Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.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 17027624 kB
MemAvailable 31329272 kB
Buffers 0 kB
Cached 14685976 kB
SwapCached 4868 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-21 16:27:12
DTS_END                         2021-01-21 16:27:12.7540
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/45980
TRN_ID                          242194
ATT_ID                          718
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: 9413.13 19064 1129576
customer order: creation 174.87 335 20984
customer order: refuse 14.70 313 1764
order to supplier: creation 46.22 1216 5546
order to supplier: removal 3.72 89596 446
invoice (draft): creation 47.72 3378 5726
invoice (draft): removal 54.40 745 6528
invoice accept: apply 42.68 16381 5121
invoice accept: cancel 48.47 755 5816
customer reserve: creation 3971.97 160 476636
customer reserve: removal 4704.68 54 564562
realization accept: apply 84.58 185 10150
realization accept: cancel 87.33 115 10479
payment from customer: creation 60.18 112 7221
payment from customer: removal 6.18 89 741
payment to supplier: creation 49.87 139 5984
payment to supplier: removal 3.43 83 411
service: total inventory turnovers 4.71 1167 565
service: total monetary turnovers 6.62 33 794
service: aggregate perf. data 0.82 23301 98
service: refresh index statistics 0.03 243127 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-01-2021 16:28:40 to 21-01-2021 16:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4996
TEST_TIME 2 7464
TEST_TIME 3 6463
TEST_TIME 4 6014
TEST_TIME 5 5560
TEST_TIME 6 6029
TEST_TIME 7 5902
TEST_TIME 8 5623
TEST_TIME 9 5908
TEST_TIME 10 5902
TEST_TIME 11 5973
TEST_TIME 12 6467
TEST_TIME 13 6794
TEST_TIME 14 6914
TEST_TIME 15 7135
TEST_TIME 16 7160
TEST_TIME 17 7291
TEST_TIME 18 7374
TEST_TIME 19 7484
TEST_TIME 20 7993
TEST_TIME 21 8566
TEST_TIME 22 8714
TEST_TIME 23 8874
TEST_TIME 24 9475
TEST_TIME 25 9624
TEST_TIME 26 9949
TEST_TIME 27 10005
TEST_TIME 28 10355
TEST_TIME 29 10742
TEST_TIME 30 10698
TEST_TIME 31 10616
TEST_TIME 32 10730
TEST_TIME 33 10616
TEST_TIME 34 10588
TEST_TIME 35 10433
TEST_TIME 36 10571
TEST_TIME 37 10497
TEST_TIME 38 10475
TEST_TIME 39 10454
TEST_TIME 40 10367
TEST_TIME 41 10249
TEST_TIME 42 10084
TEST_TIME 43 10016
TEST_TIME 44 10031
TEST_TIME 45 9895
TEST_TIME 46 9991
TEST_TIME 47 9897
TEST_TIME 48 9966
TEST_TIME 49 9971
TEST_TIME 50 9956
TEST_TIME 51 9847
TEST_TIME 52 9700
TEST_TIME 53 9771
TEST_TIME 54 9815
TEST_TIME 55 9743
TEST_TIME 56 9752
TEST_TIME 57 9812
TEST_TIME 58 9821
TEST_TIME 59 9833
TEST_TIME 60 9854
TEST_TIME 61 9883
TEST_TIME 62 9893
TEST_TIME 63 10019
TEST_TIME 64 10011
TEST_TIME 65 10044
TEST_TIME 66 10113
TEST_TIME 67 10132
TEST_TIME 68 10127
TEST_TIME 69 10087
TEST_TIME 70 10100
TEST_TIME 71 10017
TEST_TIME 72 9941
TEST_TIME 73 9920
TEST_TIME 74 9882
TEST_TIME 75 9828
TEST_TIME 76 9792
TEST_TIME 77 9734
TEST_TIME 78 9775
TEST_TIME 79 9732
TEST_TIME 80 9677
TEST_TIME 81 9654
TEST_TIME 82 9694
TEST_TIME 83 9671
TEST_TIME 84 9677
TEST_TIME 85 9683
TEST_TIME 86 9730
TEST_TIME 87 9775
TEST_TIME 88 9740
TEST_TIME 89 9798
TEST_TIME 90 9827
TEST_TIME 91 9835
TEST_TIME 92 9843
TEST_TIME 93 9884
TEST_TIME 94 9891
TEST_TIME 95 9895
TEST_TIME 96 9804
TEST_TIME 97 9765
TEST_TIME 98 9752
TEST_TIME 99 9705
TEST_TIME 100 9659
TEST_TIME 101 9601
TEST_TIME 102 9630
TEST_TIME 103 9630
TEST_TIME 104 9597
TEST_TIME 105 9597
TEST_TIME 106 9630
TEST_TIME 107 9610
TEST_TIME 108 9625
TEST_TIME 109 9616
TEST_TIME 110 9578
TEST_TIME 111 9585
TEST_TIME 112 9595
TEST_TIME 113 9613
TEST_TIME 114 9629
TEST_TIME 115 9590
TEST_TIME 116 9521
TEST_TIME 117 9508
TEST_TIME 118 9497
TEST_TIME 119 9474
TEST_TIME 120 9417

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-01-2021 16:28:43 to 21-01-2021 16:28:47.

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 1570300 1570300 0 0.00 0 28608 6 0 0
doc_list_biud 1570298 1570298 0 0.00 0 53820 25 0 0
sp_add_invoice_to_stock 5245 5121 124 2.36 19 235508 16382 0 124
sp_cancel_adding_invoice 5816 5816 0 0.00 5 58927 755 0 0
sp_cancel_client_order 1764 1764 0 0.00 4 16344 313 0 0
sp_cancel_customer_reserve 564562 564562 0 0.00 1 53824 55 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 2 5856 89 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 5199 84 0 0
sp_cancel_supplier_invoice 6536 6528 8 0.12 2 20053 746 0 8
sp_cancel_supplier_order 446 446 0 0.00 6 865312 89596 0 0
sp_cancel_write_off 10479 10479 0 0.00 1 12204 115 0 0
sp_client_order 20984 20984 0 0.00 3 29605 336 0 0
sp_customer_reserve 476636 476636 0 0.00 0 104058 161 0 0
sp_fill_shopping_cart 32251 32251 0 0.00 1 15185 38 0 0
sp_fill_shopping_cart_clo_res 476628 476628 0 0.00 0 16036 12 0 0
sp_get_clo_for_invoice 5113 5113 0 0.00 0 21621 255 0 0
sp_kill_cost_storno 17447 17447 0 0.00 0 6750 55 0 0
sp_kill_qstorno_ret_qs2qd 1146577 1146577 0 0.00 0 53807 30 0 0
sp_kill_qty_storno 604858 604858 0 0.00 0 53820 65 0 0
sp_lock_selected_doc 21221 21221 0 0.00 0 10602 7 0 0
sp_make_cost_storno 28468 28468 0 0.00 0 28595 56 0 0
sp_multiply_rows_for_pdistr 28468 28468 0 0.00 0 9926 32 0 0
sp_multiply_rows_for_qdistr 20984 20984 0 0.00 0 27575 135 0 0
sp_pay_from_customer 7221 7221 0 0.00 4 16519 113 0 0
sp_pay_to_supplier 5984 5984 0 0.00 5 11523 139 0 0
sp_payment_common 13204 13204 0 0.00 1 16511 35 0 0
sp_qd_handle_on_cancel_clo 1764 1764 0 0.00 0 16336 292 0 0
sp_qd_handle_on_invoice_upd_sts 10929 10929 0 0.00 0 29870 315 0 0
sp_qd_handle_on_reserve_upd_sts 10150 10150 0 0.00 0 19272 69 0 0
sp_reserve_write_off 10150 10150 0 0.00 6 19621 185 0 0
sp_supplier_invoice 5726 5726 0 0.00 6 91226 3378 0 0
sp_supplier_order 5546 5546 0 0.00 5 76269 1217 0 0
srv_aggregate_perf_data 98 98 0 0.00 2406 475272 23301 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1125 144538 35511 0 0
srv_find_qd_qs_mism 1080405 1080405 0 0.00 0 13373 5 0 0
srv_make_invnt_saldo 565 565 0 0.00 42 54347 1168 0 0
srv_make_money_saldo 794 794 0 0.00 1 9576 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 173286 432625 243128 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5122 5122 0 0.00 0 36758 175 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 1 2021 67 0 0
t$perf-norm:sp_cancel_client_order 1764 1764 0 0.00 0 2402 13 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 5241 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 5420 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 723 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 2237 16 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 24907 1589 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 6100 12 0 0
t$perf-norm:sp_client_order 20984 20984 0 0.00 0 9466 17 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 5045 7 0 0
t$perf-norm:sp_pay_from_customer 7221 7221 0 0.00 0 19281 13 0 0
t$perf-norm:sp_pay_to_supplier 5984 5984 0 0.00 0 5221 8 0 0
t$perf-norm:sp_reserve_write_off 10150 10150 0 0.00 0 5283 10 0 0
t$perf-norm:sp_supplier_invoice 5726 5726 0 0.00 0 4474 16 0 0
t$perf-norm:sp_supplier_order 5546 5546 0 0.00 0 5692 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 347 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 1293 14 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 1269 24 0 0
t$perf-norm:srv_make_money_saldo 794 794 0 0.00 0 784 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 4 0 0
v_add_invoice_to_stock 10474 10226 248 2.36 0 7595 19 0 248
v_all_customers 38052 38052 0 0.00 0 89 1 0 0
v_all_suppliers 31522 31522 0 0.00 0 13 1 0 0
v_all_wares 41968 41968 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 266 5 0 0
v_cancel_client_order 3528 3528 0 0.00 0 2387 4 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 2651 6 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 999 4 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 1894 8 0 0
v_cancel_supplier_invoice 888 872 16 1.80 0 1270 17 0 16
v_cancel_supplier_order 892 892 0 0.00 0 5039 10 0 0
v_cancel_write_off 1986 1986 0 0.00 0 3697 14 0 0
v_max_id_clo_ord 5545 5545 0 0.00 0 635 1 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 2704 8 0 0
v_max_id_ord_sup 5722 5722 0 0.00 0 7205 8 0 0
v_max_non_paid_invoice 1489 1489 0 0.00 0 4887 6 0 0
v_max_non_paid_realizn 3956 3956 0 0.00 0 3316 4 0 0
v_min_id_clo_ord 5545 5545 0 0.00 0 2576 10 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 5271 22 0 0
v_min_id_ord_sup 5722 5722 0 0.00 0 6443 9 0 0
v_min_non_paid_invoice 5983 5983 0 0.00 0 6905 25 0 0
v_min_non_paid_realizn 7221 7221 0 0.00 0 7446 23 0 0
v_our_firm 10446 10446 0 0.00 0 34 1 0 0
v_reserve_write_off 20300 20300 0 0.00 0 5169 5 0 0
x_lock_depdocs_on_canc_invoice 11908 11908 0 0.00 0 27785 105 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 6527 311 0 0
x_make_qstorno_1000_1200 5546 5546 0 0.00 2 76253 1139 0 0
x_make_qstorno_1200_2000 5726 5726 0 0.00 3 78243 3238 0 0
x_make_qstorno_2100_3300 476636 476636 0 0.00 0 104057 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-01-2021 16:28:48 to 21-01-2021 16:28:52.

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:22 19619 8192000000 10218110128 10519552000 830929408 9.209 67 52 106 0 852578256 2503488 19145360
13:57:50 10977 8192000000 10284231536 10594488320 1345082736 14.103 100 79 159 0 1375392288 4079520 26230032
13:58:09 35523 8192000000 10362148960 10684223488 1398740528 14.584 100 86 172 0 1432094352 5137088 28216736
13:58:58 38641 8192000000 10409690176 10738675712 1458458016 15.112 100 89 177 0 1493958896 7324416 28176464
13:59:48 8440 8192000000 10422205472 10752028672 1478870832 15.292 100 88 176 0 1514668544 7934768 27862944
14:00:04 17320 8192000000 10427606864 10759569408 1484304816 15.339 100 90 180 0 1521481856 8365504 28811536
14:00:32 16065 8192000000 10442539152 10779787264 1497346256 15.453 100 78 156 0 1530977280 8700560 24930464
14:01:12 21121 8192000000 10475777984 10820513792 1527236224 15.713 100 82 164 0 1562224368 9245760 25742384
14:01:42 13070 8192000000 10507230704 10855661568 1566783648 16.055 100 84 168 0 1602041168 9708544 25548976
14:02:18 14082 8192000000 10545671456 10902450176 1596454880 16.309 100 73 146 2 1629555024 10959408 22140736
14:02:46 12210 8192000000 10591133264 10951237632 1642070832 16.697 100 89 178 2 1680581344 11797824 26712688
14:03:05 11530 8192000000 10599557456 10965770240 1658925760 16.840 100 77 154 1 1693274368 11562304 22786304
14:03:30 7966 8192000000 10615519824 10988777472 1680442752 17.021 100 72 144 2 1713264688 10954512 21867424
14:03:45 10665 8192000000 10634346160 11009241088 1702383600 17.205 100 70 138 2 1733303840 10917888 20002352
14:04:03 8524 8192000000 10650149904 11025272832 1716133904 17.320 100 80 158 3 1750922080 11543504 23244672
14:04:18 7639 8192000000 10661929216 11036225536 1726208736 17.404 100 81 162 2 1762739760 12516032 24014992
14:04:32 5055 8192000000 10665469040 11041529856 1730139632 17.437 100 79 158 1 1766235424 12504656 23591136
14:04:46 8343 8192000000 10682443568 11060326400 1744306160 17.554 100 75 150 0 1778039456 12795840 20937456
14:05:02 6361 8192000000 10689068432 11066855424 1747295648 17.579 100 72 144 0 1779992416 12023904 20672864
14:05:14 5096 8192000000 10691108592 11070480384 1758088992 17.669 100 84 166 2 1794234720 12829616 23316112
14:05:28 4853 8192000000 10706020752 11086598144 1767684560 17.748 100 86 171 2 1804399120 12383696 24330864
14:05:40 3099 8192000000 10714326720 11094990848 1772390384 17.787 100 81 162 0 1808744544 13261424 23092736
14:05:52 4234 8192000000 10728984560 11107590144 1783109808 17.875 100 91 180 1 1821686368 13166848 25409712
14:06:03 3471 8192000000 10724625264 11108331520 1791423008 17.943 100 87 173 3 1828674656 13495552 23756096
14:06:14 7109 8192000000 10725315136 11115757568 1794415168 17.968 100 77 151 2 1828273728 12727456 21131104
14:06:28 5254 8192000000 10747708832 11131346944 1799716736 18.012 100 83 165 1 1835970464 12805712 23448016
14:06:40 3758 8192000000 10759893872 11143602176 1818065408 18.162 100 84 166 3 1852340848 11639904 22635536
14:06:50 2637 8192000000 10761402064 11148251136 1825291456 18.221 100 89 179 0 1862951616 12641056 25019104
14:06:59 2789 8192000000 10776154160 11160047616 1834173920 18.293 100 88 176 1 1872197360 13923280 24100160
14:07:09 2015 8192000000 10787448304 11169501184 1836867936 18.315 100 94 186 1 1878522720 15334560 26320224
14:07:17 2396 8192000000 10787489776 11171553280 1840117920 18.342 100 91 183 2 1878947920 13473392 25356608
14:07:26 1288 8192000000 10778251120 11164164096 1840429584 18.344 100 87 174 0 1877493424 13203120 23860720
14:07:33 1766 8192000000 10791459216 11173310464 1845497136 18.386 100 93 186 1 1885478400 13105216 26876048
14:07:41 1430 8192000000 10795770224 11181756416 1851602784 18.435 100 92 184 1 1891485952 14330720 25552448
14:07:49 1994 8192000000 10798345456 11186728960 1851250176 18.432 100 91 180 2 1892331328 14500032 26581120
14:07:57 2060 8192000000 10794367072 11184746496 1854281504 18.457 100 88 176 2 1892431440 13800272 24349664
14:08:06 2056 8192000000 10790686400 11181424640 1858797808 18.494 100 89 178 2 1897640848 13199552 25643488
14:08:14 11119 8192000000 10779489136 11182477312 1852834560 18.445 100 60 120 1 1880870112 10639696 17395856
14:08:32 19298 8192000000 10804323936 11190075392 1859570976 18.500 100 81 163 2 1893361120 10079168 23710976
14:08:59 2645 8192000000 10802691760 11193024512 1860308160 18.506 100 82 164 0 1896761040 12455248 23997632
14:09:08 28329 8192000000 10765953568 11180077056 1849684496 18.420 100 31 61 1 1865583808 7767360 8131952
14:09:43 11280 8192000000 10786930896 11186769920 1856481232 18.475 100 63 130 2 1884614512 9806960 18326320
14:10:00 25533 8192000000 10751163712 11183366144 1853651248 18.452 100 30 60 3 1870121440 6663856 9806336
14:10:35 3759 8192000000 10771754720 11189039104 1858947888 18.495 100 56 110 3 1882131408 6413952 16769568
14:10:46 3387 8192000000 10781403280 11191681024 1856968016 18.479 100 45 84 0 1877870992 8996320 11906656
14:10:56 4310 8192000000 10764829472 11190714368 1857776976 18.485 100 31 62 2 1874911056 8004448 9129632
14:11:07 6257 8192000000 10778143536 11196014592 1861385216 18.515 100 37 72 3 1882080832 10692752 10002864
14:11:20 5259 8192000000 10783972624 11201007616 1863461856 18.531 100 36 73 2 1881827968 7895728 10470384
14:11:34 6133 8192000000 10779649536 11196129280 1861761312 18.518 100 18 36 0 1872648800 6266112 4621376
14:11:49 8173 8192000000 10785241104 11207258112 1867357424 18.563 100 23 46 2 1883034160 9743968 5932768
14:12:06 5950 8192000000 10775962912 11211235328 1873944832 18.616 100 29 58 0 1889355296 7178512 8231952
14:12:19 7901 8192000000 10792953200 11216289792 1877348832 18.644 100 32 64 0 1893334224 6217536 9767856
14:12:36 8547 8192000000 10785613888 11214155776 1879128000 18.658 100 22 44 1 1891953744 6506352 6319392
14:12:54 8634 8192000000 10782235744 11214069760 1877891200 18.648 100 27 54 1 1892453440 6734432 7827808
14:13:12 7446 8192000000 10789818608 11216621568 1880511200 18.669 100 19 38 1 1891531824 5719312 5301312
14:13:30 12548 8192000000 10790936800 11224485888 1884763072 18.704 100 21 41 2 1896332624 5369536 6200016
14:13:53 12794 8192000000 10803017808 11226505216 1887639424 18.727 100 21 41 3 1903433184 10052448 5741312
14:14:12 52864 8192000000 10820671968 11239596032 1895616384 18.791 100 30 59 1 1909621024 5208064 8796576
14:15:11 25223 8192000000 10812258128 11244900352 1895690576 18.792 100 25 50 1 1908922512 5569040 7662896
14:15:45 8709 8192000000 10826650128 11247628288 1882562144 18.686 99 38 75 0 1899351088 6999680 9789264
14:16:00 5349 8192000000 10811036288 11238961152 1888494960 18.734 100 32 64 3 1905317280 8155632 8666688
14:16:13 7203 8192000000 10807067040 11241824256 1894994288 18.786 100 24 48 4 1908670784 6750272 6926224
14:16:28 3004 8192000000 10820629440 11252400128 1899353568 18.821 100 38 76 1 1920940016 10442512 11143936
14:16:40 8031 8192000000 10811694832 11245428736 1896245744 18.796 100 28 57 0 1911164112 6699840 8218528
14:16:55 9735 8192000000 10803424512 11236126720 1874090528 18.617 99 22 44 2 1886325920 5682320 6553072
14:17:14 4533 8192000000 10784268640 11209183232 1835820400 18.307 97 32 64 4 1851092784 6477136 8795248
14:17:26 4837 8192000000 10796237936 11218665472 1849795488 18.420 98 30 59 0 1863076096 5489136 7791472
14:17:37 4725 8192000000 10770056048 11196915712 1850496640 18.426 99 27 54 0 1865377408 6444368 8436400
14:17:50 12747 8192000000 10752764736 11178074112 1794493328 17.969 96 14 28 0 1808053840 9549392 4011120
14:18:11 9849 8192000000 10750217248 11177746432 1766466848 17.738 95 13 25 0 1776456640 5951024 4038768
14:18:27 14260 8192000000 10780698672 11208818688 1854553904 18.459 100 16 32 0 1868889424 9841040 4494480
14:18:47 9824 8192000000 10766541184 11191853056 1805349248 18.058 97 17 34 1 1815791072 5727488 4714336
14:19:09 76290 8192000000 10693290048 11116310528 1553867008 15.943 84 32 65 0 1567122672 4521552 8734112
14:20:31 5780 8192000000 10715587552 11138240512 1784176816 17.884 98 31 63 1 1799395616 5332048 9886752
14:20:44 8823 8192000000 10737530912 11156193280 1774471104 17.804 97 43 88 2 1793393600 5693120 13229376
14:21:01 9511 8192000000 10698792864 11110629376 1704082432 17.219 94 24 48 1 1716337856 5119040 7136384
14:21:17 4852 8192000000 10686307808 11083218944 1718343008 17.338 96 49 99 0 1739952768 7342256 14267504
14:21:30 7495 8192000000 10669594640 11084935168 1699752176 17.183 96 29 58 2 1714281680 5316224 9213280
14:21:47 7434 8192000000 10704895376 11108630528 1746504352 17.573 98 27 54 0 1759693120 5734128 7454640
14:22:06 9765 8192000000 10716015168 11128819712 1768987184 17.759 98 27 54 2 1782504656 5800656 7716816
14:22:22 8841 8192000000 10696918160 11116077056 1787481600 17.911 100 28 56 2 1801711120 6315360 7914160
14:22:38 8308 8192000000 10721229920 11139444736 1802739984 18.036 100 17 35 0 1813667072 6269136 4657952
14:22:54 4816 8192000000 10731841184 11145121792 1793359664 17.959 99 26 52 1 1811296448 10176960 7759824
14:23:08 11983 8192000000 10735169424 11151933440 1800731472 18.020 99 13 26 1 1809794768 5101376 3961920
14:23:30 14274 8192000000 10728331136 11157041152 1821816256 18.193 100 28 56 1 1835954144 5298000 8839888
14:23:52 21479 8192000000 10755388416 11176181760 1837122432 18.317 100 26 52 2 1850806304 5416400 8267472
14:24:56 33319 8192000000 10760651552 11182407680 1843581232 18.370 100 27 54 1 1857017968 5829760 7606976
14:25:37 5256 8192000000 10765150864 11187081216 1848280832 18.408 100 29 58 1 1862624928 6591120 7752976
14:25:50 7896 8192000000 10768938256 11197554688 1852143248 18.440 100 29 58 0 1866833840 6650016 8040576
14:26:04 6268 8192000000 10763978912 11191947264 1851124752 18.431 100 21 42 1 1863453776 6422832 5906192
14:26:16 10407 8192000000 10780811664 11203035136 1860856880 18.510 100 28 56 1 1874455664 5608464 7990320
14:26:38 7027 8192000000 10761341504 11197390848 1856621856 18.476 100 14 26 2 1865926176 5243728 4060592
14:26:55 8045 8192000000 10773207008 11203825664 1860689216 18.509 100 23 46 1 1872945584 5481904 6774464
14:27:10 11932 8192000000 10806154336 11228233728 1879094016 18.658 100 23 46 1 1890397056 4395280 6907760
14:27:32 5998 8192000000 10830798736 11249868800 1903433504 18.854 100 49 98 0 1927410880 10730688 13246688
14:27:45 14925 8192000000 10844287504 11257499648 1909214160 18.900 100 54 106 5 1932696816 7989680 15492976
14:28:07 3315 8192000000 10861908832 11270680576 1917255072 18.965 100 71 142 0 1950834064 14018144 19560848
14:28:22 36741 8192000000 10861696592 11279073280 1922226576 19.005 100 57 114 0 1952352864 14096256 16030032
14:29:05 10041 8192000000 10868619072 11280384000 1929050544 19.059 100 54 108 1 1956916176 12679328 15186304
14:29:23 30428 8192000000 10858186224 11279175680 1909039312 18.899 99 33 62 0 1928814480 10583808 9191360
14:30:00 26703 8192000000 10881538816 11298639872 1937873808 19.130 100 39 78 1 1960045296 10395920 11775568
14:30:35 59991 8192000000 10870748624 11309039616 1943462832 19.174 100 29 57 1 1963627488 11579008 8585648
14:31:58 27875 8192000000 10882884928 11314974720 1950092464 19.227 100 39 77 1 1974130960 12695136 11343360
14:32:34 28429 8192000000 10893898976 11325792256 1950937856 19.234 100 36 72 3 1975308960 13311856 11059248
14:33:15 20105 8192000000 10894243184 11330994176 1960327856 19.309 100 34 68 1 1984547856 13746304 10473696
14:33:43 17651 8192000000 10919395664 11347931136 1972850560 19.408 100 50 100 0 2007307632 19792400 14664672
14:34:09 4730 8192000000 10920075952 11351203840 1978110208 19.450 100 50 100 1 2009564304 16024736 15429360
14:34:26 4889 8192000000 10916436272 11347394560 1976585136 19.438 100 58 115 2 2011264096 17336544 17342416
14:34:38 9406 8192000000 10927361216 11355873280 1979505536 19.461 100 52 103 1 2014548464 18771872 16271056
14:34:55 5361 8192000000 10930013936 11356848128 1983119360 19.489 100 51 101 1 2016102992 18059792 14923840
14:35:07 30673 8192000000 10946285616 11371069440 1989386576 19.539 100 55 110 3 2031069360 25142048 16540736
14:35:47 6713 8192000000 10939776896 11366338560 1975275808 19.427 99 60 118 2 2014738656 20861456 18601392
14:36:06 9928 8192000000 10931287744 11367481344 1990006656 19.544 100 45 90 1 2023847360 19978400 13862304
14:36:26 13509 8192000000 10941462976 11379748864 1997130144 19.600 100 52 104 5 2033013824 19983840 15899840
14:36:50 8472 8192000000 10967229088 11385573376 2003274352 19.649 100 52 104 1 2040442640 21271616 15896672
14:37:06 9624 8192000000 10959987792 11394162688 2009179536 19.695 100 60 118 1 2051735536 24570704 17985296
14:37:35 10795 8192000000 10965902608 11395035136 2013046576 19.725 100 55 110 1 2052941552 23360160 16534816
14:37:58 5938 8192000000 10989206304 11403640832 2018024544 19.765 100 77 151 1 2067196064 25818384 23353136
14:38:12 3859 8192000000 10974758192 11405123584 2016419904 19.752 100 62 124 1 2060784016 25425696 18938416
14:38:24 3197 8192000000 10978847504 11405475840 2017193472 19.758 100 66 130 1 2063243936 25544304 20506160
14:38:36 9158 8192000000 10970482480 11399954432 2011358656 19.712 100 66 130 0 2058252448 27205296 19688496
14:38:54 7509 8192000000 10965234128 11391447040 1999757728 19.621 100 65 130 0 2050073408 30555616 19760064
14:39:10 8111 8192000000 10981113456 11400142848 2007805040 19.684 100 73 146 0 2061044224 31072928 22166256
14:39:30 6109 8192000000 10962141728 11394289664 1997641088 19.604 100 65 129 2 2051397392 34170944 19585360
14:39:44 8539 8192000000 10965694256 11396276224 2004077984 19.655 100 70 139 3 2056239312 30105856 22055472
14:40:01 16311 8192000000 10970356352 11400450048 2001828992 19.637 100 62 124 1 2056865232 35755008 19281232
14:40:31 19832 8192000000 10954924720 11391176704 1997011888 19.599 100 48 96 3 2045278864 32689648 15577328
14:40:58 15890 8192000000 10932299568 11381387264 1969310928 19.380 99 38 76 1 2013375776 32050272 12014576
14:41:27 9470 8192000000 10944876208 11381608448 1996642512 19.596 100 45 88 4 2039589296 28667856 14278928
14:41:46 5919 8192000000 10928664848 11358855168 1935856416 19.114 97 61 121 2 1982411408 27561440 18993552
14:42:00 10368 8192000000 10937970272 11370541056 1964825792 19.344 99 69 139 1 2014929824 28908016 21196016
14:42:21 6177 8192000000 10939847040 11368247296 1965182176 19.347 99 60 121 0 2011293184 27279360 18831648
14:42:36 8289 8192000000 10948402848 11378573312 1987736480 19.526 100 64 126 0 2033898208 27784064 18377664
14:42:53 8254 8192000000 10956207488 11387617280 1992303824 19.562 100 60 120 2 2039912976 29102288 18506864
14:43:12 4763 8192000000 10959993216 11394609152 1996206544 19.593 100 60 118 1 2045347312 30639920 18500848
14:43:24 2806 8192000000 10964541104 11388424192 1996471056 19.595 100 70 140 1 2045616272 26665840 22479376
14:43:34 2943 8192000000 10934526368 11362811904 1959094176 19.299 99 61 120 1 2005928864 27962688 18872000
14:43:47 6831 8192000000 10942060816 11372732416 1980557952 19.469 100 69 135 1 2030834960 29675344 20601664
14:44:01 4243 8192000000 10931403920 11360243712 1949197952 19.220 98 69 138 0 2000327504 29330032 21799520
14:44:14 3298 8192000000 10959165296 11384352768 1987178448 19.521 100 67 134 0 2037271984 29548176 20545360
14:44:26 5132 8192000000 10958102704 11390259200 1995503504 19.587 100 61 118 2 2045449280 31090912 18854864
14:44:39 2372 8192000000 10993149568 11405389824 2006654192 19.675 100 91 181 1 2067617744 33421712 27541840
14:44:50 1125 8192000000 10992776224 11404181504 2005044880 19.662 100 95 190 1 2068687568 34151856 29490832
14:44:58 2639 8192000000 10973580064 11387297792 1986484896 19.516 99 84 168 3 2049032832 35870912 26677024
14:45:13 3527 8192000000 10983900384 11406159872 2001782048 19.637 100 72 137 4 2057778640 34824384 21172208
14:45:25 6010 8192000000 10975517072 11397828608 2000602800 19.627 100 76 148 1 2058329568 34947792 22778976
14:45:40 1886 8192000000 10965635616 11380113408 1972669984 19.407 99 85 168 3 2035383792 36293280 26420528
14:45:51 4620 8192000000 10975779152 11394027520 1996167824 19.593 100 79 158 1 2059057104 38230304 24658976
14:46:05 4421 8192000000 10981455856 11398078464 1994825040 19.582 100 80 161 1 2059556560 39615264 25116256
14:46:17 3890 8192000000 10998838352 11413831680 2009367360 19.697 100 92 185 0 2078932448 41318496 28246592
14:46:27 3289 8192000000 10999525808 11415031808 2005116368 19.663 100 80 158 1 2072348880 42712432 24520080
14:46:39 1432 8192000000 10956522672 11362611200 1949920176 19.226 98 90 180 1 2018017952 40922672 27175104
14:46:47 1921 8192000000 10970799168 11384107008 1981327568 19.475 100 88 176 0 2053690944 44882272 27481104
14:46:58 1431 8192000000 10983193248 11390177280 1986999024 19.520 100 95 188 3 2060453360 44889840 28564496
14:47:06 1639 8192000000 10983228192 11391639552 1970971920 19.393 99 89 176 1 2044843504 46877040 26994544
14:47:17 1436 8192000000 10985165104 11395182592 1984875904 19.503 100 90 180 1 2062933840 48971136 29086800
14:47:30 16621 8192000000 10946764160 11393196032 1975292464 19.427 100 42 83 0 2037684352 47842048 14549840
14:47:58 9595 8192000000 10937945216 11373879296 1961127888 19.315 99 43 83 2 2014754624 39732240 13894496
14:48:16 13702 8192000000 10918572528 11359072256 1926572544 19.039 98 43 84 1 1981626000 40928992 14124464
14:48:42 13321 8192000000 10931850336 11379568640 1967733312 19.367 100 36 72 0 2017297312 37342064 12221936
14:49:09 8402 8192000000 10930849712 11364065280 1948157968 19.212 99 50 99 2 1998831520 34208800 16464752
14:49:27 7804 8192000000 10937555488 11372793856 1965088272 19.346 100 44 88 1 2017398000 37753392 14556336
14:49:46 13026 8192000000 10913113216 11356442624 1933314144 19.093 99 36 72 2 1983282864 37252848 12715872
14:50:15 7091 8192000000 10899403280 11336798208 1911522784 18.919 99 42 84 3 1967571152 41144608 14903760
14:50:32 18539 8192000000 10901328816 11342299136 1893356928 18.773 98 36 72 0 1954092800 47903072 12832800
14:51:14 8974 8192000000 10897507664 11354959872 1936510944 19.119 100 37 74 1 1995335504 46065184 12759376
14:51:33 18525 8192000000 10873842112 11323285504 1896077744 18.795 98 28 56 1 1941504432 35684704 9741984
14:52:08 14680 8192000000 10891392560 11337207808 1908094960 18.891 99 29 58 2 1957611184 39803632 9712592
14:52:29 12058 8192000000 10901814368 11343106048 1917103872 18.964 99 34 69 2 1968809344 40680512 11024960
14:52:47 12501 8192000000 10891602704 11334131712 1897479456 18.806 98 33 66 2 1949240416 41024576 10736384
14:53:06 29209 8192000000 10902842816 11354542080 1928711280 19.057 100 31 62 1 1983027216 43946368 10369568
14:53:47 37602 8192000000 10907969952 11334287360 1914946144 18.946 99 47 92 1 1962708320 32513376 15248800
14:54:32 15830 8192000000 10867741360 11326148608 1914539024 18.943 100 27 54 0 1956547568 33218976 8789568
14:55:20 41776 8192000000 10857033216 11326349312 1858963328 18.495 97 11 22 0 1894649904 31849600 3836976
14:56:08 87724 8192000000 10848830192 11308257280 1885505200 18.710 98 9 18 0 1906636448 18444256 2686992
14:57:43 26924 8192000000 10852418560 11284545536 1861104336 18.512 96 39 80 0 1878855280 7079536 10671408
14:58:36 71188 8192000000 10871052992 11323265024 1886876912 18.721 98 17 32 1 1903859296 11863760 5118624
15:00:11 88817 8192000000 10882255040 11344343040 1926554944 19.039 99 19 37 1 1951960160 20162704 5242512
15:01:46 63241 8192000000 10894386992 11322978304 1914657328 18.944 98 32 64 0 1936788352 12691408 9439616
15:02:56 23423 8192000000 10889213136 11334983680 1952787120 19.249 100 42 84 1 1977422448 13493024 11142304
15:03:45 70490 8192000000 10878680864 11338465280 1897173424 18.804 97 11 22 0 1912538032 12974992 2389616
15:05:02 105495 8192000000 10884296720 11346522112 1913248880 18.933 98 15 30 0 1928788688 11618576 3921232
15:06:54 64623 8192000000 10925842400 11355107328 1946667744 19.200 99 21 42 0 1959972528 7195552 6109232
15:08:05 136538 8192000000 10923596320 11374428160 1951413312 19.238 99 25 50 2 1966320304 7696896 7210096
15:10:36 22453 8192000000 10920326112 11376394240 1977190784 19.442 100 38 74 1 1998486864 10682560 10613520
15:11:05 53288 8192000000 10907562816 11386499072 1980254896 19.467 100 25 51 1 2001745664 14561232 6929536
15:12:05 47008 8192000000 10907835696 11382685696 1960745776 19.312 99 8 16 0 1977427952 14270048 2412128
15:12:59 6201 8192000000 10912251200 11379224576 1980620640 19.470 100 18 36 1 1999576096 13515056 5440400
15:14:08 32703 8192000000 10933733184 11400462336 2003291808 19.649 100 46 90 3 2023861184 7646272 12923104
15:14:48 60298 8192000000 10924605168 11409121280 1993533024 19.572 100 30 60 0 2016178864 13490192 9155648
15:15:55 112000 8192000000 10926654256 11408609280 1990510784 19.548 100 9 18 1 2008842640 15897776 2434080
15:17:53 59727 8192000000 10928595920 11417174016 1995832144 19.590 100 9 18 0 2015160944 16324256 3004544
15:19:15 82523 8192000000 10926441248 11413815296 1985154800 19.505 99 22 44 0 2011141744 18933504 7053440
15:20:49 43698 8192000000 10902587808 11388026880 1947617856 19.208 98 21 43 2 1966014176 12032912 6363408
15:21:42 38764 8192000000 10904381168 11396661248 1967965840 19.369 99 12 24 1 1983509616 11994832 3548944
15:22:28 76765 8192000000 10893569696 11383144448 1949659312 19.224 98 12 25 1 1962562288 9253616 3649360
15:23:51 66667 8192000000 10892186560 11376590848 1915163616 18.948 97 11 22 0 1927100480 8780656 3156208
15:25:04 67588 8192000000 10907212560 11385540608 1956220512 19.276 99 13 26 1 1970468096 11024272 3223312
15:26:18 77052 8192000000 10927578320 11393699840 1974118912 19.418 99 20 38 3 1990522848 11477264 4926672
15:27:44 17485 8192000000 10899557824 11359043584 1926817568 19.041 97 37 72 0 1943708176 7497568 9393040
15:28:07 25954 8192000000 10908501280 11369451520 1936916672 19.122 98 40 80 1 1962871024 15319136 10635216
15:29:32 74718 8192000000 10911051264 11383631872 1931427456 19.078 98 13 26 0 1961607616 26504944 3675216
15:30:56 56757 8192000000 10909627552 11378040832 1909633520 18.904 96 18 36 1 1924684912 10341824 4709568
15:31:59 66938 8192000000 10898834256 11360108544 1886676016 18.719 96 13 26 0 1902518672 12429744 3412912
15:33:13 67072 8192000000 10874114384 11341295616 1861935904 18.519 95 13 26 0 1881267536 15392608 3939024
15:34:27 59195 8192000000 10873640256 11346444288 1896931216 18.802 97 20 40 2 1916482032 13718128 5832688
15:35:32 84909 8192000000 10906331936 11356897280 1883137008 18.690 96 18 36 1 1897967072 9704112 5125952
15:37:03 24770 8192000000 10909685440 11364376576 1947059056 19.203 99 36 72 0 1968591488 11333520 10198912
15:37:36 29050 8192000000 10900517376 11365629952 1942747456 19.169 99 34 68 1 1965819264 13922112 9149696
15:38:23 98438 8192000000 10865350448 11345403904 1909025440 18.899 97 32 64 1 1929103408 10715008 9362960
15:40:14 63280 8192000000 10836822880 11300159488 1813774048 18.127 93 29 58 0 1831941920 11054512 7113360
15:42:34 89742 8192000000 10877648400 11352174592 1923159968 19.012 99 14 28 3 1938663408 11363872 4139568
15:44:10 70522 8192000000 10855161936 11339558912 1911112112 18.916 98 16 32 2 1928417952 12550448 4755392
15:45:37 65215 8192000000 10868201584 11335987200 1935141712 19.108 100 20 41 0 1948703712 7647584 5914416
15:46:54 82204 8192000000 10889931456 11356872704 1955839136 19.273 100 22 44 2 1971611184 9063008 6709040
15:48:40 44741 8192000000 10865278480 11344424960 1913797808 18.937 98 12 24 1 1930464336 13267520 3399008
15:49:36 63434 8192000000 10838039680 11314593792 1859497408 18.499 96 15 30 0 1873774816 9194256 5083152
15:50:49 50755 8192000000 10867301632 11325931520 1873258240 18.611 97 18 36 0 1887100592 8207552 5634800
15:51:50 62281 8192000000 10865971232 11331964928 1896443920 18.798 98 19 38 3 1915142832 13382832 5316080
15:52:59 54121 8192000000 10861952128 11344400384 1928109168 19.052 100 33 64 4 1955898512 18618768 9170576
15:54:09 71782 8192000000 10876387920 11330625536 1914970608 18.947 99 13 26 0 1933017200 14879936 3166656
15:55:28 29790 8192000000 10873888544 11328733184 1901034528 18.835 98 27 54 0 1919655296 11484848 7135920
15:56:07 55664 8192000000 10842108048 11313487872 1859773488 18.501 96 24 48 2 1881388928 14675232 6940208
15:57:09 58240 8192000000 10854060976 11321323520 1891995008 18.762 98 13 26 0 1909831632 14409504 3427120
15:58:14 56037 8192000000 10888108064 11356790784 1946615184 19.200 100 13 26 0 1968047920 17921680 3511056
15:59:24 43341 8192000000 10905044464 11360677888 1944627280 19.184 99 17 34 0 1960803040 11659072 4516688
16:00:17 97768 8192000000 10901417936 11375464448 1937932880 19.130 98 18 37 0 1951269968 8807744 4529344
16:02:01 70498 8192000000 10909327776 11378618368 1945593216 19.191 98 17 34 1 1958010400 7669968 4747216
16:03:47 63726 8192000000 10908857712 11383681024 1968225232 19.371 99 30 60 0 1985265472 8208528 8831712
16:04:59 66720 8192000000 10902313872 11383996416 1963655616 19.335 99 7 14 1 1974290416 8727808 1906992
16:06:14 31973 8192000000 10899451888 11387899904 1982193552 19.482 100 3 6 0 1991312016 8509472 608992
16:06:54 59354 8192000000 10900158672 11390038016 1963677216 19.335 99 6 12 0 1973700976 8544640 1479120
16:07:59 40308 8192000000 10918657360 11378827264 1950425552 19.230 98 32 64 2 1966157728 6493120 9239056
16:09:07 62474 8192000000 10893111072 11376443392 1940083216 19.147 98 11 22 0 1952612528 9718528 2810784
16:10:22 82833 8192000000 10900609184 11373555712 1938994528 19.139 98 11 22 0 1951510976 9320896 3195552
16:12:06 77832 8192000000 10908366320 11401777152 1946097712 19.195 98 13 25 1 1963904416 14134640 3672064
16:13:33 129311 8192000000 10899199312 11384705024 1898750016 18.816 96 10 19 0 1911543968 10373904 2420048
16:16:03 68252 8192000000 10911553856 11379499008 1945496800 19.191 98 26 52 1 1960168464 7506752 7164912
16:17:18 35558 8192000000 10918637648 11371212800 1941269232 19.157 98 21 42 0 1955157408 8049760 5838416
16:18:01 39827 8192000000 10905876064 11366088704 1936551872 19.119 98 34 68 0 1955900576 9893472 9455232
16:18:47 19880 8192000000 10904885088 11365298176 1939322816 19.141 98 34 68 2 1962189360 13646080 9220464
16:19:15 78914 8192000000 10887842704 11370876928 1929175488 19.060 98 19 38 0 1946880080 11976448 5728144
16:20:47 113494 8192000000 10890744720 11357925376 1820283248 18.180 92 17 34 0 1844031936 18918592 4830096
16:22:49 144538 8192000000 10881395776 11345850368 1847734400 18.404 94 15 30 0 1859150288 6959248 4456640
16:25:23 63332 8192000000 10875946448 11342954496 1924908016 19.026 99 27 53 3 1941629744 8507184 8214544
16:26:33 26968 8192000000 10867998064 11335000064 1908121520 18.892 98 17 34 2 1921673648 8789120 4763008
16:27:06 11323 8192000000 9498206448 9842315264 505996304 5.817 27 4 8 0 509165296 2133248 1035744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 21-01-2021 16:28:54 to 21-01-2021 16:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 124 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          242505
MON$OLDEST_ACTIVE               242506
MON$OLDEST_SNAPSHOT             242506
MON$NEXT_TRANSACTION            242506
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                       2052960
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:178: 
:179: mscs-test-161.budzdorov.ru    Thu Jan 21 16:27:19 2021
:180:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:181: 
--- end of diff output ---

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

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