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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-15 16:27:24
DTS_END                         2021-03-15 16:27:24.4170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33018
TRN_ID                          236653
ATT_ID                          655
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: 9038.58 20763 1084630
customer order: creation 170.37 376 20444
customer order: refuse 14.46 369 1735
order to supplier: creation 46.02 1304 5522
order to supplier: removal 3.34 95601 401
invoice (draft): creation 46.04 3378 5525
invoice (draft): removal 50.64 820 6077
invoice accept: apply 41.46 17123 4975
invoice accept: cancel 45.35 755 5442
customer reserve: creation 3853.07 166 462368
customer reserve: removal 4476.16 55 537139
realization accept: apply 82.95 215 9954
realization accept: cancel 79.66 107 9559
payment from customer: creation 58.45 146 7014
payment from customer: removal 5.48 83 657
payment to supplier: creation 49.88 148 5985
payment to supplier: removal 3.47 79 416
service: total inventory turnovers 4.50 1054 540
service: total monetary turnovers 6.53 44 783
service: aggregate perf. data 0.75 22222 90
service: refresh index statistics 0.03 271212 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-03-2021 16:28:39 to 15-03-2021 16:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1645
TEST_TIME 2 2305
TEST_TIME 3 3145
TEST_TIME 4 3710
TEST_TIME 5 4094
TEST_TIME 6 4801
TEST_TIME 7 5069
TEST_TIME 8 5356
TEST_TIME 9 5425
TEST_TIME 10 5518
TEST_TIME 11 5992
TEST_TIME 12 6077
TEST_TIME 13 6178
TEST_TIME 14 6890
TEST_TIME 15 7226
TEST_TIME 16 7537
TEST_TIME 17 7524
TEST_TIME 18 7760
TEST_TIME 19 8100
TEST_TIME 20 8291
TEST_TIME 21 8660
TEST_TIME 22 9020
TEST_TIME 23 8905
TEST_TIME 24 9519
TEST_TIME 25 9837
TEST_TIME 26 10196
TEST_TIME 27 10412
TEST_TIME 28 10404
TEST_TIME 29 10298
TEST_TIME 30 10405
TEST_TIME 31 10221
TEST_TIME 32 10011
TEST_TIME 33 10123
TEST_TIME 34 9940
TEST_TIME 35 9926
TEST_TIME 36 9935
TEST_TIME 37 9785
TEST_TIME 38 9606
TEST_TIME 39 9464
TEST_TIME 40 9465
TEST_TIME 41 9471
TEST_TIME 42 9365
TEST_TIME 43 9298
TEST_TIME 44 9184
TEST_TIME 45 9116
TEST_TIME 46 9282
TEST_TIME 47 9234
TEST_TIME 48 9173
TEST_TIME 49 9096
TEST_TIME 50 8985
TEST_TIME 51 8995
TEST_TIME 52 9088
TEST_TIME 53 9105
TEST_TIME 54 9117
TEST_TIME 55 9116
TEST_TIME 56 9107
TEST_TIME 57 9180
TEST_TIME 58 9187
TEST_TIME 59 9269
TEST_TIME 60 9298
TEST_TIME 61 9340
TEST_TIME 62 9419
TEST_TIME 63 9409
TEST_TIME 64 9342
TEST_TIME 65 9233
TEST_TIME 66 9160
TEST_TIME 67 9163
TEST_TIME 68 9169
TEST_TIME 69 9100
TEST_TIME 70 9052
TEST_TIME 71 9163
TEST_TIME 72 9120
TEST_TIME 73 9099
TEST_TIME 74 9095
TEST_TIME 75 9106
TEST_TIME 76 9098
TEST_TIME 77 9089
TEST_TIME 78 9210
TEST_TIME 79 9181
TEST_TIME 80 9185
TEST_TIME 81 9194
TEST_TIME 82 9263
TEST_TIME 83 9248
TEST_TIME 84 9323
TEST_TIME 85 9317
TEST_TIME 86 9375
TEST_TIME 87 9321
TEST_TIME 88 9282
TEST_TIME 89 9225
TEST_TIME 90 9219
TEST_TIME 91 9153
TEST_TIME 92 9143
TEST_TIME 93 9094
TEST_TIME 94 9117
TEST_TIME 95 9085
TEST_TIME 96 9078
TEST_TIME 97 9090
TEST_TIME 98 9097
TEST_TIME 99 9081
TEST_TIME 100 9064
TEST_TIME 101 9064
TEST_TIME 102 9136
TEST_TIME 103 9256
TEST_TIME 104 9265
TEST_TIME 105 9262
TEST_TIME 106 9272
TEST_TIME 107 9297
TEST_TIME 108 9266
TEST_TIME 109 9202
TEST_TIME 110 9177
TEST_TIME 111 9149
TEST_TIME 112 9164
TEST_TIME 113 9138
TEST_TIME 114 9104
TEST_TIME 115 9077
TEST_TIME 116 9041
TEST_TIME 117 9078
TEST_TIME 118 9060
TEST_TIME 119 9065
TEST_TIME 120 9043

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-03-2021 16:28:42 to 15-03-2021 16:28:46.

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 1511597 1511597 0 0.00 0 49304 6 0 0
doc_list_biud 1511580 1511580 0 0.00 0 35336 26 0 0
sp_add_invoice_to_stock 5034 4975 59 1.17 27 240724 17124 0 59
sp_cancel_adding_invoice 5442 5442 0 0.00 5 51370 755 0 0
sp_cancel_client_order 1735 1735 0 0.00 4 13148 370 0 0
sp_cancel_customer_reserve 537139 537139 0 0.00 1 35339 56 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 9701 84 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 4657 80 0 0
sp_cancel_supplier_invoice 6079 6077 2 0.03 2 14171 820 0 2
sp_cancel_supplier_order 401 401 0 0.00 8 1081615 95601 0 0
sp_cancel_write_off 9559 9559 0 0.00 1 18057 107 0 0
sp_client_order 20444 20444 0 0.00 3 21650 377 0 0
sp_customer_reserve 462368 462368 0 0.00 0 124202 167 0 0
sp_fill_shopping_cart 31488 31488 0 0.00 1 35041 42 0 0
sp_fill_shopping_cart_clo_res 462368 462368 0 0.00 0 14929 14 0 0
sp_get_clo_for_invoice 4967 4967 0 0.00 0 25501 308 0 0
sp_kill_cost_storno 16074 16074 0 0.00 0 12124 53 0 0
sp_kill_qstorno_ret_qs2qd 1090315 1090315 0 0.00 0 35216 31 0 0
sp_kill_qty_storno 575262 575262 0 0.00 0 35336 67 0 0
sp_lock_selected_doc 20575 20575 0 0.00 0 10403 8 0 0
sp_make_cost_storno 27920 27920 0 0.00 0 48903 94 0 0
sp_multiply_rows_for_pdistr 27910 27910 0 0.00 0 13555 28 0 0
sp_multiply_rows_for_qdistr 20444 20444 0 0.00 0 20990 183 0 0
sp_pay_from_customer 7014 7014 0 0.00 4 44606 147 0 0
sp_pay_to_supplier 5985 5985 0 0.00 4 25747 148 0 0
sp_payment_common 12994 12994 0 0.00 1 20043 29 0 0
sp_qd_handle_on_cancel_clo 1735 1735 0 0.00 0 9835 324 0 0
sp_qd_handle_on_invoice_upd_sts 10403 10403 0 0.00 0 14937 311 0 0
sp_qd_handle_on_reserve_upd_sts 9948 9948 0 0.00 0 18746 61 0 0
sp_reserve_write_off 9954 9954 0 0.00 6 49131 216 0 0
sp_supplier_invoice 5525 5525 0 0.00 6 135777 3379 0 0
sp_supplier_order 5522 5522 0 0.00 5 75410 1304 0 0
srv_aggregate_perf_data 90 90 0 0.00 3008 614788 22222 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 989 131336 34024 0 0
srv_find_qd_qs_mism 1036388 1036388 0 0.00 0 18630 5 0 0
srv_make_invnt_saldo 540 540 0 0.00 28 44165 1055 0 0
srv_make_money_saldo 783 783 0 0.00 1 11587 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 209456 316251 271212 0 0
t$perf-abend:sp_add_invoice_to_stock 59 59 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4975 4975 0 0.00 0 16347 163 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 3361 107 0 0
t$perf-norm:sp_cancel_client_order 1735 1735 0 0.00 0 6261 13 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 2392 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 3227 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 449 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 584 13 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 31653 1526 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 3806 15 0 0
t$perf-norm:sp_client_order 20444 20444 0 0.00 0 19471 16 0 0
t$perf-norm:sp_customer_reserve 1026 1026 0 0.00 0 3975 12 0 0
t$perf-norm:sp_pay_from_customer 7014 7014 0 0.00 0 14344 14 0 0
t$perf-norm:sp_pay_to_supplier 5985 5985 0 0.00 0 13475 14 0 0
t$perf-norm:sp_reserve_write_off 9954 9954 0 0.00 0 11628 11 0 0
t$perf-norm:sp_supplier_invoice 5525 5525 0 0.00 0 2630 15 0 0
t$perf-norm:sp_supplier_order 5522 5522 0 0.00 0 3424 13 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 126 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 1763 48 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 2121 24 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 4297 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 10024 9906 118 1.17 0 11499 22 0 118
v_all_customers 37216 37216 0 0.00 0 18 1 0 0
v_all_suppliers 30778 30778 0 0.00 0 24 1 0 0
v_all_wares 40888 40888 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 2099 14 0 0
v_cancel_client_order 3470 3470 0 0.00 0 7783 7 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 9685 19 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 898 4 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1582 6 0 0
v_cancel_supplier_invoice 832 828 4 0.48 0 843 14 0 4
v_cancel_supplier_order 802 802 0 0.00 0 1063 5 0 0
v_cancel_write_off 2032 2032 0 0.00 0 6267 16 0 0
v_max_id_clo_ord 5522 5522 0 0.00 0 2577 2 0 0
v_max_id_clo_res 1026 1026 0 0.00 0 1677 13 0 0
v_max_id_ord_sup 5522 5522 0 0.00 0 2321 2 0 0
v_max_non_paid_invoice 1635 1635 0 0.00 0 330 2 0 0
v_max_non_paid_realizn 3817 3817 0 0.00 0 827 4 0 0
v_min_id_clo_ord 5522 5522 0 0.00 0 20004 13 0 0
v_min_id_clo_res 1026 1026 0 0.00 0 5475 19 0 0
v_min_id_ord_sup 5522 5522 0 0.00 0 10199 9 0 0
v_min_non_paid_invoice 5980 5980 0 0.00 0 10747 18 0 0
v_min_non_paid_realizn 7014 7014 0 0.00 0 6103 15 0 0
v_our_firm 10066 10066 0 0.00 0 13 1 0 0
v_reserve_write_off 19896 19896 0 0.00 0 6922 6 0 0
x_lock_depdocs_on_canc_invoice 11105 11105 0 0.00 0 13541 106 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 15574 369 0 0
x_make_qstorno_1000_1200 5522 5522 0 0.00 2 74654 1215 0 0
x_make_qstorno_1200_2000 5525 5525 0 0.00 3 135681 3232 0 0
x_make_qstorno_2100_3300 462368 462368 0 0.00 0 124200 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-03-2021 16:28:47 to 15-03-2021 16:28:51.

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
13:57:28 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:34 10115 8192000000 10209510736 10512257024 976385536 10.649 78 61 122 0 999943312 2755488 20802288
13:57:52 32402 8192000000 10342563872 10655907840 1380301040 14.419 100 89 178 0 1414388496 4502272 29585184
13:58:34 27153 8192000000 10381716576 10704052224 1424866624 14.816 100 83 167 0 1458964928 6208656 27889648
13:59:14 22098 8192000000 10404567168 10732068864 1455635456 15.088 100 80 160 1 1488800128 6901520 26263152
13:59:46 35343 8192000000 10437901392 10768478208 1479159184 15.294 100 88 177 0 1515927088 7981392 28786512
14:00:32 28074 8192000000 10463933456 10796290048 1513469248 15.593 100 90 180 0 1550769408 8821296 28478864
14:01:12 22653 8192000000 10485327872 10822983680 1531700832 15.752 100 87 174 1 1568385600 9329584 27355184
14:01:44 20592 8192000000 10498713632 10842333184 1553961408 15.944 100 89 178 2 1591667232 10210464 27495360
14:02:15 17331 8192000000 10518639552 10870099968 1580477520 16.172 100 78 156 1 1614064272 10346928 23239824
14:02:42 13330 8192000000 10536861376 10890379264 1594575056 16.293 100 71 140 2 1625955328 10345472 21034800
14:03:04 13310 8192000000 10555880880 10915291136 1621717408 16.525 100 74 148 0 1655114064 10744288 22652368
14:03:26 10660 8192000000 10574804944 10932137984 1633476864 16.624 100 81 160 2 1669035552 11178496 24380192
14:03:45 10866 8192000000 10601273936 10962767872 1661281872 16.860 100 86 172 2 1699008896 12388176 25338848
14:04:04 9748 8192000000 10624339568 10986958848 1673451744 16.962 100 82 162 2 1710759808 12965024 24343040
14:04:22 9456 8192000000 10622893280 10995232768 1691660656 17.115 100 81 159 0 1728001344 12909216 23431472
14:04:41 7555 8192000000 10644915072 11020492800 1704008608 17.219 100 73 146 0 1742071264 17411552 20651104
14:04:57 5650 8192000000 10659718960 11031961600 1722155952 17.370 100 76 153 0 1755836432 11799072 21881408
14:05:10 7305 8192000000 10657195616 11036852224 1730310176 17.438 100 75 149 1 1763211456 11890912 21010368
14:05:23 5789 8192000000 10677245696 11057811456 1738766208 17.508 100 72 146 0 1771140480 11759424 20614848
14:05:37 4468 8192000000 10688521952 11066183680 1752730688 17.624 100 71 142 1 1785657136 13010512 19915936
14:05:49 4540 8192000000 10701036912 11081887744 1763332096 17.712 100 81 162 0 1799907264 13461824 23113344
14:06:01 10853 8192000000 10710882144 11093086208 1770429456 17.771 100 71 142 0 1803146528 13302976 19414096
14:06:19 4534 8192000000 10733701056 11112943616 1785092400 17.891 100 87 173 2 1822724912 13980512 23652000
14:06:30 4678 8192000000 10748088016 11123314688 1799326336 18.008 100 94 188 0 1841448096 15676368 26445392
14:06:42 3878 8192000000 10743284416 11126951936 1804713152 18.053 100 84 168 2 1842715600 14603152 23399296
14:06:53 2823 8192000000 10749050032 11134074880 1807996768 18.079 100 75 147 3 1841887920 12877568 21013584
14:07:04 3971 8192000000 10750636480 11142123520 1814743984 18.135 100 84 168 2 1851775920 13409808 23622128
14:07:15 3229 8192000000 10767899472 11150180352 1819768368 18.176 100 89 178 1 1857640256 12837952 25033936
14:07:25 3117 8192000000 10762644416 11152629760 1827541088 18.239 100 84 168 1 1865096208 14107104 23448016
14:07:34 2513 8192000000 10775803776 11163488256 1834837328 18.299 100 90 178 3 1873690576 13160288 25692960
14:07:44 1894 8192000000 10780846240 11170590720 1838824576 18.331 100 88 176 2 1877213248 13519264 24869408
14:07:52 2261 8192000000 10779578192 11167350784 1842781344 18.363 100 81 163 0 1877022592 11281328 22959920
14:08:01 3089 8192000000 10783452736 11176144896 1848370496 18.409 100 87 174 1 1886480416 12649712 25460208
14:08:11 2552 8192000000 10787714992 11177000960 1848813312 18.412 100 84 168 1 1884442000 11761184 23867504
14:08:20 2848 8192000000 10786888768 11176988672 1849783440 18.420 100 78 156 0 1883526512 11642016 22101056
14:08:30 2642 8192000000 10802073456 11189649408 1855487280 18.467 100 92 184 2 1893553584 11728944 26337360
14:08:39 3453 8192000000 10798795744 11189911552 1858977920 18.495 100 84 168 0 1895791088 13025920 23787248
14:08:49 2000 8192000000 10809345952 11198140416 1864184352 18.537 100 93 186 1 1903513280 13575376 25753552
14:08:58 3062 8192000000 10802553040 11194257408 1863765248 18.534 100 84 169 4 1899561904 12658944 23137712
14:09:08 10719 8192000000 10774418544 11192815616 1863357248 18.530 100 73 144 2 1896634064 13561904 19714912
14:09:26 5211 8192000000 10805534496 11202682880 1870482112 18.588 100 75 150 2 1902620480 9571392 22566976
14:09:38 2755 8192000000 10806554144 11203420160 1872722720 18.606 100 81 162 0 1907362224 10806240 23833264
14:09:47 2780 8192000000 10810428480 11208908800 1875738416 18.631 100 85 168 3 1911865424 11477440 24649568
14:09:56 1330 8192000000 10819286256 11210133504 1875866528 18.632 100 84 167 0 1912524928 13058192 23600208
14:10:04 18524 8192000000 10819124720 11213787136 1877840704 18.648 100 83 167 1 1914691872 13328320 23522848
14:10:29 1181 8192000000 10828213312 11218087936 1881076208 18.674 100 89 179 3 1919578592 13200160 25302224
14:10:37 10877 8192000000 10815241232 11213488128 1879419616 18.660 100 65 132 2 1908322800 10804624 18098560
14:10:56 4996 8192000000 10804367072 11212173312 1877837232 18.648 100 57 113 2 1902020848 8249152 15934464
14:11:07 7532 8192000000 10780041696 11208622080 1878352432 18.652 100 39 73 2 1897402352 8168336 10881584
14:11:23 3929 8192000000 10801544080 11211755520 1878837504 18.656 100 41 84 0 1898558512 6985760 12735248
14:11:35 3112 8192000000 10792680592 11215540224 1879089744 18.658 100 40 80 2 1899217552 9230320 10897488
14:11:45 5988 8192000000 10793222640 11209998336 1880113056 18.666 100 40 78 2 1898818752 6808816 11896880
14:11:58 5565 8192000000 10795467408 11217047552 1883728544 18.695 100 50 100 0 1907096096 8462336 14905216
14:12:10 4985 8192000000 10788175232 11215990784 1879898896 18.664 100 29 58 2 1895262400 7269104 8094400
14:12:21 12407 8192000000 10796169696 11217436672 1881237728 18.675 100 21 43 0 1893914592 5677440 6999424
14:12:41 2610 8192000000 10806015008 11218538496 1887824176 18.728 100 48 90 2 1908725328 7552064 13349088
14:12:52 4319 8192000000 10813540688 11226890240 1890167408 18.747 100 52 103 2 1914206192 8068864 15969920
14:13:06 9917 8192000000 10792076256 11220467712 1885859744 18.712 100 15 30 1 1896924016 6200848 4863424
14:13:23 9762 8192000000 10794357696 11228688384 1890127728 18.747 100 23 46 2 1903363712 6897040 6338944
14:13:43 10806 8192000000 10819024368 11237789696 1902100832 18.843 100 31 60 1 1916353552 5862896 8389824
14:14:00 6528 8192000000 10805316464 11235098624 1898378752 18.813 100 24 48 1 1916369808 11619360 6371696
14:14:15 6797 8192000000 10806953904 11238133760 1900034240 18.827 100 18 36 0 1911252288 6106128 5111920
14:14:30 12205 8192000000 10816940192 11238465536 1904553008 18.863 100 26 51 2 1917376096 5207968 7615120
14:14:49 64562 8192000000 10842659936 11252899840 1906653456 18.880 100 48 94 3 1926380000 5859104 13867440
14:16:00 2416 8192000000 10831192944 11258216448 1911584768 18.919 100 49 97 1 1935984976 10580448 13819760
14:16:11 4271 8192000000 10822603088 11253305344 1911803216 18.921 100 31 62 0 1927160560 6816192 8541152
14:16:23 7097 8192000000 10839358416 11264946176 1912947360 18.930 100 37 74 3 1939177232 15692800 10537072
14:16:39 4705 8192000000 10826563712 11258097664 1912277232 18.925 100 34 67 2 1928846928 7188496 9381200
14:16:52 4919 8192000000 10837222368 11263123456 1914790560 18.945 100 47 94 3 1939868096 11408640 13668896
14:17:04 5238 8192000000 10811993264 11234217984 1856394144 18.474 98 27 55 0 1874576080 10301888 7880048
14:17:19 6084 8192000000 10801162272 11231363072 1873180912 18.610 99 29 58 1 1887798992 6380928 8237152
14:17:32 4723 8192000000 10786513616 11219283968 1878999792 18.657 99 29 58 0 1893934912 6451712 8483408
14:17:42 10080 8192000000 10756014688 11181391872 1783690624 17.880 95 23 46 0 1795963088 5293824 6978640
14:18:00 15703 8192000000 10768040640 11194609664 1830175136 18.261 98 35 70 2 1847392768 6496224 10721408
14:18:51 17132 8192000000 10758087136 11185102848 1780538096 17.854 95 28 55 3 1795119264 6692960 7888208
14:19:19 7397 8192000000 10708052736 11119230976 1721891008 17.368 94 30 59 5 1737245104 6343024 9011072
14:19:34 5882 8192000000 10699978976 11114020864 1768802368 17.757 97 38 75 1 1786721472 6685632 11233472
14:19:47 4305 8192000000 10721906784 11133898752 1778087808 17.834 97 31 61 1 1793284304 6727200 8469296
14:19:58 4388 8192000000 10710098832 11123998720 1772289424 17.786 98 38 75 1 1791096400 8000320 10806656
14:20:09 8454 8192000000 10729664176 11154358272 1811161792 18.105 100 38 75 1 1829164864 7576672 10426400
14:20:24 6329 8192000000 10740548512 11164246016 1825054160 18.219 100 22 44 4 1837337232 5500096 6782976
14:20:40 4406 8192000000 10753836832 11178254336 1841137824 18.350 100 28 56 6 1855550480 6465440 7947216
14:20:52 6797 8192000000 10703813904 11117182976 1750463408 17.605 96 18 36 0 1761822272 5582432 5776432
14:21:08 10681 8192000000 10694461712 11113893888 1753437952 17.630 97 16 32 0 1763448096 5654800 4355344
14:21:28 4348 8192000000 10705713968 11114242048 1754888960 17.642 98 31 62 2 1770203040 5395440 9918640
14:21:38 6576 8192000000 10697007728 11108708352 1756432528 17.655 98 20 40 2 1771876528 9612832 5831168
14:21:51 6665 8192000000 10718445200 11141709824 1808054032 18.080 100 26 52 2 1821875296 6468016 7353248
14:22:07 8927 8192000000 10709500064 11123867648 1786046224 17.899 99 36 72 4 1802472080 6288816 10137040
14:22:22 20022 8192000000 10703992752 11126882304 1770075888 17.768 98 34 68 0 1786555904 6320912 10159104
14:23:23 9060 8192000000 10721182816 11133952000 1777066336 17.825 98 46 94 3 1797116304 6055616 13994352
14:23:45 10432 8192000000 10731403152 11156504576 1816968000 18.153 100 22 44 3 1828705792 5440208 6297584
14:24:03 7123 8192000000 10740560096 11151593472 1790314912 17.934 98 28 56 1 1805010496 6380512 8315072
14:24:17 7572 8192000000 10729061968 11159990272 1825854960 18.226 100 24 49 1 1843388352 10997712 6535680
14:24:31 7455 8192000000 10738321392 11166167040 1829287584 18.254 100 27 54 3 1843881184 6343952 8249648
14:24:46 7654 8192000000 10757657536 11174166528 1823446288 18.206 99 33 66 4 1839467408 6908400 9112720
14:25:03 5644 8192000000 10767574384 11186343936 1847655712 18.403 100 34 67 2 1863315984 6451328 9208944
14:25:15 7374 8192000000 10764588480 11188088832 1848839888 18.413 100 30 60 2 1864179920 7136288 8203744
14:25:29 8619 8192000000 10770363648 11194130432 1853394736 18.450 100 32 65 0 1872603024 10561200 8647088
14:25:48 5489 8192000000 10758315744 11185049600 1850318640 18.425 100 25 50 1 1863616256 6365280 6932336
14:26:01 8584 8192000000 10776948128 11197251584 1855559792 18.467 100 29 58 0 1869843568 5682480 8601296
14:26:19 12493 8192000000 10770055392 11199942656 1858393904 18.490 100 19 38 1 1870307344 6385808 5527632
14:26:41 10170 8192000000 10777362208 11202097152 1860474192 18.507 100 15 30 1 1869595088 5122464 3998432
14:26:57 10000 8192000000 10785253696 11210612736 1868530000 18.572 100 25 50 5 1880801216 5646528 6624688
14:27:13 102719 8192000000 10823405728 11244171264 1890378528 18.749 100 28 55 1 1902868816 5191504 7298784
14:29:08 34111 8192000000 10847181072 11269603328 1911700464 18.920 100 50 98 2 1934405952 8666608 14038880
14:29:52 10604 8192000000 10856397424 11272581120 1919804416 18.985 100 49 98 1 1944027248 10666144 13556688
14:30:14 18090 8192000000 10855980640 11280576512 1923137552 19.012 100 50 100 0 1948638688 11428544 14072592
14:30:40 12417 8192000000 10864780272 11287695360 1930122528 19.068 100 46 92 1 1953969312 11016736 12830048
14:31:01 12644 8192000000 10872646592 11296075776 1935902880 19.114 100 54 109 2 1962179472 11200096 15076496
14:31:21 17400 8192000000 10875497472 11303014400 1941120656 19.156 100 43 86 2 1964734592 11157376 12456560
14:31:55 39804 8192000000 10879279712 11309977600 1945803952 19.193 100 37 74 0 1972235200 15283312 11147936
14:32:43 25440 8192000000 10870321264 11317518336 1950954208 19.234 100 39 78 2 1978915616 16173584 11787824
14:33:15 22357 8192000000 10892788544 11322580992 1956910784 19.281 100 38 72 1 1980612288 12792656 10908848
14:33:46 12104 8192000000 10907055008 11333869568 1967454560 19.365 100 43 86 0 1992946080 13543952 11947568
14:34:05 9899 8192000000 10912889872 11340206080 1970380448 19.388 100 54 106 2 2001165568 15262080 15523040
14:34:22 4258 8192000000 10930655856 11355381760 1978171200 19.450 100 68 132 0 2016934752 19839072 18924480
14:34:39 10992 8192000000 10915343536 11343183872 1959966256 19.306 99 58 116 1 1996439152 19605216 16867680
14:34:57 7994 8192000000 10935312528 11358351360 1981307872 19.475 100 61 121 2 2017910768 18996768 17606128
14:35:18 9338 8192000000 10922960512 11351674880 1981523376 19.477 100 63 126 2 2019463232 19716736 18223120
14:35:40 3895 8192000000 10937336896 11363926016 1984641824 19.501 100 66 130 2 2027080608 23145472 19293312
14:36:01 4787 8192000000 10940529376 11370487808 1990888736 19.551 100 58 116 1 2030974112 23025072 17060304
14:36:13 5900 8192000000 10952716928 11380248576 1998275744 19.609 100 66 131 2 2042610688 24790432 19544512
14:36:26 2764 8192000000 10950589392 11373764608 1991719552 19.557 100 77 153 2 2040434928 25391536 23323840
14:36:36 12236 8192000000 10948690528 11378409472 1993286288 19.570 100 65 130 2 2039652512 26845968 19520256
14:36:58 11084 8192000000 10949900320 11377291264 1989353136 19.539 100 56 112 3 2033560928 27384704 16823088
14:37:22 6810 8192000000 10954357104 11381530624 1994336784 19.578 100 57 114 2 2040947968 28961360 17649824
14:37:38 10780 8192000000 10948078816 11376394240 1977435472 19.444 99 57 113 2 2024709616 30487712 16786432
14:37:57 5377 8192000000 10943519920 11376578560 1975077456 19.426 99 61 118 4 2024478064 30691376 18709232
14:38:16 4490 8192000000 10943521984 11379720192 1981241936 19.475 99 60 120 1 2031009904 31737904 18030064
14:38:29 3483 8192000000 10954060144 11382935552 1994011104 19.575 100 67 131 2 2041446224 28128336 19306784
14:38:40 5459 8192000000 10964385520 11389681664 1998739808 19.613 100 68 136 0 2049370560 30323424 20307328
14:38:53 4360 8192000000 10964714352 11388661760 2003695056 19.652 100 69 138 5 2054679424 30277184 20707184
14:39:05 8627 8192000000 10957604384 11385024512 1993997280 19.575 100 56 112 1 2040515488 29717952 16800256
14:39:22 2238 8192000000 10962737392 11392512000 2000657216 19.628 100 63 125 3 2049111472 29607664 18846592
14:39:32 3347 8192000000 10972022128 11394805760 2003088736 19.647 100 71 140 1 2054804080 30710944 21004400
14:39:42 2546 8192000000 10963450352 11394420736 1999045504 19.615 100 68 136 1 2052624272 32173328 21405440
14:39:52 10777 8192000000 10971912544 11404951552 2008110416 19.687 100 63 123 2 2061152352 33679104 19362832
14:40:11 9793 8192000000 10944455936 11373203456 1953328048 19.253 97 63 126 0 2006895552 34331840 19235664
14:40:28 5247 8192000000 10959924160 11386011648 1987269472 19.522 100 65 129 2 2044620560 37614112 19736976
14:40:42 8494 8192000000 10969380592 11402395648 2000025808 19.623 100 64 128 0 2058132816 38127600 19979408
14:40:58 12421 8192000000 10951456976 11392385024 1974895328 19.424 99 47 94 0 2029277696 39522256 14860112
14:41:21 2359 8192000000 10990116608 11404263424 1998673600 19.612 100 87 172 0 2064550096 39000368 26876128
14:41:31 1111 8192000000 10970351632 11384823808 1976213728 19.435 99 77 154 2 2040616848 40169456 24233664
14:41:39 4405 8192000000 10968084160 11383246848 1971079936 19.394 99 89 178 1 2037807344 39435408 27292000
14:41:50 1571 8192000000 10964335104 11382890496 1984876640 19.503 100 87 174 0 2051424240 39636560 26911040
14:41:59 2003 8192000000 10972021248 11388489728 1990481664 19.548 100 82 164 0 2053640208 37237216 25921328
14:42:10 6245 8192000000 10958619040 11381448704 1985076256 19.505 100 78 157 0 2045430848 36788896 23565696
14:42:24 4133 8192000000 10949757088 11361492992 1966710128 19.359 99 82 162 1 2029644464 37826864 25107472
14:42:37 1700 8192000000 10971320448 11391381504 1990755440 19.550 100 84 168 2 2055277984 39308752 25213792
14:42:47 2545 8192000000 10942513456 11356368896 1952980096 19.250 99 82 162 2 2016824000 39202208 24641696
14:42:57 7171 8192000000 10930448416 11356602368 1961153376 19.315 100 74 146 0 2023168720 38924176 23091168
14:43:12 5833 8192000000 10924018544 11352887296 1957204784 19.284 100 64 128 3 2016497568 39450096 19842688
14:43:28 4794 8192000000 10936883696 11362041856 1964398976 19.341 100 69 137 2 2025020416 39208864 21412576
14:43:44 3676 8192000000 10954383856 11377373184 1975836752 19.432 100 75 149 3 2041288480 41817456 23634272
14:43:55 997 8192000000 10963229312 11376771072 1980716944 19.470 100 92 184 2 2048518912 40654288 27147680
14:44:03 3845 8192000000 10965344720 11383382016 1979715568 19.462 100 70 138 2 2042327504 41595632 21016304
14:44:19 3073 8192000000 10966484400 11387187200 1969487376 19.381 99 73 145 1 2034698336 43130016 22080944
14:44:31 1568 8192000000 10976076800 11395276800 1987048512 19.520 100 71 141 0 2052432816 43475584 21908720
14:44:40 4780 8192000000 10966117968 11393970176 1989515088 19.540 100 64 124 0 2053107424 44596976 18995360
14:44:53 5248 8192000000 10959451216 11393093632 1968653136 19.375 99 57 113 1 2030489936 43853408 17983392
14:45:08 8562 8192000000 10963367536 11388616704 1978302208 19.451 100 58 116 3 2045034688 47086032 19646448
14:45:29 5116 8192000000 10989079072 11404947456 1988303520 19.530 100 67 134 1 2059062544 49624320 21134704
14:45:43 4256 8192000000 10951616768 11372756992 1940277440 19.149 98 71 142 0 2007812144 44346880 23187824
14:45:55 987 8192000000 10956705920 11371868160 1963272688 19.332 100 89 179 1 2037644368 46588384 27783296
14:46:04 10087 8192000000 10931585104 11368845312 1955055296 19.267 100 53 106 0 2019709744 47492512 17161936
14:46:21 16112 8192000000 10900113600 11340709888 1909677088 18.904 98 37 74 1 1966528000 44340240 12510672
14:46:45 12842 8192000000 10920884992 11360768000 1937511584 19.127 99 43 85 0 1994717776 43534448 13671744
14:47:05 5264 8192000000 10947556576 11376140288 1963894752 19.337 100 57 113 1 2027186976 44898240 18393984
14:47:20 6797 8192000000 10933369408 11361484800 1951453952 19.238 100 52 102 0 2012559936 44657840 16448144
14:47:42 5327 8192000000 10934008960 11367006208 1946088800 19.195 99 51 102 1 2007640672 45148432 16403440
14:47:54 9855 8192000000 10941199296 11383484416 1962486592 19.326 100 42 85 1 2027002432 51192880 13322960
14:48:10 15359 8192000000 10921235856 11371593728 1920355760 18.990 98 31 62 0 1979035456 48157440 10522256
14:48:33 11064 8192000000 10910768368 11361910784 1944852480 19.185 100 26 49 3 1995281952 41706368 8723104
14:49:03 6269 8192000000 10941152352 11368685568 1944157328 19.180 99 62 123 2 2006433648 42190448 20085872
14:49:15 14213 8192000000 10912594288 11352535040 1928169312 19.052 99 43 86 1 1986962512 44512624 14280576
14:49:36 20622 8192000000 10893504368 11346857984 1919040176 18.979 99 27 54 2 1970926208 43115264 8770768
14:50:30 10366 8192000000 10900030800 11335692288 1922931392 19.010 100 38 76 0 1980860656 45389840 12539424
14:50:47 8532 8192000000 10910866544 11351797760 1930246192 19.069 100 35 69 0 1989297760 47711664 11339904
14:51:05 15526 8192000000 10888936720 11343638528 1894942960 18.786 98 30 60 0 1956009840 50538176 10528704
14:51:28 18452 8192000000 10888260320 11338706944 1920775024 18.993 100 26 50 2 1976450752 46585600 9090128
14:51:54 34384 8192000000 10886591984 11329785856 1907510272 18.887 99 23 46 1 1951824096 36705008 7608816
14:52:36 48439 8192000000 10864775520 11327062016 1887870544 18.729 98 15 30 1 1930961248 37789776 5300928
14:53:31 23278 8192000000 10864971280 11326328832 1918210752 18.973 100 22 43 2 1954418288 28438848 7768688
14:54:09 8739 8192000000 10872231056 11331420160 1925795024 19.033 100 32 63 0 1962595232 26056688 10743520
14:54:37 55192 8192000000 10860821408 11325624320 1905404704 18.870 99 13 26 0 1928554496 18974032 4175760
14:55:46 32678 8192000000 10849221888 11297742848 1901839680 18.841 99 26 50 0 1920034064 10438848 7755536
14:57:04 41987 8192000000 10854602688 11320070144 1897269328 18.804 98 12 24 0 1914502896 13942000 3291568
14:58:16 45012 8192000000 10852434768 11312082944 1916220432 18.957 99 13 26 0 1932591344 12619312 3751600
14:59:15 69481 8192000000 10863556272 11335782400 1938069552 19.131 100 13 26 0 1956180384 14453952 3656880
15:00:53 63632 8192000000 10848471872 11301527552 1866726640 18.558 96 15 29 0 1886463296 16191600 3545056
15:02:15 60322 8192000000 10872123920 11314778112 1896648240 18.799 98 20 39 1 1914116336 11948048 5520048
15:03:24 81326 8192000000 10863802592 11322478592 1904994512 18.866 98 25 50 2 1923399232 11308016 7096704
15:04:53 77548 8192000000 10901644864 11351638016 1963975200 19.338 100 21 42 1 1979221392 8989008 6257184
15:06:45 107658 8192000000 10885838560 11348529152 1939652672 19.144 99 18 36 1 1953957040 8471264 5833104
15:08:44 55100 8192000000 10881455616 11344523264 1948853424 19.217 99 42 84 2 1971507824 11053888 11600512
15:09:47 89366 8192000000 10896411984 11356508160 1934539952 19.103 98 31 62 0 1952256176 8980496 8735728
15:11:35 55048 8192000000 10923650208 11371163648 1979340000 19.459 100 29 58 1 1998456720 10736800 8379920
15:12:51 55796 8192000000 10894599168 11373449216 1977503456 19.445 100 14 28 0 1995740752 13752864 4484432
15:14:25 25134 8192000000 10876702592 11346812928 1936036608 19.115 98 9 18 0 1945848912 6868320 2943984
15:15:03 60490 8192000000 10886897120 11362684928 1972037968 19.402 100 11 22 1 1987900864 12755072 3107824
15:16:10 70134 8192000000 10874264592 11350102016 1948427280 19.214 99 13 26 0 1959221632 7196576 3597776
15:17:26 25971 8192000000 10896393360 11359649792 1970822496 19.392 100 22 45 2 1984978528 7786528 6369504
15:18:02 74382 8192000000 10908062208 11391807488 1980104320 19.466 100 7 14 0 2000183840 17936960 2142560
15:19:59 32561 8192000000 10888037584 11362750464 1963806288 19.336 99 28 56 2 1979698000 8015920 7875792
15:20:40 52307 8192000000 10899605344 11372335104 1961247216 19.316 99 24 48 2 1977032000 9148528 6636256
15:21:53 45157 8192000000 10914570256 11384610816 1965002736 19.346 99 13 26 1 1980608192 11521984 4083472
15:23:06 51244 8192000000 10931749392 11394793472 1985349616 19.507 100 13 26 0 2005315552 15435056 4530880
15:24:05 50057 8192000000 10915929792 11389837312 1938031680 19.131 97 24 48 3 1959198272 14360096 6806496
15:25:03 90681 8192000000 10886369584 11355168768 1897721488 18.808 96 14 28 2 1916856320 14807152 4327680
15:26:40 56681 8192000000 10914279824 11363389440 1934065616 19.099 98 27 55 2 1956625696 14982464 7577616
15:27:47 72275 8192000000 10902241408 11377414144 1926911584 19.042 98 16 32 1 1941810048 11092160 3806304
15:29:15 113036 8192000000 10856794464 11304157184 1766279712 17.736 89 16 32 1 1779022912 8614912 4128288
15:31:14 73203 8192000000 10892170176 11336159232 1911969200 18.922 98 37 74 1 1934636176 11898672 10768304
15:32:33 74438 8192000000 10890537712 11342557184 1913758560 18.937 98 29 58 0 1935788304 13677584 8352160
15:33:59 13893 8192000000 10873724960 11325890560 1913406768 18.934 98 37 74 1 1938481808 14428480 10646560
15:34:33 34535 8192000000 10879830640 11350269952 1932860384 19.090 99 32 64 0 1958674928 16793008 9021536
15:36:28 43274 8192000000 10847097280 11316973568 1918709392 18.977 99 15 30 1 1937190832 13922960 4558480
15:37:58 81818 8192000000 10856193248 11342389248 1923363888 19.014 99 12 23 0 1945595408 18746032 3485488
15:39:39 40087 8192000000 10870368256 11340566528 1928345680 19.054 99 8 16 0 1941992576 11431760 2215136
15:40:28 63777 8192000000 10854588992 11317874688 1856485376 18.475 95 13 26 0 1870602848 10135840 3981632
15:41:42 83063 8192000000 10808710272 11269419008 1749565872 17.598 91 12 24 0 1761519776 8478608 3475296
15:43:22 57557 8192000000 10844856672 11309223936 1909779840 18.905 100 25 50 0 1928077040 10964592 7332608
15:44:36 126945 8192000000 10864962048 11343802368 1857023696 18.479 96 11 21 0 1879502144 19711776 2766672
15:46:49 131336 8192000000 10860250416 11329523712 1836393888 18.311 94 8 16 1 1853641808 15089632 2158288
15:49:07 116337 8192000000 10871810400 11340378112 1843736992 18.371 95 11 22 0 1860520592 13705536 3078064
15:51:30 123157 8192000000 10891402784 11371397120 1907823920 18.889 98 12 24 0 1928441840 17417392 3200528
15:53:43 126237 8192000000 10871313232 11356815360 1949856128 19.225 100 19 38 0 1979932000 24669600 5406272
15:55:59 27192 8192000000 10867007712 11337912320 1931776384 19.081 99 14 28 0 1943339744 7871888 3691472
15:56:36 22759 8192000000 10905352368 11358691328 1957575920 19.287 100 31 62 1 1977878512 11648672 8653920
15:57:05 35216 8192000000 10886810736 11357577216 1952302688 19.245 99 27 54 3 1969853152 10695024 6855440
15:59:30 55489 8192000000 10896769312 11382751232 1975999984 19.433 100 3 6 0 1984046048 7468416 577648
16:00:38 35335 8192000000 10916684640 11388334080 1989464816 19.540 100 11 20 1 2000954096 8400944 3088336
16:01:19 60795 8192000000 10895692896 11372384256 1926885712 19.042 97 26 52 1 1942572624 8385632 7301280
16:02:28 22321 8192000000 10912607424 11363155968 1956560704 19.279 99 47 93 1 1975508736 6229968 12718064
16:02:57 15193 8192000000 10901644432 11363262464 1954900256 19.265 99 34 68 0 1971771984 7732208 9139520
16:03:25 29986 8192000000 10901272560 11368636416 1960441072 19.310 99 39 76 0 1980851920 9069824 11341024
16:04:04 38162 8192000000 10907318128 11368505344 1943852192 19.177 98 19 38 0 1957551392 8361824 5337376
16:04:49 38575 8192000000 10897243760 11374215168 1957835744 19.289 99 19 38 2 1974521584 11149424 5536416
16:05:34 61925 8192000000 10925654160 11389788160 1964112320 19.339 99 15 30 0 1982058448 13082032 4864096
16:06:43 37897 8192000000 10940218848 11410255872 1998187264 19.608 100 26 52 0 2022353840 16475792 7690784
16:07:27 60350 8192000000 10935833872 11411353600 1983184176 19.490 99 13 26 0 2008531408 21301056 4046176
16:08:34 58308 8192000000 10951095232 11418984448 2002480064 19.642 100 25 50 2 2030806864 20651680 7675120
16:09:42 68457 8192000000 10946614880 11435057152 1999089440 19.616 100 10 20 1 2029575264 27326640 3159184
16:10:57 117336 8192000000 10924871872 11406565376 1944721856 19.184 97 11 22 0 1962372848 14577968 3073024
16:13:00 51917 8192000000 10942454752 11385962496 1951911536 19.242 98 31 61 1 1971753264 10803552 9038176
16:14:01 30259 8192000000 10922826000 11386580992 1974105008 19.418 99 37 74 1 1995498496 10719376 10674112
16:14:38 59012 8192000000 10910315264 11361955840 1916294304 18.957 97 22 44 0 1934990784 12312528 6383952
16:15:50 75556 8192000000 10878779392 11350282240 1946951312 19.202 99 27 54 1 1961776320 7007424 7817584
16:17:44 43916 8192000000 10880033760 11339067392 1905231136 18.868 97 26 52 1 1920295536 8058944 7005456
16:18:35 36143 8192000000 10846422480 11293544448 1888880432 18.737 97 46 92 1 1911059328 8878640 13300256
16:19:18 53029 8192000000 10839161936 11309105152 1857691456 18.485 96 26 52 2 1873775728 8861856 7222416
16:20:20 44093 8192000000 10860496016 11339808768 1939646512 19.144 100 8 16 1 1949452896 7520544 2285840
16:21:24 21974 8192000000 10881724816 11355602944 1957931936 19.290 100 9 18 0 1971978176 11229840 2816400
16:21:55 39531 8192000000 10863385312 11341160448 1899627824 18.823 97 7 14 0 1913414816 11574224 2212768
16:22:41 61336 8192000000 10866592880 11343192064 1941447504 19.158 100 13 26 0 1957832288 12106000 4278784
16:23:57 41314 8192000000 10874553520 11358183424 1943997008 19.179 100 18 36 0 1959974640 10791760 5185872
16:24:53 76581 8192000000 10869596400 11340607488 1905850240 18.873 97 19 37 0 1921366304 10286720 5229344
16:26:16 71072 8192000000 9498167312 9809498112 599439680 6.818 31 7 14 1 609387984 8190320 1757984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 15-03-2021 16:28:53 to 15-03-2021 16:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 59 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-03-2021 16:29:25 to 15-03-2021 16:29:27.

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          234708
MON$OLDEST_ACTIVE               236922
MON$OLDEST_SNAPSHOT             236922
MON$NEXT_TRANSACTION            236922
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                       2011136
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:94: 
:95: mscs-test-161.budzdorov.ru    Mon Mar 15 16:27:29 2021
:96:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:97: 
:98: 
:99: mscs-test-161.budzdorov.ru    Mon Mar 15 16:27:30 2021
:100:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:101: 
:102: 
:103: mscs-test-161.budzdorov.ru    Mon Mar 15 16:27:30 2021
:104:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:105: 
--- end of diff output ---

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

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