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

Server and database settinfs 


SERVER_MODE                     SuperServer 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-27 13:07:51
DTS_END                         2024-02-27 13:07:51.2930
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/47868
TRN_ID                          170678
ATT_ID                          570
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: 9597.90 18487 959790
customer order: creation 177.32 399 17732
customer order: refuse 14.73 386 1473
order to supplier: creation 45.84 1265 4584
order to supplier: removal 3.70 96465 370
invoice (draft): creation 47.22 3087 4722
invoice (draft): removal 54.01 663 5401
invoice accept: apply 43.00 21481 4300
invoice accept: cancel 48.62 785 4862
customer reserve: creation 4105.97 208 410597
customer reserve: removal 4760.48 59 476048
realization accept: apply 85.84 198 8584
realization accept: cancel 80.89 137 8089
payment from customer: creation 59.98 130 5998
payment from customer: removal 5.79 97 579
payment to supplier: creation 50.04 132 5004
payment to supplier: removal 3.46 73 346
service: total inventory turnovers 3.99 3570 399
service: total monetary turnovers 6.10 559 610
service: aggregate perf. data 0.89 13500 89
service: refresh index statistics 0.03 226546 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2024 13:08:38 to 27-02-2024 13:08:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5246
TEST_TIME 2 4416
TEST_TIME 3 4736
TEST_TIME 4 4835
TEST_TIME 5 5247
TEST_TIME 6 6192
TEST_TIME 7 6296
TEST_TIME 8 6079
TEST_TIME 9 5818
TEST_TIME 10 5910
TEST_TIME 11 5731
TEST_TIME 12 5974
TEST_TIME 13 6037
TEST_TIME 14 6188
TEST_TIME 15 6268
TEST_TIME 16 6475
TEST_TIME 17 6567
TEST_TIME 18 6655
TEST_TIME 19 6743
TEST_TIME 20 6735
TEST_TIME 21 7311
TEST_TIME 22 7580
TEST_TIME 23 8051
TEST_TIME 24 8067
TEST_TIME 25 8627
TEST_TIME 26 9187
TEST_TIME 27 9581
TEST_TIME 28 10126
TEST_TIME 29 10055
TEST_TIME 30 10146
TEST_TIME 31 10043
TEST_TIME 32 9872
TEST_TIME 33 9697
TEST_TIME 34 9578
TEST_TIME 35 9472
TEST_TIME 36 9302
TEST_TIME 37 9414
TEST_TIME 38 9393
TEST_TIME 39 9453
TEST_TIME 40 9464
TEST_TIME 41 9350
TEST_TIME 42 9231
TEST_TIME 43 9187
TEST_TIME 44 9274
TEST_TIME 45 9293
TEST_TIME 46 9468
TEST_TIME 47 9480
TEST_TIME 48 9420
TEST_TIME 49 9395
TEST_TIME 50 9646
TEST_TIME 51 9615
TEST_TIME 52 9679
TEST_TIME 53 9622
TEST_TIME 54 9701
TEST_TIME 55 9711
TEST_TIME 56 9654
TEST_TIME 57 9687
TEST_TIME 58 9631
TEST_TIME 59 9493
TEST_TIME 60 9478
TEST_TIME 61 9448
TEST_TIME 62 9450
TEST_TIME 63 9365
TEST_TIME 64 9336
TEST_TIME 65 9283
TEST_TIME 66 9394
TEST_TIME 67 9382
TEST_TIME 68 9334
TEST_TIME 69 9417
TEST_TIME 70 9436
TEST_TIME 71 9404
TEST_TIME 72 9437
TEST_TIME 73 9455
TEST_TIME 74 9467
TEST_TIME 75 9638
TEST_TIME 76 9650
TEST_TIME 77 9620
TEST_TIME 78 9655
TEST_TIME 79 9613
TEST_TIME 80 9508
TEST_TIME 81 9534
TEST_TIME 82 9439
TEST_TIME 83 9416
TEST_TIME 84 9398
TEST_TIME 85 9373
TEST_TIME 86 9347
TEST_TIME 87 9409
TEST_TIME 88 9363
TEST_TIME 89 9407
TEST_TIME 90 9378
TEST_TIME 91 9400
TEST_TIME 92 9406
TEST_TIME 93 9415
TEST_TIME 94 9424
TEST_TIME 95 9452
TEST_TIME 96 9502
TEST_TIME 97 9484
TEST_TIME 98 9599
TEST_TIME 99 9570
TEST_TIME 100 9609

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-02-2024 13:08:42 to 27-02-2024 13:08:45.

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 1336186 1336186 0 0.00 0 21291 7 0 0
doc_list_biud 1336186 1336186 0 0.00 0 55014 26 0 0
sp_add_invoice_to_stock 4402 4300 102 2.31 24 224712 21482 0 102
sp_cancel_adding_invoice 4862 4862 0 0.00 5 81957 786 0 0
sp_cancel_client_order 1473 1473 0 0.00 4 13360 386 0 0
sp_cancel_customer_reserve 476048 476048 0 0.00 0 55018 60 0 0
sp_cancel_pay_from_customer 579 579 0 0.00 2 11161 98 0 0
sp_cancel_pay_to_supplier 346 346 0 0.00 2 4545 74 0 0
sp_cancel_supplier_invoice 5406 5401 5 0.09 2 22228 664 0 5
sp_cancel_supplier_order 370 370 0 0.00 6 1089369 96465 0 0
sp_cancel_write_off 8089 8089 0 0.00 1 10904 138 0 0
sp_client_order 17732 17732 0 0.00 3 31041 400 0 0
sp_customer_reserve 410597 410597 0 0.00 0 54310 208 0 0
sp_fill_shopping_cart 27027 27027 0 0.00 1 14886 36 0 0
sp_fill_shopping_cart_clo_res 410587 410587 0 0.00 0 15681 16 0 0
sp_get_clo_for_invoice 4287 4287 0 0.00 0 15149 288 0 0
sp_kill_cost_storno 13876 13876 0 0.00 0 9679 69 0 0
sp_kill_qstorno_ret_qs2qd 965956 965956 0 0.00 0 54999 32 0 0
sp_kill_qty_storno 509113 509113 0 0.00 0 55013 69 0 0
sp_lock_selected_doc 17677 17677 0 0.00 0 8782 7 0 0
sp_make_cost_storno 23872 23872 0 0.00 0 12143 58 0 0
sp_multiply_rows_for_pdistr 23872 23872 0 0.00 0 12308 31 0 0
sp_multiply_rows_for_qdistr 17732 17732 0 0.00 0 29402 206 0 0
sp_pay_from_customer 5998 5998 0 0.00 4 11822 131 0 0
sp_pay_to_supplier 5004 5004 0 0.00 4 12326 132 0 0
sp_payment_common 11002 11002 0 0.00 1 6557 27 0 0
sp_qd_handle_on_cancel_clo 1473 1473 0 0.00 0 13355 356 0 0
sp_qd_handle_on_invoice_upd_sts 9148 9148 0 0.00 0 46526 321 0 0
sp_qd_handle_on_reserve_upd_sts 8584 8584 0 0.00 0 29300 65 0 0
sp_reserve_write_off 8584 8584 0 0.00 6 29336 198 0 0
sp_supplier_invoice 4722 4722 0 0.00 5 78480 3087 0 0
sp_supplier_order 4584 4584 0 0.00 4 34806 1266 0 0
srv_aggregate_perf_data 89 89 0 0.00 1369 144770 13501 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1533 117591 43801 0 0
srv_find_qd_qs_mism 916695 916695 0 0.00 0 21291 7 0 0
srv_make_invnt_saldo 399 399 0 0.00 27 85023 3570 0 0
srv_make_money_saldo 610 610 0 0.00 1 16354 559 0 0
srv_recalc_idx_stat 3 3 0 0.00 139873 376564 226547 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4300 4300 0 0.00 0 7542 162 0 0
t$perf-norm:sp_cancel_adding_invoice 349 349 0 0.00 0 4374 114 0 0
t$perf-norm:sp_cancel_client_order 1473 1473 0 0.00 0 3402 10 0 0
t$perf-norm:sp_cancel_customer_reserve 547 547 0 0.00 0 3057 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 579 579 0 0.00 0 1042 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 346 346 0 0.00 0 3672 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 335 335 0 0.00 0 1515 18 0 0
t$perf-norm:sp_cancel_supplier_order 370 370 0 0.00 0 35027 1838 0 0
t$perf-norm:sp_cancel_write_off 808 808 0 0.00 0 937 6 0 0
t$perf-norm:sp_client_order 17732 17732 0 0.00 0 4580 14 0 0
t$perf-norm:sp_customer_reserve 814 814 0 0.00 0 733 4 0 0
t$perf-norm:sp_pay_from_customer 5998 5998 0 0.00 0 3955 10 0 0
t$perf-norm:sp_pay_to_supplier 5004 5004 0 0.00 0 2445 8 0 0
t$perf-norm:sp_reserve_write_off 8584 8584 0 0.00 0 6635 9 0 0
t$perf-norm:sp_supplier_invoice 4722 4722 0 0.00 0 2813 15 0 0
t$perf-norm:sp_supplier_order 4584 4584 0 0.00 0 2706 13 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 252 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 245 6 0 0
t$perf-norm:srv_make_invnt_saldo 399 399 0 0.00 0 3304 22 0 0
t$perf-norm:srv_make_money_saldo 610 610 0 0.00 0 1293 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8776 8572 204 2.32 0 7735 24 0 204
v_all_customers 32940 32940 0 0.00 0 17 1 0 0
v_all_suppliers 26426 26426 0 0.00 0 19 1 0 0
v_all_wares 35460 35460 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 698 698 0 0.00 0 1814 12 0 0
v_cancel_client_order 2946 2946 0 0.00 0 2301 4 0 0
v_cancel_customer_prepayment 1158 1158 0 0.00 0 4879 13 0 0
v_cancel_customer_reserve 1094 1094 0 0.00 0 2329 11 0 0
v_cancel_payment_to_supplier 692 692 0 0.00 0 2038 11 0 0
v_cancel_supplier_invoice 680 670 10 1.47 0 9653 37 0 10
v_cancel_supplier_order 740 740 0 0.00 0 371 3 0 0
v_cancel_write_off 1616 1616 0 0.00 0 9865 27 0 0
v_max_id_clo_ord 4580 4580 0 0.00 0 664 1 0 0
v_max_id_clo_res 814 814 0 0.00 0 2371 17 0 0
v_max_id_ord_sup 4717 4717 0 0.00 0 4207 4 0 0
v_max_non_paid_invoice 1088 1088 0 0.00 0 1109 3 0 0
v_max_non_paid_realizn 2868 2868 0 0.00 0 2553 4 0 0
v_min_id_clo_ord 4580 4580 0 0.00 0 5721 7 0 0
v_min_id_clo_res 814 814 0 0.00 0 3053 9 0 0
v_min_id_ord_sup 4717 4717 0 0.00 0 5298 4 0 0
v_min_non_paid_invoice 5004 5004 0 0.00 0 4273 15 0 0
v_min_non_paid_realizn 5998 5998 0 0.00 0 6554 27 0 0
v_our_firm 8780 8780 0 0.00 0 19 1 0 0
v_reserve_write_off 17168 17168 0 0.00 0 7884 10 0 0
x_lock_depdocs_on_canc_invoice 9928 9928 0 0.00 0 13279 114 0 0
x_lock_depdocs_on_canc_sup_ord 370 370 0 0.00 0 10840 313 0 0
x_make_qstorno_1000_1200 4584 4584 0 0.00 1 34782 1198 0 0
x_make_qstorno_1200_2000 4722 4722 0 0.00 2 78473 2945 0 0
x_make_qstorno_2100_3300 410597 410597 0 0.00 0 45911 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 13:08:46 to 27-02-2024 13:08:50.

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
11:07:54 3 8192000000 8800058752 8811765760 5669744 0.069 2 2 3 0 5835008 103904 61360
11:08:55 11321 8192000000 9707029984 9998811136 792689376 8.822 100 91 182 0 822365488 7338256 22337856
11:10:22 41896 8192000000 9759810992 10064879616 831326272 9.213 100 96 192 0 866078400 12114048 22638080
11:12:07 15887 8192000000 9794265312 10108510208 862045328 9.521 100 86 172 0 901348576 19747680 19555568
11:13:34 8116 8192000000 9857572000 10189893632 903889312 9.937 100 73 146 0 963985872 44779232 15317328
11:14:46 11270 8192000000 9911225024 10252263424 948043616 10.372 100 84 164 0 1015251024 49857328 17350080
11:16:01 4162 8192000000 9931367872 10283499520 978419072 10.669 100 73 143 1 1046095200 53200928 14475200
11:17:08 3918 8192000000 9972616064 10335436800 1006747376 10.944 100 76 153 0 1088948128 66691712 15509040
11:18:14 2080 8192000000 9998762256 10366738432 1034284272 11.210 100 80 158 1 1115064432 64718896 16061264
11:19:18 1989 8192000000 10021640608 10397495296 1048371264 11.345 100 80 156 0 1137571216 73145104 16054848
11:20:22 34245 8192000000 10009775984 10390917120 1059127312 11.448 100 62 122 0 1119351600 47029904 13194384
11:21:59 5130 8192000000 10011297088 10409639936 1064110128 11.496 100 38 77 0 1116756112 45167360 7478624
11:23:06 6395 8192000000 9993455408 10387107840 1074569760 11.596 100 43 86 1 1102062608 19139616 8353232
11:24:16 13932 8192000000 9987999440 10394607616 1078384080 11.632 100 37 69 1 1102817920 17082048 7351792
11:25:44 4206 8192000000 9992432336 10391244800 1087559104 11.719 100 39 74 1 1106457616 10337216 8561296
11:26:53 4869 8192000000 10032118336 10430656512 1090507024 11.747 100 44 88 0 1143397440 43520320 9370096
11:27:59 6869 8192000000 10025710000 10423406592 1103364992 11.870 100 45 89 1 1130862608 19236624 8260992
11:29:08 82821 8192000000 10042920656 10450489344 1089466736 11.738 98 40 77 1 1148310704 51089568 7754400
11:31:34 35274 8192000000 10051417520 10462113792 1077548672 11.624 97 39 77 0 1136289728 50713216 8027840
11:33:19 21393 8192000000 10064524480 10482114560 1087785392 11.722 97 38 76 0 1170991680 75121696 8084592
11:34:45 27033 8192000000 10072118976 10473496576 1077221632 11.621 97 45 90 0 1151805936 65102320 9481984
11:36:22 20062 8192000000 10084340768 10484252672 1085262800 11.698 98 41 75 3 1167886976 74783216 7840960
11:37:59 9328 8192000000 10107200080 10500816896 1079155920 11.639 98 43 87 0 1196642640 108431168 9055552
11:39:22 12347 8192000000 10123942816 10535231488 1075975520 11.609 98 41 80 1 1229429728 144224512 9229696
11:40:39 7933 8192000000 10164700576 10560458752 1092428352 11.766 100 41 82 0 1276008112 174199728 9380032
11:41:53 10821 8192000000 10215904288 10612293632 1092548736 11.767 99 60 120 0 1314677056 208528416 13599904
11:43:24 3639 8192000000 10288201136 10686779392 1111982720 11.951 100 68 136 0 1390876048 263640608 15252720
11:44:43 1753 8192000000 10334924352 10727903232 1135290368 12.171 100 75 150 0 1437252208 285399520 16562320
11:45:50 3602 8192000000 10364082224 10762129408 1123178016 12.057 99 71 140 1 1457816720 318154464 16484240
11:47:02 1533 8192000000 10407672176 10808860672 1150564288 12.315 100 73 145 0 1509661024 341817248 17279488
11:48:13 4119 8192000000 10461162272 10865922048 1148956208 12.300 100 68 135 0 1555353936 390375376 16022352
11:49:20 6123 8192000000 10431278368 10864046080 1161914848 12.421 100 46 92 0 1524995328 352223392 10857088
11:50:30 13542 8192000000 10376864416 10821730304 1155973936 12.366 100 27 54 0 1492838288 330217344 6647008
11:51:54 12783 8192000000 10350140752 10847694848 1143156144 12.245 100 31 60 1 1472301392 321069008 8076240
11:53:14 23762 8192000000 10264322224 10761097216 1132420416 12.144 100 16 32 0 1385378384 248588016 4369952
11:54:43 51727 8192000000 10111873120 10634260480 1095232784 11.792 97 19 38 0 1195351664 95398064 4720816
11:56:36 79121 8192000000 10066060512 10580496384 1128737056 12.109 100 12 22 0 1167348256 36769552 1841648
11:58:56 23724 8192000000 10075072704 10506133504 1138590752 12.202 100 50 100 0 1176602064 26703056 11308256
12:00:28 117591 8192000000 10120166464 10557444096 1145450240 12.267 100 39 78 1 1217814064 64130816 8233008
12:03:28 51344 8192000000 10090568832 10535911424 1148793680 12.298 100 21 40 0 1190672400 37115600 4763120
12:05:21 38945 8192000000 10135889088 10568105984 1141185056 12.227 99 37 74 0 1220016160 70864400 7966704
12:07:06 60450 8192000000 10102813792 10582904832 1134852448 12.167 98 20 36 1 1199286864 60429840 4004576
12:09:16 44379 8192000000 10179702752 10627010560 1150865984 12.318 99 10 20 0 1256949072 104237264 1845824
12:11:02 47192 8192000000 10109602544 10589278208 1140322160 12.219 99 33 66 3 1213385680 65492128 7571392
12:13:03 45599 8192000000 10088738736 10551918592 1144381040 12.257 100 19 38 0 1185250992 36425328 4444624
12:14:51 38737 8192000000 10128932880 10582061056 1143021200 12.244 98 41 82 0 1212365584 60396544 8947840
12:16:41 49495 8192000000 10107205200 10599161856 1141976496 12.234 99 14 28 0 1254989200 109824464 3188240
12:18:33 33510 8192000000 10085072432 10534297600 1097449632 11.813 95 21 39 0 1137464480 35827488 4187360
12:20:09 35893 8192000000 10073177984 10498326528 1102419520 11.861 98 30 58 0 1148426304 40133200 5873584
12:21:51 45449 8192000000 10092093696 10530902016 1118732400 12.015 99 25 50 0 1185098336 61118160 5247776
12:23:45 17052 8192000000 10098337296 10529624064 1088623152 11.730 98 38 76 0 1181501344 85171984 7706208
12:25:46 104287 8192000000 10048288720 10485972992 1076750320 11.616 98 28 56 0 1143524448 60704144 6069984
12:28:30 34029 8192000000 10067559648 10525138944 1092592768 11.767 99 17 33 0 1163541888 67563632 3385488
12:30:29 66440 8192000000 10066353440 10541150208 1079993344 11.647 97 15 29 1 1136142416 53077600 3071472
12:32:35 81301 8192000000 10052463584 10542034944 1075537008 11.605 97 12 24 1 1129751936 51500528 2714400
12:34:57 88058 8192000000 10115044656 10568732672 1084896912 11.694 97 18 36 0 1138069376 49315824 3856640
12:37:25 52949 8192000000 10062591376 10475986944 1097723072 11.816 97 35 69 0 1123216960 18805904 6687984
12:39:23 60430 8192000000 10074552736 10499960832 1086154656 11.706 97 23 46 0 1135151392 44564096 4432640
12:41:36 53188 8192000000 10143583856 10671398912 1137289104 12.190 100 36 72 2 1266637520 122080656 7267760
12:43:31 78310 8192000000 10099675168 10533838848 1127355888 12.096 99 21 42 0 1161432128 30158896 3917344
12:45:53 63340 8192000000 10139570224 10612371456 1135062736 12.169 99 25 50 1 1223897648 83712912 5122000
12:49:15 47970 8192000000 10105339344 10557480960 1141716464 12.232 99 27 52 2 1204733408 58360176 4656768
12:51:04 92191 8192000000 10123245104 10620227584 1112618512 11.957 97 20 40 0 1221718768 104692880 4407376
12:53:52 61951 8192000000 10114737152 10621886464 1131811248 12.138 99 19 36 2 1249581104 113460256 4309600
12:56:09 41676 8192000000 10064649488 10525384704 1127800192 12.101 99 6 13 0 1184668928 55632512 1236224
12:57:51 50653 8192000000 10079386256 10542260224 1123379904 12.059 98 25 50 0 1176268608 47801536 5087168
12:59:46 30526 8192000000 10067975472 10507915264 1135952688 12.177 99 14 28 0 1166907264 28261952 2692624
13:01:23 54190 8192000000 10102466960 10560978944 1133117568 12.151 98 24 46 0 1189789248 51898448 4773232
13:03:18 106735 8192000000 10099959872 10563825664 1083489456 11.681 94 21 41 0 1131445280 44295136 3660688
13:06:07 112004 8192000000 8983389088 9300955136 27303504 0.332 3 1 2 0 36483328 9144416 35408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-02-2024 13:08:52 to 27-02-2024 13:09:06.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-02-2024 13:09:07 to 27-02-2024 13:09:09.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          170984
MON$OLDEST_ACTIVE               170985
MON$OLDEST_SNAPSHOT             170985
MON$NEXT_TRANSACTION            170985
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1931552
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             687
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Feb 27 13:09:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        89646 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170984 
    Oldest active        170985 
    Oldest snapshot        170985 
    Next transaction    170986 
    Sequence number        0 
    Next attachment ID    687 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 46.91, total records: 7791598 
    Average version length: 48.16, total versions: 195739, 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: 55, data page slots: 88976 
    Data pages: 88976, average fill: 70% 
    Primary pages: 88975, secondary pages: 1, swept pages: 25366 
    Empty pages: 7, full pages: 82316 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 44 
    40 - 59% = 1375 
    60 - 79% = 87438 
    80 - 99% = 108 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23292, nodes: 7791598 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1696690, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 333 
        20 - 39% = 1717 
        40 - 59% = 4234 
        60 - 79% = 2287 
        80 - 99% = 14721 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13529, nodes: 7791598 
    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: 1521359, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1483 
        40 - 59% = 2115 
        60 - 79% = 1102 
        80 - 99% = 8829 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8319, nodes: 7791598 
    Average node length: 6.62, total dup: 5824792, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1514437, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 926 
        40 - 59% = 1380 
        60 - 79% = 911 
        80 - 99% = 4983 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.59, total records: 2194875 
    Average version length: 58.83, total versions: 36852, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28432 
    Data pages: 28432, average fill: 71% 
    Primary pages: 28430, secondary pages: 2, swept pages: 17781 
    Empty pages: 5, full pages: 14539 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 44 
    40 - 59% = 763 
    60 - 79% = 27554 
    80 - 99% = 61 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4530, nodes: 2194875 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 671600, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1001 
        40 - 59% = 807 
        60 - 79% = 809 
        80 - 99% = 1912 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2390, nodes: 2195407 
    Average node length: 4.97, total dup: 2194509, max dup: 20275 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254112, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 220 
        40 - 59% = 1380 
        60 - 79% = 567 
        80 - 99% = 222 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1751, nodes: 2194875 
    Average node length: 4.97, total dup: 2194825, max dup: 130234 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1049418, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 15 
        40 - 59% = 585 
        60 - 79% = 49 
        80 - 99% = 1102 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4314, nodes: 2194875 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 671600, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 627 
        40 - 59% = 638 
        60 - 79% = 910 
        80 - 99% = 2047 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.28, total records: 400 
    Average version length: 27.41, total versions: 2100, max versions: 6 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 1, full pages: 15 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 15 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 26.26, total records: 140034 
    Average version length: 68.30, total versions: 99294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.35 
    Pointer pages: 7, data page slots: 3384 
    Data pages: 2112, average fill: 85% 
    Primary pages: 2111, secondary pages: 1, swept pages: 0 
    Empty pages: 49, full pages: 2000 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 18 
    40 - 59% = 19 
    60 - 79% = 439 
    80 - 99% = 1568 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704200, depth: 3, leaf buckets: 369, nodes: 140034 
    Average node length: 13.06, total dup: 12216, max dup: 2 
    Average key length: 10.52, compression ratio: 2.57 
    Average prefix length: 19.39, average data length: 7.61 
    Clustering factor: 97626, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 195 
        60 - 79% = 131 
        80 - 99% = 40 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 126, max versions: 5 
    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: 2 
    Data pages: 2, average fill: 30% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 23.83, total records: 2267 
    Average version length: 43.77, total versions: 1314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 2.43 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 67% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 24 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 11 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92219, depth: 2, leaf buckets: 8, nodes: 2267 
    Average node length: 4.15, total dup: 2169, max dup: 272 
    Average key length: 2.50, compression ratio: 7.61 
    Average prefix length: 18.54, average data length: 0.46 
    Clustering factor: 1087, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.66, total records: 70 
    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: 49% 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.37, total records: 884289 
    Average version length: 37.90, total versions: 46100, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8936 
    Data pages: 8936, average fill: 67% 
    Primary pages: 8935, secondary pages: 1, swept pages: 944 
    Empty pages: 2, full pages: 8877 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 8806 
    80 - 99% = 126 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 916, nodes: 853071 
    Average node length: 4.89, total dup: 853022, max dup: 166432 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92905, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 125 
        40 - 59% = 510 
        60 - 79% = 182 
        80 - 99% = 96 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1001, nodes: 853071 
    Average node length: 5.89, total dup: 759765, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167984, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 623 
        60 - 79% = 73 
        80 - 99% = 283 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1023, nodes: 853071 
    Average node length: 5.89, total dup: 759765, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 169817, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 65 
        40 - 59% = 606 
        60 - 79% = 66 
        80 - 99% = 285 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1186, nodes: 853071 
    Average node length: 5.98, total dup: 759765, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 161385, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 204 
        40 - 59% = 683 
        60 - 79% = 197 
        80 - 99% = 102 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5442 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.52, total fragments: 21, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 81, secondary pages: 15, swept pages: 45 
    Empty pages: 13, full pages: 53 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5442 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.05 
    Average prefix length: 34.38, average data length: 1.54 
    Clustering factor: 5070, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5442 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 161, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.03, total records: 78319 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 813 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 813 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37285, depth: 2, leaf buckets: 101, nodes: 78319 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2884, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.49, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.38, total records: 168250 
    Average version length: 151.60, total versions: 4560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 8, data page slots: 5064 
    Data pages: 4232, average fill: 82% 
    Primary pages: 4231, secondary pages: 1, swept pages: 1 
    Empty pages: 84, full pages: 4123 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4122 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 142.45, total records: 136064 
    Average version length: 152.74, total versions: 7702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 6, data page slots: 7496 
    Data pages: 3504, average fill: 80% 
    Primary pages: 3502, secondary pages: 2, swept pages: 2 
    Empty pages: 144, full pages: 3301 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 19 
    40 - 59% = 18 
    60 - 79% = 19 
    80 - 99% = 3301 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 142.99, total records: 145289 
    Average version length: 152.10, total versions: 8043, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.86 
    Pointer pages: 7, data page slots: 5384 
    Data pages: 3712, average fill: 81% 
    Primary pages: 3711, secondary pages: 1, swept pages: 1 
    Empty pages: 125, full pages: 3545 
    Fill distribution: 
     0 - 19% = 130 
    20 - 39% = 13 
    40 - 59% = 15 
    60 - 79% = 8 
    80 - 99% = 3546 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 150.21, total records: 161519 
    Average version length: 146.65, total versions: 1176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4768 
    Data pages: 4056, average fill: 82% 
    Primary pages: 4053, secondary pages: 3, swept pages: 8 
    Empty pages: 75, full pages: 3957 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 11 
    80 - 99% = 3955 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 134.48, total records: 168071 
    Average version length: 154.68, total versions: 19502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 8, data page slots: 6152 
    Data pages: 4256, average fill: 83% 
    Primary pages: 4251, secondary pages: 5, swept pages: 3 
    Empty pages: 110, full pages: 4114 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4116 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 148.70, total records: 150768 
    Average version length: 150.93, total versions: 2402, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3824, average fill: 81% 
    Primary pages: 3822, secondary pages: 2, swept pages: 1 
    Empty pages: 82, full pages: 3658 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 9 
    40 - 59% = 67 
    60 - 79% = 5 
    80 - 99% = 3658 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 135.06, total records: 176913 
    Average version length: 154.55, total versions: 19944, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.56 
    Pointer pages: 7, data page slots: 6320 
    Data pages: 4472, average fill: 83% 
    Primary pages: 4470, secondary pages: 2, swept pages: 5 
    Empty pages: 94, full pages: 4327 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 15 
    40 - 59% = 16 
    60 - 79% = 18 
    80 - 99% = 4325 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 141.25, total records: 167288 
    Average version length: 153.85, total versions: 11562, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.01 
    Pointer pages: 6, data page slots: 6320 
    Data pages: 4256, average fill: 82% 
    Primary pages: 4254, secondary pages: 2, swept pages: 4 
    Empty pages: 117, full pages: 4089 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 16 
    40 - 59% = 18 
    60 - 79% = 11 
    80 - 99% = 4089 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 143.10, total records: 169637 
    Average version length: 152.69, total versions: 9691, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 7, data page slots: 5808 
    Data pages: 4208, average fill: 84% 
    Primary pages: 4206, secondary pages: 2, swept pages: 4 
    Empty pages: 30, full pages: 4164 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4165 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 107.84, total records: 216870 
    Average version length: 155.07, total versions: 65873, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.73 
    Pointer pages: 7, data page slots: 7848 
    Data pages: 5464, average fill: 86% 
    Primary pages: 5462, secondary pages: 2, swept pages: 2 
    Empty pages: 94, full pages: 5339 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 16 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 5339 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 50.93, total records: 2110928 
    Average version length: 52.92, total versions: 87392, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25704 
    Data pages: 25696, average fill: 71% 
    Primary pages: 25677, secondary pages: 19, swept pages: 8665 
    Empty pages: 134, full pages: 23574 
    Fill distribution: 
     0 - 19% = 254 
    20 - 39% = 229 
    40 - 59% = 580 
    60 - 79% = 23649 
    80 - 99% = 984 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2557, nodes: 2110928 
    Average node length: 5.44, total dup: 1969657, max dup: 1464 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182495, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 266 
        40 - 59% = 1660 
        60 - 79% = 290 
        80 - 99% = 337 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2110928 
    Average node length: 5.69, total dup: 1895421, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 377274, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2435 
        60 - 79% = 290 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2113, nodes: 2110928 
    Average node length: 4.96, total dup: 2110828, max dup: 28523 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180457, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 180 
        40 - 59% = 1085 
        60 - 79% = 383 
        80 - 99% = 461 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.65, total records: 185974 
    Average version length: 69.18, total versions: 85098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 3, data page slots: 4208 
    Data pages: 3408, average fill: 66% 
    Primary pages: 3408, secondary pages: 0, swept pages: 329 
    Empty pages: 505, full pages: 2713 
    Fill distribution: 
     0 - 19% = 642 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 1210 
    80 - 99% = 1543 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102876, depth: 3, leaf buckets: 262, nodes: 185974 
    Average node length: 6.50, total dup: 161872, max dup: 14 
    Average key length: 3.89, compression ratio: 10.79 
    Average prefix length: 40.24, average data length: 1.76 
    Clustering factor: 32621, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 18 
        40 - 59% = 138 
        60 - 79% = 72 
        80 - 99% = 31 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.52, total records: 7722439 
    Average version length: 68.79, total versions: 700424, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 68, data page slots: 110600 
    Data pages: 110600, average fill: 76% 
    Primary pages: 110599, secondary pages: 1, swept pages: 5945 
    Empty pages: 4, full pages: 109499 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 36 
    60 - 79% = 105080 
    80 - 99% = 5478 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10882, nodes: 7722439 
    Average node length: 6.50, total dup: 6687180, max dup: 29 
    Average key length: 3.51, compression ratio: 11.98 
    Average prefix length: 40.63, average data length: 1.37 
    Clustering factor: 1798591, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 880 
        40 - 59% = 5706 
        60 - 79% = 3531 
        80 - 99% = 760 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 9046, nodes: 7722439 
    Average node length: 5.38, total dup: 7429265, max dup: 186 
    Average key length: 2.39, compression ratio: 7.12 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1582736, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 914 
        40 - 59% = 5275 
        60 - 79% = 1657 
        80 - 99% = 1187 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 9091, nodes: 7722439 
    Average node length: 5.38, total dup: 7429265, max dup: 186 
    Average key length: 2.39, compression ratio: 7.12 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1585129, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 948 
        40 - 59% = 5262 
        60 - 79% = 1682 
        80 - 99% = 1187 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.38, total records: 12626516 
    Average version length: 68.70, total versions: 534040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 111, data page slots: 179528 
    Data pages: 179528, average fill: 75% 
    Primary pages: 179528, secondary pages: 0, swept pages: 43196 
    Empty pages: 3, full pages: 179364 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 28 
    60 - 79% = 174163 
    80 - 99% = 5334 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18515, nodes: 12619267 
    Average node length: 6.64, total dup: 10999482, max dup: 65 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2539920, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1410 
        40 - 59% = 10488 
        60 - 79% = 5530 
        80 - 99% = 1057 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 34.17, total records: 2305206 
    Average version length: 69.06, total versions: 691571, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.69 
    Pointer pages: 28, data page slots: 44536 
    Data pages: 32424, average fill: 67% 
    Primary pages: 32357, secondary pages: 67, swept pages: 568 
    Empty pages: 0, full pages: 32357 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 6601 
    40 - 59% = 2729 
    60 - 79% = 12856 
    80 - 99% = 10177 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1945, nodes: 1655943 
    Average node length: 5.51, total dup: 1589360, max dup: 49 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 115266, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 155 
        40 - 59% = 915 
        60 - 79% = 622 
        80 - 99% = 233 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 28.43, total records: 1957809 
    Average version length: 69.03, total versions: 211236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.43 
    Pointer pages: 23, data page slots: 36352 
    Data pages: 28984, average fill: 46% 
    Primary pages: 28983, secondary pages: 1, swept pages: 4507 
    Empty pages: 5533, full pages: 19361 
    Fill distribution: 
     0 - 19% = 7843 
    20 - 39% = 2236 
    40 - 59% = 5436 
    60 - 79% = 12215 
    80 - 99% = 1254 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1250, nodes: 845228 
    Average node length: 5.96, total dup: 777632, max dup: 97 
    Average key length: 3.02, compression ratio: 13.90 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 127789, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 329 
        40 - 59% = 592 
        60 - 79% = 280 
        80 - 99% = 49 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 62.21, total records: 9490952 
    Average version length: 68.98, total versions: 1047986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.03 
    Pointer pages: 89, data page slots: 144440 
    Data pages: 144416, average fill: 72% 
    Primary pages: 144392, secondary pages: 24, swept pages: 17519 
    Empty pages: 354, full pages: 111110 
    Fill distribution: 
     0 - 19% = 1131 
    20 - 39% = 3829 
    40 - 59% = 12579 
    60 - 79% = 115987 
    80 - 99% = 10890 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13444, nodes: 9479770 
    Average node length: 6.68, total dup: 7866425, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2172173, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 810 
        40 - 59% = 6548 
        60 - 79% = 5305 
        80 - 99% = 780 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.44, total records: 21135920 
    Average version length: 82.89, total versions: 27542, 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: 319344 
    Data pages: 319344, average fill: 81% 
    Primary pages: 319338, secondary pages: 6, swept pages: 10192 
    Empty pages: 3, full pages: 319336 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 47203 
    80 - 99% = 272135 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19450, nodes: 21135920 
    Average node length: 5.72, total dup: 20655155, max dup: 153 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282520, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8322 
        60 - 79% = 557 
        80 - 99% = 10567 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17137, nodes: 21135920 
    Average node length: 6.31, total dup: 18574861, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915644, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 736 
        60 - 79% = 289 
        80 - 99% = 16103 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21237, nodes: 21135920 
    Average node length: 6.35, total dup: 18493720, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575871, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 8595 
        60 - 79% = 626 
        80 - 99% = 12013 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16088, nodes: 21135920 
    Average node length: 5.56, total dup: 21135820, max dup: 234033 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 944392, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2912 
        60 - 79% = 369 
        80 - 99% = 12798 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 74.83, total records: 9910443 
    Average version length: 82.67, total versions: 1022848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 105, data page slots: 171288 
    Data pages: 171256, average fill: 73% 
    Primary pages: 171219, secondary pages: 37, swept pages: 33083 
    Empty pages: 551, full pages: 123831 
    Fill distribution: 
     0 - 19% = 1686 
    20 - 39% = 5584 
    40 - 59% = 17760 
    60 - 79% = 105882 
    80 - 99% = 40344 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11341, nodes: 9910443 
    Average node length: 5.35, total dup: 9603257, max dup: 241 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2246518, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 38 
        40 - 59% = 7585 
        60 - 79% = 3609 
        80 - 99% = 106 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13515, nodes: 9910443 
    Average node length: 6.22, total dup: 8218220, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1590366, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 3606 
        40 - 59% = 4521 
        60 - 79% = 2633 
        80 - 99% = 2615 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12653, nodes: 9910443 
    Average node length: 5.96, total dup: 8619885, max dup: 56 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2446952, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 8561 
        60 - 79% = 3925 
        80 - 99% = 127 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10234, nodes: 9910443 
    Average node length: 5.13, total dup: 9910343, max dup: 164556 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1616062, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1171 
        40 - 59% = 5040 
        60 - 79% = 1771 
        80 - 99% = 2205 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.01, total records: 11420983 
    Average version length: 82.62, total versions: 822234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 120, data page slots: 194528 
    Data pages: 193184, average fill: 73% 
    Primary pages: 193034, secondary pages: 150, swept pages: 49720 
    Empty pages: 3024, full pages: 153450 
    Fill distribution: 
     0 - 19% = 4872 
    20 - 39% = 6441 
    40 - 59% = 14823 
    60 - 79% = 90094 
    80 - 99% = 76954 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13122, nodes: 11420983 
    Average node length: 5.30, total dup: 11311819, max dup: 674 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2379599, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 79 
        40 - 59% = 9043 
        60 - 79% = 3841 
        80 - 99% = 159 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10438, nodes: 11420983 
    Average node length: 5.50, total dup: 10923287, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 715580, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 815 
        40 - 59% = 2527 
        60 - 79% = 1766 
        80 - 99% = 5189 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11420983 
    Average node length: 6.02, total dup: 9975744, max dup: 73 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2396132, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 94 
        40 - 59% = 10616 
        60 - 79% = 4121 
        80 - 99% = 175 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10759, nodes: 11420983 
    Average node length: 5.22, total dup: 11420883, max dup: 212389 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 704686, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 78 
        20 - 39% = 778 
        40 - 59% = 4761 
        60 - 79% = 1462 
        80 - 99% = 3680 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.54, total records: 9973472 
    Average version length: 82.92, total versions: 973087, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 108, data page slots: 175288 
    Data pages: 175216, average fill: 72% 
    Primary pages: 175175, secondary pages: 41, swept pages: 36791 
    Empty pages: 626, full pages: 121154 
    Fill distribution: 
     0 - 19% = 1948 
    20 - 39% = 6935 
    40 - 59% = 21117 
    60 - 79% = 107306 
    80 - 99% = 37910 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11834, nodes: 9973472 
    Average node length: 5.17, total dup: 9944794, max dup: 2850 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2072510, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1336 
        40 - 59% = 7831 
        60 - 79% = 1991 
        80 - 99% = 648 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13628, nodes: 9973472 
    Average node length: 6.24, total dup: 8270797, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1551106, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 3691 
        40 - 59% = 4428 
        60 - 79% = 2643 
        80 - 99% = 2691 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12469, nodes: 9973472 
    Average node length: 5.42, total dup: 9535206, max dup: 108 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2206224, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1267 
        40 - 59% = 8784 
        60 - 79% = 1756 
        80 - 99% = 633 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10334, nodes: 9973472 
    Average node length: 5.14, total dup: 9973372, max dup: 166556 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1633806, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1212 
        40 - 59% = 5131 
        60 - 79% = 1729 
        80 - 99% = 2225 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.97, total records: 580380 
    Average version length: 68.79, total versions: 11779, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2656 
    Empty pages: 6, full pages: 7544 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 2 
    40 - 59% = 46 
    60 - 79% = 7803 
    80 - 99% = 207 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46322, depth: 3, leaf buckets: 730, nodes: 580380 
    Average node length: 5.95, total dup: 494213, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101989, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 494 
        60 - 79% = 110 
        80 - 99% = 100 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33056, depth: 3, leaf buckets: 754, nodes: 580380 
    Average node length: 6.15, total dup: 475945, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102036, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 517 
        60 - 79% = 108 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 580380 
    Average node length: 4.86, total dup: 580280, max dup: 9707 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90670, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 335 
        60 - 79% = 76 
        80 - 99% = 130 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Feb 27 13:09:33 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7791598 195739 1 0.0000 0.0000
