Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.04.2024 22:10
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 15550448 kB
MemAvailable 30097036 kB
Buffers 0 kB
Cached 16156572 kB
SwapCached 2504 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-07 22:09:45
DTS_END                         2024-04-07 22:09:45.1980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55146
TRN_ID                          171941
ATT_ID                          508
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: 9289.53 23210 928953
customer order: creation 167.39 403 16739
customer order: refuse 14.12 370 1412
order to supplier: creation 45.01 1425 4501
order to supplier: removal 3.74 109737 374
invoice (draft): creation 44.66 3308 4466
invoice (draft): removal 54.98 869 5498
invoice accept: apply 40.01 20934 4001
invoice accept: cancel 49.41 821 4941
customer reserve: creation 3802.28 202 380228
customer reserve: removal 4762.97 67 476297
realization accept: apply 81.25 186 8125
realization accept: cancel 96.53 135 9653
payment from customer: creation 57.04 110 5704
payment from customer: removal 6.10 75 610
payment to supplier: creation 48.55 151 4855
payment to supplier: removal 3.38 58 338
service: total inventory turnovers 4.93 1079 493
service: total monetary turnovers 6.45 45 645
service: aggregate perf. data 0.70 23648 70
service: refresh index statistics 0.03 300581 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-04-2024 22:10:51 to 07-04-2024 22:10:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4322
TEST_TIME 2 4260
TEST_TIME 3 4441
TEST_TIME 4 4610
TEST_TIME 5 5151
TEST_TIME 6 5108
TEST_TIME 7 5039
TEST_TIME 8 5300
TEST_TIME 9 5191
TEST_TIME 10 5586
TEST_TIME 11 5883
TEST_TIME 12 5803
TEST_TIME 13 5828
TEST_TIME 14 6046
TEST_TIME 15 5980
TEST_TIME 16 6196
TEST_TIME 17 6215
TEST_TIME 18 6419
TEST_TIME 19 6681
TEST_TIME 20 6755
TEST_TIME 21 6770
TEST_TIME 22 7189
TEST_TIME 23 7503
TEST_TIME 24 7353
TEST_TIME 25 7538
TEST_TIME 26 7717
TEST_TIME 27 7731
TEST_TIME 28 7989
TEST_TIME 29 9315
TEST_TIME 30 9269
TEST_TIME 31 9526
TEST_TIME 32 9485
TEST_TIME 33 9564
TEST_TIME 34 9574
TEST_TIME 35 9383
TEST_TIME 36 9285
TEST_TIME 37 9415
TEST_TIME 38 9331
TEST_TIME 39 9139
TEST_TIME 40 9190
TEST_TIME 41 9095
TEST_TIME 42 9245
TEST_TIME 43 9157
TEST_TIME 44 9214
TEST_TIME 45 9083
TEST_TIME 46 9058
TEST_TIME 47 9015
TEST_TIME 48 8944
TEST_TIME 49 9295
TEST_TIME 50 9260
TEST_TIME 51 9253
TEST_TIME 52 9267
TEST_TIME 53 9320
TEST_TIME 54 9273
TEST_TIME 55 9290
TEST_TIME 56 9324
TEST_TIME 57 9340
TEST_TIME 58 9336
TEST_TIME 59 9467
TEST_TIME 60 9510
TEST_TIME 61 9509
TEST_TIME 62 9393
TEST_TIME 63 9332
TEST_TIME 64 9391
TEST_TIME 65 9306
TEST_TIME 66 9299
TEST_TIME 67 9313
TEST_TIME 68 9348
TEST_TIME 69 9288
TEST_TIME 70 9214
TEST_TIME 71 9159
TEST_TIME 72 9102
TEST_TIME 73 9152
TEST_TIME 74 9147
TEST_TIME 75 9229
TEST_TIME 76 9191
TEST_TIME 77 9225
TEST_TIME 78 9225
TEST_TIME 79 9290
TEST_TIME 80 9310
TEST_TIME 81 9352
TEST_TIME 82 9345
TEST_TIME 83 9392
TEST_TIME 84 9363
TEST_TIME 85 9431
TEST_TIME 86 9451
TEST_TIME 87 9357
TEST_TIME 88 9342
TEST_TIME 89 9332
TEST_TIME 90 9310
TEST_TIME 91 9272
TEST_TIME 92 9268
TEST_TIME 93 9290
TEST_TIME 94 9289
TEST_TIME 95 9261
TEST_TIME 96 9240
TEST_TIME 97 9266
TEST_TIME 98 9244
TEST_TIME 99 9283
TEST_TIME 100 9295

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-04-2024 22:10:54 to 07-04-2024 22:10:57.

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 1278810 1278810 0 0.00 0 16789 7 0 0
doc_list_biud 1278810 1278810 0 0.00 0 73745 31 0 0
sp_add_invoice_to_stock 4075 4001 74 1.81 43 198466 20935 0 74
sp_cancel_adding_invoice 4941 4941 0 0.00 5 50806 821 0 0
sp_cancel_client_order 1412 1412 0 0.00 4 9108 371 0 0
sp_cancel_customer_reserve 476297 476297 0 0.00 0 73747 67 0 0
sp_cancel_pay_from_customer 610 610 0 0.00 2 5545 76 0 0
sp_cancel_pay_to_supplier 338 338 0 0.00 3 1275 59 0 0
sp_cancel_supplier_invoice 5502 5498 4 0.07 1 17242 870 0 4
sp_cancel_supplier_order 374 374 0 0.00 6 847908 109737 0 0
sp_cancel_write_off 9653 9653 0 0.00 1 15074 136 0 0
sp_client_order 16739 16739 0 0.00 3 26638 404 0 0
sp_customer_reserve 380228 380228 0 0.00 0 56887 203 0 0
sp_fill_shopping_cart 25698 25698 0 0.00 1 12390 35 0 0
sp_fill_shopping_cart_clo_res 380218 380218 0 0.00 0 28665 16 0 0
sp_get_clo_for_invoice 3989 3989 0 0.00 0 41440 297 0 0
sp_kill_cost_storno 15542 15542 0 0.00 0 11471 69 0 0
sp_kill_qstorno_ret_qs2qd 968119 968119 0 0.00 0 73728 37 0 0
sp_kill_qty_storno 510289 510289 0 0.00 0 73745 78 0 0
sp_lock_selected_doc 16945 16945 0 0.00 0 6303 5 0 0
sp_make_cost_storno 22673 22673 0 0.00 0 16778 56 0 0
sp_multiply_rows_for_pdistr 22673 22673 0 0.00 0 13184 27 0 0
sp_multiply_rows_for_qdistr 16739 16739 0 0.00 0 26631 185 0 0
sp_pay_from_customer 5704 5704 0 0.00 4 16319 111 0 0
sp_pay_to_supplier 4855 4855 0 0.00 5 16382 151 0 0
sp_payment_common 10559 10559 0 0.00 2 7752 23 0 0
sp_qd_handle_on_cancel_clo 1412 1412 0 0.00 0 9103 349 0 0
sp_qd_handle_on_invoice_upd_sts 8930 8930 0 0.00 0 22201 335 0 0
sp_qd_handle_on_reserve_upd_sts 8125 8125 0 0.00 0 28296 65 0 0
sp_reserve_write_off 8125 8125 0 0.00 6 28309 187 0 0
sp_supplier_invoice 4466 4466 0 0.00 6 86423 3308 0 0
sp_supplier_order 4501 4501 0 0.00 5 38978 1425 0 0
srv_aggregate_perf_data 70 70 0 0.00 1969 323851 23649 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1800 160531 38589 0 0
srv_find_qd_qs_mism 888803 888803 0 0.00 0 11540 6 0 0
srv_make_invnt_saldo 493 493 0 0.00 49 34306 1079 0 0
srv_make_money_saldo 645 645 0 0.00 1 11503 45 0 0
srv_recalc_idx_stat 3 3 0 0.00 185541 395577 300582 0 0
t$perf-abend:sp_add_invoice_to_stock 74 74 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4001 4001 0 0.00 0 11150 189 0 0
t$perf-norm:sp_cancel_adding_invoice 341 341 0 0.00 0 13340 158 0 0
t$perf-norm:sp_cancel_client_order 1412 1412 0 0.00 0 2508 14 0 0
t$perf-norm:sp_cancel_customer_reserve 579 579 0 0.00 0 1970 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 610 610 0 0.00 0 1164 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 338 338 0 0.00 0 11210 43 0 0
t$perf-norm:sp_cancel_supplier_invoice 328 328 0 0.00 0 552 10 0 0
t$perf-norm:sp_cancel_supplier_order 374 374 0 0.00 0 20664 1826 0 0
t$perf-norm:sp_cancel_write_off 852 852 0 0.00 0 2129 9 0 0
t$perf-norm:sp_client_order 16739 16739 0 0.00 0 11058 19 0 0
t$perf-norm:sp_customer_reserve 805 805 0 0.00 0 4696 12 0 0
t$perf-norm:sp_pay_from_customer 5704 5704 0 0.00 0 4194 8 0 0
t$perf-norm:sp_pay_to_supplier 4855 4855 0 0.00 0 4266 12 0 0
t$perf-norm:sp_reserve_write_off 8125 8125 0 0.00 0 9202 12 0 0
t$perf-norm:sp_supplier_invoice 4466 4466 0 0.00 0 12881 27 0 0
t$perf-norm:sp_supplier_order 4501 4501 0 0.00 0 11585 23 0 0
t$perf-norm:srv_aggregate_perf_data 70 70 0 0.00 0 2272 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 424 12 0 0
t$perf-norm:srv_make_invnt_saldo 493 493 0 0.00 0 3510 25 0 0
t$perf-norm:srv_make_money_saldo 645 645 0 0.00 0 549 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 8120 7972 148 1.82 0 5840 21 0 148
v_all_customers 31254 31254 0 0.00 0 123 1 0 0
v_all_suppliers 25796 25796 0 0.00 0 21 1 0 0
v_all_wares 33474 33474 0 0.00 0 124 1 0 0
v_cancel_adding_invoice 682 682 0 0.00 0 1729 13 0 0
v_cancel_client_order 2824 2824 0 0.00 0 3139 5 0 0
v_cancel_customer_prepayment 1220 1220 0 0.00 0 5536 8 0 0
v_cancel_customer_reserve 1158 1158 0 0.00 0 289 3 0 0
v_cancel_payment_to_supplier 676 676 0 0.00 0 272 3 0 0
v_cancel_supplier_invoice 664 656 8 1.20 0 1640 19 0 8
v_cancel_supplier_order 748 748 0 0.00 0 975 7 0 0
v_cancel_write_off 1704 1704 0 0.00 0 1556 13 0 0
v_max_id_clo_ord 4500 4500 0 0.00 0 171 1 0 0
v_max_id_clo_res 805 805 0 0.00 0 5548 19 0 0
v_max_id_ord_sup 4461 4461 0 0.00 0 3815 4 0 0
v_max_non_paid_invoice 918 918 0 0.00 0 339 3 0 0
v_max_non_paid_realizn 2700 2700 0 0.00 0 1044 5 0 0
v_min_id_clo_ord 4500 4500 0 0.00 0 7918 7 0 0
v_min_id_clo_res 805 805 0 0.00 0 3262 8 0 0
v_min_id_ord_sup 4461 4461 0 0.00 0 5652 7 0 0
v_min_non_paid_invoice 4855 4855 0 0.00 0 7748 17 0 0
v_min_non_paid_realizn 5704 5704 0 0.00 0 5521 16 0 0
v_our_firm 8228 8228 0 0.00 0 21 1 0 0
v_reserve_write_off 16250 16250 0 0.00 0 16295 12 0 0
x_lock_depdocs_on_canc_invoice 10111 10111 0 0.00 0 17751 131 0 0
x_lock_depdocs_on_canc_sup_ord 374 374 0 0.00 0 21792 407 0 0
x_make_qstorno_1000_1200 4501 4501 0 0.00 1 38955 1352 0 0
x_make_qstorno_1200_2000 4466 4466 0 0.00 3 80959 3184 0 0
x_make_qstorno_2100_3300 380228 380228 0 0.00 0 48493 184 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 07-04-2024 22:10:58 to 07-04-2024 22:11:03.

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
20:09:48 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:50 17154 8192000000 9885265504 10196430848 974388848 10.630 100 87 174 0 1003240768 5793248 23058672
20:12:19 23436 8192000000 9934110128 10257506304 1023523712 11.106 100 86 170 0 1054395808 8775152 22096944
20:14:02 13507 8192000000 9985386592 10321338368 1067785776 11.531 100 87 174 0 1100311968 9811888 22714304
20:15:19 11327 8192000000 10028466688 10379845632 1118493824 12.013 100 77 154 1 1147181376 9942320 18745232
20:16:34 4276 8192000000 10101776080 10464768000 1186933600 12.655 100 85 171 0 1217967920 11807760 19226560
20:17:43 4159 8192000000 10135981088 10510618624 1229325200 13.048 100 76 150 1 1257972432 12103008 16544224
20:18:50 1921 8192000000 10175786880 10551558144 1258776304 13.319 100 85 170 0 1290464096 13103952 18583840
20:19:54 1316 8192000000 10196987728 10582790144 1287028768 13.577 100 89 176 2 1320835744 14008576 19798400
20:20:57 1248 8192000000 10214713280 10609586176 1305539360 13.746 100 72 143 0 1334494912 12528016 16427536
20:21:58 5125 8192000000 10199624272 10612436992 1311088832 13.796 100 31 63 1 1326838608 8272480 7477296
20:23:07 6697 8192000000 10209153168 10627141632 1323312720 13.907 100 25 51 0 1334874064 5284064 6277280
20:24:15 13719 8192000000 10220157088 10634928128 1329929200 13.967 100 19 37 1 1339189632 5028912 4231520
20:25:29 8520 8192000000 10213530384 10640338944 1331557600 13.981 100 30 60 1 1344026928 5338320 7131008
20:26:41 6386 8192000000 10231776960 10654060544 1339160800 14.050 100 29 56 0 1351920832 7111824 5648208
20:27:49 6265 8192000000 10230006576 10652626944 1337551664 14.035 100 35 71 1 1352979808 8343552 7084592
20:28:57 59700 8192000000 10190434512 10603442176 1259625888 13.327 95 19 39 0 1268582752 4988400 3968464
20:31:14 9470 8192000000 10229473376 10634407936 1309525984 13.782 99 54 104 1 1335185136 13243296 12415856
20:32:29 24578 8192000000 10220276160 10629562368 1309891664 13.785 99 46 93 0 1330744816 10292096 10561056
20:33:57 9244 8192000000 10242128400 10648637440 1315184032 13.833 99 57 114 0 1341825616 13797792 12843792
20:35:07 13098 8192000000 10237080720 10642653184 1323385104 13.907 100 52 103 0 1348856304 13242816 12228384
20:36:31 8618 8192000000 10214888944 10615693312 1289252768 13.597 98 44 85 2 1312221440 12980912 9987760
20:37:46 2822 8192000000 10207119520 10605232128 1280683040 13.519 98 54 107 1 1307973248 13897504 13392704
20:38:57 28422 8192000000 10203907040 10609156096 1270091920 13.422 97 35 69 1 1294860992 15964272 8804800
20:40:34 11647 8192000000 10249005952 10652700672 1320123120 13.878 99 45 87 0 1348024032 17997328 9903584
20:41:50 5994 8192000000 10272830416 10675589120 1347946096 14.129 100 67 130 1 1380300352 18079472 14274784
20:43:04 3537 8192000000 10268003520 10669985792 1346468576 14.116 100 67 132 3 1382105568 19075024 16561968
20:44:12 17814 8192000000 10285899376 10698743808 1366755712 14.298 100 56 108 0 1401000176 21126752 13117712
20:45:36 4488 8192000000 10307724592 10712465408 1370896640 14.335 100 66 131 1 1412875616 25198896 16780080
20:46:45 12785 8192000000 10318281552 10730713088 1372558512 14.350 99 53 106 0 1419579856 33157392 13863952
20:48:03 1887 8192000000 10349263872 10753331200 1394186576 14.543 100 87 171 1 1449161136 33061584 21912976
20:49:09 1799 8192000000 10346726656 10763763712 1405628224 14.645 100 59 118 0 1453946720 33986208 14332288
20:50:18 2831 8192000000 10366570848 10777100288 1412798704 14.709 100 77 153 2 1470373168 38284224 19290240
20:51:24 15702 8192000000 10360764560 10792706048 1420598512 14.778 100 39 78 0 1470768144 39173568 10996064
20:52:47 12885 8192000000 10360173712 10794987520 1427611792 14.840 100 36 70 0 1471559760 34501024 9446944
20:54:05 23172 8192000000 10360795536 10807840768 1421730368 14.788 100 30 60 1 1477411424 47078768 8602288
20:55:36 11198 8192000000 10360914720 10803552256 1416676288 14.743 100 41 82 0 1473477040 45994640 10806112
20:56:49 20708 8192000000 10342833424 10792001536 1398586784 14.582 100 20 40 0 1454962208 49757072 6618352
20:58:17 27663 8192000000 10316247472 10791501824 1396498464 14.564 100 9 18 1 1437346752 38549568 2298720
20:59:47 30023 8192000000 10322227888 10787618816 1412944000 14.710 100 10 20 1 1431316128 15791072 2581056
21:01:21 45207 8192000000 10321934432 10774913024 1407658640 14.663 100 18 39 2 1427800720 16330208 3811872
21:03:08 41636 8192000000 10331272752 10783854592 1416170224 14.739 100 36 70 2 1436217600 11648272 8399104
21:04:53 157930 8192000000 10308430976 10776707072 1377131712 14.391 97 21 38 0 1392091168 10683680 4275776
21:08:41 17492 8192000000 10338570944 10788851712 1419559616 14.769 100 55 106 1 1442576512 9735792 13281104
21:10:00 20160 8192000000 10340278528 10788159488 1409704576 14.681 99 38 76 0 1429086608 10559296 8822736
21:11:21 55365 8192000000 10319321120 10791251968 1395052624 14.551 98 26 52 1 1414185664 12531440 6601600
21:14:04 33987 8192000000 10309790480 10768904192 1405188224 14.641 100 11 22 0 1418254448 10774592 2291632
21:15:38 50907 8192000000 10303376768 10757763072 1385532672 14.466 98 25 50 1 1407477376 15904992 6039712
21:18:14 56746 8192000000 10300629152 10792058880 1386861712 14.478 100 15 30 0 1418205984 27358128 3986144
21:20:12 39176 8192000000 10303299552 10753953792 1367780688 14.307 98 33 66 0 1384389616 8636992 7971936
21:21:55 63895 8192000000 10280042560 10738184192 1332652288 13.991 96 23 44 0 1350927808 13502672 4772848
21:24:01 41814 8192000000 10266134640 10709504000 1323184784 13.906 97 33 66 0 1343464320 13120736 7158800
21:25:43 87920 8192000000 10268286064 10703278080 1274620160 13.464 93 18 36 0 1293768240 15157536 3990544
21:28:19 103852 8192000000 10270372864 10725969920 1299447056 13.690 95 5 10 0 1319056704 18519456 1090192
21:31:04 98576 8192000000 10260564224 10708586496 1324407200 13.917 97 28 56 0 1340509424 9508496 6593728
21:34:06 37030 8192000000 10277794688 10726182912 1367863024 14.308 100 39 78 0 1388842016 11683760 9295232
21:35:44 31834 8192000000 10280596496 10731692032 1372075728 14.346 100 35 70 0 1397490528 17424720 7990080
21:37:17 43513 8192000000 10255226256 10710695936 1348859472 14.137 99 12 24 0 1369042592 17318000 2865120
21:39:34 70559 8192000000 10237587008 10684645376 1306177056 13.751 96 12 24 0 1322334400 13763472 2393872
21:41:45 60783 8192000000 10276818544 10730926080 1364366928 14.277 100 19 39 1 1379609824 10874896 4368000
21:43:48 48900 8192000000 10289926400 10754138112 1388031312 14.488 100 25 50 2 1404712256 11015872 5665072
21:45:43 19029 8192000000 10297387888 10746355712 1380641520 14.422 99 24 48 0 1394821248 8567600 5612128
21:47:03 55510 8192000000 10293193328 10746830848 1340213120 14.059 96 18 36 0 1359734320 15621440 3899760
21:49:07 64764 8192000000 10302518512 10750566400 1366875360 14.299 99 25 49 1 1386301984 13468592 5958032
21:51:15 38893 8192000000 10298770688 10746236928 1376053040 14.381 99 15 30 0 1387792080 8657808 3081232
21:52:54 24476 8192000000 10307220800 10756730880 1391959440 14.523 100 32 64 0 1408319504 9168784 7191280
21:54:20 34359 8192000000 10307302960 10764955648 1394305440 14.544 100 15 30 0 1410146352 12900704 2940208
21:56:00 160530 8192000000 10293117136 10757877760 1361175504 14.248 97 20 40 0 1377629584 12195168 4258912
21:59:48 45705 8192000000 10291898624 10753773568 1381192544 14.427 99 13 26 0 1397555120 13240864 3121712
22:01:53 57492 8192000000 10284786864 10749652992 1393420608 14.536 100 11 22 0 1406002576 10046576 2535392
22:04:20 44966 8192000000 10288767744 10756648960 1377935152 14.398 99 13 26 0 1393358928 12371504 3052272
22:06:19 38029 8192000000 10282638272 10734206976 1341005888 14.066 97 28 56 0 1359606416 12045456 6555072
22:07:58 48394 8192000000 10288459952 10739949568 1366530304 14.296 99 20 40 0 1382765504 11345520 4889680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 07-04-2024 22:11:05 to 07-04-2024 22:11:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 74 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-04-2024 22:11:19 to 07-04-2024 22:11:21.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          167861
MON$OLDEST_ACTIVE               172145
MON$OLDEST_SNAPSHOT             172145
MON$NEXT_TRANSACTION            172145
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-03 16:41:55.3470
MON$PAGES                       1909984
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Apr  7 22:11:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        89770 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    167861 
    Oldest active        172145 
    Oldest snapshot        172145 
    Next transaction    172146 
    Sequence number        0 
    Next attachment ID    704 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.15, total records: 7690295 
    Average version length: 48.16, total versions: 118640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86624 
    Data pages: 86624, average fill: 71% 
    Primary pages: 86624, secondary pages: 0, swept pages: 15937 
    Empty pages: 6, full pages: 66411 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 410 
    40 - 59% = 4083 
    60 - 79% = 82071 
    80 - 99% = 30 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23148, nodes: 7690295 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1688713, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 333 
        20 - 39% = 1966 
        40 - 59% = 3951 
        60 - 79% = 2496 
        80 - 99% = 14402 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13441, nodes: 7690295 
    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: 1512264, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1605 
        40 - 59% = 1972 
        60 - 79% = 1158 
        80 - 99% = 8706 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8269, nodes: 7690295 
    Average node length: 6.60, total dup: 5777336, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1505084, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 1039 
        40 - 59% = 1292 
        60 - 79% = 959 
        80 - 99% = 4866 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.76, total records: 2203467 
    Average version length: 34.58, total versions: 125202, max versions: 3 
    Average fragment length: 5.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28216 
    Data pages: 28216, average fill: 73% 
    Primary pages: 28206, secondary pages: 10, swept pages: 8203 
    Empty pages: 10, full pages: 20880 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 260 
    40 - 59% = 2640 
    60 - 79% = 23978 
    80 - 99% = 1291 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4492, nodes: 2203467 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 679892, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 899 
        40 - 59% = 827 
        60 - 79% = 777 
        80 - 99% = 1989 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2486, nodes: 2206489 
    Average node length: 4.97, total dup: 2205590, max dup: 18242 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1233290, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 259 
        40 - 59% = 1535 
        60 - 79% = 508 
        80 - 99% = 182 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2000, nodes: 2203467 
    Average node length: 4.97, total dup: 2203417, max dup: 130069 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1043700, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 229 
        40 - 59% = 869 
        60 - 79% = 73 
        80 - 99% = 823 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4283, nodes: 2203467 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 679892, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 612 
        40 - 59% = 550 
        60 - 79% = 878 
        80 - 99% = 2144 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.69, total records: 400 
    Average version length: 23.09, total versions: 240038, max versions: 624 
    Average fragment length: 2.00, total fragments: 30, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 91% 
    Primary pages: 13, secondary pages: 1299, swept pages: 0 
    Empty pages: 6, full pages: 1305 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1305 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 3.67, total records: 101154 
    Average version length: 68.29, total versions: 95722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 23.99 
    Pointer pages: 7, data page slots: 2080 
    Data pages: 2056, average fill: 62% 
    Primary pages: 2055, secondary pages: 1, swept pages: 0 
    Empty pages: 314, full pages: 1088 
    Fill distribution: 
     0 - 19% = 384 
    20 - 39% = 127 
    40 - 59% = 227 
    60 - 79% = 428 
    80 - 99% = 890 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705052, depth: 3, leaf buckets: 339, nodes: 101154 
    Average node length: 13.13, total dup: 7503, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.32, average data length: 7.68 
    Clustering factor: 74047, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 83 
        40 - 59% = 194 
        60 - 79% = 56 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17375, max versions: 940 
    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: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 56 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.44, total records: 1718 
    Average version length: 43.44, total versions: 1662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 40.28 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 23, secondary pages: 1, swept pages: 0 
    Empty pages: 2, full pages: 17 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90364, depth: 2, leaf buckets: 3, nodes: 1718 
    Average node length: 4.18, total dup: 1620, max dup: 194 
    Average key length: 2.61, compression ratio: 7.29 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 911, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.03, 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% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, 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: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.12, total records: 868233 
    Average version length: 25.64, total versions: 72275, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8440 
    Data pages: 8432, average fill: 72% 
    Primary pages: 8421, secondary pages: 11, swept pages: 1261 
    Empty pages: 9, full pages: 8106 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 6 
    40 - 59% = 41 
    60 - 79% = 8091 
    80 - 99% = 279 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 941, nodes: 868233 
    Average node length: 4.88, total dup: 868184, max dup: 159999 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 94775, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 104 
        40 - 59% = 544 
        60 - 79% = 218 
        80 - 99% = 71 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1081, nodes: 868233 
    Average node length: 5.89, total dup: 772812, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 173040, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 64 
        40 - 59% = 688 
        60 - 79% = 129 
        80 - 99% = 200 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1133, nodes: 868233 
    Average node length: 5.89, total dup: 772812, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 175029, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 183 
        40 - 59% = 654 
        60 - 79% = 89 
        80 - 99% = 207 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1215, nodes: 868233 
    Average node length: 5.97, total dup: 772812, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 167372, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 240 
        40 - 59% = 642 
        60 - 79% = 233 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5382 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.64, total fragments: 44, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 73, secondary pages: 15, swept pages: 48 
    Empty pages: 8, full pages: 62 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 66 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5382 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.27, average data length: 1.54 
    Clustering factor: 4962, ratio: 0.92 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5382 
    Average node length: 11.11, 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: 148, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.21, total records: 78384 
    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.22 
    Pointer pages: 1, data page slots: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 756 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 756 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34453, depth: 2, leaf buckets: 99, nodes: 78384 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3131, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 140.04, total records: 190360 
    Average version length: 154.71, total versions: 13984, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 4616, average fill: 86% 
    Primary pages: 4616, secondary pages: 0, swept pages: 1 
    Empty pages: 87, full pages: 4511 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4511 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.23, total records: 179964 
    Average version length: 154.69, total versions: 14987, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 7, data page slots: 5592 
    Data pages: 4328, average fill: 86% 
    Primary pages: 4328, secondary pages: 0, swept pages: 1 
    Empty pages: 50, full pages: 4255 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 11 
    60 - 79% = 4 
    80 - 99% = 4255 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.72, total records: 177766 
    Average version length: 151.96, total versions: 1821, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4272, secondary pages: 0, swept pages: 7 
    Empty pages: 43, full pages: 4209 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4208 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.37, total records: 164110 
    Average version length: 152.68, total versions: 5783, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 7, data page slots: 4696 
    Data pages: 3944, average fill: 86% 
    Primary pages: 3944, secondary pages: 0, swept pages: 5 
    Empty pages: 52, full pages: 3873 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 8 
    80 - 99% = 3872 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.89, total records: 166726 
    Average version length: 152.90, total versions: 4522, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 5240 
    Data pages: 4024, average fill: 85% 
    Primary pages: 4024, secondary pages: 0, swept pages: 2 
    Empty pages: 62, full pages: 3940 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3939 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 133.22, total records: 191830 
    Average version length: 154.83, total versions: 22570, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.73 
    Pointer pages: 8, data page slots: 5880 
    Data pages: 4632, average fill: 86% 
    Primary pages: 4632, secondary pages: 0, swept pages: 2 
    Empty pages: 63, full pages: 4550 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4550 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.93, total records: 165659 
    Average version length: 151.97, total versions: 3169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 5416 
    Data pages: 4000, average fill: 85% 
    Primary pages: 4000, secondary pages: 0, swept pages: 4 
    Empty pages: 68, full pages: 3913 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3912 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.89, total records: 154035 
    Average version length: 149.03, total versions: 1709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4600 
    Data pages: 3688, average fill: 86% 
    Primary pages: 3688, secondary pages: 0, swept pages: 3 
    Empty pages: 41, full pages: 3636 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3637 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.38, total records: 164147 
    Average version length: 153.88, total versions: 6975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 8, data page slots: 4720 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 9 
    Empty pages: 41, full pages: 3878 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 3875 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.64, total records: 155647 
    Average version length: 151.66, total versions: 3169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 4800 
    Data pages: 3728, average fill: 86% 
    Primary pages: 3728, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 3677 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3677 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.51, total records: 2051576 
    Average version length: 52.93, total versions: 48203, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25336 
    Data pages: 25336, average fill: 70% 
    Primary pages: 25336, secondary pages: 0, swept pages: 11242 
    Empty pages: 363, full pages: 19503 
    Fill distribution: 
     0 - 19% = 695 
    20 - 39% = 586 
    40 - 59% = 1464 
    60 - 79% = 22184 
    80 - 99% = 407 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2572, nodes: 2051576 
    Average node length: 5.44, total dup: 1913904, max dup: 1232 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 178389, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 343 
        40 - 59% = 1657 
        60 - 79% = 277 
        80 - 99% = 288 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2746, nodes: 2051576 
    Average node length: 5.69, total dup: 1840831, max dup: 81 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 367804, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2511 
        60 - 79% = 202 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2129, nodes: 2051576 
    Average node length: 4.96, total dup: 2051476, max dup: 27660 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 176434, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 214 
        40 - 59% = 1153 
        60 - 79% = 384 
        80 - 99% = 378 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 2 
    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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.02, total records: 158807 
    Average version length: 69.18, total versions: 71614, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.31 
    Pointer pages: 3, data page slots: 4032 
    Data pages: 3408, average fill: 54% 
    Primary pages: 3408, secondary pages: 0, swept pages: 577 
    Empty pages: 754, full pages: 1976 
    Fill distribution: 
     0 - 19% = 1002 
    20 - 39% = 168 
    40 - 59% = 148 
    60 - 79% = 750 
    80 - 99% = 1340 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98037, depth: 3, leaf buckets: 232, nodes: 158807 
    Average node length: 6.45, total dup: 138136, max dup: 14 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27195, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 114 
        60 - 79% = 64 
        80 - 99% = 20 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.64, total records: 7607311 
    Average version length: 68.78, total versions: 477050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 67, data page slots: 108472 
    Data pages: 108472, average fill: 75% 
    Primary pages: 108472, secondary pages: 0, swept pages: 23175 
    Empty pages: 22, full pages: 90701 
    Fill distribution: 
     0 - 19% = 168 
    20 - 39% = 894 
    40 - 59% = 5078 
    60 - 79% = 94045 
    80 - 99% = 8287 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10893, nodes: 7607311 
    Average node length: 6.51, total dup: 6579385, max dup: 35 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1695309, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1013 
        40 - 59% = 5736 
        60 - 79% = 3553 
        80 - 99% = 584 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 9109, nodes: 7607311 
    Average node length: 5.39, total dup: 7313211, max dup: 155 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1478954, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1061 
        40 - 59% = 5438 
        60 - 79% = 1465 
        80 - 99% = 1136 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 9204, nodes: 7607311 
    Average node length: 5.39, total dup: 7313211, max dup: 155 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1481448, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1100 
        40 - 59% = 5520 
        60 - 79% = 1479 
        80 - 99% = 1093 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.97, total records: 12589949 
    Average version length: 68.69, total versions: 362208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 107, data page slots: 173744 
    Data pages: 173744, average fill: 77% 
    Primary pages: 173744, secondary pages: 0, swept pages: 74814 
    Empty pages: 6, full pages: 167465 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 296 
    40 - 59% = 1867 
    60 - 79% = 163645 
    80 - 99% = 7895 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18563, nodes: 12589949 
    Average node length: 6.61, total dup: 10969880, max dup: 61 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2445393, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1625 
        40 - 59% = 10569 
        60 - 79% = 5395 
        80 - 99% = 944 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.12, total records: 1712908 
    Average version length: 69.13, total versions: 719282, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 28, data page slots: 44368 
    Data pages: 29399, average fill: 67% 
    Primary pages: 29398, secondary pages: 1, swept pages: 6158 
    Empty pages: 2414, full pages: 20372 
    Fill distribution: 
     0 - 19% = 4036 
    20 - 39% = 1793 
    40 - 59% = 1746 
    60 - 79% = 10413 
    80 - 99% = 11411 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2203, nodes: 1712908 
    Average node length: 5.51, total dup: 1643932, max dup: 99 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 116547, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 396 
        40 - 59% = 1122 
        60 - 79% = 511 
        80 - 99% = 159 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.54, total records: 1149010 
    Average version length: 69.13, total versions: 573959, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.65 
    Pointer pages: 22, data page slots: 35112 
    Data pages: 29736, average fill: 45% 
    Primary pages: 29736, secondary pages: 0, swept pages: 7800 
    Empty pages: 7821, full pages: 13442 
    Fill distribution: 
     0 - 19% = 12055 
    20 - 39% = 1592 
    40 - 59% = 1261 
    60 - 79% = 5726 
    80 - 99% = 9102 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1567, nodes: 1149010 
    Average node length: 5.79, total dup: 1073078, max dup: 108 
    Average key length: 2.85, compression ratio: 14.72 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 157334, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 330 
        40 - 59% = 744 
        60 - 79% = 392 
        80 - 99% = 96 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.54, total records: 8897749 
    Average version length: 68.98, total versions: 562436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 88, data page slots: 142248 
    Data pages: 142208, average fill: 67% 
    Primary pages: 142208, secondary pages: 0, swept pages: 47870 
    Empty pages: 721, full pages: 83068 
    Fill distribution: 
     0 - 19% = 2496 
    20 - 39% = 10956 
    40 - 59% = 22531 
    60 - 79% = 96688 
    80 - 99% = 9537 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13449, nodes: 8897749 
    Average node length: 6.68, total dup: 7380377, max dup: 25 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1890551, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1443 
        40 - 59% = 7526 
        60 - 79% = 4018 
        80 - 99% = 460 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21131601 
    Average version length: 82.99, total versions: 13623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318536 
    Data pages: 318536, average fill: 81% 
    Primary pages: 318536, secondary pages: 0, swept pages: 11676 
    Empty pages: 59, full pages: 317662 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 52 
    40 - 59% = 119 
    60 - 79% = 27152 
    80 - 99% = 291123 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19556, nodes: 21131601 
    Average node length: 5.72, total dup: 20650955, max dup: 134 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280144, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8541 
        60 - 79% = 502 
        80 - 99% = 10506 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17148, nodes: 21131601 
    Average node length: 6.31, total dup: 18570519, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914747, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 761 
        60 - 79% = 289 
        80 - 99% = 16092 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21303, nodes: 21131601 
    Average node length: 6.35, total dup: 18489052, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573604, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1 
        40 - 59% = 8724 
        60 - 79% = 566 
        80 - 99% = 12001 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16078, nodes: 21131601 
    Average node length: 5.56, total dup: 21131501, max dup: 231721 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943504, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 15 
        40 - 59% = 2854 
        60 - 79% = 409 
        80 - 99% = 12800 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.70, total records: 9314017 
    Average version length: 82.64, total versions: 530885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 104, data page slots: 169656 
    Data pages: 169608, average fill: 68% 
    Primary pages: 169608, secondary pages: 0, swept pages: 69170 
    Empty pages: 1025, full pages: 95714 
    Fill distribution: 
     0 - 19% = 3278 
    20 - 39% = 12376 
    40 - 59% = 29484 
    60 - 79% = 61888 
    80 - 99% = 62582 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11329, nodes: 9314017 
    Average node length: 5.36, total dup: 9011290, max dup: 200 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2005132, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 132 
        40 - 59% = 9288 
        60 - 79% = 1885 
        80 - 99% = 20 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13113, nodes: 9314017 
    Average node length: 6.23, total dup: 7720479, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1368602, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 115 
        20 - 39% = 3737 
        40 - 59% = 4479 
        60 - 79% = 2615 
        80 - 99% = 2167 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12638, nodes: 9314017 
    Average node length: 5.98, total dup: 8078069, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2195538, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 146 
        40 - 59% = 10351 
        60 - 79% = 2105 
        80 - 99% = 33 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9739, nodes: 9314017 
    Average node length: 5.13, total dup: 9313917, max dup: 150868 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1412458, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1232 
        40 - 59% = 4800 
        60 - 79% = 1598 
        80 - 99% = 2064 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.28, total records: 10857571 
    Average version length: 82.56, total versions: 396252, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191160 
    Data pages: 189496, average fill: 70% 
    Primary pages: 189496, secondary pages: 0, swept pages: 75455 
    Empty pages: 4275, full pages: 131979 
    Fill distribution: 
     0 - 19% = 7548 
    20 - 39% = 10475 
    40 - 59% = 21261 
    60 - 79% = 42020 
    80 - 99% = 108192 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13113, nodes: 10857571 
    Average node length: 5.30, total dup: 10748595, max dup: 662 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2255348, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 203 
        40 - 59% = 10286 
        60 - 79% = 2577 
        80 - 99% = 44 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10150, nodes: 10857571 
    Average node length: 5.49, total dup: 10381921, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 675727, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 936 
        40 - 59% = 2524 
        60 - 79% = 1791 
        80 - 99% = 4750 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15001, nodes: 10857571 
    Average node length: 6.03, total dup: 9462604, max dup: 72 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2271662, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 11954 
        60 - 79% = 2761 
        80 - 99% = 46 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10404, nodes: 10857571 
    Average node length: 5.21, total dup: 10857471, max dup: 191469 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 665638, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 970 
        40 - 59% = 4404 
        60 - 79% = 1516 
        80 - 99% = 3409 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.95, total records: 9437885 
    Average version length: 82.91, total versions: 545243, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 172840 
    Data pages: 172808, average fill: 68% 
    Primary pages: 172808, secondary pages: 0, swept pages: 70279 
    Empty pages: 1041, full pages: 96175 
    Fill distribution: 
     0 - 19% = 3317 
    20 - 39% = 12620 
    40 - 59% = 30695 
    60 - 79% = 63882 
    80 - 99% = 62294 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11475, nodes: 9437885 
    Average node length: 5.17, total dup: 9409603, max dup: 2182 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1837530, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1612 
        40 - 59% = 7493 
        60 - 79% = 1791 
        80 - 99% = 546 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13262, nodes: 9437885 
    Average node length: 6.24, total dup: 7822482, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1341545, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 187 
        20 - 39% = 3755 
        40 - 59% = 4352 
        60 - 79% = 2642 
        80 - 99% = 2326 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12103, nodes: 9437885 
    Average node length: 5.43, total dup: 9014184, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1967274, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1545 
        40 - 59% = 8410 
        60 - 79% = 1573 
        80 - 99% = 536 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9927, nodes: 9437885 
    Average node length: 5.14, total dup: 9437785, max dup: 152850 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1429323, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1290 
        40 - 59% = 4912 
        60 - 79% = 1663 
        80 - 99% = 2019 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.26, total records: 564809 
    Average version length: 68.77, total versions: 7480, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 74% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3961 
    Empty pages: 4, full pages: 6153 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 53 
    40 - 59% = 432 
    60 - 79% = 7415 
    80 - 99% = 91 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36095, depth: 3, leaf buckets: 741, nodes: 564809 
    Average node length: 5.94, total dup: 480919, max dup: 85 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 98120, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 52 
        40 - 59% = 518 
        60 - 79% = 88 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29512, depth: 3, leaf buckets: 757, nodes: 564809 
    Average node length: 6.15, total dup: 463199, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 98168, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 45 
        40 - 59% = 532 
        60 - 79% = 86 
        80 - 99% = 93 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 566, nodes: 564809 
    Average node length: 4.85, total dup: 564709, max dup: 9714 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87371, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 327 
        60 - 79% = 94 
        80 - 99% = 108 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, 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 Sun Apr  7 22:11:46 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7690295 118640 1 0.0000 0.0000
