Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.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 16792436 kB
MemAvailable 31080592 kB
Buffers 0 kB
Cached 14877712 kB
SwapCached 3256 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-25 16:27:19
DTS_END                         2021-02-25 16:27:19.8280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(50:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49442
TRN_ID                          236972
ATT_ID                          697
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: 9091.80 24046 1091016
customer order: creation 168.10 386 20172
customer order: refuse 15.23 366 1828
order to supplier: creation 44.58 1263 5349
order to supplier: removal 3.29 111458 395
invoice (draft): creation 44.85 3963 5382
invoice (draft): removal 51.36 817 6163
invoice accept: apply 41.23 19748 4948
invoice accept: cancel 47.02 827 5642
customer reserve: creation 3784.15 195 454098
customer reserve: removal 4601.44 62 552173
realization accept: apply 80.45 198 9654
realization accept: cancel 82.25 119 9870
payment from customer: creation 58.96 123 7075
payment from customer: removal 5.78 87 693
payment to supplier: creation 46.73 130 5608
payment to supplier: removal 3.51 112 421
service: total inventory turnovers 5.07 1194 608
service: total monetary turnovers 6.98 32 837
service: aggregate perf. data 0.80 23540 96
service: refresh index statistics 0.03 316306 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1795
TEST_TIME 2 2631
TEST_TIME 3 2883
TEST_TIME 4 3635
TEST_TIME 5 4607
TEST_TIME 6 4836
TEST_TIME 7 5069
TEST_TIME 8 5398
TEST_TIME 9 5812
TEST_TIME 10 6567
TEST_TIME 11 6783
TEST_TIME 12 7513
TEST_TIME 13 7423
TEST_TIME 14 7458
TEST_TIME 15 7687
TEST_TIME 16 7709
TEST_TIME 17 7721
TEST_TIME 18 8138
TEST_TIME 19 8227
TEST_TIME 20 8570
TEST_TIME 21 8651
TEST_TIME 22 8870
TEST_TIME 23 9187
TEST_TIME 24 9030
TEST_TIME 25 9256
TEST_TIME 26 9341
TEST_TIME 27 9529
TEST_TIME 28 9777
TEST_TIME 29 10253
TEST_TIME 30 10719
TEST_TIME 31 10571
TEST_TIME 32 10498
TEST_TIME 33 10956
TEST_TIME 34 10967
TEST_TIME 35 10993
TEST_TIME 36 10728
TEST_TIME 37 10624
TEST_TIME 38 10515
TEST_TIME 39 10397
TEST_TIME 40 10314
TEST_TIME 41 10137
TEST_TIME 42 10022
TEST_TIME 43 10001
TEST_TIME 44 9899
TEST_TIME 45 9923
TEST_TIME 46 9769
TEST_TIME 47 9688
TEST_TIME 48 9611
TEST_TIME 49 9544
TEST_TIME 50 9629
TEST_TIME 51 9508
TEST_TIME 52 9403
TEST_TIME 53 9398
TEST_TIME 54 9383
TEST_TIME 55 9462
TEST_TIME 56 9363
TEST_TIME 57 9281
TEST_TIME 58 9231
TEST_TIME 59 9119
TEST_TIME 60 9169
TEST_TIME 61 9227
TEST_TIME 62 9154
TEST_TIME 63 9208
TEST_TIME 64 9291
TEST_TIME 65 9257
TEST_TIME 66 9229
TEST_TIME 67 9233
TEST_TIME 68 9270
TEST_TIME 69 9342
TEST_TIME 70 9363
TEST_TIME 71 9348
TEST_TIME 72 9385
TEST_TIME 73 9417
TEST_TIME 74 9431
TEST_TIME 75 9424
TEST_TIME 76 9361
TEST_TIME 77 9251
TEST_TIME 78 9256
TEST_TIME 79 9247
TEST_TIME 80 9176
TEST_TIME 81 9221
TEST_TIME 82 9161
TEST_TIME 83 9154
TEST_TIME 84 9205
TEST_TIME 85 9166
TEST_TIME 86 9101
TEST_TIME 87 9038
TEST_TIME 88 9113
TEST_TIME 89 9038
TEST_TIME 90 9017
TEST_TIME 91 9041
TEST_TIME 92 9066
TEST_TIME 93 9057
TEST_TIME 94 9080
TEST_TIME 95 9093
TEST_TIME 96 9113
TEST_TIME 97 9130
TEST_TIME 98 9133
TEST_TIME 99 9164
TEST_TIME 100 9150
TEST_TIME 101 9236
TEST_TIME 102 9235
TEST_TIME 103 9203
TEST_TIME 104 9241
TEST_TIME 105 9214
TEST_TIME 106 9186
TEST_TIME 107 9182
TEST_TIME 108 9179
TEST_TIME 109 9184
TEST_TIME 110 9127
TEST_TIME 111 9113
TEST_TIME 112 9074
TEST_TIME 113 9062
TEST_TIME 114 9021
TEST_TIME 115 9047
TEST_TIME 116 9034
TEST_TIME 117 9054
TEST_TIME 118 9127
TEST_TIME 119 9145
TEST_TIME 120 9092

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-02-2021 16:28:24 to 25-02-2021 16:28: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 1511014 1511014 0 0.00 0 15923 7 0 0
doc_list_biud 1511014 1511014 0 0.00 0 41141 29 0 0
sp_add_invoice_to_stock 5076 4948 128 2.52 54 181416 19749 0 128
sp_cancel_adding_invoice 5642 5642 0 0.00 6 88808 828 0 0
sp_cancel_client_order 1828 1828 0 0.00 4 10599 366 0 0
sp_cancel_customer_reserve 552173 552173 0 0.00 1 16373 63 0 0
sp_cancel_pay_from_customer 693 693 0 0.00 2 4805 87 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 6306 112 0 0
sp_cancel_supplier_invoice 6174 6163 11 0.17 2 39120 817 0 11
sp_cancel_supplier_order 395 395 0 0.00 7 936100 111458 0 0
sp_cancel_write_off 9870 9870 0 0.00 1 21397 120 0 0
sp_client_order 20172 20172 0 0.00 4 19394 387 0 0
sp_customer_reserve 454098 454098 0 0.00 0 35488 195 0 0
sp_fill_shopping_cart 30858 30858 0 0.00 1 11715 42 0 0
sp_fill_shopping_cart_clo_res 454098 454098 0 0.00 0 14449 14 0 0
sp_get_clo_for_invoice 4948 4948 0 0.00 0 27908 347 0 0
sp_kill_cost_storno 16626 16626 0 0.00 0 8598 62 0 0
sp_kill_qstorno_ret_qs2qd 1120774 1120774 0 0.00 0 39034 34 0 0
sp_kill_qty_storno 590673 590673 0 0.00 0 41141 73 0 0
sp_lock_selected_doc 20386 20386 0 0.00 0 8264 6 0 0
sp_make_cost_storno 27285 27285 0 0.00 0 15887 54 0 0
sp_multiply_rows_for_pdistr 27285 27285 0 0.00 0 8220 29 0 0
sp_multiply_rows_for_qdistr 20172 20172 0 0.00 0 13854 145 0 0
sp_pay_from_customer 7075 7075 0 0.00 4 15320 124 0 0
sp_pay_to_supplier 5608 5608 0 0.00 5 16377 131 0 0
sp_payment_common 12683 12683 0 0.00 1 13187 35 0 0
sp_qd_handle_on_cancel_clo 1828 1828 0 0.00 0 10593 334 0 0
sp_qd_handle_on_invoice_upd_sts 10590 10590 0 0.00 0 41140 381 0 0
sp_qd_handle_on_reserve_upd_sts 9654 9654 0 0.00 0 13543 72 0 0
sp_reserve_write_off 9654 9654 0 0.00 7 15943 198 0 0
sp_supplier_invoice 5382 5382 0 0.00 6 78526 3964 0 0
sp_supplier_order 5349 5349 0 0.00 5 20865 1264 0 0
srv_aggregate_perf_data 96 96 0 0.00 2666 248478 23541 0 0
srv_fill_mon_cache_memory 179 179 0 0.00 1238 144105 29665 0 0
srv_find_qd_qs_mism 1043966 1043966 0 0.00 0 13688 6 0 0
srv_make_invnt_saldo 608 608 0 0.00 48 78677 1195 0 0
srv_make_money_saldo 837 837 0 0.00 1 817 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 210302 513385 316307 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 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 4948 4948 0 0.00 0 11587 185 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 1 3539 90 0 0
t$perf-norm:sp_cancel_client_order 1828 1828 0 0.00 0 3652 16 0 0
t$perf-norm:sp_cancel_customer_reserve 626 626 0 0.00 0 10507 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 693 693 0 0.00 0 1543 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 1912 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 567 13 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 19310 1593 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 3806 9 0 0
t$perf-norm:sp_client_order 20172 20172 0 0.00 0 6899 19 0 0
t$perf-norm:sp_customer_reserve 949 949 0 0.00 0 5545 14 0 0
t$perf-norm:sp_pay_from_customer 7075 7075 0 0.00 0 4925 12 0 0
t$perf-norm:sp_pay_to_supplier 5608 5608 0 0.00 0 5777 9 0 0
t$perf-norm:sp_reserve_write_off 9654 9654 0 0.00 0 5614 12 0 0
t$perf-norm:sp_supplier_invoice 5382 5382 0 0.00 0 6256 23 0 0
t$perf-norm:sp_supplier_order 5349 5349 0 0.00 0 5511 17 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 994 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 179 179 0 0.00 0 391 7 0 0
t$perf-norm:srv_make_invnt_saldo 608 608 0 0.00 0 3303 34 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 2124 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10152 9896 256 2.52 0 7297 23 0 256
v_all_customers 37050 37050 0 0.00 0 81 1 0 0
v_all_suppliers 29108 29108 0 0.00 0 99 1 0 0
v_all_wares 40344 40344 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 2279 12 0 0
v_cancel_client_order 3656 3656 0 0.00 0 2187 5 0 0
v_cancel_customer_prepayment 1386 1386 0 0.00 0 2191 8 0 0
v_cancel_customer_reserve 1252 1252 0 0.00 0 1587 5 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 5614 13 0 0
v_cancel_supplier_invoice 810 788 22 2.71 0 3775 24 0 22
v_cancel_supplier_order 790 790 0 0.00 0 2223 8 0 0
v_cancel_write_off 2076 2076 0 0.00 0 1961 15 0 0
v_max_id_clo_ord 5349 5349 0 0.00 0 2663 2 0 0
v_max_id_clo_res 949 949 0 0.00 0 1536 12 0 0
v_max_id_ord_sup 5337 5337 0 0.00 0 6594 4 0 0
v_max_non_paid_invoice 1740 1740 0 0.00 0 1123 4 0 0
v_max_non_paid_realizn 3713 3713 0 0.00 0 6540 5 0 0
v_min_id_clo_ord 5349 5349 0 0.00 0 4086 9 0 0
v_min_id_clo_res 949 949 0 0.00 0 3113 9 0 0
v_min_id_ord_sup 5337 5337 0 0.00 0 3764 6 0 0
v_min_non_paid_invoice 5608 5608 0 0.00 0 8502 18 0 0
v_min_non_paid_realizn 7075 7075 0 0.00 0 8553 26 0 0
v_our_firm 10018 10018 0 0.00 0 17 1 0 0
v_reserve_write_off 19308 19308 0 0.00 0 2466 6 0 0
x_lock_depdocs_on_canc_invoice 11411 11411 0 0.00 0 31605 147 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 13607 436 0 0
x_make_qstorno_1000_1200 5349 5349 0 0.00 2 20855 1171 0 0
x_make_qstorno_1200_2000 5382 5382 0 0.00 3 77020 3811 0 0
x_make_qstorno_2100_3300 454098 454098 0 0.00 0 35486 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-02-2021 16:28:29 to 25-02-2021 16:28: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
13:57:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 5554 8192000000 9988511232 10251362304 692781744 7.797 57 40 82 0 708382496 2041696 13559056
13:57:44 16147 8192000000 10282095728 10587574272 1317340528 13.853 100 78 155 0 1348048432 3899168 26808736
13:58:11 25471 8192000000 10345899504 10661167104 1388098752 14.489 100 75 150 0 1418558944 5237680 25222512
13:58:44 30390 8192000000 10401937712 10727124992 1451856288 15.054 100 86 172 1 1484733392 5990304 26886800
13:59:23 15686 8192000000 10421718656 10751393792 1480350960 15.304 100 89 178 1 1515769456 7368512 28049984
13:59:50 12667 8192000000 10435609792 10767917056 1495814512 15.440 100 83 166 0 1530014560 8089088 26110960
14:00:13 22198 8192000000 10455101248 10790342656 1513960000 15.598 100 90 180 1 1551122768 8722320 28440448
14:00:43 14373 8192000000 10473652432 10808676352 1526728464 15.709 100 92 184 1 1564926032 9372176 28825392
14:01:05 18853 8192000000 10485564064 10829746176 1542553504 15.846 100 88 176 0 1579739152 9985728 27199920
14:01:43 16680 8192000000 10520398320 10870185984 1572576352 16.104 100 78 157 0 1606277488 10175248 23525888
14:02:10 12454 8192000000 10542200304 10896969728 1599957680 16.339 100 79 158 0 1633969984 10068400 23943904
14:02:32 15430 8192000000 10571131504 10929688576 1627480672 16.573 100 84 168 1 1663135104 11229408 24425024
14:02:59 9332 8192000000 10604929408 10967293952 1658198624 16.834 100 78 156 0 1692164912 11588448 22377840
14:03:16 10043 8192000000 10625355744 10991558656 1682678768 17.040 100 83 166 0 1719729120 12563488 24486864
14:03:37 12576 8192000000 10646980640 11013193728 1707521792 17.248 100 77 154 1 1741570928 12344288 21704848
14:03:59 8972 8192000000 10666530208 11038822400 1723495552 17.381 100 83 166 0 1760191184 12950608 23745024
14:04:21 6877 8192000000 10690748688 11063488512 1745735568 17.566 100 83 166 0 1782949120 13321376 23892176
14:04:36 5888 8192000000 10699165280 11073916928 1755951344 17.651 100 85 170 0 1794071056 13373136 24746576
14:04:48 5884 8192000000 10710630496 11084050432 1763453888 17.713 100 78 155 2 1798448688 12794240 22200560
14:05:02 4628 8192000000 10713783296 11094433792 1773514832 17.796 100 80 158 1 1808366016 12331936 22519248
14:05:14 4697 8192000000 10717463968 11100295168 1782076672 17.867 100 79 157 2 1816618688 12450368 22091648
14:05:27 4667 8192000000 10726887472 11106766848 1794892560 17.972 100 91 183 1 1834196320 13307392 25996368
14:05:40 6026 8192000000 10735329952 11120312320 1799262480 18.008 100 87 174 2 1838150512 14548656 24339376
14:05:53 3733 8192000000 10741522704 11124248576 1800459728 18.018 100 84 169 0 1837301856 14091360 22750768
14:06:04 2628 8192000000 10750057568 11129520128 1811306128 18.107 100 96 192 1 1852720752 14837008 26577616
14:06:13 3162 8192000000 10754217376 11134291968 1814345968 18.131 100 91 178 0 1853805440 15249360 24210112
14:06:24 4527 8192000000 10765933280 11147288576 1821059440 18.186 100 88 176 0 1859925424 14776560 24089424
14:06:35 6846 8192000000 10767731728 11152850944 1824075296 18.211 100 79 157 0 1861148880 15468160 21605424
14:06:49 3278 8192000000 10777186128 11163127808 1830090096 18.260 100 85 170 1 1867711632 14334288 23287248
14:06:59 2123 8192000000 10779521888 11167211520 1839227904 18.335 100 84 168 2 1876481088 13022224 24230960
14:07:07 1892 8192000000 10792095280 11179945984 1847950848 18.405 100 90 178 0 1886574528 12710480 25913200
14:07:16 1933 8192000000 10799183808 11191517184 1859876624 18.502 100 88 174 0 1896488704 12048624 24563456
14:07:24 2035 8192000000 10798519648 11194171392 1863074576 18.528 100 87 175 0 1899713472 12150720 24488176
14:07:34 1401 8192000000 10817682480 11205136384 1870488240 18.588 100 91 182 1 1908868960 12583312 25797408
14:07:42 2450 8192000000 10813107696 11202117632 1876347920 18.636 100 90 179 2 1913318896 11347904 25623072
14:07:51 2487 8192000000 10824010992 11211902976 1874768992 18.623 100 93 186 2 1914408672 13675232 25964448
14:07:59 1966 8192000000 10825972880 11214249984 1876800896 18.639 100 92 183 1 1915927680 13727280 25399504
14:08:07 2402 8192000000 10821791648 11214581760 1875845360 18.632 100 80 160 0 1911919328 13761408 22312560
14:08:16 2141 8192000000 10823543168 11213520896 1879543648 18.661 100 93 186 2 1920827456 14996928 26286880
14:08:24 1369 8192000000 10826173024 11218853888 1880494768 18.669 100 88 176 2 1919978576 14624496 24859312
14:08:32 1524 8192000000 10821312000 11218489344 1884259632 18.699 100 87 175 0 1922150240 13520688 24369920
14:08:43 17731 8192000000 10806516400 11214323712 1878474096 18.653 100 60 119 2 1904227936 9305104 16448736
14:09:09 1514 8192000000 10836227856 11227381760 1888479648 18.734 100 91 183 1 1925595696 10890848 26225200
14:09:17 15289 8192000000 10828602848 11223851008 1886859120 18.720 100 72 145 1 1918963472 11644416 20459936
14:09:38 1748 8192000000 10840408336 11232825344 1893148496 18.771 100 86 174 0 1930216160 12439824 24627840
14:09:46 14687 8192000000 10805899440 11221770240 1888404768 18.733 100 50 99 1 1912684032 10183440 14095824
14:10:07 3642 8192000000 10810786240 11224891392 1890228000 18.748 100 51 99 6 1912398240 7462192 14708048
14:10:17 3663 8192000000 10804591024 11228524544 1889035520 18.738 100 34 68 3 1907583200 9346960 9200720
14:10:28 4056 8192000000 10808110816 11229380608 1892211520 18.764 100 40 80 1 1912150672 8692784 11246368
14:10:41 7402 8192000000 10803197680 11227250688 1893490448 18.774 100 42 86 1 1913245504 8083664 11671392
14:10:55 4722 8192000000 10808895440 11232423936 1894311664 18.781 100 23 46 2 1905836512 5262384 6262464
14:11:09 5573 8192000000 10800461296 11233509376 1897617760 18.807 100 31 61 0 1913569680 7343024 8608896
14:11:23 11067 8192000000 10800048144 11232862208 1895782096 18.792 100 23 45 0 1908171488 5981552 6407840
14:11:40 4591 8192000000 10815291504 11240722432 1904379664 18.862 100 47 95 2 1924922672 6839792 13703216
14:11:53 5442 8192000000 10818334528 11239936000 1901414640 18.838 100 30 60 1 1916750192 7482368 7853184
14:12:04 10893 8192000000 10796348656 11236077568 1897601440 18.807 100 21 42 0 1913852688 10663104 5588144
14:12:21 7726 8192000000 10806532832 11233009664 1897065424 18.803 100 16 32 1 1908037056 6227616 4744016
14:12:38 12741 8192000000 10801537824 11239788544 1902490752 18.846 100 20 40 1 1913965104 6155024 5319328
14:13:05 12444 8192000000 10806882768 11242647552 1903822080 18.857 100 19 38 1 1915124576 5824256 5478240
14:13:25 69278 8192000000 10852830240 11260805120 1907111648 18.883 100 49 97 2 1927170016 5221456 14836912
14:14:40 2881 8192000000 10833417888 11263733760 1910580096 18.911 100 47 94 2 1933690848 10077312 13033440
14:14:53 5984 8192000000 10831925712 11258445824 1908302912 18.893 100 30 60 0 1923663392 6364608 8995872
14:15:05 6409 8192000000 10829745296 11261620224 1908225776 18.892 100 23 44 3 1920173792 5880432 6067584
14:15:18 6249 8192000000 10819798896 11257585664 1909225888 18.900 100 32 64 0 1924923136 6394784 9302464
14:15:33 3653 8192000000 10831659200 11263090688 1915018576 18.947 100 40 81 0 1934192608 7613584 11560448
14:15:46 11175 8192000000 10824609264 11257270272 1894922624 18.785 99 22 44 0 1907273232 6021312 6329296
14:16:09 5100 8192000000 10825140176 11259252736 1910312032 18.909 100 20 40 0 1921786752 5962928 5511792
14:16:23 10089 8192000000 10816771168 11251388416 1875325280 18.627 98 25 49 0 1889237568 6043568 7868720
14:16:39 7694 8192000000 10830036944 11255549952 1889643136 18.743 99 20 38 2 1905007360 10049568 5314656
14:16:54 8942 8192000000 10807482416 11240509440 1881805584 18.680 99 16 31 2 1891253072 5548032 3899456
14:17:16 34003 8192000000 10786601168 11216089088 1788397568 17.919 94 26 50 1 1800091824 4455024 7239232
14:18:01 25965 8192000000 10766591664 11203575808 1836185712 18.310 98 32 64 0 1851966848 5357600 10423536
14:18:38 10506 8192000000 10747824976 11181236224 1811886192 18.111 97 11 22 0 1819826080 5021936 2917952
14:18:55 10013 8192000000 10782168416 11209994240 1854345152 18.457 99 37 75 0 1871511568 6871344 10295072
14:19:14 4458 8192000000 10775241952 11196141568 1829851792 18.258 98 43 86 1 1849922064 7756944 12313328
14:19:25 5364 8192000000 10752732000 11160723456 1796658144 17.986 97 47 94 2 1817933472 8443712 12831616
14:19:37 4801 8192000000 10761563280 11167854592 1803407648 18.042 98 35 71 3 1819983968 6762512 9813808
14:19:49 4713 8192000000 10701191760 11114463232 1754020832 17.635 96 45 89 0 1774235328 7197312 13017184
14:20:01 10435 8192000000 10700443792 11113340928 1688794048 17.091 93 30 60 2 1703000496 4877616 9328832
14:20:23 6014 8192000000 10687673312 11101081600 1707968336 17.252 95 24 48 2 1721005040 6107872 6928832
14:20:35 7192 8192000000 10672048640 11077668864 1694438880 17.139 95 16 33 2 1704843888 5361328 5043680
14:20:49 6823 8192000000 10705392016 11120836608 1753649584 17.632 98 35 70 1 1770078752 6409504 10019664
14:21:03 11051 8192000000 10729431968 11147890688 1791265760 17.942 99 18 35 0 1801572688 4703696 5603232
14:21:20 8341 8192000000 10719769808 11132280832 1745158704 17.561 96 26 53 0 1758833024 5372848 8301472
14:21:38 10824 8192000000 10715841872 11129016320 1750661680 17.607 97 28 56 1 1764377200 5489696 8225824
14:21:58 45058 8192000000 10727246832 11135586304 1782373712 17.869 98 62 123 1 1804763424 4768736 17620976
14:22:57 11784 8192000000 10723332096 11142692864 1779132448 17.842 98 20 39 1 1789120416 4548880 5439088
14:23:18 5608 8192000000 10733238832 11158810624 1819406688 18.173 100 24 48 1 1832578528 6259568 6912272
14:23:31 6006 8192000000 10728039744 11154104320 1817110096 18.154 100 24 48 0 1831159040 6729984 7318960
14:23:46 6192 8192000000 10742331024 11163684864 1823206880 18.204 100 16 32 0 1833378128 5107664 5063584
14:24:00 6005 8192000000 10741156752 11167551488 1826173984 18.228 100 23 46 0 1842804864 10352112 6278768
14:24:16 7363 8192000000 10760971488 11181391872 1843063056 18.366 100 33 66 1 1859270096 7308656 8898384
14:24:31 6725 8192000000 10757118896 11181826048 1842860368 18.364 100 21 42 1 1855417392 5278976 7278048
14:24:46 7952 8192000000 10750934768 11185885184 1849423680 18.417 100 28 56 1 1863767616 6004640 8339296
14:25:00 7485 8192000000 10766369184 11194822656 1854830384 18.461 100 20 40 2 1865084672 4717136 5537152
14:25:14 7924 8192000000 10776140512 11200012288 1857182800 18.480 100 25 50 0 1870634800 6378848 7073152
14:25:28 13795 8192000000 10770421904 11203538944 1860124432 18.504 100 26 52 0 1877471488 10102608 7244448
14:25:49 7847 8192000000 10772695104 11204018176 1860840416 18.510 100 21 42 1 1872899264 6366144 5692704
14:26:03 7485 8192000000 10777974480 11205386240 1863388672 18.531 100 18 36 1 1874684704 5597168 5698864
14:26:18 10378 8192000000 10781605360 11211669504 1867029936 18.560 100 23 45 3 1880040752 5593040 7417776
14:26:35 10077 8192000000 10778391072 11211157504 1868612720 18.573 100 17 33 1 1879369152 5442096 5314336
14:26:53 102481 8192000000 10810114800 11238268928 1885953936 18.713 100 49 99 1 1905374800 4468112 14952752
14:28:44 54151 8192000000 10848842576 11270512640 1917747168 18.969 100 53 106 0 1941433744 9114272 14572304
14:29:47 11320 8192000000 10858638400 11278270464 1926385744 19.038 100 55 110 2 1951951392 9620624 15945024
14:30:11 22709 8192000000 10866332656 11289313280 1930898000 19.074 100 51 100 2 1955384704 10284048 14202656
14:30:42 17717 8192000000 10883731744 11299909632 1938867648 19.138 100 49 98 0 1964355360 11298224 14189488
14:31:06 13998 8192000000 10882263664 11310223360 1948713136 19.216 100 51 100 1 1975019472 12126688 14179648
14:31:28 22886 8192000000 10889357424 11321942016 1954294560 19.261 100 54 107 1 1984512112 14715472 15502080
14:32:11 26800 8192000000 10879945952 11319861248 1940960656 19.154 99 48 96 3 1970486208 15087936 14437616
14:32:49 12175 8192000000 10892528688 11318935552 1956977952 19.282 100 36 71 2 1978074544 10494832 10601760
14:33:10 14385 8192000000 10895131072 11328389120 1964210096 19.339 100 38 75 1 1986797360 11339632 11247632
14:33:32 2659 8192000000 10908865184 11329896448 1971418304 19.397 100 54 107 0 2002792240 15900528 15473408
14:33:42 2841 8192000000 10922980304 11341455360 1977421264 19.444 100 72 140 1 2010980816 12498160 21061392
14:33:53 1978 8192000000 10928805792 11346141184 1982083088 19.481 100 74 149 2 2016747856 13828640 20836128
14:34:03 11885 8192000000 10929651360 11349667840 1979246464 19.459 100 66 132 1 2013932592 16328608 18357520
14:34:21 8202 8192000000 10935523728 11353792512 1983151072 19.490 100 69 138 1 2020515232 17694016 19670144
14:34:36 11028 8192000000 10920798992 11349929984 1963423472 19.333 99 59 118 0 1998458992 18268016 16767504
14:34:54 4589 8192000000 10924438976 11351134208 1978611968 19.454 100 58 116 1 2012147056 16682000 16853088
14:35:17 3747 8192000000 10934839408 11357933568 1984774496 19.502 100 68 135 1 2019375760 15240768 19360496
14:35:28 13233 8192000000 10942333536 11361738752 1988477904 19.532 100 71 143 2 2025039648 15394240 21167504
14:35:53 7548 8192000000 10941222496 11372490752 1993500400 19.571 100 55 110 0 2030816576 20557744 16758432
14:36:15 3701 8192000000 10939850640 11367419904 1991528256 19.556 100 65 130 1 2031716704 20603120 19585328
14:36:27 1570 8192000000 10959012768 11370668032 1994768048 19.581 100 77 153 0 2038602992 21083024 22751920
14:36:36 3191 8192000000 10939380560 11355394048 1974150208 19.418 99 74 148 0 2018893248 22877760 21865280
14:36:45 5639 8192000000 10945944128 11372691456 1990224656 19.546 100 80 157 1 2036856016 23962048 22669312
14:36:58 2832 8192000000 10959898112 11379445760 1993388336 19.571 100 78 156 1 2041576128 25366896 22820896
14:37:08 4004 8192000000 10949201296 11379773440 1994357504 19.578 100 70 140 3 2041003872 25899168 20747200
14:37:22 4042 8192000000 10918504096 11351146496 1966725648 19.359 99 53 106 2 2007303392 24659600 15918144
14:37:35 1910 8192000000 10947335904 11368460288 1991782416 19.558 100 80 160 1 2039234976 22736400 24716160
14:37:47 8546 8192000000 10939705664 11376541696 1992928832 19.567 100 58 116 0 2031372976 21880592 16563552
14:38:06 6821 8192000000 10930928496 11369107456 1979226176 19.459 99 57 114 0 2015712544 19210912 17275456
14:38:22 6773 8192000000 10940551024 11374063616 1976274432 19.435 99 53 105 0 2012482656 19116096 17092128
14:38:37 6653 8192000000 10953506624 11379396608 1995981440 19.591 100 71 142 0 2039912272 21883200 22047632
14:38:52 2336 8192000000 10965874512 11389173760 2004409616 19.657 100 81 164 0 2050942768 22172960 24360192
14:39:01 1915 8192000000 10972569440 11388030976 2006994512 19.678 100 84 167 1 2055252400 23399840 24858048
14:39:11 2328 8192000000 10974002992 11396976640 2011806928 19.716 100 87 173 0 2062453232 24159856 26486448
14:39:21 3035 8192000000 10959911952 11375128576 1986673088 19.517 99 82 163 2 2036084304 25129616 24281600
14:39:30 4161 8192000000 10958048352 11382661120 2002554976 19.643 100 75 150 1 2047544416 22164688 22824752
14:39:41 3861 8192000000 10938772240 11354775552 1974745504 19.423 99 83 163 2 2017972912 19014320 24213088
14:39:52 1789 8192000000 10953134240 11373203456 1994765872 19.581 100 78 156 4 2038850736 20144576 23940288
14:40:00 13113 8192000000 10936270960 11370950656 1973251040 19.411 99 51 102 2 2009076816 20562688 15263088
14:40:25 5031 8192000000 10943439648 11373854720 1985451216 19.508 100 63 125 1 2024798912 21165952 18181744
14:40:42 13188 8192000000 10935903328 11366858752 1967061792 19.362 99 68 136 1 2008349664 20888000 20399872
14:41:06 5371 8192000000 10937219376 11373633536 1983965552 19.496 100 52 104 0 2021218528 21020592 16232384
14:41:19 1640 8192000000 10940052224 11370377216 1967136640 19.363 99 53 106 0 2008970464 25835600 15998224
14:41:28 6193 8192000000 10920051056 11350884352 1962726656 19.328 99 54 109 0 1998724384 19896976 16100752
14:41:41 4732 8192000000 10912252032 11340214272 1958600064 19.295 100 63 126 1 1998545088 20640592 19304432
14:41:56 3614 8192000000 10911643744 11333804032 1948895520 19.218 99 68 135 2 1993725280 23617504 21212256
14:42:06 4461 8192000000 10931699136 11347591168 1952404480 19.246 99 79 156 2 1998934192 22911168 23618544
14:42:19 13405 8192000000 10930853904 11352416256 1973958480 19.417 100 71 141 3 2019651104 24365856 21326768
14:42:41 1744 8192000000 10936917776 11348037632 1965723088 19.352 100 73 145 1 2011764032 24158800 21882144
14:42:49 2376 8192000000 10938561104 11346993152 1961523296 19.318 100 79 157 2 2014371472 29349984 23498192
14:42:59 4330 8192000000 10950772448 11366809600 1978992656 19.457 100 76 152 3 2029164784 27811056 22361072
14:43:10 3637 8192000000 10953348448 11366969344 1969585280 19.382 99 75 150 0 2020777008 29389040 21802688
14:43:22 4843 8192000000 10962541888 11375837184 1986880944 19.519 100 83 167 1 2042364816 30668800 24815072
14:43:35 8434 8192000000 10946510976 11369521152 1976593264 19.438 100 79 156 1 2036691584 36118832 23979488
14:43:51 2589 8192000000 10939265648 11348860928 1958965680 19.298 99 69 138 0 2013728640 33421936 21341024
14:44:03 4133 8192000000 10949737872 11374542848 1980553840 19.469 100 75 150 1 2037360992 32086688 24720464
14:44:14 1427 8192000000 10959184528 11375378432 1981413168 19.476 100 85 168 1 2036851872 31435440 24003264
14:44:23 8155 8192000000 10954295472 11380158464 1983887072 19.495 100 75 150 0 2043500720 36412160 23201488
14:44:41 6103 8192000000 10947704768 11358171136 1960949408 19.314 99 86 172 2 2025590064 39320848 25319808
14:44:54 2844 8192000000 10915449456 11334164480 1929593152 19.064 98 68 134 0 1985231296 34491632 21146512
14:45:08 4373 8192000000 10910851872 11321266176 1915501680 18.951 98 82 162 1 1972571648 32120432 24949536
14:45:19 2574 8192000000 10912737728 11323289600 1933388256 19.094 100 89 176 0 1993615072 32404240 27822576
14:45:31 2685 8192000000 10914846640 11327320064 1939412256 19.142 100 69 136 2 1994378864 33574320 21392288
14:45:41 2609 8192000000 10927157088 11341492224 1951457936 19.238 100 81 161 2 2010389616 34622992 24308688
14:45:50 2204 8192000000 10938474144 11353669632 1961799472 19.320 100 87 169 0 2024680544 35802432 27078640
14:46:02 1236 8192000000 10933070320 11341361152 1929272192 19.061 98 80 159 1 1987794704 34596960 23925552
14:46:10 1396 8192000000 10942245840 11348209664 1958299344 19.293 100 83 165 0 2016607568 33894592 24413632
14:46:19 2635 8192000000 10953983904 11359649792 1969596064 19.382 100 90 180 3 2031000720 34123024 27281632
14:46:29 2580 8192000000 10950020960 11361443840 1967245232 19.364 100 85 170 0 2032188224 38756288 26186704
14:46:38 4956 8192000000 10954096896 11367616512 1972745072 19.407 100 86 171 1 2034588240 35514496 26328672
14:46:49 3942 8192000000 10948069168 11366830080 1970718624 19.391 100 64 126 0 2026484288 35987104 19778560
14:47:01 1308 8192000000 10971514720 11383197696 1985560944 19.509 100 89 174 3 2051793648 37818192 28414512
14:47:08 2508 8192000000 10956153216 11365609472 1970658816 19.391 99 86 172 3 2037239840 39143088 27437936
14:47:18 1292 8192000000 10984501936 11392737280 1986660208 19.517 100 87 174 1 2054671184 41115024 26895952
14:47:25 2746 8192000000 10974013920 11380822016 1980690928 19.470 100 86 170 2 2048600688 41839184 26070576
14:47:36 3405 8192000000 10958439824 11383930880 1979000240 19.457 100 66 130 1 2043338048 43637376 20700432
14:47:47 2930 8192000000 10953164080 11384848384 1961633792 19.319 99 59 117 0 2023121264 42912864 18574608
14:48:12 13932 8192000000 10934839888 11360370688 1922497104 19.007 97 63 126 1 1975181104 32651744 20032256
14:48:33 2867 8192000000 10953653072 11361234944 1967209392 19.363 100 81 157 0 2027553184 35585648 24758144
14:48:44 1563 8192000000 10971380592 11381469184 1980988384 19.473 100 87 174 0 2046787952 38791248 27008320
14:48:54 3585 8192000000 10967234432 11383373824 1967498064 19.366 99 73 144 0 2032540112 41563232 23478816
14:49:07 1558 8192000000 10977030144 11384270848 1983155552 19.490 100 81 160 1 2052859552 44049424 25654576
14:49:17 1886 8192000000 10969743840 11389693952 1987353504 19.523 100 75 150 0 2056410816 44858832 24198480
14:49:26 2001 8192000000 10976447392 11395309568 1987499856 19.524 100 82 164 0 2058335872 44636208 26199808
14:49:35 7061 8192000000 10963426048 11394088960 1983390000 19.492 100 62 124 1 2049299328 45543712 20365616
14:49:52 7161 8192000000 10942987072 11388555264 1956374240 19.277 99 46 93 1 2023707088 51061584 16271264
14:50:07 4438 8192000000 10945881776 11378110464 1969621280 19.382 100 46 91 0 2025672000 40514752 15535968
14:50:22 22154 8192000000 10918968800 11361550336 1927801056 19.049 98 41 82 0 1985335568 43654688 13879824
14:51:01 8059 8192000000 10940073824 11370704896 1963330160 19.333 100 46 92 0 2018843632 39681360 15832112
14:51:21 18799 8192000000 10916919056 11346759680 1938966944 19.139 99 49 96 2 1996851872 41665056 16219872
14:51:59 14652 8192000000 10924740944 11362529280 1954051104 19.259 100 47 93 0 2013553568 44067424 15435040
14:52:36 13205 8192000000 10916746496 11365552128 1954526784 19.263 100 27 54 1 2003270336 39344528 9399024
14:52:56 6045 8192000000 10917655376 11362652160 1953269520 19.253 100 31 62 3 2002115968 37893424 10953024
14:53:12 17021 8192000000 10926617648 11375144960 1963361776 19.333 100 31 62 2 2013945040 40255872 10327392
14:53:36 17170 8192000000 10931053232 11383160832 1968455136 19.373 100 28 56 2 2021696928 43305216 9936576
14:54:35 18765 8192000000 10921066032 11387109376 1935699472 19.112 99 23 46 1 1997555936 52826528 9029936
14:55:24 22338 8192000000 10909572656 11379597312 1926071504 19.035 99 23 46 0 1986980848 52156560 8752784
14:55:55 32127 8192000000 10934081968 11376758784 1931683552 19.080 99 27 54 0 1985797344 44863808 9249984
14:56:35 28647 8192000000 10910743248 11363819520 1935987328 19.115 99 13 26 0 1979880320 39037424 4855568
14:57:10 23217 8192000000 10896601808 11363962880 1915589936 18.951 98 12 24 0 1949943520 30767344 3586240
14:57:42 42507 8192000000 10904694528 11344654336 1944777456 19.185 99 24 49 1 1966722176 14751792 7192928
14:58:31 40181 8192000000 10919316368 11354259456 1949898832 19.226 99 44 86 3 1976310000 14072816 12338352
14:59:17 54213 8192000000 10914671392 11373559808 1969785616 19.384 100 17 34 1 1994928000 19995792 5146592
15:00:18 71930 8192000000 10894382576 11354193920 1903391872 18.854 97 8 16 0 1923832608 18077744 2362992
15:01:37 118740 8192000000 10911007184 11373629440 1931194112 19.076 98 9 18 2 1957912032 24418016 2299904
15:03:54 27646 8192000000 10919482640 11364917248 1981555264 19.477 100 42 84 1 2000064736 6341088 12168384
15:04:28 12810 8192000000 10912813008 11369988096 1981282992 19.475 100 25 49 1 1996195312 8786144 6126176
15:04:50 16975 8192000000 10911753440 11378335744 1987289264 19.522 100 25 50 1 2003915952 10008272 6618416
15:05:14 22772 8192000000 10911523744 11375611904 1967215296 19.363 99 13 25 2 1980671280 9985088 3470896
15:05:49 87658 8192000000 10920637184 11396800512 1992575104 19.564 100 16 30 0 2009865680 13254176 4036400
15:07:49 94055 8192000000 10922402640 11377487872 1954694976 19.264 98 28 55 1 1975446048 13252368 7498704
15:09:35 101216 8192000000 10932073152 11387060224 1991009216 19.552 100 26 53 0 2010459312 12219200 7230896
15:11:29 125364 8192000000 10909457056 11361546240 1931088720 19.076 97 15 30 0 1947735392 12366768 4279904
15:13:41 61454 8192000000 10909836848 11380527104 1990666912 19.549 100 37 75 1 2009454576 8480112 10307552
15:14:49 79439 8192000000 10912204576 11363827712 1895137136 18.787 95 19 38 0 1909816752 9159552 5520064
15:16:15 86257 8192000000 10891038160 11354079232 1953286864 19.253 99 32 64 1 1971833328 9353952 9192512
15:17:54 62369 8192000000 10910797888 11369218048 1980797776 19.471 100 24 48 0 1994868272 7091904 6978592
15:19:09 32268 8192000000 10915355920 11370217472 1947020144 19.203 98 28 56 0 1963104448 8209584 7874720
15:19:53 47453 8192000000 10899029680 11376144384 1981981968 19.480 100 23 46 1 1999676448 10462960 7231520
15:20:47 27166 8192000000 10916773136 11384541184 1964504032 19.342 99 13 26 1 1979680496 11475312 3701152
15:21:45 63021 8192000000 10892802016 11385335808 1940332864 19.149 98 14 29 0 1958221552 13601744 4286944
15:23:00 45744 8192000000 10885805760 11367030784 1934266320 19.101 98 14 26 1 1957102432 19384416 3451696
15:23:56 65945 8192000000 10910570512 11399995392 1955074624 19.267 99 9 18 0 1987463840 30142560 2246656
15:25:14 42886 8192000000 10901549616 11377377280 1971880672 19.400 100 6 12 0 1999569104 26035824 1652608
15:26:03 54628 8192000000 10894758576 11380772864 1976142096 19.434 100 8 17 2 1994119920 15472992 2504832
15:27:04 63114 8192000000 10900179376 11386011648 1959366704 19.301 99 21 41 1 1985979680 20948432 5664544
15:28:15 69968 8192000000 10900942496 11394932736 1963071456 19.330 99 14 28 0 1981348928 14434400 3843072
15:29:35 56825 8192000000 10902284400 11383742464 1958926272 19.298 99 19 36 2 1976206944 12475872 4804800
15:30:42 144105 8192000000 10897046496 11372445696 1867986192 18.568 94 7 14 0 1883629312 13721200 1921920
15:33:12 23051 8192000000 10906415040 11363074048 1941290272 19.157 98 48 97 1 1965883488 10795424 13797792
15:33:41 46015 8192000000 10882595072 11348910080 1888175328 18.731 96 25 49 2 1907012544 12269280 6567936
15:35:00 67628 8192000000 10872381152 11339931648 1895553552 18.791 98 19 38 2 1917869376 16781296 5534528
15:36:30 56181 8192000000 10889560080 11355037696 1933157104 19.092 99 13 26 1 1945585616 8554864 3873648
15:37:38 37388 8192000000 10895007088 11350732800 1906232128 18.876 97 29 55 0 1923948912 9824672 7892112
15:38:23 55688 8192000000 10866691248 11334434816 1881075056 18.674 96 27 54 0 1899629088 11102160 7451872
15:40:32 97543 8192000000 10864733584 11342098432 1835248416 18.302 94 16 32 1 1852466304 13017920 4199968
15:42:16 52623 8192000000 10863453696 11328823296 1864585280 18.540 96 12 24 1 1877708576 10164496 2958800
15:43:20 112243 8192000000 10847525792 11296227328 1877983360 18.649 97 31 62 0 1895688784 8804608 8900816
15:45:21 83821 8192000000 10849919088 11329810432 1885791536 18.712 98 11 22 0 1902374512 13813440 2769536
15:47:08 12640 8192000000 10854364880 11333013504 1929110896 19.060 100 11 22 0 1947169472 15464272 2594304
15:47:28 23224 8192000000 10865736384 11331817472 1912833056 18.929 99 14 28 0 1930989712 14329536 3827120
15:48:08 53048 8192000000 10865985168 11348586496 1931044464 19.075 99 27 54 0 1957298336 18367296 7886576
15:49:35 53195 8192000000 10872729440 11343761408 1911323440 18.917 98 17 34 0 1928324000 12584048 4416512
15:50:40 51620 8192000000 10874674176 11350118400 1938892624 19.138 99 16 32 0 1955711216 12103856 4714736
15:51:39 85119 8192000000 10860294256 11352322048 1920875136 18.994 98 10 20 0 1938939536 15258880 2805520
15:53:10 33037 8192000000 10876536528 11345842176 1947164240 19.204 100 10 20 0 1960539456 11058528 2316688
15:54:00 56217 8192000000 10877921312 11349925888 1934825728 19.105 99 13 26 0 1954207360 15720448 3661184
15:55:10 60296 8192000000 10870449248 11363139584 1933053024 19.091 99 10 20 1 1950227248 14913120 2261104
15:56:25 61969 8192000000 10863374160 11333816320 1913901712 18.938 98 15 30 0 1928790352 11008304 3880336
15:57:33 74732 8192000000 10874758288 11346788352 1933930496 19.098 99 13 26 0 1950088352 12866864 3290992
15:58:55 99303 8192000000 10893440496 11356708864 1863215536 18.529 94 30 60 5 1886311248 15670688 7425024
16:00:41 65566 8192000000 10903739616 11373101056 1966224976 19.355 100 25 50 2 1985702848 12278224 7199648
16:01:53 39468 8192000000 10930707216 11386867712 1983537744 19.493 100 31 63 3 2002621040 9448352 9634944
16:02:40 46620 8192000000 10921127520 11390087168 1968377184 19.373 99 30 60 1 1986806576 10116448 8312944
16:03:39 36948 8192000000 10925558544 11396775936 1987512864 19.524 100 31 62 3 2009753840 13828704 8412272
16:04:27 35887 8192000000 10909626160 11370078208 1949756128 19.225 98 26 52 0 1966366288 9844976 6765184
16:05:12 28026 8192000000 10915579712 11383193600 1965950304 19.353 99 33 66 2 1985444736 10248272 9246160
16:05:53 73188 8192000000 10914393120 11377070080 1949878048 19.226 98 26 51 1 1966944240 9778560 7287632
16:07:16 20298 8192000000 10923773312 11384504320 1978572736 19.453 100 47 94 2 2000120448 8650480 12897232
16:07:43 57599 8192000000 10912415104 11400855552 1966800544 19.360 99 23 46 3 1986383008 13085936 6496528
16:08:49 60643 8192000000 10868907200 11334963200 1836130096 18.309 93 13 26 0 1851032224 11520496 3381632
16:10:01 21490 8192000000 10916218672 11363741696 1964965984 19.345 100 52 104 1 1988321136 9034464 14320688
16:10:36 10721 8192000000 10918011520 11364646912 1955969776 19.274 99 51 102 2 1981234768 11211904 14053088
16:10:59 52442 8192000000 10895985968 11371524096 1938055760 19.131 98 46 92 0 1965454320 14207968 13190592
16:11:59 22787 8192000000 10889721520 11358441472 1932053088 19.083 98 16 32 1 1947923632 11150528 4720016
16:12:28 78214 8192000000 10888751904 11370217472 1943430512 19.174 99 19 37 1 1966334992 17726896 5177584
16:14:33 61060 8192000000 10883961568 11353501696 1927458672 19.047 98 28 56 1 1948762016 13115168 8188176
16:15:42 37195 8192000000 10890916464 11363655680 1954628464 19.263 100 30 58 1 1978801760 15667216 8506080
16:16:25 32214 8192000000 10856344880 11349815296 1924119424 19.020 99 4 8 0 1939132240 13936064 1076752
16:17:16 59216 8192000000 10862726640 11343740928 1915304496 18.949 98 14 28 2 1928747424 9029952 4412976
16:18:22 45708 8192000000 10872519024 11353636864 1946103056 19.195 100 11 22 1 1962546768 12893136 3550576
16:19:13 40892 8192000000 10874215472 11343532032 1927186496 19.044 98 20 40 2 1950981088 17892288 5902304
16:20:01 61067 8192000000 10884980352 11370475520 1939747776 19.145 99 21 42 0 1966839664 19725360 7366528
16:21:13 78197 8192000000 10932164896 11404902400 1976848112 19.440 100 22 44 1 2005595376 22252992 6494272
16:23:09 99908 8192000000 10921211968 11405893632 1965213888 19.347 99 19 37 1 1996221776 24859248 6148640
16:25:01 38489 8192000000 10900922064 11366981632 1936073440 19.115 98 18 36 2 1952759792 12086128 4600224
16:25:53 65366 8192000000 10893444560 11368615936 1917011312 18.963 97 20 40 1 1934605200 11826064 5767824
16:27:04 28903 8192000000 9084761216 9310294016 244814976 2.901 13 2 3 0 251470048 6240656 414416

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 25-02-2021 16:28:35 to 25-02-2021 16:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 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 25-02-2021 16:29:09 to 25-02-2021 16:29:11.

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          237277
MON$OLDEST_ACTIVE               237278
MON$OLDEST_SNAPSHOT             237278
MON$NEXT_TRANSACTION            237278
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                       2048288
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 ---
:282: 
:283: mscs-test-161.budzdorov.ru    Thu Feb 25 16:27:38 2021
:284:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:285: 
--- end of diff output ---

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

25.02.21 16:29:12. 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-25 16:29:14 No severe PSQL-related problems occured
25.02.21 16:29:16. End of report.