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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-17 07:14:43
DTS_END                         2024-03-17 07:14:43.5770
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/52192
TRN_ID                          171852
ATT_ID                          496
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: 8941.36 24421 894136
customer order: creation 173.40 457 17340
customer order: refuse 15.06 369 1506
order to supplier: creation 45.63 1562 4563
order to supplier: removal 3.54 98705 354
invoice (draft): creation 46.94 3719 4694
invoice (draft): removal 46.17 881 4617
invoice accept: apply 42.90 22164 4290
invoice accept: cancel 41.78 960 4178
customer reserve: creation 4108.50 212 410850
customer reserve: removal 4126.10 68 412610
realization accept: apply 85.68 247 8568
realization accept: cancel 75.91 163 7591
payment from customer: creation 59.09 125 5909
payment from customer: removal 5.62 113 562
payment to supplier: creation 51.11 156 5111
payment to supplier: removal 3.50 81 350
service: total inventory turnovers 3.37 4944 337
service: total monetary turnovers 6.11 706 611
service: aggregate perf. data 0.92 13464 92
service: refresh index statistics 0.03 339318 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2024 07:15:39 to 17-03-2024 07:15:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3258
TEST_TIME 2 2732
TEST_TIME 3 3382
TEST_TIME 4 3356
TEST_TIME 5 3125
TEST_TIME 6 3273
TEST_TIME 7 3340
TEST_TIME 8 3578
TEST_TIME 9 3862
TEST_TIME 10 4100
TEST_TIME 11 4280
TEST_TIME 12 4370
TEST_TIME 13 4840
TEST_TIME 14 5204
TEST_TIME 15 5300
TEST_TIME 16 5341
TEST_TIME 17 5513
TEST_TIME 18 5774
TEST_TIME 19 6215
TEST_TIME 20 6588
TEST_TIME 21 7091
TEST_TIME 22 7282
TEST_TIME 23 7425
TEST_TIME 24 7482
TEST_TIME 25 7422
TEST_TIME 26 7577
TEST_TIME 27 7727
TEST_TIME 28 8223
TEST_TIME 29 8736
TEST_TIME 30 8650
TEST_TIME 31 8905
TEST_TIME 32 8908
TEST_TIME 33 9025
TEST_TIME 34 8834
TEST_TIME 35 8753
TEST_TIME 36 8909
TEST_TIME 37 8983
TEST_TIME 38 8920
TEST_TIME 39 8984
TEST_TIME 40 8860
TEST_TIME 41 8751
TEST_TIME 42 8776
TEST_TIME 43 8750
TEST_TIME 44 8779
TEST_TIME 45 8777
TEST_TIME 46 8627
TEST_TIME 47 8653
TEST_TIME 48 8597
TEST_TIME 49 8610
TEST_TIME 50 8601
TEST_TIME 51 8544
TEST_TIME 52 8431
TEST_TIME 53 8515
TEST_TIME 54 8641
TEST_TIME 55 8653
TEST_TIME 56 8627
TEST_TIME 57 8692
TEST_TIME 58 8689
TEST_TIME 59 8829
TEST_TIME 60 8801
TEST_TIME 61 8797
TEST_TIME 62 8811
TEST_TIME 63 8956
TEST_TIME 64 8948
TEST_TIME 65 9029
TEST_TIME 66 9008
TEST_TIME 67 8894
TEST_TIME 68 8847
TEST_TIME 69 8863
TEST_TIME 70 8862
TEST_TIME 71 8864
TEST_TIME 72 8839
TEST_TIME 73 8827
TEST_TIME 74 8745
TEST_TIME 75 8784
TEST_TIME 76 8819
TEST_TIME 77 8828
TEST_TIME 78 8864
TEST_TIME 79 8880
TEST_TIME 80 8898
TEST_TIME 81 8956
TEST_TIME 82 8967
TEST_TIME 83 8989
TEST_TIME 84 8995
TEST_TIME 85 8987
TEST_TIME 86 9040
TEST_TIME 87 9041
TEST_TIME 88 9078
TEST_TIME 89 9000
TEST_TIME 90 8986
TEST_TIME 91 8960
TEST_TIME 92 8938
TEST_TIME 93 8904
TEST_TIME 94 8872
TEST_TIME 95 8870
TEST_TIME 96 8856
TEST_TIME 97 8862
TEST_TIME 98 8913
TEST_TIME 99 8943
TEST_TIME 100 8948

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2024 07:15:43 to 17-03-2024 07:15:46.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1269191 1269191 0 0.00 0 28525 8 0 0
doc_list_biud 1269190 1269190 0 0.00 0 37428 28 0 0
sp_add_invoice_to_stock 4374 4290 84 1.92 38 198005 22164 0 84
sp_cancel_adding_invoice 4178 4178 0 0.00 4 82594 960 0 0
sp_cancel_client_order 1506 1506 0 0.00 5 14856 370 0 0
sp_cancel_customer_reserve 412610 412610 0 0.00 0 30915 68 0 0
sp_cancel_pay_from_customer 562 562 0 0.00 2 7093 114 0 0
sp_cancel_pay_to_supplier 350 350 0 0.00 2 3573 82 0 0
sp_cancel_supplier_invoice 4625 4617 8 0.17 2 29380 882 0 8
sp_cancel_supplier_order 354 354 0 0.00 5 968243 98705 0 0
sp_cancel_write_off 7591 7591 0 0.00 1 19036 163 0 0
sp_client_order 17340 17340 0 0.00 3 28944 458 0 0
sp_customer_reserve 410850 410850 0 0.00 0 55870 213 0 0
sp_fill_shopping_cart 26586 26586 0 0.00 1 21394 45 0 0
sp_fill_shopping_cart_clo_res 410842 410842 0 0.00 0 55855 19 0 0
sp_get_clo_for_invoice 4282 4282 0 0.00 0 70505 412 0 0
sp_kill_cost_storno 12681 12681 0 0.00 0 11131 82 0 0
sp_kill_qstorno_ret_qs2qd 837782 837782 0 0.00 0 30910 37 0 0
sp_kill_qty_storno 443705 443705 0 0.00 0 37428 79 0 0
sp_lock_selected_doc 17801 17801 0 0.00 0 6687 5 0 0
sp_make_cost_storno 23869 23869 0 0.00 0 22478 74 0 0
sp_multiply_rows_for_pdistr 23869 23869 0 0.00 0 14636 42 0 0
sp_multiply_rows_for_qdistr 17340 17340 0 0.00 0 28928 232 0 0
sp_pay_from_customer 5909 5909 0 0.00 3 13728 125 0 0
sp_pay_to_supplier 5111 5111 0 0.00 4 28600 156 0 0
sp_payment_common 11020 11020 0 0.00 1 13710 24 0 0
sp_qd_handle_on_cancel_clo 1506 1506 0 0.00 0 14849 336 0 0
sp_qd_handle_on_invoice_upd_sts 8459 8459 0 0.00 0 37428 326 0 0
sp_qd_handle_on_reserve_upd_sts 8568 8568 0 0.00 0 17108 74 0 0
sp_reserve_write_off 8568 8568 0 0.00 6 22764 248 0 0
sp_supplier_invoice 4694 4694 0 0.00 6 103716 3720 0 0
sp_supplier_order 4563 4563 0 0.00 5 77900 1563 0 0
srv_aggregate_perf_data 92 92 0 0.00 1478 92785 13464 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 892 159638 40690 0 0
srv_find_qd_qs_mism 850490 850490 0 0.00 0 26484 7 0 0
srv_make_invnt_saldo 337 337 0 0.00 49 122995 4944 0 0
srv_make_money_saldo 611 611 0 0.00 1 17916 707 0 0
srv_recalc_idx_stat 3 3 0 0.00 164432 526376 339318 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4291 4291 0 0.00 0 6526 181 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 3263 123 0 0
t$perf-norm:sp_cancel_client_order 1506 1506 0 0.00 0 8011 22 0 0
t$perf-norm:sp_cancel_customer_reserve 605 605 0 0.00 0 6345 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 562 562 0 0.00 0 7455 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 350 350 0 0.00 0 522 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 1413 23 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 25505 1871 0 0
t$perf-norm:sp_cancel_write_off 860 860 0 0.00 0 615 2 0 0
t$perf-norm:sp_client_order 17340 17340 0 0.00 0 4848 17 0 0
t$perf-norm:sp_customer_reserve 841 841 0 0.00 0 7684 20 0 0
t$perf-norm:sp_pay_from_customer 5909 5909 0 0.00 0 4928 7 0 0
t$perf-norm:sp_pay_to_supplier 5111 5111 0 0.00 0 2648 6 0 0
t$perf-norm:sp_reserve_write_off 8568 8568 0 0.00 0 3113 8 0 0
t$perf-norm:sp_supplier_invoice 4694 4694 0 0.00 0 7276 21 0 0
t$perf-norm:sp_supplier_order 4563 4563 0 0.00 0 3209 14 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 93 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 181 8 0 0
t$perf-norm:srv_make_invnt_saldo 337 337 0 0.00 0 1504 12 0 0
t$perf-norm:srv_make_money_saldo 611 611 0 0.00 0 2325 11 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 8730 8562 168 1.92 0 5182 17 0 168
v_all_customers 32168 32168 0 0.00 0 23 1 0 0
v_all_suppliers 26600 26600 0 0.00 0 29 1 0 0
v_all_wares 34676 34676 0 0.00 0 178 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 4747 16 0 0
v_cancel_client_order 3012 3012 0 0.00 0 4673 11 0 0
v_cancel_customer_prepayment 1124 1124 0 0.00 0 2796 9 0 0
v_cancel_customer_reserve 1210 1210 0 0.00 0 2705 8 0 0
v_cancel_payment_to_supplier 700 700 0 0.00 0 2468 9 0 0
v_cancel_supplier_invoice 708 692 16 2.25 0 692 13 0 16
v_cancel_supplier_order 708 708 0 0.00 0 2889 12 0 0
v_cancel_write_off 1720 1720 0 0.00 0 4792 15 0 0
v_max_id_clo_ord 4556 4556 0 0.00 0 1375 2 0 0
v_max_id_clo_res 841 841 0 0.00 0 979 6 0 0
v_max_id_ord_sup 4691 4691 0 0.00 0 7192 7 0 0
v_max_non_paid_invoice 1058 1058 0 0.00 0 103 2 0 0
v_max_non_paid_realizn 2754 2754 0 0.00 0 12995 16 0 0
v_min_id_clo_ord 4556 4556 0 0.00 0 4581 10 0 0
v_min_id_clo_res 841 841 0 0.00 0 2606 8 0 0
v_min_id_ord_sup 4691 4691 0 0.00 0 3654 4 0 0
v_min_non_paid_invoice 5111 5111 0 0.00 0 8716 14 0 0
v_min_non_paid_realizn 5909 5909 0 0.00 0 8717 16 0 0
v_our_firm 8818 8818 0 0.00 0 24 1 0 0
v_reserve_write_off 17136 17136 0 0.00 0 4913 9 0 0
x_lock_depdocs_on_canc_invoice 8449 8449 0 0.00 0 11591 146 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 12503 388 0 0
x_make_qstorno_1000_1200 4563 4563 0 0.00 2 77893 1477 0 0
x_make_qstorno_1200_2000 4694 4694 0 0.00 3 98504 3544 0 0
x_make_qstorno_2100_3300 410850 410850 0 0.00 0 55031 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2024 07:15:47 to 17-03-2024 07:15:51.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:14:47 4 8192000000 8798557872 8809668608 4463136 0.054 2 1 2 0 4562528 63616 35776
05:15:48 25005 8192000000 9713795552 10012913664 793339488 8.829 100 92 184 0 826664736 11762624 21562624
05:17:23 13641 8192000000 9744397456 10047860736 817597840 9.074 100 92 184 0 851286128 11440736 22247552
05:18:53 19098 8192000000 9775953920 10089951232 842017552 9.320 100 88 176 0 881026736 18359136 20650048
05:20:13 19281 8192000000 9829032976 10157613056 887203248 9.771 100 79 156 0 936296048 32656448 16436352
05:21:37 8829 8192000000 9887118048 10232360960 926241792 10.158 100 80 160 0 1004011808 60885456 16884560
05:22:50 5471 8192000000 9936347568 10287661056 963150096 10.520 100 78 156 0 1050640720 71970672 15519952
05:23:57 2600 8192000000 9973468544 10332364800 995572912 10.836 100 83 166 0 1083274144 71474192 16227040
05:25:02 2225 8192000000 10010890400 10371735552 1017039760 11.043 100 90 180 2 1122513632 88351168 17122704
05:26:05 813 8192000000 10019924272 10392793088 1037897760 11.244 100 85 165 0 1131116592 77515552 15703280
05:27:09 1656 8192000000 10026837536 10401701888 1053416496 11.393 100 80 160 1 1141969648 73494160 15058992
05:28:11 963 8192000000 10008995840 10388156416 1054123472 11.400 100 78 153 0 1122629072 53301440 15204160
05:29:17 5427 8192000000 9980312352 10378510336 1069374064 11.546 100 27 52 0 1103869712 29561088 4934560
05:30:25 5633 8192000000 9987411904 10387709952 1075848368 11.608 100 28 55 2 1105865936 24043872 5973696
05:31:32 8172 8192000000 9998006704 10413363200 1079947632 11.647 100 32 65 0 1109372064 22921936 6502496
05:32:44 40402 8192000000 10002155968 10405519360 1088410496 11.728 100 61 120 0 1109022000 6432320 14179184
05:34:26 7387 8192000000 10006678416 10420334592 1092393936 11.765 100 31 60 1 1123526496 25415808 5716752
05:35:42 36334 8192000000 10032319232 10430312448 1083646032 11.682 99 51 102 0 1125293184 31785264 9861888
05:37:40 9087 8192000000 10064652096 10465497088 1107572112 11.909 100 48 96 0 1177344688 60306896 9465680
05:38:51 159637 8192000000 10101172448 10525827072 1102540128 11.862 99 30 60 0 1221434800 112188128 6706544
05:42:35 26564 8192000000 10119765328 10544078848 1111964624 11.951 99 46 91 0 1243148112 122557952 8625536
05:44:10 4609 8192000000 10147221600 10556149760 1114066800 11.971 100 45 89 0 1254721776 131704208 8950768
05:45:25 40316 8192000000 10154121360 10562826240 1069888352 11.551 96 43 86 0 1218252272 139015776 9348144
05:47:08 56616 8192000000 10180525552 10632118272 1126901152 12.092 100 44 86 0 1288706576 152494704 9310720
05:49:14 5359 8192000000 10149558992 10549882880 1090783792 11.750 97 51 100 2 1229399344 127599488 11016064
05:50:24 8204 8192000000 10179605760 10587852800 1101442784 11.851 99 39 78 0 1274461632 164262096 8756752
05:51:39 8266 8192000000 10190054848 10609336320 1101733728 11.854 99 38 75 0 1293976736 183579296 8663712
05:52:52 3434 8192000000 10212875024 10606301184 1108926384 11.922 100 75 150 3 1314420640 189881728 15612528
05:53:59 13578 8192000000 10165376064 10587881472 1097307952 11.812 100 26 52 0 1280903872 177481424 6114496
05:55:15 892 8192000000 10149583072 10533355520 1081945600 11.666 99 89 170 1 1249223952 149513504 17764848
05:56:20 2880 8192000000 10152274832 10539741184 1116758720 11.996 100 74 145 0 1247815968 116748480 14308768
05:57:30 1752 8192000000 10183678464 10567774208 1109400800 11.927 100 88 177 0 1275658640 148022320 18235520
05:58:37 10076 8192000000 10176721600 10577408000 1110530272 11.937 100 49 98 0 1277957328 156215808 11211248
05:59:53 1516 8192000000 10273500832 10659872768 1128905728 12.111 100 93 188 2 1361524480 213435488 19183264
06:00:56 7247 8192000000 10289769552 10720501760 1127315248 12.096 100 43 85 0 1391658896 254345632 9998016
06:02:09 27924 8192000000 10212875872 10675224576 1112583616 11.957 99 20 40 0 1320816928 203640400 4592912
06:03:44 12780 8192000000 10179071456 10699878400 1117332816 12.002 100 20 39 1 1323080640 201229648 4518176
06:04:58 37645 8192000000 10091771312 10513022976 1119145968 12.019 100 27 55 0 1264483088 139486016 5851104
06:06:43 20495 8192000000 10136271760 10562658304 1136707632 12.185 100 45 90 1 1229619504 83595984 9315888
06:08:37 19678 8192000000 10143825568 10576519168 1142326960 12.237 100 28 56 1 1255290192 106017152 6946080
06:10:00 57799 8192000000 10108900896 10590932992 1132310080 12.143 99 12 24 0 1240702992 105587152 2805760
06:11:59 6724 8192000000 10072112224 10532028416 1134879104 12.167 100 28 50 0 1173403856 33785088 4739664
06:13:10 41278 8192000000 10088551008 10562490368 1144180192 12.255 100 29 56 1 1184201328 34770400 5250736
06:14:59 23569 8192000000 10127028016 10557214720 1152153552 12.330 100 45 89 1 1220440256 58762192 9524512
06:16:28 106461 8192000000 10080565040 10590195712 1130989952 12.131 99 14 28 0 1191081296 56889136 3202208
06:19:18 75893 8192000000 10059229776 10505203712 1122795600 12.053 99 15 28 0 1161830592 36330848 2704144
06:21:40 31422 8192000000 10073689584 10522140672 1104487248 11.880 98 20 38 0 1164576848 55295360 4794240
06:23:13 3231 8192000000 10099576512 10530541568 1124194576 12.067 100 51 98 1 1203951856 68514768 11242512
06:24:19 81342 8192000000 10126891200 10581643264 1133433120 12.154 100 21 40 0 1247681840 109953600 4295120
06:26:49 46449 8192000000 10113512336 10578456576 1123728640 12.062 99 19 36 0 1239587040 111956352 3902048
06:28:45 65824 8192000000 10042212608 10504810496 1065953920 11.513 94 18 36 0 1098277680 28790800 3532960
06:30:56 87693 8192000000 10051631312 10490318848 1049869680 11.359 93 11 22 0 1124477792 72242976 2365136
06:33:29 34879 8192000000 10055670416 10557812736 1114841824 11.978 99 22 44 0 1180472064 61759440 3870800
06:35:04 24408 8192000000 10071228752 10509746176 1115968528 11.989 100 36 71 0 1166287856 43759104 6560224
06:36:28 15346 8192000000 10066066064 10499825664 1090438320 11.747 98 49 98 0 1159015888 59159456 9418112
06:37:50 93129 8192000000 10072975856 10549755904 1062601808 11.481 95 12 24 0 1131222496 66147552 2473136
06:40:26 143178 8192000000 10076667360 10529202176 1076065696 11.610 96 17 34 2 1148003360 68073200 3864464
06:45:24 46951 8192000000 10038277680 10497880064 1091594544 11.758 98 12 24 0 1143358816 49180064 2584208
06:47:15 65235 8192000000 10065088672 10537582592 1082556432 11.672 97 7 14 0 1139530336 55686064 1287840
06:49:46 59641 8192000000 10027856400 10471714816 1097488064 11.814 99 6 12 0 1131089936 32518368 1083504
06:51:57 45757 8192000000 10059616048 10493538304 1111581232 11.947 100 24 48 0 1170121152 53470112 5069808
06:53:47 62712 8192000000 10077400064 10531651584 1126327648 12.087 100 17 34 0 1204473184 74655824 3489712
06:55:52 49573 8192000000 10069436944 10518458368 1108941248 11.922 98 29 58 0 1167990176 53592832 5456096
06:57:44 52927 8192000000 10085285600 10529439744 1137323200 12.190 100 30 60 0 1173370736 29822576 6224960
06:59:40 18081 8192000000 10105559200 10528399360 1138188832 12.198 100 46 91 0 1203460944 56688848 8583264
07:01:00 44365 8192000000 10100453264 10534703104 1147993776 12.291 100 37 74 0 1202732928 47887760 6851392
07:02:52 116461 8192000000 10069000096 10509266944 1120379824 12.031 98 28 56 0 1163001488 37336640 5285024
07:05:51 29766 8192000000 10090115616 10535841792 1130039728 12.122 99 19 38 0 1176095920 42249984 3806208
07:07:26 31303 8192000000 10046267936 10523336704 1121626128 12.042 100 4 8 0 1160170640 37507376 1037136
07:09:13 54070 8192000000 10078658272 10518044672 1112218272 11.953 99 18 37 0 1149567632 33637728 3711632
07:11:15 62949 8192000000 10103129008 10531135488 1055971696 11.418 93 30 60 1 1146213344 83819696 6421952
07:13:21 44580 8192000000 10053665616 10506186752 1104292272 11.878 99 9 18 0 1166155696 60064128 1799296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 84 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sun Mar 17 07:16:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        90160 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171302 
    Oldest active        172348 
    Oldest snapshot        172348 
    Next transaction    172349 
    Sequence number        0 
    Next attachment ID    691 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.49, total records: 7770892 
    Average version length: 48.16, total versions: 79892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88648 
    Data pages: 88648, average fill: 70% 
    Primary pages: 88647, secondary pages: 1, swept pages: 34210 
    Empty pages: 13, full pages: 78946 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 31 
    40 - 59% = 831 
    60 - 79% = 87726 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23190, nodes: 7770892 
    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: 1709743, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 363 
        20 - 39% = 1592 
        40 - 59% = 4174 
        60 - 79% = 2313 
        80 - 99% = 14748 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13441, nodes: 7770892 
    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: 1533778, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1352 
        40 - 59% = 2173 
        60 - 79% = 1061 
        80 - 99% = 8855 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8292, nodes: 7770892 
    Average node length: 6.62, total dup: 5803138, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1526712, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 837 
        40 - 59% = 1460 
        60 - 79% = 867 
        80 - 99% = 4996 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.56, total records: 2257679 
    Average version length: 58.81, total versions: 42389, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28528 
    Data pages: 28528, average fill: 73% 
    Primary pages: 28526, secondary pages: 2, swept pages: 8881 
    Empty pages: 4, full pages: 24417 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 28 
    40 - 59% = 245 
    60 - 79% = 28153 
    80 - 99% = 93 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4531, nodes: 2257679 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 692480, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 841 
        40 - 59% = 895 
        60 - 79% = 670 
        80 - 99% = 2125 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2448, nodes: 2259523 
    Average node length: 4.97, total dup: 2258624, max dup: 20763 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1278062, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 195 
        40 - 59% = 1459 
        60 - 79% = 540 
        80 - 99% = 252 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1758, nodes: 2257679 
    Average node length: 4.97, total dup: 2257629, max dup: 130148 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066229, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 600 
        60 - 79% = 41 
        80 - 99% = 1112 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4337, nodes: 2257679 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 692480, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 552 
        40 - 59% = 663 
        60 - 79% = 766 
        80 - 99% = 2255 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.33, total records: 400 
    Average version length: 31.71, total versions: 1095, max versions: 3 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 48% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 8, full pages: 10 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 11 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.51, total records: 125807 
    Average version length: 68.28, total versions: 120488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.65 
    Pointer pages: 8, data page slots: 3248 
    Data pages: 2320, average fill: 74% 
    Primary pages: 2319, secondary pages: 1, swept pages: 0 
    Empty pages: 305, full pages: 1691 
    Fill distribution: 
     0 - 19% = 390 
    20 - 39% = 75 
    40 - 59% = 90 
    60 - 79% = 132 
    80 - 99% = 1633 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1695890, depth: 3, leaf buckets: 402, nodes: 125807 
    Average node length: 13.33, total dup: 8080, max dup: 2 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 91856, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 337 
        60 - 79% = 49 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 132, max versions: 4 
    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: 1 
    Data pages: 1, average fill: 61% 
    Primary pages: 1, 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% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.32, total records: 2324 
    Average version length: 43.17, total versions: 2167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.12 
    Pointer pages: 1, data page slots: 72 
    Data pages: 32, average fill: 76% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 22 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93303, depth: 2, leaf buckets: 3, nodes: 2324 
    Average node length: 4.19, total dup: 2226, max dup: 261 
    Average key length: 2.46, compression ratio: 7.74 
    Average prefix length: 18.59, average data length: 0.41 
    Clustering factor: 1243, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.60, 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: 51% 
    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 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, 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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.71, total records: 831322 
    Average version length: 37.91, total versions: 38512, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8608 
    Data pages: 8608, average fill: 66% 
    Primary pages: 8606, secondary pages: 2, swept pages: 1219 
    Empty pages: 28, full pages: 7548 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 53 
    40 - 59% = 321 
    60 - 79% = 8124 
    80 - 99% = 58 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 862, nodes: 807468 
    Average node length: 4.88, total dup: 807419, max dup: 149028 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90758, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 481 
        60 - 79% = 160 
        80 - 99% = 113 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 964, nodes: 807468 
    Average node length: 5.89, total dup: 718966, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160608, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 573 
        60 - 79% = 80 
        80 - 99% = 272 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1007, nodes: 807468 
    Average node length: 5.89, total dup: 718966, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162595, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 580 
        60 - 79% = 76 
        80 - 99% = 253 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1159, nodes: 807468 
    Average node length: 5.97, total dup: 718966, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155180, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 254 
        40 - 59% = 638 
        60 - 79% = 175 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5415 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.67, total fragments: 15, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 120 
    Data pages: 95, average fill: 56% 
    Primary pages: 87, secondary pages: 8, swept pages: 53 
    Empty pages: 16, full pages: 61 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 5, nodes: 5415 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 9.99 
    Average prefix length: 34.34, average data length: 1.55 
    Clustering factor: 5081, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5415 
    Average node length: 11.13, 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: 159, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 77478 
    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: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 804 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 804 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37122, depth: 2, leaf buckets: 101, nodes: 77478 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2879, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 96 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 133.97, total records: 170026 
    Average version length: 152.74, total versions: 20453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.66 
    Pointer pages: 7, data page slots: 5576 
    Data pages: 4216, average fill: 85% 
    Primary pages: 4212, secondary pages: 4, swept pages: 5 
    Empty pages: 33, full pages: 4172 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 4170 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 130.34, total records: 153767 
    Average version length: 152.70, total versions: 22349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.01 
    Pointer pages: 8, data page slots: 4568 
    Data pages: 3824, average fill: 85% 
    Primary pages: 3821, secondary pages: 3, swept pages: 3 
    Empty pages: 36, full pages: 3769 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 3766 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 119.93, total records: 197654 
    Average version length: 154.44, total versions: 43643, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.14 
    Pointer pages: 6, data page slots: 5672 
    Data pages: 4920, average fill: 86% 
    Primary pages: 4917, secondary pages: 3, swept pages: 4 
    Empty pages: 40, full pages: 4868 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4869 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 137.09, total records: 165510 
    Average version length: 151.47, total versions: 16328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.37 
    Pointer pages: 6, data page slots: 5584 
    Data pages: 4112, average fill: 84% 
    Primary pages: 4109, secondary pages: 3, swept pages: 1 
    Empty pages: 41, full pages: 4058 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4058 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 134.01, total records: 170592 
    Average version length: 152.55, total versions: 20432, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.66 
    Pointer pages: 8, data page slots: 4912 
    Data pages: 4224, average fill: 85% 
    Primary pages: 4221, secondary pages: 3, swept pages: 2 
    Empty pages: 27, full pages: 4182 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4181 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 139.20, total records: 168539 
    Average version length: 151.53, total versions: 14002, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 4160, average fill: 84% 
    Primary pages: 4158, secondary pages: 2, swept pages: 1 
    Empty pages: 18, full pages: 4133 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4134 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 119.45, total records: 189645 
    Average version length: 154.40, total versions: 42028, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.20 
    Pointer pages: 6, data page slots: 5208 
    Data pages: 4712, average fill: 86% 
    Primary pages: 4709, secondary pages: 3, swept pages: 1 
    Empty pages: 37, full pages: 4660 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4659 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 126.65, total records: 188509 
    Average version length: 153.90, total versions: 32333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.39 
    Pointer pages: 8, data page slots: 5440 
    Data pages: 4712, average fill: 85% 
    Primary pages: 4707, secondary pages: 5, swept pages: 2 
    Empty pages: 67, full pages: 4625 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4626 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 124.11, total records: 166522 
    Average version length: 153.55, total versions: 31352, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.66 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 4160, average fill: 85% 
    Primary pages: 4157, secondary pages: 3, swept pages: 4 
    Empty pages: 58, full pages: 4083 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4084 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 124.67, total records: 168951 
    Average version length: 153.75, total versions: 31214, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.60 
    Pointer pages: 6, data page slots: 4880 
    Data pages: 4192, average fill: 85% 
    Primary pages: 4189, secondary pages: 3, swept pages: 3 
    Empty pages: 35, full pages: 4145 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4145 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.99, total records: 2096544 
    Average version length: 52.93, total versions: 36013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25576 
    Data pages: 25576, average fill: 71% 
    Primary pages: 25565, secondary pages: 11, swept pages: 10478 
    Empty pages: 92, full pages: 22727 
    Fill distribution: 
     0 - 19% = 217 
    20 - 39% = 261 
    40 - 59% = 748 
    60 - 79% = 24002 
    80 - 99% = 348 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2606, nodes: 2096544 
    Average node length: 5.44, total dup: 1956008, max dup: 1467 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181759, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 311 
        40 - 59% = 1734 
        60 - 79% = 288 
        80 - 99% = 270 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2096544 
    Average node length: 5.69, total dup: 1882081, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375026, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2454 
        60 - 79% = 274 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2059, nodes: 2096544 
    Average node length: 4.96, total dup: 2096444, max dup: 28364 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 179736, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 150 
        40 - 59% = 1053 
        60 - 79% = 367 
        80 - 99% = 486 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 39.84, total records: 171422 
    Average version length: 69.18, total versions: 83635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 3, data page slots: 4440 
    Data pages: 3496, average fill: 60% 
    Primary pages: 3495, secondary pages: 1, swept pages: 530 
    Empty pages: 718, full pages: 2410 
    Fill distribution: 
     0 - 19% = 916 
    20 - 39% = 58 
    40 - 59% = 48 
    60 - 79% = 888 
    80 - 99% = 1586 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556730, depth: 3, leaf buckets: 242, nodes: 171422 
    Average node length: 6.48, total dup: 149399, max dup: 14 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29210, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 128 
        60 - 79% = 63 
        80 - 99% = 27 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.75, total records: 7011383 
    Average version length: 68.79, total versions: 491498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 65, data page slots: 106048 
    Data pages: 106048, average fill: 71% 
    Primary pages: 106047, secondary pages: 1, swept pages: 15097 
    Empty pages: 128, full pages: 76458 
    Fill distribution: 
     0 - 19% = 505 
    20 - 39% = 1222 
    40 - 59% = 7752 
    60 - 79% = 95145 
    80 - 99% = 1424 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10734, nodes: 7011383 
    Average node length: 6.51, total dup: 6064860, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1649406, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1733 
        40 - 59% = 6004 
        60 - 79% = 2605 
        80 - 99% = 389 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8656, nodes: 7011383 
    Average node length: 5.40, total dup: 6730887, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1458069, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1249 
        40 - 59% = 5126 
        60 - 79% = 1359 
        80 - 99% = 911 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8743, nodes: 7011383 
    Average node length: 5.40, total dup: 6730887, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1460349, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1341 
        40 - 59% = 5134 
        60 - 79% = 1372 
        80 - 99% = 892 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.98, total records: 11965569 
    Average version length: 68.73, total versions: 390635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 106, data page slots: 172768 
    Data pages: 172768, average fill: 74% 
    Primary pages: 172768, secondary pages: 0, swept pages: 54429 
    Empty pages: 3, full pages: 157910 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 561 
    40 - 59% = 3931 
    60 - 79% = 165767 
    80 - 99% = 2452 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18409, nodes: 11963250 
    Average node length: 6.60, total dup: 10429279, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2448230, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2201 
        40 - 59% = 11206 
        60 - 79% = 4325 
        80 - 99% = 647 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 44.49, total records: 1754570 
    Average version length: 69.04, total versions: 476007, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.83 
    Pointer pages: 30, data page slots: 48472 
    Data pages: 31320, average fill: 59% 
    Primary pages: 31212, secondary pages: 108, swept pages: 6629 
    Empty pages: 2496, full pages: 20778 
    Fill distribution: 
     0 - 19% = 4335 
    20 - 39% = 4197 
    40 - 59% = 3113 
    60 - 79% = 13377 
    80 - 99% = 6298 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 2003, nodes: 1511335 
    Average node length: 5.53, total dup: 1449774, max dup: 49 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 106632, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 437 
        40 - 59% = 981 
        60 - 79% = 478 
        80 - 99% = 95 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 35.52, total records: 1309977 
    Average version length: 69.03, total versions: 160948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.55 
    Pointer pages: 24, data page slots: 37776 
    Data pages: 31816, average fill: 33% 
    Primary pages: 31815, secondary pages: 1, swept pages: 9062 
    Empty pages: 8470, full pages: 13829 
    Fill distribution: 
     0 - 19% = 13472 
    20 - 39% = 4090 
    40 - 59% = 6438 
    60 - 79% = 7410 
    80 - 99% = 406 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1161, nodes: 740127 
    Average node length: 5.89, total dup: 685138, max dup: 68 
    Average key length: 2.96, compression ratio: 14.20 
    Average prefix length: 41.12, average data length: 0.88 
    Clustering factor: 98030, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 429 
        40 - 59% = 515 
        60 - 79% = 197 
        80 - 99% = 20 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.23, total records: 9323986 
    Average version length: 68.94, total versions: 411473, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 89, data page slots: 144600 
    Data pages: 144560, average fill: 69% 
    Primary pages: 144538, secondary pages: 22, swept pages: 41960 
    Empty pages: 223, full pages: 92738 
    Fill distribution: 
     0 - 19% = 844 
    20 - 39% = 4926 
    40 - 59% = 17157 
    60 - 79% = 118455 
    80 - 99% = 3178 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13468, nodes: 9319998 
    Average node length: 6.69, total dup: 7729583, max dup: 21 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2139208, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 960 
        40 - 59% = 6909 
        60 - 79% = 4924 
        80 - 99% = 674 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21103019 
    Average version length: 82.93, total versions: 14537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318888 
    Data pages: 318888, average fill: 81% 
    Primary pages: 318886, secondary pages: 2, swept pages: 11435 
    Empty pages: 6, full pages: 318744 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 3 
    40 - 59% = 14 
    60 - 79% = 47634 
    80 - 99% = 271231 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19261, nodes: 21103019 
    Average node length: 5.72, total dup: 20623025, max dup: 147 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276679, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 7993 
        60 - 79% = 538 
        80 - 99% = 10728 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17123, nodes: 21103019 
    Average node length: 6.31, total dup: 18545384, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915216, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 770 
        60 - 79% = 262 
        80 - 99% = 16082 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21108, nodes: 21103019 
    Average node length: 6.35, total dup: 18464496, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570017, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8418 
        60 - 79% = 572 
        80 - 99% = 12116 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16065, nodes: 21103019 
    Average node length: 5.56, total dup: 21102919, max dup: 230499 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943951, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2890 
        60 - 79% = 376 
        80 - 99% = 12789 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.32, total records: 9775379 
    Average version length: 82.62, total versions: 411383, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 104, data page slots: 168768 
    Data pages: 168736, average fill: 72% 
    Primary pages: 168703, secondary pages: 33, swept pages: 64430 
    Empty pages: 297, full pages: 111039 
    Fill distribution: 
     0 - 19% = 965 
    20 - 39% = 4520 
    40 - 59% = 18572 
    60 - 79% = 121343 
    80 - 99% = 23336 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11344, nodes: 9775379 
    Average node length: 5.36, total dup: 9467705, max dup: 189 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2240923, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 35 
        40 - 59% = 8027 
        60 - 79% = 3177 
        80 - 99% = 102 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13393, nodes: 9775379 
    Average node length: 6.23, total dup: 8102147, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1592377, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 115 
        20 - 39% = 3576 
        40 - 59% = 4523 
        60 - 79% = 2573 
        80 - 99% = 2606 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12673, nodes: 9775379 
    Average node length: 5.98, total dup: 8487378, max dup: 53 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2432946, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 46 
        40 - 59% = 9060 
        60 - 79% = 3458 
        80 - 99% = 106 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10125, nodes: 9775379 
    Average node length: 5.13, total dup: 9775279, max dup: 164737 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1606945, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1227 
        40 - 59% = 4868 
        60 - 79% = 1825 
        80 - 99% = 2174 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.02, total records: 11450932 
    Average version length: 82.55, total versions: 356610, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 119, data page slots: 194000 
    Data pages: 192768, average fill: 73% 
    Primary pages: 192608, secondary pages: 160, swept pages: 60963 
    Empty pages: 2514, full pages: 152274 
    Fill distribution: 
     0 - 19% = 4158 
    20 - 39% = 6077 
    40 - 59% = 15164 
    60 - 79% = 98650 
    80 - 99% = 68719 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13144, nodes: 11450932 
    Average node length: 5.30, total dup: 11341469, max dup: 647 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2401200, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 67 
        40 - 59% = 8998 
        60 - 79% = 3922 
        80 - 99% = 155 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10465, nodes: 11450932 
    Average node length: 5.50, total dup: 10950382, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 739088, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 777 
        40 - 59% = 2504 
        60 - 79% = 1865 
        80 - 99% = 5184 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15026, nodes: 11450932 
    Average node length: 6.03, total dup: 9997919, max dup: 75 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2417706, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 10529 
        60 - 79% = 4230 
        80 - 99% = 190 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10803, nodes: 11450932 
    Average node length: 5.23, total dup: 11450832, max dup: 205120 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 727640, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 804 
        40 - 59% = 4703 
        60 - 79% = 1524 
        80 - 99% = 3686 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.95, total records: 9852977 
    Average version length: 82.89, total versions: 373162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 172024 
    Data pages: 171992, average fill: 71% 
    Primary pages: 171967, secondary pages: 25, swept pages: 70920 
    Empty pages: 319, full pages: 107473 
    Fill distribution: 
     0 - 19% = 1131 
    20 - 39% = 5160 
    40 - 59% = 20431 
    60 - 79% = 123633 
    80 - 99% = 21637 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11845, nodes: 9852977 
    Average node length: 5.17, total dup: 9824087, max dup: 2011 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2061652, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1419 
        40 - 59% = 7906 
        60 - 79% = 1903 
        80 - 99% = 584 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13532, nodes: 9852977 
    Average node length: 6.24, total dup: 8167342, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1569797, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 3588 
        40 - 59% = 4564 
        60 - 79% = 2525 
        80 - 99% = 2673 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12460, nodes: 9852977 
    Average node length: 5.43, total dup: 9412403, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2194245, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1362 
        40 - 59% = 8788 
        60 - 79% = 1711 
        80 - 99% = 577 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10133, nodes: 9852977 
    Average node length: 5.14, total dup: 9852877, max dup: 164452 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1640788, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1114 
        40 - 59% = 4873 
        60 - 79% = 1867 
        80 - 99% = 2234 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.63, total records: 576548 
    Average version length: 68.78, total versions: 5258, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3201 
    Empty pages: 3, full pages: 7479 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 55 
    60 - 79% = 7883 
    80 - 99% = 74 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45299, depth: 3, leaf buckets: 741, nodes: 576548 
    Average node length: 5.95, total dup: 490886, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101593, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 532 
        60 - 79% = 95 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35059, depth: 3, leaf buckets: 754, nodes: 576548 
    Average node length: 6.15, total dup: 472849, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101642, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 530 
        60 - 79% = 102 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 543, nodes: 576548 
    Average node length: 4.86, total dup: 576448, max dup: 9470 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90297, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 291 
        60 - 79% = 78 
        80 - 99% = 150 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 17 07:16:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7770892 79892 1 0.0000 0.0000
