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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-09 07:17:10
DTS_END                         2024-03-09 07:17:10.2070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/54530
TRN_ID                          177209
ATT_ID                          563
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: 9146.01 20676 914601
customer order: creation 185.76 416 18576
customer order: refuse 15.86 355 1586
order to supplier: creation 50.02 1359 5002
order to supplier: removal 3.38 94299 338
invoice (draft): creation 49.39 3213 4939
invoice (draft): removal 46.55 784 4655
invoice accept: apply 45.92 20705 4592
invoice accept: cancel 42.63 921 4263
customer reserve: creation 4283.26 202 428326
customer reserve: removal 4121.90 62 412190
realization accept: apply 90.29 209 9029
realization accept: cancel 72.13 132 7213
payment from customer: creation 64.02 130 6402
payment from customer: removal 5.93 98 593
payment to supplier: creation 54.33 147 5433
payment to supplier: removal 3.96 70 396
service: total inventory turnovers 3.50 5120 350
service: total monetary turnovers 6.27 731 627
service: aggregate perf. data 0.87 18735 87
service: refresh index statistics 0.04 265831 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2024 07:18:38 to 09-03-2024 07:18:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5546
TEST_TIME 2 4039
TEST_TIME 3 3978
TEST_TIME 4 4433
TEST_TIME 5 4016
TEST_TIME 6 4722
TEST_TIME 7 5060
TEST_TIME 8 5153
TEST_TIME 9 5034
TEST_TIME 10 4892
TEST_TIME 11 4845
TEST_TIME 12 4889
TEST_TIME 13 5257
TEST_TIME 14 5321
TEST_TIME 15 5600
TEST_TIME 16 5734
TEST_TIME 17 6007
TEST_TIME 18 6364
TEST_TIME 19 6852
TEST_TIME 20 7186
TEST_TIME 21 7696
TEST_TIME 22 7748
TEST_TIME 23 8280
TEST_TIME 24 8230
TEST_TIME 25 8337
TEST_TIME 26 8802
TEST_TIME 27 8806
TEST_TIME 28 8900
TEST_TIME 29 8794
TEST_TIME 30 8847
TEST_TIME 31 8801
TEST_TIME 32 9069
TEST_TIME 33 9284
TEST_TIME 34 9104
TEST_TIME 35 9088
TEST_TIME 36 9163
TEST_TIME 37 9270
TEST_TIME 38 9260
TEST_TIME 39 9285
TEST_TIME 40 9275
TEST_TIME 41 9349
TEST_TIME 42 9427
TEST_TIME 43 9425
TEST_TIME 44 9378
TEST_TIME 45 9234
TEST_TIME 46 9081
TEST_TIME 47 9017
TEST_TIME 48 9062
TEST_TIME 49 9087
TEST_TIME 50 9116
TEST_TIME 51 9091
TEST_TIME 52 9058
TEST_TIME 53 9027
TEST_TIME 54 8954
TEST_TIME 55 8906
TEST_TIME 56 8834
TEST_TIME 57 9081
TEST_TIME 58 9176
TEST_TIME 59 9176
TEST_TIME 60 9258
TEST_TIME 61 9213
TEST_TIME 62 9311
TEST_TIME 63 9313
TEST_TIME 64 9399
TEST_TIME 65 9429
TEST_TIME 66 9460
TEST_TIME 67 9402
TEST_TIME 68 9363
TEST_TIME 69 9264
TEST_TIME 70 9205
TEST_TIME 71 9210
TEST_TIME 72 9183
TEST_TIME 73 9125
TEST_TIME 74 9069
TEST_TIME 75 9115
TEST_TIME 76 9128
TEST_TIME 77 9103
TEST_TIME 78 9126
TEST_TIME 79 9256
TEST_TIME 80 9212
TEST_TIME 81 9233
TEST_TIME 82 9303
TEST_TIME 83 9337
TEST_TIME 84 9294
TEST_TIME 85 9404
TEST_TIME 86 9428
TEST_TIME 87 9415
TEST_TIME 88 9333
TEST_TIME 89 9298
TEST_TIME 90 9269
TEST_TIME 91 9234
TEST_TIME 92 9208
TEST_TIME 93 9193
TEST_TIME 94 9204
TEST_TIME 95 9158
TEST_TIME 96 9187
TEST_TIME 97 9207
TEST_TIME 98 9249
TEST_TIME 99 9227
TEST_TIME 100 9158

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-03-2024 07:18:42 to 09-03-2024 07:18:45.

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 1305103 1305103 0 0.00 0 16486 7 0 0
doc_list_biud 1305102 1305102 0 0.00 0 35186 25 0 0
sp_add_invoice_to_stock 4738 4592 146 3.08 38 249816 20706 0 146
sp_cancel_adding_invoice 4263 4263 0 0.00 5 68503 921 0 0
sp_cancel_client_order 1586 1586 0 0.00 4 9344 355 0 0
sp_cancel_customer_reserve 412190 412190 0 0.00 0 23015 62 0 0
sp_cancel_pay_from_customer 593 593 0 0.00 2 5833 99 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 3 5302 71 0 0
sp_cancel_supplier_invoice 4666 4655 11 0.23 1 27800 784 0 11
sp_cancel_supplier_order 338 338 0 0.00 9 1093770 94300 0 0
sp_cancel_write_off 7213 7213 0 0.00 1 8619 133 0 0
sp_client_order 18576 18576 0 0.00 3 47492 416 0 0
sp_customer_reserve 428326 428326 0 0.00 0 54241 203 0 0
sp_fill_shopping_cart 28517 28517 0 0.00 1 42704 41 0 0
sp_fill_shopping_cart_clo_res 428315 428315 0 0.00 0 12458 16 0 0
sp_get_clo_for_invoice 4579 4579 0 0.00 0 21776 361 0 0
sp_kill_cost_storno 12465 12465 0 0.00 0 16478 71 0 0
sp_kill_qstorno_ret_qs2qd 836586 836586 0 0.00 0 27730 33 0 0
sp_kill_qty_storno 443852 443852 0 0.00 0 35186 73 0 0
sp_lock_selected_doc 18807 18807 0 0.00 0 6300 5 0 0
sp_make_cost_storno 25442 25442 0 0.00 0 11442 66 0 0
sp_multiply_rows_for_pdistr 25441 25441 0 0.00 0 13062 36 0 0
sp_multiply_rows_for_qdistr 18576 18576 0 0.00 0 20207 200 0 0
sp_pay_from_customer 6402 6402 0 0.00 3 13410 131 0 0
sp_pay_to_supplier 5433 5433 0 0.00 4 13077 148 0 0
sp_payment_common 11834 11834 0 0.00 1 12553 28 0 0
sp_qd_handle_on_cancel_clo 1586 1586 0 0.00 0 9336 321 0 0
sp_qd_handle_on_invoice_upd_sts 8841 8841 0 0.00 0 35186 349 0 0
sp_qd_handle_on_reserve_upd_sts 9029 9029 0 0.00 0 15544 65 0 0
sp_reserve_write_off 9029 9029 0 0.00 6 15606 209 0 0
sp_supplier_invoice 4939 4939 0 0.00 7 75910 3213 0 0
sp_supplier_order 5002 5002 0 0.00 4 44795 1360 0 0
srv_aggregate_perf_data 87 87 0 0.00 1773 217373 18736 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 973 144168 38833 0 0
srv_find_qd_qs_mism 868070 868070 0 0.00 0 15133 7 0 0
srv_make_invnt_saldo 350 350 0 0.00 37 86705 5120 0 0
srv_make_money_saldo 627 627 0 0.00 1 15258 732 0 0
srv_recalc_idx_stat 4 4 0 0.00 129370 389469 265831 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4592 4592 0 0.00 0 12577 182 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 1 2934 116 0 0
t$perf-norm:sp_cancel_client_order 1586 1586 0 0.00 0 16809 26 0 0
t$perf-norm:sp_cancel_customer_reserve 645 645 0 0.00 0 476 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 593 593 0 0.00 0 541 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 645 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 339 339 0 0.00 0 722 14 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 27661 1831 0 0
t$perf-norm:sp_cancel_write_off 916 916 0 0.00 0 3793 12 0 0
t$perf-norm:sp_client_order 18576 18576 0 0.00 0 15151 19 0 0
t$perf-norm:sp_customer_reserve 894 894 0 0.00 0 764 5 0 0
t$perf-norm:sp_pay_from_customer 6402 6402 0 0.00 0 17272 12 0 0
t$perf-norm:sp_pay_to_supplier 5433 5433 0 0.00 0 2598 10 0 0
t$perf-norm:sp_reserve_write_off 9029 9029 0 0.00 0 6829 11 0 0
t$perf-norm:sp_supplier_invoice 4939 4939 0 0.00 0 7730 24 0 0
t$perf-norm:sp_supplier_order 5002 5002 0 0.00 0 6496 20 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 506 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 1153 21 0 0
t$perf-norm:srv_make_invnt_saldo 350 350 0 0.00 0 547 10 0 0
t$perf-norm:srv_make_money_saldo 627 627 0 0.00 0 601 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 29 13 0 0
v_add_invoice_to_stock 9446 9154 292 3.09 0 6636 21 0 292
v_all_customers 34312 34312 0 0.00 0 23 1 0 0
v_all_suppliers 28102 28102 0 0.00 0 24 1 0 0
v_all_wares 37152 37152 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 1170 8 0 0
v_cancel_client_order 3172 3172 0 0.00 0 5142 8 0 0
v_cancel_customer_prepayment 1186 1186 0 0.00 0 5824 10 0 0
v_cancel_customer_reserve 1290 1290 0 0.00 0 2404 5 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 761 5 0 0
v_cancel_supplier_invoice 700 678 22 3.14 0 256 14 0 22
v_cancel_supplier_order 676 676 0 0.00 0 1541 8 0 0
v_cancel_write_off 1832 1832 0 0.00 0 1253 14 0 0
v_max_id_clo_ord 5002 5002 0 0.00 0 4052 3 0 0
v_max_id_clo_res 894 894 0 0.00 0 4442 10 0 0
v_max_id_ord_sup 4939 4939 0 0.00 0 3657 2 0 0
v_max_non_paid_invoice 1322 1322 0 0.00 0 1547 5 0 0
v_max_non_paid_realizn 3091 3091 0 0.00 0 3628 5 0 0
v_min_id_clo_ord 5002 5002 0 0.00 0 4760 8 0 0
v_min_id_clo_res 894 894 0 0.00 0 10830 21 0 0
v_min_id_ord_sup 4939 4939 0 0.00 0 6545 4 0 0
v_min_non_paid_invoice 5433 5433 0 0.00 0 10122 18 0 0
v_min_non_paid_realizn 6401 6401 0 0.00 0 12546 20 0 0
v_our_firm 9460 9460 0 0.00 0 22 1 0 0
v_reserve_write_off 18058 18058 0 0.00 0 6715 8 0 0
x_lock_depdocs_on_canc_invoice 8579 8579 0 0.00 0 11547 146 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 2327 243 0 0
x_make_qstorno_1000_1200 5002 5002 0 0.00 1 44772 1267 0 0
x_make_qstorno_1200_2000 4939 4939 0 0.00 4 72267 3068 0 0
x_make_qstorno_2100_3300 428326 428326 0 0.00 0 54239 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2024 07:18:46 to 09-03-2024 07:18:50.

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
05:17:14 2 8192000000 8797221552 8807829504 3187328 0.038 1 1 2 0 3284944 61840 35776
05:18:15 34535 8192000000 9728455776 10026586112 801238800 8.909 100 92 182 0 830619504 7377376 22003328
05:19:54 18403 8192000000 9752062416 10057175040 825739424 9.156 100 85 170 0 857206368 10944768 20522176
05:21:15 19197 8192000000 9784484496 10096922624 849156912 9.392 100 86 172 0 888532432 19318752 20056768
05:22:48 15070 8192000000 9853130512 10182127616 901592864 9.914 100 83 166 0 961268544 40609984 19065696
05:24:05 8560 8192000000 9895902464 10240753664 945632640 10.348 100 72 144 0 1011041648 49929408 15479600
05:25:16 4007 8192000000 9962275072 10315984896 985289040 10.736 100 73 146 0 1073919936 74101696 14529200
05:26:22 2181 8192000000 9971011648 10333700096 1017138304 11.044 100 83 164 2 1093961104 60455392 16367408
05:27:26 1394 8192000000 10003414240 10368634880 1033776528 11.205 100 91 182 0 1117227344 64006208 19444608
05:28:29 2237 8192000000 10023126992 10397954048 1053122816 11.391 100 79 158 0 1144995744 76029776 15843152
05:29:34 49649 8192000000 9983145920 10380443648 1063639136 11.491 100 46 92 0 1103880688 30082336 10159216
05:31:27 4687 8192000000 10009564944 10409762816 1070523600 11.557 100 45 90 0 1136702272 57208656 8970016
05:32:32 9032 8192000000 9991699632 10398031872 1079802736 11.646 100 33 65 1 1095796672 9654112 6339824
05:33:45 56933 8192000000 9994292336 10405597184 1092145968 11.763 100 28 55 0 1108608160 10623600 5838592
05:35:44 5338 8192000000 10002831248 10409988096 1092179488 11.763 100 37 74 0 1118339104 18178368 7981248
05:36:54 4831 8192000000 10024136736 10421968896 1084661728 11.692 99 53 106 1 1119974768 23812992 11500048
05:38:05 22726 8192000000 10055293312 10449850368 1092480112 11.766 99 54 107 0 1145570768 42712512 10378144
05:40:23 14233 8192000000 10062425952 10461319168 1094057504 11.781 99 50 100 0 1158068928 53400576 10610848
05:41:39 16600 8192000000 10096867904 10500939776 1107453328 11.908 100 44 86 1 1205967168 90092096 8421744
05:43:20 15675 8192000000 10084284608 10490572800 1100373840 11.841 99 42 82 0 1196736304 87996880 8365584
05:44:43 10810 8192000000 10077083520 10477613056 1079159136 11.639 97 46 91 0 1162803648 72867536 10776976
05:45:57 28645 8192000000 10097179072 10498883584 1084060320 11.686 98 48 96 0 1179665712 85190496 10414896
05:47:30 18241 8192000000 10140698160 10550456320 1110006656 11.932 100 44 88 0 1254506736 135065744 9434336
05:49:00 17374 8192000000 10129048160 10530607104 1097948160 11.818 98 37 74 0 1230784016 124564688 8271168
05:50:22 9161 8192000000 10149847168 10547605504 1085054880 11.696 98 46 91 0 1238022624 142529056 10438688
05:51:36 10112 8192000000 10215847728 10612281344 1106419280 11.899 100 61 118 0 1317879408 198541152 12918976
05:52:51 3674 8192000000 10213640704 10611810304 1117562864 12.004 100 61 122 1 1322331408 191406256 13362288
05:53:59 1629 8192000000 10270163200 10655232000 1106655968 11.901 100 76 152 0 1366121344 242674768 16790608
05:55:04 6109 8192000000 10243070656 10645262336 1083343952 11.679 100 72 144 0 1358057744 258524336 16189456
05:56:17 2687 8192000000 10269951712 10675552256 1107125088 11.905 100 84 169 0 1375720464 249150688 19444688
05:57:23 968 8192000000 10241639312 10644942848 1110116800 11.934 100 85 168 1 1337832320 208558384 19157136
05:58:28 4021 8192000000 10220404096 10645454848 1124240896 12.067 100 50 98 1 1322080096 187126384 10712816
05:59:37 3925 8192000000 10216777920 10625748992 1109568448 11.928 99 47 92 1 1311273440 190731536 10973456
06:00:50 4593 8192000000 10218936032 10636873728 1126682832 12.090 100 43 85 0 1326254752 190391712 9180208
06:02:02 25946 8192000000 10202849088 10632257536 1125517424 12.079 100 36 72 2 1308939664 174394240 9028000
06:03:36 1580 8192000000 10179027968 10581635072 1132691312 12.147 100 90 178 1 1270941056 118142256 20107488
06:04:42 2366 8192000000 10156071152 10558242816 1146764752 12.279 100 88 173 2 1252282736 87379904 18138080
06:05:47 3879 8192000000 10165468080 10610081792 1148199632 12.293 100 32 64 0 1274828512 119647248 6981632
06:06:58 4395 8192000000 10196067696 10614677504 1136299776 12.181 100 43 85 0 1295723520 149226288 10197456
06:08:05 33238 8192000000 10178018288 10640678912 1137803152 12.195 100 23 46 0 1286311760 143126944 5381664
06:09:41 22546 8192000000 10114166272 10581737472 1134005648 12.159 100 13 26 0 1225902944 89207184 2690112
06:11:05 14781 8192000000 10073187664 10486489088 1126236352 12.086 99 50 97 1 1158725904 20641008 11848544
06:12:25 30703 8192000000 10130563136 10583105536 1132651776 12.146 99 12 24 0 1221940192 86820880 2467536
06:13:59 53271 8192000000 10086668384 10524160000 1119616560 12.023 98 19 36 0 1157154480 33594240 3943680
06:16:28 142036 8192000000 10128148688 10602012672 1126569824 12.089 98 13 27 0 1178064960 48984192 2510944
06:19:50 46890 8192000000 10070349808 10496102400 1113383008 11.964 98 9 18 0 1146472368 31368096 1721264
06:21:37 101785 8192000000 10069478048 10503286784 1111080544 11.943 97 19 38 1 1150690304 35223616 4386144
06:24:47 32886 8192000000 10051172976 10522451968 1099672096 11.835 97 17 34 0 1142683840 39536016 3475728
06:26:20 40449 8192000000 10040494864 10492985344 1079741424 11.645 97 36 73 0 1133648304 45717728 8189152
06:28:05 27743 8192000000 10051164896 10477645824 1100725968 11.845 99 25 49 0 1146110592 40319232 5065392
06:29:33 20755 8192000000 10067693232 10496466944 1126520848 12.089 100 33 67 1 1180267760 47000848 6746064
06:30:55 40711 8192000000 10096662496 10535161856 1113040112 11.961 98 16 32 0 1191177216 74708944 3428160
06:32:37 40570 8192000000 10111157440 10551881728 1091830448 11.760 96 18 36 1 1219884016 124097888 3955680
06:34:19 46842 8192000000 10051266896 10563002368 1099204832 11.830 98 12 25 0 1241906096 139738368 2962896
06:36:07 29964 8192000000 10078665456 10515333120 1091305712 11.755 98 54 107 1 1158445248 56129216 11010320
06:37:39 50476 8192000000 10067858784 10496843776 1100707024 11.844 99 28 56 0 1165312560 59008784 5596752
06:39:30 67329 8192000000 10090047872 10548908032 1104671760 11.882 99 22 44 0 1190041248 80743312 4626176
06:41:38 144168 8192000000 10070281120 10530181120 1070754928 11.559 95 19 39 0 1116182496 41855504 3572064
06:45:03 127943 8192000000 10031625648 10466332672 1113868656 11.969 99 15 30 1 1153974944 36225552 3880736
06:48:17 43219 8192000000 10079519296 10549788672 1122403344 12.050 100 15 28 0 1200211616 74719776 3088496
06:50:02 52942 8192000000 10067227168 10520342528 1108379584 11.917 98 16 32 0 1168982672 57338816 3264272
06:51:56 61099 8192000000 10070112832 10575097856 1086429952 11.709 96 14 28 0 1187859312 98262368 3166992
06:53:58 36675 8192000000 10088722640 10528309248 1128613184 12.108 99 23 46 0 1184814032 51600016 4600832
06:55:35 91114 8192000000 10078087200 10588729344 1136263760 12.180 99 18 36 1 1203920160 64340016 3316384
06:58:08 29720 8192000000 10120725648 10559905792 1135949936 12.177 99 19 38 0 1208658928 68924784 3784208
06:59:38 97009 8192000000 10098809472 10537447424 1081008128 11.657 94 19 36 0 1139531024 55061600 3461296
07:02:26 72998 8192000000 10080741952 10529705984 1089135648 11.734 96 27 54 0 1136585840 42074368 5375824
07:04:39 17606 8192000000 10054175888 10492104704 1114555968 11.976 99 33 66 0 1166038512 44329568 7152976
07:05:57 106909 8192000000 10079021472 10520219648 1111471008 11.946 98 33 66 2 1157219744 38961504 6787232
07:08:48 72069 8192000000 10092969040 10567036928 1088199888 11.726 96 16 32 0 1165751568 74260992 3290688
07:11:00 42443 8192000000 10055668896 10518454272 1109205232 11.925 99 15 30 0 1193793952 81186528 3402192
07:12:43 69104 8192000000 10122700576 10615463936 1105256848 11.887 98 15 30 0 1186324176 78041920 3025408
07:14:52 76084 8192000000 10120099472 10614870016 1100704160 11.844 96 15 30 0 1194415296 90263744 3447392

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-03-2024 07:18:52 to 09-03-2024 07:19:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          177208
MON$OLDEST_ACTIVE               180764
MON$OLDEST_SNAPSHOT             180764
MON$NEXT_TRANSACTION            180764
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                       1949152
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             707
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Mar  9 07:19:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        94732 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177208 
    Oldest active        180764 
    Oldest snapshot        180764 
    Next transaction    180765 
    Sequence number        0 
    Next attachment ID    707 
    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.31, total records: 7836075 
    Average version length: 48.17, total versions: 117349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 56, data page slots: 90008 
    Data pages: 90008, average fill: 70% 
    Primary pages: 90006, secondary pages: 2, swept pages: 31452 
    Empty pages: 6, full pages: 70724 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 58 
    40 - 59% = 1571 
    60 - 79% = 88309 
    80 - 99% = 56 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23371, nodes: 7836075 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1698350, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 348 
        20 - 39% = 1406 
        40 - 59% = 4438 
        60 - 79% = 2207 
        80 - 99% = 14972 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13563, nodes: 7836075 
    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: 1522679, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1360 
        40 - 59% = 2252 
        60 - 79% = 955 
        80 - 99% = 8996 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8387, nodes: 7836075 
    Average node length: 6.64, total dup: 5826333, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1515785, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 754 
        40 - 59% = 1585 
        60 - 79% = 796 
        80 - 99% = 5108 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.22, total records: 2300768 
    Average version length: 58.88, total versions: 59476, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 29304 
    Data pages: 29304, average fill: 72% 
    Primary pages: 29302, secondary pages: 2, swept pages: 8156 
    Empty pages: 0, full pages: 20045 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 18 
    40 - 59% = 341 
    60 - 79% = 28821 
    80 - 99% = 117 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4600, nodes: 2300768 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 683758, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 829 
        40 - 59% = 929 
        60 - 79% = 676 
        80 - 99% = 2166 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2477, nodes: 2302151 
    Average node length: 4.97, total dup: 2301252, max dup: 18680 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1284326, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 185 
        40 - 59% = 1473 
        60 - 79% = 559 
        80 - 99% = 257 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1841, nodes: 2300768 
    Average node length: 4.97, total dup: 2300718, max dup: 130556 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1091809, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 697 
        60 - 79% = 49 
        80 - 99% = 1090 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4409, nodes: 2300768 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 683758, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 517 
        40 - 59% = 713 
        60 - 79% = 738 
        80 - 99% = 2337 
 
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.28, total records: 400 
    Average version length: 30.10, total versions: 2802, max versions: 8 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 66% 
    Primary pages: 9, secondary pages: 23, swept pages: 0 
    Empty pages: 5, full pages: 21 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 22 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.46, total records: 182595 
    Average version length: 68.30, total versions: 175024, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.68 
    Pointer pages: 7, data page slots: 5288 
    Data pages: 2944, average fill: 84% 
    Primary pages: 2943, secondary pages: 1, swept pages: 0 
    Empty pages: 88, full pages: 2507 
    Fill distribution: 
     0 - 19% = 161 
    20 - 39% = 96 
    40 - 59% = 95 
    60 - 79% = 227 
    80 - 99% = 2365 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1675678, depth: 3, leaf buckets: 435, nodes: 182595 
    Average node length: 13.18, total dup: 17597, max dup: 2 
    Average key length: 10.39, compression ratio: 2.60 
    Average prefix length: 19.51, average data length: 7.49 
    Clustering factor: 131563, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 88 
        60 - 79% = 268 
        80 - 99% = 74 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 272, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 53% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.49, total records: 2711 
    Average version length: 43.95, total versions: 2596, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.53 
    Pointer pages: 1, data page slots: 56 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 28 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 26 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92397, depth: 2, leaf buckets: 4, nodes: 2711 
    Average node length: 4.14, total dup: 2613, max dup: 304 
    Average key length: 2.40, compression ratio: 7.93 
    Average prefix length: 18.64, average data length: 0.36 
    Clustering factor: 1419, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        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.59, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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: 36.11, total records: 784306 
    Average version length: 37.89, total versions: 32602, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8200 
    Data pages: 8192, average fill: 66% 
    Primary pages: 8191, secondary pages: 1, swept pages: 1087 
    Empty pages: 57, full pages: 7557 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 64 
    40 - 59% = 183 
    60 - 79% = 7797 
    80 - 99% = 51 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 799, nodes: 768743 
    Average node length: 4.87, total dup: 768694, max dup: 140099 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89336, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 100 
        40 - 59% = 401 
        60 - 79% = 178 
        80 - 99% = 120 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 851, nodes: 768743 
    Average node length: 5.89, total dup: 683828, max dup: 42 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156397, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 349 
        60 - 79% = 148 
        80 - 99% = 315 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 891, nodes: 768743 
    Average node length: 5.89, total dup: 683828, max dup: 42 
    Average key length: 3.03, compression ratio: 7.27 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 158350, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 358 
        60 - 79% = 146 
        80 - 99% = 292 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1086, nodes: 768743 
    Average node length: 5.97, total dup: 683828, max dup: 42 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 151174, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 225 
        40 - 59% = 583 
        60 - 79% = 176 
        80 - 99% = 101 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.06, total records: 5563 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.62, total fragments: 26, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.01 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 63% 
    Primary pages: 76, secondary pages: 12, swept pages: 51 
    Empty pages: 5, full pages: 59 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 75 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5563 
    Average node length: 5.46, total dup: 0, max dup: 0 
    Average key length: 3.56, compression ratio: 10.17 
    Average prefix length: 34.70, average data length: 1.53 
    Clustering factor: 5328, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5563 
    Average node length: 11.10, 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: 165, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 81837 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 856 
    Data pages: 856, average fill: 66% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 851 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 851 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32770, depth: 2, leaf buckets: 105, nodes: 81837 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3477, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 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.63, 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.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.64, total records: 144280 
    Average version length: 146.64, total versions: 1112, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 3888 
    Data pages: 3568, average fill: 83% 
    Primary pages: 3566, secondary pages: 2, swept pages: 5 
    Empty pages: 27, full pages: 3529 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3529 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 119.87, total records: 174808 
    Average version length: 154.28, total versions: 38222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.15 
    Pointer pages: 6, data page slots: 6152 
    Data pages: 4384, average fill: 85% 
    Primary pages: 4382, secondary pages: 2, swept pages: 3 
    Empty pages: 69, full pages: 4298 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4298 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 137.72, total records: 174991 
    Average version length: 154.20, total versions: 16571, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.31 
    Pointer pages: 8, data page slots: 6048 
    Data pages: 4360, average fill: 84% 
    Primary pages: 4357, secondary pages: 3, swept pages: 3 
    Empty pages: 48, full pages: 4294 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4294 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.30, total records: 156047 
    Average version length: 149.35, total versions: 2016, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 8, data page slots: 5120 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3903, secondary pages: 1, swept pages: 3 
    Empty pages: 58, full pages: 3822 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 3 
    40 - 59% = 12 
    60 - 79% = 3 
    80 - 99% = 3822 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 151859 
    Average version length: 151.39, total versions: 3157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 6520 
    Data pages: 3872, average fill: 81% 
    Primary pages: 3869, secondary pages: 3, swept pages: 3 
    Empty pages: 128, full pages: 3715 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3715 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 137.66, total records: 158301 
    Average version length: 154.73, total versions: 14668, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.32 
    Pointer pages: 6, data page slots: 6240 
    Data pages: 3968, average fill: 83% 
    Primary pages: 3965, secondary pages: 3, swept pages: 8 
    Empty pages: 53, full pages: 3863 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 16 
    40 - 59% = 20 
    60 - 79% = 11 
    80 - 99% = 3863 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.16, total records: 155877 
    Average version length: 150.61, total versions: 2108, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 5272 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3901, secondary pages: 3, swept pages: 3 
    Empty pages: 64, full pages: 3818 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3819 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 142.38, total records: 188177 
    Average version length: 154.75, total versions: 12069, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 7456 
    Data pages: 4696, average fill: 84% 
    Primary pages: 4692, secondary pages: 4, swept pages: 3 
    Empty pages: 47, full pages: 4627 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 1 
    80 - 99% = 4627 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 142.28, total records: 173239 
    Average version length: 154.91, total versions: 10938, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 7, data page slots: 6648 
    Data pages: 4416, average fill: 82% 
    Primary pages: 4414, secondary pages: 2, swept pages: 4 
    Empty pages: 129, full pages: 4240 
    Fill distribution: 
     0 - 19% = 137 
    20 - 39% = 10 
    40 - 59% = 15 
    60 - 79% = 15 
    80 - 99% = 4239 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.55, total records: 152453 
    Average version length: 151.48, total versions: 1694, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 8, data page slots: 4112 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3764, secondary pages: 4, swept pages: 4 
    Empty pages: 22, full pages: 3737 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3737 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.67, total records: 2153506 
    Average version length: 52.94, total versions: 52941, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 26096 
    Data pages: 26096, average fill: 71% 
    Primary pages: 26079, secondary pages: 17, swept pages: 9889 
    Empty pages: 80, full pages: 23485 
    Fill distribution: 
     0 - 19% = 157 
    20 - 39% = 167 
    40 - 59% = 626 
    60 - 79% = 24573 
    80 - 99% = 573 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2627, nodes: 2153506 
    Average node length: 5.44, total dup: 2010830, max dup: 1622 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185007, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 257 
        40 - 59% = 1749 
        60 - 79% = 324 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2765, nodes: 2153506 
    Average node length: 5.69, total dup: 1933382, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383515, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2264 
        60 - 79% = 465 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2172, nodes: 2153506 
    Average node length: 4.96, total dup: 2153406, max dup: 28028 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182822, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 197 
        40 - 59% = 1129 
        60 - 79% = 391 
        80 - 99% = 452 
 
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: 41.78, total records: 143506 
    Average version length: 69.16, total versions: 65414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.02 
    Pointer pages: 3, data page slots: 4752 
    Data pages: 3448, average fill: 51% 
    Primary pages: 3447, secondary pages: 1, swept pages: 612 
    Empty pages: 706, full pages: 1793 
    Fill distribution: 
     0 - 19% = 1098 
    20 - 39% = 285 
    40 - 59% = 193 
    60 - 79% = 734 
    80 - 99% = 1138 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106106, depth: 3, leaf buckets: 226, nodes: 143506 
    Average node length: 6.43, total dup: 124991, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 24310, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 48 
        40 - 59% = 115 
        60 - 79% = 54 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.93, total records: 6900561 
    Average version length: 68.78, total versions: 347619, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 103816 
    Data pages: 103816, average fill: 71% 
    Primary pages: 103815, secondary pages: 1, swept pages: 15593 
    Empty pages: 126, full pages: 80009 
    Fill distribution: 
     0 - 19% = 978 
    20 - 39% = 1891 
    40 - 59% = 5168 
    60 - 79% = 94551 
    80 - 99% = 1228 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10618, nodes: 6900561 
    Average node length: 6.51, total dup: 5968190, max dup: 41 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1606405, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1905 
        40 - 59% = 5804 
        60 - 79% = 2379 
        80 - 99% = 526 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8331, nodes: 6900561 
    Average node length: 5.40, total dup: 6621037, max dup: 269 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1408012, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1353 
        40 - 59% = 4269 
        60 - 79% = 1558 
        80 - 99% = 1143 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8356, nodes: 6900561 
    Average node length: 5.40, total dup: 6621037, max dup: 269 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1410378, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1411 
        40 - 59% = 4194 
        60 - 79% = 1595 
        80 - 99% = 1144 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.35, total records: 11874572 
    Average version length: 68.75, total versions: 312942, 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: 105, data page slots: 170296 
    Data pages: 170296, average fill: 74% 
    Primary pages: 170295, secondary pages: 1, swept pages: 50659 
    Empty pages: 6, full pages: 163443 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 330 
    40 - 59% = 2035 
    60 - 79% = 165769 
    80 - 99% = 2126 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18368, nodes: 11870506 
    Average node length: 6.60, total dup: 10344467, max dup: 56 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2459840, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2539 
        40 - 59% = 10939 
        60 - 79% = 4158 
        80 - 99% = 709 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 43.94, total records: 1696494 
    Average version length: 69.06, total versions: 353170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.87 
    Pointer pages: 30, data page slots: 47368 
    Data pages: 30696, average fill: 54% 
    Primary pages: 30614, secondary pages: 82, swept pages: 7067 
    Empty pages: 2805, full pages: 20416 
    Fill distribution: 
     0 - 19% = 4831 
    20 - 39% = 5232 
    40 - 59% = 3701 
    60 - 79% = 12633 
    80 - 99% = 4299 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1893, nodes: 1338447 
    Average node length: 5.54, total dup: 1283928, max dup: 49 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 93935, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 555 
        40 - 59% = 917 
        60 - 79% = 352 
        80 - 99% = 61 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 39.02, total records: 1419552 
    Average version length: 69.02, total versions: 166116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.23 
    Pointer pages: 22, data page slots: 34488 
    Data pages: 29880, average fill: 40% 
    Primary pages: 29877, secondary pages: 3, swept pages: 5909 
    Empty pages: 5331, full pages: 14519 
    Fill distribution: 
     0 - 19% = 8605 
    20 - 39% = 4915 
    40 - 59% = 7516 
    60 - 79% = 8363 
    80 - 99% = 481 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1259, nodes: 875994 
    Average node length: 5.89, total dup: 810217, max dup: 95 
    Average key length: 2.95, compression ratio: 14.22 
    Average prefix length: 41.12, average data length: 0.88 
    Clustering factor: 130506, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 276 
        40 - 59% = 652 
        60 - 79% = 295 
        80 - 99% = 35 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.27, total records: 9492057 
    Average version length: 68.98, total versions: 565510, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 92, data page slots: 150112 
    Data pages: 150104, average fill: 68% 
    Primary pages: 150085, secondary pages: 19, swept pages: 42330 
    Empty pages: 470, full pages: 76672 
    Fill distribution: 
     0 - 19% = 1243 
    20 - 39% = 4733 
    40 - 59% = 21840 
    60 - 79% = 118134 
    80 - 99% = 4154 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13551, nodes: 9485127 
    Average node length: 6.71, total dup: 7867015, max dup: 17 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2114670, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1024 
        40 - 59% = 6495 
        60 - 79% = 5148 
        80 - 99% = 884 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21177156 
    Average version length: 82.66, total versions: 11311, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320160 
    Data pages: 320160, average fill: 81% 
    Primary pages: 320159, secondary pages: 1, swept pages: 12855 
    Empty pages: 17, full pages: 319771 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 9 
    40 - 59% = 47 
    60 - 79% = 49745 
    80 - 99% = 270339 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19528, nodes: 21177156 
    Average node length: 5.72, total dup: 20695607, max dup: 158 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290766, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8373 
        60 - 79% = 569 
        80 - 99% = 10577 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17250, nodes: 21177156 
    Average node length: 6.31, total dup: 18609494, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 921781, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 878 
        60 - 79% = 292 
        80 - 99% = 16074 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21240, nodes: 21177156 
    Average node length: 6.35, total dup: 18529292, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585067, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8484 
        60 - 79% = 630 
        80 - 99% = 12119 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16239, nodes: 21177156 
    Average node length: 5.56, total dup: 21177056, max dup: 232512 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 950481, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 3133 
        60 - 79% = 376 
        80 - 99% = 12720 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.34, total records: 9929977 
    Average version length: 82.62, total versions: 551170, 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: 109, data page slots: 177528 
    Data pages: 177504, average fill: 70% 
    Primary pages: 177472, secondary pages: 32, swept pages: 64319 
    Empty pages: 573, full pages: 98183 
    Fill distribution: 
     0 - 19% = 1487 
    20 - 39% = 6442 
    40 - 59% = 27760 
    60 - 79% = 115903 
    80 - 99% = 25912 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11435, nodes: 9929977 
    Average node length: 5.39, total dup: 9616642, max dup: 205 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2215873, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 92 
        40 - 59% = 7380 
        60 - 79% = 3814 
        80 - 99% = 146 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13765, nodes: 9929977 
    Average node length: 6.26, total dup: 8231192, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1544277, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 3906 
        40 - 59% = 4474 
        60 - 79% = 2532 
        80 - 99% = 2708 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12774, nodes: 9929977 
    Average node length: 6.01, total dup: 8620046, max dup: 40 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2407289, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 116 
        40 - 59% = 8370 
        60 - 79% = 4100 
        80 - 99% = 185 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10367, nodes: 9929977 
    Average node length: 5.16, total dup: 9929877, max dup: 140082 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1588028, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1206 
        40 - 59% = 5286 
        60 - 79% = 1661 
        80 - 99% = 2189 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.54, total records: 11629076 
    Average version length: 82.54, total versions: 438316, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 121, data page slots: 197088 
    Data pages: 195920, average fill: 73% 
    Primary pages: 195785, secondary pages: 135, swept pages: 61984 
    Empty pages: 2129, full pages: 150776 
    Fill distribution: 
     0 - 19% = 3657 
    20 - 39% = 5927 
    40 - 59% = 16960 
    60 - 79% = 98349 
    80 - 99% = 71027 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13141, nodes: 11629076 
    Average node length: 5.32, total dup: 11518332, max dup: 660 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2446427, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 66 
        40 - 59% = 8199 
        60 - 79% = 4607 
        80 - 99% = 266 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10643, nodes: 11629076 
    Average node length: 5.52, total dup: 11122486, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 761241, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 794 
        40 - 59% = 2550 
        60 - 79% = 1848 
        80 - 99% = 5307 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15024, nodes: 11629076 
    Average node length: 6.04, total dup: 10153222, max dup: 67 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2462915, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 96 
        40 - 59% = 9609 
        60 - 79% = 4996 
        80 - 99% = 323 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11059, nodes: 11629076 
    Average node length: 5.25, total dup: 11628976, max dup: 167675 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 748559, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 72 
        20 - 39% = 834 
        40 - 59% = 5038 
        60 - 79% = 1430 
        80 - 99% = 3685 
 
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: 78.67, total records: 10049488 
    Average version length: 82.94, total versions: 553883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 112, data page slots: 182280 
    Data pages: 182240, average fill: 69% 
    Primary pages: 182208, secondary pages: 32, swept pages: 66579 
    Empty pages: 790, full pages: 97618 
    Fill distribution: 
     0 - 19% = 1834 
    20 - 39% = 7488 
    40 - 59% = 31882 
    60 - 79% = 115423 
    80 - 99% = 25613 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12201, nodes: 10049488 
    Average node length: 5.22, total dup: 10020058, max dup: 1670 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2014116, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1457 
        40 - 59% = 8176 
        60 - 79% = 1881 
        80 - 99% = 652 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13898, nodes: 10049488 
    Average node length: 6.29, total dup: 8330253, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1514750, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3874 
        40 - 59% = 4445 
        60 - 79% = 2501 
        80 - 99% = 2882 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12883, nodes: 10049488 
    Average node length: 5.47, total dup: 9599866, max dup: 95 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2151509, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1440 
        40 - 59% = 9131 
        60 - 79% = 1691 
        80 - 99% = 588 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10502, nodes: 10049488 
    Average node length: 5.19, total dup: 10049388, max dup: 141373 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1617423, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1212 
        40 - 59% = 5457 
        60 - 79% = 1516 
        80 - 99% = 2285 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.33, total records: 584400 
    Average version length: 68.81, total versions: 8412, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8136 
    Data pages: 8136, average fill: 75% 
    Primary pages: 8136, secondary pages: 0, swept pages: 2939 
    Empty pages: 0, full pages: 7414 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 6 
    40 - 59% = 84 
    60 - 79% = 7900 
    80 - 99% = 145 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 30070, depth: 3, leaf buckets: 748, nodes: 584400 
    Average node length: 5.95, total dup: 497472, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102384, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 540 
        60 - 79% = 103 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26735, depth: 3, leaf buckets: 764, nodes: 584400 
    Average node length: 6.15, total dup: 479268, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102427, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 547 
        60 - 79% = 108 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 558, nodes: 584400 
    Average node length: 4.86, total dup: 584300, max dup: 9815 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90935, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 311 
        60 - 79% = 56 
        80 - 99% = 158 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar  9 07:19:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7836075 117349 1 0.0000 0.0000
