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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-27 19:27:24
DTS_END                         2021-03-27 19:27:24.6740
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50940
TRN_ID                          239476
ATT_ID                          677
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: 9336.81 21701 1120417
customer order: creation 177.01 372 21241
customer order: refuse 14.69 329 1763
order to supplier: creation 46.58 1279 5590
order to supplier: removal 3.09 116159 371
invoice (draft): creation 46.10 3447 5532
invoice (draft): removal 52.40 858 6288
invoice accept: apply 41.92 18187 5030
invoice accept: cancel 47.93 777 5752
customer reserve: creation 3876.13 180 465136
customer reserve: removal 4737.48 60 568498
realization accept: apply 83.46 186 10015
realization accept: cancel 81.30 129 9756
payment from customer: creation 58.12 132 6974
payment from customer: removal 5.80 80 696
payment to supplier: creation 49.58 143 5949
payment to supplier: removal 3.33 135 399
service: total inventory turnovers 4.72 985 566
service: total monetary turnovers 6.42 32 770
service: aggregate perf. data 0.73 22019 87
service: refresh index statistics 0.03 268521 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2021 19:28:35 to 27-03-2021 19:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3917
TEST_TIME 2 3909
TEST_TIME 3 3629
TEST_TIME 4 4526
TEST_TIME 5 4420
TEST_TIME 6 4466
TEST_TIME 7 4627
TEST_TIME 8 5254
TEST_TIME 9 5504
TEST_TIME 10 5679
TEST_TIME 11 5916
TEST_TIME 12 6250
TEST_TIME 13 6516
TEST_TIME 14 6860
TEST_TIME 15 6985
TEST_TIME 16 7027
TEST_TIME 17 7047
TEST_TIME 18 7386
TEST_TIME 19 7387
TEST_TIME 20 7974
TEST_TIME 21 8424
TEST_TIME 22 8297
TEST_TIME 23 8661
TEST_TIME 24 8750
TEST_TIME 25 9309
TEST_TIME 26 9403
TEST_TIME 27 9660
TEST_TIME 28 10745
TEST_TIME 29 10653
TEST_TIME 30 10421
TEST_TIME 31 10291
TEST_TIME 32 10061
TEST_TIME 33 10165
TEST_TIME 34 10373
TEST_TIME 35 10229
TEST_TIME 36 10040
TEST_TIME 37 9974
TEST_TIME 38 9844
TEST_TIME 39 9737
TEST_TIME 40 9768
TEST_TIME 41 9924
TEST_TIME 42 9967
TEST_TIME 43 9797
TEST_TIME 44 9644
TEST_TIME 45 9636
TEST_TIME 46 9615
TEST_TIME 47 9732
TEST_TIME 48 9677
TEST_TIME 49 9695
TEST_TIME 50 9699
TEST_TIME 51 9704
TEST_TIME 52 9777
TEST_TIME 53 9728
TEST_TIME 54 9714
TEST_TIME 55 9789
TEST_TIME 56 9694
TEST_TIME 57 9832
TEST_TIME 58 9810
TEST_TIME 59 9896
TEST_TIME 60 9785
TEST_TIME 61 9669
TEST_TIME 62 9576
TEST_TIME 63 9517
TEST_TIME 64 9556
TEST_TIME 65 9482
TEST_TIME 66 9390
TEST_TIME 67 9357
TEST_TIME 68 9261
TEST_TIME 69 9278
TEST_TIME 70 9472
TEST_TIME 71 9526
TEST_TIME 72 9480
TEST_TIME 73 9492
TEST_TIME 74 9514
TEST_TIME 75 9485
TEST_TIME 76 9528
TEST_TIME 77 9567
TEST_TIME 78 9554
TEST_TIME 79 9509
TEST_TIME 80 9623
TEST_TIME 81 9607
TEST_TIME 82 9496
TEST_TIME 83 9489
TEST_TIME 84 9455
TEST_TIME 85 9442
TEST_TIME 86 9408
TEST_TIME 87 9374
TEST_TIME 88 9372
TEST_TIME 89 9351
TEST_TIME 90 9329
TEST_TIME 91 9285
TEST_TIME 92 9322
TEST_TIME 93 9334
TEST_TIME 94 9340
TEST_TIME 95 9311
TEST_TIME 96 9406
TEST_TIME 97 9510
TEST_TIME 98 9488
TEST_TIME 99 9480
TEST_TIME 100 9472
TEST_TIME 101 9503
TEST_TIME 102 9538
TEST_TIME 103 9527
TEST_TIME 104 9534
TEST_TIME 105 9460
TEST_TIME 106 9449
TEST_TIME 107 9425
TEST_TIME 108 9423
TEST_TIME 109 9385
TEST_TIME 110 9343
TEST_TIME 111 9338
TEST_TIME 112 9293
TEST_TIME 113 9263
TEST_TIME 114 9303
TEST_TIME 115 9296
TEST_TIME 116 9321
TEST_TIME 117 9378
TEST_TIME 118 9346
TEST_TIME 119 9324
TEST_TIME 120 9341

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-03-2021 19:28:38 to 27-03-2021 19:28:42.

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 1551258 1551258 0 0.00 0 19412 7 0 0
doc_list_biud 1551256 1551256 0 0.00 0 77504 28 0 0
sp_add_invoice_to_stock 5115 5030 85 1.66 47 196723 18188 0 85
sp_cancel_adding_invoice 5752 5752 0 0.00 5 63580 777 0 0
sp_cancel_client_order 1763 1763 0 0.00 4 8609 330 0 0
sp_cancel_customer_reserve 568498 568498 0 0.00 1 77508 60 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 4817 80 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 10570 136 0 0
sp_cancel_supplier_invoice 6298 6288 10 0.15 1 16772 859 0 10
sp_cancel_supplier_order 371 371 0 0.00 7 858760 116160 0 0
sp_cancel_write_off 9756 9756 0 0.00 1 19791 129 0 0
sp_client_order 21241 21241 0 0.00 4 75819 372 0 0
sp_customer_reserve 465136 465136 0 0.00 0 90827 181 0 0
sp_fill_shopping_cart 32362 32362 0 0.00 1 14327 40 0 0
sp_fill_shopping_cart_clo_res 465126 465126 0 0.00 0 19077 14 0 0
sp_get_clo_for_invoice 5020 5020 0 0.00 0 36043 319 0 0
sp_kill_cost_storno 16603 16603 0 0.00 0 8453 58 0 0
sp_kill_qstorno_ret_qs2qd 1153411 1153411 0 0.00 0 77478 33 0 0
sp_kill_qty_storno 607463 607463 0 0.00 0 77501 70 0 0
sp_lock_selected_doc 20852 20852 0 0.00 0 11401 7 0 0
sp_make_cost_storno 27958 27958 0 0.00 0 18698 56 0 0
sp_multiply_rows_for_pdistr 27958 27958 0 0.00 0 7703 30 0 0
sp_multiply_rows_for_qdistr 21241 21241 0 0.00 0 75793 192 0 0
sp_pay_from_customer 6974 6974 0 0.00 4 18897 132 0 0
sp_pay_to_supplier 5949 5949 0 0.00 5 18910 144 0 0
sp_payment_common 12923 12923 0 0.00 1 18677 48 0 0
sp_qd_handle_on_cancel_clo 1763 1763 0 0.00 0 8591 303 0 0
sp_qd_handle_on_invoice_upd_sts 10772 10772 0 0.00 0 16634 296 0 0
sp_qd_handle_on_reserve_upd_sts 10015 10015 0 0.00 0 11368 58 0 0
sp_reserve_write_off 10015 10015 0 0.00 6 18735 187 0 0
sp_supplier_invoice 5532 5532 0 0.00 6 92951 3447 0 0
sp_supplier_order 5590 5590 0 0.00 5 46131 1279 0 0
srv_aggregate_perf_data 87 87 0 0.00 1894 411666 22020 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 365 104689 33258 0 0
srv_find_qd_qs_mism 1072353 1072353 0 0.00 0 19388 6 0 0
srv_make_invnt_saldo 566 566 0 0.00 30 24248 985 0 0
srv_make_money_saldo 770 770 0 0.00 1 7768 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 187346 338854 268522 0 0
t$perf-abend:sp_add_invoice_to_stock 85 85 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 5030 5030 0 0.00 0 19141 171 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 1 2974 85 0 0
t$perf-norm:sp_cancel_client_order 1763 1763 0 0.00 0 1963 10 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 3064 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 1635 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 770 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 959 17 0 0
t$perf-norm:sp_cancel_supplier_order 371 371 0 0.00 0 24131 1639 0 0
t$perf-norm:sp_cancel_write_off 1043 1043 0 0.00 0 14612 18 0 0
t$perf-norm:sp_client_order 21241 21241 0 0.00 0 8481 19 0 0
t$perf-norm:sp_customer_reserve 1024 1024 0 0.00 0 3236 11 0 0
t$perf-norm:sp_pay_from_customer 6974 6974 0 0.00 0 6189 8 0 0
t$perf-norm:sp_pay_to_supplier 5949 5949 0 0.00 0 8051 14 0 0
t$perf-norm:sp_reserve_write_off 10015 10015 0 0.00 0 15357 13 0 0
t$perf-norm:sp_supplier_invoice 5532 5532 0 0.00 0 6372 19 0 0
t$perf-norm:sp_supplier_order 5590 5590 0 0.00 0 5947 17 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 161 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1807 16 0 0
t$perf-norm:srv_make_invnt_saldo 566 566 0 0.00 0 7222 40 0 0
t$perf-norm:srv_make_money_saldo 770 770 0 0.00 0 4027 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10210 10040 170 1.66 0 6403 20 0 170
v_all_customers 38296 38296 0 0.00 0 18 1 0 0
v_all_suppliers 30844 30844 0 0.00 0 34 1 0 0
v_all_wares 42482 42482 0 0.00 0 13 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 4222 13 0 0
v_cancel_client_order 3526 3526 0 0.00 0 4981 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 3719 8 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 1976 6 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 5177 16 0 0
v_cancel_supplier_invoice 810 790 20 2.46 0 1350 14 0 20
v_cancel_supplier_order 742 742 0 0.00 0 2428 7 0 0
v_cancel_write_off 2086 2086 0 0.00 0 5352 17 0 0
v_max_id_clo_ord 5589 5589 0 0.00 0 5607 2 0 0
v_max_id_clo_res 1024 1024 0 0.00 0 2719 20 0 0
v_max_id_ord_sup 5531 5531 0 0.00 0 5926 7 0 0
v_max_non_paid_invoice 1647 1647 0 0.00 0 6693 6 0 0
v_max_non_paid_realizn 3759 3759 0 0.00 0 2332 4 0 0
v_min_id_clo_ord 5589 5589 0 0.00 0 6940 13 0 0
v_min_id_clo_res 1024 1024 0 0.00 0 7540 24 0 0
v_min_id_ord_sup 5531 5531 0 0.00 0 6117 11 0 0
v_min_non_paid_invoice 5949 5949 0 0.00 0 18436 38 0 0
v_min_non_paid_realizn 6974 6974 0 0.00 0 18565 32 0 0
v_our_firm 10616 10616 0 0.00 0 17 1 0 0
v_reserve_write_off 20030 20030 0 0.00 0 6993 9 0 0
x_lock_depdocs_on_canc_invoice 11645 11645 0 0.00 0 16227 115 0 0
x_lock_depdocs_on_canc_sup_ord 371 371 0 0.00 0 28661 584 0 0
x_make_qstorno_1000_1200 5590 5590 0 0.00 2 46119 1198 0 0
x_make_qstorno_1200_2000 5532 5532 0 0.00 3 86644 3297 0 0
x_make_qstorno_2100_3300 465136 465136 0 0.00 0 90822 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2021 19:28:43 to 27-03-2021 19:28:47.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:28 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:34 19515 8192000000 10242738800 10547576832 838005056 9.280 68 54 111 0 859158144 2394256 18758832
16:58:06 29140 8192000000 10353093120 10669064192 1389373936 14.500 100 81 162 0 1420985312 4831632 26779744
16:58:46 17800 8192000000 10377781360 10700537856 1430882640 14.869 100 87 174 1 1465861344 6192864 28785840
16:59:14 19578 8192000000 10392642416 10716565504 1448414448 15.024 100 88 176 0 1484592960 7126816 29051696
16:59:47 23407 8192000000 10420239056 10746978304 1472871664 15.239 100 91 182 0 1510189616 7654624 29663328
17:00:19 16504 8192000000 10434676048 10768584704 1491724624 15.404 100 82 165 0 1525794160 8018384 26051152
17:00:46 15253 8192000000 10467311616 10803556352 1520964496 15.659 100 87 172 1 1556394048 8500176 26929376
17:01:10 20224 8192000000 10497139936 10839969792 1550672064 15.916 100 82 164 1 1585519168 9184720 25662384
17:01:39 22964 8192000000 10527391904 10872999936 1572733296 16.106 100 80 160 1 1606927440 9724128 24470016
17:02:20 18503 8192000000 10552837664 10907267072 1606931776 16.399 100 77 154 3 1640531408 10039232 23560400
17:02:48 13284 8192000000 10559354592 10922053632 1628546240 16.583 100 75 150 5 1662305616 10779232 22980144
17:03:14 11521 8192000000 10590196432 10954428416 1651159024 16.774 100 75 150 0 1685249840 11594704 22496112
17:03:33 12797 8192000000 10622194240 10982653952 1670967984 16.941 100 83 166 1 1707940144 12274704 24697456
17:03:55 12845 8192000000 10629247968 10996985856 1683556288 17.047 100 79 158 3 1718826000 12783616 22486096
17:04:17 10859 8192000000 10659101296 11026087936 1713611920 17.299 100 79 158 0 1748855120 12773424 22469776
17:04:35 7953 8192000000 10661010096 11031953408 1722016544 17.369 100 84 167 2 1759073104 12890304 24166256
17:04:51 7827 8192000000 10680675680 11054043136 1735555488 17.482 100 80 160 0 1772034720 13996016 22483216
17:05:11 6759 8192000000 10692553408 11064778752 1750882624 17.609 100 88 177 0 1790897760 15094720 24920416
17:05:24 7288 8192000000 10697374240 11075186688 1755112816 17.644 100 71 142 0 1788263872 12921696 20229360
17:05:40 6233 8192000000 10701774096 11080896512 1765309312 17.728 100 78 155 2 1801697664 14144928 22243424
17:05:54 2962 8192000000 10708913520 11087298560 1772210624 17.785 100 80 160 0 1808125712 13358768 22556320
17:06:04 5127 8192000000 10721140096 11101978624 1780292784 17.852 100 83 165 0 1816930800 13091072 23546944
17:06:16 9880 8192000000 10721829088 11103850496 1784094080 17.883 100 70 138 2 1816681904 12781952 19805872
17:06:33 4651 8192000000 10727749216 11108110336 1789580336 17.928 100 80 160 0 1824536272 12487200 22468736
17:06:44 3652 8192000000 10741948384 11128049664 1803215808 18.040 100 83 166 1 1839957984 12414976 24327200
17:06:56 3659 8192000000 10750567856 11135303680 1812173456 18.114 100 86 172 1 1849291536 13089952 24028128
17:07:06 4074 8192000000 10753241040 11141791744 1815005968 18.137 100 77 154 0 1849764736 13407344 21351424
17:07:17 3478 8192000000 10763545904 11153502208 1827515920 18.239 100 79 158 1 1863241632 13508208 22217504
17:07:28 2848 8192000000 10768005152 11158020096 1829719136 18.257 100 91 181 1 1868438448 13225552 25493760
17:07:37 1485 8192000000 10774618384 11159216128 1833948816 18.292 100 82 164 4 1870922928 12903856 24070256
17:07:45 2094 8192000000 10780010512 11168083968 1837033648 18.317 100 84 167 2 1873891184 13043536 23814000
17:07:54 2529 8192000000 10779993312 11168141312 1837850592 18.323 100 77 155 1 1872228064 12500496 21876976
17:08:03 2272 8192000000 10788801808 11179442176 1845457808 18.385 100 87 175 2 1880570736 10777504 24335424
17:08:12 2763 8192000000 10796661984 11180335104 1852259392 18.440 100 83 164 0 1888008944 12171680 23577872
17:08:21 2647 8192000000 10804141040 11191189504 1859481344 18.499 100 89 178 1 1897753216 13773664 24498208
17:08:31 12376 8192000000 10806543504 11192758272 1862656992 18.525 100 92 185 1 1901876928 13390736 25829200
17:08:50 1358 8192000000 10810789216 11200860160 1863711152 18.533 100 93 186 2 1903346912 13895056 25740704
17:08:59 2480 8192000000 10813324000 11203276800 1868133456 18.569 100 90 179 0 1907197968 13988624 25075888
17:09:08 2183 8192000000 10823960656 11210436608 1870978928 18.592 100 92 184 1 1912412192 14937840 26495424
17:09:16 11012 8192000000 10801044880 11197607936 1868590432 18.573 100 71 139 2 1900986000 13067296 19328272
17:09:35 4121 8192000000 10798411392 11198058496 1867055104 18.560 100 58 114 2 1893755584 11077904 15622576
17:09:46 3065 8192000000 10790990224 11197407232 1870182752 18.586 100 55 110 1 1896334320 10645536 15506032
17:09:56 4411 8192000000 10797797216 11202424832 1868796784 18.575 100 52 104 0 1893063104 9755984 14510336
17:10:07 5110 8192000000 10784933008 11198201856 1868179888 18.570 100 39 79 3 1886287536 7422960 10684688
17:10:18 5539 8192000000 10789096096 11205029888 1872369008 18.603 100 49 97 2 1898283632 12225504 13689120
17:10:31 3433 8192000000 10805731584 11215826944 1874431920 18.620 100 26 52 1 1888212832 6777376 7003536
17:10:41 5754 8192000000 10779219024 11204534272 1874718736 18.622 100 42 82 1 1893676016 7191504 11765776
17:10:52 4084 8192000000 10794830496 11218317312 1877239456 18.643 100 44 89 1 1901326368 11367344 12719568
17:11:03 4901 8192000000 10788971648 11213221888 1877929088 18.648 100 34 68 4 1895286272 8458656 8898528
17:11:15 5904 8192000000 10798340672 11218944000 1884115840 18.698 100 39 78 3 1903051568 7573984 11361744
17:11:27 8716 8192000000 10789193136 11220721664 1878884720 18.656 100 25 50 1 1897129808 10309776 7935312
17:11:43 9349 8192000000 10793886736 11220201472 1878972976 18.657 100 23 44 2 1892225136 6596448 6655712
17:12:00 4528 8192000000 10786646272 11220525056 1884199616 18.699 100 29 56 3 1899040160 6913904 7926640
17:12:10 7152 8192000000 10794000720 11224788992 1886173472 18.715 100 25 50 0 1899778992 6549392 7056128
17:12:24 18274 8192000000 10805317024 11229499392 1894319056 18.781 100 30 62 4 1908760128 6181440 8259632
17:13:31 28436 8192000000 10823378912 11248816128 1898605616 18.815 100 30 60 0 1913564464 6277440 8681408
17:14:09 5391 8192000000 10811089520 11244183552 1898747984 18.816 100 24 48 1 1911761264 5435904 7577376
17:14:23 6156 8192000000 10823536320 11252592640 1898803280 18.817 100 25 49 2 1912398128 6628176 6966672
17:14:35 8657 8192000000 10816308384 11251392512 1902531952 18.847 100 33 66 1 1919712192 7021280 10158960
17:14:51 5704 8192000000 10816128944 11250896896 1902232368 18.844 100 33 67 0 1918377616 6817360 9327888
17:15:03 5811 8192000000 10812771040 11251208192 1902957840 18.850 100 27 54 2 1917538864 7052784 7528240
17:15:15 5768 8192000000 10818678576 11253432320 1905278032 18.869 100 24 48 1 1918817232 6497584 7041616
17:15:28 6122 8192000000 10818009328 11253653504 1905380336 18.870 100 19 38 3 1916436160 5688192 5367632
17:15:44 6667 8192000000 10831530128 11265990656 1908839216 18.897 100 30 60 0 1927708352 9913392 8955744
17:15:57 6329 8192000000 10825502608 11259465728 1908598064 18.895 100 21 42 1 1920828272 6207232 6022976
17:16:09 6500 8192000000 10808826544 11244109824 1882392128 18.684 99 17 33 0 1892477168 5137344 4947696
17:16:24 7012 8192000000 10826337376 11260854272 1907073776 18.883 100 24 48 2 1924610080 10301408 7234896
17:16:39 15984 8192000000 10800219200 11241365504 1871090464 18.593 98 17 34 0 1881359024 5788080 4480480
17:17:02 9590 8192000000 10800450656 11231195136 1863258288 18.530 98 21 40 3 1873708848 5070016 5380544
17:17:19 7971 8192000000 10790663536 11228360704 1866786064 18.558 99 21 42 1 1879606160 6750432 6069664
17:17:37 13318 8192000000 10765831104 11194191872 1811163888 18.105 96 22 44 0 1823156768 5357280 6635600
17:17:57 71196 8192000000 10785116688 11222929408 1863752704 18.534 99 24 47 1 1876682368 5140032 7789632
17:19:14 7119 8192000000 10773749264 11208658944 1851817488 18.437 99 18 36 2 1862574176 5878720 4877968
17:19:27 8296 8192000000 10773413184 11193917440 1821552400 18.190 98 30 57 1 1839820976 10348320 7920256
17:19:45 5036 8192000000 10755523568 11174825984 1835402240 18.303 100 39 76 1 1853976336 7555632 11018464
17:19:57 3886 8192000000 10745706128 11156762624 1772431840 17.787 96 40 80 2 1794667072 11101808 11133424
17:20:07 3263 8192000000 10694716528 11108954112 1756564944 17.656 98 24 48 1 1769677168 5921408 7190816
17:20:21 5301 8192000000 10714294128 11128741888 1766278592 17.736 98 36 72 2 1782950752 5776800 10895360
17:20:35 12599 8192000000 10690476480 11102531584 1684153376 17.052 93 10 20 0 1691933888 4684192 3096320
17:20:56 5996 8192000000 10728338448 11137695744 1789115488 17.925 99 29 58 0 1803188672 5646448 8426736
17:21:08 6771 8192000000 10700059360 11115802624 1756002768 17.651 98 29 58 1 1770463248 6053792 8406688
17:21:26 7779 8192000000 10709140512 11120107520 1770487936 17.771 99 33 66 2 1786481872 5717968 10275968
17:21:41 5187 8192000000 10703530464 11110952960 1756215232 17.653 98 31 62 0 1770846176 5663760 8967184
17:21:55 14479 8192000000 10695616128 11104608256 1702466352 17.206 95 28 54 1 1715226352 4624464 8135536
17:22:16 15280 8192000000 10701668768 11121811456 1749097232 17.594 98 11 22 0 1757607280 5087344 3422704
17:22:38 87761 8192000000 10735662368 11155550208 1786591184 17.904 98 24 48 0 1798383360 5177744 6614432
17:24:13 10269 8192000000 10755277840 11164438528 1810400128 18.099 99 32 63 2 1825734320 6261984 9072208
17:24:33 8631 8192000000 10752334080 11174293504 1833310800 18.286 100 17 35 0 1843235408 5569216 4355392
17:24:48 5057 8192000000 10757634112 11182620672 1843777984 18.372 100 28 56 0 1859236400 7231264 8227152
17:24:59 4865 8192000000 10755880528 11187019776 1849153328 18.415 100 36 70 4 1866804304 6757088 10893888
17:25:11 9075 8192000000 10771226320 11192328192 1852156416 18.440 100 29 58 1 1865920576 5014592 8749568
17:25:29 7442 8192000000 10761790144 11194572800 1851697200 18.436 100 20 40 3 1863880400 6874304 5308896
17:25:43 6611 8192000000 10779559824 11199270912 1858761216 18.493 100 38 76 2 1876178624 5814688 11602720
17:25:58 8151 8192000000 10770104448 11199877120 1859755936 18.501 100 23 46 2 1871851360 5512960 6582464
17:26:12 13775 8192000000 10788543872 11210506240 1862189840 18.521 100 14 28 0 1872409888 5641536 4578512
17:26:36 6196 8192000000 10785790240 11210461184 1865193056 18.545 100 17 34 1 1875639232 5402112 5044064
17:26:53 8984 8192000000 10786681184 11214843904 1867715392 18.566 100 18 37 1 1878915488 5184544 6015552
17:27:10 11417 8192000000 10795244928 11226619904 1880555440 18.670 100 19 38 2 1891282576 5619664 5107472
17:27:28 31382 8192000000 10825766496 11246559232 1902283216 18.845 100 47 92 2 1922239680 6185328 13771136
17:28:09 39350 8192000000 10844622592 11265896448 1912791776 18.929 100 43 85 1 1931767648 7576432 11399440
17:28:58 19009 8192000000 10854765392 11276529664 1925839472 19.034 100 40 80 1 1947089616 10261024 10989120
17:29:25 43224 8192000000 10854793040 11282620416 1928408480 19.054 100 46 89 1 1951777008 9959776 13408752
17:30:18 42154 8192000000 10878737680 11304157184 1934890656 19.106 100 48 96 1 1961657792 12319472 14447664
17:31:09 28117 8192000000 10889113232 11312504832 1944959136 19.186 100 48 95 0 1974306064 16169504 13177424
17:31:45 2830 8192000000 10898449984 11318185984 1950431568 19.230 100 64 126 0 1983306416 14548304 18326544
17:32:05 19625 8192000000 10887932544 11315335168 1950848240 19.233 100 49 95 4 1979197392 14624672 13724480
17:32:37 5148 8192000000 10896950032 11317997568 1953875760 19.257 100 54 108 1 1983566944 14386384 15304800
17:32:59 11021 8192000000 10894782896 11319934976 1956560256 19.279 100 55 110 0 1987979024 15486896 15931872
17:33:21 8432 8192000000 10893644608 11318743040 1951940320 19.242 100 45 90 0 1979165136 14602352 12622464
17:33:42 15833 8192000000 10901926400 11330473984 1961530832 19.318 100 54 109 1 1992072448 15408640 15132976
17:34:17 13379 8192000000 10906961216 11340619776 1965906720 19.353 100 50 100 0 1997535616 17188064 14440832
17:35:00 16086 8192000000 10908405168 11349110784 1971293136 19.396 100 44 87 1 2003248352 18660400 13294816
17:35:23 4571 8192000000 10928857600 11354415104 1977459168 19.445 100 58 116 0 2014966720 19828064 17679488
17:35:36 6699 8192000000 10947076816 11366965248 1986311424 19.515 100 76 151 3 2031493168 22389504 22792240
17:35:50 6929 8192000000 10936050288 11364696064 1989042560 19.536 100 63 126 1 2027706896 20092640 18571696
17:36:07 2719 8192000000 10933240192 11363966976 1985806960 19.511 100 62 122 2 2022779008 19209488 17762560
17:36:18 8913 8192000000 10935525872 11355938816 1983281728 19.491 100 69 130 1 2022671024 19941696 19447600
17:36:37 3432 8192000000 10932831904 11356160000 1967839536 19.368 99 65 130 2 2007946128 20246160 19860432
17:36:54 5204 8192000000 10941500960 11368505344 1986458464 19.516 100 73 144 2 2029654480 21527536 21668480
17:37:07 4061 8192000000 10946066880 11370848256 1990016224 19.544 100 67 134 1 2033858672 23307328 20535120
17:37:19 14287 8192000000 10937035584 11372507136 1990433840 19.547 100 53 106 1 2028803280 21483520 16885920
17:37:40 26824 8192000000 10936204976 11372380160 1969098432 19.378 99 47 94 4 2008244880 23861216 15285232
17:38:18 8916 8192000000 10945990864 11380736000 1990730960 19.550 100 51 102 0 2032067376 25107936 16228480
17:38:34 5948 8192000000 10946631008 11381182464 1974396704 19.420 99 49 98 0 2018554384 28793952 15363728
17:38:50 8314 8192000000 10944094176 11380510720 1994001472 19.575 100 64 128 2 2037259120 23969248 19288400
17:39:07 8010 8192000000 10945899120 11388211200 2000017136 19.623 100 41 82 3 2034674208 22052144 12604928
17:39:28 9663 8192000000 10950849984 11381727232 1983673760 19.494 99 54 106 1 2021849248 21433872 16741616
17:39:45 5491 8192000000 10946181936 11369422848 1968943200 19.377 98 65 130 0 2013108224 24894240 19270784
17:39:57 2873 8192000000 10952254128 11375624192 1970537616 19.390 99 75 150 0 2019485360 26282464 22665280
17:40:18 4706 8192000000 10964787472 11392897024 1998590208 19.612 100 70 139 0 2048850640 29133104 21127328
17:40:30 8892 8192000000 10965100688 11391221760 1984751248 19.502 99 74 147 2 2031439616 25005600 21682768
17:40:50 19362 8192000000 10966025232 11402084352 2009450736 19.697 100 67 134 1 2057466816 27661632 20354448
17:41:30 3854 8192000000 10952642144 11394899968 2002264272 19.641 100 52 104 1 2044380752 25842768 16273712
17:41:42 6332 8192000000 10969600432 11402891264 2012218976 19.719 100 66 130 0 2054807424 22879568 19708880
17:42:00 2369 8192000000 10974357840 11404861440 2015303664 19.743 100 65 130 0 2059423040 24649088 19470288
17:42:09 5866 8192000000 10984010960 11413704704 2018012928 19.765 100 65 126 0 2061873536 24506352 19354256
17:42:22 2608 8192000000 10988435360 11417022464 2023472592 19.807 100 69 138 1 2069378304 24969328 20936384
17:42:33 6191 8192000000 10978190176 11410407424 2017642256 19.762 100 66 132 2 2061928208 24710256 19575696
17:42:46 2102 8192000000 10976889984 11403743232 1998773248 19.613 99 71 143 2 2046969936 27017040 21179648
17:42:58 5637 8192000000 10977952208 11404804096 2011381488 19.712 100 65 129 2 2056468224 26131216 18955520
17:43:13 1728 8192000000 10981879504 11408932864 2017733312 19.762 100 76 149 3 2066949712 26978160 22238240
17:43:21 5236 8192000000 10981621680 11412148224 2018553616 19.769 100 75 150 2 2069320496 27665296 23101584
17:43:34 2049 8192000000 10972420864 11397357568 2006865104 19.677 99 66 133 1 2056501888 29737104 19899680
17:43:43 3052 8192000000 10998348656 11422740480 2025541104 19.824 100 76 152 0 2080741488 30766336 24434048
17:43:53 1597 8192000000 10980097440 11392638976 1996719088 19.597 99 79 157 0 2050790560 30703680 23367792
17:44:01 6776 8192000000 10971224352 11395383296 1987033824 19.520 99 71 141 1 2039814272 31410912 21369536
17:44:26 5007 8192000000 10984732336 11407331328 2002866768 19.645 100 81 159 5 2062851920 35683984 24301168
17:44:40 3316 8192000000 10984223552 11409494016 2010568736 19.706 100 80 160 0 2071917312 36818288 24530288
17:44:50 1918 8192000000 10969714656 11389165568 1985882368 19.511 99 78 154 0 2047564688 37169744 24512576
17:44:59 3181 8192000000 10989660672 11409461248 2008629504 19.691 100 82 163 2 2073644112 38639408 26375200
17:45:09 1839 8192000000 10997153808 11410198528 2006822176 19.676 100 89 179 3 2075821248 41678992 27320080
17:45:18 1537 8192000000 10979254048 11392389120 1985054944 19.505 99 90 178 0 2056318656 42935824 28327888
17:45:26 2307 8192000000 10962466224 11385184256 1944841200 19.185 97 77 154 2 2012805904 43848784 24115920
17:45:39 6332 8192000000 10965267904 11389190144 1967477632 19.365 99 70 140 2 2032345232 42993936 21873664
17:45:52 4436 8192000000 10960735024 11383533568 1967696416 19.367 99 72 143 1 2034848880 44322048 22830416
17:46:05 2685 8192000000 10959672784 11376136192 1970724112 19.391 100 79 156 0 2038382864 42562224 25096528
17:46:14 1726 8192000000 10939119088 11348426752 1939388112 19.142 98 86 170 3 2010393984 43774960 27230912
17:46:25 1874 8192000000 10954956544 11369852928 1964028464 19.338 100 81 160 1 2033845024 43749056 26067504
17:46:37 1141 8192000000 10958585360 11373797376 1967226288 19.363 100 85 170 3 2040260880 45595632 27438960
17:46:47 5382 8192000000 10939885552 11371266048 1951617056 19.239 99 58 115 2 2016058352 45657952 18783344
17:47:08 2631 8192000000 10939930848 11372953600 1950403248 19.230 99 50 100 0 2016802608 49274880 17124480
17:47:17 8020 8192000000 10917238320 11348340736 1930438384 19.070 99 46 92 0 1995276416 48460288 16377744
17:47:32 8549 8192000000 10903626176 11338264576 1905411664 18.870 98 37 74 0 1963925952 46039152 12475136
17:47:51 12419 8192000000 10909758256 11340750848 1933902464 19.098 100 51 102 0 1993334048 42670112 16761472
17:48:18 8168 8192000000 10911228368 11344359424 1927987984 19.051 99 42 84 1 1985385120 42880864 14516272
17:48:38 7130 8192000000 10945491808 11379339264 1961430048 19.317 100 43 86 1 2023943568 48359984 14153536
17:49:00 8098 8192000000 10947536336 11388973056 1970029888 19.386 100 38 76 1 2022661632 39777280 12854464
17:49:16 4408 8192000000 10930923568 11367063552 1960964080 19.314 100 69 139 3 2025896528 41650304 23282144
17:49:32 12208 8192000000 10944636448 11374735360 1964891456 19.345 100 45 90 1 2024824768 44633872 15299440
17:49:56 17101 8192000000 10928962640 11366780928 1943540368 19.175 99 41 82 1 2002967184 45337840 14088976
17:50:23 11305 8192000000 10929587360 11368210432 1939909824 19.146 99 41 82 2 2005212144 50419248 14883072
17:50:43 29307 8192000000 10925269680 11371819008 1933401168 19.094 99 36 73 2 1997119248 50824704 12893376
17:51:38 28405 8192000000 10886500848 11341041664 1895396448 18.789 98 25 50 2 1953006080 48544688 9064944
17:52:28 33711 8192000000 10869164160 11324428288 1888785488 18.736 99 18 36 1 1935506864 40424848 6296528
17:53:08 30262 8192000000 10861848128 11322654720 1890024752 18.746 99 23 46 1 1947308352 49176864 8106736
17:54:38 28083 8192000000 10892404000 11341963264 1927540800 19.047 100 20 40 1 1980746640 45727344 7478496
17:55:13 82957 8192000000 10855305104 11307962368 1840158304 18.342 95 17 34 2 1874142992 28440000 5544688
17:56:47 67786 8192000000 10860947856 11305938944 1889275840 18.740 98 14 27 0 1906538432 13685088 3577504
17:58:07 104689 8192000000 10893624384 11324002304 1933335600 19.094 99 57 112 1 1965505456 13556736 18613120
18:00:01 87573 8192000000 10877743568 11336290304 1888139120 18.731 97 26 52 0 1914708992 19276304 7293568
18:01:41 61752 8192000000 10899924576 11347148800 1941771200 19.161 99 25 48 0 1962928944 14726032 6431712
18:02:52 81238 8192000000 10935601040 11367571456 1966727280 19.359 99 75 152 0 2003720080 15518144 21474656
18:04:22 36226 8192000000 10905117136 11368849408 1976493024 19.437 100 30 58 4 2001221472 15875024 8853424
18:05:05 69771 8192000000 10931051072 11383013376 1971250832 19.395 99 36 72 3 1998331184 16437136 10643216
18:06:29 34485 8192000000 10927293600 11391188992 1993674112 19.573 100 27 54 1 2021319584 19511280 8134192
18:07:10 33247 8192000000 10911486336 11384066048 1975282336 19.427 100 20 40 1 2007811424 25835856 6693232
18:08:53 35192 8192000000 10885161216 11365355520 1949496624 19.222 99 18 36 0 1968021872 13059472 5465776
18:09:35 58561 8192000000 10872642368 11351826432 1923242672 19.013 98 6 12 1 1934204000 9310400 1650928
18:10:40 39500 8192000000 10880623952 11352453120 1942889680 19.170 99 9 18 0 1953604672 8252944 2462048
18:11:25 29566 8192000000 10892003632 11356004352 1963859632 19.337 100 20 40 0 1982235712 12406512 5969568
18:12:05 43025 8192000000 10873194720 11352903680 1908923712 18.898 97 12 24 2 1928830016 16906416 2999888
18:12:56 19243 8192000000 10884019120 11364823040 1956498480 19.278 100 9 18 0 1977243856 18040016 2705360
18:14:44 48456 8192000000 10904379968 11358605312 1948896704 19.218 99 20 36 3 1966374736 12154288 5323744
18:15:59 53819 8192000000 10891155440 11354923008 1929288864 19.061 98 24 49 0 1946639392 9784736 7565792
18:16:59 59285 8192000000 10889531552 11360722944 1953163120 19.252 99 26 52 0 1970020336 9748272 7108944
18:18:05 94549 8192000000 10892374976 11364859904 1936637312 19.120 98 15 30 0 1951792128 11253360 3901456
18:19:45 74469 8192000000 10915298336 11383193600 1963112768 19.331 99 24 47 4 1978691792 8745072 6833952
18:21:09 62272 8192000000 10923566432 11394142208 1988512320 19.532 100 17 34 1 2005132096 12291248 4328528
18:22:22 71746 8192000000 10916559344 11377057792 1949998512 19.226 98 12 23 0 1963215712 10226144 2991056
18:23:43 22207 8192000000 10930751008 11382329344 1956642336 19.279 98 46 90 0 1981192016 11933872 12615808
18:24:16 27002 8192000000 10924568608 11384037376 1978548304 19.453 100 32 64 0 2003721120 16149424 9023392
18:24:51 63862 8192000000 10899385856 11374559232 1913646448 18.936 97 13 26 0 1929501648 12099984 3755216
18:26:02 68556 8192000000 10897046784 11375210496 1931291424 19.077 98 7 14 0 1948092352 14191760 2609168
18:27:17 98696 8192000000 10907601408 11354816512 1921394208 18.998 97 34 68 0 1938076560 6855584 9826768
18:29:10 57575 8192000000 10869221712 11337687040 1937060176 19.123 99 22 44 0 1949985152 6989584 5935392
18:30:15 25853 8192000000 10890589232 11357347840 1963765600 19.336 100 29 58 1 1981930400 9745184 8419616
18:30:50 29754 8192000000 10855782448 11339153408 1922309760 19.005 98 10 20 0 1941076192 16100816 2665616
18:32:29 73099 8192000000 10890358992 11357696000 1912101280 18.924 97 13 26 0 1929219904 13374000 3744624
18:33:54 49124 8192000000 10890508592 11368562688 1966926880 19.361 100 16 31 1 1989271808 17585328 4759600
18:35:03 83868 8192000000 10893135904 11368767488 1933809936 19.097 98 11 22 1 1958542272 21393504 3338832
18:36:33 44949 8192000000 10893978544 11370491904 1916415968 18.958 98 17 34 0 1948391568 26717248 5258352
18:37:50 68717 8192000000 10852505120 11316432896 1860985072 18.511 96 16 32 1 1883978912 18537584 4456256
18:39:30 20606 8192000000 10857998160 11310804992 1880661360 18.670 97 42 84 2 1901120480 8382560 12076560
18:39:58 50687 8192000000 10846257680 11306942464 1872228032 18.602 97 27 54 0 1889693792 9950864 7514896
18:41:06 58968 8192000000 10815934400 11282964480 1792052112 17.949 94 24 48 1 1809781664 11548528 6181024
18:42:13 34947 8192000000 10850174240 11287797760 1811819264 18.111 95 37 69 2 1834338576 12523008 9996304
18:42:55 58463 8192000000 10846058816 11322417152 1912557392 18.927 100 30 60 0 1935150480 14185184 8407904
18:44:05 93950 8192000000 10849284240 11303202816 1828206640 18.245 95 23 46 1 1850210528 15983008 6020880
18:45:45 35559 8192000000 10838549696 11284557824 1852897280 18.446 97 31 62 1 1871134704 9601616 8635808
18:46:27 33889 8192000000 10851948624 11298856960 1861738592 18.517 97 30 59 3 1884418128 14126992 8552544
18:47:13 52092 8192000000 10834809872 11313065984 1884959696 18.705 99 16 32 1 1904822400 15571632 4291072
18:48:11 92165 8192000000 10852393968 11304304640 1867718144 18.566 97 20 40 3 1884614944 10862576 6034224
18:49:49 99215 8192000000 10838961632 11306594304 1907905296 18.890 99 28 56 0 1929923088 13247056 8770736
18:51:58 38833 8192000000 10865874608 11321401344 1909749264 18.905 99 23 46 1 1925914304 8968480 7196560
18:52:45 73412 8192000000 10856524512 11333271552 1934215232 19.101 100 16 32 0 1946931920 8573056 4143632
18:54:08 73119 8192000000 10880119184 11336728576 1903944320 18.858 98 15 30 2 1917065040 8381408 4739312
18:55:32 73748 8192000000 10859000672 11339575296 1928363648 19.054 99 18 36 0 1943116800 9786816 4966336
18:57:48 73730 8192000000 10882598032 11359367168 1930422576 19.070 99 10 19 0 1943870720 11287104 2161040
18:59:17 90871 8192000000 10890390832 11369795584 1926136368 19.036 98 16 32 0 1941798112 11215008 4446736
19:01:02 52522 8192000000 10900778592 11375640576 1971544304 19.398 100 15 29 1 1989092176 12916592 4631280
19:02:08 61773 8192000000 10917667840 11387244544 1964295600 19.340 99 21 42 1 1984978160 14846768 5835792
19:03:21 58474 8192000000 10898258272 11382841344 1939113088 19.140 98 13 26 2 1962297440 19037584 4146768
19:04:26 95628 8192000000 10907654112 11374387200 1911642720 18.920 97 12 24 0 1935589520 20739552 3207248
19:06:16 31475 8192000000 10906576800 11363622912 1952988960 19.250 99 38 74 0 1974637472 11203392 10445120
19:06:57 16834 8192000000 10922597040 11366449152 1955309008 19.269 99 48 95 0 1978508480 9614944 13584528
19:07:23 16255 8192000000 10905911856 11358986240 1932865664 19.090 98 47 94 1 1957316896 11444416 13006816
19:07:45 59781 8192000000 10900171296 11364360192 1939769440 19.145 99 33 66 1 1961555072 12887744 8897888
19:08:53 49857 8192000000 10898178736 11370336256 1948457936 19.214 99 26 52 2 1967000288 11702624 6839728
19:09:49 43511 8192000000 10922429664 11377246208 1956160144 19.276 99 33 66 0 1976138384 10565712 9412528
19:10:41 44704 8192000000 10891869744 11356184576 1911150896 18.916 97 28 56 0 1932163408 13218848 7793664
19:11:40 104342 8192000000 10878026688 11351642112 1930604656 19.072 99 16 32 0 1949786992 14550656 4631680
19:13:44 43571 8192000000 10898831552 11373166592 1970720528 19.391 100 25 50 2 1990558144 12003136 7834480
19:14:49 52978 8192000000 10857871120 11343106048 1923280304 19.013 98 14 28 0 1934886288 7118864 4487120
19:15:48 49958 8192000000 10857874800 11343958016 1934595536 19.104 99 13 26 0 1946614560 8457440 3561584
19:16:44 19886 8192000000 10861413088 11347451904 1947452720 19.206 100 3 6 0 1956204944 7987360 764864
19:17:10 365 8192000000 10864696368 11351187456 1952614768 19.247 100 3 6 0 1961585056 8205424 764864
19:17:17 1412 8192000000 10868892976 11355508736 1956330880 19.277 100 4 8 0 1965752096 8355408 1065808
19:17:24 24045 8192000000 10889621376 11358203904 1940905600 19.154 99 13 24 2 1953095808 8002144 4188064
19:18:01 48157 8192000000 10883479856 11369508864 1963518064 19.334 100 17 34 0 1979187072 10242304 5426704
19:18:58 95031 8192000000 10873508432 11356688384 1901791216 18.841 97 10 20 0 1918673088 13803168 3078704
19:20:39 73388 8192000000 10869140064 11353399296 1895554592 18.791 97 14 26 2 1913203168 13833616 3814960
19:22:13 48142 8192000000 10871230688 11347005440 1899986448 18.826 97 26 52 0 1923000864 15090752 7923664
19:23:07 52778 8192000000 10842520640 11310981120 1827565872 18.239 94 13 26 0 1846959056 15492704 3900480
19:24:10 47951 8192000000 10837820160 11319640064 1874747472 18.623 98 17 34 2 1892299216 12802736 4749008
19:25:04 45541 8192000000 10862982576 11320770560 1870321040 18.587 97 16 32 1 1888634880 13819584 4494256
19:26:01 89919 8192000000 9898032720 10273955840 987647872 10.759 52 12 24 0 1006573792 16096960 2828960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-03-2021 19:28:49 to 27-03-2021 19:29:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 85 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 27-03-2021 19:29:21 to 27-03-2021 19:29:23.

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          236495
MON$OLDEST_ACTIVE               239687
MON$OLDEST_SNAPSHOT             239687
MON$NEXT_TRANSACTION            239687
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                       2020160
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Sat Mar 27 19:27:39 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Mar 27 19:27:39 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

27.03.21 19:29:24. 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-03-27 19:29:26 No severe PSQL-related problems occured
27.03.21 19:29:27. End of report.