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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17222012 kB
MemAvailable 31406092 kB
Buffers 0 kB
Cached 14497080 kB
SwapCached 4864 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-01-10 22:27:09
DTS_END                         2021-01-10 22:27:09.8260
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/52294
TRN_ID                          231673
ATT_ID                          616
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: 9470.44 19210 1136453
customer order: creation 166.86 363 20023
customer order: refuse 13.96 356 1675
order to supplier: creation 43.09 1361 5171
order to supplier: removal 3.48 104868 417
invoice (draft): creation 43.92 3139 5270
invoice (draft): removal 55.45 721 6654
invoice accept: apply 40.28 19783 4833
invoice accept: cancel 50.33 706 6039
customer reserve: creation 3854.74 190 462569
customer reserve: removal 4911.23 59 589348
realization accept: apply 79.84 204 9581
realization accept: cancel 83.16 116 9979
payment from customer: creation 56.98 114 6837
payment from customer: removal 5.63 65 675
payment to supplier: creation 46.99 133 5639
payment to supplier: removal 3.05 55 366
service: total inventory turnovers 4.51 1099 541
service: total monetary turnovers 6.05 38 726
service: aggregate perf. data 0.88 18063 106
service: refresh index statistics 0.03 232771 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-01-2021 22:28:49 to 10-01-2021 22:28:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3310
TEST_TIME 2 4341
TEST_TIME 3 5388
TEST_TIME 4 5838
TEST_TIME 5 5794
TEST_TIME 6 5539
TEST_TIME 7 5525
TEST_TIME 8 5381
TEST_TIME 9 5585
TEST_TIME 10 5490
TEST_TIME 11 5553
TEST_TIME 12 5842
TEST_TIME 13 6111
TEST_TIME 14 6092
TEST_TIME 15 7138
TEST_TIME 16 7151
TEST_TIME 17 7135
TEST_TIME 18 7467
TEST_TIME 19 7657
TEST_TIME 20 7949
TEST_TIME 21 8121
TEST_TIME 22 8044
TEST_TIME 23 8954
TEST_TIME 24 9504
TEST_TIME 25 9747
TEST_TIME 26 9712
TEST_TIME 27 10452
TEST_TIME 28 10521
TEST_TIME 29 10540
TEST_TIME 30 10597
TEST_TIME 31 10480
TEST_TIME 32 10396
TEST_TIME 33 10388
TEST_TIME 34 10400
TEST_TIME 35 10296
TEST_TIME 36 10502
TEST_TIME 37 10405
TEST_TIME 38 10348
TEST_TIME 39 10328
TEST_TIME 40 10083
TEST_TIME 41 10141
TEST_TIME 42 10153
TEST_TIME 43 9989
TEST_TIME 44 9963
TEST_TIME 45 9854
TEST_TIME 46 9802
TEST_TIME 47 9889
TEST_TIME 48 9758
TEST_TIME 49 9939
TEST_TIME 50 9962
TEST_TIME 51 9922
TEST_TIME 52 9795
TEST_TIME 53 9983
TEST_TIME 54 9992
TEST_TIME 55 9976
TEST_TIME 56 10052
TEST_TIME 57 10061
TEST_TIME 58 10026
TEST_TIME 59 10187
TEST_TIME 60 10190
TEST_TIME 61 10258
TEST_TIME 62 10206
TEST_TIME 63 10264
TEST_TIME 64 10289
TEST_TIME 65 10203
TEST_TIME 66 10205
TEST_TIME 67 10102
TEST_TIME 68 10127
TEST_TIME 69 10050
TEST_TIME 70 10042
TEST_TIME 71 10018
TEST_TIME 72 10019
TEST_TIME 73 9949
TEST_TIME 74 9924
TEST_TIME 75 9930
TEST_TIME 76 9885
TEST_TIME 77 9823
TEST_TIME 78 9822
TEST_TIME 79 9797
TEST_TIME 80 9752
TEST_TIME 81 9752
TEST_TIME 82 9836
TEST_TIME 83 9810
TEST_TIME 84 9934
TEST_TIME 85 9906
TEST_TIME 86 9898
TEST_TIME 87 9909
TEST_TIME 88 9923
TEST_TIME 89 9985
TEST_TIME 90 9985
TEST_TIME 91 10015
TEST_TIME 92 9929
TEST_TIME 93 9860
TEST_TIME 94 9875
TEST_TIME 95 9825
TEST_TIME 96 9800
TEST_TIME 97 9766
TEST_TIME 98 9704
TEST_TIME 99 9701
TEST_TIME 100 9705
TEST_TIME 101 9696
TEST_TIME 102 9683
TEST_TIME 103 9649
TEST_TIME 104 9721
TEST_TIME 105 9715
TEST_TIME 106 9732
TEST_TIME 107 9727
TEST_TIME 108 9703
TEST_TIME 109 9778
TEST_TIME 110 9776
TEST_TIME 111 9781
TEST_TIME 112 9771
TEST_TIME 113 9737
TEST_TIME 114 9683
TEST_TIME 115 9667
TEST_TIME 116 9649
TEST_TIME 117 9576
TEST_TIME 118 9567
TEST_TIME 119 9526
TEST_TIME 120 9470

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-01-2021 22:28:52 to 10-01-2021 22:28:56.

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 1563973 1563973 0 0.00 0 24430 6 0 0
doc_list_biud 1563938 1563938 0 0.00 0 71140 28 0 0
sp_add_invoice_to_stock 4985 4833 152 3.04 36 235441 19783 0 152
sp_cancel_adding_invoice 6039 6039 0 0.00 5 79189 707 0 0
sp_cancel_client_order 1675 1675 0 0.00 4 11116 357 0 0
sp_cancel_customer_reserve 589348 589348 0 0.00 1 71142 59 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 3080 65 0 0
sp_cancel_pay_to_supplier 366 366 0 0.00 3 1901 56 0 0
sp_cancel_supplier_invoice 6666 6654 12 0.18 2 17198 722 0 12
sp_cancel_supplier_order 417 417 0 0.00 10 1028595 104868 0 0
sp_cancel_write_off 9979 9979 0 0.00 1 10948 117 0 0
sp_client_order 20023 20023 0 0.00 3 18158 363 0 0
sp_customer_reserve 462569 462569 0 0.00 0 54567 190 0 0
sp_fill_shopping_cart 30458 30458 0 0.00 1 12364 32 0 0
sp_fill_shopping_cart_clo_res 462569 462569 0 0.00 0 17742 13 0 0
sp_get_clo_for_invoice 4833 4833 0 0.00 0 39256 314 0 0
sp_kill_cost_storno 17059 17059 0 0.00 0 6015 50 0 0
sp_kill_qstorno_ret_qs2qd 1195746 1195746 0 0.00 0 71138 32 0 0
sp_kill_qty_storno 628504 628504 0 0.00 0 71140 68 0 0
sp_lock_selected_doc 19969 19969 0 0.00 0 10325 7 0 0
sp_make_cost_storno 26890 26890 0 0.00 0 14670 55 0 0
sp_multiply_rows_for_pdistr 26856 26856 0 0.00 0 8289 27 0 0
sp_multiply_rows_for_qdistr 20023 20023 0 0.00 0 10605 157 0 0
sp_pay_from_customer 6837 6837 0 0.00 4 19867 115 0 0
sp_pay_to_supplier 5639 5639 0 0.00 5 19850 134 0 0
sp_payment_common 12464 12464 0 0.00 1 15240 30 0 0
sp_qd_handle_on_cancel_clo 1675 1675 0 0.00 0 11110 317 0 0
sp_qd_handle_on_invoice_upd_sts 10865 10865 0 0.00 0 22367 309 0 0
sp_qd_handle_on_reserve_upd_sts 9566 9566 0 0.00 0 23250 79 0 0
sp_reserve_write_off 9581 9581 0 0.00 6 23279 204 0 0
sp_supplier_invoice 5270 5270 0 0.00 7 71314 3140 0 0
sp_supplier_order 5171 5171 0 0.00 5 50440 1361 0 0
srv_aggregate_perf_data 106 106 0 0.00 2589 175105 18064 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1249 148546 32832 0 0
srv_find_qd_qs_mism 1089471 1089471 0 0.00 0 24430 6 0 0
srv_make_invnt_saldo 541 541 0 0.00 27 34941 1099 0 0
srv_make_money_saldo 726 726 0 0.00 0 6347 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 197491 287905 232772 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4833 4833 0 0.00 0 17240 176 0 0
t$perf-norm:sp_cancel_adding_invoice 379 379 0 0.00 1 1858 66 0 0
t$perf-norm:sp_cancel_client_order 1675 1675 0 0.00 0 7910 18 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 2818 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 4205 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 366 366 0 0.00 0 1918 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 959 9 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 48204 1840 0 0
t$perf-norm:sp_cancel_write_off 1007 1007 0 0.00 0 1258 5 0 0
t$perf-norm:sp_client_order 20023 20023 0 0.00 0 9972 21 0 0
t$perf-norm:sp_customer_reserve 966 966 0 0.00 0 2884 8 0 0
t$perf-norm:sp_pay_from_customer 6837 6837 0 0.00 0 5944 15 0 0
t$perf-norm:sp_pay_to_supplier 5639 5639 0 0.00 0 8417 15 0 0
t$perf-norm:sp_reserve_write_off 9581 9581 0 0.00 0 9875 19 0 0
t$perf-norm:sp_supplier_invoice 5270 5270 0 0.00 0 7687 27 0 0
t$perf-norm:sp_supplier_order 5171 5171 0 0.00 0 22465 26 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 492 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 751 7 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 859 19 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 2904 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 219 56 0 0
v_add_invoice_to_stock 9954 9650 304 3.05 0 7628 20 0 304
v_all_customers 36680 36680 0 0.00 0 15 1 0 0
v_all_suppliers 29170 29170 0 0.00 0 19 1 0 0
v_all_wares 40046 40046 0 0.00 0 61 1 0 0
v_cancel_adding_invoice 758 758 0 0.00 0 1041 7 0 0
v_cancel_client_order 3350 3350 0 0.00 0 3859 6 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 3063 6 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 2754 6 0 0
v_cancel_payment_to_supplier 732 732 0 0.00 0 832 3 0 0
v_cancel_supplier_invoice 776 752 24 3.09 0 3040 17 0 24
v_cancel_supplier_order 834 834 0 0.00 0 2778 12 0 0
v_cancel_write_off 2014 2014 0 0.00 0 8141 21 0 0
v_max_id_clo_ord 5169 5169 0 0.00 0 742 1 0 0
v_max_id_clo_res 966 966 0 0.00 0 3070 13 0 0
v_max_id_ord_sup 5266 5266 0 0.00 0 2987 3 0 0
v_max_non_paid_invoice 1483 1483 0 0.00 0 3306 5 0 0
v_max_non_paid_realizn 3532 3532 0 0.00 0 4047 5 0 0
v_min_id_clo_ord 5169 5169 0 0.00 0 7135 8 0 0
v_min_id_clo_res 966 966 0 0.00 0 4571 12 0 0
v_min_id_ord_sup 5266 5266 0 0.00 0 4172 6 0 0
v_min_non_paid_invoice 5633 5633 0 0.00 0 11627 16 0 0
v_min_non_paid_realizn 6830 6830 0 0.00 0 6689 12 0 0
v_our_firm 9962 9962 0 0.00 0 115 1 0 0
v_reserve_write_off 19130 19130 0 0.00 0 6723 7 0 0
x_lock_depdocs_on_canc_invoice 12317 12317 0 0.00 0 12742 105 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 8708 328 0 0
x_make_qstorno_1000_1200 5171 5171 0 0.00 1 50430 1289 0 0
x_make_qstorno_1200_2000 5270 5270 0 0.00 4 71295 3029 0 0
x_make_qstorno_2100_3300 462569 462569 0 0.00 0 50355 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-01-2021 22:28:57 to 10-01-2021 22:29:01.

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:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:19 8295 8192000000 10212631680 10515955712 974090272 10.627 78 60 121 1 996254272 2716384 19447616
19:57:36 29409 8192000000 10346747552 10663997440 1402652400 14.619 100 90 181 0 1435817568 5221584 27943584
19:58:20 18164 8192000000 10388032656 10713452544 1432958768 14.887 100 84 168 0 1466536656 6802720 26775168
19:58:49 18305 8192000000 10422002752 10748776448 1472961984 15.240 100 89 176 1 1509286032 7673392 28650656
19:59:18 24800 8192000000 10441315616 10770362368 1489723136 15.386 100 86 172 1 1526261840 8500128 28038576
19:59:52 27573 8192000000 10468001216 10803273728 1517998768 15.633 100 91 182 2 1556166992 9209648 28958576
20:00:33 32194 8192000000 10488474448 10831622144 1542349872 15.844 100 83 166 0 1578225424 10094432 25781120
20:01:15 19407 8192000000 10503980000 10848792576 1558745328 15.985 100 88 176 2 1596885136 10764560 27375248
20:01:48 15644 8192000000 10536044224 10889285632 1592812160 16.278 100 84 168 1 1629614528 11512000 25290368
20:02:12 15461 8192000000 10562341936 10920771584 1621760928 16.525 100 81 162 1 1657602656 11723104 24118624
20:02:37 9812 8192000000 10578804112 10943242240 1635622688 16.643 100 75 150 1 1669765344 11839232 22303424
20:02:56 11893 8192000000 10598145616 10961764352 1657315632 16.826 100 78 154 1 1692932000 12710496 22905872
20:03:21 12198 8192000000 10614342080 10985857024 1674100640 16.968 100 70 140 0 1706736080 12109536 20525904
20:03:40 8789 8192000000 10632083696 11000029184 1694510224 17.139 100 77 153 2 1729101888 12333424 22258240
20:03:56 8345 8192000000 10643728592 11015225344 1706519552 17.240 100 84 169 1 1743300960 12667552 24113856
20:04:12 11477 8192000000 10653844656 11029245952 1718593856 17.340 100 74 146 2 1752482112 12433792 21454464
20:04:31 7555 8192000000 10663875168 11042189312 1731975632 17.452 100 74 148 1 1764881568 11707680 21198256
20:04:47 7303 8192000000 10689030368 11065159680 1746806352 17.575 100 77 154 1 1779683696 10599104 22278240
20:05:01 6396 8192000000 10690360400 11069956096 1758382272 17.671 100 80 157 2 1792676816 11877440 22417104
20:05:17 6404 8192000000 10701063920 11084054528 1768417136 17.754 100 71 142 0 1800175136 11975776 19782224
20:05:32 4864 8192000000 10721135600 11098574848 1780290192 17.852 100 86 170 0 1816529104 12526288 23712624
20:05:44 9515 8192000000 10707477984 11096158208 1780268816 17.852 100 72 144 1 1813237104 13079584 19888704
20:06:02 3284 8192000000 10740860896 11120902144 1788221520 17.917 100 80 160 0 1824137056 13592784 22322752
20:06:13 4156 8192000000 10736966592 11125235712 1801317888 18.025 100 77 152 2 1835723072 13272816 21132368
20:06:24 2574 8192000000 10750894992 11135713280 1810390368 18.099 100 80 162 0 1846758640 13953824 22414448
20:06:33 2750 8192000000 10764146304 11149086720 1819914704 18.177 100 88 177 1 1859739920 14709376 25115840
20:06:43 3196 8192000000 10764470944 11151560704 1825711120 18.224 100 90 180 1 1864798288 14248560 24838608
20:06:53 3825 8192000000 10771594704 11157704704 1828986816 18.251 100 84 168 3 1866700288 13723344 23990128
20:07:04 3367 8192000000 10771623952 11165282304 1836978912 18.316 100 83 163 1 1874754912 13938528 23837472
20:07:14 2566 8192000000 10783024432 11169398784 1844531984 18.378 100 97 194 4 1885286864 14273504 26481376
20:07:23 2953 8192000000 10792829824 11178020864 1851597024 18.435 100 95 188 1 1893825616 15346736 26881856
20:07:33 2486 8192000000 10795415680 11179548672 1850941360 18.430 100 90 179 1 1890627680 14442832 25243488
20:07:42 2441 8192000000 10801442976 11185975296 1853500032 18.451 100 87 174 2 1892123584 14600032 24023520
20:07:51 2171 8192000000 10796351504 11186593792 1856971328 18.479 100 87 174 2 1895442768 14176912 24294528
20:08:00 2105 8192000000 10795132448 11192324096 1857500480 18.483 100 70 140 0 1891679552 13772800 20406272
20:08:09 1622 8192000000 10805084192 11195682816 1864024864 18.536 100 88 174 1 1902700720 13762368 24913488
20:08:17 2253 8192000000 10813921552 11199336448 1868201792 18.570 100 91 184 4 1904901184 11219568 25479824
20:08:26 2401 8192000000 10813234640 11203371008 1873704512 18.614 100 92 185 1 1912443936 12562400 26177024
20:08:35 1960 8192000000 10820370528 11208888320 1874524800 18.621 100 90 182 0 1912622448 12437744 25659904
20:08:44 1639 8192000000 10823216800 11212177408 1874773824 18.623 100 90 180 1 1912287760 12151552 25362384
20:08:52 2219 8192000000 10823744848 11217383424 1880316624 18.668 100 88 177 0 1918523792 12355104 25852064
20:09:00 3479 8192000000 10792430000 11214856192 1877085824 18.642 100 54 108 2 1903991264 12003088 14902352
20:09:11 20212 8192000000 10792589664 11209945088 1875670752 18.630 100 47 94 0 1897680320 7770768 14238800
20:09:37 7386 8192000000 10805858176 11212398592 1874501216 18.621 100 37 75 0 1891587504 6255040 10831248
20:09:52 3947 8192000000 10796541024 11217494016 1876854768 18.640 100 40 78 1 1896113632 7639264 11619600
20:10:06 5741 8192000000 10793446800 11217252352 1880104064 18.666 100 36 73 2 1897878144 6617008 11157072
20:10:18 3656 8192000000 10790897056 11218771968 1883981424 18.697 100 34 67 3 1899809424 6625136 9202864
20:10:31 6466 8192000000 10795848208 11222372352 1884192736 18.699 100 25 50 1 1898941200 7820448 6928016
20:10:43 8173 8192000000 10783675216 11222388736 1882121360 18.682 100 13 24 1 1892088912 6302368 3665184
20:10:58 6198 8192000000 10792011760 11227250688 1890002544 18.746 100 22 44 2 1902967024 6760416 6204064
20:11:12 9514 8192000000 10802747136 11233361920 1892600192 18.767 100 22 44 0 1905078032 6558992 5918848
20:11:27 5434 8192000000 10804959744 11236872192 1894772320 18.784 100 24 47 2 1907987680 6141584 7073776
20:11:39 11168 8192000000 10801339104 11235901440 1895888400 18.793 100 21 43 1 1907799392 5667456 6243536
20:11:59 5519 8192000000 10796792976 11234906112 1895086752 18.787 100 15 30 2 1906101328 7029520 3985056
20:12:11 18052 8192000000 10807206400 11238174720 1905296800 18.869 100 29 59 0 1919957120 6159184 8501136
20:12:36 64379 8192000000 10817176272 11248390144 1897816000 18.809 100 22 44 0 1910274592 6074384 6384208
20:13:49 7794 8192000000 10806752096 11245858816 1897697024 18.808 100 21 42 1 1910746352 6491072 6558256
20:14:04 7673 8192000000 10816623152 11251605504 1899463200 18.822 100 32 61 2 1914114304 6064544 8586560
20:14:26 7595 8192000000 10811553360 11250147328 1901792592 18.841 100 43 85 1 1921096048 6899488 12403968
20:14:41 7991 8192000000 10812171504 11249573888 1899942240 18.826 100 27 56 1 1913388416 5841120 7605056
20:14:58 8828 8192000000 10817698704 11252011008 1901403312 18.838 100 25 50 0 1915013408 6832352 6777744
20:15:17 7447 8192000000 10818149456 11250761728 1900372688 18.829 100 20 40 2 1911625744 6126272 5126784
20:15:34 6585 8192000000 10805957712 11245535232 1885751520 18.712 99 22 44 0 1898529536 7165680 5612336
20:15:53 11280 8192000000 10821088512 11254566912 1900987920 18.834 100 9 18 0 1908384544 4755952 2640672
20:16:12 11773 8192000000 10811217968 11248746496 1882725456 18.687 99 13 26 1 1891069024 5262768 3080800
20:16:30 5177 8192000000 10810203296 11248590848 1897764608 18.808 100 26 51 4 1911452528 5983968 7703952
20:16:43 16321 8192000000 10799698352 11223642112 1827142384 18.236 96 22 41 1 1838642032 5147744 6351904
20:17:06 7905 8192000000 10807060336 11232206848 1871687248 18.598 99 35 70 1 1889005536 7381120 9937168
20:17:23 68012 8192000000 10797232000 11233968128 1839894576 18.340 97 31 62 1 1853531328 4613824 9022928
20:18:37 6012 8192000000 10780144624 11208884224 1825968416 18.226 97 26 52 4 1839429552 5655488 7805648
20:18:51 7671 8192000000 10798547712 11225944064 1875734880 18.631 100 31 60 0 1890499952 6116064 8649008
20:19:07 7238 8192000000 10760247680 11186872320 1767115136 17.743 95 23 46 3 1779013888 5464928 6433824
20:19:22 6057 8192000000 10759747456 11171651584 1803518240 18.043 98 24 50 4 1815929136 5802880 6608016
20:19:36 3974 8192000000 10775593520 11187568640 1846036112 18.390 100 40 80 1 1863732128 6211600 11484416
20:19:47 7416 8192000000 10711525728 11137544192 1748326608 17.588 95 26 52 3 1761382864 4802928 8253328
20:20:05 8754 8192000000 10703784640 11124215808 1726943840 17.410 95 18 36 1 1737963680 5043760 5976080
20:20:24 8393 8192000000 10698463984 11122200576 1722975984 17.377 95 22 44 0 1735381296 5510224 6895088
20:20:38 10501 8192000000 10699309280 11122298880 1765494224 17.730 98 22 45 0 1777263104 5621328 6147552
20:20:59 10446 8192000000 10722945168 11145375744 1771230128 17.777 98 31 62 2 1787117600 6271760 9615712
20:21:18 8211 8192000000 10707101968 11118878720 1734886416 17.476 96 21 41 1 1746717456 5908768 5922272
20:21:35 11965 8192000000 10684622240 11109707776 1732821392 17.459 97 16 32 1 1742300416 5097088 4381936
20:21:54 12820 8192000000 10691900640 11107295232 1729188816 17.429 97 18 36 1 1739976240 5854320 4933104
20:22:13 80015 8192000000 10721012496 11133493248 1709911376 17.268 95 24 50 3 1722020768 5286704 6822688
20:23:45 6238 8192000000 10740986880 11152162816 1811563520 18.109 100 36 72 0 1828759456 7673440 9522496
20:23:59 7795 8192000000 10738853392 11155312640 1816451216 18.149 99 35 70 0 1833363920 6660800 10251904
20:24:15 10349 8192000000 10735170512 11150995456 1811927376 18.112 99 31 62 1 1826883440 6047744 8908320
20:24:31 8074 8192000000 10751491920 11173421056 1829006528 18.251 100 27 54 0 1843235648 5259968 8969152
20:24:46 5089 8192000000 10753398128 11177476096 1838785168 18.331 100 38 76 1 1857265440 6966352 11513920
20:24:58 9507 8192000000 10764538016 11182804992 1841083392 18.350 100 25 50 1 1853469104 5192656 7193056
20:25:15 7581 8192000000 10764017440 11188322304 1845776576 18.388 100 23 46 0 1858469328 6077280 6615472
20:25:32 10392 8192000000 10775234176 11194953728 1851900000 18.438 100 27 54 1 1865381088 5819280 7661808
20:25:50 8455 8192000000 10779009616 11199311872 1853858000 18.453 100 30 59 1 1867638064 4552784 9227280
20:26:05 10459 8192000000 10775256960 11201462272 1853398480 18.450 100 23 45 4 1866830208 5938048 7493680
20:26:25 15061 8192000000 10762245872 11195940864 1854209888 18.456 100 9 18 0 1861573888 4937984 2426016
20:26:46 10647 8192000000 10775825920 11200401408 1859625984 18.500 100 11 22 0 1868126336 5458576 3041776
20:27:03 77094 8192000000 10814757552 11233992704 1879126560 18.658 100 29 58 1 1892224032 5423168 7674304
20:28:27 51383 8192000000 10830000960 11252584448 1900177040 18.828 100 50 98 2 1924188304 9468544 14542720
20:29:28 13039 8192000000 10833436976 11260592128 1908445472 18.894 100 42 84 1 1930746912 10814928 11486512
20:29:49 28189 8192000000 10846610624 11269632000 1914765344 18.945 100 35 70 2 1934107520 9855200 9486976
20:30:25 5639 8192000000 10855451520 11279310848 1925051008 19.027 100 54 105 1 1951881616 11445440 15385168
20:30:39 15544 8192000000 10872461728 11295334400 1929596176 19.064 100 57 114 2 1959450032 13461808 16392048
20:31:02 6380 8192000000 10878630224 11299360768 1935462240 19.111 100 52 105 1 1962894192 12328704 15103248
20:31:19 5668 8192000000 10879822064 11304239104 1943045184 19.171 100 65 128 3 1977336224 15912960 18378080
20:31:33 9352 8192000000 10874255264 11305226240 1945315248 19.189 100 48 94 1 1970955552 12458240 13182064
20:31:51 16871 8192000000 10884279360 11310252032 1949712624 19.224 100 47 94 2 1975478512 12481664 13284224
20:32:19 11579 8192000000 10889138720 11317829632 1955852912 19.273 100 55 108 2 1983852528 12803872 15195744
20:32:39 8141 8192000000 10896290096 11326885888 1960417584 19.309 100 55 110 4 1990129520 13856864 15855072
20:32:54 16855 8192000000 10906681984 11333730304 1965847728 19.352 100 50 100 0 1998085696 18230992 14006976
20:33:19 7919 8192000000 10915927008 11340730368 1973098672 19.410 100 57 113 4 2006120416 16646624 16375120
20:33:37 16554 8192000000 10911678240 11343917056 1975282256 19.427 100 47 94 1 2004988752 15993184 13713312
20:34:02 9475 8192000000 10935280144 11360825344 1980355552 19.468 100 57 109 1 2016299408 20181312 15762544
20:34:25 13693 8192000000 10927321056 11359961088 1990007088 19.544 100 50 99 2 2026525168 21909952 14608128
20:34:46 6391 8192000000 10934931280 11364646912 1989244272 19.538 100 47 94 1 2022258896 19015072 13999552
20:35:06 8877 8192000000 10938242080 11370942464 1993716160 19.573 100 52 104 0 2028570864 19270480 15584224
20:35:25 11267 8192000000 10926367664 11355078656 1941044464 19.155 97 48 94 2 1975334320 20100608 14189248
20:35:47 14654 8192000000 10940065824 11366678528 1989614192 19.541 100 59 118 1 2029085968 22125104 17346672
20:36:10 19387 8192000000 10954436192 11382898688 1997726080 19.605 100 62 121 2 2040700352 24471216 18503056
20:36:36 6593 8192000000 10952685872 11383021568 2001987216 19.638 100 51 103 0 2043183392 25933232 15262944
20:36:59 13203 8192000000 10954617984 11394736128 2003323408 19.649 100 38 76 2 2040476944 25278608 11874928
20:37:27 7905 8192000000 10972893312 11410968576 2017891600 19.764 100 54 107 0 2066115968 31901936 16322432
20:37:45 7872 8192000000 11000058384 11419013120 2021744704 19.794 100 64 127 2 2074010944 32191728 20074512
20:38:02 8591 8192000000 10997500656 11423158272 2026984976 19.835 100 64 124 0 2080678000 35143040 18549984
20:38:41 7052 8192000000 10990944544 11421069312 2022651392 19.801 100 58 114 2 2076679328 36929360 17098576
20:39:01 6292 8192000000 11003003856 11431768064 2029722032 19.856 100 68 136 0 2089565952 38988000 20855920
20:39:18 3078 8192000000 10998881712 11426164736 2029326768 19.853 100 73 144 2 2088208304 36793360 22088176
20:39:31 4895 8192000000 11002892752 11430350848 2030654608 19.864 100 66 132 0 2088165600 38003808 19507184
20:39:43 4720 8192000000 11014041232 11435053056 2032161008 19.876 100 75 150 1 2095717440 40596352 22960080
20:40:03 4670 8192000000 11003932560 11434610688 2027805072 19.841 100 67 134 1 2090425536 41887824 20732640
20:40:18 2528 8192000000 11009634496 11438206976 2031079776 19.867 100 67 134 3 2092648880 40297136 21271968
20:40:29 2514 8192000000 11011045248 11436081152 2028709104 19.849 100 72 144 2 2096222992 45105072 22408816
20:40:41 10336 8192000000 10996060272 11427221504 2018665136 19.770 100 60 119 2 2079689184 42153920 18870128
20:41:04 7012 8192000000 11019332064 11452858368 2030885040 19.866 100 56 113 1 2099638720 50349712 18403968
20:41:18 4395 8192000000 11024581776 11443765248 2028058016 19.843 100 70 138 0 2098332656 48013152 22261488
20:41:29 3578 8192000000 11030776144 11447779328 2019193568 19.774 99 77 151 2 2094324480 50382512 24748400
20:41:39 3561 8192000000 11025604768 11448688640 2030685680 19.864 100 76 152 1 2106096400 51052352 24358368
20:41:51 6064 8192000000 11022158336 11447513088 2029409680 19.854 100 65 130 1 2103477184 52434816 21632688
20:42:04 6707 8192000000 11023736896 11453399040 2036537632 19.910 100 73 145 3 2109556704 50155792 22863280
20:42:21 2905 8192000000 11024665872 11455766528 2035102224 19.899 100 67 134 0 2108259984 51125856 22031904
20:42:32 2700 8192000000 10992785616 11422740480 1994564192 19.580 99 74 149 0 2069179680 50450512 24164976
20:42:42 4256 8192000000 10991605424 11415920640 2005881216 19.669 100 70 138 1 2071469328 43560816 22027296
20:42:53 3637 8192000000 10998841840 11426328576 2011771344 19.715 100 69 138 1 2077902992 44059280 22072368
20:43:16 2606 8192000000 10989643568 11427373056 2016446864 19.752 100 57 112 2 2075812512 41429888 17935760
20:43:28 11441 8192000000 10995694208 11427790848 2017820320 19.763 100 77 152 1 2083995696 43016448 23158928
20:43:46 4837 8192000000 11009046096 11441770496 2023679488 19.809 100 69 138 0 2089651216 44949952 21021776
20:44:04 4186 8192000000 10993675456 11428298752 2007533040 19.682 99 66 132 0 2073419600 45351152 20535408
20:44:18 4578 8192000000 11002103536 11435630592 2003128576 19.647 99 54 106 2 2068523568 49187312 16207680
20:44:32 5050 8192000000 11016529072 11444649984 2022781248 19.802 100 69 136 1 2095467088 51003200 21682640
20:44:46 5125 8192000000 10980808128 11407519744 1974820272 19.424 98 69 138 2 2050600000 53866960 21912768
20:45:03 3512 8192000000 11002620208 11427667968 2010682096 19.707 100 67 134 1 2086031536 53538224 21811216
20:45:13 1248 8192000000 11023553952 11441348608 2023339488 19.806 100 88 172 2 2101857360 51753184 26764688
20:45:21 1542 8192000000 11026030128 11445452800 2020235344 19.782 100 88 177 0 2100525264 53100512 27189408
20:45:31 5213 8192000000 11016501648 11442376704 2019173024 19.774 100 70 140 2 2095690512 54917552 21599936
20:45:45 6332 8192000000 11009865024 11435098112 2010457120 19.705 100 73 146 0 2089555856 56198688 22900048
20:46:33 8428 8192000000 10959720416 11404894208 1977644784 19.446 100 40 80 1 2049130880 57556224 13929872
20:46:49 6889 8192000000 10967350608 11407646720 1982799200 19.487 100 41 80 3 2052436816 56413056 13224560
20:47:08 7981 8192000000 10969478624 11405959168 1962372992 19.325 98 47 95 3 2037149072 58844064 15932016
20:47:24 5741 8192000000 10962106672 11406716928 1979260288 19.459 100 47 94 1 2047862032 53435264 15166480
20:47:47 19624 8192000000 10950006320 11401568256 1964471744 19.342 99 39 78 1 2032356080 54886400 12997936
20:48:21 6530 8192000000 10928894128 11358060544 1939175296 19.140 99 44 88 1 2008337696 54248816 14913584
20:48:44 11189 8192000000 10960703616 11403988992 1970442960 19.389 100 30 60 1 2038312304 57598624 10270720
20:49:02 17676 8192000000 10955614272 11403919360 1952960880 19.250 99 33 66 0 2024747264 60332176 11454208
20:49:29 8348 8192000000 10977306080 11415076864 1978189888 19.450 100 48 96 0 2056784992 62925520 15669584
20:49:45 4675 8192000000 10932157120 11362803712 1914791376 18.945 98 53 106 2 1998810112 66274592 17744144
20:49:56 8071 8192000000 10936102576 11375759360 1934763472 19.105 100 44 88 0 2017985056 67710528 15511056
20:50:11 21561 8192000000 10903758608 11368124416 1936367072 19.118 100 31 62 1 2008093344 61028432 10697840
20:50:57 25530 8192000000 10889932272 11341127680 1876557488 18.637 97 24 48 2 1932368976 47669616 8141872
20:51:34 31166 8192000000 10879257248 11340247040 1905443232 18.870 99 19 38 0 1959334128 46898640 6992256
20:52:15 20403 8192000000 10875149072 11336130560 1906141776 18.876 99 22 44 2 1954934160 40915632 7876752
20:52:46 22606 8192000000 10875669424 11333427200 1903903200 18.858 99 20 40 1 1956056272 44843312 7309760
20:53:23 41265 8192000000 10870422000 11324817408 1899895888 18.825 99 27 54 1 1943835824 34698544 9241392
20:54:29 25327 8192000000 10864866336 11331293184 1905939312 18.874 99 29 59 2 1943904480 29785744 8179424
20:55:10 42286 8192000000 10845315280 11300937728 1865991968 18.552 97 13 26 1 1882072880 12476000 3604912
20:56:48 148546 8192000000 10856435488 11296067584 1771636880 17.781 92 16 32 1 1788799712 12996368 4166464
20:59:23 78010 8192000000 10839006448 11286130688 1824544640 18.215 95 11 22 2 1840277168 13102176 2630352
21:00:52 58836 8192000000 10867026320 11318587392 1901039424 18.835 99 9 19 1 1917124752 13227648 2857680
21:03:01 62794 8192000000 10874353824 11332296704 1922855984 19.010 99 16 31 0 1939395056 12634752 3904320
21:04:10 24222 8192000000 10879140432 11332718592 1943775968 19.177 100 13 26 2 1955007088 7876880 3354240
21:04:47 18991 8192000000 10886469888 11339567104 1940669440 19.152 99 26 52 2 1955718112 7604608 7444064
21:05:22 53976 8192000000 10883470848 11348037632 1918339072 18.974 98 12 24 0 1934171104 12611488 3220544
21:06:22 110213 8192000000 10902563520 11354955776 1939534896 19.143 99 32 64 2 1964275440 15524880 9215664
21:08:19 31480 8192000000 10922004784 11378012160 1975594448 19.430 100 45 88 1 2001533776 13876128 12063200
21:09:04 74719 8192000000 10909468160 11371520000 1956091984 19.275 99 28 56 1 1975482576 11744192 7646400
21:10:30 29429 8192000000 10910684576 11358437376 1953761920 19.256 99 29 58 0 1969517040 7180688 8574432
21:11:06 8002 8192000000 10920139600 11384602624 1983436336 19.492 100 37 74 1 2006512512 12615680 10460496
21:11:25 43789 8192000000 10916355712 11371282432 1951286384 19.237 98 20 40 1 1969427536 12279488 5861664
21:12:32 20125 8192000000 10932475136 11396648960 1994899312 19.582 100 39 78 1 2024534240 17975408 11659520
21:13:08 26745 8192000000 10941651776 11405058048 1997399744 19.602 100 51 102 2 2033783248 20300944 16082560
21:13:46 54519 8192000000 10954468112 11423903744 1997825008 19.606 100 28 57 1 2032665216 26067392 8772816
21:15:07 77388 8192000000 10930963760 11409416192 1996259264 19.593 100 18 36 2 2027410960 24953792 6197904
21:16:58 58059 8192000000 10926085952 11409715200 1984684176 19.502 99 17 34 0 2008033344 17980768 5368400
21:18:03 53046 8192000000 10938274016 11422867456 2000666400 19.628 100 11 22 0 2020378592 16399520 3312672
21:19:10 30653 8192000000 10946044384 11430133760 2011891568 19.716 100 16 32 1 2033401984 16459392 5051024
21:20:08 55276 8192000000 10944702160 11442147328 2009396304 19.697 100 6 12 0 2029187472 18236592 1554576
21:21:18 47854 8192000000 10960505968 11446616064 2017765664 19.763 100 12 24 0 2037109648 16145440 3198544
21:22:12 37009 8192000000 10955563088 11427995648 2007629984 19.683 99 32 63 2 2032372320 16068848 8673488
21:22:57 44356 8192000000 10940460464 11434766336 1999875664 19.622 99 16 32 0 2021585600 16951872 4758064
21:23:48 58356 8192000000 10963737424 11433873408 2009759440 19.700 100 13 27 0 2034272960 21222464 3291056
21:24:55 40815 8192000000 10977063792 11438907392 2010573840 19.706 99 43 86 0 2036851904 14328192 11949872
21:25:42 53158 8192000000 10972815312 11467071488 2027267568 19.837 100 19 38 1 2060345632 27758864 5319200
21:26:43 59335 8192000000 10968921392 11444326400 2004722224 19.660 99 17 33 0 2029491424 20299808 4469392
21:27:53 67768 8192000000 10939354272 11427434496 1988048368 19.528 98 14 28 2 2007643392 15935216 3659808
21:29:45 62972 8192000000 10902754368 11385229312 1895300624 18.788 94 10 20 1 1907901536 10182912 2418000
21:30:54 87554 8192000000 10892401680 11362660352 1854321504 18.457 93 13 25 2 1867483392 9988672 3173216
21:32:32 43581 8192000000 10921718368 11358765056 1883161792 18.691 95 45 90 3 1909300304 12748432 13390080
21:33:23 53457 8192000000 10897024256 11365982208 1959156272 19.299 100 43 86 0 1985633568 14194480 12282816
21:35:45 65999 8192000000 10877754496 11326713856 1832315136 18.278 93 15 30 0 1845115984 8824736 3976112
21:37:57 29599 8192000000 10883972784 11332022272 1896654592 18.799 97 23 46 0 1918227056 14461904 7110560
21:38:36 86960 8192000000 10866586944 11351093248 1910410048 18.910 98 15 30 0 1926597216 11776288 4410880
21:40:09 62112 8192000000 10878208688 11351379968 1934085760 19.100 99 15 30 2 1946783952 8251472 4446720
21:41:31 53390 8192000000 10869814704 11341807616 1882470272 18.685 96 12 24 0 1894421424 8578160 3372992
21:42:32 65594 8192000000 10843875728 11319074816 1862777744 18.526 96 10 20 0 1874510912 8824064 2909104
21:44:53 91896 8192000000 10816358448 11302510592 1818036288 18.162 95 12 24 0 1835850176 14608768 3205120
21:46:58 47323 8192000000 10853775584 11316187136 1882665504 18.687 98 28 56 1 1901218128 10999360 7553264
21:48:12 63243 8192000000 10870620208 11331313664 1887691456 18.727 98 22 42 2 1912229408 18663776 5874176
21:49:41 52410 8192000000 10851738224 11319554048 1887198672 18.723 97 24 48 1 1910943040 16607936 7136432
21:50:42 67970 8192000000 10843423664 11326484480 1849174384 18.415 96 12 24 1 1870566688 17934304 3458000
21:51:58 30782 8192000000 10864506240 11314958336 1871793040 18.599 97 35 67 3 1890163984 8869984 9500960
21:52:51 45115 8192000000 10864592544 11323584512 1889629120 18.743 98 29 58 2 1911544672 14053136 7862416
21:53:49 27748 8192000000 10863476288 11308392448 1883312032 18.692 98 33 66 0 1907507552 14916976 9278544
21:54:33 23988 8192000000 10858332000 11308167168 1908115712 18.892 100 29 58 1 1929059664 13210000 7733952
21:55:04 22372 8192000000 10865086592 11321098240 1900594176 18.831 99 20 40 1 1921806256 15694320 5517760
21:55:40 72200 8192000000 10871553248 11329757184 1905688272 18.872 99 14 28 0 1920840368 11738368 3413728
21:56:58 40222 8192000000 10897247168 11347316736 1925302496 19.029 99 32 64 1 1944933072 10850944 8779632
21:57:45 42820 8192000000 10902148736 11348549632 1909495424 18.903 97 32 64 0 1927214192 9295232 8423536
21:58:38 144350 8192000000 10882743936 11352649728 1935749600 19.113 99 23 44 2 1956144528 14156560 6238368
22:01:20 13305 8192000000 10892322352 11358932992 1956080448 19.275 100 22 44 1 1975273024 12179728 7012848
22:01:40 42535 8192000000 10895560240 11365826560 1957120064 19.283 100 13 26 0 1972921696 12484768 3316864
22:02:34 60038 8192000000 10887350304 11367067648 1944268016 19.181 99 6 12 0 1956820848 10995776 1557056
22:04:35 69099 8192000000 10904482416 11377872896 1969492288 19.381 100 8 16 2 1982193152 10292368 2408496
22:05:51 99089 8192000000 10907157760 11388157952 1960720336 19.312 99 15 31 2 1976507936 11168480 4619120
22:07:51 75324 8192000000 10897273392 11379822592 1939380208 19.142 98 9 18 0 1956556032 15182176 1993648
22:09:16 28997 8192000000 10916792448 11383377920 1980172432 19.466 100 30 60 1 1997521216 8565008 8783776
22:09:51 80009 8192000000 10920614384 11388678144 1954876496 19.265 98 25 50 1 1972608048 10721584 7009968
22:11:17 83092 8192000000 10914093232 11391881216 1982635184 19.486 100 8 16 0 1997272576 12382304 2255088
22:12:49 41814 8192000000 10940914992 11396460544 1972884944 19.408 99 31 61 0 1991369408 10549248 7935216
22:13:41 51817 8192000000 10917698160 11397615616 1971575248 19.398 99 27 54 0 1990876416 11631312 7669856
22:14:40 41796 8192000000 10927460176 11394490368 1968516720 19.374 99 22 44 3 1983501600 8773216 6211664
22:15:28 55565 8192000000 10945392448 11410358272 1996683024 19.597 100 28 56 0 2018409824 13935728 7791072
22:16:36 86865 8192000000 10936387280 11405479936 1978322096 19.451 99 17 34 0 1997119216 14420256 4376864
22:18:09 30129 8192000000 10929636016 11394441216 1947026064 19.203 97 47 94 1 1969735552 9912944 12796544
22:18:46 30388 8192000000 10929165136 11385765888 1971243808 19.395 99 35 70 1 1996681328 16209200 9228320
22:19:23 10028 8192000000 10931142560 11380420608 1960692912 19.312 99 43 86 1 1983134400 10681376 11760112
22:19:43 17043 8192000000 10923660032 11377106944 1961412304 19.317 99 42 84 1 1985094592 11924544 11757744
22:20:06 11587 8192000000 10939549056 11388952576 1986031520 19.512 100 47 94 0 2010670352 11599536 13039296
22:20:24 83793 8192000000 10886480688 11351912448 1910828048 18.913 96 41 80 1 1932408848 10260976 11319824
22:21:55 47942 8192000000 10901555216 11372515328 1967506528 19.366 100 27 54 0 1984574160 9538176 7529456
22:22:58 50537 8192000000 10892343072 11374604288 1958225936 19.292 99 11 22 0 1971754496 10219360 3309200
22:23:57 46050 8192000000 10889911712 11378765824 1972054592 19.402 100 5 10 0 1983103200 9471616 1576992
22:24:50 69570 8192000000 10879212992 11365081088 1916339168 18.958 97 12 24 0 1930718656 10754256 3625232
22:26:13 51197 8192000000 10904671552 11385450496 1970323312 19.388 100 19 37 0 1991854736 16036432 5494992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 10-01-2021 22:29:03 to 10-01-2021 22:29:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-01-2021 22:29:34 to 10-01-2021 22:29:36.

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          231880
MON$OLDEST_ACTIVE               231881
MON$OLDEST_SNAPSHOT             231881
MON$NEXT_TRANSACTION            231881
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                       2039136
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:660: 
:661: mscs-test-161.budzdorov.ru    Sun Jan 10 22:27:21 2021
:662:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:663: 
:664: 
:665: mscs-test-161.budzdorov.ru    Sun Jan 10 22:27:21 2021
:666:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:667: 
:668: 
:669: mscs-test-161.budzdorov.ru    Sun Jan 10 22:27:27 2021
:670:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:671: 
--- end of diff output ---

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

10.01.21 22:29:37. 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-01-10 22:29:39 No severe PSQL-related problems occured
10.01.21 22:29:41. End of report.