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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17203684 kB
MemAvailable 31086460 kB
Buffers 0 kB
Cached 14483684 kB
SwapCached 3256 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-02-25 19:27:20
DTS_END                         2021-02-25 19:27:20.7270
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/51048
TRN_ID                          233748
ATT_ID                          621
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: 9132.13 23160 1095856
customer order: creation 168.24 372 20189
customer order: refuse 14.16 327 1699
order to supplier: creation 45.88 1197 5505
order to supplier: removal 3.29 100351 395
invoice (draft): creation 45.43 3042 5451
invoice (draft): removal 52.18 748 6262
invoice accept: apply 40.72 18166 4886
invoice accept: cancel 46.77 724 5612
customer reserve: creation 3779.57 178 453548
customer reserve: removal 4645.54 56 557465
realization accept: apply 81.52 161 9782
realization accept: cancel 80.86 103 9703
payment from customer: creation 59.02 96 7082
payment from customer: removal 5.91 81 709
payment to supplier: creation 48.14 112 5777
payment to supplier: removal 3.32 79 398
service: total inventory turnovers 4.53 1077 544
service: total monetary turnovers 6.28 34 753
service: aggregate perf. data 0.77 22559 92
service: refresh index statistics 0.03 313731 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-02-2021 19:28:33 to 25-02-2021 19:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5434
TEST_TIME 2 6537
TEST_TIME 3 5652
TEST_TIME 4 5672
TEST_TIME 5 5000
TEST_TIME 6 5107
TEST_TIME 7 5570
TEST_TIME 8 5539
TEST_TIME 9 5866
TEST_TIME 10 6169
TEST_TIME 11 6228
TEST_TIME 12 6168
TEST_TIME 13 6185
TEST_TIME 14 6471
TEST_TIME 15 6698
TEST_TIME 16 7808
TEST_TIME 17 8248
TEST_TIME 18 8701
TEST_TIME 19 8671
TEST_TIME 20 8741
TEST_TIME 21 8936
TEST_TIME 22 10071
TEST_TIME 23 10206
TEST_TIME 24 10608
TEST_TIME 25 10747
TEST_TIME 26 10865
TEST_TIME 27 11019
TEST_TIME 28 10722
TEST_TIME 29 10604
TEST_TIME 30 10672
TEST_TIME 31 10666
TEST_TIME 32 10442
TEST_TIME 33 10452
TEST_TIME 34 10294
TEST_TIME 35 10115
TEST_TIME 36 9939
TEST_TIME 37 9825
TEST_TIME 38 9738
TEST_TIME 39 9748
TEST_TIME 40 9643
TEST_TIME 41 9519
TEST_TIME 42 9421
TEST_TIME 43 9385
TEST_TIME 44 9352
TEST_TIME 45 9368
TEST_TIME 46 9276
TEST_TIME 47 9346
TEST_TIME 48 9383
TEST_TIME 49 9298
TEST_TIME 50 9405
TEST_TIME 51 9424
TEST_TIME 52 9393
TEST_TIME 53 9556
TEST_TIME 54 9485
TEST_TIME 55 9540
TEST_TIME 56 9546
TEST_TIME 57 9489
TEST_TIME 58 9472
TEST_TIME 59 9689
TEST_TIME 60 9663
TEST_TIME 61 9688
TEST_TIME 62 9543
TEST_TIME 63 9492
TEST_TIME 64 9464
TEST_TIME 65 9402
TEST_TIME 66 9349
TEST_TIME 67 9313
TEST_TIME 68 9295
TEST_TIME 69 9334
TEST_TIME 70 9357
TEST_TIME 71 9330
TEST_TIME 72 9292
TEST_TIME 73 9368
TEST_TIME 74 9392
TEST_TIME 75 9315
TEST_TIME 76 9405
TEST_TIME 77 9365
TEST_TIME 78 9363
TEST_TIME 79 9507
TEST_TIME 80 9549
TEST_TIME 81 9564
TEST_TIME 82 9453
TEST_TIME 83 9411
TEST_TIME 84 9373
TEST_TIME 85 9335
TEST_TIME 86 9343
TEST_TIME 87 9340
TEST_TIME 88 9276
TEST_TIME 89 9263
TEST_TIME 90 9267
TEST_TIME 91 9216
TEST_TIME 92 9265
TEST_TIME 93 9281
TEST_TIME 94 9299
TEST_TIME 95 9303
TEST_TIME 96 9295
TEST_TIME 97 9270
TEST_TIME 98 9308
TEST_TIME 99 9349
TEST_TIME 100 9298
TEST_TIME 101 9394
TEST_TIME 102 9396
TEST_TIME 103 9400
TEST_TIME 104 9412
TEST_TIME 105 9373
TEST_TIME 106 9446
TEST_TIME 107 9386
TEST_TIME 108 9327
TEST_TIME 109 9294
TEST_TIME 110 9292
TEST_TIME 111 9256
TEST_TIME 112 9217
TEST_TIME 113 9169
TEST_TIME 114 9175
TEST_TIME 115 9153
TEST_TIME 116 9129
TEST_TIME 117 9180
TEST_TIME 118 9181
TEST_TIME 119 9183
TEST_TIME 120 9149

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2021 19:28:36 to 25-02-2021 19:28:39.

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 1515133 1515133 0 0.00 0 14897 6 0 0
doc_list_biud 1515124 1515124 0 0.00 0 84852 26 0 0
sp_add_invoice_to_stock 5008 4886 122 2.43 45 197427 18167 0 122
sp_cancel_adding_invoice 5612 5612 0 0.00 4 70585 725 0 0
sp_cancel_client_order 1699 1699 0 0.00 4 11823 327 0 0
sp_cancel_customer_reserve 557465 557465 0 0.00 1 55065 56 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 2 8822 82 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 6248 80 0 0
sp_cancel_supplier_invoice 6270 6262 8 0.12 2 84864 748 0 8
sp_cancel_supplier_order 395 395 0 0.00 6 1062244 100352 0 0
sp_cancel_write_off 9703 9703 0 0.00 1 19235 104 0 0
sp_client_order 20189 20189 0 0.00 3 38122 372 0 0
sp_customer_reserve 453548 453548 0 0.00 0 51757 178 0 0
sp_fill_shopping_cart 31109 31109 0 0.00 1 18793 38 0 0
sp_fill_shopping_cart_clo_res 453511 453511 0 0.00 0 13855 14 0 0
sp_get_clo_for_invoice 4848 4848 0 0.00 0 30209 368 0 0
sp_kill_cost_storno 16422 16422 0 0.00 0 5745 53 0 0
sp_kill_qstorno_ret_qs2qd 1131290 1131290 0 0.00 0 84848 31 0 0
sp_kill_qty_storno 595764 595764 0 0.00 0 84851 66 0 0
sp_lock_selected_doc 20323 20323 0 0.00 0 10374 5 0 0
sp_make_cost_storno 27488 27488 0 0.00 0 11228 45 0 0
sp_multiply_rows_for_pdistr 27487 27487 0 0.00 0 6943 23 0 0
sp_multiply_rows_for_qdistr 20189 20189 0 0.00 0 29387 171 0 0
sp_pay_from_customer 7082 7082 0 0.00 4 8634 97 0 0
sp_pay_to_supplier 5777 5777 0 0.00 5 18604 113 0 0
sp_payment_common 12857 12857 0 0.00 1 7180 26 0 0
sp_qd_handle_on_cancel_clo 1699 1699 0 0.00 0 11811 299 0 0
sp_qd_handle_on_invoice_upd_sts 10458 10458 0 0.00 0 46229 301 0 0
sp_qd_handle_on_reserve_upd_sts 9782 9782 0 0.00 0 34583 59 0 0
sp_reserve_write_off 9782 9782 0 0.00 6 34607 161 0 0
sp_supplier_invoice 5451 5451 0 0.00 7 94627 3043 0 0
sp_supplier_order 5505 5505 0 0.00 5 53910 1197 0 0
srv_aggregate_perf_data 92 92 0 0.00 2486 314113 22560 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1434 142961 35005 0 0
srv_find_qd_qs_mism 1048491 1048491 0 0.00 0 14896 5 0 0
srv_make_invnt_saldo 544 544 0 0.00 34 42412 1078 0 0
srv_make_money_saldo 753 753 0 0.00 1 9631 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 112900 416408 313731 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4886 4886 0 0.00 0 17099 173 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 7979 147 0 0
t$perf-norm:sp_cancel_client_order 1699 1699 0 0.00 0 877 7 0 0
t$perf-norm:sp_cancel_customer_reserve 643 643 0 0.00 0 873 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 4162 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 1720 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 421 421 0 0.00 0 693 8 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 20048 1653 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 5955 15 0 0
t$perf-norm:sp_client_order 20189 20189 0 0.00 0 13651 17 0 0
t$perf-norm:sp_customer_reserve 985 985 0 0.00 0 3013 7 0 0
t$perf-norm:sp_pay_from_customer 7082 7082 0 0.00 0 6625 11 0 0
t$perf-norm:sp_pay_to_supplier 5777 5777 0 0.00 0 5444 13 0 0
t$perf-norm:sp_reserve_write_off 9782 9782 0 0.00 0 6278 14 0 0
t$perf-norm:sp_supplier_invoice 5451 5451 0 0.00 0 5436 15 0 0
t$perf-norm:sp_supplier_order 5505 5505 0 0.00 0 6592 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 161 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 222 2 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 1159 17 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 575 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9936 9692 244 2.45 0 6661 16 0 244
v_all_customers 37256 37256 0 0.00 0 29 1 0 0
v_all_suppliers 30206 30206 0 0.00 0 298 1 0 0
v_all_wares 40376 40376 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 425 6 0 0
v_cancel_client_order 3398 3398 0 0.00 0 4395 5 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 4253 6 0 0
v_cancel_customer_reserve 1286 1286 0 0.00 0 4257 11 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 1608 8 0 0
v_cancel_supplier_invoice 858 842 16 1.86 0 2119 17 0 16
v_cancel_supplier_order 790 790 0 0.00 0 1310 7 0 0
v_cancel_write_off 2010 2010 0 0.00 0 3004 16 0 0
v_max_id_clo_ord 5488 5488 0 0.00 0 839 1 0 0
v_max_id_clo_res 985 985 0 0.00 0 5953 23 0 0
v_max_id_ord_sup 5427 5427 0 0.00 0 5619 7 0 0
v_max_non_paid_invoice 1588 1588 0 0.00 0 2057 5 0 0
v_max_non_paid_realizn 3653 3653 0 0.00 0 1813 3 0 0
v_min_id_clo_ord 5488 5488 0 0.00 0 4736 6 0 0
v_min_id_clo_res 985 985 0 0.00 0 7381 13 0 0
v_min_id_ord_sup 5427 5427 0 0.00 0 3658 4 0 0
v_min_non_paid_invoice 5776 5776 0 0.00 0 5334 15 0 0
v_min_non_paid_realizn 7081 7081 0 0.00 0 6978 15 0 0
v_our_firm 9975 9975 0 0.00 0 15 1 0 0
v_reserve_write_off 19564 19564 0 0.00 0 3621 5 0 0
x_lock_depdocs_on_canc_invoice 11453 11453 0 0.00 0 15712 107 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 8857 336 0 0
x_make_qstorno_1000_1200 5505 5505 0 0.00 2 53893 1118 0 0
x_make_qstorno_1200_2000 5451 5451 0 0.00 3 88529 2907 0 0
x_make_qstorno_2100_3300 453548 453548 0 0.00 0 51756 162 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 25-02-2021 19:28:40 to 25-02-2021 19:28:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:30 12830 8192000000 10217457664 10522947584 942382000 10.316 76 63 126 0 967250304 2922976 21945328
16:57:52 37661 8192000000 10349750624 10664218624 1381528288 14.430 100 84 169 0 1414185552 4999408 27657856
16:58:43 18629 8192000000 10383187296 10702827520 1438957808 14.940 100 87 174 0 1474036288 6627408 28451072
16:59:13 33589 8192000000 10438660976 10766139392 1471631984 15.228 100 92 184 0 1508814480 7724032 29458464
17:00:06 25697 8192000000 10462930208 10797158400 1516913696 15.623 100 92 184 0 1554285408 8968560 28403152
17:00:41 8594 8192000000 10466867968 10804420608 1525636752 15.699 100 93 187 0 1564853984 9639440 29577792
17:01:02 19709 8192000000 10495753328 10834595840 1543191504 15.851 100 85 170 3 1579578112 9852224 26534384
17:01:30 17946 8192000000 10505898160 10846633984 1559267184 15.990 100 87 174 1 1596706064 10426624 27012256
17:01:57 23055 8192000000 10522140848 10873253888 1577622064 16.148 100 83 166 1 1613472608 10996320 24854224
17:02:28 16268 8192000000 10549513616 10904645632 1603389104 16.368 100 76 152 2 1636715648 10709056 22617488
17:02:57 13762 8192000000 10588350320 10947440640 1644065680 16.714 100 83 166 1 1680009856 11926912 24017264
17:03:18 8405 8192000000 10610270400 10970447872 1664156528 16.884 100 80 160 0 1700046912 12931856 22958528
17:03:35 12458 8192000000 10622057120 10984808448 1681181264 17.027 100 78 154 1 1716751280 13136592 22433424
17:03:55 11620 8192000000 10653413008 11022581760 1699612400 17.182 100 79 156 4 1735226624 13382192 22232032
17:04:14 8636 8192000000 10657121888 11028365312 1712852288 17.293 100 85 168 3 1750558128 13953952 23751888
17:04:32 5891 8192000000 10663710224 11038277632 1723683248 17.383 100 81 162 1 1761278576 14784320 22811008
17:04:46 6569 8192000000 10673097792 11052838912 1735734880 17.483 100 76 152 0 1770345248 13452528 21157840
17:05:00 4389 8192000000 10685001328 11062439936 1746335440 17.571 100 84 165 1 1782926304 13470544 23120320
17:05:14 5624 8192000000 10692548432 11071082496 1755739712 17.649 100 72 146 0 1788771840 12481840 20550288
17:05:26 9913 8192000000 10700195312 11084447744 1768241600 17.752 100 69 138 1 1799900688 11566176 20092912
17:05:43 6252 8192000000 10716751136 11100643328 1779625040 17.846 100 70 141 2 1810949296 12237600 19086656
17:05:56 3062 8192000000 10735610944 11123957760 1800111296 18.015 100 76 152 2 1834395936 12574160 21710480
17:06:06 2448 8192000000 10753835856 11140272128 1811522896 18.108 100 78 157 1 1845786496 12684736 21578864
17:06:15 3466 8192000000 10752353344 11140775936 1817718608 18.159 100 80 160 2 1853118576 13161744 22238224
17:06:25 2851 8192000000 10766117488 11151499264 1824511200 18.215 100 85 169 0 1861302368 12568720 24222448
17:06:36 3965 8192000000 10777654704 11162439680 1831616096 18.273 100 77 152 0 1865725584 12623664 21485824
17:06:46 3136 8192000000 10772057536 11162558464 1839539280 18.337 100 87 169 2 1876013408 12989904 23484224
17:06:56 1832 8192000000 10783736800 11174801408 1843946096 18.373 100 87 173 4 1880374720 12545664 23882960
17:07:05 2008 8192000000 10788375824 11175235584 1847315680 18.400 100 91 180 0 1886976592 13604592 26056320
17:07:13 2748 8192000000 10792220304 11180290048 1850220592 18.424 100 85 170 3 1887106496 13635712 23250192
17:07:23 2007 8192000000 10791702144 11180105728 1854146144 18.456 100 88 174 1 1890734640 12635632 23952864
17:07:31 1693 8192000000 10796387792 11185709056 1856627616 18.476 100 87 170 1 1893534848 12356448 24550784
17:07:39 2712 8192000000 10804463760 11192664064 1858921504 18.495 100 89 176 3 1895933760 13148464 23863792
17:07:48 1944 8192000000 10801570928 11192082432 1863309584 18.530 100 90 180 2 1903328368 14255344 25763440
17:07:57 3251 8192000000 10805188400 11196760064 1863436304 18.531 100 84 166 1 1901797552 14337824 24023424
17:08:06 1977 8192000000 10806323872 11201191936 1865546976 18.548 100 92 186 1 1905712512 14388608 25776928
17:08:15 2587 8192000000 10820638368 11208163328 1870058096 18.585 100 94 188 1 1909388736 12538608 26792032
17:08:24 1553 8192000000 10809650720 11202899968 1876324592 18.635 100 83 164 2 1912680880 13122768 23233520
17:08:32 1612 8192000000 10817433840 11205885952 1877057456 18.641 100 92 184 3 1916433072 13775856 25599760
17:08:39 36155 8192000000 10791999424 11206639616 1876056416 18.633 100 63 125 0 1901984112 8346688 17581008
17:09:22 1283 8192000000 10819680480 11214610432 1881587088 18.678 100 89 176 1 1917767632 10477600 25702944
17:09:32 1529 8192000000 10829780448 11224662016 1884393808 18.701 100 92 185 0 1923685024 12446224 26844992
17:09:40 5125 8192000000 10793983440 11211386880 1873083280 18.609 100 42 85 0 1895412416 10618272 11710864
17:09:54 5209 8192000000 10784693280 11210788864 1875553504 18.629 100 26 52 0 1890444192 7488976 7401712
17:10:08 5585 8192000000 10796759712 11219152896 1880873936 18.672 100 38 76 2 1899032016 7730992 10427088
17:10:21 8212 8192000000 10798635264 11220393984 1880181120 18.667 100 31 62 2 1899869968 10962560 8726288
17:10:36 6791 8192000000 10789967712 11217408000 1880052912 18.666 100 21 42 0 1892336240 6088080 6195248
17:10:50 8068 8192000000 10788058480 11220144128 1884530160 18.702 100 23 44 3 1897087424 6254272 6302992
17:11:12 6864 8192000000 10805471536 11229962240 1890721536 18.752 100 29 57 1 1905596640 6976624 7898480
17:11:25 5197 8192000000 10805856128 11232034816 1892681264 18.767 100 33 67 1 1908052064 6478496 8892304
17:11:37 17710 8192000000 10805768688 11229700096 1893849008 18.777 100 38 77 1 1911736800 7109200 10778592
17:12:04 54851 8192000000 10834908768 11248803840 1901322912 18.837 100 47 96 1 1920553456 5288096 13942448
17:13:05 12726 8192000000 10809020688 11242463232 1899700928 18.824 100 20 40 0 1911688768 6441312 5546528
17:13:26 7965 8192000000 10811623168 11245596672 1899637344 18.823 100 24 49 1 1913003664 6133296 7233024
17:13:40 6451 8192000000 10822629232 11251380224 1903312080 18.853 100 28 56 1 1918042000 7127248 7602672
17:13:53 5438 8192000000 10812160480 11249381376 1903702048 18.856 100 30 58 2 1918433952 6563312 8168592
17:14:04 5567 8192000000 10816750320 11249430528 1903021136 18.851 100 25 50 0 1921029296 10831696 7176464
17:14:18 9398 8192000000 10829155024 11254964224 1903799728 18.857 100 22 45 0 1920729264 10383552 6545984
17:14:35 6159 8192000000 10817319040 11255119872 1906970896 18.882 100 31 62 2 1922966992 6874592 9121504
17:14:47 7295 8192000000 10824435744 11250089984 1885396192 18.709 99 22 44 1 1897277232 5508784 6372256
17:15:02 8022 8192000000 10829559872 11262709760 1905980480 18.874 100 31 62 1 1929701696 14672240 9048976
17:15:18 6647 8192000000 10822676656 11258540032 1911673520 18.920 100 29 58 2 1926383936 6478944 8231472
17:15:34 14183 8192000000 10820302528 11255042048 1888460896 18.733 99 21 43 1 1899392560 5215392 5716272
17:15:54 8229 8192000000 10826839584 11260682240 1908139776 18.892 100 16 32 2 1918319904 5779840 4400288
17:16:10 5148 8192000000 10832206064 11254444032 1889721296 18.744 99 28 55 0 1903148752 5448544 7978912
17:16:22 15035 8192000000 10816583040 11241918464 1867372976 18.563 98 23 47 2 1880174112 5882320 6918816
17:16:43 37933 8192000000 10789413568 11228491776 1881996176 18.681 99 18 36 0 1891848976 5302976 4549824
17:17:39 7631 8192000000 10792355392 11227201536 1870419808 18.588 99 36 72 0 1887616096 6748864 10447424
17:18:00 7484 8192000000 10786109024 11219271680 1869109632 18.577 99 26 50 4 1886277312 10618224 6549456
17:18:17 5660 8192000000 10783925776 11214008320 1845081440 18.382 98 24 47 2 1858199728 5551200 7567088
17:18:30 5342 8192000000 10787039552 11217854464 1872879696 18.608 100 31 62 4 1887701008 5865520 8955792
17:18:42 4340 8192000000 10773733952 11199303680 1858031088 18.487 100 33 66 3 1874254912 6189984 10033840
17:18:53 4446 8192000000 10770677008 11196366848 1840069584 18.341 99 30 59 1 1855176448 6373728 8733136
17:19:04 5345 8192000000 10755163264 11176185856 1814068768 18.129 98 31 62 2 1829007392 6026112 8912512
17:19:19 5217 8192000000 10748175152 11171700736 1795389968 17.976 97 17 34 0 1806089760 5863904 4835888
17:19:32 6159 8192000000 10743462880 11168239616 1802173504 18.032 98 19 38 0 1813467744 5977312 5316928
17:19:46 5437 8192000000 10739836000 11156615168 1764256768 17.720 96 34 68 0 1780432128 5898000 10277360
17:19:59 6244 8192000000 10685398224 11103207424 1693473808 17.130 94 26 52 4 1707150736 5937136 7739792
17:20:12 7495 8192000000 10680090592 11087593472 1753399264 17.630 98 30 61 2 1769145408 5787600 9958544
17:20:27 9357 8192000000 10688407424 11097665536 1700866432 17.192 95 27 52 0 1713930672 5578768 7485472
17:20:44 4251 8192000000 10696934816 11091218432 1729557728 17.432 97 41 78 4 1751688768 9648192 12482848
17:20:55 8489 8192000000 10701507088 11111858176 1744620128 17.557 98 19 38 1 1755905856 5938224 5347504
17:21:10 4849 8192000000 10714727824 11132104704 1782181088 17.867 99 32 64 0 1799393264 7566288 9645888
17:21:21 72779 8192000000 10692443792 11114168320 1676174464 16.985 93 24 46 2 1687650032 4826448 6649120
17:22:42 11367 8192000000 10732229536 11129688064 1749131360 17.594 97 33 64 1 1763453040 4705488 9616192
17:23:00 5645 8192000000 10728295088 11144732672 1804797792 18.053 100 37 74 2 1822462848 7410624 10254432
17:23:12 9366 8192000000 10739557216 11158241280 1820588192 18.182 100 30 60 0 1835817520 6001072 9228256
17:23:28 9172 8192000000 10743403760 11165413376 1824720800 18.216 100 26 52 0 1837807632 6054000 7032832
17:23:44 6329 8192000000 10743014656 11166515200 1827522992 18.239 100 32 64 0 1844097040 7426400 9147648
17:23:59 7233 8192000000 10754127328 11168960512 1817211072 18.155 99 37 74 3 1834166032 5385760 11569200
17:24:12 6565 8192000000 10754245280 11176247296 1833270272 18.286 100 22 46 1 1846377296 6090528 7016496
17:24:25 9244 8192000000 10755053584 11180961792 1838575312 18.329 100 21 42 0 1855104976 9960512 6569152
17:24:42 9807 8192000000 10759427520 11187728384 1846459776 18.393 100 29 58 2 1860659088 6176592 8022720
17:24:58 8729 8192000000 10767924224 11194388480 1852005920 18.438 100 26 52 1 1865876816 7040880 6830016
17:25:14 6190 8192000000 10782781648 11202600960 1857787504 18.485 100 30 60 0 1872947680 5921632 9238544
17:25:26 9794 8192000000 10770847168 11195588608 1860179936 18.505 100 30 60 1 1874717216 5189872 9347408
17:25:42 12212 8192000000 10778177488 11206889472 1863684752 18.533 100 24 46 2 1876372224 5621408 7066064
17:26:06 49278 8192000000 10795093904 11208540160 1868958848 18.576 100 50 99 2 1890358304 8068448 13331008
17:27:25 35476 8192000000 10814833760 11233292288 1891296608 18.756 100 52 104 1 1914745488 8679344 14769536
17:28:08 16559 8192000000 10835825680 11249307648 1899629488 18.823 100 54 108 0 1927207568 12020560 15557520
17:28:36 9794 8192000000 10842411920 11259465728 1906354800 18.877 100 56 110 3 1936190368 14698832 15136736
17:28:53 2381 8192000000 10870513392 11276869632 1915148496 18.948 100 75 149 1 1951673360 15318544 21206320
17:29:04 13760 8192000000 10858949680 11275431936 1919563072 18.983 100 61 122 0 1952778592 16195440 17020080
17:29:26 6816 8192000000 10865778096 11284529152 1921261184 18.997 100 54 107 0 1957192160 20174464 15756512
17:29:41 14483 8192000000 10861989696 11287875584 1925486560 19.031 100 51 99 1 1956044032 16560160 13997312
17:30:02 22260 8192000000 10870538496 11295723520 1931862896 19.082 100 51 102 2 1963855312 17279616 14712800
17:30:34 28904 8192000000 10880071504 11307487232 1941799120 19.161 100 51 102 1 1974420096 18355024 14265952
17:31:22 41781 8192000000 10886546752 11328765952 1943432240 19.174 100 33 66 0 1978892560 25804368 9655952
17:32:26 16267 8192000000 10892578752 11327442944 1954309488 19.261 100 31 62 1 1986243168 22039344 9894336
17:32:50 16456 8192000000 10906064016 11336478720 1961114656 19.315 100 47 94 2 1998676576 23537248 14024672
17:33:18 12338 8192000000 10909895456 11342467072 1967583968 19.366 100 56 109 3 2010575440 27159216 15832256
17:33:39 4875 8192000000 10924006544 11348557824 1972051040 19.402 100 55 107 0 2014304000 26543408 15709552
17:33:51 4800 8192000000 10925629088 11352276992 1976372368 19.436 100 52 104 2 2019146944 27286800 15487776
17:34:05 5780 8192000000 10932853392 11360264192 1978401888 19.452 100 59 118 2 2024670448 28489216 17779344
17:34:24 11023 8192000000 10929420080 11362856960 1978190864 19.450 100 50 98 2 2022034080 28930992 14912224
17:34:46 13424 8192000000 10935179728 11370438656 1984038304 19.497 100 42 80 2 2030055824 33841744 12175776
17:35:07 5700 8192000000 10945580384 11379396608 1991026624 19.552 100 53 107 2 2034090512 27401696 15662192
17:35:19 7086 8192000000 10955835088 11387461632 1997253632 19.601 100 57 115 2 2047494416 33473328 16767456
17:35:35 3840 8192000000 10969128240 11394195456 2004449888 19.658 100 68 136 0 2055641808 31186896 20005024
17:35:50 1817 8192000000 10970329360 11392364544 2001918848 19.638 100 74 146 0 2056403184 32368928 22115408
17:35:59 1866 8192000000 10966032240 11390910464 2001390480 19.634 100 67 134 0 2054177120 32201024 20585616
17:36:12 12331 8192000000 10950720112 11378814976 1971044304 19.394 99 56 107 5 2021255200 34010192 16200704
17:36:33 6354 8192000000 10938686992 11366912000 1952538176 19.247 98 61 122 0 2005664752 35518560 17608016
17:36:48 3862 8192000000 10946920400 11377156096 1984096288 19.497 100 65 130 3 2038739392 34945520 19697584
17:36:59 2166 8192000000 10969216032 11393081344 1995556240 19.588 100 79 156 1 2055105824 35799424 23750160
17:37:09 7485 8192000000 10967875040 11395776512 1998005472 19.607 100 71 142 1 2055173600 36195088 20973040
17:37:24 13954 8192000000 10980818608 11397693440 2007226048 19.680 100 75 140 1 2059699872 32703024 19770800
17:37:45 10394 8192000000 10983818880 11408764928 2009572896 19.698 100 71 140 0 2063915488 33736928 20605664
17:38:05 12504 8192000000 10992141616 11419484160 2019881776 19.779 100 70 140 0 2078884160 37666288 21336096
17:38:25 4158 8192000000 10978827072 11411660800 2017297392 19.759 100 69 138 1 2074768480 35793536 21677552
17:38:39 6101 8192000000 10986122112 11416125440 2017240128 19.758 100 62 123 1 2071352432 34732176 19380128
17:39:02 10259 8192000000 10991001056 11425226752 2024603888 19.816 100 59 114 0 2078363984 36339152 17420944
17:39:25 7229 8192000000 10993440880 11425050624 2007463904 19.682 99 61 123 2 2063474368 37277136 18733328
17:39:43 4137 8192000000 10998998016 11424010240 2016606128 19.753 100 73 146 1 2078713712 39373952 22733632
17:39:55 5005 8192000000 10995026464 11422310400 2005583456 19.667 99 74 148 2 2069078688 40401392 23093840
17:40:15 2629 8192000000 11001725232 11423465472 1997911840 19.606 99 83 166 2 2067387744 43579760 25896144
17:40:25 4370 8192000000 10993514096 11413442560 2007611616 19.683 100 78 156 3 2075524912 43948000 23965296
17:40:36 1432 8192000000 10990618384 11410194432 2003539056 19.651 100 84 168 0 2073745776 44603568 25603152
17:40:47 2377 8192000000 10994157024 11413286912 2005194160 19.664 100 80 161 1 2076384448 46620192 24570096
17:40:58 9101 8192000000 10993565856 11421786112 2008462192 19.689 100 70 140 1 2079597712 48903824 22231696
17:41:15 2649 8192000000 10994152800 11422871552 2007676032 19.683 100 78 158 2 2081384848 48441472 25267344
17:41:24 13076 8192000000 11000973392 11430522880 2012545456 19.722 100 70 137 4 2083793616 49794928 21453232
17:41:45 3359 8192000000 10982128192 11407609856 1995980672 19.591 99 84 163 3 2070008000 48035456 25991872
17:41:57 5562 8192000000 11006089616 11432087552 2010146832 19.703 100 67 134 0 2080744736 49423952 21173952
17:42:12 4660 8192000000 10998684128 11427868672 1995845952 19.590 99 66 132 0 2068211216 51416128 20949136
17:42:23 2133 8192000000 11033826784 11449147392 2022307456 19.798 100 86 169 2 2104819152 55401792 27109904
17:42:33 3969 8192000000 11023130128 11449290752 2023959952 19.811 100 72 144 0 2103870288 57051088 22859248
17:42:44 4260 8192000000 11021452160 11455684608 2026467840 19.831 100 67 134 1 2107642304 59490592 21683872
17:42:54 4054 8192000000 11008774080 11445260288 2021042256 19.788 100 62 124 1 2096038128 54461856 20534016
17:43:08 4358 8192000000 11018010992 11450679296 2029265584 19.853 100 71 142 1 2100835616 49475920 22094112
17:43:19 4824 8192000000 11020031792 11454791680 2030319440 19.861 100 78 153 1 2106179744 51498880 24361424
17:43:31 2407 8192000000 11022940592 11452198912 2037497072 19.917 100 89 179 0 2112909168 47271184 28140912
17:43:42 2175 8192000000 11023265472 11452043264 2033314656 19.885 100 68 136 1 2102265200 47610288 21340256
17:44:01 12532 8192000000 10986709472 11443834880 2012882032 19.724 99 42 84 1 2067714288 41136608 13695648
17:44:31 14841 8192000000 10992955440 11447910400 2024427968 19.815 100 33 66 1 2080546752 44398176 11720608
17:45:21 23126 8192000000 10974926768 11429416960 1988939968 19.535 98 31 62 1 2036088432 36480176 10668288
17:45:51 10095 8192000000 10969518112 11428257792 2011660416 19.715 100 27 54 3 2057029360 36169488 9199456
17:46:12 13886 8192000000 10982351664 11431370752 2003488816 19.650 99 44 85 4 2060071888 42553840 14029232
17:46:32 14921 8192000000 10977159152 11433385984 2009205696 19.695 100 31 60 1 2060756272 41760048 9790528
17:46:54 17929 8192000000 10971121664 11427143680 1990095328 19.545 99 31 62 3 2046586496 45328192 11162976
17:47:18 24338 8192000000 10948331104 11402276864 1951521904 19.239 98 31 62 1 2009874976 47288848 11064224
17:47:58 16215 8192000000 10944371920 11393466368 1954564544 19.263 99 26 52 1 2014565248 50285744 9714960
17:48:27 9017 8192000000 10957700928 11394437120 1939542416 19.143 98 57 114 0 2014342240 55975568 18824256
17:48:43 4583 8192000000 10921982096 11365691392 1935020976 19.107 99 42 84 0 2004955472 53729760 16204736
17:48:55 11679 8192000000 10918805216 11355860992 1915880240 18.954 99 41 82 2 1987786224 58130208 13775776
17:49:16 28418 8192000000 10921062576 11388567552 1927781104 19.049 99 35 70 2 1992364096 52715296 11867696
17:49:57 16629 8192000000 10935825152 11381346304 1963244080 19.332 100 24 47 1 2010937168 39562304 8130784
17:50:25 4715 8192000000 10931537152 11371917312 1941866528 19.162 99 41 82 1 1996509920 41182368 13461024
17:50:36 18074 8192000000 10905660208 11360305152 1915497904 18.951 98 25 50 1 1967479840 43438176 8543760
17:51:01 21997 8192000000 10886483728 11347496960 1885652928 18.711 97 24 48 2 1927982288 34513968 7815392
17:51:47 26888 8192000000 10852843072 11319300096 1886188592 18.715 98 16 32 1 1922865536 31507120 5169824
17:52:20 34441 8192000000 10869128320 11336531968 1901038384 18.835 99 18 36 0 1942506736 35541664 5926688
17:53:07 29900 8192000000 10878496096 11340263424 1910433296 18.910 99 16 32 0 1949104624 33280656 5390672
17:53:44 38217 8192000000 10879469008 11336925184 1877703328 18.647 97 18 36 2 1916116000 32310384 6102288
17:54:38 53647 8192000000 10863538112 11311816704 1884736160 18.703 97 31 62 1 1904956000 11246128 8973712
17:55:41 33977 8192000000 10876885152 11326189568 1919858784 18.986 99 47 91 1 1950969840 18397984 12713072
17:56:38 55556 8192000000 10872360208 11329441792 1886610688 18.718 97 35 70 1 1913532224 16325216 10596320
17:57:40 34126 8192000000 10856671712 11326459904 1899510288 18.822 98 8 16 0 1918063248 16219936 2333024
17:58:21 40861 8192000000 10846623632 11311910912 1900584976 18.831 98 7 13 0 1913323040 11278400 1459664
17:59:21 53872 8192000000 10853154784 11318833152 1924146496 19.020 100 10 20 0 1934384256 8013936 2223824
18:00:22 77221 8192000000 10835036000 11293155328 1861594640 18.516 96 11 20 2 1871569712 7388192 2586880
18:01:53 131577 8192000000 10846460560 11304751104 1877199440 18.642 97 18 36 1 1892995088 10927824 4867824
18:04:12 28021 8192000000 10848292416 11294924800 1888997984 18.738 98 29 58 1 1904472320 7160192 8314144
18:04:50 52045 8192000000 10840264192 11299602432 1905823024 18.873 99 25 45 3 1918282560 6511968 5947568
18:05:57 43842 8192000000 10883134320 11336450048 1946984144 19.202 100 28 57 0 1962859440 8261328 7613968
18:07:08 80375 8192000000 10879807600 11321917440 1899523344 18.822 97 34 68 1 1917977056 8469888 9983824
18:08:35 38259 8192000000 10889133552 11346116608 1958164896 19.291 100 30 60 2 1980164800 12726720 9273184
18:09:27 91218 8192000000 10900603136 11369967616 1969242016 19.379 100 18 36 0 1990197344 15634848 5320480
18:11:07 50849 8192000000 10883238416 11352170496 1956672752 19.280 99 19 38 0 1979963232 17290800 5999680
18:12:22 40929 8192000000 10901856672 11376263168 1978714064 19.455 100 19 37 0 2002315920 17795872 5805984
18:13:40 74060 8192000000 10893354672 11380428800 1976409184 19.436 100 20 40 0 1997454224 14994544 6050496
18:15:01 65690 8192000000 10904411376 11365978112 1937235248 19.125 98 6 12 0 1950557024 11430176 1891600
18:16:14 38291 8192000000 10924304128 11381620736 1986587264 19.517 100 16 33 1 1999294352 8187536 4519552
18:17:01 37514 8192000000 10907289232 11387138048 1979475664 19.461 99 32 64 0 2002306816 13654336 9176816
18:18:00 42029 8192000000 10924872672 11391721472 1987700880 19.526 100 25 50 0 2009848368 15631072 6516416
18:18:49 71793 8192000000 10932897488 11386056704 1953719488 19.256 98 31 62 0 1971538384 9707264 8111632
18:20:16 83987 8192000000 10915305760 11380326400 1950285152 19.229 98 11 22 0 1965481872 12262624 2934096
18:21:46 22209 8192000000 10943240928 11382218752 1957029040 19.282 98 47 95 2 1977693712 7679264 12985408
18:22:15 50694 8192000000 10925327792 11390504960 1977410064 19.444 99 26 52 0 1997595920 12961696 7224160
18:23:17 45605 8192000000 10926043232 11386789888 1972983744 19.409 99 26 52 2 1994702896 14713024 7006128
18:24:09 33696 8192000000 10927737744 11379777536 1990641680 19.549 100 46 91 0 2012215872 9341568 12232624
18:24:52 23876 8192000000 10947570448 11403030528 2003894256 19.653 100 38 75 2 2027636832 13182256 10560320
18:25:27 35334 8192000000 10934290496 11404156928 1986547728 19.517 99 43 86 0 2017673392 18507040 12618624
18:26:31 92528 8192000000 10918184144 11390627840 1937904800 19.130 97 8 16 0 1954262496 14474288 1883408
18:28:10 138369 8192000000 10911154416 11372535808 1907583920 18.887 95 23 46 2 1923139104 9185264 6369920
18:33:23 94934 8192000000 10915017760 11382538240 1931440272 19.078 97 14 28 2 1947322288 11010032 4871984
18:35:06 32863 8192000000 10895358064 11354234880 1903109696 18.851 95 37 74 0 1922114528 8639824 10365008
18:35:47 39453 8192000000 10890923360 11347369984 1919021072 18.979 98 28 57 2 1941194320 13974624 8198624
18:36:33 39244 8192000000 10859572288 11337154560 1893068592 18.771 97 22 44 0 1910898112 11664224 6165296
18:37:18 79403 8192000000 10855725328 11323273216 1849379584 18.417 95 12 24 0 1862766144 9873296 3513264
18:38:51 31404 8192000000 10877310384 11329257472 1896164944 18.795 97 43 86 1 1917009728 9003008 11841776
18:39:29 66208 8192000000 10865917296 11338977280 1922642496 19.008 99 21 42 1 1938807136 10222640 5942000
18:40:47 97982 8192000000 10883010464 11345842176 1871542768 18.597 96 9 18 0 1888485648 14612960 2329920
18:42:49 48937 8192000000 10860708224 11310120960 1836142880 18.309 94 26 53 0 1854948016 11399392 7405744
18:43:45 79776 8192000000 10826206048 11276869632 1793514768 17.961 93 17 34 2 1810537856 12453152 4569936
18:45:41 62672 8192000000 10847213056 11328524288 1875758544 18.631 98 13 26 1 1900037024 20452352 3826128
18:47:08 142960 8192000000 10845230224 11318767616 1847035024 18.398 96 10 20 0 1873635376 23944816 2655536
18:49:37 114140 8192000000 10858528016 11312160768 1875191920 18.626 97 30 60 1 1892036096 8170496 8673680
18:51:37 38992 8192000000 10868941856 11320254464 1926156064 19.036 100 46 90 1 1952279136 13411744 12711328
18:52:27 4133 8192000000 10869740752 11321778176 1931404576 19.078 100 40 79 1 1955598160 13460192 10733392
18:52:37 13645 8192000000 10858756384 11314163712 1913126720 18.932 99 42 84 1 1939902208 14935072 11840416
18:53:00 44335 8192000000 10821507152 11294359552 1884427072 18.701 98 27 54 0 1903978624 12284096 7267456
18:55:37 58371 8192000000 10857564480 11322105856 1913398208 18.934 99 22 43 0 1931943888 12460816 6084864
18:57:37 47680 8192000000 10866530816 11332468736 1920033376 18.987 99 15 30 0 1936486240 11988112 4464752
18:59:09 105310 8192000000 10875886496 11358085120 1947264928 19.205 100 11 22 1 1960906176 10686512 2954736
19:01:06 107918 8192000000 10880886240 11356635136 1921610464 19.000 98 3 6 0 1932307568 10242016 455088
19:03:02 48942 8192000000 10894354864 11361632256 1946174864 19.196 99 17 34 1 1959630384 7895008 5560512
19:04:00 21858 8192000000 10921318256 11368603648 1967129424 19.363 100 37 73 0 1987588144 10473744 9984976
19:04:29 26422 8192000000 10921977760 11371941888 1971501744 19.397 100 42 82 0 1994045888 11206112 11338032
19:05:04 22355 8192000000 10915157968 11377913856 1956535936 19.278 99 37 74 1 1979374144 12910080 9928128
19:05:34 96636 8192000000 10886409072 11366404096 1912774528 18.929 97 9 18 0 1926981040 11774512 2432000
19:07:27 28490 8192000000 10900600624 11357945856 1920658512 18.992 97 52 104 0 1945068816 9306272 15104032
19:08:04 86390 8192000000 10890331872 11361636352 1915091808 18.948 98 19 39 0 1933644112 13227872 5324432
19:09:44 72617 8192000000 10898586032 11369824256 1929061488 19.059 98 15 29 1 1954642496 21051872 4529136
19:11:08 64980 8192000000 10917885312 11372208128 1970930656 19.393 100 26 52 0 1988683696 10860480 6892560
19:12:34 16655 8192000000 10932738400 11371216896 1977319504 19.443 100 50 100 1 2000919504 9658240 13941760
19:12:59 39991 8192000000 10918633552 11385974784 1956339680 19.277 99 42 84 0 1980755360 12089120 12326560
19:13:45 116365 8192000000 10910396576 11376672768 1979544128 19.461 100 24 48 1 1997374336 10757888 7072320
19:15:48 108461 8192000000 10871499680 11355205632 1900723072 18.832 96 16 32 0 1915104608 9743536 4638000
19:17:43 18442 8192000000 10878929760 11328450560 1940936864 19.154 99 22 42 4 1952945968 5039072 6970032
19:18:14 48945 8192000000 10886458992 11364782080 1960558992 19.310 100 11 23 1 1973459424 10179056 2721376
19:20:37 97118 8192000000 10895860368 11383398400 1956007104 19.274 99 17 34 0 1975512704 13937376 5568224
19:22:49 78652 8192000000 10882287200 11366834176 1917273984 18.965 97 12 24 1 1931321296 10635312 3412000
19:24:29 86965 8192000000 10887090656 11369140224 1924305120 19.021 98 11 22 2 1940720144 13153792 3261232
19:26:07 79464 8192000000 9327023616 9683472384 393324720 4.581 21 2 4 0 400641520 6896032 420768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-02-2021 19:28:46 to 25-02-2021 19:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-02-2021 19:29:17 to 25-02-2021 19:29:19.

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          234074
MON$OLDEST_ACTIVE               234075
MON$OLDEST_SNAPSHOT             234075
MON$NEXT_TRANSACTION            234075
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                       2003008
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:291: 
:292: mscs-test-161.budzdorov.ru    Thu Feb 25 19:27:30 2021
:293:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:294: 
--- end of diff output ---

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

25.02.21 19:29:20. 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-02-25 19:29:23 No severe PSQL-related problems occured
25.02.21 19:29:24. End of report.