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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-13 22:27:12
DTS_END                         2021-01-13 22:27:12.8890
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/42386
TRN_ID                          237886
ATT_ID                          603
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: 9135.52 24778 1096262
customer order: creation 167.91 391 20149
customer order: refuse 14.12 361 1694
order to supplier: creation 45.13 1272 5416
order to supplier: removal 3.39 108162 407
invoice (draft): creation 45.37 3078 5444
invoice (draft): removal 51.04 845 6125
invoice accept: apply 41.33 19543 4960
invoice accept: cancel 45.94 783 5513
customer reserve: creation 3858.45 192 463014
customer reserve: removal 4570.30 63 548436
realization accept: apply 82.98 205 9957
realization accept: cancel 79.45 125 9534
payment from customer: creation 60.31 153 7237
payment from customer: removal 5.54 151 665
payment to supplier: creation 48.43 180 5811
payment to supplier: removal 3.54 87 425
service: total inventory turnovers 4.90 913 588
service: total monetary turnovers 6.58 22 790
service: aggregate perf. data 0.78 17699 93
service: refresh index statistics 0.03 341328 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-01-2021 22:28:22 to 13-01-2021 22:28:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2977
TEST_TIME 2 4754
TEST_TIME 3 4618
TEST_TIME 4 4364
TEST_TIME 5 4871
TEST_TIME 6 4751
TEST_TIME 7 5606
TEST_TIME 8 5525
TEST_TIME 9 6118
TEST_TIME 10 6087
TEST_TIME 11 6048
TEST_TIME 12 6313
TEST_TIME 13 6277
TEST_TIME 14 6412
TEST_TIME 15 6624
TEST_TIME 16 7035
TEST_TIME 17 7394
TEST_TIME 18 7691
TEST_TIME 19 7867
TEST_TIME 20 8129
TEST_TIME 21 8723
TEST_TIME 22 9258
TEST_TIME 23 9608
TEST_TIME 24 10418
TEST_TIME 25 11257
TEST_TIME 26 10996
TEST_TIME 27 11143
TEST_TIME 28 11380
TEST_TIME 29 11115
TEST_TIME 30 10822
TEST_TIME 31 10848
TEST_TIME 32 10729
TEST_TIME 33 10733
TEST_TIME 34 10522
TEST_TIME 35 10441
TEST_TIME 36 10387
TEST_TIME 37 10332
TEST_TIME 38 10362
TEST_TIME 39 10190
TEST_TIME 40 10180
TEST_TIME 41 10101
TEST_TIME 42 9982
TEST_TIME 43 9922
TEST_TIME 44 9972
TEST_TIME 45 9903
TEST_TIME 46 9840
TEST_TIME 47 9775
TEST_TIME 48 9594
TEST_TIME 49 9586
TEST_TIME 50 9631
TEST_TIME 51 9545
TEST_TIME 52 9569
TEST_TIME 53 9522
TEST_TIME 54 9643
TEST_TIME 55 9767
TEST_TIME 56 9773
TEST_TIME 57 9765
TEST_TIME 58 9761
TEST_TIME 59 9777
TEST_TIME 60 9847
TEST_TIME 61 9940
TEST_TIME 62 9896
TEST_TIME 63 9755
TEST_TIME 64 9706
TEST_TIME 65 9656
TEST_TIME 66 9621
TEST_TIME 67 9574
TEST_TIME 68 9520
TEST_TIME 69 9489
TEST_TIME 70 9523
TEST_TIME 71 9493
TEST_TIME 72 9533
TEST_TIME 73 9620
TEST_TIME 74 9596
TEST_TIME 75 9586
TEST_TIME 76 9594
TEST_TIME 77 9698
TEST_TIME 78 9661
TEST_TIME 79 9637
TEST_TIME 80 9701
TEST_TIME 81 9631
TEST_TIME 82 9569
TEST_TIME 83 9508
TEST_TIME 84 9496
TEST_TIME 85 9499
TEST_TIME 86 9433
TEST_TIME 87 9440
TEST_TIME 88 9422
TEST_TIME 89 9350
TEST_TIME 90 9342
TEST_TIME 91 9281
TEST_TIME 92 9308
TEST_TIME 93 9325
TEST_TIME 94 9275
TEST_TIME 95 9403
TEST_TIME 96 9390
TEST_TIME 97 9361
TEST_TIME 98 9412
TEST_TIME 99 9403
TEST_TIME 100 9388
TEST_TIME 101 9371
TEST_TIME 102 9409
TEST_TIME 103 9435
TEST_TIME 104 9456
TEST_TIME 105 9439
TEST_TIME 106 9447
TEST_TIME 107 9366
TEST_TIME 108 9383
TEST_TIME 109 9350
TEST_TIME 110 9308
TEST_TIME 111 9286
TEST_TIME 112 9260
TEST_TIME 113 9218
TEST_TIME 114 9252
TEST_TIME 115 9240
TEST_TIME 116 9235
TEST_TIME 117 9210
TEST_TIME 118 9207
TEST_TIME 119 9211
TEST_TIME 120 9140

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-01-2021 22:28:25 to 13-01-2021 22:28:29.

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 1525082 1525082 0 0.00 0 37930 7 0 0
doc_list_biud 1525078 1525078 0 0.00 0 39484 29 0 0
sp_add_invoice_to_stock 5014 4960 54 1.07 32 176119 19544 0 54
sp_cancel_adding_invoice 5513 5513 0 0.00 5 59911 784 0 0
sp_cancel_client_order 1694 1694 0 0.00 4 16069 362 0 0
sp_cancel_customer_reserve 548436 548436 0 0.00 1 39485 64 0 0
sp_cancel_pay_from_customer 665 665 0 0.00 3 22655 152 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 2 7045 87 0 0
sp_cancel_supplier_invoice 6131 6125 6 0.09 2 20512 845 0 6
sp_cancel_supplier_order 407 407 0 0.00 5 1214149 108162 0 0
sp_cancel_write_off 9534 9534 0 0.00 1 23175 125 0 0
sp_client_order 20149 20149 0 0.00 3 68196 391 0 0
sp_customer_reserve 463014 463014 0 0.00 0 146654 193 0 0
sp_fill_shopping_cart 31004 31004 0 0.00 1 10662 35 0 0
sp_fill_shopping_cart_clo_res 462992 462992 0 0.00 0 26263 16 0 0
sp_get_clo_for_invoice 4938 4938 0 0.00 0 25548 298 0 0
sp_kill_cost_storno 16137 16137 0 0.00 0 22637 64 0 0
sp_kill_qstorno_ret_qs2qd 1112938 1112938 0 0.00 0 39481 35 0 0
sp_kill_qty_storno 586604 586604 0 0.00 0 39483 74 0 0
sp_lock_selected_doc 20558 20558 0 0.00 0 8060 5 0 0
sp_make_cost_storno 27943 27943 0 0.00 0 20432 60 0 0
sp_multiply_rows_for_pdistr 27943 27943 0 0.00 0 22717 43 0 0
sp_multiply_rows_for_qdistr 20149 20149 0 0.00 0 68175 188 0 0
sp_pay_from_customer 7237 7237 0 0.00 4 26588 154 0 0
sp_pay_to_supplier 5811 5811 0 0.00 5 25260 181 0 0
sp_payment_common 13047 13047 0 0.00 1 26583 59 0 0
sp_qd_handle_on_cancel_clo 1694 1694 0 0.00 0 11019 317 0 0
sp_qd_handle_on_invoice_upd_sts 10451 10451 0 0.00 0 31488 325 0 0
sp_qd_handle_on_reserve_upd_sts 9957 9957 0 0.00 0 25929 60 0 0
sp_reserve_write_off 9957 9957 0 0.00 6 25953 205 0 0
sp_supplier_invoice 5444 5444 0 0.00 5 89605 3078 0 0
sp_supplier_order 5416 5416 0 0.00 5 36665 1272 0 0
srv_aggregate_perf_data 93 93 0 0.00 2656 167980 17699 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1549 154019 34233 0 0
srv_find_qd_qs_mism 1048778 1048778 0 0.00 0 37929 6 0 0
srv_make_invnt_saldo 588 588 0 0.00 45 17043 913 0 0
srv_make_money_saldo 790 790 0 0.00 0 528 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 139469 465212 341328 0 0
t$perf-abend:sp_add_invoice_to_stock 54 54 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4960 4960 0 0.00 0 12231 156 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 3368 94 0 0
t$perf-norm:sp_cancel_client_order 1694 1694 0 0.00 0 2271 15 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 2569 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 665 665 0 0.00 0 1228 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 2146 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 2273 18 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 21968 1549 0 0
t$perf-norm:sp_cancel_write_off 984 984 0 0.00 0 5699 14 0 0
t$perf-norm:sp_client_order 20150 20150 0 0.00 0 10553 17 0 0
t$perf-norm:sp_customer_reserve 994 994 0 0.00 0 2422 11 0 0
t$perf-norm:sp_pay_from_customer 7237 7237 0 0.00 0 10156 12 0 0
t$perf-norm:sp_pay_to_supplier 5811 5811 0 0.00 0 9346 8 0 0
t$perf-norm:sp_reserve_write_off 9957 9957 0 0.00 0 7892 12 0 0
t$perf-norm:sp_supplier_invoice 5444 5444 0 0.00 0 3862 14 0 0
t$perf-norm:sp_supplier_order 5416 5416 0 0.00 0 8739 19 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 2082 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 390 5 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 1885 25 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 2033 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 4 4 0 0
v_add_invoice_to_stock 9984 9876 108 1.08 0 23545 23 0 108
v_all_customers 37300 37300 0 0.00 0 18 1 0 0
v_all_suppliers 30040 30040 0 0.00 0 17 1 0 0
v_all_wares 40298 40298 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 21205 56 0 0
v_cancel_client_order 3388 3388 0 0.00 0 15937 13 0 0
v_cancel_customer_prepayment 1330 1330 0 0.00 0 2495 7 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 13875 17 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 948 4 0 0
v_cancel_supplier_invoice 806 794 12 1.48 0 15805 41 0 12
v_cancel_supplier_order 814 814 0 0.00 0 606 5 0 0
v_cancel_write_off 1968 1968 0 0.00 0 1933 13 0 0
v_max_id_clo_ord 5416 5416 0 0.00 0 458 1 0 0
v_max_id_clo_res 994 994 0 0.00 0 2163 12 0 0
v_max_id_ord_sup 5439 5439 0 0.00 0 6382 6 0 0
v_max_non_paid_invoice 1646 1646 0 0.00 0 4296 6 0 0
v_max_non_paid_realizn 3738 3738 0 0.00 0 4589 7 0 0
v_min_id_clo_ord 5416 5416 0 0.00 0 5961 5 0 0
v_min_id_clo_res 994 994 0 0.00 0 6356 20 0 0
v_min_id_ord_sup 5439 5439 0 0.00 0 6398 9 0 0
v_min_non_paid_invoice 5811 5811 0 0.00 0 22692 48 0 0
v_min_non_paid_realizn 7236 7236 0 0.00 0 22663 44 0 0
v_our_firm 9994 9994 0 0.00 0 19 1 0 0
v_reserve_write_off 19914 19914 0 0.00 0 15492 8 0 0
x_lock_depdocs_on_canc_invoice 11241 11241 0 0.00 0 15594 120 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 8929 367 0 0
x_make_qstorno_1000_1200 5416 5416 0 0.00 2 36658 1197 0 0
x_make_qstorno_1200_2000 5444 5444 0 0.00 2 89572 2957 0 0
x_make_qstorno_2100_3300 463014 463014 0 0.00 0 146653 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-01-2021 22:28:30 to 13-01-2021 22:28:34.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:23 14296 8192000000 10223018704 10532122624 955671856 10.447 75 57 114 0 976629040 2492496 18464688
19:57:44 25482 8192000000 10335550320 10653499392 1369151024 14.319 100 87 173 1 1401670944 4354400 28165520
19:58:24 23022 8192000000 10377618528 10703736832 1437181776 14.925 100 85 170 2 1470350112 6266832 26901504
19:59:02 20563 8192000000 10402864080 10729660416 1460236960 15.128 100 90 180 0 1496677520 7303984 29136576
19:59:36 27471 8192000000 10437599824 10766848000 1485121888 15.346 100 91 182 0 1521846240 8028496 28695856
20:00:20 29568 8192000000 10467344672 10802872320 1511706400 15.578 100 86 172 0 1547335104 8788368 26840336
20:00:58 16740 8192000000 10483674736 10821099520 1535231616 15.782 100 90 180 0 1573365456 9723392 28410448
20:01:27 13387 8192000000 10491575728 10836955136 1548294912 15.895 100 77 154 0 1581638416 9926304 23417200
20:01:50 17522 8192000000 10516883664 10871521280 1577564784 16.147 100 83 166 0 1613767392 10474048 25728560
20:02:21 14734 8192000000 10546487888 10902454272 1601233712 16.350 100 70 140 0 1632034816 10065040 20736064
20:02:45 11552 8192000000 10561137232 10921603072 1626668048 16.567 100 74 146 1 1658315312 10084288 21562976
20:03:07 12376 8192000000 10592718768 10951798784 1647292272 16.741 100 75 150 1 1680217488 10948160 21977056
20:03:29 12715 8192000000 10613821872 10979512320 1668938784 16.924 100 77 154 2 1702517264 11388192 22190288
20:03:50 12720 8192000000 10635206272 11006103552 1696854352 17.159 100 79 158 1 1732295408 12750016 22691040
20:04:13 7830 8192000000 10655744000 11027619840 1720703808 17.358 100 88 176 1 1759198304 12671648 25822848
20:04:30 7552 8192000000 10673432176 11047862272 1726367792 17.405 100 80 161 0 1762233184 12847936 23017456
20:04:49 7100 8192000000 10686064032 11059302400 1746721216 17.574 100 83 164 1 1783211744 12526496 23964032
20:05:04 9228 8192000000 10696045440 11070939136 1755464448 17.647 100 83 166 2 1792683056 13856016 23362592
20:05:21 7746 8192000000 10708044688 11083284480 1764736592 17.724 100 85 168 1 1801754064 12850944 24166528
20:05:36 5881 8192000000 10717306176 11095101440 1776397728 17.820 100 82 164 1 1812361456 13445744 22517984
20:05:49 5001 8192000000 10714466720 11098886144 1779255984 17.843 100 82 164 1 1816349536 13912080 23181472
20:06:01 3531 8192000000 10722232352 11102212096 1782835056 17.873 100 75 150 0 1816849008 13263584 20750368
20:06:12 3620 8192000000 10735240496 11115532288 1793733456 17.962 100 85 170 0 1835252304 18399552 23119296
20:06:22 3018 8192000000 10740554288 11121688576 1801181440 18.024 100 86 173 3 1840080224 14183808 24714976
20:06:32 3434 8192000000 10740670768 11126779904 1809020736 18.088 100 87 175 1 1847033696 13905392 24107568
20:06:43 2846 8192000000 10750938624 11131764736 1812875232 18.119 100 86 171 3 1849667824 12651232 24141360
20:06:52 3348 8192000000 10759269216 11139788800 1820331344 18.180 100 83 166 1 1856240608 13455936 22453328
20:07:02 4158 8192000000 10757976400 11144769536 1822069680 18.195 100 80 160 1 1857584400 13664688 21850032
20:07:13 4002 8192000000 10767386976 11154968576 1830632160 18.264 100 84 168 0 1866098432 12515600 22950672
20:07:25 2272 8192000000 10771985568 11160371200 1841252912 18.351 100 82 164 1 1877539616 13479488 22807216
20:07:34 3321 8192000000 10790690240 11177160704 1846286560 18.392 100 90 181 1 1884358304 13544656 24527088
20:07:44 2725 8192000000 10796997280 11185299456 1853182112 18.448 100 93 185 1 1893210304 14518384 25509808
20:07:53 2935 8192000000 10809153904 11196018688 1857524560 18.483 100 93 186 0 1899535952 15872704 26138688
20:08:02 1406 8192000000 10801010176 11191984128 1862365872 18.522 100 94 184 1 1904116096 15556544 26193680
20:08:10 1245 8192000000 10810870768 11198013440 1862852448 18.526 100 88 178 0 1900082128 12227824 25001856
20:08:17 1994 8192000000 10805024784 11193487360 1863126096 18.529 100 81 161 2 1898062176 12573568 22362512
20:08:26 1777 8192000000 10809169728 11203997696 1867887824 18.567 100 84 168 0 1907875296 15945280 24042192
20:08:34 13560 8192000000 10787778592 11199148032 1867205824 18.562 100 54 107 1 1890788816 8226960 15356032
20:09:03 2149 8192000000 10822973520 11216121856 1879857168 18.664 100 94 188 1 1917224848 10159968 27207712
20:09:11 3253 8192000000 10802590352 11211988992 1873930064 18.616 100 59 117 1 1905056784 14632544 16494176
20:09:21 4969 8192000000 10787849040 11206598656 1873521920 18.613 100 53 106 1 1899222960 10580688 15120352
20:09:32 5727 8192000000 10783491456 11206492160 1872493488 18.604 100 34 68 1 1894443072 12571856 9377728
20:09:44 4192 8192000000 10778264432 11204374528 1872100352 18.601 100 31 62 0 1888642080 7684704 8857024
20:09:55 5736 8192000000 10796816576 11207954432 1872553744 18.605 100 32 62 1 1887993264 6121184 9318336
20:10:08 6982 8192000000 10789469888 11212677120 1876251040 18.635 100 38 76 1 1895248016 9067760 9929216
20:10:21 10567 8192000000 10783846240 11210698752 1876241344 18.635 100 34 69 0 1892828000 6678896 9907760
20:10:38 65285 8192000000 10782374976 11221360640 1888341328 18.732 100 60 120 7 1913044944 5750480 18953136
20:11:52 6371 8192000000 10797795856 11227000832 1886821920 18.720 100 32 64 1 1902756096 6790368 9143808
20:12:05 6887 8192000000 10802088752 11231944704 1885623568 18.710 100 18 36 0 1896334832 6047664 4663600
20:12:18 4783 8192000000 10808204336 11233591296 1893594080 18.775 100 33 66 0 1909794368 6701504 9498784
20:12:35 4629 8192000000 10807473728 11239735296 1897676288 18.808 100 36 72 2 1915547168 8049024 9821856
20:12:47 7921 8192000000 10810750864 11239030784 1896002512 18.794 100 28 54 2 1909789376 5614048 8172816
20:13:02 7705 8192000000 10821908528 11249823744 1900581808 18.831 100 15 29 1 1911105808 5727184 4796816
20:13:17 5928 8192000000 10824716176 11247898624 1905982688 18.874 100 24 48 0 1919633776 6042944 7608144
20:13:31 13616 8192000000 10811785920 11247796224 1901869504 18.841 100 15 29 3 1912358320 6503392 3985424
20:13:51 7708 8192000000 10822055696 11252772864 1908663152 18.896 100 31 62 1 1923795040 6026176 9105712
20:14:08 5855 8192000000 10817027904 11250155520 1906968304 18.882 100 25 50 0 1920583904 6500832 7114768
20:14:20 4885 8192000000 10827497744 11256467456 1909781440 18.905 100 27 54 0 1923083152 5930080 7371632
20:14:31 13818 8192000000 10821660240 11259691008 1916254528 18.957 100 15 30 0 1926432960 5683088 4495344
20:14:53 17545 8192000000 10827241856 11260182528 1916048592 18.955 100 26 53 1 1928693392 5682048 6962752
20:15:42 27679 8192000000 10880935600 11283017728 1925843984 19.034 100 77 155 2 1954778832 6257776 22677072
20:16:15 17672 8192000000 10814005472 11254796288 1879723120 18.663 98 25 50 0 1892939424 5949664 7266640
20:16:39 8858 8192000000 10808761376 11241504768 1877406384 18.644 98 31 62 0 1892757840 6578992 8772464
20:16:56 8433 8192000000 10841119984 11260641280 1910547040 18.911 100 36 73 2 1928643872 7566912 10529920
20:17:12 3693 8192000000 10827917664 11254558720 1897102304 18.803 99 38 74 1 1913910288 6634256 10173728
20:17:22 3839 8192000000 10826138944 11252318208 1906716848 18.880 100 42 81 2 1924435456 6500288 11218320
20:17:34 7720 8192000000 10803798032 11245137920 1898333328 18.813 100 23 46 0 1910835600 6245440 6256832
20:17:52 9754 8192000000 10799778624 11227107328 1862407568 18.523 98 25 48 1 1874842560 5386336 7048656
20:18:08 6877 8192000000 10782356896 11207168000 1831662272 18.273 97 31 63 3 1846564656 6259120 8643264
20:18:23 5845 8192000000 10750503152 11160461312 1800702656 18.020 98 25 48 0 1814008160 6058160 7247344
20:18:35 7971 8192000000 10763107072 11184713728 1813125344 18.121 98 19 37 0 1824298224 6054848 5118032
20:18:50 6525 8192000000 10754589856 11180888064 1826992288 18.235 99 34 68 3 1843521184 7115472 9413424
20:19:03 3658 8192000000 10724007872 11147657216 1798608976 18.002 98 27 54 2 1813141616 6432048 8100592
20:19:13 9264 8192000000 10735212608 11148771328 1750475504 17.606 95 25 50 1 1767230144 9517760 7236880
20:19:28 5776 8192000000 10739288736 11160309760 1809140336 18.089 99 33 61 4 1829287440 11505584 8641520
20:19:40 60540 8192000000 10698651344 11124613120 1685099024 17.060 92 27 54 0 1699488416 5483568 8905824
20:20:48 14671 8192000000 10674414560 11089960960 1686263456 17.070 94 14 28 2 1695600064 4905904 4430704
20:21:11 5372 8192000000 10693604624 11100827648 1738066496 17.503 98 23 45 1 1750868208 6580448 6221264
20:21:24 6758 8192000000 10700548016 11109826560 1779169360 17.843 100 23 45 1 1791526512 5398752 6958400
20:21:41 6216 8192000000 10717034080 11121545216 1748362144 17.588 97 25 50 0 1760339616 4829792 7147680
20:21:54 8184 8192000000 10699182624 11112787968 1755037728 17.643 98 25 48 3 1767547296 5146048 7363520
20:22:09 12164 8192000000 10710680528 11119878144 1741233760 17.529 97 22 44 0 1752922608 5401568 6287280
20:22:28 9703 8192000000 10719134256 11134713856 1787973280 17.915 99 31 62 2 1802699840 5560688 9165872
20:22:47 9679 8192000000 10719318112 11142033408 1807869904 18.078 100 26 52 2 1822808544 6983664 7954976
20:23:08 11343 8192000000 10732363744 11147411456 1810162496 18.097 100 16 32 1 1820513888 5544544 4806848
20:23:28 6280 8192000000 10736596016 11146383360 1802143200 18.031 99 31 63 1 1817083568 5515328 9425040
20:23:44 13987 8192000000 10737456800 11161874432 1826591776 18.232 100 24 48 1 1839191040 5367248 7232016
20:24:06 13465 8192000000 10741028176 11172904960 1832702224 18.281 100 10 20 0 1840813552 5414144 2697184
20:24:31 66324 8192000000 10769978304 11190218752 1851101168 18.431 100 39 78 1 1868975072 6619344 11254560
20:25:44 9605 8192000000 10769883808 11191848960 1851337616 18.433 100 26 51 1 1864662544 5785536 7539392
20:26:02 8913 8192000000 10777911488 11200724992 1857335312 18.482 100 28 52 1 1870835776 6097696 7402768
20:26:18 4897 8192000000 10787033712 11204833280 1863075824 18.528 100 46 92 3 1883592208 7536832 12979552
20:26:31 3099 8192000000 10777495184 11204313088 1862684112 18.525 100 38 76 0 1881543216 7219488 11639616
20:26:42 4590 8192000000 10783288640 11205795840 1866250864 18.554 100 39 78 0 1884844592 7161296 11432432
20:26:55 9175 8192000000 10798856928 11218128896 1869478864 18.580 100 31 63 1 1883074176 4655632 8939680
20:27:11 10367 8192000000 10817256576 11231248384 1886993408 18.722 100 37 74 3 1903949552 6300576 10655568
20:27:44 50125 8192000000 10842194624 11260211200 1905566544 18.871 100 44 89 2 1927790688 9915552 12308592
20:28:47 14808 8192000000 10862003104 11276812288 1920856336 18.994 100 58 116 1 1952263216 14086496 17320384
20:29:10 4250 8192000000 10869855424 11285544960 1932069872 19.083 100 62 123 1 1964033248 14523520 17439856
20:29:21 3180 8192000000 10875014048 11284492288 1929882112 19.066 100 60 120 2 1963134560 15526144 17726304
20:29:32 6160 8192000000 10875772704 11295408128 1932514224 19.087 100 62 124 1 1970734576 21045536 17174816
20:29:45 114727 8192000000 10866920496 11305156608 1936036864 19.115 100 41 81 1 1962827792 14860864 11930064
20:32:18 18217 8192000000 10868513312 11310559232 1940044560 19.147 100 21 42 1 1963879216 17405024 6429632
20:32:46 4534 8192000000 10889127536 11312979968 1950824816 19.233 100 58 117 2 1984473040 16323680 17324544
20:32:59 21549 8192000000 10902108976 11320242176 1955411072 19.270 100 61 119 2 1991265456 18930032 16924352
20:33:28 24127 8192000000 10906526704 11330138112 1959742864 19.304 100 52 104 3 1995644736 20436432 15465440
20:34:07 5226 8192000000 10911378256 11336626176 1963613760 19.335 100 61 122 3 2002596416 20230784 18751872
20:34:21 10432 8192000000 10903258464 11335733248 1965683120 19.351 100 48 95 1 2000516544 21291088 13542336
20:34:40 3471 8192000000 10913303296 11339071488 1966111104 19.355 100 54 106 0 2001411264 19883536 15416624
20:34:50 4498 8192000000 10931765888 11347820544 1972615216 19.406 100 65 130 0 2012318608 20782816 18920576
20:35:02 16558 8192000000 10926021824 11347464192 1967850512 19.368 100 62 125 2 2008519952 23160896 17508544
20:35:28 11804 8192000000 10918659600 11348357120 1971830384 19.400 100 58 116 1 2012607712 23899696 16877632
20:35:57 8155 8192000000 10930288160 11354079232 1980010800 19.465 100 75 150 0 2025281648 22989616 22281232
20:36:15 10505 8192000000 10945512624 11369652224 1985660752 19.509 100 64 127 1 2032039296 27266640 19111904
20:36:37 8734 8192000000 10949445440 11369410560 1994169136 19.577 100 78 155 0 2038937392 22288768 22479488
20:36:52 2136 8192000000 10947126496 11358973952 1973705024 19.415 99 75 150 2 2018081440 22288592 22087824
20:37:02 6572 8192000000 10953912080 11365277696 1989909568 19.543 100 80 159 2 2036171312 22748320 23513424
20:37:19 5773 8192000000 10952330256 11372957696 1994341104 19.578 100 71 142 0 2039381584 24259696 20780784
20:37:34 4195 8192000000 10955745504 11377750016 2002519104 19.643 100 76 152 0 2051635616 27022416 22094096
20:37:58 18824 8192000000 10958046784 11392380928 2006240880 19.672 100 57 114 0 2055020928 31384400 17395648
20:38:26 16075 8192000000 10965387552 11400613888 2004691408 19.660 100 45 90 0 2049928608 31076176 14161024
20:38:51 12536 8192000000 10972157264 11408994304 1997674496 19.604 99 45 88 0 2046795408 35008944 14111968
20:39:12 4974 8192000000 10989321040 11419709440 2020199136 19.782 100 58 111 1 2076100368 37858432 18042800
20:39:25 6829 8192000000 10992125344 11427045376 2029550736 19.855 100 73 147 0 2092836256 39672160 23613360
20:39:42 5033 8192000000 11007632800 11436118016 2032956224 19.882 100 74 148 1 2098536368 41620896 23959248
20:39:56 2133 8192000000 11009185536 11437015040 2018777312 19.771 99 73 146 1 2081014880 39116272 23121296
20:40:06 5451 8192000000 11012030112 11437117440 2037721232 19.919 100 73 144 3 2099418528 38518416 23178880
20:40:22 2159 8192000000 11014725088 11433349120 2035506192 19.902 100 90 178 0 2102359856 39428832 27424832
20:40:33 3274 8192000000 10999857712 11420819456 1998770096 19.613 98 79 155 1 2063558272 39981280 24806896
20:40:43 2282 8192000000 10997109808 11419099136 2018732304 19.770 100 78 154 0 2084938208 41827136 24378768
20:40:53 6918 8192000000 11000589280 11423350784 2018008384 19.765 100 68 136 2 2082517376 42223104 22285888
20:41:07 2063 8192000000 10980816864 11397427200 1981641952 19.478 98 74 147 3 2048741504 43767152 23332400
20:41:18 5775 8192000000 10983485648 11408560128 1992576320 19.564 99 72 144 1 2060792960 45200496 23016144
20:41:39 6029 8192000000 10970620496 11386163200 1964564176 19.342 98 73 145 1 2033746256 45118496 24063584
20:41:53 4256 8192000000 10984630048 11408797696 2001092528 19.631 100 71 142 2 2069351744 45634912 22624304
20:42:07 8808 8192000000 10987864592 11417890816 2008603968 19.691 100 63 127 2 2076012256 46798112 20610176
20:42:26 6750 8192000000 10997469472 11419889664 2012819536 19.724 100 75 147 1 2083465440 46141360 24504544
20:42:42 1911 8192000000 11007691440 11423133696 2015127072 19.742 100 82 163 0 2088755920 46963632 26665216
20:42:51 5262 8192000000 10982252800 11401035776 1995042976 19.584 100 78 156 1 2068819104 48275920 25500208
20:43:04 7442 8192000000 10974275600 11392487424 1954876368 19.265 98 78 156 2 2029232544 49357152 24999024
20:43:23 3120 8192000000 10976195360 11388592128 1977487312 19.445 99 77 149 1 2050852192 48890512 24474368
20:43:35 2371 8192000000 10992870768 11406118912 1999453760 19.618 100 81 162 0 2073391280 47660896 26276624
20:43:44 1547 8192000000 10988436160 11401539584 1991866224 19.559 100 78 157 0 2065731792 49026864 24838704
20:43:54 2984 8192000000 10983111280 11391918080 1982230976 19.482 99 84 167 0 2059348800 51013264 26104560
20:44:06 3736 8192000000 10976474464 11391680512 1969888704 19.385 99 78 156 2 2045486224 50755488 24842032
20:44:17 3039 8192000000 10978737712 11398750208 1975579136 19.430 99 75 149 1 2049030224 49704992 23746096
20:44:26 3418 8192000000 10982983504 11394789376 1985071376 19.505 100 87 172 3 2062956112 50746384 27138352
20:44:37 3575 8192000000 10985242928 11398889472 1994296032 19.578 100 89 174 1 2073896720 51687888 27912800
20:44:49 2249 8192000000 10995490656 11408322560 1998640928 19.612 100 87 174 0 2072916144 46452592 27822624
20:44:59 2077 8192000000 10995251856 11410907136 1999388288 19.618 100 85 170 2 2074030752 48007824 26634640
20:45:08 2741 8192000000 10979723728 11396452352 1974106864 19.418 99 86 168 0 2051455168 50002416 27345888
20:45:18 3866 8192000000 10964281184 11383967744 1974728528 19.423 100 74 148 0 2048533264 50315232 23489504
20:45:31 2795 8192000000 10967998048 11379621888 1974958368 19.425 100 85 170 1 2052029872 50141664 26929840
20:45:41 3321 8192000000 10981487984 11400810496 1986303184 19.515 100 74 148 0 2061124368 51346400 23474784
20:45:52 4941 8192000000 10969191952 11396681728 1984047136 19.497 100 65 131 1 2056547104 51676608 20823360
20:46:14 3179 8192000000 10967362160 11393839104 1979748144 19.463 100 55 110 1 2050567168 53199648 17619376
20:46:27 5084 8192000000 10952840960 11391320064 1959124368 19.299 99 42 83 1 2028387824 55010736 14252720
20:46:55 11174 8192000000 10945066784 11377774592 1962924288 19.329 100 59 118 0 2038167824 55795696 19447840
20:47:19 13892 8192000000 10928038848 11363971072 1945977360 19.194 99 37 74 0 2016532608 57143552 13411696
20:47:44 7904 8192000000 10956202864 11389779968 1966513456 19.358 100 54 108 0 2043361456 58340416 18507584
20:48:04 16918 8192000000 10945106400 11379712000 1946770176 19.201 99 36 72 2 2019005408 59286704 12948528
20:48:28 21359 8192000000 10947550224 11393871872 1961817840 19.320 100 37 74 1 2025172064 50203504 13150720
20:48:57 15959 8192000000 10934074304 11396218880 1946978976 19.202 99 30 60 2 2009628496 51667696 10981824
20:49:26 21508 8192000000 10919939024 11382177792 1963844224 19.337 100 32 64 1 2020620656 45950144 10826288
20:50:06 30086 8192000000 10911370064 11363479552 1929861408 19.066 99 21 42 0 1986048192 48122960 8063824
20:50:46 36773 8192000000 10876726800 11330252800 1879120560 18.658 97 15 30 1 1934634224 49564352 5949312
20:51:35 40028 8192000000 10856877184 11328876544 1896304128 18.797 99 21 42 1 1944433920 41474176 6655616
20:52:23 57807 8192000000 10875803216 11314262016 1857159952 18.480 96 13 26 0 1876909584 16078400 3671232
20:53:29 6322 8192000000 10900269728 11333783552 1935842368 19.114 100 59 116 0 1969387760 16548768 16996624
20:53:43 14412 8192000000 10882725424 11342696448 1943419792 19.174 100 32 65 1 1967719568 14884816 9414960
20:54:19 80378 8192000000 10868297328 11337916416 1856688480 18.476 96 13 26 1 1879002752 18783632 3530640
20:55:46 150428 8192000000 10892354768 11335950336 1902826192 18.849 98 12 24 0 1924086848 18480304 2780352
20:58:35 122283 8192000000 10832728912 11289661440 1841072400 18.350 94 18 37 1 1856251776 9810208 5369168
21:00:46 35049 8192000000 10843440256 11300909056 1907424704 18.886 99 10 20 1 1917013920 7493072 2096144
21:01:28 16175 8192000000 10847447488 11297546240 1908639136 18.896 99 20 40 0 1921525488 7447472 5438880
21:01:51 3113 8192000000 10843577360 11287560192 1882521072 18.685 98 26 52 2 1897150016 7172000 7456944
21:02:01 33830 8192000000 10843614784 11300085760 1888072368 18.730 98 26 50 0 1903503248 7140640 8290240
21:02:46 27426 8192000000 10889770720 11320619008 1913276672 18.933 99 29 59 0 1929743872 7964896 8502304
21:03:20 56098 8192000000 10865206048 11332485120 1926037216 19.035 99 36 71 0 1945640432 9154224 10448992
21:04:28 64539 8192000000 10877608720 11342974976 1944803824 19.185 100 13 26 0 1960630976 11260656 4566496
21:05:39 154018 8192000000 10863488336 11335999488 1874589888 18.621 96 15 30 0 1891770000 12495456 4684656
21:08:24 61902 8192000000 10872195856 11334631424 1927148256 19.044 99 28 57 2 1946564240 10710256 8705728
21:09:32 68921 8192000000 10891453888 11343568896 1950401024 19.230 100 21 40 1 1968629008 11846336 6381648
21:11:04 53779 8192000000 10905600752 11353128960 1936558096 19.119 99 31 62 2 1959548896 14268832 8721968
21:12:05 34003 8192000000 10889025520 11352039424 1959483744 19.302 100 30 58 2 1980043248 12221152 8338352
21:12:45 28640 8192000000 10890207664 11351638016 1958732080 19.296 100 12 24 1 1969596000 7166064 3697856
21:13:22 36564 8192000000 10883324208 11357573120 1953050400 19.251 99 31 60 2 1972215328 10275120 8889808
21:14:14 62512 8192000000 10888527856 11362471936 1967712096 19.367 100 12 24 0 1985301344 14033248 3556000
21:15:23 91180 8192000000 10900418400 11370508288 1956147504 19.275 99 28 56 2 1980998032 17293520 7557008
21:17:05 42042 8192000000 10895914112 11380371456 1964808416 19.344 100 10 20 1 1985930416 18277056 2844944
21:18:10 26504 8192000000 10890661664 11370254336 1945493088 19.191 99 12 23 0 1967232832 17825600 3914144
21:19:19 57711 8192000000 10895815760 11368718336 1936143936 19.116 98 21 42 1 1956919696 14768464 6007296
21:20:27 39215 8192000000 10932568224 11396145152 1981263120 19.475 100 30 60 3 2008028496 17860992 8904384
21:21:40 51776 8192000000 10896571600 11389517824 1977893072 19.448 100 11 22 2 1997948608 16550464 3505072
21:22:43 13489 8192000000 10920901952 11372982272 1968956160 19.377 99 47 94 0 1990194208 7245744 13992304
21:23:07 47956 8192000000 10916051424 11369361408 1965769088 19.352 99 38 76 2 1986632592 10325648 10537856
21:24:03 24031 8192000000 10917187872 11368067072 1957764768 19.288 99 40 80 0 1980069312 11505024 10799520
21:24:38 23281 8192000000 10898574112 11351035904 1917261312 18.965 97 41 82 4 1941994128 13566336 11166480
21:25:09 14689 8192000000 10923578400 11369021440 1971884224 19.400 100 40 80 4 1994454976 11329168 11241584
21:25:30 23011 8192000000 10918000528 11377168384 1979241888 19.459 100 43 86 0 2005147440 13797184 12108368
21:26:28 19800 8192000000 10924309344 11368427520 1972914112 19.409 100 38 74 1 1992864032 8898624 11051296
21:26:55 33946 8192000000 10872844736 11338022912 1863736224 18.534 95 31 62 1 1881935472 10150832 8048416
21:27:41 91475 8192000000 10862268768 11333754880 1818098608 18.162 93 12 22 2 1836490048 15246656 3144784
21:29:19 129415 8192000000 10878796544 11326402560 1899830032 18.825 97 34 67 1 1919578032 10388352 9359648
21:31:39 26217 8192000000 10844713328 11319627776 1931678848 19.080 100 22 44 1 1946445792 8820816 5946128
21:32:20 77171 8192000000 10873724176 11347120128 1914867232 18.946 98 13 26 0 1924993616 6848688 3277696
21:33:43 49365 8192000000 10841914384 11323146240 1901521904 18.839 98 2 4 0 1909288864 7642336 124624
21:34:39 19977 8192000000 10879186464 11344220160 1938532880 19.135 99 22 41 1 1951453424 6933616 5986928
21:35:08 35476 8192000000 10877780688 11333025792 1898998192 18.818 97 31 61 0 1915833264 7911488 8923584
21:35:52 29948 8192000000 10867539232 11317956608 1877080416 18.642 96 31 62 1 1895608288 9589776 8938096
21:36:35 34412 8192000000 10875539296 11340460032 1938723984 19.137 100 34 66 2 1960669744 12095408 9850352
21:37:53 71720 8192000000 10854332352 11324010496 1909729856 18.904 98 18 36 0 1928108672 12844736 5534080
21:39:11 53651 8192000000 10881543728 11342508032 1936948432 19.122 99 24 47 1 1954770304 10685920 7135952
21:40:14 35107 8192000000 10885484112 11346182144 1932786160 19.089 99 35 69 2 1956572416 13766976 10019280
21:41:00 89613 8192000000 10882211072 11356622848 1919593920 18.984 98 13 26 1 1934604672 10915936 4094816
21:42:36 40461 8192000000 10897145248 11358740480 1919555024 18.983 98 23 46 0 1935966784 10317584 6094176
21:43:25 29459 8192000000 10887829952 11334914048 1923343536 19.014 99 27 54 2 1944931120 12922928 8664656
21:44:01 61898 8192000000 10866066192 11348426752 1906207824 18.876 98 29 58 2 1929318656 14885344 8225488
21:45:10 62957 8192000000 10878602960 11333545984 1871881680 18.599 96 11 22 0 1883814368 8701248 3231440
21:46:24 29991 8192000000 10884444992 11336134656 1908114288 18.892 98 45 88 0 1933220704 12579152 12527264
21:48:49 68440 8192000000 10838094080 11294420992 1840699712 18.347 95 27 55 0 1856287776 8042160 7545904
21:50:07 40572 8192000000 10855416592 11303968768 1904208464 18.860 99 39 78 1 1924998208 9750672 11039072
21:50:57 76901 8192000000 10857318960 11326590976 1896914256 18.801 98 28 56 1 1918834288 13931584 7988448
21:52:20 50545 8192000000 10853681536 11339026432 1933088800 19.092 100 11 22 2 1950825952 14564448 3172704
21:53:59 79703 8192000000 10865352352 11332435968 1913438016 18.934 99 6 12 0 1926547744 11406880 1702848
21:55:36 76372 8192000000 10867512752 11337256960 1902469392 18.846 98 6 10 0 1915516128 11048976 1997760
21:57:11 74351 8192000000 10879013200 11353702400 1941683664 19.160 99 16 32 1 1955653184 9518448 4451072
21:59:14 53688 8192000000 10886778000 11360088064 1940328240 19.149 99 11 22 0 1953600256 10497504 2774512
22:00:15 55202 8192000000 10897565120 11376226304 1954893232 19.265 99 16 32 1 1970998336 11855232 4249872
22:01:54 77544 8192000000 10909061264 11387928576 1974671440 19.422 100 17 34 2 1996466176 16695232 5099504
22:03:18 43518 8192000000 10912573520 11382345728 1971121216 19.394 99 27 54 1 1987450096 8123344 8205536
22:04:09 37936 8192000000 10934496256 11392864256 1977639872 19.446 99 37 74 0 1998147872 9678416 10829584
22:04:58 64497 8192000000 10913647200 11377606656 1950165360 19.228 98 28 56 0 1966491376 8306608 8019408
22:06:09 63570 8192000000 10928252992 11395166208 1966789776 19.360 99 31 62 0 1984869344 9277184 8802384
22:07:18 20158 8192000000 10934947664 11393056768 1974822464 19.424 99 29 58 1 1991211552 8787552 7601536
22:07:47 32245 8192000000 10964549152 11409768448 2002629680 19.643 100 43 86 3 2024632944 10321440 11681824
22:08:26 35568 8192000000 10948297424 11399434240 1983807184 19.495 99 48 95 0 2009384432 11862128 13715120
22:09:08 48857 8192000000 10924873232 11401773056 1983576720 19.493 99 42 84 2 2007976432 12958448 11441264
22:10:08 143430 8192000000 10895751584 11376517120 1834756240 18.298 92 10 20 1 1848855776 12137488 1962048
22:12:38 137450 8192000000 10897107488 11358924800 1839605504 18.338 93 16 31 2 1857951072 13926400 4419168
22:15:36 83561 8192000000 10864921488 11344695296 1899402448 18.821 97 16 32 0 1919952256 16466768 4083040
22:17:05 55001 8192000000 10848863616 11320619008 1863299664 18.530 96 12 24 0 1879791696 13425920 3066112
22:18:15 70679 8192000000 10863223984 11347976192 1946815328 19.201 100 12 25 0 1961472352 11276656 3380368
22:19:31 49880 8192000000 10870643104 11338563584 1912247952 18.925 98 17 35 0 1928159344 11118144 4793248
22:20:41 71498 8192000000 10845115728 11320541184 1870436256 18.588 96 15 29 1 1893300176 17402112 5461808
22:22:01 130463 8192000000 10860950880 11337216000 1895580304 18.791 98 11 22 0 1911333824 12571648 3181872
22:24:30 20332 8192000000 10874716288 11342774272 1936699424 19.120 99 23 44 2 1949700880 6974336 6027120
22:24:57 34106 8192000000 10866540864 11331252224 1901723232 18.840 97 31 62 0 1918339040 7900496 8715312
22:25:40 39165 8192000000 10869532688 11331993600 1910877136 18.914 98 20 40 0 1924705232 8856336 4971760
22:26:27 50929 8192000000 9121199472 9341767680 287047184 3.385 15 3 6 0 290115104 2269904 798016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 13-01-2021 22:28:35 to 13-01-2021 22:29:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 54 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-01-2021 22:29:07 to 13-01-2021 22:29:09.

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          236435
MON$OLDEST_ACTIVE               238263
MON$OLDEST_SNAPSHOT             238263
MON$NEXT_TRANSACTION            238263
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                       2010688
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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