Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.06.2021 16:34
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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17348196 kB
MemAvailable 31444068 kB
Buffers 0 kB
Cached 14355424 kB
SwapCached 1764 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-15 16:32:37
DTS_END                         2021-06-15 16:32:37.9080
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/60194
TRN_ID                          245255
ATT_ID                          714
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: 9404.01 18220 1128481
customer order: creation 182.59 332 21911
customer order: refuse 14.89 328 1787
order to supplier: creation 47.94 1271 5753
order to supplier: removal 3.34 103460 401
invoice (draft): creation 49.58 3235 5949
invoice (draft): removal 50.93 803 6111
invoice accept: apply 45.21 15819 5425
invoice accept: cancel 46.56 867 5587
customer reserve: creation 4168.86 156 500263
customer reserve: removal 4487.93 61 538552
realization accept: apply 87.58 174 10510
realization accept: cancel 84.90 108 10188
payment from customer: creation 61.68 109 7401
payment from customer: removal 5.83 72 700
payment to supplier: creation 50.33 121 6039
payment to supplier: removal 3.28 61 394
service: total inventory turnovers 4.51 1124 541
service: total monetary turnovers 7.17 23 860
service: aggregate perf. data 0.88 22470 105
service: refresh index statistics 0.03 213797 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-06-2021 16:35:14 to 15-06-2021 16:35:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7512
TEST_TIME 2 6643
TEST_TIME 3 6219
TEST_TIME 4 5388
TEST_TIME 5 5217
TEST_TIME 6 4914
TEST_TIME 7 5029
TEST_TIME 8 5051
TEST_TIME 9 5241
TEST_TIME 10 5304
TEST_TIME 11 5440
TEST_TIME 12 5378
TEST_TIME 13 5718
TEST_TIME 14 5832
TEST_TIME 15 6110
TEST_TIME 16 6250
TEST_TIME 17 6558
TEST_TIME 18 6788
TEST_TIME 19 6977
TEST_TIME 20 8271
TEST_TIME 21 8259
TEST_TIME 22 8607
TEST_TIME 23 8804
TEST_TIME 24 9458
TEST_TIME 25 9669
TEST_TIME 26 9648
TEST_TIME 27 10401
TEST_TIME 28 11273
TEST_TIME 29 11396
TEST_TIME 30 11228
TEST_TIME 31 10935
TEST_TIME 32 10701
TEST_TIME 33 10646
TEST_TIME 34 10657
TEST_TIME 35 10438
TEST_TIME 36 10416
TEST_TIME 37 10311
TEST_TIME 38 10269
TEST_TIME 39 10253
TEST_TIME 40 10224
TEST_TIME 41 10171
TEST_TIME 42 10086
TEST_TIME 43 10130
TEST_TIME 44 10036
TEST_TIME 45 9885
TEST_TIME 46 9823
TEST_TIME 47 9788
TEST_TIME 48 9744
TEST_TIME 49 9730
TEST_TIME 50 9607
TEST_TIME 51 9624
TEST_TIME 52 9582
TEST_TIME 53 9515
TEST_TIME 54 9604
TEST_TIME 55 9789
TEST_TIME 56 9795
TEST_TIME 57 9896
TEST_TIME 58 9839
TEST_TIME 59 9970
TEST_TIME 60 9943
TEST_TIME 61 10000
TEST_TIME 62 10031
TEST_TIME 63 9961
TEST_TIME 64 10051
TEST_TIME 65 9991
TEST_TIME 66 9881
TEST_TIME 67 9857
TEST_TIME 68 9796
TEST_TIME 69 9717
TEST_TIME 70 9678
TEST_TIME 71 9606
TEST_TIME 72 9564
TEST_TIME 73 9512
TEST_TIME 74 9550
TEST_TIME 75 9555
TEST_TIME 76 9591
TEST_TIME 77 9585
TEST_TIME 78 9637
TEST_TIME 79 9613
TEST_TIME 80 9623
TEST_TIME 81 9665
TEST_TIME 82 9614
TEST_TIME 83 9705
TEST_TIME 84 9693
TEST_TIME 85 9694
TEST_TIME 86 9719
TEST_TIME 87 9617
TEST_TIME 88 9579
TEST_TIME 89 9580
TEST_TIME 90 9583
TEST_TIME 91 9499
TEST_TIME 92 9468
TEST_TIME 93 9508
TEST_TIME 94 9492
TEST_TIME 95 9478
TEST_TIME 96 9452
TEST_TIME 97 9517
TEST_TIME 98 9548
TEST_TIME 99 9541
TEST_TIME 100 9554
TEST_TIME 101 9556
TEST_TIME 102 9566
TEST_TIME 103 9553
TEST_TIME 104 9552
TEST_TIME 105 9659
TEST_TIME 106 9705
TEST_TIME 107 9728
TEST_TIME 108 9779
TEST_TIME 109 9696
TEST_TIME 110 9679
TEST_TIME 111 9649
TEST_TIME 112 9621
TEST_TIME 113 9601
TEST_TIME 114 9557
TEST_TIME 115 9553
TEST_TIME 116 9557
TEST_TIME 117 9515
TEST_TIME 118 9493
TEST_TIME 119 9472
TEST_TIME 120 9413

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-06-2021 16:35:17 to 15-06-2021 16:35:21.

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 1590169 1590169 0 0.00 0 22269 6 0 0
doc_list_biud 1590168 1590168 0 0.00 0 28590 26 0 0
sp_add_invoice_to_stock 5525 5425 100 1.80 45 165534 15820 0 100
sp_cancel_adding_invoice 5587 5587 0 0.00 3 74565 867 0 0
sp_cancel_client_order 1787 1787 0 0.00 4 11455 328 0 0
sp_cancel_customer_reserve 538552 538552 0 0.00 1 24562 62 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 8989 73 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 2 2171 62 0 0
sp_cancel_supplier_invoice 6127 6111 16 0.26 1 11723 803 0 16
sp_cancel_supplier_order 401 401 0 0.00 8 1316914 103460 0 0
sp_cancel_write_off 10188 10188 0 0.00 1 14460 108 0 0
sp_client_order 21911 21911 0 0.00 3 17508 333 0 0
sp_customer_reserve 500263 500263 0 0.00 0 80666 156 0 0
sp_fill_shopping_cart 33608 33608 0 0.00 1 19423 41 0 0
sp_fill_shopping_cart_clo_res 500243 500243 0 0.00 0 20581 14 0 0
sp_get_clo_for_invoice 5404 5404 0 0.00 0 21301 297 0 0
sp_kill_cost_storno 16869 16869 0 0.00 0 14221 56 0 0
sp_kill_qstorno_ret_qs2qd 1093804 1093804 0 0.00 0 24550 33 0 0
sp_kill_qty_storno 578539 578539 0 0.00 0 28588 72 0 0
sp_lock_selected_doc 21896 21896 0 0.00 0 8316 6 0 0
sp_make_cost_storno 29354 29354 0 0.00 0 16009 49 0 0
sp_multiply_rows_for_pdistr 29354 29354 0 0.00 0 14116 28 0 0
sp_multiply_rows_for_qdistr 21911 21911 0 0.00 0 16280 160 0 0
sp_pay_from_customer 7401 7401 0 0.00 4 22398 110 0 0
sp_pay_to_supplier 6039 6039 0 0.00 4 20528 121 0 0
sp_payment_common 13440 13440 0 0.00 1 22030 33 0 0
sp_qd_handle_on_cancel_clo 1787 1787 0 0.00 0 11448 299 0 0
sp_qd_handle_on_invoice_upd_sts 10991 10991 0 0.00 0 28585 303 0 0
sp_qd_handle_on_reserve_upd_sts 10509 10509 0 0.00 0 13062 56 0 0
sp_reserve_write_off 10510 10510 0 0.00 6 22015 174 0 0
sp_supplier_invoice 5949 5949 0 0.00 7 83882 3235 0 0
sp_supplier_order 5753 5753 0 0.00 5 27848 1271 0 0
srv_aggregate_perf_data 105 105 0 0.00 2935 478815 22470 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 995 144029 31820 0 0
srv_find_qd_qs_mism 1077092 1077092 0 0.00 0 14603 5 0 0
srv_make_invnt_saldo 541 541 0 0.00 23 94413 1125 0 0
srv_make_money_saldo 860 860 0 0.00 1 1820 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 59976 404958 213798 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 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 5425 5425 0 0.00 0 11153 151 0 0
t$perf-norm:sp_cancel_adding_invoice 485 485 0 0.00 0 2902 87 0 0
t$perf-norm:sp_cancel_client_order 1787 1787 0 0.00 0 1492 9 0 0
t$perf-norm:sp_cancel_customer_reserve 743 743 0 0.00 0 2292 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 3927 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 2639 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 1476 14 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 21887 1535 0 0
t$perf-norm:sp_cancel_write_off 1050 1050 0 0.00 0 4843 16 0 0
t$perf-norm:sp_client_order 21911 21911 0 0.00 0 8066 15 0 0
t$perf-norm:sp_customer_reserve 1069 1069 0 0.00 0 2235 10 0 0
t$perf-norm:sp_pay_from_customer 7401 7401 0 0.00 0 4009 11 0 0
t$perf-norm:sp_pay_to_supplier 6039 6039 0 0.00 0 6623 11 0 0
t$perf-norm:sp_reserve_write_off 10510 10510 0 0.00 0 8803 11 0 0
t$perf-norm:sp_supplier_invoice 5949 5949 0 0.00 0 12779 21 0 0
t$perf-norm:sp_supplier_order 5753 5753 0 0.00 0 4353 16 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 586 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 374 5 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 5749 35 0 0
t$perf-norm:srv_make_money_saldo 860 860 0 0.00 0 1572 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 11000 10800 200 1.81 0 5684 19 0 200
v_all_customers 39782 39782 0 0.00 0 15 1 0 0
v_all_suppliers 31922 31922 0 0.00 0 25 1 0 0
v_all_wares 43822 43822 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 970 970 0 0.00 0 3546 11 0 0
v_cancel_client_order 3574 3574 0 0.00 0 5619 5 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 1888 7 0 0
v_cancel_customer_reserve 1486 1486 0 0.00 0 2118 5 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 1821 10 0 0
v_cancel_supplier_invoice 884 852 32 3.61 0 4944 23 0 32
v_cancel_supplier_order 802 802 0 0.00 0 192 3 0 0
v_cancel_write_off 2100 2100 0 0.00 0 5482 17 0 0
v_max_id_clo_ord 5753 5753 0 0.00 0 5608 3 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 1575 10 0 0
v_max_id_ord_sup 5944 5944 0 0.00 0 5838 5 0 0
v_max_non_paid_invoice 1775 1775 0 0.00 0 2470 4 0 0
v_max_non_paid_realizn 3871 3871 0 0.00 0 5151 6 0 0
v_min_id_clo_ord 5753 5753 0 0.00 0 14618 13 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 1055 2 0 0
v_min_id_ord_sup 5944 5944 0 0.00 0 11812 13 0 0
v_min_non_paid_invoice 6039 6039 0 0.00 0 8510 17 0 0
v_min_non_paid_realizn 7401 7401 0 0.00 0 14175 23 0 0
v_our_firm 11100 11100 0 0.00 0 21 1 0 0
v_reserve_write_off 21018 21018 0 0.00 0 5374 5 0 0
x_lock_depdocs_on_canc_invoice 11272 11272 0 0.00 0 27074 113 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 7944 367 0 0
x_make_qstorno_1000_1200 5753 5753 0 0.00 2 27833 1191 0 0
x_make_qstorno_1200_2000 5949 5949 0 0.00 3 83858 3085 0 0
x_make_qstorno_2100_3300 500263 500263 0 0.00 0 80665 140 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-06-2021 16:35:22 to 15-06-2021 16:35:26.

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:41 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
14:02:48 22906 8192000000 10266110336 10576306176 918574896 10.082 71 56 113 1 939730848 2579392 18576560
14:03:21 35932 8192000000 10365417808 10684207104 1409754896 14.682 100 87 174 0 1443134336 5204848 28174592
14:04:07 28377 8192000000 10398388128 10720894976 1448462176 15.024 100 84 168 0 1482776656 6992848 27321632
14:04:45 19264 8192000000 10426624544 10752679936 1478876080 15.292 100 92 184 0 1516051936 7757872 29417984
14:05:14 18553 8192000000 10433576896 10766180352 1490097936 15.390 100 87 174 0 1526061488 8075920 27887632
14:05:43 15003 8192000000 10453071360 10785583104 1507918720 15.545 100 87 174 0 1544189056 8519872 27750464
14:06:11 23090 8192000000 10476817648 10811727872 1524554224 15.690 100 88 176 0 1561525680 8637408 28334048
14:06:45 12002 8192000000 10472376496 10816700416 1537266672 15.800 100 81 162 0 1571727888 9110016 25351200
14:07:06 16702 8192000000 10490644624 10838806528 1554445856 15.948 100 78 154 2 1587484560 9058432 23980272
14:07:34 14411 8192000000 10548617376 10897694720 1591035872 16.263 100 72 144 1 1622352912 8986368 22330672
14:08:01 9534 8192000000 10567962352 10926673920 1622160720 16.528 100 77 154 0 1654861280 9489600 23210960
14:08:18 6643 8192000000 10578462528 10938552320 1643936960 16.713 100 76 152 1 1676408064 9719632 22751472
14:08:34 17442 8192000000 10612471248 10977673216 1665191824 16.893 100 67 134 2 1694509392 10002672 19314896
14:09:02 7866 8192000000 10632260496 10998636544 1691317744 17.112 100 82 164 2 1725607376 10837904 23451728
14:09:23 5256 8192000000 10638655840 11006451712 1701221728 17.195 100 79 158 2 1735815696 11727856 22866112
14:09:37 8580 8192000000 10667351072 11037724672 1723028112 17.377 100 78 157 1 1756631680 11938704 21664864
14:09:52 7599 8192000000 10670786688 11044696064 1732337424 17.455 100 82 163 1 1768935936 13918416 22680096
14:10:07 8595 8192000000 10690792416 11066322944 1745803104 17.567 100 83 164 1 1783078592 14204976 23070512
14:10:22 6190 8192000000 10696129856 11075899392 1759881792 17.683 100 88 174 2 1798628576 14480576 24266208
14:10:37 5808 8192000000 10716785088 11090362368 1767212256 17.744 100 86 171 0 1806345504 15522736 23610512
14:10:50 7091 8192000000 10717807120 11095134208 1771680832 17.781 100 80 159 2 1808729792 15383536 21665424
14:11:04 4126 8192000000 10721095056 11100524544 1782705472 17.872 100 81 162 1 1819224112 14438464 22080176
14:11:15 3521 8192000000 10723530768 11103158272 1788003376 17.915 100 92 183 1 1828127136 15060656 25063104
14:11:25 9371 8192000000 10728041472 11113775104 1792918128 17.956 100 82 162 0 1833786912 18911440 21957344
14:11:44 3542 8192000000 10751871712 11132624896 1807997648 18.079 100 88 177 1 1846220704 13679616 24543440
14:11:55 3236 8192000000 10762350816 11145392128 1813444336 18.124 100 84 168 0 1851523344 14184848 23894160
14:12:05 2120 8192000000 10762060352 11147608064 1822610944 18.199 100 81 162 1 1858859504 13528992 22719568
14:12:13 3650 8192000000 10770492352 11159363584 1834406144 18.295 100 89 178 3 1872734880 13632368 24696368
14:12:24 2050 8192000000 10784800512 11167621120 1839576672 18.337 100 89 175 3 1877793984 14095664 24121648
14:12:32 2467 8192000000 10785245888 11170144256 1842994896 18.365 100 91 182 1 1882333648 13970160 25368592
14:12:41 2651 8192000000 10791868144 11177234432 1845906736 18.389 100 89 179 0 1883227024 12090432 25229856
14:12:51 1602 8192000000 10798565440 11182874624 1852367040 18.441 100 90 183 0 1889970992 12986496 24617456
14:12:59 2955 8192000000 10802740112 11186114560 1854258176 18.457 100 90 181 1 1892662528 13266640 25137712
14:13:08 1477 8192000000 10811002576 11197595648 1865052944 18.544 100 94 188 1 1905613056 13431840 27128272
14:13:16 2015 8192000000 10810672928 11199168512 1864100352 18.537 100 88 176 0 1901856640 13182336 24573952
14:13:25 1715 8192000000 10808919600 11199660032 1865920560 18.551 100 94 188 0 1907296192 14425664 26949968
14:13:33 5363 8192000000 10807021168 11201409024 1868118976 18.569 100 90 179 2 1907902000 13505072 26277952
14:13:45 1541 8192000000 10812409088 11203080192 1869498160 18.580 100 90 181 3 1908380400 12848320 26033920
14:13:54 28118 8192000000 10784561968 11193589760 1866427600 18.555 100 44 86 3 1886743840 7878224 12438016
14:14:28 5137 8192000000 10780081136 11199885312 1866800592 18.558 100 46 92 0 1888569120 8637664 13130864
14:14:44 5958 8192000000 10789085952 11206115328 1868818752 18.575 100 36 72 0 1887694336 9013200 9862384
14:14:57 6284 8192000000 10811008272 11214544896 1876497520 18.637 100 43 87 1 1896078064 7942192 11638352
14:15:11 7042 8192000000 10788765872 11210682368 1878130656 18.650 100 32 64 0 1894759408 7989664 8639088
14:15:24 3798 8192000000 10790807072 11218472960 1879724128 18.663 100 37 74 0 1898332080 8120448 10487504
14:15:36 4818 8192000000 10792847680 11211333632 1878333216 18.652 100 29 58 4 1893031280 7031360 7666704
14:15:47 4765 8192000000 10791265232 11216269312 1880110512 18.666 100 29 58 2 1895988560 6953712 8924336
14:15:58 5988 8192000000 10800557104 11221356544 1881637888 18.678 100 29 57 1 1897383744 6845888 8899968
14:16:17 7010 8192000000 10795474528 11224268800 1882206800 18.683 100 24 48 1 1896002144 6953408 6841936
14:16:34 66548 8192000000 10812100656 11233767424 1892097520 18.763 100 37 75 3 1908571152 5435120 11038512
14:17:47 7973 8192000000 10804794896 11235196928 1893480288 18.774 100 27 54 1 1907924864 7284688 7159888
14:18:02 9424 8192000000 10807363488 11235807232 1892473168 18.766 100 32 64 1 1908493264 7029920 8990176
14:18:19 4418 8192000000 10817141584 11241840640 1898464544 18.814 100 38 76 0 1916741328 7696976 10579808
14:18:31 3705 8192000000 10823194272 11246059520 1897479376 18.806 100 41 81 2 1921625392 13039328 11106688
14:18:43 3616 8192000000 10810270256 11241975808 1900221904 18.828 100 37 75 0 1918951328 8118064 10611360
14:18:53 8491 8192000000 10822150304 11251003392 1895895552 18.793 100 16 32 0 1905819712 5926640 3997520
14:19:11 6921 8192000000 10806171184 11242770432 1899943808 18.826 100 28 56 1 1919451648 11213168 8294672
14:19:24 9155 8192000000 10805955104 11244482560 1899532880 18.823 100 19 38 0 1911199120 5942112 5724128
14:19:42 6852 8192000000 10803317984 11244851200 1901596512 18.839 100 22 44 0 1913708512 5300528 6811472
14:19:56 8144 8192000000 10810974496 11245248512 1900335456 18.829 100 25 48 5 1914125152 5593488 8196208
14:20:10 9027 8192000000 10812157168 11248308224 1902019712 18.843 100 24 48 1 1914766544 6494208 6252624
14:20:25 10952 8192000000 10813244864 11251761152 1904885152 18.866 100 27 54 0 1922268832 10429168 6954512
14:20:42 6294 8192000000 10818982064 11251433472 1906511360 18.879 100 21 43 0 1918003808 5760560 5731888
14:20:57 10100 8192000000 10820071504 11259047936 1909931584 18.906 100 14 28 2 1922773712 9441616 3400512
14:21:13 62090 8192000000 10826677776 11262668800 1916032992 18.955 100 33 66 2 1930425888 5358816 9034080
14:22:25 11768 8192000000 10819395456 11260481536 1914121584 18.940 100 14 28 0 1923768800 5167456 4479760
14:22:43 6221 8192000000 10819259984 11245645824 1897035104 18.802 99 31 62 1 1912838896 6795712 9008080
14:22:57 7034 8192000000 10815257264 11244310528 1870714272 18.590 98 40 81 1 1892375488 10911408 10749808
14:23:12 6610 8192000000 10786175696 11209388032 1836392464 18.311 97 39 78 0 1858712784 11155632 11164688
14:23:26 5903 8192000000 10753682544 11185737728 1821539168 18.190 97 23 46 0 1834191408 5879200 6773040
14:23:40 3181 8192000000 10767428272 11192553472 1853568320 18.451 100 42 87 3 1873052368 6809296 12674752
14:23:51 8894 8192000000 10784129648 11216039936 1855005936 18.463 99 18 36 1 1866094688 5651456 5437296
14:24:08 6532 8192000000 10753669488 11183136768 1821585408 18.191 98 24 47 0 1834459104 5868608 7005088
14:24:21 11261 8192000000 10717634192 11129663488 1696210304 17.153 92 30 60 2 1711100320 5339440 9550576
14:24:41 6619 8192000000 10721164800 11137011712 1759735984 17.682 97 18 37 0 1769903376 4699520 5467872
14:24:54 9491 8192000000 10675701936 11092590592 1660509808 16.853 92 27 54 0 1672699072 4715312 7473952
14:25:10 13119 8192000000 10646268096 11060371456 1666522320 16.904 94 9 18 0 1674632640 5761088 2349232
14:25:33 9660 8192000000 10673264064 11097460736 1720647664 17.358 97 12 23 0 1733753744 9940896 3165184
14:25:49 19872 8192000000 10689614048 11105648640 1711456768 17.281 96 18 34 2 1721209312 4983184 4769360
14:26:42 29827 8192000000 10705898384 11129085952 1797876432 17.996 100 31 62 3 1813028240 6891552 8260256
14:27:18 9100 8192000000 10691430096 11107360768 1724572960 17.390 96 28 57 1 1738662576 5800304 8289312
14:27:34 8242 8192000000 10710032624 11122683904 1791062768 17.941 100 33 66 1 1807966944 6429200 10474976
14:27:49 4732 8192000000 10728351808 11142356992 1808903552 18.087 100 41 82 2 1828535712 7873776 11758384
14:28:00 4429 8192000000 10716831120 11137576960 1803223904 18.040 100 32 64 1 1818951920 6519456 9208560
14:28:10 10190 8192000000 10701165024 11115061248 1754974112 17.643 97 32 64 1 1770216304 5497152 9745040
14:28:33 11617 8192000000 10718280320 11139743744 1792233792 17.950 99 26 50 0 1805801600 5743296 7824512
14:28:57 7655 8192000000 10725782768 11148701696 1804194896 18.048 99 24 48 1 1816416352 5146304 7075152
14:29:17 9042 8192000000 10749064752 11171155968 1834463568 18.296 100 26 52 3 1847777520 5785408 7528544
14:29:32 6711 8192000000 10757360176 11180683264 1843846064 18.372 100 37 70 3 1860488576 5548880 11093632
14:29:47 12693 8192000000 10746833264 11182039040 1845246544 18.383 100 11 22 0 1853653984 4944176 3463264
14:30:06 3970 8192000000 10768172080 11191865344 1853127088 18.448 100 35 68 1 1869275936 5667968 10480880
14:30:16 7883 8192000000 10761231088 11190738944 1853769440 18.453 100 21 43 3 1865831440 5938272 6123728
14:30:30 13258 8192000000 10769712640 11202637824 1856672848 18.476 100 22 46 2 1875656896 13664512 5319536
14:30:54 74215 8192000000 10791670000 11220910080 1869434976 18.580 100 27 52 1 1882133872 5011824 7687072
14:32:16 8340 8192000000 10802166944 11229859840 1886900016 18.721 100 22 44 3 1899226880 5427168 6899696
14:32:33 8659 8192000000 10807018288 11237908480 1897574592 18.807 100 31 60 1 1912087424 5783296 8729536
14:32:49 3827 8192000000 10841916352 11254018048 1908998576 18.899 100 59 117 0 1931670240 5815600 16856064
14:33:02 9791 8192000000 10855596368 11270840320 1918913760 18.978 100 57 114 3 1947951392 12386752 16650880
14:33:27 6828 8192000000 10873582704 11283460096 1924444096 19.022 100 67 134 2 1952799184 9539680 18815408
14:33:48 43061 8192000000 10868802256 11284365312 1925408000 19.030 100 68 136 1 1956727408 12321552 18997856
14:34:39 7965 8192000000 10862735760 11284480000 1925459280 19.031 100 58 116 0 1955446400 13695392 16291728
14:34:57 2291 8192000000 10864110944 11290165248 1930321280 19.069 100 52 104 0 1957746480 12267872 15157328
14:35:09 20601 8192000000 10869319664 11295870976 1935803168 19.113 100 61 121 1 1965470720 12162560 17504992
14:35:37 15958 8192000000 10877248576 11306246144 1942578608 19.167 100 59 119 0 1971964592 12812640 16573344
14:36:00 13295 8192000000 10894263360 11310370816 1951150368 19.236 100 56 112 2 1983839904 17413136 15276400
14:36:29 144029 8192000000 10884242496 11332337664 1953477216 19.254 100 35 70 3 1983026320 18958864 10590240
14:39:29 10865 8192000000 10895239936 11337568256 1965770752 19.352 100 32 64 0 1995433280 19896624 9765904
14:39:47 14528 8192000000 10922597664 11352039424 1980066208 19.465 100 68 134 1 2021392816 20973024 20353584
14:40:12 8145 8192000000 10931867744 11363315712 1982408064 19.484 100 56 110 1 2024980080 26499088 16072928
14:40:28 1726 8192000000 10940444880 11364032512 1987234064 19.522 100 57 112 1 2027967232 24282656 16450512
14:40:38 5649 8192000000 10944591280 11372904448 1990011264 19.544 100 62 124 0 2031981680 24073856 17896560
14:40:55 4450 8192000000 10951082912 11376963584 1996395248 19.594 100 71 142 0 2042141504 24681104 21065152
14:41:07 7307 8192000000 10948818624 11373604864 1996404688 19.594 100 69 137 0 2041976112 25769072 19802352
14:41:23 7868 8192000000 10957208608 11386724352 1998522992 19.611 100 60 120 1 2042772176 26454864 17794320
14:41:41 7651 8192000000 10968310272 11395813376 2006799600 19.676 100 72 143 1 2057964816 29574448 21590768
14:41:56 8724 8192000000 10961647152 11392933888 2007448208 19.681 100 56 112 3 2053663120 29655264 16559648
14:42:19 12566 8192000000 10981450272 11408293888 2015892304 19.748 100 59 113 1 2062932928 29564912 17475712
14:43:20 10236 8192000000 10980521008 11417460736 2019482464 19.776 100 54 106 1 2069503120 33702800 16317856
14:43:40 2933 8192000000 10988534320 11414011904 2009884176 19.701 99 79 150 3 2069531504 35431376 24215952
14:43:50 5961 8192000000 10977765488 11404562432 2007748400 19.684 100 68 136 0 2064807488 36922624 20136464
14:44:07 4795 8192000000 10981620640 11412983808 2015169472 19.742 100 63 125 1 2071106496 36967920 18969104
14:44:20 3542 8192000000 10989985520 11420037120 2018657312 19.770 100 67 134 0 2078036640 39635568 19743760
14:44:30 3343 8192000000 11005687968 11426639872 2024834384 19.818 100 77 150 3 2088336400 40665920 22836096
14:44:42 5542 8192000000 11000349680 11423404032 2021452784 19.792 100 79 154 3 2086997440 41941776 23602880
14:44:54 1214 8192000000 11013117952 11428990976 2025814272 19.826 100 83 166 1 2094812656 43823184 25175200
14:45:04 6898 8192000000 11006413648 11430653952 2011386560 19.712 99 82 164 1 2080960240 45369872 24203808
14:45:20 7882 8192000000 11009958848 11437785088 2030658480 19.864 100 83 166 2 2101986992 46892320 24436192
14:45:36 6718 8192000000 11011743120 11440873472 2034334704 19.893 100 74 148 0 2102680656 45947392 22398560
14:45:52 3473 8192000000 11009013456 11437965312 2024120160 19.813 100 72 145 0 2096887904 50887792 21879952
14:46:03 2927 8192000000 10994211744 11415707648 2010106448 19.702 99 84 162 2 2077545264 42946880 24491936
14:46:12 4657 8192000000 10998732448 11424862208 2009541344 19.698 99 76 151 1 2076970816 44016000 23413472
14:46:25 5651 8192000000 10983052512 11403735040 1995541056 19.588 99 81 162 2 2066861888 46124000 25196832
14:46:37 3002 8192000000 10979850416 11399020544 1974432272 19.421 98 78 156 1 2045438976 47292128 23714576
14:46:47 3265 8192000000 10999985536 11417837568 2008621856 19.691 100 81 162 0 2079869136 46215760 25031520
14:46:57 5400 8192000000 10990288128 11411357696 1989445568 19.539 99 73 146 1 2060732640 48608304 22678768
14:47:16 1229 8192000000 11006570480 11421196288 2013126336 19.726 100 85 170 1 2088658656 48553568 26978752
14:47:25 7269 8192000000 10993916448 11425722368 2014529904 19.737 100 70 140 2 2086850880 49844288 22476688
14:47:39 5287 8192000000 10995065584 11432026112 2016609200 19.754 100 51 101 1 2084089280 50472880 17007200
14:47:55 2096 8192000000 11017816784 11439460352 2026638544 19.832 100 84 168 1 2101544112 47924848 26980720
14:48:05 2274 8192000000 11002972000 11415216128 2005613024 19.667 100 88 175 1 2082503216 50196784 26693408
14:48:16 3595 8192000000 11004020928 11426889728 2011380560 19.712 100 85 169 1 2089130352 51531776 26218016
14:48:26 1994 8192000000 10994702432 11406303232 1992442960 19.563 100 93 184 0 2074349440 52755792 29150688
14:48:37 6126 8192000000 10985715984 11410145280 1997136208 19.600 100 73 145 2 2073299696 52997200 23166288
14:48:59 2452 8192000000 10984073360 11414069248 1985037136 19.505 99 58 116 1 2060140032 55858432 19244464
14:49:13 7965 8192000000 10966290000 11385843712 1957435552 19.286 98 71 140 0 2033312576 53223824 22653200
14:49:30 992 8192000000 11003649536 11413401600 2000071936 19.623 100 90 182 1 2084398816 55591856 28735024
14:49:41 3777 8192000000 10986053296 11407527936 1994045968 19.576 100 74 148 2 2075693232 57458864 24188400
14:49:52 3230 8192000000 10980346304 11397857280 1977051568 19.441 99 77 154 0 2059118464 56899744 25167152
14:50:02 3384 8192000000 10991971952 11408633856 1988648992 19.533 100 81 162 2 2072869312 58701040 25519280
14:50:12 4854 8192000000 10981482672 11391340544 1975155184 19.426 100 81 158 0 2057472608 56810624 25506800
14:50:26 1910 8192000000 10976035344 11387867136 1974575568 19.422 100 81 159 0 2060063824 60391744 25096512
14:50:37 1220 8192000000 10990675424 11404627968 1985451168 19.508 100 84 167 1 2070060976 57466128 27143680
14:50:47 1480 8192000000 11001578112 11411607552 1993614896 19.572 100 89 178 0 2081893344 59858608 28419840
14:50:57 2734 8192000000 11009473104 11428356096 2000231024 19.625 100 81 161 0 2088885552 63060784 25593744
14:51:09 2823 8192000000 11008231344 11424501760 1996862432 19.598 100 89 178 0 2090556416 64424848 29269136
14:51:19 5912 8192000000 11012816032 11433979904 1997779392 19.605 100 75 150 1 2088921840 66544768 24597680
14:51:33 4462 8192000000 11018776768 11438432256 2009256240 19.696 100 88 173 2 2105583264 68332784 27994240
14:51:45 2679 8192000000 11033410000 11450634240 2014049808 19.733 100 91 180 0 2111856144 69429776 28376560
14:51:55 2899 8192000000 11031842320 11450511360 2015433664 19.744 100 88 176 0 2116163424 72753584 27976176
14:52:06 10292 8192000000 10985206720 11434352640 1994976736 19.583 100 55 110 0 2081566128 68022144 18567248
14:52:25 18571 8192000000 10953595456 11408859136 1937825392 19.129 97 34 68 0 2008642256 59235408 11581456
14:52:50 6418 8192000000 10959661632 11410096128 1976641488 19.438 100 38 76 2 2042197328 52397696 13158144
14:53:03 4281 8192000000 10962054752 11405627392 1967848128 19.368 99 43 86 0 2032524624 49651760 15024736
14:53:16 6260 8192000000 10955851040 11397058560 1966327808 19.356 99 41 81 2 2028897376 48859216 13710352
14:53:29 17333 8192000000 10955949616 11401613312 1975364784 19.428 100 39 77 3 2039249552 50544240 13340528
14:53:53 6630 8192000000 10966517280 11404890112 1964192944 19.339 99 48 93 3 2031703952 52418208 15092800
14:54:06 20744 8192000000 10968699440 11419975680 1984660432 19.502 100 34 68 3 2055480048 58848592 11971024
14:54:37 17546 8192000000 10944074384 11396407296 1961164032 19.315 99 29 58 0 2026001296 54283760 10553504
14:55:26 22424 8192000000 10972673136 11426656256 1958742688 19.296 99 33 66 0 2035170704 64479184 11948832
14:56:00 30077 8192000000 10958692432 11421425664 1984831456 19.503 100 29 58 1 2053426160 59399728 9194976
14:56:46 29922 8192000000 10956722400 11413147648 1965582848 19.350 99 26 52 3 2019397296 45234720 8579728
14:57:29 26745 8192000000 10936763888 11415248896 1964923248 19.345 100 18 36 0 2020818704 49124752 6770704
14:58:03 11963 8192000000 10948456896 11418615808 1971178032 19.395 100 22 44 0 2031245872 52170176 7897664
14:58:22 20156 8192000000 10943869776 11401007104 1945400816 19.190 99 21 42 1 2011754144 58294080 8059248
14:59:26 47723 8192000000 10897285424 11395706880 1928207648 19.053 98 12 24 2 1969212784 36233744 4771392
15:00:46 66395 8192000000 10876115520 11353202688 1913151824 18.932 98 13 26 0 1936218784 19656080 3410880
15:01:58 125845 8192000000 10873114080 11325173760 1868194464 18.570 95 24 49 1 1885982304 11557296 6230544
15:04:28 65714 8192000000 10868301040 11335626752 1899235728 18.820 97 26 52 2 1913014736 6032224 7746784
15:05:40 104915 8192000000 10846702112 11300655104 1821828000 18.193 93 20 40 2 1835941840 8446480 5667360
15:07:51 7115 8192000000 10863558560 11316027392 1925441328 19.030 100 29 58 0 1943917088 9951680 8524080
15:08:19 1063 8192000000 10872926464 11325906944 1940525664 19.151 100 30 60 0 1955429920 6781952 8122304
15:08:28 6008 8192000000 10878696416 11318648832 1934660704 19.104 100 57 113 0 1959352624 9062720 15629200
15:08:41 23265 8192000000 10887363696 11336404992 1942640944 19.168 100 31 61 1 1961175056 9551216 8982896
15:09:46 33433 8192000000 10873140032 11337367552 1931461216 19.079 99 37 74 2 1951594144 9604416 10528512
15:10:27 31851 8192000000 10883452240 11322339328 1938927136 19.138 99 29 56 5 1955362576 7747152 8688288
15:11:05 17591 8192000000 10884717248 11339173888 1936908976 19.122 99 37 75 1 1958342688 10871056 10562656
15:11:39 54878 8192000000 10884270544 11359563776 1966348880 19.356 100 26 52 1 1982862768 8916800 7597088
15:12:41 42992 8192000000 10892508528 11356508160 1962136432 19.323 100 22 44 1 1977074560 8898864 6039264
15:14:34 24249 8192000000 10875416000 11340021760 1942780000 19.169 99 18 36 0 1957667056 9704000 5183056
15:15:13 92613 8192000000 10889517616 11355394048 1963228816 19.332 100 13 26 0 1973945280 5712000 5004464
15:16:54 92442 8192000000 10890507472 11361693696 1950460928 19.230 99 17 34 0 1961979904 6510768 5008208
15:18:38 64650 8192000000 10895499216 11375226880 1960799312 19.312 99 18 36 1 1974662224 8634048 5228864
15:19:54 33501 8192000000 10909253392 11382419456 1985859424 19.511 100 28 56 1 2005357776 11293296 8205056
15:21:26 42828 8192000000 10891789232 11372609536 1975157664 19.426 100 12 24 0 1987231744 8610000 3464080
15:22:25 59711 8192000000 10898644864 11383930880 1984434192 19.500 100 5 10 0 1994715568 8899200 1382176
15:23:38 65025 8192000000 10911786432 11386388480 1949835104 19.225 98 16 32 1 1965947664 11478096 4634464
15:24:50 91594 8192000000 10910636608 11387764736 1905246608 18.868 96 17 34 0 1926156768 16279456 4630704
15:26:33 90355 8192000000 10891727104 11379642368 1913111328 18.932 97 16 32 1 1938656720 20391824 5153568
15:28:09 88369 8192000000 10907617104 11389476864 1933880960 19.098 98 10 20 1 1957774816 20552016 3341840
15:29:44 54198 8192000000 10931549440 11385065472 1960069376 19.307 99 19 38 1 1977378608 12275984 5033248
15:30:48 68690 8192000000 10891245136 11370377216 1900408736 18.830 96 19 38 0 1917345584 11915424 5021424
15:32:03 77517 8192000000 10880847312 11344764928 1809432848 18.091 92 18 36 0 1823028032 9118304 4476880
15:33:32 82968 8192000000 10870343456 11341262848 1817598416 18.158 93 15 30 0 1831485760 9859696 4027648
15:35:03 33641 8192000000 10893185424 11350507520 1931119856 19.076 99 28 56 1 1954533856 15578400 7835600
15:35:51 76350 8192000000 10881079440 11360788480 1914748464 18.945 98 11 22 1 1934158464 16240704 3169296
15:37:17 101980 8192000000 10867496160 11344498688 1913081968 18.931 98 23 46 0 1930015280 10399952 6533360
15:39:06 27229 8192000000 10846066000 11331260416 1897284272 18.804 98 4 8 0 1909345856 11040864 1020720
15:39:39 18378 8192000000 10837921728 11329302528 1908197344 18.892 99 4 8 0 1920463104 11330368 935392
15:40:04 32012 8192000000 10829447936 11303702528 1868798480 18.575 97 9 18 0 1880979952 9844288 2337184
15:41:48 74301 8192000000 10850706576 11329736704 1882690992 18.687 97 7 14 1 1891826784 7231648 1904144
15:43:11 56448 8192000000 10843049616 11313487872 1904400208 18.862 98 19 37 0 1915087024 5766672 4920144
15:44:24 58578 8192000000 10864686000 11340034048 1910022752 18.907 98 8 16 0 1921375296 9431888 1920656
15:45:45 43681 8192000000 10852358800 11332014080 1912593216 18.927 99 15 30 0 1931113616 14399024 4121376
15:46:36 30838 8192000000 10850642432 11325874176 1910404592 18.910 99 18 35 2 1924760784 9313392 5042800
15:47:16 26643 8192000000 10858595824 11326242816 1918814880 18.977 99 19 38 1 1930332560 5985248 5532432
15:47:51 41510 8192000000 10855751312 11332509696 1921490336 18.999 99 24 48 3 1938285200 9866496 6928368
15:48:51 39853 8192000000 10864718816 11339837440 1928516272 19.055 99 30 60 1 1948963872 12665008 7782592
15:49:37 85241 8192000000 10861880672 11343699968 1902521776 18.847 98 14 28 0 1916197184 9861808 3813600
15:51:16 30313 8192000000 10888426784 11349086208 1932887184 19.090 99 36 72 2 1952871472 7298080 12686208
15:51:56 33688 8192000000 10888664656 11345346560 1915949936 18.954 98 33 66 1 1937743872 12831952 8961984
15:52:36 63674 8192000000 10844690288 11316117504 1830932400 18.267 94 18 36 0 1849189744 13228000 5029344
15:53:46 12100 8192000000 10863445344 11324571648 1917315200 18.965 99 26 52 0 1933774528 9409056 7050272
15:54:07 37499 8192000000 10872832752 11328786432 1887655984 18.727 97 38 76 1 1908702928 10267632 10779312
15:54:57 78631 8192000000 10873110704 11340697600 1918837872 18.978 99 19 38 1 1935297472 11071248 5388352
15:56:22 28835 8192000000 10876147680 11335716864 1888452624 18.733 97 17 34 2 1900700912 7705712 4542576
15:57:02 31011 8192000000 10869014992 11326447616 1883036064 18.690 97 24 48 0 1897939392 8543536 6359792
15:57:41 40442 8192000000 10869416432 11331416064 1901918608 18.842 98 27 54 1 1920748384 11250608 7579168
15:59:30 104487 8192000000 10866486240 11326357504 1920858272 18.994 99 18 36 0 1932639952 6539392 5242288
16:01:21 64106 8192000000 10887907456 11361509376 1958533136 19.294 100 27 52 1 1975730192 10388176 6808880
16:02:34 40581 8192000000 10877694288 11362496512 1946362864 19.197 99 9 17 1 1957443840 8570512 2510464
16:03:25 18439 8192000000 10866174880 11354165248 1951153344 19.236 100 6 12 0 1960719952 8143472 1423136
16:03:57 68063 8192000000 10882656048 11357569024 1939282976 19.141 99 17 32 2 1951050768 7798864 3968928
16:05:11 81880 8192000000 10871262944 11349245952 1904112608 18.859 97 8 16 0 1913538064 7626848 1798608
16:06:40 37379 8192000000 10889867776 11358105600 1943456880 19.174 99 20 40 0 1957409632 7630272 6322480
16:07:25 32386 8192000000 10908791168 11373948928 1970080096 19.386 100 31 63 0 1986404080 7707584 8616400
16:08:04 47272 8192000000 10907369344 11361906688 1923131472 19.012 97 29 58 1 1941305456 9515040 8658944
16:09:49 64315 8192000000 10876701728 11359088640 1928000720 19.051 98 16 32 2 1943824704 11053104 4770880
16:10:59 67759 8192000000 10880540416 11362336768 1920793632 18.993 98 11 22 1 1934119520 10080512 3245376
16:12:17 42589 8192000000 10891654256 11355582464 1908285904 18.893 97 24 47 3 1923142432 8389504 6467024
16:13:06 14884 8192000000 10901309440 11347251200 1919910752 18.986 98 53 104 0 1943288032 8350736 15026544
16:13:32 90565 8192000000 10874446192 11344183296 1887514080 18.726 97 23 46 0 1906830592 12960000 6356512
16:15:16 43308 8192000000 10882350096 11347779584 1889203424 18.739 96 25 50 0 1907784560 11428080 7153056
16:16:32 70151 8192000000 10884701824 11362144256 1883109120 18.690 96 21 42 1 1904051232 14947040 5995072
16:18:05 71384 8192000000 10870874416 11336990720 1868056288 18.569 96 11 21 2 1890000992 18509552 3435152
16:19:22 101640 8192000000 10845716896 11336908800 1880509984 18.669 97 12 24 1 1903488672 19697232 3281456
16:21:15 75892 8192000000 10867015648 11338981376 1916515456 18.959 99 18 35 1 1938695392 17294096 4885840
16:23:01 53798 8192000000 10846821104 11327229952 1899349920 18.821 98 14 28 0 1916206080 13548704 3307456
16:24:02 4095 8192000000 10872501744 11348779008 1939756688 19.145 100 20 40 2 1956834864 11938480 5139696
16:24:13 32387 8192000000 10848126336 11320897536 1901429920 18.838 98 15 30 0 1916802320 11286512 4085888
16:24:57 59834 8192000000 10852370720 11338678272 1932651536 19.088 100 13 26 0 1946226112 9972880 3601696
16:26:03 12853 8192000000 10853886256 11340795904 1933190768 19.092 100 5 10 0 1945680144 10981216 1508160
16:26:22 9444 8192000000 10857734400 11348221952 1934935648 19.106 100 11 21 0 1950586912 12728288 2922976
16:26:37 23854 8192000000 10836120256 11322875904 1915405440 18.950 99 6 12 1 1926653360 9482640 1765280
16:27:27 57427 8192000000 10847414080 11327471616 1900111808 18.827 98 14 28 0 1913099520 8739104 4248608
16:28:32 63681 8192000000 10842650112 11325304832 1899882624 18.825 98 16 32 2 1912940976 8918160 4140192
16:29:44 60125 8192000000 10840073856 11309178880 1860521552 18.508 96 31 63 1 1875305040 6360144 8423344
16:30:51 63882 8192000000 10825915712 11292581888 1827347872 18.238 95 28 56 4 1843872832 7955680 8569280
16:32:01 62500 8192000000 9770328704 10127732736 913063472 10.028 48 6 12 0 918747984 4215872 1468640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 15-06-2021 16:35:28 to 15-06-2021 16:35:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 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:01, from 15-06-2021 16:36:00 to 15-06-2021 16:36:01.

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          244759
MON$OLDEST_ACTIVE               245750
MON$OLDEST_SNAPSHOT             245750
MON$NEXT_TRANSACTION            245750
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                       2021440
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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'

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