DOC_LIST 2257679 42389 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1095 3 200.0000 0.0000
INVNT_TURNOVER_LOG 125807 120488 1 0.0000 0.0000
MONEY_SALDO 49 132 4 200.0000 0.0000
MONEY_TURNOVER_LOG 2324 2167 1 0.0000 0.0000
PDISTR 831322 38512 2 0.0000 0.0000
PERF_SPLIT_0 170026 20453 1 0.0000 0.0000
PERF_SPLIT_1 153767 22349 1 0.0000 0.0000
PERF_SPLIT_2 197654 43643 1 0.0000 0.0000
PERF_SPLIT_3 165510 16328 1 0.0000 0.0000
PERF_SPLIT_4 170592 20432 1 0.0000 0.0000
PERF_SPLIT_5 168539 14002 1 0.0000 0.0000
PERF_SPLIT_6 189645 42028 1 0.0000 0.0000
PERF_SPLIT_7 188509 32333 1 0.0000 0.0000
PERF_SPLIT_8 166522 31352 1 0.0000 0.0000
PERF_SPLIT_9 168951 31214 1 0.0000 0.0000
PSTORNED 2096544 36013 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 171422 83635 1 0.0000 0.0000
XQD_1000_3300 7011383 491498 1 0.0000 0.0000
XQD_1200_2000 11965569 390635 1 0.0000 0.0000
XQD_2000_3300 1754570 476007 1 0.0000 0.0000
XQD_2100_3300 1309977 160948 1 0.0000 0.0000
XQD_3300_3400 9323986 411473 1 0.0000 0.0000
XQS_1000_1200 21103019 14537 1 0.0000 0.0000
XQS_1000_3300 9775379 411383 1 0.0000 0.0000
XQS_1200_2000 11450932 356610 1 0.0000 0.0000
XQS_2100_3300 9852977 373162 1 0.0000 0.0000
XQS_3300_3400 576548 5258 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sun Mar 17 07:14:45 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sun Mar 17 07:14:48 2024
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Sun Mar 17 07:14:51 2024
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:17: 
--- end of diff output ---

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

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