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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17101772 kB
MemAvailable 31496280 kB
Buffers 0 kB
Cached 14596860 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-02 22:27:31
DTS_END                         2021-04-02 22:27:31.3500
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/33448
TRN_ID                          241748
ATT_ID                          658
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: 9537.50 23090 1144500
customer order: creation 174.41 389 20929
customer order: refuse 15.07 326 1808
order to supplier: creation 46.40 1202 5568
order to supplier: removal 3.53 111490 423
invoice (draft): creation 46.83 3126 5619
invoice (draft): removal 55.44 770 6653
invoice accept: apply 41.31 18272 4957
invoice accept: cancel 50.03 736 6004
customer reserve: creation 3870.23 177 464427
customer reserve: removal 4926.80 62 591216
realization accept: apply 84.79 213 10175
realization accept: cancel 90.19 110 10823
payment from customer: creation 60.80 117 7296
payment from customer: removal 5.69 147 683
payment to supplier: creation 50.48 157 6058
payment to supplier: removal 3.50 82 420
service: total inventory turnovers 4.61 1145 553
service: total monetary turnovers 6.56 54 787
service: aggregate perf. data 0.81 21462 97
service: refresh index statistics 0.03 301769 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2616
TEST_TIME 2 3131
TEST_TIME 3 4227
TEST_TIME 4 3868
TEST_TIME 5 3884
TEST_TIME 6 4228
TEST_TIME 7 4380
TEST_TIME 8 4913
TEST_TIME 9 4858
TEST_TIME 10 5012
TEST_TIME 11 5506
TEST_TIME 12 6082
TEST_TIME 13 6219
TEST_TIME 14 6496
TEST_TIME 15 6535
TEST_TIME 16 6696
TEST_TIME 17 6784
TEST_TIME 18 6855
TEST_TIME 19 7175
TEST_TIME 20 8028
TEST_TIME 21 8359
TEST_TIME 22 8855
TEST_TIME 23 8977
TEST_TIME 24 9101
TEST_TIME 25 8971
TEST_TIME 26 10035
TEST_TIME 27 10365
TEST_TIME 28 10529
TEST_TIME 29 11262
TEST_TIME 30 11179
TEST_TIME 31 11039
TEST_TIME 32 10875
TEST_TIME 33 10961
TEST_TIME 34 10893
TEST_TIME 35 10874
TEST_TIME 36 10826
TEST_TIME 37 10646
TEST_TIME 38 10436
TEST_TIME 39 10317
TEST_TIME 40 10450
TEST_TIME 41 10390
TEST_TIME 42 10199
TEST_TIME 43 10180
TEST_TIME 44 10113
TEST_TIME 45 10184
TEST_TIME 46 10237
TEST_TIME 47 10176
TEST_TIME 48 10065
TEST_TIME 49 9981
TEST_TIME 50 10040
TEST_TIME 51 9939
TEST_TIME 52 9943
TEST_TIME 53 9918
TEST_TIME 54 9845
TEST_TIME 55 9904
TEST_TIME 56 9865
TEST_TIME 57 9963
TEST_TIME 58 9973
TEST_TIME 59 9963
TEST_TIME 60 9921
TEST_TIME 61 9939
TEST_TIME 62 10072
TEST_TIME 63 10194
TEST_TIME 64 10170
TEST_TIME 65 10219
TEST_TIME 66 10184
TEST_TIME 67 10161
TEST_TIME 68 10079
TEST_TIME 69 10040
TEST_TIME 70 9974
TEST_TIME 71 9986
TEST_TIME 72 9926
TEST_TIME 73 9858
TEST_TIME 74 9791
TEST_TIME 75 9764
TEST_TIME 76 9757
TEST_TIME 77 9785
TEST_TIME 78 9752
TEST_TIME 79 9756
TEST_TIME 80 9726
TEST_TIME 81 9753
TEST_TIME 82 9827
TEST_TIME 83 9854
TEST_TIME 84 9798
TEST_TIME 85 9867
TEST_TIME 86 9883
TEST_TIME 87 9880
TEST_TIME 88 9987
TEST_TIME 89 10013
TEST_TIME 90 9930
TEST_TIME 91 9831
TEST_TIME 92 9768
TEST_TIME 93 9801
TEST_TIME 94 9736
TEST_TIME 95 9725
TEST_TIME 96 9726
TEST_TIME 97 9673
TEST_TIME 98 9678
TEST_TIME 99 9670
TEST_TIME 100 9800
TEST_TIME 101 9785
TEST_TIME 102 9772
TEST_TIME 103 9718
TEST_TIME 104 9742
TEST_TIME 105 9767
TEST_TIME 106 9761
TEST_TIME 107 9778
TEST_TIME 108 9845
TEST_TIME 109 9846
TEST_TIME 110 9812
TEST_TIME 111 9746
TEST_TIME 112 9734
TEST_TIME 113 9721
TEST_TIME 114 9679
TEST_TIME 115 9646
TEST_TIME 116 9606
TEST_TIME 117 9600
TEST_TIME 118 9546
TEST_TIME 119 9586
TEST_TIME 120 9538

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-04-2021 22:29:30 to 02-04-2021 22:29:34.

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 1575700 1575700 0 0.00 0 18461 6 0 0
doc_list_biud 1575700 1575700 0 0.00 0 35831 29 0 0
sp_add_invoice_to_stock 5058 4957 101 1.99 33 177037 18273 0 101
sp_cancel_adding_invoice 6004 6004 0 0.00 4 66062 736 0 0
sp_cancel_client_order 1808 1808 0 0.00 4 8333 326 0 0
sp_cancel_customer_reserve 591216 591216 0 0.00 1 35833 63 0 0
sp_cancel_pay_from_customer 683 683 0 0.00 3 30732 147 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 2 4543 82 0 0
sp_cancel_supplier_invoice 6665 6653 12 0.18 2 15046 771 0 12
sp_cancel_supplier_order 423 423 0 0.00 10 1067919 111491 0 0
sp_cancel_write_off 10823 10823 0 0.00 1 12405 110 0 0
sp_client_order 20929 20929 0 0.00 3 31102 389 0 0
sp_customer_reserve 464427 464427 0 0.00 0 52453 178 0 0
sp_fill_shopping_cart 32101 32101 0 0.00 1 8248 33 0 0
sp_fill_shopping_cart_clo_res 464419 464419 0 0.00 0 27251 14 0 0
sp_get_clo_for_invoice 4949 4949 0 0.00 0 39918 322 0 0
sp_kill_cost_storno 17930 17930 0 0.00 0 18454 62 0 0
sp_kill_qstorno_ret_qs2qd 1200331 1200331 0 0.00 0 35829 33 0 0
sp_kill_qty_storno 632051 632051 0 0.00 0 35831 72 0 0
sp_lock_selected_doc 21145 21145 0 0.00 0 8395 6 0 0
sp_make_cost_storno 28478 28478 0 0.00 0 15262 50 0 0
sp_multiply_rows_for_pdistr 28478 28478 0 0.00 0 7361 28 0 0
sp_multiply_rows_for_qdistr 20929 20929 0 0.00 0 15439 163 0 0
sp_pay_from_customer 7296 7296 0 0.00 4 24137 118 0 0
sp_pay_to_supplier 6058 6058 0 0.00 5 31266 157 0 0
sp_payment_common 13354 13354 0 0.00 1 12089 28 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 8310 301 0 0
sp_qd_handle_on_invoice_upd_sts 10953 10953 0 0.00 0 23552 322 0 0
sp_qd_handle_on_reserve_upd_sts 10175 10175 0 0.00 0 35104 70 0 0
sp_reserve_write_off 10175 10175 0 0.00 6 35179 214 0 0
sp_supplier_invoice 5619 5619 0 0.00 7 82446 3126 0 0
sp_supplier_order 5568 5568 0 0.00 5 38103 1202 0 0
srv_aggregate_perf_data 97 97 0 0.00 2793 340761 21462 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 947 130027 32351 0 0
srv_find_qd_qs_mism 1096658 1096658 0 0.00 0 14592 5 0 0
srv_make_invnt_saldo 553 553 0 0.00 28 72166 1145 0 0
srv_make_money_saldo 787 787 0 0.00 0 12487 55 0 0
srv_recalc_idx_stat 4 4 0 0.00 236166 390042 301770 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4957 4957 0 0.00 0 23224 185 0 0
t$perf-norm:sp_cancel_adding_invoice 433 433 0 0.00 0 3998 74 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 3716 15 0 0
t$perf-norm:sp_cancel_customer_reserve 736 736 0 0.00 0 2949 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 683 683 0 0.00 0 4682 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 191 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 11341 52 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 24529 1680 0 0
t$perf-norm:sp_cancel_write_off 1083 1083 0 0.00 0 528 4 0 0
t$perf-norm:sp_client_order 20929 20929 0 0.00 0 19144 20 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 3214 10 0 0
t$perf-norm:sp_pay_from_customer 7296 7296 0 0.00 0 5783 10 0 0
t$perf-norm:sp_pay_to_supplier 6058 6058 0 0.00 0 19632 15 0 0
t$perf-norm:sp_reserve_write_off 10175 10175 0 0.00 0 15531 14 0 0
t$perf-norm:sp_supplier_invoice 5619 5619 0 0.00 0 15167 23 0 0
t$perf-norm:sp_supplier_order 5568 5568 0 0.00 0 7923 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 4529 61 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 257 4 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 524 16 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 4371 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10100 9898 202 2.00 0 30893 33 0 202
v_all_customers 38408 38408 0 0.00 0 58 1 0 0
v_all_suppliers 31354 31354 0 0.00 0 18 1 0 0
v_all_wares 41858 41858 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 866 866 0 0.00 0 1891 9 0 0
v_cancel_client_order 3616 3616 0 0.00 0 3631 6 0 0
v_cancel_customer_prepayment 1366 1366 0 0.00 0 30689 33 0 0
v_cancel_customer_reserve 1472 1472 0 0.00 0 24397 54 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 2733 9 0 0
v_cancel_supplier_invoice 894 870 24 2.68 0 12318 40 0 24
v_cancel_supplier_order 846 846 0 0.00 0 1499 8 0 0
v_cancel_write_off 2166 2166 0 0.00 0 7131 21 0 0
v_max_id_clo_ord 5567 5567 0 0.00 0 233 1 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 4020 13 0 0
v_max_id_ord_sup 5605 5605 0 0.00 0 3794 3 0 0
v_max_non_paid_invoice 1553 1553 0 0.00 0 4687 6 0 0
v_max_non_paid_realizn 3779 3779 0 0.00 0 3465 4 0 0
v_min_id_clo_ord 5567 5567 0 0.00 0 3610 6 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 5396 9 0 0
v_min_id_ord_sup 5605 5605 0 0.00 0 4825 7 0 0
v_min_non_paid_invoice 6058 6058 0 0.00 0 12085 21 0 0
v_min_non_paid_realizn 7296 7296 0 0.00 0 8750 14 0 0
v_our_firm 10484 10484 0 0.00 0 16 1 0 0
v_reserve_write_off 20350 20350 0 0.00 0 30652 21 0 0
x_lock_depdocs_on_canc_invoice 12222 12222 0 0.00 0 23959 125 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 8658 368 0 0
x_make_qstorno_1000_1200 5568 5568 0 0.00 1 38095 1128 0 0
x_make_qstorno_1200_2000 5619 5619 0 0.00 3 82402 3009 0 0
x_make_qstorno_2100_3300 464427 464427 0 0.00 0 39963 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2021 22:29:35 to 02-04-2021 22:29:39.

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
19:57:35 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:41 25195 8192000000 10273743200 10584494080 978484464 10.669 75 53 109 0 997624640 2545936 16594240
19:58:18 24929 8192000000 10364066576 10678939648 1407916272 14.665 100 89 178 1 1441369968 5236592 28217104
19:58:53 27950 8192000000 10386102880 10707996672 1435778016 14.912 100 93 186 0 1473294528 7167008 30349504
19:59:35 27751 8192000000 10406572896 10731225088 1457768864 15.106 100 84 168 1 1493035360 8436288 26830208
20:00:11 12958 8192000000 10425788736 10754134016 1481768864 15.317 100 91 182 1 1520408880 9251200 29388816
20:00:41 16600 8192000000 10443525536 10774810624 1492512784 15.411 100 87 174 0 1529827472 9801472 27513216
20:01:23 22672 8192000000 10465718832 10804428800 1515493536 15.611 100 86 172 0 1553387200 10502992 27390672
20:01:54 15257 8192000000 10480077760 10821832704 1533292768 15.766 100 81 162 2 1569062240 10610864 25158608
20:02:21 20019 8192000000 10515930624 10865487872 1568054560 16.066 100 74 148 1 1601832400 10716288 23061552
20:02:52 14867 8192000000 10534885376 10889031680 1598392768 16.326 100 74 148 0 1631930256 10678816 22858672
20:03:18 12867 8192000000 10571203696 10926514176 1625193968 16.554 100 80 160 2 1660471632 11272320 24005344
20:03:40 11385 8192000000 10583015072 10941591552 1645905984 16.730 100 82 164 3 1682822784 12408032 24508768
20:04:00 11236 8192000000 10598408608 10961272832 1655506688 16.811 100 77 154 1 1691523936 12987184 23030064
20:04:20 7677 8192000000 10616220400 10984910848 1678691008 17.006 100 79 158 0 1712675232 11588960 22395264
20:04:36 7696 8192000000 10639713968 11010285568 1700866480 17.192 100 77 152 2 1735948816 12711024 22371312
20:04:51 9561 8192000000 10658989248 11031818240 1713147072 17.295 100 78 156 2 1748144128 12464976 22532080
20:05:08 8563 8192000000 10665854704 11038941184 1729283600 17.430 100 76 152 0 1763687168 12473696 21929872
20:05:29 5339 8192000000 10685825872 11058135040 1743823280 17.550 100 78 155 0 1778571696 13069696 21678720
20:05:41 5162 8192000000 10682369472 11063046144 1753113920 17.627 100 73 146 0 1787142816 13739088 20289808
20:05:54 4612 8192000000 10706050608 11084398592 1768702192 17.756 100 86 170 1 1806301904 13781888 23817824
20:06:06 4462 8192000000 10715904144 11098222592 1775905680 17.816 100 81 162 0 1811987408 13745536 22336192
20:06:18 2674 8192000000 10729835824 11109265408 1788391920 17.919 100 88 176 1 1826319296 12875008 25052368
20:06:28 8621 8192000000 10728293232 11114250240 1796998800 17.989 100 84 168 1 1833300784 13095136 23206848
20:06:44 4811 8192000000 10731121936 11116552192 1800833776 18.021 100 81 162 0 1836004912 13390976 21780160
20:06:55 2808 8192000000 10760768560 11142746112 1818632464 18.167 100 92 185 2 1859120256 14733488 25754304
20:07:04 2771 8192000000 10766789376 11148795904 1824872896 18.217 100 89 178 1 1863459136 13857296 24728944
20:07:14 2390 8192000000 10770334080 11155943424 1825883072 18.226 100 85 168 1 1863132368 13987728 23261568
20:07:23 1797 8192000000 10772142688 11159818240 1835026208 18.300 100 92 185 0 1875115216 13687552 26401456
20:07:32 2573 8192000000 10778114032 11168464896 1840805056 18.347 100 83 166 4 1876780800 12272064 23703680
20:07:41 2010 8192000000 10794916576 11178029056 1849682608 18.420 100 97 193 2 1889630032 13247792 26699632
20:07:49 1214 8192000000 10799787344 11182465024 1851734896 18.436 100 88 177 2 1890215712 13340592 25140224
20:07:57 2423 8192000000 10796610272 11185324032 1857249120 18.481 100 91 182 3 1896668496 13523856 25895520
20:08:06 1587 8192000000 10804031040 11189841920 1858050768 18.487 100 93 186 4 1897903792 13339984 26513040
20:08:14 1193 8192000000 10807699200 11192803328 1865091504 18.545 100 94 185 1 1904938720 13682912 26164304
20:08:21 1394 8192000000 10811624656 11197964288 1868131952 18.569 100 94 188 0 1908488064 13776240 26579872
20:08:29 2140 8192000000 10811949584 11197931520 1868082560 18.569 100 94 186 1 1908292224 13738592 26471072
20:08:38 2059 8192000000 10817922464 11204747264 1868328912 18.571 100 86 171 1 1905172688 13059264 23784512
20:08:46 30064 8192000000 10775106448 11194204160 1867936176 18.568 100 63 126 1 1898682256 12998704 17747376
20:09:23 3684 8192000000 10804093632 11207593984 1873280608 18.611 100 61 121 2 1897948416 8128128 16539680
20:09:33 5390 8192000000 10790175808 11205795840 1869507488 18.580 100 40 81 2 1889356448 8336400 11512560
20:09:46 4087 8192000000 10806052688 11210014720 1875107136 18.626 100 50 103 1 1897413696 7667008 14639552
20:09:58 5404 8192000000 10789767600 11211264000 1877734176 18.647 100 41 82 2 1898642912 8911152 11997584
20:10:11 4972 8192000000 10786749872 11215310848 1879115648 18.658 100 27 55 0 1893321920 6890624 7315648
20:10:25 3962 8192000000 10803426576 11220459520 1881842672 18.680 100 31 62 0 1898089008 6923648 9322688
20:10:35 6455 8192000000 10793367728 11218837504 1884195472 18.699 100 30 60 0 1899324176 6271504 8857200
20:10:48 7469 8192000000 10788647536 11218173952 1883834224 18.696 100 25 50 1 1898129152 7236912 7058016
20:11:05 11214 8192000000 10790863952 11220770816 1884162720 18.699 100 19 37 3 1894912736 5306976 5443040
20:11:23 11897 8192000000 10795542640 11225362432 1886101488 18.714 100 14 30 0 1895843152 5769360 3972304
20:11:42 10897 8192000000 10791692896 11226644480 1888901424 18.737 100 14 28 1 1898853920 5779488 4173008
20:11:59 18174 8192000000 10800006208 11236487168 1893258192 18.772 100 22 42 2 1905515936 6527200 5730544
20:12:23 50471 8192000000 10807995072 11239129088 1892892064 18.769 100 11 22 0 1905163792 9273808 2997920
20:13:21 25225 8192000000 10825821872 11252822016 1898518256 18.814 100 34 68 2 1917995408 9840240 9636912
20:13:55 7223 8192000000 10823923504 11258531840 1899394160 18.821 100 31 62 1 1914985632 6931360 8660112
20:14:09 5455 8192000000 10828406304 11256840192 1902752704 18.848 100 40 80 4 1925902592 12440720 10709168
20:14:21 4592 8192000000 10828044928 11253997568 1902837664 18.849 100 32 63 3 1919023360 7148544 9037152
20:14:33 7073 8192000000 10820339328 11256270848 1903825424 18.857 100 20 40 0 1914594576 5515696 5253456
20:14:47 9427 8192000000 10805810736 11243175936 1885319136 18.708 99 25 50 1 1897538576 5484576 6734864
20:15:04 6562 8192000000 10818776208 11248435200 1904069616 18.859 100 31 62 1 1919434128 5638160 9726352
20:15:17 9698 8192000000 10811249488 11249242112 1899764480 18.824 100 18 36 2 1911057904 6276208 5017216
20:15:35 7325 8192000000 10821428896 11252453376 1902769104 18.849 100 26 52 1 1915507824 5695968 7042752
20:15:48 11605 8192000000 10814931136 11253026816 1901366528 18.837 100 13 26 0 1910680624 5714656 3599440
20:16:06 12464 8192000000 10810654112 11249537024 1885920640 18.713 99 13 26 1 1894601072 5112656 3567776
20:16:25 11520 8192000000 10765815392 11196166144 1835875808 18.307 97 15 30 0 1845493840 5597280 4020752
20:16:43 10373 8192000000 10779799280 11214196736 1840729696 18.347 98 20 40 4 1852158096 5962496 5465904
20:16:59 60717 8192000000 10791936592 11200143360 1821508672 18.190 97 33 66 3 1836882496 5595776 9778048
20:18:07 28720 8192000000 10777135968 11205369856 1819258864 18.172 97 24 48 0 1831561584 5877424 6425296
20:18:42 6429 8192000000 10785172832 11205210112 1829631568 18.256 98 28 56 1 1844828784 7505648 7691568
20:18:58 6156 8192000000 10779391632 11198963712 1839275424 18.335 99 40 81 1 1857191552 6537696 11378432
20:19:13 3913 8192000000 10754393456 11172323328 1824400960 18.214 99 33 66 2 1841753104 7084096 10268048
20:19:24 4773 8192000000 10743921808 11167842304 1814564368 18.133 99 30 59 0 1828516096 5711248 8240480
20:19:37 7673 8192000000 10735152816 11158138880 1775862896 17.815 97 27 54 2 1789184528 5250352 8071280
20:19:51 5392 8192000000 10742646864 11165573120 1816786816 18.151 99 35 69 2 1836269808 9782832 9700160
20:20:04 7589 8192000000 10738214480 11154235392 1742086848 17.536 95 20 40 0 1751940192 5176128 4677216
20:20:20 9552 8192000000 10665408416 11077640192 1701298624 17.196 94 14 28 1 1710047328 4393792 4354912
20:20:35 7965 8192000000 10684762560 11090120704 1695972128 17.151 94 35 70 1 1712780576 7150944 9657504
20:20:50 6777 8192000000 10679270800 11091648512 1728665744 17.424 97 23 46 4 1741739984 5692176 7382064
20:21:07 10691 8192000000 10707086944 11119218688 1785503264 17.895 100 26 52 1 1798881184 5212848 8165072
20:21:25 7998 8192000000 10711445504 11126468608 1779855440 17.848 99 25 50 0 1792791776 5383808 7552528
20:21:41 22001 8192000000 10705495536 11125620736 1735144240 17.478 96 30 60 3 1748530832 5327152 8059440
20:22:10 68693 8192000000 10730327664 11151163392 1790641216 17.937 98 34 68 0 1805591168 5513776 9436176
20:23:26 10195 8192000000 10747167248 11159019520 1817128976 18.154 100 33 66 0 1831420880 5595888 8696016
20:23:42 4007 8192000000 10754111072 11164946432 1822712480 18.200 100 43 86 1 1846412848 12733568 10966800
20:23:53 5058 8192000000 10755375648 11165818880 1813160432 18.122 99 46 92 0 1833797504 7216768 13420304
20:24:08 7460 8192000000 10748516752 11168342016 1829112704 18.252 100 27 53 1 1841629136 5057488 7458944
20:24:23 7572 8192000000 10737446448 11163201536 1812654656 18.118 99 21 41 1 1824013024 5349312 6009056
20:24:41 7814 8192000000 10750988400 11175079936 1838858384 18.332 100 23 46 2 1851800928 5973856 6968688
20:24:55 6895 8192000000 10759009760 11185717248 1845860160 18.388 100 36 73 3 1861996320 5682016 10454144
20:25:08 9200 8192000000 10762726368 11190689792 1844439840 18.377 100 18 37 1 1855292496 5613792 5238864
20:25:25 7759 8192000000 10757515408 11194306560 1852726320 18.444 100 22 44 2 1864842192 5460624 6655248
20:25:42 9953 8192000000 10786983520 11204255744 1863198960 18.529 100 26 50 0 1875951328 5531904 7220464
20:25:58 9977 8192000000 10785389888 11211001856 1865081872 18.544 100 19 38 0 1876174656 5538384 5554400
20:26:20 10103 8192000000 10789164176 11217711104 1870158064 18.586 100 27 54 0 1884386048 6590752 7637232
20:26:36 14549 8192000000 10792633680 11213619200 1868384384 18.571 100 17 34 0 1878708368 4907120 5416864
20:26:57 34321 8192000000 10795058624 11224473600 1879404640 18.660 100 31 62 2 1894085120 5818048 8862432
20:27:55 60627 8192000000 10845340656 11263315968 1911126064 18.916 100 56 113 2 1933887344 7668784 15092496
20:29:04 1368 8192000000 10858635568 11274608640 1924275968 19.021 100 70 138 1 1953082896 9343568 19463360
20:29:13 15775 8192000000 10863813792 11282481152 1925580656 19.032 100 60 120 2 1952480704 9848752 17051296
20:29:41 40242 8192000000 10869780496 11291734016 1930330112 19.070 100 58 116 2 1959268928 13100080 15838736
20:30:30 16222 8192000000 10873157280 11297714176 1936839712 19.122 100 46 92 0 1961984224 12288096 12856416
20:30:54 4041 8192000000 10878347040 11302834176 1944299168 19.181 100 56 113 1 1972673312 12742192 15631952
20:31:05 42401 8192000000 10886555504 11315290112 1946882400 19.202 100 42 84 0 1973595552 14730976 11982176
20:31:57 15054 8192000000 10890638272 11318648832 1954172272 19.260 100 46 91 0 1983094560 15417440 13504848
20:32:23 11123 8192000000 10894911296 11329359872 1961913024 19.321 100 38 76 0 1988736080 15652416 11170640
20:32:44 31090 8192000000 10909363712 11344977920 1969625824 19.382 100 38 75 2 1999362896 17257424 12479648
20:33:25 27996 8192000000 10911565088 11351851008 1978366224 19.452 100 42 84 1 2009198464 17636448 13195792
20:34:03 11731 8192000000 10923098560 11360153600 1982300192 19.483 100 35 70 1 2013151712 19231712 11619808
20:34:31 19014 8192000000 10937566752 11373821952 1991579280 19.556 100 41 82 0 2025505248 21468352 12457616
20:35:00 14865 8192000000 10919931488 11358015488 1976557488 19.437 99 37 74 2 2011107120 22321376 12228256
20:35:37 19331 8192000000 10945275376 11384008704 2001007664 19.631 100 34 68 0 2033881136 21938800 10934672
20:36:04 7012 8192000000 10949115408 11380883456 2000447776 19.626 100 51 102 1 2037191184 20928368 15815040
20:36:19 8484 8192000000 10915218992 11343347712 1968573632 19.374 98 59 116 1 2009453232 23427072 17452528
20:36:39 9063 8192000000 10961425504 11389870080 2005664688 19.667 100 57 114 0 2050473616 27186752 17622176
20:36:56 9437 8192000000 10965786320 11388219392 2002116688 19.639 100 63 126 0 2047138656 25565664 19456304
20:37:13 9417 8192000000 10962042688 11397058560 2010826816 19.708 100 52 104 1 2054587712 27379008 16381888
20:37:32 7484 8192000000 10976882144 11408621568 2019913696 19.779 100 70 134 1 2073348800 32319232 21115872
20:37:48 11628 8192000000 10978515264 11413184512 2020098672 19.781 100 57 114 0 2069955888 31594864 18262352
20:38:06 2182 8192000000 10991960464 11417985024 2023806960 19.810 100 64 126 1 2075605744 32135456 19663328
20:38:20 3881 8192000000 10992741552 11419328512 2027000176 19.835 100 73 143 1 2083336256 33685584 22650496
20:38:32 3759 8192000000 10977888976 11410825216 2008708672 19.691 99 67 132 2 2061321536 32914256 19698608
20:38:42 4746 8192000000 10995187408 11414740992 2008078624 19.686 99 83 166 2 2067838672 34816176 24943872
20:38:55 12066 8192000000 10999181152 11420643328 2021325264 19.791 100 77 154 3 2081414144 36662256 23426624
20:39:17 1862 8192000000 11008356144 11424694272 2024535888 19.816 100 78 157 1 2085121392 37462048 23123456
20:39:25 3173 8192000000 10995182304 11420819456 2020564832 19.785 100 84 168 0 2084038032 37227152 26246048
20:39:35 8424 8192000000 11000492800 11424358400 2025305920 19.822 100 75 148 2 2085027216 37054064 22667232
20:39:50 2442 8192000000 11012629632 11431239680 2030069824 19.859 100 86 172 1 2095295088 38882528 26342736
20:40:00 2807 8192000000 10993622784 11412389888 2011031632 19.710 100 88 173 1 2075242224 37997984 26212608
20:40:12 5686 8192000000 10983346192 11412406272 2011484528 19.713 100 68 136 0 2070465616 38484832 20496256
20:40:27 3843 8192000000 10992089536 11421159424 2015060384 19.741 100 74 145 0 2076228496 39107840 22060272
20:40:38 7410 8192000000 10991319840 11421315072 2016578992 19.753 100 64 128 0 2075653840 39424688 19650160
20:40:59 9677 8192000000 10997659664 11430096896 2023790704 19.810 100 69 137 0 2084031104 39598832 20641568
20:41:16 4012 8192000000 11007433088 11439841280 2033568992 19.887 100 65 129 1 2093108016 39536832 20002192
20:41:35 5762 8192000000 11008036144 11439140864 2031752592 19.872 100 64 128 2 2090344928 38925360 19666976
20:41:47 3689 8192000000 11007192256 11432165376 2016815584 19.755 99 85 168 1 2082518704 40170144 25532976
20:42:00 4057 8192000000 11005715712 11435319296 2031795136 19.873 100 69 138 0 2090712224 37867312 21049776
20:42:13 3140 8192000000 11013240512 11433672704 2014753648 19.739 99 85 166 1 2081500816 40633232 26113936
20:42:22 2600 8192000000 10996515856 11424616448 2018526160 19.769 100 72 145 1 2083487776 41838848 23122768
20:42:33 2355 8192000000 11011797552 11431170048 2023880576 19.811 100 89 180 1 2095044736 43670576 27493584
20:42:43 5283 8192000000 10992080080 11413659648 2006805264 19.676 99 86 170 2 2076337120 43404704 26127152
20:42:55 2136 8192000000 11011536528 11428290560 2006064896 19.671 99 93 186 1 2079500208 44076496 29358816
20:43:04 3366 8192000000 11013455776 11433689088 2023631536 19.809 100 83 168 0 2095225232 45764624 25829072
20:43:17 7728 8192000000 10996510080 11417112576 2003424400 19.650 99 75 148 1 2073093424 46402768 23266256
20:43:36 2744 8192000000 11013129680 11434541056 2015148080 19.742 100 77 154 2 2091605952 51752960 24704912
20:43:46 6474 8192000000 11008883968 11434655744 2005184384 19.664 99 82 163 3 2081940256 50926064 25829808
20:44:00 4744 8192000000 11011732512 11434020864 2015998464 19.749 100 79 157 1 2092108608 51146752 24963392
20:44:11 3148 8192000000 11026491552 11441930240 2023459072 19.807 100 90 180 0 2103498784 51955728 28083984
20:44:21 1978 8192000000 11027028816 11439476736 2023356384 19.807 100 91 182 4 2104033424 52690960 27986080
20:44:30 6800 8192000000 11002842912 11425935360 1999881136 19.622 99 77 154 0 2074743744 50911104 23951504
20:44:45 2588 8192000000 11012536304 11434024960 2015154848 19.742 100 82 165 0 2092306896 51714224 25437824
20:44:58 1717 8192000000 11018983920 11438821376 2018468816 19.768 100 87 175 2 2099877232 53703584 27704832
20:45:08 3894 8192000000 11030734224 11448221696 2024150080 19.813 100 89 177 1 2107647632 55854752 27642800
20:45:18 5189 8192000000 11031254080 11455840256 2027576400 19.840 100 79 157 1 2109564288 57145456 24842432
20:45:31 5434 8192000000 11031092432 11454775296 2028680592 19.848 100 82 161 1 2111108128 57428608 24998928
20:45:44 1575 8192000000 11039224944 11456315392 2029254464 19.853 100 87 172 1 2116360528 59760544 27345520
20:45:54 2061 8192000000 11044949712 11463135232 2031626144 19.871 100 88 176 0 2123168368 63769920 27772304
20:46:04 1752 8192000000 11044014560 11464429568 2029652384 19.856 100 91 179 0 2124378704 65969088 28757232
20:46:12 3179 8192000000 11041413008 11460235264 2028728384 19.849 100 89 177 1 2121205456 65207840 27269232
20:46:24 1080 8192000000 11034886208 11451342848 2007081392 19.679 99 94 187 1 2103038656 65652848 30304416
20:46:35 3315 8192000000 11033840928 11453878272 2022610080 19.801 100 85 167 0 2114204080 64869392 26724608
20:46:46 4060 8192000000 11040004960 11464011776 2023934784 19.811 100 81 160 0 2119114656 68744320 26435552
20:47:01 2608 8192000000 11041245376 11456270336 2023207424 19.805 100 92 184 2 2116806480 64244896 29354160
20:47:11 2157 8192000000 11037397344 11461169152 2025457680 19.823 100 89 178 1 2119152400 65190224 28504496
20:47:21 5708 8192000000 11031546736 11459104768 2021115968 19.789 100 70 139 0 2112070656 67965216 22989472
20:47:35 7736 8192000000 11009677184 11453222912 2013417536 19.728 100 55 110 1 2096501392 64663904 18419952
20:47:57 13994 8192000000 10987299024 11435356160 2007540640 19.682 100 41 82 1 2076919408 55410304 13968464
20:48:30 6098 8192000000 10982603168 11425320960 1981863552 19.479 99 40 78 2 2052286544 57176512 13246480
20:48:52 29845 8192000000 10969688224 11419258880 1977494736 19.445 99 33 64 1 2045680432 56924608 11261088
20:49:40 21538 8192000000 10948184592 11400753152 1935855248 19.114 97 31 62 0 1992732800 45799664 11077888
20:50:08 10811 8192000000 10963926880 11412930560 1988242240 19.530 100 37 74 1 2041974832 42212672 11519920
20:50:25 10407 8192000000 10953205024 11407773696 1983424384 19.492 100 29 58 2 2041181488 48365600 9391504
20:50:43 21883 8192000000 10927966720 11375525888 1917555648 18.967 97 29 58 0 1973251552 45925696 9770208
20:51:17 2614 8192000000 10945517920 11381747712 1958679872 19.296 100 53 107 1 2024382624 48415232 17287520
20:51:27 7565 8192000000 10936907456 11375550464 1941354480 19.158 99 46 93 0 2006799536 50697968 14747088
20:51:41 16769 8192000000 10926296144 11372584960 1914535584 18.943 98 35 70 1 1978694272 52242832 11915856
20:52:15 17160 8192000000 10934675728 11381714944 1945288656 19.189 100 32 64 0 2013922400 56804368 11829376
20:53:22 17715 8192000000 10928758160 11391692800 1927411488 19.046 99 31 62 1 2002872608 64091184 11369936
20:53:48 17247 8192000000 10902554592 11370930176 1923374736 19.014 99 22 42 1 1980027296 48890464 7762096
20:55:12 37147 8192000000 10876960576 11348115456 1907097360 18.883 100 11 22 1 1955783008 44467456 4218192
20:56:04 64449 8192000000 10868472656 11338821632 1905879200 18.874 99 8 16 1 1941854304 33565008 2410096
20:57:16 130027 8192000000 10893647264 11324530688 1797516512 17.994 92 11 20 0 1812921696 12785952 2619232
20:59:49 57879 8192000000 10864746848 11322490880 1853540304 18.451 95 12 25 0 1869629600 13037328 3051968
21:00:55 64936 8192000000 10874853488 11343208448 1897976736 18.810 98 6 12 0 1913927600 14619104 1331760
21:02:15 127141 8192000000 10861994912 11326869504 1842061168 18.358 95 12 24 0 1853919376 8323600 3534608
21:04:54 43450 8192000000 10886637264 11340488704 1954913296 19.266 100 45 90 2 1973500000 5989264 12597440
21:05:47 97793 8192000000 10895459248 11365457920 1925838448 19.034 98 34 68 1 1944913952 8939968 10135536
21:07:32 56493 8192000000 10898117856 11351703552 1944129296 19.180 99 29 58 1 1964094128 12039824 7925008
21:08:51 59765 8192000000 10912473600 11361796096 1971017152 19.394 100 49 98 1 1992465920 6038016 15410752
21:09:57 947 8192000000 10904796896 11352330240 1961945040 19.321 100 43 82 2 1981793760 7768464 12080256
21:10:05 14129 8192000000 10894197584 11357622272 1963774912 19.336 100 38 76 1 1985563552 10337040 11451600
21:10:26 30371 8192000000 10885843648 11357491200 1945587632 19.191 99 20 39 2 1960825488 9257296 5980560
21:11:03 27794 8192000000 10886118336 11348684800 1939967696 19.146 99 17 31 3 1953316608 8727088 4621824
21:11:41 43221 8192000000 10925226112 11368091648 1964405440 19.341 100 35 69 1 1987297392 12572112 10319840
21:12:44 31466 8192000000 10916798528 11366363136 1955584464 19.271 99 60 120 3 1982693408 9821376 17287568
21:13:22 5683 8192000000 10922746304 11371577344 1973145424 19.410 100 59 118 0 2002051312 12298112 16607776
21:13:40 26591 8192000000 10885418256 11367940096 1967520624 19.366 100 25 50 0 1984603888 9943872 7139392
21:14:16 55309 8192000000 10870656368 11346018304 1934406576 19.102 99 9 18 0 1944656016 7671712 2577728
21:15:18 21109 8192000000 10875216480 11353165824 1953108112 19.251 100 5 10 0 1963960688 9457696 1394880
21:15:48 2709 8192000000 10872982192 11354644480 1954782576 19.265 100 8 16 0 1967222096 10366192 2073328
21:15:57 7112 8192000000 10878074624 11358019584 1957652656 19.287 100 11 22 1 1974089856 13726256 2710944
21:16:14 72019 8192000000 10923810032 11376824320 1970934800 19.393 100 16 31 0 1990448688 15006432 4507456
21:17:42 48800 8192000000 10897574576 11379777536 1969728816 19.383 100 21 42 1 1990469856 14748240 5992800
21:19:02 89340 8192000000 10885678768 11376963584 1970689152 19.391 100 18 36 0 1986989008 11232848 5067008
21:20:43 52529 8192000000 10887261408 11361406976 1935110192 19.108 98 19 38 1 1950567280 10243120 5213968
21:21:54 77081 8192000000 10877100304 11366383616 1902917408 18.850 97 12 24 0 1921331840 14775920 3638512
21:23:19 79410 8192000000 10866864928 11342274560 1869415696 18.580 95 22 41 2 1891978096 14968064 7594336
21:24:45 36148 8192000000 10882016528 11357663232 1941490144 19.159 99 18 35 1 1952749280 6638912 4620224
21:25:28 26768 8192000000 10908125328 11369254912 1967221744 19.363 100 28 55 2 1985504848 10052448 8230656
21:26:09 58479 8192000000 10887083968 11361464320 1929574720 19.063 98 25 50 1 1952354864 15432896 7347248
21:27:14 49126 8192000000 10902591264 11365031936 1935545920 19.111 98 21 43 1 1950931088 9700400 5684768
21:28:10 32790 8192000000 10915485984 11366285312 1966430032 19.357 100 37 74 0 1991504352 14344080 10730240
21:28:51 54673 8192000000 10879388064 11353350144 1890821680 18.752 96 15 30 1 1902815184 8090848 3902656
21:29:52 80039 8192000000 10855023616 11328286720 1835027488 18.300 94 9 18 1 1848949776 11698160 2224128
21:31:18 82952 8192000000 10857236784 11325579264 1805764752 18.061 93 13 26 0 1822672192 13740208 3167232
21:32:47 54401 8192000000 10865408112 11316047872 1830601840 18.264 94 21 42 1 1848175056 11755936 5817280
21:33:49 49887 8192000000 10898563824 11343298560 1935907344 19.114 100 41 83 0 1959598688 11773776 11917568
21:34:48 114364 8192000000 10876184400 11336413184 1924357584 19.022 99 39 78 1 1944712752 9068832 11286336
21:36:49 43185 8192000000 10872718192 11346493440 1949434720 19.222 100 18 36 1 1964437984 10026352 4976912
21:37:50 27110 8192000000 10854087312 11318640640 1894884368 18.785 98 19 39 0 1911309456 10640208 5784880
21:38:23 40590 8192000000 10844565824 11314802688 1890397200 18.749 98 21 41 0 1902572976 6116624 6059152
21:39:12 59683 8192000000 10833337456 11302703104 1864103232 18.537 97 12 24 0 1877605248 10119904 3382112
21:40:17 85712 8192000000 10856518432 11325218816 1883330720 18.692 98 13 25 0 1907355456 20295840 3728896
21:41:49 75363 8192000000 10839441664 11316649984 1838201856 18.326 95 21 42 0 1864249792 19750960 6296976
21:43:21 56223 8192000000 10838586608 11320963072 1892534496 18.766 99 13 26 1 1915664992 19226784 3903712
21:44:23 30522 8192000000 10852835680 11334180864 1917667008 18.968 100 9 18 0 1936259648 15885248 2707392
21:45:09 29785 8192000000 10863136064 11326652416 1912761424 18.929 99 16 32 0 1931058592 14100048 4197120
21:45:47 14262 8192000000 10844943104 11310333952 1891736080 18.760 98 30 58 1 1907709824 7016752 8956992
21:46:13 42136 8192000000 10849645056 11322724352 1886806928 18.720 98 22 44 0 1900784192 8178176 5799088
21:47:01 34435 8192000000 10874876848 11329716224 1908235552 18.892 99 27 51 1 1926957776 11000352 7721872
21:47:43 29743 8192000000 10869762960 11333722112 1939145904 19.140 100 43 86 1 1964232832 13125616 11961312
21:48:23 61746 8192000000 10871902048 11345817600 1917577552 18.967 99 26 52 0 1940031232 14977088 7476592
21:50:52 43095 8192000000 10880027776 11334574080 1899019328 18.818 97 40 79 0 1919382384 10115856 10247200
21:52:15 38134 8192000000 10875401264 11348176896 1905048272 18.867 98 24 48 0 1927087104 15125344 6913488
21:53:04 35735 8192000000 10886868560 11344273408 1914496592 18.943 98 30 57 1 1933425136 11460448 7468096
21:53:50 33414 8192000000 10891193168 11366563840 1960208608 19.308 100 37 75 2 1983190256 12914960 10066688
21:54:34 95100 8192000000 10911904048 11395764224 1968010880 19.370 100 20 40 1 1995885056 22306160 5568016
21:56:16 100260 8192000000 10906320080 11389034496 1976428480 19.436 100 12 24 0 1996746272 17350752 2967040
21:58:32 63193 8192000000 10931101456 11395936256 1994477424 19.579 100 35 70 0 2015900096 11521568 9901104
21:59:41 75106 8192000000 10912593600 11402833920 1972374688 19.404 99 19 38 1 1992271696 14195680 5701328
22:01:03 40828 8192000000 10912439056 11405250560 1974912176 19.424 99 12 24 0 1990514368 12388576 3213616
22:01:50 73789 8192000000 10882978960 11371012096 1910109824 18.908 96 9 18 2 1925006400 12655184 2241392
22:03:10 77761 8192000000 10915919376 11377381376 1924797472 19.025 97 19 39 0 1938180400 7618640 5764288
22:04:37 73438 8192000000 10907723264 11390013440 1941008512 19.155 98 14 28 0 1960203136 14886560 4308064
22:05:57 42591 8192000000 10909002784 11379740672 1974207936 19.419 100 27 54 0 1995792352 13790816 7793600
22:06:45 88934 8192000000 10905632320 11403276288 1958124496 19.291 99 15 30 0 1979428000 16872064 4431440
22:08:24 76173 8192000000 10897268304 11379535872 1946002336 19.195 98 20 40 0 1960726256 9168608 5555312
22:09:47 42006 8192000000 10896924032 11363397632 1921540752 18.999 97 21 42 1 1934879152 7794352 5544048
22:10:35 34904 8192000000 10909436928 11360739328 1911940768 18.922 97 53 106 1 1938124640 10825328 15358544
22:11:21 41062 8192000000 10887183680 11352391680 1918513696 18.975 98 33 66 1 1939313136 11565888 9233552
22:12:14 72530 8192000000 10874383088 11340509184 1861662000 18.517 95 20 41 0 1880308624 13452176 5194448
22:13:33 30122 8192000000 10911402240 11368546304 1942804512 19.169 99 22 43 0 1955896784 7308800 5783472
22:14:10 39053 8192000000 10909371856 11376082944 1950495792 19.230 99 36 72 0 1975725856 15370432 9859632
22:15:00 107366 8192000000 10913598224 11392704512 1940425328 19.150 99 8 16 0 1961066000 18783248 1857424
22:16:55 118414 8192000000 10882169120 11350867968 1902142720 18.844 97 16 32 1 1920571344 13461408 4967216
22:19:04 65776 8192000000 10884163488 11352514560 1911154576 18.916 98 24 48 0 1929581984 11381024 7046384
22:20:17 1892 8192000000 10868962512 11338641408 1930556224 19.071 99 29 58 1 1947602240 9571504 7474512
22:20:41 65868 8192000000 10855812464 11339792384 1890047312 18.746 97 12 23 0 1902816560 9302800 3466448
22:21:53 38650 8192000000 10861143168 11349274624 1943710416 19.176 100 5 10 0 1954883792 9907040 1266336
22:22:43 78429 8192000000 10884242464 11361943552 1924509664 19.023 98 18 36 0 1941243248 11906240 4827344
22:24:07 94074 8192000000 10851382608 11337289728 1893628432 18.775 97 17 34 0 1916991792 18267488 5095872
22:25:48 54819 8192000000 10878200368 11359363072 1916291296 18.957 99 15 29 1 1940574240 19317648 4965296
22:26:57 47668 8192000000 9509567552 9831620608 647751312 7.327 34 8 15 0 659905792 9724816 2429664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-04-2021 22:29:41 to 02-04-2021 22:30:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-04-2021 22:30:13 to 02-04-2021 22:30:15.

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

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