Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.03.2024 16:13
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 | 15660088 kB |
MemAvailable | 30275056 kB |
Buffers | 0 kB |
Cached | 16090128 kB |
SwapCached | 2580 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-03-20 16:12:18
DTS_END 2024-03-20 16:12:18.7720
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/56368
TRN_ID 178175
ATT_ID 619
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: |
9269.61 |
22069 |
926961 |
customer order: creation |
180.57 |
342 |
18057 |
customer order: refuse |
15.42 |
429 |
1542 |
order to supplier: creation |
48.67 |
1215 |
4867 |
order to supplier: removal |
3.38 |
109000 |
338 |
invoice (draft): creation |
48.21 |
3159 |
4821 |
invoice (draft): removal |
50.08 |
832 |
5008 |
invoice accept: apply |
43.43 |
22286 |
4343 |
invoice accept: cancel |
44.59 |
907 |
4459 |
customer reserve: creation |
4129.59 |
215 |
412959 |
customer reserve: removal |
4399.32 |
65 |
439932 |
realization accept: apply |
87.05 |
221 |
8705 |
realization accept: cancel |
81.67 |
137 |
8167 |
payment from customer: creation |
62.86 |
115 |
6286 |
payment from customer: removal |
5.67 |
99 |
567 |
payment to supplier: creation |
52.24 |
138 |
5224 |
payment to supplier: removal |
3.68 |
102 |
368 |
service: total inventory turnovers |
5.48 |
1040 |
548 |
service: total monetary turnovers |
6.99 |
33 |
699 |
service: aggregate perf. data |
0.68 |
28811 |
68 |
service: refresh index statistics |
0.03 |
272227 |
3 |
Completed "Performance in TOTAL". Done for 00:00:03, from 20-03-2024 16:13:39 to 20-03-2024 16:13:42.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
6294 |
TEST_TIME |
2 |
6363 |
TEST_TIME |
3 |
5593 |
TEST_TIME |
4 |
5677 |
TEST_TIME |
5 |
5386 |
TEST_TIME |
6 |
5940 |
TEST_TIME |
7 |
6014 |
TEST_TIME |
8 |
6125 |
TEST_TIME |
9 |
6072 |
TEST_TIME |
10 |
6178 |
TEST_TIME |
11 |
6636 |
TEST_TIME |
12 |
6667 |
TEST_TIME |
13 |
6679 |
TEST_TIME |
14 |
6871 |
TEST_TIME |
15 |
6732 |
TEST_TIME |
16 |
6913 |
TEST_TIME |
17 |
6934 |
TEST_TIME |
18 |
6930 |
TEST_TIME |
19 |
7190 |
TEST_TIME |
20 |
7441 |
TEST_TIME |
21 |
7724 |
TEST_TIME |
22 |
7930 |
TEST_TIME |
23 |
7947 |
TEST_TIME |
24 |
8320 |
TEST_TIME |
25 |
8393 |
TEST_TIME |
26 |
8248 |
TEST_TIME |
27 |
8432 |
TEST_TIME |
28 |
8458 |
TEST_TIME |
29 |
9058 |
TEST_TIME |
30 |
9583 |
TEST_TIME |
31 |
9634 |
TEST_TIME |
32 |
9496 |
TEST_TIME |
33 |
9339 |
TEST_TIME |
34 |
9475 |
TEST_TIME |
35 |
9608 |
TEST_TIME |
36 |
9556 |
TEST_TIME |
37 |
9437 |
TEST_TIME |
38 |
9219 |
TEST_TIME |
39 |
9334 |
TEST_TIME |
40 |
9284 |
TEST_TIME |
41 |
9291 |
TEST_TIME |
42 |
9207 |
TEST_TIME |
43 |
9245 |
TEST_TIME |
44 |
9219 |
TEST_TIME |
45 |
9243 |
TEST_TIME |
46 |
9238 |
TEST_TIME |
47 |
9211 |
TEST_TIME |
48 |
9111 |
TEST_TIME |
49 |
9097 |
TEST_TIME |
50 |
9163 |
TEST_TIME |
51 |
9105 |
TEST_TIME |
52 |
8973 |
TEST_TIME |
53 |
9215 |
TEST_TIME |
54 |
9409 |
TEST_TIME |
55 |
9327 |
TEST_TIME |
56 |
9421 |
TEST_TIME |
57 |
9402 |
TEST_TIME |
58 |
9473 |
TEST_TIME |
59 |
9482 |
TEST_TIME |
60 |
9461 |
TEST_TIME |
61 |
9391 |
TEST_TIME |
62 |
9565 |
TEST_TIME |
63 |
9518 |
TEST_TIME |
64 |
9593 |
TEST_TIME |
65 |
9621 |
TEST_TIME |
66 |
9621 |
TEST_TIME |
67 |
9485 |
TEST_TIME |
68 |
9478 |
TEST_TIME |
69 |
9431 |
TEST_TIME |
70 |
9364 |
TEST_TIME |
71 |
9332 |
TEST_TIME |
72 |
9317 |
TEST_TIME |
73 |
9343 |
TEST_TIME |
74 |
9277 |
TEST_TIME |
75 |
9293 |
TEST_TIME |
76 |
9251 |
TEST_TIME |
77 |
9238 |
TEST_TIME |
78 |
9282 |
TEST_TIME |
79 |
9292 |
TEST_TIME |
80 |
9287 |
TEST_TIME |
81 |
9459 |
TEST_TIME |
82 |
9479 |
TEST_TIME |
83 |
9510 |
TEST_TIME |
84 |
9511 |
TEST_TIME |
85 |
9503 |
TEST_TIME |
86 |
9545 |
TEST_TIME |
87 |
9598 |
TEST_TIME |
88 |
9554 |
TEST_TIME |
89 |
9466 |
TEST_TIME |
90 |
9436 |
TEST_TIME |
91 |
9431 |
TEST_TIME |
92 |
9430 |
TEST_TIME |
93 |
9410 |
TEST_TIME |
94 |
9379 |
TEST_TIME |
95 |
9351 |
TEST_TIME |
96 |
9307 |
TEST_TIME |
97 |
9358 |
TEST_TIME |
98 |
9352 |
TEST_TIME |
99 |
9347 |
TEST_TIME |
100 |
9286 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2024 16:13:43 to 20-03-2024 16:13:46.
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 |
1303005 |
1303005 |
0 |
0.00 |
0 |
20661 |
7 |
0 |
0 |
doc_list_biud |
1303005 |
1303005 |
0 |
0.00 |
0 |
35566 |
28 |
0 |
0 |
sp_add_invoice_to_stock |
4454 |
4343 |
111 |
2.49 |
37 |
198609 |
22286 |
0 |
111 |
sp_cancel_adding_invoice |
4459 |
4459 |
0 |
0.00 |
4 |
45293 |
908 |
0 |
0 |
sp_cancel_client_order |
1542 |
1542 |
0 |
0.00 |
5 |
11337 |
429 |
0 |
0 |
sp_cancel_customer_reserve |
439932 |
439932 |
0 |
0.00 |
0 |
35570 |
66 |
0 |
0 |
sp_cancel_pay_from_customer |
567 |
567 |
0 |
0.00 |
3 |
6028 |
99 |
0 |
0 |
sp_cancel_pay_to_supplier |
368 |
368 |
0 |
0.00 |
2 |
4663 |
102 |
0 |
0 |
sp_cancel_supplier_invoice |
5015 |
5008 |
7 |
0.13 |
2 |
17369 |
832 |
0 |
7 |
sp_cancel_supplier_order |
338 |
338 |
0 |
0.00 |
5 |
1088365 |
109001 |
0 |
0 |
sp_cancel_write_off |
8167 |
8167 |
0 |
0.00 |
1 |
11708 |
138 |
0 |
0 |
sp_client_order |
18057 |
18057 |
0 |
0.00 |
3 |
27527 |
342 |
0 |
0 |
sp_customer_reserve |
412959 |
412959 |
0 |
0.00 |
0 |
48373 |
216 |
0 |
0 |
sp_fill_shopping_cart |
27744 |
27744 |
0 |
0.00 |
1 |
12028 |
36 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
412925 |
412925 |
0 |
0.00 |
0 |
14565 |
15 |
0 |
0 |
sp_get_clo_for_invoice |
4309 |
4309 |
0 |
0.00 |
0 |
40205 |
287 |
0 |
0 |
sp_kill_cost_storno |
13561 |
13561 |
0 |
0.00 |
0 |
6876 |
70 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
893377 |
893377 |
0 |
0.00 |
0 |
35537 |
35 |
0 |
0 |
sp_kill_qty_storno |
472460 |
472460 |
0 |
0.00 |
0 |
35565 |
77 |
0 |
0 |
sp_lock_selected_doc |
18065 |
18065 |
0 |
0.00 |
0 |
7975 |
6 |
0 |
0 |
sp_make_cost_storno |
24524 |
24524 |
0 |
0.00 |
0 |
11969 |
61 |
0 |
0 |
sp_multiply_rows_for_pdistr |
24524 |
24524 |
0 |
0.00 |
0 |
6215 |
31 |
0 |
0 |
sp_multiply_rows_for_qdistr |
18057 |
18057 |
0 |
0.00 |
0 |
11544 |
161 |
0 |
0 |
sp_pay_from_customer |
6286 |
6286 |
0 |
0.00 |
4 |
27416 |
115 |
0 |
0 |
sp_pay_to_supplier |
5224 |
5224 |
0 |
0.00 |
5 |
21996 |
138 |
0 |
0 |
sp_payment_common |
11510 |
11510 |
0 |
0.00 |
1 |
11758 |
26 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1542 |
1542 |
0 |
0.00 |
0 |
11134 |
395 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
8768 |
8768 |
0 |
0.00 |
0 |
15386 |
358 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8705 |
8705 |
0 |
0.00 |
0 |
18862 |
87 |
0 |
0 |
sp_reserve_write_off |
8705 |
8705 |
0 |
0.00 |
6 |
18873 |
222 |
0 |
0 |
sp_supplier_invoice |
4821 |
4821 |
0 |
0.00 |
7 |
70317 |
3160 |
0 |
0 |
sp_supplier_order |
4867 |
4867 |
0 |
0.00 |
6 |
44248 |
1215 |
0 |
0 |
srv_aggregate_perf_data |
68 |
68 |
0 |
0.00 |
1753 |
354070 |
28811 |
0 |
0 |
srv_fill_mon_cache_memory |
58 |
58 |
0 |
0.00 |
1579 |
140053 |
33711 |
0 |
0 |
srv_find_qd_qs_mism |
881514 |
881514 |
0 |
0.00 |
0 |
20653 |
6 |
0 |
0 |
srv_make_invnt_saldo |
548 |
548 |
0 |
0.00 |
36 |
47849 |
1041 |
0 |
0 |
srv_make_money_saldo |
699 |
699 |
0 |
0.00 |
1 |
2763 |
34 |
0 |
0 |
srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
233916 |
313938 |
272227 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
111 |
111 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
7 |
7 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4343 |
4343 |
0 |
0.00 |
0 |
12308 |
212 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
358 |
358 |
0 |
0.00 |
0 |
5331 |
135 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1542 |
1542 |
0 |
0.00 |
0 |
1613 |
10 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
617 |
617 |
0 |
0.00 |
0 |
2719 |
13 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
567 |
567 |
0 |
0.00 |
0 |
506 |
4 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
368 |
368 |
0 |
0.00 |
0 |
922 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
376 |
376 |
0 |
0.00 |
0 |
985 |
20 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
338 |
338 |
0 |
0.00 |
0 |
27139 |
2002 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
885 |
885 |
0 |
0.00 |
0 |
1941 |
11 |
0 |
0 |
t$perf-norm:sp_client_order |
18057 |
18057 |
0 |
0.00 |
0 |
4361 |
17 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
897 |
897 |
0 |
0.00 |
0 |
3118 |
11 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6286 |
6286 |
0 |
0.00 |
0 |
3418 |
11 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5224 |
5224 |
0 |
0.00 |
0 |
2183 |
10 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8705 |
8705 |
0 |
0.00 |
0 |
6212 |
12 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4821 |
4821 |
0 |
0.00 |
0 |
2582 |
20 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4867 |
4867 |
0 |
0.00 |
0 |
6355 |
22 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
68 |
68 |
0 |
0.00 |
0 |
115 |
3 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
58 |
58 |
0 |
0.00 |
0 |
34 |
2 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
548 |
548 |
0 |
0.00 |
0 |
1439 |
33 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
699 |
699 |
0 |
0.00 |
0 |
1094 |
19 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
2 |
30 |
13 |
0 |
0 |
v_add_invoice_to_stock |
8840 |
8618 |
222 |
2.51 |
0 |
6219 |
21 |
0 |
222 |
v_all_customers |
33782 |
33782 |
0 |
0.00 |
0 |
22 |
1 |
0 |
0 |
v_all_suppliers |
27416 |
27416 |
0 |
0.00 |
0 |
95 |
1 |
0 |
0 |
v_all_wares |
36114 |
36114 |
0 |
0.00 |
0 |
88 |
1 |
0 |
0 |
v_cancel_adding_invoice |
716 |
716 |
0 |
0.00 |
0 |
2478 |
12 |
0 |
0 |
v_cancel_client_order |
3084 |
3084 |
0 |
0.00 |
0 |
6479 |
11 |
0 |
0 |
v_cancel_customer_prepayment |
1134 |
1134 |
0 |
0.00 |
0 |
2073 |
7 |
0 |
0 |
v_cancel_customer_reserve |
1234 |
1234 |
0 |
0.00 |
0 |
6577 |
9 |
0 |
0 |
v_cancel_payment_to_supplier |
736 |
736 |
0 |
0.00 |
0 |
4645 |
13 |
0 |
0 |
v_cancel_supplier_invoice |
766 |
752 |
14 |
1.82 |
0 |
6558 |
31 |
0 |
14 |
v_cancel_supplier_order |
676 |
676 |
0 |
0.00 |
0 |
729 |
4 |
0 |
0 |
v_cancel_write_off |
1770 |
1770 |
0 |
0.00 |
0 |
5005 |
25 |
0 |
0 |
v_max_id_clo_ord |
4866 |
4866 |
0 |
0.00 |
0 |
4124 |
3 |
0 |
0 |
v_max_id_clo_res |
897 |
897 |
0 |
0.00 |
0 |
4992 |
26 |
0 |
0 |
v_max_id_ord_sup |
4821 |
4821 |
0 |
0.00 |
0 |
4104 |
4 |
0 |
0 |
v_max_non_paid_invoice |
1203 |
1203 |
0 |
0.00 |
0 |
1631 |
6 |
0 |
0 |
v_max_non_paid_realizn |
2985 |
2985 |
0 |
0.00 |
0 |
4917 |
6 |
0 |
0 |
v_min_id_clo_ord |
4866 |
4866 |
0 |
0.00 |
0 |
9481 |
12 |
0 |
0 |
v_min_id_clo_res |
897 |
897 |
0 |
0.00 |
0 |
5946 |
9 |
0 |
0 |
v_min_id_ord_sup |
4821 |
4821 |
0 |
0.00 |
0 |
3876 |
5 |
0 |
0 |
v_min_non_paid_invoice |
5224 |
5224 |
0 |
0.00 |
0 |
9313 |
18 |
0 |
0 |
v_min_non_paid_realizn |
6286 |
6286 |
0 |
0.00 |
0 |
6221 |
17 |
0 |
0 |
v_our_firm |
8934 |
8934 |
0 |
0.00 |
0 |
93 |
1 |
0 |
0 |
v_reserve_write_off |
17410 |
17410 |
0 |
0.00 |
0 |
6481 |
6 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9091 |
9091 |
0 |
0.00 |
0 |
20985 |
156 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
338 |
338 |
0 |
0.00 |
0 |
10346 |
429 |
0 |
0 |
x_make_qstorno_1000_1200 |
4867 |
4867 |
0 |
0.00 |
1 |
44236 |
1125 |
0 |
0 |
x_make_qstorno_1200_2000 |
4821 |
4821 |
0 |
0.00 |
3 |
67750 |
3041 |
0 |
0 |
x_make_qstorno_2100_3300 |
412959 |
412959 |
0 |
0.00 |
0 |
48362 |
197 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2024 16:13:47 to 20-03-2024 16:13:51.
Fields:
page cache memo used = page cache total size, bytes:
memo used, total = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
memo allocated, total = the same of mon$memory_usage.mon$memory_allocated;
metadata cache memo used = metadata cache, bytes;
metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
total attachments cnt = total number of attachments, regardless of state;
active attachments cnt = number of attachments with mon$state = 1;
running statements cnt = number of statements that are operating with data from page cache (mon$state = 1);
stalled statements cnt = number of statements that are waiting for client request for fetching ( mon$state = 2);
memo used by attachments = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
memo used by transactions = the same of transaction level (mon$stat_group = 2);
memo used by statements = the same of statement level (mon$stat_group = 3);
Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts |
measurement duration ms |
page cache memo used |
memo used, total |
memo allocated, total |
metadata cache |
metadata cache percent of total |
total attachments cnt |
active attachments cnt |
running statements cnt |
stalled statements cnt |
memo used by attachments |
memo used by transactions |
memo used by statements |
14:12:22 |
2 |
8192000000 |
8797116944 |
8807743488 |
3953616 |
0.048 |
1 |
1 |
2 |
0 |
4051888 |
55488 |
42784 |
14:13:23 |
22765 |
8192000000 |
9873338464 |
10176430080 |
956857184 |
10.458 |
100 |
87 |
174 |
1 |
986137872 |
5698288 |
23582400 |
14:14:53 |
23199 |
8192000000 |
9930071056 |
10245447680 |
1005627696 |
10.933 |
100 |
92 |
183 |
0 |
1037934352 |
8390592 |
23916064 |
14:16:21 |
12933 |
8192000000 |
9957663600 |
10284056576 |
1038859760 |
11.254 |
100 |
83 |
167 |
0 |
1069064304 |
9083488 |
21121056 |
14:17:37 |
11417 |
8192000000 |
10010736432 |
10355924992 |
1100477696 |
11.842 |
100 |
72 |
144 |
0 |
1128117808 |
10520848 |
17119264 |
14:19:02 |
6427 |
8192000000 |
10063971280 |
10420379648 |
1152796208 |
12.336 |
100 |
75 |
150 |
0 |
1182276704 |
12396752 |
17083744 |
14:20:15 |
2285 |
8192000000 |
10112713824 |
10479718400 |
1203660928 |
12.810 |
100 |
81 |
161 |
0 |
1234512096 |
12805792 |
18045376 |
14:21:20 |
1658 |
8192000000 |
10150707632 |
10523181056 |
1235836272 |
13.108 |
100 |
84 |
165 |
1 |
1268442448 |
13774032 |
18832144 |
14:22:22 |
897 |
8192000000 |
10184569712 |
10566631424 |
1271268720 |
13.433 |
100 |
87 |
173 |
1 |
1304372352 |
13735248 |
19368384 |
14:23:25 |
1416 |
8192000000 |
10204673440 |
10588807168 |
1291308256 |
13.616 |
100 |
81 |
161 |
0 |
1321680128 |
12679808 |
17692064 |
14:24:28 |
4756 |
8192000000 |
10196377120 |
10598014976 |
1299952176 |
13.695 |
100 |
45 |
90 |
0 |
1319231056 |
9705616 |
9573264 |
14:25:35 |
17015 |
8192000000 |
10211308848 |
10613661696 |
1309510560 |
13.782 |
100 |
63 |
123 |
1 |
1329481584 |
4989680 |
14981344 |
14:26:56 |
4534 |
8192000000 |
10203024016 |
10616553472 |
1311197824 |
13.797 |
100 |
27 |
54 |
0 |
1323537840 |
6662112 |
5677904 |
14:28:02 |
8181 |
8192000000 |
10205276624 |
10621136896 |
1318687360 |
13.865 |
100 |
30 |
60 |
0 |
1331541360 |
5922224 |
6931776 |
14:29:14 |
11395 |
8192000000 |
10220343008 |
10636578816 |
1327952720 |
13.949 |
100 |
11 |
20 |
0 |
1334816080 |
4548704 |
2314656 |
14:30:29 |
36626 |
8192000000 |
10237526800 |
10646745088 |
1331578672 |
13.981 |
100 |
47 |
94 |
1 |
1348923104 |
5282112 |
12062320 |
14:32:06 |
3701 |
8192000000 |
10227182720 |
10641612800 |
1328957824 |
13.958 |
100 |
31 |
62 |
2 |
1343083152 |
5602048 |
8523280 |
14:33:14 |
10422 |
8192000000 |
10233120384 |
10641068032 |
1319783120 |
13.875 |
99 |
45 |
91 |
0 |
1339343440 |
9644112 |
9916208 |
14:34:32 |
2499 |
8192000000 |
10248614800 |
10654142464 |
1338216544 |
14.041 |
100 |
65 |
129 |
1 |
1365632720 |
12830096 |
14586080 |
14:35:39 |
46629 |
8192000000 |
10236717216 |
10652094464 |
1316630880 |
13.846 |
98 |
49 |
94 |
0 |
1338741312 |
11654256 |
10456176 |
14:37:43 |
17736 |
8192000000 |
10254509392 |
10666717184 |
1342787872 |
14.083 |
100 |
39 |
78 |
1 |
1364269664 |
12804912 |
8676880 |
14:39:05 |
46752 |
8192000000 |
10257037152 |
10672992256 |
1315933696 |
13.840 |
97 |
42 |
83 |
0 |
1340636000 |
15354208 |
9348096 |
14:40:58 |
16229 |
8192000000 |
10260902480 |
10675318784 |
1341005056 |
14.066 |
99 |
51 |
102 |
0 |
1368336336 |
15334160 |
11997120 |
14:42:18 |
16145 |
8192000000 |
10243847312 |
10657529856 |
1320075536 |
13.877 |
99 |
47 |
94 |
1 |
1350477280 |
19448816 |
10952928 |
14:44:00 |
19711 |
8192000000 |
10230709504 |
10631643136 |
1283378880 |
13.544 |
97 |
53 |
104 |
1 |
1311888832 |
16695184 |
11814768 |
14:45:24 |
1715 |
8192000000 |
10264731600 |
10660696064 |
1328410016 |
13.953 |
100 |
73 |
146 |
1 |
1364785568 |
19420528 |
16955024 |
14:46:33 |
1672 |
8192000000 |
10273314752 |
10668490752 |
1340908800 |
14.066 |
100 |
76 |
148 |
1 |
1380664944 |
22374608 |
17381536 |
14:47:40 |
3731 |
8192000000 |
10280220448 |
10684547072 |
1349154816 |
14.140 |
100 |
61 |
122 |
0 |
1389312848 |
25818816 |
14339216 |
14:48:47 |
1578 |
8192000000 |
10299862336 |
10697224192 |
1360064912 |
14.238 |
100 |
82 |
164 |
0 |
1405335296 |
25710992 |
19559392 |
14:49:52 |
6958 |
8192000000 |
10302783072 |
10706948096 |
1361837136 |
14.254 |
99 |
64 |
128 |
1 |
1405318960 |
28124480 |
15357344 |
14:51:09 |
6514 |
8192000000 |
10312508384 |
10719977472 |
1369686976 |
14.324 |
100 |
73 |
144 |
0 |
1419467120 |
31975072 |
17805072 |
14:52:24 |
2695 |
8192000000 |
10334948400 |
10742685696 |
1387746656 |
14.486 |
100 |
70 |
138 |
2 |
1438703040 |
33932624 |
17023760 |
14:53:29 |
4335 |
8192000000 |
10339328512 |
10753122304 |
1394573648 |
14.547 |
100 |
70 |
137 |
0 |
1447615168 |
35677184 |
17364336 |
14:54:37 |
14881 |
8192000000 |
10324465504 |
10753134592 |
1394998288 |
14.550 |
100 |
35 |
71 |
0 |
1437446016 |
32833120 |
9614608 |
14:56:02 |
11570 |
8192000000 |
10331962352 |
10760855552 |
1396032496 |
14.560 |
100 |
42 |
86 |
1 |
1447065424 |
39116160 |
11916768 |
14:57:44 |
6576 |
8192000000 |
10327339424 |
10752798720 |
1391164880 |
14.516 |
100 |
46 |
91 |
0 |
1434583648 |
32877840 |
10540928 |
14:58:58 |
21990 |
8192000000 |
10324051184 |
10758209536 |
1387771552 |
14.486 |
100 |
41 |
81 |
0 |
1435582192 |
36995184 |
10815456 |
15:01:08 |
11602 |
8192000000 |
10330695360 |
10768941056 |
1392055824 |
14.524 |
100 |
29 |
58 |
1 |
1441158480 |
41376432 |
7726224 |
15:02:29 |
40759 |
8192000000 |
10286152704 |
10742378496 |
1356473296 |
14.206 |
98 |
12 |
24 |
0 |
1376935792 |
17923888 |
2538608 |
15:04:11 |
50446 |
8192000000 |
10312110000 |
10745950208 |
1391629408 |
14.520 |
100 |
28 |
54 |
2 |
1411051552 |
13388816 |
6033328 |
15:06:10 |
37601 |
8192000000 |
10310423024 |
10761887744 |
1396081152 |
14.560 |
100 |
20 |
40 |
1 |
1419386224 |
18392032 |
4913040 |
15:07:49 |
17676 |
8192000000 |
10305393824 |
10745446400 |
1394022624 |
14.542 |
100 |
32 |
64 |
1 |
1410653024 |
8555088 |
8075312 |
15:09:17 |
43711 |
8192000000 |
10320612144 |
10764521472 |
1410000416 |
14.684 |
100 |
36 |
72 |
0 |
1427771424 |
9683504 |
8087504 |
15:11:26 |
65576 |
8192000000 |
10291453312 |
10734108672 |
1378778192 |
14.406 |
98 |
37 |
74 |
0 |
1395969824 |
8925872 |
8265760 |
15:13:34 |
24658 |
8192000000 |
10298623456 |
10753007616 |
1390302112 |
14.509 |
99 |
18 |
34 |
0 |
1400195072 |
5533952 |
4359008 |
15:15:19 |
9941 |
8192000000 |
10309113632 |
10753126400 |
1399845232 |
14.594 |
100 |
44 |
88 |
1 |
1419484816 |
9568384 |
10071200 |
15:16:38 |
6878 |
8192000000 |
10302528464 |
10749177856 |
1384906944 |
14.460 |
100 |
33 |
62 |
1 |
1405360240 |
12507552 |
7945744 |
15:17:46 |
60904 |
8192000000 |
10281676224 |
10732122112 |
1358856352 |
14.227 |
99 |
28 |
57 |
1 |
1379778384 |
13831968 |
7090064 |
15:19:52 |
10088 |
8192000000 |
10265317568 |
10715828224 |
1356274720 |
14.204 |
99 |
21 |
40 |
1 |
1377766896 |
16678928 |
4813248 |
15:21:07 |
32973 |
8192000000 |
10275852304 |
10729951232 |
1351981056 |
14.165 |
99 |
25 |
48 |
0 |
1380894368 |
21997472 |
6915840 |
15:22:45 |
95384 |
8192000000 |
10283438160 |
10735493120 |
1334673376 |
14.009 |
97 |
31 |
62 |
1 |
1371956704 |
29787104 |
7496224 |
15:25:35 |
64321 |
8192000000 |
10248693184 |
10712182784 |
1292484928 |
13.627 |
95 |
16 |
31 |
0 |
1314237232 |
18252480 |
3499824 |
15:27:47 |
14848 |
8192000000 |
10278642048 |
10711461888 |
1346067392 |
14.112 |
99 |
59 |
115 |
1 |
1370145952 |
11494432 |
12584128 |
15:29:07 |
57733 |
8192000000 |
10252464208 |
10698809344 |
1295333072 |
13.653 |
95 |
24 |
47 |
0 |
1311585152 |
11553024 |
4699056 |
15:31:09 |
29921 |
8192000000 |
10258805808 |
10698129408 |
1312142832 |
13.806 |
97 |
33 |
67 |
0 |
1330286528 |
10732496 |
7411200 |
15:32:41 |
21756 |
8192000000 |
10260853312 |
10696679424 |
1341987328 |
14.075 |
100 |
36 |
70 |
0 |
1358596576 |
8355216 |
8254032 |
15:34:03 |
28241 |
8192000000 |
10255863616 |
10701611008 |
1336318672 |
14.024 |
100 |
24 |
46 |
0 |
1363059264 |
21639440 |
5101152 |
15:35:32 |
13191 |
8192000000 |
10279950000 |
10714734592 |
1345377296 |
14.106 |
99 |
41 |
82 |
0 |
1367140800 |
12812768 |
8950736 |
15:36:46 |
140053 |
8192000000 |
10284000336 |
10742607872 |
1341902736 |
14.075 |
98 |
14 |
26 |
0 |
1360342800 |
15489984 |
2950080 |
15:40:38 |
71144 |
8192000000 |
10285083040 |
10731089920 |
1365575584 |
14.287 |
99 |
26 |
52 |
0 |
1385399248 |
14156528 |
5667136 |
15:43:04 |
20478 |
8192000000 |
10262294336 |
10697302016 |
1321744240 |
13.892 |
96 |
36 |
72 |
1 |
1341879456 |
12414800 |
7720416 |
15:44:25 |
26024 |
8192000000 |
10286127616 |
10740629504 |
1379464000 |
14.412 |
100 |
16 |
30 |
0 |
1397700096 |
14645216 |
3590880 |
15:45:54 |
32024 |
8192000000 |
10306100304 |
10776662016 |
1390368672 |
14.509 |
100 |
9 |
18 |
0 |
1416456368 |
24128976 |
1958720 |
15:48:34 |
45221 |
8192000000 |
10302168432 |
10757701632 |
1375636912 |
14.378 |
98 |
26 |
52 |
0 |
1394443088 |
12341920 |
6464256 |
15:50:22 |
37923 |
8192000000 |
10322562624 |
10780381184 |
1406420368 |
14.652 |
100 |
18 |
35 |
0 |
1426877584 |
16073280 |
4383936 |
15:52:11 |
78412 |
8192000000 |
10326961536 |
10794496000 |
1416987760 |
14.746 |
100 |
10 |
20 |
0 |
1436098960 |
16667088 |
2444112 |
15:54:31 |
24272 |
8192000000 |
10324295056 |
10777100288 |
1396229296 |
14.561 |
99 |
27 |
54 |
0 |
1411864112 |
9564176 |
6070640 |
15:55:56 |
95113 |
8192000000 |
10300903088 |
10753265664 |
1365621648 |
14.288 |
97 |
23 |
45 |
0 |
1383301696 |
12574880 |
5105168 |
15:58:33 |
124561 |
8192000000 |
10295645888 |
10745339904 |
1341044288 |
14.067 |
96 |
12 |
24 |
1 |
1362095552 |
19004944 |
2046320 |
16:01:47 |
51892 |
8192000000 |
10288599936 |
10733621248 |
1343099888 |
14.085 |
96 |
31 |
62 |
0 |
1357413776 |
7222352 |
7091536 |
16:03:40 |
41900 |
8192000000 |
10278548560 |
10727108608 |
1365884512 |
14.290 |
99 |
41 |
80 |
0 |
1384949584 |
10697904 |
8367168 |
16:05:26 |
37945 |
8192000000 |
10276966768 |
10739421184 |
1357852256 |
14.218 |
98 |
14 |
28 |
0 |
1376207632 |
15318624 |
3036752 |
16:07:04 |
38186 |
8192000000 |
10277215872 |
10744426496 |
1359233200 |
14.230 |
98 |
9 |
18 |
0 |
1374966192 |
13596784 |
2136208 |
16:08:43 |
60634 |
8192000000 |
10266632944 |
10729218048 |
1357693104 |
14.217 |
99 |
14 |
28 |
0 |
1377261040 |
16133968 |
3433968 |
16:11:31 |
30799 |
8192000000 |
10252880624 |
10699145216 |
1248613984 |
13.225 |
91 |
26 |
52 |
0 |
1261410880 |
7012128 |
5784768 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 20-03-2024 16:13:53 to 20-03-2024 16:14:07.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
111 |
v_add_invoice_to_stock |
335544517 |
except |
7 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2024 16:14:08 to 20-03-2024 16:14:10.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 176887
MON$OLDEST_ACTIVE 178315
MON$OLDEST_SNAPSHOT 178315
MON$NEXT_TRANSACTION 178315
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 1921568
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.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 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 Mar 20 16:14:11 2024
Database header page information:
Flags 0
Generation 93093
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 176887
Oldest active 178315
Oldest snapshot 178315
Next transaction 178316
Sequence number 0
Next attachment ID 720
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.36, total records: 7757852
Average version length: 48.16, total versions: 85664, 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: 87048
Data pages: 87048, average fill: 71%
Primary pages: 87048, secondary pages: 0, swept pages: 19669
Empty pages: 6, full pages: 64875
Fill distribution:
0 - 19% = 28
20 - 39% = 219
40 - 59% = 3121
60 - 79% = 83662
80 - 99% = 18
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510614, depth: 3, leaf buckets: 23327, nodes: 7757852
Average node length: 18.89, total dup: 0, max dup: 0
Average key length: 15.90, compression ratio: 1.70
Average prefix length: 14.10, average data length: 12.90
Clustering factor: 1735521, ratio: 0.22
Fill distribution:
0 - 19% = 310
20 - 39% = 1741
40 - 59% = 4334
60 - 79% = 2322
80 - 99% = 14620
Index DOC_DATA_ID_DESC (1)
Root page: 1528118, depth: 3, leaf buckets: 13555, nodes: 7757852
Average node length: 11.20, total dup: 0, max dup: 0
Average key length: 8.21, compression ratio: 1.10
Average prefix length: 3.79, average data length: 5.21
Clustering factor: 1557341, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1618
40 - 59% = 2050
60 - 79% = 1058
80 - 99% = 8829
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546711, depth: 3, leaf buckets: 8351, nodes: 7757852
Average node length: 6.62, total dup: 5800128, max dup: 49
Average key length: 3.63, compression ratio: 2.48
Average prefix length: 7.62, average data length: 1.38
Clustering factor: 1550133, ratio: 0.20
Fill distribution:
0 - 19% = 104
20 - 39% = 992
40 - 59% = 1410
60 - 79% = 890
80 - 99% = 4955
DOC_LIST (138)
Primary pointer page: 472, Index root page: 473
Total formats: 1, used formats: 1
Average record length: 56.30, total records: 2247981
Average version length: 34.56, total versions: 89064, max versions: 3
Average fragment length: 4.00, total fragments: 2, max fragments: 1
Average unpacked length: 84.00, compression ratio: 1.49
Pointer pages: 18, data page slots: 28520
Data pages: 28520, average fill: 73%
Primary pages: 28515, secondary pages: 5, swept pages: 11061
Empty pages: 0, full pages: 20417
Fill distribution:
0 - 19% = 11
20 - 39% = 107
40 - 59% = 1942
60 - 79% = 25794
80 - 99% = 666
Index DOC_LIST_ID_DESC (1)
Root page: 1541130, depth: 3, leaf buckets: 4576, nodes: 2247981
Average node length: 11.40, total dup: 0, max dup: 0
Average key length: 8.44, compression ratio: 1.07
Average prefix length: 3.56, average data length: 5.44
Clustering factor: 698408, ratio: 0.31
Fill distribution:
0 - 19% = 1
20 - 39% = 943
40 - 59% = 843
60 - 79% = 745
80 - 99% = 2044
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544376, depth: 3, leaf buckets: 2532, nodes: 2250220
Average node length: 4.97, total dup: 2249321, max dup: 19391
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1255086, ratio: 0.56
Fill distribution:
0 - 19% = 2
20 - 39% = 275
40 - 59% = 1544
60 - 79% = 519
80 - 99% = 192
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545909, depth: 3, leaf buckets: 2057, nodes: 2247981
Average node length: 4.97, total dup: 2247931, max dup: 130321
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1062484, ratio: 0.47
Fill distribution:
0 - 19% = 4
20 - 39% = 60
40 - 59% = 1120
60 - 79% = 50
80 - 99% = 823
Index PK_DOC_LIST (0)
Root page: 1538187, depth: 3, leaf buckets: 4389, nodes: 2247981
Average node length: 11.40, total dup: 0, max dup: 0
Average key length: 8.44, compression ratio: 1.07
Average prefix length: 3.56, average data length: 5.44
Clustering factor: 698408, ratio: 0.31
Fill distribution:
0 - 19% = 121
20 - 39% = 613
40 - 59% = 619
60 - 79% = 803
80 - 99% = 2233
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: 81.99, total records: 400
Average version length: 22.41, total versions: 253884, max versions: 664
Average fragment length: 2.00, total fragments: 73, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.27
Pointer pages: 1, data page slots: 1416
Data pages: 1416, average fill: 88%
Primary pages: 13, secondary pages: 1403, swept pages: 0
Empty pages: 6, full pages: 1409
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 1
60 - 79% = 4
80 - 99% = 1405
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: 4.78, total records: 88095
Average version length: 68.30, total versions: 81934, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 18.41
Pointer pages: 7, data page slots: 2064
Data pages: 1648, average fill: 67%
Primary pages: 1647, secondary pages: 1, swept pages: 0
Empty pages: 182, full pages: 1030
Fill distribution:
0 - 19% = 239
20 - 39% = 128
40 - 59% = 143
60 - 79% = 235
80 - 99% = 903
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1695689, depth: 3, leaf buckets: 290, nodes: 88095
Average node length: 13.37, total dup: 6642, max dup: 1
Average key length: 10.63, compression ratio: 2.54
Average prefix length: 19.29, average data length: 7.71
Clustering factor: 61158, ratio: 0.69
Fill distribution:
0 - 19% = 0
20 - 39% = 88
40 - 59% = 112
60 - 79% = 87
80 - 99% = 3
MONEY_SALDO (141)
Primary pointer page: 478, Index root page: 479
Total formats: 1, used formats: 1
Average record length: 15.22, total records: 49
Average version length: 9.00, total versions: 18426, max versions: 979
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: 92%
Primary pages: 1, secondary pages: 63, swept pages: 0
Empty pages: 0, full pages: 63
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 64
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: 3.18, total records: 1479
Average version length: 43.52, total versions: 1373, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 18.22
Pointer pages: 1, data page slots: 32
Data pages: 27, average fill: 53%
Primary pages: 26, secondary pages: 1, swept pages: 3
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 7
20 - 39% = 4
40 - 59% = 3
60 - 79% = 2
80 - 99% = 11
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 89108, depth: 2, leaf buckets: 1, nodes: 1479
Average node length: 4.46, total dup: 1381, max dup: 164
Average key length: 2.69, compression ratio: 7.06
Average prefix length: 18.38, average data length: 0.62
Clustering factor: 796, ratio: 0.54
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
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: 75
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: 52%
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% = 0
80 - 99% = 1
Index PK_MON_CACHE_MEMORY (0)
Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 10.67, compression ratio: 0.84
Average prefix length: 1.32, average data length: 7.68
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 520, Index root page: 521
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (163)
Primary pointer page: 522, Index root page: 523
Total formats: 2, used formats: 1
Average record length: 67.13, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 611.00, compression ratio: 9.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.50, total dup: 23, max dup: 4
Average key length: 2.47, compression ratio: 3.24
Average prefix length: 7.53, average data length: 0.47
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 2.00, total dup: 29, max dup: 29
Average key length: 1.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.33, total dup: 29, max dup: 29
Average key length: 2.30, compression ratio: 3.91
Average prefix length: 8.70, average data length: 0.30
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 12.90, total dup: 0, max dup: 0
Average key length: 11.87, compression ratio: 1.42
Average prefix length: 7.63, average data length: 9.20
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 8.37, total dup: 0, max dup: 0
Average key length: 7.33, compression ratio: 1.23
Average prefix length: 4.63, average data length: 4.37
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (136)
Primary pointer page: 468, Index root page: 469
Total formats: 2, used formats: 1
Average record length: 67.56, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 386.00, compression ratio: 5.71
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (146)
Primary pointer page: 488, Index root page: 489
Total formats: 1, used formats: 1
Average record length: 36.33, total records: 803747
Average version length: 25.59, total versions: 58772, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.49
Pointer pages: 6, data page slots: 8200
Data pages: 8200, average fill: 68%
Primary pages: 8171, secondary pages: 29, swept pages: 2147
Empty pages: 89, full pages: 6345
Fill distribution:
0 - 19% = 163
20 - 39% = 165
40 - 59% = 381
60 - 79% = 7283
80 - 99% = 208
Index PDISTR_AGENT_ID (2)
Root page: 1509308, depth: 2, leaf buckets: 898, nodes: 803747
Average node length: 4.87, total dup: 803698, max dup: 153451
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 88761, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 147
40 - 59% = 487
60 - 79% = 206
80 - 99% = 57
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508613, depth: 3, leaf buckets: 982, nodes: 803747
Average node length: 5.88, total dup: 715790, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 158953, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 105
40 - 59% = 495
60 - 79% = 142
80 - 99% = 239
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509187, depth: 3, leaf buckets: 1020, nodes: 803747
Average node length: 5.88, total dup: 715790, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 160960, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 205
40 - 59% = 449
60 - 79% = 124
80 - 99% = 242
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510178, depth: 3, leaf buckets: 1139, nodes: 803747
Average node length: 5.96, total dup: 715790, max dup: 42
Average key length: 3.10, compression ratio: 5.49
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 153707, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 250
40 - 59% = 586
60 - 79% = 205
80 - 99% = 97
PERF_AGG (158)
Primary pointer page: 512, Index root page: 513
Total formats: 1, used formats: 1
Average record length: 62.86, total records: 5458
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 2.46, total fragments: 52, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.03
Pointer pages: 1, data page slots: 88
Data pages: 86, average fill: 63%
Primary pages: 71, secondary pages: 15, swept pages: 54
Empty pages: 7, full pages: 67
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 1
60 - 79% = 68
80 - 99% = 1
Index PERF_AGG_UNQ (1)
Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5458
Average node length: 5.51, total dup: 0, max dup: 0
Average key length: 3.58, compression ratio: 10.05
Average prefix length: 34.44, average data length: 1.54
Clustering factor: 5119, ratio: 0.94
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: 5458
Average node length: 11.14, 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: 142, 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.15, total records: 81314
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: 784
Data pages: 784, average fill: 71%
Primary pages: 784, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 783
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 783
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 36475, depth: 2, leaf buckets: 104, nodes: 81314
Average node length: 10.18, total dup: 0, max dup: 0
Average key length: 8.19, compression ratio: 1.10
Average prefix length: 3.80, average data length: 5.20
Clustering factor: 3458, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 102
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: 149.26, total records: 169881
Average version length: 151.48, total versions: 2177, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.36
Pointer pages: 8, data page slots: 4696
Data pages: 4072, average fill: 86%
Primary pages: 4072, secondary pages: 0, swept pages: 4
Empty pages: 34, full pages: 4021
Fill distribution:
0 - 19% = 38
20 - 39% = 3
40 - 59% = 6
60 - 79% = 4
80 - 99% = 4021
PERF_SPLIT_1 (282)
Primary pointer page: 576, Index root page: 577
Total formats: 1, used formats: 1
Average record length: 148.66, total records: 167838
Average version length: 150.52, total versions: 2747, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.41
Pointer pages: 8, data page slots: 4560
Data pages: 4064, average fill: 85%
Primary pages: 4064, secondary pages: 0, swept pages: 8
Empty pages: 76, full pages: 3966
Fill distribution:
0 - 19% = 79
20 - 39% = 5
40 - 59% = 4
60 - 79% = 10
80 - 99% = 3966
PERF_SPLIT_2 (283)
Primary pointer page: 578, Index root page: 579
Total formats: 1, used formats: 1
Average record length: 148.11, total records: 171417
Average version length: 152.28, total versions: 3593, 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: 5000
Data pages: 4152, average fill: 85%
Primary pages: 4152, secondary pages: 0, swept pages: 6
Empty pages: 59, full pages: 4044
Fill distribution:
0 - 19% = 61
20 - 39% = 19
40 - 59% = 21
60 - 79% = 8
80 - 99% = 4043
PERF_SPLIT_3 (284)
Primary pointer page: 580, Index root page: 581
Total formats: 1, used formats: 1
Average record length: 138.03, total records: 176119
Average version length: 154.62, total versions: 14897, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.29
Pointer pages: 7, data page slots: 5016
Data pages: 4288, average fill: 85%
Primary pages: 4288, secondary pages: 0, swept pages: 6
Empty pages: 97, full pages: 4164
Fill distribution:
0 - 19% = 104
20 - 39% = 6
40 - 59% = 7
60 - 79% = 8
80 - 99% = 4163
PERF_SPLIT_4 (285)
Primary pointer page: 582, Index root page: 583
Total formats: 1, used formats: 1
Average record length: 142.01, total records: 136920
Average version length: 153.56, total versions: 7963, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.94
Pointer pages: 7, data page slots: 4656
Data pages: 3320, average fill: 85%
Primary pages: 3319, secondary pages: 1, swept pages: 3
Empty pages: 68, full pages: 3232
Fill distribution:
0 - 19% = 70
20 - 39% = 5
40 - 59% = 3
60 - 79% = 12
80 - 99% = 3230
PERF_SPLIT_5 (286)
Primary pointer page: 584, Index root page: 585
Total formats: 1, used formats: 1
Average record length: 141.66, total records: 166346
Average version length: 154.51, total versions: 10524, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.97
Pointer pages: 7, data page slots: 4552
Data pages: 4040, average fill: 85%
Primary pages: 4040, secondary pages: 0, swept pages: 11
Empty pages: 77, full pages: 3940
Fill distribution:
0 - 19% = 78
20 - 39% = 8
40 - 59% = 9
60 - 79% = 8
80 - 99% = 3937
PERF_SPLIT_6 (287)
Primary pointer page: 586, Index root page: 587
Total formats: 1, used formats: 1
Average record length: 147.51, total records: 156257
Average version length: 151.94, total versions: 3423, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.50
Pointer pages: 6, data page slots: 4816
Data pages: 3744, average fill: 86%
Primary pages: 3744, secondary pages: 0, swept pages: 5
Empty pages: 35, full pages: 3687
Fill distribution:
0 - 19% = 38
20 - 39% = 4
40 - 59% = 6
60 - 79% = 10
80 - 99% = 3686
PERF_SPLIT_7 (288)
Primary pointer page: 588, Index root page: 589
Total formats: 1, used formats: 1
Average record length: 145.22, total records: 158222
Average version length: 153.19, total versions: 5872, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.68
Pointer pages: 7, data page slots: 4568
Data pages: 3816, average fill: 86%
Primary pages: 3816, secondary pages: 0, swept pages: 4
Empty pages: 53, full pages: 3737
Fill distribution:
0 - 19% = 59
20 - 39% = 6
40 - 59% = 7
60 - 79% = 8
80 - 99% = 3736
PERF_SPLIT_8 (289)
Primary pointer page: 590, Index root page: 591
Total formats: 1, used formats: 1
Average record length: 149.84, total records: 160126
Average version length: 147.70, total versions: 1353, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.32
Pointer pages: 6, data page slots: 5344
Data pages: 3848, average fill: 86%
Primary pages: 3848, secondary pages: 0, swept pages: 6
Empty pages: 43, full pages: 3788
Fill distribution:
0 - 19% = 48
20 - 39% = 5
40 - 59% = 4
60 - 79% = 2
80 - 99% = 3789
PERF_SPLIT_9 (290)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 148.61, total records: 166367
Average version length: 150.72, total versions: 2687, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.41
Pointer pages: 7, data page slots: 5352
Data pages: 3976, average fill: 86%
Primary pages: 3976, secondary pages: 0, swept pages: 4
Empty pages: 25, full pages: 3936
Fill distribution:
0 - 19% = 28
20 - 39% = 5
40 - 59% = 5
60 - 79% = 2
80 - 99% = 3936
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.96, total records: 2093670
Average version length: 52.99, total versions: 31280, 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: 25560
Data pages: 25560, average fill: 70%
Primary pages: 25560, secondary pages: 0, swept pages: 11280
Empty pages: 330, full pages: 20522
Fill distribution:
0 - 19% = 605
20 - 39% = 499
40 - 59% = 1219
60 - 79% = 23005
80 - 99% = 232
Index PSTORNED_RCV_ID (1)
Root page: 1506186, depth: 3, leaf buckets: 2616, nodes: 2093670
Average node length: 5.44, total dup: 1953308, max dup: 1416
Average key length: 2.49, compression ratio: 3.62
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 181736, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 355
40 - 59% = 1690
60 - 79% = 306
80 - 99% = 261
Index PSTORNED_SND_ID (0)
Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2093670
Average node length: 5.69, total dup: 1878613, max dup: 77
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 374602, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 2411
60 - 79% = 317
80 - 99% = 29
Index PSTORNED_WORKER_ID (2)
Root page: 1507996, depth: 3, leaf buckets: 2165, nodes: 2093670
Average node length: 4.96, total dup: 2093570, max dup: 27145
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 179388, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 226
40 - 59% = 1190
60 - 79% = 343
80 - 99% = 403
RULES_FOR_PDISTR (148)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 470, Index root page: 471
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 466, Index root page: 467
Total formats: 1, used formats: 1
Average record length: 97.63, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index SETTINGS_MCODE_WM_UNQ (1)
Root page: 525, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 454, Index root page: 455
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 460, Index root page: 461
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 462, Index root page: 463
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 464, Index root page: 465
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 518, Index root page: 519
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 516, Index root page: 517
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 458, Index root page: 459
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 456, Index root page: 457
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 452, Index root page: 453
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 510, Index root page: 511
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 549, Index root page: 550
Total formats: 1, used formats: 1
Average record length: 41.69, total records: 129763
Average version length: 69.15, total versions: 51629, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.02
Pointer pages: 3, data page slots: 4104
Data pages: 2928, average fill: 51%
Primary pages: 2928, secondary pages: 0, swept pages: 501
Empty pages: 460, full pages: 1418
Fill distribution:
0 - 19% = 841
20 - 39% = 316
40 - 59% = 189
60 - 79% = 535
80 - 99% = 1047
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 316357, depth: 3, leaf buckets: 223, nodes: 129763
Average node length: 6.35, total dup: 113133, max dup: 14
Average key length: 3.96, compression ratio: 10.61
Average prefix length: 40.17, average data length: 1.83
Clustering factor: 21905, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 83
40 - 59% = 99
60 - 79% = 39
80 - 99% = 0
XQD_1000_3300 (178)
Primary pointer page: 553, Index root page: 554
Total formats: 1, used formats: 1
Average record length: 66.31, total records: 7008684
Average version length: 68.75, total versions: 268650, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.90
Pointer pages: 64, data page slots: 103232
Data pages: 103232, average fill: 72%
Primary pages: 103232, secondary pages: 0, swept pages: 37789
Empty pages: 11, full pages: 69942
Fill distribution:
0 - 19% = 133
20 - 39% = 1201
40 - 59% = 9224
60 - 79% = 89669
80 - 99% = 3005
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480454, depth: 3, leaf buckets: 10746, nodes: 7008684
Average node length: 6.51, total dup: 6063882, max dup: 29
Average key length: 3.52, compression ratio: 11.94
Average prefix length: 40.62, average data length: 1.38
Clustering factor: 1565573, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 1816
40 - 59% = 5959
60 - 79% = 2454
80 - 99% = 512
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486068, depth: 3, leaf buckets: 8532, nodes: 7008684
Average node length: 5.40, total dup: 6730026, max dup: 181
Average key length: 2.41, compression ratio: 7.07
Average prefix length: 16.63, average data length: 0.37
Clustering factor: 1365374, ratio: 0.19
Fill distribution:
0 - 19% = 7
20 - 39% = 1411
40 - 59% = 4551
60 - 79% = 1493
80 - 99% = 1070
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490608, depth: 3, leaf buckets: 8612, nodes: 7008684
Average node length: 5.40, total dup: 6730026, max dup: 181
Average key length: 2.41, compression ratio: 7.07
Average prefix length: 16.63, average data length: 0.37
Clustering factor: 1367943, ratio: 0.20
Fill distribution:
0 - 19% = 3
20 - 39% = 1471
40 - 59% = 4640
60 - 79% = 1422
80 - 99% = 1076
XQD_1200_2000 (177)
Primary pointer page: 551, Index root page: 552
Total formats: 1, used formats: 1
Average record length: 67.48, total records: 12035011
Average version length: 68.73, total versions: 256801, 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: 104, data page slots: 168816
Data pages: 168816, average fill: 76%
Primary pages: 168816, secondary pages: 0, swept pages: 85562
Empty pages: 3, full pages: 149711
Fill distribution:
0 - 19% = 56
20 - 39% = 670
40 - 59% = 5150
60 - 79% = 158863
80 - 99% = 4077
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495028, depth: 3, leaf buckets: 18373, nodes: 12035011
Average node length: 6.58, total dup: 10490785, max dup: 53
Average key length: 3.43, compression ratio: 12.26
Average prefix length: 40.70, average data length: 1.30
Clustering factor: 2364672, ratio: 0.20
Fill distribution:
0 - 19% = 26
20 - 39% = 2518
40 - 59% = 10686
60 - 79% = 4197
80 - 99% = 946
XQD_2000_3300 (179)
Primary pointer page: 555, Index root page: 556
Total formats: 1, used formats: 1
Average record length: 46.41, total records: 1517731
Average version length: 69.12, total versions: 499373, 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: 28, data page slots: 44040
Data pages: 27920, average fill: 62%
Primary pages: 27920, secondary pages: 0, swept pages: 8963
Empty pages: 3000, full pages: 17497
Fill distribution:
0 - 19% = 4983
20 - 39% = 2146
40 - 59% = 1875
60 - 79% = 11000
80 - 99% = 7916
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479712, depth: 3, leaf buckets: 2205, nodes: 1517731
Average node length: 5.51, total dup: 1456433, max dup: 99
Average key length: 2.56, compression ratio: 16.39
Average prefix length: 41.48, average data length: 0.52
Clustering factor: 99947, ratio: 0.07
Fill distribution:
0 - 19% = 10
20 - 39% = 744
40 - 59% = 1029
60 - 79% = 359
80 - 99% = 63
XQD_2100_3300 (180)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 1
Average record length: 42.24, total records: 1026475
Average version length: 69.13, total versions: 398176, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 2.98
Pointer pages: 22, data page slots: 34376
Data pages: 30152, average fill: 40%
Primary pages: 30152, secondary pages: 0, swept pages: 9522
Empty pages: 6978, full pages: 10186
Fill distribution:
0 - 19% = 12986
20 - 39% = 3751
40 - 59% = 1802
60 - 79% = 4597
80 - 99% = 7016
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479207, depth: 3, leaf buckets: 1499, nodes: 1026475
Average node length: 5.76, total dup: 960549, max dup: 99
Average key length: 2.84, compression ratio: 14.80
Average prefix length: 41.22, average data length: 0.78
Clustering factor: 135287, ratio: 0.13
Fill distribution:
0 - 19% = 4
20 - 39% = 442
40 - 59% = 715
60 - 79% = 276
80 - 99% = 62
XQD_3300_3400 (181)
Primary pointer page: 559, Index root page: 560
Total formats: 1, used formats: 1
Average record length: 66.41, total records: 9069448
Average version length: 68.96, total versions: 325667, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.90
Pointer pages: 90, data page slots: 145512
Data pages: 145488, average fill: 67%
Primary pages: 145488, secondary pages: 0, swept pages: 72302
Empty pages: 395, full pages: 68383
Fill distribution:
0 - 19% = 1272
20 - 39% = 8131
40 - 59% = 28559
60 - 79% = 103335
80 - 99% = 4191
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472590, depth: 3, leaf buckets: 13465, nodes: 9069448
Average node length: 6.69, total dup: 7525365, max dup: 29
Average key length: 3.67, compression ratio: 11.45
Average prefix length: 40.50, average data length: 1.50
Clustering factor: 1955043, ratio: 0.22
Fill distribution:
0 - 19% = 10
20 - 39% = 1492
40 - 59% = 6861
60 - 79% = 4482
80 - 99% = 620
XQS_1000_1200 (182)
Primary pointer page: 561, Index root page: 562
Total formats: 1, used formats: 1
Average record length: 82.50, total records: 21171707
Average version length: 82.93, total versions: 10713, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.53
Pointer pages: 196, data page slots: 319128
Data pages: 319128, average fill: 81%
Primary pages: 319128, secondary pages: 0, swept pages: 13200
Empty pages: 32, full pages: 318325
Fill distribution:
0 - 19% = 55
20 - 39% = 37
40 - 59% = 95
60 - 79% = 27787
80 - 99% = 291154
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426716, depth: 3, leaf buckets: 19426, nodes: 21171707
Average node length: 5.72, total dup: 20690405, max dup: 128
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3284397, ratio: 0.16
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 8189
60 - 79% = 550
80 - 99% = 10680
Index XQS_1000_1200_RCV_ID (3)
Root page: 1456980, depth: 3, leaf buckets: 17215, nodes: 21171707
Average node length: 6.31, total dup: 18605642, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 914791, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 837
60 - 79% = 265
80 - 99% = 16105
Index XQS_1000_1200_SND_ID (2)
Root page: 1441073, depth: 3, leaf buckets: 21184, nodes: 21171707
Average node length: 6.35, total dup: 18524586, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3578974, ratio: 0.17
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 8417
60 - 79% = 588
80 - 99% = 12174
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413348, depth: 3, leaf buckets: 16196, nodes: 21171707
Average node length: 5.56, total dup: 21171607, max dup: 229319
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 943532, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 3060
60 - 79% = 372
80 - 99% = 12750
XQS_1000_3300 (184)
Primary pointer page: 565, Index root page: 566
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 9528756
Average version length: 82.59, total versions: 329973, 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: 172960
Data pages: 172960, average fill: 68%
Primary pages: 172960, secondary pages: 0, swept pages: 93665
Empty pages: 757, full pages: 87563
Fill distribution:
0 - 19% = 2099
20 - 39% = 9423
40 - 59% = 33269
60 - 79% = 75518
80 - 99% = 52651
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367502, depth: 3, leaf buckets: 11400, nodes: 9528756
Average node length: 5.38, total dup: 9219784, max dup: 194
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 2119301, ratio: 0.22
Fill distribution:
0 - 19% = 4
20 - 39% = 139
40 - 59% = 8515
60 - 79% = 2661
80 - 99% = 81
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379261, depth: 3, leaf buckets: 13553, nodes: 9528756
Average node length: 6.25, total dup: 7900939, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1479488, ratio: 0.16
Fill distribution:
0 - 19% = 126
20 - 39% = 4254
40 - 59% = 4292
60 - 79% = 2601
80 - 99% = 2280
Index XQS_1000_3300_SND_ID (2)
Root page: 1373059, depth: 3, leaf buckets: 12720, nodes: 9528756
Average node length: 6.00, total dup: 8261884, max dup: 39
Average key length: 2.85, compression ratio: 3.15
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 2299171, ratio: 0.24
Fill distribution:
0 - 19% = 3
20 - 39% = 150
40 - 59% = 9513
60 - 79% = 2957
80 - 99% = 97
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362767, depth: 3, leaf buckets: 10067, nodes: 9528756
Average node length: 5.15, total dup: 9528656, max dup: 154051
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1527741, ratio: 0.16
Fill distribution:
0 - 19% = 43
20 - 39% = 1323
40 - 59% = 5015
60 - 79% = 1646
80 - 99% = 2040
XQS_1200_2000 (183)
Primary pointer page: 563, Index root page: 564
Total formats: 1, used formats: 1
Average record length: 80.13, total records: 11257502
Average version length: 82.52, total versions: 296410, 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: 120, data page slots: 194320
Data pages: 193136, average fill: 72%
Primary pages: 193136, secondary pages: 0, swept pages: 81017
Empty pages: 3380, full pages: 136828
Fill distribution:
0 - 19% = 5841
20 - 39% = 8856
40 - 59% = 21176
60 - 79% = 46160
80 - 99% = 111103
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11257502
Average node length: 5.31, total dup: 11147189, max dup: 645
Average key length: 2.08, compression ratio: 4.32
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2349244, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 207
40 - 59% = 8996
60 - 79% = 3776
80 - 99% = 149
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406110, depth: 3, leaf buckets: 10518, nodes: 11257502
Average node length: 5.51, total dup: 10766074, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 714537, ratio: 0.06
Fill distribution:
0 - 19% = 163
20 - 39% = 888
40 - 59% = 2648
60 - 79% = 1879
80 - 99% = 4940
Index XQS_1200_2000_SND_ID (2)
Root page: 1398638, depth: 3, leaf buckets: 15012, nodes: 11257502
Average node length: 6.04, total dup: 9820923, max dup: 65
Average key length: 2.81, compression ratio: 3.21
Average prefix length: 8.32, average data length: 0.68
Clustering factor: 2365623, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 284
40 - 59% = 10398
60 - 79% = 4152
80 - 99% = 177
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386211, depth: 3, leaf buckets: 10864, nodes: 11257502
Average node length: 5.23, total dup: 11257402, max dup: 192992
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 703661, ratio: 0.06
Fill distribution:
0 - 19% = 94
20 - 39% = 970
40 - 59% = 4828
60 - 79% = 1543
80 - 99% = 3429
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.90, total records: 9645069
Average version length: 82.90, total versions: 330634, 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: 109, data page slots: 177016
Data pages: 176984, average fill: 68%
Primary pages: 176984, secondary pages: 0, swept pages: 99020
Empty pages: 822, full pages: 87147
Fill distribution:
0 - 19% = 2361
20 - 39% = 10493
40 - 59% = 34918
60 - 79% = 78071
80 - 99% = 51141
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344686, depth: 3, leaf buckets: 11774, nodes: 9645069
Average node length: 5.20, total dup: 9616292, max dup: 1523
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 1924810, ratio: 0.20
Fill distribution:
0 - 19% = 30
20 - 39% = 1583
40 - 59% = 7749
60 - 79% = 1841
80 - 99% = 571
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355717, depth: 3, leaf buckets: 13762, nodes: 9645069
Average node length: 6.27, total dup: 7996783, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1438655, ratio: 0.15
Fill distribution:
0 - 19% = 195
20 - 39% = 4283
40 - 59% = 4269
60 - 79% = 2630
80 - 99% = 2385
Index XQS_2100_3300_SND_ID (2)
Root page: 1350049, depth: 3, leaf buckets: 12422, nodes: 9645069
Average node length: 5.46, total dup: 9211333, max dup: 99
Average key length: 2.29, compression ratio: 3.93
Average prefix length: 8.76, average data length: 0.24
Clustering factor: 2054474, ratio: 0.21
Fill distribution:
0 - 19% = 33
20 - 39% = 1534
40 - 59% = 8631
60 - 79% = 1672
80 - 99% = 552
Index XQS_2100_3300_WORKER_ID (0)
Root page: 985805, depth: 3, leaf buckets: 10258, nodes: 9645069
Average node length: 5.17, total dup: 9644969, max dup: 156133
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 1536955, ratio: 0.16
Fill distribution:
0 - 19% = 41
20 - 39% = 1405
40 - 59% = 5192
60 - 79% = 1572
80 - 99% = 2048
XQS_3300_3400 (187)
Primary pointer page: 571, Index root page: 572
Total formats: 1, used formats: 1
Average record length: 67.61, total records: 575346
Average version length: 68.85, total versions: 4692, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.86
Pointer pages: 5, data page slots: 8032
Data pages: 8032, average fill: 75%
Primary pages: 8032, secondary pages: 0, swept pages: 4143
Empty pages: 7, full pages: 6536
Fill distribution:
0 - 19% = 9
20 - 39% = 21
40 - 59% = 255
60 - 79% = 7667
80 - 99% = 80
Index XQS_3300_3400_DOC_ID (1)
Root page: 31084, depth: 3, leaf buckets: 749, nodes: 575346
Average node length: 5.95, total dup: 489932, max dup: 83
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 100022, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 536
60 - 79% = 94
80 - 99% = 81
Index XQS_3300_3400_SND_ID (2)
Root page: 22797, depth: 3, leaf buckets: 764, nodes: 575346
Average node length: 6.15, total dup: 471831, max dup: 25
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 100073, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 545
60 - 79% = 96
80 - 99% = 92
Index XQS_3300_3400_WORKER_ID (0)
Root page: 375548, depth: 2, leaf buckets: 583, nodes: 575346
Average node length: 4.86, total dup: 575246, max dup: 9557
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 88817, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 35
40 - 59% = 351
60 - 79% = 95
80 - 99% = 102
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 Mar 20 16:14:35 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7757852 |
85664 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2247981 |
89064 |
3 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
253884 |
664 |
63400.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
88095 |
81934 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
18426 |
979 |
37600.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
1479 |
1373 |
1 |
0.0000 |
0.0000 |
PDISTR |
803747 |
58772 |
4 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
169881 |
2177 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
167838 |
2747 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
171417 |
3593 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
176119 |
14897 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
136920 |
7963 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
166346 |
10524 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
156257 |
3423 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
158222 |
5872 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
160126 |
1353 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
166367 |
2687 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2093670 |
31280 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
129763 |
51629 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7008684 |
268650 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12035011 |
256801 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1517731 |
499373 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1026475 |
398176 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
9069448 |
325667 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21171707 |
10713 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9528756 |
329973 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
11257502 |
296410 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
9645069 |
330634 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
575346 |
4692 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:6:
:7: mscs-test-161.budzdorov.ru Wed Mar 20 16:12:20 2024
:8: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9:
:10:
:11: mscs-test-161.budzdorov.ru Wed Mar 20 16:12:22 2024
:12: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13:
--- end of diff output ---
20.03.24 16:14:47. 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-03-20 16:14:49 |
No severe PSQL-related problems occured |
20.03.24 16:14:51. End of report.