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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-10 01:27:02
DTS_END                         2020-11-10 01:27:02.0110
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33132
TRN_ID                          249080
ATT_ID                          689
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: 9398.28 22542 1127794
customer order: creation 173.40 336 20808
customer order: refuse 15.36 349 1843
order to supplier: creation 47.64 1228 5717
order to supplier: removal 3.47 106035 416
invoice (draft): creation 47.83 3421 5740
invoice (draft): removal 54.26 757 6511
invoice accept: apply 43.41 17828 5209
invoice accept: cancel 49.00 760 5880
customer reserve: creation 3933.56 179 472027
customer reserve: removal 4722.45 61 566694
realization accept: apply 84.99 176 10199
realization accept: cancel 89.03 116 10684
payment from customer: creation 61.76 117 7411
payment from customer: removal 6.06 87 727
payment to supplier: creation 49.69 127 5963
payment to supplier: removal 3.56 66 427
service: total inventory turnovers 4.79 1057 575
service: total monetary turnovers 7.19 22 863
service: aggregate perf. data 0.80 22322 96
service: refresh index statistics 0.03 295803 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-11-2020 01:28:26 to 10-11-2020 01:28:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3169
TEST_TIME 2 3941
TEST_TIME 3 4096
TEST_TIME 4 3904
TEST_TIME 5 4115
TEST_TIME 6 4311
TEST_TIME 7 4973
TEST_TIME 8 5395
TEST_TIME 9 6242
TEST_TIME 10 6402
TEST_TIME 11 6301
TEST_TIME 12 6675
TEST_TIME 13 6900
TEST_TIME 14 6968
TEST_TIME 15 7023
TEST_TIME 16 7602
TEST_TIME 17 7480
TEST_TIME 18 7957
TEST_TIME 19 8174
TEST_TIME 20 8258
TEST_TIME 21 8698
TEST_TIME 22 8739
TEST_TIME 23 9085
TEST_TIME 24 9220
TEST_TIME 25 8988
TEST_TIME 26 9384
TEST_TIME 27 9531
TEST_TIME 28 9745
TEST_TIME 29 10958
TEST_TIME 30 10979
TEST_TIME 31 10898
TEST_TIME 32 10706
TEST_TIME 33 10593
TEST_TIME 34 10751
TEST_TIME 35 10709
TEST_TIME 36 10718
TEST_TIME 37 10606
TEST_TIME 38 10454
TEST_TIME 39 10335
TEST_TIME 40 10139
TEST_TIME 41 10179
TEST_TIME 42 10133
TEST_TIME 43 10017
TEST_TIME 44 9960
TEST_TIME 45 9873
TEST_TIME 46 9791
TEST_TIME 47 9964
TEST_TIME 48 9905
TEST_TIME 49 9871
TEST_TIME 50 10010
TEST_TIME 51 9886
TEST_TIME 52 9936
TEST_TIME 53 9900
TEST_TIME 54 9999
TEST_TIME 55 9940
TEST_TIME 56 9991
TEST_TIME 57 10019
TEST_TIME 58 9930
TEST_TIME 59 10019
TEST_TIME 60 9966
TEST_TIME 61 10038
TEST_TIME 62 10126
TEST_TIME 63 10100
TEST_TIME 64 10163
TEST_TIME 65 10211
TEST_TIME 66 10093
TEST_TIME 67 10049
TEST_TIME 68 10045
TEST_TIME 69 9952
TEST_TIME 70 9893
TEST_TIME 71 9946
TEST_TIME 72 9880
TEST_TIME 73 9941
TEST_TIME 74 9863
TEST_TIME 75 9807
TEST_TIME 76 9788
TEST_TIME 77 9731
TEST_TIME 78 9692
TEST_TIME 79 9745
TEST_TIME 80 9680
TEST_TIME 81 9647
TEST_TIME 82 9643
TEST_TIME 83 9640
TEST_TIME 84 9627
TEST_TIME 85 9601
TEST_TIME 86 9668
TEST_TIME 87 9742
TEST_TIME 88 9719
TEST_TIME 89 9762
TEST_TIME 90 9759
TEST_TIME 91 9768
TEST_TIME 92 9775
TEST_TIME 93 9771
TEST_TIME 94 9769
TEST_TIME 95 9763
TEST_TIME 96 9685
TEST_TIME 97 9660
TEST_TIME 98 9600
TEST_TIME 99 9591
TEST_TIME 100 9564
TEST_TIME 101 9541
TEST_TIME 102 9525
TEST_TIME 103 9475
TEST_TIME 104 9442
TEST_TIME 105 9401
TEST_TIME 106 9382
TEST_TIME 107 9423
TEST_TIME 108 9403
TEST_TIME 109 9372
TEST_TIME 110 9391
TEST_TIME 111 9425
TEST_TIME 112 9459
TEST_TIME 113 9471
TEST_TIME 114 9452
TEST_TIME 115 9492
TEST_TIME 116 9515
TEST_TIME 117 9511
TEST_TIME 118 9501
TEST_TIME 119 9477
TEST_TIME 120 9398

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-11-2020 01:28:29 to 10-11-2020 01:28:33.

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 1564172 1564172 0 0.00 0 21767 6 0 0
doc_list_biud 1564172 1564172 0 0.00 0 56976 28 0 0
sp_add_invoice_to_stock 5345 5209 136 2.54 32 190470 17829 0 136
sp_cancel_adding_invoice 5880 5880 0 0.00 4 73532 761 0 0
sp_cancel_client_order 1843 1843 0 0.00 4 10777 349 0 0
sp_cancel_customer_reserve 566694 566694 0 0.00 1 56979 62 0 0
sp_cancel_pay_from_customer 727 727 0 0.00 3 5820 87 0 0
sp_cancel_pay_to_supplier 427 427 0 0.00 2 5116 66 0 0
sp_cancel_supplier_invoice 6521 6511 10 0.15 2 17593 757 0 10
sp_cancel_supplier_order 416 416 0 0.00 6 873678 106036 0 0
sp_cancel_write_off 10684 10684 0 0.00 1 7607 117 0 0
sp_client_order 20808 20808 0 0.00 3 54954 337 0 0
sp_customer_reserve 472027 472027 0 0.00 0 90130 180 0 0
sp_fill_shopping_cart 32222 32222 0 0.00 1 22496 38 0 0
sp_fill_shopping_cart_clo_res 472027 472027 0 0.00 0 30096 13 0 0
sp_get_clo_for_invoice 5209 5209 0 0.00 0 32966 303 0 0
sp_kill_cost_storno 17718 17718 0 0.00 0 21698 58 0 0
sp_kill_qstorno_ret_qs2qd 1150999 1150999 0 0.00 0 56974 33 0 0
sp_kill_qty_storno 607436 607436 0 0.00 0 56976 71 0 0
sp_lock_selected_doc 21379 21379 0 0.00 0 10100 5 0 0
sp_make_cost_storno 28782 28782 0 0.00 0 19934 60 0 0
sp_multiply_rows_for_pdistr 28782 28782 0 0.00 0 6400 27 0 0
sp_multiply_rows_for_qdistr 20808 20808 0 0.00 0 54926 142 0 0
sp_pay_from_customer 7411 7411 0 0.00 4 10620 118 0 0
sp_pay_to_supplier 5963 5963 0 0.00 5 11884 127 0 0
sp_payment_common 13374 13374 0 0.00 1 11420 32 0 0
sp_qd_handle_on_cancel_clo 1843 1843 0 0.00 0 10770 322 0 0
sp_qd_handle_on_invoice_upd_sts 11089 11089 0 0.00 0 18901 325 0 0
sp_qd_handle_on_reserve_upd_sts 10199 10199 0 0.00 0 11162 61 0 0
sp_reserve_write_off 10199 10199 0 0.00 6 11372 177 0 0
sp_supplier_invoice 5740 5740 0 0.00 7 97524 3421 0 0
sp_supplier_order 5717 5717 0 0.00 5 36354 1228 0 0
srv_aggregate_perf_data 96 96 0 0.00 2278 246711 22322 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1044 138019 31541 0 0
srv_find_qd_qs_mism 1078560 1078560 0 0.00 0 12942 6 0 0
srv_make_invnt_saldo 575 575 0 0.00 36 52834 1057 0 0
srv_make_money_saldo 863 863 0 0.00 0 801 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 151890 433048 295804 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 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 5209 5209 0 0.00 0 15727 155 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 8373 106 0 0
t$perf-norm:sp_cancel_client_order 1843 1843 0 0.00 0 5568 23 0 0
t$perf-norm:sp_cancel_customer_reserve 718 718 0 0.00 0 2719 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 727 727 0 0.00 0 781 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 427 427 0 0.00 0 2585 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 1270 23 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 23703 1618 0 0
t$perf-norm:sp_cancel_write_off 1043 1043 0 0.00 0 2151 6 0 0
t$perf-norm:sp_client_order 20808 20808 0 0.00 0 7375 17 0 0
t$perf-norm:sp_customer_reserve 1038 1038 0 0.00 0 1073 5 0 0
t$perf-norm:sp_pay_from_customer 7411 7411 0 0.00 0 8936 10 0 0
t$perf-norm:sp_pay_to_supplier 5963 5963 0 0.00 0 5290 10 0 0
t$perf-norm:sp_reserve_write_off 10199 10199 0 0.00 0 7129 10 0 0
t$perf-norm:sp_supplier_invoice 5740 5740 0 0.00 0 8618 20 0 0
t$perf-norm:sp_supplier_order 5717 5717 0 0.00 0 6051 16 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 120 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 773 12 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 887 18 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 1998 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 74 21 0 0
v_add_invoice_to_stock 10690 10418 272 2.54 0 10108 19 0 272
v_all_customers 38364 38364 0 0.00 0 116 1 0 0
v_all_suppliers 31212 31212 0 0.00 0 14 1 0 0
v_all_wares 41616 41616 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 1802 9 0 0
v_cancel_client_order 3686 3686 0 0.00 0 3130 5 0 0
v_cancel_customer_prepayment 1454 1454 0 0.00 0 3130 9 0 0
v_cancel_customer_reserve 1436 1436 0 0.00 0 1061 4 0 0
v_cancel_payment_to_supplier 854 854 0 0.00 0 1062 5 0 0
v_cancel_supplier_invoice 824 804 20 2.42 0 2267 19 0 20
v_cancel_supplier_order 832 832 0 0.00 0 10068 21 0 0
v_cancel_write_off 2086 2086 0 0.00 0 2865 16 0 0
v_max_id_clo_ord 5717 5717 0 0.00 0 22401 5 0 0
v_max_id_clo_res 1038 1038 0 0.00 0 3127 20 0 0
v_max_id_ord_sup 5697 5697 0 0.00 0 7015 5 0 0
v_max_non_paid_invoice 1771 1771 0 0.00 0 138 2 0 0
v_max_non_paid_realizn 3909 3909 0 0.00 0 5814 8 0 0
v_min_id_clo_ord 5717 5717 0 0.00 0 1468 5 0 0
v_min_id_clo_res 1038 1038 0 0.00 0 10688 20 0 0
v_min_id_ord_sup 5697 5697 0 0.00 0 6756 6 0 0
v_min_non_paid_invoice 5963 5963 0 0.00 0 11416 21 0 0
v_min_non_paid_realizn 7411 7411 0 0.00 0 7854 17 0 0
v_our_firm 10256 10256 0 0.00 0 12 1 0 0
v_reserve_write_off 20398 20398 0 0.00 0 6351 5 0 0
x_lock_depdocs_on_canc_invoice 11989 11989 0 0.00 0 33181 119 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 14014 427 0 0
x_make_qstorno_1000_1200 5717 5717 0 0.00 1 36346 1151 0 0
x_make_qstorno_1200_2000 5740 5740 0 0.00 3 85745 3262 0 0
x_make_qstorno_2100_3300 472027 472027 0 0.00 0 90129 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-11-2020 01:28:34 to 10-11-2020 01:28:38.

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
22:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:11 14850 8192000000 10193495392 10496561152 725695440 8.137 58 39 81 1 739798576 1881152 12221984
22:57:34 34539 8192000000 10326398352 10643611648 1366852352 14.299 100 86 171 1 1398316240 4304448 27159440
22:58:18 37421 8192000000 10377295520 10696691712 1427595200 14.840 100 91 182 0 1464917136 7300048 30021888
22:59:13 13389 8192000000 10392397888 10715553792 1444148432 14.986 100 90 180 1 1482210480 8126544 29935504
22:59:37 25683 8192000000 10414939840 10743234560 1455335552 15.085 100 86 171 1 1491645440 8233184 28076704
23:00:12 13598 8192000000 10433175600 10762465280 1474988496 15.257 100 88 176 0 1512362112 8934288 28439328
23:00:39 21394 8192000000 10458831456 10792345600 1510355488 15.566 100 88 176 1 1547541936 9800032 27386416
23:01:18 9959 8192000000 10471475488 10814062592 1531062400 15.746 100 80 158 1 1565825888 10339760 24423728
23:01:37 14577 8192000000 10506569664 10851495936 1558719952 15.985 100 81 163 3 1594532048 11115408 24696688
23:01:59 15430 8192000000 10529678608 10883493888 1579966096 16.168 100 80 160 0 1615982784 11198176 24818512
23:02:35 10976 8192000000 10555571088 10913824768 1612538720 16.446 100 77 153 1 1647772112 11801888 23431504
23:02:58 9108 8192000000 10580210768 10941509632 1638807424 16.670 100 77 153 1 1673879312 12221776 22850112
23:03:15 5229 8192000000 10600403520 10959040512 1653817024 16.797 100 86 170 3 1691457792 12513856 25126912
23:03:27 10060 8192000000 10597062768 10964766720 1665324016 16.894 100 78 155 1 1700075072 12279392 22471664
23:03:45 9152 8192000000 10635128256 10996826112 1678674128 17.006 100 84 167 1 1715922464 12844096 24404240
23:04:04 12805 8192000000 10650960448 11023298560 1704649584 17.224 100 85 168 1 1742265680 13177168 24438928
23:04:24 7100 8192000000 10659450288 11034206208 1720466816 17.356 100 85 169 0 1757607840 13485760 23655264
23:04:39 6110 8192000000 10664586192 11041529856 1730760272 17.442 100 82 162 4 1766938720 12982160 23196288
23:04:51 6743 8192000000 10686951056 11061170176 1745522624 17.564 100 84 168 1 1782789776 13476160 23790992
23:05:05 2832 8192000000 10689774640 11067142144 1755853296 17.650 100 83 166 1 1792266720 12953040 23460384
23:05:16 4795 8192000000 10700640528 11079868416 1763308960 17.712 100 78 155 0 1799090816 13598624 22183232
23:05:28 3313 8192000000 10712718704 11087224832 1768261536 17.753 100 75 147 1 1801689968 12940704 20487728
23:05:38 2991 8192000000 10705466784 11091439616 1775134960 17.809 100 75 142 2 1808023712 12482480 20406272
23:05:48 3237 8192000000 10717736592 11099385856 1784030352 17.883 100 85 165 6 1820957088 13820368 23106368
23:05:58 3764 8192000000 10732169984 11112374272 1793675136 17.962 100 91 182 2 1834586720 15510208 25401376
23:06:08 2714 8192000000 10741983712 11119538176 1794629680 17.970 100 85 170 1 1832504272 14095936 23778656
23:06:17 8097 8192000000 10727462992 11109535744 1798374064 18.001 100 85 169 2 1836776912 15372672 23030176
23:06:34 6145 8192000000 10742738464 11130802176 1808826224 18.086 100 84 167 0 1846656560 15073120 22757216
23:06:47 2248 8192000000 10766756400 11146764288 1820044992 18.178 100 86 168 1 1857454544 13694400 23715152
23:06:56 1970 8192000000 10767684480 11151626240 1825059360 18.219 100 92 180 3 1864670304 14178800 25432144
23:07:04 2264 8192000000 10780220640 11162853376 1830909440 18.267 100 95 191 4 1872390720 14429664 27051616
23:07:13 1844 8192000000 10778594432 11167576064 1840893984 18.348 100 91 180 0 1880343504 13182688 26266832
23:07:21 1938 8192000000 10787231408 11170877440 1839241856 18.335 100 94 183 2 1878216832 13250304 25724672
23:07:29 2340 8192000000 10784916960 11169857536 1844704048 18.379 100 91 182 1 1883701888 13566896 25430944
23:07:38 2437 8192000000 10788119440 11173306368 1845879232 18.389 100 87 174 1 1884630624 13701712 25049680
23:07:47 1776 8192000000 10800991344 11185479680 1853522496 18.451 100 98 198 0 1895696880 14745056 27429328
23:07:55 1776 8192000000 10798273808 11183722496 1855805248 18.469 100 97 194 2 1897767072 14597136 27364688
23:08:04 1381 8192000000 10808788800 11192913920 1861373248 18.514 100 95 190 0 1900404896 13009840 26021808
23:08:11 1179 8192000000 10808236032 11196301312 1858288576 18.489 100 92 186 2 1902303936 17895888 26119472
23:08:20 40423 8192000000 10798995200 11189997568 1856977504 18.479 100 75 151 4 1888248384 8566016 22704864
23:09:06 1513 8192000000 10813368704 11202469888 1868977296 18.576 100 92 185 3 1906217936 10270944 26969696
23:09:15 5220 8192000000 10811533776 11210280960 1869633328 18.581 100 80 160 0 1903706080 11231888 22840864
23:09:26 12290 8192000000 10779695264 11195949056 1862855760 18.526 100 36 72 1 1881876160 9203088 9817312
23:09:48 5197 8192000000 10795469824 11205840896 1869671600 18.582 100 45 90 1 1892000192 8813344 13515248
23:09:59 6660 8192000000 10784450912 11209732096 1871004800 18.592 100 23 46 0 1888226544 10928592 6293152
23:10:16 7037 8192000000 10798199792 11214450688 1872942528 18.608 100 25 49 1 1887027472 6917488 7167456
23:10:32 8676 8192000000 10783984784 11216035840 1876706016 18.638 100 24 47 2 1889482000 6119552 6656432
23:10:50 7896 8192000000 10785518144 11221778432 1884684688 18.703 100 28 56 0 1902762960 10152800 7925472
23:11:05 8750 8192000000 10786571024 11219738624 1886066160 18.714 100 21 42 2 1897896176 6091200 5738816
23:11:20 13199 8192000000 10796945200 11232088064 1885193008 18.707 100 8 16 0 1896850368 9801840 1855520
23:11:40 9583 8192000000 10796765280 11229184000 1888378992 18.733 100 10 20 1 1896752928 5814048 2559888
23:11:56 9536 8192000000 10795747280 11229483008 1888125856 18.731 100 6 12 1 1895644352 5709488 1809008
23:12:12 12511 8192000000 10794478128 11229749248 1891089392 18.755 100 22 45 0 1903294016 5981680 6222944
23:12:32 10853 8192000000 10799278528 11230748672 1890568160 18.750 100 19 36 4 1901993664 5649008 5776496
23:12:50 45213 8192000000 10820380336 11243814912 1896108960 18.795 100 35 70 1 1911786368 5680464 9996944
23:13:49 12240 8192000000 10852125328 11255439360 1907197440 18.884 100 72 143 0 1935413056 6628304 21587312
23:14:08 6372 8192000000 10815080448 11250298880 1899475088 18.822 100 27 54 1 1919319312 12396288 7447936
23:14:21 6221 8192000000 10819729616 11249360896 1904738496 18.864 100 35 70 1 1919521680 5354576 9428608
23:14:37 9707 8192000000 10818573840 11249291264 1902103360 18.843 100 28 56 1 1920254576 10363952 7787264
23:14:55 10433 8192000000 10796935312 11228848128 1865409680 18.547 98 26 52 0 1879323792 6063168 7850944
23:15:14 5464 8192000000 10808776336 11244466176 1893226400 18.772 100 22 44 1 1904489344 5634144 5628800
23:15:30 7456 8192000000 10816670480 11250151424 1900729856 18.832 100 25 50 0 1913911392 5581760 7599776
23:15:44 6863 8192000000 10816230400 11255922688 1906123600 18.876 100 29 58 6 1921036384 6161712 8751072
23:15:58 6384 8192000000 10800344160 11236065280 1855398592 18.466 98 19 37 1 1872032320 11296272 5337456
23:16:10 4889 8192000000 10801692560 11240345600 1878438272 18.652 99 28 56 0 1892766080 6473808 7854000
23:16:21 14101 8192000000 10794198272 11232231424 1870337856 18.587 99 16 32 1 1880231568 5520336 4373376
23:16:42 39203 8192000000 10774634816 11194343424 1765404464 17.729 93 42 82 2 1784478880 5299888 13774528
23:17:43 8484 8192000000 10761179856 11189878784 1835342464 18.303 99 30 59 3 1849947232 6567840 8036928
23:17:59 11796 8192000000 10757944944 11180298240 1806983648 18.071 98 28 56 2 1821355680 5842384 8529648
23:18:18 6781 8192000000 10784335280 11197267968 1850298304 18.425 100 22 44 1 1862052896 5270896 6483696
23:18:31 6981 8192000000 10741619936 11158810624 1768400480 17.754 96 27 54 1 1781878944 6049984 7428480
23:18:48 5203 8192000000 10717103872 11122597888 1787420304 17.911 99 34 67 2 1803391872 6040608 9930960
23:19:00 9393 8192000000 10698411088 11109990400 1750073760 17.602 97 23 45 1 1762662848 6134752 6454336
23:19:18 7685 8192000000 10667541456 11081850880 1699366992 17.180 95 31 62 1 1712901360 4491008 9043360
23:19:34 9943 8192000000 10683036000 11100938240 1713334560 17.297 96 18 36 0 1723971872 5952320 4684992
23:19:50 6537 8192000000 10686508432 11098963968 1755217440 17.645 98 19 38 2 1765850896 4709952 5923504
23:20:05 10378 8192000000 10705080336 11117756416 1768269568 17.753 99 17 34 1 1777987632 5395424 4322640
23:20:21 4500 8192000000 10722810064 11140055040 1805942080 18.063 100 37 74 1 1824038832 7609696 10487056
23:20:32 9127 8192000000 10728026784 11140407296 1788893072 17.923 99 26 52 2 1802264256 5589664 7781520
23:20:48 12885 8192000000 10702747248 11117064192 1744056800 17.552 97 11 22 0 1751875424 4520928 3297696
23:21:12 15043 8192000000 10716021584 11136659456 1769880720 17.766 98 28 55 1 1786961648 9457840 7623088
23:21:33 57649 8192000000 10731713344 11154960384 1813554032 18.125 100 33 66 1 1829012480 4991696 10466752
23:22:40 12662 8192000000 10724350288 11153788928 1817913744 18.161 100 20 40 0 1830404960 6391840 6099376
23:22:59 7369 8192000000 10750372336 11169447936 1825659232 18.224 100 30 60 1 1840291040 6457040 8174768
23:23:12 8887 8192000000 10746449136 11165212672 1813865600 18.128 99 31 63 2 1828286384 5543568 8877216
23:23:29 8830 8192000000 10733906112 11155521536 1816361664 18.148 99 24 48 1 1829565376 6341696 6862016
23:23:45 7995 8192000000 10747753376 11173523456 1836139120 18.309 100 29 58 1 1854563344 10098384 8325840
23:23:59 8477 8192000000 10764652352 11188527104 1843434208 18.369 100 21 42 1 1855079616 5318592 6326816
23:24:16 6437 8192000000 10756701328 11189448704 1851389040 18.433 100 28 56 2 1866411392 5911616 9110736
23:24:31 7772 8192000000 10773956880 11196768256 1852184992 18.440 100 29 59 1 1865760800 4923344 8652464
23:24:46 9786 8192000000 10768938752 11198386176 1856635152 18.476 100 23 46 2 1869112704 6251536 6226016
23:25:02 11032 8192000000 10774082608 11204866048 1858198768 18.489 100 20 39 3 1869559280 4946608 6413904
23:25:19 7625 8192000000 10777955760 11206135808 1862729920 18.525 100 14 28 1 1872359504 5540896 4088688
23:25:34 9243 8192000000 10773720240 11207909376 1867835360 18.567 100 22 44 1 1879954144 6065904 6052880
23:25:51 11378 8192000000 10782928512 11209179136 1868087040 18.569 100 27 54 2 1881741184 5836528 7817616
23:26:09 22977 8192000000 10787509088 11214622720 1870623024 18.589 100 17 34 1 1881142784 5331168 5188592
23:26:39 138019 8192000000 10804114224 11239985152 1868082192 18.569 99 39 74 2 1884147232 5145184 10919856
23:29:09 13456 8192000000 10826540352 11259076608 1909654208 18.904 100 28 53 3 1924615232 7028112 7932912
23:29:31 24062 8192000000 10848144528 11275472896 1907770688 18.889 99 33 66 1 1924328656 6668800 9889168
23:30:06 20648 8192000000 10873373584 11301597184 1939465872 19.142 100 48 96 4 1963610880 9962336 14182672
23:30:36 39658 8192000000 10874450448 11309776896 1948516704 19.215 100 37 74 2 1969679440 10362784 10799952
23:31:24 50568 8192000000 10886891008 11322712064 1962500624 19.326 100 35 70 1 1983430272 10961296 9968352
23:32:21 16769 8192000000 10901201920 11327352832 1950699472 19.232 99 56 112 1 1979143776 12146992 16297312
23:32:53 20930 8192000000 10902915632 11334365184 1970391312 19.389 100 47 94 1 1997096976 13150272 13555392
23:33:30 16349 8192000000 10904512704 11342299136 1974507264 19.421 100 42 84 0 2001389264 14736208 12145792
23:33:56 6971 8192000000 10915897088 11348041728 1975972832 19.433 100 38 75 0 2001763504 14735984 11054688
23:34:14 8720 8192000000 10925184688 11355779072 1983165920 19.490 100 43 87 0 2012148160 15144144 13838096
23:34:33 13104 8192000000 10918503808 11356073984 1980675984 19.470 100 34 68 1 2006970048 15783696 10510368
23:35:00 27890 8192000000 10915665856 11353686016 1977335472 19.444 100 45 90 2 2009608256 17653824 14618960
23:35:41 5196 8192000000 10929096112 11354714112 1982788096 19.487 100 53 106 2 2016827856 17583984 16455776
23:35:57 4829 8192000000 10941583168 11369230336 1990216512 19.546 100 65 127 2 2026389360 17401920 18770928
23:36:08 13169 8192000000 10918426896 11338321920 1926354112 19.038 97 69 138 0 1966449104 19278448 20816544
23:36:28 1846 8192000000 10945955312 11365769216 1986869680 19.519 100 83 164 0 2032373376 21535776 23967920
23:36:42 2565 8192000000 10940001584 11364216832 1969304320 19.380 99 64 128 0 2011342832 22685984 19352528
23:36:51 1849 8192000000 10953326400 11368734720 1989547520 19.540 100 79 153 1 2033656992 21148624 22960848
23:37:00 5293 8192000000 10940003312 11367215104 1987754112 19.526 100 61 123 1 2025160304 19397312 18008880
23:37:14 7029 8192000000 10943781312 11374682112 1989961744 19.543 100 51 100 0 2024070256 19507248 14601264
23:37:29 4713 8192000000 10940842448 11356684288 1978105488 19.450 100 82 164 4 2022083056 19703280 24274288
23:37:40 3925 8192000000 10927748288 11349532672 1962015392 19.322 99 76 152 4 2006880048 21586160 23278496
23:37:53 21042 8192000000 10926147456 11353649152 1955728544 19.272 99 53 105 1 1992394768 21104096 15562128
23:38:24 6079 8192000000 10927145264 11357179904 1961497856 19.318 99 58 116 1 2004724144 24894384 18331904
23:38:39 8943 8192000000 10932629696 11365928960 1980612880 19.470 100 50 100 3 2021349904 25733424 15003600
23:38:55 8549 8192000000 10928399424 11358359552 1961544144 19.318 99 55 107 2 2002232688 23622816 17065728
23:39:12 9652 8192000000 10932114144 11357241344 1973792768 19.416 100 61 122 0 2019492704 26515600 19184336
23:39:30 6393 8192000000 10916959008 11344416768 1960266096 19.308 99 67 133 1 2009298864 27339920 21692848
23:39:45 3740 8192000000 10923241760 11344224256 1949628992 19.224 99 67 134 1 1996549568 25216928 21703648
23:39:57 4191 8192000000 10912351776 11332644864 1939556976 19.143 99 65 130 2 1980987632 22593632 18837024
23:40:14 5442 8192000000 10954059168 11370610688 1981569456 19.477 100 71 140 0 2030143296 27339424 21234416
23:40:28 8027 8192000000 10946217616 11368353792 1984849616 19.503 100 79 158 1 2036250176 28365536 23035024
23:40:42 4119 8192000000 10951360704 11370844160 1974985056 19.425 99 82 163 0 2027586816 28248864 24352896
23:40:56 3147 8192000000 10952034384 11370942464 1971780880 19.400 99 74 147 1 2021578960 28049424 21748656
23:41:08 7157 8192000000 10916701056 11343470592 1955746640 19.272 100 61 123 3 2002331104 28167984 18416480
23:41:22 1899 8192000000 10951417536 11366666240 1979007248 19.457 100 88 172 1 2034033456 28045968 26980240
23:41:33 2822 8192000000 10952848640 11364405248 1964615280 19.343 99 87 175 2 2021378528 29280304 27482944
23:41:42 4606 8192000000 10950724224 11364511744 1977120384 19.442 100 82 165 0 2031418896 28055616 26242896
23:41:53 4087 8192000000 10947118576 11354648576 1962459696 19.326 99 77 153 1 2015014400 28626368 23928336
23:42:05 4208 8192000000 10950133728 11365527552 1959632624 19.303 99 84 167 1 2017140800 31362176 26146000
23:42:15 1449 8192000000 10945295344 11363950592 1975278448 19.427 100 82 165 1 2032692624 32726512 24687664
23:42:25 1040 8192000000 10954652000 11366854656 1977007040 19.441 100 77 148 0 2032285072 32685936 22592096
23:42:33 3559 8192000000 10949861472 11364917248 1956113872 19.275 99 72 141 1 2015472624 37738832 21619920
23:42:43 3365 8192000000 10942296960 11354333184 1960341808 19.309 100 83 167 1 2023767408 38030768 25394832
23:42:54 6039 8192000000 10950442928 11360198656 1967295792 19.364 100 73 145 0 2029100464 38840256 22964416
23:43:07 6487 8192000000 10924833536 11337416704 1902414128 18.846 97 73 145 3 1966494608 40554912 23525568
23:43:22 9685 8192000000 10927222592 11343753216 1944091424 19.179 100 77 151 0 2007523584 40129824 23302336
23:43:38 3276 8192000000 10941528288 11351363584 1955461440 19.270 100 82 164 0 2019950112 39166640 25322032
23:43:49 3279 8192000000 10931673264 11344048128 1956684704 19.280 100 85 167 0 2016383696 34263616 25435376
23:44:00 3029 8192000000 10950082016 11357470720 1961706192 19.320 100 84 169 0 2023973088 35438832 26828064
23:44:10 5994 8192000000 10952978832 11366424576 1965570224 19.350 100 75 149 0 2025582176 37507776 22504176
23:44:23 4109 8192000000 10953860960 11366547456 1969533760 19.382 100 77 154 2 2032978896 39543344 23901792
23:44:35 3229 8192000000 10950552448 11372171264 1971045632 19.394 100 74 148 0 2036506032 42041328 23419072
23:44:48 3153 8192000000 10965147504 11380105216 1974995120 19.425 100 82 164 0 2043093616 42528608 25569888
23:44:59 1048 8192000000 10912352416 11310018560 1903859872 18.857 96 94 188 1 1978906624 44789760 30256992
23:45:08 4268 8192000000 10936724144 11351715840 1952212128 19.244 100 81 161 0 2020818128 43665168 24940832
23:45:29 2205 8192000000 10961785664 11371741184 1967316320 19.364 100 85 168 0 2039027104 45500288 26210496
23:45:40 1908 8192000000 10939724336 11357577216 1952092288 19.243 99 75 148 1 2018119840 43263248 22764304
23:45:50 1088 8192000000 10952635168 11361648640 1960921872 19.313 99 91 182 1 2033990512 44214688 28853952
23:45:58 3274 8192000000 10958644704 11380842496 1971953680 19.401 100 61 122 0 2038417744 46882640 19581424
23:46:10 5141 8192000000 10960620304 11374841856 1940487024 19.151 98 85 169 3 2014293472 47812752 25993696
23:46:22 5760 8192000000 10948754256 11374276608 1967239360 19.364 100 59 118 1 2031727632 46123312 18364960
23:46:35 4415 8192000000 10943745952 11369123840 1951014992 19.235 99 63 126 1 2018022672 46034256 20973424
23:46:47 9004 8192000000 10924437024 11357249536 1950666384 19.232 100 50 100 0 2013784672 46773744 16344544
23:47:03 7718 8192000000 10930434848 11365199872 1952547504 19.247 100 44 86 2 2011349536 44680032 14122000
23:47:21 11400 8192000000 10916614512 11356610560 1944380832 19.182 100 34 68 1 2003123536 47045824 11696880
23:47:52 5850 8192000000 10918446528 11350675456 1924959248 19.027 99 40 80 4 1986359056 47883488 13516320
23:48:07 3558 8192000000 10946308400 11366014976 1936337040 19.118 99 63 124 1 2006730976 50264192 20129744
23:48:19 12559 8192000000 10913058096 11354591232 1932811792 19.089 99 38 75 0 1995846128 50609344 12424992
23:48:39 7270 8192000000 10920976432 11364200448 1946568128 19.199 100 31 62 2 2003294048 46427952 10297968
23:48:57 18166 8192000000 10940171632 11382398976 1958622128 19.295 100 36 72 2 2015385536 44830304 11933104
23:49:24 14680 8192000000 10925697328 11369181184 1941630032 19.160 99 29 58 2 1999370400 47601984 10138384
23:49:56 8963 8192000000 10942815120 11381350400 1963897456 19.337 100 40 80 1 2026913856 49113552 13902848
23:50:12 14577 8192000000 10933163600 11368222720 1949444352 19.222 100 37 73 1 2011982016 50387008 12150656
23:50:33 30695 8192000000 10920781424 11376345088 1936591088 19.120 99 29 58 2 1997667744 51048464 10028192
23:51:14 23579 8192000000 10904666544 11346558976 1919591696 18.984 98 26 52 3 1973480896 45148272 8740928
23:51:44 16925 8192000000 10931499136 11364679680 1954219616 19.260 100 46 92 0 2007446640 38332240 14894784
23:52:09 47836 8192000000 10908939424 11350790144 1911790608 18.921 98 29 58 1 1967343232 45433072 10119552
23:53:03 11747 8192000000 10901523664 11359739904 1935248096 19.109 100 26 52 2 1985151072 40819152 9083824
23:53:27 15298 8192000000 10912038496 11355283456 1935152416 19.108 100 28 56 0 1986424544 41394368 9877760
23:53:56 11121 8192000000 10910276032 11363368960 1940218400 19.148 100 26 52 1 1992778944 43581728 8978816
23:54:19 24760 8192000000 10923785104 11371376640 1943994288 19.179 100 25 50 1 2001794720 48712560 9087872
23:54:49 9600 8192000000 10914787008 11373006848 1942418736 19.166 100 21 42 2 2001305440 51261168 7625536
23:55:22 16958 8192000000 10904053920 11360276480 1909798144 18.905 99 24 49 2 1974233856 55139328 9296384
23:56:32 27578 8192000000 10875191216 11358904320 1933126864 19.092 100 13 26 1 1968221024 31096128 3998032
23:57:09 64339 8192000000 10873465104 11326955520 1872523760 18.605 96 11 23 0 1887040576 11888768 2628048
23:58:30 111094 8192000000 10920508096 11367563264 1953322496 19.253 100 12 24 0 1970584400 14472208 2789696
00:00:36 27131 8192000000 10931080544 11364917248 1976652960 19.438 100 46 92 0 2003444128 12312336 14478832
00:01:15 35378 8192000000 10906408144 11378388992 1974332928 19.420 100 18 36 3 1989627488 10403536 4891024
00:02:11 102926 8192000000 10904755424 11370749952 1920256336 18.989 97 6 12 0 1936411808 14733520 1421952
00:04:00 59988 8192000000 10906869840 11369177088 1967009024 19.362 99 32 63 1 1981816256 6037296 8769936
00:05:07 8476 8192000000 10926622608 11367796736 1977357088 19.444 100 45 90 2 1996528544 6278176 12893280
00:05:22 56678 8192000000 10905362048 11356413952 1920912032 18.994 97 37 74 0 1938885600 8048256 9925312
00:06:25 16756 8192000000 10928086256 11367284736 1980529024 19.469 100 48 95 2 2002126048 8196144 13400880
00:06:56 109389 8192000000 10885770672 11351912448 1942957088 19.170 98 45 88 0 1967554640 11513616 13083936
00:08:52 54585 8192000000 10943413328 11385667584 1965850880 19.353 99 32 64 0 1987052784 12117856 9084048
00:09:58 98278 8192000000 10936080592 11400507392 1984487632 19.500 100 24 48 1 2010379776 19360784 6531360
00:11:43 61721 8192000000 10925320928 11382317056 1972891088 19.408 99 18 36 0 1997816304 19468720 5456496
00:12:56 19909 8192000000 10934708048 11399741440 1978675760 19.454 99 32 64 2 2004763616 16595840 9492016
00:13:29 52402 8192000000 10953886160 11422846976 1997752560 19.605 100 37 74 1 2034724192 24831040 12140592
00:14:32 37024 8192000000 10936762784 11412078592 1991544688 19.556 99 43 86 1 2024783552 19639488 13599376
00:15:29 53438 8192000000 10919683456 11399929856 1986257696 19.514 99 11 22 1 2005513792 15588752 3667344
00:17:15 31888 8192000000 10930202720 11424849920 2005801376 19.668 100 12 24 1 2034215232 23329312 5084544
00:18:01 39916 8192000000 10919293904 11407355904 2001267168 19.633 100 7 14 0 2018421936 15105344 2049424
00:18:49 18884 8192000000 10929737264 11416326144 2001007120 19.631 100 14 28 1 2021844624 16214240 4623264
00:19:49 23902 8192000000 10929415824 11409629184 2000779968 19.629 100 15 31 0 2016947456 11276288 4891200
00:20:24 59434 8192000000 10933795616 11413741568 1983101408 19.489 99 18 36 0 2009517664 20989472 5426784
00:21:44 77082 8192000000 10895436432 11356880896 1875622784 18.630 94 15 30 0 1891963264 12787632 3552848
00:23:12 45655 8192000000 10895301184 11358236672 1892702208 18.768 96 14 28 1 1909269664 12448544 4118912
00:24:04 10808 8192000000 10890408928 11346444288 1925814176 19.033 98 36 70 1 1943252752 8065024 9373552
00:24:29 41124 8192000000 10856834416 11315015680 1865354144 18.547 96 25 50 3 1884086000 11602512 7129344
00:25:19 27242 8192000000 10874767616 11320299520 1884951088 18.705 97 39 79 0 1908895184 12961424 10982672
00:25:52 50181 8192000000 10868944720 11348193280 1934846640 19.106 100 24 48 1 1957326048 15739408 6740000
00:26:49 21686 8192000000 10874722640 11323478016 1897382912 18.805 97 29 58 2 1914370336 9610816 7376608
00:27:27 42177 8192000000 10895337616 11348045824 1880865264 18.672 96 29 58 4 1899386224 10923920 7597040
00:28:17 69414 8192000000 10853155264 11334860800 1844463824 18.377 95 17 34 0 1863958384 15076064 4418496
00:29:36 68785 8192000000 10839349824 11296043008 1759670608 17.682 91 13 26 0 1773609312 10901632 3037072
00:30:52 74820 8192000000 10840915872 11301244928 1781585680 17.863 93 14 28 0 1797476640 12414960 3476000
00:32:13 58669 8192000000 10826310080 11296530432 1844175488 18.375 97 9 18 0 1863328368 16403296 2749584
00:33:58 72735 8192000000 10838569920 11299487744 1885487472 18.709 99 36 72 1 1908654080 12055264 11111344
00:35:18 92697 8192000000 10834514096 11294453760 1820192384 18.179 95 21 42 2 1841802720 15987936 5622400
00:37:21 3728 8192000000 10825635712 11281330176 1886290192 18.716 99 20 40 4 1906231120 14420112 5520816
00:37:33 21247 8192000000 10869220960 11318865920 1915523568 18.951 100 35 70 0 1943482544 18102800 9856176
00:38:03 9960 8192000000 10873420912 11320848384 1925501472 19.031 100 60 114 6 1959932944 18351696 16079776
00:38:37 93642 8192000000 10827210400 11303747584 1862223312 18.521 97 14 28 0 1892057248 25500432 4333504
00:40:30 34692 8192000000 10843166544 11304783872 1888049360 18.730 99 10 19 1 1902511408 11745888 2716160
00:41:34 76252 8192000000 10852814400 11323473920 1927540752 19.047 100 15 30 2 1946343216 14764512 4037952
00:43:00 67774 8192000000 10853746992 11336253440 1915433104 18.950 99 13 26 0 1930356864 11037264 3886496
00:44:49 80129 8192000000 10851081888 11326668800 1903681408 18.856 98 24 49 0 1925423104 14780160 6961536
00:46:16 44186 8192000000 10841542704 11320963072 1908041632 18.891 99 10 20 0 1924513936 13277232 3195072
00:47:32 39651 8192000000 10835567568 11312009216 1886749344 18.720 98 5 10 0 1895589584 7878832 961408
00:48:20 36707 8192000000 10849827120 11324784640 1915376448 18.950 99 26 53 1 1929726752 6408032 7942272
00:49:47 55771 8192000000 10880886992 11344416768 1930188016 19.068 99 33 64 2 1950799760 11678400 8933344
00:50:51 45598 8192000000 10889551008 11351515136 1936204688 19.116 99 27 54 0 1957152816 13341968 7606160
00:51:46 75668 8192000000 10882782976 11352334336 1930723488 19.073 99 16 32 0 1951778784 16199552 4855744
00:53:17 63400 8192000000 10878837312 11360043008 1931709232 19.081 99 16 32 2 1958358992 21786592 4863168
00:54:28 73816 8192000000 10897373568 11362869248 1915562624 18.951 98 26 51 2 1939795296 16963728 7268944
00:55:49 46516 8192000000 10904152736 11365933056 1919295360 18.981 98 28 56 0 1941918096 14950272 7672464
00:56:45 106532 8192000000 10875036000 11339321344 1882117888 18.682 96 13 26 0 1895449088 9469312 3861888
00:58:42 53892 8192000000 10899632640 11357511680 1949637040 19.224 99 23 46 4 1964952288 8996912 6318336
00:59:42 59310 8192000000 10890082928 11350593536 1933156736 19.092 98 31 61 3 1952871648 11178496 8536416
01:00:48 88331 8192000000 10925369216 11371716608 1915470768 18.951 97 24 48 2 1933105664 10999056 6635840
01:02:43 77515 8192000000 10902427280 11366420480 1969253104 19.380 100 27 54 2 1987915168 11699136 6962928
01:04:25 70960 8192000000 10887653264 11352793088 1957207552 19.284 99 17 34 0 1969567008 7290016 5069440
01:05:43 2165 8192000000 10917071056 11369328640 1977350288 19.444 100 49 98 2 1999067728 8241472 13475968
01:05:51 28163 8192000000 10900290880 11365945344 1954825776 19.265 99 30 59 1 1973124112 9904448 8393888
01:06:39 61392 8192000000 10870399312 11349557248 1932217152 19.085 98 5 10 0 1940711920 7498384 996384
01:07:50 24026 8192000000 10876119904 11359825920 1946197808 19.196 99 10 17 1 1957495680 8451712 2846160
01:08:23 39881 8192000000 10889109168 11365892096 1968760080 19.376 100 14 28 1 1984872416 12370048 3742288
01:09:09 59083 8192000000 10876259200 11364528128 1954009744 19.258 99 10 20 1 1970223344 13472032 2741568
01:10:14 58628 8192000000 10851314096 11321937920 1884500496 18.701 96 10 20 0 1893732960 6747792 2484672
01:11:19 10089 8192000000 10883133136 11332341760 1934029952 19.099 99 58 112 2 1955547200 6514992 15002256
01:11:39 39048 8192000000 10866256176 11348357120 1933000848 19.091 99 21 42 0 1948460144 9059216 6400080
01:12:28 75345 8192000000 10864930416 11350700032 1910269728 18.909 98 12 24 0 1923990752 10044944 3676080
01:13:52 64028 8192000000 10851877408 11340525568 1876467056 18.637 96 9 18 1 1888402800 9335760 2599984
01:15:06 48284 8192000000 10850232704 11315752960 1825222832 18.220 94 13 26 1 1834999744 6259664 3517248
01:16:14 51144 8192000000 10863109872 11330936832 1933147200 19.092 100 32 64 2 1954939072 12569264 9222608
01:17:13 57165 8192000000 10861781216 11322646528 1854466400 18.458 96 17 34 0 1872996000 13697568 4832032
01:18:19 47549 8192000000 10817208336 11289329664 1796433856 17.985 94 31 62 2 1822076032 16908912 8733264
01:19:12 57461 8192000000 10833553424 11308863488 1886612368 18.718 99 21 42 0 1907846928 15074896 6159664
01:20:37 23707 8192000000 10857595392 11311448064 1882297120 18.684 98 34 66 1 1898245248 6188704 9759424
01:21:09 15591 8192000000 10872815456 11321663488 1920649520 18.992 100 46 92 1 1946650736 13160800 12840416
01:21:33 29876 8192000000 10886835440 11340394496 1931319424 19.077 100 40 80 1 1955366496 13280528 10766544
01:22:11 98903 8192000000 10836415328 11308515328 1756377328 17.654 91 31 62 1 1779201648 14633008 8191312
01:23:59 78607 8192000000 10838506064 11302666240 1833249600 18.286 96 24 48 0 1849599440 9975120 6374720
01:25:24 41768 8192000000 10835541984 11286417408 1817393760 18.156 95 31 62 4 1834913488 9026752 8492976
01:26:12 66541 8192000000 9962067920 10333777920 1091680784 11.759 57 12 24 0 1098903984 4343376 2879824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-11-2020 01:28:40 to 10-11-2020 01:29:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 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 10-11-2020 01:29:13 to 10-11-2020 01:29:15.

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          249344
MON$OLDEST_ACTIVE               249345
MON$OLDEST_SNAPSHOT             249345
MON$NEXT_TRANSACTION            249345
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                       2038304
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:193: 
:194: mscs-test-161.budzdorov.ru    Tue Nov 10 01:27:27 2020
:195:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:196: 
--- end of diff output ---

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

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