Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.02.2021 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 17027072 kB
MemAvailable 31227320 kB
Buffers 0 kB
Cached 14651768 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-02 22:27:13
DTS_END                         2021-02-02 22:27:13.4550
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/34572
TRN_ID                          248307
ATT_ID                          683
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: 9449.49 18472 1133939
customer order: creation 182.09 326 21851
customer order: refuse 15.68 339 1882
order to supplier: creation 47.96 1188 5755
order to supplier: removal 3.37 89555 404
invoice (draft): creation 48.47 3033 5816
invoice (draft): removal 52.46 683 6295
invoice accept: apply 44.31 16619 5317
invoice accept: cancel 47.75 803 5730
customer reserve: creation 4042.58 166 485109
customer reserve: removal 4649.18 51 557902
realization accept: apply 87.53 191 10504
realization accept: cancel 90.99 109 10919
payment from customer: creation 63.18 110 7582
payment from customer: removal 6.19 70 743
payment to supplier: creation 51.47 126 6176
payment to supplier: removal 3.63 81 436
service: total inventory turnovers 4.98 1154 598
service: total monetary turnovers 6.91 48 829
service: aggregate perf. data 0.73 22574 87
service: refresh index statistics 0.03 232209 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 02-02-2021 22:28:02 to 02-02-2021 22:28:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5413
TEST_TIME 2 4867
TEST_TIME 3 4392
TEST_TIME 4 4598
TEST_TIME 5 4056
TEST_TIME 6 4918
TEST_TIME 7 4601
TEST_TIME 8 4800
TEST_TIME 9 4888
TEST_TIME 10 5707
TEST_TIME 11 5667
TEST_TIME 12 5880
TEST_TIME 13 5986
TEST_TIME 14 6654
TEST_TIME 15 7237
TEST_TIME 16 7578
TEST_TIME 17 7610
TEST_TIME 18 7861
TEST_TIME 19 7953
TEST_TIME 20 8647
TEST_TIME 21 8597
TEST_TIME 22 8966
TEST_TIME 23 9302
TEST_TIME 24 9510
TEST_TIME 25 9847
TEST_TIME 26 9765
TEST_TIME 27 9636
TEST_TIME 28 10209
TEST_TIME 29 10318
TEST_TIME 30 10337
TEST_TIME 31 10143
TEST_TIME 32 10158
TEST_TIME 33 10063
TEST_TIME 34 10208
TEST_TIME 35 10238
TEST_TIME 36 10156
TEST_TIME 37 10149
TEST_TIME 38 10289
TEST_TIME 39 10261
TEST_TIME 40 10264
TEST_TIME 41 10139
TEST_TIME 42 10213
TEST_TIME 43 10162
TEST_TIME 44 10168
TEST_TIME 45 10061
TEST_TIME 46 9972
TEST_TIME 47 9955
TEST_TIME 48 9910
TEST_TIME 49 9861
TEST_TIME 50 10019
TEST_TIME 51 9968
TEST_TIME 52 9940
TEST_TIME 53 9891
TEST_TIME 54 9826
TEST_TIME 55 9780
TEST_TIME 56 9781
TEST_TIME 57 9690
TEST_TIME 58 9701
TEST_TIME 59 9817
TEST_TIME 60 9793
TEST_TIME 61 9767
TEST_TIME 62 9828
TEST_TIME 63 9818
TEST_TIME 64 9837
TEST_TIME 65 9853
TEST_TIME 66 9945
TEST_TIME 67 9989
TEST_TIME 68 9952
TEST_TIME 69 9976
TEST_TIME 70 9962
TEST_TIME 71 9946
TEST_TIME 72 9966
TEST_TIME 73 9997
TEST_TIME 74 9881
TEST_TIME 75 9892
TEST_TIME 76 9895
TEST_TIME 77 9813
TEST_TIME 78 9800
TEST_TIME 79 9769
TEST_TIME 80 9785
TEST_TIME 81 9719
TEST_TIME 82 9732
TEST_TIME 83 9644
TEST_TIME 84 9690
TEST_TIME 85 9676
TEST_TIME 86 9726
TEST_TIME 87 9709
TEST_TIME 88 9724
TEST_TIME 89 9720
TEST_TIME 90 9674
TEST_TIME 91 9739
TEST_TIME 92 9753
TEST_TIME 93 9816
TEST_TIME 94 9832
TEST_TIME 95 9854
TEST_TIME 96 9822
TEST_TIME 97 9827
TEST_TIME 98 9856
TEST_TIME 99 9869
TEST_TIME 100 9795
TEST_TIME 101 9774
TEST_TIME 102 9747
TEST_TIME 103 9699
TEST_TIME 104 9662
TEST_TIME 105 9632
TEST_TIME 106 9602
TEST_TIME 107 9550
TEST_TIME 108 9506
TEST_TIME 109 9549
TEST_TIME 110 9511
TEST_TIME 111 9460
TEST_TIME 112 9441
TEST_TIME 113 9424
TEST_TIME 114 9435
TEST_TIME 115 9424
TEST_TIME 116 9490
TEST_TIME 117 9470
TEST_TIME 118 9436
TEST_TIME 119 9526
TEST_TIME 120 9455

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-02-2021 22:28:06 to 02-02-2021 22:28:09.

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 1582651 1582651 0 0.00 0 22351 6 0 0
doc_list_biud 1582651 1582651 0 0.00 0 51075 23 0 0
sp_add_invoice_to_stock 5449 5317 132 2.42 33 164283 16620 0 132
sp_cancel_adding_invoice 5730 5730 0 0.00 4 59048 804 0 0
sp_cancel_client_order 1882 1882 0 0.00 5 8786 340 0 0
sp_cancel_customer_reserve 557902 557902 0 0.00 1 27876 51 0 0
sp_cancel_pay_from_customer 743 743 0 0.00 3 7575 71 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 3 6308 81 0 0
sp_cancel_supplier_invoice 6306 6295 11 0.17 1 35858 683 0 11
sp_cancel_supplier_order 404 404 0 0.00 9 983591 89556 0 0
sp_cancel_write_off 10919 10919 0 0.00 1 21945 109 0 0
sp_client_order 21851 21851 0 0.00 4 17417 327 0 0
sp_customer_reserve 485109 485109 0 0.00 0 48331 167 0 0
sp_fill_shopping_cart 33410 33410 0 0.00 1 18157 37 0 0
sp_fill_shopping_cart_clo_res 485097 485097 0 0.00 0 13056 13 0 0
sp_get_clo_for_invoice 5305 5305 0 0.00 0 38811 280 0 0
sp_kill_cost_storno 17828 17828 0 0.00 0 8829 54 0 0
sp_kill_qstorno_ret_qs2qd 1133422 1133422 0 0.00 0 35739 28 0 0
sp_kill_qty_storno 598941 598941 0 0.00 0 51073 61 0 0
sp_lock_selected_doc 21984 21984 0 0.00 0 10165 6 0 0
sp_make_cost_storno 29567 29567 0 0.00 0 22338 55 0 0
sp_multiply_rows_for_pdistr 29567 29567 0 0.00 0 9035 29 0 0
sp_multiply_rows_for_qdistr 21851 21851 0 0.00 0 9503 154 0 0
sp_pay_from_customer 7582 7582 0 0.00 4 17800 111 0 0
sp_pay_to_supplier 6176 6176 0 0.00 4 12117 126 0 0
sp_payment_common 13758 13758 0 0.00 1 17796 35 0 0
sp_qd_handle_on_cancel_clo 1882 1882 0 0.00 0 8781 305 0 0
sp_qd_handle_on_invoice_upd_sts 11035 11035 0 0.00 0 51069 309 0 0
sp_qd_handle_on_reserve_upd_sts 10504 10504 0 0.00 0 29509 65 0 0
sp_reserve_write_off 10504 10504 0 0.00 6 29528 191 0 0
sp_supplier_invoice 5816 5816 0 0.00 6 109311 3034 0 0
sp_supplier_order 5755 5755 0 0.00 6 21245 1189 0 0
srv_aggregate_perf_data 87 87 0 0.00 2266 184616 22574 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1325 129161 33952 0 0
srv_find_qd_qs_mism 1083339 1083339 0 0.00 0 14999 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 41 99372 1154 0 0
srv_make_money_saldo 829 829 0 0.00 1 13524 49 0 0
srv_recalc_idx_stat 4 4 0 0.00 150204 354674 232209 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 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5317 5317 0 0.00 0 13967 142 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 1 7625 98 0 0
t$perf-norm:sp_cancel_client_order 1882 1882 0 0.00 0 3243 12 0 0
t$perf-norm:sp_cancel_customer_reserve 751 751 0 0.00 0 706 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 743 743 0 0.00 0 2863 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 3612 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 487 11 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 34454 1614 0 0
t$perf-norm:sp_cancel_write_off 1080 1080 0 0.00 0 1170 4 0 0
t$perf-norm:sp_client_order 21851 21851 0 0.00 0 6796 15 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 790 5 0 0
t$perf-norm:sp_pay_from_customer 7582 7582 0 0.00 0 7450 9 0 0
t$perf-norm:sp_pay_to_supplier 6176 6176 0 0.00 0 6317 10 0 0
t$perf-norm:sp_reserve_write_off 10504 10504 0 0.00 0 5202 8 0 0
t$perf-norm:sp_supplier_invoice 5816 5816 0 0.00 0 13881 17 0 0
t$perf-norm:sp_supplier_order 5755 5755 0 0.00 0 8366 16 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 132 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 414 6 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 2177 16 0 0
t$perf-norm:srv_make_money_saldo 829 829 0 0.00 0 1034 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 5 0 0
v_add_invoice_to_stock 10874 10610 264 2.42 0 10240 20 0 264
v_all_customers 39910 39910 0 0.00 0 23 1 0 0
v_all_suppliers 32102 32102 0 0.00 0 21 1 0 0
v_all_wares 43702 43702 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 1550 11 0 0
v_cancel_client_order 3764 3764 0 0.00 0 6414 6 0 0
v_cancel_customer_prepayment 1486 1486 0 0.00 0 2721 4 0 0
v_cancel_customer_reserve 1502 1502 0 0.00 0 2497 8 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 189 3 0 0
v_cancel_supplier_invoice 892 870 22 2.46 0 2294 18 0 22
v_cancel_supplier_order 808 808 0 0.00 0 1024 7 0 0
v_cancel_write_off 2160 2160 0 0.00 0 5924 15 0 0
v_max_id_clo_ord 5755 5755 0 0.00 0 910 2 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 2591 12 0 0
v_max_id_ord_sup 5804 5804 0 0.00 0 4468 3 0 0
v_max_non_paid_invoice 1684 1684 0 0.00 0 359 2 0 0
v_max_non_paid_realizn 4016 4016 0 0.00 0 748 3 0 0
v_min_id_clo_ord 5755 5755 0 0.00 0 2091 5 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 8000 12 0 0
v_min_id_ord_sup 5804 5804 0 0.00 0 7776 8 0 0
v_min_non_paid_invoice 6176 6176 0 0.00 0 9162 25 0 0
v_min_non_paid_realizn 7582 7582 0 0.00 0 8768 24 0 0
v_our_firm 10924 10924 0 0.00 0 20 1 0 0
v_reserve_write_off 21008 21008 0 0.00 0 6808 7 0 0
x_lock_depdocs_on_canc_invoice 11590 11590 0 0.00 0 16722 94 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 9766 325 0 0
x_make_qstorno_1000_1200 5755 5755 0 0.00 1 21238 1111 0 0
x_make_qstorno_1200_2000 5816 5816 0 0.00 3 101150 2899 0 0
x_make_qstorno_2100_3300 485109 485109 0 0.00 0 42245 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-02-2021 22:28:10 to 02-02-2021 22:28:14.

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:17 4 8192000000 8800931696 8812138496 6918096 0.084 2 1 2 0 7037472 56816 62560
19:57:23 16385 8192000000 10237105472 10551275520 1082945088 11.676 84 62 125 0 1106845600 2857104 21043408
19:57:49 38185 8192000000 10367671504 10688696320 1397838320 14.576 100 85 170 0 1431070896 5173680 28058896
19:58:36 25343 8192000000 10392325648 10719510528 1444691792 14.991 100 91 182 0 1481696416 7185696 29818928
19:59:20 17885 8192000000 10426489552 10757730304 1477577056 15.280 100 93 184 1 1515956208 8344608 30034544
19:59:48 30880 8192000000 10468107504 10801590272 1506539488 15.533 100 86 172 1 1542889344 9028816 27321040
20:00:27 19033 8192000000 10478056128 10815557632 1537984288 15.806 100 91 182 1 1577083920 9965344 29134288
20:00:55 21311 8192000000 10501530960 10839863296 1550119408 15.911 100 93 186 1 1589319664 10551648 28648608
20:01:26 18475 8192000000 10506954320 10852069376 1563686464 16.028 100 87 174 0 1601606720 10989888 26930368
20:01:55 13799 8192000000 10523888480 10874503168 1580365264 16.171 100 80 160 0 1615802704 11439488 23997952
20:02:17 17894 8192000000 10552828736 10905808896 1602875728 16.364 100 80 160 0 1638003440 11543744 23583968
20:02:44 15975 8192000000 10576835440 10931642368 1630210400 16.597 100 87 174 1 1668677824 12781664 25685760
20:03:09 11577 8192000000 10581391184 10939891712 1647250944 16.741 100 83 164 4 1683942000 13038496 23652560
20:03:28 13831 8192000000 10600362928 10962796544 1654265968 16.800 100 76 152 0 1689351840 12694160 22391712
20:03:51 8873 8192000000 10611932368 10975608832 1667882480 16.915 100 79 158 3 1704845968 13360960 23602528
20:04:10 9429 8192000000 10625897840 10997067776 1683789600 17.049 100 74 146 1 1717249616 11506816 21953200
20:04:29 9816 8192000000 10641128288 11013197824 1707945776 17.252 100 78 155 1 1742672928 11967184 22759968
20:04:49 7040 8192000000 10656003296 11028701184 1717820832 17.334 100 77 154 0 1752867008 12737456 22308720
20:05:04 5820 8192000000 10664715360 11039420416 1729376864 17.430 100 80 159 1 1765788624 13481456 22930304
20:05:18 3528 8192000000 10674048480 11050954752 1738920832 17.510 100 85 170 1 1777476592 13975152 24580608
20:05:31 4534 8192000000 10684929856 11062517760 1747509424 17.581 100 73 146 1 1781418848 13852112 20057312
20:05:42 5288 8192000000 10704845840 11079614464 1761143200 17.694 100 80 159 1 1797202416 14356560 21702656
20:05:56 10553 8192000000 10704172384 11083845632 1764758032 17.724 100 81 161 1 1802030704 14858592 22414080
20:06:16 3649 8192000000 10732158944 11111051264 1785020352 17.891 100 81 162 0 1822717056 14523472 23173232
20:06:26 3152 8192000000 10749516576 11127009280 1804014320 18.047 100 84 169 1 1841381008 14107376 23259312
20:06:36 3578 8192000000 10739058688 11126812672 1811268544 18.106 100 77 155 1 1845885072 12448528 22168000
20:06:46 2943 8192000000 10752633616 11140378624 1816166176 18.146 100 81 160 2 1852718896 13477872 23074848
20:06:55 3176 8192000000 10765727488 11148890112 1821170384 18.187 100 82 163 0 1855584832 12296576 22117872
20:07:05 2370 8192000000 10770399568 11154374656 1825860720 18.226 100 86 171 1 1863419648 13367296 24191632
20:07:15 2359 8192000000 10779698864 11165696000 1837206528 18.318 100 88 177 0 1875195904 12815904 25173472
20:07:23 2238 8192000000 10782818080 11168096256 1842728608 18.363 100 89 181 4 1880795088 12820000 25246480
20:07:32 1629 8192000000 10783550464 11171479552 1845847488 18.388 100 94 189 3 1885356112 12628160 26880464
20:07:40 1448 8192000000 10787514016 11175002112 1849264752 18.416 100 88 176 2 1886357904 12199808 24893344
20:07:48 2622 8192000000 10785836784 11175530496 1851178096 18.432 100 87 174 0 1888396336 13332480 23885760
20:07:57 6387 8192000000 10794363536 11184300032 1854094608 18.455 100 85 169 2 1891286272 12869568 24322096
20:08:10 1972 8192000000 10808812272 11194638336 1861394336 18.515 100 91 182 0 1900917600 13737152 25786112
20:08:19 2264 8192000000 10792410880 11186958336 1861341552 18.514 100 89 176 1 1899707600 13567472 24798576
20:08:28 5370 8192000000 10786223168 11192643584 1858381216 18.490 100 81 163 1 1894176640 13209424 22586000
20:08:49 16967 8192000000 10791284272 11190493184 1855762672 18.469 100 67 134 6 1882786784 7598544 19425568
20:09:12 3411 8192000000 10775946064 11186941952 1856092736 18.472 100 56 113 1 1882199760 10629600 15477424
20:09:23 2815 8192000000 10778554512 11191635968 1857706944 18.485 100 52 105 2 1880687968 8604992 14376032
20:09:33 6935 8192000000 10777111072 11197743104 1860853968 18.510 100 35 70 0 1879491344 8542256 10095120
20:09:53 4128 8192000000 10783301296 11197202432 1862971360 18.527 100 36 72 2 1879863136 7459824 9431952
20:10:04 4864 8192000000 10781598032 11199320064 1863547088 18.532 100 33 65 1 1880992192 7830448 9614656
20:10:16 8035 8192000000 10775993296 11202117632 1866069440 18.552 100 25 49 2 1880012448 6807504 7135504
20:10:31 10745 8192000000 10773979280 11203964928 1869145072 18.577 100 23 46 1 1882752400 7299376 6307952
20:10:53 6427 8192000000 10782186752 11211591680 1872367408 18.603 100 21 42 0 1885600944 6820128 6413408
20:11:05 12378 8192000000 10783031552 11214258176 1875783424 18.631 100 16 32 0 1885970000 5989184 4197392
20:11:24 66119 8192000000 10799669952 11229360128 1883695504 18.695 100 27 55 1 1897699104 5635456 8368144
20:12:37 13873 8192000000 10803326624 11233660928 1891123968 18.755 100 40 81 2 1908506576 5457808 11924800
20:12:59 4941 8192000000 10806197136 11231993856 1889034080 18.738 100 32 64 0 1909171408 11425136 8712192
20:13:14 3964 8192000000 10822228544 11239460864 1895002256 18.786 100 42 83 6 1914008096 6658000 12347840
20:13:25 8557 8192000000 10811809424 11238973440 1895190416 18.788 100 35 69 2 1912493152 7170832 10131904
20:13:42 4684 8192000000 10814034896 11241017344 1898412480 18.814 100 30 60 1 1917507920 11106816 7988624
20:13:54 9102 8192000000 10804370176 11240349696 1897938160 18.810 100 21 42 1 1909259472 5618784 5702528
20:14:09 7491 8192000000 10813451568 11244314624 1898727808 18.816 100 26 53 0 1911306416 5319264 7259344
20:14:23 11351 8192000000 10813608048 11249684480 1902710800 18.848 100 23 46 0 1915380928 5748224 6921904
20:14:44 8822 8192000000 10828046976 11254505472 1905565488 18.871 100 19 36 4 1916191744 5430768 5195488
20:14:59 5787 8192000000 10825469472 11259604992 1911246352 18.917 100 35 70 1 1927964768 6828480 9889936
20:15:12 10323 8192000000 10820263312 11255701504 1908439024 18.894 100 19 36 1 1919535216 4773456 6322736
20:15:29 8551 8192000000 10821719968 11256197120 1909679264 18.904 100 26 52 1 1922974784 4994192 8301328
20:15:44 6976 8192000000 10822794592 11254435840 1892582816 18.767 99 26 52 1 1910353392 9755664 8014912
20:15:59 53257 8192000000 10849996608 11250692096 1887807728 18.728 99 60 120 1 1911522832 5582592 18132512
20:16:59 8214 8192000000 10811656368 11246592000 1902589440 18.847 100 23 44 2 1914760032 6275760 5894832
20:17:16 6311 8192000000 10812624144 11250692096 1903511360 18.855 100 27 54 1 1917876736 7152768 7212608
20:17:28 6102 8192000000 10825400128 11259088896 1910000192 18.907 100 22 44 1 1922271280 5646784 6624304
20:17:41 5502 8192000000 10798666784 11235024896 1866621328 18.557 98 28 56 1 1880793088 6426112 7745648
20:17:53 4878 8192000000 10789152896 11218087936 1833120848 18.285 97 21 42 1 1845424032 6176720 6126464
20:18:07 4581 8192000000 10766807856 11191435264 1826701504 18.232 97 33 64 1 1846019920 10511680 8806736
20:18:19 4489 8192000000 10772633104 11197739008 1832484624 18.280 98 17 34 2 1842407248 5514784 4407840
20:18:35 4401 8192000000 10780442192 11205300224 1816312160 18.148 97 26 50 2 1829337408 5553488 7471760
20:18:47 11769 8192000000 10740297776 11165601792 1728960656 17.427 93 13 26 0 1737913872 4985104 3968112
20:19:07 9632 8192000000 10730265088 11147501568 1706312672 17.238 93 24 48 1 1718884560 5999024 6572864
20:19:27 11922 8192000000 10690726304 11100450816 1679564176 17.014 93 25 49 1 1692168768 5413888 7190704
20:19:47 9786 8192000000 10676821968 11094503424 1697882464 17.167 95 18 36 2 1708454544 5276704 5295376
20:20:03 61649 8192000000 10653580608 11065282560 1660218720 16.851 93 27 54 0 1673664240 5100944 8344576
20:21:12 11104 8192000000 10694236272 11096952832 1703642048 17.216 96 16 32 1 1717655264 9854112 4159104
20:21:31 6776 8192000000 10694794112 11098558464 1730055360 17.436 97 33 67 0 1746602528 7179616 9367552
20:21:44 2616 8192000000 10713040496 11117879296 1771857424 17.782 99 55 110 1 1796553072 8458352 16237296
20:21:55 5305 8192000000 10715910400 11106418688 1751230736 17.612 98 36 72 3 1767366944 5512464 10623744
20:22:09 4632 8192000000 10710188448 11119390720 1782568992 17.871 100 32 64 1 1798009440 6043200 9397248
20:22:20 5440 8192000000 10710921616 11120660480 1792009648 17.948 100 33 66 1 1807551232 6051632 9489952
20:22:32 12322 8192000000 10728966048 11148533760 1805787920 18.061 100 20 38 0 1816645904 5134880 5723104
20:22:51 7462 8192000000 10732237904 11148886016 1800934144 18.022 99 26 52 1 1814226400 6141456 7150800
20:23:06 6523 8192000000 10750322160 11161669632 1821021184 18.186 100 34 68 3 1836715456 4954416 10739856
20:23:20 9038 8192000000 10748851728 11166703616 1828226864 18.245 100 34 68 1 1843745936 4889456 10629616
20:23:39 8641 8192000000 10762828000 11183169536 1837651504 18.322 100 28 57 0 1851945488 5632288 8661696
20:23:54 7188 8192000000 10768549696 11190243328 1843930704 18.373 100 27 53 2 1861470288 9677760 7861824
20:24:14 13706 8192000000 10782795664 11203403776 1853833696 18.453 100 19 38 0 1864687344 4786640 6067008
20:24:35 68551 8192000000 10760128480 11196743680 1857995744 18.487 100 26 52 1 1871058544 5990240 7072560
20:25:49 8305 8192000000 10783693520 11208650752 1859939424 18.503 100 23 46 0 1876553536 10162192 6451920
20:26:04 7767 8192000000 10773607424 11202469888 1862821872 18.526 100 26 53 0 1877545152 6057824 8665456
20:26:20 5253 8192000000 10788192000 11213946880 1865412512 18.547 100 42 83 1 1888784768 12208976 11163280
20:26:31 5358 8192000000 10781793632 11208253440 1868236160 18.570 100 44 90 2 1887448832 6722768 12489904
20:26:46 5660 8192000000 10783159040 11208802304 1867185888 18.561 100 27 53 0 1885255040 9728496 8340656
20:27:00 8814 8192000000 10795628512 11221557248 1875181232 18.626 100 27 51 3 1887808912 5145792 7481888
20:27:17 7390 8192000000 10806489312 11228848128 1887927872 18.729 100 26 52 2 1901452160 5738048 7786240
20:27:31 10170 8192000000 10825826800 11244965888 1898469280 18.814 100 42 85 0 1917174960 6678640 12027040
20:28:22 49238 8192000000 10834785680 11267432448 1915101872 18.948 100 31 60 2 1933173920 9277536 8794512
20:29:18 8736 8192000000 10850309104 11272343552 1919947488 18.986 100 36 72 0 1939799200 9401264 10450448
20:29:36 13897 8192000000 10852782832 11279269888 1924767424 19.025 100 36 70 1 1945891456 10531824 10592208
20:29:58 16601 8192000000 10855299424 11288006656 1931481312 19.079 100 47 92 2 1956341952 11081424 13779216
20:30:22 17251 8192000000 10862158272 11295956992 1940896128 19.154 100 43 84 0 1965627648 12486368 12245152
20:30:51 21552 8192000000 10882024736 11309731840 1943603856 19.176 100 48 97 2 1973440832 15356016 14480960
20:31:25 90433 8192000000 10885867648 11325734912 1945693104 19.192 100 40 78 0 1975122320 17173056 12256160
20:34:05 40866 8192000000 10913320256 11344146432 1959773568 19.304 100 25 48 0 1985373232 17908656 7691008
20:35:22 4565 8192000000 10927606080 11357609984 1968511152 19.374 99 64 126 1 2008638720 21808016 18319552
20:35:34 15140 8192000000 10928920544 11358560256 1976345712 19.436 100 54 109 1 2017724672 25199632 16179328
20:35:58 16593 8192000000 10946386992 11373654016 1979869232 19.464 100 55 109 2 2023279872 26893392 16517248
20:36:28 7436 8192000000 10944611216 11373387776 1987975008 19.528 100 58 116 3 2033400880 28532144 16893728
20:36:42 7934 8192000000 10950803280 11380662272 1994075296 19.576 100 56 112 1 2039299248 28541344 16682608
20:36:59 5009 8192000000 10955114480 11386101760 1996376928 19.594 100 55 106 0 2042519920 30008880 16134112
20:37:14 4264 8192000000 10947273472 11385098240 1995024608 19.583 100 53 103 3 2041037712 29837200 16175904
20:37:27 2863 8192000000 10976458448 11396599808 2006139072 19.671 100 77 153 0 2059456784 31145728 22171984
20:37:37 2306 8192000000 10971878000 11396313088 1990618048 19.549 99 90 180 1 2049700224 32496016 26586160
20:37:46 2626 8192000000 10974534544 11403976704 2011914272 19.717 100 81 162 1 2069158304 33058160 24185872
20:37:56 6852 8192000000 10967293744 11400024064 2008376816 19.689 100 63 126 2 2060686896 33118304 19191776
20:38:13 18367 8192000000 10955123824 11399421952 2006248784 19.672 100 50 100 0 2050050048 28334064 15467200
20:38:41 5214 8192000000 10963577104 11394531328 1992310240 19.562 99 61 123 0 2038783136 27550848 18922048
20:39:04 5747 8192000000 10953941248 11385606144 1993381088 19.571 100 61 122 0 2042057520 30092512 18583920
20:39:19 3217 8192000000 10972683520 11398479872 2002986800 19.646 100 66 131 2 2052850608 29405664 20458144
20:39:30 5777 8192000000 10976070832 11398758400 2007878080 19.685 100 71 142 2 2059103536 29536000 21689456
20:39:43 2516 8192000000 10955283552 11375497216 1965298048 19.348 99 83 164 1 2023543024 33431296 24813680
20:39:53 2587 8192000000 10967595920 11381276672 1992052928 19.560 100 90 179 0 2053301408 34424912 26823568
20:40:02 4068 8192000000 10964986704 11383099392 1986448848 19.516 100 84 167 0 2047188736 35517744 25222144
20:40:13 5947 8192000000 10938082256 11358216192 1964724256 19.344 100 74 148 1 2023892096 36691456 22476384
20:40:27 3086 8192000000 10945852000 11367493632 1975168592 19.426 100 79 157 0 2036063488 36845520 24049376
20:40:37 13188 8192000000 10946433968 11378569216 1978378784 19.452 100 68 136 0 2037950080 38653296 20918000
20:41:01 3292 8192000000 10963096208 11383586816 1971907872 19.401 99 83 162 2 2036839840 39570880 25361088
20:41:13 3562 8192000000 10936545488 11360210944 1949148656 19.220 99 75 149 1 2013813088 41564112 23100320
20:41:24 1324 8192000000 10955816304 11365314560 1969119408 19.378 100 88 174 2 2036009776 39619696 27270672
20:41:32 2880 8192000000 10949354736 11365261312 1963708400 19.336 100 84 166 2 2031854048 41570624 26575024
20:41:42 4322 8192000000 10940660912 11356729344 1952624144 19.247 99 82 161 3 2017062208 39885136 24552928
20:41:57 2169 8192000000 10941952960 11351318528 1945307296 19.189 99 86 164 1 2008802688 39624880 23870512
20:42:06 2767 8192000000 10950880640 11367956480 1972458720 19.405 100 87 173 1 2033839152 35830256 25550176
20:42:15 3013 8192000000 10949728480 11362975744 1966633696 19.359 100 77 155 0 2026626912 36662112 23331104
20:42:25 6461 8192000000 10943108784 11360636928 1971073760 19.394 100 75 150 0 2032281600 38671552 22536288
20:42:39 1844 8192000000 10953542592 11364237312 1969842432 19.384 100 85 166 0 2032794080 37771728 25179920
20:42:48 2429 8192000000 10946191760 11369435136 1971391264 19.396 100 78 154 3 2031042368 36919968 22731136
20:42:59 4204 8192000000 10946951744 11367178240 1959017280 19.298 99 77 151 1 2016133088 35703360 21412448
20:43:10 2181 8192000000 10944649632 11368554496 1941824976 19.161 98 85 169 2 2008141248 40996656 25319616
20:43:20 2517 8192000000 10944593312 11365113856 1974476064 19.421 100 91 181 0 2037746592 35377072 27893456
20:43:33 10999 8192000000 10949821184 11370151936 1972079888 19.402 100 66 128 0 2025407312 34255344 19072080
20:43:52 4027 8192000000 10945288336 11357425664 1951677264 19.240 99 72 144 1 2011004640 37607360 21720016
20:44:03 7084 8192000000 10912794320 11344220160 1936760624 19.121 99 56 112 1 1990166880 36213040 17193216
20:44:17 7505 8192000000 10903742016 11323981824 1907530256 18.887 98 59 118 0 1962644080 36446480 18667344
20:44:38 3677 8192000000 10921114320 11340935168 1944232848 19.181 100 58 116 2 1999523008 37539824 17750336
20:44:50 4469 8192000000 10925418928 11348135936 1949148848 19.220 100 70 140 2 2009444320 38567632 21727840
20:45:04 5220 8192000000 10934168544 11346649088 1948476320 19.214 100 77 150 1 2012751552 40262720 24012512
20:45:16 12576 8192000000 10917493440 11339960320 1935501200 19.111 99 66 131 1 1998117520 42061472 20554848
20:45:36 7870 8192000000 10901309440 11333742592 1910244576 18.909 98 52 104 2 1966223648 39357696 16621376
20:45:53 3936 8192000000 10905052192 11331497984 1930133840 19.068 100 53 106 3 1986930480 39402320 17394320
20:46:04 8739 8192000000 10882584496 11316412416 1918328768 18.973 99 42 85 1 1972855232 40207888 14318576
20:46:31 12525 8192000000 10892363760 11328561152 1902340128 18.845 98 47 94 2 1958646160 41362688 14943344
20:46:51 9919 8192000000 10890362768 11324383232 1906789520 18.881 99 42 84 1 1964293648 43050832 14453296
20:47:11 16285 8192000000 10905194912 11336757248 1910636736 18.912 99 37 74 3 1965963888 42079728 13247424
20:47:34 5241 8192000000 10896650208 11336544256 1926836848 19.042 99 48 96 1 1990193984 48144960 15212176
20:47:49 7813 8192000000 10900174064 11333120000 1921499488 18.999 99 46 92 0 1971903248 35965824 14437936
20:48:08 4951 8192000000 10892719888 11320840192 1917218144 18.965 99 45 88 2 1963438224 32033792 14186288
20:48:22 11284 8192000000 10876319088 11303718912 1884913552 18.705 98 37 73 0 1927042352 30473008 11655792
20:48:41 7434 8192000000 10885154384 11318521856 1922381952 19.006 100 41 81 3 1969767472 34344880 13040640
20:49:08 10601 8192000000 10888879552 11329105920 1922781840 19.009 100 31 62 1 1973990576 40132752 11075984
20:49:35 13870 8192000000 10886433680 11331993600 1910655344 18.912 99 34 68 1 1964633632 42431808 11546480
20:50:03 27682 8192000000 10861197200 11309637632 1872019792 18.601 98 25 50 1 1918750464 38327248 8403424
20:50:39 12829 8192000000 10862436496 11306708992 1889004208 18.738 100 21 42 0 1938265744 42056320 7205216
20:51:18 14133 8192000000 10853311488 11307618304 1905081568 18.867 100 24 49 0 1945801344 32734592 7985184
20:51:40 21032 8192000000 10881957072 11319779328 1905585808 18.871 99 38 76 0 1943608272 26991264 11031200
20:52:10 30858 8192000000 10848404064 11299651584 1875368704 18.628 98 16 32 0 1907808768 26803376 5636688
20:52:51 26742 8192000000 10856760448 11312836608 1907399184 18.886 100 14 28 1 1937487184 25324560 4763440
20:53:35 38711 8192000000 10845877312 11291770880 1873034320 18.609 98 21 41 0 1904007408 24391072 6582016
20:54:21 20009 8192000000 10863454576 11307876352 1910238336 18.909 100 21 42 1 1943149248 26041312 6869600
20:54:49 10702 8192000000 10861363712 11310735360 1895101056 18.787 99 12 24 1 1927910064 28492224 4316784
20:55:07 36328 8192000000 10834556400 11298713600 1874300960 18.619 98 14 28 1 1896874352 18237168 4336224
20:55:49 37852 8192000000 10840089344 11293736960 1883052432 18.690 99 9 18 2 1898062208 12626112 2383664
20:56:36 68866 8192000000 10842482512 11300528128 1837929312 18.324 96 9 18 0 1854869632 14869488 2070832
20:57:52 80787 8192000000 10850771072 11301183488 1884274992 18.700 98 20 41 0 1906333296 16827824 5230480
20:59:19 55988 8192000000 10861506192 11312836608 1916112144 18.956 99 13 26 1 1933635536 14097072 3426320
21:00:22 82887 8192000000 10874004736 11341537280 1923780048 19.017 99 9 18 0 1934771280 8712512 2278720
21:02:03 101552 8192000000 10885619456 11339354112 1928866448 19.058 99 11 22 0 1944795136 12779680 3149008
21:04:10 92770 8192000000 10916984624 11368181760 1949604016 19.223 99 14 28 1 1974184464 20563200 4017248
21:05:52 100070 8192000000 10906993312 11370070016 1971058256 19.394 100 18 36 0 1994870592 18893568 4918768
21:07:39 124102 8192000000 10908058128 11364478976 1918830080 18.977 97 30 60 3 1942952240 14926752 9195408
21:09:58 38056 8192000000 10917480496 11355025408 1964885440 19.345 100 34 68 1 1981274032 7108688 9279904
21:10:42 59418 8192000000 10936033456 11384352768 1984569312 19.501 100 42 84 1 2009381536 13255456 11556768
21:11:56 37318 8192000000 10924050080 11393339392 1992825456 19.566 100 41 82 0 2018780304 14074752 11880096
21:12:43 55434 8192000000 10924073840 11394539520 1970819504 19.392 99 21 42 1 1989275440 12970544 5485392
21:13:51 21622 8192000000 10914460496 11379494912 1954099536 19.259 98 37 74 1 1974030032 9105776 10824720
21:14:28 27641 8192000000 10921861920 11391733760 1991733088 19.557 100 22 44 3 2007963232 9873376 6356768
21:15:07 23442 8192000000 10931558384 11397226496 2000278272 19.625 100 24 47 1 2017986176 10173200 7534704
21:15:36 20290 8192000000 10920510032 11392614400 1965280224 19.348 98 26 52 0 1982052288 9474752 7297312
21:16:04 46146 8192000000 10934011536 11396218880 1972840240 19.408 99 31 62 2 1995252976 13463392 8949344
21:17:14 45470 8192000000 10908838896 11401461760 1967612240 19.367 99 11 22 1 1988252416 17492496 3147680
21:18:34 50296 8192000000 10915598800 11390046208 1970119152 19.386 99 15 28 3 1990715616 16527120 4069344
21:19:37 28992 8192000000 10923049744 11410604032 1995775040 19.589 100 8 16 0 2011764944 13936704 2053200
21:21:18 62247 8192000000 10889000400 11360698368 1924430272 19.022 97 17 34 0 1940358960 11377568 4551120
21:22:28 48688 8192000000 10874039968 11348099072 1936873680 19.122 98 23 46 2 1954103040 10896592 6332768
21:23:25 25027 8192000000 10875410336 11353174016 1924730688 19.025 98 9 18 1 1938859680 11812800 2316192
21:23:56 26863 8192000000 10872343120 11346501632 1927365088 19.046 98 6 12 0 1938027632 8989584 1672960
21:24:49 37243 8192000000 10907068896 11377311744 1931351968 19.078 98 13 26 2 1943770128 9070096 3348064
21:25:56 85151 8192000000 10852798784 11336306688 1820504016 18.182 93 10 20 1 1834821408 11316672 3000720
21:27:27 29906 8192000000 10866727760 11325075456 1894647264 18.783 97 36 69 1 1910738992 6847600 9244128
21:28:12 19888 8192000000 10899502992 11353137152 1938388016 19.134 99 40 81 2 1958003680 8553200 11062464
21:28:51 40553 8192000000 10883887088 11343548416 1885220608 18.707 96 21 42 1 1901994912 11005312 5768992
21:29:40 62601 8192000000 10866838784 11325988864 1886984576 18.721 97 22 44 1 1904354800 10945248 6424976
21:30:52 36568 8192000000 10903503728 11356475392 1935348912 19.110 99 25 50 2 1953113216 10138128 7626176
21:31:34 33039 8192000000 10889170736 11348320256 1930518336 19.071 99 29 58 0 1952312640 13621200 8173104
21:32:14 39793 8192000000 10878738688 11354853376 1926264880 19.037 99 16 32 0 1940570912 9703184 4602848
21:33:04 71336 8192000000 10876662848 11356663808 1889067424 18.738 97 11 22 1 1905704176 13788336 2848416
21:34:21 112121 8192000000 10831534560 11303194624 1718101248 17.336 89 12 24 1 1734909616 13356112 3452256
21:36:27 54862 8192000000 10873811024 11324559360 1912941200 18.930 99 32 64 0 1933911680 11664704 9305776
21:37:30 74039 8192000000 10864203584 11318362112 1872999024 18.609 97 22 44 0 1887591808 8976544 5616240
21:38:54 30241 8192000000 10864205504 11329245184 1927790112 19.049 100 27 54 1 1952009984 16416976 7802896
21:39:36 69924 8192000000 10862904480 11327447040 1865628016 18.549 97 15 30 1 1894995760 25253024 4114720
21:40:52 93503 8192000000 10847640496 11312320512 1901713008 18.840 99 31 62 0 1922872160 12521920 8637232
21:42:33 93727 8192000000 10834132944 11300753408 1870286608 18.587 97 23 46 1 1885598288 9182192 6129488
21:44:13 23577 8192000000 10879688128 11321405440 1931545216 19.079 100 54 109 4 1956217888 8723344 15949328
21:44:43 19593 8192000000 10904411776 11339575296 1940645936 19.152 100 60 118 1 1971448080 13749680 17052464
21:45:11 41080 8192000000 10869131168 11340689408 1922373840 19.006 99 30 60 1 1943471264 12572608 8524816
21:46:00 56633 8192000000 10884341328 11358380032 1947489296 19.206 100 13 25 0 1965788384 14671168 3627920
21:47:03 54369 8192000000 10874509120 11354812416 1914517600 18.943 98 9 18 1 1930074880 12806976 2750304
21:48:08 40689 8192000000 10878983360 11347984384 1933452752 19.094 99 15 31 1 1948690800 10928736 4309312
21:48:55 92854 8192000000 10880904832 11356168192 1935912384 19.114 99 17 34 0 1952687792 11721072 5054336
21:51:13 50982 8192000000 10875939296 11365097472 1950610128 19.231 100 8 16 0 1966336704 13495424 2231152
21:52:10 51288 8192000000 10898618288 11378151424 1972157360 19.403 100 32 62 2 1995214560 13940384 9116816
21:53:13 55373 8192000000 10888233344 11384614912 1949091296 19.219 99 18 36 1 1970231680 15775552 5364832
21:54:21 46957 8192000000 10899033968 11375050752 1969633152 19.383 100 18 36 0 1984512400 9740752 5138496
21:55:16 26869 8192000000 10910879872 11377700864 1977837712 19.448 100 43 85 1 1998188304 8715568 11635024
21:55:53 72650 8192000000 10894450048 11365498880 1938906080 19.138 98 22 44 0 1955968608 11344048 5718480
21:57:13 55040 8192000000 10902906224 11379445760 1936324560 19.117 98 18 36 0 1956086992 14908064 4854368
21:58:24 126319 8192000000 10911127472 11392507904 1943498720 19.175 98 10 20 0 1964914560 18777456 2638384
22:00:37 89082 8192000000 10922969040 11397271552 1964240336 19.340 99 8 16 1 1984876784 18909056 1727392
22:02:12 76738 8192000000 10924959104 11394932736 1950276368 19.229 98 12 24 1 1964242912 11018272 2948272
22:03:39 35812 8192000000 10944712192 11400871936 1974548144 19.422 99 44 88 1 1996789600 10410640 11830816
22:04:21 13374 8192000000 10945013744 11385966592 1957306976 19.285 98 67 132 0 1988845824 12868480 18670368
22:04:43 31133 8192000000 10938815344 11398017024 1981944080 19.480 100 46 90 1 2007486256 12962736 12579440
22:05:22 86735 8192000000 10903285952 11383914496 1908354944 18.893 96 24 48 0 1930988512 16259920 6373648
22:07:10 129161 8192000000 10894223088 11379269632 1959670864 19.303 99 21 42 1 1981098544 15716144 5711536
22:09:26 42753 8192000000 10874855760 11357827072 1949205920 19.220 99 26 52 0 1964635552 8012528 7417104
22:10:19 59564 8192000000 10831259968 11304415232 1856665856 18.476 95 24 48 2 1873793168 11100096 6027216
22:13:06 46916 8192000000 10841120496 11310059520 1860322224 18.506 96 9 18 0 1869054608 6214304 2518080
22:14:07 45283 8192000000 10851532016 11314855936 1871465200 18.596 97 29 58 0 1888293696 8003664 8824832
22:15:21 85670 8192000000 10839734400 11317473280 1869636944 18.581 97 15 30 0 1888791056 14860256 4293856
22:16:54 59427 8192000000 10839085232 11306086400 1866080144 18.553 97 22 44 0 1880158080 7550784 6527152
22:17:59 53489 8192000000 10842435712 11311280128 1905265696 18.869 99 29 58 1 1920061664 7032560 7763408
22:19:26 44792 8192000000 10824730528 11293802496 1846310560 18.392 96 20 40 1 1860702864 8895504 5496800
22:20:17 56159 8192000000 10828506192 11304292352 1842832064 18.364 96 19 38 0 1863082768 14803472 5447232
22:21:22 34267 8192000000 10850904784 11316862976 1893335408 18.773 99 22 44 1 1907071872 7886096 5850368
22:22:12 54902 8192000000 10844766000 11321917440 1867070160 18.561 97 24 48 1 1886091008 12213904 6806944
22:23:13 75094 8192000000 10865176864 11333472256 1902686192 18.848 99 14 27 1 1928904336 21953904 4264240
22:24:34 30950 8192000000 10867151312 11326357504 1857943568 18.487 96 36 70 1 1882117280 14284320 9889392
22:25:15 63727 8192000000 10846868816 11322482688 1869388416 18.579 97 31 62 1 1897844272 19125760 9330096
22:26:35 41137 8192000000 9426831072 9718759424 567989088 6.483 30 11 21 0 578374160 7720864 2664208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-02-2021 22:28:16 to 02-02-2021 22:28:47.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-02-2021 22:28:48 to 02-02-2021 22:28:50.

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          247760
MON$OLDEST_ACTIVE               248613
MON$OLDEST_SNAPSHOT             248613
MON$NEXT_TRANSACTION            248613
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                       2038880
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:76: 
:77: mscs-test-161.budzdorov.ru    Tue Feb  2 22:27:18 2021
:78:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:79: 
:80: 
:81: mscs-test-161.budzdorov.ru    Tue Feb  2 22:27:18 2021
:82:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:83: 
:84: 
:85: mscs-test-161.budzdorov.ru    Tue Feb  2 22:27:19 2021
:86:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:87: 
--- end of diff output ---

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

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