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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-31 16:27:09
DTS_END                         2020-12-31 16:27:09.0220
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/33268
TRN_ID                          247440
ATT_ID                          646
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9712.42 19522 1165490
customer order: creation 181.02 306 21722
customer order: refuse 15.53 305 1863
order to supplier: creation 48.48 1213 5817
order to supplier: removal 3.70 88410 444
invoice (draft): creation 48.30 3208 5796
invoice (draft): removal 54.63 752 6555
invoice accept: apply 43.48 15991 5218
invoice accept: cancel 49.18 732 5902
customer reserve: creation 4071.87 156 488624
customer reserve: removal 4887.79 52 586535
realization accept: apply 86.32 160 10358
realization accept: cancel 86.62 89 10394
payment from customer: creation 61.62 101 7394
payment from customer: removal 5.95 55 714
payment to supplier: creation 51.05 112 6126
payment to supplier: removal 3.93 57 471
service: total inventory turnovers 5.05 1074 606
service: total monetary turnovers 7.13 19 855
service: aggregate perf. data 0.77 23281 92
service: refresh index statistics 0.03 254360 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-12-2020 16:28:41 to 31-12-2020 16:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1446
TEST_TIME 2 2855
TEST_TIME 3 3471
TEST_TIME 4 4495
TEST_TIME 5 4043
TEST_TIME 6 4551
TEST_TIME 7 4969
TEST_TIME 8 5324
TEST_TIME 9 5361
TEST_TIME 10 5367
TEST_TIME 11 5978
TEST_TIME 12 6456
TEST_TIME 13 6434
TEST_TIME 14 6235
TEST_TIME 15 7126
TEST_TIME 16 7774
TEST_TIME 17 8092
TEST_TIME 18 8604
TEST_TIME 19 8706
TEST_TIME 20 8933
TEST_TIME 21 9062
TEST_TIME 22 9473
TEST_TIME 23 10172
TEST_TIME 24 10079
TEST_TIME 25 10879
TEST_TIME 26 10828
TEST_TIME 27 10675
TEST_TIME 28 10690
TEST_TIME 29 10756
TEST_TIME 30 10733
TEST_TIME 31 10703
TEST_TIME 32 10628
TEST_TIME 33 10837
TEST_TIME 34 10896
TEST_TIME 35 10845
TEST_TIME 36 10767
TEST_TIME 37 10863
TEST_TIME 38 10690
TEST_TIME 39 10464
TEST_TIME 40 10505
TEST_TIME 41 10516
TEST_TIME 42 10395
TEST_TIME 43 10367
TEST_TIME 44 10258
TEST_TIME 45 10260
TEST_TIME 46 10302
TEST_TIME 47 10195
TEST_TIME 48 10065
TEST_TIME 49 10218
TEST_TIME 50 10136
TEST_TIME 51 10094
TEST_TIME 52 9961
TEST_TIME 53 9921
TEST_TIME 54 9882
TEST_TIME 55 9818
TEST_TIME 56 9763
TEST_TIME 57 9752
TEST_TIME 58 9767
TEST_TIME 59 9817
TEST_TIME 60 9771
TEST_TIME 61 9775
TEST_TIME 62 9918
TEST_TIME 63 9881
TEST_TIME 64 9936
TEST_TIME 65 9967
TEST_TIME 66 10006
TEST_TIME 67 10069
TEST_TIME 68 10133
TEST_TIME 69 10083
TEST_TIME 70 10161
TEST_TIME 71 10160
TEST_TIME 72 10046
TEST_TIME 73 10016
TEST_TIME 74 9948
TEST_TIME 75 9971
TEST_TIME 76 9919
TEST_TIME 77 9884
TEST_TIME 78 9794
TEST_TIME 79 9844
TEST_TIME 80 9783
TEST_TIME 81 9791
TEST_TIME 82 9833
TEST_TIME 83 9837
TEST_TIME 84 9802
TEST_TIME 85 9789
TEST_TIME 86 9824
TEST_TIME 87 9850
TEST_TIME 88 9799
TEST_TIME 89 9814
TEST_TIME 90 9875
TEST_TIME 91 9954
TEST_TIME 92 9940
TEST_TIME 93 9963
TEST_TIME 94 9942
TEST_TIME 95 9963
TEST_TIME 96 9932
TEST_TIME 97 9858
TEST_TIME 98 9810
TEST_TIME 99 9810
TEST_TIME 100 9772
TEST_TIME 101 9703
TEST_TIME 102 9738
TEST_TIME 103 9704
TEST_TIME 104 9704
TEST_TIME 105 9726
TEST_TIME 106 9707
TEST_TIME 107 9711
TEST_TIME 108 9696
TEST_TIME 109 9701
TEST_TIME 110 9772
TEST_TIME 111 9799
TEST_TIME 112 9823
TEST_TIME 113 9789
TEST_TIME 114 9810
TEST_TIME 115 9818
TEST_TIME 116 9879
TEST_TIME 117 9856
TEST_TIME 118 9816
TEST_TIME 119 9774
TEST_TIME 120 9713

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-12-2020 16:28:45 to 31-12-2020 16:28:48.

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 1618022 1618022 0 0.00 0 15156 6 0 0
doc_list_biud 1618022 1618022 0 0.00 0 51861 24 0 0
sp_add_invoice_to_stock 5379 5218 161 2.99 37 174864 15991 0 161
sp_cancel_adding_invoice 5902 5902 0 0.00 5 67042 732 0 0
sp_cancel_client_order 1863 1863 0 0.00 4 12720 305 0 0
sp_cancel_customer_reserve 586535 586535 0 0.00 1 18379 53 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 2 2427 56 0 0
sp_cancel_pay_to_supplier 471 471 0 0.00 3 4495 58 0 0
sp_cancel_supplier_invoice 6566 6555 11 0.16 1 52017 753 0 11
sp_cancel_supplier_order 444 444 0 0.00 5 848962 88411 0 0
sp_cancel_write_off 10394 10394 0 0.00 1 10269 89 0 0
sp_client_order 21722 21722 0 0.00 3 15012 306 0 0
sp_customer_reserve 488624 488624 0 0.00 0 91302 157 0 0
sp_fill_shopping_cart 33327 33327 0 0.00 1 11503 32 0 0
sp_fill_shopping_cart_clo_res 488621 488621 0 0.00 0 15770 11 0 0
sp_get_clo_for_invoice 5215 5215 0 0.00 0 35786 272 0 0
sp_kill_cost_storno 17481 17481 0 0.00 0 7314 47 0 0
sp_kill_qstorno_ret_qs2qd 1190463 1190463 0 0.00 0 51860 29 0 0
sp_kill_qty_storno 627265 627265 0 0.00 0 51860 62 0 0
sp_lock_selected_doc 21809 21809 0 0.00 0 9608 7 0 0
sp_make_cost_storno 29092 29092 0 0.00 0 13983 50 0 0
sp_multiply_rows_for_pdistr 29092 29092 0 0.00 0 6470 24 0 0
sp_multiply_rows_for_qdistr 21722 21722 0 0.00 0 9473 135 0 0
sp_pay_from_customer 7394 7394 0 0.00 4 15520 101 0 0
sp_pay_to_supplier 6126 6126 0 0.00 4 11729 113 0 0
sp_payment_common 13520 13520 0 0.00 1 15480 31 0 0
sp_qd_handle_on_cancel_clo 1863 1863 0 0.00 0 12698 276 0 0
sp_qd_handle_on_invoice_upd_sts 11116 11116 0 0.00 0 16020 298 0 0
sp_qd_handle_on_reserve_upd_sts 10358 10358 0 0.00 0 23108 55 0 0
sp_reserve_write_off 10358 10358 0 0.00 6 23163 161 0 0
sp_supplier_invoice 5796 5796 0 0.00 6 92507 3209 0 0
sp_supplier_order 5817 5817 0 0.00 4 84778 1214 0 0
srv_aggregate_perf_data 92 92 0 0.00 2790 390286 23282 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1678 165420 35651 0 0
srv_find_qd_qs_mism 1115296 1115296 0 0.00 0 15156 5 0 0
srv_make_invnt_saldo 606 606 0 0.00 27 99804 1075 0 0
srv_make_money_saldo 855 855 0 0.00 0 1236 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 187692 352127 254360 0 0
t$perf-abend:sp_add_invoice_to_stock 161 161 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5218 5218 0 0.00 0 11211 131 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 4802 92 0 0
t$perf-norm:sp_cancel_client_order 1863 1863 0 0.00 0 4129 14 0 0
t$perf-norm:sp_cancel_customer_reserve 744 744 0 0.00 0 3054 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 714 714 0 0.00 0 834 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 471 471 0 0.00 0 1047 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 455 455 0 0.00 0 871 14 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 21970 1536 0 0
t$perf-norm:sp_cancel_write_off 1116 1116 0 0.00 0 7119 11 0 0
t$perf-norm:sp_client_order 21722 21722 0 0.00 0 9457 14 0 0
t$perf-norm:sp_customer_reserve 1073 1073 0 0.00 0 5801 8 0 0
t$perf-norm:sp_pay_from_customer 7394 7394 0 0.00 0 3749 7 0 0
t$perf-norm:sp_pay_to_supplier 6126 6126 0 0.00 0 5941 8 0 0
t$perf-norm:sp_reserve_write_off 10358 10358 0 0.00 0 7105 9 0 0
t$perf-norm:sp_supplier_invoice 5796 5796 0 0.00 0 4426 13 0 0
t$perf-norm:sp_supplier_order 5817 5817 0 0.00 0 6386 11 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 160 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 431 3 0 0
t$perf-norm:srv_make_invnt_saldo 606 606 0 0.00 0 1096 17 0 0
t$perf-norm:srv_make_money_saldo 855 855 0 0.00 0 3133 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 70 21 0 0
v_add_invoice_to_stock 10750 10428 322 2.99 0 6854 19 0 322
v_all_customers 39766 39766 0 0.00 0 138 0 0 0
v_all_suppliers 32370 32370 0 0.00 0 74 1 0 0
v_all_wares 43444 43444 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 5008 14 0 0
v_cancel_client_order 3726 3726 0 0.00 0 3519 4 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 467 3 0 0
v_cancel_customer_reserve 1488 1488 0 0.00 0 1679 5 0 0
v_cancel_payment_to_supplier 942 942 0 0.00 0 3223 7 0 0
v_cancel_supplier_invoice 932 910 22 2.36 0 1729 17 0 22
v_cancel_supplier_order 888 888 0 0.00 0 1384 4 0 0
v_cancel_write_off 2232 2232 0 0.00 0 3177 14 0 0
v_max_id_clo_ord 5816 5816 0 0.00 0 146 1 0 0
v_max_id_clo_res 1073 1073 0 0.00 0 4905 18 0 0
v_max_id_ord_sup 5789 5789 0 0.00 0 5034 4 0 0
v_max_non_paid_invoice 1546 1546 0 0.00 0 1863 5 0 0
v_max_non_paid_realizn 3749 3749 0 0.00 0 2677 4 0 0
v_min_id_clo_ord 5816 5816 0 0.00 0 4113 6 0 0
v_min_id_clo_res 1073 1073 0 0.00 0 5519 20 0 0
v_min_id_ord_sup 5789 5789 0 0.00 0 4419 7 0 0
v_min_non_paid_invoice 6126 6126 0 0.00 0 8839 18 0 0
v_min_non_paid_realizn 7394 7394 0 0.00 0 12281 22 0 0
v_our_firm 10968 10968 0 0.00 0 28 1 0 0
v_reserve_write_off 20716 20716 0 0.00 0 3860 4 0 0
x_lock_depdocs_on_canc_invoice 12002 12002 0 0.00 0 14636 101 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 6969 314 0 0
x_make_qstorno_1000_1200 5817 5817 0 0.00 2 84770 1145 0 0
x_make_qstorno_1200_2000 5796 5796 0 0.00 2 92499 3095 0 0
x_make_qstorno_2100_3300 488624 488624 0 0.00 0 91301 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-12-2020 16:28:49 to 31-12-2020 16:28:53.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:18 20813 8192000000 10261362000 10570395648 932521680 10.219 71 50 100 0 951980016 2659312 16799024
13:57:48 27598 8192000000 10355243248 10677596160 1396559360 14.564 100 83 166 0 1429211888 5033488 27619040
13:58:24 12348 8192000000 10371576688 10701697024 1435673072 14.911 100 84 166 1 1468255520 5773424 26809024
13:58:49 19091 8192000000 10435251488 10765107200 1478591920 15.289 100 89 178 0 1513543264 6926688 28024656
13:59:20 17629 8192000000 10447018064 10782248960 1497459680 15.454 100 91 182 0 1534316672 7796704 29060288
13:59:48 16488 8192000000 10461261952 10796056576 1512626656 15.586 100 87 174 1 1548491840 8217184 27648000
14:00:17 19773 8192000000 10472041264 10810179584 1526670832 15.708 100 89 176 1 1562849632 8520720 27658080
14:00:49 14255 8192000000 10480446160 10821214208 1538269776 15.809 100 86 170 0 1573231712 8546272 26415664
14:01:16 16389 8192000000 10487860320 10836574208 1551771392 15.925 100 89 178 2 1588762912 8681520 28310000
14:01:45 9620 8192000000 10519196512 10869633024 1574809136 16.124 100 76 150 2 1606535600 8457856 23268608
14:02:03 14769 8192000000 10540448848 10894254080 1596152352 16.306 100 75 149 1 1627755328 8982864 22620112
14:02:28 11661 8192000000 10551561952 10910810112 1618518960 16.497 100 73 146 1 1650164080 9057856 22587264
14:02:53 9691 8192000000 10575405936 10938617856 1636622080 16.651 100 71 142 1 1667592928 9664688 21306160
14:03:10 11807 8192000000 10600228368 10968289280 1660414304 16.852 100 73 145 2 1691957136 10557328 20985504
14:03:30 11244 8192000000 10631594832 10997080064 1687904128 17.084 100 82 164 3 1723450096 11344416 24201552
14:03:49 10491 8192000000 10634718176 11007115264 1696269008 17.154 100 77 154 0 1730495568 12473440 21753120
14:04:07 10041 8192000000 10649862496 11019608064 1713445024 17.298 100 88 175 2 1751686288 12746464 25494800
14:04:24 8212 8192000000 10677967504 11051126784 1728137088 17.420 100 86 171 1 1765680640 12994192 24549360
14:04:40 7997 8192000000 10680899744 11061747712 1745447264 17.564 100 76 152 1 1779702288 12751504 21503520
14:04:55 5446 8192000000 10700848384 11078238208 1762471488 17.705 100 82 163 1 1797183456 11757616 22954352
14:05:08 4975 8192000000 10714673664 11091111936 1774928720 17.808 100 85 168 1 1811790112 13217072 23644320
14:05:20 4479 8192000000 10717106384 11098439680 1781685360 17.863 100 81 161 1 1817904816 13728704 22490752
14:05:32 5771 8192000000 10727486704 11109154816 1788316464 17.918 100 77 154 1 1822976144 13380960 21278720
14:05:46 5959 8192000000 10742113584 11120574464 1795770544 17.979 100 85 169 2 1832767328 13480400 23516384
14:05:59 7132 8192000000 10743827120 11128766464 1801356336 18.025 100 73 146 2 1834826656 13442016 20028304
14:06:13 3081 8192000000 10760234176 11144818688 1818149664 18.163 100 83 165 2 1854962320 13534336 23278320
14:06:22 3390 8192000000 10769152816 11155636224 1823965536 18.210 100 87 172 2 1861945504 13993520 23986448
14:06:33 3513 8192000000 10779505264 11160956928 1833818112 18.290 100 87 173 3 1872304448 14276832 24209504
14:06:43 2504 8192000000 10779953552 11169173504 1837485520 18.320 100 87 175 3 1875645280 14189536 23970224
14:06:51 2440 8192000000 10784415712 11168620544 1841920864 18.356 100 85 171 0 1880030720 14035024 24074832
14:07:00 2096 8192000000 10790084240 11176820736 1847988816 18.406 100 96 193 0 1889109808 14381104 26739888
14:07:09 2293 8192000000 10784428672 11172421632 1851455712 18.434 100 88 177 0 1890520272 13542432 25522128
14:07:18 2009 8192000000 10800048048 11185160192 1852400608 18.442 100 86 171 2 1889243040 13504816 23337616
14:07:26 2040 8192000000 10795147968 11187073024 1860982336 18.511 100 92 179 2 1898190480 12353184 24854960
14:07:34 1404 8192000000 10808753792 11198521344 1866109696 18.553 100 90 181 1 1904798128 12814400 25874032
14:07:42 1647 8192000000 10805927216 11195940864 1867034688 18.560 100 89 178 1 1905642304 13818000 24789616
14:07:50 1458 8192000000 10816073792 11204177920 1874467008 18.620 100 92 185 0 1914307904 14182720 25658176
14:07:58 1967 8192000000 10822088720 11210776576 1875485072 18.629 100 91 182 1 1915177600 14747744 24944784
14:08:06 1442 8192000000 10823209840 11212972032 1877310944 18.643 100 95 193 3 1918901744 14667760 26923040
14:08:14 3911 8192000000 10828776800 11220430848 1883888768 18.696 100 89 179 1 1923585424 14354384 25342272
14:08:24 4671 8192000000 10802971536 11213467648 1875730672 18.631 100 62 125 0 1905864240 12798992 17334576
14:08:36 1932 8192000000 10806079952 11211309056 1878384864 18.652 100 72 142 0 1909887616 10724992 20777760
14:08:45 1555 8192000000 10819545952 11210887168 1879106160 18.658 100 69 138 1 1908879168 10501808 19271200
14:08:53 2073 8192000000 10814125984 11215831040 1882077184 18.682 100 72 145 1 1912930032 11056880 19795968
14:09:03 35401 8192000000 10804542704 11211468800 1874941632 18.624 100 44 86 1 1900559120 12501600 13115888
14:09:45 6038 8192000000 10791229344 11216969728 1874400384 18.620 100 24 48 0 1887429200 5937184 7091632
14:09:59 8617 8192000000 10788004400 11219140608 1876857536 18.640 100 25 50 0 1895155824 11102112 7196176
14:10:14 4864 8192000000 10782912416 11220340736 1879148976 18.658 100 25 51 1 1897695376 11376016 7170384
14:10:32 9957 8192000000 10785797488 11217551360 1878904928 18.656 100 20 40 2 1891291712 6449680 5937104
14:10:49 9649 8192000000 10790103760 11222192128 1880497856 18.669 100 15 30 1 1890560272 6025104 4037312
14:11:09 9432 8192000000 10790289376 11224416256 1884890016 18.705 100 16 32 2 1895997872 6329552 4778304
14:11:24 7219 8192000000 10793463680 11226296320 1884985680 18.705 100 17 34 1 1896045104 6290496 4768928
14:11:39 7467 8192000000 10789086864 11224674304 1885908992 18.713 100 21 42 0 1898510368 6492992 6108384
14:11:53 7411 8192000000 10799899008 11234992128 1886534624 18.718 100 17 34 0 1897853696 6293424 5025648
14:12:07 13400 8192000000 10789859616 11229675520 1889320512 18.740 100 17 34 0 1900621888 6213056 5088320
14:12:31 10546 8192000000 10811618208 11241971712 1895125104 18.787 100 25 50 5 1907675920 5696736 6854080
14:12:47 19794 8192000000 10799977616 11243311104 1899353488 18.821 100 32 64 2 1915049504 6946768 8749248
14:13:36 25675 8192000000 10865762688 11266510848 1910070448 18.907 100 82 168 1 1940574464 6404128 24099888
14:14:08 4791 8192000000 10831563008 11256090624 1905137408 18.868 100 46 92 0 1928476128 10763360 12575360
14:14:19 10058 8192000000 10807622624 11247603712 1901010112 18.834 100 19 37 0 1911708656 5023984 5674560
14:14:35 7103 8192000000 10828399088 11257724928 1904678896 18.864 100 32 60 1 1919748880 6933552 8136432
14:14:48 6411 8192000000 10815039360 11254452224 1905301120 18.869 100 27 55 2 1919502208 6832224 7368864
14:15:03 5912 8192000000 10816552928 11253387264 1908771152 18.897 100 31 62 0 1925154592 6429504 9953936
14:15:17 4577 8192000000 10816177312 11254665216 1906758960 18.881 100 20 40 0 1919000384 6032304 6209120
14:15:28 7049 8192000000 10827140640 11260149760 1909180048 18.900 100 24 48 0 1922950816 6311968 7458800
14:15:44 5127 8192000000 10828860096 11266662400 1913098800 18.932 100 31 60 1 1932948800 11166208 8683792
14:15:55 7414 8192000000 10819769008 11251613696 1888161776 18.731 99 27 54 0 1905176336 10203712 6810848
14:16:10 6025 8192000000 10802682608 11242041344 1897382032 18.805 100 30 60 1 1913468960 6649584 9437344
14:16:22 11564 8192000000 10794667088 11230609408 1856194384 18.472 98 13 26 1 1865938880 6053984 3690512
14:16:40 8925 8192000000 10802042160 11238907904 1890039872 18.746 100 14 28 0 1899895456 5993792 3861792
14:16:55 10072 8192000000 10811084944 11224027136 1826687120 18.232 96 33 67 1 1841391312 4692640 10011552
14:17:13 63615 8192000000 10773355312 11206840320 1808975888 18.087 96 28 54 2 1821833056 5048096 7809072
14:18:23 12492 8192000000 10778441920 11201818624 1823498608 18.206 98 14 28 0 1832615408 5437568 3679232
14:18:42 8285 8192000000 10760301856 11187224576 1774462080 17.804 95 25 50 1 1791123776 9991072 6670624
14:18:57 6465 8192000000 10720758400 11144814592 1760198272 17.686 95 30 58 5 1775033648 6474624 8360752
14:19:12 7495 8192000000 10733966688 11156889600 1770937808 17.775 97 18 36 0 1786268000 9899168 5431024
14:19:26 8439 8192000000 10724584512 11151446016 1782506304 17.870 98 30 60 0 1797864976 6763248 8595424
14:19:40 8884 8192000000 10711705616 11128020992 1746759888 17.575 96 22 44 2 1758368816 5290224 6318704
14:19:56 4213 8192000000 10744404032 11163492352 1810504016 18.100 99 34 68 3 1827506432 7544096 9458320
14:20:08 6039 8192000000 10687539952 11103424512 1730583296 17.440 96 34 68 2 1746213248 4735952 10894000
14:20:20 11170 8192000000 10718592432 11133812736 1750241248 17.604 97 18 36 1 1761347520 5592352 5513920
14:20:38 9451 8192000000 10681308960 11101057024 1713660624 17.299 95 22 44 0 1725361680 5592304 6108752
14:20:54 7698 8192000000 10677925904 11095232512 1703479744 17.214 95 15 30 0 1712908560 4917856 4510960
14:21:08 12414 8192000000 10669521104 11077197824 1680140992 17.019 95 23 46 2 1692116032 5566208 6408832
14:21:26 9892 8192000000 10706033088 11118587904 1780086976 17.850 100 31 61 1 1794736944 5205664 9444304
14:21:43 61118 8192000000 10708268688 11133743104 1770172736 17.768 98 27 55 1 1784428640 5167200 9088704
14:22:50 16129 8192000000 10740254688 11156312064 1803187312 18.040 99 34 68 1 1819114928 6993472 8934144
14:23:17 6175 8192000000 10748640720 11164594176 1812933232 18.120 99 38 76 1 1829045984 6114496 9998256
14:23:31 5142 8192000000 10737530336 11160752128 1810406096 18.099 99 31 60 2 1825440432 6440064 8594272
14:23:43 5855 8192000000 10765175568 11177410560 1833768992 18.290 100 34 67 1 1850396608 6964880 9662736
14:23:56 8901 8192000000 10759544176 11180236800 1839125600 18.334 100 23 46 0 1850782128 5222800 6433728
14:24:13 10942 8192000000 10754860800 11184451584 1843746272 18.371 100 28 55 1 1857648032 5799616 8102144
14:24:30 11907 8192000000 10753539936 11183693824 1846963984 18.397 100 21 41 3 1859445408 5638416 6843008
14:24:48 5296 8192000000 10762387088 11187675136 1851080528 18.431 100 26 52 1 1864019152 4865008 8073616
14:25:00 5616 8192000000 10769226624 11192049664 1849403584 18.417 100 19 39 1 1860676528 5801536 5471408
14:25:12 15763 8192000000 10764567200 11194011648 1850979264 18.430 100 14 28 1 1860559472 5293840 4286368
14:25:34 10868 8192000000 10765779664 11199361024 1856281632 18.473 100 19 38 0 1867606304 5731120 5593552
14:25:54 10804 8192000000 10771930592 11198763008 1857757616 18.485 100 23 46 1 1870204064 5733744 6712704
14:26:12 17413 8192000000 10766936160 11199684608 1856809024 18.477 100 11 20 1 1864764016 5079616 2875376
14:26:36 59738 8192000000 10797393264 11216457728 1865155536 18.545 100 20 42 0 1875075648 4437392 5482720
14:27:47 84385 8192000000 10823520736 11250475008 1898749504 18.816 100 38 76 0 1917145824 7883648 10512672
14:29:33 10826 8192000000 10847285632 11266531328 1915441552 18.950 100 35 70 2 1933220112 7553216 10225344
14:29:51 23861 8192000000 10847610048 11276787712 1926712752 19.041 100 42 84 0 1948444992 9397584 12334656
14:30:31 26924 8192000000 10877588656 11302346752 1937247280 19.125 100 37 74 4 1962233744 13953120 11033344
14:31:06 19345 8192000000 10882624080 11310907392 1948230000 19.212 100 46 92 2 1974266464 12126736 13909728
14:31:35 22059 8192000000 10877783392 11313451008 1951216064 19.236 100 36 72 1 1972267184 10358384 10692736
14:32:07 18438 8192000000 10884600384 11317399552 1958152240 19.291 100 41 82 0 1980666192 10717232 11796720
14:32:33 9745 8192000000 10894298224 11322839040 1960628944 19.311 100 45 90 2 1986085200 12439456 13016800
14:32:51 30288 8192000000 10896377920 11328696320 1962296576 19.324 100 53 106 2 1996471872 18683840 15491456
14:33:39 11135 8192000000 10912565904 11338063872 1968327312 19.372 100 51 102 3 1996692784 14117712 14247760
14:33:59 15724 8192000000 10907737952 11337646080 1971655504 19.399 100 51 102 1 2002205680 14979248 15570928
14:34:29 6667 8192000000 10914366848 11344830464 1977479200 19.445 100 52 104 0 2006794976 14308672 15007104
14:34:42 4958 8192000000 10901372304 11325067264 1958992272 19.298 99 56 108 2 1989977808 15189728 15795808
14:34:54 4476 8192000000 10920371088 11344711680 1976522976 19.437 100 67 131 1 2012748960 16378272 19847712
14:35:07 3660 8192000000 10931302784 11350310912 1980180176 19.466 100 66 132 0 2017683648 18077952 19425520
14:35:18 13879 8192000000 10919741312 11345108992 1954556304 19.263 99 60 120 2 1990528144 18646608 17325232
14:35:42 2965 8192000000 10918281792 11344363520 1969843088 19.384 100 62 124 1 2007185696 19078720 18263888
14:35:54 10284 8192000000 10911985744 11337441280 1965323232 19.348 100 59 118 3 2002028320 18905280 17799808
14:36:20 11066 8192000000 10931756864 11356180480 1981080672 19.473 100 60 119 2 2020666560 21106752 18479136
14:36:42 6624 8192000000 10940273360 11367366656 1986877712 19.519 100 62 122 0 2027966928 22699504 18389712
14:37:02 5863 8192000000 10947381824 11373031424 1993154416 19.569 100 62 124 2 2037256272 25016112 19085744
14:37:19 4554 8192000000 10939102560 11358916608 1972754560 19.407 99 48 92 2 2012148208 24958192 14435456
14:37:33 2822 8192000000 10947336176 11373510656 1992153056 19.561 100 67 131 2 2038163376 26271584 19738736
14:37:46 4556 8192000000 10954773584 11381104640 1993842784 19.574 100 70 138 0 2042547504 27724560 20980160
14:37:59 9229 8192000000 10955600592 11388026880 1996597360 19.596 100 55 110 0 2041306240 27607424 17101456
14:38:17 5525 8192000000 10964008240 11389689856 2001172592 19.632 100 63 123 1 2046909872 26718880 19018400
14:38:33 5293 8192000000 10952356816 11385368576 2000221728 19.624 100 52 103 0 2039639824 23296448 16121648
14:38:46 8307 8192000000 10956309936 11387621376 1983551680 19.493 99 57 114 1 2026389776 25378832 17459264
14:39:02 3942 8192000000 10971291472 11399700480 2004662352 19.659 100 68 133 0 2052169344 27151536 20355456
14:39:13 2499 8192000000 10961685392 11383570432 2000513680 19.627 100 82 163 4 2054069600 29044336 24511584
14:39:23 11801 8192000000 10952877024 11381366784 1990412640 19.547 100 76 152 3 2044914544 30784976 23716928
14:39:43 8296 8192000000 10949361440 11376791552 1983855568 19.495 100 67 133 2 2033712768 29568160 20289040
14:39:58 14258 8192000000 10957789296 11384401920 1991029168 19.552 100 59 117 0 2039115408 29760640 18325600
14:40:23 4831 8192000000 10953410384 11394736128 1993969040 19.575 100 52 104 1 2040420928 29927152 16524736
14:40:36 7903 8192000000 10949150304 11393171456 1992975536 19.567 100 45 90 3 2042510000 34771088 14763376
14:40:58 8161 8192000000 10975140016 11411492864 1999617744 19.620 100 51 100 2 2052548976 36691472 16239760
14:41:15 3856 8192000000 10971084096 11399426048 1989686528 19.541 99 69 133 0 2051281200 40475856 21118816
14:41:26 2326 8192000000 11000377136 11425484800 2015514992 19.745 100 85 169 3 2085276576 43791392 25970192
14:41:38 8929 8192000000 10991303584 11419897856 2004331456 19.657 100 74 148 3 2074955392 47207440 23416496
14:42:00 7133 8192000000 10993664592 11424186368 2012459552 19.721 100 72 145 0 2084921888 49085376 23376960
14:42:14 4937 8192000000 10988810656 11423879168 2011271488 19.712 100 63 126 1 2075793040 43522544 20999008
14:42:29 4305 8192000000 10998132848 11421675520 2010738064 19.707 100 86 172 2 2081774912 42546768 28490080
14:42:41 4629 8192000000 10978879952 11402727424 1968842576 19.376 98 72 144 0 2031632144 40273600 22515968
14:42:53 7535 8192000000 10971280224 11399331840 1989757904 19.542 100 75 149 1 2058092208 43610656 24723648
14:43:10 5692 8192000000 10977958000 11402842112 1991333328 19.554 100 70 140 0 2055042304 41758544 21950432
14:43:26 4748 8192000000 10989496624 11408183296 1984927568 19.504 99 82 164 2 2054255136 43670256 25657312
14:43:38 3190 8192000000 10969267504 11393519616 1988238528 19.530 100 87 174 2 2057694640 42222000 27234112
14:43:48 1678 8192000000 10979371216 11397120000 1988824192 19.535 100 81 163 0 2058606832 44453568 25329072
14:43:56 6069 8192000000 10963695152 11398299648 1973880208 19.416 99 70 140 2 2038790064 43011920 21897936
14:44:09 5691 8192000000 10956209824 11397922816 1988913728 19.535 100 57 114 1 2049224224 42347728 17962768
14:44:27 2601 8192000000 10943131408 11373846528 1943679824 19.176 98 60 119 0 2003823120 41340784 18802512
14:44:39 2138 8192000000 10928651568 11349188608 1934929520 19.106 98 78 155 2 1998948928 39449760 24569648
14:44:50 4334 8192000000 10965385520 11383087104 1976081248 19.434 100 82 163 0 2043687552 41982912 25623392
14:45:01 4871 8192000000 10975762720 11397664768 1985809808 19.511 100 72 143 0 2050733008 42766320 22156880
14:45:13 5982 8192000000 10946459184 11379687424 1971889616 19.400 100 59 118 2 2034089504 44129296 18070592
14:45:32 7574 8192000000 10930511904 11377131520 1954891232 19.265 99 38 76 0 2007240016 39693280 12655504
14:45:46 16800 8192000000 10914259584 11358371840 1934147344 19.100 98 38 76 0 1987247088 41247360 11852384
14:46:15 6641 8192000000 10939345408 11372011520 1959432656 19.302 100 39 78 0 2018456448 46376032 12647760
14:46:28 16679 8192000000 10913779472 11361132544 1924783568 19.025 98 38 76 1 1980431312 43125664 12522080
14:47:04 12096 8192000000 10909785280 11345620992 1893939584 18.778 97 37 76 2 1948687120 42347616 12399920
14:47:25 14400 8192000000 10894422144 11336269824 1920232688 18.989 99 30 60 1 1977508880 46627584 10648608
14:48:06 12357 8192000000 10900810224 11340431360 1923390032 19.014 99 38 76 0 1979735728 43298416 13047280
14:48:32 7263 8192000000 10891268512 11318419456 1907000144 18.883 99 39 78 3 1966597760 45997840 13599776
14:48:48 5401 8192000000 10919454016 11339640832 1925280080 19.029 100 71 142 0 1998171728 49699376 23192272
14:49:04 11878 8192000000 10909715760 11349946368 1930337568 19.070 100 44 87 1 2001839856 55862432 15639856
14:49:26 16205 8192000000 10863015920 11310166016 1856996560 18.479 97 29 58 1 1916698880 49022304 10680016
14:49:49 16785 8192000000 10855469232 11295936512 1857166688 18.480 98 33 66 1 1917356384 48888368 11301328
14:50:13 28223 8192000000 10857956864 11304595456 1897685936 18.808 100 21 42 2 1949499040 45178592 6634512
14:50:54 39532 8192000000 10879553984 11318595584 1912502528 18.927 100 34 68 1 1959913632 36277632 11133472
14:51:40 37916 8192000000 10827420928 11292905472 1836083744 18.309 97 17 34 2 1878871888 36880144 5908000
14:52:27 92620 8192000000 10808392928 11250974720 1781521280 17.862 94 16 32 1 1802224960 16735632 3968048
14:54:15 32230 8192000000 10817829392 11262996480 1859093584 18.496 98 16 31 3 1873764448 9562352 5108512
14:55:22 69192 8192000000 10871174736 11296464896 1897137008 18.803 100 31 62 0 1920548976 14295696 9116272
14:57:00 57599 8192000000 10849757744 11313471488 1906805456 18.881 100 15 30 4 1925359712 14556304 3997952
14:58:04 80263 8192000000 10870618400 11330703360 1933618240 19.096 100 14 28 1 1955857200 18322992 3915968
14:59:34 69874 8192000000 10881457008 11352281088 1938650032 19.136 100 4 8 1 1959350592 19881312 819248
15:00:50 118103 8192000000 10872657936 11335168000 1856637328 18.476 95 8 16 1 1868639264 10068000 1933936
15:02:54 65908 8192000000 10879829872 11335360512 1897936640 18.810 97 28 56 3 1920329152 14191728 8200784
15:04:08 67592 8192000000 10887411392 11350491136 1946933840 19.202 100 12 24 1 1968181312 17909520 3337952
15:05:41 78702 8192000000 10917778240 11356037120 1964636064 19.343 100 44 88 2 1986564944 8314544 13614336
15:07:11 20644 8192000000 10923753888 11365556224 1973079296 19.410 100 55 107 1 2000470896 12037152 15354448
15:07:39 52534 8192000000 10911394128 11383881728 1983085296 19.489 100 51 102 1 2015555856 18159984 14310576
15:08:46 70799 8192000000 10911707120 11361116160 1941408288 19.158 98 18 35 2 1955859488 9261696 5189504
15:10:09 57237 8192000000 10923826352 11390021632 1989382336 19.539 100 26 52 1 2012634944 15706720 7545888
15:11:13 40083 8192000000 10937646464 11397902336 1975997840 19.433 99 26 52 2 1995486928 11634528 7854560
15:12:07 78883 8192000000 10930508848 11416739840 1994599392 19.580 100 15 30 2 2020277248 20900384 4777472
15:13:32 32601 8192000000 10931675568 11407970304 2000677760 19.628 100 11 22 2 2027257472 23652320 2927392
15:14:11 44704 8192000000 10922720352 11396481024 1980968288 19.472 99 12 24 0 2000128448 15587232 3572928
15:15:13 26374 8192000000 10922166432 11399614464 1993332208 19.570 100 13 26 0 2014580288 17101504 4146576
15:15:46 16538 8192000000 10930403584 11405160448 1997679280 19.604 100 16 32 0 2022252000 19525232 5047488
15:16:09 2856 8192000000 10934006608 11400249344 1977958272 19.449 99 22 44 0 2005991472 20896288 7136912
15:16:20 36080 8192000000 10908926512 11390103552 1988338624 19.531 100 9 18 2 2002405600 11542640 2524336
15:17:02 40116 8192000000 10912352448 11394256896 1989959456 19.543 100 8 16 0 1999885088 7644448 2281184
15:17:49 49405 8192000000 10903509120 11392389120 1975539936 19.429 99 8 16 1 1987807280 9775952 2491392
15:18:46 84467 8192000000 10923803696 11387703296 1961189856 19.315 98 26 54 2 1978555344 9574992 7790496
15:20:17 39369 8192000000 10917683936 11400769536 1997397744 19.602 100 25 48 4 2015539344 11352736 6788864
15:21:13 52123 8192000000 10910882032 11396702208 2002426032 19.642 100 18 36 0 2015518672 8071104 5021536
15:22:17 41560 8192000000 10909684688 11404615680 1994645376 19.580 100 3 6 0 2003526016 8403360 477280
15:23:05 7961 8192000000 10911801536 11403108352 1998857120 19.614 100 4 7 0 2006934016 7504336 572560
15:23:39 47008 8192000000 10910591808 11370401792 1929944448 19.066 97 19 38 3 1942344784 7792992 4607344
15:24:37 71270 8192000000 10880236528 11345252352 1875441600 18.628 95 22 42 1 1893254576 12100240 5712736
15:25:54 56523 8192000000 10876976432 11344363520 1920669968 18.992 98 13 26 1 1938633744 14340672 3623104
15:27:05 33962 8192000000 10904292576 11373674496 1965886240 19.353 100 30 61 2 1985551824 11438624 8226960
15:27:46 33816 8192000000 10876183456 11355525120 1941270736 19.157 98 20 40 0 1957649280 10896928 5481616
15:28:26 65897 8192000000 10867013552 11348742144 1860506624 18.507 95 15 29 0 1878048784 13173040 4369120
15:29:40 49248 8192000000 10854211472 11316330496 1851108640 18.431 95 12 24 0 1861217600 6870176 3238784
15:30:37 45804 8192000000 10855337664 11322150912 1856332816 18.474 95 17 34 0 1870455904 9058400 5064688
15:31:31 48836 8192000000 10864428800 11325308928 1877809520 18.647 97 20 40 1 1897669584 13019792 6840272
15:32:29 61115 8192000000 10818213680 11279147008 1803755600 18.045 94 19 38 2 1820530016 11345488 5428928
15:33:37 35494 8192000000 10875377552 11316465664 1915507344 18.951 99 42 83 2 1938781232 11748400 11525488
15:34:31 84615 8192000000 10846910304 11320406016 1831663824 18.273 95 13 26 1 1850441600 14796832 3980944
15:36:05 32159 8192000000 10861557984 11306090496 1851607472 18.435 96 48 93 2 1876517328 10584960 14324896
15:36:50 33764 8192000000 10849196272 11304656896 1877175152 18.642 98 24 48 1 1898863168 14717088 6970928
15:37:40 70684 8192000000 10864840544 11328978944 1888192704 18.731 98 29 58 0 1907275456 11553248 7529504
15:38:57 73271 8192000000 10835081200 11299999744 1891991312 18.762 98 21 42 1 1910346848 12097328 6258208
15:40:31 64689 8192000000 10864420816 11325411328 1894207792 18.780 98 26 52 0 1910634912 9117328 7309792
15:42:09 45136 8192000000 10850303760 11326889984 1878668480 18.654 97 13 26 0 1894051440 11800016 3582944
15:43:06 28410 8192000000 10832255088 11297800192 1833708864 18.290 95 18 36 1 1854686784 15466336 5511584
15:43:57 72986 8192000000 10846342064 11324997632 1916233504 18.957 100 11 21 1 1934008240 14426144 3348592
15:45:16 61994 8192000000 10860542064 11337109504 1915297552 18.949 99 12 24 1 1933079600 14184704 3597344
15:46:27 64761 8192000000 10855444816 11329241088 1924676896 19.024 99 18 34 3 1945844352 15711808 5455648
15:49:34 80492 8192000000 10867397440 11340775424 1922255200 19.005 99 9 17 1 1933515600 9003712 2256688
15:51:00 30317 8192000000 10894933744 11347312640 1932801776 19.089 99 33 65 0 1949505632 7367152 9336704
15:51:43 18891 8192000000 10888979552 11350274048 1957226896 19.284 100 41 82 1 1978175680 8973520 11975264
15:52:13 30656 8192000000 10904282144 11371466752 1960992176 19.314 100 23 46 0 1975838240 8854592 5991472
15:52:50 34211 8192000000 10904272384 11364872192 1950936992 19.234 99 23 46 1 1968380544 11128896 6314656
15:53:58 84504 8192000000 10868189488 11330478080 1895362400 18.789 97 18 37 2 1913223856 12820896 5040560
15:55:30 32488 8192000000 10905273328 11364073472 1960396912 19.309 100 38 76 1 1984816560 13598704 10820944
15:56:09 79120 8192000000 10918174656 11387281408 1967795232 19.368 100 25 50 2 1988562512 13732304 7034976
15:57:39 165420 8192000000 10940744512 11408699392 1974296976 19.420 99 13 26 1 1992348128 14723840 3327312
16:00:31 70424 8192000000 10931402224 11396358144 1969384896 19.381 98 28 56 2 1987286592 10027504 7874192
16:01:49 36542 8192000000 10932554624 11409395712 1999487488 19.619 100 19 38 0 2014201152 9123280 5590384
16:02:32 32946 8192000000 10946107920 11401179136 1966620720 19.359 98 32 62 1 1984303120 8958192 8724208
16:03:13 84004 8192000000 10920018304 11392503808 1997959936 19.607 100 35 70 0 2016492048 9022672 9509440
16:04:58 106131 8192000000 10898358800 11371532288 1893015104 18.770 95 23 46 0 1910513024 10754240 6743680
16:07:25 76496 8192000000 10889025552 11368914944 1948007792 19.211 98 10 20 0 1968866320 17929504 2929024
16:08:47 60981 8192000000 10914025712 11394019328 1985181872 19.506 100 11 22 3 1999781440 11427728 3171840
16:09:57 65640 8192000000 10914333104 11397083136 1988331296 19.531 100 16 32 1 2006771712 13560608 4879808
16:11:11 63201 8192000000 10907101584 11398479872 1967613600 19.367 99 13 25 1 1987666480 15819056 4233824
16:12:21 47145 8192000000 10885211472 11365011456 1923852080 19.018 97 17 35 1 1937531472 8931568 4747824
16:13:18 59250 8192000000 10887188464 11354722304 1914934896 18.946 97 23 46 0 1931958240 9900896 7122448
16:14:24 47462 8192000000 10816522576 11279589376 1837040400 18.317 93 19 38 2 1852687952 10104320 5543232
16:15:18 58535 8192000000 10890633360 11345457152 1908783680 18.897 98 25 50 0 1927986496 11395696 7807120
16:16:33 50882 8192000000 10836544656 11320119296 1855469600 18.467 96 11 22 1 1868968336 10029264 3469472
16:17:30 68799 8192000000 10862594720 11341930496 1894327760 18.781 98 14 28 2 1911526976 12889488 4309728
16:19:01 74618 8192000000 10878883488 11335626752 1882513376 18.685 97 22 44 1 1900247120 11381616 6352128
16:20:27 26749 8192000000 10868562256 11326464000 1908529280 18.895 98 31 62 1 1926882736 9319568 9033888
16:21:35 45850 8192000000 10863003664 11322052608 1865095808 18.545 96 30 58 4 1885331376 11726144 8509424
16:22:31 71468 8192000000 10861837984 11348905984 1911886144 18.922 99 17 34 1 1936394256 19697680 4810432
16:24:22 72234 8192000000 10857696512 11322372096 1859912416 18.503 96 21 42 0 1883238384 17748576 5577392
16:25:45 90153 8192000000 9641969328 9974575104 782564176 8.719 41 15 30 1 797137216 10613488 3959552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-12-2020 16:28:55 to 31-12-2020 16:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 161 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 31-12-2020 16:29:27 to 31-12-2020 16:29:28.

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          247114
MON$OLDEST_ACTIVE               247675
MON$OLDEST_SNAPSHOT             247675
MON$NEXT_TRANSACTION            247675
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                       2048288
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:154: 
:155: mscs-test-161.budzdorov.ru    Thu Dec 31 16:27:27 2020
:156:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:157: 
:158: 
:159: mscs-test-161.budzdorov.ru    Thu Dec 31 16:27:28 2020
:160:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:161: 
--- end of diff output ---

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

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