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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-03 16:09:43
DTS_END                         2024-03-03 16:09:43.2180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46546
TRN_ID                          176521
ATT_ID                          599
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: 9228.94 21117 922894
customer order: creation 178.84 367 17884
customer order: refuse 14.94 382 1494
order to supplier: creation 47.15 1375 4715
order to supplier: removal 3.36 98939 336
invoice (draft): creation 47.63 3266 4763
invoice (draft): removal 49.13 813 4913
invoice accept: apply 43.71 21420 4371
invoice accept: cancel 44.66 873 4466
customer reserve: creation 4140.29 207 414029
customer reserve: removal 4352.04 59 435204
realization accept: apply 85.73 197 8573
realization accept: cancel 87.34 133 8734
payment from customer: creation 60.41 136 6041
payment from customer: removal 5.76 97 576
payment to supplier: creation 51.54 180 5154
payment to supplier: removal 3.38 102 338
service: total inventory turnovers 4.56 1257 456
service: total monetary turnovers 7.66 41 766
service: aggregate perf. data 0.78 21130 78
service: refresh index statistics 0.03 271359 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-03-2024 16:12:19 to 03-03-2024 16:12:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5807
TEST_TIME 2 5367
TEST_TIME 3 4943
TEST_TIME 4 4473
TEST_TIME 5 4630
TEST_TIME 6 4572
TEST_TIME 7 4697
TEST_TIME 8 4642
TEST_TIME 9 4867
TEST_TIME 10 5131
TEST_TIME 11 5428
TEST_TIME 12 5642
TEST_TIME 13 6173
TEST_TIME 14 6512
TEST_TIME 15 7109
TEST_TIME 16 7081
TEST_TIME 17 6939
TEST_TIME 18 7063
TEST_TIME 19 7567
TEST_TIME 20 7670
TEST_TIME 21 8131
TEST_TIME 22 8090
TEST_TIME 23 8024
TEST_TIME 24 8515
TEST_TIME 25 8440
TEST_TIME 26 8365
TEST_TIME 27 8552
TEST_TIME 28 8601
TEST_TIME 29 8616
TEST_TIME 30 9435
TEST_TIME 31 9577
TEST_TIME 32 9343
TEST_TIME 33 9129
TEST_TIME 34 9436
TEST_TIME 35 9704
TEST_TIME 36 9698
TEST_TIME 37 9584
TEST_TIME 38 9506
TEST_TIME 39 9371
TEST_TIME 40 9614
TEST_TIME 41 9539
TEST_TIME 42 9357
TEST_TIME 43 9323
TEST_TIME 44 9369
TEST_TIME 45 9215
TEST_TIME 46 9277
TEST_TIME 47 9226
TEST_TIME 48 9183
TEST_TIME 49 9197
TEST_TIME 50 9281
TEST_TIME 51 9156
TEST_TIME 52 9200
TEST_TIME 53 9069
TEST_TIME 54 9035
TEST_TIME 55 9070
TEST_TIME 56 9291
TEST_TIME 57 9266
TEST_TIME 58 9381
TEST_TIME 59 9361
TEST_TIME 60 9329
TEST_TIME 61 9374
TEST_TIME 62 9361
TEST_TIME 63 9402
TEST_TIME 64 9483
TEST_TIME 65 9457
TEST_TIME 66 9493
TEST_TIME 67 9480
TEST_TIME 68 9456
TEST_TIME 69 9345
TEST_TIME 70 9318
TEST_TIME 71 9329
TEST_TIME 72 9255
TEST_TIME 73 9251
TEST_TIME 74 9266
TEST_TIME 75 9188
TEST_TIME 76 9262
TEST_TIME 77 9197
TEST_TIME 78 9206
TEST_TIME 79 9202
TEST_TIME 80 9168
TEST_TIME 81 9114
TEST_TIME 82 9039
TEST_TIME 83 9062
TEST_TIME 84 9079
TEST_TIME 85 9092
TEST_TIME 86 9138
TEST_TIME 87 9126
TEST_TIME 88 9181
TEST_TIME 89 9191
TEST_TIME 90 9241
TEST_TIME 91 9302
TEST_TIME 92 9290
TEST_TIME 93 9316
TEST_TIME 94 9298
TEST_TIME 95 9353
TEST_TIME 96 9397
TEST_TIME 97 9378
TEST_TIME 98 9298
TEST_TIME 99 9278
TEST_TIME 100 9234

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-03-2024 16:12:23 to 03-03-2024 16:12:26.

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 1299842 1299842 0 0.00 0 21124 8 0 0
doc_list_biud 1299842 1299842 0 0.00 0 24861 26 0 0
sp_add_invoice_to_stock 4467 4371 96 2.14 58 174382 21420 0 96
sp_cancel_adding_invoice 4466 4466 0 0.00 4 40898 874 0 0
sp_cancel_client_order 1494 1494 0 0.00 4 8191 383 0 0
sp_cancel_customer_reserve 435204 435204 0 0.00 0 24863 59 0 0
sp_cancel_pay_from_customer 576 576 0 0.00 3 3455 97 0 0
sp_cancel_pay_to_supplier 338 338 0 0.00 2 7282 102 0 0
sp_cancel_supplier_invoice 4919 4913 6 0.12 1 14743 813 0 6
sp_cancel_supplier_order 336 336 0 0.00 5 882407 98939 0 0
sp_cancel_write_off 8734 8734 0 0.00 1 18072 133 0 0
sp_client_order 17884 17884 0 0.00 3 21467 367 0 0
sp_customer_reserve 414029 414029 0 0.00 0 96618 208 0 0
sp_fill_shopping_cart 27357 27357 0 0.00 1 25821 36 0 0
sp_fill_shopping_cart_clo_res 414023 414023 0 0.00 0 14965 15 0 0
sp_get_clo_for_invoice 4365 4365 0 0.00 0 20133 340 0 0
sp_kill_cost_storno 14114 14114 0 0.00 0 9987 68 0 0
sp_kill_qstorno_ret_qs2qd 884391 884391 0 0.00 0 24838 32 0 0
sp_kill_qty_storno 468085 468085 0 0.00 0 24861 71 0 0
sp_lock_selected_doc 17763 17763 0 0.00 0 7312 4 0 0
sp_make_cost_storno 24133 24133 0 0.00 0 16346 74 0 0
sp_multiply_rows_for_pdistr 24133 24133 0 0.00 0 13502 34 0 0
sp_multiply_rows_for_qdistr 17884 17884 0 0.00 0 21342 180 0 0
sp_pay_from_customer 6041 6041 0 0.00 4 16358 137 0 0
sp_pay_to_supplier 5154 5154 0 0.00 4 18719 180 0 0
sp_payment_common 11195 11195 0 0.00 1 14513 48 0 0
sp_qd_handle_on_cancel_clo 1494 1494 0 0.00 0 8186 344 0 0
sp_qd_handle_on_invoice_upd_sts 8831 8831 0 0.00 0 15302 357 0 0
sp_qd_handle_on_reserve_upd_sts 8573 8573 0 0.00 0 13554 55 0 0
sp_reserve_write_off 8573 8573 0 0.00 5 17145 197 0 0
sp_supplier_invoice 4763 4763 0 0.00 6 60284 3267 0 0
sp_supplier_order 4715 4715 0 0.00 5 39759 1376 0 0
srv_aggregate_perf_data 79 78 1 1.26 2191 446831 21130 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 950 155957 37051 0 0
srv_find_qd_qs_mism 877911 877911 0 0.00 0 21122 7 0 0
srv_make_invnt_saldo 456 456 0 0.00 69 44128 1258 0 0
srv_make_money_saldo 766 766 0 0.00 1 2083 42 0 0
srv_recalc_idx_stat 3 3 0 0.00 198047 391839 271359 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4372 4372 0 0.00 0 37035 196 0 0
t$perf-norm:sp_cancel_adding_invoice 351 351 0 0.00 0 8145 134 0 0
t$perf-norm:sp_cancel_client_order 1494 1494 0 0.00 0 3816 18 0 0
t$perf-norm:sp_cancel_customer_reserve 566 566 0 0.00 0 1161 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 576 576 0 0.00 0 1217 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 338 338 0 0.00 0 14060 52 0 0
t$perf-norm:sp_cancel_supplier_invoice 318 318 0 0.00 0 6457 68 0 0
t$perf-norm:sp_cancel_supplier_order 336 336 0 0.00 0 25591 1660 0 0
t$perf-norm:sp_cancel_write_off 849 849 0 0.00 0 1100 6 0 0
t$perf-norm:sp_client_order 17884 17884 0 0.00 0 21122 22 0 0
t$perf-norm:sp_customer_reserve 850 850 0 0.00 0 6847 22 0 0
t$perf-norm:sp_pay_from_customer 6041 6041 0 0.00 0 6704 11 0 0
t$perf-norm:sp_pay_to_supplier 5154 5154 0 0.00 0 3298 10 0 0
t$perf-norm:sp_reserve_write_off 8573 8573 0 0.00 0 16992 13 0 0
t$perf-norm:sp_supplier_invoice 4763 4763 0 0.00 0 11010 21 0 0
t$perf-norm:sp_supplier_order 4715 4715 0 0.00 0 4478 20 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 162 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 236 5 0 0
t$perf-norm:srv_make_invnt_saldo 456 456 0 0.00 0 1782 33 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 1985 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 6 4 0 0
v_add_invoice_to_stock 8916 8724 192 2.15 0 9234 20 0 192
v_all_customers 33028 33028 0 0.00 0 20 1 0 0
v_all_suppliers 26746 26746 0 0.00 0 26 1 0 0
v_all_wares 35768 35768 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 702 702 0 0.00 0 1445 8 0 0
v_cancel_client_order 2988 2988 0 0.00 0 5677 9 0 0
v_cancel_customer_prepayment 1152 1152 0 0.00 0 3431 14 0 0
v_cancel_customer_reserve 1132 1132 0 0.00 0 5830 12 0 0
v_cancel_payment_to_supplier 676 676 0 0.00 0 2891 8 0 0
v_cancel_supplier_invoice 648 636 12 1.85 0 4419 24 0 12
v_cancel_supplier_order 672 672 0 0.00 0 2804 8 0 0
v_cancel_write_off 1698 1698 0 0.00 0 4400 21 0 0
v_max_id_clo_ord 4712 4712 0 0.00 0 941 2 0 0
v_max_id_clo_res 850 850 0 0.00 0 2933 15 0 0
v_max_id_ord_sup 4761 4761 0 0.00 0 3395 4 0 0
v_max_non_paid_invoice 1254 1254 0 0.00 0 3718 6 0 0
v_max_non_paid_realizn 2961 2961 0 0.00 0 1355 4 0 0
v_min_id_clo_ord 4712 4712 0 0.00 0 9970 11 0 0
v_min_id_clo_res 850 850 0 0.00 0 2177 4 0 0
v_min_id_ord_sup 4761 4761 0 0.00 0 2324 4 0 0
v_min_non_paid_invoice 5154 5154 0 0.00 0 14469 44 0 0
v_min_non_paid_realizn 6041 6041 0 0.00 0 14382 36 0 0
v_our_firm 8900 8900 0 0.00 0 18 1 0 0
v_reserve_write_off 17146 17146 0 0.00 0 9768 10 0 0
x_lock_depdocs_on_canc_invoice 9061 9061 0 0.00 0 12565 128 0 0
x_lock_depdocs_on_canc_sup_ord 336 336 0 0.00 0 4488 328 0 0
x_make_qstorno_1000_1200 4715 4715 0 0.00 1 39743 1274 0 0
x_make_qstorno_1200_2000 4763 4763 0 0.00 3 60167 3159 0 0
x_make_qstorno_2100_3300 414029 414029 0 0.00 0 96613 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-03-2024 16:12:27 to 03-03-2024 16:12:31.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:47 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:48 30807 8192000000 9889586928 10197663744 970502080 10.592 100 89 178 0 1000671728 6341088 23828560
14:12:24 13896 8192000000 9943227024 10265190400 1029055488 11.159 100 88 176 0 1061039696 8636032 23348176
14:13:49 15014 8192000000 9982396160 10310307840 1060517344 11.461 100 90 180 0 1092700688 9369088 22814256
14:15:08 10372 8192000000 10016740816 10358751232 1101628048 11.853 100 85 170 0 1131879632 9774496 20477088
14:16:24 6092 8192000000 10056384144 10407718912 1143788304 12.251 100 80 160 0 1174222768 11986992 18447472
14:17:35 3594 8192000000 10103944528 10465251328 1190215984 12.685 100 87 174 0 1223142400 12272480 20653936
14:18:45 2980 8192000000 10150637856 10523070464 1236755568 13.116 100 77 154 0 1265663616 12225280 16682768
14:19:49 1139 8192000000 10180184320 10560827392 1264528368 13.372 100 92 180 0 1298379136 13394208 20456560
14:20:53 982 8192000000 10202151984 10585751552 1288101712 13.587 100 87 170 0 1320020944 12851152 19068080
14:21:55 29799 8192000000 10184543440 10592800768 1295244880 13.652 100 50 100 0 1314859072 7792656 11821536
14:23:31 6920 8192000000 10187877248 10599985152 1303920768 13.731 100 20 38 0 1315038384 6496144 4621472
14:24:42 5976 8192000000 10196152160 10609545216 1309869984 13.785 100 25 50 3 1321908352 6535440 5502928
14:25:51 13264 8192000000 10202122464 10621870080 1321018592 13.886 100 15 30 0 1329587216 5560000 3008624
14:27:07 38739 8192000000 10211354720 10632384512 1325347008 13.925 100 36 69 2 1337525664 4853520 7325136
14:28:46 5701 8192000000 10225438864 10639790080 1328583776 13.954 100 28 56 0 1340586688 5122400 6880512
14:29:56 2342 8192000000 10224372272 10629144576 1317959776 13.858 99 53 106 0 1336595616 6018976 12616864
14:31:02 33003 8192000000 10237797760 10645909504 1321141344 13.887 99 46 90 0 1340977456 9846624 9989488
14:32:53 63930 8192000000 10243188384 10658066432 1330909520 13.975 100 44 88 1 1355242544 14422944 9910080
14:35:01 25919 8192000000 10258283840 10673651712 1349099136 14.139 100 41 80 0 1373126400 15152928 8874336
14:36:30 18677 8192000000 10252961728 10659848192 1337579536 14.036 100 46 93 0 1364077664 15911680 10586448
14:37:53 6545 8192000000 10252219808 10653786112 1314414368 13.826 98 58 116 2 1347015904 19020672 13580864
14:39:06 19585 8192000000 10220952192 10619289600 1267751904 13.401 96 50 100 0 1299015408 19326688 11936816
14:40:30 18646 8192000000 10224206544 10626826240 1292714880 13.629 99 49 97 0 1327660176 23181040 11764256
14:42:07 1416 8192000000 10213429376 10607185920 1284174208 13.551 99 68 130 2 1323191888 23501552 15516128
14:43:11 10711 8192000000 10256282208 10658660352 1325994192 13.931 100 65 124 1 1368560208 26758704 15807312
14:44:33 949 8192000000 10248415232 10640146432 1311539168 13.800 98 89 176 0 1348531776 15062560 21930048
14:45:38 5878 8192000000 10263924816 10672590848 1343350800 14.088 100 53 104 0 1373649552 17260960 13037792
14:46:57 7782 8192000000 10278737248 10683383808 1347563712 14.126 100 63 125 0 1385981040 23491744 14925584
14:48:11 7033 8192000000 10288573584 10690740224 1343520048 14.089 99 61 120 1 1383340624 24235712 15584864
14:49:24 1350 8192000000 10312413936 10714083328 1369719920 14.325 100 83 165 0 1416684704 25905680 21059104
14:50:31 9551 8192000000 10299183680 10723487744 1373419152 14.358 100 46 92 0 1407547392 23394624 10733616
14:51:49 8715 8192000000 10320278304 10740359168 1391309824 14.518 100 49 98 0 1431481344 27881248 12290272
14:53:04 3504 8192000000 10354919296 10763083776 1402889840 14.621 100 75 150 0 1462322160 41137376 18294944
14:54:10 41143 8192000000 10334815376 10768531456 1405036400 14.640 100 24 48 0 1443325216 31569408 6719408
14:55:54 28936 8192000000 10329318400 10771611648 1402000816 14.613 100 32 64 0 1441534496 31705392 7828288
14:57:28 4668 8192000000 10341670400 10774331392 1404162976 14.632 100 33 67 0 1446358992 34226224 7969792
14:58:41 21246 8192000000 10326118608 10775425024 1393470976 14.537 100 15 30 1 1438872752 40972896 4428880
15:00:07 28325 8192000000 10318415152 10775842816 1386260416 14.472 100 12 24 0 1424878528 35815808 2802304
15:01:37 59103 8192000000 10337104688 10765463552 1386137888 14.471 99 33 63 1 1416949120 23307200 7504032
15:03:40 37941 8192000000 10312963664 10766442496 1396202112 14.561 99 14 28 0 1416860704 17050720 3607872
15:05:19 39565 8192000000 10310068144 10768510976 1403161824 14.623 100 7 14 1 1416930720 11671840 2097056
15:07:17 30504 8192000000 10334715632 10777653248 1394641760 14.547 98 36 70 2 1415850768 12622144 8586864
15:08:48 29363 8192000000 10317524752 10757607424 1372391184 14.348 98 36 72 0 1398834784 17641712 8801888
15:10:47 92996 8192000000 10310764144 10747764736 1379323840 14.411 99 34 64 1 1398836352 12217040 7295472
15:13:28 92876 8192000000 10298058480 10724265984 1298031952 13.677 93 65 127 2 1322601040 9823776 14745312
15:16:02 11983 8192000000 10307649584 10748137472 1374012880 14.363 99 40 80 0 1399182016 15022128 10147008
15:17:19 23991 8192000000 10284159232 10731499520 1346005824 14.112 97 22 44 0 1368765520 17463584 5296112
15:18:56 24178 8192000000 10304279568 10755317760 1384818608 14.460 100 13 22 1 1411429984 23600800 3010576
15:20:23 62135 8192000000 10305656224 10751025152 1357509776 14.215 97 19 38 0 1381726752 19643952 4573024
15:22:33 30854 8192000000 10303256256 10749181952 1377974592 14.398 99 33 63 1 1404926880 19606992 7345296
15:24:13 45179 8192000000 10272594912 10717638656 1345065168 14.103 98 25 50 0 1375132400 24056512 6010720
15:26:02 61912 8192000000 10272737712 10717609984 1304318560 13.734 96 17 34 0 1329837872 21300496 4218816
15:28:06 34065 8192000000 10247307728 10688548864 1299194736 13.688 96 34 69 1 1316159408 8735248 8229424
15:29:41 28862 8192000000 10265354080 10692124672 1330176560 13.969 99 30 60 1 1348784976 11716992 6891424
15:31:12 50523 8192000000 10254502928 10691006464 1305906000 13.749 97 23 46 0 1326309296 15444000 4959296
15:33:36 155957 8192000000 10260574272 10711851008 1252197280 13.258 93 20 39 0 1276886016 20454144 4234592
15:37:12 80538 8192000000 10247761760 10684899328 1321538576 13.891 98 23 46 1 1339164496 12530752 5095168
15:39:51 56376 8192000000 10266033584 10706128896 1325801552 13.929 98 22 42 0 1343605024 12939600 4863872
15:42:58 8345 8192000000 10298710800 10733793280 1378937264 14.407 100 57 112 1 1403774544 11698448 13138832
15:44:20 53231 8192000000 10283635632 10756288512 1375952352 14.380 100 10 21 0 1403800224 25196832 2651040
15:46:51 57106 8192000000 10281364448 10750427136 1386093200 14.471 100 12 24 1 1406173536 16911808 3168528
15:48:57 44771 8192000000 10281642816 10740678656 1375866832 14.380 99 23 45 1 1388783984 7850304 5066848
15:50:52 65881 8192000000 10290850560 10754457600 1396720960 14.566 100 10 20 0 1409861856 10977424 2163472
15:53:03 51991 8192000000 10282868064 10741551104 1356152576 14.203 97 11 22 0 1367086480 8577232 2356672
15:55:06 45796 8192000000 10292916320 10750255104 1379548752 14.413 99 13 26 0 1390796496 8540528 2707216
15:56:52 42365 8192000000 10306602128 10760445952 1384140400 14.454 99 23 47 0 1400744160 11453600 5150160
15:58:46 88522 8192000000 10300580048 10774917120 1362749792 14.262 97 10 20 0 1379540976 14365600 2425584
16:01:20 39908 8192000000 10318569888 10764013568 1384695104 14.459 99 26 52 0 1399295152 8864592 5735456
16:03:02 32479 8192000000 10281654416 10725519360 1314085488 13.823 95 35 69 0 1331965760 10514848 7365424
16:04:37 133627 8192000000 10255467552 10719760384 1276057520 13.477 93 7 14 0 1292563248 15268432 1237296
16:08:24 7707 8192000000 10267015584 10715422720 1339836592 14.056 98 27 54 1 1355091072 8676352 6578128
16:09:33 21197 8192000000 9374989600 9675677696 528301472 6.058 40 2 4 0 536520336 8123376 95488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 03-03-2024 16:12:33 to 03-03-2024 16:12:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 96 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-03-2024 16:12:48 to 03-03-2024 16:12:50.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar  3 16:12:51 2024 
 
