Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.01.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 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 17143920 kB
MemAvailable 31324540 kB
Buffers 0 kB
Cached 14508916 kB
SwapCached 4864 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-01-12 16:27:13
DTS_END                         2021-01-12 16:27:13.0260
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/51540
TRN_ID                          248263
ATT_ID                          688
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: 9371.29 24828 1124555
customer order: creation 180.39 366 21647
customer order: refuse 15.43 323 1851
order to supplier: creation 48.03 1302 5764
order to supplier: removal 3.36 103096 403
invoice (draft): creation 47.94 3282 5753
invoice (draft): removal 52.78 763 6333
invoice accept: apply 43.22 16989 5186
invoice accept: cancel 47.41 795 5689
customer reserve: creation 3998.03 168 479763
customer reserve: removal 4620.27 59 554432
realization accept: apply 86.71 183 10405
realization accept: cancel 91.83 96 11019
payment from customer: creation 62.05 119 7446
payment from customer: removal 5.80 66 696
payment to supplier: creation 51.45 127 6174
payment to supplier: removal 3.58 84 429
service: total inventory turnovers 5.26 979 631
service: total monetary turnovers 6.92 25 830
service: aggregate perf. data 0.83 23009 100
service: refresh index statistics 0.03 344724 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 12-01-2021 16:28:26 to 12-01-2021 16:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6944
TEST_TIME 2 4561
TEST_TIME 3 4945
TEST_TIME 4 4867
TEST_TIME 5 4777
TEST_TIME 6 4803
TEST_TIME 7 5047
TEST_TIME 8 5706
TEST_TIME 9 5586
TEST_TIME 10 5702
TEST_TIME 11 5800
TEST_TIME 12 5836
TEST_TIME 13 5864
TEST_TIME 14 6227
TEST_TIME 15 6436
TEST_TIME 16 6768
TEST_TIME 17 7364
TEST_TIME 18 7732
TEST_TIME 19 8174
TEST_TIME 20 8181
TEST_TIME 21 8081
TEST_TIME 22 8020
TEST_TIME 23 8325
TEST_TIME 24 9083
TEST_TIME 25 9557
TEST_TIME 26 9779
TEST_TIME 27 10213
TEST_TIME 28 10663
TEST_TIME 29 10388
TEST_TIME 30 10248
TEST_TIME 31 10459
TEST_TIME 32 10488
TEST_TIME 33 10471
TEST_TIME 34 10437
TEST_TIME 35 10462
TEST_TIME 36 10409
TEST_TIME 37 10404
TEST_TIME 38 10343
TEST_TIME 39 10252
TEST_TIME 40 10028
TEST_TIME 41 9859
TEST_TIME 42 9823
TEST_TIME 43 10022
TEST_TIME 44 9883
TEST_TIME 45 9908
TEST_TIME 46 9810
TEST_TIME 47 9778
TEST_TIME 48 9818
TEST_TIME 49 9716
TEST_TIME 50 9700
TEST_TIME 51 9597
TEST_TIME 52 9513
TEST_TIME 53 9457
TEST_TIME 54 9549
TEST_TIME 55 9589
TEST_TIME 56 9526
TEST_TIME 57 9646
TEST_TIME 58 9590
TEST_TIME 59 9647
TEST_TIME 60 9605
TEST_TIME 61 9661
TEST_TIME 62 9682
TEST_TIME 63 9730
TEST_TIME 64 9722
TEST_TIME 65 9773
TEST_TIME 66 9824
TEST_TIME 67 9857
TEST_TIME 68 9770
TEST_TIME 69 9662
TEST_TIME 70 9603
TEST_TIME 71 9627
TEST_TIME 72 9612
TEST_TIME 73 9655
TEST_TIME 74 9604
TEST_TIME 75 9547
TEST_TIME 76 9457
TEST_TIME 77 9428
TEST_TIME 78 9479
TEST_TIME 79 9498
TEST_TIME 80 9469
TEST_TIME 81 9525
TEST_TIME 82 9594
TEST_TIME 83 9597
TEST_TIME 84 9581
TEST_TIME 85 9695
TEST_TIME 86 9689
TEST_TIME 87 9706
TEST_TIME 88 9662
TEST_TIME 89 9698
TEST_TIME 90 9709
TEST_TIME 91 9632
TEST_TIME 92 9564
TEST_TIME 93 9588
TEST_TIME 94 9561
TEST_TIME 95 9526
TEST_TIME 96 9535
TEST_TIME 97 9566
TEST_TIME 98 9577
TEST_TIME 99 9549
TEST_TIME 100 9561
TEST_TIME 101 9586
TEST_TIME 102 9570
TEST_TIME 103 9576
TEST_TIME 104 9601
TEST_TIME 105 9591
TEST_TIME 106 9625
TEST_TIME 107 9593
TEST_TIME 108 9618
TEST_TIME 109 9631
TEST_TIME 110 9552
TEST_TIME 111 9519
TEST_TIME 112 9493
TEST_TIME 113 9489
TEST_TIME 114 9459
TEST_TIME 115 9417
TEST_TIME 116 9399
TEST_TIME 117 9350
TEST_TIME 118 9412
TEST_TIME 119 9426
TEST_TIME 120 9374

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-01-2021 16:28:30 to 12-01-2021 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 1568547 1568547 0 0.00 0 20480 6 0 0
doc_list_biud 1568546 1568546 0 0.00 0 67858 27 0 0
sp_add_invoice_to_stock 5303 5186 117 2.20 50 227038 16989 0 117
sp_cancel_adding_invoice 5689 5689 0 0.00 5 78620 796 0 0
sp_cancel_client_order 1851 1851 0 0.00 4 15453 324 0 0
sp_cancel_customer_reserve 554432 554432 0 0.00 1 67861 60 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 2 4781 67 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 4273 85 0 0
sp_cancel_supplier_invoice 6346 6333 13 0.20 2 27315 763 0 13
sp_cancel_supplier_order 403 403 0 0.00 7 1111043 103096 0 0
sp_cancel_write_off 11019 11019 0 0.00 1 10320 96 0 0
sp_client_order 21647 21647 0 0.00 4 27931 367 0 0
sp_customer_reserve 479763 479763 0 0.00 0 38839 168 0 0
sp_fill_shopping_cart 33158 33158 0 0.00 1 17651 38 0 0
sp_fill_shopping_cart_clo_res 479757 479757 0 0.00 0 20327 13 0 0
sp_get_clo_for_invoice 5180 5180 0 0.00 0 24485 274 0 0
sp_kill_cost_storno 17833 17833 0 0.00 0 4859 53 0 0
sp_kill_qstorno_ret_qs2qd 1126619 1126619 0 0.00 0 67850 32 0 0
sp_kill_qty_storno 595309 595309 0 0.00 0 67858 70 0 0
sp_lock_selected_doc 21639 21639 0 0.00 0 7013 4 0 0
sp_make_cost_storno 29202 29202 0 0.00 0 20474 53 0 0
sp_multiply_rows_for_pdistr 29202 29202 0 0.00 0 6534 28 0 0
sp_multiply_rows_for_qdistr 21646 21646 0 0.00 0 15908 163 0 0
sp_pay_from_customer 7446 7446 0 0.00 4 12496 119 0 0
sp_pay_to_supplier 6174 6174 0 0.00 5 14905 128 0 0
sp_payment_common 13620 13620 0 0.00 1 13808 28 0 0
sp_qd_handle_on_cancel_clo 1851 1851 0 0.00 0 15422 293 0 0
sp_qd_handle_on_invoice_upd_sts 10866 10866 0 0.00 0 43671 337 0 0
sp_qd_handle_on_reserve_upd_sts 10405 10405 0 0.00 0 21432 62 0 0
sp_reserve_write_off 10405 10405 0 0.00 6 21457 184 0 0
sp_supplier_invoice 5753 5753 0 0.00 7 91241 3282 0 0
sp_supplier_order 5764 5764 0 0.00 5 46880 1303 0 0
srv_aggregate_perf_data 100 100 0 0.00 2872 581273 23009 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1257 165887 32780 0 0
srv_find_qd_qs_mism 1074560 1074560 0 0.00 0 14535 5 0 0
srv_make_invnt_saldo 631 631 0 0.00 39 93527 979 0 0
srv_make_money_saldo 830 830 0 0.00 1 1806 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 218111 512420 344725 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5186 5186 0 0.00 0 16403 172 0 0
t$perf-norm:sp_cancel_adding_invoice 461 461 0 0.00 0 2050 67 0 0
t$perf-norm:sp_cancel_client_order 1851 1851 0 0.00 0 2831 12 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 3629 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 2473 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 3161 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 447 447 0 0.00 0 723 13 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 28664 1776 0 0
t$perf-norm:sp_cancel_write_off 1084 1084 0 0.00 0 319 3 0 0
t$perf-norm:sp_client_order 21647 21647 0 0.00 0 8657 18 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 185 2 0 0
t$perf-norm:sp_pay_from_customer 7446 7446 0 0.00 0 3770 8 0 0
t$perf-norm:sp_pay_to_supplier 6174 6174 0 0.00 0 1556 6 0 0
t$perf-norm:sp_reserve_write_off 10405 10405 0 0.00 0 8153 11 0 0
t$perf-norm:sp_supplier_invoice 5753 5753 0 0.00 0 6459 21 0 0
t$perf-norm:sp_supplier_order 5764 5764 0 0.00 0 11770 18 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 588 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 423 4 0 0
t$perf-norm:srv_make_invnt_saldo 631 631 0 0.00 0 2437 21 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 1605 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 157 41 0 0
v_add_invoice_to_stock 10588 10354 234 2.21 0 8083 20 0 234
v_all_customers 39538 39538 0 0.00 0 29 1 0 0
v_all_suppliers 32278 32278 0 0.00 0 15 1 0 0
v_all_wares 43290 43290 0 0.00 0 89 1 0 0
v_cancel_adding_invoice 922 922 0 0.00 0 439 8 0 0
v_cancel_client_order 3702 3702 0 0.00 0 4616 8 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 4651 10 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 3957 13 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 880 4 0 0
v_cancel_supplier_invoice 920 894 26 2.82 0 7255 27 0 26
v_cancel_supplier_order 806 806 0 0.00 0 6210 19 0 0
v_cancel_write_off 2168 2168 0 0.00 0 6228 21 0 0
v_max_id_clo_ord 5763 5763 0 0.00 0 1685 2 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 1113 10 0 0
v_max_id_ord_sup 5750 5750 0 0.00 0 4793 4 0 0
v_max_non_paid_invoice 1548 1548 0 0.00 0 83 2 0 0
v_max_non_paid_realizn 3901 3901 0 0.00 0 3190 7 0 0
v_min_id_clo_ord 5763 5763 0 0.00 0 8604 13 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 11103 20 0 0
v_min_id_ord_sup 5750 5750 0 0.00 0 4657 6 0 0
v_min_non_paid_invoice 6174 6174 0 0.00 0 3692 17 0 0
v_min_non_paid_realizn 7446 7446 0 0.00 0 6429 14 0 0
v_our_firm 10842 10842 0 0.00 0 12 1 0 0
v_reserve_write_off 20808 20808 0 0.00 0 7213 9 0 0
x_lock_depdocs_on_canc_invoice 11575 11575 0 0.00 0 13947 105 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 2894 297 0 0
x_make_qstorno_1000_1200 5764 5764 0 0.00 2 46874 1216 0 0
x_make_qstorno_1200_2000 5753 5753 0 0.00 3 91234 3148 0 0
x_make_qstorno_2100_3300 479763 479763 0 0.00 0 38836 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-01-2021 16:28:34 to 12-01-2021 16:28:38.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:23 17971 8192000000 10251621552 10559066112 865750960 9.558 70 46 91 0 883817648 2555104 15511584
13:57:52 23151 8192000000 10343273328 10661896192 1402601440 14.618 100 87 174 0 1436346976 4828240 28917296
13:58:28 25562 8192000000 10374881664 10699649024 1423704112 14.806 100 84 168 1 1457972464 6222048 28046304
13:59:03 21679 8192000000 10409876048 10733797376 1453586144 15.069 100 87 174 0 1488923888 6926544 28411200
13:59:36 17288 8192000000 10412516272 10740690944 1468859040 15.204 100 91 182 0 1505920400 7590160 29471200
14:00:04 26431 8192000000 10451289056 10785976320 1497716192 15.456 100 86 172 1 1533477504 7857376 27903936
14:00:41 23174 8192000000 10468575488 10808930304 1521612512 15.664 100 90 180 0 1559039936 8928032 28499392
14:01:13 18991 8192000000 10488825008 10833743872 1547051136 15.885 100 81 162 1 1582073472 9258624 25763712
14:01:41 10812 8192000000 10519732976 10868244480 1573450624 16.112 100 79 158 1 1606988896 9501056 24037216
14:02:02 13176 8192000000 10529592080 10884427776 1592011232 16.271 100 76 151 2 1624559552 9387168 23161152
14:02:26 12162 8192000000 10550790816 10910547968 1619752192 16.508 100 71 142 1 1650575104 9643792 21179120
14:02:46 10631 8192000000 10570674592 10932449280 1634056256 16.629 100 76 152 1 1667238528 10138048 23044224
14:03:08 18642 8192000000 10602343696 10966429696 1658823792 16.839 100 78 156 1 1693039824 10936016 23280016
14:03:34 11578 8192000000 10617681792 10983985152 1679087760 17.010 100 76 152 1 1712826752 11446352 22292640
14:03:54 9831 8192000000 10638105072 11009560576 1698979200 17.177 100 79 158 0 1733567952 12039552 22549200
14:04:12 11929 8192000000 10646124144 11017658368 1708707824 17.258 100 78 156 1 1743525648 12370912 22446912
14:04:34 9410 8192000000 10671787408 11047612416 1727315216 17.413 100 74 148 2 1760551104 12881136 20354752
14:04:53 6453 8192000000 10692216992 11068473344 1752699424 17.624 100 81 162 3 1788234560 13153520 22381616
14:05:11 4645 8192000000 10700090576 11076567040 1759343696 17.679 100 78 158 0 1794674832 13543696 21787440
14:05:26 5004 8192000000 10713282416 11092008960 1772807472 17.790 100 84 168 0 1810626832 14589264 23230096
14:05:38 4262 8192000000 10719540736 11101319168 1780159536 17.851 100 84 168 1 1818567056 14369920 24037600
14:05:49 2966 8192000000 10724819776 11105722368 1790823264 17.939 100 86 167 4 1828053920 13929440 23301216
14:05:59 3525 8192000000 10735142144 11116433408 1796369408 17.984 100 88 176 0 1835596160 14608032 24618720
14:06:09 3971 8192000000 10738408880 11122311168 1802177440 18.032 100 84 168 0 1838904352 13372576 23354336
14:06:20 4941 8192000000 10741734784 11128909824 1804581104 18.051 100 80 160 1 1839410976 12555744 22274128
14:06:32 3261 8192000000 10748603952 11131580416 1810506816 18.100 100 89 177 2 1849488112 14181584 24799712
14:06:42 9288 8192000000 10747735968 11134640128 1810371808 18.099 100 74 148 0 1844321360 13715744 20233808
14:06:58 5927 8192000000 10762903568 11149713408 1819388784 18.173 100 80 158 0 1856428752 14429888 22610080
14:07:11 2118 8192000000 10775366512 11158908928 1832050256 18.276 100 91 180 0 1870449200 13633056 24765888
14:07:20 2669 8192000000 10787059088 11172769792 1839933728 18.340 100 86 171 0 1878361360 14689808 23737824
14:07:29 1614 8192000000 10791578496 11178283008 1848615344 18.411 100 93 187 0 1888847056 14576768 25654944
14:07:37 2541 8192000000 10790431408 11174604800 1848111040 18.407 100 96 191 0 1888700160 13647440 26941680
14:07:46 1889 8192000000 10792956560 11178696704 1848817120 18.413 100 87 175 2 1886226816 12952576 24457120
14:07:55 1913 8192000000 10794047168 11183144960 1854982352 18.463 100 92 185 0 1894605936 13669648 25953936
14:08:03 1668 8192000000 10799582640 11185508352 1858130048 18.488 100 96 194 0 1899180528 14306288 26744192
14:08:12 1780 8192000000 10800650912 11188367360 1855051888 18.463 100 80 159 1 1890177040 13350048 21775104
14:08:20 2402 8192000000 10795398880 11185741824 1858421904 18.490 100 81 158 2 1893918080 11860640 23635536
14:08:29 1374 8192000000 10814215776 11202625536 1867636656 18.565 100 91 180 0 1906266256 12524720 26104880
14:08:37 1090 8192000000 10817952480 11206316032 1869463312 18.580 100 91 180 0 1906459856 11828160 25168384
14:08:44 13408 8192000000 10805250256 11204722688 1870079936 18.585 100 71 142 3 1901374256 11477936 19816384
14:09:17 1397 8192000000 10823397728 11214225408 1875525424 18.629 100 92 183 3 1915161152 13623904 26011824
14:09:25 13512 8192000000 10783945296 11200880640 1869424768 18.580 100 46 91 0 1892873040 11124416 12323856
14:09:45 4644 8192000000 10791363728 11203657728 1869998816 18.584 100 39 78 0 1889596224 8877664 10719744
14:09:56 4177 8192000000 10788794848 11207200768 1873333184 18.611 100 45 91 0 1899417904 13388224 12696496
14:10:06 6518 8192000000 10788695280 11210768384 1870990688 18.592 100 35 67 3 1892209504 11934960 9283856
14:10:21 6583 8192000000 10796605392 11207618560 1873494256 18.613 100 28 56 0 1888608704 7464784 7649664
14:10:36 4840 8192000000 10786572816 11211223040 1876971120 18.641 100 39 79 0 1895824480 8187968 10665392
14:10:48 7304 8192000000 10788174256 11212849152 1878097136 18.650 100 28 56 1 1891856656 5235504 8524016
14:11:03 7883 8192000000 10795094064 11216195584 1880127360 18.666 100 28 57 2 1894384416 5588512 8668544
14:11:18 10698 8192000000 10789568640 11214012416 1878208928 18.651 100 18 36 0 1888886816 5371040 5306848
14:11:36 12212 8192000000 10782059296 11217129472 1876821344 18.639 100 9 18 0 1884866672 5656192 2389136
14:11:55 11501 8192000000 10790725072 11222704128 1882282944 18.684 100 23 46 0 1896035648 7049824 6702880
14:12:12 9033 8192000000 10789848560 11220983808 1884734448 18.703 100 21 40 2 1897708224 6322480 6651296
14:12:28 13116 8192000000 10791514864 11222683648 1883793264 18.696 100 17 34 1 1894834032 6233952 4806816
14:12:47 8343 8192000000 10800193280 11229536256 1892651904 18.767 100 25 50 0 1906997216 6109728 8235584
14:13:04 63235 8192000000 10849510544 11253501952 1897693584 18.808 100 62 124 1 1926585520 9036592 19855344
14:14:14 9023 8192000000 10800157744 11242672128 1896233584 18.796 100 31 63 1 1913534128 8215024 9085520
14:14:30 8116 8192000000 10800823040 11226501120 1879319424 18.660 99 30 60 1 1894009088 5804240 8885424
14:14:45 6632 8192000000 10815268848 11237007360 1887889008 18.729 100 23 44 1 1901151600 6883776 6378816
14:14:59 4950 8192000000 10803679264 11234942976 1890644256 18.751 100 23 46 0 1903166768 6734576 5787936
14:15:12 7343 8192000000 10811412576 11248369664 1898460800 18.814 100 27 53 1 1912782752 6856816 7465136
14:15:31 8678 8192000000 10815736384 11247071232 1901643296 18.840 100 24 47 2 1918691984 10337744 6710944
14:15:46 8268 8192000000 10817328816 11255767040 1902990816 18.850 100 12 24 0 1912089616 5120304 3978496
14:16:00 4083 8192000000 10820889456 11255959552 1909395792 18.902 100 27 54 1 1923598464 6015632 8187040
14:16:11 11713 8192000000 10821948224 11257356288 1887465232 18.725 99 23 46 1 1904214384 10462448 6286704
14:16:30 2874 8192000000 10831811136 11260895232 1904094784 18.859 100 35 70 1 1924389184 9611280 10683120
14:16:39 13913 8192000000 10794664416 11230212096 1847188304 18.399 97 18 36 4 1857861616 5960544 4712768
14:17:01 8765 8192000000 10785097904 11225006080 1853814032 18.453 98 21 43 2 1865916080 6061872 6040176
14:17:16 16731 8192000000 10776696112 11188035584 1752105760 17.619 93 20 41 2 1763769664 5195344 6468560
14:17:39 69603 8192000000 10759992560 11186507776 1759430352 17.680 94 25 48 1 1771236736 5244512 6561872
14:18:55 5762 8192000000 10752610448 11177799680 1769888736 17.766 95 25 50 0 1781973840 5427392 6657712
14:19:07 5990 8192000000 10763178176 11193946112 1850368608 18.425 100 27 54 0 1864227888 6377008 7482272
14:19:20 6997 8192000000 10762395936 11176771584 1809059920 18.088 98 34 67 1 1828388304 9697376 9631008
14:19:37 4946 8192000000 10753428704 11170885632 1788330464 17.918 97 36 69 0 1805027664 7607728 9089472
14:19:50 8876 8192000000 10694559968 11114029056 1744083824 17.553 97 18 36 1 1754787728 5345664 5358240
14:20:05 5561 8192000000 10707720432 11123695616 1774898848 17.807 99 17 34 3 1785433472 5656480 4878144
14:20:18 8323 8192000000 10693402688 11109892096 1728729440 17.425 96 22 44 1 1741220656 5723216 6768000
14:20:34 8280 8192000000 10702672688 11115978752 1753506096 17.631 98 29 58 2 1768072592 6223904 8342592
14:20:48 9402 8192000000 10709811120 11128045568 1750341712 17.604 98 14 28 0 1760312816 5771712 4199392
14:21:06 8046 8192000000 10718304192 11128410112 1781156992 17.859 99 18 37 1 1791719504 5746400 4816112
14:21:20 14256 8192000000 10696631936 11094986752 1715173744 17.312 96 23 46 1 1727401376 5226848 7000784
14:21:42 15010 8192000000 10672361296 11089215488 1695648224 17.149 95 22 44 0 1707119920 5201360 6270336
14:22:03 9469 8192000000 10693404784 11107991552 1747507888 17.581 98 21 42 0 1758755488 5172688 6074912
14:22:20 66186 8192000000 10691203648 11111444480 1771461056 17.779 99 31 62 1 1785859456 4812928 9585472
14:23:32 16641 8192000000 10724841584 11148111872 1812082080 18.113 100 15 30 0 1821298592 5409072 3807440
14:23:56 7680 8192000000 10744601760 11161534464 1825333968 18.221 100 39 78 0 1844118512 8279104 10505440
14:24:10 7162 8192000000 10739737456 11164053504 1830002256 18.259 100 32 64 0 1845806128 6702464 9101408
14:24:26 7585 8192000000 10754099632 11178815488 1838163648 18.326 100 30 60 0 1857007792 10329776 8514368
14:24:48 10764 8192000000 10759650112 11183255552 1842662976 18.362 100 15 29 2 1852189888 5231264 4295648
14:25:06 5231 8192000000 10776329344 11195219968 1851086208 18.431 100 29 58 2 1869929728 10874064 7969456
14:25:20 7479 8192000000 10783114416 11195252736 1853621472 18.452 100 27 53 1 1867146912 5791552 7733888
14:25:41 9508 8192000000 10779467680 11205292032 1855694512 18.468 100 20 40 1 1875862544 14525584 5642448
14:25:58 11078 8192000000 10778516688 11202682880 1861408576 18.515 100 12 24 2 1869509536 4701152 3399808
14:26:15 15236 8192000000 10782653152 11212427264 1868762640 18.574 100 14 28 2 1877756656 5168832 3825184
14:26:37 8589 8192000000 10788857904 11216764928 1874733120 18.623 100 22 44 0 1886611008 5704288 6173600
14:26:52 9788 8192000000 10786204928 11219030016 1877279920 18.643 100 16 32 1 1887340768 4864480 5196368
14:27:09 10900 8192000000 10828808736 11240878080 1895709680 18.792 100 25 50 4 1908869904 5780064 7380160
14:27:28 19103 8192000000 10844378048 11260080128 1914542272 18.943 100 54 107 0 1941155568 10658704 15954592
14:27:56 86205 8192000000 10834142960 11275550720 1924237760 19.021 100 50 101 3 1946013952 7598032 14178160
14:29:32 77727 8192000000 10865254896 11298033664 1921700304 19.000 99 34 68 1 1940971568 10084000 9187264
14:30:58 12559 8192000000 10873258656 11303727104 1941387104 19.158 100 39 78 2 1963925920 10775968 11762848
14:31:22 33938 8192000000 10877938400 11306237952 1944334784 19.181 100 47 94 1 1968853136 11640320 12878032
14:32:05 17924 8192000000 10882145552 11317288960 1949976784 19.226 100 44 88 1 1976715504 14292400 12446320
14:32:37 15434 8192000000 10899608240 11323695104 1952996784 19.250 100 38 76 0 1977474480 13620448 10857248
14:33:00 14957 8192000000 10907072176 11331219456 1963729296 19.336 100 64 127 0 1998149120 16301872 18117952
14:33:26 12300 8192000000 10900333024 11332104192 1962380016 19.325 100 50 96 1 1992889232 16631984 13877232
14:33:47 10756 8192000000 10905847344 11339890688 1969411552 19.381 100 49 97 1 1999566112 16055040 14099520
14:34:06 5420 8192000000 10923904288 11347079168 1975733344 19.431 100 53 106 4 2006838448 15400608 15704496
14:34:21 10245 8192000000 10921134544 11355123712 1983046112 19.489 100 50 99 1 2014053808 16308720 14698976
14:34:38 6526 8192000000 10930418096 11359363072 1987326560 19.523 100 59 119 2 2021343520 16356768 17660192
14:34:55 9995 8192000000 10927212000 11358867456 1985482080 19.508 100 51 102 0 2019559184 18306736 15770368
14:35:27 15667 8192000000 10929242384 11358253056 1969364496 19.380 99 48 92 0 1999191568 16956688 12870384
14:35:54 4356 8192000000 10929888464 11359997952 1972140800 19.402 99 56 112 2 2009190480 20716400 16333280
14:36:05 7366 8192000000 10943712064 11369025536 1995446080 19.587 100 64 127 0 2031131648 17269120 18416448
14:36:20 6508 8192000000 10938897024 11371110400 1994750928 19.581 100 51 102 0 2027652944 17976080 14925936
14:36:34 2141 8192000000 10948708480 11372736512 1995741568 19.589 100 57 114 1 2032951408 19760416 17449424
14:36:44 7744 8192000000 10946765504 11377430528 1999840240 19.621 100 61 121 0 2037307264 19514256 17952768
14:37:09 6216 8192000000 10929141312 11358756864 1964099760 19.339 98 55 110 2 2004110704 24264800 15746144
14:37:25 5639 8192000000 10948372704 11375276032 1991494272 19.556 100 66 132 0 2036077216 24341040 20241904
14:37:45 9042 8192000000 10951079728 11379671040 1997452800 19.603 100 54 107 2 2040091872 26557648 16081424
14:38:04 4104 8192000000 10958899152 11388657664 2002150256 19.640 100 58 117 2 2045390160 26561472 16678432
14:38:16 9211 8192000000 10970444832 11398918144 2011094960 19.710 100 58 116 0 2056343152 27733792 17514400
14:38:33 2036 8192000000 10957965360 11384086528 2001939328 19.638 100 72 139 4 2051082432 28046848 21096256
14:38:44 7490 8192000000 10969406368 11391012864 1990926464 19.551 99 66 126 2 2036820144 27677824 18215856
14:38:59 4473 8192000000 10966559568 11387535360 2001641312 19.636 100 65 129 1 2049892848 28409888 19841648
14:39:11 2876 8192000000 10972913248 11391021056 2007517552 19.682 100 83 165 0 2061933840 30022960 24393328
14:39:20 2191 8192000000 10983314192 11404099584 2014683088 19.738 100 87 172 2 2071326016 30834368 25808560
14:39:34 5155 8192000000 10980949792 11405901824 2015517392 19.745 100 72 144 1 2068460480 31368080 21575008
14:39:48 6285 8192000000 10989472640 11410948096 2018306240 19.767 100 68 136 0 2070340736 31464848 20569648
14:40:03 8215 8192000000 10969771536 11403960320 2014147840 19.734 100 54 107 2 2061851504 31358576 16345088
14:40:19 5089 8192000000 10962381968 11385384960 1995785584 19.589 99 67 129 0 2045785840 30886672 19113584
14:40:31 5680 8192000000 10976652304 11385061376 1978248016 19.451 98 81 163 0 2036733440 33158064 25327360
14:40:44 2876 8192000000 10979251520 11396902912 2004308592 19.657 100 77 152 1 2068209472 40264416 23636464
14:40:55 5889 8192000000 10976671856 11396104192 1985697792 19.510 99 72 144 1 2044968880 36724352 22546736
14:41:08 6859 8192000000 10974278240 11405189120 2006504704 19.674 100 75 149 2 2072927344 42739392 23683248
14:41:21 6493 8192000000 10966571952 11390070784 1984199488 19.498 99 64 128 0 2041255648 37139600 19916560
14:41:38 11208 8192000000 10979785152 11408400384 2010510576 19.706 100 68 136 0 2068935632 37857344 20567712
14:41:59 3927 8192000000 10965933936 11386277888 1987040032 19.520 100 71 141 1 2050195904 41153712 22002160
14:42:13 10070 8192000000 10949353344 11374395392 1963722864 19.336 99 55 110 1 2021931008 40469232 17738912
14:42:34 3967 8192000000 10970568528 11391389696 1988076064 19.529 100 70 137 1 2052175184 42612464 21486656
14:42:44 3357 8192000000 10971097216 11391713280 1993022608 19.568 100 74 147 1 2058998416 43466960 22508848
14:42:54 1581 8192000000 10975127984 11388116992 1975804880 19.431 99 80 160 2 2047643872 46078832 25760160
14:43:04 3318 8192000000 10975100160 11396370432 1991718560 19.557 100 77 152 2 2061663664 45804816 24140288
14:43:15 5474 8192000000 10983339696 11402178560 1996319792 19.594 100 83 164 1 2067532800 45576512 25636496
14:43:27 3200 8192000000 10977420688 11398778880 1980898448 19.472 99 71 141 0 2046801968 43802576 22100944
14:43:39 2260 8192000000 10962116208 11378880512 1974798576 19.423 99 75 150 2 2041295712 42826736 23670400
14:43:48 1626 8192000000 10980174464 11393536000 1986667728 19.517 100 86 172 1 2059082048 45403840 27010480
14:43:58 4769 8192000000 10966833504 11383099392 1978124352 19.450 100 80 159 1 2049773728 46567200 25082176
14:44:10 2185 8192000000 10984545600 11397197824 1990416384 19.547 100 92 184 0 2070973008 51141152 29415472
14:44:19 1256 8192000000 10987443584 11402936320 1992643088 19.565 100 84 168 2 2069684912 50664656 26377168
14:44:28 3276 8192000000 10946932960 11356778496 1935333952 19.110 97 81 159 0 2008594064 47147008 26113104
14:44:40 3375 8192000000 10957167696 11373498368 1965872944 19.353 100 75 149 0 2037617760 46903920 24840896
14:44:50 2190 8192000000 10979075184 11394977792 1986892208 19.519 100 79 156 0 2059726288 48569248 24264832
14:45:03 3692 8192000000 10958828864 11372421120 1965240448 19.348 99 81 161 6 2038842720 47654144 25948128
14:45:14 5238 8192000000 10969066048 11380211712 1971864416 19.400 100 76 152 0 2044529632 47683248 24981968
14:45:28 7167 8192000000 10963541008 11385118720 1975807856 19.431 100 72 142 0 2046558224 47276176 23474192
14:45:45 2104 8192000000 10958485408 11366666240 1966763456 19.360 100 84 167 0 2034013792 40165232 27085104
14:45:56 4930 8192000000 10962022848 11379822592 1975098384 19.426 100 78 155 0 2040483024 41247856 24136784
14:46:08 3976 8192000000 10952986208 11373342720 1972308528 19.404 100 73 147 1 2035750048 40642912 22798608
14:46:26 23900 8192000000 10902343072 11339227136 1924167168 19.020 98 42 84 0 1972152032 35147264 12837600
14:47:16 6225 8192000000 10927108064 11352412160 1957090400 19.283 100 50 99 0 2008355776 35559008 15706368
14:47:28 7258 8192000000 10932871200 11356880896 1961668112 19.319 100 64 128 2 2022017536 41420544 18928880
14:47:42 10425 8192000000 10933849008 11368538112 1963638464 19.335 100 49 98 0 2017134624 38390848 15105312
14:48:00 9020 8192000000 10929028560 11373551616 1966527792 19.358 100 36 72 1 2017613856 39042992 12043072
14:48:27 19180 8192000000 10945058864 11387609088 1978491728 19.453 100 36 73 1 2031944928 41736384 11716816
14:48:54 6374 8192000000 10960397920 11391381504 1978454272 19.452 100 42 84 1 2036561328 44320752 13786304
14:49:07 13457 8192000000 10946179024 11385065472 1956289456 19.277 99 43 86 1 2017219376 46528880 14401040
14:49:39 15511 8192000000 10925161120 11355910144 1927123136 19.044 99 47 94 1 1992391376 49711648 15556592
14:50:04 1967 8192000000 10950295760 11372625920 1954024544 19.259 100 63 126 0 2030304880 55314976 20965360
14:50:15 8389 8192000000 10939890464 11379228672 1941738192 19.161 99 49 98 0 2019432304 60720944 16973168
14:50:30 26499 8192000000 10932303040 11372756992 1950168768 19.228 100 35 70 0 2019143824 56142880 12832176
14:51:22 17628 8192000000 10903742304 11348946944 1935968224 19.115 100 28 56 3 1992873712 46463584 10441904
14:51:48 11970 8192000000 10900626896 11345735680 1924353968 19.022 99 32 62 0 1976011840 41259696 10398176
14:52:15 17559 8192000000 10906659040 11355611136 1932941344 19.090 99 31 62 4 1983606384 40216768 10448272
14:53:01 33360 8192000000 10884246288 11337576448 1928276624 19.053 100 20 40 1 1967862400 32858608 6727168
14:53:40 40549 8192000000 10858910032 11315011584 1883628032 18.694 98 16 30 1 1922110080 33394848 5087200
14:54:28 37881 8192000000 10870372192 11305377792 1888288112 18.732 99 23 45 0 1927650880 31915344 7447424
14:55:12 8071 8192000000 10894041776 11326996480 1927729984 19.049 100 49 97 1 1968315216 25721920 14863312
14:55:28 12918 8192000000 10853931888 11321245696 1899757280 18.824 99 32 64 1 1927135088 18116880 9260928
14:56:18 55356 8192000000 10873722672 11325718528 1934370160 19.102 100 39 78 1 1964216992 17979584 11867248
14:57:28 16813 8192000000 10897926432 11336495104 1948462336 19.214 100 47 95 0 1980595712 18347792 13785584
14:58:00 56459 8192000000 10871367248 11339956224 1905607520 18.871 98 11 22 0 1932645424 23491232 3546672
14:59:04 42897 8192000000 10869217120 11337633792 1910414288 18.910 99 6 12 1 1938325536 26087088 1824160
14:59:53 62710 8192000000 10885385296 11331391488 1899765504 18.824 98 15 30 0 1921862576 18781984 3315088
15:01:12 59469 8192000000 10877773680 11330080768 1928463184 19.055 99 24 48 4 1941101824 7020048 5618592
15:02:32 96216 8192000000 10878747632 11337932800 1917759072 18.969 98 8 16 2 1929925536 9930448 2236016
15:04:15 165886 8192000000 10889175856 11348389888 1882997360 18.689 96 18 36 2 1900792400 12667504 5127536
15:07:15 83593 8192000000 10922306544 11365044224 1970540352 19.390 100 36 72 0 1991488112 11112544 9835216
15:08:46 32138 8192000000 10925765648 11370029056 1958608032 19.295 99 43 86 0 1985748176 14574144 12566000
15:09:26 65932 8192000000 10880519632 11364593664 1937201136 19.124 98 25 50 2 1966290128 21621376 7467616
15:11:43 13440 8192000000 10877591088 11344306176 1947313728 19.205 99 23 43 1 1962210624 9522736 5374160
15:12:04 8499 8192000000 10889192016 11362230272 1965997728 19.354 100 22 43 5 1982121968 10327360 5796880
15:12:51 28093 8192000000 10924596144 11358314496 1935663792 19.112 98 34 68 0 1955536608 9964912 9907904
15:13:26 17021 8192000000 10901991184 11366703104 1973541392 19.414 100 41 80 1 1997642576 11810928 12290256
15:13:55 45641 8192000000 10869178224 11340316672 1910620000 18.912 97 33 67 1 1932750496 11818304 10312192
15:14:56 28038 8192000000 10881520832 11350822912 1945977408 19.194 100 6 12 0 1958871440 11438288 1455744
15:15:31 48189 8192000000 10880428192 11354357760 1961049504 19.314 100 12 24 1 1975356512 10586576 3720432
15:16:26 46193 8192000000 10893359664 11365109760 1969120096 19.378 100 9 18 0 1980576880 8934976 2521808
15:17:49 45258 8192000000 10905695312 11371487232 1961488064 19.318 99 18 36 1 1977233616 10540944 5204608
15:18:42 61485 8192000000 10914978656 11384758272 1964266208 19.340 99 17 34 0 1985012976 15352384 5394384
15:20:36 35495 8192000000 10899927600 11386675200 1961003648 19.314 99 15 30 0 1978723504 13178192 4541664
15:21:19 54005 8192000000 10881225696 11358961664 1926042176 19.035 98 12 24 1 1940884224 11224880 3617168
15:22:27 31182 8192000000 10889538272 11355639808 1927838192 19.050 98 27 54 1 1950555216 14485808 8231216
15:23:10 27406 8192000000 10887237136 11355389952 1931967600 19.083 98 19 37 1 1947151584 9141728 6042256
15:23:58 44338 8192000000 10847838288 11323342848 1864111056 18.537 95 22 44 1 1880289248 10121872 6056320
15:24:56 59393 8192000000 10892816848 11354845184 1919795584 18.985 98 30 59 3 1935890080 7585136 8509360
15:26:02 79116 8192000000 10895984624 11374186496 1954167744 19.260 99 11 22 2 1968698416 11434560 3096112
15:27:27 42180 8192000000 10905548448 11365744640 1930936816 19.074 97 42 84 2 1949901184 7579344 11385024
15:28:20 72808 8192000000 10903230640 11374772224 1899992224 18.826 96 18 36 2 1920841328 15957264 4891840
15:29:40 88355 8192000000 10866648416 11339476992 1786608016 17.904 91 14 28 0 1799207840 9300912 3298912
15:31:21 40835 8192000000 10885178464 11345539072 1930627840 19.072 99 14 28 1 1943597584 9567168 3402576
15:32:12 71561 8192000000 10882431232 11350441984 1916126608 18.956 98 16 32 1 1934160736 13760448 4273680
15:33:33 101747 8192000000 10889191360 11328794624 1835971536 18.308 94 18 36 0 1858063952 17626752 4465664
15:35:23 28849 8192000000 10884694960 11334885376 1932515264 19.087 99 49 98 1 1958378720 12091904 13771552
15:36:00 97411 8192000000 10849835104 11310383104 1872264912 18.603 96 33 66 1 1892793072 11024640 9503520
15:37:44 73585 8192000000 10857567920 11324297216 1877950144 18.649 97 19 38 2 1899940320 16522528 5467648
15:39:08 24595 8192000000 10856474192 11327324160 1919915344 18.986 100 19 38 0 1940576096 15391504 5269248
15:39:42 77794 8192000000 10863071984 11337486336 1915480160 18.951 99 12 24 2 1929413056 10661936 3270960
15:41:09 91516 8192000000 10862418160 11340218368 1884837184 18.704 97 14 28 0 1905805200 16962288 4005728
15:42:46 46185 8192000000 10864288912 11327750144 1900829104 18.833 98 15 30 2 1922684528 17008816 4846608
15:43:39 76672 8192000000 10863281120 11332988928 1921264560 18.997 99 11 22 1 1937517264 12953904 3298800
15:45:04 55034 8192000000 10860464880 11334778880 1895379888 18.789 98 13 26 0 1910404928 11048192 3976848
15:46:06 47571 8192000000 10870681840 11337826304 1898002896 18.810 98 11 22 0 1914906624 13910448 2993280
15:47:16 91047 8192000000 10892732304 11351994368 1896510512 18.798 97 16 32 0 1919117264 17625392 4981360
15:48:56 101470 8192000000 10882625344 11354533888 1870743504 18.590 96 11 21 1 1885612880 12193696 2675680
15:50:46 42636 8192000000 10899799408 11371270144 1953845216 19.257 100 21 42 1 1976532128 16765152 5921760
15:51:37 95406 8192000000 10886467920 11360493568 1917369216 18.966 98 26 52 0 1947273696 22009536 7894944
15:53:27 42231 8192000000 10885878352 11342131200 1929108976 19.060 99 28 56 1 1951973744 14608112 8256656
15:54:32 75620 8192000000 10892191904 11350515712 1919757024 18.985 98 28 56 1 1938095648 10558192 7780432
15:55:56 54336 8192000000 10891528816 11343286272 1863871888 18.535 95 34 68 0 1888010096 15411056 8727152
15:57:00 52510 8192000000 10918583072 11372199936 1962556672 19.326 100 28 56 1 1984327664 13699616 8071376
15:57:59 123546 8192000000 10914993904 11379064832 1982224496 19.482 100 35 70 1 2002462112 10191472 10046144
16:00:09 41235 8192000000 10895679664 11374727168 1974257024 19.419 100 19 38 2 1993946096 13855904 5833168
16:00:58 55291 8192000000 10895248784 11382427648 1958453632 19.294 99 7 14 0 1974441840 14277776 1710432
16:02:03 36363 8192000000 10900881536 11390177280 1976978064 19.441 100 5 10 0 1994893312 16672432 1242816
16:02:48 9892 8192000000 10900948512 11393073152 1977907360 19.448 100 6 12 0 1993844992 14118080 1819552
16:03:06 18389 8192000000 10902937376 11397464064 1976109856 19.434 100 2 4 0 1989704064 13469584 124624
16:03:31 69828 8192000000 10918146576 11396464640 1990255152 19.546 100 16 32 2 2007318336 12758768 4304416
16:04:47 41888 8192000000 10906421088 11377065984 1956302944 19.277 98 18 36 0 1968537440 7600656 4633840
16:05:47 42503 8192000000 10898970000 11374825472 1928872864 19.058 97 13 27 0 1940521360 7430656 4217840
16:06:36 59559 8192000000 10897103792 11374952448 1926928144 19.042 97 18 36 1 1942005280 9883184 5193952
16:07:42 41934 8192000000 10884339296 11356577792 1918477264 18.975 97 23 46 3 1935851584 10163584 7210736
16:08:39 21785 8192000000 10878688240 11348086784 1929222768 19.061 98 33 66 1 1949351328 10653264 9475296
16:09:27 54527 8192000000 10909192864 11373993984 1956159568 19.276 99 21 42 2 1971770112 9720992 5889552
16:10:28 59508 8192000000 10878278560 11360133120 1907098624 18.883 97 11 22 1 1919662208 9463344 3100240
16:11:35 48980 8192000000 10900268240 11361693696 1924520960 19.023 98 24 48 0 1940135072 9207168 6406944
16:12:31 93037 8192000000 10890700096 11365052416 1896903856 18.801 96 26 52 0 1915017872 10742080 7371936
16:14:12 21517 8192000000 10908334080 11353059328 1911634112 18.920 97 38 76 0 1929266800 7207744 10424944
16:14:40 16525 8192000000 10877925280 11329613824 1860965632 18.511 95 38 77 0 1880470896 9134384 10370880
16:15:03 19736 8192000000 10901535584 11345596416 1922461952 19.007 99 37 74 1 1944832576 11945744 10424880
16:15:30 97292 8192000000 10863472352 11340640256 1829991152 18.259 94 21 42 0 1846012784 10549216 5472416
16:17:20 80537 8192000000 10857313472 11323449344 1888013056 18.730 97 16 32 0 1902340928 10354400 3973472
16:18:47 25633 8192000000 10858511776 11320229888 1905279168 18.869 98 31 62 2 1927216432 13303216 8634048
16:19:22 55683 8192000000 10850971744 11323879424 1907766032 18.889 99 13 26 2 1924789152 13690688 3332432
16:20:23 9129 8192000000 10877371872 11341275136 1936057472 19.115 100 26 54 1 1955981840 13053920 6870448
16:20:39 57361 8192000000 10862363248 11341643776 1927480704 19.047 99 14 28 0 1941074240 9360256 4233280
16:21:46 53314 8192000000 10854279616 11334844416 1890310064 18.748 97 7 14 0 1907003744 14960912 1732768
16:22:45 40119 8192000000 10856648976 11334463488 1932137792 19.084 100 12 24 0 1947809616 11636512 4035312
16:23:33 88575 8192000000 10867846944 11341553664 1889053920 18.738 97 23 47 1 1909024800 13130528 6840352
16:25:20 100545 8192000000 10874555328 11343994880 1861097968 18.512 96 12 24 1 1882931424 18203728 3629728
16:27:11 6217 8192000000 9134293408 9369239552 299171632 3.523 16 1 2 0 302774384 3540624 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-01-2021 16:29:13 to 12-01-2021 16:29:15.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          248581
MON$OLDEST_ACTIVE               248582
MON$OLDEST_SNAPSHOT             248582
MON$NEXT_TRANSACTION            248582
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                       2038880
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
--- end of diff output ---

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

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