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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15796916 kB
MemAvailable 30245484 kB
Buffers 0 kB
Cached 15929224 kB
SwapCached 2704 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-14 19:09:57
DTS_END                         2024-03-14 19:09:42.3430
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58320
TRN_ID                          170831
ATT_ID                          274
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9027.82 30290 902782
customer order: creation 161.31 421 16131
customer order: refuse 13.93 384 1393
order to supplier: creation 43.73 1462 4373
order to supplier: removal 3.63 108189 363
invoice (draft): creation 43.00 3801 4300
invoice (draft): removal 51.33 1053 5133
invoice accept: apply 40.02 22682 4002
invoice accept: cancel 45.85 924 4585
customer reserve: creation 3820.80 217 382080
customer reserve: removal 4521.77 65 452177
realization accept: apply 79.12 235 7912
realization accept: cancel 78.76 157 7876
payment from customer: creation 56.59 136 5659
payment from customer: removal 5.44 87 544
payment to supplier: creation 47.09 173 4709
payment to supplier: removal 3.21 71 321
service: total inventory turnovers 4.77 1104 477
service: total monetary turnovers 6.55 51 655
service: aggregate perf. data 0.89 20154 89
service: refresh index statistics 0.03 444434 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2024 19:10:37 to 14-03-2024 19:10:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2202
TEST_TIME 2 3775
TEST_TIME 3 3092
TEST_TIME 4 2952
TEST_TIME 5 3577
TEST_TIME 6 4463
TEST_TIME 7 4889
TEST_TIME 8 5238
TEST_TIME 9 5215
TEST_TIME 10 4976
TEST_TIME 11 5007
TEST_TIME 12 5643
TEST_TIME 13 6136
TEST_TIME 14 6340
TEST_TIME 15 6326
TEST_TIME 16 6404
TEST_TIME 17 6622
TEST_TIME 18 6801
TEST_TIME 19 6927
TEST_TIME 20 6969
TEST_TIME 21 7308
TEST_TIME 22 7575
TEST_TIME 23 7997
TEST_TIME 24 8034
TEST_TIME 25 8125
TEST_TIME 26 8313
TEST_TIME 27 8892
TEST_TIME 28 9402
TEST_TIME 29 9219
TEST_TIME 30 9043
TEST_TIME 31 8847
TEST_TIME 32 9021
TEST_TIME 33 8953
TEST_TIME 34 8844
TEST_TIME 35 8947
TEST_TIME 36 8838
TEST_TIME 37 8754
TEST_TIME 38 8677
TEST_TIME 39 8562
TEST_TIME 40 8810
TEST_TIME 41 8617
TEST_TIME 42 8661
TEST_TIME 43 8563
TEST_TIME 44 8471
TEST_TIME 45 8518
TEST_TIME 46 8633
TEST_TIME 47 8658
TEST_TIME 48 8629
TEST_TIME 49 8532
TEST_TIME 50 8696
TEST_TIME 51 8670
TEST_TIME 52 8733
TEST_TIME 53 8773
TEST_TIME 54 8871
TEST_TIME 55 8878
TEST_TIME 56 8887
TEST_TIME 57 8992
TEST_TIME 58 8992
TEST_TIME 59 8986
TEST_TIME 60 9064
TEST_TIME 61 8975
TEST_TIME 62 8852
TEST_TIME 63 8886
TEST_TIME 64 8848
TEST_TIME 65 8816
TEST_TIME 66 8840
TEST_TIME 67 8774
TEST_TIME 68 8782
TEST_TIME 69 8719
TEST_TIME 70 8613
TEST_TIME 71 8639
TEST_TIME 72 8729
TEST_TIME 73 8729
TEST_TIME 74 8790
TEST_TIME 75 8794
TEST_TIME 76 8872
TEST_TIME 77 8929
TEST_TIME 78 9020
TEST_TIME 79 8977
TEST_TIME 80 8963
TEST_TIME 81 9029
TEST_TIME 82 9038
TEST_TIME 83 9117
TEST_TIME 84 9080
TEST_TIME 85 9070
TEST_TIME 86 9020
TEST_TIME 87 9036
TEST_TIME 88 8965
TEST_TIME 89 8976
TEST_TIME 90 8931
TEST_TIME 91 8940
TEST_TIME 92 8907
TEST_TIME 93 8875
TEST_TIME 94 8869
TEST_TIME 95 8895
TEST_TIME 96 8959
TEST_TIME 97 8997
TEST_TIME 98 9090
TEST_TIME 99 9089
TEST_TIME 100 9034

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2024 19:10:41 to 14-03-2024 19:10:44.

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 1252659 1252659 0 0.00 0 19375 8 0 0
doc_list_biud 1252658 1252658 0 0.00 0 53307 31 0 0
sp_add_invoice_to_stock 4123 4002 121 2.93 49 167853 22683 0 121
sp_cancel_adding_invoice 4585 4585 0 0.00 3 59182 925 0 0
sp_cancel_client_order 1393 1393 0 0.00 4 7441 384 0 0
sp_cancel_customer_reserve 452177 452177 0 0.00 0 39721 66 0 0
sp_cancel_pay_from_customer 544 544 0 0.00 2 1891 88 0 0
sp_cancel_pay_to_supplier 321 321 0 0.00 3 5740 71 0 0
sp_cancel_supplier_invoice 5144 5133 11 0.21 1 53315 1053 0 11
sp_cancel_supplier_order 363 363 0 0.00 11 934376 108189 0 0
sp_cancel_write_off 7876 7876 0 0.00 1 42562 157 0 0
sp_client_order 16131 16131 0 0.00 3 36600 421 0 0
sp_customer_reserve 382080 382080 0 0.00 0 53974 218 0 0
sp_fill_shopping_cart 24796 24796 0 0.00 1 10659 41 0 0
sp_fill_shopping_cart_clo_res 382070 382070 0 0.00 0 22562 19 0 0
sp_get_clo_for_invoice 3992 3992 0 0.00 0 36791 398 0 0
sp_kill_cost_storno 13326 13326 0 0.00 0 19368 83 0 0
sp_kill_qstorno_ret_qs2qd 917726 917726 0 0.00 0 53298 37 0 0
sp_kill_qty_storno 483430 483430 0 0.00 0 53302 79 0 0
sp_lock_selected_doc 16551 16551 0 0.00 0 8787 5 0 0
sp_make_cost_storno 22272 22272 0 0.00 0 16139 75 0 0
sp_multiply_rows_for_pdistr 22271 22271 0 0.00 0 12030 35 0 0
sp_multiply_rows_for_qdistr 16131 16131 0 0.00 0 36593 171 0 0
sp_pay_from_customer 5659 5659 0 0.00 4 16785 137 0 0
sp_pay_to_supplier 4709 4709 0 0.00 5 23494 173 0 0
sp_payment_common 10368 10368 0 0.00 1 12032 38 0 0
sp_qd_handle_on_cancel_clo 1393 1393 0 0.00 0 7435 363 0 0
sp_qd_handle_on_invoice_upd_sts 8576 8576 0 0.00 0 42028 362 0 0
sp_qd_handle_on_reserve_upd_sts 7912 7912 0 0.00 0 35066 88 0 0
sp_reserve_write_off 7912 7912 0 0.00 6 35200 236 0 0
sp_supplier_invoice 4300 4300 0 0.00 6 84460 3801 0 0
sp_supplier_order 4373 4373 0 0.00 6 50230 1462 0 0
srv_aggregate_perf_data 89 89 0 0.00 1671 338317 20155 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2026 126213 38190 0 0
srv_find_qd_qs_mism 862433 862433 0 0.00 0 8967 6 0 0
srv_make_invnt_saldo 477 477 0 0.00 37 68249 1104 0 0
srv_make_money_saldo 655 655 0 0.00 0 8155 51 0 0
srv_recalc_idx_stat 3 3 0 0.00 428760 473820 444434 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4002 4002 0 0.00 0 9490 197 0 0
t$perf-norm:sp_cancel_adding_invoice 321 321 0 0.00 1 2971 89 0 0
t$perf-norm:sp_cancel_client_order 1393 1393 0 0.00 0 6130 18 0 0
t$perf-norm:sp_cancel_customer_reserve 551 551 0 0.00 0 1465 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 544 544 0 0.00 0 1353 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 321 321 0 0.00 0 1154 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 340 340 0 0.00 0 3542 43 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 26079 1799 0 0
t$perf-norm:sp_cancel_write_off 815 815 0 0.00 0 2926 11 0 0
t$perf-norm:sp_client_order 16131 16131 0 0.00 0 8755 19 0 0
t$perf-norm:sp_customer_reserve 745 745 0 0.00 0 2047 7 0 0
t$perf-norm:sp_pay_from_customer 5659 5659 0 0.00 0 6622 10 0 0
t$perf-norm:sp_pay_to_supplier 4709 4709 0 0.00 0 3210 9 0 0
t$perf-norm:sp_reserve_write_off 7912 7912 0 0.00 0 5120 11 0 0
t$perf-norm:sp_supplier_invoice 4300 4300 0 0.00 0 4439 17 0 0
t$perf-norm:sp_supplier_order 4373 4373 0 0.00 0 5616 18 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 203 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 366 15 0 0
t$perf-norm:srv_make_invnt_saldo 477 477 0 0.00 0 801 20 0 0
t$perf-norm:srv_make_money_saldo 655 655 0 0.00 0 4816 41 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 8224 7982 242 2.94 0 7887 18 0 242
v_all_customers 29684 29684 0 0.00 0 38 1 0 0
v_all_suppliers 24804 24804 0 0.00 0 107 1 0 0
v_all_wares 32260 32260 0 0.00 0 98 1 0 0
v_cancel_adding_invoice 642 642 0 0.00 0 1222 8 0 0
v_cancel_client_order 2786 2786 0 0.00 0 996 4 0 0
v_cancel_customer_prepayment 1088 1088 0 0.00 0 848 6 0 0
v_cancel_customer_reserve 1102 1102 0 0.00 0 10457 14 0 0
v_cancel_payment_to_supplier 642 642 0 0.00 0 1220 6 0 0
v_cancel_supplier_invoice 702 680 22 3.13 0 2188 18 0 22
v_cancel_supplier_order 726 726 0 0.00 0 994 4 0 0
v_cancel_write_off 1630 1630 0 0.00 0 636 12 0 0
v_max_id_clo_ord 4370 4370 0 0.00 0 1183 2 0 0
v_max_id_clo_res 745 745 0 0.00 0 3361 16 0 0
v_max_id_ord_sup 4296 4296 0 0.00 0 4570 11 0 0
v_max_non_paid_invoice 973 973 0 0.00 0 250 3 0 0
v_max_non_paid_realizn 2893 2893 0 0.00 0 2509 6 0 0
v_min_id_clo_ord 4370 4370 0 0.00 0 1607 5 0 0
v_min_id_clo_res 745 745 0 0.00 0 2266 8 0 0
v_min_id_ord_sup 4296 4296 0 0.00 0 5357 6 0 0
v_min_non_paid_invoice 4709 4709 0 0.00 0 11796 33 0 0
v_min_non_paid_realizn 5659 5659 0 0.00 0 12027 26 0 0
v_our_firm 8108 8108 0 0.00 0 31 1 0 0
v_reserve_write_off 15824 15824 0 0.00 0 10462 6 0 0
x_lock_depdocs_on_canc_invoice 9378 9378 0 0.00 0 16139 146 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 29344 543 0 0
x_make_qstorno_1000_1200 4373 4373 0 0.00 1 50191 1379 0 0
x_make_qstorno_1200_2000 4300 4300 0 0.00 3 84408 3647 0 0
x_make_qstorno_2100_3300 382080 382080 0 0.00 0 46448 196 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2024 19:10:45 to 14-03-2024 19:10:49.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:46 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:47 23929 8192000000 9900011584 10209988608 981844384 10.702 100 88 174 0 1011618480 6183104 23590992
17:12:17 6906 8192000000 9938495104 10255339520 1019056816 11.063 100 89 178 0 1049996080 7660512 23278752
17:13:30 10125 8192000000 9956433904 10284851200 1041520752 11.279 100 83 167 0 1071534512 8912464 21101296
17:14:45 8884 8192000000 10012295056 10351980544 1091391744 11.756 100 86 173 0 1123052224 10293152 21367328
17:16:01 4555 8192000000 10060334496 10414391296 1150154416 12.311 100 84 167 0 1181749184 12090128 19504640
17:17:09 3391 8192000000 10115297232 10482274304 1203239920 12.806 100 73 147 0 1231815600 12109968 16465712
17:18:14 1554 8192000000 10158566208 10532216832 1245075472 13.193 100 89 177 0 1278552432 13664336 19812624
17:19:17 2402 8192000000 10177297328 10555322368 1265328992 13.379 100 81 162 1 1296833984 13688320 17816672
17:20:23 1577 8192000000 10203398832 10587377664 1289479936 13.599 100 88 176 0 1321679776 13006288 19193552
17:21:26 13272 8192000000 10205423776 10600611840 1301745296 13.711 100 72 141 0 1325173520 6356896 17071328
17:22:40 8005 8192000000 10204435440 10611040256 1311878528 13.803 100 24 49 0 1323470848 5923520 5668800
17:23:52 8294 8192000000 10206407424 10621005824 1321155040 13.887 100 19 38 1 1331214928 5224736 4835152
17:25:00 9612 8192000000 10217216592 10635608064 1329685424 13.964 100 29 58 0 1343806880 7780880 6340576
17:26:15 35425 8192000000 10218749392 10638204928 1330493248 13.972 100 21 40 0 1340123664 5026064 4604352
17:27:51 4070 8192000000 10236134112 10651422720 1336722224 14.028 100 29 58 0 1350039024 6853664 6463136
17:28:55 7088 8192000000 10217883424 10639618048 1319795312 13.875 99 21 42 2 1329608848 5340336 4473200
17:30:08 43293 8192000000 10241772288 10655240192 1335274896 14.015 100 34 66 1 1349653792 7070848 7308048
17:32:01 35118 8192000000 10254932880 10667819008 1340527632 14.062 100 52 102 1 1366632816 13016896 13088288
17:34:34 4734 8192000000 10246818480 10654089216 1303008080 13.723 97 47 92 1 1332099008 18220800 10870128
17:35:46 6880 8192000000 10238298864 10645258240 1306093152 13.751 98 57 112 0 1340443168 21709088 12640928
17:37:23 20314 8192000000 10247167120 10653032448 1320076784 13.877 100 57 114 2 1358951888 25914224 12960880
17:38:51 42000 8192000000 10227170432 10633252864 1291352576 13.617 98 30 60 1 1319818752 20786688 7679488
17:40:39 8225 8192000000 10258042528 10665529344 1334964480 14.012 100 39 78 0 1372957600 28531664 9461456
17:41:52 5481 8192000000 10280219472 10687299584 1345782992 14.110 100 59 115 0 1391360512 31877376 13700144
17:43:02 7189 8192000000 10254688880 10656821248 1326432656 13.935 100 64 125 0 1364717600 23295216 14989728
17:44:20 3530 8192000000 10271109120 10670096384 1321663088 13.892 99 63 123 0 1364067328 27151120 15253120
17:45:28 2699 8192000000 10286910960 10681937920 1342662912 14.081 100 77 145 0 1389215824 28942688 17610224
17:46:41 2023 8192000000 10307610496 10705494016 1358932464 14.228 100 78 157 0 1409705536 31834176 18938896
17:47:51 2834 8192000000 10318334832 10717585408 1358878880 14.227 99 81 160 0 1411085584 32641808 19564896
17:48:58 2550 8192000000 10337333600 10744061952 1387962576 14.488 100 77 153 1 1442242032 35231024 19048432
17:50:06 3243 8192000000 10351014976 10767347712 1397241120 14.570 100 73 144 0 1456230752 40576336 18413296
17:51:13 6248 8192000000 10344017776 10765369344 1399481040 14.590 100 61 121 0 1453962080 39724928 14756112
17:52:33 8128 8192000000 10354447568 10784034816 1410131168 14.685 100 41 82 2 1461915968 40985104 10799696
17:53:48 15014 8192000000 10352437376 10785419264 1410345152 14.687 100 35 70 0 1460087152 40221040 9520960
17:55:36 9890 8192000000 10340406960 10776481792 1394718480 14.548 100 32 64 1 1448125328 44291952 9114896
17:56:51 9491 8192000000 10326680512 10765094912 1385292176 14.464 99 37 72 0 1420196768 26012464 8892128
17:58:04 20779 8192000000 10327701184 10760073216 1401092624 14.605 100 48 94 1 1423818400 11787760 10938016
17:59:33 18211 8192000000 10318598384 10758578176 1401995696 14.613 100 38 76 3 1427432384 16240288 9196400
18:00:54 46673 8192000000 10300425008 10763382784 1399851488 14.594 100 12 24 0 1412474992 9771696 2851808
18:02:42 104968 8192000000 10301757616 10758537216 1390302672 14.509 99 22 44 0 1405358720 9980384 5075664
18:05:50 41260 8192000000 10327366416 10773057536 1409536608 14.680 100 47 93 0 1430407616 10374496 10496512
18:07:41 68064 8192000000 10315121232 10770694144 1409626960 14.681 100 18 36 0 1427001088 13364752 4009376
18:10:16 47901 8192000000 10318189632 10764165120 1397658032 14.574 99 32 65 0 1410220432 5959200 6603200
18:12:06 62720 8192000000 10305892176 10764525568 1398086144 14.578 99 15 30 0 1411694528 10524560 3083824
18:14:10 55973 8192000000 10308024960 10758008832 1380943024 14.425 98 25 50 0 1401916496 14766240 6207232
18:16:14 20898 8192000000 10298110160 10752229376 1397533904 14.573 100 19 36 1 1413393072 11274960 4584208
18:17:51 38224 8192000000 10279461008 10732425216 1340365088 14.061 96 19 34 1 1353899808 9869504 3665216
18:19:36 48035 8192000000 10293614368 10746105856 1371484752 14.340 99 25 50 0 1385528496 8736064 5307680
18:21:25 54213 8192000000 10284817472 10738376704 1328782560 13.956 95 17 34 0 1344593552 12292176 3518816
18:23:19 39506 8192000000 10294218784 10749304832 1364903360 14.281 99 34 68 0 1395854048 23636000 7314688
18:25:50 27939 8192000000 10295023488 10740789248 1378796576 14.406 100 30 60 0 1399304192 14127616 6380000
18:27:22 64140 8192000000 10303943408 10739576832 1359153344 14.230 98 32 62 0 1375700768 9604240 6943184
18:29:29 70747 8192000000 10265186672 10714513408 1308380304 13.771 95 22 44 0 1326503872 13160592 4962976
18:31:41 47374 8192000000 10247576496 10702004224 1325885040 13.930 97 41 80 0 1344984064 9656352 9442672
18:33:31 51566 8192000000 10250946080 10687029248 1299992576 13.695 95 21 41 1 1312735584 8020272 4722736
18:35:24 29915 8192000000 10233865872 10684129280 1316044800 13.841 97 13 26 0 1325574624 6626784 2903040
18:37:43 40578 8192000000 10258542560 10698858496 1312678976 13.810 96 15 30 0 1328598448 12324352 3595120
18:39:24 70211 8192000000 10251627408 10708336640 1334631568 14.009 98 14 28 0 1354986736 16866528 3488640
18:42:13 50105 8192000000 10268511120 10718556160 1351428432 14.160 99 18 36 2 1370485696 14387824 4669440
18:44:07 54026 8192000000 10268776032 10710040576 1319734400 13.874 96 17 34 0 1338786656 15067584 3984672
18:46:01 70545 8192000000 10291448000 10742554624 1372726000 14.351 99 16 30 0 1386903568 10649872 3527696
18:49:01 27547 8192000000 10318975616 10758004736 1386273328 14.473 99 50 100 0 1409901216 12377296 11250592
18:50:40 46884 8192000000 10308741728 10754670592 1391045184 14.515 100 27 53 0 1408304864 11611760 5647920
18:52:29 56741 8192000000 10314693824 10765197312 1402171968 14.614 100 25 50 0 1424758624 17221936 5364720
18:54:28 126212 8192000000 10305949088 10753941504 1396139024 14.561 99 35 71 1 1419249728 15044928 8065776
18:57:36 30033 8192000000 10309233456 10758893568 1388086464 14.489 99 17 34 0 1403701056 11593072 4021520
18:59:10 85586 8192000000 10294990928 10750111744 1368075760 14.310 98 15 29 0 1386383008 14834192 3473056
19:01:39 54443 8192000000 10311019776 10753359872 1365710848 14.289 98 26 51 1 1387884144 16275664 5897632
19:04:00 78861 8192000000 10308380464 10760937472 1361472400 14.251 98 22 44 1 1389140080 22478624 5189056
19:06:19 61423 8192000000 10294607424 10758852608 1384043104 14.453 100 11 20 0 1406028528 19358784 2626640
19:08:20 49218 8192000000 10287656128 10728042496 1350821104 14.155 97 28 56 0 1368513552 11758064 5934384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-03-2024 19:10:51 to 14-03-2024 19:11:05.

