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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4793.92
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17049348 kB
MemAvailable 31447104 kB
Buffers 0 kB
Cached 14647776 kB
SwapCached 1764 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-15 22:27:38
DTS_END                         2021-06-15 22:27:38.0970
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/35838
TRN_ID                          242681
ATT_ID                          664
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: 9414.29 20269 1129715
customer order: creation 175.97 334 21116
customer order: refuse 15.07 328 1808
order to supplier: creation 45.22 1156 5426
order to supplier: removal 3.27 101761 392
invoice (draft): creation 46.45 3262 5574
invoice (draft): removal 54.79 673 6575
invoice accept: apply 41.58 16051 4989
invoice accept: cancel 50.02 717 6002
customer reserve: creation 3831.68 160 459801
customer reserve: removal 4841.57 54 580988
realization accept: apply 85.53 157 10264
realization accept: cancel 92.71 97 11125
payment from customer: creation 59.30 100 7116
payment from customer: removal 5.63 69 675
payment to supplier: creation 49.64 110 5957
payment to supplier: removal 3.70 43 444
service: total inventory turnovers 4.59 1088 551
service: total monetary turnovers 6.69 20 803
service: aggregate perf. data 0.88 22036 105
service: refresh index statistics 0.03 257156 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-06-2021 22:30:11 to 15-06-2021 22:30:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4984
TEST_TIME 2 4097
TEST_TIME 3 4620
TEST_TIME 4 4682
TEST_TIME 5 4730
TEST_TIME 6 4755
TEST_TIME 7 4724
TEST_TIME 8 4954
TEST_TIME 9 5115
TEST_TIME 10 5238
TEST_TIME 11 5776
TEST_TIME 12 6103
TEST_TIME 13 6332
TEST_TIME 14 6534
TEST_TIME 15 7063
TEST_TIME 16 7045
TEST_TIME 17 7025
TEST_TIME 18 7508
TEST_TIME 19 7494
TEST_TIME 20 7934
TEST_TIME 21 8121
TEST_TIME 22 8571
TEST_TIME 23 8747
TEST_TIME 24 9040
TEST_TIME 25 9505
TEST_TIME 26 9257
TEST_TIME 27 9743
TEST_TIME 28 10627
TEST_TIME 29 10715
TEST_TIME 30 10626
TEST_TIME 31 10548
TEST_TIME 32 10371
TEST_TIME 33 10544
TEST_TIME 34 10487
TEST_TIME 35 10538
TEST_TIME 36 10521
TEST_TIME 37 10423
TEST_TIME 38 10208
TEST_TIME 39 10196
TEST_TIME 40 10187
TEST_TIME 41 10081
TEST_TIME 42 10019
TEST_TIME 43 9922
TEST_TIME 44 9887
TEST_TIME 45 10023
TEST_TIME 46 10202
TEST_TIME 47 10080
TEST_TIME 48 10018
TEST_TIME 49 9920
TEST_TIME 50 9775
TEST_TIME 51 9785
TEST_TIME 52 9722
TEST_TIME 53 9686
TEST_TIME 54 9645
TEST_TIME 55 9784
TEST_TIME 56 9784
TEST_TIME 57 9763
TEST_TIME 58 9799
TEST_TIME 59 9799
TEST_TIME 60 9759
TEST_TIME 61 9932
TEST_TIME 62 9955
TEST_TIME 63 9909
TEST_TIME 64 9960
TEST_TIME 65 10039
TEST_TIME 66 10041
TEST_TIME 67 10005
TEST_TIME 68 9971
TEST_TIME 69 9908
TEST_TIME 70 9953
TEST_TIME 71 9898
TEST_TIME 72 9867
TEST_TIME 73 9806
TEST_TIME 74 9742
TEST_TIME 75 9705
TEST_TIME 76 9671
TEST_TIME 77 9665
TEST_TIME 78 9694
TEST_TIME 79 9642
TEST_TIME 80 9627
TEST_TIME 81 9707
TEST_TIME 82 9726
TEST_TIME 83 9760
TEST_TIME 84 9738
TEST_TIME 85 9763
TEST_TIME 86 9792
TEST_TIME 87 9758
TEST_TIME 88 9845
TEST_TIME 89 9825
TEST_TIME 90 9884
TEST_TIME 91 9894
TEST_TIME 92 9804
TEST_TIME 93 9732
TEST_TIME 94 9716
TEST_TIME 95 9653
TEST_TIME 96 9644
TEST_TIME 97 9655
TEST_TIME 98 9644
TEST_TIME 99 9609
TEST_TIME 100 9680
TEST_TIME 101 9683
TEST_TIME 102 9662
TEST_TIME 103 9636
TEST_TIME 104 9610
TEST_TIME 105 9708
TEST_TIME 106 9778
TEST_TIME 107 9753
TEST_TIME 108 9760
TEST_TIME 109 9750
TEST_TIME 110 9774
TEST_TIME 111 9753
TEST_TIME 112 9676
TEST_TIME 113 9648
TEST_TIME 114 9623
TEST_TIME 115 9622
TEST_TIME 116 9583
TEST_TIME 117 9559
TEST_TIME 118 9531
TEST_TIME 119 9482
TEST_TIME 120 9414

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-06-2021 22:30:14 to 15-06-2021 22:30:18.

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 1556595 1556595 0 0.00 0 23704 5 0 0
doc_list_biud 1556585 1556585 0 0.00 0 29262 25 0 0
sp_add_invoice_to_stock 5104 4989 115 2.25 33 204947 16051 0 115
sp_cancel_adding_invoice 6002 6002 0 0.00 5 74358 717 0 0
sp_cancel_client_order 1808 1808 0 0.00 4 9525 329 0 0
sp_cancel_customer_reserve 580988 580988 0 0.00 1 23544 54 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 4575 69 0 0
sp_cancel_pay_to_supplier 444 444 0 0.00 2 930 43 0 0
sp_cancel_supplier_invoice 6589 6575 14 0.21 2 15669 673 0 14
sp_cancel_supplier_order 392 392 0 0.00 6 935567 101762 0 0
sp_cancel_write_off 11125 11125 0 0.00 1 24042 98 0 0
sp_client_order 21116 21116 0 0.00 3 18351 334 0 0
sp_customer_reserve 459801 459801 0 0.00 0 40630 161 0 0
sp_fill_shopping_cart 32105 32105 0 0.00 1 16425 37 0 0
sp_fill_shopping_cart_clo_res 459800 459800 0 0.00 0 22212 12 0 0
sp_get_clo_for_invoice 4988 4988 0 0.00 0 22411 245 0 0
sp_kill_cost_storno 18246 18246 0 0.00 0 8836 46 0 0
sp_kill_qstorno_ret_qs2qd 1180068 1180068 0 0.00 0 24034 29 0 0
sp_kill_qty_storno 622132 622132 0 0.00 0 29260 63 0 0
sp_lock_selected_doc 21116 21116 0 0.00 0 8393 6 0 0
sp_make_cost_storno 28323 28323 0 0.00 0 16018 47 0 0
sp_multiply_rows_for_pdistr 28314 28314 0 0.00 0 7716 26 0 0
sp_multiply_rows_for_qdistr 21116 21116 0 0.00 0 16529 156 0 0
sp_pay_from_customer 7116 7116 0 0.00 4 10128 100 0 0
sp_pay_to_supplier 5957 5957 0 0.00 5 12773 111 0 0
sp_payment_common 13072 13072 0 0.00 1 12744 23 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 9516 305 0 0
sp_qd_handle_on_invoice_upd_sts 10984 10984 0 0.00 0 29258 301 0 0
sp_qd_handle_on_reserve_upd_sts 10260 10260 0 0.00 0 24289 51 0 0
sp_reserve_write_off 10264 10264 0 0.00 6 24299 158 0 0
sp_supplier_invoice 5574 5574 0 0.00 6 108406 3263 0 0
sp_supplier_order 5426 5426 0 0.00 5 30260 1156 0 0
srv_aggregate_perf_data 105 105 0 0.00 2423 400224 22037 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1267 153749 32550 0 0
srv_find_qd_qs_mism 1082269 1082269 0 0.00 0 23703 5 0 0
srv_make_invnt_saldo 551 551 0 0.00 46 69937 1088 0 0
srv_make_money_saldo 803 803 0 0.00 1 588 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 135068 534036 257157 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4989 4989 0 0.00 0 10047 156 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 1 3671 80 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 3460 14 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 2586 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 2844 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 444 444 0 0.00 0 1944 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 2532 18 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 23539 1774 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 9726 18 0 0
t$perf-norm:sp_client_order 21116 21116 0 0.00 0 10285 16 0 0
t$perf-norm:sp_customer_reserve 963 963 0 0.00 0 2420 8 0 0
t$perf-norm:sp_pay_from_customer 7116 7116 0 0.00 0 10818 12 0 0
t$perf-norm:sp_pay_to_supplier 5957 5957 0 0.00 0 5874 9 0 0
t$perf-norm:sp_reserve_write_off 10264 10264 0 0.00 0 5781 13 0 0
t$perf-norm:sp_supplier_invoice 5574 5574 0 0.00 0 15769 15 0 0
t$perf-norm:sp_supplier_order 5426 5426 0 0.00 0 6665 18 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 513 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 2299 17 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 5067 25 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 1138 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 62 17 0 0
v_add_invoice_to_stock 10194 9964 230 2.25 0 6407 18 0 230
v_all_customers 38424 38424 0 0.00 0 17 1 0 0
v_all_suppliers 30456 30456 0 0.00 0 24 1 0 0
v_all_wares 42226 42226 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 5343 15 0 0
v_cancel_client_order 3616 3616 0 0.00 0 2590 4 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 4541 9 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 4942 8 0 0
v_cancel_payment_to_supplier 888 888 0 0.00 0 246 3 0 0
v_cancel_supplier_invoice 846 818 28 3.30 0 591 12 0 28
v_cancel_supplier_order 784 784 0 0.00 0 2326 8 0 0
v_cancel_write_off 2076 2076 0 0.00 0 475 10 0 0
v_max_id_clo_ord 5426 5426 0 0.00 0 1722 1 0 0
v_max_id_clo_res 963 963 0 0.00 0 4079 17 0 0
v_max_id_ord_sup 5566 5566 0 0.00 0 6059 6 0 0
v_max_non_paid_invoice 1720 1720 0 0.00 0 108 2 0 0
v_max_non_paid_realizn 3771 3771 0 0.00 0 1978 4 0 0
v_min_id_clo_ord 5426 5426 0 0.00 0 1092 4 0 0
v_min_id_clo_res 963 963 0 0.00 0 593 2 0 0
v_min_id_ord_sup 5566 5566 0 0.00 0 5438 10 0 0
v_min_non_paid_invoice 5956 5956 0 0.00 0 12740 13 0 0
v_min_non_paid_realizn 7116 7116 0 0.00 0 5385 11 0 0
v_our_firm 10492 10492 0 0.00 0 25 1 0 0
v_reserve_write_off 20520 20520 0 0.00 0 4864 5 0 0
x_lock_depdocs_on_canc_invoice 12168 12168 0 0.00 0 14313 101 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 20720 475 0 0
x_make_qstorno_1000_1200 5426 5426 0 0.00 2 30251 1084 0 0
x_make_qstorno_1200_2000 5574 5574 0 0.00 2 99878 3118 0 0
x_make_qstorno_2100_3300 459801 459801 0 0.00 0 34814 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-06-2021 22:30:19 to 15-06-2021 22:30:23.

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:41 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:48 7587 8192000000 10134523776 10425290752 842386128 9.324 70 48 97 0 861788608 2592224 16810256
19:58:02 21893 8192000000 10286119344 10598699008 1328780304 13.956 100 76 153 0 1358646752 4041216 25825232
19:58:32 28521 8192000000 10358271008 10677358592 1412016816 14.702 100 83 166 1 1443673184 5264064 26392304
19:59:11 13905 8192000000 10385631632 10710233088 1432619168 14.884 100 84 168 0 1466340704 6406752 27314784
19:59:33 30523 8192000000 10419944528 10746896384 1471531040 15.227 100 87 173 0 1506416704 7297360 27588304
20:00:12 20488 8192000000 10427484992 10758918144 1486597296 15.359 100 90 180 1 1523517904 8230912 28689696
20:00:44 15018 8192000000 10450902720 10784464896 1507096576 15.538 100 86 172 0 1542599152 8860688 26641888
20:01:10 21031 8192000000 10474298032 10813345792 1529256480 15.731 100 91 182 1 1567934704 9695968 28982256
20:01:39 14560 8192000000 10485887856 10829189120 1544182352 15.860 100 89 178 0 1581608880 9852528 27574000
20:02:08 5724 8192000000 10499449536 10844393472 1559836912 15.995 100 83 166 0 1595816080 10399520 25579648
20:02:22 18674 8192000000 10527437232 10878160896 1574930032 16.125 100 70 140 1 1606591072 10545136 21115904
20:02:49 10856 8192000000 10554612688 10906476544 1603839392 16.372 100 78 156 1 1637936064 11022576 23074096
20:03:08 15852 8192000000 10569385120 10927226880 1626100880 16.562 100 84 168 0 1662848800 11932128 24815792
20:03:36 9238 8192000000 10586766688 10945961984 1645835888 16.729 100 86 172 0 1683215728 11817920 25561920
20:03:52 12476 8192000000 10596616048 10959392768 1657680192 16.829 100 77 152 3 1691680464 12296736 21703536
20:04:12 9895 8192000000 10620904960 10982268928 1679393744 17.012 100 85 167 2 1716481104 13031088 24056272
20:04:30 9584 8192000000 10640554272 11009024000 1700970800 17.193 100 88 176 1 1740428576 13910080 25547696
20:04:49 3914 8192000000 10647976240 11017494528 1710902848 17.276 100 80 159 3 1747685744 13021136 23761760
20:05:01 7374 8192000000 10662326256 11032342528 1722768816 17.375 100 85 170 0 1760925808 14184064 23972928
20:05:17 6039 8192000000 10675360944 11054227456 1735436880 17.481 100 77 154 2 1770494320 13242064 21815376
20:05:29 4257 8192000000 10682715968 11059204096 1746420336 17.572 100 80 158 0 1782869120 13086464 23362320
20:05:40 6586 8192000000 10684925872 11069145088 1751953632 17.618 100 69 138 1 1783816336 12590656 19272048
20:05:55 4294 8192000000 10698885424 11083935744 1767821648 17.749 100 79 158 1 1802536592 12373072 22341872
20:06:06 4155 8192000000 10715804256 11094122496 1776761584 17.823 100 76 152 1 1809693072 11741344 21190144
20:06:16 4014 8192000000 10713048272 11099860992 1781275776 17.860 100 79 158 0 1815412448 11454512 22682160
20:06:27 3582 8192000000 10729130992 11113975808 1790206288 17.933 100 83 163 0 1824607120 12139424 22261408
20:06:38 9407 8192000000 10737070608 11125391360 1802034640 18.031 100 80 157 2 1837434016 13323840 22075536
20:06:55 5920 8192000000 10756868208 11142131712 1807471632 18.075 100 82 164 1 1843259648 13070720 22717296
20:07:07 2891 8192000000 10770343232 11153584128 1824760656 18.217 100 89 176 0 1863499184 14299712 24438816
20:07:17 2487 8192000000 10777999824 11164487680 1836244160 18.310 100 89 178 1 1875456032 13950528 25261344
20:07:26 1991 8192000000 10786164768 11171069952 1841589664 18.354 100 96 192 1 1883343328 15106240 26647424
20:07:34 2114 8192000000 10784618496 11167526912 1848039184 18.406 100 90 177 1 1886445536 13294976 25111376
20:07:43 2198 8192000000 10787719728 11180621824 1845156672 18.383 100 75 149 0 1879908128 12726432 22025024
20:07:51 2227 8192000000 10792521680 11186393088 1857306848 18.481 100 90 180 2 1895040560 12424224 25309488
20:08:00 2040 8192000000 10806062656 11191500800 1860324960 18.506 100 83 167 2 1895119792 11450512 23344320
20:08:08 2256 8192000000 10803344112 11196010496 1860468880 18.507 100 78 155 1 1894346544 11792976 22084688
20:08:17 1642 8192000000 10818562912 11204239360 1868213536 18.570 100 96 192 0 1907895200 12351376 27330288
20:08:25 7529 8192000000 10806334464 11196878848 1865645680 18.549 100 70 140 2 1897885840 12611536 19628624
20:08:39 10188 8192000000 10812508496 11207327744 1869991952 18.584 100 72 145 1 1903976176 13671456 20312768
20:08:55 4133 8192000000 10801047984 11208437760 1873624784 18.614 100 70 140 1 1906009680 12652928 19731968
20:09:07 16293 8192000000 10815385968 11211169792 1874762368 18.623 100 69 138 0 1904441536 8827568 20851600
20:09:29 17888 8192000000 10767004912 11196899328 1868715536 18.574 100 30 60 0 1884110752 6925968 8469248
20:09:54 5265 8192000000 10785102624 11206369280 1872630960 18.606 100 40 80 0 1892226112 8132320 11462832
20:10:07 6397 8192000000 10789085376 11209707520 1874515040 18.621 100 33 66 3 1892015872 8198176 9302656
20:10:22 3068 8192000000 10799749744 11218272256 1881108576 18.674 100 36 72 1 1899597856 8628656 9860624
20:10:32 3394 8192000000 10799984688 11222966272 1882485072 18.685 100 36 71 1 1900858608 8479712 9893824
20:10:43 5625 8192000000 10790160048 11219214336 1881026704 18.673 100 21 41 2 1894050512 7209600 5814208
20:10:55 4978 8192000000 10795728032 11220635648 1884875520 18.704 100 34 69 1 1901055568 6639072 9540976
20:11:06 6057 8192000000 10796161824 11223605248 1887853024 18.728 100 30 60 0 1902601712 6821552 7927136
20:11:22 7440 8192000000 10788242752 11223146496 1887350272 18.724 100 25 50 0 1900767664 6159280 7258112
20:11:41 7681 8192000000 10795589088 11226779648 1888792480 18.736 100 26 52 0 1902176976 6266016 7118480
20:11:55 10490 8192000000 10793871968 11224322048 1886119904 18.714 100 11 22 0 1894995136 5917840 2957392
20:12:16 12184 8192000000 10789981936 11227496448 1891754320 18.760 100 24 48 2 1905867552 7335424 6777808
20:12:34 9074 8192000000 10800977296 11231506432 1891989504 18.762 100 12 24 0 1900813728 5512704 3311520
20:12:49 10871 8192000000 10794490944 11233796096 1892637360 18.767 100 16 32 0 1903330960 6345296 4348304
20:13:06 82175 8192000000 10810777296 11249127424 1898288464 18.813 100 33 65 1 1917824304 9585152 9950688
20:14:35 8678 8192000000 10811571648 11243712512 1896357760 18.797 100 22 44 3 1907907680 5724176 5825744
20:14:52 8066 8192000000 10825243552 11252953088 1903163968 18.852 100 30 60 1 1919291264 8020304 8106992
20:15:09 6870 8192000000 10827642768 11251589120 1900583200 18.831 100 25 50 1 1914957376 6989936 7384240
20:15:23 4639 8192000000 10813350704 11251113984 1903254672 18.852 100 25 50 2 1917067872 7283344 6529856
20:15:35 3114 8192000000 10827039968 11255431168 1902433280 18.846 100 40 80 1 1921526864 8170848 10922736
20:15:46 3945 8192000000 10810981712 11243704320 1896385792 18.797 100 33 66 0 1913018960 7855504 8777664
20:15:57 7655 8192000000 10795208560 11232051200 1879998384 18.665 99 17 35 0 1891140176 5608240 5533552
20:16:13 6198 8192000000 10812685232 11247218688 1898627072 18.815 100 35 70 4 1916407680 7502608 10278000
20:16:28 2889 8192000000 10833291936 11256532992 1905955760 18.874 100 35 70 0 1922131504 6673904 9501840
20:16:42 8296 8192000000 10821737120 11248369664 1900775696 18.833 100 21 43 1 1912729744 5626912 6327136
20:16:59 8184 8192000000 10795542368 11226021888 1865552704 18.548 98 15 30 1 1874755472 5413088 3789680
20:17:14 13255 8192000000 10782918064 11216535552 1843797504 18.372 97 12 24 1 1852169632 5185056 3187072
20:17:36 7553 8192000000 10786101920 11206467584 1826409584 18.230 97 18 36 0 1837031344 5737072 4884688
20:17:51 58883 8192000000 10789059312 11182227456 1729655376 17.433 92 43 86 0 1747224848 5095888 12473584
20:18:56 8003 8192000000 10742761984 11171151872 1813003568 18.120 98 29 58 0 1827209184 5172624 9032992
20:19:11 5051 8192000000 10767819856 11190595584 1844184304 18.375 100 26 52 1 1862402960 10417152 7801504
20:19:22 10856 8192000000 10763717248 11187990528 1804902560 18.054 97 28 56 3 1823512976 10303616 8306800
20:19:41 9017 8192000000 10737144080 11161522176 1798370576 18.001 97 19 38 0 1809338320 5875280 5092464
20:19:56 5449 8192000000 10711255136 11135541248 1762843056 17.708 96 24 47 0 1775228768 5664480 6721232
20:20:08 6848 8192000000 10717513296 11130400768 1772633568 17.789 98 23 46 2 1785312896 5356800 7322528
20:20:22 5605 8192000000 10675688736 11087097856 1692077328 17.119 95 32 64 1 1707167584 4977536 10112720
20:20:36 9150 8192000000 10673840624 11078160384 1703441488 17.214 96 21 42 3 1718657584 9460928 5755168
20:20:51 7069 8192000000 10678361152 11088809984 1737949408 17.502 98 26 52 2 1751756912 5995280 7812224
20:21:05 4260 8192000000 10694389424 11099140096 1742104480 17.536 98 31 60 1 1761540112 9825744 9609888
20:21:21 10225 8192000000 10690456784 11114373120 1728698304 17.425 96 25 48 3 1741571808 5675376 7198128
20:21:38 13222 8192000000 10699505776 11117314048 1738694288 17.508 97 14 28 1 1746599120 4677744 3227088
20:22:04 10157 8192000000 10701784032 11114786816 1730488016 17.440 96 22 44 3 1746180352 9392688 6299648
20:22:20 7701 8192000000 10728771120 11148902400 1810759216 18.102 100 18 36 0 1822131552 5430336 5942000
20:22:36 68417 8192000000 10733000016 11160145920 1794029168 17.965 98 36 72 1 1810211840 6421488 9761184
20:23:50 9445 8192000000 10739940624 11169005568 1833387792 18.287 100 20 40 4 1848423920 9743264 5292864
20:24:07 7865 8192000000 10734359872 11168047104 1818653328 18.167 99 24 48 1 1832201664 6150080 7398256
20:24:23 9631 8192000000 10758024224 11177218048 1838251104 18.327 100 32 64 0 1853829632 6675232 8903296
20:24:43 3742 8192000000 10765595904 11184902144 1848360752 18.409 100 43 87 0 1869269104 8902400 12005952
20:24:54 6167 8192000000 10762568336 11189985280 1848897168 18.413 100 26 50 1 1863314064 7240208 7176688
20:25:07 8709 8192000000 10758340672 11188699136 1850841648 18.429 100 22 45 1 1864218672 6456032 6920992
20:25:22 5684 8192000000 10765029024 11198222336 1855088448 18.463 100 25 50 1 1869090464 7310560 6691456
20:25:33 7562 8192000000 10777109472 11198214144 1857196464 18.481 100 27 56 2 1869734272 4625168 7912640
20:25:48 7403 8192000000 10769178592 11199803392 1857627600 18.484 100 25 50 0 1871261712 6279952 7354160
20:26:02 9202 8192000000 10773617856 11199090688 1858607376 18.492 100 20 39 3 1869499648 5435472 5456800
20:26:17 7655 8192000000 10767682592 11200040960 1859908832 18.503 100 19 38 1 1870837728 5586832 5342064
20:26:31 9139 8192000000 10774073184 11207643136 1861146512 18.513 100 17 34 0 1875997088 10071248 4779328
20:26:47 12348 8192000000 10770858512 11209125888 1864915856 18.543 100 15 30 1 1874610784 5714864 3980064
20:27:07 11100 8192000000 10794860816 11225964544 1884132864 18.698 100 19 37 1 1894518320 5229200 5156256
20:27:25 44259 8192000000 10827548016 11245182976 1894550528 18.782 100 33 66 0 1913807712 9076528 10180656
20:28:22 37992 8192000000 10844851152 11263361024 1917419024 18.966 100 57 114 0 1940641008 5190816 18031168
20:29:08 6791 8192000000 10854491968 11274412032 1922728224 19.009 100 58 116 0 1946909712 7124096 17057392
20:29:23 23312 8192000000 10852385472 11278794752 1925975488 19.035 100 53 106 3 1950123472 8153664 15994320
20:29:56 7994 8192000000 10858592240 11284910080 1932276080 19.085 100 43 86 0 1952926208 8710080 11940048
20:30:11 20715 8192000000 10881683472 11304554496 1939491120 19.143 100 48 95 3 1964755488 11933856 13330512
20:30:40 9381 8192000000 10877371776 11309948928 1948410784 19.214 100 50 102 0 1975350896 12188080 14752032
20:30:56 23164 8192000000 10895790848 11323813888 1957246112 19.284 100 56 111 0 1987024912 13761536 16017264
20:31:31 29923 8192000000 10896120336 11325198336 1957968192 19.290 100 44 88 1 1985727968 14370368 13389408
20:32:13 29180 8192000000 10886323312 11324645376 1961360432 19.317 100 34 67 1 1984811088 13390512 10060144
20:32:57 16136 8192000000 10912605808 11340533760 1971311696 19.396 100 53 106 0 2001501584 13931616 16258272
20:33:20 16039 8192000000 10910008752 11344850944 1975456688 19.429 100 48 96 0 2005922832 16536848 13929296
20:33:52 22592 8192000000 10916276080 11354546176 1978068480 19.449 100 38 74 1 2007019632 17892896 11058256
20:34:29 13433 8192000000 10916341152 11345887232 1962758032 19.328 99 50 100 0 1996002944 18436080 14808832
20:34:52 10905 8192000000 10914256320 11349147648 1974693328 19.423 100 53 106 0 2009363344 19174768 15495248
20:35:10 9540 8192000000 10931055280 11361353728 1984100224 19.497 100 53 106 2 2018011056 17732944 16177888
20:35:29 8410 8192000000 10931161776 11363692544 1986858272 19.519 100 47 93 0 2020171568 19298064 14015232
20:35:48 17959 8192000000 10927753408 11362504704 1974372016 19.420 99 50 100 1 2011506944 21500736 15634192
20:36:14 4526 8192000000 10935221696 11369533440 1993943040 19.575 100 44 88 3 2029177520 21703728 13530752
20:36:28 8125 8192000000 10926079904 11360690176 1981865024 19.479 100 50 99 2 2018307296 21364016 15078256
20:36:43 6707 8192000000 10944378032 11373993984 1989899184 19.543 100 56 112 1 2030398656 23540864 16958608
20:37:01 6351 8192000000 10953723632 11379294208 1995185712 19.585 100 64 128 1 2040476560 25678240 19612608
20:37:15 16303 8192000000 10939922240 11376287744 1991433632 19.555 100 51 102 3 2035446064 28540656 15471776
20:37:40 15524 8192000000 10965927056 11394039808 2002343136 19.641 100 63 127 1 2051289488 29052976 19893376
20:38:03 6022 8192000000 10972533936 11398475776 2008920256 19.693 100 57 113 3 2054970736 29312864 16737616
20:38:18 1454 8192000000 10964271840 11386744832 2000397424 19.626 100 68 134 1 2048522176 27547424 20577328
20:38:27 6411 8192000000 10951631776 11383410688 1986366416 19.515 99 68 137 2 2033760256 27302928 20090912
20:38:43 5319 8192000000 10955960080 11386322944 1999376416 19.618 100 66 132 0 2047682144 28755232 19550496
20:38:55 2119 8192000000 10951473648 11373875200 1975897648 19.432 99 84 168 1 2030376240 29174768 25303824
20:39:04 3915 8192000000 10957034864 11384049664 1992822192 19.566 100 65 127 1 2044226464 32120960 19283312
20:39:24 5733 8192000000 10963077216 11387797504 2001282880 19.633 100 74 147 3 2055682496 31290736 23108880
20:39:38 8021 8192000000 10957930608 11385896960 1992125312 19.561 100 57 114 0 2039337264 29461952 17750000
20:39:55 16731 8192000000 10966729552 11399196672 1996334368 19.594 100 57 111 4 2044993152 31629792 17028992
20:40:19 4209 8192000000 10958581776 11380367360 1976528208 19.437 99 65 130 0 2029138816 33159392 19451216
20:40:34 12246 8192000000 10946550896 11370807296 1948829872 19.217 98 60 119 1 1999260208 32648288 17782048
20:40:57 7129 8192000000 10946100864 11364184064 1956662224 19.280 99 72 144 0 2011727168 33580432 21484512
20:41:16 7481 8192000000 10953247344 11371941888 1963086352 19.331 99 71 141 3 2023002624 37656688 22259584
20:41:31 4193 8192000000 10913730448 11331346432 1923206400 19.013 98 75 149 1 1984144720 38092000 22846320
20:41:45 8262 8192000000 10928722256 11354009600 1960771008 19.312 100 68 136 0 2016365088 35318128 20275952
20:42:07 2898 8192000000 10957075664 11374051328 1979831840 19.463 100 83 162 2 2042315184 36767392 25715952
20:42:17 1988 8192000000 10963858624 11373916160 1978259456 19.451 100 89 179 2 2042593840 37729824 26604560
20:42:26 1265 8192000000 10958928208 11369525248 1976317184 19.436 100 86 172 1 2040852944 38875952 25659808
20:42:34 2976 8192000000 10940557088 11349311488 1949118544 19.219 99 83 166 0 2010822992 36454480 25249968
20:42:44 2118 8192000000 10934749216 11349737472 1959548928 19.302 100 80 156 1 2020421328 35957744 24914656
20:42:54 1275 8192000000 10937875888 11351633920 1960199296 19.308 100 80 159 0 2020747872 35946816 24601760
20:43:03 4918 8192000000 10916835472 11333808128 1932113152 19.084 99 70 140 1 1989554704 36052688 21388864
20:43:23 6893 8192000000 10916620864 11331022848 1935430704 19.110 99 71 139 2 1994641952 37210016 22001232
20:43:38 8162 8192000000 10927342400 11353321472 1955582976 19.271 100 67 131 1 2013760688 37310688 20867024
20:44:09 13979 8192000000 10927745824 11354902528 1957775584 19.288 100 55 110 0 2014660576 38813232 18071760
20:44:34 4725 8192000000 10933795888 11354718208 1958472208 19.294 100 60 121 1 2017880640 40135856 19272576
20:44:48 6492 8192000000 10934096320 11360796672 1959899872 19.305 100 61 122 0 2021604608 42550736 19154000
20:45:04 1931 8192000000 10950360800 11364442112 1960064800 19.307 100 71 142 1 2027829696 44854672 22910224
20:45:18 4029 8192000000 10956985136 11373891584 1968783744 19.376 100 60 118 2 2033016992 46190144 18043104
20:45:28 3945 8192000000 10953384320 11382104064 1972329040 19.404 100 58 116 0 2036996432 46200912 18466480
20:45:40 7329 8192000000 10951910608 11382157312 1972475584 19.405 100 56 109 0 2035763360 46089552 17198224
20:46:01 5862 8192000000 10941606320 11369693184 1954614544 19.263 99 55 110 0 2015111696 43084064 17413088
20:46:14 7647 8192000000 10926594848 11365203968 1947409696 19.206 99 43 86 1 2004730128 43258512 14061920
20:46:36 3806 8192000000 10935396048 11368460288 1964121296 19.339 100 47 94 0 2023527312 43705600 15700416
20:46:47 6643 8192000000 10945354352 11360989184 1945466080 19.190 99 71 141 2 2012249520 44714288 22069152
20:47:02 4221 8192000000 10955230640 11373096960 1972597680 19.406 100 69 139 0 2040415840 46171984 21646176
20:47:14 3685 8192000000 10973333744 11395125248 1983165664 19.490 100 72 144 2 2056719536 51055312 22498560
20:47:26 8479 8192000000 10961160432 11400130560 1980249616 19.467 100 43 86 0 2044389216 49864032 14275568
20:47:41 14300 8192000000 10948296912 11398295552 1982616688 19.485 100 37 72 1 2042963104 47746256 12600160
20:48:03 17637 8192000000 10941131120 11387981824 1961129728 19.315 99 35 70 0 2021416832 48318656 11968448
20:48:30 13762 8192000000 10933680192 11372593152 1939373168 19.142 98 43 87 1 2009678784 55575600 14730016
20:48:52 9772 8192000000 10940679488 11387887616 1962866880 19.329 100 39 78 1 2029559344 53114448 13578016
20:49:12 14354 8192000000 10926336800 11369988096 1951394688 19.238 100 34 69 2 2015847056 52942896 11509472
20:49:44 15723 8192000000 10917304576 11360595968 1936586240 19.120 99 34 67 1 1993728912 46125936 11016736
20:50:08 12498 8192000000 10903737408 11340742656 1912620256 18.928 98 37 73 3 1965031472 40551488 11859728
20:50:30 13523 8192000000 10912115872 11351883776 1922459456 19.007 99 32 64 2 1976785760 43496880 10829424
20:50:51 11844 8192000000 10913103424 11349508096 1923050144 19.011 99 37 74 1 1979746640 44783392 11913104
20:51:11 27435 8192000000 10910119584 11360092160 1943336320 19.173 100 29 58 2 2002544128 49139152 10068656
20:51:46 16065 8192000000 10916121104 11362463744 1945336416 19.189 100 28 56 0 2000696352 45942000 9417936
20:52:13 19286 8192000000 10910360464 11363672064 1945754240 19.193 100 27 54 1 2005465200 50204640 9506320
20:52:39 35955 8192000000 10904703552 11363794944 1911462352 18.918 98 19 36 1 1960870864 42274864 7133648
20:53:25 55436 8192000000 10891380560 11343544320 1897899328 18.809 98 20 40 1 1951066032 46110096 7056608
20:54:43 14309 8192000000 10885698368 11339100160 1931227168 19.077 100 27 53 1 1973299904 32995456 9077280
20:55:04 18975 8192000000 10870991104 11322527744 1880130176 18.666 98 18 35 2 1921609536 35374576 6104784
20:55:30 28165 8192000000 10844372176 11314388992 1872515776 18.605 98 20 39 2 1914925936 35347760 7062400
20:56:05 47594 8192000000 10839111120 11300282368 1889289824 18.740 99 14 28 2 1910585328 16956224 4339280
20:56:59 37784 8192000000 10849590288 11304341504 1872396336 18.604 98 8 16 1 1891107648 16711280 2000032
20:57:47 72128 8192000000 10847854352 11299356672 1851720496 18.436 96 21 41 0 1867022176 10182512 5119168
20:59:07 58873 8192000000 10872651216 11327090688 1930196384 19.068 100 16 32 2 1947936992 13211504 4529104
21:00:14 57066 8192000000 10864743936 11327397888 1903084032 18.851 98 17 34 2 1925241840 17125664 5032144
21:01:17 52134 8192000000 10889628576 11346161664 1948617664 19.215 100 17 34 2 1964178320 10692416 4868240
21:02:21 117910 8192000000 10879888896 11348987904 1900521008 18.830 97 9 18 1 1921257088 18096160 2639920
21:04:37 108396 8192000000 10909112704 11356340224 1942403744 19.166 99 30 60 0 1963175952 11473456 9298752
21:06:35 62549 8192000000 10909478880 11369054208 1969978208 19.385 100 31 62 2 1988210512 9274992 8957312
21:07:44 27568 8192000000 10900060848 11371974656 1981820432 19.479 100 38 75 2 2001486304 9518480 10147392
21:08:23 59710 8192000000 10918433728 11375644672 1981245264 19.475 100 21 41 1 1996231040 9049872 5935904
21:09:31 25393 8192000000 10923061984 11386265600 1974632448 19.422 99 41 83 1 2000207040 13284896 12289696
21:10:06 26667 8192000000 10916463296 11391905792 1991015280 19.552 100 22 44 1 2010411776 12267712 7128784
21:10:43 30110 8192000000 10928491824 11393368064 1974173008 19.419 99 21 42 3 1994386368 13730608 6482752
21:11:27 20631 8192000000 10960909216 11410124800 1996995472 19.599 100 46 94 2 2027522288 16716304 13810512
21:12:00 23259 8192000000 10965191088 11413823488 2001510560 19.635 100 51 101 4 2040362048 24573376 14278112
21:12:41 8742 8192000000 10962906000 11412766720 1999209552 19.616 100 49 98 0 2033376512 20423936 13743024
21:13:02 34216 8192000000 10919551584 11412717568 1993747536 19.573 100 23 46 0 2019687888 19508656 6431696
21:13:43 30091 8192000000 10914990912 11406999552 1989966928 19.544 100 5 10 0 2004050944 12934384 1149632
21:14:20 6402 8192000000 10898003776 11392208896 1951601824 19.239 98 5 7 0 1964471232 11996528 872880
21:14:32 2493 8192000000 10902387088 11388571648 1983700032 19.494 100 12 24 1 1997206448 10179184 3327232
21:15:04 41933 8192000000 10900867504 11373568000 1965457664 19.349 99 15 30 2 1979068272 9496800 4113808
21:16:17 33087 8192000000 10893721872 11373666304 1959645536 19.303 99 11 22 1 1975291440 12285280 3360624
21:18:31 12734 8192000000 10903559040 11388841984 1979829632 19.463 100 10 20 1 1993113072 10719392 2564048
21:18:50 23764 8192000000 10900471264 11371425792 1947735328 19.208 98 18 36 0 1960530096 8179408 4615360
21:19:24 73516 8192000000 10879399472 11362062336 1941622528 19.160 98 11 22 1 1956008208 11443168 2942512
21:21:07 70187 8192000000 10915987344 11392880640 1962216640 19.324 99 15 30 0 1982939104 16478144 4244320
21:22:27 78845 8192000000 10891151808 11356639232 1901878848 18.841 96 10 20 0 1913920368 8687056 3354464
21:23:58 34092 8192000000 10889318896 11357237248 1934126400 19.100 98 21 43 0 1949409536 9389440 5893696
21:24:41 42498 8192000000 10897316048 11364708352 1909990192 18.907 97 32 64 1 1930229568 11312704 8926672
21:25:40 43496 8192000000 10890108960 11363606528 1926604176 19.040 98 19 38 1 1944130112 12367792 5158144
21:26:35 51472 8192000000 10878404848 11336998912 1845449056 18.385 94 29 57 1 1864007872 10510176 8048640
21:27:33 34330 8192000000 10900039072 11371737088 1949685744 19.224 100 21 42 1 1969737216 14232880 5818592
21:28:20 45135 8192000000 10906534592 11373535232 1945289376 19.189 99 27 51 3 1963593248 10514752 7789120
21:29:14 37297 8192000000 10908520032 11363045376 1858767296 18.493 94 27 54 1 1874312096 8359424 7185376
21:29:58 40359 8192000000 10928827296 11385057280 1963207472 19.332 100 32 64 0 1988032448 15252864 9572112
21:31:10 50127 8192000000 10906768688 11390164992 1946979184 19.202 99 9 19 0 1971641552 21895440 2766928
21:32:10 67486 8192000000 10861611088 11329540096 1767784512 17.749 90 9 18 0 1784921408 15123632 2013264
21:33:26 80461 8192000000 10863800048 11333951488 1835109792 18.301 94 21 42 1 1855948048 14683856 6154400
21:34:53 83366 8192000000 10853803728 11321499648 1891270304 18.756 98 16 32 0 1908764752 12900624 4593824
21:36:46 96992 8192000000 10871117648 11352064000 1916442208 18.958 99 13 25 3 1935068192 14629648 3996336
21:38:39 38373 8192000000 10844447488 11325276160 1881563936 18.678 97 16 31 1 1893439568 7656784 4218848
21:39:30 54625 8192000000 10833989040 11302674432 1815200512 18.138 94 13 26 0 1826222240 7291792 3729936
21:40:36 75577 8192000000 10835940512 11306909696 1864128576 18.537 97 16 32 1 1880870496 11908640 4833280
21:42:01 80409 8192000000 10862220880 11340206080 1933586944 19.096 100 11 22 0 1951805120 14574368 3643808
21:43:32 66012 8192000000 10856465168 11332325376 1916445584 18.958 99 13 26 1 1933923376 13714224 3763568
21:45:02 34730 8192000000 10849192464 11315195904 1902754480 18.848 99 26 51 1 1921286800 11136592 7395728
21:45:50 60505 8192000000 10847917904 11331366912 1885472432 18.709 98 18 36 0 1907538912 16047152 6019328
21:46:58 64511 8192000000 10870486864 11338199040 1913126176 18.932 99 24 48 2 1935777616 15766160 6885280
21:48:09 61071 8192000000 10887296240 11359571968 1945601424 19.191 100 29 58 2 1971833504 18039424 8192656
21:49:17 54489 8192000000 10897840048 11362439168 1955924320 19.274 100 19 38 0 1972909616 12173008 4812288
21:50:18 17742 8192000000 10903629696 11371233280 1963670560 19.335 100 39 77 2 1988662464 13669568 11322336
21:51:00 19289 8192000000 10905739024 11358064640 1944571200 19.183 99 51 101 3 1969840720 10871968 14397552
21:51:36 27141 8192000000 10882428848 11339104256 1901098448 18.835 97 41 82 3 1925336416 11751088 12486880
21:52:13 67641 8192000000 10882750592 11341041664 1916489136 18.959 99 29 58 1 1937236384 12577376 8169872
21:53:30 23591 8192000000 10879053136 11340742656 1922700640 19.008 99 23 46 1 1938751568 9539008 6511920
21:54:04 38002 8192000000 10900106144 11360026624 1936182144 19.116 99 33 66 2 1961666512 16519504 8964864
21:54:48 49204 8192000000 10866359184 11349401600 1894381072 18.781 97 27 54 0 1922738592 20659792 7697728
21:55:46 45619 8192000000 10880536048 11355021312 1948270624 19.213 100 14 28 1 1963965536 12114960 3579952
21:56:42 79284 8192000000 10895312848 11376766976 1907459200 18.886 97 28 56 0 1929008640 13721968 7827472
21:58:07 142462 8192000000 10872799296 11350405120 1945782752 19.193 99 13 26 1 1965860624 16200720 3877152
22:00:36 24875 8192000000 10901423472 11370717184 1967985776 19.369 100 31 62 3 1988260272 11598688 8675808
22:01:20 35704 8192000000 10894536496 11375435776 1976461264 19.437 100 15 30 2 1989644208 9403136 3779808
22:02:02 36211 8192000000 10896550352 11377328128 1964520240 19.342 99 11 22 1 1978075296 10442272 3112784
22:05:03 83398 8192000000 10899898048 11369431040 1894479232 18.782 96 12 24 0 1909733792 12076512 3178048
22:06:37 43579 8192000000 10890113648 11366416384 1951656080 19.240 99 23 46 1 1969129376 10829008 6644288
22:07:26 81834 8192000000 10899267824 11386277888 1962224000 19.324 99 15 30 2 1979847008 13006192 4616816
22:08:54 31731 8192000000 10911506448 11383406592 1944765088 19.185 98 32 62 0 1961631552 7947744 8918720
22:09:33 45780 8192000000 10905030960 11369439232 1933900128 19.098 98 23 46 0 1951003984 10966736 6137120
22:11:03 34082 8192000000 10905431568 11371229184 1938015856 19.131 98 28 56 0 1959121808 13221616 7884336
22:11:55 48034 8192000000 10888698480 11385802752 1936433824 19.118 99 14 28 3 1959893680 18598512 4861344
22:12:56 119479 8192000000 10881404000 11362529280 1906812880 18.881 97 7 14 1 1927290016 18563840 1913296
22:15:01 59969 8192000000 10900196592 11385528320 1966401808 19.357 100 17 34 1 1987556960 16206000 4949152
22:16:09 153749 8192000000 10899920288 11389591552 1928457040 19.055 97 15 30 0 1948930720 16317952 4155728
22:18:51 86734 8192000000 10847654864 11316797440 1851590752 18.435 94 14 28 0 1865195408 10125648 3479008
22:20:25 82562 8192000000 10867300560 11347050496 1891913072 18.761 97 14 28 1 1906463968 9872896 4678000
22:21:54 14462 8192000000 10862863568 11349491712 1942417648 19.166 100 9 18 0 1956702064 11689600 2594816
22:22:17 12309 8192000000 10847283536 11334971392 1903471136 18.854 98 9 18 1 1917486048 11651424 2363488
22:23:00 46097 8192000000 10845667536 11333701632 1914538816 18.943 99 18 35 1 1928243616 8692464 5012336
22:23:54 32490 8192000000 10855971648 11331174400 1915192880 18.948 99 14 29 0 1925727216 6598048 3936288
22:25:06 67690 8192000000 10872137536 11335864320 1876644000 18.638 96 12 24 1 1889161872 8773952 3743920
22:26:22 89688 8192000000 10024681936 10418409472 1147091600 12.282 59 5 8 1 1156732416 8194624 1446192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-06-2021 22:30:24 to 15-06-2021 22:30:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-06-2021 22:30:57 to 15-06-2021 22:30:59.

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          242981
MON$OLDEST_ACTIVE               242982
MON$OLDEST_SNAPSHOT             242982
MON$NEXT_TRANSACTION            242982
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                       2056032
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Tue Jun 15 22:28:26 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
--- end of diff output ---

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

15.06.21 22:31:00. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-06-15 22:31:02 No severe PSQL-related problems occured
15.06.21 22:31:03. End of report.