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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-27 22:27:11
DTS_END                         2020-12-27 22:27:11.0070
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/59710
TRN_ID                          237943
ATT_ID                          691
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: 9166.04 24902 1099925
customer order: creation 161.93 384 19432
customer order: refuse 14.58 319 1750
order to supplier: creation 44.26 1181 5311
order to supplier: removal 3.53 107838 423
invoice (draft): creation 44.09 3420 5291
invoice (draft): removal 53.69 644 6443
invoice accept: apply 40.11 18529 4813
invoice accept: cancel 48.54 758 5825
customer reserve: creation 3730.23 181 447627
customer reserve: removal 4737.76 65 568531
realization accept: apply 79.00 189 9480
realization accept: cancel 83.95 120 10074
payment from customer: creation 56.76 138 6811
payment from customer: removal 5.27 69 632
payment to supplier: creation 47.13 151 5656
payment to supplier: removal 3.40 99 408
service: total inventory turnovers 4.68 1208 562
service: total monetary turnovers 6.34 29 761
service: aggregate perf. data 0.76 21302 91
service: refresh index statistics 0.03 341408 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-12-2020 22:28:37 to 27-12-2020 22:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 952
TEST_TIME 2 1930
TEST_TIME 3 3169
TEST_TIME 4 4464
TEST_TIME 5 3984
TEST_TIME 6 4280
TEST_TIME 7 5152
TEST_TIME 8 5459
TEST_TIME 9 5728
TEST_TIME 10 5936
TEST_TIME 11 6361
TEST_TIME 12 6867
TEST_TIME 13 6990
TEST_TIME 14 7164
TEST_TIME 15 7531
TEST_TIME 16 7577
TEST_TIME 17 7533
TEST_TIME 18 7759
TEST_TIME 19 7583
TEST_TIME 20 8206
TEST_TIME 21 8274
TEST_TIME 22 8456
TEST_TIME 23 8807
TEST_TIME 24 8965
TEST_TIME 25 9265
TEST_TIME 26 9827
TEST_TIME 27 11114
TEST_TIME 28 11268
TEST_TIME 29 11230
TEST_TIME 30 10991
TEST_TIME 31 10802
TEST_TIME 32 10728
TEST_TIME 33 10592
TEST_TIME 34 10501
TEST_TIME 35 10281
TEST_TIME 36 10094
TEST_TIME 37 9927
TEST_TIME 38 10294
TEST_TIME 39 10305
TEST_TIME 40 10119
TEST_TIME 41 10152
TEST_TIME 42 10005
TEST_TIME 43 9894
TEST_TIME 44 9811
TEST_TIME 45 9671
TEST_TIME 46 9604
TEST_TIME 47 9578
TEST_TIME 48 9604
TEST_TIME 49 9522
TEST_TIME 50 9440
TEST_TIME 51 9281
TEST_TIME 52 9182
TEST_TIME 53 9194
TEST_TIME 54 9142
TEST_TIME 55 9167
TEST_TIME 56 9181
TEST_TIME 57 9121
TEST_TIME 58 9196
TEST_TIME 59 9230
TEST_TIME 60 9215
TEST_TIME 61 9367
TEST_TIME 62 9357
TEST_TIME 63 9476
TEST_TIME 64 9484
TEST_TIME 65 9552
TEST_TIME 66 9568
TEST_TIME 67 9576
TEST_TIME 68 9612
TEST_TIME 69 9552
TEST_TIME 70 9449
TEST_TIME 71 9388
TEST_TIME 72 9408
TEST_TIME 73 9379
TEST_TIME 74 9363
TEST_TIME 75 9299
TEST_TIME 76 9252
TEST_TIME 77 9273
TEST_TIME 78 9262
TEST_TIME 79 9248
TEST_TIME 80 9296
TEST_TIME 81 9273
TEST_TIME 82 9266
TEST_TIME 83 9277
TEST_TIME 84 9392
TEST_TIME 85 9350
TEST_TIME 86 9371
TEST_TIME 87 9357
TEST_TIME 88 9393
TEST_TIME 89 9423
TEST_TIME 90 9413
TEST_TIME 91 9342
TEST_TIME 92 9323
TEST_TIME 93 9289
TEST_TIME 94 9268
TEST_TIME 95 9231
TEST_TIME 96 9191
TEST_TIME 97 9186
TEST_TIME 98 9162
TEST_TIME 99 9187
TEST_TIME 100 9164
TEST_TIME 101 9207
TEST_TIME 102 9206
TEST_TIME 103 9232
TEST_TIME 104 9226
TEST_TIME 105 9266
TEST_TIME 106 9290
TEST_TIME 107 9305
TEST_TIME 108 9268
TEST_TIME 109 9302
TEST_TIME 110 9295
TEST_TIME 111 9244
TEST_TIME 112 9239
TEST_TIME 113 9227
TEST_TIME 114 9210
TEST_TIME 115 9145
TEST_TIME 116 9111
TEST_TIME 117 9144
TEST_TIME 118 9128
TEST_TIME 119 9209
TEST_TIME 120 9166

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-12-2020 22:28:41 to 27-12-2020 22:28:44.

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 1514393 1514393 0 0.00 0 16299 6 0 0
doc_list_biud 1514392 1514392 0 0.00 0 36601 30 0 0
sp_add_invoice_to_stock 4904 4813 91 1.85 41 173431 18529 0 91
sp_cancel_adding_invoice 5825 5825 0 0.00 4 75320 758 0 0
sp_cancel_client_order 1750 1750 0 0.00 4 16091 320 0 0
sp_cancel_customer_reserve 568531 568531 0 0.00 1 31891 66 0 0
sp_cancel_pay_from_customer 632 632 0 0.00 3 6834 69 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 5921 100 0 0
sp_cancel_supplier_invoice 6447 6443 4 0.06 1 36613 644 0 4
sp_cancel_supplier_order 423 423 0 0.00 8 951833 107838 0 0
sp_cancel_write_off 10074 10074 0 0.00 1 11276 121 0 0
sp_client_order 19432 19432 0 0.00 3 39365 385 0 0
sp_customer_reserve 447627 447627 0 0.00 0 75560 181 0 0
sp_fill_shopping_cart 30014 30014 0 0.00 1 15530 40 0 0
sp_fill_shopping_cart_clo_res 447626 447626 0 0.00 0 24614 16 0 0
sp_get_clo_for_invoice 4811 4811 0 0.00 0 31845 375 0 0
sp_kill_cost_storno 16939 16939 0 0.00 0 10274 62 0 0
sp_kill_qstorno_ret_qs2qd 1154002 1154002 0 0.00 0 36596 34 0 0
sp_kill_qty_storno 607336 607336 0 0.00 0 36599 73 0 0
sp_lock_selected_doc 19935 19935 0 0.00 0 6687 5 0 0
sp_make_cost_storno 26757 26757 0 0.00 0 16291 58 0 0
sp_multiply_rows_for_pdistr 26757 26757 0 0.00 0 10307 32 0 0
sp_multiply_rows_for_qdistr 19432 19432 0 0.00 0 20609 183 0 0
sp_pay_from_customer 6811 6811 0 0.00 4 17755 138 0 0
sp_pay_to_supplier 5656 5656 0 0.00 5 16359 151 0 0
sp_payment_common 12467 12467 0 0.00 1 17745 48 0 0
sp_qd_handle_on_cancel_clo 1750 1750 0 0.00 0 16084 291 0 0
sp_qd_handle_on_invoice_upd_sts 10635 10635 0 0.00 0 31998 318 0 0
sp_qd_handle_on_reserve_upd_sts 9480 9480 0 0.00 0 26296 63 0 0
sp_reserve_write_off 9480 9480 0 0.00 6 26326 190 0 0
sp_supplier_invoice 5291 5291 0 0.00 7 96260 3420 0 0
sp_supplier_order 5311 5311 0 0.00 5 37505 1182 0 0
srv_aggregate_perf_data 91 91 0 0.00 2548 338814 21303 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1307 165237 35055 0 0
srv_find_qd_qs_mism 1054119 1054119 0 0.00 0 13498 5 0 0
srv_make_invnt_saldo 562 562 0 0.00 50 167559 1208 0 0
srv_make_money_saldo 761 761 0 0.00 0 3279 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 281751 392072 341409 0 0
t$perf-abend:sp_add_invoice_to_stock 91 91 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4813 4813 0 0.00 0 26258 192 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 1770 76 0 0
t$perf-norm:sp_cancel_client_order 1750 1750 0 0.00 0 2002 13 0 0
t$perf-norm:sp_cancel_customer_reserve 682 682 0 0.00 0 2508 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 632 632 0 0.00 0 1104 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 5664 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 750 12 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 25254 1403 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 8103 14 0 0
t$perf-norm:sp_client_order 19432 19432 0 0.00 0 9400 18 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 712 4 0 0
t$perf-norm:sp_pay_from_customer 6811 6811 0 0.00 0 7262 12 0 0
t$perf-norm:sp_pay_to_supplier 5656 5656 0 0.00 0 7255 12 0 0
t$perf-norm:sp_reserve_write_off 9480 9480 0 0.00 0 9372 12 0 0
t$perf-norm:sp_supplier_invoice 5291 5291 0 0.00 0 12144 27 0 0
t$perf-norm:sp_supplier_order 5311 5311 0 0.00 0 11664 20 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 890 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 4591 49 0 0
t$perf-norm:srv_make_invnt_saldo 562 562 0 0.00 0 1876 22 0 0
t$perf-norm:srv_make_money_saldo 761 761 0 0.00 0 1453 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9802 9620 182 1.85 0 8412 21 0 182
v_all_customers 35360 35360 0 0.00 0 20 1 0 0
v_all_suppliers 29240 29240 0 0.00 0 21 1 0 0
v_all_wares 38864 38864 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 921 7 0 0
v_cancel_client_order 3500 3500 0 0.00 0 7316 8 0 0
v_cancel_customer_prepayment 1264 1264 0 0.00 0 6763 12 0 0
v_cancel_customer_reserve 1364 1364 0 0.00 0 7998 19 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 3707 9 0 0
v_cancel_supplier_invoice 738 730 8 1.08 0 1231 16 0 8
v_cancel_supplier_order 846 846 0 0.00 0 1753 7 0 0
v_cancel_write_off 1986 1986 0 0.00 0 7494 23 0 0
v_max_id_clo_ord 5311 5311 0 0.00 0 6055 2 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 5571 15 0 0
v_max_id_ord_sup 5268 5268 0 0.00 0 9927 6 0 0
v_max_non_paid_invoice 1615 1615 0 0.00 0 1125 4 0 0
v_max_non_paid_realizn 3683 3683 0 0.00 0 8599 9 0 0
v_min_id_clo_ord 5311 5311 0 0.00 0 3342 6 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 5083 11 0 0
v_min_id_ord_sup 5268 5268 0 0.00 0 5573 4 0 0
v_min_non_paid_invoice 5656 5656 0 0.00 0 12789 29 0 0
v_min_non_paid_realizn 6811 6811 0 0.00 0 16331 36 0 0
v_our_firm 9760 9760 0 0.00 0 20 1 0 0
v_reserve_write_off 18960 18960 0 0.00 0 7316 6 0 0
x_lock_depdocs_on_canc_invoice 11903 11903 0 0.00 0 18333 125 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 13919 431 0 0
x_make_qstorno_1000_1200 5311 5311 0 0.00 2 37492 1106 0 0
x_make_qstorno_1200_2000 5291 5291 0 0.00 3 96248 3270 0 0
x_make_qstorno_2100_3300 447627 447627 0 0.00 0 75559 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-12-2020 22:28:45 to 27-12-2020 22:28:49.

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
19:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:21 27288 8192000000 10272208016 10585538560 941942112 10.312 72 59 120 0 964154224 2651104 19561008
19:57:56 34080 8192000000 10356820880 10673414144 1396633072 14.565 100 86 172 0 1429608048 5104576 27870400
19:58:41 31589 8192000000 10391020016 10714570752 1446532208 15.007 100 89 178 0 1482531488 6771952 29227328
19:59:20 22321 8192000000 10426811408 10754732032 1471903984 15.230 100 89 178 0 1508237872 7532096 28801792
19:59:52 20071 8192000000 10443731248 10775412736 1495909328 15.440 100 90 180 0 1533190048 8499216 28781504
20:00:23 21773 8192000000 10458178096 10795106304 1512580864 15.586 100 85 170 0 1548407568 9073856 26752848
20:00:52 11877 8192000000 10475796672 10813546496 1526976576 15.711 100 90 180 0 1565577456 9593248 29007632
20:01:21 15822 8192000000 10498120192 10840547328 1554311888 15.947 100 86 172 0 1591132176 10105344 26714944
20:01:45 18986 8192000000 10522208304 10871926784 1578379120 16.154 100 82 164 2 1613905632 10509440 25017072
20:02:17 16807 8192000000 10551098896 10912043008 1607469984 16.403 100 74 149 2 1640701936 10656112 22575840
20:02:45 11312 8192000000 10582523376 10944761856 1642050912 16.697 100 77 154 1 1676308208 11489216 22768080
20:03:03 10196 8192000000 10606585488 10967863296 1661878048 16.865 100 81 162 1 1698165696 12407856 23879792
20:03:20 8882 8192000000 10620444704 10985529344 1676189744 16.985 100 83 166 1 1712962848 12296144 24476960
20:03:38 9198 8192000000 10634389888 11004821504 1693831168 17.133 100 79 158 1 1729205248 12415648 22958432
20:03:54 7880 8192000000 10647729520 11022151680 1714049760 17.303 100 75 149 3 1748089232 12988128 21051344
20:04:09 6878 8192000000 10672988400 11046432768 1731576960 17.449 100 77 154 0 1766752048 13582432 21592656
20:04:23 7807 8192000000 10681094384 11055476736 1740511696 17.523 100 79 156 3 1775699744 12641808 22546240
20:04:38 4990 8192000000 10686246784 11064201216 1746378512 17.572 100 81 162 0 1782702224 12763360 23560352
20:04:50 4706 8192000000 10696505440 11073261568 1758589744 17.673 100 85 172 1 1796705808 13237632 24878432
20:05:01 7604 8192000000 10701705584 11078901760 1760609904 17.689 100 67 134 0 1792589712 13314480 18665328
20:05:15 4354 8192000000 10717927984 11097763840 1773418128 17.795 100 81 161 1 1809825664 13355776 23051760
20:05:26 3996 8192000000 10721216496 11099009024 1779324112 17.844 100 82 165 0 1815517056 13165984 23026960
20:05:37 4375 8192000000 10736870720 11115421696 1790801856 17.938 100 84 166 2 1826898256 12800224 23296176
20:05:48 2851 8192000000 10737154800 11120287744 1803324848 18.041 100 95 191 1 1843672848 13505872 26842128
20:05:58 3101 8192000000 10746088080 11126820864 1807017440 18.071 100 93 186 1 1846693216 13764592 25911184
20:06:08 6757 8192000000 10742542688 11132981248 1807663872 18.077 100 79 156 0 1843260624 13090272 22506480
20:06:22 3927 8192000000 10746684304 11138830336 1814552480 18.133 100 79 156 0 1848545280 12723952 21268848
20:06:34 2274 8192000000 10767769360 11157073920 1831486016 18.271 100 82 165 1 1866166560 11556032 23124512
20:06:43 2670 8192000000 10789811568 11174313984 1843069040 18.366 100 93 186 2 1881361680 11781168 26511472
20:06:52 1964 8192000000 10788873728 11173531648 1844416560 18.377 100 87 174 3 1881078896 12317248 24345088
20:07:01 2139 8192000000 10801267952 11187388416 1851267984 18.432 100 93 186 4 1891950656 13903040 26779632
20:07:09 1658 8192000000 10804389184 11190992896 1857429920 18.482 100 93 187 2 1897171216 13889904 25851392
20:07:17 1514 8192000000 10797846048 11189157888 1859096000 18.496 100 84 169 1 1896469536 13948384 23425152
20:07:25 2054 8192000000 10803821904 11196280832 1861904160 18.519 100 90 179 0 1900578752 13094960 25579632
20:07:34 1688 8192000000 10814911280 11201253376 1864216400 18.537 100 92 185 1 1902996176 12945472 25834304
20:07:42 2035 8192000000 10811820320 11202379776 1870979072 18.592 100 96 192 0 1911419296 13740032 26700192
20:07:50 1700 8192000000 10823747248 11212275712 1874228944 18.618 100 95 190 1 1915717568 13757136 27731488
20:07:58 1327 8192000000 10817481824 11214016512 1876357904 18.636 100 87 175 2 1914598768 13153600 25087264
20:08:06 1367 8192000000 10819348480 11213561856 1879627968 18.662 100 91 182 2 1918598368 12456816 26513584
20:08:13 42576 8192000000 10816276976 11211534336 1873779200 18.615 100 62 121 1 1899215104 7707296 17728608
20:09:03 3921 8192000000 10785912880 11206987776 1871288112 18.595 100 39 78 0 1891701520 8775872 11637536
20:09:14 4727 8192000000 10786844064 11210772480 1872657040 18.606 100 33 66 2 1889646848 7559472 9430336
20:09:25 3814 8192000000 10805409840 11216596992 1874930928 18.624 100 43 86 1 1895386480 8152752 12302800
20:09:36 6701 8192000000 10793088208 11217821696 1874997616 18.625 100 34 68 2 1892699184 8177184 9524384
20:09:50 5507 8192000000 10794226112 11215007744 1875952352 18.632 100 24 49 0 1888232496 5565440 6714704
20:10:02 6114 8192000000 10789359408 11219456000 1879339088 18.660 100 30 60 0 1895185232 7690976 8155168
20:10:16 7070 8192000000 10790929936 11221426176 1881070416 18.674 100 28 55 2 1895725040 6814912 7839712
20:10:29 6464 8192000000 10786366992 11220430848 1879277200 18.659 100 18 36 1 1889722880 5527248 4918432
20:10:42 8187 8192000000 10784430896 11221569536 1883059568 18.690 100 15 30 2 1893156288 5930496 4166224
20:11:06 7150 8192000000 10796772144 11226996736 1889659312 18.743 100 24 48 0 1902138208 6357280 6121616
20:11:21 7506 8192000000 10803221776 11229745152 1886295856 18.716 100 27 54 0 1904402784 10573632 7533296
20:11:35 7207 8192000000 10798411680 11232706560 1892335056 18.765 100 24 45 2 1905677904 7327776 6015072
20:11:49 10406 8192000000 10799056720 11233824768 1891972416 18.762 100 13 26 0 1900989824 5363888 3653520
20:12:05 10372 8192000000 10831595472 11250139136 1901230624 18.836 100 50 101 2 1922379360 6684288 14464448
20:12:22 83253 8192000000 10808287536 11249913856 1902896400 18.850 100 31 62 3 1917354160 5488928 8968832
20:13:54 6094 8192000000 10818104608 11250872320 1885880064 18.713 99 30 60 4 1901303072 7416016 8006992
20:14:08 5981 8192000000 10825873456 11256926208 1902610144 18.847 100 42 82 2 1926512416 10634352 13267920
20:14:22 5567 8192000000 10820129984 11253493760 1902455504 18.846 100 31 63 0 1917912816 6542784 8914528
20:14:34 3674 8192000000 10822125056 11255668736 1903319824 18.853 100 21 42 1 1915152784 5566720 6266240
20:14:45 8078 8192000000 10822208224 11257733120 1907082752 18.883 100 26 52 0 1921142144 6059472 7999920
20:15:01 8756 8192000000 10813441248 11253682176 1890645360 18.751 99 30 60 0 1906191568 6659600 8886608
20:15:20 4893 8192000000 10810327168 11245252608 1882318704 18.684 99 13 26 0 1891144256 5528208 3297344
20:15:31 10228 8192000000 10809312576 11248730112 1878932496 18.656 99 20 40 3 1894390528 9786192 5671840
20:15:49 12883 8192000000 10784917408 11224969216 1840080336 18.341 97 16 32 0 1850517312 5629936 4807040
20:16:08 10419 8192000000 10801990880 11238207488 1888311184 18.732 100 26 52 1 1901540704 5828496 7401024
20:16:26 15719 8192000000 10799522672 11231588352 1824572816 18.215 96 15 28 2 1832941440 5184272 3184352
20:16:51 12668 8192000000 10792483552 11218489344 1796611136 17.986 95 17 34 0 1810794848 9183232 5000480
20:17:10 60721 8192000000 10761943184 11178475520 1728067072 17.419 92 34 68 1 1744126848 5178352 10881424
20:18:21 16372 8192000000 10724837856 11149996032 1698407408 17.172 92 18 36 2 1709369296 6056736 4905152
20:18:46 6316 8192000000 10748888352 11163856896 1806207520 18.065 99 27 53 0 1819707264 6560576 6939168
20:19:03 8295 8192000000 10719779568 11137695744 1747636240 17.582 96 36 72 2 1766019824 8408848 9974736
20:19:17 4434 8192000000 10739817136 11153416192 1801278560 18.024 99 38 73 4 1817175488 4830304 11066624
20:19:28 9183 8192000000 10729920672 11147116544 1805329984 18.058 99 19 37 2 1817098848 5431472 6337392
20:19:48 7288 8192000000 10707112736 11135606784 1798541264 18.002 100 20 38 1 1809138320 5567056 5030000
20:20:07 11415 8192000000 10714171728 11141259264 1760135488 17.686 97 17 34 0 1770542384 6126928 4279968
20:20:25 9648 8192000000 10752009136 11178295296 1830580736 18.264 100 22 44 0 1843503552 5898416 7024400
20:20:43 5040 8192000000 10756496544 11176460288 1836875712 18.315 100 27 53 3 1851122912 6001168 8246032
20:20:56 11782 8192000000 10735696432 11158269952 1749989968 17.602 95 20 40 1 1761261152 5569488 5701696
20:21:14 7040 8192000000 10704069520 11120848896 1711796192 17.284 94 20 40 2 1722698416 4926592 5975632
20:21:29 9404 8192000000 10713968080 11135852544 1767596096 17.747 98 18 36 1 1778108032 5457216 5054720
20:21:49 50515 8192000000 10743679744 11157741568 1792736256 17.954 98 33 65 3 1807813440 5365312 9711872
20:22:54 23896 8192000000 10751270784 11181531136 1837951808 18.324 100 19 36 1 1848291200 5154240 5185152
20:23:24 10887 8192000000 10781641280 11200827392 1853027264 18.447 100 23 45 4 1865394512 5749856 6617392
20:23:42 5382 8192000000 10787578656 11209166848 1864944832 18.543 100 39 75 2 1882799408 7323936 10530640
20:23:54 6250 8192000000 10781937072 11206668288 1867014784 18.560 100 44 88 5 1887853600 8241616 12597200
20:24:06 6604 8192000000 10777541728 11206197248 1865714688 18.550 100 28 56 2 1880231360 6032448 8484224
20:24:22 6649 8192000000 10795457424 11215540224 1870185488 18.586 100 43 86 3 1890201264 8738976 11276800
20:24:36 9122 8192000000 10783411728 11212722176 1867895008 18.567 100 30 60 1 1883076832 6370576 8811248
20:24:52 9203 8192000000 10780408624 11213529088 1868197200 18.570 100 17 33 5 1878711248 5484864 5029184
20:25:09 11430 8192000000 10778655664 11216658432 1870384080 18.587 100 21 42 0 1881967008 5630080 5952848
20:25:27 10554 8192000000 10781569536 11218563072 1872537808 18.605 100 26 51 3 1886484624 5962768 7984048
20:25:43 10154 8192000000 10798467424 11223306240 1874725840 18.622 100 20 40 3 1886377552 5723264 5928448
20:26:00 16849 8192000000 10794546928 11225878528 1879764512 18.663 100 21 43 1 1891307168 5605248 5937408
20:26:23 9919 8192000000 10804491776 11229884416 1881443296 18.677 100 25 50 3 1895198112 6279168 7475648
20:26:39 12779 8192000000 10803743904 11229859840 1881987056 18.681 100 22 44 0 1898742864 9437888 7317920
20:27:00 132341 8192000000 10849606144 11272630272 1913788816 18.937 100 49 98 1 1935761712 6325968 15646928
20:29:28 23372 8192000000 10872699344 11297787904 1940316288 19.149 100 48 96 1 1965702544 11532928 13853328
20:30:03 26616 8192000000 10876252848 11296104448 1927819248 19.049 99 47 93 1 1953288672 12316096 13153328
20:30:37 32376 8192000000 10891033760 11320283136 1951873408 19.241 100 50 98 3 1983937936 17439072 14625456
20:31:20 26384 8192000000 10883670560 11320135680 1953672384 19.256 100 34 67 2 1976175248 12414928 10087936
20:31:55 38147 8192000000 10898244224 11332771840 1961456400 19.318 100 41 82 1 1985899776 12722000 11721376
20:32:48 34885 8192000000 10915781552 11345547264 1970272992 19.388 100 45 89 1 1998776880 15773808 12730080
20:33:44 9499 8192000000 10918452624 11349975040 1976791856 19.439 100 43 84 0 2005812896 15960000 13061040
20:34:09 13488 8192000000 10917369824 11354615808 1979534096 19.461 100 43 85 3 2007737776 15187712 13015968
20:34:34 4541 8192000000 10925735920 11356037120 1964372208 19.341 99 55 110 1 1997855856 16970256 16513392
20:34:50 8781 8192000000 10912517760 11347349504 1973207904 19.411 100 51 100 2 2005229888 17010160 15011824
20:35:08 5463 8192000000 10918349264 11343532032 1958269600 19.292 99 65 130 0 1995248672 17055824 19923248
20:35:20 14897 8192000000 10906972544 11337850880 1964429760 19.341 100 66 132 0 2002199040 18664192 19105088
20:35:43 4120 8192000000 10913038608 11339808768 1962361808 19.325 100 50 99 0 1996106320 18877536 14866976
20:35:57 25336 8192000000 10921057280 11350646784 1969118176 19.378 100 56 112 1 2004594176 19336032 16139968
20:36:30 3043 8192000000 10919037392 11342102528 1958292128 19.292 99 70 138 4 1996690368 18970448 19427792
20:36:40 3350 8192000000 10921649392 11335917568 1950594032 19.231 99 82 164 1 1995271744 20978736 23698976
20:36:53 2241 8192000000 10933142608 11344056320 1972705648 19.407 100 80 152 3 2015743376 21145920 21891808
20:37:03 8974 8192000000 10922210528 11339825152 1951647760 19.240 99 73 146 1 1994449488 22204064 20597664
20:37:20 2038 8192000000 10937978544 11355566080 1976280288 19.435 100 78 156 0 2022107296 22548512 23278496
20:37:28 3202 8192000000 10927496976 11353440256 1979695776 19.462 100 73 147 0 2023909856 22489488 21724592
20:37:38 6544 8192000000 10948679280 11361865728 1983609008 19.493 100 74 146 1 2027406496 22557952 21239536
20:37:51 2497 8192000000 10939727552 11365507072 1987305024 19.522 100 74 148 0 2032959296 23604528 22049744
20:38:01 12156 8192000000 10944713024 11376254976 1991752944 19.558 100 66 130 1 2035680048 24243104 19684000
20:38:20 2312 8192000000 10953210832 11373633536 1992421296 19.563 100 83 167 1 2045732880 28034288 25277296
20:38:31 11006 8192000000 10951342480 11377582080 1990194480 19.545 100 67 134 2 2039420720 29026784 20199456
20:38:49 3956 8192000000 10956823184 11382616064 1994622752 19.580 100 71 142 0 2042527552 26962768 20942032
20:39:01 2674 8192000000 10966607952 11387256832 1997936464 19.606 100 71 141 1 2045504672 26049696 21518512
20:39:11 3170 8192000000 10965989504 11386929152 1997260016 19.601 100 75 150 0 2046451824 26700112 22491696
20:39:20 2950 8192000000 10956661680 11373731840 1987745552 19.526 100 80 159 1 2039633408 27570992 24316864
20:39:32 7627 8192000000 10955035552 11379556352 1991614880 19.557 100 73 146 1 2041435120 27555296 22264944
20:39:48 1880 8192000000 10962235600 11384397824 1980393216 19.468 99 73 143 1 2028596800 26649584 21554000
20:39:57 3496 8192000000 10972909840 11385798656 1998490752 19.611 100 84 163 4 2050737952 27390976 24856224
20:40:08 3334 8192000000 10962408720 11386294272 1998103296 19.608 100 81 161 0 2051997408 29368544 24525568
20:40:20 2570 8192000000 10972580560 11391258624 1999294288 19.617 100 80 160 3 2054327072 30946976 24085808
20:40:31 7653 8192000000 10963719408 11387428864 1983331936 19.491 99 82 162 0 2039028560 31122896 24573728
20:40:49 1306 8192000000 10970164464 11389960192 1992424912 19.563 100 75 147 0 2049206624 34075840 22705872
20:40:59 13555 8192000000 10946700592 11380109312 1986953072 19.520 100 65 128 0 2037645472 30588016 20104384
20:41:21 9350 8192000000 10951707632 11387351040 1992549008 19.564 100 59 118 2 2042893456 31887824 18456624
20:41:39 2075 8192000000 10968411344 11397197824 2000763312 19.629 100 66 130 4 2055186480 33875888 20547280
20:41:48 2901 8192000000 10962536576 11389513728 1980132000 19.466 99 64 128 0 2036063024 35488352 20442672
20:42:02 2636 8192000000 10977343312 11398496256 1998844192 19.614 100 79 157 2 2061942000 38758064 24339744
20:42:11 6626 8192000000 10961400896 11394654208 1990641072 19.549 100 62 120 1 2046822624 38287632 17893920
20:42:28 4295 8192000000 10936230464 11355529216 1955251792 19.268 99 76 150 2 2015886448 37629744 23004912
20:42:40 3065 8192000000 10920858624 11339390976 1946660416 19.200 100 75 149 0 2003481520 34805328 22015776
20:42:53 3350 8192000000 10891523472 11305508864 1898402384 18.813 97 71 139 2 1954728144 35488704 20837056
20:43:03 4116 8192000000 10937957008 11345678336 1935842704 19.114 99 85 168 2 1999521888 37768128 25911056
20:43:15 6982 8192000000 10936493664 11358896128 1962632896 19.327 100 72 143 2 2020713312 35751776 22328640
20:43:31 4979 8192000000 10930868528 11349860352 1948986848 19.218 99 68 135 2 2005798560 36082224 20729488
20:43:43 5157 8192000000 10950864096 11367743488 1973017664 19.409 100 64 128 1 2028636704 36003296 19615744
20:43:55 1848 8192000000 10940484240 11346960384 1938427120 19.134 98 75 148 2 1999689952 38565360 22697472
20:44:04 6251 8192000000 10948748432 11366662144 1969224000 19.379 100 70 140 0 2030654144 40093168 21336976
20:44:21 7024 8192000000 10954902688 11376939008 1978806192 19.455 100 67 134 2 2040462608 40772864 20883552
20:44:35 5226 8192000000 10966536560 11384029184 1965016816 19.346 99 64 128 1 2024717136 39841600 19858720
20:44:48 2972 8192000000 10963513472 11383599104 1986485680 19.516 100 75 150 0 2050579296 40808480 23285136
20:44:57 2573 8192000000 10955963312 11362234368 1961976416 19.322 99 84 167 1 2028861296 40837216 26047664
20:45:07 3413 8192000000 10968757584 11381420032 1977058448 19.441 100 84 168 1 2050632352 47912016 25661888
20:45:18 2316 8192000000 10970989680 11380875264 1964763184 19.344 99 84 167 1 2037004704 46615456 25626064
20:45:28 2381 8192000000 10956769776 11370840064 1966705200 19.359 100 86 173 0 2042353840 49206944 26441696
20:45:41 4364 8192000000 10960580752 11380047872 1971725600 19.399 100 61 122 3 2041313376 50285200 19302576
20:45:56 11776 8192000000 10943754336 11372490752 1960730208 19.312 100 44 88 0 2025587712 50369392 14488112
20:46:20 8764 8192000000 10951981504 11373109248 1962644240 19.327 100 58 116 1 2035950752 53956864 19349648
20:46:35 6191 8192000000 10947454752 11373019136 1957418288 19.286 100 55 110 0 2029755392 53682304 18654800
20:46:55 4777 8192000000 10979867760 11395768320 1975101072 19.426 100 62 123 1 2053055360 56303568 21650720
20:47:08 7991 8192000000 10947434528 11374682112 1939491968 19.143 98 47 93 0 2011349376 56238720 15618688
20:47:26 16688 8192000000 10957223424 11403300864 1979084112 19.457 100 53 105 0 2052100560 55497888 17518560
20:47:57 4957 8192000000 10985841952 11405099008 1989756992 19.542 100 65 129 1 2060732416 50158896 20816528
20:48:12 5077 8192000000 10985714512 11415535616 1995813424 19.590 100 51 102 1 2066205392 53121616 17270352
20:48:28 5663 8192000000 10983647008 11419250688 1997258208 19.601 100 56 112 1 2069702208 54325136 18118864
20:48:43 3141 8192000000 10987994176 11412918272 1986656960 19.517 100 57 114 1 2061229328 55517248 19055120
20:48:54 7238 8192000000 10983004432 11416821760 1996254528 19.593 100 58 116 0 2074456096 58244800 19956768
20:49:22 9781 8192000000 10970497696 11396849664 1953015408 19.250 98 58 115 3 2035103712 62222576 19865728
20:49:43 12810 8192000000 10965539040 11399118848 1948034800 19.211 98 46 92 1 2018319120 54445728 15838592
20:50:03 9194 8192000000 10952198000 11394609152 1957455728 19.286 99 39 77 1 2025389104 54509824 13423552
20:50:20 15483 8192000000 10954595872 11396681728 1953971552 19.258 99 47 94 0 2028212528 58539440 15701536
20:50:47 6939 8192000000 10946001488 11385274368 1966745152 19.360 100 45 89 0 2032527920 50867280 14915488
20:51:14 13532 8192000000 10972202240 11413422080 1977344416 19.444 100 38 76 2 2047239072 56811072 13083584
20:52:20 17849 8192000000 10949828608 11409580032 1975049136 19.425 100 30 60 1 2043461328 57907392 10504800
20:52:47 7660 8192000000 10949390224 11402227712 1966140448 19.355 100 24 48 2 2033925712 59125392 8659872
20:53:26 18671 8192000000 10938060416 11411316736 1946956944 19.202 100 18 36 0 2018467744 64389152 7121648
20:54:10 28602 8192000000 10913715488 11392012288 1919360016 18.982 99 11 22 0 1979390240 55413920 4616304
20:54:46 25459 8192000000 10869929632 11358916608 1900017648 18.826 98 9 18 1 1933943824 30982384 2943792
20:55:24 73305 8192000000 10880849888 11322646528 1859755904 18.501 96 16 33 0 1883527584 19521264 4250416
20:56:49 94481 8192000000 10860497728 11303493632 1900679232 18.832 98 41 82 1 1924086592 9815152 13592208
20:58:35 101698 8192000000 10857087728 11312492544 1869070096 18.577 96 30 60 3 1885150976 8042736 8038144
21:00:32 21551 8192000000 10865244672 11317551104 1942561216 19.167 100 30 60 1 1959078432 8601408 7915808
21:01:41 55274 8192000000 10856610624 11313606656 1906010512 18.875 98 16 30 2 1916338112 5724560 4603040
21:02:42 111465 8192000000 10899062208 11355267072 1943239824 19.173 99 16 32 0 1969285232 21634112 4411296
21:05:12 165237 8192000000 10910049344 11384549376 1974224128 19.419 100 6 12 0 1999249760 22733872 2291760
21:08:03 78761 8192000000 10903308320 11383468032 1978050928 19.449 100 7 14 0 1993390336 13717440 1621968
21:09:28 126659 8192000000 10908745968 11379929088 1971320192 19.396 99 39 78 0 1990391968 7609728 11462048
21:11:41 35541 8192000000 10896796352 11378274304 1983523552 19.493 100 13 25 0 1996748000 9855248 3369200
21:12:51 34962 8192000000 10925257760 11394392064 2002401840 19.642 100 29 58 0 2021851584 11174096 8275648
21:13:49 90943 8192000000 10910805296 11402379264 1975180736 19.427 99 13 27 0 1993340704 13736672 4423296
21:15:31 40493 8192000000 10906387344 11379920896 1990283120 19.546 100 9 18 0 2004730400 12063648 2383632
21:16:23 78827 8192000000 10903945072 11377229824 1933745760 19.097 97 10 19 2 1943190352 6153744 3290848
21:17:55 122050 8192000000 10919855840 11393884160 1993019392 19.568 100 17 34 2 2007177744 9350080 4808272
21:20:08 58749 8192000000 10898882992 11390529536 1955472256 19.270 98 4 8 0 1965667200 9179488 1015456
21:21:13 40937 8192000000 10909570656 11384442880 1975120432 19.426 99 13 26 1 1984854704 6486944 3247328
21:22:08 79718 8192000000 10911584752 11383255040 1961165760 19.315 98 17 34 1 1978602560 11787424 5649376
21:23:33 56421 8192000000 10905873504 11372163072 1915711312 18.952 96 18 36 0 1932318880 11589328 5018240
21:24:43 45843 8192000000 10906984576 11378659328 1945848576 19.193 98 22 43 0 1966519744 14914816 5756352
21:25:40 65655 8192000000 10894130464 11372089344 1923895216 19.018 97 8 16 0 1935500128 9227936 2376976
21:26:52 50786 8192000000 10919267600 11389390848 1990800144 19.550 100 22 43 2 2008428912 11934256 5694512
21:27:50 82979 8192000000 10898305168 11381022720 1908689712 18.896 96 19 38 0 1934344128 20698864 4955552
21:29:20 79111 8192000000 10877732928 11351830528 1877677200 18.646 95 21 42 1 1892494016 9294656 5522160
21:30:50 76912 8192000000 10857020768 11317678080 1801659376 18.028 92 11 22 0 1813363456 9316960 2387120
21:32:13 51753 8192000000 10859182320 11327135744 1849028208 18.414 95 24 48 0 1875433280 19458064 6947008
21:33:11 27880 8192000000 10884909760 11340664832 1916099936 18.956 99 15 30 0 1933736944 13487904 4149104
21:33:49 25324 8192000000 10872236016 11320770560 1873594464 18.613 96 40 80 2 1893673632 8414256 11664912
21:34:23 18939 8192000000 10884399600 11326779392 1905547600 18.871 98 50 100 2 1931030592 11681616 13801376
21:34:51 32650 8192000000 10865550336 11325251584 1901126128 18.835 98 41 82 1 1926771808 13878592 11767088
21:35:32 54686 8192000000 10862687376 11316256768 1899778864 18.825 98 17 34 0 1913765728 9161376 4825488
21:36:37 117128 8192000000 10870427552 11339923456 1935102112 19.108 99 22 44 1 1951474512 10180656 6191744
21:38:52 16882 8192000000 10887978624 11343704064 1934711920 19.105 99 27 54 1 1952498512 10226368 7560224
21:39:15 21833 8192000000 10882386112 11328536576 1923397568 19.014 99 30 60 0 1943650416 11682128 8570720
21:39:47 42983 8192000000 10850263152 11314479104 1889043808 18.738 97 15 30 0 1902071904 8557760 4470336
21:40:37 69117 8192000000 10865646432 11342827520 1927423200 19.046 99 13 26 2 1941787808 10776192 3588416
21:41:54 66595 8192000000 10875114208 11355717632 1950807648 19.233 100 11 23 0 1971100752 17356032 2937072
21:43:07 39406 8192000000 10874614448 11338457088 1911318608 18.917 98 12 24 0 1927289104 12543472 3427024
21:43:52 78926 8192000000 10856627584 11318489088 1919185120 18.980 99 15 30 0 1939795920 16251936 4358864
21:45:32 112552 8192000000 10856538608 11334189056 1865988144 18.552 96 13 27 1 1882644240 12381088 4275008
21:47:35 57330 8192000000 10849269632 11320745984 1849321920 18.417 95 12 24 1 1867153664 13788032 4043712
21:49:02 72010 8192000000 10869509984 11337744384 1909292944 18.901 98 31 60 2 1931021264 12860224 8868096
21:50:23 73517 8192000000 10866609584 11339767808 1882831984 18.688 97 15 30 0 1904376032 16846080 4697968
21:51:53 56703 8192000000 10866447392 11322200064 1887984400 18.730 97 29 58 2 1904983488 9029024 7970064
21:52:56 41355 8192000000 10868428464 11326984192 1914702144 18.944 99 29 58 1 1933172736 10627024 7843568
21:54:04 51195 8192000000 10892073280 11328204800 1920947488 18.994 99 23 46 4 1937679648 9768144 6964016
21:55:03 38612 8192000000 10886999824 11338149888 1943131936 19.172 100 28 56 0 1964264272 13121584 8010752
21:55:57 25512 8192000000 10880318032 11334942720 1912088032 18.923 98 33 65 1 1932694496 11296848 9309616
21:56:46 66846 8192000000 10913169904 11358904320 1956364064 19.277 100 21 41 1 1972243872 9770304 6109504
21:58:00 41403 8192000000 10893975376 11354157056 1939653792 19.144 98 55 109 5 1963956800 9152240 15150768
21:59:24 43210 8192000000 10894904176 11364343808 1930351120 19.070 98 42 84 0 1955188544 12439968 12397456
22:00:20 35441 8192000000 10895161952 11365318656 1965771104 19.352 100 20 40 0 1984010000 12717008 5521888
22:01:31 77268 8192000000 10878596528 11354636288 1941272512 19.157 99 17 34 2 1959469040 13423680 4772848
22:03:00 75796 8192000000 10882836672 11359432704 1963838640 19.337 100 13 25 0 1976959072 9701232 3419200
22:04:31 71675 8192000000 10892395232 11373346816 1918947744 18.978 97 10 19 1 1933393376 11364768 3080864
22:05:52 80030 8192000000 10909477264 11394781184 1979328512 19.459 100 20 40 1 1997215360 12020048 5866800
22:07:34 52702 8192000000 10921673600 11389976576 1973215712 19.411 99 19 36 1 1990523584 11705984 5601888
22:08:33 72680 8192000000 10909793760 11382198272 1950148768 19.228 98 17 34 1 1964751136 9922384 4679984
22:09:52 56902 8192000000 10894749104 11358789632 1919651472 18.984 97 11 22 3 1930645872 8307632 2686768
22:10:55 49916 8192000000 10908234240 11377897472 1964712032 19.343 99 28 56 1 1986613184 13528640 8372512
22:11:58 50666 8192000000 10925283696 11389583360 1985881920 19.511 100 39 78 0 2014538176 16380128 12276128
22:13:16 82168 8192000000 10898817264 11360878592 1888871056 18.737 95 16 31 1 1904950464 11885472 4193936
22:15:35 30186 8192000000 10897898096 11353501696 1910925664 18.914 97 30 59 0 1930752544 11535488 8291392
22:16:12 16143 8192000000 10891582640 11340460032 1918990608 18.979 98 38 76 1 1944142656 14137648 11014400
22:16:36 84049 8192000000 10882604960 11333349376 1855961488 18.471 95 11 22 1 1874186848 15216704 3008656
22:18:09 142987 8192000000 10859483392 11315830784 1848771024 18.412 95 24 47 0 1864500096 8812544 6916528
22:20:57 52749 8192000000 10861275264 11347574784 1942510320 19.167 100 12 24 1 1962613152 16773776 3329056
22:22:07 69731 8192000000 10860670192 11330121728 1912998336 18.931 98 14 27 2 1932540240 15168032 4373872
22:24:20 84068 8192000000 10860172688 11334238208 1899117168 18.819 97 17 34 0 1923837888 19156688 5564032
22:25:50 76401 8192000000 10880137056 11360202752 1947955904 19.210 100 23 44 1 1969362912 15040016 6366992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 27-12-2020 22:28:51 to 27-12-2020 22:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 91 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-12-2020 22:29:22 to 27-12-2020 22:29:24.

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          237603
MON$OLDEST_ACTIVE               238064
MON$OLDEST_SNAPSHOT             238064
MON$NEXT_TRANSACTION            238064
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                       2019136
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:472: 
:473: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:474:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:475: 
:476: 
:477: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:478:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:479: 
:480: 
:481: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:482:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:483: 
:484: 
:485: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:486:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:487: 
:488: 
:489: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:490:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:491: 
:492: 
:493: mscs-test-161.budzdorov.ru    Sun Dec 27 22:27:24 2020
:494:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:495: 
--- end of diff output ---

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

27.12.20 22:29:25. 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-27 22:29:28 No severe PSQL-related problems occured
27.12.20 22:29:29. End of report.