Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.02.2024 19:11
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 | 15815724 kB |
MemAvailable | 30309500 kB |
Buffers | 0 kB |
Cached | 15941980 kB |
SwapCached | 2332 kB |
Command: fdisk -l |
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion. |
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk label type: gpt |
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C |
# Start End Size Type Name |
1 2048 411647 200M EFI System EFI System Partition |
2 411648 2508799 1G Microsoft basic |
3 2508800 1171742719 557.5G Linux LVM |
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 512 bytes / 512 bytes |
Disk label type: dos |
Disk identifier: 0x00000046 |
Device Boot Start End Blocks Id System |
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA) |
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
SERVER_MODE SuperServer 3.0.12
DB_NAME /home/bases/oltp30-etalone.fdb
FORCED_WRITES ON
SWEEP_INT 0
PAGE_BUFFERS 1000000
PAGE_SIZE 8192
Test configuration settings
param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2024-02-28 19:09:47
DTS_END 2024-02-28 19:09:47.3840
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/49466
TRN_ID 169007
ATT_ID 581
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: |
9139.29 |
21806 |
913929 |
customer order: creation |
167.39 |
354 |
16739 |
customer order: refuse |
13.94 |
428 |
1394 |
order to supplier: creation |
43.67 |
1259 |
4367 |
order to supplier: removal |
3.61 |
103274 |
361 |
invoice (draft): creation |
43.45 |
3182 |
4345 |
invoice (draft): removal |
53.56 |
830 |
5356 |
invoice accept: apply |
39.21 |
21980 |
3921 |
invoice accept: cancel |
48.18 |
778 |
4818 |
customer reserve: creation |
3770.17 |
211 |
377017 |
customer reserve: removal |
4654.34 |
62 |
465434 |
realization accept: apply |
82.03 |
216 |
8203 |
realization accept: cancel |
93.97 |
121 |
9397 |
payment from customer: creation |
57.80 |
143 |
5780 |
payment from customer: removal |
5.52 |
115 |
552 |
payment to supplier: creation |
47.01 |
161 |
4701 |
payment to supplier: removal |
3.41 |
116 |
341 |
service: total inventory turnovers |
4.82 |
1128 |
482 |
service: total monetary turnovers |
6.39 |
24 |
639 |
service: aggregate perf. data |
0.79 |
19559 |
79 |
service: refresh index statistics |
0.03 |
282176 |
3 |
Completed "Performance in TOTAL". Done for 00:00:02, from 28-02-2024 19:11:48 to 28-02-2024 19:11:50.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
2566 |
TEST_TIME |
2 |
3046 |
TEST_TIME |
3 |
3337 |
TEST_TIME |
4 |
3154 |
TEST_TIME |
5 |
3003 |
TEST_TIME |
6 |
3656 |
TEST_TIME |
7 |
4515 |
TEST_TIME |
8 |
4695 |
TEST_TIME |
9 |
4994 |
TEST_TIME |
10 |
5423 |
TEST_TIME |
11 |
5697 |
TEST_TIME |
12 |
6256 |
TEST_TIME |
13 |
6177 |
TEST_TIME |
14 |
6285 |
TEST_TIME |
15 |
6416 |
TEST_TIME |
16 |
6600 |
TEST_TIME |
17 |
6649 |
TEST_TIME |
18 |
6659 |
TEST_TIME |
19 |
6672 |
TEST_TIME |
20 |
6703 |
TEST_TIME |
21 |
6880 |
TEST_TIME |
22 |
6980 |
TEST_TIME |
23 |
7000 |
TEST_TIME |
24 |
7187 |
TEST_TIME |
25 |
7097 |
TEST_TIME |
26 |
7119 |
TEST_TIME |
27 |
7077 |
TEST_TIME |
28 |
6944 |
TEST_TIME |
29 |
7650 |
TEST_TIME |
30 |
8649 |
TEST_TIME |
31 |
9004 |
TEST_TIME |
32 |
8923 |
TEST_TIME |
33 |
8979 |
TEST_TIME |
34 |
8951 |
TEST_TIME |
35 |
8835 |
TEST_TIME |
36 |
8822 |
TEST_TIME |
37 |
8660 |
TEST_TIME |
38 |
8753 |
TEST_TIME |
39 |
8849 |
TEST_TIME |
40 |
8746 |
TEST_TIME |
41 |
8709 |
TEST_TIME |
42 |
8674 |
TEST_TIME |
43 |
8750 |
TEST_TIME |
44 |
8758 |
TEST_TIME |
45 |
8744 |
TEST_TIME |
46 |
8736 |
TEST_TIME |
47 |
8700 |
TEST_TIME |
48 |
8566 |
TEST_TIME |
49 |
8553 |
TEST_TIME |
50 |
8601 |
TEST_TIME |
51 |
8594 |
TEST_TIME |
52 |
8565 |
TEST_TIME |
53 |
8623 |
TEST_TIME |
54 |
8626 |
TEST_TIME |
55 |
8639 |
TEST_TIME |
56 |
8672 |
TEST_TIME |
57 |
8756 |
TEST_TIME |
58 |
8714 |
TEST_TIME |
59 |
8730 |
TEST_TIME |
60 |
8875 |
TEST_TIME |
61 |
9042 |
TEST_TIME |
62 |
9157 |
TEST_TIME |
63 |
9192 |
TEST_TIME |
64 |
9161 |
TEST_TIME |
65 |
9140 |
TEST_TIME |
66 |
9086 |
TEST_TIME |
67 |
9067 |
TEST_TIME |
68 |
9011 |
TEST_TIME |
69 |
9022 |
TEST_TIME |
70 |
9037 |
TEST_TIME |
71 |
8985 |
TEST_TIME |
72 |
8911 |
TEST_TIME |
73 |
9046 |
TEST_TIME |
74 |
9076 |
TEST_TIME |
75 |
9035 |
TEST_TIME |
76 |
8995 |
TEST_TIME |
77 |
8996 |
TEST_TIME |
78 |
9127 |
TEST_TIME |
79 |
9128 |
TEST_TIME |
80 |
9157 |
TEST_TIME |
81 |
9117 |
TEST_TIME |
82 |
9294 |
TEST_TIME |
83 |
9326 |
TEST_TIME |
84 |
9332 |
TEST_TIME |
85 |
9317 |
TEST_TIME |
86 |
9310 |
TEST_TIME |
87 |
9359 |
TEST_TIME |
88 |
9383 |
TEST_TIME |
89 |
9381 |
TEST_TIME |
90 |
9306 |
TEST_TIME |
91 |
9272 |
TEST_TIME |
92 |
9249 |
TEST_TIME |
93 |
9236 |
TEST_TIME |
94 |
9210 |
TEST_TIME |
95 |
9160 |
TEST_TIME |
96 |
9171 |
TEST_TIME |
97 |
9187 |
TEST_TIME |
98 |
9140 |
TEST_TIME |
99 |
9088 |
TEST_TIME |
100 |
9153 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2024 19:11:51 to 28-02-2024 19:11:54.
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 |
1261247 |
1261247 |
0 |
0.00 |
0 |
18308 |
7 |
0 |
0 |
doc_list_biud |
1261247 |
1261247 |
0 |
0.00 |
0 |
38385 |
29 |
0 |
0 |
sp_add_invoice_to_stock |
4015 |
3921 |
94 |
2.34 |
57 |
204748 |
21981 |
0 |
94 |
sp_cancel_adding_invoice |
4818 |
4818 |
0 |
0.00 |
5 |
54379 |
779 |
0 |
0 |
sp_cancel_client_order |
1394 |
1394 |
0 |
0.00 |
5 |
25702 |
428 |
0 |
0 |
sp_cancel_customer_reserve |
465434 |
465434 |
0 |
0.00 |
0 |
37401 |
62 |
0 |
0 |
sp_cancel_pay_from_customer |
552 |
552 |
0 |
0.00 |
3 |
12093 |
115 |
0 |
0 |
sp_cancel_pay_to_supplier |
341 |
341 |
0 |
0.00 |
2 |
8877 |
117 |
0 |
0 |
sp_cancel_supplier_invoice |
5369 |
5356 |
13 |
0.24 |
2 |
38398 |
830 |
0 |
13 |
sp_cancel_supplier_order |
361 |
361 |
0 |
0.00 |
7 |
1076331 |
103275 |
0 |
0 |
sp_cancel_write_off |
9397 |
9397 |
0 |
0.00 |
1 |
15239 |
122 |
0 |
0 |
sp_client_order |
16739 |
16739 |
0 |
0.00 |
3 |
23232 |
355 |
0 |
0 |
sp_customer_reserve |
377017 |
377017 |
0 |
0.00 |
0 |
55377 |
212 |
0 |
0 |
sp_fill_shopping_cart |
25444 |
25444 |
0 |
0.00 |
1 |
8206 |
33 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
377000 |
377000 |
0 |
0.00 |
0 |
23447 |
18 |
0 |
0 |
sp_get_clo_for_invoice |
3903 |
3903 |
0 |
0.00 |
0 |
27596 |
326 |
0 |
0 |
sp_kill_cost_storno |
15108 |
15108 |
0 |
0.00 |
0 |
8864 |
62 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
945982 |
945982 |
0 |
0.00 |
0 |
38379 |
34 |
0 |
0 |
sp_kill_qty_storno |
498866 |
498866 |
0 |
0.00 |
0 |
38383 |
73 |
0 |
0 |
sp_lock_selected_doc |
16760 |
16760 |
0 |
0.00 |
0 |
8615 |
7 |
0 |
0 |
sp_make_cost_storno |
22587 |
22587 |
0 |
0.00 |
0 |
13277 |
67 |
0 |
0 |
sp_multiply_rows_for_pdistr |
22587 |
22587 |
0 |
0.00 |
0 |
18306 |
35 |
0 |
0 |
sp_multiply_rows_for_qdistr |
16739 |
16739 |
0 |
0.00 |
0 |
16613 |
170 |
0 |
0 |
sp_pay_from_customer |
5780 |
5780 |
0 |
0.00 |
4 |
18312 |
143 |
0 |
0 |
sp_pay_to_supplier |
4701 |
4701 |
0 |
0.00 |
5 |
14082 |
161 |
0 |
0 |
sp_payment_common |
10481 |
10481 |
0 |
0.00 |
1 |
11004 |
37 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1394 |
1394 |
0 |
0.00 |
0 |
25694 |
380 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
8721 |
8721 |
0 |
0.00 |
0 |
28948 |
318 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8203 |
8203 |
0 |
0.00 |
0 |
36604 |
67 |
0 |
0 |
sp_reserve_write_off |
8203 |
8203 |
0 |
0.00 |
5 |
36641 |
216 |
0 |
0 |
sp_supplier_invoice |
4345 |
4345 |
0 |
0.00 |
6 |
75295 |
3182 |
0 |
0 |
sp_supplier_order |
4367 |
4367 |
0 |
0.00 |
5 |
38723 |
1260 |
0 |
0 |
srv_aggregate_perf_data |
79 |
79 |
0 |
0.00 |
1853 |
252118 |
19559 |
0 |
0 |
srv_fill_mon_cache_memory |
56 |
56 |
0 |
0.00 |
1193 |
105833 |
39348 |
0 |
0 |
srv_find_qd_qs_mism |
874380 |
874380 |
0 |
0.00 |
0 |
13399 |
6 |
0 |
0 |
srv_make_invnt_saldo |
482 |
482 |
0 |
0.00 |
36 |
94538 |
1128 |
0 |
0 |
srv_make_money_saldo |
639 |
639 |
0 |
0.00 |
1 |
790 |
25 |
0 |
0 |
srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
196178 |
380492 |
282177 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
94 |
94 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
13 |
13 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
3922 |
3922 |
0 |
0.00 |
0 |
13687 |
179 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
328 |
328 |
0 |
0.00 |
0 |
5220 |
98 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1394 |
1394 |
0 |
0.00 |
0 |
14588 |
27 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
518 |
518 |
0 |
0.00 |
0 |
981 |
8 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
552 |
552 |
0 |
0.00 |
0 |
1302 |
6 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
341 |
341 |
0 |
0.00 |
0 |
2158 |
9 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
329 |
329 |
0 |
0.00 |
0 |
3844 |
34 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
361 |
361 |
0 |
0.00 |
0 |
32984 |
1914 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
831 |
831 |
0 |
0.00 |
0 |
2488 |
8 |
0 |
0 |
t$perf-norm:sp_client_order |
16739 |
16739 |
0 |
0.00 |
0 |
7201 |
19 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
780 |
780 |
0 |
0.00 |
0 |
548 |
4 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
5780 |
5780 |
0 |
0.00 |
0 |
6110 |
10 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
4701 |
4701 |
0 |
0.00 |
0 |
9874 |
12 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8203 |
8203 |
0 |
0.00 |
0 |
5553 |
11 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4345 |
4345 |
0 |
0.00 |
0 |
10950 |
17 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4367 |
4367 |
0 |
0.00 |
0 |
2792 |
18 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
79 |
79 |
0 |
0.00 |
0 |
261 |
4 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
56 |
56 |
0 |
0.00 |
0 |
111 |
4 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
482 |
482 |
0 |
0.00 |
0 |
815 |
22 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
639 |
639 |
0 |
0.00 |
0 |
2276 |
21 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
2 |
5 |
3 |
0 |
0 |
v_add_invoice_to_stock |
7994 |
7806 |
188 |
2.35 |
0 |
5660 |
21 |
0 |
188 |
v_all_customers |
31106 |
31106 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_suppliers |
24992 |
24992 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_wares |
33478 |
33478 |
0 |
0.00 |
0 |
22 |
1 |
0 |
0 |
v_cancel_adding_invoice |
656 |
656 |
0 |
0.00 |
0 |
469 |
7 |
0 |
0 |
v_cancel_client_order |
2788 |
2788 |
0 |
0.00 |
0 |
8737 |
10 |
0 |
0 |
v_cancel_customer_prepayment |
1104 |
1104 |
0 |
0.00 |
0 |
5148 |
10 |
0 |
0 |
v_cancel_customer_reserve |
1036 |
1036 |
0 |
0.00 |
0 |
3953 |
15 |
0 |
0 |
v_cancel_payment_to_supplier |
682 |
682 |
0 |
0.00 |
0 |
3542 |
13 |
0 |
0 |
v_cancel_supplier_invoice |
684 |
658 |
26 |
3.80 |
0 |
2452 |
19 |
0 |
26 |
v_cancel_supplier_order |
722 |
722 |
0 |
0.00 |
0 |
5666 |
13 |
0 |
0 |
v_cancel_write_off |
1662 |
1662 |
0 |
0.00 |
0 |
3558 |
17 |
0 |
0 |
v_max_id_clo_ord |
4367 |
4367 |
0 |
0.00 |
0 |
1050 |
2 |
0 |
0 |
v_max_id_clo_res |
780 |
780 |
0 |
0.00 |
0 |
4400 |
18 |
0 |
0 |
v_max_id_ord_sup |
4338 |
4338 |
0 |
0.00 |
0 |
7406 |
3 |
0 |
0 |
v_max_non_paid_invoice |
910 |
910 |
0 |
0.00 |
0 |
632 |
4 |
0 |
0 |
v_max_non_paid_realizn |
2802 |
2802 |
0 |
0.00 |
0 |
4159 |
7 |
0 |
0 |
v_min_id_clo_ord |
4367 |
4367 |
0 |
0.00 |
0 |
2165 |
7 |
0 |
0 |
v_min_id_clo_res |
780 |
780 |
0 |
0.00 |
0 |
57 |
1 |
0 |
0 |
v_min_id_ord_sup |
4338 |
4338 |
0 |
0.00 |
0 |
7352 |
9 |
0 |
0 |
v_min_non_paid_invoice |
4701 |
4701 |
0 |
0.00 |
0 |
9360 |
25 |
0 |
0 |
v_min_non_paid_realizn |
5780 |
5780 |
0 |
0.00 |
0 |
10994 |
33 |
0 |
0 |
v_our_firm |
8328 |
8328 |
0 |
0.00 |
0 |
90 |
1 |
0 |
0 |
v_reserve_write_off |
16406 |
16406 |
0 |
0.00 |
0 |
8637 |
10 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9845 |
9845 |
0 |
0.00 |
0 |
29915 |
141 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
361 |
361 |
0 |
0.00 |
0 |
14106 |
415 |
0 |
0 |
x_make_qstorno_1000_1200 |
4367 |
4367 |
0 |
0.00 |
1 |
38714 |
1178 |
0 |
0 |
x_make_qstorno_1200_2000 |
4345 |
4345 |
0 |
0.00 |
3 |
75289 |
3065 |
0 |
0 |
x_make_qstorno_2100_3300 |
377017 |
377017 |
0 |
0.00 |
0 |
52989 |
191 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:05, from 28-02-2024 19:11:55 to 28-02-2024 19:12:00.
Fields:
page cache memo used = page cache total size, bytes:
memo used, total = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
memo allocated, total = the same of mon$memory_usage.mon$memory_allocated;
metadata cache memo used = metadata cache, bytes;
metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
total attachments cnt = total number of attachments, regardless of state;
active attachments cnt = number of attachments with mon$state = 1;
running statements cnt = number of statements that are operating with data from page cache (mon$state = 1);
stalled statements cnt = number of statements that are waiting for client request for fetching ( mon$state = 2);
memo used by attachments = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
memo used by transactions = the same of transaction level (mon$stat_group = 2);
memo used by statements = the same of statement level (mon$stat_group = 3);
Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts |
measurement duration ms |
page cache memo used |
memo used, total |
memo allocated, total |
metadata cache |
metadata cache percent of total |
total attachments cnt |
active attachments cnt |
running statements cnt |
stalled statements cnt |
memo used by attachments |
memo used by transactions |
memo used by statements |
17:09:50 |
10 |
8192000000 |
8800648528 |
8812658688 |
6649840 |
0.081 |
3 |
1 |
2 |
0 |
6750768 |
58144 |
42784 |
17:10:51 |
34782 |
8192000000 |
9899137120 |
10210828288 |
988587312 |
10.768 |
100 |
95 |
190 |
0 |
1018983104 |
5574048 |
24821744 |
17:12:33 |
18069 |
8192000000 |
9947065424 |
10268168192 |
1032048064 |
11.188 |
100 |
92 |
184 |
0 |
1063897728 |
8359296 |
23490368 |
17:13:56 |
12961 |
8192000000 |
9975790160 |
10302873600 |
1059241488 |
11.449 |
100 |
88 |
176 |
0 |
1091915424 |
10180560 |
22493376 |
17:15:16 |
13955 |
8192000000 |
10022738320 |
10369327104 |
1106622944 |
11.900 |
100 |
74 |
148 |
0 |
1135211296 |
10759280 |
17829072 |
17:16:34 |
8103 |
8192000000 |
10057027040 |
10413445120 |
1147225136 |
12.283 |
100 |
74 |
145 |
0 |
1176322816 |
12383952 |
16713728 |
17:17:43 |
2753 |
8192000000 |
10113294064 |
10481422336 |
1202313472 |
12.798 |
100 |
67 |
134 |
1 |
1228987632 |
11854928 |
14819232 |
17:18:47 |
1804 |
8192000000 |
10161427104 |
10534027264 |
1245645024 |
13.198 |
100 |
81 |
162 |
0 |
1276882560 |
12749744 |
18487792 |
17:19:51 |
1100 |
8192000000 |
10193289824 |
10573799424 |
1279551312 |
13.509 |
100 |
91 |
183 |
2 |
1313491072 |
13787936 |
20151824 |
17:20:53 |
1210 |
8192000000 |
10214734880 |
10602778624 |
1301628928 |
13.710 |
100 |
85 |
170 |
1 |
1333489008 |
14113120 |
17746960 |
17:21:56 |
36807 |
8192000000 |
10191124816 |
10605072384 |
1305789376 |
13.748 |
100 |
39 |
76 |
0 |
1320828576 |
6584720 |
8454480 |
17:23:37 |
5466 |
8192000000 |
10198014752 |
10616090624 |
1315103664 |
13.832 |
100 |
24 |
48 |
0 |
1327516480 |
7225280 |
5187536 |
17:24:44 |
16602 |
8192000000 |
10199694624 |
10622795776 |
1324672720 |
13.919 |
100 |
10 |
20 |
0 |
1332517728 |
5991104 |
1853904 |
17:26:02 |
9342 |
8192000000 |
10213206448 |
10632343552 |
1327277744 |
13.943 |
100 |
11 |
22 |
0 |
1335424848 |
5889568 |
2257536 |
17:27:13 |
20752 |
8192000000 |
10229968432 |
10640375808 |
1328646304 |
13.955 |
100 |
50 |
100 |
1 |
1346375936 |
6461744 |
11267888 |
17:28:34 |
7094 |
8192000000 |
10217705584 |
10638622720 |
1317104880 |
13.850 |
99 |
39 |
79 |
1 |
1332741504 |
6474688 |
9161936 |
17:29:44 |
20948 |
8192000000 |
10206164048 |
10620485632 |
1304306928 |
13.734 |
99 |
36 |
72 |
0 |
1319695968 |
6903472 |
8485568 |
17:31:25 |
10544 |
8192000000 |
10222295328 |
10633207808 |
1322542736 |
13.900 |
100 |
35 |
70 |
0 |
1339012480 |
8241712 |
8228032 |
17:32:50 |
35687 |
8192000000 |
10246418320 |
10661990400 |
1333538048 |
13.999 |
99 |
42 |
82 |
0 |
1353929440 |
9908512 |
10482880 |
17:34:33 |
26990 |
8192000000 |
10242250096 |
10662854656 |
1322243168 |
13.897 |
98 |
43 |
81 |
0 |
1345494352 |
13165072 |
10086112 |
17:36:06 |
36360 |
8192000000 |
10242055904 |
10661134336 |
1329206768 |
13.960 |
99 |
25 |
48 |
2 |
1348011136 |
12978864 |
5825504 |
17:37:56 |
7425 |
8192000000 |
10230698080 |
10637983744 |
1315778480 |
13.838 |
100 |
54 |
108 |
1 |
1343814608 |
15532928 |
12503200 |
17:39:35 |
6192 |
8192000000 |
10233151856 |
10638209024 |
1305290480 |
13.743 |
99 |
51 |
100 |
1 |
1336006048 |
18737376 |
11978192 |
17:40:53 |
34793 |
8192000000 |
10227040992 |
10642755584 |
1320018208 |
13.877 |
100 |
45 |
90 |
0 |
1350031760 |
19061424 |
10952128 |
17:42:37 |
4948 |
8192000000 |
10207560208 |
10597294080 |
1279731984 |
13.511 |
99 |
65 |
127 |
2 |
1312782048 |
18031040 |
15019024 |
17:43:49 |
3936 |
8192000000 |
10235735872 |
10635669504 |
1309135520 |
13.778 |
100 |
54 |
108 |
0 |
1339823584 |
17633792 |
13054272 |
17:45:02 |
4318 |
8192000000 |
10253855792 |
10654887936 |
1326458448 |
13.935 |
100 |
66 |
131 |
0 |
1363695648 |
21165616 |
16071584 |
17:46:22 |
22450 |
8192000000 |
10265120048 |
10672693248 |
1333093184 |
13.995 |
100 |
44 |
88 |
1 |
1367192528 |
23608512 |
10490832 |
17:48:02 |
1190 |
8192000000 |
10306314352 |
10702176256 |
1360555728 |
14.242 |
100 |
85 |
169 |
1 |
1409768816 |
29200912 |
20012176 |
17:49:08 |
10455 |
8192000000 |
10305699920 |
10713350144 |
1367735360 |
14.307 |
100 |
60 |
118 |
0 |
1413782768 |
31316176 |
14731232 |
17:50:24 |
9453 |
8192000000 |
10329818480 |
10742833152 |
1389169776 |
14.498 |
100 |
59 |
118 |
0 |
1439023072 |
35179376 |
14673920 |
17:51:41 |
6692 |
8192000000 |
10334139856 |
10754322432 |
1391391472 |
14.518 |
100 |
54 |
106 |
0 |
1443324736 |
38169648 |
13763616 |
17:52:54 |
11378 |
8192000000 |
10335564144 |
10754269184 |
1391617952 |
14.520 |
100 |
51 |
101 |
0 |
1443534576 |
38993712 |
12922912 |
17:54:09 |
34690 |
8192000000 |
10331172992 |
10758074368 |
1383783824 |
14.450 |
99 |
34 |
68 |
0 |
1430226304 |
37201184 |
9241296 |
17:56:17 |
9923 |
8192000000 |
10342791056 |
10771578880 |
1395499888 |
14.555 |
100 |
34 |
67 |
0 |
1446837088 |
42295920 |
9041280 |
17:57:33 |
33583 |
8192000000 |
10337535456 |
10785431552 |
1389187104 |
14.499 |
100 |
24 |
48 |
0 |
1453598144 |
56923760 |
7487280 |
17:59:13 |
54019 |
8192000000 |
10304304896 |
10766053376 |
1385773008 |
14.468 |
100 |
14 |
28 |
0 |
1431277392 |
41724944 |
3779440 |
18:01:13 |
44987 |
8192000000 |
10291123824 |
10741968896 |
1389478976 |
14.501 |
100 |
21 |
38 |
1 |
1402783840 |
8273632 |
5031232 |
18:02:59 |
28242 |
8192000000 |
10315532336 |
10751524864 |
1396060464 |
14.560 |
100 |
42 |
85 |
0 |
1412776432 |
7124128 |
9591840 |
18:04:30 |
34461 |
8192000000 |
10314418912 |
10759819264 |
1399916016 |
14.594 |
100 |
38 |
74 |
0 |
1419935376 |
11677040 |
8342320 |
18:06:05 |
100897 |
8192000000 |
10317572496 |
10772426752 |
1406094736 |
14.649 |
100 |
36 |
72 |
0 |
1427269792 |
12925648 |
8249408 |
18:09:03 |
46731 |
8192000000 |
10298925760 |
10757152768 |
1394924896 |
14.550 |
100 |
21 |
40 |
1 |
1410597680 |
11926144 |
3746640 |
18:11:10 |
27306 |
8192000000 |
10330232656 |
10773884928 |
1409708576 |
14.681 |
100 |
31 |
61 |
1 |
1427983680 |
10778480 |
7496624 |
18:12:38 |
42544 |
8192000000 |
10294896608 |
10756358144 |
1393072032 |
14.533 |
99 |
9 |
18 |
0 |
1407749920 |
12800912 |
1876976 |
18:14:22 |
41694 |
8192000000 |
10307937872 |
10765737984 |
1404136624 |
14.632 |
100 |
14 |
27 |
0 |
1418425632 |
11538288 |
2750720 |
18:16:04 |
28397 |
8192000000 |
10293655632 |
10748657664 |
1342465648 |
14.080 |
96 |
26 |
53 |
3 |
1359851568 |
11305408 |
6080512 |
18:17:37 |
60768 |
8192000000 |
10283663872 |
10742722560 |
1356389536 |
14.205 |
97 |
36 |
73 |
1 |
1373672624 |
8886960 |
8396128 |
18:19:46 |
13931 |
8192000000 |
10263337264 |
10720489472 |
1359876816 |
14.236 |
99 |
21 |
42 |
1 |
1371648768 |
7193392 |
4578560 |
18:21:02 |
75458 |
8192000000 |
10260637344 |
10729758720 |
1340363152 |
14.061 |
97 |
13 |
26 |
0 |
1356234048 |
12864640 |
3006256 |
18:23:26 |
21783 |
8192000000 |
10286194016 |
10739359744 |
1359865776 |
14.236 |
98 |
20 |
40 |
1 |
1374425760 |
9843488 |
4716496 |
18:24:53 |
56258 |
8192000000 |
10287760048 |
10747879424 |
1371646256 |
14.342 |
99 |
25 |
50 |
0 |
1394626320 |
17259792 |
5720272 |
18:26:58 |
8957 |
8192000000 |
10276814192 |
10710155264 |
1348379376 |
14.133 |
97 |
61 |
117 |
0 |
1372476960 |
10678112 |
13419472 |
18:28:11 |
36298 |
8192000000 |
10262378192 |
10695352320 |
1320378016 |
13.880 |
98 |
21 |
42 |
0 |
1342488384 |
16942992 |
5167376 |
18:29:59 |
56048 |
8192000000 |
10247421760 |
10704756736 |
1303939904 |
13.731 |
97 |
11 |
23 |
0 |
1331471952 |
24724864 |
2807184 |
18:31:55 |
29710 |
8192000000 |
10239311424 |
10671579136 |
1285361488 |
13.562 |
96 |
17 |
34 |
0 |
1297146576 |
8011168 |
3773920 |
18:33:27 |
15142 |
8192000000 |
10271856448 |
10692079616 |
1342258336 |
14.078 |
100 |
68 |
136 |
0 |
1367361184 |
9878864 |
15223984 |
18:35:08 |
104864 |
8192000000 |
10237189200 |
10673479680 |
1314001744 |
13.822 |
99 |
47 |
94 |
0 |
1340280144 |
16137120 |
10141280 |
18:37:56 |
36150 |
8192000000 |
10242139040 |
10682671104 |
1336930464 |
14.030 |
100 |
20 |
40 |
0 |
1352088640 |
10359136 |
4799040 |
18:39:38 |
39945 |
8192000000 |
10257810080 |
10708426752 |
1344651536 |
14.099 |
99 |
9 |
18 |
0 |
1362682848 |
15700000 |
2331312 |
18:41:19 |
78802 |
8192000000 |
10284672928 |
10744426496 |
1380945680 |
14.425 |
100 |
18 |
36 |
0 |
1396826240 |
11544944 |
4335616 |
18:43:51 |
66416 |
8192000000 |
10291730752 |
10741874688 |
1372453088 |
14.349 |
99 |
17 |
34 |
0 |
1390226464 |
13970880 |
3802496 |
18:46:00 |
65438 |
8192000000 |
10299916672 |
10758406144 |
1376624432 |
14.386 |
99 |
21 |
42 |
0 |
1398307856 |
16703392 |
4980032 |
18:48:07 |
47672 |
8192000000 |
10301400512 |
10752413696 |
1368739360 |
14.316 |
98 |
27 |
52 |
1 |
1384968832 |
10790784 |
5438688 |
18:49:58 |
77678 |
8192000000 |
10317345856 |
10773049344 |
1380248576 |
14.419 |
98 |
19 |
38 |
1 |
1402258656 |
17781216 |
4228864 |
18:52:18 |
65730 |
8192000000 |
10314853296 |
10761388032 |
1384401936 |
14.456 |
99 |
21 |
42 |
1 |
1400750144 |
11766928 |
4581280 |
18:54:29 |
68699 |
8192000000 |
10319326880 |
10767806464 |
1386337216 |
14.473 |
98 |
24 |
49 |
1 |
1403767696 |
11700624 |
5729856 |
18:56:42 |
47381 |
8192000000 |
10324924720 |
10784325632 |
1405582992 |
14.645 |
100 |
30 |
58 |
0 |
1426520064 |
14895024 |
6042048 |
18:58:35 |
105832 |
8192000000 |
10324070864 |
10781618176 |
1412572272 |
14.707 |
100 |
21 |
42 |
0 |
1433654656 |
16417760 |
4664624 |
19:01:24 |
29772 |
8192000000 |
10311442448 |
10763231232 |
1358195584 |
14.221 |
96 |
29 |
54 |
0 |
1373367664 |
9044560 |
6127520 |
19:02:57 |
66952 |
8192000000 |
10295530800 |
10759036928 |
1375387488 |
14.375 |
98 |
18 |
36 |
0 |
1394800560 |
15403712 |
4009360 |
19:05:08 |
70232 |
8192000000 |
10283013040 |
10740142080 |
1349335200 |
14.141 |
97 |
11 |
22 |
0 |
1371304272 |
19227728 |
2741344 |
19:07:39 |
76310 |
8192000000 |
10313658368 |
10768982016 |
1394933472 |
14.550 |
100 |
19 |
38 |
0 |
1423200320 |
23323072 |
4943776 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 28-02-2024 19:12:02 to 28-02-2024 19:12:15.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
94 |
v_add_invoice_to_stock |
335544517 |
except |
13 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-02-2024 19:12:16 to 28-02-2024 19:12:18.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 166118
MON$OLDEST_ACTIVE 169133
MON$OLDEST_SNAPSHOT 169133
MON$NEXT_TRANSACTION 169133
MON$PAGE_BUFFERS 1000000
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2020-04-03 16:41:55.3470
MON$PAGES 1906144
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: LI-V3.0.12.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0
Database "/home/bases/oltp30-etalone.fdb"
Gstat execution time Wed Feb 28 19:12:19 2024
Database header page information:
Flags 0
Generation 88068
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 166118
Oldest active 169133
Oldest snapshot 169133
Next transaction 169134
Sequence number 0
Next attachment ID 699
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 3, 2020 16:41:55
Attributes force write
Variable header data:
Sweep interval: 0
Unrecognized option 11, length 16
*END*
Database file sequence:
File /home/bases/oltp30-etalone.fdb is the only file
Analyzing database pages ...
AGENTS (150)
Primary pointer page: 496, Index root page: 497
Total formats: 1, used formats: 1
Average record length: 33.60, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.20, total dup: 0, max dup: 0
Average key length: 15.88, compression ratio: 0.92
Average prefix length: 1.42, average data length: 13.20
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (154)
Primary pointer page: 504, Index root page: 505
Total formats: 1, used formats: 1
Average record length: 108.20, total records: 20
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1235.00, compression ratio: 11.41
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 18.25, total dup: 0, max dup: 0
Average key length: 17.20, compression ratio: 1.24
Average prefix length: 7.05, average data length: 14.25
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_PREDICT_PRIOR (3)
Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.40, total dup: 0, max dup: 0
Average key length: 4.35, compression ratio: 0.67
Average prefix length: 1.20, average data length: 1.70
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 4.30, total dup: 6, max dup: 3
Average key length: 3.25, compression ratio: 0.72
Average prefix length: 1.35, average data length: 1.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.20, total dup: 0, max dup: 0
Average key length: 4.15, compression ratio: 0.65
Average prefix length: 1.10, average data length: 1.60
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (139)
Primary pointer page: 474, Index root page: 475
Total formats: 1, used formats: 1
Average record length: 47.43, total records: 7661059
Average version length: 48.17, total versions: 74192, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.35
Pointer pages: 54, data page slots: 86656
Data pages: 86656, average fill: 71%
Primary pages: 86656, secondary pages: 0, swept pages: 26174
Empty pages: 7, full pages: 54056
Fill distribution:
0 - 19% = 24
20 - 39% = 228
40 - 59% = 3558
60 - 79% = 82832
80 - 99% = 14
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510614, depth: 3, leaf buckets: 23081, nodes: 7661059
Average node length: 18.85, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 1.70
Average prefix length: 14.14, average data length: 12.86
Clustering factor: 1683588, ratio: 0.22
Fill distribution:
0 - 19% = 314
20 - 39% = 2090
40 - 59% = 3787
60 - 79% = 2605
80 - 99% = 14285
Index DOC_DATA_ID_DESC (1)
Root page: 1528118, depth: 3, leaf buckets: 13405, nodes: 7661059
Average node length: 11.20, total dup: 0, max dup: 0
Average key length: 8.21, compression ratio: 1.10
Average prefix length: 3.78, average data length: 5.22
Clustering factor: 1506602, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1724
40 - 59% = 1797
60 - 79% = 1237
80 - 99% = 8647
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546711, depth: 3, leaf buckets: 8258, nodes: 7661059
Average node length: 6.59, total dup: 5758723, max dup: 49
Average key length: 3.61, compression ratio: 2.50
Average prefix length: 7.64, average data length: 1.36
Clustering factor: 1499810, ratio: 0.20
Fill distribution:
0 - 19% = 113
20 - 39% = 1113
40 - 59% = 1197
60 - 79% = 1017
80 - 99% = 4818
DOC_LIST (138)
Primary pointer page: 472, Index root page: 473
Total formats: 1, used formats: 1
Average record length: 56.37, total records: 2193585
Average version length: 34.90, total versions: 78587, max versions: 3
Average fragment length: 7.75, total fragments: 4, max fragments: 1
Average unpacked length: 84.00, compression ratio: 1.49
Pointer pages: 18, data page slots: 28248
Data pages: 28248, average fill: 72%
Primary pages: 28242, secondary pages: 6, swept pages: 10998
Empty pages: 6, full pages: 17388
Fill distribution:
0 - 19% = 30
20 - 39% = 187
40 - 59% = 2278
60 - 79% = 25232
80 - 99% = 521
Index DOC_LIST_ID_DESC (1)
Root page: 1541130, depth: 3, leaf buckets: 4482, nodes: 2193585
Average node length: 11.41, total dup: 0, max dup: 0
Average key length: 8.45, compression ratio: 1.06
Average prefix length: 3.54, average data length: 5.46
Clustering factor: 686821, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 967
40 - 59% = 749
60 - 79% = 790
80 - 99% = 1976
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544376, depth: 3, leaf buckets: 2510, nodes: 2196193
Average node length: 4.97, total dup: 2195294, max dup: 20816
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1228800, ratio: 0.56
Fill distribution:
0 - 19% = 1
20 - 39% = 333
40 - 59% = 1536
60 - 79% = 472
80 - 99% = 168
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545909, depth: 3, leaf buckets: 2060, nodes: 2193585
Average node length: 4.97, total dup: 2193535, max dup: 130042
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1044008, ratio: 0.48
Fill distribution:
0 - 19% = 8
20 - 39% = 196
40 - 59% = 1013
60 - 79% = 53
80 - 99% = 790
Index PK_DOC_LIST (0)
Root page: 1538187, depth: 3, leaf buckets: 4269, nodes: 2193585
Average node length: 11.41, total dup: 0, max dup: 0
Average key length: 8.45, compression ratio: 1.06
Average prefix length: 3.54, average data length: 5.46
Clustering factor: 686821, ratio: 0.31
Fill distribution:
0 - 19% = 96
20 - 39% = 601
40 - 59% = 561
60 - 79% = 906
80 - 99% = 2105
DOC_STATES (149)
Primary pointer page: 494, Index root page: 495
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (155)
Primary pointer page: 506, Index root page: 507
Total formats: 2, used formats: 2
Average record length: 54.76, total records: 2182
Average version length: 79.61, total versions: 757, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 270.43, compression ratio: 4.94
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 70%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7
80 - 99% = 26
Index FB_ERRORS_GDS_CODE (0)
Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182
Average node length: 4.40, total dup: 756, max dup: 1
Average key length: 2.67, compression ratio: 1.87
Average prefix length: 4.33, average data length: 0.67
Clustering factor: 1515, ratio: 0.69
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
INVNT_SALDO (145)
Primary pointer page: 486, Index root page: 487
Total formats: 2, used formats: 1
Average record length: 82.56, total records: 400
Average version length: 23.00, total versions: 236691, max versions: 615
Average fragment length: 2.00, total fragments: 39, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.26
Pointer pages: 1, data page slots: 1304
Data pages: 1304, average fill: 90%
Primary pages: 11, secondary pages: 1293, swept pages: 0
Empty pages: 4, full pages: 1299
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 1298
Index PK_INVNT_SALDO (0)
Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 326, ratio: 0.81
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (153)
Primary pointer page: 502, Index root page: 503
Total formats: 1, used formats: 1
Average record length: 21.34, total records: 139002
Average version length: 68.28, total versions: 95576, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 4.12
Pointer pages: 6, data page slots: 2592
Data pages: 2384, average fill: 70%
Primary pages: 2383, secondary pages: 1, swept pages: 0
Empty pages: 283, full pages: 1657
Fill distribution:
0 - 19% = 346
20 - 39% = 28
40 - 59% = 129
60 - 79% = 663
80 - 99% = 1218
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1899610, depth: 3, leaf buckets: 392, nodes: 139002
Average node length: 12.91, total dup: 12723, max dup: 2
Average key length: 10.42, compression ratio: 2.59
Average prefix length: 19.49, average data length: 7.51
Clustering factor: 102210, ratio: 0.74
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 274
60 - 79% = 106
80 - 99% = 10
MONEY_SALDO (141)
Primary pointer page: 478, Index root page: 479
Total formats: 1, used formats: 1
Average record length: 15.27, total records: 49
Average version length: 9.00, total versions: 17696, max versions: 938
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: 64
Data pages: 64, average fill: 89%
Primary pages: 2, secondary pages: 62, swept pages: 0
Empty pages: 1, full pages: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2
80 - 99% = 60
Index PK_MONEY_SALDO (0)
Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (140)
Primary pointer page: 476, Index root page: 477
Total formats: 1, used formats: 1
Average record length: 8.41, total records: 2419
Average version length: 43.31, total versions: 1971, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 6.90
Pointer pages: 1, data page slots: 88
Data pages: 31, average fill: 72%
Primary pages: 30, secondary pages: 1, swept pages: 2
Empty pages: 3, full pages: 22
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 3
60 - 79% = 5
80 - 99% = 19
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 90163, depth: 2, leaf buckets: 3, nodes: 2419
Average node length: 4.11, total dup: 2321, max dup: 294
Average key length: 2.43, compression ratio: 7.82
Average prefix length: 18.61, average data length: 0.39
Clustering factor: 1213, ratio: 0.50
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
MON_CACHE_MEMORY (165)
Primary pointer page: 526, Index root page: 527
Total formats: 2, used formats: 1
Average record length: 97.03, total records: 72
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 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: 1504215, depth: 1, leaf buckets: 1, nodes: 72
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 10.68, compression ratio: 0.84
Average prefix length: 1.31, average data length: 7.69
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 520, Index root page: 521
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (163)
Primary pointer page: 522, Index root page: 523
Total formats: 2, used formats: 1
Average record length: 67.13, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 611.00, compression ratio: 9.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.50, total dup: 23, max dup: 4
Average key length: 2.47, compression ratio: 3.24
Average prefix length: 7.53, average data length: 0.47
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 2.00, total dup: 29, max dup: 29
Average key length: 1.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.33, total dup: 29, max dup: 29
Average key length: 2.30, compression ratio: 3.91
Average prefix length: 8.70, average data length: 0.30
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 12.90, total dup: 0, max dup: 0
Average key length: 11.87, compression ratio: 1.42
Average prefix length: 7.63, average data length: 9.20
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 8.37, total dup: 0, max dup: 0
Average key length: 7.33, compression ratio: 1.23
Average prefix length: 4.63, average data length: 4.37
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (136)
Primary pointer page: 468, Index root page: 469
Total formats: 2, used formats: 1
Average record length: 67.56, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 386.00, compression ratio: 5.71
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (146)
Primary pointer page: 488, Index root page: 489
Total formats: 1, used formats: 1
Average record length: 36.10, total records: 867526
Average version length: 25.49, total versions: 73479, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.50
Pointer pages: 6, data page slots: 8480
Data pages: 8480, average fill: 71%
Primary pages: 8462, secondary pages: 18, swept pages: 1467
Empty pages: 10, full pages: 7617
Fill distribution:
0 - 19% = 16
20 - 39% = 18
40 - 59% = 106
60 - 79% = 8060
80 - 99% = 280
Index PDISTR_AGENT_ID (2)
Root page: 1509308, depth: 2, leaf buckets: 958, nodes: 867526
Average node length: 4.88, total dup: 867477, max dup: 172019
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 93532, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 137
40 - 59% = 537
60 - 79% = 222
80 - 99% = 61
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508613, depth: 3, leaf buckets: 1062, nodes: 867526
Average node length: 5.89, total dup: 772333, max dup: 42
Average key length: 3.02, compression ratio: 7.28
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 171198, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 68
40 - 59% = 647
60 - 79% = 120
80 - 99% = 226
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509187, depth: 3, leaf buckets: 1093, nodes: 867526
Average node length: 5.89, total dup: 772333, max dup: 42
Average key length: 3.02, compression ratio: 7.28
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 173106, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 176
40 - 59% = 576
60 - 79% = 105
80 - 99% = 236
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510178, depth: 3, leaf buckets: 1212, nodes: 867526
Average node length: 5.97, total dup: 772333, max dup: 42
Average key length: 3.10, compression ratio: 5.48
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 165152, ratio: 0.19
Fill distribution:
0 - 19% = 6
20 - 39% = 242
40 - 59% = 638
60 - 79% = 219
80 - 99% = 107
PERF_AGG (158)
Primary pointer page: 512, Index root page: 513
Total formats: 1, used formats: 1
Average record length: 62.82, total records: 5437
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 2.60, total fragments: 62, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.03
Pointer pages: 1, data page slots: 96
Data pages: 94, average fill: 57%
Primary pages: 71, secondary pages: 23, swept pages: 53
Empty pages: 12, full pages: 63
Fill distribution:
0 - 19% = 23
20 - 39% = 1
40 - 59% = 0
60 - 79% = 70
80 - 99% = 0
Index PERF_AGG_UNQ (1)
Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5437
Average node length: 5.49, total dup: 0, max dup: 0
Average key length: 3.59, compression ratio: 10.02
Average prefix length: 34.39, average data length: 1.55
Clustering factor: 5066, ratio: 0.93
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 1
80 - 99% = 1
Index PK_PERF_AGG (0)
Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5437
Average node length: 11.11, total dup: 0, max dup: 0
Average key length: 9.21, compression ratio: 0.98
Average prefix length: 2.79, average data length: 6.21
Clustering factor: 148, 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: 1504218, Index root page: 1504219
Total formats: 1, used formats: 1
Average record length: 39.10, total records: 77242
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: 752
Data pages: 752, average fill: 71%
Primary pages: 752, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 744
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 744
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 37167, depth: 2, leaf buckets: 98, nodes: 77242
Average node length: 10.18, total dup: 0, max dup: 0
Average key length: 8.19, compression ratio: 1.10
Average prefix length: 3.81, average data length: 5.19
Clustering factor: 2894, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 97
PERF_ISQL_STAT (156)
Primary pointer page: 508, Index root page: 509
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (159)
Primary pointer page: 514, Index root page: 515
Total formats: 1, used formats: 1
Average record length: 110.57, total records: 72
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1691.00, compression ratio: 15.29
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: 573, Index root page: 574
Total formats: 1, used formats: 1
Average record length: 141.01, total records: 180427
Average version length: 154.65, total versions: 11750, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.03
Pointer pages: 5, data page slots: 5960
Data pages: 4448, average fill: 84%
Primary pages: 4448, secondary pages: 0, swept pages: 3
Empty pages: 144, full pages: 4253
Fill distribution:
0 - 19% = 147
20 - 39% = 23
40 - 59% = 14
60 - 79% = 10
80 - 99% = 4254
PERF_SPLIT_1 (282)
Primary pointer page: 576, Index root page: 577
Total formats: 1, used formats: 1
Average record length: 137.65, total records: 165371
Average version length: 154.44, total versions: 14256, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.32
Pointer pages: 7, data page slots: 4984
Data pages: 3968, average fill: 86%
Primary pages: 3968, secondary pages: 0, swept pages: 2
Empty pages: 46, full pages: 3912
Fill distribution:
0 - 19% = 49
20 - 39% = 3
40 - 59% = 1
60 - 79% = 4
80 - 99% = 3911
PERF_SPLIT_2 (283)
Primary pointer page: 578, Index root page: 579
Total formats: 1, used formats: 1
Average record length: 148.30, total records: 168844
Average version length: 151.66, total versions: 2975, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.44
Pointer pages: 5, data page slots: 4760
Data pages: 4096, average fill: 85%
Primary pages: 4096, secondary pages: 0, swept pages: 4
Empty pages: 84, full pages: 3987
Fill distribution:
0 - 19% = 86
20 - 39% = 9
40 - 59% = 6
60 - 79% = 10
80 - 99% = 3985
PERF_SPLIT_3 (284)
Primary pointer page: 580, Index root page: 581
Total formats: 1, used formats: 1
Average record length: 127.83, total records: 191095
Average version length: 154.88, total versions: 29302, 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: 6576
Data pages: 4624, average fill: 87%
Primary pages: 4624, secondary pages: 0, swept pages: 4
Empty pages: 67, full pages: 4530
Fill distribution:
0 - 19% = 71
20 - 39% = 9
40 - 59% = 6
60 - 79% = 9
80 - 99% = 4529
PERF_SPLIT_4 (285)
Primary pointer page: 582, Index root page: 583
Total formats: 1, used formats: 1
Average record length: 129.74, total records: 184752
Average version length: 154.90, total versions: 26314, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.07
Pointer pages: 7, data page slots: 6488
Data pages: 4472, average fill: 87%
Primary pages: 4472, secondary pages: 0, swept pages: 3
Empty pages: 58, full pages: 4384
Fill distribution:
0 - 19% = 62
20 - 39% = 7
40 - 59% = 9
60 - 79% = 10
80 - 99% = 4384
PERF_SPLIT_5 (286)
Primary pointer page: 584, Index root page: 585
Total formats: 1, used formats: 1
Average record length: 144.74, total records: 181828
Average version length: 153.31, total versions: 7704, 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: 8, data page slots: 7552
Data pages: 4408, average fill: 85%
Primary pages: 4408, secondary pages: 0, swept pages: 2
Empty pages: 82, full pages: 4300
Fill distribution:
0 - 19% = 84
20 - 39% = 10
40 - 59% = 9
60 - 79% = 4
80 - 99% = 4301
PERF_SPLIT_6 (287)
Primary pointer page: 586, Index root page: 587
Total formats: 1, used formats: 1
Average record length: 147.17, total records: 178395
Average version length: 151.54, total versions: 4623, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.52
Pointer pages: 6, data page slots: 5376
Data pages: 4280, average fill: 86%
Primary pages: 4280, secondary pages: 0, swept pages: 6
Empty pages: 43, full pages: 4221
Fill distribution:
0 - 19% = 47
20 - 39% = 4
40 - 59% = 4
60 - 79% = 3
80 - 99% = 4222
PERF_SPLIT_7 (288)
Primary pointer page: 588, Index root page: 589
Total formats: 1, used formats: 1
Average record length: 124.15, total records: 198319
Average version length: 155.16, total versions: 34886, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.66
Pointer pages: 8, data page slots: 6808
Data pages: 4824, average fill: 86%
Primary pages: 4824, secondary pages: 0, swept pages: 2
Empty pages: 80, full pages: 4675
Fill distribution:
0 - 19% = 82
20 - 39% = 7
40 - 59% = 47
60 - 79% = 13
80 - 99% = 4675
PERF_SPLIT_8 (289)
Primary pointer page: 590, Index root page: 591
Total formats: 1, used formats: 1
Average record length: 148.13, total records: 181105
Average version length: 152.34, total versions: 3811, 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: 6200
Data pages: 4392, average fill: 85%
Primary pages: 4392, secondary pages: 0, swept pages: 4
Empty pages: 81, full pages: 4284
Fill distribution:
0 - 19% = 82
20 - 39% = 12
40 - 59% = 5
60 - 79% = 11
80 - 99% = 4282
PERF_SPLIT_9 (290)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 150.65, total records: 178727
Average version length: 142.20, total versions: 681, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.26
Pointer pages: 6, data page slots: 4416
Data pages: 4272, average fill: 86%
Primary pages: 4271, secondary pages: 1, swept pages: 6
Empty pages: 25, full pages: 4232
Fill distribution:
0 - 19% = 28
20 - 39% = 3
40 - 59% = 6
60 - 79% = 5
80 - 99% = 4230
PHRASES (143)
Primary pointer page: 482, Index root page: 483
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (147)
Primary pointer page: 490, Index root page: 491
Total formats: 1, used formats: 1
Average record length: 51.81, total records: 2039636
Average version length: 52.96, total versions: 36134, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 70.00, compression ratio: 1.35
Pointer pages: 16, data page slots: 25424
Data pages: 25424, average fill: 69%
Primary pages: 25424, secondary pages: 0, swept pages: 12473
Empty pages: 412, full pages: 18610
Fill distribution:
0 - 19% = 787
20 - 39% = 630
40 - 59% = 1700
60 - 79% = 22011
80 - 99% = 296
Index PSTORNED_RCV_ID (1)
Root page: 1506186, depth: 3, leaf buckets: 2543, nodes: 2039636
Average node length: 5.44, total dup: 1902099, max dup: 1405
Average key length: 2.49, compression ratio: 3.61
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 177837, ratio: 0.09
Fill distribution:
0 - 19% = 8
20 - 39% = 356
40 - 59% = 1610
60 - 79% = 272
80 - 99% = 297
Index PSTORNED_SND_ID (0)
Root page: 1504819, depth: 3, leaf buckets: 2751, nodes: 2039636
Average node length: 5.70, total dup: 1829468, max dup: 64
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 365689, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 17
40 - 59% = 2511
60 - 79% = 199
80 - 99% = 24
Index PSTORNED_WORKER_ID (2)
Root page: 1507996, depth: 3, leaf buckets: 2114, nodes: 2039636
Average node length: 4.96, total dup: 2039536, max dup: 28394
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 175698, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 227
40 - 59% = 1122
60 - 79% = 391
80 - 99% = 372
RULES_FOR_PDISTR (148)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 470, Index root page: 471
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 466, Index root page: 467
Total formats: 1, used formats: 1
Average record length: 97.63, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 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: 525, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 454, Index root page: 455
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 460, Index root page: 461
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 462, Index root page: 463
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 464, Index root page: 465
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 518, Index root page: 519
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 516, Index root page: 517
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 458, Index root page: 459
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 456, Index root page: 457
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 452, Index root page: 453
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 510, Index root page: 511
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 549, Index root page: 550
Total formats: 1, used formats: 1
Average record length: 41.44, total records: 151518
Average version length: 69.14, total versions: 60795, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.04
Pointer pages: 3, data page slots: 3600
Data pages: 2991, average fill: 59%
Primary pages: 2991, secondary pages: 0, swept pages: 358
Empty pages: 373, full pages: 1753
Fill distribution:
0 - 19% = 561
20 - 39% = 308
40 - 59% = 277
60 - 79% = 643
80 - 99% = 1202
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 104734, depth: 3, leaf buckets: 232, nodes: 151518
Average node length: 6.43, total dup: 131810, max dup: 14
Average key length: 3.95, compression ratio: 10.64
Average prefix length: 40.18, average data length: 1.82
Clustering factor: 25941, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 46
40 - 59% = 119
60 - 79% = 61
80 - 99% = 6
XQD_1000_3300 (178)
Primary pointer page: 553, Index root page: 554
Total formats: 1, used formats: 1
Average record length: 65.64, total records: 7384922
Average version length: 68.76, total versions: 355133, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.92
Pointer pages: 66, data page slots: 106168
Data pages: 106168, average fill: 74%
Primary pages: 106168, secondary pages: 0, swept pages: 30045
Empty pages: 21, full pages: 82943
Fill distribution:
0 - 19% = 143
20 - 39% = 888
40 - 59% = 5512
60 - 79% = 94312
80 - 99% = 5313
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480454, depth: 3, leaf buckets: 10772, nodes: 7384922
Average node length: 6.51, total dup: 6388694, max dup: 29
Average key length: 3.52, compression ratio: 11.94
Average prefix length: 40.62, average data length: 1.38
Clustering factor: 1624276, ratio: 0.22
Fill distribution:
0 - 19% = 9
20 - 39% = 1263
40 - 59% = 5738
60 - 79% = 3118
80 - 99% = 644
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486068, depth: 3, leaf buckets: 8864, nodes: 7384922
Average node length: 5.39, total dup: 7098234, max dup: 175
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1413673, ratio: 0.19
Fill distribution:
0 - 19% = 6
20 - 39% = 1213
40 - 59% = 4895
60 - 79% = 1729
80 - 99% = 1021
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490608, depth: 3, leaf buckets: 8891, nodes: 7384922
Average node length: 5.39, total dup: 7098234, max dup: 175
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1416206, ratio: 0.19
Fill distribution:
0 - 19% = 8
20 - 39% = 1190
40 - 59% = 4910
60 - 79% = 1747
80 - 99% = 1036
XQD_1200_2000 (177)
Primary pointer page: 551, Index root page: 552
Total formats: 1, used formats: 1
Average record length: 67.41, total records: 12381883
Average version length: 68.70, total versions: 276146, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.87
Pointer pages: 106, data page slots: 171792
Data pages: 171792, average fill: 76%
Primary pages: 171792, secondary pages: 0, swept pages: 81873
Empty pages: 6, full pages: 160394
Fill distribution:
0 - 19% = 34
20 - 39% = 337
40 - 59% = 2758
60 - 79% = 163490
80 - 99% = 5173
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495028, depth: 3, leaf buckets: 18448, nodes: 12381883
Average node length: 6.60, total dup: 10791350, max dup: 73
Average key length: 3.43, compression ratio: 12.26
Average prefix length: 40.70, average data length: 1.30
Clustering factor: 2407589, ratio: 0.19
Fill distribution:
0 - 19% = 22
20 - 39% = 2047
40 - 59% = 10427
60 - 79% = 4960
80 - 99% = 992
XQD_2000_3300 (179)
Primary pointer page: 555, Index root page: 556
Total formats: 1, used formats: 1
Average record length: 46.36, total records: 1404490
Average version length: 69.10, total versions: 463052, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 2.72
Pointer pages: 26, data page slots: 41208
Data pages: 27790, average fill: 58%
Primary pages: 27788, secondary pages: 2, swept pages: 9319
Empty pages: 3858, full pages: 15625
Fill distribution:
0 - 19% = 5988
20 - 39% = 2560
40 - 59% = 2099
60 - 79% = 10210
80 - 99% = 6933
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479712, depth: 3, leaf buckets: 2120, nodes: 1404490
Average node length: 5.53, total dup: 1347555, max dup: 99
Average key length: 2.57, compression ratio: 16.33
Average prefix length: 41.47, average data length: 0.53
Clustering factor: 92854, ratio: 0.07
Fill distribution:
0 - 19% = 7
20 - 39% = 829
40 - 59% = 922
60 - 79% = 318
80 - 99% = 44
XQD_2100_3300 (180)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 1
Average record length: 40.92, total records: 1089151
Average version length: 69.13, total versions: 443268, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.08
Pointer pages: 20, data page slots: 31224
Data pages: 26024, average fill: 49%
Primary pages: 26024, secondary pages: 0, swept pages: 5954
Empty pages: 4008, full pages: 9584
Fill distribution:
0 - 19% = 7785
20 - 39% = 2571
40 - 59% = 2849
60 - 79% = 6465
80 - 99% = 6354
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479207, depth: 3, leaf buckets: 1607, nodes: 1089151
Average node length: 5.77, total dup: 1018754, max dup: 99
Average key length: 2.83, compression ratio: 14.82
Average prefix length: 41.23, average data length: 0.77
Clustering factor: 155681, ratio: 0.14
Fill distribution:
0 - 19% = 2
20 - 39% = 513
40 - 59% = 722
60 - 79% = 319
80 - 99% = 51
XQD_3300_3400 (181)
Primary pointer page: 559, Index root page: 560
Total formats: 1, used formats: 1
Average record length: 65.68, total records: 8832465
Average version length: 69.00, total versions: 410997, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.92
Pointer pages: 88, data page slots: 142672
Data pages: 142656, average fill: 66%
Primary pages: 142656, secondary pages: 0, swept pages: 60611
Empty pages: 355, full pages: 63329
Fill distribution:
0 - 19% = 1346
20 - 39% = 7653
40 - 59% = 28600
60 - 79% = 99972
80 - 99% = 5085
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472590, depth: 3, leaf buckets: 13442, nodes: 8832465
Average node length: 6.68, total dup: 7325614, max dup: 19
Average key length: 3.67, compression ratio: 11.44
Average prefix length: 40.50, average data length: 1.50
Clustering factor: 1890676, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 1569
40 - 59% = 7329
60 - 79% = 4145
80 - 99% = 398
XQS_1000_1200 (182)
Primary pointer page: 561, Index root page: 562
Total formats: 1, used formats: 1
Average record length: 82.51, total records: 21107020
Average version length: 82.92, total versions: 7320, 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: 195, data page slots: 318208
Data pages: 318208, average fill: 81%
Primary pages: 318208, secondary pages: 0, swept pages: 12523
Empty pages: 40, full pages: 317133
Fill distribution:
0 - 19% = 72
20 - 39% = 62
40 - 59% = 143
60 - 79% = 27659
80 - 99% = 290272
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426716, depth: 3, leaf buckets: 19387, nodes: 21107020
Average node length: 5.72, total dup: 20626767, max dup: 128
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3273373, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 8196
60 - 79% = 578
80 - 99% = 10607
Index XQS_1000_1200_RCV_ID (3)
Root page: 1456980, depth: 3, leaf buckets: 17136, nodes: 21107020
Average node length: 6.31, total dup: 18548808, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 911467, ratio: 0.04
Fill distribution:
0 - 19% = 6
20 - 39% = 3
40 - 59% = 768
60 - 79% = 289
80 - 99% = 16070
Index XQS_1000_1200_SND_ID (2)
Root page: 1441073, depth: 3, leaf buckets: 21132, nodes: 21107020
Average node length: 6.34, total dup: 18467643, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3567386, ratio: 0.17
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 8407
60 - 79% = 602
80 - 99% = 12115
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413348, depth: 3, leaf buckets: 16050, nodes: 21107020
Average node length: 5.56, total dup: 21106920, max dup: 230497
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 940295, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 11
40 - 59% = 2825
60 - 79% = 407
80 - 99% = 12806
XQS_1000_3300 (184)
Primary pointer page: 565, Index root page: 566
Total formats: 1, used formats: 1
Average record length: 79.11, total records: 9235556
Average version length: 82.65, total versions: 367880, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.59
Pointer pages: 104, data page slots: 169704
Data pages: 169664, average fill: 67%
Primary pages: 169664, secondary pages: 0, swept pages: 85175
Empty pages: 836, full pages: 80548
Fill distribution:
0 - 19% = 2385
20 - 39% = 9892
40 - 59% = 33454
60 - 79% = 76626
80 - 99% = 47307
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367502, depth: 3, leaf buckets: 11327, nodes: 9235556
Average node length: 5.37, total dup: 8931117, max dup: 184
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 2026083, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 133
40 - 59% = 9213
60 - 79% = 1955
80 - 99% = 23
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379261, depth: 3, leaf buckets: 13148, nodes: 9235556
Average node length: 6.23, total dup: 7654789, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1394641, ratio: 0.15
Fill distribution:
0 - 19% = 126
20 - 39% = 4140
40 - 59% = 4144
60 - 79% = 2533
80 - 99% = 2205
Index XQS_1000_3300_SND_ID (2)
Root page: 1373059, depth: 3, leaf buckets: 12651, nodes: 9235556
Average node length: 5.99, total dup: 8001743, max dup: 38
Average key length: 2.86, compression ratio: 3.15
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 2206297, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 171
40 - 59% = 10275
60 - 79% = 2167
80 - 99% = 37
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362767, depth: 3, leaf buckets: 9793, nodes: 9235556
Average node length: 5.13, total dup: 9235456, max dup: 162882
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1438290, ratio: 0.16
Fill distribution:
0 - 19% = 53
20 - 39% = 1340
40 - 59% = 4862
60 - 79% = 1573
80 - 99% = 1965
XQS_1200_2000 (183)
Primary pointer page: 563, Index root page: 564
Total formats: 1, used formats: 1
Average record length: 80.16, total records: 10844749
Average version length: 82.63, total versions: 279444, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.57
Pointer pages: 117, data page slots: 190888
Data pages: 189104, average fill: 70%
Primary pages: 189104, secondary pages: 0, swept pages: 82829
Empty pages: 4031, full pages: 129152
Fill distribution:
0 - 19% = 6979
20 - 39% = 9890
40 - 59% = 21941
60 - 79% = 46646
80 - 99% = 103648
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392101, depth: 3, leaf buckets: 13117, nodes: 10844749
Average node length: 5.30, total dup: 10735833, max dup: 634
Average key length: 2.08, compression ratio: 4.32
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2247527, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 343
40 - 59% = 9946
60 - 79% = 2763
80 - 99% = 65
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406110, depth: 3, leaf buckets: 10140, nodes: 10844749
Average node length: 5.49, total dup: 10369743, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 668680, ratio: 0.06
Fill distribution:
0 - 19% = 169
20 - 39% = 927
40 - 59% = 2484
60 - 79% = 1811
80 - 99% = 4749
Index XQS_1200_2000_SND_ID (2)
Root page: 1398638, depth: 3, leaf buckets: 15010, nodes: 10844749
Average node length: 6.03, total dup: 9451671, max dup: 58
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 2263881, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 461
40 - 59% = 11446
60 - 79% = 3035
80 - 99% = 66
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386211, depth: 3, leaf buckets: 10391, nodes: 10844749
Average node length: 5.22, total dup: 10844649, max dup: 212506
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 659059, ratio: 0.06
Fill distribution:
0 - 19% = 109
20 - 39% = 874
40 - 59% = 4527
60 - 79% = 1526
80 - 99% = 3355
XQS_2000_3300 (185)
Primary pointer page: 567, Index root page: 568
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (1)
Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (3)
Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (2)
Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_WORKER_ID (0)
Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (186)
Primary pointer page: 569, Index root page: 570
Total formats: 1, used formats: 1
Average record length: 79.60, total records: 9329512
Average version length: 82.92, total versions: 351528, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.58
Pointer pages: 106, data page slots: 172880
Data pages: 172808, average fill: 67%
Primary pages: 172808, secondary pages: 0, swept pages: 90253
Empty pages: 865, full pages: 79126
Fill distribution:
0 - 19% = 2524
20 - 39% = 10148
40 - 59% = 35032
60 - 79% = 80062
80 - 99% = 45042
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344686, depth: 3, leaf buckets: 11492, nodes: 9329512
Average node length: 5.18, total dup: 9301413, max dup: 1500
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 1845143, ratio: 0.20
Fill distribution:
0 - 19% = 36
20 - 39% = 1736
40 - 59% = 7477
60 - 79% = 1716
80 - 99% = 527
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355717, depth: 3, leaf buckets: 13250, nodes: 9329512
Average node length: 6.25, total dup: 7732142, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1365345, ratio: 0.15
Fill distribution:
0 - 19% = 178
20 - 39% = 4123
40 - 59% = 4078
60 - 79% = 2563
80 - 99% = 2308
Index XQS_2100_3300_SND_ID (2)
Root page: 1350049, depth: 3, leaf buckets: 12057, nodes: 9329512
Average node length: 5.43, total dup: 8907929, max dup: 93
Average key length: 2.29, compression ratio: 3.93
Average prefix length: 8.76, average data length: 0.24
Clustering factor: 1972947, ratio: 0.21
Fill distribution:
0 - 19% = 27
20 - 39% = 1593
40 - 59% = 8345
60 - 79% = 1577
80 - 99% = 515
Index XQS_2100_3300_WORKER_ID (0)
Root page: 985805, depth: 3, leaf buckets: 9926, nodes: 9329512
Average node length: 5.15, total dup: 9329412, max dup: 165578
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1459537, ratio: 0.16
Fill distribution:
0 - 19% = 41
20 - 39% = 1379
40 - 59% = 4963
60 - 79% = 1608
80 - 99% = 1935
XQS_3300_3400 (187)
Primary pointer page: 571, Index root page: 572
Total formats: 1, used formats: 1
Average record length: 67.52, total records: 561836
Average version length: 68.85, total versions: 5320, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.87
Pointer pages: 5, data page slots: 7976
Data pages: 7976, average fill: 74%
Primary pages: 7976, secondary pages: 0, swept pages: 4410
Empty pages: 7, full pages: 5939
Fill distribution:
0 - 19% = 12
20 - 39% = 44
40 - 59% = 460
60 - 79% = 7377
80 - 99% = 83
Index XQS_3300_3400_DOC_ID (1)
Root page: 44449, depth: 3, leaf buckets: 739, nodes: 561836
Average node length: 5.95, total dup: 478076, max dup: 83
Average key length: 3.10, compression ratio: 2.91
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 98015, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 38
40 - 59% = 542
60 - 79% = 75
80 - 99% = 83
Index XQS_3300_3400_SND_ID (2)
Root page: 33326, depth: 3, leaf buckets: 757, nodes: 561836
Average node length: 6.15, total dup: 460622, max dup: 14
Average key length: 3.30, compression ratio: 2.73
Average prefix length: 7.88, average data length: 1.12
Clustering factor: 98059, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 46
40 - 59% = 537
60 - 79% = 77
80 - 99% = 95
Index XQS_3300_3400_WORKER_ID (0)
Root page: 375548, depth: 2, leaf buckets: 573, nodes: 561836
Average node length: 4.85, total dup: 561736, max dup: 9794
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 87107, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 48
40 - 59% = 329
60 - 79% = 102
80 - 99% = 94
ZDOC_DATA (170)
Primary pointer page: 537, Index root page: 538
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (169)
Primary pointer page: 535, Index root page: 536
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (171)
Primary pointer page: 539, Index root page: 540
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (174)
Primary pointer page: 545, Index root page: 546
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (175)
Primary pointer page: 547, Index root page: 548
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (172)
Primary pointer page: 541, Index root page: 542
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (173)
Primary pointer page: 543, Index root page: 544
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (168)
Primary pointer page: 533, Index root page: 534
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (167)
Primary pointer page: 531, Index root page: 532
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (144)
Primary pointer page: 484, Index root page: 485
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Wed Feb 28 19:12:43 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7661059 |
74192 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2193585 |
78587 |
3 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
236691 |
615 |
59100.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
139002 |
95576 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
17696 |
938 |
36100.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
2419 |
1971 |
1 |
0.0000 |
0.0000 |
PDISTR |
867526 |
73479 |
5 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
180427 |
11750 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
165371 |
14256 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
168844 |
2975 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
191095 |
29302 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
184752 |
26314 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
181828 |
7704 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
178395 |
4623 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
198319 |
34886 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
181105 |
3811 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
178727 |
681 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2039636 |
36134 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
151518 |
60795 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7384922 |
355133 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12381883 |
276146 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1404490 |
463052 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1089151 |
443268 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
8832465 |
410997 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21107020 |
7320 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9235556 |
367880 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
10844749 |
279444 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
9329512 |
351528 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
561836 |
5320 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:1293:
:1294: mscs-test-161.budzdorov.ru Wed Feb 28 19:09:55 2024
:1295: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1296:
:1297:
:1298: mscs-test-161.budzdorov.ru Wed Feb 28 19:09:58 2024
:1299: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1300:
:1301:
:1302: mscs-test-161.budzdorov.ru Wed Feb 28 19:10:00 2024
:1303: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1304:
--- end of diff output ---
28.02.24 19:12:54. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
335544321 'string truncation'. Attempt to assign too long text into string variable.
335544347 'not_valid'. Validation error for column.
335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT |
ERRORS_RESULT |
2024-02-28 19:12:57 |
No severe PSQL-related problems occured |
28.02.24 19:12:58. End of report.