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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15745904 kB
MemAvailable 30250964 kB
Buffers 0 kB
Cached 15981464 kB
SwapCached 2260 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-02 01:10:13
DTS_END                         2024-03-02 01:09:40.2120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50990
TRN_ID                          184391
ATT_ID                          274
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: 9387.80 16845 938780
customer order: creation 187.21 352 18721
customer order: refuse 15.47 341 1547
order to supplier: creation 50.02 1186 5002
order to supplier: removal 3.34 118072 334
invoice (draft): creation 48.24 3418 4824
invoice (draft): removal 49.07 921 4907
invoice accept: apply 46.10 20741 4610
invoice accept: cancel 44.17 995 4417
customer reserve: creation 4311.66 204 431166
customer reserve: removal 4326.00 73 432600
realization accept: apply 90.58 209 9058
realization accept: cancel 76.07 123 7607
payment from customer: creation 63.67 129 6367
payment from customer: removal 5.91 90 591
payment to supplier: creation 52.45 150 5245
payment to supplier: removal 3.87 94 387
service: total inventory turnovers 5.27 1093 527
service: total monetary turnovers 7.67 41 767
service: aggregate perf. data 1.00 16205 100
service: refresh index statistics 0.03 172464 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-03-2024 01:10:45 to 02-03-2024 01:10:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3495
TEST_TIME 2 2499
TEST_TIME 3 2405
TEST_TIME 4 3682
TEST_TIME 5 3586
TEST_TIME 6 4008
TEST_TIME 7 4564
TEST_TIME 8 4949
TEST_TIME 9 4915
TEST_TIME 10 5140
TEST_TIME 11 5177
TEST_TIME 12 5209
TEST_TIME 13 5854
TEST_TIME 14 6189
TEST_TIME 15 6094
TEST_TIME 16 6290
TEST_TIME 17 6453
TEST_TIME 18 6776
TEST_TIME 19 7480
TEST_TIME 20 7699
TEST_TIME 21 7570
TEST_TIME 22 7877
TEST_TIME 23 7819
TEST_TIME 24 8309
TEST_TIME 25 8281
TEST_TIME 26 8375
TEST_TIME 27 8508
TEST_TIME 28 9083
TEST_TIME 29 9347
TEST_TIME 30 9429
TEST_TIME 31 9981
TEST_TIME 32 9898
TEST_TIME 33 9892
TEST_TIME 34 9681
TEST_TIME 35 9882
TEST_TIME 36 9722
TEST_TIME 37 9629
TEST_TIME 38 9555
TEST_TIME 39 9538
TEST_TIME 40 9342
TEST_TIME 41 9351
TEST_TIME 42 9442
TEST_TIME 43 9449
TEST_TIME 44 9484
TEST_TIME 45 9487
TEST_TIME 46 9408
TEST_TIME 47 9371
TEST_TIME 48 9419
TEST_TIME 49 9367
TEST_TIME 50 9323
TEST_TIME 51 9238
TEST_TIME 52 9226
TEST_TIME 53 9138
TEST_TIME 54 9186
TEST_TIME 55 9147
TEST_TIME 56 9143
TEST_TIME 57 9200
TEST_TIME 58 9232
TEST_TIME 59 9306
TEST_TIME 60 9263
TEST_TIME 61 9383
TEST_TIME 62 9366
TEST_TIME 63 9361
TEST_TIME 64 9487
TEST_TIME 65 9505
TEST_TIME 66 9524
TEST_TIME 67 9474
TEST_TIME 68 9413
TEST_TIME 69 9363
TEST_TIME 70 9334
TEST_TIME 71 9356
TEST_TIME 72 9304
TEST_TIME 73 9284
TEST_TIME 74 9278
TEST_TIME 75 9294
TEST_TIME 76 9287
TEST_TIME 77 9262
TEST_TIME 78 9322
TEST_TIME 79 9336
TEST_TIME 80 9440
TEST_TIME 81 9417
TEST_TIME 82 9414
TEST_TIME 83 9506
TEST_TIME 84 9476
TEST_TIME 85 9560
TEST_TIME 86 9511
TEST_TIME 87 9484
TEST_TIME 88 9428
TEST_TIME 89 9366
TEST_TIME 90 9368
TEST_TIME 91 9288
TEST_TIME 92 9267
TEST_TIME 93 9261
TEST_TIME 94 9289
TEST_TIME 95 9269
TEST_TIME 96 9276
TEST_TIME 97 9286
TEST_TIME 98 9402
TEST_TIME 99 9458
TEST_TIME 100 9390

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-03-2024 01:10:48 to 02-03-2024 01:10:51.

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 1333361 1333361 0 0.00 0 25769 8 0 0
doc_list_biud 1333361 1333361 0 0.00 0 78414 30 0 0
sp_add_invoice_to_stock 4732 4610 122 2.57 27 200686 20741 0 122
sp_cancel_adding_invoice 4417 4417 0 0.00 5 53465 996 0 0
sp_cancel_client_order 1547 1547 0 0.00 4 7650 342 0 0
sp_cancel_customer_reserve 432600 432600 0 0.00 0 21058 74 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 3 5824 90 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 3 8339 94 0 0
sp_cancel_supplier_invoice 4918 4907 11 0.22 2 78485 921 0 11
sp_cancel_supplier_order 334 334 0 0.00 6 936784 118073 0 0
sp_cancel_write_off 7607 7607 0 0.00 1 8926 123 0 0
sp_client_order 18721 18721 0 0.00 3 14088 353 0 0
sp_customer_reserve 431166 431166 0 0.00 0 27501 204 0 0
sp_fill_shopping_cart 28542 28542 0 0.00 1 17052 35 0 0
sp_fill_shopping_cart_clo_res 431165 431165 0 0.00 0 19602 15 0 0
sp_get_clo_for_invoice 4606 4606 0 0.00 0 24712 282 0 0
sp_kill_cost_storno 13002 13002 0 0.00 0 7629 68 0 0
sp_kill_qstorno_ret_qs2qd 878048 878048 0 0.00 0 78408 40 0 0
sp_kill_qty_storno 465074 465074 0 0.00 0 78411 85 0 0
sp_lock_selected_doc 18883 18883 0 0.00 0 8914 6 0 0
sp_make_cost_storno 25274 25274 0 0.00 0 24315 81 0 0
sp_multiply_rows_for_pdistr 25274 25274 0 0.00 0 15286 31 0 0
sp_multiply_rows_for_qdistr 18721 18721 0 0.00 0 9612 175 0 0
sp_pay_from_customer 6367 6367 0 0.00 4 25049 130 0 0
sp_pay_to_supplier 5245 5245 0 0.00 5 19369 150 0 0
sp_payment_common 11612 11612 0 0.00 1 15102 36 0 0
sp_qd_handle_on_cancel_clo 1547 1547 0 0.00 0 7637 308 0 0
sp_qd_handle_on_invoice_upd_sts 9021 9021 0 0.00 0 33929 350 0 0
sp_qd_handle_on_reserve_upd_sts 9058 9058 0 0.00 0 17703 64 0 0
sp_reserve_write_off 9058 9058 0 0.00 6 22417 210 0 0
sp_supplier_invoice 4824 4824 0 0.00 5 91094 3418 0 0
sp_supplier_order 5002 5002 0 0.00 5 80140 1186 0 0
srv_aggregate_perf_data 100 100 0 0.00 1489 334768 16205 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1217 123196 39977 0 0
srv_find_qd_qs_mism 892925 892925 0 0.00 0 10302 7 0 0
srv_make_invnt_saldo 527 527 0 0.00 32 55666 1094 0 0
srv_make_money_saldo 767 767 0 0.00 0 5815 42 0 0
srv_recalc_idx_stat 3 3 0 0.00 125428 203323 172464 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4610 4610 0 0.00 0 37981 205 0 0
t$perf-norm:sp_cancel_adding_invoice 384 384 0 0.00 0 6311 123 0 0
t$perf-norm:sp_cancel_client_order 1547 1547 0 0.00 0 3211 14 0 0
t$perf-norm:sp_cancel_customer_reserve 638 638 0 0.00 0 812 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 1772 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 1697 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 2906 25 0 0
t$perf-norm:sp_cancel_supplier_order 334 334 0 0.00 0 27285 2001 0 0
t$perf-norm:sp_cancel_write_off 961 961 0 0.00 0 586 4 0 0
t$perf-norm:sp_client_order 18721 18721 0 0.00 0 37390 19 0 0
t$perf-norm:sp_customer_reserve 895 895 0 0.00 0 2025 14 0 0
t$perf-norm:sp_pay_from_customer 6367 6367 0 0.00 0 9408 11 0 0
t$perf-norm:sp_pay_to_supplier 5245 5245 0 0.00 0 3357 11 0 0
t$perf-norm:sp_reserve_write_off 9058 9058 0 0.00 0 6600 11 0 0
t$perf-norm:sp_supplier_invoice 4824 4824 0 0.00 0 2911 16 0 0
t$perf-norm:sp_supplier_order 5002 5002 0 0.00 0 3319 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 163 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1097 21 0 0
t$perf-norm:srv_make_invnt_saldo 527 527 0 0.00 0 12571 42 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 4307 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 10 6 0 0
v_add_invoice_to_stock 9452 9208 244 2.58 0 5580 20 0 244
v_all_customers 34254 34254 0 0.00 0 99 1 0 0
v_all_suppliers 27518 27518 0 0.00 0 54 1 0 0
v_all_wares 37442 37442 0 0.00 0 182 1 0 0
v_cancel_adding_invoice 768 768 0 0.00 0 1791 10 0 0
v_cancel_client_order 3094 3094 0 0.00 0 5172 7 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 5224 11 0 0
v_cancel_customer_reserve 1276 1276 0 0.00 0 4713 10 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 5577 14 0 0
v_cancel_supplier_invoice 780 758 22 2.82 0 5591 26 0 22
v_cancel_supplier_order 668 668 0 0.00 0 2006 6 0 0
v_cancel_write_off 1922 1922 0 0.00 0 5191 17 0 0
v_max_id_clo_ord 5001 5001 0 0.00 0 3620 2 0 0
v_max_id_clo_res 895 895 0 0.00 0 1588 14 0 0
v_max_id_ord_sup 4818 4818 0 0.00 0 1561 3 0 0
v_max_non_paid_invoice 1305 1305 0 0.00 0 2424 5 0 0
v_max_non_paid_realizn 3190 3190 0 0.00 0 1105 4 0 0
v_min_id_clo_ord 5001 5001 0 0.00 0 2757 9 0 0
v_min_id_clo_res 895 895 0 0.00 0 2951 9 0 0
v_min_id_ord_sup 4818 4818 0 0.00 0 5399 10 0 0
v_min_non_paid_invoice 5245 5245 0 0.00 0 14496 25 0 0
v_min_non_paid_realizn 6367 6367 0 0.00 0 15096 28 0 0
v_our_firm 9542 9542 0 0.00 0 18 1 0 0
v_reserve_write_off 18116 18116 0 0.00 0 5174 7 0 0
x_lock_depdocs_on_canc_invoice 8945 8945 0 0.00 0 18112 137 0 0
x_lock_depdocs_on_canc_sup_ord 334 334 0 0.00 0 4097 322 0 0
x_make_qstorno_1000_1200 5002 5002 0 0.00 1 80111 1105 0 0
x_make_qstorno_1200_2000 4824 4824 0 0.00 2 89384 3295 0 0
x_make_qstorno_2100_3300 431166 431166 0 0.00 0 27500 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-03-2024 01:10:53 to 02-03-2024 01:10:57.

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
23:09:44 5 8192000000 8809579776 8824459264 14276064 0.173 4 3 4 0 14466016 82832 107120
23:10:45 25166 8192000000 9893895952 10200432640 972346416 10.610 100 87 174 0 1001149760 5973008 22830336
23:12:13 11399 8192000000 9934703360 10253369344 1018092752 11.054 100 89 178 0 1049560656 8038384 23429520
23:13:31 17208 8192000000 9966865152 10295767040 1053870624 11.398 100 90 180 0 1086018224 9447504 22700096
23:14:55 11328 8192000000 10009818064 10353627136 1097165968 11.811 100 73 146 1 1124862704 10185872 17510864
23:16:13 9498 8192000000 10061487248 10415648768 1148200864 12.293 100 78 156 0 1177978400 11677760 18099776
23:17:25 3448 8192000000 10105058080 10466930688 1189200960 12.676 100 81 161 0 1220175632 13327392 17647280
23:18:31 2412 8192000000 10137124000 10511818752 1226023696 13.017 100 84 166 0 1258197616 13324784 18849136
23:19:36 2045 8192000000 10162669072 10545852416 1253470576 13.270 100 72 144 0 1282297888 13106912 15720400
23:20:39 1306 8192000000 10207464208 10592555008 1290355392 13.607 100 95 188 0 1324558752 13686592 20516768
23:21:41 6431 8192000000 10208308000 10603057152 1300937472 13.704 100 56 110 0 1324200832 11165712 12097648
23:22:49 8760 8192000000 10198755424 10610376704 1310676592 13.792 100 29 58 0 1323768320 6802224 6289504
23:24:01 7445 8192000000 10212029456 10626723840 1322158832 13.896 100 24 47 0 1337296672 9622000 5515840
23:25:09 22766 8192000000 10217155120 10643230720 1329136576 13.959 100 13 25 0 1341197872 9127536 2933760
23:26:35 5643 8192000000 10215985568 10639466496 1333549920 13.999 100 18 36 0 1342038432 4576848 3911664
23:27:45 3693 8192000000 10227392144 10647597056 1335991696 14.021 100 30 60 0 1349323952 6558880 6773376
23:28:51 7569 8192000000 10214946608 10636967936 1328436032 13.953 100 18 36 0 1338834704 6270432 4128240
23:30:05 36001 8192000000 10219151136 10626797568 1283920352 13.549 97 20 40 0 1293933824 5237216 4776256
23:31:43 100751 8192000000 10218111456 10638270464 1302026512 13.714 98 37 74 0 1321637408 11075072 8535824
23:34:31 11248 8192000000 10211662496 10613002240 1286272624 13.570 97 47 94 0 1314274096 17493792 10507680
23:35:55 11239 8192000000 10242692192 10649481216 1317881984 13.858 99 49 96 0 1347764864 18620336 11262544
23:37:25 7539 8192000000 10241561264 10645078016 1303679216 13.729 98 60 118 1 1340043248 22840448 13523584
23:38:37 16849 8192000000 10240317120 10638991360 1315807680 13.839 100 60 119 1 1351958592 22770144 13380768
23:40:01 17877 8192000000 10250628336 10646765568 1308890224 13.776 99 57 114 0 1346411072 24231712 13289136
23:41:27 2789 8192000000 10271330496 10669551616 1333900320 14.002 100 70 140 2 1380262656 29994336 16368000
23:42:34 22578 8192000000 10276776080 10689912832 1337600480 14.036 99 47 94 2 1376422176 27413424 11408272
23:44:03 3078 8192000000 10310879392 10717679616 1375182464 14.373 100 69 138 0 1418712560 27385296 16144800
23:45:10 2542 8192000000 10321160528 10729115648 1377233808 14.392 100 71 141 0 1428120864 33613056 17274000
23:46:18 4204 8192000000 10339693296 10740744192 1383852720 14.451 100 84 168 1 1445092144 40810896 20428528
23:47:27 8156 8192000000 10325261216 10734100480 1370306480 14.330 99 63 125 0 1428440960 42514096 15620384
23:48:43 2085 8192000000 10346011456 10752323584 1381265520 14.428 99 89 175 3 1437276544 34380528 21630496
23:49:50 5151 8192000000 10336641824 10757263360 1399678368 14.592 100 45 89 2 1441753840 31123536 10951936
23:51:01 1217 8192000000 10374468496 10784911360 1417529328 14.751 100 87 173 1 1476838608 38302160 21007120
23:52:07 14971 8192000000 10360575344 10796642304 1424446000 14.812 100 37 72 1 1474540864 39882576 10212288
23:53:43 6988 8192000000 10377911584 10817257472 1434052800 14.897 100 44 87 2 1481159440 35061424 12045216
23:54:54 36825 8192000000 10357559408 10795433984 1411378400 14.696 99 37 74 0 1465607392 44106336 10122656
23:56:39 12944 8192000000 10353920432 10790342656 1405733392 14.646 100 29 57 0 1459100832 45305408 8062032
23:57:55 30349 8192000000 10339621440 10800873472 1409122608 14.676 100 12 24 0 1448969456 36386368 3460480
23:59:27 30651 8192000000 10334477872 10777550848 1391646192 14.521 99 22 44 0 1429526400 31884304 5995904
00:01:14 32669 8192000000 10316728576 10770436096 1409683328 14.681 100 26 51 0 1427600304 12286400 5630576
00:02:50 56850 8192000000 10337714128 10784616448 1418592144 14.760 100 33 67 1 1439363024 13691888 7078992
00:04:54 53859 8192000000 10324921056 10770370560 1401885648 14.612 99 13 26 0 1418629408 13533872 3209888
00:06:51 81152 8192000000 10313217072 10768928768 1401996016 14.613 99 32 64 0 1417917120 8379072 7542032
00:09:27 52951 8192000000 10338276064 10789961728 1396575408 14.564 98 40 78 0 1412235424 6716400 8943616
00:11:21 32923 8192000000 10331233872 10786344960 1418081456 14.756 100 29 58 0 1437607392 12645168 6880768
00:12:55 18209 8192000000 10311357264 10774933504 1399816448 14.593 99 30 60 0 1416008288 9444016 6747824
00:14:21 57237 8192000000 10287752896 10749554688 1367751680 14.307 98 10 20 0 1382075392 12041744 2281968
00:16:20 66250 8192000000 10285070048 10738364416 1359712608 14.235 98 19 36 0 1375133328 10962928 4457792
00:18:39 57215 8192000000 10291407648 10742870016 1370724032 14.334 99 27 53 0 1389791696 12375248 6692416
00:20:36 60787 8192000000 10246362192 10712457216 1294523008 13.645 94 15 30 0 1305695808 7729760 3443040
00:22:42 36976 8192000000 10250046976 10701017088 1326414064 13.935 98 18 36 1 1337785600 7415360 3956176
00:24:19 20465 8192000000 10264940096 10707558400 1339868672 14.056 99 26 52 0 1353317424 7685680 5763072
00:25:41 19859 8192000000 10261099728 10694144000 1323974928 13.913 99 45 90 1 1349928192 16246352 9706912
00:27:04 42927 8192000000 10249795872 10699169792 1335607920 14.018 100 30 60 0 1355809408 13654176 6547312
00:28:47 24268 8192000000 10257389712 10707484672 1333231472 13.996 99 29 58 2 1354198464 14636528 6330464
00:30:12 77537 8192000000 10250947232 10696609792 1313283488 13.816 97 13 26 0 1331259136 15687552 2288096
00:32:35 31387 8192000000 10274856304 10718957568 1353946816 14.183 100 44 88 0 1379123840 15534096 9642928
00:34:07 40423 8192000000 10258509568 10697392128 1323158752 13.905 98 36 66 0 1340416256 9641232 7616272
00:36:02 105092 8192000000 10265151648 10709950464 1345363200 14.106 99 20 40 0 1358273504 8007296 4903008
00:38:50 28607 8192000000 10281904320 10727010304 1367963568 14.309 100 40 79 0 1386352208 9676480 8712160
00:40:26 58908 8192000000 10273458608 10733350912 1368169280 14.311 99 16 30 0 1378278496 6972800 3136416
00:44:18 30961 8192000000 10288190560 10739818496 1379901168 14.416 100 28 56 0 1395631264 9351056 6379040
00:45:53 35036 8192000000 10315610944 10760716288 1396659696 14.565 100 39 78 3 1414604384 9309680 8635008
00:47:32 59401 8192000000 10312952176 10776424448 1406520896 14.653 100 21 41 0 1426723264 15471856 4730512
00:49:31 67702 8192000000 10322369376 10771873792 1373600048 14.359 98 21 42 0 1389689136 11645984 4443104
00:51:41 81771 8192000000 10303052496 10760564736 1370943760 14.336 98 10 20 0 1394440192 21280896 2215536
00:54:03 64548 8192000000 10304579616 10773073920 1398315712 14.580 100 22 44 0 1415733872 12749424 4668736
00:56:08 123196 8192000000 10280208944 10739011584 1365034144 14.283 98 29 58 0 1379700000 8789584 5876272
00:59:17 71478 8192000000 10252878800 10710863872 1304247264 13.734 95 19 38 0 1319889424 11177040 4465120
01:01:30 46839 8192000000 10241976720 10708369408 1337039536 14.031 99 10 20 0 1348840528 9427984 2373008
01:03:18 50771 8192000000 10273028160 10725105664 1303376128 13.726 95 22 44 0 1320734096 12087104 5270864
01:05:09 51990 8192000000 10268853856 10711961600 1326126368 13.932 97 29 58 1 1348032688 15079888 6826432
01:07:02 112392 8192000000 10274193920 10722570240 1314817264 13.830 97 14 26 0 1339862736 22028768 3016704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

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

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          204669
MON$OLDEST_ACTIVE               204670
MON$OLDEST_SNAPSHOT             204670
MON$NEXT_TRANSACTION            204670
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                       1912736
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.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 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 Sat Mar  2 01:11:17 2024 
 
