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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17603720 kB
MemAvailable 31434876 kB
Buffers 0 kB
Cached 14068068 kB
SwapCached 2812 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.7
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 2020-11-08 19:26:59
DTS_END                         2020-11-08 19:26:59.1030
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41742
TRN_ID                          238997
ATT_ID                          712
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: 8959.63 16836 1075156
customer order: creation 175.72 389 21086
customer order: refuse 15.35 362 1842
order to supplier: creation 46.32 1447 5558
order to supplier: removal 3.45 93113 414
invoice (draft): creation 45.55 3430 5466
invoice (draft): removal 48.73 815 5847
invoice accept: apply 42.53 18011 5104
invoice accept: cancel 44.20 827 5304
customer reserve: creation 3883.73 180 466047
customer reserve: removal 4360.07 58 523208
realization accept: apply 84.59 203 10151
realization accept: cancel 77.56 114 9307
payment from customer: creation 60.02 134 7202
payment from customer: removal 5.78 74 694
payment to supplier: creation 50.21 169 6025
payment to supplier: removal 3.28 69 394
service: total inventory turnovers 4.84 979 581
service: total monetary turnovers 6.71 24 805
service: aggregate perf. data 0.98 14977 117
service: refresh index statistics 0.03 201348 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-11-2020 19:27:51 to 08-11-2020 19:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1468
TEST_TIME 2 2458
TEST_TIME 3 3151
TEST_TIME 4 3753
TEST_TIME 5 3711
TEST_TIME 6 3931
TEST_TIME 7 4218
TEST_TIME 8 4559
TEST_TIME 9 4590
TEST_TIME 10 5097
TEST_TIME 11 5365
TEST_TIME 12 5546
TEST_TIME 13 5606
TEST_TIME 14 5737
TEST_TIME 15 5904
TEST_TIME 16 6067
TEST_TIME 17 6240
TEST_TIME 18 6378
TEST_TIME 19 7095
TEST_TIME 20 7401
TEST_TIME 21 7510
TEST_TIME 22 8140
TEST_TIME 23 8422
TEST_TIME 24 8584
TEST_TIME 25 9411
TEST_TIME 26 10601
TEST_TIME 27 10451
TEST_TIME 28 10295
TEST_TIME 29 10193
TEST_TIME 30 10079
TEST_TIME 31 9878
TEST_TIME 32 9711
TEST_TIME 33 9836
TEST_TIME 34 9834
TEST_TIME 35 9807
TEST_TIME 36 9581
TEST_TIME 37 9580
TEST_TIME 38 9384
TEST_TIME 39 9313
TEST_TIME 40 9246
TEST_TIME 41 9231
TEST_TIME 42 9202
TEST_TIME 43 9235
TEST_TIME 44 9194
TEST_TIME 45 9181
TEST_TIME 46 9036
TEST_TIME 47 8966
TEST_TIME 48 9057
TEST_TIME 49 8923
TEST_TIME 50 8929
TEST_TIME 51 8884
TEST_TIME 52 8951
TEST_TIME 53 8937
TEST_TIME 54 8901
TEST_TIME 55 9042
TEST_TIME 56 9033
TEST_TIME 57 9272
TEST_TIME 58 9290
TEST_TIME 59 9274
TEST_TIME 60 9263
TEST_TIME 61 9355
TEST_TIME 62 9343
TEST_TIME 63 9244
TEST_TIME 64 9189
TEST_TIME 65 9113
TEST_TIME 66 9097
TEST_TIME 67 9048
TEST_TIME 68 8983
TEST_TIME 69 8982
TEST_TIME 70 8948
TEST_TIME 71 8922
TEST_TIME 72 8910
TEST_TIME 73 9038
TEST_TIME 74 9044
TEST_TIME 75 9092
TEST_TIME 76 9093
TEST_TIME 77 9141
TEST_TIME 78 9126
TEST_TIME 79 9199
TEST_TIME 80 9215
TEST_TIME 81 9227
TEST_TIME 82 9260
TEST_TIME 83 9250
TEST_TIME 84 9158
TEST_TIME 85 9126
TEST_TIME 86 9122
TEST_TIME 87 9154
TEST_TIME 88 9114
TEST_TIME 89 9071
TEST_TIME 90 9015
TEST_TIME 91 8975
TEST_TIME 92 8969
TEST_TIME 93 8994
TEST_TIME 94 8963
TEST_TIME 95 8990
TEST_TIME 96 9075
TEST_TIME 97 9086
TEST_TIME 98 9079
TEST_TIME 99 9041
TEST_TIME 100 9102
TEST_TIME 101 9158
TEST_TIME 102 9144
TEST_TIME 103 9187
TEST_TIME 104 9158
TEST_TIME 105 9159
TEST_TIME 106 9141
TEST_TIME 107 9076
TEST_TIME 108 9108
TEST_TIME 109 9054
TEST_TIME 110 9044
TEST_TIME 111 9038
TEST_TIME 112 9020
TEST_TIME 113 8986
TEST_TIME 114 8965
TEST_TIME 115 8961
TEST_TIME 116 8932
TEST_TIME 117 8932
TEST_TIME 118 8952
TEST_TIME 119 8987
TEST_TIME 120 8964

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-11-2020 19:27:55 to 08-11-2020 19:27:58.

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 1507359 1507359 0 0.00 0 16081 7 0 0
doc_list_biud 1507356 1507356 0 0.00 0 49122 26 0 0
sp_add_invoice_to_stock 5192 5104 88 1.69 33 194192 18012 0 88
sp_cancel_adding_invoice 5304 5304 0 0.00 5 71558 827 0 0
sp_cancel_client_order 1842 1842 0 0.00 4 26989 363 0 0
sp_cancel_customer_reserve 523208 523208 0 0.00 1 49125 58 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 3 7248 75 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 3300 70 0 0
sp_cancel_supplier_invoice 5854 5847 7 0.11 1 41478 816 0 7
sp_cancel_supplier_order 414 414 0 0.00 4 1102254 93114 0 0
sp_cancel_write_off 9307 9307 0 0.00 1 8652 115 0 0
sp_client_order 21086 21086 0 0.00 3 34112 389 0 0
sp_customer_reserve 466047 466047 0 0.00 0 57239 181 0 0
sp_fill_shopping_cart 32096 32096 0 0.00 1 13529 42 0 0
sp_fill_shopping_cart_clo_res 466040 466040 0 0.00 0 21493 14 0 0
sp_get_clo_for_invoice 5097 5097 0 0.00 0 26408 283 0 0
sp_kill_cost_storno 15699 15699 0 0.00 0 10058 58 0 0
sp_kill_qstorno_ret_qs2qd 1061984 1061984 0 0.00 0 49119 32 0 0
sp_kill_qty_storno 561166 561166 0 0.00 0 49122 68 0 0
sp_lock_selected_doc 21098 21098 0 0.00 0 7588 6 0 0
sp_make_cost_storno 28474 28474 0 0.00 0 16078 59 0 0
sp_multiply_rows_for_pdistr 28472 28472 0 0.00 0 6222 33 0 0
sp_multiply_rows_for_qdistr 21086 21086 0 0.00 0 9699 173 0 0
sp_pay_from_customer 7202 7202 0 0.00 4 13510 134 0 0
sp_pay_to_supplier 6025 6025 0 0.00 5 22147 170 0 0
sp_payment_common 13227 13227 0 0.00 1 13494 38 0 0
sp_qd_handle_on_cancel_clo 1842 1842 0 0.00 0 26982 324 0 0
sp_qd_handle_on_invoice_upd_sts 10399 10399 0 0.00 0 21029 306 0 0
sp_qd_handle_on_reserve_upd_sts 10149 10149 0 0.00 0 30715 59 0 0
sp_reserve_write_off 10151 10151 0 0.00 6 30728 203 0 0
sp_supplier_invoice 5466 5466 0 0.00 6 75352 3431 0 0
sp_supplier_order 5558 5558 0 0.00 5 32661 1448 0 0
srv_aggregate_perf_data 117 117 0 0.00 2601 78786 14977 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1076 156284 33146 0 0
srv_find_qd_qs_mism 1027110 1027110 0 0.00 0 14133 6 0 0
srv_make_invnt_saldo 581 581 0 0.00 38 29314 980 0 0
srv_make_money_saldo 805 805 0 0.00 1 1025 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 117656 263701 201348 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5105 5105 0 0.00 0 16499 199 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 8358 97 0 0
t$perf-norm:sp_cancel_client_order 1842 1842 0 0.00 0 13352 27 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 1754 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 6339 28 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 1206 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 1116 15 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 23757 1355 0 0
t$perf-norm:sp_cancel_write_off 1041 1041 0 0.00 0 1736 6 0 0
t$perf-norm:sp_client_order 21086 21086 0 0.00 0 14877 20 0 0
t$perf-norm:sp_customer_reserve 1032 1032 0 0.00 0 1969 6 0 0
t$perf-norm:sp_pay_from_customer 7202 7202 0 0.00 0 7254 13 0 0
t$perf-norm:sp_pay_to_supplier 6025 6025 0 0.00 0 13475 14 0 0
t$perf-norm:sp_reserve_write_off 10151 10151 0 0.00 0 13505 17 0 0
t$perf-norm:sp_supplier_invoice 5466 5466 0 0.00 0 12210 19 0 0
t$perf-norm:sp_supplier_order 5558 5558 0 0.00 0 7172 16 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 1070 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 531 4 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 3175 24 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 2440 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10364 10188 176 1.69 0 11458 24 0 176
v_all_customers 37960 37960 0 0.00 0 78 1 0 0
v_all_suppliers 30788 30788 0 0.00 0 17 1 0 0
v_all_wares 42170 42170 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 6107 30 0 0
v_cancel_client_order 3684 3684 0 0.00 0 10818 12 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 265 3 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 839 3 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 1157 5 0 0
v_cancel_supplier_invoice 784 770 14 1.78 0 2684 19 0 14
v_cancel_supplier_order 828 828 0 0.00 0 2032 8 0 0
v_cancel_write_off 2082 2082 0 0.00 0 3753 16 0 0
v_max_id_clo_ord 5556 5556 0 0.00 0 7328 4 0 0
v_max_id_clo_res 1032 1032 0 0.00 0 3840 16 0 0
v_max_id_ord_sup 5453 5453 0 0.00 0 5850 5 0 0
v_max_non_paid_invoice 1640 1640 0 0.00 0 4472 7 0 0
v_max_non_paid_realizn 4006 4006 0 0.00 0 5225 7 0 0
v_min_id_clo_ord 5556 5556 0 0.00 0 8607 8 0 0
v_min_id_clo_res 1032 1032 0 0.00 0 792 4 0 0
v_min_id_ord_sup 5453 5453 0 0.00 0 8234 10 0 0
v_min_non_paid_invoice 6025 6025 0 0.00 0 8632 23 0 0
v_min_non_paid_realizn 7202 7202 0 0.00 0 10264 25 0 0
v_our_firm 10602 10602 0 0.00 0 15 1 0 0
v_reserve_write_off 20298 20298 0 0.00 0 10692 12 0 0
x_lock_depdocs_on_canc_invoice 10766 10766 0 0.00 0 21207 118 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 10373 301 0 0
x_make_qstorno_1000_1200 5558 5558 0 0.00 2 32654 1360 0 0
x_make_qstorno_1200_2000 5466 5466 0 0.00 3 69700 3279 0 0
x_make_qstorno_2100_3300 466047 466047 0 0.00 0 57223 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-11-2020 19:27:59 to 08-11-2020 19:28:03.

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:02 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:09 16782 8192000000 10232601600 10539462656 940166976 10.295 76 54 112 1 961262448 2461184 18634288
16:57:35 20648 8192000000 10311264224 10626818048 1356378672 14.205 100 86 172 1 1389832880 4820672 28633536
16:58:10 21245 8192000000 10370599952 10696564736 1426699856 14.832 100 82 164 0 1459624816 6348256 26576704
16:58:37 20933 8192000000 10393502720 10722463744 1453523456 15.069 100 88 175 1 1489068448 7280512 28264480
16:59:07 25943 8192000000 10412511808 10744860672 1468085184 15.197 100 87 174 1 1504339088 7782944 28470960
16:59:48 23062 8192000000 10443874208 10774654976 1491693184 15.404 100 88 176 1 1528557664 8674704 28189776
17:00:24 20073 8192000000 10450827424 10789875712 1508687648 15.552 100 84 168 0 1544430352 8758240 26984464
17:00:53 15493 8192000000 10469412016 10810003456 1532892784 15.762 100 83 165 1 1567711184 8975760 25842640
17:01:23 12356 8192000000 10507101408 10850676736 1563494768 16.026 100 83 166 1 1598798832 9856240 25447824
17:01:44 9635 8192000000 10522179168 10870198272 1580782784 16.175 100 85 170 2 1617585776 10295792 26507200
17:02:01 12797 8192000000 10547475568 10894925824 1594915856 16.296 100 85 170 2 1631127056 10582736 25628464
17:02:24 18758 8192000000 10553819904 10914557952 1621495920 16.523 100 82 163 1 1657042512 10952944 24593648
17:02:50 13495 8192000000 10582133472 10941100032 1640601312 16.685 100 79 158 0 1675135840 11351712 23182816
17:03:12 13425 8192000000 10599496544 10961780736 1654368736 16.801 100 80 158 1 1689203088 11697536 23136816
17:03:36 12178 8192000000 10619757776 10991550464 1681214528 17.028 100 73 146 3 1715266032 12225664 21825840
17:03:57 7196 8192000000 10643336336 11010883584 1703517504 17.215 100 81 163 3 1739403456 12217296 23668656
17:04:11 7359 8192000000 10667448608 11035729920 1721906128 17.368 100 80 160 0 1757546064 12845008 22794928
17:04:26 6456 8192000000 10673805904 11043627008 1736041328 17.486 100 84 168 1 1773914592 13904400 23968864
17:04:41 4994 8192000000 10683485552 11060617216 1748374784 17.588 100 83 166 3 1785883440 13535664 23972992
17:04:53 4389 8192000000 10696708896 11072610304 1755373440 17.646 100 79 158 0 1791245888 13310816 22561632
17:05:04 3136 8192000000 10697142544 11076485120 1761729152 17.699 100 85 171 1 1798872736 12636800 24506784
17:05:14 5811 8192000000 10713063584 11090280448 1770397920 17.770 100 84 167 2 1807501568 12591536 24512112
17:05:27 5029 8192000000 10721009760 11102412800 1787035040 17.907 100 89 175 0 1824458528 13012432 24411056
17:05:38 2639 8192000000 10724509232 11104780288 1791344160 17.943 100 87 171 3 1828078720 13190304 23544256
17:05:47 3097 8192000000 10740821488 11121000448 1798878832 18.005 100 88 176 0 1836891104 12795776 25216496
17:05:56 3616 8192000000 10738129136 11121131520 1800955664 18.022 100 82 162 3 1836097088 12355040 22786384
17:06:07 3775 8192000000 10751618160 11131830272 1807492192 18.075 100 85 168 0 1842589408 12781408 22315808
17:06:17 3624 8192000000 10750700672 11134164992 1811466000 18.108 100 86 171 2 1848920464 13968608 23485856
17:06:30 3128 8192000000 10754491856 11138109440 1815307344 18.139 100 80 158 2 1851611280 14293056 22010880
17:06:41 3307 8192000000 10772165072 11156914176 1830123424 18.260 100 89 176 2 1869323856 14679632 24520800
17:06:51 1885 8192000000 10778518800 11160010752 1832855280 18.283 100 94 188 2 1873871200 15283360 25732560
17:06:59 1935 8192000000 10781979600 11167956992 1837745504 18.322 100 89 177 0 1877253616 14794928 24713184
17:07:08 2205 8192000000 10788545024 11173130240 1847285328 18.400 100 94 189 2 1887718576 14342512 26090736
17:07:16 2427 8192000000 10791590752 11181989888 1845806992 18.388 100 77 153 2 1879180288 11908704 21464592
17:07:25 2250 8192000000 10796264992 11187396608 1852977600 18.446 100 87 174 2 1888913904 12137392 23798912
17:07:33 1512 8192000000 10804345232 11190980608 1861726768 18.517 100 93 189 1 1900866752 12969216 26170768
17:07:41 2403 8192000000 10811931456 11197521920 1863622864 18.533 100 93 186 0 1903533120 13493248 26417008
17:07:50 1496 8192000000 10809519520 11196555264 1860868288 18.510 100 89 176 2 1899748720 13571328 25309104
17:07:58 1148 8192000000 10818306128 11205799936 1866386864 18.555 100 93 183 2 1906495456 13674048 26434544
17:08:05 8392 8192000000 10810995184 11207352320 1867573536 18.565 100 67 134 0 1898882896 12996864 18312496
17:08:23 5451 8192000000 10819095520 11210903552 1875241920 18.627 100 83 167 3 1910523712 11158656 24123136
17:08:34 2494 8192000000 10805004032 11210223616 1878654624 18.654 100 75 150 2 1911986944 11906176 21426144
17:08:44 1915 8192000000 10823680288 11218288640 1880786160 18.671 100 87 174 0 1918822848 13221792 24814896
17:08:52 2264 8192000000 10802453616 11213619200 1879142640 18.658 100 63 126 3 1908572736 11325456 18104640
17:09:02 5112 8192000000 10810714752 11216547840 1882395008 18.684 100 66 129 2 1910488736 10188096 17905632
17:09:16 5307 8192000000 10782851936 11212562432 1881888160 18.680 100 36 73 1 1899113504 6746400 10478944
17:09:28 35710 8192000000 10814190272 11218718720 1882048608 18.682 100 45 93 1 1901704576 5670528 13985440
17:10:10 1465 8192000000 10833820512 11233038336 1890351872 18.749 100 84 168 1 1926172832 10864736 24956224
17:10:18 15396 8192000000 10822162560 11225337856 1888331648 18.732 100 65 130 1 1916881472 9933424 18616400
17:10:40 5178 8192000000 10808226384 11226021888 1884536240 18.702 100 40 80 1 1904389424 7357520 12495664
17:10:53 4749 8192000000 10800877616 11225448448 1883971136 18.697 100 39 78 0 1905509712 11082992 10455584
17:11:05 9200 8192000000 10798010352 11225206784 1883946416 18.697 100 22 44 0 1895891920 5496000 6449504
17:11:22 3376 8192000000 10797674208 11227308032 1886402528 18.717 100 34 68 3 1903579680 7226336 9950816
17:11:32 8262 8192000000 10790168928 11223220224 1889304576 18.740 100 24 47 3 1901766032 5304448 7157008
17:11:46 6971 8192000000 10798603552 11229925376 1891873136 18.761 100 31 63 2 1906721040 6047168 8800736
17:12:00 6971 8192000000 10802678864 11229872128 1890098864 18.747 100 17 34 2 1901393696 6586528 4708304
17:12:17 10468 8192000000 10801658672 11235414016 1894661792 18.783 100 27 54 2 1909083408 6877408 7544208
17:12:34 9783 8192000000 10810291728 11238838272 1896331712 18.797 100 28 56 1 1911059344 6179360 8548272
17:12:50 10688 8192000000 10812876352 11239858176 1897464160 18.806 100 30 58 0 1915787216 9654352 8668704
17:13:08 10333 8192000000 10803179120 11237552128 1898125664 18.811 100 14 28 2 1907055008 5022512 3906832
17:13:25 7745 8192000000 10822022512 11243335680 1899951024 18.826 100 19 38 1 1911663696 5731296 5981376
17:13:43 12115 8192000000 10816178368 11246592000 1902992064 18.850 100 20 40 1 1914248512 5573008 5683440
17:14:04 13792 8192000000 10823998080 11251331072 1906724960 18.880 100 21 42 2 1918992000 6901792 5365248
17:14:24 21156 8192000000 10819459376 11245379584 1884171728 18.699 99 19 38 0 1895042096 5722864 5147504
17:15:26 30685 8192000000 10811172272 11250163712 1887694848 18.727 99 32 64 0 1902935312 5057072 10183392
17:16:03 9839 8192000000 10795904800 11234869248 1862964688 18.527 98 24 47 2 1875314304 6080496 6269120
17:16:19 9719 8192000000 10810011408 11247169536 1895585408 18.791 100 22 44 1 1907448704 5268128 6595168
17:16:36 7747 8192000000 10810596112 11245744128 1899943328 18.826 100 26 52 0 1913710032 6414512 7352192
17:16:55 7502 8192000000 10794845584 11230048256 1859271840 18.497 98 20 41 3 1871607248 6350704 5984704
17:17:12 10192 8192000000 10803915824 11237289984 1885831376 18.712 100 26 52 3 1899696048 6496944 7367728
17:17:32 7674 8192000000 10832832272 11252715520 1899753536 18.824 100 27 53 2 1913554304 5294448 8506320
17:17:50 5790 8192000000 10805894096 11238653952 1887814592 18.728 100 22 44 0 1900544144 6511504 6218048
17:18:04 12447 8192000000 10771692144 11197878272 1770861488 17.774 94 20 40 2 1785780608 9927104 4992016
17:18:23 16557 8192000000 10742904304 11160920064 1747803648 17.583 94 7 13 2 1754191024 4455904 1931472
17:18:46 14846 8192000000 10727908544 11149869056 1706025696 17.236 92 13 26 1 1714751216 5440944 3284576
17:19:08 16492 8192000000 10720253456 11143884800 1744078624 17.552 96 14 28 0 1753281280 5215040 3987616
17:19:31 9313 8192000000 10679047920 11091136512 1672972928 16.958 93 21 41 4 1683869584 5033824 5862832
17:19:47 62702 8192000000 10695561648 11078647808 1634988928 16.637 91 38 74 0 1650578672 4447392 11142352
17:20:56 19633 8192000000 10667331536 11082903552 1675833600 16.982 95 16 32 0 1685248048 5038560 4375888
17:21:22 11814 8192000000 10703129328 11110260736 1747620608 17.582 98 30 58 3 1762116096 6028672 8466816
17:21:41 6034 8192000000 10709973424 11119763456 1768865760 17.758 99 31 62 2 1782968928 5986256 8116912
17:21:53 5506 8192000000 10711771728 11122315264 1772891504 17.791 99 22 44 1 1785382304 5998928 6491872
17:22:05 5973 8192000000 10715818432 11141783552 1809630672 18.093 100 31 61 4 1825037840 6034320 9372848
17:22:18 10172 8192000000 10731040816 11151011840 1815640144 18.142 100 20 40 1 1826672512 4885632 6146736
17:22:35 6711 8192000000 10741986736 11153080320 1815409072 18.140 100 20 40 0 1826927040 5779072 5738896
17:22:48 7618 8192000000 10745696272 11162857472 1829073760 18.252 100 31 62 0 1843385488 5916336 8395392
17:23:05 8273 8192000000 10756557008 11174641664 1833259744 18.286 100 31 62 2 1847993216 5526128 9207344
17:23:21 11303 8192000000 10749665920 11181420544 1841666848 18.354 100 23 46 0 1854268176 5630480 6970848
17:23:41 8493 8192000000 10759218400 11187085312 1844156064 18.375 100 18 36 0 1855109792 5441888 5511840
17:23:56 9442 8192000000 10767573104 11187318784 1847129472 18.399 100 26 52 3 1859889664 4943392 7816800
17:24:13 10207 8192000000 10766428208 11194118144 1854770096 18.461 100 31 62 4 1869305168 5850080 8684992
17:24:30 18583 8192000000 10772269808 11199180800 1857612064 18.484 100 25 48 3 1870050480 5203664 7234752
17:24:56 59135 8192000000 10780425968 11207864320 1860465504 18.507 100 33 66 1 1875817328 5788448 9563376
17:26:03 13285 8192000000 10785617600 11211821056 1866680512 18.557 100 26 52 0 1880378016 6497200 7200304
17:26:22 6340 8192000000 10781797808 11208241152 1867406144 18.563 100 23 46 1 1878756592 5214688 6135760
17:26:36 6472 8192000000 10789710064 11213570048 1870258544 18.586 100 26 52 0 1883149728 5559616 7331568
17:26:50 6738 8192000000 10775602720 11213209600 1870450432 18.588 100 27 54 2 1884687600 6301312 7935856
17:27:06 53099 8192000000 10814593936 11238735872 1887056256 18.722 100 33 66 2 1901933232 5623520 9253456
17:28:07 11067 8192000000 10845718624 11261173760 1907448800 18.886 100 46 91 2 1929116704 9670400 11997504
17:28:26 6219 8192000000 10852078576 11271163904 1918711888 18.977 100 53 103 1 1943726320 9981984 15032448
17:28:40 32681 8192000000 10856362176 11279597568 1924676064 19.024 100 59 118 1 1953837440 12059984 17101392
17:29:34 18202 8192000000 10874163840 11295662080 1938410864 19.134 100 46 92 0 1964765872 13465856 12889152
17:29:59 3051 8192000000 10894457888 11308097536 1946271488 19.197 100 56 113 0 1978692992 16713248 15708256
17:30:08 14293 8192000000 10893340288 11319050240 1950803312 19.233 100 54 106 1 1983384800 17412576 15168912
17:30:31 8301 8192000000 10900434880 11320614912 1955111120 19.267 100 58 116 2 1989575184 17264544 17199520
17:30:51 67170 8192000000 10904839424 11330707456 1957644304 19.287 100 48 96 3 1990398096 19149200 13604592
17:32:05 45148 8192000000 10890333632 11331346432 1959325968 19.301 100 40 80 1 1990034912 19047152 11661792
17:32:58 23872 8192000000 10896922128 11334266880 1964245440 19.340 100 34 68 1 1992566528 17684944 10636144
17:33:37 15575 8192000000 10902128832 11347062784 1966919904 19.361 100 29 56 2 1998817056 21997968 9899184
17:34:02 5700 8192000000 10925213488 11352735744 1975473888 19.429 100 56 112 4 2013327328 21020576 16832864
17:34:15 3851 8192000000 10935820784 11354648576 1978198480 19.450 100 64 130 0 2021679040 24067440 19413120
17:34:25 2158 8192000000 10952764928 11363905536 1984144208 19.497 100 80 158 2 2032406416 24743504 23518704
17:34:41 9234 8192000000 10924971520 11344113664 1963326192 19.332 99 59 116 0 2004910240 24588288 16995760
17:35:00 8293 8192000000 10930279008 11358818304 1976562384 19.437 100 59 116 0 2020586880 26466640 17557856
17:35:20 11869 8192000000 10929865072 11363745792 1980422208 19.468 100 52 104 3 2023636672 27592064 15622400
17:35:42 25624 8192000000 10934689952 11372265472 1964677152 19.343 99 55 109 0 2009194000 27936528 16580320
17:36:20 8247 8192000000 10940442848 11374731264 1986903440 19.519 100 51 102 3 2031709536 28439072 16367024
17:36:36 7309 8192000000 10935390992 11368566784 1982518112 19.485 100 54 108 1 2025673088 26694368 16460608
17:36:52 8121 8192000000 10939688576 11368706048 1982261024 19.483 100 62 124 3 2029552224 27638016 19653184
17:37:09 5388 8192000000 10954024112 11379314688 1990158080 19.545 100 70 138 1 2043007552 31657296 21192176
17:37:22 2844 8192000000 10969646848 11388321792 1996861664 19.598 100 83 162 3 2053436256 32792160 23782432
17:37:33 13135 8192000000 10957871360 11390177280 1994503120 19.579 100 69 139 0 2050269152 34678112 21087920
17:37:57 12161 8192000000 10955292544 11382206464 1990641632 19.549 100 55 109 0 2039915536 32608192 16665712
17:38:16 7257 8192000000 10949451296 11381239808 1980647760 19.470 99 63 127 1 2035395792 35391360 19356672
17:38:31 10569 8192000000 10965908096 11398762496 1997813968 19.605 100 63 125 3 2053254512 36522528 18918016
17:38:53 5046 8192000000 10972854528 11407491072 2001388992 19.634 100 62 123 1 2058107632 38666640 18052000
17:39:07 3763 8192000000 10967100656 11399311360 1996157568 19.592 100 61 122 1 2054282288 39792512 18332208
17:39:20 6891 8192000000 10981099648 11407904768 2004398944 19.657 100 67 133 3 2067746432 43322176 20025312
17:39:35 3572 8192000000 10986777424 11412045824 2009468224 19.697 100 74 148 0 2074139360 43058336 21612800
17:39:47 4739 8192000000 10988256800 11417751552 2010200848 19.703 100 71 140 2 2074794432 43823168 20770416
17:40:00 1879 8192000000 11002214816 11423735808 2015385456 19.744 100 81 162 2 2083135744 43465712 24284576
17:40:09 2354 8192000000 10998613152 11426054144 2020575552 19.785 100 81 161 1 2088776816 44159440 24041824
17:40:21 6598 8192000000 10975820112 11401863168 1960943472 19.314 97 72 144 2 2027679040 44744640 21990928
17:40:40 3877 8192000000 10993279376 11419320320 2007966640 19.686 100 66 132 0 2074450864 46185024 20299200
17:40:57 5486 8192000000 10998874304 11431817216 2013379920 19.728 100 59 117 0 2080478176 49054256 18044000
17:41:11 4182 8192000000 10999176960 11426107392 2001702688 19.636 99 68 134 1 2067923392 45768592 20452112
17:41:25 2455 8192000000 11018176336 11436691456 2024177616 19.813 100 74 146 3 2092050928 45427296 22446016
17:41:35 2036 8192000000 11008070736 11434508288 2027645920 19.840 100 78 156 2 2098080736 46909136 23525680
17:41:44 3047 8192000000 11016926096 11433787392 2005044992 19.663 99 86 167 1 2079231536 48441008 25745536
17:41:55 2920 8192000000 11004211296 11424350208 2014824960 19.739 100 89 179 2 2091142944 49474736 26843248
17:42:05 2126 8192000000 11022909136 11437285376 2023255088 19.806 100 92 183 0 2102747488 51112768 28379632
17:42:14 4009 8192000000 11013076304 11429568512 2016149648 19.750 100 83 166 2 2092487680 50689520 25648512
17:42:26 5655 8192000000 11004114272 11427647488 2015469472 19.745 100 72 144 0 2087684288 49290720 22924096
17:42:39 2293 8192000000 10999082192 11421327360 2006593120 19.675 100 82 162 4 2083458448 51297232 25568096
17:42:51 3473 8192000000 11014238960 11435855872 2017981792 19.764 100 76 151 1 2094535088 52702160 23851136
17:43:05 1597 8192000000 11015701056 11437301760 2019675296 19.778 100 79 157 0 2096537776 52216624 24645856
17:43:13 6516 8192000000 10973373472 11386671104 1960879280 19.313 98 79 154 0 2036668304 51163632 24625392
17:43:29 7449 8192000000 10987925264 11406389248 1988659584 19.533 100 65 127 0 2061656400 52727408 20269408
17:43:43 4609 8192000000 11000950560 11422420992 2001017840 19.631 100 76 148 2 2078033328 53722816 23292672
17:43:55 3972 8192000000 10953889936 11374374912 1957914240 19.289 98 69 133 2 2034926608 55777424 21234944
17:44:14 1742 8192000000 10974451088 11384045568 1924539616 19.023 96 84 168 2 2009209056 58729120 25940320
17:44:25 2220 8192000000 10987187760 11398975488 1975382640 19.428 100 80 158 0 2061463616 60888064 25192912
17:44:36 2477 8192000000 10980664352 11396673536 1977228848 19.443 100 77 153 0 2063069808 61494464 24346496
17:44:47 2982 8192000000 10997012224 11416236032 1993154288 19.569 100 87 175 0 2082257296 60761664 28341344
17:44:58 1690 8192000000 10991384032 11402395648 1977707360 19.447 100 91 185 1 2068129088 61292368 29129360
17:45:06 1845 8192000000 10984942208 11392000000 1970235696 19.387 100 88 178 1 2057357392 59003552 28118144
17:45:15 2210 8192000000 10971512928 11393101824 1973225392 19.411 100 75 151 1 2056974368 59831936 23917040
17:45:24 4198 8192000000 10957408624 11383275520 1954582208 19.263 99 64 126 1 2032871264 57276160 21012896
17:45:37 2971 8192000000 10946525120 11364610048 1936057696 19.115 99 76 154 0 2016349328 55997600 24294032
17:45:49 2332 8192000000 10970459504 11383234560 1971263136 19.395 100 92 184 0 2051577840 51762464 28552240
17:45:59 3725 8192000000 10961856976 11367284736 1947474112 19.206 99 84 168 1 2027149648 53259776 26415760
17:46:09 1072 8192000000 10967611408 11373649920 1962786432 19.328 100 90 182 2 2044131584 53877344 27467808
17:46:18 6547 8192000000 10937033184 11368058880 1950415232 19.230 100 63 126 2 2026585232 56503904 19666096
17:46:43 11412 8192000000 10921618656 11357483008 1934494160 19.103 99 40 80 2 2000397664 52801216 13102288
17:47:04 12754 8192000000 10917772624 11353968640 1925265984 19.029 99 35 67 3 1989499920 52630064 11603872
17:47:23 17850 8192000000 10934310544 11374809088 1953086528 19.251 100 37 74 2 2021360336 55511728 12762080
17:47:47 12171 8192000000 10930776672 11368054784 1913622016 18.936 98 36 72 1 1985386832 60146112 11618704
17:48:12 17053 8192000000 10914153184 11351269376 1924941200 19.026 99 29 57 2 1984264512 49501264 9822048
17:48:38 22216 8192000000 10902878512 11345162240 1919991104 18.987 99 38 76 0 1979038640 46569184 12478352
17:49:28 11172 8192000000 10873813552 11307745280 1859289024 18.498 97 32 62 2 1918304432 48444640 10570768
17:49:45 10203 8192000000 10879563776 11320778752 1893863520 18.777 100 26 52 2 1956707632 53682128 9161984
17:50:02 16117 8192000000 10876110736 11323916288 1909072016 18.899 100 28 57 0 1971167616 51915744 10179856
17:50:24 10043 8192000000 10892130656 11324768256 1903806912 18.857 100 36 72 0 1967997744 51716416 12474416
17:50:47 22151 8192000000 10867867264 11312926720 1891180528 18.755 100 33 66 4 1958049024 54976064 11892432
17:51:31 40455 8192000000 10860842416 11313352704 1882706496 18.687 99 24 46 0 1936598880 45793424 8098960
17:52:32 46130 8192000000 10843686304 11299323904 1895510912 18.790 99 10 20 2 1918062288 18702784 3848592
17:53:24 55953 8192000000 10855444480 11296010240 1904762064 18.865 99 31 63 0 1923165792 9130912 9272816
17:54:29 5236 8192000000 10884640528 11317325824 1933790384 19.097 100 59 111 2 1958458864 9274944 15393536
17:54:45 6799 8192000000 10899187888 11325128704 1939982096 19.147 100 61 122 0 1971902464 14415152 17505216
17:55:08 30671 8192000000 10864040944 11330777088 1935664976 19.112 100 17 33 3 1951604592 11207584 4732032
17:56:18 43753 8192000000 10861294752 11325390848 1932036992 19.083 100 21 42 1 1954940112 16472784 6430336
17:57:08 74155 8192000000 10859760880 11309469696 1879691968 18.663 97 14 29 0 1899063008 14792544 4578496
17:58:35 93035 8192000000 10908822576 11348017152 1935953904 19.114 99 18 36 2 1961186912 19505120 5727888
18:00:17 85901 8192000000 10894682336 11358355456 1969940256 19.385 100 20 40 0 1984978000 9305296 5732448
18:01:49 156284 8192000000 10895027072 11369353216 1971872016 19.400 100 16 32 0 1986594368 10101792 4620560
18:04:40 3062 8192000000 10913176032 11366756352 1979917504 19.464 100 26 52 0 1996696288 9327904 7450880
18:04:49 24498 8192000000 10899240368 11362164736 1963957968 19.337 99 26 52 1 1980308160 8749488 7600704
18:05:21 41355 8192000000 10913558368 11361779712 1976785104 19.439 100 44 90 0 1998759424 8776272 13198048
18:06:15 49359 8192000000 10898320960 11368783872 1961972864 19.322 99 43 85 1 1987048976 11474640 13601472
18:07:12 28276 8192000000 10901946368 11366346752 1957249840 19.284 99 21 42 0 1975401568 12002784 6148944
18:07:49 68466 8192000000 10902769056 11370500096 1960221856 19.308 99 31 63 1 1982148864 13386480 8540528
18:09:46 47627 8192000000 10896004816 11375357952 1975544064 19.429 100 9 19 0 1991910544 13524544 2841936
18:10:42 59782 8192000000 10891778240 11363958784 1957832352 19.289 99 18 36 2 1974181968 11059552 5290064
18:12:32 89607 8192000000 10901918544 11372539904 1970269216 19.388 99 26 52 1 1991102464 13163232 7670016
18:14:12 44527 8192000000 10893129488 11390992384 1975141152 19.426 100 9 18 0 1998356880 20475600 2740128
18:15:06 12793 8192000000 10895518880 11393363968 1975654592 19.430 100 2 4 0 1993598464 17525504 418368
18:15:25 28249 8192000000 10913591152 11398176768 1978575392 19.453 100 7 14 0 1996967664 16821360 1570912
18:16:00 61621 8192000000 10907713584 11393134592 1976424048 19.436 99 25 48 2 1991907136 8589888 6893200
18:17:19 61822 8192000000 10900258576 11373867008 1936130912 19.116 97 15 31 0 1950702448 10218144 4353392
18:18:42 34182 8192000000 10921166464 11385827328 1969607568 19.382 99 21 42 2 1986768752 11092944 6068240
18:19:28 89068 8192000000 10936058896 11398283264 1971627744 19.398 99 16 32 0 1987891296 11624896 4638656
18:21:05 58907 8192000000 10934374704 11400888320 1979491440 19.461 99 16 32 1 2000555728 16375776 4688512
18:22:11 24474 8192000000 10945296880 11413438464 2007581648 19.682 100 18 36 0 2029688960 16804240 5303072
18:22:42 100411 8192000000 10934577216 11431763968 1982884752 19.488 99 11 22 0 2011185120 25248304 3052064
18:24:28 64983 8192000000 10924368144 11407769600 1926361920 19.038 96 10 20 0 1947741232 18520960 2858352
18:25:40 40182 8192000000 10918399696 11381788672 1957090064 19.283 98 24 47 1 1978759632 15075808 6593760
18:26:29 57442 8192000000 10928064176 11397529600 1954447072 19.262 98 28 56 2 1979693888 17736832 7509984
18:27:36 33494 8192000000 10899079904 11342929920 1887279360 18.724 95 27 53 3 1902537632 8143936 7114336
18:28:20 53536 8192000000 10909524112 11361271808 1933995088 19.099 98 44 88 2 1956858720 11087248 11776384
18:30:05 95553 8192000000 10899373536 11356487680 1900043552 18.827 96 29 58 0 1914605616 7156560 7405504
18:31:49 38765 8192000000 10873793216 11353972736 1938459424 19.134 98 18 37 0 1952344240 8733488 5151328
18:32:37 65226 8192000000 10878666496 11359391744 1924785920 19.025 98 6 12 0 1935380688 8904624 1690144
18:35:01 57865 8192000000 10859798704 11342176256 1907214784 18.884 97 5 10 0 1915935808 7275648 1445376
18:36:28 10702 8192000000 10893883616 11338797056 1944006256 19.179 99 45 86 5 1962119264 5948864 12164144
18:36:45 53030 8192000000 10853279328 11311140864 1877956832 18.649 96 28 56 3 1898122720 12292864 7873024
18:37:51 75668 8192000000 10881182256 11347312640 1896659600 18.799 97 30 60 1 1922100960 16438096 9003264
18:39:28 72860 8192000000 10863549632 11352281088 1904092368 18.859 98 12 24 0 1923293568 15980992 3220208
18:40:54 51476 8192000000 10869349664 11329138688 1860912976 18.511 96 17 34 0 1881165664 15729200 4523488
18:41:52 43624 8192000000 10869163584 11318530048 1894668272 18.783 98 27 54 0 1914437872 12758192 7011408
18:42:44 86899 8192000000 10864182160 11336962048 1877715920 18.647 97 22 44 1 1897909280 14183808 6009552
18:44:26 66944 8192000000 10855481312 11317833728 1862243232 18.521 96 18 36 1 1880964320 13257456 5463632
18:45:43 58706 8192000000 10860770848 11318550528 1889839424 18.744 98 24 48 0 1909303664 12507072 6957168
18:46:58 50479 8192000000 10858526640 11321217024 1891985584 18.762 98 24 48 1 1916122320 17357296 6779440
18:47:56 69714 8192000000 10848485024 11319570432 1844347360 18.376 96 20 40 0 1864016624 13757312 5911952
18:49:31 103200 8192000000 10861777504 11309965312 1903499856 18.854 99 21 43 0 1920751216 11148112 6103248
18:51:22 77224 8192000000 10839878640 11314438144 1871308032 18.595 97 28 56 0 1898162848 18771024 8083792
18:52:45 11126 8192000000 10837280960 11319455744 1912970800 18.930 100 5 10 1 1932629712 18281856 1377056
18:53:34 54962 8192000000 10830068656 11309772800 1902964976 18.850 99 13 26 1 1917570928 10823984 3781968
18:54:39 28878 8192000000 10833342608 11312537600 1918166752 18.972 100 8 16 0 1930900672 10536704 2197216
18:55:15 33588 8192000000 10821273744 11298521088 1862641792 18.525 97 10 20 1 1879727312 14454432 2631088
18:55:54 60009 8192000000 10828879600 11287547904 1872230976 18.602 98 10 20 0 1888029216 13027568 2770672
18:57:01 51399 8192000000 10838349504 11306881024 1922230080 19.005 100 19 38 1 1939072048 11123600 5718368
18:58:04 88821 8192000000 10869441008 11329839104 1917027600 18.963 99 13 26 0 1933505696 12756432 3721664
18:59:39 49196 8192000000 10882724128 11340476416 1949512080 19.223 100 19 38 0 1964081648 9586944 4982624
19:00:36 50656 8192000000 10896928016 11361120256 1964466112 19.342 100 17 34 2 1978931328 9166944 5298272
19:01:33 67335 8192000000 10885336816 11364855808 1938928464 19.138 98 19 38 0 1957609952 12748608 5932880
19:02:46 52695 8192000000 10880196880 11359850496 1944888400 19.186 99 8 16 0 1956627152 9440224 2298528
19:03:46 39385 8192000000 10879800720 11334914048 1916682064 18.960 98 14 28 0 1929266912 8469248 4115600
19:04:36 47245 8192000000 10911443632 11369222144 1972924880 19.409 100 35 67 3 1996461984 13574464 9962640
19:05:29 28295 8192000000 10943504496 11384168448 1988493184 19.532 100 54 106 0 2013849392 11131104 14225104
19:06:06 29186 8192000000 10931068752 11392999424 1993243392 19.569 100 49 99 2 2021142544 13759792 14139360
19:06:48 85637 8192000000 10926765168 11383255040 1971231136 19.395 99 23 46 2 1990045840 12162496 6652208
19:08:41 44060 8192000000 10922471504 11390115840 1975077216 19.426 99 35 69 0 1996981728 12287392 9617120
19:09:43 71746 8192000000 10943331840 11391148032 1989865040 19.543 100 27 53 0 2007940064 10427008 7648016
19:11:05 20722 8192000000 10925689008 11373670400 1940923216 19.154 97 50 100 0 1965046784 9672480 14451088
19:11:32 48306 8192000000 10925807776 11387351040 1970419664 19.389 99 39 78 2 1993801792 12882528 10499600
19:12:27 97161 8192000000 10901688992 11365543936 1947102496 19.203 98 20 40 1 1960842256 8266048 5473712
19:14:13 101386 8192000000 10913459520 11377934336 1963117312 19.331 99 21 42 2 1978239296 9074864 6047120
19:16:01 35482 8192000000 10881082688 11350192128 1905962304 18.874 96 28 56 1 1925432384 12132576 7337504
19:16:44 89943 8192000000 10855285712 11334438912 1926670832 19.040 98 12 23 1 1937236704 6972336 3593536
19:18:20 45616 8192000000 10846128736 11321765888 1852961504 18.446 95 13 25 1 1863389552 6968848 3459200
19:19:17 45174 8192000000 10848133872 11309051904 1866320928 18.554 96 21 42 0 1878985040 6766368 5897744
19:20:09 77265 8192000000 10839990656 11310596096 1891111152 18.755 98 16 32 0 1902157376 6318560 4727664
19:21:33 34357 8192000000 10848005216 11319214080 1901966592 18.842 98 22 44 1 1914363248 6465776 5930880
19:22:14 46053 8192000000 10835604720 11293351936 1853719616 18.452 96 20 40 2 1866304496 7228784 5356096
19:23:23 58383 8192000000 10836634144 11305029632 1867246880 18.562 97 13 24 1 1882857440 11857456 3753104
19:25:01 76286 8192000000 10830263680 11297169408 1832690256 18.281 95 18 36 1 1846508304 8831024 4987024
19:26:23 31745 8192000000 10846307200 11301613568 1867445264 18.564 97 30 60 0 1883899552 8608800 7845488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-11-2020 19:28:05 to 08-11-2020 19:28:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-11-2020 19:28:37 to 08-11-2020 19:28:39.

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          239847
MON$OLDEST_ACTIVE               240177
MON$OLDEST_SNAPSHOT             240177
MON$NEXT_TRANSACTION            240177
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                       2003456
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:99: 
:100: mscs-test-161.budzdorov.ru    Sun Nov  8 19:27:07 2020
:101:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:102: 
:103: 
:104: mscs-test-161.budzdorov.ru    Sun Nov  8 19:27:07 2020
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Sun Nov  8 19:27:08 2020
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sun Nov  8 19:27:08 2020
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
--- end of diff output ---

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

08.11.20 19:28:40. 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
2020-11-08 19:28:42 No severe PSQL-related problems occured
08.11.20 19:28:44. End of report.