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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17155536 kB
MemAvailable 31097624 kB
Buffers 0 kB
Cached 14515716 kB
SwapCached 3892 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-02-21 16:27:19
DTS_END                         2021-02-21 16:27:19.0660
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/43268
TRN_ID                          229711
ATT_ID                          595
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: 9158.40 23092 1099008
customer order: creation 162.32 457 19479
customer order: refuse 13.58 329 1629
order to supplier: creation 42.09 1342 5051
order to supplier: removal 3.45 107344 414
invoice (draft): creation 43.75 3763 5250
invoice (draft): removal 53.67 777 6440
invoice accept: apply 39.31 18776 4717
invoice accept: cancel 48.86 770 5863
customer reserve: creation 3664.61 184 439753
customer reserve: removal 4809.13 61 577096
realization accept: apply 78.07 190 9368
realization accept: cancel 78.58 126 9430
payment from customer: creation 55.68 122 6682
payment from customer: removal 5.20 77 624
payment to supplier: creation 45.42 137 5450
payment to supplier: removal 2.97 65 356
service: total inventory turnovers 4.57 1121 548
service: total monetary turnovers 6.21 29 745
service: aggregate perf. data 0.91 16183 109
service: refresh index statistics 0.03 309992 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-02-2021 16:28:17 to 21-02-2021 16:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3134
TEST_TIME 2 3048
TEST_TIME 3 3938
TEST_TIME 4 4204
TEST_TIME 5 4237
TEST_TIME 6 4076
TEST_TIME 7 4506
TEST_TIME 8 4246
TEST_TIME 9 4497
TEST_TIME 10 4611
TEST_TIME 11 5016
TEST_TIME 12 5639
TEST_TIME 13 6086
TEST_TIME 14 6273
TEST_TIME 15 6937
TEST_TIME 16 6850
TEST_TIME 17 7448
TEST_TIME 18 7921
TEST_TIME 19 7986
TEST_TIME 20 8193
TEST_TIME 21 8773
TEST_TIME 22 9285
TEST_TIME 23 9896
TEST_TIME 24 9882
TEST_TIME 25 9991
TEST_TIME 26 11077
TEST_TIME 27 10931
TEST_TIME 28 10634
TEST_TIME 29 10506
TEST_TIME 30 10481
TEST_TIME 31 10498
TEST_TIME 32 10363
TEST_TIME 33 10238
TEST_TIME 34 10132
TEST_TIME 35 10001
TEST_TIME 36 9912
TEST_TIME 37 9659
TEST_TIME 38 9825
TEST_TIME 39 9701
TEST_TIME 40 9589
TEST_TIME 41 9519
TEST_TIME 42 9620
TEST_TIME 43 9587
TEST_TIME 44 9534
TEST_TIME 45 9546
TEST_TIME 46 9587
TEST_TIME 47 9676
TEST_TIME 48 9633
TEST_TIME 49 9574
TEST_TIME 50 9444
TEST_TIME 51 9646
TEST_TIME 52 9695
TEST_TIME 53 9758
TEST_TIME 54 9874
TEST_TIME 55 9845
TEST_TIME 56 9720
TEST_TIME 57 9585
TEST_TIME 58 9548
TEST_TIME 59 9541
TEST_TIME 60 9555
TEST_TIME 61 9422
TEST_TIME 62 9380
TEST_TIME 63 9312
TEST_TIME 64 9325
TEST_TIME 65 9266
TEST_TIME 66 9345
TEST_TIME 67 9324
TEST_TIME 68 9280
TEST_TIME 69 9193
TEST_TIME 70 9394
TEST_TIME 71 9416
TEST_TIME 72 9411
TEST_TIME 73 9433
TEST_TIME 74 9387
TEST_TIME 75 9449
TEST_TIME 76 9448
TEST_TIME 77 9436
TEST_TIME 78 9471
TEST_TIME 79 9458
TEST_TIME 80 9377
TEST_TIME 81 9367
TEST_TIME 82 9322
TEST_TIME 83 9260
TEST_TIME 84 9233
TEST_TIME 85 9179
TEST_TIME 86 9181
TEST_TIME 87 9166
TEST_TIME 88 9139
TEST_TIME 89 9146
TEST_TIME 90 9142
TEST_TIME 91 9126
TEST_TIME 92 9105
TEST_TIME 93 9143
TEST_TIME 94 9213
TEST_TIME 95 9173
TEST_TIME 96 9181
TEST_TIME 97 9168
TEST_TIME 98 9205
TEST_TIME 99 9258
TEST_TIME 100 9255
TEST_TIME 101 9267
TEST_TIME 102 9346
TEST_TIME 103 9325
TEST_TIME 104 9326
TEST_TIME 105 9246
TEST_TIME 106 9237
TEST_TIME 107 9216
TEST_TIME 108 9203
TEST_TIME 109 9170
TEST_TIME 110 9159
TEST_TIME 111 9134
TEST_TIME 112 9108
TEST_TIME 113 9089
TEST_TIME 114 9171
TEST_TIME 115 9173
TEST_TIME 116 9144
TEST_TIME 117 9155
TEST_TIME 118 9201
TEST_TIME 119 9199
TEST_TIME 120 9162

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2021 16:28:21 to 21-02-2021 16:28:24.

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 1507265 1507265 0 0.00 0 25011 6 0 0
doc_list_biud 1507265 1507265 0 0.00 0 31840 29 0 0
sp_add_invoice_to_stock 4858 4717 141 2.90 37 215741 18776 0 141
sp_cancel_adding_invoice 5863 5863 0 0.00 4 84932 770 0 0
sp_cancel_client_order 1629 1629 0 0.00 4 10350 329 0 0
sp_cancel_customer_reserve 577096 577096 0 0.00 1 31844 61 0 0
sp_cancel_pay_from_customer 624 624 0 0.00 3 5303 78 0 0
sp_cancel_pay_to_supplier 356 356 0 0.00 3 3216 66 0 0
sp_cancel_supplier_invoice 6451 6440 11 0.17 2 12197 778 0 11
sp_cancel_supplier_order 414 414 0 0.00 4 1142197 107345 0 0
sp_cancel_write_off 9430 9430 0 0.00 1 33857 126 0 0
sp_client_order 19479 19479 0 0.00 4 36941 458 0 0
sp_customer_reserve 439753 439753 0 0.00 0 51343 184 0 0
sp_fill_shopping_cart 29752 29752 0 0.00 1 15182 37 0 0
sp_fill_shopping_cart_clo_res 439735 439735 0 0.00 0 22865 15 0 0
sp_get_clo_for_invoice 4699 4699 0 0.00 0 32337 354 0 0
sp_kill_cost_storno 16273 16273 0 0.00 0 24693 59 0 0
sp_kill_qstorno_ret_qs2qd 1170476 1170476 0 0.00 0 31816 33 0 0
sp_kill_qty_storno 614939 614939 0 0.00 0 31839 71 0 0
sp_lock_selected_doc 19431 19431 0 0.00 0 10380 7 0 0
sp_make_cost_storno 26199 26199 0 0.00 0 19041 59 0 0
sp_multiply_rows_for_pdistr 26199 26199 0 0.00 0 8031 31 0 0
sp_multiply_rows_for_qdistr 19479 19479 0 0.00 0 28695 205 0 0
sp_pay_from_customer 6682 6682 0 0.00 3 17705 123 0 0
sp_pay_to_supplier 5450 5450 0 0.00 5 14787 138 0 0
sp_payment_common 12132 12132 0 0.00 2 12933 35 0 0
sp_qd_handle_on_cancel_clo 1629 1629 0 0.00 0 10343 295 0 0
sp_qd_handle_on_invoice_upd_sts 10562 10562 0 0.00 0 18756 314 0 0
sp_qd_handle_on_reserve_upd_sts 9368 9368 0 0.00 0 17990 69 0 0
sp_reserve_write_off 9368 9368 0 0.00 6 20047 191 0 0
sp_supplier_invoice 5250 5250 0 0.00 5 92800 3764 0 0
sp_supplier_order 5051 5051 0 0.00 5 75570 1343 0 0
srv_aggregate_perf_data 109 109 0 0.00 2674 138028 16183 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 768 116954 33217 0 0
srv_find_qd_qs_mism 1054565 1054565 0 0.00 0 25010 5 0 0
srv_make_invnt_saldo 548 548 0 0.00 32 114250 1122 0 0
srv_make_money_saldo 745 745 0 0.00 0 2067 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 206458 437144 309992 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4717 4717 0 0.00 0 25467 164 0 0
t$perf-norm:sp_cancel_adding_invoice 397 397 0 0.00 0 6166 95 0 0
t$perf-norm:sp_cancel_client_order 1629 1629 0 0.00 0 6973 17 0 0
t$perf-norm:sp_cancel_customer_reserve 611 611 0 0.00 0 1330 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 624 624 0 0.00 0 1217 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 356 356 0 0.00 0 193 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 2050 15 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 29633 1588 0 0
t$perf-norm:sp_cancel_write_off 957 957 0 0.00 0 2352 6 0 0
t$perf-norm:sp_client_order 19479 19479 0 0.00 0 6552 16 0 0
t$perf-norm:sp_customer_reserve 920 920 0 0.00 0 3152 7 0 0
t$perf-norm:sp_pay_from_customer 6682 6682 0 0.00 0 27685 15 0 0
t$perf-norm:sp_pay_to_supplier 5450 5450 0 0.00 0 27679 14 0 0
t$perf-norm:sp_reserve_write_off 9368 9368 0 0.00 0 27690 17 0 0
t$perf-norm:sp_supplier_invoice 5250 5250 0 0.00 0 3116 12 0 0
t$perf-norm:sp_supplier_order 5051 5051 0 0.00 0 18383 19 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 156 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 1023 11 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 1138 23 0 0
t$perf-norm:srv_make_money_saldo 745 745 0 0.00 0 816 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 9680 9398 282 2.91 0 10829 20 0 282
v_all_customers 35748 35748 0 0.00 0 44 1 0 0
v_all_suppliers 28456 28456 0 0.00 0 23 1 0 0
v_all_wares 38958 38958 0 0.00 0 72 1 0 0
v_cancel_adding_invoice 794 794 0 0.00 0 892 8 0 0
v_cancel_client_order 3258 3258 0 0.00 0 3864 7 0 0
v_cancel_customer_prepayment 1248 1248 0 0.00 0 5261 9 0 0
v_cancel_customer_reserve 1222 1222 0 0.00 0 2338 6 0 0
v_cancel_payment_to_supplier 712 712 0 0.00 0 1835 6 0 0
v_cancel_supplier_invoice 774 752 22 2.84 0 1241 20 0 22
v_cancel_supplier_order 828 828 0 0.00 0 2638 9 0 0
v_cancel_write_off 1914 1914 0 0.00 0 6794 16 0 0
v_max_id_clo_ord 5043 5043 0 0.00 0 3318 2 0 0
v_max_id_clo_res 920 920 0 0.00 0 1471 12 0 0
v_max_id_ord_sup 5230 5230 0 0.00 0 4197 3 0 0
v_max_non_paid_invoice 1495 1495 0 0.00 0 1273 3 0 0
v_max_non_paid_realizn 3384 3384 0 0.00 0 5667 9 0 0
v_min_id_clo_ord 5043 5043 0 0.00 0 2812 5 0 0
v_min_id_clo_res 920 920 0 0.00 0 1504 4 0 0
v_min_id_ord_sup 5230 5230 0 0.00 0 7131 6 0 0
v_min_non_paid_invoice 5450 5450 0 0.00 0 11145 21 0 0
v_min_non_paid_realizn 6682 6682 0 0.00 0 8041 23 0 0
v_our_firm 9806 9806 0 0.00 0 15 1 0 0
v_reserve_write_off 18736 18736 0 0.00 0 5230 6 0 0
x_lock_depdocs_on_canc_invoice 11927 11927 0 0.00 0 14898 117 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 2996 312 0 0
x_make_qstorno_1000_1200 5051 5051 0 0.00 1 75388 1272 0 0
x_make_qstorno_1200_2000 5250 5250 0 0.00 3 92648 3623 0 0
x_make_qstorno_2100_3300 439753 439753 0 0.00 0 47389 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2021 16:28:25 to 21-02-2021 16:28:29.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 8241 8192000000 10162029104 10457616384 799001552 8.886 64 48 99 0 816928832 2157376 15769904
13:57:45 25670 8192000000 10318429504 10630594560 1341233760 14.069 100 86 173 0 1375115264 4270736 29610768
13:58:23 25356 8192000000 10372206368 10690805760 1417284496 14.749 100 86 172 0 1451018352 5486256 28247600
13:59:04 26530 8192000000 10400685232 10725453824 1453347392 15.067 100 85 170 0 1486787456 6775152 26664912
13:59:40 25941 8192000000 10420036176 10749968384 1474193696 15.251 100 88 175 0 1509875152 7993088 27688368
14:00:15 21075 8192000000 10441408576 10774200320 1492797264 15.413 100 84 168 1 1528259808 8532928 26929616
14:00:44 11160 8192000000 10452359072 10787766272 1510104672 15.564 100 88 176 0 1546900496 9135872 27659952
14:01:05 20648 8192000000 10481973936 10817748992 1524784016 15.692 100 87 174 1 1561463264 9274784 27404464
14:01:39 16276 8192000000 10491323424 10837385216 1547904416 15.892 100 80 160 0 1582761248 9849760 25007072
14:02:03 10724 8192000000 10514727008 10866802688 1574764544 16.123 100 71 142 1 1605932704 9742608 21425552
14:02:26 12074 8192000000 10554800384 10907451392 1606676544 16.396 100 79 158 0 1640541472 10546768 23318160
14:02:47 12408 8192000000 10580610896 10935971840 1632312528 16.615 100 86 172 3 1668963216 11036320 25614368
14:03:13 12494 8192000000 10597027792 10956443648 1656853104 16.822 100 78 156 1 1691427152 11779040 22795008
14:03:33 8790 8192000000 10610188544 10973163520 1669810928 16.932 100 82 164 0 1706012160 12609504 23591728
14:03:51 7778 8192000000 10635675456 11001655296 1690508592 17.106 100 81 162 0 1726244880 12374208 23362080
14:04:07 9686 8192000000 10647283120 11017310208 1709307360 17.263 100 80 159 0 1744269440 12246512 22715568
14:04:25 7566 8192000000 10650963952 11023659008 1719246576 17.346 100 83 166 0 1756265952 12146528 24872848
14:04:41 6740 8192000000 10674635552 11048292352 1729998736 17.435 100 72 143 2 1761659472 11437776 20222960
14:04:56 7046 8192000000 10684296880 11063144448 1747888112 17.584 100 79 157 1 1782533632 11949296 22696224
14:05:11 3910 8192000000 10700843040 11075452928 1757979152 17.668 100 82 164 0 1793651344 12487408 23184784
14:05:22 6890 8192000000 10709803152 11088056320 1768764736 17.757 100 84 167 2 1805495408 13229872 23500800
14:05:36 3671 8192000000 10710502192 11091570688 1774720336 17.806 100 81 163 1 1810505680 13690240 22095104
14:05:46 3409 8192000000 10728895936 11106508800 1783030736 17.874 100 88 174 1 1821389312 13414560 24944016
14:05:56 3513 8192000000 10726125968 11107753984 1787391216 17.910 100 81 161 1 1823576256 13322832 22862208
14:06:07 3689 8192000000 10733385856 11113070592 1792676128 17.954 100 89 178 1 1832046176 14648976 24721072
14:06:18 3629 8192000000 10737979968 11117883392 1800191232 18.015 100 86 172 2 1838899648 15025488 23682928
14:06:28 3223 8192000000 10742765776 11122708480 1803515632 18.043 100 86 172 2 1843271424 15087776 24668016
14:06:38 3045 8192000000 10747845568 11132477440 1808216992 18.081 100 91 180 1 1848816944 15194720 25405232
14:06:51 5911 8192000000 10753250320 11135561728 1811736352 18.110 100 80 160 0 1847911232 14026048 22148832
14:07:04 2156 8192000000 10759899584 11145924608 1820546336 18.182 100 78 156 0 1856953216 14035744 22371136
14:07:12 2837 8192000000 10769701168 11151982592 1824898368 18.218 100 90 180 1 1864604416 13848064 25857984
14:07:22 2175 8192000000 10781333488 11161759744 1835814672 18.307 100 90 180 0 1875011184 14083280 25113232
14:07:30 2961 8192000000 10787503216 11174391808 1842850336 18.364 100 91 182 1 1885887760 17686848 25350576
14:07:39 1626 8192000000 10780989904 11173343232 1843599568 18.370 100 88 178 1 1880342000 11787040 24955392
14:07:47 1811 8192000000 10797032224 11182051328 1851462496 18.434 100 93 187 1 1890876192 13283984 26129712
14:07:56 2701 8192000000 10790737184 11179855872 1852364672 18.441 100 92 183 2 1890639024 12632720 25641632
14:08:05 1511 8192000000 10797823024 11185184768 1855598880 18.468 100 90 181 1 1894643152 13336064 25708208
14:08:13 2593 8192000000 10799114560 11184193536 1854939232 18.462 100 90 180 3 1895428192 15042208 25446752
14:08:22 1454 8192000000 10805770864 11192074240 1857822000 18.486 100 97 195 2 1899327840 14410784 27095056
14:08:30 1485 8192000000 10805444608 11193606144 1864600576 18.541 100 92 184 1 1904586624 14274432 25711616
14:08:38 1387 8192000000 10806583056 11192770560 1862025424 18.520 100 90 181 4 1899601840 12241072 25335344
14:08:46 2792 8192000000 10795082032 11194396672 1865625392 18.549 100 89 178 2 1902052624 11799792 24627440
14:08:55 38877 8192000000 10787732000 11193135104 1859245712 18.497 100 48 94 2 1880593104 7487984 13859408
14:09:40 11689 8192000000 10784612464 11198013440 1863102432 18.528 100 57 114 2 1889209888 9172368 16935088
14:09:59 5107 8192000000 10774703632 11195760640 1862967920 18.527 100 36 72 0 1881032576 7661552 10403104
14:10:12 5319 8192000000 10774362352 11199045632 1864091440 18.536 100 36 72 2 1887905680 13823984 9990256
14:10:24 7072 8192000000 10778416048 11198406656 1864770464 18.542 100 36 72 1 1881670384 6842160 10057760
14:10:39 3183 8192000000 10776830080 11199098880 1866632976 18.557 100 33 66 2 1883611840 8040800 8938064
14:10:50 5714 8192000000 10791753872 11209940992 1870117760 18.585 100 43 86 2 1891098576 8395840 12584976
14:11:05 11880 8192000000 10781286576 11203833856 1866599072 18.557 100 20 40 0 1878461248 5731792 6130384
14:11:25 5310 8192000000 10776654768 11205959680 1870652912 18.590 100 31 63 0 1885754000 6355808 8745280
14:11:42 7360 8192000000 10777654176 11206647808 1870354080 18.587 100 18 36 1 1881661984 6162496 5145408
14:12:00 11592 8192000000 10782558464 11214413824 1875881664 18.632 100 10 20 0 1883644048 5380448 2381936
14:12:19 13393 8192000000 10786783264 11220549632 1879769120 18.663 100 15 30 0 1890005360 5435952 4800288
14:12:40 15915 8192000000 10787111504 11224006656 1887803296 18.728 100 12 24 1 1896640160 5470528 3366336
14:13:02 7318 8192000000 10797730144 11233357824 1887554288 18.726 100 21 42 3 1900385904 7307824 5523792
14:13:16 43758 8192000000 10806456784 11236081664 1888601216 18.735 100 26 52 4 1902128304 5994256 7532832
14:14:06 26424 8192000000 10838410800 11244716032 1901005248 18.834 100 77 155 0 1929995600 5686704 23303648
14:14:39 6212 8192000000 10806412144 11243233280 1896020016 18.794 100 37 74 0 1915835632 9671744 10143872
14:14:52 6569 8192000000 10806793920 11238117376 1889732656 18.744 100 16 32 0 1899861664 5740160 4388848
14:15:05 10043 8192000000 10813062208 11241447424 1892295344 18.764 100 22 42 1 1905056128 5474448 7286336
14:15:21 5463 8192000000 10805584560 11244310528 1894914384 18.785 100 29 56 3 1910216320 7586528 7715408
14:15:34 8512 8192000000 10798170944 11233189888 1877491072 18.645 99 17 34 0 1888136368 5543408 5101888
14:15:49 9861 8192000000 10794891392 11234304000 1890366928 18.749 100 28 56 1 1908366640 10767504 7232208
14:16:07 8864 8192000000 10797655008 11228540928 1857030592 18.479 98 18 35 3 1867055408 5296608 4728208
14:16:26 7835 8192000000 10814440256 11237171200 1869710032 18.582 99 17 34 5 1880035584 5248656 5076896
14:16:44 8376 8192000000 10801666944 11232223232 1857150784 18.480 98 20 40 2 1868548432 5520384 5877264
14:17:01 11892 8192000000 10777209376 11203604480 1806943856 18.071 96 11 22 0 1815376848 5291472 3141520
14:17:19 4622 8192000000 10797098096 11220013056 1874750800 18.623 100 29 58 0 1889406992 6296288 8359904
14:17:30 65825 8192000000 10801292144 11233492992 1836492864 18.312 97 39 78 0 1857688576 9709120 11486592
14:18:44 12571 8192000000 10764958784 11190497280 1730854704 17.443 92 17 34 1 1741098208 5010832 5232672
14:19:05 5946 8192000000 10760775680 11176849408 1795208752 17.975 97 29 59 3 1808382752 5191456 7982544
14:19:17 5867 8192000000 10731545152 11146964992 1789184624 17.925 98 34 68 1 1806582128 7683408 9714096
14:19:29 5054 8192000000 10742948384 11163185152 1779327360 17.844 97 30 60 2 1794083584 6542448 8213776
14:19:42 8189 8192000000 10749580656 11166064640 1788535760 17.920 97 37 75 0 1805203600 5417280 11250560
14:19:57 7947 8192000000 10742664448 11161493504 1808899824 18.087 99 24 48 0 1821940016 6109696 6930496
14:20:11 5744 8192000000 10709598096 11125809152 1693444720 17.130 93 19 38 1 1708095184 8977296 5673168
14:20:26 5994 8192000000 10698208576 11120513024 1749587696 17.598 97 19 39 2 1760553872 5399568 5566608
14:20:38 7976 8192000000 10676848864 11093442560 1709528896 17.265 96 13 26 1 1718004480 4856016 3619568
14:20:54 11243 8192000000 10690210416 11103596544 1740944816 17.526 97 15 30 1 1750643104 5713152 3985136
14:21:16 12952 8192000000 10713406304 11137474560 1789663936 17.929 99 23 44 2 1801948864 5220064 7064864
14:21:37 8173 8192000000 10698805712 11119083520 1762702000 17.707 98 28 56 1 1777098944 6205296 8191648
14:21:52 70876 8192000000 10704500400 11130339328 1726700288 17.408 95 39 79 0 1743891280 6410320 10780672
14:23:09 9413 8192000000 10694163344 11111727104 1765547936 17.730 98 23 44 0 1778026112 5811808 6666368
14:23:25 3758 8192000000 10740272848 11153616896 1809720960 18.094 100 46 92 0 1831667392 9147280 12799152
14:23:35 6044 8192000000 10737571872 11159883776 1826798480 18.233 100 35 68 1 1844154752 7565152 9791120
14:23:49 9551 8192000000 10729603616 11158941696 1810480656 18.100 99 20 40 0 1821770384 5751840 5537888
14:24:07 6855 8192000000 10747967392 11165687808 1816804016 18.152 99 24 48 0 1829937760 6237840 6895904
14:24:20 11519 8192000000 10750980368 11171377152 1818324176 18.164 99 30 58 0 1832431728 5531232 8576320
14:24:38 5714 8192000000 10747804448 11174711296 1836589680 18.313 100 24 48 0 1849889952 6610560 6689712
14:24:59 4716 8192000000 10753307472 11179208704 1841925696 18.356 100 30 60 0 1857233792 5444176 9863920
14:25:14 14102 8192000000 10758182432 11187568640 1842597376 18.362 100 9 18 0 1850372464 5385552 2389536
14:25:36 9194 8192000000 10762957136 11191390208 1848011056 18.406 100 12 24 1 1857061744 5798400 3252288
14:25:54 12362 8192000000 10771846032 11205230592 1856290352 18.473 100 12 24 1 1864511152 4924112 3296688
14:26:14 10554 8192000000 10769400736 11202605056 1862009984 18.520 100 18 36 0 1873110928 6206560 4894384
14:26:33 100096 8192000000 10807861152 11221274624 1871314672 18.595 100 30 59 1 1886323776 5786352 9222752
14:28:20 9349 8192000000 10823977616 11237797888 1888690160 18.735 100 53 104 1 1910807344 7654928 14462256
14:28:38 4344 8192000000 10835373008 11249053696 1898235984 18.812 100 63 126 2 1924699760 9006928 17456848
14:28:50 22997 8192000000 10835485024 11252989952 1900656128 18.832 100 57 114 2 1926308176 9600864 16051184
14:29:22 9675 8192000000 10840243088 11258908672 1908420752 18.894 100 58 116 1 1934337728 10005776 15911200
14:29:45 21807 8192000000 10850216016 11270381568 1915112432 18.948 100 60 119 0 1942318800 10625728 16580640
14:30:33 16123 8192000000 10862263584 11283304448 1925054320 19.027 100 54 106 0 1953295168 13051824 15189024
14:30:56 13596 8192000000 10870119600 11291041792 1930859456 19.074 100 45 90 1 1958135232 14647120 12628656
14:31:17 9572 8192000000 10878346864 11299110912 1937259408 19.125 100 49 98 2 1966246368 14745744 14241216
14:31:34 22973 8192000000 10877058912 11307880448 1939971056 19.147 100 51 100 2 1974947904 20358560 14618288
14:32:09 25257 8192000000 10887161152 11317665792 1947673680 19.208 100 48 96 1 1977578224 16189552 13714992
14:32:48 20708 8192000000 10893159600 11321303040 1952160272 19.244 100 42 82 1 1980121824 15988080 11973472
14:33:18 38384 8192000000 10899146096 11330940928 1959951728 19.306 100 45 90 0 1990913424 18001008 12960688
14:34:05 14656 8192000000 10909238256 11338756096 1964130608 19.339 100 43 84 3 1995415632 18572160 12712864
14:34:35 49711 8192000000 10913430688 11352403968 1971323600 19.396 100 35 70 1 2003208416 21252400 10632416
14:35:33 6836 8192000000 10923794384 11350634496 1977033968 19.441 100 47 94 2 2013091536 21680656 14376912
14:35:48 14786 8192000000 10943300688 11361411072 1983980576 19.496 100 65 128 1 2026592976 23898272 18714128
14:36:17 5328 8192000000 10948874752 11369775104 1990193232 19.545 100 71 142 1 2039635984 28194304 21248448
14:36:35 10198 8192000000 10947638608 11374174208 1988183360 19.529 100 52 104 0 2033523312 29949040 15390912
14:36:54 5437 8192000000 10919632784 11344650240 1968157120 19.371 99 57 113 1 2012533168 27230896 17145152
14:37:09 4068 8192000000 10939251520 11360608256 1971816512 19.400 99 83 165 3 2022849552 26848400 24184640
14:37:23 3213 8192000000 10944752016 11364200448 1986226272 19.514 100 69 138 0 2036344144 29112928 21004944
14:37:41 1795 8192000000 10968148768 11382018048 1999099856 19.616 100 88 177 1 2055981104 29894048 26987200
14:37:50 5320 8192000000 10973193008 11382935552 1997194592 19.601 100 75 148 2 2050411952 31492096 21725264
14:38:03 2902 8192000000 10972356816 11384295424 1996738912 19.597 100 77 154 3 2051830800 32079360 23012528
14:38:14 2444 8192000000 10978368192 11393048576 2003054576 19.647 100 82 162 1 2060131520 32775536 24301408
14:38:23 1812 8192000000 10967675952 11388317696 1997828880 19.606 100 84 167 1 2055395008 32671600 24894528
14:38:33 4365 8192000000 10972975088 11390885888 2002966400 19.646 100 71 142 1 2057731776 33436352 21329024
14:38:44 3014 8192000000 10973467088 11397386240 2003586976 19.651 100 74 148 1 2060061424 33932352 22542096
14:38:54 928 8192000000 10982182784 11394289664 2004926096 19.662 100 76 152 2 2061735136 33597648 23211392
14:39:05 767 8192000000 10965293600 11379781632 1986323184 19.515 99 80 158 0 2045902944 35026512 24553248
14:39:13 4706 8192000000 10975416480 11396390912 1999095360 19.616 100 63 126 1 2053981568 34825248 20060960
14:39:26 3935 8192000000 10995190464 11410677760 2011393808 19.712 100 68 136 0 2070224704 37988592 20842304
14:39:37 3353 8192000000 10982500896 11411271680 2010861536 19.708 100 69 138 0 2073137904 40202288 22074080
14:39:52 4618 8192000000 10985531584 11414077440 2002838720 19.645 100 63 127 1 2068463392 45824416 19800256
14:40:04 4516 8192000000 10966886688 11390566400 1968425600 19.373 98 65 128 2 2025125072 36271840 20427632
14:40:15 5019 8192000000 10980485392 11403808768 1994592880 19.580 99 69 137 1 2054814128 39095616 21125632
14:40:28 3125 8192000000 10980051056 11401760768 1993584160 19.572 99 67 134 0 2051616800 36098336 21934304
14:40:39 2723 8192000000 10955183808 11387355136 1970618944 19.390 98 69 138 1 2030119024 37723440 21776640
14:40:53 4005 8192000000 10983473552 11409387520 2008845808 19.692 100 64 128 1 2067578272 38420528 20311936
14:41:03 3278 8192000000 10995417328 11406647296 2005338736 19.665 100 79 154 2 2068727856 39398896 23990224
14:41:15 2956 8192000000 10990557744 11400482816 1991167376 19.553 99 83 166 0 2058456832 41378544 25910912
14:41:24 4542 8192000000 11000890768 11419332608 2011543312 19.714 100 84 167 0 2084955216 46784960 26626944
14:41:35 2332 8192000000 10978395632 11391492096 1986275456 19.514 99 83 164 2 2055260432 42710528 26274448
14:41:45 2323 8192000000 10995101056 11413561344 2008603264 19.691 100 82 161 2 2075032112 40875744 25553104
14:41:54 3193 8192000000 10992042816 11417202688 2011781920 19.716 100 73 146 0 2077469536 42242080 23445536
14:42:05 1778 8192000000 11001858672 11417534464 2016107680 19.750 100 86 170 1 2084279168 40821520 27349968
14:42:14 4609 8192000000 10972556304 11391471616 1987314080 19.523 99 79 157 1 2052486032 40261680 24910272
14:42:27 3888 8192000000 10984526720 11401596928 2000859584 19.630 100 84 168 1 2066502880 39410496 26232800
14:42:39 5020 8192000000 10983928480 11411091456 2005752896 19.668 100 74 145 0 2068404816 39648304 23003616
14:42:53 1569 8192000000 10978061808 11399036928 1995480160 19.587 100 85 165 0 2060663264 39022048 26161056
14:43:05 2589 8192000000 10987326224 11401519104 1989405152 19.539 99 89 178 0 2058054752 40676848 27972752
14:43:14 4143 8192000000 10984230784 11405443072 1996157152 19.592 100 75 148 0 2061232096 42487680 22587264
14:43:27 1915 8192000000 10993940224 11408404480 2000534592 19.627 100 86 172 1 2071460544 45224832 25701120
14:43:36 1719 8192000000 11000318976 11415064576 2004270912 19.656 100 87 173 0 2078971440 47779424 26921104
14:43:46 3886 8192000000 10998993600 11419054080 2004177392 19.656 100 82 164 0 2080653584 50369072 26107120
14:44:05 4039 8192000000 10983052944 11397140480 1967278416 19.364 98 84 167 2 2043322864 49239808 26804640
14:44:18 1338 8192000000 10972278368 11391590400 1970009072 19.386 99 80 160 2 2045971008 49917968 26043968
14:44:29 4795 8192000000 10958808192 11381317632 1956877248 19.281 99 69 137 1 2026549264 46716000 22956016
14:44:41 7169 8192000000 10946668896 11376816128 1967542144 19.366 100 56 112 5 2032319856 46141488 18636224
14:44:57 7642 8192000000 10944495504 11374006272 1936636560 19.120 98 59 116 1 2002594320 46816848 19140912
14:45:15 15419 8192000000 10939506976 11376775168 1953537552 19.255 99 43 86 2 2014438672 46114528 14786592
14:45:39 8066 8192000000 10943989680 11375579136 1951153392 19.236 99 44 86 1 2009463184 43892160 14417632
14:46:04 9059 8192000000 10944681232 11370807296 1953287824 19.253 99 54 106 0 2014421456 44193168 16940464
14:46:22 5812 8192000000 10948148672 11376492544 1953031392 19.251 99 59 118 3 2016996144 44573952 19390800
14:46:41 6180 8192000000 10955307840 11392958464 1976124752 19.434 100 53 106 1 2042257808 48393152 17739904
14:46:58 13545 8192000000 10957043568 11392012288 1978030416 19.449 100 44 88 1 2039118880 46188800 14899664
14:47:19 12549 8192000000 10969846672 11408818176 1985059952 19.505 100 38 76 2 2048426384 49835856 13530576
14:47:42 9281 8192000000 10961367760 11407663104 1980090672 19.465 100 31 62 0 2038179872 47200208 10888992
14:48:00 9231 8192000000 10976003616 11416371200 1989721168 19.542 100 43 86 0 2058386096 54216368 14448560
14:48:17 27567 8192000000 10932952576 11379351552 1925285184 19.029 97 34 68 0 1984340032 47787392 11267456
14:48:51 21658 8192000000 10903598272 11347406848 1904493344 18.862 98 33 66 2 1968999872 52845376 11661152
14:49:19 15900 8192000000 10904502704 11355193344 1924337568 19.022 99 34 68 1 1988108800 51564848 12206384
14:49:49 10717 8192000000 10907531216 11349237760 1924323168 19.021 99 30 60 3 1974958912 40106160 10529584
14:50:11 33041 8192000000 10885290320 11353202688 1915795696 18.953 99 27 54 1 1970608528 45935680 8877152
14:50:53 25306 8192000000 10862694384 11315134464 1884213200 18.699 97 20 40 0 1922033632 31926048 5894384
14:51:53 28445 8192000000 10863096368 11311656960 1870487648 18.588 98 20 40 1 1918140832 40479888 7173296
14:52:29 21967 8192000000 10881081952 11329695744 1895305648 18.789 99 21 40 0 1944860128 42587872 6966608
14:52:57 25103 8192000000 10875284256 11339722752 1901240816 18.836 99 17 34 1 1949784000 42623664 5919520
14:53:50 11653 8192000000 10894534464 11337175040 1935416848 19.110 100 40 78 0 1959427872 12846864 11164160
14:54:09 59948 8192000000 10898494688 11339292672 1949562064 19.223 100 54 108 1 1975860112 9365136 16932912
14:55:38 11045 8192000000 10889078224 11334758400 1936552112 19.119 99 37 74 1 1957158064 9965152 10640800
14:55:58 65114 8192000000 10884332144 11325362176 1906856512 18.881 98 42 85 2 1929416656 10192112 12368032
14:57:10 50943 8192000000 10866055856 11335630848 1925897968 19.034 99 41 81 0 1949723040 12280432 11544640
14:58:10 23656 8192000000 10852890224 11327881216 1930444064 19.070 100 7 14 0 1944864256 12933568 1486624
14:58:43 29630 8192000000 10857532096 11318517760 1919213200 18.981 99 22 45 0 1933550736 8432272 5905264
14:59:22 24952 8192000000 10854410144 11323932672 1937097312 19.124 100 9 18 3 1947060144 7728848 2233984
15:01:01 11891 8192000000 10880568480 11340402688 1948739136 19.216 100 20 42 0 1968232272 14158160 5334976
15:01:26 48004 8192000000 10866617488 11328749568 1926698272 19.040 98 19 38 1 1946163920 13560608 5905040
15:02:21 24994 8192000000 10880102384 11348807680 1952923088 19.250 100 9 18 1 1968829648 13528432 2378128
15:02:52 76858 8192000000 10883612736 11359825920 1961773472 19.320 100 20 40 1 1983840048 15850416 6216160
15:04:27 72286 8192000000 10880310368 11362918400 1948562512 19.215 99 35 70 2 1970358016 11453280 10342224
15:05:47 65758 8192000000 10907746880 11374882816 1981581328 19.477 100 32 63 1 2002496528 12213968 8701232
15:07:14 16823 8192000000 10899048144 11370041344 1973927024 19.417 100 16 32 1 1992285952 12998944 5359984
15:07:37 35021 8192000000 10912796192 11381039104 1981599600 19.477 100 16 32 0 1999846480 13430208 4816672
15:08:35 80268 8192000000 10896204080 11377442816 1962809264 19.328 99 7 14 1 1980871600 15875888 2186448
15:10:05 59575 8192000000 10901342288 11374321664 1958072880 19.291 99 17 34 2 1976106368 13354144 4679344
15:11:12 80516 8192000000 10919137712 11364352000 1921606848 19.000 97 25 50 1 1942298208 12802496 7888864
15:13:37 112008 8192000000 10867170304 11343597568 1923399520 19.014 98 15 30 0 1943652336 15160080 5092736
15:15:35 88256 8192000000 10916738720 11378905088 1973417760 19.413 100 16 32 0 1992224256 14390448 4416048
15:17:09 76871 8192000000 10923908512 11395256320 1985409952 19.508 100 42 83 0 2014671056 17462448 11798656
15:18:43 54598 8192000000 10909107616 11399438336 1960770928 19.312 99 10 20 0 1980687728 17144272 2772528
15:19:46 88948 8192000000 10929022176 11412115456 1986219968 19.514 100 7 14 1 2007050768 18576000 2254800
15:21:21 90178 8192000000 10906495408 11382276096 1953975232 19.258 98 10 19 1 1971762336 14897056 2890048
15:22:58 112685 8192000000 10937065632 11395608576 1975382240 19.428 99 37 74 5 2000906416 14291232 11232944
15:25:35 31154 8192000000 10919348768 11391836160 1992745840 19.565 100 21 41 3 2009449040 10857040 5846160
15:26:12 33478 8192000000 10917297600 11384098816 1970543440 19.390 99 26 52 0 1986907568 9257616 7106512
15:26:55 77157 8192000000 10904637968 11394760704 1976144336 19.434 99 13 26 0 1987670976 8405776 3120864
15:28:18 51472 8192000000 10919691872 11407765504 1999983152 19.623 100 7 14 0 2014101984 12213536 1905296
15:29:16 18755 8192000000 10899920112 11391356928 1984322304 19.499 100 8 16 0 1998463744 11842832 2298608
15:29:41 49002 8192000000 10900540368 11382546432 1972168816 19.403 99 13 26 1 1983009824 7222848 3618160
15:30:44 53645 8192000000 10877119328 11364515840 1932801280 19.089 97 11 22 1 1943977488 8059168 3117040
15:32:07 35580 8192000000 10912787728 11382063104 1973298336 19.412 99 16 32 0 1985376912 7440656 4637920
15:33:19 66872 8192000000 10893095600 11359903744 1922470944 19.007 97 18 36 0 1939924640 12588448 4865248
15:34:36 54036 8192000000 10898639600 11370893312 1924731008 19.025 97 19 38 1 1941269392 11192320 5346064
15:35:48 58381 8192000000 10921918896 11378118656 1948077856 19.211 98 33 66 2 1972658576 15123888 9456832
15:36:54 33028 8192000000 10931230896 11394539520 1986357200 19.515 100 47 94 2 2023206544 23017376 13831968
15:37:55 69059 8192000000 10902680064 11382415360 1916818176 18.961 97 6 12 0 1939580784 20981344 1781264
15:39:11 116954 8192000000 10864335456 11346100224 1815837520 18.144 92 15 30 0 1830418320 10733024 3847776
15:41:14 29562 8192000000 10897911008 11344506880 1916355952 18.958 98 41 80 0 1935426752 7977504 11093296
15:41:54 55588 8192000000 10869772592 11345260544 1898362592 18.813 97 37 72 2 1922069904 13645792 10061520
15:43:05 99738 8192000000 10870770992 11328962560 1840559984 18.345 94 20 40 0 1861877664 15550960 5766720
15:44:51 36539 8192000000 10891585648 11346968576 1932564576 19.087 99 36 72 0 1954534512 11129856 10840080
15:45:41 63208 8192000000 10865195040 11343564800 1911900256 18.922 98 22 44 1 1930016816 12232336 5884224
15:46:54 89074 8192000000 10879289216 11347558400 1946711664 19.200 100 31 62 0 1963851264 7912464 9227136
15:48:31 90838 8192000000 10898001152 11358035968 1919982992 18.987 98 31 61 0 1937574208 9787552 7803664
15:50:28 2056 8192000000 10878868848 11334529024 1939260592 19.141 99 42 82 3 1962795440 12060192 11474656
15:50:39 84162 8192000000 10887063360 11367211008 1948854672 19.217 99 23 46 1 1971841760 16523328 6463760
15:52:12 47064 8192000000 10885088416 11369205760 1922861344 19.010 98 7 14 0 1943447488 18411056 2175088
15:53:09 35654 8192000000 10872476768 11349708800 1920418528 18.990 98 16 32 1 1944658496 19899024 4340944
15:53:56 35462 8192000000 10855489680 11325829120 1872991968 18.608 96 19 38 1 1895053360 16480512 5580880
15:54:38 51069 8192000000 10855391840 11330564096 1927376704 19.046 100 19 37 2 1950427488 16838784 6212000
15:55:35 53674 8192000000 10845837824 11333423104 1891178976 18.755 98 10 21 0 1906753552 12944336 2630240
15:56:45 30548 8192000000 10879050000 11332640768 1900976128 18.834 98 26 53 0 1917925632 9684624 7264880
15:57:23 69105 8192000000 10871017904 11339927552 1925057392 19.027 99 15 30 1 1937420784 8491376 3872016
15:58:44 32815 8192000000 10889282336 11353628672 1944953648 19.186 99 19 38 2 1957280368 7639024 4687696
15:59:25 49288 8192000000 10902808336 11377565696 1977086880 19.442 100 20 40 0 1992060496 9042176 5931440
16:00:30 72082 8192000000 10887822224 11374911488 1958428480 19.294 99 16 32 0 1972641424 10060864 4152080
16:02:10 46262 8192000000 10918831280 11382886400 1967887968 19.369 99 16 32 0 1979831056 7211744 4731344
16:03:03 42750 8192000000 10918610352 11365863424 1946662384 19.200 98 30 59 1 1964066880 8031776 9372720
16:03:53 21366 8192000000 10901355168 11363188736 1966440656 19.357 99 37 76 1 1985421232 8422464 10558112
16:04:21 40945 8192000000 10914917392 11375439872 1959870160 19.305 99 37 75 1 1980759776 10785360 10104256
16:05:09 24964 8192000000 10890990720 11368329216 1940581680 19.151 98 27 55 1 1960115760 11864704 7669376
16:05:42 63321 8192000000 10895650080 11369013248 1958817280 19.297 99 16 32 2 1978191744 14862400 4512064
16:06:57 81320 8192000000 10900139440 11363876864 1907044960 18.883 96 18 36 0 1922505888 10584512 4876416
16:08:28 111316 8192000000 10907702928 11400187904 1934439104 19.102 98 18 37 2 1961670352 22126960 5104288
16:10:36 38949 8192000000 10905323104 11362930688 1929544448 19.063 98 18 36 0 1945965824 11411120 5010256
16:11:21 111174 8192000000 10909151952 11372920832 1930187664 19.068 98 26 52 0 1950246624 12980752 7078208
16:13:36 63426 8192000000 10919187504 11387121664 1981821600 19.479 100 23 46 0 1998254400 10053360 6379440
16:14:45 54029 8192000000 10910157744 11390390272 1996813040 19.598 100 23 46 0 2010624816 7547840 6263936
16:15:47 10669 8192000000 10917885568 11391221760 1998102080 19.608 100 29 58 1 2014160000 7466096 8591824
16:16:07 79056 8192000000 10902905472 11385679872 1939458752 19.142 97 18 36 0 1956487520 11988960 5039808
16:17:33 58567 8192000000 10873311360 11340832768 1932258160 19.085 97 12 24 0 1943787872 8171248 3358464
16:18:38 63719 8192000000 10919496528 11404161024 1992943280 19.567 100 22 44 0 2009093920 9871456 6279184
16:19:48 73736 8192000000 10907949024 11396280320 1993903344 19.575 100 17 34 0 2015114848 15715360 5496144
16:21:42 74106 8192000000 10900189808 11388571648 1946190144 19.196 98 10 20 2 1959114000 10335008 2588848
16:23:02 25596 8192000000 10916036304 11373006848 1958412704 19.293 99 25 50 1 1978551552 13487504 6651344
16:23:40 45543 8192000000 10909680992 11377438720 1944785584 19.185 98 20 40 2 1962452080 11890048 5776448
16:24:40 64440 8192000000 10905830192 11389784064 1957786464 19.288 99 21 42 1 1976720704 13059424 5874816
16:25:50 31497 8192000000 10896702128 11363356672 1921696448 19.000 97 14 29 0 1932885472 7240672 3948352
16:27:18 10439 8192000000 9134081792 9360781312 292182416 3.443 15 3 6 0 298676016 6062736 430864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-02-2021 16:28:31 to 21-02-2021 16:29:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          230027
MON$OLDEST_ACTIVE               230028
MON$OLDEST_SNAPSHOT             230028
MON$NEXT_TRANSACTION            230028
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                       2012288
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
--- end of diff output ---

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

21.02.21 16:29:06. 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-02-21 16:29:08 No severe PSQL-related problems occured
21.02.21 16:29:10. End of report.