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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17307596 kB
MemAvailable 31460264 kB
Buffers 0 kB
Cached 14395700 kB
SwapCached 40 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-06-11 22:27:39
DTS_END                         2021-06-11 22:27:39.2470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57572
TRN_ID                          242743
ATT_ID                          661
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: 9128.33 28137 1095400
customer order: creation 171.83 347 20619
customer order: refuse 14.75 369 1770
order to supplier: creation 46.53 1325 5583
order to supplier: removal 3.33 112004 400
invoice (draft): creation 45.64 3531 5477
invoice (draft): removal 52.27 819 6272
invoice accept: apply 42.27 19053 5072
invoice accept: cancel 46.78 786 5614
customer reserve: creation 3802.08 194 456249
customer reserve: removal 4613.96 64 553675
realization accept: apply 83.87 191 10064
realization accept: cancel 75.47 111 9056
payment from customer: creation 59.73 116 7167
payment from customer: removal 5.79 82 695
payment to supplier: creation 48.39 137 5807
payment to supplier: removal 3.73 99 447
service: total inventory turnovers 4.45 1393 534
service: total monetary turnovers 6.70 33 804
service: aggregate perf. data 0.76 20657 91
service: refresh index statistics 0.03 401438 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-06-2021 22:29:21 to 11-06-2021 22:29:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3815
TEST_TIME 2 3564
TEST_TIME 3 3956
TEST_TIME 4 5670
TEST_TIME 5 5368
TEST_TIME 6 5329
TEST_TIME 7 5393
TEST_TIME 8 5509
TEST_TIME 9 5820
TEST_TIME 10 6247
TEST_TIME 11 6379
TEST_TIME 12 6644
TEST_TIME 13 6768
TEST_TIME 14 6655
TEST_TIME 15 7195
TEST_TIME 16 7151
TEST_TIME 17 7307
TEST_TIME 18 7240
TEST_TIME 19 7760
TEST_TIME 20 7865
TEST_TIME 21 8065
TEST_TIME 22 8363
TEST_TIME 23 8683
TEST_TIME 24 8690
TEST_TIME 25 9377
TEST_TIME 26 9517
TEST_TIME 27 10272
TEST_TIME 28 11197
TEST_TIME 29 10998
TEST_TIME 30 10896
TEST_TIME 31 10658
TEST_TIME 32 10593
TEST_TIME 33 10501
TEST_TIME 34 10315
TEST_TIME 35 10266
TEST_TIME 36 10015
TEST_TIME 37 10155
TEST_TIME 38 10179
TEST_TIME 39 10051
TEST_TIME 40 10029
TEST_TIME 41 9825
TEST_TIME 42 9770
TEST_TIME 43 9846
TEST_TIME 44 9772
TEST_TIME 45 9749
TEST_TIME 46 9700
TEST_TIME 47 9572
TEST_TIME 48 9411
TEST_TIME 49 9530
TEST_TIME 50 9496
TEST_TIME 51 9446
TEST_TIME 52 9422
TEST_TIME 53 9561
TEST_TIME 54 9499
TEST_TIME 55 9474
TEST_TIME 56 9534
TEST_TIME 57 9568
TEST_TIME 58 9522
TEST_TIME 59 9737
TEST_TIME 60 9679
TEST_TIME 61 9738
TEST_TIME 62 9810
TEST_TIME 63 9668
TEST_TIME 64 9572
TEST_TIME 65 9502
TEST_TIME 66 9486
TEST_TIME 67 9460
TEST_TIME 68 9411
TEST_TIME 69 9328
TEST_TIME 70 9335
TEST_TIME 71 9316
TEST_TIME 72 9467
TEST_TIME 73 9476
TEST_TIME 74 9449
TEST_TIME 75 9437
TEST_TIME 76 9503
TEST_TIME 77 9487
TEST_TIME 78 9486
TEST_TIME 79 9472
TEST_TIME 80 9598
TEST_TIME 81 9607
TEST_TIME 82 9541
TEST_TIME 83 9476
TEST_TIME 84 9458
TEST_TIME 85 9392
TEST_TIME 86 9408
TEST_TIME 87 9360
TEST_TIME 88 9338
TEST_TIME 89 9285
TEST_TIME 90 9312
TEST_TIME 91 9229
TEST_TIME 92 9206
TEST_TIME 93 9256
TEST_TIME 94 9269
TEST_TIME 95 9264
TEST_TIME 96 9267
TEST_TIME 97 9359
TEST_TIME 98 9342
TEST_TIME 99 9333
TEST_TIME 100 9409
TEST_TIME 101 9448
TEST_TIME 102 9402
TEST_TIME 103 9477
TEST_TIME 104 9446
TEST_TIME 105 9452
TEST_TIME 106 9466
TEST_TIME 107 9434
TEST_TIME 108 9368
TEST_TIME 109 9386
TEST_TIME 110 9358
TEST_TIME 111 9345
TEST_TIME 112 9320
TEST_TIME 113 9294
TEST_TIME 114 9277
TEST_TIME 115 9260
TEST_TIME 116 9247
TEST_TIME 117 9212
TEST_TIME 118 9205
TEST_TIME 119 9152
TEST_TIME 120 9135

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-06-2021 22:29:24 to 11-06-2021 22:29:28.

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 1519362 1519362 0 0.00 0 20119 6 0 0
doc_list_biud 1519362 1519362 0 0.00 0 53906 29 0 0
sp_add_invoice_to_stock 5173 5072 101 1.95 35 180541 19053 0 101
sp_cancel_adding_invoice 5614 5614 0 0.00 4 61549 786 0 0
sp_cancel_client_order 1770 1770 0 0.00 4 11427 370 0 0
sp_cancel_customer_reserve 553675 553675 0 0.00 1 53909 64 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 3 3442 82 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 2 8098 99 0 0
sp_cancel_supplier_invoice 6281 6272 9 0.14 2 27897 820 0 9
sp_cancel_supplier_order 400 400 0 0.00 6 1171374 112004 0 0
sp_cancel_write_off 9056 9056 0 0.00 1 6080 111 0 0
sp_client_order 20619 20619 0 0.00 4 21553 347 0 0
sp_customer_reserve 456249 456249 0 0.00 0 80138 194 0 0
sp_fill_shopping_cart 31673 31673 0 0.00 1 18283 38 0 0
sp_fill_shopping_cart_clo_res 456246 456246 0 0.00 0 15249 13 0 0
sp_get_clo_for_invoice 5064 5064 0 0.00 0 18759 302 0 0
sp_kill_cost_storno 15812 15812 0 0.00 0 7899 57 0 0
sp_kill_qstorno_ret_qs2qd 1123078 1123078 0 0.00 0 53897 34 0 0
sp_kill_qty_storno 591915 591915 0 0.00 0 53905 74 0 0
sp_lock_selected_doc 21036 21036 0 0.00 0 6486 5 0 0
sp_make_cost_storno 28102 28102 0 0.00 0 20033 54 0 0
sp_multiply_rows_for_pdistr 28102 28102 0 0.00 0 7027 32 0 0
sp_multiply_rows_for_qdistr 20619 20619 0 0.00 0 21544 144 0 0
sp_pay_from_customer 7167 7167 0 0.00 4 14573 117 0 0
sp_pay_to_supplier 5807 5807 0 0.00 5 13222 138 0 0
sp_payment_common 12974 12974 0 0.00 1 14545 33 0 0
sp_qd_handle_on_cancel_clo 1770 1770 0 0.00 0 11378 322 0 0
sp_qd_handle_on_invoice_upd_sts 10678 10678 0 0.00 0 27911 319 0 0
sp_qd_handle_on_reserve_upd_sts 10064 10064 0 0.00 0 15814 65 0 0
sp_reserve_write_off 10064 10064 0 0.00 6 15830 192 0 0
sp_supplier_invoice 5477 5477 0 0.00 7 75281 3531 0 0
sp_supplier_order 5583 5583 0 0.00 6 29264 1325 0 0
srv_aggregate_perf_data 91 91 0 0.00 2981 162174 20657 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1187 128233 29487 0 0
srv_find_qd_qs_mism 1048585 1048585 0 0.00 0 11633 6 0 0
srv_make_invnt_saldo 534 534 0 0.00 59 156083 1393 0 0
srv_make_money_saldo 804 804 0 0.00 0 5225 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 147135 497189 401438 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5072 5072 0 0.00 0 20446 193 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 0 7805 103 0 0
t$perf-norm:sp_cancel_client_order 1770 1770 0 0.00 0 2225 12 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 5291 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 1308 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 3707 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 430 430 0 0.00 0 266 7 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 23541 1519 0 0
t$perf-norm:sp_cancel_write_off 1053 1053 0 0.00 0 1776 9 0 0
t$perf-norm:sp_client_order 20619 20619 0 0.00 0 9483 20 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 6068 25 0 0
t$perf-norm:sp_pay_from_customer 7167 7167 0 0.00 0 12029 12 0 0
t$perf-norm:sp_pay_to_supplier 5807 5807 0 0.00 0 8062 13 0 0
t$perf-norm:sp_reserve_write_off 10064 10064 0 0.00 0 10352 13 0 0
t$perf-norm:sp_supplier_invoice 5477 5477 0 0.00 0 6478 21 0 0
t$perf-norm:sp_supplier_order 5583 5583 0 0.00 0 4315 19 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 472 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 248 5 0 0
t$perf-norm:srv_make_invnt_saldo 534 534 0 0.00 0 903 26 0 0
t$perf-norm:srv_make_money_saldo 804 804 0 0.00 0 984 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10328 10126 202 1.95 0 7656 19 0 202
v_all_customers 37660 37660 0 0.00 0 149 1 0 0
v_all_suppliers 30212 30212 0 0.00 0 134 1 0 0
v_all_wares 41238 41238 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 2687 12 0 0
v_cancel_client_order 3540 3540 0 0.00 0 11069 15 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 3432 10 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 1784 6 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 3155 11 0 0
v_cancel_supplier_invoice 878 860 18 2.05 0 3572 18 0 18
v_cancel_supplier_order 800 800 0 0.00 0 2986 12 0 0
v_cancel_write_off 2106 2106 0 0.00 0 1696 13 0 0
v_max_id_clo_ord 5583 5583 0 0.00 0 18276 5 0 0
v_max_id_clo_res 997 997 0 0.00 0 3177 16 0 0
v_max_id_ord_sup 5471 5471 0 0.00 0 5984 4 0 0
v_max_non_paid_invoice 1755 1755 0 0.00 0 2239 5 0 0
v_max_non_paid_realizn 3780 3780 0 0.00 0 2011 4 0 0
v_min_id_clo_ord 5583 5583 0 0.00 0 2179 6 0 0
v_min_id_clo_res 997 997 0 0.00 0 1415 5 0 0
v_min_id_ord_sup 5471 5471 0 0.00 0 4827 9 0 0
v_min_non_paid_invoice 5807 5807 0 0.00 0 13109 21 0 0
v_min_non_paid_realizn 7167 7167 0 0.00 0 7827 17 0 0
v_our_firm 10352 10352 0 0.00 0 98 1 0 0
v_reserve_write_off 20128 20128 0 0.00 0 11416 10 0 0
x_lock_depdocs_on_canc_invoice 11456 11456 0 0.00 0 15755 128 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 15634 451 0 0
x_make_qstorno_1000_1200 5583 5583 0 0.00 2 29256 1241 0 0
x_make_qstorno_1200_2000 5477 5477 0 0.00 4 75247 3399 0 0
x_make_qstorno_2100_3300 456249 456249 0 0.00 0 80138 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-06-2021 22:29:29 to 11-06-2021 22:29:33.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:42 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:48 13277 8192000000 10242171840 10546630656 1062719728 11.483 84 54 110 2 1084094128 2861792 18512608
19:58:10 35916 8192000000 10356380080 10675417088 1396592768 14.565 100 82 163 0 1427460848 4784848 26083232
19:58:56 31231 8192000000 10407584992 10736095232 1455246144 15.084 100 86 172 1 1489880720 6697008 27937568
19:59:37 32220 8192000000 10452623520 10782228480 1492329104 15.409 100 89 178 0 1528667296 7710672 28627520
20:00:20 27292 8192000000 10455185264 10787729408 1511247072 15.574 100 86 172 0 1547498464 8901280 27350112
20:01:04 20239 8192000000 10459733456 10802847744 1518370736 15.636 100 77 154 0 1551582864 8877376 24334752
20:01:36 15769 8192000000 10492923776 10839523328 1541319312 15.835 100 77 153 0 1574522464 9160480 24042672
20:02:01 13742 8192000000 10509245696 10859286528 1572482000 16.104 100 78 157 0 1606109376 9717424 23909952
20:02:24 13692 8192000000 10535292816 10887086080 1591098384 16.263 100 84 168 1 1626835632 10357904 25379344
20:02:47 18308 8192000000 10561359760 10920710144 1612467088 16.446 100 78 156 3 1645957456 10315856 23174512
20:03:14 10496 8192000000 10595611552 10953953280 1647367024 16.742 100 79 159 1 1681301840 11061152 22873664
20:03:32 9796 8192000000 10609668816 10971197440 1670331424 16.936 100 88 175 1 1709612960 12353216 26928320
20:03:49 9306 8192000000 10614467104 10977234944 1673514384 16.963 100 80 157 2 1709382224 12840784 23027056
20:04:07 10488 8192000000 10636183568 11002134528 1697083584 17.161 100 86 172 1 1735144784 13492592 24568608
20:04:26 9833 8192000000 10648762064 11018600448 1705260464 17.229 100 79 158 1 1741417392 13867968 22288960
20:04:44 7497 8192000000 10661706864 11033501696 1721935488 17.368 100 84 168 1 1760074384 14071696 24067200
20:04:59 5430 8192000000 10665085520 11040796672 1730057440 17.436 100 85 170 1 1769014656 14131712 24825504
20:05:12 7805 8192000000 10684011536 11060506624 1741317952 17.530 100 73 146 1 1774438544 12348272 20772320
20:05:26 5277 8192000000 10692180960 11068620800 1753120704 17.627 100 83 165 1 1789236368 12481216 23634448
20:05:39 4009 8192000000 10697994064 11077300224 1759725824 17.682 100 78 156 1 1795176240 13045648 22404768
20:05:52 3424 8192000000 10711579344 11091865600 1771672048 17.781 100 76 152 2 1805248048 12086160 21489840
20:06:02 5127 8192000000 10721978016 11101073408 1781693584 17.863 100 84 166 1 1817274912 12337456 23243872
20:06:13 3176 8192000000 10732478688 11111673856 1791669264 17.945 100 89 177 3 1828811008 13375296 23766448
20:06:23 5052 8192000000 10739346608 11120218112 1796159776 17.982 100 90 181 0 1835738560 14215536 25363248
20:06:35 2464 8192000000 10737929760 11120955392 1800182240 18.015 100 91 182 0 1838349808 14003824 24163744
20:06:44 3027 8192000000 10744448304 11126972416 1805114432 18.056 100 89 178 0 1843988464 14770096 24103936
20:06:54 4528 8192000000 10753416096 11133767680 1809690688 18.093 100 90 180 2 1849319648 15320736 24308224
20:07:05 3873 8192000000 10756056592 11140521984 1807657824 18.077 100 83 164 0 1845252656 15180112 22414720
20:07:15 3047 8192000000 10773917808 11155607552 1827112048 18.236 100 91 182 3 1868550304 15208032 26230224
20:07:24 1792 8192000000 10770910000 11156729856 1831298880 18.270 100 83 166 1 1869165136 14721664 23144592
20:07:32 1789 8192000000 10778648496 11163684864 1841705264 18.355 100 94 186 0 1882553968 14413024 26435680
20:07:41 2040 8192000000 10785633520 11174920192 1847388080 18.401 100 95 190 1 1886985248 12441952 27155216
20:07:50 2639 8192000000 10791106928 11178631168 1848041552 18.406 100 89 178 1 1885647408 12639376 24966480
20:07:59 2147 8192000000 10796057248 11183190016 1851667232 18.436 100 88 176 0 1889423232 12935808 24820192
20:08:07 1718 8192000000 10800580608 11186855936 1857773568 18.485 100 88 177 1 1894814304 11694768 25345968
20:08:15 1574 8192000000 10803847728 11190362112 1860841696 18.510 100 95 185 2 1900250784 12572192 26836896
20:08:23 2056 8192000000 10810312864 11199139840 1864550864 18.540 100 94 188 0 1902478064 11405456 26521744
20:08:31 1723 8192000000 10818525888 11206942720 1873945904 18.616 100 95 191 1 1914386064 13350624 27089536
20:08:40 1613 8192000000 10817426336 11204186112 1869799424 18.583 100 93 188 1 1910290816 13902832 26588560
20:08:48 10448 8192000000 10800803984 11200827392 1869921776 18.584 100 79 156 2 1903954416 12547584 21485056
20:09:05 1554 8192000000 10809996736 11206811648 1872035568 18.601 100 83 164 3 1908515296 12800944 23678784
20:09:14 17230 8192000000 10788432336 11201564672 1867012496 18.560 100 50 99 0 1893803376 12748064 14042816
20:09:41 5582 8192000000 10795934208 11205226496 1872911456 18.608 100 38 76 4 1890390576 6105376 11373744
20:09:53 7143 8192000000 10787889232 11212685312 1877453568 18.645 100 36 72 0 1896700912 9075664 10171680
20:10:10 9649 8192000000 10783990192 11215187968 1878737136 18.655 100 27 54 2 1892984368 7034640 7212592
20:10:28 7799 8192000000 10791811312 11219173376 1880962016 18.673 100 35 70 3 1898721680 8155296 9604368
20:10:41 9693 8192000000 10789789072 11215917056 1881324400 18.676 100 16 32 1 1891497584 5802736 4370448
20:10:59 8193 8192000000 10791838704 11222257664 1882660704 18.687 100 14 28 0 1892258496 5880336 3717456
20:11:16 11432 8192000000 10791700528 11222822912 1884916000 18.705 100 11 22 0 1893238800 5296144 3026656
20:11:33 12580 8192000000 10789378848 11222712320 1885874592 18.713 100 15 30 1 1896112864 5839504 4398768
20:11:54 12605 8192000000 10792942544 11225726976 1885688544 18.711 100 14 29 0 1899475888 10175136 3612208
20:12:14 8456 8192000000 10792473344 11227852800 1889076704 18.738 100 21 42 0 1901271904 6378256 5816944
20:12:28 10660 8192000000 10823379200 11247194112 1901000464 18.834 100 35 69 1 1923144192 11756496 10387232
20:12:46 62728 8192000000 10864284032 11266555904 1910816720 18.913 100 59 119 1 1936895968 6050800 20028448
20:13:55 10782 8192000000 10819746896 11258454016 1909418480 18.902 100 27 53 2 1924243936 7296912 7528544
20:14:14 5204 8192000000 10823682640 11260833792 1912092096 18.923 100 33 66 2 1928560416 6337232 10131088
20:14:27 4257 8192000000 10836550368 11265343488 1914775440 18.945 100 34 68 0 1931458208 7417072 9265696
20:14:39 3762 8192000000 10831903152 11265646592 1917612672 18.968 100 30 60 1 1932438736 6716928 8109136
20:14:51 8199 8192000000 10839499584 11271159808 1917693488 18.968 100 28 56 1 1931660480 5971472 7995520
20:15:05 4908 8192000000 10835128272 11267031040 1918846096 18.978 100 33 67 1 1934378160 6619328 8912736
20:15:16 9792 8192000000 10822253152 11261779968 1900004848 18.826 99 30 60 1 1915139856 5846672 9288336
20:15:32 5314 8192000000 10834210192 11263852544 1915485088 18.951 100 26 52 0 1930207520 6320752 8401680
20:15:44 7283 8192000000 10835207472 11266306048 1909498496 18.903 100 26 52 0 1923209024 6383824 7326704
20:16:01 6424 8192000000 10830291488 11268960256 1914335856 18.941 100 15 30 2 1923631360 4987728 4307776
20:16:16 5933 8192000000 10819392880 11259473920 1913716320 18.936 100 30 59 3 1928057088 5796352 8544416
20:16:28 44678 8192000000 10819743184 11248783360 1859092432 18.496 97 39 79 1 1880042336 9513200 11436704
20:17:22 24427 8192000000 10805383248 11234816000 1828583072 18.248 96 19 38 0 1840093696 5603024 5907600
20:17:53 9523 8192000000 10803387152 11242995712 1867358704 18.563 98 18 35 0 1877656832 5229360 5068768
20:18:10 5885 8192000000 10821871936 11245408256 1894935664 18.786 100 44 88 1 1915888944 8001168 12952112
20:18:22 4798 8192000000 10801206064 11228528640 1857712768 18.485 98 38 76 1 1877063456 8199680 11151008
20:18:33 4103 8192000000 10797975664 11220611072 1861236624 18.513 99 33 66 0 1881947824 11629744 9081456
20:18:44 5135 8192000000 10756625664 11173588992 1773202144 17.793 95 38 75 2 1791612224 7655552 10754528
20:18:57 7392 8192000000 10746119056 11166806016 1802963184 18.038 98 27 54 0 1817114528 5346960 8804384
20:19:11 6262 8192000000 10721339712 11132968960 1773161968 17.793 97 36 71 2 1789401168 5774272 10464928
20:19:24 8698 8192000000 10732228432 11159351296 1811609056 18.109 99 18 36 0 1824007616 6133344 6265216
20:19:39 7365 8192000000 10714707888 11132522496 1735217520 17.479 95 24 48 0 1747647824 4542496 7887808
20:19:55 11272 8192000000 10719119360 11139010560 1745169712 17.562 96 7 13 1 1751941504 4738576 2033216
20:20:15 5008 8192000000 10697358064 11112112128 1764421008 17.721 99 18 35 3 1775279312 5759264 5099040
20:20:27 10272 8192000000 10699912640 11108327424 1712284736 17.288 95 24 47 1 1725108336 5331408 7492192
20:20:47 6516 8192000000 10696909024 11116331008 1761903264 17.700 98 23 46 1 1773819632 5343248 6573120
20:21:02 11290 8192000000 10703277392 11112923136 1739090256 17.511 97 33 64 2 1754149872 5339312 9720304
20:21:52 32971 8192000000 10722407184 11144658944 1770565952 17.772 98 18 36 2 1781193552 5126416 5501184
20:22:33 9450 8192000000 10743939808 11161481216 1822021872 18.194 100 26 52 2 1836504384 7523088 6959424
20:22:48 7401 8192000000 10756247280 11168321536 1817701200 18.159 99 41 81 1 1836376096 6726128 11948768
20:23:03 4626 8192000000 10742387568 11165650944 1818955856 18.169 99 32 64 0 1835158784 6754032 9448896
20:23:17 11708 8192000000 10766297184 11183570944 1820758064 18.184 99 18 36 2 1830522448 5164064 4600320
20:23:35 6095 8192000000 10750328336 11183751168 1844433184 18.377 100 32 64 2 1860134576 6521024 9180368
20:23:47 9216 8192000000 10775505632 11195797504 1847104496 18.399 100 24 48 1 1860149360 6166016 6878848
20:24:04 9215 8192000000 10776880480 11201118208 1855863168 18.470 100 17 34 2 1866329200 5298016 5168016
20:24:23 10081 8192000000 10769057712 11202650112 1861923616 18.519 100 33 64 1 1877973264 6719824 9329824
20:24:40 9607 8192000000 10771707712 11202850816 1860539712 18.508 100 14 28 1 1870329552 5370528 4419312
20:24:58 8259 8192000000 10788813440 11208052736 1863789616 18.534 100 34 68 1 1879614928 5554096 10271216
20:25:12 13589 8192000000 10775526736 11211427840 1862769088 18.526 100 19 38 2 1873437712 5469952 5198672
20:25:35 6807 8192000000 10785282656 11213271040 1872747920 18.607 100 31 65 2 1887046752 5097184 9201648
20:25:48 21909 8192000000 10797046368 11224420352 1878010432 18.649 100 24 48 1 1890770832 5094416 7665984
20:26:17 69433 8192000000 10796672864 11229200384 1883783840 18.696 100 29 58 1 1897534304 4762304 8988160
20:27:32 44967 8192000000 10836115776 11262230528 1902349520 18.845 100 31 62 3 1915718640 4699728 8669392
20:28:27 21464 8192000000 10843673552 11275657216 1923199856 19.012 100 46 91 2 1945352480 8817984 13334640
20:28:57 13095 8192000000 10867905472 11289071616 1932573168 19.087 100 52 102 0 1957026560 10205008 14248384
20:29:18 12197 8192000000 10871596528 11293229056 1936006592 19.115 100 52 104 1 1961696768 11200816 14489360
20:29:37 22861 8192000000 10880617824 11304427520 1940777472 19.153 100 57 115 0 1969262608 12873872 15611264
20:30:15 22299 8192000000 10889206672 11318001664 1949415296 19.222 100 55 110 3 1979640736 14179648 16045792
20:30:45 20231 8192000000 10897148768 11328692224 1954824576 19.265 100 51 100 0 1987111584 17879856 14407152
20:31:13 26169 8192000000 10882506992 11324547072 1955735024 19.272 100 37 73 2 1985777440 18918656 11123760
20:31:47 17309 8192000000 10896375632 11333738496 1962211312 19.324 100 42 84 0 1987181248 13132336 11837600
20:32:15 9494 8192000000 10895533456 11334938624 1965777536 19.352 100 41 82 0 1992613104 14671216 12164352
20:32:32 27525 8192000000 10905584672 11338297344 1967720656 19.367 100 54 108 1 1998375136 15094544 15559936
20:33:10 13471 8192000000 10914466000 11345608704 1972638768 19.406 100 49 98 2 2005600944 18365216 14596960
20:33:32 3128 8192000000 10917564976 11349139456 1976645920 19.438 100 44 86 2 2008378096 18336800 13395376
20:33:48 18270 8192000000 10924527840 11357769728 1988961776 19.536 100 60 120 1 2025150672 19004992 17183904
20:34:15 8354 8192000000 10922215056 11355869184 1982799024 19.487 100 60 119 4 2021463888 20323088 18341776
20:34:34 18028 8192000000 10938769232 11368386560 1984647568 19.501 100 52 101 1 2020172592 20509984 15015040
20:35:04 4908 8192000000 10952377968 11374231552 1996478432 19.595 100 64 126 2 2035916560 20904544 18533584
20:35:16 4947 8192000000 10955110496 11381014528 2001345792 19.633 100 67 132 0 2042915792 22345472 19224528
20:35:28 5362 8192000000 10967493920 11389374464 2006861936 19.677 100 77 153 2 2053655552 24124944 22668672
20:35:40 4836 8192000000 10966021392 11381346304 1989504768 19.540 99 81 162 3 2038979856 25910240 23564848
20:36:02 4071 8192000000 10958139360 11378585600 1998215936 19.609 100 81 162 1 2046967424 25384464 23367024
20:36:13 5241 8192000000 10963305408 11380396032 2004075696 19.655 100 67 133 0 2046661872 23042432 19543744
20:36:28 6254 8192000000 10956470224 11383713792 2004308976 19.657 100 72 143 0 2049174128 24025408 20839744
20:36:41 4002 8192000000 10958546544 11378110464 1995832656 19.590 100 80 160 2 2044453264 24792032 23828576
20:36:53 2014 8192000000 10955784592 11372322816 1992547984 19.564 100 74 147 0 2039129888 24538400 22043504
20:37:02 7826 8192000000 10948341072 11378294784 1994007424 19.575 100 63 123 0 2037028976 24223024 18798528
20:37:17 3189 8192000000 10954939312 11384922112 2005299040 19.665 100 70 139 0 2049490800 23458736 20733024
20:37:27 4292 8192000000 10959671552 11381833728 1985275168 19.506 99 69 138 0 2029605632 23440912 20889552
20:37:39 3666 8192000000 10957850656 11384156160 1999947584 19.622 100 61 122 1 2044817648 25448064 19422000
20:37:50 5447 8192000000 10968046528 11399061504 2012523808 19.721 100 65 130 0 2060322240 28060576 19737856
20:38:02 6882 8192000000 10968696496 11392823296 1993239040 19.569 99 65 130 3 2041200080 27522176 20438864
20:38:20 13372 8192000000 10971916272 11402178560 2012852576 19.724 100 69 133 0 2062938288 29875936 20209776
20:38:42 6985 8192000000 10971257200 11410513920 2013359744 19.728 100 56 112 0 2062040080 31022384 17657952
20:38:56 5507 8192000000 10971966064 11402108928 2007622368 19.683 100 66 132 0 2060051968 32337104 20092496
20:39:11 3282 8192000000 10985735952 11406454784 2014994656 19.741 100 82 161 2 2072829024 34051504 23782864
20:39:21 12728 8192000000 10981181328 11413192704 2015170272 19.742 100 83 162 1 2076022144 35817552 25034320
20:39:44 2983 8192000000 10991215808 11411316736 2000216144 19.624 99 79 159 0 2061261360 36735008 24310208
20:39:58 2199 8192000000 10968890736 11386175488 1989860752 19.543 99 78 153 2 2048282672 34841552 23580368
20:40:10 6337 8192000000 10974770976 11405606912 2007623968 19.683 100 73 146 1 2066121152 35549376 22947808
20:40:25 4895 8192000000 10986688672 11418185728 2014765520 19.739 100 64 125 2 2067521392 33653840 19102032
20:40:39 4741 8192000000 10996162736 11423526912 2020797936 19.786 100 80 158 0 2081577616 35653360 25126320
20:40:51 5203 8192000000 10984104784 11416403968 2004034624 19.655 99 63 126 1 2061746176 38247904 19463648
20:41:04 6941 8192000000 10993925344 11418849280 2015292048 19.743 100 77 154 0 2078675504 39642640 23740816
20:41:18 3491 8192000000 10993440992 11414290432 2003553328 19.651 99 86 170 0 2070488192 41124688 25810176
20:41:31 5303 8192000000 10976357744 11396009984 1987566208 19.525 100 70 141 2 2058323296 49672304 21084784
20:41:52 4456 8192000000 11000989680 11420569600 2007925072 19.685 100 76 152 1 2079428224 47145168 24357984
20:42:03 4239 8192000000 11005849392 11428970496 2012586912 19.722 100 75 150 1 2085533376 49150560 23795904
20:42:16 1959 8192000000 11009087232 11426357248 2013252912 19.727 100 81 159 0 2086236736 48318400 24665424
20:42:27 3468 8192000000 11009350848 11426148352 2013622704 19.730 100 90 176 0 2087891712 46728272 27540736
20:42:38 4856 8192000000 11008046400 11427237888 2018924832 19.772 100 76 152 2 2084160144 42236064 22999248
20:42:52 2358 8192000000 11006048816 11427569664 2018032816 19.765 100 84 168 1 2091744080 48014672 25696592
20:43:04 2128 8192000000 10973706848 11391344640 1983910208 19.496 99 78 157 0 2050359680 41999936 24449536
20:43:16 13389 8192000000 10990151344 11414016000 2005226240 19.664 100 69 138 0 2069655376 42991664 21437472
20:43:38 3719 8192000000 10984763472 11407294464 2001360640 19.633 100 72 145 2 2068256672 43185872 23710160
20:43:49 3100 8192000000 10991245824 11411206144 2003407760 19.650 100 84 168 0 2075732720 45187600 27137360
20:43:59 4751 8192000000 10993506080 11411058688 2006313872 19.672 100 90 178 1 2081006896 46780512 27912512
20:44:13 4448 8192000000 10991391200 11415572480 2007442096 19.681 100 71 142 3 2074692368 44967920 22282352
20:44:27 4886 8192000000 10997419184 11414761472 2002849744 19.645 100 80 159 0 2077135936 48761296 25524896
20:44:39 3154 8192000000 10988683088 11406086144 1992717232 19.565 99 87 173 1 2067165008 47812192 26635584
20:44:51 1181 8192000000 10995485680 11411288064 2001992304 19.638 100 86 172 3 2077423056 48571296 26859456
20:45:00 2354 8192000000 10955476816 11372032000 1960284160 19.308 98 84 167 0 2036846768 50082736 26479872
20:45:09 1623 8192000000 10972501264 11382829056 1972264816 19.403 99 78 156 1 2046203152 50190400 23747936
20:45:17 5903 8192000000 10982436336 11401932800 1988696720 19.533 100 77 152 1 2064856176 50835696 25323760
20:45:32 2685 8192000000 10988937888 11409391616 1997311232 19.602 100 80 159 3 2074105424 51635008 25159184
20:45:43 2396 8192000000 10993833776 11401846784 1984370240 19.499 99 93 184 2 2067653376 54904480 28378656
20:45:55 7591 8192000000 10996840000 11417034752 1997317056 19.602 100 79 158 1 2079492368 57161232 25014080
20:46:11 1284 8192000000 11014265872 11428478976 2008962384 19.693 100 86 172 1 2090809488 55596192 26250912
20:46:19 3925 8192000000 10998661664 11426746368 2009729296 19.699 100 68 136 1 2084972768 53378800 21864672
20:46:31 3645 8192000000 11022821920 11433193472 2014109136 19.734 100 89 178 2 2099381952 57277104 27995712
20:46:41 3779 8192000000 11008461312 11422388224 1995946224 19.591 99 81 159 3 2078968928 57612400 25410304
20:46:53 2874 8192000000 10961174208 11369332736 1920888560 18.994 96 84 168 1 2004169760 56391216 26889984
20:47:04 1518 8192000000 10998413216 11406057472 1988405776 19.531 100 96 193 2 2073764480 55601056 29757648
20:47:13 2216 8192000000 10993282336 11405180928 1988688640 19.533 100 89 178 1 2073843728 56825472 28329616
20:47:22 2367 8192000000 11001177472 11410022400 1989633744 19.541 100 93 183 1 2074890816 56317456 28939616
20:47:37 3661 8192000000 10979863440 11402256384 1967923824 19.369 99 73 146 1 2048375392 57145296 23306272
20:47:49 1737 8192000000 10991247488 11406639104 1990789456 19.550 100 87 173 2 2074692496 56418656 27484384
20:48:04 1992 8192000000 10977741280 11396837376 1972911904 19.409 100 70 138 1 2055721360 60818608 21990848
20:48:14 2796 8192000000 10985805120 11407282176 1978592224 19.454 100 70 141 1 2060772624 58908608 23271792
20:48:24 4766 8192000000 10988670368 11415613440 1992953520 19.567 100 68 135 2 2077826000 63033616 21838864
20:48:43 12991 8192000000 10971357424 11411513344 1970596000 19.390 99 48 96 1 2048471856 61262912 16612944
20:49:14 14815 8192000000 10982553504 11426521088 1971163648 19.395 99 36 72 0 2046797712 63186624 12447440
20:49:37 6968 8192000000 10984079920 11422179328 1988240240 19.530 100 44 86 2 2065121360 62601456 14279664
20:49:54 10640 8192000000 10960358256 11406909440 1979789504 19.463 100 39 78 0 2050261472 56495312 13976656
20:50:11 10697 8192000000 10971595936 11419217920 1988980032 19.536 100 36 71 2 2057506800 56274192 12252576
20:50:28 11773 8192000000 10968566080 11410477056 1984260880 19.498 100 42 84 1 2050986144 52529952 14195312
20:50:50 9546 8192000000 10949114112 11393572864 1966892832 19.361 99 40 81 2 2036964688 56422816 13649040
20:51:06 10237 8192000000 10964217648 11403104256 1955751360 19.272 99 40 80 3 2027924256 58544672 13628224
20:51:29 11369 8192000000 10945520592 11388608512 1956596032 19.279 100 40 80 2 2026950640 56399216 13955392
20:51:47 16475 8192000000 10949393920 11395309568 1961655264 19.319 100 35 70 2 2034785248 60502768 12627216
20:52:12 20194 8192000000 10927218880 11380797440 1944313920 19.181 99 31 62 1 2009779680 54579280 10886480
20:52:50 24995 8192000000 10914212448 11368194048 1912804288 18.929 98 22 44 2 1972604352 51151968 8648096
20:53:36 41232 8192000000 10892775296 11354161152 1909197728 18.900 99 19 38 1 1979928112 62829888 7900496
20:54:30 42041 8192000000 10893857056 11361349632 1935384256 19.110 100 16 32 1 1989485792 48099712 6001824
20:55:18 48833 8192000000 10870413584 11323195392 1869533376 18.580 96 20 40 0 1885899648 10787360 5578912
20:56:21 36822 8192000000 10858321520 11305492480 1885920896 18.713 98 12 25 1 1899722000 10577840 3223264
20:57:18 61009 8192000000 10833184080 11297492992 1862374144 18.523 97 16 32 0 1877943808 11366768 4202896
20:58:47 44092 8192000000 10850037120 11310452736 1904288640 18.861 99 15 30 0 1918216416 10422944 3504832
20:59:42 18903 8192000000 10851624464 11317968896 1928762240 19.057 100 17 32 0 1944407504 10921248 4724016
21:00:11 76800 8192000000 10864097696 11329269760 1906109008 18.875 98 15 29 0 1919668480 9810080 3749392
21:01:55 117229 8192000000 10887184928 11344490496 1950840640 19.233 100 15 30 2 1967927344 12819760 4266944
21:04:02 115378 8192000000 10862791088 11326402560 1873341312 18.611 96 18 36 0 1887486944 8841696 5303936
21:06:14 51693 8192000000 10882231712 11347091456 1924016368 19.019 98 24 48 0 1939095920 8351088 6728464
21:07:13 98237 8192000000 10911012976 11358728192 1969062784 19.378 100 16 32 1 1983419568 9472144 4884640
21:09:07 12740 8192000000 10900947168 11360645120 1977920768 19.448 100 36 72 0 1997162800 9230640 10011392
21:09:30 1585 8192000000 10925991104 11369054208 1987880448 19.527 100 60 120 1 2013781648 9324416 16576784
21:09:38 15480 8192000000 10911333344 11370315776 1982411120 19.484 100 47 94 0 2007483072 11478480 13593472
21:10:01 33643 8192000000 10898489168 11371622400 1976925344 19.440 100 19 38 0 1994724032 11982112 5816576
21:10:46 55515 8192000000 10904444880 11367972864 1958805040 19.297 99 16 32 2 1972748816 9242864 4700912
21:11:57 16883 8192000000 10923358000 11373539328 1987253104 19.522 100 61 122 0 2015386912 10247504 17886304
21:12:22 45691 8192000000 10896503760 11374940160 1982256288 19.483 100 38 76 0 2006483616 13274304 10953024
21:13:15 43702 8192000000 10898508672 11371864064 1962935312 19.329 99 13 26 0 1984868688 17772736 4160640
21:14:18 48455 8192000000 10904429536 11392192512 1973267200 19.411 100 7 14 0 1995629376 20170944 2191232
21:16:23 39114 8192000000 10906034320 11391774720 1972538272 19.406 100 5 10 0 1991869664 18035360 1296032
21:17:15 24080 8192000000 10895916320 11357937664 1941400368 19.158 98 11 22 0 1959103168 14620000 3082800
21:17:46 39882 8192000000 10906586448 11369205760 1939556560 19.143 98 43 84 1 1958918368 6998976 12362832
21:18:34 38342 8192000000 10912337200 11381772288 1960897264 19.313 99 27 54 4 1980288896 11283888 8107744
21:19:24 60102 8192000000 10882912080 11362746368 1922469232 19.007 97 16 32 0 1938551216 11853728 4228256
21:21:01 65452 8192000000 10914537248 11372478464 1933442352 19.094 98 13 26 1 1946545776 9487856 3615568
21:22:14 46215 8192000000 10923218400 11378384896 1945310592 19.189 98 37 74 0 1969521056 13824912 10385552
21:23:06 62251 8192000000 10878238288 11361132544 1920957440 18.995 98 23 46 2 1940272768 13048928 6266400
21:24:15 69770 8192000000 10892496720 11343949824 1882524400 18.685 96 14 28 0 1896619568 10205024 3890144
21:25:31 28402 8192000000 10864396528 11316150272 1865394656 18.547 96 24 48 0 1881552480 9368224 6789600
21:26:07 41546 8192000000 10865754912 11328544768 1909629712 18.904 99 25 50 0 1931093088 13860192 7603184
21:27:01 50532 8192000000 10845929280 11303112704 1837102704 18.317 95 30 56 6 1855599520 10467456 8029360
21:27:58 92773 8192000000 10860443376 11327418368 1873507632 18.613 97 13 26 0 1893868800 17474032 2887136
21:29:37 116589 8192000000 10833762256 11284922368 1791782096 17.946 93 17 34 1 1808655424 12505248 4368080
21:31:41 43869 8192000000 10860666896 11308105728 1896368112 18.797 99 44 87 2 1919577024 10917488 12291424
21:32:31 25814 8192000000 10827919296 11286601728 1871115840 18.593 98 30 60 1 1890441312 10862000 8463472
21:33:09 33391 8192000000 10831864976 11297730560 1888645840 18.735 99 17 34 1 1902719792 9578064 4495888
21:34:01 50963 8192000000 10840450912 11319205888 1897229104 18.804 99 6 12 2 1907028688 8452672 1346912
21:34:59 18796 8192000000 10842241280 11309744128 1881120432 18.674 98 6 12 0 1890558352 8003536 1434384
21:35:23 41029 8192000000 10863308448 11317420032 1885915664 18.713 98 26 52 2 1899138336 5850064 7372608
21:36:10 23573 8192000000 10886377424 11333824512 1920132896 18.988 99 51 97 0 1947220704 14407232 12680576
21:36:48 28060 8192000000 10887145664 11336384512 1921349040 18.998 99 54 108 1 1951757600 15267328 15141232
21:37:31 81817 8192000000 10869016000 11334049792 1857762032 18.485 96 22 44 1 1888720656 24663312 6295312
21:38:59 96777 8192000000 10845480864 11325566976 1864478256 18.540 97 10 20 0 1886293136 18809744 3005136
21:40:44 53049 8192000000 10867108896 11312816128 1881357936 18.676 98 18 36 0 1896312544 9866640 5087968
21:41:44 21909 8192000000 10883356736 11331674112 1901700880 18.840 98 41 82 1 1921202432 8414496 11087056
21:42:24 52317 8192000000 10889067632 11356995584 1942852816 19.170 100 24 48 2 1965895840 16021472 7021552
21:43:25 24141 8192000000 10894919744 11351531520 1946669440 19.200 100 33 66 0 1966730320 11082336 8978544
21:44:00 19304 8192000000 10885376352 11345379328 1929382624 19.062 99 21 42 0 1943905936 9035728 5487584
21:44:28 33580 8192000000 10872734784 11321339904 1880185792 18.667 97 37 75 1 1899098384 8240496 10672096
21:45:08 15833 8192000000 10888253520 11337846784 1934192688 19.100 100 37 74 0 1954124448 9831360 10100400
21:45:33 41391 8192000000 10875795472 11344109568 1904863136 18.865 98 34 68 1 1926029472 11918176 9248160
21:46:26 47772 8192000000 10897569776 11356553216 1929040368 19.059 99 17 34 2 1947914384 13857440 5016576
21:47:22 87647 8192000000 10880381904 11359363072 1892624352 18.767 97 8 16 2 1911818960 16455952 2738656
21:49:06 128233 8192000000 10873651952 11342553088 1892693264 18.767 97 26 50 2 1908962192 9146064 7122864
21:51:23 68952 8192000000 10886290976 11362787328 1953853616 19.257 100 24 48 1 1970999680 10347376 6798688
21:52:59 3766 8192000000 10894685680 11357204480 1944896592 19.186 99 42 84 1 1966604128 9250496 12457040
21:53:09 5172 8192000000 10885348272 11357405184 1954541136 19.263 100 24 49 3 1970887792 9764736 6581920
21:53:20 42223 8192000000 10849823456 11335217152 1909463824 18.902 98 24 48 0 1925705920 9095248 7146848
21:54:11 2231 8192000000 10891617584 11346952192 1944270832 19.181 100 50 103 2 1965398096 7352816 13774448
21:54:19 62337 8192000000 10881326560 11355766784 1955904176 19.273 100 30 60 1 1977541360 13307216 8329968
21:55:28 65611 8192000000 10889288832 11367288832 1959382768 19.301 100 15 30 1 1977115616 12945760 4787088
21:56:42 23919 8192000000 10891289648 11366473728 1963428256 19.333 100 16 32 1 1982363760 14136432 4799072
21:57:12 66515 8192000000 10887882928 11376816128 1944811696 19.185 99 16 32 2 1962654592 13417232 4425664
21:58:31 76952 8192000000 10894594096 11365613568 1948727952 19.216 99 23 46 1 1965806176 10754944 6323280
22:00:23 70935 8192000000 10890559472 11373531136 1949725680 19.224 99 12 24 0 1959934144 7620864 2587600
22:01:44 97436 8192000000 10910228112 11398402048 1959268400 19.300 99 13 26 0 1978912304 15923664 3720240
22:03:27 95389 8192000000 10863379776 11352719360 1857507472 18.483 94 7 14 1 1878764016 19443472 1813072
22:05:09 54212 8192000000 10889683968 11363319808 1931752272 19.081 99 16 32 2 1948494304 12180096 4561936
22:06:17 61505 8192000000 10895835680 11375341568 1942246016 19.165 99 14 28 2 1965050464 18193072 4611376
22:07:25 45771 8192000000 10892240112 11383828480 1943003952 19.171 99 8 16 0 1965395136 20004608 2386576
22:08:23 73613 8192000000 10916427616 11380199424 1935138688 19.108 98 23 46 0 1953394480 11763136 6492656
22:09:49 22651 8192000000 10924011056 11401494528 1987970976 19.528 100 40 80 0 2012235216 12490064 11774176
22:10:29 90053 8192000000 10904622192 11371794432 1897261824 18.804 96 13 26 0 1918744672 18158288 3324560
22:12:06 62213 8192000000 10919109936 11391504384 1958296576 19.292 99 31 62 1 1979481632 12775376 8409680
22:13:15 102732 8192000000 10891348416 11357483008 1898172064 18.812 96 20 40 0 1916811360 13099168 5540128
22:15:33 97210 8192000000 10889580800 11364118528 1948107312 19.211 99 25 50 0 1967367440 12252512 7007616
22:17:24 32817 8192000000 10875944688 11354013696 1914904160 18.946 98 26 52 2 1938860704 16340640 7615904
22:18:34 27745 8192000000 10853415456 11332603904 1905779216 18.873 98 11 22 1 1919090032 9927920 3382896
22:19:19 77153 8192000000 10855738496 11336179712 1884390400 18.701 97 11 22 0 1895708224 7924480 3393344
22:22:31 57292 8192000000 10846989328 11328372736 1908511440 18.895 98 14 29 0 1919536144 6834400 4190304
22:23:45 53701 8192000000 10853753136 11318804480 1857753440 18.485 96 18 36 1 1870357776 6783424 5820912
22:24:49 60337 8192000000 10848488048 11324534784 1894275632 18.780 98 11 22 1 1904454800 6705600 3473568
22:25:55 78351 8192000000 10868208576 11341549568 1909308272 18.901 99 14 28 0 1921099264 8333648 3457344
22:27:20 32372 8192000000 9238394384 9509474304 395430032 4.604 21 2 4 0 404413584 8454688 528864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 11-06-2021 22:29:34 to 11-06-2021 22:30:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-06-2021 22:30:08 to 11-06-2021 22:30:10.

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          243014
MON$OLDEST_ACTIVE               243015
MON$OLDEST_SNAPSHOT             243015
MON$NEXT_TRANSACTION            243015
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                       2029152
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
:136: 
:137: mscs-test-161.budzdorov.ru    Fri Jun 11 22:27:53 2021
:138:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139: 
:140: 
:141: mscs-test-161.budzdorov.ru    Fri Jun 11 22:27:54 2021
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
--- end of diff output ---

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

11.06.21 22:30:11. 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-06-11 22:30:13 No severe PSQL-related problems occured
11.06.21 22:30:15. End of report.