Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.02.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 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 16744728 kB
MemAvailable 31164748 kB
Buffers 0 kB
Cached 14971964 kB
SwapCached 3904 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-19 22:27:21
DTS_END                         2021-02-19 22:27:21.3980
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/44560
TRN_ID                          246171
ATT_ID                          673
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: 9558.50 19869 1147020
customer order: creation 178.39 338 21407
customer order: refuse 14.79 390 1775
order to supplier: creation 47.08 1293 5650
order to supplier: removal 3.61 108774 433
invoice (draft): creation 46.99 3322 5639
invoice (draft): removal 56.05 837 6726
invoice accept: apply 41.85 19000 5022
invoice accept: cancel 50.89 838 6107
customer reserve: creation 3848.58 187 461829
customer reserve: removal 4965.98 61 595917
realization accept: apply 85.23 171 10227
realization accept: cancel 86.77 124 10412
payment from customer: creation 60.33 118 7240
payment from customer: removal 5.83 76 699
payment to supplier: creation 49.99 125 5999
payment to supplier: removal 3.51 81 421
service: total inventory turnovers 4.89 1114 587
service: total monetary turnovers 7.02 34 842
service: aggregate perf. data 0.70 23915 84
service: refresh index statistics 0.03 236583 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2021 22:29:35 to 19-02-2021 22:29:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3070
TEST_TIME 2 3957
TEST_TIME 3 4546
TEST_TIME 4 4922
TEST_TIME 5 4842
TEST_TIME 6 5326
TEST_TIME 7 5308
TEST_TIME 8 5448
TEST_TIME 9 6013
TEST_TIME 10 6191
TEST_TIME 11 6092
TEST_TIME 12 5977
TEST_TIME 13 6177
TEST_TIME 14 6471
TEST_TIME 15 6879
TEST_TIME 16 6902
TEST_TIME 17 6858
TEST_TIME 18 6854
TEST_TIME 19 7056
TEST_TIME 20 7419
TEST_TIME 21 7766
TEST_TIME 22 8385
TEST_TIME 23 8656
TEST_TIME 24 8828
TEST_TIME 25 8933
TEST_TIME 26 9028
TEST_TIME 27 9324
TEST_TIME 28 9532
TEST_TIME 29 10286
TEST_TIME 30 10989
TEST_TIME 31 10906
TEST_TIME 32 11013
TEST_TIME 33 10909
TEST_TIME 34 10762
TEST_TIME 35 10578
TEST_TIME 36 10486
TEST_TIME 37 10620
TEST_TIME 38 10688
TEST_TIME 39 10611
TEST_TIME 40 10496
TEST_TIME 41 10262
TEST_TIME 42 10126
TEST_TIME 43 10235
TEST_TIME 44 10113
TEST_TIME 45 10096
TEST_TIME 46 10071
TEST_TIME 47 9988
TEST_TIME 48 9904
TEST_TIME 49 9978
TEST_TIME 50 9886
TEST_TIME 51 9831
TEST_TIME 52 9733
TEST_TIME 53 9793
TEST_TIME 54 9883
TEST_TIME 55 9792
TEST_TIME 56 9772
TEST_TIME 57 9785
TEST_TIME 58 9730
TEST_TIME 59 9705
TEST_TIME 60 9781
TEST_TIME 61 9942
TEST_TIME 62 9969
TEST_TIME 63 9915
TEST_TIME 64 9988
TEST_TIME 65 10028
TEST_TIME 66 10017
TEST_TIME 67 9975
TEST_TIME 68 10153
TEST_TIME 69 10142
TEST_TIME 70 10078
TEST_TIME 71 9956
TEST_TIME 72 9912
TEST_TIME 73 9895
TEST_TIME 74 9819
TEST_TIME 75 9818
TEST_TIME 76 9792
TEST_TIME 77 9746
TEST_TIME 78 9717
TEST_TIME 79 9632
TEST_TIME 80 9551
TEST_TIME 81 9618
TEST_TIME 82 9644
TEST_TIME 83 9635
TEST_TIME 84 9750
TEST_TIME 85 9727
TEST_TIME 86 9727
TEST_TIME 87 9694
TEST_TIME 88 9745
TEST_TIME 89 9707
TEST_TIME 90 9824
TEST_TIME 91 9800
TEST_TIME 92 9774
TEST_TIME 93 9764
TEST_TIME 94 9828
TEST_TIME 95 9743
TEST_TIME 96 9716
TEST_TIME 97 9693
TEST_TIME 98 9688
TEST_TIME 99 9680
TEST_TIME 100 9634
TEST_TIME 101 9609
TEST_TIME 102 9561
TEST_TIME 103 9565
TEST_TIME 104 9515
TEST_TIME 105 9483
TEST_TIME 106 9476
TEST_TIME 107 9450
TEST_TIME 108 9491
TEST_TIME 109 9522
TEST_TIME 110 9534
TEST_TIME 111 9488
TEST_TIME 112 9527
TEST_TIME 113 9533
TEST_TIME 114 9553
TEST_TIME 115 9605
TEST_TIME 116 9601
TEST_TIME 117 9567
TEST_TIME 118 9652
TEST_TIME 119 9639
TEST_TIME 120 9560

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-02-2021 22:29:39 to 19-02-2021 22:29:42.

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 1576942 1576942 0 0.00 0 21208 7 0 0
doc_list_biud 1576942 1576942 0 0.00 0 58343 29 0 0
sp_add_invoice_to_stock 5150 5022 128 2.48 29 205003 19000 0 128
sp_cancel_adding_invoice 6107 6107 0 0.00 6 79209 838 0 0
sp_cancel_client_order 1775 1775 0 0.00 5 14522 390 0 0
sp_cancel_customer_reserve 595917 595917 0 0.00 1 58345 61 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 4325 76 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 2571 82 0 0
sp_cancel_supplier_invoice 6736 6726 10 0.14 1 21976 838 0 10
sp_cancel_supplier_order 433 433 0 0.00 8 1103475 108774 0 0
sp_cancel_write_off 10412 10412 0 0.00 1 21051 124 0 0
sp_client_order 21407 21407 0 0.00 4 23355 338 0 0
sp_customer_reserve 461829 461829 0 0.00 0 41305 187 0 0
sp_fill_shopping_cart 32683 32683 0 0.00 1 27153 40 0 0
sp_fill_shopping_cart_clo_res 461823 461823 0 0.00 0 17782 12 0 0
sp_get_clo_for_invoice 5016 5016 0 0.00 0 39187 285 0 0
sp_kill_cost_storno 17639 17639 0 0.00 0 9040 59 0 0
sp_kill_qstorno_ret_qs2qd 1209405 1209405 0 0.00 0 58329 33 0 0
sp_kill_qty_storno 636613 636613 0 0.00 0 58343 72 0 0
sp_lock_selected_doc 21191 21191 0 0.00 0 8252 7 0 0
sp_make_cost_storno 28482 28482 0 0.00 0 17259 50 0 0
sp_multiply_rows_for_pdistr 28482 28482 0 0.00 0 7749 32 0 0
sp_multiply_rows_for_qdistr 21407 21407 0 0.00 0 14868 147 0 0
sp_pay_from_customer 7240 7240 0 0.00 4 17789 119 0 0
sp_pay_to_supplier 5999 5999 0 0.00 5 10927 126 0 0
sp_payment_common 13239 13239 0 0.00 2 17777 27 0 0
sp_qd_handle_on_cancel_clo 1775 1775 0 0.00 0 13167 352 0 0
sp_qd_handle_on_invoice_upd_sts 11123 11123 0 0.00 0 38624 376 0 0
sp_qd_handle_on_reserve_upd_sts 10227 10227 0 0.00 0 11796 50 0 0
sp_reserve_write_off 10227 10227 0 0.00 7 11882 172 0 0
sp_supplier_invoice 5639 5639 0 0.00 6 68863 3322 0 0
sp_supplier_order 5650 5650 0 0.00 6 28290 1293 0 0
srv_aggregate_perf_data 84 84 0 0.00 3164 336223 23915 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 1320 144852 29499 0 0
srv_find_qd_qs_mism 1099604 1099604 0 0.00 0 21207 6 0 0
srv_make_invnt_saldo 587 587 0 0.00 47 75040 1114 0 0
srv_make_money_saldo 842 842 0 0.00 1 5106 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 200614 267769 236583 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5022 5022 0 0.00 0 12578 181 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 6188 142 0 0
t$perf-norm:sp_cancel_client_order 1775 1775 0 0.00 0 9648 17 0 0
t$perf-norm:sp_cancel_customer_reserve 723 723 0 0.00 0 2037 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 2897 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 1453 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 1651 15 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 30737 1712 0 0
t$perf-norm:sp_cancel_write_off 1064 1064 0 0.00 0 1753 9 0 0
t$perf-norm:sp_client_order 21407 21407 0 0.00 0 4826 17 0 0
t$perf-norm:sp_customer_reserve 1063 1063 0 0.00 0 2768 9 0 0
t$perf-norm:sp_pay_from_customer 7240 7240 0 0.00 0 8697 16 0 0
t$perf-norm:sp_pay_to_supplier 5999 5999 0 0.00 0 8779 18 0 0
t$perf-norm:sp_reserve_write_off 10227 10227 0 0.00 0 6410 12 0 0
t$perf-norm:sp_supplier_invoice 5639 5639 0 0.00 0 15473 20 0 0
t$perf-norm:sp_supplier_order 5650 5650 0 0.00 0 5736 20 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 298 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 440 13 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 1400 23 0 0
t$perf-norm:srv_make_money_saldo 842 842 0 0.00 0 2177 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10288 10032 256 2.48 0 6071 22 0 256
v_all_customers 38716 38716 0 0.00 0 16 1 0 0
v_all_suppliers 31060 31060 0 0.00 0 21 1 0 0
v_all_wares 42814 42814 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 4723 16 0 0
v_cancel_client_order 3550 3550 0 0.00 0 4441 6 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 1332 4 0 0
v_cancel_customer_reserve 1446 1446 0 0.00 0 2305 7 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 2122 7 0 0
v_cancel_supplier_invoice 836 816 20 2.39 0 2116 21 0 20
v_cancel_supplier_order 866 866 0 0.00 0 1523 6 0 0
v_cancel_write_off 2128 2128 0 0.00 0 3256 18 0 0
v_max_id_clo_ord 5650 5650 0 0.00 0 1062 1 0 0
v_max_id_clo_res 1063 1063 0 0.00 0 6284 18 0 0
v_max_id_ord_sup 5626 5626 0 0.00 0 3806 3 0 0
v_max_non_paid_invoice 1744 1744 0 0.00 0 109 2 0 0
v_max_non_paid_realizn 3967 3967 0 0.00 0 564 3 0 0
v_min_id_clo_ord 5650 5650 0 0.00 0 2777 7 0 0
v_min_id_clo_res 1063 1063 0 0.00 0 5980 7 0 0
v_min_id_ord_sup 5625 5625 0 0.00 0 9585 9 0 0
v_min_non_paid_invoice 5999 5999 0 0.00 0 6711 13 0 0
v_min_non_paid_realizn 7240 7240 0 0.00 0 10679 14 0 0
v_our_firm 10644 10644 0 0.00 0 16 1 0 0
v_reserve_write_off 20454 20454 0 0.00 0 8379 7 0 0
x_lock_depdocs_on_canc_invoice 12425 12425 0 0.00 0 31906 131 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 27585 364 0 0
x_make_qstorno_1000_1200 5650 5650 0 0.00 2 24359 1201 0 0
x_make_qstorno_1200_2000 5639 5639 0 0.00 3 68851 3186 0 0
x_make_qstorno_2100_3300 461829 461829 0 0.00 0 41303 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-02-2021 22:29:43 to 19-02-2021 22:29:47.

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:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:28 8916 8192000000 10165149840 10465312768 694547024 7.815 55 44 90 0 711159616 1948800 14663792
19:57:45 24292 8192000000 10331866064 10647945216 1358062368 14.220 100 83 167 0 1389618720 4067360 27488992
19:58:24 21436 8192000000 10388435520 10711379968 1437265056 14.926 100 86 173 0 1471885840 6360704 28260080
19:58:53 26046 8192000000 10410463280 10737999872 1463452528 15.156 100 92 185 0 1500708224 7380544 29875152
19:59:28 21759 8192000000 10439549168 10770591744 1489492976 15.384 100 92 184 0 1527434448 8780640 29160832
19:59:58 19003 8192000000 10465710912 10799235072 1510450368 15.567 100 93 186 0 1549587024 9710048 29426608
20:00:27 22869 8192000000 10469065760 10809659392 1526547856 15.707 100 92 184 0 1566258256 10615840 29094560
20:01:01 8120 8192000000 10478221136 10822270976 1538408256 15.810 100 81 162 0 1574614048 10984864 25220928
20:01:30 20854 8192000000 10509033824 10856607744 1563300704 16.025 100 79 157 0 1598222064 10788000 24133360
20:02:02 22156 8192000000 10534940432 10887356416 1589692336 16.251 100 85 170 0 1627591872 11879776 26019760
20:02:31 17646 8192000000 10559807248 10919419904 1611882256 16.441 100 83 166 3 1650199040 12175584 26141200
20:02:59 14995 8192000000 10586466224 10946183168 1642557776 16.701 100 78 156 2 1677631872 11977472 23096624
20:03:22 13386 8192000000 10601524592 10966413312 1657641264 16.829 100 87 174 1 1696742608 12898000 26203344
20:03:47 8555 8192000000 10610713488 10981212160 1672631696 16.955 100 80 160 2 1708748896 12756240 23360960
20:04:04 10020 8192000000 10633137344 11004243968 1696141888 17.153 100 89 178 2 1735392192 12756560 26493744
20:04:23 7793 8192000000 10660201232 11030466560 1714514480 17.306 100 83 166 2 1751972544 13155952 24302112
20:04:38 6562 8192000000 10659622992 11039133696 1725846416 17.401 100 71 143 1 1758699472 12509040 20344016
20:04:54 6138 8192000000 10687871280 11063402496 1746601584 17.573 100 82 164 0 1782907872 12527600 23778688
20:05:08 6118 8192000000 10701618592 11078672384 1760435552 17.688 100 78 155 1 1794395456 12093152 21866752
20:05:22 4004 8192000000 10711153056 11090702336 1769461424 17.763 100 76 153 0 1804208704 12698608 22048672
20:05:33 3243 8192000000 10723300112 11104133120 1778326688 17.836 100 85 162 2 1814270656 12554480 23389488
20:05:42 4206 8192000000 10716106352 11097149440 1782171584 17.867 100 82 166 0 1818017488 12525088 23320816
20:05:53 3782 8192000000 10727454704 11112448000 1794260160 17.967 100 76 152 1 1827880080 12704432 20915488
20:06:04 3827 8192000000 10742219744 11125927936 1806415104 18.067 100 86 167 3 1841765200 12562864 22787232
20:06:15 8485 8192000000 10735275392 11128102912 1803917744 18.046 100 73 146 0 1836446080 12765392 19762944
20:06:31 3606 8192000000 10754503440 11143770112 1811069184 18.105 100 84 166 0 1847677024 13244368 23363472
20:06:41 2512 8192000000 10760593616 11150856192 1822825744 18.201 100 68 136 1 1854252032 12443040 18983248
20:06:50 3083 8192000000 10770415088 11153928192 1830441520 18.263 100 86 171 1 1866624768 12466704 23716544
20:07:00 1488 8192000000 10785945776 11168407552 1835969920 18.308 100 91 182 1 1875542416 13697056 25875440
20:07:07 2231 8192000000 10784276432 11169726464 1841550608 18.353 100 91 181 1 1879783392 13802832 24429952
20:07:16 2431 8192000000 10790161760 11173236736 1843611488 18.370 100 90 180 1 1883163760 14514272 25038000
20:07:25 1108 8192000000 10799880352 11185139712 1852406336 18.442 100 92 187 1 1892928816 13793296 26729184
20:07:33 2060 8192000000 10800889008 11190951936 1856346688 18.474 100 90 181 1 1895669568 13374688 25948192
20:07:43 2428 8192000000 10808212848 11197042688 1861954256 18.519 100 90 177 1 1900232432 13544080 24734096
20:07:51 1600 8192000000 10808805824 11202084864 1867300080 18.562 100 87 172 1 1905512880 12820336 25392464
20:07:59 2149 8192000000 10812987200 11204726784 1871147728 18.594 100 88 176 3 1909744352 12977376 25619248
20:08:08 1567 8192000000 10817408896 11205341184 1874867152 18.624 100 92 184 0 1912928160 11776416 26284592
20:08:15 2531 8192000000 10817195008 11210649600 1877527136 18.645 100 91 183 0 1915745120 12681280 25536704
20:08:24 4895 8192000000 10811824864 11215675392 1881708592 18.679 100 88 176 1 1920266176 13166656 25390928
20:08:56 12683 8192000000 10821575696 11217190912 1881535424 18.678 100 74 145 0 1911234176 9156800 20541952
20:09:15 3539 8192000000 10809166784 11220140032 1882759232 18.687 100 58 117 0 1910261568 11771776 15730560
20:09:27 4594 8192000000 10815473184 11223031808 1880466960 18.669 100 58 117 1 1908912240 12505920 15939360
20:09:39 2040 8192000000 10808892896 11221729280 1885411264 18.709 100 64 129 3 1913815808 10710608 17693936
20:09:49 3064 8192000000 10806186144 11218853888 1881128896 18.674 100 47 94 0 1907362880 13219328 13014656
20:09:59 3079 8192000000 10811191008 11216355328 1880027472 18.665 100 39 78 0 1898864080 6981888 11854720
20:10:10 5918 8192000000 10790581536 11219345408 1881870928 18.680 100 35 69 3 1898987952 7062544 10054480
20:10:23 2414 8192000000 10795502592 11222654976 1883787488 18.696 100 37 74 1 1902333616 7753168 10792960
20:10:32 8159 8192000000 10794093792 11224621056 1881027280 18.673 100 23 44 3 1897596160 10323968 6244912
20:10:47 5592 8192000000 10799068608 11225714688 1886288256 18.716 100 26 52 0 1899350768 5452768 7609744
20:10:59 6346 8192000000 10799528736 11230314496 1889069792 18.738 100 31 58 2 1904066544 6708960 8287792
20:11:12 2696 8192000000 10826495872 11234734080 1893504848 18.774 100 38 76 3 1910792352 6532000 10755504
20:11:21 7590 8192000000 10806864000 11239825408 1897424864 18.806 100 35 70 1 1919523440 12383664 9714912
20:11:36 7071 8192000000 10803654800 11240472576 1898647024 18.815 100 28 56 1 1913545744 7092864 7805856
20:11:49 7979 8192000000 10816801728 11243139072 1897263776 18.804 100 21 42 0 1909473744 6532256 5677712
20:12:06 8566 8192000000 10824962624 11249717248 1902388992 18.846 100 35 71 1 1922224944 10365920 9470032
20:12:23 9969 8192000000 10810486672 11247063040 1902405680 18.846 100 26 52 1 1915931408 6560800 6964928
20:12:43 63699 8192000000 10812374080 11250794496 1907239440 18.884 100 37 75 1 1924117936 5805104 11073392
20:13:59 8385 8192000000 10818991424 11256958976 1908059056 18.891 100 27 54 1 1921380752 5958896 7362800
20:14:15 6709 8192000000 10825065584 11262320640 1914085728 18.939 100 42 84 0 1933204112 7631600 11486784
20:14:28 4393 8192000000 10824059040 11259441152 1910832672 18.913 100 25 51 1 1924047808 6069024 7146112
20:14:39 7045 8192000000 10828429632 11262943232 1912825488 18.929 100 28 55 1 1927072640 6533824 7713328
20:14:54 9331 8192000000 10824010752 11261313024 1915770576 18.953 100 30 60 5 1931059600 6023424 9265600
20:15:12 6675 8192000000 10823096224 11257364480 1895393552 18.789 99 25 51 2 1907934976 5365136 7176288
20:15:27 7084 8192000000 10829908032 11264733184 1912861360 18.930 100 29 58 0 1927504832 5268384 9375088
20:15:44 8385 8192000000 10806699664 11241938944 1869074016 18.577 98 22 44 2 1881618288 6125728 6418544
20:15:58 8388 8192000000 10816300432 11254517760 1899417296 18.822 100 28 56 1 1913209680 6269408 7522976
20:16:13 5959 8192000000 10803498384 11237781504 1865086272 18.544 98 35 69 2 1881988496 6626768 10275456
20:16:27 7606 8192000000 10809498208 11245981696 1897757088 18.808 100 29 56 2 1916033216 10265840 8010288
20:16:41 5011 8192000000 10803685920 11231387648 1858094352 18.488 98 32 62 2 1873135040 6398144 8642544
20:16:52 8271 8192000000 10784451840 11212103680 1850631792 18.427 98 23 44 4 1863189936 6444048 6114096
20:17:07 18948 8192000000 10754932912 11182108672 1753265968 17.629 93 29 59 1 1766433984 4872000 8296016
20:17:32 64325 8192000000 10744470688 11174936576 1701719520 17.199 91 26 52 2 1715091888 5923520 7448848
20:18:43 6220 8192000000 10765442768 11190652928 1834982688 18.300 99 28 56 4 1849492160 6420704 8088768
20:18:55 6445 8192000000 10763246832 11179278336 1836640016 18.313 100 25 50 1 1849876640 5874976 7361648
20:19:08 7052 8192000000 10745330560 11174240256 1814894224 18.136 99 26 52 1 1828259888 6355952 7009712
20:19:23 5688 8192000000 10738248080 11156258816 1794142208 17.966 98 35 70 0 1811614448 7664816 9807424
20:19:35 6753 8192000000 10697520912 11121078272 1754867360 17.642 97 30 61 4 1768797120 5625440 8304320
20:19:51 5552 8192000000 10676801552 11100688384 1725251152 17.396 96 33 66 2 1743988304 9809232 8927920
20:20:04 9173 8192000000 10695224736 11109335040 1732467152 17.456 96 23 46 0 1743981552 5268224 6246176
20:20:19 9964 8192000000 10717573376 11137372160 1758475760 17.672 97 17 32 1 1768530832 5418496 4636576
20:20:37 7351 8192000000 10684073632 11099320320 1692019232 17.118 94 19 38 1 1707380752 9263616 6097904
20:20:53 8162 8192000000 10682202560 11094208512 1729643984 17.433 97 25 49 0 1742703680 5961488 7098208
20:21:10 6246 8192000000 10704416144 11119644672 1779093568 17.842 99 35 69 3 1796114624 6158352 10862704
20:21:22 10188 8192000000 10711136144 11133390848 1805474864 18.059 100 33 66 0 1821120096 5789296 9855936
20:21:41 7185 8192000000 10725713440 11147710464 1816213376 18.147 100 25 50 1 1829894544 6335328 7345840
20:22:01 74531 8192000000 10732602272 11162566656 1815773488 18.143 99 26 51 3 1828446352 4891520 7781344
20:23:22 11318 8192000000 10746453552 11173134336 1824409392 18.214 99 36 71 3 1840963792 7033136 9521264
20:23:40 6336 8192000000 10744493248 11169902592 1833360320 18.287 100 34 68 1 1849811584 7315520 9135744
20:23:52 4923 8192000000 10757146720 11184279552 1843110096 18.366 100 23 46 0 1859741616 10473328 6158192
20:24:03 8953 8192000000 10775092864 11189534720 1847950064 18.405 100 31 62 1 1862730048 5588608 9191376
20:24:23 4375 8192000000 10775633696 11191705600 1853497696 18.451 100 43 86 0 1873627648 8045472 12084480
20:24:35 6620 8192000000 10791941424 11203563520 1860660096 18.509 100 44 88 2 1880473008 7219824 12593088
20:24:49 12469 8192000000 10767071024 11199651840 1858846992 18.494 100 28 56 0 1872477248 5138960 8491296
20:25:08 7619 8192000000 10778484032 11203022848 1862991392 18.528 100 22 44 1 1874557712 5728416 5837904
20:25:23 10008 8192000000 10772934288 11203473408 1866885680 18.559 100 29 59 3 1881492480 5683344 8923456
20:25:44 9339 8192000000 10782722896 11209756672 1865627472 18.549 100 21 40 1 1877046752 5463600 5955680
20:26:00 8889 8192000000 10793642496 11214856192 1866162016 18.553 100 19 34 3 1880012288 9253664 4596608
20:26:15 9498 8192000000 10788967824 11214761984 1868946672 18.576 100 22 44 1 1881524256 6224032 6353552
20:26:32 7832 8192000000 10778690224 11212566528 1867813424 18.567 100 15 30 2 1878066208 5699808 4552976
20:26:50 112460 8192000000 10822006368 11243642880 1884502656 18.701 100 31 62 0 1898121232 5637280 7981296
20:28:50 12640 8192000000 10837010752 11258265600 1912032256 18.923 100 46 92 0 1933471280 8168880 13270144
20:29:11 10927 8192000000 10849356512 11273154560 1921213744 18.997 100 50 100 0 1944818448 9048016 14556688
20:29:28 6734 8192000000 10861866672 11279147008 1926111696 19.036 100 57 111 4 1950668512 8551840 16004976
20:29:43 9839 8192000000 10848212768 11272962048 1924060272 19.019 100 49 98 1 1946554464 9262656 13231536
20:30:00 43632 8192000000 10868306144 11298643968 1933771072 19.097 100 53 106 0 1962868128 14661072 14435984
20:30:56 32463 8192000000 10860154512 11297517568 1919835040 18.986 99 33 66 4 1937746736 8839184 9072512
20:31:37 4039 8192000000 10889285712 11308658688 1946354608 19.197 100 57 116 1 1972879328 9365952 17158768
20:31:48 6125 8192000000 10884199216 11312787456 1935548272 19.111 99 60 120 3 1972201440 19740592 16912576
20:32:00 8773 8192000000 10885500336 11312947200 1952313456 19.245 100 56 112 1 1980983024 12315712 16353856
20:32:17 3039 8192000000 10897943072 11317194752 1952510672 19.246 100 67 134 1 1984484096 13276560 18696864
20:32:27 1907 8192000000 10902158448 11315724288 1941142752 19.156 99 79 156 1 1977933728 14362848 22428128
20:32:36 23090 8192000000 10896792448 11320565760 1954424368 19.262 100 58 116 1 1986082016 15224720 16432928
20:33:06 2461 8192000000 10900067632 11323863040 1957986752 19.290 100 54 109 0 1988748032 15035056 15726224
20:33:20 10589 8192000000 10902329776 11330469888 1962440096 19.325 100 52 104 1 1992648912 14522816 15686000
20:33:40 7946 8192000000 10885069152 11308290048 1943050784 19.171 99 55 110 0 1973085008 13929360 16104864
20:33:59 9564 8192000000 10895226736 11322793984 1956909488 19.281 100 49 97 0 1985338688 14842352 13586848
20:34:16 9208 8192000000 10907057120 11333160960 1968397824 19.373 100 70 141 1 2008804384 20001408 20405152
20:34:33 5766 8192000000 10907081744 11333017600 1952179520 19.244 99 61 120 4 1985415552 15521520 17714512
20:34:46 8189 8192000000 10931730800 11344396288 1972614384 19.406 100 67 133 5 2008995280 17029664 19351232
20:35:02 2280 8192000000 10927231664 11350052864 1973966144 19.417 100 72 141 3 2011541120 17403728 20171248
20:35:12 22037 8192000000 10924280880 11352920064 1973949200 19.417 100 59 114 0 2007317328 16941392 16426736
20:35:43 12900 8192000000 10909575712 11338702848 1961899072 19.321 99 56 110 2 1997617056 19079920 16638064
20:36:11 8286 8192000000 10922794192 11353436160 1976969344 19.441 100 71 139 0 2016933120 19379776 20584000
20:36:32 10980 8192000000 10913293728 11347521536 1959074048 19.299 99 51 103 2 1992789600 18394064 15321488
20:36:51 5228 8192000000 10918606480 11348480000 1952068128 19.243 99 51 102 2 1986599472 18587200 15944144
20:37:03 7129 8192000000 10922068736 11347976192 1956823232 19.281 99 55 110 1 1992283264 18405408 17054624
20:37:19 8749 8192000000 10918620592 11350937600 1977112480 19.442 100 59 118 2 2013835952 18401072 18322400
20:37:35 8025 8192000000 10923986336 11353739264 1976538464 19.437 100 72 141 2 2020987648 22258864 22190320
20:37:54 4557 8192000000 10913916928 11336507392 1957339312 19.285 100 62 121 0 1996381184 20902592 18139280
20:38:08 14932 8192000000 10915798912 11341320192 1951851968 19.241 99 59 118 0 1992239808 22791952 17595888
20:38:33 7928 8192000000 10927557936 11356614656 1973711984 19.415 100 54 108 1 2013695936 23146064 16837888
20:38:50 7131 8192000000 10922281568 11350155264 1974100608 19.418 100 58 116 2 2015120352 22994240 18025504
20:39:05 3206 8192000000 10950811248 11364990976 1983432912 19.492 100 65 129 2 2028223504 25399952 19390640
20:39:17 3913 8192000000 10947673280 11368665088 1974207808 19.419 99 72 144 0 2021284384 24606784 22469792
20:39:27 8016 8192000000 10942836496 11369791488 1988219072 19.530 100 63 123 0 2032064256 24935808 18909376
20:39:43 3831 8192000000 10952190176 11361574912 1980067248 19.465 100 80 159 0 2035642832 31320240 24255344
20:39:54 2347 8192000000 10957103568 11368742912 1982256000 19.483 100 86 170 2 2041489840 33238176 25995664
20:40:11 9029 8192000000 10948167424 11373264896 1985688720 19.510 100 69 137 0 2042915104 35614400 21611984
20:40:28 7915 8192000000 10937452432 11362775040 1941113088 19.156 98 65 130 0 1996899728 35561952 20224688
20:40:43 5434 8192000000 10931952144 11352788992 1948802256 19.217 99 58 117 1 2004424208 36110720 19511232
20:40:56 5493 8192000000 10938941392 11365728256 1977692752 19.446 100 72 145 0 2034567808 34157616 22717440
20:41:08 3988 8192000000 10939859616 11352453120 1944876272 19.186 99 78 154 1 2003826128 34802960 24146896
20:41:20 2780 8192000000 10930681296 11341963264 1946355200 19.197 99 76 155 0 2002789280 32413728 24020352
20:41:33 10212 8192000000 10929711696 11353120768 1968855728 19.376 100 72 145 1 2022120944 31152976 22112240
20:41:56 6392 8192000000 10921287056 11342524416 1953941664 19.258 99 65 130 0 2010019488 35401216 20676608
20:42:11 4232 8192000000 10945888400 11367038976 1973836800 19.416 100 70 140 0 2029467744 33762752 21868192
20:42:23 3674 8192000000 10953748064 11380625408 1988111024 19.529 100 76 148 0 2044859664 33869600 22879040
20:42:36 6459 8192000000 10951451760 11377848320 1982713152 19.486 100 61 122 1 2034105552 32432752 18959648
20:42:50 1676 8192000000 10954674832 11372478464 1982642976 19.486 100 75 151 2 2038973664 32881344 23449344
20:42:58 4759 8192000000 10957241616 11372961792 1968664112 19.375 99 80 157 1 2027387520 34046800 24676608
20:43:10 5170 8192000000 10929292464 11345563648 1941882976 19.162 98 78 155 1 2001283728 35022048 24378704
20:43:24 3719 8192000000 10959232480 11377389568 1982352768 19.483 100 84 170 3 2046551776 38812192 25386816
20:43:35 4350 8192000000 10934332768 11347996672 1953919168 19.258 99 80 158 3 2020810240 41781504 25109568
20:43:48 4994 8192000000 10937715600 11356033024 1950049856 19.227 99 68 134 1 2010521280 38713248 21758176
20:44:00 3943 8192000000 10941950864 11354394624 1962923104 19.329 100 71 142 1 2023178464 38055536 22199824
20:44:11 3195 8192000000 10947936080 11355312128 1948255792 19.213 99 84 168 0 2012727104 38805776 25665536
20:44:22 4414 8192000000 10936463984 11344621568 1946756704 19.201 99 81 161 0 2012209888 40228704 25224480
20:44:37 1449 8192000000 10950922864 11361550336 1968142416 19.371 100 79 158 4 2034336144 41394112 24799616
20:44:46 3210 8192000000 10971679728 11385421824 1981103216 19.473 100 83 166 1 2052111872 44496064 26512592
20:44:58 2077 8192000000 10971156464 11380801536 1976670896 19.438 100 87 174 1 2048960064 45149664 27139504
20:45:08 1426 8192000000 10979215680 11386126336 1981791408 19.479 100 93 185 2 2057947936 46239248 29917280
20:45:17 4502 8192000000 10975949968 11387252736 1982868816 19.487 100 85 170 1 2057980368 47929584 27181968
20:45:27 1808 8192000000 10982706944 11393261568 1984984512 19.504 100 90 179 2 2062408368 48349040 29074816
20:45:36 2449 8192000000 10982732832 11394228224 1987533008 19.524 100 84 168 2 2062974176 49201632 26239536
20:45:47 4202 8192000000 10995010192 11402731520 1991049904 19.552 100 84 168 1 2068322560 50864272 26408384
20:46:07 4287 8192000000 10987163568 11402063872 1988586464 19.533 100 81 162 2 2067394288 52971616 25836208
20:46:25 2732 8192000000 10974403904 11377016832 1968800336 19.376 100 90 174 0 2050744112 53903376 28040400
20:46:36 2109 8192000000 10983415904 11386777600 1973658720 19.414 100 84 166 0 2053824128 54000016 26165392
20:46:45 1318 8192000000 10960715424 11373465600 1960077120 19.307 99 86 172 0 2044003200 55493664 28432416
20:46:55 4310 8192000000 10981337008 11399708672 1983653120 19.494 100 74 148 0 2063993536 55968848 24371568
20:47:07 3556 8192000000 10967532224 11378053120 1953772144 19.257 99 79 157 0 2036045168 56743104 25529920
20:47:17 1796 8192000000 10963729072 11367145472 1961895488 19.321 100 91 182 0 2044756992 54182096 28679408
20:47:27 2404 8192000000 10961558912 11367739392 1947489360 19.206 99 85 169 0 2029863296 55693760 26680176
20:47:37 3093 8192000000 10974191952 11384840192 1971477136 19.397 100 89 178 0 2056443344 56259424 28706784
20:47:47 5778 8192000000 10964031392 11381596160 1972885744 19.408 100 74 147 1 2051671824 54847568 23938512
20:48:00 3040 8192000000 10969963088 11378876416 1961541680 19.318 100 80 160 1 2042629984 55527184 25561120
20:48:12 4113 8192000000 10940001856 11359367168 1938030544 19.131 99 77 153 1 2021202928 58529120 24643264
20:48:23 7778 8192000000 10929823808 11360505856 1953331536 19.253 100 49 98 1 2020208400 50651760 16225104
20:48:49 9867 8192000000 10928474080 11360632832 1932777792 19.089 99 46 92 1 2005650192 57004016 15868384
20:49:06 4233 8192000000 10953394928 11372806144 1956302176 19.277 100 51 101 0 2028046816 54524704 17219936
20:49:20 18722 8192000000 10940030320 11378614272 1956527088 19.278 100 40 80 3 2026491456 55612080 14352288
20:49:47 8266 8192000000 10939877040 11377360896 1960149024 19.307 100 39 78 0 2024062480 50257072 13656384
20:50:09 13760 8192000000 10935260672 11381624832 1961929536 19.321 100 36 72 3 2026337456 52348752 12059168
20:50:45 5243 8192000000 10936809264 11374288896 1956473312 19.278 100 31 62 1 2015966720 47769840 11723568
20:51:05 10995 8192000000 10921800912 11359498240 1934764928 19.105 99 32 64 1 1995718800 50110368 10843504
20:51:41 18060 8192000000 10931314976 11368202240 1936258000 19.117 99 31 62 1 1994290768 47931792 10100976
20:52:23 7881 8192000000 10917306160 11351154688 1932438240 19.086 100 35 65 1 1996938880 53767936 10732704
20:52:38 5742 8192000000 10932751840 11361243136 1939287312 19.141 100 43 85 0 2009726400 56325872 14113216
20:52:51 10411 8192000000 10929851008 11375169536 1942111744 19.164 100 41 81 2 2016486928 60492352 13882832
20:53:13 14402 8192000000 10934703024 11372105728 1945737488 19.193 100 34 68 0 2013328496 55181504 12409504
20:53:34 18979 8192000000 10919019264 11364175872 1927609024 19.048 99 29 58 3 1995084304 57063744 10411536
20:54:12 23746 8192000000 10912209808 11357696000 1929662752 19.064 100 29 58 1 2005555872 65176160 10716960
20:54:43 20780 8192000000 10911009840 11365011456 1925980432 19.035 100 24 48 3 1998423536 63004720 9438384
20:55:11 15597 8192000000 10908834112 11350003712 1912577664 18.927 99 32 64 1 1983120576 58222864 12320048
20:55:49 13874 8192000000 10915980304 11365027840 1928485376 19.055 100 23 46 1 1992608352 55407344 8715632
20:56:31 26423 8192000000 10865400016 11330105344 1894378000 18.781 98 25 50 1 1940973200 38120880 8474320
20:57:41 82016 8192000000 10880702976 11335737344 1917586016 18.967 99 12 24 0 1939346192 18408320 3351856
20:59:26 122728 8192000000 10879877568 11339145216 1863920032 18.535 95 15 31 0 1879651024 11959920 3771072
21:01:35 78314 8192000000 10914254080 11361689600 1935025264 19.107 99 26 51 2 1948928032 6936672 6966096
21:03:19 96635 8192000000 10917899168 11381915648 1969839616 19.384 100 19 38 1 1994973056 19787568 5345872
21:05:05 105673 8192000000 10900341632 11370622976 1956441952 19.278 99 7 14 0 1972833536 14575280 1816304
21:07:07 119149 8192000000 10933321760 11384754176 1985756048 19.510 100 26 52 0 2001011920 8096768 7159104
21:09:12 96948 8192000000 10933949120 11397701632 1969491712 19.381 99 29 58 3 1992675056 14553120 8630224
21:10:55 56096 8192000000 10935443504 11400364032 1995355520 19.586 100 39 78 1 2020948144 14742800 10849824
21:12:01 32596 8192000000 10915815072 11389849600 1971122784 19.394 99 13 25 0 1986318960 11531648 3664528
21:12:40 15263 8192000000 10927895200 11395747840 1988422368 19.531 100 24 45 2 2005197376 10107120 6667888
21:13:02 22259 8192000000 10918680816 11391283200 1993418848 19.571 100 12 24 0 2006615824 9719504 3477472
21:13:32 38193 8192000000 10931388560 11399217152 1997520000 19.603 100 30 57 4 2013733568 7832208 8381360
21:14:18 18559 8192000000 10930272512 11390910464 1992608288 19.564 100 29 58 1 2010289872 9445856 8235728
21:15:12 44508 8192000000 10941457776 11399561216 1977113712 19.442 99 40 78 2 2003643984 14671792 11858480
21:16:21 6621 8192000000 10940108144 11409760256 1993162368 19.569 100 31 59 3 2016532224 13875504 9494352
21:16:35 19828 8192000000 10918380992 11386253312 1982843344 19.487 99 34 68 0 2010155424 17447616 9864464
21:17:02 63974 8192000000 10933508032 11405672448 1976546736 19.437 99 27 54 2 2000263424 16361104 7355584
21:19:09 79840 8192000000 10910952432 11394510848 1916478048 18.959 96 17 34 0 1947453984 25723472 5252464
21:20:39 66085 8192000000 10873617760 11353714688 1894075424 18.779 96 14 28 1 1921898736 23534960 4288352
21:22:01 26925 8192000000 10860095424 11324690432 1920861328 18.994 98 19 40 0 1937736176 11751216 5123632
21:23:31 46498 8192000000 10880092096 11362123776 1917056480 18.963 98 6 12 0 1931409200 12856672 1496048
21:24:23 26252 8192000000 10879688032 11342127104 1913975328 18.939 98 18 36 3 1928548704 9595856 4977520
21:24:58 25486 8192000000 10902823488 11363299328 1964563408 19.342 100 39 78 1 1986509792 10657424 11288960
21:25:32 40323 8192000000 10892804288 11370065920 1964169824 19.339 100 19 38 1 1983300736 13856448 5274464
21:26:18 45996 8192000000 10911511296 11380465664 1938339104 19.134 98 26 52 1 1961917360 16048992 7529264
21:27:52 92513 8192000000 10868768720 11345555456 1864819984 18.542 95 8 16 1 1888676848 21932848 1924016
21:29:30 64529 8192000000 10870757520 11343380480 1874372272 18.620 96 16 32 1 1894418928 15900272 4146384
21:30:41 66402 8192000000 10857725776 11327184896 1843826496 18.372 95 17 35 2 1863981712 15118576 5036640
21:31:59 48017 8192000000 10845661952 11318046720 1900150608 18.828 99 9 18 0 1913759136 11110336 2498192
21:32:53 37922 8192000000 10902237760 11341459456 1892609024 18.767 97 40 81 1 1915427152 11702016 11116112
21:33:45 25921 8192000000 10894606928 11355246592 1949053520 19.219 100 35 70 2 1975543008 16682736 9806752
21:34:18 36989 8192000000 10902411920 11367649280 1952662256 19.248 100 29 58 2 1982546208 21423408 8460544
21:35:01 73057 8192000000 10877329456 11367505920 1909782064 18.905 98 11 22 0 1936222176 23402240 3037872
21:36:22 16230 8192000000 10865293600 11322900480 1924271616 19.021 99 16 32 1 1936801616 8483568 4046432
21:37:37 88907 8192000000 10858847472 11317264384 1875187664 18.626 96 33 66 0 1890949936 6707088 9055184
21:39:12 90970 8192000000 10842013600 11310809088 1843440032 18.369 95 31 62 0 1863100960 11333712 8327216
21:40:59 33139 8192000000 10847476000 11297820672 1881507440 18.677 98 46 89 1 1903075744 8510592 13057712
21:41:42 8841 8192000000 10859936224 11312218112 1922231952 19.005 100 47 94 0 1945331632 10248848 12850832
21:41:57 30644 8192000000 10858143776 11327700992 1935389376 19.110 100 42 83 2 1957061328 9610880 12061072
21:42:49 83898 8192000000 10869749392 11342684160 1884152880 18.699 97 12 24 0 1898373936 10917792 3303264
21:44:20 38694 8192000000 10862679680 11336658944 1907500816 18.887 98 20 40 1 1926934976 13128160 6306000
21:45:08 73496 8192000000 10856712112 11336843264 1897231072 18.804 98 13 26 0 1915994496 14694512 4068912
21:46:28 69189 8192000000 10850644176 11326316544 1911227568 18.917 99 17 34 0 1932071056 15431552 5411936
21:48:12 52749 8192000000 10840396688 11331743744 1912567216 18.927 99 25 51 2 1944788016 23680992 8539808
21:49:13 77394 8192000000 10873351232 11339923456 1880436832 18.669 97 19 38 1 1900538320 14711728 5389760
21:50:37 68629 8192000000 10871314016 11369893888 1942067104 19.163 100 14 28 1 1962704544 16527488 4109952
21:51:53 24824 8192000000 10886016128 11351658496 1927861632 19.050 99 42 83 0 1953147872 13540992 11745248
21:52:28 23030 8192000000 10861514240 11326218240 1904166784 18.860 98 39 78 2 1924153808 9450176 10536848
21:52:58 28776 8192000000 10887896000 11346759680 1943438640 19.174 100 46 92 1 1966252544 10085664 12728240
21:53:40 63189 8192000000 10885218800 11360907264 1948072384 19.211 100 21 43 0 1965678032 11669232 5936416
21:54:50 39700 8192000000 10901856752 11368407040 1961588800 19.319 100 33 66 2 1983493568 11902496 10002272
21:55:48 28677 8192000000 10900178640 11374927872 1965740832 19.352 100 18 36 3 1980894560 10095248 5058480
21:56:23 37082 8192000000 10907508656 11372294144 1936089664 19.116 98 32 64 2 1955483216 10547360 8846192
21:57:06 108814 8192000000 10898896704 11376254976 1962157344 19.323 100 11 22 1 1978699696 13954656 2587696
21:59:11 24380 8192000000 10915171024 11377545216 1957696016 19.288 99 22 44 0 1970768336 7350592 5721728
21:59:42 27932 8192000000 10906931504 11372765184 1958844480 19.297 99 40 80 1 1981484464 11566944 11073040
22:00:16 13152 8192000000 10923345328 11380019200 1972034928 19.402 100 39 78 0 1990788416 7381952 11371536
22:00:39 26762 8192000000 10934641376 11396603904 1988583920 19.533 100 29 57 1 2006877936 10285392 8008624
22:01:13 144852 8192000000 10909492336 11386179584 1953069248 19.251 98 19 38 0 1970741232 11963264 5708720
22:04:00 99611 8192000000 10922419328 11413479424 1996927728 19.598 100 35 70 1 2019412480 12274848 10209904
22:05:45 52128 8192000000 10902486272 11383885824 1969526208 19.382 99 9 18 0 1984418864 12267248 2625408
22:06:49 48525 8192000000 10903621936 11397087232 1988324704 19.531 100 7 14 0 1999342864 8883472 2134688
22:07:46 47933 8192000000 10910637024 11395309568 1988456528 19.532 100 11 21 0 1999784784 8571536 2756720
22:08:52 48824 8192000000 10859518064 11336966144 1918494656 18.975 97 12 22 1 1930220048 8440432 3284960
22:09:50 66940 8192000000 10883464480 11375140864 1950062944 19.227 99 18 37 1 1967618656 12365216 5190496
22:11:08 36656 8192000000 10894770912 11386466304 1967293120 19.364 100 9 18 0 1983522688 13565440 2664128
22:11:57 56894 8192000000 10866635856 11361226752 1905896208 18.874 97 10 20 0 1921251808 12474272 2881328
22:13:13 72561 8192000000 10866899792 11335688192 1848162288 18.407 95 7 14 1 1864279008 14473520 1643200
22:14:39 50313 8192000000 10868933776 11347968000 1918401776 18.974 99 29 58 1 1943013024 16129360 8481888
22:15:35 65386 8192000000 10869734640 11341107200 1874643824 18.622 96 15 28 2 1886382144 7732896 4005424
22:16:51 76872 8192000000 10880005136 11356446720 1888018016 18.730 97 15 30 0 1906787808 14875904 3893888
22:18:22 71688 8192000000 10853573136 11334881280 1853631968 18.452 95 26 52 1 1873688096 12648928 7407200
22:19:40 52971 8192000000 10854662592 11314257920 1833057264 18.284 95 20 40 2 1852389872 12938720 6393888
22:20:39 49054 8192000000 10862019472 11336515584 1872872784 18.608 97 23 45 3 1889421760 9767024 6781952
22:22:06 38931 8192000000 10861777504 11335405568 1888154032 18.731 98 16 33 1 1908377184 15823568 4399584
22:22:55 25737 8192000000 10845544048 11331641344 1884521920 18.702 98 20 40 2 1903565920 13358144 5685856
22:23:32 44293 8192000000 10868613056 11331366912 1911732192 18.921 99 22 44 0 1928322304 10246784 6343328
22:24:27 22176 8192000000 10902094928 11356307456 1950327488 19.229 100 46 91 1 1975656848 11690976 13638384
22:25:41 130882 8192000000 9508129248 9826701312 609653904 6.926 32 10 20 1 616692720 4320976 2717840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 19-02-2021 22:29:49 to 19-02-2021 22:30:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-02-2021 22:30:23 to 19-02-2021 22:30:25.

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          246040
MON$OLDEST_ACTIVE               246494
MON$OLDEST_SNAPSHOT             246494
MON$NEXT_TRANSACTION            246494
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                       2064864
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:32: 
:33: mscs-test-161.budzdorov.ru    Fri Feb 19 22:28:01 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Fri Feb 19 22:28:02 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Fri Feb 19 22:28:05 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
--- end of diff output ---

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

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