DOC_LIST 2203467 125202 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240038 624 60000.0000 0.0000
INVNT_TURNOVER_LOG 101154 95722 1 0.0000 0.0000
MONEY_SALDO 49 17375 940 35400.0000 0.0000
MONEY_TURNOVER_LOG 1718 1662 1 0.0000 0.0000
PDISTR 868233 72275 4 0.0000 0.0000
PERF_SPLIT_0 190360 13984 1 0.0000 0.0000
PERF_SPLIT_1 179964 14987 1 0.0000 0.0000
PERF_SPLIT_2 177766 1821 1 0.0000 0.0000
PERF_SPLIT_3 164110 5783 1 0.0000 0.0000
PERF_SPLIT_4 166726 4522 1 0.0000 0.0000
PERF_SPLIT_5 191830 22570 1 0.0000 0.0000
PERF_SPLIT_6 165659 3169 1 0.0000 0.0000
PERF_SPLIT_7 154035 1709 1 0.0000 0.0000
PERF_SPLIT_8 164147 6975 1 0.0000 0.0000
PERF_SPLIT_9 155647 3169 1 0.0000 0.0000
PSTORNED 2051576 48203 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 158807 71614 1 0.0000 0.0000
XQD_1000_3300 7607311 477050 1 0.0000 0.0000
XQD_1200_2000 12589949 362208 1 0.0000 0.0000
XQD_2000_3300 1712908 719282 1 0.0000 0.0000
XQD_2100_3300 1149010 573959 1 0.0000 0.0000
XQD_3300_3400 8897749 562436 1 0.0000 0.0000
XQS_1000_1200 21131601 13623 1 0.0000 0.0000
XQS_1000_3300 9314017 530885 1 0.0000 0.0000
XQS_1200_2000 10857571 396252 1 0.0000 0.0000
XQS_2100_3300 9437885 545243 1 0.0000 0.0000
XQS_3300_3400 564809 7480 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 ---
:912: 
:913: mscs-test-161.budzdorov.ru    Sun Apr  7 22:09:46 2024
:914:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:915: 
:916: 
:917: mscs-test-161.budzdorov.ru    Sun Apr  7 22:09:49 2024
:918:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:919: 
:920: 
:921: mscs-test-161.budzdorov.ru    Sun Apr  7 22:09:50 2024
:922:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:923: 
:924: 
:925: mscs-test-161.budzdorov.ru    Sun Apr  7 22:09:51 2024
:926:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:927: 
:928: 
:929: mscs-test-161.budzdorov.ru    Sun Apr  7 22:09:51 2024
:930:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:931: 
--- end of diff output ---

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

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