Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.11.2020 01: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 17487212 kB
MemAvailable 31493796 kB
Buffers 0 kB
Cached 14190772 kB
SwapCached 6308 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 2020-11-19 01:27:03
DTS_END                         2020-11-19 01:27:03.5460
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/33324
TRN_ID                          239663
ATT_ID                          631
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: 9308.57 27679 1117028
customer order: creation 170.45 376 20454
customer order: refuse 13.79 359 1655
order to supplier: creation 45.16 1325 5419
order to supplier: removal 3.43 97422 411
invoice (draft): creation 45.58 3559 5470
invoice (draft): removal 53.37 804 6404
invoice accept: apply 42.26 16966 5071
invoice accept: cancel 48.44 804 5813
customer reserve: creation 3865.29 168 463835
customer reserve: removal 4722.10 55 566652
realization accept: apply 83.29 173 9995
realization accept: cancel 85.68 115 10282
payment from customer: creation 59.18 124 7102
payment from customer: removal 5.60 92 672
payment to supplier: creation 49.17 121 5900
payment to supplier: removal 3.57 94 428
service: total inventory turnovers 4.67 1151 560
service: total monetary turnovers 6.65 55 798
service: aggregate perf. data 0.86 17268 103
service: refresh index statistics 0.03 412549 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-11-2020 01:27:58 to 19-11-2020 01:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4999
TEST_TIME 2 5221
TEST_TIME 3 4965
TEST_TIME 4 4554
TEST_TIME 5 4505
TEST_TIME 6 4597
TEST_TIME 7 4994
TEST_TIME 8 5673
TEST_TIME 9 5764
TEST_TIME 10 5623
TEST_TIME 11 6332
TEST_TIME 12 6687
TEST_TIME 13 6806
TEST_TIME 14 7205
TEST_TIME 15 8064
TEST_TIME 16 8370
TEST_TIME 17 8521
TEST_TIME 18 8585
TEST_TIME 19 8650
TEST_TIME 20 9009
TEST_TIME 21 9070
TEST_TIME 22 9186
TEST_TIME 23 9413
TEST_TIME 24 10280
TEST_TIME 25 10220
TEST_TIME 26 10610
TEST_TIME 27 11296
TEST_TIME 28 11642
TEST_TIME 29 11342
TEST_TIME 30 11410
TEST_TIME 31 11129
TEST_TIME 32 10987
TEST_TIME 33 10915
TEST_TIME 34 10715
TEST_TIME 35 10589
TEST_TIME 36 10418
TEST_TIME 37 10339
TEST_TIME 38 10072
TEST_TIME 39 10138
TEST_TIME 40 9986
TEST_TIME 41 9888
TEST_TIME 42 10121
TEST_TIME 43 10109
TEST_TIME 44 10046
TEST_TIME 45 9927
TEST_TIME 46 9915
TEST_TIME 47 10085
TEST_TIME 48 10000
TEST_TIME 49 9986
TEST_TIME 50 10093
TEST_TIME 51 9994
TEST_TIME 52 10008
TEST_TIME 53 10018
TEST_TIME 54 10011
TEST_TIME 55 9987
TEST_TIME 56 9830
TEST_TIME 57 9841
TEST_TIME 58 9784
TEST_TIME 59 9716
TEST_TIME 60 9752
TEST_TIME 61 9698
TEST_TIME 62 9664
TEST_TIME 63 9587
TEST_TIME 64 9502
TEST_TIME 65 9469
TEST_TIME 66 9477
TEST_TIME 67 9557
TEST_TIME 68 9499
TEST_TIME 69 9513
TEST_TIME 70 9638
TEST_TIME 71 9638
TEST_TIME 72 9602
TEST_TIME 73 9614
TEST_TIME 74 9619
TEST_TIME 75 9652
TEST_TIME 76 9631
TEST_TIME 77 9743
TEST_TIME 78 9757
TEST_TIME 79 9682
TEST_TIME 80 9597
TEST_TIME 81 9619
TEST_TIME 82 9543
TEST_TIME 83 9525
TEST_TIME 84 9530
TEST_TIME 85 9478
TEST_TIME 86 9455
TEST_TIME 87 9449
TEST_TIME 88 9416
TEST_TIME 89 9452
TEST_TIME 90 9430
TEST_TIME 91 9440
TEST_TIME 92 9463
TEST_TIME 93 9504
TEST_TIME 94 9533
TEST_TIME 95 9606
TEST_TIME 96 9586
TEST_TIME 97 9587
TEST_TIME 98 9537
TEST_TIME 99 9639
TEST_TIME 100 9666
TEST_TIME 101 9647
TEST_TIME 102 9567
TEST_TIME 103 9520
TEST_TIME 104 9531
TEST_TIME 105 9512
TEST_TIME 106 9486
TEST_TIME 107 9456
TEST_TIME 108 9419
TEST_TIME 109 9399
TEST_TIME 110 9368
TEST_TIME 111 9357
TEST_TIME 112 9323
TEST_TIME 113 9345
TEST_TIME 114 9310
TEST_TIME 115 9351
TEST_TIME 116 9355
TEST_TIME 117 9385
TEST_TIME 118 9421
TEST_TIME 119 9388
TEST_TIME 120 9310

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-11-2020 01:28:02 to 19-11-2020 01:28:05.

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 1544874 1544874 0 0.00 0 31265 6 0 0
doc_list_biud 1544873 1544873 0 0.00 0 56765 26 0 0
sp_add_invoice_to_stock 5159 5071 88 1.70 34 173885 16966 0 88
sp_cancel_adding_invoice 5813 5813 0 0.00 5 59231 804 0 0
sp_cancel_client_order 1655 1655 0 0.00 4 24131 360 0 0
sp_cancel_customer_reserve 566652 566652 0 0.00 1 33652 55 0 0
sp_cancel_pay_from_customer 672 672 0 0.00 3 8624 92 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 4945 94 0 0
sp_cancel_supplier_invoice 6410 6404 6 0.09 2 56781 805 0 6
sp_cancel_supplier_order 411 411 0 0.00 13 1148685 97422 0 0
sp_cancel_write_off 10282 10282 0 0.00 1 33945 115 0 0
sp_client_order 20454 20454 0 0.00 3 31463 377 0 0
sp_customer_reserve 463835 463835 0 0.00 0 39434 169 0 0
sp_fill_shopping_cart 31330 31330 0 0.00 1 24723 41 0 0
sp_fill_shopping_cart_clo_res 463830 463830 0 0.00 0 23375 15 0 0
sp_get_clo_for_invoice 5066 5066 0 0.00 0 38018 360 0 0
sp_kill_cost_storno 17195 17195 0 0.00 0 8616 58 0 0
sp_kill_qstorno_ret_qs2qd 1150401 1150401 0 0.00 0 56759 30 0 0
sp_kill_qty_storno 606278 606278 0 0.00 0 56763 66 0 0
sp_lock_selected_doc 20869 20869 0 0.00 0 6654 6 0 0
sp_make_cost_storno 28063 28063 0 0.00 0 13996 53 0 0
sp_multiply_rows_for_pdistr 28062 28062 0 0.00 0 28325 30 0 0
sp_multiply_rows_for_qdistr 20454 20454 0 0.00 0 12418 180 0 0
sp_pay_from_customer 7102 7102 0 0.00 4 28335 124 0 0
sp_pay_to_supplier 5900 5900 0 0.00 4 11691 121 0 0
sp_payment_common 13001 13001 0 0.00 1 10251 31 0 0
sp_qd_handle_on_cancel_clo 1655 1655 0 0.00 0 24064 327 0 0
sp_qd_handle_on_invoice_upd_sts 10879 10879 0 0.00 0 34214 334 0 0
sp_qd_handle_on_reserve_upd_sts 9995 9995 0 0.00 0 16890 55 0 0
sp_reserve_write_off 9995 9995 0 0.00 7 16934 173 0 0
sp_supplier_invoice 5470 5470 0 0.00 7 117663 3559 0 0
sp_supplier_order 5419 5419 0 0.00 6 32386 1325 0 0
srv_aggregate_perf_data 103 103 0 0.00 2269 259281 17268 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1210 151780 32797 0 0
srv_find_qd_qs_mism 1068534 1068534 0 0.00 0 31262 5 0 0
srv_make_invnt_saldo 560 560 0 0.00 67 33861 1151 0 0
srv_make_money_saldo 798 798 0 0.00 1 14453 56 0 0
srv_recalc_idx_stat 4 4 0 0.00 202829 693771 412550 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 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5072 5072 0 0.00 0 10919 173 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 3600 89 0 0
t$perf-norm:sp_cancel_client_order 1655 1655 0 0.00 0 4160 11 0 0
t$perf-norm:sp_cancel_customer_reserve 741 741 0 0.00 0 8029 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 672 672 0 0.00 0 2584 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 6571 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 1801 21 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 24351 1420 0 0
t$perf-norm:sp_cancel_write_off 1096 1096 0 0.00 0 4460 8 0 0
t$perf-norm:sp_client_order 20454 20454 0 0.00 0 6486 15 0 0
t$perf-norm:sp_customer_reserve 1010 1010 0 0.00 0 753 4 0 0
t$perf-norm:sp_pay_from_customer 7102 7102 0 0.00 0 5303 8 0 0
t$perf-norm:sp_pay_to_supplier 5900 5900 0 0.00 0 3673 8 0 0
t$perf-norm:sp_reserve_write_off 9995 9995 0 0.00 0 4907 8 0 0
t$perf-norm:sp_supplier_invoice 5470 5470 0 0.00 0 6451 14 0 0
t$perf-norm:sp_supplier_order 5419 5419 0 0.00 0 6437 16 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 325 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 4685 35 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 1071 18 0 0
t$perf-norm:srv_make_money_saldo 798 798 0 0.00 0 4034 33 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 33 10 0 0
v_add_invoice_to_stock 10308 10132 176 1.70 0 10752 23 0 176
v_all_customers 37398 37398 0 0.00 0 21 1 0 0
v_all_suppliers 30110 30110 0 0.00 0 30 1 0 0
v_all_wares 40908 40908 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 1701 10 0 0
v_cancel_client_order 3310 3310 0 0.00 0 4872 7 0 0
v_cancel_customer_prepayment 1344 1344 0 0.00 0 1789 7 0 0
v_cancel_customer_reserve 1482 1482 0 0.00 0 1139 4 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 378 4 0 0
v_cancel_supplier_invoice 782 770 12 1.53 0 7108 31 0 12
v_cancel_supplier_order 822 822 0 0.00 0 676 6 0 0
v_cancel_write_off 2192 2192 0 0.00 0 3949 19 0 0
v_max_id_clo_ord 5419 5419 0 0.00 0 8963 3 0 0
v_max_id_clo_res 1010 1010 0 0.00 0 1050 7 0 0
v_max_id_ord_sup 5457 5457 0 0.00 0 4596 4 0 0
v_max_non_paid_invoice 1720 1720 0 0.00 0 291 2 0 0
v_max_non_paid_realizn 3772 3772 0 0.00 0 669 3 0 0
v_min_id_clo_ord 5419 5419 0 0.00 0 5295 10 0 0
v_min_id_clo_res 1010 1010 0 0.00 0 3204 10 0 0
v_min_id_ord_sup 5457 5457 0 0.00 0 6816 7 0 0
v_min_non_paid_invoice 5899 5899 0 0.00 0 7015 18 0 0
v_min_non_paid_realizn 7102 7102 0 0.00 0 8010 22 0 0
v_our_firm 10170 10170 0 0.00 0 16 1 0 0
v_reserve_write_off 19990 19990 0 0.00 0 3733 7 0 0
x_lock_depdocs_on_canc_invoice 11832 11832 0 0.00 0 10515 106 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 8140 325 0 0
x_make_qstorno_1000_1200 5419 5419 0 0.00 2 32377 1226 0 0
x_make_qstorno_1200_2000 5470 5470 0 0.00 3 116646 3421 0 0
x_make_qstorno_2100_3300 463835 463835 0 0.00 0 36961 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-11-2020 01:28:06 to 19-11-2020 01:28:10.

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
22:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 15344 8192000000 10231578592 10540789760 1284989968 13.559 100 74 148 0 1315209632 3964960 26254704
22:57:37 32132 8192000000 10352482640 10670530560 1388565872 14.493 100 84 168 0 1420517056 5013088 26938096
22:58:22 14971 8192000000 10373934960 10699710464 1426073520 14.827 100 83 166 0 1460705920 6909760 27722640
22:58:53 20862 8192000000 10397727056 10729259008 1459477984 15.121 100 83 166 0 1493779360 7655232 26646144
22:59:25 17472 8192000000 10419251296 10753216512 1482632480 15.324 100 91 183 1 1520232240 7953296 29646464
22:59:50 20982 8192000000 10455805328 10790273024 1503025840 15.503 100 87 174 0 1539819728 8794608 27999280
23:00:25 22520 8192000000 10490858928 10830458880 1538705376 15.812 100 86 172 1 1575359552 9297760 27356416
23:00:56 22796 8192000000 10505250416 10850848768 1559703776 15.994 100 87 174 0 1597014880 10151024 27160080
23:01:28 12956 8192000000 10514561936 10862874624 1572206400 16.101 100 82 164 1 1608130576 10702960 25221216
23:01:52 12519 8192000000 10535434784 10886086656 1591201152 16.264 100 83 166 0 1627810480 11171120 25438208
23:02:13 18948 8192000000 10556151584 10916126720 1618725664 16.499 100 84 167 0 1654380512 11220432 24434416
23:02:42 16336 8192000000 10584551872 10948407296 1635906064 16.645 100 72 144 2 1668600480 11375280 21319136
23:03:07 11027 8192000000 10611772096 10974498816 1663400672 16.878 100 84 167 1 1700023536 11867664 24755200
23:03:25 8340 8192000000 10628903856 10995343360 1680654480 17.023 100 83 164 1 1717021920 12055104 24312336
23:03:43 9006 8192000000 10641810880 11009507328 1697003568 17.160 100 81 161 0 1732569312 11930176 23635568
23:04:00 7970 8192000000 10655492848 11028299776 1715112640 17.311 100 81 162 1 1751409056 12597536 23698880
23:04:16 6445 8192000000 10667963616 11041619968 1726529872 17.407 100 79 156 3 1762195808 12911840 22754096
23:04:30 5501 8192000000 10680741664 11054342144 1736267040 17.488 100 88 176 2 1776128736 13924416 25937280
23:04:42 5719 8192000000 10674756464 11053772800 1740921584 17.526 100 75 150 0 1775537968 13058672 21557712
23:04:55 6256 8192000000 10687834256 11064524800 1750481968 17.606 100 83 165 1 1787580736 13166224 23932544
23:05:08 8443 8192000000 10706247536 11085307904 1761582448 17.697 100 83 166 1 1798442736 13888992 22971296
23:05:24 5385 8192000000 10701629328 11089264640 1769480512 17.763 100 79 158 0 1805813200 14350592 21982096
23:05:36 5084 8192000000 10715578912 11096125440 1774171600 17.801 100 82 161 2 1810308656 13300384 22836672
23:05:49 3956 8192000000 10713996336 11097874432 1779512448 17.845 100 84 168 1 1816726288 13975088 23238752
23:06:00 2637 8192000000 10723701376 11103481856 1784964320 17.890 100 81 162 0 1820752640 12985264 22803056
23:06:10 3072 8192000000 10734048880 11114844160 1792604064 17.953 100 83 160 1 1826998032 11134432 23259536
23:06:20 2937 8192000000 10739426576 11119951872 1799323072 18.008 100 92 185 0 1837486656 11672112 26491472
23:06:29 3681 8192000000 10740042128 11124826112 1805960272 18.063 100 81 162 0 1840855424 11731680 23163472
23:06:46 5089 8192000000 10745933152 11132792832 1811112400 18.105 100 76 152 2 1844592944 12108080 21372464
23:06:59 2489 8192000000 10765041088 11153600512 1832415696 18.279 100 86 171 1 1868575552 12294592 23865264
23:07:09 1834 8192000000 10774782144 11161968640 1835240304 18.302 100 90 181 1 1873454816 13119040 25095472
23:07:17 2477 8192000000 10776172816 11166797824 1840525392 18.345 100 87 174 0 1877788528 12786608 24476528
23:07:26 3178 8192000000 10782812592 11172683776 1844198464 18.375 100 96 193 2 1885974160 13736800 28038896
23:07:36 2544 8192000000 10791062272 11179315200 1848396176 18.409 100 90 180 1 1887424656 12802864 26225616
23:07:45 1751 8192000000 10798616528 11185111040 1853434992 18.450 100 92 184 0 1893076400 13018608 26622800
23:07:53 1848 8192000000 10804174112 11190919168 1857020912 18.479 100 86 172 0 1892922640 12190496 23711232
23:08:01 1752 8192000000 10794942112 11185487872 1860323872 18.506 100 89 176 1 1898464640 13139888 25000880
23:08:10 1615 8192000000 10803827152 11195482112 1864771376 18.542 100 94 189 1 1904132032 12664656 26696000
23:08:18 3037 8192000000 10815627136 11204235264 1867392752 18.563 100 95 187 1 1906682736 13217888 26072096
23:08:28 1484 8192000000 10821904208 11212455936 1872812416 18.607 100 93 185 1 1912870096 13807616 26250064
23:08:36 11761 8192000000 10786305216 11200049152 1869053248 18.577 100 57 114 1 1897610480 11077216 17480016
23:08:54 2832 8192000000 10809726144 11209580544 1878589056 18.654 100 84 166 2 1912018128 10083408 23345664
23:09:03 5323 8192000000 10819023376 11218071552 1877018768 18.641 100 72 145 1 1908285696 10557248 20709680
23:09:16 9567 8192000000 10819841264 11215216640 1880167440 18.666 100 72 144 0 1911971792 11660576 20143776
23:09:32 29477 8192000000 10775194656 11212820480 1881405664 18.676 100 56 111 2 1908178160 11019584 15752912
23:10:11 7382 8192000000 10789800960 11212378112 1877388320 18.644 100 28 55 0 1891473184 5820960 8263904
23:10:25 7084 8192000000 10797727264 11217477632 1881385392 18.676 100 33 67 1 1898448736 7644896 9418448
23:10:40 9816 8192000000 10782356608 11213938688 1877413872 18.644 100 21 42 2 1889724576 6665280 5645424
23:10:56 6105 8192000000 10789693088 11216949248 1878437920 18.652 100 25 50 1 1892101712 6658896 7004896
23:11:09 6880 8192000000 10812366224 11221803008 1886598384 18.718 100 33 65 0 1902055840 7054352 8403104
23:11:22 4547 8192000000 10798529072 11222437888 1883591520 18.694 100 37 74 4 1901820416 7830128 10398768
23:11:34 4320 8192000000 10802424176 11228536832 1884932528 18.705 100 43 86 1 1906110544 9702768 11475248
23:11:46 7514 8192000000 10797206336 11222908928 1882830576 18.688 100 26 52 1 1896713456 6758240 7124640
23:12:00 9342 8192000000 10797060592 11226140672 1886979360 18.721 100 33 67 2 1904170512 7985472 9205680
23:12:16 13148 8192000000 10788732704 11228246016 1888956976 18.737 100 18 36 1 1900531408 6198288 5376144
23:12:36 5333 8192000000 10817116816 11246866432 1892477840 18.766 100 30 60 6 1911454768 11544544 7432384
23:12:47 9992 8192000000 10814663184 11240669184 1897440496 18.806 100 20 41 1 1908929968 6176176 5313296
23:13:08 18766 8192000000 10799580192 11237998592 1895469664 18.790 100 17 34 2 1906450320 6098192 4882464
23:13:36 14712 8192000000 10808402768 11240333312 1903096128 18.851 100 30 62 1 1917056592 5046208 8914256
23:13:57 50796 8192000000 10833946288 11248758784 1907008016 18.883 100 42 81 2 1925284576 5870448 12406112
23:14:54 13835 8192000000 10824811472 11249516544 1888048000 18.730 99 49 95 3 1908213504 6131248 14034256
23:15:18 8913 8192000000 10817828528 11251048448 1900188720 18.828 100 26 53 0 1914098000 6702064 7207216
23:15:33 10069 8192000000 10814723376 11249512448 1886220352 18.715 99 19 38 2 1897445824 5848528 5376944
23:15:50 5498 8192000000 10820467792 11251433472 1900059264 18.827 100 37 74 1 1919584256 9621472 9903520
23:16:02 11958 8192000000 10816080736 11252768768 1903683152 18.856 100 25 50 0 1917502144 6067088 7751904
23:16:25 7847 8192000000 10809361808 11238019072 1869949488 18.584 98 24 48 0 1882354880 5695648 6709744
23:16:40 8652 8192000000 10817283888 11258126336 1883232592 18.691 99 27 54 1 1896944704 6110192 7601920
23:16:55 10697 8192000000 10836902944 11255107584 1886313504 18.716 99 24 44 1 1897317488 4911120 6092864
23:17:12 5957 8192000000 10831393200 11259473920 1903109584 18.851 100 35 70 3 1919011952 6083664 9818704
23:17:27 11493 8192000000 10795336944 11231125504 1853981216 18.454 98 18 36 0 1868631824 9622000 5028608
23:17:46 8344 8192000000 10769002064 11198078976 1821025344 18.186 97 23 46 1 1834170048 6054208 7090496
23:18:04 7979 8192000000 10734657040 11163492352 1783274544 17.876 97 18 36 1 1794829040 5821040 5733456
23:18:21 10818 8192000000 10745954528 11175759872 1805833344 18.062 98 16 32 1 1816219904 6067872 4318688
23:18:40 12097 8192000000 10727122000 11154042880 1743865424 17.551 95 19 38 1 1754370832 5436624 5068784
23:19:03 59991 8192000000 10712760592 11139264512 1726993632 17.410 95 41 80 2 1744903008 5465920 12443456
23:20:11 8014 8192000000 10696555952 11118403584 1776186704 17.818 99 24 48 2 1789250176 5699536 7363936
23:20:28 9507 8192000000 10698768384 11121692672 1743273456 17.546 97 27 54 3 1757017072 5966064 7777552
23:20:45 8785 8192000000 10712942368 11130458112 1752587440 17.623 97 28 56 1 1766010432 5518688 7904304
23:21:02 5291 8192000000 10727655248 11129630720 1764470864 17.721 97 46 94 0 1784722128 6884272 13366992
23:21:17 4728 8192000000 10693603616 11104129024 1719307616 17.346 95 34 68 1 1735449104 6591184 9550304
23:21:28 3102 8192000000 10701689744 11116851200 1783877728 17.881 100 38 75 2 1802443968 7803360 10762880
23:21:37 7133 8192000000 10705918176 11116478464 1775488864 17.812 99 37 72 0 1792167984 6210096 10469024
23:21:52 7744 8192000000 10705421440 11121901568 1775705152 17.814 99 20 40 2 1786730496 5203984 5821360
23:22:06 6460 8192000000 10719208384 11139137536 1793108496 17.957 99 32 61 4 1809211680 6318816 9784368
23:22:20 8331 8192000000 10744875824 11160715264 1823523776 18.206 100 27 54 1 1837331920 5905008 7903136
23:22:38 8948 8192000000 10743395920 11153846272 1793154112 17.958 98 29 58 0 1807437728 6197776 8085840
23:22:53 7422 8192000000 10749458832 11168333824 1828648880 18.248 100 31 63 3 1843585824 5836272 9100672
23:23:07 6997 8192000000 10764303584 11181457408 1837630224 18.322 100 32 64 1 1852673040 5519824 9522992
23:23:21 8261 8192000000 10771595792 11186089984 1845691568 18.387 100 34 67 1 1861754992 5361712 10701712
23:23:36 18611 8192000000 10750366944 11179417600 1826251440 18.229 99 23 46 1 1839394800 6231328 6912032
23:24:02 44638 8192000000 10769201968 11173085184 1839010400 18.333 100 31 61 1 1853430144 5494432 8925312
23:25:06 2587 8192000000 10785831168 11193536512 1852279024 18.441 100 75 151 4 1880456784 6093632 22084128
23:25:19 4066 8192000000 10756071040 11182972928 1845333328 18.384 100 26 51 0 1860001648 6492704 8175616
23:25:31 7700 8192000000 10764115296 11186425856 1847519552 18.402 100 33 66 2 1862944800 5488720 9936528
23:25:46 8346 8192000000 10758867024 11192963072 1853911024 18.454 100 25 50 0 1867297776 6842384 6544368
23:26:01 7320 8192000000 10776825312 11200958464 1860088480 18.504 100 40 80 0 1879058704 8088688 10881536
23:26:21 6878 8192000000 10768706336 11202220032 1861662448 18.517 100 27 53 1 1876030416 6333280 8034688
23:26:36 5760 8192000000 10774481712 11204489216 1863986736 18.536 100 30 61 0 1878679568 5803264 8889568
23:26:53 8123 8192000000 10782661616 11211087872 1868155200 18.569 100 22 44 1 1880682800 5705056 6822544
23:27:10 54458 8192000000 10813068528 11237097472 1884266832 18.700 100 30 61 3 1901831792 9338240 8226720
23:28:19 9836 8192000000 10839693088 11253104640 1899898000 18.825 100 49 94 2 1924617328 11660176 13059152
23:28:36 6081 8192000000 10839464000 11259785216 1909617568 18.904 100 49 96 5 1935805520 11911072 14276880
23:28:49 7316 8192000000 10861114048 11279380480 1919258736 18.981 100 51 100 1 1949497760 15568144 14670880
23:29:16 8462 8192000000 10870321552 11290025984 1929439584 19.062 100 51 102 0 1959939264 16370064 14129616
23:29:36 12707 8192000000 10862658304 11280080896 1915991760 18.955 99 54 106 1 1947946048 16295376 15658912
23:29:56 12019 8192000000 10880180352 11298443264 1938018368 19.131 100 62 123 0 1975089616 19730464 17340784
23:30:16 22109 8192000000 10873519088 11301253120 1940280512 19.149 100 47 98 0 1972066384 18778528 13007344
23:30:53 97574 8192000000 10873103792 11315056640 1940160320 19.148 100 34 67 5 1972111920 21692160 10259440
23:32:37 48001 8192000000 10883557184 11322253312 1944273648 19.181 100 21 42 0 1973292800 22221632 6797520
23:33:40 8492 8192000000 10904456560 11329048576 1957330064 19.285 100 43 87 1 1992060048 21893520 12836464
23:33:58 12409 8192000000 10919330304 11339620352 1960704752 19.312 100 51 101 1 1999480128 24586752 14188624
23:34:18 5116 8192000000 10919289328 11342114816 1967646096 19.367 100 62 124 1 2012519248 26602672 18270480
23:34:31 4139 8192000000 10932412592 11348758528 1971410160 19.397 100 70 138 2 2020548832 28720928 20417744
23:34:43 7327 8192000000 10927033920 11350204416 1971599056 19.398 100 66 130 3 2020203088 29067120 19536912
23:34:58 5628 8192000000 10941500448 11358674944 1977097472 19.442 100 73 145 0 2029132432 29977360 22057600
23:35:16 7542 8192000000 10944589216 11365642240 1982876448 19.487 100 70 140 1 2036012384 31718208 21417728
23:35:32 9296 8192000000 10948417104 11371507712 1986657232 19.517 100 73 146 0 2040941408 32566256 21717920
23:35:59 4957 8192000000 10954107168 11373490176 1991574240 19.556 100 69 135 1 2041351600 29524720 20252640
23:36:14 7992 8192000000 10940188256 11366084608 1969543488 19.382 99 62 123 2 2017116288 29387600 18185200
23:36:35 6458 8192000000 10936038096 11366719488 1980432752 19.468 100 53 107 1 2027840496 31278192 16129552
23:36:54 2669 8192000000 10946527056 11374239744 1985163728 19.506 100 54 108 0 2033502304 31520624 16817952
23:37:07 8518 8192000000 10934188256 11364286464 1965385008 19.349 99 47 92 0 2010738432 31046208 14307216
23:37:23 7707 8192000000 10939429328 11364081664 1963493824 19.334 99 62 124 4 2017082864 34048800 19540240
23:37:40 4298 8192000000 10944670592 11366281216 1964879856 19.345 99 71 142 3 2022672848 36072528 21720464
23:37:53 3268 8192000000 10963636384 11375288320 1981357936 19.475 100 74 144 4 2039659872 36841824 21460112
23:38:03 2690 8192000000 10957613392 11379314688 1985545600 19.509 100 73 144 0 2044109344 36885792 21677952
23:38:15 1393 8192000000 10964791712 11384377344 1989859392 19.543 100 84 164 2 2050888640 36534912 24494336
23:38:23 2351 8192000000 10956256832 11373465600 1967829264 19.368 99 76 152 0 2027689504 37317520 22542720
23:38:32 9251 8192000000 10959690272 11378487296 1983329840 19.491 100 66 132 1 2035212080 32611232 19271008
23:38:50 4550 8192000000 10966161584 11379064832 1988091840 19.529 100 75 150 1 2042893456 32903088 21898528
23:39:02 1963 8192000000 10957605952 11376332800 1975845184 19.432 99 83 166 2 2032370688 32337648 24187856
23:39:11 2924 8192000000 10951544656 11367038976 1978115968 19.450 99 72 145 0 2034783376 34253008 22414400
23:39:21 6795 8192000000 10955795984 11372298240 1975321856 19.428 99 76 151 0 2031673600 34052496 22299248
23:39:35 2170 8192000000 10974052912 11387969536 1996417040 19.594 100 88 172 1 2055371920 33640240 25314640
23:39:44 3751 8192000000 10935425264 11353223168 1932363216 19.086 97 73 143 2 1987804656 32744464 22696976
23:39:56 4879 8192000000 10939239584 11359645696 1968113664 19.370 100 80 160 0 2028614800 36243728 24257408
23:40:08 5825 8192000000 10957346336 11378888704 1984538304 19.501 100 77 152 1 2045401296 37662032 23200960
23:40:21 5564 8192000000 10945579568 11366031360 1974033504 19.417 100 84 167 1 2038608304 38777360 25797440
23:40:33 3637 8192000000 10966360384 11383422976 1982122416 19.481 100 83 166 0 2048761936 40734944 25904576
23:40:44 1324 8192000000 10971117376 11381129216 1969331328 19.380 99 86 171 2 2038197552 41343056 27523168
23:40:53 4150 8192000000 10965744416 11379519488 1976702768 19.439 100 76 151 0 2043354432 42892416 23759248
23:41:05 7735 8192000000 10964090752 11376570368 1972205344 19.403 100 76 149 1 2041294800 46235984 22853472
23:41:21 2567 8192000000 10951399664 11372621824 1969885120 19.385 100 71 142 2 2037773056 46072640 21815296
23:41:32 2041 8192000000 10957947632 11377307648 1975751088 19.431 100 70 140 0 2045753408 47709104 22293216
23:41:42 1209 8192000000 10955053168 11367038976 1952926400 19.250 99 84 168 0 2026979168 47889168 26163600
23:41:51 10671 8192000000 10914013728 11336699904 1920201088 18.988 98 64 125 3 1987621488 47280608 20139792
23:42:08 3621 8192000000 10928288176 11351552000 1952719904 19.248 100 61 121 4 2015414320 43951632 18742784
23:42:21 1551 8192000000 10953114016 11360956416 1964699984 19.343 100 90 174 1 2037611584 45237488 27674112
23:42:29 2510 8192000000 10962979920 11372609536 1976577120 19.438 100 79 158 1 2039705600 39577920 23550560
23:42:39 6066 8192000000 10938060144 11363778560 1964470496 19.342 100 61 122 1 2022704288 39711056 18522736
23:42:52 2281 8192000000 10950844016 11365789696 1965169968 19.347 99 91 182 1 2032144096 39598576 27375552
23:43:01 3929 8192000000 10948949008 11366531072 1960994768 19.314 99 79 158 2 2024975632 39978160 24002704
23:43:24 2094 8192000000 10960687520 11371786240 1958772912 19.296 99 79 158 1 2025921616 43749008 23399696
23:43:34 3944 8192000000 10939381088 11358367744 1940586512 19.151 99 70 138 3 2006043472 44558560 20898400
23:43:50 2339 8192000000 10954737840 11371687936 1967058400 19.362 100 75 148 2 2035369200 45235424 23075376
23:43:59 3125 8192000000 10965667056 11372351488 1979623040 19.462 100 85 168 1 2044233344 38662304 25948000
23:44:09 2850 8192000000 10954761776 11367325696 1953573488 19.255 99 79 159 2 2016214064 38542592 24097984
23:44:22 2990 8192000000 10953102240 11365748736 1970279616 19.388 100 78 156 0 2033521104 39864848 23376640
23:44:32 6499 8192000000 10952463280 11364741120 1967277872 19.364 100 77 152 0 2031408512 40699264 23431376
23:44:45 1538 8192000000 10928659440 11343134720 1951180832 19.236 100 84 169 1 2019116192 42029008 25906352
23:44:56 12663 8192000000 10915987184 11353022464 1935485488 19.111 99 39 78 0 1988439552 40332224 12621840
23:45:16 9568 8192000000 10914907744 11351961600 1916095472 18.956 98 38 76 0 1972598272 44567232 11935568
23:45:34 4466 8192000000 10927383616 11359297536 1952469280 19.246 100 38 74 2 2009536272 44903520 12163472
23:45:46 5636 8192000000 10904278320 11336183808 1936717184 19.121 99 46 92 1 1996868288 45350592 14800512
23:45:59 7233 8192000000 10903578832 11331178496 1891618160 18.759 97 36 72 1 1949699168 45856944 12224064
23:46:16 1902 8192000000 10933982096 11345735680 1949236304 19.220 100 69 139 0 2017374160 45477392 22660464
23:46:27 10207 8192000000 10899869728 11329323008 1916441056 18.958 99 49 98 2 1980170912 48019776 15710080
23:46:46 3744 8192000000 10919290656 11332747264 1927918256 19.050 100 64 127 0 1996231424 48795920 19517248
23:46:57 10568 8192000000 10901361280 11338342400 1928078688 19.052 99 44 88 2 1990209360 46993104 15137568
23:47:18 10850 8192000000 10915547952 11344220160 1928034976 19.051 99 35 66 2 1978605904 39374016 11196912
23:47:39 13946 8192000000 10921370992 11359690752 1955443520 19.270 100 36 72 2 2009181552 41741328 11996704
23:48:01 14325 8192000000 10921544928 11361456128 1939905488 19.146 99 37 74 1 1995577440 43404704 12267248
23:48:25 12101 8192000000 10924918560 11361718272 1948464992 19.214 100 33 66 3 2004007056 43852688 11689376
23:48:47 11213 8192000000 10923174656 11366543360 1940700016 19.152 99 44 85 1 2000623776 45055184 14868576
23:49:06 7987 8192000000 10925142896 11353198592 1943260336 19.173 99 45 91 2 2007028512 48530464 15237712
23:49:27 8360 8192000000 10938147648 11368898560 1938272672 19.133 99 48 96 1 2005606672 51033152 16300848
23:49:43 7883 8192000000 10951917808 11377233920 1958842448 19.297 100 49 98 2 2028109312 52082720 17184144
23:50:06 12659 8192000000 10939230672 11378757632 1945670464 19.192 99 37 74 0 2014511216 55813408 13027344
23:50:37 9143 8192000000 10958500192 11387297792 1957226464 19.284 100 48 95 1 2036058544 62071648 16760432
23:50:53 12233 8192000000 10948993392 11391516672 1964920528 19.345 100 46 90 0 2038650928 58718032 15012368
23:51:19 16559 8192000000 10932074640 11387277312 1972560768 19.406 100 32 64 2 2024684624 41271312 10852544
23:51:44 19605 8192000000 10922776016 11378397184 1944711472 19.184 99 28 56 1 1996481408 42281008 9488928
23:52:10 12877 8192000000 10915557248 11370999808 1953605744 19.255 100 22 43 1 2004265744 42801088 7858912
23:52:30 11588 8192000000 10925190064 11379965952 1957789264 19.288 100 23 46 0 2011301536 45088528 8423744
23:52:49 19297 8192000000 10921359040 11379175424 1954098688 19.259 100 27 55 3 2012040816 48309840 9632288
23:53:29 21117 8192000000 10910609680 11362967552 1930254768 19.069 99 19 37 3 1979516976 42688512 6573696
23:54:00 29474 8192000000 10907076032 11359047680 1908345424 18.893 98 12 24 1 1949735328 37324112 4065792
23:55:02 23334 8192000000 10888386608 11330334720 1913753984 18.937 99 42 84 1 1945848832 18748608 13346240
23:55:32 30945 8192000000 10888748576 11317506048 1918164960 18.972 99 54 110 1 1947348304 11675296 17508048
23:56:46 1690 8192000000 10906943280 11337236480 1951179168 19.236 100 70 140 0 1983229456 12203504 19846784
23:57:10 32517 8192000000 10863469744 11332599808 1931366576 19.078 99 13 26 1 1947377792 12625776 3385440
23:57:58 43300 8192000000 10877020976 11341795328 1939520000 19.143 99 13 27 0 1953800304 10866864 3413440
23:58:48 82110 8192000000 10836053456 11298324480 1877121456 18.642 96 15 30 1 1890582384 9626816 3834112
00:00:29 68062 8192000000 10878035456 11349245952 1912922288 18.930 99 16 32 1 1929967408 12531872 4513248
00:01:43 35233 8192000000 10864641376 11324731392 1895341376 18.789 97 20 40 0 1911392304 10637936 5412992
00:02:37 82823 8192000000 10876462672 11332251648 1927974768 19.051 99 22 44 1 1946832896 13002624 5855504
00:04:07 113128 8192000000 10886081216 11349159936 1948548448 19.215 100 25 50 1 1970387184 14053856 7784880
00:06:06 49232 8192000000 10873499792 11352162304 1938133056 19.132 99 32 65 4 1964851264 17286752 9431456
00:07:08 58197 8192000000 10879740592 11350310912 1939853520 19.146 99 20 39 1 1962865680 17416272 5595888
00:08:28 67402 8192000000 10896078880 11381682176 1957479728 19.286 100 19 38 1 1983427760 20570784 5377248
00:09:53 61573 8192000000 10896126080 11371769856 1956499136 19.278 99 11 22 1 1969392960 9469216 3424608
00:11:04 84649 8192000000 10948237328 11397386240 1960902384 19.313 99 19 38 1 1978724480 12170208 5651888
00:12:42 55420 8192000000 10929942768 11399274496 1977961952 19.449 99 28 56 0 2001060336 15208784 7889600
00:13:49 66276 8192000000 10912469840 11401515008 1978071776 19.449 100 14 28 1 2000893584 18790144 4031664
00:15:08 79786 8192000000 10938231120 11406139392 1987745168 19.526 100 22 43 1 2010087920 16261232 6081520
00:16:35 78442 8192000000 10930877664 11412164608 1982792368 19.487 99 12 24 2 2000637536 14599856 3245312
00:18:02 47782 8192000000 10941526272 11390566400 1991648496 19.557 100 25 51 0 2009165232 10680688 6836048
00:18:56 50438 8192000000 10895015856 11346362368 1897430768 18.806 95 41 82 1 1919531776 10376224 11724784
00:20:34 57810 8192000000 10897353360 11370082304 1947134448 19.204 99 14 28 1 1960756240 9755408 3866384
00:21:44 80929 8192000000 10907772544 11383054336 1981095680 19.473 100 20 40 0 2002372160 14777568 6498912
00:23:27 75345 8192000000 10915835104 11384156160 1950489312 19.230 98 32 64 1 1968287088 9493680 8304096
00:24:52 78917 8192000000 10886410976 11360997376 1889230704 18.740 95 26 52 1 1913646016 17856144 6559168
00:26:26 34330 8192000000 10892370416 11350364160 1928041232 19.051 98 21 42 1 1942221824 7533936 6646656
00:27:10 59678 8192000000 10863844656 11350511616 1948870080 19.217 99 14 28 0 1962448464 9467792 4110592
00:28:35 36859 8192000000 10878984752 11358248960 1962804832 19.328 100 9 18 0 1975279456 9540848 2933776
00:29:21 38311 8192000000 10841157136 11317694464 1908848048 18.897 97 15 30 1 1919992016 7343328 3800640
00:30:06 33128 8192000000 10852119616 11325108224 1918404832 18.974 99 13 26 0 1930062832 8035744 3622256
00:30:47 54855 8192000000 10866902912 11340595200 1931847552 19.082 99 14 28 1 1944408432 8859344 3701536
00:32:00 53235 8192000000 10857056320 11320168448 1864720592 18.542 96 12 24 0 1877866000 10196256 2949152
00:33:04 88597 8192000000 10875309104 11360161792 1931661584 19.080 99 12 22 0 1956280144 22040288 2578272
00:34:44 35172 8192000000 10890434480 11348328448 1904720720 18.864 97 18 36 0 1919812288 10269216 4822352
00:35:26 30915 8192000000 10864876016 11330318336 1885125904 18.706 96 24 48 0 1903004192 11093008 6785280
00:36:09 55686 8192000000 10844994304 11302825984 1829742592 18.257 94 19 38 1 1846821424 11914240 5164592
00:37:19 111121 8192000000 10863153312 11339984896 1886433056 18.717 98 17 34 1 1908545280 17512800 4599424
00:39:27 45499 8192000000 10849380272 11310596096 1867924896 18.567 96 22 44 0 1884328160 9959728 6443536
00:40:23 48938 8192000000 10854511664 11308298240 1865856912 18.551 97 28 56 0 1883992736 10150256 7985568
00:41:18 114790 8192000000 10862416336 11329052672 1804653744 18.052 94 22 43 1 1822836976 12473984 5709248
00:43:56 92851 8192000000 10852545136 11332874240 1869076640 18.577 97 8 16 0 1885760368 14225968 2457760
00:45:35 53081 8192000000 10871381248 11325894656 1912900144 18.930 99 18 36 0 1928565888 10615136 5050608
00:46:39 103573 8192000000 10869231536 11328483328 1926995456 19.043 99 38 75 1 1950205200 12484576 10725168
00:48:52 49399 8192000000 10901155936 11352612864 1951184096 19.236 100 42 85 2 1977703808 14834528 11685184
00:49:49 45014 8192000000 10860774784 11342225408 1927556976 19.047 99 17 34 2 1947293376 15071504 4664896
00:50:41 52002 8192000000 10865703632 11350798336 1938297488 19.133 100 8 16 0 1956146432 15518352 2330592
00:51:39 24135 8192000000 10876681040 11351408640 1948920528 19.218 100 12 24 0 1972009952 19640272 3449152
00:52:32 69356 8192000000 10850864176 11323924480 1900536112 18.831 98 11 22 1 1919332624 15606512 3190000
00:53:54 60709 8192000000 10857312960 11328221184 1879574912 18.662 97 18 36 0 1905489024 20573120 5340992
00:55:40 101319 8192000000 10863968864 11330682880 1918376624 18.974 99 17 34 1 1938588144 15478080 4733440
00:57:31 45783 8192000000 10855904448 11327610880 1905967360 18.874 98 26 53 2 1927576736 14047184 7562192
00:58:27 74371 8192000000 10864039888 11333120000 1901243888 18.836 97 19 38 1 1922425184 15470112 5711184
01:00:17 80389 8192000000 10884597280 11366055936 1946510720 19.199 99 15 30 1 1962563904 11839744 4213440
01:01:47 73192 8192000000 10892688832 11381342208 1973657568 19.414 100 15 30 1 1991532560 13583008 4291984
01:03:06 53183 8192000000 10891057552 11359952896 1951618000 19.239 99 10 20 1 1965293472 10852384 2823088
01:04:09 45158 8192000000 10870763552 11336388608 1904317728 18.861 97 20 40 0 1918818672 9319568 5181376
01:05:05 24992 8192000000 10912633920 11358711808 1946035680 19.195 99 40 79 1 1967712240 9351920 12324640
01:05:38 25024 8192000000 10939932512 11374686208 1976409536 19.436 100 63 127 1 2012224816 18906704 16908576
01:06:23 130633 8192000000 10905816112 11379884032 1927722112 19.049 98 8 16 0 1943087408 12942112 2423184
01:08:40 151780 8192000000 10897438416 11373035520 1960577856 19.311 99 21 42 0 1979467456 13108528 5781072
01:11:18 50410 8192000000 10897944960 11367755776 1969350912 19.380 100 15 30 0 1981555632 8146144 4058576
01:12:20 19930 8192000000 10889872256 11355156480 1939677824 19.144 98 30 60 3 1954439072 7235120 7526128
01:12:47 36364 8192000000 10873231792 11340296192 1904178208 18.860 97 20 40 0 1916233632 6887952 5167472
01:13:48 74126 8192000000 10861280864 11339083776 1907583088 18.887 97 5 10 0 1914890864 5922208 1385568
01:15:08 73105 8192000000 10866070320 11329126400 1839971584 18.341 94 9 18 0 1849500368 6988224 2540560
01:17:35 44112 8192000000 10854224352 11301081088 1883832528 18.696 98 19 36 2 1902754336 13799536 5122272
01:18:29 51818 8192000000 10845225568 11311853568 1913776352 18.937 99 28 55 1 1929059744 7207136 8076256
01:19:50 75079 8192000000 10853168432 11325636608 1871133360 18.593 97 15 30 0 1883976960 8453888 4389712
01:21:28 108657 8192000000 10876709664 11342659584 1858982352 18.495 96 14 29 0 1885572288 22950880 3639056
01:23:28 70952 8192000000 10861536304 11345829888 1930867488 19.074 99 17 34 1 1948799152 13096432 4835232
01:25:57 73132 8192000000 9000114624 9191739392 167145472 1.999 9 5 8 1 173800432 5330896 1324064

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-11-2020 01:28:12 to 19-11-2020 01:28:43.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-11-2020 01:28:44 to 19-11-2020 01:28: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          240115
MON$OLDEST_ACTIVE               240116
MON$OLDEST_SNAPSHOT             240116
MON$NEXT_TRANSACTION            240116
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                       2025504
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:53: 
:54: mscs-test-161.budzdorov.ru    Thu Nov 19 01:27:18 2020
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
--- end of diff output ---

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

19.11.20 01:28: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
2020-11-19 01:28:49 No severe PSQL-related problems occured
19.11.20 01:28:51. End of report.