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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15660904 kB
MemAvailable 30149684 kB
Buffers 0 kB
Cached 16076976 kB
SwapCached 2480 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-04-05 19:09:45
DTS_END                         2024-04-05 19:09:45.7330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54346
TRN_ID                          179275
ATT_ID                          621
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: 9376.09 20893 937609
customer order: creation 184.54 384 18454
customer order: refuse 15.39 392 1539
order to supplier: creation 49.69 1304 4969
order to supplier: removal 3.59 97623 359
invoice (draft): creation 47.82 3329 4782
invoice (draft): removal 49.78 855 4978
invoice accept: apply 43.92 21203 4392
invoice accept: cancel 45.34 920 4534
customer reserve: creation 4212.97 203 421297
customer reserve: removal 4413.97 61 441397
realization accept: apply 89.50 185 8950
realization accept: cancel 80.86 125 8086
payment from customer: creation 63.27 114 6327
payment from customer: removal 5.86 74 586
payment to supplier: creation 52.32 119 5232
payment to supplier: removal 3.67 71 367
service: total inventory turnovers 5.11 1027 511
service: total monetary turnovers 7.56 30 756
service: aggregate perf. data 0.90 15568 90
service: refresh index statistics 0.03 274264 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-04-2024 19:10:46 to 05-04-2024 19:10:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2817
TEST_TIME 2 3615
TEST_TIME 3 4870
TEST_TIME 4 4436
TEST_TIME 5 4345
TEST_TIME 6 4283
TEST_TIME 7 5352
TEST_TIME 8 5706
TEST_TIME 9 5801
TEST_TIME 10 5663
TEST_TIME 11 5786
TEST_TIME 12 5792
TEST_TIME 13 5755
TEST_TIME 14 6114
TEST_TIME 15 6356
TEST_TIME 16 6416
TEST_TIME 17 6740
TEST_TIME 18 6848
TEST_TIME 19 7156
TEST_TIME 20 7288
TEST_TIME 21 7195
TEST_TIME 22 8233
TEST_TIME 23 8064
TEST_TIME 24 7928
TEST_TIME 25 8314
TEST_TIME 26 8974
TEST_TIME 27 9456
TEST_TIME 28 9583
TEST_TIME 29 9515
TEST_TIME 30 9649
TEST_TIME 31 9639
TEST_TIME 32 9485
TEST_TIME 33 9491
TEST_TIME 34 9513
TEST_TIME 35 9470
TEST_TIME 36 9356
TEST_TIME 37 9306
TEST_TIME 38 9247
TEST_TIME 39 9209
TEST_TIME 40 9187
TEST_TIME 41 9212
TEST_TIME 42 9237
TEST_TIME 43 9324
TEST_TIME 44 9234
TEST_TIME 45 9206
TEST_TIME 46 9145
TEST_TIME 47 9202
TEST_TIME 48 9214
TEST_TIME 49 9229
TEST_TIME 50 9198
TEST_TIME 51 9211
TEST_TIME 52 9284
TEST_TIME 53 9244
TEST_TIME 54 9355
TEST_TIME 55 9367
TEST_TIME 56 9418
TEST_TIME 57 9378
TEST_TIME 58 9448
TEST_TIME 59 9579
TEST_TIME 60 9648
TEST_TIME 61 9605
TEST_TIME 62 9547
TEST_TIME 63 9467
TEST_TIME 64 9424
TEST_TIME 65 9353
TEST_TIME 66 9420
TEST_TIME 67 9376
TEST_TIME 68 9307
TEST_TIME 69 9275
TEST_TIME 70 9165
TEST_TIME 71 9185
TEST_TIME 72 9266
TEST_TIME 73 9246
TEST_TIME 74 9272
TEST_TIME 75 9233
TEST_TIME 76 9364
TEST_TIME 77 9383
TEST_TIME 78 9374
TEST_TIME 79 9420
TEST_TIME 80 9408
TEST_TIME 81 9431
TEST_TIME 82 9472
TEST_TIME 83 9482
TEST_TIME 84 9503
TEST_TIME 85 9568
TEST_TIME 86 9536
TEST_TIME 87 9442
TEST_TIME 88 9435
TEST_TIME 89 9416
TEST_TIME 90 9380
TEST_TIME 91 9339
TEST_TIME 92 9335
TEST_TIME 93 9299
TEST_TIME 94 9346
TEST_TIME 95 9300
TEST_TIME 96 9323
TEST_TIME 97 9328
TEST_TIME 98 9431
TEST_TIME 99 9410
TEST_TIME 100 9386

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-04-2024 19:10:49 to 05-04-2024 19:10:52.

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 1322700 1322700 0 0.00 0 20307 7 0 0
doc_list_biud 1322692 1322692 0 0.00 0 31195 27 0 0
sp_add_invoice_to_stock 4549 4392 157 3.45 36 209915 21204 0 157
sp_cancel_adding_invoice 4534 4534 0 0.00 4 57108 921 0 0
sp_cancel_client_order 1539 1539 0 0.00 4 14462 392 0 0
sp_cancel_customer_reserve 441397 441397 0 0.00 0 29815 62 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 2 3568 75 0 0
sp_cancel_pay_to_supplier 367 367 0 0.00 3 3471 72 0 0
sp_cancel_supplier_invoice 4992 4978 14 0.28 1 23373 855 0 14
sp_cancel_supplier_order 359 359 0 0.00 5 1125019 97623 0 0
sp_cancel_write_off 8086 8086 0 0.00 1 15634 125 0 0
sp_client_order 18454 18454 0 0.00 3 47632 385 0 0
sp_customer_reserve 421297 421297 0 0.00 0 77648 204 0 0
sp_fill_shopping_cart 28196 28196 0 0.00 1 17108 39 0 0
sp_fill_shopping_cart_clo_res 421271 421271 0 0.00 0 17861 15 0 0
sp_get_clo_for_invoice 4363 4363 0 0.00 0 20490 306 0 0
sp_kill_cost_storno 13573 13573 0 0.00 0 9537 67 0 0
sp_kill_qstorno_ret_qs2qd 896217 896217 0 0.00 0 29473 34 0 0
sp_kill_qty_storno 474206 474206 0 0.00 0 31194 74 0 0
sp_lock_selected_doc 18385 18385 0 0.00 0 8583 6 0 0
sp_make_cost_storno 24872 24872 0 0.00 0 11016 52 0 0
sp_multiply_rows_for_pdistr 24871 24871 0 0.00 0 8753 29 0 0
sp_multiply_rows_for_qdistr 18454 18454 0 0.00 0 41540 173 0 0
sp_pay_from_customer 6327 6327 0 0.00 4 18624 114 0 0
sp_pay_to_supplier 5232 5232 0 0.00 4 11337 119 0 0
sp_payment_common 11558 11558 0 0.00 2 7606 22 0 0
sp_qd_handle_on_cancel_clo 1539 1539 0 0.00 0 14440 350 0 0
sp_qd_handle_on_invoice_upd_sts 8897 8897 0 0.00 0 31193 356 0 0
sp_qd_handle_on_reserve_upd_sts 8950 8950 0 0.00 0 18610 65 0 0
sp_reserve_write_off 8950 8950 0 0.00 6 18638 186 0 0
sp_supplier_invoice 4782 4782 0 0.00 7 86276 3329 0 0
sp_supplier_order 4969 4969 0 0.00 5 25848 1305 0 0
srv_aggregate_perf_data 90 90 0 0.00 1783 100994 15568 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1097 130157 38417 0 0
srv_find_qd_qs_mism 892210 892210 0 0.00 0 20306 7 0 0
srv_make_invnt_saldo 511 511 0 0.00 32 26987 1027 0 0
srv_make_money_saldo 756 756 0 0.00 0 3340 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 243361 330419 274264 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4392 4392 0 0.00 0 6289 175 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 7347 87 0 0
t$perf-norm:sp_cancel_client_order 1539 1539 0 0.00 0 5646 16 0 0
t$perf-norm:sp_cancel_customer_reserve 620 620 0 0.00 0 4651 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 1509 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 367 367 0 0.00 0 1331 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 368 368 0 0.00 0 643 12 0 0
t$perf-norm:sp_cancel_supplier_order 359 359 0 0.00 0 22053 1553 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 6016 12 0 0
t$perf-norm:sp_client_order 18454 18454 0 0.00 0 18620 18 0 0
t$perf-norm:sp_customer_reserve 948 948 0 0.00 0 4409 12 0 0
t$perf-norm:sp_pay_from_customer 6327 6327 0 0.00 0 14146 12 0 0
t$perf-norm:sp_pay_to_supplier 5232 5232 0 0.00 0 3410 11 0 0
t$perf-norm:sp_reserve_write_off 8950 8950 0 0.00 0 14528 16 0 0
t$perf-norm:sp_supplier_invoice 4782 4782 0 0.00 0 4761 18 0 0
t$perf-norm:sp_supplier_order 4969 4969 0 0.00 0 11389 21 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 140 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 14 1 0 0
t$perf-norm:srv_make_invnt_saldo 511 511 0 0.00 0 2324 36 0 0
t$perf-norm:srv_make_money_saldo 756 756 0 0.00 0 2704 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9036 8722 314 3.47 0 5453 19 0 314
v_all_customers 33910 33910 0 0.00 0 156 1 0 0
v_all_suppliers 27822 27822 0 0.00 0 158 1 0 0
v_all_wares 36908 36908 0 0.00 0 156 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 2979 13 0 0
v_cancel_client_order 3078 3078 0 0.00 0 3934 12 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 3562 10 0 0
v_cancel_customer_reserve 1240 1240 0 0.00 0 2998 11 0 0
v_cancel_payment_to_supplier 734 734 0 0.00 0 3442 12 0 0
v_cancel_supplier_invoice 764 736 28 3.66 0 4091 28 0 28
v_cancel_supplier_order 718 718 0 0.00 0 1053 6 0 0
v_cancel_write_off 1680 1680 0 0.00 0 2085 16 0 0
v_max_id_clo_ord 4966 4966 0 0.00 0 5063 3 0 0
v_max_id_clo_res 948 948 0 0.00 0 2505 7 0 0
v_max_id_ord_sup 4776 4776 0 0.00 0 3781 3 0 0
v_max_non_paid_invoice 1062 1062 0 0.00 0 902 4 0 0
v_max_non_paid_realizn 3177 3177 0 0.00 0 1888 5 0 0
v_min_id_clo_ord 4966 4966 0 0.00 0 2318 6 0 0
v_min_id_clo_res 948 948 0 0.00 0 1679 8 0 0
v_min_id_ord_sup 4776 4776 0 0.00 0 6780 9 0 0
v_min_non_paid_invoice 5231 5231 0 0.00 0 6540 13 0 0
v_min_non_paid_realizn 6327 6327 0 0.00 0 5509 15 0 0
v_our_firm 9298 9298 0 0.00 0 156 1 0 0
v_reserve_write_off 17900 17900 0 0.00 0 2762 7 0 0
x_lock_depdocs_on_canc_invoice 9144 9144 0 0.00 0 11350 135 0 0
x_lock_depdocs_on_canc_sup_ord 359 359 0 0.00 0 26147 412 0 0
x_make_qstorno_1000_1200 4969 4969 0 0.00 2 25817 1216 0 0
x_make_qstorno_1200_2000 4782 4782 0 0.00 3 86264 3194 0 0
x_make_qstorno_2100_3300 421297 421297 0 0.00 0 77646 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2024 19:10:54 to 05-04-2024 19:10:58.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:49 3 8192000000 8797968240 8809054208 4624720 0.056 2 1 2 0 4724320 56816 42784
17:10:50 12126 8192000000 9866766176 10170150912 957350512 10.463 100 86 172 0 986568224 5659424 23558288
17:12:06 15747 8192000000 9920538432 10234228736 1001025632 10.888 100 86 170 0 1030178016 6928080 22224304
17:13:25 19070 8192000000 9961388896 10288967680 1047642864 11.338 100 86 172 0 1078090192 8607936 21839392
17:14:48 11650 8192000000 10007595088 10351525888 1096111472 11.801 100 76 151 0 1123006432 8824496 18070464
17:16:03 6119 8192000000 10078347520 10431516672 1160645360 12.409 100 85 170 0 1192534416 11767520 20121536
17:17:14 3692 8192000000 10119253248 10483134464 1210686448 12.875 100 82 164 0 1241090368 12316464 18087456
17:18:20 3243 8192000000 10152458128 10525384704 1234831024 13.099 100 88 174 1 1267913872 13363008 19719840
17:19:27 1430 8192000000 10175083328 10550566912 1259588448 13.326 100 87 171 0 1291060656 12778384 18693824
17:20:30 1383 8192000000 10205857344 10589261824 1292076272 13.623 100 84 168 0 1321961552 11353072 18532208
17:21:34 10701 8192000000 10209833648 10600427520 1300548896 13.700 100 85 169 2 1331085040 11394736 19141408
17:22:46 6167 8192000000 10205013232 10608021504 1309232656 13.779 100 44 88 0 1328907184 10108256 9566272
17:23:53 64616 8192000000 10207448928 10631188480 1325293936 13.925 100 36 73 0 1339288016 5115728 8878352
17:26:01 4831 8192000000 10231732048 10644275200 1332162560 13.987 100 27 55 0 1343869216 5069312 6637344
17:27:09 9023 8192000000 10223399296 10647449600 1337733408 14.037 100 27 52 2 1350064304 5821792 6509104
17:28:19 58885 8192000000 10217990512 10645618688 1317039136 13.850 98 32 65 0 1334552560 8924448 8588976
17:30:29 21565 8192000000 10238171424 10647625728 1318094464 13.859 98 46 92 0 1337256272 8967216 10194592
17:31:54 19266 8192000000 10259192000 10667945984 1349399888 14.142 100 52 105 1 1371595056 10505312 11689856
17:33:18 8081 8192000000 10267577648 10681245696 1354397856 14.187 99 46 86 0 1376714288 12745056 9571376
17:34:41 79381 8192000000 10231993872 10643337216 1274793664 13.465 95 41 82 0 1301936880 17304128 9839088
17:37:10 43354 8192000000 10231537440 10653179904 1285901120 13.567 96 34 66 0 1311501408 17384960 8215328
17:38:59 13059 8192000000 10245219744 10649169920 1302846032 13.721 98 51 98 2 1327772576 13892400 11034144
17:40:18 11245 8192000000 10257009744 10663448576 1334040000 14.004 99 52 102 0 1363214368 17373072 11801296
17:41:42 3820 8192000000 10228333408 10618884096 1296327824 13.662 98 73 142 2 1331308720 17368784 17612112
17:42:52 5184 8192000000 10274399248 10666700800 1339132368 14.050 100 70 136 1 1383237568 27702464 16402736
17:44:02 8040 8192000000 10287025232 10685792256 1345805472 14.110 100 69 138 0 1392445248 30028752 16611024
17:45:19 2586 8192000000 10300462000 10694344704 1352010576 14.166 100 83 168 1 1405566656 33874096 19681984
17:46:26 1430 8192000000 10306000992 10706583552 1359530576 14.233 100 80 158 1 1413023584 33694736 19798272
17:47:35 4483 8192000000 10330763056 10728636416 1374802784 14.370 100 80 153 1 1431895792 37555360 19537648
17:48:45 1957 8192000000 10340809184 10743787520 1386967648 14.479 100 83 164 0 1444137472 37638064 19531760
17:49:50 1611 8192000000 10326693408 10737397760 1379702912 14.414 100 56 112 1 1431060144 35977232 15380000
17:50:57 1093 8192000000 10362649664 10769453056 1393906432 14.541 100 92 182 2 1464764480 47196560 23661488
17:52:01 19115 8192000000 10324419792 10759327744 1400516736 14.600 100 31 62 0 1439120848 30293456 8310656
17:53:24 20193 8192000000 10325051104 10760904704 1388377728 14.491 100 25 50 2 1435812896 39907296 7527872
17:54:59 14756 8192000000 10324256352 10757570560 1385599808 14.467 100 38 76 0 1431678480 36176800 9901872
17:56:18 40547 8192000000 10294798848 10752643072 1384441120 14.456 100 13 26 0 1412114016 23847296 3825600
17:58:01 54715 8192000000 10305381552 10745073664 1391876656 14.523 100 28 55 0 1413492352 15238384 6377312
18:00:00 78623 8192000000 10315260432 10745573376 1379582672 14.413 99 14 24 2 1391364736 8972416 2809648
18:02:21 16015 8192000000 10318390240 10762293248 1398424192 14.581 100 24 47 0 1413779584 10929088 4426304
18:03:37 116926 8192000000 10311008528 10770587648 1391444384 14.519 99 20 40 0 1411788240 15158400 5185456
18:06:37 24827 8192000000 10336794928 10768990208 1406787728 14.655 100 53 107 2 1426232160 7170304 12274128
18:08:02 28717 8192000000 10300998784 10762706944 1403266880 14.624 100 21 42 0 1422526576 14352768 4906928
18:09:45 18807 8192000000 10317085680 10763292672 1400894352 14.603 99 34 68 1 1422089712 13009728 8185632
18:11:05 30730 8192000000 10322219088 10769809408 1392926016 14.532 99 40 80 0 1426269520 24372224 8971280
18:12:37 53177 8192000000 10286195632 10744348672 1363440992 14.268 97 25 50 0 1383595600 14308752 5845856
18:14:35 29764 8192000000 10271874480 10716807168 1348748464 14.136 98 13 26 0 1364470624 12557728 3164432
18:16:07 63413 8192000000 10287883584 10728763392 1372118592 14.346 99 45 90 0 1394437440 11682304 10636544
18:18:12 71600 8192000000 10268097360 10715930624 1278649456 13.501 93 14 28 0 1297133488 15998656 2485376
18:20:25 41605 8192000000 10251361792 10705559552 1347143856 14.122 99 17 34 0 1361473104 10308688 4020560
18:22:13 22763 8192000000 10262703088 10701393920 1326840128 13.939 97 29 58 0 1343397856 10292128 6265600
18:23:36 35775 8192000000 10240512848 10678689792 1288796768 13.593 96 31 62 0 1306710336 10976304 6937264
18:25:17 79045 8192000000 10259861600 10696630272 1323405168 13.908 98 24 47 0 1340014880 11474752 5134960
18:27:59 39194 8192000000 10269325472 10716307456 1349365088 14.142 99 32 63 0 1372026544 15322544 7338912
18:29:40 119910 8192000000 10247035936 10689982464 1230189808 13.056 91 15 30 2 1251258912 17842528 3226576
18:32:41 97741 8192000000 10247474688 10695712768 1337499760 14.035 99 16 31 0 1350195200 9249840 3445600
18:35:20 11982 8192000000 10261328192 10704732160 1358388560 14.223 100 37 71 0 1377767248 11575600 7803088
18:36:32 37972 8192000000 10246913824 10703192064 1333524096 13.999 98 6 12 1 1344866512 9900880 1441536
18:38:11 54064 8192000000 10257653696 10706001920 1356912912 14.210 100 19 38 0 1371247152 9850352 4483888
18:40:13 67150 8192000000 10272867984 10725244928 1361339296 14.249 99 14 26 1 1374068320 9898432 2830592
18:43:01 40760 8192000000 10294352480 10742448128 1379590528 14.413 99 20 38 1 1394379984 10471328 4318128
18:44:54 58886 8192000000 10290686784 10745290752 1389335280 14.500 100 19 38 0 1414622192 20631616 4655296
18:46:57 23281 8192000000 10299122960 10744414208 1380473136 14.421 99 31 62 1 1396401696 8995312 6933248
18:48:25 11810 8192000000 10296194352 10739998720 1389089024 14.498 100 26 52 0 1403675376 9149936 5436416
18:49:39 25600 8192000000 10314800144 10749288448 1393944912 14.541 100 47 94 0 1416075824 12302464 9828448
18:51:06 44991 8192000000 10316291520 10770419712 1399558832 14.591 100 25 50 0 1421832384 16950160 5323392
18:52:53 32473 8192000000 10296249872 10733899776 1341259728 14.069 96 38 76 0 1361612848 11960368 8392752
18:54:26 130157 8192000000 10277206624 10725601280 1330356608 13.970 96 21 42 0 1346497744 11610432 4530704
18:57:37 61815 8192000000 10282234192 10739834880 1375386592 14.375 100 24 46 0 1398713168 17672080 5654496
18:59:43 70735 8192000000 10263308976 10721120256 1348466864 14.134 98 16 32 0 1366639840 14369360 3803616
19:02:10 61668 8192000000 10267750480 10727206912 1369429344 14.322 100 13 24 0 1385574608 13002320 3142944
19:04:19 26579 8192000000 10275363472 10712154112 1305514768 13.745 95 32 64 0 1320938704 8284864 7139072
19:05:46 43254 8192000000 10273982432 10723430400 1336654048 14.027 98 16 33 0 1355212976 14791856 3767072
19:07:30 65697 8192000000 10280062672 10734628864 1349083456 14.139 99 12 23 0 1366472304 15250256 2138592
19:09:40 15178 8192000000 8923330256 9080553472 91812880 1.108 8 1 2 0 97514160 5658928 42352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 157 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2024 19:11:15 to 05-04-2024 19:11:17.

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          180613
MON$OLDEST_ACTIVE               180614
MON$OLDEST_SNAPSHOT             180614
MON$NEXT_TRANSACTION            180614
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                       1901536
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 Fri Apr  5 19:11:18 2024 
 
