Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.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 17563152 kB
MemAvailable 31474920 kB
Buffers 0 kB
Cached 14086196 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-25 22:27:21
DTS_END                         2021-03-25 22:27:21.8200
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/49938
TRN_ID                          233102
ATT_ID                          662
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: 9261.48 25150 1111378
customer order: creation 165.63 381 19875
customer order: refuse 14.15 366 1698
order to supplier: creation 42.55 1402 5106
order to supplier: removal 3.18 120940 382
invoice (draft): creation 44.29 3115 5315
invoice (draft): removal 53.31 883 6397
invoice accept: apply 40.78 17683 4894
invoice accept: cancel 48.37 746 5804
customer reserve: creation 3800.72 174 456086
customer reserve: removal 4757.19 64 570863
realization accept: apply 81.18 183 9741
realization accept: cancel 85.27 106 10232
payment from customer: creation 56.51 93 6781
payment from customer: removal 5.51 61 661
payment to supplier: creation 47.52 118 5702
payment to supplier: removal 3.19 71 383
service: total inventory turnovers 4.70 1060 564
service: total monetary turnovers 6.53 29 784
service: aggregate perf. data 0.88 18263 106
service: refresh index statistics 0.03 337266 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-03-2021 22:28:31 to 25-03-2021 22:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4029
TEST_TIME 2 5230
TEST_TIME 3 5300
TEST_TIME 4 5320
TEST_TIME 5 5120
TEST_TIME 6 5536
TEST_TIME 7 5462
TEST_TIME 8 5684
TEST_TIME 9 5544
TEST_TIME 10 5433
TEST_TIME 11 5524
TEST_TIME 12 5792
TEST_TIME 13 5876
TEST_TIME 14 6116
TEST_TIME 15 6844
TEST_TIME 16 6659
TEST_TIME 17 7081
TEST_TIME 18 7384
TEST_TIME 19 7473
TEST_TIME 20 7644
TEST_TIME 21 7868
TEST_TIME 22 8272
TEST_TIME 23 8500
TEST_TIME 24 9120
TEST_TIME 25 9675
TEST_TIME 26 10163
TEST_TIME 27 10503
TEST_TIME 28 11046
TEST_TIME 29 10978
TEST_TIME 30 10949
TEST_TIME 31 10729
TEST_TIME 32 10730
TEST_TIME 33 10630
TEST_TIME 34 10529
TEST_TIME 35 10465
TEST_TIME 36 10456
TEST_TIME 37 10543
TEST_TIME 38 10383
TEST_TIME 39 10155
TEST_TIME 40 9981
TEST_TIME 41 9769
TEST_TIME 42 9704
TEST_TIME 43 9769
TEST_TIME 44 9668
TEST_TIME 45 9671
TEST_TIME 46 9581
TEST_TIME 47 9408
TEST_TIME 48 9415
TEST_TIME 49 9483
TEST_TIME 50 9455
TEST_TIME 51 9487
TEST_TIME 52 9510
TEST_TIME 53 9481
TEST_TIME 54 9590
TEST_TIME 55 9545
TEST_TIME 56 9546
TEST_TIME 57 9564
TEST_TIME 58 9699
TEST_TIME 59 9618
TEST_TIME 60 9725
TEST_TIME 61 9710
TEST_TIME 62 9568
TEST_TIME 63 9453
TEST_TIME 64 9473
TEST_TIME 65 9463
TEST_TIME 66 9387
TEST_TIME 67 9293
TEST_TIME 68 9330
TEST_TIME 69 9327
TEST_TIME 70 9412
TEST_TIME 71 9368
TEST_TIME 72 9382
TEST_TIME 73 9378
TEST_TIME 74 9359
TEST_TIME 75 9387
TEST_TIME 76 9432
TEST_TIME 77 9424
TEST_TIME 78 9379
TEST_TIME 79 9452
TEST_TIME 80 9494
TEST_TIME 81 9477
TEST_TIME 82 9493
TEST_TIME 83 9420
TEST_TIME 84 9378
TEST_TIME 85 9383
TEST_TIME 86 9332
TEST_TIME 87 9362
TEST_TIME 88 9308
TEST_TIME 89 9350
TEST_TIME 90 9318
TEST_TIME 91 9338
TEST_TIME 92 9307
TEST_TIME 93 9315
TEST_TIME 94 9365
TEST_TIME 95 9342
TEST_TIME 96 9375
TEST_TIME 97 9339
TEST_TIME 98 9408
TEST_TIME 99 9399
TEST_TIME 100 9430
TEST_TIME 101 9412
TEST_TIME 102 9502
TEST_TIME 103 9477
TEST_TIME 104 9581
TEST_TIME 105 9513
TEST_TIME 106 9443
TEST_TIME 107 9417
TEST_TIME 108 9416
TEST_TIME 109 9368
TEST_TIME 110 9329
TEST_TIME 111 9324
TEST_TIME 112 9300
TEST_TIME 113 9255
TEST_TIME 114 9296
TEST_TIME 115 9280
TEST_TIME 116 9270
TEST_TIME 117 9294
TEST_TIME 118 9326
TEST_TIME 119 9315
TEST_TIME 120 9268

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2021 22:28:35 to 25-03-2021 22:28:38.

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 1532355 1532355 0 0.00 0 32925 6 0 0
doc_list_biud 1532355 1532355 0 0.00 0 23550 30 0 0
sp_add_invoice_to_stock 4986 4894 92 1.84 45 179995 17683 0 92
sp_cancel_adding_invoice 5804 5804 0 0.00 4 52683 747 0 0
sp_cancel_client_order 1698 1698 0 0.00 4 9503 367 0 0
sp_cancel_customer_reserve 570863 570863 0 0.00 1 23552 64 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 3 2050 61 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 3 6057 71 0 0
sp_cancel_supplier_invoice 6410 6397 13 0.20 2 17581 883 0 13
sp_cancel_supplier_order 382 382 0 0.00 6 1138557 120940 0 0
sp_cancel_write_off 10232 10232 0 0.00 1 15571 106 0 0
sp_client_order 19875 19875 0 0.00 3 55054 381 0 0
sp_customer_reserve 456086 456086 0 0.00 0 32108 174 0 0
sp_fill_shopping_cart 30289 30289 0 0.00 1 13114 35 0 0
sp_fill_shopping_cart_clo_res 456083 456083 0 0.00 0 14390 14 0 0
sp_get_clo_for_invoice 4887 4887 0 0.00 0 29421 331 0 0
sp_kill_cost_storno 17080 17080 0 0.00 0 6941 59 0 0
sp_kill_qstorno_ret_qs2qd 1158737 1158737 0 0.00 0 23547 35 0 0
sp_kill_qty_storno 610000 610000 0 0.00 0 23550 74 0 0
sp_lock_selected_doc 20200 20200 0 0.00 0 9442 5 0 0
sp_make_cost_storno 27107 27107 0 0.00 0 32912 54 0 0
sp_multiply_rows_for_pdistr 27107 27107 0 0.00 0 8088 27 0 0
sp_multiply_rows_for_qdistr 19875 19875 0 0.00 0 48146 164 0 0
sp_pay_from_customer 6781 6781 0 0.00 4 26829 93 0 0
sp_pay_to_supplier 5702 5702 0 0.00 5 13086 119 0 0
sp_payment_common 12483 12483 0 0.00 2 26668 27 0 0
sp_qd_handle_on_cancel_clo 1698 1698 0 0.00 0 8012 325 0 0
sp_qd_handle_on_invoice_upd_sts 10687 10687 0 0.00 0 15992 285 0 0
sp_qd_handle_on_reserve_upd_sts 9741 9741 0 0.00 0 14691 59 0 0
sp_reserve_write_off 9741 9741 0 0.00 6 32944 183 0 0
sp_supplier_invoice 5315 5315 0 0.00 6 71409 3116 0 0
sp_supplier_order 5106 5106 0 0.00 6 27086 1402 0 0
srv_aggregate_perf_data 106 106 0 0.00 2591 285274 18263 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1441 142053 33888 0 0
srv_find_qd_qs_mism 1064418 1064418 0 0.00 0 16408 5 0 0
srv_make_invnt_saldo 564 564 0 0.00 15 49610 1061 0 0
srv_make_money_saldo 784 784 0 0.00 0 3485 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 152454 475679 337267 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4894 4894 0 0.00 0 27874 158 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 9037 163 0 0
t$perf-norm:sp_cancel_client_order 1698 1698 0 0.00 0 1268 9 0 0
t$perf-norm:sp_cancel_customer_reserve 675 675 0 0.00 0 2461 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 1625 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 9139 31 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 1282 15 0 0
t$perf-norm:sp_cancel_supplier_order 382 382 0 0.00 0 31813 1916 0 0
t$perf-norm:sp_cancel_write_off 973 973 0 0.00 0 7778 16 0 0
t$perf-norm:sp_client_order 19875 19875 0 0.00 0 20522 19 0 0
t$perf-norm:sp_customer_reserve 972 972 0 0.00 0 2164 7 0 0
t$perf-norm:sp_pay_from_customer 6781 6781 0 0.00 0 9561 12 0 0
t$perf-norm:sp_pay_to_supplier 5702 5702 0 0.00 0 11734 17 0 0
t$perf-norm:sp_reserve_write_off 9741 9741 0 0.00 0 9569 13 0 0
t$perf-norm:sp_supplier_invoice 5315 5315 0 0.00 0 11804 20 0 0
t$perf-norm:sp_supplier_order 5106 5106 0 0.00 0 11243 20 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 2325 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 7057 49 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 3022 26 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 1115 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9950 9766 184 1.84 0 6123 18 0 184
v_all_customers 36854 36854 0 0.00 0 18 1 0 0
v_all_suppliers 29458 29458 0 0.00 0 24 1 0 0
v_all_wares 39744 39744 0 0.00 0 125 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 781 6 0 0
v_cancel_client_order 3396 3396 0 0.00 0 5151 8 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 384 3 0 0
v_cancel_customer_reserve 1350 1350 0 0.00 0 1346 5 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 355 4 0 0
v_cancel_supplier_invoice 850 824 26 3.05 0 1664 15 0 26
v_cancel_supplier_order 764 764 0 0.00 0 231 3 0 0
v_cancel_write_off 1946 1946 0 0.00 0 4624 18 0 0
v_max_id_clo_ord 5105 5105 0 0.00 0 620 1 0 0
v_max_id_clo_res 972 972 0 0.00 0 1808 11 0 0
v_max_id_ord_sup 5310 5310 0 0.00 0 4929 4 0 0
v_max_non_paid_invoice 1388 1388 0 0.00 0 1441 3 0 0
v_max_non_paid_realizn 3389 3389 0 0.00 0 1671 3 0 0
v_min_id_clo_ord 5105 5105 0 0.00 0 3991 6 0 0
v_min_id_clo_res 972 972 0 0.00 0 5813 15 0 0
v_min_id_ord_sup 5310 5310 0 0.00 0 2560 7 0 0
v_min_non_paid_invoice 5702 5702 0 0.00 0 12870 16 0 0
v_min_non_paid_realizn 6781 6781 0 0.00 0 6456 14 0 0
v_our_firm 9674 9674 0 0.00 0 12 1 0 0
v_reserve_write_off 19482 19482 0 0.00 0 6309 6 0 0
x_lock_depdocs_on_canc_invoice 11789 11789 0 0.00 0 9811 109 0 0
x_lock_depdocs_on_canc_sup_ord 382 382 0 0.00 0 13942 342 0 0
x_make_qstorno_1000_1200 5106 5106 0 0.00 2 27031 1328 0 0
x_make_qstorno_1200_2000 5315 5315 0 0.00 3 71399 2988 0 0
x_make_qstorno_2100_3300 456086 456086 0 0.00 0 32105 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2021 22:28:39 to 25-03-2021 22:28:43.

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:25 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:31 32635 8192000000 10301702960 10611892224 940184880 10.295 71 58 115 0 961276688 2759424 18332384
19:58:15 23032 8192000000 10358821040 10674241536 1405490672 14.644 100 90 180 0 1440626688 5896448 29239568
19:58:48 38721 8192000000 10397327248 10721554432 1447933904 15.020 100 90 180 0 1484569856 7144832 29491120
19:59:39 17334 8192000000 10415460448 10741182464 1467143600 15.189 100 85 170 0 1502779616 7868896 27767120
20:00:05 24522 8192000000 10427603904 10759716864 1484281984 15.339 100 90 180 2 1521720624 8570224 28868416
20:00:39 9941 8192000000 10440720848 10775863296 1498235808 15.461 100 81 162 0 1532673136 8688192 25749136
20:01:01 25199 8192000000 10466298656 10807795712 1519989568 15.650 100 84 168 1 1555101840 9052016 26060256
20:01:39 23356 8192000000 10510514688 10853740544 1559344576 15.991 100 88 176 1 1596370736 9636128 27390032
20:02:09 11572 8192000000 10514242864 10867548160 1578346992 16.154 100 83 166 0 1614410096 9991296 26071808
20:02:29 15745 8192000000 10542322592 10896146432 1592663888 16.277 100 75 150 0 1625624176 9438080 23522208
20:02:54 14797 8192000000 10579756384 10933596160 1627582352 16.574 100 88 174 0 1664798224 10398608 26817264
20:03:19 10217 8192000000 10595706416 10957778944 1658356528 16.835 100 85 170 2 1695416144 11462480 25597136
20:03:38 8481 8192000000 10614397568 10978910208 1673462240 16.962 100 79 158 2 1709486848 12198432 23826176
20:03:55 8897 8192000000 10638108656 11005399040 1694722128 17.141 100 78 156 1 1730050880 12485008 22843744
20:04:14 8902 8192000000 10657086880 11026210816 1714864208 17.309 100 83 166 1 1752099376 13618304 23616864
20:04:32 5544 8192000000 10672849104 11045376000 1732824416 17.459 100 87 173 0 1771884608 14182912 24877280
20:04:45 6367 8192000000 10676714208 11052003328 1739473344 17.514 100 86 173 2 1778844528 14185136 25186048
20:04:58 8053 8192000000 10683567072 11062267904 1749530272 17.598 100 74 148 1 1783672384 13105952 21036160
20:05:15 4489 8192000000 10693566672 11075592192 1761600528 17.698 100 75 150 2 1794771872 12377568 20793776
20:05:27 6197 8192000000 10711071456 11091296256 1773520192 17.796 100 77 151 2 1807014336 12688848 20805296
20:05:40 4669 8192000000 10726581600 11107110912 1787240256 17.909 100 79 154 2 1821095696 12329024 21526416
20:05:52 4920 8192000000 10726462800 11104706560 1784841568 17.889 100 78 156 1 1820180160 13282960 22055632
20:06:09 3617 8192000000 10715897744 11100884992 1791639264 17.945 100 72 144 1 1824056432 12509072 19908096
20:06:21 2619 8192000000 10737350896 11127099392 1791659680 17.945 100 73 145 2 1824504912 12862672 19982560
20:06:31 2984 8192000000 10744992032 11135430656 1812234864 18.114 100 82 162 1 1847857136 12456672 23165600
20:06:41 3467 8192000000 10768589232 11155767296 1823635904 18.207 100 88 176 0 1861135216 13143136 24356176
20:06:51 3579 8192000000 10768502096 11153780736 1827657904 18.240 100 91 180 3 1867328592 14777568 24893120
20:07:01 2304 8192000000 10783460736 11168837632 1835113584 18.301 100 92 185 2 1875481968 14902240 25466144
20:07:10 2908 8192000000 10782529872 11167285248 1836777360 18.315 100 94 190 0 1878154480 14641520 26735600
20:07:19 2754 8192000000 10785942144 11169820672 1841191680 18.351 100 91 182 0 1880218848 14575840 24451328
20:07:28 3798 8192000000 10777730048 11165773824 1837077584 18.317 100 82 165 1 1874981840 13400336 24503920
20:07:39 1966 8192000000 10783618608 11169984512 1842323248 18.360 100 85 168 0 1878417392 12532992 23561152
20:07:48 1969 8192000000 10786520128 11175120896 1847878864 18.405 100 89 178 2 1887021248 12855664 26286720
20:07:56 2666 8192000000 10797871920 11183943680 1854846512 18.461 100 85 168 1 1890872608 12338224 23687872
20:08:05 2232 8192000000 10798759136 11191365632 1860458896 18.507 100 90 181 0 1900129056 13159152 26511008
20:08:14 2356 8192000000 10801338544 11192864768 1862124016 18.520 100 92 184 1 1900128832 11992448 26012368
20:08:23 2656 8192000000 10816853488 11203936256 1865557008 18.548 100 91 180 1 1904981584 13906688 25517888
20:08:32 1864 8192000000 10811160896 11200835584 1867672864 18.565 100 92 186 1 1907043552 13115168 26255520
20:08:41 1894 8192000000 10813039856 11202707456 1867275584 18.562 100 89 179 0 1905564848 13192784 25096480
20:08:49 2082 8192000000 10816095584 11205828608 1869726448 18.582 100 90 180 1 1908493120 13127520 25639152
20:08:57 26799 8192000000 10789559936 11199074304 1866544576 18.556 100 58 117 1 1893466432 10193408 16728448
20:09:31 8513 8192000000 10816588704 11207651328 1874918048 18.624 100 69 139 1 1902341856 7931872 19491936
20:09:47 16561 8192000000 10806763744 11208085504 1873924928 18.616 100 68 134 0 1903395648 10361312 19109408
20:10:10 1870 8192000000 10828962560 11221524480 1884479264 18.701 100 94 188 1 1924708016 13201408 27027344
20:10:18 4931 8192000000 10827894944 11222147072 1886661264 18.719 100 79 158 1 1922221184 13049136 22510784
20:10:29 7691 8192000000 10786967984 11214467072 1876884560 18.640 100 44 88 0 1899274016 9948096 12441360
20:10:46 4752 8192000000 10787792000 11216228352 1879118272 18.658 100 39 78 1 1899105712 8623040 11364400
20:10:58 6345 8192000000 10788613184 11215347712 1878324928 18.652 100 28 56 1 1893601568 6974432 8302208
20:11:13 6119 8192000000 10794179152 11221020672 1882517328 18.685 100 27 54 1 1896918752 6110768 8290656
20:11:26 4725 8192000000 10798039952 11224440832 1882720912 18.687 100 28 56 0 1897416880 6842400 7853568
20:11:37 5937 8192000000 10798709712 11224432640 1887610096 18.727 100 29 55 3 1901845616 5833056 8402464
20:11:51 4854 8192000000 10789943792 11224526848 1886715440 18.719 100 27 53 0 1900595744 6278464 7601840
20:12:02 11626 8192000000 10791677664 11224829952 1890660032 18.751 100 22 44 1 1902733440 5877376 6196032
20:12:20 5847 8192000000 10799710304 11232014336 1892255168 18.764 100 23 46 0 1904879872 6672752 5951952
20:12:32 8768 8192000000 10806102192 11235831808 1894189328 18.780 100 22 42 2 1905004384 5396304 5418752
20:12:49 6149 8192000000 10804356800 11238682624 1896429616 18.798 100 24 48 0 1909732768 6256672 7046480
20:13:01 10866 8192000000 10808621488 11240861696 1900813216 18.833 100 24 48 2 1914820560 6124144 7883200
20:13:24 8290 8192000000 10804637968 11242700800 1901320848 18.837 100 21 43 4 1913915936 6575056 6020032
20:13:38 8298 8192000000 10809770048 11246305280 1904875616 18.865 100 33 66 1 1920468160 6507488 9085056
20:13:56 6437 8192000000 10812948656 11252084736 1906630976 18.880 100 27 52 1 1921624368 7691488 7301904
20:14:10 11061 8192000000 10827144704 11257278464 1916739104 18.961 100 48 95 3 1937773408 5926688 15107616
20:14:32 67138 8192000000 10860613760 11269709824 1916164704 18.956 100 44 88 0 1935893024 5762720 13965600
20:15:46 4248 8192000000 10838651488 11267457024 1916423920 18.958 100 46 91 0 1939024912 10224624 12376368
20:15:57 5123 8192000000 10828813888 11265380352 1913094512 18.931 100 30 62 0 1928340080 6272944 8972624
20:16:12 6690 8192000000 10830961904 11262926848 1914350608 18.942 100 28 55 2 1930292640 7856080 8085952
20:16:25 4080 8192000000 10829716256 11262042112 1909205440 18.900 100 34 68 1 1925803472 6765168 9832864
20:16:38 8067 8192000000 10821045296 11253731328 1907473952 18.886 100 32 65 1 1923372400 6705552 9192896
20:16:52 5593 8192000000 10827775728 11247906816 1870779088 18.591 98 26 51 0 1883696528 5061296 7856144
20:17:06 5122 8192000000 10814105056 11244421120 1897452256 18.806 100 28 56 0 1912042688 6094256 8496176
20:17:18 4400 8192000000 10800218576 11226578944 1868110384 18.569 98 40 81 0 1886717728 6409056 12198288
20:17:28 13856 8192000000 10789615296 11223871488 1838061632 18.325 97 16 33 1 1848140752 5357632 4721488
20:17:49 10679 8192000000 10807207184 11241570304 1887552640 18.726 100 21 41 3 1898536736 5229840 5754256
20:18:06 43965 8192000000 10787693520 11217260544 1829741648 18.257 97 24 48 2 1842036128 5698672 6595808
20:19:01 16743 8192000000 10779074400 11206115328 1805759104 18.061 96 31 62 2 1820396784 6367520 8270160
20:19:26 4805 8192000000 10777530864 11193950208 1835548448 18.305 99 47 93 3 1856479024 7377568 13553008
20:19:38 6719 8192000000 10744235840 11165761536 1768129488 17.752 96 30 58 2 1783488848 6202240 9157120
20:19:53 6081 8192000000 10716461472 11144785920 1762394272 17.704 97 25 49 1 1776352528 6288928 7669328
20:20:06 4922 8192000000 10690048032 11103645696 1758408832 17.671 97 26 52 1 1771987808 6244992 7333984
20:20:18 9459 8192000000 10715915648 11130683392 1747493184 17.581 97 29 58 1 1762852016 6626384 8732448
20:20:36 5632 8192000000 10676849360 11094683648 1749297088 17.596 98 28 56 1 1764235024 6246416 8691520
20:20:48 10676 8192000000 10700945744 11108257792 1693898032 17.134 94 29 58 3 1708667952 6276992 8492928
20:21:11 10305 8192000000 10690050832 11105513472 1757612624 17.665 98 24 48 0 1769815952 4727232 7476096
20:21:27 6323 8192000000 10725387392 11146547200 1811574496 18.109 100 24 48 1 1824681216 6223728 6882992
20:21:40 10511 8192000000 10719486352 11142975488 1808792304 18.086 100 22 44 1 1820605616 5569568 6243744
20:21:59 11289 8192000000 10722414176 11136409600 1770622880 17.772 98 22 44 1 1782031040 4856768 6551392
20:22:18 16413 8192000000 10732906816 11141570560 1768662352 17.756 97 33 67 2 1783738304 4811360 10264592
20:22:42 65248 8192000000 10722942576 11143036928 1752976672 17.626 96 38 76 4 1768812000 5046656 10788672
20:23:53 10004 8192000000 10746345040 11165913088 1825583968 18.223 100 33 66 1 1841034016 5694432 9755616
20:24:12 4962 8192000000 10751277232 11171090432 1828378592 18.246 100 34 68 0 1849342400 11404304 9559504
20:24:25 4758 8192000000 10759684560 11178852352 1839719232 18.339 100 33 66 2 1856632608 7843776 9069600
20:24:37 6763 8192000000 10754740992 11182252032 1841829312 18.356 100 23 46 2 1854937936 6694128 6414496
20:24:50 7478 8192000000 10758439200 11187961856 1846597744 18.394 100 19 38 0 1857295856 5487552 5210560
20:25:03 7278 8192000000 10762143360 11189858304 1850951968 18.430 100 21 44 1 1862490176 5300144 6238064
20:25:20 6605 8192000000 10769563280 11197419520 1853858304 18.453 100 20 40 1 1865163040 5299968 6004768
20:25:33 12868 8192000000 10774658144 11200774144 1857891008 18.486 100 20 39 1 1869630320 6248432 5490880
20:25:54 7712 8192000000 10773209776 11203289088 1861766672 18.518 100 15 30 1 1871251024 5609472 3874880
20:26:12 11340 8192000000 10770668112 11206967296 1864330192 18.538 100 18 35 1 1875539040 5482976 5725872
20:26:31 15023 8192000000 10782735344 11213778944 1865677600 18.549 100 16 32 2 1876151984 5779552 4694832
20:26:53 13111 8192000000 10782918976 11216998400 1869939792 18.584 100 13 25 1 1878939024 4859520 4139712
20:27:13 67068 8192000000 10836157440 11254190080 1893932336 18.777 100 36 72 1 1909891984 5193184 10766464
20:28:29 5895 8192000000 10849117728 11264815104 1910639600 18.912 100 59 119 1 1935313360 8903840 15769920
20:28:42 12108 8192000000 10855277744 11272572928 1917541792 18.967 100 61 122 1 1944637840 10289952 16806096
20:29:07 16349 8192000000 10859412848 11276615680 1917702400 18.968 100 56 109 1 1942995888 10033696 15259792
20:29:35 10308 8192000000 10871977632 11286728704 1929867872 19.066 100 72 144 1 1962750960 12954176 19928912
20:29:54 14303 8192000000 10860390464 11289636864 1931851968 19.082 100 62 124 1 1961207360 11716240 17639152
20:30:23 11176 8192000000 10871305744 11297443840 1938359744 19.134 100 61 121 0 1966326672 10701312 17265616
20:30:42 7313 8192000000 10875645776 11302969344 1940809824 19.153 100 58 114 2 1968003424 10398112 16795488
20:30:57 10345 8192000000 10882415264 11308797952 1931933264 19.082 99 59 118 2 1960463920 11707424 16823232
20:31:16 17796 8192000000 10887330720 11314388992 1948441424 19.214 100 54 108 0 1976199504 12347296 15410784
20:31:45 12035 8192000000 10899886240 11322294272 1957819744 19.289 100 63 125 0 1989275840 13739072 17717024
20:32:04 24393 8192000000 10911530208 11333455872 1966849296 19.360 100 63 126 1 1998638352 13569568 18219488
20:32:42 21866 8192000000 10910050544 11340136448 1971967872 19.401 100 59 117 2 2006561168 17333712 17259584
20:33:18 50794 8192000000 10908287360 11348717568 1974271344 19.419 100 36 71 3 1999026672 13833456 10921872
20:34:20 32685 8192000000 10925882224 11366981632 1981445136 19.476 100 45 90 1 2015472816 20191872 13835808
20:34:59 19519 8192000000 10942884832 11376545792 1988525136 19.532 100 43 86 0 2023948544 22321296 13102112
20:35:32 10953 8192000000 10945625312 11384877056 1996464944 19.595 100 48 96 0 2036322512 25852512 14005056
20:36:09 5268 8192000000 10953710656 11389267968 2001964944 19.638 100 44 88 1 2040690960 25443888 13282128
20:36:24 7999 8192000000 10962730848 11393765376 2007492272 19.682 100 61 121 1 2052409328 26137632 18779424
20:36:40 6402 8192000000 10958746320 11383414784 1971819680 19.400 98 65 129 1 2018859200 27577376 19462144
20:36:56 6593 8192000000 10958945216 11387838464 2002679760 19.644 100 57 114 3 2047797296 27832224 17285312
20:37:11 17258 8192000000 10960925392 11397795840 2009329008 19.696 100 49 96 1 2052053536 27898656 14825872
20:37:37 7038 8192000000 10974052832 11406569472 2012645632 19.722 100 50 100 1 2060714976 32494160 15575184
20:37:51 4891 8192000000 10976097216 11403071488 2007601712 19.683 100 61 123 1 2060345088 33620560 19122816
20:38:05 3860 8192000000 10986694672 11412205568 2016617648 19.754 100 67 134 1 2068549664 31225856 20706160
20:38:17 2360 8192000000 10983406368 11413020672 2021487648 19.792 100 69 136 3 2074816096 31859424 21469024
20:38:28 6920 8192000000 10974439552 11409371136 2015568272 19.745 100 59 116 1 2066436880 31973232 18895376
20:38:45 10741 8192000000 10982178848 11418214400 2017453536 19.760 100 56 112 1 2066730512 31844560 17432416
20:39:03 6911 8192000000 10977210480 11405189120 2007236048 19.680 99 62 124 4 2060810768 33753744 19820976
20:39:24 3309 8192000000 10988893072 11416248320 2016224096 19.750 100 75 150 0 2078010128 38263184 23522848
20:39:34 2926 8192000000 10994390704 11417223168 2015681824 19.746 100 71 140 1 2076678656 39671072 21325760
20:39:46 6232 8192000000 10994872112 11424927744 2023159728 19.805 100 70 138 2 2084749936 39772816 21817392
20:40:04 3313 8192000000 10985753072 11420995584 2019145120 19.773 100 55 110 0 2074743696 37890944 17707632
20:40:14 1856 8192000000 11003309984 11423248384 2020702992 19.786 100 78 155 0 2085509328 39488320 25318016
20:40:25 2351 8192000000 10976064640 11391152128 1982821728 19.487 98 74 148 1 2047144128 40794032 23528368
20:40:36 8060 8192000000 10995854560 11423055872 2015534912 19.745 100 81 161 1 2082871904 41972992 25364000
20:40:54 9268 8192000000 11005109840 11430973440 2021218944 19.790 100 68 136 1 2088114640 45094176 21801520
20:41:16 15173 8192000000 11009260656 11445592064 2028716624 19.849 100 64 128 1 2095723984 46476864 20530496
20:41:51 6139 8192000000 11003835584 11435515904 2005469312 19.666 99 54 106 1 2070479696 47418544 17591840
20:42:05 3362 8192000000 11000358928 11433291776 2017595264 19.761 100 61 122 0 2085925408 48125344 20204800
20:42:15 8329 8192000000 10987591216 11418218496 2003532528 19.651 99 61 122 1 2071081104 47930976 19617600
20:42:35 7215 8192000000 11024820336 11454930944 2032463600 19.878 100 69 138 1 2105445536 49876480 23105456
20:43:02 2688 8192000000 10996729792 11428585472 2005996112 19.670 99 60 120 1 2066968000 42070992 18900896
20:43:14 8296 8192000000 10988555856 11417251840 1979963232 19.464 98 73 145 2 2045906800 43017696 22925872
20:43:29 2451 8192000000 11013402896 11433201664 2014531152 19.737 100 83 164 1 2087429824 47259024 25639648
20:43:42 4180 8192000000 11002383072 11429019648 1999865888 19.622 99 75 150 0 2071615680 48645664 23104128
20:43:54 4616 8192000000 10987792720 11415994368 1995598688 19.588 99 65 130 0 2066614112 50403248 20612176
20:44:08 2342 8192000000 10981992016 11396321280 1980903216 19.472 98 86 172 0 2056753840 49011536 26839088
20:44:17 1647 8192000000 11000483440 11420549120 1993998672 19.575 99 81 159 2 2069287056 49421088 25867296
20:44:26 1441 8192000000 11001684320 11413663744 1997201024 19.601 100 87 174 2 2076088592 51232976 27654592
20:44:36 1459 8192000000 10996474656 11412434944 1997564624 19.604 100 85 170 2 2073811584 49029440 27217520
20:44:50 5866 8192000000 10982884672 11422801920 2004110080 19.655 100 57 112 1 2069139520 46942560 18086880
20:45:04 10145 8192000000 10988019664 11429879808 2009931456 19.701 100 53 106 0 2075209968 48183584 17094928
20:45:22 16221 8192000000 10981494736 11422769152 1990814240 19.550 99 46 90 2 2052992912 46876304 15302368
20:45:48 8630 8192000000 10982859104 11420778496 2000923200 19.630 100 46 93 5 2061849104 46129168 14796736
20:46:10 4493 8192000000 10972855552 11410239488 1980824080 19.471 99 58 116 3 2048597792 48636480 19137232
20:46:21 9771 8192000000 10968213632 11408216064 1985595424 19.509 100 48 96 0 2052764480 50547120 16621936
20:46:58 2334 8192000000 10995802496 11424059392 2005806352 19.668 100 79 155 0 2079203616 48204592 25192672
20:47:09 16923 8192000000 10946045232 11392442368 1950169552 19.228 98 48 96 2 2013697408 47633840 15894016
20:47:34 16672 8192000000 10933484992 11372720128 1928442480 19.054 98 44 88 0 1994193856 50758720 14992656
20:47:57 10125 8192000000 10938920880 11381260288 1940597520 19.152 99 35 70 1 2007737456 54581392 12558544
20:48:17 6699 8192000000 10947221344 11383693312 1953698016 19.256 100 51 102 2 2024971200 53280000 17993184
20:48:39 10371 8192000000 10948943680 11386683392 1945867088 19.194 99 51 101 1 2016289216 53127168 17294960
20:48:58 2231 8192000000 10981234304 11409072128 1976343680 19.436 100 67 134 1 2056211248 57474704 22392864
20:49:11 6529 8192000000 10951886784 11388145664 1942565856 19.167 99 55 110 2 2017784288 56890192 18328240
20:49:37 17484 8192000000 10938291184 11385024512 1942335248 19.165 99 33 66 0 2008752800 54840752 11576800
20:50:02 14268 8192000000 10944424096 11389280256 1932179360 19.084 98 40 80 1 2003915936 57557616 14178960
20:50:31 24575 8192000000 10946198448 11394138112 1945471728 19.190 99 32 62 1 2013710832 56483984 11755120
20:51:07 18985 8192000000 10907464832 11360923648 1931583968 19.080 99 27 54 0 1994641152 52993680 10063504
20:51:33 26894 8192000000 10927860320 11380019200 1949465664 19.222 100 32 62 2 2012969776 51741616 11762496
20:52:28 27401 8192000000 10913080976 11372572672 1942555568 19.167 100 19 38 0 1999941424 50301104 7084752
20:53:13 20989 8192000000 10929963680 11387609088 1941048592 19.155 100 18 36 1 2002341424 54305552 6987280
20:53:43 13090 8192000000 10907493824 11364827136 1919555744 18.983 99 19 37 2 1976815136 50826912 6432480
20:54:02 20886 8192000000 10883329696 11349585920 1919228208 18.981 100 15 30 0 1959061840 34297264 5536368
20:54:35 74681 8192000000 10872434720 11334520832 1903805680 18.857 99 14 26 2 1939619664 31653616 4160368
20:56:23 46076 8192000000 10902035840 11355566080 1941878128 19.162 100 20 40 1 1968888896 20602080 6408688
20:57:38 2296 8192000000 10920473824 11355271168 1952189584 19.244 99 57 114 3 1982584576 13703696 16691296
20:57:59 38433 8192000000 10925138720 11376783360 1976968768 19.441 100 41 80 0 2004674336 16196016 11509552
20:58:50 17569 8192000000 10921321584 11384315904 1980347632 19.467 100 28 56 1 2008140640 19671328 8121680
20:59:14 95951 8192000000 10879342272 11343302656 1910628672 18.912 97 17 34 1 1932254672 16432528 5193472
21:01:04 24711 8192000000 10887074352 11340775424 1933340560 19.094 99 29 60 0 1954403808 12442784 8620464
21:01:35 74595 8192000000 10870260688 11338330112 1891355792 18.757 97 10 21 0 1907120224 13048176 2716256
21:03:26 61822 8192000000 10878980144 11347087360 1932735952 19.089 99 8 16 0 1946178832 11358208 2084672
21:04:39 50550 8192000000 10852080976 11334283264 1903991136 18.858 98 17 34 0 1923717920 14577472 5149312
21:05:35 99702 8192000000 10871888624 11325956096 1917429456 18.966 99 20 40 0 1933527552 10803952 5294144
21:07:26 66404 8192000000 10861882480 11315023872 1918593312 18.976 99 34 68 2 1935543728 7034576 9915840
21:08:44 16911 8192000000 10884628336 11320926208 1924489056 19.023 99 53 106 1 1947520160 8142096 14889008
21:09:09 5028 8192000000 10894726416 11343634432 1953894416 19.257 100 64 128 1 1986194224 14009904 18289904
21:09:33 32192 8192000000 10898778416 11348799488 1938472080 19.135 99 43 85 0 1963940080 13272304 12195696
21:10:13 71694 8192000000 10858800512 11333677056 1903502032 18.854 98 22 44 1 1926553584 16687648 6363904
21:11:32 102653 8192000000 10878980144 11353452544 1920940464 18.994 99 6 12 1 1936073808 13873984 1259360
21:13:21 45040 8192000000 10874651392 11353448448 1949977008 19.226 100 8 16 0 1972240416 19842064 2421344
21:14:14 67211 8192000000 10893352912 11356536832 1959713600 19.304 100 23 46 1 1980869920 14033744 7122576
21:16:16 60905 8192000000 10877296816 11364728832 1959154128 19.299 100 9 19 0 1970187872 8712224 2321520
21:17:29 85662 8192000000 10881997056 11362902016 1931946672 19.082 98 19 38 0 1948029632 11075984 5006976
21:19:02 86168 8192000000 10896856864 11375423488 1972835184 19.408 100 21 42 1 1988735920 10039056 5861680
21:20:34 78133 8192000000 10904859776 11384889344 1979943680 19.464 100 17 34 4 1995731568 10684032 5103856
21:22:01 33200 8192000000 10914983312 11379019776 1967437968 19.365 99 21 42 0 1983503200 10384896 5680336
21:22:40 38810 8192000000 10915683264 11391016960 1985579088 19.509 100 20 40 0 2007254656 16020736 5654832
21:23:25 130660 8192000000 10918026800 11388739584 1945518992 19.191 98 13 26 1 1967019472 18356624 3143856
21:25:42 73140 8192000000 10943675200 11396812800 1968566272 19.374 99 18 36 0 1982349568 8459600 5323696
21:27:03 31540 8192000000 10947890912 11406323712 2000914624 19.630 100 32 62 0 2025987680 16600256 8472800
21:27:41 83788 8192000000 10922214992 11391279104 1955451040 19.270 98 21 42 0 1977383440 16433184 5499216
21:29:17 93740 8192000000 10923924784 11393884160 1996841184 19.598 100 28 56 2 2016180464 11233168 8106112
21:31:14 35204 8192000000 10927055568 11409104896 1987222464 19.522 99 39 80 0 2011593200 13594144 10776592
21:32:23 44204 8192000000 10900780720 11381903360 1973611472 19.414 99 13 26 2 1986599920 9498016 3490432
21:33:13 22345 8192000000 10905001216 11383889920 1971534576 19.398 99 7 14 0 1982587216 9338624 1714016
21:35:00 78868 8192000000 10927405232 11412054016 1968483232 19.373 99 12 23 1 1987272688 14378752 4410704
21:36:29 59713 8192000000 10920226704 11401932800 1989919552 19.543 100 10 17 1 2010976256 18926960 2129744
21:37:36 24060 8192000000 10887984864 11360600064 1913974816 18.939 96 17 32 3 1925018192 6323424 4719952
21:38:06 29692 8192000000 10893087648 11353157632 1921591824 19.000 97 39 78 1 1942099600 8874656 11633120
21:38:54 30470 8192000000 10879324096 11345969152 1919602576 18.984 98 28 55 1 1935734144 8184864 7946704
21:39:43 31522 8192000000 10870422288 11342233600 1917747008 18.969 98 21 42 0 1932308800 8785248 5776544
21:40:29 36785 8192000000 10882135648 11325014016 1893675888 18.775 97 36 68 2 1916144624 12768976 9699760
21:41:13 49063 8192000000 10864051968 11323359232 1888094144 18.730 97 21 42 1 1905543840 11778640 5671056
21:42:50 68146 8192000000 10875727328 11352219648 1907175648 18.884 98 19 38 2 1924312320 11894640 5242032
21:44:08 25674 8192000000 10858470048 11328045056 1889348224 18.741 97 19 38 2 1905753760 11521808 4883728
21:44:55 34720 8192000000 10877007888 11327160320 1915375792 18.950 99 18 36 1 1929607264 9692256 4539216
21:45:44 48174 8192000000 10879300240 11342295040 1943693216 19.176 100 25 50 0 1963827392 12856400 7277776
21:46:45 65638 8192000000 10876736384 11328454656 1892984624 18.770 97 23 45 1 1908456048 9545824 5925600
21:48:02 27077 8192000000 10875473456 11328987136 1896034640 18.794 98 31 62 2 1914822960 10506080 8282240
21:48:42 64196 8192000000 10816652720 11294601216 1831029088 18.268 95 28 56 1 1850474352 11768640 7676624
21:50:46 63522 8192000000 10868333664 11337883648 1939268464 19.141 100 28 56 2 1959669392 12374064 8026864
21:51:55 69858 8192000000 10905047840 11370434560 1961643744 19.319 100 28 56 2 1989961168 19745360 8572064
21:53:19 77225 8192000000 10850122176 11336499200 1910536032 18.911 98 15 30 1 1931964352 16925248 4503072
21:54:42 37695 8192000000 10859744736 11335499776 1915020304 18.947 99 14 28 3 1934100224 15293664 3786256
21:55:26 93230 8192000000 10853387600 11340840960 1874249552 18.619 97 15 30 2 1895805824 17879200 3677072
21:57:06 58839 8192000000 10851212912 11324563456 1913653776 18.936 99 9 16 2 1925693248 10157968 1881504
21:58:13 80577 8192000000 10858556928 11327070208 1841343184 18.352 95 9 18 0 1849950800 6829088 1778528
21:59:47 26756 8192000000 10865297136 11327709184 1924516000 19.023 99 30 60 0 1941649744 8785856 8347888
22:00:21 56783 8192000000 10876676608 11350806528 1932768368 19.089 99 24 48 0 1950008768 10526256 6714144
22:01:25 40068 8192000000 10880302048 11346726912 1931951520 19.082 99 12 24 2 1943210208 7928528 3330160
22:02:11 18359 8192000000 10897187808 11359039488 1968678672 19.375 100 61 120 3 1994560704 8651488 17230544
22:02:35 40669 8192000000 10898815808 11362426880 1945906432 19.194 99 23 45 2 1962040064 9589600 6544032
22:03:25 50743 8192000000 10898285120 11353772032 1890028784 18.746 96 26 52 0 1906807184 9456992 7321408
22:04:27 37232 8192000000 10893574224 11370770432 1968781120 19.376 100 36 69 3 1988487824 9517760 10188944
22:06:02 40182 8192000000 10894817056 11374133248 1932392368 19.086 98 10 20 1 1949247936 14191824 2663744
22:06:49 69592 8192000000 10908132416 11381510144 1974531520 19.421 100 13 26 2 1987125552 8991200 3602832
22:08:14 59971 8192000000 10914927616 11389988864 1911228784 18.917 96 42 82 1 1940865456 18713072 10923600
22:09:31 88331 8192000000 10910021792 11382194176 1907197616 18.884 97 5 10 0 1921045136 12920160 927360
22:11:53 142052 8192000000 10891825504 11367124992 1878670368 18.654 95 21 42 1 1898524848 13389664 6464816
22:14:50 41121 8192000000 10887645696 11377324032 1957019648 19.282 99 17 34 0 1970739952 9087504 4632800
22:15:46 66839 8192000000 10878285296 11370115072 1929156480 19.060 98 7 14 0 1937733712 6787360 1789872
22:17:00 73945 8192000000 10898399808 11389362176 1975822816 19.432 100 21 42 0 1991414192 9668512 5922864
22:18:37 75495 8192000000 10846772768 11325997056 1852024688 18.439 94 16 32 1 1874168400 18118640 4025072
22:20:03 79820 8192000000 10860357520 11353706496 1926686672 19.040 99 10 20 1 1940662544 11196032 2779840
22:21:30 38125 8192000000 10868287072 11354710016 1895904128 18.793 97 6 12 0 1908860848 11333712 1623008
22:22:14 28209 8192000000 10878718720 11351719936 1929816336 19.065 99 21 42 1 1943082624 7148064 6118224
22:22:54 55426 8192000000 10887384336 11355541504 1918943952 18.978 98 19 38 0 1933147264 8810848 5392464
22:23:57 39424 8192000000 10883199152 11364691968 1944179456 19.180 99 28 56 0 1961397664 9381248 7836960
22:24:45 46156 8192000000 10885884352 11363897344 1923565872 19.015 98 23 46 0 1940541696 10426496 6549328
22:25:41 49391 8192000000 10867134320 11339620352 1866035104 18.552 95 19 38 0 1880170064 9108896 5026064
22:26:36 29402 8192000000 10897299616 11358818304 1947858832 19.209 100 44 88 1 1972834864 12497584 12478448
22:27:13 29418 8192000000 9127559936 9354084352 286815664 3.382 15 3 6 0 294554416 7343136 395616

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-03-2021 22:28:45 to 25-03-2021 22:29:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2021 22:29:17 to 25-03-2021 22: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          233932
MON$OLDEST_ACTIVE               234580
MON$OLDEST_SNAPSHOT             234580
MON$NEXT_TRANSACTION            234580
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2003456
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.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 ---
:291: 
:292: mscs-test-161.budzdorov.ru    Thu Mar 25 22:27:46 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.03.21 22: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-03-25 22:29:22 No severe PSQL-related problems occured
25.03.21 22:29:23. End of report.