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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-20 22:27:24
DTS_END                         2021-03-20 22:27:24.8230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58772
TRN_ID                          246041
ATT_ID                          671
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: 9404.77 22641 1128572
customer order: creation 181.32 335 21758
customer order: refuse 14.85 323 1782
order to supplier: creation 48.38 1265 5806
order to supplier: removal 3.43 95682 412
invoice (draft): creation 47.30 3371 5676
invoice (draft): removal 50.67 736 6080
invoice accept: apply 43.14 18099 5177
invoice accept: cancel 45.94 832 5513
customer reserve: creation 4088.88 175 490666
customer reserve: removal 4577.31 57 549277
realization accept: apply 86.92 160 10430
realization accept: cancel 78.73 104 9448
payment from customer: creation 62.52 94 7502
payment from customer: removal 6.28 87 753
payment to supplier: creation 52.89 112 6347
payment to supplier: removal 3.33 77 399
service: total inventory turnovers 5.13 997 615
service: total monetary turnovers 6.74 31 809
service: aggregate perf. data 0.98 13253 118
service: refresh index statistics 0.03 317028 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2021 22:28:19 to 20-03-2021 22:28:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2396
TEST_TIME 2 4266
TEST_TIME 3 3947
TEST_TIME 4 4431
TEST_TIME 5 4928
TEST_TIME 6 4768
TEST_TIME 7 5318
TEST_TIME 8 5735
TEST_TIME 9 6005
TEST_TIME 10 6256
TEST_TIME 11 6396
TEST_TIME 12 6563
TEST_TIME 13 6627
TEST_TIME 14 7147
TEST_TIME 15 7432
TEST_TIME 16 7659
TEST_TIME 17 8033
TEST_TIME 18 8076
TEST_TIME 19 8690
TEST_TIME 20 9106
TEST_TIME 21 9551
TEST_TIME 22 9735
TEST_TIME 23 9730
TEST_TIME 24 9749
TEST_TIME 25 10440
TEST_TIME 26 10517
TEST_TIME 27 10783
TEST_TIME 28 10723
TEST_TIME 29 10907
TEST_TIME 30 11112
TEST_TIME 31 10932
TEST_TIME 32 10827
TEST_TIME 33 10915
TEST_TIME 34 10709
TEST_TIME 35 10588
TEST_TIME 36 10343
TEST_TIME 37 10418
TEST_TIME 38 10248
TEST_TIME 39 10363
TEST_TIME 40 10260
TEST_TIME 41 10154
TEST_TIME 42 10127
TEST_TIME 43 10244
TEST_TIME 44 10113
TEST_TIME 45 9970
TEST_TIME 46 9963
TEST_TIME 47 9999
TEST_TIME 48 9969
TEST_TIME 49 9874
TEST_TIME 50 9754
TEST_TIME 51 9823
TEST_TIME 52 9750
TEST_TIME 53 9675
TEST_TIME 54 9614
TEST_TIME 55 9532
TEST_TIME 56 9607
TEST_TIME 57 9635
TEST_TIME 58 9511
TEST_TIME 59 9456
TEST_TIME 60 9409
TEST_TIME 61 9474
TEST_TIME 62 9472
TEST_TIME 63 9549
TEST_TIME 64 9543
TEST_TIME 65 9512
TEST_TIME 66 9542
TEST_TIME 67 9660
TEST_TIME 68 9675
TEST_TIME 69 9643
TEST_TIME 70 9625
TEST_TIME 71 9647
TEST_TIME 72 9709
TEST_TIME 73 9760
TEST_TIME 74 9738
TEST_TIME 75 9664
TEST_TIME 76 9608
TEST_TIME 77 9659
TEST_TIME 78 9605
TEST_TIME 79 9630
TEST_TIME 80 9585
TEST_TIME 81 9534
TEST_TIME 82 9515
TEST_TIME 83 9463
TEST_TIME 84 9373
TEST_TIME 85 9387
TEST_TIME 86 9370
TEST_TIME 87 9437
TEST_TIME 88 9454
TEST_TIME 89 9458
TEST_TIME 90 9406
TEST_TIME 91 9532
TEST_TIME 92 9569
TEST_TIME 93 9566
TEST_TIME 94 9541
TEST_TIME 95 9573
TEST_TIME 96 9533
TEST_TIME 97 9571
TEST_TIME 98 9604
TEST_TIME 99 9588
TEST_TIME 100 9620
TEST_TIME 101 9559
TEST_TIME 102 9503
TEST_TIME 103 9482
TEST_TIME 104 9484
TEST_TIME 105 9472
TEST_TIME 106 9456
TEST_TIME 107 9430
TEST_TIME 108 9417
TEST_TIME 109 9383
TEST_TIME 110 9374
TEST_TIME 111 9376
TEST_TIME 112 9351
TEST_TIME 113 9428
TEST_TIME 114 9401
TEST_TIME 115 9462
TEST_TIME 116 9446
TEST_TIME 117 9456
TEST_TIME 118 9472
TEST_TIME 119 9451
TEST_TIME 120 9406

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2021 22:28:23 to 20-03-2021 22:28:26.

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 1581830 1581830 0 0.00 0 17524 6 0 0
doc_list_biud 1581830 1581830 0 0.00 0 65901 25 0 0
sp_add_invoice_to_stock 5342 5177 165 3.08 33 153857 18100 0 165
sp_cancel_adding_invoice 5513 5513 0 0.00 5 74803 833 0 0
sp_cancel_client_order 1782 1782 0 0.00 4 14886 324 0 0
sp_cancel_customer_reserve 549277 549277 0 0.00 1 65903 57 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 2 7543 87 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 2 5696 77 0 0
sp_cancel_supplier_invoice 6089 6080 9 0.14 1 13292 737 0 9
sp_cancel_supplier_order 412 412 0 0.00 7 865450 95682 0 0
sp_cancel_write_off 9448 9448 0 0.00 1 17528 104 0 0
sp_client_order 21758 21758 0 0.00 4 20827 336 0 0
sp_customer_reserve 490666 490666 0 0.00 0 35617 176 0 0
sp_fill_shopping_cart 33218 33218 0 0.00 1 10489 38 0 0
sp_fill_shopping_cart_clo_res 490664 490664 0 0.00 0 17303 14 0 0
sp_get_clo_for_invoice 5172 5172 0 0.00 0 32101 310 0 0
sp_kill_cost_storno 16113 16113 0 0.00 0 17522 54 0 0
sp_kill_qstorno_ret_qs2qd 1114494 1114494 0 0.00 0 65896 31 0 0
sp_kill_qty_storno 588114 588114 0 0.00 0 65900 67 0 0
sp_lock_selected_doc 21578 21578 0 0.00 0 8503 4 0 0
sp_make_cost_storno 29451 29451 0 0.00 0 7941 42 0 0
sp_multiply_rows_for_pdistr 29451 29451 0 0.00 0 15506 27 0 0
sp_multiply_rows_for_qdistr 21758 21758 0 0.00 0 11756 154 0 0
sp_pay_from_customer 7502 7502 0 0.00 4 15515 95 0 0
sp_pay_to_supplier 6347 6347 0 0.00 4 10543 112 0 0
sp_payment_common 13849 13849 0 0.00 1 5955 20 0 0
sp_qd_handle_on_cancel_clo 1782 1782 0 0.00 0 14880 294 0 0
sp_qd_handle_on_invoice_upd_sts 10685 10685 0 0.00 0 32565 335 0 0
sp_qd_handle_on_reserve_upd_sts 10430 10430 0 0.00 0 19743 60 0 0
sp_reserve_write_off 10430 10430 0 0.00 6 19771 161 0 0
sp_supplier_invoice 5676 5676 0 0.00 5 94521 3371 0 0
sp_supplier_order 5806 5806 0 0.00 5 86678 1265 0 0
srv_aggregate_perf_data 118 118 0 0.00 3127 80815 13253 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1692 129022 33954 0 0
srv_find_qd_qs_mism 1077482 1077482 0 0.00 0 11573 6 0 0
srv_make_invnt_saldo 615 615 0 0.00 41 49376 997 0 0
srv_make_money_saldo 809 809 0 0.00 1 6424 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 219160 515819 317029 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5177 5177 0 0.00 0 8795 155 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 1 3258 84 0 0
t$perf-norm:sp_cancel_client_order 1782 1782 0 0.00 0 5957 16 0 0
t$perf-norm:sp_cancel_customer_reserve 763 763 0 0.00 0 2671 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 6794 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 3431 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 3637 26 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 24864 1397 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 2996 13 0 0
t$perf-norm:sp_client_order 21758 21758 0 0.00 0 9664 17 0 0
t$perf-norm:sp_customer_reserve 1094 1094 0 0.00 0 437 4 0 0
t$perf-norm:sp_pay_from_customer 7502 7502 0 0.00 0 8695 10 0 0
t$perf-norm:sp_pay_to_supplier 6347 6347 0 0.00 0 7881 10 0 0
t$perf-norm:sp_reserve_write_off 10430 10430 0 0.00 0 7583 13 0 0
t$perf-norm:sp_supplier_invoice 5676 5676 0 0.00 0 5153 20 0 0
t$perf-norm:sp_supplier_order 5806 5806 0 0.00 0 9503 17 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 122 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 773 12 0 0
t$perf-norm:srv_make_invnt_saldo 615 615 0 0.00 0 1078 18 0 0
t$perf-norm:srv_make_money_saldo 809 809 0 0.00 0 4063 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10674 10344 330 3.09 0 6865 18 0 330
v_all_customers 39176 39176 0 0.00 0 14 1 0 0
v_all_suppliers 32290 32290 0 0.00 0 109 1 0 0
v_all_wares 43516 43516 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 212 5 0 0
v_cancel_client_order 3564 3564 0 0.00 0 3501 7 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 3139 7 0 0
v_cancel_customer_reserve 1526 1526 0 0.00 0 6011 7 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 825 4 0 0
v_cancel_supplier_invoice 806 788 18 2.23 0 339 16 0 18
v_cancel_supplier_order 824 824 0 0.00 0 6005 15 0 0
v_cancel_write_off 2130 2130 0 0.00 0 1786 13 0 0
v_max_id_clo_ord 5802 5802 0 0.00 0 217 1 0 0
v_max_id_clo_res 1094 1094 0 0.00 0 10457 34 0 0
v_max_id_ord_sup 5658 5658 0 0.00 0 3779 4 0 0
v_max_non_paid_invoice 1662 1662 0 0.00 0 972 2 0 0
v_max_non_paid_realizn 4148 4148 0 0.00 0 2375 4 0 0
v_min_id_clo_ord 5802 5802 0 0.00 0 4203 9 0 0
v_min_id_clo_res 1094 1094 0 0.00 0 10234 31 0 0
v_min_id_ord_sup 5658 5658 0 0.00 0 6836 8 0 0
v_min_non_paid_invoice 6347 6347 0 0.00 0 4822 14 0 0
v_min_non_paid_realizn 7502 7502 0 0.00 0 4600 11 0 0
v_our_firm 11048 11048 0 0.00 0 13 1 0 0
v_reserve_write_off 20860 20860 0 0.00 0 6609 7 0 0
x_lock_depdocs_on_canc_invoice 11199 11199 0 0.00 0 23914 111 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 30124 442 0 0
x_make_qstorno_1000_1200 5806 5806 0 0.00 1 86642 1184 0 0
x_make_qstorno_1200_2000 5676 5676 0 0.00 3 91992 3229 0 0
x_make_qstorno_2100_3300 490666 490666 0 0.00 0 35615 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2021 22:28:27 to 20-03-2021 22:28:31.

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:28 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:34 16016 8192000000 10232178736 10538414080 827175136 9.171 65 46 95 0 844211584 2309264 14727184
19:57:59 29266 8192000000 10344078688 10657431552 1377560624 14.395 100 81 162 0 1408342016 4856528 25924864
19:58:37 31835 8192000000 10377192112 10702131200 1425345472 14.820 100 85 170 0 1459693712 6734640 27613600
19:59:17 18512 8192000000 10397016880 10724708352 1458071744 15.109 100 88 176 0 1494718368 7741456 28905168
19:59:45 33138 8192000000 10443712800 10772164608 1479470560 15.297 100 92 184 0 1521066016 12586352 29009104
20:00:27 20870 8192000000 10454618928 10785345536 1503770224 15.509 100 90 180 0 1542148000 9327776 29050000
20:01:00 23651 8192000000 10466250992 10803064832 1519586368 15.647 100 89 178 1 1557972256 10030688 28355200
20:01:34 22619 8192000000 10487991456 10832969728 1540725552 15.830 100 85 170 1 1577823392 10418528 26679312
20:02:08 17014 8192000000 10524098736 10871386112 1572459360 16.103 100 85 170 2 1610108832 10918928 26730544
20:02:36 12689 8192000000 10541118944 10894336000 1596496144 16.309 100 86 172 1 1634740192 11657312 26586736
20:03:02 7507 8192000000 10551104560 10913644544 1613330240 16.453 100 70 140 0 1645852624 11603920 20918464
20:03:16 9589 8192000000 10588085648 10944536576 1641156944 16.690 100 80 160 0 1676608496 11561312 23890240
20:03:36 9800 8192000000 10595764880 10956652544 1661599008 16.862 100 81 161 0 1697249936 12289632 23361296
20:03:56 14591 8192000000 10635008512 10998296576 1680426704 17.021 100 79 157 0 1716094656 13191504 22476448
20:04:18 8292 8192000000 10638708016 11006472192 1696986304 17.160 100 86 172 0 1736131376 14102960 25042112
20:04:32 10006 8192000000 10636599136 11011817472 1701151552 17.195 100 75 151 1 1736198720 13332784 21714384
20:04:49 6301 8192000000 10647551888 11024146432 1713734128 17.300 100 75 148 1 1747688976 12990112 20964736
20:05:03 5870 8192000000 10671464496 11044249600 1732195584 17.454 100 80 160 0 1767739152 12207360 23336208
20:05:16 4607 8192000000 10678253248 11052937216 1738890464 17.509 100 72 145 0 1771871232 12695616 20285152
20:05:29 4517 8192000000 10686160816 11060027392 1746952336 17.576 100 78 156 2 1782340912 12749696 22638880
20:05:41 4493 8192000000 10697111808 11072778240 1757197616 17.661 100 80 159 1 1791909472 12008352 22703504
20:05:52 9293 8192000000 10709745760 11085983744 1767681696 17.748 100 78 153 0 1801335856 12569520 21084640
20:06:08 4551 8192000000 10705459200 11090636800 1771172912 17.777 100 71 141 2 1804235568 13193248 19869408
20:06:20 3708 8192000000 10727030000 11109093376 1790300512 17.934 100 87 173 0 1827856128 13676688 23878928
20:06:30 3284 8192000000 10735384336 11117031424 1798357696 18.000 100 78 154 2 1832786864 13148480 21280688
20:06:41 2948 8192000000 10742465440 11131691008 1808054992 18.080 100 83 167 0 1845507952 13796672 23656288
20:06:50 2760 8192000000 10753341280 11138891776 1811931472 18.112 100 84 168 0 1849598160 13736320 23930368
20:06:59 2306 8192000000 10760640208 11143393280 1817559312 18.158 100 84 168 1 1853239200 12784592 22895296
20:07:08 2110 8192000000 10766082800 11149914112 1821956016 18.194 100 84 168 1 1859052512 13632000 23464496
20:07:17 2459 8192000000 10767629024 11157942272 1829992624 18.259 100 82 165 1 1865127456 12222416 22912416
20:07:25 2446 8192000000 10767591616 11152351232 1829889920 18.258 100 82 164 0 1865665664 12730016 23045728
20:07:35 1544 8192000000 10778655952 11160846336 1835271328 18.302 100 90 180 1 1874683936 13807168 25605440
20:07:43 2635 8192000000 10781783248 11167502336 1840011808 18.341 100 86 173 2 1878059648 14486384 23561456
20:07:52 1865 8192000000 10785686832 11170140160 1841741760 18.355 100 88 173 1 1879771808 13935056 24094992
20:08:00 1469 8192000000 10788590128 11173593088 1844024080 18.374 100 90 181 1 1883821760 14679024 25118656
20:08:07 1773 8192000000 10789438816 11173089280 1841994224 18.357 100 90 176 1 1878266848 11824048 24448576
20:08:16 1696 8192000000 10787843136 11176009728 1846138112 18.391 100 89 179 1 1884715296 13262080 25315104
20:08:24 4737 8192000000 10771640976 11177443328 1845673024 18.387 100 71 142 2 1879059088 13750512 19635552
20:08:41 16288 8192000000 10784459280 11180032000 1849517840 18.418 100 67 132 2 1878537696 9789936 19229920
20:09:04 3933 8192000000 10778059776 11185672192 1852134704 18.439 100 61 122 0 1880613520 11583504 16895312
20:09:15 4669 8192000000 10773107648 11179896832 1852560288 18.443 100 38 76 1 1872525328 8891120 11073920
20:09:26 7762 8192000000 10770990768 11182198784 1854917952 18.462 100 25 50 2 1868716496 6712576 7085968
20:09:40 4736 8192000000 10759597328 11187195904 1856299712 18.473 100 23 46 0 1870636720 7298656 7038352
20:09:51 5580 8192000000 10768153008 11190222848 1859658528 18.501 100 38 76 1 1878109216 7421392 11029296
20:10:03 7787 8192000000 10769135648 11192164352 1859166208 18.497 100 25 50 2 1872926688 6261360 7499120
20:10:19 8016 8192000000 10766320896 11191316480 1859707056 18.501 100 15 30 0 1869562704 5650000 4205648
20:10:37 9624 8192000000 10777308880 11198599168 1864329472 18.538 100 18 37 1 1875039088 6148128 4561488
20:10:53 7599 8192000000 10788749632 11207979008 1873441760 18.612 100 25 47 4 1886512992 6017072 7054160
20:11:07 10632 8192000000 10780657888 11207434240 1874043840 18.617 100 19 38 0 1887130208 6788192 6298176
20:11:28 53155 8192000000 10800196032 11216822272 1877502688 18.645 100 26 52 1 1891278304 4817216 8958400
20:12:43 5609 8192000000 10801783520 11226632192 1885565248 18.710 100 46 92 1 1907744608 9631808 12547552
20:12:56 4978 8192000000 10793601744 11224313856 1881504640 18.677 100 28 56 1 1895608288 6389088 7714560
20:13:07 5970 8192000000 10794904816 11227353088 1885600160 18.710 100 25 50 1 1898197632 5906752 6690720
20:13:20 9093 8192000000 10799168816 11228884992 1887224240 18.723 100 24 48 0 1899874000 6091904 6557856
20:13:37 5730 8192000000 10808357488 11235532800 1891083792 18.755 100 24 46 2 1903424480 5006896 7333792
20:13:53 8798 8192000000 10806637488 11241635840 1891853968 18.761 100 18 36 1 1902678256 5582208 5242080
20:14:08 7665 8192000000 10808485968 11240513536 1893241712 18.772 100 18 36 1 1904153264 5582016 5329536
20:14:24 6522 8192000000 10818794000 11249889280 1899388352 18.821 100 35 70 1 1920478928 10747920 10342656
20:14:39 12573 8192000000 10810956192 11244400640 1897326176 18.805 100 16 32 1 1907792368 5451568 5014624
20:15:00 10875 8192000000 10816930992 11252826112 1899706368 18.824 100 15 30 1 1913655872 9900272 4049232
20:15:17 7754 8192000000 10811081760 11244621824 1884948768 18.705 99 24 48 0 1899144336 6674048 7521520
20:15:32 9612 8192000000 10817261632 11247296512 1885737152 18.711 99 24 49 0 1901485744 9452224 6296368
20:15:47 10668 8192000000 10788401088 11223486464 1841200000 18.351 97 12 25 2 1850113712 5260800 3652912
20:16:06 11710 8192000000 10799273520 11228397568 1883481888 18.693 100 21 41 1 1894831904 5581568 5768448
20:16:27 17971 8192000000 10791710880 11224952832 1867035040 18.560 99 25 48 0 1879998176 5156992 7806144
20:16:53 66910 8192000000 10792424272 11221929984 1836520944 18.312 97 33 65 1 1850716928 5040016 9155968
20:18:06 8533 8192000000 10792063008 11218321408 1859992224 18.503 99 31 59 2 1875447824 7364032 8091568
20:18:21 7191 8192000000 10776862256 11199225856 1840107488 18.342 98 37 75 0 1857768672 6950880 10710304
20:18:37 7082 8192000000 10754059872 11181125632 1800338336 18.017 97 25 50 1 1813415616 5603328 7473952
20:18:53 8913 8192000000 10746401152 11161608192 1770905024 17.774 96 27 54 1 1784489328 5398336 8185968
20:19:10 5434 8192000000 10681421520 11096100864 1753241328 17.628 98 22 41 4 1764148768 4927728 5979712
20:19:22 6747 8192000000 10674881808 11089502208 1711491840 17.281 96 31 62 3 1729999264 9730608 8776816
20:19:35 11022 8192000000 10643099088 11050737664 1623972080 16.544 91 15 30 1 1633581632 5453504 4156048
20:19:54 8847 8192000000 10692660816 11094757376 1701780576 17.200 95 33 66 0 1717110592 4605872 10724144
20:20:09 8028 8192000000 10696534816 11111333888 1705498848 17.231 95 26 52 2 1722928224 10195888 7233488
20:20:26 9521 8192000000 10699179216 11109580800 1735078896 17.478 97 31 61 2 1749282560 5269072 8934592
20:20:43 9694 8192000000 10664758736 11082489856 1680353840 17.020 94 22 43 3 1692577632 4723376 7500416
20:20:59 7945 8192000000 10724724592 11137150976 1792745568 17.954 100 33 66 0 1809254320 7360048 9148704
20:21:17 9398 8192000000 10708991024 11129073664 1756775936 17.658 97 19 38 2 1767391840 4817744 5798160
20:21:36 6752 8192000000 10734205328 11141689344 1785225920 17.893 98 51 103 1 1808449840 6603184 16620736
20:22:19 38333 8192000000 10724750256 11148750848 1766581568 17.739 97 19 37 1 1777256864 5386288 5289008
20:23:08 6191 8192000000 10744197312 11162955776 1807705440 18.077 99 20 39 1 1819239952 5453808 6080704
20:23:21 10424 8192000000 10752681936 11178528768 1838385760 18.328 100 31 62 0 1854456480 7363120 8707600
20:23:37 4201 8192000000 10758890144 11184582656 1841287872 18.351 100 35 70 1 1858231728 6880064 10063792
20:23:47 8593 8192000000 10757584736 11185733632 1844983504 18.381 100 27 54 1 1859153184 6337776 7831904
20:24:04 9753 8192000000 10771031568 11197575168 1850725376 18.428 100 25 50 4 1864294720 5505600 8063744
20:24:20 7161 8192000000 10771660816 11199053824 1854792464 18.461 100 26 52 2 1868305104 5819952 7692688
20:24:35 7953 8192000000 10767272032 11199410176 1858327104 18.490 100 28 56 1 1872302672 5964384 8011184
20:24:51 9223 8192000000 10773629840 11206123520 1859849216 18.502 100 18 36 2 1870559488 5300096 5410176
20:25:07 12059 8192000000 10789324400 11212021760 1865692000 18.549 100 28 55 3 1880156960 5082576 9382384
20:25:28 12386 8192000000 10781501296 11211206656 1863785792 18.534 100 17 32 2 1873871728 5091776 4994160
20:25:46 9626 8192000000 10782134512 11211317248 1868541456 18.572 100 22 46 3 1880493408 5570352 6381600
20:26:02 9404 8192000000 10789977904 11216035840 1874459920 18.620 100 24 48 0 1887484544 6393840 6630784
20:26:19 22493 8192000000 10791134336 11219247104 1874582000 18.621 100 25 49 2 1888284848 5631520 8071328
20:26:49 70889 8192000000 10810334480 11237638144 1886986944 18.721 100 35 71 1 1902779696 5286848 10505904
20:28:11 20942 8192000000 10834850128 11255984128 1904240128 18.860 100 46 90 2 1924086672 7546208 12300336
20:29:00 11388 8192000000 10843117520 11268509696 1916993312 18.963 100 50 98 1 1940688192 10096864 13598016
20:29:28 20216 8192000000 10848457072 11280490496 1924916352 19.026 100 35 70 1 1943563168 8543488 10103328
20:29:55 20103 8192000000 10860653344 11290079232 1932962800 19.091 100 44 88 0 1953860032 8532672 12364560
20:30:29 11990 8192000000 10873727680 11297902592 1939500784 19.143 100 56 107 2 1965331904 10107152 15723968
20:30:52 56347 8192000000 10873679632 11306487808 1944404672 19.182 100 31 62 0 1965092576 11441136 9246768
20:31:55 11814 8192000000 10889000560 11312902144 1952287824 19.245 100 39 78 1 1975046144 10948640 11809680
20:32:22 26005 8192000000 10893993376 11331432448 1956374656 19.277 100 29 58 0 1978645776 13838336 8432784
20:32:59 10138 8192000000 10898174144 11330207744 1966589712 19.358 100 55 108 1 1999528640 16339152 16599776
20:33:30 29377 8192000000 10917176080 11348824064 1969317280 19.380 100 46 92 1 2000877136 17943136 13616720
20:34:08 12923 8192000000 10917513024 11350667264 1974331696 19.420 100 44 86 0 2005796560 19021296 12443568
20:34:30 6484 8192000000 10923529088 11354329088 1977237488 19.443 100 52 103 1 2013986048 20888352 15860208
20:34:49 10680 8192000000 10918166224 11349979136 1970898752 19.393 100 50 100 3 2008228080 21857872 15471456
20:35:07 12927 8192000000 10925111632 11364347904 1978473648 19.453 100 49 98 0 2015643936 22067872 15102416
20:35:41 6332 8192000000 10944831984 11368902656 1986779440 19.518 100 63 124 2 2027971520 22994592 18197488
20:35:54 3278 8192000000 10950462704 11376332800 1991584160 19.556 100 76 149 0 2039127184 25301312 22241712
20:36:07 2979 8192000000 10950055360 11374948352 1993432752 19.571 100 74 146 4 2042154976 27022752 21699472
20:36:18 3378 8192000000 10966795536 11378864128 1996161280 19.592 100 80 156 1 2045391568 27063936 22166352
20:36:30 13097 8192000000 10959259024 11384565760 1998545664 19.611 100 78 154 2 2049615552 28037984 23031904
20:36:56 3130 8192000000 10964758720 11391545344 2001714352 19.636 100 68 137 1 2050610640 28681264 20215024
20:37:06 9195 8192000000 10960834544 11386032128 2000662752 19.628 100 67 131 1 2047641600 27744320 19234528
20:37:23 5620 8192000000 10968175328 11394224128 2001986736 19.638 100 68 135 0 2051763728 30393968 19383024
20:37:36 4743 8192000000 10980261424 11403522048 2010051584 19.702 100 77 155 3 2064286752 31951008 22284160
20:37:53 3188 8192000000 10979600128 11408662528 2013106448 19.726 100 76 152 2 2069920288 32556752 24257088
20:38:05 5994 8192000000 10965217760 11403493376 2008837808 19.692 100 53 106 0 2057207936 32780048 15590080
20:38:18 2725 8192000000 10959940384 11388616704 1993266064 19.570 99 68 136 0 2041624208 27027952 21330192
20:38:28 3236 8192000000 10963803568 11390083072 2003397952 19.650 100 77 152 1 2053444896 27440144 22606800
20:38:40 5485 8192000000 10970625408 11402514432 2011562224 19.714 100 68 137 1 2060975408 28964384 20448800
20:38:53 3445 8192000000 10985795552 11412234240 2018210672 19.766 100 74 146 3 2069254608 29474800 21569136
20:39:03 2637 8192000000 10989489472 11412504576 2019982944 19.780 100 74 148 1 2072268848 29730960 22554944
20:39:13 10874 8192000000 10974771728 11405004800 1998259600 19.609 99 62 123 2 2049233824 31659664 19314560
20:39:35 1689 8192000000 10982102656 11408596992 2011484016 19.713 100 78 157 0 2070707952 35626880 23597056
20:39:44 2593 8192000000 10964341792 11396476928 2000976624 19.630 100 75 149 2 2054967872 30923376 23067872
20:39:53 3428 8192000000 10970212960 11393859584 1984848272 19.503 99 71 144 1 2038061632 31652256 21561104
20:40:04 7034 8192000000 10973027488 11403059200 2005245712 19.664 100 72 143 0 2060127216 33059280 21822224
20:40:20 5108 8192000000 10968107792 11405750272 2005712896 19.668 100 54 107 1 2056755280 34233584 16808800
20:40:33 9869 8192000000 10965193680 11402780672 2005527136 19.666 100 49 98 1 2054774128 33790640 15456352
20:40:53 2821 8192000000 10960504160 11384606720 1988340384 19.531 100 73 142 3 2044949296 35072192 21536720
20:41:03 2003 8192000000 10960923056 11372515328 1976186944 19.434 100 80 157 0 2036919616 35847408 24885264
20:41:12 1765 8192000000 10948073184 11361742848 1951835312 19.241 98 93 194 1 2017957712 37874448 28247952
20:41:20 2515 8192000000 10939156016 11356217344 1966429392 19.357 100 85 167 3 2028966432 36245648 26291392
20:41:29 8746 8192000000 10944411248 11366453248 1966873856 19.361 100 74 148 2 2027616768 38016832 22726080
20:41:44 2680 8192000000 10954482592 11373301760 1975011792 19.425 100 81 162 0 2037798656 38165440 24621424
20:41:56 1729 8192000000 10952793552 11375640576 1978643856 19.454 100 76 152 1 2040626304 38704848 23277600
20:42:08 8604 8192000000 10919931920 11350212608 1939726944 19.145 98 49 98 1 1992887952 37280208 15880800
20:42:24 2309 8192000000 10934214256 11346636800 1948792928 19.217 99 67 136 0 2005812640 35186496 21833216
20:42:34 4882 8192000000 10922156880 11335860224 1946312352 19.197 99 73 148 2 2007583824 37705712 23565760
20:42:46 3847 8192000000 10933668336 11360677888 1963417376 19.333 100 69 137 1 2023682960 38857984 21407600
20:43:00 2673 8192000000 10935922192 11356626944 1947459760 19.206 99 76 151 1 2008990800 37918784 23612256
20:43:11 3528 8192000000 10925486112 11337826304 1924830720 19.026 98 73 146 0 1984234432 36556672 22847040
20:43:22 4931 8192000000 10953773456 11371909120 1970404480 19.389 100 76 151 1 2032780672 39284016 23092176
20:43:34 5741 8192000000 10919002976 11334356992 1931305104 19.077 98 72 144 1 1993318464 39249504 22763856
20:43:51 3162 8192000000 10936749744 11359567872 1949321840 19.221 99 73 145 4 2012757584 40232160 23203584
20:44:01 3183 8192000000 10934824880 11358613504 1958720736 19.296 100 63 127 1 2019872816 41130032 20022048
20:44:11 3019 8192000000 10925901632 11346104320 1934203200 19.100 98 70 140 0 1997808256 41453728 22151328
20:44:29 9788 8192000000 10899581376 11330260992 1907843456 18.889 98 45 90 0 1961180384 38744944 14591984
20:44:47 2620 8192000000 10906854592 11328557056 1931048912 19.075 100 68 135 0 1992496192 40237888 21209392
20:45:00 8194 8192000000 10902926000 11332194304 1933023648 19.091 100 45 91 1 1988074384 40393056 14657680
20:45:19 6792 8192000000 10880116688 11303088128 1874529712 18.621 97 53 102 0 1933368320 41546400 17292208
20:45:36 5721 8192000000 10913465696 11335622656 1923120736 19.012 100 63 123 3 1986864144 43831568 19911840
20:45:52 10839 8192000000 10885582960 11327389696 1920084208 18.988 100 28 55 1 1973819888 43939488 9796192
20:46:12 6401 8192000000 10899743808 11325194240 1907716592 18.888 99 63 126 0 1972806160 44182752 20906816
20:46:27 3806 8192000000 10916674400 11334291456 1931216064 19.077 100 75 149 2 1997665616 42182752 24266800
20:46:38 13774 8192000000 10875023696 11318063104 1911352928 18.918 99 34 68 1 1962171008 39608528 11209552
20:46:59 11628 8192000000 10882471024 11325317120 1932108432 19.084 100 36 72 1 1978912032 34931056 11872544
20:47:19 10685 8192000000 10905593520 11342974976 1937552096 19.127 100 29 56 2 1979022560 31716432 9754032
20:47:36 16009 8192000000 10902291536 11344863232 1949081280 19.219 100 30 60 6 1988279504 29069952 10128272
20:48:14 7057 8192000000 10922773488 11340775424 1929821600 19.065 99 59 117 0 1982645760 34473728 18350432
20:48:29 2355 8192000000 10942416624 11349962752 1949201136 19.220 99 86 173 1 2013939680 37367040 27371504
20:48:38 3543 8192000000 10929993360 11353632768 1956958032 19.282 100 60 120 0 2012804784 36862704 18984048
20:48:57 14801 8192000000 10913081456 11354660864 1958166688 19.291 100 34 68 4 1999146656 29915872 11064096
20:49:18 15575 8192000000 10903492176 11345604608 1926446544 19.038 98 37 72 0 1966194784 27527984 12220256
20:49:46 17898 8192000000 10893935648 11342741504 1900308256 18.829 97 34 69 1 1941264656 30178928 10777472
20:50:33 19570 8192000000 10899619344 11340013568 1922001200 19.003 99 29 58 0 1969523728 37343264 10179264
20:51:00 23502 8192000000 10885422432 11328905216 1924792912 19.025 99 27 52 2 1967992048 34811648 8387488
20:51:32 17387 8192000000 10900586576 11345772544 1940737456 19.153 100 31 62 0 1985558144 34880064 9940624
20:51:59 18494 8192000000 10876558256 11330899968 1923714176 19.017 99 30 58 0 1967446272 34407152 9324944
20:52:52 34798 8192000000 10842061120 11304136704 1863603648 18.532 97 10 20 1 1894796016 28031680 3160688
20:53:33 26863 8192000000 10852568288 11309789184 1897822176 18.809 100 10 20 2 1929392000 28453424 3116400
20:54:12 36581 8192000000 10864107744 11313725440 1887090832 18.722 98 22 45 0 1924288480 30358400 6839248
20:55:17 30761 8192000000 10866018256 11322707968 1909801664 18.905 99 17 34 1 1938129296 22933760 5393872
20:55:59 47417 8192000000 10866945648 11332038656 1899142704 18.819 99 9 18 1 1926041872 24651664 2247504
20:56:53 75391 8192000000 10855937952 11329224704 1882885536 18.688 98 8 16 1 1906737008 21788688 2062784
20:58:15 47297 8192000000 10873336352 11304812544 1885298880 18.708 98 29 55 3 1908511248 15944688 7267680
20:59:11 49668 8192000000 10869560080 11324665856 1936571136 19.119 100 24 48 1 1955928880 12601232 6756512
21:00:19 100110 8192000000 10920783216 11349450752 1928823520 19.057 99 17 34 2 1949124176 15506336 4794320
21:02:54 129022 8192000000 10901799104 11373006848 1967995584 19.370 100 25 49 2 1994175440 18278560 7901296
21:05:13 62046 8192000000 10893724688 11365675008 1945470176 19.190 99 14 28 0 1968329456 18501824 4357456
21:06:43 22616 8192000000 10900265136 11352408064 1947057472 19.203 99 24 48 1 1964420368 10246224 7116672
21:07:16 49759 8192000000 10925389760 11369705472 1975041952 19.425 100 44 87 1 2001637952 12986128 13609872
21:08:23 34663 8192000000 10921696592 11378528256 1986011376 19.512 100 48 97 0 2017431600 17062128 14358096
21:09:16 70339 8192000000 10914002240 11394928640 1982858560 19.487 100 9 18 1 2002935040 16927344 3149136
21:10:32 27570 8192000000 10910504624 11387052032 1985133872 19.505 100 14 28 1 2006346192 17335968 3876352
21:11:06 98354 8192000000 10924607312 11384754176 1974422368 19.421 99 15 30 0 1989830992 11374816 4033808
21:13:09 30158 8192000000 10912752768 11382947840 1969308384 19.380 99 22 44 2 1992737920 16930784 6498752
21:14:01 78604 8192000000 10913930144 11388694528 1965931824 19.353 99 12 24 0 1982164544 13080416 3152304
21:15:35 127825 8192000000 10934528672 11403812864 1996772144 19.597 100 24 48 1 2012848048 9470080 6605824
21:17:54 59865 8192000000 10922144672 11391655936 1980888848 19.472 99 24 45 1 2000362400 13354480 6119072
21:19:00 56531 8192000000 10916544240 11387224064 1976412736 19.436 99 8 16 1 1987883296 9410448 2060112
21:20:03 12351 8192000000 10920486784 11388641280 1972194512 19.403 99 11 23 0 1989027776 13967392 2865872
21:20:27 18441 8192000000 10899901712 11376578560 1967983376 19.369 99 12 24 0 1979469792 8639056 2847360
21:21:07 53281 8192000000 10917709088 11394809856 1994825520 19.582 100 13 26 0 2009662400 11365184 3471696
21:22:06 79122 8192000000 10931505872 11405484032 1993508400 19.572 100 11 23 0 2011484464 14596480 3379584
21:24:25 77183 8192000000 10893857968 11372335104 1932584912 19.088 97 12 24 0 1947900848 11910960 3404976
21:26:05 68871 8192000000 10888490416 11369254912 1941261200 19.157 98 8 15 1 1949641616 6642640 1737776
21:27:29 29027 8192000000 10892092080 11355893760 1960830032 19.313 99 44 86 0 1979620992 6700320 12090640
21:28:04 43219 8192000000 10855568608 11324928000 1878088304 18.650 95 18 35 2 1890772880 7855600 4828976
21:28:54 75791 8192000000 10874803920 11341709312 1893300352 18.772 97 11 22 2 1909611296 13401856 2909088
21:30:16 64012 8192000000 10871346384 11337945088 1888529744 18.734 96 10 20 1 1899728112 8804336 2394032
21:31:34 58934 8192000000 10879302928 11329921024 1874024768 18.617 95 31 62 1 1897277216 14171792 9080656
21:32:45 58634 8192000000 10871741216 11329413120 1837062240 18.317 94 37 74 4 1865644560 18162288 10420032
21:33:50 60098 8192000000 10852560336 11326328832 1860672720 18.509 96 16 32 0 1881685504 16658912 4353872
21:35:01 95257 8192000000 10832691920 11291553792 1738078224 17.503 90 24 48 2 1758226208 12838688 7309296
21:36:42 6348 8192000000 10890228288 11310952448 1919574256 18.983 100 56 111 0 1941683296 6803648 15305392
21:36:57 7250 8192000000 10861956272 11301871616 1888340240 18.732 98 47 94 1 1910876080 9521152 13014688
21:37:12 10685 8192000000 10887484688 11323723776 1927093648 19.044 100 55 110 0 1953420352 11405840 14920864
21:37:29 8785 8192000000 10882890448 11319898112 1912600912 18.928 99 58 116 1 1941284960 12929616 15754432
21:37:45 45822 8192000000 10852620784 11307290624 1870613344 18.589 97 43 86 1 1895566624 13404800 11548480
21:38:37 71916 8192000000 10853590448 11322318848 1875096368 18.625 97 22 43 0 1894339104 12924176 6318560
21:40:10 60128 8192000000 10856221056 11333058560 1900616064 18.831 99 10 20 1 1921331968 17972784 2743120
21:41:31 42970 8192000000 10871425568 11325231104 1930121504 19.068 100 31 62 2 1947611888 8820336 8670048
21:42:26 127791 8192000000 10861736176 11337187328 1879394176 18.660 97 17 34 0 1894514144 10489712 4630256
21:44:40 80142 8192000000 10860115632 11335172096 1882613552 18.686 97 19 38 1 1907257216 19351696 5291968
21:46:12 19640 8192000000 10867289312 11317215232 1908693632 18.896 99 30 58 0 1930745952 12808768 9243552
21:46:53 68039 8192000000 10835876320 11305455616 1882905808 18.689 98 16 32 2 1895531424 8240672 4384944
21:48:20 62080 8192000000 10863811120 11330113536 1927016384 19.043 100 19 38 0 1939901600 7646320 5238896
21:49:36 73155 8192000000 10863866032 11345592320 1924073872 19.019 99 13 26 1 1943686512 15805968 3806672
21:50:55 82961 8192000000 10854954736 11323785216 1905827616 18.873 98 22 44 0 1928476272 15746736 6901920
21:52:40 8818 8192000000 10863088496 11338027008 1936873392 19.122 100 41 80 2 1963088656 14624144 11591120
21:53:02 35965 8192000000 10862823280 11339902976 1939685744 19.144 100 14 28 1 1959996688 16699936 3611008
21:53:57 45749 8192000000 10860799216 11337318400 1924127616 19.020 99 15 29 0 1941550592 13687840 3735136
21:55:26 92962 8192000000 10890455840 11365138432 1955350464 19.269 100 17 34 1 1971318960 11000784 4967712
21:57:07 52200 8192000000 10912638528 11378237440 1940113760 19.148 98 20 40 0 1958064176 12495488 5454928
21:58:05 77986 8192000000 10900524192 11374125056 1957954640 19.290 99 16 32 0 1972216016 9881376 4380000
21:59:34 112614 8192000000 10916296176 11383058432 1925593376 19.032 97 18 36 0 1938973760 8719648 4660736
22:01:41 37310 8192000000 10932806192 11394457600 1983952704 19.496 100 39 78 0 2011759088 16666320 11140064
22:02:25 54379 8192000000 10917161072 11380826112 1971688784 19.399 99 25 50 1 1988606096 10447968 6469344
22:03:30 13576 8192000000 10936645264 11388297216 1990201088 19.545 100 45 87 0 2011324480 9202272 11921120
22:03:49 19943 8192000000 10948630016 11391062016 1994883728 19.582 100 61 122 2 2023840368 11795984 17160656
22:04:18 31952 8192000000 10915219856 11377172480 1952572192 19.247 98 43 86 0 1976982016 12601792 11808032
22:05:02 66244 8192000000 10905589296 11384467456 1972399920 19.404 100 19 38 1 1991706736 14367744 4939072
22:06:15 95809 8192000000 10907815728 11380109312 1906457120 18.878 96 13 26 0 1917709936 7901728 3351088
22:08:28 102212 8192000000 10891187456 11361349632 1929117936 19.060 97 29 58 2 1944789840 6636016 9035888
22:10:16 77176 8192000000 10852891232 11319808000 1813224944 18.122 92 20 40 0 1828672896 10121216 5326736
22:11:40 31602 8192000000 10829475072 11308605440 1870503888 18.588 97 17 34 2 1883437056 8272480 4660688
22:12:19 46454 8192000000 10802814160 11280007168 1807117120 18.072 94 20 40 1 1820650976 7669568 5864288
22:13:11 61750 8192000000 10800844240 11279806464 1806284848 18.065 95 9 18 0 1822456896 13826784 2345264
22:14:19 64137 8192000000 10822293696 11294990336 1872200272 18.602 99 16 28 0 1883195568 7069392 3925904
22:15:30 85055 8192000000 10839900336 11314069504 1887665872 18.727 99 15 28 2 1903888784 11820864 4402048
22:17:03 92450 8192000000 10840961184 11318120448 1846691968 18.395 96 16 30 1 1865155984 14394160 4069856
22:19:19 75491 8192000000 10831901296 11308224512 1855679104 18.468 96 17 34 1 1872708208 11535504 5493600
22:20:44 51977 8192000000 10858411264 11319095296 1901783728 18.841 99 13 26 2 1915069968 9561936 3724304
22:21:46 32324 8192000000 10861083680 11334766592 1931899440 19.082 100 30 60 1 1952036336 11954384 8182512
22:22:26 92290 8192000000 10833215600 11309797376 1851287296 18.433 96 21 42 0 1874715600 17490432 5937872
22:24:05 52197 8192000000 10857090912 11319173120 1901090848 18.835 99 20 40 1 1916916624 10289008 5536768
22:25:11 54986 8192000000 10857598208 11319685120 1882870672 18.688 97 35 70 1 1907799184 14840976 10087536
22:26:17 74842 8192000000 9564668144 9887502336 683491904 7.700 36 7 14 0 693951344 8658752 1800688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-03-2021 22:28:33 to 20-03-2021 22:29:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 165 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2021 22:29:05 to 20-03-2021 22:29:07.

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          248696
MON$OLDEST_ACTIVE               248697
MON$OLDEST_SNAPSHOT             248697
MON$NEXT_TRANSACTION            248697
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                       2021440
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:72: 
:73: mscs-test-161.budzdorov.ru    Sat Mar 20 22:27:49 2021
:74:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:75: 
:76: 
:77: mscs-test-161.budzdorov.ru    Sat Mar 20 22:27:50 2021
:78:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:79: 
:80: 
:81: mscs-test-161.budzdorov.ru    Sat Mar 20 22:27:54 2021
:82:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:83: 
--- end of diff output ---

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

20.03.21 22:29:08. 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-03-20 22:29:10 No severe PSQL-related problems occured
20.03.21 22:29:11. End of report.