Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.11.2020 22: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 17156116 kB
MemAvailable 31392184 kB
Buffers 0 kB
Cached 14492728 kB
SwapCached 3484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-14 22:27:03
DTS_END                         2020-11-14 22:27:03.5430
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/53404
TRN_ID                          237274
ATT_ID                          690
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: 9462.47 21766 1135496
customer order: creation 171.35 386 20562
customer order: refuse 14.73 360 1767
order to supplier: creation 44.88 1322 5385
order to supplier: removal 3.45 111879 414
invoice (draft): creation 45.99 3548 5519
invoice (draft): removal 54.89 846 6587
invoice accept: apply 41.59 16708 4991
invoice accept: cancel 50.21 826 6025
customer reserve: creation 3796.53 167 455583
customer reserve: removal 4940.85 62 592902
realization accept: apply 82.72 181 9926
realization accept: cancel 85.63 117 10275
payment from customer: creation 59.78 117 7174
payment from customer: removal 5.60 114 672
payment to supplier: creation 49.08 146 5889
payment to supplier: removal 2.99 89 359
service: total inventory turnovers 5.08 1020 610
service: total monetary turnovers 6.27 31 752
service: aggregate perf. data 0.83 18861 100
service: refresh index statistics 0.03 278536 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-11-2020 22:28:16 to 14-11-2020 22:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8747
TEST_TIME 2 7154
TEST_TIME 3 6158
TEST_TIME 4 6188
TEST_TIME 5 5921
TEST_TIME 6 5469
TEST_TIME 7 5158
TEST_TIME 8 4919
TEST_TIME 9 5242
TEST_TIME 10 5477
TEST_TIME 11 5626
TEST_TIME 12 6114
TEST_TIME 13 6251
TEST_TIME 14 6259
TEST_TIME 15 6846
TEST_TIME 16 7205
TEST_TIME 17 7394
TEST_TIME 18 7652
TEST_TIME 19 7868
TEST_TIME 20 7983
TEST_TIME 21 8153
TEST_TIME 22 8043
TEST_TIME 23 8380
TEST_TIME 24 8770
TEST_TIME 25 9552
TEST_TIME 26 9847
TEST_TIME 27 10692
TEST_TIME 28 11183
TEST_TIME 29 10990
TEST_TIME 30 10840
TEST_TIME 31 10856
TEST_TIME 32 10752
TEST_TIME 33 10627
TEST_TIME 34 10751
TEST_TIME 35 10651
TEST_TIME 36 10575
TEST_TIME 37 10396
TEST_TIME 38 10204
TEST_TIME 39 10154
TEST_TIME 40 10292
TEST_TIME 41 10205
TEST_TIME 42 10182
TEST_TIME 43 10075
TEST_TIME 44 10091
TEST_TIME 45 10200
TEST_TIME 46 10128
TEST_TIME 47 10066
TEST_TIME 48 10006
TEST_TIME 49 9851
TEST_TIME 50 9835
TEST_TIME 51 9874
TEST_TIME 52 9810
TEST_TIME 53 9674
TEST_TIME 54 9721
TEST_TIME 55 9693
TEST_TIME 56 9682
TEST_TIME 57 9700
TEST_TIME 58 9678
TEST_TIME 59 9613
TEST_TIME 60 9788
TEST_TIME 61 9720
TEST_TIME 62 9828
TEST_TIME 63 9914
TEST_TIME 64 9893
TEST_TIME 65 9919
TEST_TIME 66 10026
TEST_TIME 67 9994
TEST_TIME 68 9948
TEST_TIME 69 9870
TEST_TIME 70 9794
TEST_TIME 71 9788
TEST_TIME 72 9809
TEST_TIME 73 9752
TEST_TIME 74 9689
TEST_TIME 75 9606
TEST_TIME 76 9538
TEST_TIME 77 9563
TEST_TIME 78 9573
TEST_TIME 79 9548
TEST_TIME 80 9520
TEST_TIME 81 9529
TEST_TIME 82 9584
TEST_TIME 83 9693
TEST_TIME 84 9670
TEST_TIME 85 9673
TEST_TIME 86 9818
TEST_TIME 87 9803
TEST_TIME 88 9875
TEST_TIME 89 9886
TEST_TIME 90 9824
TEST_TIME 91 9763
TEST_TIME 92 9713
TEST_TIME 93 9655
TEST_TIME 94 9654
TEST_TIME 95 9651
TEST_TIME 96 9604
TEST_TIME 97 9591
TEST_TIME 98 9639
TEST_TIME 99 9594
TEST_TIME 100 9574
TEST_TIME 101 9732
TEST_TIME 102 9706
TEST_TIME 103 9673
TEST_TIME 104 9722
TEST_TIME 105 9684
TEST_TIME 106 9793
TEST_TIME 107 9775
TEST_TIME 108 9719
TEST_TIME 109 9662
TEST_TIME 110 9631
TEST_TIME 111 9595
TEST_TIME 112 9551
TEST_TIME 113 9534
TEST_TIME 114 9531
TEST_TIME 115 9507
TEST_TIME 116 9538
TEST_TIME 117 9561
TEST_TIME 118 9552
TEST_TIME 119 9550
TEST_TIME 120 9473

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-11-2020 22:28:20 to 14-11-2020 22:28:23.

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 1558939 1558939 0 0.00 0 18873 6 0 0
doc_list_biud 1558935 1558935 0 0.00 0 53330 30 0 0
sp_add_invoice_to_stock 5109 4991 118 2.30 42 233436 16709 0 118
sp_cancel_adding_invoice 6025 6025 0 0.00 5 74020 826 0 0
sp_cancel_client_order 1767 1767 0 0.00 4 14375 361 0 0
sp_cancel_customer_reserve 592902 592902 0 0.00 1 53333 62 0 0
sp_cancel_pay_from_customer 672 672 0 0.00 3 7532 115 0 0
sp_cancel_pay_to_supplier 359 359 0 0.00 3 5975 89 0 0
sp_cancel_supplier_invoice 6598 6587 11 0.16 2 42505 847 0 11
sp_cancel_supplier_order 414 414 0 0.00 8 1342983 111879 0 0
sp_cancel_write_off 10275 10275 0 0.00 1 14445 118 0 0
sp_client_order 20562 20562 0 0.00 3 44912 386 0 0
sp_customer_reserve 455583 455583 0 0.00 0 48752 167 0 0
sp_fill_shopping_cart 31452 31452 0 0.00 1 17011 37 0 0
sp_fill_shopping_cart_clo_res 455563 455563 0 0.00 0 17918 15 0 0
sp_get_clo_for_invoice 4970 4970 0 0.00 0 18983 245 0 0
sp_kill_cost_storno 17331 17331 0 0.00 0 10516 58 0 0
sp_kill_qstorno_ret_qs2qd 1203080 1203080 0 0.00 0 53297 34 0 0
sp_kill_qty_storno 632865 632865 0 0.00 0 53330 72 0 0
sp_lock_selected_doc 20589 20589 0 0.00 0 8855 6 0 0
sp_make_cost_storno 27958 27958 0 0.00 0 12905 54 0 0
sp_multiply_rows_for_pdistr 27958 27958 0 0.00 0 6548 28 0 0
sp_multiply_rows_for_qdistr 20562 20562 0 0.00 0 16588 189 0 0
sp_pay_from_customer 7174 7174 0 0.00 3 16607 117 0 0
sp_pay_to_supplier 5889 5889 0 0.00 5 19679 147 0 0
sp_payment_common 13063 13063 0 0.00 1 10812 36 0 0
sp_qd_handle_on_cancel_clo 1767 1767 0 0.00 0 14367 326 0 0
sp_qd_handle_on_invoice_upd_sts 10994 10994 0 0.00 0 16207 327 0 0
sp_qd_handle_on_reserve_upd_sts 9926 9926 0 0.00 0 13406 55 0 0
sp_reserve_write_off 9926 9926 0 0.00 6 18280 182 0 0
sp_supplier_invoice 5519 5519 0 0.00 7 97540 3549 0 0
sp_supplier_order 5385 5385 0 0.00 6 29676 1322 0 0
srv_aggregate_perf_data 100 100 0 0.00 3079 117442 18862 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1698 168743 31133 0 0
srv_find_qd_qs_mism 1088864 1088864 0 0.00 0 11692 5 0 0
srv_make_invnt_saldo 610 610 0 0.00 34 63871 1020 0 0
srv_make_money_saldo 752 752 0 0.00 1 7289 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 154854 369206 278537 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4991 4991 0 0.00 0 18267 166 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 2301 76 0 0
t$perf-norm:sp_cancel_client_order 1767 1767 0 0.00 0 3474 11 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 2588 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 672 672 0 0.00 0 4661 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 359 359 0 0.00 0 278 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 3127 17 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 26758 1595 0 0
t$perf-norm:sp_cancel_write_off 978 978 0 0.00 0 4895 14 0 0
t$perf-norm:sp_client_order 20562 20562 0 0.00 0 10005 18 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 1412 7 0 0
t$perf-norm:sp_pay_from_customer 7174 7174 0 0.00 0 3977 10 0 0
t$perf-norm:sp_pay_to_supplier 5889 5889 0 0.00 0 4409 11 0 0
t$perf-norm:sp_reserve_write_off 9926 9926 0 0.00 0 10284 14 0 0
t$perf-norm:sp_supplier_invoice 5519 5519 0 0.00 0 6452 20 0 0
t$perf-norm:sp_supplier_order 5385 5385 0 0.00 0 8370 15 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 268 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 458 10 0 0
t$perf-norm:srv_make_invnt_saldo 610 610 0 0.00 0 875 16 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 2756 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10172 9936 236 2.32 0 17390 19 0 236
v_all_customers 38174 38174 0 0.00 0 222 1 0 0
v_all_suppliers 30336 30336 0 0.00 0 223 1 0 0
v_all_wares 41124 41124 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 310 6 0 0
v_cancel_client_order 3534 3534 0 0.00 0 3838 7 0 0
v_cancel_customer_prepayment 1344 1344 0 0.00 0 5474 17 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 1451 5 0 0
v_cancel_payment_to_supplier 718 718 0 0.00 0 408 4 0 0
v_cancel_supplier_invoice 806 784 22 2.72 0 1539 16 0 22
v_cancel_supplier_order 828 828 0 0.00 0 3451 8 0 0
v_cancel_write_off 1956 1956 0 0.00 0 5482 21 0 0
v_max_id_clo_ord 5381 5381 0 0.00 0 436 1 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 5136 32 0 0
v_max_id_ord_sup 5509 5509 0 0.00 0 2971 2 0 0
v_max_non_paid_invoice 1610 1610 0 0.00 0 554 3 0 0
v_max_non_paid_realizn 3598 3598 0 0.00 0 3728 7 0 0
v_min_id_clo_ord 5381 5381 0 0.00 0 6709 6 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 5591 8 0 0
v_min_id_ord_sup 5509 5509 0 0.00 0 5913 9 0 0
v_min_non_paid_invoice 5889 5889 0 0.00 0 10808 28 0 0
v_min_non_paid_realizn 7173 7173 0 0.00 0 9916 23 0 0
v_our_firm 10098 10098 0 0.00 0 221 1 0 0
v_reserve_write_off 19851 19851 0 0.00 0 17845 7 0 0
x_lock_depdocs_on_canc_invoice 12220 12220 0 0.00 0 13441 109 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 6716 406 0 0
x_make_qstorno_1000_1200 5385 5385 0 0.00 2 29667 1245 0 0
x_make_qstorno_1200_2000 5519 5519 0 0.00 4 97376 3417 0 0
x_make_qstorno_2100_3300 455583 455583 0 0.00 0 41873 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2020 22:28:24 to 14-11-2020 22:28:28.

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
19:57:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 15324 8192000000 10233812080 10546921472 985504368 10.738 77 63 130 1 1008096512 2888368 19703776
19:57:38 34453 8192000000 10368214800 10684227584 1392084448 14.524 100 88 176 0 1425622128 4778992 28758688
19:58:22 35804 8192000000 10392052528 10717749248 1436515408 14.919 100 89 178 0 1472734704 7154208 29065088
19:59:05 15549 8192000000 10417987056 10744537088 1464153936 15.162 100 89 178 2 1501127728 7992448 28981344
19:59:28 21306 8192000000 10433300656 10764382208 1482087776 15.320 100 91 182 0 1520191296 8948304 29155216
19:59:57 22728 8192000000 10446641472 10778431488 1496943648 15.450 100 86 172 1 1534064448 9769856 27350944
20:00:40 16935 8192000000 10454117136 10792210432 1512658320 15.586 100 92 184 0 1552280704 10355952 29266432
20:01:14 12015 8192000000 10485002992 10828955648 1536521440 15.793 100 86 170 2 1573610272 10427632 26661200
20:01:35 14400 8192000000 10504095072 10854199296 1560969648 16.005 100 82 163 2 1597419792 10651408 25798736
20:02:04 8530 8192000000 10515847744 10871877632 1582951808 16.193 100 79 158 1 1617511552 10576464 23983280
20:02:22 11052 8192000000 10537053872 10895228928 1598864848 16.330 100 73 146 0 1631025248 10193184 21967216
20:02:41 10695 8192000000 10559674320 10919624704 1622035680 16.527 100 72 144 2 1653506000 10038864 21431456
20:03:01 12891 8192000000 10586228128 10951708672 1657634432 16.829 100 76 153 0 1690598784 10903328 22061024
20:03:23 9863 8192000000 10609284224 10977259520 1670557552 16.938 100 80 160 1 1706521808 12180672 23783584
20:03:42 10638 8192000000 10624950944 10994634752 1683505072 17.047 100 84 169 0 1720063616 12035424 24523120
20:04:00 6195 8192000000 10639832000 11011055616 1700209856 17.187 100 79 158 2 1735531376 12095376 23226144
20:04:16 6213 8192000000 10652273648 11025940480 1716036928 17.319 100 78 156 0 1750182016 12027376 22117712
20:04:29 8468 8192000000 10677228864 11049488384 1733372224 17.464 100 81 163 0 1769066000 12459392 23234384
20:04:46 6921 8192000000 10698034048 11070291968 1749181952 17.595 100 84 168 2 1786689088 13985168 23521968
20:04:59 3634 8192000000 10697465728 11072479232 1759878576 17.683 100 87 173 0 1797522496 14291440 23352480
20:05:10 3112 8192000000 10700060288 11076612096 1766827520 17.741 100 90 180 0 1806104720 14270160 25007040
20:05:19 3674 8192000000 10717251440 11094425600 1772292800 17.786 100 89 178 1 1811964016 15040704 24630512
20:05:30 3612 8192000000 10728257664 11105456128 1786027072 17.899 100 93 187 2 1827870224 15870528 25972624
20:05:40 4451 8192000000 10733266688 11112513536 1789952928 17.931 100 86 171 2 1829410608 15699488 23758192
20:05:52 2290 8192000000 10736023536 11119271936 1794626576 17.970 100 84 168 3 1834124800 14915936 24582288
20:06:02 3469 8192000000 10747094160 11130150912 1807428432 18.075 100 84 163 0 1843355200 13178992 22747776
20:06:12 3066 8192000000 10756142272 11139117056 1817371040 18.156 100 86 169 0 1854397520 13724224 23302256
20:06:22 6356 8192000000 10758436000 11146735616 1818684480 18.167 100 82 163 0 1855792080 14956672 22150928
20:06:35 5988 8192000000 10762629680 11152261120 1823814272 18.209 100 84 168 2 1864881408 17777280 23289856
20:06:48 1963 8192000000 10783378000 11168538624 1841753088 18.355 100 84 168 0 1880492944 13894416 24845440
20:06:56 2125 8192000000 10783322576 11170906112 1844814864 18.380 100 90 181 4 1884332176 13508640 26008672
20:07:05 1205 8192000000 10794870704 11179401216 1851450208 18.434 100 90 180 0 1890326208 13390656 25485344
20:07:12 2681 8192000000 10796954064 11185799168 1854554304 18.459 100 93 184 3 1892511600 12584208 25373088
20:07:23 1759 8192000000 10806174160 11193180160 1860628080 18.508 100 95 190 2 1900863152 13677888 26557184
20:07:31 2179 8192000000 10799242144 11184545792 1861173344 18.513 100 93 188 1 1901045360 13431120 26440896
20:07:39 1357 8192000000 10803225088 11194753024 1863793248 18.534 100 93 184 2 1903560192 14002240 25764704
20:07:47 2144 8192000000 10807633424 11195760640 1865518656 18.548 100 89 177 2 1903262528 11682384 26061488
20:07:56 1754 8192000000 10809857216 11196694528 1866400304 18.555 100 89 181 2 1903276112 11342336 25533472
20:08:04 1821 8192000000 10805309904 11194216448 1866712848 18.558 100 87 174 2 1903295584 12560048 24022688
20:08:12 38232 8192000000 10806297488 11200131072 1862539632 18.524 100 61 122 0 1890682640 11141616 17001392
20:08:57 1684 8192000000 10797281952 11201662976 1869675616 18.582 100 74 148 2 1902378096 11561776 21140704
20:09:06 4464 8192000000 10793076384 11204857856 1867149104 18.561 100 52 104 0 1892770144 10944544 14676496
20:09:17 5005 8192000000 10793619728 11206565888 1870219520 18.586 100 47 90 2 1891961744 9149264 12592960
20:09:28 2773 8192000000 10801405152 11205890048 1873533136 18.613 100 54 108 0 1898455360 9562304 15359920
20:09:38 5460 8192000000 10801834976 11205496832 1871550384 18.597 100 39 77 0 1890537424 8084976 10902064
20:09:50 3016 8192000000 10792309584 11210964992 1874396176 18.620 100 34 68 0 1892093200 8339696 9357328
20:10:00 5429 8192000000 10794223600 11212337152 1877911856 18.648 100 39 78 0 1896363712 7444800 11007056
20:10:13 7076 8192000000 10784854656 11213807616 1877578128 18.646 100 39 78 2 1896732112 7941168 11212816
20:10:28 5600 8192000000 10792182192 11214913536 1877793600 18.647 100 29 58 0 1893229616 7399440 8036576
20:10:41 46732 8192000000 10800538256 11227516928 1881590400 18.678 100 39 78 1 1898876464 5566896 11719168
20:11:34 29141 8192000000 10797165888 11231522816 1881973360 18.681 100 20 40 1 1897614560 9835920 5805280
20:12:10 5542 8192000000 10808026192 11232428032 1888426672 18.733 100 38 76 2 1906616160 7981456 10208032
20:12:24 5934 8192000000 10810925120 11237789696 1893688464 18.775 100 47 94 0 1915478608 8293200 13496944
20:12:37 5232 8192000000 10804417264 11235151872 1891330400 18.757 100 38 77 0 1910255904 7989632 10935872
20:12:53 5841 8192000000 10813534048 11238350848 1889742544 18.744 100 31 61 1 1905460976 7249984 8468448
20:13:08 6752 8192000000 10805907504 11233636352 1888551248 18.734 100 23 46 1 1902074768 6813680 6709840
20:13:23 8122 8192000000 10812822608 11237961728 1895552592 18.791 100 28 57 1 1909344592 5847104 7944896
20:13:38 4530 8192000000 10821777216 11243974656 1895864960 18.793 100 34 67 2 1911077552 6722000 8490592
20:13:51 7185 8192000000 10803026400 11241672704 1893823408 18.777 100 16 30 2 1903621136 5401200 4396528
20:14:06 5652 8192000000 10817633040 11244625920 1896585232 18.799 100 23 46 0 1909323600 5948464 6789904
20:14:19 9829 8192000000 10803825040 11245445120 1898004768 18.810 100 15 30 0 1907590816 5626752 3959296
20:14:39 10524 8192000000 10818441872 11250647040 1900829008 18.833 100 19 36 1 1911521984 5381472 5311504
20:14:56 24249 8192000000 10790760928 11234631680 1850977632 18.430 97 29 57 1 1865659312 5238464 9443216
20:15:46 34727 8192000000 10803483104 11247468544 1897491600 18.806 100 24 48 0 1910120144 5680960 6947584
20:16:29 10301 8192000000 10788129712 11218337792 1858062192 18.488 98 19 38 2 1868623040 5003440 5557408
20:16:47 8102 8192000000 10805223808 11234562048 1871979056 18.600 99 20 40 1 1883322656 5750032 5593568
20:17:03 3482 8192000000 10791922624 11215056896 1860212128 18.505 99 21 41 4 1871460016 5581824 5666064
20:17:16 7120 8192000000 10779924080 11207704576 1836017088 18.308 98 19 39 0 1847544080 5184656 6342336
20:17:29 5777 8192000000 10772930176 11204263936 1826162304 18.228 97 37 74 4 1843077072 6249200 10665568
20:17:41 11055 8192000000 10776967888 11205267456 1835676672 18.306 98 17 34 2 1845572656 4931088 4964896
20:18:01 8962 8192000000 10741078096 11166810112 1754067360 17.635 94 12 24 2 1761815088 4946352 2801376
20:18:16 8345 8192000000 10750904992 11176828928 1812934768 18.120 98 19 38 2 1825006352 5848000 6223584
20:18:31 13209 8192000000 10722698464 11145338880 1716919440 17.327 93 21 42 3 1728465088 5630064 5915584
20:18:53 11419 8192000000 10692960352 11113455616 1680714144 17.023 92 18 36 1 1690232720 4406352 5112224
20:19:11 11167 8192000000 10719822720 11140026368 1761023728 17.693 97 15 30 0 1770791136 5804000 3963408
20:19:30 14664 8192000000 10728838016 11149131776 1787325808 17.910 98 12 24 0 1796189328 5474768 3388752
20:19:51 41017 8192000000 10676583584 11067183104 1678148176 17.002 92 35 70 1 1694624752 5453776 11022800
20:20:39 37271 8192000000 10677798992 11100491776 1641150352 16.689 91 30 60 1 1659774784 10122176 8502256
20:21:23 8240 8192000000 10681440800 11087740928 1724345056 17.388 97 22 44 2 1736254544 5266736 6642752
20:21:40 5130 8192000000 10695956336 11105648640 1755065616 17.644 97 38 76 1 1777740736 12220944 10454176
20:21:51 6098 8192000000 10708638544 11128324096 1799328512 18.008 100 34 67 2 1814966592 6072032 9566048
20:22:05 4729 8192000000 10715707952 11130671104 1785680784 17.896 99 27 54 0 1800555600 6916160 7958656
20:22:16 3989 8192000000 10728540992 11137343488 1804997968 18.055 100 35 70 0 1821055472 6599072 9458432
20:22:27 6295 8192000000 10730753792 11146723328 1797269920 17.992 99 30 61 1 1817320704 11559472 8491312
20:22:41 8893 8192000000 10732306016 11152809984 1817738208 18.159 100 28 54 0 1831569120 5944752 7886160
20:22:57 5899 8192000000 10736231984 11162374144 1831689072 18.273 100 33 64 0 1846882416 5922272 9271072
20:23:09 10049 8192000000 10754028304 11173965824 1834485312 18.296 100 32 64 2 1854013136 9431328 10096496
20:23:28 6634 8192000000 10741744272 11172270080 1823760384 18.208 99 30 60 2 1842708464 9694464 9253616
20:23:41 6032 8192000000 10758494960 11179692032 1839533520 18.337 100 24 47 1 1851386816 5119056 6734240
20:23:59 11456 8192000000 10770664528 11189252096 1848500320 18.410 100 37 73 0 1865601536 4985568 12115648
20:24:19 14885 8192000000 10770672912 11191156736 1853327312 18.449 100 24 48 0 1866520032 6017872 7174848
20:24:44 12037 8192000000 10773808112 11198283776 1855523536 18.467 100 16 32 2 1865562608 5531632 4507440
20:25:06 72902 8192000000 10773300256 11203694592 1865792240 18.550 100 31 61 4 1880407376 5523920 9091216
20:26:28 7869 8192000000 10784010304 11212189696 1868385760 18.571 100 25 50 3 1885657616 10575024 6696832
20:26:43 9654 8192000000 10782566816 11211706368 1866160064 18.553 100 16 32 1 1875563136 4878880 4524192
20:27:03 4774 8192000000 10829207744 11233669120 1892958160 18.770 100 54 106 1 1915769408 7096304 15714944
20:27:17 5083 8192000000 10835841200 11246120960 1904364432 18.861 100 63 124 0 1930469280 8192272 17912576
20:27:34 33369 8192000000 10840988848 11258454016 1905436096 18.870 100 45 90 1 1926193184 8757408 11999680
20:28:17 9065 8192000000 10845178592 11266457600 1915501136 18.951 100 47 94 0 1942083344 13602768 12979440
20:28:36 16490 8192000000 10856007408 11276607488 1926185392 19.036 100 50 98 4 1949206384 8745440 14275552
20:29:07 28014 8192000000 10861468336 11286753280 1930296576 19.069 100 44 90 2 1951253072 8450224 12506272
20:29:45 56574 8192000000 10870281088 11311517696 1943883712 19.178 100 35 70 0 1967756048 14223488 9648848
20:30:59 22545 8192000000 10893795744 11324907520 1961317424 19.317 100 42 83 0 1989275264 15829008 12128832
20:31:33 23616 8192000000 10910112256 11343237120 1968512000 19.374 100 45 89 0 1998652384 16859856 13280528
20:32:08 22842 8192000000 10907370144 11343536128 1957641376 19.287 99 49 98 0 1990152848 18327200 14184272
20:32:46 8863 8192000000 10928697968 11355332608 1982533728 19.485 100 56 112 0 2018526560 19651296 16341536
20:33:12 38051 8192000000 10922007088 11357290496 1983017456 19.489 100 49 95 1 2018193712 21407648 13768608
20:34:08 22243 8192000000 10911693760 11357499392 1982732608 19.486 100 24 48 2 2011477056 21207952 7536496
20:34:50 13445 8192000000 10926808832 11359686656 1969484592 19.381 99 32 64 2 2001594192 21790656 10318944
20:35:11 10632 8192000000 10947500976 11376267264 1991054256 19.552 100 48 96 1 2029984176 24033904 14896016
20:35:30 3919 8192000000 10942268096 11374243840 1995520928 19.587 100 52 100 1 2034856688 24732816 14602944
20:35:44 3645 8192000000 10955230304 11371655168 1981099888 19.473 99 65 128 2 2024951328 25021856 18829584
20:35:55 7681 8192000000 10936212928 11358720000 1978737328 19.455 100 67 132 2 2024141296 26482496 18921472
20:36:11 3825 8192000000 10952495552 11373150208 1988762320 19.534 100 64 128 0 2037954224 30146416 19045488
20:36:21 3150 8192000000 10953973424 11370147840 1985955280 19.512 100 63 125 1 2037645168 32902512 18787376
20:36:37 8885 8192000000 10966971776 11382542336 1993268208 19.570 100 66 129 3 2046564496 33847712 19448576
20:36:53 8370 8192000000 10950685184 11379384320 1996076960 19.592 100 61 122 1 2046263984 31110384 19076640
20:37:09 3496 8192000000 10957225952 11380371456 1997515056 19.603 100 68 134 2 2048076112 30852992 19708064
20:37:21 13507 8192000000 10940609456 11374948352 1991380256 19.555 100 60 118 4 2040304192 30578480 18345456
20:37:45 6270 8192000000 10955903104 11387949056 1997622256 19.604 100 55 107 3 2048498592 34087680 16788656
20:37:59 9404 8192000000 10949186560 11383128064 1990741936 19.550 100 49 98 0 2041512736 34798880 15971920
20:38:17 9946 8192000000 10964706400 11388059648 1979962608 19.464 99 53 107 1 2035092272 37676624 17453040
20:38:34 3271 8192000000 10971920352 11395067904 1997825888 19.606 100 66 132 0 2057407024 38153504 21427632
20:38:43 2826 8192000000 10989362528 11410821120 2009023536 19.694 100 83 159 4 2073860944 40255664 24581744
20:38:52 1698 8192000000 10975909136 11397251072 1987947312 19.528 99 85 170 1 2052877408 39306640 25623456
20:39:01 3487 8192000000 10969110832 11393896448 1986495360 19.516 99 73 146 1 2049408496 40441376 22471760
20:39:17 5860 8192000000 10974920064 11396247552 1997711872 19.605 100 72 142 1 2061020656 41449520 21859264
20:39:32 4853 8192000000 10976723136 11396255744 1985207600 19.506 99 73 144 0 2049180288 41811840 22160848
20:39:47 4323 8192000000 10977447008 11401056256 2003374496 19.649 100 79 154 0 2070806512 42905376 24526640
20:40:01 3942 8192000000 10957523072 11364278272 1967427616 19.365 98 84 168 2 2031177248 37758864 25990768
20:40:13 1950 8192000000 10979098880 11398356992 1998406448 19.610 100 76 151 1 2060392832 38352048 23634336
20:40:24 4731 8192000000 10978255248 11406422016 2004193808 19.656 100 70 139 0 2066149968 40183904 21772256
20:40:37 6800 8192000000 10963729280 11397505024 1998765152 19.613 100 62 125 0 2059243152 40385088 20092912
20:40:52 17493 8192000000 10962454048 11394306048 1980764064 19.471 99 49 97 0 2036181888 39374176 16043648
20:41:22 3515 8192000000 10969215392 11402002432 1979878128 19.464 99 53 106 0 2046555760 48970640 17706992
20:41:35 3600 8192000000 10991546784 11406090240 2003174336 19.648 100 73 147 0 2070564320 43143104 24246880
20:41:47 7891 8192000000 10995082576 11423465472 2010885200 19.708 100 75 150 3 2085528704 50466368 24177136
20:42:09 9843 8192000000 10987508160 11420225536 1993578800 19.572 99 66 132 1 2063305088 48386496 21339792
20:42:28 4348 8192000000 10956672080 11383267328 1978373056 19.452 99 65 128 3 2044502320 45028736 21100528
20:42:41 3553 8192000000 10973513984 11403767808 1999499408 19.619 100 59 118 2 2063958160 44442320 20016432
20:42:51 2664 8192000000 10973487008 11390779392 1974242880 19.419 99 82 164 2 2039991520 39958112 25790528
20:43:07 10852 8192000000 10935701696 11370340352 1961032976 19.314 99 58 116 0 2018842544 39302896 18506672
20:43:29 6718 8192000000 10933382176 11360690176 1963500480 19.334 100 68 136 0 2024064464 38520000 22043984
20:43:46 3726 8192000000 10943517968 11368833024 1970070976 19.386 100 70 139 0 2033166784 40836912 22258896
20:43:57 3086 8192000000 10960366208 11377721344 1977360832 19.444 100 76 150 1 2042477888 41914048 23203008
20:44:10 2397 8192000000 10966290992 11390304256 1986488976 19.516 100 75 150 1 2054110352 43361216 24260160
20:44:23 3333 8192000000 10948936320 11364405248 1949447088 19.222 98 70 140 0 2013368672 42524192 21397392
20:44:34 4107 8192000000 10949192960 11364769792 1963968448 19.338 99 75 150 0 2027258768 40160400 23129920
20:44:47 3060 8192000000 10960958864 11383652352 1984281360 19.499 100 70 138 0 2045891040 39892896 21716784
20:44:58 4053 8192000000 10960648144 11391496192 1990367072 19.547 100 56 113 0 2049930672 41625376 17938224
20:45:09 2627 8192000000 10955772512 11384082432 1975445392 19.429 99 77 155 1 2043525184 43317104 24762688
20:45:19 2889 8192000000 10979168928 11394015232 1988633456 19.533 100 91 181 1 2061552880 44763920 28155504
20:45:29 2151 8192000000 10983612672 11399286784 1994740912 19.581 100 81 162 0 2067462352 47786992 24934448
20:45:37 2818 8192000000 10968674608 11380314112 1962607360 19.327 99 87 172 0 2038608672 49225296 26776016
20:45:46 9364 8192000000 10937953008 11371462656 1966144608 19.355 100 60 120 1 2035386480 50064416 19177456
20:46:02 9457 8192000000 10928406912 11367616512 1956207584 19.276 100 44 88 1 2017867872 46948368 14711920
20:46:19 6821 8192000000 10938117216 11364265984 1946245344 19.197 99 47 94 0 2010474576 47890448 16338784
20:46:34 8799 8192000000 10956521344 11385659392 1975481728 19.429 100 59 118 2 2046651904 51872608 19297568
20:47:06 8608 8192000000 10953862496 11393302528 1973158592 19.410 100 37 74 2 2037025312 50887664 12979056
20:47:22 8377 8192000000 10949691808 11384053760 1956516624 19.278 99 41 82 2 2020982400 50614496 13851280
20:47:45 9306 8192000000 10933553904 11367084032 1953607920 19.255 99 37 74 1 2015366624 49224112 12534592
20:48:02 9903 8192000000 10952925824 11382857728 1970307264 19.388 100 49 98 1 2036589360 50580816 15701280
20:48:19 5354 8192000000 10968773312 11393818624 1977091168 19.442 100 62 122 0 2050438864 54079280 19268416
20:48:34 11775 8192000000 10919697888 11360505856 1922229440 19.005 98 42 84 1 1992955856 56692576 14033840
20:48:53 15675 8192000000 10946852608 11374841856 1951798880 19.241 100 40 80 0 2021444096 56308064 13337152
20:49:16 7450 8192000000 10953913168 11380539392 1958332816 19.293 100 51 102 2 2034418224 59226656 16858752
20:49:30 9878 8192000000 10953836672 11386822656 1948786496 19.217 99 48 96 0 2026539280 61990560 15762224
20:49:52 13346 8192000000 10938052832 11379748864 1942154000 19.164 99 42 84 0 2023859696 66702608 15003088
20:50:24 11648 8192000000 10955498560 11396124672 1956588816 19.279 100 39 78 1 2035131264 64773920 13768528
20:50:43 14707 8192000000 10953681616 11396657152 1961706528 19.320 100 46 92 1 2046415712 68490272 16218912
20:51:08 2503 8192000000 10957536784 11384664064 1946594816 19.199 99 58 118 0 2034423840 68369264 19459760
20:51:20 9911 8192000000 10960867744 11395674112 1961352400 19.317 100 45 89 2 2043179792 66522864 15304528
20:51:36 31767 8192000000 10937172752 11400265728 1944461280 19.182 99 34 68 2 2027146112 70004384 12680448
20:52:15 24349 8192000000 10933270336 11386343424 1949268896 19.221 100 23 45 1 2008854448 51538800 8046752
20:52:57 30689 8192000000 10928218480 11389681664 1945358192 19.189 100 21 42 1 2011147216 57021040 8767984
20:53:36 23232 8192000000 10929260704 11379326976 1950378096 19.229 100 24 48 1 2009447168 50556960 8512112
20:54:06 36028 8192000000 10901956256 11377913856 1945649328 19.192 100 18 36 0 1998146096 46759360 5737408
20:54:53 40234 8192000000 10884575776 11369304064 1915474496 18.951 99 7 14 0 1951630544 33975808 2180240
20:56:24 50531 8192000000 10863518064 11308449792 1890387440 18.749 98 28 55 4 1906458048 8008496 8062112
20:57:29 31730 8192000000 10879097248 11331833856 1948077184 19.211 100 28 55 1 1965029728 9377136 7575408
20:59:17 168743 8192000000 10889109840 11353174016 1901472624 18.838 97 11 22 0 1916658400 12632016 2553760
21:02:15 117658 8192000000 10900041648 11354865664 1894461136 18.782 96 16 34 2 1910384368 12092896 3830336
21:04:24 92951 8192000000 10890063824 11346755584 1938939792 19.138 98 36 70 0 1960397824 10535120 10922912
21:06:03 86169 8192000000 10882098976 11344228352 1920923056 18.994 98 27 54 4 1947939408 18975168 8041184
21:07:41 47351 8192000000 10905732640 11360890880 1972307472 19.404 100 30 61 1 1990438208 9634512 8496224
21:08:43 2724 8192000000 10906094464 11365191680 1975096528 19.426 100 23 46 1 1990146000 8643440 6406032
21:09:29 43150 8192000000 10931639280 11388190720 1973695776 19.415 99 15 30 1 1987716736 9752128 4268832
21:10:19 26073 8192000000 10942824464 11388358656 1992324992 19.562 100 47 96 0 2018782384 12046272 14411120
21:10:54 29232 8192000000 10936676144 11394347008 1996591072 19.596 100 53 107 1 2026217472 13921408 15704992
21:11:32 14100 8192000000 10940521408 11395428352 1997435344 19.603 100 47 93 3 2023954880 14006608 12512928
21:11:53 18354 8192000000 10926107504 11398754304 1995304864 19.586 100 31 62 0 2018615568 14195216 9115488
21:12:23 24910 8192000000 10910666720 11376308224 1930661728 19.072 97 10 20 0 1942735200 9410688 2662784
21:12:55 36489 8192000000 10900729664 11370016768 1964982016 19.346 99 14 28 1 1978786592 9597488 4207088
21:13:40 38954 8192000000 10890841152 11359416320 1935732048 19.113 98 12 24 0 1949995792 11387632 2876112
21:14:27 36099 8192000000 10895110384 11375624192 1968965104 19.377 100 11 22 1 1984011632 12121136 2925392
21:15:13 66085 8192000000 10900365712 11372310528 1940911216 19.154 98 17 34 1 1955608624 9668048 5029360
21:16:27 57460 8192000000 10894429696 11367165952 1952867632 19.249 99 20 40 1 1973974016 14776544 6329840
21:17:31 69706 8192000000 10897168032 11367809024 1944587792 19.183 99 29 59 0 1971496000 18324816 8583392
21:18:46 27720 8192000000 10868821376 11339288576 1904270880 18.861 97 14 28 3 1915485488 7400256 3814352
21:19:30 72633 8192000000 10880666336 11364024320 1966603856 19.358 100 17 34 0 1982017776 10830256 4583664
21:20:49 39986 8192000000 10883906528 11375181824 1965620896 19.351 100 5 10 0 1978274368 11252048 1401424
21:21:52 63346 8192000000 10888425136 11370180608 1937690448 19.128 98 10 20 1 1947415552 7046976 2678128
21:23:03 34011 8192000000 10895375376 11373060096 1961780368 19.320 99 36 70 1 1983861456 12448272 9632816
21:23:43 40725 8192000000 10911126464 11386621952 1969205136 19.379 99 26 52 1 1986662096 9731712 7725248
21:24:42 29322 8192000000 10918336224 11384012800 1971093808 19.394 99 25 50 2 1991265136 12886208 7285120
21:25:20 32673 8192000000 10901687808 11363889152 1949218592 19.220 99 32 64 2 1975381264 17049152 9113520
21:26:02 35220 8192000000 10907201232 11371360256 1969090672 19.378 100 22 44 0 1990512352 15371856 6049824
21:26:47 37909 8192000000 10891085984 11357306880 1933047680 19.091 98 18 36 0 1952508672 13978624 5482368
21:27:33 41302 8192000000 10903379664 11371872256 1916030016 18.955 97 23 46 0 1944099408 22173856 5895536
21:28:24 54503 8192000000 10905538208 11369267200 1923036272 19.011 98 25 49 1 1948757440 18778704 6942464
21:29:38 60520 8192000000 10876752128 11344719872 1879214048 18.659 96 12 24 0 1902262096 19955456 3092592
21:30:54 50132 8192000000 10850865040 11314065408 1806454928 18.067 93 19 38 0 1821925776 10227664 5243184
21:31:50 44079 8192000000 10881456944 11335081984 1917917904 18.970 99 29 58 3 1940499568 13738496 8843168
21:32:53 47412 8192000000 10857719424 11336261632 1874615216 18.622 97 16 32 1 1898493952 19523952 4354784
21:33:46 55959 8192000000 10898830288 11345637376 1932005552 19.083 99 36 72 2 1953100528 11322352 9772624
21:34:49 16746 8192000000 10898992624 11356348416 1956171856 19.276 100 43 85 1 1979691584 10740544 12779184
21:35:13 11179 8192000000 10907961712 11349037056 1937733776 19.129 99 44 86 3 1959903040 10409152 11760112
21:35:33 120436 8192000000 10865960224 11332145152 1913455440 18.934 98 38 75 1 1937227520 13022704 10749376
21:37:58 55824 8192000000 10855912816 11333984256 1929434192 19.062 100 10 20 1 1943418400 11262464 2721744
21:41:14 22726 8192000000 10869825696 11334393856 1946858720 19.201 100 37 72 4 1963993840 7004400 10130720
21:41:55 38384 8192000000 10862508960 11342065664 1945946656 19.194 100 14 27 0 1956061264 6286624 3827984
21:43:21 67835 8192000000 10868094560 11349061632 1938894848 19.138 99 15 30 0 1956407056 13441968 4070240
21:45:43 38230 8192000000 10849119008 11317989376 1882644112 18.686 97 16 32 2 1902202960 14969984 4588864
21:46:28 50619 8192000000 10865477904 11337342976 1925580736 19.032 99 27 54 0 1945182944 11756112 7846096
21:47:25 39136 8192000000 10860581344 11318853632 1889674384 18.743 97 25 50 0 1910124384 12762688 7687312
21:48:14 70778 8192000000 10882002816 11364220928 1949298336 19.221 100 19 38 0 1973370480 17971360 6100784
21:49:31 94251 8192000000 10880493968 11367178240 1954390800 19.261 100 23 46 0 1979986352 19392112 6203440
21:51:13 44546 8192000000 10887354480 11356561408 1919910272 18.986 98 17 34 3 1937352992 12835456 4607264
21:52:08 68104 8192000000 10907758768 11397627904 1960340352 19.309 100 23 46 2 1984291760 17559856 6391552
21:54:19 73456 8192000000 10903721520 11370196992 1944711056 19.184 99 20 40 1 1966273648 16394544 5168048
21:55:39 86756 8192000000 10893364272 11359297536 1864671072 18.541 95 14 28 0 1888119712 19997856 3450784
21:57:12 102536 8192000000 10889248912 11348840448 1945573744 19.191 99 26 52 1 1963190832 10270016 7347072
21:59:01 68572 8192000000 10886096048 11361914880 1935745424 19.113 98 22 44 0 1952771248 10607280 6418544
22:00:17 27110 8192000000 10895662336 11368771584 1970131664 19.386 100 27 52 1 1987618720 9543184 7943872
22:00:50 78569 8192000000 10879773552 11361112064 1925856768 19.034 98 13 26 1 1940150176 10739104 3554304
22:02:15 59437 8192000000 10901056592 11384270848 1967221856 19.363 100 8 16 0 1978821680 9653920 1945904
22:03:24 66772 8192000000 10891328752 11370524672 1943980304 19.179 98 15 30 0 1959946112 11254368 4711440
22:04:39 73912 8192000000 10905955984 11383554048 1943495824 19.175 98 32 64 1 1972584608 20020000 9068784
22:06:01 42410 8192000000 10937616896 11400732672 1965350800 19.349 99 23 46 0 1985385520 13393664 6641056
22:06:52 22957 8192000000 10942176016 11394052096 1979091696 19.458 99 44 88 1 2007795296 15540128 13163472
22:07:21 77977 8192000000 10919557888 11413688320 1992683184 19.565 100 27 55 2 2017560480 16237552 8639744
22:08:53 63505 8192000000 10893497120 11360604160 1879793824 18.663 95 7 14 1 1891165456 9676128 1695504
22:10:04 22470 8192000000 10911917616 11373400064 1970276016 19.388 100 28 56 1 1985958544 8138384 7544144
22:10:44 24053 8192000000 10924541232 11384692736 1984830768 19.503 100 37 74 5 2007421232 12258096 10332368
22:11:19 63510 8192000000 10904842528 11386884096 1963667280 19.335 99 20 40 0 1981150240 12160816 5322144
22:12:29 57661 8192000000 10931305280 11399761920 1951255888 19.236 98 18 36 0 1971887344 15554016 5077440
22:13:47 75850 8192000000 10897434944 11376922624 1896612912 18.799 96 10 20 0 1920924384 21453920 2857552
22:15:12 12287 8192000000 10931745808 11381415936 1982258640 19.483 100 43 84 1 1999962240 5969824 11733776
22:15:34 94334 8192000000 10877205760 11339616256 1881556960 18.678 95 38 76 0 1900379840 8165664 10657216
22:17:25 36647 8192000000 10864849904 11335106560 1915713136 18.952 98 16 32 2 1928156096 7687840 4755120
22:18:09 17115 8192000000 10880799216 11343912960 1936034592 19.115 99 28 55 2 1953901440 10055008 7811840
22:18:33 48182 8192000000 10870331360 11347378176 1917810528 18.969 98 22 44 0 1936311680 12245136 6256016
22:21:15 60730 8192000000 10870533648 11345235968 1890643920 18.751 97 9 18 1 1905373232 12059088 2670224
22:22:27 72589 8192000000 10889416400 11370135552 1930452176 19.070 99 13 26 0 1950686880 16126368 4108336
22:23:46 58032 8192000000 10856945216 11336466432 1868817712 18.575 96 8 16 0 1886749536 15539472 2392352
22:24:52 44817 8192000000 10851591184 11326730240 1852157408 18.440 95 23 46 1 1869989296 10320720 7511168
22:26:16 40758 8192000000 10869508752 11339210752 1925395376 19.030 99 20 40 0 1943611408 12447472 5768560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-11-2020 22:28:30 to 14-11-2020 22:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-11-2020 22:29:02 to 14-11-2020 22:29:04.

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          237089
MON$OLDEST_ACTIVE               239552
MON$OLDEST_SNAPSHOT             239552
MON$NEXT_TRANSACTION            239552
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                       2047648
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:92: 
:93: mscs-test-161.budzdorov.ru    Sat Nov 14 22:27:05 2020
:94:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:95: 
:96: 
:97: mscs-test-161.budzdorov.ru    Sat Nov 14 22:27:05 2020
:98:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:99: 
:100: 
:101: mscs-test-161.budzdorov.ru    Sat Nov 14 22:27:11 2020
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:103: 
--- end of diff output ---

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

14.11.20 22:29:05. 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-14 22:29:07 No severe PSQL-related problems occured
14.11.20 22:29:08. End of report.