DOC_LIST 2300768 59476 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2802 8 700.0000 0.0000
INVNT_TURNOVER_LOG 182595 175024 1 0.0000 0.0000
MONEY_SALDO 49 272 8 500.0000 0.0000
MONEY_TURNOVER_LOG 2711 2596 1 0.0000 0.0000
PDISTR 784306 32602 3 0.0000 0.0000
PERF_SPLIT_0 144280 1112 1 0.0000 0.0000
PERF_SPLIT_1 174808 38222 1 0.0000 0.0000
PERF_SPLIT_2 174991 16571 1 0.0000 0.0000
PERF_SPLIT_3 156047 2016 1 0.0000 0.0000
PERF_SPLIT_4 151859 3157 1 0.0000 0.0000
PERF_SPLIT_5 158301 14668 1 0.0000 0.0000
PERF_SPLIT_6 155877 2108 1 0.0000 0.0000
PERF_SPLIT_7 188177 12069 1 0.0000 0.0000
PERF_SPLIT_8 173239 10938 1 0.0000 0.0000
PERF_SPLIT_9 152453 1694 1 0.0000 0.0000
PSTORNED 2153506 52941 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143506 65414 1 0.0000 0.0000
XQD_1000_3300 6900561 347619 1 0.0000 0.0000
XQD_1200_2000 11874572 312942 1 0.0000 0.0000
XQD_2000_3300 1696494 353170 1 0.0000 0.0000
XQD_2100_3300 1419552 166116 1 0.0000 0.0000
XQD_3300_3400 9492057 565510 1 0.0000 0.0000
XQS_1000_1200 21177156 11311 1 0.0000 0.0000
XQS_1000_3300 9929977 551170 1 0.0000 0.0000
XQS_1200_2000 11629076 438316 1 0.0000 0.0000
XQS_2100_3300 10049488 553883 1 0.0000 0.0000
XQS_3300_3400 584400 8412 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Mar  9 07:17:20 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sat Mar  9 07:17:21 2024
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Sat Mar  9 07:17:24 2024
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:17: 
--- end of diff output ---

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

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