Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.02.2024 16:10
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 | 15728204 kB |
MemAvailable | 30296616 kB |
Buffers | 0 kB |
Cached | 16011372 kB |
SwapCached | 2396 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_MODE SuperServer 3.0.12
DB_NAME /home/bases/oltp30-etalone.fdb
FORCED_WRITES ON
SWEEP_INT 0
PAGE_BUFFERS 1000000
PAGE_SIZE 8192
Test configuration settings
param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2024-02-21 16:09:32
DTS_END 2024-02-21 16:09:32.7870
FB_GDSCODE -1
FB_MNEMONA
STACK SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/36024
TRN_ID 173506
ATT_ID 530
EXC_UNIT 2
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 |
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 |
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
*** OVERALL *** for 100 minutes: |
9165.96 |
22106 |
916596 |
customer order: creation |
173.08 |
367 |
17308 |
customer order: refuse |
14.88 |
382 |
1488 |
order to supplier: creation |
46.28 |
1403 |
4628 |
order to supplier: removal |
3.52 |
98767 |
352 |
invoice (draft): creation |
47.54 |
3699 |
4754 |
invoice (draft): removal |
53.34 |
694 |
5334 |
invoice accept: apply |
40.41 |
19240 |
4041 |
invoice accept: cancel |
47.39 |
877 |
4739 |
customer reserve: creation |
3835.20 |
186 |
383520 |
customer reserve: removal |
4600.04 |
60 |
460004 |
realization accept: apply |
84.17 |
224 |
8417 |
realization accept: cancel |
89.38 |
111 |
8938 |
payment from customer: creation |
59.92 |
135 |
5992 |
payment from customer: removal |
5.77 |
71 |
577 |
payment to supplier: creation |
49.65 |
173 |
4965 |
payment to supplier: removal |
3.73 |
89 |
373 |
service: total inventory turnovers |
4.41 |
1079 |
441 |
service: total monetary turnovers |
6.41 |
27 |
641 |
service: aggregate perf. data |
0.81 |
23526 |
81 |
service: refresh index statistics |
0.03 |
291018 |
3 |
Completed "Performance in TOTAL". Done for 00:00:03, from 21-02-2024 16:10:59 to 21-02-2024 16:11:02.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
1647 |
TEST_TIME |
2 |
3584 |
TEST_TIME |
3 |
3817 |
TEST_TIME |
4 |
3330 |
TEST_TIME |
5 |
3366 |
TEST_TIME |
6 |
4289 |
TEST_TIME |
7 |
4565 |
TEST_TIME |
8 |
4888 |
TEST_TIME |
9 |
5074 |
TEST_TIME |
10 |
5101 |
TEST_TIME |
11 |
5371 |
TEST_TIME |
12 |
5618 |
TEST_TIME |
13 |
6378 |
TEST_TIME |
14 |
6373 |
TEST_TIME |
15 |
6456 |
TEST_TIME |
16 |
6483 |
TEST_TIME |
17 |
6488 |
TEST_TIME |
18 |
6397 |
TEST_TIME |
19 |
6701 |
TEST_TIME |
20 |
6788 |
TEST_TIME |
21 |
6742 |
TEST_TIME |
22 |
7175 |
TEST_TIME |
23 |
7178 |
TEST_TIME |
24 |
7417 |
TEST_TIME |
25 |
7455 |
TEST_TIME |
26 |
7589 |
TEST_TIME |
27 |
7721 |
TEST_TIME |
28 |
7602 |
TEST_TIME |
29 |
8239 |
TEST_TIME |
30 |
9181 |
TEST_TIME |
31 |
9060 |
TEST_TIME |
32 |
8907 |
TEST_TIME |
33 |
8930 |
TEST_TIME |
34 |
9112 |
TEST_TIME |
35 |
9151 |
TEST_TIME |
36 |
9221 |
TEST_TIME |
37 |
9310 |
TEST_TIME |
38 |
9184 |
TEST_TIME |
39 |
9028 |
TEST_TIME |
40 |
8921 |
TEST_TIME |
41 |
9123 |
TEST_TIME |
42 |
8939 |
TEST_TIME |
43 |
8908 |
TEST_TIME |
44 |
8843 |
TEST_TIME |
45 |
9030 |
TEST_TIME |
46 |
9013 |
TEST_TIME |
47 |
8952 |
TEST_TIME |
48 |
8915 |
TEST_TIME |
49 |
8856 |
TEST_TIME |
50 |
8746 |
TEST_TIME |
51 |
8746 |
TEST_TIME |
52 |
8865 |
TEST_TIME |
53 |
8968 |
TEST_TIME |
54 |
8961 |
TEST_TIME |
55 |
8915 |
TEST_TIME |
56 |
8927 |
TEST_TIME |
57 |
9017 |
TEST_TIME |
58 |
9168 |
TEST_TIME |
59 |
9131 |
TEST_TIME |
60 |
9161 |
TEST_TIME |
61 |
9197 |
TEST_TIME |
62 |
9195 |
TEST_TIME |
63 |
9236 |
TEST_TIME |
64 |
9260 |
TEST_TIME |
65 |
9213 |
TEST_TIME |
66 |
9165 |
TEST_TIME |
67 |
9111 |
TEST_TIME |
68 |
9066 |
TEST_TIME |
69 |
9109 |
TEST_TIME |
70 |
9099 |
TEST_TIME |
71 |
9042 |
TEST_TIME |
72 |
8946 |
TEST_TIME |
73 |
8933 |
TEST_TIME |
74 |
9024 |
TEST_TIME |
75 |
9026 |
TEST_TIME |
76 |
9048 |
TEST_TIME |
77 |
9118 |
TEST_TIME |
78 |
9144 |
TEST_TIME |
79 |
9155 |
TEST_TIME |
80 |
9207 |
TEST_TIME |
81 |
9168 |
TEST_TIME |
82 |
9215 |
TEST_TIME |
83 |
9315 |
TEST_TIME |
84 |
9344 |
TEST_TIME |
85 |
9331 |
TEST_TIME |
86 |
9391 |
TEST_TIME |
87 |
9474 |
TEST_TIME |
88 |
9375 |
TEST_TIME |
89 |
9317 |
TEST_TIME |
90 |
9349 |
TEST_TIME |
91 |
9314 |
TEST_TIME |
92 |
9351 |
TEST_TIME |
93 |
9334 |
TEST_TIME |
94 |
9289 |
TEST_TIME |
95 |
9241 |
TEST_TIME |
96 |
9236 |
TEST_TIME |
97 |
9187 |
TEST_TIME |
98 |
9206 |
TEST_TIME |
99 |
9186 |
TEST_TIME |
100 |
9167 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2024 16:11:03 to 21-02-2024 16:11:06.
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 |
1269102 |
1269102 |
0 |
0.00 |
0 |
21102 |
7 |
0 |
0 |
doc_list_biud |
1269102 |
1269102 |
0 |
0.00 |
0 |
32773 |
27 |
0 |
0 |
sp_add_invoice_to_stock |
4155 |
4041 |
114 |
2.74 |
47 |
272764 |
19240 |
0 |
114 |
sp_cancel_adding_invoice |
4739 |
4739 |
0 |
0.00 |
4 |
43362 |
877 |
0 |
0 |
sp_cancel_client_order |
1488 |
1488 |
0 |
0.00 |
4 |
13104 |
382 |
0 |
0 |
sp_cancel_customer_reserve |
460004 |
460004 |
0 |
0.00 |
0 |
32584 |
60 |
0 |
0 |
sp_cancel_pay_from_customer |
577 |
577 |
0 |
0.00 |
3 |
5135 |
72 |
0 |
0 |
sp_cancel_pay_to_supplier |
373 |
373 |
0 |
0.00 |
3 |
4397 |
89 |
0 |
0 |
sp_cancel_supplier_invoice |
5348 |
5334 |
14 |
0.26 |
1 |
18016 |
695 |
0 |
14 |
sp_cancel_supplier_order |
352 |
352 |
0 |
0.00 |
11 |
1011819 |
98768 |
0 |
0 |
sp_cancel_write_off |
8938 |
8938 |
0 |
0.00 |
1 |
12956 |
111 |
0 |
0 |
sp_client_order |
17308 |
17308 |
0 |
0.00 |
3 |
28764 |
368 |
0 |
0 |
sp_customer_reserve |
383520 |
383520 |
0 |
0.00 |
0 |
128916 |
186 |
0 |
0 |
sp_fill_shopping_cart |
26686 |
26686 |
0 |
0.00 |
1 |
10091 |
38 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
383518 |
383518 |
0 |
0.00 |
0 |
22203 |
13 |
0 |
0 |
sp_get_clo_for_invoice |
4039 |
4039 |
0 |
0.00 |
0 |
22895 |
303 |
0 |
0 |
sp_kill_cost_storno |
14627 |
14627 |
0 |
0.00 |
0 |
7587 |
56 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
934632 |
934632 |
0 |
0.00 |
0 |
32431 |
32 |
0 |
0 |
sp_kill_qty_storno |
493311 |
493311 |
0 |
0.00 |
0 |
32770 |
69 |
0 |
0 |
sp_lock_selected_doc |
17392 |
17392 |
0 |
0.00 |
0 |
7856 |
6 |
0 |
0 |
sp_make_cost_storno |
23413 |
23413 |
0 |
0.00 |
0 |
17285 |
73 |
0 |
0 |
sp_multiply_rows_for_pdistr |
23413 |
23413 |
0 |
0.00 |
0 |
9293 |
38 |
0 |
0 |
sp_multiply_rows_for_qdistr |
17308 |
17308 |
0 |
0.00 |
0 |
28755 |
171 |
0 |
0 |
sp_pay_from_customer |
5992 |
5992 |
0 |
0.00 |
4 |
14349 |
135 |
0 |
0 |
sp_pay_to_supplier |
4965 |
4965 |
0 |
0.00 |
5 |
14105 |
174 |
0 |
0 |
sp_payment_common |
10957 |
10957 |
0 |
0.00 |
2 |
10658 |
43 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1488 |
1488 |
0 |
0.00 |
0 |
13094 |
351 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
8778 |
8778 |
0 |
0.00 |
0 |
32763 |
325 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8417 |
8417 |
0 |
0.00 |
0 |
27004 |
63 |
0 |
0 |
sp_reserve_write_off |
8417 |
8417 |
0 |
0.00 |
5 |
27022 |
225 |
0 |
0 |
sp_supplier_invoice |
4754 |
4754 |
0 |
0.00 |
6 |
125398 |
3699 |
0 |
0 |
sp_supplier_order |
4628 |
4628 |
0 |
0.00 |
5 |
35509 |
1403 |
0 |
0 |
srv_aggregate_perf_data |
81 |
81 |
0 |
0.00 |
1381 |
272929 |
23527 |
0 |
0 |
srv_fill_mon_cache_memory |
57 |
57 |
0 |
0.00 |
2724 |
146765 |
39428 |
0 |
0 |
srv_find_qd_qs_mism |
875254 |
875254 |
0 |
0.00 |
0 |
20808 |
6 |
0 |
0 |
srv_make_invnt_saldo |
441 |
441 |
0 |
0.00 |
53 |
46459 |
1079 |
0 |
0 |
srv_make_money_saldo |
641 |
641 |
0 |
0.00 |
1 |
1543 |
27 |
0 |
0 |
srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
140410 |
381522 |
291019 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
114 |
114 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
14 |
14 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4041 |
4041 |
0 |
0.00 |
0 |
18388 |
211 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
322 |
322 |
0 |
0.00 |
0 |
3185 |
111 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1488 |
1488 |
0 |
0.00 |
0 |
5459 |
22 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
602 |
602 |
0 |
0.00 |
0 |
1255 |
10 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
577 |
577 |
0 |
0.00 |
0 |
1503 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
373 |
373 |
0 |
0.00 |
0 |
1075 |
6 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
337 |
337 |
0 |
0.00 |
0 |
759 |
14 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
352 |
352 |
0 |
0.00 |
0 |
23871 |
1794 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
885 |
885 |
0 |
0.00 |
0 |
3627 |
12 |
0 |
0 |
t$perf-norm:sp_client_order |
17308 |
17308 |
0 |
0.00 |
0 |
7476 |
20 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
890 |
890 |
0 |
0.00 |
0 |
3420 |
16 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
5992 |
5992 |
0 |
0.00 |
0 |
4755 |
13 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
4965 |
4965 |
0 |
0.00 |
0 |
5549 |
15 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8417 |
8417 |
0 |
0.00 |
0 |
7379 |
15 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4754 |
4754 |
0 |
0.00 |
0 |
5042 |
24 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4628 |
4628 |
0 |
0.00 |
0 |
4956 |
20 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
81 |
81 |
0 |
0.00 |
0 |
4584 |
68 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
57 |
57 |
0 |
0.00 |
0 |
57 |
3 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
441 |
441 |
0 |
0.00 |
0 |
1171 |
26 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
641 |
641 |
0 |
0.00 |
0 |
1929 |
25 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
1 |
11 |
5 |
0 |
0 |
v_add_invoice_to_stock |
8306 |
8078 |
228 |
2.74 |
0 |
8083 |
19 |
0 |
228 |
v_all_customers |
32304 |
32304 |
0 |
0.00 |
0 |
52 |
1 |
0 |
0 |
v_all_suppliers |
26496 |
26496 |
0 |
0.00 |
0 |
37 |
1 |
0 |
0 |
v_all_wares |
34614 |
34614 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_cancel_adding_invoice |
644 |
644 |
0 |
0.00 |
0 |
8156 |
32 |
0 |
0 |
v_cancel_client_order |
2976 |
2976 |
0 |
0.00 |
0 |
2561 |
6 |
0 |
0 |
v_cancel_customer_prepayment |
1154 |
1154 |
0 |
0.00 |
0 |
3522 |
8 |
0 |
0 |
v_cancel_customer_reserve |
1204 |
1204 |
0 |
0.00 |
0 |
6246 |
11 |
0 |
0 |
v_cancel_payment_to_supplier |
746 |
746 |
0 |
0.00 |
0 |
1831 |
7 |
0 |
0 |
v_cancel_supplier_invoice |
702 |
674 |
28 |
3.98 |
0 |
1565 |
20 |
0 |
28 |
v_cancel_supplier_order |
704 |
704 |
0 |
0.00 |
0 |
2694 |
8 |
0 |
0 |
v_cancel_write_off |
1770 |
1770 |
0 |
0.00 |
0 |
1680 |
13 |
0 |
0 |
v_max_id_clo_ord |
4627 |
4627 |
0 |
0.00 |
0 |
9212 |
4 |
0 |
0 |
v_max_id_clo_res |
890 |
890 |
0 |
0.00 |
0 |
1604 |
8 |
0 |
0 |
v_max_id_ord_sup |
4752 |
4752 |
0 |
0.00 |
0 |
7793 |
6 |
0 |
0 |
v_max_non_paid_invoice |
1096 |
1096 |
0 |
0.00 |
0 |
1203 |
4 |
0 |
0 |
v_max_non_paid_realizn |
2847 |
2847 |
0 |
0.00 |
0 |
3655 |
7 |
0 |
0 |
v_min_id_clo_ord |
4627 |
4627 |
0 |
0.00 |
0 |
9114 |
15 |
0 |
0 |
v_min_id_clo_res |
890 |
890 |
0 |
0.00 |
0 |
4344 |
7 |
0 |
0 |
v_min_id_ord_sup |
4752 |
4752 |
0 |
0.00 |
0 |
5499 |
5 |
0 |
0 |
v_min_non_paid_invoice |
4965 |
4965 |
0 |
0.00 |
0 |
10655 |
35 |
0 |
0 |
v_min_non_paid_realizn |
5992 |
5992 |
0 |
0.00 |
0 |
7260 |
33 |
0 |
0 |
v_our_firm |
8600 |
8600 |
0 |
0.00 |
0 |
46 |
1 |
0 |
0 |
v_reserve_write_off |
16834 |
16834 |
0 |
0.00 |
0 |
8198 |
9 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9736 |
9736 |
0 |
0.00 |
0 |
18997 |
151 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
352 |
352 |
0 |
0.00 |
0 |
13739 |
364 |
0 |
0 |
x_make_qstorno_1000_1200 |
4628 |
4628 |
0 |
0.00 |
1 |
35492 |
1307 |
0 |
0 |
x_make_qstorno_1200_2000 |
4754 |
4754 |
0 |
0.00 |
3 |
122984 |
3575 |
0 |
0 |
x_make_qstorno_2100_3300 |
383520 |
383520 |
0 |
0.00 |
0 |
128026 |
170 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2024 16:11:07 to 21-02-2024 16:11:11.
Fields:
page cache memo used = page cache total size, bytes:
memo used, total = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
memo allocated, total = the same of mon$memory_usage.mon$memory_allocated;
metadata cache memo used = metadata cache, bytes;
metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
total attachments cnt = total number of attachments, regardless of state;
active attachments cnt = number of attachments with mon$state = 1;
running statements cnt = number of statements that are operating with data from page cache (mon$state = 1);
stalled statements cnt = number of statements that are waiting for client request for fetching ( mon$state = 2);
memo used by attachments = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
memo used by transactions = the same of transaction level (mon$stat_group = 2);
memo used by statements = the same of statement level (mon$stat_group = 3);
Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts |
measurement duration ms |
page cache memo used |
memo used, total |
memo allocated, total |
metadata cache |
metadata cache percent of total |
total attachments cnt |
active attachments cnt |
running statements cnt |
stalled statements cnt |
memo used by attachments |
memo used by transactions |
memo used by statements |
14:09:36 |
9 |
8192000000 |
8807638320 |
8821841920 |
11571952 |
0.141 |
3 |
3 |
4 |
0 |
11755856 |
76800 |
107104 |
14:10:37 |
37842 |
8192000000 |
9905135824 |
10213621760 |
985078864 |
10.734 |
100 |
86 |
172 |
0 |
1013176096 |
5836976 |
22260256 |
14:12:20 |
16277 |
8192000000 |
9938857856 |
10260221952 |
1020660976 |
11.078 |
100 |
87 |
174 |
0 |
1051031472 |
8030752 |
22339744 |
14:13:43 |
9805 |
8192000000 |
9976593520 |
10305417216 |
1056139056 |
11.420 |
100 |
84 |
168 |
0 |
1086940720 |
9922400 |
20879264 |
14:15:07 |
9485 |
8192000000 |
10015452160 |
10357284864 |
1102762752 |
11.864 |
100 |
79 |
156 |
0 |
1133026432 |
11185664 |
19078016 |
14:16:20 |
5238 |
8192000000 |
10062789568 |
10418089984 |
1149002048 |
12.300 |
100 |
82 |
164 |
0 |
1180923376 |
12698304 |
19223024 |
14:17:28 |
5818 |
8192000000 |
10105448320 |
10470199296 |
1191374912 |
12.696 |
100 |
80 |
160 |
0 |
1223114544 |
13283264 |
18456368 |
14:18:36 |
2741 |
8192000000 |
10144354528 |
10520977408 |
1234985728 |
13.100 |
100 |
84 |
168 |
0 |
1266830160 |
13404720 |
18439712 |
14:19:41 |
4142 |
8192000000 |
10169709104 |
10548969472 |
1260218848 |
13.332 |
100 |
84 |
166 |
1 |
1291094576 |
13084112 |
17791616 |
14:20:48 |
865 |
8192000000 |
10209763984 |
10595586048 |
1295076848 |
13.650 |
100 |
89 |
176 |
0 |
1327972736 |
13553680 |
19342208 |
14:21:51 |
3074 |
8192000000 |
10210617840 |
10605531136 |
1300979136 |
13.704 |
100 |
69 |
134 |
4 |
1326790080 |
10216640 |
15594304 |
14:22:56 |
11707 |
8192000000 |
10184362448 |
10602663936 |
1306819040 |
13.757 |
100 |
18 |
37 |
0 |
1316145312 |
5386880 |
3939392 |
14:24:10 |
6578 |
8192000000 |
10192102000 |
10611052544 |
1312159856 |
13.806 |
100 |
22 |
43 |
0 |
1323089728 |
6410832 |
4519040 |
14:25:17 |
7438 |
8192000000 |
10205413120 |
10618699776 |
1317158880 |
13.851 |
100 |
18 |
34 |
0 |
1326280384 |
5504448 |
3617056 |
14:26:27 |
28581 |
8192000000 |
10212889968 |
10638065664 |
1325148688 |
13.923 |
100 |
22 |
42 |
0 |
1335363040 |
5345248 |
4869104 |
14:28:15 |
4065 |
8192000000 |
10222710128 |
10642644992 |
1328185248 |
13.951 |
100 |
28 |
56 |
0 |
1345630240 |
10942016 |
6502976 |
14:29:24 |
34001 |
8192000000 |
10216283984 |
10630144000 |
1292212272 |
13.624 |
97 |
22 |
43 |
0 |
1302400464 |
5370944 |
4817248 |
14:31:05 |
9545 |
8192000000 |
10239378160 |
10655227904 |
1341965616 |
14.075 |
100 |
46 |
89 |
0 |
1360050560 |
8533648 |
9551296 |
14:32:20 |
73546 |
8192000000 |
10241590560 |
10652336128 |
1298548912 |
13.682 |
96 |
52 |
104 |
0 |
1320869968 |
9475424 |
12845632 |
14:34:36 |
4974 |
8192000000 |
10233371952 |
10643689472 |
1320924752 |
13.885 |
99 |
50 |
100 |
0 |
1343591616 |
11805648 |
10861216 |
14:35:45 |
10384 |
8192000000 |
10232844816 |
10645913600 |
1309784352 |
13.784 |
98 |
42 |
82 |
2 |
1330797536 |
11585008 |
9428176 |
14:37:01 |
5359 |
8192000000 |
10220325584 |
10623541248 |
1311669632 |
13.801 |
99 |
57 |
109 |
1 |
1334438368 |
10629200 |
12139536 |
14:38:09 |
9723 |
8192000000 |
10216570688 |
10617094144 |
1283493696 |
13.545 |
98 |
49 |
98 |
0 |
1310440784 |
15515792 |
11431296 |
14:39:24 |
12207 |
8192000000 |
10219219936 |
10615115776 |
1291392736 |
13.617 |
98 |
57 |
112 |
0 |
1322412800 |
18447040 |
12573024 |
14:40:40 |
10641 |
8192000000 |
10246513072 |
10654642176 |
1326928064 |
13.939 |
100 |
55 |
110 |
0 |
1362020496 |
21896320 |
13196112 |
14:41:54 |
2722 |
8192000000 |
10250203344 |
10650226688 |
1318286880 |
13.861 |
100 |
59 |
115 |
0 |
1358885024 |
26532656 |
14065488 |
14:43:06 |
17510 |
8192000000 |
10249863376 |
10660155392 |
1331119728 |
13.977 |
100 |
49 |
98 |
1 |
1362237216 |
19241536 |
11875952 |
14:44:26 |
8661 |
8192000000 |
10263523040 |
10677510144 |
1338322320 |
14.042 |
100 |
46 |
91 |
0 |
1375880272 |
26924080 |
10633872 |
14:45:42 |
5158 |
8192000000 |
10263013616 |
10673717248 |
1340802976 |
14.065 |
100 |
49 |
92 |
1 |
1372714144 |
20602608 |
11308560 |
14:46:53 |
2795 |
8192000000 |
10281394896 |
10685956096 |
1348947952 |
14.138 |
100 |
72 |
144 |
2 |
1388202784 |
22523056 |
16731776 |
14:47:59 |
2774 |
8192000000 |
10307491536 |
10706464768 |
1366914848 |
14.299 |
100 |
79 |
159 |
0 |
1412903888 |
26386368 |
19602672 |
14:49:04 |
8329 |
8192000000 |
10308751312 |
10725675008 |
1381524416 |
14.430 |
100 |
53 |
106 |
0 |
1419699008 |
24645872 |
13528720 |
14:50:19 |
18137 |
8192000000 |
10323498336 |
10741755904 |
1382339680 |
14.437 |
100 |
43 |
84 |
0 |
1425950192 |
32661200 |
10949312 |
14:51:43 |
24749 |
8192000000 |
10305850720 |
10728595456 |
1376266288 |
14.383 |
99 |
36 |
72 |
0 |
1418707584 |
32776592 |
9664704 |
14:53:17 |
5022 |
8192000000 |
10359295920 |
10779336704 |
1412295104 |
14.704 |
100 |
59 |
118 |
0 |
1465747280 |
38222384 |
15229792 |
14:54:28 |
31071 |
8192000000 |
10349317200 |
10779873280 |
1416641872 |
14.743 |
100 |
45 |
88 |
0 |
1461576768 |
33153504 |
11781392 |
14:56:22 |
8839 |
8192000000 |
10345034016 |
10781622272 |
1412260192 |
14.704 |
100 |
26 |
52 |
0 |
1450497344 |
31182624 |
7054528 |
14:58:11 |
21524 |
8192000000 |
10335103936 |
10798309376 |
1404427984 |
14.634 |
100 |
19 |
38 |
0 |
1452285808 |
42284816 |
5573008 |
14:59:34 |
55787 |
8192000000 |
10309174320 |
10743181312 |
1382659760 |
14.440 |
99 |
18 |
32 |
0 |
1413931664 |
27401920 |
3869984 |
15:01:37 |
54112 |
8192000000 |
10333000032 |
10764476416 |
1408266608 |
14.669 |
100 |
43 |
81 |
0 |
1430234624 |
12769856 |
9198160 |
15:03:37 |
79833 |
8192000000 |
10318697424 |
10760019968 |
1387862256 |
14.487 |
99 |
11 |
21 |
0 |
1403034048 |
12905056 |
2266736 |
15:05:58 |
37270 |
8192000000 |
10318295408 |
10777309184 |
1409282256 |
14.678 |
100 |
12 |
24 |
0 |
1426282272 |
14676192 |
2323824 |
15:07:37 |
105867 |
8192000000 |
10332692992 |
10778910720 |
1416286000 |
14.740 |
100 |
27 |
54 |
0 |
1434147344 |
10810032 |
7051312 |
15:10:49 |
42436 |
8192000000 |
10308838032 |
10750504960 |
1359024288 |
14.229 |
96 |
20 |
40 |
0 |
1369550512 |
5175248 |
5350976 |
15:12:46 |
25542 |
8192000000 |
10321121952 |
10768478208 |
1387429328 |
14.483 |
98 |
17 |
34 |
0 |
1406354688 |
15208048 |
3717312 |
15:14:13 |
34625 |
8192000000 |
10296711024 |
10765242368 |
1385197376 |
14.463 |
99 |
15 |
30 |
0 |
1409977840 |
21128528 |
3651936 |
15:15:54 |
65580 |
8192000000 |
10266899344 |
10720485376 |
1310419216 |
13.790 |
94 |
27 |
52 |
0 |
1326478752 |
10091568 |
5967968 |
15:18:24 |
95575 |
8192000000 |
10271807520 |
10717978624 |
1321477360 |
13.890 |
95 |
16 |
32 |
0 |
1338540224 |
12642448 |
4420416 |
15:21:19 |
61198 |
8192000000 |
10288135792 |
10737520640 |
1365514832 |
14.287 |
99 |
14 |
28 |
0 |
1383646208 |
14426704 |
3704672 |
15:23:48 |
23315 |
8192000000 |
10272886320 |
10712227840 |
1344033344 |
14.094 |
98 |
30 |
59 |
0 |
1358764640 |
7908800 |
6822496 |
15:25:15 |
26312 |
8192000000 |
10241052992 |
10683207680 |
1309137536 |
13.778 |
98 |
37 |
72 |
0 |
1331243552 |
13940384 |
8165632 |
15:26:41 |
52506 |
8192000000 |
10255569968 |
10706948096 |
1340141600 |
14.059 |
99 |
27 |
54 |
0 |
1357298272 |
11370240 |
5786432 |
15:28:42 |
29790 |
8192000000 |
10236477280 |
10670653440 |
1299800496 |
13.693 |
97 |
13 |
26 |
1 |
1311644976 |
8975968 |
2868512 |
15:30:12 |
57869 |
8192000000 |
10265279648 |
10694373376 |
1322255648 |
13.897 |
98 |
25 |
50 |
0 |
1337366640 |
9515008 |
5595984 |
15:32:11 |
26550 |
8192000000 |
10265065312 |
10696396800 |
1329022912 |
13.958 |
99 |
37 |
76 |
0 |
1347593856 |
10238432 |
8332512 |
15:33:41 |
60536 |
8192000000 |
10247990400 |
10696515584 |
1346195552 |
14.113 |
100 |
16 |
32 |
0 |
1360008368 |
10082880 |
3729936 |
15:36:33 |
66788 |
8192000000 |
10265086672 |
10705641472 |
1349348624 |
14.142 |
99 |
27 |
54 |
0 |
1366654704 |
11218144 |
6087936 |
15:38:40 |
31080 |
8192000000 |
10268838784 |
10725580800 |
1352934000 |
14.174 |
99 |
34 |
65 |
1 |
1374846080 |
13957280 |
7954800 |
15:40:21 |
29594 |
8192000000 |
10263046912 |
10717687808 |
1358391040 |
14.223 |
99 |
5 |
11 |
0 |
1365316768 |
6064656 |
861072 |
15:41:51 |
68824 |
8192000000 |
10281387808 |
10742112256 |
1379574880 |
14.413 |
100 |
10 |
20 |
0 |
1397613728 |
15624016 |
2414832 |
15:44:00 |
40849 |
8192000000 |
10278593744 |
10731143168 |
1359665104 |
14.234 |
98 |
13 |
27 |
0 |
1370937296 |
8468816 |
2803376 |
15:45:41 |
56195 |
8192000000 |
10301561744 |
10750148608 |
1379982464 |
14.416 |
99 |
15 |
29 |
0 |
1397062832 |
13448128 |
3632240 |
15:47:47 |
58997 |
8192000000 |
10299957632 |
10745782272 |
1386464320 |
14.474 |
99 |
23 |
46 |
0 |
1402656704 |
10638640 |
5553744 |
15:49:49 |
51536 |
8192000000 |
10312048288 |
10762010624 |
1363709744 |
14.271 |
97 |
21 |
40 |
1 |
1380889840 |
12637712 |
4542384 |
15:51:45 |
68709 |
8192000000 |
10306212112 |
10767298560 |
1386296112 |
14.473 |
99 |
33 |
66 |
1 |
1407189760 |
13567424 |
7326224 |
15:53:54 |
146765 |
8192000000 |
10333596848 |
10799001600 |
1374933504 |
14.371 |
97 |
12 |
24 |
0 |
1397655360 |
19567712 |
3154144 |
15:57:24 |
85440 |
8192000000 |
10319716592 |
10769682432 |
1392672576 |
14.530 |
99 |
28 |
56 |
0 |
1407300304 |
8728784 |
5898944 |
15:59:52 |
23412 |
8192000000 |
10322434736 |
10782056448 |
1396163584 |
14.561 |
99 |
32 |
61 |
0 |
1420393616 |
17670480 |
6559552 |
16:01:18 |
25040 |
8192000000 |
10306680640 |
10752761856 |
1368207728 |
14.311 |
98 |
36 |
71 |
1 |
1388089152 |
11569936 |
8311488 |
16:02:44 |
72157 |
8192000000 |
10275343552 |
10733465600 |
1339970704 |
14.057 |
96 |
13 |
26 |
0 |
1356852544 |
13892512 |
2989328 |
16:04:57 |
100009 |
8192000000 |
10276272016 |
10745200640 |
1363579472 |
14.269 |
99 |
14 |
28 |
0 |
1378157984 |
10969488 |
3609024 |
16:07:39 |
50514 |
8192000000 |
10284535136 |
10749874176 |
1375110560 |
14.373 |
99 |
14 |
28 |
0 |
1389113840 |
10859312 |
3143968 |
16:09:29 |
9071 |
8192000000 |
8955164928 |
9126203392 |
130998048 |
1.573 |
10 |
1 |
2 |
0 |
134686592 |
3646192 |
42352 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 21-02-2024 16:11:13 to 21-02-2024 16:11:27.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
114 |
v_add_invoice_to_stock |
335544517 |
except |
14 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-02-2024 16:11:28 to 21-02-2024 16:11:30.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 173861
MON$OLDEST_ACTIVE 173862
MON$OLDEST_SNAPSHOT 173862
MON$NEXT_TRANSACTION 173862
MON$PAGE_BUFFERS 1000000
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2020-04-03 16:41:55.3470
MON$PAGES 1918880
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: LI-V3.0.12.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0
Database "/home/bases/oltp30-etalone.fdb"
Gstat execution time Wed Feb 21 16:11:31 2024
Database header page information:
Flags 0
Generation 90760
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 173861
Oldest active 173862
Oldest snapshot 173862
Next transaction 173863
Sequence number 0
Next attachment ID 701
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 3, 2020 16:41:55
Attributes force write
Variable header data:
Sweep interval: 0
Unrecognized option 11, length 16
*END*
Database file sequence:
File /home/bases/oltp30-etalone.fdb is the only file
Analyzing database pages ...
AGENTS (150)
Primary pointer page: 496, Index root page: 497
Total formats: 1, used formats: 1
Average record length: 33.60, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.20, total dup: 0, max dup: 0
Average key length: 15.88, compression ratio: 0.92
Average prefix length: 1.42, average data length: 13.20
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (154)
Primary pointer page: 504, Index root page: 505
Total formats: 1, used formats: 1
Average record length: 108.20, total records: 20
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1235.00, compression ratio: 11.41
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 18.25, total dup: 0, max dup: 0
Average key length: 17.20, compression ratio: 1.24
Average prefix length: 7.05, average data length: 14.25
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_PREDICT_PRIOR (3)
Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.40, total dup: 0, max dup: 0
Average key length: 4.35, compression ratio: 0.67
Average prefix length: 1.20, average data length: 1.70
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 4.30, total dup: 6, max dup: 3
Average key length: 3.25, compression ratio: 0.72
Average prefix length: 1.35, average data length: 1.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.20, total dup: 0, max dup: 0
Average key length: 4.15, compression ratio: 0.65
Average prefix length: 1.10, average data length: 1.60
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (139)
Primary pointer page: 474, Index root page: 475
Total formats: 1, used formats: 1
Average record length: 47.45, total records: 7675099
Average version length: 48.17, total versions: 70532, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.35
Pointer pages: 54, data page slots: 86976
Data pages: 86976, average fill: 70%
Primary pages: 86976, secondary pages: 0, swept pages: 28624
Empty pages: 4, full pages: 55184
Fill distribution:
0 - 19% = 18
20 - 39% = 323
40 - 59% = 4214
60 - 79% = 82409
80 - 99% = 12
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510614, depth: 3, leaf buckets: 23086, nodes: 7675099
Average node length: 18.85, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 1.70
Average prefix length: 14.14, average data length: 12.86
Clustering factor: 1669859, ratio: 0.22
Fill distribution:
0 - 19% = 296
20 - 39% = 2081
40 - 59% = 3848
60 - 79% = 2476
80 - 99% = 14385
Index DOC_DATA_ID_DESC (1)
Root page: 1528118, depth: 3, leaf buckets: 13441, nodes: 7675099
Average node length: 11.20, total dup: 0, max dup: 0
Average key length: 8.21, compression ratio: 1.10
Average prefix length: 3.78, average data length: 5.22
Clustering factor: 1493263, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 1726
40 - 59% = 1883
60 - 79% = 1150
80 - 99% = 8682
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546711, depth: 3, leaf buckets: 8281, nodes: 7675099
Average node length: 6.60, total dup: 5766618, max dup: 49
Average key length: 3.61, compression ratio: 2.49
Average prefix length: 7.64, average data length: 1.36
Clustering factor: 1486277, ratio: 0.19
Fill distribution:
0 - 19% = 127
20 - 39% = 1083
40 - 59% = 1266
60 - 79% = 954
80 - 99% = 4851
DOC_LIST (138)
Primary pointer page: 472, Index root page: 473
Total formats: 1, used formats: 1
Average record length: 56.47, total records: 2198456
Average version length: 34.73, total versions: 71432, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 84.00, compression ratio: 1.49
Pointer pages: 18, data page slots: 28512
Data pages: 28512, average fill: 71%
Primary pages: 28508, secondary pages: 4, swept pages: 13792
Empty pages: 2, full pages: 17583
Fill distribution:
0 - 19% = 25
20 - 39% = 220
40 - 59% = 2863
60 - 79% = 24953
80 - 99% = 451
Index DOC_LIST_ID_DESC (1)
Root page: 1541130, depth: 3, leaf buckets: 4494, nodes: 2198456
Average node length: 11.41, total dup: 0, max dup: 0
Average key length: 8.45, compression ratio: 1.06
Average prefix length: 3.54, average data length: 5.46
Clustering factor: 674324, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 1007
40 - 59% = 742
60 - 79% = 731
80 - 99% = 2014
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544376, depth: 3, leaf buckets: 2491, nodes: 2200608
Average node length: 4.97, total dup: 2199710, max dup: 20022
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1223496, ratio: 0.56
Fill distribution:
0 - 19% = 1
20 - 39% = 269
40 - 59% = 1567
60 - 79% = 480
80 - 99% = 174
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545909, depth: 3, leaf buckets: 2056, nodes: 2198456
Average node length: 4.97, total dup: 2198406, max dup: 130267
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1049893, ratio: 0.48
Fill distribution:
0 - 19% = 6
20 - 39% = 251
40 - 59% = 933
60 - 79% = 58
80 - 99% = 808
Index PK_DOC_LIST (0)
Root page: 1538187, depth: 3, leaf buckets: 4296, nodes: 2198456
Average node length: 11.41, total dup: 0, max dup: 0
Average key length: 8.45, compression ratio: 1.06
Average prefix length: 3.54, average data length: 5.46
Clustering factor: 674324, ratio: 0.31
Fill distribution:
0 - 19% = 96
20 - 39% = 652
40 - 59% = 546
60 - 79% = 870
80 - 99% = 2132
DOC_STATES (149)
Primary pointer page: 494, Index root page: 495
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (155)
Primary pointer page: 506, Index root page: 507
Total formats: 2, used formats: 2
Average record length: 54.76, total records: 2182
Average version length: 79.61, total versions: 757, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 270.43, compression ratio: 4.94
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 70%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7
80 - 99% = 26
Index FB_ERRORS_GDS_CODE (0)
Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182
Average node length: 4.40, total dup: 756, max dup: 1
Average key length: 2.67, compression ratio: 1.87
Average prefix length: 4.33, average data length: 0.67
Clustering factor: 1515, ratio: 0.69
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
INVNT_SALDO (145)
Primary pointer page: 486, Index root page: 487
Total formats: 2, used formats: 1
Average record length: 82.43, total records: 400
Average version length: 23.13, total versions: 223117, max versions: 585
Average fragment length: 2.04, total fragments: 46, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.26
Pointer pages: 1, data page slots: 1240
Data pages: 1240, average fill: 90%
Primary pages: 14, secondary pages: 1226, swept pages: 0
Empty pages: 7, full pages: 1232
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1233
Index PK_INVNT_SALDO (0)
Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 326, ratio: 0.81
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (153)
Primary pointer page: 502, Index root page: 503
Total formats: 1, used formats: 1
Average record length: 12.11, total records: 97811
Average version length: 68.29, total versions: 80482, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 7.27
Pointer pages: 6, data page slots: 3240
Data pages: 1847, average fill: 65%
Primary pages: 1846, secondary pages: 1, swept pages: 0
Empty pages: 317, full pages: 1269
Fill distribution:
0 - 19% = 406
20 - 39% = 81
40 - 59% = 59
60 - 79% = 248
80 - 99% = 1053
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1702991, depth: 3, leaf buckets: 369, nodes: 97811
Average node length: 13.49, total dup: 7730, max dup: 3
Average key length: 10.63, compression ratio: 2.54
Average prefix length: 19.29, average data length: 7.71
Clustering factor: 69933, ratio: 0.71
Fill distribution:
0 - 19% = 1
20 - 39% = 138
40 - 59% = 199
60 - 79% = 29
80 - 99% = 2
MONEY_SALDO (141)
Primary pointer page: 478, Index root page: 479
Total formats: 1, used formats: 1
Average record length: 15.29, total records: 49
Average version length: 9.00, total versions: 16768, max versions: 916
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.09
Pointer pages: 1, data page slots: 64
Data pages: 64, average fill: 84%
Primary pages: 6, secondary pages: 58, swept pages: 0
Empty pages: 5, full pages: 58
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 57
Index PK_MONEY_SALDO (0)
Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (140)
Primary pointer page: 476, Index root page: 477
Total formats: 1, used formats: 1
Average record length: 5.76, total records: 1769
Average version length: 43.35, total versions: 1543, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 10.06
Pointer pages: 1, data page slots: 40
Data pages: 38, average fill: 45%
Primary pages: 37, secondary pages: 1, swept pages: 10
Empty pages: 11, full pages: 12
Fill distribution:
0 - 19% = 15
20 - 39% = 2
40 - 59% = 5
60 - 79% = 4
80 - 99% = 12
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 92797, depth: 2, leaf buckets: 7, nodes: 1769
Average node length: 4.34, total dup: 1671, max dup: 180
Average key length: 2.62, compression ratio: 7.25
Average prefix length: 18.43, average data length: 0.57
Clustering factor: 925, ratio: 0.52
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_CACHE_MEMORY (165)
Primary pointer page: 526, Index root page: 527
Total formats: 2, used formats: 1
Average record length: 97.03, total records: 73
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 112.00, compression ratio: 1.15
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 51%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index PK_MON_CACHE_MEMORY (0)
Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 10.67, compression ratio: 0.84
Average prefix length: 1.32, average data length: 7.68
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 520, Index root page: 521
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (163)
Primary pointer page: 522, Index root page: 523
Total formats: 2, used formats: 1
Average record length: 67.13, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 611.00, compression ratio: 9.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.50, total dup: 23, max dup: 4
Average key length: 2.47, compression ratio: 3.24
Average prefix length: 7.53, average data length: 0.47
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 2.00, total dup: 29, max dup: 29
Average key length: 1.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.33, total dup: 29, max dup: 29
Average key length: 2.30, compression ratio: 3.91
Average prefix length: 8.70, average data length: 0.30
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 12.90, total dup: 0, max dup: 0
Average key length: 11.87, compression ratio: 1.42
Average prefix length: 7.63, average data length: 9.20
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 8.37, total dup: 0, max dup: 0
Average key length: 7.33, compression ratio: 1.23
Average prefix length: 4.63, average data length: 4.37
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (136)
Primary pointer page: 468, Index root page: 469
Total formats: 2, used formats: 1
Average record length: 67.56, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 386.00, compression ratio: 5.71
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (146)
Primary pointer page: 488, Index root page: 489
Total formats: 1, used formats: 1
Average record length: 36.59, total records: 835689
Average version length: 25.60, total versions: 50983, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.48
Pointer pages: 6, data page slots: 8312
Data pages: 8312, average fill: 70%
Primary pages: 8294, secondary pages: 18, swept pages: 2168
Empty pages: 23, full pages: 6852
Fill distribution:
0 - 19% = 53
20 - 39% = 85
40 - 59% = 288
60 - 79% = 7735
80 - 99% = 151
Index PDISTR_AGENT_ID (2)
Root page: 1509308, depth: 2, leaf buckets: 914, nodes: 835689
Average node length: 4.87, total dup: 835640, max dup: 163242
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 90561, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 120
40 - 59% = 518
60 - 79% = 212
80 - 99% = 64
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508613, depth: 3, leaf buckets: 991, nodes: 835689
Average node length: 5.88, total dup: 744040, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 164761, ratio: 0.20
Fill distribution:
0 - 19% = 2
20 - 39% = 100
40 - 59% = 502
60 - 79% = 87
80 - 99% = 300
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509187, depth: 3, leaf buckets: 1032, nodes: 835689
Average node length: 5.88, total dup: 744040, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 166767, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 199
40 - 59% = 454
60 - 79% = 84
80 - 99% = 294
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510178, depth: 3, leaf buckets: 1182, nodes: 835689
Average node length: 5.96, total dup: 744040, max dup: 42
Average key length: 3.10, compression ratio: 5.48
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 159148, ratio: 0.19
Fill distribution:
0 - 19% = 3
20 - 39% = 237
40 - 59% = 623
60 - 79% = 234
80 - 99% = 85
PERF_AGG (158)
Primary pointer page: 512, Index root page: 513
Total formats: 1, used formats: 1
Average record length: 62.86, total records: 5489
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 3.41, total fragments: 59, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.03
Pointer pages: 1, data page slots: 88
Data pages: 86, average fill: 63%
Primary pages: 72, secondary pages: 14, swept pages: 55
Empty pages: 6, full pages: 67
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 0
60 - 79% = 70
80 - 99% = 0
Index PERF_AGG_UNQ (1)
Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5489
Average node length: 5.50, total dup: 0, max dup: 0
Average key length: 3.58, compression ratio: 10.07
Average prefix length: 34.50, average data length: 1.54
Clustering factor: 5147, ratio: 0.94
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 2
Index PK_PERF_AGG (0)
Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5489
Average node length: 11.13, 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: 151, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
PERF_ESTIMATED (280)
Primary pointer page: 1504218, Index root page: 1504219
Total formats: 1, used formats: 1
Average record length: 39.13, total records: 79150
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: 768
Data pages: 768, average fill: 71%
Primary pages: 768, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 762
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 762
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 36555, depth: 2, leaf buckets: 100, nodes: 79150
Average node length: 10.17, total dup: 0, max dup: 0
Average key length: 8.18, compression ratio: 1.10
Average prefix length: 3.82, average data length: 5.18
Clustering factor: 3324, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 100
PERF_ISQL_STAT (156)
Primary pointer page: 508, Index root page: 509
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (159)
Primary pointer page: 514, Index root page: 515
Total formats: 1, used formats: 1
Average record length: 111.11, total records: 72
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1691.00, compression ratio: 15.22
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 57%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
PERF_SPLIT_0 (281)
Primary pointer page: 573, Index root page: 574
Total formats: 1, used formats: 1
Average record length: 142.68, total records: 189259
Average version length: 153.40, total versions: 10666, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.89
Pointer pages: 6, data page slots: 5488
Data pages: 4584, average fill: 86%
Primary pages: 4584, secondary pages: 0, swept pages: 1
Empty pages: 81, full pages: 4481
Fill distribution:
0 - 19% = 84
20 - 39% = 8
40 - 59% = 4
60 - 79% = 8
80 - 99% = 4480
PERF_SPLIT_1 (282)
Primary pointer page: 576, Index root page: 577
Total formats: 1, used formats: 1
Average record length: 125.85, total records: 201472
Average version length: 154.51, total versions: 33564, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.48
Pointer pages: 7, data page slots: 6568
Data pages: 4872, average fill: 87%
Primary pages: 4872, secondary pages: 0, swept pages: 1
Empty pages: 66, full pages: 4779
Fill distribution:
0 - 19% = 71
20 - 39% = 8
40 - 59% = 9
60 - 79% = 7
80 - 99% = 4777
PERF_SPLIT_2 (283)
Primary pointer page: 578, Index root page: 579
Total formats: 1, used formats: 1
Average record length: 139.36, total records: 161148
Average version length: 154.45, total versions: 12227, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.17
Pointer pages: 7, data page slots: 4904
Data pages: 3936, average fill: 85%
Primary pages: 3936, secondary pages: 0, swept pages: 1
Empty pages: 67, full pages: 3771
Fill distribution:
0 - 19% = 71
20 - 39% = 6
40 - 59% = 78
60 - 79% = 9
80 - 99% = 3772
PERF_SPLIT_3 (284)
Primary pointer page: 580, Index root page: 581
Total formats: 1, used formats: 1
Average record length: 143.57, total records: 184321
Average version length: 153.12, total versions: 9471, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.81
Pointer pages: 6, data page slots: 5056
Data pages: 4448, average fill: 86%
Primary pages: 4448, secondary pages: 0, swept pages: 1
Empty pages: 58, full pages: 4365
Fill distribution:
0 - 19% = 64
20 - 39% = 5
40 - 59% = 7
60 - 79% = 7
80 - 99% = 4365
PERF_SPLIT_4 (285)
Primary pointer page: 582, Index root page: 583
Total formats: 1, used formats: 1
Average record length: 137.03, total records: 157095
Average version length: 154.76, total versions: 14373, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.38
Pointer pages: 6, data page slots: 5680
Data pages: 3800, average fill: 86%
Primary pages: 3799, secondary pages: 1, swept pages: 1
Empty pages: 61, full pages: 3717
Fill distribution:
0 - 19% = 63
20 - 39% = 12
40 - 59% = 1
60 - 79% = 7
80 - 99% = 3717
PERF_SPLIT_5 (286)
Primary pointer page: 584, Index root page: 585
Total formats: 1, used formats: 1
Average record length: 149.65, total records: 179993
Average version length: 151.81, total versions: 1644, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.33
Pointer pages: 7, data page slots: 4400
Data pages: 4296, average fill: 86%
Primary pages: 4296, secondary pages: 0, swept pages: 1
Empty pages: 27, full pages: 4261
Fill distribution:
0 - 19% = 29
20 - 39% = 3
40 - 59% = 0
60 - 79% = 3
80 - 99% = 4261
PERF_SPLIT_6 (287)
Primary pointer page: 586, Index root page: 587
Total formats: 1, used formats: 1
Average record length: 147.82, total records: 168949
Average version length: 152.18, total versions: 3655, 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: 7, data page slots: 5712
Data pages: 4048, average fill: 86%
Primary pages: 4048, secondary pages: 0, swept pages: 2
Empty pages: 31, full pages: 3992
Fill distribution:
0 - 19% = 34
20 - 39% = 4
40 - 59% = 11
60 - 79% = 7
80 - 99% = 3992
PERF_SPLIT_7 (288)
Primary pointer page: 588, Index root page: 589
Total formats: 1, used formats: 1
Average record length: 150.87, total records: 169801
Average version length: 138.20, total versions: 392, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.24
Pointer pages: 7, data page slots: 4496
Data pages: 4072, average fill: 86%
Primary pages: 4072, secondary pages: 0, swept pages: 5
Empty pages: 39, full pages: 4020
Fill distribution:
0 - 19% = 42
20 - 39% = 3
40 - 59% = 3
60 - 79% = 2
80 - 99% = 4022
PERF_SPLIT_8 (289)
Primary pointer page: 590, Index root page: 591
Total formats: 1, used formats: 1
Average record length: 149.32, total records: 158048
Average version length: 151.26, total versions: 1704, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.36
Pointer pages: 6, data page slots: 5664
Data pages: 3800, average fill: 86%
Primary pages: 3800, secondary pages: 0, swept pages: 1
Empty pages: 50, full pages: 3735
Fill distribution:
0 - 19% = 52
20 - 39% = 4
40 - 59% = 3
60 - 79% = 6
80 - 99% = 3735
PERF_SPLIT_9 (290)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 149.48, total records: 156306
Average version length: 150.22, total versions: 1544, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.35
Pointer pages: 7, data page slots: 5024
Data pages: 3760, average fill: 86%
Primary pages: 3760, secondary pages: 0, swept pages: 1
Empty pages: 50, full pages: 3695
Fill distribution:
0 - 19% = 50
20 - 39% = 9
40 - 59% = 2
60 - 79% = 4
80 - 99% = 3695
PHRASES (143)
Primary pointer page: 482, Index root page: 483
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (147)
Primary pointer page: 490, Index root page: 491
Total formats: 1, used formats: 1
Average record length: 52.00, total records: 2053548
Average version length: 52.92, total versions: 29052, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 70.00, compression ratio: 1.35
Pointer pages: 16, data page slots: 25496
Data pages: 25496, average fill: 69%
Primary pages: 25496, secondary pages: 0, swept pages: 12778
Empty pages: 385, full pages: 18923
Fill distribution:
0 - 19% = 737
20 - 39% = 647
40 - 59% = 1512
60 - 79% = 22379
80 - 99% = 221
Index PSTORNED_RCV_ID (1)
Root page: 1506186, depth: 3, leaf buckets: 2559, nodes: 2053548
Average node length: 5.45, total dup: 1914970, max dup: 1743
Average key length: 2.49, compression ratio: 3.61
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 178966, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 319
40 - 59% = 1682
60 - 79% = 276
80 - 99% = 281
Index PSTORNED_SND_ID (0)
Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2053548
Average node length: 5.70, total dup: 1842076, max dup: 70
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 368172, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 2497
60 - 79% = 219
80 - 99% = 25
Index PSTORNED_WORKER_ID (2)
Root page: 1507996, depth: 3, leaf buckets: 2144, nodes: 2053548
Average node length: 4.96, total dup: 2053448, max dup: 27717
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 176849, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 228
40 - 59% = 1174
60 - 79% = 379
80 - 99% = 360
RULES_FOR_PDISTR (148)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 470, Index root page: 471
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 466, Index root page: 467
Total formats: 1, used formats: 1
Average record length: 97.63, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index SETTINGS_MCODE_WM_UNQ (1)
Root page: 525, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 454, Index root page: 455
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 460, Index root page: 461
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 462, Index root page: 463
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 464, Index root page: 465
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 518, Index root page: 519
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 516, Index root page: 517
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 458, Index root page: 459
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 456, Index root page: 457
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 452, Index root page: 453
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 510, Index root page: 511
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 549, Index root page: 550
Total formats: 1, used formats: 1
Average record length: 45.10, total records: 129391
Average version length: 69.17, total versions: 45076, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 2.79
Pointer pages: 3, data page slots: 4120
Data pages: 3120, average fill: 48%
Primary pages: 3120, secondary pages: 0, swept pages: 606
Empty pages: 621, full pages: 1207
Fill distribution:
0 - 19% = 947
20 - 39% = 333
40 - 59% = 350
60 - 79% = 659
80 - 99% = 831
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 340842, depth: 3, leaf buckets: 215, nodes: 129391
Average node length: 6.39, total dup: 112465, max dup: 18
Average key length: 3.99, compression ratio: 10.53
Average prefix length: 40.14, average data length: 1.86
Clustering factor: 21648, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 72
40 - 59% = 93
60 - 79% = 46
80 - 99% = 4
XQD_1000_3300 (178)
Primary pointer page: 553, Index root page: 554
Total formats: 1, used formats: 1
Average record length: 66.16, total records: 7297192
Average version length: 68.77, total versions: 297158, 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: 65, data page slots: 105672
Data pages: 105672, average fill: 74%
Primary pages: 105672, secondary pages: 0, swept pages: 39863
Empty pages: 22, full pages: 79729
Fill distribution:
0 - 19% = 158
20 - 39% = 900
40 - 59% = 6804
60 - 79% = 93883
80 - 99% = 3927
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480454, depth: 3, leaf buckets: 10775, nodes: 7297192
Average node length: 6.51, total dup: 6309708, max dup: 29
Average key length: 3.52, compression ratio: 11.92
Average prefix length: 40.61, average data length: 1.39
Clustering factor: 1600578, ratio: 0.22
Fill distribution:
0 - 19% = 7
20 - 39% = 1190
40 - 59% = 6093
60 - 79% = 3006
80 - 99% = 479
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486068, depth: 3, leaf buckets: 8701, nodes: 7297192
Average node length: 5.39, total dup: 7011576, max dup: 140
Average key length: 2.40, compression ratio: 7.08
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1399611, ratio: 0.19
Fill distribution:
0 - 19% = 6
20 - 39% = 979
40 - 59% = 5075
60 - 79% = 1553
80 - 99% = 1088
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490608, depth: 3, leaf buckets: 8792, nodes: 7297192
Average node length: 5.39, total dup: 7011576, max dup: 140
Average key length: 2.40, compression ratio: 7.08
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1402171, ratio: 0.19
Fill distribution:
0 - 19% = 5
20 - 39% = 1081
40 - 59% = 5091
60 - 79% = 1558
80 - 99% = 1057
XQD_1200_2000 (177)
Primary pointer page: 551, Index root page: 552
Total formats: 1, used formats: 1
Average record length: 67.66, total records: 12204043
Average version length: 68.70, total versions: 229218, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.86
Pointer pages: 105, data page slots: 170648
Data pages: 170648, average fill: 76%
Primary pages: 170648, secondary pages: 0, swept pages: 89861
Empty pages: 13, full pages: 154567
Fill distribution:
0 - 19% = 59
20 - 39% = 673
40 - 59% = 4477
60 - 79% = 161858
80 - 99% = 3581
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495028, depth: 3, leaf buckets: 18470, nodes: 12204043
Average node length: 6.59, total dup: 10634773, max dup: 57
Average key length: 3.43, compression ratio: 12.25
Average prefix length: 40.70, average data length: 1.30
Clustering factor: 2377024, ratio: 0.19
Fill distribution:
0 - 19% = 25
20 - 39% = 2003
40 - 59% = 10901
60 - 79% = 4879
80 - 99% = 662
XQD_2000_3300 (179)
Primary pointer page: 555, Index root page: 556
Total formats: 1, used formats: 1
Average record length: 49.44, total records: 1464344
Average version length: 69.11, total versions: 417169, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 2.55
Pointer pages: 28, data page slots: 44992
Data pages: 29104, average fill: 57%
Primary pages: 29104, secondary pages: 0, swept pages: 11254
Empty pages: 3792, full pages: 15642
Fill distribution:
0 - 19% = 6208
20 - 39% = 2617
40 - 59% = 2622
60 - 79% = 11208
80 - 99% = 6449
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479712, depth: 3, leaf buckets: 2255, nodes: 1464344
Average node length: 5.52, total dup: 1405019, max dup: 97
Average key length: 2.57, compression ratio: 16.35
Average prefix length: 41.47, average data length: 0.53
Clustering factor: 100089, ratio: 0.07
Fill distribution:
0 - 19% = 3
20 - 39% = 957
40 - 59% = 963
60 - 79% = 285
80 - 99% = 47
XQD_2100_3300 (180)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 1
Average record length: 43.98, total records: 1030576
Average version length: 69.13, total versions: 373863, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 2.86
Pointer pages: 20, data page slots: 32296
Data pages: 26616, average fill: 45%
Primary pages: 26616, secondary pages: 0, swept pages: 6516
Empty pages: 4075, full pages: 9579
Fill distribution:
0 - 19% = 8518
20 - 39% = 4581
40 - 59% = 2553
60 - 79% = 4172
80 - 99% = 6792
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479207, depth: 3, leaf buckets: 1545, nodes: 1030576
Average node length: 5.82, total dup: 958468, max dup: 91
Average key length: 2.90, compression ratio: 14.49
Average prefix length: 41.17, average data length: 0.83
Clustering factor: 142649, ratio: 0.14
Fill distribution:
0 - 19% = 4
20 - 39% = 505
40 - 59% = 685
60 - 79% = 299
80 - 99% = 52
XQD_3300_3400 (181)
Primary pointer page: 559, Index root page: 560
Total formats: 1, used formats: 1
Average record length: 66.40, total records: 8768498
Average version length: 68.98, total versions: 317132, 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: 89, data page slots: 144104
Data pages: 144048, average fill: 65%
Primary pages: 144047, secondary pages: 1, swept pages: 78040
Empty pages: 499, full pages: 61578
Fill distribution:
0 - 19% = 1650
20 - 39% = 10082
40 - 59% = 30975
60 - 79% = 97193
80 - 99% = 4148
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472590, depth: 3, leaf buckets: 13465, nodes: 8768498
Average node length: 6.69, total dup: 7271955, max dup: 25
Average key length: 3.67, compression ratio: 11.43
Average prefix length: 40.50, average data length: 1.50
Clustering factor: 1839968, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 1649
40 - 59% = 7470
60 - 79% = 4023
80 - 99% = 321
XQS_1000_1200 (182)
Primary pointer page: 561, Index root page: 562
Total formats: 1, used formats: 1
Average record length: 82.51, total records: 21124061
Average version length: 82.83, total versions: 6252, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.53
Pointer pages: 196, data page slots: 318488
Data pages: 318488, average fill: 81%
Primary pages: 318488, secondary pages: 0, swept pages: 13231
Empty pages: 42, full pages: 317411
Fill distribution:
0 - 19% = 72
20 - 39% = 71
40 - 59% = 163
60 - 79% = 27768
80 - 99% = 290414
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426716, depth: 3, leaf buckets: 19339, nodes: 21124061
Average node length: 5.72, total dup: 20643517, max dup: 128
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3277542, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 8097
60 - 79% = 519
80 - 99% = 10717
Index XQS_1000_1200_RCV_ID (3)
Root page: 1456980, depth: 3, leaf buckets: 17143, nodes: 21124061
Average node length: 6.31, total dup: 18563007, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 914959, ratio: 0.04
Fill distribution:
0 - 19% = 3
20 - 39% = 6
40 - 59% = 752
60 - 79% = 289
80 - 99% = 16093
Index XQS_1000_1200_SND_ID (2)
Root page: 1441073, depth: 3, leaf buckets: 21150, nodes: 21124061
Average node length: 6.35, total dup: 18482597, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3572153, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 8430
60 - 79% = 590
80 - 99% = 12124
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413348, depth: 3, leaf buckets: 16110, nodes: 21124061
Average node length: 5.56, total dup: 21123961, max dup: 228573
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 943741, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 2924
60 - 79% = 407
80 - 99% = 12771
XQS_1000_3300 (184)
Primary pointer page: 565, Index root page: 566
Total formats: 1, used formats: 1
Average record length: 79.28, total records: 9253147
Average version length: 82.63, total versions: 349980, 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: 105, data page slots: 170728
Data pages: 170704, average fill: 67%
Primary pages: 170704, secondary pages: 0, swept pages: 94255
Empty pages: 879, full pages: 82673
Fill distribution:
0 - 19% = 2533
20 - 39% = 11197
40 - 59% = 34220
60 - 79% = 73592
80 - 99% = 49162
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367502, depth: 3, leaf buckets: 11361, nodes: 9253147
Average node length: 5.38, total dup: 8948782, max dup: 173
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 1993973, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 128
40 - 59% = 9361
60 - 79% = 1849
80 - 99% = 23
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379261, depth: 3, leaf buckets: 13075, nodes: 9253147
Average node length: 6.24, total dup: 7668719, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1348021, ratio: 0.15
Fill distribution:
0 - 19% = 123
20 - 39% = 4033
40 - 59% = 4081
60 - 79% = 2541
80 - 99% = 2297
Index XQS_1000_3300_SND_ID (2)
Root page: 1373059, depth: 3, leaf buckets: 12685, nodes: 9253147
Average node length: 6.00, total dup: 8017758, max dup: 43
Average key length: 2.86, compression ratio: 3.15
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 2177538, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 161
40 - 59% = 10404
60 - 79% = 2091
80 - 99% = 27
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362767, depth: 3, leaf buckets: 9838, nodes: 9253147
Average node length: 5.14, total dup: 9253047, max dup: 158439
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1405425, ratio: 0.15
Fill distribution:
0 - 19% = 52
20 - 39% = 1443
40 - 59% = 4780
60 - 79% = 1597
80 - 99% = 1966
XQS_1200_2000 (183)
Primary pointer page: 563, Index root page: 564
Total formats: 1, used formats: 1
Average record length: 80.53, total records: 10953592
Average version length: 82.54, total versions: 234862, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.56
Pointer pages: 119, data page slots: 193272
Data pages: 191312, average fill: 70%
Primary pages: 191312, secondary pages: 0, swept pages: 86031
Empty pages: 4107, full pages: 130235
Fill distribution:
0 - 19% = 7115
20 - 39% = 10188
40 - 59% = 22662
60 - 79% = 46318
80 - 99% = 105029
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392101, depth: 3, leaf buckets: 13138, nodes: 10953592
Average node length: 5.30, total dup: 10844114, max dup: 623
Average key length: 2.08, compression ratio: 4.32
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2278283, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 254
40 - 59% = 9892
60 - 79% = 2914
80 - 99% = 77
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406110, depth: 3, leaf buckets: 10307, nodes: 10953592
Average node length: 5.50, total dup: 10474020, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 687304, ratio: 0.06
Fill distribution:
0 - 19% = 193
20 - 39% = 913
40 - 59% = 2564
60 - 79% = 1898
80 - 99% = 4739
Index XQS_1200_2000_SND_ID (2)
Root page: 1398638, depth: 3, leaf buckets: 15024, nodes: 10953592
Average node length: 6.03, total dup: 9546993, max dup: 77
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 2294519, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 280
40 - 59% = 11510
60 - 79% = 3126
80 - 99% = 108
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386211, depth: 3, leaf buckets: 10550, nodes: 10953592
Average node length: 5.22, total dup: 10953492, max dup: 193072
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 677325, ratio: 0.06
Fill distribution:
0 - 19% = 94
20 - 39% = 963
40 - 59% = 4636
60 - 79% = 1493
80 - 99% = 3364
XQS_2000_3300 (185)
Primary pointer page: 567, Index root page: 568
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (1)
Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (3)
Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (2)
Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_WORKER_ID (0)
Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (186)
Primary pointer page: 569, Index root page: 570
Total formats: 1, used formats: 1
Average record length: 79.91, total records: 9332896
Average version length: 82.93, total versions: 318054, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.58
Pointer pages: 107, data page slots: 174560
Data pages: 174504, average fill: 66%
Primary pages: 174504, secondary pages: 0, swept pages: 104053
Empty pages: 861, full pages: 80794
Fill distribution:
0 - 19% = 2984
20 - 39% = 12489
40 - 59% = 36152
60 - 79% = 76245
80 - 99% = 46634
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344686, depth: 3, leaf buckets: 11481, nodes: 9332896
Average node length: 5.18, total dup: 9304591, max dup: 1662
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 1799909, ratio: 0.19
Fill distribution:
0 - 19% = 42
20 - 39% = 1608
40 - 59% = 7635
60 - 79% = 1694
80 - 99% = 502
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355717, depth: 3, leaf buckets: 13209, nodes: 9332896
Average node length: 6.26, total dup: 7735263, max dup: 14
Average key length: 3.11, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1306791, ratio: 0.14
Fill distribution:
0 - 19% = 181
20 - 39% = 4061
40 - 59% = 4028
60 - 79% = 2590
80 - 99% = 2349
Index XQS_2100_3300_SND_ID (2)
Root page: 1350049, depth: 3, leaf buckets: 12123, nodes: 9332896
Average node length: 5.44, total dup: 8910538, max dup: 91
Average key length: 2.29, compression ratio: 3.93
Average prefix length: 8.75, average data length: 0.25
Clustering factor: 1928634, ratio: 0.21
Fill distribution:
0 - 19% = 37
20 - 39% = 1591
40 - 59% = 8497
60 - 79% = 1527
80 - 99% = 471
Index XQS_2100_3300_WORKER_ID (0)
Root page: 985805, depth: 3, leaf buckets: 9908, nodes: 9332896
Average node length: 5.15, total dup: 9332796, max dup: 159441
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1406776, ratio: 0.15
Fill distribution:
0 - 19% = 48
20 - 39% = 1405
40 - 59% = 4873
60 - 79% = 1569
80 - 99% = 2013
XQS_3300_3400 (187)
Primary pointer page: 571, Index root page: 572
Total formats: 1, used formats: 1
Average record length: 67.54, total records: 568691
Average version length: 68.82, total versions: 5215, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.87
Pointer pages: 5, data page slots: 8024
Data pages: 8024, average fill: 74%
Primary pages: 8024, secondary pages: 0, swept pages: 4389
Empty pages: 3, full pages: 6202
Fill distribution:
0 - 19% = 6
20 - 39% = 55
40 - 59% = 367
60 - 79% = 7533
80 - 99% = 63
Index XQS_3300_3400_DOC_ID (1)
Root page: 45093, depth: 3, leaf buckets: 739, nodes: 568691
Average node length: 5.94, total dup: 484284, max dup: 82
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 98787, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 531
60 - 79% = 81
80 - 99% = 89
Index XQS_3300_3400_SND_ID (2)
Root page: 38445, depth: 3, leaf buckets: 761, nodes: 568691
Average node length: 6.15, total dup: 466505, max dup: 21
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 98836, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 543
60 - 79% = 84
80 - 99% = 95
Index XQS_3300_3400_WORKER_ID (0)
Root page: 375548, depth: 2, leaf buckets: 586, nodes: 568691
Average node length: 4.86, total dup: 568591, max dup: 9479
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 87876, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 48
40 - 59% = 356
60 - 79% = 89
80 - 99% = 93
ZDOC_DATA (170)
Primary pointer page: 537, Index root page: 538
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (169)
Primary pointer page: 535, Index root page: 536
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (171)
Primary pointer page: 539, Index root page: 540
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (174)
Primary pointer page: 545, Index root page: 546
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (175)
Primary pointer page: 547, Index root page: 548
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (172)
Primary pointer page: 541, Index root page: 542
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (173)
Primary pointer page: 543, Index root page: 544
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (168)
Primary pointer page: 533, Index root page: 534
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (167)
Primary pointer page: 531, Index root page: 532
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (144)
Primary pointer page: 484, Index root page: 485
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Wed Feb 21 16:11:54 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7675099 |
70532 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2198456 |
71432 |
4 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
223117 |
585 |
55700.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
97811 |
80482 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
16768 |
916 |
34200.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
1769 |
1543 |
1 |
0.0000 |
0.0000 |
PDISTR |
835689 |
50983 |
4 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
189259 |
10666 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
201472 |
33564 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
161148 |
12227 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
184321 |
9471 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
157095 |
14373 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
179993 |
1644 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
168949 |
3655 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
169801 |
392 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
158048 |
1704 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
156306 |
1544 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2053548 |
29052 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
129391 |
45076 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7297192 |
297158 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12204043 |
229218 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1464344 |
417169 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1030576 |
373863 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
8768498 |
317132 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21124061 |
6252 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9253147 |
349980 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
10953592 |
234862 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
9332896 |
318054 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
568691 |
5215 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
--- end of diff output ---
21.02.24 16:12:06. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
335544321 'string truncation'. Attempt to assign too long text into string variable.
335544347 'not_valid'. Validation error for column.
335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT |
ERRORS_RESULT |
2024-02-21 16:12:09 |
No severe PSQL-related problems occured |
21.02.24 16:12:10. End of report.