Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.06.2021 19: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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17381908 kB
MemAvailable 31421776 kB
Buffers 0 kB
Cached 14319596 kB
SwapCached 2976 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-06-16 19:27:36
DTS_END                         2021-06-16 19:27:36.4090
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49332
TRN_ID                          239721
ATT_ID                          678
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: 8921.53 22256 1070583
customer order: creation 173.93 373 20871
customer order: refuse 14.92 385 1790
order to supplier: creation 45.65 1396 5478
order to supplier: removal 3.23 105462 388
invoice (draft): creation 47.25 4044 5670
invoice (draft): removal 49.38 824 5926
invoice accept: apply 41.83 18161 5019
invoice accept: cancel 44.58 846 5350
customer reserve: creation 3773.30 182 452796
customer reserve: removal 4429.87 60 531584
realization accept: apply 85.03 188 10203
realization accept: cancel 80.12 113 9614
payment from customer: creation 60.29 113 7235
payment from customer: removal 5.76 86 691
payment to supplier: creation 49.68 136 5961
payment to supplier: removal 3.53 70 424
service: total inventory turnovers 5.14 956 617
service: total monetary turnovers 7.19 28 863
service: aggregate perf. data 0.83 20512 99
service: refresh index statistics 0.03 291178 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-06-2021 19:29:11 to 16-06-2021 19:29:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2861
TEST_TIME 2 3277
TEST_TIME 3 4438
TEST_TIME 4 4474
TEST_TIME 5 5142
TEST_TIME 6 5057
TEST_TIME 7 6101
TEST_TIME 8 6542
TEST_TIME 9 6568
TEST_TIME 10 6718
TEST_TIME 11 6657
TEST_TIME 12 6701
TEST_TIME 13 6717
TEST_TIME 14 6816
TEST_TIME 15 7001
TEST_TIME 16 6978
TEST_TIME 17 7008
TEST_TIME 18 6972
TEST_TIME 19 7257
TEST_TIME 20 7370
TEST_TIME 21 8027
TEST_TIME 22 8350
TEST_TIME 23 8356
TEST_TIME 24 8861
TEST_TIME 25 9804
TEST_TIME 26 9899
TEST_TIME 27 11017
TEST_TIME 28 10872
TEST_TIME 29 10717
TEST_TIME 30 10527
TEST_TIME 31 10374
TEST_TIME 32 10355
TEST_TIME 33 10242
TEST_TIME 34 10060
TEST_TIME 35 9899
TEST_TIME 36 9712
TEST_TIME 37 9786
TEST_TIME 38 9900
TEST_TIME 39 9706
TEST_TIME 40 9591
TEST_TIME 41 9529
TEST_TIME 42 9470
TEST_TIME 43 9452
TEST_TIME 44 9524
TEST_TIME 45 9501
TEST_TIME 46 9364
TEST_TIME 47 9240
TEST_TIME 48 9125
TEST_TIME 49 9351
TEST_TIME 50 9516
TEST_TIME 51 9443
TEST_TIME 52 9473
TEST_TIME 53 9400
TEST_TIME 54 9456
TEST_TIME 55 9500
TEST_TIME 56 9435
TEST_TIME 57 9471
TEST_TIME 58 9487
TEST_TIME 59 9497
TEST_TIME 60 9577
TEST_TIME 61 9595
TEST_TIME 62 9522
TEST_TIME 63 9434
TEST_TIME 64 9384
TEST_TIME 65 9304
TEST_TIME 66 9269
TEST_TIME 67 9230
TEST_TIME 68 9204
TEST_TIME 69 9144
TEST_TIME 70 9081
TEST_TIME 71 9097
TEST_TIME 72 9069
TEST_TIME 73 9100
TEST_TIME 74 9117
TEST_TIME 75 9110
TEST_TIME 76 9071
TEST_TIME 77 9141
TEST_TIME 78 9204
TEST_TIME 79 9151
TEST_TIME 80 9225
TEST_TIME 81 9196
TEST_TIME 82 9206
TEST_TIME 83 9285
TEST_TIME 84 9251
TEST_TIME 85 9303
TEST_TIME 86 9302
TEST_TIME 87 9210
TEST_TIME 88 9206
TEST_TIME 89 9153
TEST_TIME 90 9204
TEST_TIME 91 9170
TEST_TIME 92 9089
TEST_TIME 93 9079
TEST_TIME 94 9073
TEST_TIME 95 9109
TEST_TIME 96 9071
TEST_TIME 97 9103
TEST_TIME 98 9096
TEST_TIME 99 9070
TEST_TIME 100 9071
TEST_TIME 101 9104
TEST_TIME 102 9103
TEST_TIME 103 9115
TEST_TIME 104 9104
TEST_TIME 105 9104
TEST_TIME 106 9111
TEST_TIME 107 9225
TEST_TIME 108 9208
TEST_TIME 109 9192
TEST_TIME 110 9173
TEST_TIME 111 9113
TEST_TIME 112 9088
TEST_TIME 113 9088
TEST_TIME 114 9076
TEST_TIME 115 9045
TEST_TIME 116 9060
TEST_TIME 117 9015
TEST_TIME 118 8989
TEST_TIME 119 8972
TEST_TIME 120 8929

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-06-2021 19:29:15 to 16-06-2021 19: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 1491744 1491744 0 0.00 0 24794 6 0 0
doc_list_biud 1491744 1491744 0 0.00 0 60058 28 0 0
sp_add_invoice_to_stock 5124 5019 105 2.04 38 224885 18162 0 105
sp_cancel_adding_invoice 5350 5350 0 0.00 4 53870 846 0 0
sp_cancel_client_order 1790 1790 0 0.00 4 11059 386 0 0
sp_cancel_customer_reserve 531584 531584 0 0.00 1 22812 61 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 5066 87 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 2 2826 70 0 0
sp_cancel_supplier_invoice 5935 5926 9 0.15 1 60062 825 0 9
sp_cancel_supplier_order 388 388 0 0.00 7 1160048 105463 0 0
sp_cancel_write_off 9614 9614 0 0.00 1 24796 114 0 0
sp_client_order 20871 20871 0 0.00 3 30984 374 0 0
sp_customer_reserve 452796 452796 0 0.00 0 92272 183 0 0
sp_fill_shopping_cart 32013 32013 0 0.00 1 29765 45 0 0
sp_fill_shopping_cart_clo_res 452788 452788 0 0.00 0 16727 12 0 0
sp_get_clo_for_invoice 5011 5011 0 0.00 0 18579 278 0 0
sp_kill_cost_storno 16079 16079 0 0.00 0 24792 59 0 0
sp_kill_qstorno_ret_qs2qd 1079096 1079096 0 0.00 0 60054 33 0 0
sp_kill_qty_storno 569866 569866 0 0.00 0 60057 71 0 0
sp_lock_selected_doc 21076 21076 0 0.00 0 10029 6 0 0
sp_make_cost_storno 28410 28410 0 0.00 0 19069 52 0 0
sp_multiply_rows_for_pdistr 28410 28410 0 0.00 0 18278 31 0 0
sp_multiply_rows_for_qdistr 20871 20871 0 0.00 0 18787 146 0 0
sp_pay_from_customer 7235 7235 0 0.00 4 12622 113 0 0
sp_pay_to_supplier 5961 5961 0 0.00 5 18304 136 0 0
sp_payment_common 13196 13196 0 0.00 1 7653 28 0 0
sp_qd_handle_on_cancel_clo 1790 1790 0 0.00 0 9740 339 0 0
sp_qd_handle_on_invoice_upd_sts 10361 10361 0 0.00 0 33224 345 0 0
sp_qd_handle_on_reserve_upd_sts 10203 10203 0 0.00 0 29813 66 0 0
sp_reserve_write_off 10203 10203 0 0.00 6 29939 189 0 0
sp_supplier_invoice 5670 5670 0 0.00 6 102749 4044 0 0
sp_supplier_order 5478 5478 0 0.00 5 23355 1396 0 0
srv_aggregate_perf_data 99 99 0 0.00 2497 361738 20512 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1088 169615 32399 0 0
srv_find_qd_qs_mism 1023652 1023652 0 0.00 0 7909 5 0 0
srv_make_invnt_saldo 617 617 0 0.00 20 57961 956 0 0
srv_make_money_saldo 863 863 0 0.00 1 1215 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 192520 372725 291179 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 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 5019 5019 0 0.00 0 22236 224 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 2198 92 0 0
t$perf-norm:sp_cancel_client_order 1790 1790 0 0.00 0 9735 22 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 972 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 19213 33 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 878 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 412 10 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 21190 1669 0 0
t$perf-norm:sp_cancel_write_off 1050 1050 0 0.00 0 3759 16 0 0
t$perf-norm:sp_client_order 20871 20871 0 0.00 0 13478 22 0 0
t$perf-norm:sp_customer_reserve 1036 1036 0 0.00 0 2362 7 0 0
t$perf-norm:sp_pay_from_customer 7235 7235 0 0.00 0 6913 12 0 0
t$perf-norm:sp_pay_to_supplier 5961 5961 0 0.00 0 19227 18 0 0
t$perf-norm:sp_reserve_write_off 10203 10203 0 0.00 0 17610 16 0 0
t$perf-norm:sp_supplier_invoice 5670 5670 0 0.00 0 10315 21 0 0
t$perf-norm:sp_supplier_order 5478 5478 0 0.00 0 6107 20 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 245 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 3940 26 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 978 23 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 4252 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10232 10022 210 2.05 0 8389 19 0 210
v_all_customers 38398 38398 0 0.00 0 18 1 0 0
v_all_suppliers 30686 30686 0 0.00 0 24 1 0 0
v_all_wares 41742 41742 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 650 6 0 0
v_cancel_client_order 3580 3580 0 0.00 0 477 3 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 3293 12 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 452 3 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 1437 5 0 0
v_cancel_supplier_invoice 820 802 18 2.19 0 3783 21 0 18
v_cancel_supplier_order 776 776 0 0.00 0 5403 10 0 0
v_cancel_write_off 2100 2100 0 0.00 0 2910 16 0 0
v_max_id_clo_ord 5478 5478 0 0.00 0 3423 3 0 0
v_max_id_clo_res 1036 1036 0 0.00 0 2606 18 0 0
v_max_id_ord_sup 5664 5664 0 0.00 0 5331 8 0 0
v_max_non_paid_invoice 1760 1760 0 0.00 0 1261 3 0 0
v_max_non_paid_realizn 3755 3755 0 0.00 0 1826 4 0 0
v_min_id_clo_ord 5478 5478 0 0.00 0 1506 5 0 0
v_min_id_clo_res 1036 1036 0 0.00 0 719 4 0 0
v_min_id_ord_sup 5664 5664 0 0.00 0 5450 7 0 0
v_min_non_paid_invoice 5961 5961 0 0.00 0 4765 18 0 0
v_min_non_paid_realizn 7235 7235 0 0.00 0 7646 18 0 0
v_our_firm 10304 10304 0 0.00 0 169 1 0 0
v_reserve_write_off 20406 20406 0 0.00 0 5256 5 0 0
x_lock_depdocs_on_canc_invoice 10875 10875 0 0.00 0 21436 130 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 6353 360 0 0
x_make_qstorno_1000_1200 5478 5478 0 0.00 1 23341 1313 0 0
x_make_qstorno_1200_2000 5670 5670 0 0.00 2 101789 3870 0 0
x_make_qstorno_2100_3300 452796 452796 0 0.00 0 92271 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-06-2021 19:29:19 to 16-06-2021 19: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
16:57:40 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
16:57:46 26455 8192000000 10314252064 10629222400 1021169760 11.083 76 60 121 0 1044067120 2848528 20048832
16:58:25 34541 8192000000 10372611648 10694668288 1423039808 14.800 100 88 177 1 1458181808 6595072 28546928
16:59:10 16415 8192000000 10397574240 10723532800 1450871616 15.046 100 90 180 1 1488061152 7739616 29449920
16:59:36 11019 8192000000 10407494816 10735906816 1465341904 15.173 100 91 182 1 1503923920 8485520 30096496
16:59:55 22523 8192000000 10425528912 10755817472 1476371136 15.270 100 89 178 0 1513810272 8682416 28756720
17:00:26 4523 8192000000 10431126736 10763198464 1490649456 15.395 100 89 178 0 1528333056 9110016 28573584
17:00:49 20611 8192000000 10452642816 10789617664 1500883744 15.484 100 82 164 2 1537003616 9667680 26452192
17:01:31 20157 8192000000 10473930256 10813919232 1527314080 15.714 100 86 172 0 1564627216 10184096 27129040
17:02:05 14990 8192000000 10499541808 10844069888 1556708928 15.968 100 89 178 1 1594786576 10701936 27375712
17:02:28 17256 8192000000 10521526928 10868703232 1571790976 16.098 100 78 156 1 1605460544 10272000 23397568
17:03:14 10294 8192000000 10554886016 10915827712 1616255184 16.478 100 76 152 2 1649706928 10874672 22577072
17:03:41 13318 8192000000 10591182672 10951966720 1647098256 16.740 100 83 166 0 1683750400 12155424 24496720
17:04:06 9898 8192000000 10610101520 10970939392 1664429312 16.886 100 89 178 1 1703682320 13038320 26214688
17:04:23 10745 8192000000 10627704160 10994794496 1680054880 17.018 100 80 157 3 1714920416 12472528 22393008
17:04:41 9217 8192000000 10632350320 11001823232 1696779376 17.158 100 78 156 0 1732481440 12932704 22769360
17:05:00 6680 8192000000 10649457584 11022565376 1712516384 17.290 100 80 158 0 1748469408 12802016 23151008
17:05:14 8674 8192000000 10658161952 11032584192 1723594752 17.382 100 76 150 1 1757791872 12402464 21794656
17:05:31 5116 8192000000 10672513216 11047424000 1736076176 17.486 100 86 171 1 1774522016 13000720 25445120
17:05:43 5621 8192000000 10690469952 11062919168 1752478352 17.622 100 79 155 1 1787384832 12717440 22189040
17:05:55 4728 8192000000 10700236272 11075031040 1756897568 17.659 100 77 155 1 1791484448 13036688 21550192
17:06:07 4823 8192000000 10708035392 11082981376 1768370960 17.754 100 90 180 2 1808025152 14576336 25077856
17:06:18 3227 8192000000 10711947056 11089027072 1771414672 17.779 100 83 166 1 1809510128 14456048 23639408
17:06:28 4286 8192000000 10712753024 11092004864 1775843840 17.815 100 89 176 0 1813889616 14025248 24020528
17:06:39 4270 8192000000 10725287664 11103252480 1781696064 17.863 100 76 152 1 1816570848 13074640 21800144
17:06:49 3652 8192000000 10732437664 11112767488 1796488560 17.985 100 88 175 2 1833632720 13384528 23759632
17:06:59 1630 8192000000 10747051168 11124686848 1805236288 18.057 100 94 187 3 1843726352 12658736 25831328
17:07:08 6125 8192000000 10739277136 11126718464 1802207872 18.032 100 81 161 2 1837729680 13495824 22025984
17:07:20 4947 8192000000 10734783136 11124932608 1808029376 18.080 100 88 175 2 1845134848 13186640 23918832
17:07:31 1825 8192000000 10758449712 11141750784 1820113392 18.179 100 95 188 0 1860976208 14585600 26277216
17:07:40 1858 8192000000 10768606416 11152285696 1823905056 18.210 100 90 180 1 1862482816 13624944 24952816
17:07:48 2393 8192000000 10767578160 11156213760 1828090720 18.244 100 92 184 1 1869930624 15075280 26764624
17:07:57 2354 8192000000 10780715072 11165884416 1835985632 18.308 100 91 181 2 1874258928 12378144 25895152
17:08:05 1507 8192000000 10778452320 11164614656 1842908736 18.364 100 86 172 0 1879229840 11404272 24916832
17:08:13 1654 8192000000 10792106864 11176263680 1849730096 18.420 100 94 188 2 1887627488 11404624 26492768
17:08:21 2577 8192000000 10798494448 11181268992 1851176624 18.432 100 94 190 2 1891678368 13237360 27264384
17:08:30 1213 8192000000 10803319760 11186782208 1852421344 18.442 100 98 193 2 1893097904 13397936 27278624
17:08:38 1251 8192000000 10798928192 11182776320 1855216064 18.464 100 87 175 0 1893356336 14275488 23864784
17:08:45 16746 8192000000 10771643760 11185139712 1848753360 18.412 100 67 134 0 1880808464 13724208 18330896
17:09:13 11386 8192000000 10796333184 11184893952 1857153344 18.480 100 79 160 2 1891425792 11083376 23189072
17:09:30 4143 8192000000 10769083584 11187806208 1854766608 18.461 100 36 72 0 1874173584 9297056 10109920
17:09:42 4604 8192000000 10773663296 11191701504 1856811264 18.477 100 29 59 0 1872066048 7430800 7823984
17:09:55 6726 8192000000 10772014592 11192225792 1860871584 18.510 100 25 51 1 1874453184 6603200 6978400
17:10:08 3598 8192000000 10776803904 11199770624 1865892288 18.551 100 29 58 1 1881666848 7760176 8014384
17:10:23 6257 8192000000 10779596608 11202420736 1866281856 18.554 100 26 52 3 1879331248 6184288 6865104
17:10:35 3609 8192000000 10780670704 11202494464 1867898064 18.567 100 31 62 1 1885056768 7561248 9597456
17:10:50 3988 8192000000 10788209024 11209277440 1873711408 18.614 100 28 57 2 1888285680 7189808 7384464
17:11:01 5937 8192000000 10788372832 11213160448 1878886848 18.656 100 35 71 3 1894888832 6754432 9247552
17:11:15 8565 8192000000 10780706064 11210395648 1874861840 18.624 100 22 44 0 1887606544 6500144 6244560
17:11:32 2672 8192000000 10799224256 11219922944 1880763104 18.671 100 34 67 2 1898546208 7753392 10029712
17:11:41 7930 8192000000 10789351520 11217338368 1882761184 18.687 100 25 49 0 1896916080 6921840 7233056
17:11:55 5282 8192000000 10797298304 11226292224 1886632656 18.719 100 27 54 0 1904991920 10766000 7593264
17:12:08 10301 8192000000 10795291600 11224850432 1888221840 18.731 100 17 34 0 1899267632 6184496 4861296
17:12:25 61731 8192000000 10805146208 11237392384 1892249760 18.764 100 30 60 4 1907183104 5134992 9798352
17:13:34 7463 8192000000 10811294960 11247788032 1896913728 18.801 100 32 64 2 1913785712 8174256 8697728
17:13:49 9990 8192000000 10817632176 11248156672 1896780864 18.800 100 22 44 0 1910110352 6333008 6996480
17:14:06 5498 8192000000 10811005424 11246604288 1899394080 18.821 100 30 60 5 1915371840 7016592 8961168
17:14:19 7789 8192000000 10813681120 11247722496 1900592176 18.831 100 19 38 1 1911817504 5552672 5672656
17:14:33 5366 8192000000 10824410704 11254468608 1904698768 18.864 100 30 58 1 1920224064 7347040 8178256
17:14:46 5697 8192000000 10816994960 11256340480 1903513728 18.855 100 16 30 2 1917760656 9786128 4460800
17:14:58 9838 8192000000 10815043696 11249971200 1901377664 18.837 100 23 46 1 1914175808 6647920 6150224
17:15:14 5134 8192000000 10815506784 11253432320 1902109728 18.843 100 25 50 4 1916275264 7218992 6946544
17:15:27 6515 8192000000 10822634624 11255611392 1904516464 18.863 100 29 57 2 1919276832 6406768 8353600
17:15:40 11371 8192000000 10810430608 11252830208 1904374160 18.861 100 16 32 1 1915764880 6229840 5160880
17:16:00 9325 8192000000 10819901696 11256258560 1908329200 18.893 100 20 40 0 1919699424 5663072 5707152
17:16:16 10368 8192000000 10825715616 11262230528 1910647632 18.912 100 24 48 2 1924144832 6501840 6995360
17:16:33 11968 8192000000 10824137984 11255267328 1904002976 18.858 100 13 23 2 1912707120 5546112 3158032
17:16:55 15518 8192000000 10815063104 11236655104 1865329376 18.546 98 16 32 2 1875203232 4945568 4928288
17:17:23 62608 8192000000 10816029872 11251392512 1882777104 18.688 99 29 58 0 1897437072 6775232 7884736
17:18:32 7012 8192000000 10779123648 11201880064 1817737936 18.159 96 22 43 2 1829395376 6112560 5544880
17:18:48 6509 8192000000 10789395360 11215204352 1834081920 18.293 97 30 60 4 1850279120 6768880 9428320
17:19:00 7690 8192000000 10744297152 11159752704 1785126752 17.892 96 24 48 0 1797371808 5811312 6433744
17:19:15 6222 8192000000 10733368272 11153317888 1779260352 17.843 97 20 40 1 1790635648 5814080 5561216
17:19:28 7016 8192000000 10732326080 11157856256 1765786048 17.732 96 17 34 2 1775624576 5046304 4792224
17:19:44 9072 8192000000 10718574448 11128356864 1722061216 17.369 94 28 56 1 1736024880 5121904 8841760
17:20:02 8269 8192000000 10716139184 11136925696 1750261968 17.604 96 28 56 1 1764122336 6023856 7836512
17:20:18 8038 8192000000 10655399456 11059933184 1650734368 16.771 92 27 53 3 1664798784 5745280 8319136
17:20:33 4232 8192000000 10702677360 11111284736 1757857824 17.667 98 31 62 1 1772422176 5493584 9070768
17:20:45 9536 8192000000 10689907376 11104051200 1714867056 17.309 96 17 34 0 1725563360 5203088 5493216
17:21:03 8289 8192000000 10660989824 11070164992 1678355296 17.004 94 38 76 0 1695427968 5253312 11819360
17:21:22 11622 8192000000 10695745088 11100307456 1734949664 17.477 98 21 41 1 1746521792 5622240 5949888
17:21:42 12438 8192000000 10692599984 11109326848 1733705488 17.466 97 18 36 2 1748147392 9274704 5167200
17:22:01 65743 8192000000 10728465248 11148640256 1770762400 17.773 98 34 68 2 1786198368 5319616 10116352
17:23:19 12307 8192000000 10733599536 11158200320 1815608016 18.142 100 21 42 1 1831053808 9704496 5741296
17:23:39 6969 8192000000 10752519056 11163553792 1810759952 18.102 99 41 82 2 1830051552 7580064 11711536
17:23:53 3902 8192000000 10760305728 11166912512 1816263712 18.147 99 43 86 0 1839424944 10356752 12804480
17:24:05 9112 8192000000 10747659200 11169447936 1830951456 18.267 100 40 79 2 1848600112 6822416 10826240
17:24:23 8230 8192000000 10773533744 11186843648 1842537888 18.361 100 40 79 4 1861094032 6974768 11581376
17:24:42 7166 8192000000 10770647328 11189944320 1847016400 18.398 100 39 78 1 1865477360 6602544 11858416
17:24:57 7080 8192000000 10763892656 11189829632 1849999200 18.422 100 44 88 2 1869945648 6177104 13769344
17:25:14 5998 8192000000 10767772192 11197362176 1857133360 18.480 100 40 80 0 1875550752 6155168 12262224
17:25:31 4635 8192000000 10774643616 11201069056 1857822864 18.486 100 30 60 0 1872732896 6060752 8849280
17:25:42 14859 8192000000 10775569936 11205275648 1857692864 18.485 100 19 37 0 1868996784 5654080 5649840
17:26:05 10551 8192000000 10772808096 11207311360 1864185136 18.537 100 19 38 1 1876184512 6015136 5984240
17:26:23 7347 8192000000 10789942064 11217444864 1865294016 18.546 100 19 38 0 1876184064 4959600 5930448
17:26:37 12826 8192000000 10780767008 11210375168 1866896080 18.559 100 19 38 0 1878269584 5798128 5575376
17:26:58 62222 8192000000 10817128304 11235766272 1881263712 18.675 100 29 55 2 1894225056 5125808 7835536
17:28:17 48614 8192000000 10849579280 11260694528 1906815376 18.881 100 52 105 1 1930531104 9308800 14406928
17:29:12 1516 8192000000 10857753056 11267121152 1913529568 18.935 100 63 126 3 1941854608 10419984 17905056
17:29:20 14526 8192000000 10843641984 11268988928 1915785152 18.953 100 49 98 1 1940616768 10766912 14064704
17:29:43 29849 8192000000 10858252608 11285647360 1921718784 19.001 100 42 84 2 1948859184 15443568 11696832
17:30:21 15692 8192000000 10870146832 11293229056 1934589872 19.104 100 59 118 1 1963193616 11707664 16896080
17:30:47 14129 8192000000 10867282896 11292889088 1936315984 19.117 100 52 103 1 1963528096 12496352 14715760
17:31:09 7040 8192000000 10882843312 11304349696 1943627792 19.176 100 62 124 1 1973949632 12534096 17787744
17:31:26 19682 8192000000 10886280672 11305517056 1946975792 19.202 100 63 126 0 1979181040 13917264 18287984
17:31:55 27676 8192000000 10876290160 11316715520 1947171920 19.204 100 43 85 3 1975227024 15565408 12489696
17:32:59 8832 8192000000 10894737904 11330072576 1962142912 19.323 100 46 91 1 1988046608 13031648 12872048
17:33:15 7001 8192000000 10908349664 11336851456 1966334896 19.356 100 53 101 1 1995660640 15039744 14286000
17:33:30 8440 8192000000 10909890560 11340328960 1968447808 19.373 100 50 100 0 1999072592 15921888 14702896
17:33:50 11319 8192000000 10921845696 11354120192 1972816368 19.408 100 48 96 0 2010946544 23841360 14288816
17:34:22 6520 8192000000 10928925488 11358142464 1976500752 19.437 100 58 115 0 2016393792 23172432 16720608
17:34:36 3913 8192000000 10926691920 11354918912 1980146432 19.466 100 64 128 3 2018049328 18692016 19210880
17:34:47 12155 8192000000 10924149392 11355537408 1979980720 19.465 100 46 92 1 2012967296 19447984 13538592
17:35:06 7270 8192000000 10924674352 11361509376 1983680912 19.494 100 53 106 1 2019071744 19774464 15616368
17:35:20 2970 8192000000 10934126800 11359711232 1982840688 19.487 100 63 124 1 2024016464 23555792 17619984
17:35:30 3239 8192000000 10957589232 11373670400 1987340032 19.523 100 70 138 1 2030951488 24221760 19389696
17:35:40 2944 8192000000 10958363680 11377541120 1997233792 19.601 100 87 174 1 2048067984 25561984 25272208
17:35:49 9349 8192000000 10950717360 11373723648 1996580528 19.596 100 74 147 1 2042299984 25206800 20512656
17:36:06 9837 8192000000 10947001488 11379417088 1995444368 19.587 100 66 132 2 2039321952 23955216 19922368
17:36:25 7343 8192000000 10958725712 11386122240 1998936480 19.614 100 70 140 1 2044404288 25480272 19987536
17:36:42 9823 8192000000 10980436656 11399888896 2007667440 19.683 100 70 140 0 2058109184 29965840 20475904
17:37:00 3504 8192000000 10981547808 11400847360 1996857504 19.598 99 81 162 2 2053219840 32088192 24274144
17:37:10 3569 8192000000 10964346768 11379486720 1995472416 19.587 99 80 160 3 2050343472 31675168 23195888
17:37:23 6416 8192000000 10977492096 11405770752 2012010192 19.717 100 69 135 0 2065731344 33674112 20047040
17:37:36 2606 8192000000 10984565664 11413344256 2017121376 19.758 100 69 137 1 2072055424 34420384 20513664
17:37:57 9803 8192000000 10978019680 11407560704 2010815424 19.708 100 68 136 2 2064089584 32735168 20538992
17:38:14 5030 8192000000 10973128272 11399335936 1988182320 19.529 99 64 127 1 2040526016 32733184 19610512
17:38:32 1577 8192000000 10994465440 11412459520 2017765600 19.763 100 89 178 3 2080439776 35760064 26914112
17:38:40 2866 8192000000 11000333232 11417915392 2018836768 19.771 100 82 163 0 2081075232 37548560 24689904
17:38:52 2952 8192000000 10981807952 11406569472 1993650912 19.573 99 73 143 2 2053140304 37259824 22229568
17:39:02 2273 8192000000 10987441952 11410264064 2009053168 19.694 100 76 153 2 2073141984 41701584 22387232
17:39:11 5110 8192000000 10978483792 11405496320 2005699072 19.668 100 70 139 2 2065740656 38362656 21678928
17:39:24 7370 8192000000 10976698096 11403079680 1992605632 19.564 99 76 151 1 2053920864 39337104 21978128
17:39:39 6082 8192000000 10982648736 11408109568 2004978672 19.662 100 75 150 1 2068942896 40812160 23152064
17:39:55 6077 8192000000 10989087072 11414695936 2009753184 19.700 100 63 125 0 2068490336 39536640 19200512
17:40:14 5697 8192000000 10989358528 11420364800 2017241184 19.758 100 73 142 3 2078394560 39824048 21329328
17:40:30 5238 8192000000 11000932848 11429232640 2024355712 19.814 100 63 123 1 2085274608 41927952 18990944
17:40:46 4087 8192000000 11012755776 11437924352 2011559136 19.714 99 80 160 1 2081199136 45042624 24597376
17:40:57 5101 8192000000 11011171904 11439427584 2025388848 19.822 100 66 131 2 2090889696 45051536 20449312
17:41:12 5220 8192000000 11007501792 11433758720 2027324672 19.838 100 80 159 1 2095986384 44865696 23796016
17:41:26 7061 8192000000 10998194496 11410628608 1988925040 19.535 99 75 149 1 2056952576 45307952 22719584
17:41:40 4614 8192000000 10977374032 11403685888 1982761136 19.487 99 68 136 0 2050337712 46334000 21242576
17:41:55 5713 8192000000 10985232640 11406209024 1997265440 19.601 100 69 138 1 2065239424 46857952 21116032
17:42:07 4954 8192000000 10975429792 11391709184 1983434736 19.492 100 73 144 0 2053558144 48039088 22084320
17:42:18 2942 8192000000 10982478528 11397201920 1989367008 19.539 100 85 170 1 2065204384 49843312 25994064
17:42:29 4211 8192000000 10961495600 11390074880 1982562000 19.485 100 71 141 1 2054808912 49782128 22464784
17:42:41 5617 8192000000 10951400464 11372093440 1953695104 19.256 99 77 153 1 2030338944 52619840 24024000
17:42:54 4692 8192000000 10971952800 11388485632 1977887584 19.448 100 74 146 1 2048893872 47429264 23577024
17:43:05 2495 8192000000 10986580016 11398254592 1993514160 19.572 100 74 147 4 2063336160 47238144 22583856
17:43:18 4160 8192000000 10975992176 11399221248 1993009632 19.568 100 66 132 0 2062099360 48664048 20425680
17:43:29 4439 8192000000 10981726176 11401453568 1982887504 19.488 99 72 142 0 2053971936 49151776 21932656
17:43:46 7826 8192000000 10979930208 11401584640 1980865456 19.472 99 77 153 0 2054691824 50150176 23676192
17:44:06 4414 8192000000 10985357200 11410976768 1987128544 19.521 100 66 132 1 2061167680 52830944 21208192
17:44:26 5475 8192000000 10982632992 11409719296 1980886944 19.472 99 63 125 0 2054517104 54177584 19452576
17:44:39 3676 8192000000 10975159120 11388289024 1974064944 19.418 100 81 162 4 2055139392 55708656 25365792
17:44:49 3428 8192000000 10960784864 11377012736 1937913264 19.130 98 80 158 1 2016479152 53682512 24883376
17:45:02 2250 8192000000 10971327968 11386556416 1970509808 19.389 100 79 155 1 2049405488 54720080 24175600
17:45:11 3681 8192000000 10969771520 11378274304 1944105936 19.180 98 82 162 0 2024315232 55526752 24682544
17:45:23 4666 8192000000 10960794512 11375980544 1950568704 19.231 99 76 154 1 2031511600 57315152 23627744
17:45:34 3360 8192000000 10952054288 11361779712 1910888640 18.914 97 77 152 0 1993124880 58347136 23889104
17:45:44 3735 8192000000 10945317424 11357511680 1932452224 19.086 99 81 160 1 2017319520 59842528 25024768
17:45:55 1655 8192000000 10936134912 11336990720 1917083392 18.963 98 86 171 0 2006589824 62661856 26844576
17:46:05 3254 8192000000 10948229792 11358826496 1929517408 19.063 99 82 163 0 2018695488 63744736 25433344
17:46:16 2405 8192000000 10963981728 11367763968 1946215584 19.196 100 80 158 1 2035936528 64581424 25139520
17:46:28 3524 8192000000 10955058144 11365269504 1934200064 19.100 99 79 156 1 2024594160 65215952 25178144
17:46:38 3455 8192000000 10967803104 11373133824 1949242432 19.220 100 86 171 1 2042032368 65815344 26974592
17:46:50 1086 8192000000 10979108512 11382476800 1958056464 19.291 100 92 181 3 2055196048 68240720 28898864
17:46:58 1313 8192000000 10967537504 11372027904 1954572928 19.263 100 84 168 1 2044955040 63045456 27336656
17:47:06 3717 8192000000 10965352096 11377041408 1958530880 19.294 100 75 148 1 2047294016 64590656 24172480
17:47:19 3244 8192000000 10960333520 11373408256 1948819920 19.217 100 78 154 0 2041384992 67472192 25092880
17:47:30 8918 8192000000 10950860528 11371970560 1948006240 19.211 100 64 128 2 2036914336 68204592 20703504
17:47:47 1595 8192000000 10976664176 11385630720 1960090016 19.307 100 89 179 0 2060488000 70435680 29962304
17:47:56 6657 8192000000 10940813584 11368607744 1944008720 19.179 100 63 126 1 2037738992 72586272 21144000
17:48:14 4617 8192000000 10933864720 11364171776 1941043312 19.155 100 50 100 2 2019097488 60662016 17392160
17:48:24 15284 8192000000 10914434960 11345240064 1910947232 18.914 99 43 86 2 1984863552 59203008 14713312
17:48:53 7871 8192000000 10921784880 11354959872 1929846544 19.066 100 38 76 1 2004609408 61480048 13282816
17:49:08 9477 8192000000 10918120912 11362791424 1935397376 19.110 100 36 72 1 2005573136 57649056 12526704
17:49:33 7558 8192000000 10954324688 11383824384 1959235856 19.300 100 58 112 2 2038091904 61300592 17555456
17:49:50 15452 8192000000 10959028832 11399430144 1961991760 19.322 100 45 90 1 2042893904 66011488 14890656
17:50:13 17111 8192000000 10945309648 11389784064 1955020288 19.266 100 34 68 3 2032022176 65176416 11825472
17:50:36 10244 8192000000 10946445056 11382067200 1958802912 19.297 100 33 66 0 2033000928 62776224 11421792
17:50:53 11536 8192000000 10944895072 11388928000 1954884336 19.265 100 31 62 0 2028434320 62133088 11416896
17:51:12 11531 8192000000 10936368288 11386101760 1954733696 19.264 100 27 54 1 2020878016 56088000 10056320
17:51:30 22703 8192000000 10926436848 11375431680 1933005280 19.091 99 27 54 0 1997813760 54695456 10113024
17:52:07 48175 8192000000 10887274064 11345514496 1895810000 18.793 97 25 50 0 1963704944 59101120 8793824
17:53:20 42884 8192000000 10874262672 11327148032 1863243120 18.530 97 16 32 1 1909994192 40871264 5879808
17:54:48 43797 8192000000 10838932784 11315101696 1906868656 18.882 100 12 25 1 1930203360 20338112 2996592
17:55:38 27135 8192000000 10849705536 11288211456 1881076992 18.674 98 40 80 2 1899233744 6837184 11319568
17:56:15 21112 8192000000 10836493936 11292803072 1912152176 18.924 100 27 54 2 1929084912 9281488 7651248
17:56:42 13149 8192000000 10852082192 11303391232 1920987920 18.995 100 24 46 4 1936509760 8115312 7406528
17:57:02 44554 8192000000 10835513824 11285360640 1889376944 18.741 98 13 26 0 1899611504 6856688 3377872
17:57:52 106610 8192000000 10858174640 11316649984 1900177984 18.828 98 12 24 0 1911913344 8616944 3118416
18:00:00 59627 8192000000 10860724256 11318308864 1906087136 18.875 98 26 52 2 1920691008 7214560 7389312
18:01:22 123559 8192000000 10867269280 11334651904 1932730560 19.089 99 18 36 0 1948681152 10336160 5614432
18:03:39 29660 8192000000 10901687680 11343282176 1951649632 19.240 100 51 101 0 1982007232 15727584 14630016
18:04:19 61928 8192000000 10892831312 11348967424 1922196048 19.004 98 22 44 1 1940970368 12539520 6234800
18:05:34 83549 8192000000 10895307760 11347501056 1923135104 19.012 98 28 56 2 1939533168 8084464 8313600
18:07:05 39813 8192000000 10898670416 11336630272 1944273088 19.181 99 32 62 3 1961285296 7850752 9161456
18:08:05 34512 8192000000 10893837264 11349606400 1947742992 19.208 99 28 55 2 1965986368 10252912 7990464
18:08:59 34088 8192000000 10901573600 11363864576 1969545760 19.382 100 27 54 0 1987460272 9871904 8042608
18:09:41 30380 8192000000 10908111264 11365576704 1976800464 19.439 100 28 56 1 1994072240 9723888 7547888
18:10:34 51130 8192000000 10880675712 11329433600 1933867488 19.098 98 45 90 0 1961981984 14625616 13488880
18:11:37 16227 8192000000 10894370992 11351146496 1959905328 19.305 100 33 66 1 1981198640 10825904 10467408
18:12:02 61943 8192000000 10905686480 11377917952 1970236432 19.387 100 15 31 1 1988151024 13342384 4572208
18:13:11 79678 8192000000 10912164224 11384676352 1984356480 19.499 100 17 34 1 2004610656 15102336 5151840
18:14:40 70227 8192000000 10921776928 11386630144 1983218784 19.490 100 16 32 0 2006744992 18329296 5196912
18:16:29 61843 8192000000 10910902640 11397435392 1988585296 19.533 100 13 26 1 2014162448 22084720 3492432
18:18:03 25598 8192000000 10925900336 11375779840 1969605984 19.382 99 54 106 2 1992089280 6668080 15815216
18:18:39 46766 8192000000 10923269360 11385020416 1967200736 19.363 99 26 52 2 1985132400 10469008 7462656
18:19:36 52673 8192000000 10899612992 11373268992 1963461808 19.334 99 17 33 0 1976533920 8792896 4279216
18:20:38 51473 8192000000 10910442640 11384356864 1949654864 19.224 98 30 60 1 1966832624 8874400 8303360
18:21:39 75660 8192000000 10897012576 11379027968 1965827344 19.352 99 16 32 1 1980023920 9646320 4550256
18:23:03 169615 8192000000 10883673616 11360129024 1831472128 18.271 92 13 26 1 1848288112 13455216 3360768
18:26:00 108680 8192000000 10873294832 11343663104 1794883104 17.972 91 10 20 1 1813769952 16447648 2439200
18:27:55 101276 8192000000 10893902224 11345227776 1895974464 18.794 96 17 34 0 1913691856 12969072 4748320
18:29:45 102977 8192000000 10842000576 11305529344 1891545376 18.758 96 39 77 1 1910510736 8270112 10695248
18:31:34 51613 8192000000 10829614432 11282997248 1828405680 18.246 94 36 72 2 1846721248 8103584 10211984
18:32:32 26522 8192000000 10850707456 11305033728 1895083792 18.787 99 27 54 0 1916032832 13710352 7238688
18:33:13 60894 8192000000 10826374896 11290030080 1873456000 18.612 97 21 41 1 1887962512 8402928 6103584
18:34:33 51513 8192000000 10841826048 11304337408 1868797008 18.575 97 14 27 1 1886173504 13449056 3927440
18:35:32 23819 8192000000 10836896816 11313410048 1906119200 18.875 99 20 40 2 1928047760 15791728 6136832
18:36:03 44602 8192000000 10836720656 11305549824 1844643536 18.379 96 6 12 0 1860336512 13953936 1739040
18:37:02 54379 8192000000 10846581184 11314106368 1887002224 18.722 98 25 50 1 1908008560 14316080 6690256
18:38:05 74415 8192000000 10825132976 11291582464 1866807760 18.558 97 14 28 0 1889519824 18409216 4302848
18:39:31 51620 8192000000 10830147088 11297427456 1887047120 18.722 98 13 26 2 1904932048 13643856 4241072
18:40:48 69955 8192000000 10839501232 11310415872 1874424304 18.620 97 13 26 0 1889303872 11032064 3847504
18:42:07 82646 8192000000 10889695376 11352793088 1921083856 18.996 99 14 28 0 1933936112 8878000 3974256
18:43:49 45259 8192000000 10892483376 11359232000 1945765296 19.193 99 33 66 1 1969665024 14078384 9821344
18:45:00 114811 8192000000 10902557152 11372544000 1961051744 19.314 100 7 14 1 1976014704 13135232 1827728
18:47:09 61024 8192000000 10872457632 11352035328 1926195280 19.036 98 16 33 1 1943033600 12420560 4417760
18:48:17 76585 8192000000 10901410048 11362922496 1925241648 19.029 98 22 44 0 1943985008 13075696 5667664
18:49:42 145703 8192000000 10881036752 11359830016 1845721088 18.387 94 15 31 1 1865010960 15038528 4251344
18:52:16 57456 8192000000 10907667264 11364081664 1939564640 19.143 99 23 46 0 1961277440 14852976 6859824
18:53:22 51847 8192000000 10897231936 11369644032 1965176304 19.347 100 23 47 1 1984319232 12837216 6305712
18:55:01 84814 8192000000 10879152336 11366559744 1928768080 19.057 98 10 20 0 1940729616 9212624 2748912
18:56:58 59050 8192000000 10891205952 11378524160 1971794432 19.400 100 22 44 1 1988767600 10801472 6171696
18:58:14 55548 8192000000 10894276720 11390013440 1970766576 19.392 100 6 12 0 1987750048 15786272 1197200
18:59:16 10827 8192000000 10894339664 11389988864 1974828208 19.424 100 4 8 0 1991598832 15955616 815008
18:59:33 12126 8192000000 10902630672 11394514944 1979039056 19.457 100 5 10 0 1995616688 15469296 1108336
18:59:55 53098 8192000000 10895382608 11378098176 1975992864 19.433 100 13 26 0 1988352320 8989952 3369504
19:00:59 78388 8192000000 10892163088 11373805568 1950266176 19.229 98 10 20 0 1961881216 9108976 2506064
19:02:34 58125 8192000000 10898261888 11376721920 1944222720 19.180 98 28 54 0 1958925984 7354400 7348864
19:03:45 22787 8192000000 10913841872 11376484352 1981486304 19.476 100 37 74 0 1999683312 7415392 10781616
19:04:21 46378 8192000000 10908290816 11371470848 1943292656 19.173 98 19 38 3 1955824416 7143056 5388704
19:05:14 69151 8192000000 10932375584 11387334656 1970404352 19.389 99 30 60 0 1986231488 7204608 8622528
19:06:34 27957 8192000000 10910106144 11373375488 1953507648 19.254 98 39 78 1 1973681568 8966400 11207520
19:07:09 44388 8192000000 10913123408 11383369728 1964420704 19.341 99 19 37 3 1978966544 9128992 5416848
19:08:20 69759 8192000000 10913118288 11382648832 1987260832 19.522 100 16 32 1 2002734160 10867392 4605936
19:09:42 20972 8192000000 10925127408 11384311808 1971969984 19.401 99 40 80 0 1991997040 8750816 11276240
19:10:09 30711 8192000000 10924829024 11386540032 1979891648 19.464 100 26 51 0 1995967504 9112752 6963104
19:10:46 82810 8192000000 10914347504 11386081280 1949650608 19.224 98 23 46 0 1969360000 13139536 6569856
19:12:25 91392 8192000000 10923578208 11389693952 1916873456 18.962 96 21 42 3 1946370336 22884768 6612112
19:14:18 110986 8192000000 10903717824 11354468352 1869859744 18.583 95 14 28 0 1888493728 14832848 3801136
19:16:15 123285 8192000000 10894805072 11372789760 1933673232 19.096 98 17 34 0 1953630256 15397136 4559888
19:18:39 117192 8192000000 10861240704 11343249408 1872846240 18.607 95 15 30 0 1888676896 11754768 4075888
19:21:30 61674 8192000000 10865884784 11341152256 1923760272 19.017 99 14 26 0 1936077408 8668160 3648976
19:24:23 76918 8192000000 10851010512 11334262784 1925578256 19.032 99 13 26 0 1937813728 8306496 3928976
19:26:01 68743 8192000000 10841274080 11315326976 1862941376 18.527 96 12 23 0 1872145600 6433824 2770400
19:27:17 28580 8192000000 9513169536 9831895040 662968352 7.486 34 4 7 0 668117120 4199776 948992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-06-2021 19:29:25 to 16-06-2021 19:29:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 105 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 16-06-2021 19:29:58 to 16-06-2021 19:29:59.

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          240913
MON$OLDEST_ACTIVE               241212
MON$OLDEST_SNAPSHOT             241212
MON$NEXT_TRANSACTION            241212
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                       2015872
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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 ---
:63: 
:64: mscs-test-161.budzdorov.ru    Wed Jun 16 19:27:49 2021
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
:67: 
:68: mscs-test-161.budzdorov.ru    Wed Jun 16 19:27:49 2021
:69:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:70: 
:71: 
:72: mscs-test-161.budzdorov.ru    Wed Jun 16 19:27:54 2021
:73:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:74: 
:75: 
:76: mscs-test-161.budzdorov.ru    Wed Jun 16 19:27:55 2021
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
--- end of diff output ---

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

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