Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.03.2024 16:13
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 15660088 kB
MemAvailable 30275056 kB
Buffers 0 kB
Cached 16090128 kB
SwapCached 2580 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-03-20 16:12:18
DTS_END                         2024-03-20 16:12:18.7720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56368
TRN_ID                          178175
ATT_ID                          619
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: 9269.61 22069 926961
customer order: creation 180.57 342 18057
customer order: refuse 15.42 429 1542
order to supplier: creation 48.67 1215 4867
order to supplier: removal 3.38 109000 338
invoice (draft): creation 48.21 3159 4821
invoice (draft): removal 50.08 832 5008
invoice accept: apply 43.43 22286 4343
invoice accept: cancel 44.59 907 4459
customer reserve: creation 4129.59 215 412959
customer reserve: removal 4399.32 65 439932
realization accept: apply 87.05 221 8705
realization accept: cancel 81.67 137 8167
payment from customer: creation 62.86 115 6286
payment from customer: removal 5.67 99 567
payment to supplier: creation 52.24 138 5224
payment to supplier: removal 3.68 102 368
service: total inventory turnovers 5.48 1040 548
service: total monetary turnovers 6.99 33 699
service: aggregate perf. data 0.68 28811 68
service: refresh index statistics 0.03 272227 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 20-03-2024 16:13:39 to 20-03-2024 16:13:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6294
TEST_TIME 2 6363
TEST_TIME 3 5593
TEST_TIME 4 5677
TEST_TIME 5 5386
TEST_TIME 6 5940
TEST_TIME 7 6014
TEST_TIME 8 6125
TEST_TIME 9 6072
TEST_TIME 10 6178
TEST_TIME 11 6636
TEST_TIME 12 6667
TEST_TIME 13 6679
TEST_TIME 14 6871
TEST_TIME 15 6732
TEST_TIME 16 6913
TEST_TIME 17 6934
TEST_TIME 18 6930
TEST_TIME 19 7190
TEST_TIME 20 7441
TEST_TIME 21 7724
TEST_TIME 22 7930
TEST_TIME 23 7947
TEST_TIME 24 8320
TEST_TIME 25 8393
TEST_TIME 26 8248
TEST_TIME 27 8432
TEST_TIME 28 8458
TEST_TIME 29 9058
TEST_TIME 30 9583
TEST_TIME 31 9634
TEST_TIME 32 9496
TEST_TIME 33 9339
TEST_TIME 34 9475
TEST_TIME 35 9608
TEST_TIME 36 9556
TEST_TIME 37 9437
TEST_TIME 38 9219
TEST_TIME 39 9334
TEST_TIME 40 9284
TEST_TIME 41 9291
TEST_TIME 42 9207
TEST_TIME 43 9245
TEST_TIME 44 9219
TEST_TIME 45 9243
TEST_TIME 46 9238
TEST_TIME 47 9211
TEST_TIME 48 9111
TEST_TIME 49 9097
TEST_TIME 50 9163
TEST_TIME 51 9105
TEST_TIME 52 8973
TEST_TIME 53 9215
TEST_TIME 54 9409
TEST_TIME 55 9327
TEST_TIME 56 9421
TEST_TIME 57 9402
TEST_TIME 58 9473
TEST_TIME 59 9482
TEST_TIME 60 9461
TEST_TIME 61 9391
TEST_TIME 62 9565
TEST_TIME 63 9518
TEST_TIME 64 9593
TEST_TIME 65 9621
TEST_TIME 66 9621
TEST_TIME 67 9485
TEST_TIME 68 9478
TEST_TIME 69 9431
TEST_TIME 70 9364
TEST_TIME 71 9332
TEST_TIME 72 9317
TEST_TIME 73 9343
TEST_TIME 74 9277
TEST_TIME 75 9293
TEST_TIME 76 9251
TEST_TIME 77 9238
TEST_TIME 78 9282
TEST_TIME 79 9292
TEST_TIME 80 9287
TEST_TIME 81 9459
TEST_TIME 82 9479
TEST_TIME 83 9510
TEST_TIME 84 9511
TEST_TIME 85 9503
TEST_TIME 86 9545
TEST_TIME 87 9598
TEST_TIME 88 9554
TEST_TIME 89 9466
TEST_TIME 90 9436
TEST_TIME 91 9431
TEST_TIME 92 9430
TEST_TIME 93 9410
TEST_TIME 94 9379
TEST_TIME 95 9351
TEST_TIME 96 9307
TEST_TIME 97 9358
TEST_TIME 98 9352
TEST_TIME 99 9347
TEST_TIME 100 9286

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2024 16:13:43 to 20-03-2024 16:13:46.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1303005 1303005 0 0.00 0 20661 7 0 0
doc_list_biud 1303005 1303005 0 0.00 0 35566 28 0 0
sp_add_invoice_to_stock 4454 4343 111 2.49 37 198609 22286 0 111
sp_cancel_adding_invoice 4459 4459 0 0.00 4 45293 908 0 0
sp_cancel_client_order 1542 1542 0 0.00 5 11337 429 0 0
sp_cancel_customer_reserve 439932 439932 0 0.00 0 35570 66 0 0
sp_cancel_pay_from_customer 567 567 0 0.00 3 6028 99 0 0
sp_cancel_pay_to_supplier 368 368 0 0.00 2 4663 102 0 0
sp_cancel_supplier_invoice 5015 5008 7 0.13 2 17369 832 0 7
sp_cancel_supplier_order 338 338 0 0.00 5 1088365 109001 0 0
sp_cancel_write_off 8167 8167 0 0.00 1 11708 138 0 0
sp_client_order 18057 18057 0 0.00 3 27527 342 0 0
sp_customer_reserve 412959 412959 0 0.00 0 48373 216 0 0
sp_fill_shopping_cart 27744 27744 0 0.00 1 12028 36 0 0
sp_fill_shopping_cart_clo_res 412925 412925 0 0.00 0 14565 15 0 0
sp_get_clo_for_invoice 4309 4309 0 0.00 0 40205 287 0 0
sp_kill_cost_storno 13561 13561 0 0.00 0 6876 70 0 0
sp_kill_qstorno_ret_qs2qd 893377 893377 0 0.00 0 35537 35 0 0
sp_kill_qty_storno 472460 472460 0 0.00 0 35565 77 0 0
sp_lock_selected_doc 18065 18065 0 0.00 0 7975 6 0 0
sp_make_cost_storno 24524 24524 0 0.00 0 11969 61 0 0
sp_multiply_rows_for_pdistr 24524 24524 0 0.00 0 6215 31 0 0
sp_multiply_rows_for_qdistr 18057 18057 0 0.00 0 11544 161 0 0
sp_pay_from_customer 6286 6286 0 0.00 4 27416 115 0 0
sp_pay_to_supplier 5224 5224 0 0.00 5 21996 138 0 0
sp_payment_common 11510 11510 0 0.00 1 11758 26 0 0
sp_qd_handle_on_cancel_clo 1542 1542 0 0.00 0 11134 395 0 0
sp_qd_handle_on_invoice_upd_sts 8768 8768 0 0.00 0 15386 358 0 0
sp_qd_handle_on_reserve_upd_sts 8705 8705 0 0.00 0 18862 87 0 0
sp_reserve_write_off 8705 8705 0 0.00 6 18873 222 0 0
sp_supplier_invoice 4821 4821 0 0.00 7 70317 3160 0 0
sp_supplier_order 4867 4867 0 0.00 6 44248 1215 0 0
srv_aggregate_perf_data 68 68 0 0.00 1753 354070 28811 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1579 140053 33711 0 0
srv_find_qd_qs_mism 881514 881514 0 0.00 0 20653 6 0 0
srv_make_invnt_saldo 548 548 0 0.00 36 47849 1041 0 0
srv_make_money_saldo 699 699 0 0.00 1 2763 34 0 0
srv_recalc_idx_stat 3 3 0 0.00 233916 313938 272227 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4343 4343 0 0.00 0 12308 212 0 0
t$perf-norm:sp_cancel_adding_invoice 358 358 0 0.00 0 5331 135 0 0
t$perf-norm:sp_cancel_client_order 1542 1542 0 0.00 0 1613 10 0 0
t$perf-norm:sp_cancel_customer_reserve 617 617 0 0.00 0 2719 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 567 567 0 0.00 0 506 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 368 368 0 0.00 0 922 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 985 20 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 27139 2002 0 0
t$perf-norm:sp_cancel_write_off 885 885 0 0.00 0 1941 11 0 0
t$perf-norm:sp_client_order 18057 18057 0 0.00 0 4361 17 0 0
t$perf-norm:sp_customer_reserve 897 897 0 0.00 0 3118 11 0 0
t$perf-norm:sp_pay_from_customer 6286 6286 0 0.00 0 3418 11 0 0
t$perf-norm:sp_pay_to_supplier 5224 5224 0 0.00 0 2183 10 0 0
t$perf-norm:sp_reserve_write_off 8705 8705 0 0.00 0 6212 12 0 0
t$perf-norm:sp_supplier_invoice 4821 4821 0 0.00 0 2582 20 0 0
t$perf-norm:sp_supplier_order 4867 4867 0 0.00 0 6355 22 0 0
t$perf-norm:srv_aggregate_perf_data 68 68 0 0.00 0 115 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 34 2 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 1439 33 0 0
t$perf-norm:srv_make_money_saldo 699 699 0 0.00 0 1094 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 30 13 0 0
v_add_invoice_to_stock 8840 8618 222 2.51 0 6219 21 0 222
v_all_customers 33782 33782 0 0.00 0 22 1 0 0
v_all_suppliers 27416 27416 0 0.00 0 95 1 0 0
v_all_wares 36114 36114 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 716 716 0 0.00 0 2478 12 0 0
v_cancel_client_order 3084 3084 0 0.00 0 6479 11 0 0
v_cancel_customer_prepayment 1134 1134 0 0.00 0 2073 7 0 0
v_cancel_customer_reserve 1234 1234 0 0.00 0 6577 9 0 0
v_cancel_payment_to_supplier 736 736 0 0.00 0 4645 13 0 0
v_cancel_supplier_invoice 766 752 14 1.82 0 6558 31 0 14
v_cancel_supplier_order 676 676 0 0.00 0 729 4 0 0
v_cancel_write_off 1770 1770 0 0.00 0 5005 25 0 0
v_max_id_clo_ord 4866 4866 0 0.00 0 4124 3 0 0
v_max_id_clo_res 897 897 0 0.00 0 4992 26 0 0
v_max_id_ord_sup 4821 4821 0 0.00 0 4104 4 0 0
v_max_non_paid_invoice 1203 1203 0 0.00 0 1631 6 0 0
v_max_non_paid_realizn 2985 2985 0 0.00 0 4917 6 0 0
v_min_id_clo_ord 4866 4866 0 0.00 0 9481 12 0 0
v_min_id_clo_res 897 897 0 0.00 0 5946 9 0 0
v_min_id_ord_sup 4821 4821 0 0.00 0 3876 5 0 0
v_min_non_paid_invoice 5224 5224 0 0.00 0 9313 18 0 0
v_min_non_paid_realizn 6286 6286 0 0.00 0 6221 17 0 0
v_our_firm 8934 8934 0 0.00 0 93 1 0 0
v_reserve_write_off 17410 17410 0 0.00 0 6481 6 0 0
x_lock_depdocs_on_canc_invoice 9091 9091 0 0.00 0 20985 156 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 10346 429 0 0
x_make_qstorno_1000_1200 4867 4867 0 0.00 1 44236 1125 0 0
x_make_qstorno_1200_2000 4821 4821 0 0.00 3 67750 3041 0 0
x_make_qstorno_2100_3300 412959 412959 0 0.00 0 48362 197 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2024 16:13:47 to 20-03-2024 16:13:51.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:12:22 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:13:23 22765 8192000000 9873338464 10176430080 956857184 10.458 100 87 174 1 986137872 5698288 23582400
14:14:53 23199 8192000000 9930071056 10245447680 1005627696 10.933 100 92 183 0 1037934352 8390592 23916064
14:16:21 12933 8192000000 9957663600 10284056576 1038859760 11.254 100 83 167 0 1069064304 9083488 21121056
14:17:37 11417 8192000000 10010736432 10355924992 1100477696 11.842 100 72 144 0 1128117808 10520848 17119264
14:19:02 6427 8192000000 10063971280 10420379648 1152796208 12.336 100 75 150 0 1182276704 12396752 17083744
14:20:15 2285 8192000000 10112713824 10479718400 1203660928 12.810 100 81 161 0 1234512096 12805792 18045376
14:21:20 1658 8192000000 10150707632 10523181056 1235836272 13.108 100 84 165 1 1268442448 13774032 18832144
14:22:22 897 8192000000 10184569712 10566631424 1271268720 13.433 100 87 173 1 1304372352 13735248 19368384
14:23:25 1416 8192000000 10204673440 10588807168 1291308256 13.616 100 81 161 0 1321680128 12679808 17692064
14:24:28 4756 8192000000 10196377120 10598014976 1299952176 13.695 100 45 90 0 1319231056 9705616 9573264
14:25:35 17015 8192000000 10211308848 10613661696 1309510560 13.782 100 63 123 1 1329481584 4989680 14981344
14:26:56 4534 8192000000 10203024016 10616553472 1311197824 13.797 100 27 54 0 1323537840 6662112 5677904
14:28:02 8181 8192000000 10205276624 10621136896 1318687360 13.865 100 30 60 0 1331541360 5922224 6931776
14:29:14 11395 8192000000 10220343008 10636578816 1327952720 13.949 100 11 20 0 1334816080 4548704 2314656
14:30:29 36626 8192000000 10237526800 10646745088 1331578672 13.981 100 47 94 1 1348923104 5282112 12062320
14:32:06 3701 8192000000 10227182720 10641612800 1328957824 13.958 100 31 62 2 1343083152 5602048 8523280
14:33:14 10422 8192000000 10233120384 10641068032 1319783120 13.875 99 45 91 0 1339343440 9644112 9916208
14:34:32 2499 8192000000 10248614800 10654142464 1338216544 14.041 100 65 129 1 1365632720 12830096 14586080
14:35:39 46629 8192000000 10236717216 10652094464 1316630880 13.846 98 49 94 0 1338741312 11654256 10456176
14:37:43 17736 8192000000 10254509392 10666717184 1342787872 14.083 100 39 78 1 1364269664 12804912 8676880
14:39:05 46752 8192000000 10257037152 10672992256 1315933696 13.840 97 42 83 0 1340636000 15354208 9348096
14:40:58 16229 8192000000 10260902480 10675318784 1341005056 14.066 99 51 102 0 1368336336 15334160 11997120
14:42:18 16145 8192000000 10243847312 10657529856 1320075536 13.877 99 47 94 1 1350477280 19448816 10952928
14:44:00 19711 8192000000 10230709504 10631643136 1283378880 13.544 97 53 104 1 1311888832 16695184 11814768
14:45:24 1715 8192000000 10264731600 10660696064 1328410016 13.953 100 73 146 1 1364785568 19420528 16955024
14:46:33 1672 8192000000 10273314752 10668490752 1340908800 14.066 100 76 148 1 1380664944 22374608 17381536
14:47:40 3731 8192000000 10280220448 10684547072 1349154816 14.140 100 61 122 0 1389312848 25818816 14339216
14:48:47 1578 8192000000 10299862336 10697224192 1360064912 14.238 100 82 164 0 1405335296 25710992 19559392
14:49:52 6958 8192000000 10302783072 10706948096 1361837136 14.254 99 64 128 1 1405318960 28124480 15357344
14:51:09 6514 8192000000 10312508384 10719977472 1369686976 14.324 100 73 144 0 1419467120 31975072 17805072
14:52:24 2695 8192000000 10334948400 10742685696 1387746656 14.486 100 70 138 2 1438703040 33932624 17023760
14:53:29 4335 8192000000 10339328512 10753122304 1394573648 14.547 100 70 137 0 1447615168 35677184 17364336
14:54:37 14881 8192000000 10324465504 10753134592 1394998288 14.550 100 35 71 0 1437446016 32833120 9614608
14:56:02 11570 8192000000 10331962352 10760855552 1396032496 14.560 100 42 86 1 1447065424 39116160 11916768
14:57:44 6576 8192000000 10327339424 10752798720 1391164880 14.516 100 46 91 0 1434583648 32877840 10540928
14:58:58 21990 8192000000 10324051184 10758209536 1387771552 14.486 100 41 81 0 1435582192 36995184 10815456
15:01:08 11602 8192000000 10330695360 10768941056 1392055824 14.524 100 29 58 1 1441158480 41376432 7726224
15:02:29 40759 8192000000 10286152704 10742378496 1356473296 14.206 98 12 24 0 1376935792 17923888 2538608
15:04:11 50446 8192000000 10312110000 10745950208 1391629408 14.520 100 28 54 2 1411051552 13388816 6033328
15:06:10 37601 8192000000 10310423024 10761887744 1396081152 14.560 100 20 40 1 1419386224 18392032 4913040
15:07:49 17676 8192000000 10305393824 10745446400 1394022624 14.542 100 32 64 1 1410653024 8555088 8075312
15:09:17 43711 8192000000 10320612144 10764521472 1410000416 14.684 100 36 72 0 1427771424 9683504 8087504
15:11:26 65576 8192000000 10291453312 10734108672 1378778192 14.406 98 37 74 0 1395969824 8925872 8265760
15:13:34 24658 8192000000 10298623456 10753007616 1390302112 14.509 99 18 34 0 1400195072 5533952 4359008
15:15:19 9941 8192000000 10309113632 10753126400 1399845232 14.594 100 44 88 1 1419484816 9568384 10071200
15:16:38 6878 8192000000 10302528464 10749177856 1384906944 14.460 100 33 62 1 1405360240 12507552 7945744
15:17:46 60904 8192000000 10281676224 10732122112 1358856352 14.227 99 28 57 1 1379778384 13831968 7090064
15:19:52 10088 8192000000 10265317568 10715828224 1356274720 14.204 99 21 40 1 1377766896 16678928 4813248
15:21:07 32973 8192000000 10275852304 10729951232 1351981056 14.165 99 25 48 0 1380894368 21997472 6915840
15:22:45 95384 8192000000 10283438160 10735493120 1334673376 14.009 97 31 62 1 1371956704 29787104 7496224
15:25:35 64321 8192000000 10248693184 10712182784 1292484928 13.627 95 16 31 0 1314237232 18252480 3499824
15:27:47 14848 8192000000 10278642048 10711461888 1346067392 14.112 99 59 115 1 1370145952 11494432 12584128
15:29:07 57733 8192000000 10252464208 10698809344 1295333072 13.653 95 24 47 0 1311585152 11553024 4699056
15:31:09 29921 8192000000 10258805808 10698129408 1312142832 13.806 97 33 67 0 1330286528 10732496 7411200
15:32:41 21756 8192000000 10260853312 10696679424 1341987328 14.075 100 36 70 0 1358596576 8355216 8254032
15:34:03 28241 8192000000 10255863616 10701611008 1336318672 14.024 100 24 46 0 1363059264 21639440 5101152
15:35:32 13191 8192000000 10279950000 10714734592 1345377296 14.106 99 41 82 0 1367140800 12812768 8950736
15:36:46 140053 8192000000 10284000336 10742607872 1341902736 14.075 98 14 26 0 1360342800 15489984 2950080
15:40:38 71144 8192000000 10285083040 10731089920 1365575584 14.287 99 26 52 0 1385399248 14156528 5667136
15:43:04 20478 8192000000 10262294336 10697302016 1321744240 13.892 96 36 72 1 1341879456 12414800 7720416
15:44:25 26024 8192000000 10286127616 10740629504 1379464000 14.412 100 16 30 0 1397700096 14645216 3590880
15:45:54 32024 8192000000 10306100304 10776662016 1390368672 14.509 100 9 18 0 1416456368 24128976 1958720
15:48:34 45221 8192000000 10302168432 10757701632 1375636912 14.378 98 26 52 0 1394443088 12341920 6464256
15:50:22 37923 8192000000 10322562624 10780381184 1406420368 14.652 100 18 35 0 1426877584 16073280 4383936
15:52:11 78412 8192000000 10326961536 10794496000 1416987760 14.746 100 10 20 0 1436098960 16667088 2444112
15:54:31 24272 8192000000 10324295056 10777100288 1396229296 14.561 99 27 54 0 1411864112 9564176 6070640
15:55:56 95113 8192000000 10300903088 10753265664 1365621648 14.288 97 23 45 0 1383301696 12574880 5105168
15:58:33 124561 8192000000 10295645888 10745339904 1341044288 14.067 96 12 24 1 1362095552 19004944 2046320
16:01:47 51892 8192000000 10288599936 10733621248 1343099888 14.085 96 31 62 0 1357413776 7222352 7091536
16:03:40 41900 8192000000 10278548560 10727108608 1365884512 14.290 99 41 80 0 1384949584 10697904 8367168
16:05:26 37945 8192000000 10276966768 10739421184 1357852256 14.218 98 14 28 0 1376207632 15318624 3036752
16:07:04 38186 8192000000 10277215872 10744426496 1359233200 14.230 98 9 18 0 1374966192 13596784 2136208
16:08:43 60634 8192000000 10266632944 10729218048 1357693104 14.217 99 14 28 0 1377261040 16133968 3433968
16:11:31 30799 8192000000 10252880624 10699145216 1248613984 13.225 91 26 52 0 1261410880 7012128 5784768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 20-03-2024 16:13:53 to 20-03-2024 16:14:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          176887
MON$OLDEST_ACTIVE               178315
MON$OLDEST_SNAPSHOT             178315
MON$NEXT_TRANSACTION            178315
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                       1921568
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 Wed Mar 20 16:14:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        93093 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176887 
    Oldest active        178315 
    Oldest snapshot        178315 
    Next transaction    178316 
    Sequence number        0 
    Next attachment ID    720 
    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.36, total records: 7757852 
    Average version length: 48.16, total versions: 85664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87048 
    Data pages: 87048, average fill: 71% 
    Primary pages: 87048, secondary pages: 0, swept pages: 19669 
    Empty pages: 6, full pages: 64875 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 219 
    40 - 59% = 3121 
    60 - 79% = 83662 
    80 - 99% = 18 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23327, nodes: 7757852 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1735521, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 310 
        20 - 39% = 1741 
        40 - 59% = 4334 
        60 - 79% = 2322 
        80 - 99% = 14620 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13555, nodes: 7757852 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1557341, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1618 
        40 - 59% = 2050 
        60 - 79% = 1058 
        80 - 99% = 8829 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8351, nodes: 7757852 
    Average node length: 6.62, total dup: 5800128, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1550133, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 992 
        40 - 59% = 1410 
        60 - 79% = 890 
        80 - 99% = 4955 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.30, total records: 2247981 
    Average version length: 34.56, total versions: 89064, max versions: 3 
    Average fragment length: 4.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28520 
    Data pages: 28520, average fill: 73% 
    Primary pages: 28515, secondary pages: 5, swept pages: 11061 
    Empty pages: 0, full pages: 20417 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 107 
    40 - 59% = 1942 
    60 - 79% = 25794 
    80 - 99% = 666 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4576, nodes: 2247981 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 698408, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 943 
        40 - 59% = 843 
        60 - 79% = 745 
        80 - 99% = 2044 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2532, nodes: 2250220 
    Average node length: 4.97, total dup: 2249321, max dup: 19391 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1255086, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 275 
        40 - 59% = 1544 
        60 - 79% = 519 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2057, nodes: 2247981 
    Average node length: 4.97, total dup: 2247931, max dup: 130321 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062484, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 60 
        40 - 59% = 1120 
        60 - 79% = 50 
        80 - 99% = 823 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4389, nodes: 2247981 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 698408, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 613 
        40 - 59% = 619 
        60 - 79% = 803 
        80 - 99% = 2233 
 
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: 81.99, total records: 400 
    Average version length: 22.41, total versions: 253884, max versions: 664 
    Average fragment length: 2.00, total fragments: 73, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1416 
    Data pages: 1416, average fill: 88% 
    Primary pages: 13, secondary pages: 1403, swept pages: 0 
    Empty pages: 6, full pages: 1409 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 1405 
 
    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: 4.78, total records: 88095 
    Average version length: 68.30, total versions: 81934, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 18.41 
    Pointer pages: 7, data page slots: 2064 
    Data pages: 1648, average fill: 67% 
    Primary pages: 1647, secondary pages: 1, swept pages: 0 
    Empty pages: 182, full pages: 1030 
    Fill distribution: 
     0 - 19% = 239 
    20 - 39% = 128 
    40 - 59% = 143 
    60 - 79% = 235 
    80 - 99% = 903 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1695689, depth: 3, leaf buckets: 290, nodes: 88095 
    Average node length: 13.37, total dup: 6642, max dup: 1 
    Average key length: 10.63, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 61158, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 88 
        40 - 59% = 112 
        60 - 79% = 87 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18426, max versions: 979 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 92% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 64 
 
    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: 3.18, total records: 1479 
    Average version length: 43.52, total versions: 1373, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 18.22 
    Pointer pages: 1, data page slots: 32 
    Data pages: 27, average fill: 53% 
    Primary pages: 26, secondary pages: 1, swept pages: 3 
    Empty pages: 4, full pages: 11 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89108, depth: 2, leaf buckets: 1, nodes: 1479 
    Average node length: 4.46, total dup: 1381, max dup: 164 
    Average key length: 2.69, compression ratio: 7.06 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 796, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 1 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.03, total records: 75 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    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.33, total records: 803747 
    Average version length: 25.59, total versions: 58772, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8200 
    Data pages: 8200, average fill: 68% 
    Primary pages: 8171, secondary pages: 29, swept pages: 2147 
    Empty pages: 89, full pages: 6345 
    Fill distribution: 
     0 - 19% = 163 
    20 - 39% = 165 
    40 - 59% = 381 
    60 - 79% = 7283 
    80 - 99% = 208 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 898, nodes: 803747 
    Average node length: 4.87, total dup: 803698, max dup: 153451 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88761, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 147 
        40 - 59% = 487 
        60 - 79% = 206 
        80 - 99% = 57 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 982, nodes: 803747 
    Average node length: 5.88, total dup: 715790, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158953, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 105 
        40 - 59% = 495 
        60 - 79% = 142 
        80 - 99% = 239 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1020, nodes: 803747 
    Average node length: 5.88, total dup: 715790, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160960, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 205 
        40 - 59% = 449 
        60 - 79% = 124 
        80 - 99% = 242 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1139, nodes: 803747 
    Average node length: 5.96, total dup: 715790, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153707, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 250 
        40 - 59% = 586 
        60 - 79% = 205 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5458 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.46, total fragments: 52, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 86, average fill: 63% 
    Primary pages: 71, secondary pages: 15, swept pages: 54 
    Empty pages: 7, full pages: 67 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5458 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5119, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        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: 5458 
    Average node length: 11.14, 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: 142, 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.15, total records: 81314 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 783 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 783 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36475, depth: 2, leaf buckets: 104, nodes: 81314 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3458, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
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: 110.57, 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.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.26, total records: 169881 
    Average version length: 151.48, total versions: 2177, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 8, data page slots: 4696 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 4 
    Empty pages: 34, full pages: 4021 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4021 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.66, total records: 167838 
    Average version length: 150.52, total versions: 2747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 8, data page slots: 4560 
    Data pages: 4064, average fill: 85% 
    Primary pages: 4064, secondary pages: 0, swept pages: 8 
    Empty pages: 76, full pages: 3966 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 3966 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.11, total records: 171417 
    Average version length: 152.28, total versions: 3593, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 5000 
    Data pages: 4152, average fill: 85% 
    Primary pages: 4152, secondary pages: 0, swept pages: 6 
    Empty pages: 59, full pages: 4044 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 19 
    40 - 59% = 21 
    60 - 79% = 8 
    80 - 99% = 4043 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 138.03, total records: 176119 
    Average version length: 154.62, total versions: 14897, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 4288, average fill: 85% 
    Primary pages: 4288, secondary pages: 0, swept pages: 6 
    Empty pages: 97, full pages: 4164 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4163 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.01, total records: 136920 
    Average version length: 153.56, total versions: 7963, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 7, data page slots: 4656 
    Data pages: 3320, average fill: 85% 
    Primary pages: 3319, secondary pages: 1, swept pages: 3 
    Empty pages: 68, full pages: 3232 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 12 
    80 - 99% = 3230 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 141.66, total records: 166346 
    Average version length: 154.51, total versions: 10524, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 4552 
    Data pages: 4040, average fill: 85% 
    Primary pages: 4040, secondary pages: 0, swept pages: 11 
    Empty pages: 77, full pages: 3940 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 3937 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.51, total records: 156257 
    Average version length: 151.94, total versions: 3423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 6, data page slots: 4816 
    Data pages: 3744, average fill: 86% 
    Primary pages: 3744, secondary pages: 0, swept pages: 5 
    Empty pages: 35, full pages: 3687 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 3686 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.22, total records: 158222 
    Average version length: 153.19, total versions: 5872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 7, data page slots: 4568 
    Data pages: 3816, average fill: 86% 
    Primary pages: 3816, secondary pages: 0, swept pages: 4 
    Empty pages: 53, full pages: 3737 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3736 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.84, total records: 160126 
    Average version length: 147.70, total versions: 1353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 5344 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 6 
    Empty pages: 43, full pages: 3788 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3789 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.61, total records: 166367 
    Average version length: 150.72, total versions: 2687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 5352 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 4 
    Empty pages: 25, full pages: 3936 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3936 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.96, total records: 2093670 
    Average version length: 52.99, total versions: 31280, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25560, average fill: 70% 
    Primary pages: 25560, secondary pages: 0, swept pages: 11280 
    Empty pages: 330, full pages: 20522 
    Fill distribution: 
     0 - 19% = 605 
    20 - 39% = 499 
    40 - 59% = 1219 
    60 - 79% = 23005 
    80 - 99% = 232 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2616, nodes: 2093670 
    Average node length: 5.44, total dup: 1953308, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181736, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 355 
        40 - 59% = 1690 
        60 - 79% = 306 
        80 - 99% = 261 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2093670 
    Average node length: 5.69, total dup: 1878613, max dup: 77 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374602, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2411 
        60 - 79% = 317 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2165, nodes: 2093670 
    Average node length: 4.96, total dup: 2093570, max dup: 27145 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179388, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 226 
        40 - 59% = 1190 
        60 - 79% = 343 
        80 - 99% = 403 
 
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: 41.69, total records: 129763 
    Average version length: 69.15, total versions: 51629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.02 
    Pointer pages: 3, data page slots: 4104 
    Data pages: 2928, average fill: 51% 
    Primary pages: 2928, secondary pages: 0, swept pages: 501 
    Empty pages: 460, full pages: 1418 
    Fill distribution: 
     0 - 19% = 841 
    20 - 39% = 316 
    40 - 59% = 189 
    60 - 79% = 535 
    80 - 99% = 1047 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 316357, depth: 3, leaf buckets: 223, nodes: 129763 
    Average node length: 6.35, total dup: 113133, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 21905, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 99 
        60 - 79% = 39 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.31, total records: 7008684 
    Average version length: 68.75, total versions: 268650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 64, data page slots: 103232 
    Data pages: 103232, average fill: 72% 
    Primary pages: 103232, secondary pages: 0, swept pages: 37789 
    Empty pages: 11, full pages: 69942 
    Fill distribution: 
     0 - 19% = 133 
    20 - 39% = 1201 
    40 - 59% = 9224 
    60 - 79% = 89669 
    80 - 99% = 3005 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10746, nodes: 7008684 
    Average node length: 6.51, total dup: 6063882, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1565573, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1816 
        40 - 59% = 5959 
        60 - 79% = 2454 
        80 - 99% = 512 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8532, nodes: 7008684 
    Average node length: 5.40, total dup: 6730026, max dup: 181 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1365374, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1411 
        40 - 59% = 4551 
        60 - 79% = 1493 
        80 - 99% = 1070 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8612, nodes: 7008684 
    Average node length: 5.40, total dup: 6730026, max dup: 181 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1367943, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1471 
        40 - 59% = 4640 
        60 - 79% = 1422 
        80 - 99% = 1076 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.48, total records: 12035011 
    Average version length: 68.73, total versions: 256801, 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: 104, data page slots: 168816 
    Data pages: 168816, average fill: 76% 
    Primary pages: 168816, secondary pages: 0, swept pages: 85562 
    Empty pages: 3, full pages: 149711 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 670 
    40 - 59% = 5150 
    60 - 79% = 158863 
    80 - 99% = 4077 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18373, nodes: 12035011 
    Average node length: 6.58, total dup: 10490785, max dup: 53 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2364672, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2518 
        40 - 59% = 10686 
        60 - 79% = 4197 
        80 - 99% = 946 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 46.41, total records: 1517731 
    Average version length: 69.12, total versions: 499373, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.72 
    Pointer pages: 28, data page slots: 44040 
    Data pages: 27920, average fill: 62% 
    Primary pages: 27920, secondary pages: 0, swept pages: 8963 
    Empty pages: 3000, full pages: 17497 
    Fill distribution: 
     0 - 19% = 4983 
    20 - 39% = 2146 
    40 - 59% = 1875 
    60 - 79% = 11000 
    80 - 99% = 7916 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2205, nodes: 1517731 
    Average node length: 5.51, total dup: 1456433, max dup: 99 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 99947, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 744 
        40 - 59% = 1029 
        60 - 79% = 359 
        80 - 99% = 63 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 42.24, total records: 1026475 
    Average version length: 69.13, total versions: 398176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 22, data page slots: 34376 
    Data pages: 30152, average fill: 40% 
    Primary pages: 30152, secondary pages: 0, swept pages: 9522 
    Empty pages: 6978, full pages: 10186 
    Fill distribution: 
     0 - 19% = 12986 
    20 - 39% = 3751 
    40 - 59% = 1802 
    60 - 79% = 4597 
    80 - 99% = 7016 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1499, nodes: 1026475 
    Average node length: 5.76, total dup: 960549, max dup: 99 
    Average key length: 2.84, compression ratio: 14.80 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 135287, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 442 
        40 - 59% = 715 
        60 - 79% = 276 
        80 - 99% = 62 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.41, total records: 9069448 
    Average version length: 68.96, total versions: 325667, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 90, data page slots: 145512 
    Data pages: 145488, average fill: 67% 
    Primary pages: 145488, secondary pages: 0, swept pages: 72302 
    Empty pages: 395, full pages: 68383 
    Fill distribution: 
     0 - 19% = 1272 
    20 - 39% = 8131 
    40 - 59% = 28559 
    60 - 79% = 103335 
    80 - 99% = 4191 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13465, nodes: 9069448 
    Average node length: 6.69, total dup: 7525365, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1955043, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1492 
        40 - 59% = 6861 
        60 - 79% = 4482 
        80 - 99% = 620 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21171707 
    Average version length: 82.93, total versions: 10713, 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: 319128 
    Data pages: 319128, average fill: 81% 
    Primary pages: 319128, secondary pages: 0, swept pages: 13200 
    Empty pages: 32, full pages: 318325 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 37 
    40 - 59% = 95 
    60 - 79% = 27787 
    80 - 99% = 291154 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19426, nodes: 21171707 
    Average node length: 5.72, total dup: 20690405, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284397, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8189 
        60 - 79% = 550 
        80 - 99% = 10680 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17215, nodes: 21171707 
    Average node length: 6.31, total dup: 18605642, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914791, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 837 
        60 - 79% = 265 
        80 - 99% = 16105 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21184, nodes: 21171707 
    Average node length: 6.35, total dup: 18524586, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578974, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8417 
        60 - 79% = 588 
        80 - 99% = 12174 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16196, nodes: 21171707 
    Average node length: 5.56, total dup: 21171607, max dup: 229319 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943532, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 13 
        40 - 59% = 3060 
        60 - 79% = 372 
        80 - 99% = 12750 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.56, total records: 9528756 
    Average version length: 82.59, total versions: 329973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 172960 
    Data pages: 172960, average fill: 68% 
    Primary pages: 172960, secondary pages: 0, swept pages: 93665 
    Empty pages: 757, full pages: 87563 
    Fill distribution: 
     0 - 19% = 2099 
    20 - 39% = 9423 
    40 - 59% = 33269 
    60 - 79% = 75518 
    80 - 99% = 52651 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11400, nodes: 9528756 
    Average node length: 5.38, total dup: 9219784, max dup: 194 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2119301, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 139 
        40 - 59% = 8515 
        60 - 79% = 2661 
        80 - 99% = 81 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13553, nodes: 9528756 
    Average node length: 6.25, total dup: 7900939, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1479488, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 4254 
        40 - 59% = 4292 
        60 - 79% = 2601 
        80 - 99% = 2280 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12720, nodes: 9528756 
    Average node length: 6.00, total dup: 8261884, max dup: 39 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2299171, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 150 
        40 - 59% = 9513 
        60 - 79% = 2957 
        80 - 99% = 97 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10067, nodes: 9528756 
    Average node length: 5.15, total dup: 9528656, max dup: 154051 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1527741, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1323 
        40 - 59% = 5015 
        60 - 79% = 1646 
        80 - 99% = 2040 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.13, total records: 11257502 
    Average version length: 82.52, total versions: 296410, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194320 
    Data pages: 193136, average fill: 72% 
    Primary pages: 193136, secondary pages: 0, swept pages: 81017 
    Empty pages: 3380, full pages: 136828 
    Fill distribution: 
     0 - 19% = 5841 
    20 - 39% = 8856 
    40 - 59% = 21176 
    60 - 79% = 46160 
    80 - 99% = 111103 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11257502 
    Average node length: 5.31, total dup: 11147189, max dup: 645 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2349244, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 207 
        40 - 59% = 8996 
        60 - 79% = 3776 
        80 - 99% = 149 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10518, nodes: 11257502 
    Average node length: 5.51, total dup: 10766074, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714537, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 888 
        40 - 59% = 2648 
        60 - 79% = 1879 
        80 - 99% = 4940 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15012, nodes: 11257502 
    Average node length: 6.04, total dup: 9820923, max dup: 65 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2365623, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 284 
        40 - 59% = 10398 
        60 - 79% = 4152 
        80 - 99% = 177 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10864, nodes: 11257502 
    Average node length: 5.23, total dup: 11257402, max dup: 192992 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 703661, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 970 
        40 - 59% = 4828 
        60 - 79% = 1543 
        80 - 99% = 3429 
 
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: 79.90, total records: 9645069 
    Average version length: 82.90, total versions: 330634, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 109, data page slots: 177016 
    Data pages: 176984, average fill: 68% 
    Primary pages: 176984, secondary pages: 0, swept pages: 99020 
    Empty pages: 822, full pages: 87147 
    Fill distribution: 
     0 - 19% = 2361 
    20 - 39% = 10493 
    40 - 59% = 34918 
    60 - 79% = 78071 
    80 - 99% = 51141 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11774, nodes: 9645069 
    Average node length: 5.20, total dup: 9616292, max dup: 1523 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1924810, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1583 
        40 - 59% = 7749 
        60 - 79% = 1841 
        80 - 99% = 571 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13762, nodes: 9645069 
    Average node length: 6.27, total dup: 7996783, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438655, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 195 
        20 - 39% = 4283 
        40 - 59% = 4269 
        60 - 79% = 2630 
        80 - 99% = 2385 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12422, nodes: 9645069 
    Average node length: 5.46, total dup: 9211333, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2054474, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1534 
        40 - 59% = 8631 
        60 - 79% = 1672 
        80 - 99% = 552 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10258, nodes: 9645069 
    Average node length: 5.17, total dup: 9644969, max dup: 156133 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1536955, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1405 
        40 - 59% = 5192 
        60 - 79% = 1572 
        80 - 99% = 2048 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.61, total records: 575346 
    Average version length: 68.85, total versions: 4692, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 75% 
    Primary pages: 8032, secondary pages: 0, swept pages: 4143 
    Empty pages: 7, full pages: 6536 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 21 
    40 - 59% = 255 
    60 - 79% = 7667 
    80 - 99% = 80 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 31084, depth: 3, leaf buckets: 749, nodes: 575346 
    Average node length: 5.95, total dup: 489932, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100022, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 536 
        60 - 79% = 94 
        80 - 99% = 81 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 22797, depth: 3, leaf buckets: 764, nodes: 575346 
    Average node length: 6.15, total dup: 471831, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100073, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 545 
        60 - 79% = 96 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 583, nodes: 575346 
    Average node length: 4.86, total dup: 575246, max dup: 9557 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88817, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 351 
        60 - 79% = 95 
        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 Wed Mar 20 16:14:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7757852 85664 1 0.0000 0.0000
