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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17214860 kB
MemAvailable 31414300 kB
Buffers 0 kB
Cached 14439868 kB
SwapCached 3456 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-13 19:27:00
DTS_END                         2020-11-13 19:27:00.8740
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/35626
TRN_ID                          247789
ATT_ID                          729
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: 9620.07 18323 1154408
customer order: creation 180.68 323 21681
customer order: refuse 15.23 336 1827
order to supplier: creation 47.74 1202 5729
order to supplier: removal 3.34 92288 401
invoice (draft): creation 48.18 3097 5781
invoice (draft): removal 53.11 701 6373
invoice accept: apply 45.33 17411 5440
invoice accept: cancel 48.32 744 5798
customer reserve: creation 4112.84 175 493541
customer reserve: removal 4746.33 50 569559
realization accept: apply 86.11 172 10333
realization accept: cancel 94.57 100 11348
payment from customer: creation 62.45 120 7494
payment from customer: removal 6.21 87 745
payment to supplier: creation 52.37 129 6284
payment to supplier: removal 3.90 75 468
service: total inventory turnovers 5.32 1036 638
service: total monetary turnovers 7.12 36 854
service: aggregate perf. data 0.92 21445 110
service: refresh index statistics 0.03 226925 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-11-2020 19:27:54 to 13-11-2020 19:27:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3447
TEST_TIME 2 4472
TEST_TIME 3 4244
TEST_TIME 4 4809
TEST_TIME 5 4799
TEST_TIME 6 4839
TEST_TIME 7 4649
TEST_TIME 8 5362
TEST_TIME 9 5572
TEST_TIME 10 6021
TEST_TIME 11 6002
TEST_TIME 12 6151
TEST_TIME 13 6774
TEST_TIME 14 7124
TEST_TIME 15 7500
TEST_TIME 16 7793
TEST_TIME 17 8068
TEST_TIME 18 8577
TEST_TIME 19 8713
TEST_TIME 20 8902
TEST_TIME 21 9521
TEST_TIME 22 9755
TEST_TIME 23 9806
TEST_TIME 24 10373
TEST_TIME 25 10367
TEST_TIME 26 10906
TEST_TIME 27 10657
TEST_TIME 28 10732
TEST_TIME 29 10724
TEST_TIME 30 10808
TEST_TIME 31 10592
TEST_TIME 32 10796
TEST_TIME 33 10706
TEST_TIME 34 10727
TEST_TIME 35 10696
TEST_TIME 36 10764
TEST_TIME 37 10511
TEST_TIME 38 10413
TEST_TIME 39 10435
TEST_TIME 40 10352
TEST_TIME 41 10178
TEST_TIME 42 10149
TEST_TIME 43 10084
TEST_TIME 44 10020
TEST_TIME 45 10074
TEST_TIME 46 10116
TEST_TIME 47 9979
TEST_TIME 48 9944
TEST_TIME 49 9851
TEST_TIME 50 9721
TEST_TIME 51 9885
TEST_TIME 52 9890
TEST_TIME 53 9831
TEST_TIME 54 9798
TEST_TIME 55 9664
TEST_TIME 56 9647
TEST_TIME 57 9607
TEST_TIME 58 9535
TEST_TIME 59 9596
TEST_TIME 60 9622
TEST_TIME 61 9601
TEST_TIME 62 9604
TEST_TIME 63 9602
TEST_TIME 64 9753
TEST_TIME 65 9838
TEST_TIME 66 9866
TEST_TIME 67 9839
TEST_TIME 68 9863
TEST_TIME 69 9875
TEST_TIME 70 9976
TEST_TIME 71 9969
TEST_TIME 72 9906
TEST_TIME 73 9795
TEST_TIME 74 9850
TEST_TIME 75 9755
TEST_TIME 76 9723
TEST_TIME 77 9755
TEST_TIME 78 9743
TEST_TIME 79 9726
TEST_TIME 80 9669
TEST_TIME 81 9660
TEST_TIME 82 9628
TEST_TIME 83 9601
TEST_TIME 84 9728
TEST_TIME 85 9712
TEST_TIME 86 9695
TEST_TIME 87 9730
TEST_TIME 88 9696
TEST_TIME 89 9744
TEST_TIME 90 9733
TEST_TIME 91 9747
TEST_TIME 92 9760
TEST_TIME 93 9848
TEST_TIME 94 9917
TEST_TIME 95 9913
TEST_TIME 96 9827
TEST_TIME 97 9799
TEST_TIME 98 9733
TEST_TIME 99 9760
TEST_TIME 100 9740
TEST_TIME 101 9712
TEST_TIME 102 9678
TEST_TIME 103 9644
TEST_TIME 104 9590
TEST_TIME 105 9512
TEST_TIME 106 9553
TEST_TIME 107 9584
TEST_TIME 108 9549
TEST_TIME 109 9544
TEST_TIME 110 9581
TEST_TIME 111 9557
TEST_TIME 112 9573
TEST_TIME 113 9575
TEST_TIME 114 9611
TEST_TIME 115 9612
TEST_TIME 116 9633
TEST_TIME 117 9620
TEST_TIME 118 9609
TEST_TIME 119 9710
TEST_TIME 120 9629

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-11-2020 19:27:57 to 13-11-2020 19:28:01.

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 1611265 1611265 0 0.00 0 40093 6 0 0
doc_list_biud 1611263 1611263 0 0.00 0 39627 23 0 0
sp_add_invoice_to_stock 5565 5440 125 2.24 27 185912 17411 0 125
sp_cancel_adding_invoice 5798 5798 0 0.00 5 45866 744 0 0
sp_cancel_client_order 1827 1827 0 0.00 3 10875 336 0 0
sp_cancel_customer_reserve 569559 569559 0 0.00 1 39628 51 0 0
sp_cancel_pay_from_customer 745 745 0 0.00 3 6223 87 0 0
sp_cancel_pay_to_supplier 468 468 0 0.00 2 5425 76 0 0
sp_cancel_supplier_invoice 6382 6373 9 0.14 2 19592 701 0 9
sp_cancel_supplier_order 401 401 0 0.00 6 1180264 92289 0 0
sp_cancel_write_off 11348 11348 0 0.00 1 13681 100 0 0
sp_client_order 21681 21681 0 0.00 3 37338 324 0 0
sp_customer_reserve 493541 493541 0 0.00 0 45158 175 0 0
sp_fill_shopping_cart 33186 33186 0 0.00 1 12708 39 0 0
sp_fill_shopping_cart_clo_res 493526 493526 0 0.00 0 16082 13 0 0
sp_get_clo_for_invoice 5422 5422 0 0.00 0 20236 284 0 0
sp_kill_cost_storno 18359 18359 0 0.00 0 10549 52 0 0
sp_kill_qstorno_ret_qs2qd 1157240 1157240 0 0.00 0 39625 28 0 0
sp_kill_qty_storno 611060 611060 0 0.00 0 39627 61 0 0
sp_lock_selected_doc 21888 21888 0 0.00 0 6352 4 0 0
sp_make_cost_storno 29533 29533 0 0.00 0 39410 55 0 0
sp_multiply_rows_for_pdistr 29532 29532 0 0.00 0 18468 32 0 0
sp_multiply_rows_for_qdistr 21681 21681 0 0.00 0 37329 143 0 0
sp_pay_from_customer 7494 7494 0 0.00 4 16014 120 0 0
sp_pay_to_supplier 6284 6284 0 0.00 5 18483 129 0 0
sp_payment_common 13778 13778 0 0.00 1 15797 39 0 0
sp_qd_handle_on_cancel_clo 1827 1827 0 0.00 0 10866 316 0 0
sp_qd_handle_on_invoice_upd_sts 11220 11220 0 0.00 0 18132 312 0 0
sp_qd_handle_on_reserve_upd_sts 10332 10332 0 0.00 0 16180 59 0 0
sp_reserve_write_off 10333 10333 0 0.00 7 16231 173 0 0
sp_supplier_invoice 5781 5781 0 0.00 6 75604 3097 0 0
sp_supplier_order 5729 5729 0 0.00 6 38895 1203 0 0
srv_aggregate_perf_data 110 110 0 0.00 2684 314687 21446 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1390 128726 31535 0 0
srv_find_qd_qs_mism 1103672 1103672 0 0.00 0 11511 6 0 0
srv_make_invnt_saldo 638 638 0 0.00 37 56664 1037 0 0
srv_make_money_saldo 854 854 0 0.00 1 6008 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 82046 431420 226925 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 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 5441 5441 0 0.00 0 16785 150 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 1 3370 83 0 0
t$perf-norm:sp_cancel_client_order 1827 1827 0 0.00 0 1951 11 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 4440 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 745 745 0 0.00 0 574 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 468 468 0 0.00 0 5845 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 2530 23 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 22660 1578 0 0
t$perf-norm:sp_cancel_write_off 1109 1109 0 0.00 0 2476 8 0 0
t$perf-norm:sp_client_order 21681 21681 0 0.00 0 14298 19 0 0
t$perf-norm:sp_customer_reserve 1062 1062 0 0.00 0 5873 8 0 0
t$perf-norm:sp_pay_from_customer 7494 7494 0 0.00 0 4838 6 0 0
t$perf-norm:sp_pay_to_supplier 6284 6284 0 0.00 0 7198 14 0 0
t$perf-norm:sp_reserve_write_off 10333 10333 0 0.00 0 8850 10 0 0
t$perf-norm:sp_supplier_invoice 5781 5781 0 0.00 0 14905 22 0 0
t$perf-norm:sp_supplier_order 5729 5729 0 0.00 0 5584 13 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 255 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 193 3 0 0
t$perf-norm:srv_make_invnt_saldo 638 638 0 0.00 0 2088 22 0 0
t$perf-norm:srv_make_money_saldo 854 854 0 0.00 0 3236 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 11092 10842 250 2.25 0 7128 18 0 250
v_all_customers 39552 39552 0 0.00 0 17 1 0 0
v_all_suppliers 31992 31992 0 0.00 0 89 1 0 0
v_all_wares 43360 43360 0 0.00 0 47 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 424 6 0 0
v_cancel_client_order 3654 3654 0 0.00 0 3608 5 0 0
v_cancel_customer_prepayment 1490 1490 0 0.00 0 6215 10 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 1613 7 0 0
v_cancel_payment_to_supplier 936 936 0 0.00 0 329 3 0 0
v_cancel_supplier_invoice 858 840 18 2.09 0 448 14 0 18
v_cancel_supplier_order 802 802 0 0.00 0 1437 7 0 0
v_cancel_write_off 2218 2218 0 0.00 0 2547 14 0 0
v_max_id_clo_ord 5729 5729 0 0.00 0 919 1 0 0
v_max_id_clo_res 1062 1062 0 0.00 0 1361 9 0 0
v_max_id_ord_sup 5776 5776 0 0.00 0 1722 2 0 0
v_max_non_paid_invoice 1793 1793 0 0.00 0 4786 5 0 0
v_max_non_paid_realizn 3997 3997 0 0.00 0 2172 3 0 0
v_min_id_clo_ord 5729 5729 0 0.00 0 3077 6 0 0
v_min_id_clo_res 1062 1062 0 0.00 0 4815 10 0 0
v_min_id_ord_sup 5776 5776 0 0.00 0 8220 8 0 0
v_min_non_paid_invoice 6284 6284 0 0.00 0 12583 26 0 0
v_min_non_paid_realizn 7494 7494 0 0.00 0 14443 29 0 0
v_our_firm 10802 10802 0 0.00 0 19 1 0 0
v_reserve_write_off 20664 20664 0 0.00 0 3627 5 0 0
x_lock_depdocs_on_canc_invoice 11751 11751 0 0.00 0 17457 117 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 6722 341 0 0
x_make_qstorno_1000_1200 5729 5729 0 0.00 1 38875 1122 0 0
x_make_qstorno_1200_2000 5781 5781 0 0.00 3 75596 2952 0 0
x_make_qstorno_2100_3300 493541 493541 0 0.00 0 40187 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2020 19:28:02 to 13-11-2020 19:28:06.

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
16:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:10 10180 8192000000 10203274528 10506424320 790949536 8.805 64 47 96 1 809990944 2227856 16813552
16:57:28 23544 8192000000 10316866256 10628759552 1350932976 14.156 100 85 170 0 1383293728 4186320 28174432
16:57:59 30801 8192000000 10361845552 10680086528 1405406640 14.643 100 93 186 0 1442301696 5945664 30949392
16:58:37 12076 8192000000 10380605584 10703544320 1432870336 14.887 100 93 186 1 1470833248 6995488 30967424
16:59:01 6167 8192000000 10398048768 10721550336 1449877840 15.037 100 91 182 0 1491725328 11935040 29912448
16:59:20 19549 8192000000 10420977296 10748243968 1467252208 15.190 100 90 180 2 1505605984 8318912 30034864
16:59:52 23351 8192000000 10434888928 10766598144 1482960480 15.327 100 90 180 0 1521377088 9318576 29098032
17:00:29 14284 8192000000 10438905120 10774478848 1494387216 15.427 100 90 180 0 1533809776 9669072 29753488
17:00:59 13214 8192000000 10476912400 10812899328 1519489232 15.646 100 85 170 2 1557400256 10178560 27732464
17:01:21 17365 8192000000 10487567696 10834546688 1543002176 15.850 100 78 156 0 1578017936 10434528 24581232
17:01:47 18744 8192000000 10521730000 10870489088 1567699424 16.062 100 82 164 1 1607788224 15076752 25012048
17:02:19 15928 8192000000 10548176176 10902757376 1598377872 16.326 100 75 150 0 1632550272 11770048 22402352
17:02:44 14328 8192000000 10567133760 10926665728 1621876000 16.526 100 81 162 2 1658840160 12368176 24595984
17:03:10 10029 8192000000 10588103328 10948067328 1646970896 16.739 100 85 168 5 1685242272 13647632 24623744
17:03:28 9132 8192000000 10601272336 10965843968 1655823520 16.814 100 78 156 1 1691897408 13327600 22746288
17:03:45 9804 8192000000 10631671216 10997493760 1677844480 16.999 100 81 161 1 1714639632 13154528 23640624
17:04:01 7559 8192000000 10639694400 11007836160 1699872624 17.184 100 82 164 1 1737420592 13922400 23625568
17:04:15 8875 8192000000 10653495488 11024060416 1714647664 17.308 100 85 170 0 1753336736 14371952 24317120
17:04:33 6884 8192000000 10668617088 11041263616 1725752192 17.400 100 79 159 1 1761954960 13924064 22278704
17:04:47 5109 8192000000 10679874240 11054202880 1735765584 17.483 100 83 165 3 1772015488 13377008 22872896
17:05:00 4655 8192000000 10691385984 11066527744 1744568976 17.557 100 83 165 2 1781343904 13536512 23238416
17:05:11 4941 8192000000 10691090016 11070103552 1756517632 17.656 100 78 155 3 1791248496 13069888 21660976
17:05:23 4433 8192000000 10707466960 11083632640 1771150512 17.777 100 82 161 2 1806920016 12803936 22965568
17:05:34 4526 8192000000 10720110768 11100700672 1781726000 17.864 100 85 168 0 1816460192 11937600 22796592
17:05:46 4615 8192000000 10731723600 11110502400 1789355536 17.926 100 85 168 1 1825901392 13497440 23048416
17:05:57 2948 8192000000 10735901872 11117793280 1796372752 17.984 100 92 184 1 1835935984 14310064 25253168
17:06:07 5214 8192000000 10729769776 11113713664 1799045664 18.006 100 88 177 1 1837550336 14909472 23595200
17:06:19 3064 8192000000 10744245088 11125428224 1801333136 18.025 100 85 170 2 1839154640 14050400 23771104
17:06:28 2544 8192000000 10744153664 11124744192 1804446016 18.050 100 87 175 2 1844015520 15040688 24528816
17:06:38 4780 8192000000 10751851216 11132604416 1805326080 18.058 100 83 164 5 1842756064 14326800 23103184
17:06:50 4263 8192000000 10750242560 11135098880 1809853440 18.095 100 81 162 1 1845145472 13333584 21958448
17:07:01 2318 8192000000 10763201248 11147821056 1823355120 18.205 100 91 180 2 1863222224 14314416 25552688
17:07:09 2352 8192000000 10776887808 11160174592 1830847664 18.266 100 87 173 0 1868752240 12699744 25204832
17:07:19 2608 8192000000 10784808256 11170344960 1841414864 18.352 100 87 168 1 1877235504 12699680 23120960
17:07:28 1716 8192000000 10791569552 11174035456 1850746160 18.428 100 91 182 1 1889623584 13387520 25489904
17:07:36 1852 8192000000 10799283792 11186044928 1854161968 18.456 100 95 188 0 1894149936 13899904 26088064
17:07:44 2017 8192000000 10804018976 11189358592 1855902704 18.470 100 93 185 0 1896276112 14277344 26096064
17:07:52 2098 8192000000 10804750112 11192463360 1860166304 18.505 100 92 184 1 1900547888 14034624 26346960
17:08:01 1387 8192000000 10803189760 11193876480 1864430896 18.539 100 91 182 2 1903797312 13267024 26099392
17:08:09 1592 8192000000 10812821520 11201351680 1870409296 18.588 100 97 191 3 1911005824 13002720 27593808
17:08:16 1825 8192000000 10812005328 11204186112 1869882480 18.583 100 89 175 0 1908417136 13073376 25461280
17:08:25 1469 8192000000 10818965536 11208937472 1876206336 18.634 100 92 185 0 1915275440 13502032 25567072
17:08:33 1600 8192000000 10818200800 11206987776 1874934096 18.624 100 87 172 1 1913223392 13940064 24349232
17:08:42 6306 8192000000 10812948320 11206045696 1874307392 18.619 100 86 173 2 1911720240 13371072 24041776
17:08:54 1141 8192000000 10824211536 11213713408 1877481936 18.645 100 89 176 0 1916979744 13932816 25564992
17:09:02 21364 8192000000 10779090608 11202228224 1874768352 18.623 100 53 106 1 1899511280 10641968 14100960
17:09:30 2541 8192000000 10799220752 11208286208 1876718848 18.639 100 57 114 1 1901753312 8545360 16489104
17:09:40 6963 8192000000 10807507376 11213672448 1873254144 18.611 100 37 74 1 1890322992 6427392 10641456
17:09:53 3556 8192000000 10807985104 11215331328 1877602176 18.646 100 51 102 2 1901988080 10355808 14030096
17:10:04 4036 8192000000 10797461568 11213541376 1877799904 18.647 100 37 74 2 1897342752 8604432 10938416
17:10:15 5690 8192000000 10799325392 11219390464 1882200432 18.683 100 39 78 0 1901728512 8785696 10742384
17:10:30 7388 8192000000 10781702320 11217731584 1881297360 18.676 100 19 38 0 1892486368 5786880 5402128
17:10:44 6359 8192000000 10793380320 11219574784 1886487568 18.717 100 24 49 3 1898696592 4843488 7365536
17:10:59 5254 8192000000 10796310176 11223384064 1889292864 18.740 100 37 75 1 1907228592 7270432 10665296
17:11:16 4751 8192000000 10797901312 11225780224 1886352048 18.716 100 21 42 3 1898920368 6975232 5593088
17:11:33 5708 8192000000 10802523984 11226968064 1888725008 18.736 100 25 50 1 1902543328 6052480 7765840
17:11:46 4378 8192000000 10811699712 11228864512 1892640272 18.767 100 43 87 1 1912701200 7901456 12159472
17:11:57 14582 8192000000 10818769920 11235672064 1891418592 18.757 100 27 53 2 1903999664 5307200 7273872
17:12:23 49363 8192000000 10827328320 11244519424 1895154608 18.787 100 23 46 0 1906790528 4932992 6702928
17:13:42 1621 8192000000 10868486528 11267207168 1913748112 18.937 100 94 190 0 1952028576 10567920 27712544
17:13:50 5971 8192000000 10820800432 11252645888 1901535232 18.839 100 39 78 0 1926226224 13892592 10798400
17:14:02 5351 8192000000 10826213792 11254829056 1902192096 18.844 100 30 60 0 1921440192 11356160 7891936
17:14:14 3176 8192000000 10829002032 11254235136 1905809184 18.873 100 47 94 0 1928408000 8783504 13815312
17:14:24 7800 8192000000 10816169408 11248308224 1902055104 18.843 100 29 58 0 1916903472 6646960 8201408
17:14:38 9270 8192000000 10822584032 11254120448 1903135568 18.852 100 27 53 1 1917562112 7299776 7126768
17:14:54 10758 8192000000 10814063152 11247362048 1881463872 18.677 99 18 36 1 1892646528 5889296 5293360
17:15:11 9539 8192000000 10806804240 11247915008 1899260176 18.820 100 16 32 1 1909785264 6263392 4261696
17:15:27 4818 8192000000 10819377296 11254013952 1904501616 18.862 100 26 52 1 1918141776 6227552 7412608
17:15:38 11666 8192000000 10814207728 11242803200 1869995600 18.584 98 17 34 1 1879928000 4701488 5230912
17:15:56 59967 8192000000 10793324256 11232772096 1840518544 18.345 97 22 43 1 1852079136 5482448 6078144
17:17:04 9318 8192000000 10803455792 11234467840 1855716672 18.469 98 27 54 0 1870006640 6408528 7881440
17:17:19 10030 8192000000 10801097584 11223285760 1830483648 18.263 97 25 50 2 1843253296 5864976 6904672
17:17:37 6404 8192000000 10769553008 11193942016 1813076480 18.121 97 39 77 1 1831005216 7425552 10503184
17:17:50 5435 8192000000 10788190304 11200475136 1843328848 18.368 99 35 68 2 1859380320 5574304 10477168
17:18:04 10238 8192000000 10779822176 11207778304 1842391520 18.360 99 29 58 2 1857139968 6279024 8469424
17:18:23 9645 8192000000 10771744000 11198849024 1831199616 18.269 98 15 30 2 1840772992 5417760 4155616
17:18:41 5928 8192000000 10759236944 11182825472 1828893168 18.250 99 19 38 3 1840340640 5990016 5457456
17:18:54 5642 8192000000 10769251168 11189592064 1848563184 18.410 100 35 70 1 1866520656 7422144 10535328
17:19:06 4517 8192000000 10746990928 11162087424 1759416416 17.680 95 26 52 0 1772683888 5673536 7593936
17:19:18 4754 8192000000 10711279680 11118538752 1773358944 17.795 98 26 52 1 1786720544 5750720 7610880
17:19:29 13455 8192000000 10713842320 11131916288 1734130528 17.470 96 9 18 0 1740736144 4704144 1901472
17:19:49 65254 8192000000 10701633392 11106422784 1630927984 16.603 90 26 52 1 1644190272 4548208 8714080
17:21:02 15285 8192000000 10722340912 11130474496 1756710176 17.657 97 24 48 0 1769298928 5500672 7088080
17:21:25 6155 8192000000 10663299136 11074748416 1685738304 17.066 94 19 38 1 1696862672 6029584 5094784
17:21:37 7464 8192000000 10690525040 11095506944 1746612944 17.574 98 27 52 3 1760016112 5793376 7609792
17:21:52 8352 8192000000 10724665968 11140648960 1805773952 18.061 100 21 42 4 1817509408 5655056 6080400
17:22:09 8645 8192000000 10738889296 11149225984 1795651392 17.978 99 26 52 2 1808710512 5977664 7081456
17:22:24 6637 8192000000 10751184704 11157725184 1804360256 18.050 99 25 48 0 1821477680 10315152 6802272
17:22:38 8002 8192000000 10751293696 11161985024 1820986480 18.186 100 21 42 2 1832924224 5271904 6665840
17:22:55 10010 8192000000 10759322528 11179528192 1841175328 18.350 100 18 36 0 1851943520 5436016 5332176
17:23:11 8649 8192000000 10760833696 11180179456 1815202032 18.138 98 25 50 1 1827760048 4945232 7612784
17:23:26 11093 8192000000 10757002144 11185426432 1846642704 18.395 100 20 38 0 1857716256 6042416 5031136
17:23:44 10035 8192000000 10751964576 11186184192 1849236784 18.416 100 29 58 2 1863972400 5542928 9192688
17:24:01 11803 8192000000 10763623008 11196170240 1853993744 18.455 100 15 30 0 1864072336 5821200 4257392
17:24:21 8436 8192000000 10777436176 11203772416 1869021728 18.576 100 34 66 1 1885232464 6517728 9693008
17:24:42 73912 8192000000 10768778864 11206639616 1866410176 18.555 100 29 58 0 1881404576 5758272 9236128
17:26:02 9916 8192000000 10782955920 11212517376 1868828688 18.575 100 19 36 1 1879677808 5106544 5742576
17:26:19 9285 8192000000 10795065424 11220209664 1873777968 18.615 100 28 57 3 1888251120 5686288 8786864
17:26:38 6234 8192000000 10805449648 11229933568 1883646736 18.695 100 37 74 0 1901036800 7012800 10377264
17:26:50 10164 8192000000 10800806864 11230273536 1886670640 18.719 100 29 57 2 1901327200 6265776 8390784
17:27:12 48894 8192000000 10843898240 11259731968 1903704960 18.856 100 42 83 2 1921736736 6818352 11213424
17:28:22 19539 8192000000 10858395600 11278286848 1921373584 18.998 100 53 102 2 1949559024 12815696 15369744
17:28:51 22282 8192000000 10875587984 11298471936 1929200640 19.060 100 47 94 0 1958604384 16358592 13045152
17:29:21 26191 8192000000 10877944144 11301425152 1940938800 19.154 100 49 96 1 1973742240 19082576 13720864
17:29:55 9364 8192000000 10884928064 11312414720 1946916080 19.202 100 41 78 1 1975257088 17549776 10791232
17:30:14 7228 8192000000 10898843616 11318362112 1954648864 19.263 100 56 112 1 1991286880 19545760 17092256
17:30:27 12532 8192000000 10901819488 11324612608 1956576144 19.279 100 55 110 3 1993552496 20665744 16310608
17:30:52 10527 8192000000 10914873024 11334262784 1960394656 19.309 100 55 108 0 1997731296 21521248 15815392
17:31:17 15083 8192000000 10901661984 11332546560 1961079408 19.315 100 36 72 1 1992494720 20758608 10656704
17:31:44 18308 8192000000 10909753504 11339337728 1966063520 19.354 100 43 84 2 1998508288 20365280 12079488
17:32:11 37782 8192000000 10901090752 11340181504 1953240768 19.252 99 36 72 0 1986565056 20882496 12441792
17:33:23 15173 8192000000 10915034176 11351752704 1970913552 19.393 100 32 62 3 2003738480 23305696 9519232
17:33:48 30848 8192000000 10906380160 11347034112 1952811296 19.249 99 25 50 4 1984018160 23748112 7458752
17:34:26 18344 8192000000 10914710832 11355996160 1972712976 19.407 100 30 60 0 2007458272 25514400 9230896
17:34:52 9096 8192000000 10936746528 11369013248 1983205888 19.490 100 50 98 1 2025069168 27067456 14795824
17:35:13 5780 8192000000 10938433760 11366162432 1985819248 19.511 100 52 104 1 2027467424 26142368 15505808
17:35:28 2684 8192000000 10942986608 11370950656 1987769488 19.526 100 66 133 0 2032408800 25545296 19094016
17:35:39 6216 8192000000 10941501616 11364532224 1982799088 19.487 100 65 130 0 2029084272 27835056 18450128
17:35:52 3482 8192000000 10948637072 11372077056 1987657136 19.525 100 70 140 4 2035618832 27875504 20086192
17:36:03 3482 8192000000 10958662512 11378696192 1993663392 19.573 100 71 142 0 2042315232 27779408 20872432
17:36:15 4825 8192000000 10964756048 11384737792 1996204000 19.593 100 65 130 1 2043020560 28013072 18803488
17:36:28 5728 8192000000 10972153104 11388010496 1999485088 19.619 100 77 154 0 2051229344 28553328 23190928
17:36:41 2650 8192000000 10974063328 11386884096 2002888624 19.646 100 81 160 1 2055832224 29483568 23460032
17:36:51 3428 8192000000 10969269824 11389681664 2008282048 19.688 100 84 168 0 2062367024 29789984 24294992
17:37:03 3247 8192000000 10982982272 11401502720 2012475808 19.721 100 87 174 2 2068079904 30724592 24879504
17:37:15 4708 8192000000 10953695360 11372875776 1984652112 19.502 99 74 148 4 2038284464 31733744 21898608
17:37:28 4847 8192000000 10956635792 11374059520 1974872976 19.424 99 78 154 2 2029757648 32182960 22701712
17:37:44 4025 8192000000 10953056672 11368255488 1977919216 19.448 99 82 156 1 2034730192 32467696 24343280
17:37:58 3034 8192000000 10954509344 11374911488 1985077120 19.505 100 71 141 1 2039304272 32878320 21348832
17:38:10 6606 8192000000 10956408640 11380293632 1988934928 19.535 100 69 135 1 2040869744 31842880 20091936
17:38:26 5837 8192000000 10961552320 11380232192 1989964512 19.544 100 70 139 1 2043467120 33553600 19949008
17:38:44 11691 8192000000 10974871616 11395137536 1998539648 19.611 100 73 143 1 2055804432 36428592 20836192
17:39:03 7065 8192000000 10968898992 11395371008 1996115600 19.592 100 75 150 0 2058156176 39791552 22249024
17:39:20 6572 8192000000 10956971840 11383341056 1987918128 19.527 100 60 120 1 2045588912 39570112 18100672
17:39:34 2689 8192000000 10966561328 11390345216 1991330816 19.554 100 73 146 2 2053584800 39936656 22317328
17:39:45 7766 8192000000 10973712192 11403407360 1995334912 19.586 100 70 137 1 2062505440 45489376 21681152
17:40:01 10440 8192000000 10962635920 11386564608 1973765648 19.415 99 58 118 0 2029721520 37580384 18375488
17:40:21 8637 8192000000 10938979920 11368386560 1970998864 19.393 100 66 130 1 2028782048 37854960 19928224
17:40:40 5513 8192000000 10915555056 11340136448 1943943760 19.178 99 62 123 1 1997328832 34223488 19161584
17:40:54 3479 8192000000 10943114496 11360935936 1966295344 19.356 100 67 134 2 2022545008 35580976 20668688
17:41:04 2560 8192000000 10938802192 11361091584 1969982176 19.385 100 75 152 1 2030147984 36306976 23858832
17:41:13 1390 8192000000 10950854704 11363430400 1970410144 19.389 100 89 179 2 2033607184 36473520 26723520
17:41:20 1694 8192000000 10954740880 11368738816 1973665152 19.415 100 81 162 3 2035015200 37661424 23688624
17:41:33 2616 8192000000 10949810032 11359629312 1964513200 19.342 100 82 164 0 2029045776 39311280 25221296
17:41:44 1546 8192000000 10950442464 11355529216 1964297808 19.340 100 86 170 2 2026829216 37486368 25045040
17:41:52 2516 8192000000 10967578416 11377643520 1981485776 19.476 100 91 181 1 2045417472 36689072 27242624
17:42:04 8823 8192000000 10959263472 11379585024 1985011680 19.504 100 81 161 2 2048159184 38053888 25093616
17:42:20 2282 8192000000 10970811920 11390836736 1989825184 19.542 100 83 165 0 2054910704 41103856 23981664
17:42:30 2257 8192000000 10935442976 11351830528 1951714496 19.240 99 67 134 0 2013010976 40818096 20478384
17:42:39 2549 8192000000 10949137840 11359604736 1955246688 19.268 99 88 176 0 2025397344 43229312 26921344
17:42:48 1628 8192000000 10966048800 11375988736 1981132960 19.474 100 88 176 1 2045830160 37973648 26723552
17:42:56 2450 8192000000 10938103376 11343773696 1939332032 19.141 98 83 163 2 2001830032 37991056 24506944
17:43:06 8643 8192000000 10927527056 11359723520 1964483072 19.342 100 61 122 0 2019821504 36688416 18650016
17:43:25 8174 8192000000 10914808336 11331928064 1923447600 19.014 98 62 124 3 1978438240 35227728 19762912
17:43:47 1656 8192000000 10938114880 11351130112 1961565104 19.318 100 85 171 1 2024079360 35549120 26965136
17:43:58 2378 8192000000 10937570736 11358330880 1961679696 19.319 100 75 151 1 2022483968 37005072 23799200
17:44:08 2076 8192000000 10958382816 11374604288 1974056112 19.418 100 81 163 0 2035301408 36729328 24515968
17:44:17 2168 8192000000 10944713568 11355693056 1962062832 19.322 100 85 167 2 2024963312 37571984 25328496
17:44:29 8933 8192000000 10932666352 11352678400 1957858176 19.289 100 72 145 1 2017230704 37191680 22180848
17:44:49 2368 8192000000 10941586224 11355910144 1957467744 19.286 100 71 142 0 2023144848 41848800 23828304
17:44:58 1795 8192000000 10952051072 11365003264 1967031120 19.362 100 80 160 2 2028460560 36686160 24743280
17:45:08 4781 8192000000 10936453840 11355873280 1958444624 19.294 100 80 156 1 2019210224 36303456 24462144
17:45:23 6232 8192000000 10926741776 11355992064 1958759712 19.296 100 69 136 2 2020418688 40363712 21295264
17:45:36 3065 8192000000 10946261440 11361763328 1973342960 19.412 100 87 171 4 2032339648 32742304 26254384
17:45:46 2368 8192000000 10963144768 11371593728 1974152480 19.418 100 89 179 2 2037299728 35190000 27957248
17:45:56 7148 8192000000 10958154208 11382091776 1975590672 19.430 100 58 116 1 2029483568 35270560 18622336
17:46:10 6442 8192000000 10949447984 11371266048 1972243648 19.403 100 71 141 1 2031248368 36451872 22552848
17:46:24 6800 8192000000 10935886000 11362955264 1950791744 19.233 99 60 120 0 2008018896 37335488 19891664
17:46:41 9085 8192000000 10929141344 11360137216 1955890416 19.273 100 53 106 0 2013210000 39619408 17700176
17:46:57 9535 8192000000 10931521408 11365642240 1955105008 19.267 100 44 89 1 2014734128 44780224 14848896
17:47:13 7335 8192000000 10928864816 11364364288 1950565760 19.231 100 43 86 1 2013610416 48305392 14739264
17:47:32 5589 8192000000 10911883440 11347550208 1943316272 19.173 100 49 98 1 2004573856 45068368 16189216
17:47:52 17364 8192000000 10908280608 11353378816 1929970576 19.067 99 36 72 0 1986422240 44463584 11988080
17:48:16 7015 8192000000 10909077008 11352539136 1948916128 19.218 100 42 84 0 1999216544 34810560 15489856
17:48:31 12260 8192000000 10894598576 11337244672 1907955488 18.890 98 28 56 0 1949927344 32198800 9773056
17:49:28 28608 8192000000 10878788432 11336630272 1907014320 18.883 98 25 50 1 1945353584 29907040 8432224
17:50:07 17997 8192000000 10886855280 11328057344 1923064944 19.011 100 28 56 2 1965849728 33208144 9576640
17:50:35 15569 8192000000 10897462096 11346759680 1937801376 19.129 100 32 64 0 1987821568 39375296 10644896
17:51:25 20741 8192000000 10889194672 11343040512 1939579600 19.143 100 21 42 0 1976740944 29964432 7196912
17:51:58 26391 8192000000 10875865696 11334782976 1935122912 19.108 100 18 35 1 1967054128 26534352 5396864
17:52:31 12390 8192000000 10890218224 11332632576 1886756992 18.720 97 28 56 0 1925995488 29863056 9375440
17:52:50 5111 8192000000 10888068352 11329564672 1925826144 19.033 100 43 86 1 1966642256 27021088 13795024
17:53:03 18917 8192000000 10855601520 11309166592 1884148336 18.699 98 29 57 2 1916517728 23944656 8424736
17:53:33 23596 8192000000 10863759792 11321442304 1921070064 18.995 100 16 32 0 1942686288 17077440 4538784
17:54:02 21770 8192000000 10858273264 11320287232 1925492832 19.031 100 14 28 1 1943390384 13276192 4621360
17:54:32 24178 8192000000 10870913776 11316154368 1913636640 18.936 99 33 66 0 1937131888 13002864 10492384
17:55:08 37297 8192000000 10871491392 11326283776 1911324192 18.917 99 20 38 1 1933598160 16519152 5754816
17:56:01 29765 8192000000 10882422784 11343417344 1932892880 19.090 100 10 20 1 1952419632 16076784 3449968
17:57:08 58967 8192000000 10883257584 11335757824 1918533344 18.975 99 10 21 1 1931816624 10653616 2629664
17:58:13 57944 8192000000 10887240464 11332513792 1876427136 18.636 96 13 26 0 1894941584 15291856 3222592
17:59:29 95415 8192000000 10884501936 11337043968 1915500768 18.951 98 10 20 0 1928989232 11303488 2184976
18:01:18 60432 8192000000 10871153728 11327016960 1905231248 18.868 97 11 22 0 1914733600 7143968 2358384
18:02:25 61177 8192000000 10873292064 11341348864 1867510240 18.564 95 7 14 0 1879628368 10572976 1545152
18:03:32 77249 8192000000 10865716976 11309195264 1911220624 18.916 98 16 30 0 1924704608 9016096 4467888
18:05:17 99139 8192000000 10915041216 11364610048 1950469280 19.230 99 36 72 1 1971221504 10380704 10371520
18:07:02 62886 8192000000 10896596016 11362553856 1953679600 19.256 99 19 39 2 1968241504 9722480 4839424
18:08:13 11298 8192000000 10908301632 11370754048 1974989984 19.425 100 16 32 1 1990755776 11637648 4128144
18:08:33 29769 8192000000 10914860544 11361894400 1946762640 19.201 98 39 78 0 1969151824 10660864 11728320
18:09:11 76213 8192000000 10910874656 11373760512 1961879552 19.321 99 25 50 2 1980921984 11495168 7547264
18:10:33 41077 8192000000 10944693360 11387691008 1972186512 19.403 99 33 67 1 1994830464 12427664 10216288
18:11:28 47750 8192000000 10911710224 11390537728 1991081792 19.552 100 32 64 1 2016875536 16624384 9169360
18:12:44 35410 8192000000 10901018976 11384487936 1968265696 19.372 99 13 26 1 1986649808 14275136 4108976
18:13:26 26203 8192000000 10915098176 11379982336 1970057664 19.386 99 17 34 0 1990404560 15062240 5284656
18:14:04 15942 8192000000 10899511408 11362877440 1965119600 19.347 99 19 36 1 1986351312 15729056 5502656
18:14:31 56516 8192000000 10922001424 11391041536 1982515008 19.485 100 9 18 2 2004704832 19565648 2624176
18:16:11 93007 8192000000 10929216016 11403862016 1988737472 19.534 100 22 44 0 2019868752 24735312 6395968
18:17:52 104646 8192000000 10895194304 11379159040 1914575392 18.943 96 16 31 2 1940074016 21008656 4489968
18:19:43 52615 8192000000 10914724576 11398873088 1993432592 19.571 100 15 30 0 2010771936 13391040 3948304
18:20:46 38649 8192000000 10886321536 11356053504 1891264304 18.756 95 21 42 1 1907449264 10398256 5786704
18:21:39 31936 8192000000 10862566352 11339046912 1922636864 19.008 98 13 26 0 1936437968 10004688 3796416
18:22:53 68028 8192000000 10878111632 11367215104 1940444704 19.150 99 9 18 1 1957052352 13196752 3410896
18:24:17 48139 8192000000 10854819968 11328212992 1903928496 18.858 97 3 6 0 1910507312 5370608 1208208
18:25:12 49603 8192000000 10869031280 11339268096 1884605968 18.702 96 19 38 0 1896808672 7643120 4559584
18:26:25 90049 8192000000 10872071280 11350491136 1924271456 19.021 98 20 40 0 1938926656 9193744 5461456
18:28:01 48846 8192000000 10896710384 11371667456 1955387200 19.269 99 7 14 0 1964721936 7641280 1693456
18:29:01 2046 8192000000 10914065392 11350097920 1962818896 19.328 99 67 131 2 1988605776 6184608 19602272
18:29:12 28089 8192000000 10908549696 11364995072 1930776128 19.073 98 35 70 1 1949865632 9299552 9789952
18:29:51 54193 8192000000 10908952240 11385925632 1937770640 19.129 98 25 50 0 1961054720 16077904 7206176
18:31:00 73809 8192000000 10922910048 11411447808 1982767088 19.487 100 11 22 1 2010535536 24028208 3740240
18:32:58 80086 8192000000 10894298576 11368742912 1914468768 18.943 97 8 16 1 1929566528 13114800 1982960
18:34:30 23994 8192000000 10925848928 11384930304 1966233744 19.356 99 42 84 1 1987646688 9646032 11766912
18:35:08 50811 8192000000 10898703440 11362439168 1897703392 18.808 96 12 24 0 1916314384 15073088 3537904
18:36:06 44605 8192000000 10901888000 11352203264 1899041760 18.819 97 20 39 0 1924432848 19403232 5987856
18:36:57 31136 8192000000 10875372496 11339964416 1909422624 18.902 98 42 84 2 1939555232 17870944 12261664
18:37:35 47904 8192000000 10856684784 11289243648 1840149424 18.342 95 35 69 0 1859672784 9395808 10127552
18:38:30 41853 8192000000 10878940608 11316412416 1897016272 18.802 98 36 72 0 1915815312 8904192 9894848
18:39:19 74400 8192000000 10879945936 11323080704 1887111408 18.722 97 42 84 1 1908495968 9761088 11623472
18:40:48 63557 8192000000 10860137632 11334889472 1920646768 18.992 99 38 76 1 1943584016 12098640 10838608
18:41:58 33339 8192000000 10874251600 11331371008 1923802992 19.017 99 31 61 1 1943002656 10856944 8342720
18:42:42 40330 8192000000 10893739152 11348049920 1951980912 19.242 100 42 84 0 1979921344 15868592 12071840
18:43:29 25375 8192000000 10894660384 11352727552 1939502720 19.143 99 39 77 2 1971812288 21679968 10629600
18:44:08 61418 8192000000 10871388096 11351457792 1927416768 19.046 99 19 36 1 1953373456 20246416 5710272
18:45:20 17856 8192000000 10863487392 11330830336 1921945072 19.002 99 6 12 0 1947379888 23646144 1788672
18:45:45 27690 8192000000 10867617520 11340636160 1923097408 19.012 99 13 25 1 1943022688 16391056 3534224
18:46:29 58363 8192000000 10870686160 11338899456 1925455584 19.031 99 15 31 0 1942259648 12367440 4436624
18:47:44 88349 8192000000 10860012832 11343175680 1925214000 19.029 99 13 25 2 1939789648 10732192 3843456
18:49:31 57896 8192000000 10889402752 11356921856 1936908080 19.122 99 16 32 0 1960493152 19334048 4251024
18:50:41 75039 8192000000 10873407968 11356442624 1918865440 18.978 98 17 34 2 1939244320 15597168 4781712
18:52:03 72205 8192000000 10900188640 11346505728 1920878256 18.994 98 36 72 0 1939613216 8384816 10350144
18:53:27 43889 8192000000 10871293312 11348557824 1920514160 18.991 98 18 36 0 1933669136 8296208 4858768
18:54:17 49802 8192000000 10891710512 11348103168 1915158528 18.948 98 17 34 0 1929543264 9862208 4522528
18:55:19 19233 8192000000 10889025648 11352576000 1961580384 19.319 100 38 76 0 1983446304 11369024 10496896
18:55:47 113894 8192000000 10886658288 11354353664 1895756752 18.792 97 13 26 2 1915355680 15685056 3913872
18:57:49 70087 8192000000 10924589600 11384315904 1959400464 19.301 99 26 51 1 1975131280 9228736 6502080
18:59:13 128726 8192000000 10926257616 11406397440 1928849248 19.058 97 13 26 0 1949691904 17795280 3047376
19:01:30 108005 8192000000 10927237232 11400388608 1979502592 19.461 100 14 28 1 2006464496 23062192 3899712
19:03:24 106359 8192000000 10919929424 11392913408 1971269568 19.396 99 29 58 0 1987586400 8344112 7972720
19:05:19 52829 8192000000 10910785696 11397779456 1990700112 19.549 100 9 18 1 2007726464 14835648 2190704
19:06:18 6953 8192000000 10916569328 11402452992 1992162000 19.561 100 9 18 0 2008583952 13634640 2787312
19:06:31 60901 8192000000 10893808128 11384913920 1958789712 19.296 98 14 28 2 1971145120 8581376 3774032
19:07:42 62327 8192000000 10882837136 11363225600 1906579824 18.879 96 7 14 0 1915665424 7348928 1736672
19:08:51 53874 8192000000 10879917568 11348348928 1931006496 19.075 98 11 22 0 1939818704 6049872 2762336
19:10:04 56310 8192000000 10883256720 11354906624 1957792224 19.288 99 17 34 1 1972909296 9936960 5180112
19:11:24 105477 8192000000 10872451936 11346960384 1917764880 18.969 97 17 34 1 1935964288 13119376 5080032
19:13:31 51102 8192000000 10860083568 11346067456 1913996128 18.939 98 15 30 0 1935766272 17427984 4342160
19:14:37 77017 8192000000 10868934624 11340263424 1840091376 18.342 94 8 16 1 1848522944 6508720 1922848
19:16:19 67631 8192000000 10857910128 11337764864 1924019136 19.019 99 17 34 3 1942732416 13063344 5649936
19:17:36 55503 8192000000 10877805360 11336650752 1895143616 18.787 97 34 67 3 1918724128 14102720 9477792
19:18:47 66196 8192000000 10864163984 11348238336 1912193440 18.924 98 15 30 0 1932373248 15914944 4264864
19:20:03 34376 8192000000 10881477152 11338625024 1940794720 19.153 100 21 42 0 1955495312 8861472 5839120
19:20:45 24000 8192000000 10884435040 11346944000 1938669104 19.136 99 47 94 1 1963091088 10963376 13458608
19:21:20 38679 8192000000 10885312816 11350364160 1932177296 19.084 99 34 68 2 1954429072 12598928 9652848
19:22:07 37888 8192000000 10888115888 11350515712 1917740496 18.969 98 31 62 1 1939854768 13601888 8512384
19:22:51 25588 8192000000 10904706368 11358654464 1941274000 19.157 99 37 74 3 1967638272 16322592 10041680
19:23:24 39937 8192000000 10891798144 11358732288 1946005280 19.195 99 28 56 0 1967061920 13704352 7352288
19:24:35 49335 8192000000 10876060704 11334275072 1850721040 18.428 95 24 48 1 1866481328 9646096 6114192
19:25:30 74934 8192000000 10883643952 11359006720 1912786976 18.929 98 29 58 3 1936336800 15182928 8366896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 13-11-2020 19:28:07 to 13-11-2020 19:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 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 13-11-2020 19:28:41 to 13-11-2020 19:28:42.

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          247559
MON$OLDEST_ACTIVE               248182
MON$OLDEST_SNAPSHOT             248182
MON$NEXT_TRANSACTION            248182
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                       2044256
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:51: 
:52: mscs-test-161.budzdorov.ru    Fri Nov 13 19:27:15 2020
:53:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:54: 
:55: 
:56: mscs-test-161.budzdorov.ru    Fri Nov 13 19:27:20 2020
:57:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:58: 
--- end of diff output ---

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

13.11.20 19:28:43. 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-13 19:28:46 No severe PSQL-related problems occured
13.11.20 19:28:47. End of report.