Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.12.2020 19: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 17175476 kB
MemAvailable 31487832 kB
Buffers 0 kB
Cached 14539460 kB
SwapCached 4820 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 2020-12-27 19:27:06
DTS_END                         2020-12-27 19:27:06.4930
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57608
TRN_ID                          244779
ATT_ID                          677
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: 9564.52 28028 1147742
customer order: creation 175.23 310 21027
customer order: refuse 15.23 327 1827
order to supplier: creation 46.65 1214 5598
order to supplier: removal 3.47 105097 416
invoice (draft): creation 46.39 3113 5567
invoice (draft): removal 55.65 831 6678
invoice accept: apply 43.39 16751 5207
invoice accept: cancel 49.88 795 5985
customer reserve: creation 3996.72 166 479606
customer reserve: removal 4828.02 58 579362
realization accept: apply 85.15 193 10218
realization accept: cancel 88.00 103 10560
payment from customer: creation 59.33 122 7120
payment from customer: removal 5.77 72 692
payment to supplier: creation 49.05 159 5886
payment to supplier: removal 3.51 82 421
service: total inventory turnovers 5.04 974 605
service: total monetary turnovers 7.08 38 849
service: aggregate perf. data 0.95 18918 114
service: refresh index statistics 0.03 411238 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-12-2020 19:29:06 to 27-12-2020 19:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5067
TEST_TIME 2 4172
TEST_TIME 3 3533
TEST_TIME 4 3102
TEST_TIME 5 3779
TEST_TIME 6 3539
TEST_TIME 7 3567
TEST_TIME 8 4796
TEST_TIME 9 5250
TEST_TIME 10 5368
TEST_TIME 11 5487
TEST_TIME 12 5866
TEST_TIME 13 6060
TEST_TIME 14 7124
TEST_TIME 15 7555
TEST_TIME 16 8024
TEST_TIME 17 8161
TEST_TIME 18 8169
TEST_TIME 19 8591
TEST_TIME 20 8624
TEST_TIME 21 8674
TEST_TIME 22 8860
TEST_TIME 23 9011
TEST_TIME 24 9654
TEST_TIME 25 9560
TEST_TIME 26 10210
TEST_TIME 27 10602
TEST_TIME 28 11704
TEST_TIME 29 11425
TEST_TIME 30 11261
TEST_TIME 31 11144
TEST_TIME 32 11408
TEST_TIME 33 11352
TEST_TIME 34 11301
TEST_TIME 35 10994
TEST_TIME 36 10885
TEST_TIME 37 10819
TEST_TIME 38 10909
TEST_TIME 39 10783
TEST_TIME 40 10671
TEST_TIME 41 10604
TEST_TIME 42 10527
TEST_TIME 43 10551
TEST_TIME 44 10427
TEST_TIME 45 10362
TEST_TIME 46 10427
TEST_TIME 47 10287
TEST_TIME 48 10253
TEST_TIME 49 10195
TEST_TIME 50 10203
TEST_TIME 51 10068
TEST_TIME 52 10043
TEST_TIME 53 10093
TEST_TIME 54 10077
TEST_TIME 55 10040
TEST_TIME 56 9984
TEST_TIME 57 9943
TEST_TIME 58 10075
TEST_TIME 59 10211
TEST_TIME 60 10128
TEST_TIME 61 10141
TEST_TIME 62 10198
TEST_TIME 63 10289
TEST_TIME 64 10301
TEST_TIME 65 10376
TEST_TIME 66 10329
TEST_TIME 67 10231
TEST_TIME 68 10234
TEST_TIME 69 10195
TEST_TIME 70 10111
TEST_TIME 71 10130
TEST_TIME 72 10065
TEST_TIME 73 10016
TEST_TIME 74 9955
TEST_TIME 75 9906
TEST_TIME 76 9841
TEST_TIME 77 9828
TEST_TIME 78 9868
TEST_TIME 79 9851
TEST_TIME 80 9847
TEST_TIME 81 9949
TEST_TIME 82 9991
TEST_TIME 83 9984
TEST_TIME 84 9980
TEST_TIME 85 9988
TEST_TIME 86 10038
TEST_TIME 87 10047
TEST_TIME 88 10092
TEST_TIME 89 10054
TEST_TIME 90 10041
TEST_TIME 91 9993
TEST_TIME 92 9943
TEST_TIME 93 9904
TEST_TIME 94 9831
TEST_TIME 95 9865
TEST_TIME 96 9858
TEST_TIME 97 9840
TEST_TIME 98 9864
TEST_TIME 99 9872
TEST_TIME 100 9855
TEST_TIME 101 9843
TEST_TIME 102 9873
TEST_TIME 103 9879
TEST_TIME 104 9872
TEST_TIME 105 9922
TEST_TIME 106 9977
TEST_TIME 107 9960
TEST_TIME 108 9935
TEST_TIME 109 9974
TEST_TIME 110 9925
TEST_TIME 111 9856
TEST_TIME 112 9833
TEST_TIME 113 9799
TEST_TIME 114 9812
TEST_TIME 115 9755
TEST_TIME 116 9738
TEST_TIME 117 9729
TEST_TIME 118 9684
TEST_TIME 119 9643
TEST_TIME 120 9569

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-12-2020 19:29:10 to 27-12-2020 19:29:13.

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 1591560 1591560 0 0.00 0 25507 6 0 0
doc_list_biud 1591560 1591560 0 0.00 0 70106 27 0 0
sp_add_invoice_to_stock 5311 5207 104 1.95 25 189529 16751 0 104
sp_cancel_adding_invoice 5985 5985 0 0.00 5 83462 795 0 0
sp_cancel_client_order 1827 1827 0 0.00 4 11665 327 0 0
sp_cancel_customer_reserve 579362 579362 0 0.00 1 21796 59 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 2 5268 72 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 5082 83 0 0
sp_cancel_supplier_invoice 6693 6678 15 0.22 1 26586 831 0 15
sp_cancel_supplier_order 416 416 0 0.00 6 1244604 105098 0 0
sp_cancel_write_off 10560 10560 0 0.00 1 7278 103 0 0
sp_client_order 21027 21027 0 0.00 4 17711 311 0 0
sp_customer_reserve 479606 479606 0 0.00 0 137347 167 0 0
sp_fill_shopping_cart 32186 32186 0 0.00 1 13240 39 0 0
sp_fill_shopping_cart_clo_res 479602 479602 0 0.00 0 20335 13 0 0
sp_get_clo_for_invoice 5201 5201 0 0.00 0 21001 281 0 0
sp_kill_cost_storno 17658 17658 0 0.00 0 16872 57 0 0
sp_kill_qstorno_ret_qs2qd 1176378 1176378 0 0.00 0 26566 32 0 0
sp_kill_qty_storno 620247 620247 0 0.00 0 70105 69 0 0
sp_lock_selected_doc 21386 21386 0 0.00 0 8892 5 0 0
sp_make_cost_storno 28425 28425 0 0.00 0 24061 77 0 0
sp_multiply_rows_for_pdistr 28425 28425 0 0.00 0 16853 31 0 0
sp_multiply_rows_for_qdistr 21027 21027 0 0.00 0 17290 145 0 0
sp_pay_from_customer 7120 7120 0 0.00 4 23917 123 0 0
sp_pay_to_supplier 5886 5886 0 0.00 4 25657 159 0 0
sp_payment_common 13006 13006 0 0.00 1 22350 39 0 0
sp_qd_handle_on_cancel_clo 1827 1827 0 0.00 0 11613 303 0 0
sp_qd_handle_on_invoice_upd_sts 11186 11186 0 0.00 0 70104 323 0 0
sp_qd_handle_on_reserve_upd_sts 10218 10218 0 0.00 0 16775 60 0 0
sp_reserve_write_off 10218 10218 0 0.00 6 25606 193 0 0
sp_supplier_invoice 5567 5567 0 0.00 5 142598 3113 0 0
sp_supplier_order 5598 5598 0 0.00 5 34750 1214 0 0
srv_aggregate_perf_data 114 114 0 0.00 2461 259685 18918 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1217 152504 33826 0 0
srv_find_qd_qs_mism 1098847 1098847 0 0.00 0 20295 5 0 0
srv_make_invnt_saldo 605 605 0 0.00 34 65080 974 0 0
srv_make_money_saldo 849 849 0 0.00 0 7585 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 327707 452777 411238 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5207 5207 0 0.00 0 22680 137 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 8212 123 0 0
t$perf-norm:sp_cancel_client_order 1827 1827 0 0.00 0 3370 13 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 565 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 7509 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 1032 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 2037 19 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 39104 1774 0 0
t$perf-norm:sp_cancel_write_off 1092 1092 0 0.00 0 2119 7 0 0
t$perf-norm:sp_client_order 21027 21027 0 0.00 0 18714 19 0 0
t$perf-norm:sp_customer_reserve 1074 1074 0 0.00 0 1093 7 0 0
t$perf-norm:sp_pay_from_customer 7120 7120 0 0.00 0 18693 15 0 0
t$perf-norm:sp_pay_to_supplier 5886 5886 0 0.00 0 9525 10 0 0
t$perf-norm:sp_reserve_write_off 10218 10218 0 0.00 0 18675 14 0 0
t$perf-norm:sp_supplier_invoice 5567 5567 0 0.00 0 4429 14 0 0
t$perf-norm:sp_supplier_order 5598 5598 0 0.00 0 6293 15 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 477 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 558 6 0 0
t$perf-norm:srv_make_invnt_saldo 605 605 0 0.00 0 1505 19 0 0
t$perf-norm:srv_make_money_saldo 849 849 0 0.00 0 4835 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 216 56 0 0
v_add_invoice_to_stock 10610 10402 208 1.96 0 5042 16 0 208
v_all_customers 38230 38230 0 0.00 0 21 1 0 0
v_all_suppliers 31054 31054 0 0.00 0 22 1 0 0
v_all_wares 42052 42052 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 2113 9 0 0
v_cancel_client_order 3654 3654 0 0.00 0 2461 4 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 566 4 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 1007 4 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 5073 9 0 0
v_cancel_supplier_invoice 870 840 30 3.44 0 352 12 0 30
v_cancel_supplier_order 832 832 0 0.00 0 168 3 0 0
v_cancel_write_off 2184 2184 0 0.00 0 1989 13 0 0
v_max_id_clo_ord 5595 5595 0 0.00 0 254 1 0 0
v_max_id_clo_res 1074 1074 0 0.00 0 4041 17 0 0
v_max_id_ord_sup 5565 5565 0 0.00 0 12520 6 0 0
v_max_non_paid_invoice 1519 1519 0 0.00 0 1243 3 0 0
v_max_non_paid_realizn 3740 3740 0 0.00 0 3227 5 0 0
v_min_id_clo_ord 5595 5595 0 0.00 0 7437 12 0 0
v_min_id_clo_res 1074 1074 0 0.00 0 9005 14 0 0
v_min_id_ord_sup 5565 5565 0 0.00 0 5647 9 0 0
v_min_non_paid_invoice 5886 5886 0 0.00 0 12982 36 0 0
v_min_non_paid_realizn 7120 7120 0 0.00 0 15266 24 0 0
v_our_firm 10582 10582 0 0.00 0 18 1 0 0
v_reserve_write_off 20436 20436 0 0.00 0 2092 3 0 0
x_lock_depdocs_on_canc_invoice 12243 12243 0 0.00 0 14674 108 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 12808 357 0 0
x_make_qstorno_1000_1200 5598 5598 0 0.00 2 34744 1134 0 0
x_make_qstorno_1200_2000 5567 5567 0 0.00 3 138928 2975 0 0
x_make_qstorno_2100_3300 479606 479606 0 0.00 0 137344 151 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 27-12-2020 19:29:14 to 27-12-2020 19:29:19.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 23975 8192000000 10263753968 10575491072 819159600 9.090 64 46 92 0 837128992 2428352 15541040
16:57:49 22546 8192000000 10337445216 10652213248 1379181408 14.409 100 82 165 0 1410468928 4748256 26539264
16:58:27 24325 8192000000 10375700224 10698133504 1416999424 14.746 100 88 176 0 1452789344 6180064 29609856
16:59:04 19203 8192000000 10393060912 10720313344 1453514512 15.069 100 87 174 1 1489629072 7242208 28872352
16:59:32 26447 8192000000 10419964048 10751381504 1469969328 15.213 100 89 178 0 1506408848 7816720 28622800
17:00:07 19786 8192000000 10443531360 10775351296 1497922592 15.458 100 92 184 0 1536513600 8743152 29847856
17:00:34 16215 8192000000 10461436752 10795364352 1512540960 15.585 100 89 178 2 1550703056 9330960 28831136
17:00:59 19939 8192000000 10487975616 10829094912 1533232736 15.765 100 81 162 0 1567560496 9074480 25253280
17:01:29 12344 8192000000 10511625072 10860920832 1562190864 16.015 100 75 150 1 1594372528 9028992 23152672
17:01:51 15541 8192000000 10541017952 10893709312 1602620368 16.362 100 83 164 4 1637056368 9669712 24766288
17:02:15 17624 8192000000 10570761296 10929168384 1634436800 16.633 100 85 170 0 1670518736 10785136 25296800
17:02:45 7132 8192000000 10584146032 10946375680 1645305216 16.725 100 76 152 1 1679337168 11519344 22512608
17:03:05 9581 8192000000 10594049776 10955952128 1659701984 16.846 100 77 154 0 1694127984 12173152 22252848
17:03:24 7068 8192000000 10612389200 10980306944 1670410640 16.937 100 72 144 0 1703246912 11920080 20916192
17:03:41 9227 8192000000 10629380416 11001352192 1690268848 17.104 100 72 143 1 1721625712 11252288 20104576
17:03:58 8388 8192000000 10653220528 11026534400 1713094160 17.295 100 75 150 0 1746398848 12087968 21216720
17:04:14 8037 8192000000 10671781040 11048124416 1730787280 17.442 100 77 154 1 1764881872 12418416 21676176
17:04:30 4256 8192000000 10682696608 11055353856 1739655168 17.516 100 82 165 1 1775367056 12946704 22765184
17:04:42 7498 8192000000 10681300192 11061456896 1748560256 17.590 100 81 162 1 1783568272 12697360 22310656
17:04:57 5209 8192000000 10691307040 11072532480 1755403568 17.646 100 77 154 1 1789905584 13559984 20942032
17:05:09 4158 8192000000 10710953584 11090120704 1767499856 17.746 100 80 160 1 1804122352 14271584 22350912
17:05:21 3823 8192000000 10714071424 11093856256 1778096560 17.834 100 81 162 0 1814112736 13857536 22158640
17:05:32 10237 8192000000 10715735696 11100831744 1786050272 17.899 100 74 148 1 1820382880 13994912 20337696
17:05:50 5450 8192000000 10736468912 11124494336 1793698112 17.962 100 71 142 0 1826408752 13220432 19490208
17:06:03 3663 8192000000 10750606240 11134435328 1809629488 18.093 100 76 152 0 1844360416 13377888 21353040
17:06:13 3221 8192000000 10743711808 11135569920 1815660448 18.142 100 71 142 0 1847173680 11743424 19769808
17:06:23 2839 8192000000 10761801552 11145633792 1826188480 18.228 100 82 164 1 1861930848 12348464 23393904
17:06:33 2875 8192000000 10768313632 11154063360 1830716928 18.265 100 83 167 2 1866457904 12452560 23288416
17:06:42 2648 8192000000 10771814480 11161202688 1833344976 18.287 100 84 167 4 1869987840 13568144 23074720
17:06:51 2321 8192000000 10776044528 11164037120 1832907536 18.283 100 79 158 1 1869610512 13897184 22805792
17:07:00 1919 8192000000 10787026928 11171553280 1843530320 18.370 100 90 181 2 1883363216 14731136 25101760
17:07:09 2523 8192000000 10793748880 11177082880 1843384448 18.368 100 84 168 0 1881277920 13321072 24572400
17:07:17 1968 8192000000 10797622800 11183259648 1851803904 18.437 100 81 164 1 1888954336 13159296 23991136
17:07:26 2056 8192000000 10795687728 11182956544 1857352352 18.482 100 89 178 3 1895514960 13057888 25104720
17:07:34 2839 8192000000 10798387952 11190210560 1861783568 18.518 100 83 166 1 1898097936 12366880 23947488
17:07:44 1947 8192000000 10802426464 11190521856 1857833712 18.486 100 87 174 0 1895088240 12561280 24693248
17:07:52 1746 8192000000 10794303392 11185246208 1860203216 18.505 100 83 162 0 1895656240 12635968 22817056
17:08:01 1275 8192000000 10809187040 11197186048 1864522384 18.540 100 94 191 2 1905526416 14236416 26767616
17:08:08 1818 8192000000 10811507824 11198545920 1864632480 18.541 100 85 168 0 1902378816 13993568 23752768
17:08:17 2119 8192000000 10814936624 11201220608 1869785760 18.583 100 92 182 2 1909024368 13498384 25740224
17:08:26 1657 8192000000 10819552416 11206533120 1870846832 18.591 100 91 182 0 1909902528 13544656 25511040
17:08:34 1679 8192000000 10815971536 11205152768 1871213040 18.594 100 95 190 2 1911522528 13307856 27001632
17:08:42 24335 8192000000 10795298336 11197489152 1866009504 18.552 100 42 84 0 1885887264 7716912 12160848
17:09:15 20728 8192000000 10795642192 11200319488 1868765008 18.574 100 55 110 2 1893207680 9194736 15247936
17:09:42 8973 8192000000 10788425328 11203592192 1873060272 18.609 100 70 140 1 1904495008 11814560 19620176
17:09:58 4824 8192000000 10783828992 11205603328 1867008976 18.560 100 30 58 2 1887179488 12327152 7843360
17:10:10 5442 8192000000 10784527568 11203895296 1870172224 18.586 100 30 57 1 1883917312 6775344 6969744
17:10:22 3933 8192000000 10789879936 11207716864 1874506608 18.621 100 48 96 2 1895057216 6497968 14052640
17:10:35 6027 8192000000 10785485888 11210153984 1873380272 18.612 100 32 64 2 1889804112 7369312 9054528
17:10:50 4979 8192000000 10777519184 11210465280 1876783264 18.639 100 26 53 1 1891834384 6848752 8202368
17:11:01 4935 8192000000 10787217568 11218841600 1875607920 18.630 100 21 42 0 1887389072 6495520 5285632
17:11:12 7591 8192000000 10784828240 11215802368 1880884896 18.672 100 27 54 2 1895817952 7210288 7722768
17:11:26 7259 8192000000 10794345184 11221651456 1882205648 18.683 100 19 38 1 1893367920 5966144 5196128
17:11:41 12328 8192000000 10792657072 11227254784 1886303296 18.716 100 20 40 2 1901650880 10147328 5200256
17:12:01 9217 8192000000 10801185392 11228758016 1891436384 18.757 100 21 42 0 1903311168 6114448 5760336
17:12:18 10120 8192000000 10794560304 11230273536 1892811552 18.768 100 17 34 2 1903709328 6355808 4541968
17:12:34 14239 8192000000 10799916560 11232083968 1892218624 18.764 100 14 28 0 1901506896 5519408 3768864
17:12:55 14938 8192000000 10818187360 11233517568 1895840576 18.793 100 25 48 2 1908498432 6170448 6487408
17:13:16 72683 8192000000 10804106640 11246764032 1899518720 18.822 100 23 43 1 1912178816 5576688 7083408
17:14:35 5525 8192000000 10808764352 11248312320 1902281696 18.845 100 30 60 0 1917374512 6749552 8343264
17:14:48 7053 8192000000 10825239968 11254661120 1906270304 18.877 100 38 71 5 1923571456 7514624 9786528
17:15:03 4055 8192000000 10821906736 11257896960 1907774416 18.889 100 31 60 4 1922231472 6351888 8105168
17:15:14 4261 8192000000 10826980224 11258314752 1910727440 18.912 100 30 58 1 1926302672 7348272 8226960
17:15:25 5021 8192000000 10835080960 11264040960 1914964704 18.946 100 40 80 3 1932791216 6412048 11414464
17:15:40 8945 8192000000 10829804688 11260628992 1909223424 18.900 100 23 46 1 1921663792 5625600 6814768
17:15:55 7204 8192000000 10831666944 11259314176 1895894080 18.793 99 23 46 1 1909368800 6467584 7007136
17:16:10 9342 8192000000 10823329888 11258904576 1907225664 18.884 100 26 49 1 1920068400 5860912 6981824
17:16:26 10747 8192000000 10826459248 11263668224 1894173024 18.779 99 19 38 2 1905378656 5649792 5555840
17:16:45 7705 8192000000 10808528432 11235766272 1872103584 18.601 98 29 57 1 1886235360 5459712 8672064
17:16:58 8945 8192000000 10805552032 11245219840 1899433632 18.822 100 17 34 0 1909850272 5370912 5045728
17:17:16 11032 8192000000 10781027136 11217010688 1813977600 18.128 95 16 32 1 1824216800 5590800 4648400
17:17:35 18068 8192000000 10748979952 11168763904 1696200848 17.153 90 16 32 0 1705935712 4729984 5004880
17:18:06 48670 8192000000 10789630304 11182551040 1833207936 18.285 98 71 144 0 1860546576 6265472 21073168
17:19:03 11518 8192000000 10741832512 11177226240 1785261296 17.893 96 25 50 1 1798313456 6232128 6820032
17:19:24 10307 8192000000 10713886048 11127738368 1725115664 17.395 94 18 36 2 1736067664 5691504 5260496
17:19:43 6256 8192000000 10729382144 11153805312 1789927216 17.931 98 21 42 6 1801891056 6536656 5427184
17:19:58 7568 8192000000 10743679472 11163291648 1796345232 17.984 98 29 58 2 1811233616 6649664 8238720
17:20:12 4799 8192000000 10718405152 11136122880 1793747152 17.963 98 27 54 0 1808095856 6127696 8221008
17:20:26 7650 8192000000 10678792176 11093749760 1713727040 17.300 95 23 46 1 1726346352 4807920 7811392
17:20:40 10601 8192000000 10676952512 11082833920 1659463264 16.844 93 24 48 0 1671797952 5295728 7038960
17:20:58 7499 8192000000 10684554048 11103551488 1741704752 17.533 98 33 64 2 1757108224 5163936 10239536
17:21:15 7123 8192000000 10715835072 11135803392 1791647456 17.945 100 30 59 3 1815480752 15177968 8655328
17:21:32 7792 8192000000 10709347056 11118624768 1785282768 17.893 99 32 63 0 1800935584 6107328 9545488
17:21:50 10348 8192000000 10718438720 11136933888 1787608624 17.912 99 25 50 2 1800482112 5185040 7688448
17:22:07 9603 8192000000 10729507280 11143446528 1803883264 18.046 100 29 57 2 1817476384 5328544 8264576
17:22:31 65544 8192000000 10738143712 11158110208 1810055936 18.096 99 29 59 0 1822791024 4385184 8349904
17:23:43 14735 8192000000 10732803824 11165634560 1826538592 18.231 100 15 29 2 1835794384 5231248 4024544
17:24:04 8205 8192000000 10758215024 11176235008 1838032960 18.325 100 34 67 3 1854249168 6321248 9894960
17:24:18 5036 8192000000 10765453344 11187335168 1847766656 18.404 100 41 83 3 1867824208 8679312 11378240
17:24:29 6653 8192000000 10766617728 11188899840 1850779728 18.428 100 30 60 0 1866023808 6449904 8794176
17:24:42 8838 8192000000 10761669856 11187691520 1847548192 18.402 100 17 34 1 1857633904 5555424 4530288
17:24:57 6060 8192000000 10758791184 11194159104 1850956704 18.430 100 32 64 1 1870823056 10627280 9239072
17:25:09 5413 8192000000 10756012992 11189374976 1849278368 18.416 100 23 46 1 1861746496 5725152 6742976
17:25:21 13135 8192000000 10762897232 11190964224 1850446384 18.426 100 12 24 1 1858846144 4860400 3539360
17:25:42 13350 8192000000 10764271440 11196334080 1854138864 18.456 100 22 44 2 1866567040 6183408 6244768
17:26:03 14506 8192000000 10761190240 11197198336 1855791024 18.469 100 11 22 1 1863866688 4837968 3237696
17:26:28 9275 8192000000 10781706544 11206856704 1862767024 18.526 100 21 42 3 1874753056 5149312 6836720
17:26:46 10379 8192000000 10776433840 11212238848 1868140704 18.569 100 19 36 1 1879045648 5225952 5678992
17:27:04 9908 8192000000 10805369600 11224764416 1882123088 18.682 100 26 53 0 1894003104 5131136 6748880
17:27:23 70516 8192000000 10832511856 11257221120 1898313392 18.813 100 40 80 0 1917491168 7068992 12108784
17:28:51 19574 8192000000 10849278592 11270905856 1918593936 18.976 100 40 80 0 1941258704 11216672 11448096
17:29:21 123467 8192000000 10872519376 11306778624 1936591776 19.120 100 36 72 0 1959894944 12846000 10457168
17:31:32 87354 8192000000 10872021216 11318980608 1946291440 19.197 100 24 48 1 1970856176 17924176 6640560
17:33:06 35293 8192000000 10883993376 11317927936 1934793216 19.105 99 36 72 2 1963066032 17725152 10547664
17:33:49 36140 8192000000 10898950816 11332702208 1956729232 19.280 100 26 50 1 1985643264 21042128 7871904
17:34:32 12468 8192000000 10913022752 11342860288 1965394784 19.349 100 47 94 2 2004798912 24846560 14557568
17:34:52 9614 8192000000 10919505600 11345715200 1963202992 19.331 100 58 116 2 2007847840 26535232 18109616
17:35:18 7666 8192000000 10927694528 11349254144 1970021232 19.386 100 50 99 1 2011422960 25403904 15997824
17:35:35 7007 8192000000 10923036112 11357782016 1974831728 19.424 100 47 94 2 2016759552 26652832 15274992
17:35:58 7384 8192000000 10937135232 11363336192 1981703184 19.478 100 60 120 0 2024283552 24170144 18410224
17:36:16 9509 8192000000 10941095936 11373363200 1987842880 19.527 100 62 124 1 2033139408 26082224 19214304
17:36:33 9097 8192000000 10944015936 11374653440 1976223536 19.435 99 60 120 1 2020408528 25623456 18561536
17:36:50 3282 8192000000 10957260960 11382304768 1994993920 19.583 100 59 114 1 2037714464 25210352 17510192
17:37:02 7527 8192000000 10967485456 11392978944 2003502592 19.650 100 70 138 0 2052930832 28246688 21181552
17:37:17 2619 8192000000 10964202672 11396902912 2007322816 19.680 100 57 114 1 2053290240 28098048 17869376
17:37:27 1815 8192000000 10958247904 11373973504 1975265248 19.427 98 84 166 2 2027643392 28347776 24030368
17:37:36 2525 8192000000 10963469392 11392835584 2001923376 19.638 100 65 130 1 2051133200 30107984 19101840
17:37:45 2181 8192000000 10977049040 11395129344 2007877504 19.685 100 84 170 1 2063736464 31323856 24535104
17:37:55 7388 8192000000 10982300000 11398057984 2005751184 19.668 100 79 155 2 2060899968 32572784 22576000
17:38:12 2142 8192000000 10979036784 11404279808 2009448112 19.697 100 80 160 3 2070426928 36136096 24842720
17:38:21 5166 8192000000 10966769072 11391553536 1983123104 19.489 99 77 154 0 2042493120 36187504 23182512
17:38:39 9188 8192000000 10964067504 11392688128 1991197616 19.553 100 58 116 1 2047286096 38260160 17828320
17:38:55 3741 8192000000 10978656608 11399237632 1999352048 19.618 100 77 152 1 2063129952 39310928 24466976
17:39:06 5131 8192000000 10971530768 11396026368 1977829456 19.448 99 72 142 2 2042517264 42081520 22606288
17:39:21 7348 8192000000 10972150480 11404480512 1991140688 19.553 100 70 140 1 2059422176 45860192 22421296
17:39:40 3411 8192000000 10980035248 11409743872 1997282864 19.601 100 58 117 1 2058809648 43290144 18236640
17:39:53 11166 8192000000 10974869088 11401474048 1988156528 19.529 100 65 130 1 2055464016 45575696 21731792
17:40:13 12787 8192000000 10961077488 11400826880 1987585168 19.525 100 50 100 1 2049669968 45487968 16596832
17:40:34 8807 8192000000 10968067488 11401895936 1970314448 19.388 99 52 104 1 2038687024 51194352 17178224
17:40:55 9707 8192000000 10976142672 11404386304 1989401840 19.539 100 61 122 0 2057917440 48479488 20036112
17:41:13 4516 8192000000 10966856752 11405586432 1988940064 19.535 100 65 128 0 2058720048 49215744 20564240
17:41:26 10249 8192000000 10980698112 11415887872 1998053264 19.607 100 63 126 1 2066734800 47650112 21031424
17:41:49 5879 8192000000 10979499648 11417305088 2006473488 19.674 100 54 108 0 2063994432 40167728 17353216
17:42:02 10549 8192000000 10988984544 11426115584 2013251440 19.727 100 66 131 1 2075089152 41576464 20261248
17:42:19 8151 8192000000 10994486192 11420655616 2004900416 19.661 100 76 152 1 2070622752 42573792 23148544
17:42:35 2153 8192000000 10989299808 11416023040 2003451152 19.650 100 75 150 0 2068886048 42383568 23051328
17:42:45 5305 8192000000 10979767776 11408314368 1986853504 19.519 99 77 154 1 2053814400 42039008 24921888
17:42:58 2546 8192000000 10974525616 11404353536 1999978208 19.623 100 68 134 0 2059270304 38642784 20649312
17:43:09 1216 8192000000 11004975600 11424026624 2017933648 19.764 100 87 175 1 2083099472 37885888 27279936
17:43:17 2365 8192000000 10980915680 11404062720 2000027888 19.623 100 75 150 0 2063587424 40648000 22911536
17:43:26 4695 8192000000 10983839120 11408527360 2003189088 19.648 100 71 142 1 2065341616 39896848 22255680
17:43:45 4339 8192000000 10968887792 11409948672 1999946368 19.622 100 50 99 1 2054448224 38445792 16056064
17:43:56 15383 8192000000 10952812128 11406508032 1984333680 19.499 99 37 74 1 2033693184 36997408 12362096
17:44:19 3138 8192000000 10977723168 11418271744 2001757936 19.637 100 49 96 1 2055312672 38317232 15237504
17:44:30 1773 8192000000 10984035216 11413815296 2007764560 19.684 100 76 150 0 2071113536 39924320 23424656
17:44:40 2550 8192000000 10976256608 11404206080 1998128720 19.608 100 70 139 1 2059652912 38950800 22573392
17:44:50 1788 8192000000 10998349920 11419611136 2014305840 19.735 100 81 163 0 2077874176 39534848 24033488
17:44:59 5841 8192000000 10978558992 11420667904 2012348160 19.720 100 51 102 2 2067967840 40213008 15406672
17:45:19 9085 8192000000 10961687936 11402383360 1981895376 19.480 99 43 86 3 2035433216 39458800 14079040
17:45:37 10899 8192000000 10944240800 11377635328 1932672304 19.088 97 45 88 3 1989042080 41935680 14434096
17:45:55 2931 8192000000 10943107504 11375464448 1963803136 19.336 99 49 98 0 2024261984 43778224 16680624
17:46:06 7213 8192000000 10960452752 11397873664 1982861008 19.487 100 43 84 2 2041345360 44740064 13744288
17:46:23 6580 8192000000 10928629376 11364757504 1925219024 19.029 97 55 110 0 1985675152 42298960 18157168
17:46:59 6290 8192000000 10936422848 11364663296 1940859648 19.154 98 49 99 2 1998193696 40692736 16641312
17:47:12 2582 8192000000 10944504880 11350659072 1949004640 19.219 99 90 179 3 2018903904 42468992 27430272
17:47:23 2067 8192000000 10973437216 11390255104 1979631568 19.462 100 81 162 4 2050881056 46075936 25173552
17:47:44 1765 8192000000 10954620336 11382059008 1971886032 19.400 100 63 125 0 2037973040 46326752 19760256
17:48:11 15123 8192000000 10922972944 11356389376 1895711024 18.792 96 45 90 0 1958099776 47271536 15117216
17:48:34 12423 8192000000 10919922448 11349598208 1926402352 19.038 99 37 75 0 1985066864 46231568 12432944
17:48:57 4705 8192000000 10931464176 11354816512 1930204896 19.069 99 53 105 0 1996159872 48573440 17381536
17:49:15 2181 8192000000 10955996704 11368038400 1952081632 19.243 100 84 169 1 2029776256 50488992 27205632
17:49:25 17332 8192000000 10923192688 11352670208 1920672736 18.992 99 47 94 1 1992109184 55347904 16088544
17:49:52 8499 8192000000 10919623696 11354624000 1934234048 19.101 100 35 70 1 2005505456 58357280 12914128
17:50:20 8478 8192000000 10923480752 11357687808 1937177056 19.124 100 39 78 1 2007355760 56967760 13210944
17:50:47 15645 8192000000 10926094208 11358056448 1918680368 18.976 99 41 82 1 1994051984 61509264 13862352
17:51:14 14479 8192000000 10923170000 11359412224 1919271600 18.981 99 38 76 0 1994601232 61980128 13349504
17:51:37 22596 8192000000 10892706176 11342794752 1921973936 19.003 100 34 68 0 1996290448 61187024 13129488
17:52:06 22675 8192000000 10899144976 11348062208 1922823584 19.009 100 33 66 1 1988381952 53965536 11592832
17:52:47 32395 8192000000 10898760448 11355979776 1906329232 18.877 99 28 56 0 1978192528 61717840 10145456
17:53:34 13296 8192000000 10896891776 11347374080 1892439328 18.765 99 18 36 1 1960092752 60597296 7056128
17:53:56 23400 8192000000 10894432848 11354648576 1904723376 18.864 99 25 50 2 1968478112 54256512 9498224
17:54:27 22221 8192000000 10900338288 11350835200 1924568624 19.023 100 16 32 1 1979821104 49495168 5757312
17:54:56 18363 8192000000 10894250128 11368366080 1927905904 19.050 100 19 38 0 1983341248 49029312 6406032
17:55:21 33152 8192000000 10843099536 11312193536 1885828400 18.712 98 8 16 0 1907920288 20122176 1969712
17:56:00 24784 8192000000 10857973632 11306692608 1893496672 18.774 98 31 63 0 1909695104 7246368 8952064
17:56:38 38474 8192000000 10876976560 11319758848 1896426288 18.798 98 29 59 1 1918062880 13638528 7998064
17:57:30 52858 8192000000 10905235184 11343560704 1914824592 18.945 99 25 51 2 1937014096 15009280 7180224
17:58:29 95451 8192000000 10891468672 11350421504 1924856944 19.026 99 19 38 1 1948761312 18355792 5548576
18:00:16 82794 8192000000 10863926816 11331678208 1856469504 18.475 95 14 28 0 1878774320 18559776 3745040
18:01:45 88586 8192000000 10892544944 11339927552 1939155808 19.140 100 22 44 0 1955689296 10360960 6172528
18:03:20 89494 8192000000 10893350032 11340144640 1866785376 18.558 95 28 50 5 1885312608 9736992 8790240
18:04:56 19744 8192000000 10900269072 11353878528 1958353504 19.293 100 51 102 0 1986821920 13456192 15012224
18:05:24 152504 8192000000 10913230976 11370180608 1951447824 19.238 99 28 56 0 1969578880 10692960 7438096
18:08:05 30371 8192000000 10930658832 11373588480 1974106720 19.418 100 23 46 1 1990513680 9665136 6741824
18:08:43 21956 8192000000 10939981168 11380101120 1965605120 19.351 99 67 131 3 1993926320 9866512 18454688
18:09:16 41823 8192000000 10935581280 11386335232 1984850512 19.503 100 48 95 3 2010498224 11940800 13706912
18:10:12 61383 8192000000 10907798944 11389337600 1984825248 19.503 100 12 23 0 1999675040 11554768 3295024
18:11:24 31881 8192000000 10906355440 11384500224 1985678832 19.510 100 9 18 2 1998526960 10336112 2512016
18:12:06 53258 8192000000 10912362128 11392348160 1990764768 19.550 100 7 14 1 2002207696 9688560 1754368
18:13:47 52681 8192000000 10924508048 11408556032 1997498368 19.603 100 5 10 0 2005782288 7075936 1207984
18:14:46 31507 8192000000 10921508672 11398594560 1989505408 19.540 99 23 46 3 2003129408 7448272 6175728
18:15:31 81238 8192000000 10911863888 11394400256 1944637280 19.184 97 20 40 0 1962054112 11296496 6120336
18:16:59 78801 8192000000 10908969440 11396169728 1973370624 19.412 99 20 39 0 1991885584 12482768 6032192
18:18:30 10286 8192000000 10926289616 11396927488 1992492480 19.563 100 19 38 1 2010461008 12640768 5327760
18:18:47 48938 8192000000 10908959808 11393810432 1979275440 19.459 99 30 62 1 2003606144 15964304 8366400
18:20:35 55839 8192000000 10912032144 11401080832 1984197488 19.498 100 8 16 0 1998987776 12357456 2432832
18:21:40 50940 8192000000 10921364688 11389407232 1937198416 19.124 97 18 36 1 1955616048 12674592 5743040
18:22:42 24168 8192000000 10935252032 11403210752 1998010768 19.607 100 42 82 3 2016311920 7367168 10933984
18:23:13 15693 8192000000 10950586960 11411075072 2009327600 19.696 100 49 97 0 2030479584 8078688 13073296
18:23:41 17135 8192000000 10911031024 11369996288 1928789216 19.057 96 36 72 1 1950791856 11296240 10706400
18:24:06 26537 8192000000 10930800336 11396558848 1994871552 19.582 100 32 64 2 2016895856 12961056 9063248
18:24:46 56972 8192000000 10943034848 11418247168 1986256080 19.514 99 34 66 2 2017845888 21874832 9714976
18:25:50 54440 8192000000 10909908896 11406290944 1949822480 19.225 98 9 18 0 1975911296 23605696 2483120
18:26:51 39883 8192000000 10919156032 11377414144 1950212160 19.228 98 24 48 0 1964602800 7940288 6450352
18:27:39 10056 8192000000 10932826864 11385364480 1988122928 19.529 100 46 92 1 2009778816 8662320 12993568
18:27:59 27209 8192000000 10912002336 11377250304 1947834032 19.209 98 35 70 1 1969886256 12677520 9374704
18:28:33 28224 8192000000 10901008288 11364777984 1945042912 19.187 99 21 42 0 1963464448 12277664 6143872
18:29:08 68090 8192000000 10883859296 11351703552 1861956960 18.519 94 9 18 0 1874989568 11126112 1906496
18:30:25 79677 8192000000 10873149472 11355066368 1874928192 18.624 96 10 20 1 1895944000 18580992 2434816
18:32:00 36717 8192000000 10878617776 11338330112 1889224848 18.740 97 20 40 0 1907366272 12581536 5559888
18:32:44 60339 8192000000 10884709536 11344199680 1889416560 18.741 97 15 30 1 1915193472 21829504 3947408
18:33:54 101540 8192000000 10848193632 11312422912 1842381184 18.360 94 37 75 0 1866677904 13942768 10353952
18:35:48 69832 8192000000 10858719520 11329695744 1894511296 18.782 98 29 58 1 1916977184 13767696 8698192
18:37:06 40363 8192000000 10854478736 11322331136 1881044416 18.674 97 21 42 0 1902282432 15103360 6134656
18:38:56 28087 8192000000 10826405744 11306864640 1909739744 18.905 100 7 14 1 1919385920 7536400 2109776
18:41:17 63185 8192000000 10835662960 11311210496 1853054816 18.447 96 19 38 0 1872507840 13988912 5464112
18:42:40 58765 8192000000 10842741392 11316219904 1912588768 18.927 100 15 30 0 1934180640 17081280 4510592
18:43:57 70675 8192000000 10856876080 11333394432 1921881120 19.002 100 14 28 3 1940208896 14001616 4326160
18:45:28 47068 8192000000 10853985184 11320791040 1864715200 18.541 96 26 52 1 1883404528 11279792 7409536
18:46:30 43186 8192000000 10848533776 11320082432 1873219488 18.610 97 16 32 3 1889601712 11824368 4557856
18:47:20 74808 8192000000 10850254512 11331325952 1890400800 18.749 98 19 38 2 1912397920 16196256 5800864
18:48:46 48194 8192000000 10872390880 11355115520 1938921184 19.138 100 17 34 0 1960351760 16694224 4736352
18:49:41 41500 8192000000 10853677376 11315814400 1914907296 18.946 99 13 26 1 1932209872 13844400 3458176
18:50:33 18724 8192000000 10885538832 11342987264 1946188480 19.196 100 40 78 1 1967658480 9983104 11486896
18:50:59 34472 8192000000 10897827104 11355246592 1951301680 19.237 100 42 84 0 1974369472 11583872 11483920
18:51:43 34420 8192000000 10922587056 11364782080 1960333024 19.309 100 44 88 1 1985161232 12258176 12570032
18:52:27 13895 8192000000 10925490400 11373088768 1972176848 19.403 100 56 110 0 2000152672 13020784 14955040
18:52:47 37870 8192000000 10884515552 11361968128 1954808240 19.265 100 24 48 1 1974299520 12882272 6609008
18:53:31 79028 8192000000 10885922272 11355328512 1885416912 18.709 96 22 44 1 1902510560 11137312 5956336
18:55:03 39927 8192000000 10886763536 11357941760 1934776672 19.105 99 28 56 1 1957321424 14983136 7561616
18:55:50 136490 8192000000 10890913072 11378880512 1933734608 19.097 99 18 36 0 1953769632 15038496 4996528
18:58:36 80775 8192000000 10900689904 11377016832 1957592656 19.287 99 22 44 2 1972911136 9410480 5908000
19:00:45 84043 8192000000 10908254656 11386826752 1980965056 19.472 100 13 26 0 1994476288 9852912 3658320
19:02:28 92100 8192000000 10922217440 11416682496 1993004768 19.568 100 12 24 0 2006221344 10483888 2732688
19:04:10 57866 8192000000 10924853472 11406479360 1987633792 19.525 99 25 49 2 2005670592 10938576 7098224
19:05:25 36156 8192000000 10935424032 11407413248 1986100448 19.513 99 18 36 1 1998754976 8108336 4546192
19:06:08 44627 8192000000 10909488512 11385462784 1961340048 19.317 98 17 34 1 1974418192 8292096 4786048
19:07:03 17052 8192000000 10925071232 11386212352 1976003968 19.433 99 47 94 0 1997508384 8662256 12842160
19:07:27 26764 8192000000 10922971936 11392569344 1959771072 19.304 98 25 50 1 1975997984 9428608 6798304
19:08:32 67866 8192000000 10897666560 11367710720 1910729456 18.913 96 14 28 1 1923333248 8390672 4213120
19:09:46 65053 8192000000 10917072816 11383754752 1974676320 19.423 100 29 58 2 1993634704 11203648 7754736
19:10:57 71557 8192000000 10909769840 11380183040 1901437632 18.838 96 18 36 2 1915952480 9735856 4778992
19:12:22 120092 8192000000 10913825232 11397529600 1958142288 19.291 99 8 16 1 1972428000 12198832 2086880
19:14:28 87849 8192000000 10917458160 11379220480 1903119968 18.851 96 9 18 0 1913205488 7851936 2233584
19:16:03 52634 8192000000 10878746256 11361034240 1878705792 18.655 95 21 42 1 1897779360 13150960 5922608
19:17:07 120510 8192000000 10885954592 11356594176 1927749776 19.049 98 24 48 0 1949223344 14967328 6506240
19:19:41 39138 8192000000 10877571408 11340369920 1900886832 18.833 97 23 44 0 1914599056 8054160 5658064
19:20:36 8417 8192000000 10877315856 11330129920 1940061792 19.147 99 44 90 1 1959630384 7334992 12233600
19:20:51 37661 8192000000 10890552048 11346010112 1902851696 18.849 97 27 54 1 1919049696 7885152 8312848
19:21:37 65400 8192000000 10836075760 11318169600 1828571200 18.248 94 7 14 0 1838225520 8073792 1580528
19:22:58 37782 8192000000 10848211696 11324874752 1910655136 18.912 99 6 12 0 1921772496 9467648 1649712
19:23:42 32917 8192000000 10805929792 11261284352 1827192896 18.236 95 11 22 0 1837921888 7677120 3051872
19:24:22 69869 8192000000 10837924720 11297128448 1857826512 18.486 97 13 25 0 1872614048 10446224 4341312
19:25:42 72602 8192000000 10843273488 11309965312 1887302096 18.724 98 26 52 2 1910021248 14762080 7957072
19:27:05 19241 8192000000 9764266320 10120695808 899961664 9.898 47 7 13 0 909237952 7818256 1458032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-12-2020 19:29:20 to 27-12-2020 19:29:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 104 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-12-2020 19:29:52 to 27-12-2020 19:29:54.

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          244950
MON$OLDEST_ACTIVE               245647
MON$OLDEST_SNAPSHOT             245647
MON$NEXT_TRANSACTION            245647
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                       2050848
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:447: 
:448: mscs-test-161.budzdorov.ru    Sun Dec 27 19:27:35 2020
:449:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:450: 
:451: 
:452: mscs-test-161.budzdorov.ru    Sun Dec 27 19:27:37 2020
:453:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:454: 
:455: 
:456: mscs-test-161.budzdorov.ru    Sun Dec 27 19:27:37 2020
:457:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:458: 
:459: 
:460: mscs-test-161.budzdorov.ru    Sun Dec 27 19:27:39 2020
:461:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:462: 
:463: 
:464: mscs-test-161.budzdorov.ru    Sun Dec 27 19:27:42 2020
:465:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:466: 
--- end of diff output ---

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

27.12.20 19:29:55. 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
2020-12-27 19:29:58 No severe PSQL-related problems occured
27.12.20 19:29:59. End of report.