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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-28 19:27:15
DTS_END                         2021-01-28 19:27:15.0300
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43250
TRN_ID                          234468
ATT_ID                          638
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: 8930.58 25549 1071669
customer order: creation 164.78 365 19774
customer order: refuse 14.17 419 1700
order to supplier: creation 43.93 1330 5272
order to supplier: removal 3.24 107755 389
invoice (draft): creation 44.21 3668 5305
invoice (draft): removal 51.59 767 6191
invoice accept: apply 40.08 16746 4810
invoice accept: cancel 47.11 850 5653
customer reserve: creation 3673.93 166 440872
customer reserve: removal 4558.09 60 546971
realization accept: apply 79.44 189 9533
realization accept: cancel 85.31 98 10237
payment from customer: creation 56.36 126 6763
payment from customer: removal 5.34 81 641
payment to supplier: creation 47.63 126 5715
payment to supplier: removal 3.41 75 409
service: total inventory turnovers 4.50 1260 540
service: total monetary turnovers 6.58 22 789
service: aggregate perf. data 0.84 21415 101
service: refresh index statistics 0.03 355460 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-01-2021 19:28:59 to 28-01-2021 19:29:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5592
TEST_TIME 2 6767
TEST_TIME 3 6418
TEST_TIME 4 5817
TEST_TIME 5 5167
TEST_TIME 6 5009
TEST_TIME 7 5013
TEST_TIME 8 5241
TEST_TIME 9 5231
TEST_TIME 10 5254
TEST_TIME 11 5723
TEST_TIME 12 6085
TEST_TIME 13 6098
TEST_TIME 14 6686
TEST_TIME 15 6771
TEST_TIME 16 6812
TEST_TIME 17 6975
TEST_TIME 18 7655
TEST_TIME 19 8167
TEST_TIME 20 8050
TEST_TIME 21 8397
TEST_TIME 22 8436
TEST_TIME 23 9013
TEST_TIME 24 9655
TEST_TIME 25 9680
TEST_TIME 26 10264
TEST_TIME 27 10142
TEST_TIME 28 10019
TEST_TIME 29 10258
TEST_TIME 30 10325
TEST_TIME 31 10161
TEST_TIME 32 10053
TEST_TIME 33 9949
TEST_TIME 34 9797
TEST_TIME 35 9625
TEST_TIME 36 9648
TEST_TIME 37 9512
TEST_TIME 38 9404
TEST_TIME 39 9271
TEST_TIME 40 9182
TEST_TIME 41 9146
TEST_TIME 42 9123
TEST_TIME 43 9292
TEST_TIME 44 9188
TEST_TIME 45 9119
TEST_TIME 46 9050
TEST_TIME 47 8925
TEST_TIME 48 9035
TEST_TIME 49 9001
TEST_TIME 50 8933
TEST_TIME 51 9041
TEST_TIME 52 9049
TEST_TIME 53 9017
TEST_TIME 54 9131
TEST_TIME 55 9072
TEST_TIME 56 9173
TEST_TIME 57 9154
TEST_TIME 58 9239
TEST_TIME 59 9179
TEST_TIME 60 9299
TEST_TIME 61 9254
TEST_TIME 62 9184
TEST_TIME 63 9071
TEST_TIME 64 9066
TEST_TIME 65 9071
TEST_TIME 66 9090
TEST_TIME 67 9017
TEST_TIME 68 8983
TEST_TIME 69 8933
TEST_TIME 70 8946
TEST_TIME 71 8889
TEST_TIME 72 8844
TEST_TIME 73 8780
TEST_TIME 74 8824
TEST_TIME 75 8850
TEST_TIME 76 8867
TEST_TIME 77 8852
TEST_TIME 78 8946
TEST_TIME 79 8912
TEST_TIME 80 8990
TEST_TIME 81 8993
TEST_TIME 82 9046
TEST_TIME 83 9015
TEST_TIME 84 8992
TEST_TIME 85 9187
TEST_TIME 86 9247
TEST_TIME 87 9312
TEST_TIME 88 9278
TEST_TIME 89 9189
TEST_TIME 90 9181
TEST_TIME 91 9133
TEST_TIME 92 9144
TEST_TIME 93 9130
TEST_TIME 94 9069
TEST_TIME 95 9039
TEST_TIME 96 9057
TEST_TIME 97 9055
TEST_TIME 98 9097
TEST_TIME 99 9111
TEST_TIME 100 9074
TEST_TIME 101 9087
TEST_TIME 102 9148
TEST_TIME 103 9219
TEST_TIME 104 9180
TEST_TIME 105 9253
TEST_TIME 106 9249
TEST_TIME 107 9259
TEST_TIME 108 9252
TEST_TIME 109 9219
TEST_TIME 110 9261
TEST_TIME 111 9189
TEST_TIME 112 9156
TEST_TIME 113 9106
TEST_TIME 114 9100
TEST_TIME 115 9079
TEST_TIME 116 9052
TEST_TIME 117 9029
TEST_TIME 118 9042
TEST_TIME 119 8996
TEST_TIME 120 8935

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 28-01-2021 19:29:02 to 28-01-2021 19:29:06.

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 1480583 1480583 0 0.00 0 16271 6 0 0
doc_list_biud 1480581 1480581 0 0.00 0 36029 28 0 0
sp_add_invoice_to_stock 4914 4810 104 2.11 40 159661 16746 0 104
sp_cancel_adding_invoice 5653 5653 0 0.00 5 54690 851 0 0
sp_cancel_client_order 1700 1700 0 0.00 4 22221 420 0 0
sp_cancel_customer_reserve 546971 546971 0 0.00 1 19896 61 0 0
sp_cancel_pay_from_customer 641 641 0 0.00 3 4823 82 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 2 5774 76 0 0
sp_cancel_supplier_invoice 6201 6191 10 0.16 2 21373 767 0 10
sp_cancel_supplier_order 389 389 0 0.00 7 997688 107755 0 0
sp_cancel_write_off 10237 10237 0 0.00 1 16381 99 0 0
sp_client_order 19774 19774 0 0.00 3 55921 365 0 0
sp_customer_reserve 440872 440872 0 0.00 0 59287 166 0 0
sp_fill_shopping_cart 30343 30343 0 0.00 1 25666 41 0 0
sp_fill_shopping_cart_clo_res 440865 440865 0 0.00 0 21425 13 0 0
sp_get_clo_for_invoice 4802 4802 0 0.00 0 27605 307 0 0
sp_kill_cost_storno 16940 16940 0 0.00 0 10613 55 0 0
sp_kill_qstorno_ret_qs2qd 1110759 1110759 0 0.00 0 21353 33 0 0
sp_kill_qty_storno 585476 585476 0 0.00 0 36028 71 0 0
sp_lock_selected_doc 19936 19936 0 0.00 0 5762 4 0 0
sp_make_cost_storno 26813 26813 0 0.00 0 16243 56 0 0
sp_multiply_rows_for_pdistr 26813 26813 0 0.00 0 8058 32 0 0
sp_multiply_rows_for_qdistr 19774 19774 0 0.00 0 55908 166 0 0
sp_pay_from_customer 6763 6763 0 0.00 4 18918 127 0 0
sp_pay_to_supplier 5715 5715 0 0.00 5 12861 127 0 0
sp_payment_common 12478 12478 0 0.00 1 12850 35 0 0
sp_qd_handle_on_cancel_clo 1700 1700 0 0.00 0 22215 383 0 0
sp_qd_handle_on_invoice_upd_sts 10455 10455 0 0.00 0 36027 339 0 0
sp_qd_handle_on_reserve_upd_sts 9533 9533 0 0.00 0 15107 61 0 0
sp_reserve_write_off 9533 9533 0 0.00 6 17104 190 0 0
sp_supplier_invoice 5305 5305 0 0.00 5 102017 3668 0 0
sp_supplier_order 5272 5272 0 0.00 7 62261 1330 0 0
srv_aggregate_perf_data 101 101 0 0.00 2355 509409 21415 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1525 157442 33611 0 0
srv_find_qd_qs_mism 1026271 1026271 0 0.00 0 9260 4 0 0
srv_make_invnt_saldo 540 540 0 0.00 33 32536 1261 0 0
srv_make_money_saldo 789 789 0 0.00 1 480 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 130399 549574 355460 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4811 4811 0 0.00 0 15289 223 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 10532 156 0 0
t$perf-norm:sp_cancel_client_order 1700 1700 0 0.00 0 3209 21 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 10257 30 0 0
t$perf-norm:sp_cancel_pay_from_customer 641 641 0 0.00 0 2304 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 335 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 1669 14 0 0
t$perf-norm:sp_cancel_supplier_order 389 389 0 0.00 0 30235 1941 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 467 3 0 0
t$perf-norm:sp_client_order 19774 19774 0 0.00 0 12848 21 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 9683 26 0 0
t$perf-norm:sp_pay_from_customer 6763 6763 0 0.00 0 5698 12 0 0
t$perf-norm:sp_pay_to_supplier 5715 5715 0 0.00 0 13945 15 0 0
t$perf-norm:sp_reserve_write_off 9533 9533 0 0.00 0 8439 13 0 0
t$perf-norm:sp_supplier_invoice 5305 5305 0 0.00 0 8571 27 0 0
t$perf-norm:sp_supplier_order 5272 5272 0 0.00 0 4979 20 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 335 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 456 6 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 1531 22 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 5059 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 9812 9604 208 2.11 0 4022 21 0 208
v_all_customers 35728 35728 0 0.00 0 30 1 0 0
v_all_suppliers 29296 29296 0 0.00 0 54 1 0 0
v_all_wares 39544 39544 0 0.00 0 48 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 6147 18 0 0
v_cancel_client_order 3400 3400 0 0.00 0 6139 8 0 0
v_cancel_customer_prepayment 1282 1282 0 0.00 0 1854 6 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 4834 7 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 233 3 0 0
v_cancel_supplier_invoice 790 770 20 2.53 0 1729 21 0 20
v_cancel_supplier_order 778 778 0 0.00 0 1428 6 0 0
v_cancel_write_off 1984 1984 0 0.00 0 1491 14 0 0
v_max_id_clo_ord 5269 5269 0 0.00 0 2123 2 0 0
v_max_id_clo_res 997 997 0 0.00 0 9452 21 0 0
v_max_id_ord_sup 5302 5302 0 0.00 0 4782 3 0 0
v_max_non_paid_invoice 1638 1638 0 0.00 0 1171 3 0 0
v_max_non_paid_realizn 3686 3686 0 0.00 0 2699 4 0 0
v_min_id_clo_ord 5269 5269 0 0.00 0 4547 7 0 0
v_min_id_clo_res 997 997 0 0.00 0 3895 11 0 0
v_min_id_ord_sup 5302 5302 0 0.00 0 6646 6 0 0
v_min_non_paid_invoice 5715 5715 0 0.00 0 12843 22 0 0
v_min_non_paid_realizn 6763 6763 0 0.00 0 11355 23 0 0
v_our_firm 9970 9970 0 0.00 0 171 1 0 0
v_reserve_write_off 19064 19064 0 0.00 0 6343 7 0 0
x_lock_depdocs_on_canc_invoice 11459 11459 0 0.00 0 16222 122 0 0
x_lock_depdocs_on_canc_sup_ord 389 389 0 0.00 0 21151 402 0 0
x_make_qstorno_1000_1200 5272 5272 0 0.00 2 62166 1241 0 0
x_make_qstorno_1200_2000 5305 5305 0 0.00 3 101990 3528 0 0
x_make_qstorno_2100_3300 440872 440872 0 0.00 0 59285 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-01-2021 19:29:07 to 28-01-2021 19:29:11.

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:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:24 23558 8192000000 10259323824 10572734464 893979104 9.839 72 54 112 0 915285760 2518208 18788448
16:57:55 28388 8192000000 10338226128 10655649792 1384363712 14.456 100 83 167 1 1416414624 4888832 27162080
16:58:33 21163 8192000000 10374377136 10697498624 1422580448 14.796 100 83 166 1 1456306064 6594736 27130880
16:59:03 20171 8192000000 10402915584 10730618880 1456044592 15.091 100 89 178 2 1491945088 7403728 28496768
16:59:34 16392 8192000000 10413547648 10744635392 1469972368 15.213 100 91 181 0 1507523808 8242144 29309296
17:00:03 15366 8192000000 10426169744 10758590464 1479585072 15.298 100 80 160 0 1513517664 8532608 25399984
17:00:26 25253 8192000000 10451521936 10787545088 1503926192 15.510 100 84 168 0 1539774896 8846496 27002208
17:01:04 19784 8192000000 10474453344 10816548864 1531543632 15.750 100 85 170 0 1567278592 9182576 26552384
17:01:35 19841 8192000000 10502725776 10849939456 1552916848 15.935 100 82 164 0 1588110560 9693536 25500176
17:02:03 13943 8192000000 10529174784 10876547072 1579666176 16.165 100 82 164 0 1615370704 10234496 25470032
17:02:26 16741 8192000000 10544454080 10896838656 1599985344 16.339 100 82 164 0 1635541440 11006880 24549216
17:02:51 9579 8192000000 10557132144 10919038976 1621232400 16.520 100 77 155 0 1655616800 11017536 23366864
17:03:11 15360 8192000000 10588772976 10952433664 1643350976 16.708 100 81 162 0 1679238752 11276480 24611296
17:03:40 8656 8192000000 10612463664 10976849920 1671510496 16.946 100 82 164 0 1707289776 11722336 24056944
17:03:56 10783 8192000000 10630051680 10995535872 1689675584 17.099 100 83 166 0 1726158032 12444912 24037536
17:04:17 10499 8192000000 10635862016 11010596864 1702847360 17.209 100 79 158 2 1738401872 12465168 23089344
17:04:36 6374 8192000000 10655377936 11028516864 1716593088 17.324 100 75 149 1 1750930976 12564624 21773264
17:04:49 7926 8192000000 10680892640 11056291840 1740665600 17.524 100 79 158 0 1775346064 12517536 22162928
17:05:04 6570 8192000000 10680929744 11060039680 1749717440 17.599 100 80 159 1 1785430624 11880864 23832320
17:05:17 5669 8192000000 10690639696 11076894720 1763389280 17.712 100 77 152 1 1797278160 11184528 22704352
17:05:29 6794 8192000000 10701028208 11088031744 1774617696 17.805 100 70 140 0 1805813776 10405728 20790352
17:05:43 5785 8192000000 10720507728 11106246656 1789772432 17.930 100 68 137 3 1822604128 13935920 18895776
17:05:56 3586 8192000000 10720380720 11107061760 1792570256 17.953 100 73 146 0 1823005488 9703632 20731600
17:06:07 3974 8192000000 10749486304 11133689856 1808571424 18.084 100 78 156 0 1841137888 11294240 21272224
17:06:17 4219 8192000000 10751415056 11135922176 1810258560 18.098 100 79 157 1 1845061120 12607568 22194992
17:06:28 4083 8192000000 10746807008 11136745472 1816111088 18.146 100 81 159 0 1850445408 12208688 22125632
17:06:39 3134 8192000000 10765847824 11155337216 1826454768 18.230 100 87 173 2 1864134496 13267648 24412080
17:06:49 3051 8192000000 10776310256 11159457792 1827799872 18.241 100 90 181 1 1867831552 14456432 25575248
17:06:59 5318 8192000000 10762968160 11152048128 1828027392 18.243 100 84 168 0 1865959680 14803152 23129136
17:07:11 4518 8192000000 10761472272 11157127168 1830634544 18.265 100 75 150 0 1865786368 13965328 21186496
17:07:22 2433 8192000000 10788505744 11181010944 1848475280 18.410 100 86 172 2 1886109632 13816912 23817440
17:07:31 1954 8192000000 10791657632 11182313472 1849221632 18.416 100 85 168 4 1885421776 12763840 23436304
17:07:40 1977 8192000000 10798416384 11185655808 1855929120 18.470 100 91 183 1 1895656592 14700608 25026864
17:07:48 1760 8192000000 10801366816 11191173120 1857429392 18.482 100 90 178 1 1897106912 14645840 25031680
17:07:56 2428 8192000000 10803316528 11194220544 1863508976 18.532 100 92 183 0 1903979696 15523552 24947168
17:08:06 1951 8192000000 10809399632 11202355200 1864101488 18.537 100 91 183 2 1904422272 14579888 25740896
17:08:15 1727 8192000000 10817228944 11206393856 1871158960 18.594 100 86 171 1 1909711408 13437104 25115344
17:08:22 2223 8192000000 10817954848 11208912896 1876006288 18.633 100 93 186 0 1914207984 11509792 26691904
17:08:31 1818 8192000000 10819464288 11211808768 1877908880 18.648 100 87 174 2 1914957920 11933904 25115136
17:08:39 3124 8192000000 10818457296 11214352384 1879540480 18.661 100 90 180 0 1916631312 11927184 25163648
17:08:49 2276 8192000000 10818865824 11213840384 1878749360 18.655 100 89 177 1 1915948880 12911792 24287728
17:08:58 1411 8192000000 10826805792 11219456000 1883018816 18.689 100 92 185 1 1922058384 12821488 26218080
17:09:06 2069 8192000000 10825393008 11219226624 1885220816 18.707 100 91 186 0 1924522208 13712048 25589344
17:09:18 10241 8192000000 10831329776 11222876160 1884170432 18.699 100 85 170 0 1922059968 14296000 23593536
17:09:34 2358 8192000000 10828937536 11225239552 1887015776 18.722 100 89 180 1 1925907152 13825920 25065456
17:09:43 26070 8192000000 10803046336 11220168704 1879865168 18.664 100 39 77 2 1901988656 11510464 10613024
17:10:16 6922 8192000000 10795203648 11216531456 1878692816 18.655 100 29 58 1 1893388064 6685760 8009488
17:10:31 3766 8192000000 10796608928 11223547904 1883184272 18.691 100 30 60 1 1899861680 8260432 8416976
17:10:41 8075 8192000000 10792055056 11222167552 1886567936 18.718 100 30 60 0 1902221024 7448064 8205024
17:10:57 5317 8192000000 10805674800 11227193344 1888832656 18.736 100 53 106 2 1911000016 6725584 15441776
17:11:10 8211 8192000000 10802450000 11227267072 1889434384 18.741 100 32 65 0 1904957248 7156592 8366272
17:11:25 9934 8192000000 10792719904 11226775552 1886814768 18.720 100 19 38 0 1899163328 6720464 5628096
17:11:44 5889 8192000000 10806435264 11234222080 1893372240 18.773 100 31 62 0 1909457504 6769504 9315760
17:11:57 11167 8192000000 10804872480 11232473088 1894771104 18.784 100 29 58 1 1910017456 6576048 8670304
17:12:18 10863 8192000000 10807456464 11238563840 1893267056 18.772 100 15 29 0 1903126928 6068864 3791008
17:12:35 15856 8192000000 10801875264 11238760448 1894672832 18.783 100 8 16 0 1902689056 5604144 2412080
17:13:01 11428 8192000000 10807026016 11248132096 1904143680 18.860 100 15 30 2 1914590640 6025312 4421648
17:13:21 8275 8192000000 10809740656 11247972352 1908047008 18.891 100 22 44 1 1919874128 5897312 5929808
17:13:36 5798 8192000000 10836392320 11261005824 1912530768 18.927 100 36 72 1 1932533392 10068576 9934048
17:13:49 76918 8192000000 10824075984 11266334720 1917061584 18.963 100 23 46 1 1929206768 5292000 6853184
17:15:14 10562 8192000000 10829317776 11268841472 1915383632 18.950 100 27 54 1 1929700800 6841968 7475200
17:15:33 3993 8192000000 10836754816 11268362240 1913395632 18.934 100 50 100 1 1939711664 11652160 14663872
17:15:45 5490 8192000000 10836934384 11268960256 1913909952 18.938 100 31 63 0 1929860640 6589664 9361024
17:16:00 7069 8192000000 10819830576 11250524160 1898327840 18.813 100 31 64 1 1913998464 6787568 8883056
17:16:16 6197 8192000000 10826101616 11257049088 1903221424 18.852 100 25 50 2 1917141328 6937456 6982448
17:16:29 6692 8192000000 10800728640 11233972224 1866482560 18.556 98 28 55 2 1888980064 14509408 7988096
17:16:45 6870 8192000000 10811151744 11248320512 1896916752 18.801 100 23 46 1 1908790800 5523392 6350656
17:16:59 12223 8192000000 10820633712 11252645888 1868651760 18.573 98 18 36 1 1879237344 5580368 5005216
17:17:20 10692 8192000000 10818875552 11250638848 1895244448 18.788 100 26 52 0 1912665520 9785520 7635552
17:17:39 9374 8192000000 10774804896 11205242880 1834317440 18.295 98 18 34 0 1845012304 5695488 4999376
17:17:55 5686 8192000000 10774057120 11198328832 1836206800 18.310 99 17 34 0 1850376448 9423536 4746112
17:18:06 8347 8192000000 10744044320 11170275328 1804003408 18.047 97 22 44 2 1819948352 9815280 6129664
17:18:28 9164 8192000000 10699695888 11114979328 1750218896 17.603 96 16 32 0 1760685232 5657616 4808720
17:18:43 48830 8192000000 10729213328 11149447168 1794146272 17.966 98 23 47 1 1810563904 9640800 6776832
17:19:39 17945 8192000000 10682838048 11083317248 1628769072 16.584 89 36 72 2 1644728896 4847760 11112064
17:20:03 12266 8192000000 10690225168 11100045312 1687721984 17.082 94 22 44 2 1708016240 14543808 5750448
17:20:23 2623 8192000000 10698052016 11109314560 1765731888 17.732 99 52 102 4 1787805984 6997984 15076112
17:20:32 5791 8192000000 10705823168 11112054784 1754152240 17.636 98 39 75 2 1772347104 6392208 11802656
17:20:44 6914 8192000000 10698120496 11105685504 1725066560 17.394 96 36 73 1 1742042352 6244032 10731760
17:20:59 5465 8192000000 10715693568 11128729600 1799106288 18.007 100 22 44 1 1811355408 5644752 6604368
17:21:14 7739 8192000000 10728247968 11145048064 1797270048 17.992 99 30 60 3 1813402752 6494096 9638608
17:21:29 4895 8192000000 10715332080 11126312960 1771148656 17.776 98 25 50 0 1783645264 5373760 7122848
17:21:40 6696 8192000000 10732566304 11152748544 1813617536 18.125 100 19 38 1 1825020256 6032256 5370464
17:21:59 6968 8192000000 10739294352 11161104384 1813292032 18.123 99 26 52 0 1826924080 6175872 7456176
17:22:12 10326 8192000000 10742506176 11164397568 1796514688 17.985 98 22 44 1 1812746416 9794272 6437456
17:22:28 10747 8192000000 10728878608 11144179712 1782967360 17.874 98 23 46 2 1794945776 5572752 6405664
17:22:45 10574 8192000000 10744099008 11164049408 1820326768 18.180 100 25 50 1 1833462672 5091344 8044560
17:23:05 8155 8192000000 10727941184 11151986688 1791715600 17.946 98 31 62 1 1807307376 6024432 9567344
17:23:22 13520 8192000000 10760080000 11175829504 1829489520 18.255 100 19 38 0 1840710240 5473456 5747264
17:23:43 24309 8192000000 10764123104 11182247936 1825633984 18.224 99 30 60 0 1840541024 5068784 9838256
17:25:01 26838 8192000000 10759242272 11190079488 1846857136 18.397 100 26 49 1 1859868656 5643808 7367712
17:25:38 6716 8192000000 10779202528 11199840256 1853766672 18.453 100 26 52 1 1866828800 6262224 6799904
17:25:52 6229 8192000000 10780766432 11204780032 1858535728 18.491 100 37 74 2 1875187472 6704640 9947104
17:26:06 5388 8192000000 10774238448 11201327104 1858601424 18.492 100 35 69 1 1875227680 6458432 10167824
17:26:20 10344 8192000000 10770910384 11201056768 1861268016 18.514 100 28 58 2 1875637952 6192880 8177056
17:26:39 8839 8192000000 10770134256 11203641344 1861890512 18.519 100 25 50 1 1875357648 6197680 7269456
17:26:55 8328 8192000000 10785513232 11210625024 1862534224 18.524 100 21 42 1 1875172400 6148336 6489840
17:27:11 15950 8192000000 10814015808 11232464896 1885768064 18.712 100 35 70 3 1901113328 4578144 10767120
17:27:35 9828 8192000000 10833389280 11246366720 1901801152 18.841 100 49 98 2 1922372320 6762496 13808672
17:27:53 36727 8192000000 10831796544 11252600832 1889017264 18.738 99 48 96 2 1910240736 7919008 13304464
17:28:42 5738 8192000000 10845431632 11263066112 1908828912 18.897 100 49 97 0 1932916976 10493072 13594992
17:29:07 4281 8192000000 10860326224 11275194368 1919834000 18.986 100 61 121 1 1948255616 11780448 16641168
17:29:18 10530 8192000000 10868891536 11286269952 1925228928 19.029 100 60 121 2 1955137120 13276368 16631824
17:29:47 2860 8192000000 10876877568 11293605888 1935778000 19.113 100 67 131 1 1967654512 12861040 19015472
17:30:01 103554 8192000000 10860840032 11308838912 1943529392 19.175 100 33 63 1 1964510176 11508384 9472400
17:31:59 30938 8192000000 10885269664 11322081280 1951001488 19.234 100 29 58 1 1975495552 16719408 7774656
17:32:43 14547 8192000000 10889794224 11323867136 1957324704 19.285 100 40 78 2 1982110432 13470848 11314880
17:33:06 11603 8192000000 10899780016 11330490368 1962108384 19.323 100 47 94 1 1989620160 13785856 13725920
17:33:28 15835 8192000000 10899947824 11338244096 1968750112 19.376 100 40 80 2 1995803728 15715776 11337840
17:33:57 13826 8192000000 10891703104 11321602048 1952812320 19.249 99 43 85 0 1979775712 14778416 12184976
17:34:17 6508 8192000000 10901969296 11330760704 1951252640 19.236 99 55 108 1 1982406560 14870528 16283392
17:34:35 8762 8192000000 10913016288 11343691776 1969617168 19.382 100 47 94 5 2000875152 17113968 14144016
17:34:53 23884 8192000000 10923510672 11352256512 1972695888 19.407 100 41 82 0 2003946896 18371024 12879984
17:35:25 9171 8192000000 10924737232 11353231360 1974655312 19.422 100 50 100 0 2013128320 23252368 15220640
17:35:43 11316 8192000000 10917328624 11350032384 1976119152 19.434 100 43 83 2 2009347312 20225680 13002480
17:36:02 9546 8192000000 10923140592 11361357824 1983665216 19.494 100 46 92 1 2018580176 20977776 13937184
17:36:26 5118 8192000000 10945694432 11365371904 1991927456 19.559 100 55 107 1 2028097616 20574064 15596096
17:36:38 2559 8192000000 10953670000 11366973440 1976828720 19.440 99 74 150 1 2021010672 21860544 22321408
17:36:48 7670 8192000000 10953734352 11376943104 1993607424 19.572 100 64 128 1 2041028912 28485600 18935888
17:37:10 8871 8192000000 10948165408 11377225728 1992017552 19.560 100 53 107 4 2033692400 25469328 16205520
17:37:30 4401 8192000000 10957267472 11384930304 1997355680 19.602 100 57 113 0 2039846048 25226064 17264304
17:37:45 4668 8192000000 10962527872 11378237440 1996752096 19.597 100 65 128 3 2041931152 25785744 19393312
17:37:59 2922 8192000000 10969945872 11394322432 2006511792 19.674 100 65 131 1 2053426096 27168464 19745840
17:38:10 1554 8192000000 10971955840 11393708032 2005604288 19.667 100 77 152 3 2055036384 26867744 22564352
17:38:19 12694 8192000000 10965446816 11400511488 2007350032 19.681 100 69 138 0 2059116720 30841648 20925040
17:38:54 7996 8192000000 10959681888 11386535936 1986250624 19.514 99 69 138 4 2038946576 31476048 21219904
17:39:13 4350 8192000000 10951407632 11379159040 1984749680 19.502 100 65 130 0 2037270672 32826512 19694480
17:39:27 3285 8192000000 10961202288 11378573312 1986170720 19.514 100 81 160 3 2041170704 31808752 23191232
17:39:37 5673 8192000000 10949134496 11369984000 1977580416 19.446 100 68 135 0 2036080448 37996816 20503216
17:39:54 7223 8192000000 10955076032 11380453376 1988004880 19.528 100 63 127 1 2041701856 33934176 19762800
17:40:08 3679 8192000000 10947885440 11367440384 1972671472 19.407 99 78 154 0 2031643472 35499120 23472880
17:40:19 5758 8192000000 10957885056 11376295936 1986542784 19.516 100 79 158 0 2051575984 41405776 23627424
17:40:32 10057 8192000000 10952709040 11379150848 1972317904 19.404 99 62 124 3 2029505056 37702528 19484624
17:40:53 2081 8192000000 10955913392 11376914432 1981900496 19.480 100 73 145 0 2041535360 36675616 22959248
17:41:04 4244 8192000000 10933973072 11348717568 1941400880 19.158 98 74 147 2 2004106960 39206496 23499584
17:41:16 5251 8192000000 10951586464 11369758720 1957157840 19.283 99 76 152 1 2020236240 39425008 23653392
17:41:30 8449 8192000000 10957641840 11378606080 1979160224 19.458 100 73 146 0 2043216128 40785056 23270848
17:41:49 8437 8192000000 10959983984 11383070720 1984427328 19.500 100 70 136 1 2039281008 34063488 20790192
17:42:13 2548 8192000000 10961301120 11382833152 1982363440 19.483 100 70 138 1 2038439136 34364208 21711488
17:42:29 3130 8192000000 10959966832 11377434624 1984537904 19.501 100 85 166 2 2044483296 33527296 26418096
17:42:41 5703 8192000000 10959432592 11379556352 1979815408 19.463 100 75 150 0 2039184656 35557360 23811888
17:42:55 2866 8192000000 10958391680 11379474432 1984287968 19.499 100 68 136 1 2039670240 34438496 20943776
17:43:07 4534 8192000000 10970925680 11393212416 1994875440 19.582 100 74 148 1 2054334688 36013952 23445296
17:43:20 1959 8192000000 10948698400 11370074112 1972490896 19.405 99 71 142 0 2029670624 35017520 22162208
17:43:29 1982 8192000000 10949451344 11356499968 1953661184 19.256 98 88 176 1 2017172560 36376624 27134752
17:43:38 3899 8192000000 10950405088 11376709632 1976003152 19.433 100 77 154 0 2039256432 38268480 24984800
17:43:55 4477 8192000000 10958050320 11372613632 1958791216 19.296 99 77 155 1 2022346688 39807296 23748176
17:44:06 6062 8192000000 10966919376 11380314112 1981881184 19.480 100 91 180 1 2052686400 42071616 28733600
17:44:19 3275 8192000000 10957012032 11369885696 1968728272 19.375 100 80 160 0 2035962848 41465216 25769360
17:44:29 1523 8192000000 10969741632 11378208768 1972574960 19.406 100 91 180 0 2045066096 43606912 28884224
17:44:40 2102 8192000000 10966392976 11379531776 1978070976 19.449 100 84 166 2 2048263856 43613440 26579440
17:44:54 6586 8192000000 10951653424 11366965248 1957629584 19.287 99 70 140 2 2024561392 44179216 22752592
17:45:08 2593 8192000000 10946361936 11364864000 1955949104 19.274 99 73 146 1 2025083696 45357040 23777552
17:45:18 5899 8192000000 10931089968 11350282240 1942068656 19.163 99 76 150 1 2008194544 41622272 24503616
17:45:30 3404 8192000000 10940000576 11356385280 1957088880 19.283 100 82 165 1 2022126480 39261568 25776032
17:45:42 4657 8192000000 10956659632 11377668096 1974084112 19.418 100 84 167 0 2040461200 39367824 27009264
17:45:54 3351 8192000000 10963537792 11379949568 1972342960 19.404 100 78 155 0 2035441264 38894224 24204080
17:46:07 4333 8192000000 10964562128 11383988224 1975466928 19.429 100 78 154 0 2039441056 40490544 23483584
17:46:19 4252 8192000000 10949676752 11376545792 1971117488 19.394 100 73 147 1 2035371856 40436416 23817952
17:46:30 3745 8192000000 10960139616 11379740672 1977420576 19.444 100 76 148 2 2038371504 38347696 22603232
17:46:41 3260 8192000000 10939593376 11374645248 1968776320 19.376 100 64 128 0 2028340720 39597600 19966800
17:46:54 10028 8192000000 10917552480 11353415680 1942098080 19.163 99 47 94 0 1991577104 34553584 14925440
17:47:12 7868 8192000000 10916835808 11357859840 1955962176 19.274 100 41 82 2 2005139280 35623920 13553184
17:47:37 12046 8192000000 10915147424 11346067456 1928988704 19.059 99 46 92 2 1981059888 37119520 14951664
17:47:59 5068 8192000000 10942641648 11364958208 1954959072 19.266 100 61 118 3 2014419440 40121296 19339072
17:48:12 4061 8192000000 10950888112 11373080576 1963543408 19.334 100 69 137 1 2027948048 42115520 22289120
17:48:24 11290 8192000000 10903789552 11330048000 1891410560 18.757 97 64 126 1 1953591744 41752592 20428592
17:48:51 13526 8192000000 10883526624 11327938560 1894223408 18.780 98 36 72 3 1947194512 39730976 13240128
17:49:11 13025 8192000000 10894015200 11329724416 1923164896 19.012 100 41 82 1 1978538720 40444512 14929312
17:49:31 2904 8192000000 10911031680 11334451200 1926503344 19.039 100 60 118 3 1986462784 39764912 20194528
17:49:40 1569 8192000000 10932124064 11345383424 1937776368 19.129 100 75 152 2 2003634560 40979472 24878720
17:49:50 6984 8192000000 10937747376 11357167616 1942465616 19.166 100 71 142 2 2009294304 44014784 22813904
17:50:06 4074 8192000000 10935357776 11361128448 1949238880 19.220 100 68 138 2 2014344304 43002768 22102656
17:50:17 10755 8192000000 10907689344 11349135360 1909790976 18.905 98 44 88 0 1970394688 45622528 14981184
17:50:42 17432 8192000000 10899748368 11347091456 1917116784 18.964 99 37 72 1 1978049248 48679808 12252656
17:51:14 33913 8192000000 10846084048 11307741184 1886462480 18.717 98 20 40 1 1932673344 39129632 7081232
17:51:54 28377 8192000000 10864579392 11315273728 1879389360 18.660 98 13 26 0 1911998016 28210992 4397664
17:52:29 32444 8192000000 10881087072 11332923392 1901989072 18.842 99 19 38 0 1946151136 37584720 6577344
17:53:08 21308 8192000000 10878198720 11333636096 1927780800 19.049 100 19 38 1 1963670096 29926304 5962992
17:53:49 56968 8192000000 10854172048 11302846464 1870342176 18.587 97 18 36 0 1899588624 23395536 5850912
17:55:17 20811 8192000000 10854841456 11305037824 1886032784 18.714 98 33 67 2 1918311872 21806496 10472592
17:55:46 37702 8192000000 10848314016 11312775168 1897525264 18.806 99 16 32 0 1922130256 19559456 5045536
17:56:51 95348 8192000000 10857791632 11319554048 1887470848 18.725 98 13 26 0 1901804448 10819664 3513936
17:58:35 47324 8192000000 10871518640 11323047936 1932244320 19.085 100 23 45 0 1946144192 8155856 5744016
17:59:35 107406 8192000000 10856323408 11309555712 1847154624 18.399 95 24 49 1 1860182256 7399936 5627696
18:01:28 127525 8192000000 10845030112 11312451584 1899456080 18.822 98 22 44 0 1917939936 11769424 6714432
18:03:50 61335 8192000000 10884784576 11333410816 1948520752 19.215 100 26 51 0 1969797184 14251776 7024656
18:04:58 34201 8192000000 10897591536 11347312640 1960909264 19.313 100 29 57 0 1980826368 11355584 8561520
18:05:42 68477 8192000000 10877240128 11337420800 1935622416 19.112 99 9 18 0 1950324640 12144480 2557744
18:06:58 8715 8192000000 10886667616 11340898304 1955708720 19.272 100 21 42 1 1974583360 12953936 5920704
18:07:15 9619 8192000000 10900034544 11339046912 1952792240 19.249 100 40 79 3 1976935680 13167040 10976400
18:07:31 55749 8192000000 10903855888 11348299776 1958839168 19.297 100 33 65 0 1984854400 16287840 9727392
18:08:34 38496 8192000000 10891148144 11357335552 1967447744 19.365 100 18 36 1 1986215856 13927120 4840992
18:09:33 55195 8192000000 10882480192 11363143680 1950355040 19.229 99 18 37 0 1972768272 16959520 5453712
18:11:23 35743 8192000000 10868671712 11336450048 1954215936 19.260 99 19 38 1 1969381552 10111040 5054576
18:12:59 56016 8192000000 10889616592 11353042944 1949771904 19.225 99 15 29 2 1965395680 11616224 4007552
18:14:02 49492 8192000000 10893484448 11365191680 1972454448 19.405 100 20 40 0 1993467872 15136496 5876928
18:15:08 74156 8192000000 10900961792 11368366080 1979260944 19.459 100 13 26 1 1993817184 10851056 3705184
18:16:28 64732 8192000000 10915607440 11375812608 1967870048 19.369 99 20 38 0 1982589376 9473616 5245712
18:18:07 63403 8192000000 10909895488 11361075200 1924028272 19.019 97 12 24 0 1935358080 8099056 3230752
18:19:25 19009 8192000000 10914132288 11375812608 1983754256 19.494 100 41 82 0 2004769600 9435472 11579872
18:19:54 84397 8192000000 10887550624 11352420352 1928484128 19.055 97 14 28 0 1943723088 11348400 3890560
18:21:25 61138 8192000000 10906099376 11381841920 1935452464 19.110 98 11 22 1 1955376944 16985824 2938656
18:22:32 157442 8192000000 10911432928 11404750848 1943869936 19.178 98 8 16 0 1974081408 28101680 2109792
18:25:46 35381 8192000000 10882035152 11343769600 1909015216 18.899 97 17 34 2 1924884864 11050944 4818704
18:27:40 56162 8192000000 10902986096 11348008960 1900015472 18.826 96 13 25 1 1911469552 7606608 3847472
18:28:45 23690 8192000000 10911926448 11361460224 1948280272 19.213 99 36 72 1 1969755312 10947008 10528032
18:30:42 100021 8192000000 10856646384 11324338176 1846325552 18.392 94 23 46 1 1867441888 14975392 6140944
18:32:33 16361 8192000000 10866866944 11321757696 1935004608 19.107 100 33 66 0 1959671584 16019568 8647408
18:32:56 35276 8192000000 10836562704 11301744640 1876709248 18.639 97 26 51 1 1899572128 15495504 7367376
18:33:39 93474 8192000000 10828175072 11283095552 1852101584 18.439 96 13 26 0 1865586176 9343184 4141408
18:35:23 62462 8192000000 10863112368 11325374464 1916397456 18.958 99 13 26 0 1931788048 11572400 3818192
18:36:32 60862 8192000000 10852621776 11330633728 1906020752 18.875 98 9 18 0 1921450592 12304944 3124896
18:37:58 26573 8192000000 10841569552 11288375296 1874742816 18.623 97 38 76 0 1894132608 9236368 10153424
18:38:32 54021 8192000000 10851417760 11312349184 1912149728 18.924 99 23 45 1 1929504736 11272576 6082432
18:39:56 65019 8192000000 10848060352 11312103424 1913275504 18.933 99 20 40 1 1931017216 12060032 5681680
18:42:27 59493 8192000000 10868308144 11341799424 1940561360 19.151 100 13 26 1 1957909872 13147072 4201440
18:43:33 50581 8192000000 10891262000 11349630976 1940000544 19.147 99 22 45 0 1958128352 10591984 7535824
18:44:30 75280 8192000000 10869127424 11341570048 1904688000 18.864 97 20 40 1 1924632544 14172096 5772448
18:45:51 63602 8192000000 10857559104 11305435136 1813697952 18.126 93 24 48 2 1832857280 12276224 6883104
18:47:08 57659 8192000000 10871906720 11339882496 1926703344 19.041 99 26 52 0 1950224992 16301184 7220464
18:48:20 35278 8192000000 10904014656 11348537344 1938213104 19.132 99 29 57 1 1956825312 10642640 7969568
18:49:05 64000 8192000000 10907267216 11366408192 1941879024 19.162 99 29 58 3 1966822784 16506448 8437312
18:50:17 47337 8192000000 10923027744 11372957696 1969538976 19.382 100 24 48 1 1993447872 17063616 6845280
18:51:15 68845 8192000000 10890121584 11369005056 1935045424 19.107 99 31 62 0 1969164800 25150064 8969312
18:52:41 91374 8192000000 10883357264 11369734144 1912418176 18.926 98 7 14 0 1940268704 25862000 1988528
18:54:18 97350 8192000000 10876396000 11334758400 1892605984 18.767 97 14 28 1 1911456016 15069280 3780752
18:56:25 100931 8192000000 10893184736 11352809472 1923260976 19.013 98 33 66 1 1941017568 8825728 8930864
18:59:36 42134 8192000000 10874169264 11345731584 1955391056 19.269 100 25 50 0 1972194304 9988384 6814864
19:00:27 75147 8192000000 10876656304 11348611072 1957283120 19.284 100 12 24 0 1969323088 8882496 3157472
19:01:49 57871 8192000000 10891740928 11364233216 1967967584 19.369 100 14 29 0 1979468816 8026672 3474560
19:02:56 72383 8192000000 10897008560 11375661056 1959618976 19.303 99 11 22 1 1977564528 14961296 2984256
19:04:15 72307 8192000000 10881027008 11361177600 1917746864 18.969 97 14 28 0 1938266784 16405456 4114464
19:05:37 84610 8192000000 10901605808 11372908544 1907400640 18.886 96 22 43 1 1922040864 8125648 6514576
19:07:14 72978 8192000000 10937552464 11403272192 1974577168 19.422 99 23 46 1 2004502080 22872912 7052000
19:08:33 24987 8192000000 10930479712 11391938560 1978463504 19.453 99 31 62 1 2006925168 18357056 10104608
19:09:06 91017 8192000000 10910797136 11405946880 1965613936 19.351 99 13 26 0 1987862576 18483840 3764800
19:11:02 54788 8192000000 10932236064 11384750080 1964277584 19.340 98 42 83 1 1986800976 11600048 10923344
19:12:05 100084 8192000000 10887061904 11359379456 1868629088 18.573 94 19 38 0 1888323248 14013376 5680784
19:13:51 150162 8192000000 10922513584 11380203520 1888350016 18.732 95 21 42 0 1902969184 8730992 5888176
19:16:32 61852 8192000000 10907913216 11385233408 1920840832 18.994 97 23 45 0 1941252176 14319968 6091376
19:18:35 78929 8192000000 10880007632 11342733312 1871352992 18.595 95 25 50 0 1886467648 7877936 7236720
19:20:01 25208 8192000000 10865232672 11326443520 1935358128 19.110 99 9 18 0 1944117008 6349392 2409488
19:20:35 38738 8192000000 10886268288 11350794240 1931022800 19.075 98 21 42 1 1944596576 6915088 6658688
19:21:19 28669 8192000000 10881759456 11349295104 1944925504 19.186 99 19 38 2 1959134944 7913216 6296224
19:21:54 73284 8192000000 10867597328 11343224832 1907689152 18.888 97 18 34 0 1920570912 8140448 4741312
19:24:12 64388 8192000000 10884027360 11358572544 1945941152 19.194 99 12 24 0 1958286944 8338912 4006880
19:25:23 59080 8192000000 10859292048 11336925184 1884934112 18.705 96 4 8 0 1892997904 6957984 1105808
19:26:28 53483 8192000000 9610545632 9937620992 754307952 8.431 39 6 12 0 765987504 10340192 1339360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 28-01-2021 19:29:13 to 28-01-2021 19:29:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 104 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-01-2021 19:29:44 to 28-01-2021 19:29:46.

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          234749
MON$OLDEST_ACTIVE               234750
MON$OLDEST_SNAPSHOT             234750
MON$NEXT_TRANSACTION            234750
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                       2018688
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:131: 
:132: mscs-test-161.budzdorov.ru    Thu Jan 28 19:27:24 2021
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
:135: 
:136: mscs-test-161.budzdorov.ru    Thu Jan 28 19:27:31 2021
:137:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:138: 
:139: 
:140: mscs-test-161.budzdorov.ru    Thu Jan 28 19:27:33 2021
:141:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:142: 
--- end of diff output ---

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

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