Exceptions occured during test was in run

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

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          178966
MON$OLDEST_ACTIVE               178967
MON$OLDEST_SNAPSHOT             178967
MON$NEXT_TRANSACTION            178967
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1904288
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Mar 14 19:11:09 2024 
 
Database header page information: 
    Flags            0 
    Generation        94799 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    178966 
    Oldest active        178967 
    Oldest snapshot        178967 
    Next transaction    178968 
    Sequence number        0 
    Next attachment ID    699 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 46.90, total records: 7767855 
    Average version length: 48.16, total versions: 161407, 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: 53, data page slots: 86312 
    Data pages: 86312, average fill: 72% 
    Primary pages: 86312, secondary pages: 0, swept pages: 11668 
    Empty pages: 4, full pages: 71003 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 101 
    40 - 59% = 1761 
    60 - 79% = 84361 
    80 - 99% = 81 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23193, nodes: 7767855 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1738515, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 380 
        20 - 39% = 1616 
        40 - 59% = 4131 
        60 - 79% = 2247 
        80 - 99% = 14819 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13416, nodes: 7767855 
    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: 1561291, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1438 
        40 - 59% = 2029 
        60 - 79% = 1037 
        80 - 99% = 8912 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8282, nodes: 7767855 
    Average node length: 6.62, total dup: 5800815, max dup: 49 
    Average key length: 3.64, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1554328, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 868 
        40 - 59% = 1397 
        60 - 79% = 838 
        80 - 99% = 5056 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.27, total records: 2256188 
    Average version length: 34.55, total versions: 169138, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.52 
    Pointer pages: 18, data page slots: 28216 
    Data pages: 28216, average fill: 75% 
    Primary pages: 28209, secondary pages: 7, swept pages: 6838 
    Empty pages: 3, full pages: 22682 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 87 
    40 - 59% = 1011 
    60 - 79% = 25161 
    80 - 99% = 1940 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4516, nodes: 2256188 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 702465, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 838 
        40 - 59% = 844 
        60 - 79% = 717 
        80 - 99% = 2116 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2516, nodes: 2259644 
    Average node length: 4.97, total dup: 2258745, max dup: 21231 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249706, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 232 
        40 - 59% = 1535 
        60 - 79% = 552 
        80 - 99% = 193 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1977, nodes: 2256188 
    Average node length: 4.97, total dup: 2256138, max dup: 130031 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057994, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 13 
        40 - 59% = 1033 
        60 - 79% = 57 
        80 - 99% = 870 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4340, nodes: 2256188 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 702465, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 529 
        40 - 59% = 628 
        60 - 79% = 784 
        80 - 99% = 2277 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.65, total records: 400 
    Average version length: 23.10, total versions: 237409, max versions: 618 
    Average fragment length: 2.00, total fragments: 36, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1304 
    Data pages: 1304, average fill: 91% 
    Primary pages: 7, secondary pages: 1297, swept pages: 0 
    Empty pages: 0, full pages: 1303 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1303 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 0.51, total records: 135643 
    Average version length: 68.30, total versions: 134629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 172.17 
    Pointer pages: 7, data page slots: 4016 
    Data pages: 2208, average fill: 78% 
    Primary pages: 2207, secondary pages: 1, swept pages: 0 
    Empty pages: 87, full pages: 1705 
    Fill distribution: 
     0 - 19% = 155 
    20 - 39% = 112 
    40 - 59% = 129 
    60 - 79% = 267 
    80 - 99% = 1545 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707757, depth: 3, leaf buckets: 468, nodes: 135643 
    Average node length: 13.35, total dup: 11683, max dup: 1 
    Average key length: 10.50, compression ratio: 2.57 
    Average prefix length: 19.41, average data length: 7.59 
    Clustering factor: 94275, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 140 
        40 - 59% = 255 
        60 - 79% = 68 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 17636, max versions: 942 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 88% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 58 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 0.94, total records: 2333 
    Average version length: 43.87, total versions: 2283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 61.82 
    Pointer pages: 1, data page slots: 48 
    Data pages: 48, average fill: 48% 
    Primary pages: 47, secondary pages: 1, swept pages: 0 
    Empty pages: 13, full pages: 17 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90196, depth: 2, leaf buckets: 4, nodes: 2333 
    Average node length: 4.19, total dup: 2235, max dup: 258 
    Average key length: 2.46, compression ratio: 7.72 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1243, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.00, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.72, total records: 839042 
    Average version length: 25.60, total versions: 85909, max versions: 4 
    Average fragment length: 29.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8192 
    Data pages: 8184, average fill: 72% 
    Primary pages: 8167, secondary pages: 17, swept pages: 871 
    Empty pages: 22, full pages: 7640 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 7 
    40 - 59% = 46 
    60 - 79% = 7732 
    80 - 99% = 373 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 900, nodes: 839042 
    Average node length: 4.87, total dup: 838993, max dup: 159581 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91535, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 94 
        40 - 59% = 533 
        60 - 79% = 193 
        80 - 99% = 80 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 981, nodes: 839042 
    Average node length: 5.88, total dup: 746930, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166081, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 81 
        40 - 59% = 481 
        60 - 79% = 132 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1023, nodes: 839042 
    Average node length: 5.89, total dup: 746930, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168100, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 178 
        40 - 59% = 443 
        60 - 79% = 123 
        80 - 99% = 278 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1177, nodes: 839042 
    Average node length: 5.97, total dup: 746930, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 160301, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 240 
        40 - 59% = 625 
        60 - 79% = 220 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5500 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.32, total fragments: 79, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 78, secondary pages: 17, swept pages: 47 
    Empty pages: 9, full pages: 69 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5500 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.50, average data length: 1.54 
    Clustering factor: 5212, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5500 
    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: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 76877 
    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: 744 
    Data pages: 744, average fill: 71% 
    Primary pages: 744, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 741 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 741 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38068, depth: 2, leaf buckets: 98, nodes: 76877 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2688, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 96 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.71, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.27 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.26, total records: 170330 
    Average version length: 150.99, total versions: 2908, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 5808 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 3 
    Empty pages: 28, full pages: 4028 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4026 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 142.29, total records: 195002 
    Average version length: 154.03, total versions: 11587, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 7, data page slots: 6160 
    Data pages: 4664, average fill: 87% 
    Primary pages: 4663, secondary pages: 1, swept pages: 1 
    Empty pages: 29, full pages: 4626 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4626 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.29, total records: 171202 
    Average version length: 152.99, total versions: 8578, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 6, data page slots: 5792 
    Data pages: 4080, average fill: 87% 
    Primary pages: 4080, secondary pages: 0, swept pages: 4 
    Empty pages: 21, full pages: 4048 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4047 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.03, total records: 171319 
    Average version length: 151.45, total versions: 5488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 6, data page slots: 5032 
    Data pages: 4080, average fill: 87% 
    Primary pages: 4080, secondary pages: 0, swept pages: 1 
    Empty pages: 20, full pages: 4052 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4049 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.32, total records: 153434 
    Average version length: 151.53, total versions: 4687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 7, data page slots: 5304 
    Data pages: 3664, average fill: 86% 
    Primary pages: 3664, secondary pages: 0, swept pages: 1 
    Empty pages: 26, full pages: 3627 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3628 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.67, total records: 157154 
    Average version length: 149.22, total versions: 2942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 4424 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3736, secondary pages: 0, swept pages: 3 
    Empty pages: 21, full pages: 3708 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3708 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.73, total records: 182145 
    Average version length: 151.16, total versions: 3900, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4344, average fill: 86% 
    Primary pages: 4343, secondary pages: 1, swept pages: 4 
    Empty pages: 28, full pages: 4309 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4309 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.52, total records: 173801 
    Average version length: 146.64, total versions: 2792, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 5000 
    Data pages: 4144, average fill: 86% 
    Primary pages: 4144, secondary pages: 0, swept pages: 5 
    Empty pages: 23, full pages: 4110 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4110 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.57, total records: 185090 
    Average version length: 152.57, total versions: 6728, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 6, data page slots: 5168 
    Data pages: 4408, average fill: 87% 
    Primary pages: 4408, secondary pages: 0, swept pages: 5 
    Empty pages: 18, full pages: 4382 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4384 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 139.80, total records: 185438 
    Average version length: 153.87, total versions: 13753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.13 
    Pointer pages: 7, data page slots: 6448 
    Data pages: 4424, average fill: 87% 
    Primary pages: 4424, secondary pages: 0, swept pages: 3 
    Empty pages: 21, full pages: 4393 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4395 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 50.55, total records: 2126626 
    Average version length: 52.93, total versions: 88642, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.38 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25560, average fill: 72% 
    Primary pages: 25560, secondary pages: 0, swept pages: 8538 
    Empty pages: 235, full pages: 21701 
    Fill distribution: 
     0 - 19% = 470 
    20 - 39% = 363 
    40 - 59% = 901 
    60 - 79% = 22938 
    80 - 99% = 888 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2586, nodes: 2126626 
    Average node length: 5.44, total dup: 1985116, max dup: 1536 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183164, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 271 
        40 - 59% = 1700 
        60 - 79% = 291 
        80 - 99% = 321 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2126626 
    Average node length: 5.69, total dup: 1909418, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379519, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2335 
        60 - 79% = 393 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2166, nodes: 2126626 
    Average node length: 4.96, total dup: 2126526, max dup: 28797 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180748, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 173 
        40 - 59% = 1195 
        60 - 79% = 376 
        80 - 99% = 419 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 33.76, total records: 157876 
    Average version length: 69.18, total versions: 80894, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.73 
    Pointer pages: 3, data page slots: 3904 
    Data pages: 3055, average fill: 61% 
    Primary pages: 3055, secondary pages: 0, swept pages: 464 
    Empty pages: 605, full pages: 2071 
    Fill distribution: 
     0 - 19% = 761 
    20 - 39% = 23 
    40 - 59% = 49 
    60 - 79% = 806 
    80 - 99% = 1416 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105296, depth: 3, leaf buckets: 223, nodes: 157876 
    Average node length: 6.46, total dup: 137405, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26915, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 111 
        60 - 79% = 65 
        80 - 99% = 22 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.95, total records: 7444459 
    Average version length: 68.76, total versions: 540568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 102712 
    Data pages: 102712, average fill: 78% 
    Primary pages: 102712, secondary pages: 0, swept pages: 15425 
    Empty pages: 9, full pages: 99858 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 147 
    40 - 59% = 763 
    60 - 79% = 88523 
    80 - 99% = 13242 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10713, nodes: 7444459 
    Average node length: 6.51, total dup: 6440243, max dup: 41 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1660118, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1485 
        40 - 59% = 5142 
        60 - 79% = 3171 
        80 - 99% = 906 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8752, nodes: 7444459 
    Average node length: 5.39, total dup: 7155466, max dup: 182 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1449120, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 897 
        40 - 59% = 4951 
        60 - 79% = 1793 
        80 - 99% = 1099 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8792, nodes: 7444459 
    Average node length: 5.39, total dup: 7155466, max dup: 182 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1451599, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 957 
        40 - 59% = 4937 
        60 - 79% = 1814 
        80 - 99% = 1081 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.55, total records: 12424781 
    Average version length: 68.70, total versions: 431638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 105, data page slots: 170080 
    Data pages: 170080, average fill: 78% 
    Primary pages: 170080, secondary pages: 0, swept pages: 64888 
    Empty pages: 2, full pages: 169903 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 30 
    60 - 79% = 159249 
    80 - 99% = 10798 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18386, nodes: 12424781 
    Average node length: 6.60, total dup: 10826845, max dup: 77 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2429446, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1915 
        40 - 59% = 10358 
        60 - 79% = 4914 
        80 - 99% = 1174 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 32.98, total records: 1981312 
    Average version length: 69.12, total versions: 1036299, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.82 
    Pointer pages: 26, data page slots: 41448 
    Data pages: 29720, average fill: 78% 
    Primary pages: 29719, secondary pages: 1, swept pages: 3057 
    Empty pages: 1235, full pages: 25926 
    Fill distribution: 
     0 - 19% = 1831 
    20 - 39% = 696 
    40 - 59% = 696 
    60 - 79% = 9291 
    80 - 99% = 17206 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2367, nodes: 1981312 
    Average node length: 5.51, total dup: 1901254, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 132983, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 317 
        40 - 59% = 1074 
        60 - 79% = 703 
        80 - 99% = 264 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 31.84, total records: 1392263 
    Average version length: 69.14, total versions: 749873, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.96 
    Pointer pages: 22, data page slots: 34544 
    Data pages: 28928, average fill: 57% 
    Primary pages: 28927, secondary pages: 1, swept pages: 5414 
    Empty pages: 5541, full pages: 16539 
    Fill distribution: 
     0 - 19% = 7871 
    20 - 39% = 851 
    40 - 59% = 1313 
    60 - 79% = 7571 
    80 - 99% = 11322 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1781, nodes: 1392263 
    Average node length: 5.76, total dup: 1303414, max dup: 99 
    Average key length: 2.81, compression ratio: 14.92 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 193306, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 233 
        40 - 59% = 845 
        60 - 79% = 551 
        80 - 99% = 147 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.10, total records: 9300614 
    Average version length: 68.94, total versions: 781769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 88, data page slots: 142240 
    Data pages: 142224, average fill: 70% 
    Primary pages: 142224, secondary pages: 0, swept pages: 35591 
    Empty pages: 206, full pages: 88650 
    Fill distribution: 
     0 - 19% = 969 
    20 - 39% = 5611 
    40 - 59% = 19006 
    60 - 79% = 101906 
    80 - 99% = 14732 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13474, nodes: 9300614 
    Average node length: 6.67, total dup: 7715249, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2001259, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1368 
        40 - 59% = 6483 
        60 - 79% = 4769 
        80 - 99% = 850 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21112504 
    Average version length: 82.86, total versions: 17675, 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: 195, data page slots: 318152 
    Data pages: 318152, average fill: 81% 
    Primary pages: 318152, secondary pages: 0, swept pages: 11437 
    Empty pages: 31, full pages: 317580 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 23 
    40 - 59% = 78 
    60 - 79% = 26951 
    80 - 99% = 291050 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19456, nodes: 21112504 
    Average node length: 5.72, total dup: 20632459, max dup: 177 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3274594, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8397 
        60 - 79% = 489 
        80 - 99% = 10565 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17137, nodes: 21112504 
    Average node length: 6.31, total dup: 18552968, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913045, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 797 
        60 - 79% = 250 
        80 - 99% = 16085 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21243, nodes: 21112504 
    Average node length: 6.34, total dup: 18473091, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3569049, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8661 
        60 - 79% = 587 
        80 - 99% = 11990 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16035, nodes: 21112504 
    Average node length: 5.56, total dup: 21112404, max dup: 231031 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941694, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2811 
        60 - 79% = 399 
        80 - 99% = 12819 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 75.97, total records: 9735071 
    Average version length: 82.58, total versions: 760621, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 102, data page slots: 166280 
    Data pages: 166264, average fill: 73% 
    Primary pages: 166264, secondary pages: 0, swept pages: 50814 
    Empty pages: 337, full pages: 109218 
    Fill distribution: 
     0 - 19% = 1324 
    20 - 39% = 5402 
    40 - 59% = 19239 
    60 - 79% = 67670 
    80 - 99% = 72629 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11324, nodes: 9735071 
    Average node length: 5.34, total dup: 9426214, max dup: 226 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2151381, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 51 
        40 - 59% = 8056 
        60 - 79% = 3139 
        80 - 99% = 76 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13271, nodes: 9735071 
    Average node length: 6.21, total dup: 8070356, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1493421, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 3639 
        40 - 59% = 4318 
        60 - 79% = 2661 
        80 - 99% = 2550 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12644, nodes: 9735071 
    Average node length: 5.96, total dup: 8453474, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2346372, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 62 
        40 - 59% = 9079 
        60 - 79% = 3391 
        80 - 99% = 110 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10070, nodes: 9735071 
    Average node length: 5.12, total dup: 9734971, max dup: 169210 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1515046, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1265 
        40 - 59% = 4862 
        60 - 79% = 1724 
        80 - 99% = 2184 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 77.49, total records: 11334589 
    Average version length: 82.47, total versions: 660107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 118, data page slots: 191088 
    Data pages: 189888, average fill: 74% 
    Primary pages: 189888, secondary pages: 0, swept pages: 59916 
    Empty pages: 2759, full pages: 144584 
    Fill distribution: 
     0 - 19% = 4733 
    20 - 39% = 6988 
    40 - 59% = 16967 
    60 - 79% = 40826 
    80 - 99% = 120374 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13108, nodes: 11334589 
    Average node length: 5.29, total dup: 11224863, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2361832, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 9167 
        60 - 79% = 3759 
        80 - 99% = 99 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10365, nodes: 11334589 
    Average node length: 5.49, total dup: 10840136, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 713819, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 843 
        40 - 59% = 2429 
        60 - 79% = 1876 
        80 - 99% = 5075 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14995, nodes: 11334589 
    Average node length: 6.02, total dup: 9896386, max dup: 72 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2378299, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 104 
        40 - 59% = 10675 
        60 - 79% = 4110 
        80 - 99% = 106 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10666, nodes: 11334589 
    Average node length: 5.22, total dup: 11334489, max dup: 214688 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 702675, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 72 
        20 - 39% = 805 
        40 - 59% = 4682 
        60 - 79% = 1465 
        80 - 99% = 3642 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 76.48, total records: 9829530 
    Average version length: 82.89, total versions: 742451, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 104, data page slots: 169432 
    Data pages: 169400, average fill: 72% 
    Primary pages: 169400, secondary pages: 0, swept pages: 52879 
    Empty pages: 413, full pages: 105274 
    Fill distribution: 
     0 - 19% = 1268 
    20 - 39% = 4738 
    40 - 59% = 21345 
    60 - 79% = 73560 
    80 - 99% = 68489 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11822, nodes: 9829530 
    Average node length: 5.17, total dup: 9800208, max dup: 2383 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1954304, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1400 
        40 - 59% = 7964 
        60 - 79% = 1826 
        80 - 99% = 596 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13426, nodes: 9829530 
    Average node length: 6.24, total dup: 8148449, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465546, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 3719 
        40 - 59% = 4202 
        60 - 79% = 2659 
        80 - 99% = 2691 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12482, nodes: 9829530 
    Average node length: 5.43, total dup: 9391383, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2090399, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1409 
        40 - 59% = 8785 
        60 - 79% = 1695 
        80 - 99% = 565 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10196, nodes: 9829530 
    Average node length: 5.14, total dup: 9829430, max dup: 171075 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1538868, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1297 
        40 - 59% = 4905 
        60 - 79% = 1689 
        80 - 99% = 2259 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.64, total records: 581288 
    Average version length: 68.83, total versions: 13054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 7952 
    Data pages: 7952, average fill: 77% 
    Primary pages: 7952, secondary pages: 0, swept pages: 2858 
    Empty pages: 4, full pages: 7344 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 4 
    40 - 59% = 71 
    60 - 79% = 7617 
    80 - 99% = 254 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44659, depth: 3, leaf buckets: 722, nodes: 581288 
    Average node length: 5.95, total dup: 495070, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101156, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 489 
        60 - 79% = 96 
        80 - 99% = 112 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32372, depth: 3, leaf buckets: 742, nodes: 581288 
    Average node length: 6.15, total dup: 476841, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101207, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 502 
        60 - 79% = 99 
        80 - 99% = 120 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 581288 
    Average node length: 4.86, total dup: 581188, max dup: 9812 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89731, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 28 
        40 - 59% = 316 
        60 - 79% = 106 
        80 - 99% = 121 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar 14 19:11:33 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7767855 161407 1 0.0000 0.0000