Database header page information: 
    Flags            0 
    Generation        110792 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    204669 
    Oldest active        204670 
    Oldest snapshot        204670 
    Next transaction    204671 
    Sequence number        0 
    Next attachment ID    735 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.15, total records: 7853621 
    Average version length: 48.16, total versions: 121937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87064 
    Data pages: 87064, average fill: 72% 
    Primary pages: 87064, secondary pages: 0, swept pages: 14579 
    Empty pages: 2, full pages: 70546 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 131 
    40 - 59% = 1142 
    60 - 79% = 85728 
    80 - 99% = 49 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23595, nodes: 7853621 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1752637, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 349 
        20 - 39% = 1591 
        40 - 59% = 4537 
        60 - 79% = 2231 
        80 - 99% = 14887 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13694, nodes: 7853621 
    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: 1574486, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1511 
        40 - 59% = 2258 
        60 - 79% = 985 
        80 - 99% = 8940 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8470, nodes: 7853621 
    Average node length: 6.64, total dup: 5840886, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1567252, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 138 
        20 - 39% = 872 
        40 - 59% = 1565 
        60 - 79% = 847 
        80 - 99% = 5048 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.78, total records: 2305701 
    Average version length: 34.51, total versions: 131619, max versions: 3 
    Average fragment length: 5.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28496 
    Data pages: 28496, average fill: 75% 
    Primary pages: 28491, secondary pages: 5, swept pages: 8003 
    Empty pages: 7, full pages: 24960 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 71 
    40 - 59% = 849 
    60 - 79% = 25896 
    80 - 99% = 1664 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4655, nodes: 2305701 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 707280, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 875 
        40 - 59% = 942 
        60 - 79% = 679 
        80 - 99% = 2159 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2537, nodes: 2308792 
    Average node length: 4.97, total dup: 2307893, max dup: 20266 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1273880, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 188 
        40 - 59% = 1562 
        60 - 79% = 606 
        80 - 99% = 180 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2105, nodes: 2305701 
    Average node length: 4.97, total dup: 2305651, max dup: 130807 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074281, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 10 
        40 - 59% = 1261 
        60 - 79% = 48 
        80 - 99% = 778 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4413, nodes: 2305701 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 707280, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 517 
        40 - 59% = 712 
        60 - 79% = 749 
        80 - 99% = 2332 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.28, total records: 400 
    Average version length: 22.91, total versions: 253138, max versions: 662 
    Average fragment length: 2.11, total fragments: 56, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1416 
    Data pages: 1416, average fill: 89% 
    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% = 0 
    60 - 79% = 0 
    80 - 99% = 1410 
 
    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: 1.05, total records: 135269 
    Average version length: 68.30, total versions: 133185, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 83.64 
    Pointer pages: 7, data page slots: 2928 
    Data pages: 2359, average fill: 72% 
    Primary pages: 2357, secondary pages: 2, swept pages: 0 
    Empty pages: 184, full pages: 1626 
    Fill distribution: 
     0 - 19% = 311 
    20 - 39% = 148 
    40 - 59% = 166 
    60 - 79% = 166 
    80 - 99% = 1568 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704387, depth: 3, leaf buckets: 479, nodes: 135269 
    Average node length: 13.17, total dup: 12304, max dup: 2 
    Average key length: 10.50, compression ratio: 2.57 
    Average prefix length: 19.40, average data length: 7.60 
    Clustering factor: 97048, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 136 
        40 - 59% = 295 
        60 - 79% = 45 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18660, max versions: 1029 
    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: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.14, total records: 1949 
    Average version length: 43.86, total versions: 1897, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 50.90 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 49% 
    Primary pages: 38, secondary pages: 1, swept pages: 0 
    Empty pages: 11, full pages: 15 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89360, depth: 2, leaf buckets: 3, nodes: 1949 
    Average node length: 4.26, total dup: 1851, max dup: 252 
    Average key length: 2.54, compression ratio: 7.47 
    Average prefix length: 18.51, average data length: 0.49 
    Clustering factor: 989, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.00, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.70, total records: 789941 
    Average version length: 25.64, total versions: 80871, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8392 
    Data pages: 8384, average fill: 66% 
    Primary pages: 8334, secondary pages: 50, swept pages: 1460 
    Empty pages: 206, full pages: 6231 
    Fill distribution: 
     0 - 19% = 405 
    20 - 39% = 304 
    40 - 59% = 321 
    60 - 79% = 7067 
    80 - 99% = 287 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 892, nodes: 789941 
    Average node length: 4.87, total dup: 789892, max dup: 147872 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87988, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 153 
        40 - 59% = 501 
        60 - 79% = 188 
        80 - 99% = 47 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 934, nodes: 789941 
    Average node length: 5.87, total dup: 703506, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156396, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 142 
        40 - 59% = 369 
        60 - 79% = 121 
        80 - 99% = 301 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 997, nodes: 789941 
    Average node length: 5.88, total dup: 703506, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158365, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 231 
        40 - 59% = 379 
        60 - 79% = 122 
        80 - 99% = 265 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1132, nodes: 789941 
    Average node length: 5.96, total dup: 703506, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151307, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 244 
        40 - 59% = 622 
        60 - 79% = 186 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5466 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.56, total fragments: 87, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 72, secondary pages: 24, swept pages: 50 
    Empty pages: 13, full pages: 63 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5466 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.44, average data length: 1.55 
    Clustering factor: 5185, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5466 
    Average node length: 11.10, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 151, 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.14, total records: 84746 
    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: 824 
    Data pages: 824, average fill: 71% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 816 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 816 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31674, depth: 2, leaf buckets: 109, nodes: 84746 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3166, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 106 
 
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.69, 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.28 
    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.03, total records: 161803 
    Average version length: 145.95, total versions: 1591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 5208 
    Data pages: 3872, average fill: 86% 
    Primary pages: 3871, secondary pages: 1, swept pages: 1 
    Empty pages: 43, full pages: 3812 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3813 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.67, total records: 163653 
    Average version length: 151.79, total versions: 5348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 4760 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 2 
    Empty pages: 37, full pages: 3860 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 3861 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.56, total records: 173062 
    Average version length: 151.03, total versions: 2716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 6040 
    Data pages: 4184, average fill: 85% 
    Primary pages: 4184, secondary pages: 0, swept pages: 2 
    Empty pages: 77, full pages: 4090 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4090 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.92, total records: 178480 
    Average version length: 149.46, total versions: 2504, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 5952 
    Data pages: 4296, average fill: 86% 
    Primary pages: 4295, secondary pages: 1, swept pages: 1 
    Empty pages: 60, full pages: 4218 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4218 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.82, total records: 156866 
    Average version length: 151.09, total versions: 2467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 8, data page slots: 4912 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 1 
    Empty pages: 50, full pages: 3713 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3713 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 125.67, total records: 197780 
    Average version length: 155.09, total versions: 33003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.50 
    Pointer pages: 7, data page slots: 6520 
    Data pages: 4728, average fill: 88% 
    Primary pages: 4728, secondary pages: 0, swept pages: 1 
    Empty pages: 13, full pages: 4692 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 3 
    80 - 99% = 4693 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.65, total records: 169575 
    Average version length: 150.71, total versions: 2477, 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: 5696 
    Data pages: 4080, average fill: 86% 
    Primary pages: 4080, secondary pages: 0, swept pages: 2 
    Empty pages: 53, full pages: 4004 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4004 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 149.10, total records: 175332 
    Average version length: 149.77, total versions: 2125, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 6216 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4184, secondary pages: 0, swept pages: 1 
    Empty pages: 25, full pages: 4145 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 4145 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.63, total records: 174372 
    Average version length: 146.57, total versions: 1567, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4496 
    Data pages: 4168, average fill: 86% 
    Primary pages: 4168, secondary pages: 0, swept pages: 2 
    Empty pages: 31, full pages: 4126 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4126 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.08, total records: 175325 
    Average version length: 150.44, total versions: 2134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4776 
    Data pages: 4192, average fill: 86% 
    Primary pages: 4192, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 4148 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4148 
 
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.49, total records: 2146631 
    Average version length: 52.92, total versions: 51339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25560, average fill: 72% 
    Primary pages: 25560, secondary pages: 0, swept pages: 9106 
    Empty pages: 227, full pages: 22406 
    Fill distribution: 
     0 - 19% = 384 
    20 - 39% = 285 
    40 - 59% = 739 
    60 - 79% = 23662 
    80 - 99% = 490 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2631, nodes: 2146631 
    Average node length: 5.44, total dup: 2003817, max dup: 1536 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185562, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 267 
        40 - 59% = 1765 
        60 - 79% = 298 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2767, nodes: 2146631 
    Average node length: 5.69, total dup: 1927431, max dup: 61 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383514, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2301 
        60 - 79% = 427 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2207, nodes: 2146631 
    Average node length: 4.96, total dup: 2146531, max dup: 28237 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 183155, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 147 
        40 - 59% = 1278 
        60 - 79% = 410 
        80 - 99% = 371 
 
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: 35.29, total records: 159194 
    Average version length: 69.19, total versions: 78043, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.57 
    Pointer pages: 3, data page slots: 4064 
    Data pages: 2896, average fill: 64% 
    Primary pages: 2896, secondary pages: 0, swept pages: 342 
    Empty pages: 479, full pages: 2044 
    Fill distribution: 
     0 - 19% = 581 
    20 - 39% = 21 
    40 - 59% = 72 
    60 - 79% = 813 
    80 - 99% = 1409 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103106, depth: 3, leaf buckets: 224, nodes: 159194 
    Average node length: 6.46, total dup: 138596, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 26787, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 13 
        40 - 59% = 114 
        60 - 79% = 71 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.62, total records: 6958310 
    Average version length: 68.82, total versions: 438326, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 63, data page slots: 101584 
    Data pages: 101584, average fill: 73% 
    Primary pages: 101584, secondary pages: 0, swept pages: 19850 
    Empty pages: 300, full pages: 88933 
    Fill distribution: 
     0 - 19% = 1975 
    20 - 39% = 4330 
    40 - 59% = 3580 
    60 - 79% = 81753 
    80 - 99% = 9946 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10559, nodes: 6958310 
    Average node length: 6.51, total dup: 6019893, max dup: 38 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1599216, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1827 
        40 - 59% = 5593 
        60 - 79% = 2576 
        80 - 99% = 556 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8467, nodes: 6958310 
    Average node length: 5.40, total dup: 6680058, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1391502, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1201 
        40 - 59% = 4709 
        60 - 79% = 1591 
        80 - 99% = 953 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8494, nodes: 6958310 
    Average node length: 5.40, total dup: 6680058, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1393874, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1223 
        40 - 59% = 4709 
        60 - 79% = 1642 
        80 - 99% = 915 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 12023302 
    Average version length: 68.75, total versions: 391453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 102, data page slots: 165128 
    Data pages: 165128, average fill: 77% 
    Primary pages: 165128, secondary pages: 0, swept pages: 65434 
    Empty pages: 0, full pages: 162683 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 72 
    40 - 59% = 648 
    60 - 79% = 155339 
    80 - 99% = 9064 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18409, nodes: 12023302 
    Average node length: 6.57, total dup: 10479616, max dup: 72 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2383221, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 2476 
        40 - 59% = 10777 
        60 - 79% = 4361 
        80 - 99% = 774 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.23, total records: 1725505 
    Average version length: 69.14, total versions: 821235, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.48 
    Pointer pages: 29, data page slots: 45248 
    Data pages: 26240, average fill: 76% 
    Primary pages: 26240, secondary pages: 0, swept pages: 2800 
    Empty pages: 1249, full pages: 22548 
    Fill distribution: 
     0 - 19% = 1934 
    20 - 39% = 632 
    40 - 59% = 630 
    60 - 79% = 9235 
    80 - 99% = 13809 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2020, nodes: 1725505 
    Average node length: 5.50, total dup: 1656096, max dup: 99 
    Average key length: 2.55, compression ratio: 16.48 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 118742, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 160 
        40 - 59% = 965 
        60 - 79% = 664 
        80 - 99% = 221 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.68, total records: 1369501 
    Average version length: 69.14, total versions: 681411, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.63 
    Pointer pages: 24, data page slots: 37872 
    Data pages: 29320, average fill: 54% 
    Primary pages: 29320, secondary pages: 0, swept pages: 6561 
    Empty pages: 7026, full pages: 17363 
    Fill distribution: 
     0 - 19% = 9577 
    20 - 39% = 794 
    40 - 59% = 528 
    60 - 79% = 5096 
    80 - 99% = 13325 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1675, nodes: 1369501 
    Average node length: 5.73, total dup: 1285164, max dup: 99 
    Average key length: 2.79, compression ratio: 15.07 
    Average prefix length: 41.27, average data length: 0.73 
    Clustering factor: 184947, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 155 
        40 - 59% = 756 
        60 - 79% = 572 
        80 - 99% = 184 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.71, total records: 9553011 
    Average version length: 68.96, total versions: 579544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 144280 
    Data pages: 144264, average fill: 71% 
    Primary pages: 144264, secondary pages: 0, swept pages: 45957 
    Empty pages: 265, full pages: 92232 
    Fill distribution: 
     0 - 19% = 963 
    20 - 39% = 4565 
    40 - 59% = 17803 
    60 - 79% = 110173 
    80 - 99% = 10760 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13519, nodes: 9553011 
    Average node length: 6.68, total dup: 7927962, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2077051, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1099 
        40 - 59% = 6242 
        60 - 79% = 5146 
        80 - 99% = 1026 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21211423 
    Average version length: 82.80, total versions: 14111, 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: 319520 
    Data pages: 319520, average fill: 81% 
    Primary pages: 319520, secondary pages: 0, swept pages: 12133 
    Empty pages: 2, full pages: 319517 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 27077 
    80 - 99% = 292440 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19331, nodes: 21211423 
    Average node length: 5.72, total dup: 20728955, max dup: 170 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287708, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 7933 
        60 - 79% = 559 
        80 - 99% = 10834 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17249, nodes: 21211423 
    Average node length: 6.31, total dup: 18638762, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915940, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 833 
        60 - 79% = 280 
        80 - 99% = 16133 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21142, nodes: 21211423 
    Average node length: 6.35, total dup: 18559149, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584587, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 8223 
        60 - 79% = 654 
        80 - 99% = 12255 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16282, nodes: 21211423 
    Average node length: 5.56, total dup: 21211323, max dup: 231396 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945085, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 3120 
        60 - 79% = 460 
        80 - 99% = 12694 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.61, total records: 10019921 
    Average version length: 82.63, total versions: 584693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 172600 
    Data pages: 172568, average fill: 72% 
    Primary pages: 172568, secondary pages: 0, swept pages: 62738 
    Empty pages: 324, full pages: 109487 
    Fill distribution: 
     0 - 19% = 1260 
    20 - 39% = 6291 
    40 - 59% = 23593 
    60 - 79% = 70133 
    80 - 99% = 71291 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11403, nodes: 10019921 
    Average node length: 5.37, total dup: 9707997, max dup: 200 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2236821, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 25 
        40 - 59% = 7314 
        60 - 79% = 3853 
        80 - 99% = 206 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13938, nodes: 10019921 
    Average node length: 6.24, total dup: 8310084, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1556696, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 3845 
        40 - 59% = 4813 
        60 - 79% = 2529 
        80 - 99% = 2608 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12735, nodes: 10019921 
    Average node length: 5.99, total dup: 8703051, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2429920, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 35 
        40 - 59% = 8266 
        60 - 79% = 4207 
        80 - 99% = 223 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10470, nodes: 10019921 
    Average node length: 5.15, total dup: 10019821, max dup: 158650 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1607892, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1143 
        40 - 59% = 5419 
        60 - 79% = 1690 
        80 - 99% = 2165 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.21, total records: 11579401 
    Average version length: 82.52, total versions: 435314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 192288 
    Data pages: 191184, average fill: 74% 
    Primary pages: 191184, secondary pages: 0, swept pages: 61154 
    Empty pages: 2690, full pages: 151872 
    Fill distribution: 
     0 - 19% = 4425 
    20 - 39% = 6026 
    40 - 59% = 14685 
    60 - 79% = 39706 
    80 - 99% = 126342 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13152, nodes: 11579401 
    Average node length: 5.30, total dup: 11469230, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2418528, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 90 
        40 - 59% = 8634 
        60 - 79% = 4168 
        80 - 99% = 255 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10631, nodes: 11579401 
    Average node length: 5.49, total dup: 11075276, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 735711, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 179 
        20 - 39% = 819 
        40 - 59% = 2608 
        60 - 79% = 1844 
        80 - 99% = 5181 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15031, nodes: 11579401 
    Average node length: 6.02, total dup: 10112244, max dup: 62 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2435162, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 129 
        40 - 59% = 10013 
        60 - 79% = 4584 
        80 - 99% = 303 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11006, nodes: 11579401 
    Average node length: 5.22, total dup: 11579301, max dup: 202463 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 724041, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 784 
        40 - 59% = 5018 
        60 - 79% = 1488 
        80 - 99% = 3615 
 
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: 78.09, total records: 10121054 
    Average version length: 82.92, total versions: 569327, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 175584 
    Data pages: 175560, average fill: 71% 
    Primary pages: 175560, secondary pages: 0, swept pages: 66107 
    Empty pages: 397, full pages: 108874 
    Fill distribution: 
     0 - 19% = 1389 
    20 - 39% = 6703 
    40 - 59% = 24255 
    60 - 79% = 73510 
    80 - 99% = 69703 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12127, nodes: 10121054 
    Average node length: 5.19, total dup: 10091643, max dup: 1578 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2040797, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1386 
        40 - 59% = 8068 
        60 - 79% = 1981 
        80 - 99% = 654 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14055, nodes: 10121054 
    Average node length: 6.25, total dup: 8393736, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1521921, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 226 
        20 - 39% = 3882 
        40 - 59% = 4660 
        60 - 79% = 2515 
        80 - 99% = 2772 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12772, nodes: 10121054 
    Average node length: 5.44, total dup: 9671084, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2176580, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1306 
        40 - 59% = 9041 
        60 - 79% = 1796 
        80 - 99% = 596 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10617, nodes: 10121054 
    Average node length: 5.16, total dup: 10120954, max dup: 161332 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1628001, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1177 
        40 - 59% = 5542 
        60 - 79% = 1681 
        80 - 99% = 2169 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.36, total records: 585264 
    Average version length: 68.72, total versions: 7004, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 76% 
    Primary pages: 8032, secondary pages: 0, swept pages: 3380 
    Empty pages: 4, full pages: 7368 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 22 
    40 - 59% = 118 
    60 - 79% = 7759 
    80 - 99% = 128 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33679, depth: 3, leaf buckets: 745, nodes: 585264 
    Average node length: 5.95, total dup: 498321, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101935, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 526 
        60 - 79% = 105 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27051, depth: 3, leaf buckets: 769, nodes: 585264 
    Average node length: 6.15, total dup: 480065, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101996, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 538 
        60 - 79% = 108 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 570, nodes: 585264 
    Average node length: 4.86, total dup: 585164, max dup: 9297 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90490, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 19 
        40 - 59% = 332 
        60 - 79% = 88 
        80 - 99% = 130 
 
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 Sat Mar  2 01:11:40 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7853621 121937 1 0.0000 0.0000
DOC_LIST 2305701 131619 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 253138 662 63200.0000 0.0000
INVNT_TURNOVER_LOG 135269 133185 1 0.0000 0.0000
MONEY_SALDO 49 18660 1029 38000.0000 0.0000
MONEY_TURNOVER_LOG 1949 1897 1 0.0000 0.0000
PDISTR 789941 80871 5 0.0000 0.0000
PERF_SPLIT_0 161803 1591 1 0.0000 0.0000
PERF_SPLIT_1 163653 5348 1 0.0000 0.0000
PERF_SPLIT_2 173062 2716 1 0.0000 0.0000
PERF_SPLIT_3 178480 2504 1 0.0000 0.0000
PERF_SPLIT_4 156866 2467 1 0.0000 0.0000
PERF_SPLIT_5 197780 33003 1 0.0000 0.0000
PERF_SPLIT_6 169575 2477 1 0.0000 0.0000
PERF_SPLIT_7 175332 2125 1 0.0000 0.0000
PERF_SPLIT_8 174372 1567 1 0.0000 0.0000
PERF_SPLIT_9 175325 2134 1 0.0000 0.0000
PSTORNED 2146631 51339 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 159194 78043 1 0.0000 0.0000
XQD_1000_3300 6958310 438326 1 0.0000 0.0000
XQD_1200_2000 12023302 391453 1 0.0000 0.0000
XQD_2000_3300 1725505 821235 1 0.0000 0.0000
XQD_2100_3300 1369501 681411 1 0.0000 0.0000
XQD_3300_3400 9553011 579544 1 0.0000 0.0000
XQS_1000_1200 21211423 14111 1 0.0000 0.0000
XQS_1000_3300 10019921 584693 1 0.0000 0.0000
XQS_1200_2000 11579401 435314 1 0.0000 0.0000
XQS_2100_3300 10121054 569327 1 0.0000 0.0000
XQS_3300_3400 585264 7004 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 ---
--- end of diff output ---

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

02.03.24 01:11:52. 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-02 01:11:55 No severe PSQL-related problems occured
02.03.24 01:11:56. End of report.