Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.02.2024 13:08
Command: hostnamectl |
Static hostname | mscs-test-161.budzdorov.ru |
Icon name | computer-server |
Chassis | server |
Machine ID | aeee285d2cca40bf84c40a748f599e77 |
Boot ID | 2a7b53d1c5ed44b9bb2712fffac5d8c6 |
Operating System | CentOS Linux 7 (Core) |
CPE OS Name | cpe:/o:centos:centos:7 |
Kernel | Linux 3.10.0-1127.10.1.el7.x86_64 |
Architecture | x86-64 |
Command: who -b |
bootup_info | system boot 2021-11-11 18:28 |
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor' |
Manufacturer | HP |
Product Name | ProLiant DL380 Gen9 |
Command: dmesg | grep DMI |
[ 0.000000] DMI | HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018 |
Command: lscpu | grep -i -v flags |
Architecture | x86_64 |
CPU op-mode(s) | 32-bit, 64-bit |
Byte Order | Little Endian |
CPU(s) | 24 |
On-line CPU(s) list | 0-23 |
Thread(s) per core | 2 |
Core(s) per socket | 6 |
Socket(s) | 2 |
NUMA node(s) | 2 |
Vendor ID | GenuineIntel |
CPU family | 6 |
Model | 63 |
Model name | Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz |
Stepping | 2 |
CPU MHz | 1200.000 |
CPU max MHz | 2400.0000 |
CPU min MHz | 1200.0000 |
BogoMIPS | 4794.33 |
Virtualization | VT-x |
L1d cache | 32K |
L1i cache | 32K |
L2 cache | 256K |
L3 cache | 15360K |
NUMA node0 CPU(s) | 0-5,12-17 |
NUMA node1 CPU(s) | 6-11,18-23 |
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached' |
MemTotal | 32643792 kB |
MemFree | 15615180 kB |
MemAvailable | 30217640 kB |
Buffers | 0 kB |
Cached | 16093452 kB |
SwapCached | 2472 kB |
Command: fdisk -l |
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion. |
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk label type: gpt |
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C |
# Start End Size Type Name |
1 2048 411647 200M EFI System EFI System Partition |
2 411648 2508799 1G Microsoft basic |
3 2508800 1171742719 557.5G Linux LVM |
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 512 bytes / 512 bytes |
Disk label type: dos |
Disk identifier: 0x00000046 |
Device Boot Start End Blocks Id System |
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA) |
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors |
Units = sectors of 1 * 512 = 512 bytes |
Sector size (logical/physical): 512 bytes / 512 bytes |
I/O size (minimum/optimal): 262144 bytes / 524288 bytes |
SERVER_MODE SuperServer 4.0.5
DB_NAME /home/bases/oltp40-etalone.fdb
FORCED_WRITES ON
SWEEP_INT 0
PAGE_BUFFERS 1000000
PAGE_SIZE 8192
Test configuration settings
param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2024-02-20 13:07:49
DTS_END 2024-02-20 13:07:49.0300
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/35164
TRN_ID 175472
ATT_ID 494
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: |
9319.04 |
19158 |
931904 |
customer order: creation |
180.45 |
419 |
18045 |
customer order: refuse |
15.90 |
381 |
1590 |
order to supplier: creation |
47.23 |
1289 |
4723 |
order to supplier: removal |
3.69 |
86025 |
369 |
invoice (draft): creation |
48.79 |
3365 |
4879 |
invoice (draft): removal |
50.27 |
779 |
5027 |
invoice accept: apply |
43.74 |
19486 |
4374 |
invoice accept: cancel |
45.35 |
807 |
4535 |
customer reserve: creation |
4178.01 |
188 |
417801 |
customer reserve: removal |
4398.46 |
56 |
439846 |
realization accept: apply |
86.62 |
184 |
8662 |
realization accept: cancel |
84.78 |
126 |
8478 |
payment from customer: creation |
64.13 |
118 |
6413 |
payment from customer: removal |
6.03 |
75 |
603 |
payment to supplier: creation |
51.04 |
136 |
5104 |
payment to supplier: removal |
3.72 |
88 |
372 |
service: total inventory turnovers |
3.98 |
3780 |
398 |
service: total monetary turnovers |
5.84 |
654 |
584 |
service: aggregate perf. data |
0.98 |
14968 |
98 |
service: refresh index statistics |
0.03 |
250233 |
3 |
Completed "Performance in TOTAL". Done for 00:00:03, from 20-02-2024 13:08:42 to 20-02-2024 13:08:45.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
4664 |
TEST_TIME |
2 |
3133 |
TEST_TIME |
3 |
3884 |
TEST_TIME |
4 |
3841 |
TEST_TIME |
5 |
4474 |
TEST_TIME |
6 |
4924 |
TEST_TIME |
7 |
5069 |
TEST_TIME |
8 |
5152 |
TEST_TIME |
9 |
5281 |
TEST_TIME |
10 |
5427 |
TEST_TIME |
11 |
5781 |
TEST_TIME |
12 |
6069 |
TEST_TIME |
13 |
6250 |
TEST_TIME |
14 |
6393 |
TEST_TIME |
15 |
6693 |
TEST_TIME |
16 |
6853 |
TEST_TIME |
17 |
7057 |
TEST_TIME |
18 |
7242 |
TEST_TIME |
19 |
7408 |
TEST_TIME |
20 |
8320 |
TEST_TIME |
21 |
8707 |
TEST_TIME |
22 |
9330 |
TEST_TIME |
23 |
9619 |
TEST_TIME |
24 |
9516 |
TEST_TIME |
25 |
9774 |
TEST_TIME |
26 |
9956 |
TEST_TIME |
27 |
9852 |
TEST_TIME |
28 |
9653 |
TEST_TIME |
29 |
9861 |
TEST_TIME |
30 |
9877 |
TEST_TIME |
31 |
10213 |
TEST_TIME |
32 |
10241 |
TEST_TIME |
33 |
10206 |
TEST_TIME |
34 |
10075 |
TEST_TIME |
35 |
9926 |
TEST_TIME |
36 |
9797 |
TEST_TIME |
37 |
9719 |
TEST_TIME |
38 |
9769 |
TEST_TIME |
39 |
9722 |
TEST_TIME |
40 |
9673 |
TEST_TIME |
41 |
9615 |
TEST_TIME |
42 |
9650 |
TEST_TIME |
43 |
9724 |
TEST_TIME |
44 |
9617 |
TEST_TIME |
45 |
9671 |
TEST_TIME |
46 |
9636 |
TEST_TIME |
47 |
9514 |
TEST_TIME |
48 |
9559 |
TEST_TIME |
49 |
9497 |
TEST_TIME |
50 |
9433 |
TEST_TIME |
51 |
9361 |
TEST_TIME |
52 |
9339 |
TEST_TIME |
53 |
9346 |
TEST_TIME |
54 |
9335 |
TEST_TIME |
55 |
9350 |
TEST_TIME |
56 |
9410 |
TEST_TIME |
57 |
9514 |
TEST_TIME |
58 |
9511 |
TEST_TIME |
59 |
9510 |
TEST_TIME |
60 |
9529 |
TEST_TIME |
61 |
9672 |
TEST_TIME |
62 |
9708 |
TEST_TIME |
63 |
9809 |
TEST_TIME |
64 |
9827 |
TEST_TIME |
65 |
9778 |
TEST_TIME |
66 |
9705 |
TEST_TIME |
67 |
9599 |
TEST_TIME |
68 |
9574 |
TEST_TIME |
69 |
9519 |
TEST_TIME |
70 |
9413 |
TEST_TIME |
71 |
9451 |
TEST_TIME |
72 |
9399 |
TEST_TIME |
73 |
9388 |
TEST_TIME |
74 |
9348 |
TEST_TIME |
75 |
9408 |
TEST_TIME |
76 |
9405 |
TEST_TIME |
77 |
9386 |
TEST_TIME |
78 |
9365 |
TEST_TIME |
79 |
9478 |
TEST_TIME |
80 |
9464 |
TEST_TIME |
81 |
9502 |
TEST_TIME |
82 |
9475 |
TEST_TIME |
83 |
9519 |
TEST_TIME |
84 |
9541 |
TEST_TIME |
85 |
9598 |
TEST_TIME |
86 |
9491 |
TEST_TIME |
87 |
9406 |
TEST_TIME |
88 |
9384 |
TEST_TIME |
89 |
9319 |
TEST_TIME |
90 |
9337 |
TEST_TIME |
91 |
9294 |
TEST_TIME |
92 |
9289 |
TEST_TIME |
93 |
9285 |
TEST_TIME |
94 |
9261 |
TEST_TIME |
95 |
9299 |
TEST_TIME |
96 |
9391 |
TEST_TIME |
97 |
9375 |
TEST_TIME |
98 |
9351 |
TEST_TIME |
99 |
9343 |
TEST_TIME |
100 |
9325 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 20-02-2024 13:08:46 to 20-02-2024 13:08:49.
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 |
1314769 |
1314769 |
0 |
0.00 |
0 |
22249 |
7 |
0 |
0 |
doc_list_biud |
1314768 |
1314768 |
0 |
0.00 |
0 |
61341 |
24 |
0 |
0 |
sp_add_invoice_to_stock |
4522 |
4374 |
148 |
3.27 |
51 |
199258 |
19487 |
0 |
148 |
sp_cancel_adding_invoice |
4535 |
4535 |
0 |
0.00 |
4 |
63489 |
808 |
0 |
0 |
sp_cancel_client_order |
1590 |
1590 |
0 |
0.00 |
4 |
12597 |
381 |
0 |
0 |
sp_cancel_customer_reserve |
439846 |
439846 |
0 |
0.00 |
0 |
61343 |
57 |
0 |
0 |
sp_cancel_pay_from_customer |
603 |
603 |
0 |
0.00 |
3 |
2273 |
75 |
0 |
0 |
sp_cancel_pay_to_supplier |
372 |
372 |
0 |
0.00 |
2 |
5284 |
89 |
0 |
0 |
sp_cancel_supplier_invoice |
5036 |
5027 |
9 |
0.17 |
1 |
19747 |
780 |
0 |
9 |
sp_cancel_supplier_order |
369 |
369 |
0 |
0.00 |
6 |
1031462 |
86026 |
0 |
0 |
sp_cancel_write_off |
8478 |
8478 |
0 |
0.00 |
1 |
13452 |
126 |
0 |
0 |
sp_client_order |
18045 |
18045 |
0 |
0.00 |
3 |
61416 |
419 |
0 |
0 |
sp_customer_reserve |
417801 |
417801 |
0 |
0.00 |
0 |
40148 |
189 |
0 |
0 |
sp_fill_shopping_cart |
27638 |
27638 |
0 |
0.00 |
1 |
20506 |
40 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
417793 |
417793 |
0 |
0.00 |
0 |
33615 |
16 |
0 |
0 |
sp_get_clo_for_invoice |
4364 |
4364 |
0 |
0.00 |
0 |
18598 |
315 |
0 |
0 |
sp_kill_cost_storno |
13988 |
13988 |
0 |
0.00 |
0 |
22240 |
77 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
893566 |
893566 |
0 |
0.00 |
0 |
61338 |
31 |
0 |
0 |
sp_kill_qty_storno |
472870 |
472870 |
0 |
0.00 |
0 |
61341 |
67 |
0 |
0 |
sp_lock_selected_doc |
18138 |
18138 |
0 |
0.00 |
0 |
7079 |
4 |
0 |
0 |
sp_make_cost_storno |
24543 |
24543 |
0 |
0.00 |
0 |
14336 |
61 |
0 |
0 |
sp_multiply_rows_for_pdistr |
24542 |
24542 |
0 |
0.00 |
0 |
8831 |
34 |
0 |
0 |
sp_multiply_rows_for_qdistr |
18045 |
18045 |
0 |
0.00 |
0 |
61357 |
233 |
0 |
0 |
sp_pay_from_customer |
6413 |
6413 |
0 |
0.00 |
4 |
14342 |
119 |
0 |
0 |
sp_pay_to_supplier |
5104 |
5104 |
0 |
0.00 |
4 |
13204 |
136 |
0 |
0 |
sp_payment_common |
11517 |
11517 |
0 |
0.00 |
1 |
7957 |
21 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1590 |
1590 |
0 |
0.00 |
0 |
12587 |
351 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
8898 |
8898 |
0 |
0.00 |
0 |
17895 |
301 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8662 |
8662 |
0 |
0.00 |
0 |
16956 |
54 |
0 |
0 |
sp_reserve_write_off |
8662 |
8662 |
0 |
0.00 |
6 |
16982 |
184 |
0 |
0 |
sp_supplier_invoice |
4879 |
4879 |
0 |
0.00 |
5 |
106740 |
3366 |
0 |
0 |
sp_supplier_order |
4723 |
4723 |
0 |
0.00 |
5 |
51270 |
1289 |
0 |
0 |
srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
1736 |
246290 |
14969 |
0 |
0 |
srv_fill_mon_cache_memory |
53 |
53 |
0 |
0.00 |
1883 |
149680 |
44339 |
0 |
0 |
srv_find_qd_qs_mism |
887578 |
887578 |
0 |
0.00 |
0 |
18939 |
6 |
0 |
0 |
srv_make_invnt_saldo |
398 |
398 |
0 |
0.00 |
44 |
102408 |
3781 |
0 |
0 |
srv_make_money_saldo |
584 |
584 |
0 |
0.00 |
1 |
20840 |
655 |
0 |
0 |
srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
110740 |
405558 |
250233 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
148 |
148 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
9 |
9 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4374 |
4374 |
0 |
0.00 |
0 |
6668 |
162 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
341 |
341 |
0 |
0.00 |
0 |
2321 |
79 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1590 |
1590 |
0 |
0.00 |
0 |
5167 |
15 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
603 |
603 |
0 |
0.00 |
0 |
4683 |
16 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
603 |
603 |
0 |
0.00 |
0 |
241 |
2 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
372 |
372 |
0 |
0.00 |
0 |
1272 |
8 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
370 |
370 |
0 |
0.00 |
0 |
1661 |
21 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
369 |
369 |
0 |
0.00 |
0 |
23599 |
1466 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
865 |
865 |
0 |
0.00 |
0 |
950 |
5 |
0 |
0 |
t$perf-norm:sp_client_order |
18045 |
18045 |
0 |
0.00 |
0 |
4728 |
14 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
870 |
870 |
0 |
0.00 |
0 |
1012 |
6 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6413 |
6413 |
0 |
0.00 |
0 |
4895 |
11 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5104 |
5104 |
0 |
0.00 |
0 |
7094 |
10 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8662 |
8662 |
0 |
0.00 |
0 |
3227 |
7 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4879 |
4879 |
0 |
0.00 |
0 |
7062 |
14 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4723 |
4723 |
0 |
0.00 |
0 |
3349 |
13 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
0 |
522 |
14 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
53 |
53 |
0 |
0.00 |
0 |
1149 |
29 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
398 |
398 |
0 |
0.00 |
0 |
883 |
17 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
584 |
584 |
0 |
0.00 |
0 |
843 |
7 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
3 |
3 |
0 |
0.00 |
1 |
7 |
4 |
0 |
0 |
v_add_invoice_to_stock |
9018 |
8722 |
296 |
3.28 |
0 |
6790 |
18 |
0 |
296 |
v_all_customers |
33940 |
33940 |
0 |
0.00 |
0 |
47 |
1 |
0 |
0 |
v_all_suppliers |
27268 |
27268 |
0 |
0.00 |
0 |
32 |
1 |
0 |
0 |
v_all_wares |
36080 |
36080 |
0 |
0.00 |
0 |
109 |
1 |
0 |
0 |
v_cancel_adding_invoice |
682 |
682 |
0 |
0.00 |
0 |
693 |
8 |
0 |
0 |
v_cancel_client_order |
3180 |
3180 |
0 |
0.00 |
0 |
3187 |
6 |
0 |
0 |
v_cancel_customer_prepayment |
1206 |
1206 |
0 |
0.00 |
0 |
1419 |
6 |
0 |
0 |
v_cancel_customer_reserve |
1206 |
1206 |
0 |
0.00 |
0 |
3442 |
8 |
0 |
0 |
v_cancel_payment_to_supplier |
744 |
744 |
0 |
0.00 |
0 |
1790 |
7 |
0 |
0 |
v_cancel_supplier_invoice |
758 |
740 |
18 |
2.37 |
0 |
553 |
15 |
0 |
18 |
v_cancel_supplier_order |
738 |
738 |
0 |
0.00 |
0 |
3061 |
8 |
0 |
0 |
v_cancel_write_off |
1730 |
1730 |
0 |
0.00 |
0 |
4808 |
16 |
0 |
0 |
v_max_id_clo_ord |
4720 |
4720 |
0 |
0.00 |
0 |
786 |
1 |
0 |
0 |
v_max_id_clo_res |
870 |
870 |
0 |
0.00 |
0 |
8179 |
29 |
0 |
0 |
v_max_id_ord_sup |
4878 |
4878 |
0 |
0.00 |
0 |
7308 |
6 |
0 |
0 |
v_max_non_paid_invoice |
1068 |
1068 |
0 |
0.00 |
0 |
602 |
3 |
0 |
0 |
v_max_non_paid_realizn |
3029 |
3029 |
0 |
0.00 |
0 |
1009 |
4 |
0 |
0 |
v_min_id_clo_ord |
4720 |
4720 |
0 |
0.00 |
0 |
3400 |
8 |
0 |
0 |
v_min_id_clo_res |
870 |
870 |
0 |
0.00 |
0 |
11328 |
18 |
0 |
0 |
v_min_id_ord_sup |
4878 |
4878 |
0 |
0.00 |
0 |
5897 |
8 |
0 |
0 |
v_min_non_paid_invoice |
5104 |
5104 |
0 |
0.00 |
0 |
7952 |
14 |
0 |
0 |
v_min_non_paid_realizn |
6413 |
6413 |
0 |
0.00 |
0 |
5717 |
14 |
0 |
0 |
v_our_firm |
8908 |
8908 |
0 |
0.00 |
0 |
101 |
1 |
0 |
0 |
v_reserve_write_off |
17324 |
17324 |
0 |
0.00 |
0 |
3267 |
7 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9192 |
9192 |
0 |
0.00 |
0 |
15245 |
100 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
369 |
369 |
0 |
0.00 |
0 |
22574 |
348 |
0 |
0 |
x_make_qstorno_1000_1200 |
4723 |
4723 |
0 |
0.00 |
1 |
51263 |
1214 |
0 |
0 |
x_make_qstorno_1200_2000 |
4879 |
4879 |
0 |
0.00 |
2 |
101238 |
3212 |
0 |
0 |
x_make_qstorno_2100_3300 |
417801 |
417801 |
0 |
0.00 |
0 |
37245 |
170 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2024 13:08:50 to 20-02-2024 13:08:54.
Fields:
page cache memo used = page cache total size, bytes:
memo used, total = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
memo allocated, total = the same of mon$memory_usage.mon$memory_allocated;
metadata cache memo used = metadata cache, bytes;
metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
total attachments cnt = total number of attachments, regardless of state;
active attachments cnt = number of attachments with mon$state = 1;
running statements cnt = number of statements that are operating with data from page cache (mon$state = 1);
stalled statements cnt = number of statements that are waiting for client request for fetching ( mon$state = 2);
memo used by attachments = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
memo used by transactions = the same of transaction level (mon$stat_group = 2);
memo used by statements = the same of statement level (mon$stat_group = 3);
Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts |
measurement duration ms |
page cache memo used |
memo used, total |
memo allocated, total |
metadata cache |
metadata cache percent of total |
total attachments cnt |
active attachments cnt |
running statements cnt |
stalled statements cnt |
memo used by attachments |
memo used by transactions |
memo used by statements |
11:07:52 |
1 |
8192000000 |
8796669328 |
8807108608 |
3187328 |
0.038 |
1 |
1 |
2 |
0 |
3284944 |
61840 |
35776 |
11:08:53 |
26484 |
8192000000 |
9726239360 |
10027134976 |
802842112 |
8.925 |
100 |
91 |
180 |
0 |
833130896 |
7974784 |
22314000 |
11:10:26 |
17787 |
8192000000 |
9767766864 |
10077970432 |
846731648 |
9.367 |
100 |
92 |
181 |
0 |
879852928 |
11483920 |
21637360 |
11:11:46 |
16697 |
8192000000 |
9798326656 |
10117472256 |
872582336 |
9.626 |
100 |
80 |
157 |
1 |
907902864 |
17741504 |
17579024 |
11:13:13 |
16860 |
8192000000 |
9866538080 |
10195447808 |
908416464 |
9.982 |
100 |
80 |
158 |
0 |
965937424 |
40214048 |
17306912 |
11:14:38 |
7381 |
8192000000 |
9910236848 |
10251456512 |
944574016 |
10.338 |
100 |
84 |
168 |
0 |
1019144384 |
56740336 |
17830032 |
11:15:46 |
3334 |
8192000000 |
9948660464 |
10298060800 |
974689152 |
10.632 |
100 |
81 |
158 |
0 |
1067985840 |
77291936 |
16004752 |
11:16:52 |
2700 |
8192000000 |
9962447840 |
10322882560 |
1003621744 |
10.914 |
100 |
78 |
156 |
1 |
1076815552 |
57360640 |
15833168 |
11:17:57 |
5824 |
8192000000 |
10003710608 |
10369855488 |
1025299984 |
11.123 |
100 |
85 |
168 |
0 |
1112576864 |
70252736 |
17024144 |
11:19:05 |
1423 |
8192000000 |
10015088240 |
10386771968 |
1050588336 |
11.366 |
100 |
84 |
168 |
1 |
1130047600 |
62657552 |
16801712 |
11:20:09 |
8972 |
8192000000 |
10024715824 |
10409066496 |
1063625872 |
11.491 |
100 |
67 |
135 |
0 |
1137652976 |
60348128 |
13678976 |
11:21:19 |
3448 |
8192000000 |
9984188160 |
10374123520 |
1067142816 |
11.525 |
100 |
47 |
95 |
0 |
1104419424 |
26445440 |
10831168 |
11:22:25 |
3645 |
8192000000 |
9997881744 |
10397609984 |
1076567840 |
11.615 |
100 |
36 |
72 |
0 |
1120820576 |
37153056 |
7099680 |
11:23:35 |
6304 |
8192000000 |
10001241776 |
10405154816 |
1082597744 |
11.672 |
100 |
26 |
52 |
0 |
1121456480 |
33003920 |
5854816 |
11:24:43 |
37827 |
8192000000 |
10006896496 |
10403577856 |
1095613696 |
11.796 |
100 |
46 |
90 |
0 |
1118121984 |
12116288 |
10392000 |
11:26:50 |
4137 |
8192000000 |
10020818640 |
10427707392 |
1099058656 |
11.829 |
100 |
44 |
88 |
1 |
1133848064 |
25465968 |
9323440 |
11:27:57 |
38129 |
8192000000 |
10025389472 |
10427973632 |
1092325264 |
11.765 |
99 |
42 |
84 |
1 |
1125603920 |
23560416 |
9718240 |
11:29:38 |
95415 |
8192000000 |
10089409840 |
10501959680 |
1105170048 |
11.887 |
100 |
41 |
81 |
0 |
1205821120 |
92364416 |
8286656 |
11:32:41 |
36846 |
8192000000 |
10083635616 |
10513448960 |
1112900352 |
11.960 |
99 |
33 |
64 |
0 |
1199231264 |
79304480 |
7026432 |
11:34:21 |
11081 |
8192000000 |
10146672960 |
10548703232 |
1120696944 |
12.034 |
99 |
53 |
104 |
0 |
1248834496 |
117482480 |
10655072 |
11:35:36 |
7200 |
8192000000 |
10173028368 |
10574950400 |
1132676000 |
12.147 |
100 |
55 |
110 |
0 |
1274931056 |
129687488 |
12567568 |
11:36:46 |
49477 |
8192000000 |
10178906528 |
10590646272 |
1095920576 |
11.799 |
96 |
33 |
66 |
0 |
1259431504 |
155561152 |
7949776 |
11:38:39 |
5520 |
8192000000 |
10171003552 |
10573832192 |
1122891632 |
12.054 |
100 |
50 |
100 |
1 |
1276332016 |
142465744 |
10974640 |
11:39:48 |
4447 |
8192000000 |
10218785424 |
10606911488 |
1103881808 |
11.874 |
100 |
66 |
132 |
0 |
1320280992 |
201344784 |
15054400 |
11:40:58 |
7181 |
8192000000 |
10209105104 |
10621497344 |
1094055360 |
11.781 |
99 |
53 |
101 |
1 |
1308916128 |
203609664 |
11251104 |
11:42:11 |
8100 |
8192000000 |
10261362912 |
10655600640 |
1107131312 |
11.905 |
100 |
71 |
142 |
1 |
1356644640 |
233982592 |
15530736 |
11:43:34 |
4832 |
8192000000 |
10234143968 |
10641649664 |
1113539120 |
11.966 |
100 |
54 |
105 |
2 |
1338515632 |
212826208 |
12150304 |
11:44:48 |
1883 |
8192000000 |
10260684576 |
10653573120 |
1103222176 |
11.868 |
100 |
81 |
161 |
1 |
1365368336 |
244177632 |
17968528 |
11:45:58 |
5437 |
8192000000 |
10321739760 |
10741567488 |
1111261552 |
11.944 |
100 |
42 |
82 |
0 |
1423864848 |
302548992 |
10054304 |
11:47:13 |
2810 |
8192000000 |
10314003904 |
10754281472 |
1116326272 |
11.992 |
100 |
71 |
141 |
1 |
1426581376 |
294231760 |
16023344 |
11:48:20 |
4681 |
8192000000 |
10244755744 |
10665201664 |
1131951760 |
12.140 |
100 |
54 |
107 |
0 |
1344097280 |
200622016 |
11523504 |
11:49:29 |
3595 |
8192000000 |
10191166304 |
10604310528 |
1145915520 |
12.271 |
100 |
42 |
82 |
0 |
1294241584 |
139554736 |
8771328 |
11:50:33 |
42071 |
8192000000 |
10114987136 |
10528014336 |
1119319040 |
12.021 |
98 |
41 |
80 |
0 |
1186637168 |
59226384 |
8091744 |
11:52:17 |
56587 |
8192000000 |
10067602576 |
10578624512 |
1131533376 |
12.136 |
99 |
8 |
16 |
0 |
1212524000 |
79316480 |
1674144 |
11:54:15 |
34768 |
8192000000 |
10125575680 |
10549862400 |
1139121456 |
12.207 |
100 |
27 |
51 |
0 |
1174893760 |
29545488 |
6226816 |
11:55:53 |
31014 |
8192000000 |
10226171520 |
10675363840 |
1161355904 |
12.416 |
100 |
22 |
45 |
0 |
1293851936 |
127307456 |
5188576 |
11:57:31 |
52972 |
8192000000 |
10163253024 |
10623492096 |
1150281264 |
12.312 |
100 |
20 |
40 |
0 |
1290980592 |
136650880 |
4048448 |
11:59:30 |
23063 |
8192000000 |
10065259840 |
10519867392 |
1114858144 |
11.978 |
97 |
15 |
31 |
0 |
1173222096 |
55352032 |
3011920 |
12:01:05 |
49785 |
8192000000 |
10093177264 |
10525933568 |
1146525840 |
12.277 |
100 |
20 |
40 |
0 |
1196330528 |
45764704 |
4039984 |
12:02:58 |
81604 |
8192000000 |
10141717024 |
10619744256 |
1155747744 |
12.363 |
100 |
37 |
72 |
1 |
1232613264 |
68343904 |
8521616 |
12:05:23 |
44814 |
8192000000 |
10082399600 |
10545672192 |
1155175280 |
12.358 |
100 |
34 |
67 |
0 |
1213094176 |
50707072 |
7211824 |
12:07:11 |
29005 |
8192000000 |
10129258032 |
10567061504 |
1158927808 |
12.393 |
100 |
13 |
26 |
0 |
1239628384 |
77743056 |
2957520 |
12:08:41 |
27130 |
8192000000 |
10129307200 |
10580430848 |
1138375360 |
12.200 |
99 |
29 |
57 |
0 |
1236447248 |
91506112 |
6565776 |
12:10:09 |
23838 |
8192000000 |
10077643392 |
10571227136 |
1144965536 |
12.262 |
100 |
11 |
22 |
0 |
1198846384 |
51808464 |
2072384 |
12:11:35 |
87778 |
8192000000 |
10088187392 |
10561478656 |
1100992016 |
11.847 |
95 |
21 |
42 |
0 |
1176017648 |
70243136 |
4782496 |
12:14:05 |
62859 |
8192000000 |
10071358016 |
10578829312 |
1127093920 |
12.094 |
99 |
13 |
26 |
0 |
1210629248 |
80749536 |
2785792 |
12:16:13 |
29299 |
8192000000 |
10066159296 |
10509029376 |
1121641984 |
12.043 |
98 |
26 |
52 |
0 |
1152399088 |
25891136 |
4865968 |
12:17:44 |
53309 |
8192000000 |
10062921024 |
10545430528 |
1117872464 |
12.007 |
98 |
12 |
24 |
0 |
1173675600 |
53650656 |
2152480 |
12:19:44 |
46075 |
8192000000 |
10049096896 |
10506649600 |
1096319648 |
11.803 |
96 |
11 |
22 |
0 |
1127073456 |
28924576 |
1829232 |
12:21:31 |
51025 |
8192000000 |
10041506896 |
10525622272 |
1077777184 |
11.626 |
97 |
12 |
24 |
0 |
1129434304 |
48760208 |
2896912 |
12:23:25 |
19902 |
8192000000 |
10048066208 |
10465427456 |
1068586592 |
11.539 |
97 |
35 |
70 |
0 |
1121779552 |
46531904 |
6661056 |
12:25:21 |
20152 |
8192000000 |
10052393680 |
10466693120 |
1056144624 |
11.420 |
95 |
49 |
97 |
0 |
1115053616 |
49188288 |
9720704 |
12:27:10 |
97123 |
8192000000 |
10064325376 |
10602516480 |
1044824800 |
11.311 |
94 |
16 |
32 |
0 |
1153724416 |
105403232 |
3496384 |
12:30:08 |
52432 |
8192000000 |
10042302192 |
10505633792 |
1085363328 |
11.699 |
98 |
12 |
24 |
0 |
1159065792 |
70999360 |
2703104 |
12:32:05 |
102025 |
8192000000 |
10038352624 |
10468667392 |
1089449792 |
11.737 |
98 |
13 |
26 |
0 |
1130428832 |
38404512 |
2574528 |
12:35:01 |
14475 |
8192000000 |
10050725280 |
10480173056 |
1104182256 |
11.877 |
99 |
39 |
78 |
1 |
1146847456 |
35222912 |
7442288 |
12:36:59 |
69380 |
8192000000 |
10069650288 |
10538061824 |
1120767280 |
12.034 |
100 |
11 |
22 |
0 |
1184889536 |
61533376 |
2588880 |
12:39:10 |
51677 |
8192000000 |
10069874704 |
10527002624 |
1112552432 |
11.957 |
99 |
10 |
20 |
0 |
1144927088 |
30572352 |
1802304 |
12:41:06 |
38754 |
8192000000 |
10084924096 |
10526765056 |
1132692816 |
12.147 |
100 |
26 |
52 |
0 |
1193481616 |
54983984 |
5804816 |
12:42:52 |
88153 |
8192000000 |
10072397456 |
10542284800 |
1137437248 |
12.191 |
100 |
9 |
18 |
1 |
1184177920 |
45623168 |
1117504 |
12:45:36 |
61041 |
8192000000 |
10112105200 |
10594783232 |
1137993728 |
12.197 |
99 |
18 |
36 |
0 |
1223359520 |
81683280 |
3682512 |
12:47:39 |
24172 |
8192000000 |
10084797216 |
10517889024 |
1126000896 |
12.084 |
98 |
43 |
86 |
1 |
1173655136 |
39143312 |
8510928 |
12:49:05 |
149679 |
8192000000 |
10134272960 |
10613129216 |
1145333104 |
12.266 |
99 |
13 |
27 |
0 |
1220813664 |
72785664 |
2694896 |
12:52:35 |
148154 |
8192000000 |
10078625344 |
10520977408 |
1127288192 |
12.096 |
97 |
22 |
45 |
0 |
1172135456 |
40403536 |
4443728 |
12:56:20 |
63760 |
8192000000 |
10101990080 |
10587725824 |
1150332080 |
12.313 |
99 |
6 |
12 |
0 |
1207725760 |
55853936 |
1539744 |
12:58:28 |
24847 |
8192000000 |
10097155664 |
10535755776 |
1158879200 |
12.393 |
100 |
32 |
63 |
1 |
1180781872 |
15707360 |
6195312 |
12:59:57 |
63005 |
8192000000 |
10091450400 |
10554060800 |
1114346640 |
11.974 |
96 |
23 |
46 |
0 |
1168484336 |
49641248 |
4496448 |
13:02:10 |
112997 |
8192000000 |
10060684816 |
10563235840 |
1071651088 |
11.568 |
93 |
13 |
26 |
0 |
1159671632 |
84635232 |
3385312 |
13:06:11 |
34441 |
8192000000 |
10080865280 |
10511704064 |
1061437104 |
11.470 |
94 |
28 |
56 |
0 |
1097397200 |
30541808 |
5418288 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 20-02-2024 13:08:56 to 20-02-2024 13:09:10.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
148 |
v_add_invoice_to_stock |
335544517 |
except |
9 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-02-2024 13:09:11 to 20-02-2024 13:09:13.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 172728
MON$OLDEST_ACTIVE 176331
MON$OLDEST_SNAPSHOT 176331
MON$NEXT_TRANSACTION 176331
MON$PAGE_BUFFERS 1000000
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2020-04-30 07:30:08.6030 GMT
MON$PAGES 1924768
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
MON$CRYPT_STATE 0
MON$GUID {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID 02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT 705
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0
Database "/home/bases/oltp40-etalone.fdb"
Gstat execution time Tue Feb 20 13:09:14 2024
Database header page information:
Flags 0
Generation 92122
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 172728
Oldest active 176331
Oldest snapshot 176331
Next transaction 176332
Sequence number 0
Next attachment ID 705
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 30, 2020 7:30:08
Attributes force write
Variable header data:
Database GUID: {58978C10-B735-40F5-8B7D-F7A1956E782B}
Sweep interval: 0
*END*
Database file sequence:
File /home/bases/oltp40-etalone.fdb is the only file
Analyzing database pages ...
AGENTS (150)
Primary pointer page: 524, Index root page: 525
Total formats: 1, used formats: 1
Average record length: 33.60, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.20, total dup: 0, max dup: 0
Average key length: 15.88, compression ratio: 0.92
Average prefix length: 1.42, average data length: 13.20
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (154)
Primary pointer page: 532, Index root page: 533
Total formats: 1, used formats: 1
Average record length: 108.20, total records: 20
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1235.00, compression ratio: 11.41
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 18.25, total dup: 0, max dup: 0
Average key length: 17.20, compression ratio: 1.24
Average prefix length: 7.05, average data length: 14.25
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_PREDICT_PRIOR (3)
Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.40, total dup: 0, max dup: 0
Average key length: 4.35, compression ratio: 0.67
Average prefix length: 1.20, average data length: 1.70
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 4.30, total dup: 6, max dup: 3
Average key length: 3.25, compression ratio: 0.72
Average prefix length: 1.35, average data length: 1.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20
Average node length: 5.20, total dup: 0, max dup: 0
Average key length: 4.15, compression ratio: 0.65
Average prefix length: 1.10, average data length: 1.60
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (139)
Primary pointer page: 502, Index root page: 503
Total formats: 1, used formats: 1
Average record length: 47.23, total records: 7807604
Average version length: 48.17, total versions: 132957, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 55, data page slots: 88848
Data pages: 88848, average fill: 70%
Primary pages: 88846, secondary pages: 2, swept pages: 28757
Empty pages: 4, full pages: 82104
Fill distribution:
0 - 19% = 7
20 - 39% = 16
40 - 59% = 416
60 - 79% = 88331
80 - 99% = 78
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510636, depth: 3, leaf buckets: 23395, nodes: 7807604
Average node length: 18.91, total dup: 0, max dup: 0
Average key length: 15.92, compression ratio: 1.70
Average prefix length: 14.08, average data length: 12.92
Clustering factor: 1710109, ratio: 0.22
Fill distribution:
0 - 19% = 350
20 - 39% = 1667
40 - 59% = 4259
60 - 79% = 2412
80 - 99% = 14707
Index DOC_DATA_ID_DESC (1)
Root page: 1528140, depth: 3, leaf buckets: 13567, nodes: 7807604
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: 1533928, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1466
40 - 59% = 2144
60 - 79% = 1100
80 - 99% = 8857
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546735, depth: 3, leaf buckets: 8400, nodes: 7807604
Average node length: 6.63, total dup: 5823874, max dup: 49
Average key length: 3.64, compression ratio: 2.47
Average prefix length: 7.61, average data length: 1.39
Clustering factor: 1526734, ratio: 0.20
Fill distribution:
0 - 19% = 144
20 - 39% = 896
40 - 59% = 1479
60 - 79% = 871
80 - 99% = 5010
DOC_LIST (138)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 56.00, total records: 2275396
Average version length: 58.84, total versions: 68520, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 84.00, compression ratio: 1.50
Pointer pages: 18, data page slots: 28624
Data pages: 28624, average fill: 73%
Primary pages: 28622, secondary pages: 2, swept pages: 7021
Empty pages: 6, full pages: 26929
Fill distribution:
0 - 19% = 17
20 - 39% = 34
40 - 59% = 254
60 - 79% = 28178
80 - 99% = 141
Index DOC_LIST_ID_DESC (1)
Root page: 1541152, depth: 3, leaf buckets: 4582, nodes: 2275396
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: 691838, ratio: 0.30
Fill distribution:
0 - 19% = 1
20 - 39% = 853
40 - 59% = 909
60 - 79% = 723
80 - 99% = 2096
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544398, depth: 3, leaf buckets: 2405, nodes: 2277289
Average node length: 4.97, total dup: 2276390, max dup: 20508
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1281232, ratio: 0.56
Fill distribution:
0 - 19% = 3
20 - 39% = 158
40 - 59% = 1369
60 - 79% = 590
80 - 99% = 285
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545933, depth: 3, leaf buckets: 1768, nodes: 2275396
Average node length: 4.97, total dup: 2275346, max dup: 130231
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1071739, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 612
60 - 79% = 44
80 - 99% = 1106
Index PK_DOC_LIST (0)
Root page: 1538209, depth: 3, leaf buckets: 4361, nodes: 2275396
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: 691838, ratio: 0.30
Fill distribution:
0 - 19% = 103
20 - 39% = 528
40 - 59% = 657
60 - 79% = 793
80 - 99% = 2280
DOC_STATES (149)
Primary pointer page: 522, Index root page: 523
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (155)
Primary pointer page: 534, Index root page: 535
Total formats: 2, used formats: 2
Average record length: 57.88, total records: 2182
Average version length: 79.61, total versions: 757, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 270.43, compression ratio: 4.67
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 72%
Primary pages: 39, secondary pages: 1, swept pages: 0
Empty pages: 4, full pages: 34
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 22
80 - 99% = 12
Index FB_ERRORS_GDS_CODE (0)
Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182
Average node length: 4.40, total dup: 756, max dup: 1
Average key length: 2.67, compression ratio: 1.87
Average prefix length: 4.33, average data length: 0.67
Clustering factor: 1518, ratio: 0.70
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
INVNT_SALDO (145)
Primary pointer page: 514, Index root page: 515
Total formats: 2, used formats: 1
Average record length: 83.39, total records: 400
Average version length: 27.74, total versions: 2531, max versions: 7
Average fragment length: 2.00, total fragments: 4, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.25
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 60%
Primary pages: 9, secondary pages: 23, swept pages: 0
Empty pages: 4, full pages: 16
Fill distribution:
0 - 19% = 8
20 - 39% = 3
40 - 59% = 2
60 - 79% = 3
80 - 99% = 16
Index PK_INVNT_SALDO (0)
Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 326, ratio: 0.81
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (153)
Primary pointer page: 530, Index root page: 531
Total formats: 1, used formats: 1
Average record length: 15.64, total records: 89283
Average version length: 68.29, total versions: 79293, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 5.63
Pointer pages: 7, data page slots: 2928
Data pages: 2160, average fill: 56%
Primary pages: 2159, secondary pages: 1, swept pages: 0
Empty pages: 411, full pages: 931
Fill distribution:
0 - 19% = 536
20 - 39% = 201
40 - 59% = 259
60 - 79% = 349
80 - 99% = 815
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1702987, depth: 3, leaf buckets: 353, nodes: 89283
Average node length: 13.53, total dup: 6069, max dup: 2
Average key length: 10.77, compression ratio: 2.51
Average prefix length: 19.16, average data length: 7.84
Clustering factor: 67799, ratio: 0.76
Fill distribution:
0 - 19% = 1
20 - 39% = 173
40 - 59% = 148
60 - 79% = 31
80 - 99% = 0
MONEY_SALDO (141)
Primary pointer page: 506, Index root page: 507
Total formats: 1, used formats: 1
Average record length: 15.27, total records: 49
Average version length: 9.00, total versions: 324, max versions: 13
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: 6
Data pages: 6, average fill: 21%
Primary pages: 1, secondary pages: 5, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index PK_MONEY_SALDO (0)
Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (140)
Primary pointer page: 504, Index root page: 505
Total formats: 1, used formats: 1
Average record length: 10.45, total records: 1547
Average version length: 43.16, total versions: 1480, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 5.55
Pointer pages: 1, data page slots: 40
Data pages: 32, average fill: 53%
Primary pages: 31, secondary pages: 1, swept pages: 1
Empty pages: 3, full pages: 14
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 4
60 - 79% = 3
80 - 99% = 12
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 93065, depth: 2, leaf buckets: 3, nodes: 1547
Average node length: 4.22, total dup: 1449, max dup: 138
Average key length: 2.66, compression ratio: 7.14
Average prefix length: 18.40, average data length: 0.60
Clustering factor: 879, ratio: 0.57
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MON_CACHE_MEMORY (165)
Primary pointer page: 555, Index root page: 556
Total formats: 2, used formats: 1
Average record length: 97.58, total records: 69
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: 48%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_MON_CACHE_MEMORY (0)
Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 69
Average node length: 11.71, total dup: 0, max dup: 0
Average key length: 10.70, compression ratio: 0.84
Average prefix length: 1.29, average data length: 7.71
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 548, Index root page: 549
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (163)
Primary pointer page: 550, Index root page: 551
Total formats: 2, used formats: 1
Average record length: 67.13, total records: 30
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 611.00, compression ratio: 9.10
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.50, total dup: 23, max dup: 4
Average key length: 2.47, compression ratio: 3.24
Average prefix length: 7.53, average data length: 0.47
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 2.00, total dup: 29, max dup: 29
Average key length: 1.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 3.33, total dup: 29, max dup: 29
Average key length: 2.30, compression ratio: 3.91
Average prefix length: 8.70, average data length: 0.30
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 12.90, total dup: 0, max dup: 0
Average key length: 11.87, compression ratio: 1.42
Average prefix length: 7.63, average data length: 9.20
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30
Average node length: 8.37, total dup: 0, max dup: 0
Average key length: 7.33, compression ratio: 1.23
Average prefix length: 4.63, average data length: 4.37
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (136)
Primary pointer page: 496, Index root page: 497
Total formats: 2, used formats: 1
Average record length: 67.56, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 386.00, compression ratio: 5.71
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (146)
Primary pointer page: 516, Index root page: 517
Total formats: 1, used formats: 1
Average record length: 35.54, total records: 852158
Average version length: 37.88, total versions: 42672, max versions: 3
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.52
Pointer pages: 6, data page slots: 8792
Data pages: 8792, average fill: 66%
Primary pages: 8789, secondary pages: 3, swept pages: 977
Empty pages: 36, full pages: 8009
Fill distribution:
0 - 19% = 66
20 - 39% = 61
40 - 59% = 212
60 - 79% = 8385
80 - 99% = 68
Index PDISTR_AGENT_ID (2)
Root page: 1509330, depth: 2, leaf buckets: 892, nodes: 825361
Average node length: 4.88, total dup: 825312, max dup: 158680
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 92967, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 135
40 - 59% = 475
60 - 79% = 183
80 - 99% = 97
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508635, depth: 3, leaf buckets: 1020, nodes: 825361
Average node length: 5.89, total dup: 734872, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 165155, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 40
40 - 59% = 673
60 - 79% = 74
80 - 99% = 233
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509209, depth: 3, leaf buckets: 1060, nodes: 825361
Average node length: 5.89, total dup: 734872, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 167096, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 88
40 - 59% = 690
60 - 79% = 68
80 - 99% = 214
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510200, depth: 3, leaf buckets: 1159, nodes: 825361
Average node length: 5.97, total dup: 734872, max dup: 42
Average key length: 3.10, compression ratio: 5.48
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 159150, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 232
40 - 59% = 607
60 - 79% = 231
80 - 99% = 88
PERF_AGG (158)
Primary pointer page: 540, Index root page: 541
Total formats: 1, used formats: 1
Average record length: 62.81, total records: 5469
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 2.95, total fragments: 21, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.03
Pointer pages: 1, data page slots: 96
Data pages: 96, average fill: 56%
Primary pages: 79, secondary pages: 17, swept pages: 52
Empty pages: 14, full pages: 57
Fill distribution:
0 - 19% = 21
20 - 39% = 0
40 - 59% = 3
60 - 79% = 72
80 - 99% = 0
Index PERF_AGG_UNQ (1)
Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5469
Average node length: 5.48, 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: 5208, ratio: 0.95
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 1
80 - 99% = 1
Index PK_PERF_AGG (0)
Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5469
Average node length: 11.11, total dup: 0, max dup: 0
Average key length: 9.21, compression ratio: 0.98
Average prefix length: 2.79, average data length: 6.21
Clustering factor: 153, ratio: 0.03
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
PERF_ESTIMATED (280)
Primary pointer page: 399, Index root page: 434
Total formats: 1, used formats: 1
Average record length: 39.05, total records: 80182
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 48.00, compression ratio: 1.23
Pointer pages: 1, data page slots: 840
Data pages: 840, average fill: 66%
Primary pages: 840, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 832
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 832
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 34030, depth: 2, leaf buckets: 104, nodes: 80182
Average node length: 10.16, total dup: 0, max dup: 0
Average key length: 8.17, compression ratio: 1.10
Average prefix length: 3.83, average data length: 5.17
Clustering factor: 3213, ratio: 0.04
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 100
PERF_ISQL_STAT (156)
Primary pointer page: 536, Index root page: 537
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (159)
Primary pointer page: 542, Index root page: 543
Total formats: 1, used formats: 1
Average record length: 111.63, total records: 71
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1691.00, compression ratio: 15.15
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 56%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
PERF_SPLIT_0 (281)
Primary pointer page: 601, Index root page: 602
Total formats: 1, used formats: 1
Average record length: 144.10, total records: 172062
Average version length: 152.85, total versions: 8555, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.77
Pointer pages: 7, data page slots: 5024
Data pages: 4272, average fill: 84%
Primary pages: 4269, secondary pages: 3, swept pages: 4
Empty pages: 33, full pages: 4216
Fill distribution:
0 - 19% = 34
20 - 39% = 2
40 - 59% = 15
60 - 79% = 5
80 - 99% = 4216
PERF_SPLIT_1 (282)
Primary pointer page: 603, Index root page: 604
Total formats: 1, used formats: 1
Average record length: 141.40, total records: 159201
Average version length: 153.12, total versions: 10861, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.99
Pointer pages: 6, data page slots: 4248
Data pages: 3936, average fill: 84%
Primary pages: 3934, secondary pages: 2, swept pages: 2
Empty pages: 18, full pages: 3909
Fill distribution:
0 - 19% = 23
20 - 39% = 1
40 - 59% = 1
60 - 79% = 2
80 - 99% = 3909
PERF_SPLIT_2 (283)
Primary pointer page: 605, Index root page: 606
Total formats: 1, used formats: 1
Average record length: 148.85, total records: 156468
Average version length: 149.42, total versions: 2556, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.39
Pointer pages: 7, data page slots: 4168
Data pages: 3872, average fill: 83%
Primary pages: 3870, secondary pages: 2, swept pages: 4
Empty pages: 25, full pages: 3838
Fill distribution:
0 - 19% = 27
20 - 39% = 2
40 - 59% = 3
60 - 79% = 2
80 - 99% = 3838
PERF_SPLIT_3 (284)
Primary pointer page: 607, Index root page: 608
Total formats: 1, used formats: 1
Average record length: 131.68, total records: 175056
Average version length: 154.51, total versions: 23863, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.88
Pointer pages: 8, data page slots: 5256
Data pages: 4368, average fill: 84%
Primary pages: 4365, secondary pages: 3, swept pages: 1
Empty pages: 52, full pages: 4296
Fill distribution:
0 - 19% = 57
20 - 39% = 5
40 - 59% = 3
60 - 79% = 6
80 - 99% = 4297
PERF_SPLIT_4 (285)
Primary pointer page: 609, Index root page: 610
Total formats: 1, used formats: 1
Average record length: 147.35, total records: 169357
Average version length: 150.48, total versions: 4481, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.51
Pointer pages: 7, data page slots: 4872
Data pages: 4216, average fill: 83%
Primary pages: 4214, secondary pages: 2, swept pages: 3
Empty pages: 50, full pages: 4151
Fill distribution:
0 - 19% = 53
20 - 39% = 5
40 - 59% = 3
60 - 79% = 3
80 - 99% = 4152
PERF_SPLIT_5 (286)
Primary pointer page: 611, Index root page: 612
Total formats: 1, used formats: 1
Average record length: 140.72, total records: 168782
Average version length: 153.75, total versions: 12512, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.05
Pointer pages: 7, data page slots: 5520
Data pages: 4224, average fill: 83%
Primary pages: 4221, secondary pages: 3, swept pages: 3
Empty pages: 60, full pages: 4141
Fill distribution:
0 - 19% = 64
20 - 39% = 6
40 - 59% = 6
60 - 79% = 8
80 - 99% = 4140
PERF_SPLIT_6 (287)
Primary pointer page: 613, Index root page: 614
Total formats: 1, used formats: 1
Average record length: 146.31, total records: 162588
Average version length: 152.01, total versions: 5454, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.59
Pointer pages: 7, data page slots: 4600
Data pages: 4016, average fill: 84%
Primary pages: 4014, secondary pages: 2, swept pages: 1
Empty pages: 19, full pages: 3990
Fill distribution:
0 - 19% = 22
20 - 39% = 2
40 - 59% = 0
60 - 79% = 2
80 - 99% = 3990
PERF_SPLIT_7 (288)
Primary pointer page: 615, Index root page: 616
Total formats: 1, used formats: 1
Average record length: 147.14, total records: 160627
Average version length: 152.12, total versions: 4353, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.53
Pointer pages: 6, data page slots: 4920
Data pages: 3992, average fill: 83%
Primary pages: 3990, secondary pages: 2, swept pages: 2
Empty pages: 43, full pages: 3939
Fill distribution:
0 - 19% = 45
20 - 39% = 5
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3939
PERF_SPLIT_8 (289)
Primary pointer page: 617, Index root page: 618
Total formats: 1, used formats: 1
Average record length: 146.95, total records: 163957
Average version length: 151.18, total versions: 4800, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.54
Pointer pages: 6, data page slots: 4456
Data pages: 4048, average fill: 84%
Primary pages: 4046, secondary pages: 2, swept pages: 4
Empty pages: 13, full pages: 4021
Fill distribution:
0 - 19% = 16
20 - 39% = 5
40 - 59% = 3
60 - 79% = 3
80 - 99% = 4021
PERF_SPLIT_9 (290)
Primary pointer page: 619, Index root page: 620
Total formats: 1, used formats: 1
Average record length: 142.87, total records: 159790
Average version length: 152.34, total versions: 9186, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.87
Pointer pages: 7, data page slots: 4856
Data pages: 3992, average fill: 83%
Primary pages: 3990, secondary pages: 2, swept pages: 1
Empty pages: 60, full pages: 3919
Fill distribution:
0 - 19% = 65
20 - 39% = 4
40 - 59% = 0
60 - 79% = 2
80 - 99% = 3921
PHRASES (143)
Primary pointer page: 510, Index root page: 511
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (147)
Primary pointer page: 518, Index root page: 519
Total formats: 1, used formats: 1
Average record length: 51.61, total records: 2107036
Average version length: 52.90, total versions: 54821, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 70.00, compression ratio: 1.36
Pointer pages: 16, data page slots: 25616
Data pages: 25616, average fill: 71%
Primary pages: 25600, secondary pages: 16, swept pages: 9005
Empty pages: 137, full pages: 23800
Fill distribution:
0 - 19% = 265
20 - 39% = 179
40 - 59% = 441
60 - 79% = 24201
80 - 99% = 530
Index PSTORNED_RCV_ID (1)
Root page: 1506208, depth: 3, leaf buckets: 2571, nodes: 2107036
Average node length: 5.44, total dup: 1966582, max dup: 1613
Average key length: 2.49, compression ratio: 3.62
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 183141, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 270
40 - 59% = 1676
60 - 79% = 305
80 - 99% = 315
Index PSTORNED_SND_ID (0)
Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2107036
Average node length: 5.69, total dup: 1891737, max dup: 65
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 377362, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 2423
60 - 79% = 289
80 - 99% = 34
Index PSTORNED_WORKER_ID (2)
Root page: 1508018, depth: 3, leaf buckets: 2085, nodes: 2107036
Average node length: 4.96, total dup: 2106936, max dup: 28617
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 180727, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 142
40 - 59% = 1067
60 - 79% = 429
80 - 99% = 445
RULES_FOR_PDISTR (148)
Primary pointer page: 520, Index root page: 521
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 494, Index root page: 495
Total formats: 1, used formats: 1
Average record length: 97.60, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index SETTINGS_MCODE_WM_UNQ (1)
Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 482, Index root page: 483
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 488, Index root page: 489
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 490, Index root page: 491
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 546, Index root page: 547
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 544, Index root page: 545
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 486, Index root page: 487
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 484, Index root page: 485
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 538, Index root page: 539
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 508, Index root page: 509
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 526, Index root page: 527
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 577, Index root page: 578
Total formats: 1, used formats: 1
Average record length: 40.32, total records: 178777
Average version length: 69.18, total versions: 85802, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.12
Pointer pages: 3, data page slots: 4368
Data pages: 3399, average fill: 64%
Primary pages: 3399, secondary pages: 0, swept pages: 421
Empty pages: 609, full pages: 2606
Fill distribution:
0 - 19% = 749
20 - 39% = 13
40 - 59% = 7
60 - 79% = 962
80 - 99% = 1668
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 104296, depth: 3, leaf buckets: 241, nodes: 178777
Average node length: 6.49, total dup: 155642, max dup: 14
Average key length: 3.90, compression ratio: 10.77
Average prefix length: 40.23, average data length: 1.77
Clustering factor: 31076, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 17
40 - 59% = 108
60 - 79% = 81
80 - 99% = 33
XQD_1000_3300 (178)
Primary pointer page: 581, Index root page: 582
Total formats: 1, used formats: 1
Average record length: 64.30, total records: 7256858
Average version length: 68.79, total versions: 563504, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.96
Pointer pages: 66, data page slots: 106136
Data pages: 106136, average fill: 74%
Primary pages: 106136, secondary pages: 0, swept pages: 8716
Empty pages: 2, full pages: 93738
Fill distribution:
0 - 19% = 27
20 - 39% = 410
40 - 59% = 3313
60 - 79% = 99622
80 - 99% = 2764
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480476, depth: 3, leaf buckets: 10773, nodes: 7256858
Average node length: 6.50, total dup: 6281634, max dup: 29
Average key length: 3.51, compression ratio: 11.96
Average prefix length: 40.62, average data length: 1.38
Clustering factor: 1708815, ratio: 0.24
Fill distribution:
0 - 19% = 6
20 - 39% = 1485
40 - 59% = 5766
60 - 79% = 2952
80 - 99% = 564
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486090, depth: 3, leaf buckets: 8536, nodes: 7256858
Average node length: 5.39, total dup: 6973646, max dup: 181
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1499860, ratio: 0.21
Fill distribution:
0 - 19% = 7
20 - 39% = 1097
40 - 59% = 4497
60 - 79% = 1821
80 - 99% = 1114
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490630, depth: 3, leaf buckets: 8607, nodes: 7256858
Average node length: 5.39, total dup: 6973646, max dup: 181
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1502245, ratio: 0.21
Fill distribution:
0 - 19% = 8
20 - 39% = 1141
40 - 59% = 4560
60 - 79% = 1805
80 - 99% = 1093
XQD_1200_2000 (177)
Primary pointer page: 579, Index root page: 580
Total formats: 1, used formats: 1
Average record length: 66.51, total records: 12243582
Average version length: 68.73, total versions: 494945, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.89
Pointer pages: 108, data page slots: 175240
Data pages: 175240, average fill: 75%
Primary pages: 175239, secondary pages: 1, swept pages: 45890
Empty pages: 4, full pages: 169678
Fill distribution:
0 - 19% = 36
20 - 39% = 338
40 - 59% = 1732
60 - 79% = 169079
80 - 99% = 4055
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495050, depth: 3, leaf buckets: 18462, nodes: 12239324
Average node length: 6.61, total dup: 10673011, max dup: 58
Average key length: 3.42, compression ratio: 12.27
Average prefix length: 40.71, average data length: 1.29
Clustering factor: 2508089, ratio: 0.20
Fill distribution:
0 - 19% = 38
20 - 39% = 2168
40 - 59% = 10488
60 - 79% = 4909
80 - 99% = 859
XQD_2000_3300 (179)
Primary pointer page: 583, Index root page: 584
Total formats: 1, used formats: 1
Average record length: 38.87, total records: 1987423
Average version length: 69.11, total versions: 602590, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.24
Pointer pages: 29, data page slots: 45880
Data pages: 28976, average fill: 69%
Primary pages: 28839, secondary pages: 137, swept pages: 1040
Empty pages: 355, full pages: 27524
Fill distribution:
0 - 19% = 705
20 - 39% = 4137
40 - 59% = 1886
60 - 79% = 13208
80 - 99% = 9040
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479735, depth: 3, leaf buckets: 1888, nodes: 1589238
Average node length: 5.52, total dup: 1525147, max dup: 49
Average key length: 2.55, compression ratio: 16.44
Average prefix length: 41.49, average data length: 0.51
Clustering factor: 108494, ratio: 0.07
Fill distribution:
0 - 19% = 12
20 - 39% = 179
40 - 59% = 904
60 - 79% = 576
80 - 99% = 217
XQD_2100_3300 (180)
Primary pointer page: 585, Index root page: 586
Total formats: 1, used formats: 1
Average record length: 33.13, total records: 1574532
Average version length: 69.05, total versions: 159787, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.80
Pointer pages: 23, data page slots: 36112
Data pages: 28648, average fill: 41%
Primary pages: 28648, secondary pages: 0, swept pages: 5436
Empty pages: 6038, full pages: 14293
Fill distribution:
0 - 19% = 8840
20 - 39% = 3467
40 - 59% = 6242
60 - 79% = 9598
80 - 99% = 501
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479229, depth: 3, leaf buckets: 1161, nodes: 792783
Average node length: 5.89, total dup: 733548, max dup: 75
Average key length: 2.95, compression ratio: 14.22
Average prefix length: 41.12, average data length: 0.88
Clustering factor: 113600, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 317
40 - 59% = 526
60 - 79% = 281
80 - 99% = 36
XQD_3300_3400 (181)
Primary pointer page: 587, Index root page: 588
Total formats: 1, used formats: 1
Average record length: 64.61, total records: 9457500
Average version length: 68.98, total versions: 669450, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.95
Pointer pages: 90, data page slots: 146112
Data pages: 146080, average fill: 70%
Primary pages: 146057, secondary pages: 23, swept pages: 28519
Empty pages: 290, full pages: 107643
Fill distribution:
0 - 19% = 1098
20 - 39% = 5305
40 - 59% = 17163
60 - 79% = 116857
80 - 99% = 5657
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472612, depth: 3, leaf buckets: 13463, nodes: 9450625
Average node length: 6.69, total dup: 7840140, max dup: 29
Average key length: 3.67, compression ratio: 11.46
Average prefix length: 40.50, average data length: 1.50
Clustering factor: 2112555, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 1019
40 - 59% = 6497
60 - 79% = 4993
80 - 99% = 954
XQS_1000_1200 (182)
Primary pointer page: 589, Index root page: 590
Total formats: 1, used formats: 1
Average record length: 82.46, total records: 21153758
Average version length: 82.91, total versions: 22092, 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: 319688
Data pages: 319688, average fill: 81%
Primary pages: 319685, secondary pages: 3, swept pages: 11701
Empty pages: 7, full pages: 319678
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 1
60 - 79% = 48626
80 - 99% = 271053
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426738, depth: 3, leaf buckets: 19200, nodes: 21153758
Average node length: 5.72, total dup: 20672639, max dup: 177
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3285665, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 7784
60 - 79% = 533
80 - 99% = 10878
Index XQS_1000_1200_RCV_ID (3)
Root page: 1457002, depth: 3, leaf buckets: 17197, nodes: 21153758
Average node length: 6.31, total dup: 18590560, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 918156, ratio: 0.04
Fill distribution:
0 - 19% = 3
20 - 39% = 7
40 - 59% = 818
60 - 79% = 277
80 - 99% = 16092
Index XQS_1000_1200_SND_ID (2)
Root page: 1441095, depth: 3, leaf buckets: 20995, nodes: 21153758
Average node length: 6.35, total dup: 18509049, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3579217, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 8075
60 - 79% = 603
80 - 99% = 12314
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413370, depth: 3, leaf buckets: 16069, nodes: 21153758
Average node length: 5.56, total dup: 21153658, max dup: 229841
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 946902, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 2821
60 - 79% = 393
80 - 99% = 12848
XQS_1000_3300 (184)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 77.78, total records: 9853840
Average version length: 82.64, total versions: 621886, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.62
Pointer pages: 107, data page slots: 173616
Data pages: 173592, average fill: 71%
Primary pages: 173560, secondary pages: 32, swept pages: 49483
Empty pages: 458, full pages: 116635
Fill distribution:
0 - 19% = 1583
20 - 39% = 7612
40 - 59% = 23824
60 - 79% = 112319
80 - 99% = 28254
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367524, depth: 3, leaf buckets: 11359, nodes: 9853840
Average node length: 5.37, total dup: 9544561, max dup: 267
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 2209559, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 63
40 - 59% = 7628
60 - 79% = 3571
80 - 99% = 92
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379283, depth: 3, leaf buckets: 13768, nodes: 9853840
Average node length: 6.24, total dup: 8170991, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1549423, ratio: 0.16
Fill distribution:
0 - 19% = 157
20 - 39% = 4004
40 - 59% = 4487
60 - 79% = 2626
80 - 99% = 2494
Index XQS_1000_3300_SND_ID (2)
Root page: 1373081, depth: 3, leaf buckets: 12677, nodes: 9853840
Average node length: 5.98, total dup: 8561760, max dup: 44
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 2404759, ratio: 0.24
Fill distribution:
0 - 19% = 3
20 - 39% = 60
40 - 59% = 8583
60 - 79% = 3911
80 - 99% = 120
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362789, depth: 3, leaf buckets: 10169, nodes: 9853840
Average node length: 5.14, total dup: 9853740, max dup: 162175
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.43, average data length: 0.00
Clustering factor: 1589751, ratio: 0.16
Fill distribution:
0 - 19% = 37
20 - 39% = 1121
40 - 59% = 5095
60 - 79% = 1714
80 - 99% = 2202
XQS_1200_2000 (183)
Primary pointer page: 591, Index root page: 592
Total formats: 1, used formats: 1
Average record length: 79.03, total records: 11481418
Average version length: 82.56, total versions: 512552, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.59
Pointer pages: 119, data page slots: 193656
Data pages: 192496, average fill: 74%
Primary pages: 192354, secondary pages: 142, swept pages: 52338
Empty pages: 2650, full pages: 157303
Fill distribution:
0 - 19% = 4397
20 - 39% = 5839
40 - 59% = 13554
60 - 79% = 98289
80 - 99% = 70417
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392123, depth: 3, leaf buckets: 13111, nodes: 11481418
Average node length: 5.30, total dup: 11371579, max dup: 642
Average key length: 2.08, compression ratio: 4.33
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2413289, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 102
40 - 59% = 8677
60 - 79% = 4157
80 - 99% = 174
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406132, depth: 3, leaf buckets: 10511, nodes: 11481418
Average node length: 5.49, total dup: 10981107, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 745617, ratio: 0.06
Fill distribution:
0 - 19% = 120
20 - 39% = 785
40 - 59% = 2624
60 - 79% = 1848
80 - 99% = 5134
Index XQS_1200_2000_SND_ID (2)
Root page: 1398660, depth: 3, leaf buckets: 14992, nodes: 11481418
Average node length: 6.02, total dup: 10028733, max dup: 76
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 2429772, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 147
40 - 59% = 10142
60 - 79% = 4501
80 - 99% = 201
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386233, depth: 3, leaf buckets: 10867, nodes: 11481418
Average node length: 5.22, total dup: 11481318, max dup: 204035
Average key length: 2.00, compression ratio: 1.22
Average prefix length: 2.44, average data length: 0.00
Clustering factor: 733730, ratio: 0.06
Fill distribution:
0 - 19% = 75
20 - 39% = 792
40 - 59% = 4841
60 - 79% = 1541
80 - 99% = 3618
XQS_2000_3300 (185)
Primary pointer page: 595, Index root page: 596
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (1)
Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (3)
Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (2)
Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_WORKER_ID (0)
Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (186)
Primary pointer page: 597, Index root page: 598
Total formats: 1, used formats: 1
Average record length: 78.27, total records: 9951125
Average version length: 82.94, total versions: 601903, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.61
Pointer pages: 109, data page slots: 177416
Data pages: 177368, average fill: 70%
Primary pages: 177339, secondary pages: 29, swept pages: 53608
Empty pages: 737, full pages: 116498
Fill distribution:
0 - 19% = 2016
20 - 39% = 8595
40 - 59% = 25611
60 - 79% = 113784
80 - 99% = 27362
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344708, depth: 3, leaf buckets: 11897, nodes: 9951125
Average node length: 5.18, total dup: 9922124, max dup: 2027
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 2035868, ratio: 0.20
Fill distribution:
0 - 19% = 27
20 - 39% = 1403
40 - 59% = 7873
60 - 79% = 1917
80 - 99% = 677
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355739, depth: 3, leaf buckets: 13840, nodes: 9951125
Average node length: 6.25, total dup: 8251350, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1524406, ratio: 0.15
Fill distribution:
0 - 19% = 187
20 - 39% = 3911
40 - 59% = 4498
60 - 79% = 2618
80 - 99% = 2626
Index XQS_2100_3300_SND_ID (2)
Root page: 1350071, depth: 3, leaf buckets: 12538, nodes: 9951125
Average node length: 5.44, total dup: 9509668, max dup: 99
Average key length: 2.28, compression ratio: 3.94
Average prefix length: 8.76, average data length: 0.24
Clustering factor: 2170060, ratio: 0.22
Fill distribution:
0 - 19% = 26
20 - 39% = 1347
40 - 59% = 8778
60 - 79% = 1792
80 - 99% = 595
Index XQS_2100_3300_WORKER_ID (0)
Root page: 987843, depth: 3, leaf buckets: 10341, nodes: 9951125
Average node length: 5.16, total dup: 9951025, max dup: 164424
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.43, average data length: 0.00
Clustering factor: 1617085, ratio: 0.16
Fill distribution:
0 - 19% = 39
20 - 39% = 1198
40 - 59% = 5223
60 - 79% = 1659
80 - 99% = 2222
XQS_3300_3400 (187)
Primary pointer page: 599, Index root page: 600
Total formats: 1, used formats: 1
Average record length: 67.40, total records: 575497
Average version length: 68.80, total versions: 7450, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.87
Pointer pages: 5, data page slots: 8024
Data pages: 8024, average fill: 75%
Primary pages: 8024, secondary pages: 0, swept pages: 2881
Empty pages: 6, full pages: 7455
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 69
60 - 79% = 7865
80 - 99% = 80
Index XQS_3300_3400_DOC_ID (1)
Root page: 47034, depth: 3, leaf buckets: 729, nodes: 575497
Average node length: 5.94, total dup: 490276, max dup: 82
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 101114, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 498
60 - 79% = 93
80 - 99% = 100
Index XQS_3300_3400_SND_ID (2)
Root page: 31469, depth: 3, leaf buckets: 744, nodes: 575497
Average node length: 6.15, total dup: 472191, max dup: 29
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.89, average data length: 1.11
Clustering factor: 101158, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 34
40 - 59% = 504
60 - 79% = 91
80 - 99% = 114
Index XQS_3300_3400_WORKER_ID (0)
Root page: 377587, depth: 2, leaf buckets: 562, nodes: 575497
Average node length: 4.86, total dup: 575397, max dup: 9782
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 89952, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 314
60 - 79% = 91
80 - 99% = 126
ZDOC_DATA (170)
Primary pointer page: 565, Index root page: 566
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (169)
Primary pointer page: 563, Index root page: 564
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (171)
Primary pointer page: 567, Index root page: 568
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (174)
Primary pointer page: 573, Index root page: 574
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (175)
Primary pointer page: 575, Index root page: 576
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (172)
Primary pointer page: 569, Index root page: 570
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (173)
Primary pointer page: 571, Index root page: 572
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (168)
Primary pointer page: 561, Index root page: 562
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (167)
Primary pointer page: 559, Index root page: 560
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (144)
Primary pointer page: 512, Index root page: 513
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Tue Feb 20 13:09:38 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7807604 |
132957 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2275396 |
68520 |
2 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
2531 |
7 |
600.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
89283 |
79293 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
324 |
13 |
600.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
1547 |
1480 |
1 |
0.0000 |
0.0000 |
PDISTR |
852158 |
42672 |
3 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
172062 |
8555 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
159201 |
10861 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
156468 |
2556 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
175056 |
23863 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
169357 |
4481 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
168782 |
12512 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
162588 |
5454 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
160627 |
4353 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
163957 |
4800 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
159790 |
9186 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2107036 |
54821 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
178777 |
85802 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7256858 |
563504 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12243582 |
494945 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1987423 |
602590 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1574532 |
159787 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
9457500 |
669450 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21153758 |
22092 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9853840 |
621886 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
11481418 |
512552 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
9951125 |
601903 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
575497 |
7450 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:88:
:89: mscs-test-161.budzdorov.ru Tue Feb 20 13:07:49 2024
:90: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:91:
:92:
:93: mscs-test-161.budzdorov.ru Tue Feb 20 13:07:59 2024
:94: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:95:
:96:
:97: mscs-test-161.budzdorov.ru Tue Feb 20 13:07:59 2024
:98: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:99:
:100:
:101: mscs-test-161.budzdorov.ru Tue Feb 20 13:08:00 2024
:102: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:103:
--- end of diff output ---
20.02.24 13:09:49. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
335544321 'string truncation'. Attempt to assign too long text into string variable.
335544347 'not_valid'. Validation error for column.
335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT |
ERRORS_RESULT |
2024-02-20 13:09:52 |
No severe PSQL-related problems occured |
20.02.24 13:09:53. End of report.