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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17180124 kB
MemAvailable 31436232 kB
Buffers 0 kB
Cached 14454128 kB
SwapCached 0 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-04-01 22:27:24
DTS_END                         2021-04-01 22:27:24.0200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_MONEY_SALDO(33:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46166
TRN_ID                          245206
ATT_ID                          711
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: 9535.05 19493 1144206
customer order: creation 176.91 334 21229
customer order: refuse 15.23 333 1827
order to supplier: creation 46.99 1238 5639
order to supplier: removal 3.44 107095 413
invoice (draft): creation 48.58 3605 5830
invoice (draft): removal 54.10 771 6492
invoice accept: apply 44.27 18691 5312
invoice accept: cancel 48.55 936 5826
customer reserve: creation 4013.07 188 481568
customer reserve: removal 4777.40 61 573288
realization accept: apply 88.21 185 10585
realization accept: cancel 85.98 107 10318
payment from customer: creation 60.31 145 7237
payment from customer: removal 5.80 152 696
payment to supplier: creation 49.73 137 5968
payment to supplier: removal 3.83 157 460
service: total inventory turnovers 4.85 1343 582
service: total monetary turnovers 6.93 34 831
service: aggregate perf. data 0.84 21350 101
service: refresh index statistics 0.03 232990 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-04-2021 22:28:14 to 01-04-2021 22:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4729
TEST_TIME 2 4387
TEST_TIME 3 5750
TEST_TIME 4 5617
TEST_TIME 5 5291
TEST_TIME 6 5306
TEST_TIME 7 5621
TEST_TIME 8 5948
TEST_TIME 9 5954
TEST_TIME 10 6465
TEST_TIME 11 6447
TEST_TIME 12 6294
TEST_TIME 13 6381
TEST_TIME 14 6945
TEST_TIME 15 6994
TEST_TIME 16 7135
TEST_TIME 17 7522
TEST_TIME 18 7570
TEST_TIME 19 8017
TEST_TIME 20 8169
TEST_TIME 21 8146
TEST_TIME 22 8757
TEST_TIME 23 8817
TEST_TIME 24 8954
TEST_TIME 25 9595
TEST_TIME 26 9866
TEST_TIME 27 9911
TEST_TIME 28 10269
TEST_TIME 29 11127
TEST_TIME 30 10911
TEST_TIME 31 10908
TEST_TIME 32 10841
TEST_TIME 33 10786
TEST_TIME 34 10976
TEST_TIME 35 10929
TEST_TIME 36 10698
TEST_TIME 37 10545
TEST_TIME 38 10411
TEST_TIME 39 10506
TEST_TIME 40 10477
TEST_TIME 41 10466
TEST_TIME 42 10430
TEST_TIME 43 10315
TEST_TIME 44 10266
TEST_TIME 45 10259
TEST_TIME 46 10165
TEST_TIME 47 10181
TEST_TIME 48 10240
TEST_TIME 49 10230
TEST_TIME 50 10172
TEST_TIME 51 10263
TEST_TIME 52 10176
TEST_TIME 53 10050
TEST_TIME 54 10012
TEST_TIME 55 10056
TEST_TIME 56 9990
TEST_TIME 57 9914
TEST_TIME 58 9917
TEST_TIME 59 9830
TEST_TIME 60 9784
TEST_TIME 61 9802
TEST_TIME 62 9792
TEST_TIME 63 9843
TEST_TIME 64 9796
TEST_TIME 65 9821
TEST_TIME 66 9849
TEST_TIME 67 9968
TEST_TIME 68 9927
TEST_TIME 69 9933
TEST_TIME 70 9887
TEST_TIME 71 9961
TEST_TIME 72 9969
TEST_TIME 73 9973
TEST_TIME 74 9968
TEST_TIME 75 9939
TEST_TIME 76 9916
TEST_TIME 77 9866
TEST_TIME 78 9792
TEST_TIME 79 9769
TEST_TIME 80 9728
TEST_TIME 81 9676
TEST_TIME 82 9696
TEST_TIME 83 9638
TEST_TIME 84 9666
TEST_TIME 85 9607
TEST_TIME 86 9579
TEST_TIME 87 9613
TEST_TIME 88 9600
TEST_TIME 89 9561
TEST_TIME 90 9563
TEST_TIME 91 9611
TEST_TIME 92 9703
TEST_TIME 93 9666
TEST_TIME 94 9646
TEST_TIME 95 9687
TEST_TIME 96 9711
TEST_TIME 97 9660
TEST_TIME 98 9756
TEST_TIME 99 9778
TEST_TIME 100 9773
TEST_TIME 101 9738
TEST_TIME 102 9660
TEST_TIME 103 9646
TEST_TIME 104 9659
TEST_TIME 105 9668
TEST_TIME 106 9630
TEST_TIME 107 9595
TEST_TIME 108 9568
TEST_TIME 109 9545
TEST_TIME 110 9508
TEST_TIME 111 9481
TEST_TIME 112 9470
TEST_TIME 113 9424
TEST_TIME 114 9468
TEST_TIME 115 9558
TEST_TIME 116 9601
TEST_TIME 117 9570
TEST_TIME 118 9561
TEST_TIME 119 9569
TEST_TIME 120 9537

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-04-2021 22:28:18 to 01-04-2021 22:28:21.

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 1589075 1589075 0 0.00 0 28059 6 0 0
doc_list_biud 1589075 1589075 0 0.00 0 28937 28 0 0
sp_add_invoice_to_stock 5387 5312 75 1.39 34 205999 18691 0 75
sp_cancel_adding_invoice 5826 5826 0 0.00 5 73584 936 0 0
sp_cancel_client_order 1827 1827 0 0.00 4 8801 334 0 0
sp_cancel_customer_reserve 573288 573288 0 0.00 1 28938 62 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 24303 153 0 0
sp_cancel_pay_to_supplier 460 460 0 0.00 2 25609 157 0 0
sp_cancel_supplier_invoice 6502 6492 10 0.15 2 13398 772 0 10
sp_cancel_supplier_order 413 413 0 0.00 7 1125321 107095 0 0
sp_cancel_write_off 10318 10318 0 0.00 1 18048 107 0 0
sp_client_order 21229 21229 0 0.00 3 29308 335 0 0
sp_customer_reserve 481568 481568 0 0.00 0 69293 188 0 0
sp_fill_shopping_cart 32691 32691 0 0.00 1 18382 40 0 0
sp_fill_shopping_cart_clo_res 481564 481564 0 0.00 0 27438 14 0 0
sp_get_clo_for_invoice 5308 5308 0 0.00 0 30527 271 0 0
sp_kill_cost_storno 17300 17300 0 0.00 0 27972 57 0 0
sp_kill_qstorno_ret_qs2qd 1163799 1163799 0 0.00 0 28917 33 0 0
sp_kill_qty_storno 614056 614056 0 0.00 0 28936 72 0 0
sp_lock_selected_doc 21782 21782 0 0.00 0 8717 7 0 0
sp_make_cost_storno 29097 29097 0 0.00 0 27804 59 0 0
sp_multiply_rows_for_pdistr 29097 29097 0 0.00 0 14978 28 0 0
sp_multiply_rows_for_qdistr 21229 21229 0 0.00 0 14969 153 0 0
sp_pay_from_customer 7237 7237 0 0.00 4 25524 146 0 0
sp_pay_to_supplier 5968 5968 0 0.00 5 27143 137 0 0
sp_payment_common 13205 13205 0 0.00 1 20256 33 0 0
sp_qd_handle_on_cancel_clo 1827 1827 0 0.00 0 8793 302 0 0
sp_qd_handle_on_invoice_upd_sts 11133 11133 0 0.00 0 26506 337 0 0
sp_qd_handle_on_reserve_upd_sts 10585 10585 0 0.00 0 15599 56 0 0
sp_reserve_write_off 10585 10585 0 0.00 6 25612 186 0 0
sp_supplier_invoice 5830 5830 0 0.00 7 101369 3605 0 0
sp_supplier_order 5639 5639 0 0.00 5 39274 1238 0 0
srv_aggregate_perf_data 101 101 0 0.00 2916 242435 21351 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1177 129355 30591 0 0
srv_find_qd_qs_mism 1094389 1094389 0 0.00 0 14513 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 31 84222 1343 0 0
srv_make_money_saldo 831 831 0 0.00 0 8569 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 129655 298731 232990 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5312 5312 0 0.00 0 14843 161 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 2694 107 0 0
t$perf-norm:sp_cancel_client_order 1827 1827 0 0.00 0 6007 20 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 1517 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 3442 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 460 460 0 0.00 0 3640 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 411 411 0 0.00 0 1397 16 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 25205 1480 0 0
t$perf-norm:sp_cancel_write_off 970 970 0 0.00 0 3044 9 0 0
t$perf-norm:sp_client_order 21229 21229 0 0.00 0 17465 17 0 0
t$perf-norm:sp_customer_reserve 1008 1008 0 0.00 0 1660 10 0 0
t$perf-norm:sp_pay_from_customer 7237 7237 0 0.00 0 6014 10 0 0
t$perf-norm:sp_pay_to_supplier 5968 5968 0 0.00 0 6875 10 0 0
t$perf-norm:sp_reserve_write_off 10585 10585 0 0.00 0 7506 11 0 0
t$perf-norm:sp_supplier_invoice 5830 5830 0 0.00 0 14536 20 0 0
t$perf-norm:sp_supplier_order 5639 5639 0 0.00 0 6884 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 760 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 5924 60 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 2634 31 0 0
t$perf-norm:srv_make_money_saldo 831 831 0 0.00 0 3558 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 77 22 0 0
v_add_invoice_to_stock 10764 10614 150 1.39 0 23648 24 0 150
v_all_customers 38202 38202 0 0.00 0 130 1 0 0
v_all_suppliers 31180 31180 0 0.00 0 92 1 0 0
v_all_wares 42458 42458 0 0.00 0 97 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 2103 11 0 0
v_cancel_client_order 3654 3654 0 0.00 0 2712 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 24256 35 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 2023 6 0 0
v_cancel_payment_to_supplier 920 920 0 0.00 0 25596 37 0 0
v_cancel_supplier_invoice 842 822 20 2.37 0 353 14 0 20
v_cancel_supplier_order 826 826 0 0.00 0 2441 14 0 0
v_cancel_write_off 1940 1940 0 0.00 0 15049 24 0 0
v_max_id_clo_ord 5638 5638 0 0.00 0 1295 2 0 0
v_max_id_clo_res 1008 1008 0 0.00 0 8988 17 0 0
v_max_id_ord_sup 5824 5824 0 0.00 0 6179 4 0 0
v_max_non_paid_invoice 1840 1840 0 0.00 0 2819 4 0 0
v_max_non_paid_realizn 4125 4125 0 0.00 0 4099 4 0 0
v_min_id_clo_ord 5638 5638 0 0.00 0 10205 8 0 0
v_min_id_clo_res 1008 1008 0 0.00 0 1461 4 0 0
v_min_id_ord_sup 5824 5824 0 0.00 0 11850 13 0 0
v_min_non_paid_invoice 5968 5968 0 0.00 0 19617 18 0 0
v_min_non_paid_realizn 7237 7237 0 0.00 0 5458 21 0 0
v_our_firm 10480 10480 0 0.00 0 91 1 0 0
v_reserve_write_off 21170 21170 0 0.00 0 23656 12 0 0
x_lock_depdocs_on_canc_invoice 11907 11907 0 0.00 0 21953 122 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 25331 456 0 0
x_make_qstorno_1000_1200 5639 5639 0 0.00 2 39260 1154 0 0
x_make_qstorno_1200_2000 5830 5830 0 0.00 3 101354 3464 0 0
x_make_qstorno_2100_3300 481568 481568 0 0.00 0 69282 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-04-2021 22:28:22 to 01-04-2021 22:28:26.

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:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 14196 8192000000 10220240512 10521886720 878311408 9.683 70 53 111 0 898007664 2618464 17077792
19:57:56 34895 8192000000 10340452816 10656489472 1376098192 14.382 100 88 176 0 1409620320 4531296 28990832
19:58:40 29881 8192000000 10375779168 10694828032 1429468064 14.857 100 91 182 0 1465560896 6291568 29801264
19:59:18 26273 8192000000 10414604416 10738458624 1463499984 15.157 100 91 182 0 1500897264 7474112 29923168
19:59:55 29573 8192000000 10436550864 10765914112 1481317456 15.313 100 89 178 0 1518213600 8221760 28674384
20:00:34 20463 8192000000 10445762064 10778263552 1500039936 15.477 100 87 174 1 1536598880 9067008 27491936
20:01:09 11847 8192000000 10463964688 10801131520 1518529728 15.637 100 90 181 1 1556568432 9490128 28548576
20:01:30 16510 8192000000 10484089424 10822512640 1535847504 15.788 100 85 170 1 1572404064 9751952 26804608
20:01:57 9942 8192000000 10491588336 10838740992 1560712464 16.002 100 84 168 1 1596473232 9977472 25783296
20:02:16 15494 8192000000 10520671680 10872324096 1581246144 16.179 100 79 158 0 1615019312 10100656 23672512
20:02:42 14719 8192000000 10557413456 10914070528 1605579664 16.387 100 75 150 1 1638042016 10101328 22361024
20:03:08 8320 8192000000 10569932624 10927448064 1632357872 16.615 100 84 168 1 1668792624 11580480 24854272
20:03:26 13595 8192000000 10596848144 10956201984 1653265616 16.792 100 78 156 0 1688153808 12065808 22822384
20:03:49 13186 8192000000 10611864976 10971955200 1664869504 16.890 100 81 162 0 1702063408 13097840 24096064
20:04:11 11621 8192000000 10617421168 10984980480 1678056128 17.001 100 78 156 0 1713603376 13184448 22362800
20:04:32 5647 8192000000 10630761824 10999259136 1694054128 17.135 100 80 160 1 1729982656 13216864 22711664
20:04:46 7818 8192000000 10640544576 11010428928 1705652800 17.232 100 78 154 1 1740380544 12258400 22469344
20:05:00 6040 8192000000 10663538032 11036336128 1721800608 17.367 100 73 146 0 1754254752 11869584 20584560
20:05:14 5698 8192000000 10682306416 11053920256 1740969280 17.527 100 85 168 3 1777763968 12841584 23953104
20:05:27 7097 8192000000 10696092672 11070472192 1751811616 17.617 100 81 162 0 1787741072 13057216 22872240
20:05:40 5137 8192000000 10696385760 11078684672 1764295152 17.720 100 78 154 0 1799558640 13212688 22050800
20:05:52 4237 8192000000 10720965440 11097034752 1776138960 17.818 100 80 159 3 1811955008 12719280 23096768
20:06:05 4711 8192000000 10723035280 11098288128 1780750592 17.856 100 81 160 2 1816908320 13210528 22947200
20:06:17 1509 8192000000 10734126192 11114373120 1796906144 17.989 100 93 181 1 1836493040 13989632 25597264
20:06:26 2574 8192000000 10742147136 11123249152 1807462688 18.075 100 87 175 0 1845708640 13497104 24748848
20:06:35 3289 8192000000 10750941216 11131265024 1812194496 18.114 100 90 179 1 1850894800 13833296 24867008
20:06:45 3388 8192000000 10756804848 11138809856 1814475232 18.133 100 86 170 2 1851638176 13726720 23436224
20:06:56 9100 8192000000 10755383904 11144605696 1817866896 18.160 100 79 158 0 1854348384 14618352 21863136
20:07:12 4218 8192000000 10771439120 11157491712 1822288176 18.196 100 82 164 2 1858005664 13818176 21899312
20:07:23 1956 8192000000 10780615024 11163709440 1833982864 18.292 100 86 170 1 1872000400 14474208 23543328
20:07:31 1108 8192000000 10784187184 11166396416 1836371040 18.311 100 84 168 2 1873650768 14373296 22906432
20:07:39 2249 8192000000 10788562736 11174862848 1845976032 18.389 100 90 180 2 1884911024 13925568 25009424
20:07:47 2408 8192000000 10799531936 11183415296 1852536976 18.443 100 94 189 0 1892794160 13426416 26830768
20:07:56 2118 8192000000 10800414112 11188973568 1857382768 18.482 100 94 187 1 1897376160 13522400 26470992
20:08:05 1733 8192000000 10806261008 11190722560 1859112368 18.496 100 95 190 0 1900949088 14938080 26898640
20:08:13 1182 8192000000 10812858544 11199295488 1861139712 18.513 100 94 188 3 1902511056 14896704 26474640
20:08:20 1203 8192000000 10809075056 11196469248 1864158400 18.537 100 92 183 3 1903707792 14553712 24995680
20:08:28 1097 8192000000 10816877760 11203584000 1868009584 18.568 100 89 180 1 1906669552 13472320 25187648
20:08:36 1090 8192000000 10823287264 11209928704 1876346048 18.636 100 95 191 2 1915401232 12400192 26654992
20:08:43 1138 8192000000 10820687680 11208495104 1873309024 18.611 100 92 185 1 1911836256 12380320 26146912
20:08:51 6791 8192000000 10788844704 11205136384 1868345056 18.571 100 54 106 2 1894556480 11722640 14488784
20:09:04 44438 8192000000 10808915072 11208585216 1869038784 18.576 100 47 93 0 1888211296 5347040 13825472
20:09:54 24342 8192000000 10778058464 11207929856 1870961760 18.592 100 38 75 1 1889293424 7434864 10896800
20:10:28 8834 8192000000 10798410880 11216248832 1872975712 18.608 100 35 67 2 1891233648 7361440 10896496
20:10:48 4483 8192000000 10801041120 11216748544 1876330048 18.635 100 39 78 0 1895377312 8593376 10453888
20:10:59 2910 8192000000 10806342704 11224563712 1882864720 18.688 100 47 94 1 1905373440 9621984 12886736
20:11:08 3907 8192000000 10803174080 11221757952 1880560976 18.670 100 44 88 0 1902753552 9200768 12991808
20:11:19 6734 8192000000 10789860192 11220303872 1881638096 18.678 100 33 66 2 1899091728 8110480 9343152
20:11:34 9122 8192000000 10789941376 11221377024 1883340128 18.692 100 20 40 1 1894342640 5196960 5805552
20:11:51 7355 8192000000 10780650064 11220758528 1881917408 18.681 100 22 43 3 1894285520 6359424 6008688
20:12:05 10308 8192000000 10794458816 11228717056 1888785600 18.736 100 25 50 1 1902552752 6212704 7554448
20:12:23 10916 8192000000 10792706400 11227639808 1890782576 18.752 100 21 42 1 1902577424 6204288 5590560
20:12:45 9429 8192000000 10793672960 11231662080 1891603088 18.759 100 24 49 1 1904944816 6756080 6585648
20:13:01 7068 8192000000 10798588192 11232555008 1890104848 18.747 100 26 52 1 1903833648 6023056 7705744
20:13:14 9290 8192000000 10796642784 11232796672 1889281888 18.740 100 15 29 3 1899937472 6070480 4585104
20:13:33 9694 8192000000 10791278080 11234103296 1892250448 18.764 100 23 46 1 1905731472 7129584 6351440
20:13:50 10398 8192000000 10799758480 11236114432 1893460912 18.774 100 22 43 3 1906106224 6637680 6007632
20:14:09 66893 8192000000 10820825136 11243900928 1895228512 18.788 100 31 62 1 1911163968 5018320 10917136
20:15:22 3952 8192000000 10817593040 11244171264 1892443424 18.765 100 39 78 2 1912662880 9805776 10413680
20:15:34 2678 8192000000 10808513808 11244257280 1892124192 18.763 100 25 51 1 1906265968 7174752 6967024
20:15:44 8999 8192000000 10794278224 11220733952 1875379024 18.628 99 26 52 2 1888569728 5708288 7482416
20:16:02 5384 8192000000 10807329856 11235049472 1885687680 18.711 100 30 60 1 1901217104 7194656 8334768
20:16:14 5591 8192000000 10803272976 11232600064 1883657344 18.695 100 26 51 3 1897828640 6145248 8026048
20:16:28 4484 8192000000 10799039856 11229581312 1883756336 18.695 100 30 60 3 1898460080 6701216 8002528
20:16:39 10005 8192000000 10780967936 11218763776 1862662672 18.525 99 18 36 0 1873136864 5394192 5080000
20:16:59 8101 8192000000 10800354144 11225669632 1878153152 18.650 100 14 28 1 1887524496 5155312 4216032
20:17:14 9721 8192000000 10793276816 11227430912 1878243680 18.651 100 16 32 0 1887867376 4846928 4776768
20:17:30 5923 8192000000 10802500992 11234615296 1891123440 18.755 100 33 67 6 1906544192 5350016 10070736
20:17:43 9673 8192000000 10777954208 11214123008 1842824064 18.364 98 19 38 1 1854074576 5498576 5751936
20:17:59 11140 8192000000 10765649424 11190824960 1833298880 18.286 98 22 44 0 1845955312 6130560 6525872
20:18:16 8384 8192000000 10761270752 11179831296 1765839344 17.733 95 16 32 0 1775583472 5092816 4651312
20:18:34 15996 8192000000 10737569312 11148955648 1729226592 17.429 94 36 71 5 1744031520 5085872 9719056
20:18:57 59637 8192000000 10718511552 11143901184 1704715920 17.225 93 26 52 2 1716690960 4564704 7410336
20:20:02 7027 8192000000 10710227120 11133444096 1758452224 17.672 97 16 31 2 1767568800 4755296 4361280
20:20:16 5602 8192000000 10714304112 11130667008 1752214816 17.620 97 36 72 0 1773716112 11584192 9917104
20:20:30 5202 8192000000 10712417040 11132043264 1763591200 17.714 98 23 46 1 1776782592 6412448 6778944
20:20:42 6727 8192000000 10751398784 11165433856 1817040112 18.153 100 35 70 2 1833730608 7005888 9684608
20:20:56 7965 8192000000 10728381184 11155369984 1764702176 17.723 96 28 56 0 1778963728 5936304 8325248
20:21:11 9153 8192000000 10708732864 11119419392 1684204544 17.053 93 26 52 1 1697107280 5302016 7600720
20:21:30 7045 8192000000 10691486672 11109793792 1765934848 17.733 99 20 40 1 1777282720 5138048 6209824
20:21:45 6349 8192000000 10704611248 11123159040 1762366304 17.704 98 23 46 1 1775372672 6534992 6471376
20:21:57 13119 8192000000 10701237104 11118161920 1711002656 17.277 95 22 44 0 1723514448 5512080 6999712
20:22:19 9237 8192000000 10721666960 11133308928 1767169200 17.744 98 24 48 0 1780027984 5378528 7480256
20:22:37 9632 8192000000 10737329024 11156910080 1804775440 18.053 99 38 76 2 1822235360 5201568 12258352
20:22:55 9185 8192000000 10728127344 11150991360 1809523344 18.092 99 18 36 0 1820073424 5345504 5204576
20:23:11 14854 8192000000 10749086480 11173232640 1816073504 18.146 99 20 39 1 1827377088 5452016 5851568
20:23:32 52034 8192000000 10777077232 11185037312 1848225600 18.408 100 35 70 0 1862692832 5137072 9330160
20:24:30 20131 8192000000 10756374816 11190292480 1850997984 18.430 100 36 71 3 1867069088 6450576 9620528
20:24:56 8293 8192000000 10766017952 11196678144 1854319040 18.457 100 21 42 1 1866972272 5812032 6841200
20:25:18 11934 8192000000 10774671232 11199389696 1860279152 18.506 100 28 56 1 1874491808 6108688 8103968
20:25:38 3748 8192000000 10781584320 11206066176 1861953664 18.519 100 40 78 1 1881925424 8351952 11619808
20:25:52 7517 8192000000 10772382576 11206856704 1864082592 18.536 100 35 70 0 1881724864 7500032 10142240
20:26:08 4535 8192000000 10792161616 11218227200 1874423920 18.620 100 50 100 2 1896702048 7004672 15273456
20:26:24 8447 8192000000 10786540544 11215499264 1869890800 18.583 100 37 74 2 1887365456 6563984 10910672
20:26:43 7026 8192000000 10786293856 11215863808 1870012064 18.584 100 27 54 0 1883644496 5663456 7968976
20:26:56 11213 8192000000 10807860128 11226423296 1871733328 18.598 100 24 48 1 1883951040 5019136 7198576
20:27:14 7538 8192000000 10806676544 11234713600 1894876224 18.785 100 31 62 0 1909420032 5299568 9244240
20:27:29 28016 8192000000 10829174928 11247575040 1900254656 18.828 100 30 60 0 1914263360 5461904 8546800
20:28:10 13013 8192000000 10835597696 11258499072 1908751744 18.897 100 41 78 2 1928853488 9095088 11006656
20:28:40 15760 8192000000 10856997408 11275935744 1921200656 18.996 100 61 123 2 1950412832 11430256 17781920
20:29:04 5802 8192000000 10865675568 11279761408 1924950224 19.026 100 56 110 0 1952983376 11715040 16318112
20:29:19 86337 8192000000 10864421200 11298607104 1930457472 19.071 100 54 108 1 1959775600 13147440 16170688
20:31:28 10546 8192000000 10869159360 11304058880 1938956240 19.138 100 34 66 1 1963236832 14052800 10227792
20:31:47 17010 8192000000 10883467216 11309211648 1942644960 19.168 100 44 85 3 1969750800 14649120 12456720
20:32:13 10649 8192000000 10882566256 11311173632 1943995808 19.179 100 58 116 2 1976578848 16042080 16540960
20:32:34 12414 8192000000 10895018192 11320184832 1947592384 19.207 100 60 120 0 1986295760 20878528 17824848
20:33:00 11714 8192000000 10876508528 11289423872 1913769248 18.937 98 69 138 0 1952832816 19145216 19918352
20:33:19 14037 8192000000 10879774160 11311775744 1939496656 19.143 100 53 106 1 1972488928 17710896 15281376
20:33:45 9322 8192000000 10898135456 11326324736 1952454432 19.246 100 56 111 0 1989309200 21106592 15748176
20:34:02 3890 8192000000 10907972544 11332509696 1960488656 19.310 100 68 134 2 2002624640 22575520 19560464
20:34:15 2257 8192000000 10924081120 11341787136 1964126176 19.339 100 69 136 0 2009260816 25191232 19943408
20:34:32 5641 8192000000 10929082480 11348389888 1969884512 19.385 100 72 145 2 2018098672 26728544 21485616
20:34:47 15378 8192000000 10926931520 11355463680 1971315648 19.396 100 59 116 0 2017471616 28675120 17480848
20:35:10 9918 8192000000 10932962464 11360047104 1974094736 19.418 100 58 117 4 2019749840 28361776 17293328
20:35:29 12954 8192000000 10934955520 11365777408 1978344576 19.452 100 61 119 1 2025343968 29441472 17557920
20:35:50 10289 8192000000 10927118896 11359313920 1963090592 19.331 99 53 106 1 2007058208 28555536 15412080
20:36:08 7033 8192000000 10941801824 11366285312 1981397840 19.476 100 61 122 1 2029034192 29909392 17726960
20:36:23 8141 8192000000 10956167728 11377725440 1988821440 19.534 100 71 142 1 2040744032 30960144 20962448
20:36:37 2808 8192000000 10965551136 11381952512 1992626432 19.565 100 67 133 0 2043189696 30827216 19736048
20:36:48 3399 8192000000 10949704336 11370201088 1972567904 19.406 99 81 162 0 2028044720 31943520 23533296
20:37:01 4191 8192000000 10950543728 11378003968 1988852256 19.535 100 69 138 2 2043080304 33692352 20535696
20:37:14 10455 8192000000 10935721200 11362983936 1975639184 19.430 100 63 126 0 2022785808 27589808 19556816
20:37:31 5312 8192000000 10940929920 11368738816 1979604112 19.462 100 62 123 0 2024600256 26819296 18176848
20:37:44 7535 8192000000 10946797136 11373125632 1987183616 19.522 100 72 142 0 2037276096 28544400 21548080
20:37:59 11561 8192000000 10947178144 11374239744 1991580800 19.556 100 73 146 0 2041903136 29159968 21162368
20:38:18 11616 8192000000 10955198752 11386482688 1994082848 19.576 100 69 137 1 2048849632 34766240 20000544
20:38:38 11467 8192000000 10965890144 11393056768 1992650592 19.565 100 58 116 1 2040733248 30704592 17378064
20:38:58 2608 8192000000 10965824128 11396083712 2000471104 19.626 100 60 120 2 2049732928 31181200 18080624
20:39:10 7668 8192000000 10971358256 11403780096 2004910432 19.661 100 65 128 1 2056028608 31638128 19480048
20:39:28 9485 8192000000 10959623600 11393638400 1994933680 19.583 100 61 120 1 2046064240 32955232 18175328
20:39:53 2284 8192000000 10952799904 11377549312 1979364736 19.460 99 79 156 1 2036569824 34181872 23023216
20:40:02 4103 8192000000 10975731776 11398688768 1997917232 19.606 100 76 149 1 2055769680 35468624 22383824
20:40:14 3703 8192000000 10975728368 11401822208 2003102720 19.647 100 70 136 2 2060037392 35469328 21465344
20:40:31 6263 8192000000 10954496096 11380424704 1969461152 19.381 99 66 132 3 2025848832 35198560 21189120
20:40:46 2226 8192000000 10963568720 11384668160 1982365920 19.483 100 81 162 0 2044274128 38096512 23811696
20:40:57 5842 8192000000 10949491152 11381567488 1980910656 19.472 100 70 140 1 2039890752 37594304 21385792
20:41:14 8207 8192000000 10942195824 11374579712 1982220944 19.482 100 61 121 2 2030618560 30169056 18228560
20:41:36 2342 8192000000 10969663168 11394916352 1996465056 19.595 100 70 139 3 2050226032 32857376 20903600
20:41:46 6463 8192000000 10963927360 11389566976 1992725792 19.565 100 75 149 1 2048152528 33150880 22275856
20:42:02 1488 8192000000 10977486336 11389775872 1992450608 19.563 100 91 181 1 2055219616 34718480 28050528
20:42:10 2141 8192000000 10947886272 11365490688 1965257312 19.348 99 88 176 0 2027525632 34933408 27334912
20:42:18 2615 8192000000 10938846064 11353477120 1956567904 19.279 99 87 173 0 2018402992 35318080 26517008
20:42:29 2216 8192000000 10947208848 11368091648 1974035264 19.417 100 78 153 1 2034402192 36172208 24194720
20:42:40 5868 8192000000 10940727952 11358617600 1965005888 19.346 100 78 156 0 2027516192 38459344 24050960
20:42:53 3770 8192000000 10951184016 11366313984 1970213568 19.387 100 85 168 1 2036449328 40764096 25471664
20:43:04 5863 8192000000 10958306768 11378225152 1979344560 19.460 100 79 157 3 2045489712 42380112 23765040
20:43:19 2888 8192000000 10968637600 11381858304 1983785936 19.495 100 91 182 1 2054301536 42923856 27591744
20:43:29 3737 8192000000 10971571040 11386134528 1985940208 19.512 100 83 164 3 2052349184 40738960 25670016
20:43:40 2383 8192000000 10978664032 11397976064 1992005664 19.560 100 72 144 1 2056914592 42079072 22829856
20:43:51 6577 8192000000 10975524032 11403927552 1996408384 19.594 100 77 154 2 2063838672 43083520 24346768
20:44:06 1582 8192000000 10984405936 11399778304 1990045312 19.544 100 78 158 4 2059648368 46225888 23377168
20:44:15 2235 8192000000 10962697104 11376369664 1965081504 19.346 99 79 158 2 2035450304 45868208 24500592
20:44:24 3453 8192000000 10973012864 11391684608 1984183216 19.498 100 85 170 1 2054724880 44305888 26235776
20:44:36 8271 8192000000 10958179632 11383607296 1965965392 19.353 99 66 132 0 2028606752 42638512 20002848
20:44:52 1581 8192000000 10968173712 11379593216 1970969776 19.393 99 84 168 1 2042119152 45385408 25763968
20:45:00 5088 8192000000 10978384304 11397668864 1984499360 19.500 100 83 165 0 2057425680 47553568 25372752
20:45:13 5069 8192000000 10985956160 11404791808 1989405072 19.539 100 75 150 0 2061890240 49069920 23415248
20:45:27 5268 8192000000 10980448704 11402928128 1988555872 19.532 100 75 150 2 2064213472 52101232 23556368
20:45:45 3241 8192000000 10963620624 11387744256 1952689008 19.248 98 64 123 0 2024542240 51879872 19973360
20:45:57 2878 8192000000 10981820080 11392249856 1977618816 19.446 100 79 157 1 2054930464 52578592 24733056
20:46:06 2772 8192000000 10990795792 11406069760 1987322528 19.523 100 83 164 0 2066296608 53469600 25504480
20:46:16 1176 8192000000 10959088480 11369050112 1955569072 19.271 99 86 172 2 2036935776 53890608 27476096
20:46:24 3189 8192000000 10973862192 11388383232 1979734144 19.463 100 86 172 0 2053699008 46637120 27327744
20:46:34 1587 8192000000 10975814864 11384528896 1976597696 19.438 100 85 167 1 2048476624 46071712 25807216
20:46:42 3290 8192000000 10942169648 11355455488 1942813248 19.169 98 79 157 0 2013445344 46277168 24354928
20:46:56 6175 8192000000 10957311920 11383230464 1967902160 19.369 100 66 130 1 2036025440 47361312 20761968
20:47:12 2702 8192000000 10981417456 11391746048 1983440640 19.492 100 92 181 1 2061079888 49482912 28156336
20:47:23 1229 8192000000 10985487312 11401822208 1986592464 19.517 100 86 172 1 2064695440 50904896 27198080
20:47:38 11633 8192000000 10953376912 11395780608 1967932384 19.369 99 46 91 2 2035582624 52433616 15216624
20:47:57 10770 8192000000 10960237200 11397509120 1963421744 19.333 99 45 87 1 2030002656 51767504 14813408
20:48:18 7258 8192000000 10960364624 11388997632 1977616864 19.446 100 50 100 0 2041896000 47617296 16661840
20:48:36 5809 8192000000 10967645168 11381243904 1970369536 19.388 100 75 146 2 2043319072 49542688 23406848
20:48:49 1954 8192000000 10978624912 11384647680 1971019680 19.394 100 89 177 1 2053279088 54674384 27585024
20:49:01 5668 8192000000 10973359376 11380088832 1951066336 19.235 99 92 181 1 2038944096 59471680 28406080
20:49:13 2285 8192000000 10967311632 11380551680 1957551952 19.287 100 87 174 1 2046290352 61038112 27700288
20:49:25 3173 8192000000 10953355104 11365318656 1946500272 19.199 100 82 163 3 2034926240 62514496 25911472
20:49:35 3727 8192000000 10970471600 11379716096 1958051792 19.291 100 85 169 2 2049619488 64670640 26897056
20:49:50 19056 8192000000 10911682432 11365273600 1917766512 18.969 98 45 90 1 1989510096 56681056 15062528
20:50:25 8983 8192000000 10912905696 11351367680 1934975728 19.107 100 42 84 1 2003054816 53433296 14645792
20:50:41 6487 8192000000 10931197472 11364859904 1940329664 19.149 100 43 86 2 2011358176 56268080 14760432
20:50:55 14667 8192000000 10912950032 11360964608 1930114176 19.068 100 38 76 2 2000273264 56919696 13239392
20:51:21 15141 8192000000 10928178512 11360178176 1938830080 19.137 100 42 84 1 2008319936 54483088 15006768
20:51:46 15804 8192000000 10935940944 11371270144 1943584848 19.175 100 36 72 2 2015277104 58823216 12869040
20:52:13 13378 8192000000 10924022928 11368493056 1945191552 19.188 100 34 68 1 2008930448 52186288 11552608
20:52:44 30926 8192000000 10919522080 11356831744 1935709584 19.113 100 26 51 1 1991419808 46449648 9260576
20:53:21 18975 8192000000 10903257200 11361083392 1936968736 19.123 100 29 58 0 1992566464 45883584 9714144
20:53:47 30039 8192000000 10908474832 11360538624 1933406480 19.094 100 21 42 2 1981055920 40405072 7244368
20:54:23 35209 8192000000 10895731136 11353751552 1916632848 18.960 100 18 36 0 1970928160 47464752 6830560
20:55:16 56204 8192000000 10874940048 11342651392 1882185920 18.683 98 19 38 0 1949851600 60537968 7127712
20:56:18 63784 8192000000 10848832144 11299524608 1877975408 18.649 98 6 12 0 1906367344 26106160 2285776
20:57:32 20089 8192000000 10868926784 11299991552 1916764256 18.961 99 37 74 1 1934186144 7004896 10416992
20:58:35 35852 8192000000 10860566112 11311792128 1911143824 18.916 99 11 23 2 1921820272 7676912 2999536
20:59:20 40834 8192000000 10845705792 11290800128 1844129776 18.374 95 16 32 0 1854265152 5988016 4147360
21:00:37 99553 8192000000 10866846368 11331080192 1912180704 18.924 99 5 10 2 1932292016 18811344 1299968
21:02:49 66036 8192000000 10883184176 11319185408 1906740608 18.880 98 31 61 1 1922640752 7393264 8506880
21:04:07 82725 8192000000 10897973136 11346128896 1941803808 19.161 99 29 57 4 1966515184 15754720 8956656
21:05:50 98573 8192000000 10904069952 11346337792 1953405168 19.254 100 34 69 2 1986896672 22379072 11112432
21:07:35 70444 8192000000 10897007664 11353866240 1944410640 19.182 99 25 50 1 1962858544 11606224 6841680
21:08:52 36947 8192000000 10909750656 11364970496 1973938688 19.417 100 41 83 1 1997101728 11389648 11773392
21:09:37 65561 8192000000 10908729040 11380924416 1977990944 19.449 100 16 32 1 1998767072 15865760 4910368
21:10:52 85224 8192000000 10921428080 11363667968 1940880528 19.154 98 15 30 1 1962649184 17249872 4518784
21:12:25 8357 8192000000 10914924464 11354722304 1953886000 19.257 99 62 124 1 1985248992 12541760 18821232
21:12:46 19146 8192000000 10901751248 11365752832 1971540064 19.398 100 36 72 0 1994989856 13505088 9944704
21:13:35 36036 8192000000 10942087040 11396681728 1968782864 19.376 99 38 77 0 1994425264 14663520 10978880
21:14:33 48613 8192000000 10923870896 11394506752 1966270816 19.356 99 33 66 0 1998099408 22031744 9796848
21:15:31 12918 8192000000 10925503648 11399897088 1985463456 19.508 100 24 48 0 2015579888 22326336 7790096
21:15:51 54667 8192000000 10903365136 11379703808 1942098528 19.163 98 11 22 0 1966799824 21448112 3253184
21:17:40 46063 8192000000 10893213712 11376074752 1973678640 19.415 100 16 32 0 1993308464 14549936 5079888
21:18:53 36686 8192000000 10893524944 11363090432 1957382704 19.285 99 22 44 1 1973821440 9417760 7020976
21:19:48 91843 8192000000 10918645824 11371552768 1959178032 19.300 99 21 42 1 1975781728 10404880 6198816
21:21:28 93784 8192000000 10881776352 11368075264 1932359280 19.086 97 26 52 2 1947910224 8451024 7099920
21:23:10 55901 8192000000 10888796864 11356573696 1902510784 18.846 96 8 16 0 1911553664 6769280 2273600
21:24:15 16086 8192000000 10897280944 11366240256 1979939664 19.464 100 48 95 2 2000880224 7592112 13348448
21:24:44 52975 8192000000 10873240864 11361202176 1960314544 19.309 99 28 55 2 1981809264 13527824 7966896
21:25:49 75431 8192000000 10887154736 11370500096 1947647136 19.208 99 9 18 1 1963517152 13209456 2660560
21:27:46 72302 8192000000 10882874352 11369533440 1958678880 19.296 99 18 36 0 1977530848 14434960 4417008
21:29:05 65517 8192000000 10876188688 11350179840 1901113072 18.835 96 12 24 1 1911266640 7498912 2654656
21:30:22 50290 8192000000 10886483120 11357351936 1919005680 18.979 97 16 32 3 1932501264 8738176 4757408
21:31:19 30320 8192000000 10904602512 11370893312 1943514240 19.175 98 25 50 1 1958045424 7851968 6679216
21:31:58 63655 8192000000 10861511952 11337166848 1874652928 18.622 95 36 72 0 1895260704 9824736 10783040
21:33:39 98589 8192000000 10867554352 11346022400 1822600384 18.199 93 18 36 1 1843940528 16396032 4944112
21:35:24 79260 8192000000 10878006432 11333029888 1869325728 18.579 96 17 35 0 1888284080 14103536 4854816
21:37:15 28927 8192000000 10839200528 11302191104 1895478736 18.790 98 41 81 0 1917653088 10232288 11942064
21:37:54 57825 8192000000 10847181808 11319144448 1908741680 18.897 99 15 30 0 1924105920 10963856 4400384
21:39:02 41969 8192000000 10863619552 11330105344 1898511088 18.814 98 14 28 1 1912552384 10008672 4032624
21:39:50 62072 8192000000 10854109872 11311144960 1861460992 18.515 96 30 60 1 1881476592 12268448 7747152
21:40:58 40237 8192000000 10858026304 11314053120 1908276880 18.893 99 22 44 0 1924461776 10132800 6052096
21:41:49 28826 8192000000 10861472512 11321081856 1914899888 18.946 99 37 73 2 1938256624 13246304 10110432
21:42:34 21640 8192000000 10877129680 11323281408 1929611024 19.064 100 44 88 2 1953018208 10383152 13024032
21:43:06 25121 8192000000 10847989360 11303198720 1873624032 18.614 97 29 58 0 1892227152 10579600 8023520
21:43:38 19321 8192000000 10867640624 11309244416 1906440272 18.878 99 38 76 0 1927006256 10119456 10446528
21:44:10 122978 8192000000 10836959504 11299782656 1832504240 18.280 95 32 64 1 1851920880 10001808 9414832
21:46:19 78422 8192000000 10856784016 11319123968 1892447072 18.765 98 25 50 1 1912442880 13217456 6778352
21:47:44 27653 8192000000 10853350112 11319848960 1912184384 18.924 99 24 48 0 1937898832 18759792 6954656
21:48:26 55981 8192000000 10848716464 11326943232 1928889136 19.058 100 19 38 0 1952577040 17380208 6307696
21:49:29 75545 8192000000 10848240080 11314647040 1917748032 18.969 99 12 23 0 1932656768 11315168 3593568
21:50:51 48848 8192000000 10861971696 11338313728 1938330048 19.133 100 8 16 1 1950816672 9821696 2664928
21:52:11 46862 8192000000 10861354464 11347853312 1933896240 19.098 100 7 14 0 1948034752 12146448 1992064
21:53:05 65554 8192000000 10855707744 11344252928 1902941248 18.850 98 10 20 0 1922266992 16194304 3131440
21:54:21 44499 8192000000 10862162304 11329196032 1906367040 18.877 98 15 31 0 1917880752 7189088 4324624
21:55:13 62399 8192000000 10875080832 11343503360 1919166480 18.980 98 28 56 1 1939196752 11675632 8354640
21:56:23 37604 8192000000 10891380400 11358752768 1957598608 19.287 100 29 58 2 1979283408 13236624 8448176
21:57:27 64274 8192000000 10904718064 11374546944 1972055792 19.402 100 24 50 0 1992264736 13596896 6612048
21:59:27 59208 8192000000 10871353392 11346841600 1914601632 18.944 97 15 28 2 1928971552 10430976 3938944
22:00:33 23998 8192000000 10902263584 11355537408 1965999696 19.354 100 34 68 2 1982890832 7487536 9403600
22:01:08 22932 8192000000 10909794928 11365715968 1952030560 19.243 99 38 76 1 1971991200 9543456 10417184
22:01:37 39551 8192000000 10914164896 11382697984 1980716768 19.470 100 37 74 0 2005181920 13879616 10585536
22:02:26 65677 8192000000 10893356608 11383275520 1954426752 19.262 99 15 30 0 1971421520 12881344 4113424
22:03:37 56585 8192000000 10906514176 11369213952 1907378704 18.886 96 17 34 1 1921307040 9118784 4809552
22:04:42 32090 8192000000 10935752480 11399356416 1978904448 19.456 100 39 78 1 2004469712 14800384 10764880
22:05:23 44253 8192000000 10899048592 11383701504 1921262352 18.997 97 11 22 0 1935913408 11540624 3110432
22:06:14 129355 8192000000 10900938016 11380490240 1900611632 18.831 96 11 22 1 1917105568 13219344 3274592
22:08:33 35506 8192000000 10907734464 11361193984 1963392832 19.333 99 32 64 0 1983676992 11124368 9159792
22:09:15 127546 8192000000 10908765264 11390885888 1965507600 19.350 99 24 48 0 1987255776 14554128 7194048
22:11:44 32609 8192000000 10917595104 11404070912 1990251520 19.546 100 23 46 1 2011683552 15233856 6198176
22:12:59 39093 8192000000 10891585216 11375968256 1948160208 19.212 98 12 24 0 1957664736 6418880 3085648
22:13:44 47735 8192000000 10891502240 11366334464 1944406048 19.182 98 19 37 2 1955468320 6353856 4708416
22:15:05 118661 8192000000 10879622752 11361746944 1866169936 18.553 94 15 30 0 1883946144 13669888 4106320
22:17:20 57277 8192000000 10883314240 11369381888 1957089360 19.283 100 14 28 0 1975499488 14467664 3942464
22:18:26 62881 8192000000 10877602160 11357638656 1917528800 18.967 97 14 28 0 1939321024 17405568 4386656
22:19:44 34364 8192000000 10881285088 11353931776 1940997600 19.155 99 17 34 1 1960919040 14827216 5094224
22:20:24 61564 8192000000 10880804880 11362562048 1924000976 19.019 98 18 36 1 1946298464 16810768 5486720
22:21:32 65455 8192000000 10901848176 11375333376 1913603184 18.936 97 24 48 0 1941020320 19862848 7554288
22:22:53 89404 8192000000 10887164688 11373244416 1902065744 18.843 97 15 30 0 1917343600 11164544 4113312
22:24:30 53403 8192000000 10875313104 11345661952 1892331840 18.765 96 13 26 0 1905820032 9162704 4325488
22:25:29 59916 8192000000 10897183632 11356479488 1927972320 19.051 98 35 70 2 1954073376 16289808 9811248
22:26:42 53502 8192000000 9338518320 9622327296 460295728 5.319 24 6 11 0 468400368 6517520 1587120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-04-2021 22:28:28 to 01-04-2021 22:29:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          244335
MON$OLDEST_ACTIVE               245470
MON$OLDEST_SNAPSHOT             245470
MON$NEXT_TRANSACTION            245470
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                       2045664
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.33430 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33430 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33430 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33430 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 ---
:32: 
:33: mscs-test-161.budzdorov.ru    Thu Apr  1 22:27:40 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Thu Apr  1 22:27:40 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Thu Apr  1 22:27:41 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
--- end of diff output ---

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

01.04.21 22:29:04. 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-04-01 22:29:07 No severe PSQL-related problems occured
01.04.21 22:29:08. End of report.