Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.11.2020 01: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 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 17450472 kB
MemAvailable 31454516 kB
Buffers 0 kB
Cached 14228664 kB
SwapCached 2824 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.7
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 2020-11-07 01:27:01
DTS_END                         2020-11-07 01:27:01.3800
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/42068
TRN_ID                          231031
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: 9307.33 22967 1116879
customer order: creation 162.91 393 19549
customer order: refuse 14.32 405 1718
order to supplier: creation 43.77 1305 5252
order to supplier: removal 3.47 108669 416
invoice (draft): creation 44.01 3444 5281
invoice (draft): removal 54.76 821 6571
invoice accept: apply 39.90 17585 4788
invoice accept: cancel 50.21 772 6025
customer reserve: creation 3705.09 172 444611
customer reserve: removal 4901.80 60 588216
realization accept: apply 79.22 200 9506
realization accept: cancel 85.81 107 10297
payment from customer: creation 56.10 118 6732
payment from customer: removal 5.70 140 684
payment to supplier: creation 45.88 133 5505
payment to supplier: removal 3.27 67 392
service: total inventory turnovers 4.28 1167 514
service: total monetary turnovers 6.13 30 736
service: aggregate perf. data 0.68 29257 82
service: refresh index statistics 0.03 294493 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-11-2020 01:27:51 to 07-11-2020 01:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5223
TEST_TIME 2 5201
TEST_TIME 3 6627
TEST_TIME 4 5903
TEST_TIME 5 5311
TEST_TIME 6 5237
TEST_TIME 7 5324
TEST_TIME 8 5033
TEST_TIME 9 5195
TEST_TIME 10 5935
TEST_TIME 11 5949
TEST_TIME 12 5991
TEST_TIME 13 6349
TEST_TIME 14 6510
TEST_TIME 15 6444
TEST_TIME 16 6831
TEST_TIME 17 7624
TEST_TIME 18 8117
TEST_TIME 19 8690
TEST_TIME 20 8780
TEST_TIME 21 9337
TEST_TIME 22 9436
TEST_TIME 23 9263
TEST_TIME 24 9421
TEST_TIME 25 9397
TEST_TIME 26 9716
TEST_TIME 27 10080
TEST_TIME 28 11083
TEST_TIME 29 11286
TEST_TIME 30 11112
TEST_TIME 31 10957
TEST_TIME 32 10864
TEST_TIME 33 10739
TEST_TIME 34 10598
TEST_TIME 35 10443
TEST_TIME 36 10408
TEST_TIME 37 10328
TEST_TIME 38 10228
TEST_TIME 39 9987
TEST_TIME 40 9948
TEST_TIME 41 9856
TEST_TIME 42 9885
TEST_TIME 43 9862
TEST_TIME 44 9735
TEST_TIME 45 9618
TEST_TIME 46 9489
TEST_TIME 47 9477
TEST_TIME 48 9516
TEST_TIME 49 9513
TEST_TIME 50 9451
TEST_TIME 51 9375
TEST_TIME 52 9301
TEST_TIME 53 9202
TEST_TIME 54 9188
TEST_TIME 55 9095
TEST_TIME 56 9133
TEST_TIME 57 9172
TEST_TIME 58 9208
TEST_TIME 59 9175
TEST_TIME 60 9215
TEST_TIME 61 9263
TEST_TIME 62 9368
TEST_TIME 63 9400
TEST_TIME 64 9392
TEST_TIME 65 9396
TEST_TIME 66 9375
TEST_TIME 67 9477
TEST_TIME 68 9498
TEST_TIME 69 9529
TEST_TIME 70 9550
TEST_TIME 71 9439
TEST_TIME 72 9405
TEST_TIME 73 9387
TEST_TIME 74 9398
TEST_TIME 75 9354
TEST_TIME 76 9384
TEST_TIME 77 9356
TEST_TIME 78 9332
TEST_TIME 79 9292
TEST_TIME 80 9218
TEST_TIME 81 9196
TEST_TIME 82 9196
TEST_TIME 83 9197
TEST_TIME 84 9166
TEST_TIME 85 9211
TEST_TIME 86 9228
TEST_TIME 87 9234
TEST_TIME 88 9270
TEST_TIME 89 9241
TEST_TIME 90 9248
TEST_TIME 91 9366
TEST_TIME 92 9339
TEST_TIME 93 9414
TEST_TIME 94 9440
TEST_TIME 95 9465
TEST_TIME 96 9526
TEST_TIME 97 9509
TEST_TIME 98 9483
TEST_TIME 99 9424
TEST_TIME 100 9382
TEST_TIME 101 9345
TEST_TIME 102 9381
TEST_TIME 103 9350
TEST_TIME 104 9346
TEST_TIME 105 9334
TEST_TIME 106 9333
TEST_TIME 107 9299
TEST_TIME 108 9283
TEST_TIME 109 9250
TEST_TIME 110 9247
TEST_TIME 111 9264
TEST_TIME 112 9263
TEST_TIME 113 9301
TEST_TIME 114 9292
TEST_TIME 115 9313
TEST_TIME 116 9305
TEST_TIME 117 9336
TEST_TIME 118 9363
TEST_TIME 119 9368
TEST_TIME 120 9308

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-11-2020 01:27:54 to 07-11-2020 01:27:58.

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 1529386 1529386 0 0.00 0 33767 6 0 0
doc_list_biud 1529386 1529386 0 0.00 0 32104 29 0 0
sp_add_invoice_to_stock 4882 4788 94 1.92 35 170173 17585 0 94
sp_cancel_adding_invoice 6025 6025 0 0.00 4 38678 772 0 0
sp_cancel_client_order 1718 1718 0 0.00 4 24341 405 0 0
sp_cancel_customer_reserve 588216 588216 0 0.00 1 32110 60 0 0
sp_cancel_pay_from_customer 684 684 0 0.00 3 22687 141 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 2 2990 67 0 0
sp_cancel_supplier_invoice 6580 6571 9 0.13 1 20620 821 0 9
sp_cancel_supplier_order 416 416 0 0.00 14 1105288 108670 0 0
sp_cancel_write_off 10297 10297 0 0.00 1 14498 107 0 0
sp_client_order 19549 19549 0 0.00 4 31497 394 0 0
sp_customer_reserve 444611 444611 0 0.00 0 53818 172 0 0
sp_fill_shopping_cart 30049 30049 0 0.00 1 13870 41 0 0
sp_fill_shopping_cart_clo_res 444600 444600 0 0.00 0 15829 15 0 0
sp_get_clo_for_invoice 4777 4777 0 0.00 0 23719 342 0 0
sp_kill_cost_storno 17398 17398 0 0.00 0 11336 54 0 0
sp_kill_qstorno_ret_qs2qd 1193716 1193716 0 0.00 0 32042 33 0 0
sp_kill_qty_storno 627526 627526 0 0.00 0 32100 71 0 0
sp_lock_selected_doc 19839 19839 0 0.00 0 5920 4 0 0
sp_make_cost_storno 26520 26520 0 0.00 0 33753 55 0 0
sp_multiply_rows_for_pdistr 26520 26520 0 0.00 0 10576 32 0 0
sp_multiply_rows_for_qdistr 19549 19549 0 0.00 0 9462 173 0 0
sp_pay_from_customer 6732 6732 0 0.00 4 24423 119 0 0
sp_pay_to_supplier 5505 5505 0 0.00 5 23893 133 0 0
sp_payment_common 12237 12237 0 0.00 2 12743 26 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 10691 355 0 0
sp_qd_handle_on_invoice_upd_sts 10802 10802 0 0.00 0 27700 342 0 0
sp_qd_handle_on_reserve_upd_sts 9506 9506 0 0.00 0 12865 60 0 0
sp_reserve_write_off 9506 9506 0 0.00 6 31731 201 0 0
sp_supplier_invoice 5281 5281 0 0.00 7 112424 3444 0 0
sp_supplier_order 5252 5252 0 0.00 5 32591 1305 0 0
srv_aggregate_perf_data 82 82 0 0.00 3010 821094 29258 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 858 126299 33352 0 0
srv_find_qd_qs_mism 1071821 1071821 0 0.00 0 10868 5 0 0
srv_make_invnt_saldo 514 514 0 0.00 33 37011 1168 0 0
srv_make_money_saldo 736 736 0 0.00 0 5712 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 165671 609894 294493 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 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 4788 4788 0 0.00 0 10414 162 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 3677 77 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 6717 24 0 0
t$perf-norm:sp_cancel_customer_reserve 645 645 0 0.00 0 3162 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 684 684 0 0.00 0 2039 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 3879 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 335 9 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 25073 1743 0 0
t$perf-norm:sp_cancel_write_off 923 923 0 0.00 0 1829 8 0 0
t$perf-norm:sp_client_order 19549 19549 0 0.00 0 8278 20 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 3448 10 0 0
t$perf-norm:sp_pay_from_customer 6732 6732 0 0.00 0 4761 9 0 0
t$perf-norm:sp_pay_to_supplier 5505 5505 0 0.00 0 10817 15 0 0
t$perf-norm:sp_reserve_write_off 9506 9506 0 0.00 0 6772 13 0 0
t$perf-norm:sp_supplier_invoice 5281 5281 0 0.00 0 9941 17 0 0
t$perf-norm:sp_supplier_order 5252 5252 0 0.00 0 7914 17 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 1000 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 1710 16 0 0
t$perf-norm:srv_make_invnt_saldo 514 514 0 0.00 0 1811 25 0 0
t$perf-norm:srv_make_money_saldo 736 736 0 0.00 0 3540 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 47 14 0 0
v_add_invoice_to_stock 9732 9544 188 1.93 0 22312 26 0 188
v_all_customers 35428 35428 0 0.00 0 19 1 0 0
v_all_suppliers 29160 29160 0 0.00 0 14 1 0 0
v_all_wares 39078 39078 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 4078 17 0 0
v_cancel_client_order 3436 3436 0 0.00 0 24176 16 0 0
v_cancel_customer_prepayment 1368 1368 0 0.00 0 22511 35 0 0
v_cancel_customer_reserve 1290 1290 0 0.00 0 4200 11 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 920 4 0 0
v_cancel_supplier_invoice 748 730 18 2.40 0 4849 29 0 18
v_cancel_supplier_order 832 832 0 0.00 0 389 3 0 0
v_cancel_write_off 1846 1846 0 0.00 0 6224 19 0 0
v_max_id_clo_ord 5250 5250 0 0.00 0 2305 2 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 3069 16 0 0
v_max_id_ord_sup 5260 5260 0 0.00 0 4067 6 0 0
v_max_non_paid_invoice 1435 1435 0 0.00 0 972 3 0 0
v_max_non_paid_realizn 3675 3675 0 0.00 0 2252 3 0 0
v_min_id_clo_ord 5250 5250 0 0.00 0 4577 7 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 4711 19 0 0
v_min_id_ord_sup 5260 5260 0 0.00 0 7347 8 0 0
v_min_non_paid_invoice 5505 5505 0 0.00 0 6459 18 0 0
v_min_non_paid_realizn 6732 6732 0 0.00 0 12741 17 0 0
v_our_firm 9764 9764 0 0.00 0 49 1 0 0
v_reserve_write_off 19008 19008 0 0.00 0 24400 16 0 0
x_lock_depdocs_on_canc_invoice 12231 12231 0 0.00 0 26150 118 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 9996 309 0 0
x_make_qstorno_1000_1200 5252 5252 0 0.00 2 32543 1222 0 0
x_make_qstorno_1200_2000 5281 5281 0 0.00 3 112355 3285 0 0
x_make_qstorno_2100_3300 444611 444611 0 0.00 0 53796 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2020 01:27:59 to 07-11-2020 01:28:03.

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
22:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:11 8519 8192000000 10146573152 10432417792 816442576 9.063 65 45 93 0 832439136 2024944 13971616
22:57:27 28863 8192000000 10325084144 10640019456 1371719600 14.342 100 89 179 0 1404564192 4215760 28628832
22:58:04 33539 8192000000 10375929296 10694750208 1420981440 14.781 100 86 173 1 1456302240 6581152 28739648
22:58:50 25787 8192000000 10398668464 10720657408 1444288528 14.988 100 93 186 0 1482864416 7860512 30715376
22:59:26 24215 8192000000 10407648960 10734542848 1456686752 15.097 100 92 185 0 1495556416 8160864 30708800
23:00:07 26797 8192000000 10433667776 10765611008 1482693216 15.325 100 88 176 0 1520426784 9499808 28233760
23:00:48 8403 8192000000 10453039920 10788859904 1510757680 15.570 100 87 174 0 1548041040 9811952 27471408
23:01:09 6259 8192000000 10473769648 10813292544 1525368592 15.697 100 84 168 0 1561963472 10028304 26566576
23:01:23 20831 8192000000 10498860928 10846801920 1551521040 15.923 100 84 168 0 1588122368 10026336 26574992
23:01:53 20591 8192000000 10538670896 10890194944 1592851248 16.278 100 79 158 1 1626851184 10259184 23740752
23:02:23 15877 8192000000 10559657968 10917670912 1613783200 16.457 100 77 154 0 1648124912 11341968 22999744
23:02:51 8744 8192000000 10582572272 10943852544 1644778176 16.720 100 82 163 1 1681062496 12062352 24221968
23:03:07 12070 8192000000 10611225808 10973634560 1665845744 16.898 100 80 160 1 1702508560 13030064 23632752
23:03:30 10062 8192000000 10617536288 10985627648 1676166880 16.985 100 76 152 2 1710618784 12279136 22172768
23:03:49 6846 8192000000 10636928752 11008716800 1695845712 17.150 100 74 148 1 1729265904 12052896 21367296
23:04:03 7345 8192000000 10648916160 11021778944 1710183488 17.270 100 78 155 1 1745719424 13046704 22489232
23:04:17 6692 8192000000 10664121648 11036311552 1724831280 17.392 100 81 162 1 1761748208 13580784 23336144
23:04:32 5290 8192000000 10678625296 11048714240 1732907104 17.460 100 76 149 0 1767259536 13510032 20842400
23:04:44 7711 8192000000 10679412960 11056648192 1741736448 17.533 100 79 158 0 1777105728 12920800 22448480
23:05:05 5929 8192000000 10689727136 11067244544 1756628832 17.656 100 78 156 0 1791504800 11593376 23282592
23:05:18 4636 8192000000 10704213920 11086163968 1765278720 17.728 100 73 145 1 1797609744 11566528 20764496
23:05:30 6836 8192000000 10702275376 11087060992 1773248208 17.794 100 68 135 3 1804318048 12426448 18643392
23:05:45 3745 8192000000 10731430144 11117158400 1792747200 17.954 100 79 158 0 1828796032 13594960 22453872
23:05:56 3642 8192000000 10729070048 11120349184 1798147408 17.999 100 77 153 0 1832640224 12537360 21955456
23:06:06 4582 8192000000 10743008336 11130765312 1807721168 18.077 100 85 169 0 1844549520 12767184 24061168
23:06:20 4701 8192000000 10759119824 11141083136 1817132448 18.154 100 86 169 4 1854682224 13066640 24483136
23:06:31 4051 8192000000 10759531056 11145228288 1818963680 18.169 100 83 165 2 1855496304 12940272 23592352
23:06:42 2827 8192000000 10766110432 11149185024 1826105152 18.228 100 83 164 1 1862472032 13164880 23202000
23:06:52 2757 8192000000 10769717504 11151831040 1834895712 18.299 100 93 187 1 1875474048 14266736 26311600
23:07:01 2150 8192000000 10769797632 11161485312 1836480400 18.312 100 86 170 1 1873370512 12848512 24041600
23:07:10 2408 8192000000 10781733776 11165896704 1838524224 18.329 100 90 180 0 1878169680 14375248 25270208
23:07:19 2729 8192000000 10790247344 11174850560 1847035792 18.398 100 93 186 0 1886889136 13987200 25866144
23:07:28 2183 8192000000 10789663664 11178622976 1848570544 18.411 100 85 172 2 1885964400 13967696 23426160
23:07:38 2686 8192000000 10788397648 11180412928 1850132816 18.423 100 79 157 2 1884446416 12699536 21614064
23:07:47 2068 8192000000 10803509440 11190112256 1856150544 18.472 100 93 186 0 1895230400 12754768 26325088
23:07:56 2146 8192000000 10802205104 11192692736 1860776448 18.510 100 91 182 1 1899152816 12646400 25729968
23:08:04 1708 8192000000 10805668384 11192160256 1861024784 18.512 100 92 183 1 1900411696 12556832 26830080
23:08:12 2050 8192000000 10809586064 11194675200 1862737056 18.525 100 92 184 3 1901859456 12722000 26400400
23:08:21 2785 8192000000 10801236880 11197329408 1862724432 18.525 100 77 154 0 1897331472 13394528 21212512
23:08:30 29935 8192000000 10801869280 11201232896 1865230752 18.546 100 65 129 0 1892119728 8376048 18512928
23:09:06 18109 8192000000 10818132928 11207872512 1869298160 18.579 100 66 132 0 1898371152 10111664 18961328
23:09:31 1287 8192000000 10819596992 11211304960 1877819552 18.647 100 78 157 1 1910908832 10155312 22933968
23:09:39 1455 8192000000 10834487536 11224408064 1884439520 18.701 100 89 179 1 1923114672 13175136 25500016
23:09:46 2354 8192000000 10815767648 11221696512 1882758160 18.687 100 66 132 0 1912657280 11915520 17983600
23:09:58 5069 8192000000 10803088304 11213778944 1879328272 18.660 100 40 79 0 1898803824 8933792 10541760
23:10:11 2933 8192000000 10800803792 11214155776 1880817120 18.672 100 42 84 0 1900329536 7557664 11954752
23:10:20 6571 8192000000 10802952672 11217100800 1880992464 18.673 100 35 71 0 1897189856 6292256 9905136
23:10:33 9256 8192000000 10795947856 11216752640 1881967296 18.681 100 22 45 1 1894417552 6358736 6091520
23:10:50 3850 8192000000 10801363072 11222728704 1891767312 18.760 100 49 98 0 1914768400 9170848 13830240
23:11:04 7066 8192000000 10802715952 11228090368 1888311088 18.732 100 28 56 2 1903873472 7039744 8522640
23:11:18 10004 8192000000 10789356240 11223449600 1887289888 18.724 100 18 36 1 1902311488 10256752 4764848
23:11:34 8587 8192000000 10801837008 11226603520 1892268416 18.764 100 25 50 2 1905615328 5747008 7599904
23:11:51 7604 8192000000 10797663264 11229704192 1892406096 18.765 100 31 63 2 1907263920 5949008 8908816
23:12:05 8914 8192000000 10813263296 11235057664 1894045168 18.778 100 25 50 0 1907926928 6778336 7103424
23:12:22 6995 8192000000 10803471552 11237404672 1896142896 18.795 100 22 44 1 1908302528 6090864 6068768
23:12:36 7487 8192000000 10804205104 11234209792 1896843360 18.801 100 24 48 0 1909889808 5972032 7074416
23:12:52 71853 8192000000 10838333136 11257069568 1904970816 18.866 100 34 67 0 1919552528 4710352 9871360
23:14:10 1328 8192000000 10867270256 11269349376 1920595760 18.992 100 96 199 3 1957778432 10196720 26985952
23:14:18 5456 8192000000 10817550976 11253805056 1908700208 18.896 100 31 61 1 1925250272 8118208 8431856
23:14:30 7315 8192000000 10827493520 11258281984 1910233808 18.909 100 30 60 1 1924982800 5973168 8775824
23:14:44 5267 8192000000 10836894432 11266224128 1911863120 18.922 100 30 61 1 1927688848 6492992 9332736
23:14:59 2850 8192000000 10835738880 11266093056 1913823056 18.937 100 33 67 0 1931538752 8832224 8883472
23:15:08 5965 8192000000 10822976992 11264888832 1913197296 18.932 100 32 63 2 1928748592 6751312 8799984
23:15:21 5636 8192000000 10832218384 11263393792 1912959504 18.930 100 23 46 1 1925514400 5908960 6645936
23:15:34 10791 8192000000 10826013792 11264688128 1915129424 18.948 100 28 54 2 1928786784 5522480 8134880
23:15:52 6488 8192000000 10839244384 11269885952 1916288592 18.957 100 22 44 1 1932366848 10519904 5558352
23:16:05 6093 8192000000 10816140480 11255283712 1893604752 18.775 99 15 30 0 1903412688 5725280 4082656
23:16:17 7070 8192000000 10818903088 11259650048 1909811808 18.905 100 16 32 3 1920178528 6209232 4157488
23:16:30 7227 8192000000 10805723120 11244949504 1885624160 18.710 99 13 26 3 1894308352 4842352 3841840
23:16:47 49180 8192000000 10820448224 11242819584 1868168352 18.569 98 32 64 1 1883501376 5414736 9918288
23:17:44 22712 8192000000 10793794368 11232952320 1828184624 18.245 96 22 45 1 1840311456 5367008 6759824
23:18:14 7649 8192000000 10789658496 11217121280 1847991872 18.406 98 25 50 2 1860414496 5188240 7234384
23:18:28 6702 8192000000 10790234176 11216347136 1845614432 18.386 98 40 80 0 1863666480 6305280 11746768
23:18:41 6001 8192000000 10796298128 11216764928 1853716592 18.452 99 30 58 2 1873044784 10144672 9183520
23:18:53 7001 8192000000 10783406816 11198529536 1821583552 18.191 97 23 45 0 1834425664 6590768 6251344
23:19:06 5125 8192000000 10777413920 11204173824 1849763056 18.420 99 37 74 5 1866850944 5459488 11628400
23:19:18 4771 8192000000 10776253024 11200376832 1842827008 18.364 99 35 69 0 1858518624 5789008 9902608
23:19:29 5957 8192000000 10747423344 11167137792 1786916320 17.906 97 33 62 3 1802338288 6392288 9029680
23:19:42 4297 8192000000 10727300352 11140509696 1741668080 17.532 95 28 56 0 1755897120 6088976 8140064
23:19:56 7278 8192000000 10710200128 11121782784 1731700512 17.450 96 32 64 3 1746111024 5687472 8723040
23:20:11 6463 8192000000 10699533504 11122454528 1780034368 17.850 99 30 60 0 1799430672 10960544 8435760
23:20:26 5428 8192000000 10685583296 11097317376 1747779584 17.583 97 28 56 2 1761339552 5570880 7989088
23:20:44 9037 8192000000 10695352784 11114397696 1771926176 17.783 99 17 34 0 1783556736 5535456 6095104
23:21:03 11267 8192000000 10698934000 11105943552 1700020624 17.185 95 15 31 0 1709444000 5451136 3972240
23:21:28 75180 8192000000 10713990480 11141181440 1780698464 17.855 98 32 64 1 1795478608 5437888 9342256
23:22:49 10145 8192000000 10731177104 11154599936 1818941328 18.169 100 30 60 0 1833970496 6425488 8603680
23:23:06 6579 8192000000 10743157568 11158548480 1821191888 18.187 100 33 66 0 1837928128 7644944 9091296
23:23:19 6748 8192000000 10758765408 11167870976 1828833232 18.250 100 46 92 0 1849486704 8142896 12510576
23:23:34 5115 8192000000 10750955312 11169878016 1835371152 18.303 100 30 60 1 1850485536 6387712 8726672
23:23:47 10873 8192000000 10756661568 11179884544 1840471504 18.345 100 28 56 1 1854412384 5858720 8082160
23:24:11 8025 8192000000 10769588640 11183767552 1844266336 18.376 100 26 51 3 1857924000 5977104 7680560
23:24:28 8670 8192000000 10769085520 11189170176 1845253104 18.384 100 13 26 4 1853942048 5049104 3639840
23:24:45 4409 8192000000 10765377248 11189972992 1850370720 18.425 100 31 62 3 1865280144 5442784 9466640
23:24:56 8606 8192000000 10774353264 11197390848 1856954368 18.479 100 25 49 3 1870049952 5987504 7108080
23:25:13 8608 8192000000 10767779520 11200704512 1857919296 18.486 100 17 34 0 1868638752 5196752 5522704
23:25:27 7681 8192000000 10786067408 11214794752 1865614240 18.549 100 23 46 3 1877971008 5588816 6767952
23:25:41 9535 8192000000 10778364800 11211890688 1869629392 18.581 100 24 48 1 1882181056 5591072 6960592
23:25:58 18683 8192000000 10792513216 11220013056 1872061904 18.601 100 21 43 1 1883372656 5344976 5965776
23:26:23 67287 8192000000 10810218224 11229495296 1879127136 18.658 100 27 56 1 1893073360 5423488 8522736
23:27:48 48747 8192000000 10829671904 11258757120 1907499504 18.887 100 37 74 2 1925022064 6745824 10776736
23:28:55 19381 8192000000 10852085408 11281784832 1921769344 19.001 100 36 72 2 1942612320 10664720 10178256
23:29:21 10018 8192000000 10864978992 11290148864 1938003488 19.131 100 53 106 0 1964715216 10390512 16321216
23:29:43 6067 8192000000 10882761376 11302576128 1944555040 19.183 100 56 110 2 1972539888 12483248 15501600
23:29:58 23805 8192000000 10888049696 11312869376 1948473072 19.214 100 46 92 0 1977942000 16040352 13428576
23:30:29 16528 8192000000 10881338768 11319599104 1953085472 19.251 100 41 81 2 1978843904 13889136 11869296
23:30:53 12741 8192000000 10886779024 11320840192 1958072560 19.291 100 45 90 0 1983752000 12228720 13450720
23:31:19 11433 8192000000 10892036992 11329777664 1962868336 19.329 100 31 62 0 1984309056 12932368 8508352
23:31:41 21949 8192000000 10894830960 11335950336 1967601184 19.366 100 32 64 0 1990224224 13452288 9170752
23:32:19 16156 8192000000 10912643008 11350241280 1981161056 19.474 100 53 106 1 2014538016 17461200 15915760
23:32:42 16573 8192000000 10922354448 11349274624 1975124912 19.426 100 45 88 3 2006489360 18407488 12956960
23:33:06 6511 8192000000 10930289136 11352055808 1977655328 19.446 100 63 126 2 2016145728 20085488 18404912
23:33:20 21442 8192000000 10920914656 11352711168 1978308832 19.451 100 53 105 1 2014911840 21510640 15092368
23:33:53 22778 8192000000 10924806688 11359305728 1981902272 19.480 100 43 86 1 2015573792 20463968 13207552
23:34:24 27512 8192000000 10917904960 11355746304 1983892416 19.496 100 41 82 1 2016382672 20008176 12482080
23:35:00 3476 8192000000 10933595328 11362320384 1993547680 19.572 100 55 110 1 2031227920 21392864 16287376
23:35:16 32475 8192000000 10948479984 11379757056 1980874624 19.472 99 44 88 2 2018109904 23949456 13285824
23:36:01 10054 8192000000 10950489584 11377754112 1982558512 19.485 99 49 96 1 2028563648 30590736 15414400
23:36:20 5531 8192000000 10956176304 11388469248 2002713264 19.644 100 59 116 3 2049041216 27295968 19031984
23:36:34 8140 8192000000 10965442512 11395866624 2007778848 19.684 100 57 112 0 2053827408 28164576 17883984
23:36:50 10541 8192000000 10955858464 11391115264 1988009248 19.528 99 64 126 2 2036873184 29444368 19419568
23:37:11 17071 8192000000 10952814896 11392335872 2004856720 19.661 100 53 106 3 2048823360 27055088 16911552
23:37:39 13088 8192000000 10944209888 11382525952 1988127200 19.529 99 42 84 1 2024389984 23547680 12715104
23:37:58 7371 8192000000 10964474080 11391102976 2004099264 19.655 100 54 108 1 2045685936 25291904 16294768
23:38:21 4923 8192000000 10960981840 11392552960 2007665488 19.683 100 68 135 2 2055163216 26421232 21076496
23:38:33 3693 8192000000 10962385344 11392806912 2006505456 19.674 100 66 131 0 2051804096 25137152 20161488
23:38:47 5843 8192000000 10969536144 11395940352 2009813168 19.700 100 66 130 0 2054922272 25679632 19429472
23:39:04 4530 8192000000 10981755728 11404029952 2014544576 19.737 100 68 135 1 2061677664 27175200 19957888
23:39:16 5436 8192000000 10974176800 11402072064 2011869152 19.716 100 75 149 0 2061784528 27460736 22454640
23:39:29 2771 8192000000 10994421376 11406929920 2017251936 19.759 100 91 180 1 2072884848 29007872 26625040
23:39:39 6195 8192000000 10993641456 11411783680 2020663040 19.785 100 88 175 2 2077551152 30811776 26076336
23:39:54 3668 8192000000 10990883296 11409182720 2015174976 19.742 100 79 158 0 2070414192 31146240 24092976
23:40:05 6496 8192000000 10975323536 11407290368 2015416032 19.744 100 60 120 0 2062982976 29225200 18341744
23:40:20 2126 8192000000 10995846400 11410243584 2017118416 19.758 100 84 169 2 2070800576 28577616 25104544
23:40:29 2737 8192000000 10990635392 11401580544 2008496992 19.690 100 88 169 2 2065554048 31035760 26021296
23:40:39 857 8192000000 10984295504 11396562944 2006632384 19.675 100 95 190 1 2066933824 32558032 27743408
23:40:47 2632 8192000000 10962048304 11380228096 1991876704 19.559 100 81 162 1 2048673552 31934960 24861888
23:41:01 4488 8192000000 10960278352 11375738880 1980452272 19.468 100 73 146 1 2036015536 33457792 22105472
23:41:13 5429 8192000000 10957078048 11373559808 1982094544 19.481 100 82 162 0 2040238704 33360912 24783248
23:41:29 3897 8192000000 10962661152 11383910400 1989861072 19.543 100 70 140 3 2045866176 34165760 21839344
23:41:40 2381 8192000000 10954244784 11363307520 1941748448 19.161 97 83 164 1 2004131792 37497408 24885936
23:41:52 2806 8192000000 10974263648 11385593856 1987538848 19.524 100 81 160 2 2051836672 38882032 25415792
23:42:02 4301 8192000000 10950012720 11370233856 1952432528 19.246 99 71 140 2 2014053056 39191424 22429104
23:42:19 4410 8192000000 10960179152 11383513088 1983869696 19.495 100 66 130 0 2046607280 41712944 21024640
23:42:31 4578 8192000000 10922196736 11341594624 1901711168 18.840 97 70 140 1 1967684880 42922000 23051712
23:42:47 5974 8192000000 10929495408 11344642048 1928683296 19.056 99 68 134 0 1995192112 44755648 21753168
23:43:00 2445 8192000000 10949834512 11367350272 1958744800 19.296 100 76 153 1 2033760416 50471552 24544064
23:43:10 6927 8192000000 10945106688 11361783808 1954584048 19.263 100 71 140 0 2025990352 48459216 22947088
23:43:25 6147 8192000000 10947905312 11370913792 1960660272 19.311 100 70 139 2 2034282752 50167536 23454944
23:43:42 3033 8192000000 10956117584 11372142592 1965841232 19.352 100 80 160 2 2039237440 48546784 24849424
23:43:53 12378 8192000000 10957142864 11382091776 1956020928 19.274 99 68 136 0 2026534912 48998960 21515024
23:44:19 2637 8192000000 10941635200 11361275904 1958289024 19.292 100 70 138 1 2027045424 46759200 21997200
23:44:33 4520 8192000000 10953011504 11371700224 1954145120 19.259 99 69 138 2 2021447504 45291888 22010496
23:44:46 4162 8192000000 10955830256 11369938944 1970462864 19.389 100 76 152 1 2035882688 41933056 23486768
23:44:57 1349 8192000000 10972725104 11388002304 1982830720 19.487 100 88 174 0 2053762912 43692128 27240064
23:45:06 10743 8192000000 10938987856 11381014528 1969359808 19.380 100 56 112 0 2033476896 46107600 18009488
23:45:33 6476 8192000000 10930030320 11366440960 1966987344 19.362 100 58 116 2 2024883648 39240592 18655712
23:45:53 6477 8192000000 10940774848 11375501312 1967310848 19.364 100 57 114 1 2027578736 41531728 18736160
23:46:09 4969 8192000000 10975943088 11396894720 1988581744 19.533 100 68 135 1 2054226064 43946112 21698208
23:46:21 12979 8192000000 10940042128 11376099328 1940346432 19.150 98 45 90 2 1997806864 42692784 14767648
23:46:43 18424 8192000000 10936122160 11380412416 1969436784 19.381 100 35 68 1 2019521376 38627536 11457056
23:47:11 9752 8192000000 10933038192 11379666944 1966656496 19.359 100 30 60 0 2018252944 40705616 10890832
23:47:28 5053 8192000000 10950284176 11383242752 1973046880 19.410 100 49 96 1 2032387792 43068288 16272624
23:47:40 10781 8192000000 10974521072 11395387392 1978474736 19.453 100 61 124 1 2042791696 43463808 20853152
23:48:00 4507 8192000000 10973800816 11397652480 1984409200 19.500 100 81 162 0 2055076160 45536816 25130144
23:48:12 3888 8192000000 10984539088 11408289792 1990500256 19.548 100 75 151 0 2060965552 46772336 23692960
23:48:30 14476 8192000000 10929174160 11387260928 1965628608 19.351 99 29 58 2 2008561616 33577392 9355616
23:48:51 5556 8192000000 10941639600 11386306560 1981261648 19.475 100 41 82 1 2024253440 29646336 13345456
23:49:02 15041 8192000000 10916350928 11370160128 1922954544 19.011 97 31 62 1 1965853552 32999840 9899168
23:49:28 11380 8192000000 10902171904 11353841664 1914511888 18.943 98 30 60 1 1956089264 31800464 9776912
23:49:52 13735 8192000000 10913972816 11363053568 1958156896 19.291 100 26 52 4 2000058560 33434432 8467232
23:50:17 21880 8192000000 10927094528 11372625920 1963178352 19.331 100 29 58 1 2008309728 35283632 9847744
23:50:46 10017 8192000000 10934196592 11372421120 1956073600 19.275 99 43 82 2 2005180768 36422224 12684944
23:51:04 15468 8192000000 10909575792 11360714752 1942288416 19.165 99 35 70 2 1992141056 38498848 11353792
23:51:34 12067 8192000000 10923740800 11368902656 1930696672 19.072 98 30 60 1 1979923920 39396976 9830272
23:51:54 23982 8192000000 10913130592 11358834688 1930984720 19.075 99 31 62 1 1985225776 43430816 10810240
23:52:24 19089 8192000000 10894811584 11341287424 1913217264 18.932 99 24 48 2 1964789376 43156576 8415536
23:52:50 17030 8192000000 10898688144 11348393984 1923939360 19.018 100 20 40 1 1980887280 49581056 7366864
23:53:22 28621 8192000000 10869908192 11319779328 1874465056 18.620 98 17 34 0 1924401920 43276240 6660624
23:53:57 13761 8192000000 10862242560 11305172992 1839962912 18.341 97 26 53 0 1898862800 49439552 9460336
23:54:19 33619 8192000000 10884736768 11338391552 1895908064 18.793 100 29 58 1 1966010896 59683744 10419088
23:54:59 11894 8192000000 10869466160 11316338688 1878868384 18.656 99 20 40 0 1936112224 49912704 7331136
23:55:18 9147 8192000000 10873665760 11333406720 1899743472 18.824 100 23 45 1 1960302256 53168064 7390720
23:55:59 73909 8192000000 10853381152 11337916416 1905794992 18.873 100 11 22 2 1939478224 30593520 3089712
23:57:21 22774 8192000000 10851378016 11304988672 1899685232 18.824 99 23 45 2 1917588336 11498512 6404592
23:58:12 20658 8192000000 10871035472 11321499648 1931738224 19.081 100 26 53 2 1949742800 11246768 6757808
23:59:01 84747 8192000000 10862443680 11337482240 1920614416 18.992 99 15 30 0 1937470352 12935584 3920352
00:01:56 81240 8192000000 10887180640 11354796032 1932083008 19.084 99 16 32 2 1956456832 19948816 4425008
00:04:00 53580 8192000000 10882596640 11334049792 1909998400 18.907 98 10 20 2 1925972048 13022144 2951504
00:05:04 121122 8192000000 10862156400 11326963712 1914835888 18.945 99 18 35 1 1933294640 13282032 5176720
00:07:16 75317 8192000000 10875622432 11322462208 1899759296 18.824 98 30 52 2 1918652832 11453840 7439696
00:08:46 34323 8192000000 10855020512 11325059072 1927455056 19.047 100 15 30 2 1946191280 14014448 4721776
00:09:27 18646 8192000000 10882221136 11324923904 1925897584 19.034 99 38 77 0 1944548336 7328800 11321952
00:10:01 47599 8192000000 10850282384 11320303616 1906490352 18.878 98 15 30 1 1921130688 10466352 4173984
00:10:55 50976 8192000000 10865621872 11335196672 1938322224 19.133 100 8 16 0 1954519552 14027440 2169888
00:12:06 72658 8192000000 10886209552 11353325568 1952824912 19.249 100 32 65 1 1981028928 19303680 8900336
00:15:41 58346 8192000000 10885402704 11360043008 1962796080 19.328 100 15 30 0 1980412208 13367824 4248304
00:16:54 35774 8192000000 10899744336 11358404608 1972563248 19.406 100 38 76 4 1990019632 7383120 10073264
00:17:53 63495 8192000000 10883575216 11361476608 1966185280 19.355 100 16 32 0 1982689904 12476800 4027824
00:19:17 58325 8192000000 10911647808 11371134976 1971311744 19.396 100 13 26 0 1984396768 9418080 3666944
00:20:30 103878 8192000000 10882259328 11362222080 1949751248 19.224 99 8 16 0 1964193152 11652672 2789232
00:22:38 57484 8192000000 10895332208 11378180096 1971695568 19.399 100 23 46 2 1989678384 11199328 6783488
00:23:55 81386 8192000000 10909863360 11381465088 1958652944 19.295 99 11 22 1 1972970064 11213136 3103984
00:25:59 37749 8192000000 10893203184 11363135488 1927029568 19.043 98 17 34 0 1943331376 11772752 4529056
00:27:14 69127 8192000000 10900161984 11387691008 1976421376 19.436 100 14 28 0 1996628304 16288384 3918544
00:28:32 44584 8192000000 10891662096 11345055744 1923875216 19.018 98 27 52 1 1944627840 13809344 6943280
00:29:28 35853 8192000000 10870504416 11325435904 1859359728 18.498 95 24 48 1 1873793344 8039888 6393728
00:30:21 47216 8192000000 10897395024 11341488128 1909098400 18.899 98 26 52 0 1927982192 11726512 7157280
00:31:15 39991 8192000000 10892555072 11352346624 1952155120 19.244 100 29 58 0 1969937120 10063920 7718080
00:32:02 39569 8192000000 10902599088 11357003776 1918826576 18.977 98 35 70 4 1939134576 10442752 9865248
00:32:51 55107 8192000000 10913811104 11362578432 1907219328 18.884 97 31 61 2 1928330112 13032624 8078160
00:34:07 89447 8192000000 10862138656 11331362816 1856813904 18.477 95 6 12 1 1875315056 16675648 1825504
00:35:43 126299 8192000000 10867216912 11331465216 1814553984 18.133 93 7 14 1 1830634912 14224528 1856400
00:38:00 99118 8192000000 10822869424 11278860288 1816965504 18.153 94 20 40 0 1832884112 10078592 5840016
00:39:48 42674 8192000000 10852486896 11289264128 1865515568 18.548 97 48 96 1 1891220304 12552944 13151792
00:40:39 52316 8192000000 10847439136 11306094592 1899111136 18.819 99 38 75 1 1928128400 17690592 11326672
00:42:25 49025 8192000000 10852648832 11326640128 1932589168 19.088 100 22 44 0 1951424512 12255424 6579920
00:43:21 67430 8192000000 10824772688 11299106816 1853729664 18.452 96 6 12 0 1863828832 8714832 1384336
00:44:46 41895 8192000000 10839740896 11300229120 1900082352 18.827 99 26 53 2 1916692576 8393168 8217056
00:46:03 51012 8192000000 10833111936 11294408704 1911394576 18.918 99 11 22 0 1922169584 7697072 3077936
00:48:09 72605 8192000000 10852656816 11325489152 1911152048 18.916 99 19 38 2 1936608144 19612416 5843680
00:49:29 77563 8192000000 10825695248 11301085184 1849130544 18.415 96 9 18 0 1862675216 11127616 2417056
00:50:59 57771 8192000000 10827605152 11290103808 1866325408 18.555 98 15 30 0 1880772976 10338944 4108624
00:52:03 90344 8192000000 10843717680 11303677952 1869460864 18.580 97 13 26 1 1887294176 13733456 4099856
00:53:44 50233 8192000000 10864803856 11327176704 1925724560 19.033 99 25 49 3 1947000016 13486912 7788544
00:54:44 64752 8192000000 10854425296 11320819712 1881858336 18.680 97 19 38 0 1899681824 12276256 5547232
00:56:01 48152 8192000000 10857193776 11318292480 1893890512 18.777 98 16 33 0 1908847024 10755072 4201440
00:57:04 62162 8192000000 10860084032 11316781056 1894873328 18.785 98 19 38 2 1916851664 16660848 5317488
00:58:15 55486 8192000000 10870636464 11328454656 1899279168 18.820 98 24 48 1 1915666448 10041152 6346128
00:59:21 42901 8192000000 10873262800 11333328896 1894489392 18.782 97 25 50 1 1913783824 12467456 6826976
01:00:13 32558 8192000000 10890605184 11350994944 1951559600 19.239 100 35 70 0 1978887872 17030512 10297760
01:00:59 74496 8192000000 10887454320 11354345472 1916540528 18.959 98 12 24 0 1935546656 15794192 3211936
01:02:20 76265 8192000000 10904095808 11376660480 1964465856 19.342 100 14 28 1 1987334400 19094672 3773872
01:04:28 118876 8192000000 10899448960 11375931392 1976598048 19.438 100 17 34 0 1996005088 14971440 4435600
01:06:39 95845 8192000000 10903275232 11358236672 1919402720 18.982 97 29 56 1 1935305328 7554080 8348528
01:08:21 62650 8192000000 10883998800 11353624576 1936561424 19.119 98 28 56 2 1957885344 13535456 7788464
01:09:34 60754 8192000000 10889024688 11376291840 1962497056 19.326 100 11 22 1 1982755984 16939152 3319776
01:10:56 44064 8192000000 10885923744 11376861184 1942872368 19.170 99 14 29 1 1964372576 17492672 4007536
01:12:32 36879 8192000000 10889454640 11353640960 1943366704 19.174 98 24 48 1 1959484592 8771552 7346336
01:13:38 67854 8192000000 10896722320 11380965376 1981047440 19.473 100 8 16 0 1994787728 11185120 2555168
01:14:56 59514 8192000000 10914141248 11402276864 1988946112 19.535 100 14 28 0 2006206752 13785408 3475232
01:16:02 59855 8192000000 10885061648 11359555584 1942130496 19.164 98 6 12 0 1951400544 7842048 1428000
01:17:08 21389 8192000000 10932769296 11387322368 1983494896 19.492 100 37 73 0 2003220192 9119744 10605552
01:17:35 66331 8192000000 10897242160 11388895232 1966019168 19.354 99 16 32 2 1983677904 12891312 4767424
01:19:03 43192 8192000000 10897068848 11374292992 1956737760 19.280 99 17 34 0 1972399712 10965424 4696528
01:19:54 50153 8192000000 10893646128 11374436352 1950980288 19.234 99 13 26 2 1966093888 11658000 3455600
01:20:52 58379 8192000000 10888287632 11348963328 1877629248 18.646 95 16 32 1 1891784448 9726064 4429136
01:21:58 83159 8192000000 10885673872 11345301504 1881884544 18.680 96 23 46 1 1899739872 11629840 6225488
01:23:46 42385 8192000000 10875105616 11349336064 1923534608 19.015 98 26 52 2 1944397616 13441296 7421712
01:24:42 72240 8192000000 10873459104 11338735616 1896780624 18.800 97 17 34 0 1911931712 10317664 4833424
01:26:17 54392 8192000000 9608842240 9935982592 747402336 8.360 38 17 32 1 757882000 5836128 4643536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 07-11-2020 01:28:05 to 07-11-2020 01:28:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 94 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 07-11-2020 01:28:36 to 07-11-2020 01:28:38.

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          230154
MON$OLDEST_ACTIVE               231517
MON$OLDEST_SNAPSHOT             231517
MON$NEXT_TRANSACTION            231517
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                       2022784
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:145: 
:146: mscs-test-161.budzdorov.ru    Sat Nov  7 01:27:13 2020
:147:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:148: 
:149: 
:150: mscs-test-161.budzdorov.ru    Sat Nov  7 01:27:14 2020
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Sat Nov  7 01:27:20 2020
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
:157: 
:158: mscs-test-161.budzdorov.ru    Sat Nov  7 01:27:22 2020
:159:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:160: 
:161: 
:162: mscs-test-161.budzdorov.ru    Sat Nov  7 01:27:22 2020
:163:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:164: 
--- end of diff output ---

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

07.11.20 01:28:39. 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
2020-11-07 01:28:42 No severe PSQL-related problems occured
07.11.20 01:28:43. End of report.