Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.03.2024 07: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 | 15629180 kB |
MemAvailable | 30229828 kB |
Buffers | 0 kB |
Cached | 16064256 kB |
SwapCached | 2596 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-03-25 07:07:48
DTS_END 2024-03-25 07:07:48.9360
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/50418
TRN_ID 178194
ATT_ID 544
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: |
9573.25 |
19818 |
957325 |
customer order: creation |
186.78 |
405 |
18678 |
customer order: refuse |
15.59 |
377 |
1559 |
order to supplier: creation |
49.68 |
1386 |
4968 |
order to supplier: removal |
3.77 |
83642 |
377 |
invoice (draft): creation |
49.67 |
2985 |
4967 |
invoice (draft): removal |
51.55 |
702 |
5155 |
invoice accept: apply |
44.58 |
19107 |
4458 |
invoice accept: cancel |
45.76 |
783 |
4576 |
customer reserve: creation |
4324.48 |
181 |
432448 |
customer reserve: removal |
4492.65 |
56 |
449265 |
realization accept: apply |
89.80 |
212 |
8980 |
realization accept: cancel |
80.72 |
136 |
8072 |
payment from customer: creation |
63.31 |
150 |
6331 |
payment from customer: removal |
5.92 |
87 |
592 |
payment to supplier: creation |
52.86 |
157 |
5286 |
payment to supplier: removal |
3.93 |
99 |
393 |
service: total inventory turnovers |
4.27 |
3254 |
427 |
service: total monetary turnovers |
6.91 |
395 |
691 |
service: aggregate perf. data |
0.98 |
12537 |
98 |
service: refresh index statistics |
0.04 |
269703 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2024 07:08:41 to 25-03-2024 07:08:43.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
1583 |
TEST_TIME |
2 |
2873 |
TEST_TIME |
3 |
2861 |
TEST_TIME |
4 |
3701 |
TEST_TIME |
5 |
3894 |
TEST_TIME |
6 |
4271 |
TEST_TIME |
7 |
4757 |
TEST_TIME |
8 |
5399 |
TEST_TIME |
9 |
5276 |
TEST_TIME |
10 |
5781 |
TEST_TIME |
11 |
5999 |
TEST_TIME |
12 |
6287 |
TEST_TIME |
13 |
6435 |
TEST_TIME |
14 |
6654 |
TEST_TIME |
15 |
6999 |
TEST_TIME |
16 |
7351 |
TEST_TIME |
17 |
8004 |
TEST_TIME |
18 |
8471 |
TEST_TIME |
19 |
8556 |
TEST_TIME |
20 |
8927 |
TEST_TIME |
21 |
8880 |
TEST_TIME |
22 |
8910 |
TEST_TIME |
23 |
8952 |
TEST_TIME |
24 |
8812 |
TEST_TIME |
25 |
8866 |
TEST_TIME |
26 |
9673 |
TEST_TIME |
27 |
9883 |
TEST_TIME |
28 |
9854 |
TEST_TIME |
29 |
9639 |
TEST_TIME |
30 |
9677 |
TEST_TIME |
31 |
9553 |
TEST_TIME |
32 |
9699 |
TEST_TIME |
33 |
9728 |
TEST_TIME |
34 |
9772 |
TEST_TIME |
35 |
10008 |
TEST_TIME |
36 |
9877 |
TEST_TIME |
37 |
9699 |
TEST_TIME |
38 |
9644 |
TEST_TIME |
39 |
9642 |
TEST_TIME |
40 |
9471 |
TEST_TIME |
41 |
9444 |
TEST_TIME |
42 |
9458 |
TEST_TIME |
43 |
9477 |
TEST_TIME |
44 |
9543 |
TEST_TIME |
45 |
9556 |
TEST_TIME |
46 |
9436 |
TEST_TIME |
47 |
9544 |
TEST_TIME |
48 |
9476 |
TEST_TIME |
49 |
9438 |
TEST_TIME |
50 |
9437 |
TEST_TIME |
51 |
9466 |
TEST_TIME |
52 |
9484 |
TEST_TIME |
53 |
9491 |
TEST_TIME |
54 |
9430 |
TEST_TIME |
55 |
9466 |
TEST_TIME |
56 |
9651 |
TEST_TIME |
57 |
9704 |
TEST_TIME |
58 |
9634 |
TEST_TIME |
59 |
9774 |
TEST_TIME |
60 |
9870 |
TEST_TIME |
61 |
9824 |
TEST_TIME |
62 |
9710 |
TEST_TIME |
63 |
9656 |
TEST_TIME |
64 |
9612 |
TEST_TIME |
65 |
9538 |
TEST_TIME |
66 |
9581 |
TEST_TIME |
67 |
9600 |
TEST_TIME |
68 |
9535 |
TEST_TIME |
69 |
9501 |
TEST_TIME |
70 |
9436 |
TEST_TIME |
71 |
9422 |
TEST_TIME |
72 |
9388 |
TEST_TIME |
73 |
9419 |
TEST_TIME |
74 |
9399 |
TEST_TIME |
75 |
9376 |
TEST_TIME |
76 |
9484 |
TEST_TIME |
77 |
9497 |
TEST_TIME |
78 |
9519 |
TEST_TIME |
79 |
9566 |
TEST_TIME |
80 |
9542 |
TEST_TIME |
81 |
9631 |
TEST_TIME |
82 |
9641 |
TEST_TIME |
83 |
9690 |
TEST_TIME |
84 |
9649 |
TEST_TIME |
85 |
9675 |
TEST_TIME |
86 |
9574 |
TEST_TIME |
87 |
9580 |
TEST_TIME |
88 |
9599 |
TEST_TIME |
89 |
9548 |
TEST_TIME |
90 |
9469 |
TEST_TIME |
91 |
9479 |
TEST_TIME |
92 |
9470 |
TEST_TIME |
93 |
9465 |
TEST_TIME |
94 |
9468 |
TEST_TIME |
95 |
9478 |
TEST_TIME |
96 |
9497 |
TEST_TIME |
97 |
9481 |
TEST_TIME |
98 |
9531 |
TEST_TIME |
99 |
9579 |
TEST_TIME |
100 |
9576 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 25-03-2024 07:08:44 to 25-03-2024 07:08:48.
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 |
1351839 |
1351839 |
0 |
0.00 |
0 |
23413 |
7 |
0 |
0 |
doc_list_biud |
1351836 |
1351836 |
0 |
0.00 |
0 |
24863 |
24 |
0 |
0 |
sp_add_invoice_to_stock |
4584 |
4458 |
126 |
2.74 |
43 |
204268 |
19107 |
0 |
126 |
sp_cancel_adding_invoice |
4576 |
4576 |
0 |
0.00 |
5 |
62062 |
783 |
0 |
0 |
sp_cancel_client_order |
1559 |
1559 |
0 |
0.00 |
4 |
7140 |
377 |
0 |
0 |
sp_cancel_customer_reserve |
449265 |
449265 |
0 |
0.00 |
0 |
24867 |
56 |
0 |
0 |
sp_cancel_pay_from_customer |
592 |
592 |
0 |
0.00 |
2 |
7884 |
87 |
0 |
0 |
sp_cancel_pay_to_supplier |
393 |
393 |
0 |
0.00 |
2 |
3464 |
100 |
0 |
0 |
sp_cancel_supplier_invoice |
5168 |
5155 |
13 |
0.25 |
1 |
23004 |
702 |
0 |
13 |
sp_cancel_supplier_order |
377 |
377 |
0 |
0.00 |
10 |
728337 |
83642 |
0 |
0 |
sp_cancel_write_off |
8072 |
8072 |
0 |
0.00 |
1 |
11136 |
137 |
0 |
0 |
sp_client_order |
18678 |
18678 |
0 |
0.00 |
3 |
27689 |
405 |
0 |
0 |
sp_customer_reserve |
432448 |
432448 |
0 |
0.00 |
0 |
43763 |
181 |
0 |
0 |
sp_fill_shopping_cart |
28600 |
28600 |
0 |
0.00 |
1 |
20278 |
41 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
432444 |
432444 |
0 |
0.00 |
0 |
21075 |
17 |
0 |
0 |
sp_get_clo_for_invoice |
4454 |
4454 |
0 |
0.00 |
0 |
32609 |
364 |
0 |
0 |
sp_kill_cost_storno |
13633 |
13633 |
0 |
0.00 |
0 |
6765 |
68 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
912134 |
912134 |
0 |
0.00 |
0 |
24861 |
30 |
0 |
0 |
sp_kill_qty_storno |
482436 |
482436 |
0 |
0.00 |
0 |
24863 |
66 |
0 |
0 |
sp_lock_selected_doc |
18610 |
18610 |
0 |
0.00 |
0 |
8009 |
6 |
0 |
0 |
sp_make_cost_storno |
25051 |
25051 |
0 |
0.00 |
0 |
22786 |
71 |
0 |
0 |
sp_multiply_rows_for_pdistr |
25048 |
25048 |
0 |
0.00 |
0 |
23383 |
40 |
0 |
0 |
sp_multiply_rows_for_qdistr |
18678 |
18678 |
0 |
0.00 |
0 |
20698 |
205 |
0 |
0 |
sp_pay_from_customer |
6331 |
6331 |
0 |
0.00 |
4 |
23417 |
151 |
0 |
0 |
sp_pay_to_supplier |
5286 |
5286 |
0 |
0.00 |
4 |
22811 |
158 |
0 |
0 |
sp_payment_common |
11616 |
11616 |
0 |
0.00 |
1 |
16423 |
29 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1559 |
1559 |
0 |
0.00 |
0 |
7134 |
340 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
9028 |
9028 |
0 |
0.00 |
0 |
16805 |
285 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
8980 |
8980 |
0 |
0.00 |
0 |
24703 |
75 |
0 |
0 |
sp_reserve_write_off |
8980 |
8980 |
0 |
0.00 |
6 |
24923 |
213 |
0 |
0 |
sp_supplier_invoice |
4967 |
4967 |
0 |
0.00 |
5 |
93057 |
2985 |
0 |
0 |
sp_supplier_order |
4968 |
4968 |
0 |
0.00 |
4 |
94089 |
1387 |
0 |
0 |
srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
1346 |
81481 |
12538 |
0 |
0 |
srv_fill_mon_cache_memory |
57 |
57 |
0 |
0.00 |
2872 |
105782 |
39336 |
0 |
0 |
srv_find_qd_qs_mism |
910844 |
910844 |
0 |
0.00 |
0 |
18799 |
6 |
0 |
0 |
srv_make_invnt_saldo |
427 |
427 |
0 |
0.00 |
45 |
82182 |
3254 |
0 |
0 |
srv_make_money_saldo |
691 |
691 |
0 |
0.00 |
1 |
12067 |
395 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
198101 |
307205 |
269703 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
126 |
126 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
13 |
13 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4458 |
4458 |
0 |
0.00 |
0 |
26202 |
184 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
339 |
339 |
0 |
0.00 |
0 |
1813 |
70 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1559 |
1559 |
0 |
0.00 |
0 |
4863 |
14 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
635 |
635 |
0 |
0.00 |
0 |
1179 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
592 |
592 |
0 |
0.00 |
0 |
10578 |
23 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
393 |
393 |
0 |
0.00 |
0 |
123 |
1 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
374 |
374 |
0 |
0.00 |
0 |
688 |
12 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
377 |
377 |
0 |
0.00 |
0 |
27060 |
1738 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
913 |
913 |
0 |
0.00 |
0 |
15394 |
31 |
0 |
0 |
t$perf-norm:sp_client_order |
18678 |
18678 |
0 |
0.00 |
0 |
13841 |
19 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
911 |
911 |
0 |
0.00 |
0 |
13836 |
32 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6331 |
6331 |
0 |
0.00 |
0 |
13889 |
13 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5286 |
5286 |
0 |
0.00 |
0 |
11995 |
18 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
8980 |
8980 |
0 |
0.00 |
0 |
13603 |
14 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
4967 |
4967 |
0 |
0.00 |
0 |
7562 |
16 |
0 |
0 |
t$perf-norm:sp_supplier_order |
4968 |
4968 |
0 |
0.00 |
0 |
1493 |
11 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
0 |
185 |
5 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
57 |
57 |
0 |
0.00 |
0 |
3249 |
65 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
427 |
427 |
0 |
0.00 |
0 |
764 |
10 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
691 |
691 |
0 |
0.00 |
0 |
5462 |
31 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
2 |
10 |
6 |
0 |
0 |
v_add_invoice_to_stock |
9150 |
8898 |
252 |
2.75 |
0 |
1977 |
15 |
0 |
252 |
v_all_customers |
34662 |
34662 |
0 |
0.00 |
0 |
40 |
1 |
0 |
0 |
v_all_suppliers |
28352 |
28352 |
0 |
0.00 |
0 |
78 |
1 |
0 |
0 |
v_all_wares |
37354 |
37354 |
0 |
0.00 |
0 |
36 |
1 |
0 |
0 |
v_cancel_adding_invoice |
678 |
678 |
0 |
0.00 |
0 |
1144 |
8 |
0 |
0 |
v_cancel_client_order |
3118 |
3118 |
0 |
0.00 |
0 |
2831 |
5 |
0 |
0 |
v_cancel_customer_prepayment |
1184 |
1184 |
0 |
0.00 |
0 |
822 |
5 |
0 |
0 |
v_cancel_customer_reserve |
1270 |
1270 |
0 |
0.00 |
0 |
1824 |
7 |
0 |
0 |
v_cancel_payment_to_supplier |
786 |
786 |
0 |
0.00 |
0 |
1166 |
11 |
0 |
0 |
v_cancel_supplier_invoice |
774 |
748 |
26 |
3.35 |
0 |
1248 |
17 |
0 |
26 |
v_cancel_supplier_order |
754 |
754 |
0 |
0.00 |
0 |
1952 |
7 |
0 |
0 |
v_cancel_write_off |
1826 |
1826 |
0 |
0.00 |
0 |
2027 |
16 |
0 |
0 |
v_max_id_clo_ord |
4962 |
4962 |
0 |
0.00 |
0 |
274 |
1 |
0 |
0 |
v_max_id_clo_res |
911 |
911 |
0 |
0.00 |
0 |
2547 |
12 |
0 |
0 |
v_max_id_ord_sup |
4959 |
4959 |
0 |
0.00 |
0 |
3193 |
3 |
0 |
0 |
v_max_non_paid_invoice |
1030 |
1030 |
0 |
0.00 |
0 |
144 |
2 |
0 |
0 |
v_max_non_paid_realizn |
2975 |
2975 |
0 |
0.00 |
0 |
6386 |
7 |
0 |
0 |
v_min_id_clo_ord |
4962 |
4962 |
0 |
0.00 |
0 |
16649 |
12 |
0 |
0 |
v_min_id_clo_res |
911 |
911 |
0 |
0.00 |
0 |
6979 |
11 |
0 |
0 |
v_min_id_ord_sup |
4959 |
4959 |
0 |
0.00 |
0 |
18600 |
13 |
0 |
0 |
v_min_non_paid_invoice |
5285 |
5285 |
0 |
0.00 |
0 |
6545 |
13 |
0 |
0 |
v_min_non_paid_realizn |
6331 |
6331 |
0 |
0.00 |
0 |
16418 |
23 |
0 |
0 |
v_our_firm |
9404 |
9404 |
0 |
0.00 |
0 |
18 |
1 |
0 |
0 |
v_reserve_write_off |
17956 |
17956 |
0 |
0.00 |
0 |
6411 |
8 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
9357 |
9357 |
0 |
0.00 |
0 |
22490 |
118 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
377 |
377 |
0 |
0.00 |
0 |
3655 |
285 |
0 |
0 |
x_make_qstorno_1000_1200 |
4968 |
4968 |
0 |
0.00 |
1 |
94051 |
1304 |
0 |
0 |
x_make_qstorno_1200_2000 |
4967 |
4967 |
0 |
0.00 |
2 |
85754 |
2831 |
0 |
0 |
x_make_qstorno_2100_3300 |
432448 |
432448 |
0 |
0.00 |
0 |
43762 |
161 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2024 07:08:49 to 25-03-2024 07:08:53.
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 |
05:07:52 |
10 |
8192000000 |
8798422496 |
8809533440 |
4463136 |
0.054 |
2 |
1 |
2 |
0 |
4562528 |
63616 |
35776 |
05:08:53 |
33244 |
8192000000 |
9707851408 |
10005540864 |
780398448 |
8.697 |
100 |
86 |
172 |
0 |
808561056 |
7914672 |
20247936 |
05:10:31 |
25061 |
8192000000 |
9762140992 |
10071945216 |
834083264 |
9.240 |
100 |
87 |
175 |
0 |
866229136 |
11925504 |
20220368 |
05:12:02 |
14962 |
8192000000 |
9795063840 |
10114453504 |
864890672 |
9.549 |
100 |
84 |
168 |
0 |
903596928 |
19607568 |
19098688 |
05:13:21 |
11175 |
8192000000 |
9848516224 |
10179698688 |
898729232 |
9.886 |
100 |
77 |
154 |
0 |
954063584 |
38814720 |
16519632 |
05:14:37 |
8740 |
8192000000 |
9889747648 |
10233458688 |
935038208 |
10.244 |
100 |
70 |
140 |
0 |
999894496 |
51014576 |
13841712 |
05:15:48 |
7338 |
8192000000 |
9931272928 |
10285797376 |
972546288 |
10.612 |
100 |
69 |
138 |
1 |
1040959088 |
54942128 |
13470672 |
05:17:03 |
2625 |
8192000000 |
9981971664 |
10341883904 |
1000027680 |
10.879 |
100 |
85 |
170 |
0 |
1089953520 |
73022704 |
16903136 |
05:18:07 |
2816 |
8192000000 |
9981293584 |
10355261440 |
1026614768 |
11.136 |
100 |
81 |
162 |
0 |
1098404800 |
56378064 |
15411968 |
05:19:12 |
2279 |
8192000000 |
10015731520 |
10395930624 |
1044332256 |
11.306 |
100 |
79 |
156 |
0 |
1127314112 |
67501440 |
15480416 |
05:20:17 |
3212 |
8192000000 |
10002735312 |
10381041664 |
1052630208 |
11.386 |
100 |
81 |
161 |
0 |
1115526928 |
47536256 |
15360464 |
05:21:24 |
2614 |
8192000000 |
10015838720 |
10396274688 |
1058954064 |
11.446 |
100 |
79 |
158 |
0 |
1134553856 |
60341936 |
15257856 |
05:22:28 |
4222 |
8192000000 |
10031771776 |
10426916864 |
1065316400 |
11.507 |
100 |
46 |
88 |
2 |
1146625936 |
72211552 |
9097984 |
05:23:34 |
4748 |
8192000000 |
9990484880 |
10394640384 |
1067917888 |
11.532 |
100 |
46 |
91 |
3 |
1107752800 |
29978288 |
9856624 |
05:24:40 |
58052 |
8192000000 |
9986285536 |
10388164608 |
1074067136 |
11.591 |
100 |
34 |
68 |
2 |
1094793184 |
13838528 |
6887520 |
05:26:39 |
6332 |
8192000000 |
10010048480 |
10418376704 |
1077843408 |
11.627 |
100 |
44 |
88 |
1 |
1117895856 |
31493984 |
8558464 |
05:27:48 |
4887 |
8192000000 |
9985260656 |
10388725760 |
1080151264 |
11.649 |
100 |
32 |
63 |
0 |
1099396816 |
12440864 |
6804688 |
05:29:06 |
21959 |
8192000000 |
10043363216 |
10449068032 |
1093415680 |
11.775 |
100 |
51 |
99 |
1 |
1143884832 |
40632240 |
9836912 |
05:30:33 |
105782 |
8192000000 |
10068545296 |
10493108224 |
1106695888 |
11.901 |
100 |
25 |
49 |
1 |
1195749648 |
83801680 |
5252080 |
05:33:28 |
13589 |
8192000000 |
10150311312 |
10558181376 |
1114499168 |
11.975 |
100 |
57 |
111 |
1 |
1241290320 |
116325680 |
10465472 |
05:34:48 |
25003 |
8192000000 |
10101808000 |
10533650432 |
1111345424 |
11.945 |
99 |
34 |
68 |
0 |
1216087920 |
97419024 |
7323472 |
05:36:27 |
4894 |
8192000000 |
10138721280 |
10550575104 |
1131268752 |
12.133 |
100 |
55 |
110 |
0 |
1245199760 |
102083680 |
11847328 |
05:37:39 |
11318 |
8192000000 |
10146597408 |
10556919808 |
1121478976 |
12.041 |
100 |
56 |
112 |
1 |
1259112208 |
126074576 |
11558656 |
05:38:57 |
6655 |
8192000000 |
10155178192 |
10555113472 |
1089619104 |
11.739 |
97 |
64 |
126 |
0 |
1251251712 |
148183296 |
13449312 |
05:40:07 |
9854 |
8192000000 |
10167727392 |
10567364608 |
1094865344 |
11.789 |
99 |
55 |
109 |
0 |
1260654640 |
154432992 |
11356304 |
05:41:20 |
11936 |
8192000000 |
10173181616 |
10564284416 |
1077888464 |
11.627 |
98 |
65 |
129 |
0 |
1256770400 |
165630992 |
13250944 |
05:42:36 |
4165 |
8192000000 |
10198223344 |
10597216256 |
1098654400 |
11.825 |
100 |
51 |
102 |
0 |
1295382288 |
185729968 |
10997920 |
05:43:43 |
2871 |
8192000000 |
10200779952 |
10584268800 |
1078378960 |
11.632 |
99 |
83 |
166 |
0 |
1298545008 |
202122944 |
18043104 |
05:44:54 |
4844 |
8192000000 |
10211601712 |
10606825472 |
1104255712 |
11.878 |
100 |
83 |
160 |
1 |
1315008416 |
194024992 |
16727712 |
05:46:04 |
4438 |
8192000000 |
10156598896 |
10547666944 |
1081488816 |
11.662 |
99 |
63 |
126 |
1 |
1252731920 |
157955536 |
13287568 |
05:47:11 |
12468 |
8192000000 |
10124613024 |
10583891968 |
1106386880 |
11.898 |
100 |
21 |
40 |
0 |
1236495184 |
125149104 |
4959200 |
05:48:27 |
13014 |
8192000000 |
10164972080 |
10590187520 |
1110941824 |
11.941 |
100 |
47 |
92 |
1 |
1267814240 |
146444800 |
10427616 |
05:49:41 |
25997 |
8192000000 |
10165067248 |
10585890816 |
1110285936 |
11.935 |
100 |
39 |
79 |
1 |
1274387312 |
154520704 |
9580672 |
05:51:25 |
23493 |
8192000000 |
10189768944 |
10636017664 |
1099901744 |
11.837 |
99 |
15 |
30 |
0 |
1286415808 |
182742848 |
3771216 |
05:54:14 |
83027 |
8192000000 |
10033531808 |
10478862336 |
1084733296 |
11.693 |
99 |
11 |
21 |
0 |
1146859600 |
60290704 |
1835600 |
05:56:37 |
41454 |
8192000000 |
10056105296 |
10492919808 |
1105229440 |
11.887 |
100 |
29 |
59 |
1 |
1173740832 |
61858320 |
6653072 |
05:58:26 |
43934 |
8192000000 |
10058477088 |
10514534400 |
1108688352 |
11.920 |
100 |
30 |
60 |
0 |
1178516480 |
62970784 |
6857344 |
06:00:15 |
84529 |
8192000000 |
10125593440 |
10558554112 |
1125384816 |
12.078 |
100 |
24 |
46 |
1 |
1173421936 |
43573616 |
4463504 |
06:02:47 |
58695 |
8192000000 |
10056448976 |
10515951616 |
1133965536 |
12.159 |
100 |
18 |
37 |
0 |
1175758688 |
38357152 |
3436000 |
06:04:48 |
58190 |
8192000000 |
10076237952 |
10505486336 |
1126051584 |
12.084 |
99 |
41 |
80 |
0 |
1159986736 |
24794800 |
9140352 |
06:06:51 |
80564 |
8192000000 |
10106535712 |
10542546944 |
1136162704 |
12.179 |
99 |
26 |
51 |
1 |
1196676032 |
55167120 |
5346208 |
06:09:14 |
38236 |
8192000000 |
10144729808 |
10589474816 |
1157056912 |
12.376 |
100 |
41 |
82 |
0 |
1251272928 |
84935280 |
9280736 |
06:10:55 |
35011 |
8192000000 |
10133319712 |
10613817344 |
1153532224 |
12.343 |
100 |
23 |
46 |
0 |
1259462112 |
100940912 |
4988976 |
06:12:32 |
52932 |
8192000000 |
10114219408 |
10564063232 |
1143476176 |
12.248 |
99 |
14 |
28 |
1 |
1219284368 |
72956608 |
2851584 |
06:14:26 |
33861 |
8192000000 |
10058813792 |
10524246016 |
1128354272 |
12.106 |
98 |
14 |
28 |
0 |
1185452880 |
54346816 |
2751792 |
06:16:00 |
24328 |
8192000000 |
10068452624 |
10536026112 |
1139509296 |
12.211 |
99 |
16 |
32 |
1 |
1172763728 |
30456752 |
2797680 |
06:17:25 |
45369 |
8192000000 |
10071995904 |
10529431552 |
1129437376 |
12.116 |
99 |
27 |
54 |
0 |
1156605456 |
22334208 |
4833872 |
06:19:27 |
55651 |
8192000000 |
10060165536 |
10508951552 |
1124940144 |
12.074 |
99 |
28 |
54 |
1 |
1168277376 |
37313456 |
6023776 |
06:21:25 |
26116 |
8192000000 |
10084032704 |
10510782464 |
1074497936 |
11.595 |
95 |
31 |
62 |
0 |
1146543840 |
65138576 |
6907328 |
06:22:52 |
47365 |
8192000000 |
10013980320 |
10467426304 |
1059241584 |
11.449 |
96 |
7 |
15 |
0 |
1112027888 |
51392464 |
1393840 |
06:24:39 |
46348 |
8192000000 |
10048239808 |
10492444672 |
1051692544 |
11.377 |
95 |
17 |
35 |
0 |
1104444048 |
49141664 |
3609840 |
06:26:40 |
73429 |
8192000000 |
10034561872 |
10517200896 |
1043391936 |
11.297 |
96 |
17 |
34 |
0 |
1129851792 |
83265840 |
3194016 |
06:28:54 |
101437 |
8192000000 |
10019190416 |
10463535104 |
1039978160 |
11.264 |
96 |
27 |
54 |
0 |
1086606416 |
41439904 |
5188352 |
06:32:01 |
20430 |
8192000000 |
10009529504 |
10427219968 |
1083094416 |
11.677 |
100 |
31 |
63 |
0 |
1109086864 |
19903360 |
6089088 |
06:33:23 |
42976 |
8192000000 |
10079334448 |
10517929984 |
1095889216 |
11.799 |
100 |
37 |
74 |
0 |
1165483456 |
61595568 |
7998672 |
06:35:12 |
25880 |
8192000000 |
10027941984 |
10454695936 |
1095073744 |
11.791 |
100 |
27 |
53 |
0 |
1121996960 |
21167808 |
5755408 |
06:36:40 |
50080 |
8192000000 |
10066473472 |
10507927552 |
1094231296 |
11.783 |
99 |
15 |
30 |
0 |
1160120496 |
63164832 |
2724368 |
06:39:21 |
5233 |
8192000000 |
10007422416 |
10438115328 |
1082402560 |
11.670 |
99 |
52 |
102 |
2 |
1106606800 |
14094224 |
10110016 |
06:40:27 |
54070 |
8192000000 |
10022549536 |
10490589184 |
1050510192 |
11.366 |
96 |
15 |
29 |
0 |
1092311008 |
39038240 |
2762576 |
06:42:21 |
45964 |
8192000000 |
10113356080 |
10537484288 |
1106713536 |
11.901 |
99 |
19 |
38 |
0 |
1213247376 |
102697200 |
3836640 |
06:44:14 |
53122 |
8192000000 |
10061754208 |
10509565952 |
1128163984 |
12.104 |
100 |
28 |
56 |
0 |
1171618464 |
38242832 |
5211648 |
06:46:12 |
52767 |
8192000000 |
10070995376 |
10512199680 |
1125088912 |
12.075 |
99 |
17 |
34 |
1 |
1184848544 |
56516592 |
3243040 |
06:48:06 |
54989 |
8192000000 |
10090431280 |
10580463616 |
1144208112 |
12.255 |
100 |
28 |
56 |
0 |
1232673360 |
83071392 |
5393856 |
06:50:20 |
41897 |
8192000000 |
10089030464 |
10525282304 |
1146451088 |
12.276 |
100 |
24 |
47 |
0 |
1216335536 |
65106656 |
4777792 |
06:52:03 |
45455 |
8192000000 |
10121379120 |
10572775424 |
1128152752 |
12.104 |
98 |
38 |
74 |
0 |
1206986608 |
71873760 |
6960096 |
06:53:50 |
88401 |
8192000000 |
10093879920 |
10540875776 |
1110284496 |
11.935 |
97 |
27 |
54 |
0 |
1174717488 |
59409536 |
5023456 |
06:56:19 |
43714 |
8192000000 |
10050265104 |
10507284480 |
1105041200 |
11.885 |
98 |
12 |
24 |
0 |
1150875504 |
43374480 |
2459824 |
06:58:12 |
36106 |
8192000000 |
10086127408 |
10531123200 |
1129918480 |
12.121 |
100 |
20 |
40 |
0 |
1198106432 |
63996080 |
4191872 |
06:59:49 |
37427 |
8192000000 |
10034921376 |
10480656384 |
1072878720 |
11.580 |
96 |
23 |
46 |
0 |
1112212416 |
34599648 |
4734048 |
07:01:28 |
28274 |
8192000000 |
10089033344 |
10523959296 |
1111582128 |
11.947 |
99 |
26 |
52 |
0 |
1190284592 |
73148656 |
5553808 |
07:03:03 |
67202 |
8192000000 |
10047171136 |
10528407552 |
1056790464 |
11.426 |
94 |
18 |
36 |
0 |
1105930848 |
45279568 |
3860816 |
07:05:11 |
94409 |
8192000000 |
10052887200 |
10513358848 |
1053227840 |
11.392 |
95 |
15 |
31 |
0 |
1122986096 |
66621584 |
3136672 |
07:07:46 |
16058 |
8192000000 |
9027835840 |
9272090624 |
177707872 |
2.123 |
17 |
1 |
2 |
0 |
188548144 |
10804864 |
35408 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 07:08:55 to 25-03-2024 07:09:09.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
126 |
v_add_invoice_to_stock |
335544517 |
except |
13 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 07:09:10 to 25-03-2024 07:09:12.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 178481
MON$OLDEST_ACTIVE 178482
MON$OLDEST_SNAPSHOT 178482
MON$NEXT_TRANSACTION 178482
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 1920160
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 710
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.5.3081 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3081 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3081 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3081 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 Mon Mar 25 07:09:13 2024
Database header page information:
Flags 0
Generation 93105
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 178481
Oldest active 178482
Oldest snapshot 178482
Next transaction 178483
Sequence number 0
Next attachment ID 710
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.15, total records: 7812491
Average version length: 48.15, total versions: 148272, 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: 88768
Data pages: 88768, average fill: 71%
Primary pages: 88766, secondary pages: 2, swept pages: 26638
Empty pages: 2, full pages: 84363
Fill distribution:
0 - 19% = 7
20 - 39% = 18
40 - 59% = 201
60 - 79% = 88449
80 - 99% = 93
Index DOC_DATA_DOC_WARE_UNQ (0)
Root page: 1510636, depth: 3, leaf buckets: 23412, nodes: 7812491
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: 1724099, ratio: 0.22
Fill distribution:
0 - 19% = 345
20 - 39% = 1550
40 - 59% = 4387
60 - 79% = 2534
80 - 99% = 14596
Index DOC_DATA_ID_DESC (1)
Root page: 1528140, depth: 3, leaf buckets: 13595, nodes: 7812491
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: 1547485, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 1428
40 - 59% = 2236
60 - 79% = 1137
80 - 99% = 8793
Index FK_DOC_DATA_DOC_LIST (2)
Root page: 1546735, depth: 3, leaf buckets: 8406, nodes: 7812491
Average node length: 6.63, total dup: 5828958, max dup: 49
Average key length: 3.64, compression ratio: 2.47
Average prefix length: 7.61, average data length: 1.39
Clustering factor: 1540431, ratio: 0.20
Fill distribution:
0 - 19% = 151
20 - 39% = 850
40 - 59% = 1512
60 - 79% = 933
80 - 99% = 4960
DOC_LIST (138)
Primary pointer page: 500, Index root page: 501
Total formats: 1, used formats: 1
Average record length: 55.79, total records: 2274599
Average version length: 58.88, total versions: 78106, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 84.00, compression ratio: 1.51
Pointer pages: 18, data page slots: 28520
Data pages: 28520, average fill: 74%
Primary pages: 28518, secondary pages: 2, swept pages: 6582
Empty pages: 5, full pages: 27058
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 18
60 - 79% = 28339
80 - 99% = 156
Index DOC_LIST_ID_DESC (1)
Root page: 1541152, depth: 3, leaf buckets: 4590, nodes: 2274599
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: 699289, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 841
40 - 59% = 945
60 - 79% = 753
80 - 99% = 2051
Index DOC_LIST_WORKER_OPTYPE (2)
Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2276581
Average node length: 4.97, total dup: 2275682, max dup: 18088
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1282267, ratio: 0.56
Fill distribution:
0 - 19% = 3
20 - 39% = 190
40 - 59% = 1392
60 - 79% = 595
80 - 99% = 258
Index FK_DOC_LIST_AGENTS (3)
Root page: 1545933, depth: 3, leaf buckets: 1759, nodes: 2274599
Average node length: 4.97, total dup: 2274549, max dup: 130486
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 1070048, ratio: 0.47
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 593
60 - 79% = 43
80 - 99% = 1116
Index PK_DOC_LIST (0)
Root page: 1538209, depth: 3, leaf buckets: 4397, nodes: 2274599
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: 699289, ratio: 0.31
Fill distribution:
0 - 19% = 116
20 - 39% = 542
40 - 59% = 687
60 - 79% = 830
80 - 99% = 2222
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: 28.53, total versions: 2266, max versions: 6
Average fragment length: 2.00, total fragments: 1, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.25
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 55%
Primary pages: 14, secondary pages: 18, swept pages: 0
Empty pages: 7, full pages: 15
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 0
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.33, total records: 119523
Average version length: 68.30, total versions: 106775, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 88.00, compression ratio: 5.74
Pointer pages: 7, data page slots: 3200
Data pages: 2592, average fill: 62%
Primary pages: 2591, secondary pages: 1, swept pages: 0
Empty pages: 318, full pages: 1344
Fill distribution:
0 - 19% = 492
20 - 39% = 272
40 - 59% = 306
60 - 79% = 305
80 - 99% = 1217
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1690944, depth: 3, leaf buckets: 423, nodes: 119523
Average node length: 13.09, total dup: 10626, max dup: 2
Average key length: 10.56, compression ratio: 2.56
Average prefix length: 19.35, average data length: 7.65
Clustering factor: 84942, ratio: 0.71
Fill distribution:
0 - 19% = 3
20 - 39% = 99
40 - 59% = 283
60 - 79% = 38
80 - 99% = 0
MONEY_SALDO (141)
Primary pointer page: 506, Index root page: 507
Total formats: 1, used formats: 1
Average record length: 15.20, total records: 49
Average version length: 9.00, total versions: 250, max versions: 8
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: 5
Data pages: 5, average fill: 20%
Primary pages: 1, secondary pages: 4, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 4
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: 11.91, total records: 1790
Average version length: 43.98, total versions: 1646, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 58.00, compression ratio: 4.87
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 49%
Primary pages: 39, secondary pages: 1, swept pages: 0
Empty pages: 7, full pages: 16
Fill distribution:
0 - 19% = 16
20 - 39% = 2
40 - 59% = 3
60 - 79% = 3
80 - 99% = 16
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 94399, depth: 2, leaf buckets: 2, nodes: 1790
Average node length: 4.47, total dup: 1694, max dup: 246
Average key length: 2.58, compression ratio: 7.37
Average prefix length: 18.48, average data length: 0.52
Clustering factor: 941, ratio: 0.53
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
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.45, total records: 73
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 112.00, compression ratio: 1.15
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 51%
Primary pages: 2, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_MON_CACHE_MEMORY (0)
Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 10.67, compression ratio: 0.84
Average prefix length: 1.32, average data length: 7.68
Clustering factor: 2, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (162)
Primary pointer page: 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.38, total records: 849921
Average version length: 37.93, total versions: 47347, max versions: 3
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 54.00, compression ratio: 1.53
Pointer pages: 6, data page slots: 8616
Data pages: 8616, average fill: 67%
Primary pages: 8614, secondary pages: 2, swept pages: 898
Empty pages: 2, full pages: 8494
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 4
60 - 79% = 8483
80 - 99% = 121
Index PDISTR_AGENT_ID (2)
Root page: 1509330, depth: 2, leaf buckets: 878, nodes: 822905
Average node length: 4.88, total dup: 822856, max dup: 152747
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 93122, ratio: 0.11
Fill distribution:
0 - 19% = 3
20 - 39% = 118
40 - 59% = 474
60 - 79% = 174
80 - 99% = 109
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0)
Root page: 1508635, depth: 3, leaf buckets: 1021, nodes: 822905
Average node length: 5.89, total dup: 732772, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 165339, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 59
40 - 59% = 658
60 - 79% = 59
80 - 99% = 245
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1)
Root page: 1509209, depth: 3, leaf buckets: 1054, nodes: 822905
Average node length: 5.89, total dup: 732772, max dup: 42
Average key length: 3.02, compression ratio: 7.29
Average prefix length: 21.09, average data length: 0.91
Clustering factor: 167209, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 115
40 - 59% = 649
60 - 79% = 55
80 - 99% = 235
Index PDISTR_WORKER_SND_ID (3)
Root page: 1510200, depth: 3, leaf buckets: 1153, nodes: 822905
Average node length: 5.97, total dup: 732772, max dup: 42
Average key length: 3.10, compression ratio: 5.49
Average prefix length: 16.01, average data length: 0.99
Clustering factor: 159597, ratio: 0.19
Fill distribution:
0 - 19% = 2
20 - 39% = 259
40 - 59% = 583
60 - 79% = 197
80 - 99% = 112
PERF_AGG (158)
Primary pointer page: 540, Index root page: 541
Total formats: 1, used formats: 1
Average record length: 63.00, total records: 5533
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 3.71, total fragments: 31, max fragments: 1
Average unpacked length: 379.00, compression ratio: 6.02
Pointer pages: 1, data page slots: 96
Data pages: 95, average fill: 58%
Primary pages: 80, secondary pages: 15, swept pages: 50
Empty pages: 10, full pages: 54
Fill distribution:
0 - 19% = 20
20 - 39% = 0
40 - 59% = 1
60 - 79% = 74
80 - 99% = 0
Index PERF_AGG_UNQ (1)
Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5533
Average node length: 5.51, total dup: 0, max dup: 0
Average key length: 3.57, compression ratio: 10.13
Average prefix length: 34.66, average data length: 1.54
Clustering factor: 5312, ratio: 0.96
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 2
Index PK_PERF_AGG (0)
Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5533
Average node length: 11.14, total dup: 0, max dup: 0
Average key length: 9.21, compression ratio: 0.98
Average prefix length: 2.79, average data length: 6.21
Clustering factor: 165, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
PERF_ESTIMATED (280)
Primary pointer page: 399, Index root page: 434
Total formats: 1, used formats: 1
Average record length: 39.03, total records: 80770
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 48.00, compression ratio: 1.23
Pointer pages: 1, data page slots: 840
Data pages: 840, average fill: 66%
Primary pages: 840, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 838
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 838
80 - 99% = 0
Index PK_PERF_ESTIMATED (0)
Root page: 34196, depth: 2, leaf buckets: 103, nodes: 80770
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: 3088, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 101
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: 110.49, 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.30
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: 124.13, total records: 187371
Average version length: 154.77, total versions: 35681, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.66
Pointer pages: 6, data page slots: 6160
Data pages: 4712, average fill: 85%
Primary pages: 4708, secondary pages: 4, swept pages: 1
Empty pages: 76, full pages: 4601
Fill distribution:
0 - 19% = 78
20 - 39% = 11
40 - 59% = 16
60 - 79% = 6
80 - 99% = 4601
PERF_SPLIT_1 (282)
Primary pointer page: 603, Index root page: 604
Total formats: 1, used formats: 1
Average record length: 137.82, total records: 140585
Average version length: 154.26, total versions: 13005, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.31
Pointer pages: 7, data page slots: 4848
Data pages: 3544, average fill: 83%
Primary pages: 3541, secondary pages: 3, swept pages: 1
Empty pages: 73, full pages: 3444
Fill distribution:
0 - 19% = 80
20 - 39% = 10
40 - 59% = 3
60 - 79% = 7
80 - 99% = 3444
PERF_SPLIT_2 (283)
Primary pointer page: 605, Index root page: 606
Total formats: 1, used formats: 1
Average record length: 132.78, total records: 165518
Average version length: 154.37, total versions: 21273, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.77
Pointer pages: 5, data page slots: 5312
Data pages: 4200, average fill: 83%
Primary pages: 4196, secondary pages: 4, swept pages: 1
Empty pages: 111, full pages: 4055
Fill distribution:
0 - 19% = 120
20 - 39% = 9
40 - 59% = 5
60 - 79% = 11
80 - 99% = 4055
PERF_SPLIT_3 (284)
Primary pointer page: 607, Index root page: 616
Total formats: 1, used formats: 1
Average record length: 147.80, total records: 145007
Average version length: 150.74, total versions: 3460, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.48
Pointer pages: 8, data page slots: 5152
Data pages: 3616, average fill: 83%
Primary pages: 3612, secondary pages: 4, swept pages: 1
Empty pages: 47, full pages: 3554
Fill distribution:
0 - 19% = 48
20 - 39% = 6
40 - 59% = 3
60 - 79% = 4
80 - 99% = 3555
PERF_SPLIT_4 (285)
Primary pointer page: 617, Index root page: 618
Total formats: 1, used formats: 1
Average record length: 148.88, total records: 139767
Average version length: 150.73, total versions: 1965, 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: 5256
Data pages: 3480, average fill: 83%
Primary pages: 3478, secondary pages: 2, swept pages: 3
Empty pages: 48, full pages: 3415
Fill distribution:
0 - 19% = 52
20 - 39% = 2
40 - 59% = 4
60 - 79% = 7
80 - 99% = 3415
PERF_SPLIT_5 (286)
Primary pointer page: 619, Index root page: 620
Total formats: 1, used formats: 1
Average record length: 147.50, total records: 153568
Average version length: 151.57, total versions: 3939, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.50
Pointer pages: 6, data page slots: 4992
Data pages: 3864, average fill: 82%
Primary pages: 3862, secondary pages: 2, swept pages: 3
Empty pages: 74, full pages: 3763
Fill distribution:
0 - 19% = 81
20 - 39% = 12
40 - 59% = 3
60 - 79% = 4
80 - 99% = 3764
PERF_SPLIT_6 (287)
Primary pointer page: 621, Index root page: 622
Total formats: 1, used formats: 1
Average record length: 138.76, total records: 164385
Average version length: 153.73, total versions: 14339, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.22
Pointer pages: 7, data page slots: 5080
Data pages: 4104, average fill: 84%
Primary pages: 4102, secondary pages: 2, swept pages: 1
Empty pages: 52, full pages: 4035
Fill distribution:
0 - 19% = 55
20 - 39% = 7
40 - 59% = 4
60 - 79% = 4
80 - 99% = 4034
PERF_SPLIT_7 (288)
Primary pointer page: 626, Index root page: 627
Total formats: 1, used formats: 1
Average record length: 127.97, total records: 172655
Average version length: 154.63, total versions: 28042, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 13.25
Pointer pages: 6, data page slots: 5752
Data pages: 4320, average fill: 85%
Primary pages: 4318, secondary pages: 2, swept pages: 2
Empty pages: 53, full pages: 4234
Fill distribution:
0 - 19% = 58
20 - 39% = 4
40 - 59% = 19
60 - 79% = 4
80 - 99% = 4235
PERF_SPLIT_8 (289)
Primary pointer page: 628, Index root page: 629
Total formats: 1, used formats: 1
Average record length: 130.54, total records: 173060
Average version length: 154.68, total versions: 24860, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 12.99
Pointer pages: 7, data page slots: 6104
Data pages: 4344, average fill: 84%
Primary pages: 4342, secondary pages: 2, swept pages: 1
Empty pages: 74, full pages: 4248
Fill distribution:
0 - 19% = 81
20 - 39% = 8
40 - 59% = 5
60 - 79% = 2
80 - 99% = 4248
PERF_SPLIT_9 (290)
Primary pointer page: 630, Index root page: 631
Total formats: 1, used formats: 1
Average record length: 148.35, total records: 141552
Average version length: 149.14, total versions: 2515, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.43
Pointer pages: 5, data page slots: 4744
Data pages: 3544, average fill: 82%
Primary pages: 3541, secondary pages: 3, swept pages: 3
Empty pages: 59, full pages: 3461
Fill distribution:
0 - 19% = 65
20 - 39% = 6
40 - 59% = 5
60 - 79% = 8
80 - 99% = 3460
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.35, total records: 2126440
Average version length: 52.92, total versions: 68062, 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: 25600
Data pages: 25592, average fill: 72%
Primary pages: 25583, secondary pages: 9, swept pages: 8276
Empty pages: 47, full pages: 24345
Fill distribution:
0 - 19% = 97
20 - 39% = 110
40 - 59% = 333
60 - 79% = 24342
80 - 99% = 710
Index PSTORNED_RCV_ID (1)
Root page: 1506208, depth: 3, leaf buckets: 2599, nodes: 2126440
Average node length: 5.44, total dup: 1984770, max dup: 1602
Average key length: 2.49, compression ratio: 3.62
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 184142, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 275
40 - 59% = 1695
60 - 79% = 346
80 - 99% = 281
Index PSTORNED_SND_ID (0)
Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2126440
Average node length: 5.69, total dup: 1909461, max dup: 71
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 380477, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 2376
60 - 79% = 350
80 - 99% = 26
Index PSTORNED_WORKER_ID (2)
Root page: 1508018, depth: 3, leaf buckets: 2111, nodes: 2126440
Average node length: 4.96, total dup: 2126340, max dup: 28445
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.40, average data length: 0.00
Clustering factor: 181781, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 165
40 - 59% = 1063
60 - 79% = 424
80 - 99% = 456
RULES_FOR_PDISTR (148)
Primary pointer page: 520, Index root page: 521
Total formats: 1, used formats: 1
Average record length: 17.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 334.00, compression ratio: 19.65
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (137)
Primary pointer page: 498, Index root page: 499
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (152)
Primary pointer page: 528, Index root page: 529
Total formats: 1, used formats: 1
Average record length: 43.40, total records: 5
Average version length: 9.00, total versions: 1, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 7.97
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 12.40, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.60, average data length: 8.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5
Average node length: 23.40, total dup: 0, max dup: 0
Average key length: 22.00, compression ratio: 1.07
Average prefix length: 4.20, average data length: 19.40
Clustering factor: 1, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (135)
Primary pointer page: 494, Index root page: 495
Total formats: 1, used formats: 1
Average record length: 97.62, total records: 149
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.80
Pointer pages: 1, data page slots: 3
Data pages: 3, average fill: 70%
Primary pages: 3, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index SETTINGS_MCODE_WM_UNQ (1)
Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 14.66, total dup: 0, max dup: 0
Average key length: 13.55, compression ratio: 2.19
Average prefix length: 19.07, average data length: 10.66
Clustering factor: 48, ratio: 0.32
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SETTINGS_MODE_CODE (0)
Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149
Average node length: 25.56, total dup: 0, max dup: 0
Average key length: 24.56, compression ratio: 1.63
Average prefix length: 18.58, average data length: 21.56
Clustering factor: 14, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 482, Index root page: 483
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 488, Index root page: 489
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 490, Index root page: 491
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 492, Index root page: 493
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_EST_WHOLE (161)
Primary pointer page: 546, Index root page: 547
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (160)
Primary pointer page: 544, Index root page: 545
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 486, Index root page: 487
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 484, Index root page: 485
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 480, Index root page: 481
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TPAUSE (166)
Primary pointer page: 557, Index root page: 558
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (157)
Primary pointer page: 538, Index root page: 539
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WARES (142)
Primary pointer page: 508, Index root page: 509
Total formats: 1, used formats: 1
Average record length: 77.52, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 444.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 1
Index FK_WARES_WARE_GROUPS (3)
Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 60
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 344, ratio: 0.86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 53.25, total dup: 0, max dup: 0
Average key length: 52.23, compression ratio: 1.00
Average prefix length: 2.74, average data length: 49.25
Clustering factor: 355, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
WARE_GROUPS (151)
Primary pointer page: 526, Index root page: 527
Total formats: 1, used formats: 1
Average record length: 32.12, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 346.00, compression ratio: 10.77
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.12, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.12, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (176)
Primary pointer page: 577, Index root page: 578
Total formats: 1, used formats: 1
Average record length: 38.93, total records: 165551
Average version length: 69.18, total versions: 83292, 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: 3, data page slots: 3856
Data pages: 3072, average fill: 66%
Primary pages: 3072, secondary pages: 0, swept pages: 360
Empty pages: 486, full pages: 2395
Fill distribution:
0 - 19% = 594
20 - 39% = 10
40 - 59% = 15
60 - 79% = 929
80 - 99% = 1524
Index XQD_1000_1200_WA_SO_RO_WKR_SND (0)
Root page: 104242, depth: 3, leaf buckets: 234, nodes: 165551
Average node length: 6.47, total dup: 144286, max dup: 14
Average key length: 3.90, compression ratio: 10.76
Average prefix length: 40.22, average data length: 1.78
Clustering factor: 29051, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 27
40 - 59% = 114
60 - 79% = 73
80 - 99% = 19
XQD_1000_3300 (178)
Primary pointer page: 581, Index root page: 582
Total formats: 1, used formats: 1
Average record length: 64.21, total records: 7352673
Average version length: 68.80, total versions: 582603, 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: 106184
Data pages: 106184, average fill: 75%
Primary pages: 106184, secondary pages: 0, swept pages: 7523
Empty pages: 9, full pages: 102929
Fill distribution:
0 - 19% = 159
20 - 39% = 562
40 - 59% = 1161
60 - 79% = 100480
80 - 99% = 3822
Index XQD_1000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1480476, depth: 3, leaf buckets: 10804, nodes: 7352673
Average node length: 6.51, total dup: 6362750, max dup: 29
Average key length: 3.51, compression ratio: 11.95
Average prefix length: 40.62, average data length: 1.38
Clustering factor: 1740981, ratio: 0.24
Fill distribution:
0 - 19% = 7
20 - 39% = 1325
40 - 59% = 5874
60 - 79% = 2971
80 - 99% = 627
Index XQD_1000_3300_WKR_DOC_ASC (1)
Root page: 1486090, depth: 3, leaf buckets: 8781, nodes: 7352673
Average node length: 5.39, total dup: 7066055, max dup: 172
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1531791, ratio: 0.21
Fill distribution:
0 - 19% = 6
20 - 39% = 998
40 - 59% = 5129
60 - 79% = 1592
80 - 99% = 1056
Index XQD_1000_3300_WKR_DOC_DEC (2)
Root page: 1490630, depth: 3, leaf buckets: 8838, nodes: 7352673
Average node length: 5.39, total dup: 7066055, max dup: 172
Average key length: 2.40, compression ratio: 7.09
Average prefix length: 16.64, average data length: 0.36
Clustering factor: 1534227, ratio: 0.21
Fill distribution:
0 - 19% = 8
20 - 39% = 1050
40 - 59% = 5103
60 - 79% = 1645
80 - 99% = 1032
XQD_1200_2000 (177)
Primary pointer page: 579, Index root page: 580
Total formats: 1, used formats: 1
Average record length: 66.58, total records: 12373909
Average version length: 68.74, total versions: 485261, 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: 175984
Data pages: 175944, average fill: 75%
Primary pages: 175944, secondary pages: 0, swept pages: 46439
Empty pages: 13, full pages: 175672
Fill distribution:
0 - 19% = 14
20 - 39% = 2
40 - 59% = 12
60 - 79% = 171242
80 - 99% = 4674
Index XQD_1200_2000_WA_SO_RO_WKR_SND (0)
Root page: 1495050, depth: 3, leaf buckets: 18534, nodes: 12369062
Average node length: 6.62, total dup: 10782947, max dup: 63
Average key length: 3.42, compression ratio: 12.27
Average prefix length: 40.70, average data length: 1.30
Clustering factor: 2528440, ratio: 0.20
Fill distribution:
0 - 19% = 20
20 - 39% = 1818
40 - 59% = 10761
60 - 79% = 5085
80 - 99% = 850
XQD_2000_3300 (179)
Primary pointer page: 583, Index root page: 584
Total formats: 1, used formats: 1
Average record length: 37.82, total records: 1997124
Average version length: 69.09, total versions: 583065, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.33
Pointer pages: 29, data page slots: 44680
Data pages: 28400, average fill: 69%
Primary pages: 28321, secondary pages: 79, swept pages: 711
Empty pages: 87, full pages: 28057
Fill distribution:
0 - 19% = 176
20 - 39% = 4449
40 - 59% = 2314
60 - 79% = 12740
80 - 99% = 8721
Index XQD_2000_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479735, depth: 3, leaf buckets: 1880, nodes: 1539942
Average node length: 5.52, total dup: 1477751, max dup: 49
Average key length: 2.56, compression ratio: 16.42
Average prefix length: 41.48, average data length: 0.52
Clustering factor: 109348, ratio: 0.07
Fill distribution:
0 - 19% = 19
20 - 39% = 221
40 - 59% = 925
60 - 79% = 523
80 - 99% = 192
XQD_2100_3300 (180)
Primary pointer page: 585, Index root page: 586
Total formats: 1, used formats: 1
Average record length: 32.14, total records: 1618590
Average version length: 69.02, total versions: 197086, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 3.92
Pointer pages: 20, data page slots: 32496
Data pages: 25968, average fill: 46%
Primary pages: 25968, secondary pages: 0, swept pages: 4211
Empty pages: 4448, full pages: 17146
Fill distribution:
0 - 19% = 6271
20 - 39% = 2302
40 - 59% = 5993
60 - 79% = 10558
80 - 99% = 844
Index XQD_2100_3300_WA_SO_RO_WKR_SND (0)
Root page: 1479229, depth: 3, leaf buckets: 1132, nodes: 820851
Average node length: 5.94, total dup: 755957, max dup: 86
Average key length: 3.00, compression ratio: 13.99
Average prefix length: 41.08, average data length: 0.92
Clustering factor: 121828, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 198
40 - 59% = 550
60 - 79% = 331
80 - 99% = 52
XQD_3300_3400 (181)
Primary pointer page: 587, Index root page: 588
Total formats: 1, used formats: 1
Average record length: 64.33, total records: 9429733
Average version length: 68.97, total versions: 709273, 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: 89, data page slots: 145072
Data pages: 145056, average fill: 70%
Primary pages: 145035, secondary pages: 21, swept pages: 28504
Empty pages: 320, full pages: 107046
Fill distribution:
0 - 19% = 1040
20 - 39% = 5046
40 - 59% = 15825
60 - 79% = 116887
80 - 99% = 6258
Index XQD_3300_3400_WA_SO_RO_WKR_SND (0)
Root page: 1472612, depth: 3, leaf buckets: 13464, nodes: 9419353
Average node length: 6.68, total dup: 7816726, max dup: 19
Average key length: 3.66, compression ratio: 11.47
Average prefix length: 40.51, average data length: 1.49
Clustering factor: 2111453, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 1019
40 - 59% = 6511
60 - 79% = 5135
80 - 99% = 796
XQS_1000_1200 (182)
Primary pointer page: 589, Index root page: 590
Total formats: 1, used formats: 1
Average record length: 82.47, total records: 21183405
Average version length: 82.93, total versions: 21207, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.53
Pointer pages: 197, data page slots: 320152
Data pages: 320152, average fill: 81%
Primary pages: 320148, secondary pages: 4, swept pages: 11538
Empty pages: 3, full pages: 320145
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 0
60 - 79% = 48885
80 - 99% = 271261
Index XQS_1000_1200_DOC_ID (1)
Root page: 1426738, depth: 3, leaf buckets: 19582, nodes: 21183405
Average node length: 5.72, total dup: 20701934, max dup: 132
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 3289985, ratio: 0.16
Fill distribution:
0 - 19% = 11
20 - 39% = 0
40 - 59% = 8471
60 - 79% = 562
80 - 99% = 10538
Index XQS_1000_1200_RCV_ID (3)
Root page: 1457002, depth: 3, leaf buckets: 17217, nodes: 21183405
Average node length: 6.31, total dup: 18616010, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 921034, ratio: 0.04
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 806
60 - 79% = 295
80 - 99% = 16111
Index XQS_1000_1200_SND_ID (2)
Root page: 1441095, depth: 3, leaf buckets: 21348, nodes: 21183405
Average node length: 6.35, total dup: 18535177, max dup: 29
Average key length: 2.79, compression ratio: 3.23
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 3584689, ratio: 0.17
Fill distribution:
0 - 19% = 8
20 - 39% = 4
40 - 59% = 8724
60 - 79% = 601
80 - 99% = 12011
Index XQS_1000_1200_WORKER_ID (0)
Root page: 1413370, depth: 3, leaf buckets: 16118, nodes: 21183405
Average node length: 5.56, total dup: 21183305, max dup: 230856
Average key length: 2.00, compression ratio: 1.21
Average prefix length: 2.42, average data length: 0.00
Clustering factor: 949722, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 2900
60 - 79% = 361
80 - 99% = 12850
XQS_1000_3300 (184)
Primary pointer page: 593, Index root page: 594
Total formats: 1, used formats: 1
Average record length: 77.10, total records: 9878591
Average version length: 82.62, total versions: 715700, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.63
Pointer pages: 106, data page slots: 172816
Data pages: 172800, average fill: 71%
Primary pages: 172771, secondary pages: 29, swept pages: 44855
Empty pages: 500, full pages: 121352
Fill distribution:
0 - 19% = 1486
20 - 39% = 6925
40 - 59% = 22689
60 - 79% = 110508
80 - 99% = 31192
Index XQS_1000_3300_DOC_ID (1)
Root page: 1367524, depth: 3, leaf buckets: 11333, nodes: 9878591
Average node length: 5.37, total dup: 9569796, max dup: 206
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 2202921, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 63
40 - 59% = 7534
60 - 79% = 3615
80 - 99% = 118
Index XQS_1000_3300_RCV_ID (3)
Root page: 1379283, depth: 3, leaf buckets: 13735, nodes: 9878591
Average node length: 6.24, total dup: 8192063, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1548479, ratio: 0.16
Fill distribution:
0 - 19% = 128
20 - 39% = 3703
40 - 59% = 4852
60 - 79% = 2648
80 - 99% = 2404
Index XQS_1000_3300_SND_ID (2)
Root page: 1373081, depth: 3, leaf buckets: 12646, nodes: 9878591
Average node length: 5.98, total dup: 8582725, max dup: 44
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 2402333, ratio: 0.24
Fill distribution:
0 - 19% = 3
20 - 39% = 48
40 - 59% = 8555
60 - 79% = 3900
80 - 99% = 140
Index XQS_1000_3300_WORKER_ID (0)
Root page: 1362789, depth: 3, leaf buckets: 10255, nodes: 9878591
Average node length: 5.14, total dup: 9878491, max dup: 148623
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 1567504, ratio: 0.16
Fill distribution:
0 - 19% = 39
20 - 39% = 1178
40 - 59% = 5146
60 - 79% = 1747
80 - 99% = 2145
XQS_1200_2000 (183)
Primary pointer page: 591, Index root page: 592
Total formats: 1, used formats: 1
Average record length: 78.72, total records: 11415373
Average version length: 82.52, total versions: 555931, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.60
Pointer pages: 119, data page slots: 192912
Data pages: 191384, average fill: 74%
Primary pages: 191269, secondary pages: 115, swept pages: 52405
Empty pages: 2615, full pages: 155290
Fill distribution:
0 - 19% = 4112
20 - 39% = 5736
40 - 59% = 14128
60 - 79% = 96349
80 - 99% = 71059
Index XQS_1200_2000_DOC_ID (1)
Root page: 1392123, depth: 3, leaf buckets: 13103, nodes: 11415373
Average node length: 5.29, total dup: 11305888, max dup: 682
Average key length: 2.08, compression ratio: 4.33
Average prefix length: 8.93, average data length: 0.07
Clustering factor: 2399337, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 79
40 - 59% = 8941
60 - 79% = 3970
80 - 99% = 113
Index XQS_1200_2000_RCV_ID (3)
Root page: 1406132, depth: 3, leaf buckets: 10506, nodes: 11415373
Average node length: 5.49, total dup: 10917862, max dup: 49
Average key length: 2.28, compression ratio: 3.95
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 740700, ratio: 0.06
Fill distribution:
0 - 19% = 157
20 - 39% = 826
40 - 59% = 2591
60 - 79% = 1886
80 - 99% = 5046
Index XQS_1200_2000_SND_ID (2)
Root page: 1398660, depth: 3, leaf buckets: 14987, nodes: 11415373
Average node length: 6.02, total dup: 9968329, max dup: 66
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 2415761, ratio: 0.21
Fill distribution:
0 - 19% = 3
20 - 39% = 97
40 - 59% = 10485
60 - 79% = 4243
80 - 99% = 159
Index XQS_1200_2000_WORKER_ID (0)
Root page: 1386233, depth: 3, leaf buckets: 10877, nodes: 11415373
Average node length: 5.22, total dup: 11415273, max dup: 187958
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 728634, ratio: 0.06
Fill distribution:
0 - 19% = 91
20 - 39% = 793
40 - 59% = 4936
60 - 79% = 1542
80 - 99% = 3515
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: 77.48, total records: 9990938
Average version length: 82.91, total versions: 712138, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.63
Pointer pages: 109, data page slots: 176480
Data pages: 176400, average fill: 71%
Primary pages: 176375, secondary pages: 25, swept pages: 48798
Empty pages: 460, full pages: 117952
Fill distribution:
0 - 19% = 1538
20 - 39% = 7316
40 - 59% = 24294
60 - 79% = 112857
80 - 99% = 30395
Index XQS_2100_3300_DOC_ID (1)
Root page: 1344708, depth: 3, leaf buckets: 11983, nodes: 9990938
Average node length: 5.18, total dup: 9961795, max dup: 1703
Average key length: 2.03, compression ratio: 4.43
Average prefix length: 8.97, average data length: 0.03
Clustering factor: 2019008, ratio: 0.20
Fill distribution:
0 - 19% = 28
20 - 39% = 1470
40 - 59% = 7874
60 - 79% = 2000
80 - 99% = 611
Index XQS_2100_3300_RCV_ID (3)
Root page: 1355739, depth: 3, leaf buckets: 13936, nodes: 9990938
Average node length: 6.25, total dup: 8284446, max dup: 14
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 1517777, ratio: 0.15
Fill distribution:
0 - 19% = 242
20 - 39% = 3682
40 - 59% = 4855
60 - 79% = 2606
80 - 99% = 2551
Index XQS_2100_3300_SND_ID (2)
Root page: 1350071, depth: 3, leaf buckets: 12581, nodes: 9990938
Average node length: 5.44, total dup: 9547174, max dup: 115
Average key length: 2.28, compression ratio: 3.94
Average prefix length: 8.76, average data length: 0.24
Clustering factor: 2155433, ratio: 0.22
Fill distribution:
0 - 19% = 35
20 - 39% = 1332
40 - 59% = 8814
60 - 79% = 1789
80 - 99% = 611
Index XQS_2100_3300_WORKER_ID (0)
Root page: 987843, depth: 3, leaf buckets: 10418, nodes: 9990938
Average node length: 5.16, total dup: 9990838, max dup: 150743
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.40, average data length: 0.00
Clustering factor: 1593055, ratio: 0.16
Fill distribution:
0 - 19% = 44
20 - 39% = 1226
40 - 59% = 5262
60 - 79% = 1674
80 - 99% = 2212
XQS_3300_3400 (187)
Primary pointer page: 599, Index root page: 600
Total formats: 1, used formats: 1
Average record length: 66.95, total records: 580636
Average version length: 68.84, total versions: 11916, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 126.00, compression ratio: 1.88
Pointer pages: 5, data page slots: 8048
Data pages: 8048, average fill: 76%
Primary pages: 8048, secondary pages: 0, swept pages: 2493
Empty pages: 4, full pages: 7720
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 36
60 - 79% = 7781
80 - 99% = 226
Index XQS_3300_3400_DOC_ID (1)
Root page: 36966, depth: 3, leaf buckets: 739, nodes: 580636
Average node length: 5.95, total dup: 494191, max dup: 83
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 102331, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 518
60 - 79% = 92
80 - 99% = 99
Index XQS_3300_3400_SND_ID (2)
Root page: 30097, depth: 3, leaf buckets: 758, nodes: 580636
Average node length: 6.15, total dup: 476036, max dup: 25
Average key length: 3.29, compression ratio: 2.73
Average prefix length: 7.88, average data length: 1.12
Clustering factor: 102380, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 17
40 - 59% = 536
60 - 79% = 99
80 - 99% = 105
Index XQS_3300_3400_WORKER_ID (0)
Root page: 377587, depth: 2, leaf buckets: 562, nodes: 580636
Average node length: 4.86, total dup: 580536, max dup: 9820
Average key length: 2.00, compression ratio: 1.20
Average prefix length: 2.41, average data length: 0.00
Clustering factor: 90998, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 317
60 - 79% = 74
80 - 99% = 139
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 Mon Mar 25 07:09:37 2024
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
MAX_VERSIONS |
VERS_TO_RECS_PRC |
MAXV_TO_VERS_PRC |
DOC_DATA |
7812491 |
148272 |
1 |
0.0000 |
0.0000 |
DOC_LIST |
2274599 |
78106 |
2 |
0.0000 |
0.0000 |
FB_ERRORS |
2182 |
757 |
1 |
0.0000 |
0.0000 |
INVNT_SALDO |
400 |
2266 |
6 |
500.0000 |
0.0000 |
INVNT_TURNOVER_LOG |
119523 |
106775 |
1 |
0.0000 |
0.0000 |
MONEY_SALDO |
49 |
250 |
8 |
500.0000 |
0.0000 |
MONEY_TURNOVER_LOG |
1790 |
1646 |
1 |
0.0000 |
0.0000 |
PDISTR |
849921 |
47347 |
3 |
0.0000 |
0.0000 |
PERF_SPLIT_0 |
187371 |
35681 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_1 |
140585 |
13005 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_2 |
165518 |
21273 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_3 |
145007 |
3460 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_4 |
139767 |
1965 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_5 |
153568 |
3939 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_6 |
164385 |
14339 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_7 |
172655 |
28042 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_8 |
173060 |
24860 |
1 |
0.0000 |
0.0000 |
PERF_SPLIT_9 |
141552 |
2515 |
1 |
0.0000 |
0.0000 |
PSTORNED |
2126440 |
68062 |
1 |
0.0000 |
0.0000 |
SEMAPHORES |
5 |
1 |
1 |
0.0000 |
100.0000 |
XQD_1000_1200 |
165551 |
83292 |
1 |
0.0000 |
0.0000 |
XQD_1000_3300 |
7352673 |
582603 |
1 |
0.0000 |
0.0000 |
XQD_1200_2000 |
12373909 |
485261 |
1 |
0.0000 |
0.0000 |
XQD_2000_3300 |
1997124 |
583065 |
1 |
0.0000 |
0.0000 |
XQD_2100_3300 |
1618590 |
197086 |
1 |
0.0000 |
0.0000 |
XQD_3300_3400 |
9429733 |
709273 |
1 |
0.0000 |
0.0000 |
XQS_1000_1200 |
21183405 |
21207 |
1 |
0.0000 |
0.0000 |
XQS_1000_3300 |
9878591 |
715700 |
1 |
0.0000 |
0.0000 |
XQS_1200_2000 |
11415373 |
555931 |
1 |
0.0000 |
0.0000 |
XQS_2100_3300 |
9990938 |
712138 |
1 |
0.0000 |
0.0000 |
XQS_3300_3400 |
580636 |
11916 |
1 |
0.0000 |
0.0000 |
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:102:
:103: mscs-test-161.budzdorov.ru Mon Mar 25 07:08:03 2024
:104: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:105:
--- end of diff output ---
25.03.24 07: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-03-25 07:09:52 |
No severe PSQL-related problems occured |
25.03.24 07:09:53. End of report.