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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17433616 kB
MemAvailable 31509256 kB
Buffers 0 kB
Cached 14203920 kB
SwapCached 0 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-03-19 19:27:22
DTS_END                         2021-03-19 19:27:22.1210
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/40984
TRN_ID                          244425
ATT_ID                          662
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: 9402.81 21743 1128337
customer order: creation 175.82 387 21098
customer order: refuse 14.36 391 1723
order to supplier: creation 47.58 1237 5709
order to supplier: removal 3.43 96871 412
invoice (draft): creation 47.57 3507 5708
invoice (draft): removal 53.25 715 6390
invoice accept: apply 42.25 17494 5070
invoice accept: cancel 48.49 787 5819
customer reserve: creation 3903.08 171 468370
customer reserve: removal 4767.27 55 572073
realization accept: apply 84.85 166 10182
realization accept: cancel 83.45 114 10014
payment from customer: creation 60.18 112 7222
payment from customer: removal 6.02 73 722
payment to supplier: creation 49.32 117 5918
payment to supplier: removal 3.61 83 433
service: total inventory turnovers 4.84 1321 581
service: total monetary turnovers 6.53 32 783
service: aggregate perf. data 0.88 18166 106
service: refresh index statistics 0.03 293065 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-03-2021 19:28:12 to 19-03-2021 19:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2201
TEST_TIME 2 2639
TEST_TIME 3 3659
TEST_TIME 4 4177
TEST_TIME 5 3989
TEST_TIME 6 4171
TEST_TIME 7 5021
TEST_TIME 8 5399
TEST_TIME 9 5402
TEST_TIME 10 5567
TEST_TIME 11 5773
TEST_TIME 12 6249
TEST_TIME 13 6453
TEST_TIME 14 6476
TEST_TIME 15 6731
TEST_TIME 16 7055
TEST_TIME 17 7203
TEST_TIME 18 7603
TEST_TIME 19 8213
TEST_TIME 20 8760
TEST_TIME 21 9078
TEST_TIME 22 9418
TEST_TIME 23 9337
TEST_TIME 24 9524
TEST_TIME 25 9476
TEST_TIME 26 10596
TEST_TIME 27 10920
TEST_TIME 28 10839
TEST_TIME 29 10677
TEST_TIME 30 10652
TEST_TIME 31 10430
TEST_TIME 32 10527
TEST_TIME 33 10347
TEST_TIME 34 10138
TEST_TIME 35 10079
TEST_TIME 36 9950
TEST_TIME 37 10168
TEST_TIME 38 10232
TEST_TIME 39 10175
TEST_TIME 40 10026
TEST_TIME 41 9887
TEST_TIME 42 9868
TEST_TIME 43 9774
TEST_TIME 44 9887
TEST_TIME 45 9771
TEST_TIME 46 9875
TEST_TIME 47 9750
TEST_TIME 48 9803
TEST_TIME 49 9905
TEST_TIME 50 9817
TEST_TIME 51 9860
TEST_TIME 52 9840
TEST_TIME 53 9776
TEST_TIME 54 10047
TEST_TIME 55 10018
TEST_TIME 56 10161
TEST_TIME 57 10101
TEST_TIME 58 10045
TEST_TIME 59 9974
TEST_TIME 60 9867
TEST_TIME 61 9862
TEST_TIME 62 9849
TEST_TIME 63 9756
TEST_TIME 64 9679
TEST_TIME 65 9604
TEST_TIME 66 9665
TEST_TIME 67 9707
TEST_TIME 68 9691
TEST_TIME 69 9651
TEST_TIME 70 9645
TEST_TIME 71 9736
TEST_TIME 72 9818
TEST_TIME 73 9763
TEST_TIME 74 9905
TEST_TIME 75 9899
TEST_TIME 76 9835
TEST_TIME 77 9923
TEST_TIME 78 9862
TEST_TIME 79 9909
TEST_TIME 80 9915
TEST_TIME 81 9809
TEST_TIME 82 9778
TEST_TIME 83 9738
TEST_TIME 84 9706
TEST_TIME 85 9673
TEST_TIME 86 9600
TEST_TIME 87 9537
TEST_TIME 88 9579
TEST_TIME 89 9523
TEST_TIME 90 9553
TEST_TIME 91 9533
TEST_TIME 92 9530
TEST_TIME 93 9522
TEST_TIME 94 9558
TEST_TIME 95 9577
TEST_TIME 96 9599
TEST_TIME 97 9624
TEST_TIME 98 9623
TEST_TIME 99 9660
TEST_TIME 100 9655
TEST_TIME 101 9631
TEST_TIME 102 9647
TEST_TIME 103 9671
TEST_TIME 104 9602
TEST_TIME 105 9545
TEST_TIME 106 9530
TEST_TIME 107 9503
TEST_TIME 108 9462
TEST_TIME 109 9412
TEST_TIME 110 9439
TEST_TIME 111 9398
TEST_TIME 112 9381
TEST_TIME 113 9341
TEST_TIME 114 9373
TEST_TIME 115 9364
TEST_TIME 116 9373
TEST_TIME 117 9340
TEST_TIME 118 9465
TEST_TIME 119 9457
TEST_TIME 120 9403

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1563066 1563066 0 0.00 0 26648 6 0 0
doc_list_biud 1563035 1563035 0 0.00 0 46738 26 0 0
sp_add_invoice_to_stock 5167 5070 97 1.87 31 194337 17494 0 97
sp_cancel_adding_invoice 5819 5819 0 0.00 5 61762 787 0 0
sp_cancel_client_order 1723 1723 0 0.00 4 18399 391 0 0
sp_cancel_customer_reserve 572073 572073 0 0.00 1 28360 56 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 3 6803 73 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 7279 84 0 0
sp_cancel_supplier_invoice 6400 6390 10 0.15 2 18181 715 0 10
sp_cancel_supplier_order 412 412 0 0.00 5 1143044 96871 0 0
sp_cancel_write_off 10014 10014 0 0.00 1 11663 115 0 0
sp_client_order 21098 21098 0 0.00 3 31873 387 0 0
sp_customer_reserve 468370 468370 0 0.00 0 101775 172 0 0
sp_fill_shopping_cart 32511 32511 0 0.00 1 19144 38 0 0
sp_fill_shopping_cart_clo_res 468370 468370 0 0.00 0 20987 15 0 0
sp_get_clo_for_invoice 5070 5070 0 0.00 0 26606 344 0 0
sp_kill_cost_storno 16988 16988 0 0.00 0 26183 54 0 0
sp_kill_qstorno_ret_qs2qd 1160962 1160962 0 0.00 0 28335 30 0 0
sp_kill_qty_storno 611663 611663 0 0.00 0 46737 65 0 0
sp_lock_selected_doc 21109 21109 0 0.00 0 8683 6 0 0
sp_make_cost_storno 28392 28392 0 0.00 0 14297 49 0 0
sp_multiply_rows_for_pdistr 28370 28370 0 0.00 0 5153 26 0 0
sp_multiply_rows_for_qdistr 21098 21098 0 0.00 0 13097 189 0 0
sp_pay_from_customer 7222 7222 0 0.00 4 18166 113 0 0
sp_pay_to_supplier 5918 5918 0 0.00 5 13040 118 0 0
sp_payment_common 13129 13129 0 0.00 1 18161 23 0 0
sp_qd_handle_on_cancel_clo 1723 1723 0 0.00 0 18389 353 0 0
sp_qd_handle_on_invoice_upd_sts 10880 10880 0 0.00 0 46737 321 0 0
sp_qd_handle_on_reserve_upd_sts 10171 10171 0 0.00 0 14513 54 0 0
sp_reserve_write_off 10182 10182 0 0.00 6 14528 167 0 0
sp_supplier_invoice 5708 5708 0 0.00 7 106679 3508 0 0
sp_supplier_order 5709 5709 0 0.00 5 81736 1237 0 0
srv_aggregate_perf_data 106 106 0 0.00 2327 400280 18167 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1153 151335 34785 0 0
srv_find_qd_qs_mism 1080208 1080208 0 0.00 0 26646 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 27 61635 1321 0 0
srv_make_money_saldo 783 783 0 0.00 1 7323 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 133681 555642 293065 0 0
t$perf-abend:sp_add_invoice_to_stock 97 97 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5070 5070 0 0.00 0 42857 170 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 4012 111 0 0
t$perf-norm:sp_cancel_client_order 1723 1723 0 0.00 0 4354 18 0 0
t$perf-norm:sp_cancel_customer_reserve 711 711 0 0.00 0 660 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 4289 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 5873 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 2559 16 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 25229 1519 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 3024 10 0 0
t$perf-norm:sp_client_order 21098 21098 0 0.00 0 41921 22 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 2325 8 0 0
t$perf-norm:sp_pay_from_customer 7222 7222 0 0.00 0 8341 10 0 0
t$perf-norm:sp_pay_to_supplier 5918 5918 0 0.00 0 5771 9 0 0
t$perf-norm:sp_reserve_write_off 10182 10182 0 0.00 0 10995 11 0 0
t$perf-norm:sp_supplier_invoice 5708 5708 0 0.00 0 4154 15 0 0
t$perf-norm:sp_supplier_order 5709 5709 0 0.00 0 29466 20 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 362 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 1071 19 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 4002 37 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 2572 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 10316 10122 194 1.88 0 8007 17 0 194
v_all_customers 38306 38306 0 0.00 0 104 1 0 0
v_all_suppliers 31320 31320 0 0.00 0 104 1 0 0
v_all_wares 42196 42196 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 584 7 0 0
v_cancel_client_order 3446 3446 0 0.00 0 8211 6 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 6760 12 0 0
v_cancel_customer_reserve 1422 1422 0 0.00 0 1140 5 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 2419 8 0 0
v_cancel_supplier_invoice 846 826 20 2.36 0 444 14 0 20
v_cancel_supplier_order 824 824 0 0.00 0 973 8 0 0
v_cancel_write_off 2040 2040 0 0.00 0 8156 20 0 0
v_max_id_clo_ord 5709 5709 0 0.00 0 538 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 2944 15 0 0
v_max_id_ord_sup 5704 5704 0 0.00 0 19133 7 0 0
v_max_non_paid_invoice 1660 1660 0 0.00 0 829 3 0 0
v_max_non_paid_realizn 3958 3958 0 0.00 0 5066 5 0 0
v_min_id_clo_ord 5709 5709 0 0.00 0 3275 8 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 6277 22 0 0
v_min_id_ord_sup 5704 5704 0 0.00 0 5630 10 0 0
v_min_non_paid_invoice 5907 5907 0 0.00 0 5070 15 0 0
v_min_non_paid_realizn 7220 7220 0 0.00 0 3483 9 0 0
v_our_firm 10414 10414 0 0.00 0 16 1 0 0
v_reserve_write_off 20342 20342 0 0.00 0 9411 5 0 0
x_lock_depdocs_on_canc_invoice 11796 11796 0 0.00 0 13147 114 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 14040 343 0 0
x_make_qstorno_1000_1200 5709 5709 0 0.00 2 81724 1151 0 0
x_make_qstorno_1200_2000 5708 5708 0 0.00 3 106672 3378 0 0
x_make_qstorno_2100_3300 468370 468370 0 0.00 0 101768 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-03-2021 19:28:20 to 19-03-2021 19:28:24.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:25 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:32 5543 8192000000 10076858624 10352652288 801457808 8.911 65 51 107 1 821159888 2182240 17519840
16:57:44 34187 8192000000 10340806464 10658168832 1386282640 14.473 100 86 172 0 1417779040 4210880 27285520
16:58:28 20371 8192000000 10375097904 10697220096 1428513504 14.848 100 89 178 1 1463697328 5935280 29248544
16:58:58 33855 8192000000 10412815136 10742358016 1466072128 15.179 100 90 180 0 1502087680 7065328 28950224
16:59:44 16447 8192000000 10432578496 10762448896 1485704320 15.351 100 87 174 0 1521424416 8038944 27681152
17:00:12 13087 8192000000 10437489376 10769842176 1494303280 15.426 100 87 174 0 1530907168 8697488 27906400
17:00:38 23595 8192000000 10455735648 10786140160 1502319536 15.496 100 89 178 0 1539635456 9182448 28133472
17:01:12 13826 8192000000 10465366768 10799656960 1514310848 15.601 100 88 176 0 1551567696 9613104 27643744
17:01:46 20336 8192000000 10483923264 10828050432 1535459952 15.784 100 80 160 1 1569784592 9559152 24765488
17:02:19 11723 8192000000 10511625776 10862063616 1569906592 16.081 100 72 144 0 1601435808 10151376 21377840
17:02:40 14445 8192000000 10556561600 10911817728 1604708144 16.380 100 69 138 0 1634899520 10112048 20079328
17:03:04 6372 8192000000 10576498672 10935754752 1639235136 16.673 100 83 166 1 1674212976 10917744 24060096
17:03:21 8782 8192000000 10597488160 10957205504 1650015488 16.765 100 83 166 3 1686357504 12015152 24326864
17:03:37 11737 8192000000 10610916128 10975035392 1669298784 16.927 100 86 172 0 1707077808 12672560 25106464
17:03:57 8191 8192000000 10609542416 10980864000 1680023536 17.018 100 75 149 1 1714119024 11821696 22273792
17:04:13 11286 8192000000 10636431824 11003314176 1693214496 17.128 100 73 143 0 1725164320 11465984 20483840
17:04:32 8186 8192000000 10666857664 11040018432 1729989584 17.435 100 77 154 1 1763264048 11666352 21608112
17:04:47 8059 8192000000 10676755888 11051835392 1743166576 17.545 100 73 146 0 1775239888 11786512 20286800
17:05:03 6436 8192000000 10702081024 11078176768 1755702800 17.649 100 86 173 1 1792850320 12623776 24523744
17:05:17 4812 8192000000 10703437296 11080617984 1765205584 17.727 100 83 164 2 1801191840 13202624 22783632
17:05:32 5731 8192000000 10709705776 11090472960 1772259168 17.786 100 85 170 1 1809590912 13785856 23545888
17:05:44 4905 8192000000 10718364016 11095744512 1776438176 17.820 100 89 177 3 1814755664 14245360 24072128
17:05:56 3504 8192000000 10722007728 11100160000 1784033584 17.883 100 84 169 2 1821449264 14128432 23287248
17:06:06 2853 8192000000 10732181728 11109650432 1788897888 17.923 100 83 166 0 1824893696 12872576 23123232
17:06:15 2643 8192000000 10731775728 11112275968 1789648096 17.929 100 82 164 0 1827090720 14775504 22667120
17:06:24 2655 8192000000 10738684368 11119132672 1798829952 18.004 100 86 172 0 1836712320 14117360 23765008
17:06:34 2741 8192000000 10748619232 11127033856 1806785600 18.070 100 91 184 0 1845828944 13460272 25583072
17:06:43 1652 8192000000 10755331616 11135389696 1811334848 18.107 100 90 179 1 1850828912 14390304 25103760
17:06:51 4915 8192000000 10745226896 11130552320 1812747536 18.118 100 82 164 0 1849742896 14566320 22429040
17:07:03 4083 8192000000 10755936048 11140542464 1815731504 18.143 100 83 166 1 1851647680 13485632 22430544
17:07:13 1517 8192000000 10779151760 11162529792 1832488000 18.280 100 90 178 0 1871671712 14067296 25116416
17:07:21 1757 8192000000 10778618192 11162824704 1838713792 18.330 100 88 175 0 1877521008 14394608 24412608
17:07:30 2129 8192000000 10781625312 11165548544 1838021968 18.325 100 88 176 1 1877238272 14776912 24439392
17:07:38 1166 8192000000 10784274992 11166334976 1839759920 18.339 100 94 189 0 1880701520 13864832 27076768
17:07:45 2095 8192000000 10796987728 11180318720 1852652000 18.444 100 94 189 0 1892265104 13182176 26430928
17:07:54 1985 8192000000 10797398320 11182223360 1852077760 18.439 100 88 173 1 1888731088 12058176 24595152
17:08:02 1317 8192000000 10801766976 11188318208 1857008016 18.479 100 94 188 2 1897364256 13184080 27172160
17:08:09 1552 8192000000 10800836928 11186466816 1858608240 18.492 100 95 190 1 1898939120 12995232 27335648
17:08:17 1602 8192000000 10806349120 11192795136 1861618736 18.516 100 95 192 0 1902872736 13736048 27517952
17:08:25 2244 8192000000 10812371264 11197464576 1864289152 18.538 100 90 176 1 1902936960 13240608 25407200
17:08:34 37945 8192000000 10803780128 11201835008 1863521984 18.532 100 74 149 1 1895494000 11216192 20755824
17:09:18 1978 8192000000 10793931888 11201617920 1868971536 18.576 100 75 152 0 1902329872 11928528 21429808
17:09:26 10297 8192000000 10769202496 11197587456 1860170016 18.505 100 37 74 2 1884190224 14192896 9827312
17:09:44 9782 8192000000 10761111424 11189862400 1858398112 18.490 100 20 40 0 1870572112 6858160 5315840
17:10:00 11190 8192000000 10778642624 11192012800 1860651040 18.509 100 28 57 1 1874382416 6452432 7278944
17:10:19 6649 8192000000 10770643424 11198820352 1863310944 18.530 100 26 53 1 1877531184 6802464 7417776
17:10:35 8281 8192000000 10775870240 11210637312 1864676784 18.541 100 21 41 2 1885135184 14856208 5602192
17:10:49 12957 8192000000 10775288912 11203694592 1865241392 18.546 100 16 30 1 1875750000 6075040 4433568
17:11:10 7037 8192000000 10770743504 11207135232 1868340608 18.571 100 21 42 1 1881306848 6905648 6060592
17:11:27 10320 8192000000 10768401232 11207561216 1870173088 18.586 100 17 34 2 1880551552 5562208 4816256
17:11:44 9137 8192000000 10783318368 11209105408 1871501232 18.596 100 25 50 2 1884316832 5916880 6898720
17:11:59 11738 8192000000 10781922720 11215994880 1872059904 18.601 100 17 34 1 1887344064 10937984 4346176
17:12:22 14238 8192000000 10786081216 11214913536 1877014144 18.641 100 23 47 1 1890345040 6431024 6899872
17:12:42 12533 8192000000 10785773168 11219746816 1880137712 18.666 100 19 38 1 1892372560 6167472 6067376
17:13:02 80041 8192000000 10804075392 11235823616 1885128848 18.707 100 31 62 1 1899300528 5385344 8786336
17:14:29 5142 8192000000 10806227424 11236880384 1887058912 18.722 100 25 49 3 1900795520 6265520 7471088
17:14:42 5122 8192000000 10805380992 11235459072 1887037376 18.722 100 24 46 3 1900382672 6451136 6894160
17:14:55 4334 8192000000 10811687600 11236503552 1888009088 18.730 100 41 82 0 1908564064 8231952 12323024
17:15:07 4167 8192000000 10806423168 11239153664 1889464384 18.741 100 38 70 4 1906446816 7410112 9572320
17:15:20 6701 8192000000 10802325952 11233624064 1870765824 18.590 99 22 44 2 1883359168 5695728 6897616
17:15:33 6184 8192000000 10798404048 11229859840 1869981552 18.584 99 29 58 0 1884764432 5804656 8978224
17:15:48 9936 8192000000 10806796752 11243511808 1890644304 18.751 100 26 52 1 1904773376 6785088 7343984
17:16:08 4070 8192000000 10789330736 11226968064 1872511888 18.605 99 30 60 1 1887352672 6304528 8536256
17:16:20 14427 8192000000 10797562992 11234586624 1866997312 18.560 99 17 33 1 1877335248 5627040 4710896
17:16:42 7976 8192000000 10811683216 11237064704 1886325296 18.716 100 23 45 2 1899322640 6076736 6920608
17:16:56 9699 8192000000 10764409296 11194318848 1793445024 17.960 95 15 30 1 1802979424 5079552 4454848
17:17:12 9658 8192000000 10764325872 11197140992 1780383936 17.853 95 18 36 2 1790804368 5376192 5044240
17:17:28 6981 8192000000 10731572736 11158425600 1762135696 17.702 95 16 31 1 1771535712 4693552 4706464
17:17:44 8722 8192000000 10771858576 11201613824 1851627040 18.435 100 16 32 1 1861705184 5804272 4273872
17:18:03 73147 8192000000 10739054192 11164114944 1709768048 17.267 92 35 70 0 1725539440 5952512 9818880
17:19:24 9031 8192000000 10742919536 11163144192 1788043824 17.916 96 33 67 2 1804658592 5895552 10719216
17:19:40 4441 8192000000 10764909616 11184947200 1823055136 18.203 99 34 69 3 1844211152 11519104 9636912
17:19:56 5889 8192000000 10740460336 11157839872 1772597904 17.788 96 31 62 2 1787170880 5895040 8677936
17:20:09 6103 8192000000 10725621408 11140628480 1761142560 17.694 97 23 46 1 1773086992 5221728 6722704
17:20:23 3863 8192000000 10696256896 11108065280 1747703728 17.583 97 32 64 1 1763303072 5082176 10517168
17:20:34 8458 8192000000 10716686160 11134828544 1770362544 17.770 98 28 53 2 1783395488 5569376 7463568
17:20:49 6269 8192000000 10707831024 11126988800 1758716576 17.674 98 20 41 0 1769683840 5181568 5785696
17:21:03 7463 8192000000 10714383888 11134115840 1783062928 17.875 99 23 46 3 1795030032 5133408 6833696
17:21:17 4438 8192000000 10725121472 11149750272 1811714272 18.110 100 26 51 1 1829733216 10670416 7348528
17:21:27 7527 8192000000 10726716752 11144843264 1787480032 17.911 98 31 62 0 1802958288 5629680 9848576
17:21:43 9198 8192000000 10726664064 11145895936 1767493056 17.746 97 22 44 3 1778736512 5224048 6019408
17:21:59 9236 8192000000 10748907552 11155767296 1805026544 18.055 99 21 42 2 1816734256 4974720 6732992
17:22:16 10129 8192000000 10725870656 11151753216 1777632112 17.830 97 29 55 1 1791084448 5117264 8335072
17:22:35 14299 8192000000 10741457728 11163521024 1788442192 17.919 98 14 27 1 1797900528 5278544 4179792
17:23:02 43842 8192000000 10796914720 11186044928 1843606208 18.370 100 68 137 1 1869944416 5613136 20725072
17:23:52 6596 8192000000 10753583456 11172290560 1832554400 18.280 100 16 32 2 1843116096 6414432 4147264
17:24:07 8007 8192000000 10776128304 11193204736 1848761024 18.412 100 35 69 3 1865316384 6443120 10112240
17:24:22 6941 8192000000 10771447856 11194105856 1852233280 18.440 100 33 64 2 1867908608 6750912 8924416
17:24:35 4194 8192000000 10773489440 11196612608 1854929264 18.462 100 35 70 1 1872037488 7439600 9668624
17:24:46 8819 8192000000 10768361632 11199500288 1857694368 18.485 100 34 68 1 1873566656 6171152 9701136
17:25:08 6873 8192000000 10770918880 11203141632 1860308368 18.506 100 27 53 7 1873746848 5621872 7816608
17:25:23 8926 8192000000 10764966624 11204530176 1864199968 18.537 100 33 66 1 1880201680 6026912 9974800
17:25:40 8102 8192000000 10775882160 11211091968 1865499888 18.548 100 27 52 3 1878594032 5729440 7364704
17:25:56 7987 8192000000 10793922192 11223662592 1869152112 18.577 100 21 43 0 1885500064 10116560 6231392
17:26:11 7850 8192000000 10787575792 11224891392 1874988832 18.625 100 22 44 2 1887967536 6807648 6171056
17:26:26 5148 8192000000 10794173200 11223830528 1874928752 18.624 100 22 44 0 1886766144 5766592 6070800
17:26:40 9998 8192000000 10784386768 11222650880 1876465744 18.637 100 18 37 0 1887224368 5334384 5424240
17:27:01 11015 8192000000 10807758848 11237408768 1884351216 18.700 100 20 39 2 1894651792 4792816 5507760
17:27:22 151335 8192000000 10846102048 11280195584 1914852592 18.946 100 28 56 2 1928787840 5765728 8169520
17:30:00 16894 8192000000 10845925904 11277611008 1910496016 18.911 99 34 68 1 1930619216 10345056 9778144
17:30:26 26107 8192000000 10866090752 11293003776 1924141696 19.020 99 49 98 0 1952708208 14690848 13875664
17:30:59 25073 8192000000 10870749168 11304472576 1938445072 19.134 100 38 76 1 1962854400 13450688 10958640
17:31:38 17950 8192000000 10897803088 11321913344 1948804096 19.217 100 43 86 2 1974564448 13442336 12318016
17:32:04 29030 8192000000 10888445984 11320811520 1937925568 19.130 99 45 90 1 1968900112 17773920 13200624
17:32:54 5835 8192000000 10892369952 11325911040 1957152992 19.283 100 52 103 1 1991684720 19236512 15295216
17:33:08 17029 8192000000 10890691216 11329847296 1956593152 19.279 100 37 73 1 1985524992 17598352 11333488
17:33:34 8057 8192000000 10910308432 11342417920 1968885136 19.377 100 49 97 5 2003459776 19202976 15371664
17:33:49 9047 8192000000 10922053600 11347435520 1969825248 19.384 100 55 109 0 2008076688 22318320 15933120
17:34:06 21046 8192000000 10931124672 11359895552 1976137968 19.434 100 62 125 1 2025776624 30697264 18941392
17:34:37 22129 8192000000 10914932224 11353317376 1971718752 19.399 100 47 94 4 2008221136 21885040 14617344
17:35:07 8794 8192000000 10919233760 11342581760 1952950976 19.250 99 60 120 4 1991631168 20545632 18134560
17:35:31 8477 8192000000 10922438560 11352817664 1972590800 19.406 100 56 111 2 2010572112 20890080 17091232
17:35:51 13385 8192000000 10928809712 11362594816 1978350448 19.452 100 50 96 2 2014307776 21346384 14610944
17:36:13 9647 8192000000 10934668928 11366989824 1986229568 19.514 100 53 104 1 2024800368 22894784 15676016
17:36:42 5458 8192000000 10929900032 11358138368 1977569248 19.445 100 59 114 1 2016895728 22373600 16952880
17:36:56 2739 8192000000 10945258688 11370102784 1987137216 19.521 100 66 132 2 2031026496 23921408 19967872
17:37:06 5248 8192000000 10948212064 11372818432 1992719584 19.565 100 77 154 3 2039851984 24936576 22195824
17:37:21 11924 8192000000 10951078704 11378991104 1994911280 19.583 100 76 152 2 2042995168 25956256 22127632
17:37:46 3451 8192000000 10962951568 11383144448 1996717248 19.597 100 75 150 2 2048239184 30122512 21399424
17:37:57 4873 8192000000 10912348816 11335839744 1941979664 19.163 98 62 124 0 1985875328 25584032 18311632
17:38:10 4506 8192000000 10947506688 11368443904 1981780400 19.479 100 72 143 1 2028949040 26144736 21023904
17:38:22 3620 8192000000 10954301552 11377786880 1990658848 19.549 100 73 145 0 2040847808 28322080 21866880
17:38:32 3773 8192000000 10955836320 11370233856 1986617808 19.517 100 77 152 3 2037825344 28491296 22716240
17:38:43 2854 8192000000 10952595984 11377172480 1987695120 19.526 100 73 144 1 2039114720 29171248 22248352
17:38:57 3405 8192000000 10956184048 11383087104 1995648672 19.588 100 81 160 3 2049830576 30299136 23882768
17:39:11 7229 8192000000 10966506896 11391533056 2000147840 19.624 100 69 137 1 2050449808 29656992 20644976
17:39:25 3039 8192000000 10981529664 11403952128 2009496736 19.698 100 79 158 0 2061674752 29282432 22895584
17:39:37 2160 8192000000 10973447472 11396825088 1994134192 19.576 99 81 161 3 2047527680 29715600 23677888
17:39:48 5000 8192000000 10961112560 11386609664 1979114224 19.458 99 76 148 2 2032328064 31312112 21901728
17:40:00 3037 8192000000 10959753360 11379466240 1987676368 19.525 100 84 168 0 2045479552 32478576 25324608
17:40:10 5410 8192000000 10949228512 11370340352 1979920800 19.464 100 79 158 1 2036717776 32266816 24530160
17:40:25 17195 8192000000 10938224672 11371913216 1943545920 19.175 98 54 107 0 1993441008 33680032 16215056
17:40:51 5378 8192000000 10940462048 11364024320 1957730816 19.288 99 68 136 0 2011692480 33719360 20242304
17:41:05 3726 8192000000 10968067872 11384258560 1992556304 19.564 100 84 168 2 2054287280 36672224 25058752
17:41:18 3115 8192000000 10965089264 11382857728 1974012624 19.417 99 80 160 2 2036156640 37410544 24733472
17:41:28 1978 8192000000 10966000544 11384987648 1990284304 19.546 100 76 152 0 2050867344 37345168 23237872
17:41:38 3690 8192000000 10964401904 11382702080 1985224080 19.506 100 75 150 1 2045224160 37796112 22203968
17:41:49 7387 8192000000 10973240304 11392770048 1989211248 19.538 100 81 162 4 2052828000 39238224 24378528
17:42:07 2077 8192000000 10969923408 11385348096 1987932576 19.527 100 82 165 1 2052241024 39526656 24781792
17:42:16 2448 8192000000 10964080864 11385581568 1988207728 19.530 100 82 164 0 2054117760 40701824 25208208
17:42:25 1198 8192000000 10971262592 11386630144 1988320384 19.531 100 85 169 2 2052634320 38178272 26135664
17:42:35 2152 8192000000 10945774816 11357388800 1966641680 19.359 99 90 180 1 2032284368 38817456 26825232
17:42:43 2789 8192000000 10960089360 11375374336 1980762672 19.471 100 87 169 2 2045439392 39610768 25065952
17:42:54 3473 8192000000 10969762240 11385061376 1982986560 19.488 100 86 171 1 2049511552 40763440 25761552
17:43:04 5860 8192000000 10967966272 11387330560 1987262592 19.522 100 84 165 1 2053592496 40648496 25681408
17:43:26 4298 8192000000 10966031744 11391311872 1988228512 19.530 100 71 139 3 2051641312 42040000 21372800
17:43:38 4022 8192000000 10984525856 11400417280 1996016656 19.591 100 81 161 5 2063946640 43757168 24172816
17:43:51 2404 8192000000 10984216240 11400757248 1993867264 19.574 100 77 149 0 2061026608 43967952 23191392
17:44:03 2046 8192000000 10990825616 11403083776 1984357728 19.499 99 81 163 2 2054441392 45752016 24331648
17:44:13 3706 8192000000 10980099392 11396411392 1991620704 19.557 100 88 174 3 2068115520 48418384 28076432
17:44:25 5559 8192000000 10973401584 11392135168 1981391136 19.476 100 72 143 0 2053062592 49954576 21716880
17:44:38 3249 8192000000 10968927952 11384090624 1971200480 19.395 100 78 155 0 2047215296 51578512 24436304
17:44:48 3280 8192000000 10962557024 11374477312 1966621456 19.359 100 81 157 1 2044189520 52208768 25359296
17:44:59 5517 8192000000 10953779248 11376422912 1963278576 19.332 100 80 160 1 2040508176 51800400 25429200
17:45:17 3102 8192000000 10962323824 11371429888 1941587792 19.159 99 87 174 1 2023967632 55660368 26719472
17:45:27 2045 8192000000 10943273776 11351662592 1925319280 19.029 98 91 183 4 2012243392 58187104 28737008
17:45:38 2238 8192000000 10955508368 11362766848 1950663696 19.232 100 90 179 2 2038503184 59758112 28081376
17:45:49 2867 8192000000 10957884640 11372371968 1957250448 19.284 100 80 160 2 2039244480 55977872 26016160
17:46:00 6545 8192000000 10978231184 11392749568 1971770272 19.399 100 79 160 1 2054078752 57021696 25286784
17:46:19 5283 8192000000 10965749008 11380625408 1959441248 19.302 100 80 160 0 2043838416 59355920 25041248
17:46:31 1512 8192000000 10972728400 11382054912 1961908272 19.321 100 90 178 2 2052695296 62402320 28384704
17:46:41 1153 8192000000 10956978720 11360677888 1940829664 19.153 99 92 185 1 2030527424 61333712 28364048
17:46:49 2901 8192000000 10951229376 11373465600 1936844640 19.122 99 71 142 0 2022755712 63271216 22639856
17:47:00 4742 8192000000 10938530272 11373174784 1951725888 19.240 100 57 114 0 2023760656 53643392 18391376
17:47:19 9751 8192000000 10941559680 11369586688 1953372048 19.253 100 39 78 2 2012096928 45539808 13185072
17:47:36 9122 8192000000 10925102592 11365097472 1955677296 19.272 100 40 80 2 2015967888 46124832 14165760
17:47:58 7625 8192000000 10915448464 11359252480 1939172000 19.140 99 36 72 1 2001741296 50377328 12191968
17:48:26 21950 8192000000 10910245440 11354173440 1936429840 19.118 99 29 58 0 1988676144 42235104 10011200
17:48:55 18751 8192000000 10910246464 11361701888 1943456032 19.174 100 26 53 2 1994340912 41754688 9130192
17:49:31 15850 8192000000 10910325536 11370242048 1951069840 19.235 100 25 50 1 1996213584 36937344 8206400
17:49:55 28058 8192000000 10907364800 11359969280 1939612320 19.144 99 19 39 1 1980242928 34754912 5875696
17:51:14 20195 8192000000 10896632544 11350208512 1903708912 18.856 98 18 36 0 1950448560 41268112 5471536
17:52:10 17799 8192000000 10900844800 11351195648 1928132800 19.052 100 20 39 1 1984333776 48927952 7273024
17:53:39 65343 8192000000 10876618144 11297505280 1852687040 18.444 96 20 38 2 1879564928 20959040 5918848
17:55:02 42197 8192000000 10845225056 11288219648 1896042192 18.794 99 30 59 1 1912298416 8698160 7558064
17:56:02 45573 8192000000 10872502800 11309883392 1924087808 19.020 100 32 62 1 1943388080 10215456 9084816
17:57:59 101636 8192000000 10872088752 11325865984 1906358272 18.877 98 48 93 2 1928501888 9538048 12605568
17:59:48 109640 8192000000 10895127248 11356532736 1954119456 19.259 100 28 55 2 1977622672 15562256 7940960
18:01:51 76644 8192000000 10905976624 11351097344 1928286032 19.053 97 30 60 0 1952115744 14604928 9224784
18:03:19 30772 8192000000 10918499264 11360276480 1952499632 19.246 99 37 74 1 1982992528 18597600 11895296
18:04:01 30744 8192000000 10919507216 11365871616 1978778576 19.455 100 54 108 5 2015252640 19595648 16878416
18:04:40 25495 8192000000 10929448832 11370926080 1975211696 19.427 100 35 68 1 1998524528 13409136 9903696
18:05:16 111904 8192000000 10889068320 11362308096 1943259504 19.173 98 11 22 1 1955558144 9130080 3168560
18:07:14 24068 8192000000 10905165712 11370569728 1959900160 19.305 99 20 40 2 1974794336 9196864 5697312
18:07:48 30360 8192000000 10902745760 11372978176 1980264704 19.467 100 12 24 0 1995198144 11477152 3456288
18:08:27 67219 8192000000 10904102656 11378405376 1980940256 19.472 100 11 22 0 1998230256 13976768 3313232
18:09:46 48729 8192000000 10905063232 11376832512 1965823504 19.352 99 16 32 0 1983298192 13166928 4307760
18:10:46 44241 8192000000 10907481248 11376648192 1980454384 19.468 100 28 56 1 2006386416 17515696 8416336
18:11:41 59597 8192000000 10896047552 11360505856 1940483824 19.151 98 17 34 0 1959082304 13740016 4858464
18:12:54 73508 8192000000 10886495264 11366289408 1929637808 19.064 98 7 14 1 1943380080 11318480 2423792
18:14:16 60943 8192000000 10916703744 11377807360 1941624688 19.160 98 21 42 0 1958943104 11533968 5784448
18:15:24 73076 8192000000 10904722560 11376418816 1956524640 19.278 99 16 32 0 1980647632 19152544 4970448
18:16:49 32112 8192000000 10920966384 11369766912 1961962912 19.322 99 25 50 0 1978642944 9734192 6945840
18:17:31 34391 8192000000 10923453856 11381583872 1980959200 19.472 100 37 74 2 2003916336 12368608 10588528
18:18:19 39058 8192000000 10916909296 11390996480 1976991360 19.441 100 25 50 1 1998009808 13860176 7158272
18:19:11 73631 8192000000 10906183856 11375210496 1929161072 19.060 97 19 38 1 1949376000 14935936 5278992
18:20:33 70225 8192000000 10910692832 11389800448 1959617136 19.303 99 17 34 2 1987788736 22361680 5809920
18:21:54 52323 8192000000 10910292832 11379445760 1936853744 19.122 98 18 36 1 1956954672 14334528 5766400
18:22:52 64295 8192000000 10891167712 11380736000 1947303600 19.205 99 10 20 0 1966444640 16353280 2787760
18:24:04 99947 8192000000 10895331024 11335663616 1777360736 17.828 90 21 41 1 1794147440 10994576 5792128
18:25:51 22747 8192000000 10907887280 11349827584 1919420512 18.982 98 41 82 1 1942761376 11798160 11542704
18:26:26 93098 8192000000 10889981328 11348819968 1934177776 19.100 98 50 98 1 1962012144 14092672 13741696
18:30:14 42264 8192000000 10880395040 11348082688 1933463520 19.095 98 21 42 2 1945493056 6096304 5933232
18:31:10 66276 8192000000 10893932912 11369873408 1978105872 19.450 100 13 26 0 1993242544 11695872 3440800
18:32:26 77883 8192000000 10879520064 11362340864 1922249136 19.005 97 11 22 0 1940182192 14870208 3062848
18:33:50 41334 8192000000 10866662256 11335225344 1888915120 18.737 96 10 20 1 1903042912 11683408 2444384
18:34:39 29796 8192000000 10884888608 11354775552 1944630624 19.184 99 20 40 3 1958285760 8124704 5530432
18:35:18 51471 8192000000 10864794656 11328065536 1853371936 18.450 94 23 46 0 1870073472 10440528 6261008
18:36:18 35382 8192000000 10901659920 11352649728 1918210224 18.973 98 29 58 0 1939500720 12727440 8563056
18:37:05 39755 8192000000 10893663184 11354750976 1905469648 18.870 97 27 53 3 1928551600 15385216 7696736
18:37:55 70154 8192000000 10883823984 11364835328 1929994064 19.067 99 17 34 0 1952105200 17613744 4497392
18:39:11 51314 8192000000 10877269792 11349901312 1915167232 18.948 98 13 26 2 1938171408 19037856 3966320
18:40:10 40008 8192000000 10874248544 11334414336 1908741552 18.897 98 22 44 0 1932565712 17630672 6193488
18:41:00 41294 8192000000 10878244192 11356663808 1939486720 19.143 100 26 52 2 1965087824 18348784 7252320
18:41:53 97513 8192000000 10889812704 11348615168 1870241040 18.586 96 11 22 0 1886099392 13009232 2849120
18:43:36 23713 8192000000 10924210768 11369103360 1963957328 19.337 100 50 100 2 1989795744 11423776 14414640
18:44:11 37363 8192000000 10878208928 11364290560 1926750736 19.041 98 33 66 3 1952092912 15534992 9807184
18:44:59 45236 8192000000 10883218336 11344826368 1898634096 18.815 97 19 38 2 1912682864 8566960 5481808
18:45:52 35851 8192000000 10885728096 11349299200 1932670432 19.088 99 31 63 3 1955333072 13596400 9066240
18:46:39 57195 8192000000 10889658704 11357753344 1938149648 19.132 99 23 46 0 1956899712 12689456 6060608
18:47:43 137512 8192000000 10850461840 11321499648 1855701136 18.468 95 30 60 1 1874046656 9805296 8540224
18:50:11 44724 8192000000 10849063664 11321270272 1913066960 18.931 99 18 36 0 1928005216 10377200 4561056
18:51:02 11676 8192000000 10846768816 11323473920 1927003024 19.043 100 10 20 3 1939720512 8755696 3961792
18:51:21 32030 8192000000 10874303104 11343843328 1935888464 19.114 100 11 22 1 1947784032 8834848 3060720
18:52:00 50807 8192000000 10872749872 11356041216 1956462256 19.278 100 9 18 0 1967978528 9026784 2489488
18:53:09 39072 8192000000 10853457920 11330572288 1927074000 19.043 98 13 26 1 1939819680 9143632 3602048
18:53:54 47812 8192000000 10857434064 11321253888 1910755760 18.913 98 12 23 2 1924541120 9992320 3793040
18:55:01 75382 8192000000 10858537024 11347517440 1937506960 19.127 100 9 17 2 1951876832 11405856 2964016
18:56:26 68467 8192000000 10857241792 11328921600 1907759232 18.889 98 13 26 0 1920841376 9646144 3436000
18:57:41 47279 8192000000 10875005024 11343052800 1921490352 18.999 98 28 56 1 1935561360 6239584 7831424
18:58:34 52180 8192000000 10880618640 11356000256 1944711392 19.184 99 23 44 2 1957762528 7168624 5882512
18:59:36 72919 8192000000 10897501952 11375026176 1938298752 19.133 98 20 40 2 1955159744 11435248 5425744
19:01:00 70319 8192000000 10911304224 11376394240 1954309536 19.261 99 22 45 1 1973333008 12905296 6118176
19:02:21 44652 8192000000 10911169840 11388313600 1971195584 19.395 100 14 28 0 1990536320 15397856 3942880
19:03:20 112054 8192000000 10894321184 11389640704 1880434272 18.669 95 10 20 0 1895933056 12655904 2842880
19:05:23 39836 8192000000 10901871344 11368046592 1940321920 19.149 98 24 48 3 1962382480 15422896 6637664
19:06:09 86878 8192000000 10907059008 11383226368 1957628048 19.287 99 10 20 0 1977515056 16941440 2945568
19:07:43 29764 8192000000 10919337632 11392634880 1985243344 19.506 100 39 78 1 2005281072 8877504 11160224
19:08:19 49377 8192000000 10912729856 11388112896 1957049648 19.283 98 33 66 0 1975290176 8835280 9405248
19:09:22 60524 8192000000 10914453328 11377221632 1953224800 19.252 98 23 46 2 1968066768 8664624 6177344
19:10:40 93297 8192000000 10899444608 11378499584 1957888352 19.289 99 16 32 0 1973545504 11321712 4335440
19:12:20 115209 8192000000 10861035824 11339304960 1842252848 18.359 93 27 54 0 1857931792 8114688 7564256
19:14:23 54598 8192000000 10845525552 11321819136 1914030672 18.939 99 15 30 0 1927121264 8669168 4421424
19:15:28 76215 8192000000 10853207408 11327569920 1886562240 18.718 97 8 16 0 1903311456 14850688 1898528
19:16:51 41957 8192000000 10854884464 11336495104 1925422240 19.030 99 17 34 1 1947059120 16889568 4747312
19:17:44 56843 8192000000 10842293024 11303702528 1886318368 18.716 97 20 40 2 1901161392 9128160 5714864
19:18:50 44420 8192000000 10850769008 11323924480 1902870496 18.849 98 28 56 0 1923139136 12634624 7634016
19:20:03 69815 8192000000 10840515680 11312381952 1838860848 18.332 95 6 12 0 1850764048 10225888 1677312
19:21:20 49499 8192000000 10874096192 11351728128 1942320672 19.165 100 31 62 0 1963642464 12107152 9214640
19:22:16 79048 8192000000 10869543200 11337269248 1870087984 18.585 96 16 32 0 1889295120 14416816 4790320
19:23:41 84708 8192000000 10857460576 11324497920 1847407088 18.401 95 21 42 1 1865519600 11877424 6235088
19:25:59 84933 8192000000 10613238000 11056889856 1647474256 16.743 85 12 22 1 1657839200 7519168 2845776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-03-2021 19:28:26 to 19-03-2021 19:28:57.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-03-2021 19:28:58 to 19-03-2021 19:29:00.

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          244784
MON$OLDEST_ACTIVE               245517
MON$OLDEST_SNAPSHOT             245517
MON$NEXT_TRANSACTION            245517
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                       2027040
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Fri Mar 19 19:27:32 2021
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Fri Mar 19 19:27:33 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Mar 19 19:27:33 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

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