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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17198160 kB
MemAvailable 31621952 kB
Buffers 0 kB
Cached 14524972 kB
SwapCached 1988 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 2020-12-07 19:27:02
DTS_END                         2020-12-07 19:27:02.1480
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52384
TRN_ID                          262659
ATT_ID                          690
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: 9759.13 17306 1171095
customer order: creation 193.01 312 23161
customer order: refuse 16.34 288 1961
order to supplier: creation 49.81 1203 5977
order to supplier: removal 3.60 77298 432
invoice (draft): creation 50.73 2993 6087
invoice (draft): removal 54.08 641 6490
invoice accept: apply 46.69 15996 5603
invoice accept: cancel 48.57 665 5828
customer reserve: creation 4197.32 162 503678
customer reserve: removal 4778.13 46 573375
realization accept: apply 93.29 153 11195
realization accept: cancel 83.88 89 10065
payment from customer: creation 66.08 96 7929
payment from customer: removal 6.23 86 748
payment to supplier: creation 53.51 119 6421
payment to supplier: removal 4.08 78 489
service: total inventory turnovers 5.23 1075 627
service: total monetary turnovers 7.57 54 908
service: aggregate perf. data 0.98 18012 117
service: refresh index statistics 0.03 226754 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-12-2020 19:28:53 to 07-12-2020 19:28:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9702
TEST_TIME 2 8786
TEST_TIME 3 7652
TEST_TIME 4 6880
TEST_TIME 5 7260
TEST_TIME 6 7481
TEST_TIME 7 7650
TEST_TIME 8 7298
TEST_TIME 9 7913
TEST_TIME 10 7841
TEST_TIME 11 7742
TEST_TIME 12 8024
TEST_TIME 13 8226
TEST_TIME 14 8618
TEST_TIME 15 9023
TEST_TIME 16 9093
TEST_TIME 17 9431
TEST_TIME 18 9783
TEST_TIME 19 9760
TEST_TIME 20 10432
TEST_TIME 21 11059
TEST_TIME 22 11477
TEST_TIME 23 11596
TEST_TIME 24 12238
TEST_TIME 25 11929
TEST_TIME 26 11831
TEST_TIME 27 11833
TEST_TIME 28 11552
TEST_TIME 29 11662
TEST_TIME 30 11740
TEST_TIME 31 11569
TEST_TIME 32 11656
TEST_TIME 33 11610
TEST_TIME 34 11503
TEST_TIME 35 11271
TEST_TIME 36 11049
TEST_TIME 37 11182
TEST_TIME 38 11077
TEST_TIME 39 10898
TEST_TIME 40 10870
TEST_TIME 41 10699
TEST_TIME 42 10904
TEST_TIME 43 11002
TEST_TIME 44 10852
TEST_TIME 45 10814
TEST_TIME 46 10816
TEST_TIME 47 10774
TEST_TIME 48 10701
TEST_TIME 49 10596
TEST_TIME 50 10499
TEST_TIME 51 10386
TEST_TIME 52 10375
TEST_TIME 53 10313
TEST_TIME 54 10334
TEST_TIME 55 10377
TEST_TIME 56 10403
TEST_TIME 57 10409
TEST_TIME 58 10467
TEST_TIME 59 10548
TEST_TIME 60 10516
TEST_TIME 61 10539
TEST_TIME 62 10564
TEST_TIME 63 10630
TEST_TIME 64 10562
TEST_TIME 65 10670
TEST_TIME 66 10610
TEST_TIME 67 10524
TEST_TIME 68 10438
TEST_TIME 69 10429
TEST_TIME 70 10421
TEST_TIME 71 10330
TEST_TIME 72 10278
TEST_TIME 73 10234
TEST_TIME 74 10198
TEST_TIME 75 10190
TEST_TIME 76 10139
TEST_TIME 77 10149
TEST_TIME 78 10132
TEST_TIME 79 10129
TEST_TIME 80 10207
TEST_TIME 81 10198
TEST_TIME 82 10175
TEST_TIME 83 10216
TEST_TIME 84 10248
TEST_TIME 85 10258
TEST_TIME 86 10278
TEST_TIME 87 10288
TEST_TIME 88 10296
TEST_TIME 89 10194
TEST_TIME 90 10222
TEST_TIME 91 10153
TEST_TIME 92 10124
TEST_TIME 93 10062
TEST_TIME 94 10039
TEST_TIME 95 10005
TEST_TIME 96 9995
TEST_TIME 97 9969
TEST_TIME 98 10005
TEST_TIME 99 10090
TEST_TIME 100 10048
TEST_TIME 101 10052
TEST_TIME 102 10010
TEST_TIME 103 10100
TEST_TIME 104 10030
TEST_TIME 105 10219
TEST_TIME 106 10195
TEST_TIME 107 10181
TEST_TIME 108 10151
TEST_TIME 109 10109
TEST_TIME 110 10052
TEST_TIME 111 10030
TEST_TIME 112 10051
TEST_TIME 113 10019
TEST_TIME 114 9984
TEST_TIME 115 9947
TEST_TIME 116 9921
TEST_TIME 117 9880
TEST_TIME 118 9846
TEST_TIME 119 9829
TEST_TIME 120 9763

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-12-2020 19:28:57 to 07-12-2020 19:29:00.

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 1639374 1639374 0 0.00 0 26396 6 0 0
doc_list_biud 1639373 1639373 0 0.00 0 43806 21 0 0
sp_add_invoice_to_stock 5743 5603 140 2.43 32 212485 15996 0 140
sp_cancel_adding_invoice 5828 5828 0 0.00 4 47901 665 0 0
sp_cancel_client_order 1961 1961 0 0.00 4 17735 289 0 0
sp_cancel_customer_reserve 573375 573375 0 0.00 1 43809 46 0 0
sp_cancel_pay_from_customer 748 748 0 0.00 2 5057 87 0 0
sp_cancel_pay_to_supplier 489 489 0 0.00 3 5420 79 0 0
sp_cancel_supplier_invoice 6505 6490 15 0.23 2 14816 641 0 15
sp_cancel_supplier_order 432 432 0 0.00 5 1066446 77298 0 0
sp_cancel_write_off 10065 10065 0 0.00 1 14977 89 0 0
sp_client_order 23161 23161 0 0.00 3 25651 312 0 0
sp_customer_reserve 503678 503678 0 0.00 0 156506 163 0 0
sp_fill_shopping_cart 35210 35210 0 0.00 1 8530 34 0 0
sp_fill_shopping_cart_clo_res 503665 503665 0 0.00 0 11652 13 0 0
sp_get_clo_for_invoice 5590 5590 0 0.00 0 20675 281 0 0
sp_kill_cost_storno 17130 17130 0 0.00 0 10422 42 0 0
sp_kill_qstorno_ret_qs2qd 1163737 1163737 0 0.00 0 40562 25 0 0
sp_kill_qty_storno 614936 614936 0 0.00 0 43806 55 0 0
sp_lock_selected_doc 23123 23123 0 0.00 0 7240 7 0 0
sp_make_cost_storno 31135 31135 0 0.00 0 26389 43 0 0
sp_multiply_rows_for_pdistr 31135 31135 0 0.00 0 6411 24 0 0
sp_multiply_rows_for_qdistr 23161 23161 0 0.00 0 25643 155 0 0
sp_pay_from_customer 7929 7929 0 0.00 4 14106 97 0 0
sp_pay_to_supplier 6421 6421 0 0.00 4 19188 119 0 0
sp_payment_common 14350 14350 0 0.00 1 19181 29 0 0
sp_qd_handle_on_cancel_clo 1961 1961 0 0.00 0 17727 255 0 0
sp_qd_handle_on_invoice_upd_sts 11418 11418 0 0.00 0 14543 268 0 0
sp_qd_handle_on_reserve_upd_sts 11195 11195 0 0.00 0 16533 54 0 0
sp_reserve_write_off 11195 11195 0 0.00 6 16586 153 0 0
sp_supplier_invoice 6087 6087 0 0.00 6 89555 2994 0 0
sp_supplier_order 5977 5977 0 0.00 5 28900 1203 0 0
srv_aggregate_perf_data 117 117 0 0.00 2693 356518 18012 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1236 181108 32850 0 0
srv_find_qd_qs_mism 1119366 1119366 0 0.00 0 15347 5 0 0
srv_make_invnt_saldo 627 627 0 0.00 39 70702 1076 0 0
srv_make_money_saldo 908 908 0 0.00 0 26389 54 0 0
srv_recalc_idx_stat 4 4 0 0.00 141058 378624 226754 0 0
t$perf-abend:sp_add_invoice_to_stock 140 140 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5603 5603 0 0.00 0 23310 161 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 7010 114 0 0
t$perf-norm:sp_cancel_client_order 1961 1961 0 0.00 0 4049 15 0 0
t$perf-norm:sp_cancel_customer_reserve 749 749 0 0.00 0 3861 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 748 748 0 0.00 0 2608 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 489 489 0 0.00 0 352 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 3365 23 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 14589 1357 0 0
t$perf-norm:sp_cancel_write_off 1108 1108 0 0.00 0 1322 4 0 0
t$perf-norm:sp_client_order 23161 23161 0 0.00 0 13699 16 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 1115 5 0 0
t$perf-norm:sp_pay_from_customer 7929 7929 0 0.00 0 13232 11 0 0
t$perf-norm:sp_pay_to_supplier 6421 6421 0 0.00 0 6421 10 0 0
t$perf-norm:sp_reserve_write_off 11195 11195 0 0.00 0 13221 14 0 0
t$perf-norm:sp_supplier_invoice 6087 6087 0 0.00 0 4364 14 0 0
t$perf-norm:sp_supplier_order 5977 5977 0 0.00 0 5735 17 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 2423 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 182 5 0 0
t$perf-norm:srv_make_invnt_saldo 627 627 0 0.00 0 5443 19 0 0
t$perf-norm:srv_make_money_saldo 908 908 0 0.00 0 3194 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 11460 11180 280 2.44 0 14996 23 0 280
v_all_customers 41528 41528 0 0.00 0 15 1 0 0
v_all_suppliers 33088 33088 0 0.00 0 19 1 0 0
v_all_wares 46322 46322 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 3455 9 0 0
v_cancel_client_order 3922 3922 0 0.00 0 3012 7 0 0
v_cancel_customer_prepayment 1496 1496 0 0.00 0 3538 7 0 0
v_cancel_customer_reserve 1498 1498 0 0.00 0 1159 4 0 0
v_cancel_payment_to_supplier 978 978 0 0.00 0 3383 7 0 0
v_cancel_supplier_invoice 886 856 30 3.38 0 5919 23 0 30
v_cancel_supplier_order 864 864 0 0.00 0 364 3 0 0
v_cancel_write_off 2216 2216 0 0.00 0 2712 14 0 0
v_max_id_clo_ord 5974 5974 0 0.00 0 267 1 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 2541 17 0 0
v_max_id_ord_sup 6075 6075 0 0.00 0 3890 3 0 0
v_max_non_paid_invoice 1926 1926 0 0.00 0 755 3 0 0
v_max_non_paid_realizn 4475 4475 0 0.00 0 3375 4 0 0
v_min_id_clo_ord 5974 5974 0 0.00 0 5439 8 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 3773 14 0 0
v_min_id_ord_sup 6075 6075 0 0.00 0 5305 4 0 0
v_min_non_paid_invoice 6421 6421 0 0.00 0 19178 20 0 0
v_min_non_paid_realizn 7929 7929 0 0.00 0 13816 13 0 0
v_our_firm 11702 11702 0 0.00 0 22 1 0 0
v_reserve_write_off 22390 22390 0 0.00 0 15354 5 0 0
x_lock_depdocs_on_canc_invoice 11890 11890 0 0.00 0 10822 89 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 13082 269 0 0
x_make_qstorno_1000_1200 5977 5977 0 0.00 1 28887 1130 0 0
x_make_qstorno_1200_2000 6087 6087 0 0.00 2 89538 2871 0 0
x_make_qstorno_2100_3300 503678 503678 0 0.00 0 156504 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-12-2020 19:29:01 to 07-12-2020 19:29:05.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 20038 8192000000 10242279872 10553327616 906872416 9.966 70 54 110 0 928380960 2826832 18681712
16:57:40 46027 8192000000 10355602432 10674806784 1386031760 14.470 100 83 166 0 1418792912 5168016 27593136
16:58:34 23988 8192000000 10379011008 10703147008 1436885488 14.922 100 91 182 0 1474463456 6883600 30694368
16:59:07 15552 8192000000 10395248048 10721329152 1449177792 15.031 100 87 174 0 1485478144 7665328 28635024
16:59:32 21093 8192000000 10413488096 10744123392 1467760352 15.194 100 85 170 0 1502851760 7926224 27165184
17:00:05 16730 8192000000 10427879280 10762588160 1488432832 15.375 100 86 172 0 1524364560 8527200 27404528
17:00:43 18752 8192000000 10480340800 10821795840 1533174576 15.765 100 83 166 0 1568324848 9280400 25869872
17:01:20 13113 8192000000 10514517088 10865074176 1569475328 16.078 100 78 156 1 1603219984 10078160 23666496
17:01:43 15709 8192000000 10546087280 10899910656 1596416576 16.309 100 79 158 0 1630474112 10180448 23877088
17:02:09 10207 8192000000 10559884608 10919075840 1617687776 16.490 100 76 152 0 1652012384 11801472 22523136
17:02:26 9626 8192000000 10572193360 10935296000 1634017376 16.629 100 80 160 0 1669547616 11896752 23633488
17:02:46 8962 8192000000 10590233360 10956218368 1655854096 16.814 100 83 165 1 1692821312 12996640 23970576
17:03:02 7604 8192000000 10595583760 10964992000 1667253824 16.910 100 79 158 1 1702535984 11968480 23313680
17:03:17 11594 8192000000 10622508432 10994049024 1681695232 17.032 100 75 149 4 1715534816 12230176 21609408
17:03:36 6010 8192000000 10641450544 11011391488 1700192432 17.187 100 79 156 0 1735123440 12517968 22413040
17:03:50 6095 8192000000 10659251232 11030511616 1715683584 17.316 100 81 163 0 1752010048 12782624 23543840
17:04:03 8458 8192000000 10676553472 11051872256 1728500832 17.423 100 82 164 2 1765405952 13348368 23556752
17:04:18 5619 8192000000 10691491824 11068059648 1751252288 17.612 100 84 165 2 1787965232 13286464 23426480
17:04:31 4480 8192000000 10690206224 11070672896 1758222624 17.670 100 81 161 2 1794438048 12744288 23471136
17:04:42 3808 8192000000 10702953696 11080675328 1767022080 17.742 100 82 164 2 1803250800 12689856 23538864
17:04:52 3347 8192000000 10723038112 11098787840 1776918048 17.824 100 91 182 0 1816775824 14392048 25465728
17:05:02 3321 8192000000 10729574928 11109003264 1784254176 17.885 100 84 169 0 1822292576 14451792 23586608
17:05:12 3019 8192000000 10736089744 11114598400 1791075376 17.941 100 90 178 2 1829880240 13893840 24911024
17:05:22 1713 8192000000 10740164608 11118718976 1798591712 18.002 100 89 178 1 1838812320 15078096 25142512
17:05:31 5964 8192000000 10743505184 11124666368 1801846192 18.029 100 87 171 1 1840573072 14247520 24479360
17:05:44 5138 8192000000 10756997120 11142217728 1807876000 18.078 100 83 164 0 1844204576 13383696 22944880
17:05:55 2628 8192000000 10767315472 11151699968 1827231200 18.237 100 92 184 2 1867134608 14005984 25897424
17:06:05 2068 8192000000 10783911040 11166023680 1836123680 18.309 100 93 186 1 1876459200 13820064 26515456
17:06:13 1381 8192000000 10776423856 11165040640 1840821968 18.347 100 81 162 1 1877079936 13562624 22695344
17:06:21 1962 8192000000 10785072480 11172790272 1850562048 18.427 100 94 189 2 1889982752 13003568 26417136
17:06:29 1715 8192000000 10791886352 11179347968 1854920800 18.462 100 93 186 0 1894145536 12943536 26281200
17:06:37 1274 8192000000 10798158512 11186712576 1860141376 18.504 100 89 178 1 1897347248 12230224 24975648
17:06:45 1131 8192000000 10805777936 11191451648 1862611392 18.524 100 96 195 0 1903436096 13844032 26980672
17:06:52 1445 8192000000 10815498256 11200753664 1864359872 18.539 100 93 187 2 1904208720 13554976 26293872
17:07:00 1230 8192000000 10812765088 11201974272 1866626960 18.557 100 91 182 0 1905512976 12890256 25995760
17:07:07 2351 8192000000 10793795728 11199356928 1864861472 18.543 100 68 136 2 1895987392 11472624 19653296
17:07:16 4309 8192000000 10791696592 11203665920 1861281984 18.514 100 46 90 1 1883625552 9787520 12556048
17:07:26 3755 8192000000 10786673760 11194331136 1865253136 18.546 100 42 82 3 1884469280 7391136 11825008
17:07:37 50291 8192000000 10808012992 11208425472 1867445904 18.564 100 40 77 2 1884851040 6144496 11260640
17:08:34 13230 8192000000 10804334848 11220451328 1879156336 18.658 100 54 107 1 1904704432 11148944 14399152
17:08:57 7901 8192000000 10789362096 11214123008 1875432656 18.628 100 28 56 2 1890075152 6665312 7977184
17:09:11 7055 8192000000 10801316336 11218436096 1878168720 18.650 100 30 60 0 1893222368 6510848 8542800
17:09:26 2836 8192000000 10790389296 11219288064 1877111232 18.642 100 25 48 2 1891184112 7178576 6894304
17:09:35 3895 8192000000 10794405056 11223101440 1882137872 18.682 100 32 66 1 1898141008 7059696 8943440
17:09:46 4593 8192000000 10803861040 11225632768 1882236304 18.683 100 32 64 2 1898694816 7527552 8930960
17:10:00 6125 8192000000 10810009824 11229458432 1883532944 18.694 100 30 58 0 1897811600 6416752 7861904
17:10:13 8971 8192000000 10802102784 11229007872 1883303088 18.692 100 20 41 0 1894457552 5778592 5375872
17:10:32 10322 8192000000 10807563584 11234553856 1888483616 18.734 100 25 47 5 1901002656 5926928 6592112
17:10:49 10408 8192000000 10812151024 11240706048 1895180576 18.788 100 22 44 6 1911396400 10470016 5745808
17:11:06 10054 8192000000 10805236384 11240783872 1893538768 18.774 100 26 48 3 1906432048 6104704 6788576
17:11:24 6701 8192000000 10807345184 11248910336 1898223040 18.812 100 24 48 0 1914911392 10795248 5893104
17:11:37 7318 8192000000 10812737168 11248603136 1898556624 18.815 100 22 44 2 1914688256 10341600 5790032
17:11:51 10000 8192000000 10802564656 11241750528 1896962352 18.802 100 12 23 3 1905875408 5231984 3681072
17:12:11 54457 8192000000 10833105376 11254628352 1903095344 18.851 100 39 78 0 1920459520 5151632 12212544
17:13:11 13447 8192000000 10820186688 11250900992 1906077184 18.875 100 33 66 1 1920721488 5586672 9057632
17:13:31 8849 8192000000 10829053488 11260264448 1910090352 18.907 100 36 72 3 1927091728 7531136 9470240
17:13:48 6357 8192000000 10835969536 11265888256 1914313872 18.941 100 42 85 1 1938394736 11888384 12192480
17:14:01 5666 8192000000 10822725744 11257057280 1911294576 18.917 100 38 76 0 1934264464 12580752 10389136
17:14:13 3739 8192000000 10838239808 11268136960 1913841856 18.937 100 44 89 0 1938712784 12613344 12257584
17:14:23 4850 8192000000 10840219536 11266732032 1912645632 18.928 100 37 72 1 1930479232 7472944 10360656
17:14:34 4202 8192000000 10840951184 11270995968 1913129888 18.932 100 24 48 0 1926650016 5994288 7525840
17:14:45 7025 8192000000 10812789984 11255730176 1909731584 18.904 100 27 54 1 1924344528 6880000 7732944
17:15:00 5430 8192000000 10798965616 11235074048 1880586720 18.670 99 26 52 4 1893692512 5413440 7692352
17:15:16 6013 8192000000 10800407088 11238735872 1876325968 18.635 99 26 52 2 1894033120 10582848 7124304
17:15:28 9381 8192000000 10790958960 11221553152 1836584384 18.313 97 24 48 0 1849087632 5695120 6808128
17:15:45 6409 8192000000 10797795616 11228282880 1868118240 18.569 99 25 49 1 1880724432 5751824 6854368
17:15:58 9438 8192000000 10775478624 11203194880 1804073792 18.047 96 26 52 2 1818234352 7020128 7140432
17:16:17 9513 8192000000 10754051024 11180814336 1799971760 18.014 97 22 44 3 1811922112 5780864 6169488
17:16:35 10725 8192000000 10760140560 11181703168 1834437248 18.296 99 9 18 0 1843134656 5945248 2752160
17:16:52 57675 8192000000 10740514736 11170217984 1765979728 17.734 95 19 38 1 1776228688 4684624 5564336
17:18:03 11721 8192000000 10726781696 11144732672 1770985744 17.775 97 26 52 2 1783889200 6029328 6874128
17:18:22 5543 8192000000 10714037792 11134296064 1779429024 17.845 99 16 31 1 1793176944 9700544 4047376
17:18:35 6503 8192000000 10658693088 11063255040 1696454272 17.155 95 20 40 3 1707561280 5455008 5652000
17:18:48 5598 8192000000 10684490624 11098656768 1726541840 17.407 97 28 56 5 1741072992 6014256 8516896
17:19:00 5608 8192000000 10698000944 11109261312 1739119264 17.511 97 23 46 1 1750988800 4640688 7228848
17:19:13 5877 8192000000 10696059616 11103465472 1744758432 17.558 97 29 57 3 1758142496 4752352 8631712
17:19:30 9582 8192000000 10705841632 11128373248 1784543952 17.887 99 21 42 2 1796247056 5471504 6231600
17:19:48 11685 8192000000 10711983104 11128070144 1771146400 17.776 98 31 61 2 1786198576 5333504 9718672
17:20:07 11685 8192000000 10703544992 11123740672 1755222880 17.645 97 24 48 0 1768555760 6035792 7297088
17:20:26 13191 8192000000 10733910480 11156082688 1820958064 18.186 100 27 54 1 1834308880 5996400 7354416
17:20:47 12042 8192000000 10717751488 11135258624 1778709584 17.839 97 21 42 1 1794550768 10072992 5768192
17:21:05 7818 8192000000 10733148864 11153743872 1819848192 18.176 100 24 47 1 1837349680 11014256 6487232
17:21:19 17584 8192000000 10737543744 11166486528 1827621408 18.240 100 30 59 2 1841854704 5055120 9178176
17:21:43 66487 8192000000 10732769984 11160772608 1813264768 18.123 99 28 56 1 1827115072 5193856 8656448
17:22:58 8714 8192000000 10753182912 11174481920 1835483760 18.304 100 32 62 1 1850870704 6428880 8958064
17:23:14 7481 8192000000 10748497472 11173974016 1838262384 18.327 100 22 44 4 1850630656 6431392 5936880
17:23:31 8463 8192000000 10764271936 11184824320 1847329984 18.400 100 28 56 3 1862210256 6804976 8075296
17:23:46 4851 8192000000 10768078544 11190104064 1853973056 18.454 100 46 90 2 1874214288 6562720 13678512
17:24:02 9836 8192000000 10769137488 11190517760 1849020368 18.414 100 29 58 0 1863429376 6108688 8300320
17:24:23 9053 8192000000 10760241328 11189710848 1850219792 18.424 100 21 42 2 1862355440 6166992 5968656
17:24:38 9113 8192000000 10768172400 11194556416 1852895776 18.446 100 13 26 1 1862214288 5806128 3512384
17:24:55 7172 8192000000 10793141184 11202445312 1858601984 18.492 100 28 54 1 1872055152 5486336 7966832
17:25:08 10055 8192000000 10776842832 11200217088 1858494544 18.491 100 10 20 1 1867448624 5167104 3786976
17:25:24 10038 8192000000 10772959872 11201593344 1862310832 18.522 100 17 34 3 1873238256 5838192 5089232
17:25:41 17189 8192000000 10788632512 11214213120 1870902944 18.592 100 23 46 1 1882968272 5709280 6356048
17:26:09 13523 8192000000 10793268736 11217977344 1873607840 18.613 100 31 61 1 1888175344 5094816 9472688
17:26:29 70491 8192000000 10818284208 11241426944 1882279712 18.684 100 40 81 1 1898208016 4820816 11107488
17:27:47 2346 8192000000 10829821584 11251335168 1906838128 18.881 100 51 98 3 1926348320 4686432 14823760
17:27:58 14065 8192000000 10844914720 11266891776 1917540944 18.967 100 51 101 2 1939800800 7509984 14749872
17:28:18 17137 8192000000 10858668624 11283341312 1928201968 19.052 100 56 113 4 1953068256 9428928 15437360
17:28:42 17614 8192000000 10855175264 11278860288 1917383984 18.966 99 48 96 1 1939806048 9049536 13372528
17:29:11 6689 8192000000 10861398912 11281264640 1931272912 19.077 100 52 103 1 1954370192 8594464 14502816
17:29:24 8837 8192000000 10870902176 11296292864 1940364944 19.150 100 47 91 5 1963833904 9873264 13595696
17:29:45 19351 8192000000 10879195504 11307184128 1948470048 19.214 100 48 96 0 1971796144 9693408 13632688
17:30:25 17324 8192000000 10891180704 11318280192 1956129760 19.275 100 43 86 1 1977833040 9762272 11941008
17:30:49 45289 8192000000 10895023472 11329818624 1961891744 19.321 100 47 92 1 1986767328 11142592 13732992
17:31:41 6216 8192000000 10902372384 11335929856 1956879040 19.281 99 46 90 4 1983309152 13057984 13372128
17:32:00 12059 8192000000 10912550336 11345776640 1977553520 19.445 100 50 99 1 2007024912 14227696 15243696
17:32:21 7887 8192000000 10913821472 11349176320 1977743248 19.447 100 46 92 2 2006707088 15051216 13912624
17:32:39 16087 8192000000 10908451168 11350482944 1980368624 19.468 100 49 99 1 2010747088 14894720 15483744
17:33:07 11406 8192000000 10911611632 11351719936 1979319568 19.459 100 34 68 3 2002313904 13103312 9891024
17:33:27 11086 8192000000 10928964928 11361587200 1984439024 19.500 100 43 84 1 2011327776 15007696 11881056
17:33:45 5647 8192000000 10907144384 11334852608 1913650928 18.936 96 53 104 2 1949531888 20439088 15441872
17:33:58 9777 8192000000 10913798640 11343794176 1956147456 19.275 99 57 113 0 1992044608 18593456 17303696
17:34:18 4381 8192000000 10911209216 11331473408 1954035088 19.259 99 52 102 1 1987584992 19018336 14531568
17:34:30 7932 8192000000 10938002048 11357089792 1981936208 19.480 100 70 139 2 2021717968 19882000 19899760
17:34:46 4292 8192000000 10929073792 11357061120 1952729536 19.248 98 69 137 0 1996037776 22831408 20476832
17:34:57 3671 8192000000 10930587232 11350564864 1966577776 19.358 99 67 135 2 2005097600 19042608 19477216
17:35:09 15230 8192000000 10922294144 11352428544 1976196480 19.435 100 53 103 2 2012428176 20446704 15784992
17:35:38 9161 8192000000 10922726272 11342848000 1971998848 19.401 100 68 137 2 2013293696 21266640 20028208
17:35:54 8027 8192000000 10916815984 11339501568 1940023136 19.147 98 65 130 0 1983631920 24738704 18870080
17:36:11 2562 8192000000 10939387856 11357626368 1978150640 19.450 100 71 143 3 2024812736 26279888 20382208
17:36:21 3081 8192000000 10936593472 11353210880 1971033296 19.394 100 86 174 4 2021048848 24915120 25100432
17:36:33 2163 8192000000 10952607600 11362926592 1981558656 19.477 100 81 162 0 2030998416 25658592 23781168
17:36:42 1920 8192000000 10911656592 11325804544 1950650528 19.232 100 79 157 1 2000449184 26351264 23447392
17:36:50 1895 8192000000 10926768768 11340427264 1959977408 19.306 100 80 161 0 2007744736 24703792 23063536
17:36:59 7627 8192000000 10916233136 11335102464 1958737760 19.296 100 61 123 3 2000142912 24255040 17150112
17:37:16 11485 8192000000 10905580992 11321847808 1905980560 18.874 97 65 130 2 1954671824 29732176 18959088
17:37:40 2532 8192000000 10879817120 11300610048 1908123104 18.892 98 52 103 2 1949330992 25266048 15941840
17:37:50 9795 8192000000 10886408416 11312279552 1920217616 18.989 99 54 108 1 1961844832 25270016 16357200
17:38:07 7274 8192000000 10851831584 11277557760 1893753520 18.776 99 48 96 2 1932734816 24433488 14547808
17:38:26 4739 8192000000 10853427280 11270107136 1898796416 18.817 100 51 101 0 1940038304 26523680 14718208
17:38:39 9640 8192000000 10877406256 11291459584 1915307616 18.949 100 61 121 1 1961562640 27662112 18592912
17:39:01 4728 8192000000 10868122592 11275223040 1904258256 18.861 99 59 115 3 1947674720 26561008 16855456
17:39:13 3738 8192000000 10885339584 11291717632 1916274560 18.957 100 76 152 1 1967796560 27065616 24456384
17:39:24 5700 8192000000 10889030352 11295178752 1920772688 18.993 100 68 134 0 1970408224 28895888 20739648
17:39:37 1664 8192000000 10872306192 11274178560 1898423200 18.814 99 81 161 3 1951949680 28666928 24859552
17:39:45 5467 8192000000 10883909168 11282526208 1911891280 18.922 100 71 142 0 1965579712 30941200 22747232
17:40:00 10280 8192000000 10876976128 11295158272 1920435904 18.990 100 58 114 1 1966200640 28054768 17709968
17:40:26 7210 8192000000 10882801360 11307155456 1922644656 19.008 100 46 92 2 1972643648 33900624 16098368
17:40:40 2624 8192000000 10912240400 11329294336 1944405856 19.182 100 79 157 2 2004550208 34161184 25983168
17:40:49 3173 8192000000 10923849616 11335868416 1950708368 19.232 100 69 138 0 2005314512 32795904 21810240
17:41:00 2485 8192000000 10900848192 11310292992 1918804784 18.977 99 71 141 0 1972773536 31466064 22502688
17:41:09 2114 8192000000 10922435232 11323912192 1937830944 19.129 100 95 191 1 2002056368 34737280 29488144
17:41:18 5040 8192000000 10899144320 11310329856 1925942704 19.034 100 77 154 0 1984412736 35164864 23305168
17:41:32 4239 8192000000 10893134208 11299749888 1910850240 18.913 99 71 141 1 1964716112 32428176 21437696
17:41:44 2406 8192000000 10915871904 11315929088 1936044176 19.115 100 91 183 2 2002005168 37565776 28395216
17:41:52 3240 8192000000 10910566720 11322265600 1936222016 19.117 100 75 150 0 1998000096 38811312 22966768
17:42:04 3862 8192000000 10911245008 11326926848 1941531472 19.159 100 65 129 1 1998734864 37136464 20066928
17:42:17 3039 8192000000 10917116784 11332599808 1945463232 19.190 100 66 132 0 2000581520 35483760 19634528
17:42:27 10767 8192000000 10909551552 11327684608 1928196944 19.052 99 42 84 0 1977169600 35557744 13414912
17:42:48 3986 8192000000 10929537568 11339268096 1949063584 19.219 100 71 142 0 2006968944 36359136 21546224
17:43:03 3672 8192000000 10923910960 11333062656 1933338640 19.094 99 75 149 2 1992534992 36702480 22493872
17:43:13 1474 8192000000 10939915232 11339141120 1948762272 19.217 100 95 190 2 2015885296 38639120 28483904
17:43:24 3256 8192000000 10913503952 11339821056 1948273280 19.213 100 54 108 0 2002138784 37325200 16540304
17:43:41 9223 8192000000 10911296384 11336716288 1931623568 19.080 99 51 101 0 1984777584 36839632 16314384
17:43:58 1632 8192000000 10940464400 11350798336 1958331488 19.293 100 73 145 2 2020904080 39250256 23322336
17:44:07 3263 8192000000 10955394224 11359199232 1963500736 19.334 100 80 159 0 2030813440 41944416 25368288
17:44:20 1235 8192000000 10963353072 11366215680 1969616480 19.382 100 84 170 2 2038467376 43347680 25503216
17:44:28 1665 8192000000 10967801440 11376750592 1975036704 19.425 100 87 172 1 2050007344 47724864 27245776
17:44:37 2245 8192000000 10959652656 11371843584 1967000464 19.362 100 84 168 3 2039707824 46732720 25974640
17:44:47 2087 8192000000 10967211120 11379589120 1974135056 19.418 100 71 141 0 2043350656 46315328 22900272
17:44:57 7978 8192000000 10938616064 11375955968 1970611216 19.390 100 48 96 1 2030330896 44030192 15689488
17:45:18 5135 8192000000 10952158560 11371864064 1971880256 19.400 100 69 141 1 2034015584 39684816 22450512
17:45:30 15954 8192000000 10939648288 11383517184 1976703216 19.439 100 37 74 2 2030658992 41936304 12019472
17:46:06 23847 8192000000 10946359760 11383922688 1956529840 19.278 99 43 86 1 2014922176 43478752 14913584
17:46:44 17373 8192000000 10949209168 11382915072 1967901264 19.369 100 46 91 1 2033564464 49221712 16441488
17:47:09 18783 8192000000 10939078560 11377147904 1945454544 19.190 99 39 78 2 2008946976 49579312 13913120
17:47:36 20785 8192000000 10926806400 11387404288 1955727728 19.272 100 26 52 0 2017968032 52767696 9472608
17:48:09 18405 8192000000 10932329440 11376414720 1958057920 19.291 100 26 52 2 2017269424 49971232 9240272
17:48:35 33977 8192000000 10916692496 11367837696 1932575792 19.087 99 25 50 0 1982437840 40790048 9072000
17:49:17 27336 8192000000 10911680512 11368579072 1930041024 19.067 99 29 59 0 1982497520 42496176 9960320
17:50:13 31403 8192000000 10875570512 11335335936 1903421616 18.854 98 21 40 2 1940631632 31189104 6020912
17:50:52 35866 8192000000 10867693648 11348508672 1901388304 18.837 99 9 18 2 1939617840 34856320 3373216
17:51:34 66351 8192000000 10870441920 11313438720 1911881648 18.922 99 18 35 3 1928642976 11829056 4932272
17:52:47 22529 8192000000 10890374960 11331031040 1938457760 19.134 100 41 76 3 1957268288 7624112 11186416
17:53:22 119234 8192000000 10882023184 11339993088 1927778288 19.049 99 22 44 0 1944495360 10436016 6281056
17:55:36 53230 8192000000 10876764656 11341619200 1933232960 19.093 99 23 46 1 1952047840 12551952 6262928
17:56:39 106132 8192000000 10895638656 11367337984 1938577840 19.135 99 12 24 1 1955628400 13960064 3090496
17:58:31 39122 8192000000 10900949680 11363872768 1938726848 19.137 98 12 24 2 1953033712 10961728 3345136
17:59:16 137799 8192000000 10931407760 11381567488 1978706304 19.454 100 10 20 0 1996953872 15494144 2753424
18:01:40 41915 8192000000 10941255936 11377676288 1977233248 19.443 99 38 73 2 1993429264 6599600 9596416
18:02:29 102689 8192000000 10930434816 11387224064 1977737680 19.447 99 41 82 3 2003651536 14075568 11838288
18:04:25 41171 8192000000 10935089344 11384758272 1978691024 19.454 99 27 54 0 1993769552 7632128 7446400
18:05:16 46868 8192000000 10918093120 11389538304 1974046656 19.418 99 32 64 1 1994035872 10543680 9445536
18:06:11 40620 8192000000 10926365216 11399757824 1993534480 19.572 100 8 16 0 2009631328 13615296 2481552
18:06:58 16349 8192000000 10938231376 11412135936 2002292304 19.641 100 16 32 1 2020091840 12981856 4817680
18:07:21 11027 8192000000 10934059488 11415216128 2006673632 19.675 100 10 20 1 2022609680 13146064 2789984
18:08:02 12521 8192000000 10959027072 11418693632 2016503792 19.753 100 43 85 1 2044518096 14977248 13037056
18:08:33 32414 8192000000 10984884016 11436310528 2014310496 19.735 100 54 107 2 2051696656 22244128 15142032
18:09:32 67591 8192000000 10924487584 11419168768 1976894272 19.440 98 28 56 1 2009087696 24071024 8122400
18:10:46 181106 8192000000 10883327184 11360698368 1839671360 18.338 92 7 14 1 1855741024 13577792 2491872
18:13:53 81944 8192000000 10865357504 11338194944 1877849712 18.648 95 8 17 0 1891445904 11451504 2144688
18:15:24 58776 8192000000 10881256928 11351101440 1928834032 19.058 99 9 18 0 1940062976 8603584 2625360
18:16:30 56215 8192000000 10840666880 11322036224 1850522480 18.426 94 16 32 0 1862151856 7104064 4525312
18:17:36 49205 8192000000 10854851136 11342585856 1941296784 19.157 100 9 18 0 1952076944 7997440 2782720
18:18:34 58727 8192000000 10832872000 11315761152 1846259024 18.392 95 9 18 0 1855965072 7456848 2249200
18:20:18 25594 8192000000 10853017328 11322761216 1911086192 18.915 99 24 48 3 1926255680 8664720 6504768
18:20:56 50808 8192000000 10869459552 11344281600 1928696256 19.056 99 29 58 2 1948261440 11438896 8126288
18:22:00 34459 8192000000 10863342192 11327922176 1873099072 18.609 96 37 74 3 1899000336 15178320 10722944
18:22:59 31614 8192000000 10811322576 11274977280 1804209200 18.048 94 18 35 1 1821804816 12232848 5362768
18:23:37 63358 8192000000 10829930336 11294515200 1831507664 18.272 96 15 30 0 1849185808 13432720 4245424
18:24:50 34291 8192000000 10824790016 11284049920 1829017776 18.251 96 24 48 0 1846699232 11188688 6492768
18:25:35 54182 8192000000 10817035248 11287326720 1805059696 18.055 95 27 54 2 1824358560 11588624 7710240
18:27:09 33354 8192000000 10846564160 11281641472 1849267872 18.416 96 29 59 2 1865977504 8941312 7768320
18:27:49 18620 8192000000 10846148320 11298283520 1899672816 18.824 99 37 74 2 1919530416 9572368 10285232
18:28:14 82405 8192000000 10830128752 11290566656 1819451328 18.173 95 16 32 0 1834341200 10684352 4205520
18:29:47 86913 8192000000 10854116544 11320651776 1884498896 18.701 98 11 22 0 1898877936 11409152 2969888
18:31:20 14039 8192000000 10903426640 11346542592 1944868192 19.186 100 42 84 1 1966771136 8898144 13004800
18:31:43 39299 8192000000 10888367968 11343298560 1910299840 18.909 98 35 70 2 1934018448 13965920 9752688
18:32:31 54732 8192000000 10901525584 11363811328 1907387888 18.886 98 23 45 3 1931987376 17678512 6920976
18:33:32 89035 8192000000 10884743408 11350110208 1955432208 19.270 100 26 52 0 1973279744 10547312 7300224
18:35:21 47641 8192000000 10894185632 11355668480 1957438400 19.286 100 29 58 0 1974840608 9760384 7641824
18:36:19 33911 8192000000 10884106944 11349127168 1937674384 19.128 99 25 50 1 1953837360 9403552 6759424
18:36:59 20947 8192000000 10897331472 11349323776 1955744816 19.272 100 39 78 3 1975249344 8578384 10926144
18:37:30 53410 8192000000 10882038336 11365896192 1959164288 19.299 100 15 30 2 1974760880 10527680 5068912
18:38:30 74502 8192000000 10895762368 11382140928 1968911712 19.377 100 9 18 0 1989773200 18722496 2138992
18:39:50 24948 8192000000 10898049696 11364704256 1951714512 19.240 99 7 14 1 1969620864 15997328 1909024
18:40:25 54091 8192000000 10884195792 11364298752 1966077904 19.354 100 15 30 0 1982489744 11517056 4894784
18:41:35 58467 8192000000 10884124544 11378970624 1966198352 19.355 100 7 14 0 1978937552 10985808 1753392
18:42:40 87335 8192000000 10898803744 11369918464 1932500656 19.087 98 12 24 0 1949247216 13169952 3576608
18:44:34 22589 8192000000 10907104576 11375099904 1975730528 19.431 100 34 65 3 1996125440 10468560 9926352
18:45:07 47521 8192000000 10884492864 11361497088 1915259472 18.949 97 15 30 0 1933052832 13938752 3854608
18:46:09 101733 8192000000 10884464928 11369562112 1949524688 19.223 99 19 38 0 1967884032 12730192 5629152
18:47:57 64323 8192000000 10917083632 11381272576 1938897664 19.138 98 22 45 0 1958713632 13499280 6316688
18:49:08 56707 8192000000 10907301600 11383803904 1962032656 19.322 99 29 58 0 1980021152 9549424 8439072
18:50:13 84143 8192000000 10900436320 11391893504 1962364208 19.325 99 15 30 2 1981030816 14244528 4422080
18:51:44 44404 8192000000 10907129600 11379920896 1946155040 19.196 98 23 46 1 1962648256 10143360 6349856
18:52:41 49055 8192000000 10899509168 11358990336 1899938048 18.826 96 13 26 2 1912570000 8894784 3737168
18:54:45 84101 8192000000 10900165488 11378442240 1926677456 19.040 98 11 23 0 1949052784 19297168 3078160
18:56:55 90227 8192000000 10913169856 11396640768 1980892176 19.472 100 19 38 0 1998160592 12459184 4809232
18:58:32 28391 8192000000 10904850608 11389489152 1968196800 19.371 99 14 28 0 1985526544 13686448 3643296
18:59:18 38126 8192000000 10866958400 11349852160 1926174528 19.036 97 14 28 0 1940550416 10519776 3856112
19:00:35 61573 8192000000 10873099088 11362947072 1945595168 19.191 99 9 18 0 1954852960 6880896 2376896
19:01:47 42977 8192000000 10868947728 11345584128 1833048240 18.284 93 7 14 0 1840229024 5519216 1661568
19:02:39 45501 8192000000 10875955328 11347148800 1865857456 18.551 95 14 28 2 1875917424 6363120 3696848
19:03:31 64874 8192000000 10895440208 11375759360 1933335232 19.094 98 19 37 0 1951665920 12475136 5855552
19:04:56 56263 8192000000 10871760672 11342442496 1871270240 18.595 95 27 54 3 1896767648 17276544 8220864
19:06:12 56389 8192000000 10877019136 11342458880 1887161248 18.723 97 16 32 0 1910062816 18379232 4522336
19:07:15 44865 8192000000 10843082432 11297095680 1820938640 18.185 94 19 38 1 1842274752 16101952 5234160
19:08:12 40431 8192000000 10879335472 11324874752 1879752464 18.663 97 31 62 2 1900002736 11845968 8404304
19:09:01 28183 8192000000 10878831504 11331559424 1896800144 18.801 98 42 85 1 1924551488 16094752 11656592
19:09:36 35201 8192000000 10878369104 11327954944 1907901568 18.890 99 43 86 2 1939477840 19316864 12259408
19:10:19 19511 8192000000 10868375312 11338305536 1900349040 18.829 99 34 68 0 1940632912 30272720 10011152
19:13:21 67717 8192000000 10836869488 11284316160 1843127712 18.366 96 23 45 1 1860931728 11687664 6116352
19:14:35 23780 8192000000 10850760896 11304087552 1891589696 18.759 99 35 70 2 1914595488 13232832 9772960
19:15:06 48875 8192000000 10884216784 11328815104 1925737760 19.033 100 47 94 2 1953076496 14294336 13044400
19:16:02 84252 8192000000 10857887200 11323363328 1881417648 18.677 97 38 76 0 1908719520 17489904 9811968
19:17:50 74491 8192000000 10862648400 11336835072 1905456896 18.870 99 19 36 3 1934357808 23179536 5721376
19:19:10 25407 8192000000 10847080064 11342753792 1922562064 19.007 100 6 12 0 1944304784 20232432 1510288
19:19:45 4320 8192000000 10848837040 11340894208 1923427968 19.014 100 1 2 0 1942546832 19009824 109040
19:20:03 29817 8192000000 10848009776 11331850240 1938939776 19.138 100 21 42 0 1951996016 6892688 6163552
19:21:25 61490 8192000000 10850649216 11318968320 1898838464 18.817 98 7 14 0 1906366592 5835408 1692720
19:22:33 60300 8192000000 10871225536 11338756096 1918046976 18.971 99 17 34 0 1930629808 7253024 5329808
19:23:46 107548 8192000000 10843912512 11324555264 1884252576 18.699 97 14 28 0 1901781184 13630336 3898272
19:25:44 57660 8192000000 10861401616 11341545472 1932405088 19.086 100 17 34 0 1951950480 14574032 4971360
19:26:48 35332 8192000000 9610722384 9952317440 756596608 8.454 39 4 8 1 766489776 8828496 1064672

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 07-12-2020 19:29:07 to 07-12-2020 19:29:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 140 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-12-2020 19:29:39 to 07-12-2020 19:29:41.

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          262915
MON$OLDEST_ACTIVE               262916
MON$OLDEST_SNAPSHOT             262916
MON$NEXT_TRANSACTION            262916
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                       2066912
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:147: 
:148: mscs-test-161.budzdorov.ru    Mon Dec  7 19:27:30 2020
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
:151: 
:152: mscs-test-161.budzdorov.ru    Mon Dec  7 19:27:31 2020
:153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:154: 
:155: 
:156: mscs-test-161.budzdorov.ru    Mon Dec  7 19:27:31 2020
:157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:158: 
--- end of diff output ---

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

07.12.20 19:29:42. 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-12-07 19:29:45 No severe PSQL-related problems occured
07.12.20 19:29:46. End of report.