Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.02.2021 16: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 17169720 kB
MemAvailable 31185852 kB
Buffers 0 kB
Cached 14505080 kB
SwapCached 4872 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-08 16:27:17
DTS_END                         2021-02-08 16:27:17.8760
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39504
TRN_ID                          236961
ATT_ID                          710
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: 9010.17 21846 1081221
customer order: creation 166.33 368 19959
customer order: refuse 14.60 359 1752
order to supplier: creation 44.88 1350 5385
order to supplier: removal 3.70 104962 444
invoice (draft): creation 43.75 3659 5250
invoice (draft): removal 53.27 865 6392
invoice accept: apply 39.63 19157 4755
invoice accept: cancel 47.95 804 5754
customer reserve: creation 3622.13 192 434656
customer reserve: removal 4680.08 64 561610
realization accept: apply 82.03 195 9843
realization accept: cancel 84.73 122 10167
payment from customer: creation 58.07 123 6968
payment from customer: removal 5.61 155 673
payment to supplier: creation 47.82 147 5738
payment to supplier: removal 3.79 104 455
service: total inventory turnovers 4.47 1252 537
service: total monetary turnovers 6.57 26 788
service: aggregate perf. data 0.76 24237 91
service: refresh index statistics 0.03 278770 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-02-2021 16:27:58 to 08-02-2021 16:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6292
TEST_TIME 2 8219
TEST_TIME 3 7655
TEST_TIME 4 7563
TEST_TIME 5 7109
TEST_TIME 6 6836
TEST_TIME 7 6956
TEST_TIME 8 6992
TEST_TIME 9 6631
TEST_TIME 10 6225
TEST_TIME 11 6073
TEST_TIME 12 6130
TEST_TIME 13 6346
TEST_TIME 14 6583
TEST_TIME 15 6580
TEST_TIME 16 6471
TEST_TIME 17 6520
TEST_TIME 18 6715
TEST_TIME 19 6932
TEST_TIME 20 6853
TEST_TIME 21 7355
TEST_TIME 22 7519
TEST_TIME 23 7594
TEST_TIME 24 7885
TEST_TIME 25 8219
TEST_TIME 26 8357
TEST_TIME 27 8729
TEST_TIME 28 8946
TEST_TIME 29 9432
TEST_TIME 30 10344
TEST_TIME 31 10708
TEST_TIME 32 10625
TEST_TIME 33 10368
TEST_TIME 34 10186
TEST_TIME 35 10173
TEST_TIME 36 10057
TEST_TIME 37 9950
TEST_TIME 38 9848
TEST_TIME 39 9654
TEST_TIME 40 9764
TEST_TIME 41 9630
TEST_TIME 42 9724
TEST_TIME 43 9654
TEST_TIME 44 9550
TEST_TIME 45 9606
TEST_TIME 46 9531
TEST_TIME 47 9420
TEST_TIME 48 9455
TEST_TIME 49 9456
TEST_TIME 50 9368
TEST_TIME 51 9356
TEST_TIME 52 9287
TEST_TIME 53 9229
TEST_TIME 54 9220
TEST_TIME 55 9146
TEST_TIME 56 9208
TEST_TIME 57 9134
TEST_TIME 58 9017
TEST_TIME 59 8927
TEST_TIME 60 8940
TEST_TIME 61 8855
TEST_TIME 62 8862
TEST_TIME 63 8827
TEST_TIME 64 8849
TEST_TIME 65 9025
TEST_TIME 66 8992
TEST_TIME 67 8986
TEST_TIME 68 9010
TEST_TIME 69 9061
TEST_TIME 70 9061
TEST_TIME 71 9059
TEST_TIME 72 9065
TEST_TIME 73 9137
TEST_TIME 74 9141
TEST_TIME 75 9115
TEST_TIME 76 9213
TEST_TIME 77 9136
TEST_TIME 78 9066
TEST_TIME 79 9024
TEST_TIME 80 8976
TEST_TIME 81 8924
TEST_TIME 82 8941
TEST_TIME 83 8904
TEST_TIME 84 8903
TEST_TIME 85 8947
TEST_TIME 86 8922
TEST_TIME 87 8906
TEST_TIME 88 8925
TEST_TIME 89 9044
TEST_TIME 90 9056
TEST_TIME 91 9039
TEST_TIME 92 9056
TEST_TIME 93 9101
TEST_TIME 94 9137
TEST_TIME 95 9111
TEST_TIME 96 9153
TEST_TIME 97 9216
TEST_TIME 98 9127
TEST_TIME 99 9042
TEST_TIME 100 9050
TEST_TIME 101 9082
TEST_TIME 102 9042
TEST_TIME 103 9003
TEST_TIME 104 9008
TEST_TIME 105 8959
TEST_TIME 106 8930
TEST_TIME 107 8929
TEST_TIME 108 8980
TEST_TIME 109 8958
TEST_TIME 110 8927
TEST_TIME 111 9037
TEST_TIME 112 9019
TEST_TIME 113 9009
TEST_TIME 114 9019
TEST_TIME 115 9065
TEST_TIME 116 9032
TEST_TIME 117 9074
TEST_TIME 118 9044
TEST_TIME 119 9067
TEST_TIME 120 9012

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-02-2021 16:28:02 to 08-02-2021 16:28:05.

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 1486298 1486298 0 0.00 0 24133 7 0 0
doc_list_biud 1486295 1486295 0 0.00 0 61318 31 0 0
sp_add_invoice_to_stock 4900 4755 145 2.95 40 165124 19158 0 145
sp_cancel_adding_invoice 5754 5754 0 0.00 4 65042 805 0 0
sp_cancel_client_order 1752 1752 0 0.00 4 11133 360 0 0
sp_cancel_customer_reserve 561610 561610 0 0.00 1 25849 65 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 2 11577 156 0 0
sp_cancel_pay_to_supplier 455 455 0 0.00 3 6269 104 0 0
sp_cancel_supplier_invoice 6406 6392 14 0.21 1 61325 865 0 14
sp_cancel_supplier_order 444 444 0 0.00 7 1146484 104962 0 0
sp_cancel_write_off 10167 10167 0 0.00 1 9778 122 0 0
sp_client_order 19959 19959 0 0.00 3 20808 369 0 0
sp_customer_reserve 434656 434656 0 0.00 0 108701 193 0 0
sp_fill_shopping_cart 30591 30591 0 0.00 1 19265 42 0 0
sp_fill_shopping_cart_clo_res 434655 434655 0 0.00 0 20527 14 0 0
sp_get_clo_for_invoice 4754 4754 0 0.00 0 21852 280 0 0
sp_kill_cost_storno 17049 17049 0 0.00 0 8289 68 0 0
sp_kill_qstorno_ret_qs2qd 1140223 1140223 0 0.00 0 61313 35 0 0
sp_kill_qty_storno 600715 600715 0 0.00 0 61317 75 0 0
sp_lock_selected_doc 20304 20304 0 0.00 0 8042 7 0 0
sp_make_cost_storno 27303 27303 0 0.00 0 15016 56 0 0
sp_multiply_rows_for_pdistr 27302 27302 0 0.00 0 11733 36 0 0
sp_multiply_rows_for_qdistr 19959 19959 0 0.00 0 18691 157 0 0
sp_pay_from_customer 6968 6968 0 0.00 4 11988 123 0 0
sp_pay_to_supplier 5738 5738 0 0.00 5 14604 147 0 0
sp_payment_common 12705 12705 0 0.00 1 13574 36 0 0
sp_qd_handle_on_cancel_clo 1752 1752 0 0.00 0 11128 332 0 0
sp_qd_handle_on_invoice_upd_sts 10508 10508 0 0.00 0 23603 348 0 0
sp_qd_handle_on_reserve_upd_sts 9842 9842 0 0.00 0 16950 59 0 0
sp_reserve_write_off 9843 9843 0 0.00 6 16977 195 0 0
sp_supplier_invoice 5250 5250 0 0.00 6 101057 3659 0 0
sp_supplier_order 5385 5385 0 0.00 5 78822 1351 0 0
srv_aggregate_perf_data 91 91 0 0.00 2723 328315 24237 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1532 163642 33358 0 0
srv_find_qd_qs_mism 1036590 1036590 0 0.00 0 23980 6 0 0
srv_make_invnt_saldo 537 537 0 0.00 39 135673 1252 0 0
srv_make_money_saldo 788 788 0 0.00 1 1805 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 167540 415386 278770 0 0
t$perf-abend:sp_add_invoice_to_stock 145 145 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4756 4756 0 0.00 0 21015 189 0 0
t$perf-norm:sp_cancel_adding_invoice 374 374 0 0.00 0 5134 101 0 0
t$perf-norm:sp_cancel_client_order 1752 1752 0 0.00 0 2398 10 0 0
t$perf-norm:sp_cancel_customer_reserve 646 646 0 0.00 0 4272 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 2338 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 455 455 0 0.00 0 2109 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 917 15 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 27790 1819 0 0
t$perf-norm:sp_cancel_write_off 973 973 0 0.00 0 2800 11 0 0
t$perf-norm:sp_client_order 19959 19959 0 0.00 0 14952 21 0 0
t$perf-norm:sp_customer_reserve 961 961 0 0.00 0 3108 9 0 0
t$perf-norm:sp_pay_from_customer 6968 6968 0 0.00 0 6288 10 0 0
t$perf-norm:sp_pay_to_supplier 5738 5738 0 0.00 0 5822 18 0 0
t$perf-norm:sp_reserve_write_off 9843 9843 0 0.00 0 5407 15 0 0
t$perf-norm:sp_supplier_invoice 5250 5250 0 0.00 0 16743 29 0 0
t$perf-norm:sp_supplier_order 5385 5385 0 0.00 0 7771 20 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 310 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 2350 25 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 813 24 0 0
t$perf-norm:srv_make_money_saldo 788 788 0 0.00 0 1628 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 9798 9508 290 2.95 0 11511 24 0 290
v_all_customers 36566 36566 0 0.00 0 89 1 0 0
v_all_suppliers 29544 29544 0 0.00 0 14 1 0 0
v_all_wares 39918 39918 0 0.00 0 12 1 0 0
v_cancel_adding_invoice 748 748 0 0.00 0 293 6 0 0
v_cancel_client_order 3504 3504 0 0.00 0 3816 5 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 7694 19 0 0
v_cancel_customer_reserve 1292 1292 0 0.00 0 5560 10 0 0
v_cancel_payment_to_supplier 910 910 0 0.00 0 4325 11 0 0
v_cancel_supplier_invoice 810 782 28 3.45 0 303 14 0 28
v_cancel_supplier_order 888 888 0 0.00 0 312 3 0 0
v_cancel_write_off 1946 1946 0 0.00 0 3347 14 0 0
v_max_id_clo_ord 5384 5384 0 0.00 0 2684 2 0 0
v_max_id_clo_res 961 961 0 0.00 0 1534 8 0 0
v_max_id_ord_sup 5248 5248 0 0.00 0 7855 5 0 0
v_max_non_paid_invoice 1597 1597 0 0.00 0 8943 12 0 0
v_max_non_paid_realizn 3699 3699 0 0.00 0 1915 4 0 0
v_min_id_clo_ord 5384 5384 0 0.00 0 7933 6 0 0
v_min_id_clo_res 961 961 0 0.00 0 6860 11 0 0
v_min_id_ord_sup 5248 5248 0 0.00 0 4590 4 0 0
v_min_non_paid_invoice 5737 5737 0 0.00 0 9707 27 0 0
v_min_non_paid_realizn 6968 6968 0 0.00 0 7402 17 0 0
v_our_firm 9890 9890 0 0.00 0 89 1 0 0
v_reserve_write_off 19684 19684 0 0.00 0 7541 7 0 0
x_lock_depdocs_on_canc_invoice 11755 11755 0 0.00 0 18289 130 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 11286 455 0 0
x_make_qstorno_1000_1200 5385 5385 0 0.00 2 78815 1264 0 0
x_make_qstorno_1200_2000 5250 5250 0 0.00 3 90816 3502 0 0
x_make_qstorno_2100_3300 434656 434656 0 0.00 0 108695 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-02-2021 16:28:06 to 08-02-2021 16:28:10.

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
13:57:21 16 8192000000 8808535104 8821772288 11761552 0.143 4 1 2 0 11883616 59504 62560
13:57:28 29859 8192000000 10290427136 10597109760 1062617488 11.482 82 65 133 0 1087466016 3077024 21771504
13:58:06 28815 8192000000 10356976304 10674659328 1388156560 14.489 100 82 164 0 1420643232 5365936 27120736
13:58:44 24212 8192000000 10387500512 10712117248 1446203008 15.004 100 92 184 0 1482955216 6635904 30116304
13:59:19 17043 8192000000 10414900496 10743025664 1463613024 15.158 100 85 170 0 1499093984 7599200 27881760
13:59:48 1218 8192000000 10425398560 10755518464 1482835280 15.326 100 90 180 0 1520874656 8496416 29542960
13:59:59 15949 8192000000 10445800928 10778316800 1497217856 15.452 100 90 180 0 1534943920 8573616 29152448
14:00:29 11726 8192000000 10461764304 10797142016 1517806848 15.631 100 89 178 1 1555662128 9508256 28347024
14:00:53 21763 8192000000 10480531232 10820685824 1535246656 15.782 100 90 180 0 1574212368 10211472 28754240
14:01:25 12645 8192000000 10485356416 10828320768 1543645280 15.855 100 87 174 2 1582492112 10945312 27901520
14:01:48 11181 8192000000 10504221872 10853294080 1563436576 16.026 100 83 164 0 1599643856 10812512 25394768
14:02:10 12537 8192000000 10524080368 10873200640 1580475296 16.172 100 80 161 1 1616232112 10770368 24986448
14:02:31 15898 8192000000 10560258160 10912116736 1604388272 16.377 100 81 162 1 1639718336 11016176 24313888
14:02:55 12231 8192000000 10569123232 10926981120 1627472336 16.573 100 87 174 0 1666225728 12336976 26416416
14:03:18 14906 8192000000 10590490000 10955505664 1650085136 16.765 100 81 162 1 1686156368 12321920 23749312
14:03:39 11921 8192000000 10618218144 10983981056 1666921216 16.907 100 78 156 4 1702700416 12622864 23156336
14:04:00 12992 8192000000 10629568448 11000385536 1687033840 17.076 100 79 157 2 1722348080 12720096 22594144
14:04:22 10622 8192000000 10654814336 11025227776 1709831200 17.267 100 80 160 2 1745655456 12436336 23387920
14:04:40 7442 8192000000 10660771776 11034292224 1724173568 17.387 100 80 160 0 1759798976 12612992 23012416
14:04:54 5341 8192000000 10667677760 11046211584 1733008512 17.461 100 76 153 0 1767816576 12603296 22204768
14:05:08 4316 8192000000 10683122896 11062931456 1744599008 17.557 100 72 144 2 1777414368 12434848 20380512
14:05:20 6730 8192000000 10686736512 11071791104 1756848848 17.658 100 72 144 1 1788902992 11358512 20695632
14:05:35 11593 8192000000 10691910720 11077386240 1763594384 17.714 100 68 136 2 1794647792 11757536 19295872
14:05:54 3408 8192000000 10718817904 11099709440 1780918224 17.857 100 83 166 2 1817162976 11829440 24415312
14:06:04 6255 8192000000 10732588096 11119407104 1793949376 17.964 100 78 156 1 1827619776 12138000 21532400
14:06:17 3034 8192000000 10731140096 11118231552 1799001616 18.006 100 77 150 1 1830821440 10902208 20917616
14:06:27 4834 8192000000 10736878992 11128881152 1806487504 18.067 100 77 153 1 1841089744 12119632 22482608
14:06:39 3129 8192000000 10747443744 11132735488 1812819824 18.119 100 82 162 1 1848351264 12180048 23351392
14:06:49 3483 8192000000 10747114544 11133804544 1817426256 18.157 100 86 172 1 1853722240 12418208 23877776
14:06:59 3430 8192000000 10760362432 11145551872 1822041088 18.194 100 86 172 0 1858602288 12138160 24423040
14:07:10 2810 8192000000 10763291120 11147784192 1824548112 18.215 100 80 160 2 1858447280 10979776 22919392
14:07:19 2247 8192000000 10754492272 11145654272 1828651440 18.248 100 72 137 3 1858573376 11254928 18667008
14:07:28 2420 8192000000 10772980496 11161731072 1830398320 18.263 100 89 180 1 1869096800 13124544 25573936
14:07:38 1700 8192000000 10778886416 11165741056 1838259344 18.327 100 86 172 0 1875303120 13036144 24007632
14:07:46 3753 8192000000 10789840960 11171233792 1838094400 18.325 100 83 166 0 1875004672 13899696 23010576
14:07:57 2755 8192000000 10790949232 11174064128 1839405984 18.336 100 87 176 1 1877664016 14033312 24224720
14:08:06 1983 8192000000 10795015872 11178323968 1845788320 18.388 100 92 186 1 1884773984 13301248 25684416
14:08:15 1930 8192000000 10789835040 11171504128 1845634704 18.387 100 91 180 3 1883932880 13054832 25243344
14:08:23 2335 8192000000 10778170448 11172712448 1846723008 18.395 100 78 157 1 1880347984 12251968 21373008
14:08:32 2007 8192000000 10787077808 11176300544 1848261088 18.408 100 92 185 2 1887290480 13162880 25866512
14:08:40 1459 8192000000 10796963744 11181338624 1851331472 18.433 100 93 185 0 1891303104 13156816 26814816
14:08:48 1638 8192000000 10799366688 11185795072 1854059248 18.455 100 92 187 1 1894191552 13306160 26826144
14:08:56 41263 8192000000 10794228496 11182501888 1850254352 18.424 100 67 134 1 1878545712 8528944 19762416
14:09:44 1917 8192000000 10803122528 11190767616 1856559520 18.475 100 82 165 0 1890371824 9412064 24400240
14:09:53 2054 8192000000 10802460320 11193491456 1858730240 18.493 100 88 174 1 1895138352 11097392 25310720
14:10:01 11094 8192000000 10774559280 11187638272 1851864384 18.437 100 37 74 1 1871683616 9219296 10599936
14:10:19 5655 8192000000 10771945760 11186597888 1852475216 18.442 100 29 57 3 1867387024 6410272 8501536
14:10:31 9004 8192000000 10756579376 11185889280 1856611744 18.476 100 32 64 3 1873464208 8191040 8661424
14:10:47 5652 8192000000 10767211920 11193335808 1858676496 18.493 100 28 56 0 1874240560 7912208 7651856
14:11:05 5621 8192000000 10774370736 11197931520 1863707520 18.533 100 30 60 2 1879158832 6813776 8637536
14:11:19 6839 8192000000 10774180496 11197652992 1861933872 18.519 100 20 39 1 1874346960 6463008 5950080
14:11:34 8053 8192000000 10777730048 11203063808 1867946176 18.568 100 18 36 0 1878715968 5620304 5149488
14:11:48 3455 8192000000 10794300976 11215167488 1883002512 18.689 100 40 79 1 1900528768 6177024 11349232
14:12:01 12248 8192000000 10787280288 11215671296 1876354800 18.636 100 22 44 1 1889264400 5771232 7138368
14:12:34 13769 8192000000 10784115904 11215065088 1878969712 18.657 100 19 37 3 1890617632 5406880 6241040
14:12:57 8690 8192000000 10788329840 11220193280 1882591216 18.686 100 18 36 4 1893993632 6234576 5167840
14:13:15 12414 8192000000 10786481344 11224555520 1884616208 18.702 100 21 42 1 1897041440 6971024 5454208
14:13:34 11178 8192000000 10793841408 11224694784 1886640128 18.719 100 18 36 1 1897906848 6432432 4834288
14:13:52 12027 8192000000 10830763760 11236646912 1899855520 18.825 100 40 80 2 1915186640 4959616 10371504
14:14:10 83906 8192000000 10802381568 11235962880 1889806368 18.744 100 25 51 1 1902652736 5265600 7580768
14:15:43 6573 8192000000 10814216672 11235459072 1871882640 18.600 99 25 50 0 1884105680 4913584 7309456
14:15:57 6012 8192000000 10799345504 11235758080 1887462432 18.725 100 16 32 1 1897545712 6189136 3894144
14:16:09 7032 8192000000 10801904528 11238670336 1891855584 18.761 100 25 48 0 1905356720 5938432 7562704
14:16:23 7559 8192000000 10816112592 11242700800 1892582432 18.767 100 32 64 2 1908588896 7168384 8838080
14:16:40 8558 8192000000 10815394880 11231891456 1858115904 18.488 98 28 57 0 1872396192 6022592 8257696
14:16:56 8302 8192000000 10802762656 11231535104 1871164304 18.594 99 24 48 1 1884451712 5452704 7834704
14:17:14 8658 8192000000 10787377952 11222138880 1862398480 18.523 99 20 40 2 1873470000 5693824 5377696
14:17:29 5326 8192000000 10795398160 11226288128 1864797456 18.542 99 20 40 2 1880691520 10053696 5840368
14:17:41 6169 8192000000 10773099600 11198124032 1843300080 18.368 99 27 55 0 1856332208 5209824 7822304
14:17:56 7134 8192000000 10758672944 11190386688 1824867216 18.217 98 28 57 3 1839252528 5443056 8942256
14:18:12 5690 8192000000 10714115488 11135459328 1795527520 17.977 99 14 28 0 1805938624 5881376 4529728
14:18:24 7711 8192000000 10728189168 11147616256 1780413248 17.853 98 16 32 1 1791221504 5873616 4934640
14:18:39 12420 8192000000 10721764784 11146960896 1757208048 17.661 96 13 26 2 1766625008 5549248 3867712
14:18:59 19310 8192000000 10700495504 11111669760 1649699440 16.762 91 20 40 0 1660710384 5332128 5678816
14:19:25 56555 8192000000 10746396960 11150458880 1793184160 17.958 99 46 93 0 1812117024 5319136 13613728
14:20:30 10523 8192000000 10697330592 11113275392 1715301200 17.313 95 16 32 1 1729349824 9940960 4107664
14:20:47 4870 8192000000 10683658224 11094794240 1724672640 17.391 96 32 61 3 1738326864 3864480 9789744
14:20:58 7569 8192000000 10709016368 11119091712 1716154304 17.320 96 26 51 2 1729142176 5928976 7058896
14:21:15 6508 8192000000 10691864688 11110043648 1737440096 17.497 97 22 44 0 1749341664 6118976 5782592
14:21:31 7548 8192000000 10693557744 11105353728 1757377232 17.663 98 20 41 1 1767906480 5242672 5286576
14:21:45 4911 8192000000 10683849296 11087360000 1729348096 17.430 96 31 62 2 1743954512 5154336 9452080
14:21:56 10967 8192000000 10668299792 11079688192 1692244304 17.120 95 16 33 0 1701635952 5087376 4304272
14:22:14 8097 8192000000 10694649968 11104149504 1743238384 17.546 98 20 40 0 1754808064 5710160 5859520
14:22:28 8768 8192000000 10708112304 11132788736 1797655024 17.995 100 24 47 1 1810261248 6121840 6484384
14:22:46 8103 8192000000 10736485696 11145801728 1807295856 18.074 100 32 64 2 1822452288 5121216 10035216
14:23:03 9268 8192000000 10735076688 11150831616 1818548768 18.166 100 33 67 2 1834309936 5378560 10382608
14:23:22 6232 8192000000 10738700144 11164295168 1827397472 18.238 100 17 34 0 1837423680 5158288 4867920
14:23:40 7173 8192000000 10750198352 11173031936 1819577952 18.174 99 26 53 2 1833053024 5925648 7549424
14:23:56 43928 8192000000 10756260672 11189096448 1844310496 18.376 100 33 68 0 1860291232 5484976 10495760
14:25:02 16850 8192000000 10750167360 11183308800 1830011440 18.259 99 17 34 1 1839668352 4879216 4777696
14:25:25 4013 8192000000 10769898624 11196170240 1854887152 18.462 100 32 64 1 1870759440 6917280 8955008
14:25:37 7374 8192000000 10777549200 11202170880 1860490784 18.507 100 38 76 1 1876634128 5269856 10873488
14:25:52 9670 8192000000 10789022912 11211493376 1863114272 18.529 100 31 62 3 1877651456 5469472 9067712
14:26:10 7282 8192000000 10788592944 11209809920 1865958448 18.552 100 30 60 3 1880913280 6000256 8954576
14:26:25 5321 8192000000 10794339088 11213709312 1867844928 18.567 100 26 53 0 1881747712 6148624 7754160
14:26:40 10241 8192000000 10781512896 11216039936 1872461472 18.604 100 33 66 1 1887860864 5829760 9569632
14:26:56 7691 8192000000 10791980912 11224412160 1873421600 18.612 100 18 35 1 1888055120 9718592 4914928
14:27:10 9380 8192000000 10798450544 11229380608 1887626768 18.727 100 23 46 0 1900044496 6181504 6236224
14:27:27 10132 8192000000 10847677760 11257569280 1908874016 18.898 100 52 104 1 1930258528 6755776 14628736
14:27:44 8048 8192000000 10854414944 11263184896 1915305376 18.949 100 61 121 2 1941114608 9112624 16696608
14:28:00 18218 8192000000 10864762400 11280515072 1925377248 19.030 100 62 124 1 1953603536 11400416 16825872
14:28:26 16737 8192000000 10869188432 11284373504 1929240576 19.061 100 65 130 4 1959501696 11773312 18487808
14:29:03 43490 8192000000 10869184544 11287162880 1932725632 19.089 100 54 107 3 1958860336 11374576 14760128
14:29:52 24155 8192000000 10858706944 11294855168 1934326048 19.101 100 33 67 1 1953705696 8428896 10950752
14:30:24 8365 8192000000 10871491920 11301105664 1938168960 19.132 100 44 89 2 1961450784 10219888 13061936
14:30:47 17300 8192000000 10880439264 11315400704 1950022496 19.227 100 54 108 1 1976998512 10073888 16902128
14:31:12 20202 8192000000 10887540496 11320332288 1954573680 19.263 100 54 109 1 1981186624 11278560 15334384
14:31:45 20653 8192000000 10904935088 11330363392 1962498288 19.326 100 63 125 3 1991494256 11417472 17578496
14:32:13 10890 8192000000 10908807936 11333607424 1967851632 19.368 100 54 107 1 1995951456 12764400 15335424
14:32:53 32360 8192000000 10907580544 11353366528 1971106864 19.394 100 40 80 2 1995563168 12703680 11752624
14:33:41 9777 8192000000 10926576576 11365584896 1988150752 19.529 100 53 104 1 2020825792 16536960 16138080
14:34:12 18827 8192000000 10921554976 11360141312 1967746928 19.368 99 37 74 1 1997864208 18832944 11284336
14:34:39 6351 8192000000 10946117824 11375026176 1990260224 19.546 100 57 114 1 2027553616 20224288 17069104
14:34:53 4308 8192000000 10948857072 11380649984 1994514448 19.579 100 65 130 1 2035976496 21816320 19645728
14:35:05 18327 8192000000 10930440320 11375677440 1993119712 19.568 100 42 84 2 2024236592 18701024 12415856
14:35:31 43484 8192000000 10941034176 11392057344 2000302192 19.625 100 49 98 0 2040972784 25888928 14781664
14:36:22 55836 8192000000 10927849168 11379798016 1983878208 19.495 99 39 78 3 2014278128 18204224 12195696
14:37:26 11626 8192000000 10940690624 11395149824 2002833872 19.645 100 27 54 3 2034656912 22741600 9081440
14:37:45 22676 8192000000 10948432928 11402911744 2004450464 19.658 100 27 54 1 2036587360 23949328 8187568
14:38:28 20523 8192000000 10946348096 11397517312 2004489776 19.658 100 34 67 1 2039255568 24003824 10761968
14:38:57 6685 8192000000 10953876832 11401187328 2010450800 19.705 100 40 80 0 2048108688 25408544 12249344
14:39:14 9402 8192000000 10934394736 11374837760 1974981920 19.425 98 49 99 2 2012741648 22966160 14793568
14:39:31 2585 8192000000 10945060704 11384274944 1991018192 19.552 100 51 102 1 2033469120 26265856 16185072
14:39:42 5870 8192000000 10947363552 11383586816 1979501200 19.461 99 57 112 1 2023833296 26994576 17337520
14:39:56 2933 8192000000 10951340064 11388649472 1994958448 19.583 100 49 97 1 2037523792 27855376 14709968
14:40:11 4868 8192000000 10961997536 11394314240 1986426272 19.516 99 56 112 2 2034499920 30476640 17597008
14:40:24 8419 8192000000 10951128528 11386011648 1978277440 19.451 99 51 102 1 2023132352 29429104 15425808
14:40:41 9473 8192000000 10968573152 11403628544 1989215392 19.538 99 65 128 3 2044465360 35893952 19356016
14:41:07 4304 8192000000 10966522480 11404345344 2001875328 19.638 100 52 104 0 2050228176 32488416 15864432
14:41:19 5020 8192000000 10958072016 11392499712 1997086096 19.600 100 54 108 1 2044290736 30195696 17008944
14:41:31 5968 8192000000 10927244384 11353714688 1954859424 19.265 99 65 130 1 2004831904 30597824 19374656
14:41:46 10587 8192000000 10923444720 11353833472 1952980768 19.250 99 53 106 0 2000178800 30542672 16655360
14:42:07 3570 8192000000 10948998384 11374792704 1979477408 19.461 100 69 138 0 2033825040 33561552 20786080
14:42:20 7356 8192000000 10944867536 11377180672 1981404288 19.476 100 61 122 2 2033892336 34434048 18054000
14:42:36 1562 8192000000 10968817664 11393204224 1991079968 19.552 100 78 156 0 2049761600 35332720 23348912
14:42:44 11564 8192000000 10937301472 11372011520 1961491904 19.318 99 58 115 1 2014176624 35453232 17231488
14:43:07 5344 8192000000 10948004960 11377594368 1977338112 19.444 100 62 122 1 2033492752 37009520 19145120
14:43:20 16440 8192000000 10950322048 11383242752 1983152496 19.490 100 63 126 1 2041518944 39189168 19177280
14:43:47 7529 8192000000 10966253120 11394666496 1967322432 19.364 99 59 118 1 2025371968 39887936 18161600
14:44:04 2869 8192000000 10955584288 11375456256 1970128000 19.386 100 60 120 0 2032442192 43580224 18733968
14:44:16 8578 8192000000 10973150592 11401297920 1988933680 19.535 100 62 124 0 2052156608 44038080 19184848
14:44:40 3951 8192000000 10983518848 11403849728 1994391328 19.578 100 68 134 1 2060562176 45250848 20920000
14:45:01 4786 8192000000 10991739392 11419258880 2003312240 19.649 100 66 132 2 2071924672 47783280 20829152
14:45:13 5294 8192000000 10986079600 11417845760 2005466512 19.666 100 64 127 1 2073398912 47616400 20316000
14:45:26 5442 8192000000 10935868992 11346849792 1922355280 19.006 97 86 169 1 1997745984 48809568 26581136
14:45:39 4327 8192000000 10957317312 11385016320 1971400320 19.397 100 63 126 0 2041417872 49933152 20084400
14:45:51 5571 8192000000 10951503600 11367567360 1945921168 19.194 99 73 144 2 2014517328 45008368 23587792
14:46:05 4426 8192000000 10959885760 11376308224 1966247200 19.356 100 82 164 4 2038569360 46473664 25848496
14:46:16 3026 8192000000 10948167904 11362131968 1963389184 19.333 100 86 171 1 2031888480 41895168 26604128
14:46:26 4162 8192000000 10956856160 11368361984 1967787888 19.368 100 82 158 0 2034526688 41983584 24755216
14:46:39 4861 8192000000 10943927312 11367542784 1936412336 19.118 98 76 150 2 2002519568 42749440 23357792
14:46:53 1531 8192000000 10937683024 11347324928 1949756720 19.225 99 78 154 1 2017447264 43074976 24615568
14:47:04 5071 8192000000 10937080064 11350806528 1943445680 19.174 99 72 145 3 2011620736 45022944 23152112
14:47:20 2213 8192000000 10971873264 11380264960 1973776784 19.415 100 94 184 1 2047627856 45560784 28290288
14:47:30 3051 8192000000 10969670784 11380789248 1961464384 19.318 99 87 175 0 2037494592 47386720 28643488
14:47:40 3811 8192000000 10976021840 11390865408 1983223840 19.490 100 83 165 3 2057589520 47870736 26494944
14:48:00 5103 8192000000 10969825664 11389071360 1976276784 19.435 100 80 159 1 2053811792 51389312 26145696
14:48:14 3876 8192000000 10982857696 11397677056 1986920624 19.519 100 73 146 0 2057551824 47480368 23150832
14:48:26 2842 8192000000 10964312416 11380547584 1967183472 19.363 99 86 172 1 2040716304 46386016 27146816
14:48:38 1987 8192000000 10965226992 11376730112 1967234352 19.364 99 85 171 2 2037720016 43497024 26988640
14:48:46 8635 8192000000 10966421472 11397562368 1986986928 19.520 100 58 116 2 2051041712 44954720 19100064
14:49:12 5772 8192000000 10981290640 11401822208 1989428544 19.539 100 77 153 0 2059996160 46062080 24505536
14:49:25 2627 8192000000 10996947424 11410538496 2002490144 19.642 100 88 176 2 2077129264 46319792 28319328
14:49:33 8167 8192000000 10973092032 11408748544 1993882192 19.574 100 56 112 1 2059834976 47312384 18640400
14:50:01 6067 8192000000 10984759072 11407147008 1984794624 19.503 99 67 134 0 2053402752 47930416 20677712
14:50:17 2740 8192000000 10994363248 11414654976 1998741888 19.613 100 85 166 4 2072371904 47371728 26258288
14:50:28 1572 8192000000 11000318576 11425959936 2004098736 19.655 100 75 151 0 2080519008 52598640 23821632
14:50:38 2226 8192000000 11005784976 11430244352 2008299360 19.688 100 76 150 2 2086630144 54020368 24310416
14:50:47 3221 8192000000 11005167888 11430862848 2010572784 19.706 100 74 148 1 2089203232 54698224 23932224
14:50:57 12318 8192000000 10987145264 11428024320 1986534896 19.516 99 59 118 0 2061389040 55311376 19542768
14:51:17 6200 8192000000 10988172656 11427565568 1997080704 19.600 100 45 89 1 2068593296 55616080 15896512
14:51:31 8255 8192000000 10988729824 11436638208 2000136176 19.624 100 46 91 5 2074908192 58884576 15887440
14:52:00 2780 8192000000 10981790656 11414966272 1987736800 19.526 100 60 122 1 2063823504 55333264 20753440
14:52:12 8327 8192000000 10975262384 11401383936 1972197488 19.403 99 76 148 3 2054570288 58448448 23924352
14:52:40 14020 8192000000 10973738816 11410804736 1985301216 19.507 100 52 102 1 2056407088 54183840 16922032
14:53:00 32769 8192000000 10954752272 11408195584 1974024000 19.417 100 35 70 0 2042907536 56688960 12194576
14:54:01 32330 8192000000 10953999504 11405737984 1981288208 19.475 100 33 66 0 2055026448 61748336 11989904
14:54:40 24624 8192000000 10952470384 11410423808 1967239344 19.364 100 28 56 0 2027162848 49100576 10822928
14:55:24 31119 8192000000 10955078352 11409334272 1954093312 19.259 99 28 56 2 2026013664 61735888 10184464
14:56:03 26493 8192000000 10932204032 11394789376 1921458256 18.999 98 21 42 1 1985874752 55852192 8564304
14:57:17 45532 8192000000 10873670304 11350482944 1886179312 18.715 97 10 20 1 1926670336 36969808 3521216
14:58:09 79084 8192000000 10843602496 11303583744 1749698608 17.599 90 10 20 1 1766663008 14021184 2943216
14:59:34 31283 8192000000 10887249872 11313102848 1895565808 18.791 98 32 66 1 1911464048 7049040 8849200
15:00:14 4787 8192000000 10865733888 11295547392 1913887504 18.938 99 66 122 1 1937518288 6799088 16831696
15:00:27 83616 8192000000 10843659840 11285544960 1879714976 18.663 98 42 80 3 1898675328 8238016 10722336
15:02:00 153021 8192000000 10840116464 11302420480 1836654928 18.314 95 7 14 0 1846210720 7721520 1834272
15:04:39 60211 8192000000 10867041616 11325853696 1936102480 19.116 100 12 24 0 1947909344 8567232 3239632
15:05:46 34111 8192000000 10872261184 11334049792 1932730800 19.089 99 15 30 0 1949927440 12772896 4423744
15:06:27 135193 8192000000 10864940816 11314544640 1884711952 18.703 97 19 39 0 1903746048 13361856 5672240
15:08:53 64204 8192000000 10902883056 11358932992 1961436784 19.317 100 24 48 4 1982039248 14008336 6594128
15:10:14 67614 8192000000 10915854224 11371057152 1975172864 19.426 100 32 64 1 2005004352 20921216 8910272
15:11:29 80844 8192000000 10913208912 11382304768 1977669312 19.446 100 20 41 0 2000571424 16813312 6088800
15:13:00 83178 8192000000 10910244128 11383853056 1976645152 19.438 100 12 24 1 2004481424 23621376 4214896
15:15:06 108427 8192000000 10894758352 11372642304 1978203584 19.450 100 10 20 0 1991498160 10332352 2962224
15:17:05 22949 8192000000 10921193360 11366080512 1965191216 19.347 99 31 62 4 1980711296 7106768 8413312
15:17:36 5384 8192000000 10932698544 11372515328 1990596032 19.549 100 74 149 1 2022722000 10537568 21588400
15:17:48 28566 8192000000 10900031328 11373424640 1983787728 19.495 100 33 66 0 2005913552 11924016 10201808
15:18:47 10508 8192000000 10941902336 11386257408 1995234048 19.585 100 63 124 4 2024226784 11301856 17690880
15:19:14 33551 8192000000 10911240944 11380359168 1975019520 19.425 99 28 56 2 1994960912 11368016 8573376
15:19:57 104361 8192000000 10913852176 11394785280 1973832720 19.416 99 18 36 1 1996822496 17489648 5500128
15:21:47 73415 8192000000 10918733904 11390066688 1995237408 19.585 100 15 30 1 2011684880 11990160 4457312
15:23:07 62432 8192000000 10903774512 11388125184 1993819008 19.574 100 9 18 0 2004407360 7817296 2771056
15:24:16 73805 8192000000 10904500704 11378352128 1939197360 19.140 97 20 40 0 1950582128 5844912 5539856
15:25:46 85141 8192000000 10916057792 11391819776 1990920320 19.551 100 23 46 1 2009334208 11967056 6446832
15:27:31 52786 8192000000 10890071728 11380834304 1962605008 19.327 99 4 8 0 1973368688 9938176 825504
15:28:44 45111 8192000000 10884839472 11368423424 1947648960 19.208 98 11 22 1 1958348560 8222320 2477280
15:29:35 65604 8192000000 10922655584 11398004736 1974388112 19.420 99 19 38 1 1991495008 12318816 4788080
15:31:10 56569 8192000000 10920700112 11398463488 1934627696 19.104 97 18 36 1 1956900784 17323408 4949680
15:32:20 65872 8192000000 10881694896 11353354240 1917584528 18.967 97 7 14 0 1929958064 10600512 1773024
15:33:34 30115 8192000000 10899507136 11361968128 1936206080 19.116 98 27 54 0 1950415760 6783936 7425744
15:34:14 23849 8192000000 10916476368 11367448576 1944582384 19.183 98 47 93 0 1966007664 8197120 13228160
15:34:48 10894 8192000000 10900198592 11354554368 1939847248 19.146 98 54 106 1 1966499344 11619376 15032720
15:35:05 27222 8192000000 10898156016 11362443264 1956699808 19.280 100 32 64 1 1978779776 12521040 9558928
15:35:44 43928 8192000000 10883733696 11348934656 1904031952 18.859 97 28 56 2 1925370000 13854192 7483856
15:36:39 42848 8192000000 10851104720 11313029120 1876706384 18.639 96 17 35 1 1892306064 11178624 4421056
15:37:32 12152 8192000000 10894898576 11332825088 1898185712 18.812 97 57 115 0 1925157600 11123600 15848288
15:37:54 12049 8192000000 10872314704 11318149120 1907491248 18.887 98 51 102 0 1931748640 9848336 14409056
15:38:13 46910 8192000000 10844124976 11298979840 1821229008 18.188 94 19 38 0 1835646432 9210288 5207136
15:39:09 99125 8192000000 10849675008 11320348672 1878888544 18.656 97 8 16 1 1894828000 13698704 2240752
15:40:55 22175 8192000000 10872845568 11326418944 1922316048 19.005 99 30 60 0 1940442928 9520464 8606416
15:41:49 40229 8192000000 10872469568 11321139200 1909207792 18.900 99 28 56 2 1928087728 10804496 8075440
15:42:40 36965 8192000000 10876928192 11339632640 1929282336 19.061 99 54 108 2 1955117888 10263440 15572112
15:43:27 101986 8192000000 10840394800 11292471296 1805210208 18.057 93 16 32 2 1820445952 10706576 4529168
15:45:18 98273 8192000000 10830371376 11293487104 1843159264 18.367 96 27 54 2 1860237504 8691200 8387040
15:47:03 48466 8192000000 10835270720 11297497088 1877078048 18.642 98 19 38 2 1893047104 10285216 5683840
15:47:59 36962 8192000000 10841714256 11312807936 1917496000 18.967 100 18 36 0 1935083824 11818800 5769024
15:49:43 59750 8192000000 10854820784 11328434176 1928031632 19.051 100 10 21 0 1941516704 10835200 2649872
15:50:49 42187 8192000000 10842407344 11315302400 1880025024 18.665 97 13 26 1 1897825904 14001680 3799200
15:52:06 69690 8192000000 10838053744 11293282304 1854344112 18.457 96 22 44 0 1871687328 11654528 5688688
15:53:24 38879 8192000000 10846923920 11309395968 1902668064 18.848 99 37 74 2 1926574304 13466864 10439376
15:54:12 42756 8192000000 10857228624 11304882176 1863177920 18.529 97 34 68 1 1886389024 14461392 8749712
15:55:04 37832 8192000000 10856455600 11329204224 1904014272 18.859 99 30 60 1 1930646960 18196928 8435760
15:56:04 115076 8192000000 10857973360 11329765376 1865191088 18.545 97 11 22 0 1880252608 12548864 2512656
15:58:15 27405 8192000000 10889300768 11335409664 1916882752 18.962 98 42 79 0 1937615392 9468400 11264240
15:58:48 35477 8192000000 10884981456 11340922880 1913084000 18.931 98 26 52 0 1931212048 11428208 6699840
15:59:30 49660 8192000000 10868158144 11337744384 1925949952 19.034 99 19 38 0 1945793520 14728448 5115120
16:00:26 53068 8192000000 10915413824 11362906112 1941614224 19.160 99 27 54 2 1958308784 9247088 7447472
16:01:26 67546 8192000000 10926119984 11374481408 1959116256 19.299 99 34 68 1 1977848320 8512992 10219072
16:02:42 48690 8192000000 10905612800 11384594432 1974010832 19.417 100 25 48 1 1996694464 14927008 7756624
16:03:48 150195 8192000000 10915360320 11387248640 1988220048 19.530 100 16 32 2 2008662208 15713056 4729104
16:06:29 72099 8192000000 10919877920 11402264576 2000943440 19.630 100 26 51 0 2016637856 8817424 6876992
16:08:04 68006 8192000000 10915880976 11417014272 1999534576 19.619 100 15 30 0 2016381728 12509584 4337568
16:09:19 34166 8192000000 10913606208 11410472960 1999681584 19.620 100 6 12 1 2012363232 10971888 1709760
16:09:59 42731 8192000000 10904509616 11383508992 1963814464 19.336 98 19 40 0 1977064256 7309680 5940112
16:10:52 51466 8192000000 10916379824 11396599808 1974649200 19.422 99 15 30 0 1989811888 10398624 4764064
16:11:56 69992 8192000000 10935144528 11415166976 2001946512 19.638 100 23 46 1 2018456048 9217920 7291616
16:13:13 92186 8192000000 10936354672 11420745728 2001517248 19.635 100 10 20 0 2026352800 22066448 2769104
16:14:51 54618 8192000000 10930626880 11417513984 1992126880 19.561 99 18 36 1 2009875648 12335920 5412848
16:15:53 163642 8192000000 10937788528 11428552704 1908471904 18.894 95 14 28 2 1935506320 22446176 4588240
16:18:43 122562 8192000000 10896499328 11361259520 1851891744 18.437 93 9 18 0 1869004928 14903264 2209920
16:21:02 15972 8192000000 10932931296 11376074752 1964796224 19.344 99 58 113 1 1996298832 15651520 15851088
16:21:25 14419 8192000000 10918501008 11375910912 1964022096 19.338 99 66 131 3 1996141472 12826032 19293344
16:21:46 49686 8192000000 10889437552 11367362560 1910643056 18.912 97 26 52 0 1935513072 17487728 7382288
16:22:44 50278 8192000000 10897908880 11361447936 1926744976 19.041 98 24 48 0 1945187424 12182144 6260304
16:23:42 45053 8192000000 10865455984 11311112192 1868251184 18.570 96 43 85 3 1893905984 13191200 12463600
16:25:42 22009 8192000000 10861700512 11316707328 1895278352 18.788 98 38 76 0 1917523120 11779792 10464976
16:26:19 70453 8192000000 9424500896 9718870016 571948544 6.526 30 8 16 1 577710800 3748352 2013904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-02-2021 16:28:12 to 08-02-2021 16:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 145 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-02-2021 16:28:44 to 08-02-2021 16:28:46.

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          237526
MON$OLDEST_ACTIVE               237527
MON$OLDEST_SNAPSHOT             237527
MON$NEXT_TRANSACTION            237527
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                       2019200
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
--- end of diff output ---

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

08.02.21 16:28:47. 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-08 16:28:50 No severe PSQL-related problems occured
08.02.21 16:28:51. End of report.