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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-19 16:27:15
DTS_END                         2021-01-19 16:27:15.8380
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/42554
TRN_ID                          242104
ATT_ID                          644
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: 8868.89 20782 1064267
customer order: creation 175.64 355 21077
customer order: refuse 14.82 366 1778
order to supplier: creation 46.97 1342 5636
order to supplier: removal 3.35 105916 402
invoice (draft): creation 47.41 3829 5689
invoice (draft): removal 50.75 788 6090
invoice accept: apply 41.14 18907 4937
invoice accept: cancel 45.58 973 5470
customer reserve: creation 3742.29 190 449075
customer reserve: removal 4399.35 64 527922
realization accept: apply 85.47 181 10256
realization accept: cancel 85.18 118 10222
payment from customer: creation 58.96 112 7075
payment from customer: removal 5.96 95 715
payment to supplier: creation 49.66 121 5959
payment to supplier: removal 3.92 74 470
service: total inventory turnovers 4.84 1169 581
service: total monetary turnovers 6.76 28 811
service: aggregate perf. data 0.82 19965 98
service: refresh index statistics 0.03 261041 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-01-2021 16:28:25 to 19-01-2021 16:28:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2101
TEST_TIME 2 2477
TEST_TIME 3 4069
TEST_TIME 4 4415
TEST_TIME 5 4279
TEST_TIME 6 4678
TEST_TIME 7 5229
TEST_TIME 8 5041
TEST_TIME 9 5028
TEST_TIME 10 5399
TEST_TIME 11 5782
TEST_TIME 12 5809
TEST_TIME 13 6526
TEST_TIME 14 6876
TEST_TIME 15 6987
TEST_TIME 16 7498
TEST_TIME 17 7942
TEST_TIME 18 8020
TEST_TIME 19 8611
TEST_TIME 20 8777
TEST_TIME 21 9170
TEST_TIME 22 9357
TEST_TIME 23 9409
TEST_TIME 24 9763
TEST_TIME 25 9607
TEST_TIME 26 9761
TEST_TIME 27 9829
TEST_TIME 28 10105
TEST_TIME 29 10272
TEST_TIME 30 10541
TEST_TIME 31 10523
TEST_TIME 32 10489
TEST_TIME 33 10303
TEST_TIME 34 10272
TEST_TIME 35 10143
TEST_TIME 36 10040
TEST_TIME 37 9861
TEST_TIME 38 9765
TEST_TIME 39 9900
TEST_TIME 40 9734
TEST_TIME 41 9673
TEST_TIME 42 9522
TEST_TIME 43 9431
TEST_TIME 44 9500
TEST_TIME 45 9463
TEST_TIME 46 9315
TEST_TIME 47 9247
TEST_TIME 48 9224
TEST_TIME 49 9150
TEST_TIME 50 9256
TEST_TIME 51 9135
TEST_TIME 52 9039
TEST_TIME 53 8954
TEST_TIME 54 8885
TEST_TIME 55 8819
TEST_TIME 56 8748
TEST_TIME 57 8732
TEST_TIME 58 8764
TEST_TIME 59 8758
TEST_TIME 60 8731
TEST_TIME 61 8691
TEST_TIME 62 8700
TEST_TIME 63 8779
TEST_TIME 64 9011
TEST_TIME 65 8996
TEST_TIME 66 8960
TEST_TIME 67 8921
TEST_TIME 68 8949
TEST_TIME 69 8961
TEST_TIME 70 9039
TEST_TIME 71 9172
TEST_TIME 72 9121
TEST_TIME 73 9148
TEST_TIME 74 9100
TEST_TIME 75 8987
TEST_TIME 76 8958
TEST_TIME 77 8963
TEST_TIME 78 8937
TEST_TIME 79 8936
TEST_TIME 80 8925
TEST_TIME 81 8914
TEST_TIME 82 8912
TEST_TIME 83 8878
TEST_TIME 84 8824
TEST_TIME 85 8801
TEST_TIME 86 8797
TEST_TIME 87 8837
TEST_TIME 88 8811
TEST_TIME 89 8872
TEST_TIME 90 8914
TEST_TIME 91 8930
TEST_TIME 92 8938
TEST_TIME 93 8995
TEST_TIME 94 8966
TEST_TIME 95 8962
TEST_TIME 96 9024
TEST_TIME 97 9015
TEST_TIME 98 9070
TEST_TIME 99 9081
TEST_TIME 100 9083
TEST_TIME 101 9037
TEST_TIME 102 9010
TEST_TIME 103 9019
TEST_TIME 104 8989
TEST_TIME 105 8978
TEST_TIME 106 8941
TEST_TIME 107 8937
TEST_TIME 108 8929
TEST_TIME 109 8881
TEST_TIME 110 8856
TEST_TIME 111 8822
TEST_TIME 112 8810
TEST_TIME 113 8849
TEST_TIME 114 8814
TEST_TIME 115 8962
TEST_TIME 116 8964
TEST_TIME 117 8951
TEST_TIME 118 8922
TEST_TIME 119 8927
TEST_TIME 120 8875

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-01-2021 16:28:28 to 19-01-2021 16:28:32.

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 1480546 1480546 0 0.00 0 20796 7 0 0
doc_list_biud 1480546 1480546 0 0.00 0 37223 29 0 0
sp_add_invoice_to_stock 4991 4937 54 1.08 49 192924 18908 0 54
sp_cancel_adding_invoice 5470 5470 0 0.00 5 75852 974 0 0
sp_cancel_client_order 1778 1778 0 0.00 4 15763 367 0 0
sp_cancel_customer_reserve 527922 527922 0 0.00 1 26916 65 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 2 9004 96 0 0
sp_cancel_pay_to_supplier 470 470 0 0.00 3 4700 75 0 0
sp_cancel_supplier_invoice 6096 6090 6 0.09 2 20507 789 0 6
sp_cancel_supplier_order 402 402 0 0.00 10 893009 105917 0 0
sp_cancel_write_off 10222 10222 0 0.00 1 9264 118 0 0
sp_client_order 21077 21077 0 0.00 3 20540 355 0 0
sp_customer_reserve 449075 449075 0 0.00 0 38885 190 0 0
sp_fill_shopping_cart 32385 32385 0 0.00 1 40359 44 0 0
sp_fill_shopping_cart_clo_res 449067 449067 0 0.00 0 18067 14 0 0
sp_get_clo_for_invoice 4928 4928 0 0.00 0 30266 361 0 0
sp_kill_cost_storno 16877 16877 0 0.00 0 11184 60 0 0
sp_kill_qstorno_ret_qs2qd 1072558 1072558 0 0.00 0 28893 35 0 0
sp_kill_qty_storno 567067 567067 0 0.00 0 37223 76 0 0
sp_lock_selected_doc 21141 21141 0 0.00 0 9271 7 0 0
sp_make_cost_storno 28217 28217 0 0.00 0 9882 49 0 0
sp_multiply_rows_for_pdistr 28217 28217 0 0.00 0 20757 32 0 0
sp_multiply_rows_for_qdistr 21077 21077 0 0.00 0 20513 172 0 0
sp_pay_from_customer 7075 7075 0 0.00 3 11303 112 0 0
sp_pay_to_supplier 5959 5959 0 0.00 4 20801 122 0 0
sp_payment_common 13034 13034 0 0.00 1 13369 27 0 0
sp_qd_handle_on_cancel_clo 1778 1778 0 0.00 0 15756 340 0 0
sp_qd_handle_on_invoice_upd_sts 10397 10397 0 0.00 0 37222 375 0 0
sp_qd_handle_on_reserve_upd_sts 10256 10256 0 0.00 0 12283 61 0 0
sp_reserve_write_off 10256 10256 0 0.00 6 12304 182 0 0
sp_supplier_invoice 5689 5689 0 0.00 5 103764 3830 0 0
sp_supplier_order 5636 5636 0 0.00 5 38825 1343 0 0
srv_aggregate_perf_data 98 98 0 0.00 2308 167372 19966 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 897 130282 30412 0 0
srv_find_qd_qs_mism 1016707 1016707 0 0.00 0 14904 6 0 0
srv_make_invnt_saldo 581 581 0 0.00 34 123507 1170 0 0
srv_make_money_saldo 811 811 0 0.00 1 1235 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 218947 330038 261042 0 0
t$perf-abend:sp_add_invoice_to_stock 54 54 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4937 4937 0 0.00 0 10519 176 0 0
t$perf-norm:sp_cancel_adding_invoice 453 453 0 0.00 0 4727 101 0 0
t$perf-norm:sp_cancel_client_order 1778 1778 0 0.00 0 9223 23 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 3785 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 908 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 470 470 0 0.00 0 437 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 735 18 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 21990 1792 0 0
t$perf-norm:sp_cancel_write_off 1028 1028 0 0.00 0 8819 13 0 0
t$perf-norm:sp_client_order 21077 21077 0 0.00 0 16919 20 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 6533 16 0 0
t$perf-norm:sp_pay_from_customer 7075 7075 0 0.00 0 17000 15 0 0
t$perf-norm:sp_pay_to_supplier 5959 5959 0 0.00 0 17004 20 0 0
t$perf-norm:sp_reserve_write_off 10256 10256 0 0.00 0 6728 12 0 0
t$perf-norm:sp_supplier_invoice 5689 5689 0 0.00 0 11955 28 0 0
t$perf-norm:sp_supplier_order 5636 5636 0 0.00 0 6351 19 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 2154 32 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 3042 27 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 4989 34 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 470 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 9962 9854 108 1.08 0 8010 16 0 108
v_all_customers 37722 37722 0 0.00 0 38 1 0 0
v_all_suppliers 31010 31010 0 0.00 0 59 1 0 0
v_all_wares 42154 42154 0 0.00 0 106 1 0 0
v_cancel_adding_invoice 906 906 0 0.00 0 1910 12 0 0
v_cancel_client_order 3556 3556 0 0.00 0 3622 6 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 1995 6 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 8099 11 0 0
v_cancel_payment_to_supplier 940 940 0 0.00 0 4687 12 0 0
v_cancel_supplier_invoice 806 794 12 1.48 0 2764 20 0 12
v_cancel_supplier_order 804 804 0 0.00 0 3353 7 0 0
v_cancel_write_off 2056 2056 0 0.00 0 3479 15 0 0
v_max_id_clo_ord 5634 5634 0 0.00 0 812 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 2758 18 0 0
v_max_id_ord_sup 5674 5674 0 0.00 0 5655 7 0 0
v_max_non_paid_invoice 1762 1762 0 0.00 0 710 3 0 0
v_max_non_paid_realizn 4017 4017 0 0.00 0 8362 6 0 0
v_min_id_clo_ord 5634 5634 0 0.00 0 4428 7 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 3101 11 0 0
v_min_id_ord_sup 5674 5674 0 0.00 0 5850 9 0 0
v_min_non_paid_invoice 5959 5959 0 0.00 0 13364 14 0 0
v_min_non_paid_realizn 7075 7075 0 0.00 0 11293 16 0 0
v_our_firm 10548 10548 0 0.00 0 13 1 0 0
v_reserve_write_off 20512 20512 0 0.00 0 8736 5 0 0
x_lock_depdocs_on_canc_invoice 11163 11163 0 0.00 0 16107 124 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 7166 359 0 0
x_make_qstorno_1000_1200 5636 5636 0 0.00 2 38818 1262 0 0
x_make_qstorno_1200_2000 5689 5689 0 0.00 2 103721 3658 0 0
x_make_qstorno_2100_3300 449075 449075 0 0.00 0 38883 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-01-2021 16:28:33 to 19-01-2021 16:28:37.

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:19 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:26 19083 8192000000 10260595856 10575691776 1131360064 12.134 87 64 129 0 1155760720 3000032 21400624
13:57:57 34371 8192000000 10367988912 10691055616 1416076576 14.738 100 85 170 0 1448492736 5233984 27182176
13:58:43 40023 8192000000 10414825600 10743431168 1459493920 15.121 100 86 172 1 1494718864 7293136 27931808
13:59:35 5345 8192000000 10424457616 10754502656 1481498096 15.315 100 89 178 0 1518879632 8674480 28707056
13:59:52 20076 8192000000 10438021392 10770718720 1486109584 15.355 100 89 176 1 1524064016 9129248 28825184
14:00:21 18726 8192000000 10456243376 10790707200 1504998464 15.520 100 91 182 1 1544257216 9698688 29560064
14:00:52 26221 8192000000 10485738848 10826481664 1537114096 15.799 100 91 182 1 1576612112 10756080 28741936
14:01:39 12446 8192000000 10500440608 10848886784 1556219888 15.964 100 80 159 0 1592601232 11611664 24769680
14:02:07 13939 8192000000 10530915920 10885427200 1593406624 16.283 100 87 174 1 1631242784 11299984 26536176
14:02:29 10798 8192000000 10558469664 10914910208 1611940192 16.441 100 82 164 1 1649161872 12051472 25170208
14:02:49 11097 8192000000 10578551872 10935693312 1635253952 16.639 100 85 171 0 1673395584 12770992 25370640
14:03:08 8568 8192000000 10593320448 10954166272 1645194528 16.724 100 84 168 2 1683348976 13055456 25098992
14:03:26 13444 8192000000 10609811728 10973216768 1662378496 16.869 100 84 167 0 1700226160 13103136 24744528
14:03:48 8018 8192000000 10617338272 10985062400 1674335184 16.970 100 78 153 0 1709931984 13201248 22395552
14:04:03 8366 8192000000 10628822112 10996719616 1691790672 17.116 100 82 162 1 1728765936 13131232 23844032
14:04:20 8728 8192000000 10652245056 11019935744 1707728896 17.250 100 91 182 1 1747859776 13755136 26375744
14:04:37 6518 8192000000 10655122240 11031769088 1713248880 17.296 100 76 152 0 1748974448 13796544 21929024
14:04:50 7104 8192000000 10671464608 11046670336 1735097008 17.478 100 82 165 2 1771562704 12800992 23664704
14:05:05 4994 8192000000 10679462672 11054448640 1740303456 17.521 100 79 158 0 1776504016 13208096 22992464
14:05:17 5788 8192000000 10685812784 11063812096 1749678800 17.599 100 83 164 1 1786453248 13920144 22854304
14:05:29 4566 8192000000 10691044448 11071254528 1757462832 17.663 100 80 160 1 1793303344 13301616 22538896
14:05:40 3666 8192000000 10708510784 11088240640 1764971648 17.725 100 89 178 2 1803992336 14165600 24855088
14:05:51 2848 8192000000 10712787664 11090055168 1774917328 17.808 100 85 168 1 1812873632 13197168 24759136
14:06:00 3370 8192000000 10717585744 11096363008 1777817536 17.831 100 87 175 1 1816740752 14459920 24463296
14:06:09 2465 8192000000 10729146000 11109253120 1784893504 17.890 100 90 176 0 1824218144 14330368 24994272
14:06:18 2568 8192000000 10735730288 11112267776 1794386048 17.968 100 95 189 1 1835018720 13885360 26747312
14:06:28 2594 8192000000 10737548928 11119611904 1801902304 18.030 100 89 178 0 1840385216 13512272 24970640
14:06:38 7526 8192000000 10739873744 11130834944 1805301856 18.057 100 74 146 2 1837211872 11663472 20246544
14:06:52 4710 8192000000 10756685184 11143712768 1808619968 18.085 100 81 162 0 1843661408 12103280 22938160
14:07:03 1395 8192000000 10772810912 11153645568 1828613648 18.248 100 93 185 1 1868838592 14208352 26016592
14:07:11 2351 8192000000 10775955168 11161944064 1831546928 18.272 100 88 176 0 1870562384 14176368 24839088
14:07:20 2232 8192000000 10778699920 11168366592 1837316576 18.319 100 85 170 0 1875058912 14075328 23667008
14:07:29 2012 8192000000 10781703552 11169636352 1843669392 18.371 100 92 185 0 1883220624 13668576 25882656
14:07:37 2287 8192000000 10793542112 11180040192 1845204128 18.383 100 87 171 1 1883154688 14162800 23787760
14:07:46 1422 8192000000 10794974608 11179884544 1849737536 18.420 100 90 179 3 1886702288 11972160 24992592
14:07:53 2262 8192000000 10804012192 11188264960 1854652256 18.460 100 93 187 1 1894626336 13073040 26901040
14:08:02 1266 8192000000 10801531216 11187953664 1857260768 18.481 100 94 186 1 1896363680 13380000 25722912
14:08:10 2004 8192000000 10800401328 11194683392 1861754592 18.518 100 86 173 0 1898796880 11833120 25209168
14:08:18 5347 8192000000 10784858368 11197292544 1862562480 18.524 100 74 148 0 1895663024 12065168 21035376
14:08:46 17539 8192000000 10801558832 11196518400 1864947456 18.543 100 62 126 2 1890336288 7771584 17617248
14:09:10 23368 8192000000 10766535008 11200520192 1862573376 18.524 100 39 78 1 1881323424 8388928 10361120
14:09:39 7113 8192000000 10762845488 11192311808 1861269776 18.514 100 30 60 0 1876114816 5205952 9639088
14:09:57 12142 8192000000 10783045520 11203674112 1863852688 18.535 100 28 56 1 1878166176 6416128 7897360
14:10:19 8138 8192000000 10783657360 11209502720 1872655152 18.606 100 35 71 4 1890693136 7874064 10163920
14:10:34 6893 8192000000 10790367328 11210960896 1872173776 18.602 100 32 65 2 1888307840 7371680 8762384
14:10:48 8739 8192000000 10784688160 11210555392 1870683552 18.590 100 25 50 2 1883558736 5201760 7673424
14:11:06 9574 8192000000 10788652272 11219582976 1874152080 18.618 100 19 38 0 1885962336 6787936 5022320
14:11:25 6705 8192000000 10791633440 11221221376 1880913728 18.672 100 24 48 1 1898451744 10671600 6866416
14:11:40 4410 8192000000 10784129072 11215798272 1880422544 18.669 100 23 46 0 1893698960 5725184 7551232
14:11:52 12305 8192000000 10790582336 11220332544 1881782752 18.680 100 17 34 1 1892519520 5974992 4761776
14:12:13 14321 8192000000 10791853872 11218939904 1881850432 18.680 100 17 34 0 1892699712 5992672 4856608
14:12:35 12812 8192000000 10788714032 11221671936 1885064592 18.706 100 20 40 0 1897057776 6163872 5829312
14:12:55 73231 8192000000 10793795344 11232514048 1888517104 18.734 100 32 64 2 1903100416 5518256 9065056
14:14:19 7763 8192000000 10815037424 11239608320 1892787360 18.768 100 35 70 2 1909572912 6554528 10231024
14:14:33 19132 8192000000 10816605936 11242541056 1878360016 18.652 99 28 56 1 1895430176 9250016 7820144
14:14:59 5685 8192000000 10817154064 11242627072 1893179344 18.771 100 35 69 3 1909441184 6817968 9443872
14:15:11 6555 8192000000 10802060496 11234975744 1876137392 18.634 99 45 90 3 1896675216 7980224 12557600
14:15:25 6831 8192000000 10808895696 11240611840 1890139440 18.747 100 21 42 0 1902955232 6565600 6250192
14:15:42 12366 8192000000 10795024256 11227197440 1867813568 18.567 99 24 46 2 1879951936 5348736 6789632
14:16:01 7603 8192000000 10788673072 11226906624 1867775552 18.566 99 25 50 1 1881715696 7361536 6578608
14:16:15 7910 8192000000 10788776032 11224051712 1863585024 18.532 99 18 36 0 1874138832 5200208 5353600
14:16:31 6402 8192000000 10795272336 11210948608 1838343488 18.327 98 34 66 2 1854235264 6081040 9810736
14:16:45 11509 8192000000 10762734624 11195699200 1831013296 18.268 98 18 36 0 1841598016 5185632 5399088
14:17:05 8729 8192000000 10764238480 11197030400 1812089312 18.113 97 14 28 0 1821556064 5234032 4232720
14:17:23 12506 8192000000 10768981104 11205058560 1828710704 18.249 98 14 28 0 1838423792 5925024 3788064
14:17:46 68095 8192000000 10715652912 11147677696 1691010016 17.110 91 28 54 1 1704013152 4922096 8081040
14:19:03 11691 8192000000 10721345248 11146194944 1757072112 17.660 96 18 37 1 1766865216 4916176 4876928
14:19:22 4537 8192000000 10741167056 11159146496 1806547776 18.068 99 37 74 1 1824550512 7678720 10324016
14:19:36 6256 8192000000 10712268288 11125293056 1722987296 17.377 95 20 40 1 1734673920 5569152 6117472
14:19:50 7269 8192000000 10722120080 11141099520 1763022992 17.709 97 28 57 1 1777028640 6127808 7877840
14:20:05 9619 8192000000 10735841408 11154690048 1801398352 18.025 99 24 48 1 1813526240 5186736 6941152
14:20:21 6444 8192000000 10739675040 11166060544 1826970608 18.235 100 13 26 0 1836227056 5418416 3838032
14:20:34 6266 8192000000 10701255168 11124899840 1773696656 17.798 98 23 46 1 1787380976 6449648 7234672
14:20:49 8498 8192000000 10728074944 11139969024 1764503760 17.722 97 17 34 1 1774978352 5360512 5114080
14:21:06 8718 8192000000 10718619024 11128786944 1749569968 17.598 96 23 46 1 1761760384 5431408 6759008
14:21:21 5066 8192000000 10708606688 11121266688 1762769184 17.707 97 29 58 0 1777528720 6033696 8725840
14:21:34 5837 8192000000 10713262448 11131346944 1772017360 17.784 98 25 50 2 1784328576 4730144 7581072
14:21:46 9500 8192000000 10719270256 11142905856 1790747008 17.938 99 39 78 0 1813656032 11262240 11646784
14:22:03 8875 8192000000 10710691520 11133448192 1777874192 17.832 98 27 54 2 1791679328 5305296 8499840
14:22:18 6134 8192000000 10731718016 11154849792 1817367824 18.156 100 18 36 0 1828387360 5711488 5308048
14:22:33 65518 8192000000 10799193440 11189182464 1842407632 18.360 100 41 80 0 1860773200 6403840 11961728
14:23:44 9421 8192000000 10759219088 11185418240 1843500400 18.369 100 19 38 0 1855028800 6083296 5445104
14:24:00 6114 8192000000 10766931040 11193540608 1852538176 18.443 100 35 70 2 1868383328 5683136 10162016
14:24:13 7403 8192000000 10774732128 11195920384 1855541264 18.467 100 26 52 2 1868904768 6184032 7179472
14:24:26 5801 8192000000 10783407664 11207712768 1865238992 18.546 100 44 87 1 1885474544 6823136 13412416
14:24:38 3719 8192000000 10785529376 11213213696 1868137456 18.569 100 35 70 1 1886034000 7872720 10023824
14:24:50 7887 8192000000 10793728016 11215118336 1875216544 18.626 100 31 62 0 1890758624 6284912 9257168
14:25:06 6502 8192000000 10774000240 11203956736 1855968704 18.471 99 30 60 1 1871172704 6218320 8985680
14:25:20 7164 8192000000 10793352432 11215585280 1870753584 18.590 100 22 42 2 1882037680 5359568 5924528
14:25:36 8240 8192000000 10791544656 11218882560 1879737952 18.663 100 33 63 4 1894492512 5216816 9537744
14:25:53 8873 8192000000 10811724656 11227492352 1884103552 18.698 100 47 93 4 1904461056 4935680 15421824
14:26:08 12290 8192000000 10806773296 11232915456 1885768240 18.712 100 35 71 0 1902016080 5625632 10622208
14:26:27 10600 8192000000 10804819968 11229413376 1884018064 18.698 100 20 40 2 1896103936 6418368 5667504
14:26:45 8188 8192000000 10805645520 11234258944 1886458864 18.717 100 23 48 2 1898574496 5303824 6811808
14:27:00 129421 8192000000 10841604592 11272560640 1910716928 18.912 100 32 63 1 1928863920 8552704 9594288
14:29:18 24055 8192000000 10857747680 11284353024 1929419360 19.062 100 33 66 1 1948244784 8893376 9932048
14:29:52 14011 8192000000 10874312464 11298426880 1941894864 19.162 100 44 86 3 1965706528 10752624 13059040
14:30:15 21364 8192000000 10867263376 11298779136 1928191792 19.052 99 47 94 2 1954931024 12104624 14634608
14:30:45 12814 8192000000 10879904880 11309948928 1949170368 19.220 100 48 96 1 1975361680 12372400 13818912
14:31:10 4966 8192000000 10891111184 11319394304 1956169120 19.276 100 56 112 0 1985122144 13092144 15860880
14:31:30 21389 8192000000 10892555664 11319795712 1954190720 19.260 100 39 78 0 1977754624 12354992 11208912
14:31:58 22277 8192000000 10901373104 11325726720 1963850272 19.337 100 46 90 2 1989467552 12813744 12803536
14:32:28 8491 8192000000 10914015280 11339489280 1971370304 19.396 100 59 118 0 2005205808 17032992 16802512
14:33:03 8632 8192000000 10916175152 11344334848 1975946192 19.433 100 61 121 0 2011826736 17498912 18381632
14:33:27 15337 8192000000 10919873888 11344379904 1958351360 19.293 99 52 104 1 1993808736 19386912 16070464
14:33:58 9842 8192000000 10914660608 11347001344 1973032736 19.409 100 43 86 0 2004186848 17472880 13681232
14:34:15 24500 8192000000 10914806304 11344084992 1956687344 19.280 99 44 86 1 1988174144 17933520 13553280
14:34:49 9376 8192000000 10893823456 11324297216 1951570192 19.239 99 41 80 0 1979539472 16364560 11604720
14:35:06 16913 8192000000 10907719824 11342757888 1964318560 19.340 100 43 84 2 1993502272 16769232 12414480
14:35:36 11361 8192000000 10926491136 11356880896 1977223296 19.443 100 42 84 0 2011429456 21517248 12688912
14:36:04 9667 8192000000 10928660960 11364065280 1986822272 19.519 100 50 100 2 2020741936 18695232 15224432
14:36:26 8339 8192000000 10932043856 11356270592 1970953248 19.393 99 63 126 1 2010098352 20299648 18845456
14:36:42 2755 8192000000 10939284432 11365888000 1988784240 19.534 100 61 122 0 2028586224 21478176 18323808
14:36:51 8488 8192000000 10950640992 11373256704 1991632576 19.557 100 60 120 1 2032301680 22218224 18450880
14:37:08 5317 8192000000 10954079440 11380203520 1982441648 19.484 99 57 114 1 2022634624 22323520 17869456
14:37:26 6910 8192000000 10959621472 11389366272 2001578112 19.635 100 59 118 0 2046772608 26691760 18502736
14:37:44 3458 8192000000 10966789792 11386146816 2006694960 19.675 100 64 123 0 2048655200 22086512 19873728
14:37:54 4308 8192000000 10948537280 11371405312 1989100272 19.537 99 66 129 1 2031934160 23466064 19367824
14:38:07 9522 8192000000 10947682208 11380498432 1986757888 19.518 99 58 116 0 2028407584 23484368 18165328
14:38:24 4016 8192000000 10954996960 11383951360 1999583488 19.619 100 62 124 1 2042644240 24685696 18375056
14:38:35 7080 8192000000 10971810960 11389865984 2003675728 19.652 100 78 156 0 2053311776 25936288 23699760
14:38:50 22502 8192000000 10957215600 11396841472 2003322704 19.649 100 54 108 2 2044760816 24524432 16913680
14:39:25 5980 8192000000 10956802544 11387117568 1985461200 19.508 99 55 107 2 2029227344 27375600 16390544
14:39:39 5083 8192000000 10951794160 11384283136 1993170304 19.569 100 59 118 0 2041831168 29600672 19060192
14:39:53 3780 8192000000 10962563216 11381678080 1974335104 19.420 99 64 128 1 2026098736 31781104 19982528
14:40:05 2561 8192000000 10979942432 11398807552 2004774960 19.660 100 85 167 1 2063947856 33479808 25693088
14:40:15 1950 8192000000 10996909856 11415420928 2014480192 19.737 100 87 176 0 2075626144 34305264 26840688
14:40:24 1952 8192000000 10975177168 11399757824 1993953552 19.575 99 74 146 2 2049004880 32465008 22586320
14:40:33 4442 8192000000 10971509856 11399233536 2004799472 19.661 100 69 138 2 2056410432 30905024 20705936
14:40:45 2086 8192000000 10977552672 11397279744 2004942448 19.662 100 76 152 3 2060948992 33222288 22784256
14:40:56 1670 8192000000 10967299600 11377012736 1983023760 19.489 99 89 175 1 2041880016 31888576 26967680
14:41:04 1459 8192000000 10952019056 11368787968 1982640224 19.486 99 87 174 2 2040873040 32098096 26134720
14:41:13 2745 8192000000 10955412672 11366137856 1962602192 19.327 98 85 168 0 2021701568 33848512 25250864
14:41:24 4029 8192000000 10964310784 11380367360 1972978048 19.409 99 86 172 3 2032958800 33818192 26162560
14:41:35 1482 8192000000 10961341776 11379183616 1985607088 19.509 100 89 179 0 2047581552 34484752 27489712
14:41:43 2160 8192000000 10979446752 11396788224 1999294160 19.617 100 86 170 1 2060042416 34821936 25926320
14:41:52 2703 8192000000 10978086944 11392712704 1993430016 19.571 100 86 173 0 2055009248 34811856 26767376
14:42:03 1587 8192000000 10949586256 11361202176 1951050592 19.235 98 80 160 1 2008837488 34054928 23731968
14:42:11 2407 8192000000 10957520208 11368009728 1976280592 19.435 100 90 180 3 2036149536 33438768 26430176
14:42:22 5043 8192000000 10950931888 11373285376 1977358304 19.444 100 83 166 3 2039078512 36085520 25634688
14:42:34 1881 8192000000 10950214480 11367108608 1961266512 19.316 99 82 162 1 2022188912 36043760 24878640
14:42:43 2737 8192000000 10953161120 11370168320 1975154768 19.426 100 83 166 2 2036999616 35602912 26241936
14:42:55 3592 8192000000 10934841328 11347562496 1953793072 19.257 99 82 163 2 2016527712 36835456 25899184
14:43:05 1260 8192000000 10935582992 11351330816 1951275040 19.237 100 82 163 0 2013918704 36909488 25734176
14:43:13 3066 8192000000 10931696592 11341819904 1951404752 19.238 100 89 178 1 2010039712 31262464 27372496
14:43:26 4176 8192000000 10909030848 11319934976 1931028544 19.075 99 72 144 1 1984655760 31109024 22518192
14:43:44 4549 8192000000 10937065552 11354886144 1962424432 19.325 100 72 144 1 2017135152 33086160 21624560
14:43:56 4628 8192000000 10938249328 11350016000 1960955984 19.314 100 76 149 2 2016742256 33263136 22523136
14:44:09 3114 8192000000 10934191920 11346432000 1938568240 19.135 99 78 155 1 1996908528 34688592 23651696
14:44:21 8871 8192000000 10905036288 11339321344 1928626480 19.056 99 49 98 0 1978586944 34290672 15669792
14:44:46 12291 8192000000 10884599536 11320668160 1924313824 19.021 99 32 64 3 1968894960 33711120 10870016
14:45:06 15419 8192000000 10891530064 11324592128 1909651392 18.904 99 33 66 2 1956675936 35714576 11309968
14:45:32 4508 8192000000 10899455536 11315007488 1922270736 19.005 99 63 125 3 1972877360 30737056 19869568
14:45:43 3997 8192000000 10942880128 11349155840 1957540640 19.286 100 86 172 2 2018804960 34551840 26712480
14:45:55 3913 8192000000 10933073840 11352457216 1943443632 19.174 99 76 152 1 2004094960 37028464 23622864
14:46:06 5878 8192000000 10940562464 11363827712 1962237088 19.324 100 70 140 3 2019252576 35722448 21293040
14:46:19 2367 8192000000 10933171152 11339153408 1937879120 19.130 98 90 180 1 2000554064 34959376 27715568
14:46:31 4255 8192000000 10920623648 11333517312 1943953296 19.178 99 69 139 0 1998586384 33166256 21466832
14:46:42 5406 8192000000 10904956064 11328503808 1939477664 19.143 99 56 112 2 1986377056 28973280 17926112
14:46:54 2741 8192000000 10915576864 11341180928 1949824416 19.225 100 56 111 0 1997251120 30023184 17403520
14:47:04 10028 8192000000 10899483248 11328958464 1931500736 19.079 99 43 87 1 1974584192 29059536 14023920
14:47:20 4700 8192000000 10920117808 11336146944 1948258112 19.213 100 58 115 0 1993954128 27383984 18312032
14:47:33 5124 8192000000 10945964192 11363934208 1970624912 19.390 100 76 152 0 2025958208 32042128 23291168
14:47:46 1887 8192000000 10953672832 11362594816 1953552976 19.255 99 73 143 0 2009062064 33146320 22362768
14:47:55 4583 8192000000 10934807904 11360903168 1949661792 19.224 99 63 125 2 2005527168 36101808 19763568
14:48:08 2636 8192000000 10937723184 11357196288 1956396096 19.277 100 62 122 1 2012092736 36285072 19411568
14:48:20 895 8192000000 10954285920 11365072896 1967600960 19.366 100 78 152 3 2026736624 34286080 24849584
14:48:27 6811 8192000000 10910223472 11343364096 1933988048 19.099 98 64 128 4 1985933136 32122272 19822816
14:48:40 10520 8192000000 10920355632 11358187520 1959768896 19.304 100 39 75 3 2001058256 29019184 12270176
14:48:57 17020 8192000000 10921263824 11366432768 1966051600 19.354 100 38 76 0 2010197488 31595216 12550672
14:49:22 14346 8192000000 10897053728 11346493440 1933443472 19.094 99 38 77 1 1979556928 33114256 12999200
14:50:01 9475 8192000000 10888909360 11329355776 1932359824 19.086 100 41 81 3 1977692192 32223056 13109312
14:50:19 8067 8192000000 10900315072 11336953856 1935486448 19.111 100 34 68 2 1981207712 33944448 11776816
14:50:39 5111 8192000000 10895691744 11326922752 1926258848 19.037 99 50 100 2 1979690384 36530736 16900800
14:50:51 8609 8192000000 10919752544 11357048832 1950904576 19.234 100 43 85 3 2002732416 38254880 13572960
14:51:08 21888 8192000000 10925324944 11363774464 1966720672 19.359 100 44 88 3 2012100976 31315568 14064736
14:51:37 6465 8192000000 10932624912 11369041920 1966932528 19.361 100 54 104 2 2013162640 29425072 16805040
14:51:55 17031 8192000000 10920905904 11362013184 1961006912 19.314 100 30 60 1 1998195072 27651296 9536864
14:52:28 11668 8192000000 10920290416 11355066368 1927291792 19.045 98 33 66 0 1969617632 31405440 10920400
14:52:50 3003 8192000000 10924818272 11350675456 1943545216 19.175 99 48 93 2 1992466544 33233824 15687504
14:52:59 17091 8192000000 10925758064 11370999808 1959989664 19.306 100 35 70 1 2009062784 37136656 11936464
14:53:26 12562 8192000000 10938428768 11379650560 1967560784 19.366 100 34 67 1 2017747440 39023104 11163552
14:53:53 23461 8192000000 10938010704 11376664576 1968416640 19.373 100 35 69 4 2019623920 39229664 11977616
14:54:28 45061 8192000000 10909479632 11368607744 1921973216 19.003 98 34 66 1 1974681200 40887504 11820480
14:55:27 40346 8192000000 10886471344 11358892032 1946040528 19.195 100 16 32 1 1988053520 36115824 5897168
14:56:41 18860 8192000000 10896356720 11363454976 1944709312 19.184 100 20 40 2 1983913504 32328016 6876176
14:57:19 54340 8192000000 10883210112 11338792960 1926067552 19.035 99 17 32 1 1952765152 22221120 4476480
14:58:20 21871 8192000000 10884669168 11343699968 1948168976 19.212 100 20 40 0 1970211056 16174624 5867456
14:58:48 28964 8192000000 10875239632 11335512064 1936770880 19.121 99 17 34 1 1954794832 13196080 4827872
15:00:08 49825 8192000000 10893780768 11344179200 1945131680 19.188 99 32 64 1 1965932544 11361008 9439856
15:01:06 63976 8192000000 10880106640 11348062208 1960012816 19.306 100 9 18 0 1973805712 11234224 2558672
15:02:17 98641 8192000000 10886581968 11349557248 1923334832 19.014 98 11 22 0 1937843040 11228320 3279888
15:04:02 118516 8192000000 10906353728 11363037184 1978625200 19.454 100 23 48 0 1999591200 14221248 6744752
15:06:08 88402 8192000000 10912397536 11364679680 1971771680 19.399 100 15 31 1 1995621648 18991456 4858512
15:07:47 64703 8192000000 10901548000 11365707776 1979110944 19.458 100 26 50 0 1996397632 9887808 7398880
15:08:59 48881 8192000000 10907637232 11367309312 1967157408 19.363 99 17 34 0 1980623312 8705072 4760832
15:09:54 67724 8192000000 10916953216 11369639936 1978644096 19.454 100 34 65 1 2000102448 11984304 9474048
15:11:10 81150 8192000000 10884470864 11357904896 1941912912 19.162 98 30 60 0 1961210624 10388080 8909632
15:12:38 78569 8192000000 10899026592 11351433216 1943238800 19.173 98 23 45 1 1957524048 8055520 6229728
15:14:09 1811 8192000000 10919227200 11359477760 1980680208 19.470 100 50 102 2 2003538000 8386080 14471712
15:14:17 8111 8192000000 10915181552 11365191680 1979217488 19.459 100 36 71 0 1998460864 9268080 9975296
15:14:36 3643 8192000000 10932365920 11371192320 1991353328 19.554 100 59 120 3 2017966448 8582096 18031024
15:14:49 24999 8192000000 10924143216 11381764096 1993152208 19.569 100 40 81 1 2015246352 10778736 11315408
15:15:25 43599 8192000000 10903201360 11354370048 1956204544 19.276 98 28 56 2 1974015216 9218768 8591904
15:16:15 25336 8192000000 10921606256 11375427584 1972227904 19.403 99 42 85 1 1994872944 10939968 11705072
15:16:47 33193 8192000000 10895969776 11379617792 1979060480 19.457 100 13 26 0 1996342928 13335968 3946480
15:17:31 34457 8192000000 10884445712 11365687296 1943603040 19.175 98 6 12 0 1952835696 7586528 1646128
15:18:12 65655 8192000000 10885275536 11349053440 1940803232 19.153 98 8 17 0 1949298032 6521568 1973232
15:19:31 64157 8192000000 10882522192 11359547392 1960325552 19.309 99 11 22 0 1972005072 8270832 3408688
15:21:47 45297 8192000000 10867377120 11343433728 1931598976 19.080 98 12 24 1 1941498288 6655072 3244240
15:22:41 56312 8192000000 10878122272 11347456000 1943393664 19.174 99 10 20 0 1952458272 6756368 2308240
15:23:47 51136 8192000000 10846309232 11315310592 1903922160 18.858 97 14 26 1 1914974304 7065008 3987136
15:24:44 37405 8192000000 10886859904 11354513408 1945890160 19.194 99 19 37 1 1961281376 9534672 5856544
15:25:34 31838 8192000000 10881163680 11344809984 1939629408 19.144 99 16 32 0 1951889136 7243952 5015776
15:26:12 49970 8192000000 10878345184 11344510976 1904004560 18.858 97 26 51 2 1919211296 7402832 7803904
15:27:13 60021 8192000000 10912633584 11370479616 1899056784 18.819 96 21 42 0 1921557712 16594912 5906016
15:28:26 31697 8192000000 10892038800 11356999680 1934229840 19.101 98 19 38 0 1960341904 20642512 5469552
15:29:14 89053 8192000000 10898762960 11362398208 1892110048 18.763 96 18 36 1 1921301232 23926240 5264944
15:31:34 56642 8192000000 10861558816 11317190656 1864957776 18.543 96 14 28 0 1880923968 12222080 3744112
15:32:45 51554 8192000000 10871344416 11330822144 1889749536 18.744 97 28 54 3 1907760208 10152064 7858608
15:33:57 18131 8192000000 10898908864 11344896000 1937626192 19.128 99 31 62 1 1955083232 8115440 9341600
15:34:23 13402 8192000000 10924817904 11358961664 1967510192 19.366 100 56 110 0 1992045024 9438112 15096720
15:34:44 21725 8192000000 10913249296 11357175808 1965913680 19.353 100 44 86 2 1988726320 11062240 11750400
15:35:28 27857 8192000000 10904687072 11356794880 1941441184 19.158 99 40 80 1 1968317744 15898672 10977888
15:36:02 30587 8192000000 10908328784 11362037760 1965338864 19.348 100 35 70 0 1991281248 16456336 9486048
15:37:31 112278 8192000000 10904330784 11390808064 1957782816 19.288 99 5 10 0 1986728832 26828592 2117424
15:39:31 35964 8192000000 10859075552 11311067136 1811643712 18.109 92 16 32 1 1822391760 6892256 3855792
15:40:14 76230 8192000000 10858759424 11325804544 1915175008 18.948 99 14 28 1 1932237664 12443824 4618832
15:41:37 77086 8192000000 10882317392 11329437696 1942088096 19.163 100 27 54 2 1959041616 9125536 7827984
15:43:00 54000 8192000000 10889248992 11336982528 1915219552 18.949 98 31 62 0 1935174400 9606880 10347968
15:44:02 21645 8192000000 10905440000 11346329600 1952057760 19.243 100 60 120 1 1982222880 13365104 16800016
15:44:37 68918 8192000000 10857467712 11318910976 1917481968 18.967 98 27 54 1 1933794064 9038640 7273456
15:45:52 13557 8192000000 10890086384 11342405632 1958439760 19.294 100 38 75 0 1980342608 11200000 10702848
15:46:14 63026 8192000000 10841585296 11309252608 1855487824 18.467 95 15 30 0 1871710928 11693152 4529952
15:47:33 90750 8192000000 10860136832 11320045568 1856756432 18.477 96 10 20 0 1875374992 15831264 2787296
15:49:12 86405 8192000000 10832937264 11310075904 1860179488 18.505 96 6 12 0 1870357392 8586736 1591168
15:50:45 22361 8192000000 10837756848 11314647040 1925921904 19.034 100 6 12 0 1936978528 9478512 1578112
15:51:14 2868 8192000000 10838128272 11314884608 1925763712 19.033 100 4 8 0 1936132656 9407840 961104
15:51:26 29547 8192000000 10861600112 11329744896 1935007408 19.107 100 6 12 0 1949326368 12701664 1617296
15:52:15 62823 8192000000 10873830144 11345469440 1940500736 19.151 100 9 17 1 1954430400 11461952 2467712
15:54:09 36989 8192000000 10875573392 11335372800 1932006416 19.083 99 28 57 3 1951845440 11293760 8545264
15:54:58 45693 8192000000 10888781456 11348295680 1952446416 19.246 100 16 32 2 1970082032 12416416 5219200
15:55:50 65897 8192000000 10882144496 11354652672 1916100944 18.956 98 14 29 0 1938588784 18241680 4246160
15:57:24 84495 8192000000 10872083584 11333791744 1897365104 18.805 97 18 36 1 1911893312 9128816 5399392
15:58:57 75010 8192000000 10898260224 11351425024 1919446240 18.982 98 16 32 2 1937826224 14036448 4343536
16:00:21 77516 8192000000 10889169792 11349815296 1920705232 18.992 98 20 40 0 1940424624 14200752 5518640
16:01:46 55464 8192000000 10900090288 11357925376 1946283440 19.197 99 45 90 2 1974162272 15069312 12809520
16:03:07 69435 8192000000 10910033968 11368919040 1969417904 19.381 100 28 56 0 1988185280 11149872 7617504
16:04:24 39780 8192000000 10931041472 11383009280 1981479696 19.476 100 30 60 0 1998563584 8978048 8105840
16:05:10 41130 8192000000 10925064160 11385442304 1962814352 19.328 99 28 56 1 1985796576 15118576 7863648
16:06:03 115706 8192000000 10904894704 11380178944 1827425072 18.238 92 19 38 1 1847478624 14472208 5581344
16:08:06 130282 8192000000 10884061648 11356004352 1926367952 19.038 98 21 42 1 1954180016 21381152 6430912
16:10:29 62188 8192000000 10901748512 11350765568 1955621296 19.271 100 35 70 2 1972108784 7244720 9242768
16:11:37 25723 8192000000 10902657872 11356823552 1962804640 19.328 100 35 70 1 1983106016 9867584 10433792
16:12:23 32673 8192000000 10897138896 11365081088 1952085792 19.243 99 15 30 1 1969758544 13880752 3792000
16:13:10 39148 8192000000 10879540208 11356700672 1964871392 19.345 100 6 12 0 1976329600 9692768 1765440
16:13:56 55247 8192000000 10868714992 11339894784 1911046032 18.915 97 10 20 0 1922961168 9257840 2657296
16:14:58 64653 8192000000 10881824768 11356827648 1929833232 19.066 98 14 28 0 1944699376 9850176 5015968
16:16:22 53452 8192000000 10868624880 11333885952 1915544944 18.951 98 9 18 2 1929598832 11197328 2856560
16:17:30 66118 8192000000 10868899520 11324727296 1886930864 18.721 97 22 44 0 1907275520 13617024 6727632
16:18:50 49326 8192000000 10866370928 11339853824 1937462080 19.126 100 19 38 0 1963433024 19693440 6277504
16:20:12 79807 8192000000 10886239440 11343556608 1900345536 18.829 97 21 43 0 1926374224 19609424 6419264
16:21:42 84280 8192000000 10868265360 11353866240 1907993792 18.891 98 23 46 1 1937539872 22944688 6601392
16:23:13 78896 8192000000 10852757024 11307438080 1848125280 18.407 95 11 22 1 1861619936 10903840 2590816
16:24:38 47875 8192000000 10872354176 11332276224 1908229920 18.892 98 32 64 1 1926470704 9657712 8583072
16:25:32 45874 8192000000 10903664320 11357020160 1950383264 19.230 100 24 48 0 1968148960 11128624 6637072
16:26:33 51695 8192000000 9333184816 9606217728 486984608 5.611 25 11 19 1 496430208 6475088 2970512

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 54 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          241919
MON$OLDEST_ACTIVE               243493
MON$OLDEST_SNAPSHOT             243493
MON$NEXT_TRANSACTION            243493
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                       2025376
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:54: 
:55: mscs-test-161.budzdorov.ru    Tue Jan 19 16:27:39 2021
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
--- end of diff output ---

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

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