Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.06.2021 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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17109108 kB
MemAvailable 31399756 kB
Buffers 0 kB
Cached 14538820 kB
SwapCached 32 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-13 19:27:38
DTS_END                         2021-06-13 19:27:38.3380
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/58490
TRN_ID                          249527
ATT_ID                          641
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: 9520.53 19773 1142464
customer order: creation 187.21 334 22465
customer order: refuse 16.02 356 1922
order to supplier: creation 48.35 1267 5802
order to supplier: removal 3.51 100428 421
invoice (draft): creation 48.94 3646 5873
invoice (draft): removal 54.51 816 6541
invoice accept: apply 43.67 19060 5240
invoice accept: cancel 48.98 869 5877
customer reserve: creation 3967.29 192 476075
customer reserve: removal 4789.43 57 574731
realization accept: apply 89.40 184 10728
realization accept: cancel 83.10 111 9972
payment from customer: creation 64.40 124 7728
payment from customer: removal 5.94 81 713
payment to supplier: creation 53.42 133 6410
payment to supplier: removal 3.41 94 409
service: total inventory turnovers 5.08 1122 609
service: total monetary turnovers 7.09 34 851
service: aggregate perf. data 0.78 22246 93
service: refresh index statistics 0.03 244311 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-06-2021 19:28:48 to 13-06-2021 19:28:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2605
TEST_TIME 2 4118
TEST_TIME 3 5171
TEST_TIME 4 5011
TEST_TIME 5 5329
TEST_TIME 6 5295
TEST_TIME 7 6021
TEST_TIME 8 6043
TEST_TIME 9 5963
TEST_TIME 10 6375
TEST_TIME 11 6577
TEST_TIME 12 6569
TEST_TIME 13 6973
TEST_TIME 14 7308
TEST_TIME 15 7800
TEST_TIME 16 7816
TEST_TIME 17 8152
TEST_TIME 18 8039
TEST_TIME 19 8301
TEST_TIME 20 8238
TEST_TIME 21 8507
TEST_TIME 22 9110
TEST_TIME 23 9123
TEST_TIME 24 9454
TEST_TIME 25 9291
TEST_TIME 26 9304
TEST_TIME 27 9207
TEST_TIME 28 9434
TEST_TIME 29 9671
TEST_TIME 30 9992
TEST_TIME 31 9893
TEST_TIME 32 10868
TEST_TIME 33 11014
TEST_TIME 34 10961
TEST_TIME 35 10851
TEST_TIME 36 10915
TEST_TIME 37 10736
TEST_TIME 38 10647
TEST_TIME 39 10636
TEST_TIME 40 10442
TEST_TIME 41 10432
TEST_TIME 42 10358
TEST_TIME 43 10165
TEST_TIME 44 10140
TEST_TIME 45 10157
TEST_TIME 46 10118
TEST_TIME 47 10015
TEST_TIME 48 10011
TEST_TIME 49 9932
TEST_TIME 50 9925
TEST_TIME 51 9958
TEST_TIME 52 9910
TEST_TIME 53 9846
TEST_TIME 54 9749
TEST_TIME 55 9803
TEST_TIME 56 9787
TEST_TIME 57 9819
TEST_TIME 58 9735
TEST_TIME 59 9694
TEST_TIME 60 9613
TEST_TIME 61 9487
TEST_TIME 62 9509
TEST_TIME 63 9480
TEST_TIME 64 9489
TEST_TIME 65 9495
TEST_TIME 66 9552
TEST_TIME 67 9593
TEST_TIME 68 9641
TEST_TIME 69 9676
TEST_TIME 70 9678
TEST_TIME 71 9719
TEST_TIME 72 9744
TEST_TIME 73 9771
TEST_TIME 74 9807
TEST_TIME 75 9789
TEST_TIME 76 9785
TEST_TIME 77 9693
TEST_TIME 78 9620
TEST_TIME 79 9585
TEST_TIME 80 9572
TEST_TIME 81 9527
TEST_TIME 82 9498
TEST_TIME 83 9436
TEST_TIME 84 9448
TEST_TIME 85 9427
TEST_TIME 86 9390
TEST_TIME 87 9461
TEST_TIME 88 9457
TEST_TIME 89 9469
TEST_TIME 90 9487
TEST_TIME 91 9527
TEST_TIME 92 9565
TEST_TIME 93 9594
TEST_TIME 94 9558
TEST_TIME 95 9598
TEST_TIME 96 9663
TEST_TIME 97 9631
TEST_TIME 98 9641
TEST_TIME 99 9571
TEST_TIME 100 9551
TEST_TIME 101 9513
TEST_TIME 102 9514
TEST_TIME 103 9482
TEST_TIME 104 9454
TEST_TIME 105 9399
TEST_TIME 106 9380
TEST_TIME 107 9387
TEST_TIME 108 9397
TEST_TIME 109 9402
TEST_TIME 110 9390
TEST_TIME 111 9412
TEST_TIME 112 9399
TEST_TIME 113 9420
TEST_TIME 114 9431
TEST_TIME 115 9464
TEST_TIME 116 9431
TEST_TIME 117 9469
TEST_TIME 118 9460
TEST_TIME 119 9465
TEST_TIME 120 9522

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-06-2021 19:28:52 to 13-06-2021 19:28:55.

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 1585066 1585066 0 0.00 0 23296 7 0 0
doc_list_biud 1585066 1585066 0 0.00 0 25093 27 0 0
sp_add_invoice_to_stock 5325 5240 85 1.59 36 202032 19061 0 85
sp_cancel_adding_invoice 5877 5877 0 0.00 5 69448 870 0 0
sp_cancel_client_order 1922 1922 0 0.00 4 10037 357 0 0
sp_cancel_customer_reserve 574731 574731 0 0.00 1 25095 58 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 9642 82 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 6011 95 0 0
sp_cancel_supplier_invoice 6551 6541 10 0.15 2 13392 816 0 10
sp_cancel_supplier_order 421 421 0 0.00 8 973035 100429 0 0
sp_cancel_write_off 9972 9972 0 0.00 1 9307 111 0 0
sp_client_order 22465 22465 0 0.00 3 17636 335 0 0
sp_customer_reserve 476075 476075 0 0.00 0 56350 192 0 0
sp_fill_shopping_cart 34130 34130 0 0.00 1 11649 34 0 0
sp_fill_shopping_cart_clo_res 476071 476071 0 0.00 0 22276 13 0 0
sp_get_clo_for_invoice 5236 5236 0 0.00 0 28175 288 0 0
sp_kill_cost_storno 16971 16971 0 0.00 0 12669 59 0 0
sp_kill_qstorno_ret_qs2qd 1166396 1166396 0 0.00 0 25086 32 0 0
sp_kill_qty_storno 615428 615428 0 0.00 0 25093 69 0 0
sp_lock_selected_doc 22099 22099 0 0.00 0 10139 6 0 0
sp_make_cost_storno 30102 30102 0 0.00 0 23294 54 0 0
sp_multiply_rows_for_pdistr 30102 30102 0 0.00 0 13634 30 0 0
sp_multiply_rows_for_qdistr 22465 22465 0 0.00 0 12391 148 0 0
sp_pay_from_customer 7728 7728 0 0.00 4 13950 124 0 0
sp_pay_to_supplier 6410 6410 0 0.00 4 23485 134 0 0
sp_payment_common 14138 14138 0 0.00 1 22980 35 0 0
sp_qd_handle_on_cancel_clo 1922 1922 0 0.00 0 10029 328 0 0
sp_qd_handle_on_invoice_upd_sts 11113 11113 0 0.00 0 14318 344 0 0
sp_qd_handle_on_reserve_upd_sts 10728 10728 0 0.00 0 14362 54 0 0
sp_reserve_write_off 10728 10728 0 0.00 6 14554 185 0 0
sp_supplier_invoice 5873 5873 0 0.00 7 86449 3647 0 0
sp_supplier_order 5802 5802 0 0.00 6 21507 1268 0 0
srv_aggregate_perf_data 93 93 0 0.00 2894 189080 22246 0 0
srv_fill_mon_cache_memory 187 187 0 0.00 816 117118 27167 0 0
srv_find_qd_qs_mism 1092623 1092623 0 0.00 0 13453 6 0 0
srv_make_invnt_saldo 609 609 0 0.00 39 64463 1122 0 0
srv_make_money_saldo 851 851 0 0.00 1 4355 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 120644 363952 244311 0 0
t$perf-abend:sp_add_invoice_to_stock 85 85 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5241 5241 0 0.00 0 11479 156 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 1 4669 97 0 0
t$perf-norm:sp_cancel_client_order 1922 1922 0 0.00 0 15140 23 0 0
t$perf-norm:sp_cancel_customer_reserve 769 769 0 0.00 0 5075 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 1644 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 1322 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 406 10 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 22798 1697 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 2276 7 0 0
t$perf-norm:sp_client_order 22465 22465 0 0.00 0 34248 23 0 0
t$perf-norm:sp_customer_reserve 1049 1049 0 0.00 0 8529 16 0 0
t$perf-norm:sp_pay_from_customer 7728 7728 0 0.00 0 6713 9 0 0
t$perf-norm:sp_pay_to_supplier 6410 6410 0 0.00 0 5839 9 0 0
t$perf-norm:sp_reserve_write_off 10728 10728 0 0.00 0 23158 13 0 0
t$perf-norm:sp_supplier_invoice 5873 5873 0 0.00 0 8294 20 0 0
t$perf-norm:sp_supplier_order 5802 5802 0 0.00 0 4598 18 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 366 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 187 187 0 0.00 0 703 11 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 746 24 0 0
t$perf-norm:srv_make_money_saldo 851 851 0 0.00 0 2044 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10642 10472 170 1.59 0 13020 21 0 170
v_all_customers 40876 40876 0 0.00 0 15 1 0 0
v_all_suppliers 32830 32830 0 0.00 0 21 1 0 0
v_all_wares 44930 44930 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 3615 14 0 0
v_cancel_client_order 3844 3844 0 0.00 0 2358 5 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 2113 7 0 0
v_cancel_customer_reserve 1538 1538 0 0.00 0 2834 8 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 1306 9 0 0
v_cancel_supplier_invoice 878 858 20 2.27 0 3314 25 0 20
v_cancel_supplier_order 842 842 0 0.00 0 731 5 0 0
v_cancel_write_off 2042 2042 0 0.00 0 3516 18 0 0
v_max_id_clo_ord 5802 5802 0 0.00 0 805 1 0 0
v_max_id_clo_res 1049 1049 0 0.00 0 3073 18 0 0
v_max_id_ord_sup 5863 5863 0 0.00 0 3455 4 0 0
v_max_non_paid_invoice 1660 1660 0 0.00 0 9349 8 0 0
v_max_non_paid_realizn 4114 4114 0 0.00 0 2583 4 0 0
v_min_id_clo_ord 5802 5802 0 0.00 0 11085 10 0 0
v_min_id_clo_res 1049 1049 0 0.00 0 6583 12 0 0
v_min_id_ord_sup 5863 5863 0 0.00 0 5213 5 0 0
v_min_non_paid_invoice 6410 6410 0 0.00 0 9822 20 0 0
v_min_non_paid_realizn 7728 7728 0 0.00 0 10975 20 0 0
v_our_firm 11282 11282 0 0.00 0 18 1 0 0
v_reserve_write_off 21456 21456 0 0.00 0 12973 7 0 0
x_lock_depdocs_on_canc_invoice 11989 11989 0 0.00 0 11566 112 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 11622 375 0 0
x_make_qstorno_1000_1200 5802 5802 0 0.00 2 21485 1182 0 0
x_make_qstorno_1200_2000 5873 5873 0 0.00 3 86419 3535 0 0
x_make_qstorno_2100_3300 476074 476074 0 0.00 0 56350 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-06-2021 19:28:56 to 13-06-2021 19:29:00.

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:42 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
16:57:48 10354 8192000000 10174533936 10473271296 811112432 9.009 66 48 93 0 829593888 2291616 16189840
16:58:07 18522 8192000000 10302951328 10612482048 1355017424 14.193 100 84 168 0 1386968240 4362368 27588448
16:58:37 36083 8192000000 10359517040 10679377920 1399631616 14.592 100 83 166 0 1433396608 5988416 27776576
16:59:29 24835 8192000000 10399115264 10722107392 1442009968 14.967 100 86 172 0 1477500784 7347472 28143344
17:00:06 19625 8192000000 10415067824 10742910976 1466642016 15.184 100 86 172 1 1502478016 7865392 27970608
17:00:34 17420 8192000000 10437697952 10768572416 1495204608 15.434 100 90 180 0 1532432928 8575888 28652432
17:01:01 11077 8192000000 10459098608 10796236800 1517648416 15.630 100 89 178 0 1554847936 8867856 28331664
17:01:26 17443 8192000000 10480921200 10821992448 1537161120 15.799 100 89 178 1 1575090800 10001936 27927744
17:01:56 15446 8192000000 10514895504 10857902080 1567800144 16.063 100 88 176 1 1605645456 10658784 27186528
17:02:30 16567 8192000000 10524283184 10879164416 1583289472 16.196 100 80 160 0 1618796512 10991872 24515168
17:02:57 10705 8192000000 10541075232 10899144704 1607147952 16.400 100 69 138 0 1638673344 10499888 21025504
17:03:16 12858 8192000000 10577419472 10939817984 1632248672 16.614 100 70 140 0 1663049424 10515504 20285248
17:03:42 11248 8192000000 10606965504 10968485888 1659994624 16.849 100 77 154 2 1693917568 11493408 22429536
17:04:01 5877 8192000000 10618627664 10983751680 1676021248 16.984 100 81 163 2 1712272016 12518384 23732384
17:04:17 8133 8192000000 10629732896 10997055488 1689024272 17.093 100 82 164 1 1725068064 13266336 22777456
17:04:33 7756 8192000000 10643243296 11013103616 1708896496 17.260 100 84 168 2 1746756272 13917408 23942368
17:04:49 4858 8192000000 10658852880 11028774912 1715032992 17.311 100 78 154 1 1750213056 13522336 21657728
17:05:06 6980 8192000000 10670955120 11045384192 1730266320 17.438 100 75 148 2 1764228736 13123056 20839360
17:05:20 6453 8192000000 10693261296 11062304768 1750236832 17.604 100 86 172 0 1787951376 13379392 24335152
17:05:33 4984 8192000000 10698027152 11071107072 1756730848 17.657 100 87 174 1 1795206208 14046112 24429248
17:05:45 6588 8192000000 10697941648 11076866048 1757517824 17.664 100 73 146 2 1791625584 13945888 20161872
17:05:58 4095 8192000000 10692111536 11076182016 1760933392 17.692 100 73 146 2 1795882528 14071216 20877920
17:06:10 4411 8192000000 10705488512 11083952128 1767644240 17.748 100 80 156 3 1803231792 13237488 22350064
17:06:21 3816 8192000000 10726064224 11103961088 1784598512 17.887 100 85 168 0 1821383472 13111584 23673376
17:06:32 8987 8192000000 10715286368 11105583104 1786209600 17.901 100 66 132 3 1816555504 12104928 18240976
17:06:48 4501 8192000000 10727063008 11114360832 1791951456 17.948 100 72 142 1 1823653200 12117616 19584128
17:06:59 2810 8192000000 10749172400 11134046208 1812125312 18.113 100 81 160 3 1846319600 12018704 22175584
17:07:08 3224 8192000000 10766798752 11155349504 1824084144 18.211 100 87 172 2 1861471216 13252560 24134512
17:07:18 2454 8192000000 10756453008 11140677632 1823523472 18.206 100 83 166 1 1858965888 12250576 23191840
17:07:27 2182 8192000000 10774516544 11158355968 1833479312 18.288 100 94 187 1 1872704384 12731168 26493904
17:07:36 1967 8192000000 10784946528 11167850496 1839630464 18.338 100 92 185 1 1878592512 13072208 25889840
17:07:44 3099 8192000000 10772122656 11161477120 1839123024 18.334 100 84 168 1 1875669408 12641840 23904544
17:07:54 2606 8192000000 10786657936 11169759232 1840270736 18.343 100 84 164 2 1876015376 12941200 22803440
17:08:03 2024 8192000000 10790083200 11180871680 1847550752 18.402 100 87 173 1 1885140032 13853632 23735648
17:08:12 2291 8192000000 10792312448 11180920832 1848989664 18.414 100 84 168 0 1885966096 13607120 23369312
17:08:21 2059 8192000000 10802457120 11187736576 1855954832 18.470 100 94 185 2 1896512992 14475200 26082960
17:08:30 3407 8192000000 10797466960 11187793920 1859913504 18.503 100 86 170 4 1897611072 14268448 23429120
17:08:40 1264 8192000000 10796898208 11191185408 1859025184 18.495 100 94 189 0 1899467072 14015680 26426208
17:08:48 2744 8192000000 10799641104 11192307712 1860184208 18.505 100 83 164 2 1896570496 12771488 23614800
17:08:57 2322 8192000000 10806854672 11196899328 1863926368 18.535 100 93 187 1 1903711776 12167328 27618080
17:09:06 8742 8192000000 10804787072 11197796352 1865765040 18.550 100 89 177 3 1903905184 12785872 25354272
17:09:21 2212 8192000000 10812454912 11201294336 1869490416 18.580 100 92 185 1 1908476352 12342224 26643712
17:09:29 2618 8192000000 10811613008 11201335296 1867980224 18.568 100 80 158 1 1904528864 12667280 23881360
17:09:38 3980 8192000000 10795229888 11199950848 1865959488 18.552 100 60 121 1 1893822576 11171856 16691232
17:09:49 1861 8192000000 10796809136 11209629696 1868367056 18.571 100 57 114 0 1898778384 14299520 16111808
17:09:59 2663 8192000000 10796960768 11203604480 1870789136 18.591 100 58 114 3 1896902880 9139248 16974496
17:10:10 8697 8192000000 10776467952 11194961920 1865969600 18.552 100 34 68 1 1883176592 8014464 9192528
17:10:26 40496 8192000000 10797096224 11209142272 1870314256 18.587 100 43 86 2 1888465344 4560080 13591008
17:11:12 12249 8192000000 10818765344 11221143552 1879895824 18.664 100 66 136 5 1905220752 5964544 19360384
17:11:32 5577 8192000000 10797159216 11214815232 1874144864 18.618 100 34 70 2 1890532912 6488544 9899504
17:11:49 5061 8192000000 10798506064 11218927616 1877372672 18.644 100 21 43 0 1890233840 6355328 6505840
17:12:02 4724 8192000000 10798738512 11219587072 1879671376 18.662 100 34 68 2 1900212224 11021616 9519232
17:12:14 3470 8192000000 10804766336 11228921856 1883623696 18.694 100 35 71 0 1905665840 12954944 9087200
17:12:24 5276 8192000000 10797104688 11225300992 1887039152 18.722 100 32 64 1 1903380384 7198176 9143056
17:12:36 3329 8192000000 10822304640 11231973376 1888818928 18.736 100 31 63 2 1902754032 5449376 8485728
17:12:48 8258 8192000000 10794914624 11227394048 1886898288 18.721 100 23 46 2 1899925312 6614672 6412352
17:13:06 5227 8192000000 10800706080 11233046528 1889084592 18.738 100 25 49 1 1903861616 7383136 7393888
17:13:19 11248 8192000000 10789157952 11225030656 1886421840 18.717 100 14 28 0 1895573792 5229392 3922560
17:13:37 9216 8192000000 10796903888 11229814784 1889188080 18.739 100 20 40 1 1900434128 5361680 5884368
17:13:52 12485 8192000000 10796224512 11231166464 1891063792 18.754 100 19 37 3 1902350720 5216368 6070560
17:14:12 7596 8192000000 10804528864 11235254272 1894310000 18.781 100 29 57 2 1909293360 6635088 8348272
17:14:29 5393 8192000000 10807139344 11234054144 1892354640 18.765 100 19 38 1 1903852624 6263056 5234928
17:14:43 10859 8192000000 10812099072 11238895616 1897895712 18.809 100 13 26 2 1907523856 5562096 4066048
17:15:05 54131 8192000000 10816887824 11252449280 1902456192 18.846 100 16 32 0 1913797168 6319792 5021184
17:16:24 9813 8192000000 10812266912 11253526528 1908048752 18.891 100 31 62 1 1923560736 5537280 9974704
17:16:40 6527 8192000000 10824316320 11256225792 1908843584 18.897 100 29 58 1 1922992256 6346752 7801920
17:16:53 5624 8192000000 10807359216 11231752192 1888254272 18.732 99 38 74 0 1906613120 8119600 10239248
17:17:05 5967 8192000000 10826157616 11252269056 1903807424 18.857 100 30 60 0 1920074944 7059904 9207616
17:17:17 9340 8192000000 10811314912 11246501888 1886652176 18.719 99 30 60 1 1902313776 7251968 8409632
17:17:33 10148 8192000000 10798251248 11231285248 1862138992 18.521 98 17 34 1 1872418496 5248192 5031312
17:17:52 6908 8192000000 10787091120 11217313792 1850594272 18.427 98 31 62 1 1865267888 5581328 9092288
17:18:06 7205 8192000000 10799327232 11229196288 1881619840 18.678 100 27 53 2 1895953328 6389680 7943808
17:18:21 6768 8192000000 10791053120 11223740416 1868720256 18.574 99 28 54 1 1881943968 5367616 7856096
17:18:36 7380 8192000000 10793067728 11226128384 1866823488 18.559 99 20 40 1 1879094272 5165168 7105616
17:18:52 10553 8192000000 10759087824 11195088896 1788503072 17.919 95 18 34 2 1799321392 6164640 4653680
17:19:09 11834 8192000000 10764611600 11195682816 1823225584 18.204 98 30 60 3 1837322080 6024320 8072176
17:19:28 8999 8192000000 10738735200 11161042944 1740042752 17.519 94 16 32 0 1749998848 5180720 4775376
17:19:45 11072 8192000000 10702086848 11114729472 1678999696 17.009 92 17 34 2 1688847248 5000432 4847120
17:20:03 73151 8192000000 10682388080 11100712960 1532921120 15.762 84 31 60 2 1547343344 4290624 10131600
17:21:26 12752 8192000000 10670143376 11084238848 1630664688 16.601 92 14 26 2 1638332880 4553344 3114848
17:21:46 5840 8192000000 10698467904 11110785024 1762235216 17.703 99 29 58 0 1777665920 7458160 7972544
17:22:00 8708 8192000000 10711274624 11108831232 1761866048 17.700 99 26 50 0 1774651248 5259808 7525392
17:22:15 8801 8192000000 10687397200 11102482432 1730983952 17.444 97 34 68 2 1750764336 9682016 10098368
17:22:32 6570 8192000000 10712840688 11128668160 1778939328 17.841 99 31 60 1 1793843808 6232352 8672128
17:22:46 6305 8192000000 10715709168 11130830848 1785409584 17.894 99 36 70 3 1803020720 7179056 10432080
17:23:01 8909 8192000000 10741165888 11155746816 1819740512 18.176 100 25 49 4 1832413104 5520848 7151744
17:23:17 9659 8192000000 10740032672 11164274688 1794363456 17.968 98 30 60 3 1808679120 5480384 8835280
17:23:34 6805 8192000000 10755733104 11175510016 1835398160 18.303 100 39 76 6 1852579472 4983776 12197536
17:23:48 6895 8192000000 10755700192 11185209344 1841644656 18.354 100 20 40 1 1852925760 5286528 5994576
17:24:04 12105 8192000000 10772940800 11191336960 1846118000 18.391 100 20 40 1 1856973152 5184640 5670512
17:24:24 15649 8192000000 10760263936 11190644736 1848509776 18.410 100 16 32 0 1858147248 4637472 5000000
17:24:50 72036 8192000000 10775020320 11203088384 1858261184 18.489 100 28 56 0 1871045296 4846816 7937296
17:26:12 6093 8192000000 10775318640 11200061440 1857448480 18.483 100 25 50 2 1870288384 5496128 7343776
17:26:25 5155 8192000000 10774184544 11201744896 1859453584 18.499 100 40 80 1 1878371760 7836576 11081600
17:26:40 6505 8192000000 10774089360 11200868352 1858882512 18.494 100 25 50 1 1872298784 5569680 7846592
17:26:54 8949 8192000000 10781316016 11207032832 1866181136 18.553 100 45 89 3 1885843600 6111616 13550848
17:27:11 4838 8192000000 10799257728 11227566080 1885064864 18.706 100 27 54 4 1897522608 5084464 7373280
17:27:21 8934 8192000000 10806901840 11236626432 1893926016 18.777 100 25 50 1 1906484896 5218016 7340864
17:27:37 30828 8192000000 10818639376 11243851776 1901233728 18.836 100 25 50 1 1913487008 4719360 7533920
17:28:17 14829 8192000000 10840200896 11261104128 1913091440 18.931 100 55 110 2 1936221360 6621616 16508304
17:28:46 18615 8192000000 10850986368 11271049216 1922473888 19.007 100 51 102 2 1945629648 8617120 14538640
17:29:12 9531 8192000000 10865032224 11285491712 1930340624 19.070 100 59 118 1 1956643856 8974752 17328480
17:29:28 6950 8192000000 10872754320 11292131328 1936551296 19.119 100 64 128 2 1965762320 9359152 19851872
17:29:44 18144 8192000000 10868280496 11298484224 1939107696 19.140 100 51 102 0 1964940880 11109392 14723792
17:30:10 18150 8192000000 10860136448 11296305152 1940936624 19.154 100 41 82 1 1963944736 10848912 12159200
17:30:36 69726 8192000000 10864699040 11303211008 1925586016 19.032 99 39 77 2 1946502608 9482656 11433936
17:31:53 17458 8192000000 10875605248 11312181248 1951788032 19.241 100 51 102 3 1979188608 11842912 15557664
17:32:37 42870 8192000000 10907811152 11342028800 1967349552 19.364 100 39 76 0 1998824560 19118032 12356976
17:33:31 22022 8192000000 10909412256 11347443712 1975496384 19.429 100 41 82 0 2006201552 18416224 12288944
17:34:01 8182 8192000000 10924561936 11348717568 1972658208 19.407 100 53 102 1 2007504768 20108768 14737792
17:34:17 5401 8192000000 10915880896 11340238848 1971819504 19.400 100 60 117 1 2007278096 18536816 16921776
17:34:30 2642 8192000000 10919443840 11346984960 1974931232 19.425 100 66 127 0 2009975968 17156448 17888288
17:34:43 3593 8192000000 10921840320 11347513344 1976436688 19.436 100 68 135 0 2010999296 15334512 19228096
17:34:56 11125 8192000000 10914740288 11349901312 1978772976 19.455 100 56 112 0 2010312224 14712256 16826992
17:35:18 8452 8192000000 10936147088 11363000320 1986105840 19.513 100 56 108 1 2019344544 17446432 15792272
17:35:33 9331 8192000000 10930333152 11361558528 1991423984 19.555 100 59 116 1 2025844928 17681392 16739552
17:35:50 9819 8192000000 10930835696 11364233216 1987702608 19.526 100 47 93 0 2019936080 18300928 13932544
17:36:09 7869 8192000000 10933401664 11364552704 1986367248 19.515 100 57 112 1 2021940416 17927648 17645520
17:36:25 12205 8192000000 10943165920 11370491904 1990141216 19.545 100 61 122 1 2028548208 19295664 19111328
17:36:55 9474 8192000000 10933395440 11375669248 1992187488 19.561 100 41 82 0 2029412416 23974784 13250144
17:37:11 13844 8192000000 10944232560 11377639424 1991357072 19.555 100 50 98 2 2032101216 24066384 16677760
17:37:36 9246 8192000000 10944603008 11379621888 1990451488 19.547 100 53 106 0 2032890080 25898528 16540064
17:37:52 4356 8192000000 10952231984 11380801536 1997298048 19.601 100 64 128 0 2041121600 24176976 19646576
17:38:04 4944 8192000000 10956808800 11383820288 2001721520 19.636 100 68 136 0 2045001792 23715504 19564768
17:38:17 6784 8192000000 10953730400 11384324096 1983273472 19.491 99 57 113 0 2025517856 25039312 17205072
17:38:32 4680 8192000000 10939991536 11368718336 1969075840 19.378 99 54 108 0 2011494592 25435904 16982848
17:38:58 2510 8192000000 10930045488 11362525184 1969594496 19.382 99 58 116 1 2010036192 23044688 17397008
17:39:12 2341 8192000000 10946203008 11378307072 1991007280 19.552 100 56 110 0 2031501792 24444544 16049968
17:39:22 2318 8192000000 10967378848 11383046144 1985051264 19.505 99 78 155 3 2033315776 25918816 22345696
17:39:31 4783 8192000000 10962692976 11390943232 2001966592 19.638 100 71 142 2 2049825600 27160496 20698512
17:39:51 2220 8192000000 10965239392 11395387392 2005582096 19.667 100 68 136 2 2053069792 27559744 19927952
17:40:02 7229 8192000000 10933398624 11354701824 1975932240 19.432 99 79 158 1 2029341184 29542144 23866800
17:40:25 8848 8192000000 10934560592 11374866432 1971238512 19.395 99 54 107 0 2015494560 28314896 15941152
17:40:43 3715 8192000000 10944026256 11368071168 1981155328 19.474 100 74 148 3 2028354368 24989056 22209984
17:40:54 3546 8192000000 10943778976 11370557440 1983880912 19.495 100 67 134 1 2031611616 27261328 20469376
17:41:06 1495 8192000000 10962525312 11383361536 1992388176 19.563 100 78 156 0 2044778064 27037280 25352608
17:41:14 5365 8192000000 10917539328 11341578240 1918442448 18.974 97 74 146 0 1967347328 26865152 22039728
17:41:29 1995 8192000000 10899500512 11332730880 1941281648 19.157 99 52 104 0 1984255792 26831984 16142160
17:41:38 1496 8192000000 10915359632 11323707392 1931034000 19.075 98 89 173 3 1985492528 28299888 26158640
17:41:46 2131 8192000000 10923245472 11344814080 1958671776 19.295 100 79 157 2 2011820800 29464656 23684368
17:41:57 3673 8192000000 10930967568 11346812928 1959525744 19.302 100 87 175 1 2020144096 34346576 26271776
17:42:08 2063 8192000000 10932501840 11342462976 1958253328 19.292 100 89 179 3 2014070336 30032016 25784992
17:42:17 7514 8192000000 10923291840 11353366528 1962161664 19.323 100 65 128 1 2006621216 25202144 19257408
17:42:32 5592 8192000000 10930435904 11347718144 1949841472 19.225 99 69 132 3 1995022176 25044992 20135712
17:42:46 2227 8192000000 10921139504 11337728000 1944662112 19.184 99 66 132 1 1990494656 26332560 19499984
17:42:55 2374 8192000000 10947825728 11359133696 1973283040 19.411 100 89 177 2 2026866448 26890080 26693328
17:43:05 1581 8192000000 10923546224 11330572288 1936735648 19.121 99 85 170 1 1990397760 28941824 24720288
17:43:15 4607 8192000000 10928595392 11347562496 1959620448 19.303 100 81 161 0 2014552768 30759328 24172992
17:43:28 8546 8192000000 10927139664 11350351872 1957573568 19.287 100 65 130 0 2009758160 32913184 19271408
17:43:47 6393 8192000000 10939544736 11363049472 1970256704 19.387 100 68 136 1 2025704032 35445648 20001680
17:44:00 2791 8192000000 10944541040 11354357760 1964191136 19.339 100 76 153 2 2021372560 34639216 22542208
17:44:11 4060 8192000000 10930899696 11346722816 1956423840 19.278 100 87 171 3 2015972608 34467264 25081504
17:44:23 1743 8192000000 10918694880 11326812160 1939880352 19.146 100 79 156 1 1997023712 33627840 23515520
17:44:33 1192 8192000000 10927387712 11333304320 1944936752 19.186 100 88 175 0 2008660736 38326928 25397056
17:44:40 1566 8192000000 10927594096 11333369856 1930264944 19.069 99 94 190 0 1994657680 35921200 28471536
17:44:51 5025 8192000000 10900971520 11322003456 1933192704 19.092 100 59 118 0 1986291088 35977584 17120800
17:45:03 8875 8192000000 10883485408 11312357376 1910682992 18.912 99 42 84 2 1955628608 31509024 13436592
17:45:19 10281 8192000000 10898716912 11327590400 1936501504 19.119 100 52 98 1 1984203936 32280496 15421936
17:45:41 3239 8192000000 10916031344 11331645440 1941004320 19.155 100 80 160 2 2000959616 34953248 25002048
17:45:53 2208 8192000000 10932894912 11348758528 1950214112 19.228 100 75 146 3 2010701888 36979008 23508768
17:46:04 3390 8192000000 10922558048 11325530112 1930927952 19.074 99 86 173 0 1997027664 39656752 26442960
17:46:15 4658 8192000000 10927816080 11340169216 1939211680 19.140 100 81 162 1 2008843648 44146608 25485360
17:46:26 3149 8192000000 10942041968 11352317952 1948828032 19.217 100 83 165 3 2020242224 45292240 26121952
17:46:38 2627 8192000000 10937434944 11345690624 1947435392 19.206 100 88 175 0 2018896784 44090208 27371184
17:46:47 2125 8192000000 10919395936 11338153984 1923493200 19.015 99 80 158 0 1991673488 44150176 24030112
17:46:56 6725 8192000000 10904730048 11327873024 1926248944 19.037 100 55 111 0 1985011024 41202416 17559664
17:47:14 5617 8192000000 10889110288 11310108672 1908173200 18.892 99 53 107 1 1967687568 42262416 17251952
17:47:34 4200 8192000000 10920809760 11330056192 1930214656 19.069 100 72 143 1 1999058784 45699536 23144592
17:47:49 6202 8192000000 10932816928 11342999552 1939648304 19.144 100 83 165 4 2015995952 47935456 28412192
17:48:03 6681 8192000000 10939875056 11354402816 1944238496 19.181 100 73 146 1 2016584672 48566432 23779744
17:48:17 2154 8192000000 10939696336 11355316224 1943362192 19.174 100 73 144 0 2020769472 53217408 24189872
17:48:27 4028 8192000000 10953129168 11355717632 1954628448 19.263 100 84 165 1 2029833712 49699216 25506048
17:48:44 1459 8192000000 10966673360 11369775104 1965815888 19.352 100 95 189 1 2045892384 50482352 29594144
17:48:52 1374 8192000000 10960211264 11374211072 1960926368 19.313 100 84 166 0 2038211520 50776352 26508800
17:49:07 4353 8192000000 10947533264 11367321600 1964304784 19.340 100 62 124 2 2031099088 46821584 19972720
17:49:18 12138 8192000000 10901628112 11344314368 1946200144 19.196 99 45 90 3 2005526304 44500352 14825808
17:49:46 2137 8192000000 10936509120 11351912448 1959327824 19.301 100 69 138 3 2014599408 34294864 20976720
17:49:55 3580 8192000000 10915630368 11335385088 1938443264 19.134 99 68 136 1 1997083680 37341984 21298432
17:50:10 4140 8192000000 10937827792 11353714688 1953878768 19.257 100 55 111 1 2010755744 39302016 17574960
17:50:21 1418 8192000000 10958617376 11361681408 1967589616 19.366 100 90 177 3 2036503232 40410096 28503520
17:50:30 3020 8192000000 10962353232 11375747072 1967088064 19.362 100 82 160 1 2037536512 44222768 26225680
17:50:40 7081 8192000000 10949943840 11381735424 1971954736 19.401 100 56 112 1 2038660400 47843744 18861920
17:50:57 7252 8192000000 10961258944 11381456896 1976002480 19.433 100 63 127 2 2041576080 45587056 19986544
17:51:16 4748 8192000000 10949933216 11382796288 1975818960 19.432 100 66 129 1 2043385792 46038256 21528576
17:51:29 9492 8192000000 10939916848 11378409472 1964041104 19.338 100 37 72 0 2016694032 40615600 12037328
17:51:47 8352 8192000000 10934849504 11367301120 1967169360 19.363 100 38 76 1 2016395520 37252400 11973760
17:52:02 12387 8192000000 10933575152 11367297024 1950751296 19.232 99 36 72 1 2000274704 37305152 12218256
17:52:24 3449 8192000000 10934158400 11351568384 1948446960 19.214 99 56 107 2 2000056336 34679168 16930208
17:52:34 28998 8192000000 10937520928 11372728320 1970674976 19.391 100 50 99 1 2026286528 39377824 16233728
17:53:27 21473 8192000000 10936105552 11376369664 1964345456 19.341 100 33 66 0 2018867168 43594400 10927312
17:53:59 7661 8192000000 10944014608 11381227520 1967411824 19.365 100 41 80 0 2021464288 40677920 13374544
17:54:14 7990 8192000000 10958999856 11383201792 1975266368 19.427 100 46 90 3 2033071664 42550976 15254320
17:54:31 8449 8192000000 10957947824 11390205952 1981285904 19.475 100 47 94 1 2040067472 43705408 15076160
17:54:58 7127 8192000000 10952359408 11396632576 1976760688 19.439 100 46 92 1 2039352960 47201920 15390352
17:55:16 15209 8192000000 10956313936 11401306112 1974237376 19.419 100 31 62 0 2036863808 51597744 11028688
17:55:47 9009 8192000000 10948140256 11408166912 1972442032 19.405 100 31 62 2 2034899168 51637392 10819744
17:56:14 8987 8192000000 10925098208 11388399616 1964756720 19.344 100 22 44 0 2015317424 42960256 7600448
17:56:35 31214 8192000000 10922249504 11390709760 1951048864 19.235 100 16 32 2 2003580064 46635344 5895856
17:58:11 49823 8192000000 10924179408 11395821568 1951334720 19.237 100 18 35 2 2007039104 49323216 6381168
17:59:11 40345 8192000000 10899947136 11359277056 1918284928 18.973 98 12 24 0 1948798880 26770448 3743504
18:00:28 39667 8192000000 10888626720 11356069888 1905390864 18.870 98 9 18 1 1935862432 28031232 2440336
18:01:35 82513 8192000000 10888470592 11343425536 1941996608 19.163 100 17 34 0 1964375152 17625536 4753008
18:03:03 57737 8192000000 10887873536 11357278208 1955554144 19.271 100 13 25 0 1973410720 14216624 3639952
18:04:07 99925 8192000000 10905583280 11369676800 1949164544 19.220 99 18 36 1 1963365312 9729328 4471440
18:05:54 73385 8192000000 10887800096 11354996736 1891803568 18.760 96 17 35 2 1908437008 11816400 4817040
18:07:23 117117 8192000000 10891151808 11357552640 1930411568 19.070 98 25 50 2 1950186992 11888144 7887280
18:10:49 56530 8192000000 10888292240 11351130112 1941697824 19.160 99 30 56 0 1959967648 10534832 7734992
18:12:07 60806 8192000000 10878880896 11361939456 1946039936 19.195 99 27 54 1 1969230576 15452432 7738208
18:13:21 68630 8192000000 10900192288 11368906752 1958964768 19.298 100 7 14 0 1974508464 13306112 2237584
18:14:36 816 8192000000 10901932096 11370397696 1969911184 19.385 100 18 36 1 1989356944 14466368 4979392
18:14:44 9493 8192000000 10907996304 11365560320 1979321680 19.459 100 39 78 0 1997463072 6768304 11373088
18:15:01 21470 8192000000 10903668880 11372019712 1985265520 19.506 100 46 91 0 2007097376 8609648 13222208
18:15:42 63113 8192000000 10929309312 11386011648 1968526032 19.374 99 23 46 2 1986028304 10971984 6530288
18:16:51 15474 8192000000 10936850640 11390443520 1996159952 19.592 100 52 105 0 2020715344 8904144 15651248
18:17:16 37843 8192000000 10947788336 11389485056 1990723392 19.550 100 50 96 2 2014494544 10554560 13216592
18:18:03 42659 8192000000 10903124080 11365396480 1969600800 19.382 99 34 68 0 1994518112 15113072 9804240
18:18:53 32828 8192000000 10882050784 11367817216 1950132768 19.228 99 8 15 1 1965809600 13771264 1905568
18:19:32 24467 8192000000 10896407648 11377729536 1966853472 19.360 100 6 12 1 1981820464 13130096 1836896
18:20:02 16719 8192000000 10903634112 11376934912 1954823136 19.265 99 10 20 0 1976227632 18362080 3042416
18:20:31 8378 8192000000 10902743008 11384926208 1969865696 19.384 100 10 20 0 1994129488 21215920 3047872
18:20:47 18514 8192000000 10902401296 11382657024 1975218784 19.427 100 13 26 2 1998783408 20253520 3311104
18:21:22 72602 8192000000 10893943712 11379462144 1971751200 19.399 100 29 60 1 1999800400 19794752 8254448
18:22:43 50487 8192000000 10888941792 11364028416 1963709952 19.336 100 12 24 0 1980201904 13131696 3360256
18:23:43 75482 8192000000 10894473456 11375357952 1956448768 19.278 99 17 34 2 1971004672 10110832 4445072
18:25:10 22252 8192000000 10877225104 11359027200 1928449040 19.054 98 13 26 0 1942551680 10317792 3784848
18:25:38 36247 8192000000 10865566032 11347750912 1951960896 19.242 100 7 14 0 1965356288 11265856 2129536
18:26:23 36050 8192000000 10842692480 11322679296 1912659920 18.928 98 17 34 0 1923513408 6278384 4575104
18:27:05 78559 8192000000 10852346608 11329327104 1907079696 18.883 97 13 26 1 1916867104 6166624 3620784
18:30:25 48956 8192000000 10864848112 11338747904 1897132368 18.803 96 19 38 3 1914007872 11398112 5477392
18:31:24 51099 8192000000 10879094704 11354451968 1885734880 18.711 96 15 30 1 1901614608 12122048 3757680
18:32:22 50866 8192000000 10887332272 11364429824 1939935600 19.146 99 19 38 0 1961258784 15520976 5802208
18:33:29 37848 8192000000 10879486064 11350581248 1918952128 18.978 98 12 24 1 1934710656 12436752 3321776
18:34:14 7532 8192000000 10891343984 11349954560 1951281600 19.237 100 46 93 2 1978847856 14023088 13543168
18:34:31 34797 8192000000 10863648320 11336527872 1912862512 18.930 98 31 62 1 1935397312 13208656 9326144
18:35:15 46256 8192000000 10878614688 11330154496 1889635520 18.743 97 21 42 0 1906294576 10937136 5721920
18:36:12 31462 8192000000 10881212288 11335720960 1908356624 18.893 98 29 58 0 1926274240 9857360 8060256
18:37:07 27316 8192000000 10863095520 11336134656 1928532592 19.055 99 38 76 1 1954215536 15129632 10553312
18:37:42 38822 8192000000 10873131696 11336777728 1885507088 18.710 97 27 55 1 1905374880 12780576 7087216
18:38:32 46916 8192000000 10878482368 11313164288 1873384480 18.612 98 24 48 0 1895844720 15815616 6644624
18:39:25 53373 8192000000 10863907552 11331100672 1906357408 18.877 99 32 64 0 1927898736 12823296 8718032
18:40:24 55084 8192000000 10856832224 11334524928 1859992256 18.503 96 15 30 2 1874435024 10067200 4375568
18:41:34 43202 8192000000 10864820624 11328524288 1899433408 18.822 98 18 36 1 1913403632 9348928 4621296
18:42:42 57866 8192000000 10892960976 11349569536 1927521072 19.047 99 17 34 2 1943790000 11541696 4727232
18:43:47 97744 8192000000 10847248784 11298992128 1856169136 18.472 95 39 78 2 1874632656 7402992 11060528
18:45:32 44215 8192000000 10862432368 11315367936 1926870512 19.042 100 46 92 0 1950015888 9890368 13255008
18:46:26 3983 8192000000 10861056688 11313856512 1928276528 19.053 100 44 88 0 1950382816 9772592 12333696
18:46:36 17500 8192000000 10852547184 11310002176 1925033056 19.027 100 32 64 1 1943811008 9724336 9053616
18:47:15 58966 8192000000 10848583584 11325718528 1935157200 19.108 100 13 26 0 1944890688 6373072 3360416
18:48:35 38018 8192000000 10846083712 11332562944 1917367776 18.966 99 6 12 0 1926491584 7290208 1833600
18:49:26 26494 8192000000 10854299552 11338596352 1939909408 19.146 100 7 15 0 1949120992 7692752 1518832
18:49:59 13690 8192000000 10858954928 11320647680 1933775408 19.097 100 36 70 3 1949356528 6690960 8890160
18:50:23 76835 8192000000 10857382080 11332079616 1886756208 18.720 97 17 34 0 1902911824 11322672 4832944
18:51:45 77920 8192000000 10857994912 11338579968 1917237248 18.965 99 9 18 0 1935706480 15601504 2867728
18:53:10 35145 8192000000 10877479568 11344941056 1946238704 19.197 100 43 86 3 1971903200 12544640 13119856
18:53:56 66416 8192000000 10871549280 11344560128 1891056800 18.754 97 18 36 0 1904600224 8307984 5235440
18:55:09 50746 8192000000 10870360848 11339063296 1927569696 19.047 99 20 40 1 1943655904 9229504 6856704
18:56:08 90706 8192000000 10887183056 11351965696 1903965712 18.858 97 37 74 0 1923292224 9059696 10266816
18:57:46 43437 8192000000 10898969296 11364634624 1960246448 19.308 100 21 42 1 1981452752 15986384 5219920
18:58:38 72285 8192000000 10895880912 11374366720 1967857008 19.368 100 17 34 1 1984493072 12035776 4600288
18:59:56 58962 8192000000 10911757600 11377397760 1954918704 19.266 99 15 31 0 1968504080 9880864 3704512
19:01:02 36249 8192000000 10942767776 11402141696 1985360832 19.507 100 36 72 1 2010596080 15304192 9931056
19:01:47 59305 8192000000 10914018032 11400396800 1966479056 19.358 99 11 22 0 1987657856 18256496 2922304
19:02:52 64796 8192000000 10913724912 11393998848 1961592192 19.319 99 12 24 0 1980897328 16145600 3159536
19:04:05 43845 8192000000 10901894896 11371151360 1921342288 18.998 97 12 24 1 1934914640 10461536 3110816
19:04:56 63661 8192000000 10898073376 11378855936 1958161296 19.291 99 28 56 1 1979562448 12910544 8490608
19:06:35 81542 8192000000 10915024592 11381825536 1977420224 19.444 100 44 88 1 1997745232 8089488 12235520
19:08:05 16721 8192000000 10887479392 11354181632 1930616736 19.072 98 27 55 1 1946765056 8587408 7560912
19:08:28 36309 8192000000 10871623968 11358683136 1927274176 19.045 98 13 26 2 1941562704 10731888 3556640
19:09:12 79788 8192000000 10887983232 11378409472 1942810752 19.169 99 10 20 0 1959290384 13580320 2899312
19:10:40 53972 8192000000 10858360304 11330838528 1889998864 18.746 96 12 24 0 1904198896 10451744 3748288
19:11:40 68756 8192000000 10859716000 11327365120 1895972384 18.794 97 16 30 1 1910483168 9502912 5007872
19:12:59 55472 8192000000 10869403248 11349704704 1940325360 19.149 100 18 35 2 1955236192 8965600 5945232
19:14:01 84468 8192000000 10848612848 11338625024 1868610976 18.573 96 21 42 0 1885905024 11188400 6105648
19:16:09 84000 8192000000 10841300960 11320360960 1876775168 18.639 97 9 18 0 1893619408 13954912 2889328
19:17:40 35362 8192000000 10856216608 11317207040 1896507312 18.798 98 29 58 0 1915519392 11032400 7979680
19:18:24 26687 8192000000 10875933648 11345960960 1938167280 19.132 100 30 59 2 1960208416 13069232 8971904
19:18:57 46388 8192000000 10848866752 11311267840 1831832128 18.274 94 27 54 2 1850070912 11040304 7198480
19:19:51 28297 8192000000 10876809008 11328716800 1910927488 18.914 99 54 107 0 1936460240 10611904 14920848
19:20:34 54806 8192000000 10868583232 11337789440 1926928272 19.042 100 26 53 0 1945407360 11400176 7078912
19:21:35 29956 8192000000 10866331344 11320127488 1895963536 18.794 98 38 75 1 1917083792 10762672 10357584
19:22:13 48117 8192000000 10840278624 11318648832 1897176896 18.804 99 33 66 2 1918894400 12434032 9283472
19:23:07 44936 8192000000 10846443312 11308343296 1841473216 18.353 96 12 22 2 1853490528 9182752 2834560
19:24:05 49652 8192000000 10829320032 11301384192 1851367728 18.433 97 27 54 0 1876804448 17970432 7466288
19:25:10 62488 8192000000 10863446896 11317948416 1879550448 18.661 98 31 62 0 1899097792 10817120 8730224
19:26:20 89286 8192000000 9885752448 10257768448 976124112 10.646 51 6 12 0 987733328 10282320 1326896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 13-06-2021 19:29:02 to 13-06-2021 19:29:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 85 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-06-2021 19:29:37 to 13-06-2021 19:29:39.

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          248938
MON$OLDEST_ACTIVE               249833
MON$OLDEST_SNAPSHOT             249833
MON$NEXT_TRANSACTION            249833
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                       2043680
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:95: 
:96: mscs-test-161.budzdorov.ru    Sun Jun 13 19:27:52 2021
:97:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:98: 
--- end of diff output ---

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

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