Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.11.2020 16: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 17448732 kB
MemAvailable 31602304 kB
Buffers 0 kB
Cached 14219220 kB
SwapCached 1984 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-11-30 16:27:04
DTS_END                         2020-11-30 16:27:04.1330
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/53810
TRN_ID                          246926
ATT_ID                          703
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: 9591.89 19002 1151027
customer order: creation 181.38 421 21765
customer order: refuse 15.15 307 1818
order to supplier: creation 47.36 1329 5683
order to supplier: removal 3.56 96575 427
invoice (draft): creation 48.15 3308 5778
invoice (draft): removal 55.05 742 6606
invoice accept: apply 42.52 17024 5102
invoice accept: cancel 49.60 699 5952
customer reserve: creation 4014.99 166 481799
customer reserve: removal 4828.25 55 579390
realization accept: apply 86.71 164 10405
realization accept: cancel 83.58 107 10030
payment from customer: creation 62.19 125 7463
payment from customer: removal 5.80 85 696
payment to supplier: creation 51.84 141 6221
payment to supplier: removal 3.63 68 435
service: total inventory turnovers 4.68 1150 561
service: total monetary turnovers 6.59 27 791
service: aggregate perf. data 0.84 23426 101
service: refresh index statistics 0.03 234122 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-11-2020 16:28:12 to 30-11-2020 16:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6813
TEST_TIME 2 6028
TEST_TIME 3 6053
TEST_TIME 4 5700
TEST_TIME 5 6035
TEST_TIME 6 5672
TEST_TIME 7 5857
TEST_TIME 8 5833
TEST_TIME 9 6346
TEST_TIME 10 6339
TEST_TIME 11 6876
TEST_TIME 12 6916
TEST_TIME 13 6915
TEST_TIME 14 6968
TEST_TIME 15 6811
TEST_TIME 16 7029
TEST_TIME 17 7710
TEST_TIME 18 7745
TEST_TIME 19 8150
TEST_TIME 20 8884
TEST_TIME 21 8847
TEST_TIME 22 9135
TEST_TIME 23 9707
TEST_TIME 24 10481
TEST_TIME 25 10887
TEST_TIME 26 11017
TEST_TIME 27 10776
TEST_TIME 28 10767
TEST_TIME 29 10551
TEST_TIME 30 10812
TEST_TIME 31 10957
TEST_TIME 32 10990
TEST_TIME 33 11060
TEST_TIME 34 10917
TEST_TIME 35 11098
TEST_TIME 36 11079
TEST_TIME 37 10899
TEST_TIME 38 10663
TEST_TIME 39 10610
TEST_TIME 40 10696
TEST_TIME 41 10617
TEST_TIME 42 10567
TEST_TIME 43 10467
TEST_TIME 44 10402
TEST_TIME 45 10521
TEST_TIME 46 10493
TEST_TIME 47 10445
TEST_TIME 48 10357
TEST_TIME 49 10240
TEST_TIME 50 10179
TEST_TIME 51 10101
TEST_TIME 52 10045
TEST_TIME 53 9964
TEST_TIME 54 9919
TEST_TIME 55 9927
TEST_TIME 56 9881
TEST_TIME 57 9952
TEST_TIME 58 9957
TEST_TIME 59 9911
TEST_TIME 60 10026
TEST_TIME 61 10114
TEST_TIME 62 10078
TEST_TIME 63 10164
TEST_TIME 64 10121
TEST_TIME 65 10153
TEST_TIME 66 10273
TEST_TIME 67 10295
TEST_TIME 68 10198
TEST_TIME 69 10091
TEST_TIME 70 10083
TEST_TIME 71 9991
TEST_TIME 72 10027
TEST_TIME 73 9952
TEST_TIME 74 9955
TEST_TIME 75 9863
TEST_TIME 76 9935
TEST_TIME 77 9920
TEST_TIME 78 9880
TEST_TIME 79 9891
TEST_TIME 80 9851
TEST_TIME 81 9942
TEST_TIME 82 9909
TEST_TIME 83 9968
TEST_TIME 84 10035
TEST_TIME 85 9998
TEST_TIME 86 10028
TEST_TIME 87 10084
TEST_TIME 88 10109
TEST_TIME 89 10069
TEST_TIME 90 10005
TEST_TIME 91 9963
TEST_TIME 92 9918
TEST_TIME 93 9898
TEST_TIME 94 9837
TEST_TIME 95 9832
TEST_TIME 96 9800
TEST_TIME 97 9802
TEST_TIME 98 9782
TEST_TIME 99 9774
TEST_TIME 100 9814
TEST_TIME 101 9817
TEST_TIME 102 9846
TEST_TIME 103 9876
TEST_TIME 104 9888
TEST_TIME 105 9911
TEST_TIME 106 9888
TEST_TIME 107 9912
TEST_TIME 108 9896
TEST_TIME 109 9948
TEST_TIME 110 9870
TEST_TIME 111 9809
TEST_TIME 112 9780
TEST_TIME 113 9739
TEST_TIME 114 9727
TEST_TIME 115 9691
TEST_TIME 116 9663
TEST_TIME 117 9674
TEST_TIME 118 9640
TEST_TIME 119 9672
TEST_TIME 120 9592

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-11-2020 16:28:15 to 30-11-2020 16:28:19.

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 1598105 1598105 0 0.00 0 30511 6 0 0
doc_list_biud 1598057 1598057 0 0.00 0 28403 25 0 0
sp_add_invoice_to_stock 5234 5102 132 2.52 28 172573 17024 0 132
sp_cancel_adding_invoice 5952 5952 0 0.00 5 60852 700 0 0
sp_cancel_client_order 1818 1818 0 0.00 4 7938 307 0 0
sp_cancel_customer_reserve 579390 579390 0 0.00 1 28405 55 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 5945 85 0 0
sp_cancel_pay_to_supplier 435 435 0 0.00 3 2950 69 0 0
sp_cancel_supplier_invoice 6616 6606 10 0.15 1 16724 742 0 10
sp_cancel_supplier_order 427 427 0 0.00 6 880174 96576 0 0
sp_cancel_write_off 10030 10030 0 0.00 1 11220 107 0 0
sp_client_order 21765 21765 0 0.00 4 34163 422 0 0
sp_customer_reserve 481799 481799 0 0.00 0 49047 166 0 0
sp_fill_shopping_cart 33190 33190 0 0.00 1 9798 35 0 0
sp_fill_shopping_cart_clo_res 481790 481790 0 0.00 0 22511 13 0 0
sp_get_clo_for_invoice 5093 5093 0 0.00 0 16067 237 0 0
sp_kill_cost_storno 17113 17113 0 0.00 0 11213 53 0 0
sp_kill_qstorno_ret_qs2qd 1175843 1175843 0 0.00 0 28394 30 0 0
sp_kill_qty_storno 619721 619721 0 0.00 0 28403 65 0 0
sp_lock_selected_doc 21460 21460 0 0.00 0 9200 6 0 0
sp_make_cost_storno 29182 29182 0 0.00 0 15647 45 0 0
sp_multiply_rows_for_pdistr 29182 29182 0 0.00 0 7423 29 0 0
sp_multiply_rows_for_qdistr 21765 21765 0 0.00 0 22522 190 0 0
sp_pay_from_customer 7463 7463 0 0.00 4 29565 126 0 0
sp_pay_to_supplier 6221 6221 0 0.00 4 25212 141 0 0
sp_payment_common 13668 13668 0 0.00 1 14739 27 0 0
sp_qd_handle_on_cancel_clo 1818 1818 0 0.00 0 6576 277 0 0
sp_qd_handle_on_invoice_upd_sts 11045 11045 0 0.00 0 25814 314 0 0
sp_qd_handle_on_reserve_upd_sts 10405 10405 0 0.00 0 19746 49 0 0
sp_reserve_write_off 10405 10405 0 0.00 5 19814 164 0 0
sp_supplier_invoice 5778 5778 0 0.00 5 117744 3309 0 0
sp_supplier_order 5683 5683 0 0.00 5 39756 1329 0 0
srv_aggregate_perf_data 101 101 0 0.00 2379 602446 23427 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 831 145336 34485 0 0
srv_find_qd_qs_mism 1101510 1101510 0 0.00 0 30511 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 49 139223 1150 0 0
srv_make_money_saldo 791 791 0 0.00 1 3300 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 150550 275301 234122 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5102 5102 0 0.00 0 10096 173 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 5468 98 0 0
t$perf-norm:sp_cancel_client_order 1818 1818 0 0.00 0 4529 14 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 1965 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 938 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 435 435 0 0.00 0 2774 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 818 9 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 23997 1706 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 796 4 0 0
t$perf-norm:sp_client_order 21765 21765 0 0.00 0 10600 17 0 0
t$perf-norm:sp_customer_reserve 1028 1028 0 0.00 0 1520 6 0 0
t$perf-norm:sp_pay_from_customer 7463 7463 0 0.00 0 4386 9 0 0
t$perf-norm:sp_pay_to_supplier 6221 6221 0 0.00 0 6517 10 0 0
t$perf-norm:sp_reserve_write_off 10405 10405 0 0.00 0 10646 17 0 0
t$perf-norm:sp_supplier_invoice 5778 5778 0 0.00 0 6458 16 0 0
t$perf-norm:sp_supplier_order 5683 5683 0 0.00 0 6857 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 82 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 499 10 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 4775 26 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 1609 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10447 10183 264 2.52 0 14383 19 0 264
v_all_customers 39928 39928 0 0.00 0 17 1 0 0
v_all_suppliers 32206 32206 0 0.00 0 16 1 0 0
v_all_wares 43494 43494 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 1563 8 0 0
v_cancel_client_order 3636 3636 0 0.00 0 3847 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 1764 6 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 2901 7 0 0
v_cancel_payment_to_supplier 870 870 0 0.00 0 2931 10 0 0
v_cancel_supplier_invoice 824 804 20 2.42 0 266 13 0 20
v_cancel_supplier_order 854 854 0 0.00 0 1232 4 0 0
v_cancel_write_off 2070 2070 0 0.00 0 4645 17 0 0
v_max_id_clo_ord 5678 5678 0 0.00 0 3916 2 0 0
v_max_id_clo_res 1028 1028 0 0.00 0 1530 13 0 0
v_max_id_ord_sup 5765 5765 0 0.00 0 5338 4 0 0
v_max_non_paid_invoice 1554 1554 0 0.00 0 1603 4 0 0
v_max_non_paid_realizn 3779 3779 0 0.00 0 2546 5 0 0
v_min_id_clo_ord 5678 5678 0 0.00 0 4167 5 0 0
v_min_id_clo_res 1028 1028 0 0.00 0 3339 12 0 0
v_min_id_ord_sup 5765 5765 0 0.00 0 8748 14 0 0
v_min_non_paid_invoice 6214 6214 0 0.00 0 9726 18 0 0
v_min_non_paid_realizn 7454 7454 0 0.00 0 8384 17 0 0
v_our_firm 10916 10916 0 0.00 0 11 1 0 0
v_reserve_write_off 20810 20810 0 0.00 0 3849 6 0 0
x_lock_depdocs_on_canc_invoice 12156 12156 0 0.00 0 15498 96 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 3609 274 0 0
x_make_qstorno_1000_1200 5683 5683 0 0.00 2 39510 1260 0 0
x_make_qstorno_1200_2000 5778 5778 0 0.00 3 108982 3173 0 0
x_make_qstorno_2100_3300 481799 481799 0 0.00 0 49038 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-11-2020 16:28:20 to 30-11-2020 16:28:24.

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
13:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:14 17314 8192000000 10237816096 10541461504 908559968 9.983 73 58 122 1 930632672 2608416 19464288
13:57:38 32339 8192000000 10344694592 10659700736 1379841136 14.415 100 83 166 0 1411664464 4768000 27055328
13:58:20 34948 8192000000 10378595536 10701467648 1419599856 14.769 100 87 174 0 1455359872 6538176 29221840
13:59:02 24237 8192000000 10386673840 10714689536 1444980128 14.994 100 88 176 0 1481656144 7409584 29266432
13:59:37 16811 8192000000 10408569072 10739396608 1462944576 15.152 100 84 168 0 1498439072 7738896 27755600
14:00:02 26421 8192000000 10441811376 10772451328 1482622080 15.324 100 88 176 0 1519678464 8279376 28777008
14:00:38 14884 8192000000 10447747696 10785722368 1508036240 15.546 100 88 176 0 1545117760 9052304 28029216
14:01:00 24070 8192000000 10464524768 10809020416 1529127200 15.729 100 88 176 0 1565722032 9529040 27065792
14:01:34 11786 8192000000 10513745984 10861977600 1559451024 15.991 100 76 151 1 1592122544 9481488 23190032
14:01:53 16790 8192000000 10538602048 10894340096 1595157808 16.298 100 80 160 0 1629491632 10255616 24078208
14:02:20 17954 8192000000 10565471504 10924306432 1622631216 16.532 100 86 172 1 1659669392 11222976 25815200
14:02:47 10389 8192000000 10590450720 10953682944 1652399760 16.785 100 79 158 2 1687975488 12209040 23366688
14:03:06 11980 8192000000 10613985504 10979418112 1670827360 16.940 100 78 156 0 1706622400 12473520 23321520
14:03:27 6716 8192000000 10614598592 10983219200 1680860016 17.025 100 78 156 1 1716039568 12373376 22806176
14:03:41 10395 8192000000 10644644080 11011530752 1694201568 17.137 100 78 156 2 1729108896 12204240 22703088
14:03:58 9260 8192000000 10656864592 11028344832 1707582752 17.249 100 77 154 0 1742537152 12965360 21989040
14:04:17 6310 8192000000 10664247088 11038048256 1723874176 17.384 100 72 144 0 1757286368 12970528 20441664
14:04:31 7238 8192000000 10669296336 11049816064 1735813664 17.484 100 73 146 2 1768600144 12542448 20244032
14:04:46 3974 8192000000 10678327904 11059945472 1747947248 17.585 100 77 152 5 1781880800 12151360 21782192
14:04:58 5049 8192000000 10697671152 11078782976 1763610384 17.714 100 78 155 5 1797971120 12237968 22122768
14:05:13 6550 8192000000 10709549248 11095212032 1780351488 17.852 100 79 158 1 1815953008 12563520 23038000
14:05:27 4357 8192000000 10723161056 11105828864 1784465408 17.886 100 84 169 0 1821949632 14272928 23211296
14:05:39 2732 8192000000 10730002512 11112394752 1790455264 17.936 100 83 162 1 1825939600 13365632 22118704
14:05:48 10041 8192000000 10736975168 11122495488 1791161744 17.941 100 74 148 1 1826796416 14666848 20967824
14:06:05 2813 8192000000 10755474704 11138088960 1803685600 18.044 100 86 170 2 1842248208 14541840 24020768
14:06:15 3248 8192000000 10756117920 11142909952 1817758880 18.159 100 80 160 0 1854369056 13899568 22710608
14:06:25 2288 8192000000 10764235648 11151179776 1823557952 18.207 100 86 171 3 1860671056 12897168 24215936
14:06:34 2842 8192000000 10769061680 11160444928 1829671600 18.257 100 86 169 1 1867078592 12830208 24576784
14:06:43 2031 8192000000 10777100336 11166773248 1836621104 18.313 100 87 174 1 1874433728 12729152 25083472
14:06:52 2525 8192000000 10784294672 11174354944 1837739904 18.322 100 71 143 0 1868752432 10619632 20392896
14:07:01 2814 8192000000 10788083792 11177000960 1849729392 18.420 100 86 170 1 1886674080 13229248 23715440
14:07:10 2017 8192000000 10794915392 11183181824 1854724128 18.460 100 89 178 3 1891829024 12253792 24851104
14:07:19 2677 8192000000 10802422848 11187421184 1856811680 18.477 100 87 174 0 1895416864 13773632 24831552
14:07:28 1384 8192000000 10802236784 11188670464 1859346608 18.498 100 91 182 2 1898344160 13761120 25236432
14:07:36 2886 8192000000 10806426976 11193917440 1859526304 18.499 100 91 182 1 1897026128 13116112 24383712
14:07:45 2209 8192000000 10797739120 11194515456 1863125168 18.529 100 76 152 0 1897822864 13292528 21405168
14:07:54 1980 8192000000 10804602096 11197009920 1863378000 18.531 100 83 164 4 1898199456 12442912 22378544
14:08:03 10324 8192000000 10788782656 11190624256 1861363296 18.514 100 57 114 0 1888477888 11336624 15777968
14:08:19 7171 8192000000 10797488672 11200983040 1869773824 18.582 100 80 162 0 1904024720 11505040 22745856
14:08:40 1331 8192000000 10815405264 11206901760 1872921664 18.608 100 94 188 3 1912523520 12279456 27322400
14:08:48 28501 8192000000 10792986848 11200331776 1866730336 18.558 100 43 85 1 1885070688 6423456 11916896
14:09:24 6289 8192000000 10774984736 11196559360 1863068736 18.528 100 22 41 1 1875374464 6222256 6083472
14:09:37 6848 8192000000 10772494192 11200655360 1867085616 18.561 100 28 56 0 1881447536 6995312 7366608
14:09:50 7619 8192000000 10767645456 11203276800 1867588704 18.565 100 30 60 0 1882783856 6728272 8466880
14:10:07 7199 8192000000 10775846224 11201224704 1866182176 18.553 100 19 36 3 1877784880 6479984 5122720
14:10:22 6952 8192000000 10774352368 11208482816 1872464960 18.604 100 30 60 1 1888512272 7675472 8371840
14:10:35 10466 8192000000 10776827072 11208003584 1869554656 18.581 100 13 26 0 1879853104 5891392 4407056
14:10:52 8595 8192000000 10786679552 11214761984 1876131920 18.634 100 24 48 1 1889802240 6786784 6883536
14:11:07 13891 8192000000 10777368736 11212472320 1875942336 18.632 100 13 26 1 1887204960 5559504 5703120
14:11:29 8904 8192000000 10794206752 11220987904 1883413376 18.693 100 25 51 1 1897572800 6799840 7359584
14:11:45 14637 8192000000 10788365552 11221614592 1883806240 18.696 100 19 38 1 1895537248 6222560 5508448
14:12:08 7269 8192000000 10802813952 11230883840 1886207024 18.715 100 24 48 1 1898453488 5709584 6536880
14:12:21 13966 8192000000 10795596640 11228385280 1886929024 18.721 100 13 26 1 1896510416 6273808 3307584
14:12:42 63204 8192000000 10822251296 11244888064 1894257984 18.780 100 22 44 1 1906564112 5229456 7076672
14:13:52 11069 8192000000 10799914096 11237494784 1875588112 18.629 99 21 41 1 1887809344 6399488 5821744
14:14:09 8806 8192000000 10819423584 11243511808 1893903856 18.777 100 33 66 1 1910114608 7565936 8644816
14:14:24 7487 8192000000 10813851216 11247239168 1895290672 18.788 100 23 45 1 1908273552 7009008 5973872
14:14:41 6640 8192000000 10812938272 11246878720 1899946512 18.826 100 25 49 1 1913068400 6420832 6701056
14:14:55 6186 8192000000 10810538880 11243515904 1896635760 18.799 100 36 73 1 1914384992 7267248 10481984
14:15:07 4820 8192000000 10818249152 11248275456 1897489296 18.806 100 20 37 3 1908416800 5568208 5359296
14:15:22 3730 8192000000 10827049936 11256537088 1903611360 18.855 100 30 60 1 1918840016 6813568 8415088
14:15:34 11627 8192000000 10810689584 11253202944 1901771712 18.841 100 12 24 0 1910457104 5483712 3201680
14:15:54 9003 8192000000 10818456848 11259445248 1904045344 18.859 100 21 42 3 1920146032 10327264 5773424
14:16:10 7638 8192000000 10789364208 11226423296 1865212064 18.546 98 17 32 2 1875606544 6044080 4350400
14:16:24 17482 8192000000 10794419328 11235012608 1848820304 18.413 97 16 31 1 1858476096 5153056 4502736
14:16:47 10324 8192000000 10778760928 11203850240 1801411200 18.025 95 14 29 0 1809872880 4685712 3775968
14:17:04 63314 8192000000 10750175936 11154669568 1699480400 17.181 91 26 48 1 1711064896 5047024 6537472
14:18:13 16395 8192000000 10735392784 11165245440 1754099232 17.636 95 15 30 0 1768067120 10149200 3818688
14:18:36 7107 8192000000 10752647024 11180625920 1820124048 18.179 99 25 50 3 1840335504 13794080 6417376
14:18:51 4924 8192000000 10749469904 11157757952 1763926560 17.717 96 31 62 3 1778526496 5804544 8795392
14:19:02 7981 8192000000 10742965200 11166740480 1824960416 18.218 100 23 46 2 1838824784 6982176 6882192
14:19:18 10150 8192000000 10742081152 11156242432 1773529616 17.796 97 26 52 0 1786771584 6046512 7195456
14:19:37 8050 8192000000 10682171872 11098652672 1728751280 17.425 97 37 74 3 1747051280 7612640 10687360
14:19:53 7339 8192000000 10707464240 11123372032 1776749264 17.823 99 27 54 0 1790542784 5086496 8707024
14:20:10 7176 8192000000 10668507088 11081019392 1737956624 17.502 99 26 52 0 1752031200 6756000 7318576
14:20:31 8611 8192000000 10702238032 11114754048 1783705712 17.880 100 33 66 1 1799329248 5656720 9966816
14:20:46 7721 8192000000 10704472672 11116969984 1785472176 17.895 100 32 63 1 1800940336 5231216 10236944
14:21:00 4899 8192000000 10709984192 11120492544 1751870192 17.617 97 42 84 2 1770831392 6486704 12474496
14:21:11 13528 8192000000 10701356096 11129806848 1763910464 17.717 98 15 29 1 1773469360 4959840 4599056
14:21:31 69967 8192000000 10727883312 11151106048 1809090272 18.088 100 24 48 0 1822067696 5688128 7289296
14:22:47 13519 8192000000 10734749184 11158212608 1824663232 18.216 100 23 43 2 1837137136 6472752 6001152
14:23:07 4762 8192000000 10749197568 11176259584 1825845152 18.225 100 19 38 2 1840610608 9668336 5097120
14:23:19 10192 8192000000 10740842176 11167846400 1836928784 18.316 100 25 50 1 1849296992 5320048 7048160
14:23:36 7604 8192000000 10750907472 11176828928 1837394064 18.320 100 23 46 2 1849679360 5971152 6314144
14:23:51 7678 8192000000 10759215616 11183075328 1843804176 18.372 100 32 64 0 1859824208 6940160 9079872
14:24:06 6440 8192000000 10752241136 11185152000 1847365584 18.401 100 27 54 2 1862162848 5957936 8839328
14:24:19 10832 8192000000 10764740112 11192369152 1851706608 18.436 100 24 46 1 1864600112 6182416 6711088
14:24:38 7301 8192000000 10764673104 11193188352 1852940960 18.446 100 19 38 2 1865045840 6026448 6078432
14:24:52 10469 8192000000 10769618032 11194019840 1854277168 18.457 100 15 29 1 1864309888 5684720 4348000
14:25:09 12232 8192000000 10774671568 11198631936 1860053008 18.504 100 30 60 0 1874586592 5255632 9277952
14:25:27 6110 8192000000 10784606832 11206004736 1858528208 18.491 100 19 36 2 1873264128 9839248 4896672
14:25:45 11194 8192000000 10773634160 11203461120 1862245328 18.521 100 20 41 1 1873106096 5517792 5342976
14:26:05 10634 8192000000 10773653472 11205062656 1863416048 18.531 100 14 28 1 1872391104 5382752 3592304
14:26:21 70188 8192000000 10777059728 11211902976 1848352800 18.409 99 29 58 1 1865932496 8946176 8633520
14:27:47 5102 8192000000 10817981360 11242307584 1892774736 18.768 100 43 87 1 1911654992 6622480 12257776
14:28:02 29046 8192000000 10832942672 11254607872 1900337888 18.829 100 47 95 3 1921700480 7820416 13542176
14:28:40 2920 8192000000 10841491216 11264069632 1912088752 18.923 100 47 92 1 1933946032 8599376 13257904
14:28:52 10958 8192000000 10844670224 11267063808 1915664384 18.952 100 47 94 1 1938258624 8617040 13977200
14:29:14 19900 8192000000 10858442128 11279974400 1927064128 19.043 100 46 92 1 1948613344 8562304 12986912
14:29:43 14407 8192000000 10865776496 11289350144 1933111840 19.092 100 52 104 0 1958584992 10607904 14865248
14:30:05 33916 8192000000 10878376592 11307765760 1943079184 19.171 100 52 104 5 1970729904 12793136 14857584
14:31:03 24133 8192000000 10873221280 11305582592 1944656288 19.184 100 33 66 0 1966470688 12282240 9532160
14:31:43 9802 8192000000 10893755568 11321319424 1954641664 19.263 100 51 98 3 1984245360 14127440 15476256
14:32:01 26768 8192000000 10899744736 11335213056 1964294416 19.340 100 47 94 1 1996176768 18109968 13772384
14:32:39 32256 8192000000 10909752496 11348668416 1970593824 19.390 100 33 66 0 1999437200 18864560 9978816
14:33:21 14022 8192000000 10919683968 11356377088 1979306528 19.459 100 52 103 1 2015531440 20794416 15430496
14:33:42 15834 8192000000 10926128800 11355283456 1975992560 19.433 100 52 104 3 2013520416 21819280 15708576
14:34:05 5507 8192000000 10917068000 11355693056 1977709120 19.447 100 46 94 1 2013578848 21828512 14041216
14:34:17 2317 8192000000 10936878432 11357720576 1981933296 19.480 100 55 109 0 2020385088 22457440 15994352
14:34:31 3220 8192000000 10936667600 11360985088 1983267872 19.491 100 56 112 2 2022075216 23244576 15562768
14:34:41 4624 8192000000 10934561440 11359571968 1979244096 19.459 100 77 152 0 2026989232 25167200 22577936
14:34:56 18091 8192000000 10928523840 11360395264 1978736144 19.455 100 59 118 0 2023225088 26753712 17735232
14:35:33 13066 8192000000 10925224512 11351990272 1968623392 19.375 100 61 121 1 2014479552 27022560 18833600
14:35:58 12365 8192000000 10930179984 11360555008 1975603904 19.430 100 46 91 1 2016827216 26662336 14560976
14:36:18 4675 8192000000 10947335136 11372707840 1983449376 19.492 100 59 113 1 2028531104 27988272 17093456
14:36:42 7949 8192000000 10916959008 11338850304 1943193040 19.172 98 72 140 1 1989337136 25515216 20628880
14:37:00 6775 8192000000 10936521184 11353100288 1970404224 19.389 100 57 113 4 2012610752 26167296 16039232
14:37:16 4345 8192000000 10934557568 11364118528 1983279408 19.491 100 72 142 1 2031330160 27871424 20179328
14:37:32 9602 8192000000 10927113264 11359870976 1960759088 19.312 99 57 114 2 2005575552 27668672 17147792
14:37:50 9177 8192000000 10935152368 11358392320 1979173792 19.458 100 66 132 3 2025051904 26187744 19690368
14:38:06 2087 8192000000 10946085488 11359297536 1944116720 19.180 98 87 173 1 2001409520 30952560 26340240
14:38:15 9669 8192000000 10935199776 11360956416 1970886592 19.392 100 66 132 0 2024364816 33141552 20336672
14:38:33 3331 8192000000 10957052768 11375792128 1982754064 19.486 100 72 143 1 2040507440 35797216 21956160
14:38:47 7739 8192000000 10928673680 11359305728 1969966768 19.385 100 64 126 0 2020052128 31209040 18876320
14:39:05 7311 8192000000 10946455600 11372937216 1959733008 19.304 99 64 125 1 2012815136 33944224 19137904
14:39:19 4336 8192000000 10947067168 11365191680 1959647184 19.303 99 71 142 2 2017739120 35825728 22266208
14:39:30 5804 8192000000 10935528384 11357233152 1938747808 19.137 98 71 138 3 1996340224 36446544 21145872
14:39:47 9322 8192000000 10947316928 11373694976 1977308880 19.443 100 65 129 1 2036934992 40188704 19437408
14:40:03 4687 8192000000 10949817888 11367735296 1974823488 19.424 100 73 145 1 2037141536 39746960 22571088
14:40:16 7591 8192000000 10955343472 11380645888 1983899456 19.496 100 63 126 1 2042391312 38447472 20044384
14:40:41 5863 8192000000 10949180000 11370766336 1959332256 19.301 99 69 137 0 2023117792 42710048 21075488
14:40:59 4136 8192000000 10953234432 11374465024 1963590896 19.335 99 70 140 1 2030105296 44918784 21595616
14:41:18 5691 8192000000 10967417952 11389030400 1985999136 19.512 100 70 139 2 2053823712 45126928 22697648
14:41:32 3587 8192000000 10958871904 11383181312 1981675536 19.478 100 62 120 0 2045975872 45237664 19062672
14:41:44 3025 8192000000 10945824752 11359768576 1951126912 19.235 99 87 171 0 2024154336 46364528 26662896
14:41:54 1789 8192000000 10954256864 11365625856 1965047008 19.346 100 84 167 2 2038502128 47515760 25939360
14:42:04 4271 8192000000 10965561504 11376074752 1970125200 19.386 100 79 156 2 2044605856 49838592 24642064
14:42:16 16050 8192000000 10955976016 11373871104 1967770032 19.368 100 74 146 1 2040629248 50745552 22113664
14:42:46 7617 8192000000 10973624384 11395514368 1976410880 19.436 100 69 138 0 2055090720 56376240 22303600
14:43:01 2368 8192000000 10963820512 11373674496 1963209920 19.332 99 77 152 0 2044018288 57138928 23669440
14:43:10 4711 8192000000 10954164128 11368337408 1950269504 19.229 99 73 146 0 2031247584 57905680 23072400
14:43:26 2655 8192000000 10987340336 11397726208 1979653728 19.462 100 82 164 3 2066140944 60201376 26285840
14:43:36 5160 8192000000 10964920224 11381432320 1951178208 19.236 99 78 154 0 2039801520 63917680 24705632
14:43:50 4688 8192000000 10962026576 11379740672 1963862784 19.337 100 78 152 0 2046822368 59052368 23907216
14:44:05 4524 8192000000 10951196480 11373916160 1951763712 19.241 100 71 142 1 2037168032 61759904 23644416
14:44:19 7092 8192000000 10948812912 11370086400 1960969760 19.314 100 64 126 1 2039345008 57179920 21195328
14:44:37 1614 8192000000 10960919504 11370487808 1953673600 19.256 99 76 154 1 2032343296 54296208 24373488
14:44:48 10974 8192000000 10965849168 11382554624 1972687248 19.407 100 81 161 1 2055431824 57583488 25161088
14:45:10 3161 8192000000 10962078848 11377647616 1967035760 19.362 100 74 148 1 2046628832 55301904 24291168
14:45:19 9852 8192000000 10960071088 11379613696 1968158944 19.371 100 73 146 1 2046863920 55221872 23483104
14:45:37 2722 8192000000 10968058304 11380342784 1968633424 19.375 100 85 171 1 2051619024 55793952 27191648
14:45:47 830 8192000000 10958965904 11363835904 1953159984 19.252 99 90 177 0 2036892224 56763456 26968784
14:45:54 2848 8192000000 10977557120 11387277312 1973176800 19.411 100 85 169 1 2058370208 58394144 26799264
14:46:04 6131 8192000000 10971134368 11394043904 1973935024 19.417 100 67 133 0 2054683552 59384816 21363712
14:46:19 6461 8192000000 10960578400 11398852608 1975075728 19.426 100 48 96 0 2048492848 57503936 15913184
14:46:32 13471 8192000000 10940585728 11374653440 1935521696 19.111 98 47 94 2 2007161312 55828944 15810672
14:46:52 6294 8192000000 10945575648 11381014528 1960345664 19.309 100 45 90 1 2031825568 56016608 15463296
14:47:12 6886 8192000000 10921501552 11378147328 1951788400 19.241 100 31 62 1 2010718096 48337952 10591744
14:47:26 17765 8192000000 10924920448 11372097536 1961770384 19.320 100 40 80 2 2020916736 46470896 12675456
14:47:55 34770 8192000000 10916028880 11365617664 1905223184 18.868 97 28 56 2 1959841984 45236688 9382112
14:48:46 19687 8192000000 10915458544 11363696640 1944063536 19.179 100 26 52 1 2001771104 48638160 9069408
14:49:13 32566 8192000000 10905060720 11356803072 1919300560 18.981 99 26 52 1 1978520944 49980912 9239472
14:49:52 12136 8192000000 10924496336 11370835968 1931489296 19.079 100 27 54 1 1994922928 53381600 10052032
14:50:11 3119 8192000000 10931649488 11369402368 1945883136 19.194 100 44 88 0 2013207792 52213632 15111024
14:50:28 16464 8192000000 10930608784 11382730752 1943687984 19.176 100 31 62 0 2015588560 60385712 11514864
14:50:55 33995 8192000000 10909064336 11375906816 1926263904 19.037 99 22 44 1 1987934832 53796304 7874624
14:51:37 32331 8192000000 10894547296 11370397696 1942144976 19.164 100 14 27 3 1985607408 38504944 4957488
14:52:16 40030 8192000000 10859122352 11315396608 1845535648 18.386 95 15 30 2 1866007216 15733296 4738272
14:53:02 47720 8192000000 10855112608 11321208832 1909003120 18.899 99 6 11 0 1929865088 19126528 1735440
14:53:58 41412 8192000000 10845755840 11296841728 1831516096 18.272 95 12 24 2 1850105824 15432304 3157424
14:54:58 56701 8192000000 10844126592 11297845248 1858554032 18.492 97 26 52 0 1885982832 19636320 7792480
14:56:09 54018 8192000000 10879680640 11315724288 1908352320 18.893 99 23 47 2 1932194672 16994496 6847856
14:57:16 101772 8192000000 10866008384 11318738944 1887280208 18.724 98 22 44 4 1913676944 19927824 6468912
14:59:22 49905 8192000000 10869619024 11323543552 1873682128 18.614 96 9 18 2 1888410896 12747056 1981712
15:00:19 85723 8192000000 10899116288 11345682432 1912691152 18.928 98 13 26 1 1929319392 13215216 3413024
15:01:51 145335 8192000000 10907933552 11367546880 1954802480 19.265 99 24 48 0 1979313648 17293520 7217648
15:04:23 126702 8192000000 10927972272 11379396608 1959333408 19.301 99 38 75 2 1983294624 12319808 11641408
15:06:37 33791 8192000000 10912220464 11373002752 1964727360 19.344 99 37 74 0 1994466768 18731984 11007424
15:07:34 67398 8192000000 10906569136 11373842432 1964029904 19.338 99 24 48 1 1980281840 9218224 7033712
15:09:14 9956 8192000000 10929185360 11381026816 1994568608 19.580 100 51 102 3 2017214512 8109664 14536240
15:09:32 46378 8192000000 10905835952 11370983424 1945977936 19.194 98 21 42 2 1960985456 9144176 5863344
15:10:30 23064 8192000000 10943709024 11385098240 1971214736 19.395 99 29 58 0 1990678240 10625248 8838256
15:11:05 31927 8192000000 10938142800 11391750144 1973691168 19.415 99 39 78 2 2002987840 18872128 10424544
15:12:03 58134 8192000000 10897876304 11377176576 1939967120 19.146 98 12 24 0 1967485744 24232528 3286096
15:13:26 38624 8192000000 10900084336 11379302400 1977514864 19.445 100 17 34 2 1994919840 13333344 4071632
15:14:11 20715 8192000000 10918321600 11390332928 1979913120 19.464 100 18 36 0 2002974880 18856752 4205008
15:14:49 25249 8192000000 10906389952 11387461632 1983889808 19.495 100 11 22 0 2001351920 14595312 2866800
15:15:28 107315 8192000000 10912885968 11394330624 1993232752 19.569 100 10 19 2 2005954640 10335776 2386112
15:17:53 61812 8192000000 10921588896 11397230592 2002518384 19.643 100 21 42 0 2017993616 9720016 5755216
15:19:53 61075 8192000000 10911342480 11395567616 1995010432 19.583 100 16 32 0 2007018272 7988112 4019728
15:21:13 64131 8192000000 10904294400 11375386624 1896948816 18.802 95 4 8 0 1904543840 6834544 760480
15:22:27 72186 8192000000 10875040016 11343069184 1823686384 18.208 92 21 42 1 1842739472 13420320 5632768
15:23:46 27703 8192000000 10883784560 11363934208 1941996944 19.163 99 31 63 2 1963766624 12155696 9613984
15:24:21 44241 8192000000 10867518464 11348180992 1900172368 18.828 97 11 22 0 1919235584 15973584 3089632
15:25:17 49660 8192000000 10861560384 11324612608 1860995168 18.511 95 29 56 1 1883997760 14778928 8223664
15:26:14 52912 8192000000 10825978096 11288879104 1858249280 18.489 96 18 36 1 1879581168 15981792 5350096
15:27:15 30822 8192000000 10857678224 11321278464 1901870672 18.841 98 31 62 2 1919302320 8379792 9051856
15:27:53 38357 8192000000 10863454112 11324342272 1865656672 18.549 96 23 46 0 1884054400 11710832 6686896
15:28:51 56010 8192000000 10837482032 11293962240 1796872240 17.988 93 14 28 1 1811332768 10999824 3460704
15:29:56 60910 8192000000 10863666816 11342016512 1911675424 18.920 99 19 38 3 1937484912 20832208 4977280
15:31:12 19944 8192000000 10868554448 11322814464 1875530112 18.629 96 20 40 1 1887347792 6590720 5226960
15:31:43 32155 8192000000 10885482848 11335708672 1909712240 18.904 98 35 70 0 1931277552 11892128 9673184
15:32:28 40626 8192000000 10886911792 11348140032 1925784640 19.033 99 35 70 0 1952797104 17113248 9899216
15:34:39 44899 8192000000 10880903072 11319590912 1862812592 18.526 96 27 53 1 1885715728 15174288 7728848
15:35:41 85025 8192000000 10817420576 11278901248 1883118816 18.690 98 38 78 0 1907103968 13209808 10775344
15:37:12 77652 8192000000 10864120016 11308527616 1848975520 18.414 96 36 72 1 1868141152 8145248 11020384
15:39:02 57632 8192000000 10830654608 11306405888 1912144528 18.924 100 28 56 2 1933987856 13613024 8230304
15:40:10 42516 8192000000 10814913280 11292479488 1873147520 18.610 98 9 18 0 1885911136 10152784 2610832
15:40:59 59116 8192000000 10840095312 11317248000 1897993488 18.810 99 13 26 0 1914407184 12304928 4108768
15:42:08 82909 8192000000 10849649952 11324125184 1925771520 19.033 100 20 40 0 1945569792 13434512 6363760
15:43:44 80647 8192000000 10850231296 11345223680 1888078080 18.730 98 8 16 0 1907271280 16931424 2261776
15:45:11 47592 8192000000 10858366160 11325480960 1901696992 18.840 98 14 28 0 1919383760 13749664 3937104
15:46:11 80683 8192000000 10878580720 11342536704 1917290848 18.965 99 17 34 0 1933577712 11091680 5195184
15:47:55 57397 8192000000 10852249136 11320455168 1909594560 18.903 99 14 28 2 1930875728 16472944 4808224
15:49:03 38829 8192000000 10865509568 11326320640 1911256528 18.917 99 34 68 0 1934342192 13365392 9720272
15:49:53 46548 8192000000 10886672528 11353436160 1942076688 19.163 100 16 32 0 1960790896 14078016 4636192
15:50:56 54733 8192000000 10866788368 11342741504 1928418224 19.054 99 13 26 0 1948337264 16083744 3835296
15:51:57 54492 8192000000 10888096560 11348770816 1917671344 18.968 98 22 44 0 1934073136 10707200 5694592
15:53:07 73030 8192000000 10905399856 11356585984 1936282192 19.117 99 22 43 2 1958878016 15666640 6929184
15:54:29 51941 8192000000 10887848816 11360055296 1950306208 19.229 100 17 31 3 1968861296 13994800 4560288
15:55:34 36105 8192000000 10910389776 11352666112 1918467904 18.975 98 15 30 0 1936361904 13363680 4530320
15:56:18 91026 8192000000 10905851072 11371331584 1969631440 19.383 100 45 89 2 1994562752 13286720 11644592
15:58:13 75316 8192000000 10909926128 11371835392 1959627440 19.303 99 28 56 0 1975299328 7984672 7687216
15:59:34 54080 8192000000 10901440496 11383402496 1977605920 19.446 100 11 22 1 1988085296 7106240 3373136
16:00:35 45505 8192000000 10891383168 11375034368 1959611488 19.303 99 6 12 0 1971022848 9641632 1769728
16:01:26 35162 8192000000 10897131568 11373858816 1979854272 19.464 100 18 36 0 1992740480 7206656 5679552
16:02:07 42639 8192000000 10887274992 11371716608 1973085136 19.410 100 11 22 0 1983375040 7173328 3116576
16:02:58 61907 8192000000 10900642256 11385012224 1976263376 19.435 100 2 4 0 1984597952 7920384 414192
16:04:10 65867 8192000000 10901031936 11379216384 1947540752 19.207 98 11 22 1 1961496208 10718576 3236880
16:05:24 25641 8192000000 10902038720 11375591424 1973840816 19.416 100 26 52 1 1993942848 12369664 7732368
16:06:05 40933 8192000000 10903075440 11370389504 1941471744 19.158 98 18 36 0 1958286832 11226816 5588272
16:07:00 88221 8192000000 10878518352 11352354816 1877518752 18.645 95 20 40 1 1899093680 14957424 6617504
16:08:38 52792 8192000000 10882571920 11358642176 1911000864 18.915 97 17 34 1 1926724640 10996240 4727536
16:09:37 69328 8192000000 10871283152 11335544832 1850486496 18.426 94 26 50 0 1869847968 12161552 7199920
16:10:53 77478 8192000000 10861132064 11336568832 1881878464 18.680 96 17 34 0 1897112320 11060960 4172896
16:12:25 55797 8192000000 10894092592 11362086912 1954567712 19.263 100 25 48 2 1971782224 9428752 7785760
16:13:29 54524 8192000000 10892334496 11360698368 1909543632 18.903 97 29 58 2 1927905984 10560896 7801456
16:14:32 21190 8192000000 10916343728 11376517120 1969816960 19.384 100 23 46 1 1986000560 9629232 6554368
16:15:02 61499 8192000000 10893691840 11349762048 1906099808 18.875 97 21 42 0 1921148448 9453184 5595456
16:16:10 33196 8192000000 10898469568 11369672704 1944932832 19.186 99 32 64 1 1970622000 17022032 8667136
16:16:50 141915 8192000000 10858568944 11327467520 1875531984 18.629 96 27 53 1 1893119216 9725968 7861264
16:19:18 54413 8192000000 10849004592 11329609728 1896090144 18.795 98 10 20 0 1907246224 8145312 3010768
16:20:19 45158 8192000000 10844629312 11318202368 1918742192 18.977 99 7 14 0 1927204384 6528208 1933984
16:21:14 48758 8192000000 10826580032 11302084608 1861900368 18.519 96 8 15 0 1869901216 6016704 1984144
16:22:10 27423 8192000000 10839429936 11319447552 1909712416 18.904 99 4 8 1 1917435888 6786128 937344
16:22:43 24812 8192000000 10827862896 11293237248 1843124624 18.366 96 18 36 1 1854903648 6883920 4895104
16:23:14 48264 8192000000 10847986736 11307114496 1880623712 18.670 98 24 48 0 1894736992 7134128 6979152
16:24:10 60690 8192000000 10822544080 11297501184 1842225168 18.359 96 22 45 1 1857498976 9033184 6240624
16:25:37 48375 8192000000 10846733616 11316801536 1920620736 18.992 100 26 52 1 1941353936 13110176 7623024
16:26:35 35773 8192000000 9802175712 10162450432 920716096 10.103 48 10 20 0 931419616 8103360 2600160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 30-11-2020 16:28:26 to 30-11-2020 16:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 132 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-11-2020 16:28:57 to 30-11-2020 16:28:59.

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          247011
MON$OLDEST_ACTIVE               247290
MON$OLDEST_SNAPSHOT             247290
MON$NEXT_TRANSACTION            247290
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                       2036704
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:128: 
:129: mscs-test-161.budzdorov.ru    Mon Nov 30 16:27:14 2020
:130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131: 
:132: 
:133: mscs-test-161.budzdorov.ru    Mon Nov 30 16:27:15 2020
:134:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:135: 
:136: 
:137: mscs-test-161.budzdorov.ru    Mon Nov 30 16:27:17 2020
:138:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139: 
:140: 
:141: mscs-test-161.budzdorov.ru    Mon Nov 30 16:27:25 2020
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
--- end of diff output ---

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

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