Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.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 16760092 kB
MemAvailable 31116864 kB
Buffers 0 kB
Cached 14953048 kB
SwapCached 3312 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-27 22:27:20
DTS_END                         2021-02-27 22:27:20.2300
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55444
TRN_ID                          245590
ATT_ID                          630
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: 9123.45 22657 1094814
customer order: creation 171.98 371 20638
customer order: refuse 15.33 343 1839
order to supplier: creation 46.00 1442 5520
order to supplier: removal 3.47 97983 416
invoice (draft): creation 47.05 3832 5646
invoice (draft): removal 51.93 823 6232
invoice accept: apply 42.28 18642 5074
invoice accept: cancel 46.28 816 5553
customer reserve: creation 3843.40 187 461208
customer reserve: removal 4567.37 58 548084
realization accept: apply 83.15 185 9978
realization accept: cancel 75.68 104 9082
payment from customer: creation 59.68 111 7162
payment from customer: removal 5.91 96 709
payment to supplier: creation 48.39 151 5807
payment to supplier: removal 3.58 92 430
service: total inventory turnovers 4.68 1138 561
service: total monetary turnovers 6.45 24 774
service: aggregate perf. data 0.81 18521 97
service: refresh index statistics 0.03 308216 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2021 22:28:45 to 27-02-2021 22:28:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4683
TEST_TIME 2 4355
TEST_TIME 3 3846
TEST_TIME 4 3410
TEST_TIME 5 3989
TEST_TIME 6 4357
TEST_TIME 7 4679
TEST_TIME 8 5454
TEST_TIME 9 5771
TEST_TIME 10 5868
TEST_TIME 11 6008
TEST_TIME 12 6065
TEST_TIME 13 6962
TEST_TIME 14 6927
TEST_TIME 15 7068
TEST_TIME 16 7135
TEST_TIME 17 7204
TEST_TIME 18 7397
TEST_TIME 19 7762
TEST_TIME 20 8055
TEST_TIME 21 8357
TEST_TIME 22 8313
TEST_TIME 23 8488
TEST_TIME 24 8659
TEST_TIME 25 9237
TEST_TIME 26 9682
TEST_TIME 27 10482
TEST_TIME 28 10784
TEST_TIME 29 10747
TEST_TIME 30 10744
TEST_TIME 31 10526
TEST_TIME 32 10363
TEST_TIME 33 10290
TEST_TIME 34 10162
TEST_TIME 35 10093
TEST_TIME 36 10129
TEST_TIME 37 9923
TEST_TIME 38 9900
TEST_TIME 39 9814
TEST_TIME 40 9782
TEST_TIME 41 9734
TEST_TIME 42 9732
TEST_TIME 43 9758
TEST_TIME 44 9751
TEST_TIME 45 9672
TEST_TIME 46 9537
TEST_TIME 47 9505
TEST_TIME 48 9554
TEST_TIME 49 9438
TEST_TIME 50 9357
TEST_TIME 51 9392
TEST_TIME 52 9417
TEST_TIME 53 9403
TEST_TIME 54 9407
TEST_TIME 55 9413
TEST_TIME 56 9600
TEST_TIME 57 9538
TEST_TIME 58 9601
TEST_TIME 59 9585
TEST_TIME 60 9674
TEST_TIME 61 9641
TEST_TIME 62 9648
TEST_TIME 63 9662
TEST_TIME 64 9530
TEST_TIME 65 9485
TEST_TIME 66 9452
TEST_TIME 67 9418
TEST_TIME 68 9354
TEST_TIME 69 9382
TEST_TIME 70 9349
TEST_TIME 71 9296
TEST_TIME 72 9258
TEST_TIME 73 9218
TEST_TIME 74 9230
TEST_TIME 75 9244
TEST_TIME 76 9279
TEST_TIME 77 9346
TEST_TIME 78 9402
TEST_TIME 79 9388
TEST_TIME 80 9416
TEST_TIME 81 9482
TEST_TIME 82 9534
TEST_TIME 83 9506
TEST_TIME 84 9423
TEST_TIME 85 9377
TEST_TIME 86 9341
TEST_TIME 87 9329
TEST_TIME 88 9343
TEST_TIME 89 9287
TEST_TIME 90 9243
TEST_TIME 91 9231
TEST_TIME 92 9176
TEST_TIME 93 9189
TEST_TIME 94 9189
TEST_TIME 95 9190
TEST_TIME 96 9175
TEST_TIME 97 9213
TEST_TIME 98 9199
TEST_TIME 99 9265
TEST_TIME 100 9239
TEST_TIME 101 9272
TEST_TIME 102 9398
TEST_TIME 103 9375
TEST_TIME 104 9425
TEST_TIME 105 9442
TEST_TIME 106 9466
TEST_TIME 107 9408
TEST_TIME 108 9351
TEST_TIME 109 9314
TEST_TIME 110 9342
TEST_TIME 111 9297
TEST_TIME 112 9271
TEST_TIME 113 9248
TEST_TIME 114 9236
TEST_TIME 115 9210
TEST_TIME 116 9186
TEST_TIME 117 9154
TEST_TIME 118 9147
TEST_TIME 119 9193
TEST_TIME 120 9130

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-02-2021 22:28:48 to 27-02-2021 22:28:52.

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 1522861 1522861 0 0.00 0 24943 7 0 0
doc_list_biud 1522860 1522860 0 0.00 0 32530 27 0 0
sp_add_invoice_to_stock 5196 5074 122 2.34 56 215934 18643 0 122
sp_cancel_adding_invoice 5553 5553 0 0.00 4 72226 817 0 0
sp_cancel_client_order 1839 1839 0 0.00 5 15171 344 0 0
sp_cancel_customer_reserve 548084 548084 0 0.00 1 31508 58 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 3 4748 96 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 2 7377 92 0 0
sp_cancel_supplier_invoice 6240 6232 8 0.12 2 32536 824 0 8
sp_cancel_supplier_order 416 416 0 0.00 7 1198188 97983 0 0
sp_cancel_write_off 9082 9082 0 0.00 1 27073 105 0 0
sp_client_order 20638 20638 0 0.00 4 22790 371 0 0
sp_customer_reserve 461208 461208 0 0.00 0 42679 187 0 0
sp_fill_shopping_cart 31794 31794 0 0.00 1 14801 39 0 0
sp_fill_shopping_cart_clo_res 461194 461194 0 0.00 0 15766 14 0 0
sp_get_clo_for_invoice 5060 5060 0 0.00 0 18843 255 0 0
sp_kill_cost_storno 15774 15774 0 0.00 0 7370 53 0 0
sp_kill_qstorno_ret_qs2qd 1111898 1111898 0 0.00 0 32527 32 0 0
sp_kill_qty_storno 586243 586243 0 0.00 0 32529 69 0 0
sp_lock_selected_doc 20867 20867 0 0.00 0 9416 5 0 0
sp_make_cost_storno 28007 28007 0 0.00 0 24788 58 0 0
sp_multiply_rows_for_pdistr 28007 28007 0 0.00 0 7675 33 0 0
sp_multiply_rows_for_qdistr 20638 20638 0 0.00 0 11360 152 0 0
sp_pay_from_customer 7162 7162 0 0.00 4 11527 112 0 0
sp_pay_to_supplier 5807 5807 0 0.00 5 14662 151 0 0
sp_payment_common 12969 12969 0 0.00 1 12161 28 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 1 15151 321 0 0
sp_qd_handle_on_invoice_upd_sts 10612 10612 0 0.00 0 30361 332 0 0
sp_qd_handle_on_reserve_upd_sts 9978 9978 0 0.00 0 27096 61 0 0
sp_reserve_write_off 9978 9978 0 0.00 6 27157 186 0 0
sp_supplier_invoice 5646 5646 0 0.00 6 86410 3832 0 0
sp_supplier_order 5520 5520 0 0.00 5 28044 1442 0 0
srv_aggregate_perf_data 97 97 0 0.00 2734 151804 18522 0 0
srv_fill_mon_cache_memory 178 178 0 0.00 939 122642 29438 0 0
srv_find_qd_qs_mism 1047505 1047505 0 0.00 0 17207 6 0 0
srv_make_invnt_saldo 561 561 0 0.00 41 70012 1139 0 0
srv_make_money_saldo 774 774 0 0.00 1 503 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 205188 361891 308216 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 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5074 5074 0 0.00 0 14589 196 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 8876 109 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 7301 22 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 8092 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 3064 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 3788 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 8450 48 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 21368 1647 0 0
t$perf-norm:sp_cancel_write_off 926 926 0 0.00 0 1991 12 0 0
t$perf-norm:sp_client_order 20638 20638 0 0.00 0 12805 18 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 6207 14 0 0
t$perf-norm:sp_pay_from_customer 7162 7162 0 0.00 0 7362 13 0 0
t$perf-norm:sp_pay_to_supplier 5807 5807 0 0.00 0 7180 12 0 0
t$perf-norm:sp_reserve_write_off 9978 9978 0 0.00 0 11777 16 0 0
t$perf-norm:sp_supplier_invoice 5646 5646 0 0.00 0 6878 20 0 0
t$perf-norm:sp_supplier_order 5520 5520 0 0.00 0 10558 23 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 1072 25 0 0
t$perf-norm:srv_fill_mon_cache_memory 178 178 0 0.00 0 184 4 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 1103 24 0 0
t$perf-norm:srv_make_money_saldo 774 774 0 0.00 0 650 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 16 9 0 0
v_add_invoice_to_stock 10358 10114 244 2.35 0 8701 19 0 244
v_all_customers 37148 37148 0 0.00 0 24 1 0 0
v_all_suppliers 30388 30388 0 0.00 0 29 1 0 0
v_all_wares 41276 41276 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 1591 10 0 0
v_cancel_client_order 3678 3678 0 0.00 0 2233 5 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 4307 11 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 1766 7 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 632 4 0 0
v_cancel_supplier_invoice 848 832 16 1.88 0 810 15 0 16
v_cancel_supplier_order 832 832 0 0.00 0 3258 11 0 0
v_cancel_write_off 1852 1852 0 0.00 0 5817 19 0 0
v_max_id_clo_ord 5518 5518 0 0.00 0 439 1 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 7633 26 0 0
v_max_id_ord_sup 5638 5638 0 0.00 0 3451 4 0 0
v_max_non_paid_invoice 1769 1769 0 0.00 0 4674 5 0 0
v_max_non_paid_realizn 4015 4015 0 0.00 0 1164 3 0 0
v_min_id_clo_ord 5518 5518 0 0.00 0 3791 8 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 4905 10 0 0
v_min_id_ord_sup 5638 5638 0 0.00 0 4408 5 0 0
v_min_non_paid_invoice 5807 5807 0 0.00 0 12154 20 0 0
v_min_non_paid_realizn 7162 7162 0 0.00 0 10115 17 0 0
v_our_firm 10422 10422 0 0.00 0 77 1 0 0
v_reserve_write_off 19956 19956 0 0.00 0 3257 6 0 0
x_lock_depdocs_on_canc_invoice 11369 11369 0 0.00 0 17444 128 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 15466 444 0 0
x_make_qstorno_1000_1200 5520 5520 0 0.00 2 28031 1354 0 0
x_make_qstorno_1200_2000 5646 5646 0 0.00 3 86389 3701 0 0
x_make_qstorno_2100_3300 461208 461208 0 0.00 0 42677 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2021 22:28:53 to 27-02-2021 22:28:57.

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:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:29 22356 8192000000 10260766880 10572185600 1084158592 11.687 83 67 134 0 1109620048 3048688 22412768
19:58:04 21562 8192000000 10359149072 10676224000 1393296192 14.535 100 81 162 1 1424061776 4756768 26008816
19:58:34 27109 8192000000 10381543504 10710089728 1436910080 14.922 100 83 166 0 1470616688 6676448 27030160
19:59:11 15362 8192000000 10421329232 10750136320 1477154896 15.276 100 90 180 0 1513095776 7288640 28652240
19:59:38 11097 8192000000 10436858608 10770284544 1497270400 15.452 100 91 182 0 1534331472 8098096 28962976
19:59:57 13877 8192000000 10444385424 10777767936 1501713424 15.491 100 88 176 0 1538399568 8558224 28127920
20:00:26 6739 8192000000 10458942416 10793127936 1514534688 15.603 100 88 176 0 1551781568 9066560 28180320
20:00:43 19345 8192000000 10475702080 10810523648 1523627328 15.682 100 91 182 0 1562116832 9514160 28975344
20:01:12 18880 8192000000 10480919808 10818564096 1534951584 15.780 100 88 176 0 1573045936 9888624 28205728
20:01:41 16272 8192000000 10501405824 10850344960 1566124752 16.049 100 87 174 0 1602976928 10165584 26686592
20:02:05 12820 8192000000 10515275744 10866556928 1580560736 16.173 100 80 159 2 1615043792 10091824 24391232
20:02:34 12227 8192000000 10557379024 10913251328 1611245312 16.435 100 78 156 1 1646465232 10857280 24362640
20:02:57 12545 8192000000 10590296592 10950451200 1639535520 16.676 100 76 152 0 1673832080 11018912 23277648
20:03:17 10417 8192000000 10610874624 10975485952 1669630368 16.930 100 84 168 1 1706216848 11436816 25149664
20:03:35 12095 8192000000 10632651104 11002523648 1694813888 17.142 100 77 154 0 1727850848 11314496 21722464
20:03:57 8000 8192000000 10664612960 11034284032 1721896784 17.368 100 78 156 1 1755706528 11388576 22421168
20:04:13 6684 8192000000 10686389904 11060637696 1739220528 17.512 100 78 156 3 1774790640 12833584 22736528
20:04:27 4957 8192000000 10692991536 11073806336 1752922736 17.626 100 85 168 1 1790536848 13203488 24410624
20:04:39 5740 8192000000 10695830384 11079667712 1762518768 17.705 100 76 153 2 1796685488 12871488 21295232
20:04:51 6559 8192000000 10701723904 11083894784 1771652960 17.781 100 89 177 1 1809412384 13088096 24671328
20:05:05 3501 8192000000 10718098944 11095982080 1778095168 17.834 100 89 174 0 1815099936 13111440 23893328
20:05:15 5134 8192000000 10726802048 11111469056 1789331616 17.926 100 86 172 1 1827270192 13917024 24021552
20:05:26 5447 8192000000 10729688896 11111374848 1789886448 17.931 100 84 168 0 1827186096 13820880 23478768
20:05:40 3716 8192000000 10741760224 11122012160 1800037664 18.014 100 92 184 0 1840248512 14582944 25627904
20:05:50 2630 8192000000 10746816000 11128315904 1802890448 18.038 100 90 177 1 1843094672 15059296 25144928
20:06:00 2391 8192000000 10748706736 11130548224 1809397072 18.091 100 87 174 3 1848702832 15456496 23849264
20:06:09 7590 8192000000 10743956992 11138101248 1809413008 18.091 100 71 142 1 1841704352 13040432 19250912
20:06:24 4900 8192000000 10758392464 11149410304 1820165456 18.179 100 85 169 1 1856307568 12904352 23237760
20:06:35 2798 8192000000 10780106528 11166728192 1831309552 18.270 100 83 168 0 1867171008 12543856 23317600
20:06:44 2035 8192000000 10783385648 11170709504 1841493296 18.353 100 82 164 4 1878074992 13757168 22824528
20:06:53 2363 8192000000 10793023920 11180265472 1849650832 18.419 100 91 183 0 1888361296 13463728 25246736
20:07:01 2036 8192000000 10792506400 11179515904 1850193440 18.424 100 91 183 1 1889914368 13998128 25722800
20:07:10 1875 8192000000 10791329152 11179896832 1851630864 18.435 100 94 186 1 1893119488 15442432 26046192
20:07:19 1880 8192000000 10799277264 11186507776 1856534016 18.475 100 94 188 2 1897600304 14408848 26657440
20:07:27 2230 8192000000 10796627952 11186003968 1856462720 18.475 100 89 178 0 1895935856 13817248 25655888
20:07:36 1781 8192000000 10806212464 11194298368 1862851776 18.526 100 95 189 1 1903553104 15073744 25627584
20:07:44 1452 8192000000 10804070848 11194445824 1863101328 18.528 100 94 190 2 1902415456 13040512 26273616
20:07:51 10217 8192000000 10804802784 11198816256 1862116656 18.520 100 76 152 2 1894956368 11725200 21114512
20:08:08 1392 8192000000 10818097472 11204603904 1866719536 18.558 100 97 195 2 1907374352 12524336 28130480
20:08:16 2402 8192000000 10790027376 11195428864 1864099168 18.537 100 63 126 1 1893965808 12507520 17359120
20:08:25 1998 8192000000 10784993168 11189899264 1861045968 18.512 100 44 88 1 1882764944 8301088 13417888
20:08:34 4883 8192000000 10784224384 11192188928 1861025488 18.512 100 40 79 1 1881275792 7542480 12707824
20:08:46 3884 8192000000 10780061104 11192487936 1861887440 18.519 100 38 77 2 1880641712 8619808 10134464
20:08:56 3672 8192000000 10795968176 11204755456 1870714656 18.590 100 54 108 2 1893873888 7990512 15168720
20:09:06 5568 8192000000 10770882288 11196063744 1865479776 18.548 100 38 77 1 1884789008 8194688 11114544
20:09:20 6941 8192000000 10764390656 11197378560 1866669856 18.557 100 31 63 1 1882942720 7359488 8913376
20:09:33 6985 8192000000 10775908192 11197829120 1866415984 18.555 100 30 61 1 1881442352 6179664 8846704
20:09:50 6403 8192000000 10774633312 11204050944 1872751840 18.607 100 30 59 1 1888206160 7428608 8025712
20:10:03 7561 8192000000 10785377328 11209785344 1873223184 18.610 100 15 29 2 1882717504 5524096 3970224
20:10:16 10942 8192000000 10773219584 11209781248 1875620736 18.630 100 24 48 1 1887867680 5346160 6900784
20:10:37 5452 8192000000 10787686176 11221848064 1883006080 18.689 100 31 60 1 1898361872 6894576 8461216
20:10:49 71527 8192000000 10801547344 11236937728 1891244272 18.756 100 34 68 1 1907953184 6711568 9997344
20:12:09 3569 8192000000 10811803616 11244097536 1892276816 18.764 100 28 56 2 1906916528 6916144 7723568
20:12:19 8781 8192000000 10809021472 11242463232 1894841936 18.785 100 31 62 1 1910217440 6679600 8695904
20:12:37 9669 8192000000 10816774256 11249078272 1896207392 18.796 100 23 46 0 1910271792 6850016 7214384
20:12:54 5705 8192000000 10808653904 11248197632 1899441536 18.822 100 21 42 0 1911438928 6247392 5750000
20:13:07 7407 8192000000 10817704992 11252035584 1905488336 18.870 100 26 52 1 1918921200 6078320 7354544
20:13:21 7926 8192000000 10825768208 11258589184 1906923648 18.882 100 30 60 1 1921967136 6361600 8681888
20:13:38 8296 8192000000 10828613472 11258839040 1904787648 18.865 100 18 36 1 1916028416 6055456 5185312
20:13:55 9459 8192000000 10812693664 11254370304 1907543600 18.887 100 26 51 3 1921220528 5751200 7925728
20:14:12 4965 8192000000 10831074160 11262025728 1911067008 18.915 100 36 72 1 1928564912 7173744 10324160
20:14:26 5570 8192000000 10825991872 11262668800 1908770384 18.897 100 24 48 0 1922506272 7315840 6420048
20:14:41 6794 8192000000 10817305600 11257425920 1906096768 18.875 100 23 46 1 1919641744 7392928 6152048
20:14:54 9794 8192000000 10816808160 11253694464 1893399696 18.773 99 25 50 1 1906297456 5828288 7069472
20:15:11 8820 8192000000 10818603056 11255799808 1903314768 18.853 100 19 38 3 1914538448 5548640 5675040
20:15:28 49245 8192000000 10823825904 11253735424 1872484192 18.604 98 27 50 0 1891438864 10053344 8901328
20:16:36 15584 8192000000 10796185824 11224911872 1824225376 18.212 96 29 56 1 1838103680 6181008 7697296
20:17:02 7587 8192000000 10795390608 11227688960 1866638832 18.557 99 25 50 3 1880476656 7135536 6702288
20:17:17 2743 8192000000 10807494720 11229908992 1873992864 18.617 99 38 75 4 1891523760 6962368 10568528
20:17:26 4391 8192000000 10798410736 11228688384 1868620208 18.573 99 30 61 0 1883741376 7004288 8116880
20:17:38 4728 8192000000 10787950144 11218227200 1861743296 18.517 99 32 63 2 1877189856 5995104 9451456
20:17:51 7453 8192000000 10789349824 11221405696 1869301376 18.579 99 50 100 0 1894602624 11086656 14214592
20:18:06 4455 8192000000 10747503376 11172044800 1786135200 17.900 96 21 37 2 1796983968 5258288 5590480
20:18:17 7060 8192000000 10744289680 11169435648 1804639664 18.052 98 22 44 1 1816335632 5329936 6366032
20:18:33 7406 8192000000 10749092832 11159916544 1791050752 17.940 98 38 76 0 1807438016 4809936 11577328
20:18:48 7207 8192000000 10714251184 11126800384 1747284416 17.579 96 31 62 1 1762446528 6235328 8926784
20:19:02 6916 8192000000 10683461520 11088412672 1673007728 16.959 93 31 61 0 1687274176 5604512 8661936
20:19:15 8212 8192000000 10655134400 11073593344 1686028400 17.068 95 27 54 2 1700474480 6359680 8086400
20:19:29 9110 8192000000 10710501408 11125264384 1744800384 17.558 97 23 46 4 1756952880 5315856 6836640
20:19:45 5905 8192000000 10708206272 11120680960 1771565216 17.780 99 23 44 0 1782798576 4959232 6274128
20:19:58 4589 8192000000 10703288592 11121352704 1787277104 17.909 100 27 54 1 1802738368 7876464 7584800
20:20:12 67547 8192000000 10752456752 11144142848 1766886448 17.741 98 36 75 0 1782839472 5376400 10576624
20:21:26 9447 8192000000 10681261136 11101548544 1707177104 17.245 95 24 48 1 1723453344 9875520 6400720
20:21:41 4139 8192000000 10722617568 11141181440 1806441456 18.067 100 37 73 2 1823866544 6869168 10555920
20:21:52 8705 8192000000 10728468880 11139657728 1779963072 17.849 98 38 74 1 1796912672 6589872 10359728
20:22:07 6687 8192000000 10762111776 11161653248 1804613392 18.052 99 50 101 1 1825566160 6406336 14546432
20:22:23 6423 8192000000 10747821008 11158401024 1822665344 18.199 100 25 49 2 1835676016 5770336 7240336
20:22:36 4853 8192000000 10750891888 11163656192 1826365920 18.230 100 34 68 4 1841958912 5992528 9600464
20:22:47 6272 8192000000 10765258480 11185795072 1843118832 18.366 100 33 66 2 1858681856 6010128 9552896
20:23:00 10885 8192000000 10761466768 11181588480 1825900880 18.226 99 21 42 2 1837498176 5316544 6280752
20:23:19 5438 8192000000 10767675056 11185831936 1847396720 18.401 100 32 60 3 1863613264 7325264 8891280
20:23:31 12058 8192000000 10761525392 11190706176 1854802032 18.461 100 30 60 0 1870962880 7804800 8356048
20:23:49 8323 8192000000 10784325808 11207958528 1864921248 18.543 100 33 66 1 1880121840 5370608 9829984
20:24:06 8183 8192000000 10777957632 11206971392 1863521392 18.532 100 34 66 2 1878510640 5386352 9602896
20:24:21 47653 8192000000 10777352048 11208253440 1864500128 18.540 100 22 44 0 1875762032 5115344 6146560
20:25:15 25720 8192000000 10778971200 11210055680 1866855360 18.559 100 22 43 2 1878387824 5432832 6099632
20:25:49 7862 8192000000 10792683824 11213291520 1873169376 18.610 100 29 57 1 1886192512 4736208 8286928
20:26:04 6545 8192000000 10788631696 11219509248 1873671504 18.614 100 32 64 1 1894207952 12069968 8466480
20:26:17 5539 8192000000 10792353344 11219402752 1873420288 18.612 100 29 58 2 1887621888 6123184 8078416
20:26:29 7809 8192000000 10796789920 11224129536 1878053712 18.649 100 36 72 0 1895586720 7782896 9750112
20:26:48 8162 8192000000 10806223040 11226595328 1880228896 18.667 100 26 52 0 1893973952 5532816 8212240
20:27:02 10648 8192000000 10797459264 11228024832 1873362864 18.611 99 25 49 0 1884725024 4547824 6814336
20:27:20 17828 8192000000 10835535728 11251322880 1897714768 18.808 100 37 72 1 1913369904 5461280 10193856
20:28:02 2946 8192000000 10857824176 11265978368 1917782448 18.969 100 59 116 2 1941259360 5713584 17763328
20:28:16 45856 8192000000 10847374864 11275608064 1919784336 18.985 100 40 79 1 1937668352 6644816 11239200
20:29:17 34141 8192000000 10870717168 11301240832 1936423488 19.118 100 43 86 2 1962668736 13839616 12405632
20:30:04 20889 8192000000 10877170464 11304366080 1945912464 19.194 100 33 66 1 1965595248 9733120 9949664
20:30:32 53248 8192000000 10869871280 11301883904 1932095152 19.084 99 51 102 2 1959151392 11945168 15111072
20:31:45 28360 8192000000 10871378608 11304873984 1940204304 19.148 100 33 65 1 1964074976 14444912 9425760
20:32:23 7481 8192000000 10864867056 11298881536 1909303296 18.901 98 43 86 0 1934432064 12542864 12585904
20:32:38 22774 8192000000 10872991776 11311788032 1946491472 19.199 100 43 86 3 1972817072 13714000 12611600
20:33:32 14291 8192000000 10885364848 11327660032 1955442672 19.270 100 31 60 3 1980672800 16497632 8732496
20:33:54 18919 8192000000 10896229328 11320803328 1946790000 19.201 99 45 88 4 1976295264 16463232 13042032
20:34:21 7331 8192000000 10901880848 11329986560 1946882096 19.202 99 61 120 3 1982367024 17343936 18140992
20:34:40 13919 8192000000 10922868688 11350347776 1977106128 19.442 100 77 154 1 2017753888 18073696 22574064
20:35:07 4169 8192000000 10909468192 11337117696 1943669104 19.176 99 58 116 0 1979822608 19452080 16701424
20:35:19 1560 8192000000 10904955520 11320270848 1926040016 19.035 98 74 146 1 1968415584 20662080 21713488
20:35:28 5788 8192000000 10903680448 11327053824 1956039616 19.275 100 62 124 1 1991793744 18505840 17248288
20:35:42 6049 8192000000 10919641280 11339956224 1966851088 19.360 100 73 145 1 2005743264 19116256 19775920
20:35:54 1693 8192000000 10938460224 11346681856 1977374160 19.444 100 86 171 3 2020243856 19803840 23065856
20:36:02 1684 8192000000 10925089552 11333079040 1939250480 19.141 98 81 159 1 1979893104 18235840 22406784
20:36:13 3736 8192000000 10930392816 11348762624 1974187728 19.419 100 76 149 1 2015515712 20096128 21231856
20:36:23 2903 8192000000 10907029936 11326181376 1944629296 19.184 99 79 157 1 1987511984 20574944 22307744
20:36:33 5763 8192000000 10915998176 11337302016 1963502752 19.334 100 64 128 1 2002112592 19665376 18944464
20:36:47 7391 8192000000 10926905936 11342356480 1951131360 19.235 99 73 146 1 1993302992 20725232 21446400
20:37:02 2894 8192000000 10924172192 11343167488 1967761040 19.368 100 73 146 1 2010900928 21780592 21359296
20:37:12 2532 8192000000 10931383088 11337547776 1965820624 19.352 100 82 161 1 2010089840 19711568 24557648
20:37:22 4675 8192000000 10927119264 11344601088 1970965008 19.393 100 69 137 0 2012121568 20960144 20196416
20:37:35 13950 8192000000 10911763680 11333025792 1952868880 19.249 99 71 142 1 1996038112 22231328 20937904
20:37:57 7664 8192000000 10924705648 11346083840 1964501568 19.342 100 71 140 0 2009671424 24149136 21020720
20:38:11 5727 8192000000 10925857504 11345068032 1965020640 19.346 100 65 128 0 2012068144 27460304 19587200
20:38:28 23584 8192000000 10914513760 11346993152 1951341024 19.237 99 53 106 0 1994291984 26345200 16605760
20:39:05 15030 8192000000 10908064784 11336019968 1909869792 18.906 97 48 94 1 1955090784 30912032 14308960
20:39:27 9238 8192000000 10934961632 11353321472 1964661568 19.343 100 60 119 1 2012087616 29402352 18023696
20:39:44 2963 8192000000 10943962176 11365625856 1977905824 19.448 100 70 139 1 2030664784 32329616 20429344
20:39:54 8137 8192000000 10932905360 11357319168 1945327488 19.189 98 74 147 0 2000432496 32922480 22182528
20:40:11 2239 8192000000 10954148464 11358625792 1971911600 19.401 100 86 172 0 2031524288 33648240 25964448
20:40:20 5828 8192000000 10923315040 11349450752 1950115936 19.227 99 67 134 0 2001788960 30645632 21027392
20:40:38 4252 8192000000 10915513760 11333914624 1940533152 19.151 99 78 152 2 1995297072 30160000 24603920
20:40:50 5075 8192000000 10903648032 11328004096 1947238992 19.204 100 61 121 0 1987413248 22004720 18169536
20:41:02 11560 8192000000 10894524832 11315216384 1909519504 18.903 97 63 126 1 1952363872 24084288 18760080
20:41:21 5709 8192000000 10914331856 11336400896 1955328816 19.269 100 66 132 0 2000804944 24977344 20498784
20:41:33 2398 8192000000 10877589536 11288911872 1912831280 18.929 98 77 152 0 1959378432 23986112 22561040
20:41:43 6519 8192000000 10910994144 11325714432 1946056176 19.195 100 74 147 1 1994306384 26163136 22087072
20:41:58 2947 8192000000 10897662128 11310788608 1916929696 18.962 99 81 162 2 1967599616 26894608 23775312
20:42:07 938 8192000000 10887991888 11286835200 1912801536 18.929 99 90 180 1 1967967200 28506832 26658832
20:42:16 4909 8192000000 10915859456 11326058496 1943533296 19.175 100 87 172 1 1998971408 29026752 26411360
20:42:28 7639 8192000000 10915309520 11327356928 1945190272 19.188 100 76 152 4 1999138432 30296640 23651520
20:42:45 10765 8192000000 10909857200 11343949824 1956682352 19.280 100 59 118 1 2005283440 29894000 18707088
20:43:10 9164 8192000000 10936005312 11356798976 1950473056 19.230 99 58 114 0 1996351120 28557232 17320832
20:43:26 3056 8192000000 10941510448 11358023680 1967686272 19.367 100 80 159 0 2025880608 33969232 24225104
20:43:38 3153 8192000000 10944420768 11356946432 1966583920 19.358 100 85 168 1 2026532160 34570048 25378192
20:43:49 6462 8192000000 10947037504 11364732928 1974465600 19.421 100 84 163 2 2030471024 30838272 25167152
20:44:02 1320 8192000000 10956442720 11363958784 1978763056 19.455 100 85 167 2 2036480432 32144352 25573024
20:44:10 5915 8192000000 10958910160 11377549312 1983527376 19.493 100 86 170 1 2043203424 33544272 26131776
20:44:23 2368 8192000000 10952625872 11364417536 1965051200 19.346 99 91 183 1 2028167632 34988032 28128400
20:44:32 3116 8192000000 10969126048 11376488448 1980389920 19.468 100 87 174 0 2043832768 35767072 27675776
20:44:43 1777 8192000000 10964836320 11375718400 1984364576 19.499 100 86 171 1 2047438336 36041680 27032080
20:44:52 3579 8192000000 10959540128 11376099328 1981758976 19.479 100 88 176 0 2046482416 36344832 28378608
20:45:02 2241 8192000000 10966529504 11382030336 1983085728 19.489 100 83 165 2 2045592144 36629376 25877040
20:45:15 5630 8192000000 10949517088 11364745216 1968814000 19.376 100 80 159 1 2032435600 38642976 24978624
20:45:30 2806 8192000000 10955108256 11367538688 1968923344 19.377 100 84 168 0 2034816288 39168944 26724000
20:45:38 2354 8192000000 10960446720 11372568576 1973266784 19.411 100 86 172 2 2039620960 38624320 27729856
20:45:49 2444 8192000000 10949018720 11363069952 1965482208 19.350 100 85 169 1 2030448944 38244432 26722304
20:46:01 3011 8192000000 10941214752 11363012608 1964876240 19.345 100 73 143 0 2026684224 38454096 23353888
20:46:10 1966 8192000000 10968421760 11380432896 1977167808 19.442 100 88 175 1 2042042256 37238896 27635552
20:46:22 1734 8192000000 10959501696 11370668032 1972470928 19.405 100 92 182 1 2040683232 39334528 28877776
20:46:32 8949 8192000000 10918070016 11342987264 1920782896 18.993 98 67 134 1 1979782384 37164608 21834880
20:46:49 2665 8192000000 10933177024 11344564224 1950065008 19.227 100 73 146 4 2008878624 35672928 23140688
20:46:58 3626 8192000000 10941928080 11346776064 1953511440 19.254 100 91 182 1 2020584640 37744048 29329152
20:47:08 6989 8192000000 10924192640 11346509824 1949397312 19.222 100 66 133 0 2009817616 38283088 22137216
20:47:27 5343 8192000000 10939212208 11359772672 1959342384 19.301 100 61 122 1 2019963696 40031024 20590288
20:47:39 2162 8192000000 10954359904 11372822528 1967820288 19.368 100 70 141 1 2032084112 40784096 23479728
20:47:51 11207 8192000000 10924755008 11361259520 1963255440 19.332 100 47 95 2 2014713152 35486016 15971696
20:48:09 2235 8192000000 10952099344 11375460352 1972717744 19.407 100 76 152 1 2032262128 35369440 24174944
20:48:18 4472 8192000000 10953769488 11378077696 1978260256 19.451 100 65 130 0 2034073904 35128320 20685328
20:48:41 15570 8192000000 10922643680 11357409280 1949747456 19.224 99 37 74 2 1993271024 30820080 12703488
20:49:05 3054 8192000000 10938971792 11363815424 1953767648 19.256 99 68 133 1 2008399856 33702112 20930096
20:49:17 10674 8192000000 10935350896 11366158336 1947021296 19.203 99 40 80 1 1996279728 36038176 13220256
20:49:38 13447 8192000000 10918897776 11353776128 1954441312 19.262 100 40 80 0 2007245376 38728816 14075248
20:50:00 9267 8192000000 10925906320 11363164160 1955789696 19.273 100 44 86 2 2011592496 40883872 14918928
20:50:18 6075 8192000000 10932332256 11366391808 1957274000 19.284 100 40 79 3 2015328192 44379600 13674592
20:50:50 21619 8192000000 10924425472 11367854080 1940527696 19.151 99 35 70 0 1999291648 46464416 12299536
20:51:22 6041 8192000000 10908101760 11347914752 1932939712 19.090 99 39 78 0 1991490064 45364224 13186128
20:51:36 13741 8192000000 10930489392 11369947136 1949052448 19.219 100 30 59 0 2007990624 48699104 10239072
20:52:07 15120 8192000000 10908357552 11364597760 1933877920 19.098 99 30 60 1 1989965088 44773968 11313200
20:52:48 23448 8192000000 10899105392 11358433280 1937242128 19.125 100 19 38 0 1987291024 42540592 7508304
20:53:18 17839 8192000000 10887032240 11334918144 1913820512 18.937 99 26 52 2 1961521056 38850656 8849888
20:53:43 7312 8192000000 10906578192 11343802368 1938343136 19.134 100 38 75 0 1987110464 36009776 12757552
20:53:58 15191 8192000000 10898791696 11352150016 1940895600 19.154 100 32 65 2 1988235920 36067792 11272528
20:54:21 22974 8192000000 10895353856 11362586624 1944025968 19.179 100 22 42 2 1991229200 39460784 7742448
20:54:50 29316 8192000000 10874112736 11335479296 1908460928 18.894 98 13 26 2 1931155392 18368768 4325696
20:55:44 75025 8192000000 10874315472 11336892416 1923082272 19.012 99 4 6 1 1932627328 8838816 706240
20:57:06 98763 8192000000 10915699648 11352231936 1948890432 19.218 99 31 62 1 1969385264 12090848 8403984
20:58:52 52128 8192000000 10914572256 11359485952 1954351472 19.261 99 40 78 2 1975417040 9190704 11874864
21:00:01 25612 8192000000 10892239456 11357356032 1971453040 19.397 100 24 48 2 1988760352 10785328 6521984
21:01:26 78867 8192000000 10895642608 11354763264 1933242976 19.093 98 46 89 3 1954801664 8823232 12735456
21:02:51 104549 8192000000 10896461328 11347439616 1932911408 19.090 98 24 47 1 1952925184 13738304 6275472
21:04:42 12794 8192000000 10915791872 11353837568 1957138704 19.283 99 47 96 0 1977057376 6545984 13372688
21:05:01 3160 8192000000 10914698160 11355926528 1973124336 19.410 100 56 110 1 1996434240 8266944 15042960
21:05:13 15269 8192000000 10880006288 11335405568 1941752080 19.161 99 26 52 1 1955343232 6697072 6894080
21:05:36 25313 8192000000 10891266512 11348439040 1950931136 19.234 99 31 62 1 1966050928 6929216 8190576
21:06:07 35932 8192000000 10903203648 11359453184 1968820464 19.376 100 21 42 0 1985069824 10274768 5974592
21:06:53 35338 8192000000 10922954576 11375915008 1967993872 19.370 99 37 70 0 1989718688 11116368 10608448
21:07:36 36741 8192000000 10925580624 11382226944 1968791936 19.376 99 23 44 1 1985659952 10331872 6536144
21:08:22 22125 8192000000 10923654272 11380563968 1977754432 19.447 99 37 74 1 2001963616 13296368 10912816
21:09:23 61578 8192000000 10904597264 11370799104 1944249440 19.181 98 13 26 0 1962588320 14016528 4322352
21:10:37 35464 8192000000 10903017472 11380961280 1981063056 19.473 100 13 25 1 1995705920 11508464 3134400
21:11:19 18387 8192000000 10891479856 11364503552 1973480992 19.413 100 19 38 1 1987298688 8008384 5809312
21:11:44 25369 8192000000 10890878864 11359715328 1954173872 19.260 99 13 26 0 1965001088 7560144 3267072
21:12:25 44396 8192000000 10887806064 11357224960 1939224496 19.141 98 14 28 2 1952057632 8632064 4201072
21:13:23 38376 8192000000 10903453856 11373625344 1975593840 19.430 100 13 26 0 1989993984 10417408 3982736
21:14:08 83176 8192000000 10904855408 11385724928 1980321680 19.467 100 23 46 1 2000355456 12985616 7048160
21:15:38 47683 8192000000 10890191808 11352719360 1940641136 19.152 98 22 44 1 1959324032 12072640 6610256
21:16:38 68537 8192000000 10896864080 11374608384 1983201456 19.490 100 21 42 0 2001165952 12206896 5757600
21:18:04 59090 8192000000 10882817408 11363975168 1920936896 18.994 97 8 16 1 1933713760 10542864 2234000
21:19:19 53338 8192000000 10883072192 11363749888 1897546784 18.807 96 14 27 1 1912468528 11186272 3735472
21:20:30 73681 8192000000 10852441696 11329880064 1898995504 18.818 96 22 44 0 1926771568 21653728 6122336
21:22:01 60432 8192000000 10886099936 11358691328 1926306096 19.037 98 22 44 2 1956832352 24211120 6315136
21:23:12 81649 8192000000 10878414240 11351883776 1879334976 18.660 96 13 26 0 1896179456 13305840 3538640
21:24:40 37196 8192000000 10873873872 11338846208 1893850704 18.777 97 32 64 3 1917175280 14282448 9042128
21:25:37 77199 8192000000 10859210864 11341541376 1840718128 18.347 95 22 44 3 1870136992 23093552 6325312
21:27:01 67621 8192000000 10880463808 11340849152 1922799744 19.009 99 22 44 0 1947570048 18449600 6320704
21:28:15 27899 8192000000 10893805168 11347533824 1949407024 19.222 100 46 92 1 1974546096 13144400 11994672
21:28:50 10221 8192000000 10894372912 11345645568 1940071648 19.147 99 40 80 0 1960681488 9733312 10876528
21:29:11 5391 8192000000 10904771424 11353972736 1958544752 19.294 100 51 101 1 1982696128 9855568 14295808
21:29:27 53528 8192000000 10875449104 11335626752 1845727856 18.387 94 32 64 0 1866814896 12423488 8663552
21:30:27 28823 8192000000 10888644320 11342307328 1866501456 18.556 96 37 74 0 1888758496 12417072 9839968
21:31:06 93677 8192000000 10899286448 11351859200 1947856784 19.209 100 47 94 1 1978115504 17447216 12811504
21:32:47 38616 8192000000 10883621104 11348844544 1933706160 19.097 99 36 72 2 1960420656 15904176 10810320
21:33:44 68223 8192000000 10846097600 11322630144 1903429088 18.854 98 20 40 0 1925006528 15496224 6081216
21:35:33 62217 8192000000 10837898992 11330609152 1854353744 18.457 96 7 14 0 1868599200 12353488 1891968
21:36:43 11521 8192000000 10841195584 11335311360 1919309072 18.981 100 2 4 0 1930767440 11170304 288064
21:37:01 30823 8192000000 10852019888 11321278464 1896330976 18.797 98 28 55 0 1910154848 5947680 7876192
21:37:49 33679 8192000000 10851163760 11305230336 1856634896 18.476 96 22 44 0 1870983824 7922368 6426560
21:38:37 24506 8192000000 10874967776 11325112320 1931329136 19.078 100 47 93 0 1951817536 7460880 13027520
21:39:11 18874 8192000000 10890258512 11338481664 1944129184 19.180 100 46 93 0 1966876048 9420464 13326400
21:39:46 34529 8192000000 10851675008 11320512512 1896051728 18.795 98 13 25 0 1908354880 8906272 3396880
21:40:27 32177 8192000000 10877511968 11341602816 1930409760 19.070 99 26 52 1 1951971840 14133584 7428496
21:41:12 34046 8192000000 10881427248 11355746304 1916306032 18.957 98 24 49 0 1939826192 15950448 7569712
21:41:54 70356 8192000000 10887999312 11343032320 1920425680 18.990 99 15 29 0 1943044848 18079600 4539568
21:43:15 70300 8192000000 10859600688 11339730944 1892560944 18.766 98 12 24 0 1921138704 24746944 3830816
21:44:31 42568 8192000000 10876179120 11328864256 1893446288 18.774 98 21 42 0 1911457200 12212224 5798688
21:45:37 114649 8192000000 10885207984 11365081088 1906702688 18.880 98 13 26 1 1931159712 20804624 3652400
21:47:38 70012 8192000000 10884402576 11348992000 1917497280 18.967 98 19 37 0 1945343184 21778416 6067488
21:49:00 89230 8192000000 10883963184 11352436736 1916714000 18.961 98 19 36 0 1934015168 12310928 4990240
21:50:43 122642 8192000000 10890810560 11363348480 1960300128 19.308 100 31 59 1 1976927472 8135792 8491552
21:52:53 47475 8192000000 10890794688 11367751680 1951452640 19.238 99 21 42 0 1970887968 13384672 6050656
21:53:51 11610 8192000000 10886469680 11369316352 1962307744 19.324 100 22 44 4 1982659408 14226272 6125392
21:54:14 13494 8192000000 10891321424 11377229824 1967117328 19.363 100 10 21 0 1981420288 11510512 2792448
21:54:40 79797 8192000000 10878102928 11368058880 1931186624 19.076 98 23 45 1 1946012512 7560800 7265088
21:56:14 43053 8192000000 10879721536 11372363776 1944346528 19.181 99 4 8 0 1956350880 10724416 1279936
21:57:03 34920 8192000000 10894616096 11373850624 1968922896 19.377 100 15 29 1 1982623616 10411328 3289392
21:57:51 70317 8192000000 10874722608 11363586048 1920221040 18.989 97 13 26 1 1932134784 8061296 3852448
21:59:47 45103 8192000000 10898471984 11375484928 1972598160 19.406 100 22 44 0 1986108064 7686640 5823264
22:00:49 63733 8192000000 10885702064 11367383040 1931825520 19.081 98 8 16 0 1941845696 7922000 2098176
22:02:01 60129 8192000000 10900292624 11376873472 1941673776 19.160 98 17 34 0 1953856464 8089520 4093168
22:03:07 69511 8192000000 10904483344 11382689792 1941756336 19.161 98 17 34 1 1957208128 10677568 4774224
22:04:25 59110 8192000000 10915319248 11394588672 1966384032 19.357 99 15 30 0 1987975680 17316832 4274816
22:06:06 34152 8192000000 10932667712 11397517312 1969703856 19.383 99 26 52 0 1993480336 16450096 7326384
22:06:46 45430 8192000000 10922177280 11392716800 1967733712 19.367 99 22 44 1 1989422704 15412032 6276960
22:07:38 33387 8192000000 10921328400 11396567040 1973013824 19.409 99 23 45 1 1992015552 12560480 6441248
22:08:19 43373 8192000000 10899117808 11362258944 1906880736 18.882 96 19 37 0 1923904224 11514656 5508832
22:09:17 61749 8192000000 10896567088 11398832128 1951501808 19.238 99 11 22 0 1970151904 15663360 2986736
22:10:25 108820 8192000000 10903231376 11376185344 1894241904 18.780 96 15 30 0 1911774640 13443248 4089488
22:12:20 108318 8192000000 10893084000 11375407104 1914335536 18.941 97 8 16 1 1937512704 21305520 1871648
22:14:15 29627 8192000000 10879664656 11332575232 1884181216 18.699 96 37 74 2 1903006304 8006480 10818608
22:14:59 89383 8192000000 10876104624 11329122304 1901390384 18.837 98 40 77 3 1920643824 7883072 11370368
22:16:36 75402 8192000000 10829864896 11296071680 1780137840 17.851 92 24 48 0 1797703872 11104048 6461984
22:18:11 31482 8192000000 10806907696 11279360000 1873702224 18.614 98 19 38 0 1886767344 8190848 4874272
22:19:10 50021 8192000000 10833184528 11304235008 1884696448 18.703 98 14 28 1 1895857520 7118416 4042656
22:20:08 58900 8192000000 10839898464 11320406016 1885700416 18.711 98 8 15 1 1896772448 9045168 2026864
22:21:13 34912 8192000000 10836574272 11317895168 1903288336 18.853 99 17 34 0 1919124128 10786864 5048928
22:22:07 61151 8192000000 10822415728 11294273536 1862721776 18.525 97 14 28 0 1879549296 12414368 4413152
22:23:24 43394 8192000000 10832524016 11318784000 1912671456 18.928 100 13 26 0 1929165696 12755424 3738816
22:24:17 32785 8192000000 10845512608 11321380864 1880730128 18.671 98 21 42 1 1900630080 13871104 6028848
22:25:04 35661 8192000000 10842562576 11324203008 1908397680 18.894 100 8 16 0 1927246336 16343872 2504784
22:25:46 43543 8192000000 10854490928 11330256896 1899739232 18.824 99 15 31 2 1921941120 17369136 4832752
22:26:39 31369 8192000000 10865351424 11331219456 1907949280 18.890 99 15 30 1 1924522240 12663696 3909264
22:27:17 8915 8192000000 9134059936 9372897280 297070496 3.499 16 2 4 0 301369792 4174672 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 27-02-2021 22:28:59 to 27-02-2021 22:29:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 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 27-02-2021 22:29:33 to 27-02-2021 22:29:35.

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          246007
MON$OLDEST_ACTIVE               246008
MON$OLDEST_SNAPSHOT             246008
MON$NEXT_TRANSACTION            246008
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                       2058912
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:392: 
:393: mscs-test-161.budzdorov.ru    Sat Feb 27 22:27:43 2021
:394:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:395: 
--- end of diff output ---

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

27.02.21 22:29:36. 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-27 22:29:39 No severe PSQL-related problems occured
27.02.21 22:29:40. End of report.