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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17249672 kB
MemAvailable 31348660 kB
Buffers 0 kB
Cached 14405260 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-09 16:27:11
DTS_END                         2021-01-09 16:27:11.4670
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60936
TRN_ID                          242049
ATT_ID                          624
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: 9603.73 20025 1152447
customer order: creation 184.18 365 22102
customer order: refuse 15.18 323 1822
order to supplier: creation 48.03 1434 5764
order to supplier: removal 3.62 98534 434
invoice (draft): creation 48.04 3364 5765
invoice (draft): removal 55.08 798 6609
invoice accept: apply 42.86 15871 5143
invoice accept: cancel 49.63 736 5955
customer reserve: creation 3964.91 155 475789
customer reserve: removal 4880.90 56 585708
realization accept: apply 88.24 173 10589
realization accept: cancel 87.48 92 10498
payment from customer: creation 61.66 110 7399
payment from customer: removal 5.77 57 692
payment to supplier: creation 51.94 122 6233
payment to supplier: removal 3.73 92 447
service: total inventory turnovers 5.01 934 601
service: total monetary turnovers 6.56 33 787
service: aggregate perf. data 0.88 22448 106
service: refresh index statistics 0.03 254805 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-01-2021 16:28:29 to 09-01-2021 16:28:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5264
TEST_TIME 2 4952
TEST_TIME 3 4800
TEST_TIME 4 5034
TEST_TIME 5 4825
TEST_TIME 6 5088
TEST_TIME 7 5428
TEST_TIME 8 5745
TEST_TIME 9 6739
TEST_TIME 10 6746
TEST_TIME 11 7037
TEST_TIME 12 7092
TEST_TIME 13 7237
TEST_TIME 14 7246
TEST_TIME 15 7639
TEST_TIME 16 8031
TEST_TIME 17 7927
TEST_TIME 18 7953
TEST_TIME 19 8294
TEST_TIME 20 8704
TEST_TIME 21 8843
TEST_TIME 22 9312
TEST_TIME 23 9684
TEST_TIME 24 9451
TEST_TIME 25 9447
TEST_TIME 26 9705
TEST_TIME 27 10988
TEST_TIME 28 11199
TEST_TIME 29 10989
TEST_TIME 30 11037
TEST_TIME 31 10961
TEST_TIME 32 10756
TEST_TIME 33 10915
TEST_TIME 34 10730
TEST_TIME 35 10571
TEST_TIME 36 10573
TEST_TIME 37 10348
TEST_TIME 38 10348
TEST_TIME 39 10264
TEST_TIME 40 10188
TEST_TIME 41 10249
TEST_TIME 42 10192
TEST_TIME 43 10106
TEST_TIME 44 9998
TEST_TIME 45 9864
TEST_TIME 46 9733
TEST_TIME 47 9737
TEST_TIME 48 9678
TEST_TIME 49 9636
TEST_TIME 50 9603
TEST_TIME 51 9691
TEST_TIME 52 9817
TEST_TIME 53 9811
TEST_TIME 54 9725
TEST_TIME 55 9775
TEST_TIME 56 9840
TEST_TIME 57 9970
TEST_TIME 58 9965
TEST_TIME 59 9926
TEST_TIME 60 9969
TEST_TIME 61 9908
TEST_TIME 62 9794
TEST_TIME 63 9801
TEST_TIME 64 9740
TEST_TIME 65 9662
TEST_TIME 66 9669
TEST_TIME 67 9621
TEST_TIME 68 9631
TEST_TIME 69 9689
TEST_TIME 70 9668
TEST_TIME 71 9732
TEST_TIME 72 9685
TEST_TIME 73 9718
TEST_TIME 74 9838
TEST_TIME 75 9777
TEST_TIME 76 9920
TEST_TIME 77 9937
TEST_TIME 78 9996
TEST_TIME 79 10005
TEST_TIME 80 9927
TEST_TIME 81 9868
TEST_TIME 82 9835
TEST_TIME 83 9796
TEST_TIME 84 9815
TEST_TIME 85 9741
TEST_TIME 86 9707
TEST_TIME 87 9657
TEST_TIME 88 9615
TEST_TIME 89 9628
TEST_TIME 90 9663
TEST_TIME 91 9661
TEST_TIME 92 9691
TEST_TIME 93 9665
TEST_TIME 94 9716
TEST_TIME 95 9807
TEST_TIME 96 9802
TEST_TIME 97 9812
TEST_TIME 98 9788
TEST_TIME 99 9763
TEST_TIME 100 9894
TEST_TIME 101 9889
TEST_TIME 102 9916
TEST_TIME 103 9882
TEST_TIME 104 9795
TEST_TIME 105 9777
TEST_TIME 106 9799
TEST_TIME 107 9760
TEST_TIME 108 9776
TEST_TIME 109 9731
TEST_TIME 110 9774
TEST_TIME 111 9758
TEST_TIME 112 9703
TEST_TIME 113 9630
TEST_TIME 114 9581
TEST_TIME 115 9594
TEST_TIME 116 9657
TEST_TIME 117 9679
TEST_TIME 118 9663
TEST_TIME 119 9647
TEST_TIME 120 9606

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-01-2021 16:28:33 to 09-01-2021 16:28:36.

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 1595057 1595057 0 0.00 0 18626 5 0 0
doc_list_biud 1595057 1595057 0 0.00 0 21544 27 0 0
sp_add_invoice_to_stock 5270 5143 127 2.40 23 206247 15871 0 127
sp_cancel_adding_invoice 5955 5955 0 0.00 4 65231 737 0 0
sp_cancel_client_order 1822 1822 0 0.00 4 10408 324 0 0
sp_cancel_customer_reserve 585708 585708 0 0.00 1 21546 57 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 2 3417 58 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 7967 92 0 0
sp_cancel_supplier_invoice 6618 6609 9 0.13 1 13401 798 0 9
sp_cancel_supplier_order 434 434 0 0.00 5 992817 98534 0 0
sp_cancel_write_off 10498 10498 0 0.00 1 7896 92 0 0
sp_client_order 22102 22102 0 0.00 3 16305 366 0 0
sp_customer_reserve 475789 475789 0 0.00 0 78654 156 0 0
sp_fill_shopping_cart 33624 33624 0 0.00 1 10375 36 0 0
sp_fill_shopping_cart_clo_res 475785 475785 0 0.00 0 16059 12 0 0
sp_get_clo_for_invoice 5139 5139 0 0.00 0 21810 292 0 0
sp_kill_cost_storno 17592 17592 0 0.00 0 7856 52 0 0
sp_kill_qstorno_ret_qs2qd 1188957 1188957 0 0.00 0 18493 31 0 0
sp_kill_qty_storno 626754 626754 0 0.00 0 21543 67 0 0
sp_lock_selected_doc 21825 21825 0 0.00 0 5586 4 0 0
sp_make_cost_storno 29360 29360 0 0.00 0 18615 54 0 0
sp_multiply_rows_for_pdistr 29360 29360 0 0.00 0 8038 27 0 0
sp_multiply_rows_for_qdistr 22102 22102 0 0.00 0 13671 176 0 0
sp_pay_from_customer 7399 7399 0 0.00 3 13027 111 0 0
sp_pay_to_supplier 6233 6233 0 0.00 4 15930 122 0 0
sp_payment_common 13632 13632 0 0.00 1 11013 25 0 0
sp_qd_handle_on_cancel_clo 1822 1822 0 0.00 0 10400 296 0 0
sp_qd_handle_on_invoice_upd_sts 11094 11094 0 0.00 0 15783 328 0 0
sp_qd_handle_on_reserve_upd_sts 10589 10589 0 0.00 0 10153 61 0 0
sp_reserve_write_off 10589 10589 0 0.00 6 15463 174 0 0
sp_supplier_invoice 5765 5765 0 0.00 6 74249 3364 0 0
sp_supplier_order 5764 5764 0 0.00 5 65692 1434 0 0
srv_aggregate_perf_data 106 106 0 0.00 2607 399406 22448 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1316 143081 32018 0 0
srv_find_qd_qs_mism 1103523 1103523 0 0.00 0 14621 4 0 0
srv_make_invnt_saldo 601 601 0 0.00 32 21950 935 0 0
srv_make_money_saldo 787 787 0 0.00 0 6331 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 166657 349033 254805 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5144 5144 0 0.00 0 11894 163 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 0 5495 91 0 0
t$perf-norm:sp_cancel_client_order 1822 1822 0 0.00 0 6506 19 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 3829 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 3797 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 554 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 1435 12 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 19080 1562 0 0
t$perf-norm:sp_cancel_write_off 1108 1108 0 0.00 0 3915 13 0 0
t$perf-norm:sp_client_order 22102 22102 0 0.00 0 5800 18 0 0
t$perf-norm:sp_customer_reserve 1085 1085 0 0.00 0 1230 5 0 0
t$perf-norm:sp_pay_from_customer 7399 7399 0 0.00 0 14612 15 0 0
t$perf-norm:sp_pay_to_supplier 6233 6233 0 0.00 0 14069 13 0 0
t$perf-norm:sp_reserve_write_off 10589 10589 0 0.00 0 5364 12 0 0
t$perf-norm:sp_supplier_invoice 5765 5765 0 0.00 0 7801 20 0 0
t$perf-norm:sp_supplier_order 5764 5764 0 0.00 0 9912 18 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 242 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 2203 31 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 6062 24 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 1129 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 96 26 0 0
v_add_invoice_to_stock 10532 10278 254 2.41 0 5253 17 0 254
v_all_customers 39858 39858 0 0.00 0 50 1 0 0
v_all_suppliers 32422 32422 0 0.00 0 131 1 0 0
v_all_wares 44204 44204 0 0.00 0 47 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 4669 16 0 0
v_cancel_client_order 3644 3644 0 0.00 0 3992 7 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 757 3 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 3512 6 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 1759 7 0 0
v_cancel_supplier_invoice 866 848 18 2.07 0 880 14 0 18
v_cancel_supplier_order 868 868 0 0.00 0 2837 8 0 0
v_cancel_write_off 2216 2216 0 0.00 0 3164 12 0 0
v_max_id_clo_ord 5764 5764 0 0.00 0 986 1 0 0
v_max_id_clo_res 1085 1085 0 0.00 0 1422 8 0 0
v_max_id_ord_sup 5756 5756 0 0.00 0 6672 6 0 0
v_max_non_paid_invoice 1542 1542 0 0.00 0 892 3 0 0
v_max_non_paid_realizn 4021 4021 0 0.00 0 486 2 0 0
v_min_id_clo_ord 5764 5764 0 0.00 0 1977 5 0 0
v_min_id_clo_res 1085 1085 0 0.00 0 3581 6 0 0
v_min_id_ord_sup 5756 5756 0 0.00 0 6714 7 0 0
v_min_non_paid_invoice 6233 6233 0 0.00 0 8083 14 0 0
v_min_non_paid_realizn 7399 7399 0 0.00 0 11006 18 0 0
v_our_firm 11102 11102 0 0.00 0 30 1 0 0
v_reserve_write_off 21178 21178 0 0.00 0 8093 8 0 0
x_lock_depdocs_on_canc_invoice 12140 12140 0 0.00 0 28691 112 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 5127 304 0 0
x_make_qstorno_1000_1200 5764 5764 0 0.00 2 65675 1362 0 0
x_make_qstorno_1200_2000 5765 5765 0 0.00 2 74235 3225 0 0
x_make_qstorno_2100_3300 475789 475789 0 0.00 0 78650 141 0 0

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

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:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 18840 8192000000 10261249936 10569461760 818669472 9.085 64 39 79 0 833613168 2122784 12820912
13:57:52 25234 8192000000 10356256080 10675240960 1400708320 14.601 100 84 168 0 1433515776 5195872 27611584
13:58:28 12569 8192000000 10375102096 10698702848 1434704192 14.903 100 88 176 0 1469362048 6278288 28379568
13:58:59 25782 8192000000 10421269360 10748760064 1465767232 15.177 100 87 175 0 1501037856 7356464 27914160
13:59:47 26246 8192000000 10451630768 10785157120 1499810240 15.475 100 81 162 0 1534184512 8624224 25750048
14:00:24 13590 8192000000 10458503136 10793369600 1515482800 15.611 100 91 182 0 1553326224 9112400 28731024
14:00:48 11983 8192000000 10468018016 10803884032 1519195488 15.643 100 83 166 0 1554745152 9319872 26229792
14:01:16 25770 8192000000 10505465968 10848550912 1547733504 15.890 100 81 162 0 1582493568 9958064 24802000
14:01:53 20678 8192000000 10517424720 10867347456 1574373104 16.120 100 80 160 0 1608837264 9953344 24510816
14:02:24 13213 8192000000 10547914848 10901372928 1603431104 16.369 100 79 158 0 1637711264 10490960 23789200
14:02:48 12709 8192000000 10573593616 10929184768 1628608336 16.583 100 85 169 1 1664912896 11252528 25052032
14:03:08 15699 8192000000 10595714768 10954821632 1651312816 16.775 100 86 172 0 1688757472 12244288 25200368
14:03:32 10753 8192000000 10604264528 10970124288 1656986144 16.823 100 82 164 0 1694187040 13103952 24096944
14:03:56 7971 8192000000 10630986176 10993422336 1681783632 17.032 100 82 164 0 1717220160 11938096 23498432
14:04:12 7565 8192000000 10626287136 10998374400 1689164192 17.094 100 73 146 2 1722713584 11991136 21558256
14:04:27 7038 8192000000 10642884096 11016884224 1710480288 17.273 100 78 156 1 1744743728 11750944 22512496
14:04:41 9065 8192000000 10654653040 11030704128 1719945664 17.352 100 73 146 2 1752262432 11477472 20839296
14:04:58 6165 8192000000 10673341312 11048689664 1734751744 17.475 100 78 156 2 1768794992 11893312 22149936
14:05:10 4675 8192000000 10687948880 11060068352 1748522768 17.589 100 82 164 0 1783720848 11874256 23323824
14:05:26 6355 8192000000 10693843472 11071311872 1755862624 17.650 100 77 154 1 1788792800 11321760 21608416
14:05:39 3698 8192000000 10703050192 11081379840 1764042864 17.718 100 81 161 2 1798934288 12220208 22671216
14:05:50 4786 8192000000 10719365584 11096518656 1778781936 17.839 100 90 179 1 1817496864 13449664 25265264
14:06:01 3715 8192000000 10732913472 11114115072 1790268640 17.934 100 84 168 1 1827441408 13387648 23785120
14:06:11 3449 8192000000 10735096272 11116646400 1795484352 17.977 100 85 170 0 1832045488 12434512 24126624
14:06:22 2893 8192000000 10736682080 11123113984 1799942192 18.013 100 87 173 1 1836567664 12303440 24322032
14:06:31 2320 8192000000 10739313584 11119378432 1803868112 18.046 100 85 169 0 1840380672 13214912 23297648
14:06:39 2872 8192000000 10751759424 11133386752 1810434640 18.099 100 91 182 0 1849494976 13747392 25312944
14:06:54 4826 8192000000 10759285968 11146809344 1811491536 18.108 100 69 138 1 1842440400 12537232 18411632
14:07:06 2361 8192000000 10767416544 11152998400 1829280720 18.253 100 81 160 0 1864111728 12374592 22456416
14:07:15 1864 8192000000 10779219280 11162537984 1834573696 18.297 100 92 186 2 1873145184 12514000 26057488
14:07:23 1872 8192000000 10783959312 11167862784 1840169264 18.342 100 89 178 1 1878828512 14129232 24530016
14:07:31 1875 8192000000 10797036192 11179077632 1845603472 18.386 100 95 190 2 1887567328 15660336 26303520
14:07:40 1329 8192000000 10787908208 11171934208 1846381504 18.393 100 97 195 1 1889304336 15651568 27271264
14:07:47 1915 8192000000 10795819040 11182243840 1856129248 18.472 100 91 181 0 1896209520 13928032 26152240
14:07:55 1545 8192000000 10799049360 11185078272 1853646480 18.452 100 93 185 4 1892960912 13853952 25460480
14:08:03 1122 8192000000 10795473984 11180539904 1856830768 18.478 100 96 191 1 1897135568 14012096 26292704
14:08:11 8393 8192000000 10769851072 11181281280 1852129808 18.439 100 60 120 0 1881752736 12737616 16885312
14:08:33 2287 8192000000 10795824384 11195420672 1861337248 18.514 100 80 158 1 1896128304 12737504 22053552
14:08:43 2755 8192000000 10787088768 11189788672 1858549008 18.492 100 55 108 1 1883333712 10440800 14343904
14:08:54 1770 8192000000 10796240128 11198087168 1862747984 18.526 100 69 139 0 1894723792 12323152 19652656
14:09:02 2797 8192000000 10790499424 11199840256 1867637648 18.565 100 61 122 1 1896042800 11339680 17065472
14:09:15 2203 8192000000 10790285968 11196850176 1870382224 18.587 100 57 111 0 1895245104 9270064 15592816
14:09:24 4220 8192000000 10795689152 11200741376 1868048960 18.568 100 53 106 1 1892752112 9881232 14821920
14:09:36 3029 8192000000 10810785024 11210305536 1877521088 18.645 100 63 126 0 1905330192 9251632 18557472
14:09:45 5604 8192000000 10787012096 11207344128 1867988720 18.568 100 32 64 2 1888436416 11394256 9053440
14:09:57 5728 8192000000 10785801696 11207262208 1873029104 18.609 100 41 81 2 1891537824 6214672 12294048
14:10:10 14686 8192000000 10770103952 11207667712 1872206864 18.602 100 17 34 1 1883812496 7133680 4471952
14:10:58 31539 8192000000 10824854640 11227475968 1881562560 18.678 100 65 131 0 1906812272 5821712 19428000
14:11:36 2159 8192000000 10813220848 11233468416 1890566288 18.750 100 66 132 1 1920425296 10852368 19006640
14:11:46 9276 8192000000 10794354976 11225051136 1881385248 18.676 100 21 43 1 1893227008 5986640 5855120
14:12:03 6584 8192000000 10797556672 11227189248 1886910016 18.721 100 31 62 1 1902724096 7509936 8304144
14:12:17 5784 8192000000 10810668400 11237068800 1893188560 18.771 100 30 60 2 1908170848 5941968 9040320
14:12:31 4940 8192000000 10809664656 11239845888 1896717120 18.800 100 30 60 1 1911288720 6098160 8473440
14:12:43 7217 8192000000 10798356784 11236081664 1893783024 18.776 100 23 46 2 1907001504 6985520 6232960
14:12:56 5417 8192000000 10818548176 11247095808 1894764608 18.784 100 23 46 0 1906261920 5279376 6217936
14:13:11 6910 8192000000 10810573792 11246292992 1899952256 18.826 100 28 57 1 1914953184 6564896 8436032
14:13:26 7311 8192000000 10811335792 11242807296 1900392960 18.829 100 30 60 1 1915369920 6295776 8681184
14:13:41 11270 8192000000 10809193264 11247685632 1898873984 18.817 100 15 31 1 1909045712 5987984 4183744
14:14:00 6878 8192000000 10812565120 11249512448 1902191568 18.844 100 24 48 2 1915348832 6204656 6952608
14:14:13 8013 8192000000 10823453920 11253997568 1904743360 18.864 100 30 60 0 1918545728 5630256 8172112
14:14:28 13568 8192000000 10820037024 11257974784 1906022704 18.875 100 21 42 3 1917446256 6069808 5353744
14:14:47 58566 8192000000 10844509088 11269894144 1909207264 18.900 100 32 65 2 1923245664 5613648 8424752
14:15:58 8472 8192000000 10811568784 11252244480 1903500400 18.854 100 15 30 0 1913155456 5226576 4428480
14:16:14 8243 8192000000 10811965488 11240394752 1892839040 18.769 99 30 60 1 1907629936 6596032 8194864
14:16:34 4779 8192000000 10824795856 11260661760 1907264352 18.885 100 30 60 0 1921618576 6579232 7774992
14:16:46 7958 8192000000 10813106320 11235987456 1861682896 18.517 98 32 64 1 1877832112 7279616 8869600
14:17:00 3773 8192000000 10803233248 11235647488 1889814256 18.744 100 31 62 2 1905590768 6622976 9153536
14:17:11 10797 8192000000 10805009632 11233038336 1875973456 18.633 99 27 54 1 1889739072 5448304 8317312
14:17:28 6103 8192000000 10811045648 11238653952 1888353264 18.733 100 23 46 2 1905097216 10044880 6699072
14:17:42 5267 8192000000 10799528304 11216297984 1848717232 18.412 98 25 48 2 1862107296 6284704 7105360
14:17:56 9484 8192000000 10765706768 11189690368 1834932448 18.300 98 24 48 0 1847994608 5704400 7357760
14:18:12 10949 8192000000 10750076032 11168108544 1760599024 17.689 95 24 48 1 1772963296 5436736 6927536
14:18:30 4508 8192000000 10727603440 11153002496 1780746848 17.856 97 16 32 0 1791508368 5961616 4799904
14:18:44 8370 8192000000 10713491136 11128258560 1703081072 17.211 93 25 49 0 1715126496 5179424 6866000
14:19:02 9296 8192000000 10683705984 11092328448 1697125040 17.161 94 29 56 1 1710975376 5284320 8566016
14:19:20 17380 8192000000 10665450224 11086741504 1690342960 17.104 94 23 46 2 1702057312 5401312 6313040
14:19:44 67872 8192000000 10695872608 11121143808 1763463280 17.713 98 29 58 1 1777960064 5846688 8650096
14:20:59 15262 8192000000 10724479648 11137757184 1763977344 17.717 97 31 60 1 1779805872 7285648 8542880
14:21:22 9223 8192000000 10681367792 11093147648 1730836432 17.442 96 25 51 2 1744137584 6074592 7226560
14:21:37 3474 8192000000 10701274208 11118649344 1745081040 17.561 97 34 68 0 1765541232 11355248 9104944
14:21:55 7051 8192000000 10703490672 11121922048 1784551568 17.887 100 28 54 1 1806818688 15136800 7130320
14:22:09 7713 8192000000 10702387808 11119075328 1764260256 17.720 98 20 40 2 1775950704 5674272 6016176
14:22:23 11467 8192000000 10719880096 11145117696 1804947728 18.054 100 21 42 1 1816560336 5655648 5956960
14:22:42 10181 8192000000 10753664976 11173650432 1830682096 18.265 100 22 45 3 1847102416 9575936 6844384
14:22:59 10593 8192000000 10745773648 11167854592 1817755056 18.159 99 33 66 0 1833899680 5736768 10407856
14:23:18 15102 8192000000 10760799536 11186143232 1846217040 18.391 100 29 58 2 1859766608 5178160 8371408
14:23:42 13183 8192000000 10768191408 11185483776 1832596656 18.281 99 35 70 2 1849368800 5243200 11528944
14:24:04 9851 8192000000 10763268864 11184930816 1829697520 18.257 99 25 50 0 1842547824 4639264 8211040
14:24:20 7556 8192000000 10762693536 11190452224 1851539968 18.435 100 25 50 1 1868839904 10193632 7106304
14:24:34 78618 8192000000 10771390784 11199684608 1859630112 18.500 100 28 56 0 1873560192 5316368 8613712
14:26:04 9948 8192000000 10775306016 11204538368 1863473008 18.531 100 26 48 2 1875299072 5405504 6420560
14:26:22 10353 8192000000 10787639312 11214397440 1866048704 18.552 100 29 58 2 1884488112 10491696 7947712
14:26:38 7676 8192000000 10782810144 11210268672 1869380608 18.579 100 35 70 2 1886793168 7635760 9776800
14:26:53 8117 8192000000 10775770608 11210338304 1868983936 18.576 100 34 68 2 1884638304 6115712 9538656
14:27:09 34176 8192000000 10816495584 11232063488 1885676416 18.711 100 26 52 0 1898224128 5054976 7492736
14:27:50 26097 8192000000 10837332656 11252838400 1902581104 18.847 100 47 94 1 1923615712 7272864 13761744
14:28:27 19081 8192000000 10845346688 11268653056 1917824880 18.969 100 48 95 1 1942747216 10955520 13966816
14:28:58 6646 8192000000 10843661936 11274461184 1919526528 18.983 100 35 70 1 1940283488 10630848 10126112
14:29:16 33422 8192000000 10861101424 11288489984 1929176256 19.060 100 35 70 1 1951591712 12341856 10073600
14:29:57 20993 8192000000 10881093648 11303682048 1944443248 19.182 100 50 98 1 1972173088 12910864 14818976
14:30:28 11804 8192000000 10875778912 11304255488 1944562384 19.183 100 39 79 2 1970836912 14963456 11311072
14:30:50 17389 8192000000 10884613584 11312300032 1952453120 19.246 100 45 89 1 1980804144 15019968 13331056
14:31:16 15359 8192000000 10895841136 11325014016 1956799952 19.281 100 44 88 1 1986214864 16413536 13001376
14:31:38 15461 8192000000 10906038752 11327451136 1961489104 19.318 100 40 76 0 1987960976 15557952 10913920
14:32:04 46238 8192000000 10904702832 11337805824 1968715072 19.375 100 49 98 0 2000595696 17379216 14501408
14:32:58 16853 8192000000 10908315248 11344003072 1966276896 19.356 100 41 80 0 2001485664 23973408 11235360
14:33:22 25826 8192000000 10908371920 11343556608 1971763088 19.399 100 58 116 0 2006252880 18239760 16250032
14:34:01 6702 8192000000 10920310192 11350454272 1975899168 19.432 100 38 73 3 2007929776 21669680 10360928
14:34:16 22420 8192000000 10920993936 11354271744 1976628672 19.438 100 42 82 1 2014061248 24299024 13133552
14:34:47 16235 8192000000 10933772992 11362418688 1976189264 19.435 100 49 99 1 2015480368 24546032 14745072
14:35:10 5154 8192000000 10938169648 11361587200 1980085568 19.465 100 67 133 1 2027787264 26575824 21125872
14:35:24 7799 8192000000 10931528064 11364077568 1981335072 19.475 100 59 117 2 2027745248 28701792 17708384
14:35:42 2840 8192000000 10950102432 11374288896 1989537488 19.540 100 78 158 3 2039838336 26822928 23477920
14:36:01 13909 8192000000 10943850240 11382390784 1993788320 19.574 100 48 97 1 2033937344 26000912 14148112
14:36:22 5841 8192000000 10947704784 11376488448 1995366896 19.586 100 54 106 0 2037527376 26945408 15215072
14:36:34 2254 8192000000 10966013712 11387416576 2006290672 19.672 100 60 120 0 2051757584 27884368 17582544
14:36:43 4270 8192000000 10958536256 11383681024 2004606688 19.659 100 68 134 0 2050119712 25378960 20134064
14:37:00 2018 8192000000 10970231248 11388379136 2006154016 19.671 100 83 164 2 2055544544 25022992 24367536
14:37:09 3125 8192000000 10972679232 11394744320 2011253104 19.711 100 68 136 0 2058964256 27544400 20166752
14:37:20 8419 8192000000 10961144352 11386560512 1984887072 19.503 99 69 138 1 2033108064 27870016 20350976
14:37:38 8298 8192000000 10947247984 11380551680 1998451664 19.611 100 56 111 0 2042749008 27480672 16816672
14:37:57 2442 8192000000 10951592944 11366039552 1984966752 19.504 99 62 121 1 2030818000 27770320 18080928
14:38:11 3796 8192000000 10957240784 11379535872 1998640592 19.612 100 62 121 0 2046723056 29749344 18333120
14:38:25 3537 8192000000 10962466208 11385143296 1986533792 19.516 99 73 143 1 2038409840 30338672 21537376
14:38:40 6459 8192000000 10955091264 11381985280 1996491984 19.595 100 69 136 3 2046496112 30483392 19520736
14:38:57 5399 8192000000 10977035008 11397312512 2005615520 19.667 100 73 145 2 2061433888 34876944 20941424
14:39:10 6589 8192000000 10977308368 11400785920 2010264080 19.704 100 73 146 2 2063225968 31106304 21855584
14:39:23 4550 8192000000 10961507616 11378753536 1978129040 19.450 99 79 158 1 2033661504 30637456 24895008
14:39:36 14173 8192000000 10965884704 11388456960 1999454256 19.618 100 73 146 3 2053797776 32856816 21486704
14:40:00 3769 8192000000 10978587792 11400253440 2003531456 19.651 100 74 146 0 2061891840 36173888 22186496
14:40:11 8984 8192000000 10974544832 11406860288 2008991424 19.694 100 61 120 0 2063690400 36436096 18262880
14:40:28 2188 8192000000 10996391872 11420303360 2021167632 19.789 100 71 142 1 2080728944 38001824 21559488
14:40:39 4462 8192000000 11002225008 11420233728 2022951600 19.803 100 80 162 1 2083222768 35584384 24686784
14:40:50 1859 8192000000 10995904736 11408875520 2012478992 19.721 100 86 171 1 2076035984 38333040 25223952
14:41:00 4269 8192000000 10992210736 11410116608 2010496224 19.705 100 79 158 0 2074332272 39676880 24159168
14:41:11 4145 8192000000 10991072048 11406516224 2009728560 19.699 100 78 154 1 2071351472 37752064 23870848
14:41:24 3270 8192000000 10988721920 11405799424 2002342784 19.641 100 79 156 3 2070589264 43667520 24578960
14:41:35 1725 8192000000 10981991056 11399897088 2001262624 19.633 100 79 159 1 2066288112 39863760 25161728
14:41:45 3345 8192000000 10986465856 11409100800 2008093408 19.687 100 74 148 0 2072133392 40935088 23104896
14:41:56 3178 8192000000 11004950656 11414970368 2013848016 19.732 100 90 180 2 2083781568 42105376 27828176
14:42:06 9380 8192000000 10980770000 11405119488 1983353392 19.491 99 75 146 0 2049085072 42914608 22817072
14:42:32 1920 8192000000 10991371200 11413245952 2008691968 19.691 100 79 158 0 2076488608 43101728 24694912
14:42:43 3828 8192000000 10992975136 11419865088 2011493184 19.713 100 70 140 3 2074097696 40730800 21873712
14:42:53 1852 8192000000 10989113552 11405996032 2008206096 19.687 100 85 168 1 2073199312 39401648 25591568
14:43:03 2108 8192000000 11003472000 11416010752 1998751296 19.613 99 91 182 0 2067460096 41068576 27640224
14:43:12 3122 8192000000 10996682352 11412963328 2011880800 19.716 100 79 158 0 2077953152 42128080 23944272
14:43:22 4252 8192000000 10973442016 11393150976 1992802992 19.566 100 72 144 0 2056105824 41057184 22245648
14:43:35 7428 8192000000 10954619120 11393175552 1981630928 19.478 99 55 111 1 2038015264 39235712 17148624
14:43:53 5969 8192000000 10971663376 11403124736 2003662896 19.652 100 52 104 0 2057146928 36706928 16777104
14:44:10 15744 8192000000 10978647008 11415605248 2013231248 19.727 100 50 100 4 2068081632 38995008 15855376
14:44:41 5513 8192000000 10974349056 11408551936 1986138800 19.513 99 50 100 1 2045983248 43096752 16747696
14:44:59 6955 8192000000 10970997216 11405357056 1983209328 19.490 99 50 98 2 2043579360 44423424 15946608
14:45:15 7380 8192000000 10974788848 11405848576 1981932880 19.480 99 64 129 2 2049895024 46655664 21306480
14:45:34 4263 8192000000 10991077264 11414818816 2003611024 19.651 100 85 169 0 2079557968 47894528 28052416
14:45:45 1316 8192000000 10981111936 11397369856 1984549200 19.501 99 85 166 5 2058977936 48713152 25715584
14:45:55 2792 8192000000 10996295232 11414720512 2002330752 19.641 100 77 150 0 2075220960 49531328 23358880
14:46:07 4040 8192000000 10999099136 11418652672 2004741808 19.660 100 81 162 0 2082707488 51779456 26186224
14:46:18 4595 8192000000 10995436496 11411083264 1993723488 19.573 100 81 162 1 2073667520 53500864 26443168
14:46:29 1412 8192000000 11006537648 11418087424 2004060928 19.655 100 89 174 4 2085801888 53880000 27860960
14:46:38 5735 8192000000 10977969280 11405803520 1988332064 19.531 100 61 122 1 2058973760 51188352 19453344
14:46:50 10591 8192000000 10970690544 11407040512 1973878384 19.416 99 58 116 1 2043998848 51503824 18616640
14:47:11 7789 8192000000 10959524928 11391946752 1970183712 19.387 99 47 94 3 2038624608 52597760 15843136
14:47:30 8891 8192000000 10939309488 11374309376 1949625216 19.223 99 39 78 2 2015444624 52076960 13742448
14:48:03 3244 8192000000 10956580464 11368660992 1961058448 19.314 100 66 128 3 2027832064 45942816 20830800
14:48:13 1865 8192000000 10958317440 11375755264 1969941248 19.385 100 74 148 1 2041231856 47408832 23881776
14:48:24 4298 8192000000 10963918368 11388030976 1973792736 19.416 100 63 127 2 2042644768 49394256 19457776
14:48:43 1748 8192000000 10948782976 11371651072 1957903536 19.289 99 63 126 0 2026316016 48035520 20376960
14:49:13 7933 8192000000 10949349952 11388137472 1956178112 19.276 99 43 86 0 2020132960 49437056 14517792
14:49:28 11510 8192000000 10961482192 11404783616 1981499760 19.477 100 38 75 0 2045544864 50548784 13496320
14:49:49 17541 8192000000 10954698512 11403137024 1978788368 19.455 100 36 72 2 2040579440 49352000 12439072
14:50:37 18647 8192000000 10941198400 11386187776 1974215552 19.419 100 39 77 1 2026322960 39992160 12115248
14:51:07 18577 8192000000 10930553360 11364122624 1951985280 19.242 100 36 72 2 2004156752 40611056 11560416
14:51:32 18627 8192000000 10923631696 11368804352 1941532608 19.159 99 30 60 3 1994471936 42900304 10039024
14:51:57 10551 8192000000 10930195408 11375800320 1954854816 19.265 100 25 50 3 2009117776 44868368 9394592
14:52:14 29851 8192000000 10932088832 11388190720 1960858528 19.313 100 28 56 3 2022086512 51958608 9269376
14:53:09 12396 8192000000 10934640560 11392929792 1954948000 19.266 100 24 48 0 2019747472 56119968 8679504
14:53:36 23277 8192000000 10931028256 11397812224 1947668288 19.208 100 15 30 2 2013024592 59193392 6162912
14:54:13 18325 8192000000 10932770816 11393843200 1950015376 19.227 100 18 36 0 2023479328 66553040 6910912
14:54:45 57406 8192000000 10878296160 11360161792 1934206912 19.101 100 6 12 0 1960632224 24862800 1562512
14:55:50 7871 8192000000 10873244128 11323637760 1926164928 19.036 99 44 87 0 1945245888 6620992 12459968
14:56:11 30856 8192000000 10869839952 11332886528 1922193216 19.004 99 8 16 1 1934343168 9990560 2159392
14:57:10 43849 8192000000 10877008688 11309592576 1846046752 18.390 95 40 75 1 1868862048 12444736 10370560
14:58:10 72495 8192000000 10849423776 11294507008 1811829584 18.111 94 18 36 1 1823686784 7499200 4358000
14:59:31 143081 8192000000 10870362512 11339575296 1921929376 19.002 99 12 24 0 1947767104 22632576 3205152
15:02:41 61906 8192000000 10875178624 11331059712 1911203968 18.916 98 28 56 2 1927618944 8565680 7849296
15:03:52 78673 8192000000 10898466784 11341660160 1945534528 19.191 99 44 86 1 1966207728 8514016 12159184
15:05:21 48583 8192000000 10874401232 11338903552 1920603088 18.992 98 30 61 0 1942381168 13156256 8621824
15:06:20 104209 8192000000 10901743728 11372388352 1974343280 19.420 100 33 66 3 1994180672 9527632 10309760
15:08:15 47055 8192000000 10895866592 11365580800 1952181680 19.244 99 10 20 0 1965303264 10211712 2909872
15:09:08 25830 8192000000 10896828128 11359293440 1953745344 19.256 99 14 28 1 1965469136 8084256 3639536
15:09:41 66644 8192000000 10897173440 11364679680 1953656320 19.256 99 7 14 1 1962792896 7611152 1525424
15:11:27 54273 8192000000 10896570352 11372507136 1963655040 19.335 99 11 22 0 1974174496 7307488 3211968
15:13:01 82358 8192000000 10891705168 11368914944 1967427760 19.365 99 26 52 1 1984780384 9045616 8307008
15:14:29 39110 8192000000 10896119504 11370024960 1955402288 19.269 99 11 22 1 1968771584 10970512 2398784
15:15:29 83007 8192000000 10902886032 11380441088 1940628032 19.152 98 13 26 1 1951435776 7313776 3493968
15:16:58 85118 8192000000 10919345696 11388493824 1951565808 19.239 98 18 36 3 1969624560 12727248 5331504
15:18:29 59688 8192000000 10905499568 11391352832 1969916016 19.385 99 19 38 1 1991233376 15136992 6180368
15:19:35 50715 8192000000 10915304496 11388895232 1985836800 19.511 100 17 34 1 1999637808 9147440 4653568
15:20:32 50126 8192000000 10955240208 11403976704 1996260592 19.593 100 22 42 1 2013313040 11118192 5934256
15:21:43 91007 8192000000 10931966816 11408384000 1948031808 19.211 97 18 34 1 1970315568 17074464 5209296
15:23:24 72047 8192000000 10905886432 11386208256 1921618992 19.000 96 9 18 0 1937443104 13473360 2350752
15:24:44 41323 8192000000 10869708752 11339399168 1885140144 18.707 95 14 28 1 1897841792 8978224 3723424
15:25:40 59175 8192000000 10889638944 11343728640 1863925056 18.535 95 16 32 0 1884896064 16258992 4712016
15:26:45 42492 8192000000 10904972608 11366387712 1960761872 19.312 100 38 76 0 1985017792 13676240 10579680
15:27:39 73984 8192000000 10890728880 11352854528 1934521824 19.103 98 27 54 0 1954206112 12280256 7404032
15:29:29 49910 8192000000 10911242976 11373211648 1955306400 19.269 99 30 60 1 1978837392 15215840 8315152
15:30:25 30361 8192000000 10882804512 11369422848 1966179840 19.355 100 12 24 1 1981307424 12147600 2979984
15:31:02 16115 8192000000 10882132784 11371651072 1967421968 19.365 100 10 20 2 1981471792 11778976 2270848
15:31:43 45468 8192000000 10867753440 11337601024 1925482544 19.031 99 10 20 1 1933950160 6004800 2462816
15:32:35 40413 8192000000 10872227504 11349209088 1918369536 18.974 98 10 20 1 1933868880 12770448 2728896
15:33:28 66712 8192000000 10889520176 11355901952 1920887680 18.994 98 9 18 1 1930936992 7367648 2681664
15:34:41 62374 8192000000 10899224112 11380051968 1960159712 19.307 99 18 36 1 1978079056 12841696 5077648
15:35:54 64860 8192000000 10874764208 11350151168 1877133936 18.642 95 12 24 0 1892529552 11908496 3487120
15:37:47 67668 8192000000 10869846688 11347927040 1922855056 19.010 99 20 40 0 1942236704 12997552 6384096
15:39:04 30394 8192000000 10888416640 11342594048 1920087808 18.988 98 35 70 1 1938000304 8135424 9777072
15:39:47 45154 8192000000 10873596784 11345838080 1895284784 18.788 97 12 24 0 1909510144 10797280 3428080
15:40:38 78189 8192000000 10852407888 11337846784 1864892928 18.543 96 17 34 0 1882654160 12870912 4890320
15:42:06 107447 8192000000 10885409504 11356995584 1903879440 18.857 98 23 45 1 1922252656 12850768 5522448
15:44:01 70908 8192000000 10875144368 11340623872 1887926768 18.729 97 6 12 0 1902725952 13353120 1446064
15:45:18 50143 8192000000 10863421184 11322691584 1821870720 18.193 94 14 28 0 1839789296 13553072 4365504
15:46:15 50662 8192000000 10868270384 11333758976 1899970352 18.826 99 18 36 2 1917980016 13102464 4907200
15:47:18 81299 8192000000 10857199120 11322589184 1923299552 19.013 100 15 30 1 1939302112 11757360 4245200
15:48:46 47318 8192000000 10849438592 11310161920 1838642080 18.330 95 27 54 0 1854181776 7658592 7881104
15:49:40 43906 8192000000 10852107760 11314753536 1921860208 19.002 100 29 59 1 1940278256 10908432 7509616
15:50:30 8390 8192000000 10844472928 11315646464 1921230640 18.997 100 10 20 1 1933672064 9866416 2575008
15:50:44 5420 8192000000 10851288112 11316137984 1925076336 19.027 100 14 28 1 1938553872 8986672 4490864
15:50:56 24170 8192000000 10858571680 11330433024 1932010688 19.083 100 8 16 1 1944682016 10048144 2623184
15:51:26 62219 8192000000 10835395600 11320832000 1895015232 18.786 98 12 24 1 1911067296 12630352 3421712
15:52:35 10225 8192000000 10836976336 11321028608 1918316560 18.973 100 4 9 0 1932900672 13379504 1204608
15:53:00 4661 8192000000 10845157760 11328659456 1922372512 19.006 100 6 12 0 1941788176 17245200 2170464
15:53:11 14603 8192000000 10855080272 11322908672 1930488608 19.071 100 31 62 1 1953204448 13712272 9003568
15:53:34 50506 8192000000 10838425568 11310526464 1878824816 18.656 97 11 23 0 1893138352 10623328 3690208
15:54:34 84617 8192000000 10848982304 11326996480 1897076832 18.803 98 12 24 0 1913111696 12529120 3505744
15:56:14 59300 8192000000 10850470496 11331567616 1898301040 18.813 98 7 13 1 1909377152 9317504 1758608
15:57:26 32822 8192000000 10873737952 11329703936 1926175568 19.036 99 28 56 2 1940296688 6964752 7156368
15:58:04 46819 8192000000 10855704640 11329703936 1917765296 18.969 98 27 54 3 1933417936 8478000 7174640
15:59:12 31125 8192000000 10890768400 11352027136 1956387088 19.277 100 26 52 1 1971789840 8559296 6843456
15:59:50 49764 8192000000 10891573328 11362082816 1925038416 19.027 98 20 40 1 1940755872 10287120 5430336
16:00:46 115591 8192000000 10879756624 11360157696 1882320448 18.684 96 10 20 0 1900535440 15435952 2779040
16:02:47 58748 8192000000 10925042432 11369721856 1962725088 19.328 100 11 22 0 1976411248 10713904 2972256
16:03:53 87382 8192000000 10905862832 11387035648 1961362704 19.317 99 17 34 1 1975795104 9901152 4531248
16:05:26 16221 8192000000 10933899376 11384881152 1984989408 19.504 100 37 74 1 2002548928 6920304 10639216
16:05:52 69497 8192000000 10932358256 11396497408 1970468928 19.389 99 32 63 0 1998203568 18712880 9021760
16:07:09 57561 8192000000 10902602912 11376701440 1905720976 18.872 96 26 52 2 1934180400 21687984 6771440
16:08:13 103048 8192000000 10884484352 11366907904 1929732624 19.065 98 12 24 1 1950514816 17309328 3472864
16:10:02 100580 8192000000 10916900864 11371081728 1971190656 19.395 100 19 38 0 1984812304 8420288 5201360
16:11:53 37610 8192000000 10882614272 11354218496 1924862960 19.026 97 32 64 2 1940269520 6839488 8567072
16:13:09 61529 8192000000 10893504560 11365605376 1918398240 18.974 97 15 30 2 1941272112 18701424 4172448
16:14:17 12322 8192000000 10870502240 11333558272 1882341264 18.684 96 28 54 3 1904813088 14137792 8334032
16:14:36 29021 8192000000 10898919232 11354107904 1954113088 19.259 100 35 70 1 1977274224 13151744 10009392
16:15:16 62463 8192000000 10891143520 11374383104 1946789568 19.201 99 14 28 0 1964191440 13424240 3977632
16:16:24 50948 8192000000 10887042208 11375677440 1954323712 19.261 99 11 22 1 1972777488 14389264 4064512
16:17:29 43113 8192000000 10894328304 11362967552 1951732256 19.240 99 16 32 1 1967679952 11876048 4071648
16:18:19 39622 8192000000 10877324032 11357368320 1935587904 19.112 98 24 48 1 1949817200 7623936 6605360
16:19:21 84712 8192000000 10919152800 11388465152 1979715488 19.462 100 13 26 1 2002751152 19289888 3745776
16:20:52 91627 8192000000 10894005056 11383242752 1942333200 19.165 98 21 42 0 1971603168 21992208 7277760
16:22:57 66026 8192000000 10875103840 11346096128 1915362768 18.950 98 16 32 1 1936905152 16797408 4744976
16:24:25 25369 8192000000 10861352928 11328978944 1857450896 18.483 95 26 51 1 1871755776 7388048 6916832
16:24:57 43512 8192000000 10874861136 11338432512 1928702592 19.057 99 24 48 0 1951207840 15538608 6966640
16:25:52 53699 8192000000 10865683552 11319877632 1872392416 18.604 96 21 42 0 1890192032 11922032 5877584
16:27:00 17773 8192000000 9694218976 10036060160 826254176 9.162 43 11 17 1 844830368 15628160 2948032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 09-01-2021 16:28:43 to 09-01-2021 16:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 09-01-2021 16:29:16 to 09-01-2021 16:29:17.

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          242048
MON$OLDEST_ACTIVE               246248
MON$OLDEST_SNAPSHOT             246248
MON$NEXT_TRANSACTION            246248
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                       2029536
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:610: 
:611: mscs-test-161.budzdorov.ru    Sat Jan  9 16:27:24 2021
:612:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:613: 
:614: 
:615: mscs-test-161.budzdorov.ru    Sat Jan  9 16:27:25 2021
:616:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:617: 
:618: 
:619: mscs-test-161.budzdorov.ru    Sat Jan  9 16:27:27 2021
:620:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:621: 
--- end of diff output ---

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

09.01.21 16:29:18. 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-09 16:29:21 No severe PSQL-related problems occured
09.01.21 16:29:22. End of report.