Database header page information: 
    Flags            0 
    Generation        94042 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180613 
    Oldest active        180614 
    Oldest snapshot        180614 
    Next transaction    180615 
    Sequence number        0 
    Next attachment ID    726 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.07, total records: 7819027 
    Average version length: 48.16, total versions: 134762, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86808 
    Data pages: 86808, average fill: 72% 
    Primary pages: 86808, secondary pages: 0, swept pages: 14039 
    Empty pages: 3, full pages: 69776 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 88 
    40 - 59% = 1011 
    60 - 79% = 85629 
    80 - 99% = 65 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23433, nodes: 7819027 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1753350, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 366 
        20 - 39% = 1681 
        40 - 59% = 4228 
        60 - 79% = 2331 
        80 - 99% = 14827 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13589, nodes: 7819027 
    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: 1575532, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1493 
        40 - 59% = 2132 
        60 - 79% = 1076 
        80 - 99% = 8888 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8394, nodes: 7819027 
    Average node length: 6.63, total dup: 5829606, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1568232, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 865 
        40 - 59% = 1496 
        60 - 79% = 871 
        80 - 99% = 5029 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.72, total records: 2280351 
    Average version length: 34.55, total versions: 137232, max versions: 3 
    Average fragment length: 4.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28320 
    Data pages: 28320, average fill: 75% 
    Primary pages: 28315, secondary pages: 5, swept pages: 7956 
    Empty pages: 1, full pages: 22462 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 55 
    40 - 59% = 680 
    60 - 79% = 26047 
    80 - 99% = 1531 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4590, nodes: 2280351 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 710216, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 884 
        40 - 59% = 881 
        60 - 79% = 685 
        80 - 99% = 2140 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2531, nodes: 2283447 
    Average node length: 4.97, total dup: 2282548, max dup: 19027 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1263057, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 205 
        40 - 59% = 1578 
        60 - 79% = 567 
        80 - 99% = 177 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2061, nodes: 2280351 
    Average node length: 4.97, total dup: 2280301, max dup: 130528 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1065956, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 34 
        40 - 59% = 1164 
        60 - 79% = 52 
        80 - 99% = 803 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4398, nodes: 2280351 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 710216, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 538 
        40 - 59% = 669 
        60 - 79% = 762 
        80 - 99% = 2304 
 
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.25, total records: 400 
    Average version length: 22.98, total versions: 241393, max versions: 636 
    Average fragment length: 2.00, total fragments: 59, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1344 
    Data pages: 1344, average fill: 89% 
    Primary pages: 11, secondary pages: 1333, swept pages: 0 
    Empty pages: 4, full pages: 1338 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1337 
 
    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: 11.05, total records: 131782 
    Average version length: 68.30, total versions: 110473, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.96 
    Pointer pages: 6, data page slots: 3272 
    Data pages: 1992, average fill: 81% 
    Primary pages: 1991, secondary pages: 1, swept pages: 0 
    Empty pages: 60, full pages: 1685 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 64 
    40 - 59% = 96 
    60 - 79% = 248 
    80 - 99% = 1493 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1693165, depth: 3, leaf buckets: 378, nodes: 131782 
    Average node length: 13.04, total dup: 10588, max dup: 2 
    Average key length: 10.57, compression ratio: 2.55 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 96263, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 265 
        60 - 79% = 88 
        80 - 99% = 20 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18919, max versions: 1026 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 62 
 
    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: 4.40, total records: 2081 
    Average version length: 43.72, total versions: 1872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 13.18 
    Pointer pages: 1, data page slots: 32 
    Data pages: 28, average fill: 70% 
    Primary pages: 27, secondary pages: 1, swept pages: 2 
    Empty pages: 4, full pages: 19 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92416, depth: 2, leaf buckets: 4, nodes: 2081 
    Average node length: 4.27, total dup: 1983, max dup: 260 
    Average key length: 2.50, compression ratio: 7.60 
    Average prefix length: 18.55, average data length: 0.45 
    Clustering factor: 1026, ratio: 0.49 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, 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.15 
    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.83, total records: 809680 
    Average version length: 25.46, total versions: 78344, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8144, average fill: 70% 
    Primary pages: 8126, secondary pages: 18, swept pages: 1216 
    Empty pages: 98, full pages: 7457 
    Fill distribution: 
     0 - 19% = 195 
    20 - 39% = 130 
    40 - 59% = 99 
    60 - 79% = 7413 
    80 - 99% = 307 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 886, nodes: 809680 
    Average node length: 4.87, total dup: 809631, max dup: 147812 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90511, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 121 
        40 - 59% = 488 
        60 - 79% = 216 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 964, nodes: 809680 
    Average node length: 5.88, total dup: 720888, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161880, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 105 
        40 - 59% = 465 
        60 - 79% = 104 
        80 - 99% = 288 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1007, nodes: 809680 
    Average node length: 5.88, total dup: 720888, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163859, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 204 
        40 - 59% = 430 
        60 - 79% = 81 
        80 - 99% = 292 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1142, nodes: 809680 
    Average node length: 5.96, total dup: 720888, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156750, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 229 
        40 - 59% = 625 
        60 - 79% = 194 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5510 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.58, total fragments: 67, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 77, secondary pages: 19, swept pages: 55 
    Empty pages: 12, full pages: 65 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5510 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.08 
    Average prefix length: 34.52, average data length: 1.54 
    Clustering factor: 5247, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        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: 5510 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 141, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 82178 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 792 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 792 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32251, depth: 2, leaf buckets: 107, nodes: 82178 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3225, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 150.23, total records: 152597 
    Average version length: 146.68, total versions: 518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3664, average fill: 86% 
    Primary pages: 3663, secondary pages: 1, swept pages: 14 
    Empty pages: 46, full pages: 3602 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 8 
    80 - 99% = 3600 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.79, total records: 167022 
    Average version length: 145.66, total versions: 394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 4000, average fill: 86% 
    Primary pages: 4000, secondary pages: 0, swept pages: 3 
    Empty pages: 32, full pages: 3951 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3951 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.93, total records: 158437 
    Average version length: 139.56, total versions: 102, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 6, data page slots: 3976 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3808, secondary pages: 0, swept pages: 2 
    Empty pages: 47, full pages: 3749 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3749 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 150.08, total records: 167584 
    Average version length: 151.41, total versions: 1152, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 4328 
    Data pages: 4040, average fill: 85% 
    Primary pages: 4039, secondary pages: 1, swept pages: 7 
    Empty pages: 54, full pages: 3963 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 3962 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 120.95, total records: 173620 
    Average version length: 155.28, total versions: 34228, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.02 
    Pointer pages: 6, data page slots: 4776 
    Data pages: 4224, average fill: 87% 
    Primary pages: 4224, secondary pages: 0, swept pages: 4 
    Empty pages: 74, full pages: 4108 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 7 
    40 - 59% = 25 
    60 - 79% = 9 
    80 - 99% = 4106 
 
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: 166669 
    Average version length: 154.80, total versions: 6328, 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: 9, data page slots: 5056 
    Data pages: 4000, average fill: 86% 
    Primary pages: 4000, secondary pages: 0, swept pages: 5 
    Empty pages: 39, full pages: 3942 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3942 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 150.08, total records: 164299 
    Average version length: 153.14, total versions: 1228, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 5616 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3967, secondary pages: 1, swept pages: 5 
    Empty pages: 57, full pages: 3888 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3887 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.72, total records: 155796 
    Average version length: 153.00, total versions: 2217, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5512 
    Data pages: 3776, average fill: 85% 
    Primary pages: 3776, secondary pages: 0, swept pages: 7 
    Empty pages: 74, full pages: 3679 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3678 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.34, total records: 163492 
    Average version length: 153.14, total versions: 3065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 3944 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 4 
    Empty pages: 31, full pages: 3870 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3869 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.60, total records: 163551 
    Average version length: 149.62, total versions: 397, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 5040 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 3867 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3868 
 
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: 51.37, total records: 2128365 
    Average version length: 53.01, total versions: 55594, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25520 
    Data pages: 25512, average fill: 72% 
    Primary pages: 25512, secondary pages: 0, swept pages: 9745 
    Empty pages: 221, full pages: 21538 
    Fill distribution: 
     0 - 19% = 413 
    20 - 39% = 336 
    40 - 59% = 868 
    60 - 79% = 23370 
    80 - 99% = 525 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2608, nodes: 2128365 
    Average node length: 5.44, total dup: 1986871, max dup: 1576 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184050, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 294 
        40 - 59% = 1721 
        60 - 79% = 285 
        80 - 99% = 307 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2128365 
    Average node length: 5.69, total dup: 1910860, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380372, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2383 
        60 - 79% = 339 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2201, nodes: 2128365 
    Average node length: 4.96, total dup: 2128265, max dup: 28802 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 181431, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 191 
        40 - 59% = 1245 
        60 - 79% = 386 
        80 - 99% = 377 
 
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: 36.71, total records: 150855 
    Average version length: 69.18, total versions: 70851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.43 
    Pointer pages: 3, data page slots: 4264 
    Data pages: 2920, average fill: 60% 
    Primary pages: 2920, secondary pages: 0, swept pages: 339 
    Empty pages: 485, full pages: 1992 
    Fill distribution: 
     0 - 19% = 688 
    20 - 39% = 130 
    40 - 59% = 66 
    60 - 79% = 683 
    80 - 99% = 1353 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101533, depth: 3, leaf buckets: 224, nodes: 150855 
    Average node length: 6.44, total dup: 131252, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25872, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 102 
        60 - 79% = 70 
        80 - 99% = 11 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.25, total records: 7208761 
    Average version length: 68.81, total versions: 491535, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 62, data page slots: 100600 
    Data pages: 100600, average fill: 77% 
    Primary pages: 100600, secondary pages: 0, swept pages: 16494 
    Empty pages: 4, full pages: 93045 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 416 
    40 - 59% = 2363 
    60 - 79% = 86400 
    80 - 99% = 11384 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10584, nodes: 7208761 
    Average node length: 6.51, total dup: 6236781, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1614178, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1465 
        40 - 59% = 5476 
        60 - 79% = 2996 
        80 - 99% = 643 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8561, nodes: 7208761 
    Average node length: 5.39, total dup: 6924264, max dup: 171 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1400996, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1018 
        40 - 59% = 4755 
        60 - 79% = 1744 
        80 - 99% = 1033 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8653, nodes: 7208761 
    Average node length: 5.39, total dup: 6924264, max dup: 171 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1403639, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1163 
        40 - 59% = 4746 
        60 - 79% = 1709 
        80 - 99% = 1029 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.75, total records: 12153414 
    Average version length: 68.75, total versions: 388069, 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: 103, data page slots: 166816 
    Data pages: 166816, average fill: 77% 
    Primary pages: 166816, secondary pages: 0, swept pages: 65764 
    Empty pages: 7, full pages: 164883 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 110 
    40 - 59% = 602 
    60 - 79% = 157040 
    80 - 99% = 9047 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18342, nodes: 12153414 
    Average node length: 6.58, total dup: 10594919, max dup: 61 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2393271, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2266 
        40 - 59% = 10462 
        60 - 79% = 4738 
        80 - 99% = 853 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.07, total records: 1853296 
    Average version length: 69.10, total versions: 859833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.40 
    Pointer pages: 27, data page slots: 43240 
    Data pages: 28656, average fill: 75% 
    Primary pages: 28655, secondary pages: 1, swept pages: 4007 
    Empty pages: 1559, full pages: 23726 
    Fill distribution: 
     0 - 19% = 2321 
    20 - 39% = 967 
    40 - 59% = 993 
    60 - 79% = 9523 
    80 - 99% = 14852 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2299, nodes: 1853296 
    Average node length: 5.50, total dup: 1778539, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 126185, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 348 
        40 - 59% = 1106 
        60 - 79% = 646 
        80 - 99% = 187 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.45, total records: 1309033 
    Average version length: 69.10, total versions: 655646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.66 
    Pointer pages: 21, data page slots: 33456 
    Data pages: 26336, average fill: 58% 
    Primary pages: 26336, secondary pages: 0, swept pages: 5173 
    Empty pages: 5049, full pages: 16933 
    Fill distribution: 
     0 - 19% = 7114 
    20 - 39% = 1036 
    40 - 59% = 544 
    60 - 79% = 5543 
    80 - 99% = 12099 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1625, nodes: 1309033 
    Average node length: 5.78, total dup: 1222977, max dup: 101 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 180901, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 160 
        40 - 59% = 778 
        60 - 79% = 520 
        80 - 99% = 162 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.94, total records: 9452622 
    Average version length: 68.97, total versions: 680639, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 89, data page slots: 144536 
    Data pages: 144536, average fill: 70% 
    Primary pages: 144536, secondary pages: 0, swept pages: 41834 
    Empty pages: 335, full pages: 87455 
    Fill distribution: 
     0 - 19% = 1106 
    20 - 39% = 5044 
    40 - 59% = 19486 
    60 - 79% = 107041 
    80 - 99% = 11859 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13533, nodes: 9452622 
    Average node length: 6.68, total dup: 7841476, max dup: 17 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2049930, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1175 
        40 - 59% = 6517 
        60 - 79% = 4881 
        80 - 99% = 958 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21194621 
    Average version length: 82.89, total versions: 18878, 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: 319368 
    Data pages: 319368, average fill: 81% 
    Primary pages: 319368, secondary pages: 0, swept pages: 12406 
    Empty pages: 16, full pages: 318919 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 13 
    40 - 59% = 45 
    60 - 79% = 27326 
    80 - 99% = 291951 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19511, nodes: 21194621 
    Average node length: 5.72, total dup: 20712864, max dup: 146 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288160, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8317 
        60 - 79% = 577 
        80 - 99% = 10611 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17205, nodes: 21194621 
    Average node length: 6.31, total dup: 18626788, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915610, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 765 
        60 - 79% = 280 
        80 - 99% = 16154 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21261, nodes: 21194621 
    Average node length: 6.35, total dup: 18544782, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582903, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8501 
        60 - 79% = 672 
        80 - 99% = 12082 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16177, nodes: 21194621 
    Average node length: 5.56, total dup: 21194521, max dup: 230407 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944493, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2977 
        60 - 79% = 408 
        80 - 99% = 12782 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.04, total records: 9870931 
    Average version length: 82.65, total versions: 644119, 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: 105, data page slots: 171072 
    Data pages: 171064, average fill: 71% 
    Primary pages: 171064, secondary pages: 0, swept pages: 57016 
    Empty pages: 449, full pages: 107371 
    Fill distribution: 
     0 - 19% = 1452 
    20 - 39% = 6558 
    40 - 59% = 24434 
    60 - 79% = 67223 
    80 - 99% = 71397 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11393, nodes: 9870931 
    Average node length: 5.37, total dup: 9560489, max dup: 234 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2195048, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 84 
        40 - 59% = 7675 
        60 - 79% = 3535 
        80 - 99% = 97 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13670, nodes: 9870931 
    Average node length: 6.24, total dup: 8184146, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1530283, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 3820 
        40 - 59% = 4449 
        60 - 79% = 2664 
        80 - 99% = 2592 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12705, nodes: 9870931 
    Average node length: 5.98, total dup: 8571275, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2387647, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 87 
        40 - 59% = 8683 
        60 - 79% = 3778 
        80 - 99% = 155 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10295, nodes: 9870931 
    Average node length: 5.14, total dup: 9870831, max dup: 151732 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1570319, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1159 
        40 - 59% = 5271 
        60 - 79% = 1708 
        80 - 99% = 2112 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.63, total records: 11504145 
    Average version length: 82.57, total versions: 513962, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 118, data page slots: 192432 
    Data pages: 191288, average fill: 74% 
    Primary pages: 191288, secondary pages: 0, swept pages: 61657 
    Empty pages: 3003, full pages: 149241 
    Fill distribution: 
     0 - 19% = 4963 
    20 - 39% = 6281 
    40 - 59% = 15186 
    60 - 79% = 40843 
    80 - 99% = 124015 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13125, nodes: 11504145 
    Average node length: 5.30, total dup: 11394287, max dup: 648 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2403109, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 8657 
        60 - 79% = 4174 
        80 - 99% = 192 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10550, nodes: 11504145 
    Average node length: 5.50, total dup: 11003543, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 730357, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 785 
        40 - 59% = 2653 
        60 - 79% = 1811 
        80 - 99% = 5153 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15007, nodes: 11504145 
    Average node length: 6.02, total dup: 10045986, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2419689, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 123 
        40 - 59% = 10122 
        60 - 79% = 4521 
        80 - 99% = 239 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10998, nodes: 11504145 
    Average node length: 5.22, total dup: 11504045, max dup: 203072 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 719268, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 808 
        40 - 59% = 5065 
        60 - 79% = 1448 
        80 - 99% = 3569 
 
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: 77.45, total records: 9981454 
    Average version length: 82.93, total versions: 638121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 175136 
    Data pages: 175104, average fill: 71% 
    Primary pages: 175104, secondary pages: 0, swept pages: 61788 
    Empty pages: 803, full pages: 107747 
    Fill distribution: 
     0 - 19% = 2038 
    20 - 39% = 7414 
    40 - 59% = 26310 
    60 - 79% = 68921 
    80 - 99% = 70421 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12007, nodes: 9981454 
    Average node length: 5.18, total dup: 9952410, max dup: 2432 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2001067, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1437 
        40 - 59% = 7953 
        60 - 79% = 1995 
        80 - 99% = 592 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13787, nodes: 9981454 
    Average node length: 6.25, total dup: 8275270, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1491516, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 3822 
        40 - 59% = 4463 
        60 - 79% = 2637 
        80 - 99% = 2690 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12695, nodes: 9981454 
    Average node length: 5.44, total dup: 9537999, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2135759, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1439 
        40 - 59% = 8942 
        60 - 79% = 1726 
        80 - 99% = 557 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10418, nodes: 9981454 
    Average node length: 5.15, total dup: 9981354, max dup: 154169 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1589064, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1222 
        40 - 59% = 5231 
        60 - 79% = 1754 
        80 - 99% = 2178 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.28, total records: 578970 
    Average version length: 68.77, total versions: 7620, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 75% 
    Primary pages: 8048, secondary pages: 0, swept pages: 3663 
    Empty pages: 7, full pages: 6844 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 24 
    40 - 59% = 241 
    60 - 79% = 7638 
    80 - 99% = 134 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35175, depth: 3, leaf buckets: 751, nodes: 578970 
    Average node length: 5.95, total dup: 492774, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101033, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 541 
        60 - 79% = 104 
        80 - 99% = 80 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32749, depth: 3, leaf buckets: 767, nodes: 578970 
    Average node length: 6.15, total dup: 474880, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101081, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 542 
        60 - 79% = 95 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 578970 
    Average node length: 4.86, total dup: 578870, max dup: 9431 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89702, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 328 
        60 - 79% = 96 
        80 - 99% = 114 
 
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 Fri Apr  5 19:11:41 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7819027 134762 1 0.0000 0.0000
DOC_LIST 2280351 137232 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 241393 636 60300.0000 0.0000
INVNT_TURNOVER_LOG 131782 110473 1 0.0000 0.0000
MONEY_SALDO 49 18919 1026 38600.0000 0.0000
MONEY_TURNOVER_LOG 2081 1872 1 0.0000 0.0000
PDISTR 809680 78344 4 0.0000 0.0000
PERF_SPLIT_0 152597 518 1 0.0000 0.0000
PERF_SPLIT_1 167022 394 1 0.0000 0.0000
PERF_SPLIT_2 158437 102 1 0.0000 0.0000
PERF_SPLIT_3 167584 1152 1 0.0000 0.0000
PERF_SPLIT_4 173620 34228 1 0.0000 0.0000
PERF_SPLIT_5 166669 6328 1 0.0000 0.0000
PERF_SPLIT_6 164299 1228 1 0.0000 0.0000
PERF_SPLIT_7 155796 2217 1 0.0000 0.0000
PERF_SPLIT_8 163492 3065 1 0.0000 0.0000
PERF_SPLIT_9 163551 397 1 0.0000 0.0000
PSTORNED 2128365 55594 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150855 70851 1 0.0000 0.0000
XQD_1000_3300 7208761 491535 1 0.0000 0.0000
XQD_1200_2000 12153414 388069 1 0.0000 0.0000
XQD_2000_3300 1853296 859833 1 0.0000 0.0000
XQD_2100_3300 1309033 655646 1 0.0000 0.0000
XQD_3300_3400 9452622 680639 1 0.0000 0.0000
XQS_1000_1200 21194621 18878 1 0.0000 0.0000
XQS_1000_3300 9870931 644119 1 0.0000 0.0000
XQS_1200_2000 11504145 513962 1 0.0000 0.0000
XQS_2100_3300 9981454 638121 1 0.0000 0.0000
XQS_3300_3400 578970 7620 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 ---
:823: 
:824: mscs-test-161.budzdorov.ru    Fri Apr  5 19:09:59 2024
:825:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:826: 
--- end of diff output ---

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

05.04.24 19:11:53. 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-04-05 19:11:56 No severe PSQL-related problems occured
05.04.24 19:11:57. End of report.