DOC_LIST 2256188 169138 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237409 618 59300.0000 0.0000
INVNT_TURNOVER_LOG 135643 134629 1 0.0000 0.0000
MONEY_SALDO 49 17636 942 35900.0000 0.0000
MONEY_TURNOVER_LOG 2333 2283 1 0.0000 0.0000
PDISTR 839042 85909 4 0.0000 0.0000
PERF_SPLIT_0 170330 2908 1 0.0000 0.0000
PERF_SPLIT_1 195002 11587 1 0.0000 0.0000
PERF_SPLIT_2 171202 8578 1 0.0000 0.0000
PERF_SPLIT_3 171319 5488 1 0.0000 0.0000
PERF_SPLIT_4 153434 4687 1 0.0000 0.0000
PERF_SPLIT_5 157154 2942 1 0.0000 0.0000
PERF_SPLIT_6 182145 3900 1 0.0000 0.0000
PERF_SPLIT_7 173801 2792 1 0.0000 0.0000
PERF_SPLIT_8 185090 6728 1 0.0000 0.0000
PERF_SPLIT_9 185438 13753 1 0.0000 0.0000
PSTORNED 2126626 88642 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 157876 80894 1 0.0000 0.0000
XQD_1000_3300 7444459 540568 1 0.0000 0.0000
XQD_1200_2000 12424781 431638 1 0.0000 0.0000
XQD_2000_3300 1981312 1036299 1 0.0000 0.0000
XQD_2100_3300 1392263 749873 1 0.0000 0.0000
XQD_3300_3400 9300614 781769 1 0.0000 0.0000
XQS_1000_1200 21112504 17675 1 0.0000 0.0000
XQS_1000_3300 9735071 760621 1 0.0000 0.0000
XQS_1200_2000 11334589 660107 1 0.0000 0.0000
XQS_2100_3300 9829530 742451 1 0.0000 0.0000
XQS_3300_3400 581288 13054 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

--- start of diff output ---
--- end of diff output ---

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

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