Database header page information: 
    Flags            0 
    Generation        92282 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176050 
    Oldest active        176872 
    Oldest snapshot        176872 
    Next transaction    176873 
    Sequence number        0 
    Next attachment ID    715 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.71, total records: 7720859 
    Average version length: 48.16, total versions: 29036, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87288 
    Data pages: 87288, average fill: 71% 
    Primary pages: 87288, secondary pages: 0, swept pages: 39429 
    Empty pages: 9, full pages: 52387 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 308 
    40 - 59% = 3995 
    60 - 79% = 82944 
    80 - 99% = 9 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23290, nodes: 7720859 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1704481, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 315 
        20 - 39% = 1958 
        40 - 59% = 4070 
        60 - 79% = 2510 
        80 - 99% = 14437 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13511, nodes: 7720859 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1527298, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1656 
        40 - 59% = 1956 
        60 - 79% = 1164 
        80 - 99% = 8735 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8360, nodes: 7720859 
    Average node length: 6.61, total dup: 5781065, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1520274, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 1022 
        40 - 59% = 1362 
        60 - 79% = 995 
        80 - 99% = 4848 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 57.05, total records: 2230691 
    Average version length: 34.73, total versions: 29604, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28680 
    Data pages: 28680, average fill: 72% 
    Primary pages: 28675, secondary pages: 5, swept pages: 19544 
    Empty pages: 7, full pages: 17068 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 159 
    40 - 59% = 2439 
    60 - 79% = 25860 
    80 - 99% = 192 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4579, nodes: 2230691 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 683094, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 988 
        40 - 59% = 825 
        60 - 79% = 738 
        80 - 99% = 2028 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2522, nodes: 2232073 
    Average node length: 4.97, total dup: 2231174, max dup: 20315 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1241935, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 289 
        40 - 59% = 1520 
        60 - 79% = 531 
        80 - 99% = 180 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2044, nodes: 2230691 
    Average node length: 4.97, total dup: 2230641, max dup: 130390 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061058, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 212 
        40 - 59% = 932 
        60 - 79% = 51 
        80 - 99% = 845 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4342, nodes: 2230691 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 683094, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 632 
        40 - 59% = 579 
        60 - 79% = 870 
        80 - 99% = 2165 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.57, total records: 400 
    Average version length: 23.00, total versions: 231333, max versions: 601 
    Average fragment length: 2.00, total fragments: 43, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1272 
    Data pages: 1272, average fill: 90% 
    Primary pages: 9, secondary pages: 1263, swept pages: 0 
    Empty pages: 2, full pages: 1269 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1269 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 14.04, total records: 87581 
    Average version length: 68.29, total versions: 69581, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.27 
    Pointer pages: 8, data page slots: 2720 
    Data pages: 1568, average fill: 69% 
    Primary pages: 1567, secondary pages: 1, swept pages: 76 
    Empty pages: 114, full pages: 1038 
    Fill distribution: 
     0 - 19% = 195 
    20 - 39% = 113 
    40 - 59% = 148 
    60 - 79% = 260 
    80 - 99% = 852 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705487, depth: 3, leaf buckets: 380, nodes: 87581 
    Average node length: 13.24, total dup: 7317, max dup: 1 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 62416, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 254 
        40 - 59% = 118 
        60 - 79% = 8 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18435, max versions: 1029 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.31, total records: 1770 
    Average version length: 43.47, total versions: 1522, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 9.20 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 57% 
    Primary pages: 28, secondary pages: 2, swept pages: 0 
    Empty pages: 3, full pages: 15 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90840, depth: 2, leaf buckets: 2, nodes: 1770 
    Average node length: 4.25, total dup: 1672, max dup: 194 
    Average key length: 2.59, compression ratio: 7.35 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 904, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.69, total records: 802757 
    Average version length: 25.83, total versions: 43978, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 5, data page slots: 8104 
    Data pages: 8104, average fill: 69% 
    Primary pages: 8086, secondary pages: 18, swept pages: 3263 
    Empty pages: 27, full pages: 5126 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 70 
    40 - 59% = 451 
    60 - 79% = 7389 
    80 - 99% = 141 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 900, nodes: 802757 
    Average node length: 4.87, total dup: 802708, max dup: 143933 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89869, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 120 
        40 - 59% = 539 
        60 - 79% = 193 
        80 - 99% = 47 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 968, nodes: 802757 
    Average node length: 5.88, total dup: 714720, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160403, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 126 
        40 - 59% = 445 
        60 - 79% = 146 
        80 - 99% = 250 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1024, nodes: 802757 
    Average node length: 5.88, total dup: 714720, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162345, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 228 
        40 - 59% = 430 
        60 - 79% = 114 
        80 - 99% = 252 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1161, nodes: 802757 
    Average node length: 5.96, total dup: 714720, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155425, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 275 
        40 - 59% = 593 
        60 - 79% = 201 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5406 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.38, total fragments: 42, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 70, secondary pages: 18, swept pages: 60 
    Empty pages: 8, full pages: 62 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5406 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.32, average data length: 1.55 
    Clustering factor: 4990, ratio: 0.92 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5406 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 141, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 80814 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 778 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34635, depth: 2, leaf buckets: 102, nodes: 80814 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3340, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 142.37, total records: 191115 
    Average version length: 153.33, total versions: 11300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 6, data page slots: 6360 
    Data pages: 4648, average fill: 85% 
    Primary pages: 4648, secondary pages: 0, swept pages: 75 
    Empty pages: 87, full pages: 4522 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 16 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4522 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 133.39, total records: 204853 
    Average version length: 153.89, total versions: 24026, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.71 
    Pointer pages: 8, data page slots: 5600 
    Data pages: 4936, average fill: 87% 
    Primary pages: 4936, secondary pages: 0, swept pages: 60 
    Empty pages: 58, full pages: 4858 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 4858 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 144.05, total records: 164053 
    Average version length: 151.42, total versions: 7402, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 5616 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3967, secondary pages: 1, swept pages: 73 
    Empty pages: 71, full pages: 3873 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3871 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 135.07, total records: 186612 
    Average version length: 153.76, total versions: 19582, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.56 
    Pointer pages: 7, data page slots: 5280 
    Data pages: 4544, average fill: 85% 
    Primary pages: 4544, secondary pages: 0, swept pages: 101 
    Empty pages: 105, full pages: 4418 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 4418 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 133.06, total records: 158080 
    Average version length: 153.63, total versions: 18618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.75 
    Pointer pages: 8, data page slots: 5112 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3807, secondary pages: 1, swept pages: 34 
    Empty pages: 48, full pages: 3738 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 3737 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.00, total records: 177362 
    Average version length: 151.57, total versions: 7001, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 10, data page slots: 5496 
    Data pages: 4256, average fill: 86% 
    Primary pages: 4256, secondary pages: 0, swept pages: 44 
    Empty pages: 47, full pages: 4193 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4194 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 122.86, total records: 201554 
    Average version length: 154.39, total versions: 37538, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.80 
    Pointer pages: 7, data page slots: 5488 
    Data pages: 4864, average fill: 87% 
    Primary pages: 4863, secondary pages: 1, swept pages: 63 
    Empty pages: 58, full pages: 4781 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4782 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 142.43, total records: 162287 
    Average version length: 151.55, total versions: 9067, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 5304 
    Data pages: 3888, average fill: 86% 
    Primary pages: 3888, secondary pages: 0, swept pages: 31 
    Empty pages: 38, full pages: 3833 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3834 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 143.95, total records: 163923 
    Average version length: 151.45, total versions: 7300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 6104 
    Data pages: 3960, average fill: 85% 
    Primary pages: 3960, secondary pages: 0, swept pages: 71 
    Empty pages: 71, full pages: 3868 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3869 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 131.05, total records: 190852 
    Average version length: 153.98, total versions: 25048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.94 
    Pointer pages: 7, data page slots: 5784 
    Data pages: 4600, average fill: 87% 
    Primary pages: 4600, secondary pages: 0, swept pages: 72 
    Empty pages: 62, full pages: 4513 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4515 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.35, total records: 2075326 
    Average version length: 52.88, total versions: 15613, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25560, average fill: 70% 
    Primary pages: 25560, secondary pages: 0, swept pages: 13080 
    Empty pages: 342, full pages: 19404 
    Fill distribution: 
     0 - 19% = 633 
    20 - 39% = 591 
    40 - 59% = 1422 
    60 - 79% = 22794 
    80 - 99% = 120 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2605, nodes: 2075326 
    Average node length: 5.44, total dup: 1936095, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180414, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 336 
        40 - 59% = 1696 
        60 - 79% = 299 
        80 - 99% = 269 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2075326 
    Average node length: 5.70, total dup: 1861801, max dup: 63 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371436, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2457 
        60 - 79% = 277 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2171, nodes: 2075326 
    Average node length: 4.96, total dup: 2075226, max dup: 28835 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178339, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 251 
        40 - 59% = 1174 
        60 - 79% = 370 
        80 - 99% = 376 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 46.35, total records: 143986 
    Average version length: 69.16, total versions: 47552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.72 
    Pointer pages: 3, data page slots: 4752 
    Data pages: 3440, average fill: 48% 
    Primary pages: 3440, secondary pages: 0, swept pages: 762 
    Empty pages: 715, full pages: 1008 
    Fill distribution: 
     0 - 19% = 930 
    20 - 39% = 209 
    40 - 59% = 695 
    60 - 79% = 999 
    80 - 99% = 607 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101204, depth: 3, leaf buckets: 242, nodes: 143986 
    Average node length: 6.52, total dup: 125196, max dup: 14 
    Average key length: 3.96, compression ratio: 10.60 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 24362, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 69 
        40 - 59% = 126 
        60 - 79% = 43 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.52, total records: 6875466 
    Average version length: 68.75, total versions: 242996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 63, data page slots: 101280 
    Data pages: 101280, average fill: 72% 
    Primary pages: 101280, secondary pages: 0, swept pages: 52765 
    Empty pages: 24, full pages: 59237 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 253 
    40 - 59% = 6216 
    60 - 79% = 92035 
    80 - 99% = 2744 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10679, nodes: 6875466 
    Average node length: 6.51, total dup: 5947268, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1517844, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1956 
        40 - 59% = 5830 
        60 - 79% = 2498 
        80 - 99% = 385 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8545, nodes: 6875466 
    Average node length: 5.40, total dup: 6598671, max dup: 185 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1326737, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1451 
        40 - 59% = 4704 
        60 - 79% = 1501 
        80 - 99% = 881 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8620, nodes: 6875466 
    Average node length: 5.40, total dup: 6598671, max dup: 185 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1329252, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1527 
        40 - 59% = 4733 
        60 - 79% = 1474 
        80 - 99% = 879 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.04, total records: 11806492 
    Average version length: 68.75, total versions: 156704, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 103, data page slots: 167040 
    Data pages: 167040, average fill: 75% 
    Primary pages: 167040, secondary pages: 0, swept pages: 111533 
    Empty pages: 4, full pages: 133221 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 250 
    40 - 59% = 4401 
    60 - 79% = 160441 
    80 - 99% = 1935 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18275, nodes: 11806492 
    Average node length: 6.58, total dup: 10290708, max dup: 65 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2331277, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2741 
        40 - 59% = 10551 
        60 - 79% = 4238 
        80 - 99% = 715 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 48.36, total records: 1434477 
    Average version length: 69.11, total versions: 431404, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.61 
    Pointer pages: 30, data page slots: 47400 
    Data pages: 29112, average fill: 56% 
    Primary pages: 29112, secondary pages: 0, swept pages: 12560 
    Empty pages: 4390, full pages: 15198 
    Fill distribution: 
     0 - 19% = 6633 
    20 - 39% = 2571 
    40 - 59% = 2616 
    60 - 79% = 10755 
    80 - 99% = 6537 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2264, nodes: 1434477 
    Average node length: 5.52, total dup: 1376271, max dup: 99 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 96095, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 961 
        40 - 59% = 1030 
        60 - 79% = 239 
        80 - 99% = 18 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 47.98, total records: 940510 
    Average version length: 69.14, total versions: 286749, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.63 
    Pointer pages: 20, data page slots: 32328 
    Data pages: 28480, average fill: 38% 
    Primary pages: 28480, secondary pages: 0, swept pages: 11629 
    Empty pages: 5876, full pages: 4563 
    Fill distribution: 
     0 - 19% = 9910 
    20 - 39% = 4340 
    40 - 59% = 6213 
    60 - 79% = 5178 
    80 - 99% = 2839 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1545, nodes: 940510 
    Average node length: 5.75, total dup: 880312, max dup: 99 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 124145, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 714 
        40 - 59% = 607 
        60 - 79% = 193 
        80 - 99% = 26 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.07, total records: 9089810 
    Average version length: 68.95, total versions: 240767, 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: 90, data page slots: 145552 
    Data pages: 145552, average fill: 67% 
    Primary pages: 145552, secondary pages: 0, swept pages: 87744 
    Empty pages: 342, full pages: 68338 
    Fill distribution: 
     0 - 19% = 1276 
    20 - 39% = 7372 
    40 - 59% = 28654 
    60 - 79% = 105264 
    80 - 99% = 2986 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13544, nodes: 9089810 
    Average node length: 6.69, total dup: 7540756, max dup: 17 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1943650, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1480 
        40 - 59% = 7033 
        60 - 79% = 4406 
        80 - 99% = 621 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21150782 
    Average version length: 82.78, total versions: 5399, 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: 318824 
    Data pages: 318824, average fill: 81% 
    Primary pages: 318824, secondary pages: 0, swept pages: 13427 
    Empty pages: 30, full pages: 317988 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 43 
    40 - 59% = 101 
    60 - 79% = 27964 
    80 - 99% = 290664 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19395, nodes: 21150782 
    Average node length: 5.72, total dup: 20669552, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281551, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8168 
        60 - 79% = 537 
        80 - 99% = 10684 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17168, nodes: 21150782 
    Average node length: 6.31, total dup: 18587362, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915035, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 748 
        60 - 79% = 290 
        80 - 99% = 16122 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21159, nodes: 21150782 
    Average node length: 6.35, total dup: 18506042, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575795, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8389 
        60 - 79% = 598 
        80 - 99% = 12166 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16056, nodes: 21150782 
    Average node length: 5.56, total dup: 21150682, max dup: 232302 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943924, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 14 
        40 - 59% = 2782 
        60 - 79% = 381 
        80 - 99% = 12877 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.60, total records: 9512141 
    Average version length: 82.58, total versions: 210098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 173768 
    Data pages: 173704, average fill: 68% 
    Primary pages: 173704, secondary pages: 0, swept pages: 110665 
    Empty pages: 845, full pages: 87629 
    Fill distribution: 
     0 - 19% = 2598 
    20 - 39% = 10495 
    40 - 59% = 33005 
    60 - 79% = 77879 
    80 - 99% = 49727 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11409, nodes: 9512141 
    Average node length: 5.39, total dup: 9203592, max dup: 174 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2075760, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 94 
        40 - 59% = 8668 
        60 - 79% = 2564 
        80 - 99% = 81 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13509, nodes: 9512141 
    Average node length: 6.26, total dup: 7885920, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1424493, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 138 
        20 - 39% = 4087 
        40 - 59% = 4377 
        60 - 79% = 2632 
        80 - 99% = 2275 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12729, nodes: 9512141 
    Average node length: 6.01, total dup: 8247543, max dup: 35 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2260492, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 97 
        40 - 59% = 9706 
        60 - 79% = 2823 
        80 - 99% = 101 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10083, nodes: 9512141 
    Average node length: 5.16, total dup: 9512041, max dup: 162237 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1462137, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1349 
        40 - 59% = 5045 
        60 - 79% = 1603 
        80 - 99% = 2041 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.84, total records: 11273543 
    Average version length: 82.50, total versions: 201100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193560 
    Data pages: 192224, average fill: 72% 
    Primary pages: 192224, secondary pages: 0, swept pages: 80858 
    Empty pages: 3361, full pages: 138384 
    Fill distribution: 
     0 - 19% = 5778 
    20 - 39% = 8183 
    40 - 59% = 19609 
    60 - 79% = 46483 
    80 - 99% = 112171 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13158, nodes: 11273543 
    Average node length: 5.31, total dup: 11163528, max dup: 679 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2350629, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 205 
        40 - 59% = 9166 
        60 - 79% = 3613 
        80 - 99% = 172 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10452, nodes: 11273543 
    Average node length: 5.50, total dup: 10780875, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 711667, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 858 
        40 - 59% = 2559 
        60 - 79% = 1933 
        80 - 99% = 4954 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15038, nodes: 11273543 
    Average node length: 6.03, total dup: 9834204, max dup: 75 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2367037, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 242 
        40 - 59% = 10613 
        60 - 79% = 3962 
        80 - 99% = 219 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10710, nodes: 11273543 
    Average node length: 5.23, total dup: 11273443, max dup: 203366 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 700584, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 870 
        40 - 59% = 4663 
        60 - 79% = 1502 
        80 - 99% = 3588 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 81.09, total records: 9607434 
    Average version length: 82.92, total versions: 191825, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 109, data page slots: 176880 
    Data pages: 176808, average fill: 67% 
    Primary pages: 176808, secondary pages: 0, swept pages: 119313 
    Empty pages: 761, full pages: 85893 
    Fill distribution: 
     0 - 19% = 2501 
    20 - 39% = 10775 
    40 - 59% = 35353 
    60 - 79% = 78976 
    80 - 99% = 49203 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11834, nodes: 9607434 
    Average node length: 5.20, total dup: 9578430, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1855274, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1652 
        40 - 59% = 7866 
        60 - 79% = 1749 
        80 - 99% = 537 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13582, nodes: 9607434 
    Average node length: 6.27, total dup: 7963488, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1377131, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 4047 
        40 - 59% = 4316 
        60 - 79% = 2691 
        80 - 99% = 2367 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12438, nodes: 9607434 
    Average node length: 5.46, total dup: 9172291, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1987900, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1544 
        40 - 59% = 8759 
        60 - 79% = 1596 
        80 - 99% = 515 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10153, nodes: 9607434 
    Average node length: 5.17, total dup: 9607334, max dup: 165292 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1466055, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1358 
        40 - 59% = 5071 
        60 - 79% = 1570 
        80 - 99% = 2119 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.78, total records: 569743 
    Average version length: 68.75, total versions: 3177, 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: 8064 
    Data pages: 8064, average fill: 74% 
    Primary pages: 8064, secondary pages: 0, swept pages: 4784 
    Empty pages: 5, full pages: 6134 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 39 
    40 - 59% = 435 
    60 - 79% = 7550 
    80 - 99% = 35 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40079, depth: 3, leaf buckets: 736, nodes: 569743 
    Average node length: 5.95, total dup: 485113, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 98773, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 523 
        60 - 79% = 96 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31887, depth: 3, leaf buckets: 762, nodes: 569743 
    Average node length: 6.15, total dup: 467186, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 98820, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 552 
        60 - 79% = 84 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 578, nodes: 569743 
    Average node length: 4.86, total dup: 569643, max dup: 9607 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87841, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 334 
        60 - 79% = 93 
        80 - 99% = 109 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar  3 16:13:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7720859 29036 1 0.0000 0.0000
