Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.04.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 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 17043348 kB
MemAvailable 31395948 kB
Buffers 0 kB
Cached 14580612 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-04-05 19:27:24
DTS_END                         2021-04-05 19:27:24.1080
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/50232
TRN_ID                          252480
ATT_ID                          718
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: 9764.30 19531 1171716
customer order: creation 187.83 329 22540
customer order: refuse 16.74 332 2009
order to supplier: creation 51.10 1291 6132
order to supplier: removal 3.76 91340 451
invoice (draft): creation 50.22 3257 6026
invoice (draft): removal 55.43 756 6652
invoice accept: apply 44.58 17281 5350
invoice accept: cancel 49.91 765 5989
customer reserve: creation 4126.88 170 495225
customer reserve: removal 4860.02 55 583202
realization accept: apply 91.06 187 10927
realization accept: cancel 85.16 116 10219
payment from customer: creation 64.52 126 7742
payment from customer: removal 6.83 85 820
payment to supplier: creation 53.51 129 6421
payment to supplier: removal 3.53 99 424
service: total inventory turnovers 4.72 1184 566
service: total monetary turnovers 7.58 30 909
service: aggregate perf. data 0.90 18897 108
service: refresh index statistics 0.03 254190 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3641
TEST_TIME 2 3266
TEST_TIME 3 3578
TEST_TIME 4 3671
TEST_TIME 5 4239
TEST_TIME 6 4550
TEST_TIME 7 4903
TEST_TIME 8 5590
TEST_TIME 9 6012
TEST_TIME 10 6772
TEST_TIME 11 6977
TEST_TIME 12 7103
TEST_TIME 13 7626
TEST_TIME 14 7702
TEST_TIME 15 7482
TEST_TIME 16 7944
TEST_TIME 17 8114
TEST_TIME 18 8196
TEST_TIME 19 8326
TEST_TIME 20 8602
TEST_TIME 21 8933
TEST_TIME 22 9648
TEST_TIME 23 9723
TEST_TIME 24 9838
TEST_TIME 25 9766
TEST_TIME 26 9822
TEST_TIME 27 10161
TEST_TIME 28 10290
TEST_TIME 29 11404
TEST_TIME 30 11462
TEST_TIME 31 11284
TEST_TIME 32 11356
TEST_TIME 33 11329
TEST_TIME 34 11248
TEST_TIME 35 11138
TEST_TIME 36 10983
TEST_TIME 37 11138
TEST_TIME 38 11000
TEST_TIME 39 10803
TEST_TIME 40 10582
TEST_TIME 41 10587
TEST_TIME 42 10653
TEST_TIME 43 10650
TEST_TIME 44 10619
TEST_TIME 45 10542
TEST_TIME 46 10502
TEST_TIME 47 10405
TEST_TIME 48 10533
TEST_TIME 49 10491
TEST_TIME 50 10392
TEST_TIME 51 10359
TEST_TIME 52 10316
TEST_TIME 53 10241
TEST_TIME 54 10095
TEST_TIME 55 10184
TEST_TIME 56 10065
TEST_TIME 57 10051
TEST_TIME 58 10045
TEST_TIME 59 10008
TEST_TIME 60 9963
TEST_TIME 61 9979
TEST_TIME 62 10015
TEST_TIME 63 10197
TEST_TIME 64 10209
TEST_TIME 65 10286
TEST_TIME 66 10318
TEST_TIME 67 10243
TEST_TIME 68 10282
TEST_TIME 69 10340
TEST_TIME 70 10396
TEST_TIME 71 10346
TEST_TIME 72 10427
TEST_TIME 73 10394
TEST_TIME 74 10302
TEST_TIME 75 10263
TEST_TIME 76 10224
TEST_TIME 77 10140
TEST_TIME 78 10164
TEST_TIME 79 10116
TEST_TIME 80 10057
TEST_TIME 81 10068
TEST_TIME 82 10022
TEST_TIME 83 9945
TEST_TIME 84 9844
TEST_TIME 85 9883
TEST_TIME 86 9874
TEST_TIME 87 9887
TEST_TIME 88 9923
TEST_TIME 89 9892
TEST_TIME 90 9927
TEST_TIME 91 9944
TEST_TIME 92 9960
TEST_TIME 93 9960
TEST_TIME 94 9934
TEST_TIME 95 9923
TEST_TIME 96 9975
TEST_TIME 97 9938
TEST_TIME 98 9999
TEST_TIME 99 10028
TEST_TIME 100 10060
TEST_TIME 101 9990
TEST_TIME 102 9929
TEST_TIME 103 9931
TEST_TIME 104 9881
TEST_TIME 105 9882
TEST_TIME 106 9835
TEST_TIME 107 9792
TEST_TIME 108 9741
TEST_TIME 109 9725
TEST_TIME 110 9730
TEST_TIME 111 9699
TEST_TIME 112 9695
TEST_TIME 113 9753
TEST_TIME 114 9751
TEST_TIME 115 9784
TEST_TIME 116 9745
TEST_TIME 117 9780
TEST_TIME 118 9809
TEST_TIME 119 9771
TEST_TIME 120 9767

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-04-2021 19:28:14 to 05-04-2021 19:28:18.

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 1630763 1630763 0 0.00 0 14351 6 0 0
doc_list_biud 1630762 1630762 0 0.00 0 18485 25 0 0
sp_add_invoice_to_stock 5464 5350 114 2.08 42 199112 17281 0 114
sp_cancel_adding_invoice 5989 5989 0 0.00 6 61341 766 0 0
sp_cancel_client_order 2009 2009 0 0.00 5 9464 333 0 0
sp_cancel_customer_reserve 583202 583202 0 0.00 1 18486 55 0 0
sp_cancel_pay_from_customer 820 820 0 0.00 3 6910 86 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 4942 99 0 0
sp_cancel_supplier_invoice 6659 6652 7 0.10 2 14152 756 0 7
sp_cancel_supplier_order 451 451 0 0.00 6 1051369 91341 0 0
sp_cancel_write_off 10219 10219 0 0.00 1 13025 116 0 0
sp_client_order 22540 22540 0 0.00 4 29430 330 0 0
sp_customer_reserve 495225 495225 0 0.00 0 41455 170 0 0
sp_fill_shopping_cart 34680 34680 0 0.00 1 13607 34 0 0
sp_fill_shopping_cart_clo_res 495220 495220 0 0.00 0 23830 12 0 0
sp_get_clo_for_invoice 5345 5345 0 0.00 0 21765 260 0 0
sp_kill_cost_storno 17452 17452 0 0.00 0 14326 59 0 0
sp_kill_qstorno_ret_qs2qd 1183726 1183726 0 0.00 0 18450 30 0 0
sp_kill_qty_storno 624794 624794 0 0.00 0 18485 66 0 0
sp_lock_selected_doc 22745 22745 0 0.00 0 6996 5 0 0
sp_make_cost_storno 30435 30435 0 0.00 0 10704 50 0 0
sp_multiply_rows_for_pdistr 30435 30435 0 0.00 0 6636 32 0 0
sp_multiply_rows_for_qdistr 22540 22540 0 0.00 0 19883 144 0 0
sp_pay_from_customer 7742 7742 0 0.00 4 10700 127 0 0
sp_pay_to_supplier 6421 6421 0 0.00 4 12826 130 0 0
sp_payment_common 14163 14163 0 0.00 1 9597 31 0 0
sp_qd_handle_on_cancel_clo 2009 2009 0 0.00 0 9453 302 0 0
sp_qd_handle_on_invoice_upd_sts 11334 11334 0 0.00 0 16321 335 0 0
sp_qd_handle_on_reserve_upd_sts 10927 10927 0 0.00 0 11731 58 0 0
sp_reserve_write_off 10927 10927 0 0.00 6 18176 187 0 0
sp_supplier_invoice 6026 6026 0 0.00 7 109991 3258 0 0
sp_supplier_order 6132 6132 0 0.00 6 36950 1292 0 0
srv_aggregate_perf_data 108 108 0 0.00 2802 180165 18898 0 0
srv_fill_mon_cache_memory 178 178 0 0.00 873 138406 29602 0 0
srv_find_qd_qs_mism 1120081 1120081 0 0.00 0 11956 5 0 0
srv_make_invnt_saldo 566 566 0 0.00 31 65479 1185 0 0
srv_make_money_saldo 909 909 0 0.00 0 5920 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 165991 342532 254191 0 0
t$perf-abend:sp_add_invoice_to_stock 114 114 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5350 5350 0 0.00 0 28121 189 0 0
t$perf-norm:sp_cancel_adding_invoice 457 457 0 0.00 0 10763 90 0 0
t$perf-norm:sp_cancel_client_order 2009 2009 0 0.00 0 17515 25 0 0
t$perf-norm:sp_cancel_customer_reserve 750 750 0 0.00 0 1024 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 820 820 0 0.00 0 3528 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 5822 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 451 451 0 0.00 0 2759 23 0 0
t$perf-norm:sp_cancel_supplier_order 451 451 0 0.00 0 21934 1516 0 0
t$perf-norm:sp_cancel_write_off 1111 1111 0 0.00 0 2255 5 0 0
t$perf-norm:sp_client_order 22540 22540 0 0.00 0 15761 19 0 0
t$perf-norm:sp_customer_reserve 1028 1028 0 0.00 0 4745 9 0 0
t$perf-norm:sp_pay_from_customer 7742 7742 0 0.00 0 14699 12 0 0
t$perf-norm:sp_pay_to_supplier 6421 6421 0 0.00 0 13975 12 0 0
t$perf-norm:sp_reserve_write_off 10927 10927 0 0.00 0 5967 10 0 0
t$perf-norm:sp_supplier_invoice 6026 6026 0 0.00 0 9393 24 0 0
t$perf-norm:sp_supplier_order 6132 6132 0 0.00 0 5966 22 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 813 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 178 178 0 0.00 0 679 9 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 7262 52 0 0
t$perf-norm:srv_make_money_saldo 909 909 0 0.00 0 1266 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 262 67 0 0
v_add_invoice_to_stock 10918 10690 228 2.08 0 10601 24 0 228
v_all_customers 41020 41020 0 0.00 0 134 1 0 0
v_all_suppliers 33772 33772 0 0.00 0 21 1 0 0
v_all_wares 45080 45080 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 914 914 0 0.00 0 10668 21 0 0
v_cancel_client_order 4018 4018 0 0.00 0 3239 5 0 0
v_cancel_customer_prepayment 1640 1640 0 0.00 0 3343 6 0 0
v_cancel_customer_reserve 1500 1500 0 0.00 0 4268 10 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 3542 13 0 0
v_cancel_supplier_invoice 916 902 14 1.52 0 7494 29 0 14
v_cancel_supplier_order 902 902 0 0.00 0 3217 9 0 0
v_cancel_write_off 2222 2222 0 0.00 0 7319 20 0 0
v_max_id_clo_ord 6129 6129 0 0.00 0 1928 2 0 0
v_max_id_clo_res 1028 1028 0 0.00 0 7056 18 0 0
v_max_id_ord_sup 6011 6011 0 0.00 0 4403 3 0 0
v_max_non_paid_invoice 1675 1675 0 0.00 0 1016 3 0 0
v_max_non_paid_realizn 4165 4165 0 0.00 0 3434 6 0 0
v_min_id_clo_ord 6129 6129 0 0.00 0 1919 5 0 0
v_min_id_clo_res 1028 1028 0 0.00 0 1915 8 0 0
v_min_id_ord_sup 6011 6011 0 0.00 0 4082 3 0 0
v_min_non_paid_invoice 6421 6421 0 0.00 0 6909 17 0 0
v_min_non_paid_realizn 7742 7742 0 0.00 0 6631 21 0 0
v_our_firm 11214 11214 0 0.00 0 16 1 0 0
v_reserve_write_off 21854 21854 0 0.00 0 7628 9 0 0
x_lock_depdocs_on_canc_invoice 12190 12190 0 0.00 0 17738 112 0 0
x_lock_depdocs_on_canc_sup_ord 451 451 0 0.00 0 13816 344 0 0
x_make_qstorno_1000_1200 6132 6132 0 0.00 2 36939 1208 0 0
x_make_qstorno_1200_2000 6026 6026 0 0.00 3 100146 3140 0 0
x_make_qstorno_2100_3300 495225 495225 0 0.00 0 41453 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2021 19:28:19 to 05-04-2021 19:28:23.

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:27 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:34 13466 8192000000 10209849008 10512699392 889103504 9.790 71 53 106 0 909680400 2441072 18135824
16:57:55 34945 8192000000 10336684400 10651099136 1359800880 14.236 100 83 166 0 1392944928 4804256 28339792
16:58:38 25868 8192000000 10378311376 10701582336 1417542768 14.751 100 87 174 0 1452880656 6313392 29024496
16:59:11 17792 8192000000 10399656192 10722639872 1452818320 15.063 100 88 176 0 1488655568 6888992 28948256
16:59:37 28356 8192000000 10424341088 10757062656 1477128544 15.276 100 87 172 1 1512941456 7528096 28284816
17:00:18 26762 8192000000 10450597648 10787864576 1506612896 15.534 100 87 174 0 1542994000 8433104 27948000
17:01:06 21092 8192000000 10492575824 10832330752 1544605072 15.863 100 85 170 1 1580231760 9298464 26328224
17:01:39 12875 8192000000 10519105104 10870063104 1571461024 16.095 100 79 159 0 1605009936 9937024 23611888
17:02:00 9289 8192000000 10535017616 10889822208 1595830864 16.304 100 75 150 0 1629356544 10621120 22904560
17:02:19 17134 8192000000 10566080496 10919944192 1616851328 16.483 100 79 158 2 1651225040 10841072 23532640
17:02:44 10502 8192000000 10579381840 10937982976 1631916240 16.611 100 80 160 2 1667610688 11696992 23997456
17:03:04 14118 8192000000 10599165088 10960011264 1652564096 16.786 100 80 160 0 1688450304 12208096 23678112
17:03:26 9898 8192000000 10612706656 10981285888 1672462992 16.954 100 71 142 0 1709334912 15903856 20968064
17:03:44 8873 8192000000 10625998544 10993717248 1687142224 17.077 100 78 156 1 1722393232 12279552 22971456
17:04:02 9625 8192000000 10632656544 11001298944 1696593712 17.157 100 71 142 1 1729277024 12063120 20620192
17:04:18 7428 8192000000 10652938112 11023605760 1707260576 17.246 100 77 154 0 1742037904 11970624 22806704
17:04:36 7893 8192000000 10653899872 11028017152 1719297744 17.346 100 78 156 3 1754058240 12704992 22055504
17:04:51 7883 8192000000 10670522000 11044188160 1729773600 17.434 100 80 160 2 1765747600 13337280 22636720
17:05:06 4498 8192000000 10675309648 11049857024 1739171152 17.512 100 81 162 2 1776422208 13756480 23494576
17:05:20 6062 8192000000 10685314624 11065499648 1754692656 17.640 100 72 145 2 1787583632 12681536 20209440
17:05:33 5551 8192000000 10693866464 11075686400 1760719504 17.690 100 65 131 1 1790200800 11761392 17719904
17:05:46 3052 8192000000 10705330352 11082227712 1768101792 17.751 100 77 154 0 1801007536 11535440 21370304
17:05:57 5853 8192000000 10718378816 11098632192 1777076624 17.825 100 83 166 0 1813711232 12756048 23878560
17:06:10 5685 8192000000 10708561712 11098132480 1779190736 17.843 100 67 134 1 1810396112 12908320 18297056
17:06:23 2676 8192000000 10736020544 11116900352 1785178176 17.892 100 78 156 1 1820850832 12808192 22864464
17:06:33 3489 8192000000 10737027424 11124527104 1803759744 18.045 100 70 139 2 1834437728 11239952 19438032
17:06:44 3527 8192000000 10760360688 11139493888 1814361232 18.132 100 83 166 2 1849978928 11938176 23679520
17:06:54 1544 8192000000 10752851792 11136729088 1817487824 18.157 100 85 170 1 1854284592 12621808 24174960
17:07:03 3525 8192000000 10765427296 11142275072 1822098960 18.195 100 95 192 3 1863814992 14781760 26934272
17:07:13 2944 8192000000 10771331664 11150643200 1823680416 18.208 100 93 186 1 1865705856 16507264 25518176
17:07:22 2708 8192000000 10776645408 11159371776 1828406432 18.246 100 85 170 2 1867732448 15989520 23336496
17:07:31 2810 8192000000 10776525824 11163590656 1838810096 18.331 100 93 186 3 1878815520 14082640 25922784
17:07:41 2553 8192000000 10780600592 11171889152 1844737888 18.379 100 87 173 3 1881890432 13234256 23918288
17:07:50 3113 8192000000 10790986480 11174473728 1843930992 18.373 100 87 173 0 1881013456 13121808 23960656
17:07:59 2468 8192000000 10798655264 11184402432 1852320880 18.441 100 89 178 2 1891959328 13443040 26195408
17:08:08 2061 8192000000 10801881696 11186884608 1855276528 18.465 100 93 186 1 1896217232 15240080 25700624
17:08:16 1379 8192000000 10801539264 11188199424 1858410416 18.490 100 94 185 0 1898073232 13725264 25937552
17:08:24 1988 8192000000 10809664752 11195535360 1858670688 18.493 100 95 190 1 1901235680 15831808 26733184
17:08:32 1421 8192000000 10808452560 11192020992 1860970416 18.511 100 93 187 1 1901235888 13624832 26640640
17:08:40 1975 8192000000 10809790896 11198963712 1862786272 18.526 100 91 182 1 1905298512 16563632 25948608
17:08:48 28464 8192000000 10801972816 11193241600 1861118096 18.512 100 52 104 3 1885474704 8991088 15365520
17:09:29 7525 8192000000 10816109440 11207483392 1868270496 18.570 100 83 167 2 1902459232 10109504 24079232
17:09:43 1194 8192000000 10820502688 11213463552 1877178032 18.642 100 98 196 4 1917132064 11775088 28178944
17:09:51 4418 8192000000 10779839760 11200294912 1865081520 18.544 100 44 88 1 1887195072 10147360 11966192
17:10:02 4308 8192000000 10791101952 11203493888 1869604352 18.581 100 36 72 1 1887082176 7124496 10353328
17:10:13 6663 8192000000 10784542224 11202953216 1870547632 18.589 100 43 85 1 1890435664 8311808 11576224
17:10:26 5935 8192000000 10788581392 11202142208 1870789280 18.591 100 25 49 1 1883559216 5357776 7412160
17:10:41 7678 8192000000 10780782784 11206856704 1871808608 18.599 100 26 52 1 1885463104 7093760 6560736
17:10:55 5465 8192000000 10795323632 11218698240 1877196368 18.642 100 42 84 0 1900695072 12211040 11287664
17:11:10 7979 8192000000 10781208752 11213279232 1876381136 18.636 100 21 42 2 1888484784 6687376 5416272
17:11:28 10143 8192000000 10803077184 11219951616 1879875232 18.664 100 24 48 1 1892048144 5189856 6983056
17:11:45 10048 8192000000 10785324368 11214012416 1878452992 18.653 100 15 30 1 1887665360 4982016 4230352
17:12:01 7688 8192000000 10786838352 11217248256 1881646192 18.678 100 20 40 1 1893279280 6070016 5563072
17:12:19 53479 8192000000 10807300576 11231354880 1886316656 18.716 100 32 64 1 1901192960 5436896 9439408
17:13:22 12110 8192000000 10816442384 11232829440 1888723200 18.735 100 24 46 1 1900933536 5752880 6457456
17:13:42 7001 8192000000 10808607360 11233345536 1889301136 18.740 100 30 58 2 1903451264 5972384 8177744
17:13:55 5846 8192000000 10811354576 11236401152 1892237936 18.764 100 37 73 1 1909984480 7832240 9914304
17:14:08 6801 8192000000 10811998832 11237142528 1890333328 18.748 100 20 41 2 1902506224 6645184 5527712
17:14:23 5042 8192000000 10821331760 11249639424 1898720464 18.816 100 27 55 1 1917208864 10376448 8111952
17:14:35 7175 8192000000 10828198144 11257036800 1899901376 18.826 100 19 40 0 1911485616 5314448 6269792
17:14:49 4024 8192000000 10832066352 11251503104 1903959408 18.858 100 28 56 0 1918395536 5796592 8639536
17:15:01 9902 8192000000 10820113280 11252199424 1903934032 18.858 100 14 28 0 1913160816 5631760 3595024
17:15:19 8752 8192000000 10811581184 11250819072 1908857120 18.897 100 22 44 1 1920266128 4555472 6853536
17:15:33 4922 8192000000 10832004544 11263950848 1909651824 18.904 100 22 44 1 1922777456 6649712 6475920
17:15:45 5451 8192000000 10827312928 11260063744 1911250096 18.917 100 23 46 3 1924583104 6695168 6637840
17:15:56 6007 8192000000 10834373632 11261976576 1899094448 18.819 99 28 56 0 1913552336 6648560 7809328
17:16:09 11224 8192000000 10815780608 11254611968 1893364592 18.773 99 18 36 3 1904520400 6096992 5058816
17:16:27 11479 8192000000 10820377488 11248693248 1885615680 18.710 99 14 28 0 1895736896 5917600 4203616
17:16:45 13562 8192000000 10811649840 11244605440 1882248672 18.683 99 29 58 1 1900127472 9638656 8240144
17:17:08 66697 8192000000 10799513392 11236233216 1847361232 18.401 97 25 49 0 1864620704 9933200 7326272
17:18:21 7965 8192000000 10783320800 11209555968 1836560784 18.313 97 27 54 0 1850277808 6504336 7212688
17:18:35 4953 8192000000 10771360128 11194892288 1830488112 18.263 97 40 81 0 1848656560 6997392 11171056
17:18:50 4898 8192000000 10778202320 11207122944 1853588160 18.451 99 33 67 0 1869375872 5965328 9822384
17:19:01 4743 8192000000 10763370512 11181957120 1809234800 18.090 97 25 50 1 1822111360 5658656 7217904
17:19:12 5299 8192000000 10744391616 11164913664 1762451184 17.705 95 18 36 1 1772881968 5482304 4948480
17:19:24 6861 8192000000 10737075792 11157790720 1808056320 18.080 98 22 44 3 1819382560 5237456 6088784
17:19:38 6714 8192000000 10701135808 11123449856 1774924032 17.808 98 21 42 1 1786266832 5267456 6075344
17:19:51 7428 8192000000 10719874208 11135614976 1771339952 17.778 98 27 54 2 1784749664 5579040 7830672
17:20:06 8196 8192000000 10738726832 11155656704 1784264176 17.885 98 31 56 3 1796828736 4897120 7667440
17:20:24 8837 8192000000 10717039552 11137122304 1761057440 17.693 97 14 27 1 1770573024 5104112 4411472
17:20:40 7782 8192000000 10719461008 11139702784 1761774832 17.699 97 28 56 2 1776074528 5969680 8330016
17:20:55 11780 8192000000 10703073344 11121790976 1738285008 17.504 96 15 30 4 1747690496 4798384 4607104
17:21:13 13118 8192000000 10715066832 11135049728 1757591680 17.664 97 13 26 0 1766610560 5394256 3624624
17:21:33 6134 8192000000 10707443728 11110678528 1755521376 17.647 97 50 100 2 1776738864 6523296 14694192
17:21:49 4407 8192000000 10715392048 11114938368 1776192480 17.818 99 32 62 0 1791847728 4029872 11625376
17:22:00 61076 8192000000 10718209536 11142967296 1811069072 18.105 100 41 82 0 1827887488 5204240 11614176
17:23:07 13383 8192000000 10704692416 11121152000 1762236320 17.703 97 23 46 3 1774612992 5856016 6520656
17:23:30 9098 8192000000 10734507744 11156033536 1817135040 18.154 100 31 62 0 1832762000 7161760 8465200
17:23:46 6749 8192000000 10740311328 11166351360 1829074592 18.252 100 29 58 2 1842289936 4927056 8288288
17:23:59 6172 8192000000 10763384224 11177816064 1838801200 18.331 100 28 56 1 1852671808 5815136 8055472
17:24:12 5887 8192000000 10768979200 11188236288 1850277088 18.424 100 26 52 1 1863669968 5828704 7564176
17:24:24 8834 8192000000 10765824112 11191468032 1853792240 18.453 100 30 60 3 1868404992 6083680 8529072
17:24:44 7657 8192000000 10782632176 11204300800 1862240640 18.521 100 30 58 2 1875807760 5149936 8417184
17:25:01 6113 8192000000 10785398800 11208282112 1863399088 18.531 100 19 38 1 1875105440 6590256 5116096
17:25:14 8523 8192000000 10785712352 11212222464 1870642352 18.589 100 40 81 3 1889381120 5460496 13278272
17:25:29 8609 8192000000 10778900800 11209338880 1866789776 18.558 100 20 40 1 1878327088 5495664 6041648
17:25:44 12035 8192000000 10782577264 11210432512 1868426544 18.572 100 20 41 2 1879909840 5489344 5993952
17:26:05 12293 8192000000 10779597712 11213021184 1867724288 18.566 100 9 18 2 1875271536 5020416 2526832
17:26:24 5300 8192000000 10779820848 11216080896 1871802368 18.599 100 16 32 2 1881814576 5687504 4324704
17:26:35 23561 8192000000 10798709696 11224899584 1879198672 18.659 100 20 40 3 1890703760 5368608 6136480
17:27:06 113504 8192000000 10837856208 11268321280 1906772816 18.881 100 33 63 1 1920424224 4470848 9180560
17:29:09 10570 8192000000 10864988016 11288276992 1934931520 19.106 100 55 112 1 1959194800 7916960 16346320
17:29:27 5200 8192000000 10890084672 11306307584 1943671280 19.176 100 71 142 3 1977035200 13070336 20293584
17:29:41 26391 8192000000 10883257536 11301572608 1942871216 19.170 100 47 94 4 1966019616 9975760 13172640
17:30:18 31523 8192000000 10882012080 11318362112 1954072128 19.259 100 49 99 1 1981582160 13531728 13978304
17:31:04 62514 8192000000 10894154272 11338379264 1965959680 19.353 100 39 78 1 1992605776 14653264 11992832
17:32:27 11589 8192000000 10910559936 11346321408 1971063360 19.394 100 43 86 1 2001224960 17363424 12798176
17:32:49 27273 8192000000 10918220448 11357216768 1975569184 19.430 100 48 96 0 2009616144 19652832 14394128
17:33:34 3941 8192000000 10918522960 11354779648 1979585408 19.461 100 45 89 2 2010718816 18479392 12654016
17:33:48 8584 8192000000 10924692944 11359178752 1983753040 19.494 100 46 92 0 2017199952 19700416 13746496
17:34:06 18530 8192000000 10950356704 11371806720 1991035168 19.552 100 53 102 1 2025985712 20480352 14470192
17:34:33 12008 8192000000 10928353488 11367309312 1988742608 19.534 100 45 91 0 2020477952 18315392 13419952
17:34:56 12171 8192000000 10924213808 11358187520 1981703440 19.478 100 55 108 0 2018966160 21089280 16173440
17:35:17 10681 8192000000 10936505520 11369984000 1989853344 19.543 100 56 110 1 2026904288 20821968 16228976
17:35:40 2660 8192000000 10962208592 11375214592 2000229552 19.625 100 71 141 1 2042677664 21695936 20752176
17:35:52 2793 8192000000 10950010416 11375464448 1996521536 19.595 100 75 147 0 2039075760 20421584 22132640
17:36:02 2876 8192000000 10958086032 11381895168 2004537936 19.659 100 79 155 0 2048188752 20899920 22750896
17:36:12 3020 8192000000 10956236592 11385200640 2005239456 19.664 100 80 161 2 2051729632 21965088 24525088
17:36:23 11053 8192000000 10963723632 11393769472 2006311056 19.672 100 65 130 0 2054222992 29079792 18832144
17:36:42 3152 8192000000 10983396992 11404144640 2012989776 19.725 100 79 156 1 2061311104 24473536 23847792
17:36:53 2985 8192000000 10973865888 11393282048 2009456560 19.697 100 85 169 0 2062164368 27183600 25524208
17:37:04 11662 8192000000 10953760464 11389558784 2002142432 19.640 100 67 134 2 2051189296 28344848 20702016
17:37:31 2804 8192000000 10980668880 11406254080 2012549824 19.722 100 78 155 2 2064419456 28558704 23310928
17:37:42 10471 8192000000 10972815184 11401121792 2012084656 19.718 100 63 126 1 2056116464 25545504 18486304
17:37:59 4205 8192000000 10962896304 11387805696 1990207568 19.545 99 68 134 2 2033642544 24227456 19207520
17:38:13 7031 8192000000 10962739264 11384569856 1999252800 19.617 100 75 144 1 2046058720 25646976 21158944
17:38:28 5620 8192000000 10956642480 11389267968 1988246128 19.530 99 73 146 0 2033403120 23963504 21193488
17:38:41 4236 8192000000 10975243232 11398242304 2009734560 19.699 100 72 136 0 2053455536 23367120 20353856
17:38:56 2359 8192000000 10978028512 11395014656 2007687280 19.683 100 88 174 3 2058839056 24956800 26194976
17:39:05 7360 8192000000 10955297808 11386527744 1989170928 19.537 99 76 152 2 2038347776 26646032 22530816
17:39:20 5806 8192000000 10968931616 11396169728 2007988064 19.686 100 68 135 1 2053685184 25910352 19786768
17:39:35 2804 8192000000 10981973456 11405205504 2015476816 19.745 100 77 152 1 2064653632 26294912 22881904
17:39:47 4382 8192000000 10949116832 11372482560 1972127968 19.402 98 76 150 2 2021637680 26764112 22745600
17:40:00 3388 8192000000 10972626640 11390042112 2000193328 19.624 100 85 170 1 2054604464 28677328 25733808
17:40:10 2517 8192000000 10941997296 11359322112 1974190480 19.419 99 81 162 0 2027771376 29300000 24280896
17:40:21 3327 8192000000 10970347264 11382284288 1993935392 19.575 100 87 173 0 2050623664 30151952 26536320
17:40:32 4917 8192000000 10958134752 11371646976 1973653856 19.414 99 81 157 2 2027337184 30010576 23672752
17:40:44 871 8192000000 10937530272 11349798912 1950109712 19.227 98 88 173 0 2002762608 26658816 25994080
17:40:54 5782 8192000000 10944728000 11373649920 1984869808 19.503 100 68 134 1 2032887120 27430288 20587024
17:41:08 5614 8192000000 10944386768 11364999168 1978378912 19.452 99 77 154 2 2027874368 26201808 23293648
17:41:22 3930 8192000000 10963134688 11387559936 1998307952 19.609 100 72 144 0 2047713872 27690752 21715168
17:41:33 2499 8192000000 10959942400 11381469184 1993694560 19.573 100 75 147 0 2043955120 28272128 21988432
17:41:42 6058 8192000000 10947058608 11369046016 1960691312 19.312 98 81 162 1 2013562272 28798528 24072432
17:41:59 6460 8192000000 10938515184 11363733504 1974295520 19.420 100 68 136 1 2024918224 28979440 21643264
17:42:14 9532 8192000000 10955302880 11380367360 1985317168 19.507 100 68 134 0 2037382688 31029376 21036144
17:42:31 2347 8192000000 10962412208 11382956032 1989690112 19.541 100 71 141 0 2043157408 32570000 20897296
17:42:39 4708 8192000000 10976659312 11395629056 1997319520 19.602 100 86 171 1 2058832224 35822544 25690160
17:43:00 2644 8192000000 10956225088 11380940800 1958621232 19.295 98 80 161 1 2020629232 37175552 24832448
17:43:12 6221 8192000000 10948518752 11378995200 1978410848 19.452 100 78 156 3 2035863344 33606736 23845760
17:43:27 5674 8192000000 10935519824 11363667968 1968016032 19.370 100 59 119 0 2017809984 31536672 18257280
17:43:40 2269 8192000000 10954640496 11371229184 1981249008 19.475 100 84 167 1 2038697584 31164480 26284096
17:43:52 3218 8192000000 10946583472 11368763392 1974721088 19.423 100 73 146 0 2027427696 29957632 22748976
17:44:05 5467 8192000000 10946998112 11372969984 1978507680 19.453 100 63 126 0 2029474880 31451168 19516032
17:44:18 962 8192000000 10946426944 11361587200 1954630912 19.263 99 72 145 2 2009075104 32723776 21720416
17:44:26 6368 8192000000 10945682144 11361820672 1964750000 19.344 100 78 153 2 2019662848 31436816 23476032
17:44:42 4874 8192000000 10949473232 11369156608 1977528448 19.445 100 80 158 1 2034817312 33160208 24128656
17:44:54 4430 8192000000 10945301776 11374764032 1977562080 19.445 100 67 134 0 2033016240 34401264 21052896
17:45:08 6589 8192000000 10913314112 11348570112 1944995184 19.187 99 56 111 0 1995474032 32994416 17484432
17:45:25 6317 8192000000 10912403936 11340181504 1946670272 19.200 99 54 108 1 1995590896 31112048 17808576
17:45:39 4377 8192000000 10915470144 11339636736 1934624480 19.104 99 65 128 0 1985675888 31263120 19788288
17:45:50 2294 8192000000 10930401072 11356164096 1961442176 19.318 100 66 130 3 2016070688 34045216 20583296
17:46:00 2093 8192000000 10954025232 11369295872 1971024608 19.394 100 86 170 4 2033342736 36184608 26133520
17:46:09 1418 8192000000 10934393376 11339079680 1947647616 19.208 99 88 177 1 2012314000 37516592 27149792
17:46:17 2511 8192000000 10926535936 11345883136 1943075248 19.171 99 79 158 1 2004986064 37468416 24442400
17:46:27 4936 8192000000 10954197536 11364438016 1971623872 19.398 100 84 168 0 2039248896 41313920 26311104
17:46:39 4912 8192000000 10964540496 11384012800 1979410160 19.460 100 81 162 1 2049518192 44850560 25257472
17:46:52 2159 8192000000 10983539568 11397373952 1989053952 19.536 100 88 174 0 2061933424 45345072 27534400
17:47:01 10206 8192000000 10951885904 11397533696 1983611808 19.493 100 49 98 1 2048244400 48141088 16491504
17:47:20 7262 8192000000 10959497040 11391995904 1976689392 19.438 100 52 102 2 2042678560 48232608 17756560
17:47:40 3024 8192000000 10953004288 11377631232 1967878688 19.369 100 57 112 2 2033157616 47125632 18153296
17:47:50 4905 8192000000 10958780608 11376832512 1961006688 19.314 100 66 133 2 2031814304 49219152 21588464
17:48:03 3766 8192000000 10950750992 11377123328 1964853536 19.345 100 71 140 2 2035808864 48105104 22850224
17:48:15 6497 8192000000 10931137808 11363737600 1954826576 19.265 100 53 106 0 2023076448 50810240 17439632
17:48:36 8429 8192000000 10937150080 11364642816 1931666592 19.080 99 50 101 1 2002444080 53541664 17235824
17:48:52 8576 8192000000 10916055744 11348733952 1929411936 19.062 99 53 107 1 1996360960 49099552 17849472
17:49:17 3229 8192000000 10934752576 11362807808 1947790336 19.209 99 60 121 0 2007897840 40511312 19596192
17:49:28 7263 8192000000 10930299184 11362037760 1956800832 19.281 100 58 115 1 2017406000 41763328 18841840
17:49:46 11439 8192000000 10894557376 11350470656 1917019792 18.963 98 28 56 2 1961688736 35531520 9137424
17:50:12 10544 8192000000 10894433712 11328901120 1926284368 19.037 100 38 76 1 1976347680 37456192 12607120
17:50:33 11849 8192000000 10890522592 11323207680 1918746960 18.977 99 34 67 4 1967970288 38306432 10916896
17:50:53 11112 8192000000 10886306128 11337973760 1929386624 19.062 100 32 64 1 1980122240 40343024 10392592
17:51:19 6798 8192000000 10907203056 11338305536 1937421152 19.126 100 57 111 2 1990116928 35982160 16713616
17:51:37 14832 8192000000 10904147680 11345276928 1928600528 19.056 99 24 48 0 1972616960 36032080 7984352
17:52:02 16198 8192000000 10910161840 11352559616 1928192608 19.052 99 26 52 0 1981104144 43735616 9175920
17:52:28 13805 8192000000 10905114576 11343712256 1925202304 19.028 99 31 62 2 1974440864 38930064 10308496
17:52:51 12243 8192000000 10913286528 11356909568 1944516192 19.183 100 28 56 1 1997445296 43231104 9698000
17:53:09 15748 8192000000 10921555072 11365593088 1949320624 19.221 100 35 70 1 2006450208 45263152 11866432
17:53:31 15074 8192000000 10921142768 11374600192 1949735056 19.224 100 24 48 3 2007056176 48686752 8634368
17:53:52 6739 8192000000 10928474240 11382534144 1953822896 19.257 100 33 66 2 2012789504 46727088 12239520
17:54:20 20670 8192000000 10915162240 11381141504 1946581344 19.199 100 24 48 0 2007013520 51494880 8937296
17:55:20 25170 8192000000 10915231632 11368394752 1922878880 19.010 99 22 44 0 1979077600 48391920 7806800
17:55:54 8192 8192000000 10909640784 11366211584 1942070464 19.163 100 24 48 0 1996300848 46227648 8002736
17:56:10 14485 8192000000 10896975632 11356323840 1944601456 19.183 100 12 24 0 1979029008 30570896 3856656
17:56:38 31311 8192000000 10887235280 11359207424 1942458512 19.166 100 15 31 4 1969842208 23285104 4098592
17:57:16 33921 8192000000 10857939104 11314987008 1888088496 18.730 98 7 14 0 1907079728 17270144 1721088
17:58:01 62015 8192000000 10889715872 11337637888 1932186144 19.084 99 25 50 1 1951209824 12304480 6719200
17:59:18 102217 8192000000 10866487920 11323584512 1858313696 18.490 95 5 10 0 1868927232 9864816 748720
18:01:06 80652 8192000000 10880611808 11336396800 1930553888 19.071 99 16 33 0 1943816864 9037024 4225952
18:02:35 61107 8192000000 10892387760 11336896512 1921450928 18.998 98 26 52 1 1936908576 8189840 7267808
18:03:51 22043 8192000000 10901134336 11356045312 1965673648 19.351 100 30 60 2 1985935680 11441184 8820848
18:04:22 93067 8192000000 10901255680 11376070656 1968703616 19.375 100 4 8 0 1984179616 14353248 1122752
18:06:01 30728 8192000000 10927675392 11367014400 1982665552 19.486 100 41 80 1 2001771616 7923168 11182896
18:07:05 66081 8192000000 10950511968 11386757120 1989929824 19.543 100 38 75 0 2013524816 12232208 11362784
18:08:22 23736 8192000000 10934222560 11379187712 1994359088 19.578 100 45 88 2 2016581616 10005904 12216624
18:08:58 94840 8192000000 10933228432 11390181376 1957853392 19.289 98 32 64 1 1980320416 13552416 8914608
18:10:53 45185 8192000000 10918824336 11389906944 1984564096 19.501 100 21 42 1 2005883280 15605328 5713856
18:11:50 36658 8192000000 10916045136 11395182592 1988668912 19.533 100 22 44 0 2007457744 12403248 6385584
18:12:33 14025 8192000000 10912693168 11385118720 1967103984 19.362 99 18 36 0 1985462304 12499856 5858464
18:12:55 16920 8192000000 10919982880 11384078336 1992949328 19.567 100 39 76 1 2012429984 8686624 10794032
18:13:21 64101 8192000000 10924422112 11390656512 1977489104 19.445 99 18 36 2 1990740816 8466304 4785408
18:14:40 49280 8192000000 10931518544 11383664640 1981294304 19.475 99 30 58 1 1998630816 9246176 8090336
18:15:48 2779 8192000000 10929112656 11387949056 1994318224 19.578 100 57 113 0 2024443072 13561232 16563616
18:15:58 32567 8192000000 10909649920 11388739584 1997866112 19.606 100 31 62 2 2016320640 9502192 8952336
18:16:38 18513 8192000000 10898810864 11371876352 1975995776 19.433 99 8 16 0 1985560752 7110144 2454832
18:17:03 21859 8192000000 10905792336 11386806272 1992609264 19.564 100 15 31 1 2003596096 6601744 4385088
18:17:40 42181 8192000000 10902512496 11380142080 1952412944 19.246 98 8 16 0 1963013744 8182960 2417840
18:18:28 9183 8192000000 10905998752 11385573376 1983977952 19.496 100 4 8 0 1993515968 8844720 693296
18:18:46 32626 8192000000 10910493504 11378036736 1952904208 19.250 98 24 48 1 1969468880 9839440 6725232
18:19:40 57255 8192000000 10901959376 11383820288 1963297568 19.332 99 13 26 0 1979467568 12318144 3851856
18:21:17 118947 8192000000 10900523344 11388604416 1967303568 19.364 99 14 28 1 1982086624 10974032 3809024
18:23:45 38590 8192000000 10890448096 11379359744 1971235920 19.395 99 27 54 2 1988387712 9397856 7753936
18:24:30 86552 8192000000 10878070592 11362574336 1883822784 18.696 95 10 20 0 1895932800 9631776 2478240
18:26:03 52592 8192000000 10836483360 11304407040 1782707760 17.872 91 16 29 1 1796656336 10030928 3917648
18:27:09 59953 8192000000 10871580080 11329110016 1833786336 18.290 95 31 62 1 1855099104 13345664 7967104
18:28:20 46067 8192000000 10826449264 11303927808 1814615616 18.134 94 13 26 2 1839435072 20690416 4129040
18:29:14 52695 8192000000 10834573728 11294744576 1863827760 18.534 98 16 32 0 1894640784 26173584 4639440
18:30:14 57988 8192000000 10833090624 11309371392 1859256928 18.497 97 9 18 1 1875164656 13516272 2391456
18:31:18 52209 8192000000 10868177984 11339698176 1876740480 18.639 97 16 32 0 1896792720 15719376 4332864
18:32:23 55618 8192000000 10850682288 11335221248 1872615520 18.605 97 12 24 0 1899883264 24201440 3066304
18:33:25 50237 8192000000 10853831632 11309273088 1825541696 18.223 95 15 30 3 1839824672 9950352 4332624
18:34:26 25044 8192000000 10857429520 11309785088 1884584880 18.702 98 46 91 3 1908562688 11630368 12347440
18:35:01 27055 8192000000 10877784144 11323527168 1926025584 19.035 100 44 87 0 1952961424 14957936 11977904
18:35:37 40037 8192000000 10843799296 11314638848 1888149728 18.731 98 30 60 1 1915931264 19157488 8624048
18:36:24 38761 8192000000 10858148240 11316203520 1886123056 18.715 98 19 38 0 1901347552 9628256 5596240
18:37:09 78950 8192000000 10872505440 11334733824 1917583872 18.967 100 15 30 0 1931666672 9827168 4255632
18:38:34 53157 8192000000 10874425792 11340873728 1916514640 18.959 99 24 45 1 1936695792 14008032 6173120
18:39:34 79664 8192000000 10869579520 11317895168 1852892880 18.446 95 28 56 3 1872075120 11440880 7741360
18:41:01 138406 8192000000 10840829856 11302391808 1825441456 18.222 95 14 28 1 1836183152 7098288 3643408
18:43:26 45152 8192000000 10871274976 11332894720 1923407824 19.014 99 39 78 0 1945490512 12020992 10061696
18:44:18 40184 8192000000 10887301328 11343548416 1949731904 19.224 100 44 88 1 1971662064 10156384 11773776
18:45:12 26422 8192000000 10883313104 11346046976 1939931824 19.146 99 55 110 1 1971799104 15224912 16642368
18:45:55 57567 8192000000 10875683360 11359227904 1932772352 19.089 99 5 10 1 1947086080 13006416 1307312
18:46:59 33017 8192000000 10875868272 11340046336 1932913360 19.090 99 19 38 1 1947792464 8286240 6592864
18:47:38 37166 8192000000 10876440864 11356368896 1959821824 19.305 100 21 42 1 1974011120 8312448 5876848
18:48:33 57611 8192000000 10890478832 11378335744 1971342112 19.396 100 13 25 1 1988575776 13737760 3495904
18:49:37 28404 8192000000 10880395088 11361538048 1953017280 19.251 99 18 36 2 1967300208 8689936 5592992
18:50:12 19107 8192000000 10896196752 11373252608 1970146592 19.387 100 13 24 0 1983448976 9837696 3464688
18:50:37 48248 8192000000 10887963584 11369537536 1955197280 19.268 99 12 23 2 1971065552 12788336 3079936
18:51:34 57184 8192000000 10893518944 11387301888 1971995600 19.401 100 19 39 1 1997031920 19985968 5050352
18:52:39 50580 8192000000 10903999328 11381153792 1971252400 19.395 100 6 12 0 1988638608 16072128 1314080
18:53:45 83285 8192000000 10912777472 11400740864 1975348384 19.428 100 13 26 0 1995979952 16911680 3719888
18:55:25 48224 8192000000 10907002128 11390586880 1983937040 19.496 100 22 43 1 2002571856 12491248 6143568
18:56:23 72317 8192000000 10914417360 11394699264 1950670944 19.232 98 15 30 0 1964548816 9522448 4355424
18:57:43 38085 8192000000 10925571296 11399090176 1982703008 19.486 100 30 60 2 2004625936 13167776 8755152
18:58:27 56142 8192000000 10913604736 11400880128 1954494576 19.262 98 22 44 1 1974078912 13521248 6063088
18:59:47 62898 8192000000 10930130656 11393609728 1954687904 19.264 98 19 38 4 1967935744 8069664 5178176
19:00:57 60973 8192000000 10927196784 11395678208 1978907264 19.456 99 33 66 3 2001040928 13129360 9004304
19:02:23 38486 8192000000 10932463280 11401555968 1984507856 19.500 99 32 64 1 2009411248 15807488 9095904
19:03:08 41138 8192000000 10931371952 11414798336 1997275680 19.601 100 28 56 1 2020079648 14776384 8027584
19:04:09 57591 8192000000 10902670928 11384795136 1915820816 18.953 96 22 44 0 1933981856 11635680 6525360
19:06:35 45003 8192000000 10893402000 11374166016 1908006400 18.891 97 12 24 2 1925416592 13616368 3793824
19:07:33 113977 8192000000 10858898560 11327664128 1849009248 18.414 94 14 28 0 1868457728 14776864 4671616
19:09:42 107327 8192000000 10858393424 11338772480 1857431504 18.482 95 18 36 1 1872013728 9981360 4600864
19:11:42 3768 8192000000 10866909856 11337342976 1919330960 18.981 99 20 40 0 1936523824 11448640 5744224
19:12:14 76680 8192000000 10841737200 11323695104 1862667728 18.525 96 13 25 1 1874590080 8272256 3650096
19:13:47 44885 8192000000 10851786992 11335168000 1900946608 18.834 98 10 20 0 1917022784 13558528 2517648
19:14:38 44473 8192000000 10875841120 11350818816 1930058272 19.067 99 16 32 0 1944260784 9687184 4515328
19:15:32 57199 8192000000 10831414080 11311562752 1899189344 18.820 98 18 35 2 1916229472 11326576 5713552
19:16:41 80466 8192000000 10836553072 11321651200 1910690240 18.912 99 17 33 2 1926026320 10500928 4835152
19:18:11 74915 8192000000 10840939328 11318263808 1875227488 18.627 97 17 34 0 1893591184 13076896 5286800
19:19:50 68608 8192000000 10837140400 11321556992 1854080784 18.455 96 16 32 2 1875223056 15757904 5384368
19:21:05 32915 8192000000 10867346944 11335139328 1930569392 19.071 100 20 40 2 1945289088 9706096 5013600
19:21:44 27766 8192000000 10853232720 11322130432 1881741728 18.679 97 26 52 1 1897438752 8509968 7187056
19:22:19 76431 8192000000 10860462864 11325890560 1846112608 18.391 96 18 36 1 1861837520 10710704 5014208
19:23:42 49235 8192000000 10844388384 11307339776 1844946672 18.381 95 28 54 3 1864828256 12301520 7580064
19:24:44 74115 8192000000 10836599792 11310858240 1819677760 18.175 95 13 26 0 1837586256 14497248 3411248
19:26:08 43608 8192000000 10858912848 11310882816 1882226384 18.683 98 36 72 1 1903590352 11249152 10114816
19:27:02 18869 8192000000 10858893200 11309342720 1885209472 18.707 98 45 90 0 1911285248 13750912 12324864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 05-04-2021 19:28:25 to 05-04-2021 19:28:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 114 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2021 19:28:59 to 05-04-2021 19:29:01.

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          250103
MON$OLDEST_ACTIVE               253086
MON$OLDEST_SNAPSHOT             253086
MON$NEXT_TRANSACTION            253086
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                       2052896
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
:87: 
:88: mscs-test-161.budzdorov.ru    Mon Apr  5 19:27:26 2021
:89:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:90: 
:91: 
:92: mscs-test-161.budzdorov.ru    Mon Apr  5 19:27:27 2021
:93:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:94: 
:95: 
:96: mscs-test-161.budzdorov.ru    Mon Apr  5 19:27:32 2021
:97:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:98: 
--- end of diff output ---

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

05.04.21 19:29:02. 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-04-05 19:29:04 No severe PSQL-related problems occured
05.04.21 19:29:06. End of report.