DOC_LIST 2194875 36852 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2100 6 500.0000 0.0000
INVNT_TURNOVER_LOG 140034 99294 1 0.0000 0.0000
MONEY_SALDO 49 126 5 200.0000 0.0000
MONEY_TURNOVER_LOG 2267 1314 1 0.0000 0.0000
PDISTR 884289 46100 2 0.0000 0.0000
PERF_SPLIT_0 168250 4560 1 0.0000 0.0000
PERF_SPLIT_1 136064 7702 1 0.0000 0.0000
PERF_SPLIT_2 145289 8043 1 0.0000 0.0000
PERF_SPLIT_3 161519 1176 1 0.0000 0.0000
PERF_SPLIT_4 168071 19502 1 0.0000 0.0000
PERF_SPLIT_5 150768 2402 1 0.0000 0.0000
PERF_SPLIT_6 176913 19944 1 0.0000 0.0000
PERF_SPLIT_7 167288 11562 1 0.0000 0.0000
PERF_SPLIT_8 169637 9691 1 0.0000 0.0000
PERF_SPLIT_9 216870 65873 1 0.0000 0.0000
PSTORNED 2110928 87392 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 185974 85098 1 0.0000 0.0000
XQD_1000_3300 7722439 700424 1 0.0000 0.0000
XQD_1200_2000 12626516 534040 1 0.0000 0.0000
XQD_2000_3300 2305206 691571 1 0.0000 0.0000
XQD_2100_3300 1957809 211236 1 0.0000 0.0000
XQD_3300_3400 9490952 1047986 1 0.0000 0.0000
XQS_1000_1200 21135920 27542 1 0.0000 0.0000
XQS_1000_3300 9910443 1022848 1 0.0000 0.0000
XQS_1200_2000 11420983 822234 1 0.0000 0.0000
XQS_2100_3300 9973472 973087 1 0.0000 0.0000
XQS_3300_3400 580380 11779 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-oltp40 according to config parameter 'remove_isql_logs'  

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