Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.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 16341628 kB
MemAvailable 31480068 kB
Buffers 0 kB
Cached 15369624 kB
SwapCached 4076 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-17 19:26:59
DTS_END                         2020-11-17 19:26:59.9320
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/42018
TRN_ID                          235763
ATT_ID                          715
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: 8899.89 25007 1067987
customer order: creation 168.14 369 20177
customer order: refuse 14.65 329 1758
order to supplier: creation 45.47 1293 5456
order to supplier: removal 3.16 104215 379
invoice (draft): creation 44.81 3633 5377
invoice (draft): removal 50.09 796 6011
invoice accept: apply 41.63 18819 4996
invoice accept: cancel 45.54 830 5465
customer reserve: creation 3784.78 189 454173
customer reserve: removal 4410.83 58 529300
realization accept: apply 82.80 176 9936
realization accept: cancel 81.93 116 9831
payment from customer: creation 58.17 111 6980
payment from customer: removal 5.53 80 663
payment to supplier: creation 47.06 152 5647
payment to supplier: removal 3.45 71 414
service: total inventory turnovers 4.59 1007 551
service: total monetary turnovers 6.41 28 769
service: aggregate perf. data 0.83 19178 100
service: refresh index statistics 0.03 348696 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-11-2020 19:28:19 to 17-11-2020 19:28:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1928
TEST_TIME 2 4519
TEST_TIME 3 4964
TEST_TIME 4 4401
TEST_TIME 5 5457
TEST_TIME 6 6611
TEST_TIME 7 6443
TEST_TIME 8 6185
TEST_TIME 9 6426
TEST_TIME 10 6609
TEST_TIME 11 6681
TEST_TIME 12 6464
TEST_TIME 13 6682
TEST_TIME 14 6781
TEST_TIME 15 6890
TEST_TIME 16 6940
TEST_TIME 17 7140
TEST_TIME 18 7691
TEST_TIME 19 8265
TEST_TIME 20 8113
TEST_TIME 21 8374
TEST_TIME 22 8836
TEST_TIME 23 8724
TEST_TIME 24 9151
TEST_TIME 25 9555
TEST_TIME 26 10059
TEST_TIME 27 10151
TEST_TIME 28 10014
TEST_TIME 29 10555
TEST_TIME 30 10522
TEST_TIME 31 10403
TEST_TIME 32 10309
TEST_TIME 33 10294
TEST_TIME 34 10270
TEST_TIME 35 10093
TEST_TIME 36 10062
TEST_TIME 37 10006
TEST_TIME 38 10029
TEST_TIME 39 9911
TEST_TIME 40 9883
TEST_TIME 41 9809
TEST_TIME 42 9690
TEST_TIME 43 9603
TEST_TIME 44 9601
TEST_TIME 45 9489
TEST_TIME 46 9418
TEST_TIME 47 9313
TEST_TIME 48 9230
TEST_TIME 49 9196
TEST_TIME 50 9188
TEST_TIME 51 9101
TEST_TIME 52 9191
TEST_TIME 53 9216
TEST_TIME 54 9198
TEST_TIME 55 9117
TEST_TIME 56 9236
TEST_TIME 57 9168
TEST_TIME 58 9194
TEST_TIME 59 9224
TEST_TIME 60 9258
TEST_TIME 61 9245
TEST_TIME 62 9342
TEST_TIME 63 9323
TEST_TIME 64 9407
TEST_TIME 65 9449
TEST_TIME 66 9479
TEST_TIME 67 9413
TEST_TIME 68 9308
TEST_TIME 69 9292
TEST_TIME 70 9212
TEST_TIME 71 9174
TEST_TIME 72 9177
TEST_TIME 73 9161
TEST_TIME 74 9107
TEST_TIME 75 9042
TEST_TIME 76 8957
TEST_TIME 77 8984
TEST_TIME 78 9029
TEST_TIME 79 9108
TEST_TIME 80 9089
TEST_TIME 81 9062
TEST_TIME 82 9160
TEST_TIME 83 9117
TEST_TIME 84 9120
TEST_TIME 85 9085
TEST_TIME 86 9203
TEST_TIME 87 9221
TEST_TIME 88 9237
TEST_TIME 89 9228
TEST_TIME 90 9186
TEST_TIME 91 9135
TEST_TIME 92 9089
TEST_TIME 93 9086
TEST_TIME 94 9035
TEST_TIME 95 8991
TEST_TIME 96 8938
TEST_TIME 97 9003
TEST_TIME 98 8989
TEST_TIME 99 9003
TEST_TIME 100 8984
TEST_TIME 101 9012
TEST_TIME 102 8993
TEST_TIME 103 9031
TEST_TIME 104 8994
TEST_TIME 105 9051
TEST_TIME 106 9117
TEST_TIME 107 9088
TEST_TIME 108 9079
TEST_TIME 109 9082
TEST_TIME 110 9071
TEST_TIME 111 9023
TEST_TIME 112 9032
TEST_TIME 113 9016
TEST_TIME 114 9002
TEST_TIME 115 8945
TEST_TIME 116 8947
TEST_TIME 117 8911
TEST_TIME 118 8924
TEST_TIME 119 8896
TEST_TIME 120 8942

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-11-2020 19:28:23 to 17-11-2020 19:28:26.

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 1487637 1487637 0 0.00 0 18856 6 0 0
doc_list_biud 1487637 1487637 0 0.00 0 69250 27 0 0
sp_add_invoice_to_stock 5122 4996 126 2.45 33 195699 18819 0 126
sp_cancel_adding_invoice 5465 5465 0 0.00 5 51456 830 0 0
sp_cancel_client_order 1758 1758 0 0.00 4 16511 330 0 0
sp_cancel_customer_reserve 529300 529300 0 0.00 1 24679 59 0 0
sp_cancel_pay_from_customer 663 663 0 0.00 3 5733 81 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 3 2194 71 0 0
sp_cancel_supplier_invoice 6025 6011 14 0.23 2 71600 796 0 14
sp_cancel_supplier_order 379 379 0 0.00 5 999206 104215 0 0
sp_cancel_write_off 9831 9831 0 0.00 1 16174 117 0 0
sp_client_order 20177 20177 0 0.00 3 17935 370 0 0
sp_customer_reserve 454173 454173 0 0.00 0 42418 189 0 0
sp_fill_shopping_cart 31000 31000 0 0.00 1 45160 41 0 0
sp_fill_shopping_cart_clo_res 454163 454163 0 0.00 0 20072 14 0 0
sp_get_clo_for_invoice 4984 4984 0 0.00 0 18826 280 0 0
sp_kill_cost_storno 16373 16373 0 0.00 0 15337 57 0 0
sp_kill_qstorno_ret_qs2qd 1074821 1074821 0 0.00 0 69248 32 0 0
sp_kill_qty_storno 567664 567664 0 0.00 0 69250 69 0 0
sp_lock_selected_doc 20588 20588 0 0.00 0 6637 4 0 0
sp_make_cost_storno 27547 27547 0 0.00 0 18156 50 0 0
sp_multiply_rows_for_pdistr 27547 27547 0 0.00 0 18841 34 0 0
sp_multiply_rows_for_qdistr 20177 20177 0 0.00 0 16552 163 0 0
sp_pay_from_customer 6980 6980 0 0.00 4 18180 112 0 0
sp_pay_to_supplier 5647 5647 0 0.00 4 18866 153 0 0
sp_payment_common 12627 12627 0 0.00 1 10985 30 0 0
sp_qd_handle_on_cancel_clo 1758 1758 0 0.00 0 16504 307 0 0
sp_qd_handle_on_invoice_upd_sts 10449 10449 0 0.00 0 27613 343 0 0
sp_qd_handle_on_reserve_upd_sts 9936 9936 0 0.00 0 12625 53 0 0
sp_reserve_write_off 9936 9936 0 0.00 6 18184 176 0 0
sp_supplier_invoice 5377 5377 0 0.00 6 110893 3634 0 0
sp_supplier_order 5456 5456 0 0.00 4 76244 1293 0 0
srv_aggregate_perf_data 100 100 0 0.00 2190 225549 19178 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 827 148803 31891 0 0
srv_find_qd_qs_mism 1020808 1020808 0 0.00 0 13347 6 0 0
srv_make_invnt_saldo 551 551 0 0.00 42 42627 1008 0 0
srv_make_money_saldo 769 769 0 0.00 1 5159 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 133805 638419 348696 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4996 4996 0 0.00 0 23303 216 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 1409 70 0 0
t$perf-norm:sp_cancel_client_order 1758 1758 0 0.00 0 13041 22 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 1066 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 663 663 0 0.00 0 967 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 5990 29 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 13078 55 0 0
t$perf-norm:sp_cancel_supplier_order 379 379 0 0.00 0 31956 1551 0 0
t$perf-norm:sp_cancel_write_off 970 970 0 0.00 0 2061 11 0 0
t$perf-norm:sp_client_order 20177 20177 0 0.00 0 30917 22 0 0
t$perf-norm:sp_customer_reserve 1019 1019 0 0.00 0 7145 25 0 0
t$perf-norm:sp_pay_from_customer 6980 6980 0 0.00 0 17669 16 0 0
t$perf-norm:sp_pay_to_supplier 5647 5647 0 0.00 0 8411 15 0 0
t$perf-norm:sp_reserve_write_off 9936 9936 0 0.00 0 9174 14 0 0
t$perf-norm:sp_supplier_invoice 5377 5377 0 0.00 0 4593 20 0 0
t$perf-norm:sp_supplier_order 5456 5456 0 0.00 0 28495 22 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 76 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 425 5 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 987 18 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 5956 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10220 9968 252 2.46 0 3299 18 0 252
v_all_customers 36792 36792 0 0.00 0 15 1 0 0
v_all_suppliers 29452 29452 0 0.00 0 18 1 0 0
v_all_wares 40354 40354 0 0.00 0 111 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1826 7 0 0
v_cancel_client_order 3516 3516 0 0.00 0 7071 6 0 0
v_cancel_customer_prepayment 1326 1326 0 0.00 0 2058 5 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 559 3 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 2187 9 0 0
v_cancel_supplier_invoice 830 802 28 3.37 0 809 14 0 28
v_cancel_supplier_order 758 758 0 0.00 0 1737 6 0 0
v_cancel_write_off 1940 1940 0 0.00 0 2570 18 0 0
v_max_id_clo_ord 5456 5456 0 0.00 0 363 1 0 0
v_max_id_clo_res 1019 1019 0 0.00 0 1990 15 0 0
v_max_id_ord_sup 5367 5367 0 0.00 0 3859 3 0 0
v_max_non_paid_invoice 1744 1744 0 0.00 0 249 2 0 0
v_max_non_paid_realizn 3639 3639 0 0.00 0 5049 6 0 0
v_min_id_clo_ord 5456 5456 0 0.00 0 3726 8 0 0
v_min_id_clo_res 1019 1019 0 0.00 0 1444 4 0 0
v_min_id_ord_sup 5367 5367 0 0.00 0 5504 6 0 0
v_min_non_paid_invoice 5647 5647 0 0.00 0 6384 18 0 0
v_min_non_paid_realizn 6980 6980 0 0.00 0 10983 19 0 0
v_our_firm 10244 10244 0 0.00 0 21 1 0 0
v_reserve_write_off 19870 19870 0 0.00 0 4549 6 0 0
x_lock_depdocs_on_canc_invoice 11075 11075 0 0.00 0 17430 130 0 0
x_lock_depdocs_on_canc_sup_ord 379 379 0 0.00 0 3213 343 0 0
x_make_qstorno_1000_1200 5456 5456 0 0.00 1 76229 1211 0 0
x_make_qstorno_1200_2000 5377 5377 0 0.00 3 110825 3481 0 0
x_make_qstorno_2100_3300 454173 454173 0 0.00 0 42417 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2020 19:28:27 to 17-11-2020 19:28:31.

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:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:09 16414 8192000000 10234411264 10545852416 880357280 9.703 69 54 108 0 901140832 2605296 18178256
16:57:35 32879 8192000000 10333676528 10649206784 1379571472 14.413 100 90 180 1 1414046672 5010656 29464544
16:58:22 29477 8192000000 10388828448 10712010752 1437879664 14.931 100 90 180 0 1473922464 6639856 29402944
16:59:03 27187 8192000000 10416185152 10745335808 1460575984 15.131 100 88 176 0 1497572144 7892160 29104000
16:59:44 22779 8192000000 10448502896 10779746304 1488052928 15.372 100 84 168 0 1523677632 8419840 27204864
17:00:17 12258 8192000000 10460573664 10794508288 1514573232 15.603 100 93 186 0 1553300160 9203136 29523792
17:00:46 10541 8192000000 10465057888 10804748288 1523855952 15.684 100 81 162 1 1559566912 9870608 25840352
17:01:10 20084 8192000000 10492418736 10835447808 1548587088 15.898 100 88 176 1 1586073264 10100128 27386048
17:01:39 20137 8192000000 10525681056 10876608512 1586091664 16.220 100 84 168 1 1622525840 10747376 25686800
17:02:08 11844 8192000000 10553803872 10905882624 1608522864 16.412 100 83 167 1 1645088496 11280624 25285008
17:02:31 16897 8192000000 10571733808 10930565120 1625031600 16.553 100 78 156 0 1659741440 11191760 23518080
17:02:56 13150 8192000000 10587842352 10949070848 1639567008 16.676 100 81 163 1 1676070704 11829760 24673936
17:03:19 7923 8192000000 10602600800 10966740992 1661415536 16.861 100 74 149 2 1695461280 11772576 22273168
17:03:36 6704 8192000000 10611398464 10981277696 1679223232 17.011 100 78 154 1 1714036448 12064992 22748224
17:03:51 8665 8192000000 10631030928 11002994688 1697796624 17.167 100 76 151 1 1731789888 11912400 22080864
17:04:07 6119 8192000000 10644271584 11019091968 1709208640 17.262 100 77 154 2 1743166592 11583040 22374912
17:04:21 5209 8192000000 10651025712 11027423232 1717444976 17.331 100 67 134 1 1747998208 11349648 19203584
17:04:36 5968 8192000000 10657690256 11040735232 1733150256 17.462 100 72 144 3 1766684000 12512160 21021584
17:04:52 4924 8192000000 10688425856 11064250368 1746694768 17.574 100 82 162 2 1783017968 12716624 23606576
17:05:03 7859 8192000000 10690427008 11071008768 1759140400 17.677 100 73 146 0 1792626976 12556896 20929680
17:05:23 8072 8192000000 10715910864 11094822912 1766438944 17.738 100 73 144 0 1798601008 12025520 20136544
17:05:39 3697 8192000000 10735397520 11115130880 1792805808 17.955 100 88 176 3 1830794496 13215040 24773648
17:05:52 6008 8192000000 10740452496 11122081792 1797542736 17.994 100 80 161 1 1832609152 12089872 22976544
17:06:05 4885 8192000000 10742361744 11134193664 1807318704 18.074 100 74 147 1 1839890768 12618432 19953632
17:06:17 2340 8192000000 10746113440 11134066688 1810782288 18.102 100 72 142 1 1843623216 12097936 20742992
17:06:26 2487 8192000000 10758718256 11143413760 1821923232 18.193 100 85 170 2 1857908672 11786192 24199248
17:06:36 2945 8192000000 10758269568 11149938688 1825007664 18.219 100 82 165 0 1860362000 13094816 22259520
17:06:46 3172 8192000000 10774586960 11158052864 1831984208 18.276 100 91 182 0 1871586064 14285728 25316128
17:06:57 2219 8192000000 10777068944 11159613440 1833600928 18.289 100 92 185 0 1872484496 13503824 25379744
17:07:05 1413 8192000000 10788471440 11171090432 1841155856 18.350 100 92 188 3 1881453520 14049488 26248176
17:07:13 2500 8192000000 10785233040 11169329152 1843049072 18.366 100 96 192 0 1884363248 14022928 27291248
17:07:22 2407 8192000000 10785092752 11170287616 1844596080 18.378 100 90 180 0 1887246640 17540400 25110160
17:07:31 2092 8192000000 10791553296 11178848256 1850625120 18.427 100 89 179 1 1887866496 13141072 24100304
17:07:40 2065 8192000000 10793262288 11180081152 1849386144 18.417 100 91 180 1 1889793536 13800448 26606944
17:07:48 1456 8192000000 10791979648 11180007424 1851012016 18.430 100 90 180 1 1891138272 14876128 25250128
17:07:56 1387 8192000000 10793960704 11181236224 1850956848 18.430 100 92 185 0 1891196688 13951200 26288640
17:08:03 2165 8192000000 10794008480 11184209920 1854260416 18.457 100 90 182 1 1892680672 12298832 26121424
17:08:13 2257 8192000000 10793419840 11186405376 1857920768 18.486 100 89 178 0 1895589600 13095440 24573392
17:08:21 2022 8192000000 10790931200 11185156096 1858204064 18.489 100 85 167 0 1895168992 13076928 23888000
17:08:30 1780 8192000000 10809737408 11196936192 1863962688 18.535 100 95 191 2 1904153824 13358800 26832336
17:08:38 10114 8192000000 10803986752 11195551744 1862577936 18.524 100 84 168 1 1899354576 13738352 23038288
17:08:55 1556 8192000000 10812958928 11200614400 1864101584 18.537 100 90 177 1 1903898624 14812160 24984880
17:09:03 1353 8192000000 10808066976 11199553536 1868238336 18.570 100 89 178 1 1907633104 13865008 25529760
17:09:10 10119 8192000000 10804206096 11199741952 1867304176 18.562 100 84 170 2 1902761936 11715808 23741952
17:09:27 2761 8192000000 10792916992 11195994112 1868662896 18.573 100 61 122 2 1895490272 9259872 17567504
17:09:37 5408 8192000000 10799841600 11202809856 1868938992 18.576 100 59 117 1 1894404608 8807104 16658512
17:09:52 2695 8192000000 10804543248 11207917568 1875462928 18.628 100 67 134 3 1903868512 8914592 19490992
17:10:02 6524 8192000000 10797036960 11206320128 1872141488 18.602 100 38 76 2 1890849136 7593824 11113824
17:10:15 6900 8192000000 10800081312 11213377536 1876376624 18.636 100 40 80 0 1896155344 7824736 11953984
17:10:28 8291 8192000000 10796993536 11215192064 1876534976 18.637 100 32 64 1 1893297248 7622048 9140224
17:10:44 3090 8192000000 10808026624 11219857408 1889266368 18.740 100 57 114 3 1913252384 7596480 16389536
17:10:54 6847 8192000000 10797524320 11223236608 1885381568 18.709 100 37 75 2 1905123088 8934288 10807232
17:11:07 6616 8192000000 10798835920 11223134208 1886796288 18.720 100 45 91 0 1908132144 8215360 13120496
17:11:21 3727 8192000000 10804740864 11223203840 1886278224 18.716 100 35 71 1 1902335488 5608416 10448848
17:11:32 5877 8192000000 10797284416 11220873216 1884568192 18.702 100 26 52 1 1898514416 6739584 7206640
17:11:44 5765 8192000000 10795880144 11223588864 1885463040 18.709 100 32 63 0 1900588576 6175024 8950512
17:11:56 17730 8192000000 10788676672 11224031232 1884269056 18.700 100 17 33 2 1895104192 5758256 5076880
17:12:20 42131 8192000000 10818138064 11237912576 1891617760 18.759 100 54 104 5 1914580224 6415440 16547024
17:13:12 8793 8192000000 10790867840 11230240768 1886666736 18.719 100 17 32 3 1897426016 6061536 4697744
17:13:29 3499 8192000000 10809911984 11238277120 1893066704 18.770 100 36 72 0 1910096976 6938064 10092208
17:13:40 5199 8192000000 10818059856 11244740608 1896346544 18.797 100 39 77 1 1914845408 7427104 11071760
17:13:52 3792 8192000000 10824183056 11247009792 1897037184 18.802 100 40 80 1 1916997632 8300016 11660432
17:14:02 6346 8192000000 10812443904 11241754624 1894778656 18.784 100 22 44 2 1907293824 6531104 5984064
17:14:14 8681 8192000000 10814843648 11242508288 1897263008 18.804 100 34 67 1 1914074672 6456912 10354752
17:14:29 6592 8192000000 10819847776 11245891584 1896274064 18.796 100 15 30 1 1906015840 5404784 4336992
17:14:45 6136 8192000000 10814294528 11248816128 1899847744 18.825 100 25 50 0 1918019456 11585376 6586336
17:14:58 5376 8192000000 10822579232 11252068352 1906394576 18.878 100 34 68 0 1923023328 6357808 10270944
17:15:09 7256 8192000000 10810767200 11244396544 1897755248 18.808 100 33 67 0 1914554528 7444288 9354992
17:15:23 9534 8192000000 10822366608 11253538816 1902212976 18.844 100 28 56 1 1916563504 6553456 7797072
17:15:39 4211 8192000000 10805811408 11247222784 1900582928 18.831 100 24 48 0 1913938160 6361024 6994208
17:15:52 6260 8192000000 10822739328 11249524736 1885993072 18.713 99 30 60 3 1901071808 6820576 8258160
17:16:08 10849 8192000000 10818781184 11250470912 1883189568 18.691 99 27 54 3 1897762896 6463376 8109952
17:16:27 8593 8192000000 10807108848 11239952384 1877160720 18.642 99 23 46 1 1890876336 7012416 6703200
17:16:42 5437 8192000000 10832067072 11249291264 1903079232 18.851 100 63 128 1 1927638096 4881440 19677424
17:16:55 58111 8192000000 10804887792 11239845888 1860675424 18.509 98 24 48 0 1873185216 4844480 7665312
17:18:02 8608 8192000000 10795684384 11223347200 1830238400 18.261 97 21 42 1 1841043168 5066704 5738064
17:18:18 5948 8192000000 10768072912 11192700928 1801924112 18.030 96 36 72 1 1818775856 6772752 10078992
17:18:33 4764 8192000000 10784937296 11201064960 1854716528 18.460 100 38 74 0 1871884288 5723680 11444080
17:18:45 7363 8192000000 10755951056 11168858112 1785187712 17.892 96 36 72 1 1802564608 5423216 11953680
17:18:59 8329 8192000000 10715421760 11133087744 1752489472 17.622 96 27 52 1 1767112048 6643696 7978880
17:19:17 2798 8192000000 10695772272 11098763264 1759353728 17.679 97 25 51 5 1772727408 4810496 8563184
17:19:28 6947 8192000000 10719658160 11128762368 1758015568 17.668 97 36 72 1 1778016512 9434640 10566304
17:19:43 7981 8192000000 10691835520 11107295232 1730661760 17.441 96 29 58 2 1745645456 5802688 9181008
17:19:57 11816 8192000000 10697739168 11111378944 1724939072 17.393 96 23 46 1 1736989328 5242112 6808144
17:20:16 6732 8192000000 10719878752 11137122304 1786891600 17.906 99 22 44 1 1799059040 5311264 6856176
17:20:31 10524 8192000000 10726518896 11141910528 1776913520 17.824 98 28 56 0 1790615184 5299728 8401936
17:20:48 10619 8192000000 10717641552 11134607360 1731860848 17.451 95 25 49 0 1743807872 4751008 7196016
17:21:08 13153 8192000000 10731918192 11155038208 1805715840 18.061 99 20 40 0 1817390864 5522448 6152576
17:21:29 66749 8192000000 10716134032 11143438336 1795097856 17.974 98 19 38 0 1805560576 5214320 5248400
17:22:44 5380 8192000000 10742184832 11162537984 1813514128 18.125 99 34 68 0 1830831728 7246592 10071008
17:22:57 8992 8192000000 10753944800 11170426880 1803561616 18.043 98 36 72 2 1819979936 6131616 10286704
17:23:14 6374 8192000000 10743256944 11160162304 1793521536 17.961 98 24 48 1 1807031856 6827488 6682832
17:23:28 5944 8192000000 10749995872 11165802496 1813257616 18.123 99 32 64 1 1829299376 7011360 9030400
17:23:41 8960 8192000000 10728712064 11142025216 1794161024 17.966 98 26 52 1 1806602704 4422048 8019632
17:23:59 9348 8192000000 10755320928 11176022016 1828684816 18.249 100 21 42 1 1840538544 5422768 6430960
17:24:14 7452 8192000000 10752967520 11180113920 1844856064 18.380 100 25 50 1 1858165472 6136992 7172416
17:24:33 9181 8192000000 10764791888 11194003456 1854264784 18.457 100 35 70 1 1870926320 6462000 10199536
17:24:48 9709 8192000000 10770863088 11199582208 1854856560 18.462 100 24 48 2 1867782608 6184096 6741952
17:25:04 6545 8192000000 10768869072 11198099456 1858064352 18.488 100 21 42 2 1869353536 4908960 6380224
17:25:17 8858 8192000000 10773344368 11200614400 1861920656 18.519 100 28 56 1 1875377872 5164048 8293168
17:25:37 10955 8192000000 10768535520 11200942080 1859019040 18.495 100 16 32 2 1873247360 9889568 4338752
17:25:57 6385 8192000000 10775723952 11205939200 1861558768 18.516 100 19 38 2 1872722736 5508608 5655360
17:26:16 15735 8192000000 10786551952 11211542528 1864539456 18.540 100 28 53 4 1878895584 5821776 8534352
17:26:39 94335 8192000000 10832373824 11240935424 1887378304 18.725 100 52 106 1 1909275616 6367216 15530096
17:28:20 3543 8192000000 10854479264 11258679296 1910213696 18.908 100 76 152 2 1941091344 8581296 22296352
17:28:33 7370 8192000000 10844950128 11262824448 1911090224 18.915 100 53 106 1 1935897344 10165168 14641952
17:28:47 3538 8192000000 10857106192 11267899392 1915746400 18.953 100 62 123 1 1943345968 10383296 17216272
17:28:58 15146 8192000000 10860579440 11274670080 1917124256 18.964 100 43 83 3 1937498928 9061488 11313184
17:29:22 7025 8192000000 10856934752 11280179200 1924522128 19.023 100 49 96 0 1947565248 9426112 13617008
17:29:37 24549 8192000000 10856341856 11285032960 1931431152 19.078 100 59 119 3 1957652672 9493280 16728240
17:30:20 28480 8192000000 10872194000 11296628736 1939772400 19.145 100 53 106 0 1965979984 11174032 15033552
17:30:56 8876 8192000000 10875692816 11302252544 1942812960 19.169 100 45 90 1 1968973840 12263776 13897104
17:31:15 9167 8192000000 10875249968 11309359104 1947426816 19.206 100 47 94 2 1974157216 12639088 14091312
17:31:31 9862 8192000000 10876598544 11309084672 1949239312 19.220 100 46 92 1 1975711472 12759472 13712688
17:31:49 29728 8192000000 10874613696 11317075968 1950399968 19.230 100 41 82 1 1976133408 13600528 12132912
17:32:27 5588 8192000000 10890129120 11312762880 1937553968 19.127 99 42 86 0 1960835952 11040480 12241504
17:32:40 2528 8192000000 10891188688 11320623104 1959090832 19.299 100 54 107 0 1983749328 9442592 15215904
17:32:51 4755 8192000000 10899644384 11326767104 1965642416 19.351 100 57 114 3 1991767024 10196144 15928464
17:33:04 5284 8192000000 10908193968 11327528960 1966730640 19.360 100 64 123 1 1994895312 10775360 17389312
17:33:18 11665 8192000000 10910818704 11337535488 1972788624 19.408 100 64 128 0 2002875008 10999312 19087072
17:33:38 11037 8192000000 10915748592 11346149376 1974429344 19.421 100 44 88 0 2000815808 14117936 12268528
17:33:57 6026 8192000000 10934319728 11359727616 1985360752 19.507 100 66 130 2 2023658656 20123824 18174080
17:34:13 3179 8192000000 10929570896 11356770304 1983716016 19.494 100 52 104 1 2014700368 16262704 14721648
17:34:24 22631 8192000000 10929576848 11353210880 1965597792 19.351 99 53 107 3 2000452512 19349568 15505152
17:34:56 25107 8192000000 10949941904 11377340416 1990350688 19.547 100 63 126 2 2031685024 23360016 17974320
17:35:28 4096 8192000000 10944329616 11380768768 1995799376 19.590 100 52 105 1 2035404352 24158464 15446512
17:35:40 10243 8192000000 10953086912 11380482048 1998771456 19.613 100 60 118 2 2040945120 24053696 18119968
17:35:57 5196 8192000000 10948904512 11377377280 1996050096 19.592 100 60 121 1 2039284816 25380128 17854592
17:36:10 7707 8192000000 10956350768 11382812672 2001415760 19.634 100 60 118 0 2042162896 23191088 17556048
17:36:29 10622 8192000000 10942773360 11372314624 1986998576 19.520 99 66 131 1 2027426576 21361248 19066752
17:36:47 9114 8192000000 10957933712 11379453952 1984449008 19.500 99 63 124 1 2023935360 21208640 18277712
17:37:07 4824 8192000000 10965257504 11387691008 2004328896 19.657 100 65 131 4 2047554432 24944768 18280768
17:37:22 8315 8192000000 10951789296 11379355648 1989632880 19.541 99 63 123 0 2034208128 25932656 18642592
17:37:44 1270 8192000000 10971213344 11386339328 2002992000 19.646 100 87 173 1 2054869504 25687520 26189984
17:37:52 5141 8192000000 10955115664 11376521216 1980539776 19.469 99 68 136 2 2027262496 26305584 20417136
17:38:06 5251 8192000000 10934615568 11359965184 1964838016 19.344 99 61 119 3 2008276560 25541808 17896736
17:38:20 14275 8192000000 10948436192 11370680320 1986086464 19.513 100 56 111 0 2029883856 27063968 16733424
17:38:42 14783 8192000000 10934226944 11360518144 1970398288 19.389 99 62 124 0 2019066784 29932224 18736272
17:39:08 11185 8192000000 10937403376 11369775104 1974837968 19.424 99 58 116 1 2026929216 34212320 17878928
17:39:27 4443 8192000000 10944519808 11374149632 1984975600 19.504 100 59 119 1 2033114960 29524432 18614928
17:39:39 4707 8192000000 10949256528 11372486656 1987965680 19.528 100 66 132 0 2038928880 29682112 21281088
17:39:51 4539 8192000000 10941194048 11362299904 1964406992 19.341 99 71 142 0 2013628880 28789696 20432192
17:40:02 4318 8192000000 10944207296 11360419840 1978960304 19.456 100 78 156 0 2033165376 30722656 23482416
17:40:18 6617 8192000000 10940748256 11365543936 1975913808 19.432 100 68 136 1 2028151024 31145728 21091488
17:40:34 2969 8192000000 10927070112 11343818752 1953196864 19.252 99 73 146 0 2007205664 31673824 22334976
17:40:44 2864 8192000000 10918987664 11339079680 1941968848 19.162 99 80 158 2 1996165920 29999200 24197872
17:40:55 5472 8192000000 10938189536 11353878528 1966031552 19.354 100 77 154 0 2020378672 30951712 23395408
17:41:09 3432 8192000000 10949189440 11368603648 1982892464 19.488 100 86 174 1 2041667504 31965776 26809264
17:41:20 4097 8192000000 10952016608 11358904320 1968592320 19.374 100 82 161 2 2025140816 32264480 24284016
17:41:35 4006 8192000000 10951479152 11364294656 1975114448 19.426 100 78 153 1 2032604400 33649440 23840512
17:41:47 6186 8192000000 10951714672 11366150144 1965672112 19.351 99 73 146 1 2023326528 34942480 22711936
17:42:02 2705 8192000000 10959406480 11378462720 1984165504 19.498 100 75 148 1 2041199968 33711232 23323232
17:42:11 3334 8192000000 10956749216 11375849472 1987868528 19.527 100 81 159 2 2046339280 33087136 25383616
17:42:26 7836 8192000000 10954673456 11371286528 1980542560 19.469 100 73 146 2 2039231680 35866864 22822256
17:42:42 5241 8192000000 10943940256 11358453760 1946920048 19.202 98 74 148 1 2008627024 38610512 23096464
17:42:56 2905 8192000000 10953209088 11369861120 1977700688 19.446 100 78 156 0 2041629568 39900320 24028560
17:43:06 4784 8192000000 10960453344 11370917888 1972556992 19.406 100 80 157 2 2038125632 40937376 24631264
17:43:19 2887 8192000000 10972116448 11381063680 1984379824 19.499 100 78 155 1 2049281552 41157376 23744352
17:43:30 2302 8192000000 10930922496 11338362880 1920470832 18.991 97 78 151 2 1984298432 39605024 24222576
17:43:42 4125 8192000000 10931087696 11345764352 1922965008 19.011 98 75 149 2 1986558016 39801232 23791776
17:43:56 6509 8192000000 10936519312 11358097408 1939766192 19.145 99 65 130 2 2003213120 42212992 21233936
17:44:10 2889 8192000000 10958265024 11364331520 1963537808 19.334 100 89 178 0 2030744208 39607136 27599264
17:44:20 4033 8192000000 10947220544 11360714752 1962762592 19.328 100 85 168 2 2029810992 40507936 26540464
17:44:31 4394 8192000000 10944317392 11365048320 1959643808 19.303 100 72 144 1 2024863024 42252368 22966848
17:44:47 4289 8192000000 10936479040 11357638656 1962300112 19.324 100 76 149 1 2026217728 40217024 23700592
17:45:01 2328 8192000000 10940338240 11356590080 1958377056 19.293 100 74 149 1 2021790784 39561856 23851872
17:45:14 3571 8192000000 10925935184 11338289152 1930373360 19.070 99 85 165 2 1997180880 40826192 25981328
17:45:25 3881 8192000000 10928907280 11337678848 1935448896 19.110 99 79 156 2 1999007664 39271104 24287664
17:45:40 4010 8192000000 10935136048 11350695936 1936500672 19.119 99 79 159 1 2000360640 39452256 24407712
17:46:05 12895 8192000000 10912211632 11343716352 1945159072 19.188 100 43 86 3 1992065440 32854304 14052064
17:46:26 13286 8192000000 10906610816 11341418496 1943426464 19.174 100 39 78 0 1991256480 35230352 12599664
17:46:48 11335 8192000000 10910774432 11344535552 1944480336 19.182 100 40 80 1 1994038768 36370272 13188160
17:47:20 5937 8192000000 10949204960 11374755840 1966831712 19.360 100 64 128 0 2029068192 41749536 20486944
17:47:45 8117 8192000000 10940653312 11373748224 1972593760 19.406 100 47 94 1 2022779344 35111536 15074048
17:48:18 13256 8192000000 10932161824 11365613568 1951398288 19.238 99 40 78 3 1998686448 34396000 12892160
17:48:39 8036 8192000000 10926626304 11371130880 1962550352 19.326 100 38 76 1 2013649936 38443600 12655984
17:48:56 13270 8192000000 10920203840 11365203968 1957127248 19.283 100 29 58 3 1999868400 32240640 10500512
17:49:19 5858 8192000000 10949633504 11372703744 1972743680 19.407 100 62 124 1 2023211040 31103440 19363920
17:49:34 5053 8192000000 10943408688 11363618816 1956665888 19.280 99 66 130 1 2014984928 36307504 22011536
17:49:47 4070 8192000000 10964301072 11375247360 1955541824 19.271 99 85 168 1 2022720784 41124560 26054400
17:49:59 12105 8192000000 10930509632 11373121536 1962488112 19.326 100 46 91 1 2021488704 43705760 15294832
17:50:29 24208 8192000000 10930148656 11380047872 1968261552 19.372 100 33 66 3 2016712672 37398352 11052768
17:51:00 21436 8192000000 10882736080 11354722304 1903901072 18.858 97 19 38 3 1944484032 34017680 6565280
17:51:28 23271 8192000000 10908052240 11367161856 1948156528 19.212 100 23 46 0 1993971088 38169984 7644576
17:52:37 32015 8192000000 10911295232 11369684992 1955582096 19.271 100 15 30 1 1993672880 33250096 4840688
17:53:22 40200 8192000000 10903811040 11369365504 1922108640 19.004 98 16 32 1 1960218384 33441696 4668048
17:54:09 46147 8192000000 10891599536 11353579520 1937476464 19.127 100 13 26 3 1976359168 34180944 4701760
17:55:02 8788 8192000000 10882064240 11329679360 1862448224 18.523 96 24 48 1 1907285776 36792864 8044688
17:55:18 33128 8192000000 10872284192 11318136832 1920237056 18.989 100 21 40 0 1963043008 36314224 6491728
17:55:57 23554 8192000000 10875337424 11319779328 1915283920 18.949 99 35 67 1 1933321104 8411568 9625616
17:56:27 827 8192000000 10898204912 11308597248 1921864272 19.002 99 89 181 1 1956847888 8409840 26573776
17:56:35 8047 8192000000 10870413648 11308646400 1925971104 19.035 100 47 95 2 1949972320 10987616 13013600
17:57:17 30866 8192000000 10878014736 11326976000 1939573152 19.143 100 25 50 4 1961324896 14582400 7169344
17:59:00 48770 8192000000 10861153200 11323273216 1889296480 18.740 97 12 24 0 1913012384 20238976 3476928
17:59:58 58351 8192000000 10857016032 11329150976 1918259024 18.973 99 8 16 0 1935619584 14722416 2638144
18:01:13 35802 8192000000 10876472496 11339960320 1940341360 19.149 100 34 66 0 1967196320 17463520 9391440
18:01:59 41154 8192000000 10878964336 11333689344 1931953040 19.082 99 24 46 0 1949264848 11264912 6046896
18:02:46 53237 8192000000 10893244928 11354124288 1955424544 19.270 100 26 51 2 1975650016 13156784 7068688
18:03:52 96753 8192000000 10904831776 11353530368 1946846048 19.201 99 21 42 0 1971298736 17415184 7037504
18:05:39 103961 8192000000 10906886944 11352518656 1943826240 19.177 99 28 54 2 1966143712 13907776 8409696
18:07:32 79639 8192000000 10879986480 11333197824 1928160784 19.052 98 24 48 0 1949649040 14312576 7175680
18:08:58 43349 8192000000 10863215072 11324116992 1918820480 18.977 98 20 40 1 1937262048 12577184 5864384
18:09:48 35786 8192000000 10870874752 11332321280 1950286528 19.229 100 27 52 0 1975997040 18297024 7413488
18:10:48 22381 8192000000 10895359440 11354292224 1967120208 19.363 100 36 72 1 1983688768 6523920 10044640
18:11:18 39876 8192000000 10901462784 11357229056 1956765904 19.280 99 34 66 0 1976308704 10169248 9373552
18:12:04 63033 8192000000 10878024848 11352330240 1934182128 19.100 98 16 32 0 1951556176 12481680 4892368
18:13:14 80606 8192000000 10903933664 11374866432 1968541296 19.374 100 11 22 1 1988524368 16632224 3350848
18:14:41 82345 8192000000 10899535680 11367665664 1959640832 19.303 99 20 40 0 1980122800 14742368 5739600
18:16:32 67570 8192000000 10899965712 11385069568 1977461024 19.445 100 12 24 2 1997695024 16316528 3917472
18:18:12 44633 8192000000 10905252064 11384115200 1984583040 19.501 100 12 23 1 2000440064 12035392 3821632
18:20:00 60819 8192000000 10896835936 11372961792 1938589776 19.136 98 10 20 0 1950755568 9088320 3077472
18:21:18 40260 8192000000 10915278256 11370553344 1946235344 19.196 98 28 56 0 1964762272 10429424 8097504
18:22:10 60032 8192000000 10892769888 11364347904 1922717952 19.009 97 20 40 2 1942491568 13990384 5783232
18:23:16 54448 8192000000 10902766160 11366105088 1934951120 19.106 98 14 28 2 1951572656 12193504 4428032
18:24:18 26237 8192000000 10933272240 11375484928 1958282816 19.292 99 42 84 1 1988148672 17795984 12069872
18:24:51 28757 8192000000 10931489344 11382534144 1982749920 19.486 100 49 98 2 2012535376 16172512 13612944
18:25:28 30850 8192000000 10918198720 11372068864 1944610896 19.184 98 45 90 3 1976677872 19534240 12532736
18:26:05 71893 8192000000 10889769072 11373322240 1917789312 18.969 97 21 42 2 1937636688 14358240 5489136
18:27:23 39819 8192000000 10883955984 11338784768 1881796800 18.680 95 23 47 1 1896385280 8116000 6472480
18:28:15 82368 8192000000 10886534528 11363065856 1898076064 18.811 97 8 16 0 1910678800 10722528 1880208
18:29:43 42036 8192000000 10897105248 11365527552 1910164224 18.908 97 17 34 0 1932499968 17756688 4579056
18:30:32 124379 8192000000 10876453280 11357618176 1880939888 18.673 96 9 18 1 1899840912 16722240 2178784
18:32:43 148803 8192000000 10877429280 11325124608 1844828768 18.380 94 16 32 0 1862201888 13001456 4371664
18:35:19 69110 8192000000 10875283472 11322089472 1895940752 18.794 97 52 103 0 1918799840 8354000 14505088
18:36:44 31151 8192000000 10878806640 11323449344 1925303488 19.029 99 41 82 3 1949621856 13162736 11155632
18:37:25 78781 8192000000 10837615280 11310047232 1867488352 18.564 96 15 30 0 1880712928 8442864 4781712
18:38:50 21167 8192000000 10851861952 11327860736 1935067152 19.107 100 6 13 1 1946201728 9359168 1775408
18:39:18 26181 8192000000 10855869584 11322576896 1933533920 19.095 100 11 22 2 1946509376 9498288 3477168
18:39:50 42441 8192000000 10850385328 11308269568 1861472592 18.515 96 18 36 1 1874048224 7555568 5020064
18:40:38 76822 8192000000 10849792704 11306844160 1841065888 18.349 95 23 45 1 1859939472 11931216 6942368
18:42:38 55897 8192000000 10868177648 11335266304 1943739872 19.177 100 39 78 2 1971606208 17027344 10838992
18:43:48 40641 8192000000 10878636000 11353739264 1947501056 19.207 100 8 16 0 1969992512 20028080 2463376
18:45:09 76315 8192000000 10849676992 11309268992 1842818624 18.364 95 9 18 1 1857893264 12316736 2757904
18:46:32 65319 8192000000 10882284496 11330920448 1879446144 18.661 97 29 58 0 1899459360 11869152 8144064
18:47:57 112648 8192000000 10859313936 11302481920 1775439152 17.812 92 16 32 1 1792991888 13080880 4471856
18:49:56 61126 8192000000 10869855136 11331084288 1925229664 19.029 100 21 42 0 1943257680 12185552 5842464
18:51:42 88148 8192000000 10880275856 11357155328 1928649008 19.056 99 10 21 0 1949151888 17469344 3033536
18:53:23 126385 8192000000 10908974096 11363573760 1919942768 18.986 98 11 22 0 1936672768 13984192 2745808
18:55:39 44556 8192000000 10905473024 11359330304 1952421824 19.246 99 24 48 0 1970626032 11508336 6695872
18:57:22 91037 8192000000 10888078448 11348213760 1936342960 19.118 98 29 59 1 1952090960 8170160 7577840
18:58:59 36582 8192000000 10889890048 11359313920 1967339120 19.364 100 19 36 1 1979600144 7274656 4986368
19:01:20 43669 8192000000 10883757664 11356798976 1945419552 19.190 99 10 20 1 1960037200 11460096 3157552
19:02:10 36232 8192000000 10879766528 11332669440 1928738624 19.057 98 9 18 0 1940345472 9146912 2459936
19:03:00 82816 8192000000 10872292608 11359133696 1916167200 18.956 98 9 18 0 1927263664 8510160 2586304
19:04:29 79422 8192000000 10895658400 11372654592 1943851856 19.177 99 19 37 2 1960323008 10685120 5786032
19:05:55 46864 8192000000 10907014528 11367690240 1959086272 19.299 99 36 69 2 1981398880 12336736 9975872
19:06:59 57532 8192000000 10896765520 11368005632 1953826080 19.257 99 20 40 3 1971487792 12669488 4992224
19:08:07 20384 8192000000 10917389632 11375718400 1978784368 19.455 100 46 92 1 2000534032 8382768 13366896
19:08:40 85937 8192000000 10893011536 11361198080 1920465056 18.991 97 15 30 2 1934060032 9350000 4244976
19:10:12 30046 8192000000 10929126800 11384586240 1979267552 19.459 100 33 64 2 1995797696 7952448 8577696
19:10:49 52395 8192000000 10904399968 11376091136 1951944256 19.242 99 28 56 2 1975102944 15459920 7698768
19:11:56 137624 8192000000 10889912032 11350904832 1840747024 18.347 93 14 27 0 1860475440 15581200 4147216
19:14:20 38892 8192000000 10905677376 11356049408 1928104592 19.052 98 29 57 2 1943438384 8005856 7327936
19:15:10 20114 8192000000 10904410384 11359817728 1949674096 19.224 99 35 70 1 1970201568 10732096 9795376
19:15:37 42715 8192000000 10927677184 11366260736 1965339520 19.348 100 31 62 3 1986572368 12185488 9047360
19:17:52 74181 8192000000 10877822432 11356991488 1911469936 18.918 97 21 41 1 1932056288 15236736 5349616
19:19:14 38490 8192000000 10875444048 11360686080 1958467232 19.294 100 7 14 0 1973035056 12560032 2007792
19:20:01 45223 8192000000 10840118160 11317223424 1909809632 18.905 98 10 20 1 1918987968 6398416 2779920
19:21:01 33087 8192000000 10851958272 11330027520 1937366864 19.126 100 5 10 0 1945473184 6955424 1150896
19:21:40 26895 8192000000 10843355360 11313672192 1866900496 18.559 96 12 24 0 1882391600 12154832 3336272
19:22:28 56454 8192000000 10835210288 11307765760 1882912880 18.689 98 10 20 0 1897660336 11948176 2799280
19:23:31 39021 8192000000 10817998688 11296538624 1839689856 18.338 96 7 14 0 1854349728 12866832 1793040
19:24:16 40303 8192000000 10821683760 11296784384 1834212832 18.294 96 13 26 0 1845667744 8019232 3435680
19:25:02 58779 8192000000 10858582288 11319021568 1888655424 18.735 98 18 36 0 1907391152 13474704 5261024
19:26:10 43952 8192000000 10823501120 11291222016 1808195392 18.081 94 23 46 1 1826138992 11348000 6595600

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 17-11-2020 19:28:33 to 17-11-2020 19:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

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

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          232509
MON$OLDEST_ACTIVE               236009
MON$OLDEST_SNAPSHOT             236009
MON$NEXT_TRANSACTION            236009
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                       2011072
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:239: 
:240: mscs-test-161.budzdorov.ru    Tue Nov 17 19:27:02 2020
:241:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:242: 
:243: 
:244: mscs-test-161.budzdorov.ru    Tue Nov 17 19:27:04 2020
:245:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:246: 
:247: 
:248: mscs-test-161.budzdorov.ru    Tue Nov 17 19:27:07 2020
:249:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:250: 
:251: 
:252: mscs-test-161.budzdorov.ru    Tue Nov 17 19:27:08 2020
:253:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:254: 
--- end of diff output ---

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

17.11.20 19:29:09. 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-17 19:29:11 No severe PSQL-related problems occured
17.11.20 19:29:12. End of report.