Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.02.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 17014108 kB
MemAvailable 31257512 kB
Buffers 0 kB
Cached 14701908 kB
SwapCached 4876 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-02-03 16:27:14
DTS_END                         2021-02-03 16:27:14.2870
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45956
TRN_ID                          250532
ATT_ID                          657
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: 9374.76 19634 1124971
customer order: creation 184.94 328 22193
customer order: refuse 15.66 359 1879
order to supplier: creation 48.27 1260 5792
order to supplier: removal 3.46 106888 415
invoice (draft): creation 48.33 3317 5799
invoice (draft): removal 51.09 918 6131
invoice accept: apply 44.18 18309 5301
invoice accept: cancel 46.42 846 5570
customer reserve: creation 4044.26 182 485311
customer reserve: removal 4575.83 62 549099
realization accept: apply 89.87 178 10784
realization accept: cancel 84.38 110 10125
payment from customer: creation 62.72 102 7526
payment from customer: removal 6.44 79 773
payment to supplier: creation 52.38 131 6285
payment to supplier: removal 3.30 80 396
service: total inventory turnovers 5.15 1121 618
service: total monetary turnovers 7.38 28 885
service: aggregate perf. data 0.71 25835 85
service: refresh index statistics 0.03 232552 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-02-2021 16:29:11 to 03-02-2021 16:29:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7399
TEST_TIME 2 6123
TEST_TIME 3 6383
TEST_TIME 4 5839
TEST_TIME 5 5952
TEST_TIME 6 5846
TEST_TIME 7 5991
TEST_TIME 8 6276
TEST_TIME 9 6286
TEST_TIME 10 6563
TEST_TIME 11 6404
TEST_TIME 12 6630
TEST_TIME 13 6811
TEST_TIME 14 7311
TEST_TIME 15 7499
TEST_TIME 16 7479
TEST_TIME 17 7650
TEST_TIME 18 8093
TEST_TIME 19 8039
TEST_TIME 20 8093
TEST_TIME 21 8086
TEST_TIME 22 8387
TEST_TIME 23 8752
TEST_TIME 24 9096
TEST_TIME 25 9403
TEST_TIME 26 10110
TEST_TIME 27 10594
TEST_TIME 28 11204
TEST_TIME 29 11333
TEST_TIME 30 11368
TEST_TIME 31 11172
TEST_TIME 32 11090
TEST_TIME 33 10983
TEST_TIME 34 10813
TEST_TIME 35 10989
TEST_TIME 36 10731
TEST_TIME 37 10748
TEST_TIME 38 10673
TEST_TIME 39 10612
TEST_TIME 40 10447
TEST_TIME 41 10444
TEST_TIME 42 10379
TEST_TIME 43 10431
TEST_TIME 44 10339
TEST_TIME 45 10225
TEST_TIME 46 10140
TEST_TIME 47 10145
TEST_TIME 48 10015
TEST_TIME 49 9996
TEST_TIME 50 10057
TEST_TIME 51 9974
TEST_TIME 52 9919
TEST_TIME 53 9803
TEST_TIME 54 9850
TEST_TIME 55 9881
TEST_TIME 56 9926
TEST_TIME 57 9863
TEST_TIME 58 9894
TEST_TIME 59 9853
TEST_TIME 60 9839
TEST_TIME 61 10045
TEST_TIME 62 10051
TEST_TIME 63 10101
TEST_TIME 64 10114
TEST_TIME 65 10063
TEST_TIME 66 10116
TEST_TIME 67 10133
TEST_TIME 68 10120
TEST_TIME 69 10126
TEST_TIME 70 9995
TEST_TIME 71 9938
TEST_TIME 72 9911
TEST_TIME 73 9872
TEST_TIME 74 9806
TEST_TIME 75 9733
TEST_TIME 76 9722
TEST_TIME 77 9655
TEST_TIME 78 9632
TEST_TIME 79 9735
TEST_TIME 80 9740
TEST_TIME 81 9705
TEST_TIME 82 9670
TEST_TIME 83 9707
TEST_TIME 84 9713
TEST_TIME 85 9736
TEST_TIME 86 9728
TEST_TIME 87 9783
TEST_TIME 88 9826
TEST_TIME 89 9798
TEST_TIME 90 9794
TEST_TIME 91 9827
TEST_TIME 92 9738
TEST_TIME 93 9719
TEST_TIME 94 9712
TEST_TIME 95 9663
TEST_TIME 96 9627
TEST_TIME 97 9634
TEST_TIME 98 9603
TEST_TIME 99 9628
TEST_TIME 100 9603
TEST_TIME 101 9581
TEST_TIME 102 9569
TEST_TIME 103 9667
TEST_TIME 104 9672
TEST_TIME 105 9652
TEST_TIME 106 9634
TEST_TIME 107 9686
TEST_TIME 108 9703
TEST_TIME 109 9672
TEST_TIME 110 9716
TEST_TIME 111 9667
TEST_TIME 112 9634
TEST_TIME 113 9582
TEST_TIME 114 9596
TEST_TIME 115 9556
TEST_TIME 116 9519
TEST_TIME 117 9490
TEST_TIME 118 9485
TEST_TIME 119 9454
TEST_TIME 120 9381

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-02-2021 16:29:14 to 03-02-2021 16:29:18.

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 1574001 1574001 0 0.00 0 17044 7 0 0
doc_list_biud 1574001 1574001 0 0.00 0 29419 28 0 0
sp_add_invoice_to_stock 5485 5301 184 3.35 29 183217 18310 0 184
sp_cancel_adding_invoice 5570 5570 0 0.00 5 80745 846 0 0
sp_cancel_client_order 1879 1879 0 0.00 5 13849 359 0 0
sp_cancel_customer_reserve 549099 549099 0 0.00 1 23267 63 0 0
sp_cancel_pay_from_customer 773 773 0 0.00 3 5058 79 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 2 3830 80 0 0
sp_cancel_supplier_invoice 6152 6131 21 0.34 2 29429 919 0 21
sp_cancel_supplier_order 415 415 0 0.00 6 1090906 106888 0 0
sp_cancel_write_off 10125 10125 0 0.00 1 14344 110 0 0
sp_client_order 22193 22193 0 0.00 4 23362 329 0 0
sp_customer_reserve 485311 485311 0 0.00 0 58039 183 0 0
sp_fill_shopping_cart 33783 33783 0 0.00 1 21730 36 0 0
sp_fill_shopping_cart_clo_res 485300 485300 0 0.00 0 16890 13 0 0
sp_get_clo_for_invoice 5288 5288 0 0.00 0 23160 288 0 0
sp_kill_cost_storno 16864 16864 0 0.00 0 7929 58 0 0
sp_kill_qstorno_ret_qs2qd 1114869 1114869 0 0.00 0 29413 34 0 0
sp_kill_qty_storno 589291 589291 0 0.00 0 29416 74 0 0
sp_lock_selected_doc 22266 22266 0 0.00 0 9595 7 0 0
sp_make_cost_storno 29883 29883 0 0.00 0 12459 50 0 0
sp_multiply_rows_for_pdistr 29883 29883 0 0.00 0 8167 29 0 0
sp_multiply_rows_for_qdistr 22193 22193 0 0.00 0 23191 145 0 0
sp_pay_from_customer 7526 7526 0 0.00 4 11818 102 0 0
sp_pay_to_supplier 6285 6285 0 0.00 4 13749 131 0 0
sp_payment_common 13811 13811 0 0.00 1 7974 27 0 0
sp_qd_handle_on_cancel_clo 1879 1879 0 0.00 0 13844 329 0 0
sp_qd_handle_on_invoice_upd_sts 10858 10858 0 0.00 0 26609 334 0 0
sp_qd_handle_on_reserve_upd_sts 10784 10784 0 0.00 0 15070 59 0 0
sp_reserve_write_off 10784 10784 0 0.00 6 15088 179 0 0
sp_supplier_invoice 5799 5799 0 0.00 7 96448 3317 0 0
sp_supplier_order 5792 5792 0 0.00 4 25058 1261 0 0
srv_aggregate_perf_data 85 85 0 0.00 2304 322129 25836 0 0
srv_fill_mon_cache_memory 182 182 0 0.00 1440 136029 27700 0 0
srv_find_qd_qs_mism 1074161 1074161 0 0.00 0 12116 6 0 0
srv_make_invnt_saldo 618 618 0 0.00 20 84930 1121 0 0
srv_make_money_saldo 885 885 0 0.00 1 2155 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 129464 480776 232552 0 0
t$perf-abend:sp_add_invoice_to_stock 184 184 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 21 21 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5301 5301 0 0.00 0 23993 210 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 1 4773 128 0 0
t$perf-norm:sp_cancel_client_order 1879 1879 0 0.00 0 6940 18 0 0
t$perf-norm:sp_cancel_customer_reserve 805 805 0 0.00 0 1775 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 773 773 0 0.00 0 1985 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 359 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 2553 18 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 20673 1839 0 0
t$perf-norm:sp_cancel_write_off 1097 1097 0 0.00 0 12157 24 0 0
t$perf-norm:sp_client_order 22193 22193 0 0.00 0 20447 21 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 4323 11 0 0
t$perf-norm:sp_pay_from_customer 7526 7526 0 0.00 0 8744 11 0 0
t$perf-norm:sp_pay_to_supplier 6285 6285 0 0.00 0 17506 13 0 0
t$perf-norm:sp_reserve_write_off 10784 10784 0 0.00 0 20459 11 0 0
t$perf-norm:sp_supplier_invoice 5799 5799 0 0.00 0 18957 25 0 0
t$perf-norm:sp_supplier_order 5792 5792 0 0.00 0 11483 22 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 6602 99 0 0
t$perf-norm:srv_fill_mon_cache_memory 182 182 0 0.00 0 456 5 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 9568 44 0 0
t$perf-norm:srv_make_money_saldo 885 885 0 0.00 0 2709 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10934 10566 368 3.36 0 9807 25 0 368
v_all_customers 40224 40224 0 0.00 0 20 1 0 0
v_all_suppliers 32280 32280 0 0.00 0 111 1 0 0
v_all_wares 44386 44386 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 913 6 0 0
v_cancel_client_order 3758 3758 0 0.00 0 2886 6 0 0
v_cancel_customer_prepayment 1546 1546 0 0.00 0 2672 5 0 0
v_cancel_customer_reserve 1610 1610 0 0.00 0 2418 5 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 1572 8 0 0
v_cancel_supplier_invoice 858 816 42 4.89 0 2921 24 0 42
v_cancel_supplier_order 830 830 0 0.00 0 526 5 0 0
v_cancel_write_off 2194 2194 0 0.00 0 5448 22 0 0
v_max_id_clo_ord 5792 5792 0 0.00 0 689 1 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 3546 14 0 0
v_max_id_ord_sup 5798 5798 0 0.00 0 5498 5 0 0
v_max_non_paid_invoice 1735 1735 0 0.00 0 3023 4 0 0
v_max_non_paid_realizn 4089 4089 0 0.00 0 1125 4 0 0
v_min_id_clo_ord 5792 5792 0 0.00 0 988 5 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 2199 5 0 0
v_min_id_ord_sup 5798 5798 0 0.00 0 9283 8 0 0
v_min_non_paid_invoice 6285 6285 0 0.00 0 6594 21 0 0
v_min_non_paid_realizn 7526 7526 0 0.00 0 7971 16 0 0
v_our_firm 11036 11036 0 0.00 0 16 1 0 0
v_reserve_write_off 21568 21568 0 0.00 0 6331 7 0 0
x_lock_depdocs_on_canc_invoice 11293 11293 0 0.00 0 24557 139 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 32161 432 0 0
x_make_qstorno_1000_1200 5792 5792 0 0.00 2 25020 1180 0 0
x_make_qstorno_1200_2000 5799 5799 0 0.00 4 93420 3190 0 0
x_make_qstorno_2100_3300 485311 485311 0 0.00 0 58036 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-02-2021 16:29:19 to 03-02-2021 16:29:23.

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:18 10 8192000000 8810983104 8825049088 14828976 0.180 4 2 3 0 15068272 77680 161616
13:57:24 9978 8192000000 10219631056 10525331456 889971952 9.799 69 52 102 1 908940480 2463136 16505392
13:57:46 45377 8192000000 10371241984 10692104192 1414663616 14.725 100 89 179 0 1449083632 5664256 28755760
13:58:40 14095 8192000000 10393812288 10715410432 1452075360 15.056 100 94 188 0 1489600336 7571856 29953120
13:59:04 21852 8192000000 10406975232 10732470272 1462226048 15.145 100 94 188 0 1501198416 8698752 30273616
13:59:33 22618 8192000000 10414364384 10746212352 1471732640 15.229 100 88 176 1 1508975696 9124480 28118576
14:00:04 11874 8192000000 10440609872 10773012480 1491879184 15.405 100 89 178 0 1529410704 9322208 28209312
14:00:28 13592 8192000000 10452011936 10786676736 1507079376 15.538 100 92 184 1 1546288368 10106160 29102832
14:01:04 23931 8192000000 10470586112 10813374464 1526934224 15.710 100 89 178 2 1565377920 10523648 27920048
14:01:37 19023 8192000000 10498874688 10850709504 1559031360 15.988 100 77 154 0 1593290368 10514880 23744128
14:02:05 18203 8192000000 10528010672 10878349312 1585456224 16.215 100 76 152 0 1619187104 10838528 22892352
14:02:32 15573 8192000000 10552929680 10909147136 1609980576 16.425 100 81 162 0 1646428736 12235152 24213008
14:02:55 9457 8192000000 10576231008 10930434048 1631244400 16.605 100 84 167 1 1668357392 12460752 24652240
14:03:12 12060 8192000000 10602277648 10961555456 1652190016 16.783 100 90 180 2 1691953056 13284592 26478448
14:03:33 10988 8192000000 10606326704 10970099712 1665614768 16.896 100 75 150 0 1699812928 12642224 21555936
14:03:52 9554 8192000000 10626334928 10992246784 1685013712 17.059 100 83 166 1 1721920608 12787712 24119184
14:04:09 9332 8192000000 10647199744 11012100096 1697510848 17.164 100 79 158 1 1734225280 13517680 23196752
14:04:26 6909 8192000000 10651923552 11025657856 1721483792 17.365 100 85 170 0 1759022864 12789168 24749904
14:04:40 4592 8192000000 10670931696 11045724160 1730264224 17.438 100 76 150 3 1764731376 12978000 21489152
14:04:55 5157 8192000000 10686124944 11061186560 1746345840 17.571 100 73 145 1 1779720672 12744592 20630240
14:05:08 3818 8192000000 10689166944 11068628992 1756423312 17.655 100 87 175 0 1794634880 13340864 24870704
14:05:19 4571 8192000000 10708830832 11090354176 1772031008 17.784 100 82 163 2 1807391616 12654912 22705696
14:05:31 4476 8192000000 10725030256 11101872128 1783695072 17.880 100 91 180 2 1822366032 13934304 24736656
14:05:43 4580 8192000000 10734211120 11112247296 1788711408 17.921 100 87 171 1 1826380208 13717344 23951456
14:05:55 3965 8192000000 10735372832 11114311680 1796890656 17.988 100 90 180 2 1834156880 12838720 24427504
14:06:05 2558 8192000000 10740961760 11120848896 1800888928 18.021 100 88 177 1 1838678304 13605920 24183456
14:06:14 8912 8192000000 10744717120 11129098240 1805446400 18.059 100 85 169 4 1843272608 14437616 23388592
14:06:29 6495 8192000000 10769144800 11150217216 1814391600 18.132 100 84 168 1 1851712016 14074848 23245568
14:06:42 2096 8192000000 10774910144 11165659136 1835739280 18.306 100 85 169 1 1877119920 17176704 24203936
14:06:51 2034 8192000000 10779368768 11170496512 1844652112 18.379 100 86 172 2 1881368256 12374080 24342064
14:06:59 1441 8192000000 10793134352 11182448640 1853352480 18.449 100 86 171 1 1889014192 11299408 24362304
14:07:07 1708 8192000000 10802149088 11190603776 1860608416 18.508 100 89 179 1 1898196784 11970000 25618368
14:07:15 1633 8192000000 10805678240 11194527744 1867658432 18.565 100 95 190 0 1906755728 12374032 26723264
14:07:23 1952 8192000000 10812275888 11199164416 1865047360 18.544 100 96 194 1 1905611072 13651536 26912176
14:07:32 2155 8192000000 10813329680 11198984192 1869301008 18.579 100 94 189 1 1909780080 14669552 25809520
14:07:40 1838 8192000000 10820817792 11207348224 1868414704 18.571 100 94 187 2 1909005776 13991904 26599168
14:07:48 1920 8192000000 10812895520 11202609152 1870304848 18.587 100 91 182 3 1908935712 13559072 25071792
14:07:57 2119 8192000000 10800195520 11203485696 1868618272 18.573 100 74 148 2 1902670864 13498224 20554368
14:08:06 18989 8192000000 10779648624 11200086016 1870816704 18.591 100 58 114 0 1895887936 8863424 16207808
14:08:32 11266 8192000000 10812860688 11205582848 1875008032 18.625 100 71 141 3 1900411968 7209344 18194592
14:08:50 1419 8192000000 10823285200 11214110720 1878216240 18.651 100 86 172 1 1914681472 11403040 25062192
14:08:57 3624 8192000000 10798697168 11209994240 1871778368 18.599 100 51 102 0 1897264752 11099344 14387040
14:09:08 5022 8192000000 10793284384 11204108288 1869258304 18.578 100 38 76 1 1889136032 9253104 10624624
14:09:25 4599 8192000000 10791347136 11210911744 1874390416 18.620 100 31 62 1 1890961728 7896112 8675200
14:09:37 7631 8192000000 10792681984 11213266944 1876966064 18.641 100 28 54 1 1891857456 7317168 7574224
14:09:53 3258 8192000000 10790377680 11219533824 1881945552 18.681 100 23 46 0 1895203760 7105584 6152624
14:10:04 12221 8192000000 10801194192 11220365312 1882132944 18.682 100 21 42 1 1894681200 5890464 6657792
14:10:31 13710 8192000000 10799067024 11227820032 1886562384 18.718 100 19 38 0 1898179056 6498656 5118016
14:10:52 11931 8192000000 10797216368 11225153536 1890158464 18.747 100 19 38 0 1901781648 5300672 6322512
14:11:10 17131 8192000000 10793303872 11226886144 1888087280 18.730 100 18 36 0 1899839232 6937856 4814096
14:11:34 73328 8192000000 10801546112 11239915520 1894517568 18.782 100 31 61 2 1909413584 5837040 9058976
14:12:54 4855 8192000000 10819631984 11250774016 1898835376 18.817 100 32 64 2 1918614128 10822240 8956512
14:13:05 7123 8192000000 10817544864 11247349760 1898069712 18.811 100 20 40 0 1910657968 6247536 6340720
14:13:18 5972 8192000000 10824580832 11248820224 1902510448 18.846 100 41 82 1 1922785664 8231984 12043232
14:13:30 7600 8192000000 10816058176 11250573312 1904439456 18.862 100 29 58 1 1918878864 6700784 7738624
14:13:44 4663 8192000000 10816789024 11252019200 1901468304 18.838 100 24 48 1 1914215152 6093392 6653456
14:13:57 4482 8192000000 10817166304 11250180096 1905906656 18.874 100 33 65 3 1921665216 6040912 9717648
14:14:09 5283 8192000000 10829743824 11263057920 1910202544 18.908 100 34 68 1 1926124624 6212496 9709584
14:14:23 5532 8192000000 10830771920 11263942656 1913044128 18.931 100 27 54 1 1927496592 7309056 7143408
14:14:35 5855 8192000000 10822221024 11260567552 1916279232 18.957 100 27 54 2 1930031632 6417120 7335280
14:14:48 8340 8192000000 10837104880 11268091904 1916556656 18.959 100 26 51 2 1929837408 5599312 7681440
14:15:03 8212 8192000000 10821662720 11261321216 1914335744 18.941 100 20 40 1 1926200224 6180944 5683536
14:15:20 8598 8192000000 10828003712 11263799296 1914687296 18.944 100 22 44 0 1926844624 5927536 6229792
14:15:35 8090 8192000000 10815351456 11255672832 1907468288 18.886 100 19 38 0 1918601920 5740816 5392816
14:15:51 7963 8192000000 10806185488 11237687296 1880937872 18.673 99 24 48 1 1894280544 6282112 7060560
14:16:06 58521 8192000000 10825950816 11236601856 1859478576 18.499 98 30 60 0 1873472864 5635888 8358400
14:17:11 12818 8192000000 10799423328 11231612928 1871068544 18.593 99 15 30 2 1881103808 6099424 3935840
14:17:30 5499 8192000000 10799645440 11226644480 1846293824 18.392 98 29 57 0 1864966832 10032736 8640272
14:17:44 8568 8192000000 10783205440 11209551872 1837567600 18.321 98 24 48 1 1849714720 5612480 6534640
14:18:02 6822 8192000000 10781628896 11198251008 1815137040 18.138 97 33 64 3 1835139648 10561904 9440704
14:18:18 4745 8192000000 10755294064 11177680896 1818587168 18.166 98 38 76 1 1835893440 6637376 10668896
14:18:30 5634 8192000000 10708938128 11129896960 1758918624 17.675 95 33 67 1 1775208304 6767504 9522176
14:18:44 4961 8192000000 10725753760 11147390976 1788858336 17.922 98 32 64 0 1804289472 6269120 9162016
14:18:57 5499 8192000000 10725809248 11135332352 1789521744 17.928 98 34 70 3 1805949104 5613264 10814096
14:19:10 3362 8192000000 10727723312 11146903552 1800421408 18.017 99 23 45 1 1812622816 6124192 6077216
14:19:21 5210 8192000000 10679213152 11091681280 1708746720 17.258 94 29 56 2 1721892704 5963360 7182624
14:19:33 9469 8192000000 10699528224 11116662784 1755713584 17.649 97 35 70 3 1772366352 6445328 10207440
14:19:48 6246 8192000000 10702049984 11116601344 1753815376 17.633 97 22 44 0 1765955520 5501696 6638448
14:20:02 8100 8192000000 10720703648 11139362816 1784455328 17.886 98 29 58 1 1798419904 5396976 8567600
14:20:17 7541 8192000000 10740913088 11142242304 1796215328 17.983 99 31 62 2 1810692896 4744432 9733136
14:20:31 5207 8192000000 10719670496 11133796352 1803484960 18.042 100 27 55 2 1817458912 5675680 8298272
14:20:43 59413 8192000000 10709155808 11124338688 1742036112 17.536 96 37 74 2 1757378928 5150304 10192512
14:21:52 12357 8192000000 10714104800 11135942656 1773910864 17.799 98 21 42 3 1785034672 5663888 5459920
14:22:12 12716 8192000000 10707276688 11124465664 1752467808 17.622 97 24 48 0 1765019824 5816752 6735264
14:22:33 7695 8192000000 10726630528 11134115840 1775281744 17.811 98 32 64 3 1790403184 6501904 8619536
14:22:49 4481 8192000000 10738678384 11156570112 1822408544 18.197 100 30 60 0 1837955024 6858768 8687712
14:23:04 5965 8192000000 10756452160 11180449792 1839625584 18.338 100 35 71 1 1855155344 5297728 10232032
14:23:17 7581 8192000000 10752793120 11183046656 1841409152 18.352 100 19 36 1 1851918976 5096032 5413792
14:23:31 4316 8192000000 10763488272 11186814976 1852605120 18.443 100 24 48 2 1864519216 5093456 6820640
14:23:42 5519 8192000000 10766385472 11190927360 1854711728 18.460 100 28 56 3 1868606352 5639312 8255312
14:23:55 6366 8192000000 10772661200 11197378560 1855558736 18.467 100 20 40 2 1866608096 5717744 5331616
14:24:08 8759 8192000000 10782530864 11204993024 1859726896 18.501 100 27 54 0 1873801728 5675968 8398864
14:24:24 9176 8192000000 10773141840 11202195456 1862643328 18.525 100 23 46 0 1875186944 5603824 6939792
14:24:45 11437 8192000000 10772963952 11205574656 1864481648 18.540 100 20 40 1 1875201088 5232720 5486720
14:25:03 11434 8192000000 10790763536 11213377536 1868596688 18.573 100 21 40 1 1883831184 9937552 5296944
14:25:22 57397 8192000000 10780469184 11215605760 1872232688 18.602 100 27 54 1 1885588208 5013824 8341696
14:26:31 10228 8192000000 10793242112 11221897216 1875187648 18.626 100 20 40 0 1890137632 9784976 5165008
14:26:47 7944 8192000000 10802737040 11229876224 1881840864 18.680 100 21 41 1 1892944560 5486384 5617312
14:27:02 6230 8192000000 10806787328 11234189312 1887692112 18.727 100 31 60 1 1902541776 6435952 8413712
14:27:18 23281 8192000000 10838923392 11259289600 1907579632 18.887 100 52 100 3 1928023776 6318224 14125920
14:27:48 15388 8192000000 10843662448 11267657728 1920438960 18.990 100 50 99 1 1943217792 8680240 14098592
14:28:13 31180 8192000000 10862410016 11288690688 1926527696 19.039 100 36 71 2 1944914576 8658880 9728000
14:28:57 19964 8192000000 10876084352 11301122048 1942310272 19.165 100 57 113 2 1967620944 9209136 16101536
14:29:25 6216 8192000000 10894341344 11311808512 1949389376 19.222 100 50 100 0 1972816608 8985024 14442208
14:29:43 13440 8192000000 10881079808 11313795072 1959423056 19.301 100 54 104 2 1984763632 9624128 15716448
14:30:05 6047 8192000000 10894140512 11323781120 1958510288 19.294 100 44 88 4 1981135024 9759104 12865632
14:30:21 8702 8192000000 10888753728 11313274880 1945567664 19.191 99 49 97 0 1968633648 9404640 13661344
14:30:42 12839 8192000000 10901656528 11329409024 1965474480 19.350 100 54 107 0 1992239280 12058560 14706240
14:31:20 38367 8192000000 10893343280 11330985984 1969237952 19.379 100 49 98 0 1994853744 11529088 14086704
14:32:31 9627 8192000000 10898629408 11348635648 1975841968 19.432 100 33 66 3 2005034656 18965600 10227088
14:32:51 2867 8192000000 10923571216 11353112576 1987275872 19.522 100 61 122 1 2016728912 11386960 18066080
14:33:02 2622 8192000000 10937345808 11365040128 1993947936 19.575 100 70 141 1 2030235616 16844464 19443216
14:33:11 5589 8192000000 10929383328 11358130176 1992248096 19.562 100 62 124 0 2024193120 14182976 17762048
14:33:24 2982 8192000000 10932133776 11363979264 1995362288 19.586 100 72 143 3 2028841408 12973952 20505168
14:33:44 12816 8192000000 10935717744 11362439168 1982536320 19.485 100 64 125 1 2019275904 19299856 17439728
14:34:06 10439 8192000000 10932052784 11356270592 1971887040 19.400 99 66 132 1 2008110240 17141408 19081792
14:34:37 6597 8192000000 10936004480 11367235584 1990239040 19.546 100 56 111 2 2023741280 16667584 16834656
14:34:56 20795 8192000000 10937968544 11373862912 1995578544 19.588 100 51 102 2 2029628848 18863312 15186992
14:35:31 22349 8192000000 10914473392 11358388224 1977976064 19.449 99 44 88 1 2011008048 19365520 13666464
14:36:04 20142 8192000000 10940341728 11383853056 2001873264 19.638 100 40 80 2 2031148112 17159104 12115744
14:36:37 7477 8192000000 10962864656 11393703936 2007627280 19.683 100 53 105 1 2044557136 21095152 15834704
14:36:51 4265 8192000000 10959515088 11386929152 2005303728 19.665 100 70 139 2 2049655200 22911552 21439920
14:37:02 5778 8192000000 10962141104 11391623168 2010546976 19.706 100 81 160 2 2058159056 24078592 23533488
14:37:18 5470 8192000000 10956418848 11383754752 2002514848 19.643 100 65 129 1 2043662272 22340640 18806784
14:37:30 10082 8192000000 10949192304 11383123968 1994952816 19.583 100 58 113 2 2034437984 22609056 16876112
14:38:01 6471 8192000000 10934319392 11374268416 1977710960 19.447 99 45 88 1 2019169728 27754512 13704256
14:38:18 5158 8192000000 10927458304 11354726400 1967083008 19.362 100 60 118 0 2010742112 25963872 17695232
14:38:40 6770 8192000000 10939487584 11367178240 1983905296 19.496 100 66 131 1 2029301696 25846384 19550016
14:39:02 2714 8192000000 10938233280 11367018496 1980550832 19.469 100 71 142 3 2027467920 25997296 20919792
14:39:12 5683 8192000000 10939890160 11366703104 1973314720 19.412 99 62 124 0 2017835376 25401856 19118800
14:39:25 5229 8192000000 10943087264 11378012160 1993177248 19.569 100 62 124 0 2037057680 24727920 19152512
14:39:45 4074 8192000000 10929552192 11362476032 1957484048 19.286 99 55 111 0 1998720336 24529344 16706944
14:39:55 7047 8192000000 10917761856 11351486464 1939526640 19.143 98 53 105 2 1984361200 27462896 17371664
14:40:15 4870 8192000000 10935884784 11360002048 1969025440 19.378 100 69 136 1 2019552592 29170192 21356960
14:40:31 9693 8192000000 10918894800 11340386304 1935338048 19.110 98 66 132 2 1985222480 29700352 20184080
14:40:48 7629 8192000000 10926655168 11344482304 1955286896 19.269 99 75 150 2 2010617760 31204320 24126544
14:41:03 1930 8192000000 10947285040 11365429248 1972619920 19.406 100 84 168 1 2031825248 32981216 26224112
14:41:14 2778 8192000000 10953623840 11375058944 1981868144 19.479 100 77 153 0 2039232160 33590560 23773456
14:41:24 2539 8192000000 10972372816 11388223488 1992711568 19.565 100 86 172 3 2051700208 32401104 26587536
14:41:34 2698 8192000000 10954360496 11380203520 1984708832 19.502 100 74 148 1 2038231408 31290656 22231920
14:41:46 9353 8192000000 10935333584 11368067072 1963193824 19.331 99 54 108 0 2010562528 30502912 16865792
14:42:04 5140 8192000000 10926256560 11358224384 1941152608 19.156 98 58 114 0 1989633872 29900640 18580624
14:42:17 5155 8192000000 10926626880 11352920064 1963251856 19.332 100 56 108 1 2008976448 29200640 16523952
14:42:30 5385 8192000000 10916847952 11346522112 1932520592 19.087 98 59 118 1 1982269536 30937760 18811184
14:42:43 4545 8192000000 10898997008 11321892864 1923287392 19.013 98 67 126 4 1972439712 29382640 19769680
14:42:57 8516 8192000000 10908081568 11331145728 1945746400 19.193 100 62 124 0 1995512272 30598944 19166928
14:43:15 3420 8192000000 10935866544 11348262912 1958617696 19.295 100 91 177 1 2020899104 34440192 27841216
14:43:28 2855 8192000000 10922583920 11335798784 1930559408 19.071 99 78 154 0 1989743216 35372112 23811696
14:43:39 4129 8192000000 10927536400 11338219520 1939081152 19.139 99 79 158 0 2001446208 37244736 25120320
14:43:50 1889 8192000000 10925706432 11332423680 1938577760 19.135 100 85 170 0 2005692848 39029840 28085248
14:43:59 3555 8192000000 10923827744 11334496256 1942790864 19.169 100 79 156 1 2005458304 38484608 24182832
14:44:10 3422 8192000000 10938214976 11346722816 1956014896 19.274 100 90 179 1 2023204688 38938768 28251024
14:44:21 4529 8192000000 10938519520 11344523264 1940364592 19.150 99 84 168 1 2005992160 39406608 26220960
14:44:33 4048 8192000000 10922089920 11337539584 1943557088 19.175 100 74 148 1 2007768688 40591472 23620128
14:44:45 6093 8192000000 10930283280 11341729792 1945903136 19.194 100 67 133 0 2006913728 40249328 20761264
14:45:00 1618 8192000000 10936908544 11342024704 1930244384 19.069 99 89 178 1 2000913072 42065344 28603344
14:45:10 3651 8192000000 10922312928 11333500928 1927436432 19.046 99 77 155 0 1993043584 41226496 24380656
14:45:20 1820 8192000000 10944829216 11349815296 1952008064 19.242 100 92 184 1 2021697184 42029968 27659152
14:45:30 6164 8192000000 10920208848 11345649664 1952416080 19.246 100 64 128 0 2014835760 42602832 19816848
14:45:43 7938 8192000000 10913775072 11350614016 1954151216 19.260 100 39 78 0 2002935568 35992320 12792032
14:45:58 11322 8192000000 10937928512 11364438016 1965289328 19.348 100 55 107 2 2018727008 36179280 17258400
14:46:20 3022 8192000000 10940165920 11360354304 1967791760 19.368 100 74 147 0 2029357232 38391760 23173712
14:46:31 3852 8192000000 10932984880 11338493952 1944684992 19.184 99 89 176 3 2013095744 41311568 27099184
14:46:43 3487 8192000000 10956225296 11364114432 1969729744 19.383 100 80 160 0 2035175648 41046784 24399120
14:46:55 3124 8192000000 10959933984 11367735296 1971707424 19.399 100 72 140 0 2035342512 42066160 21568928
14:47:05 1807 8192000000 10970618944 11375828992 1978445360 19.452 100 92 183 1 2050563184 43845824 28272000
14:47:13 1787 8192000000 10979910160 11385593856 1986002880 19.512 100 93 181 0 2057845440 44318912 27523648
14:47:23 2696 8192000000 10976720944 11380875264 1968216944 19.371 99 89 176 0 2041167792 45892704 27058144
14:47:33 1438 8192000000 10987456128 11392585728 1990009264 19.544 100 96 192 0 2065831328 46393808 29428256
14:47:41 2196 8192000000 10977426032 11380604928 1981988960 19.480 100 88 175 3 2056042112 46981552 27071600
14:47:51 3274 8192000000 10962950080 11378139136 1971699456 19.399 100 69 140 0 2040240672 46366176 22175040
14:48:01 8152 8192000000 10947806560 11375747072 1969380832 19.381 100 49 96 0 2030302352 45074768 15846752
14:48:16 5159 8192000000 10964265728 11382558720 1976415680 19.436 100 58 114 2 2041303664 46043568 18844416
14:48:27 5997 8192000000 10945386896 11364147200 1932201072 19.084 98 57 113 2 1998438032 47299600 18937360
14:48:43 6498 8192000000 10948285008 11373576192 1966104976 19.355 100 54 108 1 2035519728 50896896 18517856
14:48:57 6194 8192000000 10942207360 11364704256 1939433056 19.142 99 58 116 2 2011100848 52097424 19570368
14:49:17 8593 8192000000 10936562032 11367788544 1950516816 19.231 100 45 89 1 2020105312 54149920 15438576
14:49:34 14298 8192000000 10947353408 11385974784 1965908832 19.353 100 48 92 0 2036318832 53934976 16475024
14:49:56 4042 8192000000 10960027040 11383640064 1951187968 19.236 99 70 140 0 2030468320 55973328 23307024
14:50:12 6667 8192000000 10933446928 11362320384 1937140912 19.124 99 53 106 2 2003692512 49104080 17447520
14:50:30 11118 8192000000 10944073312 11375910912 1953089152 19.251 100 51 103 0 2022931312 53064800 16777360
14:50:48 11688 8192000000 10926086368 11367993344 1948435088 19.214 100 43 86 0 2017813568 54510752 14867728
14:51:09 13076 8192000000 10932300496 11361710080 1947818944 19.209 100 35 69 0 2014929392 54198208 12912240
14:51:29 14690 8192000000 10932297856 11379195904 1954574448 19.263 100 41 80 1 2026164528 57852640 13737440
14:51:53 20259 8192000000 10935815408 11383468032 1956275600 19.276 100 43 84 3 2027185216 56774704 14134912
14:52:21 7586 8192000000 10936196320 11376291840 1947281136 19.205 100 27 52 2 2013928640 56424784 10222720
14:52:35 15524 8192000000 10935220320 11383648256 1952045152 19.243 100 36 72 1 2022311696 57404688 12861856
14:53:11 2633 8192000000 10953027008 11382734848 1961944480 19.321 100 59 116 0 2034039472 52871760 19223232
14:53:21 1569 8192000000 10974942784 11389480960 1966681152 19.359 100 86 169 5 2052167152 56785376 28700624
14:53:29 13337 8192000000 10935168336 11382018048 1932617136 19.088 99 33 66 0 2006037488 61715600 11704752
14:53:58 41211 8192000000 10900410928 11365109760 1945369504 19.190 100 21 42 2 2000791104 47678000 7743600
14:54:45 46321 8192000000 10900441600 11362889728 1941018432 19.155 100 16 32 1 1983101056 36133824 5948800
14:55:38 22659 8192000000 10898163904 11377577984 1949997984 19.226 100 8 16 0 1980312864 27923248 2391632
14:56:07 47734 8192000000 10884957216 11356262400 1910747344 18.913 98 8 16 1 1936855568 23405808 2702416
14:57:16 56883 8192000000 10886671328 11329122304 1913599008 18.936 98 22 43 0 1925470656 6534992 5336656
14:58:28 20893 8192000000 10864634272 11318398976 1912601024 18.928 98 8 16 0 1923060656 7851168 2608464
14:58:55 53820 8192000000 10905349184 11344388096 1937249968 19.125 99 32 63 1 1954920160 8996352 8673840
14:59:55 90149 8192000000 10901572304 11347795968 1934858608 19.106 98 26 51 4 1952957232 11593872 6504752
15:01:32 136029 8192000000 10893242480 11359318016 1944799216 19.185 99 14 28 1 1962765744 14225984 3740544
15:04:05 25658 8192000000 10920148784 11362041856 1971943392 19.401 100 33 66 1 1990294960 9399040 8952528
15:04:46 71335 8192000000 10928046992 11386044416 1986045200 19.513 100 29 58 1 2006149712 11740416 8364096
15:06:33 55968 8192000000 10921260816 11391152128 1991796320 19.558 100 17 34 0 2011267792 14787120 4684352
15:08:02 15379 8192000000 10911898592 11376717824 1974400496 19.420 99 29 58 2 1993265008 10855408 8009104
15:08:35 33464 8192000000 10913495968 11369951232 1949014240 19.219 98 27 52 0 1966339984 9694400 7631344
15:09:15 18889 8192000000 10919307904 11378573312 1987858000 19.527 100 50 100 1 2013354800 10383168 15113632
15:09:42 12439 8192000000 10944598144 11378585600 1976156496 19.434 99 69 134 1 2005337216 9482320 19698400
15:10:01 6361 8192000000 10936412144 11388964864 1993570000 19.572 100 54 108 0 2020581600 12157216 14854384
15:10:25 13215 8192000000 10912923808 11374501888 1969808448 19.384 99 31 62 1 1989134144 10366160 8959536
15:10:49 45484 8192000000 10921501936 11385933824 1986280912 19.514 100 12 24 0 1998693584 9223008 3189664
15:11:46 10771 8192000000 10887289120 11368620032 1963845648 19.337 99 5 10 0 1971896576 6586208 1464720
15:12:03 3670 8192000000 10905036496 11376734208 1984847200 19.503 100 23 46 4 1997228480 6154960 6226320
15:12:14 8078 8192000000 10901786560 11373281280 1981974832 19.480 100 21 42 3 1994681920 6831424 5875664
15:12:28 27361 8192000000 10910098576 11378098176 1973519968 19.413 99 18 37 0 1987041776 8497952 5023856
15:13:58 32713 8192000000 10886915360 11358707712 1953378528 19.253 99 19 38 2 1970577168 11378288 5820352
15:14:37 27221 8192000000 10899423328 11370168320 1970875824 19.392 100 13 26 2 1984134192 9355152 3903216
15:15:11 38422 8192000000 10901896448 11369795584 1954926192 19.266 99 20 40 3 1974256528 12826704 6503632
15:15:59 82296 8192000000 10872450160 11351580672 1952694048 19.248 99 20 40 0 1968348144 9682352 5971744
15:17:54 22068 8192000000 10889970352 11349463040 1959686112 19.304 100 23 46 0 1972381728 6256032 6439584
15:18:25 25006 8192000000 10879668128 11351760896 1947694848 19.208 99 24 48 0 1964914304 10819744 6399712
15:19:10 57287 8192000000 10886851072 11363758080 1968106592 19.370 100 25 50 1 1989289648 14297280 6885776
15:20:31 58450 8192000000 10874379472 11364335616 1910465120 18.910 97 8 16 0 1927117488 14075872 2576496
15:21:50 72973 8192000000 10862420752 11340660736 1857389808 18.482 95 9 18 1 1873181296 13678080 2113408
15:23:09 64440 8192000000 10858311952 11320487936 1810707968 18.102 93 22 44 0 1830291728 13294160 6289600
15:24:19 29577 8192000000 10870863920 11329409024 1887088720 18.722 97 33 66 1 1904446880 8251744 9106416
15:24:55 46513 8192000000 10882949952 11352580096 1939359024 19.142 100 24 48 0 1961169936 14738480 7072432
15:25:51 65083 8192000000 10873313968 11333509120 1886840304 18.720 97 26 52 1 1914143648 19904832 7398512
15:27:12 33227 8192000000 10889373040 11340943360 1942053072 19.163 100 40 80 1 1969657152 16638064 10966016
15:28:00 57573 8192000000 10887854288 11356577792 1945052272 19.187 100 18 36 1 1974015232 23634496 5328464
15:29:42 64110 8192000000 10911385120 11381010432 1929957744 19.067 98 14 28 2 1950650768 17361248 3331776
15:30:59 38599 8192000000 10907065744 11360514048 1911501360 18.919 97 26 52 0 1936007264 16605152 7900752
15:31:44 12183 8192000000 10899678896 11358703616 1942471584 19.166 99 29 58 2 1966082304 15665040 7945680
15:32:03 34563 8192000000 10870337648 11325136896 1875140528 18.626 96 30 60 0 1895685808 12432704 8112576
15:32:44 45362 8192000000 10884945072 11343028224 1924810944 19.025 99 29 58 0 1946367952 13746304 7810704
15:33:37 96577 8192000000 10865978064 11329552384 1872772784 18.607 96 18 36 0 1893874256 16401504 4699968
15:35:20 76785 8192000000 10867130576 11351404544 1906775360 18.881 98 14 28 0 1928203104 17543760 3883984
15:36:55 105894 8192000000 10849755264 11316142080 1907688512 18.888 98 22 44 1 1922494640 8783632 6022496
15:39:08 16551 8192000000 10855556096 11325456384 1921487376 18.999 99 23 46 1 1935954272 8376128 6090768
15:39:34 33284 8192000000 10788493040 11248828416 1830206768 18.261 95 24 47 6 1843497024 6083392 7206864
15:40:21 42196 8192000000 10831928384 11307544576 1911983712 18.923 100 7 14 0 1920925984 6917280 2024992
15:41:10 49645 8192000000 10848049664 11321569280 1918903120 18.978 100 10 19 0 1931463264 9940176 2619968
15:42:09 42824 8192000000 10846143040 11313324032 1887426560 18.725 98 14 28 0 1901175216 9620528 4128128
15:42:58 61181 8192000000 10866841872 11332595712 1937027696 19.123 100 26 52 3 1957534736 12648672 7858368
15:44:06 57221 8192000000 10862025168 11343896576 1938091712 19.132 100 18 35 2 1961464832 17231904 6141216
15:45:10 38705 8192000000 10873200864 11345436672 1936184800 19.116 100 17 34 1 1957647856 16001632 5461424
15:45:55 77594 8192000000 10861363664 11343368192 1888117456 18.731 97 18 36 1 1907060512 13947312 4995744
15:47:19 49588 8192000000 10858567344 11327401984 1914443952 18.942 99 18 36 0 1927082800 7678768 4960080
15:48:15 31918 8192000000 10869017120 11337928704 1938718864 19.137 100 39 76 0 1960135552 10045280 11371408
15:48:59 47841 8192000000 10858182624 11324243968 1869959616 18.584 96 22 44 2 1888869040 12521376 6388048
15:49:58 65000 8192000000 10882187072 11354316800 1931200128 19.076 99 27 54 2 1948966416 10728048 7038240
15:51:12 71728 8192000000 10876195760 11351912448 1919055792 18.979 98 28 56 3 1937944048 11390848 7497408
15:52:38 42769 8192000000 10910742336 11365519360 1962859744 19.329 100 33 66 0 1984380848 11637920 9883184
15:53:35 53365 8192000000 10873001968 11358253056 1914317136 18.941 98 18 36 1 1935124352 15985840 4821376
15:54:35 100779 8192000000 10886538512 11358822400 1920892416 18.994 98 19 38 0 1937701264 11727552 5081296
15:56:22 38474 8192000000 10901083440 11359424512 1948696208 19.216 99 39 76 3 1969829152 10168224 10964720
15:57:17 22991 8192000000 10915060432 11373776896 1966217008 19.355 100 35 70 0 1989294896 13657776 9420112
15:57:46 87033 8192000000 10852020736 11320471552 1877267040 18.643 96 9 18 0 1897816912 18324032 2225840
16:00:04 76093 8192000000 10864682192 11316781056 1866460848 18.556 96 25 52 2 1883099616 9391328 7247440
16:01:26 42020 8192000000 10835227888 11309600768 1907442208 18.886 99 28 54 2 1925047984 10259840 7345936
16:02:23 51373 8192000000 10846800816 11324727296 1903599632 18.855 99 14 28 0 1921471760 14268496 3603632
16:03:21 35470 8192000000 10841954240 11322925056 1905057824 18.867 99 9 18 0 1921731376 14276032 2397520
16:04:02 15458 8192000000 10844200880 11320365056 1900688944 18.832 99 16 32 0 1919475536 13816896 4969696
16:05:29 40704 8192000000 10844528496 11313623040 1890202848 18.747 98 28 58 1 1906467456 8004768 8259840
16:06:27 33774 8192000000 10861835712 11330088960 1903888288 18.858 98 23 46 0 1918420528 7207120 7325120
16:07:07 68958 8192000000 10894069552 11361787904 1929567552 19.063 99 16 32 1 1945445568 10979440 4898576
16:09:02 79210 8192000000 10893472544 11376984064 1940453024 19.150 99 26 52 0 1966003872 18012240 7538608
16:10:31 104222 8192000000 10894412880 11369132032 1925063600 19.027 98 10 20 0 1944066720 16154160 2848960
16:12:22 29854 8192000000 10878947408 11340197888 1897440560 18.806 97 20 39 3 1910723616 7303136 5979920
16:12:59 30188 8192000000 10903198272 11360202752 1932390816 19.086 99 32 64 2 1953984768 13056608 8537344
16:13:38 42073 8192000000 10869606480 11350634496 1915552272 18.951 98 26 52 1 1938663232 15244592 7866368
16:15:10 51327 8192000000 10876490000 11346403328 1902427056 18.846 98 17 34 0 1920724592 13635440 4662096
16:16:12 59571 8192000000 10871404496 11329318912 1883748384 18.695 97 28 57 2 1903595408 11904592 7942432
16:17:30 104190 8192000000 10872058992 11335581696 1867844400 18.567 96 18 34 2 1883429856 10957936 4627520
16:19:29 67256 8192000000 10860976656 11331674112 1904890992 18.866 98 19 38 0 1917072288 6386336 5794960
16:20:49 11201 8192000000 10869402720 11333640192 1929169536 19.060 99 36 74 0 1947155664 7970416 10015712
16:21:06 21488 8192000000 10870173408 11343503360 1943953840 19.178 100 22 44 1 1957597360 7426976 6216544
16:21:34 45737 8192000000 10863645424 11351142400 1932369808 19.086 99 16 33 2 1946782720 9655840 4757072
16:22:30 39389 8192000000 10861680784 11334209536 1930715264 19.073 99 8 15 0 1941525056 8721840 2087952
16:23:15 48813 8192000000 10856198448 11331158016 1909090864 18.899 98 12 24 0 1920589840 8094048 3404928
16:24:22 47427 8192000000 10866584800 11331121152 1910709072 18.912 98 20 40 1 1927260624 10250960 6300592
16:25:21 36850 8192000000 10874556544 11347918848 1948224736 19.212 100 25 49 1 1966624832 10959744 7440352
16:26:06 68234 8192000000 10862754768 11344314368 1931860256 19.082 99 19 38 2 1947565056 9365024 6339776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 03-02-2021 16:29:25 to 03-02-2021 16:29:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 184 v_add_invoice_to_stock 335544517
except 21 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-02-2021 16:29:59 to 03-02-2021 16:30:01.

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          248795
MON$OLDEST_ACTIVE               250991
MON$OLDEST_SNAPSHOT             250991
MON$NEXT_TRANSACTION            250991
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                       2044320
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:110: 
:111: mscs-test-161.budzdorov.ru    Wed Feb  3 16:27:34 2021
:112:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:113: 
:114: 
:115: mscs-test-161.budzdorov.ru    Wed Feb  3 16:27:34 2021
:116:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:117: 
--- end of diff output ---

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

03.02.21 16:30:02. 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-02-03 16:30:04 No severe PSQL-related problems occured
03.02.21 16:30:06. End of report.