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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-16 01:27:03
DTS_END                         2020-12-16 01:27:03.6750
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/39358
TRN_ID                          256054
ATT_ID                          675
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: 9906.54 18269 1188785
customer order: creation 186.33 338 22360
customer order: refuse 15.70 310 1884
order to supplier: creation 49.04 1154 5885
order to supplier: removal 3.64 79908 437
invoice (draft): creation 48.98 2879 5877
invoice (draft): removal 55.43 645 6652
invoice accept: apply 45.68 16271 5481
invoice accept: cancel 50.52 625 6062
customer reserve: creation 4178.41 164 501409
customer reserve: removal 4955.79 46 594695
realization accept: apply 92.48 151 11098
realization accept: cancel 85.77 100 10292
payment from customer: creation 63.08 98 7569
payment from customer: removal 6.28 63 753
payment to supplier: creation 52.33 101 6279
payment to supplier: removal 4.04 88 485
service: total inventory turnovers 5.32 949 638
service: total monetary turnovers 6.83 38 819
service: aggregate perf. data 0.88 19772 106
service: refresh index statistics 0.03 241671 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-12-2020 01:27:53 to 16-12-2020 01:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9061
TEST_TIME 2 9835
TEST_TIME 3 9698
TEST_TIME 4 8187
TEST_TIME 5 7745
TEST_TIME 6 7349
TEST_TIME 7 7203
TEST_TIME 8 7233
TEST_TIME 9 7262
TEST_TIME 10 7643
TEST_TIME 11 7638
TEST_TIME 12 8000
TEST_TIME 13 8701
TEST_TIME 14 8929
TEST_TIME 15 9354
TEST_TIME 16 9617
TEST_TIME 17 10004
TEST_TIME 18 10380
TEST_TIME 19 10595
TEST_TIME 20 10621
TEST_TIME 21 11359
TEST_TIME 22 12266
TEST_TIME 23 12293
TEST_TIME 24 12093
TEST_TIME 25 12049
TEST_TIME 26 11671
TEST_TIME 27 11551
TEST_TIME 28 11464
TEST_TIME 29 11396
TEST_TIME 30 11398
TEST_TIME 31 11350
TEST_TIME 32 11198
TEST_TIME 33 11066
TEST_TIME 34 11064
TEST_TIME 35 11103
TEST_TIME 36 11170
TEST_TIME 37 10997
TEST_TIME 38 10892
TEST_TIME 39 10657
TEST_TIME 40 10625
TEST_TIME 41 10869
TEST_TIME 42 10792
TEST_TIME 43 10738
TEST_TIME 44 10718
TEST_TIME 45 10619
TEST_TIME 46 10699
TEST_TIME 47 10920
TEST_TIME 48 10874
TEST_TIME 49 10918
TEST_TIME 50 10966
TEST_TIME 51 11104
TEST_TIME 52 11106
TEST_TIME 53 11039
TEST_TIME 54 10921
TEST_TIME 55 10803
TEST_TIME 56 10789
TEST_TIME 57 10749
TEST_TIME 58 10666
TEST_TIME 59 10634
TEST_TIME 60 10581
TEST_TIME 61 10544
TEST_TIME 62 10456
TEST_TIME 63 10359
TEST_TIME 64 10332
TEST_TIME 65 10367
TEST_TIME 66 10323
TEST_TIME 67 10351
TEST_TIME 68 10343
TEST_TIME 69 10338
TEST_TIME 70 10339
TEST_TIME 71 10337
TEST_TIME 72 10583
TEST_TIME 73 10575
TEST_TIME 74 10513
TEST_TIME 75 10566
TEST_TIME 76 10509
TEST_TIME 77 10588
TEST_TIME 78 10539
TEST_TIME 79 10438
TEST_TIME 80 10423
TEST_TIME 81 10369
TEST_TIME 82 10310
TEST_TIME 83 10241
TEST_TIME 84 10222
TEST_TIME 85 10206
TEST_TIME 86 10167
TEST_TIME 87 10129
TEST_TIME 88 10102
TEST_TIME 89 10150
TEST_TIME 90 10133
TEST_TIME 91 10187
TEST_TIME 92 10202
TEST_TIME 93 10196
TEST_TIME 94 10194
TEST_TIME 95 10197
TEST_TIME 96 10153
TEST_TIME 97 10240
TEST_TIME 98 10256
TEST_TIME 99 10248
TEST_TIME 100 10255
TEST_TIME 101 10184
TEST_TIME 102 10134
TEST_TIME 103 10164
TEST_TIME 104 10111
TEST_TIME 105 10079
TEST_TIME 106 10048
TEST_TIME 107 10001
TEST_TIME 108 9964
TEST_TIME 109 9908
TEST_TIME 110 9942
TEST_TIME 111 9946
TEST_TIME 112 9931
TEST_TIME 113 9932
TEST_TIME 114 9924
TEST_TIME 115 9985
TEST_TIME 116 9963
TEST_TIME 117 9995
TEST_TIME 118 10015
TEST_TIME 119 9981
TEST_TIME 120 9910

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-12-2020 01:27:56 to 16-12-2020 01:28:00.

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 1653444 1653444 0 0.00 0 22479 5 0 0
doc_list_biud 1653443 1653443 0 0.00 0 31056 22 0 0
sp_add_invoice_to_stock 5656 5481 175 3.09 37 152289 16272 0 175
sp_cancel_adding_invoice 6062 6062 0 0.00 4 40719 626 0 0
sp_cancel_client_order 1884 1884 0 0.00 4 12725 311 0 0
sp_cancel_customer_reserve 594695 594695 0 0.00 1 31057 47 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 2 4110 64 0 0
sp_cancel_pay_to_supplier 485 485 0 0.00 2 4842 89 0 0
sp_cancel_supplier_invoice 6669 6652 17 0.25 1 14515 646 0 17
sp_cancel_supplier_order 437 437 0 0.00 6 925423 79909 0 0
sp_cancel_write_off 10292 10292 0 0.00 1 27388 101 0 0
sp_client_order 22360 22360 0 0.00 3 19873 338 0 0
sp_customer_reserve 501409 501409 0 0.00 0 74219 164 0 0
sp_fill_shopping_cart 34116 34116 0 0.00 1 21366 33 0 0
sp_fill_shopping_cart_clo_res 501394 501394 0 0.00 0 15670 13 0 0
sp_get_clo_for_invoice 5466 5466 0 0.00 0 28367 283 0 0
sp_kill_cost_storno 17592 17592 0 0.00 0 4913 39 0 0
sp_kill_qstorno_ret_qs2qd 1206771 1206771 0 0.00 0 31052 25 0 0
sp_kill_qty_storno 636586 636586 0 0.00 0 31056 55 0 0
sp_lock_selected_doc 22801 22801 0 0.00 0 10703 6 0 0
sp_make_cost_storno 30412 30412 0 0.00 0 16185 39 0 0
sp_multiply_rows_for_pdistr 30412 30412 0 0.00 0 6313 21 0 0
sp_multiply_rows_for_qdistr 22360 22360 0 0.00 0 15186 157 0 0
sp_pay_from_customer 7569 7569 0 0.00 4 14616 99 0 0
sp_pay_to_supplier 6279 6279 0 0.00 4 14417 102 0 0
sp_payment_common 13848 13848 0 0.00 1 14608 25 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 12711 273 0 0
sp_qd_handle_on_invoice_upd_sts 11528 11528 0 0.00 0 19427 262 0 0
sp_qd_handle_on_reserve_upd_sts 11098 11098 0 0.00 0 15800 58 0 0
sp_reserve_write_off 11098 11098 0 0.00 6 16209 152 0 0
sp_supplier_invoice 5877 5877 0 0.00 6 76481 2879 0 0
sp_supplier_order 5885 5885 0 0.00 5 35054 1155 0 0
srv_aggregate_perf_data 106 106 0 0.00 3025 621857 19772 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1041 146582 35354 0 0
srv_find_qd_qs_mism 1137479 1137479 0 0.00 0 22462 5 0 0
srv_make_invnt_saldo 638 638 0 0.00 18 45900 949 0 0
srv_make_money_saldo 819 819 0 0.00 1 10278 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 136059 326933 241672 0 0
t$perf-abend:sp_add_invoice_to_stock 175 175 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5481 5481 0 0.00 0 12704 143 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 9750 99 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 8964 22 0 0
t$perf-norm:sp_cancel_customer_reserve 766 766 0 0.00 0 3348 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 4748 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 485 485 0 0.00 0 382 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 2592 17 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 32257 1313 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 546 4 0 0
t$perf-norm:sp_client_order 22360 22360 0 0.00 0 10879 14 0 0
t$perf-norm:sp_customer_reserve 1106 1106 0 0.00 0 1640 4 0 0
t$perf-norm:sp_pay_from_customer 7569 7569 0 0.00 0 5046 9 0 0
t$perf-norm:sp_pay_to_supplier 6279 6279 0 0.00 0 10201 15 0 0
t$perf-norm:sp_reserve_write_off 11098 11098 0 0.00 0 11105 13 0 0
t$perf-norm:sp_supplier_invoice 5877 5877 0 0.00 0 7616 17 0 0
t$perf-norm:sp_supplier_order 5885 5885 0 0.00 0 9623 16 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 1208 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 431 8 0 0
t$perf-norm:srv_make_invnt_saldo 638 638 0 0.00 0 649 16 0 0
t$perf-norm:srv_make_money_saldo 819 819 0 0.00 0 1090 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 4 0 0
v_add_invoice_to_stock 11280 10930 350 3.10 0 7131 21 0 350
v_all_customers 40218 40218 0 0.00 0 47 0 0 0
v_all_suppliers 32384 32384 0 0.00 0 181 1 0 0
v_all_wares 44720 44720 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 4060 11 0 0
v_cancel_client_order 3768 3768 0 0.00 0 3855 5 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 4015 9 0 0
v_cancel_customer_reserve 1532 1532 0 0.00 0 1268 5 0 0
v_cancel_payment_to_supplier 970 970 0 0.00 0 4815 20 0 0
v_cancel_supplier_invoice 872 838 34 3.89 0 5983 28 0 34
v_cancel_supplier_order 874 874 0 0.00 0 594 4 0 0
v_cancel_write_off 2124 2124 0 0.00 0 3411 17 0 0
v_max_id_clo_ord 5885 5885 0 0.00 0 3419 2 0 0
v_max_id_clo_res 1106 1106 0 0.00 0 4414 17 0 0
v_max_id_ord_sup 5871 5871 0 0.00 0 2641 3 0 0
v_max_non_paid_invoice 1843 1843 0 0.00 0 1530 3 0 0
v_max_non_paid_realizn 4185 4185 0 0.00 0 3098 3 0 0
v_min_id_clo_ord 5885 5885 0 0.00 0 3851 5 0 0
v_min_id_clo_res 1106 1106 0 0.00 0 4117 6 0 0
v_min_id_ord_sup 5871 5871 0 0.00 0 9227 6 0 0
v_min_non_paid_invoice 6279 6279 0 0.00 0 14371 13 0 0
v_min_non_paid_realizn 7569 7569 0 0.00 0 14594 13 0 0
v_our_firm 11270 11270 0 0.00 0 12 1 0 0
v_reserve_write_off 22196 22196 0 0.00 0 4896 7 0 0
x_lock_depdocs_on_canc_invoice 12295 12295 0 0.00 0 29169 91 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 18915 350 0 0
x_make_qstorno_1000_1200 5885 5885 0 0.00 1 35026 1084 0 0
x_make_qstorno_1200_2000 5877 5877 0 0.00 3 73386 2765 0 0
x_make_qstorno_2100_3300 501409 501409 0 0.00 0 74212 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-12-2020 01:28:01 to 16-12-2020 01:28:05.

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
22:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 12882 8192000000 10198426096 10503299072 878898576 9.689 70 60 120 0 902218272 2534416 20785280
22:57:36 20398 8192000000 10289219904 10600914944 1351827168 14.164 100 87 172 1 1384285840 4059584 28399088
22:58:07 21720 8192000000 10338359904 10652327936 1379252128 14.410 100 86 172 0 1413526064 5528800 28745136
22:58:39 16211 8192000000 10347179536 10666037248 1405355888 14.643 100 89 177 1 1441239488 6668288 29215312
22:59:09 15183 8192000000 10382272736 10702766080 1427366336 14.838 100 90 181 2 1464872208 7562688 29943184
22:59:34 23240 8192000000 10394780624 10723774464 1444756016 14.992 100 89 176 2 1482104848 8266400 29082432
23:00:07 24952 8192000000 10421351552 10751492096 1470390816 15.217 100 88 176 0 1507669248 8915616 28362816
23:00:40 9791 8192000000 10433583936 10769895424 1482716032 15.325 100 73 146 0 1515295408 9262112 23317264
23:00:58 15619 8192000000 10448731456 10792984576 1506813152 15.536 100 77 154 0 1541055184 9847952 24394080
23:01:23 15640 8192000000 10496723872 10845425664 1549723824 15.908 100 84 167 2 1585154816 9618416 25812576
23:01:49 11050 8192000000 10513633056 10862575616 1572647184 16.105 100 82 164 1 1608961424 11172992 25141248
23:02:09 11641 8192000000 10537248448 10891743232 1587697696 16.234 100 82 162 2 1624316208 11614224 25004288
23:02:28 15463 8192000000 10567272032 10930499584 1626058544 16.561 100 76 150 1 1660740816 11788128 22894144
23:02:55 9159 8192000000 10606128352 10967781376 1655483920 16.811 100 77 154 0 1690631376 11763536 23383920
23:03:14 11125 8192000000 10628843968 10994802688 1682650976 17.040 100 82 162 2 1719453456 12886512 23915968
23:03:33 7962 8192000000 10646823248 11015458816 1703230032 17.212 100 77 155 1 1738901248 12962240 22708976
23:03:48 5872 8192000000 10648158656 11023167488 1713085504 17.295 100 78 156 0 1749293200 13131472 23076224
23:04:02 5014 8192000000 10665353664 11041099776 1729149840 17.428 100 77 153 4 1762008960 11614448 21244672
23:04:14 5483 8192000000 10677258480 11054542848 1741117696 17.528 100 78 156 0 1775255040 12261744 21875600
23:04:27 4715 8192000000 10691790832 11069853696 1756079648 17.652 100 85 169 0 1792864320 13067232 23717440
23:04:38 5039 8192000000 10699438176 11077648384 1763930720 17.717 100 82 163 0 1799413280 13255568 22226992
23:04:50 5562 8192000000 10711066800 11088302080 1771997792 17.784 100 88 177 2 1811040160 14363328 24679040
23:05:02 3636 8192000000 10718217040 11096014848 1781607392 17.863 100 88 176 0 1820003408 14463760 23932256
23:05:13 3030 8192000000 10735708240 11115122688 1792006800 17.948 100 85 167 0 1829385152 14681264 22697088
23:05:23 3356 8192000000 10739208912 11119984640 1798584416 18.002 100 85 170 1 1836314384 14244672 23485296
23:05:32 3133 8192000000 10746542016 11128623104 1804794144 18.053 100 85 170 1 1841475472 13403920 23277408
23:05:42 2350 8192000000 10758941664 11138584576 1812915952 18.120 100 93 185 3 1852696496 13567344 26213200
23:05:51 4420 8192000000 10752201600 11139305472 1815163120 18.138 100 70 138 2 1846919984 13091056 18665808
23:06:03 4671 8192000000 10759284800 11150139392 1818522528 18.166 100 74 148 0 1853141552 13763696 20855328
23:06:14 1499 8192000000 10781593072 11166523392 1839206816 18.334 100 95 190 1 1880543232 14475408 26861008
23:06:22 1907 8192000000 10787182304 11171016704 1842150032 18.358 100 93 186 5 1882230176 13656816 26423328
23:06:30 2039 8192000000 10792445584 11178856448 1846855136 18.397 100 90 179 2 1886163696 13870128 25438432
23:06:39 1587 8192000000 10792604272 11182809088 1852438496 18.442 100 93 186 2 1891408720 13070832 25899392
23:06:47 2009 8192000000 10808085952 11194900480 1859072960 18.496 100 95 190 0 1899857760 13259456 27525344
23:06:55 1199 8192000000 10809408896 11197235200 1866931968 18.559 100 93 186 0 1906990576 13717632 26340976
23:07:03 947 8192000000 10810746912 11201933312 1869434288 18.580 100 93 187 0 1909494112 12990144 27069680
23:07:11 13143 8192000000 10804389232 11201318912 1869971456 18.584 100 70 141 0 1898484544 10082816 18430272
23:07:30 2929 8192000000 10793146464 11203850240 1871908048 18.600 100 65 128 1 1900829472 11337024 17584400
23:07:40 3213 8192000000 10795399712 11204300800 1871463088 18.596 100 57 114 1 1897804608 10369824 15971696
23:07:51 2535 8192000000 10794144848 11207602176 1870229472 18.586 100 46 91 0 1895458608 13028672 12200464
23:08:00 4830 8192000000 10787015632 11208220672 1870976880 18.592 100 39 76 1 1895574640 12990160 11607600
23:08:13 10141 8192000000 10781539600 11205615616 1874074128 18.617 100 40 80 0 1894477712 8584112 11819472
23:08:30 10962 8192000000 10776792496 11206242304 1873595184 18.613 100 21 40 3 1885207696 5955888 5656624
23:08:51 12010 8192000000 10785446880 11218759680 1880185968 18.667 100 19 38 1 1891876944 6630240 5060736
23:09:11 17150 8192000000 10802990160 11222192128 1885352160 18.708 100 33 67 2 1900303056 5772016 9178880
23:09:35 57475 8192000000 10834315280 11237986304 1891293504 18.756 100 58 117 1 1914487504 5815792 17378208
23:10:39 10693 8192000000 10797173952 11234811904 1890960064 18.754 100 20 40 0 1903136880 6595072 5581744
23:10:59 7817 8192000000 10817987408 11244331008 1900240368 18.828 100 35 70 1 1917029104 7152528 9636208
23:11:13 4636 8192000000 10816684944 11246301184 1899776976 18.824 100 30 59 1 1915516272 7712336 8026960
23:11:27 3295 8192000000 10818608704 11250655232 1903882560 18.858 100 33 66 1 1921317040 8431104 9003376
23:11:38 6074 8192000000 10815758928 11250606080 1906749152 18.881 100 28 56 1 1921308256 6663440 7895664
23:11:50 6780 8192000000 10827482960 11256885248 1910931712 18.914 100 37 72 0 1927060832 5382368 10746752
23:12:03 10339 8192000000 10826161536 11258736640 1915230032 18.949 100 23 45 0 1927886336 5695536 6960768
23:12:23 3799 8192000000 10820868752 11256737792 1913954624 18.938 100 31 62 2 1927641952 5217648 8469680
23:12:33 12242 8192000000 10833158192 11265654784 1919378880 18.982 100 23 46 0 1931579856 5863296 6337680
23:12:52 10273 8192000000 10842485296 11271733248 1922051184 19.003 100 26 52 3 1936104464 6284704 7768576
23:13:12 12514 8192000000 10827194192 11270725632 1920589488 18.992 100 16 33 2 1931548144 5363936 5594720
23:13:30 10204 8192000000 10830223440 11267817472 1904654928 18.864 99 24 47 1 1917100512 5346800 7098784
23:13:47 7906 8192000000 10836588448 11272531968 1924321200 19.021 100 25 48 2 1937407952 5974544 7112208
23:14:01 26368 8192000000 10829565248 11273494528 1888296080 18.732 98 22 43 0 1899965760 5005840 6663840
23:15:11 20198 8192000000 10836182032 11278655488 1928018368 19.051 100 23 45 1 1940856368 6673600 6164400
23:15:39 4271 8192000000 10824425152 11267137536 1904467216 18.862 99 18 36 3 1914878112 5574336 4836560
23:15:52 11299 8192000000 10823439680 11263033344 1902308480 18.845 99 26 49 4 1916423136 5956720 8157936
23:16:10 7816 8192000000 10809198944 11240640512 1866822864 18.559 98 22 44 1 1879108912 6024000 6262048
23:16:23 3544 8192000000 10831782528 11263676416 1909635984 18.904 100 29 59 0 1925127056 7652144 7838928
23:16:34 4136 8192000000 10836726144 11254874112 1904816736 18.865 100 36 72 0 1923548128 7953328 10778064
23:16:45 9521 8192000000 10817726544 11253956608 1890450672 18.749 99 27 52 2 1908474080 10980336 7043072
23:17:00 7535 8192000000 10792144720 11221032960 1832069136 18.276 97 26 52 2 1845093312 6158560 6865616
23:17:14 6236 8192000000 10785476448 11221094400 1875114832 18.626 100 28 54 1 1890209424 5538416 9556176
23:17:29 8356 8192000000 10782543680 11214254080 1844752432 18.379 98 31 62 0 1858611840 5160960 8698448
23:17:44 5934 8192000000 10740724928 11157499904 1698004608 17.168 91 23 46 1 1710229504 6080128 6144768
23:18:00 6767 8192000000 10746738848 11169460224 1793728416 17.962 97 16 32 0 1803938384 5592544 4617424
23:18:19 6503 8192000000 10718293728 11134468096 1739391952 17.514 95 30 58 1 1754298144 6116192 8790000
23:18:32 8666 8192000000 10695623488 11110518784 1698283840 17.171 94 26 52 1 1710979040 5650224 7044976
23:18:47 6083 8192000000 10726286096 11139239936 1779033936 17.842 99 33 66 1 1795184288 7133008 9017344
23:19:02 15545 8192000000 10704528240 11122049024 1725590144 17.399 95 29 58 1 1743358880 9527760 8240976
23:19:24 45718 8192000000 10699795760 11108499456 1744346256 17.555 96 26 52 0 1757820192 4791120 8682816
23:20:24 20882 8192000000 10706481872 11124240384 1715990096 17.319 95 35 70 2 1733226960 6993792 10243072
23:20:51 11540 8192000000 10691787344 11104931840 1725738848 17.400 96 24 50 3 1738090320 4987856 7363616
23:21:11 8844 8192000000 10737185056 11138912256 1762305872 17.703 98 26 52 1 1774982160 5270368 7405920
23:21:26 7835 8192000000 10722187632 11136585728 1786754672 17.905 99 26 50 0 1800439584 5943920 7740992
23:21:41 4536 8192000000 10733342400 11151441920 1814618048 18.134 100 26 52 1 1831084656 8600240 7866368
23:21:51 7973 8192000000 10735733328 11156992000 1822817136 18.201 100 34 67 2 1838630512 5556784 10256592
23:22:05 5290 8192000000 10744715392 11167780864 1833255888 18.286 100 33 65 1 1849513600 6640256 9617456
23:22:18 6450 8192000000 10748261968 11173625856 1831368592 18.270 100 16 32 1 1841613040 5845200 4399248
23:22:33 8650 8192000000 10748812560 11175264256 1826402384 18.230 99 27 54 0 1840179888 5767920 8009584
23:22:49 9097 8192000000 10760299056 11183947776 1842181648 18.359 100 14 28 0 1851832192 5156592 4493952
23:23:05 9002 8192000000 10777184480 11196698624 1855757600 18.469 100 37 73 4 1873421232 6332816 11330816
23:23:20 8564 8192000000 10768791344 11197227008 1855633312 18.468 100 18 36 0 1866069920 5170832 5265776
23:23:38 6075 8192000000 10768679760 11201925120 1859517040 18.499 100 25 50 2 1876504640 9783696 7203904
23:23:51 9380 8192000000 10781823552 11208675328 1862822000 18.526 100 24 49 0 1880094480 10035264 7237216
23:24:13 13098 8192000000 10775716000 11207237632 1865082864 18.544 100 17 34 1 1875547296 5342752 5121680
23:24:33 57461 8192000000 10788212112 11214553088 1868771072 18.574 100 21 39 2 1879981216 5322128 5888016
23:25:38 11892 8192000000 10788266096 11219566592 1873481424 18.612 100 28 57 1 1888067872 6368736 8217712
23:25:58 11689 8192000000 10790995264 11215560704 1874534672 18.621 100 27 53 1 1888708384 6276032 7897680
23:26:17 9140 8192000000 10803106688 11230044160 1876500464 18.637 100 29 58 0 1891611200 6735696 8375040
23:26:34 9277 8192000000 10785620352 11220631552 1879051280 18.657 100 36 72 0 1896133264 7003024 10078960
23:26:49 8467 8192000000 10788578912 11223224320 1878072128 18.650 100 20 40 1 1889527968 5628416 5827424
23:27:06 6438 8192000000 10825051008 11246452736 1895534320 18.790 100 28 56 0 1909446960 6215328 7697312
23:27:21 3593 8192000000 10849216688 11261214720 1910708416 18.912 100 48 95 1 1930627104 6653072 13265616
23:27:36 12181 8192000000 10842235568 11267911680 1919690304 18.984 100 49 98 1 1941934304 8287808 13956192
23:27:58 5684 8192000000 10861422560 11278561280 1925783456 19.033 100 56 110 2 1949264384 8526256 14954672
23:28:15 8493 8192000000 10842853088 11265302528 1914154944 18.940 99 48 96 1 1936041824 9336000 12550880
23:28:43 34696 8192000000 10869673840 11298930688 1935403392 19.110 100 47 94 3 1960438592 11629360 13405840
23:29:27 12445 8192000000 10872457904 11302502400 1941972336 19.162 100 43 85 1 1963562608 8989120 12601152
23:29:47 5618 8192000000 10882204512 11308449792 1948900176 19.218 100 56 110 1 1973403408 8276912 16226320
23:30:13 8729 8192000000 10895716064 11320152064 1956560528 19.279 100 55 109 3 1985202288 11890864 16750896
23:30:29 48757 8192000000 10888658304 11321593856 1926319232 19.037 98 58 115 1 1955950816 13000672 16630912
23:31:29 29081 8192000000 10893523248 11330682880 1951390784 19.238 99 42 85 0 1974729376 11318128 12020464
23:32:06 6731 8192000000 10902885296 11338354688 1971702304 19.399 100 42 84 1 2001191184 17266528 12222352
23:32:20 17593 8192000000 10907657152 11333734400 1951565472 19.239 99 48 95 0 1979459808 14193344 13700992
23:32:48 6364 8192000000 10930218064 11359936512 1975862736 19.432 100 54 108 2 2016622848 25226528 15533584
23:33:08 3155 8192000000 10917561952 11343024128 1971971728 19.401 100 62 122 2 2005258384 15134976 18151680
23:33:19 12485 8192000000 10920881568 11351019520 1976345824 19.436 100 58 112 1 2013932928 21115824 16471280
23:33:38 4774 8192000000 10915596304 11343724544 1971407008 19.397 100 49 97 1 2002796704 17552368 13837328
23:33:52 11302 8192000000 10910514224 11342188544 1971236976 19.395 100 55 109 0 2005375184 18382016 15756192
23:34:11 8954 8192000000 10921371488 11353526272 1973875872 19.416 100 51 103 0 2010619984 21915184 14828928
23:34:30 11926 8192000000 10902805136 11332259840 1956995680 19.282 99 51 102 2 1992335888 20044624 15295584
23:34:49 9237 8192000000 10932690128 11359969280 1981826320 19.479 100 57 113 2 2020017296 20725216 17465760
23:35:12 9628 8192000000 10917311280 11352031232 1975252336 19.427 100 47 94 0 2011913536 22136112 14525088
23:35:29 5118 8192000000 10914548288 11349278720 1957431536 19.286 99 46 91 1 1994689920 22888784 14369600
23:35:41 9191 8192000000 10907198416 11325423616 1933291056 19.093 98 53 104 0 1969709792 20826736 15592000
23:35:57 5165 8192000000 10944329328 11359256576 1977387456 19.444 100 77 153 3 2023313680 23307248 22618976
23:36:18 3196 8192000000 10940389104 11360210944 1969738000 19.383 99 67 134 1 2016287376 26730480 19818896
23:36:27 4241 8192000000 10931232848 11356262400 1973387968 19.412 100 57 113 2 2017426368 27375008 16663392
23:36:46 2660 8192000000 10938440704 11355926528 1972076992 19.402 100 73 144 1 2023494896 29964640 21453264
23:36:55 4024 8192000000 10928341840 11353149440 1958405168 19.293 99 63 126 1 2006208208 28797952 19005088
23:37:09 3409 8192000000 10938644416 11360096256 1975984480 19.433 100 71 141 0 2026758080 29640064 21133536
23:37:20 3047 8192000000 10935178960 11355602944 1972143360 19.402 100 85 171 1 2029068528 31180432 25744736
23:37:30 11698 8192000000 10920531744 11342970880 1963401008 19.333 100 64 128 3 2012027504 28378768 20247728
23:37:51 4910 8192000000 10903915728 11331354624 1951282256 19.237 99 52 104 1 1995177104 27352928 16541920
23:38:03 7624 8192000000 10929200048 11350364160 1962853216 19.329 100 59 115 0 2013418944 32702368 17863360
23:38:20 8748 8192000000 10920366080 11344011264 1962046704 19.322 100 72 144 1 2014475136 30418224 22010208
23:38:38 5167 8192000000 10923221440 11344031744 1962165696 19.323 100 71 142 2 2014919552 30584400 22169456
23:38:52 4532 8192000000 10924954896 11336122368 1938281120 19.133 99 78 156 0 1994532880 32672288 23579472
23:39:04 3020 8192000000 10926533744 11336085504 1941989776 19.163 99 87 175 0 2003531872 34279440 27262656
23:39:15 2071 8192000000 10931028400 11341725696 1957250416 19.284 100 82 164 1 2017612560 35179344 25182800
23:39:31 5963 8192000000 10918330000 11340537856 1939563744 19.143 99 67 134 0 1997005456 36638640 20803072
23:39:48 3714 8192000000 10895668672 11313057792 1906893024 18.882 98 64 127 1 1964079568 37801184 19385360
23:39:59 3030 8192000000 10895461312 11304513536 1916326928 18.957 99 68 133 2 1976669904 38866464 21476512
23:40:11 2147 8192000000 10926016704 11336028160 1948377232 19.214 100 83 166 1 2011934432 37682032 25875168
23:40:20 2051 8192000000 10929342096 11340992512 1948433408 19.214 100 90 177 1 2012895488 37233728 27228352
23:40:29 1839 8192000000 10929376688 11335757824 1945083920 19.187 100 84 164 0 2009980560 40336688 24559952
23:40:40 2504 8192000000 10922666704 11335671808 1940650352 19.152 100 72 138 1 2000858272 39413344 20794576
23:40:51 8644 8192000000 10916935632 11339640832 1947943472 19.210 100 61 122 2 2007548272 40102672 19502128
23:41:06 6944 8192000000 10922740688 11353313280 1956968256 19.282 100 48 96 0 2008557856 36237280 15352320
23:41:21 3401 8192000000 10913702208 11335667712 1923269056 19.013 98 66 130 0 1976384464 32639280 20476128
23:41:32 6216 8192000000 10924080144 11340136448 1948813648 19.217 100 70 137 0 2005867648 36167056 20886944
23:41:47 1038 8192000000 10933069952 11337760768 1945612656 19.192 99 80 158 1 2005825984 35829360 24383968
23:41:55 5812 8192000000 10933007264 11352256512 1955133664 19.267 100 72 144 1 2016720784 38706656 22880464
23:42:10 5171 8192000000 10940247744 11358748672 1961505264 19.318 100 72 143 7 2023314144 39732864 22076016
23:42:23 7066 8192000000 10934116784 11367395328 1965933648 19.353 100 58 116 1 2024227328 39758288 18535392
23:42:57 10423 8192000000 10915376048 11345752064 1920787888 18.993 98 41 82 1 1973811136 39505872 13517376
23:43:22 11904 8192000000 10881503504 11325071360 1888441536 18.733 97 32 62 4 1937626976 37859200 11326240
23:43:45 12304 8192000000 10909514848 11333337088 1929256192 19.061 100 48 97 2 1982836288 37955776 15624320
23:44:05 4862 8192000000 10923568928 11351937024 1952441072 19.246 100 65 129 1 2011543632 37661664 21440896
23:44:16 2442 8192000000 10932139664 11346432000 1951497808 19.238 100 68 130 0 2007343184 35894448 19950928
23:44:25 11353 8192000000 10907109520 11342397440 1942629472 19.168 100 37 74 1 1991884064 37352960 11901632
23:44:42 21477 8192000000 10928321024 11370307584 1960416528 19.309 100 36 72 0 2016236832 43811280 12009024
23:45:11 24742 8192000000 10901695968 11350429696 1956644640 19.279 100 33 66 2 1996650288 29025008 10980640
23:46:33 24390 8192000000 10894052320 11338063872 1936118624 19.116 100 24 48 0 1978811648 34226400 8466624
23:47:33 39615 8192000000 10895168224 11354796032 1934090784 19.100 100 21 42 0 1982182128 40228144 7863200
23:48:23 69801 8192000000 10849320880 11310383104 1811425104 18.108 94 9 18 0 1848755808 33916464 3414240
23:49:41 53774 8192000000 10842965232 11288653824 1865368656 18.547 97 18 35 3 1884322944 13950720 5003568
23:50:41 44278 8192000000 10849427792 11314954240 1915674816 18.952 100 12 24 1 1937196800 18307104 3214880
23:51:32 78769 8192000000 10866111904 11317346304 1892147744 18.763 98 10 20 1 1912079824 17131232 2800848
23:52:59 37462 8192000000 10895455328 11322875904 1924050784 19.019 99 47 95 1 1944393056 7395872 12946400
23:53:55 58648 8192000000 10862020048 11325968384 1948444624 19.214 100 56 112 2 1974153264 10332880 15375760
23:55:33 140288 8192000000 10900304736 11341242368 1895385232 18.789 97 34 68 0 1913780592 9002192 9393168
23:58:00 121623 8192000000 10893544176 11347742720 1889546336 18.742 96 28 56 0 1905233712 7898560 7788816
00:00:33 15029 8192000000 10895871184 11349823488 1961547920 19.318 99 17 34 0 1980067152 13495024 5024208
00:00:54 58181 8192000000 10907636944 11366068224 1937427744 19.126 98 35 70 0 1965065344 17016128 10621472
00:01:59 50457 8192000000 10907840288 11372851200 1969489120 19.381 100 15 30 0 1998529632 24011600 5028912
00:02:55 37385 8192000000 10895233088 11376877568 1972171168 19.403 100 10 20 0 1995848080 20510160 3166752
00:03:42 35678 8192000000 10894781056 11374006272 1951790912 19.241 99 12 24 0 1973603072 18332688 3479472
00:04:24 18521 8192000000 10891494144 11360710656 1966341472 19.356 100 12 24 0 1985978128 16162144 3474512
00:05:47 104808 8192000000 10909150480 11379257344 1965099872 19.347 99 17 34 1 1989263808 18681904 5482032
00:07:38 67436 8192000000 10897910000 11393150976 1977810880 19.447 100 17 34 0 2000059808 17366592 4882336
00:08:54 64025 8192000000 10918216528 11389317120 1992143504 19.561 100 23 46 0 2006296912 8288784 5864624
00:10:06 50864 8192000000 10934545440 11393810432 1997879040 19.606 100 15 27 1 2010191472 8601488 3710944
00:11:08 28954 8192000000 10942239344 11404435456 1996965376 19.599 99 42 83 1 2025752016 17269536 11517104
00:11:46 50753 8192000000 10928449040 11399905280 1974573664 19.422 98 27 54 0 2003550528 21005808 7971056
00:12:49 46849 8192000000 10939424432 11421790208 1986830032 19.519 99 13 26 0 2016770368 25989200 3951136
00:14:39 101215 8192000000 10942201520 11396386816 1942730496 19.169 97 22 42 2 1961781056 13663264 5387296
00:16:31 55044 8192000000 10918414768 11397525504 1952881056 19.249 98 25 50 0 1984188112 23831536 7475520
00:17:34 56495 8192000000 10888685040 11382464512 1896069344 18.795 96 10 18 0 1919714640 21200080 2445216
00:18:54 113015 8192000000 10885845024 11352989696 1837720672 18.322 93 17 34 0 1855618224 13670544 4227008
00:21:05 111093 8192000000 10889739776 11357073408 1948993488 19.218 99 31 62 0 1967706688 9995680 8717520
00:23:07 51113 8192000000 10903683616 11365658624 1938232752 19.133 98 33 65 2 1959371520 11966272 9172496
00:24:14 31191 8192000000 10888622768 11351334912 1956488992 19.278 100 20 38 2 1971427552 8281376 6657184
00:24:52 16325 8192000000 10877113920 11325186048 1898579424 18.815 97 29 56 2 1913417056 7124816 7712816
00:25:18 23908 8192000000 10861553952 11312570368 1908873312 18.898 98 54 106 0 1932682320 8646320 15162688
00:25:53 43793 8192000000 10859115760 11325378560 1917777872 18.969 99 12 24 1 1927965344 6825200 3362272
00:26:43 50243 8192000000 10874949056 11335630848 1921513984 18.999 99 16 32 1 1936363920 11077888 3772048
00:27:42 44612 8192000000 10851764976 11320422400 1867732528 18.566 95 17 34 1 1879322464 6652080 4937856
00:28:34 37043 8192000000 10833983264 11301187584 1914884640 18.946 99 7 14 0 1922415312 6191184 1339488
00:29:27 37920 8192000000 10841008224 11311386624 1913968496 18.938 99 7 14 0 1921625264 5876048 1780720
00:30:11 26422 8192000000 10850471184 11319840768 1934610592 19.104 100 8 16 1 1947455568 10984816 1860160
00:30:47 23271 8192000000 10828380736 11300130816 1881733664 18.679 97 8 16 1 1892867488 9423424 1710400
00:31:18 58088 8192000000 10849622864 11309563904 1838797104 18.331 95 13 26 0 1855302752 13456144 3049504
00:32:22 43812 8192000000 10858102896 11333627904 1895484192 18.790 98 18 36 0 1912122208 11579440 5058576
00:33:12 38547 8192000000 10884859360 11346358272 1925561600 19.031 99 17 34 1 1940084160 9696496 4826064
00:34:01 28063 8192000000 10862171440 11321012224 1896402928 18.797 97 42 84 0 1923783424 15753744 11626752
00:34:38 75950 8192000000 10891178976 11353677824 1911812080 18.921 98 19 38 0 1940605488 23193600 5599808
00:36:00 37332 8192000000 10873426112 11336761344 1888951184 18.737 97 18 36 2 1915846480 21394144 5501152
00:36:44 57282 8192000000 10859604608 11320020992 1903082480 18.851 98 18 36 0 1930002112 21910832 5008800
00:37:47 68462 8192000000 10868697008 11338985472 1896545408 18.798 98 15 31 1 1934612608 33293408 4773792
00:39:07 48369 8192000000 10858555776 11319037952 1873606800 18.613 97 11 20 2 1894625712 17435584 3583328
00:40:06 55246 8192000000 10854283696 11310665728 1890340736 18.749 98 23 46 2 1906604000 10299056 5964208
00:41:07 8200 8192000000 10881053120 11320373248 1942011920 19.163 100 65 125 1 1968454176 7279968 19162288
00:41:22 10710 8192000000 10893673680 11322552320 1924544192 19.023 99 58 116 2 1951236432 10035696 16656544
00:41:40 11329 8192000000 10886818960 11330211840 1942819008 19.169 100 50 100 1 1967001744 10605568 13577168
00:42:00 14757 8192000000 10878095888 11315879936 1887878080 18.729 97 44 88 1 1911919632 11784064 12257488
00:42:23 63378 8192000000 10856963440 11323019264 1912532096 18.927 99 34 68 1 1935109600 13373600 9203904
00:43:43 34014 8192000000 10895489120 11345367040 1951360112 19.237 100 44 88 0 1976706960 12516528 12830320
00:45:02 146582 8192000000 10883930128 11359617024 1938289888 19.133 99 21 42 0 1955148032 11192880 5665264
00:47:42 44696 8192000000 10889698736 11366113280 1958865296 19.297 100 12 24 0 1981029392 19230544 2933552
00:48:33 6480 8192000000 10889387184 11362693120 1958499824 19.294 100 9 17 1 1978498048 17607344 2390880
00:48:46 30625 8192000000 10873462512 11346370560 1943719760 19.176 99 17 34 0 1953876512 5316752 4840000
00:49:24 54576 8192000000 10873155536 11347492864 1943506928 19.175 99 10 20 0 1954750544 8659936 2583680
00:50:29 74955 8192000000 10879974752 11353518080 1944805952 19.185 99 17 34 1 1960907568 11218144 4883472
00:51:50 90909 8192000000 10869539776 11352305664 1942524624 19.167 99 11 22 0 1960031264 14573952 2932688
00:53:35 85159 8192000000 10893311472 11366965248 1945136112 19.188 99 12 24 1 1957147920 8512336 3499472
00:55:39 60721 8192000000 10888691344 11359277056 1948348784 19.213 99 19 38 0 1965893136 12085888 5458464
00:56:53 62474 8192000000 10881770032 11346202624 1940424160 19.150 98 24 47 1 1955778976 9081008 6273808
00:58:06 62151 8192000000 10914222160 11396349952 1985981968 19.512 100 15 30 1 2003529280 13200112 4347200
00:59:14 75986 8192000000 10869492656 11329777664 1838516816 18.329 93 11 22 1 1855433056 14281552 2634688
01:00:37 54359 8192000000 10898898976 11354054656 1906043744 18.875 97 24 48 1 1922451104 10063984 6343376
01:01:40 52259 8192000000 10873319104 11335966720 1879263296 18.659 96 30 60 2 1905982880 18002416 8717168
01:02:56 11002 8192000000 10914615600 11362103296 1959527904 19.302 100 50 98 1 1982422288 9062672 13831712
01:03:21 47903 8192000000 10892963248 11345711104 1887562272 18.726 96 46 92 2 1918422528 18339472 12520784
01:04:22 56855 8192000000 10881439024 11334987776 1898668896 18.816 97 33 66 2 1917668464 10028448 8971120
01:05:29 70582 8192000000 10894896128 11345883136 1897740256 18.808 97 25 49 2 1917086912 12643264 6703392
01:06:50 35437 8192000000 10889163184 11356495872 1939291696 19.141 99 40 80 1 1961057280 10903184 10862400
01:07:37 81652 8192000000 10892421600 11350802432 1926185984 19.036 98 26 52 0 1943958176 10215696 7556496
01:09:09 69487 8192000000 10879296976 11351035904 1959386752 19.301 100 42 83 2 1983645040 12183440 12074848
01:10:27 80229 8192000000 10849593264 11325005824 1839132448 18.334 94 11 22 1 1860419872 18277280 3010144
01:11:54 18472 8192000000 10862040832 11334127616 1925197936 19.028 100 7 14 0 1943690368 17063664 1428768
01:12:20 14497 8192000000 10843943936 11313881088 1919260992 18.981 99 8 16 0 1938945744 17059024 2625728
01:12:40 47196 8192000000 10831280176 11302481920 1867021760 18.560 96 14 29 0 1879430256 8206272 4202224
01:13:34 53249 8192000000 10841990912 11314270208 1900605056 18.831 98 8 16 1 1910684880 7956512 2123312
01:14:33 29617 8192000000 10861266704 11336904704 1943271024 19.173 100 9 18 0 1956978144 11203520 2503600
01:15:34 63985 8192000000 10844606928 11312893952 1895410576 18.789 98 9 18 0 1912150704 13776704 2963424
01:17:19 42556 8192000000 10867669776 11305701376 1903811664 18.857 99 19 36 1 1916169296 7336720 5020912
01:18:08 58770 8192000000 10861851696 11328761856 1901155568 18.836 98 12 24 0 1911998000 7495952 3346480
01:19:23 39020 8192000000 10864549424 11331252224 1912203936 18.924 98 21 41 3 1930870608 11206224 7460448
01:20:12 72553 8192000000 10857473904 11327295488 1866634944 18.557 96 22 44 0 1885611344 12916544 6059856
01:21:31 59723 8192000000 10865280624 11330572288 1933776064 19.097 100 20 40 0 1956024320 16552624 5695632
01:22:38 136356 8192000000 10866433344 11340996608 1869606848 18.581 96 23 46 0 1890401184 13984992 6809344
01:25:01 78306 8192000000 10856390688 11305623552 1848509296 18.410 95 22 44 2 1866102880 11631344 5962240
01:26:28 34955 8192000000 10866769552 11311927296 1858975216 18.495 96 51 102 0 1882372096 8719728 14677152

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 16-12-2020 01:28:07 to 16-12-2020 01:28:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 175 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-12-2020 01:28:38 to 16-12-2020 01:28:40.

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          255223
MON$OLDEST_ACTIVE               256629
MON$OLDEST_SNAPSHOT             256629
MON$NEXT_TRANSACTION            256629
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                       2036320
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:129: 
:130: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:12 2020
:131:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:132: 
:133: 
:134: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:17 2020
:135:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:136: 
:137: 
:138: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:18 2020
:139:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:140: 
:141: 
:142: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:18 2020
:143:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:144: 
:145: 
:146: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:20 2020
:147:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:148: 
:149: 
:150: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:20 2020
:151:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Wed Dec 16 01:27:20 2020
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
--- end of diff output ---

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

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