Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.02.2024 13:08
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 | 15694324 kB |
MemAvailable | 30235044 kB |
Buffers | 0 kB |
Cached | 16024964 kB |
SwapCached | 2472 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 4.0.5
DB_NAME /home/bases/oltp40-etalone.fdb
FORCED_WRITES ON
SWEEP_INT 0
PAGE_BUFFERS 1000000
PAGE_SIZE 8192
Test configuration settings
param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2024-02-25 13:07:49
DTS_END 2024-02-25 13:07:49.3920
FB_GDSCODE -1
FB_MNEMONA
STACK SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/47820
TRN_ID 176736
ATT_ID 519
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: |
9333.98 |
18449 |
933398 |
customer order: creation |
182.29 |
413 |
18229 |
customer order: refuse |
15.08 |
372 |
1508 |
order to supplier: creation |
48.60 |
1348 |
4860 |
order to supplier: removal |
3.25 |
92077 |
325 |
invoice (draft): creation |
49.20 |
3591 |
4920 |
invoice (draft): removal |
49.45 |
696 |
4945 |
invoice accept: apply |
44.91 |
20739 |
4491 |
invoice accept: cancel |
44.49 |
808 |
4449 |
customer reserve: creation |
4277.42 |
199 |
427742 |
customer reserve: removal |
4315.07 |
55 |
431507 |
realization accept: apply |
88.66 |
212 |
8866 |
realization accept: cancel |
80.87 |
116 |
8087 |
payment from customer: creation |
62.32 |
118 |
6232 |
payment from customer: removal |
5.79 |
82 |
579 |
payment to supplier: creation |
51.40 |
150 |
5140 |
payment to supplier: removal |
3.60 |
81 |
360 |
service: total inventory turnovers |
4.07 |
3803 |
407 |
service: total monetary turnovers |
6.45 |
621 |
645 |
service: aggregate perf. data |
1.03 |
13925 |
103 |
service: refresh index statistics |
0.03 |
229571 |
3 |
Completed "Performance in TOTAL". Done for 00:00:02, from 25-02-2024 13:08:36 to 25-02-2024 13:08:38.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
1409 |
TEST_TIME |
2 |
2475 |
TEST_TIME |
3 |
2994 |
TEST_TIME |
4 |
3546 |
TEST_TIME |
5 |
3409 |
TEST_TIME |
6 |
4024 |
TEST_TIME |
7 |
4840 |
TEST_TIME |
8 |
5067 |
TEST_TIME |
9 |
5105 |
TEST_TIME |
10 |
5499 |
TEST_TIME |
11 |
5797 |
TEST_TIME |
12 |
6164 |
TEST_TIME |
13 |
6336 |
TEST_TIME |
14 |
6392 |
TEST_TIME |
15 |
6614 |
TEST_TIME |
16 |
6837 |
TEST_TIME |
17 |
7136 |
TEST_TIME |
18 |
7457 |
TEST_TIME |
19 |
7550 |
TEST_TIME |
20 |
8582 |
TEST_TIME |
21 |
9388 |
TEST_TIME |
22 |
9461 |
TEST_TIME |
23 |
9820 |
TEST_TIME |
24 |
10397 |
TEST_TIME |
25 |
10001 |
TEST_TIME |
26 |
9819 |
TEST_TIME |
27 |
9580 |
TEST_TIME |
28 |
9709 |
TEST_TIME |
29 |
9565 |
TEST_TIME |
30 |
9377 |
TEST_TIME |
31 |
9220 |
TEST_TIME |
32 |
9330 |
TEST_TIME |
33 |
9128 |
TEST_TIME |
34 |
8930 |
TEST_TIME |
35 |
9161 |
TEST_TIME |
36 |
9186 |
TEST_TIME |
37 |
9110 |
TEST_TIME |
38 |
9146 |
TEST_TIME |
39 |
9301 |
TEST_TIME |
40 |
9282 |
TEST_TIME |
41 |
9173 |
TEST_TIME |
42 |
9395 |
TEST_TIME |
43 |
9466 |
TEST_TIME |
44 |
9484 |
TEST_TIME |
45 |
9476 |
TEST_TIME |
46 |
9432 |
TEST_TIME |
47 |
9666 |
TEST_TIME |
48 |
9700 |
TEST_TIME |
49 |
9637 |
TEST_TIME |
50 |
9468 |
TEST_TIME |
51 |
9370 |
TEST_TIME |
52 |
9341 |
TEST_TIME |
53 |
9419 |
TEST_TIME |
54 |
9381 |
TEST_TIME |
55 |
9326 |
TEST_TIME |
56 |
9303 |
TEST_TIME |
57 |
9237 |
TEST_TIME |
58 |
9201 |
TEST_TIME |
59 |
9138 |
TEST_TIME |
60 |
9166 |
TEST_TIME |
61 |
9212 |
TEST_TIME |
62 |
9242 |
TEST_TIME |
63 |
9324 |
TEST_TIME |
64 |
9273 |
TEST_TIME |
65 |
9294 |
TEST_TIME |
66 |
9358 |
TEST_TIME |
67 |
9344 |
TEST_TIME |
68 |
9430 |
TEST_TIME |
69 |
9453 |
TEST_TIME |
70 |
9458 |
TEST_TIME |
71 |
9350 |
TEST_TIME |
72 |
9271 |
TEST_TIME |
73 |
9271 |
TEST_TIME |
74 |
9192 |
TEST_TIME |
75 |
9158 |
TEST_TIME |
76 |
9155 |
TEST_TIME |
77 |
9226 |
TEST_TIME |
78 |
9227 |
TEST_TIME |
79 |
9235 |
TEST_TIME |
80 |
9294 |
TEST_TIME |
81 |
9250 |
TEST_TIME |
82 |
9303 |
TEST_TIME |
83 |
9350 |
TEST_TIME |
84 |
9398 |
TEST_TIME |
85 |
9398 |
TEST_TIME |
86 |
9386 |
TEST_TIME |
87 |
9445 |
TEST_TIME |
88 |
9375 |
TEST_TIME |
89 |
9297 |
TEST_TIME |
90 |
9255 |
TEST_TIME |
91 |
9220 |
TEST_TIME |
92 |
9214 |
TEST_TIME |
93 |
9176 |
TEST_TIME |
94 |
9166 |
TEST_TIME |
95 |
9161 |
TEST_TIME |
96 |
9220 |
TEST_TIME |
97 |
9170 |
TEST_TIME |
98 |
9234 |
TEST_TIME |
99 |
9337 |
TEST_TIME |
100 |
9338 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2024 13:08:39 to 25-02-2024 13:08:42.
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 |
1322667 |
1322667 |
0 |
0.00 |
0 |
16079 |
7 |
0 |
0 |
doc_list_biud |
1322664 |
1322664 |
0 |
0.00 |
0 |
96988 |
23 |
0 |
0 |
sp_add_invoice_to_stock |
4593 |
4491 |
102 |
2.22 |
28 |
200250 |
20739 |
0 |
102 |
sp_cancel_adding_invoice |
4449 |
4449 |
0 |
0.00 |
4 |
76213 |
808 |
0 |
0 |
sp_cancel_client_order |
1508 |
1508 |
0 |
0.00 |
4 |
10326 |
373 |
0 |
0 |
sp_cancel_customer_reserve |
431507 |
431507 |
0 |
0.00 |
0 |
30269 |
55 |
0 |
0 |
sp_cancel_pay_from_customer |
579 |
579 |
0 |
0.00 |
2 |
4330 |
82 |
0 |
0 |
sp_cancel_pay_to_supplier |
360 |
360 |
0 |
0.00 |
2 |
4327 |
82 |
0 |
0 |
sp_cancel_supplier_invoice |
4951 |
4945 |
6 |
0.12 |
1 |
96995 |
696 |
0 |
6 |
sp_cancel_supplier_order |
325 |
325 |
0 |
0.00 |
12 |
1109230 |
92077 |
0 |
0 |
sp_cancel_write_off |
8087 |
8087 |
0 |
0.00 |
1 |
12436 |
117 |
0 |
0 |
sp_client_order |
18229 |
18229 |
0 |
0.00 |
3 |
24701 |
413 |
0 |
0 |
sp_customer_reserve |
427742 |
427742 |
0 |
0.00 |
0 |
91440 |
199 |
0 |
0 |
sp_fill_shopping_cart |
28006 |
28006 |
0 |
0.00 |
1 |
36874 |
48 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
427735 |
427735 |
0 |
0.00 |
0 |
19444 |
16 |
0 |
0 |
sp_get_clo_for_invoice |
4484 |
4484 |
0 |
0.00 |
0 |
30727 |
389 |
0 |
0 |
sp_kill_cost_storno |
13475 |
13475 |
0 |
0.00 |
0 |
12403 |
69 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
876371 |
876371 |
0 |
0.00 |
0 |
96987 |
30 |
0 |
0 |
sp_kill_qty_storno |
464168 |
464168 |
0 |
0.00 |
0 |
96988 |
65 |
0 |
0 |
sp_lock_selected_doc |
18318 |
18318 |
0 |
0.00 |
0 |
6745 |
6 |
0 |
0 |
sp_make_cost_storno |
24722 |
24722 |
0 |
0.00 |
0 |
15948 |
67 |
0 |
0 |
sp_multiply_rows_for_pdistr |
24720 |
24720 |
0 |
0.00 |
0 |
14606 |
32 |
0 |
0 |
sp_multiply_rows_for_qdistr |
18229 |
18229 |
0 |
0.00 |
0 |
24521 |
220 |
0 |
0 |
sp_pay_from_customer |
6232 |
6232 |
0 |
0.00 |
4 |
14282 |
119 |
0 |
0 |
sp_pay_to_supplier |
5140 |
5140 |
0 |
0.00 |
4 |
20257 |
151 |
0 |
0 |
sp_payment_common |
11372 |
11372 |
0 |
0.00 |
1 |
13799 |
33 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1508 |
1508 |
0 |
0.00 |
0 |
10318 |
335 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
8930 |
8930 |
0 |
0.00 |
0 |
35674 |
317 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8866 |
8866 |
0 |
0.00 |
0 |
15758 |
66 |
0 |
0 |
sp_reserve_write_off |
8866 |
8866 |
0 |
0.00 |
6 |
18664 |
212 |
0 |
0 |
sp_supplier_invoice |
4920 |
4920 |
0 |
0.00 |
7 |
121362 |
3591 |
0 |
0 |
sp_supplier_order |
4860 |
4860 |
0 |
0.00 |
5 |
59926 |
1349 |
0 |
0 |
srv_aggregate_perf_data |
103 |
103 |
0 |
0.00 |
1608 |
193087 |
13925 |
0 |
0 |
srv_fill_mon_cache_memory |
55 |
55 |
0 |
0.00 |
2195 |
167856 |
44004 |
0 |
0 |
srv_find_qd_qs_mism |
887265 |
887265 |
0 |
0.00 |
0 |
13525 |
6 |
0 |
0 |
srv_make_invnt_saldo |
407 |
407 |
0 |
0.00 |
47 |
85453 |
3803 |
0 |
0 |
srv_make_money_saldo |
645 |
645 |
0 |
0.00 |
1 |
10286 |
621 |
0 |
0 |
srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
95023 |
323734 |
229571 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
102 |
102 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
6 |
6 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4491 |
4491 |
0 |
0.00 |
0 |
10209 |
174 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
352 |
352 |
0 |
0.00 |
0 |
2217 |
105 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1508 |
1508 |
0 |
0.00 |
0 |
3035 |
17 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
635 |
635 |
0 |
0.00 |
0 |
859 |
10 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
579 |
579 |
0 |
0.00 |
0 |
319 |
3 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
360 |
360 |
0 |
0.00 |
0 |
1387 |
11 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
363 |
363 |
0 |
0.00 |
0 |
1184 |
14 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
325 |
325 |
0 |
0.00 |
0 |
34737 |
1767 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
850 |
850 |
0 |
0.00 |
0 |
2723 |
10 |
0 |
0 |
t$perf-norm:sp_client_order |
18229 |
18229 |
0 |
0.00 |
0 |
10478 |
16 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
859 |
859 |
0 |
0.00 |
0 |
12568 |
20 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6232 |
6232 |
0 |
0.00 |
0 |
9482 |
10 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5140 |
5140 |
0 |
0.00 |
0 |
8361 |
11 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8866 |
8866 |
0 |
0.00 |
0 |
6471 |
11 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4920 |
4920 |
0 |
0.00 |
0 |
3626 |
15 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4860 |
4860 |
0 |
0.00 |
0 |
4707 |
15 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
103 |
103 |
0 |
0.00 |
0 |
1418 |
22 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
55 |
55 |
0 |
0.00 |
0 |
308 |
11 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
407 |
407 |
0 |
0.00 |
0 |
3201 |
15 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
645 |
645 |
0 |
0.00 |
0 |
1061 |
7 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
1 |
5 |
2 |
0 |
0 |
v_add_invoice_to_stock |
9164 |
8960 |
204 |
2.22 |
0 |
14104 |
20 |
0 |
204 |
v_all_customers |
33608 |
33608 |
0 |
0.00 |
0 |
17 |
1 |
0 |
0 |
v_all_suppliers |
27430 |
27430 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_wares |
36456 |
36456 |
0 |
0.00 |
0 |
26 |
1 |
0 |
0 |
v_cancel_adding_invoice |
704 |
704 |
0 |
0.00 |
0 |
510 |
7 |
0 |
0 |
v_cancel_client_order |
3016 |
3016 |
0 |
0.00 |
0 |
4509 |
10 |
0 |
0 |
v_cancel_customer_prepayment |
1158 |
1158 |
0 |
0.00 |
0 |
1510 |
6 |
0 |
0 |
v_cancel_customer_reserve |
1270 |
1270 |
0 |
0.00 |
0 |
1904 |
8 |
0 |
0 |
v_cancel_payment_to_supplier |
720 |
720 |
0 |
0.00 |
0 |
819 |
5 |
0 |
0 |
v_cancel_supplier_invoice |
738 |
726 |
12 |
1.62 |
0 |
610 |
14 |
0 |
12 |
v_cancel_supplier_order |
650 |
650 |
0 |
0.00 |
0 |
5971 |
13 |
0 |
0 |
v_cancel_write_off |
1700 |
1700 |
0 |
0.00 |
0 |
3218 |
16 |
0 |
0 |
v_max_id_clo_ord |
4860 |
4860 |
0 |
0.00 |
0 |
3196 |
2 |
0 |
0 |
v_max_id_clo_res |
859 |
859 |
0 |
0.00 |
0 |
5670 |
24 |
0 |
0 |
v_max_id_ord_sup |
4918 |
4918 |
0 |
0.00 |
0 |
7371 |
6 |
0 |
0 |
v_max_non_paid_invoice |
1202 |
1202 |
0 |
0.00 |
0 |
249 |
2 |
0 |
0 |
v_max_non_paid_realizn |
3099 |
3099 |
0 |
0.00 |
0 |
5751 |
5 |
0 |
0 |
v_min_id_clo_ord |
4860 |
4860 |
0 |
0.00 |
0 |
9219 |
23 |
0 |
0 |
v_min_id_clo_res |
859 |
859 |
0 |
0.00 |
0 |
12481 |
38 |
0 |
0 |
v_min_id_ord_sup |
4918 |
4918 |
0 |
0.00 |
0 |
11207 |
9 |
0 |
0 |
v_min_non_paid_invoice |
5140 |
5140 |
0 |
0.00 |
0 |
12582 |
33 |
0 |
0 |
v_min_non_paid_realizn |
6232 |
6232 |
0 |
0.00 |
0 |
10338 |
20 |
0 |
0 |
v_our_firm |
9114 |
9114 |
0 |
0.00 |
0 |
30 |
1 |
0 |
0 |
v_reserve_write_off |
17732 |
17732 |
0 |
0.00 |
0 |
18609 |
8 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9031 |
9031 |
0 |
0.00 |
0 |
24473 |
109 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
325 |
325 |
0 |
0.00 |
0 |
3387 |
289 |
0 |
0 |
x_make_qstorno_1000_1200 |
4860 |
4860 |
0 |
0.00 |
1 |
53407 |
1257 |
0 |
0 |
x_make_qstorno_1200_2000 |
4920 |
4920 |
0 |
0.00 |
3 |
106334 |
3409 |
0 |
0 |
x_make_qstorno_2100_3300 |
427742 |
427742 |
0 |
0.00 |
0 |
91437 |
180 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 25-02-2024 13:08:44 to 25-02-2024 13:08:48.
Fields:
page cache memo used = page cache total size, bytes:
memo used, total = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
memo allocated, total = the same of mon$memory_usage.mon$memory_allocated;
metadata cache memo used = metadata cache, bytes;
metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
total attachments cnt = total number of attachments, regardless of state;
active attachments cnt = number of attachments with mon$state = 1;
running statements cnt = number of statements that are operating with data from page cache (mon$state = 1);
stalled statements cnt = number of statements that are waiting for client request for fetching ( mon$state = 2);
memo used by attachments = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
memo used by transactions = the same of transaction level (mon$stat_group = 2);
memo used by statements = the same of statement level (mon$stat_group = 3);
Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts |
measurement duration ms |
page cache memo used |
memo used, total |
memo allocated, total |
metadata cache |
metadata cache percent of total |
total attachments cnt |
active attachments cnt |
running statements cnt |
stalled statements cnt |
memo used by attachments |
memo used by transactions |
memo used by statements |
11:07:53 |
2 |
8192000000 |
8796669328 |
8807108608 |
3187328 |
0.038 |
1 |
1 |
2 |
0 |
3284944 |
61840 |
35776 |
11:08:54 |
25617 |
8192000000 |
9714183568 |
10007543808 |
788164848 |
8.776 |
100 |
92 |
182 |
1 |
818406288 |
7955552 |
22285888 |
11:10:27 |
24687 |
8192000000 |
9746315056 |
10051280896 |
817237600 |
9.071 |
100 |
81 |
162 |
0 |
848494096 |
11594080 |
19662416 |
11:12:06 |
15137 |
8192000000 |
9786835600 |
10103443456 |
858486368 |
9.485 |
100 |
80 |
160 |
0 |
896498544 |
19679328 |
18332848 |
11:13:26 |
13906 |
8192000000 |
9853525168 |
10183921664 |
907466208 |
9.972 |
100 |
79 |
158 |
0 |
959701472 |
34996448 |
17238816 |
11:14:41 |
5990 |
8192000000 |
9895323632 |
10236583936 |
935110416 |
10.245 |
100 |
77 |
154 |
0 |
1006542672 |
55077136 |
16355120 |
11:15:52 |
4489 |
8192000000 |
9928656448 |
10278350848 |
974368400 |
10.629 |
100 |
82 |
164 |
0 |
1050292416 |
59020192 |
16903824 |
11:17:05 |
2749 |
8192000000 |
9991968480 |
10350440448 |
1008631024 |
10.962 |
100 |
85 |
167 |
0 |
1108394656 |
83088800 |
16674832 |
11:18:09 |
1698 |
8192000000 |
9991185696 |
10356113408 |
1033010496 |
11.197 |
100 |
90 |
176 |
1 |
1106327936 |
56354816 |
16962624 |
11:19:12 |
1333 |
8192000000 |
10026863008 |
10402701312 |
1059733600 |
11.454 |
100 |
83 |
167 |
0 |
1147824720 |
71203632 |
16887488 |
11:20:14 |
20581 |
8192000000 |
10011634464 |
10389749760 |
1067252896 |
11.526 |
100 |
64 |
123 |
1 |
1135722528 |
55460512 |
13009120 |
11:21:36 |
6871 |
8192000000 |
10001605776 |
10392776704 |
1076604544 |
11.615 |
100 |
42 |
81 |
0 |
1120218512 |
34675552 |
8938416 |
11:22:44 |
4941 |
8192000000 |
9997177824 |
10398982144 |
1085634736 |
11.701 |
100 |
39 |
76 |
0 |
1116979648 |
23447776 |
7897136 |
11:23:53 |
5191 |
8192000000 |
10003820464 |
10402099200 |
1092116624 |
11.763 |
100 |
37 |
73 |
1 |
1125044864 |
24525120 |
8403120 |
11:25:00 |
41788 |
8192000000 |
10010981728 |
10410409984 |
1098389856 |
11.822 |
100 |
53 |
102 |
0 |
1121833968 |
13253264 |
10190848 |
11:26:43 |
3350 |
8192000000 |
10029480688 |
10431709184 |
1102461408 |
11.861 |
100 |
51 |
101 |
0 |
1142290400 |
28984688 |
10844304 |
11:27:47 |
8082 |
8192000000 |
10026007728 |
10423472128 |
1092762416 |
11.769 |
99 |
39 |
78 |
1 |
1125209920 |
23939440 |
8508064 |
11:29:08 |
11301 |
8192000000 |
10061712880 |
10465529856 |
1113930336 |
11.970 |
100 |
51 |
102 |
1 |
1165096032 |
40331616 |
10834080 |
11:30:22 |
78435 |
8192000000 |
10085633152 |
10496598016 |
1097000720 |
11.809 |
98 |
51 |
99 |
1 |
1200841312 |
93963840 |
9876752 |
11:32:43 |
16178 |
8192000000 |
10137372480 |
10536976384 |
1115844560 |
11.988 |
99 |
59 |
114 |
0 |
1228090160 |
100530928 |
11714672 |
11:34:05 |
14837 |
8192000000 |
10141106480 |
10551189504 |
1101935152 |
11.856 |
98 |
43 |
84 |
0 |
1229856912 |
118615488 |
9306272 |
11:35:24 |
13559 |
8192000000 |
10129233856 |
10530598912 |
1088538176 |
11.729 |
97 |
54 |
107 |
0 |
1216865936 |
116577232 |
11750528 |
11:37:00 |
7801 |
8192000000 |
10148583840 |
10555117568 |
1095249776 |
11.793 |
98 |
69 |
138 |
0 |
1257988896 |
147705488 |
15033632 |
11:38:16 |
2194 |
8192000000 |
10172918880 |
10563805184 |
1093454048 |
11.775 |
100 |
65 |
126 |
1 |
1284520192 |
177772224 |
13293920 |
11:39:22 |
3066 |
8192000000 |
10212956464 |
10606489600 |
1106183952 |
11.896 |
100 |
68 |
135 |
0 |
1323477664 |
203079488 |
14214224 |
11:40:29 |
4559 |
8192000000 |
10221151216 |
10607849472 |
1092894512 |
11.770 |
99 |
67 |
131 |
2 |
1314232928 |
206838176 |
14500240 |
11:41:39 |
6001 |
8192000000 |
10230770912 |
10616836096 |
1074820144 |
11.598 |
100 |
64 |
125 |
0 |
1333894640 |
245401456 |
13673040 |
11:42:50 |
2718 |
8192000000 |
10291584656 |
10680176640 |
1096493056 |
11.804 |
100 |
77 |
151 |
1 |
1389611744 |
276158064 |
16960624 |
11:43:57 |
3448 |
8192000000 |
10356460176 |
10749399040 |
1117856784 |
12.007 |
100 |
70 |
139 |
0 |
1454719120 |
321492368 |
15369968 |
11:45:04 |
2737 |
8192000000 |
10394676848 |
10797953024 |
1126860368 |
12.092 |
100 |
76 |
152 |
1 |
1505041408 |
360458752 |
17722288 |
11:46:11 |
5274 |
8192000000 |
10401978816 |
10802814976 |
1126707600 |
12.090 |
100 |
70 |
136 |
1 |
1502217264 |
359875392 |
15634272 |
11:47:20 |
2365 |
8192000000 |
10313306528 |
10737324032 |
1138539936 |
12.202 |
100 |
75 |
146 |
1 |
1417170992 |
262198208 |
16432848 |
11:48:27 |
3674 |
8192000000 |
10257524240 |
10673045504 |
1147609344 |
12.287 |
100 |
43 |
85 |
0 |
1361679184 |
204412080 |
9657760 |
11:49:32 |
9165 |
8192000000 |
10204260800 |
10656927744 |
1148374128 |
12.294 |
100 |
27 |
54 |
0 |
1321339968 |
166912576 |
6053264 |
11:50:44 |
25553 |
8192000000 |
10121580240 |
10605617152 |
1132217760 |
12.142 |
100 |
13 |
25 |
1 |
1236355344 |
101211408 |
2926176 |
11:52:12 |
67452 |
8192000000 |
10069364416 |
10492702720 |
1133285312 |
12.152 |
100 |
47 |
93 |
1 |
1168957920 |
24905200 |
10767408 |
11:54:43 |
36081 |
8192000000 |
10129540064 |
10567897088 |
1143442560 |
12.248 |
100 |
46 |
93 |
0 |
1238462608 |
85726976 |
9293072 |
11:56:20 |
9630 |
8192000000 |
10084613264 |
10528198656 |
1143984768 |
12.253 |
100 |
10 |
20 |
0 |
1192041072 |
45992768 |
2063536 |
11:57:34 |
92038 |
8192000000 |
10159315312 |
10615521280 |
1142098176 |
12.235 |
99 |
17 |
34 |
1 |
1235513008 |
90017360 |
3397472 |
12:00:20 |
103750 |
8192000000 |
10114623760 |
10587209728 |
1124889184 |
12.073 |
98 |
23 |
46 |
0 |
1196027168 |
66308208 |
4829776 |
12:03:18 |
43064 |
8192000000 |
10072635024 |
10540318720 |
1148077856 |
12.291 |
100 |
7 |
13 |
1 |
1188056160 |
38891632 |
1086672 |
12:05:03 |
79258 |
8192000000 |
10120031312 |
10631946240 |
1133015696 |
12.150 |
98 |
11 |
22 |
0 |
1194935024 |
59655504 |
2263824 |
12:07:38 |
19123 |
8192000000 |
10067872240 |
10515365888 |
1119600848 |
12.023 |
97 |
21 |
42 |
0 |
1158390816 |
34606352 |
4183616 |
12:09:17 |
46364 |
8192000000 |
10135781120 |
10662608896 |
1144278528 |
12.256 |
99 |
10 |
20 |
0 |
1223828480 |
77720144 |
1829808 |
12:11:09 |
110420 |
8192000000 |
10096892096 |
10531491840 |
1068051552 |
11.533 |
92 |
12 |
24 |
0 |
1098511856 |
28080064 |
2380240 |
12:14:06 |
35280 |
8192000000 |
10091676832 |
10569330688 |
1119385072 |
12.021 |
97 |
19 |
39 |
0 |
1218231216 |
95195568 |
3650576 |
12:15:44 |
55398 |
8192000000 |
10081662496 |
10532679680 |
1113939808 |
11.970 |
97 |
10 |
19 |
0 |
1168061792 |
52372048 |
1749936 |
12:17:39 |
167856 |
8192000000 |
10062226784 |
10550538240 |
1110222320 |
11.935 |
97 |
26 |
52 |
0 |
1212169024 |
96031328 |
5915376 |
12:21:31 |
58364 |
8192000000 |
10045938720 |
10511380480 |
1110296768 |
11.935 |
99 |
13 |
27 |
0 |
1149175376 |
36327136 |
2551472 |
12:23:32 |
47365 |
8192000000 |
10054006816 |
10515795968 |
1111387584 |
11.946 |
98 |
24 |
48 |
1 |
1178263088 |
61594016 |
5281488 |
12:25:26 |
46649 |
8192000000 |
10031511824 |
10504773632 |
1094264288 |
11.783 |
98 |
13 |
25 |
1 |
1135136448 |
37932416 |
2939744 |
12:27:13 |
30288 |
8192000000 |
10032143424 |
10465587200 |
1083588128 |
11.682 |
98 |
25 |
50 |
1 |
1132182320 |
43674800 |
4919392 |
12:28:43 |
109257 |
8192000000 |
10053320080 |
10527399936 |
1064782544 |
11.502 |
95 |
15 |
30 |
0 |
1138992944 |
70787056 |
3423344 |
12:31:33 |
45317 |
8192000000 |
10072065328 |
10519498752 |
1100931152 |
11.846 |
99 |
42 |
83 |
0 |
1173578240 |
64478256 |
8168832 |
12:33:19 |
24982 |
8192000000 |
10089578400 |
10545086464 |
1090526304 |
11.748 |
98 |
39 |
78 |
0 |
1182900464 |
84764528 |
7609632 |
12:34:44 |
34133 |
8192000000 |
10090543312 |
10531405824 |
1105534128 |
11.890 |
99 |
32 |
64 |
0 |
1167959104 |
55622672 |
6802304 |
12:36:53 |
39590 |
8192000000 |
10108098592 |
10535993344 |
1127308672 |
12.096 |
100 |
42 |
84 |
0 |
1195322688 |
60016672 |
7997344 |
12:38:33 |
82229 |
8192000000 |
10079682144 |
10510950400 |
1126299264 |
12.086 |
99 |
45 |
89 |
0 |
1174738656 |
39122528 |
9316864 |
12:40:55 |
43864 |
8192000000 |
10056866528 |
10495086592 |
1101360928 |
11.851 |
98 |
12 |
24 |
0 |
1153250096 |
49242704 |
2646464 |
12:42:58 |
65514 |
8192000000 |
10143387760 |
10608672768 |
1139214176 |
12.208 |
100 |
17 |
34 |
0 |
1250924144 |
107366896 |
4343072 |
12:45:05 |
53350 |
8192000000 |
10096659824 |
10529398784 |
1134395504 |
12.163 |
99 |
21 |
42 |
0 |
1174864080 |
36060688 |
4407888 |
12:47:04 |
68474 |
8192000000 |
10085335904 |
10548625408 |
1122705712 |
12.053 |
98 |
16 |
32 |
0 |
1170002144 |
44135440 |
3160992 |
12:49:14 |
78328 |
8192000000 |
10094326448 |
10591199232 |
1116863952 |
11.997 |
97 |
12 |
24 |
0 |
1197770880 |
78387648 |
2519280 |
12:51:40 |
76933 |
8192000000 |
10076647120 |
10500321280 |
1116421136 |
11.993 |
97 |
30 |
60 |
0 |
1143700528 |
21173152 |
6106240 |
12:54:04 |
130544 |
8192000000 |
10065802736 |
10534879232 |
1102998608 |
11.866 |
97 |
27 |
54 |
0 |
1167985440 |
59294816 |
5692016 |
12:57:22 |
7679 |
8192000000 |
10099144016 |
10528026624 |
1129787248 |
12.119 |
100 |
44 |
86 |
2 |
1193087136 |
54011008 |
9288880 |
12:58:31 |
88319 |
8192000000 |
10095731056 |
10564800512 |
1106668336 |
11.901 |
97 |
17 |
32 |
0 |
1173717872 |
63563088 |
3486448 |
13:01:00 |
50526 |
8192000000 |
10097577008 |
10562568192 |
1112897440 |
11.960 |
98 |
25 |
50 |
0 |
1199925936 |
81305552 |
5722944 |
13:02:50 |
53398 |
8192000000 |
10137657968 |
10611478528 |
1132086752 |
12.141 |
99 |
23 |
46 |
0 |
1214800640 |
77318784 |
5395104 |
13:05:04 |
76942 |
8192000000 |
10075391488 |
10603470848 |
1067361024 |
11.527 |
94 |
22 |
42 |
0 |
1189819488 |
117590352 |
4868112 |
13:07:33 |
21481 |
8192000000 |
8877744688 |
9165369344 |
15718272 |
0.191 |
2 |
1 |
2 |
0 |
15821792 |
68112 |
35408 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 25-02-2024 13:08:50 to 25-02-2024 13:09:03.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
102 |
v_add_invoice_to_stock |
335544517 |
except |
6 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-02-2024 13:09:04 to 25-02-2024 13:09:06.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 177047
MON$OLDEST_ACTIVE 177048
MON$OLDEST_SNAPSHOT 177048
MON$NEXT_TRANSACTION 177048
MON$PAGE_BUFFERS 1000000
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2020-04-30 07:30:08.6030 GMT
MON$PAGES 1920928
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
MON$CRYPT_STATE 0
MON$GUID {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID 02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT 703
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0
Database "/home/bases/oltp40-etalone.fdb"
Gstat execution time Sun Feb 25 13:09:07 2024
Database header page information:
Flags 0
Generation 92476
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 177047
Oldest active 177048
Oldest snapshot 177048
Next transaction 177049
Sequence number 0
Next attachment ID 703
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 30, 2020 7:30:08
Attributes force write
Variable header data:
Database GUID: {58978C10-B735-40F5-8B7D-F7A1956E782B}
Sweep interval: 0
*END*
Database file sequence:
File /home/bases/oltp40-etalone.fdb is the only file
Analyzing database pages ...
AGENTS (150)
Primary pointer page: 524, Index root page: 525
Total formats: 1, used formats: 1
Average record length: 33.60, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.20, total dup: 0, max dup: 0
Average key length: 15.88, compression ratio: 0.92
Average prefix length: 1.42, average data length: 13.20
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (154)
Primary pointer page: 532, Index root page: 533
Total formats: 1, used formats: 1
Average record length: 108.20, total records: 20
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1235.00, compression ratio: 11.41
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 18.25, total dup: 0, max dup: 0
Average key length: 17.20, compression ratio: 1.24
Average prefix length: 7.05, average data length: 14.25
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_PREDICT_PRIOR (3)
Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.40, total dup: 0, max dup: 0
Average key length: 4.35, compression ratio: 0.67
Average prefix length: 1.20, average data length: 1.70
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 4.30, total dup: 6, max dup: 3
Average key length: 3.25, compression ratio: 0.72
Average prefix length: 1.35, average data length: 1.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.20, total dup: 0, max dup: 0
Average key length: 4.15, compression ratio: 0.65
Average prefix length: 1.10, average data length: 1.60
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (139)
Primary pointer page: 502, Index root page: 503
Total formats: 1, used formats: 1
Average record length: 47.27, total records: 7822251
Average version length: 48.16, total versions: 124832, 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: 55, data page slots: 89632
Data pages: 89632, average fill: 70%
Primary pages: 89631, secondary pages: 1, swept pages: 31862
Empty pages: 4, full pages: 74308
Fill distribution:
0 - 19% = 9
20 - 39% = 43
40 - 59% = 1575
60 - 79% = 87890
80 - 99% = 115
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510636, depth: 3, leaf buckets: 23287, nodes: 7822251
Average node length: 18.92, total dup: 0, max dup: 0
Average key length: 15.93, compression ratio: 1.69
Average prefix length: 14.06, average data length: 12.94
Clustering factor: 1691186, ratio: 0.22
Fill distribution:
0 - 19% = 339
20 - 39% = 1518
40 - 59% = 4204
60 - 79% = 2206
80 - 99% = 15020
Index DOC_DATA_ID_DESC (1)
Root page: 1528140, depth: 3, leaf buckets: 13509, nodes: 7822251
Average node length: 11.20, total dup: 0, max dup: 0
Average key length: 8.21, compression ratio: 1.10
Average prefix length: 3.79, average data length: 5.21
Clustering factor: 1516023, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 1377
40 - 59% = 2145
60 - 79% = 1010
80 - 99% = 8977
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546735, depth: 3, leaf buckets: 8347, nodes: 7822251
Average node length: 6.63, total dup: 5825213, max dup: 49
Average key length: 3.65, compression ratio: 2.47
Average prefix length: 7.61, average data length: 1.39
Clustering factor: 1509047, ratio: 0.19
Fill distribution:
0 - 19% = 141
20 - 39% = 814
40 - 59% = 1445
60 - 79% = 858
80 - 99% = 5089
DOC_LIST (138)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 56.03, total records: 2288381
Average version length: 58.91, total versions: 67773, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 84.00, compression ratio: 1.50
Pointer pages: 18, data page slots: 29008
Data pages: 29008, average fill: 73%
Primary pages: 29006, secondary pages: 2, swept pages: 7831
Empty pages: 22, full pages: 23376
Fill distribution:
0 - 19% = 31
20 - 39% = 15
40 - 59% = 306
60 - 79% = 28503
80 - 99% = 153
Index DOC_LIST_ID_DESC (1)
Root page: 1541152, depth: 3, leaf buckets: 4589, nodes: 2288381
Average node length: 11.40, total dup: 0, max dup: 0
Average key length: 8.44, compression ratio: 1.07
Average prefix length: 3.56, average data length: 5.44
Clustering factor: 691187, ratio: 0.30
Fill distribution:
0 - 19% = 0
20 - 39% = 885
40 - 59% = 859
60 - 79% = 694
80 - 99% = 2151
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544398, depth: 3, leaf buckets: 2457, nodes: 2290070
Average node length: 4.97, total dup: 2289172, max dup: 19394
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1275880, ratio: 0.56
Fill distribution:
0 - 19% = 1
20 - 39% = 188
40 - 59% = 1427
60 - 79% = 591
80 - 99% = 250
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545933, depth: 3, leaf buckets: 1812, nodes: 2288381
Average node length: 4.97, total dup: 2288331, max dup: 130382
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1081940, ratio: 0.47
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 665
60 - 79% = 53
80 - 99% = 1092
Index PK_DOC_LIST (0)
Root page: 1538209, depth: 3, leaf buckets: 4371, nodes: 2288381
Average node length: 11.40, total dup: 0, max dup: 0
Average key length: 8.43, compression ratio: 1.07
Average prefix length: 3.56, average data length: 5.44
Clustering factor: 691187, ratio: 0.30
Fill distribution:
0 - 19% = 100
20 - 39% = 552
40 - 59% = 626
60 - 79% = 752
80 - 99% = 2341
DOC_STATES (149)
Primary pointer page: 522, Index root page: 523
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (155)
Primary pointer page: 534, Index root page: 535
Total formats: 2, used formats: 2
Average record length: 57.88, total records: 2182
Average version length: 79.61, total versions: 757, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 270.43, compression ratio: 4.67
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 72%
Primary pages: 39, secondary pages: 1, swept pages: 0
Empty pages: 4, full pages: 34
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 22
80 - 99% = 12
Index FB_ERRORS_GDS_CODE (0)
Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182
Average node length: 4.40, total dup: 756, max dup: 1
Average key length: 2.67, compression ratio: 1.87
Average prefix length: 4.33, average data length: 0.67
Clustering factor: 1518, ratio: 0.70
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
INVNT_SALDO (145)
Primary pointer page: 514, Index root page: 515
Total formats: 2, used formats: 1
Average record length: 83.34, total records: 400
Average version length: 23.84, total versions: 1553, max versions: 6
Average fragment length: 2.00, total fragments: 2, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.25
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 54%
Primary pages: 7, secondary pages: 17, swept pages: 0
Empty pages: 3, full pages: 10
Fill distribution:
0 - 19% = 8
20 - 39% = 2
40 - 59% = 1
60 - 79% = 4
80 - 99% = 9
Index PK_INVNT_SALDO (0)
Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 326, ratio: 0.81
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (153)
Primary pointer page: 530, Index root page: 531
Total formats: 1, used formats: 1
Average record length: 16.79, total records: 169386
Average version length: 68.29, total versions: 147133, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 5.24
Pointer pages: 6, data page slots: 3296
Data pages: 2976, average fill: 76%
Primary pages: 2975, secondary pages: 1, swept pages: 0
Empty pages: 221, full pages: 2281
Fill distribution:
0 - 19% = 303
20 - 39% = 138
40 - 59% = 150
60 - 79% = 378
80 - 99% = 2007
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1704611, depth: 3, leaf buckets: 431, nodes: 169386
Average node length: 13.03, total dup: 15371, max dup: 2
Average key length: 10.41, compression ratio: 2.59
Average prefix length: 19.49, average data length: 7.51
Clustering factor: 120816, ratio: 0.71
Fill distribution:
0 - 19% = 2
20 - 39% = 18
40 - 59% = 114
60 - 79% = 267
80 - 99% = 30
MONEY_SALDO (141)
Primary pointer page: 506, Index root page: 507
Total formats: 1, used formats: 1
Average record length: 15.27, total records: 49
Average version length: 9.00, total versions: 125, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 63%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (140)
Primary pointer page: 504, Index root page: 505
Total formats: 1, used formats: 1
Average record length: 12.18, total records: 2803
Average version length: 43.81, total versions: 2556, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 4.76
Pointer pages: 1, data page slots: 64
Data pages: 48, average fill: 62%
Primary pages: 47, secondary pages: 1, swept pages: 0
Empty pages: 7, full pages: 27
Fill distribution:
0 - 19% = 12
20 - 39% = 4
40 - 59% = 4
60 - 79% = 0
80 - 99% = 28
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 92813, depth: 2, leaf buckets: 4, nodes: 2803
Average node length: 4.15, total dup: 2705, max dup: 356
Average key length: 2.38, compression ratio: 7.99
Average prefix length: 18.66, average data length: 0.34
Clustering factor: 1413, ratio: 0.50
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
MON_CACHE_MEMORY (165)
Primary pointer page: 555, Index root page: 556
Total formats: 2, used formats: 1
Average record length: 97.65, total records: 71
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 112.00, compression ratio: 1.15
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 50%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index PK_MON_CACHE_MEMORY (0)
Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 10.69, compression ratio: 0.84
Average prefix length: 1.30, average data length: 7.70
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 548, Index root page: 549
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (163)
Primary pointer page: 550, Index root page: 551
Total formats: 2, used formats: 1
Average record length: 67.13, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 611.00, compression ratio: 9.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.50, total dup: 23, max dup: 4
Average key length: 2.47, compression ratio: 3.24
Average prefix length: 7.53, average data length: 0.47
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 2.00, total dup: 29, max dup: 29
Average key length: 1.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.33, total dup: 29, max dup: 29
Average key length: 2.30, compression ratio: 3.91
Average prefix length: 8.70, average data length: 0.30
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 12.90, total dup: 0, max dup: 0
Average key length: 11.87, compression ratio: 1.42
Average prefix length: 7.63, average data length: 9.20
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 8.37, total dup: 0, max dup: 0
Average key length: 7.33, compression ratio: 1.23
Average prefix length: 4.63, average data length: 4.37
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (136)
Primary pointer page: 496, Index root page: 497
Total formats: 2, used formats: 1
Average record length: 67.56, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 386.00, compression ratio: 5.71
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (146)
Primary pointer page: 516, Index root page: 517
Total formats: 1, used formats: 1
Average record length: 35.69, total records: 823390
Average version length: 37.92, total versions: 42618, max versions: 3
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.51
Pointer pages: 6, data page slots: 8424
Data pages: 8424, average fill: 67%
Primary pages: 8423, secondary pages: 1, swept pages: 988
Empty pages: 6, full pages: 7782
Fill distribution:
0 - 19% = 10
20 - 39% = 17
40 - 59% = 81
60 - 79% = 8228
80 - 99% = 88
Index PDISTR_AGENT_ID (2)
Root page: 1509330, depth: 2, leaf buckets: 850, nodes: 803042
Average node length: 4.88, total dup: 802993, max dup: 144551
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 91120, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 100
40 - 59% = 463
60 - 79% = 197
80 - 99% = 90
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508635, depth: 3, leaf buckets: 889, nodes: 803042
Average node length: 5.89, total dup: 714823, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 160785, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 37
40 - 59% = 412
60 - 79% = 107
80 - 99% = 333
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509209, depth: 3, leaf buckets: 918, nodes: 803042
Average node length: 5.89, total dup: 714823, max dup: 42
Average key length: 3.02, compression ratio: 7.28
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 162706, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 81
40 - 59% = 408
60 - 79% = 104
80 - 99% = 325
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510200, depth: 3, leaf buckets: 1137, nodes: 803042
Average node length: 5.97, total dup: 714823, max dup: 42
Average key length: 3.10, compression ratio: 5.48
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 155161, ratio: 0.19
Fill distribution:
0 - 19% = 4
20 - 39% = 272
40 - 59% = 558
60 - 79% = 207
80 - 99% = 96
PERF_AGG (158)
Primary pointer page: 540, Index root page: 541
Total formats: 1, used formats: 1
Average record length: 62.79, total records: 5456
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 4.31, total fragments: 13, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.04
Pointer pages: 1, data page slots: 88
Data pages: 85, average fill: 63%
Primary pages: 74, secondary pages: 11, swept pages: 53
Empty pages: 5, full pages: 57
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 1
60 - 79% = 73
80 - 99% = 0
Index PERF_AGG_UNQ (1)
Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5456
Average node length: 5.53, total dup: 0, max dup: 0
Average key length: 3.58, compression ratio: 10.03
Average prefix length: 34.40, average data length: 1.55
Clustering factor: 5198, ratio: 0.95
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 4
60 - 79% = 1
80 - 99% = 1
Index PK_PERF_AGG (0)
Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5456
Average node length: 11.16, 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: 164, ratio: 0.03
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
PERF_ESTIMATED (280)
Primary pointer page: 399, Index root page: 434
Total formats: 1, used formats: 1
Average record length: 39.04, total records: 80694
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: 840
Data pages: 840, average fill: 66%
Primary pages: 840, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 837
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1
60 - 79% = 837
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 35562, depth: 2, leaf buckets: 104, nodes: 80694
Average node length: 10.16, total dup: 0, max dup: 0
Average key length: 8.17, compression ratio: 1.10
Average prefix length: 3.82, average data length: 5.18
Clustering factor: 3185, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 100
PERF_ISQL_STAT (156)
Primary pointer page: 536, Index root page: 537
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (159)
Primary pointer page: 542, Index root page: 543
Total formats: 1, used formats: 1
Average record length: 111.08, total records: 71
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1691.00, compression ratio: 15.22
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 56%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
PERF_SPLIT_0 (281)
Primary pointer page: 601, Index root page: 602
Total formats: 1, used formats: 1
Average record length: 127.29, total records: 195523
Average version length: 154.88, total versions: 32874, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.32
Pointer pages: 6, data page slots: 6056
Data pages: 4936, average fill: 84%
Primary pages: 4934, secondary pages: 2, swept pages: 4
Empty pages: 97, full pages: 4800
Fill distribution:
0 - 19% = 103
20 - 39% = 11
40 - 59% = 10
60 - 79% = 13
80 - 99% = 4799
PERF_SPLIT_1 (282)
Primary pointer page: 603, Index root page: 604
Total formats: 1, used formats: 1
Average record length: 147.48, total records: 139143
Average version length: 151.23, total versions: 3315, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.50
Pointer pages: 6, data page slots: 5296
Data pages: 3488, average fill: 82%
Primary pages: 3485, secondary pages: 3, swept pages: 1
Empty pages: 64, full pages: 3398
Fill distribution:
0 - 19% = 69
20 - 39% = 10
40 - 59% = 2
60 - 79% = 9
80 - 99% = 3398
PERF_SPLIT_2 (283)
Primary pointer page: 605, Index root page: 606
Total formats: 1, used formats: 1
Average record length: 127.79, total records: 187332
Average version length: 154.40, total versions: 30686, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.27
Pointer pages: 7, data page slots: 6104
Data pages: 4728, average fill: 84%
Primary pages: 4725, secondary pages: 3, swept pages: 3
Empty pages: 96, full pages: 4594
Fill distribution:
0 - 19% = 100
20 - 39% = 15
40 - 59% = 9
60 - 79% = 9
80 - 99% = 4595
PERF_SPLIT_3 (284)
Primary pointer page: 607, Index root page: 608
Total formats: 1, used formats: 1
Average record length: 148.55, total records: 156487
Average version length: 151.95, total versions: 2697, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.42
Pointer pages: 7, data page slots: 5056
Data pages: 3888, average fill: 83%
Primary pages: 3885, secondary pages: 3, swept pages: 1
Empty pages: 41, full pages: 3834
Fill distribution:
0 - 19% = 42
20 - 39% = 5
40 - 59% = 3
60 - 79% = 4
80 - 99% = 3834
PERF_SPLIT_4 (285)
Primary pointer page: 609, Index root page: 610
Total formats: 1, used formats: 1
Average record length: 136.46, total records: 189535
Average version length: 154.85, total versions: 19690, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.43
Pointer pages: 6, data page slots: 7288
Data pages: 4784, average fill: 83%
Primary pages: 4782, secondary pages: 2, swept pages: 4
Empty pages: 99, full pages: 4650
Fill distribution:
0 - 19% = 102
20 - 39% = 13
40 - 59% = 15
60 - 79% = 4
80 - 99% = 4650
PERF_SPLIT_5 (286)
Primary pointer page: 611, Index root page: 612
Total formats: 1, used formats: 1
Average record length: 148.49, total records: 151192
Average version length: 151.76, total versions: 2581, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.42
Pointer pages: 7, data page slots: 4328
Data pages: 3768, average fill: 83%
Primary pages: 3765, secondary pages: 3, swept pages: 1
Empty pages: 45, full pages: 3700
Fill distribution:
0 - 19% = 49
20 - 39% = 7
40 - 59% = 8
60 - 79% = 4
80 - 99% = 3700
PERF_SPLIT_6 (287)
Primary pointer page: 613, Index root page: 614
Total formats: 1, used formats: 1
Average record length: 145.11, total records: 159505
Average version length: 152.62, total versions: 6722, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.69
Pointer pages: 5, data page slots: 6944
Data pages: 4024, average fill: 82%
Primary pages: 4022, secondary pages: 2, swept pages: 2
Empty pages: 92, full pages: 3900
Fill distribution:
0 - 19% = 93
20 - 39% = 9
40 - 59% = 13
60 - 79% = 8
80 - 99% = 3901
PERF_SPLIT_7 (288)
Primary pointer page: 615, Index root page: 616
Total formats: 1, used formats: 1
Average record length: 144.67, total records: 172204
Average version length: 152.66, total versions: 7938, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.72
Pointer pages: 7, data page slots: 6096
Data pages: 4352, average fill: 82%
Primary pages: 4350, secondary pages: 2, swept pages: 1
Empty pages: 103, full pages: 4217
Fill distribution:
0 - 19% = 105
20 - 39% = 10
40 - 59% = 9
60 - 79% = 13
80 - 99% = 4215
PERF_SPLIT_8 (289)
Primary pointer page: 617, Index root page: 618
Total formats: 1, used formats: 1
Average record length: 142.61, total records: 148227
Average version length: 153.10, total versions: 8487, 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: 5632
Data pages: 3728, average fill: 82%
Primary pages: 3726, secondary pages: 2, swept pages: 7
Empty pages: 81, full pages: 3620
Fill distribution:
0 - 19% = 87
20 - 39% = 3
40 - 59% = 5
60 - 79% = 13
80 - 99% = 3620
PERF_SPLIT_9 (290)
Primary pointer page: 619, Index root page: 620
Total formats: 1, used formats: 1
Average record length: 148.09, total records: 152656
Average version length: 152.07, total versions: 2886, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.45
Pointer pages: 7, data page slots: 4896
Data pages: 3808, average fill: 83%
Primary pages: 3803, secondary pages: 5, swept pages: 3
Empty pages: 55, full pages: 3729
Fill distribution:
0 - 19% = 58
20 - 39% = 7
40 - 59% = 3
60 - 79% = 10
80 - 99% = 3730
PHRASES (143)
Primary pointer page: 510, Index root page: 511
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (147)
Primary pointer page: 518, Index root page: 519
Total formats: 1, used formats: 1
Average record length: 51.43, total records: 2136568
Average version length: 52.91, total versions: 64461, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 70.00, compression ratio: 1.36
Pointer pages: 16, data page slots: 25832
Data pages: 25832, average fill: 72%
Primary pages: 25819, secondary pages: 13, swept pages: 9213
Empty pages: 75, full pages: 23779
Fill distribution:
0 - 19% = 151
20 - 39% = 166
40 - 59% = 477
60 - 79% = 24350
80 - 99% = 688
Index PSTORNED_RCV_ID (1)
Root page: 1506208, depth: 3, leaf buckets: 2612, nodes: 2136568
Average node length: 5.44, total dup: 1994634, max dup: 1416
Average key length: 2.48, compression ratio: 3.62
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 184654, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 269
40 - 59% = 1737
60 - 79% = 308
80 - 99% = 293
Index PSTORNED_SND_ID (0)
Root page: 1504841, depth: 3, leaf buckets: 2763, nodes: 2136568
Average node length: 5.69, total dup: 1918425, max dup: 64
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 381587, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 2338
60 - 79% = 386
80 - 99% = 32
Index PSTORNED_WORKER_ID (2)
Root page: 1508018, depth: 3, leaf buckets: 2130, nodes: 2136568
Average node length: 4.96, total dup: 2136468, max dup: 28859
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 182226, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 171
40 - 59% = 1071
60 - 79% = 439
80 - 99% = 448
RULES_FOR_PDISTR (148)
Primary pointer page: 520, Index root page: 521
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 494, Index root page: 495
Total formats: 1, used formats: 1
Average record length: 97.62, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index SETTINGS_MCODE_WM_UNQ (1)
Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 482, Index root page: 483
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 488, Index root page: 489
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 490, Index root page: 491
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 546, Index root page: 547
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 544, Index root page: 545
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 486, Index root page: 487
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 484, Index root page: 485
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 538, Index root page: 539
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 508, Index root page: 509
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 526, Index root page: 527
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 577, Index root page: 578
Total formats: 1, used formats: 1
Average record length: 39.37, total records: 163331
Average version length: 69.19, total versions: 80949, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.20
Pointer pages: 3, data page slots: 4472
Data pages: 3392, average fill: 59%
Primary pages: 3392, secondary pages: 0, swept pages: 496
Empty pages: 686, full pages: 2156
Fill distribution:
0 - 19% = 875
20 - 39% = 68
40 - 59% = 82
60 - 79% = 983
80 - 99% = 1384
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 1555463, depth: 3, leaf buckets: 239, nodes: 163331
Average node length: 6.49, total dup: 142182, max dup: 14
Average key length: 3.93, compression ratio: 10.69
Average prefix length: 40.20, average data length: 1.80
Clustering factor: 27824, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 31
40 - 59% = 112
60 - 79% = 67
80 - 99% = 25
XQD_1000_3300 (178)
Primary pointer page: 581, Index root page: 582
Total formats: 1, used formats: 1
Average record length: 64.64, total records: 7109291
Average version length: 68.79, total versions: 511760, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.95
Pointer pages: 63, data page slots: 102656
Data pages: 102656, average fill: 75%
Primary pages: 102655, secondary pages: 1, swept pages: 8923
Empty pages: 2, full pages: 97121
Fill distribution:
0 - 19% = 31
20 - 39% = 231
40 - 59% = 1404
60 - 79% = 98196
80 - 99% = 2794
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480476, depth: 3, leaf buckets: 10622, nodes: 7109291
Average node length: 6.51, total dup: 6152640, max dup: 29
Average key length: 3.51, compression ratio: 11.95
Average prefix length: 40.62, average data length: 1.38
Clustering factor: 1700105, ratio: 0.24
Fill distribution:
0 - 19% = 13
20 - 39% = 1518
40 - 59% = 5789
60 - 79% = 2778
80 - 99% = 524
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486090, depth: 3, leaf buckets: 8359, nodes: 7109291
Average node length: 5.39, total dup: 6829604, max dup: 177
Average key length: 2.40, compression ratio: 7.08
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1500776, ratio: 0.21
Fill distribution:
0 - 19% = 11
20 - 39% = 1047
40 - 59% = 4464
60 - 79% = 1618
80 - 99% = 1219
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490630, depth: 3, leaf buckets: 8455, nodes: 7109291
Average node length: 5.39, total dup: 6829604, max dup: 177
Average key length: 2.40, compression ratio: 7.08
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1503063, ratio: 0.21
Fill distribution:
0 - 19% = 13
20 - 39% = 1146
40 - 59% = 4483
60 - 79% = 1605
80 - 99% = 1208
XQD_1200_2000 (177)
Primary pointer page: 579, Index root page: 580
Total formats: 1, used formats: 1
Average record length: 67.01, total records: 12009648
Average version length: 68.74, total versions: 385387, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.88
Pointer pages: 105, data page slots: 171112
Data pages: 171112, average fill: 75%
Primary pages: 171112, secondary pages: 0, swept pages: 45835
Empty pages: 6, full pages: 170009
Fill distribution:
0 - 19% = 10
20 - 39% = 50
40 - 59% = 259
60 - 79% = 167813
80 - 99% = 2980
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495050, depth: 3, leaf buckets: 18309, nodes: 12005411
Average node length: 6.60, total dup: 10466224, max dup: 68
Average key length: 3.43, compression ratio: 12.26
Average prefix length: 40.70, average data length: 1.30
Clustering factor: 2484417, ratio: 0.21
Fill distribution:
0 - 19% = 32
20 - 39% = 2295
40 - 59% = 10698
60 - 79% = 4481
80 - 99% = 803
XQD_2000_3300 (179)
Primary pointer page: 583, Index root page: 584
Total formats: 1, used formats: 1
Average record length: 40.76, total records: 1893569
Average version length: 69.05, total versions: 474721, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.09
Pointer pages: 27, data page slots: 43448
Data pages: 30696, average fill: 60%
Primary pages: 30598, secondary pages: 98, swept pages: 4199
Empty pages: 1058, full pages: 24514
Fill distribution:
0 - 19% = 2496
20 - 39% = 5593
40 - 59% = 3354
60 - 79% = 12857
80 - 99% = 6396
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479735, depth: 3, leaf buckets: 1935, nodes: 1474679
Average node length: 5.51, total dup: 1414435, max dup: 49
Average key length: 2.56, compression ratio: 16.38
Average prefix length: 41.48, average data length: 0.52
Clustering factor: 109733, ratio: 0.07
Fill distribution:
0 - 19% = 12
20 - 39% = 399
40 - 59% = 938
60 - 79% = 471
80 - 99% = 115
XQD_2100_3300 (180)
Primary pointer page: 585, Index root page: 586
Total formats: 1, used formats: 1
Average record length: 33.76, total records: 1602683
Average version length: 69.02, total versions: 220078, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.73
Pointer pages: 21, data page slots: 33448
Data pages: 29112, average fill: 43%
Primary pages: 29110, secondary pages: 2, swept pages: 5841
Empty pages: 5684, full pages: 18539
Fill distribution:
0 - 19% = 8058
20 - 39% = 2853
40 - 59% = 7294
60 - 79% = 10169
80 - 99% = 738
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479229, depth: 3, leaf buckets: 1242, nodes: 881361
Average node length: 5.92, total dup: 813392, max dup: 93
Average key length: 2.98, compression ratio: 14.09
Average prefix length: 41.09, average data length: 0.91
Clustering factor: 129156, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 252
40 - 59% = 633
60 - 79% = 316
80 - 99% = 41
XQD_3300_3400 (181)
Primary pointer page: 587, Index root page: 588
Total formats: 1, used formats: 1
Average record length: 64.85, total records: 9516937
Average version length: 68.95, total versions: 633212, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.94
Pointer pages: 90, data page slots: 145520
Data pages: 145496, average fill: 70%
Primary pages: 145480, secondary pages: 16, swept pages: 34944
Empty pages: 293, full pages: 93275
Fill distribution:
0 - 19% = 704
20 - 39% = 2543
40 - 59% = 15274
60 - 79% = 121491
80 - 99% = 5484
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472612, depth: 3, leaf buckets: 13534, nodes: 9506937
Average node length: 6.68, total dup: 7888914, max dup: 14
Average key length: 3.66, compression ratio: 11.48
Average prefix length: 40.51, average data length: 1.49
Clustering factor: 2130763, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 949
40 - 59% = 6516
60 - 79% = 5264
80 - 99% = 804
XQS_1000_1200 (182)
Primary pointer page: 589, Index root page: 590
Total formats: 1, used formats: 1
Average record length: 82.41, total records: 21187753
Average version length: 82.76, total versions: 38542, 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: 197, data page slots: 320144
Data pages: 320144, average fill: 81%
Primary pages: 320137, secondary pages: 7, swept pages: 10483
Empty pages: 16, full pages: 319878
Fill distribution:
0 - 19% = 23
20 - 39% = 7
40 - 59% = 24
60 - 79% = 46507
80 - 99% = 273583
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426738, depth: 3, leaf buckets: 19279, nodes: 21187753
Average node length: 5.72, total dup: 20706208, max dup: 181
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3288243, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 7898
60 - 79% = 565
80 - 99% = 10810
Index XQS_1000_1200_RCV_ID (3)
Root page: 1457002, depth: 3, leaf buckets: 17190, nodes: 21187753
Average node length: 6.31, total dup: 18620427, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 917116, ratio: 0.04
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 781
60 - 79% = 280
80 - 99% = 16123
Index XQS_1000_1200_SND_ID (2)
Root page: 1441095, depth: 3, leaf buckets: 21036, nodes: 21187753
Average node length: 6.35, total dup: 18540025, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3583037, ratio: 0.17
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 8150
60 - 79% = 596
80 - 99% = 12287
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413370, depth: 3, leaf buckets: 16058, nodes: 21187753
Average node length: 5.56, total dup: 21187653, max dup: 228224
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 946150, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 2852
60 - 79% = 277
80 - 99% = 12918
XQS_1000_3300 (184)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 77.68, total records: 9976265
Average version length: 82.59, total versions: 644986, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.62
Pointer pages: 103, data page slots: 167560
Data pages: 167536, average fill: 74%
Primary pages: 167510, secondary pages: 26, swept pages: 48168
Empty pages: 223, full pages: 119370
Fill distribution:
0 - 19% = 553
20 - 39% = 2023
40 - 59% = 11846
60 - 79% = 121709
80 - 99% = 31405
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367524, depth: 3, leaf buckets: 11385, nodes: 9976265
Average node length: 5.37, total dup: 9664317, max dup: 267
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 2293219, ratio: 0.23
Fill distribution:
0 - 19% = 4
20 - 39% = 26
40 - 59% = 7403
60 - 79% = 3781
80 - 99% = 171
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379283, depth: 3, leaf buckets: 13571, nodes: 9976265
Average node length: 6.24, total dup: 8273682, max dup: 14
Average key length: 3.10, compression ratio: 2.91
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1628216, ratio: 0.16
Fill distribution:
0 - 19% = 117
20 - 39% = 3694
40 - 59% = 4382
60 - 79% = 2654
80 - 99% = 2724
Index XQS_1000_3300_SND_ID (2)
Root page: 1373081, depth: 3, leaf buckets: 12695, nodes: 9976265
Average node length: 5.99, total dup: 8667296, max dup: 44
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 2489722, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 30
40 - 59% = 8343
60 - 79% = 4094
80 - 99% = 227
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362789, depth: 3, leaf buckets: 10175, nodes: 9976265
Average node length: 5.15, total dup: 9976165, max dup: 154079
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1636911, ratio: 0.16
Fill distribution:
0 - 19% = 45
20 - 39% = 1032
40 - 59% = 4940
60 - 79% = 1773
80 - 99% = 2385
XQS_1200_2000 (183)
Primary pointer page: 591, Index root page: 592
Total formats: 1, used formats: 1
Average record length: 77.09, total records: 11957450
Average version length: 82.48, total versions: 850981, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.63
Pointer pages: 123, data page slots: 199792
Data pages: 198832, average fill: 75%
Primary pages: 198657, secondary pages: 175, swept pages: 52411
Empty pages: 1782, full pages: 160916
Fill distribution:
0 - 19% = 3301
20 - 39% = 5966
40 - 59% = 14741
60 - 79% = 87589
80 - 99% = 87235
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392123, depth: 3, leaf buckets: 13189, nodes: 11957450
Average node length: 5.33, total dup: 11846594, max dup: 694
Average key length: 2.08, compression ratio: 4.33
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2499122, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 39
40 - 59% = 7534
60 - 79% = 5180
80 - 99% = 435
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406132, depth: 3, leaf buckets: 10823, nodes: 11957450
Average node length: 5.53, total dup: 11435959, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 761002, ratio: 0.06
Fill distribution:
0 - 19% = 138
20 - 39% = 702
40 - 59% = 2559
60 - 79% = 1819
80 - 99% = 5605
Index XQS_1200_2000_SND_ID (2)
Root page: 1398660, depth: 3, leaf buckets: 15089, nodes: 11957450
Average node length: 6.05, total dup: 10461300, max dup: 82
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 2516008, ratio: 0.21
Fill distribution:
0 - 19% = 6
20 - 39% = 62
40 - 59% = 8928
60 - 79% = 5626
80 - 99% = 467
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386233, depth: 3, leaf buckets: 11263, nodes: 11957450
Average node length: 5.26, total dup: 11957350, max dup: 202334
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 749006, ratio: 0.06
Fill distribution:
0 - 19% = 85
20 - 39% = 791
40 - 59% = 5029
60 - 79% = 1360
80 - 99% = 3998
XQS_2000_3300 (185)
Primary pointer page: 595, Index root page: 596
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (1)
Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (3)
Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (2)
Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_WORKER_ID (0)
Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (186)
Primary pointer page: 597, Index root page: 598
Total formats: 1, used formats: 1
Average record length: 78.32, total records: 10047836
Average version length: 82.90, total versions: 602608, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.61
Pointer pages: 106, data page slots: 171840
Data pages: 171808, average fill: 73%
Primary pages: 171789, secondary pages: 19, swept pages: 52734
Empty pages: 304, full pages: 115930
Fill distribution:
0 - 19% = 776
20 - 39% = 2982
40 - 59% = 16307
60 - 79% = 123247
80 - 99% = 28496
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344708, depth: 3, leaf buckets: 12062, nodes: 10047836
Average node length: 5.18, total dup: 10018940, max dup: 1548
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 2077710, ratio: 0.21
Fill distribution:
0 - 19% = 34
20 - 39% = 1343
40 - 59% = 8127
60 - 79% = 1924
80 - 99% = 634
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355739, depth: 3, leaf buckets: 13671, nodes: 10047836
Average node length: 6.25, total dup: 8333083, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1587195, ratio: 0.16
Fill distribution:
0 - 19% = 190
20 - 39% = 3671
40 - 59% = 4316
60 - 79% = 2641
80 - 99% = 2853
Index XQS_2100_3300_SND_ID (2)
Root page: 1350071, depth: 3, leaf buckets: 12681, nodes: 10047836
Average node length: 5.44, total dup: 9601156, max dup: 99
Average key length: 2.28, compression ratio: 3.94
Average prefix length: 8.76, average data length: 0.24
Clustering factor: 2214740, ratio: 0.22
Fill distribution:
0 - 19% = 29
20 - 39% = 1321
40 - 59% = 9004
60 - 79% = 1666
80 - 99% = 661
Index XQS_2100_3300_WORKER_ID (0)
Root page: 987843, depth: 3, leaf buckets: 10295, nodes: 10047836
Average node length: 5.16, total dup: 10047736, max dup: 155804
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1658777, ratio: 0.17
Fill distribution:
0 - 19% = 37
20 - 39% = 1102
40 - 59% = 5018
60 - 79% = 1832
80 - 99% = 2306
XQS_3300_3400 (187)
Primary pointer page: 599, Index root page: 600
Total formats: 1, used formats: 1
Average record length: 67.10, total records: 582069
Average version length: 68.83, total versions: 10566, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.88
Pointer pages: 5, data page slots: 8104
Data pages: 8104, average fill: 75%
Primary pages: 8104, secondary pages: 0, swept pages: 2932
Empty pages: 4, full pages: 7365
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 65
60 - 79% = 7844
80 - 99% = 189
Index XQS_3300_3400_DOC_ID (1)
Root page: 42665, depth: 3, leaf buckets: 752, nodes: 582069
Average node length: 5.95, total dup: 495786, max dup: 82
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 102353, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 534
60 - 79% = 114
80 - 99% = 76
Index XQS_3300_3400_SND_ID (2)
Root page: 31559, depth: 3, leaf buckets: 768, nodes: 582069
Average node length: 6.15, total dup: 477552, max dup: 21
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 102394, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 33
40 - 59% = 528
60 - 79% = 113
80 - 99% = 93
Index XQS_3300_3400_WORKER_ID (0)
Root page: 377587, depth: 2, leaf buckets: 561, nodes: 582069
Average node length: 4.86, total dup: 581969, max dup: 10068
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 90938, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 328
60 - 79% = 64
80 - 99% = 146
ZDOC_DATA (170)
Primary pointer page: 565, Index root page: 566
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (169)
Primary pointer page: 563, Index root page: 564
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (171)
Primary pointer page: 567, Index root page: 568
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (174)
Primary pointer page: 573, Index root page: 574
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (175)
Primary pointer page: 575, Index root page: 576
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (172)
Primary pointer page: 569, Index root page: 570
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (173)
Primary pointer page: 571, Index root page: 572
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (168)
Primary pointer page: 561, Index root page: 562
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (167)
Primary pointer page: 559, Index root page: 560
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (144)
Primary pointer page: 512, Index root page: 513
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Sun Feb 25 13:09:32 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7822251 |
124832 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2288381 |
67773 |
2 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
1553 |
6 |
300.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
169386 |
147133 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
125 |
6 |
200.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
2803 |
2556 |
1 |
0.0000 |
0.0000 |
PDISTR |
823390 |
42618 |
3 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
195523 |
32874 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
139143 |
3315 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
187332 |
30686 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
156487 |
2697 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
189535 |
19690 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
151192 |
2581 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
159505 |
6722 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
172204 |
7938 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
148227 |
8487 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
152656 |
2886 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2136568 |
64461 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
163331 |
80949 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7109291 |
511760 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12009648 |
385387 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1893569 |
474721 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1602683 |
220078 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
9516937 |
633212 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21187753 |
38542 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9976265 |
644986 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
11957450 |
850981 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
10047836 |
602608 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
582069 |
10566 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
--- end of diff output ---
25.02.24 13:09:43. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
335544321 'string truncation'. Attempt to assign too long text into string variable.
335544347 'not_valid'. Validation error for column.
335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT |
ERRORS_RESULT |
2024-02-25 13:09:46 |
No severe PSQL-related problems occured |
25.02.24 13:09:47. End of report.