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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17376112 kB
MemAvailable 31610276 kB
Buffers 0 kB
Cached 14294096 kB
SwapCached 2316 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-11-29 16:27:00
DTS_END                         2020-11-29 16:27:00.9600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37658
TRN_ID                          245092
ATT_ID                          623
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: 9419.18 19853 1130302
customer order: creation 173.13 336 20776
customer order: refuse 14.48 355 1737
order to supplier: creation 45.97 1229 5516
order to supplier: removal 3.49 104133 419
invoice (draft): creation 45.93 3248 5511
invoice (draft): removal 54.77 912 6572
invoice accept: apply 42.37 16989 5084
invoice accept: cancel 50.14 805 6017
customer reserve: creation 3818.36 172 458203
customer reserve: removal 4861.07 56 583328
realization accept: apply 85.66 172 10279
realization accept: cancel 90.58 104 10870
payment from customer: creation 61.71 103 7405
payment from customer: removal 5.83 56 700
payment to supplier: creation 49.99 101 5999
payment to supplier: removal 3.63 94 436
service: total inventory turnovers 4.60 1219 552
service: total monetary turnovers 6.58 28 790
service: aggregate perf. data 0.87 15658 104
service: refresh index statistics 0.03 251294 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-11-2020 16:28:03 to 29-11-2020 16:28:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5739
TEST_TIME 2 5066
TEST_TIME 3 5235
TEST_TIME 4 5275
TEST_TIME 5 5543
TEST_TIME 6 5918
TEST_TIME 7 5449
TEST_TIME 8 5679
TEST_TIME 9 5571
TEST_TIME 10 5764
TEST_TIME 11 5714
TEST_TIME 12 5795
TEST_TIME 13 6053
TEST_TIME 14 6307
TEST_TIME 15 6640
TEST_TIME 16 6939
TEST_TIME 17 6887
TEST_TIME 18 7605
TEST_TIME 19 7844
TEST_TIME 20 7991
TEST_TIME 21 8598
TEST_TIME 22 9598
TEST_TIME 23 10635
TEST_TIME 24 10954
TEST_TIME 25 10859
TEST_TIME 26 10832
TEST_TIME 27 10648
TEST_TIME 28 10641
TEST_TIME 29 10484
TEST_TIME 30 10446
TEST_TIME 31 10274
TEST_TIME 32 10120
TEST_TIME 33 10075
TEST_TIME 34 10278
TEST_TIME 35 10314
TEST_TIME 36 10185
TEST_TIME 37 10079
TEST_TIME 38 10263
TEST_TIME 39 10231
TEST_TIME 40 10128
TEST_TIME 41 10066
TEST_TIME 42 10070
TEST_TIME 43 10365
TEST_TIME 44 10248
TEST_TIME 45 10063
TEST_TIME 46 10026
TEST_TIME 47 10131
TEST_TIME 48 10002
TEST_TIME 49 10005
TEST_TIME 50 9950
TEST_TIME 51 9876
TEST_TIME 52 9903
TEST_TIME 53 9921
TEST_TIME 54 9900
TEST_TIME 55 9827
TEST_TIME 56 9723
TEST_TIME 57 9623
TEST_TIME 58 9558
TEST_TIME 59 9760
TEST_TIME 60 9655
TEST_TIME 61 9617
TEST_TIME 62 9720
TEST_TIME 63 9840
TEST_TIME 64 9822
TEST_TIME 65 9822
TEST_TIME 66 9867
TEST_TIME 67 9847
TEST_TIME 68 9802
TEST_TIME 69 9863
TEST_TIME 70 9839
TEST_TIME 71 9821
TEST_TIME 72 9754
TEST_TIME 73 9893
TEST_TIME 74 9926
TEST_TIME 75 9853
TEST_TIME 76 9772
TEST_TIME 77 9724
TEST_TIME 78 9711
TEST_TIME 79 9730
TEST_TIME 80 9699
TEST_TIME 81 9646
TEST_TIME 82 9617
TEST_TIME 83 9524
TEST_TIME 84 9507
TEST_TIME 85 9556
TEST_TIME 86 9485
TEST_TIME 87 9519
TEST_TIME 88 9505
TEST_TIME 89 9513
TEST_TIME 90 9515
TEST_TIME 91 9530
TEST_TIME 92 9569
TEST_TIME 93 9572
TEST_TIME 94 9613
TEST_TIME 95 9608
TEST_TIME 96 9706
TEST_TIME 97 9689
TEST_TIME 98 9626
TEST_TIME 99 9733
TEST_TIME 100 9752
TEST_TIME 101 9676
TEST_TIME 102 9646
TEST_TIME 103 9638
TEST_TIME 104 9623
TEST_TIME 105 9578
TEST_TIME 106 9536
TEST_TIME 107 9534
TEST_TIME 108 9518
TEST_TIME 109 9464
TEST_TIME 110 9452
TEST_TIME 111 9427
TEST_TIME 112 9449
TEST_TIME 113 9453
TEST_TIME 114 9423
TEST_TIME 115 9457
TEST_TIME 116 9470
TEST_TIME 117 9507
TEST_TIME 118 9481
TEST_TIME 119 9482
TEST_TIME 120 9421

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-11-2020 16:28:07 to 29-11-2020 16:28:10.

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 1555997 1555997 0 0.00 0 34992 6 0 0
doc_list_biud 1555995 1555995 0 0.00 0 36684 28 0 0
sp_add_invoice_to_stock 5207 5084 123 2.36 18 227143 16989 0 123
sp_cancel_adding_invoice 6017 6017 0 0.00 5 58165 805 0 0
sp_cancel_client_order 1737 1737 0 0.00 4 14371 356 0 0
sp_cancel_customer_reserve 583328 583328 0 0.00 1 36687 57 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 2574 57 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 3 6620 94 0 0
sp_cancel_supplier_invoice 6585 6572 13 0.19 1 30409 912 0 13
sp_cancel_supplier_order 419 419 0 0.00 7 1155003 104133 0 0
sp_cancel_write_off 10870 10870 0 0.00 1 36127 104 0 0
sp_client_order 20776 20776 0 0.00 3 27204 336 0 0
sp_customer_reserve 458203 458203 0 0.00 0 95578 173 0 0
sp_fill_shopping_cart 31787 31787 0 0.00 1 12176 34 0 0
sp_fill_shopping_cart_clo_res 458201 458201 0 0.00 0 22825 13 0 0
sp_get_clo_for_invoice 5074 5074 0 0.00 0 22365 280 0 0
sp_kill_cost_storno 18023 18023 0 0.00 0 6614 54 0 0
sp_kill_qstorno_ret_qs2qd 1184517 1184517 0 0.00 0 36339 32 0 0
sp_kill_qty_storno 624291 624291 0 0.00 0 36684 69 0 0
sp_lock_selected_doc 21143 21143 0 0.00 0 18761 5 0 0
sp_make_cost_storno 28753 28753 0 0.00 0 12404 47 0 0
sp_multiply_rows_for_pdistr 28752 28752 0 0.00 0 9541 27 0 0
sp_multiply_rows_for_qdistr 20776 20776 0 0.00 0 12888 130 0 0
sp_pay_from_customer 7405 7405 0 0.00 4 21212 104 0 0
sp_pay_to_supplier 5999 5999 0 0.00 5 10615 102 0 0
sp_payment_common 13404 13404 0 0.00 1 21207 28 0 0
sp_qd_handle_on_cancel_clo 1737 1737 0 0.00 0 14365 334 0 0
sp_qd_handle_on_invoice_upd_sts 11086 11086 0 0.00 0 20518 354 0 0
sp_qd_handle_on_reserve_upd_sts 10279 10279 0 0.00 0 24253 62 0 0
sp_reserve_write_off 10279 10279 0 0.00 6 24291 173 0 0
sp_supplier_invoice 5511 5511 0 0.00 6 95252 3249 0 0
sp_supplier_order 5516 5516 0 0.00 5 34763 1229 0 0
srv_aggregate_perf_data 104 104 0 0.00 2876 114074 15658 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1464 162924 34876 0 0
srv_find_qd_qs_mism 1082881 1082881 0 0.00 0 34991 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 50 97264 1220 0 0
srv_make_money_saldo 790 790 0 0.00 1 3461 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 185924 353897 251294 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5084 5084 0 0.00 0 35558 196 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 3562 97 0 0
t$perf-norm:sp_cancel_client_order 1737 1737 0 0.00 0 15977 23 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 1266 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 1349 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 466 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 4004 19 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 17308 1462 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 1379 7 0 0
t$perf-norm:sp_client_order 20776 20776 0 0.00 0 27531 19 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 1045 5 0 0
t$perf-norm:sp_pay_from_customer 7405 7405 0 0.00 0 22987 13 0 0
t$perf-norm:sp_pay_to_supplier 5999 5999 0 0.00 0 3996 10 0 0
t$perf-norm:sp_reserve_write_off 10279 10279 0 0.00 0 7080 12 0 0
t$perf-norm:sp_supplier_invoice 5511 5511 0 0.00 0 22732 18 0 0
t$perf-norm:sp_supplier_order 5516 5516 0 0.00 0 11227 17 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 481 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 688 9 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 1469 19 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 32426 54 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10382 10136 246 2.36 0 6609 16 0 246
v_all_customers 37992 37992 0 0.00 0 108 1 0 0
v_all_suppliers 30508 30508 0 0.00 0 102 1 0 0
v_all_wares 41552 41552 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 829 6 0 0
v_cancel_client_order 3474 3474 0 0.00 0 1401 3 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 2567 6 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 3003 7 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 1130 4 0 0
v_cancel_supplier_invoice 780 754 26 3.33 0 343 13 0 26
v_cancel_supplier_order 838 838 0 0.00 0 410 3 0 0
v_cancel_write_off 2044 2044 0 0.00 0 1424 10 0 0
v_max_id_clo_ord 5515 5515 0 0.00 0 977 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 2509 13 0 0
v_max_id_ord_sup 5495 5495 0 0.00 0 2143 3 0 0
v_max_non_paid_invoice 1755 1755 0 0.00 0 161 2 0 0
v_max_non_paid_realizn 4016 4016 0 0.00 0 5396 5 0 0
v_min_id_clo_ord 5515 5515 0 0.00 0 1395 4 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 4425 13 0 0
v_min_id_ord_sup 5495 5495 0 0.00 0 2856 4 0 0
v_min_non_paid_invoice 5999 5999 0 0.00 0 5098 10 0 0
v_min_non_paid_realizn 7405 7405 0 0.00 0 20975 19 0 0
v_our_firm 10338 10338 0 0.00 0 18 1 0 0
v_reserve_write_off 20558 20558 0 0.00 0 6554 5 0 0
x_lock_depdocs_on_canc_invoice 12212 12212 0 0.00 0 15080 108 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 13315 410 0 0
x_make_qstorno_1000_1200 5516 5516 0 0.00 1 34750 1163 0 0
x_make_qstorno_1200_2000 5511 5511 0 0.00 3 87879 3125 0 0
x_make_qstorno_2100_3300 458203 458203 0 0.00 0 95577 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-11-2020 16:28:11 to 29-11-2020 16:28:15.

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
13:57:04 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:10 28336 8192000000 10252485152 10566311936 845852448 9.358 66 54 108 0 866765728 2573376 18339904
13:57:50 27715 8192000000 10345165104 10660384768 1390315408 14.509 100 87 174 1 1423758640 5054384 28388848
13:58:29 23863 8192000000 10365502912 10690572288 1424543104 14.813 100 92 185 0 1461116112 6403712 30169296
13:59:03 16849 8192000000 10389890736 10716295168 1438498640 14.936 100 86 171 1 1474416144 7211840 28705664
13:59:30 24232 8192000000 10410651344 10740961280 1469944720 15.213 100 90 180 0 1506833344 7859744 29028880
14:00:01 19557 8192000000 10432478720 10766020608 1485766768 15.352 100 85 170 0 1522064736 8719280 27578688
14:00:30 16241 8192000000 10452239408 10792685568 1502382256 15.497 100 77 154 0 1535763120 8954000 24426864
14:00:55 13716 8192000000 10474743184 10813796352 1525940672 15.702 100 83 166 1 1561601520 9844640 25816208
14:01:19 10561 8192000000 10481613664 10826326016 1537656512 15.803 100 79 158 0 1572440144 10248912 24534720
14:01:40 17943 8192000000 10503452336 10852212736 1562817424 16.020 100 83 166 0 1599275552 10891600 25566528
14:02:07 12817 8192000000 10527790512 10878685184 1578844480 16.158 100 74 148 1 1612093360 10569088 22679792
14:02:36 8273 8192000000 10542285568 10899243008 1604676672 16.379 100 80 160 0 1639600352 10549856 24373824
14:02:52 11747 8192000000 10564242880 10920390656 1618737744 16.499 100 80 160 2 1653786592 10878224 24170624
14:03:11 8520 8192000000 10582515488 10948653056 1644042880 16.714 100 74 148 3 1676460816 10568240 21849696
14:03:28 11420 8192000000 10611705072 10975920128 1675517792 16.980 100 77 154 2 1709219680 11134464 22567424
14:03:47 8956 8192000000 10632016992 11004481536 1694180992 17.136 100 73 146 2 1726814976 11185152 21448832
14:04:06 6593 8192000000 10651227792 11024125952 1716974512 17.327 100 75 149 4 1749807104 11120784 21711808
14:04:19 10174 8192000000 10683076336 11060264960 1741447840 17.531 100 76 151 3 1774989696 12216800 21325056
14:04:36 4784 8192000000 10694867680 11070472192 1755903392 17.650 100 80 160 2 1790604784 12137360 22564032
14:04:49 5133 8192000000 10698080864 11077750784 1765285024 17.728 100 76 150 1 1798289552 11841232 21163296
14:05:00 6493 8192000000 10702433104 11088973824 1773554560 17.796 100 78 156 0 1807260048 11942832 21762656
14:05:13 3692 8192000000 10722084672 11105406976 1781075808 17.858 100 83 164 2 1816814736 12396384 23342544
14:05:24 3075 8192000000 10719006640 11101937664 1785102416 17.891 100 83 164 1 1822183152 13760720 23320016
14:05:34 3717 8192000000 10731280720 11112415232 1795272336 17.975 100 85 169 1 1832918736 13558784 24087616
14:05:44 10046 8192000000 10737905008 11120791552 1800088080 18.015 100 81 162 0 1836666544 13792704 22785760
14:06:01 6150 8192000000 10731600400 11125866496 1805714192 18.061 100 80 160 1 1841498464 13504240 22280032
14:06:14 3851 8192000000 10760319888 11148095488 1821970272 18.194 100 86 168 5 1858199504 12004400 24224832
14:06:24 2303 8192000000 10770708064 11151843328 1829730640 18.257 100 90 181 1 1868864464 13567456 25566368
14:06:33 2218 8192000000 10772789488 11155877888 1835853424 18.307 100 86 171 1 1873306672 13558384 23894864
14:06:42 2596 8192000000 10780538304 11169058816 1840746256 18.347 100 87 173 1 1879121440 13159856 25215328
14:06:51 1474 8192000000 10787861648 11173036032 1845733856 18.387 100 91 182 0 1884887520 13079520 26074144
14:07:00 2922 8192000000 10785126704 11176906752 1848162480 18.407 100 81 162 1 1882375968 12050000 22163488
14:07:09 2141 8192000000 10805857008 11191488512 1854288512 18.457 100 92 183 3 1892405216 12569200 25547504
14:07:18 1879 8192000000 10801089408 11188899840 1859694256 18.501 100 88 176 0 1897906256 13489072 24722928
14:07:26 3048 8192000000 10805883152 11193364480 1860682608 18.509 100 91 182 1 1900346432 14209808 25454016
14:07:36 1630 8192000000 10815371376 11202850816 1865781200 18.550 100 95 191 0 1908936400 15917632 27237568
14:07:43 1884 8192000000 10818722976 11204669440 1868204208 18.570 100 90 180 1 1908493968 15425424 24864336
14:07:51 1566 8192000000 10819060272 11205779456 1870873888 18.591 100 96 193 2 1911904752 13448992 27581872
14:07:59 1228 8192000000 10828338368 11215355904 1881525072 18.677 100 95 188 0 1921524064 13591984 26407008
14:08:07 1884 8192000000 10829715344 11216527360 1881205888 18.675 100 96 193 1 1922283216 14032544 27044784
14:08:15 1409 8192000000 10832758752 11224584192 1884605712 18.702 100 88 176 1 1922245808 12013952 25626144
14:08:24 38748 8192000000 10805351152 11221090304 1881365424 18.676 100 44 88 2 1901376160 7884432 12126304
14:09:14 5235 8192000000 10786692880 11215724544 1880664512 18.670 100 31 62 2 1896043072 6684736 8693824
14:09:27 6688 8192000000 10804171984 11223678976 1886236016 18.715 100 40 80 0 1905296832 8033360 11027456
14:09:40 3879 8192000000 10798363408 11221118976 1884087152 18.698 100 30 60 3 1900427104 7931744 8408208
14:09:55 8933 8192000000 10789968656 11222888448 1884448192 18.701 100 18 36 1 1894737264 5104176 5184896
14:10:13 12851 8192000000 10803168208 11224911872 1887011824 18.722 100 26 54 2 1901184320 6752464 7420032
14:10:34 10573 8192000000 10800328368 11231219712 1892034000 18.762 100 18 35 3 1902506272 5731984 4740288
14:10:57 15696 8192000000 10793532688 11233652736 1892707936 18.768 100 18 35 1 1903829264 6122000 4999328
14:11:20 7335 8192000000 10807042112 11238793216 1896217936 18.796 100 22 44 1 1908528224 6112608 6197680
14:11:36 9910 8192000000 10806788672 11239804928 1899770480 18.824 100 21 42 1 1911973792 6732544 5470768
14:11:58 9118 8192000000 10809247856 11244523520 1901482144 18.838 100 20 39 0 1913014816 5471472 6061200
14:12:18 15327 8192000000 10820323360 11245518848 1902329792 18.845 100 17 34 1 1913415520 6302544 4783184
14:12:40 71956 8192000000 10822146384 11259785216 1910766992 18.913 100 29 58 1 1925682912 6273120 8642800
14:14:01 8325 8192000000 10828737344 11260342272 1911775168 18.921 100 27 54 0 1926330976 6473248 8082560
14:14:18 4866 8192000000 10839193072 11268419584 1919283632 18.981 100 42 84 4 1938859280 7182784 12392864
14:14:31 6408 8192000000 10826300880 11262337024 1911324240 18.917 100 21 42 3 1922809264 5716512 5768512
14:14:45 7803 8192000000 10823541504 11262210048 1912411024 18.926 100 26 52 0 1926175952 6457920 7307008
14:15:01 9510 8192000000 10822001552 11263307776 1910349216 18.909 100 21 42 1 1922920624 6884384 5687024
14:15:19 5834 8192000000 10815977984 11250851840 1889237616 18.740 99 28 56 3 1903685136 6172160 8275360
14:15:31 5762 8192000000 10819116464 11249766400 1889630928 18.743 99 27 54 0 1903204144 6234704 7338512
14:15:45 8795 8192000000 10819363056 11250401280 1883297280 18.692 99 27 52 0 1898450416 7282240 7870896
14:16:01 7648 8192000000 10827483392 11248775168 1883173840 18.691 99 37 74 3 1904342720 10091344 11077536
14:16:16 8753 8192000000 10809465728 11243565056 1879700160 18.663 99 15 30 1 1889299984 5556384 4043440
14:16:31 6888 8192000000 10811365680 11241574400 1882022000 18.681 99 19 39 1 1893935088 6298144 5614944
14:16:44 12893 8192000000 10788599664 11212386304 1828658304 18.248 97 15 30 3 1838179152 5275920 4244928
14:17:05 10029 8192000000 10741966576 11172696064 1756946704 17.659 94 20 40 0 1768391152 5959824 5484624
14:17:25 11665 8192000000 10765147024 11178946560 1785197856 17.892 96 36 72 1 1801557424 5073504 11286064
14:17:43 58633 8192000000 10718446256 11153465344 1754468864 17.639 95 29 58 1 1768372032 5592032 8311136
14:18:51 6812 8192000000 10739374896 11166785536 1811475536 18.108 99 20 40 2 1822369488 5488880 5405072
14:19:04 7857 8192000000 10716550112 11135803392 1759343616 17.679 97 28 56 1 1773809488 6652768 7813104
14:19:20 9959 8192000000 10737432064 11152826368 1797123328 17.990 99 30 59 4 1811482784 5681568 8677888
14:19:40 9597 8192000000 10685576224 11090911232 1689430832 17.097 93 16 32 4 1699506224 5759840 4315552
14:19:57 8640 8192000000 10718887888 11131420672 1760703648 17.690 98 27 52 2 1773490640 5236096 7550896
14:20:16 8889 8192000000 10666888560 11083190272 1700365600 17.188 95 30 60 0 1714756720 5148272 9242848
14:20:32 10088 8192000000 10681020448 11094036480 1717493008 17.331 97 16 32 1 1727186704 5512752 4180944
14:20:48 6924 8192000000 10700039792 11109863424 1734698288 17.475 97 29 59 1 1748255184 4834672 8722224
14:21:02 10231 8192000000 10724991600 11140046848 1781451312 17.861 99 25 50 2 1794459632 4999536 8008784
14:21:24 14697 8192000000 10734381008 11152818176 1781916336 17.865 98 20 40 0 1793619264 5421632 6281296
14:21:46 7677 8192000000 10734018576 11152224256 1787183984 17.909 98 28 55 1 1801042720 5405968 8452768
14:22:01 7332 8192000000 10740967936 11165814784 1822966272 18.202 100 23 47 1 1836548128 6656944 6924912
14:22:14 12031 8192000000 10761265008 11179253760 1832383840 18.279 100 23 46 2 1844565760 4949024 7232896
14:22:32 61625 8192000000 10800575952 11191267328 1854847600 18.461 100 76 155 3 1882989664 6209568 21932496
14:23:40 7948 8192000000 10764753872 11188875264 1848438368 18.409 100 39 78 2 1868403440 9345856 10619216
14:23:54 7693 8192000000 10762978320 11189252096 1849379648 18.417 100 26 50 1 1862128464 6037952 6710864
14:24:09 3195 8192000000 10776646528 11196162048 1852164400 18.440 100 51 100 0 1874651920 7925008 14562512
14:24:23 6732 8192000000 10784708528 11204620288 1859519232 18.499 100 38 76 1 1877750048 6989568 11241248
14:24:38 4838 8192000000 10774595280 11204919296 1865760768 18.550 100 37 74 0 1882302912 5140896 11401248
14:24:49 9957 8192000000 10782385568 11211591680 1870084288 18.585 100 28 57 2 1883038176 5263152 7690736
14:25:08 8749 8192000000 10782911616 11217129472 1872697152 18.606 100 33 66 4 1888862272 6052864 10112256
14:25:23 7012 8192000000 10795829568 11218124800 1872727072 18.606 100 26 53 1 1885868512 5171968 7969472
14:25:38 10383 8192000000 10786052480 11220561920 1873372864 18.612 100 19 38 0 1884301552 5742944 5185744
14:26:00 7632 8192000000 10788951008 11221204992 1877910368 18.648 100 20 40 2 1889147232 5429184 5807680
14:26:15 13327 8192000000 10802878672 11230752768 1881736016 18.679 100 18 35 1 1892787600 5701696 5349888
14:26:37 14377 8192000000 10803252624 11234177024 1887604032 18.726 100 18 36 2 1897272576 4838448 4830096
14:26:59 70360 8192000000 10851183792 11258707968 1906253904 18.877 100 54 108 0 1929077936 7107168 15716864
14:28:17 8991 8192000000 10843453248 11269058560 1919396832 18.982 100 53 104 0 1942832368 8574816 14860720
14:28:35 15353 8192000000 10859621680 11277430784 1908642832 18.896 99 50 100 0 1930881984 8210944 14028208
14:29:04 8005 8192000000 10867165808 11287244800 1930051744 19.067 100 52 104 0 1955416224 10488592 14875888
14:29:24 26557 8192000000 10875501600 11303350272 1941293248 19.157 100 46 92 1 1967373856 12751424 13329184
14:30:03 5895 8192000000 10885967216 11314073600 1952878096 19.249 100 49 96 1 1980129456 13366784 13884576
14:30:22 10152 8192000000 10895825984 11326939136 1958063952 19.291 100 50 100 2 1989918272 17612768 14241552
14:30:40 4474 8192000000 10913587168 11335852032 1965779568 19.352 100 63 126 1 2003042784 18155888 19107328
14:30:53 18148 8192000000 10917197760 11340480512 1967111952 19.363 100 53 106 0 2001048240 18579184 15357104
14:31:23 13877 8192000000 10919804576 11346530304 1956246032 19.276 99 60 120 1 1995264448 21942752 17075664
14:31:49 17706 8192000000 10916602896 11350740992 1974197552 19.419 100 49 98 1 2010297616 21883776 14216288
14:32:14 13435 8192000000 10909787744 11342864384 1956609344 19.279 99 43 86 0 1989785280 20685664 12490272
14:32:37 11435 8192000000 10917643024 11350904832 1979525600 19.461 100 59 118 0 2019166816 21809936 17831280
14:33:01 21975 8192000000 10928220688 11360174080 1977536864 19.445 100 48 96 1 2015960320 23963472 14459984
14:33:39 14393 8192000000 10905965200 11348234240 1947435424 19.206 98 41 82 2 1983454416 22810256 13208736
14:34:09 8909 8192000000 10948250064 11377078272 1990358592 19.547 100 42 80 0 2030036912 27094768 12583552
14:34:27 12724 8192000000 10959080832 11385679872 1980763968 19.471 99 51 99 3 2024938976 29084592 15090416
14:34:50 12562 8192000000 10963179856 11396722688 1999665024 19.620 100 55 110 2 2047065696 30966688 16433984
14:35:17 14920 8192000000 10966304656 11397779456 2003078464 19.647 100 49 98 2 2052524624 34288096 15158064
14:35:40 12516 8192000000 10971184384 11401797632 2010705200 19.707 100 65 130 2 2063758112 33309504 19743408
14:36:01 6528 8192000000 10983292912 11414900736 2017584160 19.761 100 65 126 0 2072344640 35762064 18998416
14:36:17 9418 8192000000 10981226144 11412201472 2012213904 19.719 100 56 112 1 2066908016 37542208 17151904
14:36:34 14255 8192000000 10959032416 11394052096 1978108176 19.450 98 50 100 1 2032227328 37905296 16213856
14:36:57 9669 8192000000 10973254656 11406606336 1990343088 19.547 99 51 102 1 2045781312 39340224 16098000
14:37:19 7494 8192000000 10972294432 11412267008 2012994032 19.725 100 42 84 2 2065168320 38811392 13362896
14:37:36 6782 8192000000 10989383472 11427966976 2024529520 19.816 100 52 103 1 2081056064 39746064 16780480
14:37:52 9455 8192000000 11003247856 11439308800 2033634448 19.887 100 63 126 1 2093615520 40492288 19488784
14:38:11 8692 8192000000 11017515504 11444797440 2033938896 19.889 100 62 124 0 2095053008 42356864 18757248
14:38:28 2321 8192000000 11008112480 11444305920 2038696080 19.927 100 62 123 1 2101986000 43731248 19558672
14:38:37 8531 8192000000 10999992704 11432693760 2020458128 19.784 99 57 113 1 2081600304 43022544 18119632
14:38:54 3385 8192000000 11019839456 11439874048 2034849216 19.897 100 69 138 1 2100468912 43303200 22316496
14:39:04 3233 8192000000 11006721952 11432980480 2012917440 19.724 99 70 140 0 2081111776 45544416 22649920
14:39:15 2021 8192000000 11016747376 11429761024 2009332032 19.696 99 81 161 2 2080326592 46217216 24777344
14:39:24 7884 8192000000 10991748816 11411791872 1999866272 19.622 99 73 146 1 2071611328 48466816 23278240
14:39:40 4797 8192000000 10997828912 11421065216 2009985216 19.701 100 68 136 0 2082096384 50486736 21624432
14:39:56 3077 8192000000 11013438240 11437248512 2023945792 19.811 100 85 167 4 2099225936 49075888 26204256
14:40:07 2335 8192000000 11001672864 11417415680 1998170000 19.608 99 83 167 3 2071056688 47375104 25511584
14:40:17 6664 8192000000 10999965776 11430318080 2018721280 19.770 100 62 123 3 2085271344 47530592 19019472
14:40:32 4310 8192000000 11008862720 11431956480 2022389472 19.799 100 62 125 0 2089425584 47875952 19160160
14:40:45 10333 8192000000 11001614128 11426496512 2002447680 19.642 99 69 138 4 2072802096 49184592 21169824
14:41:05 2676 8192000000 10993344192 11406110720 1985191232 19.506 99 83 165 2 2060644912 49963280 25490400
14:41:15 2937 8192000000 11001052016 11415105536 2009524368 19.698 100 89 178 3 2090005408 52149584 28331456
14:41:25 3963 8192000000 11001092048 11421237248 2007982640 19.686 100 75 150 2 2083002528 51675952 23343936
14:41:36 2709 8192000000 11005631264 11414863872 2002788688 19.645 99 89 178 1 2084711136 54108560 27813888
14:41:46 3726 8192000000 11008956224 11423965184 2010516672 19.706 100 81 161 2 2090147056 54509376 25121008
14:41:57 2825 8192000000 10975032032 11392679936 1976544736 19.437 99 80 160 2 2056852688 54959680 25348272
14:42:07 6088 8192000000 10968069248 11375722496 1947022384 19.203 98 82 164 0 2029399328 56482368 25894576
14:42:21 2434 8192000000 10984046512 11393388544 1983939056 19.496 100 84 168 2 2068667424 57933520 26794848
14:42:30 2611 8192000000 10974225808 11380711424 1957709504 19.288 99 86 172 2 2044203712 58524096 27970112
14:42:45 4251 8192000000 10987504112 11402805248 1981719872 19.478 100 88 174 2 2071141712 62058832 27363008
14:42:56 6431 8192000000 10971055968 11387392000 1966654096 19.359 99 77 154 1 2052696672 61758944 24283632
14:43:10 2132 8192000000 10977708960 11395125248 1978125248 19.450 100 81 161 0 2060013744 56841216 25047280
14:43:22 3409 8192000000 10977758272 11393839104 1963133168 19.331 99 75 149 2 2043836752 57139040 23564544
14:43:33 3174 8192000000 10971814176 11387076608 1975479088 19.429 100 79 158 2 2054057760 54755552 23823120
14:43:45 2319 8192000000 10986455344 11392536576 1981007920 19.473 100 84 164 2 2062919152 56628336 25282896
14:43:54 5350 8192000000 10980917056 11398139904 1976776640 19.439 100 72 142 1 2058799680 59531968 22491072
14:44:09 4386 8192000000 10998681040 11408146432 1987364336 19.523 100 84 167 1 2075046208 60448464 27233408
14:44:21 2218 8192000000 10966019600 11370188800 1942849808 19.169 98 84 166 0 2031135440 61700176 26585456
14:44:30 2415 8192000000 10997808512 11403587584 1979211872 19.458 100 92 180 0 2071341904 63487840 28642192
14:44:40 4993 8192000000 10992620864 11408936960 1986582768 19.517 100 80 159 1 2075035264 63871280 24581216
14:44:53 2229 8192000000 10993486336 11410186240 1987535168 19.524 100 79 158 1 2078423344 65060144 25828032
14:45:03 1462 8192000000 11012479056 11422965760 1993414688 19.571 100 91 182 3 2088845280 67123600 28306992
14:45:11 3591 8192000000 10998669408 11415072768 1988793552 19.534 100 81 163 0 2078784176 63526944 26463680
14:45:23 3303 8192000000 10979472928 11405041664 1977424288 19.444 100 68 133 1 2064682240 64908496 22349456
14:45:42 17479 8192000000 10958171376 11402780672 1971021856 19.394 100 45 88 1 2051189856 64483408 15684592
14:46:12 9311 8192000000 10953667600 11392770048 1961043040 19.314 100 50 100 2 2042982768 63674576 18265152
14:46:31 8560 8192000000 10968146304 11403075584 1971132000 19.394 100 57 112 3 2050598304 60149648 19316656
14:46:50 17141 8192000000 10963636784 11408703488 1971285728 19.396 100 44 88 3 2049399984 61635024 16479232
14:47:24 12587 8192000000 10977994112 11419697152 1977316576 19.443 100 37 74 0 2057477328 65558784 14601968
14:47:52 5745 8192000000 10971319920 11410661376 1978990384 19.457 100 57 112 1 2064610160 66477856 19141920
14:48:07 12068 8192000000 10963266224 11402776576 1950297312 19.229 99 46 88 2 2032892064 67286256 15308496
14:48:34 13088 8192000000 10934525200 11390148608 1939486992 19.143 99 32 64 1 2017942704 65667616 12788096
14:48:57 29917 8192000000 10926643504 11385245696 1925223552 19.029 99 31 62 2 2002563008 65227424 12112032
14:50:03 8904 8192000000 10907633968 11348586496 1913980064 18.939 99 29 57 0 1974715648 50407248 10328336
14:50:51 28851 8192000000 10858912096 11331026944 1922972160 19.011 99 15 30 0 1954836112 27075840 4788112
14:51:38 33747 8192000000 10885462048 11329888256 1907309136 18.885 98 41 82 2 1931615328 13026544 11279648
14:52:19 20765 8192000000 10880156560 11332374528 1937940880 19.130 100 33 66 1 1963027408 15050080 10036448
14:52:48 16681 8192000000 10875167584 11339751424 1939483200 19.143 100 13 26 0 1961509696 17818944 4207552
14:53:11 10494 8192000000 10871396368 11343716352 1941614160 19.160 100 15 30 3 1957485248 12058912 3812176
14:53:29 31137 8192000000 10884336848 11336265728 1924892688 19.026 99 29 58 1 1944561744 11214512 8454544
14:54:07 20665 8192000000 10881143760 11340525568 1945181504 19.188 100 20 40 0 1962044496 11021488 5841504
14:55:20 94405 8192000000 10835094144 11297849344 1811858896 18.111 94 12 24 1 1823659264 8618240 3182128
14:57:09 81453 8192000000 10883826560 11337187328 1937291872 19.125 100 11 23 0 1949041616 8894304 2855440
14:58:39 32705 8192000000 10886557456 11341889536 1924857280 19.026 98 11 22 1 1934949104 6745680 3346144
14:59:20 32226 8192000000 10887788976 11346186240 1944486896 19.183 99 12 22 1 1959967616 12208576 3272144
15:00:03 97385 8192000000 10894747488 11360514048 1942875584 19.170 99 8 16 1 1958320720 13187984 2257152
15:01:48 43450 8192000000 10901475264 11345539072 1924760160 19.025 98 25 50 1 1940012080 8142032 7109888
15:02:42 46866 8192000000 10897574864 11355205632 1960436944 19.310 100 9 18 1 1972047600 9243072 2367584
15:03:41 65125 8192000000 10894572816 11358789632 1951161296 19.236 99 8 16 0 1964328704 10897280 2270128
15:05:38 100012 8192000000 10909846352 11375009792 1935152384 19.108 98 6 12 0 1947856480 10953952 1750144
15:07:42 19316 8192000000 10928686848 11379572736 1985603008 19.509 100 24 48 2 2008180080 15894688 6682384
15:08:09 45585 8192000000 10930794176 11377463296 1949091840 19.219 98 24 48 4 1972553872 16370016 7092016
15:09:04 67047 8192000000 10921496528 11398762496 1978285856 19.451 100 9 18 0 2010400960 28964192 3150912
15:10:17 66976 8192000000 10891608656 11342610432 1880087328 18.666 95 13 25 1 1895375856 11142096 4146432
15:11:30 159198 8192000000 10911713248 11363880960 1932082256 19.084 98 34 67 0 1960015568 18684608 9248704
15:14:42 33807 8192000000 10907364912 11368529920 1967401632 19.365 100 41 82 1 1992785296 12918608 12465056
15:16:24 32330 8192000000 10863659472 11337064448 1869166800 18.578 95 15 30 1 1881745536 8516560 4062176
15:17:04 37880 8192000000 10901673376 11351859200 1952437856 19.246 100 33 64 1 1973522336 11787568 9296912
15:18:18 26089 8192000000 10907885344 11350929408 1955574960 19.271 100 48 96 2 1981741376 12121632 14044784
15:18:56 63670 8192000000 10875945680 11350831104 1903660544 18.856 97 26 52 0 1930687248 19535856 7490848
15:20:15 162923 8192000000 10842318496 11311054848 1822183600 18.196 93 18 36 0 1848768000 21383168 5201232
15:23:04 75109 8192000000 10844048304 11320774656 1895952144 18.794 98 12 24 2 1914220224 14497056 3771024
15:24:32 60526 8192000000 10863912384 11329945600 1880955536 18.673 97 17 34 0 1901161968 15678624 4527808
15:25:59 31553 8192000000 10876694400 11343986688 1934115168 19.100 100 22 44 0 1968323504 26643472 7564864
15:26:37 29696 8192000000 10877279024 11368505344 1941472912 19.159 100 19 38 0 1976245456 27889008 6883536
15:27:17 90929 8192000000 10894153984 11359535104 1902314880 18.845 97 17 34 1 1931434512 23980224 5139408
15:29:09 150988 8192000000 10882309472 11356225536 1777818224 17.832 91 14 28 0 1802898960 20589392 4491344
15:31:47 61423 8192000000 10863253504 11322052608 1841501376 18.353 94 16 32 0 1854140128 8220144 4418608
15:32:56 93376 8192000000 10876107056 11350437888 1919220272 18.981 99 13 26 0 1933524528 10810624 3493632
15:35:03 22579 8192000000 10904179120 11353407488 1930111296 19.068 98 47 94 0 1954859872 11649024 13099552
15:35:38 50969 8192000000 10901509472 11359313920 1939129296 19.140 99 47 95 1 1966083792 13917280 13037216
15:36:42 90569 8192000000 10873953344 11336577024 1797706400 17.995 92 18 36 2 1811967696 9713776 4547520
15:38:22 62107 8192000000 10905098320 11364007936 1949326048 19.221 100 18 36 0 1972640112 18294592 5019472
15:39:31 40339 8192000000 10907924256 11358695424 1935099312 19.108 99 37 71 0 1969000576 23105968 10795296
15:40:26 25414 8192000000 10897008128 11353030656 1937516240 19.127 99 35 69 2 1962097824 14716496 9865088
15:41:02 86617 8192000000 10861395856 11332345856 1857885888 18.486 95 21 42 1 1875200512 11716512 5598112
15:42:37 148986 8192000000 10875802432 11345178624 1886297808 18.716 97 26 52 1 1907440832 13860576 7282448
15:45:12 40993 8192000000 10867237984 11351711744 1945006624 19.187 100 23 46 1 1973966480 22345200 6614656
15:46:16 69210 8192000000 10870590592 11346382848 1931459616 19.079 99 17 35 0 1944470608 8811072 4199920
15:47:32 79994 8192000000 10852240704 11327954944 1885764192 18.712 97 9 18 1 1899456528 11535472 2156864
15:49:00 68974 8192000000 10864516928 11336572928 1925566272 19.031 99 28 54 0 1947836592 15345248 6925072
15:50:44 79153 8192000000 10867599248 11341209600 1928207056 19.053 99 18 36 1 1942651360 9308000 5136304
15:52:10 59859 8192000000 10849406144 11338559488 1899904640 18.826 98 9 18 0 1913278816 10961248 2412928
15:53:16 40214 8192000000 10876546736 11337199616 1928897264 19.058 99 37 74 0 1947022928 8107120 10018544
15:54:03 46822 8192000000 10863509520 11338825728 1921445472 18.998 99 15 30 2 1934952736 9260208 4247056
15:55:01 26231 8192000000 10871610640 11344134144 1944787104 19.185 100 25 50 1 1960471680 8710800 6973776
15:55:34 61107 8192000000 10888103680 11348406272 1935563792 19.111 99 24 48 1 1950900128 8574016 6762320
15:57:44 97733 8192000000 10890367616 11350761472 1865377408 18.547 95 15 30 0 1882050224 12866944 3805872
15:59:31 60375 8192000000 10893749136 11360047104 1918529760 18.975 98 20 40 0 1934979600 11238608 5211232
16:00:38 42140 8192000000 10910220112 11367411712 1947832272 19.209 99 23 46 0 1965478048 11715024 5930752
16:01:29 56291 8192000000 10886289776 11356643328 1928464480 19.055 98 19 38 1 1943110992 9990736 4655776
16:02:31 52374 8192000000 10879219248 11350491136 1920172368 18.988 98 13 26 1 1934655872 11247472 3236032
16:03:42 77883 8192000000 10896486656 11362115584 1923765008 19.017 98 14 28 1 1937379472 10042752 3571712
16:05:25 26207 8192000000 10925029424 11367399424 1951143424 19.236 99 43 86 2 1977168592 13592816 12432352
16:06:02 8749 8192000000 10900606832 11342962688 1918975856 18.979 98 53 106 1 1950575296 16114096 15485344
16:06:23 12835 8192000000 10892773712 11339079680 1920909568 18.994 99 43 86 2 1953303440 20389904 12003968
16:06:46 111789 8192000000 10856972800 11335696384 1859727536 18.501 96 12 24 0 1881250880 18478688 3044656
16:08:54 106515 8192000000 10873183408 11346984960 1917202912 18.964 99 16 32 0 1935085984 13315680 4567392
16:11:08 36472 8192000000 10823421728 11296497664 1858371552 18.490 96 15 29 2 1874665760 11972432 4321776
16:11:59 46643 8192000000 10834412272 11312705536 1903018800 18.851 99 5 10 0 1915134512 11186912 928800
16:13:11 64771 8192000000 10865147040 11335737344 1929284176 19.061 99 30 60 1 1946055328 8503312 8267840
16:14:23 40572 8192000000 10861626912 11342364672 1928925248 19.058 99 11 22 2 1939693136 7730368 3037520
16:15:16 45606 8192000000 10851685216 11322535936 1894256128 18.780 97 15 30 2 1910073776 11407040 4410608
16:16:24 61652 8192000000 10875191296 11344605184 1949161840 19.220 100 15 30 2 1965638896 11409728 5067328
16:17:32 70375 8192000000 10850332656 11325366272 1871077728 18.593 96 19 38 2 1891536656 14475680 5983248
16:18:50 53564 8192000000 10870248192 11338256384 1921356416 18.998 99 18 36 1 1942491728 15707120 5428192
16:19:53 55375 8192000000 10872974224 11353366528 1947041584 19.203 100 12 22 0 1964883504 14374656 3467264
16:20:55 51159 8192000000 10876381936 11343527936 1919827984 18.985 98 23 46 2 1937417712 11271792 6317936
16:21:56 78486 8192000000 10866290784 11334062080 1860015216 18.503 95 14 28 0 1871649072 8160240 3473616
16:23:23 66356 8192000000 10852094336 11325313024 1866313904 18.554 96 16 32 0 1884055680 13350608 4391168
16:24:44 78686 8192000000 10860311312 11316584448 1840208144 18.343 95 27 54 0 1856742928 8986432 7548352
16:26:16 63828 8192000000 9180793456 9422221312 339519040 3.979 18 6 12 0 348031184 6910912 1601232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 29-11-2020 16:28:17 to 29-11-2020 16:28:47.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-11-2020 16:28:48 to 29-11-2020 16:28:50.

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          245364
MON$OLDEST_ACTIVE               245365
MON$OLDEST_SNAPSHOT             245365
MON$NEXT_TRANSACTION            245365
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                       2046944
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:84: 
:85: mscs-test-161.budzdorov.ru    Sun Nov 29 16:27:26 2020
:86:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:87: 
:88: 
:89: mscs-test-161.budzdorov.ru    Sun Nov 29 16:27:26 2020
:90:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:91: 
:92: 
:93: mscs-test-161.budzdorov.ru    Sun Nov 29 16:27:29 2020
:94:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:95: 
--- end of diff output ---

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

29.11.20 16:28:51. 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-11-29 16:28:53 No severe PSQL-related problems occured
29.11.20 16:28:55. End of report.