Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.12.2020 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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17461424 kB
MemAvailable 31572004 kB
Buffers 0 kB
Cached 14220960 kB
SwapCached 1976 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 2020-12-06 16:27:04
DTS_END                         2020-12-06 16:27:04.4350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34260
TRN_ID                          249780
ATT_ID                          653
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: 9273.03 24227 1112763
customer order: creation 171.93 351 20632
customer order: refuse 14.61 279 1753
order to supplier: creation 46.23 1122 5548
order to supplier: removal 3.58 76458 429
invoice (draft): creation 46.27 3248 5552
invoice (draft): removal 53.53 630 6424
invoice accept: apply 41.21 15023 4945
invoice accept: cancel 48.53 729 5824
customer reserve: creation 3746.25 150 449550
customer reserve: removal 4802.52 44 576302
realization accept: apply 84.89 159 10187
realization accept: cancel 82.65 92 9918
payment from customer: creation 58.94 99 7073
payment from customer: removal 6.28 67 753
payment to supplier: creation 49.62 119 5954
payment to supplier: removal 3.51 95 421
service: total inventory turnovers 4.84 987 581
service: total monetary turnovers 6.73 18 807
service: aggregate perf. data 0.88 18541 106
service: refresh index statistics 0.03 366330 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-12-2020 16:28:27 to 06-12-2020 16:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5588
TEST_TIME 2 3659
TEST_TIME 3 4987
TEST_TIME 4 5226
TEST_TIME 5 5411
TEST_TIME 6 5403
TEST_TIME 7 5997
TEST_TIME 8 6662
TEST_TIME 9 6735
TEST_TIME 10 7494
TEST_TIME 11 7397
TEST_TIME 12 8028
TEST_TIME 13 8237
TEST_TIME 14 9056
TEST_TIME 15 9235
TEST_TIME 16 9676
TEST_TIME 17 9977
TEST_TIME 18 10288
TEST_TIME 19 10331
TEST_TIME 20 10297
TEST_TIME 21 10179
TEST_TIME 22 11053
TEST_TIME 23 11464
TEST_TIME 24 11355
TEST_TIME 25 11509
TEST_TIME 26 11591
TEST_TIME 27 11269
TEST_TIME 28 11130
TEST_TIME 29 11042
TEST_TIME 30 10821
TEST_TIME 31 10761
TEST_TIME 32 10639
TEST_TIME 33 10513
TEST_TIME 34 10457
TEST_TIME 35 10293
TEST_TIME 36 10271
TEST_TIME 37 10227
TEST_TIME 38 10189
TEST_TIME 39 10158
TEST_TIME 40 10089
TEST_TIME 41 10016
TEST_TIME 42 9818
TEST_TIME 43 9787
TEST_TIME 44 9760
TEST_TIME 45 9806
TEST_TIME 46 9663
TEST_TIME 47 9566
TEST_TIME 48 9494
TEST_TIME 49 9437
TEST_TIME 50 9470
TEST_TIME 51 9418
TEST_TIME 52 9553
TEST_TIME 53 9549
TEST_TIME 54 9568
TEST_TIME 55 9647
TEST_TIME 56 9580
TEST_TIME 57 9614
TEST_TIME 58 9579
TEST_TIME 59 9644
TEST_TIME 60 9656
TEST_TIME 61 9744
TEST_TIME 62 9716
TEST_TIME 63 9789
TEST_TIME 64 9680
TEST_TIME 65 9652
TEST_TIME 66 9572
TEST_TIME 67 9530
TEST_TIME 68 9478
TEST_TIME 69 9466
TEST_TIME 70 9433
TEST_TIME 71 9523
TEST_TIME 72 9558
TEST_TIME 73 9520
TEST_TIME 74 9529
TEST_TIME 75 9495
TEST_TIME 76 9561
TEST_TIME 77 9518
TEST_TIME 78 9515
TEST_TIME 79 9568
TEST_TIME 80 9541
TEST_TIME 81 9636
TEST_TIME 82 9681
TEST_TIME 83 9596
TEST_TIME 84 9544
TEST_TIME 85 9541
TEST_TIME 86 9488
TEST_TIME 87 9476
TEST_TIME 88 9475
TEST_TIME 89 9398
TEST_TIME 90 9389
TEST_TIME 91 9406
TEST_TIME 92 9406
TEST_TIME 93 9426
TEST_TIME 94 9462
TEST_TIME 95 9479
TEST_TIME 96 9457
TEST_TIME 97 9530
TEST_TIME 98 9518
TEST_TIME 99 9477
TEST_TIME 100 9656
TEST_TIME 101 9623
TEST_TIME 102 9625
TEST_TIME 103 9640
TEST_TIME 104 9639
TEST_TIME 105 9627
TEST_TIME 106 9644
TEST_TIME 107 9571
TEST_TIME 108 9559
TEST_TIME 109 9508
TEST_TIME 110 9499
TEST_TIME 111 9451
TEST_TIME 112 9450
TEST_TIME 113 9415
TEST_TIME 114 9352
TEST_TIME 115 9358
TEST_TIME 116 9347
TEST_TIME 117 9346
TEST_TIME 118 9338
TEST_TIME 119 9345
TEST_TIME 120 9273

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-12-2020 16:28:30 to 06-12-2020 16:28:34.

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 1531954 1531954 0 0.00 0 27306 5 0 0
doc_list_biud 1531954 1531954 0 0.00 0 39662 22 0 0
sp_add_invoice_to_stock 5067 4945 122 2.40 44 188409 15023 0 122
sp_cancel_adding_invoice 5824 5824 0 0.00 5 54323 730 0 0
sp_cancel_client_order 1753 1753 0 0.00 4 8830 280 0 0
sp_cancel_customer_reserve 576302 576302 0 0.00 1 39665 44 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 3 3758 68 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 2 5891 95 0 0
sp_cancel_supplier_invoice 6440 6424 16 0.24 1 38531 630 0 16
sp_cancel_supplier_order 429 429 0 0.00 7 774229 76458 0 0
sp_cancel_write_off 9918 9918 0 0.00 1 9830 92 0 0
sp_client_order 20632 20632 0 0.00 3 24448 351 0 0
sp_customer_reserve 449550 449550 0 0.00 0 35985 150 0 0
sp_fill_shopping_cart 31732 31732 0 0.00 1 17800 41 0 0
sp_fill_shopping_cart_clo_res 449550 449550 0 0.00 0 15811 13 0 0
sp_get_clo_for_invoice 4944 4944 0 0.00 0 29914 356 0 0
sp_kill_cost_storno 16916 16916 0 0.00 0 11640 44 0 0
sp_kill_qstorno_ret_qs2qd 1169375 1169375 0 0.00 0 38522 24 0 0
sp_kill_qty_storno 615781 615781 0 0.00 0 39661 53 0 0
sp_lock_selected_doc 20971 20971 0 0.00 0 8776 7 0 0
sp_make_cost_storno 28158 28158 0 0.00 0 27302 58 0 0
sp_multiply_rows_for_pdistr 28158 28158 0 0.00 0 11529 26 0 0
sp_multiply_rows_for_qdistr 20632 20632 0 0.00 0 15911 176 0 0
sp_pay_from_customer 7073 7073 0 0.00 4 13131 99 0 0
sp_pay_to_supplier 5954 5954 0 0.00 4 16872 120 0 0
sp_payment_common 13027 13027 0 0.00 1 9392 32 0 0
sp_qd_handle_on_cancel_clo 1753 1753 0 0.00 0 8824 253 0 0
sp_qd_handle_on_invoice_upd_sts 10768 10768 0 0.00 0 28654 299 0 0
sp_qd_handle_on_reserve_upd_sts 10187 10187 0 0.00 0 12055 51 0 0
sp_reserve_write_off 10187 10187 0 0.00 6 16716 160 0 0
sp_supplier_invoice 5552 5552 0 0.00 6 80625 3249 0 0
sp_supplier_order 5548 5548 0 0.00 5 34309 1122 0 0
srv_aggregate_perf_data 106 106 0 0.00 3252 301493 18542 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1379 142424 36872 0 0
srv_find_qd_qs_mism 1066767 1066767 0 0.00 0 12857 4 0 0
srv_make_invnt_saldo 581 581 0 0.00 35 31366 987 0 0
srv_make_money_saldo 807 807 0 0.00 0 480 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 314350 422463 366330 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4945 4945 0 0.00 0 14349 160 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 7056 120 0 0
t$perf-norm:sp_cancel_client_order 1753 1753 0 0.00 0 5225 17 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 2315 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 1603 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 280 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 514 10 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 29420 1314 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 2739 16 0 0
t$perf-norm:sp_client_order 20632 20632 0 0.00 0 14321 16 0 0
t$perf-norm:sp_customer_reserve 1075 1075 0 0.00 0 3711 8 0 0
t$perf-norm:sp_pay_from_customer 7073 7073 0 0.00 0 7859 12 0 0
t$perf-norm:sp_pay_to_supplier 5954 5954 0 0.00 0 11651 16 0 0
t$perf-norm:sp_reserve_write_off 10187 10187 0 0.00 0 12907 12 0 0
t$perf-norm:sp_supplier_invoice 5552 5552 0 0.00 0 4504 17 0 0
t$perf-norm:sp_supplier_order 5548 5548 0 0.00 0 8732 14 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 387 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 5097 39 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 1088 14 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 2638 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 14 6 0 0
v_add_invoice_to_stock 10132 9888 244 2.40 0 7352 17 0 244
v_all_customers 36914 36914 0 0.00 0 96 1 0 0
v_all_suppliers 30612 30612 0 0.00 0 21 1 0 0
v_all_wares 41264 41264 0 0.00 0 189 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 1947 8 0 0
v_cancel_client_order 3506 3506 0 0.00 0 2775 6 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 1690 5 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 245 3 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 974 4 0 0
v_cancel_supplier_invoice 802 770 32 3.99 0 4817 18 0 32
v_cancel_supplier_order 858 858 0 0.00 0 1509 6 0 0
v_cancel_write_off 2046 2046 0 0.00 0 1415 11 0 0
v_max_id_clo_ord 5548 5548 0 0.00 0 1184 2 0 0
v_max_id_clo_res 1075 1075 0 0.00 0 2388 14 0 0
v_max_id_ord_sup 5552 5552 0 0.00 0 6659 5 0 0
v_max_non_paid_invoice 1748 1748 0 0.00 0 1007 2 0 0
v_max_non_paid_realizn 4058 4058 0 0.00 0 9387 8 0 0
v_min_id_clo_ord 5548 5548 0 0.00 0 8197 16 0 0
v_min_id_clo_res 1075 1075 0 0.00 0 7756 18 0 0
v_min_id_ord_sup 5552 5552 0 0.00 0 6730 9 0 0
v_min_non_paid_invoice 5954 5954 0 0.00 0 8707 22 0 0
v_min_non_paid_realizn 7073 7073 0 0.00 0 7658 19 0 0
v_our_firm 10380 10380 0 0.00 0 21 1 0 0
v_reserve_write_off 20374 20374 0 0.00 0 3187 4 0 0
x_lock_depdocs_on_canc_invoice 11863 11863 0 0.00 0 13343 104 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 7293 292 0 0
x_make_qstorno_1000_1200 5548 5548 0 0.00 1 34297 1035 0 0
x_make_qstorno_1200_2000 5552 5552 0 0.00 3 80482 3109 0 0
x_make_qstorno_2100_3300 449550 449550 0 0.00 0 35982 135 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-12-2020 16:28:35 to 06-12-2020 16:28:39.

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:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:14 13375 8192000000 10236423520 10544652288 925374512 10.149 75 47 96 0 943959568 2553104 16031952
13:57:36 30482 8192000000 10347824512 10668322816 1392439440 14.528 100 82 164 0 1423597472 4309520 26848512
13:58:16 32116 8192000000 10399267920 10722074624 1448449728 15.024 100 93 186 2 1484461968 6249104 29763136
13:59:02 23367 8192000000 10416754848 10746036224 1470530528 15.218 100 90 180 0 1506606592 7293984 28782080
13:59:36 20378 8192000000 10441624416 10777423872 1488379536 15.375 100 79 158 0 1521241984 7593040 25269408
14:00:04 20978 8192000000 10469918304 10802565120 1517735104 15.631 100 91 182 0 1555029072 8727024 28566944
14:00:37 18135 8192000000 10464515680 10807554048 1529429056 15.732 100 82 164 1 1563868880 9384784 25055040
14:01:04 13115 8192000000 10501894656 10848014336 1557806640 15.977 100 82 164 0 1591788688 9736208 24245840
14:01:27 10928 8192000000 10520722544 10873495552 1581807200 16.184 100 76 151 0 1614646096 10711792 22127104
14:01:48 14594 8192000000 10558081040 10912780288 1617294624 16.487 100 79 158 0 1652096912 11265072 23537216
14:02:12 6778 8192000000 10564183664 10925686784 1628988752 16.586 100 83 166 3 1665139536 11589712 24561072
14:02:25 13484 8192000000 10602781488 10965356544 1647979872 16.747 100 85 167 0 1685105504 12037840 25087792
14:02:48 11403 8192000000 10611806224 10978025472 1671445440 16.945 100 79 158 1 1706620192 12563344 22611408
14:03:08 8054 8192000000 10627627792 10996822016 1689882016 17.100 100 79 159 1 1724147872 11858528 22407328
14:03:27 8031 8192000000 10654922896 11025195008 1713645952 17.299 100 85 169 1 1750506224 12666064 24194208
14:03:43 6594 8192000000 10677057520 11047747584 1734590416 17.474 100 86 172 0 1775802496 17284944 23927136
14:03:57 4963 8192000000 10684973536 11060625408 1744375792 17.555 100 76 152 0 1778169344 12206768 21586784
14:04:10 5112 8192000000 10695368624 11073523712 1758876912 17.675 100 76 152 0 1793183520 12902048 21404560
14:04:22 4550 8192000000 10707461920 11087491072 1767232160 17.744 100 77 154 1 1800894448 11666640 21995648
14:04:34 4844 8192000000 10712164624 11096195072 1778294256 17.835 100 82 165 0 1814618112 13051840 23272016
14:04:47 2889 8192000000 10728262400 11106332672 1788315856 17.918 100 89 178 0 1826968304 14065696 24586752
14:04:56 3727 8192000000 10730030784 11108732928 1791891648 17.947 100 89 176 1 1831740512 15633616 24215248
14:05:06 2829 8192000000 10739515312 11120537600 1796828352 17.988 100 90 177 0 1835485808 14368992 24288464
14:05:16 4796 8192000000 10733172608 11122429952 1805084624 18.056 100 81 159 1 1840636464 13168448 22383392
14:05:28 1557 8192000000 10751402720 11137560576 1818092752 18.162 100 84 168 0 1854513360 12589072 23831536
14:05:36 4937 8192000000 10758096592 11144089600 1815757472 18.143 100 75 149 2 1849313120 13071328 20484320
14:05:48 2821 8192000000 10775036960 11157372928 1828622896 18.248 100 95 190 2 1869185488 14236848 26325744
14:05:58 1762 8192000000 10784774912 11171344384 1842882752 18.364 100 92 182 1 1881426240 12028656 26514832
14:06:06 1345 8192000000 10794554272 11181015040 1851090432 18.431 100 89 179 0 1889961008 13582288 25288288
14:06:14 1825 8192000000 10797889696 11187970048 1856236416 18.473 100 92 185 2 1895223664 12610928 26376320
14:06:22 2074 8192000000 10801198992 11188547584 1854999456 18.463 100 90 176 0 1893929760 13825168 25105136
14:06:30 1749 8192000000 10798090064 11188559872 1856412432 18.474 100 87 174 3 1895429552 14460224 24556896
14:06:38 1432 8192000000 10811515152 11197243392 1862530624 18.524 100 93 186 0 1903740944 14843584 26366736
14:06:46 1667 8192000000 10809935680 11199680512 1863967696 18.535 100 90 181 1 1903929584 13721424 26240464
14:06:54 3964 8192000000 10809138512 11203051520 1868786672 18.574 100 85 168 1 1904932608 12026912 24119024
14:07:04 2982 8192000000 10803661792 11206246400 1872560944 18.605 100 80 161 4 1906816656 11559600 22696112
14:07:15 1438 8192000000 10804321712 11212034048 1872154976 18.602 100 55 110 2 1899887744 12245248 15487520
14:07:23 2139 8192000000 10804917312 11211722752 1874177344 18.618 100 64 129 1 1903749936 11642416 17930176
14:07:33 39480 8192000000 10804932480 11215990784 1872075520 18.601 100 38 76 1 1889524672 6531952 10917200
14:08:26 1201 8192000000 10833739280 11231760384 1889068112 18.738 100 80 160 0 1922127184 9589904 23469168
14:08:33 13435 8192000000 10787657392 11219644416 1878534144 18.653 100 25 50 0 1893331424 7701824 7095456
14:08:54 12371 8192000000 10808655344 11226378240 1885895104 18.713 100 32 62 3 1899864304 4723184 9246016
14:09:17 4065 8192000000 10809121936 11233398784 1889739760 18.744 100 42 85 0 1909996720 8349488 11907472
14:09:29 3450 8192000000 10804000272 11231068160 1890236880 18.748 100 36 70 2 1912341040 11947744 10156416
14:09:39 4792 8192000000 10812468176 11235835904 1891912336 18.761 100 35 70 1 1910021888 7706304 10403248
14:09:51 8009 8192000000 10800903712 11229806592 1889874000 18.745 100 23 46 1 1901999280 5990304 6134976
14:10:07 6077 8192000000 10800131120 11234938880 1890737856 18.752 100 27 53 1 1909638880 10704240 8196784
14:10:22 8485 8192000000 10795344304 11232301056 1890122624 18.747 100 15 30 0 1904323744 10326944 3874176
14:10:38 11364 8192000000 10806471584 11236728832 1892137168 18.763 100 14 28 3 1901603648 5587680 3878800
14:10:59 11490 8192000000 10807533104 11242926080 1899970080 18.826 100 24 48 3 1913443296 6831584 6641632
14:11:21 10384 8192000000 10814430640 11246120960 1903902912 18.858 100 21 42 0 1915296352 5171232 6222208
14:11:37 8507 8192000000 10810748304 11246936064 1901079088 18.835 100 16 29 3 1911173872 6029248 4065536
14:11:52 4847 8192000000 10817990848 11249422336 1902775024 18.849 100 24 47 2 1915785088 6138208 6871856
14:12:05 9201 8192000000 10819297520 11252445184 1907685456 18.888 100 22 44 3 1919945840 5852288 6408096
14:12:25 71890 8192000000 10816544176 11261026304 1914768720 18.945 100 33 67 2 1929508656 5231536 9508400
14:13:43 11492 8192000000 10840320400 11272933376 1916450656 18.958 100 22 43 1 1937340240 14039296 6850288
14:14:03 7249 8192000000 10829957424 11268603904 1917644144 18.968 100 25 50 0 1930499856 5662688 7193024
14:14:16 10562 8192000000 10840862000 11274932224 1917818640 18.969 100 17 34 0 1928154080 5657792 4677648
14:14:35 7351 8192000000 10829338176 11269472256 1920361232 18.990 100 25 50 1 1933074880 5712208 7001440
14:14:49 6405 8192000000 10828636560 11265302528 1915400784 18.950 100 29 59 3 1930234752 6867808 7966160
14:15:01 7544 8192000000 10818188784 11246194688 1879966016 18.665 98 25 50 0 1896964640 10199168 6799456
14:15:16 9929 8192000000 10807959232 11246190592 1874191280 18.618 98 20 40 0 1885980528 5899072 5890176
14:15:33 7820 8192000000 10797210880 11238154240 1879737888 18.663 99 23 46 3 1892406848 5978992 6689968
14:15:47 8610 8192000000 10804414224 11239890944 1894440944 18.782 100 26 53 3 1907331280 5691280 7199056
14:16:04 13156 8192000000 10782557184 11210850304 1798085456 17.998 95 17 34 2 1811396816 9178592 4132768
14:16:26 10544 8192000000 10758729056 11182616576 1783064000 17.875 96 14 27 0 1792446448 5272000 4110448
14:16:46 10130 8192000000 10761616640 11188281344 1820434064 18.181 98 23 45 0 1833263040 5799056 7029920
14:17:06 12263 8192000000 10712758128 11131400192 1691615712 17.115 92 30 59 2 1704871392 4292416 8963264
14:17:26 60620 8192000000 10682550640 11087310848 1664560752 16.887 92 25 48 1 1677233760 5101168 7571840
14:18:35 17706 8192000000 10714985472 11135270912 1738761280 17.508 96 16 32 2 1748523536 5424832 4337424
14:19:01 4273 8192000000 10691711360 11102269440 1720061824 17.353 96 31 62 2 1735816784 7204304 8550656
14:19:13 2988 8192000000 10706623232 11117748224 1788648672 17.921 100 32 64 0 1805676464 6845888 10181904
14:19:23 7822 8192000000 10695528480 11105452032 1760935360 17.692 99 37 72 0 1778240352 7387712 9917280
14:19:38 6302 8192000000 10710150128 11112185856 1782928592 17.874 100 27 52 0 1796362400 5793984 7639824
14:19:51 5564 8192000000 10692691776 11098132480 1733961456 17.468 97 28 54 2 1748204880 6504160 7739264
14:20:05 5259 8192000000 10695713664 11114070016 1754581264 17.640 98 21 42 1 1766793072 5784256 6427552
14:20:17 6358 8192000000 10701917152 11120848896 1780172592 17.851 99 20 40 1 1792091952 6389040 5530320
14:20:29 6381 8192000000 10726105056 11139317760 1794158240 17.966 99 22 42 5 1806435984 5379024 6898720
14:20:45 12805 8192000000 10727170112 11141894144 1792681728 17.954 99 12 24 0 1801587424 4959264 3946432
14:21:07 7196 8192000000 10727107968 11144732672 1811586784 18.109 100 10 20 0 1819844752 5126432 3131536
14:21:21 13118 8192000000 10754478640 11170918400 1831230992 18.269 100 25 50 2 1844336640 5372992 7732656
14:21:40 11091 8192000000 10724473872 11154423808 1777154080 17.826 97 19 38 1 1788209120 5617936 5437104
14:21:58 10352 8192000000 10734168672 11167657984 1829819680 18.258 100 18 34 1 1840854112 5403920 5630512
14:22:17 45981 8192000000 10764495024 11186753536 1842369920 18.360 100 34 68 3 1858395632 5368592 10657120
14:23:15 34330 8192000000 10757581408 11188805632 1848065824 18.406 100 31 58 0 1862154912 5510336 8578752
14:23:58 8369 8192000000 10768868944 11196944384 1856229232 18.473 100 33 65 2 1872287536 6451488 9606816
14:24:12 4332 8192000000 10775293344 11200602112 1858959136 18.495 100 25 50 2 1872181904 5464480 7758288
14:24:25 7053 8192000000 10779029168 11201036288 1859384768 18.498 100 28 56 2 1874075600 6677536 8013296
14:24:39 8442 8192000000 10776839344 11206926336 1864886288 18.543 100 24 48 0 1877782112 5593536 7302288
14:24:54 7511 8192000000 10785107344 11213479936 1868930800 18.576 100 29 57 1 1886980480 10494480 7555200
14:25:11 5995 8192000000 10785664896 11213090816 1869464208 18.580 100 31 60 1 1883840864 5958976 8417680
14:25:26 12021 8192000000 10780688720 11216060416 1869669792 18.582 100 12 24 0 1879145984 5537120 3939072
14:25:45 10008 8192000000 10800001216 11219243008 1874657056 18.622 100 27 51 3 1886978080 4906768 7414256
14:26:06 11043 8192000000 10794280576 11223810048 1881605392 18.678 100 24 48 0 1894676112 5329408 7741312
14:26:25 14248 8192000000 10809946992 11231256576 1879938576 18.665 100 23 46 1 1892145232 5118752 7087904
14:26:48 11409 8192000000 10793294112 11230781440 1882327712 18.684 100 14 28 2 1892345520 6240160 3777648
14:27:06 28414 8192000000 10839480688 11259772928 1904283056 18.861 100 30 59 1 1916970080 4337232 8349792
14:27:46 53264 8192000000 10841781088 11273334784 1920721840 18.993 100 36 72 2 1937729728 6751184 10256704
14:28:50 83454 8192000000 10869404128 11304837120 1942328512 19.165 100 31 62 0 1960713344 8970672 9414160
14:30:22 47667 8192000000 10880968256 11320369152 1927038368 19.043 99 32 65 0 1951582288 15420976 9122944
14:31:20 19763 8192000000 10899603584 11330555904 1962413776 19.325 100 44 86 1 1987415872 12819632 12182464
14:31:48 12654 8192000000 10903219504 11328569344 1963774304 19.336 100 58 116 2 1995205984 15655920 15775760
14:32:07 7104 8192000000 10915553008 11343142912 1972810016 19.408 100 65 130 2 2007090032 15188960 19091056
14:32:22 12337 8192000000 10902488912 11336441856 1953700448 19.256 99 52 104 2 1983586032 15221808 14663776
14:32:51 14123 8192000000 10923425152 11353669632 1973966848 19.417 100 44 87 1 2005015344 18122448 12926048
14:33:12 13484 8192000000 10928830992 11355508736 1977605424 19.446 100 54 107 2 2012618896 19481936 15531536
14:33:33 4736 8192000000 10934994928 11357089792 1984771792 19.502 100 63 124 3 2023250096 20719808 17758496
14:33:53 4346 8192000000 10931267760 11360894976 1986387728 19.515 100 60 117 3 2024288512 20517360 17383424
14:34:05 3657 8192000000 10941564864 11369209856 1989935520 19.543 100 47 94 0 2025501472 22137072 13428880
14:34:17 3328 8192000000 10927901840 11346542592 1967237280 19.364 99 68 131 0 2010873712 23493760 20142672
14:34:28 2039 8192000000 10934651168 11348439040 1953089408 19.251 99 71 141 0 1998063536 24423312 20550816
14:34:37 7625 8192000000 10929633536 11352702976 1972480880 19.405 100 70 140 0 2018646656 26019552 20146224
14:34:53 3077 8192000000 10917333856 11333787648 1932611120 19.088 98 66 130 0 1977066304 25531200 18923984
14:35:03 3325 8192000000 10902411280 11320954880 1938870016 19.138 99 70 140 0 1990635344 30147136 21618192
14:35:14 4743 8192000000 10875247712 11294339072 1916696096 18.960 98 59 118 0 1960542160 26262240 17583824
14:35:28 7240 8192000000 10879361296 11307372544 1932840320 19.090 99 52 103 0 1974768576 26060048 15868208
14:35:43 4426 8192000000 10913628016 11339149312 1957438736 19.286 100 55 110 2 1999269120 25601792 16228592
14:35:54 3661 8192000000 10922339824 11347488768 1968272672 19.372 100 66 132 2 2014627072 25735808 20618592
14:36:05 3661 8192000000 10923523200 11347845120 1956833008 19.281 99 64 128 1 2002944640 27033136 19078496
14:36:16 2260 8192000000 10929291024 11339063296 1948586896 19.215 99 75 151 1 1998685872 28106256 21992720
14:36:34 8180 8192000000 10936375696 11361173504 1975483584 19.429 100 59 118 1 2023417200 29690976 18242640
14:36:50 4923 8192000000 10936040416 11361230848 1975736512 19.431 100 64 128 0 2025451952 30040688 19674752
14:37:03 12948 8192000000 10929860208 11358429184 1960434336 19.309 99 60 119 2 2009700688 30620512 18645840
14:37:25 1378 8192000000 10944026432 11369611264 1982228208 19.482 100 77 149 1 2035909888 30710208 22971472
14:37:34 7228 8192000000 10915563184 11342221312 1965764288 19.352 100 62 124 0 2006843776 22680608 18398880
14:37:50 9551 8192000000 10925109648 11348209664 1956668368 19.280 99 63 125 2 1997824160 22815168 18340624
14:38:07 4108 8192000000 10934452208 11353559040 1953399776 19.254 99 75 150 1 2002695264 26007120 23288368
14:38:20 3393 8192000000 10915775376 11331047424 1940065648 19.147 99 72 143 1 1988865152 27042128 21757376
14:38:30 2275 8192000000 10923705408 11338313728 1954199088 19.260 100 79 156 2 2008813152 30835968 23778096
14:38:40 3087 8192000000 10926815600 11340963840 1943072256 19.171 99 82 165 3 1998428624 30565232 24791136
14:38:52 2196 8192000000 10920982544 11337101312 1950609472 19.231 100 71 140 0 2003997904 32408512 20979920
14:39:03 5309 8192000000 10942638432 11349585920 1950802624 19.233 99 90 179 0 2012662320 34646912 27212784
14:39:16 7021 8192000000 10918535616 11323588608 1933934032 19.098 99 83 165 0 1994729936 35580128 25215776
14:39:34 2561 8192000000 10918325344 11332100096 1948139360 19.212 100 78 156 1 2009613664 37030368 24443936
14:39:44 3412 8192000000 10908384304 11331133440 1931164928 19.076 99 65 130 1 1987834528 36542368 20127232
14:39:55 1409 8192000000 10918676256 11325648896 1939500608 19.143 100 82 164 2 1997702432 32844304 25357520
14:40:03 3801 8192000000 10919063824 11325763584 1925958144 19.035 99 84 167 4 1984902976 33696480 25248352
14:40:15 1529 8192000000 10892539584 11297701888 1893715232 18.776 97 76 151 2 1949720928 32175984 23829712
14:40:27 1981 8192000000 10885662336 11294797824 1914365520 18.942 100 60 118 1 1963791968 31205232 18221216
14:40:37 2619 8192000000 10900215312 11304583168 1926905776 19.042 100 86 164 2 1984485744 31686992 25892976
14:40:50 1470 8192000000 10891123712 11296473088 1917503408 18.967 100 77 147 0 1972719040 32590400 22625232
14:40:59 2303 8192000000 10898501680 11294982144 1917956464 18.970 100 85 171 1 1979111520 34396768 26758288
14:41:08 2368 8192000000 10901175712 11304558592 1910326640 18.909 99 81 161 1 1968986544 33910256 24749648
14:41:18 1436 8192000000 10924299440 11324112896 1937506400 19.127 100 93 186 3 1999280768 33347920 28426448
14:41:26 7280 8192000000 10904770224 11324497920 1933215680 19.093 100 59 117 0 1986706224 35419712 18070832
14:41:40 7748 8192000000 10889539248 11327655936 1935288240 19.109 100 39 78 0 1983996432 36189296 12518896
14:42:02 18328 8192000000 10891300096 11330469888 1931961008 19.083 100 27 54 0 1978038256 36798224 9279024
14:42:32 16342 8192000000 10880574144 11321245696 1924169008 19.020 100 38 76 1 1973795168 36794464 12831696
14:43:01 9785 8192000000 10883522672 11307466752 1900712736 18.832 99 43 85 1 1954986960 40661360 13612864
14:43:18 12039 8192000000 10887556496 11314237440 1921038672 18.995 100 47 94 2 1972637296 36444032 15154592
14:43:40 9571 8192000000 10893075728 11326033920 1929315632 19.061 100 37 74 1 1979679808 38046608 12317568
14:43:56 6276 8192000000 10904376320 11333070848 1946809040 19.201 100 60 119 0 2000384976 34371344 19204592
14:44:17 13397 8192000000 10880254912 11313102848 1879619552 18.662 97 31 62 0 1923493440 33462320 10411568
14:44:42 5702 8192000000 10876737904 11306496000 1916230848 18.957 100 51 102 1 1965362496 32125680 17005968
14:44:57 3701 8192000000 10880648064 11312975872 1925596048 19.032 100 50 98 2 1970835024 29351904 15887072
14:45:20 6897 8192000000 10859405840 11301142528 1900561744 18.831 99 24 47 1 1935902896 27789888 7551264
14:45:33 9805 8192000000 10872081808 11315060736 1922240912 19.005 100 20 39 2 1957878528 29203088 6434528
14:45:52 19451 8192000000 10883070064 11328663552 1930634720 19.072 100 25 50 0 1965289664 26848160 7806784
14:46:35 13806 8192000000 10880316256 11324256256 1905749504 18.873 98 28 56 0 1941803216 27139328 8914384
14:46:55 24338 8192000000 10891061616 11331796992 1938171264 19.132 100 30 60 2 1975786976 27925184 9690528
14:47:32 27640 8192000000 10898450480 11339505664 1926740640 19.041 99 29 56 1 1971800304 35092208 9967456
14:48:18 19609 8192000000 10886481136 11323789312 1892480960 18.766 98 22 44 0 1939959984 39274880 8204144
14:48:47 21746 8192000000 10888436096 11324739584 1888187664 18.731 98 24 48 1 1943734800 46844496 8702640
14:49:16 29599 8192000000 10861100432 11311030272 1877610848 18.646 98 22 44 2 1918850080 33957760 7281472
14:50:14 37476 8192000000 10859190208 11318235136 1895803600 18.793 99 17 34 0 1931169296 30049392 5316304
14:51:34 65255 8192000000 10880801888 11325022208 1925174976 19.028 100 39 79 3 1963171184 25350160 12646048
14:53:01 3733 8192000000 10892586096 11317334016 1932951728 19.090 100 60 121 3 1963618928 12728432 17938768
14:53:11 17219 8192000000 10869741024 11327528960 1936243744 19.117 100 51 102 0 1967021264 14890624 15886896
14:53:38 37198 8192000000 10856258176 11328135168 1919894736 18.986 99 16 32 0 1937401072 12924192 4582144
14:54:25 40743 8192000000 10875006320 11322822656 1939893504 19.146 100 25 52 2 1958363200 11350528 7119168
14:55:15 88050 8192000000 10870838896 11342020608 1946215024 19.196 100 16 32 1 1964820560 14289632 4315904
14:56:51 76839 8192000000 10879151760 11340247040 1917773504 18.969 98 17 34 3 1938051984 15506352 4772128
14:58:15 85982 8192000000 10893570256 11355070464 1963836304 19.337 100 11 22 0 1983284608 16587936 2860368
14:59:48 63850 8192000000 10891227312 11345235968 1946958992 19.202 99 29 57 0 1968988336 12398704 9630640
15:01:26 99240 8192000000 10894833072 11359465472 1953834496 19.257 99 15 30 0 1973716784 15647632 4234656
15:03:15 41113 8192000000 10889399216 11359232000 1967453360 19.365 100 12 24 2 1983471152 12306192 3711600
15:04:08 2495 8192000000 10925941984 11366453248 1985018208 19.504 100 68 135 0 2013860816 9122784 19719824
15:04:30 65208 8192000000 10901706624 11366559744 1977540816 19.445 100 24 48 1 1994315552 9764112 7010624
15:05:44 31765 8192000000 10886535664 11355131904 1962202576 19.324 99 21 41 2 1975656240 8018032 5435632
15:06:22 64334 8192000000 10903807360 11374419968 1980396688 19.468 100 8 16 3 1989667648 7073552 2197408
15:07:36 55832 8192000000 10894767872 11364757504 1946145200 19.196 98 18 36 1 1962341440 11265680 4930560
15:08:46 73390 8192000000 10916337168 11371356160 1937373472 19.126 98 15 30 1 1952802816 11414176 4015168
15:10:14 74557 8192000000 10884164592 11356676096 1951030928 19.235 99 21 41 1 1974592848 17987888 5574032
15:11:51 28836 8192000000 10890725056 11359547392 1969043136 19.378 100 20 40 1 1985922656 11706368 5173152
15:12:39 98717 8192000000 10884060560 11357728768 1957338784 19.285 99 11 22 1 1968131072 7898416 2893872
15:14:25 57139 8192000000 10876986016 11361337344 1957078480 19.283 99 5 10 0 1965496720 7097088 1321152
15:16:46 61685 8192000000 10886004224 11372331008 1921904432 19.002 97 9 18 1 1933234496 8965424 2364640
15:18:09 29870 8192000000 10890867088 11357618176 1904592048 18.863 96 23 46 1 1923111536 12275920 6243568
15:19:01 87011 8192000000 10889675472 11360428032 1887779072 18.728 96 13 26 2 1905857664 14500496 3578096
15:20:40 106234 8192000000 10875783824 11349176320 1896522496 18.798 96 11 22 1 1910297200 10265712 3508992
15:22:41 47782 8192000000 10838516048 11291971584 1821126016 18.187 94 20 39 1 1832811024 6386624 5298384
15:23:42 37936 8192000000 10822013872 11285925888 1829016240 18.251 95 30 60 2 1847869024 10343184 8509600
15:24:30 25260 8192000000 10853853984 11303723008 1900808496 18.833 99 28 56 1 1916289552 8113136 7367920
15:25:03 23877 8192000000 10871384400 11320119296 1889038464 18.738 98 32 64 1 1907796928 10064336 8694128
15:25:38 29385 8192000000 10867228592 11322748928 1928222448 19.053 100 23 46 0 1946934336 12501088 6210800
15:26:17 50199 8192000000 10857130608 11315077120 1862722928 18.525 97 22 44 1 1885146352 16497872 5925552
15:27:31 96669 8192000000 10893510016 11351818240 1898124336 18.811 97 19 37 0 1918003328 15526512 4352480
15:29:50 142424 8192000000 10874523200 11338850304 1890177632 18.747 96 23 46 1 1909580752 13093824 6309296
15:32:28 51396 8192000000 10865487648 11342913536 1946969024 19.202 100 18 36 1 1961871344 10267440 4634880
15:33:42 36463 8192000000 10865941024 11344031744 1950593568 19.231 100 7 14 0 1964082432 11511216 1977648
15:34:30 36334 8192000000 10877488432 11350679552 1942050944 19.163 99 7 14 0 1951416240 7390976 1974320
15:35:38 93088 8192000000 10911790512 11376611328 1956648896 19.279 99 13 26 0 1972917872 12662176 3606800
15:37:42 81195 8192000000 10853630976 11326406656 1862487360 18.523 95 11 22 0 1883055392 17387328 3180704
15:39:10 63399 8192000000 10838390944 11280609280 1836865984 18.315 95 26 52 1 1856013568 11211312 7936272
15:40:20 40125 8192000000 10851533520 11311431680 1906750816 18.881 99 22 44 0 1925940032 13147968 6041248
15:41:06 46591 8192000000 10867408880 11334324224 1914382608 18.942 99 15 30 0 1933116704 14429024 4305072
15:42:06 32977 8192000000 10883254288 11331219456 1917975680 18.971 98 43 87 1 1937944384 8002912 11965792
15:42:52 38985 8192000000 10873603808 11336806400 1904805584 18.865 98 34 68 1 1929868112 15539168 9523360
15:43:37 91201 8192000000 10895058448 11348844544 1949712080 19.224 100 23 46 0 1968513424 12189760 6611584
15:45:21 60208 8192000000 10874224896 11347714048 1901472432 18.838 97 24 48 0 1919849536 11258304 7118800
15:46:39 99751 8192000000 10905083040 11388932096 1978171792 19.450 100 17 34 0 1996107264 13245824 4689648
15:48:29 67348 8192000000 10908486368 11376906240 1954055600 19.259 99 9 18 3 1970085280 13594448 2435232
15:49:48 141758 8192000000 10904078256 11371003904 1914018160 18.939 97 16 31 2 1934800336 16645808 4136368
15:52:16 31263 8192000000 10896088480 11374882816 1973054352 19.410 100 18 36 0 1987548640 9925424 4568864
15:52:54 42550 8192000000 10902223456 11379064832 1978388352 19.452 100 13 26 1 1993346000 10860528 4097120
15:53:43 76513 8192000000 10914542224 11397337088 1941932624 19.162 98 13 25 0 1963707104 18260272 3514208
15:55:05 52396 8192000000 10911411760 11401871360 1961013808 19.314 99 8 16 1 1990671264 27247744 2409712
15:56:04 41947 8192000000 10922018208 11398045696 1983557984 19.493 100 9 18 1 2009789648 23574912 2656752
15:57:00 73793 8192000000 10912758832 11397300224 1966963856 19.361 99 11 22 0 1989179408 19016096 3199456
15:58:35 37434 8192000000 10911262304 11395866624 1994190800 19.577 100 17 34 1 2009612624 10852320 4569504
15:59:23 68096 8192000000 10919001120 11395219456 1946693568 19.200 97 15 30 1 1967145680 16474224 3977888
16:01:00 86798 8192000000 10932910912 11405754368 1985257632 19.506 99 16 32 0 1998454784 9006704 4190448
16:02:35 44417 8192000000 10930371536 11399794688 1986235984 19.514 99 17 34 1 2000308272 9489360 4582928
16:03:26 71639 8192000000 10933281008 11413532672 1986431360 19.516 99 24 48 1 2008425424 15050480 6943584
16:04:46 75450 8192000000 10934504096 11396177920 1924673184 19.024 96 16 32 1 1953264416 24191312 4399920
16:06:08 58301 8192000000 10955457040 11424833536 1983473728 19.492 99 35 68 2 2014995264 21856208 9665328
16:08:16 47867 8192000000 10894318496 11357155328 1912187312 18.924 96 20 40 0 1926550064 9059168 5303584
16:09:10 34944 8192000000 10892216016 11345666048 1872921552 18.608 95 17 34 1 1886178656 8099760 5157344
16:09:51 53030 8192000000 10862472512 11329703936 1871218192 18.594 96 16 32 0 1885995456 10315168 4462096
16:10:51 47624 8192000000 10878802192 11349577728 1926244320 19.037 99 15 30 0 1940324688 9885056 4195312
16:11:47 88638 8192000000 10891577936 11345793024 1838332880 18.327 93 23 46 0 1858956560 13936352 6687328
16:13:28 101060 8192000000 10862413376 11315269632 1873798224 18.615 96 23 46 1 1892015760 11573168 6644368
16:15:34 48963 8192000000 10843724944 11315834880 1892987424 18.770 98 12 24 0 1906296080 10001760 3306896
16:16:29 28213 8192000000 10850774608 11323891712 1913677408 18.936 99 12 25 0 1927784928 10430496 3677024
16:17:08 70079 8192000000 10850620816 11327807488 1899674288 18.824 98 10 20 0 1910666528 8003472 2988768
16:18:28 44693 8192000000 10870979856 11344646144 1944027328 19.179 100 11 23 0 1956570208 9229552 3313328
16:19:19 65436 8192000000 10830764736 11307855872 1841057712 18.349 95 6 12 0 1850292736 7426720 1808304
16:20:36 85721 8192000000 10877949248 11330248704 1895938208 18.794 98 20 40 0 1907733056 6448416 5346432
16:22:09 79112 8192000000 10853786912 11330449408 1920135392 18.988 99 12 24 0 1933968672 10530496 3302784
16:23:34 50857 8192000000 10852033840 11326341120 1877556640 18.645 97 13 26 0 1891087248 9956128 3574480
16:24:31 53660 8192000000 10850486736 11318435840 1861570336 18.516 96 17 34 1 1878881360 12332064 4978960
16:25:31 56712 8192000000 10855826848 11320844288 1877241616 18.643 97 20 40 1 1899841776 16735632 5864528
16:26:34 44767 8192000000 9757399280 10111332352 889611472 9.795 46 7 14 0 907088576 15688960 1788144

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 06-12-2020 16:28:40 to 06-12-2020 16:29:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-12-2020 16:29:11 to 06-12-2020 16:29:13.

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          250034
MON$OLDEST_ACTIVE               250035
MON$OLDEST_SNAPSHOT             250035
MON$NEXT_TRANSACTION            250035
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                       2032288
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:38: 
:39: mscs-test-161.budzdorov.ru    Sun Dec  6 16:27:21 2020
:40:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:41: 
:42: 
:43: mscs-test-161.budzdorov.ru    Sun Dec  6 16:27:28 2020
:44:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:45: 
:46: 
:47: mscs-test-161.budzdorov.ru    Sun Dec  6 16:27:29 2020
:48:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:49: 
:50: 
:51: mscs-test-161.budzdorov.ru    Sun Dec  6 16:27:32 2020
:52:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:53: 
:54: 
:55: mscs-test-161.budzdorov.ru    Sun Dec  6 16:27:35 2020
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
--- end of diff output ---

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

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