Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2021 16:33
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17316892 kB
MemAvailable 31528284 kB
Buffers 0 kB
Cached 14330044 kB
SwapCached 0 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 and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
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=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-17 16:32:50
DTS_END                         2021-03-17 16:32:50.1240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36106
TRN_ID                          233867
ATT_ID                          665
EXC_UNIT                        2


Test workload details

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

Indexes for heavy-loaded tables

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

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9004.81 24248 1080577
customer order: creation 165.83 373 19900
customer order: refuse 14.27 399 1712
order to supplier: creation 45.33 1355 5439
order to supplier: removal 3.50 112020 420
invoice (draft): creation 45.48 3853 5458
invoice (draft): removal 51.85 934 6222
invoice accept: apply 40.84 20694 4901
invoice accept: cancel 46.49 979 5579
customer reserve: creation 3711.83 208 445419
customer reserve: removal 4595.66 65 551479
realization accept: apply 80.00 228 9600
realization accept: cancel 77.27 127 9272
payment from customer: creation 56.83 158 6819
payment from customer: removal 5.58 120 669
payment to supplier: creation 48.13 191 5775
payment to supplier: removal 3.43 94 412
service: total inventory turnovers 4.73 1263 568
service: total monetary turnovers 6.83 32 820
service: aggregate perf. data 0.91 18006 109
service: refresh index statistics 0.03 323863 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2021 16:34:00 to 17-03-2021 16:34:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1948
TEST_TIME 2 2281
TEST_TIME 3 2542
TEST_TIME 4 2422
TEST_TIME 5 3079
TEST_TIME 6 3387
TEST_TIME 7 3493
TEST_TIME 8 3757
TEST_TIME 9 3882
TEST_TIME 10 4676
TEST_TIME 11 4992
TEST_TIME 12 5329
TEST_TIME 13 5639
TEST_TIME 14 5619
TEST_TIME 15 5604
TEST_TIME 16 5599
TEST_TIME 17 5909
TEST_TIME 18 6016
TEST_TIME 19 6225
TEST_TIME 20 6727
TEST_TIME 21 6901
TEST_TIME 22 7131
TEST_TIME 23 7426
TEST_TIME 24 7417
TEST_TIME 25 7819
TEST_TIME 26 7677
TEST_TIME 27 7814
TEST_TIME 28 8036
TEST_TIME 29 8539
TEST_TIME 30 8666
TEST_TIME 31 8588
TEST_TIME 32 8780
TEST_TIME 33 8870
TEST_TIME 34 9623
TEST_TIME 35 9735
TEST_TIME 36 9556
TEST_TIME 37 9608
TEST_TIME 38 9609
TEST_TIME 39 9521
TEST_TIME 40 9573
TEST_TIME 41 9458
TEST_TIME 42 9309
TEST_TIME 43 9236
TEST_TIME 44 9416
TEST_TIME 45 9435
TEST_TIME 46 9365
TEST_TIME 47 9296
TEST_TIME 48 9172
TEST_TIME 49 9135
TEST_TIME 50 9094
TEST_TIME 51 9098
TEST_TIME 52 9072
TEST_TIME 53 9054
TEST_TIME 54 9115
TEST_TIME 55 9153
TEST_TIME 56 9074
TEST_TIME 57 9008
TEST_TIME 58 8907
TEST_TIME 59 9048
TEST_TIME 60 9031
TEST_TIME 61 9036
TEST_TIME 62 9083
TEST_TIME 63 9049
TEST_TIME 64 9031
TEST_TIME 65 9039
TEST_TIME 66 9022
TEST_TIME 67 9161
TEST_TIME 68 9146
TEST_TIME 69 9120
TEST_TIME 70 9154
TEST_TIME 71 9259
TEST_TIME 72 9218
TEST_TIME 73 9279
TEST_TIME 74 9293
TEST_TIME 75 9291
TEST_TIME 76 9307
TEST_TIME 77 9211
TEST_TIME 78 9267
TEST_TIME 79 9215
TEST_TIME 80 9158
TEST_TIME 81 9107
TEST_TIME 82 9153
TEST_TIME 83 9161
TEST_TIME 84 9116
TEST_TIME 85 9132
TEST_TIME 86 9099
TEST_TIME 87 9075
TEST_TIME 88 8996
TEST_TIME 89 9016
TEST_TIME 90 8996
TEST_TIME 91 9050
TEST_TIME 92 9012
TEST_TIME 93 9051
TEST_TIME 94 9032
TEST_TIME 95 9067
TEST_TIME 96 9068
TEST_TIME 97 9137
TEST_TIME 98 9167
TEST_TIME 99 9133
TEST_TIME 100 9113
TEST_TIME 101 9131
TEST_TIME 102 9177
TEST_TIME 103 9191
TEST_TIME 104 9188
TEST_TIME 105 9233
TEST_TIME 106 9154
TEST_TIME 107 9101
TEST_TIME 108 9094
TEST_TIME 109 9066
TEST_TIME 110 9026
TEST_TIME 111 8997
TEST_TIME 112 9009
TEST_TIME 113 8965
TEST_TIME 114 8964
TEST_TIME 115 8968
TEST_TIME 116 8941
TEST_TIME 117 8959
TEST_TIME 118 8920
TEST_TIME 119 8934
TEST_TIME 120 9008

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2021 16:34:04 to 17-03-2021 16:34:07.

