Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.02.2021 19:27
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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17167476 kB
MemAvailable 31075388 kB
Buffers 0 kB
Cached 14515640 kB
SwapCached 3312 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-02-27 19:27:16
DTS_END                         2021-02-27 19:27:16.6820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53642
TRN_ID                          237648
ATT_ID                          662
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: 9018.44 24053 1082213
customer order: creation 164.06 336 19687
customer order: refuse 14.26 315 1711
order to supplier: creation 43.19 1167 5183
order to supplier: removal 3.45 103198 414
invoice (draft): creation 44.03 3302 5283
invoice (draft): removal 53.34 814 6401
invoice accept: apply 40.13 18492 4816
invoice accept: cancel 47.63 795 5715
customer reserve: creation 3675.63 185 441076
customer reserve: removal 4645.85 60 557502
realization accept: apply 79.09 184 9491
realization accept: cancel 83.03 109 9964
payment from customer: creation 57.07 121 6848
payment from customer: removal 5.46 81 655
payment to supplier: creation 47.37 140 5684
payment to supplier: removal 3.48 114 418
service: total inventory turnovers 4.52 1068 542
service: total monetary turnovers 6.05 46 726
service: aggregate perf. data 0.78 21018 93
service: refresh index statistics 0.03 329505 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2021 19:28:02 to 27-02-2021 19:28:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10747
TEST_TIME 2 6499
TEST_TIME 3 5633
TEST_TIME 4 6267
TEST_TIME 5 5838
TEST_TIME 6 5520
TEST_TIME 7 5512
TEST_TIME 8 5197
TEST_TIME 9 5255
TEST_TIME 10 5186
TEST_TIME 11 5230
TEST_TIME 12 5336
TEST_TIME 13 5346
TEST_TIME 14 5802
TEST_TIME 15 5979
TEST_TIME 16 6316
TEST_TIME 17 6453
TEST_TIME 18 6808
TEST_TIME 19 7262
TEST_TIME 20 7988
TEST_TIME 21 8232
TEST_TIME 22 9312
TEST_TIME 23 9344
TEST_TIME 24 9804
TEST_TIME 25 10420
TEST_TIME 26 10442
TEST_TIME 27 10169
TEST_TIME 28 10259
TEST_TIME 29 10234
TEST_TIME 30 10065
TEST_TIME 31 9957
TEST_TIME 32 9802
TEST_TIME 33 9632
TEST_TIME 34 9540
TEST_TIME 35 9431
TEST_TIME 36 9250
TEST_TIME 37 9510
TEST_TIME 38 9509
TEST_TIME 39 9377
TEST_TIME 40 9349
TEST_TIME 41 9201
TEST_TIME 42 9262
TEST_TIME 43 9102
TEST_TIME 44 9070
TEST_TIME 45 9087
TEST_TIME 46 9068
TEST_TIME 47 9182
TEST_TIME 48 9226
TEST_TIME 49 9167
TEST_TIME 50 9214
TEST_TIME 51 9189
TEST_TIME 52 9184
TEST_TIME 53 9343
TEST_TIME 54 9261
TEST_TIME 55 9201
TEST_TIME 56 9310
TEST_TIME 57 9272
TEST_TIME 58 9175
TEST_TIME 59 9074
TEST_TIME 60 9036
TEST_TIME 61 9043
TEST_TIME 62 8927
TEST_TIME 63 9005
TEST_TIME 64 8979
TEST_TIME 65 9002
TEST_TIME 66 8965
TEST_TIME 67 9091
TEST_TIME 68 9155
TEST_TIME 69 9227
TEST_TIME 70 9162
TEST_TIME 71 9186
TEST_TIME 72 9199
TEST_TIME 73 9199
TEST_TIME 74 9242
TEST_TIME 75 9162
TEST_TIME 76 9243
TEST_TIME 77 9272
TEST_TIME 78 9284
TEST_TIME 79 9173
TEST_TIME 80 9133
TEST_TIME 81 9146
TEST_TIME 82 9114
TEST_TIME 83 9073
TEST_TIME 84 9049
TEST_TIME 85 9023
TEST_TIME 86 9043
TEST_TIME 87 8983
TEST_TIME 88 8919
TEST_TIME 89 9006
TEST_TIME 90 9033
TEST_TIME 91 8979
TEST_TIME 92 9020
TEST_TIME 93 9174
TEST_TIME 94 9128
TEST_TIME 95 9171
TEST_TIME 96 9131
TEST_TIME 97 9195
TEST_TIME 98 9204
TEST_TIME 99 9228
TEST_TIME 100 9261
TEST_TIME 101 9258
TEST_TIME 102 9224
TEST_TIME 103 9172
TEST_TIME 104 9130
TEST_TIME 105 9099
TEST_TIME 106 9099
TEST_TIME 107 9058
TEST_TIME 108 9056
TEST_TIME 109 9039
TEST_TIME 110 8992
TEST_TIME 111 8991
TEST_TIME 112 8988
TEST_TIME 113 8985
TEST_TIME 114 9003
TEST_TIME 115 9008
TEST_TIME 116 9025
TEST_TIME 117 9053
TEST_TIME 118 9036
TEST_TIME 119 9089
TEST_TIME 120 9027

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-02-2021 19:28:06 to 27-02-2021 19:28:09.

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 1492178 1492178 0 0.00 0 23685 7 0 0
doc_list_biud 1492177 1492177 0 0.00 0 34026 28 0 0
sp_add_invoice_to_stock 4929 4816 113 2.29 28 176595 18492 0 113
sp_cancel_adding_invoice 5715 5715 0 0.00 5 111681 795 0 0
sp_cancel_client_order 1711 1711 0 0.00 5 8934 316 0 0
sp_cancel_customer_reserve 557502 557502 0 0.00 1 22982 60 0 0
sp_cancel_pay_from_customer 655 655 0 0.00 3 5199 82 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 10078 114 0 0
sp_cancel_supplier_invoice 6410 6401 9 0.14 1 32401 814 0 9
sp_cancel_supplier_order 414 414 0 0.00 12 1045704 103198 0 0
sp_cancel_write_off 9964 9964 0 0.00 1 20793 110 0 0
sp_client_order 19687 19687 0 0.00 4 13330 337 0 0
sp_customer_reserve 441076 441076 0 0.00 0 45625 186 0 0
sp_fill_shopping_cart 30142 30142 0 0.00 1 34663 41 0 0
sp_fill_shopping_cart_clo_res 441067 441067 0 0.00 0 15368 14 0 0
sp_get_clo_for_invoice 4803 4803 0 0.00 0 33289 323 0 0
sp_kill_cost_storno 16752 16752 0 0.00 0 7955 53 0 0
sp_kill_qstorno_ret_qs2qd 1131783 1131783 0 0.00 0 32322 33 0 0
sp_kill_qty_storno 596001 596001 0 0.00 0 34025 70 0 0
sp_lock_selected_doc 19972 19972 0 0.00 0 8200 8 0 0
sp_make_cost_storno 26826 26826 0 0.00 0 15721 57 0 0
sp_multiply_rows_for_pdistr 26826 26826 0 0.00 0 6650 30 0 0
sp_multiply_rows_for_qdistr 19687 19687 0 0.00 0 11604 165 0 0
sp_pay_from_customer 6848 6848 0 0.00 4 20216 122 0 0
sp_pay_to_supplier 5684 5684 0 0.00 5 16039 140 0 0
sp_payment_common 12532 12532 0 0.00 1 20199 37 0 0
sp_qd_handle_on_cancel_clo 1711 1711 0 0.00 0 8916 280 0 0
sp_qd_handle_on_invoice_upd_sts 10518 10518 0 0.00 0 34022 322 0 0
sp_qd_handle_on_reserve_upd_sts 9491 9491 0 0.00 0 18015 60 0 0
sp_reserve_write_off 9491 9491 0 0.00 6 18041 184 0 0
sp_supplier_invoice 5283 5283 0 0.00 6 70469 3302 0 0
sp_supplier_order 5183 5183 0 0.00 4 39948 1168 0 0
srv_aggregate_perf_data 93 93 0 0.00 2990 350353 21018 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1223 116518 33398 0 0
srv_find_qd_qs_mism 1037295 1037295 0 0.00 0 23683 6 0 0
srv_make_invnt_saldo 542 542 0 0.00 27 69413 1068 0 0
srv_make_money_saldo 726 726 0 0.00 0 12156 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 137852 512296 329506 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4816 4816 0 0.00 0 25133 192 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 0 9194 112 0 0
t$perf-norm:sp_cancel_client_order 1711 1711 0 0.00 0 3696 14 0 0
t$perf-norm:sp_cancel_customer_reserve 661 661 0 0.00 0 1013 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 655 655 0 0.00 0 5520 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 1226 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 4183 26 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 20147 1636 0 0
t$perf-norm:sp_cancel_write_off 964 964 0 0.00 0 3430 12 0 0
t$perf-norm:sp_client_order 19687 19687 0 0.00 0 6749 17 0 0
t$perf-norm:sp_customer_reserve 949 949 0 0.00 0 3485 12 0 0
t$perf-norm:sp_pay_from_customer 6848 6848 0 0.00 0 16094 14 0 0
t$perf-norm:sp_pay_to_supplier 5684 5684 0 0.00 0 6471 10 0 0
t$perf-norm:sp_reserve_write_off 9491 9491 0 0.00 0 7489 15 0 0
t$perf-norm:sp_supplier_invoice 5283 5283 0 0.00 0 5987 18 0 0
t$perf-norm:sp_supplier_order 5183 5183 0 0.00 0 4607 15 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 808 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 487 9 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 5592 46 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 680 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 33 10 0 0
v_add_invoice_to_stock 9830 9604 226 2.29 0 4873 20 0 226
v_all_customers 36206 36206 0 0.00 0 34 1 0 0
v_all_suppliers 29186 29186 0 0.00 0 32 1 0 0
v_all_wares 39374 39374 0 0.00 0 222 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 230 6 0 0
v_cancel_client_order 3422 3422 0 0.00 0 1624 3 0 0
v_cancel_customer_prepayment 1310 1310 0 0.00 0 5055 15 0 0
v_cancel_customer_reserve 1322 1322 0 0.00 0 4889 9 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 1092 5 0 0
v_cancel_supplier_invoice 862 844 18 2.08 0 5075 24 0 18
v_cancel_supplier_order 828 828 0 0.00 0 3943 9 0 0
v_cancel_write_off 1928 1928 0 0.00 0 4310 17 0 0
v_max_id_clo_ord 5183 5183 0 0.00 0 1489 2 0 0
v_max_id_clo_res 949 949 0 0.00 0 2331 12 0 0
v_max_id_ord_sup 5272 5272 0 0.00 0 6450 5 0 0
v_max_non_paid_invoice 1546 1546 0 0.00 0 2245 4 0 0
v_max_non_paid_realizn 3572 3572 0 0.00 0 4978 9 0 0
v_min_id_clo_ord 5183 5183 0 0.00 0 2044 8 0 0
v_min_id_clo_res 949 949 0 0.00 0 3206 7 0 0
v_min_id_ord_sup 5272 5272 0 0.00 0 3683 7 0 0
v_min_non_paid_invoice 5684 5684 0 0.00 0 7789 21 0 0
v_min_non_paid_realizn 6848 6848 0 0.00 0 14125 24 0 0
v_our_firm 9718 9718 0 0.00 0 174 1 0 0
v_reserve_write_off 18982 18982 0 0.00 0 5484 7 0 0
x_lock_depdocs_on_canc_invoice 11694 11694 0 0.00 0 15838 115 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 14888 352 0 0
x_make_qstorno_1000_1200 5183 5183 0 0.00 1 39934 1088 0 0
x_make_qstorno_1200_2000 5283 5283 0 0.00 3 66665 3155 0 0
x_make_qstorno_2100_3300 441076 441076 0 0.00 0 45609 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2021 19:28:10 to 27-02-2021 19:28:14.

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
16:57:20 1 8192000000 8798421856 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:26 14644 8192000000 10211779184 10516537344 812005440 9.018 65 54 109 0 833128288 2472800 18650048
16:57:49 27664 8192000000 10309665648 10621054976 1351001792 14.156 100 84 168 0 1383459776 4818848 27639136
16:58:25 20082 8192000000 10332544320 10650394624 1386743808 14.477 100 85 170 0 1421729440 6370032 28615600
16:58:56 19189 8192000000 10366071552 10688733184 1419008896 14.764 100 83 165 0 1453201408 6714896 27477616
16:59:26 20493 8192000000 10408401568 10735296512 1447981984 15.020 100 85 170 0 1483203088 7771712 27449392
17:00:05 19120 8192000000 10436685248 10768183296 1487195728 15.364 100 89 178 0 1525248528 9336368 28716432
17:00:38 24810 8192000000 10478347536 10816827392 1518364944 15.636 100 89 178 0 1557102512 10052000 28685568
17:01:14 10128 8192000000 10500912448 10839093248 1547869776 15.892 100 90 180 0 1586854256 10731424 28253056
17:01:36 16610 8192000000 10517344064 10866454528 1569943136 16.082 100 82 164 1 1606789376 11539088 25307152
17:01:59 18938 8192000000 10549867056 10903232512 1596573968 16.310 100 83 166 2 1634226416 12141808 25510640
17:02:27 11391 8192000000 10573780224 10925731840 1623637568 16.541 100 85 168 2 1661786768 12743648 25405552
17:02:47 17502 8192000000 10582779120 10941374464 1638997920 16.671 100 80 158 3 1674454416 11810624 23645872
17:03:12 10393 8192000000 10590949408 10951122944 1650433792 16.768 100 81 162 1 1687586144 12882416 24269936
17:03:30 11338 8192000000 10607005600 10972479488 1663284128 16.877 100 81 161 0 1700448800 12740672 24424000
17:03:50 8589 8192000000 10625114864 10991869952 1685371472 17.062 100 78 155 2 1720482128 12750272 22360384
17:04:05 5863 8192000000 10636688608 11005562880 1694457840 17.139 100 78 156 1 1730461024 12844160 23159024
17:04:20 7758 8192000000 10643190320 11017838592 1708765888 17.258 100 78 156 0 1744397440 12938912 22692640
17:04:36 5567 8192000000 10667839520 11039719424 1723752288 17.383 100 80 158 2 1759570752 12917792 22900672
17:04:48 4793 8192000000 10678667712 11052703744 1736669552 17.491 100 81 162 1 1773216192 13281632 23265008
17:05:00 5079 8192000000 10683364768 11059265536 1746905408 17.576 100 75 150 1 1781957968 13850272 21202288
17:05:12 4188 8192000000 10706104400 11082637312 1764365728 17.720 100 82 165 2 1800242048 13539424 22336896
17:05:23 4193 8192000000 10719113632 11096289280 1775305680 17.811 100 86 169 0 1812535888 13169168 24061040
17:05:34 2972 8192000000 10726786912 11103424512 1782659776 17.871 100 88 171 2 1821582576 14709536 24213264
17:05:44 2926 8192000000 10728672352 11113840640 1790747168 17.938 100 80 158 2 1826214464 13490752 21976544
17:05:53 3539 8192000000 10737925952 11121090560 1801147536 18.023 100 77 152 0 1835329696 12798576 21383584
17:06:04 3873 8192000000 10754426656 11136823296 1815330208 18.140 100 90 174 1 1853183376 13245808 24607360
17:06:15 5978 8192000000 10750581520 11136671744 1818508608 18.165 100 89 176 0 1856522960 13956032 24058320
17:06:29 4713 8192000000 10762129248 11148046336 1824137712 18.211 100 81 162 3 1859818832 13531392 22149728
17:06:40 1960 8192000000 10773349744 11161026560 1838267504 18.327 100 80 160 0 1878918080 18021952 22628624
17:06:49 1441 8192000000 10786751680 11174518784 1842452912 18.361 100 87 170 6 1880519168 13709088 24357168
17:06:57 2782 8192000000 10791645712 11176882176 1850706432 18.428 100 92 183 2 1889679568 13238880 25734256
17:07:06 2292 8192000000 10796475232 11181797376 1851449264 18.434 100 91 181 2 1890772752 13548384 25775104
17:07:15 1584 8192000000 10798374944 11186589696 1856562608 18.475 100 84 169 1 1892792832 12720592 23509632
17:07:23 1442 8192000000 10797410176 11184975872 1856232848 18.473 100 89 177 0 1894632512 12690240 25709424
17:07:31 1844 8192000000 10802255504 11188813824 1863059376 18.528 100 85 167 1 1899534528 12952640 23522512
17:07:39 1707 8192000000 10811027056 11196354560 1868851360 18.575 100 98 197 1 1909544336 13057296 27635680
17:07:47 5751 8192000000 10814867712 11204866048 1867693472 18.566 100 81 160 4 1903592064 12758288 23140304
17:08:00 1290 8192000000 10813285568 11201851392 1868845184 18.575 100 82 163 1 1904002048 12347360 22809504
17:08:07 2020 8192000000 10812525072 11210301440 1873089232 18.609 100 72 143 0 1910591312 17198240 20303840
17:08:16 1831 8192000000 10814812800 11214163968 1879686464 18.663 100 73 146 1 1912675056 12620096 20368496
17:08:25 3992 8192000000 10793351840 11204829184 1871964016 18.600 100 43 86 1 1893673888 9642848 12067024
17:08:35 3787 8192000000 10783524784 11203067904 1871223984 18.594 100 33 66 0 1889158144 8001824 9932336
17:08:46 7960 8192000000 10786839520 11204759552 1873229056 18.610 100 39 78 0 1892043520 7315056 11499408
17:09:03 5172 8192000000 10791933168 11210162176 1876166144 18.634 100 38 77 1 1895043936 8233296 10644496
17:09:15 9356 8192000000 10802032192 11213848576 1875482912 18.629 100 26 49 2 1889032640 6448176 7101552
17:09:31 46822 8192000000 10811933696 11220336640 1877723360 18.647 100 14 28 0 1887461248 5005424 4732464
17:10:24 18410 8192000000 10803151072 11228520448 1884610096 18.702 100 35 70 1 1902088048 7337888 10140064
17:10:51 6769 8192000000 10796556048 11229511680 1885521744 18.710 100 26 52 6 1899796160 6777120 7497296
17:11:04 6972 8192000000 10799448176 11230085120 1887192384 18.723 100 19 38 2 1898238560 5664912 5381264
17:11:18 7594 8192000000 10808400896 11238707200 1894605344 18.783 100 24 48 3 1908378784 7133328 6640112
17:11:33 7890 8192000000 10824980000 11252174848 1899857184 18.825 100 20 40 2 1915820656 10362464 5601008
17:11:48 6200 8192000000 10820177872 11248422912 1903510144 18.855 100 35 70 3 1921383552 7938672 9934736
17:12:03 4277 8192000000 10824257072 11252310016 1904621280 18.863 100 38 76 0 1923604224 7932384 11050560
17:12:14 5273 8192000000 10826729696 11250802688 1904236768 18.860 100 31 62 2 1920507840 6899728 9371344
17:12:28 8961 8192000000 10811114400 11245187072 1904193040 18.860 100 26 52 3 1918195376 6432704 7569632
17:12:45 8006 8192000000 10815705264 11252359168 1906147936 18.876 100 21 39 3 1918053904 6338032 5567936
17:13:01 8216 8192000000 10818300272 11254804480 1907916224 18.890 100 17 34 0 1918696480 5867008 4913248
17:13:21 14425 8192000000 10815100240 11254087680 1907117104 18.883 100 18 36 1 1917987936 5642736 5228096
17:13:49 9813 8192000000 10827085424 11260686336 1909829216 18.905 100 14 28 0 1918969120 5363376 3776528
17:14:10 5778 8192000000 10831481984 11263545344 1915947120 18.954 100 50 101 1 1935555952 4469296 15139536
17:14:23 62715 8192000000 10825203504 11256786944 1891930512 18.761 99 19 38 1 1903172048 5296176 5945360
17:15:32 10510 8192000000 10816693456 11248979968 1888804896 18.736 99 15 30 2 1897724864 4888480 4031488
17:15:50 4709 8192000000 10828529504 11258646528 1893340800 18.773 99 42 84 1 1913967488 8816208 11810480
17:16:02 2795 8192000000 10829230592 11260833792 1909772096 18.905 100 31 58 2 1933381392 15055600 8553696
17:16:13 9210 8192000000 10831291952 11261026304 1893769776 18.776 99 27 54 1 1907809648 6044304 7995568
17:16:32 5457 8192000000 10765227920 11188527104 1834551952 18.296 96 42 84 2 1853612480 7498864 11561664
17:16:43 5382 8192000000 10787565760 11211722752 1869515728 18.580 99 30 59 1 1885242816 5876816 9850272
17:16:58 5926 8192000000 10804829024 11230822400 1873305856 18.611 99 28 56 4 1887676832 6642096 7728880
17:17:11 4565 8192000000 10807485568 11234213888 1873329360 18.611 99 29 58 1 1888437088 6589136 8518592
17:17:25 5821 8192000000 10763051440 11190702080 1839193136 18.334 99 34 68 3 1855872912 6346640 10333136
17:17:40 6651 8192000000 10760043664 11184078848 1805911696 18.062 97 23 45 2 1817972352 5527104 6533552
17:17:53 12177 8192000000 10760926784 11187945472 1800802192 18.020 97 19 38 0 1811842096 5546784 5493120
17:18:12 8676 8192000000 10743341616 11156246528 1764863456 17.725 96 28 56 0 1779122576 6384720 7874400
17:18:26 10068 8192000000 10735376592 11147468800 1771454928 17.779 97 28 55 2 1784852832 5009200 8388704
17:18:43 50241 8192000000 10711569808 11125067776 1661533200 16.862 91 26 52 2 1673553808 4580416 7440192
17:19:45 34879 8192000000 10688995424 11104169984 1630870480 16.602 90 19 38 0 1641512384 5088656 5553248
17:20:30 3945 8192000000 10711806032 11115098112 1738503424 17.506 96 38 76 1 1754841744 6131232 10207088
17:20:40 3293 8192000000 10709183776 11112583168 1775922400 17.816 99 48 97 0 1796134864 5434016 14778448
17:20:50 8807 8192000000 10708090672 11119083520 1732996048 17.460 96 27 55 0 1746477264 4747424 8733792
17:21:05 9721 8192000000 10722925936 11138760704 1767839280 17.749 98 30 60 2 1781636624 5268224 8529120
17:21:21 6366 8192000000 10731239024 11146227712 1779880448 17.848 98 39 79 0 1797513168 5906560 11726160
17:21:35 10826 8192000000 10732138000 11158814720 1804807696 18.053 99 20 40 0 1816228160 5466128 5954336
17:21:53 4626 8192000000 10763016208 11176148992 1824856960 18.217 99 22 44 1 1836169104 5233472 6078672
17:22:05 7809 8192000000 10759821264 11179057152 1839028176 18.333 100 24 48 3 1851963776 6015680 6919920
17:22:23 8972 8192000000 10768121648 11181027328 1835284112 18.302 100 25 46 3 1847002784 4769520 6949152
17:22:41 8168 8192000000 10758409008 11185410048 1846970272 18.398 100 24 46 4 1859019760 5743344 6306144
17:22:57 8724 8192000000 10748183584 11181056000 1844384592 18.376 100 22 45 1 1856331328 5631232 6315504
17:23:12 8644 8192000000 10750194816 11181346816 1842683664 18.363 100 27 54 0 1856937744 6843008 7411072
17:23:29 56578 8192000000 10784386896 11196092416 1839434928 18.336 99 24 48 1 1851808864 5317296 7056640
17:24:51 1813 8192000000 10804922192 11213389824 1870327728 18.587 100 77 153 0 1903994240 11431792 22234720
17:25:03 5305 8192000000 10797120192 11213242368 1866010480 18.552 100 35 70 2 1881259632 5710816 9538336
17:25:16 5902 8192000000 10807378080 11219001344 1871263808 18.594 100 33 66 1 1887016576 6260624 9492144
17:25:31 5020 8192000000 10789116576 11217117184 1874911648 18.624 100 36 72 2 1893045872 7803744 10330480
17:25:42 9112 8192000000 10783021712 11221110784 1875422016 18.628 100 35 70 1 1891413104 6213744 9777344
17:25:58 5686 8192000000 10791448320 11221684224 1876792608 18.639 100 26 52 0 1890684944 6155776 7736560
17:26:13 7157 8192000000 10792155520 11224100864 1882389104 18.684 100 32 63 2 1901911552 10419648 9102800
17:26:27 8119 8192000000 10798989792 11222802432 1878202896 18.651 100 21 42 1 1890030752 5312464 6515392
17:26:41 5526 8192000000 10783437488 11221250048 1879242256 18.659 100 25 50 1 1892654528 5572928 7839344
17:26:56 8868 8192000000 10790121568 11225452544 1879593680 18.662 100 23 46 1 1891286224 5193216 6499328
17:27:12 6564 8192000000 10809678368 11237879808 1895133424 18.787 100 27 54 0 1909200128 6086896 7979808
17:27:30 9439 8192000000 10834176400 11254947840 1908786320 18.897 100 47 94 0 1927593168 5663008 13143840
17:27:47 8657 8192000000 10844585472 11260506112 1914040048 18.939 100 54 105 3 1936486752 7866304 14580400
17:28:03 72654 8192000000 10838240224 11270799360 1917260880 18.965 100 43 86 0 1937482224 7328928 12892416
17:29:24 17048 8192000000 10860963872 11288383488 1930207024 19.069 100 38 76 1 1950777840 9413840 11156976
17:29:49 54390 8192000000 10868787472 11303489536 1940660064 19.152 100 37 73 1 1964207488 13027888 10519536
17:31:01 9963 8192000000 10874110832 11311104000 1947637520 19.208 100 37 75 1 1970646240 12779168 10229552
17:31:19 8830 8192000000 10874180784 11301023744 1940539552 19.151 100 49 97 2 1969257008 13748912 14968544
17:31:41 12759 8192000000 10880588752 11314425856 1946867472 19.202 100 45 89 0 1974233104 14130448 13235184
17:32:00 17273 8192000000 10888954176 11320918016 1955038192 19.267 100 40 80 0 1981150320 14584112 11528016
17:32:33 33493 8192000000 10904954704 11342835712 1960741760 19.312 100 45 90 1 1990748304 17089776 12916768
17:33:17 20674 8192000000 10899005664 11345526784 1972307168 19.404 100 39 77 3 2005465616 21555104 11603344
17:33:46 11094 8192000000 10918638512 11350446080 1956921200 19.282 99 40 79 0 1994460368 25509056 12030112
17:34:06 21152 8192000000 10925030144 11358330880 1977898384 19.448 100 40 80 2 2014491248 23522960 13069904
17:34:53 13445 8192000000 10920943808 11354750976 1951920400 19.242 98 46 92 0 1989477984 23946256 13611328
17:35:17 3237 8192000000 10942680496 11365752832 1983203248 19.490 100 64 126 1 2029293264 26801280 19288736
17:35:29 15645 8192000000 10937544208 11364720640 1970853744 19.392 99 64 129 0 2018979664 29037344 19088576
17:35:51 11102 8192000000 10945011552 11372400640 1983658416 19.494 100 61 122 3 2034748000 32366720 18722864
17:36:12 15268 8192000000 10939677632 11373588480 1971734464 19.399 99 54 107 3 2021893936 34621824 15537648
17:36:37 7821 8192000000 10935658064 11367170048 1982443616 19.484 100 54 107 3 2029341488 30217824 16680048
17:36:57 15734 8192000000 10943183968 11376467968 1990510656 19.548 100 57 114 2 2040174240 32029104 17634480
17:37:26 9201 8192000000 10953167040 11387133952 1993897168 19.575 100 55 105 5 2042643856 32240608 16506080
17:37:43 8972 8192000000 10962570032 11389329408 1984824320 19.503 99 62 121 2 2036912336 33315728 18772288
17:38:01 10323 8192000000 10968254656 11393191936 1985904192 19.511 99 63 127 0 2039269008 33682624 19682192
17:38:21 5494 8192000000 10968037088 11398959104 2003928928 19.654 100 62 124 0 2056291408 33512800 18849680
17:38:37 9974 8192000000 10949928960 11375239168 1981409328 19.476 99 69 136 1 2037442864 35361232 20672304
17:39:01 7366 8192000000 10973756848 11402186752 2003806448 19.653 100 63 126 0 2060338576 36749392 19782736
17:39:23 5564 8192000000 10978575760 11410649088 2011840192 19.716 100 67 131 1 2069166544 37630384 19695968
17:39:38 2005 8192000000 10973250880 11395354624 2003071456 19.647 100 76 154 2 2062856928 36099456 23686016
17:39:51 6397 8192000000 10967982208 11397664768 1987498688 19.524 99 68 136 0 2045680064 36627088 21554288
17:40:13 6338 8192000000 10996544160 11422044160 2016202624 19.750 100 72 144 1 2083297856 44316368 22778864
17:40:27 7047 8192000000 10984891952 11404156928 1999522544 19.619 99 70 138 0 2062229520 40692608 22014368
17:40:43 3870 8192000000 10998946656 11424546816 2019312960 19.775 100 78 154 2 2086954896 43232608 24409328
17:40:56 1769 8192000000 10975318816 11388403712 1990664160 19.549 100 89 178 1 2063509104 45196800 27648144
17:41:07 4005 8192000000 10980482400 11397451776 1994349920 19.578 100 72 144 0 2063267808 46444976 22472912
17:41:18 3255 8192000000 10989041568 11400388608 2003780816 19.653 100 80 158 1 2071156832 43737504 23638512
17:41:31 4500 8192000000 10990375552 11412586496 2016987136 19.756 100 79 158 0 2087990352 47534080 23469136
17:41:42 2212 8192000000 10982003648 11394228224 1994427056 19.579 100 88 175 0 2064887040 43411696 27048288
17:41:54 7562 8192000000 10975278640 11392598016 1975376464 19.428 99 72 144 1 2043723344 46133376 22213504
17:42:11 3336 8192000000 10990558960 11409960960 2002152272 19.640 100 80 156 0 2073242816 46614512 24476032
17:42:26 1222 8192000000 10964846464 11368595456 1957730480 19.288 98 89 176 1 2033782672 48678272 27373920
17:42:33 2457 8192000000 10965319408 11378704384 1971863632 19.400 100 84 168 1 2049924944 51430384 26630928
17:42:43 3546 8192000000 10977448528 11397836800 1987727296 19.526 100 76 149 0 2061571184 50915728 22928160
17:42:53 1574 8192000000 10967489472 11382984704 1975389504 19.428 100 83 164 1 2053168272 51762784 26015984
17:43:04 3007 8192000000 10982383648 11390631936 1982298480 19.483 100 82 165 0 2062551264 54378320 25874464
17:43:14 2356 8192000000 10987734512 11400445952 1990225120 19.546 100 86 170 1 2070852880 53435824 27191936
17:43:24 3708 8192000000 10984533344 11394580480 1985701712 19.510 100 85 168 1 2066570784 54571024 26298048
17:43:37 5881 8192000000 10979903408 11395977216 1971367904 19.396 99 71 141 1 2049701984 55299744 23034336
17:43:50 2769 8192000000 10991265232 11403640832 1989716272 19.542 100 83 166 1 2070462480 54272848 26473360
17:44:00 3406 8192000000 10964585152 11371458560 1960517888 19.310 99 79 157 0 2042052176 56427824 25106464
17:44:10 1336 8192000000 10997698464 11402321920 1988708896 19.534 100 94 188 2 2076161440 57746640 29705904
17:44:18 3664 8192000000 10958139584 11374346240 1957031984 19.282 100 82 163 2 2042964800 59706176 26226640
17:44:30 4468 8192000000 10963896112 11378135040 1963102416 19.331 100 79 156 2 2048433952 59508000 25823536
17:44:44 2760 8192000000 10965376880 11380379648 1964238128 19.340 100 79 159 0 2051778640 61153168 26387344
17:44:54 2953 8192000000 10966321824 11377152000 1947648448 19.208 99 81 161 0 2040852528 66050960 27153120
17:45:05 8077 8192000000 10964453792 11373985792 1940166304 19.148 99 73 146 1 2028403744 63834544 24402896
17:45:21 4484 8192000000 10966607040 11382214656 1947871440 19.210 99 80 161 1 2039245680 65264720 26109520
17:45:32 2533 8192000000 10973673104 11386032128 1964015232 19.338 100 93 186 3 2062306272 67306432 30984608
17:45:43 1675 8192000000 10975159376 11387031552 1966236336 19.356 100 90 176 1 2059241184 64394944 28609904
17:45:56 4522 8192000000 10974917280 11397107712 1967462272 19.365 100 66 132 1 2060010192 70462896 22085024
17:46:09 20348 8192000000 10947116928 11392114688 1960650240 19.311 100 53 106 0 2047436656 68157344 18629072
17:46:48 20469 8192000000 10930952912 11378212864 1930410224 19.070 99 44 89 0 2013334288 67297056 15627008
17:47:30 13312 8192000000 10920606928 11348332544 1916967664 18.963 99 49 96 3 1990343552 57620304 15755584
17:47:58 31347 8192000000 10914588960 11365056512 1938915008 19.138 100 30 60 2 2004808912 55119888 10774016
17:48:44 23819 8192000000 10934639488 11377762304 1944622752 19.184 100 32 63 1 2023586032 66934704 12028576
17:49:16 36480 8192000000 10908718368 11372822528 1953394848 19.254 100 26 52 2 2021033680 58373712 9265120
17:50:05 28206 8192000000 10901402400 11361247232 1947257712 19.205 100 19 39 1 1987352576 34585200 5509664
17:50:51 29147 8192000000 10877917104 11341074432 1898227552 18.812 98 18 35 1 1943861984 39058128 6576304
17:51:27 19145 8192000000 10870676032 11330695168 1889525952 18.742 98 15 29 1 1934572848 40125056 4921840
17:52:02 16692 8192000000 10871897872 11326812160 1907065408 18.883 99 24 46 3 1940925744 27062560 6797776
17:52:26 21201 8192000000 10855247136 11311501312 1893503760 18.774 98 18 36 5 1910949888 12356048 5090080
17:53:10 32892 8192000000 10858956544 11321442304 1924760928 19.025 100 13 26 0 1944496960 15798768 3937264
17:54:07 88547 8192000000 10870826496 11324731392 1926589616 19.040 99 33 65 2 1952674064 16589360 9495088
17:55:44 48521 8192000000 10843477888 11310796800 1904588624 18.863 99 19 38 0 1922996752 13416736 4991392
17:56:41 63088 8192000000 10881632048 11340259328 1939718992 19.145 100 19 36 2 1960566576 15519792 5327792
17:57:51 50090 8192000000 10851782160 11303198720 1887173744 18.723 97 21 42 1 1899363664 6875824 5314096
17:58:52 47303 8192000000 10832380704 11288956928 1873682832 18.614 97 15 30 1 1884343488 6771120 3889536
17:59:48 43989 8192000000 10849690112 11303346176 1914217568 18.940 99 15 30 0 1928325632 10202464 3905600
18:00:39 41707 8192000000 10864976320 11319701504 1914597440 18.944 99 11 22 0 1933971824 16328416 3045968
18:01:28 27473 8192000000 10870730080 11329392640 1938591280 19.136 100 11 22 1 1961567296 19745776 3230240
18:02:14 7086 8192000000 10869696256 11326017536 1936298048 19.117 100 12 24 1 1960575440 20843248 3434144
18:02:30 8408 8192000000 10863174304 11322155008 1930553328 19.071 100 11 22 0 1955739440 21979200 3206912
18:02:44 8487 8192000000 10877633808 11321765888 1930505168 19.071 100 8 16 0 1955879520 23010144 2364208
18:03:02 30303 8192000000 10888240096 11333267456 1937250992 19.125 100 11 22 0 1961837920 21483232 3103696
18:03:39 41694 8192000000 10892136272 11352870912 1947030272 19.203 100 19 38 1 1977674464 24167728 6476464
18:04:45 82711 8192000000 10884165248 11348254720 1956270288 19.276 100 21 41 2 1972340032 9761936 6307808
18:06:14 42349 8192000000 10913542224 11351060480 1968133520 19.371 100 34 66 2 1984988960 7827648 9027792
18:07:05 62592 8192000000 10899000880 11368853504 1983177600 19.490 100 57 113 2 2012295872 13353920 15764352
18:08:37 63430 8192000000 10872724704 11340558336 1911895696 18.922 97 9 18 0 1925101424 10534912 2670816
18:10:12 32640 8192000000 10897147808 11354300416 1967753056 19.368 100 27 53 0 1980701712 6152992 6795664
18:10:55 28497 8192000000 10890024784 11366367232 1975365936 19.428 100 15 30 2 1988229440 8595168 4268336
18:11:56 48841 8192000000 10907081312 11385393152 1983773664 19.495 100 15 30 0 1998857776 10817488 4266624
18:12:59 32687 8192000000 10920771776 11382071296 1971424336 19.397 99 35 68 0 1994408080 13499808 9483936
18:13:47 42842 8192000000 10916306976 11380363264 1973941120 19.417 99 37 74 1 2000941888 16470720 10530048
18:15:08 74974 8192000000 10913869568 11384451072 1957044144 19.283 99 20 39 1 1974917184 12701696 5171344
18:17:02 48333 8192000000 10913667744 11379023872 1964971472 19.346 99 36 72 0 1986507712 11797440 9738800
18:17:58 35716 8192000000 10925385040 11377258496 1986834624 19.519 100 25 51 2 2004610832 10867968 6908240
18:18:40 54274 8192000000 10926011200 11382759424 1954428864 19.262 98 30 60 1 1973084080 10415760 8239456
18:20:17 68801 8192000000 10900037392 11367018496 1943957008 19.178 98 17 34 0 1960093136 11233680 4902448
18:21:37 24610 8192000000 10932694592 11375673344 1979500864 19.461 100 27 54 1 1995022624 8119120 7402640
18:22:10 16396 8192000000 10932463488 11380502528 1973112848 19.410 99 54 105 1 2000558016 12971904 14473264
18:22:38 12401 8192000000 10952918592 11387215872 1995574080 19.588 100 61 122 1 2025217568 12406544 17236944
18:22:59 22551 8192000000 10937516352 11392397312 1978426416 19.452 99 48 96 1 2005066368 13414560 13225392
18:23:35 77559 8192000000 10890839136 11360768000 1946876288 19.202 98 23 46 1 1968396400 14899392 6620720
18:25:08 71472 8192000000 10893466352 11336466432 1862649824 18.525 94 21 40 1 1881047040 12124720 6272496
18:26:28 36245 8192000000 10874826368 11322097664 1924379424 19.022 98 31 62 0 1944923632 11262208 9282000
18:27:20 65038 8192000000 10852878400 11320815616 1862674464 18.525 95 21 41 1 1879654720 10909808 6070448
18:28:36 43778 8192000000 10859159280 11344138240 1917343952 18.966 99 5 10 0 1931423488 13248048 831488
18:29:26 29661 8192000000 10876578304 11359133696 1951595728 19.239 100 11 21 0 1971675920 17489696 2590496
18:30:02 57270 8192000000 10878816624 11368951808 1960776032 19.312 100 15 30 0 1981262720 16067152 4419536
18:31:16 65870 8192000000 10899906864 11373039616 1933665968 19.096 98 13 26 0 1946058064 9041312 3350784
18:32:29 89038 8192000000 10896500032 11361415168 1859170928 18.497 94 21 42 0 1880730672 15634480 5925264
18:34:07 68292 8192000000 10864783456 11341889536 1883997360 18.697 97 11 22 0 1906777392 20010432 2769600
18:35:25 88181 8192000000 10873515904 11350941696 1860600096 18.508 95 4 8 1 1877095616 15488576 1006944
18:37:20 21677 8192000000 10902111696 11352317952 1939621904 19.144 99 43 84 0 1958383008 6841024 11920080
18:38:00 40297 8192000000 10892922240 11347177472 1939736800 19.145 99 47 94 0 1965601344 12127392 13737152
18:38:56 50360 8192000000 10878989568 11334946816 1925057472 19.027 99 29 58 0 1942489808 9681824 7750512
18:39:53 31000 8192000000 10895787248 11350065152 1948458944 19.214 100 27 54 0 1965338560 9368576 7511040
18:40:32 81355 8192000000 10876922304 11354251264 1930132384 19.068 99 34 68 0 1952803344 13312544 9358416
18:42:03 40513 8192000000 10914289408 11357667328 1947684480 19.208 99 29 58 0 1965820528 9604352 8531696
18:42:49 22768 8192000000 10907207728 11359313920 1946314512 19.197 99 38 76 4 1970685488 13374960 10996016
18:43:19 84687 8192000000 10901850128 11382394880 1952512752 19.246 99 28 56 1 1982755360 22273392 7969216
18:44:59 116518 8192000000 10885504544 11341549568 1860794752 18.510 95 15 30 1 1879321408 13792128 4734528
18:47:07 78346 8192000000 10855558880 11334889472 1902667760 18.848 98 16 32 0 1921307712 14307792 4332160
18:48:34 19883 8192000000 10868853920 11337371648 1939847472 19.146 100 23 46 0 1958209312 11994096 6367744
18:49:11 20366 8192000000 10843561776 11309211648 1875273328 18.627 97 22 44 1 1891666944 10492288 5901328
18:49:50 59562 8192000000 10864672512 11329150976 1919746448 18.985 99 19 38 0 1934844032 9667904 5429680
18:51:08 34838 8192000000 10863150128 11340156928 1944413072 19.182 100 13 26 0 1960911760 12490080 4008608
18:51:49 58603 8192000000 10855636032 11338981376 1925291680 19.029 99 15 30 1 1940836032 10829056 4715296
18:52:54 49730 8192000000 10864154096 11347718144 1929275984 19.061 99 12 21 2 1946694576 14075824 3342768
18:54:14 45819 8192000000 10873458480 11357630464 1929427280 19.062 99 11 22 0 1946332208 13532336 3372592
18:55:12 62188 8192000000 10874554768 11356246016 1914909456 18.946 98 11 22 0 1939064000 20730048 3424496
18:56:21 51182 8192000000 10837255696 11317575680 1826273680 18.229 94 15 30 0 1845719696 14944032 4501984
18:57:18 84280 8192000000 10846088864 11313455104 1819259792 18.172 95 12 23 1 1836700992 14015792 3425408
18:58:49 37030 8192000000 10869799776 11324637184 1914032816 18.939 99 29 59 0 1936159824 13291696 8835312
18:59:35 53935 8192000000 10870227968 11355586560 1940000928 19.147 100 14 28 1 1963886640 19725120 4160592
19:00:36 65071 8192000000 10872900992 11337084928 1912457696 18.926 98 19 38 3 1940552640 23241568 4853376
19:02:01 62355 8192000000 10899840000 11347812352 1914585776 18.943 98 12 24 3 1927332800 9541760 3205264
19:03:09 30457 8192000000 10911848320 11358347264 1960450304 19.310 100 36 72 1 1981635568 10777616 10407648
19:03:49 77992 8192000000 10890948848 11370065920 1918385568 18.974 98 26 52 1 1938404272 12221456 7797248
19:05:19 82995 8192000000 10902941520 11373662208 1948653328 19.216 99 16 32 0 1964856160 12071168 4131664
19:06:53 60234 8192000000 10911454016 11390050304 1972662016 19.407 100 11 22 0 1987139072 11577248 2899808
19:08:05 102637 8192000000 10887546992 11348987904 1918983040 18.979 97 21 42 0 1937134592 12345312 5806240
19:09:54 108912 8192000000 10876015088 11352035328 1956223904 19.276 99 26 51 2 1970277152 7324624 6728624
19:11:59 42156 8192000000 10881934528 11358855168 1937711120 19.128 98 19 38 0 1951879008 8312352 5855536
19:12:50 43431 8192000000 10894357760 11373752320 1975517696 19.429 100 23 47 2 1991883456 9887632 6478128
19:13:41 45708 8192000000 10888929296 11379511296 1972972672 19.409 100 10 20 1 1985728992 9894128 2862192
19:14:38 40449 8192000000 10895339792 11373965312 1954325632 19.261 99 9 18 1 1966714928 9421184 2968112
19:15:32 36480 8192000000 10863824080 11340464128 1936544368 19.119 98 8 16 1 1948511392 9978768 1988256
19:16:14 74274 8192000000 10867206880 11342688256 1898800560 18.817 96 13 26 1 1911144848 7708736 4635552
19:17:52 58359 8192000000 10873291008 11354292224 1922467440 19.007 98 14 28 0 1935563536 9095552 4000544
19:18:56 42854 8192000000 10881710928 11358162944 1923982496 19.019 98 5 10 0 1932333008 6896912 1453600
19:19:50 30096 8192000000 10905692832 11375120384 1972367296 19.404 100 32 64 1 1992833392 10895808 9570288
19:20:26 62976 8192000000 10899223872 11380830208 1960365264 19.309 99 25 50 2 1980043408 13021968 6656176
19:21:52 74538 8192000000 10904843488 11382255616 1942792752 19.169 98 11 22 0 1957522768 11934368 2795648
19:23:54 46011 8192000000 10869495040 11349663744 1875539024 18.629 95 12 24 0 1890674368 12043008 3092336
19:24:58 62697 8192000000 10889385664 11350679552 1871452096 18.596 95 34 68 2 1894266848 13411936 9402816
19:26:12 50801 8192000000 10858954304 11334430720 1901175952 18.836 98 16 32 0 1921447648 15965008 4306688
19:27:08 14935 8192000000 8893860224 9038716928 68011072 0.823 4 2 2 1 68904688 368304 525312

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-02-2021 19:28:16 to 27-02-2021 19:28:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 27-02-2021 19:28:49 to 27-02-2021 19:28: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          237954
MON$OLDEST_ACTIVE               237955
MON$OLDEST_SNAPSHOT             237955
MON$NEXT_TRANSACTION            237955
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                       2006976
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:383: 
:384: mscs-test-161.budzdorov.ru    Sat Feb 27 19:27:27 2021
:385:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:386: 
--- end of diff output ---

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

27.02.21 19:28: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-02-27 19:28:54 No severe PSQL-related problems occured
27.02.21 19:28:55. End of report.