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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-27 13:07:53
DTS_END                         2024-03-27 13:07:53.6720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/52956
TRN_ID                          167997
ATT_ID                          500
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: 9192.00 17750 919200
customer order: creation 175.73 394 17573
customer order: refuse 14.84 378 1484
order to supplier: creation 45.60 1299 4560
order to supplier: removal 3.67 80460 367
invoice (draft): creation 46.41 3338 4641
invoice (draft): removal 49.28 668 4928
invoice accept: apply 42.83 20990 4283
invoice accept: cancel 44.42 831 4442
customer reserve: creation 4104.20 203 410420
customer reserve: removal 4360.36 54 436036
realization accept: apply 84.68 186 8468
realization accept: cancel 91.37 126 9137
payment from customer: creation 59.28 109 5928
payment from customer: removal 5.67 85 567
payment to supplier: creation 49.26 122 4926
payment to supplier: removal 3.03 50 303
service: total inventory turnovers 3.65 4062 365
service: total monetary turnovers 6.61 565 661
service: aggregate perf. data 1.08 13036 108
service: refresh index statistics 0.03 228044 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2024 13:09:46 to 27-03-2024 13:09:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5608
TEST_TIME 2 4082
TEST_TIME 3 5099
TEST_TIME 4 5255
TEST_TIME 5 5459
TEST_TIME 6 5304
TEST_TIME 7 5805
TEST_TIME 8 5770
TEST_TIME 9 5973
TEST_TIME 10 6779
TEST_TIME 11 6789
TEST_TIME 12 7255
TEST_TIME 13 7588
TEST_TIME 14 7830
TEST_TIME 15 7791
TEST_TIME 16 8026
TEST_TIME 17 8074
TEST_TIME 18 8206
TEST_TIME 19 8143
TEST_TIME 20 8393
TEST_TIME 21 8527
TEST_TIME 22 8698
TEST_TIME 23 8982
TEST_TIME 24 9678
TEST_TIME 25 9800
TEST_TIME 26 9630
TEST_TIME 27 9391
TEST_TIME 28 9657
TEST_TIME 29 9528
TEST_TIME 30 9388
TEST_TIME 31 9394
TEST_TIME 32 9117
TEST_TIME 33 9348
TEST_TIME 34 9343
TEST_TIME 35 9296
TEST_TIME 36 9377
TEST_TIME 37 9281
TEST_TIME 38 9234
TEST_TIME 39 9192
TEST_TIME 40 9068
TEST_TIME 41 9039
TEST_TIME 42 8945
TEST_TIME 43 8940
TEST_TIME 44 8987
TEST_TIME 45 8998
TEST_TIME 46 9058
TEST_TIME 47 9068
TEST_TIME 48 9124
TEST_TIME 49 9146
TEST_TIME 50 9224
TEST_TIME 51 9328
TEST_TIME 52 9298
TEST_TIME 53 9272
TEST_TIME 54 9377
TEST_TIME 55 9492
TEST_TIME 56 9534
TEST_TIME 57 9474
TEST_TIME 58 9341
TEST_TIME 59 9258
TEST_TIME 60 9261
TEST_TIME 61 9245
TEST_TIME 62 9226
TEST_TIME 63 9142
TEST_TIME 64 9142
TEST_TIME 65 9293
TEST_TIME 66 9267
TEST_TIME 67 9271
TEST_TIME 68 9289
TEST_TIME 69 9251
TEST_TIME 70 9379
TEST_TIME 71 9417
TEST_TIME 72 9415
TEST_TIME 73 9413
TEST_TIME 74 9483
TEST_TIME 75 9533
TEST_TIME 76 9534
TEST_TIME 77 9441
TEST_TIME 78 9413
TEST_TIME 79 9352
TEST_TIME 80 9379
TEST_TIME 81 9324
TEST_TIME 82 9269
TEST_TIME 83 9286
TEST_TIME 84 9306
TEST_TIME 85 9277
TEST_TIME 86 9297
TEST_TIME 87 9311
TEST_TIME 88 9341
TEST_TIME 89 9409
TEST_TIME 90 9373
TEST_TIME 91 9446
TEST_TIME 92 9415
TEST_TIME 93 9469
TEST_TIME 94 9426
TEST_TIME 95 9378
TEST_TIME 96 9362
TEST_TIME 97 9346
TEST_TIME 98 9290
TEST_TIME 99 9228
TEST_TIME 100 9200

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-03-2024 13:09:50 to 27-03-2024 13:09:53.

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 1294486 1294486 0 0.00 0 22465 7 0 0
doc_list_biud 1294484 1294484 0 0.00 0 60344 23 0 0
sp_add_invoice_to_stock 4392 4283 109 2.48 39 212175 20990 0 109
sp_cancel_adding_invoice 4442 4442 0 0.00 3 63162 832 0 0
sp_cancel_client_order 1484 1484 0 0.00 4 11898 379 0 0
sp_cancel_customer_reserve 436036 436036 0 0.00 0 33240 54 0 0
sp_cancel_pay_from_customer 567 567 0 0.00 3 4379 86 0 0
sp_cancel_pay_to_supplier 303 303 0 0.00 2 841 51 0 0
sp_cancel_supplier_invoice 4937 4928 9 0.18 1 20934 669 0 9
sp_cancel_supplier_order 367 367 0 0.00 7 750760 80461 0 0
sp_cancel_write_off 9137 9137 0 0.00 1 13188 127 0 0
sp_client_order 17573 17573 0 0.00 3 21744 395 0 0
sp_customer_reserve 410420 410420 0 0.00 0 71050 204 0 0
sp_fill_shopping_cart 26762 26762 0 0.00 1 10291 36 0 0
sp_fill_shopping_cart_clo_res 410408 410408 0 0.00 0 22008 17 0 0
sp_get_clo_for_invoice 4267 4267 0 0.00 0 22349 311 0 0
sp_kill_cost_storno 14449 14449 0 0.00 0 13009 65 0 0
sp_kill_qstorno_ret_qs2qd 886504 886504 0 0.00 0 28081 29 0 0
sp_kill_qty_storno 469129 469129 0 0.00 0 60341 63 0 0
sp_lock_selected_doc 17481 17481 0 0.00 0 11851 7 0 0
sp_make_cost_storno 23589 23589 0 0.00 0 15242 54 0 0
sp_multiply_rows_for_pdistr 23589 23589 0 0.00 0 9667 32 0 0
sp_multiply_rows_for_qdistr 17573 17573 0 0.00 0 16065 198 0 0
sp_pay_from_customer 5928 5928 0 0.00 4 12320 109 0 0
sp_pay_to_supplier 4926 4926 0 0.00 4 12123 123 0 0
sp_payment_common 10854 10854 0 0.00 1 11795 22 0 0
sp_qd_handle_on_cancel_clo 1484 1484 0 0.00 0 9380 333 0 0
sp_qd_handle_on_invoice_upd_sts 8709 8709 0 0.00 0 60340 296 0 0
sp_qd_handle_on_reserve_upd_sts 8468 8468 0 0.00 0 10947 58 0 0
sp_reserve_write_off 8468 8468 0 0.00 6 15801 187 0 0
sp_supplier_invoice 4641 4641 0 0.00 7 129473 3339 0 0
sp_supplier_order 4560 4560 0 0.00 4 29499 1300 0 0
srv_aggregate_perf_data 108 108 0 0.00 1905 117132 13037 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2717 93082 39614 0 0
srv_find_qd_qs_mism 875954 875954 0 0.00 0 22465 6 0 0
srv_make_invnt_saldo 365 365 0 0.00 54 88343 4063 0 0
srv_make_money_saldo 661 661 0 0.00 1 12159 566 0 0
srv_recalc_idx_stat 3 3 0 0.00 110980 327598 228044 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4283 4283 0 0.00 0 17891 184 0 0
t$perf-norm:sp_cancel_adding_invoice 345 345 0 0.00 0 5428 162 0 0
t$perf-norm:sp_cancel_client_order 1484 1484 0 0.00 0 4313 14 0 0
t$perf-norm:sp_cancel_customer_reserve 537 537 0 0.00 0 795 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 567 567 0 0.00 0 1162 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 303 303 0 0.00 0 271 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 338 338 0 0.00 0 3980 50 0 0
t$perf-norm:sp_cancel_supplier_order 367 367 0 0.00 0 21911 1347 0 0
t$perf-norm:sp_cancel_write_off 806 806 0 0.00 0 1296 7 0 0
t$perf-norm:sp_client_order 17573 17573 0 0.00 0 26799 17 0 0
t$perf-norm:sp_customer_reserve 846 846 0 0.00 0 517 4 0 0
t$perf-norm:sp_pay_from_customer 5928 5928 0 0.00 0 4322 7 0 0
t$perf-norm:sp_pay_to_supplier 4926 4926 0 0.00 0 3694 10 0 0
t$perf-norm:sp_reserve_write_off 8468 8468 0 0.00 0 26878 13 0 0
t$perf-norm:sp_supplier_invoice 4641 4641 0 0.00 0 5414 16 0 0
t$perf-norm:sp_supplier_order 4560 4560 0 0.00 0 3333 14 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 425 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 1227 28 0 0
t$perf-norm:srv_make_invnt_saldo 365 365 0 0.00 0 339 6 0 0
t$perf-norm:srv_make_money_saldo 661 661 0 0.00 0 1074 11 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 42 21 0 0
v_add_invoice_to_stock 8748 8530 218 2.49 0 5434 17 0 218
v_all_customers 32752 32752 0 0.00 0 27 1 0 0
v_all_suppliers 26026 26026 0 0.00 0 24 1 0 0
v_all_wares 35146 35146 0 0.00 0 130 1 0 0
v_cancel_adding_invoice 690 690 0 0.00 0 212 7 0 0
v_cancel_client_order 2968 2968 0 0.00 0 3390 7 0 0
v_cancel_customer_prepayment 1134 1134 0 0.00 0 1441 7 0 0
v_cancel_customer_reserve 1074 1074 0 0.00 0 2951 10 0 0
v_cancel_payment_to_supplier 606 606 0 0.00 0 259 3 0 0
v_cancel_supplier_invoice 694 676 18 2.59 0 3354 17 0 18
v_cancel_supplier_order 734 734 0 0.00 0 1395 8 0 0
v_cancel_write_off 1612 1612 0 0.00 0 7293 26 0 0
v_max_id_clo_ord 4555 4555 0 0.00 0 510 1 0 0
v_max_id_clo_res 846 846 0 0.00 0 3771 15 0 0
v_max_id_ord_sup 4634 4634 0 0.00 0 6859 6 0 0
v_max_non_paid_invoice 1102 1102 0 0.00 0 416 3 0 0
v_max_non_paid_realizn 2761 2761 0 0.00 0 1619 3 0 0
v_min_id_clo_ord 4555 4555 0 0.00 0 1769 6 0 0
v_min_id_clo_res 846 846 0 0.00 0 2959 15 0 0
v_min_id_ord_sup 4634 4634 0 0.00 0 4478 7 0 0
v_min_non_paid_invoice 4926 4926 0 0.00 0 5049 11 0 0
v_min_non_paid_realizn 5928 5928 0 0.00 0 5049 17 0 0
v_our_firm 8728 8728 0 0.00 0 13 1 0 0
v_reserve_write_off 16936 16936 0 0.00 0 8612 6 0 0
x_lock_depdocs_on_canc_invoice 9032 9032 0 0.00 0 19628 104 0 0
x_lock_depdocs_on_canc_sup_ord 367 367 0 0.00 0 11431 290 0 0
x_make_qstorno_1000_1200 4560 4560 0 0.00 1 29494 1224 0 0
x_make_qstorno_1200_2000 4641 4641 0 0.00 3 125244 3203 0 0
x_make_qstorno_2100_3300 410419 410419 0 0.00 0 71050 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2024 13:09:54 to 27-03-2024 13:09: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
11:07:57 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
11:08:58 33705 8192000000 9724917232 10027753472 806710384 8.964 100 82 164 0 833187440 6954288 19522768
11:10:33 25679 8192000000 9760176176 10070183936 833399248 9.233 100 91 182 0 866376624 11886640 21090736
11:12:01 17006 8192000000 9793044608 10111488000 858837504 9.489 100 86 172 0 897086512 18647008 19602000
11:13:24 12526 8192000000 9842678352 10173145088 891629952 9.815 100 80 159 0 946334304 37524176 17180176
11:14:39 6404 8192000000 9886101568 10228854784 933235040 10.226 100 83 165 0 1001682448 51491696 16955712
11:15:47 5351 8192000000 9925456288 10281406464 968294448 10.570 100 76 150 1 1038206752 55161824 14750480
11:16:54 2721 8192000000 9972784960 10329866240 993661504 10.817 100 85 170 0 1083521280 73466480 16393296
11:18:00 3989 8192000000 9982763616 10351702016 1009255072 10.968 100 71 142 1 1102226672 79122464 13849136
11:19:08 1560 8192000000 10011681136 10384261120 1045059328 11.313 100 87 174 0 1124348752 62224800 17064624
11:20:11 18936 8192000000 9996055840 10379673600 1055392752 11.412 100 53 100 1 1122363344 55908304 11062288
11:21:32 825 8192000000 10041751920 10422976512 1071197520 11.564 100 86 172 0 1157327488 69334608 16795360
11:22:34 9707 8192000000 10004142896 10411544576 1070961488 11.561 100 34 70 0 1128596464 50977952 6657024
11:23:47 4269 8192000000 9998344384 10398289920 1082564880 11.672 100 51 95 0 1114975904 22531536 9879488
11:24:54 18183 8192000000 9984320480 10388664320 1086858880 11.713 100 32 62 3 1123481584 30097520 6525184
11:26:15 20743 8192000000 10019612496 10410926080 1088908784 11.732 100 72 140 0 1125254752 20367664 15978304
11:27:37 3414 8192000000 10007809264 10402611200 1092150912 11.763 100 41 81 1 1111356512 9965152 9240448
11:28:47 11040 8192000000 10055637984 10453987328 1097986768 11.819 100 57 112 0 1157238528 48332240 10919520
11:30:02 40422 8192000000 10060070976 10470158336 1109649552 11.929 100 48 96 1 1179696256 59623888 10422816
11:31:47 10282 8192000000 10064690736 10464780288 1110870544 11.941 100 51 98 0 1171548864 50618816 10059504
11:33:12 12443 8192000000 10072800912 10475651072 1102930272 11.865 99 37 72 0 1190672448 79553232 8188944
11:34:31 18511 8192000000 10073870048 10475585536 1076497472 11.614 98 35 70 0 1178765408 94916000 7351936
11:35:53 9251 8192000000 10087954416 10482520064 1054470304 11.404 98 60 118 1 1178576864 112174016 11932544
11:37:11 7745 8192000000 10092316112 10484535296 1066581360 11.519 99 61 119 0 1194504688 116035008 11888320
11:38:24 8012 8192000000 10080736944 10465062912 1058725152 11.444 98 59 118 0 1172299056 101975008 11598896
11:39:42 3791 8192000000 10130136688 10507546624 1073656672 11.587 99 70 136 0 1231624496 143876832 14090992
11:40:50 3501 8192000000 10150933600 10541465600 1096726048 11.807 99 63 126 0 1244436496 134343184 13367264
11:41:57 2716 8192000000 10177500096 10569367552 1114210560 11.972 100 69 137 0 1277231648 148227216 14793872
11:43:01 3194 8192000000 10239813328 10637225984 1120130912 12.028 100 72 142 0 1334002048 198804784 15066352
11:44:20 7618 8192000000 10245633600 10646786048 1121358832 12.040 100 59 116 0 1352861728 218028544 13474352
11:45:33 2778 8192000000 10257055360 10668597248 1130060400 12.122 100 86 169 0 1352249088 203838352 18350336
11:46:40 6000 8192000000 10280377888 10684456960 1137951536 12.196 100 66 131 0 1382506464 230224656 14330272
11:48:02 18091 8192000000 10271394688 10716622848 1139550848 12.211 100 41 80 0 1383043760 233998512 9494400
11:49:52 12252 8192000000 10252690976 10719535104 1128691040 12.109 100 29 58 0 1362106960 226638160 6777760
11:51:37 65860 8192000000 10049685632 10499317760 1113370816 11.964 99 11 22 0 1221423616 105442672 2610128
11:53:48 17770 8192000000 10139040544 10581389312 1138631872 12.203 100 29 57 1 1218134192 73475760 6026560
11:55:18 25478 8192000000 10169740688 10607034368 1147550064 12.286 100 27 54 0 1247667872 94322976 5794832
11:56:51 56666 8192000000 10179078752 10628857856 1137409824 12.191 99 33 64 0 1267271200 123275824 6585552
11:58:53 85436 8192000000 10156065040 10604724224 1141714800 12.232 100 37 73 0 1263643168 113791376 8136992
12:01:19 24059 8192000000 10104620672 10540851200 1151376864 12.322 100 35 68 1 1208395184 50256080 6762240
12:02:45 45207 8192000000 10096410048 10587127808 1154018736 12.347 100 13 26 1 1237607632 80574032 3014864
12:04:49 43859 8192000000 10078002032 10552451072 1137292816 12.190 99 11 22 0 1170174352 30614128 2267408
12:06:37 38107 8192000000 10077196112 10548989952 1135722848 12.175 99 18 36 0 1172670560 32998880 3948832
12:08:18 46777 8192000000 10090030320 10571833344 1156741456 12.373 100 17 32 0 1210028496 50295504 2991536
12:10:07 26090 8192000000 10109434624 10572136448 1145137040 12.264 99 18 36 0 1205128400 56330368 3660992
12:11:35 62909 8192000000 10066160880 10534432768 1109940848 11.932 96 9 18 0 1179077408 67984832 1151728
12:13:53 43365 8192000000 10085520976 10546733056 1122815216 12.054 97 19 36 0 1162125920 35799856 3510848
12:15:39 33340 8192000000 10079660672 10513051648 1133893216 12.158 99 28 56 0 1176391600 37300528 5197856
12:17:17 50767 8192000000 10085059616 10557399040 1117728016 12.006 98 30 60 1 1205330544 81309808 6292720
12:19:11 83304 8192000000 10039317728 10466869248 1004293808 10.920 89 15 30 0 1034632512 27716400 2622304
12:23:18 77309 8192000000 10020120688 10513866752 1038358736 11.249 94 24 48 0 1081252896 37469312 5424848
12:25:42 55544 8192000000 10026353008 10440998912 1076135712 11.611 98 32 64 0 1112742848 30456240 6150896
12:27:39 29420 8192000000 10083390992 10549338112 1096711680 11.806 100 39 79 1 1187811632 83287088 7812864
12:29:22 32539 8192000000 10051095936 10543497216 1106910320 11.903 100 9 18 0 1190583728 81724048 1949360
12:30:58 55457 8192000000 10093739328 10568675328 1097500912 11.814 99 17 34 0 1209566864 108543440 3522512
12:33:37 31967 8192000000 10034672832 10467594240 1091618384 11.758 99 23 46 0 1137240992 41148368 4474240
12:35:16 30755 8192000000 10044232496 10476781568 1081767968 11.664 98 26 52 1 1119622176 32873280 4980928
12:36:48 54798 8192000000 10072109072 10540597248 1070716224 11.559 97 24 48 0 1160150384 84663920 4770240
12:38:50 92411 8192000000 10078660656 10515742720 1082656880 11.673 97 26 50 0 1120362816 32847328 4858608
12:41:27 65075 8192000000 10100965440 10574438400 1102096576 11.858 99 15 29 0 1155898736 51354096 2448064
12:43:37 57550 8192000000 10101867968 10526220288 1112723216 11.958 99 30 60 0 1170659888 51910032 6026640
12:45:41 79067 8192000000 10111864656 10568163328 1113934560 11.970 99 38 75 0 1200023280 79091344 6997376
12:48:12 21446 8192000000 10075977776 10568941568 1132272384 12.143 100 9 18 0 1185072832 50979248 1821200
12:49:34 48754 8192000000 10080450496 10575040512 1118117936 12.009 99 11 23 1 1190159312 69794512 2246864
12:51:47 47724 8192000000 10090859216 10537095168 1140566992 12.221 100 24 48 0 1185877968 40643792 4667184
12:53:36 92144 8192000000 10114500816 10570854400 1145428960 12.267 100 20 41 0 1190888704 41294496 4165248
12:56:12 60844 8192000000 10094216640 10577387520 1129078544 12.113 99 14 28 0 1208962048 76940608 2942896
12:58:19 78233 8192000000 10066702176 10499252224 1096659584 11.806 96 19 36 2 1136951968 36989248 3303136
13:00:40 41805 8192000000 10099743904 10546991104 1108667728 11.920 99 25 50 0 1167051728 53680720 4703280
13:02:25 93082 8192000000 10069391328 10515349504 1120501472 12.032 99 29 58 0 1157006608 30600976 5904160
13:05:00 66538 8192000000 10046176880 10495332352 1088050688 11.724 96 10 20 0 1123830976 33680320 2099968

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 109 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-03-2024 13:10:15 to 27-03-2024 13:10:17.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Mar 27 13:10:18 2024 
 
