Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.03.2024 10: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 15504936 kB
MemAvailable 30236860 kB
Buffers 0 kB
Cached 16218256 kB
SwapCached 2456 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-28 10:07:50
DTS_END                         2024-03-28 10:07:50.7570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37282
TRN_ID                          175121
ATT_ID                          575
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: 8936.92 20538 893692
customer order: creation 184.03 399 18403
customer order: refuse 15.87 449 1587
order to supplier: creation 48.29 1332 4829
order to supplier: removal 3.46 80857 346
invoice (draft): creation 49.42 3374 4942
invoice (draft): removal 46.77 652 4677
invoice accept: apply 44.00 20088 4400
invoice accept: cancel 41.63 858 4163
customer reserve: creation 4146.59 195 414659
customer reserve: removal 4053.79 56 405379
realization accept: apply 89.82 230 8982
realization accept: cancel 75.33 115 7533
payment from customer: creation 62.45 127 6245
payment from customer: removal 6.33 114 633
payment to supplier: creation 53.70 161 5370
payment to supplier: removal 3.82 232 382
service: total inventory turnovers 4.17 3770 417
service: total monetary turnovers 6.42 596 642
service: aggregate perf. data 0.99 14116 99
service: refresh index statistics 0.04 283038 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-03-2024 10:09:39 to 28-03-2024 10:09:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2799
TEST_TIME 2 2562
TEST_TIME 3 4743
TEST_TIME 4 4266
TEST_TIME 5 4137
TEST_TIME 6 4762
TEST_TIME 7 5314
TEST_TIME 8 5399
TEST_TIME 9 6137
TEST_TIME 10 6350
TEST_TIME 11 6496
TEST_TIME 12 6847
TEST_TIME 13 7148
TEST_TIME 14 7471
TEST_TIME 15 7436
TEST_TIME 16 7405
TEST_TIME 17 7683
TEST_TIME 18 7783
TEST_TIME 19 7972
TEST_TIME 20 8386
TEST_TIME 21 8612
TEST_TIME 22 8773
TEST_TIME 23 9102
TEST_TIME 24 9818
TEST_TIME 25 9789
TEST_TIME 26 9437
TEST_TIME 27 9336
TEST_TIME 28 9540
TEST_TIME 29 9303
TEST_TIME 30 9445
TEST_TIME 31 9327
TEST_TIME 32 9398
TEST_TIME 33 9357
TEST_TIME 34 9378
TEST_TIME 35 9410
TEST_TIME 36 9337
TEST_TIME 37 9440
TEST_TIME 38 9638
TEST_TIME 39 9617
TEST_TIME 40 9702
TEST_TIME 41 9577
TEST_TIME 42 9743
TEST_TIME 43 9526
TEST_TIME 44 9453
TEST_TIME 45 9403
TEST_TIME 46 9266
TEST_TIME 47 9249
TEST_TIME 48 9240
TEST_TIME 49 9201
TEST_TIME 50 9259
TEST_TIME 51 9226
TEST_TIME 52 9289
TEST_TIME 53 9229
TEST_TIME 54 9269
TEST_TIME 55 9180
TEST_TIME 56 9253
TEST_TIME 57 9156
TEST_TIME 58 9115
TEST_TIME 59 9047
TEST_TIME 60 8987
TEST_TIME 61 8935
TEST_TIME 62 8949
TEST_TIME 63 8908
TEST_TIME 64 8975
TEST_TIME 65 8998
TEST_TIME 66 8982
TEST_TIME 67 9044
TEST_TIME 68 9074
TEST_TIME 69 9061
TEST_TIME 70 9207
TEST_TIME 71 9198
TEST_TIME 72 9176
TEST_TIME 73 9224
TEST_TIME 74 9386
TEST_TIME 75 9277
TEST_TIME 76 9173
TEST_TIME 77 9142
TEST_TIME 78 9134
TEST_TIME 79 9089
TEST_TIME 80 9096
TEST_TIME 81 9039
TEST_TIME 82 9103
TEST_TIME 83 9053
TEST_TIME 84 9069
TEST_TIME 85 9128
TEST_TIME 86 9119
TEST_TIME 87 9137
TEST_TIME 88 9108
TEST_TIME 89 9172
TEST_TIME 90 9193
TEST_TIME 91 9201
TEST_TIME 92 9176
TEST_TIME 93 9206
TEST_TIME 94 9140
TEST_TIME 95 9078
TEST_TIME 96 9039
TEST_TIME 97 9020
TEST_TIME 98 9016
TEST_TIME 99 8971
TEST_TIME 100 8942

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 28-03-2024 10:09:42 to 28-03-2024 10:09:46.

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 1273510 1273510 0 0.00 0 20697 7 0 0
doc_list_biud 1273510 1273510 0 0.00 0 52118 23 0 0
sp_add_invoice_to_stock 4502 4400 102 2.26 44 158854 20088 0 102
sp_cancel_adding_invoice 4163 4163 0 0.00 3 75600 859 0 0
sp_cancel_client_order 1587 1587 0 0.00 4 36410 449 0 0
sp_cancel_customer_reserve 405379 405379 0 0.00 0 52119 56 0 0
sp_cancel_pay_from_customer 633 633 0 0.00 2 7238 114 0 0
sp_cancel_pay_to_supplier 382 382 0 0.00 2 46246 232 0 0
sp_cancel_supplier_invoice 4685 4677 8 0.17 1 39154 652 0 8
sp_cancel_supplier_order 346 346 0 0.00 20 873581 80857 0 0
sp_cancel_write_off 7533 7533 0 0.00 1 9470 115 0 0
sp_client_order 18403 18403 0 0.00 3 50350 399 0 0
sp_customer_reserve 414659 414659 0 0.00 0 58057 196 0 0
sp_fill_shopping_cart 28156 28156 0 0.00 1 16554 39 0 0
sp_fill_shopping_cart_clo_res 414654 414654 0 0.00 0 10870 15 0 0
sp_get_clo_for_invoice 4395 4395 0 0.00 0 20151 368 0 0
sp_kill_cost_storno 12711 12711 0 0.00 0 10759 67 0 0
sp_kill_qstorno_ret_qs2qd 823314 823314 0 0.00 0 52116 30 0 0
sp_kill_qty_storno 437062 437062 0 0.00 0 52118 67 0 0
sp_lock_selected_doc 18601 18601 0 0.00 0 6851 4 0 0
sp_make_cost_storno 24992 24992 0 0.00 0 20614 73 0 0
sp_multiply_rows_for_pdistr 24992 24992 0 0.00 0 17331 33 0 0
sp_multiply_rows_for_qdistr 18403 18403 0 0.00 0 17489 189 0 0
sp_pay_from_customer 6245 6245 0 0.00 4 29922 127 0 0
sp_pay_to_supplier 5370 5370 0 0.00 4 53942 162 0 0
sp_payment_common 11615 11615 0 0.00 1 8283 20 0 0
sp_qd_handle_on_cancel_clo 1587 1587 0 0.00 0 20778 388 0 0
sp_qd_handle_on_invoice_upd_sts 8558 8558 0 0.00 0 45324 327 0 0
sp_qd_handle_on_reserve_upd_sts 8982 8982 0 0.00 0 22200 68 0 0
sp_reserve_write_off 8982 8982 0 0.00 6 57915 231 0 0
sp_supplier_invoice 4942 4942 0 0.00 7 82805 3375 0 0
sp_supplier_order 4829 4829 0 0.00 5 53039 1332 0 0
srv_aggregate_perf_data 99 99 0 0.00 1276 150731 14116 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1224 119613 41384 0 0
srv_find_qd_qs_mism 848979 848979 0 0.00 0 9457 6 0 0
srv_make_invnt_saldo 417 417 0 0.00 39 89707 3771 0 0
srv_make_money_saldo 642 642 0 0.00 0 11846 597 0 0
srv_recalc_idx_stat 4 4 0 0.00 221556 402205 283039 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4402 4402 0 0.00 0 10174 171 0 0
t$perf-norm:sp_cancel_adding_invoice 355 355 0 0.00 0 3824 101 0 0
t$perf-norm:sp_cancel_client_order 1587 1587 0 0.00 0 986 9 0 0
t$perf-norm:sp_cancel_customer_reserve 639 639 0 0.00 0 2082 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 633 633 0 0.00 0 1978 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 382 382 0 0.00 0 1102 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 367 367 0 0.00 0 1379 17 0 0
t$perf-norm:sp_cancel_supplier_order 346 346 0 0.00 0 14827 1559 0 0
t$perf-norm:sp_cancel_write_off 915 915 0 0.00 0 1467 5 0 0
t$perf-norm:sp_client_order 18403 18403 0 0.00 0 12433 18 0 0
t$perf-norm:sp_customer_reserve 957 957 0 0.00 0 480 4 0 0
t$perf-norm:sp_pay_from_customer 6245 6245 0 0.00 0 3458 8 0 0
t$perf-norm:sp_pay_to_supplier 5370 5370 0 0.00 0 5199 12 0 0
t$perf-norm:sp_reserve_write_off 8982 8982 0 0.00 0 10977 11 0 0
t$perf-norm:sp_supplier_invoice 4942 4942 0 0.00 0 6469 18 0 0
t$perf-norm:sp_supplier_order 4829 4829 0 0.00 0 4887 17 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 204 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 962 27 0 0
t$perf-norm:srv_make_invnt_saldo 417 417 0 0.00 0 4953 31 0 0
t$perf-norm:srv_make_money_saldo 642 642 0 0.00 0 1916 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 73 27 0 0
v_add_invoice_to_stock 8994 8790 204 2.26 0 57781 29 0 204
v_all_customers 33938 33938 0 0.00 0 27 1 0 0
v_all_suppliers 27758 27758 0 0.00 0 102 1 0 0
v_all_wares 36804 36804 0 0.00 0 32 1 0 0
v_cancel_adding_invoice 710 710 0 0.00 0 368 7 0 0
v_cancel_client_order 3174 3174 0 0.00 0 36284 20 0 0
v_cancel_customer_prepayment 1266 1266 0 0.00 0 1965 6 0 0
v_cancel_customer_reserve 1278 1278 0 0.00 0 967 4 0 0
v_cancel_payment_to_supplier 764 764 0 0.00 0 46131 89 0 0
v_cancel_supplier_invoice 750 734 16 2.13 0 1935 16 0 16
v_cancel_supplier_order 692 692 0 0.00 0 15205 26 0 0
v_cancel_write_off 1830 1830 0 0.00 0 2352 15 0 0
v_max_id_clo_ord 4825 4825 0 0.00 0 2000 2 0 0
v_max_id_clo_res 957 957 0 0.00 0 2072 15 0 0
v_max_id_ord_sup 4928 4928 0 0.00 0 995 2 0 0
v_max_non_paid_invoice 1242 1242 0 0.00 0 138 2 0 0
v_max_non_paid_realizn 3155 3155 0 0.00 0 570 3 0 0
v_min_id_clo_ord 4825 4825 0 0.00 0 3695 7 0 0
v_min_id_clo_res 957 957 0 0.00 0 2685 5 0 0
v_min_id_ord_sup 4928 4928 0 0.00 0 3866 5 0 0
v_min_non_paid_invoice 5370 5370 0 0.00 0 4542 11 0 0
v_min_non_paid_realizn 6245 6245 0 0.00 0 8280 17 0 0
v_our_firm 9046 9046 0 0.00 0 26 1 0 0
v_reserve_write_off 17964 17964 0 0.00 0 57790 14 0 0
x_lock_depdocs_on_canc_invoice 8473 8473 0 0.00 0 14255 112 0 0
x_lock_depdocs_on_canc_sup_ord 346 346 0 0.00 0 11433 296 0 0
x_make_qstorno_1000_1200 4829 4829 0 0.00 1 53031 1249 0 0
x_make_qstorno_1200_2000 4942 4942 0 0.00 3 82769 3233 0 0
x_make_qstorno_2100_3300 414659 414659 0 0.00 0 58055 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2024 10:09:47 to 28-03-2024 10:09:51.

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
08:07:54 4 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:55 24237 8192000000 9699895040 9999859712 783099600 8.725 100 89 178 0 812226928 7280256 21847072
08:10:24 15159 8192000000 9745730752 10053410816 821726096 9.116 100 89 178 0 854265168 12064816 20474256
08:11:45 22011 8192000000 9780672880 10099003392 848490096 9.385 100 83 166 0 886517296 19703488 18323712
08:13:10 16317 8192000000 9852720512 10184593408 883562240 9.735 100 84 168 0 956046208 54327616 18156352
08:14:30 8439 8192000000 9893572064 10232893440 925117168 10.147 100 76 152 0 1000139392 59104288 15917936
08:15:43 3194 8192000000 9917445648 10266972160 966243456 10.550 100 76 149 0 1022048864 41251632 14553776
08:16:50 2421 8192000000 9966039920 10325237760 993579200 10.816 100 81 160 0 1084232016 75525744 15127072
08:17:55 2427 8192000000 9997632096 10364674048 1016733184 11.040 100 84 168 0 1111896416 79463824 15699408
08:18:59 1946 8192000000 10030943968 10404093952 1030321568 11.172 100 81 158 2 1143201392 97935392 14944432
08:20:04 961 8192000000 10043520896 10421534720 1054227008 11.401 100 85 170 1 1162293872 91007360 17059504
08:21:08 1997 8192000000 10029049584 10407129088 1059101968 11.448 100 82 162 0 1139570800 64589008 15879824
08:22:12 17766 8192000000 10016386352 10413568000 1063236320 11.487 100 46 93 1 1135524448 61899920 10388208
08:23:33 5021 8192000000 10002651104 10392559616 1070997392 11.562 100 50 100 0 1113348336 32330064 10020880
08:24:39 6966 8192000000 9983829120 10382761984 1078659200 11.635 100 33 66 0 1104014560 18719712 6635648
08:25:48 48037 8192000000 9999692928 10404999168 1086699392 11.711 100 46 91 1 1116247968 19686320 9862256
08:27:37 4353 8192000000 10018117760 10421202944 1083904800 11.685 100 44 90 0 1136044992 42730768 9409424
08:28:46 10248 8192000000 10016409712 10419961856 1097053456 11.810 100 35 70 1 1128261984 23302832 7905696
08:30:04 12383 8192000000 10064976320 10469552128 1107159184 11.906 100 56 116 0 1178710000 59976000 11574816
08:31:21 64790 8192000000 10092060576 10503786496 1110369616 11.936 99 37 72 1 1188285712 70112480 7803616
08:33:35 9894 8192000000 10102786736 10517405696 1116521168 11.994 100 45 90 0 1214469520 89105392 8842960
08:34:48 6650 8192000000 10135802720 10537005056 1109723744 11.930 99 63 121 2 1233289936 112035392 11530800
08:35:57 8102 8192000000 10118400800 10514624512 1088143504 11.725 99 60 119 0 1213014688 112590928 12280256
08:37:13 31062 8192000000 10084571472 10512109568 1079707600 11.645 98 41 82 0 1190570208 102470096 8392512
08:38:49 5391 8192000000 10086909552 10486759424 1092495216 11.766 100 51 98 0 1191495952 88509792 10490944
08:39:58 6742 8192000000 10082410640 10476564480 1076422160 11.613 98 68 127 1 1175700464 86544160 12734144
08:41:10 3773 8192000000 10113061056 10497003520 1075318896 11.603 100 76 149 0 1213868496 123248576 15301024
08:42:17 2664 8192000000 10131935424 10525315072 1092776880 11.769 100 64 128 0 1232964384 126784240 13403264
08:43:22 3150 8192000000 10207516112 10596499456 1098077360 11.819 100 78 156 2 1300119248 185744800 16297088
08:44:28 1761 8192000000 10201015760 10596589568 1077665024 11.625 99 68 135 0 1299833936 207490000 14678912
08:45:37 1222 8192000000 10255924128 10649001984 1108702912 11.920 100 74 142 0 1349356432 224787632 15865888
08:46:41 2340 8192000000 10232430976 10633920512 1120547104 12.032 100 74 147 0 1337919424 201324576 16047744
08:47:46 6931 8192000000 10243463648 10653691904 1132245264 12.143 100 61 117 2 1343732560 199282928 12204368
08:48:58 12189 8192000000 10261568624 10700775424 1127718016 12.100 100 32 62 0 1358184976 223366112 7100848
08:50:15 21422 8192000000 10174707536 10608836608 1105512400 11.890 99 17 32 0 1276782160 167457168 3812592
08:51:42 36487 8192000000 10079002352 10558496768 1107206208 11.906 99 14 28 0 1199053424 88496080 3351136
08:53:19 60825 8192000000 10076884832 10504224768 1120329184 12.030 100 30 58 1 1173802976 46960864 6512928
08:55:22 44456 8192000000 10054383776 10532020224 1124932528 12.074 100 10 20 0 1164732608 37904304 1895776
08:57:09 119611 8192000000 10091865792 10595512320 1124239200 12.067 99 14 28 0 1195714576 68672592 2802784
09:00:10 40639 8192000000 10073331168 10525057024 1133087072 12.150 100 13 26 1 1167709696 32207136 2415488
09:02:04 36784 8192000000 10073427904 10527469568 1113031120 11.961 98 31 62 0 1165863680 46659040 6173520
09:03:46 103449 8192000000 10130463616 10614153216 1144671792 12.259 100 14 28 0 1219227504 71845568 2710144
09:06:31 93906 8192000000 10098173904 10543177728 1126803184 12.091 98 11 20 0 1171338896 42949024 1586688
09:09:32 83195 8192000000 10070521904 10499334144 1130303472 12.124 99 26 52 1 1168224176 32391168 5529536
09:11:59 103143 8192000000 10069903072 10499670016 1080439456 11.652 95 43 88 1 1115551440 25343088 9768896
09:14:48 14170 8192000000 10104015744 10527240192 1119445744 12.022 98 47 89 3 1184390896 55526112 9419040
09:16:04 80016 8192000000 10127293904 10626883584 1133863936 12.158 99 23 46 1 1241703280 102556896 5282448
09:18:27 42240 8192000000 10119131840 10566074368 1127831344 12.101 99 16 32 0 1217391488 86004848 3555296
09:20:11 37236 8192000000 10099517744 10589483008 1115509632 11.985 98 13 26 0 1186055264 68036496 2509136
09:22:14 56350 8192000000 10100096128 10591375360 1116662880 11.995 99 21 42 0 1215786720 94063072 5060768
09:24:15 50882 8192000000 10034280624 10492715008 1090237760 11.745 97 24 49 0 1122380128 27519072 4623296
09:26:07 62942 8192000000 10028264784 10505465856 1087003424 11.714 98 16 32 0 1126476656 36437232 3036000
09:28:16 53926 8192000000 10033630592 10485669888 1059055024 11.447 95 10 20 0 1112099664 50736288 2308352
09:30:33 47310 8192000000 10036688048 10473811968 1039307936 11.258 95 25 49 1 1090007136 46370416 4328784
09:32:21 38404 8192000000 10012540288 10428850176 1042259216 11.286 95 29 58 0 1077406432 29494096 5653120
09:34:03 14712 8192000000 10070725552 10489495552 1082464656 11.671 100 54 108 0 1176402176 83580464 10357056
09:35:18 31984 8192000000 10038809920 10467139584 1057523184 11.433 98 28 56 1 1112620976 49849920 5247872
09:37:16 51838 8192000000 10047595152 10525003776 1089240256 11.735 99 9 18 0 1160037024 68875120 1921648
09:39:08 29347 8192000000 10067096480 10487746560 1116873328 11.997 100 36 71 0 1160139728 36773984 6492416
09:40:40 46768 8192000000 10082010560 10608857088 1092376976 11.765 98 15 29 1 1189521808 94542000 2602832
09:43:06 37451 8192000000 10030973440 10447433728 1093696080 11.778 98 56 110 0 1113252336 8182464 11373792
09:44:45 52500 8192000000 10069018464 10521104384 1119739600 12.025 100 13 26 0 1176089712 54142448 2207664
09:46:39 38930 8192000000 10042329392 10489294848 1112691440 11.958 99 17 36 0 1157949888 42351872 2906576
09:48:24 36994 8192000000 10099870832 10525106176 1121218304 12.038 99 36 68 1 1172692512 44779552 6694656
09:50:11 36954 8192000000 10087867040 10513575936 1112215792 11.953 98 28 55 0 1176981824 59580208 5185824
09:51:54 69702 8192000000 10087519552 10578432000 1121559712 12.042 99 20 40 0 1193614880 67843904 4211264
09:54:05 53653 8192000000 10073588688 10522492928 1122672304 12.052 99 10 20 1 1156772240 32375120 1724816
09:56:00 65474 8192000000 10093521424 10581602304 1112596528 11.957 98 13 26 0 1177251552 62412896 2242128
09:58:08 85529 8192000000 10081279520 10534789120 1130428000 12.125 99 23 46 0 1179117984 44718144 3971840
10:00:38 114862 8192000000 10060758336 10503704576 1102059856 11.857 97 34 68 0 1154994688 46223136 6711696
10:03:36 37918 8192000000 10053507136 10502086656 1113489488 11.965 98 12 22 1 1155815744 40410416 1915840
10:05:24 37053 8192000000 10048519280 10523688960 1101566912 11.853 98 9 18 0 1134018848 30613856 1838080
10:07:08 59062 8192000000 9357852144 9696464896 481642240 5.552 43 12 24 0 526178688 41899392 2637056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 28-03-2024 10:09:53 to 28-03-2024 10:10:07.

