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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17534296 kB
MemAvailable 31498988 kB
Buffers 0 kB
Cached 14144592 kB
SwapCached 3712 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-17 22:27:06
DTS_END                         2020-12-17 22:27:06.7050
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/41136
TRN_ID                          248343
ATT_ID                          684
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: 9054.16 19897 1086499
customer order: creation 176.04 339 21125
customer order: refuse 15.47 312 1856
order to supplier: creation 48.28 1231 5793
order to supplier: removal 3.43 85604 412
invoice (draft): creation 47.10 3341 5652
invoice (draft): removal 51.27 768 6152
invoice accept: apply 43.02 17430 5162
invoice accept: cancel 46.10 672 5532
customer reserve: creation 3866.67 177 464000
customer reserve: removal 4467.17 50 536060
realization accept: apply 84.17 180 10100
realization accept: cancel 73.60 101 8832
payment from customer: creation 60.24 111 7229
payment from customer: removal 5.98 64 718
payment to supplier: creation 49.33 146 5920
payment to supplier: removal 3.69 87 443
service: total inventory turnovers 5.02 1091 602
service: total monetary turnovers 6.60 34 792
service: aggregate perf. data 0.96 15971 115
service: refresh index statistics 0.03 270238 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-12-2020 22:28:16 to 17-12-2020 22:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6189
TEST_TIME 2 6023
TEST_TIME 3 6059
TEST_TIME 4 6102
TEST_TIME 5 5761
TEST_TIME 6 5590
TEST_TIME 7 6013
TEST_TIME 8 6576
TEST_TIME 9 6683
TEST_TIME 10 6704
TEST_TIME 11 7481
TEST_TIME 12 7838
TEST_TIME 13 7789
TEST_TIME 14 7981
TEST_TIME 15 8316
TEST_TIME 16 8406
TEST_TIME 17 8642
TEST_TIME 18 9449
TEST_TIME 19 9478
TEST_TIME 20 9703
TEST_TIME 21 10682
TEST_TIME 22 10941
TEST_TIME 23 11795
TEST_TIME 24 11595
TEST_TIME 25 11654
TEST_TIME 26 11518
TEST_TIME 27 11181
TEST_TIME 28 10962
TEST_TIME 29 10814
TEST_TIME 30 10654
TEST_TIME 31 10508
TEST_TIME 32 10368
TEST_TIME 33 10254
TEST_TIME 34 10218
TEST_TIME 35 10084
TEST_TIME 36 10036
TEST_TIME 37 10105
TEST_TIME 38 9925
TEST_TIME 39 9818
TEST_TIME 40 9765
TEST_TIME 41 9774
TEST_TIME 42 9622
TEST_TIME 43 9510
TEST_TIME 44 9423
TEST_TIME 45 9443
TEST_TIME 46 9379
TEST_TIME 47 9459
TEST_TIME 48 9435
TEST_TIME 49 9403
TEST_TIME 50 9430
TEST_TIME 51 9513
TEST_TIME 52 9520
TEST_TIME 53 9545
TEST_TIME 54 9489
TEST_TIME 55 9497
TEST_TIME 56 9529
TEST_TIME 57 9553
TEST_TIME 58 9669
TEST_TIME 59 9698
TEST_TIME 60 9559
TEST_TIME 61 9453
TEST_TIME 62 9496
TEST_TIME 63 9433
TEST_TIME 64 9409
TEST_TIME 65 9336
TEST_TIME 66 9269
TEST_TIME 67 9225
TEST_TIME 68 9293
TEST_TIME 69 9325
TEST_TIME 70 9312
TEST_TIME 71 9270
TEST_TIME 72 9342
TEST_TIME 73 9378
TEST_TIME 74 9437
TEST_TIME 75 9439
TEST_TIME 76 9398
TEST_TIME 77 9423
TEST_TIME 78 9429
TEST_TIME 79 9415
TEST_TIME 80 9543
TEST_TIME 81 9568
TEST_TIME 82 9539
TEST_TIME 83 9462
TEST_TIME 84 9479
TEST_TIME 85 9417
TEST_TIME 86 9408
TEST_TIME 87 9376
TEST_TIME 88 9355
TEST_TIME 89 9348
TEST_TIME 90 9289
TEST_TIME 91 9250
TEST_TIME 92 9267
TEST_TIME 93 9226
TEST_TIME 94 9218
TEST_TIME 95 9216
TEST_TIME 96 9246
TEST_TIME 97 9248
TEST_TIME 98 9273
TEST_TIME 99 9298
TEST_TIME 100 9286
TEST_TIME 101 9333
TEST_TIME 102 9321
TEST_TIME 103 9317
TEST_TIME 104 9335
TEST_TIME 105 9359
TEST_TIME 106 9359
TEST_TIME 107 9373
TEST_TIME 108 9355
TEST_TIME 109 9273
TEST_TIME 110 9298
TEST_TIME 111 9259
TEST_TIME 112 9227
TEST_TIME 113 9180
TEST_TIME 114 9215
TEST_TIME 115 9179
TEST_TIME 116 9155
TEST_TIME 117 9177
TEST_TIME 118 9147
TEST_TIME 119 9131
TEST_TIME 120 9057

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-12-2020 22:28:19 to 17-12-2020 22:28:23.

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 1516847 1516847 0 0.00 0 31833 6 0 0
doc_list_biud 1516847 1516847 0 0.00 0 59465 23 0 0
sp_add_invoice_to_stock 5241 5162 79 1.50 59 165295 17430 0 79
sp_cancel_adding_invoice 5532 5532 0 0.00 5 57130 672 0 0
sp_cancel_client_order 1856 1856 0 0.00 3 13516 313 0 0
sp_cancel_customer_reserve 536060 536060 0 0.00 1 29042 51 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 2866 64 0 0
sp_cancel_pay_to_supplier 443 443 0 0.00 3 10968 88 0 0
sp_cancel_supplier_invoice 6157 6152 5 0.08 2 59472 769 0 5
sp_cancel_supplier_order 412 412 0 0.00 6 956288 85604 0 0
sp_cancel_write_off 8832 8832 0 0.00 1 8092 101 0 0
sp_client_order 21125 21125 0 0.00 3 19272 339 0 0
sp_customer_reserve 464000 464000 0 0.00 0 49673 177 0 0
sp_fill_shopping_cart 32568 32568 0 0.00 1 12957 43 0 0
sp_fill_shopping_cart_clo_res 463996 463996 0 0.00 0 26013 14 0 0
sp_get_clo_for_invoice 5157 5157 0 0.00 0 32098 357 0 0
sp_kill_cost_storno 15525 15525 0 0.00 0 28305 50 0 0
sp_kill_qstorno_ret_qs2qd 1087516 1087516 0 0.00 0 59462 28 0 0
sp_kill_qty_storno 574101 574101 0 0.00 0 59464 61 0 0
sp_lock_selected_doc 21243 21243 0 0.00 0 9940 5 0 0
sp_make_cost_storno 28406 28406 0 0.00 0 31827 61 0 0
sp_multiply_rows_for_pdistr 28406 28406 0 0.00 0 10614 26 0 0
sp_multiply_rows_for_qdistr 21125 21125 0 0.00 0 13829 152 0 0
sp_pay_from_customer 7229 7229 0 0.00 4 13513 112 0 0
sp_pay_to_supplier 5920 5920 0 0.00 4 32036 146 0 0
sp_payment_common 13149 13149 0 0.00 1 18119 28 0 0
sp_qd_handle_on_cancel_clo 1856 1856 0 0.00 0 13507 288 0 0
sp_qd_handle_on_invoice_upd_sts 10689 10689 0 0.00 0 15353 275 0 0
sp_qd_handle_on_reserve_upd_sts 10100 10100 0 0.00 0 12990 66 0 0
sp_reserve_write_off 10100 10100 0 0.00 6 13016 180 0 0
sp_supplier_invoice 5652 5652 0 0.00 8 80245 3342 0 0
sp_supplier_order 5793 5793 0 0.00 5 65204 1231 0 0
srv_aggregate_perf_data 115 115 0 0.00 3041 143594 15971 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1622 129925 34805 0 0
srv_find_qd_qs_mism 1038321 1038321 0 0.00 0 11563 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 15 150006 1092 0 0
srv_make_money_saldo 792 792 0 0.00 1 7674 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 158040 439936 270238 0 0
t$perf-abend:sp_add_invoice_to_stock 79 79 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5162 5162 0 0.00 0 14095 165 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 3432 83 0 0
t$perf-norm:sp_cancel_client_order 1856 1856 0 0.00 0 3875 14 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 1479 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 6713 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 443 443 0 0.00 0 4160 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 1147 13 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 47275 1539 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 3399 17 0 0
t$perf-norm:sp_client_order 21125 21125 0 0.00 0 11534 17 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 2922 15 0 0
t$perf-norm:sp_pay_from_customer 7229 7229 0 0.00 0 17233 11 0 0
t$perf-norm:sp_pay_to_supplier 5920 5920 0 0.00 0 7735 15 0 0
t$perf-norm:sp_reserve_write_off 10100 10100 0 0.00 0 6587 13 0 0
t$perf-norm:sp_supplier_invoice 5652 5652 0 0.00 0 7875 19 0 0
t$perf-norm:sp_supplier_order 5793 5793 0 0.00 0 6517 19 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 282 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 337 4 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 2867 23 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 4432 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10472 10314 158 1.50 0 4677 18 0 158
v_all_customers 38542 38542 0 0.00 0 22 1 0 0
v_all_suppliers 30920 30920 0 0.00 0 14 1 0 0
v_all_wares 42250 42250 0 0.00 0 107 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 945 6 0 0
v_cancel_client_order 3712 3712 0 0.00 0 1752 4 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 1019 4 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 3202 7 0 0
v_cancel_payment_to_supplier 886 886 0 0.00 0 380 3 0 0
v_cancel_supplier_invoice 802 792 10 1.24 0 1874 19 0 10
v_cancel_supplier_order 824 824 0 0.00 0 966 4 0 0
v_cancel_write_off 2094 2094 0 0.00 0 2721 16 0 0
v_max_id_clo_ord 5792 5792 0 0.00 0 532 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 2081 13 0 0
v_max_id_ord_sup 5651 5651 0 0.00 0 3581 3 0 0
v_max_non_paid_invoice 1903 1903 0 0.00 0 500 2 0 0
v_max_non_paid_realizn 3891 3891 0 0.00 0 4718 6 0 0
v_min_id_clo_ord 5792 5792 0 0.00 0 2767 8 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 4685 16 0 0
v_min_id_ord_sup 5651 5651 0 0.00 0 4387 10 0 0
v_min_non_paid_invoice 5920 5920 0 0.00 0 5526 13 0 0
v_min_non_paid_realizn 7229 7229 0 0.00 0 8561 13 0 0
v_our_firm 10384 10384 0 0.00 0 15 1 0 0
v_reserve_write_off 20198 20198 0 0.00 0 5344 4 0 0
x_lock_depdocs_on_canc_invoice 11288 11288 0 0.00 0 17477 116 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 16455 360 0 0
x_make_qstorno_1000_1200 5793 5793 0 0.00 1 65198 1154 0 0
x_make_qstorno_1200_2000 5652 5652 0 0.00 3 80236 3183 0 0
x_make_qstorno_2100_3300 464000 464000 0 0.00 0 49653 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-12-2020 22:28:24 to 17-12-2020 22:28:28.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 17448 8192000000 10226722096 10537062400 1004080416 10.918 77 56 112 0 1026283888 2998512 19204960
19:57:43 19224 8192000000 10337913360 10655961088 1386741792 14.477 100 81 162 0 1418097744 4940256 26415696
19:58:11 15622 8192000000 10362416112 10684690432 1417728064 14.753 100 82 164 0 1450808448 6000512 27079872
19:58:41 24633 8192000000 10414358992 10741743616 1463179680 15.154 100 85 170 0 1498490608 7374544 27936384
19:59:15 19790 8192000000 10443077648 10777944064 1492057440 15.407 100 88 176 1 1528571056 8011376 28502240
19:59:45 16061 8192000000 10460650400 10798833664 1514858912 15.606 100 88 175 1 1551384064 8754384 27770768
20:00:13 12363 8192000000 10475559280 10813476864 1528168672 15.721 100 90 179 0 1565898016 9118192 28611152
20:00:33 13654 8192000000 10482134960 10822225920 1538814800 15.813 100 86 172 1 1575646560 9581632 27250128
20:00:54 17719 8192000000 10493755088 10838872064 1545954720 15.875 100 87 174 1 1583508592 10095616 27458256
20:01:22 19950 8192000000 10519168192 10869784576 1571489456 16.095 100 82 164 2 1606882432 10131264 25261712
20:01:51 14655 8192000000 10530923392 10886418432 1592940032 16.279 100 88 176 1 1634192480 14827392 26425056
20:02:16 12151 8192000000 10575605408 10931838976 1623685984 16.541 100 87 174 0 1661008288 11284224 26038080
20:02:37 15890 8192000000 10588268784 10949140480 1650539568 16.769 100 81 163 2 1685845312 12057504 23248240
20:03:06 9678 8192000000 10600542336 10963038208 1659563680 16.845 100 80 160 0 1695616304 12336544 23716080
20:03:23 8012 8192000000 10613430080 10980077568 1676278048 16.986 100 78 154 3 1711701616 12951248 22472320
20:03:42 8813 8192000000 10628920288 11002040320 1691191040 17.111 100 76 153 0 1725864576 12661696 22011840
20:04:03 8097 8192000000 10652893984 11028586496 1720366480 17.355 100 72 143 2 1753067936 12494512 20206944
20:04:18 5177 8192000000 10666551360 11041800192 1727874112 17.418 100 77 154 0 1762937008 12456960 22605936
20:04:31 4993 8192000000 10676404880 11053268992 1741254736 17.529 100 71 141 0 1772896624 11900416 19741472
20:04:43 4463 8192000000 10686439184 11067183104 1750427248 17.605 100 78 156 0 1784330688 11687392 22216048
20:04:54 3712 8192000000 10698904608 11077271552 1764850800 17.724 100 71 142 0 1796205744 11207488 20147456
20:05:04 2674 8192000000 10715842512 11096899584 1774701216 17.806 100 76 152 1 1808792432 12246432 21844784
20:05:13 5500 8192000000 10718914368 11099967488 1778092048 17.834 100 80 158 2 1813108464 13325104 21691312
20:05:25 4895 8192000000 10740702832 11124617216 1791661872 17.945 100 75 149 1 1825682320 12715904 21304544
20:05:37 4992 8192000000 10740880544 11130925056 1810083664 18.097 100 73 147 0 1843609184 13180320 20345200
20:05:49 2719 8192000000 10762340368 11149156352 1820695712 18.183 100 85 170 0 1858939888 13122656 25121520
20:05:58 3056 8192000000 10764918960 11155140608 1824513408 18.215 100 87 174 0 1864372000 13912272 25946320
20:06:08 3328 8192000000 10769193712 11157327872 1830888304 18.267 100 85 170 2 1868319824 13976800 23454720
20:06:18 2101 8192000000 10774184272 11159740416 1834964320 18.300 100 92 184 1 1874590368 13342704 26283344
20:06:26 2299 8192000000 10784686064 11168759808 1839379152 18.336 100 92 185 1 1879339536 14994432 24965952
20:06:35 2189 8192000000 10784836304 11171799040 1843074608 18.366 100 91 183 1 1882718320 14641056 25002656
20:06:44 2279 8192000000 10788878336 11175305216 1847911328 18.405 100 87 172 3 1887610160 15147376 24551456
20:06:53 1538 8192000000 10783753936 11176464384 1853156080 18.448 100 91 184 0 1892247040 14054832 25036128
20:07:01 1588 8192000000 10803271104 11188264960 1857549824 18.483 100 94 188 2 1896851568 12300800 27000944
20:07:09 2054 8192000000 10803803776 11190435840 1858383168 18.490 100 93 188 1 1896294400 12001184 25910048
20:07:18 1967 8192000000 10810471632 11200503808 1866848384 18.559 100 91 183 1 1905691648 12865312 25977952
20:07:26 1497 8192000000 10817055552 11206799360 1876558896 18.637 100 91 182 2 1913974944 11409904 26006144
20:07:33 1000 8192000000 10817996240 11210354688 1874207344 18.618 100 89 179 0 1913119856 13582320 25330192
20:07:41 22299 8192000000 10815382944 11214307328 1875694640 18.630 100 71 142 0 1906420944 11492160 19234144
20:08:09 8847 8192000000 10820089840 11218305024 1878557584 18.653 100 76 152 1 1913072384 13499328 21015472
20:08:25 17481 8192000000 10778106576 11203817472 1872961984 18.608 100 35 70 3 1889593600 6768864 9862752
20:08:49 3909 8192000000 10794384992 11207286784 1877600800 18.646 100 43 89 1 1897387120 6740608 13045712
20:08:59 3929 8192000000 10793774672 11213713408 1878195824 18.651 100 26 52 1 1891405888 5925888 7284176
20:09:11 4805 8192000000 10793637936 11217035264 1882262112 18.683 100 35 70 2 1898923888 6501376 10160400
20:09:24 8564 8192000000 10795335584 11218636800 1881942608 18.681 100 24 48 3 1895326368 6826304 6557456
20:09:41 7442 8192000000 10793185504 11223883776 1884787744 18.704 100 20 40 1 1896740416 6516240 5436432
20:09:58 9235 8192000000 10790240000 11224317952 1887181440 18.723 100 28 56 3 1902640848 7139488 8319920
20:10:13 14723 8192000000 10793820080 11228712960 1887700976 18.727 100 18 36 2 1898811696 6113232 4997488
20:10:34 11003 8192000000 10793486288 11233128448 1894578480 18.783 100 19 37 1 1906163168 6314864 5269824
20:10:55 11821 8192000000 10796680176 11232100352 1895350400 18.789 100 15 30 0 1905664736 5805872 4508464
20:11:16 11132 8192000000 10807042832 11238445056 1897752048 18.808 100 20 40 0 1909645760 6029760 5863952
20:11:35 18035 8192000000 10809340272 11245772800 1899451744 18.822 100 15 30 0 1913278720 9732464 4094512
20:12:03 59000 8192000000 10832571248 11260702720 1909204096 18.900 100 33 67 1 1928471936 9127936 10139904
20:13:08 17345 8192000000 10816549952 11256393728 1908593696 18.895 100 25 50 1 1922536320 7014544 6928080
20:13:35 11186 8192000000 10834604144 11263078400 1912412912 18.926 100 25 49 0 1925402656 6380528 6609216
20:13:54 5447 8192000000 10826880368 11266453504 1916388928 18.958 100 31 62 1 1932651520 7600816 8661776
20:14:07 6886 8192000000 10841004480 11269435392 1915285136 18.949 100 40 80 1 1934720832 7776560 11659136
20:14:23 6995 8192000000 10833607072 11267760128 1918339664 18.974 100 37 74 1 1935592336 7079248 10173424
20:14:36 7444 8192000000 10838338880 11267444736 1916452416 18.958 100 25 50 0 1930227600 6325568 7449616
20:14:50 7661 8192000000 10831366048 11269046272 1916848960 18.962 100 21 42 2 1928900016 6296896 5754160
20:15:06 5797 8192000000 10817695280 11260444672 1900495840 18.830 99 19 38 1 1911896912 6124960 5276112
20:15:19 4732 8192000000 10833402704 11257937920 1903245840 18.852 100 41 82 4 1923015024 7407632 12361552
20:15:31 7976 8192000000 10799995888 11236184064 1864443808 18.539 98 17 35 0 1875373536 5992944 4936784
20:15:47 9748 8192000000 10804892608 11239780352 1895532128 18.790 100 20 40 0 1907234944 6199152 5503664
20:16:07 6107 8192000000 10821226896 11256778752 1903580144 18.855 100 20 41 2 1915478336 6446624 5451568
20:16:20 15573 8192000000 10797262016 11228897280 1796479552 17.985 94 12 23 2 1805440896 4999680 3961664
20:16:42 8532 8192000000 10797563008 11228139520 1852145600 18.440 98 21 42 1 1863042384 5287888 5608896
20:17:00 15752 8192000000 10763822848 11191078912 1750632672 17.607 93 16 32 0 1761101840 5017616 5451552
20:17:22 57790 8192000000 10759572880 11169419264 1771487264 17.779 96 27 55 0 1785016192 5310256 8218672
20:18:26 11976 8192000000 10709595856 11137994752 1743476752 17.547 95 27 52 1 1756483280 6213056 6793472
20:18:45 9998 8192000000 10685417296 11096244224 1697289424 17.162 94 28 56 2 1710212336 5834736 7088176
20:19:01 6501 8192000000 10712879296 11127255040 1751787472 17.616 97 32 65 0 1766320816 5734192 8799152
20:19:16 7510 8192000000 10689212800 11107303424 1736853088 17.492 97 23 46 0 1749882192 6528480 6500624
20:19:32 7820 8192000000 10680904320 11092533248 1719405248 17.347 97 33 66 1 1734229920 5698752 9125920
20:19:48 7829 8192000000 10681510752 11086757888 1733823920 17.467 98 27 54 1 1747461472 5824912 7812640
20:20:05 10477 8192000000 10688459776 11110895616 1766643744 17.739 99 19 38 1 1777352544 5481840 5226960
20:20:22 11046 8192000000 10694636096 11112177664 1730839936 17.442 96 26 52 2 1744397472 5455264 8102272
20:20:42 5214 8192000000 10718867776 11131285504 1767283392 17.745 98 21 42 1 1778371824 5176672 5911760
20:20:58 3373 8192000000 10711209328 11133337600 1801919808 18.030 100 24 46 0 1814056240 5418080 6718352
20:21:08 8820 8192000000 10737809040 11151089664 1801447616 18.026 99 29 58 0 1815662368 5186112 9028640
20:21:25 13482 8192000000 10736164384 11160551424 1822416480 18.197 100 29 59 1 1836440944 5286000 8738464
20:21:49 9017 8192000000 10755379456 11174035456 1828959472 18.251 100 15 30 0 1838931184 5787504 4184208
20:22:07 61304 8192000000 10768341616 11186483200 1845216816 18.383 100 44 85 5 1863633712 6327440 12089456
20:23:18 11690 8192000000 10752840448 11180429312 1843642368 18.370 100 21 42 0 1855379984 5859232 5878384
20:23:38 11521 8192000000 10768679968 11188469760 1843962240 18.373 100 15 30 2 1853486128 5159632 4364256
20:23:56 7943 8192000000 10761344816 11188772864 1852063488 18.439 100 27 54 0 1865261408 5821008 7376912
20:24:11 13262 8192000000 10774373488 11193978880 1852256416 18.440 100 21 42 0 1864302320 6381312 5664592
20:24:30 7257 8192000000 10768910624 11198763008 1856646496 18.476 100 22 44 1 1868519216 5314816 6557904
20:24:44 16158 8192000000 10774656880 11205394432 1861143792 18.513 100 19 38 0 1872486752 5218336 6124624
20:25:09 8157 8192000000 10777164048 11209379840 1863084544 18.528 100 13 26 1 1872497168 5334512 4078112
20:25:23 10217 8192000000 10782333152 11212996608 1869609360 18.581 100 24 45 2 1881551872 4755856 7186656
20:25:46 6279 8192000000 10797307456 11220209664 1874227296 18.618 100 31 62 2 1889142752 5418704 9496752
20:26:00 15502 8192000000 10777190352 11216781312 1873105264 18.609 100 18 34 2 1883580112 5199968 5274880
20:26:22 18264 8192000000 10790233760 11221012480 1872353392 18.603 100 10 18 1 1880599456 5269856 2976208
20:26:48 15859 8192000000 10786615200 11221184512 1877732352 18.647 100 24 49 2 1890006144 5469808 6803984
20:27:10 47394 8192000000 10819942240 11245580288 1880153504 18.666 99 33 65 4 1894428384 4690912 9583968
20:28:10 33055 8192000000 10856476544 11273150464 1922709152 19.009 100 55 110 2 1945207856 7133776 15364928
20:28:52 13919 8192000000 10863463520 11283439616 1928992464 19.059 100 62 119 2 1954895536 9568560 16334512
20:29:14 9349 8192000000 10871900208 11292581888 1933589936 19.096 100 63 124 2 1963527488 13183776 16753776
20:29:33 10153 8192000000 10874903648 11298181120 1935007376 19.107 100 53 105 1 1962187104 12326160 14853568
20:29:51 11356 8192000000 10887724224 11306823680 1942588736 19.167 100 60 119 3 1973269712 13467008 17213968
20:30:10 9609 8192000000 10883120080 11309248512 1947249424 19.205 100 64 128 1 1978502048 13542672 17709952
20:30:27 6554 8192000000 10893240480 11310747648 1948457296 19.214 100 54 108 2 1977304352 12059136 16787920
20:30:48 26731 8192000000 10892392288 11317731328 1947848416 19.209 100 52 104 1 1978147680 15717136 14582128
20:31:25 6922 8192000000 10900674192 11325997056 1959282480 19.300 100 54 108 3 1990918640 16146240 15489920
20:31:50 28500 8192000000 10879669856 11311644672 1947712576 19.208 100 44 87 0 1976819152 16491408 12615168
20:32:30 7135 8192000000 10903354032 11328430080 1955809408 19.273 100 43 85 0 1986974592 18699392 12465792
20:32:54 6097 8192000000 10910198144 11338768384 1966460176 19.357 100 54 106 1 2002698528 20361296 15877056
20:33:08 7833 8192000000 10919640752 11342499840 1971536912 19.398 100 63 126 0 2010924736 20141504 19246320
20:33:27 17930 8192000000 10921471168 11341344768 1954014016 19.258 99 53 106 0 1992850560 23442608 15393936
20:33:53 6970 8192000000 10924882816 11348135936 1952266128 19.245 99 54 107 0 1992058064 24236736 15555200
20:34:09 5924 8192000000 10913093632 11339485184 1954361840 19.261 99 63 124 2 1996935152 24119520 18453792
20:34:22 6819 8192000000 10910895616 11336970240 1960706992 19.312 100 54 108 1 2005502880 27847568 16948320
20:34:40 6274 8192000000 10923296272 11342639104 1966791952 19.360 100 61 122 1 2012651808 27107056 18752800
20:34:54 14589 8192000000 10884774640 11317878784 1928019440 19.051 98 52 104 0 1971857248 27692256 16145552
20:35:18 11753 8192000000 10887960272 11323944960 1950680032 19.232 100 42 84 1 1985454496 21438784 13335680
20:35:39 4191 8192000000 10907971952 11333996544 1946444352 19.198 99 53 103 1 1983319040 21825760 15048928
20:35:53 10291 8192000000 10917458688 11341471744 1948432032 19.214 99 58 116 1 1989881424 24187280 17262112
20:36:13 7008 8192000000 10938485728 11356504064 1972513344 19.405 100 71 142 4 2021044080 27914224 20616512
20:36:27 2141 8192000000 10918329280 11326513152 1948823168 19.217 99 79 153 3 2002189696 29875136 23491392
20:36:37 5345 8192000000 10923196736 11340845056 1944890064 19.186 99 69 139 2 1994632928 28536128 21206736
20:36:50 2474 8192000000 10934132336 11342716928 1964304560 19.340 100 82 164 2 2019057264 29714064 25038640
20:37:01 6988 8192000000 10938818128 11351416832 1968476448 19.373 100 77 154 1 2022221072 30452848 23291776
20:37:22 3508 8192000000 10924354048 11330498560 1933285104 19.093 98 72 144 1 1987020864 32503984 21231776
20:37:32 2694 8192000000 10939775456 11348307968 1965804240 19.352 100 79 157 0 2024061024 33944688 24312096
20:37:43 8867 8192000000 10947033424 11365167104 1975620144 19.430 100 73 145 0 2033202992 35978832 21604016
20:38:04 7796 8192000000 10945996016 11362934784 1973373504 19.412 100 69 139 0 2031256160 37303936 20578720
20:38:22 2380 8192000000 10941192176 11361738752 1969079808 19.378 100 77 154 2 2030379216 37672560 23626848
20:38:32 2716 8192000000 10949771792 11365281792 1971876768 19.400 100 84 165 2 2035387872 37993264 25517840
20:38:41 2752 8192000000 10920233520 11327660032 1942526864 19.167 99 79 158 1 2002015872 36106304 23382704
20:38:51 2650 8192000000 10918632656 11324362752 1935244880 19.109 99 82 163 0 1998273456 37421456 25607120
20:39:01 4639 8192000000 10908185328 11318685696 1916820608 18.961 99 79 158 2 1978411408 37222976 24367824
20:39:15 6935 8192000000 10883469408 11290492928 1885056144 18.706 97 68 136 2 1942295392 36303040 20936208
20:39:31 3058 8192000000 10892875152 11307134976 1901932912 18.842 98 65 129 1 1956113984 34404880 19776192
20:39:41 4690 8192000000 10889183376 11297935360 1887901936 18.729 98 73 147 3 1945745616 35996576 21847104
20:39:53 4805 8192000000 10883393776 11297501184 1904199680 18.860 99 63 126 0 1960412160 36803200 19409280
20:40:12 3716 8192000000 10906938752 11317940224 1934425984 19.102 100 71 138 1 1991981280 36321296 21234000
20:40:23 2735 8192000000 10920398960 11321659392 1937451088 19.126 100 87 171 0 2002543136 38564352 26527696
20:40:35 3777 8192000000 10911016480 11318218752 1915316048 18.949 99 75 149 1 1977747792 39679392 22752352
20:40:46 2472 8192000000 10945417056 11346161664 1950527568 19.231 100 85 171 0 2017824176 41424736 25871872
20:40:57 2880 8192000000 10942194496 11350114304 1957040288 19.283 100 79 158 0 2025089872 43405952 24643632
20:41:06 3104 8192000000 10908294672 11306958848 1892066096 18.762 97 79 158 2 1959125568 43009248 24050224
20:41:16 3657 8192000000 10909884992 11317858304 1925492112 19.031 100 73 146 0 1992296368 43837056 22967200
20:41:27 3299 8192000000 10924724704 11324149760 1930979696 19.075 100 82 159 2 1999126928 44152096 23995136
20:41:37 5166 8192000000 10924863376 11331010560 1921289984 18.997 99 79 155 0 1990176048 45205536 23680528
20:41:50 1634 8192000000 10907709040 11306110976 1913845120 18.938 99 92 181 1 1986878576 46082832 26950624
20:41:58 4447 8192000000 10922553120 11319664640 1910804688 18.913 99 88 175 2 1987495456 49717168 26973600
20:42:10 2810 8192000000 10929800704 11327074304 1929177760 19.060 100 87 178 0 2006316192 50539184 26599248
20:42:19 3551 8192000000 10932148384 11335094272 1935800656 19.113 100 85 167 1 2007834448 45941120 26092672
20:42:29 4347 8192000000 10936000992 11344150528 1947448960 19.206 100 73 146 1 2016777648 46098640 23230048
20:42:41 1914 8192000000 10931639408 11343138816 1943280192 19.173 100 76 152 0 2014057360 46839984 23937184
20:42:50 1619 8192000000 10950939648 11354005504 1951775104 19.241 100 86 171 2 2026841392 47457440 27608848
20:43:01 5620 8192000000 10938103856 11354136576 1955497856 19.270 100 70 140 2 2025456016 47304128 22654032
20:43:14 15068 8192000000 10926214512 11350384640 1933474224 19.095 99 55 107 0 1998566400 47657232 17434944
20:43:35 3160 8192000000 10950023520 11365736448 1960536560 19.310 100 69 138 0 2030183312 47885712 21761040
20:43:47 5349 8192000000 10959743104 11374071808 1963910288 19.337 100 73 146 0 2037170496 50544624 22715584
20:44:00 2588 8192000000 10961687472 11378454528 1971237472 19.395 100 78 157 1 2048355536 52758256 24359808
20:44:11 4453 8192000000 10944824368 11372687360 1967499184 19.366 100 66 132 1 2038250272 49465584 21285504
20:44:35 10983 8192000000 10931892688 11364229120 1927082944 19.044 98 46 92 0 1992993024 50431776 15478304
20:44:55 11450 8192000000 10940453072 11368685568 1940133280 19.148 99 46 92 1 2009621280 53417792 16070208
20:45:13 16255 8192000000 10950856240 11385511936 1961653728 19.319 100 47 94 4 2035891280 57660304 16577248
20:45:43 17234 8192000000 10923331232 11368005632 1923370288 19.014 98 32 63 0 1982964112 47984944 11608880
20:46:07 16893 8192000000 10915106944 11356114944 1928895072 19.058 99 31 63 0 1982528256 42663296 10969888
20:46:30 15321 8192000000 10919028720 11364786176 1940687520 19.152 100 32 64 0 2000421808 47656192 12078096
20:47:10 10585 8192000000 10925753792 11369422848 1945917296 19.194 100 35 70 0 2010395936 51455440 13023200
20:47:27 16185 8192000000 10929300160 11373719552 1948194496 19.212 100 39 78 1 2017096544 54653984 14248064
20:47:49 19895 8192000000 10911158400 11373948928 1932387168 19.086 99 30 59 1 1995554256 52109216 11057872
20:48:17 17647 8192000000 10910119056 11375230976 1951435472 19.238 100 28 56 0 1996316768 35897584 8983712
20:48:46 28484 8192000000 10894395904 11356430336 1931066656 19.075 99 24 48 1 1976037200 36526656 8443888
20:49:36 33066 8192000000 10908278016 11361177600 1917454448 18.966 99 18 36 1 1964697488 40881520 6361520
20:50:18 24734 8192000000 10870858672 11336282112 1900567264 18.831 98 13 26 1 1935107984 30164752 4375968
20:50:55 53397 8192000000 10886374448 11341766656 1942823728 19.169 100 23 45 0 1967730928 18539936 6367264
20:51:55 14988 8192000000 10884595840 11343163392 1953642032 19.255 100 44 87 1 1981357520 14696768 13018720
20:52:26 17384 8192000000 10882237056 11351654400 1952376544 19.245 100 18 36 3 1973818832 16206960 5235328
20:52:50 11174 8192000000 10884896688 11353477120 1954343520 19.261 100 10 20 0 1969997200 12720720 2932960
20:54:24 81981 8192000000 10886959840 11358867456 1965985472 19.354 100 34 67 0 1982346080 7311744 9048864
20:56:08 40921 8192000000 10879739280 11355099136 1945556928 19.191 99 13 26 0 1960311408 11075168 3679312
20:57:06 61045 8192000000 10887514992 11357573120 1945798176 19.193 99 14 29 1 1957721616 8091216 3832224
20:58:15 58444 8192000000 10895922896 11355095040 1944025056 19.179 98 18 36 1 1961427296 12490864 4911376
20:59:20 70906 8192000000 10896876640 11360464896 1964544960 19.342 99 22 43 0 1984215328 12995424 6674944
21:00:47 86353 8192000000 10914750544 11379179520 1973541936 19.414 99 21 42 0 1992768384 13335632 5890816
21:02:21 81299 8192000000 10924223200 11383640064 1975871424 19.432 99 22 43 0 1995966112 13900896 6193792
21:03:49 114180 8192000000 10910625792 11391614976 1976442016 19.437 99 11 22 1 1993536576 14012288 3082272
21:05:52 18241 8192000000 10918014528 11386396672 1973490320 19.413 99 15 30 2 1992665792 13728864 5446608
21:06:24 74811 8192000000 10926613344 11402997760 2000433984 19.626 100 24 48 2 2021120544 13389344 7297216
21:07:58 64886 8192000000 10914755328 11403149312 2001208112 19.632 100 7 14 0 2015025344 11940576 1876656
21:09:09 76739 8192000000 10927548544 11404161024 2004643632 19.659 100 14 28 1 2018375808 9503168 4229008
21:10:32 94565 8192000000 10935049200 11406942208 1990408464 19.547 99 28 56 1 2017943072 19170960 8363648
21:12:16 50735 8192000000 10935794192 11419643904 2008416288 19.689 100 27 55 2 2035068816 19775488 6877040
21:13:13 33464 8192000000 10924110048 11405541376 1995626704 19.588 99 10 20 0 2016128832 17758368 2743760
21:14:05 53000 8192000000 10918901536 11398049792 1965475712 19.350 98 15 30 1 1994767936 24932640 4359584
21:15:16 41349 8192000000 10945917104 11405139968 2006907488 19.677 100 24 48 1 2022869264 9006848 6954928
21:16:09 33530 8192000000 10924515152 11394551808 1967388944 19.365 98 32 64 0 1986090528 9999456 8702128
21:16:59 68151 8192000000 10932302448 11395686400 1945912112 19.194 97 24 48 1 1964027120 11410896 6704112
21:18:14 72352 8192000000 10919745232 11382996992 1901104144 18.835 95 24 48 0 1920173808 12501648 6568016
21:19:36 60437 8192000000 10914574416 11386093568 1972079728 19.402 99 28 56 0 1990326560 10644016 7602816
21:20:45 43626 8192000000 10918400320 11367243776 1928960272 19.059 97 32 62 0 1946843632 9240720 8642640
21:21:40 19240 8192000000 10917315536 11367071744 1944233008 19.181 98 44 88 0 1967824160 11427568 12163584
21:22:08 46075 8192000000 10902944032 11359367168 1914349184 18.942 97 39 79 1 1942018640 16985120 10684336
21:23:00 52182 8192000000 10903875376 11355443200 1892215232 18.764 96 28 56 0 1914266256 14090752 7960272
21:24:01 120943 8192000000 10876444848 11341697024 1812606880 18.117 93 12 24 1 1833651024 17713296 3330848
21:26:14 129925 8192000000 10868657216 11319422976 1885329568 18.708 97 17 34 1 1907385104 16932464 5123072
21:28:33 66242 8192000000 10841604704 11298480128 1817843776 18.160 94 19 38 0 1837531232 14620464 5066992
21:29:51 45844 8192000000 10825541072 11282808832 1878779200 18.655 98 26 52 1 1901505776 15580560 7146016
21:30:43 40924 8192000000 10832769712 11291774976 1862227824 18.521 98 15 30 0 1876999408 10446384 4325200
21:31:39 79821 8192000000 10856973408 11324547072 1912125200 18.924 99 15 29 1 1924375600 8229056 4021344
21:33:06 73214 8192000000 10856500176 11331350528 1903429408 18.854 98 13 27 1 1924864240 17108544 4326288
21:34:28 44569 8192000000 10852227504 11341533184 1927959680 19.051 100 8 16 0 1949004208 18242736 2801792
21:35:19 33952 8192000000 10860339696 11343024128 1930975600 19.075 100 10 20 1 1949653680 15595408 3082672
21:35:59 51159 8192000000 10835567392 11321700352 1834633680 18.297 95 14 28 1 1856103232 17606000 3863552
21:37:49 87271 8192000000 10874398160 11344699392 1888598688 18.734 97 12 24 2 1908118448 15666864 3852896
21:39:26 60293 8192000000 10865932192 11340550144 1923864256 19.018 99 17 34 2 1944204192 15236688 5103248
21:40:33 60753 8192000000 10875504080 11334594560 1920265072 18.989 99 12 24 0 1936739232 12845552 3628608
21:41:53 49854 8192000000 10880229584 11331051520 1894693792 18.784 97 36 71 0 1913300992 8144320 10462880
21:42:56 26510 8192000000 10859260736 11311063040 1866227568 18.554 96 26 52 2 1882113296 8851488 7034240
21:43:29 29035 8192000000 10885941792 11336130560 1940131520 19.148 100 35 70 0 1959908320 10127200 9649600
21:44:06 13827 8192000000 10897124896 11344580608 1950760672 19.233 100 51 103 0 1979427872 14584288 14082912
21:44:30 92711 8192000000 10857551824 11330666496 1851938208 18.438 95 23 45 1 1871069616 12488592 6642816
21:46:13 73055 8192000000 10890043920 11361259520 1917695264 18.968 99 15 29 0 1934775536 13080880 3999392
21:47:45 111712 8192000000 10877434752 11347398656 1935775808 19.113 99 15 30 1 1953128432 13377952 3974672
21:50:37 80691 8192000000 10877335856 11348488192 1941736160 19.161 99 30 59 1 1957543312 7193184 8613968
21:52:12 66695 8192000000 10885243584 11332055040 1899241376 18.820 97 22 44 0 1912166672 7049200 5876096
21:53:26 51251 8192000000 10862768816 11350716416 1950529360 19.231 100 13 26 0 1964012608 9697904 3785344
21:54:24 41182 8192000000 10863733744 11346903040 1930009344 19.067 99 7 14 0 1943385280 11433600 1942336
21:55:21 51601 8192000000 10868228368 11338719232 1930055312 19.067 99 15 30 1 1942637072 8485680 4096080
21:56:28 80696 8192000000 10881988704 11363147776 1949573552 19.223 99 14 29 0 1961935360 8816096 3545712
21:58:04 82178 8192000000 10886717648 11373838336 1955193808 19.268 99 26 52 2 1971288080 8885968 7208304
21:59:39 47775 8192000000 10882570112 11370340352 1952864688 19.249 99 14 27 1 1965850128 9089216 3896224
22:01:04 49950 8192000000 10883630176 11363082240 1936193616 19.116 98 12 24 0 1951154512 11884960 3075936
22:02:10 60164 8192000000 10893500272 11366993920 1935994080 19.115 98 17 34 0 1949011120 8639120 4377920
22:03:16 49812 8192000000 10894717008 11375595520 1978612688 19.454 100 20 40 0 1991575600 7769568 5193344
22:04:17 47988 8192000000 10891789472 11366596608 1957357440 19.285 99 22 44 0 1972119456 8871648 5890368
22:05:21 69060 8192000000 10908113104 11381538816 1917403168 18.966 97 15 30 0 1930961136 9375248 4182720
22:06:39 84076 8192000000 10894614160 11365027840 1918471344 18.975 97 13 25 0 1942228496 19764064 3993088
22:08:12 53385 8192000000 10871285776 11333931008 1864282064 18.538 95 8 16 0 1879932464 13104080 2546320
22:09:19 111363 8192000000 10875449792 11334246400 1890946896 18.753 96 31 62 0 1910269024 11098624 8223504
22:11:17 91544 8192000000 10891297168 11353960448 1891665776 18.759 96 22 44 1 1909886512 12127184 6093552
22:12:54 57438 8192000000 10870820704 11325124608 1841175568 18.350 94 23 46 1 1855961024 7847920 6937536
22:13:58 23198 8192000000 10874999616 11326312448 1920804560 18.993 99 39 78 1 1941225792 9613760 10807472
22:14:29 24136 8192000000 10867938128 11328860160 1938147808 19.132 100 28 56 1 1956598496 10793904 7656784
22:15:03 114112 8192000000 10885932736 11345035264 1953029296 19.251 100 20 41 1 1974812400 15798048 5985056
22:17:15 60842 8192000000 10863007600 11328208896 1906407712 18.878 98 20 38 1 1926512000 14842256 5262032
22:18:23 47044 8192000000 10827257680 11288965120 1863152448 18.529 96 15 30 0 1881475920 14120672 4202800
22:19:26 62716 8192000000 10831359744 11304280064 1888517488 18.734 98 5 10 0 1900986160 11188032 1280640
22:20:44 55231 8192000000 10835682704 11308380160 1888321424 18.732 98 12 24 0 1903931472 12381312 3228736
22:21:55 32666 8192000000 10827779392 11298873344 1883263280 18.691 98 7 14 0 1895261488 10353376 1644832
22:22:35 69793 8192000000 10827115376 11297046528 1861774832 18.518 97 12 25 0 1872752768 7464080 3513856
22:24:03 39830 8192000000 10852585680 11312496640 1905008960 18.867 99 16 32 0 1919654592 10001136 4644496
22:24:54 53377 8192000000 10830607264 11287486464 1789474736 17.927 93 14 28 1 1799667712 6221568 3971408
22:25:56 42336 8192000000 10808503872 11268251648 1814912784 18.136 95 16 32 0 1833129936 13708720 4508432
22:26:52 23260 8192000000 9189235136 9438097408 352569120 4.126 19 3 4 1 359947152 6604544 773488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 17-12-2020 22:28:30 to 17-12-2020 22:29:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 79 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-12-2020 22:29:01 to 17-12-2020 22:29:03.

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          248708
MON$OLDEST_ACTIVE               248709
MON$OLDEST_SNAPSHOT             248709
MON$NEXT_TRANSACTION            248709
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                       2018048
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:16: 
:17: mscs-test-161.budzdorov.ru    Thu Dec 17 22:27:28 2020
:18:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:19: 
--- end of diff output ---

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

17.12.20 22:29:04. 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-17 22:29:07 No severe PSQL-related problems occured
17.12.20 22:29:08. End of report.