Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.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 17199784 kB
MemAvailable 31386648 kB
Buffers 0 kB
Cached 14492332 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-09 22:27:10
DTS_END                         2021-01-09 22:27:10.8010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37192
TRN_ID                          246215
ATT_ID                          712
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: 9394.20 21620 1127304
customer order: creation 179.93 356 21592
customer order: refuse 15.34 367 1841
order to supplier: creation 49.09 1332 5891
order to supplier: removal 3.35 94013 402
invoice (draft): creation 47.24 3289 5669
invoice (draft): removal 52.49 807 6299
invoice accept: apply 42.90 17616 5148
invoice accept: cancel 48.03 760 5763
customer reserve: creation 3961.00 174 475320
customer reserve: removal 4685.93 52 562312
realization accept: apply 88.23 190 10588
realization accept: cancel 83.46 95 10015
payment from customer: creation 63.00 138 7560
payment from customer: removal 5.99 70 719
payment to supplier: creation 52.18 142 6262
payment to supplier: removal 3.58 72 430
service: total inventory turnovers 4.69 1086 563
service: total monetary turnovers 6.92 29 830
service: aggregate perf. data 0.80 21032 96
service: refresh index statistics 0.03 290787 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 09-01-2021 22:28:29 to 09-01-2021 22:28:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5186
TEST_TIME 2 5220
TEST_TIME 3 4786
TEST_TIME 4 4901
TEST_TIME 5 4697
TEST_TIME 6 4379
TEST_TIME 7 4615
TEST_TIME 8 5371
TEST_TIME 9 5276
TEST_TIME 10 5646
TEST_TIME 11 5793
TEST_TIME 12 6142
TEST_TIME 13 6378
TEST_TIME 14 6420
TEST_TIME 15 6552
TEST_TIME 16 6670
TEST_TIME 17 6947
TEST_TIME 18 7197
TEST_TIME 19 7930
TEST_TIME 20 7830
TEST_TIME 21 8275
TEST_TIME 22 8400
TEST_TIME 23 9138
TEST_TIME 24 8871
TEST_TIME 25 9271
TEST_TIME 26 9352
TEST_TIME 27 9591
TEST_TIME 28 10396
TEST_TIME 29 10532
TEST_TIME 30 10390
TEST_TIME 31 10232
TEST_TIME 32 10184
TEST_TIME 33 10184
TEST_TIME 34 10209
TEST_TIME 35 10198
TEST_TIME 36 10199
TEST_TIME 37 10252
TEST_TIME 38 10169
TEST_TIME 39 9938
TEST_TIME 40 9854
TEST_TIME 41 9890
TEST_TIME 42 9790
TEST_TIME 43 9694
TEST_TIME 44 9647
TEST_TIME 45 9566
TEST_TIME 46 9758
TEST_TIME 47 9903
TEST_TIME 48 9750
TEST_TIME 49 9795
TEST_TIME 50 9772
TEST_TIME 51 9712
TEST_TIME 52 9807
TEST_TIME 53 9778
TEST_TIME 54 9741
TEST_TIME 55 9769
TEST_TIME 56 9731
TEST_TIME 57 9694
TEST_TIME 58 9837
TEST_TIME 59 9835
TEST_TIME 60 9915
TEST_TIME 61 9871
TEST_TIME 62 9871
TEST_TIME 63 9887
TEST_TIME 64 9889
TEST_TIME 65 9802
TEST_TIME 66 9704
TEST_TIME 67 9657
TEST_TIME 68 9571
TEST_TIME 69 9562
TEST_TIME 70 9541
TEST_TIME 71 9536
TEST_TIME 72 9589
TEST_TIME 73 9511
TEST_TIME 74 9528
TEST_TIME 75 9513
TEST_TIME 76 9528
TEST_TIME 77 9614
TEST_TIME 78 9596
TEST_TIME 79 9573
TEST_TIME 80 9643
TEST_TIME 81 9625
TEST_TIME 82 9574
TEST_TIME 83 9650
TEST_TIME 84 9646
TEST_TIME 85 9675
TEST_TIME 86 9684
TEST_TIME 87 9719
TEST_TIME 88 9767
TEST_TIME 89 9687
TEST_TIME 90 9633
TEST_TIME 91 9596
TEST_TIME 92 9545
TEST_TIME 93 9607
TEST_TIME 94 9530
TEST_TIME 95 9566
TEST_TIME 96 9532
TEST_TIME 97 9589
TEST_TIME 98 9557
TEST_TIME 99 9617
TEST_TIME 100 9615
TEST_TIME 101 9628
TEST_TIME 102 9640
TEST_TIME 103 9679
TEST_TIME 104 9691
TEST_TIME 105 9698
TEST_TIME 106 9762
TEST_TIME 107 9713
TEST_TIME 108 9700
TEST_TIME 109 9656
TEST_TIME 110 9610
TEST_TIME 111 9637
TEST_TIME 112 9588
TEST_TIME 113 9572
TEST_TIME 114 9527
TEST_TIME 115 9531
TEST_TIME 116 9526
TEST_TIME 117 9471
TEST_TIME 118 9487
TEST_TIME 119 9465
TEST_TIME 120 9398

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-01-2021 22:28:33 to 09-01-2021 22:28:36.

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 1566842 1566842 0 0.00 0 22461 7 0 0
doc_list_biud 1566840 1566840 0 0.00 0 29369 24 0 0
sp_add_invoice_to_stock 5335 5148 187 3.50 21 200913 17616 0 187
sp_cancel_adding_invoice 5763 5763 0 0.00 5 66563 761 0 0
sp_cancel_client_order 1841 1841 0 0.00 5 22604 367 0 0
sp_cancel_customer_reserve 562312 562312 0 0.00 1 29393 52 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 2 6479 71 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 3 1384 73 0 0
sp_cancel_supplier_invoice 6318 6299 19 0.30 2 21242 807 0 19
sp_cancel_supplier_order 402 402 0 0.00 7 1129948 94014 0 0
sp_cancel_write_off 10015 10015 0 0.00 1 12390 95 0 0
sp_client_order 21592 21592 0 0.00 4 17809 357 0 0
sp_customer_reserve 475320 475320 0 0.00 0 89581 175 0 0
sp_fill_shopping_cart 33141 33141 0 0.00 1 10521 36 0 0
sp_fill_shopping_cart_clo_res 475315 475315 0 0.00 0 14644 15 0 0
sp_get_clo_for_invoice 5143 5143 0 0.00 0 34771 310 0 0
sp_kill_cost_storno 16927 16927 0 0.00 0 11724 52 0 0
sp_kill_qstorno_ret_qs2qd 1141340 1141340 0 0.00 0 28515 29 0 0
sp_kill_qty_storno 602363 602363 0 0.00 0 29368 63 0 0
sp_lock_selected_doc 21801 21801 0 0.00 0 8447 6 0 0
sp_make_cost_storno 29553 29553 0 0.00 0 22374 56 0 0
sp_multiply_rows_for_pdistr 29553 29553 0 0.00 0 12953 32 0 0
sp_multiply_rows_for_qdistr 21592 21592 0 0.00 0 17789 163 0 0
sp_pay_from_customer 7560 7560 0 0.00 4 30662 138 0 0
sp_pay_to_supplier 6262 6262 0 0.00 5 22782 142 0 0
sp_payment_common 13822 13822 0 0.00 1 30647 38 0 0
sp_qd_handle_on_cancel_clo 1841 1841 0 0.00 0 22597 332 0 0
sp_qd_handle_on_invoice_upd_sts 10906 10906 0 0.00 0 16645 313 0 0
sp_qd_handle_on_reserve_upd_sts 10588 10588 0 0.00 0 18073 64 0 0
sp_reserve_write_off 10588 10588 0 0.00 6 18190 190 0 0
sp_supplier_invoice 5669 5669 0 0.00 7 80985 3290 0 0
sp_supplier_order 5891 5891 0 0.00 4 28417 1333 0 0
srv_aggregate_perf_data 96 96 0 0.00 3213 336471 21032 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1093 127756 34967 0 0
srv_find_qd_qs_mism 1077122 1077122 0 0.00 0 21009 6 0 0
srv_make_invnt_saldo 563 563 0 0.00 31 54547 1086 0 0
srv_make_money_saldo 830 830 0 0.00 0 5154 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 173192 448642 290788 0 0
t$perf-abend:sp_add_invoice_to_stock 187 187 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 19 19 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5148 5148 0 0.00 0 12063 150 0 0
t$perf-norm:sp_cancel_adding_invoice 459 459 0 0.00 0 3781 81 0 0
t$perf-norm:sp_cancel_client_order 1841 1841 0 0.00 0 2117 12 0 0
t$perf-norm:sp_cancel_customer_reserve 743 743 0 0.00 0 4152 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 1317 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 4655 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 340 10 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 30410 1453 0 0
t$perf-norm:sp_cancel_write_off 1057 1057 0 0.00 0 4492 8 0 0
t$perf-norm:sp_client_order 21592 21592 0 0.00 0 13649 18 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 6154 16 0 0
t$perf-norm:sp_pay_from_customer 7560 7560 0 0.00 0 8281 11 0 0
t$perf-norm:sp_pay_to_supplier 6262 6262 0 0.00 0 23114 14 0 0
t$perf-norm:sp_reserve_write_off 10588 10588 0 0.00 0 21243 12 0 0
t$perf-norm:sp_supplier_invoice 5669 5669 0 0.00 0 4095 18 0 0
t$perf-norm:sp_supplier_order 5891 5891 0 0.00 0 7574 16 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 754 26 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 1446 15 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 933 21 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 1257 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 80 22 0 0
v_add_invoice_to_stock 10658 10284 374 3.50 0 5121 18 0 374
v_all_customers 39446 39446 0 0.00 0 22 1 0 0
v_all_suppliers 32108 32108 0 0.00 0 17 1 0 0
v_all_wares 43184 43184 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 918 918 0 0.00 0 465 6 0 0
v_cancel_client_order 3682 3682 0 0.00 0 5182 8 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 2347 5 0 0
v_cancel_customer_reserve 1486 1486 0 0.00 0 2146 7 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 890 8 0 0
v_cancel_supplier_invoice 876 838 38 4.33 0 1272 17 0 38
v_cancel_supplier_order 804 804 0 0.00 0 2063 8 0 0
v_cancel_write_off 2114 2114 0 0.00 0 4505 16 0 0
v_max_id_clo_ord 5883 5883 0 0.00 0 1249 1 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 6936 15 0 0
v_max_id_ord_sup 5666 5666 0 0.00 0 3938 5 0 0
v_max_non_paid_invoice 1757 1757 0 0.00 0 280 2 0 0
v_max_non_paid_realizn 4034 4034 0 0.00 0 2315 4 0 0
v_min_id_clo_ord 5883 5883 0 0.00 0 10509 11 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 5915 17 0 0
v_min_id_ord_sup 5666 5666 0 0.00 0 6380 5 0 0
v_min_non_paid_invoice 6262 6262 0 0.00 0 9441 17 0 0
v_min_non_paid_realizn 7560 7560 0 0.00 0 11459 29 0 0
v_our_firm 10790 10790 0 0.00 0 20 1 0 0
v_reserve_write_off 21176 21176 0 0.00 0 11375 8 0 0
x_lock_depdocs_on_canc_invoice 11643 11643 0 0.00 0 21652 115 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 2678 289 0 0
x_make_qstorno_1000_1200 5891 5891 0 0.00 1 28363 1251 0 0
x_make_qstorno_1200_2000 5669 5669 0 0.00 4 80979 3166 0 0
x_make_qstorno_2100_3300 475320 475320 0 0.00 0 89578 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-01-2021 22:28:37 to 09-01-2021 22:28:41.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 6719 8192000000 9976745600 10244214784 685931216 7.726 57 38 77 0 701319280 1960992 13427072
19:57:34 12288 8192000000 10262939664 10569740288 1317832992 13.857 100 86 172 0 1350614800 3826944 28954864
19:57:53 36933 8192000000 10348165584 10668093440 1384935840 14.461 100 87 174 0 1417424160 4750096 27738224
19:58:40 13053 8192000000 10380583504 10700468224 1437364352 14.926 100 94 188 1 1474564640 6569424 30630864
19:59:07 17448 8192000000 10395566608 10719129600 1454924064 15.081 100 94 188 0 1492618576 7278848 30415664
19:59:39 22105 8192000000 10425411952 10753060864 1474899776 15.257 100 89 178 1 1511111808 7512016 28700016
20:00:11 29518 8192000000 10439851488 10773618688 1491711312 15.404 100 88 176 0 1528610160 8490416 28408432
20:00:51 16128 8192000000 10469885776 10805604352 1511214384 15.574 100 87 174 1 1547361168 8682832 27463952
20:01:29 17038 8192000000 10498559536 10847961088 1551524112 15.923 100 76 152 0 1583896464 8893088 23479264
20:01:53 12952 8192000000 10524125040 10875748352 1584260960 16.205 100 77 154 2 1617609264 9665504 23682800
20:02:18 11951 8192000000 10548170992 10905628672 1609710560 16.422 100 83 164 1 1644473168 10398160 24364448
20:02:41 14554 8192000000 10576088992 10938228736 1631993360 16.612 100 73 143 4 1664149856 10653312 21503184
20:03:04 12737 8192000000 10587407488 10955128832 1660111776 16.850 100 79 158 0 1694896080 11703840 23080464
20:03:25 9972 8192000000 10610450992 10976952320 1673916240 16.966 100 77 154 4 1708391536 11618800 22856496
20:03:44 5951 8192000000 10618056272 10986147840 1680576864 17.022 100 76 152 0 1714822496 12107456 22138176
20:04:00 7742 8192000000 10642442064 11014221824 1704568304 17.223 100 80 158 3 1739807872 12314864 22924704
20:04:16 8378 8192000000 10648385776 11022704640 1714551104 17.307 100 82 164 1 1750653392 12419328 23682960
20:04:34 5875 8192000000 10654937280 11032199168 1724224192 17.387 100 73 146 0 1757373312 12418752 20730368
20:04:50 5359 8192000000 10672900064 11049598976 1733193536 17.462 100 76 150 1 1767485520 13049408 21242576
20:05:03 5615 8192000000 10683346976 11060494336 1749207584 17.595 100 77 154 1 1784064928 13096480 21760864
20:05:18 5195 8192000000 10699179232 11079012352 1759651328 17.682 100 78 156 1 1795597648 13575536 22370784
20:05:30 5304 8192000000 10698180064 11082485760 1767241536 17.744 100 74 147 3 1800480960 12988576 20250848
20:05:43 4790 8192000000 10717799184 11099672576 1780955648 17.857 100 83 166 1 1816974192 12903504 23115040
20:06:01 9183 8192000000 10733050704 11119128576 1783985168 17.882 100 78 156 0 1822729952 17130528 21614256
20:06:18 3906 8192000000 10749099360 11136958464 1804356176 18.050 100 79 156 1 1842909008 17140144 21412688
20:06:28 3197 8192000000 10752922320 11133190144 1808251680 18.082 100 81 163 2 1844415056 13412832 22750544
20:06:39 3017 8192000000 10748040160 11137376256 1813941552 18.128 100 74 148 1 1848110064 12602736 21565776
20:06:48 2888 8192000000 10751630608 11139067904 1822626192 18.199 100 88 174 0 1860712592 13012624 25073776
20:06:57 1974 8192000000 10774476496 11155480576 1825117184 18.219 100 90 178 2 1863084064 13732560 24234320
20:07:06 2286 8192000000 10775861296 11160281088 1831418896 18.271 100 86 172 0 1870657264 14945248 24293120
20:07:15 2802 8192000000 10775909264 11159658496 1835269744 18.302 100 89 179 0 1874145344 13752000 25123600
20:07:25 2314 8192000000 10779125904 11168292864 1844461968 18.377 100 87 174 2 1883666624 14529344 24675312
20:07:34 2010 8192000000 10782400416 11174428672 1847593040 18.403 100 85 170 2 1884667872 13675248 23399584
20:07:43 3897 8192000000 10791547504 11184955392 1855531424 18.467 100 85 169 2 1893382976 13559984 24291568
20:07:54 1849 8192000000 10804180368 11190841344 1861090400 18.512 100 90 177 0 1898851104 12993280 24767424
20:08:02 2900 8192000000 10804651680 11191488512 1858694576 18.493 100 89 178 2 1898082752 13495136 25893040
20:08:11 2573 8192000000 10806962192 11192692736 1864220288 18.537 100 89 178 2 1903341376 13858992 25262096
20:08:20 2022 8192000000 10810351072 11199655936 1866762448 18.558 100 97 193 1 1908003184 14316048 26924688
20:08:29 1547 8192000000 10809564224 11200471040 1865205840 18.545 100 94 188 0 1905820576 13556688 27058048
20:08:37 1847 8192000000 10804131488 11196743680 1870932336 18.592 100 87 173 1 1907631888 12813792 23885760
20:08:45 1652 8192000000 10814471568 11203219456 1871678336 18.598 100 93 187 1 1911259280 12868576 26712368
20:08:54 44812 8192000000 10802931216 11200278528 1862009568 18.520 100 52 102 1 1886054048 8396080 15648400
20:09:45 1171 8192000000 10815275664 11208323072 1873648336 18.614 100 91 184 1 1910447856 10103536 26695984
20:09:53 4509 8192000000 10818264160 11211444224 1875150384 18.626 100 82 162 0 1908282704 11067008 22065312
20:10:03 20049 8192000000 10795773504 11203657728 1866930848 18.559 100 26 53 0 1880794848 6529248 7334752
20:10:30 10249 8192000000 10779844912 11206447104 1870057392 18.585 100 26 52 1 1884116544 6743728 7315424
20:10:49 5067 8192000000 10780614016 11208290304 1874701024 18.622 100 31 64 0 1890497968 6722384 9074560
20:11:02 4371 8192000000 10792450576 11214249984 1876511008 18.637 100 29 58 0 1891900688 6418304 8971376
20:11:14 9735 8192000000 10800486352 11225833472 1878961104 18.657 100 32 64 1 1898794192 10619584 9213504
20:11:30 3571 8192000000 10789140544 11222216704 1881158224 18.674 100 29 58 2 1900346832 11147296 8041312
20:11:40 5060 8192000000 10806837936 11226468352 1883258464 18.691 100 25 50 0 1897608128 7369280 6980384
20:11:53 9439 8192000000 10802329296 11230810112 1889517424 18.742 100 36 72 2 1911171648 11012880 10641344
20:12:09 6845 8192000000 10795915424 11228561408 1890959088 18.754 100 31 62 0 1906574224 6813424 8801712
20:12:23 10158 8192000000 10793057968 11230232576 1889030448 18.738 100 14 28 1 1898072528 5010752 4031328
20:12:40 8381 8192000000 10810377760 11239116800 1896707104 18.800 100 18 36 0 1907363504 5422064 5234336
20:12:54 11728 8192000000 10802527824 11240452096 1899631856 18.823 100 13 26 1 1909059504 5773456 3654192
20:13:12 6466 8192000000 10810258928 11246358528 1904055744 18.859 100 23 46 0 1915971072 5383456 6531872
20:13:29 11887 8192000000 10812151216 11245838336 1902889648 18.850 100 16 32 1 1912978336 5625616 4463072
20:13:48 12091 8192000000 10811847824 11246891008 1905487984 18.870 100 14 28 1 1915182944 5786896 3908064
20:14:10 9226 8192000000 10813524400 11252318208 1905073248 18.867 100 12 24 0 1913889312 5419728 3396336
20:14:27 47064 8192000000 10830216608 11260153856 1908532912 18.895 100 26 52 0 1920886496 5176720 7176864
20:15:23 33952 8192000000 10835691520 11266265088 1913794656 18.937 100 32 64 2 1928710176 6031648 8883872
20:16:04 5611 8192000000 10839564864 11268304896 1912531744 18.927 100 20 40 3 1924664528 6050560 6082224
20:16:18 7183 8192000000 10835945840 11269320704 1916154400 18.956 100 24 48 1 1930078496 7475952 6448144
20:16:31 3173 8192000000 10836243488 11269701632 1917537648 18.967 100 29 59 1 1932854160 7421776 7894736
20:16:43 6579 8192000000 10841308128 11272335360 1918750400 18.977 100 34 68 3 1936388496 8149536 9488560
20:16:56 6400 8192000000 10823946448 11262951424 1916704064 18.960 100 32 64 1 1932503216 7083184 8715968
20:17:10 13822 8192000000 10802532096 11239919616 1879332624 18.660 99 29 58 1 1901856480 14983728 7540128
20:17:31 7842 8192000000 10795188160 11221233664 1862966832 18.527 99 19 38 1 1874454208 5285584 6201792
20:17:49 5227 8192000000 10789274192 11203473408 1824373088 18.213 98 25 50 2 1837657312 5994464 7289760
20:18:00 16519 8192000000 10744782320 11171713024 1758724160 17.674 94 17 34 1 1768581264 4824128 5032976
20:18:24 5748 8192000000 10756320256 11169591296 1819489136 18.174 99 30 58 1 1834241264 6224992 8527136
20:18:39 6177 8192000000 10743648352 11164131328 1783726768 17.880 97 28 56 0 1798456320 6706448 8023104
20:18:51 15397 8192000000 10741140768 11157864448 1764203744 17.719 96 25 49 3 1776603280 4930480 7469056
20:19:14 72664 8192000000 10664317072 11071401984 1535846160 15.788 84 37 72 4 1554450432 8968560 9635712
20:20:34 9279 8192000000 10713385744 11131777024 1765790144 17.732 98 25 50 1 1779337968 6182784 7365040
20:20:51 5899 8192000000 10735707584 11153268736 1796140960 17.982 99 32 61 1 1810897216 6357488 8398768
20:21:03 5611 8192000000 10707736272 11124264960 1728618320 17.424 95 23 46 1 1740967248 5603792 6745136
20:21:17 7591 8192000000 10733313744 11147411456 1795083776 17.974 99 32 64 1 1811379952 6773792 9522384
20:21:35 6810 8192000000 10719265376 11141816320 1796801984 17.988 99 24 47 4 1809698768 6265328 6631456
20:21:52 7608 8192000000 10738861872 11149791232 1817301072 18.156 100 26 53 1 1830118384 4561920 8255392
20:22:07 11343 8192000000 10732475568 11145768960 1769527456 17.763 97 23 45 1 1781921552 5910144 6483952
20:22:27 8078 8192000000 10740209568 11152125952 1785363328 17.894 98 20 40 2 1796423200 5725216 5334656
20:22:44 7322 8192000000 10741833024 11168010240 1819330560 18.172 99 23 46 0 1832614272 5834304 7449408
20:22:59 8418 8192000000 10736516848 11162935296 1816130544 18.146 99 26 50 1 1829623856 5919024 7574288
20:23:16 10808 8192000000 10739846144 11170463744 1838966832 18.332 100 37 73 0 1855193456 5489040 10737584
20:23:35 9233 8192000000 10758251296 11185131520 1845656928 18.387 100 26 52 0 1859051056 5512192 7881936
20:23:53 70115 8192000000 10764788160 11194437632 1850493872 18.426 100 26 50 1 1863108416 5232368 7382176
20:25:09 7692 8192000000 10769857424 11199909888 1858311552 18.490 100 28 56 2 1872529664 6428544 7789568
20:25:27 4889 8192000000 10770647152 11194990592 1857546096 18.483 100 25 50 1 1870917840 6548688 6823056
20:25:38 7110 8192000000 10770742848 11199803392 1858770976 18.493 100 34 68 2 1875055984 6613328 9671680
20:25:53 7417 8192000000 10793147456 11209809920 1865427040 18.547 100 36 72 4 1882422368 6688800 10306528
20:26:08 7359 8192000000 10782553424 11212365824 1863981664 18.536 100 21 41 2 1876032400 5552320 6498416
20:26:25 6670 8192000000 10774612976 11208699904 1866687120 18.557 100 19 38 2 1877930432 5897616 5345696
20:26:38 8598 8192000000 10796444752 11217801216 1868290816 18.570 100 25 50 0 1881676016 5732720 7652480
20:26:54 9304 8192000000 10791824576 11223072768 1876274352 18.635 100 32 64 2 1897405808 10495536 10635920
20:27:09 34100 8192000000 10818508736 11243323392 1893196768 18.772 100 35 68 3 1908673968 4372800 11104400
20:27:55 9615 8192000000 10836098736 11256958976 1907502160 18.887 100 34 65 0 1923078848 6553952 9022736
20:28:12 60589 8192000000 10856610928 11285733376 1923366432 19.014 100 35 69 2 1941540960 8654512 9520016
20:29:21 59008 8192000000 10848639088 11293302784 1930184560 19.068 100 28 56 2 1947013312 8698272 8130480
20:30:27 127756 8192000000 10878799968 11325415424 1944659696 19.184 100 31 62 0 1962166960 8725984 8781280
20:32:45 59172 8192000000 10893988208 11331084288 1960696336 19.312 100 32 64 1 1982165344 11009056 10459952
20:33:54 17561 8192000000 10901454544 11340083200 1972073616 19.402 100 49 96 2 1999350976 12986976 14290384
20:34:20 2672 8192000000 10923095728 11348996096 1973989824 19.417 100 49 99 3 2004955776 16081024 14884928
20:34:29 4968 8192000000 10923741136 11351375872 1978588688 19.454 100 58 112 0 2011200960 15944368 16667904
20:34:43 14735 8192000000 10934447936 11358908416 1983717152 19.494 100 62 124 3 2019800080 18575728 17507200
20:35:07 5899 8192000000 10946152576 11372109824 1991434352 19.555 100 79 158 0 2039469520 24578368 23456800
20:35:21 3745 8192000000 10945927600 11365969920 1991988128 19.560 100 66 130 1 2031114512 19009808 20116576
20:35:32 14572 8192000000 10940097520 11371982848 1992174656 19.561 100 56 110 0 2026973632 18769024 16029952
20:35:59 5461 8192000000 10938365792 11368370176 1991539184 19.556 100 61 122 2 2028464304 19054672 17870448
20:36:12 13456 8192000000 10951166304 11375558656 1995228320 19.585 100 63 122 0 2033341200 19882080 18230800
20:36:33 6480 8192000000 10950926064 11381334016 1995481232 19.587 100 58 116 1 2033286512 20538240 17267040
20:36:48 30727 8192000000 10948042576 11393282048 2000222912 19.624 100 52 104 2 2038320640 22270112 15827616
20:37:37 5166 8192000000 10951361936 11391434752 2003199376 19.648 100 45 90 0 2041006896 24610720 13196800
20:37:51 3779 8192000000 10958194544 11394756608 2007102752 19.679 100 52 104 1 2046779840 24440080 15237008
20:38:02 2175 8192000000 10966850032 11387875328 1995712176 19.589 99 79 155 3 2048317200 29493392 23111632
20:38:11 10058 8192000000 10972211968 11393896448 2005040048 19.662 100 64 127 1 2050588800 27457424 18091328
20:38:30 4759 8192000000 10953129040 11378610176 1983983392 19.496 99 73 145 0 2034216448 28765152 21467904
20:38:48 6705 8192000000 10964538480 11390574592 1987569680 19.525 99 77 154 1 2040840816 30132896 23138240
20:39:05 5884 8192000000 10956998704 11388641280 1996226256 19.593 100 66 133 0 2045304176 28828960 20248960
20:39:33 4681 8192000000 10956839232 11384205312 1981627904 19.478 99 59 115 1 2027808880 28411904 17769072
20:39:45 3174 8192000000 10968680672 11392278528 1984743280 19.502 99 71 140 1 2036715232 30543568 21428384
20:39:55 19204 8192000000 10962467328 11395362816 2000460816 19.626 100 57 114 2 2048377760 31162832 16754112
20:40:25 4312 8192000000 10974051232 11406270464 2016057600 19.749 100 64 128 1 2062153712 26569520 19526592
20:40:36 2890 8192000000 10983763376 11409092608 2017896096 19.764 100 84 167 2 2071682896 28602896 25183904
20:40:50 2383 8192000000 10990125376 11409866752 2016842560 19.755 100 83 164 2 2070742752 28948768 24951424
20:41:00 1261 8192000000 10995989248 11415818240 2019420704 19.776 100 90 176 1 2075493424 29985424 26087296
20:41:08 4107 8192000000 10987499392 11405029376 2001096656 19.631 99 78 156 2 2055615088 30646576 23871856
20:41:19 3938 8192000000 10985161264 11398234112 2009418416 19.697 100 73 144 2 2060649120 29468304 21762400
20:41:33 9885 8192000000 10976341312 11400704000 1991049520 19.552 99 71 142 1 2042522896 30197264 21276112
20:41:53 3900 8192000000 10985164640 11409694720 2008407600 19.689 100 76 150 2 2069127664 37649360 23070704
20:42:04 2333 8192000000 10982163392 11395403776 2009326192 19.696 100 84 166 1 2067683600 33088800 25268608
20:42:14 1990 8192000000 10972220128 11389267968 1988276624 19.530 99 84 168 3 2048044928 34489552 25278752
20:42:23 2812 8192000000 10960265520 11368472576 1962650960 19.327 99 91 181 4 2025443488 35107648 27684880
20:42:32 4030 8192000000 10959888768 11370782720 1970099408 19.386 99 88 174 0 2031006240 35030784 25876048
20:42:44 5360 8192000000 10936673440 11350614016 1955032928 19.267 99 82 162 3 2016463344 36305280 25125136
20:42:58 8600 8192000000 10963184496 11381137408 1962809840 19.328 99 70 140 0 2028825072 43931488 22083744
20:43:23 2906 8192000000 10941482336 11362451456 1954160960 19.260 99 71 143 3 2016218000 39749184 22307856
20:43:35 7026 8192000000 10923941376 11351625728 1945358416 19.189 99 69 137 2 2008145968 40646048 22141504
20:43:52 3489 8192000000 10957631648 11378520064 1977258512 19.443 100 71 142 0 2041762176 41082448 23421216
20:44:03 1092 8192000000 10977180064 11386585088 1986159216 19.513 100 80 155 0 2050374240 40691584 23523440
20:44:10 2897 8192000000 10959614928 11370663936 1960669456 19.311 99 88 175 3 2029067296 41946320 26451520
20:44:20 4496 8192000000 10924260576 11341893632 1937998352 19.131 99 74 150 1 2002087696 41626624 22462720
20:44:32 3099 8192000000 10940364784 11350958080 1953871056 19.257 100 80 161 2 2019186688 40974256 24341376
20:44:47 1927 8192000000 10948533392 11361808384 1961982640 19.322 100 91 179 3 2030096016 40675760 27437616
20:44:57 4630 8192000000 10935410512 11355910144 1953919360 19.258 100 75 148 1 2019314032 41859216 23535456
20:45:09 2543 8192000000 10934183712 11342561280 1944801600 19.185 100 85 169 3 2012327856 42454368 25071888
20:45:18 3403 8192000000 10946721040 11358830592 1956249584 19.276 100 85 170 2 2025129248 42691712 26187952
20:45:28 2505 8192000000 10942491600 11361009664 1958302560 19.293 100 68 136 1 2022584208 43170656 21110992
20:45:42 3061 8192000000 10952943872 11368677376 1966319920 19.356 100 66 130 2 2031228560 45266256 19642384
20:45:53 1345 8192000000 10937341056 11353944064 1933895984 19.098 98 85 169 0 2007687440 48354832 25436624
20:46:02 1542 8192000000 10960756832 11364126720 1959942832 19.306 100 95 189 1 2037881664 49871344 28067488
20:46:10 1844 8192000000 10943609200 11357155328 1949105280 19.219 100 88 177 0 2028144112 51700960 27337872
20:46:18 5227 8192000000 10930785488 11353792512 1949594336 19.223 100 58 116 0 2016317536 48248592 18474608
20:46:41 24587 8192000000 10908432272 11343659008 1927894784 19.050 99 33 66 2 1986475344 47546352 11034208
20:47:13 20211 8192000000 10873366672 11306356736 1862867504 18.527 96 30 60 0 1919546688 45647536 11031648
20:47:41 9963 8192000000 10908099824 11334553600 1915423184 18.950 99 44 88 3 1979235488 48320992 15491312
20:47:59 3770 8192000000 10928902864 11354255360 1941582624 19.159 100 63 126 4 2010540240 48634320 20323296
20:48:12 5517 8192000000 10899731696 11325112320 1877859136 18.648 97 45 90 4 1946176864 53575280 14742448
20:48:29 8197 8192000000 10899244640 11332202496 1906472960 18.878 99 54 108 1 1975336896 50818896 18045040
20:48:48 10185 8192000000 10905327792 11343962112 1926329008 19.038 100 31 62 1 1988384096 50924896 11130192
20:49:13 19859 8192000000 10916618528 11354464256 1933864672 19.098 100 31 62 0 1999045488 54422816 10758000
20:49:43 13086 8192000000 10914089776 11359428608 1931640368 19.080 100 27 54 1 1996891600 55846096 9405136
20:50:05 20862 8192000000 10921788112 11359547392 1938912384 19.138 100 27 53 2 1998203872 50358016 8933472
20:50:51 15294 8192000000 10872646672 11314388992 1886421728 18.717 97 27 54 0 1932607424 37500400 8685296
20:51:12 39037 8192000000 10888779344 11316998144 1882987328 18.689 98 39 78 2 1933105328 37762752 12355248
20:52:06 17693 8192000000 10876654816 11323088896 1901014880 18.834 99 27 55 2 1950397328 40301968 9080480
20:52:41 27020 8192000000 10872170304 11328225280 1879076672 18.658 98 24 46 1 1932166576 45032928 8056976
20:53:14 22205 8192000000 10890671696 11334414336 1910647872 18.912 100 23 46 3 1964199680 45745808 7806000
20:53:44 25885 8192000000 10880068864 11328487424 1900567056 18.831 99 19 38 1 1953166224 46197424 6401744
20:54:17 17281 8192000000 10896917920 11342938112 1913335600 18.933 100 21 42 0 1970314832 49149472 7829760
20:54:40 14472 8192000000 10878352368 11330486272 1896479776 18.798 99 19 39 0 1953200656 49874304 6846576
20:55:05 29716 8192000000 10871278720 11346403328 1919907872 18.986 100 15 30 1 1964135264 39784944 4442448
20:55:43 41118 8192000000 10893161472 11328299008 1931627520 19.080 100 26 51 1 1953819424 14434944 7756960
20:56:34 106120 8192000000 10886800464 11333955584 1894915648 18.785 97 15 29 1 1908379056 9632800 3830608
20:58:27 58581 8192000000 10906997952 11348946944 1949266784 19.221 99 46 89 5 1970277136 7956544 13053808
20:59:35 34594 8192000000 10903460640 11361255424 1950790480 19.233 99 17 33 4 1969204240 13504768 4908992
21:00:17 73979 8192000000 10908997664 11378241536 1948809424 19.217 99 12 24 0 1967363040 15694176 2859440
21:01:38 113629 8192000000 10907987712 11378528256 1913620416 18.936 97 7 14 0 1932508608 17112720 1775472
21:03:56 74879 8192000000 10896357888 11356901376 1954055360 19.259 99 10 20 2 1981298240 24648368 2594512
21:05:17 103830 8192000000 10923715184 11377610752 1986010160 19.512 100 35 70 2 2005492960 8586240 10896560
21:07:07 41401 8192000000 10931123488 11383709696 1972679296 19.407 99 40 80 5 1996819152 12334080 11805776
21:08:15 18283 8192000000 10942754656 11393044480 1993858304 19.574 100 51 102 0 2020513280 11948784 14706192
21:08:40 119898 8192000000 10924361024 11386060800 1978243872 19.451 99 34 68 1 1998943792 10758880 9941040
21:10:52 17704 8192000000 10942566320 11394625536 1979111248 19.458 99 37 74 1 2006015888 15994400 10910240
21:11:20 9898 8192000000 10938270912 11380789248 1983832128 19.495 100 54 108 1 2013138288 11874704 17431456
21:11:41 31982 8192000000 10936495664 11396235264 1997874880 19.606 100 40 81 2 2024978272 14961376 12142016
21:12:24 16742 8192000000 10965924784 11416932352 2017923632 19.764 100 68 133 2 2055335120 17211632 20199856
21:13:00 47162 8192000000 10919477232 11402264576 1982320000 19.483 99 22 44 1 2009587296 20093888 7173408
21:14:05 38986 8192000000 10901937456 11405053952 1965312624 19.348 99 13 26 1 1989815120 20210720 4291776
21:15:30 49955 8192000000 10908325600 11373596672 1947979712 19.210 98 16 32 0 1967109824 14393088 4737024
21:16:42 33525 8192000000 10906497312 11390738432 1977630448 19.446 100 12 24 1 1998700272 17166976 3902848
21:17:23 50665 8192000000 10908748560 11387654144 1980394880 19.468 100 15 30 1 1998799888 14184848 4220160
21:18:41 103764 8192000000 10896194256 11378716672 1910878224 18.914 96 10 20 0 1931297856 17351360 3068272
21:20:39 17044 8192000000 10942861136 11391614976 1983348752 19.491 100 46 92 2 2008115792 11574544 13192496
21:21:04 18397 8192000000 10889367968 11351293952 1942452496 19.166 98 53 104 2 1966144400 8439440 15252464
21:21:29 49721 8192000000 10888609968 11357822976 1912952112 18.930 97 20 40 1 1926887040 8561808 5373120
21:22:25 53121 8192000000 10920987440 11363831808 1924787664 19.025 98 31 62 0 1945825936 12797072 8241200
21:23:25 15402 8192000000 10905507488 11363495936 1968676432 19.375 100 42 84 0 1988854928 8286832 11891664
21:23:54 28303 8192000000 10923723920 11385069568 1977679872 19.446 100 34 68 0 2003353616 16571136 9102608
21:24:35 101950 8192000000 10903672224 11388497920 1926103968 19.036 97 12 24 1 1952502400 22857232 3541200
21:26:23 45404 8192000000 10895298176 11379052544 1941083568 19.155 99 17 35 0 1970329504 24010816 5235120
21:27:22 51852 8192000000 10875119408 11332386816 1863866672 18.535 95 11 22 0 1876424784 9921856 2636256
21:28:20 39151 8192000000 10881289008 11338641408 1899459456 18.822 97 28 56 2 1913857424 7262912 7135056
21:29:06 28090 8192000000 10880089120 11342254080 1921975424 19.003 98 25 50 3 1938035424 9585168 6474832
21:29:45 50279 8192000000 10885225872 11346264064 1900229600 18.828 97 36 72 0 1919270448 9090656 9950192
21:30:41 73743 8192000000 10854093840 11311063040 1786209744 17.901 92 12 24 0 1806874624 17473680 3191200
21:32:08 9537 8192000000 10872479152 11312406528 1921696992 19.000 100 57 113 0 1946217280 8667280 15853008
21:32:26 90186 8192000000 10841525920 11286372352 1811864240 18.111 94 44 88 0 1833090976 9082160 12144576
21:34:11 46676 8192000000 10858291264 11308150784 1894971216 18.786 99 21 41 1 1910688752 9382448 6335088
21:35:07 86856 8192000000 10873636480 11332567040 1914740368 18.945 99 23 46 1 1944049136 21580624 7728144
21:36:40 68087 8192000000 10863416912 11331182592 1876436352 18.636 97 20 40 0 1902036400 19509728 6090320
21:38:04 92694 8192000000 10856082016 11317723136 1893610512 18.775 98 17 34 0 1922609200 23738592 5260096
21:39:50 67312 8192000000 10797102640 11252559872 1779677232 17.847 92 19 38 3 1797324848 11655856 5991760
21:41:07 80146 8192000000 10805194080 11271675904 1831838800 18.274 97 17 33 1 1850545808 13591104 5115904
21:42:33 25708 8192000000 10783918976 11258572800 1860420192 18.507 99 7 14 0 1877296304 14700768 2175344
21:43:10 38175 8192000000 10834386224 11294142464 1871427904 18.596 99 14 29 1 1887590704 11629232 4533568
21:43:57 111265 8192000000 10841486208 11315773440 1889322496 18.740 99 11 22 0 1912303376 19711152 3269728
21:46:13 24709 8192000000 10864538144 11305914368 1873656192 18.614 97 45 88 2 1894090800 8142416 12292192
21:46:47 61735 8192000000 10855288896 11319033856 1903573232 18.855 99 30 60 1 1925823680 12770848 9479600
21:48:02 71587 8192000000 10867139264 11324006400 1910859280 18.914 99 26 52 0 1931111648 12981984 7270384
21:49:20 28626 8192000000 10868085712 11323437056 1901406432 18.838 98 37 74 0 1920660384 9009568 10244384
21:49:58 59103 8192000000 10862359792 11343917056 1935969328 19.115 100 17 34 2 1955276112 14333712 4973072
21:51:03 40344 8192000000 10877557072 11332038656 1915297104 18.949 99 19 38 0 1931317248 10732160 5287984
21:51:52 43935 8192000000 10888742768 11343298560 1947590464 19.207 100 38 76 1 1970392976 12243776 10558736
21:53:51 74271 8192000000 10881810720 11334266880 1869320400 18.579 96 13 26 0 1887688448 14798720 3569328
21:55:11 105969 8192000000 10863241040 11326758912 1920109120 18.988 99 17 34 0 1933413472 8689680 4614672
21:57:26 77229 8192000000 10901045664 11356037120 1918983888 18.979 98 31 62 1 1937109088 10090256 8034944
22:00:12 32585 8192000000 10872876736 11352453120 1923932992 19.018 98 21 41 3 1944284400 14569184 5782224
22:00:53 44606 8192000000 10878522272 11363778560 1958349200 19.293 100 9 18 0 1974329056 13441088 2538768
22:01:50 61513 8192000000 10878274368 11368726528 1945131024 19.188 99 11 22 2 1961350608 13065264 3154320
22:03:01 68795 8192000000 10898783696 11372027904 1951977760 19.242 99 14 29 0 1965224112 9722384 3523968
22:04:16 37637 8192000000 10903806768 11382362112 1960506176 19.310 99 16 32 0 1980813040 15533712 4773152
22:05:02 101910 8192000000 10883686544 11356471296 1940519616 19.151 98 17 34 0 1962470400 17040944 4909840
22:06:50 53603 8192000000 10883985072 11356962816 1915109264 18.948 97 20 40 1 1930033392 8712432 6211696
22:07:56 67821 8192000000 10889774384 11369713664 1943826688 19.177 99 17 34 2 1960929632 12479616 4623328
22:09:57 52718 8192000000 10851876816 11325698048 1862863456 18.526 96 20 40 1 1881777424 13494880 5419088
22:10:57 38586 8192000000 10842214720 11317465088 1866378432 18.555 97 9 18 0 1881582752 12674896 2529424
22:11:45 127676 8192000000 10865939280 11350990848 1863973824 18.535 96 10 20 2 1877726000 11275184 2476992
22:13:59 76767 8192000000 10884555776 11338866688 1902450608 18.846 98 11 22 0 1917096624 11861472 2784544
22:15:23 16579 8192000000 10882879168 11327356928 1889061872 18.738 97 37 74 1 1908880720 9929536 9889312
22:15:48 38411 8192000000 10892702752 11340283904 1913808368 18.937 98 41 82 1 1940284240 15406448 11069424
22:16:33 121002 8192000000 10870116736 11342618624 1937296464 19.125 100 29 58 2 1963826416 18174864 8355088
22:18:43 53513 8192000000 10854631872 11332603904 1919985584 18.987 99 26 48 4 1934098720 7491776 6621360
22:19:45 32578 8192000000 10853682544 11331551232 1925576992 19.031 99 20 40 1 1939341680 7666704 6097984
22:20:24 34718 8192000000 10850758560 11329593344 1922550272 19.007 99 11 22 0 1935071888 9578960 2942656
22:21:05 65460 8192000000 10815601136 11285372928 1859033984 18.495 96 11 22 0 1871771424 9722544 3014896
22:22:17 60349 8192000000 10849655808 11325407232 1908228048 18.892 99 7 14 0 1922852592 12592960 2031584
22:23:24 80949 8192000000 10858877984 11331710976 1918479712 18.975 99 14 28 0 1934249440 11284144 4485584
22:24:52 49894 8192000000 10846821888 11332071424 1918867744 18.978 99 17 34 2 1935019296 10891376 5260176
22:25:49 57323 8192000000 10837273904 11310465024 1831006464 18.268 95 10 20 0 1846788288 13312640 2469184
22:26:52 24571 8192000000 9189932528 9437040640 353578528 4.137 19 2 4 0 355955888 2252736 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-01-2021 22:28:43 to 09-01-2021 22:29:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 187 v_add_invoice_to_stock 335544517
except 19 v_cancel_supplier_invoice 335544517

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

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          245869
MON$OLDEST_ACTIVE               246578
MON$OLDEST_SNAPSHOT             246578
MON$NEXT_TRANSACTION            246578
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                       2040288
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 ---
:632: 
:633: mscs-test-161.budzdorov.ru    Sat Jan  9 22:27:19 2021
:634:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:635: 
--- end of diff output ---

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

09.01.21 22:29:18. 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-09 22:29:20 No severe PSQL-related problems occured
09.01.21 22:29:21. End of report.