DOC_LIST 2247981 89064 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 253884 664 63400.0000 0.0000
INVNT_TURNOVER_LOG 88095 81934 1 0.0000 0.0000
MONEY_SALDO 49 18426 979 37600.0000 0.0000
MONEY_TURNOVER_LOG 1479 1373 1 0.0000 0.0000
PDISTR 803747 58772 4 0.0000 0.0000
PERF_SPLIT_0 169881 2177 1 0.0000 0.0000
PERF_SPLIT_1 167838 2747 1 0.0000 0.0000
PERF_SPLIT_2 171417 3593 1 0.0000 0.0000
PERF_SPLIT_3 176119 14897 1 0.0000 0.0000
PERF_SPLIT_4 136920 7963 1 0.0000 0.0000
PERF_SPLIT_5 166346 10524 1 0.0000 0.0000
PERF_SPLIT_6 156257 3423 1 0.0000 0.0000
PERF_SPLIT_7 158222 5872 1 0.0000 0.0000
PERF_SPLIT_8 160126 1353 1 0.0000 0.0000
PERF_SPLIT_9 166367 2687 1 0.0000 0.0000
PSTORNED 2093670 31280 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 129763 51629 1 0.0000 0.0000
XQD_1000_3300 7008684 268650 1 0.0000 0.0000
XQD_1200_2000 12035011 256801 1 0.0000 0.0000
XQD_2000_3300 1517731 499373 1 0.0000 0.0000
XQD_2100_3300 1026475 398176 1 0.0000 0.0000
XQD_3300_3400 9069448 325667 1 0.0000 0.0000
XQS_1000_1200 21171707 10713 1 0.0000 0.0000
XQS_1000_3300 9528756 329973 1 0.0000 0.0000
XQS_1200_2000 11257502 296410 1 0.0000 0.0000
XQS_2100_3300 9645069 330634 1 0.0000 0.0000
XQS_3300_3400 575346 4692 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Wed Mar 20 16:12:20 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Wed Mar 20 16:12:22 2024
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

20.03.24 16:14:47. 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-03-20 16:14:49 No severe PSQL-related problems occured
20.03.24 16:14:51. End of report.