Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.03.2021 16: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 17538900 kB
MemAvailable 31610260 kB
Buffers 0 kB
Cached 14129496 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-05 16:27:22
DTS_END                         2021-03-05 16:27:22.8300
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46112
TRN_ID                          241531
ATT_ID                          635
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: 9366.34 21439 1123961
customer order: creation 177.77 360 21332
customer order: refuse 14.83 314 1779
order to supplier: creation 47.48 1257 5697
order to supplier: removal 3.48 99313 418
invoice (draft): creation 46.13 3185 5536
invoice (draft): removal 52.73 818 6328
invoice accept: apply 42.00 17450 5040
invoice accept: cancel 48.30 769 5796
customer reserve: creation 3896.86 171 467623
customer reserve: removal 4733.77 56 568052
realization accept: apply 85.08 180 10210
realization accept: cancel 84.99 103 10199
payment from customer: creation 60.38 102 7246
payment from customer: removal 5.76 75 691
payment to supplier: creation 50.73 123 6087
payment to supplier: removal 3.83 92 459
service: total inventory turnovers 4.85 1158 582
service: total monetary turnovers 6.54 23 785
service: aggregate perf. data 0.81 24536 97
service: refresh index statistics 0.03 278695 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-03-2021 16:28:39 to 05-03-2021 16:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3651
TEST_TIME 2 4145
TEST_TIME 3 5204
TEST_TIME 4 5478
TEST_TIME 5 6000
TEST_TIME 6 5736
TEST_TIME 7 5734
TEST_TIME 8 5644
TEST_TIME 9 5714
TEST_TIME 10 6076
TEST_TIME 11 6255
TEST_TIME 12 6526
TEST_TIME 13 7149
TEST_TIME 14 7324
TEST_TIME 15 7558
TEST_TIME 16 7569
TEST_TIME 17 7798
TEST_TIME 18 7751
TEST_TIME 19 8024
TEST_TIME 20 8241
TEST_TIME 21 9004
TEST_TIME 22 9099
TEST_TIME 23 9761
TEST_TIME 24 10272
TEST_TIME 25 10893
TEST_TIME 26 11196
TEST_TIME 27 10927
TEST_TIME 28 10939
TEST_TIME 29 11263
TEST_TIME 30 11116
TEST_TIME 31 11137
TEST_TIME 32 10961
TEST_TIME 33 10849
TEST_TIME 34 10812
TEST_TIME 35 10682
TEST_TIME 36 10646
TEST_TIME 37 10496
TEST_TIME 38 10410
TEST_TIME 39 10388
TEST_TIME 40 10440
TEST_TIME 41 10423
TEST_TIME 42 10338
TEST_TIME 43 10193
TEST_TIME 44 10115
TEST_TIME 45 10085
TEST_TIME 46 10001
TEST_TIME 47 9960
TEST_TIME 48 9877
TEST_TIME 49 9774
TEST_TIME 50 9666
TEST_TIME 51 9552
TEST_TIME 52 9580
TEST_TIME 53 9592
TEST_TIME 54 9747
TEST_TIME 55 9682
TEST_TIME 56 9790
TEST_TIME 57 9854
TEST_TIME 58 9903
TEST_TIME 59 9913
TEST_TIME 60 10007
TEST_TIME 61 10008
TEST_TIME 62 10053
TEST_TIME 63 9993
TEST_TIME 64 10013
TEST_TIME 65 9913
TEST_TIME 66 9790
TEST_TIME 67 9840
TEST_TIME 68 9887
TEST_TIME 69 9808
TEST_TIME 70 9745
TEST_TIME 71 9703
TEST_TIME 72 9673
TEST_TIME 73 9623
TEST_TIME 74 9600
TEST_TIME 75 9555
TEST_TIME 76 9557
TEST_TIME 77 9543
TEST_TIME 78 9559
TEST_TIME 79 9615
TEST_TIME 80 9619
TEST_TIME 81 9604
TEST_TIME 82 9583
TEST_TIME 83 9601
TEST_TIME 84 9650
TEST_TIME 85 9601
TEST_TIME 86 9653
TEST_TIME 87 9715
TEST_TIME 88 9761
TEST_TIME 89 9657
TEST_TIME 90 9633
TEST_TIME 91 9604
TEST_TIME 92 9629
TEST_TIME 93 9573
TEST_TIME 94 9514
TEST_TIME 95 9470
TEST_TIME 96 9512
TEST_TIME 97 9499
TEST_TIME 98 9492
TEST_TIME 99 9512
TEST_TIME 100 9489
TEST_TIME 101 9505
TEST_TIME 102 9515
TEST_TIME 103 9508
TEST_TIME 104 9553
TEST_TIME 105 9553
TEST_TIME 106 9561
TEST_TIME 107 9568
TEST_TIME 108 9583
TEST_TIME 109 9585
TEST_TIME 110 9504
TEST_TIME 111 9502
TEST_TIME 112 9482
TEST_TIME 113 9490
TEST_TIME 114 9442
TEST_TIME 115 9415
TEST_TIME 116 9376
TEST_TIME 117 9406
TEST_TIME 118 9441
TEST_TIME 119 9424
TEST_TIME 120 9370

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-03-2021 16:28:43 to 05-03-2021 16:28:46.

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 1556917 1556917 0 0.00 0 30271 6 0 0
doc_list_biud 1556917 1556917 0 0.00 0 65062 27 0 0
sp_add_invoice_to_stock 5246 5040 206 3.92 49 200653 17450 0 206
sp_cancel_adding_invoice 5796 5796 0 0.00 5 53500 769 0 0
sp_cancel_client_order 1779 1779 0 0.00 4 8929 314 0 0
sp_cancel_customer_reserve 568052 568052 0 0.00 1 65066 57 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 4220 75 0 0
sp_cancel_pay_to_supplier 459 459 0 0.00 3 6519 93 0 0
sp_cancel_supplier_invoice 6351 6328 23 0.36 2 52845 819 0 23
sp_cancel_supplier_order 418 418 0 0.00 6 1287618 99313 0 0
sp_cancel_write_off 10199 10199 0 0.00 1 21646 104 0 0
sp_client_order 21332 21332 0 0.00 3 29533 360 0 0
sp_customer_reserve 467623 467623 0 0.00 0 43362 172 0 0
sp_fill_shopping_cart 32556 32556 0 0.00 1 15060 34 0 0
sp_fill_shopping_cart_clo_res 467618 467618 0 0.00 0 15435 14 0 0
sp_get_clo_for_invoice 5035 5035 0 0.00 0 20513 304 0 0
sp_kill_cost_storno 17145 17145 0 0.00 0 7949 51 0 0
sp_kill_qstorno_ret_qs2qd 1153049 1153049 0 0.00 0 65053 31 0 0
sp_kill_qty_storno 607817 607817 0 0.00 0 65061 68 0 0
sp_lock_selected_doc 21119 21119 0 0.00 0 9124 6 0 0
sp_make_cost_storno 28578 28578 0 0.00 0 12191 48 0 0
sp_multiply_rows_for_pdistr 28578 28578 0 0.00 0 8205 27 0 0
sp_multiply_rows_for_qdistr 21332 21332 0 0.00 0 11555 159 0 0
sp_pay_from_customer 7246 7246 0 0.00 4 14462 102 0 0
sp_pay_to_supplier 6087 6087 0 0.00 4 16947 124 0 0
sp_payment_common 13333 13333 0 0.00 1 9981 28 0 0
sp_qd_handle_on_cancel_clo 1779 1779 0 0.00 0 8921 278 0 0
sp_qd_handle_on_invoice_upd_sts 10831 10831 0 0.00 0 18088 334 0 0
sp_qd_handle_on_reserve_upd_sts 10210 10210 0 0.00 0 21442 67 0 0
sp_reserve_write_off 10210 10210 0 0.00 6 21651 181 0 0
sp_supplier_invoice 5536 5536 0 0.00 5 81429 3185 0 0
sp_supplier_order 5697 5697 0 0.00 4 71344 1257 0 0
srv_aggregate_perf_data 97 97 0 0.00 2423 515045 24536 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1107 146184 33829 0 0
srv_find_qd_qs_mism 1075131 1075131 0 0.00 0 30269 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 19 41094 1159 0 0
srv_make_money_saldo 785 785 0 0.00 1 621 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 153581 368856 278696 0 0
t$perf-abend:sp_add_invoice_to_stock 206 206 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 23 23 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5040 5040 0 0.00 0 14140 157 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 4658 119 0 0
t$perf-norm:sp_cancel_client_order 1779 1779 0 0.00 0 9318 17 0 0
t$perf-norm:sp_cancel_customer_reserve 641 641 0 0.00 0 3537 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 293 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 459 459 0 0.00 0 1541 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 4160 22 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 38116 1502 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 6031 15 0 0
t$perf-norm:sp_client_order 21332 21332 0 0.00 0 8880 20 0 0
t$perf-norm:sp_customer_reserve 1079 1079 0 0.00 0 547 3 0 0
t$perf-norm:sp_pay_from_customer 7246 7246 0 0.00 0 3566 8 0 0
t$perf-norm:sp_pay_to_supplier 6087 6087 0 0.00 0 10333 9 0 0
t$perf-norm:sp_reserve_write_off 10210 10210 0 0.00 0 9067 13 0 0
t$perf-norm:sp_supplier_invoice 5536 5536 0 0.00 0 9444 20 0 0
t$perf-norm:sp_supplier_order 5697 5697 0 0.00 0 2935 16 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 373 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 2012 23 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 1498 20 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 537 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10478 10066 412 3.93 0 13356 22 0 412
v_all_customers 38632 38632 0 0.00 0 30 1 0 0
v_all_suppliers 31494 31494 0 0.00 0 49 1 0 0
v_all_wares 42664 42664 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 2887 17 0 0
v_cancel_client_order 3558 3558 0 0.00 0 4608 5 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 4198 8 0 0
v_cancel_customer_reserve 1282 1282 0 0.00 0 3934 6 0 0
v_cancel_payment_to_supplier 918 918 0 0.00 0 815 5 0 0
v_cancel_supplier_invoice 848 802 46 5.42 0 3210 20 0 46
v_cancel_supplier_order 836 836 0 0.00 0 4164 23 0 0
v_cancel_write_off 2102 2102 0 0.00 0 1032 13 0 0
v_max_id_clo_ord 5695 5695 0 0.00 0 5188 2 0 0
v_max_id_clo_res 1079 1079 0 0.00 0 3342 17 0 0
v_max_id_ord_sup 5528 5528 0 0.00 0 4113 6 0 0
v_max_non_paid_invoice 1563 1563 0 0.00 0 382 2 0 0
v_max_non_paid_realizn 3825 3825 0 0.00 0 2100 5 0 0
v_min_id_clo_ord 5695 5695 0 0.00 0 2694 5 0 0
v_min_id_clo_res 1079 1079 0 0.00 0 4965 8 0 0
v_min_id_ord_sup 5528 5528 0 0.00 0 4792 6 0 0
v_min_non_paid_invoice 6087 6087 0 0.00 0 8511 16 0 0
v_min_non_paid_realizn 7246 7246 0 0.00 0 7480 20 0 0
v_our_firm 10874 10874 0 0.00 0 17 1 0 0
v_reserve_write_off 20420 20420 0 0.00 0 9213 6 0 0
x_lock_depdocs_on_canc_invoice 11723 11723 0 0.00 0 13587 105 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 5191 298 0 0
x_make_qstorno_1000_1200 5697 5697 0 0.00 2 71331 1178 0 0
x_make_qstorno_1200_2000 5536 5536 0 0.00 2 81421 3067 0 0
x_make_qstorno_2100_3300 467623 467623 0 0.00 0 41940 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-03-2021 16:28:47 to 05-03-2021 16:28:51.

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
13:57:26 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:32 9162 8192000000 10177812016 10480361472 876955136 9.669 71 57 116 1 898381904 2490688 18936080
13:57:50 27898 8192000000 10314735200 10625527808 1351731216 14.163 100 79 158 0 1382623584 4550944 26341424
13:58:27 25373 8192000000 10365162048 10681995264 1419448048 14.768 100 94 188 0 1456022544 5864432 30710064
13:59:08 14652 8192000000 10387881008 10710364160 1445230464 14.996 100 92 184 0 1482127760 6650432 30246864
13:59:30 32216 8192000000 10407033344 10733674496 1460139824 15.127 100 92 185 0 1497519136 7399424 29979888
14:00:13 18094 8192000000 10428526064 10756845568 1482592080 15.324 100 88 176 0 1518395392 7686320 28116992
14:00:43 17137 8192000000 10443402320 10775588864 1496340128 15.444 100 86 172 0 1532457504 8114128 28003248
14:01:09 10093 8192000000 10452593696 10790330368 1515934048 15.615 100 80 160 0 1549511280 8164224 25413008
14:01:37 16293 8192000000 10489731984 10837127168 1544133712 15.859 100 75 150 0 1575869520 8532832 23202976
14:02:01 17959 8192000000 10534961840 10883903488 1594897504 16.296 100 75 150 0 1627345936 9239856 23208576
14:02:29 10023 8192000000 10547376176 10905358336 1607050720 16.400 100 74 148 1 1639588176 9816000 22721456
14:02:47 14847 8192000000 10567463360 10928717824 1630611248 16.600 100 72 144 0 1662712240 10866496 21234496
14:03:09 11734 8192000000 10606381552 10969026560 1656718432 16.821 100 77 155 0 1690800336 11719408 22362496
14:03:30 12101 8192000000 10617348400 10981306368 1673461264 16.962 100 83 166 0 1710281536 12065504 24754768
14:03:52 13568 8192000000 10633990656 11001892864 1688862448 17.092 100 84 168 2 1726253472 13136272 24254752
14:04:15 8706 8192000000 10644234320 11013500928 1697989200 17.168 100 74 146 3 1731651408 12319616 21342592
14:04:32 7803 8192000000 10660956032 11027566592 1718288096 17.338 100 84 168 5 1756534944 13370608 24876240
14:04:46 7778 8192000000 10654363888 11031560192 1722221584 17.371 100 73 146 2 1755692272 12427744 21042944
14:05:01 9529 8192000000 10678349968 11050725376 1735488304 17.481 100 79 160 1 1770883200 12581456 22813440
14:05:18 6385 8192000000 10684639632 11064344576 1750427296 17.605 100 80 158 0 1786431744 13644000 22360448
14:05:32 4465 8192000000 10694712624 11071803392 1756076336 17.652 100 81 162 0 1792550224 14173456 22300432
14:05:44 5370 8192000000 10703136496 11079991296 1764519648 17.722 100 82 164 2 1802083456 14993744 22570064
14:05:56 10674 8192000000 10698763936 11079966720 1764863904 17.725 100 72 144 1 1799086752 14253632 19969216
14:06:15 4564 8192000000 10716853232 11099267072 1771916144 17.783 100 81 160 1 1808262544 13410608 22935792
14:06:27 4420 8192000000 10734087568 11115712512 1793218080 17.958 100 76 152 0 1827345760 12574048 21553632
14:06:38 4481 8192000000 10742050704 11128553472 1806009008 18.063 100 81 161 2 1839764304 11579840 22175456
14:06:50 4474 8192000000 10757193104 11143106560 1812763632 18.119 100 84 166 1 1848379424 11266688 24349104
14:07:02 3264 8192000000 10760933488 11146395648 1820779872 18.184 100 75 150 1 1853796848 11983280 21033696
14:07:12 3173 8192000000 10772256160 11155206144 1829246208 18.253 100 92 185 4 1868364384 12963424 26154752
14:07:24 2445 8192000000 10772889728 11160891392 1838357600 18.327 100 87 175 0 1876797104 13489248 24950256
14:07:33 3064 8192000000 10787463488 11173187584 1843402720 18.368 100 89 178 0 1882087552 13600976 25083856
14:07:43 2082 8192000000 10781514640 11166867456 1844122992 18.374 100 82 165 2 1878429056 11611248 22694816
14:07:52 2972 8192000000 10787162576 11174318080 1844319024 18.376 100 72 144 1 1877661968 12947088 20395856
14:08:01 1343 8192000000 10794281952 11177340928 1852547312 18.443 100 88 176 0 1890249536 12774304 24927920
14:08:09 1720 8192000000 10794001136 11182321664 1854993104 18.463 100 88 177 0 1893356736 13020016 25343616
14:08:17 2312 8192000000 10798861664 11187994624 1857749472 18.485 100 87 174 1 1895133488 13537696 23846320
14:08:26 1748 8192000000 10805394048 11191177216 1859454752 18.499 100 90 180 1 1897092800 12197744 25440304
14:08:34 2424 8192000000 10800098096 11188891648 1864331568 18.538 100 91 180 1 1901863440 12150928 25380944
14:08:43 1383 8192000000 10802627264 11193511936 1863750720 18.534 100 88 176 2 1901116608 13002176 24363712
14:08:51 18057 8192000000 10797057408 11194720256 1860457152 18.507 100 59 118 2 1888836336 12299856 16079328
14:09:16 18719 8192000000 10808937088 11196297216 1867729856 18.566 100 87 174 2 1903661456 11682896 24248704
14:09:41 1059 8192000000 10801712240 11202236416 1870310928 18.587 100 78 156 1 1905178640 12781104 22086608
14:09:48 10914 8192000000 10799250384 11200503808 1867545552 18.564 100 62 124 1 1896346960 11942640 16858768
14:10:06 4065 8192000000 10779888064 11196407808 1868694624 18.574 100 48 95 0 1895872016 14601008 12576384
14:10:16 3913 8192000000 10786395392 11199533056 1868523344 18.572 100 51 100 1 1892507984 10153552 13831088
14:10:27 3340 8192000000 10797387568 11204313088 1872516656 18.605 100 48 94 0 1894148384 9279408 12352320
14:10:37 3082 8192000000 10792983696 11203616768 1870535344 18.589 100 44 88 2 1892090816 8698928 12856544
14:10:49 3390 8192000000 10799568704 11198648320 1871385376 18.595 100 51 97 2 1892494032 7730496 13378160
14:11:02 5390 8192000000 10785680256 11203018752 1871249456 18.594 100 25 50 1 1884414768 6075680 7089632
14:11:14 4001 8192000000 10778995920 11203231744 1872952272 18.608 100 28 56 2 1888645888 7949504 7744112
14:11:24 5305 8192000000 10783049232 11207073792 1875706640 18.630 100 37 74 2 1894038704 7821344 10510720
14:11:38 11220 8192000000 10793083920 11212537856 1874919344 18.624 100 34 68 1 1892263328 7879152 9464832
14:11:56 5782 8192000000 10789680000 11209945088 1881129312 18.674 100 34 66 1 1897780624 6901424 9749888
14:12:11 9112 8192000000 10789905328 11208937472 1879105184 18.658 100 27 52 1 1893104960 6831792 7167984
14:12:27 4627 8192000000 10805763904 11217616896 1883374944 18.692 100 48 97 3 1906364064 9856432 13132688
14:12:38 7102 8192000000 10795216576 11214856192 1881575952 18.678 100 34 67 1 1897497776 6489840 9431984
14:12:51 66886 8192000000 10813992256 11227545600 1882161760 18.683 100 27 53 2 1896473200 6118400 8193040
14:14:04 3056 8192000000 10821886368 11239067648 1895635984 18.791 100 74 149 1 1927166752 9964800 21565968
14:14:16 4688 8192000000 10807907856 11236237312 1892722384 18.768 100 39 74 5 1910978560 8148336 10107840
14:14:27 7203 8192000000 10807898704 11235225600 1891812064 18.760 100 33 66 3 1908578480 7745792 9020624
14:14:43 4466 8192000000 10818441680 11241558016 1894107584 18.779 100 38 76 0 1913352416 7407168 11837664
14:14:54 7156 8192000000 10812614752 11241730048 1894263872 18.780 100 25 50 0 1912154992 11051776 6839344
14:15:09 6741 8192000000 10818217632 11241377792 1897222464 18.804 100 39 76 1 1915781872 7344848 11214560
14:15:23 6782 8192000000 10810907200 11240480768 1894468672 18.782 100 24 48 1 1907986000 6098272 7419056
14:15:36 4919 8192000000 10820830992 11237289984 1898571600 18.815 100 35 68 1 1912823456 5666992 8584864
14:15:48 10013 8192000000 10811119872 11237642240 1895376000 18.789 100 19 38 4 1906684912 5323104 5985808
14:16:04 7893 8192000000 10816308912 11239653376 1896315424 18.797 100 22 44 1 1908241856 5616288 6310144
14:16:20 12428 8192000000 10815405216 11243331584 1898840784 18.817 100 20 40 1 1910057696 5522608 5694304
14:16:39 6178 8192000000 10812527088 11235684352 1877694256 18.646 99 24 48 2 1891354144 6420320 7239568
14:16:52 13914 8192000000 10816900304 11227975680 1892347840 18.765 100 40 80 3 1909623952 5548800 11727312
14:18:03 22141 8192000000 10781435216 11203121152 1775225376 17.810 94 21 42 0 1785657680 5000624 5431680
14:18:33 5286 8192000000 10787482656 11197304832 1844894976 18.381 99 41 81 1 1863662496 6343536 12423984
14:18:46 7961 8192000000 10770726256 11196661760 1828935584 18.251 98 21 41 2 1839990432 4866560 6188288
14:19:01 5810 8192000000 10744992224 11157889024 1784382448 17.886 96 32 65 2 1799244816 6256800 8605568
14:19:15 6980 8192000000 10745859696 11164311552 1814002416 18.129 98 28 54 0 1828257040 6495328 7759296
14:19:29 7372 8192000000 10739617568 11154915328 1785403232 17.894 97 36 71 2 1803413744 8258160 9752352
14:19:45 3795 8192000000 10743060320 11158441984 1806379616 18.066 98 34 65 4 1823271168 6984896 9906656
14:19:55 6582 8192000000 10747054352 11165376512 1802690576 18.036 98 27 54 1 1817223664 6263392 8269696
14:20:11 8475 8192000000 10728074448 11142074368 1763525392 17.714 97 35 71 0 1780356176 6601520 10229264
14:20:27 4882 8192000000 10686152384 11094343680 1748438800 17.589 97 37 74 1 1769215936 10138464 10638672
14:20:39 10947 8192000000 10714627856 11130691584 1778047280 17.833 98 20 40 3 1789033056 5249856 5735920
14:20:59 8224 8192000000 10670070112 11078332416 1695494656 17.147 94 26 52 0 1713364352 10481776 7387920
14:21:13 9787 8192000000 10704438976 11112878080 1757164320 17.661 98 22 44 1 1769546000 5365504 7016176
14:22:03 35533 8192000000 10690524304 11104157696 1714824768 17.309 95 35 70 0 1730886176 5968704 10092704
14:22:46 5480 8192000000 10731802384 11129655296 1765979488 17.734 98 34 68 1 1781725824 5924864 9821472
14:23:00 4747 8192000000 10728786272 11135594496 1778466272 17.837 98 42 84 2 1798444976 7013520 12965184
14:23:12 6974 8192000000 10740039056 11145887744 1811094352 18.105 100 33 64 3 1826928048 5987504 9846192
14:23:25 7661 8192000000 10734278560 11147251712 1797850864 17.996 99 32 64 1 1813281696 6332224 9098608
14:23:40 3592 8192000000 10743006336 11162644480 1825322256 18.221 100 42 84 1 1845011280 7552576 12136448
14:23:52 9487 8192000000 10734521440 11160854528 1809700624 18.093 99 28 56 2 1823711792 6094464 7916704
14:24:10 7421 8192000000 10754104304 11170639872 1829311840 18.254 100 25 50 0 1842162256 5719664 7130752
14:24:25 8473 8192000000 10745492128 11179761664 1837095312 18.317 100 17 34 2 1847458032 5430208 4932512
14:24:40 7302 8192000000 10762123536 11187363840 1838278480 18.327 100 20 40 0 1853255808 9940048 5037280
14:24:55 7723 8192000000 10771983648 11187007488 1844565104 18.378 100 32 65 1 1860745200 6467728 9712368
14:25:11 7283 8192000000 10766466624 11189727232 1846730688 18.396 100 21 42 2 1858371440 5302320 6338432
14:25:28 8497 8192000000 10779473072 11199758336 1849944784 18.422 100 21 41 1 1864802320 9637248 5220288
14:25:42 56018 8192000000 10770304528 11197513728 1855632304 18.468 100 30 59 2 1868961648 5471888 7857456
14:26:45 19797 8192000000 10787494032 11216498688 1863366064 18.531 100 17 32 2 1876301152 8826144 4108944
14:27:12 8626 8192000000 10797105568 11224346624 1884047760 18.698 100 19 38 1 1894035264 4689088 5298416
14:27:28 8577 8192000000 10822374128 11239878656 1898005008 18.810 100 54 108 4 1918631536 5424976 15201552
14:27:57 3683 8192000000 10840167936 11251003392 1905740720 18.872 100 60 118 2 1928876144 6826176 16309248
14:28:08 5375 8192000000 10850388848 11265798144 1911395008 18.918 100 62 123 1 1943209424 14211520 17602896
14:28:29 36929 8192000000 10848352656 11268288512 1912104448 18.924 100 58 115 0 1938665168 10503072 16057648
14:29:26 37872 8192000000 10850031264 11281575936 1924494192 19.023 100 48 96 2 1951769536 13588320 13687024
14:30:11 43990 8192000000 10865267632 11302903808 1931279328 19.077 100 37 74 1 1959170496 17941312 9949856
14:31:02 28807 8192000000 10866523088 11310641152 1939592800 19.144 100 38 76 0 1964986240 14595584 10797856
14:31:49 9705 8192000000 10892829312 11321614336 1956354800 19.277 100 46 92 4 1982286704 12157744 13774160
14:32:08 10128 8192000000 10896228304 11325968384 1959450576 19.302 100 50 100 0 1992404640 18417056 14537008
14:32:30 10567 8192000000 10903678992 11336105984 1964899392 19.345 100 54 108 0 1995965776 15019216 16047168
14:32:54 4751 8192000000 10911150096 11342053376 1971180048 19.395 100 53 106 1 2000560032 14039888 15340096
14:33:08 8038 8192000000 10903481648 11340685312 1971218336 19.395 100 39 78 1 1996750240 14188480 11343424
14:33:25 37440 8192000000 10916302896 11356581888 1979692944 19.462 100 41 79 1 2006711840 15330656 11688240
14:34:10 8293 8192000000 10936478240 11363041280 1991905824 19.559 100 66 131 0 2025767216 15213232 18648160
14:34:29 4318 8192000000 10933012016 11356946432 1986270752 19.514 100 50 100 1 2015940176 15498640 14170784
14:34:41 6497 8192000000 10942800416 11370631168 1995201072 19.585 100 72 140 2 2036261392 20689984 20370336
14:34:57 5795 8192000000 10926718032 11354624000 1980932368 19.472 99 72 140 0 2018690160 17164976 20592816
14:35:09 21885 8192000000 10946126448 11371012096 1995487600 19.587 100 60 121 2 2031700864 18698576 17514688
14:35:40 14168 8192000000 10941933184 11377897472 2000478016 19.627 100 63 126 0 2038529792 19305376 18746400
14:36:06 4952 8192000000 10948719392 11385008128 2005692672 19.668 100 50 100 0 2042536944 21371168 15473104
14:36:18 7612 8192000000 10950678656 11386580992 2007846496 19.685 100 66 131 1 2048543200 21243184 19453520
14:36:34 2826 8192000000 10960270496 11391324160 2011280880 19.712 100 53 106 1 2049264192 21580720 16402592
14:36:45 7790 8192000000 10977872352 11406397440 2016047616 19.749 100 71 141 1 2060191136 22949904 21193616
14:37:01 6257 8192000000 10965657136 11396149248 2000397248 19.626 99 68 135 5 2042980560 23184560 19398752
14:37:14 7740 8192000000 10960396416 11395936256 2005007728 19.662 100 55 110 0 2047196048 24650704 17537616
14:37:35 5825 8192000000 10940426960 11379879936 1987040704 19.520 99 39 77 3 2029134720 29426752 12667264
14:37:49 6223 8192000000 10948850880 11383898112 1993125488 19.568 100 54 107 1 2038027744 28523136 16379120
14:38:04 2601 8192000000 10960035840 11375443968 1980868336 19.472 99 78 157 0 2037468656 32664752 23935568
14:38:14 5428 8192000000 10962326112 11389124608 1995047536 19.584 100 65 130 0 2049961232 34843680 20070016
14:38:26 3997 8192000000 10961320832 11382419456 1985576272 19.509 99 72 142 0 2042012544 34994144 21442128
14:38:38 4137 8192000000 10979889264 11401416704 2004540224 19.659 100 81 162 1 2064602832 34680768 25381840
14:38:49 9183 8192000000 10958090512 11391066112 1985214592 19.506 99 63 126 0 2041807664 36672528 19920544
14:39:08 4259 8192000000 10957298736 11385724928 1980972432 19.472 99 62 119 2 2037475808 37087360 19416016
14:39:22 9774 8192000000 10974853392 11400163328 1998960816 19.615 100 66 132 2 2057863184 37919472 20982896
14:39:39 6417 8192000000 10950739600 11386167296 1987075712 19.521 100 60 120 0 2045454896 38363872 20015312
14:39:54 4234 8192000000 10971683232 11397443584 2000312032 19.625 100 68 134 2 2058441568 37154448 20975088
14:40:07 3811 8192000000 10971639104 11408601088 2007329728 19.680 100 61 122 2 2065110704 38961120 18819856
14:40:18 5384 8192000000 10966260944 11398582272 2003864208 19.653 100 71 140 1 2062258000 36531488 21862304
14:40:32 4131 8192000000 10962596512 11383898112 1991191504 19.553 100 78 156 0 2049413600 34631344 23590752
14:40:43 5031 8192000000 10979253312 11402604544 1997659024 19.604 100 73 146 0 2065160144 45198976 22302144
14:40:56 4166 8192000000 10979033008 11394985984 1998715296 19.613 100 83 166 2 2060502400 35918800 25868304
14:41:08 4666 8192000000 10978597312 11408363520 2006599536 19.675 100 72 144 3 2067374048 38002912 22771600
14:41:23 2655 8192000000 10982470704 11400269824 1986301568 19.515 99 73 146 3 2048302544 39228864 22772112
14:41:36 6227 8192000000 10960076304 11375808512 1983254784 19.490 99 72 137 1 2042101856 38258080 20588992
14:41:51 3637 8192000000 10973380320 11402485760 2002923456 19.646 100 75 149 2 2065837520 38976992 23937072
14:42:02 1953 8192000000 10961846000 11377758208 1955613296 19.271 98 84 166 3 2020928224 39501856 25813072
14:42:14 3080 8192000000 10961485040 11380097024 1980451744 19.468 100 75 147 0 2043052384 40354016 22246624
14:42:28 7775 8192000000 10938128704 11367731200 1970777024 19.392 100 71 142 2 2031288288 38548016 21963248
14:42:44 2829 8192000000 10946771776 11356659712 1944784288 19.185 98 84 169 0 2007861536 36662784 26414464
14:42:54 2864 8192000000 10962105088 11381161984 1985463392 19.508 100 76 152 1 2046784672 37752224 23569056
14:43:06 5536 8192000000 10977171520 11397107712 1996389392 19.594 100 72 143 1 2056525216 37870352 22265472
14:43:18 2894 8192000000 10994338048 11412934656 2008936864 19.693 100 87 173 2 2075851824 40553120 26361840
14:43:29 2594 8192000000 10963068496 11384782848 1986296944 19.515 99 76 151 1 2050189440 39970208 23922288
14:43:39 4205 8192000000 10989752464 11402874880 2006616880 19.675 100 87 173 2 2074759680 41839776 26303024
14:43:50 1575 8192000000 10998487696 11412381696 2012008000 19.717 100 83 166 2 2077038976 39809072 25221904
14:43:58 1100 8192000000 11005252880 11412897792 2011010080 19.709 100 91 182 3 2080979328 40953200 29016048
14:44:05 1672 8192000000 10986111072 11400400896 1996927168 19.598 100 75 148 1 2060393040 41156480 22309392
14:44:15 7954 8192000000 10962528896 11401437184 1995592080 19.588 100 47 94 1 2050759696 39858944 15308672
14:44:31 3670 8192000000 10944604576 11371864064 1956690320 19.280 99 61 122 1 2023172032 47466000 19015712
14:44:42 5676 8192000000 10942712192 11362172928 1932667136 19.088 98 53 104 2 1993465232 43950176 16847920
14:44:56 6393 8192000000 10937484192 11367178240 1950270128 19.229 99 48 96 1 2009736528 43257264 16209136
14:45:11 3397 8192000000 10955694624 11382919168 1979380256 19.460 100 53 107 0 2041133984 43100576 18653152
14:45:24 3088 8192000000 10982225248 11393204224 1990228224 19.546 100 89 176 4 2062237840 44002288 28007328
14:45:34 4940 8192000000 10979457472 11403010048 1991383888 19.555 100 64 128 0 2058662880 46177936 21101056
14:45:47 5609 8192000000 10988985872 11411501056 1997188448 19.601 100 71 142 0 2068528208 48957552 22382208
14:46:02 5011 8192000000 10981433616 11406200832 1978256080 19.451 99 69 138 2 2053325744 51795120 23274544
14:46:18 6789 8192000000 10991296992 11414003712 1994738560 19.581 100 70 138 0 2068427808 51380752 22308496
14:46:31 4202 8192000000 10983431568 11403538432 1984926352 19.504 100 77 155 2 2062793536 52177520 25689664
14:46:48 3761 8192000000 10979257776 11401179136 1983137328 19.490 100 74 149 1 2060504016 52983696 24382992
14:47:05 9905 8192000000 10945676896 11376410624 1951718256 19.240 99 54 106 2 2016608816 47513584 17376976
14:47:29 5682 8192000000 10952977936 11376078848 1962463344 19.326 100 61 122 3 2033156672 50327392 20365936
14:47:42 2328 8192000000 10953655104 11376123904 1950761888 19.233 99 65 129 2 2024871712 52654544 21455280
14:47:51 7562 8192000000 10956681552 11384131584 1965712736 19.351 100 52 104 2 2037936384 54736224 17487424
14:48:15 14081 8192000000 10947667568 11392757760 1973571136 19.414 100 37 74 0 2038620736 51779760 13269840
14:48:37 19648 8192000000 10935981952 11381088256 1953614640 19.255 99 32 64 0 2015351104 50248720 11487744
14:49:07 19582 8192000000 10930530896 11389071360 1969248384 19.379 100 31 62 1 2029359408 48861872 11249152
14:49:37 23640 8192000000 10941222192 11385491456 1950813184 19.233 99 35 70 1 2015077376 52161872 12102320
14:50:07 12413 8192000000 10949815152 11394211840 1967362288 19.365 100 40 79 3 2032998224 52161968 13473968
14:50:26 28945 8192000000 10928658288 11381420032 1948445552 19.214 99 29 58 1 2008948736 50195680 10307504
14:51:01 25497 8192000000 10938990384 11391397888 1959844384 19.305 100 30 60 0 2019069168 49325152 9899632
14:51:41 21442 8192000000 10917839312 11399618560 1966909968 19.361 100 23 46 0 2018764656 44246080 7608608
14:52:10 52568 8192000000 10909853392 11390935040 1969386544 19.381 100 13 25 0 2008008032 34748032 3873456
14:53:09 56423 8192000000 10903422512 11385864192 1909042848 18.899 97 10 20 0 1941593344 30033616 2516880
14:54:26 30765 8192000000 10933817088 11375521792 1975732416 19.431 100 49 94 1 2007554256 18789280 13032560
14:55:04 32834 8192000000 10923317808 11394920448 1978913328 19.456 100 27 54 2 2014119072 27414944 7790800
14:55:45 57712 8192000000 10909092768 11388006400 1953251168 19.252 99 12 24 2 1983842176 27887456 2703552
14:57:00 122936 8192000000 10895244096 11360948224 1881329728 18.676 95 12 24 2 1900149168 16170416 2649024
14:59:09 96002 8192000000 10913014032 11368480768 1924914384 19.026 98 11 22 0 1950881376 23328224 2638768
15:01:02 94261 8192000000 10919515408 11366199296 1971622080 19.398 100 37 73 0 1998610784 15664832 11323872
15:02:43 80065 8192000000 10922659760 11382390784 1965019216 19.346 99 38 76 2 1985100208 9919520 10161472
15:04:13 40141 8192000000 10892386224 11349725184 1926336144 19.038 97 44 89 2 1951350272 12967008 12047120
15:05:56 78983 8192000000 10917894544 11381055488 1939690432 19.144 98 35 70 2 1970130512 20504720 9935360
15:07:32 88246 8192000000 10882190736 11350237184 1900836592 18.833 97 14 29 1 1922031520 17193152 4001776
15:09:07 43922 8192000000 10874702624 11359920128 1955484096 19.270 100 6 12 1 1970001696 13027824 1489776
15:09:57 57067 8192000000 10899815776 11368161280 1970033472 19.386 100 17 34 1 1981726048 6953728 4738848
15:11:00 42615 8192000000 10905766960 11376631808 1981163984 19.474 100 15 30 1 1993937120 8539536 4233600
15:12:18 24999 8192000000 10890243664 11366379520 1970916544 19.393 99 21 43 1 1984967760 7970096 6081120
15:12:50 61747 8192000000 10920752384 11371884544 1963010128 19.330 99 11 22 0 1975365680 9049312 3306240
15:14:16 75187 8192000000 10892075504 11373342720 1945217488 19.188 98 17 34 0 1964244720 14274752 4752480
15:15:39 33400 8192000000 10913979392 11396284416 1988236944 19.530 100 14 28 2 2009603968 17434240 3932784
15:16:21 5171 8192000000 10883889744 11332841472 1916758512 18.961 97 40 78 0 1940405872 12586832 11060528
15:16:34 33562 8192000000 10908361664 11379527680 1976042496 19.433 100 18 36 0 1994325104 13113088 5169520
15:17:16 36033 8192000000 10892438544 11363012608 1942351648 19.166 98 29 54 1 1968102832 18171696 7579488
15:18:05 50714 8192000000 10920252992 11391520768 1976520928 19.437 100 18 36 3 1999232064 17211904 5499232
15:19:02 62143 8192000000 10900348208 11393994752 1956196720 19.276 99 13 26 0 1979456720 19312224 3947776
15:20:24 73770 8192000000 10908169392 11401166848 1919239392 18.981 97 13 26 0 1951040128 27186464 4614272
15:21:44 61102 8192000000 10913619824 11389607936 1979102000 19.458 100 23 46 1 2007675952 22152816 6421136
15:22:52 63144 8192000000 10906606384 11376648192 1946235808 19.196 98 17 34 1 1963863488 12397424 5230256
15:24:01 26236 8192000000 10928435520 11386068992 1969064832 19.378 99 38 74 2 1992977024 12746864 11165328
15:24:34 51554 8192000000 10893812352 11364294656 1941762928 19.161 98 28 56 1 1961717664 10845792 9108944
15:25:43 55491 8192000000 10917212416 11368259584 1916218976 18.957 97 16 32 0 1933224800 12252368 4753456
15:26:47 53925 8192000000 10909711168 11390050304 1954257872 19.260 99 15 30 0 1976329264 17777232 4294160
15:28:03 40674 8192000000 10924933312 11370340352 1917440592 18.966 97 29 57 0 1936773840 11538720 7794528
15:29:00 104459 8192000000 10866784992 11330269184 1828749600 18.249 93 16 32 0 1846762688 13743312 4269776
15:30:59 55075 8192000000 10898210816 11356614656 1882320432 18.684 96 27 54 0 1902133424 12313584 7499408
15:32:00 50283 8192000000 10869875968 11332251648 1899053840 18.819 97 30 60 1 1926282688 19044656 8184192
15:33:20 81142 8192000000 10877593952 11343200256 1909372976 18.902 98 34 68 3 1940471056 20962368 10135712
15:34:54 54962 8192000000 10867275296 11355111424 1953249344 19.252 100 23 46 1 1967988064 8889072 5849648
15:36:57 40367 8192000000 10870581360 11345248256 1934189824 19.100 99 11 21 0 1944923856 7742544 2991488
15:37:45 53360 8192000000 10865894736 11345772544 1919867280 18.986 98 11 22 0 1935878144 12834992 3175872
15:38:44 33932 8192000000 10869540864 11358470144 1951553568 19.239 100 12 24 1 1962757728 7950464 3253696
15:39:27 86174 8192000000 10882057680 11355557888 1921740608 19.001 98 17 34 3 1934607424 8668720 4198096
15:41:07 54703 8192000000 10862119472 11357360128 1916882304 18.962 98 6 12 0 1928565440 10020384 1662752
15:42:08 66311 8192000000 10841944704 11325562880 1808009328 18.080 93 13 26 0 1820442000 8467728 3964944
15:43:26 67132 8192000000 10869292496 11345666048 1899723744 18.824 98 14 28 0 1914446496 10962816 3759936
15:44:50 39956 8192000000 10889352800 11364286464 1920060336 18.987 98 37 74 3 1952236960 22128720 10047904
15:45:51 74011 8192000000 10864211232 11335438336 1872033840 18.601 96 11 22 0 1886208240 11281872 2892528
15:47:11 105707 8192000000 10883629296 11349323776 1892410400 18.765 97 16 32 0 1907105808 10081920 4613488
15:49:04 51624 8192000000 10907170304 11375374336 1942687696 19.168 99 29 59 2 1962990064 11484512 8817856
15:50:08 88164 8192000000 10866723504 11344678912 1865531152 18.548 95 18 36 0 1880241408 10090768 4619488
15:51:48 40104 8192000000 10901883168 11369025536 1949857552 19.225 100 24 48 3 1966428992 9823984 6747456
15:52:48 30379 8192000000 10897816112 11370291200 1967054752 19.362 100 28 55 1 1985910048 11207824 7647472
15:53:31 24930 8192000000 10912644992 11375251456 1959304912 19.301 99 31 62 1 1981012016 12566448 9140656
15:54:03 44502 8192000000 10912307056 11385470976 1965755344 19.352 100 24 48 1 1994431264 21742592 6933328
15:54:59 104795 8192000000 10907468240 11379855360 1971676736 19.399 100 19 38 1 1991903744 14578944 5648064
15:57:07 77109 8192000000 10890243840 11351986176 1908140480 18.892 96 25 50 1 1922883616 8342592 6400544
15:58:35 49731 8192000000 10900337904 11366141952 1951422832 19.238 99 13 26 0 1964575456 9543424 3609200
15:59:50 40391 8192000000 10866098032 11353681920 1943532080 19.175 99 22 37 1 1955496400 6756752 5207568
16:01:19 74439 8192000000 10867418432 11352461312 1886669440 18.719 96 13 26 0 1895981248 6111680 3200128
16:02:40 128308 8192000000 10878509344 11359346688 1865427312 18.547 95 9 18 1 1877205376 9600704 2177360
16:04:57 25533 8192000000 10898933792 11369414656 1968969088 19.377 100 32 65 2 1984720768 6063792 9687888
16:05:36 33082 8192000000 10896308896 11371732992 1956523712 19.278 99 32 64 0 1974296560 8784608 8988240
16:06:15 88367 8192000000 10891107520 11372130304 1913422720 18.934 97 18 36 1 1927276880 8325808 5528352
16:07:50 64290 8192000000 10912992384 11386101760 1962150736 19.323 99 15 30 2 1976355856 9965760 4239360
16:09:02 32808 8192000000 10860921424 11332452352 1919073744 18.979 97 15 28 1 1933469696 10453184 3942768
16:09:44 18545 8192000000 10920590272 11381624832 1975779632 19.431 100 50 100 0 1997331216 7354944 14196640
16:10:10 53676 8192000000 10900029728 11376779264 1917608496 18.968 97 27 54 0 1940902336 15658544 7635296
16:11:46 83464 8192000000 10884510976 11369390080 1900656624 18.832 96 18 36 1 1917099664 10767840 5675200
16:13:16 121405 8192000000 10892084016 11363377152 1854584144 18.459 94 18 36 0 1875155984 16248928 4322912
16:15:25 75298 8192000000 10854852720 11321950208 1822146912 18.195 93 13 25 1 1840771696 15065216 3559568
16:16:47 146184 8192000000 10883134448 11323379712 1813196176 18.122 93 21 42 1 1830305232 11574560 5534496
16:20:14 52988 8192000000 10821507104 11305054208 1864472400 18.540 97 7 14 0 1876158144 9818576 1867168
16:21:13 30193 8192000000 10833692544 11318837248 1892932304 18.769 99 10 19 0 1909480016 14104000 2443712
16:21:54 47577 8192000000 10831981632 11309404160 1884375488 18.700 98 8 16 1 1898629920 12227520 2026912
16:22:49 38318 8192000000 10845432656 11322322944 1911208928 18.916 99 16 32 0 1925598896 9357056 5032912
16:23:52 79308 8192000000 10850005248 11338227712 1895958848 18.794 98 14 28 0 1909762224 9892352 3911024
16:25:18 78484 8192000000 10859818624 11339468800 1883593808 18.694 97 19 38 0 1900072688 10876848 5602032
16:26:45 34821 8192000000 10854690880 11319668736 1862791248 18.526 96 30 59 4 1885272944 14295552 8186144

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-03-2021 16:28:53 to 05-03-2021 16:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 206 v_add_invoice_to_stock 335544517
except 23 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-03-2021 16:29:25 to 05-03-2021 16:29:27.

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          241820
MON$OLDEST_ACTIVE               241821
MON$OLDEST_SNAPSHOT             241821
MON$NEXT_TRANSACTION            241821
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                       2021696
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:49: 
:50: mscs-test-161.budzdorov.ru    Fri Mar  5 16:27:33 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Fri Mar  5 16:27:40 2021
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
--- end of diff output ---

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

05.03.21 16:29:28. 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-05 16:29:31 No severe PSQL-related problems occured
05.03.21 16:29:32. End of report.