Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.03.2024 04:09
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 15584576 kB
MemAvailable 30218992 kB
Buffers 20 kB
Cached 16084672 kB
SwapCached 2248 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-02 04:07:50
DTS_END                         2024-03-02 04:07:50.6000
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(68:17)
IP                              ::1/40820
TRN_ID                          179597
ATT_ID                          592
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: 9391.96 17164 939196
customer order: creation 185.30 380 18530
customer order: refuse 15.83 399 1583
order to supplier: creation 48.90 1380 4890
order to supplier: removal 3.44 85579 344
invoice (draft): creation 49.82 3545 4982
invoice (draft): removal 51.31 657 5131
invoice accept: apply 44.35 21279 4435
invoice accept: cancel 46.15 747 4615
customer reserve: creation 4156.91 210 415691
customer reserve: removal 4481.52 52 448152
realization accept: apply 88.27 214 8827
realization accept: cancel 82.66 124 8266
payment from customer: creation 63.45 117 6345
payment from customer: removal 6.04 112 604
payment to supplier: creation 52.08 144 5208
payment to supplier: removal 3.52 81 352
service: total inventory turnovers 3.91 3818 391
service: total monetary turnovers 7.28 510 728
service: aggregate perf. data 1.18 11015 118
service: refresh index statistics 0.04 212909 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-03-2024 04:09:33 to 02-03-2024 04:09:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4386
TEST_TIME 2 3320
TEST_TIME 3 4379
TEST_TIME 4 5161
TEST_TIME 5 5346
TEST_TIME 6 5633
TEST_TIME 7 5691
TEST_TIME 8 5903
TEST_TIME 9 5814
TEST_TIME 10 6230
TEST_TIME 11 6417
TEST_TIME 12 6313
TEST_TIME 13 6527
TEST_TIME 14 6768
TEST_TIME 15 6716
TEST_TIME 16 6971
TEST_TIME 17 6939
TEST_TIME 18 7190
TEST_TIME 19 7324
TEST_TIME 20 7509
TEST_TIME 21 7883
TEST_TIME 22 8135
TEST_TIME 23 8071
TEST_TIME 24 8215
TEST_TIME 25 8288
TEST_TIME 26 8558
TEST_TIME 27 8763
TEST_TIME 28 8981
TEST_TIME 29 9624
TEST_TIME 30 9650
TEST_TIME 31 9809
TEST_TIME 32 9893
TEST_TIME 33 9747
TEST_TIME 34 9590
TEST_TIME 35 9469
TEST_TIME 36 9395
TEST_TIME 37 9408
TEST_TIME 38 9432
TEST_TIME 39 9401
TEST_TIME 40 9450
TEST_TIME 41 9512
TEST_TIME 42 9472
TEST_TIME 43 9372
TEST_TIME 44 9239
TEST_TIME 45 9169
TEST_TIME 46 9203
TEST_TIME 47 9185
TEST_TIME 48 9180
TEST_TIME 49 9203
TEST_TIME 50 9348
TEST_TIME 51 9390
TEST_TIME 52 9485
TEST_TIME 53 9514
TEST_TIME 54 9409
TEST_TIME 55 9370
TEST_TIME 56 9353
TEST_TIME 57 9536
TEST_TIME 58 9581
TEST_TIME 59 9555
TEST_TIME 60 9522
TEST_TIME 61 9427
TEST_TIME 62 9316
TEST_TIME 63 9336
TEST_TIME 64 9330
TEST_TIME 65 9254
TEST_TIME 66 9193
TEST_TIME 67 9151
TEST_TIME 68 9211
TEST_TIME 69 9205
TEST_TIME 70 9204
TEST_TIME 71 9210
TEST_TIME 72 9205
TEST_TIME 73 9206
TEST_TIME 74 9271
TEST_TIME 75 9354
TEST_TIME 76 9358
TEST_TIME 77 9381
TEST_TIME 78 9491
TEST_TIME 79 9494
TEST_TIME 80 9558
TEST_TIME 81 9456
TEST_TIME 82 9377
TEST_TIME 83 9321
TEST_TIME 84 9341
TEST_TIME 85 9301
TEST_TIME 86 9248
TEST_TIME 87 9180
TEST_TIME 88 9281
TEST_TIME 89 9266
TEST_TIME 90 9269
TEST_TIME 91 9241
TEST_TIME 92 9290
TEST_TIME 93 9339
TEST_TIME 94 9388
TEST_TIME 95 9344
TEST_TIME 96 9393
TEST_TIME 97 9400
TEST_TIME 98 9431
TEST_TIME 99 9427
TEST_TIME 100 9403

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-03-2024 04:09:36 to 02-03-2024 04:09:40.

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 1319256 1319256 0 0.00 0 18972 8 0 0
doc_list_biud 1319256 1319256 0 0.00 0 27065 23 0 0
sp_add_invoice_to_stock 4516 4435 81 1.79 54 227356 21279 0 81
sp_cancel_adding_invoice 4615 4615 0 0.00 4 34438 747 0 0
sp_cancel_client_order 1583 1583 0 0.00 4 10766 399 0 0
sp_cancel_customer_reserve 448152 448152 0 0.00 0 22789 52 0 0
sp_cancel_pay_from_customer 604 604 0 0.00 2 9052 112 0 0
sp_cancel_pay_to_supplier 352 352 0 0.00 2 5771 82 0 0
sp_cancel_supplier_invoice 5133 5131 2 0.03 1 21588 658 0 2
sp_cancel_supplier_order 344 344 0 0.00 8 853707 85580 0 0
sp_cancel_write_off 8266 8266 0 0.00 1 16234 124 0 0
sp_client_order 18530 18530 0 0.00 3 15504 381 0 0
sp_customer_reserve 415691 415691 0 0.00 0 49193 210 0 0
sp_fill_shopping_cart 28398 28398 0 0.00 1 15329 40 0 0
sp_fill_shopping_cart_clo_res 415685 415685 0 0.00 0 19441 15 0 0
sp_get_clo_for_invoice 4427 4427 0 0.00 0 30764 341 0 0
sp_kill_cost_storno 13837 13837 0 0.00 0 13309 62 0 0
sp_kill_qstorno_ret_qs2qd 910045 910045 0 0.00 0 21573 28 0 0
sp_kill_qty_storno 481345 481345 0 0.00 0 27064 62 0 0
sp_lock_selected_doc 18417 18417 0 0.00 0 12414 5 0 0
sp_make_cost_storno 24807 24807 0 0.00 0 18609 66 0 0
sp_multiply_rows_for_pdistr 24807 24807 0 0.00 0 14836 37 0 0
sp_multiply_rows_for_qdistr 18530 18530 0 0.00 0 14777 197 0 0
sp_pay_from_customer 6345 6345 0 0.00 4 13494 117 0 0
sp_pay_to_supplier 5208 5208 0 0.00 4 13459 145 0 0
sp_payment_common 11553 11553 0 0.00 1 11817 28 0 0
sp_qd_handle_on_cancel_clo 1583 1583 0 0.00 0 10759 371 0 0
sp_qd_handle_on_invoice_upd_sts 9042 9042 0 0.00 0 27064 299 0 0
sp_qd_handle_on_reserve_upd_sts 8827 8827 0 0.00 0 18317 58 0 0
sp_reserve_write_off 8827 8827 0 0.00 6 18360 214 0 0
sp_supplier_invoice 4982 4982 0 0.00 6 97307 3546 0 0
sp_supplier_order 4890 4890 0 0.00 4 29269 1380 0 0
srv_aggregate_perf_data 118 118 0 0.00 1736 154415 11015 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1593 126608 37727 0 0
srv_find_qd_qs_mism 894050 894050 0 0.00 0 16001 7 0 0
srv_make_invnt_saldo 391 391 0 0.00 48 87059 3819 0 0
srv_make_money_saldo 728 728 0 0.00 0 12734 511 0 0
srv_recalc_idx_stat 4 4 0 0.00 158182 297257 212910 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4436 4436 0 0.00 0 6010 163 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 5025 94 0 0
t$perf-norm:sp_cancel_client_order 1583 1583 0 0.00 0 2824 12 0 0
t$perf-norm:sp_cancel_customer_reserve 610 610 0 0.00 0 1382 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 604 604 0 0.00 0 1385 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 352 352 0 0.00 0 778 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 359 359 0 0.00 0 2725 23 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 35737 1509 0 0
t$perf-norm:sp_cancel_write_off 916 916 0 0.00 0 601 4 0 0
t$perf-norm:sp_client_order 18530 18530 0 0.00 0 5326 15 0 0
t$perf-norm:sp_customer_reserve 933 933 0 0.00 0 1841 5 0 0
t$perf-norm:sp_pay_from_customer 6345 6345 0 0.00 0 5555 7 0 0
t$perf-norm:sp_pay_to_supplier 5208 5208 0 0.00 0 5423 11 0 0
t$perf-norm:sp_reserve_write_off 8827 8827 0 0.00 0 4306 9 0 0
t$perf-norm:sp_supplier_invoice 4982 4982 0 0.00 0 3700 16 0 0
t$perf-norm:sp_supplier_order 4890 4890 0 0.00 0 2029 15 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 689 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 278 8 0 0
t$perf-norm:srv_make_invnt_saldo 391 391 0 0.00 0 2199 25 0 0
t$perf-norm:srv_make_money_saldo 728 728 0 0.00 0 793 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 9014 8852 162 1.79 0 13468 24 0 162
v_all_customers 34274 34274 0 0.00 0 121 1 0 0
v_all_suppliers 27844 27844 0 0.00 0 25 1 0 0
v_all_wares 37060 37060 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 6710 21 0 0
v_cancel_client_order 3166 3166 0 0.00 0 5917 8 0 0
v_cancel_customer_prepayment 1208 1208 0 0.00 0 3922 14 0 0
v_cancel_customer_reserve 1220 1220 0 0.00 0 3810 10 0 0
v_cancel_payment_to_supplier 704 704 0 0.00 0 4224 8 0 0
v_cancel_supplier_invoice 722 718 4 0.55 0 3029 19 0 4
v_cancel_supplier_order 688 688 0 0.00 0 311 3 0 0
v_cancel_write_off 1832 1832 0 0.00 0 2918 15 0 0
v_max_id_clo_ord 4890 4890 0 0.00 0 610 2 0 0
v_max_id_clo_res 933 933 0 0.00 0 1979 13 0 0
v_max_id_ord_sup 4978 4978 0 0.00 0 8198 8 0 0
v_max_non_paid_invoice 1154 1154 0 0.00 0 278 3 0 0
v_max_non_paid_realizn 3099 3099 0 0.00 0 7397 6 0 0
v_min_id_clo_ord 4890 4890 0 0.00 0 10376 11 0 0
v_min_id_clo_res 933 933 0 0.00 0 7416 16 0 0
v_min_id_ord_sup 4978 4978 0 0.00 0 7954 11 0 0
v_min_non_paid_invoice 5208 5208 0 0.00 0 11796 19 0 0
v_min_non_paid_realizn 6345 6345 0 0.00 0 11797 22 0 0
v_our_firm 9278 9278 0 0.00 0 17 1 0 0
v_reserve_write_off 17654 17654 0 0.00 0 13474 10 0 0
x_lock_depdocs_on_canc_invoice 9387 9387 0 0.00 0 9854 110 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 5348 330 0 0
x_make_qstorno_1000_1200 4890 4890 0 0.00 1 29263 1293 0 0
x_make_qstorno_1200_2000 4982 4982 0 0.00 3 93264 3405 0 0
x_make_qstorno_2100_3300 415691 415691 0 0.00 0 49192 192 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-03-2024 04:09:41 to 02-03-2024 04:09:45.

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
02:07:53 1081 8192000000 8955707488 9017962496 18865024 0.229 5 3 7 0 19498800 147888 485888
02:08:56 17376 8192000000 9704916960 9999503360 787492944 8.769 100 91 182 0 817344528 7521424 22330160
02:10:16 25254 8192000000 9753069632 10059132928 835875600 9.258 100 84 168 0 866871744 11282368 19713776
02:11:48 14481 8192000000 9790013968 10105356288 862130208 9.521 100 83 166 0 898614208 17506256 18977744
02:13:05 10271 8192000000 9841362944 10168705024 894674208 9.846 100 86 172 0 953931552 40046000 19211344
02:14:24 8495 8192000000 9888769472 10227957760 930571648 10.200 100 79 158 0 1004930496 57270768 17088080
02:15:38 3217 8192000000 9924720112 10271629312 963031968 10.519 100 78 150 1 1031317536 52831280 15454288
02:16:43 2458 8192000000 9978865936 10340044800 995225392 10.832 100 76 152 0 1094081728 83478960 15377376
02:17:49 2113 8192000000 9995993840 10360422400 1024490080 11.115 100 82 163 1 1117506272 76874016 16142176
02:18:52 1663 8192000000 10011076016 10379550720 1051990016 11.380 100 87 173 0 1128297328 59108784 17198528
02:19:56 1229 8192000000 10065720480 10440753152 1066775920 11.521 100 84 169 0 1179943152 96239488 16927744
02:20:58 6456 8192000000 9966930672 10365960192 1070948016 11.561 100 33 64 1 1092382992 13782928 7652048
02:22:08 7357 8192000000 9992557808 10398806016 1080811168 11.655 100 25 49 0 1114809792 29019408 4979216
02:23:19 8557 8192000000 10001611344 10396590080 1092185904 11.763 100 47 95 0 1114453392 12291136 9976352
02:24:28 24287 8192000000 10001094736 10403852288 1093732464 11.778 100 43 84 2 1113180960 10377408 9071088
02:25:53 5864 8192000000 10012881552 10418061312 1100061248 11.838 100 46 91 0 1130311408 20185584 10064576
02:26:59 8983 8192000000 10015663808 10430824448 1096479088 11.804 100 44 88 0 1129700096 22689408 10531600
02:28:14 20520 8192000000 10003440768 10402906112 1080549200 11.653 98 45 89 0 1103085616 13660208 8876208
02:29:39 46175 8192000000 10042509680 10442260480 1076966512 11.619 98 57 114 1 1149454048 60482320 12005216
02:31:29 13677 8192000000 10059527328 10468458496 1088857360 11.732 98 49 96 0 1138094640 39259632 9977648
02:32:54 9951 8192000000 10067231104 10458427392 1088912560 11.732 99 65 130 0 1164416368 61847568 13656240
02:34:13 17780 8192000000 10098564656 10502025216 1091566400 11.758 100 69 138 1 1214447248 109365984 13514864
02:35:38 9569 8192000000 10050528304 10454056960 1091955008 11.761 100 38 76 0 1159296048 59501120 7839920
02:36:53 18554 8192000000 10054446800 10471632896 1083120752 11.677 99 38 74 0 1170708176 79594480 7992944
02:38:18 26046 8192000000 10086076448 10491572224 1082813600 11.674 99 47 90 0 1187796896 95535472 9447824
02:39:48 5244 8192000000 10101355600 10495315968 1080574000 11.653 100 58 112 1 1207511776 115064800 11872976
02:40:58 15511 8192000000 10109275120 10505383936 1082670672 11.673 99 51 102 0 1204253888 110793232 10789984
02:42:21 10837 8192000000 10158064160 10549579776 1093156320 11.773 100 66 131 1 1257082352 150523984 13402048
02:43:44 7233 8192000000 10152628448 10547785728 1078763136 11.636 99 60 119 0 1252320752 161037792 12519824
02:44:53 3200 8192000000 10200758752 10586812416 1108048480 11.914 100 83 161 2 1300489520 175024432 17416608
02:45:58 2344 8192000000 10241866144 10638991360 1122775280 12.053 100 88 177 1 1337169344 194825216 19568848
02:47:03 1589 8192000000 10256015968 10663297024 1134132720 12.160 100 71 139 2 1357550112 208583760 14833632
02:48:10 5460 8192000000 10276875168 10692079616 1150710608 12.316 100 81 160 0 1372979952 205276272 16993072
02:49:22 2269 8192000000 10272626176 10674110464 1161852256 12.421 100 77 148 0 1368022752 190667408 15503088
02:50:28 20491 8192000000 10286330208 10717249536 1150854992 12.318 100 28 57 0 1390629488 232505264 7269232
02:51:55 35294 8192000000 10325050048 10768461824 1157741200 12.382 100 39 76 0 1424748832 257482800 9524832
02:53:39 16388 8192000000 10289853344 10748612608 1155220992 12.358 100 20 40 0 1408052656 247775104 5056560
02:54:57 26207 8192000000 10233578656 10737938432 1155110048 12.357 100 17 32 0 1341785056 182417488 4257520
02:57:11 37853 8192000000 10105282896 10530537472 1150607392 12.315 100 33 63 1 1209245712 51540096 7098224
02:58:52 67061 8192000000 10086212544 10547613696 1138725312 12.204 99 23 48 0 1194846752 50867456 5253984
03:01:03 105584 8192000000 10115585472 10558844928 1143197344 12.246 99 37 74 0 1206831552 55007440 8626768
03:04:06 19446 8192000000 10101413200 10558664704 1151491312 12.323 100 73 144 1 1193147376 25853152 15802912
03:05:28 51072 8192000000 10126080192 10568245248 1154208800 12.349 100 33 66 0 1224259568 62819808 7230960
03:07:37 27652 8192000000 10110295872 10582716416 1152026864 12.329 100 16 32 1 1214503824 59370592 3106368
03:09:06 43739 8192000000 10079294880 10585567232 1146101760 12.273 99 12 24 0 1190087360 41566176 2419424
03:10:52 52747 8192000000 10101841984 10553921536 1140775632 12.223 98 23 46 0 1189029648 43739472 4514544
03:12:46 24950 8192000000 10067246672 10564395008 1142121904 12.235 99 24 48 1 1173851984 27166448 4563632
03:14:12 21583 8192000000 10061242320 10499256320 1109652640 11.929 96 19 36 0 1137913792 24640640 3620512
03:15:37 33640 8192000000 10138770448 10580594688 1146373712 12.275 100 25 50 0 1218968112 67231232 5363168
03:17:17 50536 8192000000 10073225856 10549141504 1058746208 11.444 93 15 30 0 1165372816 103216976 3409632
03:19:08 50389 8192000000 10078903264 10563121152 1088248800 11.726 97 24 47 1 1201544224 108652800 4642624
03:21:03 15204 8192000000 10057979232 10467405824 1095219888 11.792 98 59 115 0 1129907584 22745376 11942320
03:22:21 32647 8192000000 10108486784 10541457408 1074008112 11.590 96 41 81 0 1183445152 101520336 7916704
03:23:54 60829 8192000000 10063638448 10581499904 1074821648 11.598 97 17 34 0 1166335024 87712624 3800752
03:25:55 126608 8192000000 10026919840 10495959040 1061788272 11.474 96 6 13 0 1110403968 47535616 1080080
03:29:33 42037 8192000000 10055933344 10518863872 1104038640 11.876 100 29 58 0 1182684576 72346288 6299648
03:31:27 51947 8192000000 10021121312 10463920128 1098827120 11.827 99 13 26 0 1123536384 21508528 3200736
03:33:24 49200 8192000000 10083718384 10536820736 1107304240 11.907 99 14 28 0 1183240464 72876528 3059696
03:35:18 50727 8192000000 10036849056 10497888256 1104654400 11.882 99 11 23 0 1153709888 46252736 2802752
03:37:09 57787 8192000000 10056527824 10519093248 1110128192 11.934 99 22 42 1 1140483472 25834928 4520352
03:39:07 20697 8192000000 10077955712 10514370560 1113080320 11.962 99 33 66 0 1174341488 54144880 7116288
03:40:31 39179 8192000000 10138605744 10564419584 1140610016 12.221 100 30 58 0 1216342032 70043888 5688128
03:42:10 34239 8192000000 10101710752 10544742400 1145872944 12.271 100 20 41 0 1207261952 57220576 4168432
03:43:50 45628 8192000000 10107390336 10544222208 1128868784 12.111 98 28 56 0 1176726640 42255392 5602464
03:45:36 88838 8192000000 10095138352 10593398784 1109537232 11.928 97 14 28 0 1190705360 77841808 3326320
03:48:10 97975 8192000000 10070424432 10520625152 1135964176 12.178 99 19 38 0 1159319600 19412432 3942992
03:50:51 62645 8192000000 10108124768 10578243584 1148304352 12.294 99 25 50 0 1218925152 65539968 5080832
03:52:56 44429 8192000000 10104505984 10581712896 1132822672 12.148 98 8 16 0 1193657216 59046224 1788320
03:54:43 53818 8192000000 10099715152 10624708608 1157358256 12.379 100 7 14 0 1233846480 74946336 1541888
03:56:44 27389 8192000000 10080572704 10518638592 1130696864 12.128 98 28 53 1 1169570176 32870944 6002368
03:58:16 36399 8192000000 10136787824 10581217280 1156738960 12.373 100 18 36 1 1209268976 48143552 4386464
04:00:08 56107 8192000000 10079461072 10554122240 1136209600 12.180 98 10 20 0 1189470240 51118832 2141808
04:02:05 47561 8192000000 10089883056 10516537344 1094007088 11.781 96 24 48 0 1138045424 38835056 5203280
04:03:55 65730 8192000000 10125724432 10605924352 1103300320 11.869 97 37 75 1 1147778992 37154224 7324448
04:06:52 79932 8192000000 9671174752 10075627520 750200416 8.389 68 19 38 0 787724128 33911104 3612608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 81 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          179825
MON$OLDEST_ACTIVE               179826
MON$OLDEST_SNAPSHOT             179826
MON$NEXT_TRANSACTION            179826
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1926688
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             711
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Mar  2 04:10:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        93950 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    179825 
    Oldest active        179826 
    Oldest snapshot        179826 
    Next transaction    179827 
    Sequence number        0 
    Next attachment ID    711 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.75, total records: 7705517 
    Average version length: 48.16, total versions: 28051, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89048 
    Data pages: 89048, average fill: 69% 
    Primary pages: 89048, secondary pages: 0, swept pages: 54539 
    Empty pages: 0, full pages: 57250 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 78 
    40 - 59% = 2672 
    60 - 79% = 86279 
    80 - 99% = 12 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23272, nodes: 7705517 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1675638, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 301 
        20 - 39% = 2102 
        40 - 59% = 3972 
        60 - 79% = 2493 
        80 - 99% = 14404 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13523, nodes: 7705517 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1498900, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1776 
        40 - 59% = 1880 
        60 - 79% = 1138 
        80 - 99% = 8727 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8329, nodes: 7705517 
    Average node length: 6.60, total dup: 5780802, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1491876, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 1119 
        40 - 59% = 1279 
        60 - 79% = 958 
        80 - 99% = 4874 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.10, total records: 2215227 
    Average version length: 58.83, total versions: 14891, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28768 
    Data pages: 28768, average fill: 71% 
    Primary pages: 28766, secondary pages: 2, swept pages: 20526 
    Empty pages: 20, full pages: 13088 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 34 
    40 - 59% = 695 
    60 - 79% = 27969 
    80 - 99% = 44 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4561, nodes: 2215227 
    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: 674471, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1026 
        40 - 59% = 779 
        60 - 79% = 774 
        80 - 99% = 1982 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2423, nodes: 2215811 
    Average node length: 4.97, total dup: 2214912, max dup: 19779 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259276, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 255 
        40 - 59% = 1394 
        60 - 79% = 526 
        80 - 99% = 245 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1786, nodes: 2215227 
    Average node length: 4.97, total dup: 2215177, max dup: 130511 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061325, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 626 
        60 - 79% = 50 
        80 - 99% = 1096 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4387, nodes: 2215227 
    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: 674471, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 710 
        40 - 59% = 625 
        60 - 79% = 874 
        80 - 99% = 2084 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.12, total records: 400 
    Average version length: 24.71, total versions: 3259, max versions: 9 
    Average fragment length: 2.00, total fragments: 15, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 68% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 6, full pages: 22 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 22 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 19.58, total records: 85540 
    Average version length: 68.28, total versions: 70282, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.49 
    Pointer pages: 7, data page slots: 4424 
    Data pages: 2096, average fill: 54% 
    Primary pages: 2095, secondary pages: 1, swept pages: 368 
    Empty pages: 372, full pages: 946 
    Fill distribution: 
     0 - 19% = 559 
    20 - 39% = 264 
    40 - 59% = 171 
    60 - 79% = 329 
    80 - 99% = 773 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1717015, depth: 3, leaf buckets: 368, nodes: 85540 
    Average node length: 13.46, total dup: 5694, max dup: 1 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.13, average data length: 7.87 
    Clustering factor: 62435, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 237 
        40 - 59% = 114 
        60 - 79% = 16 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 222, max versions: 10 
    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: 2 
    Data pages: 2, average fill: 46% 
    Primary pages: 1, secondary pages: 1, 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_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.88, total records: 1474 
    Average version length: 43.35, total versions: 1316, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.50 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 49% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 8, full pages: 14 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93324, depth: 2, leaf buckets: 4, nodes: 1474 
    Average node length: 4.23, total dup: 1376, max dup: 173 
    Average key length: 2.72, compression ratio: 6.99 
    Average prefix length: 18.35, average data length: 0.65 
    Clustering factor: 741, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.68, total records: 75 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 53% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 75 
    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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.32, total records: 801144 
    Average version length: 37.93, total versions: 10542, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8712 
    Data pages: 8712, average fill: 63% 
    Primary pages: 8711, secondary pages: 1, swept pages: 5368 
    Empty pages: 17, full pages: 3502 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 74 
    40 - 59% = 1441 
    60 - 79% = 7144 
    80 - 99% = 18 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 891, nodes: 796111 
    Average node length: 4.88, total dup: 796062, max dup: 151888 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89772, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 163 
        40 - 59% = 489 
        60 - 79% = 161 
        80 - 99% = 78 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 919, nodes: 796111 
    Average node length: 5.89, total dup: 708791, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157720, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 474 
        60 - 79% = 97 
        80 - 99% = 303 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 955, nodes: 796111 
    Average node length: 5.89, total dup: 708791, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159570, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 93 
        40 - 59% = 479 
        60 - 79% = 100 
        80 - 99% = 282 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1124, nodes: 796111 
    Average node length: 5.97, total dup: 708791, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151954, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 222 
        40 - 59% = 617 
        60 - 79% = 193 
        80 - 99% = 92 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.91, total records: 5428 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.64, total fragments: 11, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 56% 
    Primary pages: 79, secondary pages: 16, swept pages: 65 
    Empty pages: 13, full pages: 65 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5428 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.06 
    Average prefix length: 34.43, average data length: 1.54 
    Clustering factor: 5200, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5428 
    Average node length: 11.13, 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: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 82009 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 856 
    Data pages: 856, average fill: 66% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 851 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 851 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38304, depth: 2, leaf buckets: 104, nodes: 82009 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3210, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.78, total records: 175144 
    Average version length: 149.46, total versions: 1433, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 4768 
    Data pages: 4344, average fill: 83% 
    Primary pages: 4342, secondary pages: 2, swept pages: 2 
    Empty pages: 41, full pages: 4290 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4290 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.92, total records: 166302 
    Average version length: 152.44, total versions: 5723, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 6, data page slots: 5296 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4157, secondary pages: 3, swept pages: 2 
    Empty pages: 72, full pages: 4068 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4067 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.84, total records: 133691 
    Average version length: 147.90, total versions: 1806, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 4536 
    Data pages: 3352, average fill: 82% 
    Primary pages: 3350, secondary pages: 2, swept pages: 2 
    Empty pages: 62, full pages: 3268 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3268 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 148.99, total records: 150427 
    Average version length: 150.08, total versions: 2267, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4368 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3734, secondary pages: 2, swept pages: 2 
    Empty pages: 35, full pages: 3690 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3689 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 148.25, total records: 156423 
    Average version length: 150.94, total versions: 2990, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4888 
    Data pages: 3944, average fill: 82% 
    Primary pages: 3942, secondary pages: 2, swept pages: 1 
    Empty pages: 92, full pages: 3824 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3825 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 147.03, total records: 157313 
    Average version length: 152.75, total versions: 4431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 6536 
    Data pages: 4008, average fill: 81% 
    Primary pages: 4006, secondary pages: 2, swept pages: 3 
    Empty pages: 117, full pages: 3837 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 10 
    40 - 59% = 28 
    60 - 79% = 12 
    80 - 99% = 3836 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 141.63, total records: 174700 
    Average version length: 153.80, total versions: 11615, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 5536 
    Data pages: 4408, average fill: 82% 
    Primary pages: 4405, secondary pages: 3, swept pages: 3 
    Empty pages: 103, full pages: 4278 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4278 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 123.32, total records: 186978 
    Average version length: 154.81, total versions: 36253, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.75 
    Pointer pages: 8, data page slots: 6840 
    Data pages: 4664, average fill: 85% 
    Primary pages: 4662, secondary pages: 2, swept pages: 1 
    Empty pages: 55, full pages: 4592 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 4592 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.37, total records: 188268 
    Average version length: 154.08, total versions: 11735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 6272 
    Data pages: 4768, average fill: 82% 
    Primary pages: 4767, secondary pages: 1, swept pages: 14 
    Empty pages: 113, full pages: 4603 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 16 
    40 - 59% = 16 
    60 - 79% = 18 
    80 - 99% = 4602 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 137.25, total records: 192403 
    Average version length: 154.54, total versions: 18679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.36 
    Pointer pages: 7, data page slots: 5624 
    Data pages: 4856, average fill: 83% 
    Primary pages: 4854, secondary pages: 2, swept pages: 1 
    Empty pages: 112, full pages: 4710 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 17 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4710 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.48, total records: 2065743 
    Average version length: 52.86, total versions: 12942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25824 
    Data pages: 25824, average fill: 69% 
    Primary pages: 25814, secondary pages: 10, swept pages: 13836 
    Empty pages: 227, full pages: 20209 
    Fill distribution: 
     0 - 19% = 443 
    20 - 39% = 435 
    40 - 59% = 1419 
    60 - 79% = 23420 
    80 - 99% = 107 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2554, nodes: 2065743 
    Average node length: 5.45, total dup: 1926205, max dup: 1750 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179942, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 320 
        40 - 59% = 1655 
        60 - 79% = 290 
        80 - 99% = 289 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2762, nodes: 2065743 
    Average node length: 5.70, total dup: 1853061, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370000, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2513 
        60 - 79% = 217 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2091, nodes: 2065743 
    Average node length: 4.96, total dup: 2065643, max dup: 27475 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178038, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 234 
        40 - 59% = 1047 
        60 - 79% = 365 
        80 - 99% = 443 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 53.48, total records: 105869 
    Average version length: 69.15, total versions: 27685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.36 
    Pointer pages: 3, data page slots: 4312 
    Data pages: 3208, average fill: 39% 
    Primary pages: 3208, secondary pages: 0, swept pages: 875 
    Empty pages: 535, full pages: 253 
    Fill distribution: 
     0 - 19% = 844 
    20 - 39% = 621 
    40 - 59% = 975 
    60 - 79% = 695 
    80 - 99% = 73 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105242, depth: 3, leaf buckets: 219, nodes: 105869 
    Average node length: 6.58, total dup: 92156, max dup: 14 
    Average key length: 4.00, compression ratio: 10.50 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 18715, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 131 
        40 - 59% = 72 
        60 - 79% = 15 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 68.16, total records: 6868432 
    Average version length: 68.79, total versions: 92299, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 66, data page slots: 106208 
    Data pages: 106208, average fill: 69% 
    Primary pages: 106206, secondary pages: 2, swept pages: 72736 
    Empty pages: 4, full pages: 38972 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 608 
    40 - 59% = 10211 
    60 - 79% = 95162 
    80 - 99% = 143 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10686, nodes: 6868432 
    Average node length: 6.52, total dup: 5938831, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1600950, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1813 
        40 - 59% = 6141 
        60 - 79% = 2391 
        80 - 99% = 336 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8386, nodes: 6868432 
    Average node length: 5.40, total dup: 6589960, max dup: 126 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1422562, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1284 
        40 - 59% = 4596 
        60 - 79% = 1502 
        80 - 99% = 996 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8464, nodes: 6868432 
    Average node length: 5.40, total dup: 6589960, max dup: 126 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1424809, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1392 
        40 - 59% = 4550 
        60 - 79% = 1518 
        80 - 99% = 992 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.45, total records: 11836804 
    Average version length: 68.77, total versions: 99227, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.84 
    Pointer pages: 108, data page slots: 174824 
    Data pages: 174824, average fill: 72% 
    Primary pages: 174823, secondary pages: 1, swept pages: 115663 
    Empty pages: 7, full pages: 115819 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 562 
    40 - 59% = 7716 
    60 - 79% = 166010 
    80 - 99% = 491 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18387, nodes: 11835894 
    Average node length: 6.62, total dup: 10317504, max dup: 49 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2426071, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 2578 
        40 - 59% = 10876 
        60 - 79% = 4205 
        80 - 99% = 693 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 60.23, total records: 1271190 
    Average version length: 69.03, total versions: 116864, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.09 
    Pointer pages: 27, data page slots: 43088 
    Data pages: 29207, average fill: 46% 
    Primary pages: 29144, secondary pages: 63, swept pages: 16730 
    Empty pages: 4958, full pages: 11960 
    Fill distribution: 
     0 - 19% = 7687 
    20 - 39% = 4175 
    40 - 59% = 3551 
    60 - 79% = 12346 
    80 - 99% = 1448 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1893, nodes: 1199420 
    Average node length: 5.54, total dup: 1150680, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 85523, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 788 
        40 - 59% = 850 
        60 - 79% = 232 
        80 - 99% = 12 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 31.00, total records: 1787810 
    Average version length: 69.02, total versions: 182831, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.06 
    Pointer pages: 21, data page slots: 33872 
    Data pages: 28904, average fill: 44% 
    Primary pages: 28904, secondary pages: 0, swept pages: 5916 
    Empty pages: 5583, full pages: 15985 
    Fill distribution: 
     0 - 19% = 7908 
    20 - 39% = 2896 
    40 - 59% = 6558 
    60 - 79% = 10737 
    80 - 99% = 805 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1228, nodes: 838274 
    Average node length: 6.01, total dup: 769037, max dup: 66 
    Average key length: 3.05, compression ratio: 13.75 
    Average prefix length: 41.03, average data length: 0.97 
    Clustering factor: 121668, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 270 
        40 - 59% = 615 
        60 - 79% = 315 
        80 - 99% = 28 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.41, total records: 9600646 
    Average version length: 68.95, total versions: 865250, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 89, data page slots: 144888 
    Data pages: 144872, average fill: 72% 
    Primary pages: 144858, secondary pages: 14, swept pages: 19783 
    Empty pages: 206, full pages: 116342 
    Fill distribution: 
     0 - 19% = 757 
    20 - 39% = 3472 
    40 - 59% = 12972 
    60 - 79% = 119064 
    80 - 99% = 8607 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13479, nodes: 9586858 
    Average node length: 6.68, total dup: 7955753, max dup: 14 
    Average key length: 3.66, compression ratio: 11.48 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2164191, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 961 
        40 - 59% = 6223 
        60 - 79% = 5318 
        80 - 99% = 975 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21207408 
    Average version length: 82.82, total versions: 24143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320512 
    Data pages: 320512, average fill: 81% 
    Primary pages: 320507, secondary pages: 5, swept pages: 11216 
    Empty pages: 5, full pages: 320503 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 48934 
    80 - 99% = 271569 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19161, nodes: 21207408 
    Average node length: 5.72, total dup: 20725477, max dup: 151 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3295954, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 7596 
        60 - 79% = 597 
        80 - 99% = 10965 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17253, nodes: 21207408 
    Average node length: 6.31, total dup: 18637500, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 922517, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 854 
        60 - 79% = 265 
        80 - 99% = 16127 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20917, nodes: 21207408 
    Average node length: 6.35, total dup: 18556396, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3590209, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 7810 
        60 - 79% = 624 
        80 - 99% = 12478 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16253, nodes: 21207408 
    Average node length: 5.56, total dup: 21207308, max dup: 228097 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 951118, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 3134 
        60 - 79% = 368 
        80 - 99% = 12741 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.26, total records: 10011947 
    Average version length: 82.60, total versions: 838833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 106, data page slots: 172080 
    Data pages: 172032, average fill: 73% 
    Primary pages: 172008, secondary pages: 24, swept pages: 36670 
    Empty pages: 333, full pages: 127096 
    Fill distribution: 
     0 - 19% = 1176 
    20 - 39% = 4960 
    40 - 59% = 19638 
    60 - 79% = 109373 
    80 - 99% = 36885 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11378, nodes: 10011947 
    Average node length: 5.36, total dup: 9700140, max dup: 200 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2264874, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 49 
        40 - 59% = 7262 
        60 - 79% = 3872 
        80 - 99% = 192 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13673, nodes: 10011947 
    Average node length: 6.23, total dup: 8304059, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1594434, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 3509 
        40 - 59% = 4680 
        60 - 79% = 2740 
        80 - 99% = 2597 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12701, nodes: 10011947 
    Average node length: 5.97, total dup: 8704020, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2463164, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 59 
        40 - 59% = 8216 
        60 - 79% = 4178 
        80 - 99% = 245 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10326, nodes: 10011947 
    Average node length: 5.14, total dup: 10011847, max dup: 151064 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1617477, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1128 
        40 - 59% = 5216 
        60 - 79% = 1766 
        80 - 99% = 2184 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.91, total records: 11731197 
    Average version length: 82.56, total versions: 703192, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 120, data page slots: 195424 
    Data pages: 194208, average fill: 75% 
    Primary pages: 194084, secondary pages: 124, swept pages: 45943 
    Empty pages: 1909, full pages: 161199 
    Fill distribution: 
     0 - 19% = 3181 
    20 - 39% = 4812 
    40 - 59% = 12692 
    60 - 79% = 95987 
    80 - 99% = 77536 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13132, nodes: 11731197 
    Average node length: 5.31, total dup: 11620603, max dup: 639 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2463437, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 88 
        40 - 59% = 7909 
        60 - 79% = 4821 
        80 - 99% = 314 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10747, nodes: 11731197 
    Average node length: 5.51, total dup: 11220918, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 758439, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 816 
        40 - 59% = 2630 
        60 - 79% = 1855 
        80 - 99% = 5299 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15018, nodes: 11731197 
    Average node length: 6.03, total dup: 10249121, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2479929, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 111 
        40 - 59% = 9278 
        60 - 79% = 5277 
        80 - 99% = 347 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11176, nodes: 11731197 
    Average node length: 5.24, total dup: 11731097, max dup: 188758 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 745843, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 749 
        40 - 59% = 5198 
        60 - 79% = 1475 
        80 - 99% = 3665 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 76.67, total records: 10122900 
    Average version length: 82.89, total versions: 832894, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 108, data page slots: 176200 
    Data pages: 176168, average fill: 72% 
    Primary pages: 176145, secondary pages: 23, swept pages: 39627 
    Empty pages: 353, full pages: 126120 
    Fill distribution: 
     0 - 19% = 1221 
    20 - 39% = 6067 
    40 - 59% = 22490 
    60 - 79% = 111038 
    80 - 99% = 35352 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12046, nodes: 10122900 
    Average node length: 5.18, total dup: 10093906, max dup: 2492 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2074036, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1328 
        40 - 59% = 8026 
        60 - 79% = 1985 
        80 - 99% = 677 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13791, nodes: 10122900 
    Average node length: 6.25, total dup: 8395952, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1559541, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 198 
        20 - 39% = 3477 
        40 - 59% = 4661 
        60 - 79% = 2702 
        80 - 99% = 2753 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12671, nodes: 10122900 
    Average node length: 5.44, total dup: 9676528, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2211576, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1220 
        40 - 59% = 8984 
        60 - 79% = 1802 
        80 - 99% = 643 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10556, nodes: 10122900 
    Average node length: 5.16, total dup: 10122800, max dup: 152682 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1642087, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1160 
        40 - 59% = 5418 
        60 - 79% = 1738 
        80 - 99% = 2201 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 582838 
    Average version length: 68.84, total versions: 14440, 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: 5, data page slots: 8072 
    Data pages: 8072, average fill: 76% 
    Primary pages: 8072, secondary pages: 0, swept pages: 2345 
    Empty pages: 2, full pages: 7702 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 30 
    60 - 79% = 7767 
    80 - 99% = 273 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43691, depth: 3, leaf buckets: 741, nodes: 582838 
    Average node length: 5.95, total dup: 496277, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102515, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 518 
        60 - 79% = 101 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35129, depth: 3, leaf buckets: 763, nodes: 582838 
    Average node length: 6.15, total dup: 478033, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102562, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 535 
        60 - 79% = 103 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 570, nodes: 582838 
    Average node length: 4.86, total dup: 582738, max dup: 9689 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91195, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 341 
        60 - 79% = 64 
        80 - 99% = 137 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar  2 04:10:29 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7705517 28051 1 0.0000 0.0000
