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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17391732 kB
MemAvailable 31474808 kB
Buffers 0 kB
Cached 14263528 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-28 19:27:25
DTS_END                         2021-03-28 19:27:25.1100
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/37862
TRN_ID                          241218
ATT_ID                          654
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: 9049.96 22356 1085995
customer order: creation 172.09 384 20651
customer order: refuse 14.78 374 1774
order to supplier: creation 45.35 1343 5442
order to supplier: removal 3.35 109648 402
invoice (draft): creation 45.82 3833 5498
invoice (draft): removal 50.42 915 6050
invoice accept: apply 41.81 19572 5017
invoice accept: cancel 45.24 895 5429
customer reserve: creation 3860.86 193 463303
customer reserve: removal 4484.92 64 538190
realization accept: apply 83.35 187 10002
realization accept: cancel 72.83 112 8740
payment from customer: creation 58.18 112 6981
payment from customer: removal 5.81 78 697
payment to supplier: creation 49.41 136 5929
payment to supplier: removal 3.45 75 414
service: total inventory turnovers 4.64 1029 557
service: total monetary turnovers 6.90 29 828
service: aggregate perf. data 0.73 27112 87
service: refresh index statistics 0.03 281019 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-03-2021 19:28:29 to 28-03-2021 19:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2766
TEST_TIME 2 4722
TEST_TIME 3 4414
TEST_TIME 4 4809
TEST_TIME 5 4853
TEST_TIME 6 4881
TEST_TIME 7 4956
TEST_TIME 8 5790
TEST_TIME 9 5794
TEST_TIME 10 5906
TEST_TIME 11 5833
TEST_TIME 12 5987
TEST_TIME 13 6666
TEST_TIME 14 6749
TEST_TIME 15 6798
TEST_TIME 16 7167
TEST_TIME 17 7220
TEST_TIME 18 7408
TEST_TIME 19 7673
TEST_TIME 20 8087
TEST_TIME 21 7991
TEST_TIME 22 8190
TEST_TIME 23 8677
TEST_TIME 24 8650
TEST_TIME 25 9138
TEST_TIME 26 9331
TEST_TIME 27 9560
TEST_TIME 28 10048
TEST_TIME 29 10640
TEST_TIME 30 10536
TEST_TIME 31 10304
TEST_TIME 32 10016
TEST_TIME 33 10237
TEST_TIME 34 10164
TEST_TIME 35 10072
TEST_TIME 36 9948
TEST_TIME 37 9900
TEST_TIME 38 9724
TEST_TIME 39 9641
TEST_TIME 40 9569
TEST_TIME 41 9456
TEST_TIME 42 9315
TEST_TIME 43 9222
TEST_TIME 44 9176
TEST_TIME 45 9121
TEST_TIME 46 8978
TEST_TIME 47 8938
TEST_TIME 48 8851
TEST_TIME 49 8959
TEST_TIME 50 9049
TEST_TIME 51 9142
TEST_TIME 52 9012
TEST_TIME 53 8981
TEST_TIME 54 8881
TEST_TIME 55 8864
TEST_TIME 56 8781
TEST_TIME 57 8919
TEST_TIME 58 8961
TEST_TIME 59 8965
TEST_TIME 60 8972
TEST_TIME 61 9066
TEST_TIME 62 9131
TEST_TIME 63 9113
TEST_TIME 64 9125
TEST_TIME 65 9328
TEST_TIME 66 9329
TEST_TIME 67 9285
TEST_TIME 68 9360
TEST_TIME 69 9367
TEST_TIME 70 9355
TEST_TIME 71 9269
TEST_TIME 72 9221
TEST_TIME 73 9189
TEST_TIME 74 9200
TEST_TIME 75 9221
TEST_TIME 76 9180
TEST_TIME 77 9154
TEST_TIME 78 9096
TEST_TIME 79 9100
TEST_TIME 80 9083
TEST_TIME 81 9020
TEST_TIME 82 9040
TEST_TIME 83 9040
TEST_TIME 84 9038
TEST_TIME 85 9085
TEST_TIME 86 9085
TEST_TIME 87 9079
TEST_TIME 88 9090
TEST_TIME 89 9090
TEST_TIME 90 9108
TEST_TIME 91 9145
TEST_TIME 92 9183
TEST_TIME 93 9180
TEST_TIME 94 9199
TEST_TIME 95 9210
TEST_TIME 96 9229
TEST_TIME 97 9164
TEST_TIME 98 9215
TEST_TIME 99 9160
TEST_TIME 100 9143
TEST_TIME 101 9095
TEST_TIME 102 9072
TEST_TIME 103 9023
TEST_TIME 104 8976
TEST_TIME 105 8977
TEST_TIME 106 8943
TEST_TIME 107 8994
TEST_TIME 108 9015
TEST_TIME 109 9006
TEST_TIME 110 9014
TEST_TIME 111 9014
TEST_TIME 112 9057
TEST_TIME 113 9105
TEST_TIME 114 9087
TEST_TIME 115 9114
TEST_TIME 116 9123
TEST_TIME 117 9116
TEST_TIME 118 9136
TEST_TIME 119 9070
TEST_TIME 120 9051

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2021 19:28:33 to 28-03-2021 19:28:36.

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 1513475 1513475 0 0.00 0 20760 7 0 0
doc_list_biud 1513467 1513467 0 0.00 0 35198 29 0 0
sp_add_invoice_to_stock 5162 5017 145 2.80 37 190097 19573 0 145
sp_cancel_adding_invoice 5429 5429 0 0.00 3 101870 895 0 0
sp_cancel_client_order 1774 1774 0 0.00 3 10350 375 0 0
sp_cancel_customer_reserve 538190 538190 0 0.00 1 28222 65 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 3 4922 78 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 3 5454 76 0 0
sp_cancel_supplier_invoice 6058 6050 8 0.13 2 27195 916 0 8
sp_cancel_supplier_order 402 402 0 0.00 14 1051283 109649 0 0
sp_cancel_write_off 8740 8740 0 0.00 1 10195 113 0 0
sp_client_order 20651 20651 0 0.00 4 38344 384 0 0
sp_customer_reserve 463303 463303 0 0.00 0 60279 193 0 0
sp_fill_shopping_cart 31591 31591 0 0.00 1 12208 39 0 0
sp_fill_shopping_cart_clo_res 463302 463302 0 0.00 0 36340 17 0 0
sp_get_clo_for_invoice 5013 5013 0 0.00 0 35658 326 0 0
sp_kill_cost_storno 15280 15280 0 0.00 0 8287 60 0 0
sp_kill_qstorno_ret_qs2qd 1091572 1091572 0 0.00 0 28216 35 0 0
sp_kill_qty_storno 575597 575597 0 0.00 0 35197 76 0 0
sp_lock_selected_doc 20830 20830 0 0.00 0 9609 6 0 0
sp_make_cost_storno 27925 27925 0 0.00 0 16032 58 0 0
sp_multiply_rows_for_pdistr 27920 27920 0 0.00 0 7630 29 0 0
sp_multiply_rows_for_qdistr 20651 20651 0 0.00 0 35235 173 0 0
sp_pay_from_customer 6981 6981 0 0.00 4 13567 113 0 0
sp_pay_to_supplier 5929 5929 0 0.00 5 17975 136 0 0
sp_payment_common 12906 12906 0 0.00 1 9111 30 0 0
sp_qd_handle_on_cancel_clo 1774 1774 0 0.00 0 9745 343 0 0
sp_qd_handle_on_invoice_upd_sts 10439 10439 0 0.00 0 35195 371 0 0
sp_qd_handle_on_reserve_upd_sts 10002 10002 0 0.00 0 12439 68 0 0
sp_reserve_write_off 10002 10002 0 0.00 6 14734 188 0 0
sp_supplier_invoice 5498 5498 0 0.00 6 92826 3834 0 0
sp_supplier_order 5442 5442 0 0.00 6 29108 1344 0 0
srv_aggregate_perf_data 87 87 0 0.00 2681 368470 27112 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1555 170347 31163 0 0
srv_find_qd_qs_mism 1037524 1037524 0 0.00 0 20760 6 0 0
srv_make_invnt_saldo 557 557 0 0.00 43 47621 1030 0 0
srv_make_money_saldo 828 828 0 0.00 0 3162 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 197223 357438 281020 0 0
t$perf-abend:sp_add_invoice_to_stock 145 145 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5017 5017 0 0.00 0 19131 208 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 7067 114 0 0
t$perf-norm:sp_cancel_client_order 1774 1774 0 0.00 0 7182 16 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 799 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 7726 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 1474 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 5562 29 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 28323 1846 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 7758 23 0 0
t$perf-norm:sp_client_order 20651 20651 0 0.00 0 10038 21 0 0
t$perf-norm:sp_customer_reserve 1012 1012 0 0.00 0 3311 6 0 0
t$perf-norm:sp_pay_from_customer 6981 6981 0 0.00 0 9981 10 0 0
t$perf-norm:sp_pay_to_supplier 5929 5929 0 0.00 0 13934 19 0 0
t$perf-norm:sp_reserve_write_off 10002 10002 0 0.00 0 9340 13 0 0
t$perf-norm:sp_supplier_invoice 5498 5498 0 0.00 0 5369 22 0 0
t$perf-norm:sp_supplier_order 5442 5442 0 0.00 0 7673 24 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 146 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 64 1 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 1162 25 0 0
t$perf-norm:srv_make_money_saldo 828 828 0 0.00 0 2170 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 36 12 0 0
v_add_invoice_to_stock 10304 10014 290 2.81 0 5098 20 0 290
v_all_customers 37554 37554 0 0.00 0 27 1 0 0
v_all_suppliers 30300 30300 0 0.00 0 23 1 0 0
v_all_wares 41302 41302 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 3880 21 0 0
v_cancel_client_order 3548 3548 0 0.00 0 2545 6 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 4916 11 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 342 3 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 3179 8 0 0
v_cancel_supplier_invoice 850 834 16 1.88 0 1521 17 0 16
v_cancel_supplier_order 804 804 0 0.00 0 188 3 0 0
v_cancel_write_off 1984 1984 0 0.00 0 8596 23 0 0
v_max_id_clo_ord 5442 5442 0 0.00 0 4358 2 0 0
v_max_id_clo_res 1012 1012 0 0.00 0 2256 14 0 0
v_max_id_ord_sup 5498 5498 0 0.00 0 1480 3 0 0
v_max_non_paid_invoice 1714 1714 0 0.00 0 867 3 0 0
v_max_non_paid_realizn 3645 3645 0 0.00 0 2004 4 0 0
v_min_id_clo_ord 5442 5442 0 0.00 0 2479 4 0 0
v_min_id_clo_res 1012 1012 0 0.00 0 4763 25 0 0
v_min_id_ord_sup 5498 5498 0 0.00 0 8114 8 0 0
v_min_non_paid_invoice 5924 5924 0 0.00 0 7294 21 0 0
v_min_non_paid_realizn 6980 6980 0 0.00 0 6123 18 0 0
v_our_firm 10418 10418 0 0.00 0 16 1 0 0
v_reserve_write_off 20004 20004 0 0.00 0 5102 5 0 0
x_lock_depdocs_on_canc_invoice 11062 11062 0 0.00 0 19786 123 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 13727 353 0 0
x_make_qstorno_1000_1200 5442 5442 0 0.00 2 29100 1263 0 0
x_make_qstorno_1200_2000 5498 5498 0 0.00 3 92726 3692 0 0
x_make_qstorno_2100_3300 463303 463303 0 0.00 0 60278 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2021 19:28:37 to 28-03-2021 19:28:41.

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:28 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:34 14588 8192000000 10232759120 10542964736 1010957616 10.985 79 59 118 2 1033705984 2797296 19951072
16:57:57 36720 8192000000 10339838256 10656452608 1378417408 14.402 100 81 162 0 1409732752 4558384 26756960
16:58:41 28316 8192000000 10389202960 10711834624 1430049072 14.862 100 86 172 0 1465088672 6512512 28527088
16:59:24 19944 8192000000 10408331936 10735456256 1465262064 15.172 100 92 184 0 1502828928 7396384 30170480
16:59:58 20183 8192000000 10424561168 10751250432 1477351824 15.278 100 93 186 0 1515702720 8149920 30200976
17:00:28 21876 8192000000 10443128640 10775781376 1490375312 15.392 100 86 172 0 1527092288 8651856 28065120
17:01:04 19346 8192000000 10457186704 10792980480 1510535920 15.568 100 91 182 1 1548826240 9239952 29050368
17:01:34 17131 8192000000 10470472064 10814894080 1529560576 15.733 100 79 158 1 1564368192 9784112 25023504
17:02:05 17154 8192000000 10518964976 10864799744 1567499808 16.061 100 81 162 0 1602206544 10095568 24611168
17:02:30 18182 8192000000 10538171696 10892091392 1593131344 16.281 100 79 158 2 1627931584 10954320 23845920
17:02:56 9683 8192000000 10552331232 10914680832 1615993104 16.476 100 73 143 1 1646911552 9643152 21275296
17:03:20 11211 8192000000 10595671936 10956677120 1648994624 16.756 100 80 160 2 1687418864 14845728 23578512
17:03:43 7429 8192000000 10604514176 10973151232 1676360896 16.987 100 75 150 2 1708735152 10622336 21751920
17:03:59 11220 8192000000 10637235776 11007606784 1695836320 17.150 100 79 159 2 1730171760 11540048 22795392
17:04:18 8788 8192000000 10655017200 11023396864 1714071376 17.303 100 90 181 3 1752889808 13224832 25593600
17:04:34 6549 8192000000 10663396224 11032891392 1724486480 17.390 100 90 180 2 1763800304 14239568 25074256
17:04:48 5042 8192000000 10674634048 11044859904 1734027968 17.469 100 90 178 3 1773878496 14818864 25031664
17:05:01 3962 8192000000 10683046144 11055763456 1745907408 17.568 100 89 179 1 1785931504 14809472 25214624
17:05:12 5673 8192000000 10701376864 11075493888 1753931120 17.634 100 88 176 0 1793647072 14603648 25112304
17:05:24 5142 8192000000 10700886112 11077042176 1763418912 17.713 100 86 171 2 1801889040 14356240 24113888
17:05:37 3470 8192000000 10714770832 11090534400 1771553104 17.780 100 83 165 3 1808880928 13548752 23779072
17:05:48 4452 8192000000 10721569216 11099955200 1779052320 17.842 100 85 170 1 1815379968 12844448 23483200
17:05:59 3641 8192000000 10726115968 11110584320 1784260560 17.885 100 75 151 1 1817018192 12134944 20622688
17:06:09 4730 8192000000 10740505776 11118915584 1795468960 17.977 100 89 178 2 1834683376 14160928 25053488
17:06:20 3881 8192000000 10741837104 11124404224 1802561760 18.035 100 91 179 0 1841246720 13891648 24793312
17:06:31 3620 8192000000 10746569856 11125547008 1802655168 18.036 100 84 168 2 1840244496 13325056 24264272
17:06:41 3866 8192000000 10757137536 11141636096 1803688176 18.044 100 81 160 0 1840126960 14189744 22249040
17:06:52 1631 8192000000 10760865392 11146248192 1820192032 18.179 100 87 174 1 1858471584 14122736 24156816
17:07:00 2551 8192000000 10775762800 11155025920 1826601264 18.232 100 90 180 1 1866665680 14462672 25601744
17:07:09 1622 8192000000 10776858896 11159343104 1833306512 18.286 100 91 182 1 1871558656 13559472 24692672
17:07:17 1500 8192000000 10783996144 11165671424 1839481584 18.337 100 93 186 0 1879759664 14083408 26194672
17:07:25 1551 8192000000 10784941888 11167830016 1845095344 18.382 100 88 176 4 1883469664 14323680 24050640
17:07:33 1637 8192000000 10795953376 11178676224 1847497056 18.402 100 96 189 1 1887634288 13726832 26410400
17:07:41 2506 8192000000 10798563552 11186196480 1852202800 18.440 100 82 165 1 1887565056 12790928 22571328
17:07:49 1633 8192000000 10808529104 11192913920 1862514416 18.524 100 96 192 2 1902448976 13779104 26155456
17:07:57 1619 8192000000 10805646512 11193442304 1864127232 18.537 100 95 187 2 1903186096 12801600 26257264
17:08:05 1874 8192000000 10813432928 11198525440 1866605216 18.557 100 94 189 1 1908917600 15347552 26964832
17:08:13 1263 8192000000 10814653680 11202338816 1869110432 18.577 100 91 184 2 1908118352 13011104 25996816
17:08:21 1402 8192000000 10817478432 11204812800 1870089488 18.585 100 88 176 0 1908358976 13473824 24795664
17:08:28 27118 8192000000 10791440352 11198611456 1864084720 18.536 100 51 102 1 1889581792 11313936 14183136
17:09:03 15047 8192000000 10816518464 11205754880 1874891792 18.624 100 79 160 0 1906001088 8864304 22244992
17:09:24 10304 8192000000 10817770128 11212763136 1875870576 18.632 100 79 157 1 1908680592 10985296 21824720
17:09:41 10982 8192000000 10770832928 11199426560 1865262848 18.546 100 34 68 0 1884398192 9740752 9394592
17:10:01 7269 8192000000 10780741136 11200499712 1866826144 18.559 100 38 74 1 1883385712 5641552 10918016
17:10:16 3634 8192000000 10787846240 11207122944 1871949248 18.600 100 49 98 1 1894350080 7993328 14407504
17:10:27 5129 8192000000 10776722496 11203874816 1868579008 18.573 100 28 56 1 1882735760 7030384 7126368
17:10:43 2586 8192000000 10789097024 11213402112 1874152368 18.618 100 43 86 0 1895424864 9168704 12103792
17:10:55 9900 8192000000 10784831168 11211943936 1871922960 18.600 100 25 50 0 1885527088 6831072 6773056
17:11:13 7105 8192000000 10784344240 11208503296 1874586752 18.621 100 29 54 2 1889431056 5996080 8848224
17:11:26 5973 8192000000 10789061152 11215249408 1879190192 18.659 100 33 65 0 1894164864 6608176 8366496
17:11:42 8230 8192000000 10786670688 11218997248 1881813440 18.680 100 21 42 2 1893014464 5263232 5937792
17:11:56 8623 8192000000 10790932480 11223543808 1884560240 18.702 100 20 40 0 1896130144 6127712 5442192
17:12:15 10261 8192000000 10797276752 11226886144 1884759776 18.704 100 18 36 3 1896107184 6009184 5338224
17:12:34 6295 8192000000 10791370240 11227394048 1886008224 18.714 100 17 34 1 1897022288 6011040 5003024
17:12:46 7017 8192000000 10801604960 11228196864 1887696176 18.727 100 17 34 0 1898646416 6337360 4612880
17:13:08 7071 8192000000 10796516256 11229655040 1893438560 18.773 100 23 46 2 1905704416 5922848 6343008
17:13:23 44604 8192000000 10830326400 11250675712 1901387824 18.837 100 49 97 4 1926231744 9577216 15266704
17:14:20 20446 8192000000 10863098720 11264495616 1910455024 18.910 100 81 166 0 1941079824 6083520 24541280
17:14:47 7734 8192000000 10806840400 11248676864 1900809312 18.833 100 28 56 0 1916514944 8129504 7576128
17:15:03 10487 8192000000 10825472512 11257053184 1903480128 18.854 100 30 59 1 1921960512 10866160 7614224
17:15:21 7440 8192000000 10828902544 11261456384 1902544848 18.847 100 36 71 1 1927491856 15317824 9629184
17:15:37 7576 8192000000 10814800880 11243421696 1883124384 18.690 99 29 58 1 1897763312 6484592 8154336
17:15:51 5027 8192000000 10821903920 11245486080 1895555232 18.791 100 35 70 1 1913420496 7886208 9979056
17:16:03 8568 8192000000 10808021040 11247685632 1897164320 18.803 100 28 56 3 1911188800 6316768 7707712
17:16:23 5712 8192000000 10817254032 11252506624 1904419856 18.862 100 40 80 2 1923085792 7520784 11145152
17:16:37 10827 8192000000 10825732272 11261452288 1904165856 18.860 100 18 34 1 1919300240 10648352 4486032
17:16:58 14809 8192000000 10796188704 11231719424 1827191680 18.236 96 13 26 2 1836436624 5164592 4080352
17:17:23 7819 8192000000 10761303472 11184640000 1814068816 18.129 97 19 37 1 1824638144 5393344 5175984
17:17:37 12153 8192000000 10771066992 11192193024 1800211232 18.016 96 25 50 0 1812342656 5119840 7011584
17:17:56 59392 8192000000 10781082064 11184189440 1766518080 17.738 94 47 92 2 1786595376 5135264 14942032
17:19:03 15704 8192000000 10746502816 11174993920 1772076208 17.784 96 18 36 1 1782344656 4910352 5358096
17:19:28 7825 8192000000 10741148432 11157594112 1761845984 17.700 96 35 71 1 1778192400 6428256 9918160
17:19:43 8204 8192000000 10736769136 11154538496 1793382880 17.960 98 34 67 1 1809658928 6303280 9972768
17:19:57 10316 8192000000 10695818000 11106205696 1690382320 17.105 93 32 64 2 1705012128 5118016 9511792
17:20:14 6941 8192000000 10688857808 11106148352 1738377280 17.505 97 27 54 0 1751901008 5838496 7685232
17:20:27 3967 8192000000 10674264304 11088203776 1750651856 17.607 98 33 66 1 1767826416 7944976 9229584
17:20:42 9209 8192000000 10675513120 11080056832 1720847664 17.359 97 26 52 0 1737841648 9502864 7491120
17:20:58 6296 8192000000 10664780912 11069001728 1686042128 17.068 96 33 66 0 1705869440 10452624 9374688
17:21:10 14147 8192000000 10709438288 11126419456 1769425968 17.762 99 32 62 3 1786169664 6550960 10192736
17:21:32 12385 8192000000 10730016464 11143000064 1789338736 17.926 99 21 42 3 1801324096 5843216 6142144
17:21:54 7369 8192000000 10713661856 11126775808 1765038000 17.726 98 19 38 2 1776102768 4742416 6322352
17:22:14 11081 8192000000 10734856592 11143593984 1791712624 17.946 99 17 35 2 1801367424 4666432 4988368
17:22:35 68913 8192000000 10740239888 11166244864 1807754496 18.077 99 34 67 1 1823830416 5229936 10845984
17:23:50 8443 8192000000 10737678720 11168542720 1831105680 18.268 100 21 42 2 1842900272 5941392 5853200
17:24:07 7001 8192000000 10766635408 11181383680 1838734000 18.331 100 37 74 1 1856670192 7902464 10033728
17:24:22 7469 8192000000 10774777376 11193753600 1850865536 18.429 100 47 92 2 1870818976 7037216 12916224
17:24:35 5097 8192000000 10774115328 11192057856 1851484288 18.434 100 20 40 2 1863936480 5626944 6825248
17:24:46 4690 8192000000 10771297616 11195666432 1854435376 18.458 100 28 56 1 1869233584 6872816 7925392
17:24:59 8627 8192000000 10790164304 11208376320 1863344736 18.530 100 28 55 1 1876026352 5267776 7413840
17:25:14 6633 8192000000 10775133728 11204042752 1861496544 18.515 100 31 62 3 1876362128 6028848 8836736
17:25:27 6969 8192000000 10780435200 11207749632 1863767424 18.534 100 26 50 3 1876942064 5303504 7871136
17:25:44 7618 8192000000 10772011184 11207688192 1867901472 18.567 100 32 61 1 1883366592 6098656 9366464
17:25:58 7662 8192000000 10787064640 11211649024 1865873808 18.551 100 20 41 0 1876961872 4838688 6249376
17:26:18 9023 8192000000 10781824048 11212902400 1869770544 18.582 100 17 32 3 1879516592 5307344 4438704
17:26:33 12071 8192000000 10784950880 11220783104 1874100992 18.617 100 19 38 0 1884375040 4822128 5451920
17:26:52 14995 8192000000 10794967856 11228450816 1880081120 18.666 100 26 52 1 1892748128 4969072 7697936
17:27:14 13703 8192000000 10824340976 11242479616 1898859840 18.817 100 26 53 2 1911071232 4696672 7514720
17:27:38 15064 8192000000 10849824688 11268710400 1916737440 18.961 100 45 88 2 1937272464 7038208 13496816
17:28:00 93249 8192000000 10855637968 11283292160 1927032512 19.043 100 62 124 0 1954600656 9869920 17698224
17:29:44 27533 8192000000 10845876256 11275960320 1913776448 18.937 99 37 72 1 1932087792 8137040 10174304
17:30:22 7481 8192000000 10852961536 11279118336 1921880976 19.002 99 42 84 1 1942658832 8432432 12345424
17:30:39 26419 8192000000 10878378000 11307544576 1945219968 19.188 100 49 96 1 1968418768 9774096 13424704
17:31:12 13056 8192000000 10881527536 11313647616 1953581840 19.255 100 55 108 1 1980283456 10567888 16133728
17:31:36 7357 8192000000 10888036496 11321503744 1959599696 19.303 100 50 97 1 1987202032 12654512 14947824
17:31:51 3497 8192000000 10895347152 11324538880 1963343568 19.333 100 55 109 2 1991632432 12502448 15786416
17:32:02 9048 8192000000 10910222608 11338309632 1966797664 19.360 100 50 100 1 1998839600 17758736 14283200
17:32:22 18011 8192000000 10911430704 11337080832 1970184016 19.387 100 53 106 2 1999687184 14092608 15410560
17:32:48 8213 8192000000 10912842048 11340636160 1973083680 19.410 100 56 112 2 2003433536 14432336 15917520
17:33:03 13539 8192000000 10907588576 11340386304 1974823792 19.424 100 55 110 0 2005824624 15302272 15698560
17:33:25 20561 8192000000 10922169056 11354849280 1980768400 19.471 100 50 96 3 2011994576 16449568 14776608
17:33:56 4751 8192000000 10933862192 11360272384 1988215328 19.530 100 58 114 1 2023235088 18023760 16996000
17:34:09 12255 8192000000 10938262336 11365908480 1992573104 19.564 100 73 144 1 2033724224 19096480 22054640
17:34:28 4514 8192000000 10930230944 11361406976 1981574128 19.477 100 57 112 3 2018538496 20041680 16922688
17:34:41 14399 8192000000 10932138864 11361382400 1968520096 19.374 99 57 113 1 2006927088 20989152 17417840
17:35:14 9516 8192000000 10935310576 11369947136 1989522320 19.540 100 52 102 1 2024549984 19756992 15270672
17:35:30 9148 8192000000 10937282176 11376037888 1994480864 19.579 100 44 88 1 2027099728 18683424 13935440
17:35:46 7577 8192000000 10924100400 11358420992 1972022128 19.401 99 54 108 4 2006756320 17979488 16754704
17:36:01 8997 8192000000 10932172192 11362484224 1971616576 19.398 99 64 128 0 2010707424 19884816 19206032
17:36:17 8248 8192000000 10944212112 11369058304 1992104912 19.560 100 62 124 0 2030331376 20012848 18213616
17:36:33 15790 8192000000 10957686896 11384614912 2002061392 19.639 100 78 156 1 2047010944 22293840 22655712
17:36:55 7306 8192000000 10956324608 11381981184 1999600592 19.620 100 65 130 1 2041000576 22063920 19336064
17:37:16 5824 8192000000 10968829456 11394371584 2001690368 19.636 100 58 116 0 2039361504 20664832 17006304
17:37:30 6218 8192000000 10965207392 11395854336 2013582112 19.730 100 66 131 1 2055937712 23482992 18872608
17:37:45 7087 8192000000 10950240624 11382300672 1982837008 19.487 99 62 122 1 2025112464 24082336 18193120
17:37:59 6514 8192000000 10948864256 11383955456 2000215536 19.624 100 54 106 0 2040240608 24075936 15949136
17:38:18 4422 8192000000 10964003264 11395358720 2000078048 19.623 100 55 110 0 2047953776 31063216 16812512
17:38:31 5746 8192000000 10964254560 11394179072 1996526096 19.595 100 59 117 1 2046246240 31656976 18063168
17:38:45 2556 8192000000 10952413040 11385020416 1994504560 19.579 100 67 134 1 2044673616 28506896 21662160
17:38:56 3944 8192000000 10969523088 11400478720 2005670304 19.667 100 73 145 3 2057840752 30344992 21825456
17:39:07 3481 8192000000 10969429376 11396706304 1993177024 19.569 99 75 146 0 2047739280 32329216 22233040
17:39:24 6430 8192000000 10966665440 11391856640 1995453216 19.587 100 70 140 1 2050393264 33820784 21119264
17:39:47 6062 8192000000 10978790496 11400343552 2005560272 19.667 100 70 140 1 2064084784 36252800 22271712
17:40:01 5237 8192000000 10955853728 11388211200 1983684368 19.494 99 72 144 1 2039503088 33136784 22681936
17:40:14 3182 8192000000 10963605328 11386830848 1982899632 19.488 99 82 164 1 2036401792 28319088 25183072
17:40:23 4971 8192000000 10958165328 11386662912 1989559904 19.540 100 79 158 1 2049304896 35332832 24412160
17:40:43 2721 8192000000 10961663568 11390586880 1995868112 19.590 100 73 145 0 2050352304 31644112 22840080
17:40:53 4988 8192000000 10942738240 11386990592 1977756176 19.447 99 51 103 2 2022159808 28530592 15873040
17:41:08 15506 8192000000 10931842544 11374354432 1976074256 19.434 99 42 83 2 2017882080 28648912 13158912
17:41:34 5733 8192000000 10938133280 11384131584 1986209840 19.514 100 40 78 2 2025734784 27252208 12272736
17:41:53 7565 8192000000 10936064912 11378794496 1984393568 19.499 100 44 88 2 2027100144 28439696 14266880
17:42:08 2878 8192000000 10937019648 11367833600 1973541664 19.414 100 61 122 3 2022457136 30293024 18622448
17:42:17 4707 8192000000 10927649456 11350908928 1958833152 19.297 100 71 143 0 2017837968 36478832 22525984
17:42:30 12408 8192000000 10938792928 11363983360 1966257664 19.356 100 68 135 0 2021439328 35083984 20097680
17:42:51 3139 8192000000 10949586752 11370733568 1973043792 19.410 100 68 136 1 2028792112 35539280 20209040
17:43:01 7089 8192000000 10958955760 11385614336 1988353904 19.531 100 75 150 0 2046061104 34747328 22959872
17:43:17 2580 8192000000 10969378912 11392118784 1990145920 19.545 100 78 153 2 2048224480 35391520 22687040
17:43:29 4832 8192000000 10952360240 11377782784 1980169552 19.466 100 75 149 0 2040034240 37292896 22571792
17:43:43 4151 8192000000 10959329808 11381063680 1976394576 19.436 100 81 163 3 2037768224 37332720 24040928
17:43:55 5298 8192000000 10951100000 11383840768 1982543536 19.485 100 71 142 0 2040843712 36265120 22035056
17:44:11 7099 8192000000 10959510064 11388297216 1988754064 19.534 100 64 128 0 2040544256 31682640 20107552
17:44:27 6684 8192000000 10947415408 11370471424 1975319984 19.428 99 74 148 2 2031553296 33387136 22846176
17:44:41 6997 8192000000 10950812656 11383177216 1981658336 19.478 100 67 134 1 2037119792 34724864 20736592
17:44:55 2748 8192000000 10966242992 11384745984 1988335584 19.531 100 81 161 2 2049192416 34907600 25949232
17:45:04 2798 8192000000 10971089744 11391283200 1991451520 19.555 100 82 163 0 2053449024 36595920 25401584
17:45:14 1667 8192000000 10981195680 11390099456 1988485984 19.532 100 88 174 2 2051227024 35793056 26947984
17:45:25 2056 8192000000 10979467968 11395309568 1993669376 19.573 100 88 177 0 2058269024 37186288 27413360
17:45:34 1566 8192000000 10968752704 11383136256 1988450960 19.532 100 85 167 2 2050631808 36360496 25820352
17:45:43 2460 8192000000 10969184160 11385536512 1971246400 19.395 99 75 148 0 2030913568 36220880 23446288
17:45:53 3752 8192000000 10956583184 11374321664 1967572384 19.366 99 82 164 1 2028899888 34825600 26501904
17:46:07 2189 8192000000 10966053696 11378446336 1983289904 19.491 100 84 168 0 2045472096 35877232 26304960
17:46:17 3699 8192000000 10968055760 11388207104 1977042112 19.441 99 83 164 1 2038121088 35616896 25462080
17:46:31 9672 8192000000 10969804880 11393159168 1995026352 19.583 100 67 134 0 2051385328 35601040 20757936
17:46:47 3332 8192000000 10979896272 11393114112 1994287648 19.578 100 92 184 1 2059308720 35789184 29231888
17:46:57 1746 8192000000 10972175968 11388268544 1990492672 19.548 100 92 183 0 2055562992 36472288 28598032
17:47:05 2579 8192000000 10992904944 11402817536 2000875856 19.630 100 92 184 1 2067263104 37650976 28736272
17:47:14 4107 8192000000 10979748608 11399729152 1982046976 19.481 99 77 154 0 2043896224 38427280 23421968
17:47:26 7406 8192000000 10962592240 11400839168 1992678960 19.565 100 67 134 2 2049483728 36082416 20722352
17:47:41 9305 8192000000 10946923552 11386978304 1968681568 19.375 99 42 84 0 2018065264 34868672 14515024
17:47:59 14028 8192000000 10954213600 11396157440 1987901056 19.527 100 42 85 1 2040134208 37502320 14730832
17:48:27 7323 8192000000 10951339776 11384897536 1987093184 19.521 100 54 107 1 2041154032 36655952 17404896
17:48:44 4556 8192000000 10940527568 11357425664 1949122912 19.219 99 76 152 1 2011953296 38486144 24344240
17:48:58 3191 8192000000 10971621312 11384717312 1980999200 19.473 100 76 152 2 2046340240 41236960 24104080
17:49:07 1555 8192000000 10967338528 11380973568 1974987968 19.425 100 90 175 0 2046656928 43835632 27833328
17:49:16 3858 8192000000 10965558976 11389120512 1982302832 19.483 100 76 150 1 2049270080 43910352 23056896
17:49:36 6690 8192000000 10957433504 11389833216 1964127456 19.339 99 56 112 1 2027646512 45251088 18267968
17:49:51 3059 8192000000 10948014752 11361157120 1945215584 19.188 99 73 145 0 2012118592 43628768 23274240
17:50:11 2333 8192000000 10962892608 11384041472 1974399008 19.420 100 78 154 2 2045400080 45944096 25056976
17:50:20 7177 8192000000 10948948736 11370405888 1952972688 19.250 99 74 146 0 2022122064 45707008 23442368
17:50:41 16736 8192000000 10922048448 11364769792 1945054256 19.187 100 40 79 2 2009474192 51104784 13315152
17:51:18 17135 8192000000 10921721568 11359989760 1932923424 19.090 99 38 76 1 1988689024 42681856 13083744
17:51:51 29255 8192000000 10905533440 11347738624 1926776048 19.041 99 37 74 3 1984036224 43747248 13512928
17:52:46 20846 8192000000 10883396784 11338252288 1935009952 19.107 100 28 56 1 1979050496 34134016 9906528
17:53:15 13155 8192000000 10889850496 11324682240 1909075872 18.899 99 40 81 3 1955788192 33448560 13263760
17:53:53 36940 8192000000 10873370160 11335348224 1898191760 18.812 98 22 44 1 1939216864 33167472 7857632
17:54:37 26808 8192000000 10874828688 11339902976 1914341376 18.941 100 16 32 0 1955390896 35240656 5808864
17:55:10 26315 8192000000 10887013840 11340079104 1914702496 18.944 100 20 40 0 1966553344 44135088 7715760
17:55:47 20194 8192000000 10863696864 11336867840 1880536800 18.669 98 24 48 1 1918449408 29780064 8132544
17:56:18 47720 8192000000 10842104288 11294543872 1833021872 18.284 96 10 18 0 1847472864 10692896 3758096
17:57:18 63380 8192000000 10834892240 11297460224 1873121296 18.610 98 9 18 0 1892687328 17133264 2432768
17:58:38 79065 8192000000 10860039152 11301031936 1899735680 18.824 99 35 68 0 1928505216 18802608 9966928
18:00:04 19973 8192000000 10847109696 11311726592 1911377440 18.918 99 49 97 0 1945660064 20748384 13534240
18:00:31 23451 8192000000 10869108400 11312594944 1912595552 18.927 99 30 55 2 1927077200 6812992 7668656
18:01:04 17534 8192000000 10852633664 11317506048 1938795184 19.137 100 18 36 3 1951161120 7218992 5146944
18:01:28 28135 8192000000 10856564320 11316957184 1936252512 19.117 100 14 28 2 1947387632 6973248 4161872
18:02:26 31999 8192000000 10871408896 11336519680 1951816112 19.241 100 15 30 0 1966324688 10622128 3886448
18:03:11 54625 8192000000 10876603472 11352432640 1956603152 19.279 100 9 18 0 1971235568 11835632 2796784
18:04:13 72354 8192000000 10890016432 11345915904 1945700224 19.192 99 25 50 1 1962860672 10041456 7118992
18:05:36 33294 8192000000 10923669440 11357376512 1972034032 19.402 100 42 83 2 1992073520 8116896 11922592
18:06:19 40193 8192000000 10892081744 11358781440 1974408624 19.420 100 37 74 0 1993804656 8521632 10874400
18:07:14 134009 8192000000 10885372496 11352289280 1936704880 19.120 98 22 43 0 1951414224 8626016 6083328
18:09:34 76645 8192000000 10883844864 11352567808 1954035568 19.259 99 31 61 0 1972789104 10104608 8648928
18:11:05 79133 8192000000 10890261648 11362357248 1973054464 19.410 100 25 50 1 1992252688 12404000 6794224
18:12:42 56466 8192000000 10900214752 11365580800 1974230992 19.419 100 17 34 2 1990554720 11092192 5231536
18:13:45 9749 8192000000 10921740096 11379122176 1985521840 19.508 100 30 58 2 2006705104 13255872 7927392
18:14:10 5837 8192000000 10942761072 11387756544 2002329536 19.641 100 51 101 1 2034678624 17714688 14634400
18:14:25 14483 8192000000 10925648096 11375099904 1961879632 19.321 99 39 78 1 1997310288 23963648 11467008
18:15:23 56627 8192000000 10921960128 11379339264 1969547568 19.382 99 37 74 0 2001947904 21365408 11034928
18:16:27 36366 8192000000 10899344240 11381358592 1955546704 19.271 99 19 38 0 1988680064 26323408 6809952
18:17:11 41879 8192000000 10895139904 11375525888 1964483888 19.342 100 12 24 0 1992523552 24513520 3526144
18:17:59 53987 8192000000 10900493152 11383873536 1963483072 19.334 100 18 36 2 1995351200 26772048 5096080
18:19:00 67988 8192000000 10892241296 11364294656 1956600768 19.279 99 8 16 0 1968960432 10212128 2147536
18:20:15 41268 8192000000 10884937952 11358990336 1957699296 19.288 99 17 32 2 1974785872 12732128 4354448
18:21:03 30073 8192000000 10893428976 11367088128 1973035424 19.410 100 6 12 0 1984147440 9634128 1477888
18:21:50 68945 8192000000 10900456240 11373056000 1921646128 19.000 97 8 12 1 1933286736 10163312 1477296
18:23:05 78635 8192000000 10902684704 11363520512 1935343984 19.110 98 27 53 3 1958452000 15017872 8090144
18:24:43 42345 8192000000 10878534016 11346247680 1918875104 18.978 98 16 32 0 1941177760 17340416 4962240
18:25:32 69562 8192000000 10873403568 11349594112 1914367520 18.942 98 15 30 1 1930330032 11244176 4718336
18:26:51 80296 8192000000 10904322544 11361316864 1947846832 19.209 99 17 34 0 1967427440 14834576 4746032
18:28:19 63910 8192000000 10915090208 11368112128 1918299968 18.973 97 26 52 0 1939405568 13623872 7481728
18:29:31 53933 8192000000 10915519088 11380785152 1953604016 19.255 99 21 43 0 1970127584 11151232 5372336
18:30:32 78432 8192000000 10916811872 11377790976 1924656064 19.024 97 11 22 0 1941365456 13724144 2985248
18:32:03 53105 8192000000 10907076800 11389149184 1961356976 19.317 99 7 14 0 1981809872 18369696 2083200
18:33:46 64231 8192000000 10922559024 11370692608 1927238576 19.045 97 31 63 1 1946420752 10419072 8763104
18:34:57 20897 8192000000 10906206336 11362070528 1968682912 19.375 100 35 70 1 1989348992 10621840 10044240
18:35:28 123605 8192000000 10911030448 11370930176 1859615600 18.500 94 22 44 1 1878562464 13109216 5837648
18:37:43 110874 8192000000 10882991920 11333427200 1875184960 18.626 95 35 70 1 1892959856 8774352 9000544
18:39:58 84121 8192000000 10861466672 11317243904 1856346160 18.474 95 33 66 2 1877194272 11555024 9293088
18:41:45 17639 8192000000 10833443440 11304984576 1852954016 18.446 96 29 58 1 1875057776 13550144 8553616
18:42:24 49439 8192000000 10821329232 11283267584 1883442096 18.693 98 16 32 3 1894790288 7546576 3801616
18:43:26 78548 8192000000 10829569920 11305373696 1854113632 18.456 96 11 22 0 1866183232 9130624 2938976
18:44:51 56990 8192000000 10860009104 11309858816 1883787216 18.696 98 30 58 3 1899058192 8412192 6858784
18:46:07 64512 8192000000 10826150272 11302068224 1886876512 18.721 98 15 30 0 1901636432 10280880 4479040
18:47:22 26362 8192000000 10817276544 11281764352 1849184800 18.416 97 7 14 0 1863469648 12356800 1928048
18:47:55 33383 8192000000 10814565936 11285360640 1897981408 18.810 100 12 24 1 1911999776 10685088 3333280
18:48:43 30900 8192000000 10830959376 11282755584 1871902752 18.600 98 18 36 0 1889082192 11463616 5715824
18:49:27 77025 8192000000 10828916672 11310444544 1909267008 18.901 100 8 16 2 1923858128 12210080 2381040
18:50:50 64774 8192000000 10855325664 11330179072 1924689456 19.024 100 26 52 0 1942862064 11076592 7096016
18:52:02 58613 8192000000 10854992480 11322658816 1890785696 18.752 98 19 38 1 1913534528 18020624 4728208
18:53:35 33594 8192000000 10853354560 11314159616 1899804832 18.825 98 29 58 1 1915859984 8413344 7641808
18:54:17 24757 8192000000 10860278736 11308478464 1915843600 18.954 99 24 47 1 1930089088 7763232 6482256
18:54:50 15714 8192000000 10873996240 11332534272 1940989984 19.155 100 36 71 1 1959724112 7911040 10823088
18:55:11 47099 8192000000 10853950480 11318624256 1890749760 18.752 97 27 54 3 1907906128 9100320 8056048
18:56:05 20283 8192000000 10881760880 11332255744 1941915040 19.162 100 38 76 2 1960868336 8780720 10172576
18:56:41 51933 8192000000 10886419184 11354177536 1954227696 19.260 100 23 46 1 1971755008 11010448 6516864
18:57:40 151334 8192000000 10892619200 11353477120 1851572560 18.435 94 14 28 1 1875037600 19550528 3914512
19:00:17 32896 8192000000 10887832672 11347726336 1910056096 18.907 97 26 52 1 1925784688 8852848 6875744
19:00:59 38065 8192000000 10884425520 11345379328 1931444480 19.078 99 25 50 0 1950862160 12206960 7210720
19:01:44 55393 8192000000 10922319536 11372761088 1944167088 19.180 99 26 52 0 1967509808 15746144 7596576
19:02:49 170346 8192000000 10890024720 11367923712 1911046688 18.915 97 17 34 1 1941409008 24983152 5379168
19:05:58 46726 8192000000 10887834704 11351764992 1942127552 19.164 99 26 52 0 1961959696 12330960 7501184
19:06:52 28839 8192000000 10888514480 11361660928 1949611264 19.223 99 22 44 2 1964967216 9007376 6348576
19:07:30 40074 8192000000 10882820272 11357749248 1966563344 19.358 100 11 22 0 1977463520 7402672 3497504
19:08:16 69252 8192000000 10880040944 11359989760 1955461040 19.270 99 10 20 0 1964528016 6047456 3019520
19:09:33 77260 8192000000 10887918688 11364601856 1931615408 19.080 98 11 22 2 1942305456 7571296 3118752
19:10:57 54653 8192000000 10887248128 11347607552 1953707952 19.256 99 28 56 1 1973946768 11800192 8438624
19:11:58 53427 8192000000 10890676048 11367976960 1942796896 19.169 98 28 56 0 1968982656 17876304 8309456
19:12:57 77432 8192000000 10893870944 11361660928 1880223760 18.667 95 24 48 2 1904531120 17045376 7261984
19:14:21 72701 8192000000 10906767472 11374350336 1952334768 19.245 99 24 48 0 1973189360 14088880 6765712
19:15:54 46138 8192000000 10888890416 11350777856 1895160272 18.787 96 20 40 2 1910696352 9778048 5758032
19:16:47 88430 8192000000 10892541504 11351891968 1862148384 18.521 95 22 44 2 1879222208 11031088 6042736
19:18:22 44543 8192000000 10919195920 11370209280 1958849360 19.297 100 22 44 1 1977275424 11754240 6671824
19:19:22 64925 8192000000 10909897248 11390988288 1978238160 19.451 100 35 70 1 2007385312 18571952 10575200
19:20:36 54897 8192000000 10937003872 11377844224 1943696288 19.176 98 25 48 0 1959174224 8908512 6569424
19:21:39 46165 8192000000 10904950912 11372564480 1938991792 19.139 98 30 60 0 1959856592 12569984 8294816
19:22:31 39035 8192000000 10913476432 11368677376 1929789072 19.065 98 30 60 0 1953991968 16018144 8184752
19:23:36 72062 8192000000 10894067568 11358486528 1886155456 18.715 96 14 28 0 1902530672 12591456 3783760
19:24:54 24166 8192000000 10896768656 11355054080 1937359776 19.126 99 36 72 2 1960881680 13415056 10106848
19:25:26 72837 8192000000 10883939888 11351207936 1920174848 18.988 98 41 81 2 1953207008 21604272 11427888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-03-2021 19:28:43 to 28-03-2021 19:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 145 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-03-2021 19:29:16 to 28-03-2021 19:29:18.

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          240350
MON$OLDEST_ACTIVE               241374
MON$OLDEST_SNAPSHOT             241374
MON$NEXT_TRANSACTION            241374
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                       2030240
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:103: 
:104: mscs-test-161.budzdorov.ru    Sun Mar 28 19:27:26 2021
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Sun Mar 28 19:27:26 2021
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sun Mar 28 19:27:29 2021
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
--- end of diff output ---

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

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