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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17466548 kB
MemAvailable 31481460 kB
Buffers 0 kB
Cached 14254860 kB
SwapCached 2820 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.7
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 2020-11-09 22:27:03
DTS_END                         2020-11-09 22:27:03.2220
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59306
TRN_ID                          239844
ATT_ID                          670
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: 9400.95 21063 1128114
customer order: creation 173.71 359 20845
customer order: refuse 15.28 372 1834
order to supplier: creation 45.75 1279 5490
order to supplier: removal 3.66 93986 439
invoice (draft): creation 45.61 3316 5473
invoice (draft): removal 53.14 727 6377
invoice accept: apply 42.61 18674 5113
invoice accept: cancel 48.27 769 5792
customer reserve: creation 3935.06 185 472207
customer reserve: removal 4740.06 56 568807
realization accept: apply 83.92 205 10070
realization accept: cancel 81.13 108 9736
payment from customer: creation 61.08 127 7329
payment from customer: removal 5.91 114 709
payment to supplier: creation 49.27 146 5912
payment to supplier: removal 3.54 66 425
service: total inventory turnovers 5.00 1051 600
service: total monetary turnovers 7.13 34 855
service: aggregate perf. data 0.81 19638 97
service: refresh index statistics 0.03 280057 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-11-2020 22:28:30 to 09-11-2020 22:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7002
TEST_TIME 2 5249
TEST_TIME 3 3957
TEST_TIME 4 4202
TEST_TIME 5 5466
TEST_TIME 6 6197
TEST_TIME 7 6644
TEST_TIME 8 6856
TEST_TIME 9 6722
TEST_TIME 10 6936
TEST_TIME 11 6819
TEST_TIME 12 6825
TEST_TIME 13 7095
TEST_TIME 14 7507
TEST_TIME 15 7601
TEST_TIME 16 7894
TEST_TIME 17 8578
TEST_TIME 18 8382
TEST_TIME 19 8672
TEST_TIME 20 9349
TEST_TIME 21 9699
TEST_TIME 22 9724
TEST_TIME 23 9449
TEST_TIME 24 9922
TEST_TIME 25 10424
TEST_TIME 26 10920
TEST_TIME 27 10845
TEST_TIME 28 10705
TEST_TIME 29 11089
TEST_TIME 30 10850
TEST_TIME 31 10724
TEST_TIME 32 10735
TEST_TIME 33 10634
TEST_TIME 34 10405
TEST_TIME 35 10315
TEST_TIME 36 10248
TEST_TIME 37 10062
TEST_TIME 38 10116
TEST_TIME 39 10000
TEST_TIME 40 9896
TEST_TIME 41 10049
TEST_TIME 42 10100
TEST_TIME 43 10107
TEST_TIME 44 9983
TEST_TIME 45 9827
TEST_TIME 46 9728
TEST_TIME 47 9889
TEST_TIME 48 9967
TEST_TIME 49 10035
TEST_TIME 50 9961
TEST_TIME 51 10000
TEST_TIME 52 9966
TEST_TIME 53 10023
TEST_TIME 54 9982
TEST_TIME 55 10019
TEST_TIME 56 10078
TEST_TIME 57 10168
TEST_TIME 58 10151
TEST_TIME 59 10135
TEST_TIME 60 10178
TEST_TIME 61 10031
TEST_TIME 62 9980
TEST_TIME 63 9887
TEST_TIME 64 9823
TEST_TIME 65 9917
TEST_TIME 66 9836
TEST_TIME 67 9767
TEST_TIME 68 9733
TEST_TIME 69 9683
TEST_TIME 70 9605
TEST_TIME 71 9640
TEST_TIME 72 9625
TEST_TIME 73 9583
TEST_TIME 74 9565
TEST_TIME 75 9527
TEST_TIME 76 9660
TEST_TIME 77 9690
TEST_TIME 78 9752
TEST_TIME 79 9755
TEST_TIME 80 9717
TEST_TIME 81 9846
TEST_TIME 82 9817
TEST_TIME 83 9941
TEST_TIME 84 9909
TEST_TIME 85 9833
TEST_TIME 86 9790
TEST_TIME 87 9722
TEST_TIME 88 9708
TEST_TIME 89 9699
TEST_TIME 90 9638
TEST_TIME 91 9585
TEST_TIME 92 9550
TEST_TIME 93 9502
TEST_TIME 94 9511
TEST_TIME 95 9646
TEST_TIME 96 9632
TEST_TIME 97 9615
TEST_TIME 98 9618
TEST_TIME 99 9677
TEST_TIME 100 9659
TEST_TIME 101 9678
TEST_TIME 102 9655
TEST_TIME 103 9666
TEST_TIME 104 9640
TEST_TIME 105 9674
TEST_TIME 106 9676
TEST_TIME 107 9677
TEST_TIME 108 9674
TEST_TIME 109 9639
TEST_TIME 110 9577
TEST_TIME 111 9601
TEST_TIME 112 9550
TEST_TIME 113 9525
TEST_TIME 114 9532
TEST_TIME 115 9504
TEST_TIME 116 9485
TEST_TIME 117 9460
TEST_TIME 118 9454
TEST_TIME 119 9482
TEST_TIME 120 9404

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-11-2020 22:28:34 to 09-11-2020 22:28:37.

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 1565392 1565392 0 0.00 0 18856 6 0 0
doc_list_biud 1565391 1565391 0 0.00 0 52339 26 0 0
sp_add_invoice_to_stock 5255 5113 142 2.70 32 199872 18674 0 142
sp_cancel_adding_invoice 5792 5792 0 0.00 5 57868 769 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 10832 372 0 0
sp_cancel_customer_reserve 568807 568807 0 0.00 1 34168 57 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 3 7726 115 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 4603 66 0 0
sp_cancel_supplier_invoice 6382 6377 5 0.07 2 22640 727 0 5
sp_cancel_supplier_order 439 439 0 0.00 5 971021 93987 0 0
sp_cancel_write_off 9736 9736 0 0.00 1 18168 109 0 0
sp_client_order 20845 20845 0 0.00 3 33322 360 0 0
sp_customer_reserve 472207 472207 0 0.00 0 36207 185 0 0
sp_fill_shopping_cart 31798 31798 0 0.00 1 10819 34 0 0
sp_fill_shopping_cart_clo_res 472202 472202 0 0.00 0 23789 13 0 0
sp_get_clo_for_invoice 5106 5106 0 0.00 0 23921 271 0 0
sp_kill_cost_storno 16662 16662 0 0.00 0 8852 56 0 0
sp_kill_qstorno_ret_qs2qd 1154166 1154166 0 0.00 0 33824 30 0 0
sp_kill_qty_storno 608160 608160 0 0.00 0 52339 67 0 0
sp_lock_selected_doc 21096 21096 0 0.00 0 7081 5 0 0
sp_make_cost_storno 28417 28417 0 0.00 0 15881 58 0 0
sp_multiply_rows_for_pdistr 28417 28417 0 0.00 0 9857 31 0 0
sp_multiply_rows_for_qdistr 20845 20845 0 0.00 0 27595 142 0 0
sp_pay_from_customer 7329 7329 0 0.00 4 14410 128 0 0
sp_pay_to_supplier 5912 5912 0 0.00 5 15891 147 0 0
sp_payment_common 13241 13241 0 0.00 1 11299 38 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 10783 345 0 0
sp_qd_handle_on_invoice_upd_sts 10898 10898 0 0.00 0 52337 353 0 0
sp_qd_handle_on_reserve_upd_sts 10069 10069 0 0.00 0 28128 71 0 0
sp_reserve_write_off 10070 10070 0 0.00 7 28175 205 0 0
sp_supplier_invoice 5473 5473 0 0.00 5 87025 3317 0 0
sp_supplier_order 5490 5490 0 0.00 5 41258 1280 0 0
srv_aggregate_perf_data 97 97 0 0.00 3443 144904 19639 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 945 136999 30383 0 0
srv_find_qd_qs_mism 1079593 1079593 0 0.00 0 18856 5 0 0
srv_make_invnt_saldo 600 600 0 0.00 25 32953 1052 0 0
srv_make_money_saldo 855 855 0 0.00 0 10801 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 131894 418954 280057 0 0
t$perf-abend:sp_add_invoice_to_stock 142 142 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5113 5113 0 0.00 0 34825 182 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 9723 152 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 8289 22 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 3260 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 2715 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 826 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 873 14 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 16845 1431 0 0
t$perf-norm:sp_cancel_write_off 984 984 0 0.00 0 7762 14 0 0
t$perf-norm:sp_client_order 20845 20845 0 0.00 0 14183 21 0 0
t$perf-norm:sp_customer_reserve 1079 1079 0 0.00 0 558 5 0 0
t$perf-norm:sp_pay_from_customer 7329 7329 0 0.00 0 29106 20 0 0
t$perf-norm:sp_pay_to_supplier 5912 5912 0 0.00 0 5099 11 0 0
t$perf-norm:sp_reserve_write_off 10070 10070 0 0.00 0 7327 12 0 0
t$perf-norm:sp_supplier_invoice 5473 5473 0 0.00 0 4809 15 0 0
t$perf-norm:sp_supplier_order 5490 5490 0 0.00 0 4365 18 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 18 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 250 4 0 0
t$perf-norm:srv_make_invnt_saldo 600 600 0 0.00 0 5119 31 0 0
t$perf-norm:srv_make_money_saldo 855 855 0 0.00 0 3184 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 18 6 0 0
v_add_invoice_to_stock 10494 10210 284 2.70 0 6165 19 0 284
v_all_customers 38150 38150 0 0.00 0 16 1 0 0
v_all_suppliers 30378 30378 0 0.00 0 14 1 0 0
v_all_wares 41690 41690 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 324 6 0 0
v_cancel_client_order 3668 3668 0 0.00 0 3400 6 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 2895 8 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 2565 9 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 237 3 0 0
v_cancel_supplier_invoice 814 804 10 1.22 0 3245 25 0 10
v_cancel_supplier_order 878 878 0 0.00 0 1794 9 0 0
v_cancel_write_off 1968 1968 0 0.00 0 4980 15 0 0
v_max_id_clo_ord 5486 5486 0 0.00 0 236 1 0 0
v_max_id_clo_res 1079 1079 0 0.00 0 4210 23 0 0
v_max_id_ord_sup 5466 5466 0 0.00 0 3913 4 0 0
v_max_non_paid_invoice 1673 1673 0 0.00 0 900 3 0 0
v_max_non_paid_realizn 3819 3819 0 0.00 0 3151 6 0 0
v_min_id_clo_ord 5485 5485 0 0.00 0 3145 6 0 0
v_min_id_clo_res 1079 1079 0 0.00 0 6575 18 0 0
v_min_id_ord_sup 5466 5466 0 0.00 0 2656 3 0 0
v_min_non_paid_invoice 5911 5911 0 0.00 0 11296 27 0 0
v_min_non_paid_realizn 7329 7329 0 0.00 0 9892 25 0 0
v_our_firm 10560 10560 0 0.00 0 15 1 0 0
v_reserve_write_off 20138 20138 0 0.00 0 5148 8 0 0
x_lock_depdocs_on_canc_invoice 11767 11767 0 0.00 0 26258 138 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 6300 327 0 0
x_make_qstorno_1000_1200 5490 5490 0 0.00 1 41248 1201 0 0
x_make_qstorno_1200_2000 5473 5473 0 0.00 3 87014 3201 0 0
x_make_qstorno_2100_3300 472207 472207 0 0.00 0 33551 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2020 22:28:38 to 09-11-2020 22:28:42.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 6820 8192000000 10114168256 10409115648 834940464 9.249 68 50 101 0 855018208 2370560 17707184
19:57:29 43559 8192000000 10332504944 10648412160 1362230384 14.257 100 89 178 0 1396070624 5066544 28773696
19:58:24 19226 8192000000 10378850480 10701008896 1433762208 14.895 100 87 173 2 1468684432 6589952 28332272
19:58:53 32909 8192000000 10416173568 10746183680 1456583712 15.096 100 86 171 0 1491998160 7581744 27832704
19:59:37 16285 8192000000 10434561168 10770644992 1492315968 15.409 100 85 170 1 1528477120 8795728 27365424
20:00:07 18402 8192000000 10457519472 10792681472 1513960672 15.598 100 93 186 2 1553027616 9524864 29542080
20:00:37 23736 8192000000 10474031904 10814287872 1529176640 15.730 100 87 174 1 1567042544 10467344 27398560
20:01:11 22038 8192000000 10496544096 10844221440 1546133136 15.877 100 79 158 0 1581545504 10699936 24712432
20:01:46 15001 8192000000 10526830320 10878918656 1582752800 16.192 100 84 168 2 1619449280 11117824 25578656
20:02:12 14083 8192000000 10549460944 10905169920 1607872368 16.407 100 78 156 1 1642757808 11416768 23468672
20:02:35 20829 8192000000 10572655008 10932834304 1631020144 16.604 100 77 154 1 1665758592 11220784 23517664
20:03:04 10849 8192000000 10592727216 10953777152 1649612208 16.761 100 80 159 0 1685569680 12530688 23426784
20:03:31 10102 8192000000 10599264960 10964553728 1666783216 16.906 100 87 173 0 1704122000 12514096 24824688
20:03:49 12212 8192000000 10631964160 10999103488 1679718192 17.015 100 73 146 0 1712512816 11378448 21416176
20:04:10 8476 8192000000 10641011504 11012689920 1702090736 17.203 100 76 150 2 1735408400 11535520 21782144
20:04:27 9102 8192000000 10643757616 11021418496 1710544672 17.273 100 75 150 0 1744948144 12557152 21846320
20:04:44 5829 8192000000 10665147392 11042889728 1726949600 17.410 100 73 146 1 1760867536 11883984 22033952
20:04:58 6687 8192000000 10682413760 11063037952 1747107088 17.578 100 77 154 2 1785824976 17052256 21665632
20:05:12 7311 8192000000 10690477136 11069865984 1753162384 17.628 100 77 154 0 1787183968 12630992 21390592
20:05:26 5164 8192000000 10704773408 11084038144 1764738064 17.724 100 83 166 2 1802025088 13661328 23625696
20:05:38 11279 8192000000 10697968144 11085512704 1767914224 17.750 100 77 154 1 1803354912 13856288 21584400
20:05:56 6484 8192000000 10717648144 11101851648 1771058016 17.776 100 79 158 1 1807578896 14192704 22328176
20:06:10 3285 8192000000 10733614960 11119771648 1793546064 17.961 100 74 149 1 1827563872 12920080 21097728
20:06:20 3543 8192000000 10753094464 11137679360 1806685184 18.069 100 81 164 2 1842148736 11469920 23993632
20:06:30 3495 8192000000 10755801856 11147165696 1813748736 18.127 100 79 158 2 1846700464 11036976 21914752
20:06:40 2577 8192000000 10756247392 11147816960 1823175824 18.204 100 81 160 2 1858216784 12178752 22862208
20:06:49 3111 8192000000 10763218304 11156156416 1834407248 18.295 100 79 159 1 1867846560 10898304 22541008
20:06:59 2923 8192000000 10781160352 11169058816 1840650544 18.346 100 85 168 1 1877095856 12838288 23607024
20:07:08 3115 8192000000 10782790416 11173650432 1845017360 18.382 100 81 162 1 1880332720 12524304 22791056
20:07:18 2047 8192000000 10795143808 11181473792 1851075088 18.431 100 91 180 1 1889438896 13990064 24373744
20:07:26 2112 8192000000 10793965584 11181711360 1851891936 18.437 100 84 168 1 1889886624 14400672 23594016
20:07:35 2062 8192000000 10799917136 11188604928 1855342416 18.466 100 87 175 1 1894128816 14706256 24080144
20:07:43 2260 8192000000 10793321008 11183706112 1860399600 18.507 100 91 184 0 1899679248 13969152 25310496
20:07:52 1967 8192000000 10798827984 11187421184 1858143824 18.488 100 92 182 2 1896989312 13247664 25597824
20:08:01 1768 8192000000 10808265632 11195371520 1865179472 18.545 100 96 191 1 1903899568 12279040 26441056
20:08:09 2602 8192000000 10806625584 11197132800 1864485056 18.540 100 88 175 0 1903264784 12323888 26455840
20:08:18 2026 8192000000 10807688320 11196223488 1867381440 18.563 100 86 171 3 1904394192 12528720 24484032
20:08:27 13291 8192000000 10805277440 11195437056 1867119776 18.561 100 70 139 2 1897665632 12235664 18310192
20:08:46 5537 8192000000 10822672448 11207917568 1870508640 18.588 100 94 188 2 1911040176 13972400 26559136
20:08:58 2369 8192000000 10810741584 11205251072 1869152384 18.577 100 82 164 0 1905255680 13139552 22963744
20:09:08 9398 8192000000 10795162944 11201716224 1868459232 18.572 100 56 111 2 1894302016 10252928 15589856
20:09:24 5940 8192000000 10780246864 11197906944 1869643904 18.581 100 42 85 2 1889486992 8330976 11512112
20:09:37 9864 8192000000 10779633488 11197718528 1868724672 18.574 100 46 93 3 1888574096 7349584 12499840
20:09:55 49614 8192000000 10792373616 11209211904 1870286864 18.587 100 42 83 4 1888538624 4893504 13358256
20:10:51 1757 8192000000 10820181552 11225214976 1883089888 18.690 100 80 160 1 1916413536 9919376 23404272
20:11:06 7601 8192000000 10794065712 11218755584 1879555824 18.662 100 34 68 1 1895888464 6227072 10105568
20:11:21 5457 8192000000 10807648080 11225235456 1883199616 18.691 100 30 60 1 1898545328 6664416 8681296
20:11:33 6027 8192000000 10787230112 11224879104 1885246368 18.707 100 27 54 1 1899813200 6851472 7715360
20:11:48 4071 8192000000 10807462272 11231776768 1888266336 18.732 100 35 70 0 1904873664 6424640 10182688
20:12:00 5036 8192000000 10806942240 11235303424 1891693872 18.759 100 39 79 2 1909480864 5658768 12128224
20:12:13 3362 8192000000 10822334688 11238387712 1894389600 18.781 100 40 79 1 1913923952 8787296 10747056
20:12:22 8867 8192000000 10810172976 11238658048 1891473104 18.758 100 29 56 3 1906376240 6671008 8232128
20:12:38 5958 8192000000 10810696432 11236241408 1891322464 18.756 100 25 50 2 1908629040 10053760 7252816
20:12:50 6888 8192000000 10815469360 11242614784 1892537520 18.766 100 25 51 1 1909865776 10727600 6600656
20:13:06 8709 8192000000 10814565424 11240611840 1894922208 18.785 100 22 44 3 1907581856 6365984 6293664
20:13:28 6259 8192000000 10814494928 11250216960 1902546928 18.847 100 20 40 1 1913637856 5603184 5487744
20:13:40 9865 8192000000 10805389024 11244384256 1899390704 18.821 100 17 34 1 1911065008 6367024 5307280
20:13:58 11517 8192000000 10802733312 11243802624 1899849824 18.825 100 20 40 1 1911780224 5727904 6202496
20:14:17 14501 8192000000 10820226816 11249647616 1903313040 18.853 100 31 62 1 1919424320 7904976 8206304
20:14:40 65051 8192000000 10821624288 11253112832 1906209024 18.876 100 32 64 1 1921327904 6270448 8848432
20:15:52 7988 8192000000 10804229312 11230769152 1848969808 18.414 97 23 44 2 1860191952 4933024 6289120
20:16:06 9176 8192000000 10808234336 11243134976 1898764400 18.816 100 21 41 2 1910998000 6041696 6191904
20:16:22 7003 8192000000 10808249504 11244269568 1885532416 18.710 99 18 37 1 1895632496 5528480 4571600
20:16:37 7242 8192000000 10825432144 11251306496 1902750368 18.848 100 29 57 4 1916802128 5592608 8459152
20:16:54 7686 8192000000 10814418496 11244826624 1887357584 18.724 99 28 56 1 1901897600 6359552 8180464
20:17:09 3537 8192000000 10828652096 11251552256 1870851632 18.591 98 39 77 2 1889032992 7153424 11027936
20:17:19 5852 8192000000 10802366112 11231793152 1885021920 18.706 100 20 40 1 1896262432 5701856 5538656
20:17:31 7451 8192000000 10801347328 11236724736 1891676368 18.759 100 21 42 2 1903215232 5858080 5680784
20:17:47 10560 8192000000 10773570816 11196325888 1821838816 18.193 97 18 36 1 1832289408 5410400 5040192
20:18:05 7045 8192000000 10775773104 11197665280 1832128656 18.277 98 31 62 2 1847695792 5974352 9592784
20:18:18 7170 8192000000 10753528032 11178033152 1806874512 18.070 98 22 44 3 1819354864 5719904 6760448
20:18:37 5796 8192000000 10771978672 11191808000 1846120688 18.391 100 20 40 0 1857257504 5415472 5721344
20:18:48 12279 8192000000 10774296320 11197284352 1828008016 18.243 98 29 58 0 1842276112 5118112 9149984
20:19:12 12497 8192000000 10730632784 11152601088 1764252000 17.720 96 21 42 2 1776193120 5886144 6054976
20:19:30 50096 8192000000 10720730624 11105665024 1676528736 16.988 92 63 127 1 1699944032 4896864 18518432
20:20:27 9846 8192000000 10671655200 11089367040 1659412416 16.844 93 13 26 0 1668017280 4980144 3624720
20:20:45 7393 8192000000 10698623088 11109482496 1728848288 17.426 96 33 67 0 1743081616 5036432 9196896
20:20:58 6452 8192000000 10702929952 11116507136 1754281520 17.637 98 32 64 1 1770240048 6636912 9321616
20:21:11 4862 8192000000 10686489216 11102588928 1778157456 17.834 100 53 106 3 1802737424 9345232 15234736
20:21:26 7431 8192000000 10707854752 11116257280 1772148032 17.785 99 45 90 2 1793400976 7202672 14050272
20:21:41 4727 8192000000 10708022448 11114221568 1759720768 17.682 98 30 62 2 1774045904 5241840 9083296
20:21:52 10942 8192000000 10701526464 11117142016 1783222320 17.876 99 35 70 3 1799801024 6504144 10074560
20:22:11 9576 8192000000 10722493568 11137253376 1789863968 17.931 99 17 34 1 1800968592 5998224 5106400
20:22:32 7549 8192000000 10730377776 11151278080 1815477056 18.141 100 24 48 3 1827591712 4997936 7116720
20:22:46 7242 8192000000 10719817136 11142201344 1799220624 18.008 99 33 66 3 1815489744 6238368 10030752
20:23:00 8838 8192000000 10737214944 11150356480 1812623984 18.117 100 23 46 1 1824236912 5230880 6382048
20:23:15 11023 8192000000 10750744448 11160301568 1827386416 18.238 100 28 54 4 1841070224 5167312 8516496
20:23:32 8623 8192000000 10745729008 11168243712 1832442304 18.279 100 30 59 1 1846774880 5582256 8750320
20:23:49 19289 8192000000 10769654560 11177132032 1830698064 18.265 100 26 51 1 1843291120 6029936 6563120
20:24:15 59474 8192000000 10751284848 11180269568 1846630128 18.395 100 32 64 2 1861979552 5153600 10195824
20:25:21 12245 8192000000 10758356384 11189096448 1850639152 18.427 100 28 56 0 1864390976 6409344 7342480
20:25:40 5004 8192000000 10773985360 11195637760 1854058816 18.455 100 29 56 1 1866938720 5051648 7828256
20:25:54 6011 8192000000 10768601472 11197128704 1855126928 18.464 100 20 40 0 1867141136 6163856 5850352
20:26:07 8660 8192000000 10774091504 11199270912 1859994192 18.503 100 24 48 0 1872609440 5293024 7322224
20:26:22 9136 8192000000 10782657968 11207172096 1866925504 18.559 100 31 62 0 1882582160 7194224 8462432
20:26:38 9348 8192000000 10788611504 11212640256 1867720704 18.566 100 20 39 2 1878862992 5796624 5345664
20:26:56 8751 8192000000 10801318192 11218350080 1872913920 18.608 100 30 59 0 1887207744 5287920 9005904
20:27:12 37004 8192000000 10817268160 11238920192 1899501808 18.822 100 51 101 2 1920514400 6056976 14955616
20:27:57 8573 8192000000 10827955696 11247636480 1901229536 18.836 100 37 74 2 1918625872 7252288 10144048
20:28:13 8005 8192000000 10841570752 11256553472 1910942240 18.914 100 48 97 0 1933261008 7705936 14612832
20:28:29 10168 8192000000 10853099600 11267825664 1918436944 18.974 100 51 102 1 1941841872 8679648 14725280
20:28:51 17868 8192000000 10859692880 11280371712 1925330080 19.030 100 48 96 3 1948768096 10116480 13321536
20:29:19 21243 8192000000 10864462544 11289440256 1932332048 19.086 100 50 99 1 1958179312 10920784 14926480
20:29:52 118589 8192000000 10872205280 11304861696 1939769984 19.145 100 48 96 1 1965938944 12301008 13867952
20:31:58 29811 8192000000 10868249952 11310645248 1940386656 19.150 100 29 58 2 1965117568 15989936 8740976
20:32:37 34802 8192000000 10877952896 11320438784 1951817472 19.241 100 28 56 3 1978538832 18337408 8383952
20:33:20 9467 8192000000 10909107456 11335581696 1961319248 19.317 100 49 98 1 1992038368 16300192 14418928
20:33:37 3181 8192000000 10925952128 11338006528 1969240720 19.379 100 69 135 0 2008123568 18349440 20533408
20:33:49 3266 8192000000 10920034368 11343704064 1971163504 19.395 100 66 132 1 2012029552 23264560 17601488
20:34:02 6780 8192000000 10925963200 11345215488 1972057408 19.402 100 58 115 1 2006086032 17745728 16282896
20:34:16 18306 8192000000 10913714864 11336163328 1959015696 19.298 99 60 117 1 1998344480 21102448 18226336
20:34:45 1921 8192000000 10925434352 11350622208 1964865200 19.345 99 71 142 0 2006243600 19981408 21396992
20:34:54 9912 8192000000 10928993360 11354927104 1977628832 19.446 100 64 127 1 2014776208 18802224 18345152
20:35:15 2047 8192000000 10932919968 11358593024 1969223056 19.379 99 72 143 3 2010043664 20289744 20530864
20:35:25 2861 8192000000 10936140048 11357544448 1964717648 19.344 99 79 155 2 2007460240 20656512 22086080
20:35:34 2177 8192000000 10938203200 11353333760 1983627680 19.493 100 82 161 2 2029934816 23091696 23215440
20:35:43 2963 8192000000 10942027808 11362455552 1988115952 19.529 100 78 156 0 2034454688 23880400 22458336
20:35:54 8561 8192000000 10942305280 11355881472 1983459280 19.492 100 77 156 1 2027936432 22477104 22000048
20:36:19 1818 8192000000 10954168768 11370168320 1990678544 19.549 100 76 152 2 2041132064 28920384 21533136
20:36:28 9610 8192000000 10947986992 11369766912 1992445168 19.563 100 68 137 2 2039860208 26954752 20460288
20:36:44 11455 8192000000 10949677312 11374174208 1993571760 19.572 100 66 132 2 2037420704 24249904 19599040
20:37:08 14790 8192000000 10961546816 11386195968 1996598688 19.596 100 58 116 1 2038307568 24778320 16930560
20:37:30 8199 8192000000 10955196576 11386109952 2005544512 19.666 100 61 122 0 2045451584 22669024 17238048
20:37:48 9788 8192000000 10965226368 11396407296 2009396432 19.697 100 61 119 1 2049369168 22497536 17475200
20:38:05 5525 8192000000 10958412992 11390148608 2004936720 19.662 100 57 114 0 2046138000 24203520 16997760
20:38:21 4255 8192000000 10941310256 11369824256 1966595408 19.358 98 62 124 1 2009902672 25091120 18216144
20:38:32 4999 8192000000 10951982304 11375497216 1989879200 19.543 100 71 138 1 2036995600 26623456 20492944
20:38:46 6758 8192000000 10966355072 11388964864 2002879040 19.645 100 78 153 2 2053327008 27313056 23134912
20:38:59 1768 8192000000 10967170864 11391385600 2004486768 19.658 100 72 144 1 2054616064 28092352 22036944
20:39:13 5479 8192000000 10963237984 11388780544 2003066768 19.647 100 70 140 0 2052569504 28348640 21154096
20:39:26 6970 8192000000 10964108512 11391885312 1998055248 19.607 100 64 128 2 2056871840 39730704 19085888
20:39:40 10952 8192000000 10959473072 11386634240 1994751536 19.581 100 63 127 1 2044111392 30108848 19251008
20:39:58 2835 8192000000 10967221584 11394322432 2003787568 19.653 100 73 144 1 2057833008 31905344 22140096
20:40:09 5192 8192000000 10979299856 11404673024 2006541696 19.674 100 66 130 0 2059601552 32812192 20247664
20:40:23 8534 8192000000 10962023344 11398184960 1985909824 19.511 99 56 112 2 2038238000 34377632 17950544
20:40:40 3616 8192000000 10977055296 11400294400 2003164672 19.648 100 64 127 1 2057739040 35211920 19362448
20:40:51 1423 8192000000 10988472032 11407126528 2008071376 19.686 100 82 167 1 2070404160 36029360 26303424
20:41:00 7001 8192000000 10977023440 11407323136 2007006960 19.678 100 69 138 1 2064784464 36268272 21509232
20:41:24 4159 8192000000 10985766800 11406028800 1994868352 19.582 99 80 160 2 2055751536 36414240 24468944
20:41:36 944 8192000000 10991513568 11410644992 2014636144 19.738 100 90 180 2 2076230656 34566000 27028512
20:41:44 2478 8192000000 10981593008 11399057408 2005086128 19.663 100 86 172 0 2065262288 34201216 25974944
20:41:55 2806 8192000000 10978341456 11400351744 1992011328 19.560 99 83 164 2 2051291008 34214128 25065552
20:42:05 4523 8192000000 10963707872 11380256768 1977018944 19.441 99 80 160 1 2036329024 35329200 23980880
20:42:17 2627 8192000000 10975989920 11396628480 1997190912 19.601 100 83 165 2 2061317392 40272288 23854192
20:42:27 1763 8192000000 10975403024 11387801600 1994007936 19.575 100 91 179 2 2059958464 38177296 27773232
20:42:35 2385 8192000000 10974475696 11390406656 1992564272 19.564 100 80 160 1 2056002400 39200624 24237504
20:42:47 5209 8192000000 10935819360 11353149440 1951946688 19.242 98 71 142 1 2014692224 40408992 22336544
20:42:59 2202 8192000000 10978389248 11385040896 1984926256 19.504 100 90 181 2 2054107120 40926048 28254816
20:43:08 2204 8192000000 10968868688 11378229248 1978770928 19.455 100 88 176 2 2046047072 40463424 26812720
20:43:18 1448 8192000000 10970104352 11384414208 1983866080 19.495 100 90 180 0 2052703424 41007808 27829536
20:43:27 3386 8192000000 10965328560 11377717248 1964406176 19.341 99 83 163 1 2029443936 40486192 24551568
20:43:43 3826 8192000000 10960748464 11376353280 1961929024 19.321 99 84 168 0 2031697584 43932112 25836448
20:43:54 1905 8192000000 10946786752 11366895616 1955712640 19.272 99 75 150 3 2022598880 44112880 22773360
20:44:03 1103 8192000000 10971745536 11382009856 1980804752 19.471 100 86 169 5 2052491808 45875984 25811072
20:44:11 2661 8192000000 10966225760 11382546432 1960594784 19.311 99 79 158 3 2032818704 47080032 25143888
20:44:21 2549 8192000000 10967498368 11383734272 1981929488 19.480 100 86 171 3 2053601248 45120128 26551632
20:44:31 2032 8192000000 10961161680 11380273152 1963048864 19.330 99 82 164 1 2034823136 46155888 25618384
20:44:40 3528 8192000000 10952501920 11380944896 1971113888 19.394 100 57 115 0 2033494736 44163296 18217552
20:44:51 6216 8192000000 10906883104 11339116544 1925581632 19.032 98 35 70 2 1976506144 39006592 11917920
20:45:19 6495 8192000000 10926607600 11351494656 1923080672 19.012 98 70 138 3 1987421184 42919312 21421200
20:45:35 2237 8192000000 10944252672 11359465472 1942817760 19.169 99 86 171 1 2015835600 46072560 26945280
20:45:44 3235 8192000000 10957257680 11371229184 1964570192 19.342 100 85 170 0 2040069824 48332736 27166896
20:45:54 2082 8192000000 10961725056 11369652224 1953805728 19.257 99 91 183 1 2032813264 49811968 29195568
20:46:04 4389 8192000000 10955980720 11369431040 1948389024 19.214 99 80 158 3 2022770688 49910064 24471600
20:46:16 2447 8192000000 10962386672 11382243328 1969504784 19.382 100 80 161 0 2048014464 52027632 26482048
20:46:27 3153 8192000000 10968075024 11387027456 1977610912 19.446 100 87 173 1 2057849184 52908592 27329680
20:46:37 4814 8192000000 10932624400 11347382272 1917855744 18.970 97 75 150 0 1995151472 53662864 23632864
20:46:49 3443 8192000000 10972611776 11388604416 1969753984 19.383 100 80 160 1 2053619424 58657456 25207984
20:47:09 12328 8192000000 10935826464 11382554624 1963296448 19.332 100 34 68 2 2022158320 47855664 11006208
20:47:29 8476 8192000000 10925339456 11360124928 1930616880 19.072 99 44 87 1 1997705888 52607600 14481408
20:47:45 14649 8192000000 10921308672 11360423936 1928291808 19.053 99 34 68 0 1982929440 43150800 11486832
20:48:09 25400 8192000000 10907723104 11352670208 1942599952 19.167 100 29 58 1 1991628448 38733536 10294960
20:48:42 37906 8192000000 10902669344 11350159360 1914423168 18.942 98 39 78 0 1967869712 41672496 11774048
20:49:36 22295 8192000000 10903015536 11355148288 1945085200 19.187 100 24 48 3 1988229840 35390704 7753936
20:50:11 15953 8192000000 10901377696 11356426240 1945995472 19.195 100 22 44 2 1991611568 37862000 7754096
20:50:38 12771 8192000000 10906858592 11356946432 1929927392 19.066 99 23 46 0 1978058832 40317648 7813792
20:51:02 33023 8192000000 10896857584 11359084544 1940701152 19.152 100 22 44 3 1986631136 38482160 7447824
20:51:45 12283 8192000000 10895498640 11359252480 1935670640 19.112 100 12 24 1 1983464736 42922480 4871616
20:52:04 21584 8192000000 10893412032 11330093056 1903506720 18.854 99 26 53 1 1952064416 39939424 8618272
20:52:41 22766 8192000000 10862299536 11331948544 1890728176 18.752 98 22 44 1 1942353280 44191696 7433408
20:53:17 25368 8192000000 10859700176 11316670464 1897570752 18.807 99 14 28 0 1922132624 20060400 4501472
20:53:57 34404 8192000000 10881625984 11318247424 1895687792 18.792 98 40 78 2 1924381936 17828288 10865856
20:54:41 27963 8192000000 10856991232 11315576832 1909594560 18.903 99 19 38 3 1933044048 17208736 6240752
20:55:36 52313 8192000000 10868107200 11342045184 1930574448 19.071 100 9 18 1 1957187744 23540224 3073072
20:56:35 43963 8192000000 10846091552 11297501184 1851308048 18.433 96 10 19 0 1863819632 10285248 2226336
20:57:27 45458 8192000000 10870522112 11319074816 1924952656 19.027 99 46 90 3 1947456864 9187904 13316304
20:58:46 23691 8192000000 10864269840 11304189952 1879784176 18.663 96 52 103 1 1904524448 10157648 14582624
20:59:35 80801 8192000000 10864560560 11332534272 1923965424 19.019 99 17 34 1 1944688640 15469216 5254000
21:01:20 63525 8192000000 10842687424 11279818752 1869194528 18.578 96 43 87 1 1889938368 8036176 12707664
21:02:30 15735 8192000000 10881283824 11320639488 1923631632 19.016 99 60 120 1 1949964816 9010784 17322400
21:02:54 69323 8192000000 10871098096 11330629632 1930838848 19.074 99 30 60 0 1955512000 15167968 9505184
21:04:37 4575 8192000000 10907755728 11339632640 1947126512 19.204 99 53 104 2 1969207120 8437280 13643328
21:04:48 13590 8192000000 10916897824 11358011392 1964387840 19.341 100 58 114 1 1997070240 16831776 15850624
21:05:08 16472 8192000000 10897694240 11354202112 1971899584 19.401 100 41 82 2 1999322112 15776144 11646384
21:05:40 25037 8192000000 10907151920 11355004928 1960917936 19.313 100 23 46 1 1983070800 15386080 6766784
21:06:15 38193 8192000000 10912643344 11360763904 1963904592 19.337 100 25 49 1 1987878448 16946016 7027840
21:07:00 45785 8192000000 10909642544 11369844736 1973693744 19.415 100 36 72 0 2002801536 18284704 10823088
21:07:54 19676 8192000000 10922158256 11379310592 1976930944 19.440 100 30 60 1 2008056832 21915568 9210320
21:08:21 32525 8192000000 10914730800 11384938496 1977068736 19.441 100 14 28 3 2000988768 19691472 4228560
21:09:04 57561 8192000000 10875416976 11353825280 1924977824 19.027 98 9 18 0 1943955696 16193728 2784144
21:10:08 23506 8192000000 10878395184 11363340288 1952945184 19.250 100 12 23 0 1971709776 15320480 3444112
21:10:43 17433 8192000000 10876624240 11344171008 1941061216 19.155 99 9 18 0 1953019856 9435168 2523472
21:11:07 39384 8192000000 10885626912 11347714048 1955970080 19.274 100 15 30 1 1969992816 9731024 4291712
21:11:55 63974 8192000000 10903259376 11365347328 1969424704 19.381 100 24 48 1 1990362224 13046944 7890576
21:13:13 60079 8192000000 10899318480 11374473216 1970604320 19.390 100 20 39 2 1997329888 19725312 7000256
21:14:45 59863 8192000000 10895066416 11372105728 1954576816 19.263 99 19 38 0 1973285344 12640464 6068064
21:15:54 55295 8192000000 10899933584 11372916736 1953747840 19.256 99 19 38 2 1971760336 12779600 5232896
21:17:06 22657 8192000000 10906301088 11360485376 1955196384 19.268 99 40 80 0 1974467168 8030416 11240368
21:17:49 27570 8192000000 10908350704 11368910848 1977448832 19.444 100 35 70 1 1997568576 10457456 9662288
21:18:29 58181 8192000000 10910226128 11369676800 1969745664 19.383 100 8 16 0 1983388160 11470960 2171536
21:19:34 98129 8192000000 10896697760 11350659072 1894961360 18.786 96 12 24 1 1911364544 12986016 3417168
21:21:18 53456 8192000000 10904070912 11366424576 1948731648 19.216 99 36 72 3 1970328960 12155328 9441984
21:22:22 48652 8192000000 10907512096 11361230848 1930874352 19.074 98 19 38 1 1948092192 11723520 5494320
21:23:19 54585 8192000000 10894658832 11370078208 1929488624 19.063 98 26 52 1 1954245088 17508880 7247584
21:24:20 91504 8192000000 10890812320 11359383552 1906468704 18.878 97 3 6 0 1918459216 11135200 855312
21:25:58 28063 8192000000 10899145600 11343998976 1922326560 19.005 98 29 55 0 1939879056 10207344 7345152
21:26:36 38969 8192000000 10884262144 11356823552 1948083984 19.211 100 35 70 1 1969115008 11351456 9679568
21:27:24 136999 8192000000 10878592000 11344818176 1953803904 19.257 99 25 50 0 1969695392 8624576 7266912
21:29:52 64086 8192000000 10866299952 11322368000 1852726704 18.444 93 32 64 0 1872455120 11094032 8634384
21:31:03 8500 8192000000 10874821248 11336384512 1950518816 19.231 100 38 76 3 1973086704 11680144 10887744
21:31:23 18915 8192000000 10913728576 11358130176 1957139536 19.283 100 39 77 0 1977655648 10258928 10257184
21:31:51 46452 8192000000 10868934256 11341438976 1888392048 18.733 96 19 38 0 1907319184 12835872 6091264
21:32:57 33371 8192000000 10863836496 11346038784 1932767248 19.089 99 5 10 0 1944028800 10055200 1206352
21:33:37 46579 8192000000 10851290336 11322101760 1874913184 18.624 96 11 22 0 1886183568 8339280 2931104
21:34:48 40759 8192000000 10846787360 11317706752 1918478688 18.975 99 8 16 0 1929235504 8443168 2313648
21:35:53 41472 8192000000 10863342816 11338977280 1930405712 19.070 99 18 35 2 1944744192 8499088 5839392
21:36:41 49622 8192000000 10879530096 11344683008 1937412768 19.126 99 15 30 0 1949972176 8152368 4407040
21:37:39 48131 8192000000 10854878640 11323723776 1901885168 18.841 97 12 24 1 1914618896 9365712 3368016
21:38:38 45160 8192000000 10853733664 11321040896 1907236096 18.884 99 16 32 3 1922537488 10535488 4765904
21:39:33 37429 8192000000 10830941664 11295469568 1866536432 18.556 97 28 56 3 1882373936 7567120 8270384
21:40:26 50372 8192000000 10864723728 11327569920 1894708800 18.784 98 26 52 2 1915051440 12782288 7560352
21:42:21 65965 8192000000 10861444928 11322728448 1915579008 18.951 99 14 28 0 1933598336 14276032 3743296
21:43:55 39547 8192000000 10885467024 11353128960 1952041584 19.243 100 20 40 0 1970546976 12578656 5926736
21:44:41 49731 8192000000 10885628656 11355426816 1917109296 18.964 98 22 44 1 1939750816 16490432 6151088
21:45:47 95750 8192000000 10872157136 11335774208 1891839504 18.761 97 12 24 0 1905939600 10761584 3338512
21:47:29 41787 8192000000 10868053280 11338162176 1897980496 18.810 97 32 63 3 1917439632 10101328 9357808
21:48:25 71256 8192000000 10880390960 11349856256 1864720576 18.542 96 12 24 1 1879190800 11377296 3092928
21:49:50 40395 8192000000 10873783536 11341918208 1886075872 18.714 97 18 36 0 1919171136 27535808 5559456
21:50:46 95099 8192000000 10866564752 11348107264 1915000880 18.947 99 7 14 0 1939967552 22556640 2410032
21:52:28 117065 8192000000 10886372528 11348385792 1948148784 19.212 100 26 52 0 1966733632 11791840 6793008
21:54:31 44506 8192000000 10853273536 11315707904 1853795408 18.453 95 29 58 2 1870723072 9086864 7840800
21:55:40 55166 8192000000 10854839952 11336773632 1942761312 19.169 100 11 22 0 1956926880 10642560 3523008
21:56:42 37437 8192000000 10850229456 11310665728 1907430544 18.886 98 21 42 0 1922445392 9298672 5716176
21:57:25 85003 8192000000 10893732960 11359961088 1938484208 19.135 99 24 48 0 1956484160 11510944 6489008
21:59:09 69028 8192000000 10906834000 11373891584 1972930240 19.409 100 14 28 0 1993024496 15953664 4140592
22:00:58 97239 8192000000 10892542816 11385327616 1954215600 19.260 99 21 43 0 1984169552 23499728 6454224
22:02:44 50407 8192000000 10872258176 11339784192 1921377584 18.998 98 11 22 0 1940526912 16259760 2889568
22:03:40 37557 8192000000 10896289568 11357884416 1942631568 19.168 99 22 44 0 1956264768 7077168 6556032
22:04:24 34947 8192000000 10909309952 11372220416 1972846064 19.408 100 27 54 3 1992501792 12023616 7632112
22:05:05 52839 8192000000 10923319920 11381075968 1975638112 19.430 100 16 32 0 1991488288 11687840 4162336
22:06:08 26158 8192000000 10918567616 11383451648 1991825088 19.558 100 48 95 4 2013896176 8708688 13362400
22:06:50 39912 8192000000 10930780656 11384557568 1989347136 19.539 100 13 26 2 2001978544 9088064 3543344
22:07:38 45695 8192000000 10906023552 11378876416 1951132432 19.235 98 19 38 0 1969355840 12547648 5675760
22:08:31 61767 8192000000 10919601008 11382407168 1966068576 19.354 99 27 54 0 1983883360 10613792 7200992
22:09:39 43332 8192000000 10932908720 11397861376 1992047904 19.560 100 39 78 1 2013251440 9879712 11323824
22:10:28 30980 8192000000 10923859120 11381690368 1973156160 19.410 99 35 70 5 1991340464 8507808 9676496
22:11:13 24720 8192000000 10899517104 11353812992 1899380560 18.821 96 37 74 0 1919665088 10173392 10111136
22:11:45 80777 8192000000 10846066576 11306962944 1842252112 18.359 94 17 34 1 1857980240 11131024 4597104
22:13:23 71439 8192000000 10873546944 11329052672 1912033568 18.923 99 23 46 1 1927723408 9112752 6577088
22:14:41 91961 8192000000 10886345184 11344896000 1897686688 18.808 97 9 18 0 1915355904 15577632 2091584
22:16:19 97363 8192000000 10898049808 11353690112 1942305872 19.165 99 25 49 0 1956607920 7188656 7113392
22:18:06 66954 8192000000 10878756768 11357020160 1913035184 18.931 97 18 33 4 1925398432 7493728 4869520
22:19:19 60168 8192000000 10860819232 11332325376 1927618704 19.048 98 13 26 2 1940797744 9251824 3927216
22:20:25 4412 8192000000 10870083136 11311378432 1893679056 18.775 97 61 115 0 1918351296 7735632 16936608
22:20:37 38889 8192000000 10840693584 11301208064 1858398160 18.490 96 26 52 2 1874702800 8587776 7716864
22:21:26 76077 8192000000 10848160096 11330048000 1910270816 18.909 99 6 12 0 1919826944 8040256 1515872
22:22:50 45143 8192000000 10864645856 11333128192 1917436544 18.966 99 13 26 1 1929343472 7726032 4180896
22:25:16 48270 8192000000 10845974976 11328208896 1905108736 18.867 98 10 20 2 1921161424 13081552 2971136
22:26:18 47202 8192000000 9128397632 9368121344 295847456 3.485 16 3 6 0 301530816 4915536 767824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-11-2020 22:28:44 to 09-11-2020 22:29:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 142 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-11-2020 22:29:17 to 09-11-2020 22:29:19.

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          240127
MON$OLDEST_ACTIVE               240128
MON$OLDEST_SNAPSHOT             240128
MON$NEXT_TRANSACTION            240128
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                       2022208
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:160: 
:161: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:162:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:163: 
:164: 
:165: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:166:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:167: 
:168: 
:169: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:170:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:171: 
:172: 
:173: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:174:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:175: 
:176: 
:177: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:178:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:179: 
:180: 
:181: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:182:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:183: 
:184: 
:185: mscs-test-161.budzdorov.ru    Mon Nov  9 22:27:09 2020
:186:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:187: 
--- end of diff output ---

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

09.11.20 22:29:20. 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
2020-11-09 22:29:22 No severe PSQL-related problems occured
09.11.20 22:29:24. End of report.