DOC_LIST 2215227 14891 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3259 9 800.0000 0.0000
INVNT_TURNOVER_LOG 85540 70282 1 0.0000 0.0000
MONEY_SALDO 49 222 10 400.0000 0.0000
MONEY_TURNOVER_LOG 1474 1316 1 0.0000 0.0000
PDISTR 801144 10542 2 0.0000 0.0000
PERF_SPLIT_0 175144 1433 1 0.0000 0.0000
PERF_SPLIT_1 166302 5723 1 0.0000 0.0000
PERF_SPLIT_2 133691 1806 1 0.0000 0.0000
PERF_SPLIT_3 150427 2267 1 0.0000 0.0000
PERF_SPLIT_4 156423 2990 1 0.0000 0.0000
PERF_SPLIT_5 157313 4431 1 0.0000 0.0000
PERF_SPLIT_6 174700 11615 1 0.0000 0.0000
PERF_SPLIT_7 186978 36253 1 0.0000 0.0000
PERF_SPLIT_8 188268 11735 1 0.0000 0.0000
PERF_SPLIT_9 192403 18679 1 0.0000 0.0000
PSTORNED 2065743 12942 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 105869 27685 1 0.0000 0.0000
XQD_1000_3300 6868432 92299 1 0.0000 0.0000
XQD_1200_2000 11836804 99227 1 0.0000 0.0000
XQD_2000_3300 1271190 116864 1 0.0000 0.0000
XQD_2100_3300 1787810 182831 1 0.0000 0.0000
XQD_3300_3400 9600646 865250 1 0.0000 0.0000
XQS_1000_1200 21207408 24143 1 0.0000 0.0000
XQS_1000_3300 10011947 838833 1 0.0000 0.0000
XQS_1200_2000 11731197 703192 1 0.0000 0.0000
XQS_2100_3300 10122900 832894 1 0.0000 0.0000
XQS_3300_3400 582838 14440 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

--- start of diff output ---
:37: 
:38: mscs-test-161.budzdorov.ru    Sat Mar  2 04:08:37 2024
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Sat Mar  2 04:08:38 2024
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:44: 
--- end of diff output ---

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

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