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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15597476 kB
MemAvailable 30238812 kB
Buffers 0 kB
Cached 16121596 kB
SwapCached 2476 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-27 16:09:43
DTS_END                         2024-03-27 16:09:43.7580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39956
TRN_ID                          175486
ATT_ID                          548
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: 9443.89 20098 944389
customer order: creation 184.38 329 18438
customer order: refuse 15.59 356 1559
order to supplier: creation 49.36 1296 4936
order to supplier: removal 3.42 91646 342
invoice (draft): creation 49.11 3250 4911
invoice (draft): removal 50.62 755 5062
invoice accept: apply 45.12 21664 4512
invoice accept: cancel 44.98 911 4498
customer reserve: creation 4307.55 209 430755
customer reserve: removal 4404.09 57 440409
realization accept: apply 86.62 183 8662
realization accept: cancel 67.53 119 6753
payment from customer: creation 63.05 123 6305
payment from customer: removal 6.09 70 609
payment to supplier: creation 50.58 133 5058
payment to supplier: removal 3.25 83 325
service: total inventory turnovers 4.55 1367 455
service: total monetary turnovers 6.97 37 697
service: aggregate perf. data 1.00 14983 100
service: refresh index statistics 0.03 264392 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2024 16:10:34 to 27-03-2024 16:10:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5013
TEST_TIME 2 6477
TEST_TIME 3 5710
TEST_TIME 4 5362
TEST_TIME 5 5119
TEST_TIME 6 5545
TEST_TIME 7 5988
TEST_TIME 8 6030
TEST_TIME 9 6207
TEST_TIME 10 6224
TEST_TIME 11 6619
TEST_TIME 12 6753
TEST_TIME 13 6744
TEST_TIME 14 6926
TEST_TIME 15 6932
TEST_TIME 16 6926
TEST_TIME 17 6888
TEST_TIME 18 6944
TEST_TIME 19 6933
TEST_TIME 20 7167
TEST_TIME 21 7045
TEST_TIME 22 7427
TEST_TIME 23 7323
TEST_TIME 24 7419
TEST_TIME 25 7704
TEST_TIME 26 7943
TEST_TIME 27 8297
TEST_TIME 28 8360
TEST_TIME 29 8185
TEST_TIME 30 8378
TEST_TIME 31 8355
TEST_TIME 32 8825
TEST_TIME 33 9310
TEST_TIME 34 9363
TEST_TIME 35 9259
TEST_TIME 36 9213
TEST_TIME 37 9139
TEST_TIME 38 9103
TEST_TIME 39 9247
TEST_TIME 40 9267
TEST_TIME 41 9366
TEST_TIME 42 9387
TEST_TIME 43 9393
TEST_TIME 44 9581
TEST_TIME 45 9494
TEST_TIME 46 9453
TEST_TIME 47 9351
TEST_TIME 48 9257
TEST_TIME 49 9313
TEST_TIME 50 9208
TEST_TIME 51 9222
TEST_TIME 52 9160
TEST_TIME 53 9170
TEST_TIME 54 9218
TEST_TIME 55 9254
TEST_TIME 56 9157
TEST_TIME 57 9100
TEST_TIME 58 9071
TEST_TIME 59 9221
TEST_TIME 60 9258
TEST_TIME 61 9190
TEST_TIME 62 9186
TEST_TIME 63 9269
TEST_TIME 64 9209
TEST_TIME 65 9282
TEST_TIME 66 9338
TEST_TIME 67 9342
TEST_TIME 68 9351
TEST_TIME 69 9407
TEST_TIME 70 9426
TEST_TIME 71 9433
TEST_TIME 72 9584
TEST_TIME 73 9636
TEST_TIME 74 9536
TEST_TIME 75 9457
TEST_TIME 76 9441
TEST_TIME 77 9438
TEST_TIME 78 9397
TEST_TIME 79 9350
TEST_TIME 80 9337
TEST_TIME 81 9288
TEST_TIME 82 9264
TEST_TIME 83 9231
TEST_TIME 84 9228
TEST_TIME 85 9183
TEST_TIME 86 9248
TEST_TIME 87 9215
TEST_TIME 88 9206
TEST_TIME 89 9206
TEST_TIME 90 9182
TEST_TIME 91 9152
TEST_TIME 92 9283
TEST_TIME 93 9276
TEST_TIME 94 9242
TEST_TIME 95 9281
TEST_TIME 96 9280
TEST_TIME 97 9365
TEST_TIME 98 9379
TEST_TIME 99 9462
TEST_TIME 100 9464

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-03-2024 16:10:38 to 27-03-2024 16:10:41.

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 1337036 1337036 0 0.00 0 14676 7 0 0
doc_list_biud 1337036 1337036 0 0.00 0 50499 24 0 0
sp_add_invoice_to_stock 4607 4512 95 2.06 49 228933 21665 0 95
sp_cancel_adding_invoice 4498 4498 0 0.00 4 71373 911 0 0
sp_cancel_client_order 1559 1559 0 0.00 4 10648 356 0 0
sp_cancel_customer_reserve 440409 440409 0 0.00 0 50511 57 0 0
sp_cancel_pay_from_customer 609 609 0 0.00 3 2375 70 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 2 3767 84 0 0
sp_cancel_supplier_invoice 5067 5062 5 0.09 1 18475 755 0 5
sp_cancel_supplier_order 342 342 0 0.00 10 898730 91646 0 0
sp_cancel_write_off 6753 6753 0 0.00 1 8985 120 0 0
sp_client_order 18438 18438 0 0.00 3 31881 330 0 0
sp_customer_reserve 430755 430755 0 0.00 0 58370 210 0 0
sp_fill_shopping_cart 28279 28279 0 0.00 1 13895 41 0 0
sp_fill_shopping_cart_clo_res 430726 430726 0 0.00 0 10733 12 0 0
sp_get_clo_for_invoice 4482 4482 0 0.00 0 15740 249 0 0
sp_kill_cost_storno 12185 12185 0 0.00 0 6905 60 0 0
sp_kill_qstorno_ret_qs2qd 892975 892975 0 0.00 0 41767 31 0 0
sp_kill_qty_storno 471765 471765 0 0.00 0 50499 68 0 0
sp_lock_selected_doc 18265 18265 0 0.00 0 6111 3 0 0
sp_make_cost_storno 24505 24505 0 0.00 0 14666 55 0 0
sp_multiply_rows_for_pdistr 24505 24505 0 0.00 0 5232 29 0 0
sp_multiply_rows_for_qdistr 18438 18438 0 0.00 0 11086 126 0 0
sp_pay_from_customer 6305 6305 0 0.00 4 20699 124 0 0
sp_pay_to_supplier 5058 5058 0 0.00 5 21847 134 0 0
sp_payment_common 11363 11363 0 0.00 1 19932 29 0 0
sp_qd_handle_on_cancel_clo 1559 1559 0 0.00 0 10641 331 0 0
sp_qd_handle_on_invoice_upd_sts 8978 8978 0 0.00 0 24937 326 0 0
sp_qd_handle_on_reserve_upd_sts 8662 8662 0 0.00 0 26047 63 0 0
sp_reserve_write_off 8662 8662 0 0.00 6 26066 183 0 0
sp_supplier_invoice 4911 4911 0 0.00 6 74739 3251 0 0
sp_supplier_order 4936 4936 0 0.00 5 71551 1297 0 0
srv_aggregate_perf_data 100 100 0 0.00 1477 115695 14983 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1498 108153 38478 0 0
srv_find_qd_qs_mism 898261 898261 0 0.00 0 11581 7 0 0
srv_make_invnt_saldo 455 455 0 0.00 44 59911 1368 0 0
srv_make_money_saldo 697 697 0 0.00 1 6265 37 0 0
srv_recalc_idx_stat 3 3 0 0.00 134489 400233 264393 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4512 4512 0 0.00 0 22830 203 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 14631 154 0 0
t$perf-norm:sp_cancel_client_order 1559 1559 0 0.00 0 3546 16 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 886 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 609 609 0 0.00 0 224 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 2074 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 4185 33 0 0
t$perf-norm:sp_cancel_supplier_order 342 342 0 0.00 0 21722 1785 0 0
t$perf-norm:sp_cancel_write_off 849 849 0 0.00 0 4272 15 0 0
t$perf-norm:sp_client_order 18438 18438 0 0.00 0 23563 24 0 0
t$perf-norm:sp_customer_reserve 883 883 0 0.00 0 11216 29 0 0
t$perf-norm:sp_pay_from_customer 6305 6305 0 0.00 0 20631 17 0 0
t$perf-norm:sp_pay_to_supplier 5058 5058 0 0.00 0 6368 11 0 0
t$perf-norm:sp_reserve_write_off 8662 8662 0 0.00 0 22761 15 0 0
t$perf-norm:sp_supplier_invoice 4911 4911 0 0.00 0 8350 19 0 0
t$perf-norm:sp_supplier_order 4936 4936 0 0.00 0 8548 26 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 359 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 616 14 0 0
t$perf-norm:srv_make_invnt_saldo 455 455 0 0.00 0 1764 30 0 0
t$perf-norm:srv_make_money_saldo 697 697 0 0.00 0 1557 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9150 8960 190 2.07 0 16400 21 0 190
v_all_customers 33774 33774 0 0.00 0 28 1 0 0
v_all_suppliers 27670 27670 0 0.00 0 27 1 0 0
v_all_wares 36876 36876 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 24008 57 0 0
v_cancel_client_order 3118 3118 0 0.00 0 3177 6 0 0
v_cancel_customer_prepayment 1218 1218 0 0.00 0 1555 4 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 2223 7 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 1629 8 0 0
v_cancel_supplier_invoice 770 760 10 1.29 0 1392 17 0 10
v_cancel_supplier_order 684 684 0 0.00 0 363 5 0 0
v_cancel_write_off 1698 1698 0 0.00 0 2551 14 0 0
v_max_id_clo_ord 4936 4936 0 0.00 0 6036 4 0 0
v_max_id_clo_res 883 883 0 0.00 0 2114 10 0 0
v_max_id_ord_sup 4905 4905 0 0.00 0 3849 2 0 0
v_max_non_paid_invoice 1064 1064 0 0.00 0 917 4 0 0
v_max_non_paid_realizn 3184 3184 0 0.00 0 3546 7 0 0
v_min_id_clo_ord 4936 4936 0 0.00 0 7202 7 0 0
v_min_id_clo_res 883 883 0 0.00 0 4844 12 0 0
v_min_id_ord_sup 4905 4905 0 0.00 0 6037 8 0 0
v_min_non_paid_invoice 5058 5058 0 0.00 0 19921 24 0 0
v_min_non_paid_realizn 6305 6305 0 0.00 0 6230 19 0 0
v_our_firm 9344 9344 0 0.00 0 17 1 0 0
v_reserve_write_off 17324 17324 0 0.00 0 16290 11 0 0
x_lock_depdocs_on_canc_invoice 9180 9180 0 0.00 0 13780 133 0 0
x_lock_depdocs_on_canc_sup_ord 342 342 0 0.00 0 5094 373 0 0
x_make_qstorno_1000_1200 4936 4936 0 0.00 1 71518 1215 0 0
x_make_qstorno_1200_2000 4911 4911 0 0.00 3 74665 3098 0 0
x_make_qstorno_2100_3300 430755 430755 0 0.00 0 58369 194 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2024 16:10:42 to 27-03-2024 16:10:46.

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 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:48 32390 8192000000 9904290128 10213859328 973686864 10.623 100 87 172 1 1002370720 5591888 23091968
14:12:29 19846 8192000000 9947052704 10267725824 1024964224 11.120 100 88 176 0 1055160880 7536976 22659680
14:13:54 18377 8192000000 9966285344 10296279040 1053845792 11.398 100 88 176 0 1085820576 9412048 22562736
14:15:20 18290 8192000000 10016024816 10361110528 1104908912 11.884 100 75 150 0 1132810336 10164720 17736704
14:16:41 7598 8192000000 10085534448 10445008896 1166853040 12.467 100 77 153 0 1195094528 10915264 17326224
14:17:53 2961 8192000000 10116926304 10483249152 1209622288 12.866 100 87 171 1 1241435824 12217920 19595616
14:18:59 2623 8192000000 10159662864 10536521728 1243768528 13.181 100 81 161 0 1275264512 13953728 17542256
14:20:04 1922 8192000000 10189388992 10569912320 1267692048 13.400 100 85 166 2 1300083696 14200864 18190784
14:21:08 1619 8192000000 10209421712 10597240832 1297177216 13.670 100 80 160 0 1326820320 11647904 17995200
14:22:11 1813 8192000000 10215062336 10612514816 1304291696 13.734 100 64 128 2 1335042320 16729792 14020832
14:23:13 4103 8192000000 10213219552 10615169024 1307367840 13.762 100 58 114 1 1328181008 7159232 13653936
14:24:18 8618 8192000000 10199112240 10616950784 1315679920 13.838 100 21 42 0 1327096944 6689840 4727184
14:25:27 13683 8192000000 10213391984 10630774784 1325506560 13.927 100 19 39 0 1335878768 6133008 4239200
14:26:42 6351 8192000000 10215235120 10634563584 1333107600 13.995 100 21 42 0 1343209664 5299040 4803024
14:27:50 14184 8192000000 10213441536 10637725696 1329235632 13.960 100 18 37 1 1339124880 5442384 4446864
14:29:04 16512 8192000000 10233402608 10642931712 1328193024 13.951 100 66 133 0 1350724192 6606640 15924528
14:30:22 2663 8192000000 10240655120 10651529216 1321953456 13.894 99 59 118 1 1349263920 14394880 12915584
14:31:29 4984 8192000000 10252374624 10661928960 1342909376 14.084 100 69 135 0 1369526320 11735680 14881264
14:32:38 20670 8192000000 10267982560 10686681088 1361551184 14.251 100 47 94 1 1383983296 11826624 10605488
14:34:02 10652 8192000000 10265484912 10677329920 1343333040 14.087 99 54 107 0 1370892336 14380256 13179040
14:35:20 24465 8192000000 10278167280 10690576384 1360961648 14.246 100 53 106 3 1386979760 14246208 11771904
14:36:47 12874 8192000000 10270548640 10680754176 1346284768 14.114 99 58 116 1 1375199744 15663712 13251264
14:38:04 21605 8192000000 10261263104 10679390208 1343043216 14.085 99 41 82 0 1369501904 16513472 9945216
14:39:32 13290 8192000000 10242294800 10650804224 1318712976 13.865 99 50 100 0 1347968384 17728224 11527184
14:40:48 7375 8192000000 10225855616 10631385088 1284277136 13.552 97 51 99 3 1311039120 15056688 11705296
14:42:03 7925 8192000000 10205638208 10610356224 1258215968 13.314 96 40 80 0 1284747984 16637536 9894480
14:43:16 7171 8192000000 10238234256 10636558336 1302781920 13.721 99 73 140 1 1339516416 20535392 16199104
14:44:35 13554 8192000000 10216606832 10613112832 1283467264 13.545 98 57 114 0 1315227376 18699536 13060576
14:46:03 8247 8192000000 10222062272 10621853696 1303015152 13.723 100 53 106 0 1333833200 18634768 12183280
14:47:23 3877 8192000000 10254854928 10658115584 1327712112 13.946 100 63 124 2 1363339520 20132416 15494992
14:48:47 1496 8192000000 10271152896 10672414720 1343736496 14.091 100 64 128 0 1385199488 26135456 15327536
14:49:54 21643 8192000000 10268821088 10683076608 1346593664 14.117 100 24 48 0 1377601664 24707808 6300192
14:51:21 9309 8192000000 10287451616 10708561920 1363428160 14.268 100 45 88 0 1405113728 30857136 10828432
14:52:37 2812 8192000000 10321940592 10724347904 1371114640 14.337 100 82 164 0 1425286336 33974336 20197360
14:53:44 9544 8192000000 10325128528 10738626560 1373259664 14.356 100 59 116 1 1430285360 41312240 15713456
14:54:58 17039 8192000000 10322686640 10750435328 1382675504 14.440 100 39 78 1 1433502608 40043392 10783712
14:56:22 2819 8192000000 10331871424 10756878336 1394380880 14.545 100 48 91 1 1442488320 35862336 12245104
14:57:26 38588 8192000000 10330581040 10756358144 1396625216 14.565 100 56 108 1 1431602496 21868800 13108480
14:59:06 5918 8192000000 10330013264 10762113024 1399893744 14.594 100 43 86 1 1441823440 31102688 10827008
15:00:22 17652 8192000000 10324512736 10767974400 1390734512 14.512 100 21 42 0 1431175728 34579744 5861472
15:01:44 35356 8192000000 10312557488 10769326080 1386716144 14.477 100 13 26 1 1423004112 32954736 3333232
15:03:30 50201 8192000000 10310348192 10741116928 1385433216 14.465 100 35 71 2 1402248784 8710496 8105072
15:05:24 59511 8192000000 10303894608 10744016896 1378349008 14.402 99 38 75 1 1396134880 9381216 8404656
15:07:28 81069 8192000000 10307300832 10766032896 1383233552 14.445 99 12 22 0 1401610224 15998336 2378336
15:09:51 81034 8192000000 10305941248 10761240576 1386194992 14.472 99 7 14 0 1407228464 19390064 1643408
15:12:15 65778 8192000000 10310501616 10778353664 1377974704 14.398 98 12 24 0 1397461088 16696720 2789664
15:14:21 72744 8192000000 10297630928 10763374592 1380126320 14.418 99 13 24 0 1400980080 18215984 2637776
15:16:58 78748 8192000000 10302726288 10758955008 1382442592 14.438 99 30 60 0 1398022912 8775200 6805120
15:19:22 43811 8192000000 10292540608 10748379136 1379941040 14.416 99 18 36 0 1392025648 7773536 4311072
15:21:10 14958 8192000000 10301792768 10737496064 1350960000 14.156 97 52 101 2 1371837888 8160752 12717136
15:22:28 30058 8192000000 10275767024 10716147712 1331152752 13.978 97 34 67 0 1352993408 13821808 8018848
15:24:06 74656 8192000000 10255562368 10709229568 1305494016 13.745 96 25 50 1 1323255232 12110352 5650864
15:26:24 76831 8192000000 10237059488 10672140288 1270343568 13.425 95 18 36 0 1292639600 18077952 4218080
15:28:52 21546 8192000000 10235966592 10676080640 1294615952 13.646 97 21 42 1 1311797872 12872064 4309856
15:30:17 47742 8192000000 10251497872 10679033856 1260404800 13.334 94 17 34 0 1276089856 11547712 4137344
15:32:16 61955 8192000000 10218786864 10660081664 1261076048 13.340 95 22 43 0 1274305872 8254048 4975776
15:34:19 100539 8192000000 10232910080 10684149760 1282143584 13.533 96 12 24 0 1301671488 16690192 2837712
15:37:19 47385 8192000000 10260063552 10696032256 1326175792 13.933 98 33 67 0 1343549712 10316272 7057648
15:39:08 78496 8192000000 10292772560 10744344576 1356013632 14.202 99 16 32 1 1384442880 25023088 3406160
15:41:44 108153 8192000000 10287064912 10730262528 1355504128 14.197 98 21 40 0 1376987568 17636128 3847312
15:45:21 23977 8192000000 10290053296 10740367360 1377940736 14.398 100 28 56 0 1398227696 14334320 5952640
15:46:46 45831 8192000000 10280025360 10745405440 1382327616 14.437 100 8 14 0 1391793744 8392752 1073376
15:48:40 60778 8192000000 10289728080 10747760640 1379931600 14.416 99 17 34 0 1392650624 8501216 4217808
15:50:42 52865 8192000000 10300741088 10759692288 1398070448 14.578 100 16 31 2 1410852000 9201904 3579648
15:53:27 44455 8192000000 10313573904 10776027136 1403924176 14.630 100 20 40 0 1421399872 12696880 4778816
15:55:12 73218 8192000000 10301028944 10779824128 1389484704 14.501 99 19 38 2 1412099840 18112912 4502224
15:57:26 76366 8192000000 10294822000 10755026944 1342892176 14.083 96 14 28 0 1355107504 9173616 3041712
15:59:43 58530 8192000000 10302436080 10756964352 1371372624 14.339 98 22 44 1 1393161168 16733696 5054848
16:01:42 51365 8192000000 10297109952 10756284416 1389153152 14.498 100 14 27 0 1402024016 9883088 2987776
16:03:35 32998 8192000000 10301549952 10743050240 1349244544 14.141 97 47 93 0 1372178736 12554800 10379392
16:05:09 40717 8192000000 10309116848 10754625536 1373446048 14.358 99 43 87 0 1397210352 14581920 9182384
16:06:50 75820 8192000000 10298932032 10752540672 1369939728 14.327 99 19 36 0 1385922752 12154752 3828272
16:09:21 39485 8192000000 9215787168 9468866560 367539456 4.293 26 3 6 0 377529264 9362400 627408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-03-2024 16:10:48 to 27-03-2024 16:11:02.