Database header page information: 
    Flags            0 
    Generation        89564 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167996 
    Oldest active        171115 
    Oldest snapshot        171115 
    Next transaction    171116 
    Sequence number        0 
    Next attachment ID    688 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.74, total records: 7694360 
    Average version length: 48.16, total versions: 30068, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89048 
    Data pages: 89048, average fill: 69% 
    Primary pages: 89047, secondary pages: 1, swept pages: 46995 
    Empty pages: 5, full pages: 65127 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 153 
    40 - 59% = 3807 
    60 - 79% = 85048 
    80 - 99% = 14 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23172, nodes: 7694360 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1661787, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 327 
        20 - 39% = 1973 
        40 - 59% = 3960 
        60 - 79% = 2450 
        80 - 99% = 14462 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13447, nodes: 7694360 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1486136, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1666 
        40 - 59% = 1900 
        60 - 79% = 1137 
        80 - 99% = 8744 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8303, nodes: 7694360 
    Average node length: 6.60, total dup: 5770878, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1479251, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 1047 
        40 - 59% = 1282 
        60 - 79% = 948 
        80 - 99% = 4897 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.08, total records: 2214962 
    Average version length: 58.78, total versions: 16032, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28720 
    Data pages: 28720, average fill: 71% 
    Primary pages: 28718, secondary pages: 2, swept pages: 13760 
    Empty pages: 10, full pages: 16431 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 50 
    40 - 59% = 1074 
    60 - 79% = 27555 
    80 - 99% = 25 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4519, nodes: 2214962 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 675972, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 965 
        40 - 59% = 768 
        60 - 79% = 763 
        80 - 99% = 2023 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2429, nodes: 2215768 
    Average node length: 4.97, total dup: 2214869, max dup: 19123 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256159, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 253 
        40 - 59% = 1421 
        60 - 79% = 517 
        80 - 99% = 237 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1785, nodes: 2214962 
    Average node length: 4.97, total dup: 2214912, max dup: 130222 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060400, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 643 
        60 - 79% = 37 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4345, nodes: 2214962 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 675972, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 654 
        40 - 59% = 593 
        60 - 79% = 831 
        80 - 99% = 2164 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.28, total records: 400 
    Average version length: 29.17, total versions: 1945, max versions: 5 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 67% 
    Primary pages: 8, secondary pages: 16, swept pages: 0 
    Empty pages: 1, full pages: 13 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 14 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 16.25, total records: 80078 
    Average version length: 68.27, total versions: 70294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.42 
    Pointer pages: 6, data page slots: 1528 
    Data pages: 1384, average fill: 77% 
    Primary pages: 1383, secondary pages: 1, swept pages: 0 
    Empty pages: 46, full pages: 1000 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 74 
    40 - 59% = 150 
    60 - 79% = 194 
    80 - 99% = 887 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701929, depth: 3, leaf buckets: 258, nodes: 80078 
    Average node length: 13.07, total dup: 3973, max dup: 1 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 58375, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 75 
        40 - 59% = 101 
        60 - 79% = 77 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 204, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 85% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.38, total records: 1548 
    Average version length: 43.34, total versions: 1487, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.59 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 51% 
    Primary pages: 31, secondary pages: 1, swept pages: 8 
    Empty pages: 11, full pages: 16 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89451, depth: 2, leaf buckets: 2, nodes: 1548 
    Average node length: 4.21, total dup: 1450, max dup: 179 
    Average key length: 2.66, compression ratio: 7.14 
    Average prefix length: 18.40, average data length: 0.60 
    Clustering factor: 831, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.63, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.96, total records: 810352 
    Average version length: 37.95, total versions: 16633, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8664 
    Data pages: 8664, average fill: 64% 
    Primary pages: 8662, secondary pages: 2, swept pages: 3278 
    Empty pages: 13, full pages: 4869 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 69 
    40 - 59% = 1009 
    60 - 79% = 7529 
    80 - 99% = 16 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 869, nodes: 801021 
    Average node length: 4.88, total dup: 800972, max dup: 149012 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91373, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 141 
        40 - 59% = 450 
        60 - 79% = 172 
        80 - 99% = 105 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 989, nodes: 801021 
    Average node length: 5.89, total dup: 712936, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161301, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 52 
        40 - 59% = 602 
        60 - 79% = 111 
        80 - 99% = 224 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1011, nodes: 801021 
    Average node length: 5.89, total dup: 712936, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163155, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 99 
        40 - 59% = 584 
        60 - 79% = 103 
        80 - 99% = 224 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1138, nodes: 801021 
    Average node length: 5.97, total dup: 712936, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155567, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 233 
        40 - 59% = 621 
        60 - 79% = 197 
        80 - 99% = 86 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5480 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.47, total fragments: 32, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 77, secondary pages: 11, swept pages: 61 
    Empty pages: 4, full pages: 62 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5480 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.46, average data length: 1.54 
    Clustering factor: 5234, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5480 
    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: 174, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 78237 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 812 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 812 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34447, depth: 2, leaf buckets: 100, nodes: 78237 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3177, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.61, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.81, total records: 146609 
    Average version length: 153.94, total versions: 3117, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3632, average fill: 83% 
    Primary pages: 3631, secondary pages: 1, swept pages: 4 
    Empty pages: 29, full pages: 3587 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3588 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.65, total records: 141564 
    Average version length: 139.38, total versions: 182, 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: 4016 
    Data pages: 3536, average fill: 82% 
    Primary pages: 3533, secondary pages: 3, swept pages: 4 
    Empty pages: 54, full pages: 3467 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3466 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.27, total records: 145894 
    Average version length: 153.10, total versions: 2676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 5256 
    Data pages: 3624, average fill: 83% 
    Primary pages: 3622, secondary pages: 2, swept pages: 4 
    Empty pages: 36, full pages: 3573 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3572 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 148.79, total records: 165445 
    Average version length: 152.80, total versions: 2781, 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: 6, data page slots: 6352 
    Data pages: 4136, average fill: 83% 
    Primary pages: 4134, secondary pages: 2, swept pages: 6 
    Empty pages: 59, full pages: 4053 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4053 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.26, total records: 154021 
    Average version length: 150.13, total versions: 819, 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: 7, data page slots: 5632 
    Data pages: 3856, average fill: 82% 
    Primary pages: 3854, secondary pages: 2, swept pages: 8 
    Empty pages: 65, full pages: 3768 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3767 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.01, total records: 164307 
    Average version length: 155.19, total versions: 7160, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 5, data page slots: 4608 
    Data pages: 4120, average fill: 83% 
    Primary pages: 4117, secondary pages: 3, swept pages: 3 
    Empty pages: 63, full pages: 4031 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 5 
    40 - 59% = 11 
    60 - 79% = 3 
    80 - 99% = 4030 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.18, total records: 156790 
    Average version length: 153.25, total versions: 1921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 5, data page slots: 4024 
    Data pages: 3888, average fill: 83% 
    Primary pages: 3886, secondary pages: 2, swept pages: 3 
    Empty pages: 32, full pages: 3841 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3843 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.68, total records: 158506 
    Average version length: 153.70, total versions: 4895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 8, data page slots: 4232 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3942, secondary pages: 2, swept pages: 6 
    Empty pages: 45, full pages: 3886 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3886 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 142.49, total records: 165384 
    Average version length: 154.96, total versions: 9963, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 7, data page slots: 6408 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 1 
    Empty pages: 66, full pages: 4054 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4054 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.08, total records: 161490 
    Average version length: 152.79, total versions: 2344, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 5336 
    Data pages: 4056, average fill: 82% 
    Primary pages: 4053, secondary pages: 3, swept pages: 3 
    Empty pages: 64, full pages: 3946 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 13 
    40 - 59% = 21 
    60 - 79% = 7 
    80 - 99% = 3945 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.46, total records: 2060500 
    Average version length: 53.09, total versions: 13492, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25680 
    Data pages: 25680, average fill: 69% 
    Primary pages: 25663, secondary pages: 17, swept pages: 13012 
    Empty pages: 207, full pages: 20723 
    Fill distribution: 
     0 - 19% = 420 
    20 - 39% = 405 
    40 - 59% = 1193 
    60 - 79% = 23550 
    80 - 99% = 112 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2541, nodes: 2060500 
    Average node length: 5.44, total dup: 1922610, max dup: 1180 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179601, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 332 
        40 - 59% = 1598 
        60 - 79% = 301 
        80 - 99% = 308 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2060500 
    Average node length: 5.70, total dup: 1848508, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 369279, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2481 
        60 - 79% = 233 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2054, nodes: 2060500 
    Average node length: 4.96, total dup: 2060400, max dup: 27291 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 177296, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 191 
        40 - 59% = 999 
        60 - 79% = 388 
        80 - 99% = 471 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 46.85, total records: 136579 
    Average version length: 69.16, total versions: 50721, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.69 
    Pointer pages: 3, data page slots: 4256 
    Data pages: 3383, average fill: 49% 
    Primary pages: 3383, secondary pages: 0, swept pages: 566 
    Empty pages: 494, full pages: 1119 
    Fill distribution: 
     0 - 19% = 782 
    20 - 39% = 503 
    40 - 59% = 664 
    60 - 79% = 821 
    80 - 99% = 613 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104047, depth: 3, leaf buckets: 238, nodes: 136579 
    Average node length: 6.49, total dup: 118887, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23019, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 78 
        40 - 59% = 123 
        60 - 79% = 36 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.13, total records: 6913919 
    Average version length: 68.81, total versions: 212600, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 66, data page slots: 106664 
    Data pages: 106664, average fill: 69% 
    Primary pages: 106663, secondary pages: 1, swept pages: 44135 
    Empty pages: 54, full pages: 47734 
    Fill distribution: 
     0 - 19% = 227 
    20 - 39% = 926 
    40 - 59% = 10054 
    60 - 79% = 95074 
    80 - 99% = 383 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10666, nodes: 6913919 
    Average node length: 6.51, total dup: 5979545, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1613138, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1875 
        40 - 59% = 5819 
        60 - 79% = 2564 
        80 - 99% = 400 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8507, nodes: 6913919 
    Average node length: 5.40, total dup: 6635790, max dup: 146 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1428184, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1242 
        40 - 59% = 4961 
        60 - 79% = 1290 
        80 - 99% = 1008 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8551, nodes: 6913919 
    Average node length: 5.40, total dup: 6635790, max dup: 146 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1430473, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1306 
        40 - 59% = 4901 
        60 - 79% = 1328 
        80 - 99% = 1013 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.20, total records: 11950049 
    Average version length: 68.72, total versions: 149440, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 174752 
    Data pages: 174752, average fill: 73% 
    Primary pages: 174752, secondary pages: 0, swept pages: 89364 
    Empty pages: 4, full pages: 137012 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 627 
    40 - 59% = 6503 
    60 - 79% = 166889 
    80 - 99% = 696 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18332, nodes: 11949303 
    Average node length: 6.61, total dup: 10417208, max dup: 66 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2450934, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2379 
        40 - 59% = 10661 
        60 - 79% = 4526 
        80 - 99% = 738 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.75, total records: 1214418 
    Average version length: 69.03, total versions: 183863, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.22 
    Pointer pages: 27, data page slots: 42664 
    Data pages: 26999, average fill: 49% 
    Primary pages: 26932, secondary pages: 67, swept pages: 12533 
    Empty pages: 4241, full pages: 11745 
    Fill distribution: 
     0 - 19% = 6616 
    20 - 39% = 3542 
    40 - 59% = 3369 
    60 - 79% = 11371 
    80 - 99% = 2101 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1765, nodes: 1147688 
    Average node length: 5.53, total dup: 1101252, max dup: 49 
    Average key length: 2.58, compression ratio: 16.28 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 81374, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 725 
        40 - 59% = 774 
        60 - 79% = 235 
        80 - 99% = 22 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 45.35, total records: 1009751 
    Average version length: 69.00, total versions: 125803, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.78 
    Pointer pages: 20, data page slots: 31968 
    Data pages: 25903, average fill: 37% 
    Primary pages: 25903, secondary pages: 0, swept pages: 6706 
    Empty pages: 3758, full pages: 4599 
    Fill distribution: 
     0 - 19% = 7239 
    20 - 39% = 5873 
    40 - 59% = 7795 
    60 - 79% = 4861 
    80 - 99% = 135 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1196, nodes: 737354 
    Average node length: 5.92, total dup: 680361, max dup: 69 
    Average key length: 3.00, compression ratio: 14.01 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 104938, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 440 
        40 - 59% = 573 
        60 - 79% = 179 
        80 - 99% = 3 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.74, total records: 8940745 
    Average version length: 68.98, total versions: 170681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 89, data page slots: 143880 
    Data pages: 143832, average fill: 66% 
    Primary pages: 143815, secondary pages: 17, swept pages: 76371 
    Empty pages: 412, full pages: 60746 
    Fill distribution: 
     0 - 19% = 1341 
    20 - 39% = 5686 
    40 - 59% = 23477 
    60 - 79% = 112606 
    80 - 99% = 722 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13473, nodes: 8938908 
    Average node length: 6.68, total dup: 7414099, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1994083, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1592 
        40 - 59% = 7166 
        60 - 79% = 4215 
        80 - 99% = 499 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21136167 
    Average version length: 82.99, total versions: 5736, 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: 319576 
    Data pages: 319576, average fill: 81% 
    Primary pages: 319571, secondary pages: 5, swept pages: 12478 
    Empty pages: 28, full pages: 318912 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 43 
    40 - 59% = 105 
    60 - 79% = 48736 
    80 - 99% = 270646 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19275, nodes: 21136167 
    Average node length: 5.72, total dup: 20655461, max dup: 130 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285224, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 4 
        40 - 59% = 7914 
        60 - 79% = 564 
        80 - 99% = 10783 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17166, nodes: 21136167 
    Average node length: 6.31, total dup: 18575701, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918799, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 777 
        60 - 79% = 292 
        80 - 99% = 16089 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21041, nodes: 21136167 
    Average node length: 6.35, total dup: 18493260, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577816, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 8173 
        60 - 79% = 602 
        80 - 99% = 12258 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16077, nodes: 21136167 
    Average node length: 5.56, total dup: 21136067, max dup: 227976 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947229, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 2877 
        60 - 79% = 356 
        80 - 99% = 12832 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.24, total records: 9367786 
    Average version length: 82.62, total versions: 150511, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 104, data page slots: 169568 
    Data pages: 169528, average fill: 68% 
    Primary pages: 169496, secondary pages: 32, swept pages: 98791 
    Empty pages: 595, full pages: 88246 
    Fill distribution: 
     0 - 19% = 1896 
    20 - 39% = 7893 
    40 - 59% = 27023 
    60 - 79% = 117483 
    80 - 99% = 15233 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11341, nodes: 9367786 
    Average node length: 5.36, total dup: 9062279, max dup: 176 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2110402, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 9104 
        60 - 79% = 2099 
        80 - 99% = 51 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13191, nodes: 9367786 
    Average node length: 6.22, total dup: 7765265, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1479974, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 4030 
        40 - 59% = 4143 
        60 - 79% = 2639 
        80 - 99% = 2259 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12670, nodes: 9367786 
    Average node length: 5.98, total dup: 8119488, max dup: 31 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2294688, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 120 
        40 - 59% = 10196 
        60 - 79% = 2292 
        80 - 99% = 61 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9838, nodes: 9367786 
    Average node length: 5.12, total dup: 9367686, max dup: 150758 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1499300, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1340 
        40 - 59% = 4713 
        60 - 79% = 1730 
        80 - 99% = 2021 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.57, total records: 11016196 
    Average version length: 82.52, total versions: 110093, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 193184 
    Data pages: 191536, average fill: 70% 
    Primary pages: 191420, secondary pages: 116, swept pages: 80961 
    Empty pages: 2973, full pages: 136165 
    Fill distribution: 
     0 - 19% = 5300 
    20 - 39% = 8820 
    40 - 59% = 21188 
    60 - 79% = 97846 
    80 - 99% = 58382 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13128, nodes: 11016196 
    Average node length: 5.30, total dup: 10906947, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2311119, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 197 
        40 - 59% = 9839 
        60 - 79% = 3025 
        80 - 99% = 66 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10234, nodes: 11016196 
    Average node length: 5.50, total dup: 10534216, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714461, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 890 
        40 - 59% = 2469 
        60 - 79% = 1826 
        80 - 99% = 4878 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15009, nodes: 11016196 
    Average node length: 6.03, total dup: 9604580, max dup: 75 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2327278, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 254 
        40 - 59% = 11355 
        60 - 79% = 3306 
        80 - 99% = 91 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10581, nodes: 11016196 
    Average node length: 5.22, total dup: 11016096, max dup: 207049 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 703101, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 908 
        40 - 59% = 4629 
        60 - 79% = 1533 
        80 - 99% = 3401 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.67, total records: 9468403 
    Average version length: 82.94, total versions: 137676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 107, data page slots: 173976 
    Data pages: 173944, average fill: 67% 
    Primary pages: 173913, secondary pages: 31, swept pages: 106440 
    Empty pages: 731, full pages: 84316 
    Fill distribution: 
     0 - 19% = 2376 
    20 - 39% = 9054 
    40 - 59% = 29547 
    60 - 79% = 118239 
    80 - 99% = 14728 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11592, nodes: 9468403 
    Average node length: 5.17, total dup: 9440047, max dup: 1535 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1907794, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1645 
        40 - 59% = 7611 
        60 - 79% = 1758 
        80 - 99% = 542 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13308, nodes: 9468403 
    Average node length: 6.24, total dup: 7848662, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1433550, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 4009 
        40 - 59% = 4123 
        60 - 79% = 2638 
        80 - 99% = 2384 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12187, nodes: 9468403 
    Average node length: 5.43, total dup: 9040366, max dup: 89 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2036921, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1521 
        40 - 59% = 8510 
        60 - 79% = 1573 
        80 - 99% = 542 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9897, nodes: 9468403 
    Average node length: 5.14, total dup: 9468303, max dup: 152865 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1506866, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1334 
        40 - 59% = 4723 
        60 - 79% = 1670 
        80 - 99% = 2131 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.99, total records: 564112 
    Average version length: 68.72, total versions: 1612, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 74% 
    Primary pages: 7983, secondary pages: 1, swept pages: 4137 
    Empty pages: 5, full pages: 6553 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 37 
    40 - 59% = 194 
    60 - 79% = 7736 
    80 - 99% = 12 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40343, depth: 3, leaf buckets: 726, nodes: 564112 
    Average node length: 5.94, total dup: 480435, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99754, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 517 
        60 - 79% = 78 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31250, depth: 3, leaf buckets: 751, nodes: 564112 
    Average node length: 6.15, total dup: 462689, max dup: 20 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99809, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 39 
        40 - 59% = 529 
        60 - 79% = 75 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 567, nodes: 564112 
    Average node length: 4.85, total dup: 564012, max dup: 9536 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88705, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 54 
        40 - 59% = 303 
        60 - 79% = 99 
        80 - 99% = 110 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Mar 27 13:10:42 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7694360 30068 1 0.0000 0.0000
