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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-19 16:31:11
DTS_END                         2021-02-19 16:31:11.6840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40388
TRN_ID                          238324
ATT_ID                          622
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: 8886.27 22843 1066352
customer order: creation 173.70 370 20844
customer order: refuse 14.85 381 1782
order to supplier: creation 46.60 1382 5592
order to supplier: removal 3.43 93094 412
invoice (draft): creation 46.68 3588 5601
invoice (draft): removal 49.70 804 5964
invoice accept: apply 42.09 20654 5051
invoice accept: cancel 44.63 906 5355
customer reserve: creation 3807.85 209 456942
customer reserve: removal 4358.43 57 523012
realization accept: apply 84.68 186 10161
realization accept: cancel 81.03 122 9723
payment from customer: creation 60.34 122 7241
payment from customer: removal 5.72 84 686
payment to supplier: creation 50.23 136 6027
payment to supplier: removal 3.52 116 422
service: total inventory turnovers 4.89 1279 587
service: total monetary turnovers 6.96 26 835
service: aggregate perf. data 0.93 22815 111
service: refresh index statistics 0.03 310536 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2021 16:32:03 to 19-02-2021 16:32:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5293
TEST_TIME 2 6240
TEST_TIME 3 6004
TEST_TIME 4 6149
TEST_TIME 5 6074
TEST_TIME 6 5962
TEST_TIME 7 5836
TEST_TIME 8 6477
TEST_TIME 9 6613
TEST_TIME 10 6523
TEST_TIME 11 6524
TEST_TIME 12 6626
TEST_TIME 13 7030
TEST_TIME 14 7141
TEST_TIME 15 7127
TEST_TIME 16 7217
TEST_TIME 17 7336
TEST_TIME 18 7626
TEST_TIME 19 7723
TEST_TIME 20 8024
TEST_TIME 21 8357
TEST_TIME 22 8329
TEST_TIME 23 8604
TEST_TIME 24 8536
TEST_TIME 25 8737
TEST_TIME 26 8713
TEST_TIME 27 8738
TEST_TIME 28 8687
TEST_TIME 29 8732
TEST_TIME 30 9097
TEST_TIME 31 9563
TEST_TIME 32 10003
TEST_TIME 33 9970
TEST_TIME 34 10004
TEST_TIME 35 10173
TEST_TIME 36 10082
TEST_TIME 37 10041
TEST_TIME 38 9923
TEST_TIME 39 9703
TEST_TIME 40 9548
TEST_TIME 41 9496
TEST_TIME 42 9592
TEST_TIME 43 9488
TEST_TIME 44 9496
TEST_TIME 45 9422
TEST_TIME 46 9310
TEST_TIME 47 9229
TEST_TIME 48 9134
TEST_TIME 49 9161
TEST_TIME 50 9166
TEST_TIME 51 9045
TEST_TIME 52 9064
TEST_TIME 53 9054
TEST_TIME 54 8962
TEST_TIME 55 8901
TEST_TIME 56 8859
TEST_TIME 57 8742
TEST_TIME 58 8709
TEST_TIME 59 8752
TEST_TIME 60 8729
TEST_TIME 61 8822
TEST_TIME 62 8871
TEST_TIME 63 8886
TEST_TIME 64 8907
TEST_TIME 65 8994
TEST_TIME 66 9044
TEST_TIME 67 8985
TEST_TIME 68 8964
TEST_TIME 69 8994
TEST_TIME 70 9075
TEST_TIME 71 9115
TEST_TIME 72 9157
TEST_TIME 73 9132
TEST_TIME 74 9170
TEST_TIME 75 9064
TEST_TIME 76 9076
TEST_TIME 77 9092
TEST_TIME 78 9071
TEST_TIME 79 9039
TEST_TIME 80 8992
TEST_TIME 81 8946
TEST_TIME 82 8931
TEST_TIME 83 8961
TEST_TIME 84 8944
TEST_TIME 85 8919
TEST_TIME 86 8873
TEST_TIME 87 8855
TEST_TIME 88 8799
TEST_TIME 89 8809
TEST_TIME 90 8800
TEST_TIME 91 8812
TEST_TIME 92 8834
TEST_TIME 93 8828
TEST_TIME 94 8811
TEST_TIME 95 8924
TEST_TIME 96 8955
TEST_TIME 97 8942
TEST_TIME 98 8961
TEST_TIME 99 8979
TEST_TIME 100 8986
TEST_TIME 101 9017
TEST_TIME 102 9055
TEST_TIME 103 9069
TEST_TIME 104 9028
TEST_TIME 105 8967
TEST_TIME 106 8922
TEST_TIME 107 8931
TEST_TIME 108 8877
TEST_TIME 109 8869
TEST_TIME 110 8852
TEST_TIME 111 8855
TEST_TIME 112 8865
TEST_TIME 113 8867
TEST_TIME 114 8892
TEST_TIME 115 8863
TEST_TIME 116 8908
TEST_TIME 117 8921
TEST_TIME 118 8900
TEST_TIME 119 8916
TEST_TIME 120 8893

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-02-2021 16:32:06 to 19-02-2021 16:32:10.

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 1490078 1490078 0 0.00 0 22983 7 0 0
doc_list_biud 1490078 1490078 0 0.00 0 33354 26 0 0
sp_add_invoice_to_stock 5166 5051 115 2.22 37 180291 20654 0 115
sp_cancel_adding_invoice 5355 5355 0 0.00 5 69018 906 0 0
sp_cancel_client_order 1782 1782 0 0.00 4 14792 381 0 0
sp_cancel_customer_reserve 523012 523012 0 0.00 1 33380 57 0 0
sp_cancel_pay_from_customer 686 686 0 0.00 3 6620 84 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 5920 116 0 0
sp_cancel_supplier_invoice 5969 5964 5 0.08 1 16162 804 0 5
sp_cancel_supplier_order 412 412 0 0.00 10 926945 93094 0 0
sp_cancel_write_off 9723 9723 0 0.00 1 37020 122 0 0
sp_client_order 20844 20844 0 0.00 3 22960 371 0 0
sp_customer_reserve 456942 456942 0 0.00 0 32523 209 0 0
sp_fill_shopping_cart 32028 32028 0 0.00 1 13460 41 0 0
sp_fill_shopping_cart_clo_res 456929 456929 0 0.00 0 11609 12 0 0
sp_get_clo_for_invoice 5038 5038 0 0.00 0 29213 297 0 0
sp_kill_cost_storno 16186 16186 0 0.00 0 22981 65 0 0
sp_kill_qstorno_ret_qs2qd 1062123 1062123 0 0.00 0 30864 31 0 0
sp_kill_qty_storno 561447 561447 0 0.00 0 33353 68 0 0
sp_lock_selected_doc 21070 21070 0 0.00 0 8623 4 0 0
sp_make_cost_storno 28467 28467 0 0.00 0 21800 59 0 0
sp_multiply_rows_for_pdistr 28467 28467 0 0.00 0 7831 33 0 0
sp_multiply_rows_for_qdistr 20844 20844 0 0.00 0 12949 152 0 0
sp_pay_from_customer 7241 7241 0 0.00 4 9936 122 0 0
sp_pay_to_supplier 6027 6027 0 0.00 5 15295 136 0 0
sp_payment_common 13268 13268 0 0.00 1 13251 29 0 0
sp_qd_handle_on_cancel_clo 1782 1782 0 0.00 0 14779 353 0 0
sp_qd_handle_on_invoice_upd_sts 10393 10393 0 0.00 0 16203 356 0 0
sp_qd_handle_on_reserve_upd_sts 10161 10161 0 0.00 0 16358 53 0 0
sp_reserve_write_off 10161 10161 0 0.00 6 21819 186 0 0
sp_supplier_invoice 5601 5601 0 0.00 6 67257 3589 0 0
sp_supplier_order 5592 5592 0 0.00 6 32211 1383 0 0
srv_aggregate_perf_data 111 111 0 0.00 2583 570443 22815 0 0
srv_fill_mon_cache_memory 185 185 0 0.00 1112 123603 28773 0 0
srv_find_qd_qs_mism 1018582 1018582 0 0.00 0 14086 6 0 0
srv_make_invnt_saldo 587 587 0 0.00 21 118363 1280 0 0
srv_make_money_saldo 835 835 0 0.00 0 1257 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 145948 471576 310537 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5052 5052 0 0.00 0 23538 185 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 1 10962 149 0 0
t$perf-norm:sp_cancel_client_order 1782 1782 0 0.00 0 5373 14 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 3703 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 686 686 0 0.00 0 2591 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 644 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 4710 37 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 21655 1537 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 1213 6 0 0
t$perf-norm:sp_client_order 20844 20844 0 0.00 0 11967 22 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 1171 4 0 0
t$perf-norm:sp_pay_from_customer 7241 7241 0 0.00 0 10860 12 0 0
t$perf-norm:sp_pay_to_supplier 6027 6027 0 0.00 0 6224 11 0 0
t$perf-norm:sp_reserve_write_off 10161 10161 0 0.00 0 11967 13 0 0
t$perf-norm:sp_supplier_invoice 5601 5601 0 0.00 0 23456 24 0 0
t$perf-norm:sp_supplier_order 5592 5592 0 0.00 0 6614 19 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 789 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 185 185 0 0.00 0 803 15 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 17578 68 0 0
t$perf-norm:srv_make_money_saldo 835 835 0 0.00 0 2177 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10304 10074 230 2.23 0 3365 17 0 230
v_all_customers 38276 38276 0 0.00 0 20 1 0 0
v_all_suppliers 31016 31016 0 0.00 0 16 1 0 0
v_all_wares 41688 41688 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 1139 11 0 0
v_cancel_client_order 3564 3564 0 0.00 0 2891 7 0 0
v_cancel_customer_prepayment 1372 1372 0 0.00 0 1741 6 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 562 4 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 845 5 0 0
v_cancel_supplier_invoice 820 810 10 1.21 0 4591 24 0 10
v_cancel_supplier_order 824 824 0 0.00 0 842 3 0 0
v_cancel_write_off 2102 2102 0 0.00 0 2900 14 0 0
v_max_id_clo_ord 5592 5592 0 0.00 0 3333 2 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 2871 19 0 0
v_max_id_ord_sup 5592 5592 0 0.00 0 2164 3 0 0
v_max_non_paid_invoice 1703 1703 0 0.00 0 898 3 0 0
v_max_non_paid_realizn 3758 3758 0 0.00 0 2376 4 0 0
v_min_id_clo_ord 5592 5592 0 0.00 0 2163 6 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 2090 7 0 0
v_min_id_ord_sup 5592 5592 0 0.00 0 6617 11 0 0
v_min_non_paid_invoice 6027 6027 0 0.00 0 13244 20 0 0
v_min_non_paid_realizn 7241 7241 0 0.00 0 3943 13 0 0
v_our_firm 10378 10378 0 0.00 0 17 1 0 0
v_reserve_write_off 20322 20322 0 0.00 0 7152 7 0 0
x_lock_depdocs_on_canc_invoice 10914 10914 0 0.00 0 15837 136 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 8580 351 0 0
x_make_qstorno_1000_1200 5592 5592 0 0.00 2 32190 1285 0 0
x_make_qstorno_1200_2000 5601 5601 0 0.00 3 67217 3447 0 0
x_make_qstorno_2100_3300 456942 456942 0 0.00 0 32495 194 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-02-2021 16:32:11 to 19-02-2021 16:32:15.

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
14:01:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:21 16540 8192000000 10216103712 10523312128 933975344 10.234 75 55 113 0 955716592 2680208 19061040
14:01:46 31718 8192000000 10324104224 10634534912 1362810880 14.263 100 88 176 0 1396043344 4583936 28648528
14:02:30 22175 8192000000 10364615152 10682179584 1403444112 14.626 100 83 166 0 1436776528 6019808 27312608
14:03:03 36064 8192000000 10385974288 10710368256 1435581856 14.911 100 89 178 0 1472225376 7446624 29196896
14:03:54 21840 8192000000 10416448016 10744692736 1467137008 15.189 100 87 174 0 1504796992 8224656 29435328
14:04:28 22700 8192000000 10446142368 10779443200 1492069552 15.407 100 86 172 1 1528107296 8594368 27443376
14:04:59 17875 8192000000 10461235856 10796634112 1513413216 15.593 100 91 182 0 1555463264 13443424 28606624
14:05:23 15759 8192000000 10473516960 10815213568 1529965008 15.737 100 85 170 0 1565523840 9141440 26417392
14:05:55 24367 8192000000 10511163600 10860806144 1562226944 16.015 100 83 166 0 1598343600 9792560 26324096
14:06:28 13907 8192000000 10527225824 10884595712 1588552880 16.241 100 76 152 0 1622004576 9695328 23756368
14:06:52 12317 8192000000 10541493008 10902495232 1606903360 16.398 100 73 146 1 1639399824 10221600 22274864
14:07:13 21474 8192000000 10574951088 10936238080 1638683408 16.669 100 84 168 0 1674668720 11251200 24734112
14:07:41 9380 8192000000 10600841408 10961088512 1659652512 16.846 100 85 169 1 1697073344 12639760 24781072
14:08:01 15009 8192000000 10616921936 10981580800 1669209632 16.927 100 80 158 2 1704722768 12472720 23040416
14:08:24 10212 8192000000 10623728928 10993098752 1686600304 17.073 100 76 151 4 1721199936 12804656 21794976
14:08:42 10315 8192000000 10647621888 11017334784 1708401920 17.255 100 85 170 1 1746050016 13318848 24329248
14:09:02 8386 8192000000 10655019504 11026198528 1714373696 17.305 100 78 156 0 1750050912 13903648 21773568
14:09:22 7358 8192000000 10665168400 11041853440 1727678832 17.416 100 79 159 0 1763640720 13515456 22446432
14:09:42 4118 8192000000 10684530976 11061547008 1741941936 17.535 100 82 164 1 1778095520 12597184 23556400
14:09:54 5446 8192000000 10688710080 11067060224 1751019552 17.610 100 74 148 1 1784019760 12645760 20354448
14:10:06 4482 8192000000 10696330960 11076542464 1761831344 17.700 100 76 150 1 1796169936 13059088 21279504
14:10:17 5160 8192000000 10710638224 11089571840 1771250928 17.777 100 89 179 2 1809979728 13810304 24918496
14:10:29 3416 8192000000 10718464416 11097698304 1781739600 17.864 100 88 176 1 1820933600 15022304 24171696
14:10:40 5416 8192000000 10714110144 11099205632 1777127728 17.826 100 78 156 1 1814111392 14969280 22014384
14:10:53 5423 8192000000 10720703824 11105095680 1787702560 17.913 100 79 158 0 1823792320 13578512 22511248
14:11:06 2168 8192000000 10745501888 11127496704 1807250288 18.073 100 83 165 3 1842283696 12607648 22425760
14:11:15 3131 8192000000 10748832048 11134099456 1811994480 18.112 100 84 166 2 1848368576 12775568 23598528
14:11:24 2557 8192000000 10758449264 11144290304 1816468240 18.149 100 82 164 2 1852904464 13169840 23266384
14:11:34 2959 8192000000 10765171952 11151753216 1825514592 18.223 100 90 180 3 1864270400 12728928 26026880
14:11:43 2815 8192000000 10778713824 11162587136 1832321472 18.278 100 94 187 2 1872103456 12904032 26877952
14:11:52 2118 8192000000 10777734512 11160748032 1840889168 18.348 100 97 190 1 1881461360 13478560 27093632
14:12:00 1405 8192000000 10785153040 11169640448 1844127936 18.374 100 94 190 1 1883190464 12634736 26427792
14:12:08 2291 8192000000 10792202672 11177394176 1848872512 18.413 100 92 184 0 1888166976 13184736 26109728
14:12:17 1518 8192000000 10794176912 11182383104 1850763424 18.428 100 86 174 0 1887751920 12532400 24456096
14:12:25 1430 8192000000 10791869248 11181506560 1852943280 18.446 100 81 162 1 1888049632 13191728 21914624
14:12:33 1814 8192000000 10799696192 11187965952 1857797056 18.485 100 88 176 2 1897677632 14378032 25502544
14:12:41 2018 8192000000 10806366832 11193364480 1859051184 18.496 100 91 178 1 1897432656 13064496 25316976
14:12:50 7471 8192000000 10803107776 11193643008 1859256928 18.497 100 80 161 0 1894788096 12418800 23112368
14:13:05 2089 8192000000 10811219184 11198271488 1860972912 18.511 100 80 161 0 1895931232 12203392 22754928
14:13:13 19973 8192000000 10795886192 11193139200 1860367952 18.506 100 63 126 0 1890421456 11665040 18388464
14:13:39 10794 8192000000 10774554048 11194859520 1862050896 18.520 100 49 98 0 1886379024 10888544 13439584
14:13:57 4229 8192000000 10792182144 11198066688 1858468176 18.491 100 32 63 1 1877685856 9334752 9882928
14:14:08 8064 8192000000 10779547024 11201916928 1867325312 18.563 100 40 80 1 1886475040 8178848 10970880
14:14:24 3270 8192000000 10782639456 11197759488 1866484256 18.556 100 40 80 0 1885968512 7455008 12029248
14:14:36 5652 8192000000 10779342960 11198947328 1866622848 18.557 100 32 64 3 1886714608 10968912 9122848
14:14:47 8067 8192000000 10776823376 11202174976 1872389328 18.604 100 31 61 3 1886892944 5805504 8698112
14:15:03 4518 8192000000 10785175792 11205636096 1872314864 18.603 100 35 70 2 1890382640 7927216 10140560
14:15:14 4192 8192000000 10791514672 11206369280 1872464880 18.604 100 35 70 0 1890331088 8279328 9586880
14:15:24 7697 8192000000 10782830448 11210530816 1874878016 18.624 100 33 66 0 1892936912 8557184 9501712
14:15:38 8379 8192000000 10802296960 11221950464 1877178096 18.642 100 30 60 1 1898072608 12308384 8586128
14:15:55 5937 8192000000 10798314464 11221315584 1881584288 18.678 100 35 70 2 1898806720 7594320 9628112
14:16:07 4697 8192000000 10793586848 11223805952 1882496944 18.685 100 27 54 1 1896664048 6776816 7390288
14:16:20 8904 8192000000 10810188672 11225751552 1891839952 18.761 100 40 80 3 1911473408 7939056 11694400
14:16:36 3767 8192000000 10809509232 11228426240 1891587728 18.759 100 47 94 1 1913959824 9095232 13276864
14:16:48 4429 8192000000 10804877168 11229765632 1894842880 18.785 100 38 76 1 1913492336 7832608 10816848
14:17:05 47916 8192000000 10837947536 11250868224 1902046816 18.843 100 25 50 0 1914508832 5266976 7195040
14:18:26 1793 8192000000 10854213728 11264143360 1910539648 18.911 100 83 169 0 1944815568 9944864 24331056
14:18:39 2510 8192000000 10822744288 11249704960 1903722384 18.856 100 39 78 1 1922352848 7423664 11206800
14:18:48 6649 8192000000 10822985344 11253379072 1905498384 18.870 100 31 62 2 1920563664 6593152 8472128
14:19:01 3587 8192000000 10847235728 11258621952 1911650112 18.920 100 45 93 3 1932299200 8103312 12545776
14:19:12 3355 8192000000 10839145584 11263647744 1909400912 18.902 100 49 96 2 1935294896 11340432 14553552
14:19:23 6141 8192000000 10837737504 11260776448 1906799440 18.881 100 27 54 1 1928927472 14498880 7629152
14:19:36 5573 8192000000 10831051568 11257749504 1907301520 18.885 100 28 56 0 1922085952 6990112 7794320
14:19:50 6765 8192000000 10824020992 11259400192 1913426432 18.934 100 35 72 0 1930183248 7109808 9647008
14:20:04 6920 8192000000 10839857200 11265630208 1909241920 18.901 100 25 49 1 1922779152 6716112 6821120
14:20:17 37037 8192000000 10828323424 11259981824 1909891408 18.906 100 27 54 0 1924772288 5747024 9133856
14:21:05 22224 8192000000 10818487360 11255001088 1891771568 18.760 99 37 75 0 1909427728 6582112 11074048
14:21:37 10528 8192000000 10816951712 11247874048 1899421104 18.822 100 31 62 0 1915549760 6140336 9988320
14:21:57 8023 8192000000 10814127792 11243663360 1867745040 18.566 98 19 36 0 1878785536 5601088 5439408
14:22:13 4968 8192000000 10814347872 11243061248 1892648688 18.767 100 36 71 2 1909233248 6930384 9654176
14:22:26 3713 8192000000 10815451232 11237875712 1876529520 18.637 99 48 97 4 1897986304 8449440 13007344
14:22:35 5873 8192000000 10797710976 11221843968 1862812832 18.526 99 40 79 2 1881379776 7070304 11496640
14:22:48 7383 8192000000 10774277856 11195170816 1818693344 18.167 97 27 54 1 1832980256 5898752 8388160
14:23:02 6037 8192000000 10777499024 11205894144 1858129824 18.488 100 28 53 1 1871458896 5848832 7480240
14:23:14 7987 8192000000 10788416656 11207524352 1830193536 18.261 98 22 44 0 1842007840 5058512 6755792
14:23:30 6765 8192000000 10699984592 11118923776 1752057280 17.619 96 15 28 1 1761141600 5105232 3979088
14:23:43 9135 8192000000 10728166912 11149037568 1782297536 17.868 98 16 32 2 1792348688 5883152 4168000
14:23:58 5259 8192000000 10725486160 11136864256 1779320352 17.844 98 28 56 1 1793072416 5932176 7819888
14:24:10 9606 8192000000 10733932880 11155431424 1717741584 17.333 94 26 52 1 1731477936 5703840 8032512
14:24:28 50534 8192000000 10722573568 11113381888 1656992160 16.823 91 41 79 1 1673469520 4635168 11842192
14:25:42 24150 8192000000 10697512288 11100950528 1640859360 16.687 91 26 51 0 1653314576 5614256 6840960
14:26:12 7386 8192000000 10673336112 11074162688 1717877408 17.335 97 28 55 3 1732151984 6417248 7857328
14:26:28 8927 8192000000 10721566608 11126792192 1787946768 17.915 100 40 80 0 1806136496 6146176 12043552
14:26:49 8930 8192000000 10726703904 11148779520 1806354896 18.066 100 28 54 2 1825081120 11066576 7659648
14:27:04 8022 8192000000 10721705936 11136458752 1800820304 18.021 100 32 64 0 1815746464 5549216 9376944
14:27:21 6006 8192000000 10736239952 11150348288 1812579920 18.117 100 35 70 1 1832999600 9992016 10427664
14:27:40 7240 8192000000 10736054704 11158069248 1821141424 18.187 100 19 37 0 1831326960 5320912 4864624
14:27:54 5298 8192000000 10753650624 11176689664 1840721264 18.347 100 41 82 0 1858991488 6288928 11981296
14:28:08 11131 8192000000 10762948592 11180404736 1824576512 18.215 99 23 45 2 1841148672 9609424 6962736
14:28:30 3843 8192000000 10778890832 11189215232 1849525840 18.418 100 38 76 1 1866058304 4896208 11636256
14:28:40 6937 8192000000 10768190320 11193679872 1852670656 18.444 100 26 52 3 1866250528 6346064 7233808
14:28:55 7676 8192000000 10771962176 11198554112 1854232608 18.456 100 18 37 0 1865268336 5844560 5191168
14:29:09 6555 8192000000 10771831280 11202412544 1859324496 18.498 100 14 28 0 1869187344 5861056 4001792
14:29:21 63120 8192000000 10786357312 11205783552 1863942112 18.535 100 24 48 1 1876459936 5374144 7143680
14:30:37 19045 8192000000 10777591792 11211710464 1870919952 18.592 100 36 72 2 1889212080 8253840 10038288
14:31:04 4397 8192000000 10795365216 11220520960 1879882256 18.664 100 33 65 3 1895518912 6316032 9320624
14:31:19 32402 8192000000 10824056976 11243212800 1894902384 18.785 100 48 96 2 1915352496 7087152 13362960
14:32:01 9620 8192000000 10847221088 11259482112 1908482752 18.894 100 60 120 2 1933982256 8521696 16977808
14:32:23 30718 8192000000 10856211984 11273990144 1917731024 18.969 100 60 120 0 1944635024 10413040 16490960
14:33:01 1137 8192000000 10861319280 11275902976 1925472864 19.031 100 66 130 1 1953826480 9961440 18392176
14:33:09 6482 8192000000 10865693744 11280265216 1926146944 19.036 100 64 123 3 1954459072 10692224 17619904
14:33:26 6127 8192000000 10884871968 11288494080 1930527824 19.071 100 66 130 2 1960052032 11086768 18437440
14:33:45 43708 8192000000 10869614960 11295219712 1937012992 19.123 100 46 91 1 1960195968 10468816 12714160
14:34:38 32431 8192000000 10867647856 11304001536 1940165968 19.148 100 38 76 1 1962387392 10796800 11424624
14:35:18 15891 8192000000 10867745360 11304353792 1941545056 19.159 100 27 54 0 1958528128 8590304 8392768
14:35:55 25027 8192000000 10881757840 11319382016 1952981056 19.250 100 40 80 0 1974964096 10483648 11499392
14:36:28 24161 8192000000 10878390736 11319320576 1957686688 19.288 100 42 83 1 1980705552 10878624 12140240
14:37:06 8856 8192000000 10891454624 11329699840 1963175728 19.331 100 53 107 2 1989241200 10616384 15449088
14:37:29 24813 8192000000 10906465872 11338493952 1969884768 19.385 100 41 82 2 1992349552 10743744 11721040
14:38:01 9524 8192000000 10912815728 11344297984 1980443440 19.468 100 55 109 0 2010239184 14181984 15613760
14:38:18 8558 8192000000 10918123776 11349680128 1983930928 19.496 100 61 122 1 2016524208 15080288 17512992
14:38:35 11135 8192000000 10937701104 11352866816 1982129328 19.482 100 61 121 0 2015068080 15567552 17371200
14:39:02 4800 8192000000 10933341968 11362197504 1988072016 19.529 100 67 132 2 2024621920 16971456 19578448
14:39:15 2986 8192000000 10939654496 11361136640 1990993904 19.552 100 67 130 1 2026348688 16796992 18557792
14:39:26 2212 8192000000 10946776320 11371577344 1994793792 19.582 100 76 152 2 2035578000 18541232 22242976
14:39:36 18442 8192000000 10931143024 11360350208 1988055136 19.528 100 66 132 5 2024180080 16762064 19362880
14:40:03 10113 8192000000 10943894848 11367563264 1987983744 19.528 100 70 137 1 2027241952 19540176 19718032
14:40:26 7424 8192000000 10951643328 11376754688 1992596608 19.564 100 77 154 1 2035837104 20417776 22822720
14:40:41 8659 8192000000 10942916656 11378073600 1995901968 19.590 100 56 112 3 2037375088 24099072 17374048
14:41:02 1918 8192000000 10958173488 11384197120 2002198288 19.640 100 71 139 1 2045829664 22135600 21495776
14:41:12 8618 8192000000 10962538576 11389546496 2003791456 19.653 100 63 126 0 2043650384 21854816 18004112
14:41:29 15274 8192000000 10966186336 11392839680 2003477120 19.650 100 68 136 2 2049062656 26516704 19068832
14:41:53 5479 8192000000 10963480432 11388547072 2004548128 19.659 100 55 110 0 2044120032 23168752 16403152
14:42:07 6035 8192000000 10941603904 11378401280 1996786528 19.597 100 55 110 1 2035719424 22616784 16316112
14:42:21 4391 8192000000 10945903040 11382013952 1998145888 19.608 100 60 117 2 2038489712 23316208 17027616
14:42:46 5866 8192000000 10947762288 11379548160 1993958080 19.575 100 65 130 0 2038947312 25355824 19633408
14:42:59 1111 8192000000 10967770144 11385577472 2002811120 19.645 100 89 179 1 2053551712 24917264 25823328
14:43:08 6651 8192000000 10970418784 11390992384 2003916560 19.654 100 73 145 0 2052421968 26602544 21902864
14:43:22 3233 8192000000 10966741648 11392933888 2002749168 19.644 100 75 148 2 2052112592 27013008 22350416
14:43:32 3471 8192000000 10964821792 11395002368 2002443296 19.642 100 69 138 1 2051480912 28189392 20848224
14:43:52 4191 8192000000 10965707600 11399716864 2005845136 19.669 100 60 119 0 2051796144 28010960 17940048
14:44:05 9515 8192000000 10952070560 11382251520 1994226576 19.577 100 80 158 1 2044073264 26648336 23198352
14:44:26 9977 8192000000 10961946944 11394617344 2000888608 19.630 100 62 123 0 2046826816 27045328 18892880
14:44:43 7962 8192000000 10952355824 11395829760 2001275456 19.633 100 60 116 0 2046109440 27664576 17169408
14:44:59 2076 8192000000 10958150976 11386994688 1983706704 19.494 99 69 138 0 2029644448 25183824 20753920
14:45:08 9231 8192000000 10966937424 11393052672 2001322576 19.633 100 72 141 0 2048493216 25709616 21461024
14:45:25 7253 8192000000 10966080512 11396128768 2002291936 19.641 100 70 140 0 2046782896 24182640 20308320
14:45:41 1882 8192000000 10944168000 11371810816 1979888320 19.464 99 68 132 0 2025240720 25666240 19686160
14:45:51 5033 8192000000 10950274416 11378483200 1985833152 19.511 99 70 140 0 2032586128 24863856 21889120
14:46:14 5817 8192000000 10949005408 11372773376 1956983584 19.282 98 76 148 0 2007429264 28135552 22310128
14:46:29 1892 8192000000 10955107168 11375300608 1986903840 19.519 100 82 164 0 2040764688 29440848 24420000
14:46:38 6029 8192000000 10936152240 11367829504 1964436688 19.341 99 66 130 3 2012867088 27980160 20450240
14:46:52 3906 8192000000 10956142880 11379990528 1971108288 19.394 99 81 162 3 2025986704 30947216 23931200
14:47:03 2761 8192000000 10961160848 11384750080 1988481696 19.532 100 84 167 2 2046268912 32672224 25114992
14:47:13 4143 8192000000 10942044112 11368947712 1967879552 19.369 100 66 132 2 2021803088 33972048 19951488
14:47:25 3093 8192000000 10962311632 11373490176 1981513904 19.477 100 83 165 0 2040713504 34586976 24612624
14:47:35 2565 8192000000 10957416800 11376472064 1977365632 19.444 100 79 159 0 2036177680 35402768 23409280
14:47:46 5394 8192000000 10941667600 11364884480 1967210496 19.363 100 82 160 1 2028092272 36306112 24575664
14:48:02 1347 8192000000 10954024864 11366342656 1968235264 19.371 100 83 165 4 2029299952 35927024 25137664
14:48:11 8154 8192000000 10929470432 11359768576 1962822032 19.328 100 66 132 0 2020826112 37221216 20782864
14:48:28 4258 8192000000 10931496256 11349831680 1947894832 19.210 100 66 130 2 2004081040 35531424 20654784
14:48:40 3712 8192000000 10908225728 11324907520 1929531056 19.063 99 82 162 0 1988922560 35184656 24206848
14:48:50 7356 8192000000 10933703488 11355217920 1955913904 19.274 100 78 155 2 2016952976 36869808 24169264
14:49:09 4725 8192000000 10953532592 11374608384 1968843984 19.376 100 79 155 1 2031691536 39352240 23495312
14:49:22 1316 8192000000 10948798544 11358748672 1954597088 19.263 99 89 179 1 2019273104 37095008 27581008
14:49:31 4266 8192000000 10936836176 11360362496 1959407136 19.301 100 75 147 1 2021580480 38800848 23372496
14:49:42 3396 8192000000 10945487424 11358912512 1960183248 19.307 100 90 177 1 2023877056 37554832 26138976
14:49:54 4412 8192000000 10901236640 11324874752 1917770640 18.969 98 60 120 0 1973560416 36826656 18963120
14:50:06 4389 8192000000 10914999424 11330912256 1923703792 19.017 99 77 154 0 1984760880 37453744 23603344
14:50:23 6331 8192000000 10914207168 11334877184 1940835232 19.153 100 73 146 2 1999109584 35373712 22900640
14:50:37 7015 8192000000 10904650496 11327176704 1905486112 18.870 98 69 138 1 1964123040 37099760 21537168
14:50:50 9342 8192000000 10912434288 11331178496 1920223792 18.989 99 82 162 0 1983823312 38461664 25137856
14:51:09 2971 8192000000 10924427664 11334598656 1930692880 19.072 100 84 168 2 1995239216 38815760 25730576
14:51:18 2304 8192000000 10898623536 11309608960 1924758096 19.025 100 85 170 2 1984222816 33545872 25918848
14:51:31 3548 8192000000 10901438048 11315798016 1909324240 18.901 99 70 140 1 1965278144 34580496 21373408
14:51:45 3004 8192000000 10899049840 11316256768 1912596112 18.927 99 75 147 1 1971572480 36135216 22841152
14:51:56 1421 8192000000 10892225728 11302313984 1885231936 18.707 98 93 186 0 1951947776 36530448 30185392
14:52:05 2765 8192000000 10871925280 11278061568 1876882832 18.640 98 75 150 0 1937655744 37652192 23120720
14:52:17 3208 8192000000 10898374384 11309400064 1914746384 18.945 100 83 165 3 1977658272 36789440 26122448
14:52:29 3126 8192000000 10898984032 11317030912 1922412608 19.006 100 72 142 4 1981628864 36701536 22514720
14:52:40 8969 8192000000 10882988672 11317309440 1919023984 18.979 100 46 92 0 1971062352 37365376 14672992
14:52:59 11353 8192000000 10884318992 11314532352 1920614768 18.992 100 50 100 0 1970350048 34524080 15211200
14:53:23 2017 8192000000 10899144928 11318124544 1927963312 19.051 100 69 136 2 1981642720 32953152 20726256
14:53:39 1556 8192000000 10903509184 11319255040 1931004144 19.075 100 86 173 1 1991749600 33438512 27306944
14:53:47 12869 8192000000 10883344288 11314298880 1920348528 18.990 100 59 118 1 1972699136 34248752 18101856
14:54:09 2467 8192000000 10891098448 11310895104 1921001264 18.995 100 63 126 4 1970246736 29583200 19662272
14:54:19 2940 8192000000 10864088704 11282690048 1884061440 18.698 99 56 110 0 1929531200 28282096 17187664
14:54:30 2758 8192000000 10881473840 11299057664 1911194592 18.916 100 62 123 2 1959036592 28534208 19307792
14:54:40 7093 8192000000 10859651072 11279732736 1873313344 18.611 98 54 108 1 1918746064 29373344 16059376
14:54:59 5594 8192000000 10866177456 11282735104 1879983504 18.665 99 57 112 1 1925558880 28099152 17476224
14:55:12 2686 8192000000 10862228512 11279421440 1898692240 18.816 100 67 134 1 1949161344 28945952 21523152
14:55:24 9166 8192000000 10853771312 11285368832 1886608064 18.718 99 46 91 0 1931028272 30167728 14252480
14:55:45 3362 8192000000 10885000464 11306033152 1914717952 18.945 100 56 110 1 1961731024 29740672 17272400
14:56:01 5367 8192000000 10876441280 11303170048 1904636672 18.864 99 43 85 0 1946113728 28495392 12981664
14:56:15 5549 8192000000 10902119616 11323338752 1934180400 19.100 100 59 116 3 1981853408 30132000 17541008
14:56:29 4670 8192000000 10909295456 11327725568 1939092608 19.140 100 56 113 0 1984132496 28592096 16447792
14:56:40 8606 8192000000 10921482704 11337256960 1948393696 19.214 100 58 114 2 1995991488 29904800 17692992
14:56:56 4952 8192000000 10914576720 11342278656 1956277712 19.276 100 55 110 0 2004147712 30928256 16941744
14:57:10 5957 8192000000 10907583216 11337560064 1946342416 19.197 100 39 74 4 1987293056 28837584 12113056
14:57:23 5038 8192000000 10895285472 11319554048 1919006096 18.979 99 47 94 3 1963947296 30458016 14483184
14:57:36 10269 8192000000 10893557136 11319709696 1920233328 18.989 99 50 100 1 1967471392 31633168 15604896
14:57:54 15697 8192000000 10909718304 11333324800 1935903792 19.114 100 40 80 0 1980744976 31755584 13085600
14:58:25 12538 8192000000 10904198640 11336581120 1942666320 19.168 100 29 58 3 1984360896 32307152 9387424
14:58:50 24768 8192000000 10898467056 11342397440 1923586864 19.016 99 23 46 2 1965161328 33066352 8508112
14:59:21 27335 8192000000 10896107568 11339108352 1918700912 18.976 99 25 50 3 1961908624 34621312 8586400
14:59:57 5835 8192000000 10902098704 11343060992 1937980480 19.131 100 39 78 4 1990401888 38419296 14002112
15:00:19 21417 8192000000 10906332288 11343482880 1924849136 19.026 100 26 52 0 1979812144 44928080 10034928
15:00:53 21757 8192000000 10896691424 11338805248 1914193312 18.940 99 29 58 2 1966491712 41879792 10418608
15:01:30 31877 8192000000 10897586192 11337084928 1932468544 19.087 100 23 45 1 1976463568 36397408 7597616
15:02:08 8296 8192000000 10900953792 11334307840 1941596896 19.159 100 36 70 2 1984210016 30295952 12317168
15:02:27 34744 8192000000 10892193120 11342929920 1937100880 19.124 100 10 20 0 1968990048 28835600 3053568
15:03:22 81519 8192000000 10874891072 11325759488 1890645376 18.751 97 10 19 0 1909511728 16656768 2209584
15:04:57 50536 8192000000 10895580912 11351924736 1956963072 19.282 100 34 68 1 1981296768 14408848 9924848
15:05:55 86773 8192000000 10898386736 11359776768 1940168480 19.148 99 5 10 1 1958426912 16873632 1384800
15:07:28 89553 8192000000 10869474704 11329323008 1906011408 18.875 98 9 18 0 1925184592 17010208 2162976
15:09:04 58751 8192000000 10888664624 11341185024 1936963216 19.123 99 27 53 1 1954076576 9826160 7287200
15:10:14 62717 8192000000 10893448048 11332268032 1923248960 19.013 98 48 97 1 1944621584 6758912 14613712
15:11:24 2960 8192000000 10901262144 11336671232 1958187760 19.292 100 53 106 0 1982248752 8845168 15215824
15:11:34 32435 8192000000 10903710368 11348848640 1960934208 19.313 100 39 78 0 1985505696 14071856 10499632
15:12:18 52508 8192000000 10907488928 11357839360 1966225536 19.355 100 32 63 2 1985227504 10203872 8798096
15:13:20 52108 8192000000 10900259776 11365314560 1963231600 19.332 100 18 37 0 1981004704 12241952 5531152
15:14:19 57378 8192000000 10889359840 11343732736 1934552560 19.103 98 45 88 2 1956123808 9426208 12145040
15:15:28 64350 8192000000 10898437824 11353530368 1942712432 19.168 99 13 26 1 1952801232 6492736 3596064
15:16:45 24324 8192000000 10887536576 11348553728 1961421456 19.317 100 13 26 0 1974431680 9422400 3587824
15:17:15 117692 8192000000 10911026688 11383595008 1979205104 19.458 100 14 29 1 1995243984 12119824 3919056
15:19:19 77670 8192000000 10917488976 11391033344 1973456944 19.413 99 9 19 0 1991499856 15349872 2693040
15:21:05 123603 8192000000 10906193040 11372773376 1969365072 19.380 99 20 40 1 1989833376 14301808 6166496
15:23:27 61095 8192000000 10907048320 11380789248 1970355520 19.388 99 22 44 1 1988148688 11856336 5936832
15:24:35 34389 8192000000 10897838992 11373977600 1966052832 19.354 99 19 38 1 1983370336 12026656 5290848
15:25:17 20912 8192000000 10902198224 11378270208 1984224960 19.498 100 15 30 1 1998346720 9991024 4130736
15:25:46 18283 8192000000 10930149728 11384909824 1992286256 19.562 100 43 87 2 2013881328 9246080 12348992
15:26:12 27744 8192000000 10918109696 11376091136 1954202080 19.260 98 31 62 1 1975747776 12796768 8748928
15:26:54 66526 8192000000 10883656640 11361411072 1949359856 19.221 98 24 47 0 1970676256 14408544 6907856
15:28:19 93896 8192000000 10902982608 11383599104 1975173216 19.426 100 23 44 0 1996855856 15238672 6443968
15:30:00 53535 8192000000 10907250560 11390722048 1985392752 19.507 100 11 22 1 1997276304 8314816 3568736
15:30:59 55932 8192000000 10918550368 11400241152 1973394304 19.412 99 15 30 0 1988165376 10808336 3962736
15:32:06 86435 8192000000 10925642960 11413753856 1978113504 19.450 99 18 36 0 2003458992 20223632 5121856
15:33:40 65468 8192000000 10907127728 11375910912 1934724400 19.105 97 11 22 1 1951353840 13718128 2911312
15:34:53 41613 8192000000 10896876576 11366985728 1911135968 18.916 96 24 48 2 1927589872 10063824 6390080
15:35:49 39983 8192000000 10896680112 11365289984 1926685296 19.040 97 19 38 1 1943974384 11791072 5498016
15:36:37 76240 8192000000 10872445344 11351711744 1876861584 18.640 95 21 41 0 1894574064 11526960 6185520
15:38:00 55698 8192000000 10843933632 11307212800 1787984288 17.915 91 15 30 1 1800068672 8039184 4045200
15:39:02 15224 8192000000 10881051504 11328151552 1900829120 18.833 98 49 98 1 1930419952 16095184 13495648
15:39:27 28494 8192000000 10877857504 11321417728 1879591872 18.662 97 54 108 1 1909457376 14174944 15690560
15:40:05 84099 8192000000 10864717568 11336318976 1895392848 18.789 98 36 72 0 1923455776 18050832 10012096
15:41:35 54475 8192000000 10870371856 11323744256 1851875552 18.437 95 19 37 1 1871671488 13816608 5979328
15:42:49 82712 8192000000 10850031712 11314376704 1818448928 18.165 94 18 37 2 1836911776 13448816 5014032
15:44:23 57408 8192000000 10847343872 11311935488 1855458768 18.466 96 30 60 0 1878108128 14022288 8627072
15:45:35 91955 8192000000 10841666272 11304742912 1910946320 18.914 100 15 30 1 1926955248 11465104 4543824
15:47:14 60408 8192000000 10848415808 11316797440 1852985984 18.446 96 32 62 0 1878804544 17029024 8789536
15:48:20 72691 8192000000 10823004640 11302756352 1839490896 18.337 96 12 24 1 1859210320 16575312 3144112
15:49:41 4920 8192000000 10811496704 11288690688 1878739024 18.655 99 14 28 0 1897758640 15155744 3863872
15:49:55 11622 8192000000 10816857264 11291381760 1896962144 18.802 100 17 34 1 1912080736 10011104 5107488
15:50:27 32452 8192000000 10849904784 11319218176 1916340256 18.958 100 23 46 1 1932252864 9786672 6125936
15:51:09 38723 8192000000 10843569152 11309240320 1894098992 18.779 98 28 56 1 1917863680 16214048 7550640
15:51:56 84984 8192000000 10859998832 11329970176 1891302640 18.756 98 22 44 2 1914099248 16048608 6748000
15:53:31 54924 8192000000 10865613808 11337007104 1937041744 19.123 100 26 52 2 1957250704 12213680 7995280
15:54:44 36510 8192000000 10852291632 11338121216 1934775712 19.105 100 10 20 0 1948639584 10807984 3055888
15:55:27 23539 8192000000 10843877536 11331096576 1917367232 18.966 99 10 20 0 1930733792 10495136 2871424
15:55:59 32530 8192000000 10843654112 11319214080 1910467120 18.910 99 7 12 1 1922258448 9939760 1851568
15:56:37 48387 8192000000 10849300096 11307122688 1891319216 18.756 98 17 34 0 1906114784 9409616 5385952
15:57:42 7293 8192000000 10855798704 11308027904 1916488032 18.959 99 47 91 1 1935597360 5708192 13401136
15:57:56 19096 8192000000 10840666368 11301351424 1915087072 18.947 99 30 61 0 1932857008 9272352 8497584
15:58:29 82015 8192000000 10846572272 11326922752 1914840064 18.945 99 11 22 0 1925450672 7619056 2991552
16:00:07 64761 8192000000 10862871424 11347394560 1938562176 19.135 100 5 10 0 1949586256 9839424 1184656
16:01:18 59153 8192000000 10891720976 11361886208 1939195968 19.140 99 12 24 0 1952545024 10438224 2910832
16:02:24 70342 8192000000 10885059904 11348783104 1921663728 19.000 98 17 35 0 1936012608 9266640 5082240
16:03:43 38329 8192000000 10903337408 11364573184 1942521888 19.167 99 15 30 1 1958634512 12676592 3436032
16:04:28 38981 8192000000 10908243616 11368603648 1955166560 19.268 99 23 46 1 1970378256 8956944 6254752
16:05:14 57858 8192000000 10909327872 11397660672 1988322944 19.531 100 34 68 1 2013747776 15954000 9470832
16:06:35 65130 8192000000 10893614080 11370029056 1938494400 19.135 98 13 26 1 1959765760 16442192 4829168
16:07:47 56369 8192000000 10931452048 11382099968 1966180544 19.355 99 27 54 3 1982996336 9196640 7619152
16:08:53 45768 8192000000 10924265296 11391680512 1953447040 19.254 98 45 88 1 1977093408 11113808 12532560
16:09:46 113021 8192000000 10913131600 11372146688 1943562672 19.175 98 30 60 1 1963185584 11502272 8120640
16:11:49 27679 8192000000 10928540064 11379294208 1949477888 19.222 98 57 113 1 1975337264 9184512 16674864
16:12:23 27283 8192000000 10939874512 11400355840 1987939792 19.528 100 46 92 2 2020435104 19961296 12534016
16:14:00 81290 8192000000 10916712688 11398582272 1969155296 19.379 99 18 35 1 1985591792 11211120 5225376
16:15:35 100624 8192000000 10912888928 11375116288 1913290256 18.933 96 20 40 0 1931731200 12374320 6066624
16:17:22 89187 8192000000 10869471136 11342131200 1943842736 19.177 98 30 60 1 1964558896 11498144 9218016
16:18:57 58730 8192000000 10905839008 11394752512 1984577264 19.501 100 10 20 0 2001094976 13790304 2727408
16:20:09 31324 8192000000 10899982144 11385888768 1965329600 19.348 99 9 18 0 1984244352 16082656 2832096
16:20:47 27645 8192000000 10902626640 11387211776 1962811968 19.328 99 12 25 2 1980962336 14820736 3329632
16:21:21 36437 8192000000 10908883088 11393781760 1982664384 19.486 100 19 38 1 2003900528 15215264 6020880
16:22:06 56737 8192000000 10895803760 11384037376 1963049360 19.330 99 10 20 1 1979776192 13963088 2763744
16:23:51 65875 8192000000 10912206272 11391696896 1946349104 19.197 98 12 24 1 1965865600 15434768 4081728
16:25:03 65922 8192000000 10888444336 11374186496 1884683600 18.703 95 16 32 0 1900105856 10582176 4840080
16:26:15 38217 8192000000 10881986384 11350441984 1884483296 18.701 95 28 54 1 1902139808 10247184 7409328
16:27:00 84400 8192000000 10905977792 11381800960 1947827600 19.209 99 24 48 2 1968815712 14471424 6516688
16:28:32 54740 8192000000 10911873456 11377332224 1896875984 18.801 96 12 24 0 1911810080 11738384 3195712
16:29:36 73786 8192000000 10905587600 11373072384 1942273280 19.165 98 19 38 1 1961070784 13534368 5263136
16:31:03 16290 8192000000 9213277696 9470005248 365770016 4.274 19 3 6 1 379688496 13016112 902368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 19-02-2021 16:32:17 to 19-02-2021 16:32:51.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-02-2021 16:32:51 to 19-02-2021 16:32:53.

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          238323
MON$OLDEST_ACTIVE               238614
MON$OLDEST_SNAPSHOT             238614
MON$NEXT_TRANSACTION            238614
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                       2018112
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Fri Feb 19 16:31:21 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Fri Feb 19 16:31:21 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

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