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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17147580 kB
MemAvailable 31251820 kB
Buffers 0 kB
Cached 14575976 kB
SwapCached 4876 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-02-05 19:27:18
DTS_END                         2021-02-05 19:27:18.4420
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/51098
TRN_ID                          234798
ATT_ID                          611
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: 9241.33 20929 1108959
customer order: creation 169.08 383 20289
customer order: refuse 14.44 436 1733
order to supplier: creation 45.86 1333 5503
order to supplier: removal 3.52 108929 422
invoice (draft): creation 45.78 3535 5494
invoice (draft): removal 52.21 906 6265
invoice accept: apply 41.08 18389 4930
invoice accept: cancel 46.84 744 5621
customer reserve: creation 3878.91 179 465469
customer reserve: removal 4657.63 64 558915
realization accept: apply 81.88 173 9825
realization accept: cancel 78.28 126 9394
payment from customer: creation 57.02 114 6842
payment from customer: removal 5.94 80 713
payment to supplier: creation 48.19 135 5783
payment to supplier: removal 3.34 121 401
service: total inventory turnovers 4.44 1265 533
service: total monetary turnovers 6.23 43 747
service: aggregate perf. data 0.63 31870 76
service: refresh index statistics 0.03 249762 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-02-2021 19:29:03 to 05-02-2021 19:29:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5650
TEST_TIME 2 5502
TEST_TIME 3 6097
TEST_TIME 4 5610
TEST_TIME 5 5672
TEST_TIME 6 5391
TEST_TIME 7 5310
TEST_TIME 8 5844
TEST_TIME 9 5749
TEST_TIME 10 5948
TEST_TIME 11 5959
TEST_TIME 12 6306
TEST_TIME 13 6390
TEST_TIME 14 7001
TEST_TIME 15 7131
TEST_TIME 16 7394
TEST_TIME 17 7574
TEST_TIME 18 7820
TEST_TIME 19 8418
TEST_TIME 20 8525
TEST_TIME 21 8810
TEST_TIME 22 8926
TEST_TIME 23 9105
TEST_TIME 24 9062
TEST_TIME 25 9411
TEST_TIME 26 10038
TEST_TIME 27 11014
TEST_TIME 28 11013
TEST_TIME 29 10839
TEST_TIME 30 10496
TEST_TIME 31 10304
TEST_TIME 32 10279
TEST_TIME 33 10219
TEST_TIME 34 10390
TEST_TIME 35 10305
TEST_TIME 36 10180
TEST_TIME 37 10110
TEST_TIME 38 9985
TEST_TIME 39 10030
TEST_TIME 40 10163
TEST_TIME 41 10045
TEST_TIME 42 10029
TEST_TIME 43 9958
TEST_TIME 44 10008
TEST_TIME 45 9852
TEST_TIME 46 9739
TEST_TIME 47 9725
TEST_TIME 48 9712
TEST_TIME 49 9613
TEST_TIME 50 9567
TEST_TIME 51 9568
TEST_TIME 52 9484
TEST_TIME 53 9407
TEST_TIME 54 9466
TEST_TIME 55 9566
TEST_TIME 56 9592
TEST_TIME 57 9591
TEST_TIME 58 9610
TEST_TIME 59 9697
TEST_TIME 60 9674
TEST_TIME 61 9642
TEST_TIME 62 9880
TEST_TIME 63 9823
TEST_TIME 64 9896
TEST_TIME 65 9819
TEST_TIME 66 9884
TEST_TIME 67 10049
TEST_TIME 68 10015
TEST_TIME 69 9882
TEST_TIME 70 9835
TEST_TIME 71 9741
TEST_TIME 72 9737
TEST_TIME 73 9760
TEST_TIME 74 9672
TEST_TIME 75 9649
TEST_TIME 76 9585
TEST_TIME 77 9535
TEST_TIME 78 9549
TEST_TIME 79 9518
TEST_TIME 80 9513
TEST_TIME 81 9523
TEST_TIME 82 9522
TEST_TIME 83 9572
TEST_TIME 84 9553
TEST_TIME 85 9568
TEST_TIME 86 9561
TEST_TIME 87 9585
TEST_TIME 88 9540
TEST_TIME 89 9564
TEST_TIME 90 9648
TEST_TIME 91 9621
TEST_TIME 92 9650
TEST_TIME 93 9574
TEST_TIME 94 9512
TEST_TIME 95 9509
TEST_TIME 96 9464
TEST_TIME 97 9409
TEST_TIME 98 9383
TEST_TIME 99 9331
TEST_TIME 100 9360
TEST_TIME 101 9324
TEST_TIME 102 9330
TEST_TIME 103 9335
TEST_TIME 104 9330
TEST_TIME 105 9348
TEST_TIME 106 9329
TEST_TIME 107 9369
TEST_TIME 108 9425
TEST_TIME 109 9432
TEST_TIME 110 9448
TEST_TIME 111 9459
TEST_TIME 112 9442
TEST_TIME 113 9505
TEST_TIME 114 9442
TEST_TIME 115 9386
TEST_TIME 116 9376
TEST_TIME 117 9332
TEST_TIME 118 9317
TEST_TIME 119 9308
TEST_TIME 120 9243

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-02-2021 19:29:06 to 05-02-2021 19:29:10.

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 1540287 1540287 0 0.00 0 13726 6 0 0
doc_list_biud 1540282 1540282 0 0.00 0 28183 29 0 0
sp_add_invoice_to_stock 5058 4930 128 2.53 20 165960 18390 0 128
sp_cancel_adding_invoice 5621 5621 0 0.00 5 42043 744 0 0
sp_cancel_client_order 1733 1733 0 0.00 4 15781 437 0 0
sp_cancel_customer_reserve 558915 558915 0 0.00 1 23752 64 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 4105 81 0 0
sp_cancel_pay_to_supplier 401 401 0 0.00 3 10148 122 0 0
sp_cancel_supplier_invoice 6272 6265 7 0.11 2 27614 907 0 7
sp_cancel_supplier_order 422 422 0 0.00 7 1098241 108930 0 0
sp_cancel_write_off 9394 9394 0 0.00 1 14466 127 0 0
sp_client_order 20289 20289 0 0.00 4 26933 383 0 0
sp_customer_reserve 465469 465469 0 0.00 0 76910 179 0 0
sp_fill_shopping_cart 31263 31263 0 0.00 1 14547 39 0 0
sp_fill_shopping_cart_clo_res 465464 465464 0 0.00 0 17982 14 0 0
sp_get_clo_for_invoice 4924 4924 0 0.00 0 32949 368 0 0
sp_kill_cost_storno 16129 16129 0 0.00 0 11937 61 0 0
sp_kill_qstorno_ret_qs2qd 1133911 1133911 0 0.00 0 27574 35 0 0
sp_kill_qty_storno 597099 597099 0 0.00 0 28181 75 0 0
sp_lock_selected_doc 20555 20555 0 0.00 0 8913 5 0 0
sp_make_cost_storno 27374 27374 0 0.00 0 13104 49 0 0
sp_multiply_rows_for_pdistr 27374 27374 0 0.00 0 6957 30 0 0
sp_multiply_rows_for_qdistr 20285 20285 0 0.00 0 10616 172 0 0
sp_pay_from_customer 6842 6842 0 0.00 4 10357 114 0 0
sp_pay_to_supplier 5783 5783 0 0.00 5 9546 136 0 0
sp_payment_common 12625 12625 0 0.00 1 9427 26 0 0
sp_qd_handle_on_cancel_clo 1733 1733 0 0.00 0 15771 388 0 0
sp_qd_handle_on_invoice_upd_sts 10545 10545 0 0.00 0 13199 312 0 0
sp_qd_handle_on_reserve_upd_sts 9825 9825 0 0.00 0 28179 64 0 0
sp_reserve_write_off 9825 9825 0 0.00 6 28257 174 0 0
sp_supplier_invoice 5494 5494 0 0.00 5 78680 3535 0 0
sp_supplier_order 5503 5503 0 0.00 5 35399 1334 0 0
srv_aggregate_perf_data 76 76 0 0.00 2797 719370 31871 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1432 146954 31108 0 0
srv_find_qd_qs_mism 1061835 1061835 0 0.00 0 13726 6 0 0
srv_make_invnt_saldo 533 533 0 0.00 40 132615 1265 0 0
srv_make_money_saldo 747 747 0 0.00 0 6487 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 150424 360538 249762 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4932 4932 0 0.00 0 16584 151 0 0
t$perf-norm:sp_cancel_adding_invoice 412 412 0 0.00 1 4284 101 0 0
t$perf-norm:sp_cancel_client_order 1733 1733 0 0.00 0 3561 16 0 0
t$perf-norm:sp_cancel_customer_reserve 702 702 0 0.00 0 3734 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 8681 34 0 0
t$perf-norm:sp_cancel_pay_to_supplier 401 401 0 0.00 0 2592 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 433 433 0 0.00 0 479 10 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 23535 1808 0 0
t$perf-norm:sp_cancel_write_off 991 991 0 0.00 0 2939 9 0 0
t$perf-norm:sp_client_order 20290 20290 0 0.00 0 14752 20 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 2104 8 0 0
t$perf-norm:sp_pay_from_customer 6846 6846 0 0.00 0 6726 15 0 0
t$perf-norm:sp_pay_to_supplier 5783 5783 0 0.00 0 2999 9 0 0
t$perf-norm:sp_reserve_write_off 9825 9825 0 0.00 0 7151 11 0 0
t$perf-norm:sp_supplier_invoice 5494 5494 0 0.00 0 6778 18 0 0
t$perf-norm:sp_supplier_order 5503 5503 0 0.00 0 12526 22 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 158 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 513 7 0 0
t$perf-norm:srv_make_invnt_saldo 533 533 0 0.00 0 1581 21 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 912 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 17 6 0 0
v_add_invoice_to_stock 10102 9846 256 2.53 0 16980 31 0 256
v_all_customers 37004 37004 0 0.00 0 22 1 0 0
v_all_suppliers 30734 30734 0 0.00 0 156 1 0 0
v_all_wares 40566 40566 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 824 824 0 0.00 0 2983 9 0 0
v_cancel_client_order 3466 3466 0 0.00 0 15352 13 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 3128 9 0 0
v_cancel_customer_reserve 1404 1404 0 0.00 0 3356 10 0 0
v_cancel_payment_to_supplier 802 802 0 0.00 0 10099 29 0 0
v_cancel_supplier_invoice 880 866 14 1.59 0 4250 23 0 14
v_cancel_supplier_order 844 844 0 0.00 0 720 5 0 0
v_cancel_write_off 1982 1982 0 0.00 0 505 11 0 0
v_max_id_clo_ord 5497 5497 0 0.00 0 580 1 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 2789 16 0 0
v_max_id_ord_sup 5481 5481 0 0.00 0 4814 6 0 0
v_max_non_paid_invoice 1394 1394 0 0.00 0 203 2 0 0
v_max_non_paid_realizn 3673 3673 0 0.00 0 6325 5 0 0
v_min_id_clo_ord 5497 5497 0 0.00 0 8715 8 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 6797 13 0 0
v_min_id_ord_sup 5481 5481 0 0.00 0 4804 8 0 0
v_min_non_paid_invoice 5783 5783 0 0.00 0 4143 18 0 0
v_min_non_paid_realizn 6842 6842 0 0.00 0 9420 15 0 0
v_our_firm 9900 9900 0 0.00 0 15 1 0 0
v_reserve_write_off 19650 19650 0 0.00 0 10167 7 0 0
x_lock_depdocs_on_canc_invoice 11453 11453 0 0.00 0 19034 119 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 7486 337 0 0
x_make_qstorno_1000_1200 5503 5503 0 0.00 2 35381 1252 0 0
x_make_qstorno_1200_2000 5494 5494 0 0.00 2 75194 3392 0 0
x_make_qstorno_2100_3300 465469 465469 0 0.00 0 76907 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-02-2021 19:29:11 to 05-02-2021 19:29:15.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:28 15654 8192000000 10222317776 10524631040 881676848 9.716 70 61 125 0 904825216 2498128 20650240
16:57:52 30798 8192000000 10340991248 10655744000 1383768672 14.450 100 90 181 1 1417392832 4750480 28873680
16:58:34 23835 8192000000 10374552848 10696159232 1429031168 14.853 100 90 180 0 1464724512 6761984 28931360
16:59:06 21512 8192000000 10401656016 10728402944 1450509584 15.042 100 86 172 0 1485678752 7769440 27399728
16:59:46 20729 8192000000 10430916832 10759098368 1481535760 15.315 100 93 186 0 1520158448 9054288 29568400
17:00:21 25529 8192000000 10442942208 10775891968 1497947968 15.458 100 88 176 0 1535824656 9663136 28213552
17:01:03 18720 8192000000 10466207152 10803150848 1516898224 15.623 100 88 176 0 1555202448 10359840 27944384
17:01:31 17387 8192000000 10487471344 10830041088 1545245840 15.869 100 89 178 1 1584058640 10829232 27983568
17:02:01 16480 8192000000 10524677232 10872410112 1562133376 16.015 100 84 169 3 1600087904 11413728 26540800
17:02:26 16906 8192000000 10545049888 10895306752 1597816512 16.321 100 87 174 0 1636960736 12223280 26920944
17:02:50 13008 8192000000 10555259104 10908467200 1610906816 16.432 100 85 170 0 1649683456 13016096 25760544
17:03:14 12190 8192000000 10569892016 10928300032 1627572768 16.574 100 81 161 0 1665113632 13336304 24204560
17:03:35 13042 8192000000 10588818640 10945425408 1641797200 16.695 100 83 166 1 1679785424 13257376 24730848
17:03:57 7394 8192000000 10605090192 10968592384 1663062608 16.875 100 84 168 3 1702095584 13830592 25202384
17:04:14 9263 8192000000 10621318320 10990247936 1682662640 17.040 100 81 162 0 1719494944 13197248 23635056
17:04:29 7214 8192000000 10642844368 11009363968 1700683408 17.191 100 83 166 4 1738212496 13152960 24376128
17:04:47 5505 8192000000 10648091216 11015667712 1711355792 17.280 100 87 174 3 1751123568 14100128 25667648
17:05:02 6432 8192000000 10658452208 11031535616 1723913600 17.385 100 75 149 0 1757530176 12439984 21176592
17:05:16 4785 8192000000 10679133552 11049058304 1733038304 17.461 100 82 164 2 1769561408 12723824 23799280
17:05:29 4691 8192000000 10688368112 11062669312 1747070256 17.577 100 79 156 0 1781136896 12311168 21755472
17:05:40 5100 8192000000 10690232816 11067686912 1752232560 17.620 100 86 172 1 1790839392 13055152 25551680
17:05:52 3094 8192000000 10699103552 11077828608 1763630304 17.714 100 85 171 1 1800388608 11957984 24800320
17:06:03 3720 8192000000 10715184400 11092549632 1775685184 17.814 100 86 171 1 1812084784 12750672 23648928
17:06:13 3131 8192000000 10719955168 11098763264 1779266720 17.843 100 79 158 0 1813685728 12461312 21957696
17:06:22 3547 8192000000 10734730416 11111079936 1788994320 17.924 100 86 174 2 1824806128 11820000 23991808
17:06:33 3523 8192000000 10734779488 11113766912 1794824224 17.971 100 91 181 1 1833953696 14111760 25017712
17:06:43 3984 8192000000 10743155680 11124146176 1799435040 18.009 100 87 176 0 1838206240 14958640 23812560
17:06:54 4223 8192000000 10754091936 11135299584 1804245024 18.049 100 86 174 0 1842789872 15466032 23078816
17:07:05 2035 8192000000 10760275792 11144228864 1817819680 18.160 100 83 166 1 1854641792 14762640 22059472
17:07:13 2107 8192000000 10771718080 11153887232 1826652304 18.232 100 90 181 1 1866266208 14655376 24958528
17:07:22 2225 8192000000 10771098272 11153514496 1828795264 18.250 100 95 188 0 1868879360 13671600 26412496
17:07:30 2643 8192000000 10784522432 11171102720 1836185456 18.310 100 81 162 1 1875164256 16494688 22484112
17:07:39 1343 8192000000 10783434272 11169968128 1839332672 18.335 100 87 175 0 1876496560 12499776 24664112
17:07:47 2290 8192000000 10787198064 11174436864 1847675680 18.403 100 97 195 1 1887660672 12689728 27295264
17:07:56 1787 8192000000 10792807072 11179343872 1850924400 18.430 100 92 183 0 1890546512 13502720 26119392
17:08:04 1408 8192000000 10797147488 11182481408 1852068560 18.439 100 87 174 0 1890803696 13636976 25098160
17:08:12 2212 8192000000 10804265600 11189760000 1856574256 18.475 100 88 176 1 1894174160 13513776 24086128
17:08:21 1084 8192000000 10804408496 11189960704 1860411008 18.507 100 95 188 3 1901628880 14599552 26618320
17:08:28 1002 8192000000 10813355552 11198271488 1865796304 18.550 100 91 180 0 1905006128 13842864 25366960
17:08:36 4046 8192000000 10789730912 11192664064 1863071136 18.528 100 79 158 1 1899154704 13599376 22484192
17:08:48 29939 8192000000 10787224112 11193528320 1859078032 18.496 100 55 112 1 1882872592 8133104 15661456
17:09:24 2714 8192000000 10784070048 11195789312 1863803904 18.534 100 60 120 2 1890946832 10097520 17045408
17:09:44 5173 8192000000 10782507760 11195039744 1860438896 18.507 100 38 75 0 1878376064 6784480 11152688
17:09:56 6188 8192000000 10771459488 11195166720 1859634544 18.500 100 27 54 1 1873999808 7174928 7190336
17:10:11 7152 8192000000 10788375168 11207065600 1867193808 18.562 100 36 73 0 1886103360 8524368 10385184
17:10:25 5761 8192000000 10786759280 11205181440 1873838096 18.615 100 39 78 0 1893323792 8337680 11148016
17:10:40 8983 8192000000 10801360720 11219087360 1873743504 18.615 100 28 56 1 1887930352 6714448 7472400
17:10:59 7172 8192000000 10781496544 11211501568 1877577648 18.646 100 18 36 3 1888352768 5809824 4965296
17:11:14 10634 8192000000 10791480912 11218714624 1880744816 18.671 100 22 44 1 1892800496 5587648 6468032
17:11:33 4659 8192000000 10794028176 11222646784 1884710448 18.703 100 29 58 1 1899510016 6998272 7801296
17:11:44 7769 8192000000 10790762496 11220434944 1883748144 18.695 100 16 32 0 1894619248 5777104 5094000
17:12:02 9656 8192000000 10804812656 11235241984 1889151440 18.739 100 21 42 2 1904860912 10016656 5692816
17:12:17 11399 8192000000 10800099968 11233935360 1893696288 18.776 100 24 48 2 1906242272 6339888 6206096
17:12:35 71281 8192000000 10808405504 11244007424 1897971312 18.810 100 34 66 1 1917541616 10027184 9543120
17:13:55 8866 8192000000 10808196912 11247788032 1896619808 18.799 100 18 37 1 1907207872 5590384 4997680
17:14:12 5447 8192000000 10823027792 11250499584 1899694992 18.824 100 32 64 0 1915807200 6929360 9182848
17:14:23 4481 8192000000 10818259904 11250384896 1900695440 18.832 100 35 70 1 1919895600 8108896 11091264
17:14:34 4980 8192000000 10834572912 11252064256 1901085792 18.835 100 39 77 0 1919743232 7746096 10911344
17:14:47 7694 8192000000 10820991088 11251621888 1904074640 18.859 100 34 68 1 1922547648 7873888 10599120
17:15:01 5617 8192000000 10814268912 11249848320 1902096640 18.843 100 23 44 2 1914770864 5704592 6969632
17:15:13 5647 8192000000 10813340816 11250995200 1905692944 18.872 100 27 54 1 1919579968 5305664 8581360
17:15:26 8414 8192000000 10824699600 11259359232 1908704368 18.896 100 21 43 0 1920101328 5824656 5572304
17:15:41 6978 8192000000 10836777600 11264446464 1909289104 18.901 100 24 48 0 1922260768 5852032 7119632
17:15:56 9204 8192000000 10816669152 11253534720 1893954528 18.778 99 26 51 1 1907943424 6579776 7409120
17:16:12 6512 8192000000 10823519888 11252748288 1905467056 18.870 100 16 32 2 1915631280 5484416 4679808
17:16:25 8173 8192000000 10808559664 11246084096 1890507392 18.750 99 16 32 2 1901176992 5256544 5413056
17:16:44 8007 8192000000 10790607120 11228286976 1854032864 18.455 97 27 54 1 1867404000 5698128 7673008
17:16:58 62417 8192000000 10777449504 11201323008 1811564576 18.109 95 27 56 1 1824816992 4600720 8651696
17:18:07 14906 8192000000 10776856336 11210055680 1807104912 18.072 96 23 46 0 1819218912 4908640 7205360
17:18:29 7868 8192000000 10749154016 11177971712 1793113584 17.957 96 21 42 1 1805083200 6276992 5692624
17:18:45 3568 8192000000 10771461264 11189841920 1847150240 18.399 100 32 65 0 1863109088 6694880 9263968
17:18:58 8226 8192000000 10753291872 11179290624 1825632624 18.224 99 27 54 1 1839498704 6119904 7746176
17:19:15 6969 8192000000 10731291776 11152347136 1791503952 17.944 98 24 48 2 1804745664 5868880 7372832
17:19:29 5819 8192000000 10733948720 11152654336 1796454752 17.985 99 28 56 0 1813961888 9590816 7916320
17:19:42 4643 8192000000 10708139648 11121160192 1777819136 17.832 98 28 57 0 1792817744 6609904 8388704
17:19:53 7639 8192000000 10722546336 11139678208 1764463232 17.721 97 34 66 2 1779781616 5229056 10089328
17:20:07 4864 8192000000 10730334944 11140276224 1807755536 18.077 100 36 72 0 1824729360 6526768 10447056
17:20:18 7067 8192000000 10719273504 11126685696 1731227856 17.446 95 33 65 2 1746828768 6153696 9447216
17:20:32 5268 8192000000 10719367488 11128680448 1773506864 17.796 99 39 78 3 1791044048 6232688 11304496
17:20:46 10428 8192000000 10714630352 11136466944 1785145040 17.892 99 33 66 0 1800365936 5640432 9580464
17:21:03 9732 8192000000 10714296000 11126534144 1749877696 17.601 97 22 41 2 1761592384 5366000 6348688
17:21:25 11593 8192000000 10720008480 11141664768 1778435568 17.837 98 33 66 1 1794567760 5757040 10375152
17:21:43 55485 8192000000 10713518496 11142737920 1756451584 17.655 97 35 69 2 1771738672 5628912 9658176
17:22:47 14655 8192000000 10727581232 11146166272 1767664832 17.748 97 18 36 1 1778171760 5747216 4759712
17:23:08 7249 8192000000 10751904928 11153121280 1807362832 18.074 99 42 81 1 1826073520 6751536 11959152
17:23:22 9213 8192000000 10727360096 11153596416 1805310560 18.057 99 46 93 2 1825013408 6747408 12955440
17:23:37 6624 8192000000 10749139248 11164676096 1812894720 18.120 99 29 58 3 1826392240 5320480 8177040
17:23:53 9590 8192000000 10753494048 11173433344 1817416304 18.157 99 29 57 1 1832074976 6364928 8293744
17:24:11 5734 8192000000 10760447488 11182579712 1818272240 18.164 99 26 52 1 1831531936 5345648 7914048
17:24:23 8479 8192000000 10762189360 11187400704 1844115920 18.374 100 18 36 0 1855190720 5601216 5473584
17:24:38 6881 8192000000 10769898608 11191742464 1850364080 18.425 100 21 42 1 1861207664 4867104 5976480
17:24:53 12918 8192000000 10768261008 11197337600 1854976688 18.463 100 17 34 0 1865907456 5621072 5309696
17:25:12 7867 8192000000 10787704272 11211378688 1867137456 18.561 100 20 40 0 1878720640 5692672 5890512
17:25:27 7850 8192000000 10788962352 11219431424 1871847680 18.599 100 18 36 1 1882324752 5375376 5101696
17:25:44 6876 8192000000 10789836208 11222171648 1876639664 18.638 100 19 38 2 1888449504 6176672 5633168
17:25:57 10292 8192000000 10786121648 11222167552 1879895632 18.664 100 18 36 0 1890301808 5234512 5171664
17:26:18 58086 8192000000 10796016368 11229585408 1880749904 18.671 100 23 45 3 1891897248 4963120 6184224
17:27:32 20676 8192000000 10838998480 11259400192 1915508144 18.951 100 43 86 0 1932916496 4420976 12987376
17:28:02 24600 8192000000 10860811760 11280027648 1930232240 19.069 100 58 116 1 1954064480 7268688 16563552
17:28:56 9497 8192000000 10883405296 11299807232 1944642656 19.184 100 65 130 1 1973853520 9685408 19525456
17:29:14 5548 8192000000 10886006624 11302567936 1951783760 19.241 100 65 125 3 1980078288 10579216 17715312
17:29:29 2550 8192000000 10893800272 11314827264 1953921424 19.258 100 64 124 2 1982842576 10969104 17952048
17:29:41 41804 8192000000 10895848224 11327590400 1959071840 19.299 100 57 113 1 1987043024 11862048 16109136
17:30:40 20481 8192000000 10894156896 11331403776 1965760000 19.352 100 45 90 0 1993340048 13770800 13809248
17:31:13 12037 8192000000 10912655328 11345088512 1970530208 19.390 100 49 97 0 2000865184 16153728 14181248
17:31:32 12164 8192000000 10911372096 11344371712 1977994352 19.449 100 51 102 1 2007666544 15034512 14637680
17:32:09 28482 8192000000 10918284032 11355938816 1981436448 19.476 100 34 68 1 2005950656 14622352 9891856
17:32:52 23185 8192000000 10929281280 11365687296 1990358272 19.547 100 37 71 1 2018010320 16060064 11591984
17:33:29 39067 8192000000 10929490176 11368992768 1976510592 19.437 99 46 92 0 2008838208 18464240 13863376
17:34:18 11286 8192000000 10938194096 11377217536 1998466544 19.611 100 46 91 0 2033306576 20651168 14188864
17:34:47 22917 8192000000 10957595408 11395268608 2009723568 19.699 100 49 98 0 2046811328 22298784 14788976
17:35:17 9362 8192000000 10944523840 11392851968 2008797968 19.692 100 39 76 0 2039076640 19048432 11230240
17:35:41 12211 8192000000 10954838880 11395039232 2013726096 19.731 100 43 84 0 2044667440 18354672 12586672
17:36:00 2470 8192000000 10975843408 11403735040 2022019296 19.796 100 70 137 3 2062668080 19768128 20880656
17:36:11 13949 8192000000 10968624320 11409027072 2022442032 19.799 100 51 102 3 2059682416 21979472 15260912
17:36:47 16064 8192000000 10975890000 11419262976 2029066816 19.851 100 49 98 0 2067236160 22762064 15407280
17:37:20 10418 8192000000 10971674448 11416309760 2024365952 19.814 100 49 98 1 2063864512 24168896 15329664
17:37:40 8860 8192000000 10970288848 11411140608 2024623136 19.816 100 53 104 3 2065328592 24002384 16703072
17:37:58 8002 8192000000 10981361632 11417911296 2030839360 19.865 100 70 137 1 2073385488 22121760 20424368
17:38:15 4491 8192000000 10989374800 11424112640 2030771424 19.865 100 62 124 0 2073714544 24317952 18625168
17:38:28 5235 8192000000 10989471280 11424157696 2033797584 19.888 100 66 131 0 2077050864 23911536 19341744
17:38:47 8439 8192000000 10992780864 11422527488 2027016544 19.835 100 63 125 1 2071992240 26160336 18815360
17:39:04 6084 8192000000 10997074304 11417718784 2026233264 19.829 100 83 166 1 2078938976 27756384 24949328
17:39:17 4525 8192000000 10987617056 11404935168 2016112688 19.750 100 83 165 1 2069973664 29109488 24751488
17:39:31 6409 8192000000 10979469872 11413463040 2020451168 19.784 100 72 144 0 2073721232 30918352 22351712
17:39:45 2490 8192000000 10989840928 11414753280 2020929808 19.787 100 84 165 1 2080874448 34550160 25394480
17:39:55 1765 8192000000 10994045856 11414069248 2021490016 19.792 100 79 158 0 2074498896 28481456 24527424
17:40:03 3370 8192000000 10986650928 11412742144 2017721808 19.762 100 76 150 1 2069903696 29591952 22589936
17:40:19 3284 8192000000 10990716320 11416420352 2023661264 19.809 100 73 146 1 2075034416 29347152 22026000
17:40:29 21432 8192000000 10975773760 11410956288 1997402944 19.602 99 68 135 0 2047677904 30084080 20190880
17:40:59 3049 8192000000 10998219328 11425005568 2021939056 19.795 100 81 161 1 2081494800 34723664 24832080
17:41:09 4129 8192000000 10999518880 11423141888 2022769168 19.802 100 78 156 0 2080896208 33646720 24480320
17:41:22 2272 8192000000 10995866448 11418042368 2019700448 19.778 100 86 171 1 2079571664 34044256 25826960
17:41:31 3658 8192000000 10996109296 11420819456 2020294736 19.782 100 83 166 0 2080900528 34979648 25626144
17:41:42 3822 8192000000 10996530240 11413467136 2013033712 19.725 100 90 179 1 2078109904 36049296 29026896
17:41:54 3571 8192000000 10977333120 11406381056 1993846528 19.574 99 75 151 3 2052132320 34373072 23912720
17:42:05 3082 8192000000 10982780576 11410276352 2009689872 19.699 100 68 136 0 2066427104 35444000 21293232
17:42:16 4389 8192000000 10985095968 11410796544 2005361936 19.665 100 68 136 0 2063382320 36012128 22008256
17:42:33 4251 8192000000 10992347680 11416133632 2011228720 19.711 100 84 170 2 2075120448 37558352 26333376
17:42:47 5858 8192000000 10999969248 11437936640 2020934976 19.787 100 53 106 0 2076906448 38844608 17126864
17:43:03 4525 8192000000 10985541184 11403431936 1994122384 19.576 99 72 138 0 2055111264 39478336 21510544
17:43:19 3189 8192000000 10991922960 11420557312 2013060480 19.726 100 73 144 0 2078086816 41812112 23214224
17:43:30 1976 8192000000 11006309008 11437297664 2019048304 19.773 100 71 142 2 2090343920 48649696 22645920
17:43:39 2441 8192000000 11016911072 11441627136 2025049776 19.820 100 77 154 1 2096099872 46138048 24912048
17:43:49 1758 8192000000 11017990224 11443118080 2026655312 19.832 100 80 159 0 2098003840 46154016 25194512
17:43:58 1431 8192000000 11017813200 11440005120 2023654384 19.809 100 79 158 0 2094537824 45493984 25389456
17:44:06 2049 8192000000 11016017056 11443990528 2029797840 19.857 100 79 156 2 2100824880 46421712 24605328
17:44:19 3788 8192000000 11012366688 11436302336 2022970784 19.803 100 72 144 1 2093043472 46735392 23337296
17:44:29 7003 8192000000 10992340416 11428487168 2015066928 19.741 100 73 147 1 2084860704 45739168 24054608
17:44:44 4439 8192000000 11010619888 11436511232 2007981184 19.686 99 76 150 1 2076950784 45220480 23749120
17:44:57 4907 8192000000 11003478080 11438596096 2013684784 19.731 100 61 119 1 2079704640 47006528 19013328
17:45:22 2885 8192000000 11020549520 11447418880 2020850528 19.787 100 79 156 1 2097672928 52010176 24812224
17:45:33 1572 8192000000 11023237952 11451142144 2023487888 19.808 100 82 164 2 2102694256 52901168 26305200
17:45:43 3691 8192000000 10998299328 11423219712 1997966144 19.607 100 74 148 0 2076488224 54326784 24195296
17:45:54 4691 8192000000 11009578000 11434553344 2016155280 19.750 100 79 158 1 2092446464 50525008 25766176
17:46:05 2110 8192000000 10980837136 11398537216 1977162640 19.442 98 92 186 1 2058179776 51833664 29183472
17:46:14 5109 8192000000 10987695808 11414622208 1993484560 19.571 100 73 142 0 2069254144 52847872 22921712
17:46:27 8790 8192000000 10973212256 11413168128 1978532560 19.453 99 61 122 3 2051313504 52800320 19980624
17:46:44 4639 8192000000 10972554768 11409145856 1990006448 19.544 100 54 109 2 2057335200 48663200 18665552
17:46:56 5236 8192000000 10958327488 11402608640 1992332080 19.562 100 49 97 2 2049301696 41292768 15676848
17:47:09 5869 8192000000 10948259072 11392942080 1972258016 19.403 99 38 76 2 2023529280 38747296 12523968
17:47:23 9149 8192000000 10967714992 11406446592 1973826928 19.416 99 46 92 0 2031886992 42921072 15138992
17:47:44 9317 8192000000 10956399264 11406499840 1984534576 19.501 100 36 72 2 2042203600 45298016 12371008
17:48:15 8036 8192000000 10963626512 11421859840 1999970032 19.622 100 38 76 1 2056298896 43954752 12374112
17:48:32 17650 8192000000 10962461200 11411714048 1996922032 19.598 100 31 62 0 2045710432 37262752 11525648
17:49:04 10674 8192000000 10955868400 11402502144 1983690016 19.494 99 45 89 1 2037165680 39206496 14269168
17:49:32 7490 8192000000 10956502288 11406008320 1991133552 19.553 100 37 72 0 2041100224 37227904 12738768
17:49:48 4203 8192000000 10919691024 11366486016 1955114736 19.267 100 34 68 1 2006129872 39549136 11466000
17:50:16 27064 8192000000 10928022288 11385999360 1953882256 19.257 99 28 56 1 2006174080 42322608 9969216
17:51:14 29109 8192000000 10912813072 11367555072 1935095104 19.108 99 30 60 1 1992283984 46475280 10713600
17:51:58 22238 8192000000 10921017968 11385163776 1950518928 19.231 100 27 54 0 2010867952 50015568 10333456
17:52:27 19676 8192000000 10896257680 11351437312 1922205504 19.005 99 22 44 0 1977483488 46821616 8456368
17:52:57 24888 8192000000 10897623552 11350732800 1901319664 18.837 98 38 73 1 1962403376 48360704 12723008
17:53:37 19480 8192000000 10893743632 11361222656 1911892112 18.922 99 26 52 0 1968771216 48022048 8857056
17:54:16 29545 8192000000 10832448416 11298828288 1813754352 18.127 94 16 32 0 1837714528 18558800 5401376
17:54:55 56745 8192000000 10843854432 11316219904 1876863824 18.640 98 9 18 1 1895032752 15837440 2331488
17:56:04 87558 8192000000 10844096272 11304853504 1847901840 18.405 96 12 24 0 1870034640 18997152 3135648
17:57:54 38657 8192000000 10857246480 11298189312 1864326160 18.538 96 44 87 2 1884574384 8423520 11824704
17:58:49 53384 8192000000 10863178320 11305414656 1908848064 18.897 99 33 66 1 1929841696 11793248 9200384
17:59:55 85071 8192000000 10880470336 11321606144 1822190048 18.196 94 31 62 0 1846170464 15419392 8561024
18:01:29 59259 8192000000 10879640848 11342598144 1936864416 19.122 100 25 50 1 1969097984 24674112 7559456
18:02:34 31052 8192000000 10885468448 11349987328 1950083216 19.227 100 16 32 1 1970282784 15887168 4312400
18:03:12 17831 8192000000 10881303360 11325480960 1941431152 19.158 99 43 86 2 1963286688 9628928 12226608
18:03:36 3519 8192000000 10901732880 11342610432 1957281920 19.284 100 48 95 2 1982056512 10818768 13955824
18:03:46 109668 8192000000 10915692224 11361533952 1914079200 18.939 97 32 64 2 1936199520 11769792 10350528
18:05:45 61099 8192000000 10929280352 11369328640 1973537744 19.414 100 52 104 2 2002845152 13765712 15541696
18:06:52 22651 8192000000 10892705504 11365502976 1953350976 19.253 99 31 62 1 1977413344 15296240 8766128
18:07:25 52280 8192000000 10887566080 11359174656 1965675184 19.351 100 11 22 0 1980106720 11282336 3149200
18:09:27 21696 8192000000 10887573424 11367137280 1965993088 19.354 100 9 18 1 1976296048 8023008 2279952
18:09:57 31553 8192000000 10885471600 11341803520 1951172064 19.236 99 15 29 0 1962698928 7445056 4081808
18:10:42 25613 8192000000 10900726816 11367911424 1967724576 19.367 100 18 37 0 1984308672 11672976 4911120
18:11:42 30227 8192000000 10895287824 11355451392 1963853280 19.337 100 9 16 0 1974297360 7878560 2565520
18:12:19 79118 8192000000 10902887024 11363876864 1974503616 19.421 100 44 88 0 1994162096 6528624 13129856
18:13:49 36644 8192000000 10912472880 11370889216 1981580848 19.477 100 35 66 3 1999499312 8334256 9584208
18:14:41 29939 8192000000 10921105424 11371511808 1966141344 19.355 99 42 82 3 1985139040 7204896 11792800
18:15:17 16627 8192000000 10925631360 11381837824 1989022080 19.536 100 56 112 1 2018024512 13148624 15853808
18:15:44 61462 8192000000 10915616992 11381121024 1971467616 19.397 99 18 35 0 1984750128 8409152 4873360
18:16:53 2768 8192000000 10914993776 11380903936 1990573472 19.548 100 23 46 1 2005100384 8404736 6122176
18:17:03 16870 8192000000 10923295840 11393306624 1993268368 19.570 100 21 42 1 2010647056 11137840 6240848
18:17:28 48911 8192000000 10913949360 11384623104 1964105440 19.339 98 37 73 0 1988991712 13697808 11188464
18:18:27 63518 8192000000 10900358096 11372044288 1965157856 19.347 99 13 26 1 1988495760 19432112 3905792
18:19:37 69574 8192000000 10918428160 11398447104 1991821024 19.558 100 17 33 2 2011963616 15228944 4913648
18:21:12 42567 8192000000 10931603248 11407810560 1993545136 19.572 100 26 53 2 2023267920 21263408 8459376
18:22:04 54041 8192000000 10926719792 11405488128 1971950256 19.401 99 12 24 1 1989692896 14734608 3008032
18:23:14 54633 8192000000 10925173952 11395772416 1978931376 19.456 99 22 42 1 2002551552 17280416 6339760
18:24:15 64923 8192000000 10907303312 11384373248 1977595824 19.446 99 17 34 1 1996475920 13673776 5206320
18:25:34 48167 8192000000 10908734704 11385204736 1970189696 19.387 99 14 28 0 1991259296 16655376 4414224
18:26:29 39203 8192000000 10914197472 11377242112 1933502896 19.095 97 18 34 2 1951433472 13424448 4506128
18:27:22 22026 8192000000 10940827664 11390922752 1977341536 19.444 99 52 102 2 2006336848 15093568 13901744
18:27:51 24192 8192000000 10921668720 11375661056 1959590880 19.303 98 44 88 1 1987599072 16123808 11884384
18:28:24 64703 8192000000 10908537424 11393093632 1938817232 19.137 98 21 42 0 1961497952 17134096 5546624
18:29:36 65443 8192000000 10910570480 11366215680 1925501232 19.031 97 18 36 0 1946228608 16183504 4543872
18:30:49 39365 8192000000 10907151136 11377995776 1941007408 19.155 98 29 58 1 1959338752 10194928 8136416
18:31:36 59712 8192000000 10899110640 11364823040 1939284976 19.141 98 16 32 0 1956599232 12941136 4373120
18:32:42 25984 8192000000 10922916352 11369140224 1953931568 19.258 99 28 56 0 1976953072 15250032 7771472
18:33:25 42541 8192000000 10913448880 11392827392 1948182192 19.212 99 21 42 0 1973951856 19700048 6069616
18:34:25 90576 8192000000 10875108016 11349405696 1834168368 18.293 93 10 20 1 1853953840 17360976 2424496
18:36:01 81447 8192000000 10874683536 11349815296 1947359856 19.205 100 14 28 0 1960141840 8946032 3835952
18:37:56 55703 8192000000 10860908288 11316396032 1885972912 18.713 97 32 64 0 1904029904 8947312 9109680
18:38:58 39354 8192000000 10887264176 11348336640 1947572608 19.207 100 23 46 1 1964276416 10110640 6593168
18:39:45 45902 8192000000 10860539344 11339968512 1919525136 18.983 98 21 42 2 1938342768 12568688 6248944
18:40:54 40222 8192000000 10867223648 11340697600 1910393520 18.910 98 11 21 0 1920783344 7598752 2791072
18:41:41 50970 8192000000 10846453952 11319201792 1872050592 18.601 96 18 36 2 1888075680 11180928 4844160
18:42:38 49009 8192000000 10808138976 11274100736 1806613216 18.068 94 16 33 0 1824704784 13391536 4700032
18:43:34 49367 8192000000 10799706304 11273814016 1843036400 18.366 97 18 36 1 1861065216 12408384 5620432
18:44:30 40708 8192000000 10821960576 11293298688 1894786528 18.784 100 14 28 0 1915262720 15776192 4700000
18:46:01 39511 8192000000 10819493440 11281510400 1832631584 18.281 96 14 28 0 1842854480 6474224 3748672
18:46:48 55907 8192000000 10827604480 11302744064 1880989520 18.673 98 26 52 3 1900275184 11901760 7383904
18:48:29 50029 8192000000 10838575696 11297284096 1870557584 18.589 98 27 54 1 1887048320 9232160 7258576
18:49:38 27726 8192000000 10842363088 11307032576 1896611072 18.799 99 34 66 5 1920287248 14388224 9287952
18:50:16 58889 8192000000 10832798384 11280916480 1802534304 18.035 94 29 58 0 1824828400 14358256 7935840
18:51:21 28504 8192000000 10841774944 11293396992 1900247344 18.828 100 45 90 1 1924898528 11680864 12970320
18:51:56 44924 8192000000 10837657328 11297755136 1888457488 18.733 99 26 52 3 1905551376 9973568 7120320
18:52:51 39849 8192000000 10860149104 11312549888 1919114592 18.980 100 49 98 1 1942699712 9882240 13702880
18:53:38 70883 8192000000 10853296832 11305402368 1873710960 18.614 97 30 59 1 1893282512 11604832 7966720
18:54:56 17510 8192000000 10883063536 11327782912 1933617360 19.096 100 29 57 1 1953568592 11106144 8845088
18:55:20 14811 8192000000 10902947184 11343826944 1942471584 19.166 100 43 86 0 1966449184 11976672 12000928
18:55:44 41092 8192000000 10907583248 11362213888 1953416080 19.254 100 42 84 0 1981873024 17046384 11410560
18:56:38 75203 8192000000 10894017088 11367116800 1953775024 19.257 100 19 38 0 1975254768 16842832 4636912
18:58:03 40685 8192000000 10886541536 11342385152 1906119776 18.875 97 21 42 0 1922611248 11036400 5455072
18:58:51 60196 8192000000 10887019536 11360419840 1940139584 19.148 99 14 27 2 1957151648 13591200 3420864
19:00:06 86506 8192000000 10905964864 11367387136 1968130976 19.371 100 31 62 2 1984700528 7417488 9152064
19:01:47 66196 8192000000 10885303104 11362705408 1961611104 19.319 99 21 42 1 1982834304 14830544 6392656
19:02:59 79476 8192000000 10883987440 11380031488 1972260960 19.403 100 5 10 0 1985145744 11509712 1375072
19:04:26 2336 8192000000 10885119648 11380957184 1969994240 19.385 100 3 6 0 1981742896 11068864 679792
19:04:39 21571 8192000000 10883558400 11370381312 1973557216 19.414 100 9 18 0 1984921712 9143136 2221360
19:05:09 69629 8192000000 10887220848 11370946560 1936560144 19.119 98 13 25 1 1946789008 7214464 3014400
19:07:43 62042 8192000000 10902045504 11379802112 1959657456 19.303 99 16 32 0 1972177968 7920112 4600400
19:08:52 56131 8192000000 10907047024 11388260352 1954685328 19.264 98 22 44 1 1970881040 10191216 6004496
19:09:54 42063 8192000000 10909844656 11391078400 1984821632 19.503 100 8 16 1 1997237360 10159712 2256016
19:10:43 32461 8192000000 10925082192 11401117696 1990443056 19.547 100 19 38 1 2007570704 11957392 5170256
19:11:32 39121 8192000000 10917584608 11390320640 1949806672 19.225 98 14 28 1 1967834512 14061136 3966704
19:12:34 42575 8192000000 10879408288 11343044608 1887817616 18.728 95 22 42 3 1903728112 9758832 6151664
19:13:28 61942 8192000000 10875645680 11353501696 1907884752 18.890 97 17 34 0 1926030192 13529120 4616320
19:14:36 82716 8192000000 10880650944 11367809024 1922032688 19.003 98 12 24 0 1945169632 19596512 3540432
19:16:05 61147 8192000000 10891779888 11366092800 1924148704 19.020 98 8 16 1 1939227888 13079328 1999856
19:17:16 146952 8192000000 10889047792 11337265152 1872988944 18.608 95 26 49 1 1892803984 13445488 6369552
19:19:50 36477 8192000000 10899531296 11363192832 1947510432 19.207 99 39 78 1 1969399424 11021840 10867152
19:20:34 135636 8192000000 10890330336 11348467712 1908119184 18.892 97 14 28 0 1927808752 16020544 3669024
19:22:55 64465 8192000000 10869048560 11334750208 1907396320 18.886 97 27 54 1 1926620016 12034816 7188880
19:24:27 12800 8192000000 10899185936 11364200448 1965866752 19.353 100 37 74 2 1991241216 14686816 10687648
19:24:47 53939 8192000000 10851613696 11324469248 1866194704 18.553 95 22 45 1 1885033536 12760032 6078800
19:25:47 61572 8192000000 10846368304 11327934464 1889479504 18.742 97 6 12 1 1900718000 9387216 1851280
19:27:01 25412 8192000000 9712310432 10156314624 791449648 8.810 41 3 6 0 796778352 4761312 567392

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-02-2021 19:29:17 to 05-02-2021 19:29:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 05-02-2021 19:29:50 to 05-02-2021 19:29:51.

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          234510
MON$OLDEST_ACTIVE               235200
MON$OLDEST_SNAPSHOT             235200
MON$NEXT_TRANSACTION            235200
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                       2029152
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.33414 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33414 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33414 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33414 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Feb  5 19:27:37 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Fri Feb  5 19:27:38 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

05.02.21 19:29:52. 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-02-05 19:29:55 No severe PSQL-related problems occured
05.02.21 19:29:56. End of report.