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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16979140 kB
MemAvailable 31205572 kB
Buffers 0 kB
Cached 14687528 kB
SwapCached 4876 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-04 22:27:12
DTS_END                         2021-02-04 22:27:12.3050
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/37986
TRN_ID                          250330
ATT_ID                          731
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: 9562.49 25843 1147499
customer order: creation 180.88 322 21705
customer order: refuse 15.67 343 1880
order to supplier: creation 49.28 1228 5914
order to supplier: removal 3.64 91149 437
invoice (draft): creation 48.31 3251 5797
invoice (draft): removal 51.22 777 6146
invoice accept: apply 45.44 17556 5453
invoice accept: cancel 46.63 885 5596
customer reserve: creation 4197.53 172 503704
customer reserve: removal 4621.38 57 554565
realization accept: apply 89.51 162 10741
realization accept: cancel 73.86 103 8863
payment from customer: creation 64.82 104 7778
payment from customer: removal 6.18 125 741
payment to supplier: creation 51.48 113 6177
payment to supplier: removal 3.68 72 442
service: total inventory turnovers 5.06 1053 607
service: total monetary turnovers 7.09 27 851
service: aggregate perf. data 0.82 24274 98
service: refresh index statistics 0.03 375082 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 04-02-2021 22:28:22 to 04-02-2021 22:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3967
TEST_TIME 2 3672
TEST_TIME 3 4081
TEST_TIME 4 4440
TEST_TIME 5 5004
TEST_TIME 6 4916
TEST_TIME 7 5061
TEST_TIME 8 5368
TEST_TIME 9 5678
TEST_TIME 10 6233
TEST_TIME 11 6265
TEST_TIME 12 6554
TEST_TIME 13 6609
TEST_TIME 14 7224
TEST_TIME 15 7377
TEST_TIME 16 7769
TEST_TIME 17 8284
TEST_TIME 18 8724
TEST_TIME 19 9098
TEST_TIME 20 9165
TEST_TIME 21 9252
TEST_TIME 22 9302
TEST_TIME 23 9825
TEST_TIME 24 9711
TEST_TIME 25 9848
TEST_TIME 26 9789
TEST_TIME 27 10862
TEST_TIME 28 11143
TEST_TIME 29 11328
TEST_TIME 30 11065
TEST_TIME 31 10990
TEST_TIME 32 10943
TEST_TIME 33 10688
TEST_TIME 34 10733
TEST_TIME 35 10658
TEST_TIME 36 10754
TEST_TIME 37 10659
TEST_TIME 38 10549
TEST_TIME 39 10485
TEST_TIME 40 10400
TEST_TIME 41 10437
TEST_TIME 42 10325
TEST_TIME 43 10380
TEST_TIME 44 10311
TEST_TIME 45 10200
TEST_TIME 46 10166
TEST_TIME 47 10106
TEST_TIME 48 10144
TEST_TIME 49 10148
TEST_TIME 50 10113
TEST_TIME 51 10138
TEST_TIME 52 10160
TEST_TIME 53 10204
TEST_TIME 54 10226
TEST_TIME 55 10198
TEST_TIME 56 10268
TEST_TIME 57 10282
TEST_TIME 58 10220
TEST_TIME 59 10329
TEST_TIME 60 10341
TEST_TIME 61 10322
TEST_TIME 62 10181
TEST_TIME 63 10116
TEST_TIME 64 10087
TEST_TIME 65 10017
TEST_TIME 66 9959
TEST_TIME 67 9862
TEST_TIME 68 9843
TEST_TIME 69 9932
TEST_TIME 70 9976
TEST_TIME 71 9993
TEST_TIME 72 9947
TEST_TIME 73 9988
TEST_TIME 74 10014
TEST_TIME 75 9975
TEST_TIME 76 10065
TEST_TIME 77 10041
TEST_TIME 78 10107
TEST_TIME 79 10045
TEST_TIME 80 10098
TEST_TIME 81 10104
TEST_TIME 82 9996
TEST_TIME 83 10005
TEST_TIME 84 9921
TEST_TIME 85 9882
TEST_TIME 86 9883
TEST_TIME 87 9875
TEST_TIME 88 9840
TEST_TIME 89 9779
TEST_TIME 90 9728
TEST_TIME 91 9676
TEST_TIME 92 9665
TEST_TIME 93 9659
TEST_TIME 94 9633
TEST_TIME 95 9642
TEST_TIME 96 9662
TEST_TIME 97 9727
TEST_TIME 98 9720
TEST_TIME 99 9714
TEST_TIME 100 9726
TEST_TIME 101 9762
TEST_TIME 102 9743
TEST_TIME 103 9801
TEST_TIME 104 9795
TEST_TIME 105 9819
TEST_TIME 106 9836
TEST_TIME 107 9882
TEST_TIME 108 9832
TEST_TIME 109 9777
TEST_TIME 110 9739
TEST_TIME 111 9706
TEST_TIME 112 9734
TEST_TIME 113 9684
TEST_TIME 114 9635
TEST_TIME 115 9649
TEST_TIME 116 9624
TEST_TIME 117 9613
TEST_TIME 118 9595
TEST_TIME 119 9624
TEST_TIME 120 9568