Exceptions occured during test was in run

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

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

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          175752
MON$OLDEST_ACTIVE               175753
MON$OLDEST_SNAPSHOT             175753
MON$NEXT_TRANSACTION            175753
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                       1928992
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.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 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 Wed Mar 27 16:11:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        91563 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175752 
    Oldest active        175753 
    Oldest snapshot        175753 
    Next transaction    175754 
    Sequence number        0 
    Next attachment ID    708 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 46.59, total records: 7897384 
    Average version length: 48.16, total versions: 214381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.37 
    Pointer pages: 54, data page slots: 87776 
    Data pages: 87776, average fill: 72% 
    Primary pages: 87776, secondary pages: 0, swept pages: 8677 
    Empty pages: 4, full pages: 81302 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 169 
    40 - 59% = 3151 
    60 - 79% = 84312 
    80 - 99% = 127 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23345, nodes: 7897384 
    Average node length: 18.95, total dup: 0, max dup: 0 
    Average key length: 15.96, compression ratio: 1.69 
    Average prefix length: 14.04, average data length: 12.96 
    Clustering factor: 1757907, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 364 
        20 - 39% = 1315 
        40 - 59% = 4302 
        60 - 79% = 2039 
        80 - 99% = 15325 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13574, nodes: 7897384 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1580838, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1226 
        40 - 59% = 2351 
        60 - 79% = 886 
        80 - 99% = 9111 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8361, nodes: 7897384 
    Average node length: 6.65, total dup: 5863132, max dup: 49 
    Average key length: 3.66, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1573843, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 741 
        40 - 59% = 1529 
        60 - 79% = 744 
        80 - 99% = 5223 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 54.72, total records: 2322728 
    Average version length: 34.46, total versions: 221880, max versions: 3 
    Average fragment length: 7.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.54 
    Pointer pages: 18, data page slots: 28912 
    Data pages: 28912, average fill: 76% 
    Primary pages: 28903, secondary pages: 9, swept pages: 5260 
    Empty pages: 8, full pages: 25153 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 61 
    40 - 59% = 1227 
    60 - 79% = 24007 
    80 - 99% = 3593 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4611, nodes: 2322728 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 706573, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 840 
        40 - 59% = 916 
        60 - 79% = 584 
        80 - 99% = 2271 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2576, nodes: 2326773 
    Average node length: 4.97, total dup: 2325874, max dup: 19996 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1272973, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 235 
        40 - 59% = 1576 
        60 - 79% = 546 
        80 - 99% = 216 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2093, nodes: 2322728 
    Average node length: 4.97, total dup: 2322678, max dup: 130435 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1086284, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 1200 
        60 - 79% = 37 
        80 - 99% = 825 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4385, nodes: 2322728 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 706573, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 514 
        40 - 59% = 647 
        60 - 79% = 661 
        80 - 99% = 2454 
 
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.34, total records: 400 
    Average version length: 23.16, total versions: 228192, max versions: 596 
    Average fragment length: 2.04, total fragments: 55, 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: 13, secondary pages: 1259, swept pages: 0 
    Empty pages: 6, full pages: 1265 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1264 
 
    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: 17.48, total records: 122764 
    Average version length: 68.29, total versions: 91345, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.03 
    Pointer pages: 7, data page slots: 2912 
    Data pages: 2112, average fill: 71% 
    Primary pages: 2111, secondary pages: 1, swept pages: 0 
    Empty pages: 185, full pages: 1498 
    Fill distribution: 
     0 - 19% = 240 
    20 - 39% = 145 
    40 - 59% = 166 
    60 - 79% = 266 
    80 - 99% = 1295 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1695934, depth: 3, leaf buckets: 393, nodes: 122764 
    Average node length: 13.20, total dup: 10532, max dup: 2 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 86980, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 289 
        60 - 79% = 64 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17848, max versions: 971 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 61 
 
    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: 9.02, total records: 1807 
    Average version length: 43.88, total versions: 1448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.43 
    Pointer pages: 1, data page slots: 40 
    Data pages: 34, average fill: 51% 
    Primary pages: 33, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 12 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 8 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93471, depth: 2, leaf buckets: 2, nodes: 1807 
    Average node length: 4.41, total dup: 1711, max dup: 226 
    Average key length: 2.57, compression ratio: 7.39 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 859, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.89, total records: 74 
    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.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.24, total records: 800329 
    Average version length: 25.14, total versions: 103235, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 5, data page slots: 7864 
    Data pages: 7848, average fill: 72% 
    Primary pages: 7826, secondary pages: 22, swept pages: 564 
    Empty pages: 22, full pages: 7518 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 20 
    40 - 59% = 39 
    60 - 79% = 7285 
    80 - 99% = 467 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 877, nodes: 800329 
    Average node length: 4.87, total dup: 800280, max dup: 145127 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88452, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 128 
        40 - 59% = 477 
        60 - 79% = 199 
        80 - 99% = 68 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 860, nodes: 800329 
    Average node length: 5.88, total dup: 712485, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158758, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 88 
        40 - 59% = 280 
        60 - 79% = 111 
        80 - 99% = 380 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 899, nodes: 800329 
    Average node length: 5.88, total dup: 712485, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160746, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 166 
        40 - 59% = 254 
        60 - 79% = 109 
        80 - 99% = 370 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1131, nodes: 800329 
    Average node length: 5.96, total dup: 712485, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153560, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 229 
        40 - 59% = 620 
        60 - 79% = 183 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5430 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.07, total fragments: 105, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 93, average fill: 58% 
    Primary pages: 77, secondary pages: 16, swept pages: 49 
    Empty pages: 8, full pages: 59 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5430 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.04 
    Average prefix length: 34.35, average data length: 1.54 
    Clustering factor: 5211, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5430 
    Average node length: 11.15, 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: 153, 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.13, total records: 80481 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 775 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 775 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36764, depth: 2, leaf buckets: 103, nodes: 80481 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3493, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.57, 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.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 135.30, total records: 159212 
    Average version length: 154.96, total versions: 16443, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.54 
    Pointer pages: 6, data page slots: 5160 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3847, secondary pages: 1, swept pages: 1 
    Empty pages: 60, full pages: 3770 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 3770 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 142.02, total records: 160729 
    Average version length: 154.21, total versions: 9313, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 6, data page slots: 5048 
    Data pages: 3864, average fill: 86% 
    Primary pages: 3863, secondary pages: 1, swept pages: 9 
    Empty pages: 46, full pages: 3795 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3795 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.12, total records: 168779 
    Average version length: 152.72, total versions: 4890, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 4128, average fill: 85% 
    Primary pages: 4128, secondary pages: 0, swept pages: 10 
    Empty pages: 99, full pages: 3996 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 13 
    40 - 59% = 11 
    60 - 79% = 8 
    80 - 99% = 3994 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.81, total records: 165659 
    Average version length: 152.36, total versions: 5084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 5248 
    Data pages: 4032, average fill: 85% 
    Primary pages: 4032, secondary pages: 0, swept pages: 7 
    Empty pages: 83, full pages: 3925 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3922 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.76, total records: 146327 
    Average version length: 153.19, total versions: 8091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 6, data page slots: 5440 
    Data pages: 3552, average fill: 85% 
    Primary pages: 3551, secondary pages: 1, swept pages: 5 
    Empty pages: 68, full pages: 3459 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 12 
    80 - 99% = 3458 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.21, total records: 158765 
    Average version length: 152.83, total versions: 6267, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 7, data page slots: 5816 
    Data pages: 3888, average fill: 84% 
    Primary pages: 3888, secondary pages: 0, swept pages: 9 
    Empty pages: 87, full pages: 3736 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 11 
    40 - 59% = 44 
    60 - 79% = 3 
    80 - 99% = 3737 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.28, total records: 156320 
    Average version length: 152.71, total versions: 3798, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 7040 
    Data pages: 3792, average fill: 85% 
    Primary pages: 3792, secondary pages: 0, swept pages: 3 
    Empty pages: 72, full pages: 3693 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3692 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 100.52, total records: 224730 
    Average version length: 155.05, total versions: 75239, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 16.87 
    Pointer pages: 7, data page slots: 6392 
    Data pages: 5480, average fill: 88% 
    Primary pages: 5480, secondary pages: 0, swept pages: 5 
    Empty pages: 94, full pages: 5359 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 5359 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 133.17, total records: 166085 
    Average version length: 154.39, total versions: 19387, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.74 
    Pointer pages: 7, data page slots: 5688 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4024, secondary pages: 0, swept pages: 3 
    Empty pages: 69, full pages: 3928 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3928 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 124.41, total records: 173476 
    Average version length: 155.01, total versions: 30220, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.63 
    Pointer pages: 7, data page slots: 4912 
    Data pages: 4184, average fill: 87% 
    Primary pages: 4184, secondary pages: 0, swept pages: 5 
    Empty pages: 52, full pages: 4115 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 4112 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 50.55, total records: 2177547 
    Average version length: 52.97, total versions: 90671, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.38 
    Pointer pages: 16, data page slots: 25832 
    Data pages: 25832, average fill: 73% 
    Primary pages: 25832, secondary pages: 0, swept pages: 7196 
    Empty pages: 222, full pages: 23393 
    Fill distribution: 
     0 - 19% = 409 
    20 - 39% = 242 
    40 - 59% = 605 
    60 - 79% = 23662 
    80 - 99% = 914 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2616, nodes: 2177547 
    Average node length: 5.44, total dup: 2033819, max dup: 2053 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 186230, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 198 
        40 - 59% = 1791 
        60 - 79% = 305 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2760, nodes: 2177547 
    Average node length: 5.69, total dup: 1956182, max dup: 70 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 387524, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2216 
        60 - 79% = 507 
        80 - 99% = 36 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2233, nodes: 2177547 
    Average node length: 4.96, total dup: 2177447, max dup: 27909 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183786, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 174 
        40 - 59% = 1274 
        60 - 79% = 368 
        80 - 99% = 414 
 
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: 34.72, total records: 168620 
    Average version length: 69.17, total versions: 84008, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.63 
    Pointer pages: 3, data page slots: 4448 
    Data pages: 3400, average fill: 58% 
    Primary pages: 3400, secondary pages: 0, swept pages: 439 
    Empty pages: 717, full pages: 2055 
    Fill distribution: 
     0 - 19% = 888 
    20 - 39% = 28 
    40 - 59% = 109 
    60 - 79% = 1099 
    80 - 99% = 1276 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 257163, depth: 3, leaf buckets: 257, nodes: 168620 
    Average node length: 6.47, total dup: 146678, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 29240, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 44 
        40 - 59% = 137 
        60 - 79% = 59 
        80 - 99% = 15 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 62.05, total records: 7412585 
    Average version length: 68.80, total versions: 743424, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.03 
    Pointer pages: 63, data page slots: 102312 
    Data pages: 102040, average fill: 78% 
    Primary pages: 102040, secondary pages: 0, swept pages: 8351 
    Empty pages: 39, full pages: 100997 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 84 
    40 - 59% = 118 
    60 - 79% = 81602 
    80 - 99% = 20180 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10782, nodes: 7412585 
    Average node length: 6.51, total dup: 6412434, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1617140, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1216 
        40 - 59% = 5781 
        60 - 79% = 3148 
        80 - 99% = 626 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8703, nodes: 7412585 
    Average node length: 5.39, total dup: 7122533, max dup: 164 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1406469, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 897 
        40 - 59% = 4946 
        60 - 79% = 1650 
        80 - 99% = 1204 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8771, nodes: 7412585 
    Average node length: 5.39, total dup: 7122533, max dup: 164 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1408991, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 974 
        40 - 59% = 4936 
        60 - 79% = 1635 
        80 - 99% = 1220 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 65.76, total records: 12333126 
    Average version length: 68.75, total versions: 572165, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 104, data page slots: 168824 
    Data pages: 168824, average fill: 78% 
    Primary pages: 168824, secondary pages: 0, swept pages: 50773 
    Empty pages: 4, full pages: 168753 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 154025 
    80 - 99% = 14788 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18385, nodes: 12333126 
    Average node length: 6.60, total dup: 10747759, max dup: 71 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2398195, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1841 
        40 - 59% = 10572 
        60 - 79% = 4984 
        80 - 99% = 955 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 27.37, total records: 2386515 
    Average version length: 69.12, total versions: 1441724, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.60 
    Pointer pages: 30, data page slots: 47768 
    Data pages: 32680, average fill: 86% 
    Primary pages: 32679, secondary pages: 1, swept pages: 578 
    Empty pages: 28, full pages: 32630 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 8737 
    80 - 99% = 23895 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2610, nodes: 2386515 
    Average node length: 5.50, total dup: 2289772, max dup: 99 
    Average key length: 2.53, compression ratio: 16.57 
    Average prefix length: 41.51, average data length: 0.49 
    Clustering factor: 159467, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 88 
        40 - 59% = 1119 
        60 - 79% = 961 
        80 - 99% = 433 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 33.04, total records: 1355618 
    Average version length: 69.14, total versions: 706691, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.81 
    Pointer pages: 21, data page slots: 33480 
    Data pages: 28792, average fill: 55% 
    Primary pages: 28792, secondary pages: 0, swept pages: 5019 
    Empty pages: 5666, full pages: 16905 
    Fill distribution: 
     0 - 19% = 8547 
    20 - 39% = 1228 
    40 - 59% = 845 
    60 - 79% = 6441 
    80 - 99% = 11731 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1691, nodes: 1355618 
    Average node length: 5.76, total dup: 1268343, max dup: 112 
    Average key length: 2.82, compression ratio: 14.89 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 182741, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 182 
        40 - 59% = 797 
        60 - 79% = 547 
        80 - 99% = 164 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 60.87, total records: 9951109 
    Average version length: 68.96, total versions: 1158560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.07 
    Pointer pages: 91, data page slots: 147712 
    Data pages: 147696, average fill: 73% 
    Primary pages: 147696, secondary pages: 0, swept pages: 20474 
    Empty pages: 297, full pages: 112862 
    Fill distribution: 
     0 - 19% = 838 
    20 - 39% = 3968 
    40 - 59% = 18465 
    60 - 79% = 96554 
    80 - 99% = 27871 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13566, nodes: 9951109 
    Average node length: 6.70, total dup: 8254978, max dup: 19 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2154544, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 638 
        40 - 59% = 5887 
        60 - 79% = 5759 
        80 - 99% = 1279 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.43, total records: 21174858 
    Average version length: 82.89, total versions: 27567, 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: 318944 
    Data pages: 318944, average fill: 81% 
    Primary pages: 318944, secondary pages: 0, swept pages: 10848 
    Empty pages: 7, full pages: 318936 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26469 
    80 - 99% = 292468 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19627, nodes: 21174858 
    Average node length: 5.72, total dup: 20693492, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285659, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 8606 
        60 - 79% = 553 
        80 - 99% = 10461 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17189, nodes: 21174858 
    Average node length: 6.31, total dup: 18608377, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915993, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 779 
        60 - 79% = 285 
        80 - 99% = 16116 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21411, nodes: 21174858 
    Average node length: 6.35, total dup: 18527854, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580006, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 8869 
        60 - 79% = 596 
        80 - 99% = 11938 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16162, nodes: 21174858 
    Average node length: 5.56, total dup: 21174758, max dup: 230538 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944975, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2970 
        60 - 79% = 411 
        80 - 99% = 12771 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.11, total records: 10293993 
    Average version length: 82.62, total versions: 1037073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.70 
    Pointer pages: 108, data page slots: 176144 
    Data pages: 176120, average fill: 73% 
    Primary pages: 176120, secondary pages: 0, swept pages: 40404 
    Empty pages: 648, full pages: 122944 
    Fill distribution: 
     0 - 19% = 1639 
    20 - 39% = 6687 
    40 - 59% = 25200 
    60 - 79% = 48063 
    80 - 99% = 94531 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11441, nodes: 10293993 
    Average node length: 5.39, total dup: 9980928, max dup: 219 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2244585, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 57 
        40 - 59% = 6222 
        60 - 79% = 4937 
        80 - 99% = 223 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13885, nodes: 10293993 
    Average node length: 6.26, total dup: 8537067, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1552806, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3557 
        40 - 59% = 4532 
        60 - 79% = 2662 
        80 - 99% = 2985 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12767, nodes: 10293993 
    Average node length: 5.99, total dup: 8961617, max dup: 44 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2458578, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 67 
        40 - 59% = 7129 
        60 - 79% = 5320 
        80 - 99% = 247 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10531, nodes: 10293993 
    Average node length: 5.17, total dup: 10293893, max dup: 156364 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1596670, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1067 
        40 - 59% = 5385 
        60 - 79% = 1608 
        80 - 99% = 2433 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 76.89, total records: 11736335 
    Average version length: 82.54, total versions: 771188, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 121, data page slots: 196552 
    Data pages: 195424, average fill: 74% 
    Primary pages: 195424, secondary pages: 0, swept pages: 54778 
    Empty pages: 3223, full pages: 153265 
    Fill distribution: 
     0 - 19% = 5282 
    20 - 39% = 6955 
    40 - 59% = 15264 
    60 - 79% = 37897 
    80 - 99% = 130026 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13152, nodes: 11736335 
    Average node length: 5.32, total dup: 11626006, max dup: 698 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2450698, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 51 
        40 - 59% = 8077 
        60 - 79% = 4747 
        80 - 99% = 275 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10649, nodes: 11736335 
    Average node length: 5.51, total dup: 11225151, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 743900, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 742 
        40 - 59% = 2542 
        60 - 79% = 1823 
        80 - 99% = 5407 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15036, nodes: 11736335 
    Average node length: 6.03, total dup: 10256874, max dup: 84 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2467414, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 56 
        40 - 59% = 9590 
        60 - 79% = 5072 
        80 - 99% = 318 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11041, nodes: 11736335 
    Average node length: 5.24, total dup: 11736235, max dup: 199993 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 732066, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 80 
        20 - 39% = 765 
        40 - 59% = 4914 
        60 - 79% = 1449 
        80 - 99% = 3833 
 
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: 74.70, total records: 10379602 
    Average version length: 82.91, total versions: 1008173, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 111, data page slots: 180584 
    Data pages: 180568, average fill: 72% 
    Primary pages: 180568, secondary pages: 0, swept pages: 44260 
    Empty pages: 611, full pages: 116899 
    Fill distribution: 
     0 - 19% = 1638 
    20 - 39% = 7258 
    40 - 59% = 29166 
    60 - 79% = 52875 
    80 - 99% = 89631 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12360, nodes: 10379602 
    Average node length: 5.22, total dup: 10350165, max dup: 2443 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2044735, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1345 
        40 - 59% = 8114 
        60 - 79% = 2175 
        80 - 99% = 686 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13990, nodes: 10379602 
    Average node length: 6.28, total dup: 8607406, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1498958, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3546 
        40 - 59% = 4473 
        60 - 79% = 2669 
        80 - 99% = 3106 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12981, nodes: 10379602 
    Average node length: 5.47, total dup: 9924037, max dup: 106 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2186745, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1222 
        40 - 59% = 9134 
        60 - 79% = 1953 
        80 - 99% = 648 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10681, nodes: 10379602 
    Average node length: 5.19, total dup: 10379502, max dup: 158472 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1591624, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1064 
        40 - 59% = 5607 
        60 - 79% = 1556 
        80 - 99% = 2432 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.82, total records: 590660 
    Average version length: 68.79, total versions: 11780, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8072, average fill: 77% 
    Primary pages: 8072, secondary pages: 0, swept pages: 2702 
    Empty pages: 1, full pages: 7497 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 13 
    40 - 59% = 99 
    60 - 79% = 7720 
    80 - 99% = 239 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45199, depth: 3, leaf buckets: 743, nodes: 590660 
    Average node length: 5.95, total dup: 503110, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102378, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 522 
        60 - 79% = 109 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36563, depth: 3, leaf buckets: 770, nodes: 590660 
    Average node length: 6.15, total dup: 484504, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102424, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 538 
        60 - 79% = 110 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 582, nodes: 590660 
    Average node length: 4.86, total dup: 590560, max dup: 9736 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90805, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 340 
        60 - 79% = 88 
        80 - 99% = 126 
 
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 Wed Mar 27 16:11:31 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7897384 214381 1 0.0000 0.0000
DOC_LIST 2322728 221880 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 228192 596 57000.0000 0.0000
INVNT_TURNOVER_LOG 122764 91345 1 0.0000 0.0000
MONEY_SALDO 49 17848 971 36400.0000 0.0000
MONEY_TURNOVER_LOG 1807 1448 1 0.0000 0.0000
PDISTR 800329 103235 5 0.0000 0.0000
PERF_SPLIT_0 159212 16443 1 0.0000 0.0000
PERF_SPLIT_1 160729 9313 1 0.0000 0.0000
PERF_SPLIT_2 168779 4890 1 0.0000 0.0000
PERF_SPLIT_3 165659 5084 1 0.0000 0.0000
PERF_SPLIT_4 146327 8091 1 0.0000 0.0000
PERF_SPLIT_5 158765 6267 1 0.0000 0.0000
PERF_SPLIT_6 156320 3798 1 0.0000 0.0000
PERF_SPLIT_7 224730 75239 1 0.0000 0.0000
PERF_SPLIT_8 166085 19387 1 0.0000 0.0000
PERF_SPLIT_9 173476 30220 1 0.0000 0.0000
PSTORNED 2177547 90671 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 168620 84008 1 0.0000 0.0000
XQD_1000_3300 7412585 743424 1 0.0000 0.0000
XQD_1200_2000 12333126 572165 1 0.0000 0.0000
XQD_2000_3300 2386515 1441724 1 0.0000 0.0000
XQD_2100_3300 1355618 706691 1 0.0000 0.0000
XQD_3300_3400 9951109 1158560 1 0.0000 0.0000
XQS_1000_1200 21174858 27567 1 0.0000 0.0000
XQS_1000_3300 10293993 1037073 1 0.0000 0.0000
XQS_1200_2000 11736335 771188 1 0.0000 0.0000
XQS_2100_3300 10379602 1008173 1 0.0000 0.0000
XQS_3300_3400 590660 11780 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 ---
:438: 
:439: mscs-test-161.budzdorov.ru    Wed Mar 27 16:10:04 2024
:440:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:441: 
:442: 
:443: mscs-test-161.budzdorov.ru    Wed Mar 27 16:10:04 2024
:444:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:445: 
--- end of diff output ---

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

27.03.24 16:11:42. 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-27 16:11:45 No severe PSQL-related problems occured
27.03.24 16:11:46. End of report.