Performance in DETAILS

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 1493001 1493001 0 0.00 0 30399 8 0 0
doc_list_biud 1492997 1492997 0 0.00 0 70450 31 0 0
sp_add_invoice_to_stock 5012 4901 111 2.21 39 197819 20695 0 111
sp_cancel_adding_invoice 5579 5579 0 0.00 5 87589 979 0 0
sp_cancel_client_order 1712 1712 0 0.00 4 8208 400 0 0
sp_cancel_customer_reserve 551479 551479 0 0.00 1 25843 66 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 2 14123 121 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 10002 94 0 0
sp_cancel_supplier_invoice 6224 6222 2 0.03 1 70521 935 0 2
sp_cancel_supplier_order 420 420 0 0.00 7 1160300 112021 0 0
sp_cancel_write_off 9272 9272 0 0.00 1 14751 128 0 0
sp_client_order 19900 19900 0 0.00 3 24819 374 0 0
sp_customer_reserve 445419 445419 0 0.00 0 106842 208 0 0
sp_fill_shopping_cart 30785 30785 0 0.00 1 16631 44 0 0
sp_fill_shopping_cart_clo_res 445414 445414 0 0.00 0 19357 14 0 0
sp_get_clo_for_invoice 4896 4896 0 0.00 0 20339 269 0 0
sp_kill_cost_storno 15932 15932 0 0.00 0 14258 75 0 0
sp_kill_qstorno_ret_qs2qd 1118872 1118872 0 0.00 0 70448 36 0 0
sp_kill_qty_storno 589180 589180 0 0.00 0 70449 78 0 0
sp_lock_selected_doc 20107 20107 0 0.00 0 7505 4 0 0
sp_make_cost_storno 27090 27090 0 0.00 0 17517 83 0 0
sp_multiply_rows_for_pdistr 27090 27090 0 0.00 0 15110 42 0 0
sp_multiply_rows_for_qdistr 19899 19899 0 0.00 0 19618 158 0 0
sp_pay_from_customer 6819 6819 0 0.00 4 30189 158 0 0
sp_pay_to_supplier 5775 5775 0 0.00 4 30885 192 0 0
sp_payment_common 12594 12594 0 0.00 2 16975 49 0 0
sp_qd_handle_on_cancel_clo 1712 1712 0 0.00 0 8201 375 0 0
sp_qd_handle_on_invoice_upd_sts 10475 10475 0 0.00 0 24434 413 0 0
sp_qd_handle_on_reserve_upd_sts 9600 9600 0 0.00 0 19579 66 0 0
sp_reserve_write_off 9600 9600 0 0.00 6 21623 229 0 0
sp_supplier_invoice 5458 5458 0 0.00 7 121556 3854 0 0
sp_supplier_order 5439 5439 0 0.00 5 29552 1356 0 0
srv_aggregate_perf_data 109 109 0 0.00 3037 164536 18006 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 841 147037 28065 0 0
srv_find_qd_qs_mism 1034259 1034259 0 0.00 0 24929 6 0 0
srv_make_invnt_saldo 568 568 0 0.00 40 83426 1264 0 0
srv_make_money_saldo 820 820 0 0.00 1 1386 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 125321 561454 323863 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4901 4901 0 0.00 0 22472 189 0 0
t$perf-norm:sp_cancel_adding_invoice 383 383 0 0.00 1 4241 134 0 0
t$perf-norm:sp_cancel_client_order 1712 1712 0 0.00 0 2385 16 0 0
t$perf-norm:sp_cancel_customer_reserve 637 637 0 0.00 0 10733 30 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 8442 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 10789 40 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 994 21 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 37951 1968 0 0
t$perf-norm:sp_cancel_write_off 949 949 0 0.00 0 2885 15 0 0
t$perf-norm:sp_client_order 19900 19900 0 0.00 0 12711 23 0 0
t$perf-norm:sp_customer_reserve 912 912 0 0.00 0 2142 7 0 0
t$perf-norm:sp_pay_from_customer 6819 6819 0 0.00 0 5038 10 0 0
t$perf-norm:sp_pay_to_supplier 5775 5775 0 0.00 0 9468 12 0 0
t$perf-norm:sp_reserve_write_off 9600 9600 0 0.00 0 6529 10 0 0
t$perf-norm:sp_supplier_invoice 5458 5458 0 0.00 0 19479 27 0 0
t$perf-norm:sp_supplier_order 5439 5439 0 0.00 0 2381 17 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 655 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 896 10 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 815 28 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 3318 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10014 9792 222 2.21 0 9947 21 0 222
v_all_customers 36166 36166 0 0.00 0 21 1 0 0
v_all_suppliers 29966 29966 0 0.00 0 21 1 0 0
v_all_wares 39798 39798 0 0.00 0 219 1 0 0
v_cancel_adding_invoice 766 766 0 0.00 0 1643 10 0 0
v_cancel_client_order 3424 3424 0 0.00 0 1575 4 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 5726 8 0 0
v_cancel_customer_reserve 1274 1274 0 0.00 0 285 3 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 3099 8 0 0
v_cancel_supplier_invoice 862 858 4 0.46 0 4730 26 0 4
v_cancel_supplier_order 840 840 0 0.00 0 220 3 0 0
v_cancel_write_off 1898 1898 0 0.00 0 4741 17 0 0
v_max_id_clo_ord 5437 5437 0 0.00 0 815 1 0 0
v_max_id_clo_res 912 912 0 0.00 0 8447 19 0 0
v_max_id_ord_sup 5449 5449 0 0.00 0 4016 5 0 0
v_max_non_paid_invoice 1678 1678 0 0.00 0 1375 3 0 0
v_max_non_paid_realizn 3653 3653 0 0.00 0 5040 5 0 0
v_min_id_clo_ord 5437 5437 0 0.00 0 13705 15 0 0
v_min_id_clo_res 912 912 0 0.00 0 2269 9 0 0
v_min_id_ord_sup 5449 5449 0 0.00 0 8013 12 0 0
v_min_non_paid_invoice 5775 5775 0 0.00 0 16969 45 0 0
v_min_non_paid_realizn 6819 6819 0 0.00 0 13810 31 0 0
v_our_firm 9964 9964 0 0.00 0 21 1 0 0
v_reserve_write_off 19200 19200 0 0.00 0 7275 7 0 0
x_lock_depdocs_on_canc_invoice 11372 11372 0 0.00 0 22667 135 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 7787 444 0 0
x_make_qstorno_1000_1200 5439 5439 0 0.00 1 29534 1250 0 0
x_make_qstorno_1200_2000 5458 5458 0 0.00 4 121537 3706 0 0
x_make_qstorno_2100_3300 445419 445419 0 0.00 0 106841 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2021 16:34:08 to 17-03-2021 16:34:12.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:02:53 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:03:00 9572 8192000000 10185971088 10480177152 836220384 9.262 67 54 107 0 856964832 2246944 18497504
14:03:18 29321 8192000000 10345776000 10659962880 1372335360 14.348 100 81 163 0 1402695104 4136960 26222784
14:03:58 30850 8192000000 10385351120 10705338368 1431028384 14.870 100 83 165 0 1463292384 6163392 26100608
14:04:38 8907 8192000000 10402621888 10725425152 1461638672 15.140 100 91 182 1 1498218992 7526832 29053488
14:04:59 31893 8192000000 10435838784 10762108928 1484176992 15.338 100 92 184 0 1521649488 8326912 29145584
14:05:51 15097 8192000000 10445298272 10775609344 1499667168 15.473 100 93 186 0 1538924288 9617152 29639968
14:06:21 23208 8192000000 10458967200 10794885120 1506469616 15.533 100 84 168 1 1542778400 9692496 26616288
14:06:54 19715 8192000000 10476347808 10811883520 1526085712 15.703 100 86 172 1 1562767472 9974496 26707264
14:07:23 19958 8192000000 10506393488 10849218560 1561892944 16.013 100 87 174 0 1598590208 10460720 26236544
14:07:55 18951 8192000000 10530225856 10880204800 1590128480 16.255 100 85 170 2 1626714656 10866048 25720128
14:08:22 11858 8192000000 10549324240 10902556672 1601807024 16.355 100 78 153 3 1636346048 11769392 22769632
14:08:45 7668 8192000000 10570757024 10925596672 1624171168 16.545 100 83 166 0 1661005408 12020720 24813520
14:09:00 9606 8192000000 10579340080 10939125760 1634566096 16.634 100 72 144 0 1667549232 11793136 21190000
14:09:17 12686 8192000000 10605572064 10966589440 1661745136 16.864 100 81 159 3 1698218736 13054288 23419312
14:09:39 8008 8192000000 10621497888 10983759872 1676822496 16.991 100 81 162 2 1714035888 13311072 23902320
14:09:55 13161 8192000000 10639266976 11005468672 1695854928 17.150 100 83 163 1 1733865648 13939776 24070944
14:10:16 9088 8192000000 10647863360 11017691136 1706827648 17.242 100 83 164 1 1744050800 13641648 23581504
14:10:32 7870 8192000000 10667886160 11038236672 1728036288 17.419 100 85 168 2 1765262848 12663088 24563472
14:10:49 6617 8192000000 10671164288 11046432768 1733213728 17.462 100 81 163 1 1770326496 13899360 23213408
14:11:02 5860 8192000000 10685967824 11058896896 1741845472 17.534 100 78 154 1 1776542880 12816224 21881184
14:11:15 6894 8192000000 10694481200 11068874752 1754769808 17.641 100 79 154 1 1788599680 12548304 21281568
14:11:28 4417 8192000000 10696772672 11074629632 1762283520 17.703 100 77 152 1 1795965344 12332352 21349472
14:11:40 4209 8192000000 10713226272 11087503360 1772807504 17.790 100 80 156 2 1807757840 13178496 21771840
14:11:50 3190 8192000000 10718707824 11094114304 1779190544 17.843 100 78 154 0 1813111024 12793136 21127344
14:12:00 4580 8192000000 10732269536 11109736448 1786512880 17.903 100 86 172 2 1824429392 14369968 23546544
14:12:12 3403 8192000000 10736505296 11112394752 1792987968 17.956 100 87 174 1 1832038144 14672192 24377984
14:12:22 2907 8192000000 10746750640 11124850688 1801281728 18.024 100 88 175 1 1839588992 13950016 24357248
14:12:31 8569 8192000000 10744124656 11127410688 1806880400 18.070 100 83 166 0 1844464944 14457504 23127040
14:12:47 2642 8192000000 10760360592 11141410816 1817714992 18.159 100 90 179 1 1856459664 14127312 24617360
14:12:56 1992 8192000000 10764692160 11147116544 1824198240 18.212 100 90 178 0 1863573200 14328320 25046640
14:13:05 3029 8192000000 10769389904 11151147008 1830289808 18.262 100 87 174 4 1868735856 13792880 24653168
14:13:15 3253 8192000000 10781104880 11167117312 1835503600 18.304 100 93 183 0 1873841200 12420288 25917312
14:13:25 2720 8192000000 10789023136 11171766272 1842846480 18.364 100 85 168 2 1880919168 13261280 24811408
14:13:34 1610 8192000000 10791180768 11173892096 1849223552 18.416 100 88 176 1 1887507184 13429568 24854064
14:13:42 1484 8192000000 10794662272 11177308160 1848199520 18.407 100 95 190 0 1889578720 15090064 26289136
14:13:51 1944 8192000000 10794512672 11178622976 1853377568 18.450 100 87 172 2 1891245712 13348000 24520144
14:13:59 1660 8192000000 10802183392 11188088832 1856176800 18.472 100 92 182 2 1896055584 13518448 26360336
14:14:07 1440 8192000000 10805014192 11190329344 1861114480 18.512 100 97 197 1 1901582400 13231472 27236448
14:14:15 2878 8192000000 10806420960 11190046720 1859766704 18.501 100 91 182 0 1898841264 13102400 25972160
14:14:25 1763 8192000000 10806078288 11192606720 1861513376 18.516 100 83 166 0 1896956928 12132256 23311296
14:14:33 3389 8192000000 10806976592 11195772928 1865582448 18.549 100 85 170 1 1903053968 13554912 23916608
14:14:43 2506 8192000000 10814114208 11202793472 1870774896 18.591 100 87 174 0 1909188064 13124816 25288352
14:15:02 1501 8192000000 10813596128 11202285568 1871091344 18.593 100 93 185 0 1910704640 12771856 26841440
14:15:09 19761 8192000000 10798811488 11197517824 1867799104 18.566 100 62 125 2 1896080064 9451616 18829344
14:15:35 4198 8192000000 10796023456 11199426560 1868514032 18.572 100 61 120 1 1895295712 9315536 17466144
14:15:47 2154 8192000000 10794999728 11205132288 1872149152 18.602 100 58 116 1 1897755152 9548112 16057888
14:15:55 4545 8192000000 10789937600 11202924544 1868297024 18.570 100 44 87 2 1891049312 9804896 12947392
14:16:09 4293 8192000000 10791197648 11203379200 1869132672 18.577 100 42 84 0 1889941936 9046176 11763088
14:16:21 3197 8192000000 10787091664 11201654784 1869283568 18.578 100 43 85 0 1889551872 8567072 11701232
14:16:32 6205 8192000000 10785074272 11201523712 1870333264 18.587 100 38 75 1 1887875792 7431600 10110928
14:16:45 12955 8192000000 10782267328 11204243456 1868178160 18.570 100 15 30 0 1878283248 5794480 4310608
14:17:08 10931 8192000000 10776549648 11204280320 1871993968 18.600 100 28 56 1 1885052160 5750784 7307408
14:17:32 7032 8192000000 10781101328 11207790592 1875027536 18.625 100 31 61 2 1890955488 6446976 9480976
14:17:46 7888 8192000000 10791736912 11216363520 1878234608 18.651 100 25 48 2 1892791072 7738720 6817744
14:18:03 5801 8192000000 10792886624 11216396288 1880381744 18.668 100 26 52 1 1895532032 7443584 7706704
14:18:17 9378 8192000000 10806106160 11225579520 1886213520 18.715 100 36 71 0 1902494896 5158768 11122608
14:18:34 70260 8192000000 10820929616 11235397632 1887676784 18.727 100 28 56 0 1902163152 6087440 8398928
14:19:51 4696 8192000000 10815112256 11241529344 1898521904 18.814 100 51 102 0 1922530816 9911888 14097024
14:20:03 5717 8192000000 10805313472 11235770368 1890382976 18.749 100 21 43 2 1901927904 6086784 5458144
14:20:17 7429 8192000000 10810293152 11240075264 1893868544 18.777 100 26 52 3 1907220768 6074000 7278224
14:20:30 3565 8192000000 10812447840 11242708992 1898253840 18.812 100 34 68 1 1914907696 7427856 9226000
14:20:41 7543 8192000000 10817815792 11247939584 1900659648 18.832 100 32 63 3 1916874336 6821648 9393040
14:20:55 6159 8192000000 10820806928 11250044928 1901470944 18.838 100 30 58 2 1916283296 6057824 8754528
14:21:10 7132 8192000000 10809404368 11245342720 1902112576 18.843 100 25 50 1 1914919600 5533392 7273632
14:21:26 6124 8192000000 10813711856 11250679808 1905942320 18.874 100 21 42 1 1918308048 6319152 6046576
14:21:39 5753 8192000000 10816145264 11245793280 1886477264 18.717 99 25 50 2 1899640096 6189088 6973744
14:21:52 7275 8192000000 10816049648 11252375552 1901494304 18.838 100 22 42 3 1914845840 7201168 6150368
14:22:08 7603 8192000000 10819503920 11257987072 1906033712 18.875 100 17 34 1 1915357488 5057264 4266512
14:22:23 6184 8192000000 10820058992 11255418880 1908508144 18.895 100 24 47 0 1921517664 5489248 7520272
14:22:37 10011 8192000000 10818315104 11256655872 1908918960 18.898 100 19 38 3 1920422160 6305616 5197584
14:22:57 14475 8192000000 10802381520 11239059456 1866526064 18.556 98 12 24 0 1875324656 5610944 3187648
14:23:17 15521 8192000000 10791563552 11223748608 1844578256 18.378 97 21 43 0 1855894112 5425344 5890512
14:24:06 43640 8192000000 10760226688 11192688640 1777327120 17.827 94 27 54 1 1791006704 5166448 8513136
14:24:58 6069 8192000000 10772749152 11188248576 1815764368 18.143 98 31 63 0 1829446544 5012192 8669984
14:25:13 6893 8192000000 10761690544 11190145024 1825703984 18.224 98 33 67 0 1842077040 7072720 9300336
14:25:26 8409 8192000000 10721716592 11141308416 1747220912 17.579 94 20 40 2 1757412432 5388624 4802896
14:25:42 10493 8192000000 10732342400 11147231232 1706429616 17.239 93 29 58 0 1720472560 5312384 8730560
14:26:00 6396 8192000000 10743788976 11164078080 1823521024 18.206 100 22 43 1 1835691824 5933776 6237024
14:26:13 11362 8192000000 10693224336 11105529856 1647630752 16.744 91 25 50 0 1660552992 5778960 7143280
14:26:32 6054 8192000000 10694292128 11100086272 1743672624 17.549 98 29 58 2 1758875952 6252560 8950768
14:26:48 8246 8192000000 10694378496 11101175808 1741919040 17.535 98 23 42 2 1758054672 9641680 6493952
14:27:04 6685 8192000000 10702490224 11116904448 1754431776 17.638 98 26 52 2 1767338048 5505184 7401088
14:27:19 7891 8192000000 10698657136 11122642944 1777835792 17.832 99 21 42 3 1789727344 6012944 5878608
14:27:43 12288 8192000000 10724228432 11133698048 1777021760 17.825 99 25 50 0 1790130064 6152784 6955520
14:28:03 10232 8192000000 10720987488 11133460480 1753516800 17.631 97 21 41 3 1764350752 5099440 5734512
14:28:19 58198 8192000000 10719060144 11132416000 1777487504 17.829 98 35 71 0 1793580944 4977168 11116272
14:29:24 25521 8192000000 10709755456 11135090688 1773683888 17.797 98 15 30 0 1784253120 5335952 5233280
14:29:56 6275 8192000000 10738562976 11155648512 1816892400 18.152 100 27 54 0 1830544176 6352336 7299440
14:30:11 3722 8192000000 10745808688 11153866752 1821161504 18.187 100 35 68 4 1836536960 5420528 9954928
14:30:22 6717 8192000000 10761625840 11174060032 1833888928 18.291 100 48 96 1 1856618816 9418016 13311872
14:30:36 6622 8192000000 10738766416 11161628672 1811409616 18.107 99 25 50 1 1824957536 6226848 7321072
14:30:52 12163 8192000000 10746148960 11172093952 1836438208 18.312 100 22 44 1 1848405056 5513424 6453424
14:31:12 7427 8192000000 10755328944 11177799680 1836350304 18.311 100 21 42 1 1847914448 5916192 5647952
14:31:27 6928 8192000000 10754310608 11180777472 1842269584 18.359 100 30 60 1 1856813728 5666672 8877472
14:31:41 8859 8192000000 10764058640 11185664000 1847015584 18.398 100 27 54 2 1860467488 5024480 8427424
14:31:57 10811 8192000000 10784202816 11209322496 1854508992 18.459 100 30 59 2 1873087360 10090320 8488048
14:32:18 4834 8192000000 10797533568 11210555392 1875414592 18.628 100 35 72 0 1890323040 4945680 9962768
14:32:31 12478 8192000000 10791923968 11220291584 1877281216 18.643 100 18 34 4 1887703024 5477776 4944032
14:32:51 45878 8192000000 10819382880 11238744064 1893201568 18.772 100 29 57 1 1907674176 5367696 9104912
14:33:59 26477 8192000000 10840060896 11265216512 1915575840 18.951 100 40 80 1 1936956032 8912832 12467360
14:34:35 47080 8192000000 10861932688 11284459520 1929918624 19.066 100 43 86 0 1954513888 11663760 12931504
14:35:40 135203 8192000000 10863657856 11306086400 1940114656 19.148 100 36 72 0 1965442656 14108864 11219136
14:38:03 15908 8192000000 10880104176 11314036736 1946680608 19.200 100 31 62 1 1971434544 15448128 9305808
14:38:27 7706 8192000000 10886476768 11316822016 1952090352 19.243 100 45 90 1 1982220816 16681392 13449072
14:38:42 14092 8192000000 10898459152 11326291968 1957455552 19.286 100 50 100 1 1988698560 16196624 15046384
14:39:07 14855 8192000000 10909771680 11333922816 1962543120 19.326 100 55 110 1 1995029232 16836224 15649888
14:39:32 22335 8192000000 10909781376 11340976128 1967214784 19.363 100 45 88 1 1997604480 17065280 13324416
14:40:03 7663 8192000000 10914890048 11342532608 1971716688 19.399 100 57 111 2 2005054864 17363008 15975168
14:40:21 11553 8192000000 10912650288 11343233024 1971079728 19.394 100 52 104 1 2004069904 18157680 14832496
14:40:40 3088 8192000000 10924664576 11348455424 1975993920 19.433 100 65 128 1 2012383088 18345104 18044064
14:40:54 15663 8192000000 10927604368 11353366528 1977224672 19.443 100 60 119 2 2016272960 20780336 18267952
14:41:19 15587 8192000000 10925437776 11352743936 1958325984 19.293 99 55 109 2 1997743120 23552256 15864880
14:41:45 12675 8192000000 10928285200 11364810752 1976368688 19.436 100 41 82 0 2013727296 24901072 12457536
14:42:06 7494 8192000000 10931063184 11369107456 1981603744 19.477 100 46 90 1 2017567040 22818992 13144304
14:42:23 3392 8192000000 10960499856 11385688064 1991013728 19.552 100 67 132 1 2041318976 30876480 19428768
14:42:34 13022 8192000000 10937565824 11372752896 1992109184 19.560 100 73 142 4 2039589632 26468496 21011952
14:42:59 12709 8192000000 10951724800 11383263232 1995381280 19.586 100 57 114 0 2038619104 26297024 16940800
14:43:23 3913 8192000000 10943825472 11380314112 1993756080 19.573 100 56 108 1 2034485312 25233936 15495296
14:43:38 3628 8192000000 10949877392 11376197632 1996541664 19.595 100 77 152 0 2045932864 25655296 23735904
14:43:48 3746 8192000000 10954963776 11380498432 1995272944 19.585 100 65 131 2 2040417248 26251328 18892976
14:43:59 5242 8192000000 10955934352 11385720832 1996093024 19.592 100 61 119 0 2040171760 26680432 17398304
14:44:13 2013 8192000000 10977293920 11397210112 2008992080 19.694 100 85 169 1 2061686864 28196272 24498512
14:44:23 4531 8192000000 10972871024 11397926912 2011158544 19.711 100 81 162 2 2065398240 29884016 24355680
14:44:35 16362 8192000000 10970310480 11400175616 2009558032 19.698 100 69 138 4 2056931536 27039600 20333904
14:45:01 10094 8192000000 10940409760 11377942528 1967521872 19.366 98 54 105 1 2007958880 25055488 15381520
14:45:26 11447 8192000000 10951637504 11388567552 2005291760 19.664 100 54 107 0 2041248768 19740208 16216800
14:45:46 4378 8192000000 10962125536 11394850816 2011831840 19.716 100 52 104 2 2048224640 20188496 16204304
14:45:58 8287 8192000000 10966862368 11396349952 2012600448 19.722 100 63 125 2 2052927008 21573552 18753008
14:46:15 7837 8192000000 10964750400 11396976640 1996785744 19.597 99 55 108 2 2034995840 22029664 16180432
14:46:32 7344 8192000000 10963159360 11401805824 2013191136 19.727 100 60 120 0 2054552160 23064736 18296288
14:46:50 8706 8192000000 10972152048 11407278080 2016087072 19.749 100 54 107 3 2055766208 23395488 16283648
14:47:11 7331 8192000000 10977778496 11414585344 2024006528 19.812 100 55 107 2 2065040608 24650944 16383136
14:47:27 10484 8192000000 10961861296 11395317760 1966070240 19.354 97 51 102 0 2006060448 24614304 15375904
14:47:48 4781 8192000000 10976161616 11402805248 2010812624 19.708 100 64 129 0 2056370112 26545088 19012400
14:48:00 3265 8192000000 10980816176 11406852096 2015908704 19.748 100 75 149 2 2064212032 26198416 22104912
14:48:12 5940 8192000000 10961985216 11393851392 1989411888 19.539 99 68 134 1 2035587344 26423520 19751936
14:48:27 2740 8192000000 10980816032 11400376320 2007079936 19.679 100 81 158 0 2058605984 28073424 23452624
14:48:36 6527 8192000000 10975803616 11401863168 2009806672 19.700 100 83 162 1 2064229424 29161936 25260816
14:48:52 7002 8192000000 10955039952 11379261440 1967475072 19.365 98 73 146 0 2020938880 30415360 23048448
14:49:07 5001 8192000000 10973520000 11397971968 2001079760 19.631 100 72 141 3 2053466528 31512912 20873856
14:49:19 2753 8192000000 10973482288 11387183104 1990241120 19.546 99 87 172 2 2049090560 33302720 25546720
14:49:29 2941 8192000000 10975701168 11397144576 2002240752 19.640 100 77 154 1 2059616976 33705552 23670672
14:49:40 11562 8192000000 10965470112 11382587392 1976490640 19.437 98 82 162 2 2033463360 31985488 24987232
14:49:59 2295 8192000000 10978048176 11407867904 2008710144 19.691 100 68 135 2 2060581264 31547488 20323632
14:50:11 1881 8192000000 11000196576 11413225472 2016444112 19.752 100 79 156 0 2072915024 32337200 24133712
14:50:20 2375 8192000000 10991396992 11417776128 2021798608 19.794 100 77 156 1 2078299856 32654224 23847024
14:50:32 1183 8192000000 10993176608 11413073920 2019259280 19.774 100 84 167 2 2078201152 33095168 25846704
14:50:40 1959 8192000000 10987065888 11396325376 1974824864 19.424 98 89 176 1 2036529424 35242384 26462176
14:50:51 3810 8192000000 10955940384 11370930176 1949562720 19.223 97 87 174 0 2011401184 35638128 26200336
14:51:03 3044 8192000000 10976762848 11387883520 1988628032 19.533 100 84 168 3 2051501040 37483072 25389936
14:51:16 4133 8192000000 10969878320 11388915712 1988258688 19.530 100 76 152 0 2050803920 39209072 23336160
14:51:27 840 8192000000 10981011728 11396190208 1991926160 19.559 100 87 174 4 2057140592 39312240 25902192
14:51:34 2227 8192000000 10950918304 11364827136 1962343712 19.325 98 82 164 1 2026435200 39124928 24966560
14:51:43 1966 8192000000 10950521424 11362426880 1963613344 19.335 99 80 161 1 2027086832 38361296 25112192
14:51:51 1076 8192000000 10970117328 11383373824 1964692672 19.343 99 88 176 0 2030774448 39865264 26216512
14:52:00 2347 8192000000 10970933280 11384795136 1979845680 19.463 100 88 176 2 2048997456 41935488 27216288
14:52:09 1970 8192000000 10959878272 11374600192 1963123568 19.331 99 86 173 1 2031909376 42395968 26389840
14:52:18 4672 8192000000 10947300576 11358896128 1954438048 19.262 99 83 164 2 2023022192 43480576 25103568
14:52:35 2333 8192000000 10945313008 11362168832 1953963328 19.258 99 87 172 3 2025756656 44383056 27410272
14:52:48 1740 8192000000 10948491440 11360751616 1956693824 19.280 100 79 156 0 2024892000 43335824 24862352
14:52:58 6077 8192000000 10934143792 11353006080 1957588544 19.287 100 86 170 0 2020956336 37069568 26298224
14:53:12 4700 8192000000 10944786608 11359432704 1960913088 19.313 100 72 143 3 2021137712 37865424 22359200
14:53:26 2519 8192000000 10964590720 11381428224 1976835776 19.440 100 83 164 1 2041191296 39101520 25254000
14:53:40 5258 8192000000 10966824944 11386155008 1978172816 19.450 100 80 159 2 2042379152 39163152 25043184
14:53:53 2555 8192000000 10963366848 11384889344 1984394992 19.499 100 81 162 2 2047321600 37711728 25214880
14:54:03 1329 8192000000 10978906976 11390595072 1990765712 19.550 100 89 178 2 2058386448 39015504 28605232
14:54:12 4180 8192000000 10964502032 11393138688 1989901536 19.543 100 70 138 0 2051975264 39760080 22313648
14:54:23 5368 8192000000 10965210880 11389652992 1982990128 19.488 100 70 139 1 2043894464 38969040 21935296
14:54:38 1931 8192000000 10971553968 11394318336 1992474496 19.563 100 79 158 2 2055630528 38365408 24790624
14:54:49 2145 8192000000 10948950736 11366273024 1955679536 19.272 98 79 155 1 2019128192 37957888 25490768
14:54:58 3924 8192000000 10948779328 11365539840 1954020448 19.258 99 77 152 0 2015096496 37843264 23232784
14:55:09 6788 8192000000 10939998368 11358810112 1955999920 19.274 100 73 146 0 2018016240 38774736 23241584
14:55:23 5928 8192000000 10939441600 11362230272 1961765488 19.320 100 62 123 1 2018181952 37297568 19118896
14:55:42 3895 8192000000 10935129712 11366539264 1965297440 19.348 100 56 112 0 2018096848 34786880 18012528
14:56:02 7405 8192000000 10954945568 11384508416 1980845024 19.471 100 61 119 0 2037215520 37858480 18512016
14:56:18 11048 8192000000 10950228816 11387588608 1981843072 19.479 100 36 71 0 2030972912 36898336 12231504
14:56:36 5889 8192000000 10955518496 11368292352 1957195536 19.284 98 67 134 1 2014786816 35999808 21591472
14:56:51 1548 8192000000 10970275232 11385364480 1978980928 19.457 100 84 166 1 2042185328 37949200 25255200
14:57:03 4083 8192000000 10958502832 11367964672 1967581360 19.366 99 86 171 0 2036401744 42724992 26095392
14:57:13 2732 8192000000 10967381840 11378905088 1975619632 19.430 100 82 165 0 2044756624 44115696 25021296
14:57:22 3371 8192000000 10976821664 11384410112 1979083472 19.457 100 86 170 0 2052274096 46697200 26493424
14:57:32 2072 8192000000 10975044512 11388850176 1978666464 19.454 100 79 158 0 2052427248 48726368 25034416
14:57:53 14498 8192000000 10937349792 11386462208 1953140896 19.251 99 31 62 0 2010710032 46834560 10734576
14:58:15 8443 8192000000 10933501952 11371909120 1947579856 19.207 99 35 68 2 2002509792 42965216 11964720
14:58:42 8218 8192000000 10966382352 11384623104 1970775104 19.392 100 48 95 3 2032971488 46408976 15787408
14:58:57 11670 8192000000 10947487040 11382452224 1961725216 19.320 100 49 98 1 2027309456 49545936 16038304
14:59:20 8025 8192000000 10964084496 11387015168 1969438896 19.381 100 51 103 2 2036186576 49255440 17492240
14:59:35 9565 8192000000 10967283328 11393458176 1974155712 19.418 100 59 116 2 2043850896 50287120 19408064
14:59:54 1912 8192000000 10988391392 11400839168 1984376192 19.499 100 82 163 1 2060172288 50619248 25176848
15:00:03 1547 8192000000 10982276928 11394420736 1963658496 19.335 99 89 177 1 2043678912 51294576 28725840
15:00:13 10038 8192000000 10956668112 11400851456 1975458608 19.429 100 52 104 0 2047474592 54870368 17145616
15:00:30 17033 8192000000 10936702368 11387691008 1965765328 19.352 100 34 68 3 2033885360 56302016 11818016
15:01:02 6969 8192000000 10946456320 11377524736 1930097456 19.068 98 49 98 1 1997227952 51052720 16077776
15:01:17 9331 8192000000 10940052256 11391995904 1963119808 19.331 100 48 96 0 2033711600 54182704 16409088
15:01:39 12101 8192000000 10934287552 11386474496 1966724736 19.359 100 30 60 2 2018628240 41366256 10537248
15:02:07 30698 8192000000 10943430304 11383439360 1973687472 19.415 100 30 60 0 2016575504 32827584 10060448
15:02:55 10349 8192000000 10951911824 11394998272 1989578368 19.540 100 35 68 2 2033388496 33416832 10393296
15:03:24 25158 8192000000 10946248192 11397562368 1983738128 19.494 100 24 48 0 2028258512 36116512 8403872
15:04:19 21492 8192000000 10930377376 11388035072 1963357728 19.333 99 31 62 3 2017054992 43149216 10548048
15:05:03 19018 8192000000 10940106160 11398238208 1975415584 19.428 100 22 44 1 2023764096 41185744 7162768
15:06:39 45280 8192000000 10896943200 11369897984 1948666688 19.216 99 11 22 0 1980068560 28188912 3212960
15:07:33 46309 8192000000 10927441904 11372576768 1986403104 19.515 100 23 44 3 2005465424 13060128 6002192
15:08:26 26124 8192000000 10932108448 11369074688 1973550128 19.414 99 37 74 2 1994337200 10083984 10703088
15:08:59 16528 8192000000 10897408240 11351683072 1944534976 19.183 98 20 40 1 1961190624 10887104 5768544
15:09:25 81175 8192000000 10915958064 11384864768 1939019760 19.139 98 14 28 0 1958631344 15668064 3943520
15:10:55 105872 8192000000 10879812016 11348942848 1862781616 18.526 94 14 29 1 1882753440 16192624 3779200
15:12:55 27691 8192000000 10909786832 11355475968 1964298576 19.340 100 22 44 1 1977758976 7561872 5898528
15:13:37 43643 8192000000 10931258352 11373928448 1972903568 19.408 100 34 66 1 1993449744 11099760 9446416
15:14:28 51142 8192000000 10924875264 11372134400 1961800352 19.320 99 48 96 3 1986775696 9976080 14999264
15:15:26 31344 8192000000 10931654464 11388686336 1985132800 19.505 100 38 74 2 2014888096 18648464 11106832
15:16:05 31004 8192000000 10929464256 11394719744 1989408432 19.539 100 31 60 1 2019181872 21056304 8717136
15:16:44 103369 8192000000 10941535248 11394215936 1964215264 19.340 99 10 20 0 1992024704 25140432 2669008
15:18:38 77684 8192000000 10916855488 11384557568 1976893728 19.440 99 14 28 2 1993648048 12483824 4270496
15:20:56 40967 8192000000 10941774976 11398713344 1995932976 19.591 100 24 47 1 2011114320 7989232 7192112
15:21:45 70439 8192000000 10953974048 11420332032 2014464608 19.737 100 52 104 1 2043638496 14128640 15045248
15:23:11 60376 8192000000 10946857280 11395461120 1952555488 19.247 97 51 101 1 1976603920 9901216 14147216
15:24:41 35987 8192000000 10895106688 11362607104 1953123840 19.251 98 23 46 3 1971392240 11625120 6643280
15:25:24 18069 8192000000 10922832752 11378638848 1979804064 19.463 100 40 77 1 2001847200 11289728 10753408
15:25:50 15796 8192000000 10935395648 11392757760 1987777920 19.526 100 17 34 0 2010812032 18281216 4752896
15:26:15 52024 8192000000 10942613920 11404517376 1978429312 19.452 99 53 106 0 2016256624 21714720 16112592
15:27:16 44189 8192000000 10921042400 11399938048 1970052704 19.386 99 21 42 2 1998646464 22950848 5642912
15:29:07 73018 8192000000 10941064848 11414646784 1997577232 19.604 100 14 29 0 2021053984 19376528 4100224
15:30:26 44026 8192000000 10922999920 11397537792 1987725504 19.526 99 19 38 0 2015243760 21957888 5560368
15:32:33 80086 8192000000 10904466160 11395944448 1949349536 19.221 98 13 26 0 1962154560 9482336 3322688
15:34:14 125743 8192000000 10905595152 11378483200 1890150128 18.747 95 9 18 1 1908261264 15990752 2120384
15:36:26 62707 8192000000 10887483040 11356573696 1917174352 18.964 97 22 45 0 1936534528 12629200 6730976
15:37:35 11046 8192000000 10914998304 11368607744 1978663680 19.454 100 57 112 1 2003387344 8833616 15890048
15:37:53 18832 8192000000 10927083696 11375755264 1964216976 19.340 99 65 130 5 1996101984 13560000 18325008
15:38:18 40696 8192000000 10931066096 11384381440 1958335344 19.293 99 45 90 1 1987461280 16321536 12804400
15:39:05 86340 8192000000 10887899872 11361366016 1900673728 18.832 96 26 53 3 1920556768 12449408 7433632
15:40:40 79289 8192000000 10889192848 11350003712 1847873568 18.405 94 17 34 2 1865554576 12924448 4756560
15:42:07 30344 8192000000 10862911040 11318960128 1876807536 18.639 96 27 54 0 1891631552 7463168 7360848
15:42:44 38338 8192000000 10873434192 11325689856 1885321440 18.708 97 28 56 2 1904217888 10092320 8804128
15:43:32 62382 8192000000 10885112880 11362693120 1931316144 19.077 99 17 34 0 1954936768 18901184 4719440
15:44:40 62540 8192000000 10863512688 11327983616 1852895936 18.446 95 11 22 1 1870283872 14211616 3176320
15:46:21 45240 8192000000 10884414960 11342909440 1918132208 18.972 99 23 46 1 1940726608 16141184 6453216
15:47:13 45273 8192000000 10878281248 11340189696 1906807552 18.881 98 19 38 0 1923360480 11428928 5124000
15:48:04 46225 8192000000 10862267456 11315068928 1859256816 18.497 96 22 44 0 1878982560 13583552 6142192
15:48:57 147037 8192000000 10861229328 11328954368 1912156112 18.924 99 36 70 1 1940896768 17973024 10767632
15:51:32 95622 8192000000 10879060240 11342979072 1927181216 19.044 99 28 55 0 1945840080 11116928 7541936
15:53:14 45536 8192000000 10903893568 11358265344 1937823088 19.129 99 27 54 1 1955415088 9640704 7951296
15:54:29 89491 8192000000 10862109808 11334692864 1855037552 18.463 95 22 44 0 1876160512 14781216 6341744
15:56:05 63999 8192000000 10853219712 11331424256 1901410432 18.838 98 16 32 1 1918598912 12315568 4872912
15:58:02 57216 8192000000 10870377136 11343753216 1939179376 19.140 100 13 26 0 1953352592 10525088 3648128
15:59:20 21540 8192000000 10858385984 11340247040 1924285936 19.021 99 12 24 1 1939039984 10484624 4269424
16:00:33 48683 8192000000 10880685040 11353706496 1954323040 19.261 100 31 60 1 1973299968 9850112 9126816
16:01:56 46059 8192000000 10884690736 11362795520 1940787488 19.153 99 13 26 3 1954767776 9790080 4190208
16:03:02 55610 8192000000 10884669232 11374600192 1931398656 19.078 98 6 12 1 1944544160 11759984 1385520
16:04:29 44011 8192000000 10882343952 11350548480 1920832672 18.994 98 18 37 3 1934125488 8955616 4337200
16:05:20 76118 8192000000 10888875888 11355828224 1925812304 19.033 98 11 22 0 1939572784 10710752 3049728
16:06:42 52016 8192000000 10905915088 11366825984 1940308768 19.149 98 27 53 0 1957199040 9133504 7756768
16:07:41 44780 8192000000 10901405152 11377524736 1952520880 19.247 99 10 20 0 1963566320 8596048 2449392
16:08:45 43669 8192000000 10912523104 11389173760 1963175408 19.331 99 18 36 1 1979212880 11227968 4809504
16:09:38 49758 8192000000 10911949600 11384926208 1947976736 19.210 98 14 28 1 1965017088 13094896 3945456
16:10:36 51405 8192000000 10929122896 11380445184 1921199072 18.996 97 28 56 2 1941941664 12879248 7863344
16:11:33 14281 8192000000 10931908208 11378163712 1979035488 19.457 100 55 110 1 2003959088 8771088 16152512
16:11:55 16562 8192000000 10913501344 11358887936 1948368128 19.213 99 49 97 2 1971104240 9370464 13365648
16:12:24 11637 8192000000 10915535648 11364040704 1967886624 19.369 100 51 101 0 1992332080 10821888 13623568
16:12:44 10246 8192000000 10911095584 11360989184 1952030624 19.243 99 51 103 1 1977477488 11219744 14227120
16:13:10 7311 8192000000 10939268320 11383193600 1975909728 19.432 100 59 118 0 2004986480 12391728 16685024
16:13:26 28475 8192000000 10921695504 11393703936 1981408160 19.476 100 47 94 1 2013020144 18449152 13162832
16:14:04 112315 8192000000 10894381536 11377373184 1880177136 18.667 95 11 22 0 1898797120 15794864 2825120
16:16:02 36618 8192000000 10932550320 11390230528 1981804064 19.479 100 22 44 0 1997589840 9268160 6517616
16:18:26 141525 8192000000 10885387328 11367743488 1885339184 18.708 95 22 44 1 1908995632 17291552 6364896
16:21:19 28928 8192000000 10892881312 11371728896 1966514096 19.358 100 8 16 0 1987017984 18378608 2125280
16:21:54 52283 8192000000 10871212736 11354898432 1893341664 18.773 96 10 20 1 1905524896 9357024 2826208
16:22:53 54370 8192000000 10878945344 11354415104 1941436784 19.158 99 11 22 1 1957527040 13172224 2918032
16:24:21 65124 8192000000 10877500560 11349766144 1933509184 19.095 98 12 24 1 1946278032 9048368 3720480
16:25:33 79689 8192000000 10897602976 11377254400 1954092784 19.259 99 22 44 0 1975926464 15126432 6707248
16:26:59 55900 8192000000 10882488128 11369885696 1910727296 18.912 97 6 12 0 1929557712 17225552 1604864
16:28:03 34878 8192000000 10913009824 11370430464 1930317376 19.069 98 29 59 0 1946022752 7266880 8438496
16:28:46 75009 8192000000 10875095920 11352817664 1927769632 19.049 98 15 30 0 1941581792 9636912 4175248
16:30:26 56379 8192000000 10897044608 11372179456 1938363664 19.134 98 20 39 0 1955408752 11427232 5617856
16:31:28 87070 8192000000 10039855472 10436874240 1142386720 12.238 58 5 10 0 1153106800 9360864 1359216

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 17-03-2021 16:34:14 to 17-03-2021 16:34:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2021 16:34:48 to 17-03-2021 16:34:50.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          234133
MON$OLDEST_ACTIVE               234134
MON$OLDEST_SNAPSHOT             234134
MON$NEXT_TRANSACTION            234134
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2042272
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Wed Mar 17 16:33:06 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Wed Mar 17 16:33:08 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

17.03.21 16:34:51. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-17 16:34:53 No severe PSQL-related problems occured
17.03.21 16:34:55. End of report.