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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17438152 kB
MemAvailable 31319036 kB
Buffers 0 kB
Cached 14234200 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-15 16:27:15
DTS_END                         2021-01-15 16:27:15.5890
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/36400
TRN_ID                          236066
ATT_ID                          623
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: 9272.73 20228 1112728
customer order: creation 173.49 361 20819
customer order: refuse 14.43 359 1732
order to supplier: creation 46.43 1302 5571
order to supplier: removal 3.56 93779 427
invoice (draft): creation 45.99 3173 5519
invoice (draft): removal 52.62 829 6314
invoice accept: apply 41.68 17952 5001
invoice accept: cancel 47.58 832 5710
customer reserve: creation 3899.26 176 467911
customer reserve: removal 4645.35 56 557442
realization accept: apply 83.40 178 10008
realization accept: cancel 88.58 96 10630
payment from customer: creation 60.38 135 7245
payment from customer: removal 5.95 77 714
payment to supplier: creation 48.20 126 5784
payment to supplier: removal 3.13 118 376
service: total inventory turnovers 5.06 1139 607
service: total monetary turnovers 6.78 53 813
service: aggregate perf. data 0.84 23228 101
service: refresh index statistics 0.03 260593 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-01-2021 16:28:27 to 15-01-2021 16:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4355
TEST_TIME 2 5748
TEST_TIME 3 6275
TEST_TIME 4 6216
TEST_TIME 5 6199
TEST_TIME 6 5929
TEST_TIME 7 5682
TEST_TIME 8 5625
TEST_TIME 9 5844
TEST_TIME 10 5672
TEST_TIME 11 6043
TEST_TIME 12 6373
TEST_TIME 13 6489
TEST_TIME 14 6845
TEST_TIME 15 7026
TEST_TIME 16 7226
TEST_TIME 17 7221
TEST_TIME 18 7230
TEST_TIME 19 7354
TEST_TIME 20 7748
TEST_TIME 21 8496
TEST_TIME 22 9422
TEST_TIME 23 9296
TEST_TIME 24 9756
TEST_TIME 25 9813
TEST_TIME 26 9885
TEST_TIME 27 10687
TEST_TIME 28 10805
TEST_TIME 29 10491
TEST_TIME 30 10447
TEST_TIME 31 10337
TEST_TIME 32 10259
TEST_TIME 33 10174
TEST_TIME 34 10051
TEST_TIME 35 10105
TEST_TIME 36 10033
TEST_TIME 37 9893
TEST_TIME 38 9849
TEST_TIME 39 9723
TEST_TIME 40 9718
TEST_TIME 41 9702
TEST_TIME 42 9640
TEST_TIME 43 9578
TEST_TIME 44 9469
TEST_TIME 45 9413
TEST_TIME 46 9305
TEST_TIME 47 9270
TEST_TIME 48 9271
TEST_TIME 49 9270
TEST_TIME 50 9397
TEST_TIME 51 9364
TEST_TIME 52 9366
TEST_TIME 53 9473
TEST_TIME 54 9550
TEST_TIME 55 9642
TEST_TIME 56 9600
TEST_TIME 57 9694
TEST_TIME 58 9672
TEST_TIME 59 9748
TEST_TIME 60 9852
TEST_TIME 61 9703
TEST_TIME 62 9612
TEST_TIME 63 9565
TEST_TIME 64 9481
TEST_TIME 65 9481
TEST_TIME 66 9489
TEST_TIME 67 9514
TEST_TIME 68 9473
TEST_TIME 69 9451
TEST_TIME 70 9446
TEST_TIME 71 9460
TEST_TIME 72 9543
TEST_TIME 73 9534
TEST_TIME 74 9544
TEST_TIME 75 9656
TEST_TIME 76 9636
TEST_TIME 77 9647
TEST_TIME 78 9713
TEST_TIME 79 9683
TEST_TIME 80 9575
TEST_TIME 81 9527
TEST_TIME 82 9471
TEST_TIME 83 9502
TEST_TIME 84 9518
TEST_TIME 85 9467
TEST_TIME 86 9410
TEST_TIME 87 9425
TEST_TIME 88 9375
TEST_TIME 89 9315
TEST_TIME 90 9369
TEST_TIME 91 9363
TEST_TIME 92 9375
TEST_TIME 93 9406
TEST_TIME 94 9424
TEST_TIME 95 9407
TEST_TIME 96 9440
TEST_TIME 97 9479
TEST_TIME 98 9518
TEST_TIME 99 9486
TEST_TIME 100 9521
TEST_TIME 101 9562
TEST_TIME 102 9585
TEST_TIME 103 9569
TEST_TIME 104 9567
TEST_TIME 105 9493
TEST_TIME 106 9476
TEST_TIME 107 9495
TEST_TIME 108 9451
TEST_TIME 109 9450
TEST_TIME 110 9410
TEST_TIME 111 9368
TEST_TIME 112 9337
TEST_TIME 113 9283
TEST_TIME 114 9343
TEST_TIME 115 9324
TEST_TIME 116 9342
TEST_TIME 117 9326
TEST_TIME 118 9334
TEST_TIME 119 9338
TEST_TIME 120 9276

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-01-2021 16:28:30 to 15-01-2021 16:28:34.

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 1544867 1544867 0 0.00 0 30877 6 0 0
doc_list_biud 1544867 1544867 0 0.00 0 69403 26 0 0
sp_add_invoice_to_stock 5129 5001 128 2.49 35 188354 17952 0 128
sp_cancel_adding_invoice 5710 5710 0 0.00 4 61786 832 0 0
sp_cancel_client_order 1732 1732 0 0.00 4 16950 360 0 0
sp_cancel_customer_reserve 557442 557442 0 0.00 1 58630 56 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 3 10355 78 0 0
sp_cancel_pay_to_supplier 376 376 0 0.00 3 6446 118 0 0
sp_cancel_supplier_invoice 6321 6314 7 0.11 2 69409 830 0 7
sp_cancel_supplier_order 427 427 0 0.00 5 1115616 93780 0 0
sp_cancel_write_off 10630 10630 0 0.00 1 6738 96 0 0
sp_client_order 20819 20819 0 0.00 3 18498 361 0 0
sp_customer_reserve 467911 467911 0 0.00 0 139797 176 0 0
sp_fill_shopping_cart 31894 31894 0 0.00 1 12161 36 0 0
sp_fill_shopping_cart_clo_res 467908 467908 0 0.00 0 22093 14 0 0
sp_get_clo_for_invoice 4994 4994 0 0.00 0 32799 267 0 0
sp_kill_cost_storno 17430 17430 0 0.00 0 8221 51 0 0
sp_kill_qstorno_ret_qs2qd 1132255 1132255 0 0.00 0 69402 31 0 0
sp_kill_qty_storno 597257 597257 0 0.00 0 69403 66 0 0
sp_lock_selected_doc 20885 20885 0 0.00 0 6699 4 0 0
sp_make_cost_storno 28031 28031 0 0.00 0 30538 45 0 0
sp_multiply_rows_for_pdistr 28031 28031 0 0.00 0 30865 27 0 0
sp_multiply_rows_for_qdistr 20819 20819 0 0.00 0 17718 153 0 0
sp_pay_from_customer 7245 7245 0 0.00 4 47552 135 0 0
sp_pay_to_supplier 5784 5784 0 0.00 5 16093 127 0 0
sp_payment_common 13029 13029 0 0.00 1 47520 33 0 0
sp_qd_handle_on_cancel_clo 1732 1732 0 0.00 0 16945 332 0 0
sp_qd_handle_on_invoice_upd_sts 10704 10704 0 0.00 0 30192 319 0 0
sp_qd_handle_on_reserve_upd_sts 10008 10008 0 0.00 0 17846 59 0 0
sp_reserve_write_off 10008 10008 0 0.00 6 30888 178 0 0
sp_supplier_invoice 5519 5519 0 0.00 6 100276 3174 0 0
sp_supplier_order 5571 5571 0 0.00 5 42956 1303 0 0
srv_aggregate_perf_data 101 101 0 0.00 2776 367852 23229 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1911 192782 33911 0 0
srv_find_qd_qs_mism 1064011 1064011 0 0.00 0 18723 5 0 0
srv_make_invnt_saldo 607 607 0 0.00 21 86122 1139 0 0
srv_make_money_saldo 813 813 0 0.00 1 25736 54 0 0
srv_recalc_idx_stat 4 4 0 0.00 144505 425296 260593 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 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 5001 5001 0 0.00 0 12942 155 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 0 2724 107 0 0
t$perf-norm:sp_cancel_client_order 1732 1732 0 0.00 0 6256 19 0 0
t$perf-norm:sp_cancel_customer_reserve 723 723 0 0.00 0 3479 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 714 714 0 0.00 0 1076 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 376 376 0 0.00 0 17831 56 0 0
t$perf-norm:sp_cancel_supplier_invoice 443 443 0 0.00 0 900 10 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 26605 1618 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 2698 8 0 0
t$perf-norm:sp_client_order 20819 20819 0 0.00 0 13215 15 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 2584 8 0 0
t$perf-norm:sp_pay_from_customer 7245 7245 0 0.00 0 8774 11 0 0
t$perf-norm:sp_pay_to_supplier 5784 5784 0 0.00 0 15775 10 0 0
t$perf-norm:sp_reserve_write_off 10008 10008 0 0.00 0 6138 12 0 0
t$perf-norm:sp_supplier_invoice 5519 5519 0 0.00 0 13556 21 0 0
t$perf-norm:sp_supplier_order 5571 5571 0 0.00 0 14789 17 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 518 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 189 5 0 0
t$perf-norm:srv_make_invnt_saldo 607 607 0 0.00 0 905 19 0 0
t$perf-norm:srv_make_money_saldo 813 813 0 0.00 0 620 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10244 9988 256 2.49 0 10480 25 0 256
v_all_customers 38254 38254 0 0.00 0 16 1 0 0
v_all_suppliers 30632 30632 0 0.00 0 21 1 0 0
v_all_wares 41638 41638 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 8515 18 0 0
v_cancel_client_order 3464 3464 0 0.00 0 1780 5 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 10318 14 0 0
v_cancel_customer_reserve 1446 1446 0 0.00 0 10515 28 0 0
v_cancel_payment_to_supplier 752 752 0 0.00 0 4610 20 0 0
v_cancel_supplier_invoice 900 886 14 1.55 0 1130 13 0 14
v_cancel_supplier_order 854 854 0 0.00 0 5472 14 0 0
v_cancel_write_off 2040 2040 0 0.00 0 3465 21 0 0
v_max_id_clo_ord 5571 5571 0 0.00 0 438 1 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 3836 14 0 0
v_max_id_ord_sup 5504 5504 0 0.00 0 6092 6 0 0
v_max_non_paid_invoice 1543 1543 0 0.00 0 1170 3 0 0
v_max_non_paid_realizn 3640 3640 0 0.00 0 4743 6 0 0
v_min_id_clo_ord 5571 5571 0 0.00 0 3855 6 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 4031 12 0 0
v_min_id_ord_sup 5504 5504 0 0.00 0 6616 7 0 0
v_min_non_paid_invoice 5784 5784 0 0.00 0 16075 20 0 0
v_min_non_paid_realizn 7245 7245 0 0.00 0 47488 23 0 0
v_our_firm 10594 10594 0 0.00 0 109 1 0 0
v_reserve_write_off 20016 20016 0 0.00 0 10326 10 0 0
x_lock_depdocs_on_canc_invoice 11581 11581 0 0.00 0 19346 131 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 5016 307 0 0
x_make_qstorno_1000_1200 5571 5571 0 0.00 1 42946 1230 0 0
x_make_qstorno_1200_2000 5519 5519 0 0.00 3 100257 3040 0 0
x_make_qstorno_2100_3300 467911 467911 0 0.00 0 139796 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-01-2021 16:28:35 to 15-01-2021 16:28:39.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:19 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:25 13487 8192000000 10214431872 10517487616 962773568 10.516 76 62 126 0 986356592 2706032 20876992
13:57:46 20947 8192000000 10313387632 10627907584 1364947568 14.282 100 84 168 0 1397106864 4431648 27727648
13:58:17 30369 8192000000 10363532928 10684084224 1425156208 14.818 100 95 190 0 1462135072 6310288 30668576
13:58:57 20129 8192000000 10383598992 10708938752 1437369632 14.926 100 87 174 0 1473303168 7292880 28640656
13:59:29 4861 8192000000 10409071184 10733056000 1465018016 15.170 100 93 186 0 1503547824 8054416 30475392
13:59:45 25016 8192000000 10431357328 10759942144 1471316016 15.225 100 83 166 1 1506700944 8420880 26964048
14:00:21 17003 8192000000 10438804384 10768781312 1494923888 15.432 100 95 190 0 1535685904 9421008 31341008
14:00:46 26454 8192000000 10450306160 10783367168 1498243968 15.461 100 87 173 1 1535845392 9773344 27828080
14:01:34 24082 8192000000 10474632032 10817998848 1530615584 15.742 100 79 158 2 1565122432 9412928 25093920
14:02:08 11302 8192000000 10501175440 10846552064 1557377968 15.974 100 81 162 0 1592146640 9898080 24870592
14:02:29 19158 8192000000 10527738320 10881646592 1582268192 16.188 100 75 150 1 1615686208 10530400 22887616
14:02:56 13701 8192000000 10555350240 10913656832 1607676896 16.405 100 68 136 1 1638563104 10770480 20115728
14:03:18 14982 8192000000 10565898464 10929999872 1630883408 16.602 100 77 154 0 1665750400 11971424 22895568
14:03:40 11725 8192000000 10598694928 10962382848 1652060800 16.782 100 72 143 1 1685465920 12437472 20967648
14:04:00 7556 8192000000 10613453872 10979045376 1671348016 16.945 100 76 152 1 1705810752 12898800 21563936
14:04:15 7778 8192000000 10620299040 10987560960 1684571616 17.056 100 75 150 2 1719174576 12388608 22214352
14:04:30 8985 8192000000 10633276912 11002970112 1699946352 17.185 100 78 156 0 1735182544 12488848 22747344
14:04:46 8258 8192000000 10646933456 11022422016 1714261616 17.304 100 84 168 2 1750698944 12554720 23882608
14:05:06 6914 8192000000 10663931616 11040440320 1726884000 17.410 100 72 143 3 1760302992 12800144 20618848
14:05:21 5106 8192000000 10670510240 11049328640 1739416400 17.514 100 74 148 3 1772778032 12522240 20839392
14:05:33 6502 8192000000 10683780656 11063701504 1746085824 17.569 100 77 154 0 1780485552 12779808 21619920
14:05:46 6882 8192000000 10685157440 11069558784 1755171744 17.644 100 72 144 0 1787828160 12994512 19661904
14:06:01 5423 8192000000 10703757504 11088060416 1766328640 17.737 100 77 151 2 1800016320 11947856 21739824
14:06:13 5858 8192000000 10714522800 11098628096 1784271888 17.885 100 82 164 1 1818747552 11746992 22728672
14:06:25 3640 8192000000 10727716240 11111698432 1789828208 17.930 100 71 142 0 1822856624 12325696 20702720
14:06:35 4615 8192000000 10729614912 11118432256 1800278656 18.016 100 76 152 1 1834497568 12497536 21721376
14:06:46 3752 8192000000 10743981440 11131224064 1809253600 18.090 100 79 155 0 1843211760 12580272 21377888
14:06:57 3416 8192000000 10760750320 11143077888 1816026672 18.145 100 90 181 2 1855369744 13403408 25939664
14:07:07 3694 8192000000 10762294848 11146137600 1821645136 18.191 100 86 170 0 1859865632 13799120 24421376
14:07:17 3482 8192000000 10766448464 11148017664 1827661152 18.240 100 89 178 1 1866863104 14501808 24700144
14:07:27 2867 8192000000 10782329792 11162734592 1830450816 18.263 100 93 187 1 1872064576 15627632 25986128
14:07:36 2072 8192000000 10774398560 11162034176 1833822608 18.290 100 93 186 2 1876233056 15580800 26829648
14:07:45 1893 8192000000 10781541456 11168559104 1838198448 18.326 100 86 171 0 1876788480 13399408 25190624
14:07:53 2137 8192000000 10787911616 11173486592 1847413392 18.401 100 89 178 0 1886108368 13014832 25680144
14:08:02 4514 8192000000 10793103136 11186339840 1846431776 18.393 100 81 162 1 1878621120 9986272 22203072
14:08:13 2216 8192000000 10794524640 11183812608 1854487264 18.459 100 95 192 1 1894147568 12176512 27483792
14:08:21 2084 8192000000 10805118512 11191406592 1857322128 18.482 100 93 186 0 1895834800 11810176 26702496
14:08:29 1643 8192000000 10800526080 11185831936 1860601984 18.508 100 93 185 2 1899610240 12695728 26312528
14:08:37 1034 8192000000 10809173888 11197353984 1863262288 18.530 100 90 178 1 1902043552 12920176 25861088
14:08:44 2153 8192000000 10810228656 11199004672 1865542480 18.548 100 91 183 1 1905363792 13583136 26238176
14:08:53 23631 8192000000 10809152624 11199705088 1867078640 18.561 100 72 145 1 1898908928 11711760 20118528
14:09:23 1996 8192000000 10789915600 11200483328 1865125024 18.545 100 63 126 1 1893920832 10416992 18378816
14:09:32 5557 8192000000 10773763808 11192586240 1863114896 18.529 100 51 102 2 1886906480 8921312 14870272
14:09:46 5996 8192000000 10769962368 11192762368 1861786512 18.518 100 28 56 1 1876229472 6883808 7559152
14:10:00 4313 8192000000 10787007040 11200212992 1868006176 18.568 100 35 71 1 1885380192 7479840 9894176
14:10:11 13711 8192000000 10772626896 11197681664 1866089984 18.553 100 24 48 0 1879661392 6945744 6625664
14:10:32 6459 8192000000 10769473856 11205144576 1868123168 18.569 100 20 40 0 1881098672 7270080 5705424
14:10:46 4665 8192000000 10783548160 11209875456 1873704784 18.614 100 39 78 3 1893059680 7928624 11426272
14:10:57 9080 8192000000 10787105968 11210792960 1874793328 18.623 100 29 56 3 1889899024 7254048 7851648
14:11:13 6388 8192000000 10775239216 11209007104 1874303296 18.619 100 19 38 1 1885986976 6127040 5556640
14:11:28 4647 8192000000 10805276208 11213840384 1878464960 18.653 100 41 81 1 1896799280 6861920 11472400
14:11:39 6234 8192000000 10782885760 11211968512 1879925584 18.665 100 49 99 2 1900258752 5788496 14544672
14:12:01 62844 8192000000 10788982768 11223994368 1878004032 18.649 100 23 46 2 1890349344 5449792 6895520
14:13:10 16438 8192000000 10787397872 11223453696 1878559152 18.653 100 24 48 2 1892053680 6554480 6940048
14:13:34 6163 8192000000 10788132032 11224694784 1879854448 18.664 100 24 48 1 1892987776 6233888 6899440
14:13:47 5206 8192000000 10795361488 11226263552 1885262112 18.708 100 23 47 0 1897490928 5681920 6546896
14:14:01 10678 8192000000 10799936208 11231551488 1883395872 18.693 100 23 46 0 1895000304 4990624 6613808
14:14:18 12068 8192000000 10805173440 11236646912 1888671664 18.735 100 22 44 1 1900755168 6215680 5867824
14:14:40 8842 8192000000 10803893136 11237040128 1890358768 18.749 100 17 34 1 1900545520 5149408 5037344
14:14:57 11978 8192000000 10803297040 11237855232 1889760960 18.744 100 13 26 0 1898948224 5606768 3580496
14:15:21 11954 8192000000 10799732768 11238948864 1891912224 18.761 100 16 32 1 1902150368 5770448 4467696
14:15:40 10331 8192000000 10796832672 11240034304 1891810336 18.760 100 18 36 4 1903375360 6328928 5236096
14:15:56 12519 8192000000 10812384256 11245363200 1897465920 18.806 100 12 24 0 1906330032 5647536 3216576
14:16:17 13621 8192000000 10805474560 11240361984 1863577536 18.532 98 19 38 0 1874226544 5456608 5192400
14:16:38 63781 8192000000 10798594640 11231014912 1858324480 18.490 98 30 60 2 1872125200 4968272 8832448
14:17:51 7406 8192000000 10806826512 11233132544 1886864384 18.721 100 24 48 0 1899631056 6163104 6603568
14:18:05 9496 8192000000 10791829136 11215147008 1841721936 18.355 98 31 62 1 1857285552 7187008 8376608
14:18:21 5965 8192000000 10779039408 11210366976 1856276768 18.473 99 30 60 0 1871632560 6549712 8806080
14:18:35 5956 8192000000 10786807648 11207794688 1849367040 18.417 99 38 71 4 1865142256 6375504 9399712
14:18:48 5636 8192000000 10760674480 11186888704 1809530016 18.092 97 35 70 2 1825988288 6495488 9962784
14:19:02 5922 8192000000 10747038816 11174944768 1821551088 18.190 99 19 38 2 1832665024 5901472 5212464
14:19:16 5333 8192000000 10718025488 11130515456 1763901968 17.717 97 15 30 0 1773638304 4792528 4943808
14:19:29 7147 8192000000 10714898624 11137011712 1790653728 17.937 99 20 40 3 1802220352 5907328 5659296
14:19:43 2983 8192000000 10662232768 11070619648 1734633888 17.474 96 24 48 1 1747290304 5339808 7316608
14:19:56 5672 8192000000 10691481840 11103989760 1689138992 17.094 93 21 42 1 1700600496 5153488 6308016
14:20:09 8321 8192000000 10686374896 11104796672 1717144672 17.328 96 19 38 0 1728749104 5907856 5696576
14:20:26 8321 8192000000 10670159024 11082014720 1696364528 17.155 96 13 27 0 1705348528 4873392 4110608
14:20:43 11332 8192000000 10692369536 11102736384 1715311120 17.313 96 21 42 2 1726530848 4846736 6372992
14:21:04 5868 8192000000 10689585264 11104034816 1724598768 17.391 96 22 43 4 1737432352 5870704 6962880
14:21:17 18382 8192000000 10697825584 11109695488 1730748944 17.442 96 20 37 2 1741417456 4676400 5992112
14:21:41 60143 8192000000 10674792192 11087880192 1693351888 17.129 94 39 77 2 1710597584 5728224 11517472
14:22:47 8936 8192000000 10702729312 11116720128 1739040736 17.511 97 18 36 2 1749372320 5288144 5043440
14:23:03 7822 8192000000 10706947968 11117891584 1771944720 17.783 99 23 45 1 1784071312 5569088 6557504
14:23:17 7824 8192000000 10713903312 11134029824 1788963968 17.923 99 28 54 2 1802942496 6474688 7503840
14:23:32 6081 8192000000 10718951360 11128070144 1794677136 17.970 99 35 70 0 1810948912 5694496 10577280
14:23:47 6818 8192000000 10740690224 11161980928 1822899984 18.201 100 31 62 1 1837750768 5631472 9219312
14:24:01 8687 8192000000 10750935824 11169193984 1831759568 18.274 100 22 42 2 1843432928 5432448 6240912
14:24:22 6658 8192000000 10751857984 11177103360 1839097840 18.333 100 29 61 1 1853675312 5908368 8669104
14:24:35 5993 8192000000 10766236304 11186122752 1843913968 18.373 100 30 60 1 1858492960 5172064 9406928
14:24:50 9829 8192000000 10771091408 11192000512 1849255200 18.416 100 39 76 2 1867148960 5663712 12230048
14:25:08 16569 8192000000 10771305072 11197218816 1854918000 18.462 100 31 60 0 1874029376 10562784 8548592
14:25:31 10640 8192000000 10760360720 11193569280 1854587488 18.459 100 21 42 1 1865381840 4957344 5837008
14:25:50 5822 8192000000 10764726608 11197452288 1856616256 18.476 100 14 28 1 1866460544 6255376 3588912
14:26:06 9713 8192000000 10776300192 11198418944 1859370256 18.498 100 20 38 1 1869565744 5110688 5084800
14:26:26 71309 8192000000 10812653504 11221909504 1876405568 18.636 100 49 99 0 1895945184 5078160 14461456
14:27:43 14675 8192000000 10819419680 11236802560 1890437088 18.749 100 42 82 0 1908200192 6498512 11264592
14:28:07 44827 8192000000 10836121024 11255738368 1903707440 18.856 100 50 100 0 1928477632 11107776 13662416
14:29:02 12616 8192000000 10845528880 11264311296 1911667104 18.920 100 54 106 3 1939301728 12708176 14926448
14:29:21 10059 8192000000 10855311424 11270909952 1917012864 18.963 100 62 121 2 1946306176 12953584 16339728
14:29:46 4722 8192000000 10857239872 11277455360 1925771680 19.033 100 56 111 0 1953924864 11843872 16309312
14:29:57 13862 8192000000 10859747104 11283386368 1928920544 19.058 100 46 93 1 1953932112 11442320 13569248
14:30:21 8722 8192000000 10872049088 11290628096 1934915488 19.106 100 57 114 1 1964457536 12305248 17236800
14:30:37 17955 8192000000 10877200224 11302334464 1940441520 19.150 100 49 98 3 1967596512 13441792 13713200
14:31:02 16535 8192000000 10878338912 11304247296 1944493232 19.183 100 53 107 3 1973098240 13064496 15540512
14:31:26 14114 8192000000 10882592672 11311607808 1949201968 19.220 100 50 98 2 1976258464 12923104 14133392
14:32:01 17765 8192000000 10878437200 11315400704 1950336432 19.229 100 35 70 1 1974683120 13966016 10380672
14:32:41 28813 8192000000 10890720464 11320852480 1960492880 19.310 100 42 83 2 1985123968 12220784 12410304
14:33:19 20543 8192000000 10895267216 11329155072 1964416976 19.341 100 41 80 2 1989865232 13771712 11676544
14:33:57 17091 8192000000 10900161744 11334377472 1965806112 19.352 100 34 67 2 1989260000 13744944 9708944
14:34:22 23497 8192000000 10910469616 11347177472 1970873744 19.392 100 44 88 0 1998330624 14629344 12827536
14:34:53 7217 8192000000 10924393120 11350700032 1979135680 19.458 100 50 100 1 2011196480 17303888 14756912
14:35:07 13825 8192000000 10929651232 11358281728 1983056656 19.489 100 54 106 1 2015852784 17471824 15324304
14:35:34 8960 8192000000 10941213024 11359158272 1987993184 19.528 100 59 117 0 2023570736 19411936 16165616
14:35:53 7242 8192000000 10935231680 11356979200 1971798144 19.400 99 65 130 3 2011029200 20601632 18629424
14:36:11 9481 8192000000 10927424416 11355103232 1982515760 19.485 100 47 92 2 2014153664 17664576 13973328
14:36:40 9297 8192000000 10933018928 11365285888 1976395520 19.436 99 54 108 1 2011466160 19122944 15947696
14:36:58 5060 8192000000 10948032416 11368222720 1986635648 19.517 100 61 120 2 2026412336 22101152 17675536
14:37:12 8185 8192000000 10945745968 11373441024 1993666864 19.573 100 63 123 1 2035773696 23840944 18265888
14:37:30 7086 8192000000 10934446448 11365601280 1987716016 19.526 100 57 113 1 2029549440 24403840 17429584
14:37:45 31785 8192000000 10935026160 11368927232 1966824560 19.360 99 48 96 2 2008991808 27468960 14698288
14:38:24 12325 8192000000 10940416400 11374686208 1994006848 19.575 100 49 99 3 2036325392 26333328 15985216
14:38:44 8916 8192000000 10951267216 11382091776 1995487152 19.587 100 53 105 3 2035565392 23761760 16316480
14:39:01 4307 8192000000 10976486544 11396300800 2015879056 19.748 100 71 143 0 2062988272 25674384 21434832
14:39:13 2016 8192000000 10985054496 11401613312 2016011248 19.749 100 75 150 0 2064843536 26586624 22245664
14:39:22 2058 8192000000 10981774864 11395883008 2013346896 19.728 100 86 169 0 2067269088 28583520 25338672
14:39:31 8086 8192000000 10985622496 11407872000 2015212976 19.743 100 72 144 0 2067793552 30553200 22027376
14:39:47 2405 8192000000 10962942736 11385995264 1996416752 19.594 99 73 145 2 2049503280 30923088 22163440
14:39:58 5317 8192000000 10990156192 11414056960 2017592256 19.761 100 72 144 1 2070185760 30511920 22081584
14:40:12 6232 8192000000 10977669536 11408347136 2001300928 19.633 99 65 130 0 2053020368 31772080 19947360
14:40:26 3818 8192000000 10978306608 11401678848 2006162032 19.671 100 71 139 1 2059285600 31049712 22073856
14:40:38 4596 8192000000 10968204256 11398983680 1992603152 19.564 99 64 128 1 2044101152 31887680 19610320
14:40:52 4443 8192000000 10972585808 11393728512 1999661312 19.620 100 75 147 4 2054210832 32096928 22452592
14:41:03 2383 8192000000 10966403552 11387105280 1988575296 19.533 99 66 132 0 2040646768 31834720 20236752
14:41:20 3889 8192000000 10978480864 11401023488 2009000144 19.694 100 67 134 1 2061966320 32158928 20807248
14:41:31 4651 8192000000 10993284976 11411165184 2016028000 19.749 100 79 156 3 2077455296 37515600 23911696
14:41:42 2779 8192000000 10999206128 11420160000 2020700656 19.786 100 75 150 0 2077832288 34549552 22582080
14:41:52 2426 8192000000 10976866640 11388608512 1995363488 19.586 99 75 148 0 2054018768 35273392 23381888
14:42:01 4232 8192000000 10984303152 11406127104 2015013632 19.741 100 80 160 2 2072095552 32964560 24117360
14:42:12 4087 8192000000 10995946192 11415924736 2022993824 19.804 100 77 155 0 2080182560 33285744 23902992
14:42:24 2252 8192000000 10994104736 11405844480 2007045248 19.678 99 88 174 2 2070009504 35004448 27959808
14:42:34 4775 8192000000 10983053264 11403272192 2008743456 19.692 100 72 145 0 2063585200 32816080 22025664
14:42:51 4411 8192000000 10984760912 11409670144 2011141792 19.711 100 73 145 0 2068445456 34556512 22747152
14:43:02 4373 8192000000 10975668416 11401596928 2006536800 19.674 100 72 142 1 2062908544 34608880 21762864
14:43:14 5133 8192000000 10959987792 11386650624 1975787360 19.431 99 67 134 2 2034758208 37473648 21497200
14:43:27 6974 8192000000 10973674000 11390545920 1992885984 19.567 100 78 151 1 2051230912 34982096 23362832
14:43:41 3101 8192000000 10963722384 11389132800 1981586864 19.477 99 71 142 2 2039406624 35535232 22284528
14:43:51 3294 8192000000 10975338528 11394560000 1984018240 19.496 99 79 154 0 2043921568 36106704 23796624
14:44:03 4195 8192000000 10958371888 11380838400 1982400800 19.484 99 72 144 1 2040399696 35399648 22599248
14:44:18 3158 8192000000 10988516384 11405848576 2010781552 19.708 100 83 166 3 2074128784 37885136 25462096
14:44:29 3917 8192000000 11002899200 11420639232 2018191088 19.766 100 87 172 1 2083031552 37827792 27012672
14:44:41 4894 8192000000 11003099712 11421847552 2014065120 19.734 100 79 159 0 2076046016 37650192 24330704
14:44:54 2376 8192000000 10995654944 11415199744 2011574816 19.714 100 84 168 1 2078436560 40587280 26274464
14:45:04 2308 8192000000 10999293984 11418337280 2012836720 19.724 100 77 154 0 2077421520 40476448 24108352
14:45:15 3020 8192000000 11011532592 11427540992 2023099200 19.804 100 89 178 2 2092971504 42115168 27757136
14:45:28 3493 8192000000 11011781456 11429728256 2021360608 19.791 100 78 155 0 2089791152 44198512 24232032
14:45:41 1910 8192000000 11019073552 11434614784 2024935328 19.819 100 88 172 1 2095450672 44202384 26312960
14:45:51 6098 8192000000 11008110976 11425710080 2020213184 19.782 100 78 156 2 2089979616 45637856 24128576
14:46:05 3606 8192000000 11019935744 11439755264 2021877136 19.795 100 84 169 1 2099670496 50798368 26994992
14:46:16 5085 8192000000 11003543936 11424858112 1993988528 19.575 99 79 157 3 2071519056 51685216 25845312
14:46:29 5571 8192000000 10992238608 11414859776 1972034256 19.402 98 79 158 0 2050733776 53412880 25286640
14:46:45 4142 8192000000 10988697264 11410767872 1989166624 19.537 100 76 152 1 2069434816 55230544 25037648
14:46:58 2304 8192000000 10955850944 11371855872 1934514336 19.103 97 81 158 4 2014990656 55232528 25243792
14:47:08 6342 8192000000 10943604048 11374264320 1970429792 19.389 100 67 135 2 2037165824 44868688 21867344
14:47:24 16044 8192000000 10935497216 11375841280 1959585232 19.303 100 52 102 1 2026051424 47634176 18832016
14:47:53 12738 8192000000 10962200736 11400949760 1979234736 19.459 100 56 111 4 2050199392 51306352 19658304
14:48:15 6881 8192000000 10954839888 11384713216 1952002912 19.242 99 67 131 1 2028460464 54288016 22169536
14:48:31 5060 8192000000 10959330368 11383525376 1958272272 19.292 100 68 136 0 2033335088 52576720 22486096
14:48:43 8232 8192000000 10948235072 11389997056 1964282304 19.340 100 53 106 1 2036743296 54277632 18183360
14:49:27 32546 8192000000 10916625040 11377381376 1965940368 19.353 100 25 50 0 2014864320 40175904 8748048
14:50:08 22354 8192000000 10923409168 11379433472 1948268000 19.213 99 29 58 2 1993092240 35068608 9755632
14:51:09 26373 8192000000 10899009712 11357368320 1949675056 19.224 100 27 54 1 1998944464 39847152 9422256
14:51:49 34270 8192000000 10881072080 11335974912 1916345152 18.958 99 16 32 1 1947937040 26553760 5038128
14:52:29 5477 8192000000 10905376176 11357130752 1938102384 19.132 100 19 38 1 1975415440 30888608 6424448
14:52:56 58173 8192000000 10902280976 11367247872 1931333280 19.078 99 13 26 1 1971536192 35479696 4723216
14:54:01 24070 8192000000 10886245984 11357413376 1927419376 19.046 99 16 32 2 1968797312 35901664 5476272
14:55:17 122406 8192000000 10829209760 11282681856 1776045696 17.817 92 27 53 1 1794836336 10073200 8717440
14:57:28 90613 8192000000 10813569216 11271528448 1799741904 18.012 94 14 28 2 1818567248 14198432 4626912
14:59:36 7096 8192000000 10857514784 11289649152 1910200896 18.908 100 61 123 2 1941711104 14642848 16867360
14:59:49 63157 8192000000 10858825872 11306164224 1906594080 18.879 99 26 52 1 1926267472 12081104 7592288
15:01:00 45633 8192000000 10851315616 11310239744 1896305152 18.797 98 31 62 0 1923731136 18551744 8874240
15:02:18 48783 8192000000 10850375600 11323002880 1896181584 18.796 98 12 24 1 1913843520 14617088 3044848
15:03:22 40316 8192000000 10827585024 11282812928 1890917328 18.753 98 16 32 2 1905083024 9880544 4285152
15:04:09 192781 8192000000 10854509408 11315326976 1851622720 18.435 96 20 40 3 1868398864 11183904 5592240
15:07:40 42255 8192000000 10846075008 11315986432 1916346224 18.958 99 15 30 0 1933117696 11614144 5157328
15:09:20 63415 8192000000 10853898944 11320655872 1938500960 19.135 100 22 45 0 1953651664 9364512 5786192
15:10:34 65750 8192000000 10857423136 11322818560 1900697136 18.832 98 21 42 2 1916204816 9969056 5538624
15:11:46 45264 8192000000 10871182480 11333279744 1948301344 19.213 100 17 34 0 1960227248 7028240 4897664
15:12:49 70084 8192000000 10869007952 11343458304 1952509392 19.246 100 12 23 0 1963315488 7790880 3015216
15:14:15 69211 8192000000 10887463376 11358003200 1961339024 19.317 100 6 12 1 1972543136 9828160 1375952
15:15:34 42547 8192000000 10901318480 11344994304 1909492384 18.903 97 24 48 0 1926946896 10957104 6497408
15:16:47 52965 8192000000 10879175408 11361599488 1962352560 19.325 100 16 32 0 1978812960 11619376 4841024
15:17:46 54057 8192000000 10898398480 11362230272 1931086784 19.076 98 15 30 1 1943377952 8547216 3743952
15:19:05 18210 8192000000 10942872768 11377692672 1985436560 19.508 100 55 110 3 2017148928 15987920 15724448
15:19:34 34005 8192000000 10902365232 11375894528 1966111968 19.355 99 31 62 5 1992798944 17643712 9043264
15:20:20 76666 8192000000 10922631680 11383140352 1990034080 19.544 100 20 39 1 2012440032 16834160 5571792
15:21:47 60352 8192000000 10921826064 11399147520 1989414224 19.539 100 15 30 0 2006041600 12400560 4226816
15:22:57 84445 8192000000 10899633920 11377602560 1893576208 18.775 95 16 32 0 1907079200 9175600 4327392
15:24:28 91844 8192000000 10927706208 11414315008 1986103136 19.513 100 8 16 2 2002033312 13379936 2550240
15:27:10 122194 8192000000 10914670160 11384676352 1949977520 19.226 97 17 35 0 1969778176 15035648 4765008
15:29:57 40504 8192000000 10889582608 11353239552 1955377456 19.269 98 22 44 2 1968127232 5666752 7083024
15:30:45 50591 8192000000 10904047264 11381563392 1974235168 19.419 99 13 26 1 1986355936 8657952 3462816
15:31:42 55284 8192000000 10915157264 11395555328 1991632672 19.557 100 9 18 0 2003934384 9751200 2550512
15:32:56 60905 8192000000 10922463248 11417141248 2000737376 19.629 100 14 28 0 2019555152 15025072 3792704
15:34:30 61756 8192000000 10904031360 11372503040 1932136960 19.084 97 18 36 0 1955063696 17847328 5079408
15:35:43 29995 8192000000 10897297648 11369291776 1944986704 19.187 98 20 40 1 1957041776 6834224 5220848
15:36:19 26924 8192000000 10915759664 11375824896 1971325760 19.396 99 51 101 1 1991323952 6393872 13604320
15:37:01 101767 8192000000 10878580832 11344310272 1785443808 17.894 90 16 32 1 1803328496 13313392 4571296
15:38:50 87313 8192000000 10883715840 11364655104 1876011520 18.633 96 19 38 0 1898504400 16718016 5774864
15:40:42 72872 8192000000 10866464016 11327819776 1845877728 18.389 94 16 32 0 1872161408 21344176 4939504
15:43:05 38198 8192000000 10889671088 11347693568 1916560752 18.959 98 35 70 0 1941342976 15140832 9641392
15:43:58 35841 8192000000 10872414224 11327688704 1880525392 18.669 97 23 46 0 1902900928 16183152 6192384
15:44:42 23929 8192000000 10868938480 11314892800 1893263776 18.772 98 32 63 0 1911937216 9809616 8863824
15:45:12 41079 8192000000 10842504848 11311366144 1853045968 18.447 96 28 56 1 1873900112 12806288 8047856
15:46:00 56105 8192000000 10844565680 11293089792 1864652224 18.541 97 17 34 2 1880452272 11074816 4725232
15:47:26 120165 8192000000 10841812640 11299287040 1791875040 17.947 93 24 48 0 1806795552 7822320 7098192
15:49:36 52655 8192000000 10833096272 11299196928 1896722656 18.800 99 20 40 2 1919640016 16755872 6161488
15:50:42 33806 8192000000 10852900592 11300679680 1910814864 18.913 100 34 68 0 1933472704 11714448 10943392
15:51:27 22306 8192000000 10850196192 11313504256 1922410240 19.006 100 20 38 1 1936041328 7944800 5686288
15:52:06 60711 8192000000 10850278272 11319001088 1891036416 18.754 98 10 20 1 1905941424 12104784 2800224
15:53:13 77697 8192000000 10862238416 11319955456 1883922240 18.697 97 22 44 0 1901165088 10868208 6374640
15:54:43 64901 8192000000 10842140592 11319595008 1890698000 18.751 98 13 26 1 1910432544 15506624 4227920
15:56:08 50447 8192000000 10860659376 11332161536 1931753728 19.081 100 13 25 1 1948538560 13202896 3581936
15:57:11 44317 8192000000 10864370016 11329392640 1902132400 18.843 98 11 22 0 1920112816 14811600 3168816
15:58:03 50608 8192000000 10897644400 11352199168 1952051040 19.243 100 13 26 2 1962578032 7067808 3459184
15:59:19 47152 8192000000 10890409296 11353833472 1951188720 19.236 99 25 50 0 1967265696 8977248 7099728
16:00:12 45243 8192000000 10881575584 11351199744 1944236336 19.181 99 8 16 1 1956119872 9421392 2462144
16:01:06 36705 8192000000 10905447664 11362033664 1950568176 19.231 99 32 65 1 1968624240 8094320 9961744
16:01:52 26593 8192000000 10900995536 11367231488 1952666256 19.248 99 20 41 3 1966762960 8807616 5289088
16:02:28 58354 8192000000 10880789520 11348553728 1908916688 18.898 97 17 33 2 1926417152 12689472 4810992
16:03:33 51741 8192000000 10878306816 11346948096 1930101904 19.068 98 14 28 0 1950144304 16262848 3779552
16:04:36 34344 8192000000 10911908288 11357605888 1968152992 19.371 100 15 30 0 1981984704 10288656 3543056
16:05:19 29584 8192000000 10921368352 11376607232 1976708240 19.439 100 40 80 0 1999584848 11517296 11359312
16:05:56 69642 8192000000 10898929232 11357655040 1921880144 19.002 97 30 60 0 1941875680 11472768 8522768
16:07:13 81722 8192000000 10910845248 11375878144 1960118752 19.307 99 25 50 2 1977978272 10646240 7213280
16:08:41 101026 8192000000 10919815824 11388563456 1960423808 19.309 99 21 42 1 1980166432 14168768 5573856
16:10:29 44035 8192000000 10932855312 11381133312 1964927024 19.345 99 30 60 2 1983522496 10121360 8474112
16:11:19 112724 8192000000 10924009744 11389861888 1983229760 19.490 100 14 28 0 2002785840 15646624 3909456
16:13:24 70511 8192000000 10891594512 11356635136 1891781120 18.760 95 39 78 1 1914428656 12295216 10352320
16:14:46 55062 8192000000 10901716576 11360657408 1958994432 19.298 100 26 53 2 1976246448 9918992 7333024
16:15:50 27970 8192000000 10874109488 11337072640 1909280784 18.901 97 18 36 1 1921346736 7068256 4997696
16:16:26 78591 8192000000 10889736336 11364163584 1952756528 19.248 99 5 10 0 1960392336 5935184 1700624
16:17:58 66114 8192000000 10907117600 11370627072 1939786496 19.145 98 13 26 0 1957138544 13613088 3738960
16:19:57 93808 8192000000 10868489904 11350159360 1930941824 19.074 98 11 22 1 1949620208 15526496 3151888
16:21:41 76630 8192000000 10875124656 11350491136 1925569776 19.031 98 8 16 2 1945448096 17236272 2642048
16:23:05 35119 8192000000 10891639104 11356971008 1945885120 19.194 99 21 42 1 1960585024 8896672 5803232
16:23:48 32170 8192000000 10880090544 11348684800 1939371968 19.142 99 23 46 0 1953706992 7649664 6685360
16:24:26 50767 8192000000 10888877280 11353198592 1910648224 18.912 97 26 52 0 1927611664 8671728 8291712
16:25:54 58396 8192000000 10857558544 11314393088 1809671376 18.093 93 19 38 0 1829161872 13714992 5775504
16:27:00 24115 8192000000 9404329152 9696686080 546127424 6.249 29 4 8 0 557384000 10284144 972432

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-01-2021 16:28:41 to 15-01-2021 16:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 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 15-01-2021 16:29:12 to 15-01-2021 16:29:14.

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          237015
MON$OLDEST_ACTIVE               237298
MON$OLDEST_SNAPSHOT             237298
MON$NEXT_TRANSACTION            237298
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                       2004096
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:946: 
:947: mscs-test-161.budzdorov.ru    Fri Jan 15 16:27:36 2021
:948:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:949: 
--- end of diff output ---

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

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