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

Server and database settinfs 


SERVER_MODE                     SuperServer 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-04 19:09:46
DTS_END                         2024-04-04 19:09:46.7660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40168
TRN_ID                          171908
ATT_ID                          539
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: 9510.05 21900 951005
customer order: creation 171.05 395 17105
customer order: refuse 14.53 412 1453
order to supplier: creation 45.05 1480 4505
order to supplier: removal 3.48 115968 348
invoice (draft): creation 45.61 3600 4561
invoice (draft): removal 54.62 843 5462
invoice accept: apply 40.78 22100 4078
invoice accept: cancel 49.95 894 4995
customer reserve: creation 3931.77 211 393177
customer reserve: removal 4853.45 65 485345
realization accept: apply 81.41 224 8141
realization accept: cancel 92.94 128 9294
payment from customer: creation 57.26 125 5726
payment from customer: removal 5.46 95 546
payment to supplier: creation 47.41 169 4741
payment to supplier: removal 3.13 71 313
service: total inventory turnovers 4.89 1315 489
service: total monetary turnovers 6.45 37 645
service: aggregate perf. data 0.78 26145 78
service: refresh index statistics 0.03 263718 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2024 19:11:55 to 04-04-2024 19:11:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4421
TEST_TIME 2 4781
TEST_TIME 3 3714
TEST_TIME 4 4332
TEST_TIME 5 5308
TEST_TIME 6 5010
TEST_TIME 7 5629
TEST_TIME 8 5681
TEST_TIME 9 5729
TEST_TIME 10 5681
TEST_TIME 11 5844
TEST_TIME 12 5858
TEST_TIME 13 5833
TEST_TIME 14 5804
TEST_TIME 15 5787
TEST_TIME 16 5910
TEST_TIME 17 6117
TEST_TIME 18 6072
TEST_TIME 19 6177
TEST_TIME 20 6556
TEST_TIME 21 6708
TEST_TIME 22 6839
TEST_TIME 23 7128
TEST_TIME 24 7580
TEST_TIME 25 7634
TEST_TIME 26 7736
TEST_TIME 27 7861
TEST_TIME 28 7817
TEST_TIME 29 8585
TEST_TIME 30 9261
TEST_TIME 31 9520
TEST_TIME 32 9502
TEST_TIME 33 9449
TEST_TIME 34 9665
TEST_TIME 35 9863
TEST_TIME 36 10282
TEST_TIME 37 10124
TEST_TIME 38 9958
TEST_TIME 39 9940
TEST_TIME 40 10039
TEST_TIME 41 9895
TEST_TIME 42 9907
TEST_TIME 43 9767
TEST_TIME 44 9716
TEST_TIME 45 9699
TEST_TIME 46 9745
TEST_TIME 47 9708
TEST_TIME 48 9798
TEST_TIME 49 9662
TEST_TIME 50 9598
TEST_TIME 51 9554
TEST_TIME 52 9509
TEST_TIME 53 9645
TEST_TIME 54 9574
TEST_TIME 55 9539
TEST_TIME 56 9404
TEST_TIME 57 9391
TEST_TIME 58 9423
TEST_TIME 59 9399
TEST_TIME 60 9355
TEST_TIME 61 9284
TEST_TIME 62 9334
TEST_TIME 63 9520
TEST_TIME 64 9547
TEST_TIME 65 9571
TEST_TIME 66 9575
TEST_TIME 67 9571
TEST_TIME 68 9654
TEST_TIME 69 9647
TEST_TIME 70 9663
TEST_TIME 71 9686
TEST_TIME 72 9675
TEST_TIME 73 9657
TEST_TIME 74 9564
TEST_TIME 75 9609
TEST_TIME 76 9535
TEST_TIME 77 9501
TEST_TIME 78 9457
TEST_TIME 79 9466
TEST_TIME 80 9472
TEST_TIME 81 9466
TEST_TIME 82 9416
TEST_TIME 83 9409
TEST_TIME 84 9367
TEST_TIME 85 9354
TEST_TIME 86 9358
TEST_TIME 87 9511
TEST_TIME 88 9594
TEST_TIME 89 9579
TEST_TIME 90 9630
TEST_TIME 91 9631
TEST_TIME 92 9651
TEST_TIME 93 9693
TEST_TIME 94 9740
TEST_TIME 95 9736
TEST_TIME 96 9659
TEST_TIME 97 9622
TEST_TIME 98 9566
TEST_TIME 99 9566
TEST_TIME 100 9528

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2024 19:11:58 to 04-04-2024 19:12:02.

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 1310968 1310968 0 0.00 0 28133 7 0 0
doc_list_biud 1310967 1310967 0 0.00 0 37790 30 0 0
sp_add_invoice_to_stock 4193 4078 115 2.74 39 163320 22100 0 115
sp_cancel_adding_invoice 4995 4995 0 0.00 4 90628 895 0 0
sp_cancel_client_order 1453 1453 0 0.00 4 12116 412 0 0
sp_cancel_customer_reserve 485345 485345 0 0.00 0 37791 65 0 0
sp_cancel_pay_from_customer 546 546 0 0.00 3 6349 96 0 0
sp_cancel_pay_to_supplier 313 313 0 0.00 3 1554 72 0 0
sp_cancel_supplier_invoice 5473 5462 11 0.20 1 16802 844 0 11
sp_cancel_supplier_order 348 348 0 0.00 7 1283176 115968 0 0
sp_cancel_write_off 9294 9294 0 0.00 1 18213 128 0 0
sp_client_order 17105 17105 0 0.00 3 24491 395 0 0
sp_customer_reserve 393177 393177 0 0.00 0 50287 211 0 0
sp_fill_shopping_cart 26162 26162 0 0.00 1 21095 40 0 0
sp_fill_shopping_cart_clo_res 393164 393164 0 0.00 0 14362 15 0 0
sp_get_clo_for_invoice 4064 4064 0 0.00 0 19288 296 0 0
sp_kill_cost_storno 15148 15148 0 0.00 0 19928 74 0 0
sp_kill_qstorno_ret_qs2qd 985794 985794 0 0.00 0 37691 35 0 0
sp_kill_qty_storno 519102 519102 0 0.00 0 37790 76 0 0
sp_lock_selected_doc 16943 16943 0 0.00 0 7422 4 0 0
sp_make_cost_storno 22672 22672 0 0.00 0 18076 71 0 0
sp_multiply_rows_for_pdistr 22672 22672 0 0.00 0 11364 34 0 0
sp_multiply_rows_for_qdistr 17105 17105 0 0.00 0 14379 160 0 0
sp_pay_from_customer 5726 5726 0 0.00 4 16414 125 0 0
sp_pay_to_supplier 4741 4741 0 0.00 5 17947 169 0 0
sp_payment_common 10466 10466 0 0.00 2 11314 35 0 0
sp_qd_handle_on_cancel_clo 1453 1453 0 0.00 0 12097 389 0 0
sp_qd_handle_on_invoice_upd_sts 9059 9059 0 0.00 0 29769 374 0 0
sp_qd_handle_on_reserve_upd_sts 8141 8141 0 0.00 0 21622 81 0 0
sp_reserve_write_off 8141 8141 0 0.00 6 24392 224 0 0
sp_supplier_invoice 4561 4561 0 0.00 5 79532 3601 0 0
sp_supplier_order 4505 4505 0 0.00 5 30338 1481 0 0
srv_aggregate_perf_data 78 78 0 0.00 1886 370406 26146 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1540 179983 35380 0 0
srv_find_qd_qs_mism 909383 909383 0 0.00 0 28132 6 0 0
srv_make_invnt_saldo 489 489 0 0.00 39 78590 1316 0 0
srv_make_money_saldo 645 645 0 0.00 1 3139 37 0 0
srv_recalc_idx_stat 3 3 0 0.00 214602 340562 263718 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4081 4081 0 0.00 0 7726 215 0 0
t$perf-norm:sp_cancel_adding_invoice 344 344 0 0.00 0 1620 85 0 0
t$perf-norm:sp_cancel_client_order 1453 1453 0 0.00 0 1954 14 0 0
t$perf-norm:sp_cancel_customer_reserve 569 569 0 0.00 0 3546 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 546 546 0 0.00 0 3566 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 313 313 0 0.00 0 439 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 329 329 0 0.00 0 2202 25 0 0
t$perf-norm:sp_cancel_supplier_order 348 348 0 0.00 0 24853 2093 0 0
t$perf-norm:sp_cancel_write_off 836 836 0 0.00 0 1492 8 0 0
t$perf-norm:sp_client_order 17105 17105 0 0.00 0 7933 19 0 0
t$perf-norm:sp_customer_reserve 799 799 0 0.00 0 4055 14 0 0
t$perf-norm:sp_pay_from_customer 5726 5726 0 0.00 0 7946 14 0 0
t$perf-norm:sp_pay_to_supplier 4741 4741 0 0.00 0 6570 15 0 0
t$perf-norm:sp_reserve_write_off 8141 8141 0 0.00 0 4728 15 0 0
t$perf-norm:sp_supplier_invoice 4562 4562 0 0.00 0 5055 19 0 0
t$perf-norm:sp_supplier_order 4505 4505 0 0.00 0 3033 18 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 252 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 440 13 0 0
t$perf-norm:srv_make_invnt_saldo 489 489 0 0.00 0 1668 40 0 0
t$perf-norm:srv_make_money_saldo 645 645 0 0.00 0 1335 26 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 100 37 0 0
v_add_invoice_to_stock 8358 8128 230 2.75 0 15260 20 0 230
v_all_customers 31696 31696 0 0.00 0 134 1 0 0
v_all_suppliers 25650 25650 0 0.00 0 33 1 0 0
v_all_wares 34204 34204 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 688 688 0 0.00 0 4792 15 0 0
v_cancel_client_order 2906 2906 0 0.00 0 1685 4 0 0
v_cancel_customer_prepayment 1092 1092 0 0.00 0 2225 6 0 0
v_cancel_customer_reserve 1138 1138 0 0.00 0 1354 6 0 0
v_cancel_payment_to_supplier 626 626 0 0.00 0 279 3 0 0
v_cancel_supplier_invoice 680 658 22 3.23 0 1374 14 0 22
v_cancel_supplier_order 696 696 0 0.00 0 1366 10 0 0
v_cancel_write_off 1672 1672 0 0.00 0 14901 25 0 0
v_max_id_clo_ord 4504 4504 0 0.00 0 1777 2 0 0
v_max_id_clo_res 799 799 0 0.00 0 2314 9 0 0
v_max_id_ord_sup 4556 4556 0 0.00 0 9033 7 0 0
v_max_non_paid_invoice 975 975 0 0.00 0 5082 10 0 0
v_max_non_paid_realizn 2697 2697 0 0.00 0 4225 7 0 0
v_min_id_clo_ord 4504 4504 0 0.00 0 4472 14 0 0
v_min_id_clo_res 799 799 0 0.00 0 2924 7 0 0
v_min_id_ord_sup 4556 4556 0 0.00 0 5259 6 0 0
v_min_non_paid_invoice 4740 4740 0 0.00 0 11309 26 0 0
v_min_non_paid_realizn 5726 5726 0 0.00 0 9545 27 0 0
v_our_firm 8566 8566 0 0.00 0 19 1 0 0
v_reserve_write_off 16282 16282 0 0.00 0 14234 8 0 0
x_lock_depdocs_on_canc_invoice 10128 10128 0 0.00 0 10437 136 0 0
x_lock_depdocs_on_canc_sup_ord 348 348 0 0.00 0 12357 355 0 0
x_make_qstorno_1000_1200 4505 4505 0 0.00 2 30298 1387 0 0
x_make_qstorno_1200_2000 4561 4561 0 0.00 2 78891 3466 0 0
x_make_qstorno_2100_3300 393177 393177 0 0.00 0 47859 193 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2024 19:12:03 to 04-04-2024 19:12:07.

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
17:09:50 2 8192000000 8799188976 8810692608 5574512 0.068 2 1 2 0 5674144 56848 42784
17:10:51 30948 8192000000 9911141360 10225561600 984674576 10.730 100 87 174 0 1013104272 5942160 22487536
17:12:28 23597 8192000000 9957532112 10281615360 1039655744 11.261 100 92 184 0 1072183072 8565872 23961456
17:13:57 14062 8192000000 9979354480 10312888320 1065343232 11.508 100 89 177 0 1097265840 9650000 22272608
17:15:30 8160 8192000000 10038973008 10390790144 1131764592 12.138 100 78 155 0 1160032640 10197616 18070432
17:16:40 4610 8192000000 10085214896 10448097280 1175357344 12.547 100 72 145 0 1203158432 11420512 16380576
17:17:47 3321 8192000000 10136086352 10509115392 1226991520 13.026 100 76 153 1 1256006832 12256544 16758768
17:18:53 2651 8192000000 10168794608 10543788032 1253792528 13.273 100 84 165 2 1285102544 13632480 17677536
17:19:59 1308 8192000000 10204123120 10590633984 1290528880 13.609 100 85 170 0 1322157024 13273328 18354816
17:21:02 16443 8192000000 10214113840 10608553984 1303398464 13.726 100 60 122 0 1330483392 13966800 13118128
17:22:22 19636 8192000000 10192580352 10609651712 1310650736 13.792 100 30 61 0 1322666320 5536784 6478800
17:23:42 5443 8192000000 10205308480 10618585088 1315877232 13.839 100 36 72 0 1331081536 7478384 7725920
17:24:50 9974 8192000000 10198705488 10620551168 1322358736 13.898 100 23 46 0 1333235776 5836112 5040928
17:26:01 50377 8192000000 10237282288 10649399296 1333238144 13.996 100 27 54 3 1344441248 5166560 6036544
17:27:59 3618 8192000000 10237663056 10653622272 1337411024 14.034 100 37 74 0 1352686800 7034224 8241552
17:29:07 10055 8192000000 10222460864 10637529088 1319677024 13.874 99 30 61 0 1332198064 5321776 7199264
17:30:22 14339 8192000000 10241179488 10648899584 1323848704 13.912 99 48 96 0 1345927280 10908848 11169728
17:31:44 28134 8192000000 10195659904 10604756992 1259407712 13.325 94 47 97 1 1278840160 8453664 10978784
17:33:58 11355 8192000000 10228837408 10633551872 1306095440 13.751 99 53 106 0 1329855088 12046000 11713648
17:35:16 9897 8192000000 10208484576 10605109248 1283814528 13.548 98 61 122 0 1313344320 15908240 13621552
17:36:59 8828 8192000000 10203273664 10597552128 1277900464 13.494 99 58 116 0 1308080544 17155328 13024752
17:38:22 23754 8192000000 10230548480 10636931072 1315781824 13.838 100 40 80 0 1343068432 18010656 9275952
17:39:53 6829 8192000000 10242511552 10643963904 1315156288 13.833 99 53 104 0 1347234640 19276512 12801840
17:41:11 17020 8192000000 10243388272 10642726912 1317440704 13.854 99 55 110 0 1351472288 21386800 12644784
17:42:35 9267 8192000000 10259719216 10665967616 1338137280 14.041 100 47 93 0 1371493760 21563216 11793264
17:43:55 7831 8192000000 10293088384 10695237632 1361539376 14.251 100 64 128 1 1403573664 26198272 15836016
17:45:06 3231 8192000000 10300908496 10705915904 1351984976 14.165 99 48 96 0 1399357200 34973968 12398256
17:46:13 2420 8192000000 10325434016 10726907904 1373846288 14.361 100 83 165 1 1433255936 38988496 20421152
17:47:19 4468 8192000000 10333232064 10739671040 1382892640 14.442 100 65 126 0 1436449664 37687232 15869792
17:48:29 2659 8192000000 10349961744 10752577536 1386243952 14.472 100 82 163 1 1451087824 44695616 20148256
17:49:39 1532 8192000000 10364889232 10768199680 1400530960 14.600 100 81 160 1 1462649424 41942240 20176224
17:50:47 2350 8192000000 10375696528 10784256000 1413416192 14.714 100 80 158 0 1477955888 44606592 19933104
17:51:57 2071 8192000000 10397531232 10804011008 1421593840 14.787 100 94 187 0 1500962416 55316736 24051840
17:53:03 13434 8192000000 10357600800 10793635840 1407745216 14.664 100 38 73 0 1472700688 54414800 10540672
17:54:20 9674 8192000000 10371936944 10792669184 1411920512 14.701 100 63 125 2 1474759360 47119520 15719328
17:55:34 19825 8192000000 10362662576 10798489600 1413766768 14.717 100 29 58 0 1470170944 48712160 7692016
17:56:58 6574 8192000000 10368359584 10814435328 1406483136 14.653 100 32 64 2 1472978624 57004656 9490832
17:58:25 29280 8192000000 10352458064 10815660032 1393517552 14.537 100 13 26 0 1459250688 61820288 3912848
17:59:58 15548 8192000000 10334271568 10770309120 1405056608 14.640 100 34 62 2 1440345184 27192352 8096224
18:01:19 10340 8192000000 10343404960 10791837696 1422788592 14.797 100 26 52 0 1449855712 20680368 6386752
18:03:17 35302 8192000000 10362185664 10820730880 1426245440 14.828 100 18 36 0 1464622208 32952816 5423952
18:05:16 54785 8192000000 10319526592 10771181568 1392099568 14.525 99 37 74 0 1423987520 23671296 8216656
18:07:21 179983 8192000000 10322437728 10793496576 1373536464 14.359 97 26 52 0 1396074016 16759152 5778400
18:11:21 39173 8192000000 10320254752 10785554432 1410457920 14.688 99 23 46 0 1430595888 14766288 5371680
18:13:14 5674 8192000000 10322068192 10772271104 1400495456 14.599 99 32 62 1 1425873312 18434672 6943184
18:14:28 20862 8192000000 10319005200 10760110080 1377054016 14.390 98 49 98 1 1403082576 13543840 12484720
18:15:50 20832 8192000000 10298639968 10759573504 1388555280 14.493 100 41 82 1 1414021520 16734976 8731264
18:17:14 40859 8192000000 10288690192 10754072576 1365754848 14.289 98 17 32 0 1383004016 13345920 3903248
18:19:33 56726 8192000000 10291762240 10749308928 1382676720 14.440 99 15 30 0 1399521776 13182384 3662672
18:21:34 97849 8192000000 10290259792 10759532544 1381530448 14.430 99 21 42 1 1400159920 13531344 5098128
18:24:15 47563 8192000000 10277726096 10737254400 1352108944 14.166 97 15 28 0 1364016880 8831616 3076320
18:26:06 49905 8192000000 10295163472 10756083712 1363419840 14.268 98 27 54 0 1381233024 12155632 5657552
18:28:00 54933 8192000000 10263143120 10735325184 1322075440 13.895 96 5 8 1 1333627984 10823776 728768
18:29:58 20324 8192000000 10314735200 10759729152 1376924384 14.389 99 35 70 0 1399910576 14781664 8204528
18:31:20 63140 8192000000 10255662080 10718183424 1331521408 13.981 97 14 28 1 1355163936 20561520 3081008
18:33:24 45238 8192000000 10263839952 10714619904 1334957232 14.012 98 18 37 0 1353584736 14205456 4422048
18:35:57 41866 8192000000 10269052784 10706161664 1328825328 13.957 98 30 60 1 1348469376 12760832 6883216
18:37:41 42270 8192000000 10258034848 10707820544 1314847872 13.830 97 20 41 0 1332564000 12940144 4775984
18:39:28 52846 8192000000 10279361056 10720342016 1315185728 13.833 96 26 52 0 1337637760 17008672 5443360
18:41:49 120014 8192000000 10265398464 10701946880 1326229456 13.933 98 31 58 0 1341958560 9267120 6461984
18:45:15 67007 8192000000 10266598160 10720722944 1351350992 14.160 99 12 24 0 1373363568 19376944 2635632
18:47:22 47221 8192000000 10272255088 10723885056 1343287648 14.087 98 17 34 0 1364386800 16849440 4249712
18:49:21 75075 8192000000 10275929024 10740572160 1375250944 14.374 100 15 29 0 1392346672 13956544 3139184
18:51:37 44455 8192000000 10291281104 10741149696 1383264608 14.446 100 20 40 1 1395865968 8199920 4401440
18:53:23 41389 8192000000 10318144736 10766934016 1399234496 14.588 100 24 48 0 1418831888 14264496 5332896
18:55:08 77239 8192000000 10302858992 10782343168 1377083904 14.390 98 22 45 0 1411622048 29168112 5370032
18:57:39 94605 8192000000 10304224368 10757210112 1362167632 14.257 97 14 28 0 1379704336 14530432 3006272
19:00:19 21925 8192000000 10313597120 10761494528 1399696112 14.592 100 23 46 0 1415030032 9658608 5675312
19:01:43 36369 8192000000 10311294688 10756927488 1389349776 14.500 99 22 43 0 1407131600 12762848 5018976
19:03:21 51614 8192000000 10288075744 10738053120 1306236944 13.752 93 10 20 1 1317080432 8878976 1964512
19:05:13 68687 8192000000 10304781264 10754314240 1378399328 14.402 99 13 26 0 1392092320 10756848 2936144
19:08:06 12541 8192000000 10273303104 10702786560 1348178704 14.131 98 46 92 1 1369093856 10643280 10271872
19:09:28 27632 8192000000 9707026368 10072731648 848649952 9.387 62 4 8 0 853386256 4084320 651984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 04-04-2024 19:12:09 to 04-04-2024 19:12:22.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-04-2024 19:12:23 to 04-04-2024 19:12:25.

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          171164
MON$OLDEST_ACTIVE               172351
MON$OLDEST_SNAPSHOT             172351
MON$NEXT_TRANSACTION            172351
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                       1944160
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 Thu Apr  4 19:12:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        89997 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171164 
    Oldest active        172351 
    Oldest snapshot        172351 
    Next transaction    172352 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.77, total records: 7619337 
    Average version length: 48.16, total versions: 18487, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87256 
    Data pages: 87256, average fill: 70% 
    Primary pages: 87256, secondary pages: 0, swept pages: 45475 
    Empty pages: 9, full pages: 49850 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 738 
    40 - 59% = 6283 
    60 - 79% = 80139 
    80 - 99% = 4 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23299, nodes: 7619337 
    Average node length: 18.82, total dup: 0, max dup: 0 
    Average key length: 15.83, compression ratio: 1.71 
    Average prefix length: 14.17, average data length: 12.83 
    Clustering factor: 1660833, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 334 
        20 - 39% = 2134 
        40 - 59% = 4255 
        60 - 79% = 2864 
        80 - 99% = 13712 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13523, nodes: 7619337 
    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: 1483689, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1774 
        40 - 59% = 1995 
        60 - 79% = 1390 
        80 - 99% = 8364 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8357, nodes: 7619337 
    Average node length: 6.58, total dup: 5746948, max dup: 49 
    Average key length: 3.59, compression ratio: 2.51 
    Average prefix length: 7.65, average data length: 1.35 
    Clustering factor: 1476782, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 1115 
        40 - 59% = 1384 
        60 - 79% = 1152 
        80 - 99% = 4574 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 57.18, total records: 2162505 
    Average version length: 34.87, total versions: 16256, max versions: 3 
    Average fragment length: 7.33, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28552 
    Data pages: 28552, average fill: 70% 
    Primary pages: 28542, secondary pages: 10, swept pages: 20015 
    Empty pages: 6, full pages: 15989 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 435 
    40 - 59% = 4059 
    60 - 79% = 23948 
    80 - 99% = 50 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4540, nodes: 2162505 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 669648, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 988 
        40 - 59% = 901 
        60 - 79% = 868 
        80 - 99% = 1783 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2455, nodes: 2163784 
    Average node length: 4.97, total dup: 2162885, max dup: 18594 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1221620, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 295 
        40 - 59% = 1479 
        60 - 79% = 516 
        80 - 99% = 165 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2033, nodes: 2162505 
    Average node length: 4.97, total dup: 2162455, max dup: 130207 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1039652, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 249 
        40 - 59% = 894 
        60 - 79% = 131 
        80 - 99% = 756 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4354, nodes: 2162505 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 669648, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 667 
        40 - 59% = 694 
        60 - 79% = 960 
        80 - 99% = 1924 
 
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.39, total records: 400 
    Average version length: 23.00, total versions: 240699, max versions: 628 
    Average fragment length: 2.00, total fragments: 49, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1336 
    Data pages: 1336, average fill: 90% 
    Primary pages: 8, secondary pages: 1328, swept pages: 0 
    Empty pages: 1, full pages: 1334 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1333 
 
    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: 6.18, total records: 52397 
    Average version length: 68.25, total versions: 47654, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 14.24 
    Pointer pages: 8, data page slots: 2224 
    Data pages: 984, average fill: 67% 
    Primary pages: 983, secondary pages: 1, swept pages: 1 
    Empty pages: 104, full pages: 611 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 76 
    40 - 59% = 96 
    60 - 79% = 133 
    80 - 99% = 533 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1710808, depth: 3, leaf buckets: 176, nodes: 52397 
    Average node length: 13.47, total dup: 768, max dup: 1 
    Average key length: 11.17, compression ratio: 2.42 
    Average prefix length: 18.81, average data length: 8.19 
    Clustering factor: 42705, ratio: 0.82 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 46 
        40 - 59% = 83 
        60 - 79% = 41 
        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: 17674, max versions: 935 
    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: 88% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 58 
 
    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.78, total records: 897 
    Average version length: 42.70, total versions: 861, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 32.62 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 38% 
    Primary pages: 23, secondary pages: 1, swept pages: 4 
    Empty pages: 4, full pages: 6 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92007, depth: 2, leaf buckets: 1, nodes: 897 
    Average node length: 4.69, total dup: 799, max dup: 78 
    Average key length: 3.14, compression ratio: 6.06 
    Average prefix length: 17.97, average data length: 1.03 
    Clustering factor: 508, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        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.23, 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.88, total records: 853207 
    Average version length: 25.52, total versions: 40197, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8744 
    Data pages: 8736, average fill: 68% 
    Primary pages: 8709, secondary pages: 27, swept pages: 4398 
    Empty pages: 39, full pages: 4885 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 121 
    40 - 59% = 630 
    60 - 79% = 7745 
    80 - 99% = 150 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 967, nodes: 853207 
    Average node length: 4.88, total dup: 853158, max dup: 168431 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89934, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 148 
        40 - 59% = 575 
        60 - 79% = 206 
        80 - 99% = 37 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1125, nodes: 853207 
    Average node length: 5.89, total dup: 759624, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164374, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 108 
        40 - 59% = 736 
        60 - 79% = 92 
        80 - 99% = 184 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1165, nodes: 853207 
    Average node length: 5.89, total dup: 759624, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166301, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 236 
        40 - 59% = 670 
        60 - 79% = 71 
        80 - 99% = 187 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1199, nodes: 853207 
    Average node length: 5.97, total dup: 759624, max dup: 45 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158137, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 221 
        40 - 59% = 656 
        60 - 79% = 227 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.91, total records: 5472 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.27, total fragments: 26, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 128 
    Data pages: 96, average fill: 56% 
    Primary pages: 75, secondary pages: 21, swept pages: 58 
    Empty pages: 12, full pages: 65 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5472 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.46, average data length: 1.54 
    Clustering factor: 5265, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5472 
    Average node length: 11.12, 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: 145, 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.13, total records: 78987 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 761 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 761 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32883, depth: 2, leaf buckets: 102, nodes: 78987 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3344, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        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.21, 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.21 
    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.47, total records: 179907 
    Average version length: 152.81, total versions: 12544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.07 
    Pointer pages: 8, data page slots: 7432 
    Data pages: 4480, average fill: 83% 
    Primary pages: 4480, secondary pages: 0, swept pages: 58 
    Empty pages: 174, full pages: 4218 
    Fill distribution: 
     0 - 19% = 183 
    20 - 39% = 16 
    40 - 59% = 24 
    60 - 79% = 38 
    80 - 99% = 4219 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.63, total records: 185467 
    Average version length: 152.08, total versions: 7834, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 5952 
    Data pages: 4488, average fill: 85% 
    Primary pages: 4488, secondary pages: 0, swept pages: 27 
    Empty pages: 74, full pages: 4378 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 13 
    80 - 99% = 4378 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.94, total records: 169412 
    Average version length: 151.88, total versions: 7732, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 6, data page slots: 5608 
    Data pages: 4120, average fill: 85% 
    Primary pages: 4120, secondary pages: 0, swept pages: 27 
    Empty pages: 97, full pages: 3998 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3998 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.78, total records: 182435 
    Average version length: 152.73, total versions: 9729, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 7, data page slots: 5720 
    Data pages: 4392, average fill: 86% 
    Primary pages: 4392, secondary pages: 0, swept pages: 42 
    Empty pages: 60, full pages: 4303 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 13 
    80 - 99% = 4304 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.65, total records: 163181 
    Average version length: 151.82, total versions: 4766, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 5168 
    Data pages: 3960, average fill: 85% 
    Primary pages: 3960, secondary pages: 0, swept pages: 31 
    Empty pages: 77, full pages: 3853 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 11 
    40 - 59% = 12 
    60 - 79% = 8 
    80 - 99% = 3851 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.50, total records: 184393 
    Average version length: 152.66, total versions: 7885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 8, data page slots: 5840 
    Data pages: 4520, average fill: 84% 
    Primary pages: 4519, secondary pages: 1, swept pages: 16 
    Empty pages: 136, full pages: 4353 
    Fill distribution: 
     0 - 19% = 140 
    20 - 39% = 7 
    40 - 59% = 13 
    60 - 79% = 7 
    80 - 99% = 4353 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 144.46, total records: 197883 
    Average version length: 152.56, total versions: 8834, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 9, data page slots: 6080 
    Data pages: 4768, average fill: 86% 
    Primary pages: 4768, secondary pages: 0, swept pages: 26 
    Empty pages: 63, full pages: 4680 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 4679 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 142.61, total records: 175175 
    Average version length: 153.01, total versions: 9553, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 8, data page slots: 6080 
    Data pages: 4328, average fill: 84% 
    Primary pages: 4328, secondary pages: 0, swept pages: 61 
    Empty pages: 152, full pages: 4118 
    Fill distribution: 
     0 - 19% = 154 
    20 - 39% = 13 
    40 - 59% = 29 
    60 - 79% = 13 
    80 - 99% = 4119 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 139.89, total records: 183688 
    Average version length: 152.85, total versions: 13398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 8, data page slots: 6104 
    Data pages: 4544, average fill: 84% 
    Primary pages: 4544, secondary pages: 0, swept pages: 75 
    Empty pages: 144, full pages: 4319 
    Fill distribution: 
     0 - 19% = 154 
    20 - 39% = 37 
    40 - 59% = 18 
    60 - 79% = 16 
    80 - 99% = 4319 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.09, total records: 188077 
    Average version length: 152.06, total versions: 7518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 8, data page slots: 5960 
    Data pages: 4560, average fill: 85% 
    Primary pages: 4560, secondary pages: 0, swept pages: 32 
    Empty pages: 88, full pages: 4444 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 4 
    40 - 59% = 10 
    60 - 79% = 14 
    80 - 99% = 4443 
 
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: 52.38, total records: 2016602 
    Average version length: 52.82, total versions: 13925, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25768, average fill: 67% 
    Primary pages: 25768, secondary pages: 0, swept pages: 14933 
    Empty pages: 486, full pages: 17319 
    Fill distribution: 
     0 - 19% = 1014 
    20 - 39% = 898 
    40 - 59% = 2189 
    60 - 79% = 21570 
    80 - 99% = 97 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2548, nodes: 2016602 
    Average node length: 5.45, total dup: 1879681, max dup: 1416 
    Average key length: 2.50, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 175330, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 401 
        40 - 59% = 1583 
        60 - 79% = 296 
        80 - 99% = 266 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2752, nodes: 2016602 
    Average node length: 5.70, total dup: 1808705, max dup: 66 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 360952, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2566 
        60 - 79% = 155 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2039, nodes: 2016602 
    Average node length: 4.96, total dup: 2016502, max dup: 28367 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 173831, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 220 
        40 - 59% = 999 
        60 - 79% = 398 
        80 - 99% = 419 
 
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: 43.12, total records: 143760 
    Average version length: 69.16, total versions: 54176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.92 
    Pointer pages: 3, data page slots: 4400 
    Data pages: 3280, average fill: 51% 
    Primary pages: 3280, secondary pages: 0, swept pages: 572 
    Empty pages: 699, full pages: 1400 
    Fill distribution: 
     0 - 19% = 915 
    20 - 39% = 231 
    40 - 59% = 433 
    60 - 79% = 729 
    80 - 99% = 972 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106262, depth: 3, leaf buckets: 246, nodes: 143760 
    Average node length: 6.40, total dup: 125153, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 24783, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 77 
        40 - 59% = 124 
        60 - 79% = 43 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.44, total records: 7393865 
    Average version length: 68.73, total versions: 378840, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 68, data page slots: 109528 
    Data pages: 109440, average fill: 72% 
    Primary pages: 109440, secondary pages: 0, swept pages: 45718 
    Empty pages: 14, full pages: 64123 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 439 
    40 - 59% = 8068 
    60 - 79% = 96596 
    80 - 99% = 4303 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10971, nodes: 7393865 
    Average node length: 6.51, total dup: 6396338, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1647040, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1516 
        40 - 59% = 5832 
        60 - 79% = 3053 
        80 - 99% = 561 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 9041, nodes: 7393865 
    Average node length: 5.39, total dup: 7106634, max dup: 140 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1432273, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1237 
        40 - 59% = 5248 
        60 - 79% = 1609 
        80 - 99% = 935 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 9089, nodes: 7393865 
    Average node length: 5.39, total dup: 7106634, max dup: 140 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1434833, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1283 
        40 - 59% = 5256 
        60 - 79% = 1614 
        80 - 99% = 928 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.32, total records: 12426395 
    Average version length: 68.66, total versions: 295314, 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: 108, data page slots: 175240 
    Data pages: 175240, average fill: 75% 
    Primary pages: 175240, secondary pages: 0, swept pages: 97692 
    Empty pages: 3, full pages: 145217 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 383 
    40 - 59% = 5047 
    60 - 79% = 164880 
    80 - 99% = 4910 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18544, nodes: 12426395 
    Average node length: 6.62, total dup: 10830406, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2409617, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1977 
        40 - 59% = 10335 
        60 - 79% = 5325 
        80 - 99% = 884 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 48.85, total records: 1384686 
    Average version length: 69.11, total versions: 406286, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.58 
    Pointer pages: 30, data page slots: 46928 
    Data pages: 27592, average fill: 57% 
    Primary pages: 27591, secondary pages: 1, swept pages: 10600 
    Empty pages: 4202, full pages: 15240 
    Fill distribution: 
     0 - 19% = 6281 
    20 - 39% = 2200 
    40 - 59% = 2050 
    60 - 79% = 10859 
    80 - 99% = 6202 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2132, nodes: 1384686 
    Average node length: 5.52, total dup: 1328657, max dup: 99 
    Average key length: 2.57, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 93753, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 858 
        40 - 59% = 982 
        60 - 79% = 261 
        80 - 99% = 22 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 45.89, total records: 875897 
    Average version length: 69.12, total versions: 293441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 26, data page slots: 42264 
    Data pages: 32552, average fill: 31% 
    Primary pages: 32552, secondary pages: 0, swept pages: 11541 
    Empty pages: 9757, full pages: 4717 
    Fill distribution: 
     0 - 19% = 15023 
    20 - 39% = 5084 
    40 - 59% = 5258 
    60 - 79% = 3861 
    80 - 99% = 3326 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1489, nodes: 875897 
    Average node length: 5.84, total dup: 814173, max dup: 99 
    Average key length: 2.93, compression ratio: 14.35 
    Average prefix length: 41.14, average data length: 0.86 
    Clustering factor: 119551, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 713 
        40 - 59% = 605 
        60 - 79% = 147 
        80 - 99% = 18 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.51, total records: 8629982 
    Average version length: 69.00, total versions: 173814, 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: 90, data page slots: 146208 
    Data pages: 146120, average fill: 63% 
    Primary pages: 146119, secondary pages: 1, swept pages: 98448 
    Empty pages: 872, full pages: 58620 
    Fill distribution: 
     0 - 19% = 3055 
    20 - 39% = 13506 
    40 - 59% = 33293 
    60 - 79% = 93789 
    80 - 99% = 2477 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13463, nodes: 8629982 
    Average node length: 6.70, total dup: 7157834, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1827454, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2050 
        40 - 59% = 7323 
        60 - 79% = 3650 
        80 - 99% = 437 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21137823 
    Average version length: 82.82, total versions: 5535, 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: 318704 
    Data pages: 318704, average fill: 81% 
    Primary pages: 318704, secondary pages: 0, swept pages: 13000 
    Empty pages: 35, full pages: 317506 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 59 
    40 - 59% = 188 
    60 - 79% = 27843 
    80 - 99% = 290549 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19499, nodes: 21137823 
    Average node length: 5.72, total dup: 20656951, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279325, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8398 
        60 - 79% = 536 
        80 - 99% = 10558 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17186, nodes: 21137823 
    Average node length: 6.31, total dup: 18575312, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914521, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 815 
        60 - 79% = 296 
        80 - 99% = 16071 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21329, nodes: 21137823 
    Average node length: 6.35, total dup: 18494538, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573575, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 0 
        40 - 59% = 8729 
        60 - 79% = 643 
        80 - 99% = 11947 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16064, nodes: 21137823 
    Average node length: 5.56, total dup: 21137723, max dup: 229091 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943205, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2798 
        60 - 79% = 434 
        80 - 99% = 12824 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 81.45, total records: 9008993 
    Average version length: 82.60, total versions: 103600, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 174112 
    Data pages: 173976, average fill: 64% 
    Primary pages: 173976, secondary pages: 0, swept pages: 131680 
    Empty pages: 1307, full pages: 71958 
    Fill distribution: 
     0 - 19% = 4154 
    20 - 39% = 16382 
    40 - 59% = 40017 
    60 - 79% = 72531 
    80 - 99% = 40892 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11363, nodes: 9008993 
    Average node length: 5.40, total dup: 8706549, max dup: 164 
    Average key length: 2.25, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 1967803, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 267 
        40 - 59% = 9622 
        60 - 79% = 1453 
        80 - 99% = 16 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13371, nodes: 9008993 
    Average node length: 6.26, total dup: 7466872, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1352360, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 4380 
        40 - 59% = 4641 
        60 - 79% = 2480 
        80 - 99% = 1747 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12680, nodes: 9008993 
    Average node length: 6.01, total dup: 7801294, max dup: 44 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2142104, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 336 
        40 - 59% = 10704 
        60 - 79% = 1625 
        80 - 99% = 14 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9691, nodes: 9008993 
    Average node length: 5.15, total dup: 9008893, max dup: 140311 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1412019, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 62 
        20 - 39% = 1451 
        40 - 59% = 4706 
        60 - 79% = 1616 
        80 - 99% = 1856 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.39, total records: 10693075 
    Average version length: 82.51, total versions: 116983, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 119, data page slots: 193256 
    Data pages: 191424, average fill: 68% 
    Primary pages: 191424, secondary pages: 0, swept pages: 94774 
    Empty pages: 4495, full pages: 122699 
    Fill distribution: 
     0 - 19% = 8398 
    20 - 39% = 12411 
    40 - 59% = 25942 
    60 - 79% = 46439 
    80 - 99% = 98234 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13108, nodes: 10693075 
    Average node length: 5.31, total dup: 10584299, max dup: 627 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2228001, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 310 
        40 - 59% = 10408 
        60 - 79% = 2313 
        80 - 99% = 76 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10219, nodes: 10693075 
    Average node length: 5.51, total dup: 10223667, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 676778, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 189 
        20 - 39% = 984 
        40 - 59% = 2621 
        60 - 79% = 1892 
        80 - 99% = 4533 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14985, nodes: 10693075 
    Average node length: 6.05, total dup: 9314134, max dup: 69 
    Average key length: 2.82, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2244169, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 380 
        40 - 59% = 11886 
        60 - 79% = 2623 
        80 - 99% = 94 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10358, nodes: 10693075 
    Average node length: 5.23, total dup: 10692975, max dup: 179417 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 667524, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 963 
        40 - 59% = 4498 
        60 - 79% = 1535 
        80 - 99% = 3256 
 
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: 81.98, total records: 9098212 
    Average version length: 82.92, total versions: 82976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 110, data page slots: 178024 
    Data pages: 177904, average fill: 63% 
    Primary pages: 177904, secondary pages: 0, swept pages: 140116 
    Empty pages: 1360, full pages: 69621 
    Fill distribution: 
     0 - 19% = 4534 
    20 - 39% = 17138 
    40 - 59% = 42553 
    60 - 79% = 76460 
    80 - 99% = 37219 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11273, nodes: 9098212 
    Average node length: 5.20, total dup: 9070184, max dup: 1546 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1788615, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1818 
        40 - 59% = 7207 
        60 - 79% = 1640 
        80 - 99% = 570 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13519, nodes: 9098212 
    Average node length: 6.27, total dup: 7540416, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1310551, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 4443 
        40 - 59% = 4560 
        60 - 79% = 2504 
        80 - 99% = 1843 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 11830, nodes: 9098212 
    Average node length: 5.46, total dup: 8683260, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1911013, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1677 
        40 - 59% = 8016 
        60 - 79% = 1573 
        80 - 99% = 530 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9810, nodes: 9098212 
    Average node length: 5.17, total dup: 9098112, max dup: 141906 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1421617, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 56 
        20 - 39% = 1462 
        40 - 59% = 4846 
        60 - 79% = 1575 
        80 - 99% = 1871 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 68.03, total records: 560120 
    Average version length: 68.98, total versions: 1052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 73% 
    Primary pages: 8040, secondary pages: 0, swept pages: 5182 
    Empty pages: 5, full pages: 5691 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 89 
    40 - 59% = 589 
    60 - 79% = 7343 
    80 - 99% = 8 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41508, depth: 3, leaf buckets: 735, nodes: 560120 
    Average node length: 5.95, total dup: 476696, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 97370, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 48 
        40 - 59% = 526 
        60 - 79% = 74 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31391, depth: 3, leaf buckets: 752, nodes: 560120 
    Average node length: 6.15, total dup: 459294, max dup: 27 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 97420, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 541 
        60 - 79% = 77 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 558, nodes: 560120 
    Average node length: 4.85, total dup: 560020, max dup: 9624 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 86802, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 328 
        60 - 79% = 100 
        80 - 99% = 102 
 
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 Thu Apr  4 19:12:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7619337 18487 1 0.0000 0.0000
DOC_LIST 2162505 16256 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240699 628 60100.0000 0.0000
INVNT_TURNOVER_LOG 52397 47654 1 0.0000 0.0000
MONEY_SALDO 49 17674 935 36000.0000 0.0000
MONEY_TURNOVER_LOG 897 861 1 0.0000 0.0000
PDISTR 853207 40197 5 0.0000 0.0000
PERF_SPLIT_0 179907 12544 1 0.0000 0.0000
PERF_SPLIT_1 185467 7834 1 0.0000 0.0000
PERF_SPLIT_2 169412 7732 1 0.0000 0.0000
PERF_SPLIT_3 182435 9729 1 0.0000 0.0000
PERF_SPLIT_4 163181 4766 1 0.0000 0.0000
PERF_SPLIT_5 184393 7885 1 0.0000 0.0000
PERF_SPLIT_6 197883 8834 1 0.0000 0.0000
PERF_SPLIT_7 175175 9553 1 0.0000 0.0000
PERF_SPLIT_8 183688 13398 1 0.0000 0.0000
PERF_SPLIT_9 188077 7518 1 0.0000 0.0000
PSTORNED 2016602 13925 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143760 54176 1 0.0000 0.0000
XQD_1000_3300 7393865 378840 1 0.0000 0.0000
XQD_1200_2000 12426395 295314 1 0.0000 0.0000
XQD_2000_3300 1384686 406286 1 0.0000 0.0000
XQD_2100_3300 875897 293441 1 0.0000 0.0000
XQD_3300_3400 8629982 173814 1 0.0000 0.0000
XQS_1000_1200 21137823 5535 1 0.0000 0.0000
XQS_1000_3300 9008993 103600 1 0.0000 0.0000
XQS_1200_2000 10693075 116983 1 0.0000 0.0000
XQS_2100_3300 9098212 82976 1 0.0000 0.0000
XQS_3300_3400 560120 1052 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 ---
:783: 
:784: mscs-test-161.budzdorov.ru    Thu Apr  4 19:10:11 2024
:785:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:786: 
--- end of diff output ---

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

04.04.24 19:13:01. 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-04 19:13:04 No severe PSQL-related problems occured
04.04.24 19:13:05. End of report.