Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.04.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 15514260 kB
MemAvailable 30056816 kB
Buffers 20 kB
Cached 16139488 kB
SwapCached 2508 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-04-09 04:07:49
DTS_END                         2024-04-09 04:07:49.2650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(526:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/59676
TRN_ID                          175987
ATT_ID                          599
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: 9131.20 21695 913120
customer order: creation 180.70 406 18070
customer order: refuse 15.13 381 1513
order to supplier: creation 48.12 1330 4812
order to supplier: removal 3.57 81913 357
invoice (draft): creation 47.68 3269 4768
invoice (draft): removal 46.98 630 4698
invoice accept: apply 43.74 21743 4374
invoice accept: cancel 42.61 786 4261
customer reserve: creation 4243.40 208 424340
customer reserve: removal 4162.11 57 416211
realization accept: apply 87.38 194 8738
realization accept: cancel 76.01 131 7601
payment from customer: creation 61.65 153 6165
payment from customer: removal 5.84 94 584
payment to supplier: creation 51.78 164 5178
payment to supplier: removal 3.37 77 337
service: total inventory turnovers 3.87 4301 387
service: total monetary turnovers 6.31 515 631
service: aggregate perf. data 0.92 15220 92
service: refresh index statistics 0.03 302324 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1683
TEST_TIME 2 2382
TEST_TIME 3 3250
TEST_TIME 4 4328
TEST_TIME 5 3827
TEST_TIME 6 3696
TEST_TIME 7 4042
TEST_TIME 8 4884
TEST_TIME 9 5150
TEST_TIME 10 5476
TEST_TIME 11 6089
TEST_TIME 12 6306
TEST_TIME 13 6548
TEST_TIME 14 6610
TEST_TIME 15 6912
TEST_TIME 16 7255
TEST_TIME 17 7457
TEST_TIME 18 7344
TEST_TIME 19 7359
TEST_TIME 20 7584
TEST_TIME 21 7721
TEST_TIME 22 7732
TEST_TIME 23 8405
TEST_TIME 24 9217
TEST_TIME 25 9444
TEST_TIME 26 10029
TEST_TIME 27 9812
TEST_TIME 28 9859
TEST_TIME 29 9585
TEST_TIME 30 9480
TEST_TIME 31 9576
TEST_TIME 32 9528
TEST_TIME 33 9404
TEST_TIME 34 9306
TEST_TIME 35 9316
TEST_TIME 36 9220
TEST_TIME 37 9067
TEST_TIME 38 9070
TEST_TIME 39 9050
TEST_TIME 40 8960
TEST_TIME 41 8853
TEST_TIME 42 8792
TEST_TIME 43 8744
TEST_TIME 44 8733
TEST_TIME 45 8991
TEST_TIME 46 8912
TEST_TIME 47 9013
TEST_TIME 48 8934
TEST_TIME 49 9099
TEST_TIME 50 9078
TEST_TIME 51 9290
TEST_TIME 52 9309
TEST_TIME 53 9429
TEST_TIME 54 9392
TEST_TIME 55 9407
TEST_TIME 56 9461
TEST_TIME 57 9483
TEST_TIME 58 9377
TEST_TIME 59 9314
TEST_TIME 60 9226
TEST_TIME 61 9207
TEST_TIME 62 9197
TEST_TIME 63 9120
TEST_TIME 64 9046
TEST_TIME 65 8956
TEST_TIME 66 8971
TEST_TIME 67 8993
TEST_TIME 68 8955
TEST_TIME 69 8954
TEST_TIME 70 9000
TEST_TIME 71 8982
TEST_TIME 72 9034
TEST_TIME 73 9044
TEST_TIME 74 9092
TEST_TIME 75 9101
TEST_TIME 76 9116
TEST_TIME 77 9145
TEST_TIME 78 9159
TEST_TIME 79 9142
TEST_TIME 80 9063
TEST_TIME 81 9040
TEST_TIME 82 9052
TEST_TIME 83 9024
TEST_TIME 84 8963
TEST_TIME 85 8971
TEST_TIME 86 9008
TEST_TIME 87 9007
TEST_TIME 88 9046
TEST_TIME 89 9027
TEST_TIME 90 9102
TEST_TIME 91 9095
TEST_TIME 92 9146
TEST_TIME 93 9129
TEST_TIME 94 9108
TEST_TIME 95 9119
TEST_TIME 96 9182
TEST_TIME 97 9219
TEST_TIME 98 9186
TEST_TIME 99 9147
TEST_TIME 100 9136

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-04-2024 04:09:37 to 09-04-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 1298966 1298966 0 0.00 0 22048 8 0 0
doc_list_biud 1298966 1298966 0 0.00 0 31738 23 0 0
sp_add_invoice_to_stock 4474 4374 100 2.23 33 225338 21744 0 100
sp_cancel_adding_invoice 4261 4261 0 0.00 4 61236 787 0 0
sp_cancel_client_order 1513 1513 0 0.00 4 14778 381 0 0
sp_cancel_customer_reserve 416211 416211 0 0.00 0 26276 57 0 0
sp_cancel_pay_from_customer 584 584 0 0.00 2 10633 94 0 0
sp_cancel_pay_to_supplier 337 337 0 0.00 3 4158 77 0 0
sp_cancel_supplier_invoice 4704 4698 6 0.12 1 14706 631 0 6
sp_cancel_supplier_order 357 357 0 0.00 8 889690 81913 0 0
sp_cancel_write_off 7601 7601 0 0.00 1 11827 131 0 0
sp_client_order 18070 18070 0 0.00 3 23798 406 0 0
sp_customer_reserve 424340 424340 0 0.00 0 45484 208 0 0
sp_fill_shopping_cart 27636 27636 0 0.00 1 21052 40 0 0
sp_fill_shopping_cart_clo_res 424330 424330 0 0.00 0 18196 17 0 0
sp_get_clo_for_invoice 4364 4364 0 0.00 0 43671 361 0 0
sp_kill_cost_storno 12783 12783 0 0.00 0 10623 62 0 0
sp_kill_qstorno_ret_qs2qd 845078 845078 0 0.00 0 26194 31 0 0
sp_kill_qty_storno 447743 447743 0 0.00 0 31738 66 0 0
sp_lock_selected_doc 18069 18069 0 0.00 0 7906 5 0 0
sp_make_cost_storno 24445 24445 0 0.00 0 22037 69 0 0
sp_multiply_rows_for_pdistr 24445 24445 0 0.00 0 10499 35 0 0
sp_multiply_rows_for_qdistr 18070 18070 0 0.00 0 21542 202 0 0
sp_pay_from_customer 6165 6165 0 0.00 4 19077 154 0 0
sp_pay_to_supplier 5178 5178 0 0.00 4 17808 165 0 0
sp_payment_common 11343 11343 0 0.00 1 10630 35 0 0
sp_qd_handle_on_cancel_clo 1513 1513 0 0.00 0 14771 354 0 0
sp_qd_handle_on_invoice_upd_sts 8625 8625 0 0.00 0 31737 281 0 0
sp_qd_handle_on_reserve_upd_sts 8738 8738 0 0.00 0 12704 57 0 0
sp_reserve_write_off 8738 8738 0 0.00 6 20811 194 0 0
sp_supplier_invoice 4768 4768 0 0.00 6 67911 3269 0 0
sp_supplier_order 4812 4812 0 0.00 5 50339 1331 0 0
srv_aggregate_perf_data 92 92 0 0.00 1465 250511 15220 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2093 136327 41855 0 0
srv_find_qd_qs_mism 867231 867231 0 0.00 0 16136 7 0 0
srv_make_invnt_saldo 387 387 0 0.00 36 115126 4302 0 0
srv_make_money_saldo 631 631 0 0.00 1 15475 516 0 0
srv_recalc_idx_stat 3 3 0 0.00 146019 395317 302324 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4374 4374 0 0.00 0 11725 170 0 0
t$perf-norm:sp_cancel_adding_invoice 346 346 0 0.00 0 3243 104 0 0
t$perf-norm:sp_cancel_client_order 1513 1513 0 0.00 0 10650 20 0 0
t$perf-norm:sp_cancel_customer_reserve 610 610 0 0.00 0 787 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 584 584 0 0.00 0 5075 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 337 337 0 0.00 0 620 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 569 12 0 0
t$perf-norm:sp_cancel_supplier_order 357 357 0 0.00 0 25770 1665 0 0
t$perf-norm:sp_cancel_write_off 870 870 0 0.00 0 1034 4 0 0
t$perf-norm:sp_client_order 18070 18070 0 0.00 0 9575 17 0 0
t$perf-norm:sp_customer_reserve 857 857 0 0.00 0 1803 7 0 0
t$perf-norm:sp_pay_from_customer 6165 6165 0 0.00 0 6157 10 0 0
t$perf-norm:sp_pay_to_supplier 5178 5178 0 0.00 0 8368 11 0 0
t$perf-norm:sp_reserve_write_off 8738 8738 0 0.00 0 3211 9 0 0
t$perf-norm:sp_supplier_invoice 4768 4768 0 0.00 0 5203 17 0 0
t$perf-norm:sp_supplier_order 4812 4812 0 0.00 0 4273 14 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 296 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 147 3 0 0
t$perf-norm:srv_make_invnt_saldo 387 387 0 0.00 0 1674 17 0 0
t$perf-norm:srv_make_money_saldo 631 631 0 0.00 0 4654 13 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 338 116 0 0
v_add_invoice_to_stock 8924 8724 200 2.24 0 7438 19 0 200
v_all_customers 33410 33410 0 0.00 0 24 1 0 0
v_all_suppliers 27228 27228 0 0.00 0 20 1 0 0
v_all_wares 36136 36136 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 692 692 0 0.00 0 991 8 0 0
v_cancel_client_order 3026 3026 0 0.00 0 2330 6 0 0
v_cancel_customer_prepayment 1168 1168 0 0.00 0 1525 5 0 0
v_cancel_customer_reserve 1220 1220 0 0.00 0 5111 8 0 0
v_cancel_payment_to_supplier 674 674 0 0.00 0 2390 8 0 0
v_cancel_supplier_invoice 720 708 12 1.66 0 1764 16 0 12
v_cancel_supplier_order 714 714 0 0.00 0 1783 7 0 0
v_cancel_write_off 1740 1740 0 0.00 0 7663 26 0 0
v_max_id_clo_ord 4810 4810 0 0.00 0 392 1 0 0
v_max_id_clo_res 857 857 0 0.00 0 2722 18 0 0
v_max_id_ord_sup 4756 4756 0 0.00 0 4761 5 0 0
v_max_non_paid_invoice 1130 1130 0 0.00 0 130 2 0 0
v_max_non_paid_realizn 3007 3007 0 0.00 0 10610 8 0 0
v_min_id_clo_ord 4810 4810 0 0.00 0 8180 12 0 0
v_min_id_clo_res 857 857 0 0.00 0 7525 20 0 0
v_min_id_ord_sup 4756 4756 0 0.00 0 7063 6 0 0
v_min_non_paid_invoice 5178 5178 0 0.00 0 10463 25 0 0
v_min_non_paid_realizn 6165 6165 0 0.00 0 10476 29 0 0
v_our_firm 9042 9042 0 0.00 0 16 1 0 0
v_reserve_write_off 17472 17472 0 0.00 0 5959 8 0 0
x_lock_depdocs_on_canc_invoice 8605 8605 0 0.00 0 10190 109 0 0
x_lock_depdocs_on_canc_sup_ord 357 357 0 0.00 0 4480 317 0 0
x_make_qstorno_1000_1200 4812 4812 0 0.00 1 50327 1254 0 0
x_make_qstorno_1200_2000 4768 4768 0 0.00 2 67671 3118 0 0
x_make_qstorno_2100_3300 424340 424340 0 0.00 0 45483 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-04-2024 04:09:41 to 09-04-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 2 8192000000 8799831536 8811565056 5452432 0.066 3 1 2 0 5553600 65392 35776
02:08:53 42554 8192000000 9721449712 10022854656 791501984 8.810 100 90 180 0 819724800 7235680 20987136
02:10:41 24119 8192000000 9756597200 10063290368 828366784 9.183 100 91 182 0 861647760 12505088 20775888
02:12:10 12762 8192000000 9778304288 10092941312 846299792 9.363 100 88 176 0 888834000 23139152 19395056
02:13:31 8528 8192000000 9836465264 10166435840 884858736 9.748 100 76 152 0 945364544 43512816 16992992
02:14:48 6475 8192000000 9888984544 10232770560 926246048 10.158 100 74 148 1 1002617936 61468176 14903712
02:16:00 3533 8192000000 9934183856 10285518848 964027808 10.528 100 77 154 1 1043217456 63929696 15259952
02:17:06 2109 8192000000 9975818768 10338705408 997341312 10.853 100 75 149 1 1086042432 74538464 14162656
02:18:11 1807 8192000000 9999040192 10369011712 1028630464 11.155 100 83 166 1 1114663520 70501104 15531952
02:19:16 1074 8192000000 10021951056 10397458432 1050579776 11.366 100 74 148 0 1127290256 61947360 14763120
02:20:18 2104 8192000000 10013123344 10393862144 1057687344 11.434 100 56 112 0 1126394176 57736736 10970096
02:21:21 9257 8192000000 10006600240 10410217472 1062741168 11.483 100 42 82 1 1135362736 65123056 7498512
02:22:36 2490 8192000000 10001470368 10405416960 1072786832 11.579 100 34 68 1 1118858784 39498640 6573312
02:23:39 5442 8192000000 9984925136 10382352384 1073340144 11.584 100 20 38 2 1094871072 17914944 3615984
02:24:47 60753 8192000000 10011459840 10403909632 1083521056 11.681 100 51 92 2 1107441584 14187280 9733248
02:26:48 5824 8192000000 10002921056 10403127296 1086715168 11.711 100 24 42 3 1104080000 12324768 5040064
02:28:04 25985 8192000000 10012262448 10417098752 1087889824 11.723 100 38 74 0 1118055216 22830816 7334576
02:29:50 14923 8192000000 10034726128 10438856704 1099118848 11.829 100 38 76 0 1132933312 26177216 7637248
02:31:08 23687 8192000000 10063651344 10476339200 1099676160 11.835 99 30 60 0 1174683088 67859552 7147376
02:32:39 35340 8192000000 10083944848 10491658240 1088900064 11.732 98 33 66 0 1180551856 84655168 6996624
02:34:25 16469 8192000000 10109382080 10511896576 1077220448 11.621 97 37 73 0 1198364688 114347408 6796832
02:35:49 17989 8192000000 10104181040 10504187904 1085323648 11.698 100 43 85 1 1196823376 102694176 8805552
02:37:13 22914 8192000000 10111653920 10517524480 1069694208 11.549 99 48 93 0 1202639936 123727008 9218720
02:38:43 6995 8192000000 10094217760 10492321792 1063978464 11.495 98 52 100 1 1190796016 116799600 10017952
02:39:53 9051 8192000000 10118943712 10515640320 1068262592 11.535 98 53 106 1 1216659952 136782464 11614896
02:41:10 2724 8192000000 10120039184 10502250496 1053677376 11.396 98 70 138 0 1208653824 140553872 14422576
02:42:17 5759 8192000000 10175403152 10578804736 1069055216 11.543 100 61 121 0 1280720896 197630176 14035504
02:43:34 14380 8192000000 10160426336 10563829760 1070139936 11.553 98 57 111 1 1263486864 181361568 11985360
02:44:53 15147 8192000000 10172568624 10571862016 1098597280 11.824 100 40 79 0 1266779776 159083568 9098928
02:46:11 2092 8192000000 10255786112 10654273536 1120662192 12.033 100 73 146 3 1355977984 219690816 15624976
02:47:17 4773 8192000000 10311300144 10707238912 1134857344 12.167 100 79 156 0 1408515248 257249632 16408272
02:48:26 16406 8192000000 10330651760 10762317824 1141087616 12.226 100 34 67 1 1442971632 294312880 7571136
02:49:49 8499 8192000000 10356399856 10779934720 1139495744 12.211 100 49 94 1 1464054176 314255440 10302992
02:51:05 7461 8192000000 10257123520 10699812864 1124951792 12.074 100 29 57 0 1368990416 237636176 6402448
02:52:17 26787 8192000000 10175507888 10630750208 1110830496 11.940 99 15 30 0 1283865520 169703424 3331600
02:53:55 62821 8192000000 10090163376 10511249408 1131485648 12.135 100 47 89 1 1186953616 45655072 9812896
02:56:02 33282 8192000000 10069984528 10523205632 1134983888 12.168 100 27 54 0 1179814480 39656928 5173664
02:57:38 14482 8192000000 10116594640 10544472064 1137900176 12.196 100 63 127 0 1220972304 68357904 14714224
02:58:59 42440 8192000000 10065695456 10521137152 1132604416 12.146 99 21 37 1 1176834688 40522688 3707584
03:00:45 43822 8192000000 10077904336 10526486528 1142999728 12.244 100 12 23 0 1181458992 36109472 2349792
03:02:31 47971 8192000000 10067701280 10551767040 1145657040 12.269 100 8 17 0 1187362752 39992160 1713552
03:04:22 92662 8192000000 10047657680 10499698688 1133376752 12.153 99 29 58 1 1166081072 26598848 6105472
03:07:21 53168 8192000000 10083269808 10539106304 1150667856 12.316 100 19 33 0 1192424944 38220160 3536928
03:09:15 42380 8192000000 10176211680 10632863744 1151887664 12.327 99 31 61 0 1276769776 117866512 7015600
03:11:08 107904 8192000000 10083786112 10640498688 1142202672 12.236 99 19 38 0 1278030608 131065760 4762176
03:14:00 61587 8192000000 10077755360 10539360256 1123081520 12.056 97 24 48 0 1177753232 49706160 4965552
03:16:11 77633 8192000000 10087412560 10519306240 1142818928 12.242 99 17 34 0 1215583424 69157840 3606656
03:18:29 94545 8192000000 10112644096 10577289216 1145300944 12.265 99 15 32 0 1203843040 55595264 2946832
03:21:04 44923 8192000000 10055438112 10500628480 1096333056 11.803 95 19 38 0 1127421088 26767872 4320160
03:22:51 52708 8192000000 10057900432 10544521216 1068738624 11.540 95 38 77 0 1145104464 68963712 7402128
03:24:49 136327 8192000000 10009391936 10431774720 997889536 10.858 92 29 58 0 1040278496 36557856 5831104
03:28:07 29600 8192000000 10042713936 10447716352 1057892480 11.436 98 50 100 0 1109659984 42061232 9706272
03:29:43 49650 8192000000 10015199472 10445631488 1089290560 11.736 100 9 19 0 1121751392 30755248 1705584
03:31:34 93183 8192000000 10031289728 10474536960 1046324560 11.325 96 15 30 0 1111333680 61769104 3240016
03:34:19 44726 8192000000 10001520176 10431614976 1068496256 11.538 98 8 16 1 1111897904 42007040 1394608
03:36:04 36983 8192000000 10037944320 10459426816 1069255008 11.545 98 36 71 0 1104349888 27897104 7197776
03:37:49 38186 8192000000 10039648528 10465677312 1094636624 11.787 99 25 46 0 1131811488 32659776 4515088
03:39:30 51428 8192000000 10042276448 10514141184 1102594848 11.862 100 19 37 0 1150312048 44549360 3167840
03:41:28 59535 8192000000 10045767824 10523324416 1097262496 11.812 99 23 46 0 1174187728 72541504 4383728
03:43:29 62708 8192000000 10072477936 10514518016 1114277200 11.973 100 18 36 0 1170783776 52757504 3749072
03:45:32 23249 8192000000 10043048400 10466308096 1090624976 11.749 98 36 70 0 1127749184 30336384 6787824
03:47:01 79681 8192000000 10107583088 10526343168 1114882416 11.979 99 48 95 0 1163987856 39567008 9538432
03:49:29 49235 8192000000 10070338512 10534055936 1134070528 12.160 100 21 42 0 1188876400 51147696 3658176
03:51:19 67375 8192000000 10086961888 10574241792 1146348112 12.275 100 13 26 0 1212143440 63474832 2320496
03:53:28 42316 8192000000 10074413248 10494701568 1114750432 11.977 97 29 58 0 1139007472 18275168 5981872
03:55:10 57135 8192000000 10082121760 10543726592 1137260128 12.190 100 21 42 0 1182833104 41144752 4428224
03:57:14 53094 8192000000 10085535872 10554208256 1131949184 12.140 99 23 47 0 1194770384 57968736 4852464
03:59:25 69319 8192000000 10062920912 10494386176 1096061728 11.800 96 17 34 1 1138421648 38229248 4130672
04:01:36 17371 8192000000 10092133328 10512277504 1095119456 11.791 97 38 75 0 1159363728 57023536 7220736
04:02:55 17763 8192000000 10105186992 10519404544 1087782656 11.722 98 55 109 0 1161294640 63188784 10323200
04:04:16 36709 8192000000 10064810032 10513387520 1102286224 11.859 99 22 44 0 1156952544 50687680 3978640
04:05:53 78547 8192000000 10044004032 10467581952 1047832640 11.340 95 25 50 0 1077356720 24311888 5212192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-04-2024 04:10:02 to 09-04-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          175486
MON$OLDEST_ACTIVE               176837
MON$OLDEST_SNAPSHOT             176837
MON$NEXT_TRANSACTION            176837
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                       1911584
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             701
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Tue Apr  9 04:10:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        92880 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175486 
    Oldest active        176837 
    Oldest snapshot        176837 
    Next transaction    176838 
    Sequence number        0 
    Next attachment ID    701 
    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.64, total records: 7780048 
    Average version length: 48.15, total versions: 50256, 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: 89432 
    Data pages: 89432, average fill: 69% 
    Primary pages: 89431, secondary pages: 1, swept pages: 47416 
    Empty pages: 7, full pages: 63685 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 49 
    40 - 59% = 1594 
    60 - 79% = 87748 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23435, nodes: 7780048 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1683369, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 363 
        20 - 39% = 1788 
        40 - 59% = 4236 
        60 - 79% = 2399 
        80 - 99% = 14649 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13574, nodes: 7780048 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1508053, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1570 
        40 - 59% = 2077 
        60 - 79% = 1080 
        80 - 99% = 8847 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8392, nodes: 7780048 
    Average node length: 6.63, total dup: 5806274, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1500882, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 951 
        40 - 59% = 1424 
        60 - 79% = 924 
        80 - 99% = 4962 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.88, total records: 2265103 
    Average version length: 58.87, total versions: 26739, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 29056 
    Data pages: 29056, average fill: 72% 
    Primary pages: 29055, secondary pages: 1, swept pages: 15325 
    Empty pages: 0, full pages: 15576 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 26 
    40 - 59% = 437 
    60 - 79% = 28535 
    80 - 99% = 54 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4600, nodes: 2265103 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 678483, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 918 
        40 - 59% = 881 
        60 - 79% = 720 
        80 - 99% = 2080 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2418, nodes: 2265883 
    Average node length: 4.97, total dup: 2264985, max dup: 19022 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1268148, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 178 
        40 - 59% = 1394 
        60 - 79% = 559 
        80 - 99% = 282 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1814, nodes: 2265103 
    Average node length: 4.97, total dup: 2265053, max dup: 130439 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1078685, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 659 
        60 - 79% = 38 
        80 - 99% = 1108 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4397, nodes: 2265103 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 678483, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 548 
        40 - 59% = 678 
        60 - 79% = 845 
        80 - 99% = 2212 
 
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.39, total records: 400 
    Average version length: 28.07, total versions: 1457, max versions: 4 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 54% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 8, full pages: 13 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 20.96, total records: 70553 
    Average version length: 68.28, total versions: 56338, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.20 
    Pointer pages: 7, data page slots: 2008 
    Data pages: 1400, average fill: 67% 
    Primary pages: 1399, secondary pages: 1, swept pages: 3 
    Empty pages: 122, full pages: 839 
    Fill distribution: 
     0 - 19% = 228 
    20 - 39% = 111 
    40 - 59% = 116 
    60 - 79% = 211 
    80 - 99% = 734 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703944, depth: 3, leaf buckets: 241, nodes: 70553 
    Average node length: 13.19, total dup: 5012, max dup: 1 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 51635, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 80 
        40 - 59% = 125 
        60 - 79% = 27 
        80 - 99% = 9 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 204, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 85% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.09, total records: 814 
    Average version length: 43.82, total versions: 722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.43 
    Pointer pages: 1, data page slots: 32 
    Data pages: 24, average fill: 36% 
    Primary pages: 23, secondary pages: 1, swept pages: 4 
    Empty pages: 9, full pages: 6 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92353, depth: 2, leaf buckets: 2, nodes: 814 
    Average node length: 4.52, total dup: 720, max dup: 116 
    Average key length: 3.24, compression ratio: 5.86 
    Average prefix length: 17.87, average data length: 1.13 
    Clustering factor: 415, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.54, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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.07, total records: 772539 
    Average version length: 37.96, total versions: 13635, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8344 
    Data pages: 8344, average fill: 63% 
    Primary pages: 8343, secondary pages: 1, swept pages: 4190 
    Empty pages: 17, full pages: 3751 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 60 
    40 - 59% = 1231 
    60 - 79% = 7002 
    80 - 99% = 16 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 855, nodes: 764911 
    Average node length: 4.87, total dup: 764862, max dup: 138975 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88381, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 157 
        40 - 59% = 468 
        60 - 79% = 155 
        80 - 99% = 75 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 895, nodes: 764911 
    Average node length: 5.88, total dup: 681258, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 153203, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 58 
        40 - 59% = 442 
        60 - 79% = 120 
        80 - 99% = 275 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 930, nodes: 764911 
    Average node length: 5.88, total dup: 681258, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155141, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 111 
        40 - 59% = 442 
        60 - 79% = 120 
        80 - 99% = 257 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1106, nodes: 764911 
    Average node length: 5.96, total dup: 681258, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 148263, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 260 
        40 - 59% = 575 
        60 - 79% = 193 
        80 - 99% = 76 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5448 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.03, total fragments: 34, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 86, average fill: 62% 
    Primary pages: 75, secondary pages: 11, swept pages: 64 
    Empty pages: 4, full pages: 62 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5448 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.39, average data length: 1.54 
    Clustering factor: 5156, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5448 
    Average node length: 11.14, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 80629 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 837 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 837 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38145, depth: 2, leaf buckets: 102, nodes: 80629 
    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: 3229, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
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.21, 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.21 
    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: 133.71, total records: 194017 
    Average version length: 153.22, total versions: 23837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.68 
    Pointer pages: 7, data page slots: 5376 
    Data pages: 4784, average fill: 85% 
    Primary pages: 4783, secondary pages: 1, swept pages: 2 
    Empty pages: 12, full pages: 4769 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4769 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 123.74, total records: 190162 
    Average version length: 153.74, total versions: 36665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.71 
    Pointer pages: 5, data page slots: 5632 
    Data pages: 4696, average fill: 86% 
    Primary pages: 4694, secondary pages: 2, swept pages: 2 
    Empty pages: 14, full pages: 4679 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 4681 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 139.47, total records: 182460 
    Average version length: 151.42, total versions: 15075, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.16 
    Pointer pages: 9, data page slots: 5184 
    Data pages: 4496, average fill: 85% 
    Primary pages: 4494, secondary pages: 2, swept pages: 4 
    Empty pages: 12, full pages: 4480 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4482 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 120.88, total records: 203213 
    Average version length: 153.75, total versions: 43108, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.03 
    Pointer pages: 8, data page slots: 5336 
    Data pages: 5008, average fill: 86% 
    Primary pages: 5006, secondary pages: 2, swept pages: 6 
    Empty pages: 8, full pages: 4997 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 4994 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 130.61, total records: 199490 
    Average version length: 153.39, total versions: 28850, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 7, data page slots: 5352 
    Data pages: 4960, average fill: 85% 
    Primary pages: 4958, secondary pages: 2, swept pages: 3 
    Empty pages: 48, full pages: 4904 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4904 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 137.03, total records: 179416 
    Average version length: 152.19, total versions: 17880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.38 
    Pointer pages: 7, data page slots: 6888 
    Data pages: 4464, average fill: 84% 
    Primary pages: 4462, secondary pages: 2, swept pages: 1 
    Empty pages: 42, full pages: 4400 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4402 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 108.61, total records: 212733 
    Average version length: 154.37, total versions: 63284, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.62 
    Pointer pages: 7, data page slots: 6080 
    Data pages: 5288, average fill: 87% 
    Primary pages: 5285, secondary pages: 3, swept pages: 3 
    Empty pages: 39, full pages: 5237 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 5236 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 135.09, total records: 168531 
    Average version length: 153.16, total versions: 18459, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.55 
    Pointer pages: 5, data page slots: 4776 
    Data pages: 4176, average fill: 84% 
    Primary pages: 4173, secondary pages: 3, swept pages: 1 
    Empty pages: 20, full pages: 4107 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 4 
    40 - 59% = 39 
    60 - 79% = 5 
    80 - 99% = 4107 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 134.41, total records: 163703 
    Average version length: 152.31, total versions: 18734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.62 
    Pointer pages: 6, data page slots: 4848 
    Data pages: 4032, average fill: 85% 
    Primary pages: 4031, secondary pages: 1, swept pages: 3 
    Empty pages: 15, full pages: 4008 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4009 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 137.41, total records: 167043 
    Average version length: 153.08, total versions: 15718, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 7, data page slots: 4424 
    Data pages: 4136, average fill: 84% 
    Primary pages: 4135, secondary pages: 1, swept pages: 4 
    Empty pages: 30, full pages: 4093 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4092 
 
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.21, total records: 2108718 
    Average version length: 52.96, total versions: 26116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25744 
    Data pages: 25744, average fill: 70% 
    Primary pages: 25728, secondary pages: 16, swept pages: 11611 
    Empty pages: 113, full pages: 22163 
    Fill distribution: 
     0 - 19% = 223 
    20 - 39% = 218 
    40 - 59% = 780 
    60 - 79% = 24262 
    80 - 99% = 261 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2587, nodes: 2108718 
    Average node length: 5.44, total dup: 1967657, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182663, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 288 
        40 - 59% = 1692 
        60 - 79% = 308 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2758, nodes: 2108718 
    Average node length: 5.69, total dup: 1892623, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377008, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2407 
        60 - 79% = 317 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2079, nodes: 2108718 
    Average node length: 4.96, total dup: 2108618, max dup: 27994 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 180604, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 178 
        40 - 59% = 1039 
        60 - 79% = 375 
        80 - 99% = 485 
 
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: 48.60, total records: 113222 
    Average version length: 69.19, total versions: 38793, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.59 
    Pointer pages: 3, data page slots: 4320 
    Data pages: 3144, average fill: 44% 
    Primary pages: 3144, secondary pages: 0, swept pages: 529 
    Empty pages: 518, full pages: 652 
    Fill distribution: 
     0 - 19% = 768 
    20 - 39% = 564 
    40 - 59% = 795 
    60 - 79% = 750 
    80 - 99% = 267 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104399, depth: 3, leaf buckets: 212, nodes: 113222 
    Average node length: 6.55, total dup: 98514, max dup: 14 
    Average key length: 4.00, compression ratio: 10.51 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 20130, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 94 
        40 - 59% = 91 
        60 - 79% = 26 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.39, total records: 6600435 
    Average version length: 68.80, total versions: 172572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 64, data page slots: 103912 
    Data pages: 103912, average fill: 68% 
    Primary pages: 103912, secondary pages: 0, swept pages: 54561 
    Empty pages: 144, full pages: 40836 
    Fill distribution: 
     0 - 19% = 820 
    20 - 39% = 1469 
    40 - 59% = 11938 
    60 - 79% = 89452 
    80 - 99% = 233 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10586, nodes: 6600435 
    Average node length: 6.51, total dup: 5711016, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1554251, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 2256 
        40 - 59% = 5942 
        60 - 79% = 2112 
        80 - 99% = 265 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8057, nodes: 6600435 
    Average node length: 5.41, total dup: 6329271, max dup: 145 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1378353, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1305 
        40 - 59% = 4231 
        60 - 79% = 1651 
        80 - 99% = 864 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8150, nodes: 6600435 
    Average node length: 5.41, total dup: 6329271, max dup: 145 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1380663, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1417 
        40 - 59% = 4223 
        60 - 79% = 1678 
        80 - 99% = 827 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.05, total records: 11776814 
    Average version length: 68.78, total versions: 176380, 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: 107, data page slots: 173296 
    Data pages: 173296, average fill: 72% 
    Primary pages: 173295, secondary pages: 1, swept pages: 98677 
    Empty pages: 8, full pages: 124693 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 609 
    40 - 59% = 7489 
    60 - 79% = 164212 
    80 - 99% = 927 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18351, nodes: 11775171 
    Average node length: 6.60, total dup: 10271673, max dup: 58 
    Average key length: 3.42, compression ratio: 12.28 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2428234, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2754 
        40 - 59% = 10686 
        60 - 79% = 4233 
        80 - 99% = 655 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.93, total records: 1308011 
    Average version length: 68.99, total versions: 203332, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.38 
    Pointer pages: 27, data page slots: 42320 
    Data pages: 28592, average fill: 48% 
    Primary pages: 28528, secondary pages: 64, swept pages: 12933 
    Empty pages: 4569, full pages: 13575 
    Fill distribution: 
     0 - 19% = 6989 
    20 - 39% = 4606 
    40 - 59% = 3234 
    60 - 79% = 11456 
    80 - 99% = 2307 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1838, nodes: 1158531 
    Average node length: 5.54, total dup: 1111514, max dup: 49 
    Average key length: 2.58, compression ratio: 16.26 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 79441, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 781 
        40 - 59% = 817 
        60 - 79% = 211 
        80 - 99% = 14 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 53.65, total records: 764071 
    Average version length: 69.03, total versions: 42557, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.35 
    Pointer pages: 23, data page slots: 36176 
    Data pages: 28376, average fill: 27% 
    Primary pages: 28375, secondary pages: 1, swept pages: 15601 
    Empty pages: 7623, full pages: 1641 
    Fill distribution: 
     0 - 19% = 12170 
    20 - 39% = 6712 
    40 - 59% = 7123 
    60 - 79% = 2363 
    80 - 99% = 8 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1102, nodes: 611049 
    Average node length: 5.92, total dup: 565212, max dup: 56 
    Average key length: 2.99, compression ratio: 14.04 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 79519, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 584 
        40 - 59% = 425 
        60 - 79% = 86 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.65, total records: 9239502 
    Average version length: 68.95, total versions: 190301, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 88, data page slots: 143200 
    Data pages: 143192, average fill: 69% 
    Primary pages: 143175, secondary pages: 17, swept pages: 85413 
    Empty pages: 318, full pages: 63160 
    Fill distribution: 
     0 - 19% = 757 
    20 - 39% = 2320 
    40 - 59% = 14761 
    60 - 79% = 124209 
    80 - 99% = 1145 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13516, nodes: 9237564 
    Average node length: 6.67, total dup: 7663750, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2126809, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1293 
        40 - 59% = 6861 
        60 - 79% = 4663 
        80 - 99% = 696 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21167291 
    Average version length: 83.07, total versions: 3265, 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: 320280 
    Data pages: 320280, average fill: 81% 
    Primary pages: 320276, secondary pages: 4, swept pages: 14650 
    Empty pages: 50, full pages: 318652 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 79 
    40 - 59% = 209 
    60 - 79% = 50069 
    80 - 99% = 269846 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19367, nodes: 21167291 
    Average node length: 5.72, total dup: 20685810, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285195, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8047 
        60 - 79% = 584 
        80 - 99% = 10729 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17196, nodes: 21167291 
    Average node length: 6.31, total dup: 18602812, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916357, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 782 
        60 - 79% = 282 
        80 - 99% = 16126 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21145, nodes: 21167291 
    Average node length: 6.35, total dup: 18520754, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579232, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8333 
        60 - 79% = 584 
        80 - 99% = 12223 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16048, nodes: 21167291 
    Average node length: 5.56, total dup: 21167191, max dup: 230585 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945281, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 11 
        40 - 59% = 2781 
        60 - 79% = 325 
        80 - 99% = 12929 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.43, total records: 10351530 
    Average version length: 82.59, total versions: 845764, 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: 103, data page slots: 167864 
    Data pages: 167840, average fill: 77% 
    Primary pages: 167818, secondary pages: 22, swept pages: 26228 
    Empty pages: 203, full pages: 154173 
    Fill distribution: 
     0 - 19% = 495 
    20 - 39% = 1533 
    40 - 59% = 5623 
    60 - 79% = 118093 
    80 - 99% = 42096 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11345, nodes: 10351530 
    Average node length: 5.36, total dup: 10038179, max dup: 221 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2413304, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 19 
        40 - 59% = 6050 
        60 - 79% = 4962 
        80 - 99% = 311 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13892, nodes: 10351530 
    Average node length: 6.23, total dup: 8587613, max dup: 14 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.08, average data length: 0.92 
    Clustering factor: 1735743, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 3326 
        40 - 59% = 4841 
        60 - 79% = 2671 
        80 - 99% = 2894 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12668, nodes: 10351530 
    Average node length: 5.97, total dup: 9013242, max dup: 45 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2616115, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 21 
        40 - 59% = 6919 
        60 - 79% = 5381 
        80 - 99% = 345 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10392, nodes: 10351530 
    Average node length: 5.14, total dup: 10351430, max dup: 160777 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1740891, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 805 
        40 - 59% = 5143 
        60 - 79% = 1991 
        80 - 99% = 2408 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.19, total records: 11808265 
    Average version length: 82.52, total versions: 663437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 119, data page slots: 192720 
    Data pages: 191728, average fill: 76% 
    Primary pages: 191573, secondary pages: 155, swept pages: 38058 
    Empty pages: 1638, full pages: 170546 
    Fill distribution: 
     0 - 19% = 2609 
    20 - 39% = 3489 
    40 - 59% = 8776 
    60 - 79% = 95526 
    80 - 99% = 81328 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13112, nodes: 11808265 
    Average node length: 5.31, total dup: 11697979, max dup: 652 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2477177, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 7833 
        60 - 79% = 4892 
        80 - 99% = 351 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10695, nodes: 11808265 
    Average node length: 5.51, total dup: 11294825, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 760088, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 732 
        40 - 59% = 2587 
        60 - 79% = 1797 
        80 - 99% = 5447 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15007, nodes: 11808265 
    Average node length: 6.03, total dup: 10323828, max dup: 73 
    Average key length: 2.79, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2493831, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 74 
        40 - 59% = 9255 
        60 - 79% = 5298 
        80 - 99% = 379 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11083, nodes: 11808265 
    Average node length: 5.24, total dup: 11808165, max dup: 189349 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 747194, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 610 
        40 - 59% = 5049 
        60 - 79% = 1556 
        80 - 99% = 3775 
 
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.91, total records: 10447039 
    Average version length: 82.90, total versions: 825902, 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: 106, data page slots: 172248 
    Data pages: 172232, average fill: 76% 
    Primary pages: 172204, secondary pages: 28, swept pages: 30614 
    Empty pages: 236, full pages: 151802 
    Fill distribution: 
     0 - 19% = 751 
    20 - 39% = 2626 
    40 - 59% = 9203 
    60 - 79% = 119205 
    80 - 99% = 40447 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12282, nodes: 10447039 
    Average node length: 5.18, total dup: 10417828, max dup: 1953 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2220821, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1220 
        40 - 59% = 8150 
        60 - 79% = 2206 
        80 - 99% = 689 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 14016, nodes: 10447039 
    Average node length: 6.24, total dup: 8666236, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1708693, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 218 
        20 - 39% = 3289 
        40 - 59% = 4845 
        60 - 79% = 2662 
        80 - 99% = 3002 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12931, nodes: 10447039 
    Average node length: 5.43, total dup: 9991046, max dup: 99 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2362279, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1171 
        40 - 59% = 9114 
        60 - 79% = 1942 
        80 - 99% = 684 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10616, nodes: 10447039 
    Average node length: 5.15, total dup: 10446939, max dup: 162971 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1773290, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 924 
        40 - 59% = 5343 
        60 - 79% = 1987 
        80 - 99% = 2332 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.96, total records: 585857 
    Average version length: 68.84, total versions: 11983, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8088, secondary pages: 0, swept pages: 2299 
    Empty pages: 6, full pages: 8028 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 7848 
    80 - 99% = 231 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41738, depth: 3, leaf buckets: 733, nodes: 585857 
    Average node length: 5.95, total dup: 498918, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102962, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 501 
        60 - 79% = 100 
        80 - 99% = 105 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33988, depth: 3, leaf buckets: 756, nodes: 585857 
    Average node length: 6.15, total dup: 480537, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103020, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 512 
        60 - 79% = 104 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 546, nodes: 585857 
    Average node length: 4.86, total dup: 585757, max dup: 9892 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 91578, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 292 
        60 - 79% = 66 
        80 - 99% = 165 
 
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 Tue Apr  9 04:10:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7780048 50256 1 0.0000 0.0000
DOC_LIST 2265103 26739 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1457 4 300.0000 0.0000
INVNT_TURNOVER_LOG 70553 56338 1 0.0000 0.0000
MONEY_SALDO 49 204 6 400.0000 0.0000
MONEY_TURNOVER_LOG 814 722 1 0.0000 0.0000
PDISTR 772539 13635 2 0.0000 0.0000
PERF_SPLIT_0 194017 23837 1 0.0000 0.0000
PERF_SPLIT_1 190162 36665 1 0.0000 0.0000
PERF_SPLIT_2 182460 15075 1 0.0000 0.0000
PERF_SPLIT_3 203213 43108 1 0.0000 0.0000
PERF_SPLIT_4 199490 28850 1 0.0000 0.0000
PERF_SPLIT_5 179416 17880 1 0.0000 0.0000
PERF_SPLIT_6 212733 63284 1 0.0000 0.0000
PERF_SPLIT_7 168531 18459 1 0.0000 0.0000
PERF_SPLIT_8 163703 18734 1 0.0000 0.0000
PERF_SPLIT_9 167043 15718 1 0.0000 0.0000
PSTORNED 2108718 26116 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 113222 38793 1 0.0000 0.0000
XQD_1000_3300 6600435 172572 1 0.0000 0.0000
XQD_1200_2000 11776814 176380 1 0.0000 0.0000
XQD_2000_3300 1308011 203332 1 0.0000 0.0000
XQD_2100_3300 764071 42557 1 0.0000 0.0000
XQD_3300_3400 9239502 190301 1 0.0000 0.0000
XQS_1000_1200 21167291 3265 1 0.0000 0.0000
XQS_1000_3300 10351530 845764 1 0.0000 0.0000
XQS_1200_2000 11808265 663437 1 0.0000 0.0000
XQS_2100_3300 10447039 825902 1 0.0000 0.0000
XQS_3300_3400 585857 11983 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 ---
:305: 
:306: mscs-test-161.budzdorov.ru    Tue Apr  9 04:07:58 2024
:307:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:308: 
:309: 
:310: mscs-test-161.budzdorov.ru    Tue Apr  9 04:08:33 2024
:311:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:312: 
--- end of diff output ---

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

09.04.24 04:10:42. 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-04-09 04:10:44 No severe PSQL-related problems occured
09.04.24 04:10:46. End of report.