Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.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 17226688 kB
MemAvailable 31439772 kB
Buffers 0 kB
Cached 14431060 kB
SwapCached 2824 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.7
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-06 19:27:02
DTS_END                         2020-11-06 19:27:02.3670
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/38392
TRN_ID                          249116
ATT_ID                          713
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: 9644.35 20354 1157322
customer order: creation 183.51 343 22021
customer order: refuse 15.37 343 1844
order to supplier: creation 48.42 1201 5810
order to supplier: removal 3.40 113924 408
invoice (draft): creation 48.03 3154 5763
invoice (draft): removal 53.18 809 6382
invoice accept: apply 44.53 18484 5343
invoice accept: cancel 48.57 845 5828
customer reserve: creation 4121.38 182 494566
customer reserve: removal 4761.85 65 571422
realization accept: apply 88.33 183 10600
realization accept: cancel 88.91 109 10669
payment from customer: creation 63.38 131 7606
payment from customer: removal 5.99 90 719
payment to supplier: creation 52.19 135 6263
payment to supplier: removal 3.73 77 448
service: total inventory turnovers 5.23 951 627
service: total monetary turnovers 7.51 41 901
service: aggregate perf. data 0.82 21725 98
service: refresh index statistics 0.03 244280 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-11-2020 19:28:18 to 06-11-2020 19:28:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7699
TEST_TIME 2 6014
TEST_TIME 3 5698
TEST_TIME 4 5153
TEST_TIME 5 5340
TEST_TIME 6 5130
TEST_TIME 7 5113
TEST_TIME 8 5146
TEST_TIME 9 5255
TEST_TIME 10 5463
TEST_TIME 11 5860
TEST_TIME 12 6252
TEST_TIME 13 6716
TEST_TIME 14 6783
TEST_TIME 15 7124
TEST_TIME 16 7221
TEST_TIME 17 7349
TEST_TIME 18 7526
TEST_TIME 19 8168
TEST_TIME 20 8582
TEST_TIME 21 9131
TEST_TIME 22 9455
TEST_TIME 23 9542
TEST_TIME 24 9676
TEST_TIME 25 9947
TEST_TIME 26 9994
TEST_TIME 27 10669
TEST_TIME 28 11229
TEST_TIME 29 11951
TEST_TIME 30 11759
TEST_TIME 31 11537
TEST_TIME 32 11573
TEST_TIME 33 11461
TEST_TIME 34 11372
TEST_TIME 35 11349
TEST_TIME 36 11393
TEST_TIME 37 11358
TEST_TIME 38 11219
TEST_TIME 39 10999
TEST_TIME 40 10819
TEST_TIME 41 10644
TEST_TIME 42 10701
TEST_TIME 43 10667
TEST_TIME 44 10660
TEST_TIME 45 10606
TEST_TIME 46 10518
TEST_TIME 47 10418
TEST_TIME 48 10283
TEST_TIME 49 10224
TEST_TIME 50 10395
TEST_TIME 51 10392
TEST_TIME 52 10344
TEST_TIME 53 10285
TEST_TIME 54 10246
TEST_TIME 55 10229
TEST_TIME 56 10383
TEST_TIME 57 10378
TEST_TIME 58 10403
TEST_TIME 59 10383
TEST_TIME 60 10441
TEST_TIME 61 10490
TEST_TIME 62 10463
TEST_TIME 63 10445
TEST_TIME 64 10478
TEST_TIME 65 10527
TEST_TIME 66 10477
TEST_TIME 67 10336
TEST_TIME 68 10284
TEST_TIME 69 10212
TEST_TIME 70 10155
TEST_TIME 71 10171
TEST_TIME 72 10103
TEST_TIME 73 10091
TEST_TIME 74 10072
TEST_TIME 75 10126
TEST_TIME 76 10199
TEST_TIME 77 10147
TEST_TIME 78 10089
TEST_TIME 79 10192
TEST_TIME 80 10263
TEST_TIME 81 10297
TEST_TIME 82 10243
TEST_TIME 83 10308
TEST_TIME 84 10301
TEST_TIME 85 10290
TEST_TIME 86 10242
TEST_TIME 87 10170
TEST_TIME 88 10116
TEST_TIME 89 10096
TEST_TIME 90 10073
TEST_TIME 91 10008
TEST_TIME 92 9973
TEST_TIME 93 9996
TEST_TIME 94 9970
TEST_TIME 95 9970
TEST_TIME 96 9922
TEST_TIME 97 9958
TEST_TIME 98 10010
TEST_TIME 99 9995
TEST_TIME 100 10035
TEST_TIME 101 10005
TEST_TIME 102 10051
TEST_TIME 103 10043
TEST_TIME 104 9997
TEST_TIME 105 10047
TEST_TIME 106 10048
TEST_TIME 107 10028
TEST_TIME 108 9971
TEST_TIME 109 9966
TEST_TIME 110 9896
TEST_TIME 111 9918
TEST_TIME 112 9879
TEST_TIME 113 9831
TEST_TIME 114 9785
TEST_TIME 115 9737
TEST_TIME 116 9781
TEST_TIME 117 9758
TEST_TIME 118 9748
TEST_TIME 119 9731
TEST_TIME 120 9651

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-11-2020 19:28:21 to 06-11-2020 19:28:25.

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 1614984 1614984 0 0.00 0 28393 6 0 0
doc_list_biud 1614979 1614979 0 0.00 0 55522 28 0 0
sp_add_invoice_to_stock 5479 5343 136 2.48 24 259669 18485 0 136
sp_cancel_adding_invoice 5828 5828 0 0.00 6 73867 846 0 0
sp_cancel_client_order 1844 1844 0 0.00 5 10698 344 0 0
sp_cancel_customer_reserve 571422 571422 0 0.00 1 31716 65 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 2 8839 90 0 0
sp_cancel_pay_to_supplier 448 448 0 0.00 3 2659 78 0 0
sp_cancel_supplier_invoice 6398 6382 16 0.25 2 55531 809 0 16
sp_cancel_supplier_order 408 408 0 0.00 10 1182946 113924 0 0
sp_cancel_write_off 10669 10669 0 0.00 1 8353 110 0 0
sp_client_order 22021 22021 0 0.00 3 23891 343 0 0
sp_customer_reserve 494566 494566 0 0.00 0 122353 182 0 0
sp_fill_shopping_cart 33590 33590 0 0.00 1 15573 34 0 0
sp_fill_shopping_cart_clo_res 494555 494555 0 0.00 0 20860 14 0 0
sp_get_clo_for_invoice 5328 5328 0 0.00 0 30015 278 0 0
sp_kill_cost_storno 17664 17664 0 0.00 0 6631 55 0 0
sp_kill_qstorno_ret_qs2qd 1160303 1160303 0 0.00 0 55519 35 0 0
sp_kill_qty_storno 612481 612481 0 0.00 0 55521 74 0 0
sp_lock_selected_doc 21995 21995 0 0.00 0 9958 7 0 0
sp_make_cost_storno 29797 29797 0 0.00 0 28388 49 0 0
sp_multiply_rows_for_pdistr 29797 29797 0 0.00 0 8388 29 0 0
sp_multiply_rows_for_qdistr 22021 22021 0 0.00 0 12031 162 0 0
sp_pay_from_customer 7606 7606 0 0.00 4 28398 132 0 0
sp_pay_to_supplier 6263 6263 0 0.00 5 25492 135 0 0
sp_payment_common 13869 13869 0 0.00 1 15097 26 0 0
sp_qd_handle_on_cancel_clo 1844 1844 0 0.00 0 10688 308 0 0
sp_qd_handle_on_invoice_upd_sts 11156 11156 0 0.00 0 23169 310 0 0
sp_qd_handle_on_reserve_upd_sts 10600 10600 0 0.00 0 19630 56 0 0
sp_reserve_write_off 10600 10600 0 0.00 7 19650 183 0 0
sp_supplier_invoice 5763 5763 0 0.00 7 83422 3155 0 0
sp_supplier_order 5810 5810 0 0.00 5 59499 1201 0 0
srv_aggregate_perf_data 98 98 0 0.00 2890 195518 21726 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1440 253041 29783 0 0
srv_find_qd_qs_mism 1106218 1106218 0 0.00 0 17928 6 0 0
srv_make_invnt_saldo 627 627 0 0.00 30 35412 952 0 0
srv_make_money_saldo 901 901 0 0.00 1 16628 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 171145 334325 244280 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5343 5343 0 0.00 0 10507 156 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 4736 100 0 0
t$perf-norm:sp_cancel_client_order 1844 1844 0 0.00 0 2673 13 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 1359 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 7407 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 448 448 0 0.00 0 5799 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 561 8 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 25168 1458 0 0
t$perf-norm:sp_cancel_write_off 1091 1091 0 0.00 0 1746 9 0 0
t$perf-norm:sp_client_order 22021 22021 0 0.00 0 7259 17 0 0
t$perf-norm:sp_customer_reserve 1017 1017 0 0.00 0 1564 8 0 0
t$perf-norm:sp_pay_from_customer 7606 7606 0 0.00 0 24033 11 0 0
t$perf-norm:sp_pay_to_supplier 6263 6263 0 0.00 0 3469 7 0 0
t$perf-norm:sp_reserve_write_off 10600 10600 0 0.00 0 3838 8 0 0
t$perf-norm:sp_supplier_invoice 5763 5763 0 0.00 0 16749 19 0 0
t$perf-norm:sp_supplier_order 5810 5810 0 0.00 0 3193 13 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 291 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 703 9 0 0
t$perf-norm:srv_make_invnt_saldo 627 627 0 0.00 0 1243 24 0 0
t$perf-norm:srv_make_money_saldo 901 901 0 0.00 0 1435 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10928 10656 272 2.48 0 21755 22 0 272
v_all_customers 40332 40332 0 0.00 0 21 1 0 0
v_all_suppliers 32174 32174 0 0.00 0 19 1 0 0
v_all_wares 44042 44042 0 0.00 0 108 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 1136 8 0 0
v_cancel_client_order 3688 3688 0 0.00 0 5964 6 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 2507 5 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 6839 15 0 0
v_cancel_payment_to_supplier 896 896 0 0.00 0 2639 15 0 0
v_cancel_supplier_invoice 838 806 32 3.81 0 2215 16 0 32
v_cancel_supplier_order 816 816 0 0.00 0 14784 35 0 0
v_cancel_write_off 2182 2182 0 0.00 0 6633 19 0 0
v_max_id_clo_ord 5809 5809 0 0.00 0 2194 2 0 0
v_max_id_clo_res 1017 1017 0 0.00 0 3679 15 0 0
v_max_id_ord_sup 5760 5760 0 0.00 0 3795 3 0 0
v_max_non_paid_invoice 1745 1745 0 0.00 0 489 2 0 0
v_max_non_paid_realizn 3902 3902 0 0.00 0 965 3 0 0
v_min_id_clo_ord 5809 5809 0 0.00 0 2674 5 0 0
v_min_id_clo_res 1017 1017 0 0.00 0 6886 27 0 0
v_min_id_ord_sup 5760 5760 0 0.00 0 7482 8 0 0
v_min_non_paid_invoice 6263 6263 0 0.00 0 9245 20 0 0
v_min_non_paid_realizn 7606 7606 0 0.00 0 7404 14 0 0
v_our_firm 11118 11118 0 0.00 0 16 1 0 0
v_reserve_write_off 21200 21200 0 0.00 0 17001 9 0 0
x_lock_depdocs_on_canc_invoice 11807 11807 0 0.00 0 30216 125 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 15560 387 0 0
x_make_qstorno_1000_1200 5810 5810 0 0.00 2 57292 1122 0 0
x_make_qstorno_1200_2000 5763 5763 0 0.00 3 83360 3036 0 0
x_make_qstorno_2100_3300 494566 494566 0 0.00 0 122352 166 0 0

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

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:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 19072 8192000000 10246199360 10551631872 899300784 9.891 71 51 107 0 917815728 2393728 16121216
16:57:39 47073 8192000000 10361934640 10678640640 1393610048 14.538 100 92 184 0 1428081488 4862224 29609216
16:58:34 24224 8192000000 10394327456 10714095616 1444099088 14.986 100 95 190 1 1482794640 7121504 31574048
16:59:09 24025 8192000000 10401978704 10730700800 1454585824 15.078 100 93 186 1 1493656336 8062032 31008480
16:59:59 27341 8192000000 10438607552 10771288064 1487303232 15.365 100 86 172 0 1523824848 8922352 27599264
17:00:34 20498 8192000000 10458396672 10791755776 1505964032 15.528 100 85 170 2 1543049456 9533600 27551824
17:01:03 13044 8192000000 10469890704 10808201216 1521230176 15.661 100 81 162 1 1557024096 10015040 25778880
17:01:25 16569 8192000000 10472424800 10818437120 1535647040 15.786 100 86 172 0 1573601296 10656928 27297328
17:01:48 17385 8192000000 10504677680 10854514688 1555754160 15.960 100 74 148 1 1589259792 10677936 22827696
17:02:14 12803 8192000000 10528490576 10882342912 1583240288 16.196 100 76 152 1 1617045616 10474944 23330384
17:02:36 11034 8192000000 10551090096 10912243712 1613014064 16.450 100 70 140 1 1644382592 10606352 20762176
17:02:54 13367 8192000000 10581836000 10943553536 1641154368 16.690 100 74 147 1 1673815392 10925344 21735680
17:03:18 12288 8192000000 10604252496 10966884352 1660159216 16.850 100 77 154 1 1694343360 12002848 22181296
17:03:41 8243 8192000000 10611518640 10977615872 1677034032 16.992 100 82 165 0 1713211856 11847552 24330272
17:03:58 7932 8192000000 10644751936 11009110016 1696470656 17.156 100 86 172 1 1733515760 12489168 24555936
17:04:13 8227 8192000000 10644923184 11015774208 1707433328 17.247 100 84 166 2 1744264864 13004288 23827248
17:04:29 4643 8192000000 10662810976 11033923584 1730108512 17.436 100 87 171 1 1767832400 12907728 24816160
17:04:42 7423 8192000000 10684970512 11060629504 1743810448 17.550 100 82 164 0 1780100448 12938448 23351552
17:04:56 3830 8192000000 10690906448 11066843136 1756568336 17.656 100 87 172 1 1792920224 12484608 23867280
17:05:09 4668 8192000000 10713365568 11089293312 1766348384 17.737 100 84 167 1 1803251056 13346512 23556160
17:05:21 3606 8192000000 10716264304 11095695360 1780949072 17.857 100 81 162 2 1816965216 13386480 22629664
17:05:31 3851 8192000000 10723852128 11103051776 1784994496 17.891 100 85 170 0 1823238784 14851344 23392944
17:05:42 4002 8192000000 10728382992 11108343808 1787589024 17.912 100 86 174 2 1826989968 15085440 24315504
17:05:52 3103 8192000000 10729510240 11109511168 1792880768 17.955 100 83 166 0 1829610352 13446368 23283216
17:06:02 3123 8192000000 10745824224 11127287808 1802961824 18.038 100 88 176 2 1842039968 13632752 25445392
17:06:12 7631 8192000000 10742725904 11130290176 1802811552 18.037 100 73 146 0 1835838736 13355424 19671760
17:06:27 3001 8192000000 10754953696 11139780608 1821131056 18.187 100 80 160 0 1856915936 13234112 22550768
17:06:36 3180 8192000000 10775389248 11158704128 1826665472 18.232 100 87 174 1 1864131376 13807952 23657952
17:06:46 2461 8192000000 10780306000 11166855168 1833035040 18.284 100 86 170 0 1870111808 13343808 23732960
17:06:55 1657 8192000000 10781307072 11169771520 1842122864 18.358 100 87 173 1 1880082272 13518384 24441024
17:07:03 1589 8192000000 10792222288 11178479616 1846974896 18.398 100 89 176 2 1884408224 13252656 24180672
17:07:11 1512 8192000000 10794040960 11178049536 1852134272 18.439 100 89 178 1 1890185504 13121296 24929936
17:07:19 1789 8192000000 10795937664 11186892800 1855299792 18.465 100 92 188 1 1894972592 13845120 25827680
17:07:27 1351 8192000000 10803559680 11191259136 1857783024 18.485 100 97 195 2 1899818736 14359472 27676240
17:07:35 1993 8192000000 10804777872 11192180736 1859385312 18.498 100 90 179 0 1898414848 13378704 25650832
17:07:43 2025 8192000000 10803844048 11196264448 1862121968 18.520 100 92 181 2 1901350496 13291184 25937344
17:07:52 19259 8192000000 10801529808 11198615552 1864364640 18.539 100 77 153 0 1898567424 13132560 21070224
17:08:18 4107 8192000000 10793030880 11201048576 1863949232 18.535 100 68 136 0 1895874704 12761648 19163824
17:08:32 4292 8192000000 10788666864 11194433536 1861496656 18.515 100 49 99 0 1884301344 8637664 14167024
17:08:43 2915 8192000000 10794664672 11202633728 1867307280 18.562 100 58 116 1 1893203472 10256480 15639712
17:08:53 3047 8192000000 10787849680 11199852544 1864996384 18.544 100 44 86 3 1885815520 8885136 11934000
17:09:03 7775 8192000000 10794389408 11203547136 1869786048 18.583 100 44 88 1 1889309936 6996304 12527584
17:09:18 6789 8192000000 10789951488 11213242368 1871723136 18.598 100 43 86 2 1897420848 13271856 12425856
17:09:32 3802 8192000000 10791440928 11210805248 1875216304 18.626 100 36 72 0 1894315568 8533504 10565760
17:09:43 7743 8192000000 10789146640 11211456512 1877693888 18.646 100 28 56 1 1893319232 7643216 7982128
17:09:59 5252 8192000000 10796701888 11215015936 1879258528 18.659 100 42 85 1 1897459024 6366928 11833568
17:10:13 3992 8192000000 10795221984 11215560704 1882840496 18.688 100 41 79 1 1902585056 8024400 11720160
17:10:23 7323 8192000000 10784851360 11214635008 1881292624 18.676 100 26 52 2 1895604864 6179920 8132320
17:10:37 8430 8192000000 10790050128 11219279872 1884203872 18.699 100 31 62 1 1900074688 6453648 9417168
17:10:54 8937 8192000000 10790764912 11224084480 1885760352 18.712 100 18 35 1 1897048304 5376160 5911792
17:11:09 10368 8192000000 10799780960 11232948224 1895059856 18.787 100 38 78 2 1912981344 7198128 10723360
17:11:26 52358 8192000000 10824854160 11241390080 1894575088 18.783 100 33 63 4 1909169248 5140336 9453824
17:12:25 10456 8192000000 10805955200 11239895040 1895394480 18.789 100 25 50 0 1909350688 7336576 6619632
17:12:42 7310 8192000000 10811003472 11239940096 1897202656 18.804 100 31 62 0 1913164976 7440672 8521648
17:12:58 7109 8192000000 10813772208 11241107456 1896667440 18.799 100 37 74 2 1915398832 8144528 10586864
17:13:14 3912 8192000000 10818128880 11246305280 1897181824 18.804 100 34 68 0 1913978832 7457520 9339488
17:13:27 4024 8192000000 10808577184 11244691456 1898206592 18.812 100 30 60 1 1913729008 7001584 8520832
17:13:40 5068 8192000000 10810030928 11245408256 1900136112 18.827 100 31 63 0 1916567376 6572640 9858624
17:13:52 3917 8192000000 10817963344 11248578560 1905394480 18.870 100 33 67 0 1921944944 6450464 10100000
17:14:02 6450 8192000000 10813567968 11250778112 1902915152 18.850 100 29 56 2 1918836880 5427376 10494352
17:14:19 4926 8192000000 10819518144 11250401280 1905900544 18.874 100 33 66 1 1922907056 6942112 10064400
17:14:32 5734 8192000000 10816161440 11246776320 1889164000 18.739 99 27 54 3 1903578384 6361152 8053232
17:14:45 8567 8192000000 10827909296 11257298944 1907492384 18.887 100 24 48 2 1920317328 6240368 6584576
17:15:00 5972 8192000000 10804678160 11236306944 1872932080 18.608 98 30 59 3 1886784464 5873968 7978416
17:15:12 5470 8192000000 10831294592 11251564544 1884527504 18.702 99 33 66 3 1900910768 7383104 9000160
17:15:23 11047 8192000000 10818430560 11255746560 1901822448 18.841 100 19 36 3 1912507296 5903792 4781056
17:15:41 17350 8192000000 10800880688 11231956992 1831974928 18.275 96 16 31 0 1843142672 6239408 4928336
17:16:06 66861 8192000000 10796164880 11233509376 1855786768 18.469 98 26 52 3 1868432096 4968176 7677152
17:17:20 8010 8192000000 10810088640 11245891584 1881134944 18.674 99 27 54 2 1896126848 7272400 7719504
17:17:37 5215 8192000000 10773896464 11198431232 1814617552 18.134 96 39 78 1 1833545920 7736656 11191712
17:17:48 5706 8192000000 10770468448 11185332224 1777209136 17.826 95 29 58 2 1790651136 5646480 7795520
17:18:05 6580 8192000000 10748153536 11171676160 1800373072 18.017 98 28 56 0 1818041664 9602160 8066432
17:18:20 7941 8192000000 10733754080 11161067520 1767384816 17.745 96 25 47 2 1779748560 5438928 6924816
17:18:36 6528 8192000000 10752623616 11168305152 1813391856 18.124 99 44 87 2 1832436400 5139056 13905488
17:18:52 8850 8192000000 10744771840 11160899584 1790082832 17.932 98 21 43 0 1802217168 5698016 6436320
17:19:10 5496 8192000000 10747105104 11171987456 1812409392 18.116 99 18 36 1 1823289280 5499216 5380672
17:19:22 8981 8192000000 10725669600 11146768384 1775742896 17.814 97 19 38 2 1787448368 5931840 5773632
17:19:40 7988 8192000000 10728261616 11143057408 1766093904 17.735 97 26 52 1 1779686368 5869792 7722672
17:19:54 9494 8192000000 10721085120 11137949696 1758450784 17.672 97 20 39 0 1769573824 4929984 6193056
17:20:12 10135 8192000000 10694844416 11108225024 1721975456 17.369 96 24 48 1 1734050656 4880608 7194592
17:20:32 25544 8192000000 10680574752 11098165248 1684565344 17.056 94 24 48 1 1696771168 5857424 6348400
17:21:17 22215 8192000000 10696155680 11087028224 1730002864 17.436 97 56 111 2 1750799392 5730224 15066304
17:21:47 11777 8192000000 10704574368 11121188864 1776009632 17.817 99 30 60 2 1792081008 7221840 8849536
17:22:05 8442 8192000000 10711027424 11126349824 1772613360 17.789 99 32 64 1 1789582016 7542320 9426336
17:22:20 2564 8192000000 10728919632 11130683392 1775742384 17.814 99 47 94 1 1801648512 11893184 14012944
17:22:29 5481 8192000000 10722334944 11130183680 1800464400 18.018 100 46 93 1 1821985664 8128128 13393136
17:22:40 5621 8192000000 10722656800 11139088384 1809266000 18.090 100 41 82 4 1828369664 6753872 12349792
17:22:54 5226 8192000000 10726729424 11144990720 1813068160 18.121 100 28 56 0 1827658608 6720128 7870320
17:23:05 6356 8192000000 10727804128 11155939328 1821574000 18.191 100 19 38 0 1833221888 6122272 5525616
17:23:20 8141 8192000000 10741061056 11161985024 1825683424 18.224 100 23 45 0 1838235632 5912928 6639280
17:23:34 7880 8192000000 10740598496 11166134272 1832611856 18.281 100 27 54 2 1846744992 6303712 7829424
17:23:48 7603 8192000000 10751819232 11175817216 1837441424 18.320 100 32 64 1 1853613936 7289760 8882752
17:24:02 9609 8192000000 10763931792 11179950080 1840827440 18.348 100 16 29 0 1850385824 4919920 4638464
17:24:17 7648 8192000000 10772075168 11186274304 1847619776 18.403 100 27 55 0 1861849520 6007824 8221920
17:24:35 9497 8192000000 10781585152 11190104064 1851506752 18.434 100 27 54 0 1864298656 5679728 7112176
17:24:54 12061 8192000000 10761943904 11191402496 1852996608 18.446 100 23 46 0 1866202192 5536576 7669008
17:25:12 7018 8192000000 10761921712 11197251584 1859343104 18.498 100 30 60 3 1874427008 5987024 9096880
17:25:27 73349 8192000000 10779430720 11200225280 1862541488 18.524 100 24 48 0 1875181120 4969504 7670128
17:26:47 13377 8192000000 10780245536 11205894144 1848963584 18.414 99 33 65 3 1868270768 10785552 8521632
17:27:10 27702 8192000000 10806509936 11222331392 1878239616 18.651 100 44 86 1 1896051696 5537136 12274944
17:27:44 16496 8192000000 10823747232 11242483712 1891311296 18.756 100 39 78 2 1909884896 7648992 10924608
17:28:10 10359 8192000000 10835551840 11251871744 1906604384 18.879 100 63 127 3 1933618912 9015888 17998640
17:28:30 6094 8192000000 10849743216 11262271488 1912673056 18.928 100 60 120 1 1939638368 9858384 17106928
17:28:44 19257 8192000000 10846056832 11267375104 1917372720 18.966 100 53 106 0 1943074000 11010784 14690496
17:29:13 29409 8192000000 10843753808 11270684672 1914706352 18.944 100 43 86 0 1937485152 10891440 11887360
17:29:54 11356 8192000000 10864657312 11285843968 1926126192 19.036 100 54 107 4 1954887056 13777536 14983328
17:30:14 26713 8192000000 10862586112 11294695424 1932031824 19.083 100 41 81 0 1961067440 17028112 12007504
17:30:48 6348 8192000000 10872754128 11298164736 1941793840 19.161 100 47 94 0 1972354624 16469696 14091088
17:31:13 25911 8192000000 10889688976 11316232192 1946300032 19.197 100 52 104 1 1982357632 20764320 15293280
17:31:49 12210 8192000000 10894269440 11322359808 1953928512 19.258 100 51 102 2 1992316128 22555648 15831968
17:32:08 21924 8192000000 10897231600 11322621952 1922152448 19.004 98 58 116 3 1962368208 23075696 17140064
17:32:44 14402 8192000000 10907200688 11333447680 1958559696 19.295 100 45 88 1 1995972864 23847392 13565776
17:33:07 10641 8192000000 10907596016 11337117696 1962194992 19.323 100 50 100 1 2000035392 22819424 15020976
17:33:42 14054 8192000000 10914898192 11347828736 1967136464 19.363 100 47 93 0 2009175984 28280048 13759472
17:34:07 11046 8192000000 10920195776 11352088576 1968996144 19.377 100 49 98 1 2013188048 28541824 15650080
17:34:26 8635 8192000000 10912232640 11347390464 1969492688 19.381 100 46 92 1 2010260592 25709312 15058592
17:34:47 17019 8192000000 10933487968 11358150656 1974925616 19.425 100 51 100 2 2015647456 25474688 15247152
17:35:19 9516 8192000000 10930682256 11364167680 1980244320 19.467 100 43 84 2 2019397104 26211024 12941760
17:35:37 5171 8192000000 10938553360 11367604224 1966412896 19.357 99 60 118 1 2014226176 30504816 17308464
17:35:51 3370 8192000000 10941188064 11364970496 1982505984 19.485 100 52 104 0 2025358160 27007072 15845104
17:36:01 10651 8192000000 10947435648 11377127424 1988721136 19.534 100 57 114 0 2033360512 27785040 16854336
17:36:23 7893 8192000000 10932216544 11358990336 1976644720 19.438 99 64 127 0 2025634736 29976944 19013072
17:36:40 3659 8192000000 10950851440 11378257920 1992009200 19.560 100 62 123 1 2039425280 28710752 18705328
17:36:53 6694 8192000000 10968211184 11389997056 2001999120 19.638 100 74 148 1 2057121056 32002800 23119136
17:37:07 8905 8192000000 10973017104 11395977216 2005540656 19.666 100 70 140 0 2058941104 32471968 20928480
17:37:24 7965 8192000000 10975998736 11401793536 2007619648 19.683 100 68 136 5 2061450688 33374816 20456224
17:37:41 1508 8192000000 10976080688 11403030528 2010206672 19.703 100 64 126 2 2062865488 33243568 19415248
17:37:51 5872 8192000000 10978323376 11403726848 2010207280 19.703 100 65 130 1 2063588448 33524752 19856416
17:38:13 6915 8192000000 10979458128 11410833408 2014867216 19.740 100 67 134 2 2071813792 36293808 20652768
17:38:29 1480 8192000000 10992344368 11402231808 2003458928 19.650 100 84 166 2 2066432128 36522656 26450544
17:38:37 1947 8192000000 10960828288 11371380736 1977889680 19.448 100 82 161 1 2039759616 37592208 24277728
17:38:46 1437 8192000000 10950194752 11366977536 1978376480 19.452 100 88 177 0 2040562304 35968160 26217664
17:38:55 5550 8192000000 10967706352 11382915072 1984108352 19.497 100 88 174 4 2048897392 38777648 26011392
17:39:08 5301 8192000000 10975570320 11391315968 1991991472 19.560 100 90 178 0 2060427936 41010352 27426112
17:39:20 2547 8192000000 10956128000 11373907968 1974621952 19.422 99 73 144 0 2039172464 42091248 22459264
17:39:29 5404 8192000000 10962654688 11376631808 1978947440 19.456 99 71 140 1 2041711632 41175088 21589104
17:39:42 6356 8192000000 10980488080 11402215424 2001555568 19.635 100 71 139 1 2065815488 42105792 22154128
17:39:57 3594 8192000000 10985148480 11402625024 1998392208 19.610 100 86 170 0 2068417696 43674304 26351184
17:40:07 3017 8192000000 10970731872 11391746048 1978684896 19.454 99 80 160 3 2046053216 42499536 24868784
17:40:18 6454 8192000000 10977137280 11399483392 1998334048 19.610 100 78 154 4 2065800976 42606592 24860336
17:40:31 3651 8192000000 10993915056 11408384000 2001657264 19.636 100 89 175 0 2073777888 45013024 27107600
17:40:43 1932 8192000000 10977355456 11401797632 1994798640 19.582 100 80 158 1 2064923920 45727184 24398096
17:40:53 10145 8192000000 10968392096 11397189632 1989425616 19.539 100 67 130 2 2052757504 43228080 20103808
17:41:12 4229 8192000000 10958876400 11381837824 1982028768 19.481 100 67 132 0 2043835856 41939856 19867232
17:41:24 2524 8192000000 10984792048 11395428352 1992167120 19.561 100 90 179 1 2064528496 45059952 27301424
17:41:33 10883 8192000000 10979779632 11400904704 1993319568 19.570 100 70 140 1 2061163840 46052288 21791984
17:41:51 2395 8192000000 10996456336 11413725184 2001954624 19.638 100 78 154 1 2074840688 48763696 24122368
17:41:59 1633 8192000000 10998230720 11414638592 1998934384 19.614 100 81 158 1 2075432176 51198704 25299088
17:42:10 9106 8192000000 10987747088 11410964480 1995815536 19.590 100 74 148 1 2071305152 52541120 22948496
17:42:35 3518 8192000000 10983213056 11405701120 1995843344 19.590 100 60 119 0 2064862528 49206656 19812528
17:42:48 8985 8192000000 10975827968 11403276288 1989532688 19.540 100 67 133 0 2061665712 50956208 21176816
17:43:06 3158 8192000000 10984088624 11409211392 1995062672 19.584 100 60 120 0 2067163216 53446896 18653648
17:43:16 7097 8192000000 10974641504 11397124096 1974794064 19.423 99 72 142 0 2048482640 51480048 22208528
17:43:29 6025 8192000000 10963793808 11387035648 1976000064 19.433 100 72 145 1 2049834656 50721904 23112688
17:43:46 1933 8192000000 10987603168 11401744384 1990109648 19.545 100 89 178 0 2069736512 51972960 27653904
17:43:56 2002 8192000000 10998821424 11410198528 1997076704 19.600 100 86 172 2 2078460768 54063072 27320992
17:44:05 2565 8192000000 10984192528 11391725568 1966021696 19.354 99 89 178 2 2049058464 54896352 28140416
17:44:14 2494 8192000000 10990855984 11397976064 1982876992 19.487 100 91 183 3 2067444960 56318640 28249328
17:44:24 3152 8192000000 10987088080 11402547200 1986538432 19.516 100 72 142 3 2064856992 55913568 22404992
17:44:38 2084 8192000000 10961255056 11389218816 1972232720 19.403 100 61 119 1 2049152192 56506416 20413056
17:44:55 2318 8192000000 10994961248 11406864384 1985599104 19.509 100 81 162 1 2069445888 57750608 26096176
17:45:06 2647 8192000000 10996892464 11411279872 1988730560 19.534 100 86 171 2 2077724752 61221184 27773008
17:45:16 3070 8192000000 11001961232 11415764992 1995778576 19.589 100 88 176 2 2088935024 63776448 29380000
17:45:26 2539 8192000000 11008069344 11420086272 2001563488 19.635 100 86 173 1 2091481408 61811136 28106784
17:45:36 1478 8192000000 11006614688 11423621120 1999756224 19.621 100 84 164 0 2088532640 61923360 26853056
17:45:47 3377 8192000000 10991240848 11409575936 1987982272 19.528 100 78 156 1 2076869296 63131728 25755296
17:45:58 1456 8192000000 11007930944 11421392896 1993516784 19.572 100 84 167 0 2085785616 65148592 27120240
17:46:05 8009 8192000000 10983873392 11404730368 1963574176 19.334 99 76 149 3 2055897184 67535296 24787712
17:46:21 7158 8192000000 10957902000 11382005760 1937794592 19.129 99 71 142 0 2033215904 71371648 24049664
17:46:35 5224 8192000000 10962175856 11396091904 1962968448 19.330 100 51 102 0 2049201264 68563968 17668848
17:46:47 11490 8192000000 10951030928 11397156864 1943271280 19.173 99 41 83 1 2023686784 65808528 14606976
17:47:09 2885 8192000000 10944189568 11369418752 1948318448 19.213 100 50 96 6 2022806224 58230672 16257104
17:47:19 4506 8192000000 10937635744 11368767488 1950182976 19.228 100 50 99 1 2019516064 53735840 15597248
17:47:36 2377 8192000000 10959902896 11380645888 1963160608 19.331 100 62 123 0 2038167536 55603792 19403136
17:47:49 5635 8192000000 10951366976 11382366208 1943585280 19.175 99 53 106 1 2021224576 60483296 17156000
17:48:00 9761 8192000000 10935669232 11370876928 1917486128 18.967 98 46 92 0 1996051520 62945552 15619840
17:48:18 8401 8192000000 10941409552 11379900416 1941539216 19.159 100 33 66 0 2020845664 68007584 11298864
17:48:33 10246 8192000000 10946792160 11383644160 1950136080 19.228 100 45 91 1 2030493648 65084176 15273392
17:48:53 14278 8192000000 10920092864 11366420480 1904728432 18.864 98 31 61 2 1976383328 61191728 10463168
17:49:14 9822 8192000000 10922373392 11365396480 1934581248 19.103 100 35 69 1 2007541200 61146880 11813072
17:49:30 13542 8192000000 10930902240 11378053120 1945550624 19.191 100 31 62 2 2014670864 58621488 10498752
17:49:56 9006 8192000000 10934019344 11379974144 1951543248 19.239 100 36 72 1 2014611632 51164992 11903392
17:50:15 4734 8192000000 10971040016 11393019904 1970475120 19.389 100 64 129 0 2042878144 52597632 19805392
17:50:29 1837 8192000000 10982609104 11391422464 1970554288 19.390 100 83 165 1 2052044896 56455728 25034880
17:50:37 12295 8192000000 10967555568 11402305536 1974677888 19.423 100 48 96 0 2052147840 62050016 15419936
17:51:38 23300 8192000000 10967036416 11412860928 1968081712 19.370 100 34 68 1 2036333888 56853088 11399088
17:52:14 26031 8192000000 10955094704 11415646208 1975366976 19.428 100 29 58 1 2044433536 59408448 9658112
17:52:48 15216 8192000000 10948425472 11403091968 1969507424 19.382 100 28 56 1 2038250896 59582432 9161040
17:53:11 18995 8192000000 10940723712 11392524288 1933305296 19.093 99 26 52 1 2004529120 62093216 9130608
17:53:36 13436 8192000000 10931906992 11392126976 1943818992 19.177 100 24 48 1 2017454912 64668080 8967840
17:54:22 12173 8192000000 10935205712 11389267968 1939551952 19.143 100 18 36 1 2018974960 72275536 7147472
17:54:41 16210 8192000000 10918748592 11374264320 1934660256 19.104 100 18 36 0 2005727888 63705104 7362528
17:55:04 35250 8192000000 10909648032 11362467840 1923294176 19.013 99 21 43 1 1972171088 42080224 6796688
17:55:46 27053 8192000000 10890927200 11352301568 1904953168 18.866 98 31 62 0 1949663616 35106640 9603808
17:56:21 40207 8192000000 10864605952 11335200768 1918985104 18.979 99 7 14 0 1935558320 13590112 2983104
17:57:10 71340 8192000000 10895478432 11344322560 1916100848 18.956 98 22 43 0 1930908144 9145744 5661552
17:58:30 35407 8192000000 10881619712 11337859072 1938402240 19.134 99 14 28 1 1951998592 9974928 3621424
17:59:13 108430 8192000000 10884141248 11351822336 1881605488 18.678 96 13 26 2 1897642144 12738912 3297744
18:01:21 40293 8192000000 10895741472 11356131328 1964121968 19.339 100 18 34 1 1979447376 10629680 4695728
18:02:30 125188 8192000000 10908833776 11385606144 1939887120 19.146 98 15 30 0 1961430528 17467056 4076352
18:04:45 148132 8192000000 10929916400 11380088832 1943296992 19.173 98 34 68 1 1971431440 18130512 10003936
18:07:20 57400 8192000000 10942751168 11395256320 1969403568 19.381 99 34 68 1 1996004448 17365920 9234960
18:08:27 30262 8192000000 10936143024 11400843264 1987776944 19.526 100 28 56 1 2019014720 23277168 7960608
18:10:26 29480 8192000000 10916525376 11382349824 1983551536 19.493 100 17 34 0 1997505776 8917680 5036560
18:11:20 12720 8192000000 10933286624 11388243968 1975570448 19.430 99 54 109 1 2000819168 7321712 17927008
18:11:44 25471 8192000000 10923734672 11378626560 1970914368 19.393 99 36 72 1 1992365216 11308064 10142784
18:12:22 14452 8192000000 10927428624 11372318720 1979318896 19.459 100 63 125 1 2003960752 8932096 15709760
18:12:49 25274 8192000000 10909864032 11374944256 1979774592 19.463 100 43 85 3 2001411520 8946432 12690496
18:13:29 253041 8192000000 10897837168 11369422848 1878936736 18.657 94 22 44 1 1898681344 13074720 6669888
18:17:57 87797 8192000000 10904550048 11389112320 1975111776 19.426 100 16 32 0 1992084848 12272704 4700368
18:19:34 57102 8192000000 10893796480 11366637568 1912927168 18.930 97 4 8 0 1921460832 7122304 1411360
18:20:39 40769 8192000000 10915503024 11381657600 1953951104 19.258 99 24 48 1 1968182816 7790976 6440736
18:21:27 33241 8192000000 10917865456 11384872960 1978015808 19.449 100 23 46 1 1997435040 13181184 6238048
18:22:11 56869 8192000000 10915138576 11394379776 1959342544 19.301 99 17 34 0 1979380368 14706368 5331456
18:23:17 79748 8192000000 10893959920 11376992256 1899136144 18.819 96 13 26 1 1912311360 9788560 3386656
18:24:53 29903 8192000000 10898515616 11358949376 1907304464 18.885 97 33 66 2 1924141504 7014896 9822144
18:25:33 43962 8192000000 10896096096 11364605952 1919629760 18.984 98 27 54 0 1941435136 14768800 7036576
18:26:31 56065 8192000000 10893972464 11347353600 1910936592 18.914 97 31 62 2 1929987184 10858608 8191984
18:27:38 52335 8192000000 10853118608 11320979456 1866159408 18.553 95 19 39 1 1881159168 9913296 5086464
18:28:38 69145 8192000000 10876477136 11336192000 1851940480 18.438 95 12 24 1 1862458096 7453968 3063648
18:29:53 47890 8192000000 10904321088 11354230784 1909625392 18.904 98 33 67 3 1929499024 10792176 9081456
18:30:47 27543 8192000000 10898264448 11346518016 1921616944 19.000 98 34 68 2 1944061584 13034096 9410544
18:31:26 54108 8192000000 10865242624 11344412672 1851289488 18.433 95 19 38 1 1873379520 16850608 5239424
18:32:26 43082 8192000000 10878674144 11329839104 1871251008 18.594 97 18 36 0 1883035520 6752080 5032432
18:33:15 39135 8192000000 10870458976 11326496768 1898198544 18.812 98 41 81 0 1919928464 10564000 11165920
18:34:01 90273 8192000000 10877899600 11347697664 1935116640 19.108 100 32 64 1 1954953584 11029232 8807712
18:35:38 57513 8192000000 10880919760 11352686592 1937327440 19.125 99 22 44 1 1958654112 15338864 5987808
18:36:55 68963 8192000000 10851731200 11324768256 1870243104 18.586 96 25 50 1 1891468688 13651584 7574000
18:38:11 55378 8192000000 10856272016 11329454080 1897414368 18.805 98 18 36 1 1919015616 16445184 5156064
18:39:24 75091 8192000000 10863540832 11343306752 1894442320 18.782 97 21 42 2 1915740864 14856544 6442000
18:40:49 87520 8192000000 10862873808 11329425408 1864663648 18.541 96 23 46 0 1891039280 19001824 7373808
18:42:57 84545 8192000000 10877393216 11351502848 1903489424 18.854 98 14 28 1 1919153488 11960416 3703648
18:44:54 22000 8192000000 10904091424 11345211392 1939827216 19.145 99 47 90 0 1966472480 12254944 14390320
18:45:22 38461 8192000000 10910910032 11369320448 1951962240 19.242 99 41 82 3 1981432608 17550912 11919456
18:46:13 52282 8192000000 10889335184 11361927168 1954062016 19.259 100 19 38 1 1977021968 17591936 5368016
18:47:11 74626 8192000000 10893033728 11359408128 1918385616 18.974 98 15 30 1 1934331776 11881920 4064240
18:48:36 49228 8192000000 10896676336 11358732288 1922685808 19.008 98 22 44 1 1936936560 8822752 5428000
18:49:41 39511 8192000000 10922579744 11378749440 1950825232 19.233 99 28 55 2 1976245968 18039840 7380896
18:50:27 90212 8192000000 10885630480 11361202176 1890178464 18.747 96 20 39 1 1912269920 16684944 5406512
18:52:05 18620 8192000000 10902241872 11358126080 1955797696 19.273 100 27 52 0 1970753408 7668352 7287360
18:52:30 18021 8192000000 10926930304 11378798592 1975089232 19.426 100 46 92 2 2001491472 13606416 12795824
18:53:00 129624 8192000000 10896954960 11369758720 1953091488 19.251 99 28 56 2 1974535120 13240800 8202832
18:55:21 46132 8192000000 10905662160 11370967040 1950967056 19.234 99 32 64 3 1969422352 9303728 9151568
18:56:14 26191 8192000000 10897816960 11363315712 1935093280 19.108 98 53 106 0 1962810496 12369360 15347856
18:57:02 87975 8192000000 10910635312 11391672320 1979130480 19.458 100 17 34 0 1999463440 15627088 4705872
18:58:36 28969 8192000000 10914317088 11394658304 1988759024 19.534 100 12 26 0 2007996256 15999824 3237408
18:59:11 23010 8192000000 10902137280 11389861888 1949516752 19.223 98 7 13 1 1969484304 18206272 1761280
18:59:45 15499 8192000000 10881799792 11367485440 1958382576 19.293 99 4 8 0 1973286880 14148656 755648
19:00:09 7330 8192000000 10891565792 11371769856 1945118512 19.188 99 9 18 0 1965659664 18178784 2362368
19:00:23 25692 8192000000 10898937104 11375755264 1967890224 19.369 100 10 20 0 1984038224 13089232 3058768
19:00:55 50537 8192000000 10905305232 11394310144 1975421408 19.428 100 12 24 0 1996585616 18363888 2800320
19:01:52 48322 8192000000 10927149200 11407896576 1961035712 19.314 99 18 34 0 1978200128 12500128 4664288
19:02:54 53249 8192000000 10935558336 11404038144 1979518528 19.461 99 23 46 1 2000241216 13000208 7722480
19:03:59 42906 8192000000 10924039856 11401801728 1975696368 19.431 99 20 40 0 1993229536 11894768 5638400
19:04:53 71979 8192000000 10880147648 11350417408 1882347360 18.684 95 14 29 1 1897749712 11134688 4267664
19:06:12 21008 8192000000 10898213040 11367305216 1963282336 19.332 100 26 50 2 1978383568 7444176 7657056
19:07:05 70353 8192000000 10902911904 11386052608 1943220080 19.172 98 17 34 1 1957922688 10171872 4530736
19:08:25 64086 8192000000 10908112784 11383881728 1940691024 19.152 98 13 26 0 1957050032 12640976 3718032
19:09:36 99512 8192000000 10896561424 11362402304 1857304128 18.481 94 13 26 0 1875812512 15226320 3282064
19:11:27 16368 8192000000 10906615936 11362881536 1960467392 19.310 100 36 71 1 1980512880 10305856 9739632
19:12:22 56326 8192000000 10880036256 11368882176 1939978432 19.147 99 31 62 0 1965926848 16442816 9505600
19:13:33 90491 8192000000 10873775888 11310505984 1749444624 17.597 90 14 28 1 1763558400 9642752 4471024
19:15:10 85352 8192000000 10878988144 11332214784 1931891664 19.082 100 45 90 1 1956449376 12200400 12357312
19:18:49 32245 8192000000 10839037664 11312066560 1889647536 18.743 98 10 20 2 1900328432 6998736 3682160
19:20:01 53202 8192000000 10841655600 11319644160 1904039104 18.859 99 7 14 0 1916596624 10587264 1970256
19:21:00 59818 8192000000 10849086624 11318231040 1876183712 18.634 97 14 28 1 1890288848 9833168 4271968
19:22:20 53406 8192000000 10826964096 11309043712 1906650352 18.880 99 17 35 1 1926419504 14538480 5230672
19:23:24 56987 8192000000 10822019392 11292524544 1849391136 18.417 97 12 24 0 1862380096 9037056 3951904
19:24:32 37961 8192000000 10824579888 11293900800 1878771008 18.655 98 19 39 1 1891422272 6975872 5675392
19:25:24 17093 8192000000 10862768336 11328258048 1933293264 19.093 100 38 76 0 1952523776 8509856 10720656
19:25:51 37608 8192000000 10886282512 11350339584 1926494560 19.039 99 27 54 0 1950787968 17031888 7261520
19:26:35 38935 8192000000 9191602096 9454493696 343137728 4.020 18 7 11 1 352181056 7145408 1897920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 06-11-2020 19:28:31 to 06-11-2020 19:29:04.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-11-2020 19:29:05 to 06-11-2020 19:29:07.

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          249106
MON$OLDEST_ACTIVE               249404
MON$OLDEST_SNAPSHOT             249404
MON$NEXT_TRANSACTION            249404
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                       2046560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:107: 
:108: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:16 2020
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:17 2020
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
:115: 
:116: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:20 2020
:117:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:118: 
:119: 
:120: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:26 2020
:121:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:122: 
:123: 
:124: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:28 2020
:125:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:126: 
:127: 
:128: mscs-test-161.budzdorov.ru    Fri Nov  6 19:27:28 2020
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
--- end of diff output ---

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

06.11.20 19:29:08. 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-06 19:29:10 No severe PSQL-related problems occured
06.11.20 19:29:12. End of report.