Performance per minute, chart


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

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 1612541 1612541 0 0.00 0 16518 6 0 0
doc_list_biud 1612540 1612540 0 0.00 0 26261 25 0 0
sp_add_invoice_to_stock 5616 5453 163 2.90 39 181660 17557 0 163
sp_cancel_adding_invoice 5596 5596 0 0.00 5 66697 886 0 0
sp_cancel_client_order 1880 1880 0 0.00 4 14744 343 0 0
sp_cancel_customer_reserve 554565 554565 0 0.00 1 22376 57 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 3 12533 126 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 3 1167 73 0 0
sp_cancel_supplier_invoice 6154 6146 8 0.12 2 17421 778 0 8
sp_cancel_supplier_order 437 437 0 0.00 6 1274563 91150 0 0
sp_cancel_write_off 8863 8863 0 0.00 1 16905 103 0 0
sp_client_order 21705 21705 0 0.00 3 11908 322 0 0
sp_customer_reserve 503704 503704 0 0.00 0 158705 173 0 0
sp_fill_shopping_cart 33412 33412 0 0.00 1 13852 37 0 0
sp_fill_shopping_cart_clo_res 503683 503683 0 0.00 0 17088 13 0 0
sp_get_clo_for_invoice 5432 5432 0 0.00 0 31324 299 0 0
sp_kill_cost_storno 15642 15642 0 0.00 0 12227 56 0 0
sp_kill_qstorno_ret_qs2qd 1124576 1124576 0 0.00 0 22356 31 0 0
sp_kill_qty_storno 593660 593660 0 0.00 0 26248 68 0 0
sp_lock_selected_doc 22333 22333 0 0.00 0 8152 6 0 0
sp_make_cost_storno 30128 30128 0 0.00 0 11230 45 0 0
sp_multiply_rows_for_pdistr 30128 30128 0 0.00 0 11140 28 0 0
sp_multiply_rows_for_qdistr 21705 21705 0 0.00 0 8224 149 0 0
sp_pay_from_customer 7778 7778 0 0.00 4 13806 104 0 0
sp_pay_to_supplier 6177 6177 0 0.00 4 10421 113 0 0
sp_payment_common 13955 13955 0 0.00 1 13771 26 0 0
sp_qd_handle_on_cancel_clo 1880 1880 0 0.00 0 12095 302 0 0
sp_qd_handle_on_invoice_upd_sts 11028 11028 0 0.00 0 26245 343 0 0
sp_qd_handle_on_reserve_upd_sts 10741 10741 0 0.00 0 17505 55 0 0
sp_reserve_write_off 10741 10741 0 0.00 7 17531 162 0 0
sp_supplier_invoice 5797 5797 0 0.00 7 74900 3252 0 0
sp_supplier_order 5914 5914 0 0.00 5 21453 1229 0 0
srv_aggregate_perf_data 98 98 0 0.00 2452 306871 24275 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 1106 178141 29986 0 0
srv_find_qd_qs_mism 1095535 1095535 0 0.00 0 16518 5 0 0
srv_make_invnt_saldo 607 607 0 0.00 37 43969 1054 0 0
srv_make_money_saldo 851 851 0 0.00 0 2423 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 245583 639300 375083 0 0
t$perf-abend:sp_add_invoice_to_stock 163 163 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5453 5453 0 0.00 0 19072 172 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 0 3454 99 0 0
t$perf-norm:sp_cancel_client_order 1880 1880 0 0.00 0 17663 26 0 0
t$perf-norm:sp_cancel_customer_reserve 753 753 0 0.00 0 5593 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 6060 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 4935 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 510 11 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 20429 1349 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 819 3 0 0
t$perf-norm:sp_client_order 21705 21705 0 0.00 0 6605 17 0 0
t$perf-norm:sp_customer_reserve 1087 1087 0 0.00 0 4677 10 0 0
t$perf-norm:sp_pay_from_customer 7778 7778 0 0.00 0 3174 8 0 0
t$perf-norm:sp_pay_to_supplier 6177 6177 0 0.00 0 5559 10 0 0
t$perf-norm:sp_reserve_write_off 10741 10741 0 0.00 0 5191 10 0 0
t$perf-norm:sp_supplier_invoice 5797 5797 0 0.00 0 5200 18 0 0
t$perf-norm:sp_supplier_order 5914 5914 0 0.00 0 15095 15 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 415 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 703 12 0 0
t$perf-norm:srv_make_invnt_saldo 607 607 0 0.00 0 1322 21 0 0
t$perf-norm:srv_make_money_saldo 851 851 0 0.00 0 932 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 11190 10864 326 2.91 0 8523 22 0 326
v_all_customers 40002 40002 0 0.00 0 19 1 0 0
v_all_suppliers 32142 32142 0 0.00 0 23 1 0 0
v_all_wares 43408 43408 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 2409 9 0 0
v_cancel_client_order 3760 3760 0 0.00 0 7509 7 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 6159 16 0 0
v_cancel_customer_reserve 1506 1506 0 0.00 0 96 3 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 275 4 0 0
v_cancel_supplier_invoice 822 806 16 1.94 0 330 13 0 16
v_cancel_supplier_order 874 874 0 0.00 0 888 5 0 0
v_cancel_write_off 2138 2138 0 0.00 0 6685 17 0 0
v_max_id_clo_ord 5913 5913 0 0.00 0 447 1 0 0
v_max_id_clo_res 1087 1087 0 0.00 0 2408 14 0 0
v_max_id_ord_sup 5795 5795 0 0.00 0 5008 4 0 0
v_max_non_paid_invoice 1813 1813 0 0.00 0 248 2 0 0
v_max_non_paid_realizn 4105 4105 0 0.00 0 4613 5 0 0
v_min_id_clo_ord 5913 5913 0 0.00 0 2376 5 0 0
v_min_id_clo_res 1087 1087 0 0.00 0 5086 8 0 0
v_min_id_ord_sup 5795 5795 0 0.00 0 6085 8 0 0
v_min_non_paid_invoice 6177 6177 0 0.00 0 9930 15 0 0
v_min_non_paid_realizn 7778 7778 0 0.00 0 13766 16 0 0
v_our_firm 10752 10752 0 0.00 0 18 1 0 0
v_reserve_write_off 21482 21482 0 0.00 0 5065 5 0 0
x_lock_depdocs_on_canc_invoice 11339 11339 0 0.00 0 16677 113 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 18646 382 0 0
x_make_qstorno_1000_1200 5914 5914 0 0.00 1 21412 1151 0 0
x_make_qstorno_1200_2000 5797 5797 0 0.00 4 74886 3121 0 0
x_make_qstorno_2100_3300 503704 503704 0 0.00 0 158703 157 0 0

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

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 14648 8192000000 10223155600 10524434432 835356336 9.253 67 52 109 0 855059392 2230688 17472368
19:57:44 25499 8192000000 10333553456 10647367680 1371401984 14.340 100 85 169 0 1404122896 4539216 28181696
19:58:25 20402 8192000000 10363405120 10680471552 1419579888 14.769 100 90 180 0 1455218272 6112384 29526000
19:58:52 32293 8192000000 10392273024 10714476544 1447689296 15.018 100 91 182 0 1485026816 7150736 30186784
19:59:38 8491 8192000000 10410378208 10733826048 1466472816 15.183 100 91 182 0 1503915024 7875856 29566352
20:00:06 28351 8192000000 10433723232 10767261696 1488420688 15.375 100 86 173 0 1524044496 8407616 27216192
20:00:44 19654 8192000000 10465790704 10802032640 1518730928 15.639 100 88 176 0 1555545840 8936128 27878784
20:01:12 18533 8192000000 10487177024 10827948032 1535470032 15.784 100 87 173 1 1572410400 9928448 27011920
20:01:37 12073 8192000000 10500076368 10845294592 1555947856 15.961 100 79 159 0 1590786880 10396224 24442800
20:02:00 17822 8192000000 10537234944 10884894720 1583421712 16.197 100 83 165 1 1619278176 10732144 25124320
20:02:26 8096 8192000000 10540033504 10895814656 1603743024 16.371 100 87 174 1 1641303776 10829664 26731088
20:02:44 16633 8192000000 10570800656 10928308224 1627788768 16.576 100 84 168 1 1663974416 11415520 24770128
20:03:12 9294 8192000000 10588814480 10950541312 1651718720 16.779 100 80 160 1 1687053936 11980608 23354608
20:03:30 7941 8192000000 10613725920 10976329728 1670634304 16.939 100 79 158 0 1705892304 12003392 23254608
20:03:47 10928 8192000000 10620948656 10987884544 1686016816 17.068 100 76 152 2 1720411296 11912784 22481696
20:04:10 7621 8192000000 10647470560 11014934528 1706116688 17.236 100 87 175 1 1744276240 12645792 25513760
20:04:25 6575 8192000000 10661377072 11035406336 1722196208 17.371 100 83 166 2 1759381152 12981360 24203584
20:04:39 6051 8192000000 10684233152 11057016832 1737412176 17.497 100 87 173 1 1774956416 13365488 24178752
20:04:53 6793 8192000000 10688332016 11063648256 1747098544 17.578 100 86 172 0 1785706640 14665552 23942544
20:05:08 3519 8192000000 10698840320 11071639552 1754981792 17.643 100 84 166 0 1792680944 14456352 23242800
20:05:18 4969 8192000000 10710876704 11083595776 1766918736 17.742 100 89 178 0 1807160576 14892272 25349568
20:05:29 3219 8192000000 10714278624 11089899520 1769046080 17.759 100 87 175 3 1808757232 14419152 25292000
20:05:39 3778 8192000000 10721029120 11100835840 1777475424 17.829 100 87 174 0 1816493120 14422928 24594768
20:05:50 3036 8192000000 10722362768 11099475968 1781200976 17.859 100 87 172 1 1820068720 14066864 24800880
20:05:59 2100 8192000000 10727402208 11107147776 1787984224 17.915 100 87 173 1 1826711568 14008832 24718512
20:06:07 7977 8192000000 10735238592 11118964736 1793563248 17.961 100 86 172 0 1831765024 14120624 24081152
20:06:23 2375 8192000000 10742867600 11122544640 1797798016 17.996 100 81 161 1 1834445168 13938496 22708656
20:06:32 2607 8192000000 10759831088 11139600384 1817597120 18.158 100 84 169 0 1855887328 14029456 24260752
20:06:41 1937 8192000000 10759599664 11143962624 1821623056 18.191 100 89 177 5 1860673360 13301824 25748480
20:06:49 1822 8192000000 10768524432 11154071552 1829944128 18.259 100 92 184 1 1870478256 14207296 26326832
20:06:57 1577 8192000000 10781863104 11164258304 1833044208 18.284 100 93 188 1 1874287056 14927488 26315360
20:07:06 1896 8192000000 10781492144 11163967488 1835981712 18.308 100 95 190 1 1878164448 15059360 27123376
20:07:14 1526 8192000000 10784619920 11168145408 1845556592 18.386 100 89 176 2 1882714112 12838816 24318704
20:07:22 2120 8192000000 10792663392 11174342656 1846790928 18.396 100 93 186 1 1886302480 13101616 26409936
20:07:31 1251 8192000000 10797835328 11179995136 1852434544 18.442 100 93 194 1 1891589264 12562096 26592624
20:07:38 1282 8192000000 10788294944 11181568000 1854401568 18.458 100 90 173 2 1891368976 12294448 24672960
20:07:46 1899 8192000000 10808557472 11193356288 1863211152 18.529 100 95 188 2 1901002560 11576960 26214448
20:07:55 1544 8192000000 10812249920 11196293120 1864289664 18.538 100 94 190 1 1904309392 12609680 27410048
20:08:03 39730 8192000000 10786583712 11195092992 1860764544 18.509 100 50 100 1 1883627952 8191408 14672000
20:08:49 2347 8192000000 10805782944 11200598016 1870872896 18.591 100 79 158 0 1901954928 8705488 22376544
20:08:58 9510 8192000000 10818053168 11211980800 1871522512 18.597 100 80 161 1 1906097632 11992480 22582640
20:09:14 7080 8192000000 10789808416 11204587520 1865359584 18.547 100 45 90 0 1888193792 10185920 12648288
20:09:28 3419 8192000000 10802332992 11205046272 1870793216 18.591 100 59 119 2 1895861888 8698528 16370144
20:09:38 4403 8192000000 10791954112 11208396800 1873033088 18.609 100 48 94 1 1896212352 10327904 12851360
20:09:49 2589 8192000000 10785372416 11206197248 1874984896 18.625 100 47 93 1 1896261312 7435808 13840608
20:10:01 6466 8192000000 10778727808 11206475776 1873470256 18.612 100 29 58 2 1889152000 7539536 8142208
20:10:16 6031 8192000000 10776939136 11206365184 1874169392 18.618 100 27 55 0 1887576592 5712288 7694912
20:10:28 6995 8192000000 10790387200 11212713984 1876986640 18.641 100 17 32 2 1887039488 5443328 4609520
20:10:46 4372 8192000000 10788483584 11217821696 1884590448 18.702 100 23 46 1 1896690064 5078544 7021072
20:10:56 10522 8192000000 10791876080 11220201472 1884238480 18.699 100 24 48 2 1897156416 6137808 6780128
20:11:14 12306 8192000000 10793125504 11223068672 1886705232 18.719 100 19 38 2 1897660752 5725744 5229776
20:11:34 10951 8192000000 10795838288 11227803648 1889232080 18.740 100 14 28 0 1899221184 5603280 4385824
20:11:51 8310 8192000000 10801069312 11229020160 1891958288 18.762 100 11 20 1 1899837504 5119488 2759728
20:12:07 12449 8192000000 10802910208 11236114432 1895820768 18.793 100 20 41 0 1908096640 6659920 5615952
20:12:26 8292 8192000000 10813413696 11242512384 1904641360 18.864 100 23 46 1 1917437728 5866944 6929424
20:12:41 20110 8192000000 10814693856 11247652864 1906443264 18.878 100 32 64 4 1921380080 5516656 9420160
20:13:10 57325 8192000000 10858193888 11260092416 1912242272 18.925 100 63 126 1 1936905072 5646608 19016192
20:14:13 9175 8192000000 10808139312 11248066560 1903022496 18.851 100 23 46 0 1916078640 6887008 6169136
20:14:28 8717 8192000000 10820493808 11254562816 1906576368 18.879 100 22 44 3 1918468304 5462160 6429776
20:14:45 3104 8192000000 10829644096 11257425920 1911132176 18.916 100 44 87 3 1932104864 8026960 12945728
20:14:58 6664 8192000000 10833500768 11259854848 1911821296 18.921 100 32 64 1 1927420912 7062560 8537056
20:15:12 4816 8192000000 10843065920 11266064384 1913615696 18.936 100 43 86 0 1935113296 8993200 12504400
20:15:24 8105 8192000000 10829682704 11254677504 1895299520 18.788 99 27 54 1 1909608000 6799392 7509088
20:15:41 6381 8192000000 10825051584 11254972416 1907403904 18.886 100 26 50 0 1921427072 6531616 7491552
20:15:54 9255 8192000000 10815040800 11253096448 1889583792 18.742 99 18 36 0 1900752256 6219008 4949456
20:16:12 7370 8192000000 10817328224 11250712576 1889051936 18.738 99 29 57 1 1904196736 6652736 8492064
20:16:29 9063 8192000000 10785210896 11216961536 1844704224 18.379 97 18 36 1 1855269456 5275152 5290080
20:16:45 7553 8192000000 10807066624 11236417536 1879090656 18.658 99 27 54 1 1893043520 5957680 7995184
20:17:02 6833 8192000000 10775298352 11201576960 1809460208 18.091 96 22 44 3 1825493920 10017376 6016336
20:17:16 9478 8192000000 10766124544 11183906816 1824785392 18.217 97 29 58 2 1838936832 5512128 8639312
20:17:32 20940 8192000000 10752706368 11186634752 1786353856 17.902 95 22 42 1 1800467232 5197872 8915504
20:18:36 26067 8192000000 10717522592 11140157440 1645357040 16.725 88 26 50 2 1658023440 5768096 6898304
20:19:11 8400 8192000000 10721405376 11143720960 1737841552 17.501 95 25 50 1 1751500944 6647696 7011696
20:19:28 5537 8192000000 10706788688 11128516608 1760191456 17.686 97 32 64 1 1776621120 7144608 9285056
20:19:40 4558 8192000000 10730166304 11139104768 1771030240 17.776 97 38 76 1 1789081072 7485984 10564848
20:19:51 5909 8192000000 10738995552 11148476416 1791114704 17.941 98 28 56 1 1806155296 6438512 8602080
20:20:06 7712 8192000000 10711704384 11123552256 1720558112 17.357 95 35 69 3 1740638224 10834112 9246000
20:20:20 6544 8192000000 10699823728 11116650496 1764009776 17.718 98 37 75 1 1780823904 6160800 10653328
20:20:35 9430 8192000000 10704389600 11126874112 1774981440 17.808 99 29 58 1 1788780240 5800288 7998512
20:20:55 6832 8192000000 10719203168 11131994112 1802430800 18.034 100 43 86 1 1821824240 7302352 12091088
20:21:10 9423 8192000000 10717743744 11138301952 1790619008 17.937 99 28 55 1 1804994976 5902144 8473824
20:21:27 8719 8192000000 10720518960 11144548352 1761925920 17.700 97 26 52 1 1779205136 9952128 7327088
20:21:42 8661 8192000000 10737592608 11162271744 1821700640 18.192 100 29 58 0 1836195968 5545504 8949824
20:22:00 10019 8192000000 10715617648 11141226496 1782044864 17.866 98 16 32 2 1791927136 5536448 4345824
20:22:22 68970 8192000000 10739530624 11176370176 1832837040 18.282 100 33 66 1 1848728144 5595776 10295328
20:23:37 10185 8192000000 10764606352 11190841344 1843242816 18.367 100 18 36 1 1853824816 5910336 4671664
20:23:55 9229 8192000000 10773985280 11197587456 1840312992 18.343 99 27 54 1 1855073808 7155808 7605008
20:24:12 8059 8192000000 10793172368 11202535424 1843462032 18.369 99 37 72 2 1860287936 5988800 10837104
20:24:27 5660 8192000000 10790363616 11206905856 1866067424 18.552 100 38 74 1 1882569216 5496720 11005072
20:24:40 5873 8192000000 10764954960 11192352768 1846701328 18.395 99 12 23 2 1855367872 5336576 3329968
20:24:54 8665 8192000000 10784877760 11218898944 1871077840 18.593 100 25 50 3 1888421936 10306304 7037792
20:25:10 4427 8192000000 10794910240 11220889600 1875378736 18.628 100 29 58 0 1889638784 5982624 8277424
20:25:20 8365 8192000000 10788997088 11221377024 1878076016 18.650 100 16 31 0 1887859520 5411024 4372480
20:25:43 7586 8192000000 10791303552 11226030080 1880076208 18.666 100 18 35 0 1891958864 5532800 6349856
20:26:01 7788 8192000000 10803412960 11230732288 1883063872 18.690 100 26 55 2 1897294480 6437600 7793008
20:26:18 9238 8192000000 10789112672 11227029504 1879515440 18.661 100 11 21 2 1887288160 5185744 2586976
20:26:34 16673 8192000000 10795880544 11231297536 1883366272 18.692 100 19 39 0 1894243008 5367792 5508944
20:27:00 27735 8192000000 10814271200 11248222208 1896253248 18.796 100 31 62 1 1909956720 5347856 8355616
20:28:04 9829 8192000000 10836238352 11260727296 1914101680 18.940 100 54 106 0 1934566432 5335888 15128864
20:28:29 38634 8192000000 10849433904 11278983168 1925438320 19.030 100 56 110 1 1949350896 8416064 15496512
20:29:16 48488 8192000000 10868270432 11299434496 1929238032 19.061 100 40 80 1 1952399728 11597168 11564528
20:30:14 16318 8192000000 10877695136 11303235584 1942606272 19.168 100 38 75 3 1963655264 10449792 10599200
20:30:38 7991 8192000000 10881349216 11309678592 1950008944 19.227 100 42 84 0 1972567184 10464240 12094000
20:31:02 16434 8192000000 10908771568 11327725568 1956221504 19.276 100 45 90 1 1980611392 11570624 12819264
20:31:28 3520 8192000000 10911227824 11332755456 1967243712 19.364 100 60 120 1 1998261648 14118112 16899824
20:31:39 15956 8192000000 10914586928 11339489280 1970079120 19.386 100 59 116 0 2002339760 15928000 16332640
20:32:08 21630 8192000000 10918499184 11350712320 1972610432 19.406 100 48 95 1 2000639936 14866752 13162752
20:32:38 20023 8192000000 10922494816 11355668480 1982567152 19.485 100 48 96 0 2012413792 15936912 13909728
20:33:48 8949 8192000000 10928232656 11365146624 1986742256 19.518 100 49 99 0 2025041840 23833808 14465776
20:34:04 17125 8192000000 10929885328 11367682048 1990523808 19.548 100 37 74 0 2016548208 14216832 11807568
20:34:31 6109 8192000000 10918096528 11361857536 1988698512 19.534 100 45 90 2 2017347728 14858720 13790496
20:34:44 18616 8192000000 10939863408 11374608384 1997004576 19.599 100 52 104 0 2029044496 16097456 15942464
20:35:14 4720 8192000000 10936090496 11374862336 1997909504 19.606 100 52 101 1 2028700912 16382800 14408608
20:35:36 7179 8192000000 10937167984 11366961152 1970518416 19.390 98 65 131 1 2008586480 18864592 19203472
20:35:52 3450 8192000000 10956331232 11380830208 1996799904 19.597 100 71 141 2 2035869136 19041616 20027616
20:36:02 3549 8192000000 10954004032 11381051392 2002298096 19.641 100 72 142 0 2041916464 19372992 20245376
20:36:13 1909 8192000000 10971692880 11391516672 2011012768 19.709 100 77 154 0 2057412656 23449728 22950160
20:36:21 3379 8192000000 10972523632 11393380352 2007719808 19.684 100 82 163 2 2056095248 24776688 23598752
20:36:32 1208 8192000000 10972945472 11394826240 2009460352 19.697 100 81 162 3 2056762496 23623456 23678688
20:36:40 4315 8192000000 10963356304 11396378624 2011875136 19.716 100 73 146 2 2057733920 24103712 21755072
20:36:58 2937 8192000000 10978247680 11405459456 2012580624 19.722 100 73 145 2 2058440752 24234752 21625376
20:37:12 15479 8192000000 10966863552 11405000704 1996548064 19.596 99 61 120 1 2040375376 25868320 17958992
20:37:34 5095 8192000000 10969297648 11400466432 1997413648 19.602 99 67 134 1 2044063008 26715872 19933488
20:37:47 6237 8192000000 10958395232 11389853696 1989977424 19.544 99 58 115 1 2031476128 24266960 17231744
20:38:04 4296 8192000000 10965809872 11389620224 1994812992 19.582 100 65 129 0 2037504944 23896368 18795584
20:38:22 6585 8192000000 10961672176 11389681664 2001278336 19.633 100 66 132 3 2046984464 26239312 19466816
20:38:38 4024 8192000000 10974284288 11399180288 2006180640 19.671 100 75 147 1 2055232032 27070768 21980624
20:38:52 3534 8192000000 10990007120 11416043520 2021622576 19.793 100 80 160 0 2075100352 29137024 24340752
20:39:04 6857 8192000000 10970639744 11397242880 1992487136 19.563 99 81 161 0 2046302544 29733216 24082192
20:39:20 3457 8192000000 10976525328 11402121216 2009802752 19.700 100 67 133 0 2059154192 29392224 19959216
20:39:32 4330 8192000000 10978799024 11403870208 2006554752 19.674 100 66 130 0 2058047856 31867392 19625712
20:39:43 2843 8192000000 10970778368 11396653056 2001057712 19.631 100 77 152 1 2057503808 32595440 23850656
20:39:56 5678 8192000000 10971378640 11398955008 2002413984 19.642 100 71 142 2 2055886160 31398768 22073408
20:40:13 1428 8192000000 10977053312 11400777728 2009652000 19.699 100 78 155 2 2065008672 31051472 24305200
20:40:23 1839 8192000000 10986072816 11404083200 2007704704 19.683 100 90 179 1 2067905344 32262256 27938384
20:40:34 3481 8192000000 10977974560 11402153984 2003434240 19.650 100 79 158 1 2063885984 36030272 24421472
20:40:46 2686 8192000000 10957260768 11375259648 1979824048 19.463 100 85 168 3 2041660240 36003840 25832352
20:40:56 2936 8192000000 10971273088 11385434112 1989947456 19.543 100 82 165 1 2052194864 36625760 25621648
20:41:06 3295 8192000000 10955654544 11372773376 1969215312 19.379 99 82 163 3 2029693200 35348832 25129056
20:41:17 1552 8192000000 10936220768 11346579456 1949485792 19.222 98 83 162 1 2006250576 32341264 24423520
20:41:26 3093 8192000000 10950731136 11375116288 1980464480 19.468 100 74 146 3 2036362672 32322112 23576080
20:41:37 2308 8192000000 10952093616 11373314048 1987204416 19.522 100 73 148 0 2040055168 30436656 22414096
20:41:48 8150 8192000000 10932082480 11346280448 1956995392 19.282 99 75 152 1 2009075584 28713744 23366448
20:42:03 3389 8192000000 10957137808 11369717760 1980876848 19.472 100 82 162 1 2036626576 31818784 23930944
20:42:13 2296 8192000000 10949263792 11365867520 1960392464 19.309 99 88 175 2 2020894496 32427376 28074656
20:42:21 2879 8192000000 10941645424 11359985664 1969696576 19.383 100 89 177 0 2031429680 34876784 26856320
20:42:31 3394 8192000000 10960361488 11374407680 1978878096 19.456 100 84 166 0 2038757968 34347472 25532400
20:42:43 2630 8192000000 10962307104 11373305856 1978758656 19.455 100 90 180 0 2042386448 35697056 27930736
20:42:52 4390 8192000000 10931040928 11357188096 1962532112 19.326 100 68 133 1 2020253232 36475040 21246080
20:43:03 2925 8192000000 10942783216 11360399360 1950482640 19.230 99 80 160 3 2012862880 37034768 25345472
20:43:13 4715 8192000000 10950204960 11370020864 1970962784 19.393 100 76 152 0 2029275504 34943936 23368784
20:43:25 8567 8192000000 10932289280 11354333184 1946166016 19.196 99 70 138 0 2004081920 36704768 21211136
20:43:42 4613 8192000000 10942174688 11367751680 1966308912 19.356 100 75 148 1 2027259232 37605616 23344704
20:43:56 2146 8192000000 10952336288 11371810816 1951833392 19.241 99 76 150 0 2012529872 38045104 22651376
20:44:04 2901 8192000000 10955202048 11371245568 1972024736 19.402 100 90 181 1 2039046880 38430352 28591792
20:44:14 1658 8192000000 10957362128 11371343872 1970101904 19.386 100 90 180 2 2037546880 40016944 27428032
20:44:23 1105 8192000000 10966316544 11377029120 1974318176 19.420 100 92 184 0 2042036272 39581440 28136656
20:44:31 3415 8192000000 10941436880 11346489344 1949421360 19.222 99 91 182 1 2015699392 38227280 28050752
20:44:41 3404 8192000000 10953844224 11366289408 1971941424 19.401 100 83 165 0 2032570912 35581136 25048352
20:44:52 3061 8192000000 10964127760 11375616000 1976980800 19.441 100 85 171 0 2040075616 37332560 25762256
20:45:03 3023 8192000000 10956835984 11377680384 1979177392 19.458 100 81 162 0 2041733584 36687280 25868912
20:45:12 2840 8192000000 10944255712 11364278272 1956879264 19.281 99 78 156 1 2019425824 37334464 25212096
20:45:24 3556 8192000000 10941835856 11353825280 1960509344 19.310 100 82 163 1 2019879120 34065360 25304416
20:45:35 1538 8192000000 10952985232 11372408832 1974085312 19.418 100 82 164 0 2032615200 33938496 24591392
20:45:46 1411 8192000000 10951161328 11369848832 1970807328 19.392 100 73 142 0 2028007408 35028384 22171696
20:45:58 3277 8192000000 10956935472 11375452160 1979331424 19.459 100 78 157 3 2038226368 33548416 25346528
20:46:09 5697 8192000000 10944670384 11379441664 1975803296 19.431 100 59 118 2 2028207440 34235456 18168688
20:46:21 4806 8192000000 10943868768 11379322880 1978268304 19.451 100 52 104 1 2029616240 35204688 16143248
20:46:52 13709 8192000000 10905866400 11361181696 1929820272 19.065 98 32 64 3 1975233424 34874240 10538912
20:47:12 6825 8192000000 10913349040 11361763328 1940002320 19.147 99 34 67 2 1984280144 33513968 10763856
20:47:25 18037 8192000000 10911077568 11357847552 1919077136 18.979 98 31 61 1 1962764752 33956272 9731344
20:47:50 10718 8192000000 10925385760 11354439680 1952478912 19.246 100 30 60 1 1995827968 32145520 11203536
20:48:10 6495 8192000000 10925129504 11362779136 1961030048 19.314 100 43 86 1 2008876912 34069584 13777280
20:48:24 11795 8192000000 10900732592 11343216640 1942012080 19.163 99 34 68 1 1988008304 34886432 11109792
20:48:42 7435 8192000000 10920715760 11356188672 1952029360 19.243 100 40 80 1 2001610016 36373344 13207312
20:48:57 8055 8192000000 10908245760 11340509184 1919167024 18.980 98 38 76 1 1968248992 36277312 12804656
20:49:13 4523 8192000000 10941975696 11366842368 1964975232 19.346 100 69 136 1 2026612416 39774000 21863184
20:49:24 8166 8192000000 10943898272 11378053120 1964465920 19.342 100 48 96 0 2021967488 41382160 16119408
20:49:44 4776 8192000000 10950012784 11383005184 1972400768 19.404 100 54 106 2 2034800416 44995056 17404592
20:49:57 17663 8192000000 10934481584 11377963008 1946346144 19.197 99 38 70 1 1997335024 39950768 11038112
20:50:21 9533 8192000000 10922071024 11363110912 1950035232 19.227 100 46 92 1 2011330992 46401904 14893856
20:50:37 9405 8192000000 10931943072 11367661568 1960272016 19.308 100 38 76 0 2005408736 32737296 12399424
20:51:03 22977 8192000000 10935699856 11373498368 1969833984 19.384 100 45 91 1 2018603264 34484960 14284320
20:51:36 18415 8192000000 10932825488 11384864768 1950889136 19.234 99 40 80 0 2001757120 38067184 12800800
20:52:06 29354 8192000000 10926954096 11389628416 1957261056 19.284 100 28 56 3 2012050560 44772992 10016512
20:53:37 23076 8192000000 10915770624 11362963456 1934166752 19.100 100 29 58 2 1990576384 45719120 10690512
20:54:06 25003 8192000000 10909101184 11381293056 1939100416 19.140 100 23 46 0 1994912832 46846816 8965600
20:54:47 19876 8192000000 10890100448 11376041984 1933273408 19.093 100 10 20 3 1971882544 35249520 3359616
20:55:14 18760 8192000000 10897130288 11366768640 1932826960 19.089 100 10 20 1 1970404832 34326480 3251392
20:55:39 23086 8192000000 10869649792 11358932992 1905396688 18.870 98 7 14 0 1942908624 35427168 2084768
20:56:08 35765 8192000000 10854290816 11316256768 1878942128 18.657 97 27 54 1 1900176416 13573312 7660976
20:56:50 98247 8192000000 10877221008 11324645376 1852857888 18.445 96 14 28 0 1868297536 11122688 4316960
20:58:41 67578 8192000000 10876888640 11333537792 1929322704 19.061 99 42 84 0 1953775472 13464784 10987984
21:00:01 123078 8192000000 10891176704 11346165760 1937465440 19.127 99 35 69 1 1959704816 11514960 10724416
21:02:11 103322 8192000000 10909116704 11353694208 1891242816 18.756 96 32 64 2 1914935424 14405152 9287456
21:04:00 178141 8192000000 10882291280 11338153984 1868471808 18.572 95 25 50 1 1886901920 11455536 6974576
21:07:05 32754 8192000000 10903871440 11365130240 1969696144 19.383 100 32 64 1 1987935872 9003024 9236704
21:07:45 46586 8192000000 10911220720 11365933056 1975704208 19.431 100 45 90 2 1997498848 8422976 13371664
21:08:40 12257 8192000000 10912895584 11371106304 1977845472 19.448 100 30 55 4 1993913568 7920496 8147600
21:09:17 52938 8192000000 10900927888 11363577856 1954885568 19.265 99 26 51 1 1977942784 15848944 7208272
21:10:21 39556 8192000000 10894297600 11370958848 1970002432 19.385 100 10 20 0 1987448032 14430720 3014880
21:11:09 12670 8192000000 10889060336 11364081664 1956360592 19.277 99 11 22 0 1969243904 9924240 2959072
21:11:28 10839 8192000000 10890147200 11366563840 1971545904 19.398 100 8 15 0 1983275712 9706544 2023264
21:11:46 18970 8192000000 10911473088 11372580864 1975976128 19.433 100 14 29 0 1990346160 10030768 4339264
21:12:11 45203 8192000000 10894536592 11367313408 1960954000 19.314 99 7 14 0 1973473936 10568320 1951616
21:13:02 39079 8192000000 10883483776 11352027136 1958940048 19.298 99 15 30 0 1975879712 12392832 4546832
21:14:23 52020 8192000000 10897354128 11375722496 1962426304 19.325 99 12 24 1 1973162160 7366480 3369376
21:15:41 72054 8192000000 10885706176 11359035392 1945810480 19.193 98 13 27 0 1958742080 9437968 3493632
21:17:00 47300 8192000000 10907005248 11361435648 1923624000 19.016 97 33 66 0 1941631168 7921008 10086160
21:17:58 39263 8192000000 10903087680 11376807936 1977972720 19.449 100 25 50 1 1995953424 10740000 7240704
21:18:44 40369 8192000000 10907542544 11383975936 1962693312 19.327 99 17 33 0 1983630144 16784768 4152064
21:19:30 55049 8192000000 10909703248 11391442944 1959417056 19.301 99 17 34 0 1979495008 15431120 4646832
21:20:32 54376 8192000000 10874807424 11344777216 1860306480 18.506 94 16 32 1 1873798208 9401504 4090224
21:21:32 24987 8192000000 10894533328 11351969792 1921620080 19.000 98 20 40 0 1934625264 7226240 5778944
21:22:08 13192 8192000000 10906610832 11360067584 1961989712 19.322 100 40 80 1 1983626192 10037104 11599376
21:22:27 35989 8192000000 10902866752 11358470144 1929316672 19.061 98 34 69 1 1955614912 16798832 9499408
21:23:12 66230 8192000000 10867862112 11350577152 1889360496 18.741 96 26 52 0 1915063664 18222976 7480192
21:24:31 47019 8192000000 10884145248 11347410944 1914119376 18.940 98 20 40 1 1928786576 9238912 5428288
21:25:30 15455 8192000000 10901703264 11350982656 1933913136 19.098 98 41 82 0 1955281520 9748608 11619776
21:25:52 52093 8192000000 10886517056 11357253632 1911468992 18.918 97 22 44 1 1928344720 10487264 6388464
21:27:29 131015 8192000000 10882174864 11354521600 1886958928 18.721 96 13 26 0 1909760656 19426320 3375408
21:29:46 75411 8192000000 10875053360 11341901824 1890785840 18.752 96 30 60 1 1910347280 11293760 8267680
21:31:07 25802 8192000000 10891287216 11352793088 1928407824 19.054 98 27 54 1 1950216512 14422528 7386160
21:31:52 46130 8192000000 10881349696 11365171200 1957036624 19.282 100 14 28 1 1974982144 14034192 3911328
21:32:44 44250 8192000000 10884121344 11359092736 1923531920 19.015 98 10 20 0 1937047872 11053552 2462400
21:33:45 50093 8192000000 10904637728 11379122176 1972454592 19.405 100 13 26 0 1989700272 13677808 3567872
21:34:41 80701 8192000000 10869607280 11337449472 1864629232 18.541 94 20 40 0 1888164720 17669456 5866032
21:36:08 54640 8192000000 10873900736 11353591808 1945666304 19.192 99 18 36 0 1971146832 20220336 5260192
21:37:23 27520 8192000000 10888607184 11353759744 1960813120 19.313 100 15 29 1 1972405472 8193360 3398992
21:38:00 38513 8192000000 10874679536 11338035200 1905259936 18.869 97 28 54 1 1920448080 7570448 7617696
21:38:56 59997 8192000000 10869733968 11323068416 1833714816 18.290 94 21 42 0 1847717632 8180992 5821824
21:40:06 49216 8192000000 10851084448 11327086592 1891759488 18.760 98 23 46 0 1909297984 10328672 7209824
21:41:07 65644 8192000000 10888303152 11333431296 1890906496 18.753 98 26 52 0 1908907776 10688224 7313056
21:42:19 54149 8192000000 10870131904 11330547712 1896405760 18.797 98 44 87 0 1925078064 16647392 12024912
21:43:31 90591 8192000000 10860589360 11325218816 1837664496 18.322 95 7 14 0 1849432320 10079264 1688560
21:45:17 49343 8192000000 10903633696 11356172288 1944055840 19.179 100 15 30 1 1961976432 14052400 3868192
21:46:13 88670 8192000000 10895673552 11358728192 1899279376 18.820 97 24 48 1 1918599392 13120912 6199104
21:47:52 52774 8192000000 10894736032 11370946560 1942646096 19.168 99 12 24 0 1957673936 11916992 3110848
21:48:52 117313 8192000000 10875772352 11344359424 1912023504 18.923 97 23 46 1 1930327792 11444800 6859488
21:50:55 83302 8192000000 10883921696 11358199808 1914277424 18.941 98 14 28 0 1933281888 15202656 3801808
21:52:26 7857 8192000000 10888935280 11359092736 1955563824 19.271 100 24 48 1 1978228608 15965488 6699296
21:52:40 20174 8192000000 10876295904 11347619840 1954477968 19.262 100 21 42 1 1976825520 15863824 6483728
21:53:13 69211 8192000000 10870032768 11357016064 1921823168 19.001 98 22 43 0 1941751760 14210144 5718448
21:55:29 76651 8192000000 10892598448 11358683136 1944699344 19.184 99 21 41 0 1962871872 12198704 5973824
21:56:52 48731 8192000000 10861850336 11337703424 1939036096 19.139 99 8 16 0 1948267408 6812000 2419312
21:57:52 70296 8192000000 10874663200 11348054016 1918946848 18.978 98 22 43 0 1938064880 13424784 5693248
21:59:52 61670 8192000000 10892477728 11371741184 1967406240 19.365 100 9 18 0 1977945408 7982976 2556192
22:01:00 49523 8192000000 10923833712 11392851968 1968076352 19.370 99 18 36 0 1983849824 10859280 4914192
22:01:56 69395 8192000000 10897803824 11375259648 1899636240 18.823 95 17 34 1 1916959696 12521904 4801552
22:03:13 70823 8192000000 10885610896 11373064192 1917006480 18.963 97 23 46 0 1936717824 12894912 6816432
22:04:33 33725 8192000000 10899279200 11368382464 1940818336 19.153 98 24 48 3 1957968336 10371024 6778976
22:05:15 49162 8192000000 10888328608 11339157504 1913690832 18.936 97 22 44 0 1930684272 10333040 6660400
22:06:11 28098 8192000000 10882910320 11340922880 1902492720 18.846 97 25 50 0 1918982464 9583376 6906368
22:06:51 30091 8192000000 10889179632 11357196288 1955531504 19.271 100 33 66 0 1974803648 10085616 9186528
22:07:30 32608 8192000000 10885745472 11346444288 1892242128 18.764 96 33 66 0 1913385152 11910896 9232128
22:08:40 86988 8192000000 10895492592 11362836480 1906286480 18.877 97 25 49 3 1925527296 12129728 7111088
22:10:13 61963 8192000000 10888166816 11364036608 1935037408 19.107 99 19 38 1 1958570560 17768256 5764896
22:11:22 69461 8192000000 10884271360 11370369024 1939925584 19.146 99 21 43 0 1959679216 13777280 5976352
22:12:38 100027 8192000000 10907953968 11387789312 1930419728 19.070 98 19 38 2 1952328944 16558896 5350320
22:14:28 109622 8192000000 10873410656 11344756736 1924081408 19.020 98 7 14 0 1941085920 15127392 1877120
22:16:54 62227 8192000000 10875467904 11352481792 1919075696 18.979 98 12 24 0 1929436272 7186032 3174544
22:18:03 47132 8192000000 10905316528 11371671552 1978592256 19.454 100 29 59 1 1993602400 7089984 7920160
22:19:11 73576 8192000000 10873456448 11360419840 1891222336 18.756 96 4 8 0 1901536496 9219792 1094368
22:20:36 27488 8192000000 10876704096 11360051200 1940199600 19.148 99 8 16 2 1954553376 12012784 2340992
22:21:10 35801 8192000000 10877760384 11359760384 1949150240 19.220 100 9 18 0 1969621120 18118992 2351888
22:21:52 12973 8192000000 10873525248 11355832320 1952466656 19.246 100 10 20 0 1969895408 14289376 3139376
22:22:13 50252 8192000000 10854550304 11341000704 1924633648 19.024 99 9 18 0 1936809344 9871664 2304032
22:24:00 44395 8192000000 10871558064 11332063232 1896885184 18.801 98 21 40 2 1910810864 8299760 5625920
22:24:55 19508 8192000000 10864798320 11332919296 1923432416 19.014 99 23 46 0 1937247456 7449040 6366000
22:25:20 29602 8192000000 10857989648 11327344640 1876012496 18.633 96 20 40 0 1890277136 8480208 5784432
22:26:05 42749 8192000000 10851228112 11331411968 1913452160 18.934 99 22 44 3 1929620752 9894384 6274208
22:26:54 27435 8192000000 9470455616 9785958400 605610832 6.883 32 7 14 0 612856608 5554256 1691520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 04-02-2021 22:28:36 to 04-02-2021 22:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 163 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          250354
MON$OLDEST_ACTIVE               250984
MON$OLDEST_SNAPSHOT             250984
MON$NEXT_TRANSACTION            250984
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                       2044320
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.33413 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33413 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33413 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33413 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Thu Feb  4 22:27:25 2021
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Thu Feb  4 22:27:26 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Thu Feb  4 22:27:26 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Thu Feb  4 22:27:26 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
--- end of diff output ---

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

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