Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.01.2021 19:29
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 16964924 kB
MemAvailable 31295580 kB
Buffers 0 kB
Cached 14754596 kB
SwapCached 4868 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-01-29 19:27:15
DTS_END                         2021-01-29 19:27:15.4910
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/56178
TRN_ID                          250613
ATT_ID                          686
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: 9586.51 16451 1150381
customer order: creation 187.09 344 22451
customer order: refuse 15.89 352 1907
order to supplier: creation 48.90 1229 5868
order to supplier: removal 3.55 94802 426
invoice (draft): creation 50.03 3302 6003
invoice (draft): removal 55.41 714 6649
invoice accept: apply 43.62 17168 5234
invoice accept: cancel 49.95 788 5994
customer reserve: creation 3931.94 174 471833
customer reserve: removal 4880.28 55 585634
realization accept: apply 90.97 181 10916
realization accept: cancel 89.89 101 10787
payment from customer: creation 64.42 114 7730
payment from customer: removal 6.11 124 733
payment to supplier: creation 51.55 128 6186
payment to supplier: removal 3.78 71 454
service: total inventory turnovers 5.25 1076 630
service: total monetary turnovers 7.01 31 841
service: aggregate perf. data 0.84 21226 101
service: refresh index statistics 0.03 187049 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-01-2021 19:29:32 to 29-01-2021 19:29:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6119
TEST_TIME 2 5223
TEST_TIME 3 4542
TEST_TIME 4 6128
TEST_TIME 5 5852
TEST_TIME 6 5613
TEST_TIME 7 5749
TEST_TIME 8 6237
TEST_TIME 9 6523
TEST_TIME 10 6769
TEST_TIME 11 6747
TEST_TIME 12 6986
TEST_TIME 13 6759
TEST_TIME 14 7124
TEST_TIME 15 7777
TEST_TIME 16 8206
TEST_TIME 17 8520
TEST_TIME 18 8579
TEST_TIME 19 8861
TEST_TIME 20 9057
TEST_TIME 21 8918
TEST_TIME 22 8983
TEST_TIME 23 8958
TEST_TIME 24 9126
TEST_TIME 25 9439
TEST_TIME 26 9445
TEST_TIME 27 10022
TEST_TIME 28 10015
TEST_TIME 29 11000
TEST_TIME 30 11371
TEST_TIME 31 11208
TEST_TIME 32 10979
TEST_TIME 33 10864
TEST_TIME 34 10582
TEST_TIME 35 10686
TEST_TIME 36 10749
TEST_TIME 37 10636
TEST_TIME 38 10588
TEST_TIME 39 10515
TEST_TIME 40 10485
TEST_TIME 41 10460
TEST_TIME 42 10359
TEST_TIME 43 10429
TEST_TIME 44 10387
TEST_TIME 45 10284
TEST_TIME 46 10218
TEST_TIME 47 10182
TEST_TIME 48 10182
TEST_TIME 49 10055
TEST_TIME 50 10042
TEST_TIME 51 10080
TEST_TIME 52 10021
TEST_TIME 53 9912
TEST_TIME 54 9835
TEST_TIME 55 9799
TEST_TIME 56 9773
TEST_TIME 57 9763
TEST_TIME 58 9736
TEST_TIME 59 9682
TEST_TIME 60 9914
TEST_TIME 61 9950
TEST_TIME 62 10026
TEST_TIME 63 10038
TEST_TIME 64 10176
TEST_TIME 65 10157
TEST_TIME 66 10135
TEST_TIME 67 10188
TEST_TIME 68 10301
TEST_TIME 69 10301
TEST_TIME 70 10248
TEST_TIME 71 10163
TEST_TIME 72 10215
TEST_TIME 73 10165
TEST_TIME 74 10150
TEST_TIME 75 10103
TEST_TIME 76 10049
TEST_TIME 77 9966
TEST_TIME 78 9924
TEST_TIME 79 9879
TEST_TIME 80 9975
TEST_TIME 81 9937
TEST_TIME 82 9996
TEST_TIME 83 10004
TEST_TIME 84 9962
TEST_TIME 85 10031
TEST_TIME 86 9979
TEST_TIME 87 10047
TEST_TIME 88 10010
TEST_TIME 89 10013
TEST_TIME 90 9987
TEST_TIME 91 10078
TEST_TIME 92 10076
TEST_TIME 93 10052
TEST_TIME 94 9967
TEST_TIME 95 9943
TEST_TIME 96 9930
TEST_TIME 97 9910
TEST_TIME 98 9841
TEST_TIME 99 9808
TEST_TIME 100 9806
TEST_TIME 101 9766
TEST_TIME 102 9776
TEST_TIME 103 9739
TEST_TIME 104 9727
TEST_TIME 105 9779
TEST_TIME 106 9747
TEST_TIME 107 9742
TEST_TIME 108 9784
TEST_TIME 109 9787
TEST_TIME 110 9791
TEST_TIME 111 9795
TEST_TIME 112 9792
TEST_TIME 113 9781
TEST_TIME 114 9843
TEST_TIME 115 9793
TEST_TIME 116 9723
TEST_TIME 117 9697
TEST_TIME 118 9688
TEST_TIME 119 9661
TEST_TIME 120 9587

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-01-2021 19:29:36 to 29-01-2021 19:29:39.

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 1588984 1588984 0 0.00 0 10934 6 0 0
doc_list_biud 1588982 1588982 0 0.00 0 52876 26 0 0
sp_add_invoice_to_stock 5369 5234 135 2.51 34 209378 17168 0 135
sp_cancel_adding_invoice 5994 5994 0 0.00 3 53274 789 0 0
sp_cancel_client_order 1907 1907 0 0.00 4 13514 353 0 0
sp_cancel_customer_reserve 585634 585634 0 0.00 1 52877 55 0 0
sp_cancel_pay_from_customer 733 733 0 0.00 2 11362 124 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 2520 71 0 0
sp_cancel_supplier_invoice 6662 6649 13 0.19 1 23801 715 0 13
sp_cancel_supplier_order 426 426 0 0.00 6 920635 94803 0 0
sp_cancel_write_off 10787 10787 0 0.00 1 10556 101 0 0
sp_client_order 22451 22451 0 0.00 3 17396 344 0 0
sp_customer_reserve 471833 471833 0 0.00 0 98533 175 0 0
sp_fill_shopping_cart 34321 34321 0 0.00 1 15744 38 0 0
sp_fill_shopping_cart_clo_res 471832 471832 0 0.00 0 18064 12 0 0
sp_get_clo_for_invoice 5230 5230 0 0.00 0 24635 255 0 0
sp_kill_cost_storno 17968 17968 0 0.00 0 9903 53 0 0
sp_kill_qstorno_ret_qs2qd 1189130 1189130 0 0.00 0 52873 30 0 0
sp_kill_qty_storno 627543 627543 0 0.00 0 52876 65 0 0
sp_lock_selected_doc 22368 22368 0 0.00 0 8790 7 0 0
sp_make_cost_storno 30062 30062 0 0.00 0 10825 54 0 0
sp_multiply_rows_for_pdistr 30061 30061 0 0.00 0 10705 28 0 0
sp_multiply_rows_for_qdistr 22451 22451 0 0.00 0 11692 160 0 0
sp_pay_from_customer 7730 7730 0 0.00 4 11097 114 0 0
sp_pay_to_supplier 6186 6186 0 0.00 5 11044 129 0 0
sp_payment_common 13914 13914 0 0.00 1 10571 31 0 0
sp_qd_handle_on_cancel_clo 1907 1907 0 0.00 0 13509 322 0 0
sp_qd_handle_on_invoice_upd_sts 11224 11224 0 0.00 0 42896 320 0 0
sp_qd_handle_on_reserve_upd_sts 10916 10916 0 0.00 0 14208 58 0 0
sp_reserve_write_off 10916 10916 0 0.00 6 14252 182 0 0
sp_supplier_invoice 6003 6003 0 0.00 7 97247 3303 0 0
sp_supplier_order 5868 5868 0 0.00 5 80987 1230 0 0
srv_aggregate_perf_data 101 101 0 0.00 2916 217160 21227 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1249 134010 30015 0 0
srv_find_qd_qs_mism 1100712 1100712 0 0.00 0 10550 5 0 0
srv_make_invnt_saldo 630 630 0 0.00 17 53264 1077 0 0
srv_make_money_saldo 841 841 0 0.00 1 3895 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 120453 220681 187049 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5234 5234 0 0.00 0 11117 157 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 1 4202 108 0 0
t$perf-norm:sp_cancel_client_order 1907 1907 0 0.00 0 4823 15 0 0
t$perf-norm:sp_cancel_customer_reserve 747 747 0 0.00 0 2769 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 733 733 0 0.00 0 4059 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 2823 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 742 15 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 35120 1700 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 10036 22 0 0
t$perf-norm:sp_client_order 22452 22452 0 0.00 0 13713 18 0 0
t$perf-norm:sp_customer_reserve 1130 1130 0 0.00 0 1286 6 0 0
t$perf-norm:sp_pay_from_customer 7730 7730 0 0.00 0 7719 8 0 0
t$perf-norm:sp_pay_to_supplier 6186 6186 0 0.00 0 5015 11 0 0
t$perf-norm:sp_reserve_write_off 10916 10916 0 0.00 0 7730 11 0 0
t$perf-norm:sp_supplier_invoice 6003 6003 0 0.00 0 7829 20 0 0
t$perf-norm:sp_supplier_order 5868 5868 0 0.00 0 14835 24 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 1249 32 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 460 5 0 0
t$perf-norm:srv_make_invnt_saldo 630 630 0 0.00 0 1287 20 0 0
t$perf-norm:srv_make_money_saldo 841 841 0 0.00 0 10255 29 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 10730 10460 270 2.51 0 4797 17 0 270
v_all_customers 41088 41088 0 0.00 0 133 1 0 0
v_all_suppliers 32210 32210 0 0.00 0 24 1 0 0
v_all_wares 44902 44902 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 2200 11 0 0
v_cancel_client_order 3814 3814 0 0.00 0 3654 6 0 0
v_cancel_customer_prepayment 1466 1466 0 0.00 0 3151 11 0 0
v_cancel_customer_reserve 1494 1494 0 0.00 0 2348 5 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 2249 7 0 0
v_cancel_supplier_invoice 894 868 26 2.90 0 2347 19 0 26
v_cancel_supplier_order 852 852 0 0.00 0 646 5 0 0
v_cancel_write_off 2142 2142 0 0.00 0 1675 13 0 0
v_max_id_clo_ord 5868 5868 0 0.00 0 6675 3 0 0
v_max_id_clo_res 1130 1130 0 0.00 0 3916 22 0 0
v_max_id_ord_sup 6002 6002 0 0.00 0 2973 2 0 0
v_max_non_paid_invoice 1950 1950 0 0.00 0 4810 5 0 0
v_max_non_paid_realizn 3988 3988 0 0.00 0 1688 4 0 0
v_min_id_clo_ord 5868 5868 0 0.00 0 5825 9 0 0
v_min_id_clo_res 1130 1130 0 0.00 0 6719 14 0 0
v_min_id_ord_sup 6002 6002 0 0.00 0 15738 10 0 0
v_min_non_paid_invoice 6185 6185 0 0.00 0 10530 18 0 0
v_min_non_paid_realizn 7729 7729 0 0.00 0 10451 21 0 0
v_our_firm 11296 11296 0 0.00 0 223 1 0 0
v_reserve_write_off 21830 21830 0 0.00 0 4975 6 0 0
x_lock_depdocs_on_canc_invoice 12209 12209 0 0.00 0 18773 106 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 12351 342 0 0
x_make_qstorno_1000_1200 5868 5868 0 0.00 2 80845 1144 0 0
x_make_qstorno_1200_2000 6003 6003 0 0.00 3 91630 3175 0 0
x_make_qstorno_2100_3300 471833 471833 0 0.00 0 98533 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-01-2021 19:29:40 to 29-01-2021 19:29:44.

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
16:57:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 23251 8192000000 10264421600 10578452480 872443776 9.624 68 55 108 1 893897472 2778224 18675472
16:57:55 36384 8192000000 10361570832 10682085376 1409358240 14.678 100 81 162 0 1441312592 5471648 26482704
16:58:40 24683 8192000000 10396406928 10722463744 1447336736 15.014 100 87 173 0 1483085936 7101408 28647792
16:59:17 23629 8192000000 10424279504 10752999424 1476481376 15.271 100 93 186 0 1514999376 8396960 30121040
16:59:55 21532 8192000000 10440143552 10774417408 1494376560 15.427 100 91 182 1 1532807136 9026528 29404048
17:00:29 27895 8192000000 10466578736 10799005696 1512931168 15.589 100 90 181 1 1551054032 9432416 28690448
17:01:06 22285 8192000000 10478292768 10820534272 1535737024 15.787 100 90 180 1 1574404864 9973072 28694768
17:01:39 14717 8192000000 10497976144 10844983296 1554012144 15.945 100 85 170 0 1590732432 10380560 26339728
17:02:04 22001 8192000000 10512594240 10870218752 1573876384 16.116 100 78 155 0 1608387184 10551104 23959696
17:02:37 12467 8192000000 10564744496 10921750528 1616685904 16.482 100 75 150 1 1649356480 9726272 22944304
17:03:05 10277 8192000000 10596368736 10956242944 1647801984 16.746 100 78 156 0 1682131856 11251456 23078416
17:03:24 13174 8192000000 10600635376 10971213824 1665126944 16.892 100 76 152 1 1699597552 12143744 22326864
17:03:48 11815 8192000000 10628053184 10998476800 1689666560 17.099 100 74 148 0 1722882576 11729872 21486144
17:04:07 6255 8192000000 10640070896 11011457024 1700867184 17.192 100 73 144 4 1734050384 12270208 20912992
17:04:22 5939 8192000000 10655223696 11029831680 1713833488 17.301 100 78 155 0 1749464256 13079744 22551024
17:04:35 6618 8192000000 10670324384 11046367232 1733758288 17.467 100 81 163 0 1769428960 12975248 22695424
17:04:51 8195 8192000000 10681072128 11062280192 1747703776 17.583 100 84 168 2 1785699360 14150720 23844864
17:05:06 5981 8192000000 10688135200 11069915136 1756358768 17.654 100 78 156 1 1791329424 12790800 22179856
17:05:20 6219 8192000000 10688548240 11077267456 1759483312 17.680 100 63 126 1 1788834688 11423632 17927744
17:05:35 4415 8192000000 10707327136 11090477056 1773804928 17.798 100 76 151 0 1806455488 11724608 20925952
17:05:47 3616 8192000000 10717946080 11099590656 1779134896 17.842 100 78 156 1 1812947952 11746560 22066496
17:05:59 6683 8192000000 10716829296 11104227328 1791622592 17.945 100 77 154 2 1825058848 11980592 21455664
17:06:16 3328 8192000000 10739765120 11126231040 1801636208 18.027 100 81 163 0 1838200864 13550656 23014000
17:06:25 1938 8192000000 10749940480 11134406656 1810611440 18.101 100 84 168 3 1847110352 13055824 23443088
17:06:34 2567 8192000000 10758669808 11142549504 1816366992 18.148 100 94 188 1 1857653552 14578944 26707616
17:06:43 2787 8192000000 10768809152 11148197888 1818570256 18.166 100 90 179 1 1856759904 13851216 24338432
17:06:52 3162 8192000000 10765547072 11145482240 1823137760 18.203 100 86 169 4 1859341152 13189760 23013632
17:07:02 2446 8192000000 10770940592 11155189760 1826252224 18.229 100 90 178 0 1865289968 13597376 25440368
17:07:11 1523 8192000000 10777421456 11159949312 1833716464 18.290 100 92 182 0 1871888000 12968400 25203136
17:07:19 1807 8192000000 10778220016 11163459584 1838274896 18.327 100 92 185 0 1876806256 13344208 25187152
17:07:27 2022 8192000000 10785153312 11169087488 1840871856 18.348 100 93 186 2 1880706928 13071024 26764048
17:07:36 1838 8192000000 10792208912 11176964096 1845954112 18.389 100 94 187 3 1886171456 13905200 26312144
17:07:45 1845 8192000000 10794711936 11179634688 1850371984 18.425 100 96 194 0 1892217648 14684832 27160832
17:07:53 1771 8192000000 10795365392 11185872896 1849936016 18.422 100 95 190 0 1894592384 17745040 26911328
17:08:02 1164 8192000000 10791974656 11181756416 1852497168 18.442 100 91 180 0 1889777776 11669888 25610720
17:08:09 1885 8192000000 10797591088 11184754688 1852726048 18.444 100 89 180 0 1890576608 12255680 25594880
17:08:18 2573 8192000000 10803785840 11191271424 1854336656 18.457 100 90 179 0 1893406416 13546592 25523168
17:08:27 7650 8192000000 10789901264 11185618944 1858195456 18.489 100 72 145 0 1889704320 11495408 20013456
17:08:41 19907 8192000000 10784429712 11189731328 1856448864 18.474 100 64 129 3 1884574912 10529024 17597024
17:09:08 17043 8192000000 10758078464 11182514176 1856368864 18.474 100 52 105 1 1879381264 8486640 14525760
17:09:36 3684 8192000000 10780960384 11191463936 1857858832 18.486 100 44 88 0 1878024032 7397856 12767344
17:09:49 5354 8192000000 10768373376 11186704384 1859534864 18.500 100 42 86 2 1879130368 7385728 12209776
17:10:02 5012 8192000000 10781270064 11203268608 1864254784 18.538 100 35 70 0 1882624176 8871120 9498272
17:10:16 9009 8192000000 10771275312 11198287872 1865233792 18.546 100 31 60 3 1881240688 6812784 9194112
17:10:31 5487 8192000000 10775861808 11201314816 1866064464 18.552 100 22 40 1 1877605152 6167344 5373344
17:10:45 9074 8192000000 10770163744 11201523712 1869330096 18.579 100 23 46 0 1882150928 6550576 6270256
17:11:00 6910 8192000000 10781775376 11208822784 1874673408 18.622 100 29 57 3 1889487840 6609248 8205184
17:11:13 9757 8192000000 10778509360 11212660736 1873936480 18.616 100 11 22 1 1883010624 6114512 2959632
17:11:30 12379 8192000000 10795226768 11220791296 1878217040 18.651 100 21 42 2 1890840000 6811776 5811184
17:11:54 9605 8192000000 10790254560 11224576000 1883951008 18.697 100 23 45 3 1900819264 10277056 6591200
17:12:10 15109 8192000000 10791364096 11224465408 1888609728 18.735 100 19 38 0 1899591136 5558544 5422864
17:12:32 4625 8192000000 10797892112 11228291072 1891445216 18.757 100 26 52 1 1905861120 7036864 7379040
17:12:46 17936 8192000000 10808617616 11234918400 1890404128 18.749 100 26 52 2 1902482880 5110848 6967904
17:13:13 49524 8192000000 10832170160 11249197056 1896954032 18.802 100 36 72 0 1913712144 5663536 11094576
17:14:09 4712 8192000000 10813383840 11250278400 1899587216 18.823 100 40 80 1 1921485184 10818496 11079472
17:14:23 4196 8192000000 10815172176 11249057792 1898662848 18.816 100 31 60 0 1914247408 7041232 8543328
17:14:35 6106 8192000000 10814737728 11249954816 1897063760 18.803 100 16 32 2 1906950240 5660064 4226416
17:14:50 5844 8192000000 10819870512 11252162560 1900540160 18.831 100 32 64 1 1916854576 7660400 8654016
17:15:02 5814 8192000000 10817175072 11251425280 1902304192 18.845 100 31 61 1 1918423696 7112000 9007504
17:15:14 9670 8192000000 10813423136 11251412992 1900196656 18.828 100 14 28 0 1909450832 5427488 3826688
17:15:33 8756 8192000000 10811297696 11253788672 1905818848 18.873 100 24 48 1 1919665984 6960176 6886960
17:15:48 4483 8192000000 10821349184 11256438784 1903735648 18.856 100 23 44 1 1917049648 7045888 6268112
17:16:03 7807 8192000000 10815267392 11245768704 1896750432 18.800 100 13 26 0 1906330400 5567088 4012880
17:16:20 7354 8192000000 10806922768 11238785024 1864384912 18.539 98 13 26 1 1873253392 5430256 3438224
17:16:34 10018 8192000000 10792321872 11234664448 1888754976 18.736 100 20 40 4 1900980816 6355232 5870608
17:16:50 9427 8192000000 10794409008 11225993216 1865659472 18.549 99 19 38 4 1875906672 4847184 5400016
17:17:05 11474 8192000000 10791957584 11225034752 1850721520 18.428 98 13 26 1 1859568208 5451120 3395568
17:17:27 14795 8192000000 10791922912 11222478848 1858405056 18.490 99 20 40 2 1868750048 4806064 5538928
17:17:50 68251 8192000000 10780759808 11212181504 1793388960 17.960 95 27 54 1 1806074256 4838224 7847072
17:19:06 10674 8192000000 10743656608 11164319744 1746192256 17.570 94 26 52 1 1758914704 5099984 7622464
17:19:24 6326 8192000000 10755381648 11186380800 1843423360 18.369 100 30 60 1 1858798464 6655872 8719232
17:19:37 7134 8192000000 10742302544 11164434432 1816124592 18.146 99 36 71 2 1832024624 6046928 9853104
17:19:52 6860 8192000000 10680247168 11101429760 1703575264 17.215 95 15 30 1 1713144352 5321504 4247584
17:20:06 5492 8192000000 10715500912 11129933824 1790537840 17.936 100 25 50 1 1803973616 6509376 6926400
17:20:21 7919 8192000000 10684859024 11095101440 1679995184 17.017 93 23 46 0 1692117632 5327792 6794656
17:20:37 4863 8192000000 10694770384 11091148800 1717502720 17.331 97 26 50 1 1729559984 5076192 6981072
17:20:48 10434 8192000000 10704696368 11112660992 1714933456 17.310 96 19 38 1 1725723440 5235584 5554400
17:21:12 7574 8192000000 10709101584 11122073600 1762848288 17.708 98 12 24 0 1771573168 4817568 3907312
17:21:28 4822 8192000000 10726417312 11124387840 1760867840 17.692 98 44 88 3 1779600128 5750192 12982096
17:21:41 9570 8192000000 10693974784 11108802560 1757692208 17.665 98 32 64 3 1772987136 5858144 9436784
17:21:57 6553 8192000000 10715444400 11126267904 1774916688 17.808 99 21 41 2 1786820720 5434592 6469440
17:22:10 19817 8192000000 10718417136 11131060224 1776981872 17.825 99 18 36 0 1788634256 5519616 6132768
17:22:38 60738 8192000000 10736293184 11159879680 1818111584 18.162 100 26 51 2 1830733296 4860432 7761280
17:23:46 14674 8192000000 10750986784 11174117376 1820567200 18.182 99 26 52 0 1833655280 5953920 7134160
17:24:08 6258 8192000000 10765409088 11183570944 1839290032 18.335 100 32 64 0 1856156992 7490480 9376480
17:24:20 8467 8192000000 10763661440 11185041408 1844852608 18.380 100 30 59 1 1859235024 6662928 7719488
17:24:36 5455 8192000000 10755372704 11183300608 1844782832 18.380 100 25 48 0 1857707952 6207184 6717936
17:24:49 10472 8192000000 10751354976 11186315264 1846367808 18.393 100 17 34 1 1856645696 5496672 4781216
17:25:08 8959 8192000000 10764734064 11190616064 1851450032 18.434 100 20 40 2 1862507984 5156576 5901376
17:25:25 9446 8192000000 10770648992 11195916288 1854378960 18.458 100 23 46 0 1866468800 5859440 6230400
17:25:44 11399 8192000000 10767373904 11195961344 1852531120 18.443 100 14 28 1 1861795568 5409488 3854960
17:26:04 8051 8192000000 10774446208 11199377408 1856393360 18.474 100 18 36 0 1866984320 5345712 5245248
17:26:26 6478 8192000000 10775538448 11202064384 1858993264 18.495 100 22 44 3 1870630096 5269776 6367056
17:26:38 13883 8192000000 10773054992 11207065600 1858954656 18.495 100 12 25 2 1868424400 5373152 4096592
17:27:00 8815 8192000000 10787534448 11215519744 1870661568 18.590 100 18 36 0 1881335744 5554560 5119616
17:27:14 17406 8192000000 10829377648 11238658048 1889981584 18.746 100 35 70 1 1905149856 5102576 10065696
17:27:39 37466 8192000000 10825840304 11250880512 1899441072 18.822 100 32 62 1 1915725344 7181616 9102656
17:28:25 52929 8192000000 10837406960 11260768256 1914924864 18.946 100 37 74 1 1933650928 7032288 11693776
17:29:26 70274 8192000000 10862026512 11284254720 1929467008 19.063 100 44 88 1 1950718640 9167200 12084432
17:30:46 14881 8192000000 10877508096 11297796096 1936802704 19.121 100 56 110 1 1962943216 11024032 15116480
17:31:08 16600 8192000000 10863487760 11299303424 1939640256 19.144 100 40 78 4 1962106912 10882784 11583872
17:31:32 16089 8192000000 10879984976 11319156736 1945221904 19.188 100 37 74 4 1970250336 14096432 10932000
17:31:55 30913 8192000000 10893473104 11322863616 1952903440 19.250 100 35 70 1 1975127200 12261104 9962656
17:32:33 8849 8192000000 10907816000 11334377472 1970298400 19.388 100 63 126 1 2002187280 13661520 18227360
17:32:50 5839 8192000000 10916969728 11339841536 1972383536 19.404 100 57 112 2 2003545008 14900384 16261088
17:33:02 12326 8192000000 10918158304 11343228928 1976169632 19.434 100 55 110 0 2006653984 14816176 15668176
17:33:26 3537 8192000000 10911631616 11344482304 1977111632 19.442 100 55 109 0 2006923904 13355680 16456592
17:33:41 13572 8192000000 10925875792 11347521536 1981210288 19.474 100 60 118 3 2013245216 15091136 16943792
17:34:02 6836 8192000000 10918572640 11349630976 1980499984 19.469 100 48 96 1 2009177920 14841024 13836912
17:34:18 8254 8192000000 10926615616 11356680192 1985528656 19.508 100 64 128 1 2019572576 15156800 18887120
17:34:38 5580 8192000000 10930984112 11363287040 1993283312 19.570 100 57 114 3 2025742800 16354288 16105200
17:34:51 14805 8192000000 10932430704 11370618880 1991107824 19.553 100 44 87 1 2019639840 15738896 12793120
17:35:14 14958 8192000000 10913245760 11355258880 1953834160 19.257 98 43 86 2 1983750752 17148784 12767808
17:35:42 7372 8192000000 10936373072 11367755776 1993755712 19.573 100 47 93 0 2022541248 14497584 14287952
17:35:57 8545 8192000000 10932165808 11370156032 1979346000 19.460 99 52 104 0 2015916976 20547616 16023360
17:36:19 4048 8192000000 10939785392 11375439872 1997042416 19.599 100 56 111 0 2031373440 16440752 17890272
17:36:32 5699 8192000000 10944972896 11378032640 1999797568 19.621 100 53 106 1 2033821328 17482080 16541680
17:36:44 6291 8192000000 10934310896 11373481984 1982363136 19.483 99 51 100 1 2016040016 17834144 15842736
17:37:00 2170 8192000000 10951551024 11370741760 1996855152 19.598 100 71 140 3 2034431392 16845952 20730288
17:37:09 3432 8192000000 10945853888 11359072256 1984494672 19.500 99 74 149 0 2023051952 16733376 21823904
17:37:20 1701 8192000000 10951342992 11369295872 1982599136 19.485 99 79 158 1 2023429232 18019040 22811056
17:37:29 3468 8192000000 10953871168 11374866432 2000331104 19.625 100 69 138 1 2040483024 19754336 20397584
17:37:43 2945 8192000000 10956297936 11375198208 2005210112 19.664 100 76 151 1 2046922384 19428000 22284272
17:37:53 4926 8192000000 10954110656 11372580864 1969727936 19.383 98 79 158 2 2017114560 23501536 23885088
17:38:05 9521 8192000000 10946287152 11367800832 1990740256 19.550 100 73 143 1 2032793248 20152064 21900928
17:38:22 5310 8192000000 10940738400 11365466112 1972095888 19.402 99 66 130 0 2012913904 21204112 19613904
17:38:34 5205 8192000000 10949588960 11379703808 1994149840 19.577 100 68 133 1 2041512032 27635712 19726480
17:38:56 8851 8192000000 10945916544 11381440512 1993266576 19.570 100 54 107 0 2034674512 25202192 16205744
17:39:16 8075 8192000000 10950369024 11381358592 1997336896 19.602 100 55 110 2 2040766688 26679536 16750256
17:39:31 7029 8192000000 10939324288 11376201728 1977666816 19.446 99 51 102 2 2021645776 27345856 16633104
17:39:46 13941 8192000000 10943492880 11381723136 1990064736 19.544 100 47 92 1 2031236176 27053488 14117952
17:40:09 9212 8192000000 10953423808 11387367424 1996198224 19.593 100 50 100 0 2038314880 27355056 14761600
17:40:31 11494 8192000000 10922351152 11352129536 1959649968 19.303 100 56 109 3 2005096816 29327680 16119168
17:40:48 1945 8192000000 10934818528 11356188672 1968994896 19.377 100 68 136 0 2024264816 34701136 20568784
17:40:57 2502 8192000000 10948004288 11366768640 1981608400 19.477 100 73 146 0 2035154784 31308928 22237456
17:41:07 1442 8192000000 10957566304 11368370176 1977963952 19.449 100 92 184 4 2037432784 31922832 27546000
17:41:16 3115 8192000000 10930772944 11347771392 1961943280 19.321 99 72 144 0 2014412672 30520272 21949120
17:41:28 1337 8192000000 10952065824 11363418112 1964949344 19.345 99 91 184 3 2022944880 30646368 27349168
17:41:36 2938 8192000000 10895199328 11307442176 1914774192 18.945 98 71 142 2 1968315776 31948992 21592592
17:41:46 8000 8192000000 10917463648 11330252800 1937061328 19.123 99 69 138 1 1992519440 34037264 21420848
17:42:03 5112 8192000000 10898020640 11305865216 1914031168 18.939 98 69 137 1 1970923008 35364016 21527824
17:42:16 10813 8192000000 10910185360 11331584000 1927051712 19.043 99 66 132 1 1985695344 37899744 20743888
17:42:34 2715 8192000000 10918860720 11335663616 1942096384 19.163 100 77 154 2 2002799200 36778496 23924320
17:42:44 11369 8192000000 10898465760 11323162624 1924358240 19.022 99 53 106 1 1978316176 35698368 18259568
17:43:02 3955 8192000000 10911101840 11326324736 1923315344 19.013 99 68 136 1 1977753472 33197184 21240944
17:43:13 4599 8192000000 10916440288 11337981952 1946336288 19.197 100 71 142 1 2002423680 34351344 21736048
17:43:30 1245 8192000000 10909778416 11324747776 1922224704 19.005 99 68 134 0 1978824976 35847232 20753040
17:43:38 3042 8192000000 10912030176 11317657600 1927359952 19.046 99 86 171 2 1991235344 37922064 25953328
17:43:53 6288 8192000000 10911201696 11337584640 1935486192 19.111 100 58 116 0 1997785584 44573488 17725904
17:44:09 7169 8192000000 10912825424 11347636224 1946343696 19.197 100 43 87 0 1996151664 36682800 13125168
17:44:25 5307 8192000000 10923725632 11352969216 1950087552 19.227 100 47 91 2 2002341440 36894848 15359040
17:44:36 3661 8192000000 10914798592 11335352320 1925653120 19.032 99 73 145 1 1983335408 35356864 22325424
17:44:47 4383 8192000000 10916190864 11337977856 1934283232 19.101 100 65 128 0 1999768128 43944432 21540464
17:45:00 9923 8192000000 10865678064 11305799680 1899452912 18.822 98 36 72 0 1948617696 37399248 11765536
17:45:17 7839 8192000000 10903655328 11326054400 1929619056 19.064 100 63 126 1 1987124080 37799904 19705120
17:45:32 1925 8192000000 10911180192 11318583296 1928499008 19.055 100 73 143 1 1989912688 38656912 22756768
17:45:41 3370 8192000000 10914929472 11324448768 1920263696 18.989 99 83 161 3 1982024912 37837568 23923648
17:45:50 2123 8192000000 10885466096 11284647936 1895582112 18.791 99 80 159 5 1959536848 38571904 25382832
17:45:59 2439 8192000000 10908523312 11313319936 1922390240 19.006 100 89 178 1 1989618160 40268016 26959904
17:46:08 9846 8192000000 10908683760 11323097088 1926981888 19.043 100 60 118 1 1986376000 41159824 18234288
17:46:27 2714 8192000000 10924530896 11335950336 1941204960 19.156 100 76 152 1 2007280640 43567088 22508592
17:46:37 2336 8192000000 10945529344 11354001408 1953329568 19.253 100 83 165 0 2023795232 44766288 25699376
17:46:45 3097 8192000000 10960892768 11366498304 1961923136 19.321 100 88 175 2 2033320608 44764576 26632896
17:46:55 2399 8192000000 10936234784 11352309760 1952436336 19.246 100 74 148 1 2014432768 39739408 22257024
17:47:11 4679 8192000000 10927619776 11349282816 1949684176 19.224 100 62 124 1 2010447552 41671856 19091520
17:47:25 11532 8192000000 10908396608 11340324864 1927129440 19.044 99 45 90 5 1979750608 38491392 14129776
17:47:43 4523 8192000000 10913221952 11340492800 1943666000 19.176 100 45 90 2 1995120592 37325072 14129520
17:47:56 6140 8192000000 10901915968 11333636096 1938437824 19.134 100 44 88 0 1989114512 36287376 14389312
17:48:08 6306 8192000000 10910573616 11341123584 1944915072 19.186 100 52 105 1 1997080928 36623440 15542416
17:48:21 2292 8192000000 10928621344 11352236032 1953544624 19.255 100 68 133 1 2011521680 37239840 20737216
17:48:33 2895 8192000000 10936722176 11350601728 1952176928 19.244 100 71 140 1 2012620256 38818464 21624864
17:48:42 6858 8192000000 10933518736 11357016064 1952203440 19.244 100 53 105 0 2010691360 42287664 16200256
17:49:00 2543 8192000000 10947457040 11369410560 1963771696 19.336 100 61 121 0 2026432096 43197632 19462768
17:49:16 10154 8192000000 10945495184 11381059584 1966134896 19.355 100 48 96 0 2027658880 46832400 14691584
17:49:33 12032 8192000000 10921019504 11362123776 1942899600 19.170 99 27 55 2 1998808864 47200448 8708816
17:49:56 11277 8192000000 10928350416 11359227904 1942094496 19.163 99 40 80 0 1998526768 43727488 12704784
17:50:15 3485 8192000000 10940488736 11356299264 1950090928 19.227 100 72 144 1 2021425072 48208208 23125936
17:50:27 11861 8192000000 10907745696 11350028288 1938355472 19.134 100 35 70 2 1999470800 49313248 11802080
17:50:51 6961 8192000000 10933853616 11363028992 1951905248 19.242 100 47 93 2 2015837024 48375280 15556496
17:51:05 13701 8192000000 10937608400 11379458048 1960782448 19.312 100 40 80 0 2024329056 50205984 13340624
17:51:28 17999 8192000000 10939867920 11378843648 1966872320 19.361 100 36 72 0 2024782032 45595984 12313728
17:51:53 18965 8192000000 10933861840 11379359744 1946539552 19.199 99 36 71 3 2008277616 49252672 12485392
17:52:19 25988 8192000000 10920507712 11382865920 1951777680 19.241 100 23 46 0 2007306832 47342224 8186928
17:53:26 12568 8192000000 10939546192 11386896384 1965556176 19.350 100 43 86 0 2030904304 51053440 14294688
17:53:48 13165 8192000000 10934704080 11382263808 1939325728 19.141 99 21 42 0 1999455728 52314064 7815936
17:54:13 38531 8192000000 10927861536 11398750208 1956041200 19.275 100 29 58 1 2029434880 62965296 10428384
17:55:11 32847 8192000000 10933903696 11388329984 1955851248 19.273 100 22 44 0 2016986720 53436464 7699008
17:55:51 28080 8192000000 10918875744 11403259904 1946661568 19.200 100 18 37 1 2007334416 53849520 6823328
17:56:37 29056 8192000000 10898334160 11357093888 1928909184 19.058 99 14 28 2 1975864752 41954720 5000848
17:57:13 65902 8192000000 10868202608 11312119808 1909897456 18.906 98 24 49 0 1924006688 8041632 6067600
17:58:25 29270 8192000000 10895175680 11346509824 1955150480 19.267 100 23 47 3 1977166288 15836736 6179072
17:59:03 26399 8192000000 10917878080 11358253056 1952084656 19.243 99 39 78 2 1976999984 14683904 10231424
17:59:47 33142 8192000000 10899555120 11341193216 1936038448 19.115 98 41 81 3 1959667232 12388304 11240480
18:00:35 102668 8192000000 10919144512 11363966976 1961165408 19.315 100 29 58 1 1982781776 12551136 9065232
18:02:32 74974 8192000000 10892236288 11367944192 1931762752 19.081 98 12 24 0 1947363504 12727200 2873552
18:04:00 67585 8192000000 10910256448 11367874560 1921560560 18.999 97 25 50 1 1940226896 11556784 7109552
18:05:15 81894 8192000000 10903575680 11378601984 1954514864 19.262 99 24 48 2 1979254224 17780064 6959296
18:06:56 31055 8192000000 10896045440 11367677952 1963870288 19.337 100 19 37 2 1987617280 18132144 5614848
18:07:37 4485 8192000000 10892801424 11359727616 1963270784 19.332 100 11 22 2 1979503552 12964400 3268368
18:07:48 9639 8192000000 10895365488 11358072832 1968803184 19.376 100 22 43 1 1983159088 7794288 6561616
18:08:10 29276 8192000000 10902617632 11365269504 1960326528 19.309 99 28 56 1 1976889232 8674912 7887792
18:08:51 35126 8192000000 10906963072 11363258368 1956697072 19.280 99 16 32 1 1970103904 8749712 4657120
18:09:35 22177 8192000000 10918093264 11366756352 1975453056 19.429 100 49 99 0 2001637280 11491824 14692400
18:10:09 37425 8192000000 10901536864 11370319872 1975030976 19.425 100 33 64 2 1997939232 13621584 9286672
18:10:53 36078 8192000000 10891422800 11359195136 1952367648 19.245 99 9 18 1 1965642608 10697984 2576976
18:11:38 133996 8192000000 10908602704 11380154368 1941788752 19.161 98 15 30 0 1959014352 12865168 4360432
18:13:59 32398 8192000000 10894708768 11361808384 1941262672 19.157 98 7 14 1 1955270192 11963792 2043728
18:14:40 59073 8192000000 10887859264 11361173504 1948430400 19.214 99 9 19 0 1964545520 13542880 2572240
18:15:45 63838 8192000000 10897373584 11365834752 1942692240 19.168 99 13 25 1 1958970144 12036208 4241696
18:17:12 62460 8192000000 10895142000 11374239744 1949507392 19.223 99 22 44 0 1970573648 14346112 6720144
18:18:44 45491 8192000000 10914857744 11381399552 1971629488 19.398 100 36 72 2 2000504512 18612864 10262160
18:19:36 23052 8192000000 10891944832 11371225088 1973820016 19.416 100 18 36 2 1990787648 12119504 4848128
18:20:08 60322 8192000000 10896430736 11367698432 1956464160 19.278 99 16 29 2 1971851376 10736496 4650720
18:21:49 71822 8192000000 10857417696 11341070336 1851200160 18.432 94 15 30 1 1864739136 9497840 4041136
18:23:08 28693 8192000000 10853199552 11325538304 1923311920 19.013 99 4 8 0 1932651776 8300272 1039584
18:23:44 47390 8192000000 10890247920 11349204992 1915916816 18.954 98 29 58 1 1931853056 7703472 8232768
18:24:40 19311 8192000000 10881667088 11347320832 1942432192 19.166 99 34 68 1 1963383328 11504544 9446592
18:25:13 42974 8192000000 10875682944 11333517312 1826802704 18.233 93 31 62 3 1851841536 16016096 9022736
18:26:05 45122 8192000000 10875025184 11336364032 1888890672 18.737 98 16 32 1 1918069024 24611296 4567056
18:27:05 48119 8192000000 10881845456 11363532800 1934886928 19.106 100 12 24 0 1972470880 34164304 3419648
18:28:00 78400 8192000000 10853051408 11308077056 1729625808 17.432 89 12 24 0 1748952368 16062096 3264464
18:29:25 75118 8192000000 10869741568 11338563584 1866112080 18.553 97 13 26 0 1884188896 14614944 3461872
18:30:46 52503 8192000000 10863891104 11345825792 1898237776 18.812 98 20 40 3 1921331216 17360368 5733072
18:32:38 24959 8192000000 10893080592 11342815232 1920163968 18.988 98 34 69 2 1944294832 14967136 9163728
18:33:12 22953 8192000000 10908283888 11355136000 1926112800 19.036 98 51 102 2 1954496656 14720960 13662896
18:33:43 31526 8192000000 10906261488 11369881600 1953986272 19.258 100 35 70 0 1985101008 21377648 9737088
18:34:23 22705 8192000000 10895680096 11371786240 1939325728 19.141 99 17 34 0 1963498368 19059312 5113328
18:34:52 90392 8192000000 10889532208 11376623616 1883964704 18.697 96 12 24 0 1908658160 20882672 3810784
18:36:29 73809 8192000000 10871127232 11328167936 1875693984 18.630 96 34 67 1 1895254608 10014960 9545664
18:37:49 128111 8192000000 10882335296 11354034176 1905649536 18.872 98 28 56 0 1928085648 14584240 7851872
18:41:09 13002 8192000000 10869048336 11317121024 1919087424 18.980 98 61 123 1 1944815200 8552112 17175664
18:41:31 39184 8192000000 10873584000 11338223616 1927105520 19.044 99 26 49 2 1943916960 9979728 6831712
18:42:29 81586 8192000000 10889408144 11359174656 1924223280 19.021 98 18 36 1 1941008224 11363616 5421328
18:44:04 71049 8192000000 10913548336 11373821952 1945333040 19.189 99 20 40 1 1971949952 20835328 5781584
18:45:22 73631 8192000000 10885222528 11366027264 1945314640 19.189 99 23 46 0 1968682976 16294736 7073600
18:46:41 42822 8192000000 10871342752 11347685376 1917769728 18.969 98 13 26 0 1941340720 18928848 4642144
18:47:31 51344 8192000000 10869576960 11359715328 1932741136 19.089 99 4 8 1 1950274240 16613152 919952
18:48:28 91498 8192000000 10889442208 11370741760 1956189808 19.276 100 13 27 1 1977196240 17733024 3273408
18:50:19 52669 8192000000 10902697744 11384385536 1980635440 19.470 100 27 53 0 1999372352 11547104 7189808
18:51:25 58939 8192000000 10880279264 11363196928 1892516240 18.766 96 21 42 0 1912444848 13966848 5961760
18:52:42 33701 8192000000 10892161744 11359195136 1963097264 19.331 100 26 50 2 1983439296 13270448 7071584
18:53:31 20351 8192000000 10911697360 11372736512 1954700208 19.264 99 33 66 1 1972308720 8874656 8733856
18:53:57 53680 8192000000 10898073792 11378098176 1949505056 19.223 99 25 50 1 1970517488 13574672 7437760
18:55:03 62814 8192000000 10894603904 11359391744 1911797984 18.921 97 27 53 2 1929133104 9861216 7473904
18:56:13 35396 8192000000 10897235376 11357577216 1946960576 19.202 99 31 64 0 1965277728 9716256 8600896
18:56:56 62618 8192000000 10920246016 11390160896 1956031232 19.274 99 18 36 1 1976193232 15474208 4687792
18:58:04 73994 8192000000 10897822688 11353686016 1873088176 18.609 95 7 14 0 1888103776 13624704 1390896
18:59:25 12751 8192000000 10916218720 11372933120 1977075184 19.442 100 52 104 1 1999477568 7720080 14682304
18:59:46 111612 8192000000 10920366592 11375652864 1925742128 19.033 97 28 56 1 1943283712 10326304 7215280
19:01:44 83412 8192000000 10904219584 11383406592 1943718480 19.176 98 23 46 2 1960200176 10193424 6288272
19:03:45 46964 8192000000 10888491440 11367895040 1956123072 19.275 99 28 54 1 1976776912 13318912 7334928
19:05:02 57500 8192000000 10889231632 11372142592 1951308832 19.237 99 11 22 0 1969041216 14711648 3020736
19:06:07 51242 8192000000 10882573776 11368882176 1931623696 19.080 98 8 16 0 1943668544 9837296 2207552
19:07:05 79038 8192000000 10903121280 11383468032 1978611248 19.454 100 16 32 1 2003021024 18870928 5538848
19:08:37 70854 8192000000 10888026592 11370418176 1921261216 18.997 97 12 23 0 1935557760 10829056 3467488
19:09:55 45940 8192000000 10888161968 11346780160 1874222176 18.618 95 17 33 0 1885177424 6536432 4418816
19:10:48 38019 8192000000 10905409520 11376107520 1972250272 19.403 100 32 64 1 1991134736 9797888 9086576
19:11:32 42419 8192000000 10917991888 11377500160 1962748976 19.328 99 37 73 2 1983226272 8900192 11577104
19:12:36 38786 8192000000 10863531504 11337949184 1901656880 18.840 97 19 38 0 1919196480 12251824 5287776
19:13:50 50166 8192000000 10856288224 11311292416 1854405792 18.458 95 27 54 0 1872594240 10364096 7824352
19:14:48 66860 8192000000 10819506576 11295907840 1774607600 17.805 92 16 32 0 1790066336 11018208 4440528
19:16:01 72505 8192000000 10849653776 11316903936 1880199712 18.667 98 11 23 1 1898480016 14617488 3662816
19:17:23 79912 8192000000 10873146656 11333775360 1898494064 18.814 98 12 24 0 1912043696 10091232 3458400
19:18:53 31526 8192000000 10851029344 11304386560 1855674784 18.468 96 24 48 0 1870591904 8266480 6650640
19:19:33 32912 8192000000 10887412032 11334049792 1935369792 19.110 100 45 90 1 1958943664 10879296 12694576
19:20:15 15028 8192000000 10906014464 11346853888 1946567600 19.199 100 51 102 1 1972911024 12375552 13967872
19:20:39 71140 8192000000 10876869424 11361996800 1885049520 18.706 97 14 28 0 1910357088 21407456 3900112
19:21:56 79876 8192000000 10855441984 11336491008 1912703376 18.928 99 5 9 1 1928299664 14383120 1213168
19:23:26 60273 8192000000 10878068944 11341119488 1941868832 19.162 100 25 50 0 1957465472 8832400 6764240
19:24:35 81325 8192000000 10858425984 11348148224 1913154096 18.932 98 12 23 0 1929749040 13063904 3531040
19:26:03 33745 8192000000 10863136496 11353702400 1946350320 19.197 100 4 8 0 1959430048 12037424 1042304
19:26:47 14831 8192000000 10857167312 11340521472 1925369776 19.030 99 4 8 0 1937810720 11211520 1229424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 29-01-2021 19:29:46 to 29-01-2021 19:30:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-01-2021 19:30:20 to 29-01-2021 19:30:22.

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          250224
MON$OLDEST_ACTIVE               250730
MON$OLDEST_SNAPSHOT             250730
MON$NEXT_TRANSACTION            250730
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                       2051488
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

29.01.21 19:30:23. 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-01-29 19:30:25 No severe PSQL-related problems occured
29.01.21 19:30:27. End of report.