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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17495104 kB
MemAvailable 31507312 kB
Buffers 0 kB
Cached 14149920 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 19:27:22
DTS_END                         2021-03-21 19:27:22.8940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44150
TRN_ID                          240775
ATT_ID                          708
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: 9552.45 20242 1146294
customer order: creation 177.61 374 21313
customer order: refuse 15.44 338 1853
order to supplier: creation 47.56 1269 5707
order to supplier: removal 3.50 103030 420
invoice (draft): creation 46.04 3207 5525
invoice (draft): removal 53.78 713 6453
invoice accept: apply 41.97 18427 5036
invoice accept: cancel 49.10 802 5892
customer reserve: creation 3944.73 180 473368
customer reserve: removal 4863.73 59 583648
realization accept: apply 85.22 156 10226
realization accept: cancel 91.81 117 11017
payment from customer: creation 61.08 111 7329
payment from customer: removal 5.92 65 710
payment to supplier: creation 49.25 143 5910
payment to supplier: removal 3.53 47 423
service: total inventory turnovers 4.82 1044 578
service: total monetary turnovers 6.53 42 784
service: aggregate perf. data 0.82 23417 98
service: refresh index statistics 0.03 251294 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-03-2021 19:28:09 to 21-03-2021 19:28:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4393
TEST_TIME 2 4561
TEST_TIME 3 4040
TEST_TIME 4 5132
TEST_TIME 5 4604
TEST_TIME 6 4810
TEST_TIME 7 4995
TEST_TIME 8 5055
TEST_TIME 9 4998
TEST_TIME 10 5052
TEST_TIME 11 5312
TEST_TIME 12 5562
TEST_TIME 13 5977
TEST_TIME 14 6092
TEST_TIME 15 6454
TEST_TIME 16 6780
TEST_TIME 17 7077
TEST_TIME 18 7620
TEST_TIME 19 8319
TEST_TIME 20 8662
TEST_TIME 21 8966
TEST_TIME 22 9532
TEST_TIME 23 9757
TEST_TIME 24 10300
TEST_TIME 25 10690
TEST_TIME 26 10689
TEST_TIME 27 10804
TEST_TIME 28 10782
TEST_TIME 29 10569
TEST_TIME 30 10381
TEST_TIME 31 10361
TEST_TIME 32 10193
TEST_TIME 33 10195
TEST_TIME 34 10137
TEST_TIME 35 10032
TEST_TIME 36 9957
TEST_TIME 37 10073
TEST_TIME 38 10042
TEST_TIME 39 9935
TEST_TIME 40 9917
TEST_TIME 41 9815
TEST_TIME 42 9681
TEST_TIME 43 9678
TEST_TIME 44 9770
TEST_TIME 45 9755
TEST_TIME 46 9675
TEST_TIME 47 9831
TEST_TIME 48 9918
TEST_TIME 49 9964
TEST_TIME 50 9878
TEST_TIME 51 9992
TEST_TIME 52 10041
TEST_TIME 53 10018
TEST_TIME 54 10218
TEST_TIME 55 10170
TEST_TIME 56 10219
TEST_TIME 57 10276
TEST_TIME 58 10138
TEST_TIME 59 10030
TEST_TIME 60 10030
TEST_TIME 61 9945
TEST_TIME 62 10014
TEST_TIME 63 9943
TEST_TIME 64 9885
TEST_TIME 65 9814
TEST_TIME 66 9828
TEST_TIME 67 9771
TEST_TIME 68 9774
TEST_TIME 69 9778
TEST_TIME 70 9783
TEST_TIME 71 9884
TEST_TIME 72 9814
TEST_TIME 73 9802
TEST_TIME 74 9802
TEST_TIME 75 9954
TEST_TIME 76 9895
TEST_TIME 77 10004
TEST_TIME 78 9945
TEST_TIME 79 10014
TEST_TIME 80 9900
TEST_TIME 81 9812
TEST_TIME 82 9759
TEST_TIME 83 9772
TEST_TIME 84 9701
TEST_TIME 85 9683
TEST_TIME 86 9633
TEST_TIME 87 9592
TEST_TIME 88 9556
TEST_TIME 89 9569
TEST_TIME 90 9555
TEST_TIME 91 9555
TEST_TIME 92 9538
TEST_TIME 93 9543
TEST_TIME 94 9588
TEST_TIME 95 9617
TEST_TIME 96 9602
TEST_TIME 97 9675
TEST_TIME 98 9668
TEST_TIME 99 9723
TEST_TIME 100 9741
TEST_TIME 101 9730
TEST_TIME 102 9732
TEST_TIME 103 9691
TEST_TIME 104 9613
TEST_TIME 105 9616
TEST_TIME 106 9564
TEST_TIME 107 9538
TEST_TIME 108 9521
TEST_TIME 109 9522
TEST_TIME 110 9530
TEST_TIME 111 9514
TEST_TIME 112 9492
TEST_TIME 113 9516
TEST_TIME 114 9506
TEST_TIME 115 9514
TEST_TIME 116 9552
TEST_TIME 117 9546
TEST_TIME 118 9560
TEST_TIME 119 9559
TEST_TIME 120 9554

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2021 19:28:13 to 21-03-2021 19:28:16.

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 1587153 1587153 0 0.00 0 19077 6 0 0
doc_list_biud 1587148 1587148 0 0.00 0 59131 27 0 0
sp_add_invoice_to_stock 5187 5036 151 2.91 25 182574 18428 0 151
sp_cancel_adding_invoice 5892 5892 0 0.00 5 93425 802 0 0
sp_cancel_client_order 1853 1853 0 0.00 4 14138 338 0 0
sp_cancel_customer_reserve 583648 583648 0 0.00 1 59134 59 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 3 1935 66 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 2 1464 47 0 0
sp_cancel_supplier_invoice 6470 6453 17 0.26 2 14372 714 0 17
sp_cancel_supplier_order 420 420 0 0.00 5 1135680 103031 0 0
sp_cancel_write_off 11017 11017 0 0.00 1 12271 118 0 0
sp_client_order 21313 21313 0 0.00 3 24856 374 0 0
sp_customer_reserve 473368 473368 0 0.00 0 103632 180 0 0
sp_fill_shopping_cart 32541 32541 0 0.00 1 14504 35 0 0
sp_fill_shopping_cart_clo_res 473363 473363 0 0.00 0 18997 15 0 0
sp_get_clo_for_invoice 5028 5028 0 0.00 0 25465 287 0 0
sp_kill_cost_storno 18042 18042 0 0.00 0 12267 57 0 0
sp_kill_qstorno_ret_qs2qd 1185186 1185186 0 0.00 0 59110 32 0 0
sp_kill_qty_storno 624534 624534 0 0.00 0 59131 68 0 0
sp_lock_selected_doc 21222 21222 0 0.00 0 9412 6 0 0
sp_make_cost_storno 28493 28493 0 0.00 0 16069 48 0 0
sp_multiply_rows_for_pdistr 28489 28489 0 0.00 0 16786 31 0 0
sp_multiply_rows_for_qdistr 21313 21313 0 0.00 0 12034 164 0 0
sp_pay_from_customer 7329 7329 0 0.00 4 11320 112 0 0
sp_pay_to_supplier 5910 5910 0 0.00 5 19243 144 0 0
sp_payment_common 13238 13238 0 0.00 1 19210 28 0 0
sp_qd_handle_on_cancel_clo 1853 1853 0 0.00 0 14109 300 0 0
sp_qd_handle_on_invoice_upd_sts 10918 10918 0 0.00 0 17504 318 0 0
sp_qd_handle_on_reserve_upd_sts 10225 10225 0 0.00 0 15477 53 0 0
sp_reserve_write_off 10226 10226 0 0.00 5 16030 156 0 0
sp_supplier_invoice 5525 5525 0 0.00 6 90678 3207 0 0
sp_supplier_order 5707 5707 0 0.00 4 65185 1270 0 0
srv_aggregate_perf_data 98 98 0 0.00 2880 367161 23417 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1419 165414 33983 0 0
srv_find_qd_qs_mism 1098659 1098659 0 0.00 0 16959 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 33 76364 1045 0 0
srv_make_money_saldo 784 784 0 0.00 1 16472 42 0 0
srv_recalc_idx_stat 4 4 0 0.00 90664 383606 251295 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5036 5036 0 0.00 0 10116 146 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 4004 114 0 0
t$perf-norm:sp_cancel_client_order 1853 1853 0 0.00 0 7231 16 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 3039 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 2429 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 213 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 1219 14 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 16227 1607 0 0
t$perf-norm:sp_cancel_write_off 1054 1054 0 0.00 0 1631 9 0 0
t$perf-norm:sp_client_order 21313 21313 0 0.00 0 5711 15 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 557 3 0 0
t$perf-norm:sp_pay_from_customer 7329 7329 0 0.00 0 6752 11 0 0
t$perf-norm:sp_pay_to_supplier 5910 5910 0 0.00 0 8644 11 0 0
t$perf-norm:sp_reserve_write_off 10226 10226 0 0.00 0 9859 11 0 0
t$perf-norm:sp_supplier_invoice 5525 5525 0 0.00 0 9141 17 0 0
t$perf-norm:sp_supplier_order 5707 5707 0 0.00 0 6101 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 353 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 1232 25 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 1392 21 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 2092 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10354 10052 302 2.91 0 7496 19 0 302
v_all_customers 39092 39092 0 0.00 0 139 1 0 0
v_all_suppliers 31176 31176 0 0.00 0 284 1 0 0
v_all_wares 42626 42626 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 3745 11 0 0
v_cancel_client_order 3706 3706 0 0.00 0 4623 10 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 1678 4 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 4302 12 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 355 3 0 0
v_cancel_supplier_invoice 806 772 34 4.21 0 1626 18 0 34
v_cancel_supplier_order 840 840 0 0.00 0 480 5 0 0
v_cancel_write_off 2108 2108 0 0.00 0 2798 14 0 0
v_max_id_clo_ord 5705 5705 0 0.00 0 207 1 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 2209 16 0 0
v_max_id_ord_sup 5523 5523 0 0.00 0 5390 7 0 0
v_max_non_paid_invoice 1549 1549 0 0.00 0 1825 4 0 0
v_max_non_paid_realizn 3799 3799 0 0.00 0 1984 4 0 0
v_min_id_clo_ord 5705 5705 0 0.00 0 3591 4 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 1301 4 0 0
v_min_id_ord_sup 5523 5523 0 0.00 0 8442 9 0 0
v_min_non_paid_invoice 5909 5909 0 0.00 0 19206 17 0 0
v_min_non_paid_realizn 7329 7329 0 0.00 0 11309 20 0 0
v_our_firm 10594 10594 0 0.00 0 16 1 0 0
v_reserve_write_off 20450 20450 0 0.00 0 3173 5 0 0
x_lock_depdocs_on_canc_invoice 11959 11959 0 0.00 0 21151 107 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 9603 345 0 0
x_make_qstorno_1000_1200 5707 5707 0 0.00 1 65175 1200 0 0
x_make_qstorno_1200_2000 5525 5525 0 0.00 3 87868 3074 0 0
x_make_qstorno_2100_3300 473368 473368 0 0.00 0 103549 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2021 19:28:17 to 21-03-2021 19:28:21.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:26 9 8192000000 8803197024 8815017984 8973408 0.109 2 1 2 0 9144432 61552 109472
16:57:32 14678 8192000000 10236125472 10538205184 864709520 9.547 69 55 111 0 886536560 2668032 19159008
16:57:56 34159 8192000000 10347580864 10665295872 1382115776 14.435 100 84 168 0 1415835088 5191168 28528144
16:58:37 25463 8192000000 10381644880 10703208448 1426610784 14.831 100 81 162 0 1460781520 7041600 27129136
16:59:16 36151 8192000000 10405012624 10737958912 1457451120 15.103 100 79 158 0 1491256688 7843568 25962000
17:00:04 15183 8192000000 10438918240 10773929984 1489567632 15.385 100 83 166 0 1524360016 8231840 26560544
17:00:38 21284 8192000000 10464838144 10805424128 1523477664 15.680 100 89 178 0 1560894144 9105280 28311200
17:01:11 15337 8192000000 10491878368 10833137664 1543132736 15.851 100 90 180 0 1580924352 9463648 28327968
17:01:41 18924 8192000000 10508039488 10857885696 1564682352 16.037 100 80 161 1 1599870016 10450464 24737200
17:02:19 16328 8192000000 10540840992 10893164544 1589713920 16.251 100 77 154 0 1624206720 10834272 23658528
17:02:53 11549 8192000000 10557912560 10920095744 1624440128 16.548 100 78 156 0 1658927968 11279440 23208400
17:03:14 13519 8192000000 10583214080 10944659456 1642672080 16.702 100 82 164 2 1678860192 11522928 24665184
17:03:36 16559 8192000000 10606913952 10974044160 1663593136 16.879 100 78 157 1 1698551040 12310000 22647904
17:04:06 7605 8192000000 10641676576 11007913984 1690375424 17.104 100 84 167 0 1727820064 12919808 24524832
17:04:22 11463 8192000000 10640473632 11014811648 1707212272 17.245 100 79 158 2 1743529440 13503504 22813664
17:04:44 7616 8192000000 10647612832 11025895424 1715526880 17.315 100 81 162 0 1753041776 14203104 23311792
17:04:58 8982 8192000000 10658747808 11037405184 1727304976 17.413 100 74 148 2 1761172384 13254272 20613136
17:05:17 6349 8192000000 10671519520 11049230336 1736626144 17.491 100 71 141 1 1768635872 12162816 19846912
17:05:36 5250 8192000000 10689813216 11072737280 1754346416 17.638 100 83 163 1 1790262784 12512032 23404336
17:05:49 3185 8192000000 10700539616 11080806400 1762962192 17.709 100 73 146 1 1795295632 12013600 20319840
17:06:00 6752 8192000000 10702808464 11094274048 1777071792 17.825 100 74 148 0 1810737376 12335936 21329648
17:06:14 3538 8192000000 10715983552 11096293376 1782311440 17.869 100 82 164 2 1817496112 12775824 22408848
17:06:24 7502 8192000000 10722454704 11106238464 1788223984 17.917 100 82 163 2 1823530608 12410496 22896128
17:06:43 5685 8192000000 10747415904 11133177856 1797168144 17.991 100 77 153 2 1829281088 10761728 21351216
17:06:55 2775 8192000000 10751735024 11142705152 1824045456 18.211 100 77 154 1 1857473008 11832224 21595328
17:07:04 3049 8192000000 10767739760 11153899520 1829575568 18.256 100 86 169 1 1866013088 12249792 24187728
17:07:14 2157 8192000000 10779802000 11163762688 1833169824 18.285 100 89 178 2 1871738880 13618096 24950960
17:07:22 2837 8192000000 10780764640 11169923072 1838589424 18.329 100 91 182 0 1878575584 14375984 25610176
17:07:31 2139 8192000000 10783646176 11170512896 1841720496 18.355 100 92 184 0 1880280704 12826496 25733712
17:07:40 1561 8192000000 10790092272 11175776256 1844852736 18.380 100 83 165 0 1882133088 14219824 23060528
17:07:48 1844 8192000000 10793046416 11176493056 1847943728 18.405 100 96 193 1 1890605600 15408928 27252944
17:07:56 1947 8192000000 10801068816 11188486144 1852734528 18.444 100 95 189 3 1893113664 14057696 26321440
17:08:05 1425 8192000000 10803289952 11188920320 1853522624 18.451 100 93 187 1 1893305840 13603472 26179744
17:08:13 2146 8192000000 10794358256 11183808512 1855917248 18.470 100 90 179 2 1894931120 14029808 24984064
17:08:22 2633 8192000000 10789822048 11182317568 1854595248 18.459 100 88 173 2 1891199424 11947280 24656896
17:08:30 18403 8192000000 10792143184 11188326400 1856952448 18.479 100 73 147 1 1887889184 10270528 20666208
17:08:55 2130 8192000000 10812602400 11197902848 1861226304 18.513 100 92 186 0 1900713056 12437376 27049376
17:09:03 2351 8192000000 10789405872 11193597952 1857644512 18.484 100 60 118 0 1886431376 11879424 16907440
17:09:12 2261 8192000000 10786615984 11193253888 1859163456 18.496 100 59 119 2 1886703936 10830512 16709968
17:09:21 5552 8192000000 10769653776 11191652352 1857760832 18.485 100 38 76 0 1877380368 8740928 10878608
17:09:35 7882 8192000000 10778572256 11200106496 1865694080 18.549 100 41 81 3 1886468496 8932720 11841696
17:09:50 5598 8192000000 10774629488 11197931520 1863470000 18.531 100 29 58 2 1879852416 8042512 8339904
17:10:02 9764 8192000000 10787861344 11198488576 1866384160 18.555 100 30 60 0 1881703120 7224560 8094400
17:10:19 7442 8192000000 10783856672 11206324224 1868789888 18.574 100 22 44 1 1881128592 6406144 5932560
17:10:33 4746 8192000000 10774109424 11209449472 1874482704 18.621 100 30 61 2 1890117888 7176240 8458944
17:10:48 9970 8192000000 10776892128 11209572352 1874185952 18.618 100 20 40 2 1885398032 5890912 5321168
17:11:04 9899 8192000000 10778490368 11212320768 1876272400 18.635 100 18 36 5 1887405472 6243280 4889792
17:11:23 4939 8192000000 10785190688 11218280448 1880956096 18.673 100 33 67 4 1897939856 8041808 8941952
17:11:36 12867 8192000000 10781607968 11218128896 1882085472 18.682 100 21 41 1 1894207040 6003776 6117792
17:11:57 53361 8192000000 10806114736 11231395840 1885834432 18.712 100 53 106 0 1911896576 9977280 16084864
17:12:58 9726 8192000000 10813295360 11232837632 1883402672 18.693 100 31 61 1 1898452320 5270688 9778960
17:13:18 10824 8192000000 10796261984 11234693120 1887196464 18.723 100 22 43 2 1899731856 6295248 6240144
17:13:38 5976 8192000000 10814447808 11240337408 1888794608 18.736 100 26 52 1 1902585088 6220752 7569728
17:13:52 6024 8192000000 10804480608 11239424000 1890201984 18.747 100 20 40 0 1901862960 6390736 5270240
17:14:07 5066 8192000000 10802481472 11238887424 1894646752 18.783 100 25 50 1 1907936640 6512352 6777536
17:14:20 5904 8192000000 10822462448 11248316416 1898434288 18.814 100 34 68 1 1914811440 6503616 9873536
17:14:33 5607 8192000000 10802835712 11246821376 1901419280 18.838 100 32 64 0 1917043616 7143216 8481120
17:14:45 9408 8192000000 10813245216 11248209920 1897236112 18.804 100 12 24 2 1910195152 9621280 3337760
17:15:00 7652 8192000000 10809933200 11248496640 1898166784 18.812 100 17 34 2 1909153472 6552208 4434480
17:15:18 9211 8192000000 10816443712 11250855936 1902612432 18.847 100 22 42 2 1914539696 4777456 7149808
17:15:35 6409 8192000000 10825819312 11254607872 1901880112 18.841 100 30 61 1 1916109920 5877328 8352480
17:15:48 6981 8192000000 10815895056 11253272576 1903810160 18.857 100 25 50 1 1917633552 6720976 7102416
17:16:07 9803 8192000000 10807666864 11251716096 1902682320 18.848 100 19 38 1 1913512800 5456752 5373728
17:16:23 56272 8192000000 10823136880 11252346880 1891148384 18.755 99 55 111 1 1914235952 5384064 17703504
17:17:27 13720 8192000000 10809113696 11248783360 1862177264 18.521 98 17 33 2 1875523056 9450304 3895488
17:17:50 9210 8192000000 10809633376 11230117888 1837431808 18.320 97 36 71 2 1854582736 7278400 9872528
17:18:06 5970 8192000000 10792663184 11222581248 1870769568 18.591 100 20 39 3 1881776976 5676432 5330976
17:18:20 5303 8192000000 10788593072 11199619072 1804870736 18.054 96 38 75 1 1822130272 7112864 10146672
17:18:34 6806 8192000000 10740223840 11165003776 1769686624 17.764 96 22 43 0 1782692864 5816640 7189600
17:18:49 8397 8192000000 10726171376 11151396864 1791528080 17.944 98 23 46 2 1803599824 5578912 6492832
17:19:06 6687 8192000000 10725305120 11141169152 1738427248 17.506 95 27 54 0 1751608624 5354896 7826480
17:19:20 8644 8192000000 10731618512 11141476352 1762810608 17.708 97 19 38 2 1773138784 5018080 5310096
17:19:35 6835 8192000000 10727878640 11152490496 1815938736 18.144 100 28 55 1 1831173680 5965440 9269504
17:19:53 8330 8192000000 10725920720 11158970368 1805423632 18.058 99 22 44 2 1818209360 5059040 7726688
17:20:08 10368 8192000000 10711571088 11134042112 1756351360 17.654 96 15 30 0 1766182272 5217200 4613712
17:20:25 7447 8192000000 10733415664 11147403264 1783431680 17.878 98 20 40 1 1794419216 5079648 5907888
17:20:39 13599 8192000000 10635435984 11022966784 1611264320 16.435 89 22 43 1 1622986400 4648672 7073408
17:21:00 62128 8192000000 10671702016 11087814656 1643048480 16.706 91 24 47 2 1659000832 9139632 6812720
17:22:09 8483 8192000000 10712135808 11119968256 1755727728 17.649 98 19 38 1 1765804000 5114928 4961344
17:22:24 4634 8192000000 10747998656 11150684160 1810088512 18.097 100 25 49 3 1823043680 6128080 6827088
17:22:35 7539 8192000000 10746423888 11154829312 1806132608 18.064 99 45 90 1 1827437104 8832704 12471792
17:22:51 7890 8192000000 10729856768 11153002496 1816208096 18.147 100 25 50 1 1829804976 6718432 6878448
17:23:05 6720 8192000000 10744999584 11168206848 1814262464 18.131 99 26 52 0 1827845600 5421008 8162128
17:23:18 4646 8192000000 10757803264 11169116160 1826509792 18.231 100 41 83 0 1845129360 6702336 11917232
17:23:31 8371 8192000000 10765721456 11174047744 1834344496 18.295 100 30 60 1 1849767904 5741376 9682032
17:23:50 8267 8192000000 10758667744 11179069440 1844921504 18.381 100 30 60 1 1859225328 5694336 8609488
17:24:07 10229 8192000000 10764747584 11188854784 1848663360 18.411 100 26 51 0 1866756192 10039888 8052944
17:24:24 11991 8192000000 10776982832 11196473344 1857805232 18.485 100 38 75 3 1874985616 6243008 10937376
17:24:44 7901 8192000000 10782134384 11204984832 1861330016 18.514 100 32 65 1 1875711104 4788000 9593088
17:24:59 18377 8192000000 10780957504 11207192576 1862619520 18.525 100 18 36 1 1873218960 5637328 4962112
17:25:24 66176 8192000000 10792757504 11220017152 1870993632 18.592 100 40 78 2 1887064032 5544432 10525968
17:26:37 14875 8192000000 10777564000 11211415552 1870271600 18.586 100 22 44 1 1882305776 5741072 6293104
17:26:58 8646 8192000000 10794896656 11220328448 1875877040 18.632 100 27 54 2 1888931776 5298832 7755904
17:27:14 10158 8192000000 10798868704 11229892608 1886555408 18.718 100 21 39 1 1896719616 4371472 5792736
17:27:36 17437 8192000000 10844914032 11257815040 1905690144 18.872 100 54 108 2 1928255056 6327824 16237088
17:28:01 3355 8192000000 10842235168 11264180224 1917065664 18.963 100 55 109 1 1941304368 9033808 15204896
17:28:28 31073 8192000000 10858529600 11284381696 1921567648 18.999 100 44 87 1 1948918608 15370832 11980128
17:29:25 23042 8192000000 10861561664 11294068736 1936341248 19.118 100 51 102 3 1962878656 12053072 14484336
17:29:56 28390 8192000000 10877179248 11305070592 1939557184 19.143 100 46 88 2 1963502288 11552448 12392656
17:30:33 33342 8192000000 10907074832 11333677056 1952985568 19.250 100 46 92 3 1984905008 18219600 13699840
17:31:15 13984 8192000000 10893808384 11340627968 1963531504 19.334 100 43 87 0 1996891456 20668576 12691376
17:31:49 22676 8192000000 10909279264 11349585920 1972704192 19.407 100 41 82 3 2003718240 18904448 12109600
17:32:26 13702 8192000000 10929732736 11360595968 1983278896 19.491 100 51 102 0 2021300224 23006032 15015296
17:32:47 16679 8192000000 10933344640 11364024320 1986863600 19.519 100 45 90 1 2024263136 23966128 13433408
17:33:13 31861 8192000000 10937703136 11377459200 1990894752 19.551 100 42 84 1 2036480592 32570560 13015280
17:33:56 2523 8192000000 10939317568 11383148544 1992616032 19.564 100 44 88 1 2033039056 27178448 13244576
17:34:09 5970 8192000000 10953342384 11385233408 2003770896 19.652 100 61 122 1 2048560960 26409344 18380720
17:34:25 7373 8192000000 10948292544 11384799232 1997695264 19.605 100 42 83 1 2036527856 26708928 12123664
17:34:42 11368 8192000000 10951802400 11392323584 2005568128 19.667 100 51 100 1 2048517104 28030192 14918784
17:35:10 3937 8192000000 10958123936 11397783552 2008501696 19.690 100 57 114 1 2054084320 28818528 16764096
17:35:21 7655 8192000000 10974112848 11401932800 2011425312 19.713 100 63 126 2 2059005904 29055408 18525184
17:35:35 4370 8192000000 10973650992 11405037568 2014839264 19.740 100 65 130 3 2064131760 30073136 19219360
17:35:51 7607 8192000000 10978921168 11409346560 2016566656 19.753 100 60 120 0 2064794864 30472704 17755504
17:36:07 11560 8192000000 10984989104 11417743360 2022459872 19.799 100 58 116 1 2071525104 31368816 17696416
17:36:27 11442 8192000000 10992268768 11425480704 2022361728 19.799 100 58 116 0 2071612656 31583104 17667824
17:36:47 7372 8192000000 10991886896 11423825920 2028378656 19.846 100 61 121 3 2080889808 33287584 19223568
17:37:04 6230 8192000000 10985309840 11421401088 2011819392 19.716 99 62 122 0 2064416464 34509744 18087328
17:37:18 5146 8192000000 11004600576 11431952384 2029050688 19.851 100 62 122 1 2085637008 37809488 18776832
17:37:31 9048 8192000000 11001291184 11428442112 2015319376 19.743 99 75 150 0 2077828560 39333552 23175632
17:37:46 2853 8192000000 10993983344 11423436800 2025150208 19.821 100 64 128 1 2084679264 40412592 19116464
17:38:01 9765 8192000000 10964717856 11394555904 1972247632 19.403 97 61 122 2 2034335856 43814800 18273424
17:38:23 1661 8192000000 11004624992 11422478336 2024271280 19.814 100 87 171 0 2091748048 41068944 26407824
17:38:32 10578 8192000000 10998929856 11428904960 2025846064 19.826 100 76 152 1 2092024864 42847936 23330864
17:38:50 14310 8192000000 10992867280 11430125568 2007038016 19.678 99 62 124 2 2070899840 44396480 19465344
17:39:12 4480 8192000000 11003823600 11439955968 2032462944 19.878 100 62 122 1 2094275776 42207152 19605680
17:39:25 4931 8192000000 11006142128 11441016832 2034186848 19.891 100 62 124 0 2094553456 41019552 19347056
17:39:37 3879 8192000000 11017733888 11446128640 2032861424 19.881 100 77 153 3 2102509856 45237024 24411408
17:39:48 2832 8192000000 11023806448 11446476800 2040195072 19.938 100 74 149 1 2111382112 45303392 25883648
17:39:58 6257 8192000000 11020197232 11459338240 2042604112 19.957 100 67 133 0 2108338000 45106320 20627568
17:40:15 7421 8192000000 11030301952 11460567040 2047252448 19.994 100 77 154 0 2115484480 44437808 23794224
17:40:36 7073 8192000000 11024878304 11456790528 2041671136 19.950 100 75 148 2 2110458320 45727520 23059664
17:41:00 3521 8192000000 11004015072 11436171264 2010362352 19.704 99 67 133 0 2078453808 46999536 21091920
17:41:11 11235 8192000000 11012365120 11442618368 2027176256 19.836 100 65 130 0 2095771104 47279984 21314864
17:41:32 5025 8192000000 11020470640 11451650048 2036184048 19.907 100 68 135 0 2105768816 48066768 21518000
17:41:46 3475 8192000000 11033485696 11462651904 2046296832 19.986 100 79 156 3 2120061760 49498688 24266240
17:41:56 1730 8192000000 11021680592 11444506624 2025544960 19.824 99 84 168 0 2101544512 50246400 25753152
17:42:07 2903 8192000000 11006821952 11424071680 2002446880 19.642 98 86 172 1 2081665200 52405328 26812992
17:42:18 3268 8192000000 11028929136 11454902272 2036295840 19.908 100 92 182 2 2119203488 54017024 28890624
17:42:29 1677 8192000000 11024497056 11445493760 2026275184 19.829 100 85 171 1 2107538960 53861440 27402336
17:42:43 4326 8192000000 11011934960 11437649920 2017886176 19.764 100 74 148 1 2095938720 53254096 24798448
17:42:57 8872 8192000000 11025645952 11450454016 2030418064 19.862 100 78 156 1 2108525840 53232992 24874784
17:43:13 5829 8192000000 11002788688 11434430464 2006968864 19.678 99 65 131 0 2081305168 52962944 21373360
17:43:28 2878 8192000000 11015684848 11438804992 2018065472 19.765 100 86 172 1 2096821936 51972160 26784304
17:43:39 5410 8192000000 10981997520 11412922368 1959440992 19.302 97 62 124 0 2032265600 52099472 20725136
17:43:51 1781 8192000000 10997508800 11423576064 1992160656 19.561 99 83 165 2 2071914016 53260208 26493152
17:44:04 6666 8192000000 10973076368 11390869504 1964083728 19.338 98 76 152 1 2045416704 56934176 24398800
17:44:17 4908 8192000000 10961638592 11385044992 1949085648 19.219 98 73 146 3 2031064608 58548000 23430960
17:44:34 1565 8192000000 11000142800 11418046464 1977235904 19.443 99 91 177 0 2064697792 59436160 28025728
17:44:42 3872 8192000000 10998489376 11429834752 1999262000 19.617 100 80 159 2 2086113872 61064048 25787824
17:44:53 4374 8192000000 10992359840 11423531008 1996222944 19.593 100 66 132 2 2076178256 58609520 21345792
17:45:05 3517 8192000000 11005376240 11427213312 1998131168 19.608 100 85 169 0 2084089536 58996096 26962272
17:45:16 1418 8192000000 11002432464 11419418624 1991563392 19.556 100 84 168 0 2078802752 59924016 27315344
17:45:25 4577 8192000000 10981753920 11408494592 1968141600 19.371 99 70 138 0 2054281136 63200608 22938928
17:45:36 12457 8192000000 10957353056 11404673024 1960134704 19.307 99 45 90 2 2036495280 61287584 15072992
17:46:03 10683 8192000000 10937872336 11387486208 1936777248 19.121 98 41 79 2 2003838080 54822672 12238160
17:46:22 13212 8192000000 10953955008 11400749056 1970794512 19.392 100 38 76 2 2036608208 53359296 12454400
17:46:42 12886 8192000000 10958676368 11405664256 1967725776 19.367 99 45 90 0 2032406864 50379168 14301920
17:47:01 11835 8192000000 10942005648 11394129920 1943839248 19.177 98 34 67 1 2002536016 47767552 10929216
17:47:26 13745 8192000000 10940548944 11393163264 1966878576 19.361 100 29 58 3 2025108256 48705808 9523872
17:48:15 16278 8192000000 10936252416 11395928064 1964920752 19.345 100 27 54 0 2017610928 43948448 8741728
17:48:58 28760 8192000000 10907893984 11366010880 1928355920 19.054 99 29 58 1 1985266592 46616096 10294576
17:49:36 27671 8192000000 10893327424 11340931072 1932046000 19.083 100 20 40 2 1982264736 43350336 6868400
17:50:30 27457 8192000000 10907304112 11372290048 1943794048 19.177 100 23 46 0 1996082096 44542528 7745520
17:51:04 9687 8192000000 10905914816 11371798528 1927756176 19.049 99 18 36 0 1978021680 44195552 6069952
17:51:20 10343 8192000000 10893330896 11364864000 1922333680 19.006 99 15 30 1 1971771616 44310096 5127840
17:51:58 26180 8192000000 10866055280 11332087808 1880982192 18.673 97 32 64 1 1919315936 28873136 9460608
17:52:31 40260 8192000000 10875254736 11324571648 1909987536 18.907 99 17 36 2 1933091328 17498336 5605456
17:53:21 41230 8192000000 10857677904 11321880576 1888943632 18.737 98 11 22 1 1906975408 14954848 3076928
17:55:01 29066 8192000000 10848261072 11311755264 1906583120 18.879 99 15 30 0 1920104704 9291904 4229680
17:55:38 64707 8192000000 10888269808 11317432320 1883222944 18.691 97 29 59 1 1901920608 10097744 8599920
17:56:50 96031 8192000000 10858389184 11294334976 1802120336 18.031 93 35 69 1 1824430320 13194608 9115376
17:58:34 89350 8192000000 10871111104 11307143168 1905176480 18.868 99 51 101 1 1932922080 12778272 14967328
18:00:14 30890 8192000000 10892792640 11320311808 1929014560 19.059 100 58 114 3 1959279248 14292288 15972400
18:00:55 41728 8192000000 10865762512 11328331776 1946436640 19.198 100 20 40 1 1964571472 12748976 5385856
18:01:45 145800 8192000000 10877291872 11319328768 1866376384 18.555 95 30 58 0 1888635008 12868192 9390432
18:04:20 41084 8192000000 10862338992 11322556416 1920815024 18.993 99 39 77 1 1949166944 16371456 11980464
18:05:09 54374 8192000000 10868995968 11326509056 1902698384 18.848 98 14 28 0 1918744576 11807168 4239024
18:06:19 27328 8192000000 10858572448 11322814464 1930368992 19.070 99 14 28 1 1950651664 16114048 4168624
18:06:53 51453 8192000000 10857374160 11319480320 1925430400 19.030 99 13 26 1 1948923776 19376848 4116528
18:07:51 66222 8192000000 10883944032 11339808768 1932394576 19.086 99 24 45 3 1954377904 15535216 6448112
18:09:09 114247 8192000000 10869899376 11350302720 1916994992 18.963 98 22 45 1 1942762464 18884736 6882736
18:11:34 33205 8192000000 10863682416 11320426496 1931225120 19.077 99 26 52 0 1946591776 8185856 7180800
18:12:13 70157 8192000000 10877218464 11346251776 1936926304 19.122 99 18 36 0 1957017248 14935808 5155136
18:13:30 86803 8192000000 10877997184 11361648640 1920007840 18.987 98 14 28 2 1943538576 19632576 3898160
18:15:07 61431 8192000000 10866442896 11340804096 1915590000 18.951 98 22 44 1 1936416672 14698800 6127872
18:16:15 41175 8192000000 10880831424 11351105536 1952930800 19.250 100 8 16 2 1965324304 10229424 2164080
18:17:08 48677 8192000000 10912712544 11367161856 1974181232 19.419 100 36 72 1 1995594416 11445200 9967984
18:18:03 70877 8192000000 10900896480 11368071168 1936556240 19.119 98 16 32 0 1952483488 11604016 4323232
18:19:26 67236 8192000000 10895694192 11349815296 1890103712 18.747 96 16 32 0 1908448768 13819728 4525328
18:20:42 57942 8192000000 10894134848 11371245568 1961926896 19.321 100 19 38 2 1985154176 17795328 5431952
18:21:50 48263 8192000000 10900300976 11382108160 1946020192 19.195 99 7 14 1 1962381600 14623456 1737952
18:22:49 41896 8192000000 10904837360 11368239104 1950842592 19.233 99 14 28 0 1972612880 17969600 3800688
18:23:39 69222 8192000000 10889169104 11372654592 1889604384 18.743 96 18 36 1 1913855728 19676752 4574592
18:24:54 104061 8192000000 10871035504 11310202880 1866423920 18.555 95 35 68 1 1885927456 10112000 9391536
18:26:45 73503 8192000000 10878643984 11343278080 1934282832 19.101 99 35 69 1 1956427104 12760608 9383664
18:28:13 8216 8192000000 10884422800 11346767872 1950879856 19.233 100 33 66 0 1974724880 14279328 9565696
18:28:27 29014 8192000000 10910943648 11357536256 1959279280 19.300 100 35 70 2 1979825904 10686064 9860560
18:29:04 43051 8192000000 10879750784 11356987392 1962767056 19.328 100 28 54 1 1983586848 13363424 7456368
18:30:04 50716 8192000000 10827445552 11303055360 1842603680 18.362 94 11 22 0 1852181616 6332080 3245856
18:31:01 51532 8192000000 10856505936 11329806336 1942595664 19.167 100 19 38 0 1954301968 6631424 5074880
18:32:08 51226 8192000000 10857971552 11333091328 1892517488 18.766 97 7 14 0 1900725232 6740736 1467008
18:33:05 48275 8192000000 10877976768 11343831040 1925154720 19.028 99 19 37 2 1938691936 8426352 5110864
18:35:01 47545 8192000000 10885894960 11336048640 1895560400 18.791 97 29 57 3 1912947824 9090544 8296880
18:35:55 47044 8192000000 10871802800 11330494464 1892604528 18.767 97 33 65 0 1910999584 9126864 9268192
18:36:52 48967 8192000000 10867731536 11335626752 1894756224 18.784 97 18 37 2 1911089136 11117008 5215904
18:38:13 81767 8192000000 10876604480 11329679360 1866972176 18.560 96 20 40 1 1886154320 13689440 5492704
18:39:51 30789 8192000000 10908650256 11360104448 1958006192 19.290 100 41 82 2 1985110400 14889984 12214224
18:40:43 82898 8192000000 10874461984 11346452480 1893023040 18.770 97 21 41 3 1920251920 21190464 6038416
18:42:12 53457 8192000000 10868549008 11336192000 1888760224 18.736 98 8 16 1 1905685184 14711904 2213056
18:43:14 48811 8192000000 10880501664 11337003008 1912532560 18.927 99 13 26 1 1931330752 14881568 3916624
18:44:18 91066 8192000000 10883061344 11348295680 1874141808 18.618 96 8 16 0 1886906272 10760192 2004272
18:45:56 76846 8192000000 10845245840 11314282496 1834144992 18.293 94 22 43 3 1852550032 12028480 6376560
18:47:19 165414 8192000000 10863580112 11333246976 1920319872 18.989 99 20 40 2 1933690160 7884272 5486016
18:50:12 56184 8192000000 10846530624 11332177920 1911916672 18.922 98 14 28 0 1926210768 10252720 4041376
18:52:28 65226 8192000000 10858333376 11321782272 1906572704 18.879 98 13 26 0 1918784080 8411424 3799952
18:54:30 62781 8192000000 10879926560 11349737472 1937538048 19.127 99 15 30 1 1957118608 15242800 4337760
18:55:41 44917 8192000000 10866650160 11348160512 1917137472 18.964 98 17 34 1 1936972784 15604256 4231056
18:56:42 59661 8192000000 10893146288 11343679488 1920288240 18.989 98 16 32 1 1934172272 9844992 4039040
18:57:52 29771 8192000000 10881115504 11345784832 1920886496 18.994 98 27 54 1 1936225984 8256880 7082608
18:58:30 33525 8192000000 10894216336 11356901376 1964427888 19.341 100 36 72 1 1982943680 8412448 10103344
18:59:11 22098 8192000000 10909836464 11366785024 1969931344 19.385 100 39 78 3 1989958384 9578736 10448304
18:59:42 19466 8192000000 10903647504 11364241408 1969639776 19.383 100 35 70 2 1991452880 11753936 10059168
19:00:07 34874 8192000000 10906314544 11374518272 1957602640 19.287 99 43 86 1 1985584080 16161344 11820096
19:00:55 55091 8192000000 10920137824 11392065536 1963771584 19.336 99 15 30 0 1984148512 16190736 4186192
19:02:00 62308 8192000000 10897948176 11364843520 1896129264 18.795 96 20 40 0 1916120336 13801232 6189840
19:03:21 66115 8192000000 10902755424 11370950656 1930098752 19.068 98 16 31 3 1951196016 15896624 5200640
19:04:34 80168 8192000000 10917968960 11379978240 1972795536 19.408 100 16 32 1 1989800176 12600176 4404464
19:06:02 61794 8192000000 10892972144 11371859968 1938557216 19.135 98 18 36 1 1957025648 13645776 4822656
19:07:11 68832 8192000000 10889746160 11346092032 1865900960 18.551 95 16 32 0 1880071040 9890336 4279744
19:08:29 21122 8192000000 10901202528 11358035968 1962872928 19.329 100 46 92 4 1984274688 8703120 12698640
19:08:58 49372 8192000000 10894743040 11347492864 1915815152 18.953 98 28 56 2 1933111088 9871872 7424064
19:09:54 36641 8192000000 10905928528 11368316928 1967080224 19.362 100 38 76 1 1990331904 12833648 10418032
19:10:42 88463 8192000000 10898342624 11360403456 1963789712 19.336 100 33 66 1 1985901856 12636528 9475616
19:12:16 28739 8192000000 10878877360 11350450176 1958719536 19.296 100 23 47 0 1971775888 6249488 6806864
19:12:54 54685 8192000000 10859177120 11334647808 1908916416 18.898 97 15 30 0 1919049152 5848448 4284288
19:15:55 55090 8192000000 10896227760 11376816128 1972932368 19.409 100 20 39 0 1989791856 11607808 5251680
19:17:13 76357 8192000000 10878053008 11363164160 1923104768 19.012 97 17 35 2 1944756704 16684016 4967920
19:18:57 32733 8192000000 10883405728 11355643904 1932660480 19.088 98 25 50 2 1946521024 6608480 7252064
19:19:38 47727 8192000000 10866928672 11327352832 1859956560 18.503 95 21 42 0 1877389184 12019936 5412688
19:20:38 36195 8192000000 10840178160 11308347392 1891510464 18.758 98 13 26 0 1902701552 7523376 3667712
19:21:27 26146 8192000000 10865506352 11327991808 1908069664 18.891 98 33 66 0 1925072208 7899616 9102928
19:22:12 38143 8192000000 10866946656 11336482816 1921381664 18.998 99 32 64 1 1941952128 11166272 9404192
19:23:08 54803 8192000000 10876940464 11351261184 1940488256 19.151 99 22 44 1 1956102736 9284064 6330416
19:24:14 21680 8192000000 10872755088 11331084288 1914581664 18.943 98 44 87 2 1935360928 7832112 12947152
19:24:54 38260 8192000000 10846963904 11300421632 1831996048 18.276 95 28 56 2 1850068384 10262992 7809344
19:25:39 44398 8192000000 10846223872 11291471872 1878601280 18.654 98 35 70 0 1900233552 11984016 9648256
19:26:34 57740 8192000000 9386402240 9677541376 533311040 6.112 29 7 14 1 544131312 8992512 1827760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 21-03-2021 19:28:23 to 21-03-2021 19:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2021 19:28:54 to 21-03-2021 19:28:56.

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          241251
MON$OLDEST_ACTIVE               241252
MON$OLDEST_SNAPSHOT             241252
MON$NEXT_TRANSACTION            241252
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                       2016128
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 19:28:57. 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 19:28:59 No severe PSQL-related problems occured
21.03.21 19:29:01. End of report.