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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17314464 kB
MemAvailable 31518340 kB
Buffers 0 kB
Cached 14416492 kB
SwapCached 3300 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-11-24 16:27:02
DTS_END                         2020-11-24 16:27:02.7110
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/37850
TRN_ID                          242769
ATT_ID                          675
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: 9391.55 21521 1126986
customer order: creation 176.31 395 21157
customer order: refuse 14.79 379 1775
order to supplier: creation 45.55 1356 5466
order to supplier: removal 3.50 104712 420
invoice (draft): creation 47.74 3486 5729
invoice (draft): removal 54.16 799 6499
invoice accept: apply 41.97 18060 5036
invoice accept: cancel 48.36 747 5803
customer reserve: creation 3899.11 177 467893
customer reserve: removal 4751.08 60 570129
realization accept: apply 84.55 194 10146
realization accept: cancel 92.91 105 11149
payment from customer: creation 60.39 131 7247
payment from customer: removal 5.89 117 707
payment to supplier: creation 49.53 140 5943
payment to supplier: removal 3.73 123 447
service: total inventory turnovers 4.51 1277 541
service: total monetary turnovers 6.68 75 802
service: aggregate perf. data 0.78 23540 93
service: refresh index statistics 0.03 274543 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-11-2020 16:28:38 to 24-11-2020 16:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4805
TEST_TIME 2 2951
TEST_TIME 3 4487
TEST_TIME 4 4558
TEST_TIME 5 5143
TEST_TIME 6 5162
TEST_TIME 7 5781
TEST_TIME 8 5926
TEST_TIME 9 5857
TEST_TIME 10 5901
TEST_TIME 11 5871
TEST_TIME 12 6023
TEST_TIME 13 6156
TEST_TIME 14 6406
TEST_TIME 15 6627
TEST_TIME 16 6935
TEST_TIME 17 7301
TEST_TIME 18 7709
TEST_TIME 19 7833
TEST_TIME 20 8435
TEST_TIME 21 8765
TEST_TIME 22 8808
TEST_TIME 23 9103
TEST_TIME 24 9531
TEST_TIME 25 9747
TEST_TIME 26 10111
TEST_TIME 27 10388
TEST_TIME 28 11282
TEST_TIME 29 11148
TEST_TIME 30 11348
TEST_TIME 31 11169
TEST_TIME 32 11174
TEST_TIME 33 11123
TEST_TIME 34 11060
TEST_TIME 35 10793
TEST_TIME 36 10705
TEST_TIME 37 10730
TEST_TIME 38 10672
TEST_TIME 39 10726
TEST_TIME 40 10554
TEST_TIME 41 10438
TEST_TIME 42 10404
TEST_TIME 43 10456
TEST_TIME 44 10372
TEST_TIME 45 10416
TEST_TIME 46 10371
TEST_TIME 47 10326
TEST_TIME 48 10226
TEST_TIME 49 10090
TEST_TIME 50 10066
TEST_TIME 51 10061
TEST_TIME 52 9945
TEST_TIME 53 9969
TEST_TIME 54 9831
TEST_TIME 55 9779
TEST_TIME 56 9738
TEST_TIME 57 9727
TEST_TIME 58 9670
TEST_TIME 59 9677
TEST_TIME 60 9849
TEST_TIME 61 9983
TEST_TIME 62 10112
TEST_TIME 63 10075
TEST_TIME 64 10214
TEST_TIME 65 10228
TEST_TIME 66 10266
TEST_TIME 67 10328
TEST_TIME 68 10290
TEST_TIME 69 10336
TEST_TIME 70 10224
TEST_TIME 71 10154
TEST_TIME 72 10106
TEST_TIME 73 10088
TEST_TIME 74 10028
TEST_TIME 75 9972
TEST_TIME 76 9917
TEST_TIME 77 9895
TEST_TIME 78 9841
TEST_TIME 79 9736
TEST_TIME 80 9644
TEST_TIME 81 9662
TEST_TIME 82 9778
TEST_TIME 83 9788
TEST_TIME 84 9779
TEST_TIME 85 9808
TEST_TIME 86 9792
TEST_TIME 87 9755
TEST_TIME 88 9755
TEST_TIME 89 9837
TEST_TIME 90 9869
TEST_TIME 91 9873
TEST_TIME 92 9808
TEST_TIME 93 9858
TEST_TIME 94 9891
TEST_TIME 95 9793
TEST_TIME 96 9761
TEST_TIME 97 9732
TEST_TIME 98 9692
TEST_TIME 99 9638
TEST_TIME 100 9648
TEST_TIME 101 9626
TEST_TIME 102 9623
TEST_TIME 103 9601
TEST_TIME 104 9616
TEST_TIME 105 9608
TEST_TIME 106 9627
TEST_TIME 107 9626
TEST_TIME 108 9632
TEST_TIME 109 9622
TEST_TIME 110 9645
TEST_TIME 111 9655
TEST_TIME 112 9703
TEST_TIME 113 9712
TEST_TIME 114 9657
TEST_TIME 115 9594
TEST_TIME 116 9558
TEST_TIME 117 9533
TEST_TIME 118 9493
TEST_TIME 119 9472
TEST_TIME 120 9394

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-11-2020 16:28:41 to 24-11-2020 16:28:45.

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 1561683 1561683 0 0.00 0 23623 6 0 0
doc_list_biud 1561683 1561683 0 0.00 0 25187 28 0 0
sp_add_invoice_to_stock 5122 5036 86 1.67 41 172458 18061 0 86
sp_cancel_adding_invoice 5803 5803 0 0.00 3 64349 748 0 0
sp_cancel_client_order 1775 1775 0 0.00 5 17364 380 0 0
sp_cancel_customer_reserve 570129 570129 0 0.00 1 21091 61 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 3 7505 117 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 7143 124 0 0
sp_cancel_supplier_invoice 6508 6499 9 0.13 1 18149 800 0 9
sp_cancel_supplier_order 420 420 0 0.00 11 1221929 104713 0 0
sp_cancel_write_off 11149 11149 0 0.00 1 15973 105 0 0
sp_client_order 21157 21157 0 0.00 3 77785 395 0 0
sp_customer_reserve 467893 467893 0 0.00 0 52365 177 0 0
sp_fill_shopping_cart 32348 32348 0 0.00 1 31604 41 0 0
sp_fill_shopping_cart_clo_res 467890 467890 0 0.00 0 19731 16 0 0
sp_get_clo_for_invoice 5033 5033 0 0.00 0 19492 292 0 0
sp_kill_cost_storno 18106 18106 0 0.00 0 23612 59 0 0
sp_kill_qstorno_ret_qs2qd 1158326 1158326 0 0.00 0 21086 33 0 0
sp_kill_qty_storno 610954 610954 0 0.00 0 25186 71 0 0
sp_lock_selected_doc 21145 21145 0 0.00 0 9774 5 0 0
sp_make_cost_storno 28369 28369 0 0.00 0 20026 57 0 0
sp_multiply_rows_for_pdistr 28369 28369 0 0.00 0 9709 37 0 0
sp_multiply_rows_for_qdistr 21157 21157 0 0.00 0 73278 178 0 0
sp_pay_from_customer 7247 7247 0 0.00 4 16141 131 0 0
sp_pay_to_supplier 5943 5943 0 0.00 5 10863 140 0 0
sp_payment_common 13190 13190 0 0.00 1 9568 42 0 0
sp_qd_handle_on_cancel_clo 1775 1775 0 0.00 0 17285 350 0 0
sp_qd_handle_on_invoice_upd_sts 10836 10836 0 0.00 0 25183 334 0 0
sp_qd_handle_on_reserve_upd_sts 10146 10146 0 0.00 0 20790 72 0 0
sp_reserve_write_off 10146 10146 0 0.00 6 27002 195 0 0
sp_supplier_invoice 5729 5729 0 0.00 7 91261 3487 0 0
sp_supplier_order 5466 5466 0 0.00 5 41602 1357 0 0
srv_aggregate_perf_data 93 93 0 0.00 2556 200462 23540 0 0
srv_fill_mon_cache_memory 181 181 0 0.00 1002 128962 29360 0 0
srv_find_qd_qs_mism 1079150 1079150 0 0.00 0 11754 5 0 0
srv_make_invnt_saldo 541 541 0 0.00 50 71097 1278 0 0
srv_make_money_saldo 802 802 0 0.00 1 15269 75 0 0
srv_recalc_idx_stat 4 4 0 0.00 80214 400699 274543 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5037 5037 0 0.00 0 33660 202 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 15979 122 0 0
t$perf-norm:sp_cancel_client_order 1775 1775 0 0.00 0 6201 21 0 0
t$perf-norm:sp_cancel_customer_reserve 766 766 0 0.00 0 5196 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 14369 33 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 596 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 4008 20 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 22446 1600 0 0
t$perf-norm:sp_cancel_write_off 996 996 0 0.00 0 1712 8 0 0
t$perf-norm:sp_client_order 21157 21157 0 0.00 0 8451 21 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 2753 8 0 0
t$perf-norm:sp_pay_from_customer 7247 7247 0 0.00 0 32653 20 0 0
t$perf-norm:sp_pay_to_supplier 5943 5943 0 0.00 0 5466 13 0 0
t$perf-norm:sp_reserve_write_off 10146 10146 0 0.00 0 6989 15 0 0
t$perf-norm:sp_supplier_invoice 5729 5729 0 0.00 0 9150 27 0 0
t$perf-norm:sp_supplier_order 5466 5466 0 0.00 0 5729 22 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 238 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 181 181 0 0.00 0 618 11 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 1678 28 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2838 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10238 10066 172 1.68 0 6799 18 0 172
v_all_customers 38692 38692 0 0.00 0 28 1 0 0
v_all_suppliers 30998 30998 0 0.00 0 16 1 0 0
v_all_wares 42310 42310 0 0.00 0 106 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 50 5 0 0
v_cancel_client_order 3550 3550 0 0.00 0 4884 6 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 5481 12 0 0
v_cancel_customer_reserve 1532 1532 0 0.00 0 2454 6 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 1790 6 0 0
v_cancel_supplier_invoice 910 892 18 1.97 0 4438 21 0 18
v_cancel_supplier_order 840 840 0 0.00 0 441 4 0 0
v_cancel_write_off 1992 1992 0 0.00 0 3538 14 0 0
v_max_id_clo_ord 5465 5465 0 0.00 0 1292 1 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 2293 14 0 0
v_max_id_ord_sup 5728 5728 0 0.00 0 7342 5 0 0
v_max_non_paid_invoice 1637 1637 0 0.00 0 3289 6 0 0
v_max_non_paid_realizn 3770 3770 0 0.00 0 7062 10 0 0
v_min_id_clo_ord 5465 5465 0 0.00 0 30746 20 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 8228 22 0 0
v_min_id_ord_sup 5728 5728 0 0.00 0 6095 6 0 0
v_min_non_paid_invoice 5943 5943 0 0.00 0 7129 27 0 0
v_min_non_paid_realizn 7247 7247 0 0.00 0 7193 30 0 0
v_our_firm 10572 10572 0 0.00 0 15 1 0 0
v_reserve_write_off 20288 20288 0 0.00 0 6507 5 0 0
x_lock_depdocs_on_canc_invoice 11856 11856 0 0.00 0 20623 120 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 20816 354 0 0
x_make_qstorno_1000_1200 5466 5466 0 0.00 2 41518 1261 0 0
x_make_qstorno_1200_2000 5729 5729 0 0.00 3 91253 3346 0 0
x_make_qstorno_2100_3300 467893 467893 0 0.00 0 52364 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-11-2020 16:28:46 to 24-11-2020 16:28:50.

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
13:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:12 4016 8192000000 9832671536 10062827520 732830800 8.211 62 49 102 1 752444800 2084160 17529840
13:57:27 28857 8192000000 10315366016 10628882432 1354841328 14.191 100 89 177 2 1388071360 4176112 29053920
13:58:04 29677 8192000000 10366954320 10686107648 1422303936 14.793 100 88 176 0 1456924464 6088224 28532304
13:58:49 22679 8192000000 10394122368 10717351936 1443305584 14.979 100 91 182 2 1480873328 7403952 30163792
13:59:22 19099 8192000000 10413725008 10741350400 1467289088 15.190 100 92 182 0 1505129008 7955952 29883968
13:59:58 20189 8192000000 10433357072 10764312576 1488466560 15.375 100 94 188 1 1527743488 8847088 30429840
14:00:27 19269 8192000000 10447040432 10780721152 1497647632 15.456 100 87 174 2 1534768000 9132048 27988320
14:00:55 8524 8192000000 10463587840 10799439872 1515626624 15.612 100 85 168 0 1551961840 9438448 26896768
14:01:11 13658 8192000000 10472630432 10817343488 1532832368 15.762 100 83 166 1 1569376128 10132896 26410864
14:01:40 10690 8192000000 10514204272 10862436352 1574919344 16.125 100 79 158 0 1610235712 10297824 25018544
14:02:01 15342 8192000000 10540001904 10895101952 1599553072 16.336 100 74 148 0 1632221536 10406528 22261936
14:02:25 13905 8192000000 10563136000 10920566784 1619373696 16.505 100 81 162 0 1655797600 11772800 24651104
14:02:47 11065 8192000000 10574901424 10929860608 1634633408 16.634 100 86 171 2 1672132128 11850032 25648688
14:03:05 12762 8192000000 10606028928 10969235456 1659651872 16.846 100 81 163 0 1695392048 11893696 23846480
14:03:27 7878 8192000000 10615566016 10985746432 1678637024 17.006 100 75 150 1 1713522480 12370848 22514608
14:03:46 10464 8192000000 10633585232 11007094784 1695384672 17.146 100 71 142 1 1728486672 12216112 20885888
14:04:05 8220 8192000000 10660661712 11032883200 1717583120 17.332 100 76 151 2 1751576144 12197104 21795920
14:04:21 7236 8192000000 10668974688 11043962880 1737217088 17.496 100 86 173 2 1773963056 12076576 24669392
14:04:35 5439 8192000000 10677477264 11054321664 1743719744 17.550 100 88 175 1 1780357088 11867648 24769696
14:04:50 6474 8192000000 10695479520 11071254528 1755789024 17.650 100 80 160 1 1790949296 12512800 22647472
14:05:03 4460 8192000000 10708669952 11083632640 1765124080 17.727 100 87 171 3 1802933216 13638096 24171040
14:05:15 4009 8192000000 10710818880 11089506304 1771411056 17.779 100 82 164 0 1807011872 12947344 22653472
14:05:27 4702 8192000000 10725848640 11107143680 1784902336 17.890 100 75 150 1 1818479264 12643872 20933056
14:05:38 3499 8192000000 10734535632 11112550400 1790474704 17.936 100 86 172 0 1828222048 13847792 23899552
14:05:48 2793 8192000000 10731542672 11114758144 1796151344 17.982 100 90 178 1 1834856880 13204560 25500976
14:05:57 3170 8192000000 10744058944 11128356864 1805793920 18.061 100 85 167 2 1842042976 12829264 23419792
14:06:08 1994 8192000000 10751868064 11134726144 1812230352 18.114 100 90 178 0 1851372672 14408848 24733472
14:06:17 3583 8192000000 10761433200 11144376320 1815672288 18.142 100 90 177 1 1854501232 14542080 24286864
14:06:27 2388 8192000000 10760596112 11147808768 1822212608 18.196 100 91 182 0 1862653040 15202272 25238160
14:06:40 2820 8192000000 10763791568 11147694080 1822672288 18.200 100 83 166 0 1860555328 14397488 23485552
14:06:50 2455 8192000000 10772388432 11160625152 1835815984 18.307 100 88 177 0 1874922416 14878144 24228288
14:06:58 2160 8192000000 10780287632 11166269440 1837893328 18.324 100 85 169 0 1874558192 13470064 23194800
14:07:07 2003 8192000000 10790996672 11176198144 1844894448 18.381 100 86 172 0 1882985568 13722064 24369056
14:07:15 1768 8192000000 10788764816 11177885696 1849779008 18.420 100 88 174 1 1886839552 13098496 23962048
14:07:24 2179 8192000000 10804693792 11190075392 1858147680 18.488 100 94 189 0 1898565376 13920224 26497472
14:07:32 1982 8192000000 10804776320 11190870016 1857586528 18.484 100 91 183 1 1896983568 13740672 25656368
14:07:41 2168 8192000000 10804963552 11193659392 1859784576 18.502 100 87 175 2 1897951408 13420384 24746448
14:07:50 1732 8192000000 10805588816 11197476864 1866477952 18.556 100 90 179 0 1905987376 13911856 25597568
14:07:58 1794 8192000000 10815540848 11203637248 1870290560 18.587 100 90 179 2 1907649408 12725792 24633056
14:08:06 3223 8192000000 10818525152 11206549504 1874892240 18.624 100 96 190 2 1914920816 13137792 26890784
14:08:16 1989 8192000000 10824142800 11214266368 1879291712 18.659 100 91 184 0 1917655216 12376576 25986928
14:08:24 39108 8192000000 10803456000 11209990144 1873541600 18.613 100 57 114 1 1900713952 9586624 17585728
14:09:11 1315 8192000000 10825762800 11217580032 1881146480 18.674 100 85 172 1 1915824944 9345616 25332848
14:09:20 1117 8192000000 10830671248 11223994368 1885514656 18.710 100 81 162 0 1919781872 10545648 23721568
14:09:28 4681 8192000000 10797425392 11219927040 1882293984 18.684 100 49 98 0 1906922128 10365264 14262880
14:09:40 4832 8192000000 10801319792 11222138880 1883042752 18.690 100 45 91 1 1904843984 8913968 12887264
14:09:52 9526 8192000000 10797370576 11224477696 1880723408 18.671 100 26 52 0 1895249472 7615776 6910288
14:10:09 5133 8192000000 10810167904 11225812992 1889065744 18.738 100 46 93 1 1909228000 7093024 13069232
14:10:26 7264 8192000000 10805444832 11225346048 1884811968 18.704 100 21 42 2 1896998304 6058912 6127424
14:10:42 7551 8192000000 10796709472 11225591808 1886154720 18.715 100 18 36 3 1897886160 6439888 5291552
14:10:56 8825 8192000000 10795987600 11230953472 1889844256 18.745 100 22 42 3 1902794176 7251888 5698032
14:11:14 15252 8192000000 10803796304 11233452032 1894823600 18.785 100 17 34 0 1905515696 6361680 4330416
14:11:37 3455 8192000000 10819583664 11241943040 1902286384 18.845 100 46 91 1 1924548672 8777136 13485152
14:11:50 6164 8192000000 10811486640 11241439232 1899963840 18.826 100 29 58 2 1915196608 6956896 8275872
14:12:03 8038 8192000000 10807548160 11241836544 1899459520 18.822 100 24 46 5 1912682800 6760624 6462656
14:12:17 6376 8192000000 10821432480 11245637632 1901229328 18.836 100 32 64 0 1917039216 6447440 9362448
14:12:32 27804 8192000000 10803463808 11246907392 1901629568 18.839 100 27 54 0 1916455232 6683984 8141680
14:13:30 23030 8192000000 10822171216 11256844288 1905110112 18.867 100 30 60 0 1920733760 7645904 7977744
14:14:03 6884 8192000000 10813876512 11253817344 1904472496 18.862 100 20 40 1 1916010848 5827456 5710896
14:14:18 6971 8192000000 10817116560 11252948992 1904984096 18.866 100 23 46 1 1917126624 5721440 6421088
14:14:33 6851 8192000000 10826414256 11256418304 1905615136 18.871 100 27 54 2 1918939408 6013872 7310400
14:14:46 4338 8192000000 10834582784 11258490880 1911945840 18.922 100 38 74 0 1928923168 7216400 9760928
14:15:02 9710 8192000000 10815421920 11256049664 1906923264 18.882 100 26 51 1 1920037568 5472960 7641344
14:15:18 9069 8192000000 10806754288 11248254976 1890560928 18.750 99 24 46 1 1903151568 5131088 7459552
14:15:33 6668 8192000000 10810901984 11252400128 1903690048 18.856 100 16 32 1 1914468976 6021712 4757216
14:15:51 7658 8192000000 10822289600 11260981248 1908158080 18.892 100 16 32 1 1921656000 9439328 4058592
14:16:05 10990 8192000000 10825191616 11254636544 1886731456 18.719 99 19 38 0 1897972096 5748176 5492464
14:16:24 6283 8192000000 10801401600 11245219840 1899249184 18.820 100 23 46 4 1911674256 5498848 6926224
14:16:41 18325 8192000000 10797372992 11233353728 1858919696 18.495 98 13 26 0 1868301648 5688544 3693408
14:17:06 11063 8192000000 10805393824 11225882624 1836219136 18.310 97 14 27 2 1845512304 5143344 4149824
14:17:23 78048 8192000000 10727892288 11158962176 1643654688 16.711 87 24 48 0 1655345040 4507088 7183264
14:18:50 10833 8192000000 10759731744 11170021376 1785896384 17.898 97 22 44 1 1806079520 13648704 6534432
14:19:08 6403 8192000000 10758962448 11180888064 1813934592 18.128 98 22 42 2 1826069072 5470096 6664384
14:19:24 7016 8192000000 10749664592 11171229696 1805717696 18.061 98 25 49 2 1818845824 5878160 7249968
14:19:39 8607 8192000000 10718777872 11132977152 1692671232 17.124 92 23 45 3 1703969920 4642208 6656480
14:19:54 3275 8192000000 10671056416 11070980096 1692175952 17.120 94 32 63 1 1706823056 5754496 8892608
14:20:03 8734 8192000000 10669231872 11087929344 1690140672 17.102 95 26 52 0 1703326416 5340880 7844864
14:20:21 12412 8192000000 10691521808 11106631680 1706970176 17.243 95 12 25 0 1715392496 5388112 3034208
14:20:41 7395 8192000000 10687588608 11100004352 1772550336 17.788 99 30 60 4 1787055344 6177200 8327808
14:20:55 11282 8192000000 10721841184 11125633024 1759761120 17.682 98 35 72 2 1774729104 4802208 10165776
14:21:14 6873 8192000000 10736056368 11143176192 1811701216 18.110 100 27 55 3 1824466384 4817248 7947920
14:21:27 10760 8192000000 10743678560 11161030656 1809373968 18.091 99 28 55 2 1823383712 5782176 8227568
14:21:46 11591 8192000000 10723660144 11153661952 1795900944 17.980 98 25 50 2 1809507264 6030624 7575696
14:22:09 16550 8192000000 10730745600 11144560640 1757301296 17.662 96 32 64 0 1771791376 4607296 9882784
14:22:32 67756 8192000000 10728140560 11154710528 1807357712 18.074 99 21 39 1 1818523504 4799008 6366784
14:23:47 7745 8192000000 10732758336 11157929984 1809790672 18.094 99 18 37 0 1820603840 5312576 5500592
14:24:03 9065 8192000000 10759866736 11181666304 1838759024 18.331 100 29 57 2 1853692768 6042016 8891728
14:24:24 8267 8192000000 10765525120 11191144448 1847001328 18.398 100 10 21 0 1854922832 5259760 2661744
14:24:42 7207 8192000000 10783584624 11197382656 1857864240 18.486 100 32 64 1 1872730304 4863312 10002752
14:24:55 8601 8192000000 10774680320 11201994752 1860181216 18.505 100 21 40 2 1871176240 4839184 6155840
14:25:11 9498 8192000000 10781217728 11211448320 1868123344 18.569 100 25 49 3 1880770544 5100528 7546672
14:25:26 6943 8192000000 10790990976 11216539648 1872958800 18.608 100 31 61 1 1888508048 6432080 9117168
14:25:43 9811 8192000000 10786360656 11217326080 1873802032 18.615 100 21 42 0 1885650560 5566736 6281792
14:26:01 11279 8192000000 10791932896 11217891328 1873891408 18.616 100 16 32 0 1883614352 4981888 4741056
14:26:18 7582 8192000000 10784989248 11221213184 1882691568 18.687 100 37 74 2 1899392672 5481520 11219584
14:26:34 11106 8192000000 10804786544 11225292800 1882723408 18.687 100 21 43 2 1894178064 4988256 6466400
14:26:52 25528 8192000000 10804099552 11228188672 1882481088 18.685 100 14 26 2 1891437584 5440368 3516128
14:27:35 21870 8192000000 10851141408 11263619072 1915758848 18.953 100 48 94 2 1936635216 7338208 13538160
14:28:05 128961 8192000000 10877637776 11300507648 1933742736 19.097 100 46 92 1 1957801040 11271392 12786912
14:30:21 10891 8192000000 10861222736 11291058176 1935875472 19.114 100 28 56 0 1956198560 12235088 8088000
14:30:39 39700 8192000000 10881037456 11316854784 1951605360 19.239 100 37 72 1 1977074272 15252928 10215984
14:31:30 34157 8192000000 10882179808 11319169024 1952209024 19.244 100 31 62 0 1976885072 15593584 9082464
14:32:10 9130 8192000000 10900801232 11328028672 1960117568 19.307 100 42 84 2 1988107296 15320160 12669568
14:32:28 3486 8192000000 10920349904 11345313792 1971682048 19.399 100 63 122 1 2006834864 16100144 19052672
14:32:40 2837 8192000000 10911406608 11337936896 1972033248 19.402 100 56 111 2 2006116816 17696400 16387168
14:32:49 13165 8192000000 10918138752 11345907712 1972789968 19.408 100 49 96 0 2003911840 17619104 13502768
14:33:11 15825 8192000000 10927087952 11350417408 1978674144 19.454 100 58 116 0 2014258496 19006288 16578064
14:33:42 8017 8192000000 10936032832 11362353152 1988004656 19.528 100 68 135 2 2029668752 22699264 18964832
14:33:56 2450 8192000000 10934859856 11361398784 1987435920 19.524 100 58 114 0 2026636032 22638176 16561936
14:34:05 7423 8192000000 10927242480 11363303424 1988671888 19.533 100 57 112 3 2027603824 22305808 16626128
14:34:26 11640 8192000000 10937522016 11368214528 1992985632 19.567 100 56 112 1 2028610352 18603520 17021200
14:34:51 12060 8192000000 10940708416 11378651136 2000451456 19.626 100 44 88 3 2032887760 18055424 14380880
14:35:11 15131 8192000000 10950906912 11389108224 2008056592 19.686 100 52 104 1 2044322096 20439840 15825664
14:35:36 20355 8192000000 10962322000 11399696384 2012104528 19.718 100 55 110 0 2050663840 21887808 16671504
14:36:03 11721 8192000000 10960082928 11400777728 2019425856 19.776 100 46 92 2 2054464416 21509600 13528960
14:36:35 2651 8192000000 10970847520 11404836864 2019953056 19.780 100 47 93 0 2053992032 20093136 13945840
14:36:45 4216 8192000000 10965702208 11398651904 2015694976 19.746 100 57 114 1 2054273024 20951760 17626288
14:36:56 6108 8192000000 10971603840 11400548352 2018490704 19.768 100 57 113 3 2057527344 21899152 17137488
14:37:10 3846 8192000000 10966677024 11402088448 2022356016 19.799 100 56 110 0 2061427376 22857552 16213808
14:37:22 10817 8192000000 10986505408 11407241216 2027865344 19.842 100 68 136 0 2070677232 22919552 19892336
14:37:40 2652 8192000000 10989625200 11414851584 2031981696 19.874 100 73 141 1 2077450752 25430736 20038320
14:37:53 3469 8192000000 10986751792 11409350656 2010228560 19.703 99 67 133 0 2057587808 26983648 20375600
14:38:03 5613 8192000000 10978007216 11408343040 2008793248 19.692 99 81 162 3 2059926064 27413360 23719456
14:38:15 9183 8192000000 10977438608 11410165760 2019008608 19.772 100 61 120 0 2063403136 26607648 17786880
14:38:33 6659 8192000000 10971208992 11402313728 2001028752 19.631 99 55 110 0 2044262832 26583888 16650192
14:38:51 7727 8192000000 10974762032 11403194368 1999195072 19.616 99 63 124 2 2046968000 28397856 19375072
14:39:07 3798 8192000000 10989156272 11403919360 2012086864 19.718 100 78 153 3 2064588480 28560944 23940672
14:39:18 9946 8192000000 10976574480 11410595840 2021016768 19.788 100 62 124 0 2068876144 29215632 18643744
14:39:38 6410 8192000000 10992131328 11418382336 2024211424 19.813 100 75 150 1 2079106112 32010560 22884128
14:39:51 3907 8192000000 10988188752 11403534336 2006262224 19.672 99 81 159 1 2061453360 31901984 23289152
14:40:01 5021 8192000000 11001841104 11423117312 2029025296 19.851 100 81 160 2 2085700496 33062128 23613072
14:40:14 4837 8192000000 10977366336 11395735552 1985772144 19.510 98 73 144 0 2040626832 33371456 21483232
14:40:27 6330 8192000000 10976724000 11401781248 2009983296 19.701 100 77 154 1 2066580720 33663952 22933472
14:40:42 8510 8192000000 10963122000 11392774144 2000529232 19.627 100 62 124 0 2053229712 34335824 18364656
14:41:00 4630 8192000000 10956656848 11380576256 1989032416 19.536 99 57 114 0 2038983904 32991392 16960096
14:41:14 6294 8192000000 10984104016 11407822848 2007769392 19.684 100 68 136 3 2062762256 33814096 21178768
14:41:28 5541 8192000000 10959657616 11380117504 1964842368 19.345 98 77 154 1 2023798752 34849760 24106624
14:41:41 2265 8192000000 10968142464 11389521920 1994277728 19.578 100 76 151 0 2052222928 34979056 22966144
14:41:52 1850 8192000000 10974486192 11382951936 1986917776 19.519 100 90 175 0 2052005488 38674480 26413232
14:42:03 3512 8192000000 10958364512 11363753984 1957173712 19.284 99 90 179 3 2024257824 39498288 27585824
14:42:16 3515 8192000000 10956092544 11369873408 1972057616 19.402 100 84 168 0 2040968896 42891824 26019456
14:42:28 1828 8192000000 10969325344 11381497856 1965734560 19.352 99 86 173 0 2036503200 43723360 27045280
14:42:37 1583 8192000000 10953892032 11373125632 1967463360 19.365 99 82 162 1 2036061872 43686256 24912256
14:42:45 4632 8192000000 10965081984 11378671616 1974447872 19.421 100 86 169 1 2044924528 44313760 26162896
14:42:58 2918 8192000000 10939628720 11346063360 1937497008 19.127 99 80 160 0 2006112864 43285408 25330448
14:43:10 3550 8192000000 10937138192 11356028928 1959670192 19.303 100 72 144 0 2027541312 44867120 23004000
14:43:22 2637 8192000000 10929359280 11337199616 1943352112 19.173 99 73 145 2 2008466976 41990864 23124000
14:43:32 1697 8192000000 10930188144 11329695744 1924059968 19.019 98 89 176 1 1994962032 42822032 28080032
14:43:42 2592 8192000000 10943930976 11346202624 1950693328 19.232 100 90 177 2 2022406704 44100592 27612784
14:43:53 3711 8192000000 10935686608 11348725760 1949921552 19.226 100 77 154 2 2020197584 46208528 24067504
14:44:10 3092 8192000000 10924186640 11334053888 1932858624 19.090 99 83 166 1 2006270352 47614032 25797696
14:44:23 6943 8192000000 10929998048 11339812864 1939678880 19.144 100 73 137 2 2011031872 48814672 22538320
14:44:38 2259 8192000000 10950630032 11359490048 1955928112 19.274 100 83 167 2 2033275456 49688832 27658512
14:44:48 2197 8192000000 10950687904 11356241920 1950097664 19.227 100 90 181 1 2029879216 51312752 28468800
14:44:57 3826 8192000000 10924959888 11338694656 1934421344 19.102 99 80 160 2 2009784656 49462352 25900960
14:45:10 3710 8192000000 10933279136 11345068032 1939949584 19.146 100 68 136 2 2011410112 49265664 22194864
14:45:22 2015 8192000000 10944066000 11349524480 1934571072 19.103 99 83 164 1 2012464048 51320576 26572400
14:45:31 6925 8192000000 10939054112 11347714048 1940534160 19.151 100 83 165 2 2017633856 51231968 25867728
14:45:45 3621 8192000000 10950368944 11357020160 1950637056 19.232 100 86 172 0 2028246880 50303776 27306048
14:45:56 5437 8192000000 10937357088 11357016064 1958418688 19.293 100 77 152 1 2027317328 45429920 23468720
14:46:09 1428 8192000000 10962121360 11369598976 1951935248 19.242 99 92 182 0 2027447040 48734592 26777200
14:46:17 2573 8192000000 10951100816 11358699520 1947968416 19.210 99 84 168 0 2024921680 51036160 25917104
14:46:27 1948 8192000000 10978159808 11380854784 1970159056 19.387 100 90 180 0 2050580240 52597200 27823984
14:46:37 4182 8192000000 10972733152 11385745408 1974552432 19.422 100 82 163 1 2052936880 52583840 25800608
14:46:48 1002 8192000000 10977006224 11381346304 1970745872 19.391 100 85 165 0 2049391328 53249136 25396320
14:46:56 3836 8192000000 10971959520 11391102976 1978168640 19.450 100 77 154 0 2057194560 53587792 25438128
14:47:08 5489 8192000000 10955027904 11380240384 1955656848 19.272 99 69 137 0 2029294048 51679536 21957664
14:47:21 4052 8192000000 10952760784 11375104000 1960375440 19.309 100 63 126 0 2032677792 52342784 19959568
14:47:33 6553 8192000000 10934456608 11365851136 1949656544 19.224 99 59 118 0 2013663296 45348992 18657760
14:47:47 2643 8192000000 10958323856 11383660544 1976913632 19.440 100 69 140 0 2045642224 46669264 22059328
14:48:02 14997 8192000000 10953577600 11391578112 1983958256 19.496 100 44 86 1 2040673968 43021520 13694192
14:48:31 5294 8192000000 10944433168 11367411712 1965726608 19.352 100 47 93 1 2021128976 39836912 15565456
14:48:45 6900 8192000000 10947934768 11379568640 1968058400 19.370 100 44 88 1 2025667200 42385360 15223440
14:49:00 8531 8192000000 10945858240 11381170176 1975703856 19.431 100 53 106 0 2038129568 44925888 17499824
14:49:18 4188 8192000000 10954100352 11388674048 1977944528 19.448 100 51 102 3 2041074992 46171184 16959280
14:49:30 8373 8192000000 10955359184 11396100096 1978615680 19.454 100 42 84 1 2043512032 50010928 14885424
14:50:02 13089 8192000000 10960590400 11394502656 1980733328 19.471 100 44 88 1 2045289088 49583312 14972448
14:50:23 11507 8192000000 10964673184 11403878400 1965513856 19.350 99 40 80 0 2033609680 53812880 14282944
14:50:51 16937 8192000000 10944674816 11392069632 1937539280 19.127 98 36 71 3 2005411136 55914928 11956928
14:51:14 20163 8192000000 10945176560 11403612160 1971782640 19.400 100 38 74 3 2041596288 57456848 12356800
14:51:41 13192 8192000000 10944562384 11412144128 1974208192 19.419 100 24 48 1 2034964800 52655840 8100768
14:52:37 23128 8192000000 10943492752 11404038144 1970885344 19.392 100 27 54 1 2030181248 50154368 9141536
14:53:08 34305 8192000000 10952629856 11405185024 1970853360 19.392 100 23 46 1 2028417872 49713792 7850720
14:53:49 18002 8192000000 10942535344 11411832832 1975719200 19.431 100 21 42 1 2027898704 44959488 7220016
14:54:15 42657 8192000000 10899703440 11359813632 1924135376 19.020 98 19 38 2 1972314464 41391760 6787328
14:55:04 47189 8192000000 10891942576 11380076544 1935628624 19.112 100 12 24 0 1992017824 51636416 4752784
14:56:02 51475 8192000000 10873444944 11338522624 1908125760 18.892 98 9 18 0 1925405008 14926416 2352832
14:57:03 35858 8192000000 10888078816 11358035968 1949782560 19.225 100 10 20 0 1973060288 20197872 3079856
14:57:50 46445 8192000000 10910904688 11355279360 1949822592 19.225 99 33 68 1 1972143488 12519120 9801776
14:58:52 40059 8192000000 10888483312 11339272192 1928649920 19.056 98 26 52 2 1941478048 5791488 7036640
14:59:43 27838 8192000000 10875867664 11332374528 1902309952 18.845 97 8 16 0 1913378944 9226176 1842816
15:00:45 76391 8192000000 10901184016 11357757440 1925529168 19.031 98 14 27 2 1943207248 14128752 3549328
15:02:11 86675 8192000000 10915463440 11360907264 1951676368 19.240 99 29 58 2 1967937504 9001792 7259344
15:04:04 66521 8192000000 10924286048 11390558208 1983567616 19.493 100 18 36 1 2007277840 19171424 4538800
15:05:19 71732 8192000000 10927378560 11377934336 1960755312 19.312 99 21 39 1 1977391232 11209152 5426768
15:06:39 21414 8192000000 10930258400 11393355776 1996383104 19.594 100 43 86 0 2016972992 8840576 11749312
15:07:21 83368 8192000000 10900875424 11364495360 1957972848 19.290 98 20 41 0 1972749648 8554736 6222064
15:08:51 1454 8192000000 10926986032 11386470400 1993764096 19.574 100 37 74 1 2012923888 8268800 10890992
15:09:00 7746 8192000000 10920760304 11386056704 1993879200 19.574 100 26 52 1 2009989696 8083168 8027328
15:09:15 17696 8192000000 10922329328 11386560512 1972060032 19.402 99 18 36 1 1991244608 13856848 5327728
15:09:55 51028 8192000000 10912350976 11379552256 1972778144 19.407 100 11 22 1 1990440544 14542960 3119440
15:10:53 12881 8192000000 10934687904 11385180160 1991103920 19.553 100 56 110 1 2016590640 8228160 17258560
15:11:14 29926 8192000000 10934146416 11391959040 1990284768 19.546 100 40 80 0 2014090368 12028608 11776992
15:11:50 21206 8192000000 10923338848 11390574592 1991481072 19.555 100 37 73 3 2015736624 14035232 10220320
15:12:23 60267 8192000000 10920575808 11396521984 1972073632 19.402 99 21 42 2 1992666768 14299888 6293248
15:13:35 32507 8192000000 10910608144 11399327744 1985829056 19.511 100 11 22 0 2006422240 17396448 3196736
15:14:20 10852 8192000000 10910642016 11397910528 1987365152 19.523 100 6 12 1 2001968736 12407072 2196512
15:14:37 21477 8192000000 10892341888 11373449216 1952630208 19.247 98 12 24 0 1964034848 7654800 3749840
15:15:07 61681 8192000000 10908299744 11380072448 1965530320 19.350 99 13 26 1 1977141040 8284720 3326000
15:16:15 42903 8192000000 10905311312 11385114624 1984175328 19.498 100 11 22 1 1999832000 11858720 3797952
15:17:11 95417 8192000000 10910993936 11384791040 1970220240 19.387 99 23 46 0 1983592464 6850640 6521584
15:18:57 37199 8192000000 10917305504 11382042624 1976429872 19.436 99 27 52 2 1991126432 6671440 8025120
15:19:43 7491 8192000000 10920521872 11384848384 1992787200 19.566 100 34 70 0 2009596048 7023376 9785472
15:19:57 19773 8192000000 10924189824 11394101248 1997598752 19.604 100 24 48 1 2012720768 8274496 6847520
15:20:23 56789 8192000000 10899010512 11391635456 1976243152 19.435 99 8 16 1 1986345584 7800960 2301472
15:21:37 29876 8192000000 10911394736 11398934528 1971100032 19.394 99 8 16 0 1981694560 8125952 2468576
15:22:17 79670 8192000000 10933388480 11416031232 1980855712 19.471 99 18 36 2 1996935536 10871216 5208608
15:23:43 34941 8192000000 10931352768 11403223040 1977344336 19.444 99 22 44 2 1999389008 15724448 6320224
15:24:35 33088 8192000000 10906856368 11375288320 1911625408 18.920 96 27 55 0 1937642592 17750336 8266848
15:25:21 26850 8192000000 10904647664 11375140864 1963394304 19.333 100 29 58 0 1990038000 18251696 8392000
15:26:17 26610 8192000000 10927915232 11404546048 1983905824 19.496 100 21 42 2 2017600992 27323392 6371776
15:26:50 61708 8192000000 10867704784 11344195584 1860267808 18.505 94 17 34 0 1890146672 24382752 5496112
15:28:00 61839 8192000000 10872009824 11345539072 1904218720 18.860 98 15 30 0 1930859200 22311520 4328960
15:29:08 48725 8192000000 10852514160 11311902720 1842561616 18.362 95 13 26 0 1860586640 14017312 4007712
15:30:05 35341 8192000000 10873098816 11336855552 1926829440 19.042 99 23 46 1 1945436832 12136688 6470704
15:30:56 99969 8192000000 10866957104 11334615040 1857688064 18.485 95 8 16 0 1876230688 16337952 2204672
15:32:47 60012 8192000000 10902187568 11358375936 1932479136 19.087 99 15 29 1 1951597056 14833856 4284064
15:33:56 31764 8192000000 10868194960 11335290880 1917358080 18.966 99 21 42 1 1942126016 18117136 6650800
15:34:45 43138 8192000000 10874317296 11309809664 1857679552 18.484 96 27 55 2 1877084752 11267040 8138160
15:35:34 34674 8192000000 10881341824 11337302016 1911143296 18.916 99 36 72 0 1931587552 10116176 10328080
15:36:23 109890 8192000000 10869551232 11324096512 1917206224 18.964 99 28 55 2 1936122752 11497024 7419504
15:38:19 47843 8192000000 10853952160 11309473792 1896748304 18.800 98 44 88 3 1918007600 8169936 13089360
15:39:13 50808 8192000000 10855642864 11315724288 1889764016 18.744 98 38 76 0 1916342336 15335392 11242928
15:40:13 27812 8192000000 10863079968 11335270400 1916097328 18.956 99 24 48 2 1939274080 15985392 7191360
15:40:53 2827 8192000000 10851071312 11329130496 1928986192 19.059 100 4 6 0 1942540192 13194624 359376
15:41:03 9904 8192000000 10846243072 11332329472 1912803792 18.929 99 2 4 0 1927611008 13967920 839296
15:41:20 61567 8192000000 10849411120 11317682176 1878340640 18.652 97 10 18 0 1886784912 5738144 2706128
15:42:32 41953 8192000000 10852645232 11319021568 1911305840 18.917 99 20 40 1 1924360976 7336912 5718224
15:43:20 52194 8192000000 10856669968 11324588032 1895663280 18.791 98 19 38 1 1910074656 9232352 5179024
15:44:21 49965 8192000000 10867464048 11341287424 1930866016 19.074 99 17 34 0 1946690800 10851312 4973472
15:45:18 60797 8192000000 10853434208 11326832640 1907632912 18.888 98 18 36 2 1925651888 12340256 5678720
15:46:36 73705 8192000000 10887485744 11341369344 1927872944 19.050 99 48 96 2 1961581696 19810880 13897872
15:47:57 32022 8192000000 10891480896 11367063552 1955968864 19.274 100 42 84 0 1990414864 22121680 12324320
15:48:35 81391 8192000000 10871298128 11350597632 1907473952 18.886 98 10 20 0 1923171984 12923056 2774976
15:50:07 58169 8192000000 10885928704 11365408768 1932879744 19.090 99 18 36 0 1950291008 12225760 5185504
15:51:17 76142 8192000000 10870583008 11348541440 1917652800 18.968 98 12 24 4 1929564608 8736240 3175568
15:52:47 41477 8192000000 10879639008 11340865536 1900372064 18.829 97 35 70 0 1919977136 9737120 9867952
15:53:38 38975 8192000000 10885701792 11352055808 1928961072 19.059 99 35 68 1 1948980032 10759136 9259824
15:54:30 46669 8192000000 10894499904 11364859904 1957807872 19.289 100 40 80 0 1982884432 13292176 11784384
15:55:29 109946 8192000000 10903133600 11392638976 1966430224 19.357 100 24 48 0 1996115952 23246000 6439728
15:57:25 88219 8192000000 10894390496 11371122688 1923700336 19.016 97 10 20 0 1934924416 8763920 2460160
15:59:03 30823 8192000000 10931334576 11389050880 1964518704 19.342 99 24 48 0 1986937920 15536368 6882848
15:59:40 28368 8192000000 10932241520 11388841984 1989923056 19.543 100 44 88 0 2016874128 14000672 12950400
16:00:15 37420 8192000000 10919062464 11400413184 1985327168 19.507 100 14 28 1 2006117056 16663968 4125920
16:01:04 113601 8192000000 10908554912 11383603200 1986156752 19.513 100 19 38 2 2004556464 12933776 5465936
16:03:16 31207 8192000000 10896593024 11371470848 1944680224 19.184 98 32 65 1 1961727248 8419760 8627264
16:03:57 66372 8192000000 10892613968 11374952448 1957716512 19.288 99 15 30 0 1974503776 12118400 4668864
16:06:19 56983 8192000000 10895228272 11373252608 1959848784 19.305 99 20 39 1 1976522048 10897904 5775360
16:07:57 41500 8192000000 10878219920 11357585408 1924884640 19.026 98 13 26 1 1936727232 8059584 3783008
16:08:45 47873 8192000000 10872709744 11359916032 1944506320 19.183 99 6 12 1 1955696640 8898400 2291920
16:09:39 52423 8192000000 10883607088 11353198592 1924917168 19.026 98 20 39 0 1937700672 7439568 5343936
16:10:37 12302 8192000000 10896058832 11350294528 1942776784 19.169 99 50 100 0 1967331776 10172464 14382528
16:10:59 32706 8192000000 10870928592 11348578304 1934631232 19.104 99 17 34 0 1947351296 7879152 4840912
16:11:38 31402 8192000000 10880315728 11353640960 1941352816 19.158 99 25 50 0 1956356320 8151392 6852112
16:12:34 36213 8192000000 10879738832 11352633344 1920551584 18.991 98 19 38 1 1935342624 9473168 5317872
16:13:22 36962 8192000000 10866380096 11339304960 1910489712 18.911 98 22 44 0 1927849184 10979664 6379808
16:14:05 57773 8192000000 10872953728 11323908096 1865742832 18.550 96 15 29 1 1877318576 8125280 3450464
16:15:10 45534 8192000000 10835162336 11305123840 1852682848 18.444 96 19 38 2 1867785792 9371072 5731872
16:16:12 44623 8192000000 10836234512 11299921920 1834466176 18.296 95 28 56 1 1850934272 8686624 7781472
16:17:07 64036 8192000000 10830158224 11310694400 1853328000 18.449 97 17 35 1 1871142752 13205568 4609184
16:18:28 112171 8192000000 10823994912 11297329152 1771132576 17.776 92 12 24 1 1789555248 15006272 3416400
16:20:27 116623 8192000000 10814817072 11277406208 1815651744 18.142 95 12 24 0 1826971600 8073616 3246240
16:22:44 39188 8192000000 10837315744 11282432000 1869220800 18.578 98 36 70 0 1886541584 6839072 10481712
16:23:30 73520 8192000000 10833628112 11311284224 1915381856 18.950 100 19 38 1 1929411520 8555040 5474624
16:24:50 57229 8192000000 10837284704 11319345152 1922677376 19.008 100 4 8 0 1931160272 7422672 1060224
16:25:54 34430 8192000000 10845319712 11329572864 1931846304 19.082 100 13 26 0 1947849248 12584944 3418000
16:26:44 25038 8192000000 10031611392 10428321792 1157435488 12.379 60 2 4 0 1164203696 6355408 412800

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 24-11-2020 16:28:51 to 24-11-2020 16:29:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 24-11-2020 16:29:26 to 24-11-2020 16:29:27.

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          243148
MON$OLDEST_ACTIVE               243149
MON$OLDEST_SNAPSHOT             243149
MON$NEXT_TRANSACTION            243149
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                       2041696
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:182: 
:183: mscs-test-161.budzdorov.ru    Tue Nov 24 16:27:12 2020
:184:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:185: 
:186: 
:187: mscs-test-161.budzdorov.ru    Tue Nov 24 16:27:12 2020
:188:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:189: 
--- end of diff output ---

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

24.11.20 16:29:28. 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-11-24 16:29:31 No severe PSQL-related problems occured
24.11.20 16:29:32. End of report.