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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16867944 kB
MemAvailable 31159848 kB
Buffers 0 kB
Cached 14809116 kB
SwapCached 4772 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-13 19:27:17
DTS_END                         2021-02-13 19:27:17.3110
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34164
TRN_ID                          244573
ATT_ID                          653
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: 9232.03 20663 1107844
customer order: creation 177.00 329 21240
customer order: refuse 15.55 328 1866
order to supplier: creation 48.22 1275 5786
order to supplier: removal 3.48 93700 417
invoice (draft): creation 47.87 3608 5744
invoice (draft): removal 51.57 748 6188
invoice accept: apply 43.64 18653 5237
invoice accept: cancel 46.37 771 5564
customer reserve: creation 3910.41 190 469249
customer reserve: removal 4590.33 56 550840
realization accept: apply 87.53 182 10504
realization accept: cancel 75.89 116 9107
payment from customer: creation 61.23 114 7348
payment from customer: removal 6.01 83 721
payment to supplier: creation 50.53 129 6064
payment to supplier: removal 3.77 70 452
service: total inventory turnovers 4.86 1252 583
service: total monetary turnovers 6.96 27 835
service: aggregate perf. data 0.79 27469 95
service: refresh index statistics 0.03 264169 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-02-2021 19:27:58 to 13-02-2021 19:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7821
TEST_TIME 2 7253
TEST_TIME 3 6733
TEST_TIME 4 6463
TEST_TIME 5 6282
TEST_TIME 6 6526
TEST_TIME 7 6418
TEST_TIME 8 6284
TEST_TIME 9 6336
TEST_TIME 10 6603
TEST_TIME 11 6540
TEST_TIME 12 6882
TEST_TIME 13 7460
TEST_TIME 14 7661
TEST_TIME 15 8039
TEST_TIME 16 8115
TEST_TIME 17 8214
TEST_TIME 18 8614
TEST_TIME 19 8582
TEST_TIME 20 8638
TEST_TIME 21 8965
TEST_TIME 22 9016
TEST_TIME 23 9061
TEST_TIME 24 9366
TEST_TIME 25 9437
TEST_TIME 26 9730
TEST_TIME 27 9852
TEST_TIME 28 10060
TEST_TIME 29 10649
TEST_TIME 30 11148
TEST_TIME 31 10949
TEST_TIME 32 11032
TEST_TIME 33 10977
TEST_TIME 34 10706
TEST_TIME 35 10438
TEST_TIME 36 10434
TEST_TIME 37 10337
TEST_TIME 38 10198
TEST_TIME 39 10173
TEST_TIME 40 10143
TEST_TIME 41 10115
TEST_TIME 42 10127
TEST_TIME 43 9972
TEST_TIME 44 9968
TEST_TIME 45 9971
TEST_TIME 46 9863
TEST_TIME 47 9799
TEST_TIME 48 9683
TEST_TIME 49 9714
TEST_TIME 50 9641
TEST_TIME 51 9535
TEST_TIME 52 9454
TEST_TIME 53 9549
TEST_TIME 54 9442
TEST_TIME 55 9377
TEST_TIME 56 9300
TEST_TIME 57 9193
TEST_TIME 58 9296
TEST_TIME 59 9318
TEST_TIME 60 9407
TEST_TIME 61 9395
TEST_TIME 62 9434
TEST_TIME 63 9368
TEST_TIME 64 9420
TEST_TIME 65 9445
TEST_TIME 66 9524
TEST_TIME 67 9478
TEST_TIME 68 9514
TEST_TIME 69 9539
TEST_TIME 70 9492
TEST_TIME 71 9522
TEST_TIME 72 9561
TEST_TIME 73 9507
TEST_TIME 74 9446
TEST_TIME 75 9458
TEST_TIME 76 9393
TEST_TIME 77 9338
TEST_TIME 78 9334
TEST_TIME 79 9309
TEST_TIME 80 9307
TEST_TIME 81 9285
TEST_TIME 82 9244
TEST_TIME 83 9178
TEST_TIME 84 9144
TEST_TIME 85 9138
TEST_TIME 86 9107
TEST_TIME 87 9158
TEST_TIME 88 9123
TEST_TIME 89 9182
TEST_TIME 90 9238
TEST_TIME 91 9263
TEST_TIME 92 9255
TEST_TIME 93 9312
TEST_TIME 94 9298
TEST_TIME 95 9354
TEST_TIME 96 9337
TEST_TIME 97 9316
TEST_TIME 98 9301
TEST_TIME 99 9413
TEST_TIME 100 9362
TEST_TIME 101 9298
TEST_TIME 102 9246
TEST_TIME 103 9213
TEST_TIME 104 9157
TEST_TIME 105 9115
TEST_TIME 106 9137
TEST_TIME 107 9155
TEST_TIME 108 9144
TEST_TIME 109 9155
TEST_TIME 110 9115
TEST_TIME 111 9132
TEST_TIME 112 9175
TEST_TIME 113 9174
TEST_TIME 114 9177
TEST_TIME 115 9161
TEST_TIME 116 9194
TEST_TIME 117 9243
TEST_TIME 118 9282
TEST_TIME 119 9306
TEST_TIME 120 9238

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-02-2021 19:28:02 to 13-02-2021 19:28:05.

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 1541528 1541528 0 0.00 0 12073 7 0 0
doc_list_biud 1541525 1541525 0 0.00 0 46110 26 0 0
sp_add_invoice_to_stock 5354 5237 117 2.18 31 164201 18654 0 117
sp_cancel_adding_invoice 5564 5564 0 0.00 5 58634 771 0 0
sp_cancel_client_order 1866 1866 0 0.00 4 10121 329 0 0
sp_cancel_customer_reserve 550840 550840 0 0.00 1 46111 57 0 0
sp_cancel_pay_from_customer 721 721 0 0.00 3 3869 83 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 3749 70 0 0
sp_cancel_supplier_invoice 6191 6188 3 0.04 2 31320 748 0 3
sp_cancel_supplier_order 417 417 0 0.00 7 1075431 93701 0 0
sp_cancel_write_off 9107 9107 0 0.00 1 13509 117 0 0
sp_client_order 21240 21240 0 0.00 3 30351 330 0 0
sp_customer_reserve 469249 469249 0 0.00 0 76551 190 0 0
sp_fill_shopping_cart 32762 32762 0 0.00 1 22360 43 0 0
sp_fill_shopping_cart_clo_res 469241 469241 0 0.00 0 15830 13 0 0
sp_get_clo_for_invoice 5228 5228 0 0.00 0 33003 339 0 0
sp_kill_cost_storno 15844 15844 0 0.00 0 7470 56 0 0
sp_kill_qstorno_ret_qs2qd 1117392 1117392 0 0.00 0 46107 31 0 0
sp_kill_qty_storno 589712 589712 0 0.00 0 46109 66 0 0
sp_lock_selected_doc 21793 21793 0 0.00 0 7952 4 0 0
sp_make_cost_storno 29143 29143 0 0.00 0 11406 59 0 0
sp_multiply_rows_for_pdistr 29143 29143 0 0.00 0 7464 33 0 0
sp_multiply_rows_for_qdistr 21240 21240 0 0.00 0 13548 143 0 0
sp_pay_from_customer 7348 7348 0 0.00 4 10333 115 0 0
sp_pay_to_supplier 6064 6064 0 0.00 5 12067 130 0 0
sp_payment_common 13412 13412 0 0.00 1 10301 27 0 0
sp_qd_handle_on_cancel_clo 1866 1866 0 0.00 0 10113 305 0 0
sp_qd_handle_on_invoice_upd_sts 10790 10790 0 0.00 0 9995 316 0 0
sp_qd_handle_on_reserve_upd_sts 10504 10504 0 0.00 0 11564 56 0 0
sp_reserve_write_off 10504 10504 0 0.00 6 12079 183 0 0
sp_supplier_invoice 5744 5744 0 0.00 6 77438 3609 0 0
sp_supplier_order 5786 5786 0 0.00 5 30251 1276 0 0
srv_aggregate_perf_data 95 95 0 0.00 2431 743877 27470 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 901 127054 29262 0 0
srv_find_qd_qs_mism 1058333 1058333 0 0.00 0 11432 6 0 0
srv_make_invnt_saldo 583 583 0 0.00 62 159996 1253 0 0
srv_make_money_saldo 835 835 0 0.00 1 989 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 103289 451408 264169 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5237 5237 0 0.00 0 11995 196 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 0 3094 92 0 0
t$perf-norm:sp_cancel_client_order 1866 1866 0 0.00 0 5147 18 0 0
t$perf-norm:sp_cancel_customer_reserve 763 763 0 0.00 0 3129 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 721 721 0 0.00 0 9521 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 1553 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 1858 17 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 29541 1430 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 3978 15 0 0
t$perf-norm:sp_client_order 21240 21240 0 0.00 0 19650 21 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 2616 9 0 0
t$perf-norm:sp_pay_from_customer 7348 7348 0 0.00 0 5842 8 0 0
t$perf-norm:sp_pay_to_supplier 6064 6064 0 0.00 0 9518 9 0 0
t$perf-norm:sp_reserve_write_off 10504 10504 0 0.00 0 9202 12 0 0
t$perf-norm:sp_supplier_invoice 5744 5744 0 0.00 0 3100 20 0 0
t$perf-norm:sp_supplier_order 5786 5786 0 0.00 0 2223 17 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 1545 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 1200 18 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 5651 33 0 0
t$perf-norm:srv_make_money_saldo 835 835 0 0.00 0 3672 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10684 10450 234 2.19 0 12872 19 0 234
v_all_customers 38544 38544 0 0.00 0 17 1 0 0
v_all_suppliers 31176 31176 0 0.00 0 23 1 0 0
v_all_wares 42478 42478 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 1804 9 0 0
v_cancel_client_order 3732 3732 0 0.00 0 3415 5 0 0
v_cancel_customer_prepayment 1442 1442 0 0.00 0 1774 4 0 0
v_cancel_customer_reserve 1526 1526 0 0.00 0 3009 6 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 749 5 0 0
v_cancel_supplier_invoice 844 838 6 0.71 0 260 13 0 6
v_cancel_supplier_order 834 834 0 0.00 0 2774 7 0 0
v_cancel_write_off 2046 2046 0 0.00 0 2530 16 0 0
v_max_id_clo_ord 5782 5782 0 0.00 0 2054 2 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 4634 21 0 0
v_max_id_ord_sup 5740 5740 0 0.00 0 3084 4 0 0
v_max_non_paid_invoice 1998 1998 0 0.00 0 540 3 0 0
v_max_non_paid_realizn 4002 4002 0 0.00 0 996 4 0 0
v_min_id_clo_ord 5782 5782 0 0.00 0 2720 7 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 5544 13 0 0
v_min_id_ord_sup 5740 5740 0 0.00 0 5224 8 0 0
v_min_non_paid_invoice 6064 6064 0 0.00 0 6089 16 0 0
v_min_non_paid_realizn 7348 7348 0 0.00 0 4762 16 0 0
v_our_firm 10626 10626 0 0.00 0 14 1 0 0
v_reserve_write_off 21008 21008 0 0.00 0 4109 6 0 0
x_lock_depdocs_on_canc_invoice 11333 11333 0 0.00 0 9567 106 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 21935 414 0 0
x_make_qstorno_1000_1200 5786 5786 0 0.00 1 30242 1181 0 0
x_make_qstorno_1200_2000 5744 5744 0 0.00 3 75855 3463 0 0
x_make_qstorno_2100_3300 469249 469249 0 0.00 0 76550 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-02-2021 19:28:06 to 13-02-2021 19:28:10.

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:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:27 30890 8192000000 10282720816 10591645696 1028660064 11.156 79 61 121 0 1050151408 2706832 18784512
16:58:07 33491 8192000000 10365405328 10685267968 1406426288 14.652 100 83 166 1 1439009744 5515040 27068416
16:58:48 26157 8192000000 10405594816 10728767488 1450925440 15.046 100 92 184 0 1487310768 6706704 29678624
16:59:35 27455 8192000000 10425346096 10755477504 1479293680 15.295 100 84 168 1 1514155616 7972736 26889200
17:00:17 20751 8192000000 10444649264 10778169344 1498929280 15.467 100 87 174 0 1535364176 8635568 27799328
17:00:46 20848 8192000000 10470172384 10807992320 1520223904 15.652 100 85 170 0 1556911392 9302144 27385344
17:01:19 16973 8192000000 10486643136 10835279872 1542843936 15.848 100 72 144 0 1574525600 9151904 22529760
17:01:45 15777 8192000000 10528423616 10873024512 1567265104 16.059 100 82 162 1 1602223776 9806752 25151920
17:02:10 7266 8192000000 10531426224 10883137536 1591952608 16.271 100 85 170 0 1628651008 10786000 25912400
17:02:29 13391 8192000000 10550603584 10906324992 1607710032 16.405 100 76 151 1 1641270688 10853920 22706736
17:02:52 14115 8192000000 10583300464 10943401984 1636056416 16.646 100 79 158 1 1670692720 11025904 23610400
17:03:17 11464 8192000000 10610459712 10970173440 1659667760 16.846 100 84 168 0 1696298144 11887904 24742480
17:03:38 12984 8192000000 10622113008 10988417024 1682010512 17.034 100 85 170 1 1718670608 12021120 24638976
17:04:01 9161 8192000000 10645534512 11015585792 1701948112 17.201 100 80 159 2 1737145056 12290272 22906672
17:04:17 9501 8192000000 10655568208 11030241280 1716228880 17.321 100 81 162 1 1752280288 12350704 23700704
17:04:34 10596 8192000000 10670843168 11043577856 1729903472 17.435 100 74 148 2 1764197904 12407808 21886624
17:04:52 7467 8192000000 10684035024 11059445760 1745550768 17.565 100 76 152 1 1778589840 11349856 21689216
17:05:07 6171 8192000000 10693188704 11074191360 1758840320 17.675 100 77 155 2 1792671984 11970432 21861232
17:05:21 6078 8192000000 10708347616 11090960384 1772107552 17.784 100 77 154 0 1806287232 12977264 21202416
17:05:34 4374 8192000000 10711380256 11086520320 1776278832 17.819 100 84 168 3 1813356272 13350720 23726720
17:05:45 4530 8192000000 10727025296 11106189312 1786710896 17.905 100 82 160 3 1822502368 12877264 22914208
17:05:57 5151 8192000000 10732753888 11117060096 1795119296 17.974 100 85 169 2 1832431472 13314512 23997664
17:06:08 2961 8192000000 10735736160 11120873472 1799234784 18.008 100 78 156 0 1834767680 13719280 21813616
17:06:18 2859 8192000000 10748415616 11132059648 1807629424 18.076 100 86 171 1 1844813792 13223392 23960976
17:06:29 3780 8192000000 10750404960 11135881216 1815850448 18.144 100 85 170 3 1852885376 13596496 23438432
17:06:39 5383 8192000000 10758099872 11144466432 1816503376 18.149 100 74 148 0 1849733504 13102560 20127568
17:06:52 4660 8192000000 10766943280 11148345344 1819778928 18.176 100 89 178 2 1859421840 14394224 25248688
17:07:03 2930 8192000000 10779852944 11165712384 1833847152 18.291 100 91 180 0 1873906976 14474048 25585776
17:07:12 2078 8192000000 10769494528 11162001408 1838174032 18.326 100 87 174 4 1877164208 14260272 24729904
17:07:20 2292 8192000000 10781130400 11170029568 1844842304 18.380 100 94 188 1 1885053936 13273200 26938432
17:07:29 2890 8192000000 10791826064 11180838912 1852252336 18.440 100 89 176 1 1889692528 12669168 24771024
17:07:39 2024 8192000000 10800908080 11186368512 1855893088 18.470 100 90 180 2 1894096496 12474960 25728448
17:07:47 2673 8192000000 10801606688 11187466240 1857083296 18.480 100 87 177 3 1894640512 13214368 24342848
17:07:56 1714 8192000000 10804106128 11192360960 1862423248 18.523 100 92 183 1 1903333008 14205536 26704224
17:08:04 1817 8192000000 10805986912 11193593856 1863378592 18.531 100 91 181 1 1902273200 13652624 25241984
17:08:12 1669 8192000000 10817179568 11203829760 1867543184 18.564 100 90 181 0 1907196992 13797472 25856336
17:08:20 1306 8192000000 10816142000 11202461696 1868989760 18.576 100 94 188 2 1910023904 15085424 25948720
17:08:28 1706 8192000000 10819593360 11206475776 1867830976 18.567 100 90 179 1 1906848336 14282352 24735008
17:08:36 1456 8192000000 10821557440 11208253440 1872222160 18.602 100 88 177 1 1909640464 13319632 24098672
17:08:43 1909 8192000000 10809608544 11209707520 1873503136 18.613 100 81 162 0 1909985280 13447344 23034800
17:08:52 1804 8192000000 10811866800 11210727424 1875129760 18.626 100 87 175 3 1912094176 11271888 25692528
17:09:00 1763 8192000000 10820468464 11212267520 1877388368 18.644 100 76 152 0 1910502432 11059360 22054704
17:09:08 7336 8192000000 10789488128 11207237632 1873970784 18.616 100 49 99 0 1895588400 8571584 13046032
17:09:23 41320 8192000000 10802456592 11216424960 1876292912 18.635 100 36 72 2 1893075312 6094400 10688000
17:10:15 6501 8192000000 10794145552 11219632128 1878711584 18.655 100 27 52 1 1893094960 7000512 7382864
17:10:30 9068 8192000000 10788315680 11220455424 1877238160 18.643 100 17 33 0 1887131744 5482448 4411136
17:10:50 11859 8192000000 10790530368 11225755648 1883131744 18.690 100 27 53 0 1900587024 9678688 7776592
17:11:08 14031 8192000000 10792637664 11225944064 1884933232 18.705 100 23 45 6 1896960560 6304336 5722992
17:11:28 4968 8192000000 10797605056 11228385280 1887468320 18.725 100 21 39 3 1899225264 6132144 5624800
17:11:41 8306 8192000000 10803620048 11232653312 1890341120 18.749 100 21 42 1 1902730016 6499360 5889536
17:11:58 8062 8192000000 10810784736 11238359040 1896000544 18.794 100 24 49 3 1909341472 6933056 6407872
17:12:16 15491 8192000000 10793994896 11234541568 1893982000 18.778 100 16 32 0 1904347360 5932752 4432608
17:12:37 12185 8192000000 10802956928 11240304640 1895780688 18.792 100 19 37 3 1906556944 5754240 5022016
17:13:02 9872 8192000000 10802595744 11241316352 1897334656 18.805 100 13 26 1 1906397280 5607888 3454736
17:13:18 11733 8192000000 10803250736 11244572672 1899852928 18.825 100 12 24 2 1908569104 5521984 3194192
17:13:37 10672 8192000000 10809406544 11240300544 1881037424 18.673 99 17 34 1 1891423008 5681936 4703648
17:13:54 50258 8192000000 10841794672 11254525952 1899279584 18.820 100 19 38 1 1910881488 5453232 6148672
17:14:51 23201 8192000000 10847682496 11260723200 1910870416 18.914 100 63 127 1 1935787360 6210320 18706624
17:15:20 6924 8192000000 10817950448 11255959552 1907551904 18.887 100 37 74 2 1927002576 9470912 9979760
17:15:36 11346 8192000000 10822525408 11258609664 1906271712 18.877 100 29 57 1 1921012784 6340432 8400640
17:15:55 9199 8192000000 10810120640 11245260800 1885259280 18.708 99 22 44 0 1897376752 5950832 6166640
17:16:12 6278 8192000000 10808906016 11241209856 1866253360 18.554 98 33 63 0 1880283728 5401824 8628544
17:16:26 5797 8192000000 10804405360 11239505920 1879726592 18.663 99 32 62 2 1895282576 6665696 8890288
17:16:40 4690 8192000000 10809917408 11245211648 1884173760 18.699 99 32 63 1 1900133392 7461152 8498480
17:16:50 6088 8192000000 10812933360 11244912640 1891078144 18.754 100 31 62 0 1906276240 6477552 8720544
17:17:06 8043 8192000000 10812893280 11244883968 1898332624 18.813 100 27 54 1 1912528608 5682224 8513760
17:17:26 5526 8192000000 10799852192 11235262464 1888568160 18.734 100 32 63 1 1904958032 7891584 8498288
17:17:41 22582 8192000000 10774505360 11203121152 1755731248 17.649 93 6 12 0 1762363952 5081728 1550976
17:18:10 5644 8192000000 10782900848 11194556416 1828923360 18.251 98 26 50 2 1842145312 5806848 7415104
17:18:22 39399 8192000000 10775494944 11199176704 1831886528 18.275 98 34 66 2 1847238528 4883792 10468208
17:19:16 31030 8192000000 10740355680 11164352512 1734362448 17.472 93 25 49 1 1748726112 6187120 8176544
17:19:58 14849 8192000000 10721297728 11136737280 1691574736 17.115 92 26 52 2 1704336800 4905776 7856288
17:20:20 6576 8192000000 10724388640 11135041536 1761123888 17.694 98 26 51 1 1774340464 5296160 7920416
17:20:34 8249 8192000000 10709598800 11133693952 1778658400 17.838 98 22 44 0 1791510256 6611200 6240656
17:20:53 4037 8192000000 10729795072 11148582912 1792796912 17.955 98 36 71 2 1809285904 6497264 9991728
17:21:05 6173 8192000000 10697829840 11115823104 1764181728 17.719 97 25 51 1 1777402976 6413616 6807632
17:21:18 5553 8192000000 10684206816 11104845824 1730793952 17.442 96 30 60 1 1745758160 6416960 8547248
17:21:31 6032 8192000000 10663763984 11076067328 1732137712 17.453 97 33 66 0 1747677936 5787776 9752448
17:21:43 6553 8192000000 10705553856 11127873536 1781853856 17.865 99 22 44 2 1794320240 6385040 6081344
17:21:56 6637 8192000000 10720460992 11144712192 1796046928 17.981 99 35 70 0 1817403936 10946080 10410928
17:22:12 7856 8192000000 10712553088 11140427776 1793449312 17.960 99 15 30 2 1802557296 4698864 4409120
17:22:26 11294 8192000000 10729179168 11152678912 1816763280 18.151 100 26 52 0 1835281984 10672816 7845888
17:22:47 10571 8192000000 10742409232 11169009664 1827916672 18.242 100 25 50 2 1841355872 6057136 7382064
17:23:04 14990 8192000000 10739213824 11163914240 1812837296 18.119 99 16 32 0 1823442288 5874960 4730032
17:23:25 10162 8192000000 10767116752 11180740608 1841479376 18.353 100 26 52 0 1854672752 5096016 8097360
17:23:42 79481 8192000000 10772025968 11195088896 1851652928 18.436 100 30 59 0 1866487120 5012480 9821712
17:25:10 11188 8192000000 10766847712 11198541824 1854839584 18.461 100 19 38 1 1865527952 5254912 5433456
17:25:31 7793 8192000000 10779166464 11203284992 1856379808 18.474 100 31 62 2 1872298752 7576800 8342144
17:25:50 8022 8192000000 10777942176 11206893568 1862782960 18.526 100 31 60 1 1878351984 7123760 8445264
17:26:06 4728 8192000000 10786857216 11211030528 1866407568 18.555 100 36 69 2 1882761152 6793936 9559648
17:26:17 7287 8192000000 10775673136 11207606272 1864993296 18.544 100 20 40 1 1877307152 6476480 5837376
17:26:32 11020 8192000000 10780743472 11213737984 1870224096 18.586 100 17 33 3 1880535872 5503872 4807904
17:26:51 10029 8192000000 10780479808 11218403328 1872028448 18.601 100 22 44 2 1884326096 5227984 7069664
17:27:07 10230 8192000000 10804564288 11233071104 1888150480 18.731 100 26 51 1 1900854800 5690720 7013600
17:27:31 13550 8192000000 10839143264 11254235136 1908487952 18.895 100 49 99 1 1929411728 6748272 14175504
17:27:51 20991 8192000000 10848182960 11268960256 1918116544 18.972 100 56 112 4 1942586528 8861776 15608208
17:28:20 19016 8192000000 10860331568 11282989056 1930352320 19.070 100 66 130 1 1958687840 10398960 17936560
17:28:46 39052 8192000000 10864192864 11289034752 1932199424 19.084 100 54 108 1 1956965280 9484192 15281664
17:29:34 14918 8192000000 10863710112 11299569664 1937729696 19.129 100 48 96 2 1961540512 10504640 13306176
17:30:02 10075 8192000000 10871033024 11303571456 1939418672 19.142 100 38 76 2 1959313376 9230608 10664096
17:30:19 20734 8192000000 10878404976 11310276608 1946142592 19.196 100 48 96 1 1971005024 11071472 13790960
17:30:56 26636 8192000000 10884441856 11316953088 1952823920 19.249 100 45 90 1 1974376208 8435216 13117072
17:31:30 22923 8192000000 10915892672 11330191360 1949837024 19.225 99 68 133 0 1980825856 12473760 18515072
17:32:13 3558 8192000000 10915550112 11338797056 1969459408 19.381 100 62 122 1 2000715200 13922048 17333744
17:32:23 3584 8192000000 10922700352 11342925824 1973963872 19.417 100 73 145 0 2010343952 14344096 22035984
17:32:35 13470 8192000000 10924487136 11350749184 1976631792 19.438 100 67 132 0 2012093920 15695696 19766432
17:33:02 28372 8192000000 10908332368 11341635584 1958711168 19.296 99 59 118 3 1993116144 17755360 16649616
17:33:49 11826 8192000000 10906914704 11347415040 1974322768 19.420 100 49 97 0 2006251824 17283200 14645856
17:34:20 18923 8192000000 10898481600 11341000704 1942001088 19.163 98 48 96 1 1973619712 17285632 14332992
17:34:49 18692 8192000000 10904894864 11339530240 1966433136 19.357 100 51 102 0 1997566816 16280512 14853168
17:35:17 8131 8192000000 10906452784 11345702912 1971619120 19.398 100 52 103 1 2002623216 15703792 15300304
17:35:35 13141 8192000000 10916375216 11350523904 1977439088 19.444 100 53 106 1 2009452960 16355152 15658720
17:35:56 7114 8192000000 10922302064 11347390464 1972307584 19.404 100 46 92 0 2003071504 16948656 13815264
17:36:11 7422 8192000000 10919075792 11349032960 1972914064 19.409 100 53 106 1 2007068432 18367280 15787088
17:36:25 5272 8192000000 10917958928 11349024768 1957980464 19.290 99 68 136 0 1996800288 19179056 19640768
17:36:38 7832 8192000000 10923637392 11350097920 1975078608 19.426 100 68 135 0 2014503776 20677328 18747840
17:37:01 3599 8192000000 10931700656 11358760960 1980681232 19.470 100 67 134 2 2021869936 21815872 19372832
17:37:11 1974 8192000000 10940012432 11364323328 1984323232 19.499 100 71 141 0 2026963936 22768208 19872496
17:37:20 3566 8192000000 10933168704 11355488256 1981704256 19.478 100 73 146 3 2025713344 22763056 21246032
17:37:31 5412 8192000000 10938543984 11361124352 1982035024 19.481 100 81 163 1 2029097424 23315424 23746976
17:37:43 3692 8192000000 10932908752 11346309120 1970215312 19.387 100 78 153 2 2014310800 21889600 22205888
17:37:54 4239 8192000000 10939357616 11355869184 1978636400 19.454 100 80 159 0 2025160096 22676528 23847168
17:38:05 12191 8192000000 10932258000 11358961664 1979857664 19.464 100 71 142 1 2024146720 23056160 21232896
17:38:29 6821 8192000000 10936649600 11365953536 1984186624 19.498 100 65 130 0 2027914160 23900816 19826720
17:38:47 2732 8192000000 10946250384 11372175360 1987623232 19.525 100 65 130 2 2033427408 25454240 20349936
17:38:59 2691 8192000000 10950001616 11367493632 1981929824 19.480 100 81 160 1 2032925408 26427472 24568112
17:39:08 3496 8192000000 10944483968 11366326272 1968560848 19.374 99 75 146 1 2020021600 28193744 23267008
17:39:19 4461 8192000000 10941732768 11364777984 1975836800 19.432 100 76 150 0 2027351776 29178368 22336608
17:39:32 3885 8192000000 10945130096 11367399424 1977609328 19.446 100 71 142 1 2028845888 29665200 21571360
17:39:43 10154 8192000000 10953386496 11380359168 1984358944 19.499 100 64 127 1 2035413024 31516992 19537088
17:40:00 12057 8192000000 10955333312 11384348672 1989223552 19.538 100 58 117 0 2037416800 30673920 17519328
17:40:21 6644 8192000000 10944249312 11375824896 1986257792 19.514 100 59 118 2 2033922192 29236192 18428208
17:40:36 4322 8192000000 10936211744 11367284736 1952826176 19.249 98 67 134 0 2002393248 29535312 20031760
17:40:53 3387 8192000000 10946849616 11370704896 1987715568 19.526 100 79 158 0 2037657904 26685872 23256464
17:41:03 4076 8192000000 10936207328 11366592512 1978157568 19.450 100 61 122 3 2022828272 26434688 18236016
17:41:16 4441 8192000000 10952005776 11369414656 1983451744 19.492 100 77 154 3 2033377616 26644832 23281040
17:41:27 3332 8192000000 10941661920 11363291136 1975435728 19.429 100 79 157 0 2028064192 28151744 24476720
17:41:38 2398 8192000000 10947080448 11366207488 1959850976 19.305 99 79 158 1 2012864432 29009280 24004176
17:41:48 1743 8192000000 10956142016 11373199360 1980002960 19.465 100 81 157 1 2036766736 31482320 25281456
17:41:57 3108 8192000000 10926071504 11344273408 1935428048 19.110 98 82 164 0 1991509936 31547744 24534144
17:42:08 6158 8192000000 10923485248 11347759104 1957048672 19.283 100 63 126 4 2006757600 30874256 18834672
17:42:22 4390 8192000000 10912198224 11337461760 1922195376 19.004 98 67 133 0 1974471648 31681568 20594704
17:42:33 3003 8192000000 10932966960 11351461888 1959541280 19.302 100 74 145 1 2013208112 31652192 22014640
17:42:43 2662 8192000000 10925104400 11337793536 1949869872 19.225 100 84 166 2 2006461952 30498208 26093872
17:42:52 2328 8192000000 10928982016 11334397952 1950737888 19.232 100 79 155 1 2005492096 31305488 23448720
17:43:03 4033 8192000000 10915918832 11334213632 1944421856 19.182 100 77 154 0 1999290720 30879104 23989760
17:43:15 9508 8192000000 10906921008 11330285568 1941622352 19.160 100 73 146 1 1994893088 31467184 21803552
17:43:31 2363 8192000000 10914026848 11320803328 1928502656 19.055 100 84 166 3 1988268944 34782320 24983968
17:43:40 6862 8192000000 10870214928 11299422208 1904487600 18.862 99 59 118 0 1957602848 35189504 17925744
17:43:58 7715 8192000000 10905138896 11332218880 1931733872 19.081 100 60 120 1 1986501056 36177616 18589568
17:44:15 3594 8192000000 10916113104 11327135744 1927561328 19.047 99 79 157 1 1989849712 38645136 23643248
17:44:27 1903 8192000000 10920846832 11330764800 1934144640 19.100 100 81 158 1 1999262928 40243264 24875024
17:44:37 5630 8192000000 10904331152 11328446464 1918480784 18.975 99 76 152 1 1980619296 39210240 22928272
17:44:49 3527 8192000000 10899656256 11314270208 1921112096 18.996 99 74 145 0 1980526480 37602144 21812240
17:45:00 2941 8192000000 10874549680 11291668480 1889160528 18.739 98 72 144 2 1948878400 37042624 22675248
17:45:10 2938 8192000000 10910975776 11319377920 1934040224 19.099 100 81 161 0 1990555264 31137712 25377328
17:45:19 900 8192000000 10917343552 11329601536 1947994464 19.211 100 83 165 1 2001681888 28767392 24920032
17:45:27 1460 8192000000 10926470384 11334537216 1952172048 19.244 100 88 169 3 2007459728 30157376 25130304
17:45:36 5571 8192000000 10894871296 11294134272 1912204512 18.924 99 80 156 0 1967844976 31912304 23728160
17:45:48 5913 8192000000 10920586176 11322568704 1937234272 19.125 100 88 169 2 1997308880 35224144 24850464
17:46:02 7330 8192000000 10920144864 11332489216 1939330368 19.141 100 81 162 0 2000375152 36853248 24191536
17:46:16 1433 8192000000 10932209920 11339186176 1944009152 19.179 100 83 165 0 2008235744 39069552 25157040
17:46:25 1887 8192000000 10922718704 11322699776 1935621168 19.112 99 88 177 0 2001428016 39362000 26444848
17:46:35 1999 8192000000 10950053216 11350605824 1955017792 19.266 100 88 175 2 2020921312 39346384 26557136
17:46:47 3933 8192000000 10901012480 11312467968 1907934736 18.890 98 73 144 3 1970582576 40643312 22004528
17:46:58 4838 8192000000 10930777552 11341656064 1944747344 19.185 100 87 170 1 2014727360 43299040 26680976
17:47:09 2139 8192000000 10933775632 11345674240 1944894208 19.186 100 85 167 0 2014038272 43389312 25754752
17:47:20 2829 8192000000 10945870272 11352633344 1951558240 19.239 100 90 181 2 2027578448 48079600 27940608
17:47:34 2962 8192000000 10931207888 11347079168 1944320688 19.181 100 71 141 2 2014753184 48135392 22297104
17:47:44 8493 8192000000 10917761984 11348459520 1943935120 19.178 100 46 92 1 2004418640 45201312 15282208
17:48:00 1565 8192000000 10945860240 11360419840 1958063312 19.291 100 82 162 1 2031496608 47486800 25946496
17:48:09 5058 8192000000 10919049952 11353354240 1932586768 19.088 99 45 90 0 1995162256 48303840 14271648
17:48:32 6997 8192000000 10924376000 11351842816 1949899344 19.226 100 51 102 1 2015128576 48725072 16504160
17:48:53 15839 8192000000 10908322832 11338289152 1914731296 18.945 98 39 78 1 1977344688 48927008 13686384
17:49:24 8667 8192000000 10912848272 11343126528 1928245200 19.053 99 51 101 2 1990508688 46601264 15662224
17:49:39 15811 8192000000 10914818688 11348291584 1942083744 19.163 100 46 92 0 2003808304 46223632 15500928
17:50:06 13518 8192000000 10930502256 11364122624 1946752272 19.201 100 41 82 1 2010355248 49909952 13693024
17:50:29 18259 8192000000 10934369152 11367608320 1954071216 19.259 100 42 84 0 2016162480 48078752 14012512
17:50:56 18328 8192000000 10937285136 11379224576 1960498032 19.310 100 50 100 2 2028180672 51747728 15934912
17:51:28 5550 8192000000 10950258848 11386572800 1965070560 19.346 100 54 107 1 2035243504 53175456 16997488
17:51:43 13066 8192000000 10942444336 11391762432 1969765424 19.384 100 43 86 0 2033672416 49361680 14545312
17:52:10 15521 8192000000 10936358096 11387146240 1963137696 19.331 100 29 58 1 2023965024 50409936 10417392
17:52:32 21259 8192000000 10932963088 11386466304 1964474368 19.342 100 33 66 2 2027756704 52314048 10968288
17:53:00 23645 8192000000 10935958448 11377184768 1944368688 19.182 99 26 50 2 2000452240 47973904 8109648
17:53:31 28134 8192000000 10924930048 11376390144 1953430976 19.254 100 24 48 3 2002173744 40611552 8131216
17:54:17 22993 8192000000 10916500608 11385290752 1957185920 19.284 100 21 42 0 2011671184 47622400 6862864
17:55:12 22101 8192000000 10916897360 11382362112 1950376224 19.229 100 18 36 0 2007724576 51069296 6279056
17:56:00 52108 8192000000 10898173552 11374362624 1946690960 19.200 100 23 46 1 2005764592 50843456 8230176
17:57:46 74151 8192000000 10882121200 11336822784 1898878816 18.817 97 21 40 0 1917962160 14474624 4608720
17:59:08 25664 8192000000 10862442880 11319050240 1891513136 18.758 97 11 22 0 1903682976 8658288 3511552
17:59:40 76562 8192000000 10883168304 11350798336 1938868160 19.138 99 6 12 0 1952118688 11927648 1322880
18:01:02 118177 8192000000 10885430704 11328958464 1934541296 19.103 98 35 71 2 1954373216 9688304 10143616
18:03:54 29459 8192000000 10891810784 11363004416 1967264048 19.364 100 9 18 1 1982451904 12910272 2277584
18:04:32 40198 8192000000 10926014288 11375685632 1978093344 19.450 100 33 66 1 2001365744 12777856 10494544
18:05:18 69245 8192000000 10916020192 11376365568 1964778464 19.344 99 31 60 0 1990654016 18203056 7672496
18:06:34 59616 8192000000 10904146352 11357990912 1904324320 18.861 96 20 38 1 1928612608 19296288 4992000
18:07:41 60914 8192000000 10894186000 11363647488 1942435456 19.166 99 16 32 0 1967140016 19797776 4906784
18:08:52 53997 8192000000 10911884896 11365351424 1965542928 19.350 100 13 26 0 1986233456 16844288 3846240
18:09:57 37085 8192000000 10906511968 11356741632 1956458672 19.278 99 21 42 1 1973632384 11318560 5855152
18:12:43 68334 8192000000 10888920256 11355000832 1922409200 19.006 97 14 26 1 1940948336 14658992 3880144
18:14:01 42471 8192000000 10897768144 11370164224 1963893280 19.337 100 12 24 0 1987561568 20200688 3467600
18:15:07 103858 8192000000 10881048480 11346087936 1933851936 19.098 98 13 26 1 1951730960 14152896 3726128
18:17:07 55609 8192000000 10887680048 11354816512 1956173120 19.276 99 23 47 0 1970058896 7462480 6423296
18:18:15 30752 8192000000 10905119776 11362271232 1955549392 19.271 99 23 46 0 1971615632 9237808 6828432
18:18:54 55281 8192000000 10888730640 11360681984 1938843120 19.138 98 16 31 3 1954093072 10396144 4853808
18:20:03 37716 8192000000 10879772176 11367280640 1969504848 19.382 100 18 37 3 1983911408 9129392 5277168
18:20:49 61152 8192000000 10889388064 11367456768 1926385744 19.038 97 10 20 0 1938678896 9449280 2843872
18:21:59 44270 8192000000 10882989136 11344048128 1921391904 18.998 97 24 48 1 1937372016 9009424 6970688
18:22:59 69431 8192000000 10893640688 11375489024 1977792576 19.447 100 18 36 0 1993903328 11130560 4980192
18:24:15 76441 8192000000 10891992480 11383996416 1977805312 19.447 100 13 26 0 1992629136 10651904 4171920
18:26:24 96324 8192000000 10863172640 11337625600 1872205280 18.602 95 16 32 0 1888692320 12000368 4486672
18:28:06 48552 8192000000 10845399264 11309756416 1818843200 18.168 93 11 22 0 1827806432 6454144 2509088
18:29:01 80408 8192000000 10846622272 11310501888 1823550640 18.207 94 9 18 1 1833808720 7982000 2276080
18:30:30 24521 8192000000 10864534800 11313717248 1883379216 18.692 97 36 72 1 1903250736 9971728 9899792
18:31:07 24649 8192000000 10845871888 11289907200 1873350208 18.611 97 58 116 0 1905231152 15069056 16811888
18:31:48 74633 8192000000 10857503472 11333611520 1900376000 18.829 99 18 36 2 1915602128 10374048 4852080
18:33:42 58999 8192000000 10870241376 11322855424 1825150832 18.220 94 27 52 1 1843928048 11354208 7423008
18:34:47 88138 8192000000 10866078448 11330957312 1895270912 18.788 98 23 46 1 1915631200 13904512 6455776
18:36:27 51351 8192000000 10825674560 11288035328 1819497664 18.174 94 17 34 1 1832858720 8711072 4649984
18:37:25 54573 8192000000 10866678720 11323396096 1922443936 19.006 100 31 63 0 1943568848 12467520 8657392
18:38:28 62988 8192000000 10864240064 11325648896 1895930144 18.794 98 17 34 0 1917643696 16896224 4817328
18:39:37 43200 8192000000 10867878256 11323465728 1921457888 18.999 99 31 62 2 1941443856 11175408 8810560
18:40:33 113513 8192000000 10850462784 11307184128 1865302384 18.546 96 35 70 2 1884563568 8952368 10308816
18:42:32 80072 8192000000 10848968896 11314540544 1908604528 18.895 99 16 32 0 1925864160 12686128 4573504
18:43:59 17137 8192000000 10840025760 11300503552 1905435408 18.870 99 30 58 0 1922267392 7795136 9036848
18:44:24 2575 8192000000 10859644128 11310624768 1922782864 19.009 100 39 74 4 1941556512 7635824 11137824
18:44:33 15538 8192000000 10886111664 11329216512 1933996432 19.099 100 39 78 0 1954438272 9682976 10758864
18:44:55 30661 8192000000 10844671904 11325800448 1938124496 19.132 100 49 98 1 1962868992 10958176 13786320
18:45:33 64176 8192000000 10854901584 11332263936 1921032048 18.995 99 14 28 1 1936315712 11320672 3962992
18:46:43 56508 8192000000 10859087296 11343716352 1930496176 19.071 100 6 12 1 1943392448 11196752 1699520
18:47:49 18531 8192000000 10853234240 11332259840 1918669152 18.976 99 5 10 0 1932268656 12218400 1381104
18:48:23 75752 8192000000 10858204528 11345801216 1939681264 19.144 100 10 20 2 1955156416 12661072 2814080
18:49:48 45716 8192000000 10876099408 11342336000 1944088272 19.179 100 23 45 2 1957536304 6971440 6476592
18:50:43 8856 8192000000 10875827504 11343171584 1954866704 19.265 100 63 125 2 1982437664 9468112 18102848
18:51:54 52757 8192000000 10866246400 11348480000 1930870992 19.074 99 11 20 1 1945635584 12098576 2666016
18:54:46 54349 8192000000 10881500384 11354656768 1948409008 19.214 100 13 26 0 1967659840 15373344 3877488
18:55:52 39680 8192000000 10897591712 11369332736 1958882192 19.297 100 21 42 2 1981834304 17024960 5927152
18:56:38 55996 8192000000 10877243696 11356606464 1864969344 18.544 95 20 39 2 1886094896 16172448 4953104
18:57:41 88702 8192000000 10900246480 11369508864 1925255904 19.029 98 17 32 1 1947579584 17519312 4804368
18:59:18 57248 8192000000 10913350432 11381596160 1958783136 19.296 99 23 46 0 1976403264 11036480 6583648
19:01:18 56044 8192000000 10907616496 11381755904 1951934288 19.242 99 25 50 1 1969264080 11148384 6181408
19:02:20 82060 8192000000 10919106256 11382083584 1960022256 19.306 99 13 25 4 1973346256 9773776 3550224
19:03:49 13280 8192000000 10912215136 11376201728 1955329280 19.269 98 50 100 0 1977177456 8104256 13743920
19:04:13 35837 8192000000 10923351312 11357392896 1906402240 18.878 96 46 92 0 1928021664 8497008 13122416
19:04:57 11802 8192000000 10895613360 11341422592 1909077696 18.899 97 46 92 0 1932769616 11220128 12471792
19:05:16 34481 8192000000 10914879712 11365335040 1957049680 19.283 100 36 72 1 1981130976 14127072 9954224
19:06:01 25311 8192000000 10917989728 11383373824 1967061760 19.362 100 39 78 0 1996100848 17818688 11220400
19:06:41 67464 8192000000 10890070144 11382497280 1892791456 18.768 96 6 12 0 1917132496 22961984 1379056
19:08:10 85648 8192000000 10895172544 11363934208 1960124784 19.307 100 31 62 1 1976249632 7209120 8915728
19:09:42 37435 8192000000 10858394896 11336900608 1902728672 18.848 97 14 28 0 1915858160 8628848 4500640
19:10:32 39444 8192000000 10870704128 11350396928 1937121888 19.124 99 7 14 1 1949510848 9885600 2503360
19:11:21 46980 8192000000 10880762752 11353100288 1938737200 19.137 99 10 20 2 1955801936 14305280 2759456
19:12:18 73002 8192000000 10895041504 11381002240 1961497936 19.318 100 18 36 2 1983829440 17334960 4996544
19:13:37 28346 8192000000 10880579360 11368407040 1949086416 19.219 100 11 22 1 1968177040 16227952 2862672
19:14:13 40979 8192000000 10883924176 11366850560 1955424592 19.270 100 10 20 0 1968983632 10850704 2708336
19:15:00 71489 8192000000 10881415680 11359490048 1909433424 18.902 97 12 24 0 1921199376 8579344 3186608
19:16:18 35130 8192000000 10872617280 11347677184 1886863600 18.720 96 10 20 0 1897253488 7268208 3121680
19:17:04 33243 8192000000 10878884048 11338440704 1930288848 19.069 99 44 87 1 1954154528 10957360 12908320
19:17:50 38197 8192000000 10895958720 11365109760 1960255136 19.308 100 29 59 0 1985886688 17389728 8241824
19:18:35 48332 8192000000 10885156368 11355856896 1905155248 18.868 97 15 30 1 1923403616 13856064 4392304
19:20:02 71061 8192000000 10890411744 11359059968 1923234112 19.013 98 21 42 1 1942050464 12714384 6101968
19:21:49 49676 8192000000 10905848768 11379150848 1949859952 19.225 99 19 38 2 1968441184 13187776 5393456
19:22:54 61055 8192000000 10862223152 11339571200 1831610976 18.272 93 26 51 0 1856176912 17586992 6978944
19:24:08 53449 8192000000 10882392304 11362234368 1898970848 18.818 98 10 21 0 1925520000 23250816 3298336
19:25:16 127054 8192000000 9478420032 9785049088 563612576 6.437 30 3 6 0 574756272 10465712 677984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-02-2021 19:28:12 to 13-02-2021 19:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-02-2021 19:28:45 to 13-02-2021 19:28:47.

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          245285
MON$OLDEST_ACTIVE               245286
MON$OLDEST_SNAPSHOT             245286
MON$NEXT_TRANSACTION            245286
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                       2054496
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 ---
--- end of diff output ---

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

13.02.21 19:28:48. 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-13 19:28:50 No severe PSQL-related problems occured
13.02.21 19:28:52. End of report.