Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.02.2021 19: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 17123400 kB
MemAvailable 31148092 kB
Buffers 0 kB
Cached 14554388 kB
SwapCached 4384 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-15 19:27:14
DTS_END                         2021-02-15 19:27:14.8660
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/36970
TRN_ID                          234894
ATT_ID                          666
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: 9290.33 24003 1114840
customer order: creation 166.40 381 19968
customer order: refuse 14.26 349 1711
order to supplier: creation 44.88 1322 5386
order to supplier: removal 3.56 106292 427
invoice (draft): creation 44.89 3426 5387
invoice (draft): removal 56.07 810 6728
invoice accept: apply 40.46 18090 4855
invoice accept: cancel 50.02 770 6002
customer reserve: creation 3698.27 181 443792
customer reserve: removal 4880.31 60 585637
realization accept: apply 81.13 173 9735
realization accept: cancel 84.38 118 10125
payment from customer: creation 57.40 121 6888
payment from customer: removal 6.03 85 724
payment to supplier: creation 46.85 133 5622
payment to supplier: removal 3.23 97 387
service: total inventory turnovers 4.68 1195 561
service: total monetary turnovers 6.75 19 810
service: aggregate perf. data 0.76 25870 91
service: refresh index statistics 0.03 320573 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-02-2021 19:28:31 to 15-02-2021 19:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6540
TEST_TIME 2 4930
TEST_TIME 3 5362
TEST_TIME 4 5295
TEST_TIME 5 5427
TEST_TIME 6 5787
TEST_TIME 7 5649
TEST_TIME 8 5772
TEST_TIME 9 6101
TEST_TIME 10 5982
TEST_TIME 11 6281
TEST_TIME 12 6418
TEST_TIME 13 6521
TEST_TIME 14 6565
TEST_TIME 15 6787
TEST_TIME 16 6887
TEST_TIME 17 6854
TEST_TIME 18 7292
TEST_TIME 19 7357
TEST_TIME 20 7405
TEST_TIME 21 7986
TEST_TIME 22 9071
TEST_TIME 23 9128
TEST_TIME 24 9043
TEST_TIME 25 10568
TEST_TIME 26 10806
TEST_TIME 27 10756
TEST_TIME 28 10833
TEST_TIME 29 10545
TEST_TIME 30 10446
TEST_TIME 31 10274
TEST_TIME 32 10369
TEST_TIME 33 10262
TEST_TIME 34 10149
TEST_TIME 35 10031
TEST_TIME 36 9950
TEST_TIME 37 9934
TEST_TIME 38 9989
TEST_TIME 39 9867
TEST_TIME 40 9718
TEST_TIME 41 9656
TEST_TIME 42 9665
TEST_TIME 43 9501
TEST_TIME 44 9475
TEST_TIME 45 9344
TEST_TIME 46 9295
TEST_TIME 47 9167
TEST_TIME 48 9122
TEST_TIME 49 9273
TEST_TIME 50 9206
TEST_TIME 51 9145
TEST_TIME 52 9241
TEST_TIME 53 9355
TEST_TIME 54 9463
TEST_TIME 55 9522
TEST_TIME 56 9420
TEST_TIME 57 9383
TEST_TIME 58 9521
TEST_TIME 59 9676
TEST_TIME 60 9771
TEST_TIME 61 9774
TEST_TIME 62 9786
TEST_TIME 63 9648
TEST_TIME 64 9593
TEST_TIME 65 9537
TEST_TIME 66 9496
TEST_TIME 67 9434
TEST_TIME 68 9429
TEST_TIME 69 9425
TEST_TIME 70 9490
TEST_TIME 71 9444
TEST_TIME 72 9476
TEST_TIME 73 9400
TEST_TIME 74 9631
TEST_TIME 75 9594
TEST_TIME 76 9570
TEST_TIME 77 9597
TEST_TIME 78 9684
TEST_TIME 79 9633
TEST_TIME 80 9649
TEST_TIME 81 9736
TEST_TIME 82 9649
TEST_TIME 83 9546
TEST_TIME 84 9574
TEST_TIME 85 9525
TEST_TIME 86 9532
TEST_TIME 87 9531
TEST_TIME 88 9491
TEST_TIME 89 9447
TEST_TIME 90 9452
TEST_TIME 91 9429
TEST_TIME 92 9363
TEST_TIME 93 9347
TEST_TIME 94 9403
TEST_TIME 95 9413
TEST_TIME 96 9460
TEST_TIME 97 9482
TEST_TIME 98 9488
TEST_TIME 99 9443
TEST_TIME 100 9477
TEST_TIME 101 9543
TEST_TIME 102 9548
TEST_TIME 103 9547
TEST_TIME 104 9541
TEST_TIME 105 9591
TEST_TIME 106 9589
TEST_TIME 107 9574
TEST_TIME 108 9496
TEST_TIME 109 9463
TEST_TIME 110 9434
TEST_TIME 111 9368
TEST_TIME 112 9394
TEST_TIME 113 9350
TEST_TIME 114 9345
TEST_TIME 115 9303
TEST_TIME 116 9311
TEST_TIME 117 9358
TEST_TIME 118 9383
TEST_TIME 119 9367
TEST_TIME 120 9294

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-02-2021 19:28:34 to 15-02-2021 19:28:38.

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 1526592 1526592 0 0.00 0 14721 6 0 0
doc_list_biud 1526592 1526592 0 0.00 0 30595 29 0 0
sp_add_invoice_to_stock 4977 4855 122 2.45 56 167661 18090 0 122
sp_cancel_adding_invoice 6002 6002 0 0.00 5 60730 771 0 0
sp_cancel_client_order 1711 1711 0 0.00 4 9502 349 0 0
sp_cancel_customer_reserve 585637 585637 0 0.00 1 26106 61 0 0
sp_cancel_pay_from_customer 724 724 0 0.00 3 5207 86 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 3 3962 97 0 0
sp_cancel_supplier_invoice 6741 6728 13 0.19 2 16600 810 0 13
sp_cancel_supplier_order 427 427 0 0.00 8 1082678 106293 0 0
sp_cancel_write_off 10125 10125 0 0.00 1 10797 119 0 0
sp_client_order 19968 19968 0 0.00 3 34295 382 0 0
sp_customer_reserve 443792 443792 0 0.00 0 158965 182 0 0
sp_fill_shopping_cart 30734 30734 0 0.00 1 15495 40 0 0
sp_fill_shopping_cart_clo_res 443788 443788 0 0.00 0 16245 13 0 0
sp_get_clo_for_invoice 4851 4851 0 0.00 0 26250 330 0 0
sp_kill_cost_storno 17238 17238 0 0.00 0 10460 59 0 0
sp_kill_qstorno_ret_qs2qd 1188554 1188554 0 0.00 0 26038 33 0 0
sp_kill_qty_storno 625216 625216 0 0.00 0 30593 71 0 0
sp_lock_selected_doc 20247 20247 0 0.00 0 7973 4 0 0
sp_make_cost_storno 27096 27096 0 0.00 0 14720 51 0 0
sp_multiply_rows_for_pdistr 27096 27096 0 0.00 0 6785 30 0 0
sp_multiply_rows_for_qdistr 19968 19968 0 0.00 0 23930 163 0 0
sp_pay_from_customer 6888 6888 0 0.00 4 24150 122 0 0
sp_pay_to_supplier 5622 5622 0 0.00 5 14048 134 0 0
sp_payment_common 12510 12510 0 0.00 2 24092 34 0 0
sp_qd_handle_on_cancel_clo 1711 1711 0 0.00 0 9490 311 0 0
sp_qd_handle_on_invoice_upd_sts 10853 10853 0 0.00 0 30592 340 0 0
sp_qd_handle_on_reserve_upd_sts 9735 9735 0 0.00 0 21670 52 0 0
sp_reserve_write_off 9735 9735 0 0.00 6 21715 174 0 0
sp_supplier_invoice 5387 5387 0 0.00 6 75519 3427 0 0
sp_supplier_order 5386 5386 0 0.00 6 47614 1323 0 0
srv_aggregate_perf_data 91 91 0 0.00 2984 687217 25870 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1198 151986 31979 0 0
srv_find_qd_qs_mism 1069098 1069098 0 0.00 0 12901 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 33 98281 1195 0 0
srv_make_money_saldo 810 810 0 0.00 0 697 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 190590 462302 320573 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4855 4855 0 0.00 0 11565 163 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 0 3293 80 0 0
t$perf-norm:sp_cancel_client_order 1711 1711 0 0.00 0 6600 24 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 3439 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 724 724 0 0.00 0 4411 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 351 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 9885 48 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 43316 1634 0 0
t$perf-norm:sp_cancel_write_off 934 934 0 0.00 0 7889 11 0 0
t$perf-norm:sp_client_order 19968 19968 0 0.00 0 18996 19 0 0
t$perf-norm:sp_customer_reserve 977 977 0 0.00 0 4994 11 0 0
t$perf-norm:sp_pay_from_customer 6888 6888 0 0.00 0 5893 14 0 0
t$perf-norm:sp_pay_to_supplier 5622 5622 0 0.00 0 19770 14 0 0
t$perf-norm:sp_reserve_write_off 9735 9735 0 0.00 0 9954 13 0 0
t$perf-norm:sp_supplier_invoice 5387 5387 0 0.00 0 12470 22 0 0
t$perf-norm:sp_supplier_order 5386 5386 0 0.00 0 9126 18 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 82 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 98 1 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 1241 18 0 0
t$perf-norm:srv_make_money_saldo 810 810 0 0.00 0 4535 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 6 0 0
v_add_invoice_to_stock 9942 9698 244 2.45 0 4716 21 0 244
v_all_customers 36504 36504 0 0.00 0 93 1 0 0
v_all_suppliers 29656 29656 0 0.00 0 18 1 0 0
v_all_wares 39936 39936 0 0.00 0 124 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 3870 18 0 0
v_cancel_client_order 3422 3422 0 0.00 0 4978 12 0 0
v_cancel_customer_prepayment 1448 1448 0 0.00 0 4113 8 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 5489 9 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 3806 15 0 0
v_cancel_supplier_invoice 846 820 26 3.07 0 4172 43 0 26
v_cancel_supplier_order 854 854 0 0.00 0 2531 9 0 0
v_cancel_write_off 1868 1868 0 0.00 0 3897 16 0 0
v_max_id_clo_ord 5385 5385 0 0.00 0 163 1 0 0
v_max_id_clo_res 977 977 0 0.00 0 4336 22 0 0
v_max_id_ord_sup 5380 5380 0 0.00 0 4116 4 0 0
v_max_non_paid_invoice 1558 1558 0 0.00 0 952 4 0 0
v_max_non_paid_realizn 3604 3604 0 0.00 0 4930 5 0 0
v_min_id_clo_ord 5385 5385 0 0.00 0 3623 6 0 0
v_min_id_clo_res 977 977 0 0.00 0 4950 18 0 0
v_min_id_ord_sup 5380 5380 0 0.00 0 7571 10 0 0
v_min_non_paid_invoice 5622 5622 0 0.00 0 14033 24 0 0
v_min_non_paid_realizn 6888 6888 0 0.00 0 24080 22 0 0
v_our_firm 10000 10000 0 0.00 0 11 1 0 0
v_reserve_write_off 19470 19470 0 0.00 0 5372 9 0 0
x_lock_depdocs_on_canc_invoice 12320 12320 0 0.00 0 11466 114 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 13367 410 0 0
x_make_qstorno_1000_1200 5386 5386 0 0.00 1 47608 1250 0 0
x_make_qstorno_1200_2000 5387 5387 0 0.00 2 75497 3279 0 0
x_make_qstorno_2100_3300 443792 443792 0 0.00 0 158964 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2021 19:28:39 to 15-02-2021 19:28:43.

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
16:57:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:24 11076 8192000000 10184311792 10484830208 776879776 8.661 64 49 97 0 795778608 2150096 16748736
16:57:45 31135 8192000000 10335930880 10649964544 1347591728 14.126 100 75 151 0 1376789088 4535920 24661440
16:58:26 28142 8192000000 10385535824 10704736256 1428876064 14.851 100 85 170 0 1463353088 6395056 28081968
16:59:06 31091 8192000000 10410427232 10739412992 1462992304 15.152 100 92 184 1 1500562800 7588928 29981568
16:59:45 21166 8192000000 10439844944 10770989056 1491970400 15.406 100 88 176 0 1528421520 8413120 28038000
17:00:21 17994 8192000000 10457006800 10788655104 1512624576 15.586 100 95 190 1 1552449216 9418784 30405856
17:01:00 21088 8192000000 10463050640 10798907392 1520177664 15.652 100 89 178 1 1559081408 10342784 28560960
17:01:30 15911 8192000000 10484040432 10827665408 1530166544 15.738 100 80 158 2 1568976576 14296208 24513824
17:01:57 15708 8192000000 10504555968 10855399424 1566176752 16.049 100 73 146 0 1598781840 10261184 22343904
17:02:20 12227 8192000000 10533699440 10883502080 1583107904 16.195 100 78 156 0 1617336960 10453696 23775360
17:02:46 12467 8192000000 10558303104 10914705408 1617152048 16.486 100 81 162 1 1653597920 11867120 24578752
17:03:05 11839 8192000000 10575495856 10935472128 1632353344 16.615 100 78 156 1 1668201088 12027952 23819792
17:03:26 10447 8192000000 10595559280 10958139392 1656064160 16.816 100 76 152 3 1690254896 12389264 21801472
17:03:45 8552 8192000000 10599161632 10970271744 1668824384 16.923 100 72 144 0 1701784112 11231008 21728720
17:04:02 10433 8192000000 10628392208 10996191232 1688929152 17.092 100 76 152 1 1722334640 11223616 22181872
17:04:21 8354 8192000000 10640081216 11012468736 1701127888 17.195 100 76 152 2 1735485680 12136864 22220928
17:04:36 6451 8192000000 10660841808 11035934720 1724284864 17.388 100 77 155 1 1758877056 12457360 22134832
17:04:53 8089 8192000000 10678194304 11050946560 1739600832 17.515 100 80 159 3 1774403872 12324432 22478608
17:05:08 4752 8192000000 10690302272 11065012224 1749504848 17.597 100 88 176 1 1788266640 13439424 25322368
17:05:20 5306 8192000000 10700427856 11082354688 1762124592 17.702 100 81 160 0 1797610992 12861744 22624656
17:05:33 4989 8192000000 10710695136 11097546752 1776404928 17.820 100 75 150 0 1809863776 12738096 20720752
17:05:45 4669 8192000000 10733532976 11112583168 1788728768 17.921 100 90 180 0 1827476240 13116144 25631328
17:05:57 3636 8192000000 10738552384 11117195264 1797145904 17.990 100 88 175 1 1835968896 14643296 24179696
17:06:07 4795 8192000000 10735925392 11122741248 1799787408 18.012 100 77 154 0 1835168544 14456512 20924624
17:06:21 3450 8192000000 10745109904 11128922112 1811173616 18.105 100 86 171 2 1850156448 15022768 23960064
17:06:31 3246 8192000000 10759125472 11145867264 1822533232 18.198 100 92 183 0 1866493520 18551696 25408592
17:06:41 3020 8192000000 10773466496 11158970368 1831620224 18.273 100 84 168 1 1869456128 14127296 23708608
17:06:51 3048 8192000000 10774544832 11162640384 1835825296 18.307 100 85 171 1 1873032896 12481984 24725616
17:07:00 2608 8192000000 10779558496 11168456704 1842246176 18.359 100 83 162 4 1877051856 12586080 22219600
17:07:09 2149 8192000000 10781500352 11169976320 1849669600 18.419 100 78 157 1 1883374432 11693440 22011392
17:07:18 1980 8192000000 10793650656 11183304704 1849520192 18.418 100 84 164 1 1885588368 12801056 23267120
17:07:27 2516 8192000000 10796671520 11184566272 1849780128 18.420 100 85 169 2 1886465552 13339536 23345888
17:07:36 2059 8192000000 10801129520 11189772288 1856814560 18.477 100 88 177 2 1895859504 14041504 25003440
17:07:45 1864 8192000000 10799197456 11189432320 1863374656 18.531 100 91 178 3 1902832272 14332304 25125312
17:07:53 2503 8192000000 10805501712 11191427072 1864920240 18.543 100 94 189 1 1905381728 13543552 26917936
17:08:02 1749 8192000000 10809842624 11200950272 1868608992 18.573 100 93 186 1 1907646272 12751760 26285520
17:08:12 1757 8192000000 10814371040 11200876544 1869058784 18.577 100 87 172 3 1905916160 12919408 23937968
17:08:20 2788 8192000000 10813844448 11206578176 1871071056 18.593 100 91 181 0 1910148896 13687392 25390448
17:08:30 2091 8192000000 10811045488 11204841472 1870688736 18.590 100 91 182 0 1910424544 13498896 26236912
17:08:39 1579 8192000000 10814726320 11208343552 1874599856 18.621 100 97 195 0 1916404288 14325984 27478448
17:08:48 1096 8192000000 10812501024 11203661824 1877695504 18.646 100 88 173 2 1915928720 12709648 25523568
17:08:56 1252 8192000000 10825888672 11214069760 1877814272 18.647 100 91 180 2 1914842480 12321792 24706416
17:09:03 2011 8192000000 10827558336 11215196160 1879331360 18.660 100 95 191 1 1920301856 13078896 27891600
17:09:13 5142 8192000000 10825203584 11219783680 1880993888 18.673 100 81 161 1 1916865520 13138304 22733328
17:09:25 1630 8192000000 10831634208 11221901312 1885023456 18.706 100 90 177 3 1924067136 13956944 25086736
17:09:33 3256 8192000000 10814369504 11217846272 1877818272 18.647 100 58 115 1 1905355712 11300704 16236736
17:09:47 2832 8192000000 10809770592 11216027648 1878814368 18.656 100 53 106 0 1904623472 10452256 15356848
17:09:58 5060 8192000000 10783838176 11212754944 1877996368 18.649 100 40 78 4 1897770640 8725264 11049008
17:10:10 6075 8192000000 10794969440 11213238272 1881235952 18.675 100 48 95 1 1901733568 7492192 13005424
17:10:26 10098 8192000000 10794664800 11207864320 1877630160 18.646 100 25 51 0 1890930432 6166368 7133904
17:10:42 10855 8192000000 10789223904 11219042304 1880666688 18.670 100 20 41 0 1892684368 6513888 5503792
17:11:02 8203 8192000000 10797666016 11223306240 1886967680 18.721 100 35 70 0 1905175600 7878464 10329456
17:11:16 56288 8192000000 10821342560 11238203392 1891650832 18.759 100 44 88 3 1911278112 7579584 12047696
17:12:21 6573 8192000000 10799768672 11236597760 1893957728 18.778 100 32 64 2 1910690544 7493088 9239728
17:12:40 9709 8192000000 10817961856 11241316352 1895319472 18.789 100 25 50 1 1908544736 6015360 7209904
17:12:57 5168 8192000000 10819769824 11246219264 1897704592 18.808 100 40 75 1 1916370432 7529504 11136336
17:13:09 6351 8192000000 10813298656 11242782720 1897656416 18.807 100 28 56 1 1916485824 10548064 8281344
17:13:23 8083 8192000000 10805793488 11244789760 1895874704 18.793 100 19 38 1 1907266384 6058960 5332720
17:13:37 5686 8192000000 10823096256 11253858304 1902547104 18.847 100 32 64 1 1917696336 5922320 9226912
17:13:50 7282 8192000000 10814731744 11250724864 1906755824 18.881 100 28 52 1 1919971744 5512448 7703472
17:14:04 7546 8192000000 10828289504 11255201792 1905397552 18.870 100 25 48 3 1918362480 5415936 7548992
17:14:18 7073 8192000000 10818549520 11254902784 1906423264 18.878 100 22 44 1 1918669792 6159328 6087200
17:14:31 6803 8192000000 10820325264 11251089408 1905619936 18.871 100 17 34 1 1916108512 5256624 5231952
17:14:46 11385 8192000000 10819192880 11255365632 1908787824 18.897 100 17 32 2 1918149024 5197184 4164016
17:15:05 10089 8192000000 10817859168 11257114624 1910119632 18.908 100 26 53 5 1923304560 5384000 7800928
17:15:22 8197 8192000000 10816493600 11257462784 1912054544 18.923 100 17 34 0 1922596256 5707776 4833936
17:15:36 12502 8192000000 10826267728 11264987136 1914347856 18.942 100 15 30 1 1928722144 9808048 4566240
17:15:55 8264 8192000000 10824531216 11258929152 1912722576 18.928 100 28 56 0 1926671920 5723008 8226336
17:16:14 79167 8192000000 10810239200 11249328128 1838850752 18.331 96 25 50 0 1852443152 5047712 8544688
17:17:40 5539 8192000000 10794144624 11220029440 1811190416 18.106 95 27 54 1 1824203696 6291200 6722080
17:17:53 6346 8192000000 10744030624 11167113216 1799749936 18.012 97 30 59 2 1814806272 6564880 8491456
17:18:07 3537 8192000000 10759022512 11182858240 1801766800 18.028 97 32 64 2 1818051904 6943344 9341760
17:18:16 9076 8192000000 10741758752 11162832896 1755471296 17.647 95 27 54 0 1769732944 5923184 8338464
17:18:32 7917 8192000000 10753358576 11180654592 1800657808 18.019 97 31 62 2 1816495696 6455968 9381920
17:18:47 4108 8192000000 10772259248 11194949632 1838543360 18.329 99 31 61 2 1856909488 9713984 8652144
17:18:57 11816 8192000000 10719493328 11147726848 1717392112 17.330 93 16 32 1 1727091920 5490192 4209616
17:19:15 11898 8192000000 10735993616 11153711104 1756230960 17.653 96 26 50 2 1770190176 5699360 8259856
17:19:33 4518 8192000000 10709791120 11124662272 1709103328 17.261 94 22 44 1 1719987744 4887376 5997040
17:19:44 9825 8192000000 10700465008 11123675136 1714612704 17.307 95 13 24 1 1727977248 9869952 3494592
17:20:00 8186 8192000000 10704204368 11123621888 1768384288 17.754 98 27 54 0 1783752032 5999824 9367920
17:20:16 12060 8192000000 10701312192 11115520000 1723456592 17.381 96 23 46 1 1735553824 5385616 6711616
17:20:38 9094 8192000000 10718942352 11121156096 1752619296 17.623 98 28 57 0 1766284688 4965072 8700320
17:20:57 15146 8192000000 10720538192 11133763584 1797075728 17.990 100 26 50 2 1811051216 5194064 8781424
17:21:19 58174 8192000000 10740253408 11160743936 1786117520 17.900 98 32 59 1 1799533200 5100304 8315376
17:22:23 9081 8192000000 10720982384 11141509120 1779199376 17.843 98 27 53 1 1792792640 6245776 7347488
17:22:39 7908 8192000000 10711402272 11121504256 1792025072 17.948 99 24 47 2 1804349792 4872144 7452576
17:22:57 7496 8192000000 10747054272 11168247808 1828529360 18.247 100 26 52 0 1841794208 5368736 7896112
17:23:11 7826 8192000000 10736456672 11160670208 1813657856 18.126 99 20 40 0 1824766048 5341136 5767056
17:23:25 7787 8192000000 10746417952 11169943552 1819972112 18.177 99 29 58 2 1834251456 5507904 8771440
17:23:40 9717 8192000000 10754818544 11180261376 1828789200 18.249 99 33 66 2 1844408448 6555696 9063552
17:23:56 8524 8192000000 10767509696 11188891648 1845594176 18.386 100 28 56 0 1860127952 5754688 8779088
17:24:12 7680 8192000000 10771168928 11194204160 1850247328 18.424 100 23 46 1 1862063328 5568656 6247344
17:24:26 7985 8192000000 10768288832 11195695104 1854801504 18.461 100 14 28 0 1864259104 5860320 3597280
17:24:43 10641 8192000000 10778953104 11202179072 1858492304 18.491 100 17 34 0 1868975696 5661088 4822304
17:25:06 7320 8192000000 10774792480 11204825088 1861257632 18.513 100 19 38 2 1871888528 5412032 5218864
17:25:21 8589 8192000000 10775494016 11204648960 1864526192 18.540 100 21 41 0 1876527536 5126912 6874432
17:25:38 13738 8192000000 10780809088 11210002432 1866768256 18.558 100 20 41 1 1878206944 5404912 6033776
17:26:03 39000 8192000000 10775129152 11215843328 1868633040 18.573 100 18 36 1 1879543168 5648032 5262096
17:27:01 66370 8192000000 10832734096 11259760640 1893230640 18.772 100 35 70 1 1909694400 5932704 10531056
17:28:15 22320 8192000000 10836765136 11266490368 1913882752 18.938 100 43 81 4 1932252784 6497952 11872080
17:28:56 21720 8192000000 10858957456 11288072192 1921468608 18.999 100 31 62 0 1936174400 6140480 8565312
17:29:24 10453 8192000000 10866075744 11295621120 1935136752 19.108 100 40 76 1 1953347824 7373168 10837904
17:29:42 25687 8192000000 10879098048 11304869888 1947290528 19.205 100 59 118 2 1974729440 10211568 17227344
17:30:16 6269 8192000000 10893021424 11318616064 1951829904 19.241 100 58 114 2 1980082912 12197120 16055888
17:30:30 14058 8192000000 10896054832 11325009920 1955451680 19.270 100 59 118 2 1987087600 14147792 17488128
17:30:52 21000 8192000000 10894735136 11325071360 1955493840 19.270 100 45 90 0 1981762736 13571152 12697744
17:31:20 19821 8192000000 10899899392 11336654848 1958615440 19.295 100 50 101 0 1994352528 21485744 14251344
17:31:49 23656 8192000000 10887709728 11333722112 1958796176 19.296 100 36 72 1 1986132144 16181040 11154928
17:32:21 13411 8192000000 10894120304 11333476352 1962927072 19.329 100 36 72 3 1988522976 13918384 11677520
17:32:42 3026 8192000000 10929172208 11349487616 1975497344 19.429 100 82 162 1 2019373488 19350304 24525840
17:32:53 11465 8192000000 10916633184 11345944576 1971958096 19.401 100 57 114 1 2006962240 17699904 17304240
17:33:12 9163 8192000000 10913832800 11345485824 1971225392 19.395 100 52 102 0 2004359312 18543936 14589984
17:33:35 15111 8192000000 10920196880 11357233152 1974292576 19.419 100 54 108 2 2010741472 21308208 15140688
17:34:00 14061 8192000000 10930801280 11361742848 1982047056 19.481 100 54 108 0 2015053008 17114672 15891280
17:34:25 15018 8192000000 10932845984 11365306368 1988404416 19.531 100 53 106 1 2021228864 17338208 15486240
17:34:50 10017 8192000000 10932173728 11372142592 1993739984 19.573 100 56 112 3 2027888400 17920304 16228112
17:35:09 12151 8192000000 10935924608 11372421120 1999233984 19.617 100 60 121 2 2035880576 18826464 17820128
17:35:31 1984 8192000000 10962252288 11383083008 2002137168 19.640 100 77 155 2 2044950640 19743200 23070272
17:35:41 2810 8192000000 10963012320 11389485056 2002217632 19.640 100 71 142 0 2046413568 22671216 21524720
17:35:52 2851 8192000000 10950139296 11376955392 1996628176 19.596 100 72 142 0 2038664560 21678256 20358128
17:36:06 3247 8192000000 10954094288 11376111616 1997519984 19.603 100 70 139 3 2039372688 21928256 19924448
17:36:19 22910 8192000000 10943392544 11383812096 1997872080 19.606 100 60 118 1 2036997696 20928320 18197296
17:36:49 9772 8192000000 10947692160 11391840256 2002440384 19.642 100 46 90 0 2040365536 24294480 13630672
17:37:09 12773 8192000000 10953676384 11396939776 2013251744 19.727 100 50 99 0 2049816624 21027008 15537872
17:37:37 9786 8192000000 10967064000 11405266944 2016581328 19.753 100 59 118 1 2058593120 23632464 18379328
17:37:54 6128 8192000000 10965686160 11396993024 1998692336 19.612 99 68 137 3 2045522288 24924064 21905888
17:38:11 5388 8192000000 10959928880 11389386752 2000053520 19.623 100 66 130 1 2046219104 25696336 20469248
17:38:25 8939 8192000000 10962169440 11399049216 2004711488 19.660 100 57 109 2 2046821744 24918400 17191856
17:38:42 3845 8192000000 10945482304 11378106368 1991595040 19.556 99 60 119 3 2036565264 26500144 18470080
17:38:54 4149 8192000000 10952872176 11387092992 1999626384 19.620 100 61 121 1 2042002352 23254816 19121152
17:39:06 10520 8192000000 10958445072 11390537728 1999748672 19.621 100 75 150 2 2049445840 26999264 22697904
17:39:31 7106 8192000000 10966437872 11401646080 2007745600 19.684 100 60 120 0 2055346608 28749008 18852000
17:39:45 3222 8192000000 10979662080 11405651968 2013445968 19.729 100 79 155 1 2067189680 29864416 23879296
17:39:55 2580 8192000000 10981485712 11405168640 2009281792 19.696 100 80 161 0 2063270320 29545808 24442720
17:40:05 13205 8192000000 10961759472 11391197184 1984340400 19.499 99 64 128 1 2034639072 29970576 20328096
17:40:25 4309 8192000000 10988385552 11405488128 2009111040 19.695 100 78 156 1 2064640208 31377584 24151584
17:40:37 5016 8192000000 10971486528 11400953856 2005311024 19.665 100 67 134 0 2058471776 32291120 20869632
17:40:48 3854 8192000000 10982723936 11401244672 2004296240 19.657 100 84 166 3 2063258960 33223840 25738880
17:41:00 3222 8192000000 10956256240 11371094016 1958295824 19.292 98 82 163 0 2015728960 32324496 25108640
17:41:11 4658 8192000000 10951179136 11367751680 1951993392 19.242 99 81 161 0 2009924768 33566064 24365312
17:41:24 5170 8192000000 10956960992 11378438144 1981783472 19.479 100 67 133 4 2035112336 32909200 20419664
17:41:39 3743 8192000000 10961248672 11385040896 1988985472 19.536 100 67 134 0 2045883456 36590368 20307616
17:41:54 7164 8192000000 10970288704 11387658240 1987483888 19.524 100 82 164 0 2049944016 37527152 24932976
17:42:09 4745 8192000000 10966068160 11392270336 1991434304 19.555 100 72 144 3 2052183088 38241040 22507744
17:42:42 4574 8192000000 10972558176 11398672384 1992239344 19.561 100 66 132 0 2054821312 41134128 21447840
17:42:56 4733 8192000000 10970056816 11390857216 1967613264 19.367 98 71 141 5 2028846112 39192352 22040496
17:43:10 2838 8192000000 10982300400 11404632064 2001262704 19.633 100 76 152 0 2063310928 37904432 24143792
17:43:20 4721 8192000000 10975593856 11402072064 1996589216 19.596 100 74 148 1 2059498448 39337904 23571328
17:43:32 3708 8192000000 10976596896 11393044480 1984964880 19.504 99 90 178 2 2055344128 42098864 28280384
17:43:46 2746 8192000000 10973634784 11397689344 1963901024 19.337 98 71 142 2 2029289712 42528928 22859760
17:43:57 3910 8192000000 10983685808 11396554752 1975599824 19.430 99 75 148 2 2043640032 45003488 23036720
17:44:08 3727 8192000000 10984625312 11398389760 1977271184 19.443 99 82 161 2 2049252832 46015040 25966608
17:44:19 5683 8192000000 10975272320 11398922240 1990340752 19.546 100 67 131 2 2057236432 45747920 21147760
17:44:33 1908 8192000000 10990758608 11402203136 1996907984 19.598 100 83 164 1 2070399424 47138880 26352560
17:44:43 5069 8192000000 11005549232 11421253632 2001590992 19.635 100 85 169 2 2077026016 48505168 26929856
17:44:56 6318 8192000000 11011652496 11431931904 2014416560 19.736 100 78 156 1 2090405392 50818576 25170256
17:45:10 3410 8192000000 10995746128 11417395200 2006681440 19.675 100 80 161 1 2077044256 44720016 25642800
17:45:22 3005 8192000000 11007472752 11421466624 2013543376 19.729 100 90 178 0 2085473408 43828448 28101584
17:45:32 1537 8192000000 10966444928 11375382528 1955129248 19.267 98 88 173 3 2027054608 44294736 27630624
17:45:40 3110 8192000000 10979362912 11392528384 1982998352 19.488 100 85 169 1 2055982576 46028576 26955648
17:45:50 2357 8192000000 10981046640 11391717376 1985352704 19.507 100 85 169 1 2056590128 44891904 26345520
17:45:59 1194 8192000000 10994346112 11406659584 1998181584 19.608 100 91 181 0 2072955056 46667408 28106064
17:46:07 2083 8192000000 10970388800 11382046720 1971594816 19.398 99 87 174 1 2046029376 47486160 26948400
17:46:17 2592 8192000000 10975174352 11396534272 1983470576 19.492 100 75 150 0 2055526928 48436640 23619712
17:46:26 4921 8192000000 10957275728 11388080128 1958236384 19.292 99 63 126 0 2030520896 51422096 20862416
17:46:41 7905 8192000000 10943429376 11371737088 1950219488 19.228 100 55 110 2 2021455488 52691328 18544672
17:47:07 8674 8192000000 10932121008 11366432768 1945479248 19.190 100 48 96 0 2019953840 56812592 17662000
17:47:37 6608 8192000000 10946281536 11379830784 1952327072 19.245 100 49 98 2 2030030784 59581920 18121792
17:47:57 11496 8192000000 10948860720 11393630208 1960511632 19.310 100 51 102 1 2041459632 62599216 18348784
17:48:24 25667 8192000000 10943235408 11389116416 1946048768 19.195 99 38 76 2 2009704560 50236336 13419456
17:49:07 25006 8192000000 10920419184 11383992320 1966054304 19.354 100 32 64 0 2016888096 40487360 10346432
17:49:39 20803 8192000000 10921700000 11379482624 1961043552 19.314 100 22 44 1 2006936800 38079456 7813792
17:50:07 19443 8192000000 10929225504 11380113408 1967380784 19.365 100 36 70 3 2016667232 37723504 11562944
17:50:41 27895 8192000000 10928060800 11391684608 1964042960 19.338 100 23 46 0 2013054784 41033280 7978544
17:51:23 12071 8192000000 10948437216 11392860160 1970258192 19.387 100 33 66 5 2027406448 45004176 12144080
17:51:43 42783 8192000000 10930165024 11400134656 1926702128 19.041 98 26 52 0 1992213008 55347696 10163184
17:53:06 56708 8192000000 10901323296 11357130752 1938152448 19.132 100 11 22 3 1956296976 14870112 3274416
17:54:09 43077 8192000000 10867445008 11337203712 1865435424 18.547 96 22 44 0 1892777184 21240480 6101280
17:54:59 46655 8192000000 10851692512 11328598016 1910847088 18.913 99 10 20 2 1940644256 26530736 3266432
17:56:05 108154 8192000000 10879989600 11337977856 1910503872 18.911 98 32 63 1 1928802224 9800848 8497504
17:58:01 87155 8192000000 10888761456 11349512192 1925339120 19.030 98 41 82 1 1949950096 13700304 10910672
17:59:35 40429 8192000000 10914247152 11360669696 1965578976 19.350 100 34 66 5 1981616384 7757744 8279664
18:00:24 37252 8192000000 10906545104 11361972224 1957732160 19.288 99 27 54 2 1974548912 9910768 6905984
18:01:35 24376 8192000000 10857870064 11315888128 1924835472 19.026 98 24 48 2 1945183616 12744080 7604064
18:02:09 38357 8192000000 10879906032 11334680576 1915972464 18.955 98 17 34 0 1931030928 10233120 4825344
18:03:02 52217 8192000000 10892897856 11348615168 1924578736 19.024 98 38 77 0 1947701248 12092544 11029968
18:04:06 26162 8192000000 10873602704 11326648320 1922964240 19.011 99 18 36 0 1943829792 15316800 5548752
18:05:00 18118 8192000000 10880033776 11345899520 1938942176 19.138 99 20 40 1 1960425248 15480944 6002128
18:05:25 106909 8192000000 10882879824 11348455424 1918332352 18.973 98 9 18 0 1933500032 12288208 2879472
18:07:27 82599 8192000000 10887747936 11359698944 1952055984 19.243 99 10 20 0 1967601120 12662080 2883056
18:09:03 50675 8192000000 10884598368 11360845824 1948213168 19.212 99 14 28 1 1965741168 13292896 4235104
18:10:27 72700 8192000000 10887421392 11363643392 1973137632 19.410 100 23 46 1 1985416672 5868752 6410288
18:11:49 26279 8192000000 10898384480 11371630592 1982169312 19.482 100 6 12 0 1990035248 6558672 1307264
18:12:29 28955 8192000000 10914898784 11374190592 1955297056 19.269 98 42 81 3 1972560704 6574880 10688768
18:13:06 44709 8192000000 10906754848 11380772864 1971874096 19.400 99 21 42 1 1992280128 13560080 6845952
18:13:59 60199 8192000000 10916763248 11395379200 1987976224 19.528 100 16 32 0 2006677568 13532512 5168832
18:16:07 44917 8192000000 10904635792 11387449344 1970014064 19.386 99 12 24 0 1985180448 11525808 3640576
18:17:08 22444 8192000000 10926054224 11392491520 1993759120 19.573 100 20 40 0 2007590928 8472816 5358992
18:17:45 48283 8192000000 10924372128 11391488000 1967468352 19.365 98 36 70 1 1990921920 14310416 9143152
18:18:44 59565 8192000000 10916906176 11392172032 1958055632 19.291 98 22 44 3 1981902720 16771872 7075216
18:19:51 65212 8192000000 10916897856 11402178560 1993625504 19.572 100 19 39 2 2016425760 17691184 5109072
18:21:02 109362 8192000000 10905896784 11380727808 1908830688 18.897 96 9 18 1 1929647040 18269472 2546880
18:22:58 43120 8192000000 10916674000 11377545216 1963676256 19.335 99 22 44 1 1987161136 17174096 6310784
18:23:48 43829 8192000000 10923946896 11385483264 1954669712 19.264 98 40 79 3 1984087536 17587584 11830240
18:24:43 59106 8192000000 10934298176 11397152768 1988182432 19.529 100 26 52 0 2012830048 17229216 7418400
18:26:05 102017 8192000000 10935578304 11422527488 1956659568 19.279 98 8 16 0 1976436192 18038944 1737680
18:28:05 73605 8192000000 10911292160 11376230400 1910654656 18.912 96 9 18 2 1930886832 18421776 1810400
18:29:28 104420 8192000000 10873465248 11324190720 1846552160 18.394 93 23 41 1 1860654832 8300640 5802032
18:31:19 36878 8192000000 10846114016 11324915712 1891905824 18.761 97 36 72 0 1909801584 8021552 9874208
18:32:13 49490 8192000000 10861257520 11338608640 1933299648 19.093 99 4 8 0 1939806064 5711104 795312
18:33:09 7139 8192000000 10857786416 11337170944 1945733168 19.192 100 4 8 0 1954210128 7535696 941264
18:33:23 16039 8192000000 10874046336 11353747456 1945614720 19.192 100 7 14 0 1953116848 6122096 1380032
18:33:51 52478 8192000000 10883176208 11368325120 1939674624 19.144 99 10 20 0 1953488512 11126496 2687392
18:34:52 43872 8192000000 10893386336 11364069376 1958478144 19.294 100 21 41 1 1979161776 14529984 6153648
18:35:50 77109 8192000000 10869519728 11335544832 1857819344 18.486 95 15 31 0 1876659008 14479696 4359968
18:37:14 43788 8192000000 10870544464 11341832192 1907112080 18.883 98 17 34 0 1921402128 8924160 5365888
18:38:15 42162 8192000000 10865178016 11320651776 1898698720 18.816 97 38 74 0 1917824592 7798464 11327408
18:39:07 46571 8192000000 10858660480 11323293696 1866031232 18.552 96 32 64 1 1888179456 13496144 8652080
18:39:59 75425 8192000000 10888945408 11359436800 1932694544 19.088 99 15 30 1 1956507952 19148016 4665392
18:42:35 76526 8192000000 10889964848 11362095104 1951244304 19.236 100 23 46 0 1971749072 14101920 6402848
18:43:59 34620 8192000000 10906623472 11366809600 1961332016 19.317 100 15 30 1 1979051696 13528800 4190880
18:45:19 74211 8192000000 10912956864 11365634048 1933123424 19.092 98 23 45 2 1952874064 13513808 6236832
18:46:40 68700 8192000000 10911502192 11373961216 1933252720 19.093 98 31 61 2 1956370672 13665536 9452416
18:47:58 62575 8192000000 10883877840 11368923136 1906289184 18.877 97 17 34 1 1924140112 13410848 4440080
18:49:23 100554 8192000000 10868859200 11336101888 1934977696 19.107 99 18 37 0 1949508096 8843760 5686640
18:51:49 59371 8192000000 10885475328 11347542016 1921123216 18.996 98 29 58 2 1939471344 10179136 8168992
18:53:00 24684 8192000000 10870722976 11338764288 1928795424 19.057 99 23 46 1 1944578112 9613536 6169152
18:53:31 36349 8192000000 10858949408 11333386240 1922358752 19.006 99 24 48 0 1938359664 9041472 6959440
18:54:15 37360 8192000000 10864800256 11343007744 1941910752 19.162 100 8 14 0 1949878864 6469584 1498528
18:55:09 58324 8192000000 10865170448 11342508032 1944382544 19.182 100 25 50 0 1959479232 8312096 6784592
18:56:15 49839 8192000000 10858533728 11333328896 1890480736 18.750 97 19 38 1 1905012928 8978800 5553392
18:57:12 70272 8192000000 10858692624 11340259328 1928246128 19.053 99 12 22 1 1941200752 9966368 2988256
18:58:31 24938 8192000000 10869961616 11353108480 1948849488 19.217 100 6 12 0 1959124112 8470288 1804336
18:59:05 37120 8192000000 10878740736 11351154688 1935317296 19.109 99 16 32 0 1952538272 12612080 4608896
19:00:06 54432 8192000000 10897754768 11373375488 1955293488 19.269 100 13 26 0 1977132576 18400288 3438800
19:01:11 43978 8192000000 10885304608 11373182976 1943578112 19.175 99 14 28 0 1965036896 17395552 4063232
19:02:01 64347 8192000000 10865555360 11330883584 1857685088 18.485 95 13 26 0 1874673056 13125760 3862208
19:03:11 79043 8192000000 10862163120 11343085568 1867845744 18.567 96 18 35 1 1879926640 7512240 4568656
19:04:36 21160 8192000000 10885003328 11349127168 1941904576 19.162 99 32 65 1 1958583504 7950176 8728752
19:05:10 18321 8192000000 10899286944 11361574912 1965966144 19.353 100 23 46 0 1983212688 10548528 6698016
19:05:36 30832 8192000000 10899798576 11372265472 1954911104 19.266 99 33 65 2 1979925408 14869312 10144992
19:06:18 10768 8192000000 10903088432 11361636352 1955061152 19.267 99 51 103 1 1980187728 10685456 14441120
19:06:35 31688 8192000000 10910782848 11383029760 1974789696 19.423 100 47 94 2 2008544784 20484672 13270416
19:07:16 21369 8192000000 10900291248 11366461440 1946543216 19.199 99 21 42 1 1965905024 12964576 6397232
19:07:54 63159 8192000000 10886786128 11363061760 1928173872 19.052 98 11 21 0 1947611648 16635024 2802752
19:09:04 53720 8192000000 10891259344 11354734592 1915643376 18.952 98 14 27 0 1932592208 12758928 4189904
19:10:15 36644 8192000000 10904090000 11359948800 1931178512 19.076 98 40 80 1 1951633760 9207344 11247904
19:11:02 28082 8192000000 10882405008 11346251776 1908576832 18.895 97 33 65 0 1930309152 12697728 9034592
19:11:37 20578 8192000000 10896546272 11344433152 1928013520 19.051 99 33 65 2 1947650400 10763200 8873680
19:12:09 18599 8192000000 10906138592 11358085120 1926574992 19.039 98 47 94 0 1953115344 13777312 12763040
19:12:38 24595 8192000000 10885157744 11347890176 1910877792 18.914 98 41 82 1 1938580880 16522512 11180576
19:13:08 151986 8192000000 10884412656 11344093184 1932332752 19.086 99 21 42 0 1953864912 15848496 5683664
19:17:00 51464 8192000000 10859069248 11330138112 1911568432 18.919 98 28 56 0 1929998400 10432480 7997488
19:18:03 100630 8192000000 10857859584 11338534912 1916801776 18.961 99 9 18 0 1935120672 15381920 2936976
19:19:50 34001 8192000000 10857670016 11335532544 1921604896 19.000 99 9 18 0 1934290128 10428752 2256480
19:20:58 47296 8192000000 10888773440 11349016576 1924893680 19.026 98 24 49 1 1950159696 17599040 7666976
19:21:59 61640 8192000000 10887589312 11354689536 1936044800 19.115 99 23 44 0 1959169312 16557040 6567472
19:23:07 87496 8192000000 10880521376 11375058944 1951284944 19.237 100 12 24 3 1973737664 18921952 3530768
19:25:12 52794 8192000000 10871309040 11346694144 1911517152 18.919 98 11 22 0 1930691040 15856064 3317824
19:26:13 47484 8192000000 10886124944 11352952832 1931596592 19.080 99 17 34 1 1945824000 9273616 4953792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-02-2021 19:28:44 to 15-02-2021 19:29:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-02-2021 19:29:17 to 15-02-2021 19:29:19.

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          233261
MON$OLDEST_ACTIVE               235372
MON$OLDEST_SNAPSHOT             235372
MON$NEXT_TRANSACTION            235372
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                       2018368
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:419: 
:420: mscs-test-161.budzdorov.ru    Mon Feb 15 19:27:15 2021
:421:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:422: 
:423: 
:424: mscs-test-161.budzdorov.ru    Mon Feb 15 19:27:17 2021
:425:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:426: 
:427: 
:428: mscs-test-161.budzdorov.ru    Mon Feb 15 19:27:18 2021
:429:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:430: 
:431: 
:432: mscs-test-161.budzdorov.ru    Mon Feb 15 19:27:18 2021
:433:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:434: 
:435: 
:436: mscs-test-161.budzdorov.ru    Mon Feb 15 19:27:18 2021
:437:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:438: 
--- end of diff output ---

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

15.02.21 19:29:20. 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-15 19:29:22 No severe PSQL-related problems occured
15.02.21 19:29:24. End of report.