Exceptions occured during test was in run

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

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

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          175120
MON$OLDEST_ACTIVE               175719
MON$OLDEST_SNAPSHOT             175719
MON$NEXT_TRANSACTION            175719
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                       1938720
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             693
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 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 Thu Mar 28 10:10:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        92029 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175120 
    Oldest active        175719 
    Oldest snapshot        175719 
    Next transaction    175720 
    Sequence number        0 
    Next attachment ID    693 
    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.70, total records: 7751275 
    Average version length: 48.17, total versions: 37817, 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: 89664 
    Data pages: 89664, average fill: 69% 
    Primary pages: 89663, secondary pages: 1, swept pages: 47612 
    Empty pages: 10, full pages: 64941 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 84 
    40 - 59% = 3638 
    60 - 79% = 85904 
    80 - 99% = 22 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23150, nodes: 7751275 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1671545, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 311 
        20 - 39% = 1803 
        40 - 59% = 4001 
        60 - 79% = 2318 
        80 - 99% = 14717 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13475, nodes: 7751275 
    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: 1496547, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1617 
        40 - 59% = 1939 
        60 - 79% = 1054 
        80 - 99% = 8865 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8279, nodes: 7751275 
    Average node length: 6.62, total dup: 5792585, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1489626, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 963 
        40 - 59% = 1329 
        60 - 79% = 869 
        80 - 99% = 5011 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.02, total records: 2250293 
    Average version length: 58.88, total versions: 20273, 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: 29152 
    Data pages: 29152, average fill: 71% 
    Primary pages: 29151, secondary pages: 1, swept pages: 13313 
    Empty pages: 141, full pages: 17290 
    Fill distribution: 
     0 - 19% = 165 
    20 - 39% = 39 
    40 - 59% = 646 
    60 - 79% = 28246 
    80 - 99% = 56 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4539, nodes: 2250293 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 681863, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 972 
        40 - 59% = 756 
        60 - 79% = 695 
        80 - 99% = 2116 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2420, nodes: 2251228 
    Average node length: 4.97, total dup: 2250329, max dup: 19215 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1271793, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 197 
        40 - 59% = 1393 
        60 - 79% = 564 
        80 - 99% = 263 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1791, nodes: 2250293 
    Average node length: 4.97, total dup: 2250243, max dup: 130188 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074448, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 630 
        60 - 79% = 44 
        80 - 99% = 1115 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4336, nodes: 2250293 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 681863, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 618 
        40 - 59% = 598 
        60 - 79% = 782 
        80 - 99% = 2252 
 
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.40, total records: 400 
    Average version length: 23.58, total versions: 1870, max versions: 6 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 60% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 4, full pages: 14 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 11 
 
    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: 14.78, total records: 83179 
    Average version length: 68.26, total versions: 75075, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.96 
    Pointer pages: 8, data page slots: 2592 
    Data pages: 1648, average fill: 68% 
    Primary pages: 1647, secondary pages: 1, swept pages: 18 
    Empty pages: 263, full pages: 1081 
    Fill distribution: 
     0 - 19% = 336 
    20 - 39% = 49 
    40 - 59% = 83 
    60 - 79% = 209 
    80 - 99% = 971 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694980, depth: 3, leaf buckets: 238, nodes: 83179 
    Average node length: 13.51, total dup: 3372, max dup: 2 
    Average key length: 10.87, compression ratio: 2.48 
    Average prefix length: 19.09, average data length: 7.91 
    Clustering factor: 62268, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 115 
        60 - 79% = 106 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 149, 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: 67% 
    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: 11.77, total records: 1824 
    Average version length: 42.76, total versions: 1682, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.93 
    Pointer pages: 1, data page slots: 48 
    Data pages: 34, average fill: 56% 
    Primary pages: 33, secondary pages: 1, swept pages: 9 
    Empty pages: 9, full pages: 18 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91912, depth: 2, leaf buckets: 4, nodes: 1824 
    Average node length: 4.49, total dup: 1726, max dup: 165 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 1017, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.60, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.50, total records: 780847 
    Average version length: 37.89, total versions: 25196, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8496 
    Data pages: 8496, average fill: 63% 
    Primary pages: 8495, secondary pages: 1, swept pages: 3153 
    Empty pages: 30, full pages: 4162 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 131 
    40 - 59% = 1388 
    60 - 79% = 6861 
    80 - 99% = 58 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 874, nodes: 769181 
    Average node length: 4.88, total dup: 769132, max dup: 149277 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88383, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 157 
        40 - 59% = 504 
        60 - 79% = 135 
        80 - 99% = 78 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 919, nodes: 769181 
    Average node length: 5.88, total dup: 684986, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 154263, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 89 
        40 - 59% = 447 
        60 - 79% = 106 
        80 - 99% = 277 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 956, nodes: 769181 
    Average node length: 5.88, total dup: 684986, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156103, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 139 
        40 - 59% = 450 
        60 - 79% = 109 
        80 - 99% = 257 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1114, nodes: 769181 
    Average node length: 5.96, total dup: 684986, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 148888, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 251 
        40 - 59% = 613 
        60 - 79% = 185 
        80 - 99% = 63 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.99, total records: 5496 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.12, total fragments: 8, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 76, secondary pages: 12, swept pages: 57 
    Empty pages: 8, full pages: 57 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5496 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.55, average data length: 1.55 
    Clustering factor: 5190, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5496 
    Average node length: 11.10, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 177, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 80062 
    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: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 831 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 831 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37192, depth: 2, leaf buckets: 102, nodes: 80062 
    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: 3517, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 100 
 
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.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.07, total records: 161464 
    Average version length: 154.20, total versions: 2884, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4528 
    Data pages: 4016, average fill: 83% 
    Primary pages: 4014, secondary pages: 2, swept pages: 3 
    Empty pages: 36, full pages: 3965 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 3967 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.87, total records: 128575 
    Average version length: 136.24, total versions: 157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 3664 
    Data pages: 3192, average fill: 83% 
    Primary pages: 3191, secondary pages: 1, swept pages: 2 
    Empty pages: 27, full pages: 3151 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 8 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3151 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 147.75, total records: 152058 
    Average version length: 153.81, total versions: 3771, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 6, data page slots: 4104 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3790, secondary pages: 2, swept pages: 4 
    Empty pages: 26, full pages: 3721 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 21 
    40 - 59% = 17 
    60 - 79% = 1 
    80 - 99% = 3721 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.81, total records: 156249 
    Average version length: 152.92, total versions: 1685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 4328 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3871, secondary pages: 1, swept pages: 2 
    Empty pages: 25, full pages: 3838 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3838 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.73, total records: 153048 
    Average version length: 151.04, total versions: 717, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 8, data page slots: 4712 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3797, secondary pages: 3, swept pages: 2 
    Empty pages: 27, full pages: 3759 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3761 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.13, total records: 150148 
    Average version length: 153.45, total versions: 2294, 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: 4952 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3732, secondary pages: 4, swept pages: 3 
    Empty pages: 37, full pages: 3688 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3687 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 147.85, total records: 141269 
    Average version length: 152.67, total versions: 3307, 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: 5, data page slots: 4440 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3517, secondary pages: 3, swept pages: 1 
    Empty pages: 40, full pages: 3465 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 3467 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 151.32, total records: 154801 
    Average version length: 137.88, total versions: 129, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.21 
    Pointer pages: 7, data page slots: 4240 
    Data pages: 3832, average fill: 83% 
    Primary pages: 3830, secondary pages: 2, swept pages: 3 
    Empty pages: 21, full pages: 3801 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3800 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 138.58, total records: 152139 
    Average version length: 154.67, total versions: 13126, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.24 
    Pointer pages: 6, data page slots: 4768 
    Data pages: 3784, average fill: 84% 
    Primary pages: 3781, secondary pages: 3, swept pages: 2 
    Empty pages: 41, full pages: 3731 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3730 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 151.11, total records: 150065 
    Average version length: 139.11, total versions: 181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 6, data page slots: 3872 
    Data pages: 3744, average fill: 83% 
    Primary pages: 3742, secondary pages: 2, swept pages: 2 
    Empty pages: 45, full pages: 3685 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 3685 
 
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.29, total records: 2108262 
    Average version length: 52.88, total versions: 22016, 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: 25872 
    Data pages: 25872, average fill: 70% 
    Primary pages: 25856, secondary pages: 16, swept pages: 11948 
    Empty pages: 127, full pages: 21904 
    Fill distribution: 
     0 - 19% = 279 
    20 - 39% = 253 
    40 - 59% = 937 
    60 - 79% = 24220 
    80 - 99% = 183 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2610, nodes: 2108262 
    Average node length: 5.44, total dup: 1966804, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182747, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 287 
        40 - 59% = 1748 
        60 - 79% = 289 
        80 - 99% = 282 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2764, nodes: 2108262 
    Average node length: 5.69, total dup: 1892316, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377313, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2434 
        60 - 79% = 303 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2087, nodes: 2108262 
    Average node length: 4.96, total dup: 2108162, max dup: 27690 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180970, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 195 
        40 - 59% = 1024 
        60 - 79% = 385 
        80 - 99% = 482 
 
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: 45.46, total records: 138532 
    Average version length: 69.17, total versions: 54659, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.77 
    Pointer pages: 3, data page slots: 4696 
    Data pages: 3504, average fill: 48% 
    Primary pages: 3503, secondary pages: 1, swept pages: 570 
    Empty pages: 726, full pages: 1256 
    Fill distribution: 
     0 - 19% = 981 
    20 - 39% = 413 
    40 - 59% = 503 
    60 - 79% = 881 
    80 - 99% = 726 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556111, depth: 3, leaf buckets: 230, nodes: 138532 
    Average node length: 6.43, total dup: 120583, max dup: 14 
    Average key length: 3.96, compression ratio: 10.62 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 24167, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 72 
        40 - 59% = 105 
        60 - 79% = 45 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.74, total records: 6733297 
    Average version length: 68.82, total versions: 249420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 66, data page slots: 106952 
    Data pages: 106952, average fill: 68% 
    Primary pages: 106952, secondary pages: 0, swept pages: 45895 
    Empty pages: 8, full pages: 40122 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 1654 
    40 - 59% = 16558 
    60 - 79% = 88259 
    80 - 99% = 368 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10711, nodes: 6733297 
    Average node length: 6.51, total dup: 5825578, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1575415, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 2225 
        40 - 59% = 5922 
        60 - 79% = 2227 
        80 - 99% = 323 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8743, nodes: 6733297 
    Average node length: 5.40, total dup: 6460241, max dup: 172 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1387325, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1747 
        40 - 59% = 5084 
        60 - 79% = 1274 
        80 - 99% = 628 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8788, nodes: 6733297 
    Average node length: 5.40, total dup: 6460241, max dup: 172 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1389825, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1797 
        40 - 59% = 5061 
        60 - 79% = 1312 
        80 - 99% = 611 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.71, total records: 11866449 
    Average version length: 68.75, total versions: 244789, 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: 108, data page slots: 175384 
    Data pages: 175384, average fill: 72% 
    Primary pages: 175383, secondary pages: 1, swept pages: 90326 
    Empty pages: 5, full pages: 127158 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 1045 
    40 - 59% = 9335 
    60 - 79% = 163768 
    80 - 99% = 1158 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18508, nodes: 11865370 
    Average node length: 6.61, total dup: 10346037, max dup: 67 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2423393, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2587 
        40 - 59% = 11096 
        60 - 79% = 4163 
        80 - 99% = 638 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.31, total records: 1280168 
    Average version length: 69.03, total versions: 262574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.41 
    Pointer pages: 29, data page slots: 46576 
    Data pages: 28760, average fill: 48% 
    Primary pages: 28669, secondary pages: 91, swept pages: 12564 
    Empty pages: 5241, full pages: 13290 
    Fill distribution: 
     0 - 19% = 7729 
    20 - 39% = 3603 
    40 - 59% = 3165 
    60 - 79% = 10939 
    80 - 99% = 3324 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1848, nodes: 1184282 
    Average node length: 5.54, total dup: 1135761, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 81450, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 771 
        40 - 59% = 812 
        60 - 79% = 226 
        80 - 99% = 28 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 47.56, total records: 956033 
    Average version length: 69.05, total versions: 102705, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.65 
    Pointer pages: 22, data page slots: 35104 
    Data pages: 29856, average fill: 31% 
    Primary pages: 29853, secondary pages: 3, swept pages: 10150 
    Empty pages: 6539, full pages: 6110 
    Fill distribution: 
     0 - 19% = 11665 
    20 - 39% = 6474 
    40 - 59% = 7049 
    60 - 79% = 4590 
    80 - 99% = 78 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1185, nodes: 717201 
    Average node length: 5.84, total dup: 666704, max dup: 61 
    Average key length: 2.92, compression ratio: 14.40 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 94794, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 504 
        40 - 59% = 537 
        60 - 79% = 130 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.33, total records: 9225249 
    Average version length: 68.95, total versions: 236942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 92, data page slots: 148976 
    Data pages: 148944, average fill: 66% 
    Primary pages: 148924, secondary pages: 20, swept pages: 79469 
    Empty pages: 381, full pages: 65605 
    Fill distribution: 
     0 - 19% = 1296 
    20 - 39% = 5844 
    40 - 59% = 26715 
    60 - 79% = 113658 
    80 - 99% = 1431 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13504, nodes: 9221155 
    Average node length: 6.71, total dup: 7646132, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2068340, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1236 
        40 - 59% = 6848 
        60 - 79% = 4679 
        80 - 99% = 741 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21141254 
    Average version length: 82.88, total versions: 6956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 319880 
    Data pages: 319880, average fill: 81% 
    Primary pages: 319874, secondary pages: 6, swept pages: 14675 
    Empty pages: 57, full pages: 318264 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 73 
    40 - 59% = 197 
    60 - 79% = 49606 
    80 - 99% = 269903 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19556, nodes: 21141254 
    Average node length: 5.72, total dup: 20660507, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281176, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 3 
        40 - 59% = 8481 
        60 - 79% = 529 
        80 - 99% = 10534 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17176, nodes: 21141254 
    Average node length: 6.31, total dup: 18578899, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916522, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 781 
        60 - 79% = 285 
        80 - 99% = 16104 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21359, nodes: 21141254 
    Average node length: 6.35, total dup: 18498096, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575504, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8799 
        60 - 79% = 601 
        80 - 99% = 11950 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16063, nodes: 21141254 
    Average node length: 5.56, total dup: 21141154, max dup: 229029 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945432, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2863 
        60 - 79% = 331 
        80 - 99% = 12861 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.95, total records: 9632931 
    Average version length: 82.57, total versions: 192961, 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: 108, data page slots: 175464 
    Data pages: 175408, average fill: 68% 
    Primary pages: 175377, secondary pages: 31, swept pages: 101819 
    Empty pages: 564, full pages: 88833 
    Fill distribution: 
     0 - 19% = 1834 
    20 - 39% = 8291 
    40 - 59% = 31203 
    60 - 79% = 116359 
    80 - 99% = 17721 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11393, nodes: 9632931 
    Average node length: 5.38, total dup: 9325857, max dup: 174 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2198283, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 72 
        40 - 59% = 8436 
        60 - 79% = 2800 
        80 - 99% = 83 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13421, nodes: 9632931 
    Average node length: 6.25, total dup: 7984412, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1549636, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 4017 
        40 - 59% = 4149 
        60 - 79% = 2592 
        80 - 99% = 2544 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12724, nodes: 9632931 
    Average node length: 6.00, total dup: 8357396, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2379182, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 95 
        40 - 59% = 9458 
        60 - 79% = 3076 
        80 - 99% = 92 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10005, nodes: 9632931 
    Average node length: 5.15, total dup: 9632831, max dup: 159046 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1599433, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1240 
        40 - 59% = 4861 
        60 - 79% = 1640 
        80 - 99% = 2216 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.41, total records: 11232691 
    Average version length: 82.51, total versions: 137297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 120, data page slots: 194544 
    Data pages: 193112, average fill: 71% 
    Primary pages: 192977, secondary pages: 135, swept pages: 76503 
    Empty pages: 2845, full pages: 141851 
    Fill distribution: 
     0 - 19% = 4884 
    20 - 39% = 7697 
    40 - 59% = 19779 
    60 - 79% = 98903 
    80 - 99% = 61849 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13129, nodes: 11232691 
    Average node length: 5.31, total dup: 11123275, max dup: 646 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2363029, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 113 
        40 - 59% = 9426 
        60 - 79% = 3467 
        80 - 99% = 123 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10368, nodes: 11232691 
    Average node length: 5.50, total dup: 10741829, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 737382, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 869 
        40 - 59% = 2483 
        60 - 79% = 1822 
        80 - 99% = 5043 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15012, nodes: 11232691 
    Average node length: 6.03, total dup: 9799253, max dup: 75 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2379359, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 153 
        40 - 59% = 10971 
        60 - 79% = 3719 
        80 - 99% = 167 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10729, nodes: 11232691 
    Average node length: 5.23, total dup: 11232591, max dup: 208516 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 725544, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 847 
        40 - 59% = 4777 
        60 - 79% = 1534 
        80 - 99% = 3486 
 
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: 81.23, total records: 9758941 
    Average version length: 82.88, total versions: 199751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 110, data page slots: 179352 
    Data pages: 179280, average fill: 67% 
    Primary pages: 179253, secondary pages: 27, swept pages: 106248 
    Empty pages: 663, full pages: 88533 
    Fill distribution: 
     0 - 19% = 2076 
    20 - 39% = 9186 
    40 - 59% = 32538 
    60 - 79% = 117782 
    80 - 99% = 17698 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11898, nodes: 9758941 
    Average node length: 5.20, total dup: 9729572, max dup: 1865 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2017379, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1531 
        40 - 59% = 7931 
        60 - 79% = 1877 
        80 - 99% = 529 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13539, nodes: 9758941 
    Average node length: 6.27, total dup: 8088304, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1520861, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 3914 
        40 - 59% = 4219 
        60 - 79% = 2548 
        80 - 99% = 2701 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12569, nodes: 9758941 
    Average node length: 5.46, total dup: 9318334, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2146841, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1492 
        40 - 59% = 8841 
        60 - 79% = 1697 
        80 - 99% = 504 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10266, nodes: 9758941 
    Average node length: 5.17, total dup: 9758841, max dup: 161623 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1624628, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1331 
        40 - 59% = 5121 
        60 - 79% = 1543 
        80 - 99% = 2234 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.68, total records: 579862 
    Average version length: 68.78, total versions: 4885, 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: 5, data page slots: 8144 
    Data pages: 8144, average fill: 75% 
    Primary pages: 8144, secondary pages: 0, swept pages: 3891 
    Empty pages: 4, full pages: 6798 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 6 
    40 - 59% = 160 
    60 - 79% = 7890 
    80 - 99% = 83 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40720, depth: 3, leaf buckets: 741, nodes: 579862 
    Average node length: 5.95, total dup: 493787, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101365, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 534 
        60 - 79% = 86 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32732, depth: 3, leaf buckets: 765, nodes: 579862 
    Average node length: 6.15, total dup: 475616, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101412, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 538 
        60 - 79% = 89 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 544, nodes: 579862 
    Average node length: 4.86, total dup: 579762, max dup: 9544 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90215, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 291 
        60 - 79% = 65 
        80 - 99% = 160 
 
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 Thu Mar 28 10:10:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7751275 37817 1 0.0000 0.0000
DOC_LIST 2250293 20273 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1870 6 400.0000 0.0000
INVNT_TURNOVER_LOG 83179 75075 1 0.0000 0.0000
MONEY_SALDO 49 149 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1824 1682 1 0.0000 0.0000
PDISTR 780847 25196 3 0.0000 0.0000
PERF_SPLIT_0 161464 2884 1 0.0000 0.0000
PERF_SPLIT_1 128575 157 1 0.0000 0.0000
PERF_SPLIT_2 152058 3771 1 0.0000 0.0000
PERF_SPLIT_3 156249 1685 1 0.0000 0.0000
PERF_SPLIT_4 153048 717 1 0.0000 0.0000
PERF_SPLIT_5 150148 2294 1 0.0000 0.0000
PERF_SPLIT_6 141269 3307 1 0.0000 0.0000
PERF_SPLIT_7 154801 129 1 0.0000 0.0000
PERF_SPLIT_8 152139 13126 1 0.0000 0.0000
PERF_SPLIT_9 150065 181 1 0.0000 0.0000
PSTORNED 2108262 22016 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 138532 54659 1 0.0000 0.0000
XQD_1000_3300 6733297 249420 1 0.0000 0.0000
XQD_1200_2000 11866449 244789 1 0.0000 0.0000
XQD_2000_3300 1280168 262574 1 0.0000 0.0000
XQD_2100_3300 956033 102705 1 0.0000 0.0000
XQD_3300_3400 9225249 236942 1 0.0000 0.0000
XQS_1000_1200 21141254 6956 1 0.0000 0.0000
XQS_1000_3300 9632931 192961 1 0.0000 0.0000
XQS_1200_2000 11232691 137297 1 0.0000 0.0000
XQS_2100_3300 9758941 199751 1 0.0000 0.0000
XQS_3300_3400 579862 4885 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 ---
:115: 
:116: mscs-test-161.budzdorov.ru    Thu Mar 28 10:08:11 2024
:117:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:118: 
:119: 
:120: mscs-test-161.budzdorov.ru    Thu Mar 28 10:08:11 2024
:121:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:122: 
--- end of diff output ---

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

28.03.24 10:10:47. 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-28 10:10:49 No severe PSQL-related problems occured
28.03.24 10:10:51. End of report.