DOC_LIST 2214962 16032 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1945 5 400.0000 0.0000
INVNT_TURNOVER_LOG 80078 70294 1 0.0000 0.0000
MONEY_SALDO 49 204 6 400.0000 0.0000
MONEY_TURNOVER_LOG 1548 1487 1 0.0000 0.0000
PDISTR 810352 16633 2 0.0000 0.0000
PERF_SPLIT_0 146609 3117 1 0.0000 0.0000
PERF_SPLIT_1 141564 182 1 0.0000 0.0000
PERF_SPLIT_2 145894 2676 1 0.0000 0.0000
PERF_SPLIT_3 165445 2781 1 0.0000 0.0000
PERF_SPLIT_4 154021 819 1 0.0000 0.0000
PERF_SPLIT_5 164307 7160 1 0.0000 0.0000
PERF_SPLIT_6 156790 1921 1 0.0000 0.0000
PERF_SPLIT_7 158506 4895 1 0.0000 0.0000
PERF_SPLIT_8 165384 9963 1 0.0000 0.0000
PERF_SPLIT_9 161490 2344 1 0.0000 0.0000
PSTORNED 2060500 13492 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 136579 50721 1 0.0000 0.0000
XQD_1000_3300 6913919 212600 1 0.0000 0.0000
XQD_1200_2000 11950049 149440 1 0.0000 0.0000
XQD_2000_3300 1214418 183863 1 0.0000 0.0000
XQD_2100_3300 1009751 125803 1 0.0000 0.0000
XQD_3300_3400 8940745 170681 1 0.0000 0.0000
XQS_1000_1200 21136167 5736 1 0.0000 0.0000
XQS_1000_3300 9367786 150511 1 0.0000 0.0000
XQS_1200_2000 11016196 110093 1 0.0000 0.0000
XQS_2100_3300 9468403 137676 1 0.0000 0.0000
XQS_3300_3400 564112 1612 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 ---
:68: 
:69: mscs-test-161.budzdorov.ru    Wed Mar 27 13:07:56 2024
:70:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:71: 
--- end of diff output ---

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

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