Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2021 22: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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17177524 kB
MemAvailable 31503272 kB
Buffers 0 kB
Cached 14455192 kB
SwapCached 0 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-03-21 22:27:25
DTS_END                         2021-03-21 22:27:25.7120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45906
TRN_ID                          242550
ATT_ID                          656
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: 9550.20 20858 1146024
customer order: creation 175.36 334 21043
customer order: refuse 14.80 330 1776
order to supplier: creation 46.18 1278 5542
order to supplier: removal 3.53 98131 424
invoice (draft): creation 47.68 3232 5721
invoice (draft): removal 55.49 811 6659
invoice accept: apply 42.50 16995 5100
invoice accept: cancel 49.43 751 5932
customer reserve: creation 3934.98 167 472197
customer reserve: removal 4864.44 54 583733
realization accept: apply 85.44 154 10253
realization accept: cancel 99.71 96 11965
payment from customer: creation 59.63 96 7156
payment from customer: removal 6.11 87 733
payment to supplier: creation 49.77 106 5972
payment to supplier: removal 3.29 64 395
service: total inventory turnovers 4.61 1088 553
service: total monetary turnovers 6.42 25 770
service: aggregate perf. data 0.80 21588 96
service: refresh index statistics 0.03 271767 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-03-2021 22:28:43 to 21-03-2021 22:28:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1520
TEST_TIME 2 3833
TEST_TIME 3 4674
TEST_TIME 4 4811
TEST_TIME 5 5385
TEST_TIME 6 5747
TEST_TIME 7 5424
TEST_TIME 8 5511
TEST_TIME 9 5887
TEST_TIME 10 5932
TEST_TIME 11 6069
TEST_TIME 12 6073
TEST_TIME 13 6654
TEST_TIME 14 6761
TEST_TIME 15 6883
TEST_TIME 16 7216
TEST_TIME 17 7567
TEST_TIME 18 7725
TEST_TIME 19 7845
TEST_TIME 20 8048
TEST_TIME 21 8270
TEST_TIME 22 8534
TEST_TIME 23 8539
TEST_TIME 24 9143
TEST_TIME 25 9784
TEST_TIME 26 9960
TEST_TIME 27 10138
TEST_TIME 28 10245
TEST_TIME 29 10068
TEST_TIME 30 10295
TEST_TIME 31 10322
TEST_TIME 32 10105
TEST_TIME 33 10073
TEST_TIME 34 9962
TEST_TIME 35 9987
TEST_TIME 36 10023
TEST_TIME 37 9967
TEST_TIME 38 9840
TEST_TIME 39 9824
TEST_TIME 40 9746
TEST_TIME 41 9955
TEST_TIME 42 10005
TEST_TIME 43 9986
TEST_TIME 44 9951
TEST_TIME 45 9900
TEST_TIME 46 10050
TEST_TIME 47 10241
TEST_TIME 48 10095
TEST_TIME 49 9947
TEST_TIME 50 9978
TEST_TIME 51 10029
TEST_TIME 52 9870
TEST_TIME 53 9865
TEST_TIME 54 9804
TEST_TIME 55 9853
TEST_TIME 56 9847
TEST_TIME 57 9806
TEST_TIME 58 9734
TEST_TIME 59 9704
TEST_TIME 60 9659
TEST_TIME 61 9537
TEST_TIME 62 9593
TEST_TIME 63 9602
TEST_TIME 64 9583
TEST_TIME 65 9606
TEST_TIME 66 9692
TEST_TIME 67 9648
TEST_TIME 68 9719
TEST_TIME 69 9702
TEST_TIME 70 9700
TEST_TIME 71 9736
TEST_TIME 72 9787
TEST_TIME 73 9831
TEST_TIME 74 9842
TEST_TIME 75 9869
TEST_TIME 76 9873
TEST_TIME 77 9765
TEST_TIME 78 9767
TEST_TIME 79 9690
TEST_TIME 80 9633
TEST_TIME 81 9693
TEST_TIME 82 9621
TEST_TIME 83 9589
TEST_TIME 84 9548
TEST_TIME 85 9563
TEST_TIME 86 9552
TEST_TIME 87 9510
TEST_TIME 88 9537
TEST_TIME 89 9544
TEST_TIME 90 9538
TEST_TIME 91 9666
TEST_TIME 92 9617
TEST_TIME 93 9639
TEST_TIME 94 9645
TEST_TIME 95 9694
TEST_TIME 96 9714
TEST_TIME 97 9682
TEST_TIME 98 9769
TEST_TIME 99 9827
TEST_TIME 100 9851
TEST_TIME 101 9766
TEST_TIME 102 9757
TEST_TIME 103 9770
TEST_TIME 104 9743
TEST_TIME 105 9715
TEST_TIME 106 9675
TEST_TIME 107 9624
TEST_TIME 108 9644
TEST_TIME 109 9644
TEST_TIME 110 9603
TEST_TIME 111 9584
TEST_TIME 112 9532
TEST_TIME 113 9579
TEST_TIME 114 9549
TEST_TIME 115 9540
TEST_TIME 116 9547
TEST_TIME 117 9567
TEST_TIME 118 9629
TEST_TIME 119 9611
TEST_TIME 120 9551

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-03-2021 22:28:46 to 21-03-2021 22:28:50.

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 1582964 1582964 0 0.00 0 16036 5 0 0
doc_list_biud 1582964 1582964 0 0.00 0 80149 26 0 0
sp_add_invoice_to_stock 5221 5100 121 2.31 27 260939 16995 0 121
sp_cancel_adding_invoice 5932 5932 0 0.00 6 89181 752 0 0
sp_cancel_client_order 1776 1776 0 0.00 4 12028 331 0 0
sp_cancel_customer_reserve 583733 583733 0 0.00 1 44252 55 0 0
sp_cancel_pay_from_customer 733 733 0 0.00 3 5813 87 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 4324 64 0 0
sp_cancel_supplier_invoice 6670 6659 11 0.16 2 80209 811 0 11
sp_cancel_supplier_order 424 424 0 0.00 9 890445 98132 0 0
sp_cancel_write_off 11965 11965 0 0.00 1 7750 96 0 0
sp_client_order 21043 21043 0 0.00 3 16131 334 0 0
sp_customer_reserve 472197 472197 0 0.00 0 51758 168 0 0
sp_fill_shopping_cart 32293 32293 0 0.00 1 23483 39 0 0
sp_fill_shopping_cart_clo_res 472195 472195 0 0.00 0 13293 13 0 0
sp_get_clo_for_invoice 5097 5097 0 0.00 0 27438 302 0 0
sp_kill_cost_storno 19025 19025 0 0.00 0 5817 53 0 0
sp_kill_qstorno_ret_qs2qd 1186514 1186514 0 0.00 0 80148 30 0 0
sp_kill_qty_storno 625839 625839 0 0.00 0 80149 65 0 0
sp_lock_selected_doc 21261 21261 0 0.00 0 6081 3 0 0
sp_make_cost_storno 28478 28478 0 0.00 0 12675 44 0 0
sp_multiply_rows_for_pdistr 28478 28478 0 0.00 0 9513 27 0 0
sp_multiply_rows_for_qdistr 21043 21043 0 0.00 0 13936 154 0 0
sp_pay_from_customer 7156 7156 0 0.00 4 6243 96 0 0
sp_pay_to_supplier 5972 5972 0 0.00 5 11333 107 0 0
sp_payment_common 13128 13128 0 0.00 1 11328 23 0 0
sp_qd_handle_on_cancel_clo 1776 1776 0 0.00 0 11835 307 0 0
sp_qd_handle_on_invoice_upd_sts 11029 11029 0 0.00 0 26451 333 0 0
sp_qd_handle_on_reserve_upd_sts 10253 10253 0 0.00 0 15824 54 0 0
sp_reserve_write_off 10253 10253 0 0.00 6 15842 154 0 0
sp_supplier_invoice 5721 5721 0 0.00 6 115759 3232 0 0
sp_supplier_order 5542 5542 0 0.00 5 36758 1279 0 0
srv_aggregate_perf_data 96 96 0 0.00 2624 329404 21589 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1074 142417 31337 0 0
srv_find_qd_qs_mism 1097281 1097281 0 0.00 0 9420 4 0 0
srv_make_invnt_saldo 553 553 0 0.00 50 51889 1088 0 0
srv_make_money_saldo 770 770 0 0.00 1 1145 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 176533 388526 271767 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5100 5100 0 0.00 0 18404 159 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 15375 109 0 0
t$perf-norm:sp_cancel_client_order 1776 1776 0 0.00 0 4749 19 0 0
t$perf-norm:sp_cancel_customer_reserve 709 709 0 0.00 0 5343 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 733 733 0 0.00 0 915 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 4717 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 449 449 0 0.00 0 4370 32 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 28154 1962 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 3591 12 0 0
t$perf-norm:sp_client_order 21043 21043 0 0.00 0 11606 20 0 0
t$perf-norm:sp_customer_reserve 966 966 0 0.00 0 5057 10 0 0
t$perf-norm:sp_pay_from_customer 7156 7156 0 0.00 0 4581 9 0 0
t$perf-norm:sp_pay_to_supplier 5972 5972 0 0.00 0 11349 11 0 0
t$perf-norm:sp_reserve_write_off 10253 10253 0 0.00 0 5189 11 0 0
t$perf-norm:sp_supplier_invoice 5721 5721 0 0.00 0 7735 19 0 0
t$perf-norm:sp_supplier_order 5542 5542 0 0.00 0 7205 21 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 313 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 1154 15 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 1147 19 0 0
t$perf-norm:srv_make_money_saldo 770 770 0 0.00 0 2230 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10434 10192 242 2.31 0 3496 16 0 242
v_all_customers 38274 38274 0 0.00 0 375 1 0 0
v_all_suppliers 31338 31338 0 0.00 0 101 1 0 0
v_all_wares 42086 42086 0 0.00 0 104 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 157 6 0 0
v_cancel_client_order 3552 3552 0 0.00 0 1555 3 0 0
v_cancel_customer_prepayment 1466 1466 0 0.00 0 5795 10 0 0
v_cancel_customer_reserve 1418 1418 0 0.00 0 536 3 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 4270 10 0 0
v_cancel_supplier_invoice 920 898 22 2.39 0 1159 15 0 22
v_cancel_supplier_order 848 848 0 0.00 0 657 5 0 0
v_cancel_write_off 2012 2012 0 0.00 0 3515 14 0 0
v_max_id_clo_ord 5542 5542 0 0.00 0 838 2 0 0
v_max_id_clo_res 966 966 0 0.00 0 1383 14 0 0
v_max_id_ord_sup 5707 5707 0 0.00 0 5706 6 0 0
v_max_non_paid_invoice 1552 1552 0 0.00 0 1422 4 0 0
v_max_non_paid_realizn 3757 3757 0 0.00 0 1282 3 0 0
v_min_id_clo_ord 5542 5542 0 0.00 0 1977 5 0 0
v_min_id_clo_res 966 966 0 0.00 0 1869 8 0 0
v_min_id_ord_sup 5707 5707 0 0.00 0 6334 6 0 0
v_min_non_paid_invoice 5972 5972 0 0.00 0 11324 17 0 0
v_min_non_paid_realizn 7156 7156 0 0.00 0 4527 13 0 0
v_our_firm 10610 10610 0 0.00 0 23 1 0 0
v_reserve_write_off 20506 20506 0 0.00 0 5795 5 0 0
x_lock_depdocs_on_canc_invoice 12142 12142 0 0.00 0 15801 108 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 11687 318 0 0
x_make_qstorno_1000_1200 5542 5542 0 0.00 2 36754 1200 0 0
x_make_qstorno_1200_2000 5721 5721 0 0.00 3 115723 3085 0 0
x_make_qstorno_2100_3300 472197 472197 0 0.00 0 51757 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2021 22:28:51 to 21-03-2021 22:28:55.

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
19:57:29 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:36 10400 8192000000 10174816496 10469183488 855936544 9.460 70 52 100 1 875927840 2352688 17638608
19:57:55 27592 8192000000 10325538704 10639237120 1362153184 14.257 100 82 164 0 1392228112 4132272 25942656
19:58:32 37386 8192000000 10377311904 10699354112 1427098992 14.836 100 89 178 0 1462717024 6568784 29049248
19:59:18 13559 8192000000 10394756992 10719657984 1446940912 15.011 100 85 170 1 1482892240 7891552 28059776
19:59:43 33130 8192000000 10420015536 10747424768 1470298752 15.216 100 93 186 0 1509172160 8735952 30137456
20:00:27 20037 8192000000 10438165952 10767556608 1485210064 15.347 100 93 186 0 1524933888 10046560 29677264
20:00:56 18039 8192000000 10446097456 10784976896 1498688816 15.465 100 85 170 1 1536711840 10581360 27441664
20:01:26 20032 8192000000 10475382544 10816192512 1522573136 15.673 100 73 146 0 1555584336 10512048 22499152
20:01:57 16855 8192000000 10516201200 10861101056 1558266784 15.981 100 85 170 1 1595945728 11697984 25980960
20:02:24 13962 8192000000 10521112048 10873798656 1578273840 16.153 100 82 163 2 1615592400 11869040 25449520
20:02:47 14441 8192000000 10548592752 10902376448 1597510768 16.318 100 75 150 1 1632027072 11491008 23025296
20:03:10 14224 8192000000 10566357264 10923671552 1621936864 16.526 100 78 156 2 1657635792 11537008 24161920
20:03:34 13603 8192000000 10592725040 10955964416 1647610736 16.744 100 80 159 1 1683689760 12407728 23671296
20:03:54 11064 8192000000 10609687200 10972995584 1662991904 16.874 100 88 175 1 1701707120 13077104 25638112
20:04:15 6486 8192000000 10622715840 10987786240 1682574096 17.039 100 81 162 1 1719366272 13067168 23725008
20:04:29 10303 8192000000 10633756912 11003863040 1700438896 17.189 100 83 166 3 1738267888 13469136 24359856
20:04:47 7711 8192000000 10664708816 11034046464 1717067808 17.328 100 84 167 1 1754852368 14022032 23762528
20:05:02 6531 8192000000 10676692112 11050205184 1729535664 17.432 100 77 154 0 1765012992 13936864 21540464
20:05:15 5625 8192000000 10685643520 11060137984 1748870032 17.592 100 85 171 1 1787252688 14717264 23665392
20:05:28 4171 8192000000 10688361440 11068657664 1754862544 17.642 100 84 169 0 1793516880 14700144 23954192
20:05:38 5589 8192000000 10711222656 11089571840 1765538112 17.730 100 83 164 1 1803299440 14115568 23645760
20:05:50 4390 8192000000 10719951888 11097407488 1776507568 17.821 100 85 166 2 1813126624 13473344 23145712
20:06:01 3098 8192000000 10725278224 11107381248 1779088992 17.842 100 75 150 0 1813516848 13158304 21269552
20:06:11 2554 8192000000 10732887392 11114201088 1791983840 17.948 100 77 154 1 1825886320 12660240 21242240
20:06:20 1611 8192000000 10739036864 11120693248 1803464176 18.042 100 89 176 2 1841968000 13518768 24985056
20:06:29 7412 8192000000 10746853376 11133075456 1809709200 18.093 100 81 163 1 1845929360 13337984 22882176
20:06:43 3261 8192000000 10755852816 11141632000 1814392640 18.132 100 83 164 1 1850329344 12380448 23556256
20:06:54 2263 8192000000 10773551136 11154694144 1832385264 18.279 100 85 170 2 1870047616 12672416 24989936
20:07:03 1956 8192000000 10776078512 11164872704 1840629360 18.346 100 86 172 3 1877396240 12872496 23894384
20:07:11 1220 8192000000 10787921904 11169341440 1841357056 18.352 100 90 178 0 1879485840 12912288 25216496
20:07:19 2051 8192000000 10788671888 11178455040 1848426192 18.409 100 90 179 3 1886679440 12419808 25833440
20:07:27 1996 8192000000 10793196656 11181977600 1854960544 18.462 100 84 168 1 1891741056 12345984 24434528
20:07:36 2444 8192000000 10802460576 11188191232 1859458624 18.499 100 93 187 0 1900210096 13760656 26990816
20:07:45 1476 8192000000 10804905136 11190185984 1858045296 18.487 100 86 171 1 1895321344 13194560 24081488
20:07:53 2127 8192000000 10800396000 11194880000 1861958752 18.519 100 91 182 3 1899648352 12375488 25314112
20:08:01 2008 8192000000 10814303136 11199508480 1864253552 18.538 100 92 184 0 1903888592 12959104 26675936
20:08:09 21555 8192000000 10784927568 11207106560 1865410928 18.547 100 67 134 1 1905630192 21749984 18469280
20:08:53 16277 8192000000 10768767280 11193991168 1859316384 18.498 100 27 55 3 1873205520 6408640 7480496
20:09:18 4059 8192000000 10787599520 11200442368 1865944160 18.551 100 36 71 1 1881993584 6219136 9830288
20:09:29 2599 8192000000 10792553264 11203338240 1868855184 18.575 100 34 69 0 1885976304 7255776 9865344
20:09:39 5018 8192000000 10788433568 11210686464 1872219328 18.602 100 34 68 2 1889691088 7890800 9580960
20:09:50 7635 8192000000 10788383248 11211730944 1873013536 18.609 100 27 53 2 1887533696 6771280 7748880
20:10:06 4782 8192000000 10791341632 11214340096 1878601776 18.654 100 40 81 1 1897948256 8840656 10505824
20:10:20 12101 8192000000 10792435872 11218362368 1876766432 18.639 100 20 40 0 1888401168 6411536 5223200
20:10:41 3442 8192000000 10802115056 11231055872 1887202736 18.723 100 37 74 2 1910047856 12382080 10463040
20:10:55 6437 8192000000 10796645152 11228667904 1886797984 18.720 100 15 31 0 1897170032 6133168 4238880
20:11:08 6158 8192000000 10809612880 11227365376 1889154240 18.739 100 20 41 2 1901055984 6070128 5831616
20:11:21 9080 8192000000 10803648112 11233292288 1889299360 18.740 100 15 29 1 1899332320 6352176 3680784
20:11:36 8882 8192000000 10800560208 11233161216 1891366512 18.757 100 19 38 2 1902896448 6187424 5342512
20:11:54 7066 8192000000 10804154864 11239424000 1894022704 18.778 100 22 45 3 1906748240 6092304 6633232
20:12:09 8654 8192000000 10809884800 11238014976 1901253264 18.836 100 32 63 1 1915268512 5126576 8888672
20:12:25 68958 8192000000 10837834432 11259625472 1910855136 18.914 100 45 88 1 1930225600 6108544 13261920
20:13:41 6635 8192000000 10822551200 11259252736 1907008624 18.883 100 27 55 1 1921032352 5692672 8331056
20:13:57 8210 8192000000 10836266224 11262877696 1909064656 18.899 100 32 60 1 1924966272 7072304 8829312
20:14:14 7978 8192000000 10830523072 11265871872 1912348800 18.925 100 21 42 3 1923045056 5067776 5628480
20:14:29 7942 8192000000 10833377584 11267727360 1914349088 18.942 100 27 56 2 1927692768 4951264 8392416
20:14:43 6217 8192000000 10832571648 11268841472 1915206080 18.948 100 25 50 0 1928304656 6298544 6800032
20:14:55 5640 8192000000 10833754800 11274670080 1922052048 19.003 100 31 62 0 1938518528 7756064 8710416
20:15:09 5071 8192000000 10849277712 11275841536 1922843520 19.010 100 25 50 0 1937252352 5902624 8506208
20:15:21 3717 8192000000 10839638400 11275526144 1925092128 19.028 100 34 69 2 1942238960 7075904 10070928
20:15:32 5866 8192000000 10850380448 11279060992 1922432208 19.006 100 31 62 0 1938464384 7253824 8778352
20:15:47 5258 8192000000 10841740592 11274641408 1921968448 19.003 100 28 58 3 1936641008 6487168 8185392
20:16:02 5412 8192000000 10833896432 11266433024 1895764208 18.792 99 25 51 0 1908586832 5170496 7652128
20:16:15 8561 8192000000 10826301440 11268599808 1921541328 18.999 100 31 62 2 1936999168 6631824 8826016
20:16:30 8916 8192000000 10810687104 11246723072 1885599200 18.710 99 22 44 2 1898232672 6881760 5751712
20:16:45 14446 8192000000 10797567392 11232890880 1844350880 18.376 97 16 32 2 1854911968 5587616 4973472
20:17:07 56434 8192000000 10775816608 11201290240 1782622400 17.871 94 27 54 4 1795252224 5087664 7542160
20:18:09 7373 8192000000 10760348064 11186909184 1828901936 18.250 98 20 37 2 1838518896 4956592 4660368
20:18:25 5223 8192000000 10765049552 11191943168 1816169392 18.146 97 24 48 0 1829144816 5858368 7117056
20:18:36 6275 8192000000 10790421664 11209854976 1839443600 18.336 98 36 69 1 1855637616 5778384 10415632
20:18:50 3400 8192000000 10764980784 11185795072 1829814432 18.258 99 43 85 1 1849453264 7655376 11983456
20:19:01 5069 8192000000 10765255568 11188617216 1835504368 18.304 99 26 52 1 1849558800 6718544 7335888
20:19:12 9913 8192000000 10738103600 11156090880 1766509360 17.738 95 39 78 1 1784561216 6435136 11616720
20:19:30 6861 8192000000 10723360992 11148087296 1775690704 17.814 97 30 60 0 1790181696 5830320 8660672
20:19:45 4802 8192000000 10687410288 11102228480 1699109632 17.178 94 32 64 4 1714861696 6277728 9474336
20:19:56 7602 8192000000 10672607408 11087638528 1745933008 17.568 98 32 64 0 1761319936 6129312 9257616
20:20:10 7097 8192000000 10680723952 11100295168 1720941664 17.360 97 22 44 2 1733802816 5900640 6960512
20:20:25 7807 8192000000 10697242944 11101392896 1719847488 17.351 96 34 68 0 1735029232 5187984 9993760
20:20:39 3579 8192000000 10706580992 11117334528 1782769824 17.872 100 31 62 0 1799585088 7294416 9520848
20:20:50 5553 8192000000 10708695632 11131658240 1782607632 17.871 99 28 56 2 1796425600 5181712 8636256
20:21:05 7898 8192000000 10730176288 11149078528 1793506464 17.961 99 19 36 2 1804038352 5078080 5453808
20:21:19 8883 8192000000 10722172816 11145351168 1782279904 17.868 98 20 40 2 1793863024 5417856 6165264
20:21:40 71765 8192000000 10753946736 11155144704 1771859296 17.782 97 38 76 0 1788113632 5065344 11188992
20:23:02 9719 8192000000 10746202304 11165245440 1825280176 18.221 100 37 74 0 1841846064 6349744 10216144
20:23:17 9826 8192000000 10756785648 11178254336 1830848000 18.266 100 33 65 1 1851318592 11520192 8950400
20:23:33 8745 8192000000 10754230256 11185029120 1845177072 18.383 100 30 60 1 1861209216 6962592 9069552
20:23:48 7383 8192000000 10758495216 11187486720 1848953920 18.414 100 26 53 2 1862766944 5971840 7841184
20:24:02 7002 8192000000 10789962992 11194388480 1836281264 18.311 99 28 54 0 1849384560 4768496 8334800
20:24:16 10716 8192000000 10775849952 11206467584 1860966048 18.511 100 23 46 0 1873120912 5655200 6499664
20:24:36 6524 8192000000 10776274928 11210792960 1863743136 18.534 100 18 36 0 1878462112 9923536 4795440
20:24:49 7279 8192000000 10787925456 11215257600 1866063744 18.552 100 23 46 2 1883585392 10636352 6885296
20:25:07 8691 8192000000 10783256464 11213844480 1868442768 18.572 100 15 30 2 1877661536 4809600 4409168
20:25:26 6890 8192000000 10775445744 11215134720 1871318688 18.595 100 17 33 2 1881832352 5706128 4807536
20:25:39 9133 8192000000 10798387424 11223064576 1875215376 18.626 100 23 46 0 1887540688 5308688 7016624
20:25:55 9251 8192000000 10789221392 11221225472 1877387184 18.644 100 24 49 0 1890424240 5857792 7179264
20:26:17 9733 8192000000 10793763408 11219181568 1876799120 18.639 100 21 42 0 1888964176 6367856 5797200
20:26:33 28340 8192000000 10786588816 11225079808 1878197920 18.651 100 21 41 0 1889622848 5160496 6264432
20:27:57 60673 8192000000 10849243872 11268456448 1914443344 18.942 100 37 74 1 1932735408 7521488 10770576
20:29:19 16997 8192000000 10856197920 11281788928 1911489632 18.919 99 53 105 3 1937617872 11363248 14764992
20:29:44 3175 8192000000 10884172304 11297431552 1937215056 19.125 100 67 134 0 1967641760 11946816 18479888
20:29:55 2859 8192000000 10897606320 11305254912 1943265392 19.173 100 69 136 0 1977064864 14510288 19289184
20:30:04 8501 8192000000 10887247168 11312082944 1948248576 19.213 100 68 136 1 1982064640 14489920 19326144
20:30:20 3306 8192000000 10889732816 11313872896 1953115376 19.251 100 64 129 2 1984312208 13274352 17922480
20:30:33 27474 8192000000 10898349520 11322900480 1952461792 19.246 100 55 103 3 1980474496 13488800 14523904
20:31:07 22147 8192000000 10895184256 11324366848 1960375104 19.309 100 43 86 1 1986484192 13660416 12448672
20:31:41 24407 8192000000 10891090272 11332268032 1964459184 19.341 100 40 80 2 1991366944 15264704 11643056
20:32:22 21989 8192000000 10903003024 11338641408 1968035344 19.370 100 37 74 2 1991592912 13014560 10543008
20:32:51 12143 8192000000 10918238496 11346006016 1970971984 19.393 100 51 101 3 1999678672 14205488 14501200
20:33:27 5750 8192000000 10920785264 11352064000 1979988368 19.465 100 51 103 1 2010903840 15731456 15184016
20:33:43 10855 8192000000 10926535616 11354972160 1984001392 19.496 100 52 103 0 2013102176 14462384 14638400
20:34:01 10132 8192000000 10930808960 11359305728 1987885552 19.527 100 57 112 0 2019952640 15643232 16423856
20:34:20 8719 8192000000 10931656864 11359248384 1971693584 19.399 99 58 116 0 2006158336 17627136 16837616
20:34:38 5026 8192000000 10935967936 11363946496 1986545376 19.516 100 64 128 1 2024372208 18849920 18976912
20:34:50 8081 8192000000 10940912080 11366404096 1990252000 19.546 100 67 133 4 2028268304 18828816 19187488
20:35:07 6499 8192000000 10942798672 11372199936 1993058496 19.568 100 62 125 0 2031283728 19921152 18304080
20:35:22 11549 8192000000 10940894496 11375554560 1996135104 19.592 100 58 116 0 2033242976 19298112 17809760
20:35:45 13589 8192000000 10940442160 11371405312 1977094720 19.442 99 53 106 2 2012976288 19545808 16335760
20:36:07 6254 8192000000 10929116512 11358613504 1986756064 19.518 100 55 110 1 2019264272 15877072 16631136
20:36:26 16658 8192000000 10941826416 11377205248 1993653952 19.573 100 58 114 2 2027058464 16979312 16425200
20:36:51 15169 8192000000 10937720768 11381780480 2005692144 19.668 100 53 103 2 2041057152 19944368 15420640
20:37:19 9035 8192000000 10949262032 11389767680 2006823760 19.677 100 50 100 0 2042784080 20782576 15177744
20:37:35 4451 8192000000 10947550992 11368083456 1977877888 19.448 99 67 133 4 2019650048 21644496 20127664
20:37:48 14703 8192000000 10953850416 11381178368 1998317120 19.609 100 59 118 2 2040654320 24530176 17807024
20:38:17 15293 8192000000 10951200464 11382206464 1979527712 19.461 99 57 114 2 2026419488 28716752 18175024
20:38:41 14730 8192000000 10945229456 11386691584 1994759440 19.581 100 59 117 0 2042722320 28826576 19136304
20:39:15 7076 8192000000 10970780752 11400536064 2003849536 19.653 100 64 128 1 2052894832 28754432 20290864
20:39:31 8298 8192000000 10967016720 11396931584 2002766096 19.645 100 64 128 0 2053932928 31457456 19709376
20:39:51 6067 8192000000 10979517280 11405160448 2007373088 19.681 100 74 145 0 2062440400 31796448 23270864
20:40:12 10097 8192000000 10957540272 11397976064 2010577232 19.706 100 52 103 1 2055484896 28331056 16576608
20:40:33 3402 8192000000 10948322208 11382366208 1986724336 19.518 99 60 120 0 2027197184 20998336 19474512
20:40:46 7218 8192000000 10951325280 11384688640 1997089040 19.600 100 54 104 0 2036617408 22976144 16552224
20:41:00 3269 8192000000 10970569440 11395821568 2003745248 19.652 100 68 134 2 2050238592 26109760 20383584
20:41:11 2237 8192000000 10981815872 11399819264 2010228592 19.703 100 86 171 2 2063126192 26704048 26193552
20:41:20 1272 8192000000 10978860912 11392528384 1992461264 19.563 99 85 170 3 2043104160 24675088 25967808
20:41:29 3078 8192000000 10950325024 11367251968 1980867984 19.472 99 77 152 1 2027675296 23512192 23295120
20:41:42 3568 8192000000 10946041776 11369357312 1984039360 19.497 99 79 154 0 2032073136 24941792 23091984
20:41:56 3002 8192000000 10964676064 11378610176 1981004432 19.473 99 91 180 2 2035192576 26918800 27269344
20:42:06 4041 8192000000 10969448560 11382693888 1995926400 19.591 100 89 175 1 2051093648 29018880 26148368
20:42:19 2292 8192000000 10964702560 11382947840 1991545904 19.556 100 85 169 1 2048304096 30614880 26143312
20:42:28 3899 8192000000 10952151040 11371048960 1981469504 19.476 100 82 164 4 2037902208 30718928 25713776
20:42:40 3514 8192000000 10946350672 11363389440 1970452560 19.389 99 83 164 1 2027241344 30959840 25828944
20:42:52 2882 8192000000 10968832000 11381743616 1987614720 19.525 100 87 172 2 2045906800 30407248 27884832
20:43:04 3004 8192000000 10961772592 11380977664 1976495424 19.437 99 85 169 0 2033461936 30663936 26302576
20:43:14 3184 8192000000 10924091680 11340431360 1927791040 19.049 97 79 158 1 1984936800 31805408 25340352
20:43:23 9366 8192000000 10936120352 11361509376 1967130896 19.363 100 72 143 2 2020670320 31056336 22483088
20:43:40 4203 8192000000 10925447104 11353022464 1961245152 19.316 100 57 114 1 2007971040 28813552 17912336
20:43:51 2687 8192000000 10929733744 11351519232 1962681376 19.327 100 82 164 3 2017300208 28860240 25758592
20:44:01 3640 8192000000 10947023696 11361845248 1969740640 19.383 100 74 145 2 2023527696 31736960 22050096
20:44:11 1594 8192000000 10966057376 11378216960 1980094208 19.465 100 92 184 3 2042728256 33159376 29474672
20:44:19 2633 8192000000 10970183616 11384356864 1984150848 19.498 100 88 175 1 2045557008 34372368 27033792
20:44:29 2450 8192000000 10937394656 11354566656 1952370720 19.245 99 86 171 2 2015492032 36387328 26733984
20:44:40 5432 8192000000 10946413328 11360067584 1955967120 19.274 99 71 142 0 2012412384 33902816 22542448
20:44:53 2608 8192000000 10950270816 11370254336 1974562576 19.422 100 77 151 2 2030681744 32565792 23553376
20:45:02 3508 8192000000 10930499152 11343212544 1947917392 19.210 99 79 158 1 2005701776 33535872 24248512
20:45:12 1814 8192000000 10956434864 11363180544 1969320048 19.380 100 91 182 1 2029225600 31834352 28071200
20:45:21 3912 8192000000 10946863072 11358998528 1954411856 19.262 99 84 166 1 2013615616 33506800 25696960
20:45:33 3196 8192000000 10950633168 11362037760 1969111248 19.378 100 80 157 2 2026940208 33338432 24490528
20:45:43 2852 8192000000 10952835296 11370127360 1973741088 19.415 100 86 170 2 2034466896 34026080 26699728
20:46:00 5065 8192000000 10955223504 11379249152 1981634144 19.478 100 69 138 1 2037325440 33788528 21902768
20:46:12 3821 8192000000 10959998528 11378184192 1981691792 19.478 100 80 158 0 2039859664 33772736 24395136
20:46:22 4524 8192000000 10969393296 11391655936 1988090640 19.529 100 77 152 2 2047133408 35200288 23842480
20:46:37 7275 8192000000 10951243920 11382210560 1979362576 19.460 100 60 117 2 2032668672 34952480 18353616
20:46:52 4660 8192000000 10970453536 11394695168 1992162320 19.561 100 79 157 0 2054173728 37637056 24374352
20:47:10 1072 8192000000 10983226304 11397488640 1993329648 19.570 100 88 176 2 2060879600 39908608 27641344
20:47:18 3383 8192000000 10978500432 11394654208 1993977936 19.575 100 84 169 0 2057645104 37617712 26049456
20:47:29 4755 8192000000 10985572416 11400396800 1995475840 19.587 100 77 153 2 2056283280 36800736 24006704
20:47:40 3458 8192000000 10935960912 11347431424 1942585168 19.167 98 84 165 1 2005642592 36659296 26398128
20:47:51 2623 8192000000 10953785552 11366727680 1965697536 19.351 100 85 170 2 2030578768 37809952 27071280
20:48:02 3701 8192000000 10928518928 11356790784 1956266864 19.276 100 61 121 1 2013573232 38107808 19198560
20:48:20 8852 8192000000 10923178608 11364888576 1958567040 19.295 100 40 80 2 2011081184 39453584 13060560
20:48:39 17902 8192000000 10899622128 11335880704 1917761232 18.969 98 35 69 2 1968314944 38677120 11876592
20:49:09 6897 8192000000 10932499216 11364696064 1954749408 19.264 100 38 75 4 2007226720 39433536 13043776
20:49:24 14033 8192000000 10925393696 11370229760 1958291552 19.292 100 33 68 2 2008521104 39542224 10687328
20:49:47 23969 8192000000 10899422512 11342741504 1918794784 18.977 98 26 52 1 1967163232 39033488 9334960
20:50:19 19948 8192000000 10906984848 11349270528 1918247632 18.973 99 30 60 1 1975022512 45507904 11266976
20:50:46 14599 8192000000 10917962512 11356966912 1922754032 19.009 99 34 68 0 1989030240 54127984 12148224
20:51:07 16645 8192000000 10903663888 11353124864 1929578896 19.064 100 33 66 0 2001709600 59795120 12335584
20:51:35 24222 8192000000 10887043024 11337510912 1895268672 18.788 98 35 70 1 1957439264 49795456 12375136
20:52:07 23551 8192000000 10888063616 11347025920 1909938640 18.906 99 31 62 1 1959337104 39201104 10197360
20:53:07 18383 8192000000 10875353120 11320541184 1904053856 18.859 100 26 52 3 1945968880 33517632 8397392
20:53:45 43665 8192000000 10878424720 11324280832 1905942432 18.874 99 28 57 1 1949798992 35097840 8758720
20:54:36 17506 8192000000 10870154064 11313700864 1915913568 18.954 100 29 58 0 1949569344 24752352 8903424
20:55:00 11337 8192000000 10849611424 11306651648 1901661824 18.840 99 22 44 2 1929828592 21389936 6776832
20:56:05 47548 8192000000 10844130608 11298836480 1895361216 18.789 99 18 35 1 1917713360 16898224 5453920
20:57:05 28281 8192000000 10848400576 11319545856 1904179616 18.860 99 21 44 1 1925773120 15512976 6080528
20:57:39 38091 8192000000 10869427456 11318444032 1933214368 19.093 100 21 42 0 1952589872 12835152 6540352
20:58:24 38144 8192000000 10841446528 11305086976 1894404816 18.781 98 13 26 1 1907630224 9894160 3331248
20:59:15 54485 8192000000 10850410816 11296563200 1889286112 18.740 98 17 32 1 1901086608 7850432 3950064
21:00:25 51467 8192000000 10862736640 11321651200 1927479984 19.047 100 21 42 1 1946234000 13094864 5659152
21:01:23 78444 8192000000 10870310144 11335782400 1907287408 18.885 98 8 16 1 1923721056 14513360 1920288
21:02:48 112580 8192000000 10890221744 11342442496 1915591008 18.952 98 10 20 0 1929507696 11217552 2699136
21:04:48 37807 8192000000 10907106336 11344834560 1957193072 19.284 100 20 40 1 1969911952 7104048 5614832
21:05:35 24766 8192000000 10907653536 11357339648 1967021760 19.362 100 31 62 1 1984114528 7970544 9122224
21:06:17 51614 8192000000 10910549840 11361947648 1936659968 19.120 98 22 44 1 1952177936 8832880 6685088
21:07:15 91272 8192000000 10902459696 11369615360 1958991920 19.298 99 8 16 1 1974366672 12786848 2587904
21:09:08 142417 8192000000 10916196128 11371421696 1941517104 19.159 98 11 22 1 1961497968 16926016 3054848
21:11:47 65152 8192000000 10931134048 11404726272 1975085648 19.426 99 9 18 1 2000108064 22182576 2839840
21:13:13 43001 8192000000 10930683152 11415035904 1982046928 19.481 100 6 12 0 2006288848 22500832 1741088
21:14:02 84774 8192000000 10911357472 11358973952 1940582704 19.151 98 11 22 2 1964058896 19808000 3668192
21:15:36 95108 8192000000 10918430032 11388166144 1984703184 19.502 100 42 82 0 2009172096 12679936 11788976
21:17:24 27350 8192000000 10910889696 11370586112 1953362400 19.253 98 42 83 1 1979086528 12791056 12933072
21:18:01 82269 8192000000 10908894224 11390423040 1990381712 19.547 100 23 46 0 2008687232 11577520 6728000
21:19:41 18344 8192000000 10937220464 11375230976 1977038640 19.441 99 35 67 3 1993142528 6190528 9913360
21:20:05 1650 8192000000 10962705856 11396149248 2006248352 19.672 100 77 155 0 2037297392 8437440 22611600
21:20:13 27302 8192000000 10916429376 11379236864 1960217488 19.308 98 26 52 1 1976530800 9033408 7279904
21:21:27 27892 8192000000 10916845536 11382194176 1975056992 19.426 99 31 62 0 1992729392 8505088 9167312
21:22:15 19478 8192000000 10887840176 11352993792 1935783568 19.113 97 49 97 2 1961930176 11220448 14926160
21:22:44 68592 8192000000 10913974208 11380457472 1960387808 19.309 99 34 68 1 1978290032 8195392 9706832
21:24:01 37476 8192000000 10872706160 11349897216 1917673440 18.968 97 13 26 1 1931850608 10283232 3893936
21:24:45 59352 8192000000 10883037184 11358793728 1942793984 19.169 99 9 18 0 1954764768 9648592 2322192
21:25:51 25364 8192000000 10880624208 11359580160 1949791424 19.225 99 6 12 1 1958418128 7223568 1403136
21:26:44 36495 8192000000 10871561744 11350159360 1923210624 19.013 98 13 26 1 1937774832 10703104 3861104
21:27:27 56221 8192000000 10884178352 11358101504 1942912880 19.170 99 19 38 0 1958713408 10479568 5320960
21:28:31 82631 8192000000 10875430320 11354255360 1888499968 18.734 96 23 46 1 1905580112 10915232 6164912
21:30:06 48423 8192000000 10857632656 11341885440 1912056496 18.923 98 12 24 0 1933615408 18544624 3014288
21:31:07 50747 8192000000 10877678992 11349901312 1894370768 18.781 97 15 30 1 1905902992 7906176 3626048
21:32:05 38279 8192000000 10895284384 11361210368 1939645360 19.144 99 14 28 0 1956129584 12723648 3760576
21:32:53 62182 8192000000 10873005296 11347718144 1896143616 18.795 97 10 20 1 1913198608 14742528 2312464
21:34:06 30823 8192000000 10889500320 11343376384 1900714960 18.832 97 26 52 1 1917958272 9266368 7976944
21:34:45 7155 8192000000 10882323584 11340353536 1939143872 19.140 99 46 92 0 1960291648 8669424 12478352
21:35:06 54898 8192000000 10877960192 11356721152 1931767936 19.081 99 35 70 1 1952927920 11643312 9516672
21:36:11 77927 8192000000 10880996864 11347283968 1899524272 18.822 97 18 34 4 1915374256 11132000 4717984
21:37:36 69021 8192000000 10863978112 11333292032 1817156288 18.154 93 17 34 1 1838803136 16529408 5117440
21:38:51 83234 8192000000 10843557984 11315654656 1781819040 17.864 92 21 42 0 1816638112 28674160 6144912
21:40:20 105096 8192000000 10845561760 11320328192 1804962944 18.055 94 9 18 0 1817431616 10464016 2004656
21:42:12 88084 8192000000 10863333728 11342376960 1882058672 18.682 98 10 20 1 1897737456 12868848 2809936
21:43:48 71307 8192000000 10854098800 11314696192 1876643136 18.638 97 35 69 0 1898946048 11757472 10545440
21:45:39 47507 8192000000 10838997280 11283767296 1828451728 18.247 95 40 78 3 1846323968 6180224 11692016
21:46:36 22037 8192000000 10868401760 11312267264 1911789952 18.921 100 55 110 0 1941463872 14618048 15055872
21:47:18 16508 8192000000 10862745376 11312893952 1918982720 18.979 100 45 90 1 1946544192 14870672 12690800
21:47:42 31119 8192000000 10862114720 11313635328 1913693040 18.936 100 50 100 1 1943781568 15928992 14159536
21:48:23 61447 8192000000 10837886736 11320389632 1918571008 18.975 100 19 36 1 1938597344 15109632 4916704
21:49:30 51037 8192000000 10850732368 11325874176 1927860512 19.050 100 10 20 0 1941438736 10917344 2660880
21:50:33 56225 8192000000 10853182240 11324239872 1911743568 18.921 99 15 30 0 1926923936 10809152 4371216
21:51:40 70200 8192000000 10866508672 11343478784 1923269040 19.013 99 21 42 1 1941701104 12040080 6391984
21:53:08 70785 8192000000 10889162832 11349381120 1925100960 19.028 99 12 24 1 1940905648 12132528 3672160
21:54:31 58352 8192000000 10885919312 11359490048 1952775056 19.249 100 18 36 1 1975632400 17851664 5005680
21:56:06 80346 8192000000 10882405488 11349266432 1917177952 18.964 98 20 40 1 1940986944 17495680 6313312
21:57:37 67196 8192000000 10882004992 11362775040 1917932528 18.970 98 8 16 0 1931561632 11565312 2063792
21:59:43 30270 8192000000 10889010816 11357155328 1942875936 19.170 99 17 34 1 1957051600 9437072 4738592
22:00:28 57949 8192000000 10918310528 11368751104 1950255440 19.229 99 20 40 1 1963547552 7823696 5468416
22:01:36 70224 8192000000 10897546448 11364896768 1898175264 18.812 96 29 58 2 1917732624 11126640 8430720
22:02:57 101101 8192000000 10892095856 11347025920 1887631152 18.727 96 13 26 0 1905532544 13945200 3956192
22:04:50 71778 8192000000 10893203648 11372765184 1936573360 19.119 99 13 26 1 1958113392 17767920 3772112
22:06:11 76581 8192000000 10888395488 11386085376 1919307392 18.981 98 7 14 0 1956455120 34982976 2164752
22:08:18 81757 8192000000 10869734576 11338178560 1880357920 18.668 96 24 48 0 1898406144 11577888 6470336
22:09:46 68313 8192000000 10878112528 11362394112 1952255472 19.244 100 18 36 0 1975355968 17208016 5892480
22:11:12 8303 8192000000 10874659040 11361300480 1952948080 19.250 100 10 20 0 1969900752 13735472 3217200
22:11:26 14512 8192000000 10909039536 11359014912 1963780832 19.336 100 34 68 4 1984168384 10946816 9440736
22:11:50 59669 8192000000 10870921232 11351601152 1891357216 18.757 96 21 42 1 1907975984 10928720 5690048
22:12:55 46713 8192000000 10870667040 11340759040 1897757984 18.808 97 11 22 0 1912212320 11594848 2859488
22:13:53 46212 8192000000 10835842592 11306070016 1865686800 18.549 96 11 22 2 1883719328 14783632 3248896
22:14:47 79810 8192000000 10866079056 11347771392 1946425136 19.198 100 15 30 2 1965345696 14309440 4611120
22:17:34 47079 8192000000 10883969408 11370569728 1936571136 19.119 99 17 34 2 1959285600 16638832 6075632
22:18:32 47633 8192000000 10889844384 11373686784 1962500768 19.326 100 14 28 0 1984739984 18484000 3755216
22:20:32 71010 8192000000 10863314848 11342270464 1892037472 18.762 97 13 26 1 1910176336 14679040 3459824
22:21:59 69336 8192000000 10881845344 11353112576 1883990144 18.697 96 15 30 2 1902564944 14587376 3987424
22:23:23 39852 8192000000 10872792576 11345653760 1894586144 18.783 97 14 28 2 1914563968 16127056 3850768
22:24:09 50442 8192000000 10887961360 11354169344 1928282032 19.053 99 29 58 1 1958163760 21398528 8483200
22:25:06 64396 8192000000 10882879824 11362402304 1894529472 18.782 97 19 38 0 1919778992 19503376 5746144
22:26:19 47034 8192000000 10885977776 11352203264 1930033184 19.067 99 24 49 1 1953725200 16811696 6880320
22:27:15 27748 8192000000 9020628400 9227489280 186190336 2.222 10 3 6 0 192990176 6295728 504112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-03-2021 22:28:57 to 21-03-2021 22:29:28.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2021 22:29:29 to 21-03-2021 22:29:31.

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          244127
MON$OLDEST_ACTIVE               244128
MON$OLDEST_SNAPSHOT             244128
MON$NEXT_TRANSACTION            244128
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                       2051744
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
--- end of diff output ---

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

21.03.21 22:29:32. 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-03-21 22:29:34 No severe PSQL-related problems occured
21.03.21 22:29:36. End of report.