Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.03.2024 12:14
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 10976364 kB
MemAvailable 30319976 kB
Buffers 0 kB
Cached 20663216 kB
SwapCached 2048 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                    CRASH DURING TEST RUN, 2024-03-09 12:14
DTS_END                         2024-03-09 12:14:12.6230
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          106505
ATT_ID                          482
EXC_UNIT                        9

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: 4110.35 21868 411035
customer order: creation 83.33 386 8333
customer order: refuse 7.03 379 703
order to supplier: creation 22.44 1699 2244
order to supplier: removal 1.32 162561 132
invoice (draft): creation 21.42 3827 2142
invoice (draft): removal 20.93 1048 2093
invoice accept: apply 20.14 26325 2014
invoice accept: cancel 19.07 1261 1907
customer reserve: creation 1907.43 257 190743
customer reserve: removal 1866.43 95 186643
realization accept: apply 40.49 259 4049
realization accept: cancel 38.63 190 3863
payment from customer: creation 29.03 146 2903
payment from customer: removal 2.98 113 298
payment to supplier: creation 23.56 163 2356
payment to supplier: removal 1.48 116 148
service: total inventory turnovers 1.39 8134 139
service: total monetary turnovers 2.87 1335 287
service: aggregate perf. data 0.36 18070 36
service: refresh index statistics 0.02 210990 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2024 12:14:37 to 09-03-2024 12:14:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2403
TEST_TIME 2 1923
TEST_TIME 3 2683
TEST_TIME 4 3309
TEST_TIME 5 3911
TEST_TIME 6 4418
TEST_TIME 7 4844
TEST_TIME 8 5038
TEST_TIME 9 5110
TEST_TIME 10 5203
TEST_TIME 11 5656
TEST_TIME 12 5953
TEST_TIME 13 6574
TEST_TIME 14 6766
TEST_TIME 15 6938
TEST_TIME 16 7212
TEST_TIME 17 7358
TEST_TIME 18 7824
TEST_TIME 19 7830
TEST_TIME 20 7924
TEST_TIME 21 8030
TEST_TIME 22 8374
TEST_TIME 23 8793
TEST_TIME 24 9147
TEST_TIME 25 9511
TEST_TIME 26 9658
TEST_TIME 27 9560
TEST_TIME 28 9312
TEST_TIME 29 9244
TEST_TIME 30 9161
TEST_TIME 31 9141
TEST_TIME 32 9141
TEST_TIME 33 8974
TEST_TIME 34 9016
TEST_TIME 35 8954
TEST_TIME 36 9009
TEST_TIME 37 9020
TEST_TIME 38 9172
TEST_TIME 39 9231
TEST_TIME 40 9196
TEST_TIME 41 9306
TEST_TIME 42 9208
TEST_TIME 43 9258
TEST_TIME 44 9291
TEST_TIME 45 9194

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 09-03-2024 12:14:41 to 09-03-2024 12:14:43.

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 583449 583449 0 0.00 0 18118 10 0 0
doc_list_biud 583448 583448 0 0.00 0 26934 37 0 0
sp_add_invoice_to_stock 2087 2014 73 3.49 64 200073 26325 0 73
sp_cancel_adding_invoice 1907 1907 0 0.00 4 55396 1261 0 0
sp_cancel_client_order 703 703 0 0.00 5 5474 379 0 0
sp_cancel_customer_reserve 186643 186643 0 0.00 0 23024 95 0 0
sp_cancel_pay_from_customer 298 298 0 0.00 2 2028 114 0 0
sp_cancel_pay_to_supplier 148 148 0 0.00 2 1965 116 0 0
sp_cancel_supplier_invoice 2097 2093 4 0.19 1 11175 1048 0 4
sp_cancel_supplier_order 132 132 0 0.00 7 860770 162561 0 0
sp_cancel_write_off 3863 3863 0 0.00 1 11696 191 0 0
sp_client_order 8333 8333 0 0.00 3 22031 386 0 0
sp_customer_reserve 190743 190743 0 0.00 0 51608 258 0 0
sp_fill_shopping_cart 12709 12709 0 0.00 1 19944 40 0 0
sp_fill_shopping_cart_clo_res 190739 190739 0 0.00 0 16287 18 0 0
sp_get_clo_for_invoice 2010 2010 0 0.00 0 24165 301 0 0
sp_kill_cost_storno 6216 6216 0 0.00 0 8697 107 0 0
sp_kill_qstorno_ret_qs2qd 379374 379374 0 0.00 0 22984 51 0 0
sp_kill_qty_storno 201400 201400 0 0.00 0 26934 106 0 0
sp_lock_selected_doc 8330 8330 0 0.00 0 5528 3 0 0
sp_make_cost_storno 11318 11318 0 0.00 0 10283 75 0 0
sp_multiply_rows_for_pdistr 11317 11317 0 0.00 0 10449 54 0 0
sp_multiply_rows_for_qdistr 8333 8333 0 0.00 0 13336 206 0 0
sp_pay_from_customer 2903 2903 0 0.00 4 8506 146 0 0
sp_pay_to_supplier 2356 2356 0 0.00 4 10472 163 0 0
sp_payment_common 5258 5258 0 0.00 1 8251 42 0 0
sp_qd_handle_on_cancel_clo 703 703 0 0.00 1 3615 354 0 0
sp_qd_handle_on_invoice_upd_sts 3917 3917 0 0.00 0 19204 374 0 0
sp_qd_handle_on_reserve_upd_sts 4049 4049 0 0.00 0 26933 73 0 0
sp_reserve_write_off 4049 4049 0 0.00 7 27085 259 0 0
sp_supplier_invoice 2142 2142 0 0.00 7 98901 3827 0 0
sp_supplier_order 2244 2244 0 0.00 6 74974 1700 0 0
srv_aggregate_perf_data 36 36 0 0.00 1145 117949 18071 0 0
srv_fill_mon_cache_memory 28 28 0 0.00 2152 78608 30457 0 0
srv_find_qd_qs_mism 389577 389577 0 0.00 0 18118 8 0 0
srv_make_invnt_saldo 139 139 0 0.00 56 84913 8135 0 0
srv_make_money_saldo 287 287 0 0.00 1 18245 1336 0 0
srv_recalc_idx_stat 2 2 0 0.00 156418 265563 210991 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 2015 2015 0 0.00 0 7074 289 0 0
t$perf-norm:sp_cancel_adding_invoice 161 161 0 0.00 1 5396 184 0 0
t$perf-norm:sp_cancel_client_order 703 703 0 0.00 0 1316 16 0 0
t$perf-norm:sp_cancel_customer_reserve 282 282 0 0.00 0 431 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 298 298 0 0.00 0 1200 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 148 148 0 0.00 0 566 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 141 141 0 0.00 0 1272 31 0 0
t$perf-norm:sp_cancel_supplier_order 132 132 0 0.00 0 19488 2917 0 0
t$perf-norm:sp_cancel_write_off 407 407 0 0.00 0 374 5 0 0
t$perf-norm:sp_client_order 8333 8333 0 0.00 0 4753 23 0 0
t$perf-norm:sp_customer_reserve 404 404 0 0.00 0 848 8 0 0
t$perf-norm:sp_pay_from_customer 2903 2903 0 0.00 0 3486 9 0 0
t$perf-norm:sp_pay_to_supplier 2356 2356 0 0.00 0 2599 13 0 0
t$perf-norm:sp_reserve_write_off 4049 4049 0 0.00 0 2636 12 0 0
t$perf-norm:sp_supplier_invoice 2142 2142 0 0.00 0 6162 21 0 0
t$perf-norm:sp_supplier_order 2244 2244 0 0.00 0 4130 29 0 0
t$perf-norm:srv_aggregate_perf_data 36 36 0 0.00 0 445 35 0 0
t$perf-norm:srv_fill_mon_cache_memory 28 28 0 0.00 0 129 6 0 0
t$perf-norm:srv_make_invnt_saldo 139 139 0 0.00 0 467 12 0 0
t$perf-norm:srv_make_money_saldo 287 287 0 0.00 0 371 4 0 0
t$perf-norm:srv_recalc_idx_stat 2 2 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 4164 4018 146 3.50 0 2886 19 0 146
v_all_customers 15494 15494 0 0.00 0 16 1 0 0
v_all_suppliers 12350 12350 0 0.00 0 41 1 0 0
v_all_wares 16662 16662 0 0.00 0 87 1 0 0
v_cancel_adding_invoice 322 322 0 0.00 0 1884 13 0 0
v_cancel_client_order 1406 1406 0 0.00 0 456 3 0 0
v_cancel_customer_prepayment 596 596 0 0.00 0 862 5 0 0
v_cancel_customer_reserve 564 564 0 0.00 0 730 7 0 0
v_cancel_payment_to_supplier 296 296 0 0.00 0 170 3 0 0
v_cancel_supplier_invoice 290 282 8 2.75 0 151 14 0 8
v_cancel_supplier_order 264 264 0 0.00 0 424 8 0 0
v_cancel_write_off 814 814 0 0.00 0 246 15 0 0
v_max_id_clo_ord 2243 2243 0 0.00 0 541 2 0 0
v_max_id_clo_res 404 404 0 0.00 0 2934 28 0 0
v_max_id_ord_sup 2135 2135 0 0.00 0 638 2 0 0
v_max_non_paid_invoice 559 559 0 0.00 0 141 3 0 0
v_max_non_paid_realizn 1454 1454 0 0.00 0 7478 11 0 0
v_min_id_clo_ord 2243 2243 0 0.00 0 5077 16 0 0
v_min_id_clo_res 404 404 0 0.00 0 6132 23 0 0
v_min_id_ord_sup 2135 2135 0 0.00 0 2899 4 0 0
v_min_non_paid_invoice 2356 2356 0 0.00 0 7460 31 0 0
v_min_non_paid_realizn 2902 2902 0 0.00 0 7508 35 0 0
v_our_firm 4064 4064 0 0.00 0 17 1 0 0
v_reserve_write_off 8098 8098 0 0.00 0 2214 6 0 0
x_lock_depdocs_on_canc_invoice 3859 3859 0 0.00 0 10505 191 0 0
x_lock_depdocs_on_canc_sup_ord 132 132 0 0.00 0 3288 516 0 0
x_make_qstorno_1000_1200 2244 2244 0 0.00 2 74954 1571 0 0
x_make_qstorno_1200_2000 2142 2142 0 0.00 4 98853 3711 0 0
x_make_qstorno_2100_3300 190743 190743 0 0.00 0 51606 236 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2024 12:14:44 to 09-03-2024 12:14:48.

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:53 14 8192000000 8801223776 8813207552 5752384 0.070 3 1 2 0 5853552 65392 35776
11:08:54 31174 8192000000 9719331472 10021552128 800503232 8.901 100 83 166 0 827873024 7293296 20076496
11:10:33 13892 8192000000 9765347776 10073038848 838437600 9.284 100 95 190 0 873554016 12344720 22771696
11:11:52 14408 8192000000 9790232784 10107105280 859683984 9.497 100 89 179 0 899224960 18722448 20818528
11:13:10 13077 8192000000 9843500368 10173911040 897869216 9.877 100 78 156 2 951094816 35727392 17498208
11:14:31 9485 8192000000 9895712576 10238468096 943335664 10.326 100 81 162 0 1012702336 52385408 16981264
11:15:48 4107 8192000000 9941283264 10293530624 979769712 10.682 100 76 153 0 1051083440 55762032 15551696
11:16:55 3259 8192000000 9981002672 10342207488 1003221904 10.910 100 76 152 3 1090635136 72457024 14956208
11:17:59 1828 8192000000 10008740544 10374787072 1023212176 11.103 100 82 161 0 1126763232 86547952 17003104
11:19:03 1659 8192000000 10036352736 10410614784 1048531456 11.347 100 90 180 0 1148192992 81419360 18242176
11:20:07 1558 8192000000 10019698240 10404282368 1072345728 11.574 100 70 137 0 1142238592 56009552 13883312
11:21:09 12026 8192000000 10029665088 10429042688 1076721168 11.616 100 47 94 1 1162465088 76827696 8916224
11:22:22 3637 8192000000 10013401568 10419388416 1080764896 11.655 100 43 83 1 1131147312 41727776 8654640
11:23:27 7100 8192000000 10001574272 10397761536 1088428240 11.728 100 36 69 3 1115510496 19282896 7799360
11:24:35 21752 8192000000 10012185104 10435284992 1096396592 11.803 100 42 82 1 1130329168 25021008 8911568
11:25:57 903 8192000000 10044840560 10432102400 1101611136 11.853 100 79 159 0 1149792336 30941808 17239392
11:26:59 6880 8192000000 10007815552 10406748160 1091215216 11.754 99 42 84 1 1120533184 20202624 9115344
11:28:11 26915 8192000000 10016594032 10421927936 1105392128 11.889 100 37 75 1 1128673104 15140016 8140960
11:29:41 63305 8192000000 10051618064 10465873920 1094421472 11.785 99 50 98 1 1153285648 48138768 10725408
11:31:51 29079 8192000000 10061152496 10488279040 1103045872 11.867 99 35 70 0 1185290608 74706800 7537936
11:33:24 24357 8192000000 10105645728 10509295616 1094311840 11.784 98 58 116 1 1193478416 87297056 11869520
11:34:56 12024 8192000000 10128356208 10539962368 1117825776 12.006 99 59 116 0 1243231104 112338752 13066576
11:36:11 2729 8192000000 10149361440 10550751232 1120617456 12.033 100 60 120 1 1253847152 119630224 13599472
11:37:19 28130 8192000000 10192070528 10598154240 1114031440 11.971 99 53 104 0 1284501840 159233136 11237264
11:38:54 6750 8192000000 10165457200 10575818752 1096800848 11.807 98 68 134 0 1261102656 149433600 14868208
11:40:05 6300 8192000000 10205611824 10620297216 1115089600 11.981 100 65 129 0 1308741968 180062720 13589648
11:41:17 10378 8192000000 10176734624 10588835840 1093087504 11.772 99 52 101 1 1267099888 162936256 11076128
11:42:31 3752 8192000000 10185270016 10597068800 1121379632 12.040 100 62 122 0 1292332416 157695760 13257024
11:43:41 4138 8192000000 10227290656 10644316160 1108996016 11.923 100 73 146 1 1323024640 198150688 15877936
11:44:54 2151 8192000000 10222635040 10614685696 1105556864 11.890 99 82 164 0 1315923056 192123056 18243136
11:46:03 6652 8192000000 10218978080 10616426496 1116306816 11.992 100 57 114 0 1316874176 187911440 12655920
11:47:16 9017 8192000000 10216911456 10635472896 1117144336 12.000 100 49 98 0 1317218736 188753552 11320848
11:48:34 7437 8192000000 10231305936 10641035264 1130303216 12.124 100 50 100 0 1321909952 179962144 11644592
11:49:48 41756 8192000000 10174755440 10662256640 1113981072 11.970 99 16 32 0 1320764384 202801840 3981472
11:51:31 42191 8192000000 10134330112 10625867776 1114671728 11.977 100 15 30 1 1256539184 138770592 3096864
11:53:16 64683 8192000000 10076963232 10544902144 1125544416 12.079 100 17 32 0 1184594272 55794544 3255312
11:55:22 70070 8192000000 10090206368 10551910400 1137069104 12.188 100 36 71 1 1202601488 58451360 7081024
11:57:47 43965 8192000000 10108756752 10537381888 1142432144 12.238 100 29 56 0 1202297584 54546016 5319424
11:59:37 69286 8192000000 10139899040 10584064000 1138803536 12.204 99 29 58 0 1210905872 65768480 6333856
12:01:57 16079 8192000000 10177535952 10600558592 1148606976 12.296 100 54 102 2 1269391264 109091680 11692608
12:03:17 52784 8192000000 10191460640 10640654336 1141146032 12.226 99 21 42 0 1277591440 131548240 4897168
12:05:18 25597 8192000000 10152535440 10632466432 1148861984 12.299 100 15 30 0 1266917584 114377088 3678512
12:06:46 46707 8192000000 10094309680 10563129344 1144341264 12.256 100 22 44 0 1225593984 76257440 4995280
12:08:40 57930 8192000000 10073955632 10550824960 1080505904 11.652 95 6 12 0 1133601648 52032976 1062768
12:10:39 78608 8192000000 10077809536 10540806144 1113152736 11.962 98 16 31 0 1171888128 55960592 2774800

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 09-03-2024 12:14:50 to 09-03-2024 12:15:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 73 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-03-2024 12:15:03 to 09-03-2024 12:15:05.

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          103374
MON$OLDEST_ACTIVE               106610
MON$OLDEST_SNAPSHOT             106610
MON$NEXT_TRANSACTION            106610
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                       1885568
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             577
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3064 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3064 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3064 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3064 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 Sat Mar  9 12:15:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        56778 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    103374 
    Oldest active        106610 
    Oldest snapshot        106610 
    Next transaction    106611 
    Sequence number        0 
    Next attachment ID    577 
    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.07, total records: 7782482 
    Average version length: 48.16, total versions: 163695, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87336 
    Data pages: 87336, average fill: 71% 
    Primary pages: 87335, secondary pages: 1, swept pages: 21621 
    Empty pages: 6, full pages: 80972 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 17 
    40 - 59% = 578 
    60 - 79% = 86595 
    80 - 99% = 136 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 20835, nodes: 7874136 
    Average node length: 19.01, total dup: 0, max dup: 0 
    Average key length: 16.02, compression ratio: 1.69 
    Average prefix length: 13.98, average data length: 13.02 
    Clustering factor: 1702016, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 230 
        20 - 39% = 16 
        40 - 59% = 2776 
        60 - 79% = 734 
        80 - 99% = 17079 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 12102, nodes: 7873896 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1533507, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 55 
        40 - 59% = 1880 
        60 - 79% = 155 
        80 - 99% = 10012 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 7415, nodes: 7958751 
    Average node length: 6.69, total dup: 5844597, max dup: 49 
    Average key length: 3.71, compression ratio: 2.43 
    Average prefix length: 7.56, average data length: 1.44 
    Clustering factor: 1559154, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 3 
        40 - 59% = 1265 
        60 - 79% = 64 
        80 - 99% = 5961 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.60, total records: 2313576 
    Average version length: 57.82, total versions: 92414, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28712 
    Data pages: 28712, average fill: 75% 
    Primary pages: 28710, secondary pages: 2, swept pages: 6958 
    Empty pages: 2, full pages: 25695 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 8 
    40 - 59% = 158 
    60 - 79% = 27803 
    80 - 99% = 737 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 3940, nodes: 2384071 
    Average node length: 11.38, total dup: 0, max dup: 0 
    Average key length: 8.41, compression ratio: 1.07 
    Average prefix length: 3.58, average data length: 5.42 
    Clustering factor: 688803, ratio: 0.29 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 997 
        60 - 79% = 12 
        80 - 99% = 2906 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2275, nodes: 2359650 
    Average node length: 4.97, total dup: 2358751, max dup: 20962 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261173, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 33 
        40 - 59% = 1401 
        60 - 79% = 286 
        80 - 99% = 553 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1732, nodes: 2321710 
    Average node length: 4.97, total dup: 2321660, max dup: 127792 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1082938, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 563 
        60 - 79% = 21 
        80 - 99% = 1148 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 3867, nodes: 2406270 
    Average node length: 11.37, total dup: 0, max dup: 0 
    Average key length: 8.41, compression ratio: 1.07 
    Average prefix length: 3.59, average data length: 5.41 
    Clustering factor: 693642, ratio: 0.29 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 6 
        40 - 59% = 708 
        60 - 79% = 3 
        80 - 99% = 3051 
 
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.30, total records: 400 
    Average version length: 24.76, total versions: 2274, max versions: 9 
    Average fragment length: 2.00, total fragments: 7, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 54% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 0, full pages: 14 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 13 
 
    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: 17.23, total records: 143424 
    Average version length: 68.29, total versions: 123528, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.11 
    Pointer pages: 6, data page slots: 3920 
    Data pages: 2824, average fill: 68% 
    Primary pages: 2823, secondary pages: 1, swept pages: 0 
    Empty pages: 270, full pages: 1780 
    Fill distribution: 
     0 - 19% = 440 
    20 - 39% = 232 
    40 - 59% = 217 
    60 - 79% = 337 
    80 - 99% = 1598 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702629, depth: 3, leaf buckets: 462, nodes: 142804 
    Average node length: 13.49, total dup: 11375, max dup: 2 
    Average key length: 10.59, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 100423, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 112 
        40 - 59% = 215 
        60 - 79% = 116 
        80 - 99% = 15 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.16, total records: 49 
    Average version length: 9.00, total versions: 281, max versions: 10 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 18% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 5 
    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: 15.56, total records: 2532 
    Average version length: 43.59, total versions: 2066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.73 
    Pointer pages: 1, data page slots: 56 
    Data pages: 48, average fill: 55% 
    Primary pages: 47, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 26 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93738, depth: 2, leaf buckets: 8, nodes: 2524 
    Average node length: 4.19, total dup: 2426, max dup: 253 
    Average key length: 2.46, compression ratio: 7.74 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1368, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 0 
        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.71, total records: 45 
    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: 1 
    Data pages: 1, average fill: 63% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 45 
    Average node length: 11.87, total dup: 0, max dup: 0 
    Average key length: 10.84, compression ratio: 0.83 
    Average prefix length: 1.13, average data length: 7.87 
    Clustering factor: 1, ratio: 0.02 
    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: 34.99, total records: 782859 
    Average version length: 37.83, total versions: 53032, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.54 
    Pointer pages: 5, data page slots: 8080 
    Data pages: 8080, average fill: 67% 
    Primary pages: 8075, secondary pages: 5, swept pages: 1034 
    Empty pages: 23, full pages: 7323 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 75 
    40 - 59% = 330 
    60 - 79% = 7482 
    80 - 99% = 146 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 779, nodes: 757203 
    Average node length: 4.87, total dup: 757154, max dup: 125482 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 85937, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 87 
        40 - 59% = 418 
        60 - 79% = 152 
        80 - 99% = 121 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 825, nodes: 756309 
    Average node length: 5.89, total dup: 672689, max dup: 42 
    Average key length: 3.03, compression ratio: 7.27 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 147982, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 17 
        40 - 59% = 384 
        60 - 79% = 121 
        80 - 99% = 301 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 836, nodes: 756283 
    Average node length: 5.89, total dup: 672674, max dup: 42 
    Average key length: 3.03, compression ratio: 7.26 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 149882, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 375 
        60 - 79% = 118 
        80 - 99% = 299 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1100, nodes: 760236 
    Average node length: 5.97, total dup: 676231, max dup: 42 
    Average key length: 3.11, compression ratio: 5.46 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 143978, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 232 
        40 - 59% = 629 
        60 - 79% = 165 
        80 - 99% = 73 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.26, total records: 2494 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.25, total fragments: 4, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 5.99 
    Pointer pages: 1, data page slots: 56 
    Data pages: 53, average fill: 47% 
    Primary pages: 42, secondary pages: 11, swept pages: 11 
    Empty pages: 10, full pages: 7 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 3 
    40 - 59% = 10 
    60 - 79% = 26 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 3, nodes: 2494 
    Average node length: 6.09, total dup: 0, max dup: 0 
    Average key length: 4.18, compression ratio: 8.62 
    Average prefix length: 33.88, average data length: 2.12 
    Clustering factor: 2413, ratio: 0.97 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 6, nodes: 2494 
    Average node length: 11.12, 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: 75, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 3 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 47896 
    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: 504 
    Data pages: 504, average fill: 65% 
    Primary pages: 504, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 498 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 499 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37249, depth: 2, leaf buckets: 62, nodes: 47896 
    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: 2290, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 60 
 
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: 109.59, 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.43 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 55% 
    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: 144.51, total records: 169023 
    Average version length: 152.82, total versions: 7890, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 7, data page slots: 6448 
    Data pages: 4224, average fill: 83% 
    Primary pages: 4221, secondary pages: 3, swept pages: 1 
    Empty pages: 58, full pages: 4138 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 14 
    80 - 99% = 4136 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 131.11, total records: 158235 
    Average version length: 154.41, total versions: 22216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.94 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 3984, average fill: 84% 
    Primary pages: 3981, secondary pages: 3, swept pages: 5 
    Empty pages: 79, full pages: 3882 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3881 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 147.23, total records: 160622 
    Average version length: 151.18, total versions: 4213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 5, data page slots: 5176 
    Data pages: 4016, average fill: 83% 
    Primary pages: 4012, secondary pages: 4, swept pages: 9 
    Empty pages: 64, full pages: 3931 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 3930 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.51, total records: 158284 
    Average version length: 150.88, total versions: 3912, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 7 
    Empty pages: 40, full pages: 3878 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 10 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3876 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 144.75, total records: 165623 
    Average version length: 151.25, total versions: 7335, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 7, data page slots: 6792 
    Data pages: 4120, average fill: 83% 
    Primary pages: 4118, secondary pages: 2, swept pages: 7 
    Empty pages: 40, full pages: 4056 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 3 
    80 - 99% = 4055 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.90, total records: 170545 
    Average version length: 153.96, total versions: 11253, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 4272, average fill: 83% 
    Primary pages: 4269, secondary pages: 3, swept pages: 1 
    Empty pages: 62, full pages: 4185 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 12 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4184 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.56, total records: 153081 
    Average version length: 149.32, total versions: 1456, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 5944 
    Data pages: 3808, average fill: 83% 
    Primary pages: 3805, secondary pages: 3, swept pages: 3 
    Empty pages: 46, full pages: 3747 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3745 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 142.43, total records: 151174 
    Average version length: 153.66, total versions: 9242, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 6504 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3797, secondary pages: 3, swept pages: 29 
    Empty pages: 72, full pages: 3708 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 1 
    80 - 99% = 3708 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.37, total records: 159608 
    Average version length: 151.07, total versions: 4138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 6736 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3990, secondary pages: 2, swept pages: 2 
    Empty pages: 66, full pages: 3910 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3911 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 147.81, total records: 159113 
    Average version length: 151.30, total versions: 3694, 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: 5280 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3983, secondary pages: 1, swept pages: 28 
    Empty pages: 63, full pages: 3895 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3895 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.35, total records: 2142641 
    Average version length: 52.84, total versions: 67065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25640 
    Data pages: 25640, average fill: 72% 
    Primary pages: 25622, secondary pages: 18, swept pages: 6806 
    Empty pages: 94, full pages: 22438 
    Fill distribution: 
     0 - 19% = 198 
    20 - 39% = 204 
    40 - 59% = 699 
    60 - 79% = 23592 
    80 - 99% = 947 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2484, nodes: 2178669 
    Average node length: 5.43, total dup: 2036169, max dup: 1206 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 181470, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 1852 
        60 - 79% = 223 
        80 - 99% = 370 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2737, nodes: 2153382 
    Average node length: 5.69, total dup: 1934410, max dup: 65 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379232, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 2263 
        60 - 79% = 442 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 1752, nodes: 2201044 
    Average node length: 4.96, total dup: 2200944, max dup: 28618 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181359, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 715 
        60 - 79% = 112 
        80 - 99% = 912 
 
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: 36.17, total records: 154445 
    Average version length: 69.13, total versions: 84685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.48 
    Pointer pages: 3, data page slots: 4176 
    Data pages: 4136, average fill: 47% 
    Primary pages: 4133, secondary pages: 3, swept pages: 556 
    Empty pages: 726, full pages: 1576 
    Fill distribution: 
     0 - 19% = 1331 
    20 - 39% = 486 
    40 - 59% = 389 
    60 - 79% = 892 
    80 - 99% = 1038 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1557704, depth: 3, leaf buckets: 287, nodes: 152747 
    Average node length: 6.52, total dup: 133003, max dup: 29 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 24193, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 125 
        40 - 59% = 127 
        60 - 79% = 33 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.39, total records: 6813498 
    Average version length: 68.69, total versions: 628851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 62, data page slots: 100136 
    Data pages: 100136, average fill: 74% 
    Primary pages: 100131, secondary pages: 5, swept pages: 8222 
    Empty pages: 6, full pages: 87743 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 795 
    40 - 59% = 4030 
    60 - 79% = 91249 
    80 - 99% = 3985 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10516, nodes: 6840423 
    Average node length: 6.51, total dup: 5917157, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1591770, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1528 
        40 - 59% = 6361 
        60 - 79% = 2114 
        80 - 99% = 507 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 7352, nodes: 6848051 
    Average node length: 5.40, total dup: 6573161, max dup: 185 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1391121, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 330 
        40 - 59% = 3794 
        60 - 79% = 1583 
        80 - 99% = 1639 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 7368, nodes: 6847739 
    Average node length: 5.40, total dup: 6572822, max dup: 185 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1393524, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 362 
        40 - 59% = 3766 
        60 - 79% = 1559 
        80 - 99% = 1676 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 11515153 
    Average version length: 68.75, total versions: 473693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 101, data page slots: 164712 
    Data pages: 164712, average fill: 75% 
    Primary pages: 164709, secondary pages: 3, swept pages: 45107 
    Empty pages: 18, full pages: 155440 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 654 
    40 - 59% = 2985 
    60 - 79% = 155338 
    80 - 99% = 5641 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18013, nodes: 11546132 
    Average node length: 6.56, total dup: 10067829, max dup: 60 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2340952, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2099 
        40 - 59% = 12162 
        60 - 79% = 2945 
        80 - 99% = 785 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 39.93, total records: 1949692 
    Average version length: 68.72, total versions: 535884, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 26, data page slots: 40864 
    Data pages: 35246, average fill: 55% 
    Primary pages: 35125, secondary pages: 121, swept pages: 6175 
    Empty pages: 2557, full pages: 23177 
    Fill distribution: 
     0 - 19% = 4626 
    20 - 39% = 7053 
    40 - 59% = 4798 
    60 - 79% = 12114 
    80 - 99% = 6655 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1977, nodes: 1540565 
    Average node length: 5.51, total dup: 1478369, max dup: 99 
    Average key length: 2.56, compression ratio: 16.44 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 127053, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 327 
        40 - 59% = 985 
        60 - 79% = 561 
        80 - 99% = 94 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 34.11, total records: 1707187 
    Average version length: 68.87, total versions: 244275, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.69 
    Pointer pages: 21, data page slots: 33376 
    Data pages: 33272, average fill: 41% 
    Primary pages: 33271, secondary pages: 1, swept pages: 3548 
    Empty pages: 2700, full pages: 17653 
    Fill distribution: 
     0 - 19% = 8938 
    20 - 39% = 6885 
    40 - 59% = 7569 
    60 - 79% = 9243 
    80 - 99% = 637 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1308, nodes: 953763 
    Average node length: 5.92, total dup: 880200, max dup: 99 
    Average key length: 2.98, compression ratio: 14.09 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 138203, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 272 
        40 - 59% = 565 
        60 - 79% = 395 
        80 - 99% = 75 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.70, total records: 9673913 
    Average version length: 68.90, total versions: 655868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 144344 
    Data pages: 144336, average fill: 72% 
    Primary pages: 144324, secondary pages: 12, swept pages: 33364 
    Empty pages: 84, full pages: 97352 
    Fill distribution: 
     0 - 19% = 255 
    20 - 39% = 1244 
    40 - 59% = 12771 
    60 - 79% = 119709 
    80 - 99% = 10357 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13443, nodes: 9666261 
    Average node length: 6.69, total dup: 8023324, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2065802, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 396 
        40 - 59% = 6467 
        60 - 79% = 5955 
        80 - 99% = 623 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 20771401 
    Average version length: 82.95, total versions: 17263, 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: 193, data page slots: 313576 
    Data pages: 313576, average fill: 81% 
    Primary pages: 313571, secondary pages: 5, swept pages: 5823 
    Empty pages: 44, full pages: 312186 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 76 
    40 - 59% = 164 
    60 - 79% = 36168 
    80 - 99% = 277091 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 17432, nodes: 20771245 
    Average node length: 5.71, total dup: 20299089, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3226680, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 5007 
        60 - 79% = 356 
        80 - 99% = 12065 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 16670, nodes: 20771901 
    Average node length: 6.30, total dup: 18254377, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 903521, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 567 
        60 - 79% = 168 
        80 - 99% = 15930 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 19094, nodes: 20774740 
    Average node length: 6.34, total dup: 18177370, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3515200, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 5119 
        60 - 79% = 393 
        80 - 99% = 13580 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 14863, nodes: 20771704 
    Average node length: 5.55, total dup: 20771604, max dup: 224776 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 931623, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1194 
        60 - 79% = 88 
        80 - 99% = 13581 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.51, total records: 10126478 
    Average version length: 82.56, total versions: 669904, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 106, data page slots: 171536 
    Data pages: 171528, average fill: 73% 
    Primary pages: 171505, secondary pages: 23, swept pages: 52706 
    Empty pages: 113, full pages: 105278 
    Fill distribution: 
     0 - 19% = 332 
    20 - 39% = 2039 
    40 - 59% = 16613 
    60 - 79% = 99451 
    80 - 99% = 53093 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11325, nodes: 10171435 
    Average node length: 5.40, total dup: 9861314, max dup: 245 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2213560, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 25 
        40 - 59% = 6127 
        60 - 79% = 5026 
        80 - 99% = 141 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 11123, nodes: 11260437 
    Average node length: 6.26, total dup: 9352213, max dup: 14 
    Average key length: 3.09, compression ratio: 2.92 
    Average prefix length: 8.08, average data length: 0.92 
    Clustering factor: 1682240, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 161 
        40 - 59% = 4069 
        60 - 79% = 262 
        80 - 99% = 6517 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12641, nodes: 10183428 
    Average node length: 6.01, total dup: 8858479, max dup: 47 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2413895, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 6999 
        60 - 79% = 5447 
        80 - 99% = 167 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 8742, nodes: 10930571 
    Average node length: 5.17, total dup: 10930471, max dup: 170208 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1704606, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 3513 
        60 - 79% = 273 
        80 - 99% = 4848 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.34, total records: 11744373 
    Average version length: 82.49, total versions: 468486, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191672 
    Data pages: 191352, average fill: 76% 
    Primary pages: 191245, secondary pages: 107, swept pages: 45518 
    Empty pages: 1119, full pages: 152899 
    Fill distribution: 
     0 - 19% = 2199 
    20 - 39% = 4340 
    40 - 59% = 12886 
    60 - 79% = 62921 
    80 - 99% = 109006 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13099, nodes: 11748062 
    Average node length: 5.33, total dup: 11639226, max dup: 657 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2449238, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 7816 
        60 - 79% = 5147 
        80 - 99% = 127 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 9594, nodes: 11789545 
    Average node length: 5.53, total dup: 11277269, max dup: 49 
    Average key length: 2.27, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 758961, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 264 
        40 - 59% = 1678 
        60 - 79% = 1115 
        80 - 99% = 6489 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14982, nodes: 11752382 
    Average node length: 6.05, total dup: 10271576, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2466786, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 8 
        40 - 59% = 9312 
        60 - 79% = 5513 
        80 - 99% = 146 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 9583, nodes: 11807287 
    Average node length: 5.25, total dup: 11807187, max dup: 185252 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 749110, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 273 
        40 - 59% = 3351 
        60 - 79% = 533 
        80 - 99% = 5392 
 
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: 77.88, total records: 10236839 
    Average version length: 82.87, total versions: 667057, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 107, data page slots: 174304 
    Data pages: 174304, average fill: 73% 
    Primary pages: 174283, secondary pages: 21, swept pages: 57051 
    Empty pages: 125, full pages: 105703 
    Fill distribution: 
     0 - 19% = 381 
    20 - 39% = 2220 
    40 - 59% = 17415 
    60 - 79% = 100260 
    80 - 99% = 54028 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12191, nodes: 10438112 
    Average node length: 5.22, total dup: 10408800, max dup: 2260 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2044062, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 431 
        40 - 59% = 9196 
        60 - 79% = 1981 
        80 - 99% = 578 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 11241, nodes: 11344795 
    Average node length: 6.27, total dup: 9420437, max dup: 14 
    Average key length: 3.09, compression ratio: 2.92 
    Average prefix length: 8.08, average data length: 0.92 
    Clustering factor: 1621997, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 147 
        40 - 59% = 4051 
        60 - 79% = 254 
        80 - 99% = 6627 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12880, nodes: 10396717 
    Average node length: 5.47, total dup: 9939597, max dup: 113 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2177582, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 436 
        40 - 59% = 10401 
        60 - 79% = 1507 
        80 - 99% = 531 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 8880, nodes: 11072067 
    Average node length: 5.18, total dup: 11071967, max dup: 173013 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1716989, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 96 
        40 - 59% = 3639 
        60 - 79% = 214 
        80 - 99% = 4926 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.81, total records: 579096 
    Average version length: 68.85, total versions: 13095, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8008 
    Data pages: 8008, average fill: 76% 
    Primary pages: 8008, secondary pages: 0, swept pages: 2423 
    Empty pages: 6, full pages: 6940 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 9 
    40 - 59% = 135 
    60 - 79% = 7384 
    80 - 99% = 474 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46832, depth: 3, leaf buckets: 732, nodes: 584262 
    Average node length: 5.94, total dup: 497903, max dup: 83 
    Average key length: 3.09, compression ratio: 2.92 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100187, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 555 
        60 - 79% = 82 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39064, depth: 3, leaf buckets: 745, nodes: 584473 
    Average node length: 6.15, total dup: 479607, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100282, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 542 
        60 - 79% = 87 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 462, nodes: 588045 
    Average node length: 4.86, total dup: 587945, max dup: 9533 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89280, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 166 
        60 - 79% = 50 
        80 - 99% = 241 
 
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 Sat Mar  9 12:15:58 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7782482 163695 1 0.0000 0.0000
DOC_LIST 2313576 92414 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2274 9 500.0000 0.0000
INVNT_TURNOVER_LOG 143424 123528 1 0.0000 0.0000
MONEY_SALDO 49 281 10 500.0000 0.0000
MONEY_TURNOVER_LOG 2532 2066 1 0.0000 0.0000
PDISTR 782859 53032 3 0.0000 0.0000
PERF_SPLIT_0 169023 7890 1 0.0000 0.0000
PERF_SPLIT_1 158235 22216 1 0.0000 0.0000
PERF_SPLIT_2 160622 4213 1 0.0000 0.0000
PERF_SPLIT_3 158284 3912 1 0.0000 0.0000
PERF_SPLIT_4 165623 7335 1 0.0000 0.0000
PERF_SPLIT_5 170545 11253 1 0.0000 0.0000
PERF_SPLIT_6 153081 1456 1 0.0000 0.0000
PERF_SPLIT_7 151174 9242 1 0.0000 0.0000
PERF_SPLIT_8 159608 4138 1 0.0000 0.0000
PERF_SPLIT_9 159113 3694 1 0.0000 0.0000
PSTORNED 2142641 67065 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 154445 84685 1 0.0000 0.0000
XQD_1000_3300 6813498 628851 1 0.0000 0.0000
XQD_1200_2000 11515153 473693 1 0.0000 0.0000
XQD_2000_3300 1949692 535884 1 0.0000 0.0000
XQD_2100_3300 1707187 244275 1 0.0000 0.0000
XQD_3300_3400 9673913 655868 1 0.0000 0.0000
XQS_1000_1200 20771401 17263 1 0.0000 0.0000
XQS_1000_3300 10126478 669904 1 0.0000 0.0000
XQS_1200_2000 11744373 468486 1 0.0000 0.0000
XQS_2100_3300 10236839 667057 1 0.0000 0.0000
XQS_3300_3400 579096 13095 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 ---
:32: 
:33: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:34:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:35: 
:36: 
:37: 
:38: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:39:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:40: 
:41: 
:42: 
:43: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:44:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:45:     Uncommitted work may have been lost.
:46:     Error writing data to the connection.
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:50:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:51:     Uncommitted work may have been lost.
:52:     Error writing data to the connection.
:53: 
:54: 
:55: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:56:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:57:     Uncommitted work may have been lost.
:58:     Error writing data to the connection.
:59: 
:60: 
:61: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:62:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:63:     Uncommitted work may have been lost.
:64:     Error writing data to the connection.
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:68:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:69:     Uncommitted work may have been lost.
:70:     Error writing data to the connection.
:71: 
:72: 
:73: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:74:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:75:     Uncommitted work may have been lost.
:76:     Error writing data to the connection.
:77: 
:78: 
:79: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:80:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:81:     Uncommitted work may have been lost.
:82:     Error writing data to the connection.
:83: 
:84: 
:85: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:86:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:87:     Uncommitted work may have been lost.
:88:     Error writing data to the connection.
:89: 
:90: 
:91: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:92:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:93:     Uncommitted work may have been lost.
:94:     Error writing data to the connection.
:95: 
:96: 
:97: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:98:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:99:     Uncommitted work may have been lost.
:100:     Error writing data to the connection.
:101: 
:102: 
:103: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:104:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:105:     Uncommitted work may have been lost.
:106:     Error writing data to the connection.
:107: 
:108: 
:109: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:110:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:111:     Uncommitted work may have been lost.
:112:     Error writing data to the connection.
:113: 
:114: 
:115: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:116:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:117:     Uncommitted work may have been lost.
:118:     Error writing data to the connection.
:119: 
:120: 
:121: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:122:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:123:     Uncommitted work may have been lost.
:124:     Error writing data to the connection.
:125: 
:126: 
:127: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:128:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:129:     Uncommitted work may have been lost.
:130:     Error writing data to the connection.
:131: 
:132: 
:133: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:134:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:135:     Uncommitted work may have been lost.
:136:     Error writing data to the connection.
:137: 
:138: 
:139: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:140:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:141:     Uncommitted work may have been lost.
:142:     Error writing data to the connection.
:143: 
:144: 
:145: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:146:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:147:     Uncommitted work may have been lost.
:148:     Error writing data to the connection.
:149: 
:150: 
:151: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:152:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:153:     Uncommitted work may have been lost.
:154:     Error writing data to the connection.
:155: 
:156: 
:157: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:158:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:159:     Uncommitted work may have been lost.
:160:     Error writing data to the connection.
:161: 
:162: 
:163: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:164:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:165:     Uncommitted work may have been lost.
:166:     Error writing data to the connection.
:167: 
:168: 
:169: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:170:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:171:     Uncommitted work may have been lost.
:172:     Error writing data to the connection.
:173: 
:174: 
:175: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:176:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:177:     Uncommitted work may have been lost.
:178:     Error writing data to the connection.
:179: 
:180: 
:181: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:182:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:183:     Uncommitted work may have been lost.
:184:     Error writing data to the connection.
:185: 
:186: 
:187: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:188:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:189:     Uncommitted work may have been lost.
:190:     Error writing data to the connection.
:191: 
:192: 
:193: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:194:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:195:     Uncommitted work may have been lost.
:196:     Error writing data to the connection.
:197: 
:198: 
:199: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:200:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:201:     Uncommitted work may have been lost.
:202:     Error writing data to the connection.
:203: 
:204: 
:205: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:206:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:207:     Uncommitted work may have been lost.
:208:     Error writing data to the connection.
:209: 
:210: 
:211: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:212:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:213:     Uncommitted work may have been lost.
:214:     Error writing data to the connection.
:215: 
:216: 
:217: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:218:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:219:     Uncommitted work may have been lost.
:220:     Error writing data to the connection.
:221: 
:222: 
:223: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:224:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:225:     Uncommitted work may have been lost.
:226:     Error writing data to the connection.
:227: 
:228: 
:229: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:230:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:231:     Uncommitted work may have been lost.
:232:     Error writing data to the connection.
:233: 
:234: 
:235: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:236:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:237:     Uncommitted work may have been lost.
:238:     Error writing data to the connection.
:239: 
:240: 
:241: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:242:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:243:     Uncommitted work may have been lost.
:244:     Error writing data to the connection.
:245: 
:246: 
:247: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:248:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:249:     Uncommitted work may have been lost.
:250:     Error writing data to the connection.
:251: 
:252: 
:253: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:254:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:255:     Uncommitted work may have been lost.
:256:     Error writing data to the connection.
:257: 
:258: 
:259: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:260:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:261:     Uncommitted work may have been lost.
:262:     Error writing data to the connection.
:263: 
:264: 
:265: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:266:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:267:     Uncommitted work may have been lost.
:268:     Error writing data to the connection.
:269: 
:270: 
:271: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:272:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:273:     Uncommitted work may have been lost.
:274:     Error writing data to the connection.
:275: 
:276: 
:277: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:278:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:279:     Uncommitted work may have been lost.
:280:     Error writing data to the connection.
:281: 
:282: 
:283: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:284:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:285:     Uncommitted work may have been lost.
:286:     Error writing data to the connection.
:287: 
:288: 
:289: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:290:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:291:     Uncommitted work may have been lost.
:292:     Error writing data to the connection.
:293: 
:294: 
:295: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:296:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:297:     Uncommitted work may have been lost.
:298:     Error writing data to the connection.
:299: 
:300: 
:301: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:302:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:303:     Uncommitted work may have been lost.
:304:     Error writing data to the connection.
:305: 
:306: 
:307: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:308:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:309:     Uncommitted work may have been lost.
:310:     Error writing data to the connection.
:311: 
:312: 
:313: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:314:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:315:     Uncommitted work may have been lost.
:316:     Error writing data to the connection.
:317: 
:318: 
:319: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:320:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:321:     Uncommitted work may have been lost.
:322:     Error writing data to the connection.
:323: 
:324: 
:325: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:326:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:327:     Uncommitted work may have been lost.
:328:     Error writing data to the connection.
:329: 
:330: 
:331: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:332:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:333:     Uncommitted work may have been lost.
:334:     Error writing data to the connection.
:335: 
:336: 
:337: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:338:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:339:     Uncommitted work may have been lost.
:340:     Error writing data to the connection.
:341: 
:342: 
:343: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:344:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:345:     Uncommitted work may have been lost.
:346:     Error writing data to the connection.
:347: 
:348: 
:349: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:350:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:351:     Uncommitted work may have been lost.
:352:     Error writing data to the connection.
:353: 
:354: 
:355: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:356:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:357:     Uncommitted work may have been lost.
:358:     Error writing data to the connection.
:359: 
:360: 
:361: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:362:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:363:     Uncommitted work may have been lost.
:364:     Error writing data to the connection.
:365: 
:366: 
:367: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:368:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:369:     Uncommitted work may have been lost.
:370:     Error writing data to the connection.
:371: 
:372: 
:373: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:374:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:375:     Uncommitted work may have been lost.
:376:     Error writing data to the connection.
:377: 
:378: 
:379: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:380:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:381:     Uncommitted work may have been lost.
:382:     Error writing data to the connection.
:383: 
:384: 
:385: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:386:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:387:     Uncommitted work may have been lost.
:388:     Error writing data to the connection.
:389: 
:390: 
:391: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:392:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:393:     Uncommitted work may have been lost.
:394:     Error writing data to the connection.
:395: 
:396: 
:397: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:398:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:399:     Uncommitted work may have been lost.
:400:     Error writing data to the connection.
:401: 
:402: 
:403: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:404:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:405:     Uncommitted work may have been lost.
:406:     Error writing data to the connection.
:407: 
:408: 
:409: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:410:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:411:     Uncommitted work may have been lost.
:412:     Error writing data to the connection.
:413: 
:414: 
:415: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:416:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:417:     Uncommitted work may have been lost.
:418:     Error writing data to the connection.
:419: 
:420: 
:421: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:422:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:423:     Uncommitted work may have been lost.
:424:     Error writing data to the connection.
:425: 
:426: 
:427: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:428:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:429:     Uncommitted work may have been lost.
:430:     Error writing data to the connection.
:431: 
:432: 
:433: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:434:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:435:     Uncommitted work may have been lost.
:436:     Error writing data to the connection.
:437: 
:438: 
:439: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:440:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:441:     Uncommitted work may have been lost.
:442:     Error writing data to the connection.
:443: 
:444: 
:445: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:446:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:447:     Uncommitted work may have been lost.
:448:     Error writing data to the connection.
:449: 
:450: 
:451: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:452:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:453:     Uncommitted work may have been lost.
:454:     Error writing data to the connection.
:455: 
:456: 
:457: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:458:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:459:     Uncommitted work may have been lost.
:460:     Error writing data to the connection.
:461: 
:462: 
:463: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:464:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:465:     Uncommitted work may have been lost.
:466:     Error writing data to the connection.
:467: 
:468: 
:469: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:470:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:471:     Uncommitted work may have been lost.
:472:     Error writing data to the connection.
:473: 
:474: 
:475: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:476:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:477:     Uncommitted work may have been lost.
:478:     Error writing data to the connection.
:479: 
:480: 
:481: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:482:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:483:     Uncommitted work may have been lost.
:484:     Error writing data to the connection.
:485: 
:486: 
:487: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:488:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:489:     Uncommitted work may have been lost.
:490:     Error writing data to the connection.
:491: 
:492: 
:493: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:494:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:495:     Uncommitted work may have been lost.
:496:     Error writing data to the connection.
:497: 
:498: 
:499: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:500:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:501:     Uncommitted work may have been lost.
:502:     Error writing data to the connection.
:503: 
:504: 
:505: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:506:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:507:     Uncommitted work may have been lost.
:508:     Error writing data to the connection.
:509: 
:510: 
:511: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:512:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:513:     Uncommitted work may have been lost.
:514:     Error writing data to the connection.
:515: 
:516: 
:517: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:518:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:519:     Uncommitted work may have been lost.
:520:     Error writing data to the connection.
:521: 
:522: 
:523: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:524:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:525:     Uncommitted work may have been lost.
:526:     Error writing data to the connection.
:527: 
:528: 
:529: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:530:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:531:     Uncommitted work may have been lost.
:532:     Error writing data to the connection.
:533: 
:534: 
:535: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:536:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:537:     Uncommitted work may have been lost.
:538:     Error writing data to the connection.
:539: 
:540: 
:541: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:542:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:543:     Uncommitted work may have been lost.
:544:     Error writing data to the connection.
:545: 
:546: 
:547: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:548:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:549:     Uncommitted work may have been lost.
:550:     Error writing data to the connection.
:551: 
:552: 
:553: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:554:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:555:     Uncommitted work may have been lost.
:556:     Error writing data to the connection.
:557: 
:558: 
:559: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:560:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:561:     Uncommitted work may have been lost.
:562:     Error writing data to the connection.
:563: 
:564: 
:565: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:566:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:567:     Uncommitted work may have been lost.
:568:     Error writing data to the connection.
:569: 
:570: 
:571: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:572:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:573:     Uncommitted work may have been lost.
:574:     Error writing data to the connection.
:575: 
:576: 
:577: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:578:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:579:     Uncommitted work may have been lost.
:580:     Error writing data to the connection.
:581: 
:582: 
:583: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:584:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:585:     Uncommitted work may have been lost.
:586:     Error writing data to the connection.
:587: 
:588: 
:589: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:590:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:591:     Uncommitted work may have been lost.
:592:     Error writing data to the connection.
:593: 
:594: 
:595: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:596:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:597:     Uncommitted work may have been lost.
:598:     Error writing data to the connection.
:599: 
:600: 
:601: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:602:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:603:     Uncommitted work may have been lost.
:604:     Error writing data to the connection.
:605: 
:606: 
:607: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:608:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:609:     Uncommitted work may have been lost.
:610:     Error writing data to the connection.
:611: 
:612: 
:613: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:614:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:615:     Uncommitted work may have been lost.
:616:     Error writing data to the connection.
:617: 
:618: 
:619: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:620:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:621:     Uncommitted work may have been lost.
:622:     Error writing data to the connection.
:623: 
:624: 
:625: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:626:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:627:     Uncommitted work may have been lost.
:628:     Error writing data to the connection.
:629: 
:630: 
:631: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:632:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:633:     Uncommitted work may have been lost.
:634:     Error writing data to the connection.
:635: 
:636: 
:637: mscs-test-161.budzdorov.ru    Sat Mar  9 12:14:09 2024
:638:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:639:     Uncommitted work may have been lost.
:640:     Error writing data to the connection.
:641: 
--- end of diff output ---

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

09.03.24 12:16:10. All 6 logs in /var/tmp/logs-oltp40 are preserved, 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-09 12:16:12 No severe PSQL-related problems occured
09.03.24 12:16:14. End of report.