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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-07 22:27:16
DTS_END                         2021-02-07 22:27:16.3800
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56240
TRN_ID                          233674
ATT_ID                          658
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: 9203.98 22359 1104478
customer order: creation 169.17 368 20300
customer order: refuse 13.74 335 1649
order to supplier: creation 45.29 1306 5435
order to supplier: removal 3.38 94641 406
invoice (draft): creation 44.36 3222 5323
invoice (draft): removal 54.33 749 6519
invoice accept: apply 40.64 17111 4877
invoice accept: cancel 48.58 789 5830
customer reserve: creation 3740.43 170 448851
customer reserve: removal 4754.86 53 570583
realization accept: apply 81.62 161 9794
realization accept: cancel 82.02 101 9842
payment from customer: creation 57.31 101 6877
payment from customer: removal 5.33 92 639
payment to supplier: creation 47.59 123 5711
payment to supplier: removal 3.20 76 384
service: total inventory turnovers 4.72 940 566
service: total monetary turnovers 6.61 21 793
service: aggregate perf. data 0.79 23215 95
service: refresh index statistics 0.03 303608 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-02-2021 22:28:40 to 07-02-2021 22:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5973
TEST_TIME 2 6045
TEST_TIME 3 4490
TEST_TIME 4 4488
TEST_TIME 5 4988
TEST_TIME 6 4648
TEST_TIME 7 4623
TEST_TIME 8 4954
TEST_TIME 9 5450
TEST_TIME 10 5576
TEST_TIME 11 5738
TEST_TIME 12 5997
TEST_TIME 13 6447
TEST_TIME 14 6955
TEST_TIME 15 7229
TEST_TIME 16 7362
TEST_TIME 17 7604
TEST_TIME 18 7582
TEST_TIME 19 7771
TEST_TIME 20 8282
TEST_TIME 21 8468
TEST_TIME 22 8699
TEST_TIME 23 9218
TEST_TIME 24 9219
TEST_TIME 25 9319
TEST_TIME 26 10665
TEST_TIME 27 10564
TEST_TIME 28 10361
TEST_TIME 29 10165
TEST_TIME 30 10047
TEST_TIME 31 9832
TEST_TIME 32 9996
TEST_TIME 33 9840
TEST_TIME 34 9809
TEST_TIME 35 9627
TEST_TIME 36 9577
TEST_TIME 37 9482
TEST_TIME 38 9378
TEST_TIME 39 9511
TEST_TIME 40 9506
TEST_TIME 41 9489
TEST_TIME 42 9510
TEST_TIME 43 9438
TEST_TIME 44 9367
TEST_TIME 45 9340
TEST_TIME 46 9264
TEST_TIME 47 9522
TEST_TIME 48 9564
TEST_TIME 49 9461
TEST_TIME 50 9471
TEST_TIME 51 9572
TEST_TIME 52 9562
TEST_TIME 53 9601
TEST_TIME 54 9609
TEST_TIME 55 9451
TEST_TIME 56 9476
TEST_TIME 57 9376
TEST_TIME 58 9384
TEST_TIME 59 9309
TEST_TIME 60 9290
TEST_TIME 61 9184
TEST_TIME 62 9086
TEST_TIME 63 9245
TEST_TIME 64 9184
TEST_TIME 65 9258
TEST_TIME 66 9258
TEST_TIME 67 9287
TEST_TIME 68 9268
TEST_TIME 69 9274
TEST_TIME 70 9312
TEST_TIME 71 9297
TEST_TIME 72 9358
TEST_TIME 73 9376
TEST_TIME 74 9374
TEST_TIME 75 9493
TEST_TIME 76 9547
TEST_TIME 77 9488
TEST_TIME 78 9494
TEST_TIME 79 9432
TEST_TIME 80 9372
TEST_TIME 81 9362
TEST_TIME 82 9365
TEST_TIME 83 9325
TEST_TIME 84 9273
TEST_TIME 85 9265
TEST_TIME 86 9243
TEST_TIME 87 9228
TEST_TIME 88 9174
TEST_TIME 89 9195
TEST_TIME 90 9258
TEST_TIME 91 9240
TEST_TIME 92 9270
TEST_TIME 93 9240
TEST_TIME 94 9279
TEST_TIME 95 9255
TEST_TIME 96 9328
TEST_TIME 97 9336
TEST_TIME 98 9410
TEST_TIME 99 9413
TEST_TIME 100 9420
TEST_TIME 101 9370
TEST_TIME 102 9461
TEST_TIME 103 9460
TEST_TIME 104 9383
TEST_TIME 105 9350
TEST_TIME 106 9343
TEST_TIME 107 9318
TEST_TIME 108 9284
TEST_TIME 109 9253
TEST_TIME 110 9241
TEST_TIME 111 9212
TEST_TIME 112 9184
TEST_TIME 113 9179
TEST_TIME 114 9170
TEST_TIME 115 9178
TEST_TIME 116 9244
TEST_TIME 117 9240
TEST_TIME 118 9218
TEST_TIME 119 9283
TEST_TIME 120 9208

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-02-2021 22:28:44 to 07-02-2021 22:28:47.

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 1521416 1521416 0 0.00 0 20006 6 0 0
doc_list_biud 1521416 1521416 0 0.00 0 66338 25 0 0
sp_add_invoice_to_stock 4973 4877 96 1.93 39 178928 17111 0 96
sp_cancel_adding_invoice 5830 5830 0 0.00 5 57347 790 0 0
sp_cancel_client_order 1649 1649 0 0.00 4 11728 336 0 0
sp_cancel_customer_reserve 570583 570583 0 0.00 1 66339 53 0 0
sp_cancel_pay_from_customer 639 639 0 0.00 2 7984 93 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 4194 77 0 0
sp_cancel_supplier_invoice 6528 6519 9 0.13 2 14364 750 0 9
sp_cancel_supplier_order 406 406 0 0.00 7 1022263 94642 0 0
sp_cancel_write_off 9842 9842 0 0.00 1 5344 101 0 0
sp_client_order 20300 20300 0 0.00 4 52338 369 0 0
sp_customer_reserve 448851 448851 0 0.00 0 46146 170 0 0
sp_fill_shopping_cart 31057 31057 0 0.00 1 20294 39 0 0
sp_fill_shopping_cart_clo_res 448844 448844 0 0.00 0 18637 15 0 0
sp_get_clo_for_invoice 4870 4870 0 0.00 0 36542 344 0 0
sp_kill_cost_storno 16695 16695 0 0.00 0 7976 50 0 0
sp_kill_qstorno_ret_qs2qd 1157933 1157933 0 0.00 0 66334 29 0 0
sp_kill_qty_storno 609493 609493 0 0.00 0 66336 63 0 0
sp_lock_selected_doc 20111 20111 0 0.00 0 10379 4 0 0
sp_make_cost_storno 27252 27252 0 0.00 0 19967 50 0 0
sp_multiply_rows_for_pdistr 27252 27252 0 0.00 0 7105 26 0 0
sp_multiply_rows_for_qdistr 20300 20300 0 0.00 0 50703 173 0 0
sp_pay_from_customer 6877 6877 0 0.00 4 14857 101 0 0
sp_pay_to_supplier 5711 5711 0 0.00 5 20019 123 0 0
sp_payment_common 12588 12588 0 0.00 1 14850 25 0 0
sp_qd_handle_on_cancel_clo 1649 1649 0 0.00 0 11722 302 0 0
sp_qd_handle_on_invoice_upd_sts 10700 10700 0 0.00 0 36641 293 0 0
sp_qd_handle_on_reserve_upd_sts 9794 9794 0 0.00 0 12392 54 0 0
sp_reserve_write_off 9794 9794 0 0.00 6 13536 161 0 0
sp_supplier_invoice 5323 5323 0 0.00 6 73297 3222 0 0
sp_supplier_order 5435 5435 0 0.00 5 35945 1306 0 0
srv_aggregate_perf_data 95 95 0 0.00 2592 296763 23216 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1160 130488 35097 0 0
srv_find_qd_qs_mism 1058650 1058650 0 0.00 0 14214 5 0 0
srv_make_invnt_saldo 566 566 0 0.00 38 52183 940 0 0
srv_make_money_saldo 793 793 0 0.00 1 1867 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 152422 623062 303609 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 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 4877 4877 0 0.00 0 15122 190 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 3593 100 0 0
t$perf-norm:sp_cancel_client_order 1649 1649 0 0.00 0 3886 12 0 0
t$perf-norm:sp_cancel_customer_reserve 647 647 0 0.00 0 6072 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 639 639 0 0.00 0 9950 30 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 7448 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 672 14 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 40398 1765 0 0
t$perf-norm:sp_cancel_write_off 914 914 0 0.00 0 4009 11 0 0
t$perf-norm:sp_client_order 20300 20300 0 0.00 0 13042 17 0 0
t$perf-norm:sp_customer_reserve 944 944 0 0.00 0 2594 9 0 0
t$perf-norm:sp_pay_from_customer 6877 6877 0 0.00 0 13694 15 0 0
t$perf-norm:sp_pay_to_supplier 5711 5711 0 0.00 0 9357 14 0 0
t$perf-norm:sp_reserve_write_off 9794 9794 0 0.00 0 9561 13 0 0
t$perf-norm:sp_supplier_invoice 5323 5323 0 0.00 0 13646 23 0 0
t$perf-norm:sp_supplier_order 5435 5435 0 0.00 0 9018 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 401 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 3541 37 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 1164 23 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 18288 34 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 26 8 0 0
v_add_invoice_to_stock 9932 9740 192 1.93 0 13638 20 0 192
v_all_customers 37058 37058 0 0.00 0 116 1 0 0
v_all_suppliers 29982 29982 0 0.00 0 15 1 0 0
v_all_wares 40600 40600 0 0.00 0 113 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 2294 12 0 0
v_cancel_client_order 3298 3298 0 0.00 0 2596 6 0 0
v_cancel_customer_prepayment 1278 1278 0 0.00 0 3946 13 0 0
v_cancel_customer_reserve 1294 1294 0 0.00 0 3845 7 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 4186 9 0 0
v_cancel_supplier_invoice 816 798 18 2.20 0 1416 15 0 18
v_cancel_supplier_order 812 812 0 0.00 0 9353 17 0 0
v_cancel_write_off 1828 1828 0 0.00 0 3831 15 0 0
v_max_id_clo_ord 5435 5435 0 0.00 0 587 1 0 0
v_max_id_clo_res 944 944 0 0.00 0 3461 23 0 0
v_max_id_ord_sup 5322 5322 0 0.00 0 3170 4 0 0
v_max_non_paid_invoice 1477 1477 0 0.00 0 2079 4 0 0
v_max_non_paid_realizn 3634 3634 0 0.00 0 1508 3 0 0
v_min_id_clo_ord 5435 5435 0 0.00 0 4702 9 0 0
v_min_id_clo_res 944 944 0 0.00 0 8372 27 0 0
v_min_id_ord_sup 5322 5322 0 0.00 0 7281 11 0 0
v_min_non_paid_invoice 5711 5711 0 0.00 0 5974 18 0 0
v_min_non_paid_realizn 6877 6877 0 0.00 0 9013 14 0 0
v_our_firm 10028 10028 0 0.00 0 17 1 0 0
v_reserve_write_off 19588 19588 0 0.00 0 13365 8 0 0
x_lock_depdocs_on_canc_invoice 11950 11950 0 0.00 0 14606 100 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 5305 315 0 0
x_make_qstorno_1000_1200 5435 5435 0 0.00 2 35933 1232 0 0
x_make_qstorno_1200_2000 5323 5323 0 0.00 3 73291 3074 0 0
x_make_qstorno_2100_3300 448851 448851 0 0.00 0 46144 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-02-2021 22:28:48 to 07-02-2021 22:28:52.

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:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:26 13160 8192000000 10221592928 10518310912 786379104 8.758 63 51 103 0 806104592 2327104 17398384
19:57:47 34546 8192000000 10359193056 10675355648 1376979152 14.390 100 86 170 1 1409748016 4731520 28037344
19:58:32 3188 8192000000 10375470704 10693394432 1434942496 14.905 100 92 184 0 1470905472 6295824 29667152
19:58:44 24751 8192000000 10392215088 10718486528 1449426448 15.033 100 93 186 0 1487184896 7047264 30711184
19:59:23 28845 8192000000 10418670112 10747953152 1465553616 15.175 100 84 167 2 1500704320 8006608 27144096
20:00:04 29742 8192000000 10439726384 10771435520 1492364288 15.410 100 89 178 0 1533756272 12820688 28571296
20:00:46 6343 8192000000 10442505424 10777026560 1503047648 15.503 100 85 170 0 1538873040 8896176 26929216
20:01:04 23152 8192000000 10464078192 10801725440 1517080992 15.625 100 83 166 1 1553063744 9498464 26484288
20:01:37 17433 8192000000 10483279840 10828472320 1536820896 15.796 100 74 148 0 1569145856 9486208 22838752
20:02:07 12727 8192000000 10521534304 10871783424 1577089424 16.143 100 85 170 1 1613453968 10424144 25940400
20:02:31 14979 8192000000 10552082832 10904764416 1606039968 16.391 100 81 162 1 1641309312 11368912 23900432
20:02:56 9740 8192000000 10574806064 10932797440 1627330080 16.572 100 78 157 1 1662739648 12118112 23291456
20:03:14 12555 8192000000 10592536960 10955227136 1654432208 16.802 100 88 177 0 1693264576 12748304 26084064
20:03:34 9228 8192000000 10615894496 10980298752 1671059840 16.942 100 86 172 0 1710165520 13693872 25411808
20:04:00 11385 8192000000 10637856720 11004305408 1694561584 17.140 100 84 166 1 1731291584 12750752 23979248
20:04:19 7966 8192000000 10650012848 11019870208 1708135968 17.253 100 79 158 2 1742739584 12571760 22031856
20:04:36 7626 8192000000 10653389920 11027918848 1716912064 17.326 100 78 156 1 1751895104 12595696 22387344
20:04:50 7226 8192000000 10661016976 11036631040 1722750128 17.375 100 79 158 1 1759200816 13502960 22947728
20:05:05 6028 8192000000 10683678352 11058606080 1743290640 17.546 100 83 164 1 1779766768 13184816 23291312
20:05:18 4707 8192000000 10686730080 11062239232 1750601968 17.607 100 71 143 0 1782309232 11951344 19755920
20:05:30 4699 8192000000 10695248096 11074977792 1759477200 17.680 100 66 132 1 1789580464 11509056 18594208
20:05:41 4106 8192000000 10708043424 11088187392 1771922992 17.783 100 82 164 0 1807653664 12377984 23352688
20:05:52 12005 8192000000 10699682656 11091300352 1776267264 17.819 100 67 134 1 1807647392 11758096 19622032
20:06:11 4071 8192000000 10726065744 11111829504 1789462544 17.927 100 71 142 1 1821750144 11965728 20321872
20:06:22 5174 8192000000 10744703840 11130744832 1808670512 18.085 100 82 161 0 1843448240 11549936 23227792
20:06:34 4383 8192000000 10744666720 11134742528 1815998928 18.145 100 74 148 1 1847933680 11274176 20660576
20:06:46 2518 8192000000 10755307216 11142324224 1819110848 18.170 100 82 163 1 1854232512 11498224 23623440
20:06:55 3178 8192000000 10769146640 11150364672 1825731984 18.225 100 93 186 0 1865142560 13490528 25920048
20:07:05 3750 8192000000 10770985984 11158323200 1830309648 18.262 100 87 172 0 1868093568 12764304 25019616
20:07:15 2612 8192000000 10778403840 11162357760 1834628576 18.297 100 95 189 0 1874934288 14276800 26028912
20:07:25 1888 8192000000 10776172240 11165376512 1841313216 18.351 100 90 180 1 1879907040 13215648 25378176
20:07:33 2229 8192000000 10786143408 11171598336 1845641104 18.387 100 93 186 1 1884937440 13456592 25839744
20:07:42 2567 8192000000 10789613616 11177324544 1843966944 18.373 100 84 164 0 1880803392 13859168 22977280
20:07:50 2170 8192000000 10797902448 11182878720 1852740032 18.444 100 93 186 2 1892437712 13857248 25840432
20:07:59 2046 8192000000 10795996832 11181756416 1850677280 18.428 100 92 187 1 1891045136 13818144 26549712
20:08:08 2090 8192000000 10795197664 11181035520 1852309536 18.441 100 93 186 1 1892844256 14536576 25998144
20:08:16 1859 8192000000 10802498032 11187425280 1857884096 18.486 100 94 189 0 1896896208 11939344 27072768
20:08:24 1589 8192000000 10805881888 11192651776 1858998480 18.495 100 94 188 2 1899953232 13177248 27777504
20:08:32 13733 8192000000 10794955952 11189133312 1858184416 18.489 100 78 157 1 1893481712 13195504 22101792
20:08:53 9701 8192000000 10802415664 11193851904 1862619600 18.525 100 87 175 0 1899509968 12506784 24383584
20:09:10 1890 8192000000 10806111632 11194609664 1863863856 18.535 100 90 181 0 1901756144 11424016 26468272
20:09:18 8360 8192000000 10812888080 11198558208 1866186544 18.553 100 93 184 2 1905421776 12423520 26811712
20:09:33 25123 8192000000 10777330288 11193069568 1860885440 18.510 100 58 116 4 1889941616 12617936 16438240
20:10:05 3282 8192000000 10783969408 11193647104 1863922176 18.535 100 54 108 0 1887445872 7791728 15731968
20:10:18 3555 8192000000 10785327536 11197509632 1863477104 18.531 100 46 92 1 1884424016 8083072 12863840
20:10:29 4810 8192000000 10776093008 11197763584 1866440144 18.555 100 43 86 1 1886756720 8394048 11922528
20:10:41 2615 8192000000 10781701088 11200638976 1866156208 18.553 100 32 64 1 1883316736 8348256 8812272
20:10:51 5617 8192000000 10776896032 11203022848 1870998352 18.592 100 17 34 1 1881847728 6036160 4813216
20:11:06 5494 8192000000 10793957040 11210358784 1878919024 18.656 100 38 77 2 1897008544 6246896 11842624
20:11:20 6524 8192000000 10778831696 11208556544 1873790640 18.615 100 26 52 1 1887771616 6356832 7624144
20:11:34 5383 8192000000 10776418752 11208257536 1875885424 18.632 100 27 52 3 1890170160 6505440 7779296
20:11:47 8859 8192000000 10782253488 11214045184 1875508000 18.629 100 19 38 1 1887104832 6460496 5136336
20:12:02 5956 8192000000 10784102448 11216564224 1878411904 18.652 100 19 38 3 1889707840 5809104 5486832
20:12:16 9927 8192000000 10791229168 11221053440 1881884496 18.680 100 24 47 2 1894989200 6267472 6837232
20:12:34 5253 8192000000 10782752000 11219779584 1883680832 18.695 100 24 48 2 1896889168 6434928 6773408
20:12:50 9727 8192000000 10787637728 11219644416 1882622032 18.686 100 14 28 2 1892022400 5591936 3808432
20:13:07 13448 8192000000 10797016096 11227484160 1886582800 18.718 100 23 46 3 1899452208 6476720 6392688
20:13:27 20780 8192000000 10791510512 11225321472 1888478896 18.734 100 24 48 3 1901354480 5656016 7219568
20:13:59 65566 8192000000 10801047616 11239837696 1897170448 18.804 100 39 76 2 1912876336 5168368 10537520
20:15:11 5289 8192000000 10799959680 11242045440 1891745440 18.760 100 23 46 1 1904430960 6766368 5919152
20:15:23 8610 8192000000 10807811136 11243659264 1894853584 18.785 100 26 50 2 1908205312 6612944 6738784
20:15:38 5902 8192000000 10828090688 11251900416 1900903904 18.834 100 42 83 0 1919732736 7110592 11718240
20:15:52 6928 8192000000 10835159024 11256942592 1902428240 18.846 100 35 71 1 1919943632 6982864 10532528
20:16:06 9101 8192000000 10820155008 11255611392 1906671328 18.880 100 33 66 2 1922612112 6543696 9397088
20:16:22 11051 8192000000 10824210960 11255304192 1904444848 18.862 100 33 66 1 1919676160 5450624 9780688
20:16:39 10989 8192000000 10811485280 11242835968 1893826064 18.777 100 25 50 0 1908095440 6166000 8103376
20:16:57 5477 8192000000 10821649856 11255246848 1900476800 18.830 100 27 55 0 1914327328 6423200 7427328
20:17:09 10623 8192000000 10815567376 11242864640 1880610928 18.670 99 24 48 1 1893625088 5939888 7074272
20:17:30 8388 8192000000 10799627600 11229061120 1879470320 18.661 100 16 32 0 1889931200 5940960 4519920
20:17:45 7633 8192000000 10790990208 11224449024 1866275072 18.554 99 23 45 0 1879055872 6643824 6136976
20:18:02 8925 8192000000 10770645568 11198898176 1831409552 18.271 98 16 32 1 1840348320 4483184 4455584
20:18:20 9056 8192000000 10760644208 11181629440 1786175600 17.900 96 18 36 2 1797318496 6103920 5038976
20:18:37 63663 8192000000 10713512192 11128221696 1666410144 16.903 90 30 60 1 1680934672 4973184 9551344
20:19:49 16873 8192000000 10679054400 11093811200 1675570432 16.980 92 23 46 2 1686852448 5126848 6155168
20:20:12 5293 8192000000 10720409728 11127177216 1757382288 17.663 97 43 86 0 1777723152 8230480 12110384
20:20:25 6009 8192000000 10696810288 11097776128 1735247392 17.479 96 51 99 0 1756132496 6343312 14541792
20:20:37 5433 8192000000 10682388096 11096555520 1713484640 17.298 96 23 46 2 1725921856 5102224 7334992
20:20:52 6171 8192000000 10690022096 11101814784 1736504176 17.490 98 22 44 1 1748169504 5591344 6073984
20:21:08 7525 8192000000 10720418080 11130105856 1789529136 17.928 99 39 78 2 1808214816 7320160 11365520
20:21:24 6629 8192000000 10698555776 11109199872 1736378240 17.489 97 21 42 2 1748911792 5704384 6829168
20:21:39 15178 8192000000 10703549488 11121446912 1731686800 17.450 96 16 31 1 1741040448 4800960 4552688
20:22:02 7196 8192000000 10734376656 11155869696 1817653616 18.159 100 27 54 1 1832162496 6141936 8366944
20:22:16 9823 8192000000 10741748032 11162066944 1813056368 18.121 99 30 60 1 1827720528 5426048 9238112
20:22:32 10606 8192000000 10735145776 11149320192 1812847344 18.119 99 28 56 1 1826907680 6135552 7924784
20:22:49 6786 8192000000 10749894768 11160784896 1823098416 18.203 100 28 56 0 1837617952 6246048 8273488
20:23:02 25998 8192000000 10768893216 11175714816 1816922592 18.153 99 13 26 1 1826230800 5189424 4118784
20:23:34 69111 8192000000 10754002064 11186728960 1830284464 18.262 99 20 40 2 1841839152 5196832 6357856
20:24:51 13190 8192000000 10770105520 11197935616 1855748592 18.469 100 21 41 1 1868320560 6196064 6375904
20:25:15 4208 8192000000 10791018944 11209342976 1863091296 18.528 100 36 72 3 1881024528 6973728 10959504
20:25:26 9745 8192000000 10771731696 11205885952 1863232896 18.529 100 31 61 3 1878486320 6452880 8800544
20:25:43 5614 8192000000 10786569248 11207757824 1866010880 18.552 100 21 42 2 1877327840 4915264 6401696
20:25:58 8745 8192000000 10778580144 11213008896 1873602144 18.613 100 25 50 2 1886497840 4945744 7949952
20:26:13 13201 8192000000 10789098464 11218747392 1875540864 18.629 100 21 41 3 1887542256 5172512 6828880
20:26:38 11609 8192000000 10791760896 11225632768 1878835424 18.656 100 16 32 1 1888355104 5009952 4509728
20:26:58 10952 8192000000 10806976576 11237806080 1886172864 18.715 100 21 41 2 1901247472 9473120 5601488
20:27:18 4084 8192000000 10839474000 11255615488 1913696528 18.936 100 42 82 2 1930684000 5152688 11834784
20:27:33 11054 8192000000 10843115760 11267010560 1916968336 18.963 100 40 75 3 1934298032 6476048 10853648
20:27:57 40264 8192000000 10852662128 11277856768 1921011792 18.995 100 36 72 1 1938982464 8059936 9910736
20:28:44 10075 8192000000 10860687504 11289006080 1934029760 19.099 100 46 91 1 1958186128 10931648 13224720
20:29:02 20614 8192000000 10883747056 11301416960 1937927920 19.130 100 50 98 1 1961922768 10735664 13259184
20:29:35 9701 8192000000 10895388736 11307020288 1947979248 19.210 100 51 102 3 1973142912 10900160 14263504
20:29:53 85596 8192000000 10893218608 11324743680 1955892240 19.273 100 47 94 1 1986588384 17536864 13159280
20:31:26 10686 8192000000 10897164864 11325607936 1960400784 19.309 100 45 87 1 1986047264 12720912 12925568
20:31:45 40302 8192000000 10904680256 11339464704 1966237168 19.356 100 41 82 0 2000336560 22547264 11552128
20:32:33 12752 8192000000 10895448592 11335790592 1966211136 19.355 100 39 76 2 1992492448 14670240 11611072
20:33:03 31221 8192000000 10915972352 11353759744 1972166448 19.403 100 39 75 2 1995863248 12993184 10703616
20:33:46 36563 8192000000 10922925376 11369414656 1986067808 19.513 100 42 84 2 2018768672 20073232 12627632
20:34:29 23948 8192000000 10933843168 11372494848 1990423760 19.547 100 47 94 1 2024820144 20385440 14010944
20:35:00 11533 8192000000 10944382640 11376062464 1995576032 19.588 100 53 106 2 2033575744 22637392 15362320
20:35:19 24502 8192000000 10956612880 11386482688 2002814752 19.645 100 62 123 0 2043714464 22727680 18172032
20:35:52 9892 8192000000 10956160576 11390369792 2004891360 19.661 100 53 106 0 2044331824 23534080 15906384
20:36:20 4819 8192000000 10969231952 11398356992 2011933040 19.717 100 66 132 1 2056232992 24097520 20202432
20:36:32 3763 8192000000 10983234496 11404222464 2016836096 19.755 100 75 148 0 2064491744 25181472 22474176
20:36:45 6801 8192000000 10966653248 11403001856 2021188368 19.789 100 66 132 1 2064649840 23952368 19509104
20:37:01 4391 8192000000 10978825504 11406573568 2020688064 19.786 100 69 138 1 2064180848 22914880 20577904
20:37:15 5859 8192000000 10982621440 11409297408 2022419856 19.799 100 67 133 0 2066094944 23890736 19784352
20:37:30 3613 8192000000 10979550640 11413241856 2023022352 19.804 100 63 126 0 2071393664 29267136 19104176
20:37:41 6019 8192000000 10986933088 11414147072 2027286032 19.837 100 71 140 1 2072685200 24776928 20622240
20:37:55 2994 8192000000 10991780096 11415232512 2026767152 19.833 100 74 148 0 2073681200 24876720 22037328
20:38:06 6272 8192000000 10986828064 11415904256 2026722624 19.833 100 73 146 0 2074569280 26522512 21324144
20:38:23 3546 8192000000 10973243296 11401052160 1999747824 19.621 99 74 148 1 2050977024 28261248 22967952
20:38:35 2409 8192000000 10994195280 11413471232 2021882304 19.795 100 85 168 2 2074920928 27588416 25450208
20:38:44 1930 8192000000 10983201680 11407798272 2015660448 19.746 100 74 145 2 2068902960 31123648 22118864
20:38:55 15238 8192000000 10979129264 11416973312 2015888912 19.748 100 59 118 2 2065891904 31665120 18337872
20:39:18 8533 8192000000 10985293872 11418947584 2015882544 19.748 100 57 114 1 2067630160 33797344 17950272
20:39:35 12146 8192000000 10986795184 11424915456 2020685760 19.786 100 62 124 1 2077053248 36628608 19738880
20:39:54 14109 8192000000 10965424560 11407523840 1991491712 19.556 99 68 136 0 2052633888 39808896 21333280
20:40:20 5325 8192000000 10997436576 11425484800 2015830672 19.747 100 60 120 0 2075964400 41713232 18420496
20:40:33 2388 8192000000 11011603680 11438223360 2029293008 19.853 100 86 171 1 2094195856 39387552 25515296
20:40:41 4310 8192000000 11006961552 11433721856 2022867200 19.803 100 80 156 0 2089252144 42506128 23878816
20:40:52 2875 8192000000 11016305584 11443650560 2028387248 19.846 100 81 162 0 2096762224 43669872 24705104
20:41:04 2445 8192000000 10999490160 11427491840 2015324128 19.743 100 81 162 0 2086611856 45830736 25456992
20:41:13 2996 8192000000 10995557776 11422527488 1999291136 19.617 99 76 155 0 2066408080 43783808 23333136
20:41:23 4138 8192000000 10993972448 11427708928 2018116768 19.765 100 73 144 0 2085350432 44572080 22661584
20:41:36 5016 8192000000 10983545872 11411001344 1980252352 19.467 98 72 144 0 2041379776 39095456 22031968
20:41:48 3294 8192000000 10985387728 11411800064 1986442368 19.516 99 77 154 0 2051730192 41454656 23833168
20:42:05 6951 8192000000 10962774192 11394613248 1947273504 19.205 97 59 118 0 2008513824 41881024 19359296
20:42:19 1159 8192000000 10974873088 11399008256 1992101808 19.560 100 71 144 1 2054613824 40799312 21712704
20:42:27 2331 8192000000 10970453712 11387629568 1982825776 19.487 99 82 163 1 2049700288 41279888 25594624
20:42:37 6557 8192000000 10956999728 11389210624 1959693840 19.304 98 58 116 0 2018219872 40221632 18304400
20:42:55 7160 8192000000 10952351392 11388235776 1980950784 19.472 100 48 95 0 2035619904 38567328 16101792
20:43:10 4407 8192000000 10970245904 11399778304 1994411472 19.579 100 66 131 1 2052618016 37777312 20429232
20:43:22 4026 8192000000 10970178528 11404001280 1996173664 19.593 100 57 114 2 2053123984 39929152 17021168
20:43:37 1757 8192000000 11015415568 11435327488 2019518912 19.776 100 92 184 0 2091350832 44047616 27784304
20:43:45 1270 8192000000 11001231312 11426504704 2015987664 19.749 100 85 170 4 2083444128 42133184 25323280
20:43:53 11562 8192000000 10989696464 11416637440 1991823216 19.558 99 68 135 0 2055075984 42915968 20336800
20:44:14 6645 8192000000 10993131664 11419430912 1990749728 19.550 99 67 133 2 2059182112 47593552 20838832
20:44:29 2763 8192000000 10995199168 11424690176 2011664752 19.715 100 77 153 1 2084956416 48637776 24653888
20:44:42 7869 8192000000 10961089120 11401551872 1970948352 19.393 99 56 112 0 2036373616 47671504 17753760
20:45:18 5788 8192000000 10962020704 11397160960 1977651664 19.446 100 54 106 1 2039108752 44740512 16716576
20:45:31 7688 8192000000 10962871472 11393994752 1982517488 19.485 100 62 123 4 2046158912 43764176 19877248
20:45:45 5840 8192000000 10984003568 11407536128 1992566416 19.564 100 62 124 3 2057518384 45964960 18987008
20:46:01 2554 8192000000 10988661632 11415928832 1998175520 19.608 100 75 150 0 2071046944 49261504 23609920
20:46:12 1989 8192000000 10992819200 11418550272 1984455376 19.500 99 75 151 0 2060883360 52670624 23757360
20:46:21 13097 8192000000 10966185136 11410325504 1985997584 19.512 100 56 112 1 2057150256 52721632 18431040
20:46:48 13072 8192000000 10938081184 11383087104 1920251248 18.989 97 35 70 3 1982748864 50573920 11923696
20:47:12 14785 8192000000 10935135472 11383341056 1953369168 19.253 99 30 60 1 2015481152 51505440 10606544
20:47:34 9493 8192000000 10928842400 11372150784 1942701888 19.168 99 32 64 3 1997524512 44235200 10587424
20:47:50 8339 8192000000 10943610960 11385495552 1970021328 19.386 100 44 86 3 2028160912 44311360 13828224
20:48:08 10091 8192000000 10948379136 11393294336 1976221216 19.435 100 49 97 1 2037601408 45470592 15909600
20:48:24 18061 8192000000 10932570336 11383259136 1953104720 19.251 99 26 52 2 2009792432 47839568 8848144
20:48:51 10698 8192000000 10930605376 11374542848 1931078848 19.076 98 43 86 0 1993789952 48430560 14280544
20:49:13 7400 8192000000 10940748944 11386769408 1963783840 19.336 100 40 78 1 2023091824 46632480 12675504
20:49:32 16897 8192000000 10906099888 11354501120 1915648736 18.952 98 32 64 1 1972207584 45720176 10838672
20:50:04 11261 8192000000 10913599952 11363643392 1953409312 19.254 100 29 57 2 2002434656 39570592 9454752
20:50:33 25854 8192000000 10873285184 11320754176 1898337296 18.813 99 20 40 1 1940150160 34727024 7085840
20:51:16 18752 8192000000 10890054176 11341066240 1926382848 19.038 100 22 44 1 1972093680 37617280 8093552
20:51:46 33359 8192000000 10866756176 11310350336 1818369088 18.164 95 22 44 1 1871069072 44224128 8475856
20:52:26 17963 8192000000 10875710640 11319209984 1884931392 18.705 99 35 71 0 1947282544 50655904 11695248
20:52:56 28584 8192000000 10860733104 11308998656 1874795408 18.623 99 28 56 0 1943689360 58973184 9920768
20:53:37 84212 8192000000 10817125472 11250733056 1804409072 18.050 95 32 59 2 1829129696 15801648 8918976
20:55:08 36925 8192000000 10828415616 11268841472 1890215296 18.748 100 33 67 0 1909449392 8929680 10304416
20:55:52 41251 8192000000 10852620912 11293466624 1907786240 18.889 100 32 64 0 1926840704 10093584 8960880
20:57:00 73694 8192000000 10852073696 11305357312 1885932256 18.713 98 23 47 0 1910739008 18013968 6792784
20:58:21 113131 8192000000 10841379552 11309096960 1869676256 18.582 97 12 24 0 1890138720 17325424 3137040
21:00:50 61879 8192000000 10864370640 11330416640 1927020928 19.043 100 8 16 0 1948019616 18748832 2249856
21:01:59 57789 8192000000 10868135168 11322052608 1927962384 19.051 99 17 35 1 1946812064 14218896 4630784
21:03:59 116628 8192000000 10880134144 11332829184 1927379424 19.046 99 26 51 2 1945078432 10118928 7580080
21:06:03 20854 8192000000 10871810992 11330125824 1930895056 19.074 99 24 48 0 1951043600 13290336 6858208
21:06:43 86816 8192000000 10875773088 11347308544 1930863024 19.074 99 20 39 0 1949153472 12774560 5515888
21:08:16 82910 8192000000 10889303600 11360325632 1946320944 19.197 99 20 39 0 1963980784 12352592 5307248
21:09:45 73823 8192000000 10891305568 11363827712 1948364288 19.213 99 21 42 1 1966286272 11820016 6101968
21:11:17 68958 8192000000 10906386080 11364675584 1955891488 19.273 99 15 30 0 1972454432 11809504 4753440
21:12:48 63645 8192000000 10921364160 11391721472 1984985856 19.504 100 12 24 0 2004303328 15851344 3466128
21:14:40 98420 8192000000 10889905520 11353034752 1936701152 19.120 98 12 24 1 1956551200 16258528 3591520
21:16:25 34262 8192000000 10927577712 11368009728 1957039648 19.283 99 29 56 0 1973757888 8156720 8561520
21:17:06 31163 8192000000 10934816480 11388129280 1987756336 19.526 100 42 84 0 2011076672 11772752 11547584
21:18:55 82019 8192000000 10930988896 11396390912 1925028128 19.027 97 9 18 1 1946018128 18639728 2350272
21:20:25 74214 8192000000 10914123808 11384483840 1966521056 19.358 99 27 55 2 1992954656 18393904 8039696
21:21:51 109483 8192000000 10908729376 11378700288 1964883104 19.345 99 20 40 0 1981420640 10526160 6011376
21:23:47 56119 8192000000 10920892384 11381202944 1986685248 19.518 100 18 36 1 2000622912 8482128 5455536
21:24:50 44938 8192000000 10905732752 11377856512 1968783056 19.376 99 21 40 1 1982876368 8384144 5709168
21:25:49 52672 8192000000 10918837984 11391496192 1974568896 19.422 99 15 30 1 1986825072 8244720 4011456
21:26:48 50442 8192000000 10892176848 11368853504 1955225808 19.268 98 10 20 0 1969341056 11033536 3081712
21:27:45 12609 8192000000 10905791952 11382820864 1983835856 19.495 100 8 15 1 1997291872 11744416 1711600
21:28:08 12841 8192000000 10910491824 11393286144 1987900368 19.527 100 7 14 1 2006084704 16598720 1585616
21:28:33 83030 8192000000 10905198464 11380047872 1973526560 19.413 99 16 30 1 1994150816 16765296 3858960
21:30:03 21621 8192000000 10909373200 11400241152 1991237008 19.554 100 8 16 0 2007024336 13304256 2483072
21:30:30 48834 8192000000 10911500608 11398369280 1986800048 19.519 100 7 14 1 2000868368 12290592 1777728
21:31:26 51488 8192000000 10902446880 11387138048 1941486496 19.159 97 15 30 2 1959101344 13133888 4480960
21:32:30 65767 8192000000 10888138656 11362336768 1915944608 18.954 97 10 20 0 1930300208 11542240 2813360
21:33:46 45679 8192000000 10908919936 11381911552 1966294512 19.356 99 26 52 2 1986224320 13033648 6896160
21:34:45 36338 8192000000 10899162176 11373760512 1945463312 19.190 98 23 46 0 1959943552 8204864 6275376
21:35:52 50223 8192000000 10890234176 11335962624 1854652160 18.460 94 33 66 0 1877365184 13341680 9371344
21:36:50 67474 8192000000 10863283312 11327844352 1851487680 18.434 95 24 48 1 1868896720 10516928 6892112
21:38:04 47988 8192000000 10874891264 11327447040 1898895680 18.817 98 20 40 0 1915292288 10703520 5693088
21:38:59 51841 8192000000 10872900896 11339075584 1892573920 18.767 97 23 46 2 1917862960 19123552 6165488
21:39:57 64536 8192000000 10877419024 11340009472 1904750384 18.864 98 26 52 3 1927023008 14378032 7894592
21:41:11 58057 8192000000 10898074208 11363827712 1944801952 19.185 100 27 54 1 1973860800 21748384 7310464
21:44:17 62662 8192000000 10848196304 11304656896 1860247072 18.505 96 23 46 1 1880440896 13982480 6211344
21:45:26 119007 8192000000 10828182368 11296378880 1866490176 18.556 97 30 60 0 1882067200 7368944 8208080
21:47:34 66623 8192000000 10839597328 11300593664 1853637840 18.452 96 37 74 1 1872811296 8766784 10406672
21:48:57 19725 8192000000 10839294688 11302506496 1894373152 18.781 99 27 54 0 1912735856 10550384 7812320
21:49:27 33751 8192000000 10823054528 11295686656 1887951760 18.729 99 11 22 1 1900069824 9279584 2838480
21:50:08 42471 8192000000 10830631648 11301048320 1899048624 18.819 99 18 36 2 1914068864 9906640 5113600
21:50:58 54288 8192000000 10834839744 11304513536 1864074832 18.536 97 14 27 0 1878848272 10787600 3985840
21:51:59 26915 8192000000 10835775808 11308494848 1917769072 18.969 100 7 13 1 1932374528 12871472 1733984
21:52:32 20771 8192000000 10841530608 11315208192 1919086512 18.980 100 8 16 0 1937264128 15722976 2454640
21:52:59 64958 8192000000 10851377184 11324600320 1911525616 18.919 99 15 30 2 1925631680 10285072 3820992
21:54:11 82043 8192000000 10869900224 11333472256 1893084736 18.771 98 17 34 0 1913738432 15861888 4791808
21:55:40 18328 8192000000 10859282224 11326341120 1919486496 18.983 99 31 64 1 1941620528 13498048 8635984
21:57:11 85813 8192000000 10880556032 11345338368 1924346288 19.022 99 12 24 1 1943325360 15686496 3292576
21:58:44 47040 8192000000 10868721872 11340488704 1907451424 18.886 97 20 40 0 1922177072 9674576 5051072
21:59:38 77473 8192000000 10894047344 11351306240 1900166608 18.828 97 10 20 0 1909787248 7450896 2169744
22:01:03 43164 8192000000 10908031104 11354984448 1945090896 19.187 99 22 44 1 1960841952 9733120 6017936
22:01:56 16168 8192000000 10914637968 11351461888 1944499632 19.183 99 45 89 1 1967500800 10852704 12148464
22:02:22 20379 8192000000 10910292432 11364089856 1966040480 19.354 100 49 98 1 1994659376 14285136 14333760
22:02:53 62268 8192000000 10882096912 11340304384 1889549152 18.742 96 38 77 2 1915037824 14324096 11164576
22:04:08 105742 8192000000 10870418672 11353669632 1882531840 18.686 96 10 20 0 1900678144 15142096 3004208
22:06:08 86246 8192000000 10887576912 11364859904 1941001632 19.155 99 8 16 0 1956809120 13794384 2013104
22:07:41 41791 8192000000 10917044080 11367194624 1955661008 19.272 99 30 62 1 1972656368 8944880 8050480
22:08:31 30713 8192000000 10925710304 11378630656 1961458384 19.318 99 51 102 0 1988107840 11541520 15107936
22:09:58 130488 8192000000 10904876928 11379834880 1938410560 19.134 98 14 28 2 1951793312 9774320 3608432
22:12:55 62603 8192000000 10906506064 11390877696 1981824608 19.479 100 21 42 2 1999054816 11258960 5971248
22:14:04 39630 8192000000 10900815088 11382145024 1967488208 19.366 99 19 38 2 1984211552 11964208 4759136
22:15:07 57041 8192000000 10889754832 11377819648 1974443392 19.421 100 6 12 0 1985437472 9334576 1659504
22:17:08 55710 8192000000 10912385136 11379576832 1971856672 19.400 100 11 22 0 1983484256 8379376 3248208
22:18:20 48274 8192000000 10880055984 11367219200 1936719184 19.121 98 11 22 1 1949092144 9225968 3146992
22:19:21 85216 8192000000 10874462320 11351584768 1874576944 18.621 95 11 22 0 1887846432 9910848 3358640
22:20:57 58554 8192000000 10877807264 11352686592 1919628912 18.984 98 12 24 0 1934207600 10964176 3614512
22:22:16 70569 8192000000 10904362912 11364487168 1941408224 19.158 99 13 26 1 1960521584 15138688 3974672
22:23:33 76535 8192000000 10884250992 11363065856 1888641776 18.735 96 17 34 0 1908228448 14310496 5276176
22:24:57 43013 8192000000 10921270496 11382394880 1952383872 19.245 99 20 40 3 1969689808 11708624 5597312
22:25:59 74664 8192000000 10914472352 11390160896 1945719008 19.192 98 24 48 0 1976902112 24128608 7054496

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-02-2021 22:28:54 to 07-02-2021 22:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 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-02-2021 22:29:25 to 07-02-2021 22:29:27.

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          232532
MON$OLDEST_ACTIVE               234728
MON$OLDEST_SNAPSHOT             234728
MON$NEXT_TRANSACTION            234728
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                       2003968
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:80: 
:81: mscs-test-161.budzdorov.ru    Sun Feb  7 22:27:39 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'

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