Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.11.2020 16:27
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 17266136 kB
MemAvailable 31469564 kB
Buffers 0 kB
Cached 14387748 kB
SwapCached 2888 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-01 16:27:01
DTS_END                         2020-11-01 16:27:01.2350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42758
TRN_ID                          244879
ATT_ID                          669
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: 9531.41 18649 1143769
customer order: creation 176.46 315 21175
customer order: refuse 15.97 341 1916
order to supplier: creation 46.03 1236 5523
order to supplier: removal 3.62 98128 434
invoice (draft): creation 46.28 3228 5553
invoice (draft): removal 54.84 860 6581
invoice accept: apply 42.77 17784 5132
invoice accept: cancel 49.42 757 5930
customer reserve: creation 3909.76 178 469171
customer reserve: removal 4894.85 55 587382
realization accept: apply 85.71 174 10285
realization accept: cancel 74.46 114 8935
payment from customer: creation 60.06 118 7207
payment from customer: removal 5.94 90 713
payment to supplier: creation 49.37 146 5924
payment to supplier: removal 3.53 69 424
service: total inventory turnovers 4.71 916 565
service: total monetary turnovers 6.71 32 805
service: aggregate perf. data 0.92 19781 110
service: refresh index statistics 0.03 228648 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-11-2020 16:28:04 to 01-11-2020 16:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8389
TEST_TIME 2 5129
TEST_TIME 3 4771
TEST_TIME 4 5132
TEST_TIME 5 5409
TEST_TIME 6 5610
TEST_TIME 7 5570
TEST_TIME 8 6253
TEST_TIME 9 6239
TEST_TIME 10 6345
TEST_TIME 11 6373
TEST_TIME 12 6682
TEST_TIME 13 6956
TEST_TIME 14 7336
TEST_TIME 15 7518
TEST_TIME 16 7830
TEST_TIME 17 7844
TEST_TIME 18 8407
TEST_TIME 19 8425
TEST_TIME 20 8590
TEST_TIME 21 8529
TEST_TIME 22 8829
TEST_TIME 23 9358
TEST_TIME 24 9500
TEST_TIME 25 9510
TEST_TIME 26 10022
TEST_TIME 27 10751
TEST_TIME 28 10696
TEST_TIME 29 11348
TEST_TIME 30 11578
TEST_TIME 31 11481
TEST_TIME 32 11228
TEST_TIME 33 11403
TEST_TIME 34 11252
TEST_TIME 35 11267
TEST_TIME 36 11069
TEST_TIME 37 10776
TEST_TIME 38 10801
TEST_TIME 39 10702
TEST_TIME 40 10622
TEST_TIME 41 10544
TEST_TIME 42 10454
TEST_TIME 43 10288
TEST_TIME 44 10623
TEST_TIME 45 10559
TEST_TIME 46 10438
TEST_TIME 47 10386
TEST_TIME 48 10246
TEST_TIME 49 10171
TEST_TIME 50 10151
TEST_TIME 51 10104
TEST_TIME 52 10101
TEST_TIME 53 10061
TEST_TIME 54 9989
TEST_TIME 55 10036
TEST_TIME 56 9980
TEST_TIME 57 9894
TEST_TIME 58 9864
TEST_TIME 59 9813
TEST_TIME 60 9818
TEST_TIME 61 9883
TEST_TIME 62 9904
TEST_TIME 63 9872
TEST_TIME 64 9963
TEST_TIME 65 9995
TEST_TIME 66 9971
TEST_TIME 67 9972
TEST_TIME 68 10093
TEST_TIME 69 10043
TEST_TIME 70 9998
TEST_TIME 71 10056
TEST_TIME 72 10135
TEST_TIME 73 10163
TEST_TIME 74 10136
TEST_TIME 75 10062
TEST_TIME 76 10013
TEST_TIME 77 9944
TEST_TIME 78 9955
TEST_TIME 79 9945
TEST_TIME 80 9880
TEST_TIME 81 9839
TEST_TIME 82 9823
TEST_TIME 83 9771
TEST_TIME 84 9733
TEST_TIME 85 9658
TEST_TIME 86 9726
TEST_TIME 87 9697
TEST_TIME 88 9701
TEST_TIME 89 9692
TEST_TIME 90 9653
TEST_TIME 91 9679
TEST_TIME 92 9705
TEST_TIME 93 9801
TEST_TIME 94 9774
TEST_TIME 95 9807
TEST_TIME 96 9845
TEST_TIME 97 9837
TEST_TIME 98 9847
TEST_TIME 99 9830
TEST_TIME 100 9849
TEST_TIME 101 9896
TEST_TIME 102 9852
TEST_TIME 103 9811
TEST_TIME 104 9829
TEST_TIME 105 9774
TEST_TIME 106 9758
TEST_TIME 107 9735
TEST_TIME 108 9692
TEST_TIME 109 9656
TEST_TIME 110 9610
TEST_TIME 111 9601
TEST_TIME 112 9563
TEST_TIME 113 9566
TEST_TIME 114 9568
TEST_TIME 115 9573
TEST_TIME 116 9557
TEST_TIME 117 9559
TEST_TIME 118 9605
TEST_TIME 119 9614
TEST_TIME 120 9534

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-11-2020 16:28:07 to 01-11-2020 16:28:11.

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 1578741 1578741 0 0.00 0 26963 7 0 0
doc_list_biud 1578740 1578740 0 0.00 0 74985 27 0 0
sp_add_invoice_to_stock 5304 5132 172 3.24 29 162770 17784 0 172
sp_cancel_adding_invoice 5930 5930 0 0.00 3 64861 757 0 0
sp_cancel_client_order 1916 1916 0 0.00 4 19598 342 0 0
sp_cancel_customer_reserve 587382 587382 0 0.00 1 15379 56 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 2 4933 90 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 3045 69 0 0
sp_cancel_supplier_invoice 6601 6581 20 0.30 2 75001 860 0 20
sp_cancel_supplier_order 434 434 0 0.00 7 1136084 98129 0 0
sp_cancel_write_off 8935 8935 0 0.00 1 7093 115 0 0
sp_client_order 21175 21175 0 0.00 3 23063 315 0 0
sp_customer_reserve 469171 469171 0 0.00 0 42943 179 0 0
sp_fill_shopping_cart 32250 32250 0 0.00 1 9537 34 0 0
sp_fill_shopping_cart_clo_res 469162 469162 0 0.00 0 18787 13 0 0
sp_get_clo_for_invoice 5123 5123 0 0.00 0 27752 263 0 0
sp_kill_cost_storno 16002 16002 0 0.00 0 12660 58 0 0
sp_kill_qstorno_ret_qs2qd 1190714 1190714 0 0.00 0 74976 31 0 0
sp_kill_qty_storno 626585 626585 0 0.00 0 74981 66 0 0
sp_lock_selected_doc 21361 21361 0 0.00 0 6239 4 0 0
sp_make_cost_storno 28539 28539 0 0.00 0 16292 60 0 0
sp_multiply_rows_for_pdistr 28538 28538 0 0.00 0 12872 29 0 0
sp_multiply_rows_for_qdistr 21175 21175 0 0.00 0 17743 148 0 0
sp_pay_from_customer 7207 7207 0 0.00 4 11979 119 0 0
sp_pay_to_supplier 5924 5924 0 0.00 5 17190 147 0 0
sp_payment_common 13131 13131 0 0.00 1 16350 39 0 0
sp_qd_handle_on_cancel_clo 1916 1916 0 0.00 0 19588 312 0 0
sp_qd_handle_on_invoice_upd_sts 11052 11052 0 0.00 0 27851 324 0 0
sp_qd_handle_on_reserve_upd_sts 10285 10285 0 0.00 0 11756 46 0 0
sp_reserve_write_off 10285 10285 0 0.00 6 14249 175 0 0
sp_supplier_invoice 5553 5553 0 0.00 7 120911 3228 0 0
sp_supplier_order 5523 5523 0 0.00 5 42796 1236 0 0
srv_aggregate_perf_data 110 110 0 0.00 3168 373321 19781 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1054 141475 30234 0 0
srv_find_qd_qs_mism 1095530 1095530 0 0.00 0 26953 6 0 0
srv_make_invnt_saldo 565 565 0 0.00 36 36428 916 0 0
srv_make_money_saldo 805 805 0 0.00 0 5727 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 135957 323752 228649 0 0
t$perf-abend:sp_add_invoice_to_stock 172 172 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 20 20 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5132 5132 0 0.00 0 7550 148 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 1 4097 104 0 0
t$perf-norm:sp_cancel_client_order 1916 1916 0 0.00 0 2801 14 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 7510 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 546 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 216 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 2687 24 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 21647 1534 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 3164 6 0 0
t$perf-norm:sp_client_order 21175 21175 0 0.00 0 12992 17 0 0
t$perf-norm:sp_customer_reserve 1018 1018 0 0.00 0 2242 8 0 0
t$perf-norm:sp_pay_from_customer 7207 7207 0 0.00 0 5645 7 0 0
t$perf-norm:sp_pay_to_supplier 5924 5924 0 0.00 0 6613 9 0 0
t$perf-norm:sp_reserve_write_off 10285 10285 0 0.00 0 7028 9 0 0
t$perf-norm:sp_supplier_invoice 5553 5553 0 0.00 0 4619 20 0 0
t$perf-norm:sp_supplier_order 5523 5523 0 0.00 0 16453 18 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 125 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 305 4 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 12066 43 0 0
t$perf-norm:srv_make_money_saldo 805 805 0 0.00 0 1060 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10588 10244 344 3.24 0 4818 17 0 344
v_all_customers 37948 37948 0 0.00 0 20 1 0 0
v_all_suppliers 30610 30610 0 0.00 0 68 1 0 0
v_all_wares 42350 42350 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 4299 14 0 0
v_cancel_client_order 3832 3832 0 0.00 0 3397 7 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 1564 5 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 1433 7 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 486 4 0 0
v_cancel_supplier_invoice 858 818 40 4.66 0 602 14 0 40
v_cancel_supplier_order 868 868 0 0.00 0 2194 8 0 0
v_cancel_write_off 1980 1980 0 0.00 0 2692 13 0 0
v_max_id_clo_ord 5523 5523 0 0.00 0 1832 2 0 0
v_max_id_clo_res 1018 1018 0 0.00 0 1274 14 0 0
v_max_id_ord_sup 5551 5551 0 0.00 0 5791 7 0 0
v_max_non_paid_invoice 1693 1693 0 0.00 0 531 3 0 0
v_max_non_paid_realizn 4002 4002 0 0.00 0 3340 5 0 0
v_min_id_clo_ord 5523 5523 0 0.00 0 4236 11 0 0
v_min_id_clo_res 1018 1018 0 0.00 0 13877 18 0 0
v_min_id_ord_sup 5551 5551 0 0.00 0 6251 5 0 0
v_min_non_paid_invoice 5924 5924 0 0.00 0 16344 31 0 0
v_min_non_paid_realizn 7207 7207 0 0.00 0 11322 28 0 0
v_our_firm 10812 10812 0 0.00 0 27 1 0 0
v_reserve_write_off 20570 20570 0 0.00 0 2713 6 0 0
x_lock_depdocs_on_canc_invoice 12102 12102 0 0.00 0 15025 117 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 14417 351 0 0
x_make_qstorno_1000_1200 5523 5523 0 0.00 1 42730 1153 0 0
x_make_qstorno_1200_2000 5553 5553 0 0.00 3 115458 3122 0 0
x_make_qstorno_2100_3300 469171 469171 0 0.00 0 42926 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-11-2020 16:28:12 to 01-11-2020 16:28:16.

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:04 1 8192000000 8798422528 8808923136 5084624 0.062 1 1 2 0 5202672 55488 62560
13:57:11 20610 8192000000 10257960992 10570289152 865389088 9.554 67 52 106 0 885298144 2230352 17678704
13:57:41 29499 8192000000 10353771888 10668523520 1391759696 14.522 100 92 184 0 1426535184 4767024 30008464
13:58:18 29841 8192000000 10374960112 10700582912 1430130064 14.862 100 92 184 0 1466584416 6327232 30127120
13:58:56 34988 8192000000 10406631920 10735333376 1452798064 15.063 100 87 174 0 1488625712 7284736 28542912
13:59:41 23515 8192000000 10423450880 10753462272 1476332384 15.269 100 87 174 0 1513094080 8255680 28506016
14:00:17 12957 8192000000 10444821968 10777440256 1494607808 15.429 100 85 170 0 1530781216 8603344 27570064
14:00:41 16379 8192000000 10464100720 10802794496 1513821456 15.597 100 84 168 1 1549135344 8878768 26435120
14:01:07 8767 8192000000 10471997776 10819735552 1530301984 15.740 100 71 142 1 1561260480 9056544 21901952
14:01:27 14761 8192000000 10523346352 10874499072 1568394528 16.068 100 67 133 3 1597642336 8991968 20255840
14:01:54 6224 8192000000 10550391392 10903588864 1610140640 16.426 100 84 168 0 1645958272 10588608 25229024
14:02:18 14297 8192000000 10581085904 10940743680 1630657344 16.600 100 86 172 2 1668122704 11586816 25878544
14:02:40 11758 8192000000 10591991008 10956419072 1643186016 16.707 100 73 146 0 1677264512 12374656 21703840
14:03:02 8598 8192000000 10604502768 10973155328 1663979584 16.882 100 75 150 0 1698711760 12701040 22031136
14:03:17 10835 8192000000 10632760336 11001290752 1683803120 17.049 100 73 146 0 1717232624 12026784 21402720
14:03:37 10666 8192000000 10652377056 11023597568 1703593280 17.215 100 81 163 0 1739854864 12628896 23632688
14:03:56 6558 8192000000 10664751536 11038085120 1721565088 17.365 100 76 152 1 1756546176 12867040 22114048
14:04:13 5198 8192000000 10679244768 11055058944 1739757888 17.517 100 78 155 0 1774791776 12930400 22103488
14:04:25 4451 8192000000 10689562768 11067596800 1751835456 17.617 100 83 167 0 1788405232 12727648 23842128
14:04:37 4369 8192000000 10689366528 11074035712 1762963248 17.709 100 84 168 2 1800157312 13216048 23978016
14:04:49 6736 8192000000 10714062784 11091079168 1769206752 17.760 100 81 158 3 1803954160 12989024 21758384
14:05:03 4013 8192000000 10712278480 11097665536 1775806352 17.815 100 78 154 2 1810046112 12258848 21980912
14:05:14 5769 8192000000 10723876368 11109462016 1787421680 17.911 100 79 158 2 1821967712 12612752 21933280
14:05:26 3405 8192000000 10734696528 11115520000 1796776400 17.987 100 89 175 0 1834070176 13375728 23918048
14:05:36 3892 8192000000 10739879472 11123781632 1801132176 18.023 100 92 184 0 1840275328 14030784 25112368
14:05:47 3337 8192000000 10753116512 11136454656 1805445392 18.059 100 78 155 1 1840827408 13884992 21497024
14:05:58 6538 8192000000 10754942240 11142184960 1813410880 18.124 100 82 162 2 1850105680 14109920 22584880
14:06:12 5330 8192000000 10767389696 11154993152 1820250896 18.180 100 73 145 1 1852271616 12342432 19678288
14:06:24 2784 8192000000 10779368432 11169959936 1834384752 18.295 100 85 170 4 1870783312 12724608 23673952
14:06:34 1788 8192000000 10779232336 11167199232 1838975184 18.332 100 92 183 2 1877606832 13683168 24948480
14:06:42 1860 8192000000 10784263632 11176054784 1842525200 18.361 100 88 176 0 1882028256 14661296 24841760
14:06:51 1595 8192000000 10792681680 11177537536 1843302240 18.368 100 92 184 3 1883608112 14183728 26122144
14:06:59 1946 8192000000 10778423024 11173765120 1845351824 18.384 100 85 171 0 1883625696 13885696 24388176
14:07:07 1284 8192000000 10789002864 11176706048 1845246352 18.383 100 83 165 2 1881299376 12110640 23942384
14:07:15 2415 8192000000 10788528240 11183439872 1848762512 18.412 100 89 178 2 1886618176 11578608 26277056
14:07:23 1295 8192000000 10793439632 11182190592 1853937200 18.454 100 91 180 3 1892443648 12927088 25579360
14:07:31 1860 8192000000 10798064704 11190657024 1857741456 18.485 100 90 180 1 1896111312 12710256 25659600
14:07:40 1891 8192000000 10817234656 11206012928 1863964112 18.535 100 96 192 2 1904746912 13437024 27345776
14:07:48 1347 8192000000 10816625584 11204972544 1868074480 18.569 100 90 180 1 1906827136 13891056 24861600
14:07:56 1194 8192000000 10817135056 11203178496 1871056896 18.593 100 96 194 2 1910996112 12458368 27480848
14:08:03 1946 8192000000 10816874720 11205955584 1868744048 18.574 100 94 185 0 1907834400 13052192 26038160
14:08:11 1182 8192000000 10814383296 11206508544 1870419008 18.588 100 86 172 0 1908381408 12887360 25075040
14:08:19 7623 8192000000 10783770480 11202035712 1871278288 18.595 100 51 102 3 1895688656 10564224 13846144
14:08:34 33349 8192000000 10809202784 11213697024 1870872048 18.591 100 59 119 3 1895160000 8307200 15980752
14:09:14 9348 8192000000 10779068720 11206619136 1865820576 18.550 100 24 48 1 1880415984 8130192 6465216
14:09:32 4146 8192000000 10784252848 11207958528 1873204848 18.610 100 39 76 2 1890554160 5676672 11672640
14:09:44 8620 8192000000 10778914992 11212050432 1871233072 18.594 100 12 24 0 1880055360 5624064 3198224
14:10:01 8140 8192000000 10783053568 11216375808 1876365760 18.636 100 23 46 1 1889496560 7132176 5998624
14:10:15 6919 8192000000 10786105040 11217731584 1877763840 18.647 100 28 57 0 1891891808 6485552 7642416
14:10:31 5912 8192000000 10787532576 11218853888 1876903856 18.640 100 23 46 2 1890193312 5789568 7499888
14:10:43 10866 8192000000 10788525760 11223318528 1878710784 18.655 100 15 31 0 1893583216 10706304 4166128
14:11:04 16795 8192000000 10782047600 11219484672 1879977728 18.665 100 22 41 1 1892210576 6726336 5506512
14:11:31 7361 8192000000 10791414176 11224166400 1879455776 18.661 100 17 34 1 1894804528 10866688 4482064
14:11:44 11591 8192000000 10790122016 11227615232 1884425552 18.701 100 15 30 2 1893919200 5587632 3906016
14:12:02 12661 8192000000 10798381040 11230879744 1885774416 18.712 100 20 37 4 1896583888 5722528 5086944
14:12:24 12570 8192000000 10803157904 11233341440 1889971376 18.746 100 12 24 0 1898206864 5286128 2949360
14:12:44 9372 8192000000 10809661824 11237113856 1898126688 18.811 100 42 83 2 1916912816 5620560 13165568
14:13:02 61441 8192000000 10828009888 11250356224 1898852288 18.817 100 37 74 3 1915807424 6045328 10909808
14:14:10 11998 8192000000 10810715648 11250429952 1899292768 18.821 100 30 59 2 1916267104 7643008 9331328
14:14:29 8027 8192000000 10824481488 11255885824 1899286368 18.821 100 24 47 0 1911857888 5640800 6930720
14:14:43 6877 8192000000 10832015392 11261186048 1909047504 18.899 100 30 61 0 1923934736 5823056 9064176
14:14:57 6785 8192000000 10822723424 11250360320 1899890000 18.825 100 28 55 3 1913871328 6290256 7691072
14:15:11 6224 8192000000 10813199600 11250065408 1897958448 18.810 100 21 42 1 1910331568 6326576 6046544
14:15:24 5432 8192000000 10819788992 11244015616 1881345520 18.676 99 24 50 1 1894177856 5726960 7105376
14:15:38 7940 8192000000 10829754784 11255144448 1902376704 18.845 100 38 74 1 1919369040 6133760 10858576
14:15:56 9935 8192000000 10809057552 11248975872 1866265424 18.554 98 22 44 0 1878936080 5857728 6812928
14:16:14 7539 8192000000 10815871536 11244036096 1864135728 18.537 98 24 48 1 1877893200 6502352 7255120
14:16:28 5138 8192000000 10792490848 11215417344 1822302896 18.197 96 28 56 1 1836664912 6101792 8260224
14:16:39 8710 8192000000 10779965952 11215552512 1840269392 18.343 98 14 28 0 1849945088 5503104 4172592
14:16:56 7121 8192000000 10751160208 11174580224 1787939424 17.915 95 21 42 1 1799360048 5310560 6110064
14:17:10 9507 8192000000 10745058880 11176185856 1793398832 17.960 97 18 32 4 1804075296 5647536 5028928
14:17:31 7264 8192000000 10713994480 11133370368 1784550992 17.887 97 19 38 0 1796321664 5383936 6386736
14:17:44 16640 8192000000 10698119696 11117686784 1644503872 16.718 91 11 22 0 1652346944 5179520 2663552
14:18:12 54843 8192000000 10716201792 11097366528 1691491376 17.114 93 51 103 2 1711656272 5008832 15156064
14:19:13 8027 8192000000 10698760752 11115786240 1783921696 17.882 99 30 60 0 1799424624 7515424 7987504
14:19:27 10029 8192000000 10733966896 11139076096 1774538848 17.804 98 35 70 1 1790458416 5212496 10707072
14:19:44 6699 8192000000 10722995504 11140313088 1791194240 17.942 99 26 52 0 1804661232 6216336 7250656
14:19:58 5642 8192000000 10729526880 11146534912 1786254064 17.901 98 30 62 4 1801506464 6485536 8766864
14:20:12 9682 8192000000 10740452064 11151007744 1771974384 17.783 97 36 73 1 1787113936 5272752 9866800
14:20:28 5053 8192000000 10746668432 11159781376 1821422672 18.189 100 43 87 0 1841614144 7244256 12947216
14:20:42 9259 8192000000 10717323584 11129483264 1757690672 17.665 97 33 66 1 1772778624 5213712 9874240
14:20:58 8121 8192000000 10740917904 11150364672 1805305728 18.057 100 26 50 4 1822646400 9681056 7659616
14:21:14 5348 8192000000 10734030976 11154837504 1818664176 18.167 100 20 40 1 1829755344 4864416 6226752
14:21:27 14545 8192000000 10737247344 11159736320 1819156320 18.171 99 20 40 2 1830432512 5937216 5338976
14:21:47 8118 8192000000 10734567840 11157852160 1801768256 18.028 98 19 38 3 1812509808 5841952 4899600
14:22:04 6750 8192000000 10740902640 11165077504 1826667264 18.232 100 23 45 1 1838868928 5513872 6687792
14:22:17 15428 8192000000 10752885552 11180429312 1838932096 18.332 100 20 36 2 1848946144 4630960 5383088
14:22:39 9569 8192000000 10744001152 11175038976 1820887936 18.185 99 12 24 0 1830177696 6090912 3198848
14:22:56 66287 8192000000 10757759920 11191549952 1843324992 18.368 100 25 50 0 1855503424 4947344 7231088
14:24:09 9814 8192000000 10759097072 11189477376 1835123472 18.301 99 29 58 1 1849134784 5952944 8058368
14:24:25 9741 8192000000 10780301248 11200704512 1858065968 18.488 100 32 63 3 1873804624 6608864 9129792
14:24:44 2571 8192000000 10799079520 11213029376 1869119184 18.577 100 50 98 0 1892122944 7736432 15267328
14:24:57 6012 8192000000 10772732576 11206025216 1864171504 18.537 100 30 58 2 1878124576 5143920 8809152
14:25:11 5785 8192000000 10786663408 11213426688 1868629984 18.573 100 37 74 2 1886530384 7391856 10508544
14:25:26 7053 8192000000 10784339072 11209986048 1869763344 18.582 100 34 68 2 1885484880 5394496 10327040
14:25:46 11619 8192000000 10780031568 11218829312 1872693312 18.606 100 26 52 1 1886407840 5683376 8031152
14:26:04 6117 8192000000 10793382928 11221934080 1874919040 18.624 100 15 30 1 1884137344 4965056 4253248
14:26:17 10620 8192000000 10795279632 11227123712 1876490752 18.637 100 23 46 1 1888572720 5198720 6883248
14:26:36 10574 8192000000 10809085232 11234648064 1881390896 18.676 100 20 40 2 1892143776 5382256 5370624
14:26:52 14663 8192000000 10819889648 11241537536 1887850624 18.728 100 19 37 2 1899331616 5336208 6144784
14:27:15 30901 8192000000 10830310864 11256913920 1913003440 18.931 100 33 66 1 1928207136 5187664 10016032
14:28:02 25803 8192000000 10853043296 11279011840 1924488848 19.023 100 32 63 1 1942240240 8628496 9122896
14:28:35 27996 8192000000 10864937056 11291541504 1932940400 19.090 100 36 73 1 1952407472 8632080 10834992
14:29:10 79286 8192000000 10881450432 11308494848 1946452608 19.198 100 51 97 2 1970566432 10549824 13564000
14:30:52 24717 8192000000 10882288624 11317481472 1954377488 19.261 100 40 77 3 1978051920 12682576 10991856
14:31:26 42118 8192000000 10877182160 11312152576 1916103120 18.956 98 30 59 0 1936092352 11575552 8413680
14:32:18 3711 8192000000 10901241200 11326840832 1960264256 19.308 100 52 101 3 1988814832 13279744 15270832
14:32:30 17930 8192000000 10902461056 11338706944 1963926096 19.337 100 43 83 0 1993775312 18094288 11754928
14:33:03 28393 8192000000 10911563792 11352735744 1978484416 19.453 100 38 76 0 2008834608 19118688 11231504
14:33:39 8065 8192000000 10935305344 11364155392 1989653824 19.541 100 50 100 1 2024324544 20728592 13942128
14:33:58 4179 8192000000 10946869120 11371139072 1993887808 19.575 100 66 131 1 2035014432 22168912 18957712
14:34:10 5898 8192000000 10943650928 11370008576 1992222272 19.561 100 58 116 0 2032321168 23374144 16724752
14:34:25 5142 8192000000 10952366368 11374821376 1994557936 19.580 100 63 126 1 2036537600 23751440 18228224
14:34:40 6750 8192000000 10929142608 11355656192 1973052992 19.410 99 62 124 2 2020048800 28125072 18870736
14:34:58 8532 8192000000 10942922640 11369578496 1990984480 19.552 100 74 143 3 2038218784 25791360 21442944
14:35:18 7446 8192000000 10947870256 11370807296 1994486688 19.579 100 59 118 0 2037640576 25842864 17311024
14:35:34 4392 8192000000 10967539312 11385634816 2003150608 19.648 100 75 150 1 2052710832 27201184 22359040
14:35:45 5802 8192000000 10960783744 11378221056 1999197696 19.616 100 84 168 1 2048270112 23913920 25158496
14:35:58 4343 8192000000 10935399952 11355676672 1973299408 19.412 99 63 126 1 2014516944 22945808 18271728
14:36:09 5624 8192000000 10952285056 11374698496 1996007568 19.591 100 73 146 1 2040640752 23254944 21378240
14:36:22 4268 8192000000 10947113408 11363557376 1980096768 19.465 99 76 148 1 2025384416 23303728 21983920
14:36:38 8426 8192000000 10956207264 11375640576 1996147392 19.592 100 71 141 0 2039485760 23540016 19798352
14:36:56 9710 8192000000 10961020528 11383959552 2003582848 19.651 100 64 127 1 2049224096 26407856 19233392
14:37:20 9166 8192000000 10963699776 11389206528 2004561920 19.659 100 70 140 1 2052606192 27611136 20433136
14:37:40 4613 8192000000 10938384800 11360862208 1964949536 19.345 99 67 132 2 2014897456 30604704 19343216
14:37:51 3596 8192000000 10936369632 11360129024 1981308080 19.475 100 62 121 4 2026007984 25734016 18965888
14:38:01 7810 8192000000 10923538720 11346309120 1941904192 19.162 98 68 132 1 1990525920 28372512 20249216
14:38:18 1876 8192000000 10925780832 11337490432 1931701120 19.080 98 81 160 2 1985250816 29488496 24061200
14:38:27 1685 8192000000 10935345392 11343319040 1951165296 19.236 99 84 168 2 2007768064 31441968 25160800
14:38:36 3177 8192000000 10927749216 11337977856 1952294160 19.245 99 77 154 2 2006766224 32463760 22008304
14:38:46 3008 8192000000 10952263040 11359825920 1974732416 19.423 100 92 181 2 2036200368 34885264 26582688
14:38:56 3518 8192000000 10944531008 11356692480 1970318240 19.388 100 78 156 1 2028633024 35105168 23209616
14:39:07 5118 8192000000 10945219504 11362398208 1974535056 19.421 100 71 137 2 2029640096 34301856 20803184
14:39:19 7694 8192000000 10908414512 11322224640 1938230256 19.133 99 75 152 1 1995886704 34459040 23197408
14:39:33 2606 8192000000 10923786160 11335204864 1950065616 19.227 100 76 149 1 2007437120 33873568 23497936
14:39:46 3574 8192000000 10920314032 11334897664 1937916720 19.130 99 76 150 2 1996001904 34963040 23122144
14:40:01 4790 8192000000 10921960848 11331866624 1947808288 19.209 100 74 148 0 2005204944 34769840 22626816
14:40:13 1258 8192000000 10908498208 11319189504 1937553728 19.127 100 76 153 1 1994166256 33879584 22732944
14:40:22 3068 8192000000 10914584320 11326701568 1942157520 19.164 100 77 154 0 2000174912 33955504 24061888
14:40:36 2775 8192000000 10911231888 11320549376 1926373168 19.038 99 79 156 0 1984447904 34072576 24002160
14:40:51 7294 8192000000 10907722160 11325116416 1926090912 19.036 99 53 105 2 1976184272 33319792 16773568
14:41:05 4417 8192000000 10906635904 11323224064 1912233712 18.925 98 66 129 2 1967348368 34396512 20718144
14:41:20 11999 8192000000 10893192496 11305435136 1909546272 18.903 99 76 152 1 1968187504 35080816 23560416
14:41:39 4971 8192000000 10893910336 11305918464 1918118464 18.972 100 61 122 0 1973816656 36243648 19454544
14:42:00 7046 8192000000 10906259280 11321192448 1933231328 19.093 100 58 115 2 1985478016 34391056 17855632
14:42:34 6310 8192000000 10884921136 11297116160 1911737856 18.921 99 61 122 1 1963746528 32957552 19051120
14:42:48 2976 8192000000 10910795536 11317800960 1931436832 19.078 100 72 143 0 1988234368 34288928 22508608
14:43:02 2280 8192000000 10933891616 11338555392 1949335392 19.221 100 91 175 1 2014397120 37159184 27902544
14:43:13 4967 8192000000 10920655584 11343478784 1951665216 19.240 100 65 130 1 2010212304 38094064 20453024
14:43:26 5937 8192000000 10924336288 11342299136 1950421024 19.230 100 66 132 1 2002851264 33068624 19361616
14:43:40 5749 8192000000 10922720736 11344523264 1952469392 19.246 100 68 134 0 2006010656 33233088 20308176
14:43:54 3859 8192000000 10911910512 11320655872 1927292976 19.045 99 72 142 0 1982617760 33607824 21716960
14:44:07 1931 8192000000 10928345376 11336122368 1946023360 19.195 100 76 152 0 2004489376 34896208 23569808
14:44:20 1100 8192000000 10940355584 11346542592 1951869760 19.241 100 82 168 1 2015666864 38000448 25796656
14:44:29 1049 8192000000 10939676464 11347849216 1955973088 19.274 100 92 183 1 2023250944 38659280 28618576
14:44:37 4586 8192000000 10936038896 11352129536 1955652688 19.271 100 73 144 1 2017349936 39632736 22064512
14:44:49 1992 8192000000 10951608544 11354923008 1957015712 19.282 100 97 195 1 2027194016 41087392 29090912
14:44:59 3895 8192000000 10951700096 11365707776 1962945488 19.329 100 71 142 0 2027175488 42230992 21999008
14:45:10 4114 8192000000 10960000016 11371053056 1970420960 19.389 100 76 152 0 2038517648 44416544 23680144
14:45:21 1271 8192000000 10955587872 11363532800 1951361024 19.237 99 85 168 1 2020523648 43409424 25753200
14:45:30 5417 8192000000 10927509776 11363446784 1962611392 19.327 100 58 115 0 2021333888 40593408 18129088
14:45:42 12533 8192000000 10935833296 11373113344 1947366560 19.205 99 33 66 0 1997162224 38663856 11131808
14:46:08 7930 8192000000 10924014800 11360956416 1947499904 19.207 99 37 74 1 1999544512 39565120 12479488
14:46:27 10374 8192000000 10930663872 11370790912 1965277536 19.348 100 44 88 1 2021881344 41998064 14605744
14:46:47 6253 8192000000 10948770864 11375296512 1970611520 19.390 100 52 100 1 2028989472 42393696 15984256
14:47:00 1364 8192000000 10964667984 11378180096 1978127248 19.450 100 82 165 2 2045581840 42533104 24921488
14:47:08 3778 8192000000 10952800832 11372969984 1961817264 19.320 100 63 126 0 2030309104 49204320 19287520
14:47:19 4192 8192000000 10938497712 11364593664 1958112672 19.291 100 53 105 4 2019671824 44854080 16705072
14:47:31 3964 8192000000 10954484160 11376496640 1969478016 19.381 100 76 152 1 2038336544 45989952 22868576
14:47:43 2573 8192000000 10967221872 11379404800 1976927744 19.440 100 75 151 2 2043625552 42664560 24033248
14:47:51 4860 8192000000 10968054688 11386212352 1979968304 19.464 100 70 140 1 2046484432 44171984 22344144
14:48:03 6488 8192000000 10944678304 11386982400 1976559984 19.437 100 42 84 0 2036253840 45730816 13963040
14:48:16 8530 8192000000 10951619008 11387514880 1975051392 19.425 100 44 88 0 2040176176 50603072 14521712
14:48:42 4603 8192000000 10958714944 11390763008 1976356976 19.436 100 45 88 2 2040476064 48586464 15532624
14:48:54 3351 8192000000 10973077104 11402694656 1988206064 19.530 100 59 117 0 2057101664 50506384 18389216
14:49:06 2799 8192000000 10987446832 11412779008 1994536560 19.580 100 75 147 1 2072220320 53697184 23986576
14:49:21 4115 8192000000 10971912016 11406958592 1992224736 19.561 100 47 94 2 2053914848 45780000 15910112
14:49:40 9867 8192000000 10972827072 11408478208 1990867312 19.551 100 45 89 1 2054255216 48594800 14793104
14:50:01 11615 8192000000 10966791440 11406512128 1985134992 19.505 100 40 78 0 2050339440 51472768 13731680
14:50:19 16125 8192000000 10954802176 11402301440 1985983184 19.512 100 36 72 1 2048412912 49664896 12764832
14:50:51 17174 8192000000 10955992576 11397697536 1981224912 19.474 100 31 62 2 2035136560 42928688 10982960
14:51:18 10601 8192000000 10948580912 11393400832 1975397200 19.428 100 42 84 0 2038995424 49293168 14305056
14:51:44 9950 8192000000 10955610816 11396702208 1968274864 19.372 100 40 78 1 2035283664 52717040 14291760
14:52:06 12091 8192000000 10948252080 11381932032 1960946960 19.314 100 47 94 2 2029076960 51268144 16861856
14:52:25 10828 8192000000 10965381904 11399725056 1968779392 19.376 100 46 92 1 2041869488 56956672 16133424
14:53:03 4156 8192000000 10962672864 11403059200 1971226272 19.395 100 38 76 1 2040691264 56216960 13248032
14:53:25 20435 8192000000 10960485376 11406680064 1970930576 19.393 100 38 76 1 2037932880 53470736 13531568
14:53:53 18327 8192000000 10921270464 11385630720 1937813728 19.129 99 21 42 2 1998778160 52726192 8238240
14:54:55 35548 8192000000 10913087328 11374821376 1954231616 19.260 100 19 37 0 2000792128 40498320 6062192
14:56:15 69609 8192000000 10903129600 11381575680 1958921312 19.297 100 13 26 1 2003298512 40360640 4016560
14:57:31 111112 8192000000 10902992560 11363237888 1891554304 18.758 96 13 26 0 1911950704 17040240 3356160
14:59:29 28579 8192000000 10915005296 11352743936 1958966608 19.298 99 39 79 1 1984923856 14267744 11689504
15:00:07 79799 8192000000 10917090640 11391315968 1925970448 19.035 98 11 22 0 1947316144 18965952 2379744
15:02:28 141475 8192000000 10918817200 11376480256 1956556960 19.279 99 19 39 0 1979974032 17690928 5726144
15:05:05 69062 8192000000 10921538000 11380568064 1975397808 19.428 100 40 77 1 1999207920 12493840 11316272
15:06:22 61531 8192000000 10928738576 11387854848 1988281392 19.530 100 46 92 2 2010959152 9875344 12802416
15:07:41 7490 8192000000 10952498928 11393777664 2005247184 19.664 100 61 122 2 2034444496 11566976 17630336
15:08:01 33190 8192000000 10936513584 11402797056 2004692656 19.660 100 34 68 0 2026774352 12680704 9400992
15:10:03 38177 8192000000 10964192816 11416518656 2013829024 19.732 100 48 92 1 2043929264 16247392 13852848
15:10:57 74265 8192000000 10922789552 11429421056 2006907008 19.677 100 17 34 2 2030152880 18250992 4994880
15:12:40 29621 8192000000 10920586224 11407192064 2005993344 19.670 100 22 43 0 2022265200 9666048 6605808
15:13:19 57108 8192000000 10918144976 11392036864 1970437104 19.389 98 13 27 0 1980760560 6772416 3551040
15:14:25 10871 8192000000 10917812624 11389825024 1976586464 19.438 99 11 22 0 1986345440 6588064 3170912
15:14:42 30842 8192000000 10932807136 11403218944 2000801136 19.629 100 14 28 1 2017814432 12819888 4193408
15:15:43 55143 8192000000 10915038624 11396788224 1985007296 19.504 99 10 22 1 1998707408 10540720 3159392
15:16:54 71217 8192000000 10918399664 11383410688 1952509504 19.246 98 29 58 1 1968902160 8405440 7987216
15:18:12 90528 8192000000 10910505456 11393835008 1990178960 19.545 100 10 20 1 2004299120 11546128 2574032
15:20:18 50847 8192000000 10908156240 11379060736 1936639424 19.120 97 28 55 3 1957772320 12515680 8617216
15:21:20 72304 8192000000 10895428720 11386413056 1912565472 18.927 96 13 26 1 1933933760 17731728 3636560
15:22:39 42540 8192000000 10887483104 11380555776 1955966768 19.274 99 10 20 1 1975721280 16984960 2769552
15:23:33 107187 8192000000 10905894400 11383734272 1963731200 19.336 99 14 28 0 1982745712 14615600 4398912
15:25:35 86350 8192000000 10892469056 11382681600 1953783840 19.257 99 16 32 0 1976927120 18317168 4826112
15:27:53 29571 8192000000 10881413152 11358629888 1947586512 19.207 99 16 32 0 1967913968 15524336 4803120
15:28:39 22696 8192000000 10918711264 11371040768 1935240992 19.109 98 34 67 1 1951296944 6634528 9421424
15:29:11 12291 8192000000 10886191984 11347722240 1919619680 18.984 98 38 76 0 1938473952 8828608 10025664
15:29:30 37199 8192000000 10877839504 11343912960 1922202784 19.004 98 22 44 1 1937827472 9300688 6324000
15:30:20 26649 8192000000 10894708304 11364409344 1941202752 19.156 99 32 64 3 1964579456 14637152 8739552
15:31:02 44675 8192000000 10876476736 11353489408 1900914384 18.834 97 25 50 0 1919104960 11555216 6635360
15:31:58 48014 8192000000 10890797248 11360096256 1952653008 19.248 100 23 42 1 1970603680 11648384 6302288
15:32:56 35559 8192000000 10865861552 11347730432 1918022144 18.971 98 19 38 1 1933995536 11037936 4935456
15:33:38 20826 8192000000 10882691248 11339702272 1912701040 18.928 98 26 51 1 1928564080 8938048 6924992
15:34:08 24580 8192000000 10891675232 11338870784 1945614720 19.192 100 54 107 1 1976495184 15495968 15384496
15:34:40 72242 8192000000 10847380368 11333165056 1859533440 18.499 96 30 60 0 1884952288 17096288 8322560
15:35:59 52820 8192000000 10866436224 11323727872 1867279872 18.562 96 27 54 0 1885257648 10522816 7454960
15:37:00 32622 8192000000 10872504336 11326824448 1918988624 18.979 99 37 74 2 1939811216 10804416 10018176
15:37:42 15183 8192000000 10875891040 11323736064 1912870848 18.930 99 39 79 1 1936824640 13371600 10582192
15:38:06 50229 8192000000 10873181248 11334848512 1901536240 18.839 98 35 70 0 1924708384 13900960 9271184
15:39:07 111879 8192000000 10849103568 11314659328 1833254736 18.286 95 18 36 1 1855695440 18040224 4400480
15:41:05 98489 8192000000 10856964096 11326160896 1871944992 18.600 97 25 50 0 1890154352 11618736 6590624
15:42:49 91074 8192000000 10847428512 11304325120 1851872224 18.437 96 20 40 1 1873097984 15719488 5506272
15:44:28 56139 8192000000 10860177808 11324526592 1929671584 19.064 100 27 52 2 1954303264 17216112 7415568
15:46:05 38858 8192000000 10854227872 11326599168 1918907968 18.978 99 14 28 2 1930127872 6916704 4303200
15:47:55 45571 8192000000 10832569552 11285778432 1798000112 17.997 93 28 56 3 1820342928 14247472 8095344
15:48:50 68423 8192000000 10800134512 11271507968 1832622672 18.281 96 13 26 0 1847274080 10981168 3670240
15:50:10 74259 8192000000 10852520912 11318267904 1902684016 18.848 99 14 28 0 1920985072 14284768 4016288
15:51:30 38303 8192000000 10852878960 11325116416 1927489824 19.047 100 13 25 1 1943112608 12253088 3369696
15:52:35 63995 8192000000 10865654016 11346485248 1936847712 19.122 100 10 20 0 1952450960 12763632 2839616
15:54:01 93736 8192000000 10859447840 11342487552 1922371744 19.006 99 9 16 0 1932862160 8425824 2064592
15:55:43 35522 8192000000 10894642240 11350106112 1958993360 19.298 100 34 67 2 1976511360 8652624 8865376
15:56:27 26141 8192000000 10885987872 11344560128 1922455296 19.007 98 35 68 0 1946282688 13983600 9843792
15:57:02 45746 8192000000 10895390176 11348652032 1924597696 19.024 98 32 64 1 1945373872 12090272 8685904
15:57:55 61642 8192000000 10909900944 11367997440 1971103072 19.394 100 33 65 2 1989112448 9172496 8836880
15:59:02 34621 8192000000 10928196560 11378892800 1980351776 19.467 100 34 68 1 2000075088 10612432 9110880
15:59:43 56068 8192000000 10918220560 11402391552 1993838816 19.574 100 36 72 0 2018075680 13873760 10363104
16:00:49 63977 8192000000 10919507232 11400450048 1951969744 19.242 98 11 22 0 1972020832 16494512 3556576
16:02:05 86789 8192000000 10921049472 11401998336 1945390208 19.190 98 13 25 1 1967741872 18890464 3461200
16:03:47 98969 8192000000 10894209120 11368468480 1871358416 18.595 94 14 28 0 1887977648 13002432 3616800
16:05:34 54928 8192000000 10903029648 11359162368 1913711792 18.936 97 16 32 2 1925718432 7805488 4201152
16:06:35 21462 8192000000 10903727504 11356721152 1944528400 19.183 99 39 77 2 1964782272 9598768 10655104
16:07:04 52414 8192000000 10914764256 11376693248 1956900944 19.281 99 34 68 3 1986829040 20906064 9022032
16:08:06 104328 8192000000 10887787408 11368415232 1912416592 18.926 97 23 46 0 1940109248 20702448 6990208
16:10:16 82733 8192000000 10868800304 11355230208 1889660176 18.743 96 17 34 0 1908625616 14495792 4469648
16:12:12 7629 8192000000 10863419136 11338084352 1926671312 19.040 99 9 18 2 1939594944 10599280 2324352
16:12:26 31783 8192000000 10878798544 11343364096 1937237808 19.125 99 29 58 1 1953134528 8091600 7805120
16:13:07 66369 8192000000 10883118624 11361050624 1949123648 19.219 99 20 40 2 1965951568 11270832 5557088
16:14:19 54595 8192000000 10882983680 11362332672 1946631440 19.200 99 4 8 0 1954660656 7008224 1020992
16:15:20 32362 8192000000 10899265712 11367260160 1968312336 19.372 100 22 42 2 1981192112 5797280 7082496
16:15:59 62319 8192000000 10910083104 11380584448 1962991216 19.330 99 12 24 0 1974297152 7970176 3335760
16:17:07 77542 8192000000 10909858240 11384352768 1966484416 19.358 99 15 30 0 1979160064 8220256 4455392
16:18:31 16058 8192000000 10903168080 11377971200 1970555552 19.390 99 23 46 0 1988073392 10651952 6865888
16:18:56 31960 8192000000 10874360864 11346161664 1941773040 19.161 98 15 30 2 1955380416 9608080 3999296
16:21:24 31893 8192000000 10877523968 11344478208 1886242496 18.715 96 22 43 1 1899064496 6601952 6220048
16:22:11 70270 8192000000 10849978992 11324239872 1837821680 18.323 94 18 36 0 1851303984 8483344 4998960
16:23:27 68812 8192000000 10880181552 11342831616 1903454000 18.854 98 20 40 1 1921758848 12661376 5643472
16:24:43 60513 8192000000 10867248288 11340800000 1883030592 18.690 97 22 44 0 1908811520 18987584 6793344
16:25:50 75665 8192000000 10229747808 10636578816 1285324784 13.562 66 9 18 0 1295191200 7249296 2617120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-11-2020 16:28:18 to 01-11-2020 16:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 172 v_add_invoice_to_stock 335544517
user_exc 20 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-11-2020 16:28:51 to 01-11-2020 16:28:53.

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          244878
MON$OLDEST_ACTIVE               246570
MON$OLDEST_SNAPSHOT             246570
MON$NEXT_TRANSACTION            246570
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                       2044640
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:140: 
:141: mscs-test-161.budzdorov.ru    Sun Nov  1 16:27:15 2020
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
:144: 
:145: mscs-test-161.budzdorov.ru    Sun Nov  1 16:27:16 2020
:146:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:147: 
:148: 
:149: mscs-test-161.budzdorov.ru    Sun Nov  1 16:27:20 2020
:150:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:151: 
--- end of diff output ---

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

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