Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.12.2020 16:33
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 17330024 kB
MemAvailable 31579980 kB
Buffers 0 kB
Cached 14380568 kB
SwapCached 3704 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-10 16:31:57
DTS_END                         2020-12-10 16:31:57.9000
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/41536
TRN_ID                          257936
ATT_ID                          737
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: 9749.84 19715 1169981
customer order: creation 185.03 316 22204
customer order: refuse 16.13 261 1936
order to supplier: creation 50.41 1070 6049
order to supplier: removal 3.58 76027 430
invoice (draft): creation 49.27 3053 5912
invoice (draft): removal 53.33 698 6400
invoice accept: apply 45.01 15182 5401
invoice accept: cancel 48.87 716 5864
customer reserve: creation 4155.35 151 498642
customer reserve: removal 4816.06 44 577927
realization accept: apply 91.90 146 11028
realization accept: cancel 95.42 81 11450
payment from customer: creation 63.88 97 7665
payment from customer: removal 6.26 78 751
payment to supplier: creation 52.23 93 6267
payment to supplier: removal 3.88 44 465
service: total inventory turnovers 5.21 1058 625
service: total monetary turnovers 7.03 40 843
service: aggregate perf. data 0.98 15987 118
service: refresh index statistics 0.03 279161 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-12-2020 16:33:25 to 10-12-2020 16:33:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 273
TEST_TIME 2 2278
TEST_TIME 3 2990
TEST_TIME 4 3583
TEST_TIME 5 4447
TEST_TIME 6 4382
TEST_TIME 7 4469
TEST_TIME 8 5013
TEST_TIME 9 5508
TEST_TIME 10 6295
TEST_TIME 11 6459
TEST_TIME 12 6671
TEST_TIME 13 7677
TEST_TIME 14 7581
TEST_TIME 15 8058
TEST_TIME 16 8932
TEST_TIME 17 9193
TEST_TIME 18 10226
TEST_TIME 19 10713
TEST_TIME 20 11085
TEST_TIME 21 11136
TEST_TIME 22 11559
TEST_TIME 23 11832
TEST_TIME 24 11542
TEST_TIME 25 11368
TEST_TIME 26 11448
TEST_TIME 27 11335
TEST_TIME 28 11449
TEST_TIME 29 11323
TEST_TIME 30 11288
TEST_TIME 31 11318
TEST_TIME 32 11497
TEST_TIME 33 11402
TEST_TIME 34 11331
TEST_TIME 35 11568
TEST_TIME 36 11283
TEST_TIME 37 11085
TEST_TIME 38 11043
TEST_TIME 39 10877
TEST_TIME 40 10910
TEST_TIME 41 10841
TEST_TIME 42 10793
TEST_TIME 43 10748
TEST_TIME 44 10763
TEST_TIME 45 10645
TEST_TIME 46 10664
TEST_TIME 47 10525
TEST_TIME 48 10390
TEST_TIME 49 10385
TEST_TIME 50 10368
TEST_TIME 51 10229
TEST_TIME 52 10166
TEST_TIME 53 10054
TEST_TIME 54 10111
TEST_TIME 55 10115
TEST_TIME 56 10058
TEST_TIME 57 10103
TEST_TIME 58 10073
TEST_TIME 59 10157
TEST_TIME 60 10165
TEST_TIME 61 10171
TEST_TIME 62 10311
TEST_TIME 63 10271
TEST_TIME 64 10317
TEST_TIME 65 10344
TEST_TIME 66 10385
TEST_TIME 67 10304
TEST_TIME 68 10180
TEST_TIME 69 10199
TEST_TIME 70 10189
TEST_TIME 71 10148
TEST_TIME 72 10045
TEST_TIME 73 10076
TEST_TIME 74 10004
TEST_TIME 75 9940
TEST_TIME 76 10003
TEST_TIME 77 10027
TEST_TIME 78 10018
TEST_TIME 79 10027
TEST_TIME 80 10020
TEST_TIME 81 10034
TEST_TIME 82 10038
TEST_TIME 83 10031
TEST_TIME 84 10040
TEST_TIME 85 10100
TEST_TIME 86 10113
TEST_TIME 87 10153
TEST_TIME 88 10093
TEST_TIME 89 10032
TEST_TIME 90 9977
TEST_TIME 91 9980
TEST_TIME 92 9922
TEST_TIME 93 9844
TEST_TIME 94 9841
TEST_TIME 95 9887
TEST_TIME 96 9890
TEST_TIME 97 9851
TEST_TIME 98 9865
TEST_TIME 99 9842
TEST_TIME 100 9921
TEST_TIME 101 9943
TEST_TIME 102 9940
TEST_TIME 103 9952
TEST_TIME 104 10034
TEST_TIME 105 10022
TEST_TIME 106 10066
TEST_TIME 107 10049
TEST_TIME 108 10083
TEST_TIME 109 10000
TEST_TIME 110 9936
TEST_TIME 111 9926
TEST_TIME 112 9909
TEST_TIME 113 9859
TEST_TIME 114 9817
TEST_TIME 115 9792
TEST_TIME 116 9742
TEST_TIME 117 9678
TEST_TIME 118 9762
TEST_TIME 119 9746
TEST_TIME 120 9753

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-12-2020 16:33:29 to 10-12-2020 16:33:32.

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 1631355 1631355 0 0.00 0 22583 5 0 0
doc_list_biud 1631355 1631355 0 0.00 0 34542 21 0 0
sp_add_invoice_to_stock 5559 5401 158 2.84 35 172574 15183 0 158
sp_cancel_adding_invoice 5864 5864 0 0.00 5 81983 717 0 0
sp_cancel_client_order 1936 1936 0 0.00 5 8749 261 0 0
sp_cancel_customer_reserve 577927 577927 0 0.00 1 34545 45 0 0
sp_cancel_pay_from_customer 751 751 0 0.00 2 9415 79 0 0
sp_cancel_pay_to_supplier 465 465 0 0.00 3 1790 45 0 0
sp_cancel_supplier_invoice 6416 6400 16 0.24 2 24376 698 0 16
sp_cancel_supplier_order 430 430 0 0.00 5 899868 76027 0 0
sp_cancel_write_off 11450 11450 0 0.00 1 8511 81 0 0
sp_client_order 22204 22204 0 0.00 3 25480 317 0 0
sp_customer_reserve 498642 498642 0 0.00 0 52461 152 0 0
sp_fill_shopping_cart 34155 34155 0 0.00 1 18166 36 0 0
sp_fill_shopping_cart_clo_res 498634 498634 0 0.00 0 12893 12 0 0
sp_get_clo_for_invoice 5393 5393 0 0.00 0 20647 275 0 0
sp_kill_cost_storno 18530 18530 0 0.00 0 22297 39 0 0
sp_kill_qstorno_ret_qs2qd 1174134 1174134 0 0.00 0 34526 25 0 0
sp_kill_qty_storno 620428 620428 0 0.00 0 34542 54 0 0
sp_lock_selected_doc 22803 22803 0 0.00 0 7004 3 0 0
sp_make_cost_storno 30353 30353 0 0.00 0 22397 40 0 0
sp_multiply_rows_for_pdistr 30353 30353 0 0.00 0 7585 21 0 0
sp_multiply_rows_for_qdistr 22204 22204 0 0.00 0 13878 151 0 0
sp_pay_from_customer 7665 7665 0 0.00 4 23889 98 0 0
sp_pay_to_supplier 6267 6267 0 0.00 4 8782 94 0 0
sp_payment_common 13932 13932 0 0.00 1 7557 25 0 0
sp_qd_handle_on_cancel_clo 1936 1936 0 0.00 0 8738 243 0 0
sp_qd_handle_on_invoice_upd_sts 11257 11257 0 0.00 0 21659 258 0 0
sp_qd_handle_on_reserve_upd_sts 11028 11028 0 0.00 0 16234 58 0 0
sp_reserve_write_off 11028 11028 0 0.00 6 16253 147 0 0
sp_supplier_invoice 5912 5912 0 0.00 7 104951 3054 0 0
sp_supplier_order 6049 6049 0 0.00 5 47357 1071 0 0
srv_aggregate_perf_data 118 118 0 0.00 2806 129853 15988 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 916 150548 39164 0 0
srv_find_qd_qs_mism 1118325 1118325 0 0.00 0 15294 5 0 0
srv_make_invnt_saldo 625 625 0 0.00 35 67860 1058 0 0
srv_make_money_saldo 843 843 0 0.00 1 6305 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 183825 338796 279161 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5401 5401 0 0.00 0 17121 137 0 0
t$perf-norm:sp_cancel_adding_invoice 483 483 0 0.00 1 4393 82 0 0
t$perf-norm:sp_cancel_client_order 1936 1936 0 0.00 0 2927 14 0 0
t$perf-norm:sp_cancel_customer_reserve 763 763 0 0.00 0 1770 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 751 751 0 0.00 0 1167 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 465 465 0 0.00 0 2437 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 1735 13 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 15332 1284 0 0
t$perf-norm:sp_cancel_write_off 1127 1127 0 0.00 0 1787 9 0 0
t$perf-norm:sp_client_order 22204 22204 0 0.00 0 16837 15 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 1313 6 0 0
t$perf-norm:sp_pay_from_customer 7665 7665 0 0.00 0 5877 10 0 0
t$perf-norm:sp_pay_to_supplier 6267 6267 0 0.00 0 7391 8 0 0
t$perf-norm:sp_reserve_write_off 11028 11028 0 0.00 0 12645 12 0 0
t$perf-norm:sp_supplier_invoice 5912 5912 0 0.00 0 3301 14 0 0
t$perf-norm:sp_supplier_order 6049 6049 0 0.00 0 20291 17 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 62 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 2715 26 0 0
t$perf-norm:srv_make_invnt_saldo 625 625 0 0.00 0 504 10 0 0
t$perf-norm:srv_make_money_saldo 843 843 0 0.00 0 1683 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 20 7 0 0
v_add_invoice_to_stock 11102 10786 316 2.84 0 5473 19 0 316
v_all_customers 40592 40592 0 0.00 0 115 0 0 0
v_all_suppliers 32756 32756 0 0.00 0 80 1 0 0
v_all_wares 44408 44408 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 966 966 0 0.00 0 442 5 0 0
v_cancel_client_order 3872 3872 0 0.00 0 3778 3 0 0
v_cancel_customer_prepayment 1502 1502 0 0.00 0 2143 9 0 0
v_cancel_customer_reserve 1526 1526 0 0.00 0 3450 7 0 0
v_cancel_payment_to_supplier 930 930 0 0.00 0 670 3 0 0
v_cancel_supplier_invoice 886 854 32 3.61 0 1100 13 0 32
v_cancel_supplier_order 860 860 0 0.00 0 2329 8 0 0
v_cancel_write_off 2254 2254 0 0.00 0 2532 14 0 0
v_max_id_clo_ord 6049 6049 0 0.00 0 3046 2 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 1778 14 0 0
v_max_id_ord_sup 5902 5902 0 0.00 0 5982 4 0 0
v_max_non_paid_invoice 1840 1840 0 0.00 0 904 2 0 0
v_max_non_paid_realizn 3986 3986 0 0.00 0 731 2 0 0
v_min_id_clo_ord 6049 6049 0 0.00 0 3389 5 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 1822 11 0 0
v_min_id_ord_sup 5902 5902 0 0.00 0 5801 7 0 0
v_min_non_paid_invoice 6267 6267 0 0.00 0 4253 15 0 0
v_min_non_paid_realizn 7665 7665 0 0.00 0 6604 17 0 0
v_our_firm 11174 11174 0 0.00 0 24 1 0 0
v_reserve_write_off 22056 22056 0 0.00 0 4269 5 0 0
x_lock_depdocs_on_canc_invoice 11837 11837 0 0.00 0 19041 88 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 15049 325 0 0
x_make_qstorno_1000_1200 6049 6049 0 0.00 2 47320 1007 0 0
x_make_qstorno_1200_2000 5912 5912 0 0.00 3 104931 2915 0 0
x_make_qstorno_2100_3300 498642 498642 0 0.00 0 52460 137 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-12-2020 16:33:33 to 10-12-2020 16:33:37.

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:02:01 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:08 23940 8192000000 10272514320 10584035328 927124992 10.166 72 54 108 0 947683920 2660512 17898416
14:02:42 32208 8192000000 10354522704 10674331648 1386635616 14.476 100 87 174 0 1422190432 5942928 29611888
14:03:25 27365 8192000000 10388250480 10714673152 1433507616 14.892 100 89 178 1 1470360912 7174432 29678864
14:04:06 28661 8192000000 10418830080 10752094208 1462569568 15.148 100 82 163 2 1497108848 7714432 26824848
14:04:43 17450 8192000000 10446851008 10779672576 1499968208 15.476 100 91 182 0 1538089680 8563136 29558336
14:05:15 15028 8192000000 10454370224 10793529344 1513990400 15.598 100 87 174 0 1551177296 9348784 27838112
14:05:38 20022 8192000000 10482582976 10822934528 1527809840 15.718 100 87 174 0 1565576880 9840848 27926192
14:06:10 17074 8192000000 10492008400 10834092032 1542799360 15.848 100 87 174 0 1581076528 10595504 27681664
14:06:43 17025 8192000000 10523823440 10873569280 1570081504 16.083 100 74 148 0 1603208304 10335856 22790944
14:07:11 17016 8192000000 10552112160 10911518720 1600802672 16.346 100 75 150 1 1634327344 10660208 22864464
14:07:38 12123 8192000000 10586859008 10947031040 1635886688 16.645 100 77 154 1 1670376592 11624736 22865168
14:08:01 9797 8192000000 10608396656 10972430336 1664968384 16.891 100 84 168 1 1701592736 12186800 24437552
14:08:19 7928 8192000000 10618241520 10986119168 1678079888 17.001 100 76 153 0 1712965488 12246112 22639488
14:08:37 8796 8192000000 10634286736 11004792832 1693718896 17.132 100 80 160 1 1730445472 13057408 23669168
14:08:53 4810 8192000000 10650523376 11025297408 1710070176 17.269 100 80 159 0 1745908944 13080416 22758352
14:09:05 5547 8192000000 10661171792 11036803072 1728911952 17.426 100 85 170 0 1767130656 13573056 24645648
14:09:17 5380 8192000000 10671443072 11052900352 1739543840 17.515 100 82 164 0 1776605408 13695216 23366352
14:09:28 6143 8192000000 10689789312 11067768832 1754114832 17.636 100 82 158 2 1789980064 13674912 22190320
14:09:42 3866 8192000000 10705154880 11083055104 1761223184 17.695 100 84 169 2 1798041168 13474352 23343632
14:09:53 3361 8192000000 10708771792 11087728640 1770060656 17.768 100 89 175 1 1808464224 13983824 24419744
14:10:03 4310 8192000000 10717207824 11095302144 1772713840 17.789 100 87 174 1 1811811152 14889232 24208080
14:10:14 2792 8192000000 10724139680 11104382976 1781155568 17.859 100 89 176 3 1819812992 14285088 24372336
14:10:24 2941 8192000000 10731585760 11110006784 1787220032 17.909 100 90 178 2 1826104368 14848640 24035696
14:10:33 3342 8192000000 10729945280 11116621824 1794838832 17.972 100 87 173 0 1833085424 14258064 23988528
14:10:43 3609 8192000000 10724782992 11110793216 1792112384 17.949 100 74 146 0 1825660784 12865200 20683200
14:10:53 5478 8192000000 10741119632 11123044352 1799625408 18.011 100 82 162 2 1836332768 14123600 22583760
14:11:05 1616 8192000000 10760036832 11144175616 1821195568 18.187 100 96 193 0 1863802272 15470816 27135888
14:11:13 2117 8192000000 10769187312 11151159296 1820773248 18.184 100 90 179 1 1859896960 14291712 24832000
14:11:22 1846 8192000000 10774728928 11158913024 1829061760 18.252 100 92 184 0 1869240944 14376592 25802592
14:11:30 1455 8192000000 10780149328 11165532160 1836064064 18.309 100 89 178 1 1874521584 13740304 24717216
14:11:37 2265 8192000000 10783366880 11168522240 1840472656 18.345 100 86 171 1 1877782496 13387504 23922336
14:11:46 1137 8192000000 10787416560 11172020224 1846433296 18.393 100 91 181 3 1885144736 14051264 24660176
14:11:54 1702 8192000000 10792999088 11179827200 1848931408 18.413 100 95 190 0 1889364624 13814736 26618480
14:12:02 1827 8192000000 10799890704 11186335744 1851188064 18.432 100 93 185 0 1889275168 12361184 25725920
14:12:10 1471 8192000000 10802584976 11189579776 1855554672 18.467 100 95 190 1 1896156832 14303216 26298944
14:12:18 27208 8192000000 10791512368 11193098240 1854124048 18.456 100 61 122 3 1883621248 12297264 17199936
14:12:51 19826 8192000000 10775272352 11184799744 1855087568 18.463 100 53 106 1 1879005968 8269920 15648480
14:13:18 4946 8192000000 10767972688 11187720192 1853983952 18.454 100 36 72 1 1871942272 8127248 9831072
14:13:31 7930 8192000000 10791441648 11200008192 1862584512 18.524 100 54 108 1 1887354912 9499920 15270480
14:13:45 2913 8192000000 10783679088 11198459904 1864659008 18.541 100 57 109 1 1890566736 10976384 14931344
14:13:57 3250 8192000000 10774993824 11194953728 1861023952 18.512 100 35 70 1 1878570336 8108768 9437616
14:14:07 6319 8192000000 10776584208 11197870080 1863991344 18.536 100 34 68 0 1881239440 8043776 9204320
14:14:19 9346 8192000000 10777533264 11199410176 1866594224 18.557 100 23 46 2 1879214688 6137584 6482880
14:14:35 7753 8192000000 10781509808 11206742016 1871095248 18.593 100 32 65 0 1892154272 12053728 9005296
14:14:52 7174 8192000000 10787664512 11208699904 1871150544 18.594 100 31 60 1 1887150096 6852176 9147376
14:15:06 7974 8192000000 10787252816 11214266368 1877663184 18.646 100 35 69 2 1895075184 7615920 9796080
14:15:20 14875 8192000000 10785559552 11217432576 1878929872 18.656 100 25 50 0 1893042048 6433488 7678688
14:15:47 10198 8192000000 10793854816 11225083904 1883717216 18.695 100 20 40 0 1895658480 6096880 5844384
14:16:05 15829 8192000000 10813303792 11222110208 1882789520 18.688 100 11 21 2 1891587216 6158048 2639648
14:16:28 17835 8192000000 10794919792 11234295808 1889540592 18.742 100 25 50 0 1902535616 6246112 6748912
14:16:52 68113 8192000000 10817062176 11247071232 1893545584 18.774 100 36 72 0 1909791408 6310368 9935456
14:18:06 5883 8192000000 10812314432 11249442816 1898492608 18.814 100 34 68 1 1915473024 7734864 9245552
14:18:20 4517 8192000000 10822999472 11252150272 1900889264 18.833 100 39 75 1 1918604880 7235776 10479840
14:18:33 6803 8192000000 10832046880 11254280192 1900868944 18.833 100 24 48 1 1914512160 6154800 7488416
14:18:46 6538 8192000000 10813236272 11251191808 1901249344 18.836 100 19 38 1 1912544768 5698576 5596848
14:19:01 7677 8192000000 10827049744 11257143296 1903188672 18.852 100 17 34 1 1917831360 10210784 4431904
14:19:20 11635 8192000000 10804000256 11238084608 1882527440 18.686 99 14 28 1 1892755728 6437488 3790800
14:19:37 11594 8192000000 10821933344 11248574464 1881473056 18.677 99 23 46 1 1897856736 10136768 6246912
14:19:56 11968 8192000000 10805506912 11244408832 1880826704 18.672 99 25 50 0 1893981216 5985280 7169232
14:20:14 18993 8192000000 10809347344 11244417024 1861141728 18.513 98 18 36 0 1876987504 10608912 5236864
14:20:39 12417 8192000000 10791404688 11222761472 1860668176 18.509 99 13 25 1 1869955840 5471008 3816656
14:20:58 10739 8192000000 10798871120 11222437888 1840859680 18.348 98 25 48 5 1866056352 18515200 6681472
14:21:19 57871 8192000000 10755358816 11172544512 1771562112 17.780 95 37 74 1 1788108688 5035840 11510736
14:22:26 19107 8192000000 10742086048 11161169920 1774826048 17.807 96 19 38 3 1785587760 5310560 5451152
14:22:51 7187 8192000000 10743868176 11167879168 1752098624 17.619 95 23 46 2 1764650608 5656416 6895568
14:23:05 6452 8192000000 10723719024 11144359936 1764367552 17.720 97 23 46 1 1776234192 5577648 6288992
14:23:19 5611 8192000000 10730197008 11145682944 1761433072 17.696 97 36 71 1 1783369024 11653376 10282576
14:23:31 4959 8192000000 10695989200 11108769792 1771526032 17.780 99 21 43 1 1784817872 6798704 6493136
14:23:43 9348 8192000000 10723422624 11148128256 1789718608 17.929 99 22 44 0 1801620032 6037920 5863504
14:23:58 7479 8192000000 10716462464 11132198912 1762888144 17.708 97 22 44 1 1779276304 10214976 6173184
14:24:13 8869 8192000000 10698039136 11111456768 1713033552 17.294 95 21 42 1 1724887520 5174912 6679056
14:24:28 9832 8192000000 10700720016 11119738880 1731477968 17.448 96 17 33 1 1741681728 4877680 5326080
14:24:44 6979 8192000000 10706176272 11118161920 1745875376 17.567 97 26 52 0 1759560528 5657984 8027168
14:25:01 11690 8192000000 10692539744 11102388224 1710024448 17.269 95 27 54 0 1723069008 5256784 7787776
14:25:19 18212 8192000000 10714649984 11131162624 1755121376 17.644 97 18 36 2 1765410480 5077040 5212064
14:25:44 7892 8192000000 10712149712 11130060800 1786115984 17.900 99 34 66 1 1800935184 5133936 9685264
14:26:01 18314 8192000000 10728394784 11144261632 1804775568 18.053 99 31 57 4 1823511648 9670368 9065712
14:27:05 31752 8192000000 10733003952 11164368896 1820562608 18.182 100 14 28 1 1829774640 5570032 3642000
14:27:45 9534 8192000000 10757770160 11177582592 1836777008 18.315 100 32 63 1 1851958896 6213184 8968704
14:28:01 7175 8192000000 10758470768 11182313472 1840014496 18.341 100 22 42 1 1852417504 6142016 6260992
14:28:15 8625 8192000000 10764883232 11188899840 1847394112 18.401 100 21 42 1 1858565888 5363904 5807872
14:28:29 7549 8192000000 10767964144 11194933248 1858789584 18.493 100 31 62 1 1873837456 6046944 9000928
14:28:46 6820 8192000000 10770985424 11199971328 1860586384 18.508 100 30 60 0 1879032480 9848464 8597632
14:29:00 9092 8192000000 10775123136 11204112384 1859658176 18.501 100 16 32 0 1870324128 5857904 4808048
14:29:15 9568 8192000000 10774351968 11202273280 1860287232 18.506 100 11 21 0 1868401984 5143216 2971536
14:29:31 10845 8192000000 10779742656 11209302016 1865330624 18.546 100 24 48 2 1877628160 5377280 6920256
14:29:51 12435 8192000000 10785379360 11212677120 1866297936 18.554 100 23 46 1 1878024832 5361968 6364928
14:30:13 11005 8192000000 10781469664 11213979648 1868084784 18.569 100 21 41 1 1880314736 5280896 6949056
14:30:33 12627 8192000000 10776130096 11212578816 1873116880 18.609 100 16 31 1 1882751568 5277072 4357616
14:30:56 9669 8192000000 10792335360 11223375872 1874379456 18.620 100 19 38 1 1884601440 5480400 4741584
14:31:12 13859 8192000000 10786497136 11224154112 1872782080 18.607 100 10 19 0 1884610880 9371392 2457408
14:31:36 121955 8192000000 10827222960 11254468608 1895920224 18.793 100 36 72 1 1914740032 8255184 10564624
14:33:47 11080 8192000000 10852666480 11274702848 1922174448 19.004 100 45 88 2 1944625392 10414960 12035984
14:34:11 18274 8192000000 10866680224 11291365376 1930723648 19.073 100 52 104 1 1957207488 12303120 14180720
14:34:37 7358 8192000000 10841272768 11261865984 1896981920 18.802 98 53 106 1 1924277840 12292288 15003632
14:34:52 7448 8192000000 10857551696 11274760192 1918787216 18.977 100 47 91 0 1943598384 11957040 12854128
14:35:07 28962 8192000000 10860660048 11293630464 1934956832 19.106 100 42 84 0 1960499520 13831600 11711088
14:35:48 19044 8192000000 10885023984 11314327552 1946880192 19.202 100 43 84 4 1977016640 18385328 11751120
14:36:15 26838 8192000000 10883822608 11314790400 1938206720 19.132 99 43 86 0 1969882928 18863216 12812992
14:36:51 24009 8192000000 10899688064 11332096000 1954447632 19.262 100 38 74 1 1982297184 17551664 10297888
14:37:25 11221 8192000000 10898081552 11332726784 1957982640 19.290 100 35 68 1 1990237344 21980048 10274656
14:37:44 5688 8192000000 10916035104 11339980800 1963477712 19.334 100 58 116 0 2002555632 21717648 17360272
14:37:57 12005 8192000000 10912783584 11346046976 1971727216 19.399 100 51 100 2 2009465552 23520768 14217568
14:38:19 7458 8192000000 10938503376 11359719424 1981807824 19.479 100 59 118 1 2026519408 26531888 18179696
14:38:34 4706 8192000000 10937394432 11366121472 1985601344 19.509 100 57 115 2 2030159920 27097440 17461136
14:38:48 4610 8192000000 10944398160 11372294144 1991004368 19.552 100 63 125 0 2037456320 28729504 17722448
14:39:00 4789 8192000000 10945018544 11372281856 1984729680 19.502 100 60 120 1 2033431152 31042288 17659184
14:39:12 14194 8192000000 10946753088 11377045504 1987301696 19.522 100 53 106 3 2034282288 30740112 16240480
14:39:42 4931 8192000000 10941638496 11378982912 1993460960 19.571 100 50 100 0 2038051808 29281920 15308928
14:39:55 5799 8192000000 10955565424 11388485632 2000276656 19.625 100 57 114 2 2046823680 29207456 17339568
14:40:08 4015 8192000000 10950767568 11375276032 1976730624 19.439 99 62 124 0 2026401104 31037440 18633040
14:40:21 7586 8192000000 10950272256 11378257920 1989626400 19.541 100 54 108 0 2037174288 30303808 17244080
14:40:37 6981 8192000000 10966894144 11389452288 1998174352 19.608 100 73 146 2 2052534208 32747520 21612336
14:40:52 2025 8192000000 10967643808 11387580416 2003405520 19.650 100 86 168 3 2060978224 33020928 24551776
14:41:00 2569 8192000000 10965220368 11383169024 1995003824 19.583 100 76 149 0 2050743312 33754368 21985120
14:41:10 3563 8192000000 10971486128 11390730240 2002831696 19.645 100 73 142 1 2057531760 33514512 21185552
14:41:31 1588 8192000000 10983766800 11396997120 2005542128 19.666 100 90 178 1 2066991616 34961536 26487952
14:41:40 3293 8192000000 10966168224 11378651136 1983515728 19.493 99 87 174 2 2045867120 35987728 26363664
14:41:50 2462 8192000000 10969455120 11385200640 1993633520 19.572 100 78 156 1 2051230752 34358064 23239168
14:42:00 5979 8192000000 10965214512 11383586816 1990458464 19.547 100 78 156 1 2049865632 35947328 23459840
14:42:12 1563 8192000000 10957860448 11366993920 1965361952 19.349 99 88 178 1 2026031072 35654944 25014176
14:42:20 3558 8192000000 10975272208 11389657088 1994360368 19.578 100 85 170 0 2057373056 37808304 25204384
14:42:32 3483 8192000000 10984287424 11395612672 2000438672 19.626 100 86 172 1 2065160096 39151120 25570304
14:42:43 7150 8192000000 10971853056 11391025152 1980319488 19.467 99 78 155 0 2042993424 39268176 23405760
14:43:03 10520 8192000000 10927416416 11354562560 1925643328 19.032 97 59 117 0 1982336064 38952800 17739936
14:43:21 2981 8192000000 10940688368 11356463104 1962750688 19.328 100 78 156 2 2026471504 40136384 23584432
14:43:32 1864 8192000000 10951176768 11361427456 1967367200 19.365 100 81 162 2 2032497488 40850272 24280016
14:43:41 2458 8192000000 10946006192 11364769792 1958589280 19.295 99 76 151 2 2023560320 41933648 23037392
14:43:49 3018 8192000000 10968771728 11385131008 1987935600 19.527 100 78 155 0 2054591584 43489776 23166208
14:44:00 1299 8192000000 10979774160 11392348160 1987410928 19.523 100 83 164 0 2058219616 44863424 25945264
14:44:08 913 8192000000 10962182112 11369447424 1967848432 19.368 99 95 189 0 2039996064 43992032 28155600
14:44:17 6641 8192000000 10907806512 11341438976 1903365264 18.853 97 53 104 0 1960437216 40773264 16298688
14:44:38 5781 8192000000 10897735552 11326615552 1915132272 18.948 99 42 84 0 1967055408 38712656 13210480
14:44:56 7059 8192000000 10890527072 11323494400 1923145040 19.012 99 42 84 1 1978944288 41876016 13923232
14:45:17 13881 8192000000 10917857552 11347099648 1929545680 19.063 99 46 92 1 1986347376 41480928 15320768
14:45:39 4722 8192000000 10940121584 11361579008 1958104640 19.291 100 66 131 3 2026212064 45839264 22268160
14:45:53 3221 8192000000 10959141216 11370819584 1959706320 19.304 100 77 152 2 2033520608 49574832 24239456
14:46:04 4930 8192000000 10950071360 11375677440 1963063920 19.330 100 63 125 1 2036686832 53073600 20549312
14:46:16 18067 8192000000 10945181536 11386781696 1962254688 19.324 100 43 84 0 2032300400 54715824 15329888
14:46:43 4468 8192000000 10956663536 11366834176 1922694944 19.008 98 62 120 2 1996795440 53516976 20583520
14:46:56 15106 8192000000 10915928272 11358068736 1932482656 19.087 99 47 94 0 2003407520 54898176 16026688
14:47:21 13329 8192000000 10876564800 11313786880 1861316112 18.514 97 41 82 0 1931463872 56153568 13994192
14:47:44 11193 8192000000 10876197360 11312173056 1874697488 18.622 98 30 60 1 1930242352 44947808 10597056
14:48:12 18879 8192000000 10890914928 11329208320 1901658224 18.840 99 34 67 1 1967756336 54202448 11895664
14:48:38 18712 8192000000 10904743200 11342467072 1928237712 19.053 100 35 70 1 1996962176 56823552 11900912
14:49:04 25640 8192000000 10892669152 11338899456 1899174256 18.820 98 30 59 1 1959142624 49461840 10506528
14:49:51 23278 8192000000 10904161200 11342360576 1915658912 18.952 99 35 69 1 1962995456 36529120 10807424
14:50:21 19610 8192000000 10884464576 11331424256 1920022128 18.987 99 29 58 2 1959334592 30353680 8958784
14:50:47 29801 8192000000 10889637760 11344818176 1922317200 19.005 99 26 53 1 1956149200 25701296 8130704
14:51:30 18759 8192000000 10881922384 11340525568 1947347760 19.205 100 16 32 1 1972103872 19491120 5264992
14:51:56 26518 8192000000 10886743760 11346284544 1944691616 19.184 100 16 32 2 1966126400 16476384 4958400
14:53:00 38138 8192000000 10848703728 11309170688 1875362000 18.628 97 19 38 2 1906604048 24473504 6768544
14:53:45 48887 8192000000 10827301152 11301150720 1838704320 18.330 96 13 26 1 1859873808 16888672 4280816
14:54:40 60471 8192000000 10886627632 11314987008 1906001232 18.875 99 24 46 2 1924716928 12243856 6471840
14:55:51 22402 8192000000 10886760432 11317207040 1920006336 18.987 99 53 103 0 1942459152 7637760 14815056
14:56:22 44950 8192000000 10862020320 11321016320 1938113232 19.132 100 20 40 1 1953775040 10185248 5476560
14:57:47 122053 8192000000 10860498752 11328630784 1868679056 18.574 96 10 20 0 1882039040 11003760 2356224
15:00:08 99602 8192000000 10863585008 11321647104 1842096304 18.358 95 7 14 0 1856434832 12302416 2036112
15:01:55 65372 8192000000 10918094240 11368312832 1963491392 19.334 100 13 26 3 1979500416 12714864 3294160
15:03:07 113469 8192000000 10909917424 11370369024 1948072480 19.211 98 13 26 0 1965031712 13857760 3101472
15:05:51 76617 8192000000 10903221104 11378716672 1963371200 19.333 99 6 12 1 1981664368 16840768 1452400
15:07:24 105462 8192000000 10906218368 11373039616 1963464768 19.334 99 31 62 1 1979998944 7620944 8913232
15:09:21 61425 8192000000 10915324368 11381927936 1986656512 19.517 100 31 63 2 2004895520 9159040 9079968
15:10:34 28434 8192000000 10911137280 11369361408 1961661936 19.319 99 18 35 1 1975942416 8663824 5616656
15:11:09 38273 8192000000 10919990400 11380551680 1963817024 19.336 99 26 52 0 1981853168 10572864 7463280
15:12:02 29157 8192000000 10935342208 11375755264 1980911232 19.472 100 37 72 3 1998732240 7995984 9825024
15:12:37 38682 8192000000 10908586304 11383578624 1987388048 19.523 100 31 62 1 2008429056 11798288 9242720
15:13:22 103493 8192000000 10915296448 11396628480 1978323744 19.451 99 14 29 1 1992593792 10296336 3973712
15:15:12 41052 8192000000 10914681136 11393253376 1973964944 19.417 99 16 33 0 1989572544 10717584 4890016
15:16:26 35639 8192000000 10911809616 11390771200 1956952496 19.282 98 23 46 1 1972625792 9102944 6570352
15:17:08 21809 8192000000 10917730064 11383885824 1972820288 19.408 99 13 26 1 1986047840 9185680 4041872
15:17:41 58659 8192000000 10894747712 11375276032 1951535472 19.239 98 19 38 1 1968147152 11123168 5488512
15:18:48 88883 8192000000 10905601328 11381870592 1960097600 19.307 99 19 38 1 1977956768 12194400 5664768
15:20:29 40827 8192000000 10889012528 11371282432 1947583856 19.207 98 19 38 1 1962879632 9942992 5352784
15:21:31 30288 8192000000 10872322048 11348078592 1938440048 19.134 98 22 44 0 1951831744 7584032 5807664
15:22:14 84606 8192000000 10882530576 11361976320 1917107696 18.964 97 16 32 0 1927590320 6101408 4381216
15:23:54 51514 8192000000 10861868096 11345678336 1885909104 18.713 96 2 4 0 1895374016 9042752 422160
15:24:52 40443 8192000000 10863960272 11341115392 1864795744 18.542 96 10 20 2 1877182992 9935312 2451936
15:25:39 37670 8192000000 10864144848 11317989376 1845414240 18.385 95 18 36 0 1856617600 6239952 4963408
15:26:29 32492 8192000000 10860161936 11337936896 1937223312 19.125 100 32 64 0 1954802384 9202096 8376976
15:27:12 51683 8192000000 10856488048 11322966016 1888366096 18.733 97 22 44 1 1904062720 9743616 5953008
15:28:10 45332 8192000000 10881232928 11343929344 1913742800 18.937 98 27 54 1 1928550208 7188432 7618976
15:29:03 20313 8192000000 10879202176 11334770688 1897128784 18.803 97 33 66 1 1917701056 11130592 9441680
15:29:34 30319 8192000000 10851377952 11315671040 1889436160 18.741 97 36 72 0 1914058464 14437616 10184688
15:30:13 48493 8192000000 10880864800 11338678272 1924163920 19.020 99 28 56 1 1939423392 7383808 7875664
15:31:10 24794 8192000000 10878523552 11342802944 1933017808 19.091 99 34 68 0 1954337184 11857088 9462288
15:31:46 16775 8192000000 10873010480 11326222336 1911061904 18.915 98 37 74 0 1929437584 8349552 10026128
15:32:10 24294 8192000000 10893667808 11341570048 1893115264 18.771 97 36 72 2 1912514928 9216272 10183392
15:32:41 78557 8192000000 10871136800 11358736384 1904151184 18.860 98 25 50 1 1935353824 24280960 6921680
15:34:08 44044 8192000000 10845444800 11303174144 1835023536 18.300 95 14 28 0 1853399296 14488848 3886912
15:34:58 33773 8192000000 10867620848 11313651712 1881801008 18.680 98 26 52 1 1901941776 12633168 7507600
15:35:40 46672 8192000000 10857799904 11304042496 1836366848 18.311 95 32 64 2 1854250832 9027248 8856736
15:36:35 48248 8192000000 10868229568 11318521856 1890862096 18.753 98 47 94 1 1916578928 12648432 13068400
15:37:33 72126 8192000000 10854069040 11309711360 1852450080 18.442 96 30 60 1 1876240880 14461984 9328816
15:38:51 129751 8192000000 10859681856 11333746688 1912360704 18.926 99 39 77 1 1943802160 19887728 11553728
15:41:16 53264 8192000000 10877334096 11338178560 1933962720 19.099 100 19 38 0 1957647840 17980096 5705024
15:42:15 42458 8192000000 10854340016 11327037440 1905523888 18.871 98 15 30 1 1921242832 11625664 4093280
15:43:04 91429 8192000000 10856638784 11332313088 1920797296 18.993 99 11 21 2 1936136032 11253152 4085584
15:44:43 32625 8192000000 10857652960 11341484032 1936001088 19.115 100 2 2 0 1944849024 8755808 92128
15:45:21 51312 8192000000 10872580944 11344683008 1933031328 19.091 99 26 52 3 1949685760 9379504 7274928
15:46:25 59597 8192000000 10884300912 11352748032 1921766288 19.001 98 16 32 0 1940859712 14548304 4545120
15:48:03 54059 8192000000 10891454064 11365412864 1943939424 19.178 99 25 51 1 1968406528 17132192 7334912
15:49:04 36546 8192000000 10886380048 11357798400 1943821648 19.177 99 14 28 3 1960379984 12728384 3829952
15:49:49 66151 8192000000 10907386912 11364241408 1946209728 19.196 99 28 56 1 1964509616 10145888 8154000
15:51:04 94751 8192000000 10893930720 11368853504 1966003024 19.354 100 23 46 1 1986204096 13571136 6629936
15:52:47 79192 8192000000 10889194128 11363160064 1931749216 19.081 98 15 30 1 1945187136 9497568 3940352
15:54:18 40202 8192000000 10912379808 11371511808 1949125680 19.220 99 28 56 2 1970307104 13664064 7517360
15:55:04 51157 8192000000 10888244768 11356557312 1908504784 18.895 97 22 44 1 1927828032 13201808 6121440
15:56:02 98134 8192000000 10882554416 11361271808 1904555104 18.863 97 19 38 0 1925816096 16201696 5059296
15:57:47 146330 8192000000 10898692896 11359051776 1906094784 18.875 97 15 30 0 1922592992 12349936 4148272
16:00:59 56959 8192000000 10878372288 11339620352 1917667712 18.968 98 29 58 0 1934199504 8701872 7829920
16:02:02 25330 8192000000 10874246768 11340455936 1946360624 19.197 100 28 56 0 1963399488 9999696 7039168
16:02:38 46354 8192000000 10865044096 11345960960 1940653632 19.152 99 13 26 0 1950914976 6753936 3507408
16:04:01 27780 8192000000 10856718832 11334066176 1932214528 19.085 99 6 12 0 1941870352 8188000 1467824
16:04:39 48972 8192000000 10876463200 11355140096 1952005024 19.242 100 10 18 2 1964653872 10123008 2525840
16:05:39 65939 8192000000 10856898992 11337961472 1821614240 18.191 93 6 12 0 1833881952 11005472 1262240
16:06:59 84753 8192000000 10868858288 11342266368 1875855600 18.632 96 18 36 1 1889894992 9353552 4685840
16:08:31 44474 8192000000 10878579264 11342311424 1912388304 18.926 98 16 32 0 1925475872 8549040 4538528
16:09:29 60241 8192000000 10871303760 11339145216 1889960592 18.745 97 16 32 0 1907064144 12555456 4548096
16:10:37 61628 8192000000 10874550672 11345575936 1891788928 18.760 97 26 52 1 1918601488 18825664 7986896
16:11:44 75948 8192000000 10868844688 11337588736 1868051760 18.569 96 8 16 1 1887845520 17020432 2773328
16:13:11 29246 8192000000 10905061616 11354112000 1928868480 19.058 99 23 46 1 1947518304 12041952 6607872
16:13:51 35791 8192000000 10912795072 11374239744 1961842832 19.321 100 40 80 2 1993382768 20090512 11449424
16:14:33 38551 8192000000 10907840272 11365625856 1919662864 18.984 98 40 79 1 1952283104 21313248 11306992
16:15:23 75263 8192000000 10916964768 11365462016 1937113232 19.124 99 17 34 0 1956338928 14509472 4716224
16:16:45 99992 8192000000 10873788528 11339485184 1878623520 18.654 96 24 48 1 1899594080 14080704 6889856
16:18:48 150548 8192000000 10845095056 11303792640 1829542320 18.256 94 15 30 0 1850651600 16055824 5053456
16:21:43 45471 8192000000 10852239520 11318452224 1903205872 18.852 98 19 36 2 1915732592 7307056 5219664
16:22:42 84218 8192000000 10845386640 11332567040 1908853008 18.897 99 6 12 0 1922752416 12473296 1426112
16:24:13 50468 8192000000 10843507616 11313676288 1893639888 18.775 98 12 24 0 1904158560 7255952 3262720
16:25:10 54721 8192000000 10826181776 11279769600 1852858176 18.445 96 20 39 1 1865413440 7252976 5302288
16:26:24 62137 8192000000 10841268336 11311132672 1870102672 18.585 97 26 53 1 1890258880 12173312 7982896
16:27:42 83173 8192000000 10863932656 11331108864 1897291600 18.805 98 28 56 2 1921514320 15627184 8595536
16:29:11 92240 8192000000 10844362256 11333898240 1903348816 18.853 99 9 18 1 1922463200 16626592 2487792
16:31:09 57295 8192000000 9165038624 9409871872 313847136 3.689 17 2 4 0 316015776 1777408 391232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 10-12-2020 16:33:39 to 10-12-2020 16:34:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 158 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-12-2020 16:34:09 to 10-12-2020 16:34:11.

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          258213
MON$OLDEST_ACTIVE               258214
MON$OLDEST_SNAPSHOT             258214
MON$NEXT_TRANSACTION            258214
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                       2046368
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.33399 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33399 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33399 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33399 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 ---
--- end of diff output ---

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

10.12.20 16:34:12. 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-10 16:34:15 No severe PSQL-related problems occured
10.12.20 16:34:16. End of report.