DOC_LIST 2230691 29604 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 231333 601 57800.0000 0.0000
INVNT_TURNOVER_LOG 87581 69581 1 0.0000 0.0000
MONEY_SALDO 49 18435 1029 37600.0000 0.0000
MONEY_TURNOVER_LOG 1770 1522 1 0.0000 0.0000
PDISTR 802757 43978 4 0.0000 0.0000
PERF_SPLIT_0 191115 11300 1 0.0000 0.0000
PERF_SPLIT_1 204853 24026 1 0.0000 0.0000
PERF_SPLIT_2 164053 7402 1 0.0000 0.0000
PERF_SPLIT_3 186612 19582 1 0.0000 0.0000
PERF_SPLIT_4 158080 18618 1 0.0000 0.0000
PERF_SPLIT_5 177362 7001 1 0.0000 0.0000
PERF_SPLIT_6 201554 37538 1 0.0000 0.0000
PERF_SPLIT_7 162287 9067 1 0.0000 0.0000
PERF_SPLIT_8 163923 7300 1 0.0000 0.0000
PERF_SPLIT_9 190852 25048 1 0.0000 0.0000
PSTORNED 2075326 15613 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143986 47552 1 0.0000 0.0000
XQD_1000_3300 6875466 242996 1 0.0000 0.0000
XQD_1200_2000 11806492 156704 1 0.0000 0.0000
XQD_2000_3300 1434477 431404 1 0.0000 0.0000
XQD_2100_3300 940510 286749 1 0.0000 0.0000
XQD_3300_3400 9089810 240767 1 0.0000 0.0000
XQS_1000_1200 21150782 5399 1 0.0000 0.0000
XQS_1000_3300 9512141 210098 1 0.0000 0.0000
XQS_1200_2000 11273543 201100 1 0.0000 0.0000
XQS_2100_3300 9607434 191825 1 0.0000 0.0000
XQS_3300_3400 569743 3177 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 ---
:90: 
:91: mscs-test-161.budzdorov.ru    Sun Mar  3 16:10:14 2024
:92:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:93: 
:94: 
:95: mscs-test-161.budzdorov.ru    Sun Mar  3 16:10:14 2024
:96:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:97: 
--- end of diff output ---

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

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