Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.01.2021 16:28
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 17214372 kB
MemAvailable 31309720 kB
Buffers 0 kB
Cached 14451308 kB
SwapCached 4864 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-01-17 16:27:10
DTS_END                         2021-01-17 16:27:10.9400
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/39288
TRN_ID                          243920
ATT_ID                          637
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: 9528.62 20638 1143434
customer order: creation 175.44 363 21053
customer order: refuse 15.43 320 1852
order to supplier: creation 46.68 1334 5602
order to supplier: removal 3.69 98437 443
invoice (draft): creation 46.74 2962 5609
invoice (draft): removal 55.38 792 6645
invoice accept: apply 42.71 17615 5125
invoice accept: cancel 49.64 803 5957
customer reserve: creation 3937.42 174 472490
customer reserve: removal 4854.16 59 582499
realization accept: apply 86.31 170 10357
realization accept: cancel 82.91 114 9949
payment from customer: creation 61.06 97 7327
payment from customer: removal 5.72 75 686
payment to supplier: creation 49.48 115 5938
payment to supplier: removal 3.35 79 402
service: total inventory turnovers 4.74 1015 569
service: total monetary turnovers 6.83 53 819
service: aggregate perf. data 0.90 14264 108
service: refresh index statistics 0.03 273914 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-01-2021 16:28:24 to 17-01-2021 16:28:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11235
TEST_TIME 2 7572
TEST_TIME 3 6001
TEST_TIME 4 6277
TEST_TIME 5 6076
TEST_TIME 6 6255
TEST_TIME 7 6522
TEST_TIME 8 6332
TEST_TIME 9 6342
TEST_TIME 10 6357
TEST_TIME 11 6691
TEST_TIME 12 6904
TEST_TIME 13 6857
TEST_TIME 14 7308
TEST_TIME 15 7319
TEST_TIME 16 7760
TEST_TIME 17 8119
TEST_TIME 18 8483
TEST_TIME 19 8430
TEST_TIME 20 8543
TEST_TIME 21 9019
TEST_TIME 22 9449
TEST_TIME 23 9255
TEST_TIME 24 9639
TEST_TIME 25 10569
TEST_TIME 26 10603
TEST_TIME 27 11243
TEST_TIME 28 11450
TEST_TIME 29 11407
TEST_TIME 30 11183
TEST_TIME 31 11042
TEST_TIME 32 10869
TEST_TIME 33 10803
TEST_TIME 34 10733
TEST_TIME 35 10554
TEST_TIME 36 10525
TEST_TIME 37 10418
TEST_TIME 38 10295
TEST_TIME 39 10527
TEST_TIME 40 10525
TEST_TIME 41 10376
TEST_TIME 42 10301
TEST_TIME 43 10179
TEST_TIME 44 10210
TEST_TIME 45 10238
TEST_TIME 46 10202
TEST_TIME 47 10219
TEST_TIME 48 10140
TEST_TIME 49 10249
TEST_TIME 50 10163
TEST_TIME 51 10143
TEST_TIME 52 10180
TEST_TIME 53 10240
TEST_TIME 54 10162
TEST_TIME 55 10307
TEST_TIME 56 10211
TEST_TIME 57 10213
TEST_TIME 58 10142
TEST_TIME 59 10058
TEST_TIME 60 9960
TEST_TIME 61 9984
TEST_TIME 62 9939
TEST_TIME 63 9856
TEST_TIME 64 9804
TEST_TIME 65 9752
TEST_TIME 66 9726
TEST_TIME 67 9773
TEST_TIME 68 9829
TEST_TIME 69 9806
TEST_TIME 70 9847
TEST_TIME 71 9841
TEST_TIME 72 9861
TEST_TIME 73 9899
TEST_TIME 74 9899
TEST_TIME 75 9936
TEST_TIME 76 9918
TEST_TIME 77 10025
TEST_TIME 78 10011
TEST_TIME 79 10028
TEST_TIME 80 9957
TEST_TIME 81 9883
TEST_TIME 82 9880
TEST_TIME 83 9815
TEST_TIME 84 9807
TEST_TIME 85 9812
TEST_TIME 86 9767
TEST_TIME 87 9738
TEST_TIME 88 9701
TEST_TIME 89 9681
TEST_TIME 90 9628
TEST_TIME 91 9597
TEST_TIME 92 9627
TEST_TIME 93 9642
TEST_TIME 94 9675
TEST_TIME 95 9690
TEST_TIME 96 9683
TEST_TIME 97 9703
TEST_TIME 98 9727
TEST_TIME 99 9779
TEST_TIME 100 9750
TEST_TIME 101 9784
TEST_TIME 102 9764
TEST_TIME 103 9756
TEST_TIME 104 9793
TEST_TIME 105 9802
TEST_TIME 106 9808
TEST_TIME 107 9785
TEST_TIME 108 9741
TEST_TIME 109 9697
TEST_TIME 110 9672
TEST_TIME 111 9672
TEST_TIME 112 9625
TEST_TIME 113 9577
TEST_TIME 114 9569
TEST_TIME 115 9562
TEST_TIME 116 9531
TEST_TIME 117 9517
TEST_TIME 118 9592
TEST_TIME 119 9607
TEST_TIME 120 9540

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-01-2021 16:28:28 to 17-01-2021 16:28:31.

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 1581159 1581159 0 0.00 0 30090 6 0 0
doc_list_biud 1581154 1581154 0 0.00 0 56343 28 0 0
sp_add_invoice_to_stock 5239 5125 114 2.17 21 241413 17615 0 114
sp_cancel_adding_invoice 5957 5957 0 0.00 4 63833 804 0 0
sp_cancel_client_order 1852 1852 0 0.00 4 8776 321 0 0
sp_cancel_customer_reserve 582499 582499 0 0.00 1 56345 60 0 0
sp_cancel_pay_from_customer 686 686 0 0.00 3 9047 76 0 0
sp_cancel_pay_to_supplier 402 402 0 0.00 3 6152 79 0 0
sp_cancel_supplier_invoice 6651 6645 6 0.09 1 17234 793 0 6
sp_cancel_supplier_order 443 443 0 0.00 7 1153641 98438 0 0
sp_cancel_write_off 9949 9949 0 0.00 1 12796 114 0 0
sp_client_order 21053 21053 0 0.00 3 67093 364 0 0
sp_customer_reserve 472490 472490 0 0.00 0 41748 175 0 0
sp_fill_shopping_cart 32261 32261 0 0.00 1 18524 36 0 0
sp_fill_shopping_cart_clo_res 472474 472474 0 0.00 0 16704 14 0 0
sp_get_clo_for_invoice 5106 5106 0 0.00 0 38887 297 0 0
sp_kill_cost_storno 16994 16994 0 0.00 0 9738 54 0 0
sp_kill_qstorno_ret_qs2qd 1182035 1182035 0 0.00 0 56341 32 0 0
sp_kill_qty_storno 622807 622807 0 0.00 0 56343 69 0 0
sp_lock_selected_doc 21434 21434 0 0.00 0 4886 5 0 0
sp_make_cost_storno 28726 28726 0 0.00 0 25867 50 0 0
sp_multiply_rows_for_pdistr 28726 28726 0 0.00 0 6961 25 0 0
sp_multiply_rows_for_qdistr 21052 21052 0 0.00 0 67087 171 0 0
sp_pay_from_customer 7327 7327 0 0.00 4 8403 98 0 0
sp_pay_to_supplier 5938 5938 0 0.00 5 25872 115 0 0
sp_payment_common 13264 13264 0 0.00 1 5082 19 0 0
sp_qd_handle_on_cancel_clo 1852 1852 0 0.00 0 8765 289 0 0
sp_qd_handle_on_invoice_upd_sts 11062 11062 0 0.00 0 14639 296 0 0
sp_qd_handle_on_reserve_upd_sts 10357 10357 0 0.00 0 29035 59 0 0
sp_reserve_write_off 10357 10357 0 0.00 6 29119 170 0 0
sp_supplier_invoice 5609 5609 0 0.00 6 70179 2963 0 0
sp_supplier_order 5602 5602 0 0.00 5 26593 1334 0 0
srv_aggregate_perf_data 108 108 0 0.00 2657 104478 14264 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1352 148839 32792 0 0
srv_find_qd_qs_mism 1094811 1094811 0 0.00 0 30088 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 38 74450 1016 0 0
srv_make_money_saldo 819 819 0 0.00 1 24321 53 0 0
srv_recalc_idx_stat 4 4 0 0.00 104553 446841 273914 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 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5125 5125 0 0.00 0 15656 165 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 1654 65 0 0
t$perf-norm:sp_cancel_client_order 1852 1852 0 0.00 0 3225 13 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 1419 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 686 686 0 0.00 0 3159 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 402 402 0 0.00 0 155 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 421 421 0 0.00 0 925 10 0 0
t$perf-norm:sp_cancel_supplier_order 443 443 0 0.00 0 27476 1574 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 6450 15 0 0
t$perf-norm:sp_client_order 21053 21053 0 0.00 0 13070 19 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 467 3 0 0
t$perf-norm:sp_pay_from_customer 7327 7327 0 0.00 0 7164 8 0 0
t$perf-norm:sp_pay_to_supplier 5938 5938 0 0.00 0 5614 13 0 0
t$perf-norm:sp_reserve_write_off 10357 10357 0 0.00 0 4928 10 0 0
t$perf-norm:sp_supplier_invoice 5609 5609 0 0.00 0 9373 20 0 0
t$perf-norm:sp_supplier_order 5602 5602 0 0.00 0 11512 17 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 458 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 319 3 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1317 18 0 0
t$perf-norm:srv_make_money_saldo 819 819 0 0.00 0 4678 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 10424 10196 228 2.18 0 9743 19 0 228
v_all_customers 38214 38214 0 0.00 0 20 1 0 0
v_all_suppliers 31456 31456 0 0.00 0 19 1 0 0
v_all_wares 42102 42102 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 1084 7 0 0
v_cancel_client_order 3704 3704 0 0.00 0 2973 7 0 0
v_cancel_customer_prepayment 1372 1372 0 0.00 0 6212 10 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 6757 11 0 0
v_cancel_payment_to_supplier 804 804 0 0.00 0 1793 5 0 0
v_cancel_supplier_invoice 854 842 12 1.40 0 1372 15 0 12
v_cancel_supplier_order 886 886 0 0.00 0 534 4 0 0
v_cancel_write_off 2032 2032 0 0.00 0 4264 13 0 0
v_max_id_clo_ord 5602 5602 0 0.00 0 1646 2 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 3201 19 0 0
v_max_id_ord_sup 5607 5607 0 0.00 0 4905 5 0 0
v_max_non_paid_invoice 1418 1418 0 0.00 0 832 2 0 0
v_max_non_paid_realizn 3932 3932 0 0.00 0 1159 3 0 0
v_min_id_clo_ord 5602 5602 0 0.00 0 2851 6 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 9115 27 0 0
v_min_id_ord_sup 5607 5607 0 0.00 0 5398 6 0 0
v_min_non_paid_invoice 5937 5937 0 0.00 0 5079 11 0 0
v_min_non_paid_realizn 7326 7326 0 0.00 0 5011 12 0 0
v_our_firm 10678 10678 0 0.00 0 20 1 0 0
v_reserve_write_off 20714 20714 0 0.00 0 11571 7 0 0
x_lock_depdocs_on_canc_invoice 12181 12181 0 0.00 0 25092 116 0 0
x_lock_depdocs_on_canc_sup_ord 443 443 0 0.00 0 7812 345 0 0
x_make_qstorno_1000_1200 5602 5602 0 0.00 2 26581 1259 0 0
x_make_qstorno_1200_2000 5609 5609 0 0.00 4 70171 2831 0 0
x_make_qstorno_2100_3300 472490 472490 0 0.00 0 41747 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-01-2021 16:28:32 to 17-01-2021 16:28:36.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 16644 8192000000 10239644128 10543484928 934688880 10.241 74 58 116 0 957123040 2653760 19780400
13:57:49 40138 8192000000 10343254624 10659815424 1385717616 14.468 100 76 152 0 1415004320 5141952 24144752
13:58:40 30721 8192000000 10394826048 10718408704 1443800672 14.983 100 85 169 1 1478486800 7096928 27589200
13:59:21 7386 8192000000 10400621888 10730708992 1461205104 15.136 100 86 170 0 1496613280 7716464 27691712
13:59:43 23917 8192000000 10439546688 10770907136 1485783520 15.352 100 84 168 0 1521322528 7915936 27623072
14:00:26 14111 8192000000 10464822976 10802900992 1516166880 15.617 100 89 178 1 1553338656 8698896 28472880
14:00:57 22355 8192000000 10500063664 10842030080 1546514848 15.880 100 84 168 0 1582559328 9514224 26530256
14:01:27 14626 8192000000 10517103712 10866270208 1568940128 16.073 100 78 156 0 1602700208 9738512 24021568
14:01:53 15409 8192000000 10545539104 10899849216 1598383408 16.326 100 82 164 1 1634617504 11232336 25001760
14:02:18 16779 8192000000 10570238256 10925436928 1626162848 16.562 100 82 163 0 1661998432 11303920 24531664
14:02:44 10602 8192000000 10581261520 10944720896 1641123728 16.689 100 74 148 1 1674744944 11530912 22090304
14:03:05 8881 8192000000 10607124608 10967572480 1658712544 16.838 100 90 177 3 1697849440 13016992 26119904
14:03:20 12117 8192000000 10612051984 10975318016 1667252640 16.910 100 84 168 1 1705285408 13546272 24486496
14:03:41 10350 8192000000 10639819760 11005952000 1698256816 17.171 100 83 166 1 1735446416 13323952 23865648
14:03:59 9303 8192000000 10637980416 11013177344 1706399296 17.239 100 83 166 0 1744870448 14087776 24383376
14:04:15 6209 8192000000 10661186688 11031703552 1718858752 17.343 100 84 168 3 1757471408 14266832 24345824
14:04:28 6370 8192000000 10662095008 11039305728 1727790032 17.417 100 81 162 1 1764481728 13584928 23106768
14:04:41 4543 8192000000 10684249488 11060506624 1742869568 17.542 100 79 157 1 1778267232 13191744 22205920
14:04:54 4208 8192000000 10693518128 11069911040 1753413840 17.630 100 84 167 2 1790188176 13376736 23397600
14:05:06 4080 8192000000 10700389344 11084214272 1766698560 17.740 100 79 156 3 1801427856 12370880 22358416
14:05:17 3715 8192000000 10720645264 11096567808 1774278320 17.802 100 82 164 0 1810347552 13073600 22995632
14:05:27 3613 8192000000 10730049104 11104718848 1783117824 17.875 100 88 174 1 1821728720 14122448 24488448
14:05:37 3237 8192000000 10722267264 11103813632 1784150352 17.884 100 85 170 0 1823062368 15422496 23489520
14:05:47 3191 8192000000 10737346992 11117211648 1793739680 17.963 100 91 180 1 1833934352 15411584 24783088
14:05:56 3199 8192000000 10732697968 11119935488 1796914752 17.989 100 83 166 1 1834607824 14760816 22932256
14:06:06 2813 8192000000 10737279168 11118448640 1803269328 18.041 100 97 194 3 1845812720 14919072 27624320
14:06:15 9037 8192000000 10744082064 11125833728 1804305616 18.049 100 78 154 2 1839626448 14010432 21310400
14:06:30 2589 8192000000 10752630016 11136458752 1813316640 18.123 100 84 166 2 1851122288 14093984 23711664
14:06:40 2696 8192000000 10776025440 11157729280 1827319904 18.237 100 89 178 2 1866178448 13960608 24897936
14:06:49 1834 8192000000 10778903408 11160940544 1828702336 18.249 100 89 176 0 1866740336 12903200 25134800
14:06:57 1904 8192000000 10784817904 11168370688 1837530288 18.321 100 91 179 0 1875825680 12289408 26005984
14:07:05 1351 8192000000 10783000752 11167453184 1839462784 18.336 100 90 178 0 1877203168 12546064 25194320
14:07:13 2214 8192000000 10786622912 11174436864 1845547328 18.386 100 88 175 1 1881242256 11581840 24113088
14:07:22 2362 8192000000 10793403072 11179040768 1847933488 18.405 100 94 188 2 1888801168 13893952 26973728
14:07:31 2365 8192000000 10797067872 11182161920 1849670064 18.419 100 90 180 1 1889465408 13373408 26421936
14:07:39 1497 8192000000 10797158384 11183648768 1852204656 18.440 100 90 177 2 1890825904 13905184 24716064
14:07:47 2136 8192000000 10801814144 11187585024 1858913136 18.494 100 93 185 1 1898691664 13845376 25933152
14:07:56 1090 8192000000 10805909248 11194019840 1860650816 18.509 100 94 188 0 1900348784 12859808 26838160
14:08:03 37662 8192000000 10783242576 11190800384 1855661328 18.468 100 63 126 0 1884878672 11062368 18154976
14:08:47 5316 8192000000 10792320128 11198988288 1859540320 18.500 100 48 96 2 1885701744 12941872 13219552
14:08:59 4967 8192000000 10785018576 11202043904 1867870048 18.567 100 48 97 0 1889865856 9018368 12977440
14:09:11 3142 8192000000 10792438384 11207647232 1874525344 18.621 100 53 106 1 1899623408 10330704 14767360
14:09:22 3897 8192000000 10795520016 11212800000 1871377344 18.595 100 49 96 1 1898696224 14022080 13296800
14:09:35 11191 8192000000 10784479280 11204079616 1871563184 18.597 100 21 42 0 1883068640 6114096 5391360
14:09:53 6662 8192000000 10797459984 11211014144 1868901552 18.575 100 25 50 1 1881940752 6340880 6698320
14:10:08 5465 8192000000 10791074320 11213447168 1874521056 18.621 100 26 52 0 1888074112 5780576 7772480
14:10:21 5219 8192000000 10785243808 11213508608 1880601936 18.670 100 23 44 1 1894014272 5686384 7725952
14:10:32 7874 8192000000 10793515616 11220553728 1878916976 18.656 100 18 36 1 1893886352 10096368 4873008
14:10:46 11183 8192000000 10789482624 11221856256 1881454160 18.677 100 14 28 0 1891475424 5746448 4274816
14:11:04 17378 8192000000 10795917456 11227521024 1888869472 18.737 100 30 59 0 1903917344 5445616 9602256
14:11:30 49714 8192000000 10801667696 11236478976 1888303664 18.732 100 27 54 0 1901111440 4730352 8077424
14:12:28 10237 8192000000 10803849408 11232264192 1888005440 18.730 100 18 36 0 1899232336 6112304 5114592
14:12:44 10567 8192000000 10810707712 11238404096 1891315536 18.756 100 33 66 1 1908000528 7383904 9301088
14:13:03 4049 8192000000 10814507376 11240263680 1891420928 18.757 100 27 54 0 1906357728 6966864 7969936
14:13:14 6604 8192000000 10813103424 11242704896 1891777440 18.760 100 23 47 1 1903478768 5050752 6650576
14:13:28 7515 8192000000 10814221904 11243687936 1895502832 18.790 100 28 56 2 1909899408 6088576 8308000
14:13:42 10051 8192000000 10805445584 11243421696 1893705936 18.776 100 20 38 1 1904329776 5271552 5352288
14:14:00 8923 8192000000 10810681440 11246010368 1899327968 18.821 100 16 32 2 1909325936 5552896 4445072
14:14:19 11870 8192000000 10809048496 11247820800 1898861920 18.817 100 25 46 2 1911884928 6373456 6649552
14:14:37 7755 8192000000 10805342240 11245092864 1899825664 18.825 100 22 43 0 1911379744 5175232 6378848
14:14:51 8792 8192000000 10819512464 11252682752 1903087184 18.851 100 22 44 1 1915252272 6121232 6043856
14:15:07 8046 8192000000 10824436000 11252596736 1901445712 18.838 100 21 42 0 1913579344 5639664 6493968
14:15:24 7320 8192000000 10820192224 11251789824 1904604464 18.863 100 25 50 0 1917201600 5359968 7237168
14:15:40 49605 8192000000 10830122432 11249184768 1887659440 18.727 99 31 61 0 1903051424 5368080 10023904
14:16:54 15103 8192000000 10746233232 11177074688 1730052752 17.436 92 14 28 1 1739385136 5303120 4029264
14:17:16 8098 8192000000 10774938976 11198439424 1839784096 18.339 99 26 52 1 1852553584 5395184 7374304
14:17:36 5525 8192000000 10778654560 11202490368 1814529024 18.133 97 31 61 2 1833925648 11136864 8259760
14:17:47 4481 8192000000 10763502800 11190382592 1825245184 18.221 98 33 66 2 1841125824 6891520 8989120
14:17:59 7436 8192000000 10755248096 11176267776 1796887680 17.988 97 27 54 1 1810906000 5562912 8455408
14:18:16 3569 8192000000 10752502928 11168882688 1808592096 18.084 98 35 68 1 1825206832 7113760 9500976
14:18:27 8998 8192000000 10721060848 11154718720 1758118592 17.669 95 19 38 2 1769379488 6134080 5126816
14:18:45 7261 8192000000 10712210880 11128836096 1742114768 17.536 96 20 39 2 1757403520 9611280 5677472
14:18:58 7867 8192000000 10707176480 11124736000 1733368544 17.464 96 26 51 1 1746174784 5630144 7176096
14:19:13 6426 8192000000 10674889936 11085279232 1732236224 17.454 97 20 39 1 1742815408 4941296 5637888
14:19:28 8279 8192000000 10675419744 11089649664 1723939456 17.385 97 29 59 1 1738538688 5737840 8861392
14:19:43 11808 8192000000 10678339344 11098075136 1721846736 17.368 97 16 33 2 1731920192 5855344 4218112
14:20:01 8782 8192000000 10703885888 11120738304 1741962976 17.535 97 18 36 0 1752424400 5120848 5340576
14:20:16 38951 8192000000 10694925408 11114430464 1752835936 17.625 98 27 54 1 1766414736 6269024 7309776
14:21:14 24173 8192000000 10708012816 11130044416 1751994832 17.618 97 25 50 0 1769440384 10347856 7097696
14:21:47 7434 8192000000 10719436128 11141189632 1806310192 18.066 100 32 64 3 1822585888 7250784 9024912
14:22:03 10060 8192000000 10729563504 11143376896 1781641072 17.863 98 24 46 2 1792968112 5249936 6077104
14:22:20 7277 8192000000 10735627568 11149053952 1811343088 18.107 100 40 80 2 1831576496 9005664 11227744
14:22:35 8549 8192000000 10741309840 11163045888 1822291040 18.196 100 38 76 4 1840027120 6833936 10902144
14:22:51 5945 8192000000 10743952736 11172368384 1834565168 18.297 100 30 60 3 1849390048 6196064 8628816
14:23:05 14172 8192000000 10753702080 11182854144 1843074080 18.366 100 22 44 2 1855469408 6027344 6367984
14:23:27 10417 8192000000 10764193360 11187970048 1845031008 18.382 100 21 42 0 1857815664 5685040 7099616
14:23:48 9871 8192000000 10780798112 11198021632 1853384736 18.450 100 32 63 0 1868632928 5309904 9938288
14:24:04 8709 8192000000 10770011776 11200090112 1858035888 18.487 100 19 34 1 1868708528 5096192 5576448
14:24:19 8761 8192000000 10768617888 11206164480 1864350976 18.539 100 24 48 0 1877488096 5236480 7900640
14:24:36 13540 8192000000 10788999280 11213590528 1867936960 18.568 100 24 48 0 1880600144 5831376 6831808
14:24:55 13572 8192000000 10781292624 11210715136 1868714096 18.574 100 10 20 0 1876482928 4754080 3014752
14:25:15 56570 8192000000 10798409008 11220987904 1874811424 18.623 100 31 59 1 1888397328 4878304 8707600
14:26:22 6902 8192000000 10789311536 11224322048 1879941568 18.665 100 33 67 2 1895898224 6857600 9099056
14:26:35 19347 8192000000 10784703616 11221086208 1874480272 18.621 100 16 32 2 1884213840 5064384 4669184
14:27:02 7488 8192000000 10808975872 11238633472 1891025312 18.754 100 34 67 3 1906514928 6481504 9008112
14:27:17 6637 8192000000 10838120000 11252994048 1904886464 18.866 100 45 90 0 1924283456 7460512 11936480
14:27:31 11442 8192000000 10840799360 11260518400 1912068720 18.923 100 51 102 2 1934510672 8566400 13875552
14:27:51 11076 8192000000 10855862768 11271610368 1921883584 19.002 100 59 118 0 1947903952 10357968 15662400
14:28:10 9547 8192000000 10853792048 11278561280 1926546576 19.039 100 57 115 0 1951993072 10068384 15378112
14:28:29 19086 8192000000 10855963184 11285229568 1933582464 19.096 100 47 94 1 1956290912 9342288 13366160
14:28:57 27853 8192000000 10866303392 11294666752 1935452176 19.110 100 38 76 0 1954715728 8411696 10851856
14:29:32 43870 8192000000 10872054640 11306123264 1944867024 19.186 100 38 76 3 1966835600 11237600 10730976
14:30:25 27177 8192000000 10894692256 11323068416 1941169648 19.156 99 43 85 2 1968018304 14329184 12519472
14:31:03 18710 8192000000 10898085120 11325919232 1958727680 19.296 100 52 104 1 1990981792 16132752 16121360
14:31:36 51686 8192000000 10905197072 11340959744 1968700080 19.375 100 49 96 5 2001108800 17681520 14727200
14:32:38 21341 8192000000 10937888832 11353059328 1980865376 19.472 100 57 110 4 2013047344 16857344 15324624
14:33:07 11020 8192000000 10927662528 11359358976 1982917152 19.488 100 58 116 2 2020091056 20339632 16834272
14:33:36 28950 8192000000 10926884928 11373637632 1986836960 19.519 100 51 99 0 2023163168 21965264 14360944
14:34:14 7191 8192000000 10933506096 11376869376 1992263648 19.562 100 48 96 1 2026176416 20013056 13899712
14:34:39 7036 8192000000 10940537744 11381829632 1997098432 19.600 100 51 102 1 2035971472 23858496 15014544
14:34:56 3169 8192000000 10954300144 11376766976 1997039568 19.599 100 78 156 0 2041550416 20953024 23557824
14:35:08 28686 8192000000 10954717360 11388456960 2000552432 19.627 100 58 116 1 2039692320 22610816 16529072
14:35:45 5282 8192000000 10964810752 11394015232 2009865200 19.700 100 67 133 1 2057972816 27028080 21079536
14:35:59 6619 8192000000 10964814112 11400044544 2011010912 19.709 100 61 121 2 2056585104 27672528 17901664
14:36:13 14500 8192000000 10947731216 11375136768 1992085392 19.560 99 58 115 2 2036380672 27211824 17083456
14:36:37 4588 8192000000 10965715952 11398209536 2012773168 19.723 100 67 131 2 2060246464 27696112 19777184
14:36:49 7789 8192000000 10981275296 11408809984 2018412096 19.768 100 66 132 0 2065984496 27718512 19853888
14:37:04 5039 8192000000 10977908960 11408449536 2019993440 19.780 100 67 132 4 2068186080 28577696 19614944
14:37:16 3080 8192000000 10977132848 11408375808 2018752112 19.770 100 58 114 3 2066158496 28835120 18571264
14:37:30 8010 8192000000 10960211968 11387293696 1994821744 19.582 99 64 128 0 2044134368 30218032 19094592
14:37:50 2565 8192000000 10968310624 11396055040 2002371696 19.641 100 66 131 0 2053223504 31014624 19837184
14:38:02 3653 8192000000 10976924496 11406782464 2015567968 19.745 100 82 162 2 2069541120 29935056 24038096
14:38:13 8176 8192000000 10958215824 11385376768 1956921520 19.282 97 67 133 0 2009291296 32078352 20291424
14:38:30 3494 8192000000 10963669824 11391119360 1996229168 19.593 100 71 141 1 2049696144 32598128 20868848
14:38:40 3570 8192000000 10960740528 11389894656 1982972080 19.488 99 65 130 1 2035616448 33266416 19377952
14:38:51 2536 8192000000 10974885008 11390640128 1986245984 19.514 99 82 163 1 2045695488 34595360 24854144
14:39:01 5098 8192000000 10970124672 11398033408 2002540288 19.643 100 72 144 1 2059505776 34396512 22568976
14:39:14 4110 8192000000 10967607456 11393478656 1997977392 19.607 100 75 150 1 2056354464 36019696 22357376
14:39:29 4168 8192000000 10963307792 11391696896 1983198400 19.490 99 71 142 1 2042740736 37814800 21727536
14:39:47 4093 8192000000 10957432336 11384143872 1973726496 19.415 99 79 157 1 2035330432 36815984 24787952
14:39:58 3973 8192000000 10964042112 11391590400 1993004384 19.568 100 63 124 0 2053108368 40652944 19451040
14:40:13 7604 8192000000 10974472080 11400323072 1995670192 19.589 100 70 139 0 2059534032 42401904 21461936
14:40:32 4705 8192000000 10971525856 11396370432 1980835680 19.471 99 64 128 1 2043568816 42909952 19823184
14:40:48 2511 8192000000 10984526528 11404414976 1999299616 19.617 100 78 156 2 2067938032 44410400 24228016
14:40:58 4939 8192000000 10962773712 11380158464 1966896240 19.361 99 89 177 4 2040008048 45741488 27370320
14:41:16 3382 8192000000 10964357328 11391664128 1983614336 19.493 100 65 128 1 2050746048 46836288 20295424
14:41:28 2759 8192000000 10972639200 11395899392 1975703072 19.431 99 75 150 1 2045173296 45890080 23580144
14:41:37 10574 8192000000 10957152464 11390074880 1984122560 19.497 100 72 145 2 2049316768 42550304 22643904
14:41:57 3276 8192000000 10976814784 11400495104 1993895648 19.575 100 77 152 0 2060081248 43031376 23154224
14:42:25 4936 8192000000 10950799232 11381862400 1963338768 19.333 99 64 128 0 2029082624 44953360 20790496
14:42:38 5849 8192000000 10966793152 11392831488 1981133904 19.474 100 60 119 1 2045274368 44546736 19593728
14:42:53 4620 8192000000 10962545440 11387064320 1963861984 19.337 99 69 136 0 2031758080 46245584 21650512
14:43:06 3252 8192000000 10963409488 11387990016 1979891072 19.464 100 65 130 0 2045472112 44882432 20698608
14:43:23 9262 8192000000 10975030880 11409596416 1992293104 19.562 100 52 104 0 2056122240 46444800 17384336
14:43:45 3130 8192000000 10965751216 11398455296 1981400848 19.476 100 59 118 0 2048150512 47644000 19105664
14:43:54 4669 8192000000 10919959952 11347451904 1937568912 19.127 99 73 147 1 2005536176 45615744 22351520
14:44:10 7199 8192000000 10929169056 11360165888 1951697552 19.240 100 50 100 0 2011591792 43821440 16072800
14:44:31 6039 8192000000 10934107776 11355283456 1953541552 19.255 99 59 115 1 2016612144 44385216 18685376
14:44:45 8357 8192000000 10946367520 11372244992 1969308416 19.380 100 65 127 1 2031816256 42580272 19927568
14:45:02 9000 8192000000 10949441184 11369857024 1954131136 19.259 99 74 147 0 2020822912 44266880 22424896
14:45:19 2983 8192000000 10958241472 11377061888 1974126064 19.418 100 75 150 1 2041404208 43529072 23749072
14:45:33 1379 8192000000 10976221824 11384885248 1979046000 19.457 100 94 188 2 2052684864 44869664 28769200
14:45:40 1758 8192000000 10964537856 11370307584 1970941072 19.393 100 98 192 1 2047628000 47112752 29574176
14:45:49 4430 8192000000 10936983888 11361345536 1948616688 19.215 99 68 136 1 2010884032 41376256 20891088
14:46:01 11796 8192000000 10925054096 11367890944 1957398768 19.285 100 31 62 2 2008804656 40828192 10577696
14:46:26 4468 8192000000 10942601008 11384123392 1973405456 19.412 100 46 92 1 2030553888 41894240 15254192
14:46:40 3347 8192000000 10944514768 11376713728 1967914464 19.369 100 57 113 0 2030686544 43741856 19030224
14:46:51 8229 8192000000 10932311936 11355582464 1933943056 19.098 98 56 113 1 1997248688 45379008 17926624
14:47:06 1789 8192000000 10949365056 11372490752 1963011696 19.330 100 69 138 3 2032209360 47150704 22046960
14:47:15 7139 8192000000 10921925824 11341058048 1938339344 19.134 99 68 136 3 2011482112 50998656 22144112
14:47:32 4537 8192000000 10959720256 11370242048 1959356448 19.301 100 86 168 0 2035028704 49852864 25819392
14:47:43 1349 8192000000 10953757360 11364024320 1948528960 19.215 100 87 174 2 2032850128 56904352 27416816
14:47:53 11498 8192000000 10924035616 11366854656 1949794256 19.225 100 43 86 0 2021913600 57422464 14696880
14:48:16 12516 8192000000 10934528768 11374981120 1946349360 19.197 100 38 76 0 2019405376 60646192 12409824
14:48:36 15052 8192000000 10931698848 11375071232 1932370000 19.086 99 36 72 2 2003647104 58731744 12545360
14:49:04 21073 8192000000 10914633856 11360624640 1911936240 18.922 98 34 65 4 1977167184 54195536 11035408
14:49:43 12302 8192000000 10915826000 11351846912 1923791856 19.017 99 37 74 1 1981976880 46235280 11949744
14:50:02 21075 8192000000 10919663280 11359940608 1937218112 19.125 100 42 81 0 2001164400 50533984 13412304
14:50:34 9313 8192000000 10899726320 11337920512 1910943216 18.914 99 49 98 1 1981772560 54752976 16076368
14:50:52 11292 8192000000 10904606400 11342405632 1902307376 18.845 99 36 72 0 1971838720 57835600 11695744
14:51:12 40007 8192000000 10888303936 11334586368 1904772656 18.865 99 28 56 2 1966649824 51750320 10126848
14:52:17 36687 8192000000 10888796560 11352920064 1903900256 18.858 99 25 50 1 1970685456 58041472 8743728
14:53:08 28087 8192000000 10885247904 11344015360 1927944784 19.050 100 20 40 0 1970075216 35223952 6906480
14:53:43 27335 8192000000 10870312400 11336491008 1907598560 18.887 99 15 30 1 1948961424 36279104 5083760
14:54:28 53862 8192000000 10867994240 11327647744 1893283056 18.772 98 15 30 1 1920040416 22315600 4441760
14:55:51 44266 8192000000 10879658384 11341144064 1940751792 19.153 100 12 24 1 1960794640 16143872 3898976
14:56:47 23745 8192000000 10900232240 11320475648 1933721584 19.097 99 55 104 0 1956112080 7307504 15082992
14:57:18 70100 8192000000 10847978720 11302727680 1918277968 18.973 98 44 88 3 1940590736 10114640 12198128
14:59:24 27190 8192000000 10869791296 11317161984 1901836096 18.841 98 43 86 0 1921261216 7638080 11787040
14:59:57 58837 8192000000 10872133824 11318460416 1876417024 18.636 96 25 50 1 1890601328 7058768 7125536
15:01:04 12553 8192000000 10895440160 11330101248 1935991856 19.115 99 50 100 1 1960750368 10487872 14270640
15:01:25 80556 8192000000 10891295616 11349688320 1940265200 19.149 99 17 34 1 1959858480 14617584 4975696
15:02:52 6687 8192000000 10900863744 11356938240 1963992768 19.338 100 30 60 1 1989955552 16742272 9220512
15:03:05 27575 8192000000 10911225232 11368873984 1975722192 19.431 100 27 54 2 2000095392 16335504 8037696
15:03:53 10770 8192000000 10921828448 11373084672 1967989264 19.369 99 34 68 1 1992060144 14112832 9958048
15:04:13 9814 8192000000 10929601760 11378413568 1989052496 19.536 100 31 61 0 2008600848 10691664 8856688
15:04:31 23125 8192000000 10942274704 11386089472 1992435360 19.563 100 23 46 0 2011077824 11298864 7343600
15:05:02 16764 8192000000 10951502192 11396050944 2004371616 19.657 100 59 111 1 2034698560 12589776 17737168
15:05:34 39546 8192000000 10917532864 11386712064 1976434912 19.436 99 27 54 2 2003838256 17435104 9968240
15:06:22 44635 8192000000 10900888544 11377692672 1956711440 19.280 99 17 34 2 1982932304 20677392 5543472
15:07:19 46187 8192000000 10902778176 11383451648 1977410352 19.444 100 8 16 1 1992726832 13026976 2289504
15:08:13 49066 8192000000 10899578080 11366760448 1949374672 19.221 98 16 32 1 1962646240 8634416 4637152
15:09:12 56152 8192000000 10906474368 11383881728 1985408928 19.507 100 15 30 2 2002577568 12280480 4888160
15:10:48 43705 8192000000 10924476944 11404480512 1989561200 19.540 100 18 36 1 2013050000 18297024 5191776
15:11:53 76408 8192000000 10923949520 11387936768 1952881904 19.249 98 16 32 2 1969355648 12001200 4472544
15:13:19 40912 8192000000 10912945648 11385978880 1954480464 19.262 98 16 32 3 1971959392 13057936 4420992
15:14:15 41482 8192000000 10924830176 11394060288 1989276320 19.538 100 38 76 0 2015629152 14962800 11390032
15:15:19 38607 8192000000 10925226800 11381915648 1957187168 19.284 98 20 40 1 1972282064 9248336 5846560
15:16:06 66839 8192000000 10901141472 11377197056 1979342624 19.459 100 16 32 0 1996132272 12246640 4543008
15:17:20 30417 8192000000 10921510528 11388715008 1998139856 19.608 100 21 42 0 2014049184 10249312 5660016
15:17:57 32624 8192000000 10936988768 11387248640 1959313520 19.301 98 30 61 3 1980524640 12606736 8604384
15:18:39 38851 8192000000 10931442432 11394998272 1990062256 19.544 100 27 54 2 2013460928 15885440 7513232
15:19:25 50716 8192000000 10923409472 11385249792 1947891408 19.210 98 15 30 0 1965564624 13076656 4596560
15:20:25 107744 8192000000 10890387584 11373387776 1896644304 18.799 96 7 14 1 1916729392 17983136 2101952
15:22:25 64070 8192000000 10904529968 11364118528 1914750160 18.945 97 15 30 1 1929904304 10620080 4534064
15:23:52 50657 8192000000 10931308592 11383013376 1955277600 19.268 99 38 74 0 1985092544 19176560 10638384
15:24:50 75770 8192000000 10918153392 11368333312 1975819984 19.432 100 37 74 0 1999849344 13835632 10193728
15:26:19 53425 8192000000 10827408320 11271680000 1869964400 18.584 95 26 51 2 1883143824 6205104 6974320
15:27:21 31531 8192000000 10884159824 11339108352 1932497296 19.087 99 34 68 1 1950955856 9237264 9221296
15:28:15 23400 8192000000 10885633456 11348004864 1949143808 19.220 99 29 58 1 1967523472 10359216 8020448
15:28:45 32719 8192000000 10880160224 11351945216 1947038304 19.203 99 15 30 0 1958874832 7808960 4027568
15:29:25 49648 8192000000 10865088720 11339669504 1915364832 18.950 98 6 12 0 1924447232 7630384 1452016
15:30:28 52988 8192000000 10866624784 11330695168 1877492880 18.645 96 18 35 0 1892662576 9921296 5248400
15:31:27 56378 8192000000 10857159376 11325231104 1899439328 18.822 98 16 32 1 1915939104 11997296 4502480
15:32:30 71060 8192000000 10851603984 11316461568 1826615568 18.232 94 13 26 0 1843025888 13082720 3327600
15:33:50 58599 8192000000 10824165280 11272847360 1827826576 18.242 95 17 34 1 1844494032 11763504 4903952
15:34:55 47050 8192000000 10803598624 11274272768 1824062592 18.211 96 21 42 0 1838615072 8653248 5899232
15:35:53 32383 8192000000 10870069584 11310559232 1915488368 18.951 100 36 72 2 1934366832 8147088 10731376
15:36:39 49131 8192000000 10860542976 11317927936 1908777984 18.897 99 28 56 2 1925847632 9401632 7668016
15:37:40 58599 8192000000 10864932752 11332780032 1890459136 18.749 98 21 42 0 1908540816 12140688 5940992
15:39:02 72147 8192000000 10859873616 11339505664 1902938016 18.850 98 26 51 2 1928022224 17201504 7882704
15:40:20 110012 8192000000 10873050816 11344240640 1897118128 18.803 98 7 13 1 1916278720 16897040 2263552
15:42:18 83165 8192000000 10892375024 11365076992 1950893088 19.234 100 18 36 0 1975267040 19244272 5129680
15:43:48 125626 8192000000 10893562448 11373907968 1907943792 18.890 97 8 16 0 1921218960 11197024 2078144
15:46:07 54700 8192000000 10871104208 11345125376 1884171232 18.699 96 13 26 0 1904095744 15993040 3931472
15:47:08 148839 8192000000 10860793088 11327791104 1882847232 18.688 97 17 34 0 1900235968 12457056 4931680
15:49:43 42617 8192000000 10875978272 11337797632 1934849456 19.106 99 31 62 1 1953317296 9925360 8542480
15:50:37 49637 8192000000 10912062704 11362230272 1963316016 19.332 100 34 68 1 1982152624 8132224 10704384
15:51:55 51865 8192000000 10883216608 11364552704 1962112640 19.323 100 15 30 1 1973336480 7353712 3870128
15:53:06 52476 8192000000 10887668192 11353296896 1925039200 19.027 98 18 36 2 1941283600 10943248 5301152
15:54:25 53586 8192000000 10866670992 11342966784 1918027552 18.971 98 10 19 1 1931109024 10280800 2800672
15:55:24 71883 8192000000 10878097504 11352850432 1942790736 19.169 99 11 23 1 1956036848 10220544 3025568
15:56:48 38735 8192000000 10880402720 11363762176 1960322800 19.309 100 10 21 1 1973182288 10016656 2842832
15:58:18 9675 8192000000 10860311536 11314405376 1898313024 18.813 96 40 82 1 1918044304 7785456 11945824
15:58:34 75960 8192000000 10873799680 11362869248 1937888960 19.130 99 9 18 0 1952785488 12613920 2282608
16:00:09 67829 8192000000 10893933584 11363069952 1945619376 19.192 99 17 34 1 1963360688 12596848 5144464
16:01:23 54853 8192000000 10895910048 11386163200 1954376480 19.261 99 18 36 1 1971951568 12153312 5421776
16:02:32 69180 8192000000 10899754128 11369340928 1920445040 18.990 97 14 29 2 1937291216 12895632 3950544
16:03:48 26676 8192000000 10915419840 11373281280 1959618592 19.303 99 37 75 1 1981077552 10761552 10697408
16:04:29 50448 8192000000 10895576928 11359657984 1936644448 19.120 98 22 44 1 1955975280 13000736 6330096
16:05:26 68924 8192000000 10915282992 11375161344 1948333632 19.213 98 32 64 1 1967976736 11073824 8569280
16:07:20 73513 8192000000 10898455680 11368611840 1928130640 19.052 98 11 22 0 1943663376 12711216 2821520
16:08:47 55947 8192000000 10894938224 11360624640 1946065376 19.195 99 15 30 0 1960420320 9942144 4412800
16:09:51 68848 8192000000 10897646384 11349319680 1851648384 18.436 94 24 48 2 1873002592 14871008 6483200
16:11:27 111335 8192000000 10883528608 11363782656 1843710464 18.371 94 11 22 0 1858288720 10944128 3634128
16:14:04 121093 8192000000 10844108656 11315273728 1823323088 18.205 93 29 58 0 1843898784 13309840 7265856
16:16:23 53890 8192000000 10858671088 11331571712 1916293728 18.957 99 14 28 0 1931192928 10915952 3983248
16:17:52 39411 8192000000 10860869200 11330289664 1893092736 18.771 97 23 46 1 1914398832 14752976 6553120
16:18:49 92916 8192000000 10850639696 11326590976 1850495056 18.426 95 18 36 0 1869688576 14084336 5109184
16:20:31 69855 8192000000 10831510944 11304591360 1850460080 18.426 96 16 32 0 1866715936 11489088 4766768
16:22:15 63384 8192000000 10850820768 11319771136 1897025776 18.802 99 13 26 0 1912402800 11037008 4340016
16:23:25 58109 8192000000 10838089712 11310530560 1867693648 18.566 97 12 24 0 1883647760 12267520 3686592
16:24:43 56695 8192000000 10824044320 11310436352 1885637888 18.711 98 17 32 2 1911552768 19879968 6034912
16:25:47 39023 8192000000 10860156496 11318353920 1884937952 18.705 98 29 58 0 1905791536 12209504 8644080
16:26:34 46157 8192000000 9461223744 9761222656 608667840 6.916 32 10 18 2 618789712 7113824 3008048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-01-2021 16:28:38 to 17-01-2021 16:29:09.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-01-2021 16:29:10 to 17-01-2021 16:29:12.

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          244234
MON$OLDEST_ACTIVE               244619
MON$OLDEST_SNAPSHOT             244619
MON$NEXT_TRANSACTION            244619
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                       2024736
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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'

17.01.21 16:29:13. 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-01-17 16:29:16 No severe PSQL-related problems occured
17.01.21 16:29:17. End of report.