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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17249824 kB
MemAvailable 31595552 kB
Buffers 0 kB
Cached 14414460 kB
SwapCached 1944 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-01 01:27:02
DTS_END                         2020-12-01 01:27:02.6420
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/59544
TRN_ID                          239518
ATT_ID                          646
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: 9697.44 22672 1163693
customer order: creation 171.13 345 20536
customer order: refuse 14.48 370 1738
order to supplier: creation 46.17 1258 5540
order to supplier: removal 3.73 103523 448
invoice (draft): creation 44.55 3222 5346
invoice (draft): removal 57.62 718 6914
invoice accept: apply 40.85 18471 4902
invoice accept: cancel 53.18 855 6381
customer reserve: creation 3765.03 182 451803
customer reserve: removal 5198.52 58 623823
realization accept: apply 84.01 183 10081
realization accept: cancel 88.48 106 10617
payment from customer: creation 59.43 114 7132
payment from customer: removal 5.66 81 679
payment to supplier: creation 48.05 142 5766
payment to supplier: removal 3.57 83 428
service: total inventory turnovers 5.43 1047 652
service: total monetary turnovers 6.69 39 803
service: aggregate perf. data 0.83 19534 100
service: refresh index statistics 0.03 303113 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-12-2020 01:27:58 to 01-12-2020 01:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8063
TEST_TIME 2 6273
TEST_TIME 3 6763
TEST_TIME 4 6619
TEST_TIME 5 6355
TEST_TIME 6 5979
TEST_TIME 7 6229
TEST_TIME 8 6542
TEST_TIME 9 6519
TEST_TIME 10 6931
TEST_TIME 11 6893
TEST_TIME 12 7199
TEST_TIME 13 7681
TEST_TIME 14 7610
TEST_TIME 15 7556
TEST_TIME 16 7635
TEST_TIME 17 7956
TEST_TIME 18 8180
TEST_TIME 19 8187
TEST_TIME 20 8620
TEST_TIME 21 9097
TEST_TIME 22 9420
TEST_TIME 23 9994
TEST_TIME 24 10518
TEST_TIME 25 10705
TEST_TIME 26 11523
TEST_TIME 27 11351
TEST_TIME 28 11121
TEST_TIME 29 11193
TEST_TIME 30 11090
TEST_TIME 31 10883
TEST_TIME 32 10995
TEST_TIME 33 10907
TEST_TIME 34 10738
TEST_TIME 35 10634
TEST_TIME 36 10613
TEST_TIME 37 10736
TEST_TIME 38 10643
TEST_TIME 39 10524
TEST_TIME 40 10513
TEST_TIME 41 10394
TEST_TIME 42 10397
TEST_TIME 43 10373
TEST_TIME 44 10372
TEST_TIME 45 10480
TEST_TIME 46 10546
TEST_TIME 47 10488
TEST_TIME 48 10317
TEST_TIME 49 10155
TEST_TIME 50 10197
TEST_TIME 51 10216
TEST_TIME 52 10114
TEST_TIME 53 10056
TEST_TIME 54 9968
TEST_TIME 55 9925
TEST_TIME 56 9922
TEST_TIME 57 10200
TEST_TIME 58 10103
TEST_TIME 59 10043
TEST_TIME 60 9989
TEST_TIME 61 9952
TEST_TIME 62 9894
TEST_TIME 63 9933
TEST_TIME 64 9905
TEST_TIME 65 9928
TEST_TIME 66 10039
TEST_TIME 67 10050
TEST_TIME 68 10016
TEST_TIME 69 10045
TEST_TIME 70 9996
TEST_TIME 71 10001
TEST_TIME 72 10038
TEST_TIME 73 10113
TEST_TIME 74 10115
TEST_TIME 75 10109
TEST_TIME 76 10088
TEST_TIME 77 10001
TEST_TIME 78 9973
TEST_TIME 79 9952
TEST_TIME 80 9919
TEST_TIME 81 9924
TEST_TIME 82 9886
TEST_TIME 83 9841
TEST_TIME 84 9777
TEST_TIME 85 9746
TEST_TIME 86 9709
TEST_TIME 87 9623
TEST_TIME 88 9724
TEST_TIME 89 9746
TEST_TIME 90 9762
TEST_TIME 91 9744
TEST_TIME 92 9745
TEST_TIME 93 9737
TEST_TIME 94 9821
TEST_TIME 95 9978
TEST_TIME 96 9931
TEST_TIME 97 9914
TEST_TIME 98 9932
TEST_TIME 99 9970
TEST_TIME 100 9993
TEST_TIME 101 9964
TEST_TIME 102 9894
TEST_TIME 103 9883
TEST_TIME 104 9819
TEST_TIME 105 9809
TEST_TIME 106 9776
TEST_TIME 107 9712
TEST_TIME 108 9670
TEST_TIME 109 9677
TEST_TIME 110 9709
TEST_TIME 111 9696
TEST_TIME 112 9671
TEST_TIME 113 9648
TEST_TIME 114 9632
TEST_TIME 115 9642
TEST_TIME 116 9634
TEST_TIME 117 9733
TEST_TIME 118 9745
TEST_TIME 119 9782
TEST_TIME 120 9701

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-12-2020 01:28:02 to 01-12-2020 01:28:05.

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 1584763 1584763 0 0.00 0 20686 6 0 0
doc_list_biud 1584762 1584762 0 0.00 0 49716 29 0 0
sp_add_invoice_to_stock 5051 4902 149 2.94 34 164947 18472 0 149
sp_cancel_adding_invoice 6381 6381 0 0.00 5 60743 856 0 0
sp_cancel_client_order 1738 1738 0 0.00 5 10372 371 0 0
sp_cancel_customer_reserve 623823 623823 0 0.00 1 49718 58 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 3 7270 81 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 3508 83 0 0
sp_cancel_supplier_invoice 6922 6914 8 0.11 2 23318 718 0 8
sp_cancel_supplier_order 448 448 0 0.00 8 1105598 103524 0 0
sp_cancel_write_off 10617 10617 0 0.00 1 11680 107 0 0
sp_client_order 20536 20536 0 0.00 4 17041 345 0 0
sp_customer_reserve 451803 451803 0 0.00 0 98712 182 0 0
sp_fill_shopping_cart 31420 31420 0 0.00 1 13011 37 0 0
sp_fill_shopping_cart_clo_res 451799 451799 0 0.00 0 20440 14 0 0
sp_get_clo_for_invoice 4896 4896 0 0.00 0 32378 285 0 0
sp_kill_cost_storno 18105 18105 0 0.00 0 11636 61 0 0
sp_kill_qstorno_ret_qs2qd 1265625 1265625 0 0.00 0 49709 31 0 0
sp_kill_qty_storno 664898 664898 0 0.00 0 49716 67 0 0
sp_lock_selected_doc 20731 20731 0 0.00 0 8192 5 0 0
sp_make_cost_storno 27875 27875 0 0.00 0 20662 56 0 0
sp_multiply_rows_for_pdistr 27875 27875 0 0.00 0 7454 34 0 0
sp_multiply_rows_for_qdistr 20536 20536 0 0.00 0 17023 161 0 0
sp_pay_from_customer 7132 7132 0 0.00 4 10478 114 0 0
sp_pay_to_supplier 5766 5766 0 0.00 4 21017 142 0 0
sp_payment_common 12897 12897 0 0.00 1 10474 30 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 10367 340 0 0
sp_qd_handle_on_invoice_upd_sts 11277 11277 0 0.00 0 20533 365 0 0
sp_qd_handle_on_reserve_upd_sts 10081 10081 0 0.00 0 15572 58 0 0
sp_reserve_write_off 10081 10081 0 0.00 6 16175 183 0 0
sp_supplier_invoice 5346 5346 0 0.00 6 81019 3223 0 0
sp_supplier_order 5540 5540 0 0.00 5 23297 1258 0 0
srv_aggregate_perf_data 100 100 0 0.00 2505 188789 19534 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1151 140005 30576 0 0
srv_find_qd_qs_mism 1117830 1117830 0 0.00 0 16644 5 0 0
srv_make_invnt_saldo 652 652 0 0.00 31 81575 1047 0 0
srv_make_money_saldo 803 803 0 0.00 0 3581 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 127638 439972 303113 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4902 4902 0 0.00 0 10244 180 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 8017 121 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 3935 17 0 0
t$perf-norm:sp_cancel_customer_reserve 657 657 0 0.00 0 1368 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 723 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 562 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 7882 35 0 0
t$perf-norm:sp_cancel_supplier_order 448 448 0 0.00 0 24160 1766 0 0
t$perf-norm:sp_cancel_write_off 977 977 0 0.00 0 2959 10 0 0
t$perf-norm:sp_client_order 20536 20536 0 0.00 0 10169 18 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 642 6 0 0
t$perf-norm:sp_pay_from_customer 7132 7132 0 0.00 0 4406 8 0 0
t$perf-norm:sp_pay_to_supplier 5766 5766 0 0.00 0 5796 9 0 0
t$perf-norm:sp_reserve_write_off 10081 10081 0 0.00 0 6650 12 0 0
t$perf-norm:sp_supplier_invoice 5346 5346 0 0.00 0 6249 23 0 0
t$perf-norm:sp_supplier_order 5540 5540 0 0.00 0 4484 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 335 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 2859 22 0 0
t$perf-norm:srv_make_invnt_saldo 652 652 0 0.00 0 703 22 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 706 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10090 9792 298 2.95 0 4080 18 0 298
v_all_customers 37402 37402 0 0.00 0 134 1 0 0
v_all_suppliers 30206 30206 0 0.00 0 61 1 0 0
v_all_wares 41072 41072 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 429 6 0 0
v_cancel_client_order 3476 3476 0 0.00 0 4942 6 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 4796 7 0 0
v_cancel_customer_reserve 1314 1314 0 0.00 0 1707 7 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 3496 15 0 0
v_cancel_supplier_invoice 830 814 16 1.92 0 3521 26 0 16
v_cancel_supplier_order 896 896 0 0.00 0 3242 13 0 0
v_cancel_write_off 1954 1954 0 0.00 0 4176 19 0 0
v_max_id_clo_ord 5539 5539 0 0.00 0 11707 4 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 9393 19 0 0
v_max_id_ord_sup 5345 5345 0 0.00 0 7105 5 0 0
v_max_non_paid_invoice 1547 1547 0 0.00 0 2025 5 0 0
v_max_non_paid_realizn 3786 3786 0 0.00 0 5842 7 0 0
v_min_id_clo_ord 5539 5539 0 0.00 0 13008 9 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 6894 17 0 0
v_min_id_ord_sup 5345 5345 0 0.00 0 11508 11 0 0
v_min_non_paid_invoice 5766 5766 0 0.00 0 10035 17 0 0
v_min_non_paid_realizn 7131 7131 0 0.00 0 8512 20 0 0
v_our_firm 10360 10360 0 0.00 0 21 1 0 0
v_reserve_write_off 20162 20162 0 0.00 0 8999 8 0 0
x_lock_depdocs_on_canc_invoice 12888 12888 0 0.00 0 31626 117 0 0
x_lock_depdocs_on_canc_sup_ord 448 448 0 0.00 0 7538 357 0 0
x_make_qstorno_1000_1200 5540 5540 0 0.00 2 23272 1170 0 0
x_make_qstorno_1200_2000 5346 5346 0 0.00 3 79003 3097 0 0
x_make_qstorno_2100_3300 451803 451803 0 0.00 0 98692 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-12-2020 01:28:06 to 01-12-2020 01:28:10.

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
22:57:06 5 8192000000 8800799232 8812003328 6918096 0.084 2 1 2 0 7037472 56816 62560
22:57:12 15763 8192000000 10230476608 10539655168 873803584 9.638 68 49 98 0 892100608 2513728 15783296
22:57:39 31467 8192000000 10341798720 10657390592 1389657872 14.503 100 87 174 1 1423520816 4971600 28891344
22:58:19 11764 8192000000 10358469440 10679640064 1418454864 14.759 100 88 176 0 1453560560 6420592 28685104
22:58:44 33316 8192000000 10416699408 10740748288 1447658096 15.017 100 83 166 0 1482484464 7570608 27255760
22:59:28 15106 8192000000 10428331632 10757992448 1480357664 15.305 100 86 171 0 1516824736 8127440 28339632
22:59:54 20357 8192000000 10444573936 10776236032 1498798528 15.466 100 94 188 0 1537928576 8890880 30239168
23:00:25 24813 8192000000 10462971248 10799730688 1514580000 15.603 100 89 178 0 1552812048 9359040 28873008
23:01:02 9184 8192000000 10477965056 10818977792 1532649264 15.760 100 75 150 0 1565337584 9065728 23622592
23:01:19 18739 8192000000 10499449856 10842595328 1552928976 15.935 100 83 166 2 1588400192 9831120 25640096
23:01:58 7919 8192000000 10519457552 10872320000 1583351872 16.197 100 80 160 0 1618025344 9989840 24683632
23:02:13 13273 8192000000 10539700768 10893492224 1593564304 16.284 100 69 138 2 1625013440 10392224 21056912
23:02:36 11249 8192000000 10558954864 10917179392 1619561408 16.506 100 79 158 1 1654132528 11224864 23346256
23:03:01 11072 8192000000 10586604768 10948673536 1635883120 16.645 100 75 150 0 1670132512 12350512 21898880
23:03:22 11017 8192000000 10609252224 10970050560 1662175200 16.867 100 89 178 0 1701710208 13052416 26482592
23:03:42 6438 8192000000 10605478496 10978078720 1674318480 16.970 100 77 154 0 1710148928 12814144 23016304
23:03:55 11056 8192000000 10638447840 11006042112 1691906224 17.117 100 78 156 1 1726800720 12642544 22251952
23:04:14 8424 8192000000 10652943600 11020947456 1707435392 17.247 100 83 164 1 1744341872 13311472 23595008
23:04:29 5512 8192000000 10652694208 11025600512 1713239152 17.296 100 73 147 1 1746612496 12877232 20496112
23:04:42 5559 8192000000 10667421504 11040108544 1724664496 17.391 100 82 164 1 1761373712 13471952 23237264
23:04:56 6500 8192000000 10687530416 11061981184 1745496352 17.564 100 86 172 0 1784052096 13385232 25170512
23:05:09 7018 8192000000 10690993840 11065446400 1749320304 17.596 100 81 162 0 1786554480 14585952 22648224
23:05:24 6013 8192000000 10703214624 11081834496 1760170816 17.686 100 82 165 1 1797843840 14837680 22835344
23:05:38 3849 8192000000 10710750640 11084095488 1771612000 17.780 100 89 176 1 1810580816 14314064 24654752
23:05:48 3495 8192000000 10715248944 11094994944 1777248544 17.827 100 89 172 1 1815364784 14550560 23565680
23:05:59 3651 8192000000 10733836848 11109904384 1783319232 17.877 100 84 169 3 1819337392 13277184 22740976
23:06:09 3930 8192000000 10729451232 11112673280 1796616608 17.986 100 82 164 0 1832206992 13169472 22420912
23:06:20 4650 8192000000 10734177456 11117518848 1798569392 18.002 100 84 167 0 1834614256 12735568 23309296
23:06:32 4276 8192000000 10740732832 11124097024 1806748032 18.069 100 86 173 2 1844810400 14307632 23754736
23:06:43 3380 8192000000 10763566592 11146792960 1821340448 18.189 100 89 179 3 1859750976 13824992 24585536
23:06:54 2686 8192000000 10768434672 11152629760 1829260224 18.253 100 85 170 0 1867382448 14996464 23125760
23:07:03 2602 8192000000 10776803296 11159064576 1831665232 18.273 100 89 174 0 1870671104 14245568 24760304
23:07:12 1969 8192000000 10773399232 11162251264 1837871808 18.323 100 89 178 1 1875706928 13088544 24746576
23:07:20 2530 8192000000 10778362000 11162836992 1839056560 18.333 100 81 163 4 1873689296 12006240 22626496
23:07:30 1802 8192000000 10796878832 11183484928 1849270160 18.416 100 93 183 2 1888302128 12446144 26585824
23:07:38 1839 8192000000 10793083072 11180343296 1854386992 18.458 100 91 180 2 1892970016 12917616 25665408
23:07:46 1187 8192000000 10805710240 11190812672 1855875040 18.470 100 95 190 2 1896200288 13852384 26472864
23:07:53 1204 8192000000 10802992400 11191459840 1859410672 18.499 100 93 186 1 1900573264 14601200 26561392
23:08:01 9425 8192000000 10790872640 11188318208 1859508368 18.499 100 75 151 1 1891646496 10805744 21332384
23:08:17 10712 8192000000 10804486064 11196731392 1863624608 18.533 100 82 164 1 1900114032 12458752 24030672
23:08:34 1074 8192000000 10816469840 11204665344 1871611888 18.597 100 96 193 1 1912105920 13524000 26970032
23:08:41 21160 8192000000 10769495216 11190681600 1861038304 18.512 100 40 80 1 1880634240 8491296 11104640
23:09:10 5743 8192000000 10778049200 11199741952 1861220912 18.513 100 31 62 1 1881335856 12062352 8052592
23:09:24 5952 8192000000 10777922704 11197616128 1863785696 18.534 100 27 54 2 1878511200 7428576 7296928
23:09:36 2882 8192000000 10791709248 11199885312 1873654224 18.614 100 57 114 0 1897883824 7833808 16395792
23:09:46 8772 8192000000 10774521088 11206094848 1867549008 18.564 100 22 44 0 1884625648 11147184 5929456
23:10:02 7003 8192000000 10791242400 11211546624 1874543488 18.621 100 42 84 1 1894582240 8305136 11733616
23:10:16 12690 8192000000 10767963536 11205812224 1874926608 18.624 100 25 50 2 1889073520 7216160 6930752
23:10:36 9964 8192000000 10782396016 11212312576 1876184240 18.634 100 24 47 0 1889853104 6090672 7578192
23:10:56 11921 8192000000 10779040432 11213795328 1879292800 18.659 100 21 40 0 1891936640 6689088 5954752
23:11:15 9797 8192000000 10785675680 11216216064 1884536464 18.702 100 25 51 2 1897073216 5699952 6836800
23:11:34 9986 8192000000 10782712112 11218419712 1880057360 18.666 100 15 30 1 1889707792 5521936 4128496
23:11:51 7905 8192000000 10794918304 11225473024 1886075136 18.714 100 18 36 1 1897574448 6465840 5033472
23:12:06 70734 8192000000 10800851760 11234680832 1892908768 18.769 100 30 59 1 1906629360 5292112 8428480
23:13:29 9967 8192000000 10810946752 11244732416 1897897616 18.809 100 30 60 1 1913777072 7726128 8153328
23:13:46 4427 8192000000 10818247072 11250839552 1897231968 18.804 100 27 54 0 1915448912 10988160 7228784
23:13:57 6375 8192000000 10808892688 11246551040 1900626224 18.831 100 36 70 0 1917689936 6626544 10437168
23:14:11 4248 8192000000 10815816176 11247521792 1901526048 18.839 100 41 83 2 1919302800 5853312 11923440
23:14:24 6653 8192000000 10805769872 11246088192 1898471504 18.814 100 16 32 3 1908567264 5928208 4167552
23:14:37 10751 8192000000 10820236528 11252543488 1904453152 18.862 100 23 46 2 1916178720 5430992 6294576
23:14:57 7777 8192000000 10819009152 11253022720 1903048576 18.851 100 18 36 2 1914417984 6011968 5357440
23:15:21 10132 8192000000 10812792992 11246329856 1886618608 18.719 99 20 40 2 1898522160 5207120 6696432
23:15:37 6027 8192000000 10813029392 11248750592 1885841632 18.712 99 23 45 1 1898734608 6184592 6708384
23:15:49 5808 8192000000 10816981296 11249098752 1899404592 18.822 100 21 40 2 1911033872 5621184 6008096
23:16:01 12480 8192000000 10795651088 11232604160 1866252016 18.554 98 18 36 1 1876781056 5098592 5430448
23:16:21 9726 8192000000 10783797856 11218735104 1859082688 18.496 98 21 41 3 1870667408 5184000 6400720
23:17:00 43579 8192000000 10799800240 11237031936 1859304800 18.498 98 36 70 1 1875490368 5952064 10233504
23:17:50 8631 8192000000 10784665936 11221757952 1834818160 18.299 97 22 44 1 1847237824 5756816 6662848
23:18:05 5098 8192000000 10789670816 11217084416 1858544320 18.491 99 27 53 5 1873653376 6127680 8981376
23:18:17 4676 8192000000 10771838864 11188428800 1814500960 18.133 97 33 66 2 1830523632 6707712 9314960
23:18:30 4173 8192000000 10737631568 11157164032 1789201840 17.925 97 35 71 1 1810524768 11905088 9417840
23:18:40 6528 8192000000 10746175408 11165507584 1786244848 17.901 97 28 57 1 1801181984 7428864 7508272
23:18:54 4507 8192000000 10742944272 11160547328 1822806800 18.201 100 31 62 2 1837615680 5699056 9109824
23:19:04 6875 8192000000 10686575760 11105730560 1767743936 17.748 97 19 38 0 1783174176 10276544 5153696
23:19:18 8366 8192000000 10694916672 11104796672 1695867424 17.150 94 21 41 0 1707015344 5279120 5868800
23:19:38 10149 8192000000 10678190080 11092774912 1676602448 16.989 94 27 53 2 1690948960 6019136 8327376
23:19:55 7501 8192000000 10673468032 11088990208 1720357760 17.355 97 29 58 2 1734518528 6080368 8080400
23:20:09 7797 8192000000 10670892032 11080232960 1741026672 17.527 98 25 51 1 1754222144 5399088 7796384
23:20:26 12103 8192000000 10691449408 11100606464 1704723792 17.225 95 26 52 3 1718083488 5325664 8034032
23:20:46 10291 8192000000 10715657888 11137040384 1762562384 17.706 98 18 35 1 1773224080 5066336 5595360
23:21:04 66718 8192000000 10731746816 11158016000 1803906000 18.046 99 27 54 0 1818176224 5461536 8808688
23:22:17 8746 8192000000 10730484720 11156549632 1808840000 18.086 99 23 45 3 1821340496 5599872 6900624
23:22:32 14782 8192000000 10763694608 11183349760 1835738448 18.306 100 31 62 2 1850345968 6748320 7859200
23:22:55 4678 8192000000 10760528304 11167178752 1806325584 18.066 98 54 108 1 1828937968 6869584 15742800
23:23:08 6544 8192000000 10749234768 11172364288 1837955584 18.324 100 34 63 0 1852199360 5230288 9013488
23:23:25 6770 8192000000 10743932672 11177320448 1842630336 18.362 100 22 43 2 1854556560 5527136 6399088
23:23:39 9120 8192000000 10766957520 11189800960 1850286352 18.424 100 23 46 2 1862735392 5821424 6627616
23:23:57 8707 8192000000 10763652640 11194044416 1852898320 18.446 100 19 38 2 1863666928 4992048 5776560
23:24:12 8992 8192000000 10766491520 11195027456 1853649968 18.452 100 16 31 1 1863184448 5372624 4161856
23:24:29 9439 8192000000 10775515424 11203715072 1860692768 18.509 100 21 42 0 1873240512 5718464 6829280
23:24:44 7849 8192000000 10773640880 11206352896 1863415568 18.531 100 17 34 0 1874235712 6006000 4814144
23:24:59 10310 8192000000 10782117280 11209859072 1865980896 18.552 100 19 38 0 1877177392 4906912 6289584
23:25:16 9115 8192000000 10786255808 11215392768 1870439616 18.588 100 22 44 1 1882431584 5849872 6142096
23:25:32 27143 8192000000 10783732208 11219607552 1872726912 18.606 100 33 67 0 1888270336 6195872 9347552
23:26:05 45620 8192000000 10787320544 11223420928 1874280304 18.619 100 25 49 2 1891913472 10520000 7113168
23:26:59 24432 8192000000 10812258192 11232628736 1887101616 18.722 100 24 47 3 1897584304 4525136 5957552
23:27:33 18729 8192000000 10845447008 11261161472 1910133664 18.908 100 59 116 2 1935902400 9207344 16561392
23:27:59 9975 8192000000 10849980048 11266023424 1914803744 18.945 100 42 82 3 1937545712 10689664 12052304
23:28:17 7989 8192000000 10858669328 11278311424 1923071248 19.011 100 59 118 0 1951857104 12411200 16374656
23:28:33 15859 8192000000 10865874448 11286937600 1928229968 19.053 100 57 112 1 1959847072 16718752 14898352
23:28:59 7973 8192000000 10868753328 11287748608 1933709152 19.097 100 48 96 1 1958330128 11148544 13472432
23:29:23 38788 8192000000 10873026752 11304480768 1945408848 19.190 100 52 104 2 1973317568 12844912 15063808
23:30:33 7353 8192000000 10882145696 11316744192 1951360096 19.237 100 43 86 1 1982116864 17375632 13381136
23:30:48 24310 8192000000 10883765520 11323437056 1959925824 19.305 100 42 85 0 1985536688 12641536 12969328
23:31:27 28903 8192000000 10910391968 11339632640 1965412624 19.349 100 42 83 1 1991095376 13514272 12168480
23:32:12 25101 8192000000 10907602672 11344236544 1970805808 19.392 100 39 78 1 1997759328 15306064 11647456
23:33:04 18570 8192000000 10918743696 11357003776 1979219648 19.459 100 42 84 0 2010323152 18296816 12806688
23:33:40 4157 8192000000 10921106960 11356020736 1965673856 19.351 99 49 95 1 2001098208 21291728 14132624
23:34:00 12568 8192000000 10924244432 11361538048 1981501152 19.477 100 39 76 1 2012826048 20514208 10810688
23:34:20 4162 8192000000 10942299056 11372707840 1992445024 19.563 100 68 136 0 2033680112 21266512 19968576
23:34:32 7737 8192000000 10951528672 11377295360 1995883184 19.590 100 68 134 0 2036998432 22827120 18288128
23:34:46 3686 8192000000 10959848000 11384475648 2001788960 19.637 100 74 146 1 2047059536 24155920 21114656
23:34:56 7583 8192000000 10948710496 11379249152 1984428208 19.500 99 62 124 0 2028009856 24510752 19070896
23:35:11 3430 8192000000 10951818032 11376963584 1986525408 19.516 99 79 159 2 2034235200 24816480 22893312
23:35:21 20876 8192000000 10948094432 11379286016 1982397216 19.484 99 61 122 0 2025769280 25429904 17942160
23:35:53 4565 8192000000 10948512896 11385245696 1998594256 19.612 100 56 109 0 2041845008 26869216 16381536
23:36:04 3907 8192000000 10947807328 11383771136 1998924288 19.614 100 47 94 2 2038849840 25279488 14646064
23:36:21 2837 8192000000 10956052400 11384102912 1987211360 19.522 99 70 139 3 2033712256 25419984 21080912
23:36:32 4973 8192000000 10946421360 11379281920 1993039120 19.568 100 67 134 1 2040854064 26870256 20944688
23:36:44 9582 8192000000 10962001040 11393179648 1999079952 19.615 100 55 110 1 2044833776 30238400 15515424
23:37:01 4084 8192000000 10968575088 11398938624 2008263104 19.688 100 70 139 0 2060802208 31974160 20564944
23:37:13 7490 8192000000 10967985024 11399757824 2007819856 19.684 100 60 119 0 2059261808 32972976 18468976
23:37:29 3656 8192000000 10967850912 11400822784 2005745152 19.668 100 63 126 1 2058779120 32854960 20179008
23:37:41 7089 8192000000 10955803136 11393359872 2001330064 19.633 100 60 116 1 2047694832 29273792 17090976
23:37:55 4308 8192000000 10971591792 11404275712 2012420096 19.721 100 79 155 1 2066906192 31201936 23284160
23:38:14 1520 8192000000 10993031952 11413532672 2016153984 19.750 100 80 160 3 2074064144 33880304 24029856
23:38:24 2158 8192000000 10974056208 11394240512 1993780960 19.574 99 83 166 0 2053086624 35079232 24226432
23:38:38 6741 8192000000 10980203968 11400212480 1991380624 19.555 99 84 168 1 2051882240 35643552 24858064
23:38:53 8048 8192000000 10967160656 11399471104 1996533952 19.595 100 67 134 1 2054012496 36839184 20639360
23:39:15 5086 8192000000 10985190992 11412074496 2014558480 19.737 100 76 152 0 2073305424 35501120 23245824
23:39:28 4102 8192000000 10989318576 11409936384 2013987920 19.733 100 87 171 2 2075499648 36274544 25237184
23:39:40 8860 8192000000 10991377360 11416977408 2012577936 19.722 100 79 157 0 2074307328 37949936 23779456
23:39:57 7120 8192000000 10987051552 11410309120 2001426752 19.634 100 76 150 1 2066100384 42554336 22119296
23:40:17 1858 8192000000 10959417856 11387826176 1990348480 19.547 99 67 133 1 2039292896 28556976 20387440
23:40:29 5251 8192000000 10963402624 11397173248 1989028432 19.536 99 55 110 1 2034676384 28637488 17010464
23:40:41 12058 8192000000 10969347824 11399147520 2002247648 19.640 100 67 134 1 2053104256 29961216 20895392
23:41:01 2272 8192000000 10961186192 11382472704 1990495344 19.548 100 75 150 0 2045118880 31294416 23329120
23:41:11 1554 8192000000 10960058272 11377823744 1986354528 19.515 100 86 173 1 2044825392 31878688 26592176
23:41:22 4363 8192000000 10958186160 11384983552 1993122208 19.568 100 64 128 0 2045186272 32177856 19886208
23:41:34 4892 8192000000 10950347536 11382317056 1960365488 19.309 98 68 136 2 2014419920 32477600 21576832
23:41:46 2858 8192000000 10974744672 11402862592 2002474960 19.642 100 75 150 0 2059503456 32883600 24144896
23:41:58 1749 8192000000 10984688624 11396067328 2005230736 19.664 100 86 171 1 2064522720 33566736 25725248
23:42:06 5383 8192000000 10977410032 11395747840 2000892016 19.630 100 81 163 1 2059804416 34579728 24332672
23:42:18 2760 8192000000 10991415248 11402481664 2005681136 19.668 100 86 171 2 2068310000 36655712 25973152
23:42:27 3417 8192000000 10979243760 11394088960 1995141200 19.584 100 85 171 0 2059735888 37903328 26691360
23:42:45 5686 8192000000 10976736400 11391901696 1990889088 19.551 100 80 161 2 2055324432 39017648 25417696
23:43:06 2448 8192000000 10987845072 11408916480 2007018720 19.678 100 82 164 0 2072360256 39646160 25695376
23:43:18 1839 8192000000 10991912512 11406974976 2004227280 19.656 100 87 172 0 2072335440 41006080 27102080
23:43:28 3093 8192000000 10971422416 11393114112 1980005632 19.465 99 77 154 0 2046700032 41801040 24893360
23:43:38 5297 8192000000 10973691648 11396280320 1988883872 19.535 100 73 147 3 2053527136 41767024 22876240
23:43:53 4696 8192000000 10946980464 11360989184 1962368880 19.325 100 86 170 1 2033004448 43269520 27366048
23:44:05 2015 8192000000 10947174336 11361562624 1954587632 19.263 99 80 160 0 2021954720 42397728 24969360
23:44:16 4697 8192000000 10963092352 11379625984 1979492976 19.461 100 78 154 2 2044993424 41639024 23861424
23:44:29 3931 8192000000 10954407440 11375153152 1963342992 19.333 99 69 138 0 2026908496 41840048 21725456
23:44:43 1888 8192000000 10970447520 11388633088 1986607520 19.517 100 73 147 0 2053579344 44170976 22800848
23:44:52 3455 8192000000 10971308944 11391827968 1988373088 19.531 100 73 147 0 2054684736 43187584 23124064
23:45:03 1990 8192000000 10982738192 11403554816 2000409840 19.626 100 86 172 2 2072937328 43994000 28533488
23:45:11 1860 8192000000 10996398928 11405824000 1999852240 19.622 100 89 176 0 2073678224 46439248 27386736
23:45:22 3158 8192000000 11001290480 11410751488 2007125536 19.679 100 92 183 0 2079711776 44422832 28163408
23:45:35 4330 8192000000 10996417536 11414450176 2007484352 19.682 100 87 172 1 2078274048 43735648 27054048
23:45:46 3524 8192000000 10998289264 11406999552 2004150544 19.655 100 85 170 1 2074388304 42924512 27313248
23:45:56 3758 8192000000 11007487136 11420573696 2008791040 19.692 100 92 182 1 2081537888 44073952 28672896
23:46:08 2277 8192000000 10979484800 11390676992 1981468944 19.476 99 80 160 2 2053185632 46019104 25697584
23:46:18 3240 8192000000 10980907664 11388239872 1976943504 19.440 99 87 174 0 2055249456 50190512 28115440
23:46:31 3611 8192000000 10969954208 11382534144 1972586512 19.406 99 83 166 3 2051696720 52097824 27012384
23:46:43 1150 8192000000 11001307264 11410173952 1996188272 19.593 100 91 181 0 2078258896 53231264 28839360
23:46:50 2875 8192000000 10995122320 11403460608 1980484960 19.469 99 90 181 0 2062333440 53585232 28263248
23:47:00 1266 8192000000 11000675472 11411382272 1995097104 19.584 100 93 186 0 2078857120 53649936 30110080
23:47:11 3093 8192000000 10994364544 11410227200 1995160672 19.585 100 83 166 0 2077668944 55590672 26917600
23:47:21 1289 8192000000 10988821168 11399454720 1981334064 19.475 99 87 173 2 2066095392 56266208 28495120
23:47:30 1220 8192000000 10984085008 11390058496 1975169984 19.426 99 94 188 1 2060210704 54882048 30158672
23:47:39 1600 8192000000 11001267008 11414294528 1998630384 19.612 100 88 176 2 2081369392 55037552 27701456
23:47:49 4617 8192000000 10970209856 11394351104 1976450464 19.437 100 64 128 0 2052462800 54894496 21117840
23:48:02 6805 8192000000 10961056560 11395473408 1976167264 19.434 100 56 112 0 2049522128 54829296 18525568
23:48:19 5762 8192000000 10952075168 11380367360 1951759888 19.240 99 57 113 0 2024870400 53763376 19347136
23:48:33 2451 8192000000 10962885296 11378073600 1951886880 19.242 99 72 144 1 2023959904 48506560 23566464
23:48:42 1962 8192000000 10978356912 11387981824 1975863744 19.432 100 83 165 2 2053253808 50517744 26872320
23:48:50 7667 8192000000 10939327472 11380101120 1970629296 19.390 100 44 88 1 2031840000 46249072 14961632
23:49:07 5959 8192000000 10967489200 11397222400 1976874160 19.440 100 57 115 1 2046021600 50258336 18889104
23:49:33 8542 8192000000 10969528816 11400941568 1965832432 19.352 99 58 117 0 2036211376 50187536 20191408
23:50:00 15399 8192000000 10932024192 11395022848 1963268800 19.332 100 34 68 3 2025278080 49666896 12342384
23:50:49 15282 8192000000 10908002672 11355541504 1941193744 19.156 99 28 56 0 1999875648 48018896 10663008
23:51:16 14826 8192000000 10918683440 11372916736 1943713968 19.176 99 26 52 0 1993129840 40180560 9235312
23:51:40 18106 8192000000 10919033056 11378978816 1961245744 19.316 100 21 42 1 2005634384 36691360 7697280
23:52:09 25737 8192000000 10933005136 11392077824 1966310112 19.356 100 21 42 0 2014097984 40122560 7665312
23:52:44 27580 8192000000 10892772624 11365621760 1914330880 18.941 98 15 30 0 1958099088 38098880 5669328
23:53:21 25087 8192000000 10869271104 11358576640 1918424528 18.974 99 15 30 2 1959059216 35367056 5267632
23:53:52 39785 8192000000 10880803936 11325673472 1900883968 18.833 98 26 52 2 1927066736 18098208 8084560
23:55:01 41641 8192000000 10879011792 11334303744 1923103152 19.012 99 29 59 1 1949294640 17817616 8373872
23:55:56 61601 8192000000 10868516768 11340476416 1936128032 19.116 100 14 28 2 1959054224 18773808 4152384
23:58:05 54693 8192000000 10900561712 11342999552 1921153120 18.996 98 26 52 0 1940459104 11749120 7556864
23:59:08 69260 8192000000 10880915600 11342499840 1913729328 18.937 98 12 24 0 1930382160 13330208 3322624
00:00:24 75159 8192000000 10888554096 11338887168 1915461968 18.950 98 9 17 1 1926639072 9210016 1967088
00:01:51 19706 8192000000 10905346800 11364876288 1967659120 19.367 100 18 36 0 1989033568 16652912 4721536
00:02:23 92037 8192000000 10881508048 11342807040 1863475584 18.531 95 7 14 0 1879539328 14439648 1624096
00:05:15 66847 8192000000 10883923584 11339816960 1949488080 19.222 100 15 30 0 1962878560 9046160 4344320
00:06:29 28772 8192000000 10896165232 11342880768 1956807360 19.281 100 37 74 1 1978921600 11280464 10833776
00:07:07 63495 8192000000 10883338592 11342094336 1922664208 19.008 98 33 66 0 1941485232 9347952 9473072
00:08:25 41378 8192000000 10889585360 11339321344 1945306000 19.189 99 34 65 1 1960665136 6713824 8645312
00:09:26 51576 8192000000 10886962592 11353497600 1922658432 19.008 98 10 20 0 1934787856 9496800 2632624
00:10:43 80080 8192000000 10899037584 11367501824 1934466448 19.103 98 15 29 0 1949062784 10545232 4051104
00:12:17 117821 8192000000 10905802624 11379699712 1953742160 19.256 99 5 10 0 1972234560 17522368 970032
00:14:24 117357 8192000000 10936455744 11376439296 1981454848 19.476 100 43 82 3 2003662400 9433104 12774448
00:16:35 45624 8192000000 10915919760 11365191680 1958172000 19.292 99 35 70 1 1982070160 13361024 10537136
00:17:38 34206 8192000000 10915667296 11363782656 1952901648 19.250 99 28 56 1 1975036144 13692432 8442064
00:18:19 51016 8192000000 10891940208 11355754496 1922116768 19.004 97 26 52 0 1941297968 12045376 7135824
00:19:18 17241 8192000000 10889934560 11365928960 1967430720 19.365 100 12 24 0 1982376752 11588512 3357520
00:19:41 20375 8192000000 10897718336 11369086976 1969770080 19.384 100 13 26 0 1984929104 10866112 4292912
00:20:18 108088 8192000000 10926597344 11396747264 1969755472 19.384 99 26 52 0 2000644800 22946064 7943264
00:22:21 31516 8192000000 10943279344 11403612160 1997655584 19.604 100 30 59 1 2025637280 19042224 8939472
00:23:03 81455 8192000000 10916622688 11404128256 1951328816 19.237 98 25 50 1 1984757488 25761360 7667312
00:24:47 53093 8192000000 10871279792 11337949184 1933112768 19.092 98 10 20 1 1955313504 19404304 2796432
00:25:48 140005 8192000000 10887891296 11372015616 1937223888 19.125 98 10 20 0 1948713536 8896032 2593616
00:28:17 22533 8192000000 10897546224 11377340416 1977956592 19.449 100 17 34 1 1995229184 12558112 4714480
00:28:52 32780 8192000000 10871496960 11356110848 1911165152 18.916 97 3 6 0 1919339920 7589088 585680
00:29:31 36197 8192000000 10863772672 11329335296 1853127360 18.448 94 14 26 1 1862917248 7020336 2769552
00:30:27 84209 8192000000 10865636800 11345821696 1871337264 18.595 96 8 16 0 1890554320 17481216 1735840
00:32:01 81086 8192000000 10874529408 11360735232 1877331104 18.644 96 14 28 1 1899416464 18156912 3928448
00:33:33 62354 8192000000 10889869264 11358617600 1924343776 19.022 98 16 32 0 1938115840 9307456 4464608
00:34:42 36427 8192000000 10881079776 11338817536 1863578752 18.532 95 15 30 0 1879068752 11671312 3818688
00:35:26 29097 8192000000 10892642576 11354914816 1944488016 19.183 99 37 74 1 1965422400 10717136 10217248
00:36:01 69990 8192000000 10900751152 11351928832 1902647744 18.848 97 19 39 1 1921805664 14177328 4980592
00:37:24 16491 8192000000 10897861568 11346419712 1907564560 18.887 97 44 88 1 1934172608 14172752 12435296
00:37:49 34424 8192000000 10905264352 11362414592 1957573152 19.287 100 31 62 1 1981436928 15228352 8635424
00:38:34 44079 8192000000 10870218544 11353985024 1898862128 18.817 97 24 46 2 1925513616 20244128 6407360
00:39:25 100590 8192000000 10848290032 11330064384 1786218144 17.901 92 7 14 0 1809321744 21047696 2055904
00:41:12 45714 8192000000 10892461152 11335389184 1927404144 19.046 99 26 53 1 1946280880 11480416 7396320
00:42:06 45565 8192000000 10898702560 11350487040 1935558816 19.111 99 30 60 2 1955309536 11318432 8432288
00:43:03 23996 8192000000 10903353968 11352846336 1959620912 19.303 100 37 74 2 1979733056 10234720 9877424
00:43:39 107297 8192000000 10893291104 11366469632 1964750656 19.344 100 22 44 1 1985560896 13827792 6982448
00:45:36 78413 8192000000 10890111136 11370942464 1937006160 19.123 98 17 34 1 1956532432 14558400 4967872
00:47:01 47014 8192000000 10890209248 11371995136 1968134160 19.371 100 13 26 0 1984680704 12979552 3566992
00:47:55 15907 8192000000 10880328752 11349188608 1930066560 19.067 98 29 58 0 1947817248 9048800 8701888
00:48:18 23023 8192000000 10884383072 11343187968 1935019920 19.107 99 52 104 0 1963294320 13108336 15166064
00:48:58 50949 8192000000 10873039680 11342888960 1918482208 18.975 98 16 32 0 1930315536 7542624 4290704
00:50:00 93539 8192000000 10896696032 11358498816 1904815120 18.865 97 22 44 0 1920469040 9568736 6085184
00:51:50 83512 8192000000 10874296480 11354296320 1944294032 19.181 99 10 20 0 1963931264 16599072 3038160
00:53:49 60072 8192000000 10885357488 11351117824 1948804128 19.217 100 15 29 3 1972595520 19226144 4565248
00:54:55 47253 8192000000 10866600832 11330564096 1911180624 18.916 98 20 40 0 1934321056 17302320 5838112
00:55:51 68843 8192000000 10868142672 11336499200 1873059760 18.609 97 15 30 0 1891036944 13600800 4376384
00:57:06 94440 8192000000 10899156160 11365515264 1935557424 19.111 99 16 32 1 1960801680 20717904 4526352
00:58:47 57342 8192000000 10928196528 11391975424 1979201696 19.458 100 16 32 0 1998404544 14787008 4415840
00:59:51 52156 8192000000 10943282064 11409088512 1990912448 19.551 100 19 38 0 2014930464 18517728 5500288
01:01:13 78087 8192000000 10913726928 11405045760 1982585792 19.485 99 19 38 0 2008954624 20891856 5476976
01:02:38 51717 8192000000 10942726512 11387449344 1987085344 19.521 100 22 40 2 2004374992 11663696 5625952
01:03:35 16476 8192000000 10904054672 11351031808 1937789744 19.129 98 44 88 2 1958423088 8495104 12138240
01:04:00 42634 8192000000 10918706992 11362041856 1966534096 19.358 100 37 74 1 1987888384 11471344 9882944
01:04:49 1399 8192000000 10936821120 11373371392 1984237088 19.498 100 70 139 2 2014418560 10414800 19766672
01:04:58 50456 8192000000 10894192480 11364155392 1916545936 18.959 97 29 58 1 1941663840 16309664 8808240
01:05:55 66955 8192000000 10907550160 11380371456 1950373280 19.229 99 8 16 0 1966525104 14148496 2003328
01:07:08 88177 8192000000 10919203184 11373490176 1941747024 19.161 98 22 44 0 1960702976 12984336 5971616
01:08:45 27321 8192000000 10906435088 11362050048 1932770000 19.089 98 39 77 0 1954178368 10876128 10532240
01:09:31 118221 8192000000 10879864608 11351900160 1944092304 19.179 99 24 48 0 1965162304 14274032 6795968
01:11:52 58188 8192000000 10896259664 11378315264 1974752464 19.423 100 25 50 3 1997654992 15963120 6939408
01:12:57 44787 8192000000 10889278128 11380809728 1973491136 19.413 100 5 9 1 1985103568 10389008 1223424
01:13:55 45748 8192000000 10893783664 11377786880 1973491936 19.413 100 7 14 1 1989839152 13925856 2421360
01:14:48 59621 8192000000 10895904928 11379048448 1961351840 19.317 99 15 30 1 1982080496 16637264 4091392
01:15:54 49453 8192000000 10888589504 11374100480 1940039536 19.147 99 11 22 1 1960905216 17896448 2969232
01:17:09 45261 8192000000 10876960336 11357872128 1956567056 19.279 100 16 30 1 1972549840 11072208 4910576
01:18:06 60060 8192000000 10884111408 11352363008 1919670336 18.984 98 10 21 0 1929389712 7507664 2211712
01:19:17 68775 8192000000 10898263856 11376648192 1952959136 19.250 99 27 54 0 1968935696 9076032 6900528
01:20:46 14450 8192000000 10915129840 11372986368 1956979856 19.282 99 42 84 1 1982790000 13645952 12164192
01:21:12 65357 8192000000 10906733472 11382960128 1977312256 19.443 100 24 48 0 2003078240 18730592 7035392
01:22:53 64428 8192000000 10912306816 11394838528 1973155152 19.410 100 12 24 2 1997308352 20372320 3780880
01:24:21 106458 8192000000 10887444400 11349577728 1810205328 18.098 92 10 21 0 1821968368 9257136 2505904
01:26:14 53309 8192000000 10364026656 10794369024 1461402544 15.138 75 11 22 0 1479948112 15237760 3307808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-12-2020 01:28:12 to 01-12-2020 01:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 149 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-12-2020 01:28:45 to 01-12-2020 01:28:47.

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          239841
MON$OLDEST_ACTIVE               239842
MON$OLDEST_SNAPSHOT             239842
MON$NEXT_TRANSACTION            239842
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                       2058016
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:175: 
:176: mscs-test-161.budzdorov.ru    Tue Dec  1 01:27:30 2020
:177:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:178: 
--- end of diff output ---

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

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