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

Hardware and OS info

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

Server and database settinfs 


SERVER_MODE                     SuperServer 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-11 04:07:48
DTS_END                         2024-03-11 04:07:48.6660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/52028
TRN_ID                          170501
ATT_ID                          583
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9179.33 21374 917933
customer order: creation 175.20 371 17520
customer order: refuse 15.04 382 1504
order to supplier: creation 46.37 1279 4637
order to supplier: removal 3.41 98902 341
invoice (draft): creation 47.63 3194 4763
invoice (draft): removal 49.27 755 4927
invoice accept: apply 43.13 20742 4313
invoice accept: cancel 44.30 936 4430
customer reserve: creation 4130.86 200 413086
customer reserve: removal 4329.82 62 432982
realization accept: apply 84.71 183 8471
realization accept: cancel 79.40 137 7940
payment from customer: creation 59.89 111 5989
payment from customer: removal 6.10 99 610
payment to supplier: creation 49.20 137 4920
payment to supplier: removal 3.59 124 359
service: total inventory turnovers 3.86 3784 386
service: total monetary turnovers 6.66 549 666
service: aggregate perf. data 0.86 14716 86
service: refresh index statistics 0.03 280826 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2024 04:09:48 to 11-03-2024 04:09:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3264
TEST_TIME 2 4273
TEST_TIME 3 6095
TEST_TIME 4 5489
TEST_TIME 5 5872
TEST_TIME 6 5899
TEST_TIME 7 6483
TEST_TIME 8 6030
TEST_TIME 9 6389
TEST_TIME 10 6315
TEST_TIME 11 6207
TEST_TIME 12 6375
TEST_TIME 13 6359
TEST_TIME 14 6393
TEST_TIME 15 6597
TEST_TIME 16 6719
TEST_TIME 17 6909
TEST_TIME 18 7074
TEST_TIME 19 7197
TEST_TIME 20 7754
TEST_TIME 21 8181
TEST_TIME 22 8223
TEST_TIME 23 8311
TEST_TIME 24 8820
TEST_TIME 25 9750
TEST_TIME 26 9925
TEST_TIME 27 9818
TEST_TIME 28 9667
TEST_TIME 29 9825
TEST_TIME 30 9619
TEST_TIME 31 9745
TEST_TIME 32 9491
TEST_TIME 33 9424
TEST_TIME 34 9216
TEST_TIME 35 9276
TEST_TIME 36 9284
TEST_TIME 37 9387
TEST_TIME 38 9418
TEST_TIME 39 9473
TEST_TIME 40 9369
TEST_TIME 41 9205
TEST_TIME 42 9235
TEST_TIME 43 9251
TEST_TIME 44 9421
TEST_TIME 45 9435
TEST_TIME 46 9388
TEST_TIME 47 9400
TEST_TIME 48 9495
TEST_TIME 49 9509
TEST_TIME 50 9477
TEST_TIME 51 9517
TEST_TIME 52 9584
TEST_TIME 53 9583
TEST_TIME 54 9659
TEST_TIME 55 9554
TEST_TIME 56 9700
TEST_TIME 57 9591
TEST_TIME 58 9462
TEST_TIME 59 9491
TEST_TIME 60 9437
TEST_TIME 61 9375
TEST_TIME 62 9330
TEST_TIME 63 9261
TEST_TIME 64 9189
TEST_TIME 65 9235
TEST_TIME 66 9202
TEST_TIME 67 9194
TEST_TIME 68 9250
TEST_TIME 69 9263
TEST_TIME 70 9217
TEST_TIME 71 9354
TEST_TIME 72 9319
TEST_TIME 73 9406
TEST_TIME 74 9427
TEST_TIME 75 9392
TEST_TIME 76 9445
TEST_TIME 77 9396
TEST_TIME 78 9365
TEST_TIME 79 9382
TEST_TIME 80 9307
TEST_TIME 81 9240
TEST_TIME 82 9222
TEST_TIME 83 9203
TEST_TIME 84 9156
TEST_TIME 85 9073
TEST_TIME 86 9041
TEST_TIME 87 9064
TEST_TIME 88 9086
TEST_TIME 89 9117
TEST_TIME 90 9103
TEST_TIME 91 9180
TEST_TIME 92 9191
TEST_TIME 93 9191
TEST_TIME 94 9204
TEST_TIME 95 9219
TEST_TIME 96 9263
TEST_TIME 97 9261
TEST_TIME 98 9284
TEST_TIME 99 9209
TEST_TIME 100 9183

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-03-2024 04:09:52 to 11-03-2024 04:09:55.

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 1295017 1295017 0 0.00 0 26151 8 0 0
doc_list_biud 1295016 1295016 0 0.00 0 27680 26 0 0
sp_add_invoice_to_stock 4438 4313 125 2.81 44 167836 20743 0 125
sp_cancel_adding_invoice 4430 4430 0 0.00 4 81853 936 0 0
sp_cancel_client_order 1504 1504 0 0.00 4 13070 383 0 0
sp_cancel_customer_reserve 432982 432982 0 0.00 0 27681 62 0 0
sp_cancel_pay_from_customer 610 610 0 0.00 2 7412 99 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 3 8197 125 0 0
sp_cancel_supplier_invoice 4938 4927 11 0.22 1 19003 756 0 11
sp_cancel_supplier_order 341 341 0 0.00 4 999293 98903 0 0
sp_cancel_write_off 7940 7940 0 0.00 1 26154 137 0 0
sp_client_order 17520 17520 0 0.00 3 21698 372 0 0
sp_customer_reserve 413086 413086 0 0.00 0 119815 201 0 0
sp_fill_shopping_cart 26919 26919 0 0.00 1 20013 35 0 0
sp_fill_shopping_cart_clo_res 413082 413082 0 0.00 0 21564 16 0 0
sp_get_clo_for_invoice 4309 4309 0 0.00 0 20015 319 0 0
sp_kill_cost_storno 13339 13339 0 0.00 0 26150 77 0 0
sp_kill_qstorno_ret_qs2qd 879172 879172 0 0.00 0 27679 34 0 0
sp_kill_qty_storno 464904 464904 0 0.00 0 27680 72 0 0
sp_lock_selected_doc 17729 17729 0 0.00 0 10403 6 0 0
sp_make_cost_storno 23689 23689 0 0.00 0 13540 60 0 0
sp_multiply_rows_for_pdistr 23689 23689 0 0.00 0 8288 34 0 0
sp_multiply_rows_for_qdistr 17520 17520 0 0.00 0 21601 192 0 0
sp_pay_from_customer 5989 5989 0 0.00 4 11370 112 0 0
sp_pay_to_supplier 4920 4920 0 0.00 4 12636 138 0 0
sp_payment_common 10909 10909 0 0.00 1 8894 23 0 0
sp_qd_handle_on_cancel_clo 1504 1504 0 0.00 0 13060 352 0 0
sp_qd_handle_on_invoice_upd_sts 8739 8739 0 0.00 0 18021 322 0 0
sp_qd_handle_on_reserve_upd_sts 8471 8471 0 0.00 0 11653 57 0 0
sp_reserve_write_off 8471 8471 0 0.00 6 23085 184 0 0
sp_supplier_invoice 4763 4763 0 0.00 5 84892 3194 0 0
sp_supplier_order 4637 4637 0 0.00 4 32233 1280 0 0
srv_aggregate_perf_data 86 86 0 0.00 1601 239455 14717 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1084 158558 43418 0 0
srv_find_qd_qs_mism 874023 874023 0 0.00 0 10298 7 0 0
srv_make_invnt_saldo 386 386 0 0.00 62 99940 3784 0 0
srv_make_money_saldo 666 666 0 0.00 1 13565 550 0 0
srv_recalc_idx_stat 3 3 0 0.00 224321 351923 280826 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 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 4315 4315 0 0.00 0 7372 161 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 0 3938 95 0 0
t$perf-norm:sp_cancel_client_order 1504 1504 0 0.00 0 4032 19 0 0
t$perf-norm:sp_cancel_customer_reserve 598 598 0 0.00 0 2040 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 610 610 0 0.00 0 4519 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 302 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 1690 13 0 0
t$perf-norm:sp_cancel_supplier_order 341 341 0 0.00 0 19458 1556 0 0
t$perf-norm:sp_cancel_write_off 819 819 0 0.00 0 2069 10 0 0
t$perf-norm:sp_client_order 17520 17520 0 0.00 0 11328 16 0 0
t$perf-norm:sp_customer_reserve 914 914 0 0.00 0 2996 7 0 0
t$perf-norm:sp_pay_from_customer 5989 5989 0 0.00 0 5252 11 0 0
t$perf-norm:sp_pay_to_supplier 4921 4921 0 0.00 0 2173 8 0 0
t$perf-norm:sp_reserve_write_off 8471 8471 0 0.00 0 4427 10 0 0
t$perf-norm:sp_supplier_invoice 4763 4763 0 0.00 0 4043 15 0 0
t$perf-norm:sp_supplier_order 4637 4637 0 0.00 0 5526 13 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 193 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 471 11 0 0
t$perf-norm:srv_make_invnt_saldo 386 386 0 0.00 0 2063 10 0 0
t$perf-norm:srv_make_money_saldo 666 666 0 0.00 0 1850 7 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 12 5 0 0
v_add_invoice_to_stock 8866 8616 250 2.81 0 7577 15 0 250
v_all_customers 32528 32528 0 0.00 0 27 1 0 0
v_all_suppliers 26236 26236 0 0.00 0 21 1 0 0
v_all_wares 35040 35040 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 432 6 0 0
v_cancel_client_order 3008 3008 0 0.00 0 6637 6 0 0
v_cancel_customer_prepayment 1220 1220 0 0.00 0 2083 7 0 0
v_cancel_customer_reserve 1196 1196 0 0.00 0 1462 4 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 3171 10 0 0
v_cancel_supplier_invoice 728 706 22 3.02 0 1168 16 0 22
v_cancel_supplier_order 682 682 0 0.00 0 600 4 0 0
v_cancel_write_off 1638 1638 0 0.00 0 3964 13 0 0
v_max_id_clo_ord 4637 4637 0 0.00 0 579 1 0 0
v_max_id_clo_res 914 914 0 0.00 0 1937 12 0 0
v_max_id_ord_sup 4762 4762 0 0.00 0 4680 2 0 0
v_max_non_paid_invoice 1201 1201 0 0.00 0 769 3 0 0
v_max_non_paid_realizn 2947 2947 0 0.00 0 1570 3 0 0
v_min_id_clo_ord 4637 4637 0 0.00 0 3072 8 0 0
v_min_id_clo_res 914 914 0 0.00 0 3877 13 0 0
v_min_id_ord_sup 4762 4762 0 0.00 0 7013 6 0 0
v_min_non_paid_invoice 4920 4920 0 0.00 0 6592 14 0 0
v_min_non_paid_realizn 5989 5989 0 0.00 0 8329 18 0 0
v_our_firm 8596 8596 0 0.00 0 21 1 0 0
v_reserve_write_off 16942 16942 0 0.00 0 6625 5 0 0
x_lock_depdocs_on_canc_invoice 9004 9004 0 0.00 0 13395 116 0 0
x_lock_depdocs_on_canc_sup_ord 341 341 0 0.00 0 8879 334 0 0
x_make_qstorno_1000_1200 4637 4637 0 0.00 1 32186 1212 0 0
x_make_qstorno_1200_2000 4763 4763 0 0.00 2 83894 3062 0 0
x_make_qstorno_2100_3300 413086 413086 0 0.00 0 119812 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2024 04:09:56 to 11-03-2024 04:10:00.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:52 2 8192000000 8796669552 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
02:08:52 40898 8192000000 9725774272 10022600704 797241408 8.868 100 92 184 1 827129952 7884528 22004016
02:10:37 21212 8192000000 9756674336 10064965632 833869776 9.238 100 84 168 0 865267744 11303936 20094032
02:12:03 19997 8192000000 9794496752 10109521920 864374528 9.544 100 91 182 0 904122912 18537232 21211152
02:13:26 17316 8192000000 9847232256 10178277376 899249984 9.891 100 77 154 1 955365584 39317600 16798000
02:14:46 6706 8192000000 9901875456 10241101824 938892672 10.282 100 82 160 0 1013188768 57444496 16851600
02:15:55 4239 8192000000 9926700960 10275999744 971662288 10.603 100 71 142 1 1045428208 59117776 14648144
02:17:00 3199 8192000000 9970307184 10328678400 1004454592 10.922 100 88 173 0 1088696224 67123184 17118448
02:18:06 7521 8192000000 9996662752 10368917504 1027757408 11.147 100 74 148 0 1118941584 77100336 14083840
02:19:16 1874 8192000000 10032503536 10402824192 1058482672 11.442 100 88 175 0 1140516656 64552048 17481936
02:20:19 1224 8192000000 10055560128 10430840832 1069225296 11.545 100 78 154 0 1166094352 81184416 15684640
02:21:32 5219 8192000000 10014352528 10404089856 1073019520 11.581 100 47 94 0 1129573648 46806720 9747408
02:22:39 6451 8192000000 10005153280 10402861056 1087012800 11.714 100 46 91 0 1124616560 28345872 9257888
02:23:47 6069 8192000000 10019291216 10430795776 1091972736 11.761 100 21 42 1 1131267904 35323200 3971968
02:24:53 29159 8192000000 10011306160 10413277184 1097193232 11.811 100 37 75 0 1122636144 17608080 7834832
02:26:25 5660 8192000000 10007478496 10408280064 1091521216 11.757 99 36 72 0 1120670144 21463904 7685024
02:27:37 9459 8192000000 10017271568 10431803392 1107795024 11.912 100 17 36 0 1132105728 20915376 3395328
02:28:55 4928 8192000000 10062720624 10458148864 1111651120 11.948 100 59 115 1 1173420368 49913472 11855776
02:30:05 24349 8192000000 10085620368 10487443456 1113045440 11.961 99 62 123 1 1200589664 74852096 12692128
02:31:31 33974 8192000000 10056090448 10462937088 1113534112 11.966 99 42 84 0 1166491248 43759920 9197216
02:33:08 23058 8192000000 10104291104 10515976192 1116029824 11.989 99 44 88 0 1206674352 81663904 8980624
02:34:44 12491 8192000000 10083986656 10490429440 1106465088 11.899 99 42 84 0 1179616544 64081664 9069792
02:36:00 19148 8192000000 10143468208 10549633024 1103323552 11.869 100 55 109 0 1241864080 126756144 11784384
02:37:22 13836 8192000000 10119829600 10510155776 1062475680 11.480 96 50 100 0 1193507632 120078112 10953840
02:39:11 9432 8192000000 10143440272 10540548096 1082749760 11.674 98 49 97 1 1235651152 142188096 10713296
02:40:24 3950 8192000000 10158645936 10551726080 1096757440 11.807 99 52 102 1 1260683712 152193264 11733008
02:41:33 3816 8192000000 10245128016 10641276928 1130280352 12.124 100 63 126 0 1349904000 205751184 13872464
02:42:42 2979 8192000000 10260563696 10665615360 1121419952 12.040 99 77 154 3 1360408272 221832432 17155888
02:43:48 2066 8192000000 10301807072 10687676416 1124601440 12.070 100 89 171 0 1398710000 255386240 18722320
02:44:56 1084 8192000000 10355870112 10751881216 1142049200 12.235 100 79 154 1 1450089152 291230672 16809280
02:46:03 3245 8192000000 10374724752 10768826368 1130140960 12.123 100 85 171 1 1473109168 323329168 19639040
02:47:11 3014 8192000000 10389315456 10805317632 1139181536 12.208 100 91 174 0 1498384944 338651696 20551712
02:48:17 4189 8192000000 10329955632 10753204224 1137826880 12.195 99 53 106 3 1434563408 284854240 11882288
02:49:24 15269 8192000000 10333707824 10766209024 1149772768 12.307 100 27 54 0 1444574448 287825648 6976032
02:50:43 21414 8192000000 10298336240 10766880768 1124550928 12.070 99 34 66 0 1410101536 277246608 8304000
02:53:01 56368 8192000000 10044447536 10476871680 1099913040 11.837 99 9 18 0 1145864272 43996000 1955232
02:55:01 29628 8192000000 10073653376 10498908160 1124237376 12.067 100 32 62 0 1168027424 37179792 6610256
02:56:47 66741 8192000000 10098272352 10553761792 1116965808 11.998 99 13 26 0 1211138864 91143968 3029088
02:58:56 72193 8192000000 10090934656 10520952832 1134651760 12.165 100 31 62 0 1163974528 22995984 6326784
03:01:10 78289 8192000000 10171717232 10608963584 1140229712 12.218 99 20 40 0 1221984416 76492000 5262704
03:03:31 37150 8192000000 10129538784 10616754176 1144979472 12.262 100 20 40 0 1282765328 132382640 5403216
03:05:12 60785 8192000000 10119884864 10564460544 1130231152 12.124 99 26 50 1 1229527104 93495280 5800672
03:07:38 61551 8192000000 10137778560 10584383488 1147635312 12.287 99 18 36 0 1248660192 96981936 4042944
03:09:41 75255 8192000000 10160460304 10654642176 1151819328 12.327 100 22 42 0 1281428352 124394000 5215024
03:12:14 35719 8192000000 10062160384 10527965184 1134799824 12.167 99 6 12 0 1171181296 35398352 983120
03:13:50 68226 8192000000 10107660944 10569863168 1111589440 11.947 97 28 57 2 1162742128 46065568 5087120
03:16:00 90414 8192000000 10077573744 10524184576 1089886768 11.742 96 28 56 0 1127451184 31857600 5706816
03:18:32 75087 8192000000 10061463408 10540195840 1078240720 11.631 94 13 26 0 1144678832 63700352 2737760
03:20:50 19634 8192000000 10052180016 10471817216 1081469280 11.661 96 24 47 0 1109797296 23513040 4814976
03:22:12 31093 8192000000 10075000352 10526851072 1107834880 11.912 99 34 68 1 1159423584 44618208 6970496
03:23:45 108050 8192000000 10032762624 10448539648 1068476160 11.538 95 13 26 0 1115193680 43459728 3257792
03:26:34 46604 8192000000 10053037840 10543480832 1113075728 11.962 100 25 50 0 1170716480 52455312 5185440
03:28:43 73576 8192000000 10050846784 10500161536 1077894688 11.627 96 19 38 0 1130769264 49068352 3806224
03:30:58 62501 8192000000 10090605024 10549608448 1115681664 11.986 100 12 24 0 1194089184 75731632 2675888
03:33:40 49492 8192000000 10060893616 10501386240 1109553552 11.928 99 44 79 0 1136939920 19453136 7933232
03:35:36 39147 8192000000 10055779552 10497654784 1097016352 11.809 98 16 32 0 1151299152 51000096 3282704
03:37:19 68541 8192000000 10099191072 10591956992 1133023952 12.150 100 19 38 0 1218213616 81362320 3827344
03:39:31 41546 8192000000 10142895312 10564874240 1106027632 11.895 99 30 60 0 1190863616 78696544 6139440
03:41:14 158558 8192000000 10077502576 10561675264 1073673424 11.587 95 15 30 0 1138862816 62428400 2760992
03:44:54 18167 8192000000 10060799680 10485002240 1109692288 11.930 99 45 84 0 1143029840 24924816 8412736
03:46:12 33846 8192000000 10112477728 10574073856 1128890784 12.111 100 35 70 0 1196785616 60530416 7364416
03:47:46 98025 8192000000 10070359840 10534027264 1135980656 12.178 100 22 44 0 1185885248 45663728 4240864
03:50:26 64703 8192000000 10068807936 10526441472 1130373440 12.125 99 8 16 0 1168688272 36800832 1514000
03:52:34 44090 8192000000 10063587024 10509402112 1109926144 11.932 98 13 26 0 1153551312 41087200 2537968
03:54:20 66267 8192000000 10093861728 10561757184 1127128800 12.094 99 18 36 0 1212483488 81523536 3831152
03:56:30 23400 8192000000 10051838592 10491944960 1124515632 12.070 99 28 54 1 1193127056 62889168 5722256
03:57:54 51895 8192000000 10124691648 10582278144 1122090096 12.047 98 38 76 0 1214056720 83253088 8713536
03:59:54 25634 8192000000 10064038848 10488229888 1112746320 11.958 98 39 77 1 1143420336 22986400 7687616
04:01:25 36586 8192000000 10098944400 10537152512 1136839472 12.186 100 24 49 1 1177370400 35499488 5031440
04:03:03 50100 8192000000 10078300384 10527506432 1083249552 11.678 96 17 34 0 1156420896 69666096 3505248
04:04:59 123409 8192000000 10083671792 10522710016 1039502992 11.260 92 23 46 0 1122688608 77867840 5317776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 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 11-03-2024 04:10:17 to 11-03-2024 04:10:19.

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          169757
MON$OLDEST_ACTIVE               170698
MON$OLDEST_SNAPSHOT             170698
MON$NEXT_TRANSACTION            170698
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                       1913824
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             695
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 Mon Mar 11 04:10:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        89053 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169757 
    Oldest active        170698 
    Oldest snapshot        170698 
    Next transaction    170699 
    Sequence number        0 
    Next attachment ID    695 
    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.71, total records: 7709042 
    Average version length: 48.16, total versions: 35575, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88504 
    Data pages: 88504, average fill: 70% 
    Primary pages: 88502, secondary pages: 2, swept pages: 46949 
    Empty pages: 2, full pages: 62095 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 36 
    40 - 59% = 1237 
    60 - 79% = 87202 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23260, nodes: 7709042 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1675597, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 354 
        20 - 39% = 2024 
        40 - 59% = 3937 
        60 - 79% = 2465 
        80 - 99% = 14480 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13486, nodes: 7709042 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1499332, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1728 
        40 - 59% = 1876 
        60 - 79% = 1147 
        80 - 99% = 8735 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8341, nodes: 7709042 
    Average node length: 6.61, total dup: 5774413, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1492367, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 1050 
        40 - 59% = 1303 
        60 - 79% = 955 
        80 - 99% = 4896 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.96, total records: 2229105 
    Average version length: 58.90, total versions: 21811, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28584 
    Data pages: 28584, average fill: 72% 
    Primary pages: 28582, secondary pages: 2, swept pages: 15846 
    Empty pages: 8, full pages: 15598 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 41 
    40 - 59% = 452 
    60 - 79% = 28035 
    80 - 99% = 43 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4554, nodes: 2229105 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678410, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 968 
        40 - 59% = 810 
        60 - 79% = 747 
        80 - 99% = 2029 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2402, nodes: 2229823 
    Average node length: 4.97, total dup: 2228924, max dup: 19311 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261714, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 202 
        40 - 59% = 1388 
        60 - 79% = 561 
        80 - 99% = 250 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1774, nodes: 2229105 
    Average node length: 4.97, total dup: 2229055, max dup: 130127 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060860, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 621 
        60 - 79% = 42 
        80 - 99% = 1096 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4376, nodes: 2229105 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678410, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 640 
        40 - 59% = 652 
        60 - 79% = 833 
        80 - 99% = 2150 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.39, total records: 400 
    Average version length: 28.25, total versions: 2555, max versions: 7 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 60% 
    Primary pages: 11, secondary pages: 21, swept pages: 0 
    Empty pages: 4, full pages: 18 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 17 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 19.70, total records: 81897 
    Average version length: 68.29, total versions: 67126, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.47 
    Pointer pages: 7, data page slots: 2704 
    Data pages: 1760, average fill: 62% 
    Primary pages: 1759, secondary pages: 1, swept pages: 230 
    Empty pages: 271, full pages: 947 
    Fill distribution: 
     0 - 19% = 352 
    20 - 39% = 169 
    40 - 59% = 175 
    60 - 79% = 238 
    80 - 99% = 826 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708277, depth: 3, leaf buckets: 345, nodes: 81897 
    Average node length: 13.07, total dup: 6816, max dup: 1 
    Average key length: 10.67, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 58418, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 95 
        60 - 79% = 20 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 143, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 65% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    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: 14.13, total records: 1216 
    Average version length: 43.93, total versions: 1041, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.11 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 41% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 6, full pages: 6 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95043, depth: 2, leaf buckets: 2, nodes: 1216 
    Average node length: 4.36, total dup: 1120, max dup: 146 
    Average key length: 2.83, compression ratio: 6.70 
    Average prefix length: 18.24, average data length: 0.76 
    Clustering factor: 646, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.69, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.29, total records: 785718 
    Average version length: 37.89, total versions: 9796, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8504 
    Data pages: 8504, average fill: 63% 
    Primary pages: 8503, secondary pages: 1, swept pages: 5024 
    Empty pages: 18, full pages: 3732 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 63 
    40 - 59% = 1280 
    60 - 79% = 7092 
    80 - 99% = 20 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 862, nodes: 780164 
    Average node length: 4.88, total dup: 780115, max dup: 142047 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89583, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 138 
        40 - 59% = 467 
        60 - 79% = 163 
        80 - 99% = 89 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 919, nodes: 780164 
    Average node length: 5.89, total dup: 694603, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156106, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 59 
        40 - 59% = 465 
        60 - 79% = 121 
        80 - 99% = 274 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 947, nodes: 780164 
    Average node length: 5.89, total dup: 694603, max dup: 44 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157906, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 114 
        40 - 59% = 449 
        60 - 79% = 125 
        80 - 99% = 259 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1121, nodes: 780164 
    Average node length: 5.97, total dup: 694603, max dup: 44 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150756, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 250 
        40 - 59% = 589 
        60 - 79% = 201 
        80 - 99% = 78 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5458 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.40, total fragments: 25, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 112 
    Data pages: 110, average fill: 49% 
    Primary pages: 93, secondary pages: 17, swept pages: 63 
    Empty pages: 24, full pages: 56 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5458 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.42, average data length: 1.55 
    Clustering factor: 5140, ratio: 0.94 
    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: 5458 
    Average node length: 11.16, 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: 155, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 77991 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 809 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 809 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36185, depth: 2, leaf buckets: 99, nodes: 77991 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2871, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 145.31, total records: 153847 
    Average version length: 153.82, total versions: 6012, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 5, data page slots: 4488 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3815, secondary pages: 1, swept pages: 2 
    Empty pages: 37, full pages: 3769 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3768 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 147.05, total records: 146951 
    Average version length: 153.21, total versions: 4093, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 5, data page slots: 4632 
    Data pages: 3632, average fill: 84% 
    Primary pages: 3629, secondary pages: 3, swept pages: 1 
    Empty pages: 20, full pages: 3603 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3603 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.25, total records: 147952 
    Average version length: 151.87, total versions: 1876, 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: 7, data page slots: 4760 
    Data pages: 3672, average fill: 83% 
    Primary pages: 3669, secondary pages: 3, swept pages: 7 
    Empty pages: 29, full pages: 3624 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3624 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 133.66, total records: 181472 
    Average version length: 155.02, total versions: 22470, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.69 
    Pointer pages: 6, data page slots: 6840 
    Data pages: 4544, average fill: 84% 
    Primary pages: 4541, secondary pages: 3, swept pages: 3 
    Empty pages: 66, full pages: 4461 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 8 
    80 - 99% = 4461 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.27, total records: 148704 
    Average version length: 146.27, total versions: 862, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 3712, average fill: 83% 
    Primary pages: 3709, secondary pages: 3, swept pages: 2 
    Empty pages: 53, full pages: 3645 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3645 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 128.26, total records: 184304 
    Average version length: 154.77, total versions: 29574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.22 
    Pointer pages: 6, data page slots: 5272 
    Data pages: 4576, average fill: 85% 
    Primary pages: 4574, secondary pages: 2, swept pages: 2 
    Empty pages: 34, full pages: 4532 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4532 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 150.18, total records: 163410 
    Average version length: 149.98, total versions: 1448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 8, data page slots: 5672 
    Data pages: 4048, average fill: 83% 
    Primary pages: 4045, secondary pages: 3, swept pages: 1 
    Empty pages: 25, full pages: 4015 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4016 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 169261 
    Average version length: 151.11, total versions: 2349, 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: 6, data page slots: 5568 
    Data pages: 4208, average fill: 83% 
    Primary pages: 4205, secondary pages: 3, swept pages: 1 
    Empty pages: 41, full pages: 4150 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4149 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.84, total records: 155735 
    Average version length: 152.86, total versions: 3396, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 5344 
    Data pages: 3856, average fill: 83% 
    Primary pages: 3854, secondary pages: 2, swept pages: 3 
    Empty pages: 29, full pages: 3816 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3816 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.87, total records: 167571 
    Average version length: 152.57, total versions: 2789, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 5008 
    Data pages: 4168, average fill: 83% 
    Primary pages: 4165, secondary pages: 3, swept pages: 3 
    Empty pages: 42, full pages: 4111 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4109 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.40, total records: 2070746 
    Average version length: 52.84, total versions: 16324, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25544 
    Data pages: 25536, average fill: 70% 
    Primary pages: 25518, secondary pages: 18, swept pages: 12728 
    Empty pages: 131, full pages: 21191 
    Fill distribution: 
     0 - 19% = 296 
    20 - 39% = 308 
    40 - 59% = 986 
    60 - 79% = 23780 
    80 - 99% = 166 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2562, nodes: 2070746 
    Average node length: 5.44, total dup: 1931659, max dup: 1333 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180435, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 323 
        40 - 59% = 1650 
        60 - 79% = 286 
        80 - 99% = 298 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2070746 
    Average node length: 5.70, total dup: 1857793, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371369, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2451 
        60 - 79% = 265 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2098, nodes: 2070746 
    Average node length: 4.96, total dup: 2070646, max dup: 28205 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178371, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 212 
        40 - 59% = 1075 
        60 - 79% = 383 
        80 - 99% = 424 
 
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: 56.82, total records: 105791 
    Average version length: 69.18, total versions: 21745, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.22 
    Pointer pages: 3, data page slots: 4016 
    Data pages: 3048, average fill: 41% 
    Primary pages: 3048, secondary pages: 0, swept pages: 932 
    Empty pages: 432, full pages: 298 
    Fill distribution: 
     0 - 19% = 675 
    20 - 39% = 669 
    40 - 59% = 980 
    60 - 79% = 650 
    80 - 99% = 74 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105309, depth: 3, leaf buckets: 218, nodes: 105791 
    Average node length: 6.62, total dup: 91875, max dup: 14 
    Average key length: 4.03, compression ratio: 10.42 
    Average prefix length: 40.10, average data length: 1.90 
    Clustering factor: 18516, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 122 
        40 - 59% = 82 
        60 - 79% = 13 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 68.21, total records: 6714258 
    Average version length: 68.78, total versions: 82523, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 65, data page slots: 105208 
    Data pages: 105208, average fill: 68% 
    Primary pages: 105208, secondary pages: 0, swept pages: 72998 
    Empty pages: 53, full pages: 34267 
    Fill distribution: 
     0 - 19% = 386 
    20 - 39% = 1260 
    40 - 59% = 11594 
    60 - 79% = 91884 
    80 - 99% = 84 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10702, nodes: 6714258 
    Average node length: 6.51, total dup: 5807468, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1582121, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 2116 
        40 - 59% = 6171 
        60 - 79% = 2090 
        80 - 99% = 313 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8412, nodes: 6714258 
    Average node length: 5.41, total dup: 6440127, max dup: 126 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1402985, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1518 
        40 - 59% = 4648 
        60 - 79% = 1310 
        80 - 99% = 924 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8433, nodes: 6714258 
    Average node length: 5.41, total dup: 6440127, max dup: 126 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1405378, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1460 
        40 - 59% = 4711 
        60 - 79% = 1347 
        80 - 99% = 907 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.26, total records: 11856866 
    Average version length: 68.71, total versions: 134560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 107, data page slots: 174224 
    Data pages: 174224, average fill: 72% 
    Primary pages: 174223, secondary pages: 1, swept pages: 102686 
    Empty pages: 10, full pages: 125008 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 511 
    40 - 59% = 7114 
    60 - 79% = 165803 
    80 - 99% = 748 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18491, nodes: 11855692 
    Average node length: 6.61, total dup: 10339070, max dup: 55 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2440502, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2606 
        40 - 59% = 11177 
        60 - 79% = 4003 
        80 - 99% = 676 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 57.61, total records: 1199258 
    Average version length: 69.03, total versions: 123367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.19 
    Pointer pages: 27, data page slots: 43232 
    Data pages: 26848, average fill: 47% 
    Primary pages: 26774, secondary pages: 74, swept pages: 14380 
    Empty pages: 4483, full pages: 11562 
    Fill distribution: 
     0 - 19% = 6614 
    20 - 39% = 4310 
    40 - 59% = 3498 
    60 - 79% = 10963 
    80 - 99% = 1463 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1739, nodes: 1092366 
    Average node length: 5.56, total dup: 1047720, max dup: 49 
    Average key length: 2.59, compression ratio: 16.24 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 77522, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 760 
        40 - 59% = 773 
        60 - 79% = 192 
        80 - 99% = 5 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 56.41, total records: 773306 
    Average version length: 69.01, total versions: 31942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.23 
    Pointer pages: 20, data page slots: 32296 
    Data pages: 26496, average fill: 30% 
    Primary pages: 26496, secondary pages: 0, swept pages: 15025 
    Empty pages: 5054, full pages: 832 
    Fill distribution: 
     0 - 19% = 9505 
    20 - 39% = 7250 
    40 - 59% = 7560 
    60 - 79% = 2178 
    80 - 99% = 3 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1112, nodes: 642997 
    Average node length: 5.89, total dup: 595948, max dup: 49 
    Average key length: 2.96, compression ratio: 14.21 
    Average prefix length: 41.12, average data length: 0.88 
    Clustering factor: 86459, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 509 
        40 - 59% = 495 
        60 - 79% = 100 
        80 - 99% = 6 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.72, total records: 8996258 
    Average version length: 68.96, total versions: 174030, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 89, data page slots: 143648 
    Data pages: 143616, average fill: 67% 
    Primary pages: 143601, secondary pages: 15, swept pages: 81099 
    Empty pages: 352, full pages: 61498 
    Fill distribution: 
     0 - 19% = 1158 
    20 - 39% = 5800 
    40 - 59% = 20634 
    60 - 79% = 115082 
    80 - 99% = 942 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13435, nodes: 8994665 
    Average node length: 6.68, total dup: 7462044, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2045199, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1485 
        40 - 59% = 7072 
        60 - 79% = 4329 
        80 - 99% = 546 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21117763 
    Average version length: 82.91, total versions: 4435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319368 
    Data pages: 319368, average fill: 81% 
    Primary pages: 319364, secondary pages: 4, swept pages: 13837 
    Empty pages: 32, full pages: 318312 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 41 
    40 - 59% = 149 
    60 - 79% = 49074 
    80 - 99% = 270053 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19196, nodes: 21117763 
    Average node length: 5.72, total dup: 20637472, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278619, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1 
        40 - 59% = 7803 
        60 - 79% = 524 
        80 - 99% = 10858 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17139, nodes: 21117763 
    Average node length: 6.31, total dup: 18559010, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914438, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 774 
        60 - 79% = 261 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20966, nodes: 21117763 
    Average node length: 6.35, total dup: 18476959, max dup: 23 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571525, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8064 
        60 - 79% = 598 
        80 - 99% = 12294 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15980, nodes: 21117763 
    Average node length: 5.56, total dup: 21117663, max dup: 229974 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943250, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 10 
        40 - 59% = 2697 
        60 - 79% = 358 
        80 - 99% = 12912 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.56, total records: 10079268 
    Average version length: 82.59, total versions: 804239, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 105, data page slots: 170384 
    Data pages: 170344, average fill: 74% 
    Primary pages: 170316, secondary pages: 28, swept pages: 35901 
    Empty pages: 357, full pages: 135635 
    Fill distribution: 
     0 - 19% = 1055 
    20 - 39% = 4412 
    40 - 59% = 14912 
    60 - 79% = 112673 
    80 - 99% = 37292 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11350, nodes: 10079268 
    Average node length: 5.35, total dup: 9768246, max dup: 223 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2280630, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 20 
        40 - 59% = 7163 
        60 - 79% = 3962 
        80 - 99% = 203 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13627, nodes: 10079268 
    Average node length: 6.22, total dup: 8359250, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1610884, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 3444 
        40 - 59% = 4553 
        60 - 79% = 2735 
        80 - 99% = 2740 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12667, nodes: 10079268 
    Average node length: 5.96, total dup: 8767192, max dup: 45 
    Average key length: 2.83, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2483748, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 8096 
        60 - 79% = 4301 
        80 - 99% = 241 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10288, nodes: 10079268 
    Average node length: 5.13, total dup: 10079168, max dup: 154158 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1629097, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1042 
        40 - 59% = 5080 
        60 - 79% = 1830 
        80 - 99% = 2296 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.96, total records: 11173251 
    Average version length: 82.61, total versions: 204420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193096 
    Data pages: 191808, average fill: 71% 
    Primary pages: 191691, secondary pages: 117, swept pages: 72174 
    Empty pages: 2909, full pages: 143658 
    Fill distribution: 
     0 - 19% = 5085 
    20 - 39% = 7913 
    40 - 59% = 17980 
    60 - 79% = 100042 
    80 - 99% = 60788 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13135, nodes: 11173251 
    Average node length: 5.30, total dup: 11063745, max dup: 670 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2338812, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 9586 
        60 - 79% = 3255 
        80 - 99% = 140 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10391, nodes: 11173251 
    Average node length: 5.49, total dup: 10684462, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 713686, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 885 
        40 - 59% = 2552 
        60 - 79% = 1831 
        80 - 99% = 4947 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11173251 
    Average node length: 6.03, total dup: 9745705, max dup: 89 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2355146, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 177 
        40 - 59% = 11140 
        60 - 79% = 3532 
        80 - 99% = 161 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10650, nodes: 11173251 
    Average node length: 5.22, total dup: 11173151, max dup: 210535 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 702203, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 846 
        40 - 59% = 4652 
        60 - 79% = 1538 
        80 - 99% = 3514 
 
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: 77.33, total records: 10132265 
    Average version length: 82.89, total versions: 743488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 107, data page slots: 174224 
    Data pages: 174160, average fill: 73% 
    Primary pages: 174134, secondary pages: 26, swept pages: 38510 
    Empty pages: 289, full pages: 133165 
    Fill distribution: 
     0 - 19% = 1068 
    20 - 39% = 5725 
    40 - 59% = 19615 
    60 - 79% = 113125 
    80 - 99% = 34627 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12065, nodes: 10132265 
    Average node length: 5.18, total dup: 10103230, max dup: 2724 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2083177, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1354 
        40 - 59% = 7982 
        60 - 79% = 2056 
        80 - 99% = 643 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13790, nodes: 10132265 
    Average node length: 6.24, total dup: 8404220, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1573015, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 200 
        20 - 39% = 3521 
        40 - 59% = 4589 
        60 - 79% = 2728 
        80 - 99% = 2752 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12679, nodes: 10132265 
    Average node length: 5.43, total dup: 9684730, max dup: 133 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2221344, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1339 
        40 - 59% = 8839 
        60 - 79% = 1832 
        80 - 99% = 647 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10437, nodes: 10132265 
    Average node length: 5.15, total dup: 10132165, max dup: 156196 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1640224, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1085 
        40 - 59% = 5255 
        60 - 79% = 1779 
        80 - 99% = 2270 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.97, total records: 579924 
    Average version length: 68.64, total versions: 11782, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 76% 
    Primary pages: 8016, secondary pages: 0, swept pages: 2360 
    Empty pages: 1, full pages: 7909 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 17 
    60 - 79% = 7746 
    80 - 99% = 251 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40110, depth: 3, leaf buckets: 732, nodes: 579924 
    Average node length: 5.95, total dup: 493968, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102019, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 503 
        60 - 79% = 108 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35456, depth: 3, leaf buckets: 755, nodes: 579924 
    Average node length: 6.15, total dup: 475719, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102075, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 530 
        60 - 79% = 99 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 572, nodes: 579924 
    Average node length: 4.86, total dup: 579824, max dup: 9914 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90583, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 333 
        60 - 79% = 77 
        80 - 99% = 125 
 
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 Mon Mar 11 04:10:43 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7709042 35575 1 0.0000 0.0000
DOC_LIST 2229105 21811 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2555 7 600.0000 0.0000
INVNT_TURNOVER_LOG 81897 67126 1 0.0000 0.0000
MONEY_SALDO 49 143 5 200.0000 0.0000
MONEY_TURNOVER_LOG 1216 1041 1 0.0000 0.0000
PDISTR 785718 9796 2 0.0000 0.0000
PERF_SPLIT_0 153847 6012 1 0.0000 0.0000
PERF_SPLIT_1 146951 4093 1 0.0000 0.0000
PERF_SPLIT_2 147952 1876 1 0.0000 0.0000
PERF_SPLIT_3 181472 22470 1 0.0000 0.0000
PERF_SPLIT_4 148704 862 1 0.0000 0.0000
PERF_SPLIT_5 184304 29574 1 0.0000 0.0000
PERF_SPLIT_6 163410 1448 1 0.0000 0.0000
PERF_SPLIT_7 169261 2349 1 0.0000 0.0000
PERF_SPLIT_8 155735 3396 1 0.0000 0.0000
PERF_SPLIT_9 167571 2789 1 0.0000 0.0000
PSTORNED 2070746 16324 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 105791 21745 1 0.0000 0.0000
XQD_1000_3300 6714258 82523 1 0.0000 0.0000
XQD_1200_2000 11856866 134560 1 0.0000 0.0000
XQD_2000_3300 1199258 123367 1 0.0000 0.0000
XQD_2100_3300 773306 31942 1 0.0000 0.0000
XQD_3300_3400 8996258 174030 1 0.0000 0.0000
XQS_1000_1200 21117763 4435 1 0.0000 0.0000
XQS_1000_3300 10079268 804239 1 0.0000 0.0000
XQS_1200_2000 11173251 204420 1 0.0000 0.0000
XQS_2100_3300 10132265 743488 1 0.0000 0.0000
XQS_3300_3400 579924 11782 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 ---
:671: 
:672: mscs-test-161.budzdorov.ru    Mon Mar 11 04:08:23 2024
:673:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:674: 
--- end of diff output ---

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

11.03.24 04:10:55. 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-11 04:10:57 No severe PSQL-related problems occured
11.03.24 04:10:59. End of report.