Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.01.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 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 17211172 kB
MemAvailable 31335780 kB
Buffers 0 kB
Cached 14513364 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-21 19:27:13
DTS_END                         2021-01-21 19:27:13.1470
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/47858
TRN_ID                          239093
ATT_ID                          691
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: 9368.20 24560 1124184
customer order: creation 170.83 352 20500
customer order: refuse 14.50 348 1740
order to supplier: creation 45.15 1396 5418
order to supplier: removal 3.50 91066 420
invoice (draft): creation 45.31 3417 5437
invoice (draft): removal 54.13 730 6496
invoice accept: apply 41.82 16946 5018
invoice accept: cancel 49.23 731 5908
customer reserve: creation 3806.94 170 456833
customer reserve: removal 4847.49 51 581699
realization accept: apply 81.01 180 9721
realization accept: cancel 81.18 110 9742
payment from customer: creation 59.01 114 7081
payment from customer: removal 5.67 67 680
payment to supplier: creation 47.75 124 5730
payment to supplier: removal 3.19 63 383
service: total inventory turnovers 4.57 1173 548
service: total monetary turnovers 6.03 32 723
service: aggregate perf. data 0.86 21826 103
service: refresh index statistics 0.03 352297 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-01-2021 19:29:09 to 21-01-2021 19:29:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6860
TEST_TIME 2 5929
TEST_TIME 3 6810
TEST_TIME 4 6373
TEST_TIME 5 6033
TEST_TIME 6 5606
TEST_TIME 7 5735
TEST_TIME 8 5870
TEST_TIME 9 5915
TEST_TIME 10 6175
TEST_TIME 11 6190
TEST_TIME 12 6103
TEST_TIME 13 6565
TEST_TIME 14 6579
TEST_TIME 15 6793
TEST_TIME 16 6968
TEST_TIME 17 7390
TEST_TIME 18 7804
TEST_TIME 19 8139
TEST_TIME 20 9431
TEST_TIME 21 9499
TEST_TIME 22 9392
TEST_TIME 23 9718
TEST_TIME 24 9944
TEST_TIME 25 10126
TEST_TIME 26 10647
TEST_TIME 27 10800
TEST_TIME 28 10688
TEST_TIME 29 10560
TEST_TIME 30 10740
TEST_TIME 31 10645
TEST_TIME 32 10516
TEST_TIME 33 10526
TEST_TIME 34 10627
TEST_TIME 35 10493
TEST_TIME 36 10266
TEST_TIME 37 10106
TEST_TIME 38 10054
TEST_TIME 39 9994
TEST_TIME 40 9944
TEST_TIME 41 9943
TEST_TIME 42 9825
TEST_TIME 43 9815
TEST_TIME 44 9802
TEST_TIME 45 9712
TEST_TIME 46 9602
TEST_TIME 47 9455
TEST_TIME 48 9502
TEST_TIME 49 9420
TEST_TIME 50 9368
TEST_TIME 51 9332
TEST_TIME 52 9274
TEST_TIME 53 9318
TEST_TIME 54 9410
TEST_TIME 55 9356
TEST_TIME 56 9395
TEST_TIME 57 9504
TEST_TIME 58 9531
TEST_TIME 59 9577
TEST_TIME 60 9647
TEST_TIME 61 9662
TEST_TIME 62 9662
TEST_TIME 63 9744
TEST_TIME 64 9784
TEST_TIME 65 9926
TEST_TIME 66 9908
TEST_TIME 67 9825
TEST_TIME 68 9781
TEST_TIME 69 9747
TEST_TIME 70 9669
TEST_TIME 71 9689
TEST_TIME 72 9716
TEST_TIME 73 9664
TEST_TIME 74 9607
TEST_TIME 75 9588
TEST_TIME 76 9563
TEST_TIME 77 9464
TEST_TIME 78 9492
TEST_TIME 79 9556
TEST_TIME 80 9557
TEST_TIME 81 9544
TEST_TIME 82 9685
TEST_TIME 83 9633
TEST_TIME 84 9685
TEST_TIME 85 9734
TEST_TIME 86 9709
TEST_TIME 87 9722
TEST_TIME 88 9825
TEST_TIME 89 9878
TEST_TIME 90 9821
TEST_TIME 91 9744
TEST_TIME 92 9714
TEST_TIME 93 9708
TEST_TIME 94 9670
TEST_TIME 95 9623
TEST_TIME 96 9601
TEST_TIME 97 9537
TEST_TIME 98 9538
TEST_TIME 99 9537
TEST_TIME 100 9531
TEST_TIME 101 9540
TEST_TIME 102 9571
TEST_TIME 103 9535
TEST_TIME 104 9527
TEST_TIME 105 9582
TEST_TIME 106 9621
TEST_TIME 107 9582
TEST_TIME 108 9667
TEST_TIME 109 9633
TEST_TIME 110 9656
TEST_TIME 111 9629
TEST_TIME 112 9624
TEST_TIME 113 9547
TEST_TIME 114 9553
TEST_TIME 115 9557
TEST_TIME 116 9509
TEST_TIME 117 9444
TEST_TIME 118 9432
TEST_TIME 119 9447
TEST_TIME 120 9377

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-01-2021 19:29:13 to 21-01-2021 19:29:16.

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 1547527 1547527 0 0.00 0 27519 6 0 0
doc_list_biud 1547527 1547527 0 0.00 0 34109 25 0 0
sp_add_invoice_to_stock 5138 5018 120 2.33 43 223307 16946 0 120
sp_cancel_adding_invoice 5908 5908 0 0.00 4 97399 732 0 0
sp_cancel_client_order 1740 1740 0 0.00 4 16671 348 0 0
sp_cancel_customer_reserve 581699 581699 0 0.00 1 22956 51 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 3 3155 68 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 2 2370 63 0 0
sp_cancel_supplier_invoice 6504 6496 8 0.12 2 33848 730 0 8
sp_cancel_supplier_order 420 420 0 0.00 8 991523 91066 0 0
sp_cancel_write_off 9742 9742 0 0.00 1 16501 110 0 0
sp_client_order 20500 20500 0 0.00 3 21676 353 0 0
sp_customer_reserve 456833 456833 0 0.00 0 54647 170 0 0
sp_fill_shopping_cart 31343 31343 0 0.00 1 12173 37 0 0
sp_fill_shopping_cart_clo_res 456833 456833 0 0.00 0 14586 12 0 0
sp_get_clo_for_invoice 5001 5001 0 0.00 0 24646 244 0 0
sp_kill_cost_storno 16713 16713 0 0.00 0 13226 54 0 0
sp_kill_qstorno_ret_qs2qd 1180056 1180056 0 0.00 0 33825 28 0 0
sp_kill_qty_storno 620727 620727 0 0.00 0 34097 61 0 0
sp_lock_selected_doc 20475 20475 0 0.00 0 6487 5 0 0
sp_make_cost_storno 27533 27533 0 0.00 0 11666 54 0 0
sp_multiply_rows_for_pdistr 27533 27533 0 0.00 0 7767 28 0 0
sp_multiply_rows_for_qdistr 20500 20500 0 0.00 0 17992 150 0 0
sp_pay_from_customer 7081 7081 0 0.00 4 12820 115 0 0
sp_pay_to_supplier 5730 5730 0 0.00 4 23971 124 0 0
sp_payment_common 12811 12811 0 0.00 1 23854 28 0 0
sp_qd_handle_on_cancel_clo 1740 1740 0 0.00 0 16648 321 0 0
sp_qd_handle_on_invoice_upd_sts 10909 10909 0 0.00 0 34077 319 0 0
sp_qd_handle_on_reserve_upd_sts 9721 9721 0 0.00 0 18038 65 0 0
sp_reserve_write_off 9721 9721 0 0.00 6 18081 181 0 0
sp_supplier_invoice 5437 5437 0 0.00 6 91752 3417 0 0
sp_supplier_order 5418 5418 0 0.00 5 41093 1396 0 0
srv_aggregate_perf_data 103 103 0 0.00 2493 608278 21827 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1664 143809 32079 0 0
srv_find_qd_qs_mism 1077196 1077196 0 0.00 0 27518 5 0 0
srv_make_invnt_saldo 548 548 0 0.00 50 69199 1173 0 0
srv_make_money_saldo 723 723 0 0.00 1 3445 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 233263 510861 352298 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5019 5019 0 0.00 0 21576 199 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 17819 132 0 0
t$perf-norm:sp_cancel_client_order 1740 1740 0 0.00 0 7329 19 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 9259 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 14083 39 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 6067 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 1694 14 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 32567 1669 0 0
t$perf-norm:sp_cancel_write_off 1012 1012 0 0.00 0 4174 11 0 0
t$perf-norm:sp_client_order 20500 20500 0 0.00 0 9476 20 0 0
t$perf-norm:sp_customer_reserve 945 945 0 0.00 0 12286 23 0 0
t$perf-norm:sp_pay_from_customer 7081 7081 0 0.00 0 16960 17 0 0
t$perf-norm:sp_pay_to_supplier 5730 5730 0 0.00 0 8530 13 0 0
t$perf-norm:sp_reserve_write_off 9721 9721 0 0.00 0 15570 13 0 0
t$perf-norm:sp_supplier_invoice 5437 5437 0 0.00 0 8873 24 0 0
t$perf-norm:sp_supplier_order 5418 5418 0 0.00 0 3461 13 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 283 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 2490 23 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 2319 22 0 0
t$perf-norm:srv_make_money_saldo 723 723 0 0.00 0 1158 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10238 9998 240 2.34 0 7140 20 0 240
v_all_customers 37460 37460 0 0.00 0 27 1 0 0
v_all_suppliers 29816 29816 0 0.00 0 16 1 0 0
v_all_wares 40998 40998 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 507 6 0 0
v_cancel_client_order 3480 3480 0 0.00 0 2817 5 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 484 4 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 2558 7 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 2217 8 0 0
v_cancel_supplier_invoice 804 788 16 1.99 0 2377 17 0 16
v_cancel_supplier_order 840 840 0 0.00 0 1303 5 0 0
v_cancel_write_off 2024 2024 0 0.00 0 2457 14 0 0
v_max_id_clo_ord 5417 5417 0 0.00 0 67 1 0 0
v_max_id_clo_res 945 945 0 0.00 0 2959 13 0 0
v_max_id_ord_sup 5427 5427 0 0.00 0 2538 4 0 0
v_max_non_paid_invoice 1666 1666 0 0.00 0 2407 4 0 0
v_max_non_paid_realizn 3748 3748 0 0.00 0 1912 4 0 0
v_min_id_clo_ord 5417 5417 0 0.00 0 5846 7 0 0
v_min_id_clo_res 945 945 0 0.00 0 2974 13 0 0
v_min_id_ord_sup 5427 5427 0 0.00 0 3447 4 0 0
v_min_non_paid_invoice 5730 5730 0 0.00 0 23848 17 0 0
v_min_non_paid_realizn 7081 7081 0 0.00 0 8608 19 0 0
v_our_firm 10204 10204 0 0.00 0 18 1 0 0
v_reserve_write_off 19440 19440 0 0.00 0 4740 6 0 0
x_lock_depdocs_on_canc_invoice 12010 12010 0 0.00 0 20591 109 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 10845 350 0 0
x_make_qstorno_1000_1200 5418 5418 0 0.00 2 41074 1313 0 0
x_make_qstorno_1200_2000 5437 5437 0 0.00 3 91742 3293 0 0
x_make_qstorno_2100_3300 456833 456833 0 0.00 0 54645 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-01-2021 19:29:17 to 21-01-2021 19:29:21.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:23 18955 8192000000 10251976624 10559156224 884282944 9.742 70 53 110 0 904450896 2491200 17676752
16:57:53 27744 8192000000 10334816144 10648051712 1374380464 14.366 100 86 172 1 1407101840 4413376 28308000
16:58:32 24443 8192000000 10368337168 10688237568 1419551056 14.769 100 87 175 0 1453831952 5900080 28380816
16:59:11 22293 8192000000 10402153888 10728443904 1453480400 15.069 100 82 166 1 1487243984 6962240 26801344
16:59:41 15836 8192000000 10425187776 10753716224 1481129568 15.311 100 90 180 0 1517533824 7683344 28720912
17:00:15 18745 8192000000 10443468672 10778501120 1498660096 15.464 100 84 167 1 1533860928 8434576 26766256
17:00:46 17588 8192000000 10458592096 10796503040 1518809792 15.640 100 81 162 0 1553757200 9034592 25912816
17:01:17 13130 8192000000 10479994368 10821287936 1533869152 15.771 100 82 164 2 1569318128 9472128 25976848
17:01:42 14709 8192000000 10508129648 10855931904 1567344496 16.059 100 83 166 1 1603393072 9892816 26155760
17:02:05 17338 8192000000 10535451056 10888671232 1591918944 16.270 100 85 170 0 1628798656 10637872 26241840
17:02:36 17537 8192000000 10574629728 10934243328 1625549760 16.557 100 82 163 1 1661569712 11453296 24566656
17:03:03 6744 8192000000 10587420992 10947563520 1649551136 16.761 100 84 166 1 1686531904 11901568 25079200
17:03:19 12335 8192000000 10610117312 10972491776 1670443760 16.937 100 82 164 1 1707314608 12350688 24520160
17:03:42 10416 8192000000 10629420000 10993819648 1684464432 17.055 100 90 180 1 1723616352 12644080 26507840
17:04:02 8535 8192000000 10641594496 11009912832 1701531520 17.198 100 87 175 3 1740889216 13588976 25768720
17:04:24 6409 8192000000 10660379792 11029880832 1720579712 17.357 100 87 173 3 1759153040 13695632 24877696
17:04:38 5855 8192000000 10677713264 11048427520 1728338048 17.422 100 85 170 0 1766409872 14268864 23802960
17:04:52 6263 8192000000 10681051120 11054292992 1742347552 17.538 100 83 164 2 1779789040 14435024 23006464
17:05:05 5527 8192000000 10690908544 11069661184 1751126272 17.611 100 76 152 0 1785549504 13639536 20783696
17:05:17 4810 8192000000 10702204336 11078205440 1758615664 17.673 100 82 163 1 1794838432 13169504 23053264
17:05:29 4891 8192000000 10709982640 11087478784 1766443072 17.738 100 80 159 1 1800918576 12625424 21850080
17:05:41 3786 8192000000 10725284336 11102420992 1783182432 17.876 100 88 177 2 1822107248 13079088 25845728
17:05:51 3314 8192000000 10716679776 11102162944 1787013984 17.907 100 80 159 3 1822497664 13516048 21967632
17:06:01 3012 8192000000 10736039872 11114061824 1792626224 17.953 100 84 168 0 1828962912 12542896 23793792
17:06:11 2784 8192000000 10743910544 11122663424 1798711824 18.003 100 87 173 0 1836782128 14235408 23834896
17:06:21 2069 8192000000 10754980032 11133005824 1807904896 18.079 100 92 182 1 1847963936 14453872 25605168
17:06:29 3851 8192000000 10756285808 11136610304 1808513136 18.084 100 84 168 3 1846143520 14248880 23381504
17:06:40 2267 8192000000 10760849728 11141529600 1819196000 18.171 100 91 181 0 1858508128 14990064 24322064
17:06:48 2762 8192000000 10765385312 11147628544 1826435888 18.230 100 87 175 1 1865013680 15042656 23535136
17:06:57 4639 8192000000 10772091296 11154833408 1827388032 18.238 100 80 160 0 1863364592 14728176 21248384
17:07:09 4627 8192000000 10772805840 11161145344 1830489920 18.263 100 83 166 1 1866781504 13724688 22566896
17:07:19 1581 8192000000 10788178336 11175157760 1845075216 18.382 100 94 190 0 1886387984 14480048 26832720
17:07:27 1823 8192000000 10796719488 11181780992 1852862512 18.445 100 89 178 2 1892672736 14337072 25473152
17:07:35 2040 8192000000 10799646640 11186556928 1854887488 18.462 100 96 191 2 1895335648 13256624 27191536
17:07:44 1942 8192000000 10802183648 11188473856 1860613040 18.508 100 98 196 1 1900495440 12668224 27214176
17:07:52 1250 8192000000 10812069120 11200061440 1864375328 18.539 100 96 192 2 1904174960 12923632 26876000
17:07:59 1577 8192000000 10813990000 11200540672 1867321584 18.563 100 95 189 1 1907309040 14087664 25899792
17:08:07 1696 8192000000 10813469232 11201540096 1869487264 18.580 100 94 189 0 1910501648 13873984 27140400
17:08:15 1577 8192000000 10816581376 11204554752 1870055264 18.585 100 95 190 1 1912655824 15330944 27269616
17:08:23 2125 8192000000 10818366224 11209469952 1876424816 18.636 100 91 182 2 1916494816 14058144 26011856
17:08:31 1545 8192000000 10821458000 11214082048 1880759968 18.671 100 94 189 2 1920099984 12792768 26547248
17:08:39 1542 8192000000 10826013376 11218419712 1882843872 18.688 100 91 178 0 1921266224 13697984 24724368
17:08:47 54807 8192000000 10804357824 11212050432 1871005392 18.592 100 37 74 0 1888882816 7575184 10302240
17:09:48 12438 8192000000 10802901648 11219058688 1883373056 18.692 100 74 148 0 1914966416 10571344 21022016
17:10:14 7363 8192000000 10781900944 11215933440 1879713424 18.663 100 32 64 0 1895242208 7063376 8465408
17:10:29 8983 8192000000 10803938352 11221643264 1882398512 18.684 100 31 58 1 1897442592 6107744 8936336
17:10:46 6574 8192000000 10793410704 11229265920 1883024704 18.690 100 29 56 2 1902557568 11587568 7945296
17:10:59 7824 8192000000 10796654272 11227140096 1885461456 18.709 100 29 56 0 1901044032 7724736 7857840
17:11:15 6288 8192000000 10805772368 11232489472 1887990688 18.730 100 29 56 2 1902370880 6387760 7992432
17:11:28 12344 8192000000 10801756048 11235045376 1890290480 18.748 100 19 39 2 1901620112 5502144 5827488
17:11:48 6765 8192000000 10807850000 11239305216 1896982976 18.802 100 21 42 0 1909019712 6535168 5501568
17:12:04 9836 8192000000 10808012832 11243360256 1898870912 18.817 100 19 38 1 1910643520 6321904 5450704
17:12:29 14640 8192000000 10811144080 11247054848 1901185904 18.836 100 18 35 2 1911643184 4961696 5495584
17:12:51 10239 8192000000 10813762752 11249291264 1903167936 18.852 100 18 35 2 1914682688 5696336 5818416
17:13:11 6697 8192000000 10803917920 11245506560 1902561024 18.847 100 15 30 1 1912777248 6100448 4115776
17:13:28 17151 8192000000 10811771168 11246493696 1902948816 18.850 100 16 32 1 1913144736 5939872 4256048
17:13:57 10354 8192000000 10805098384 11248775168 1904793216 18.865 100 19 38 5 1916126832 6290384 5043232
17:14:15 12817 8192000000 10821158064 11251621888 1888535360 18.734 99 23 46 1 1900891088 5533152 6822576
17:14:34 72860 8192000000 10774662912 11207114752 1821165072 18.187 96 27 55 0 1834757424 5839296 7753056
17:15:53 3268 8192000000 10796350784 11224260608 1865975584 18.552 99 36 71 4 1882762688 6894288 9892816
17:16:04 5229 8192000000 10805122112 11231625216 1881819328 18.680 100 16 33 3 1891299856 5296816 4183712
17:16:17 6669 8192000000 10803738832 11239866368 1894597888 18.783 100 25 50 2 1908329296 6312288 7419120
17:16:31 9875 8192000000 10799876848 11237281792 1873906416 18.616 99 20 39 0 1885072944 6021744 5144784
17:16:47 3767 8192000000 10819224352 11244363776 1895159120 18.787 100 40 80 1 1913684144 7316208 11208816
17:17:00 6653 8192000000 10813440432 11245953024 1897402960 18.805 100 26 52 1 1911611712 6828064 7380688
17:17:15 6989 8192000000 10770528480 11193577472 1852634688 18.444 98 17 34 0 1862913168 5650128 4628352
17:17:32 6084 8192000000 10785181200 11218599936 1858639824 18.492 99 24 48 1 1871675104 6133072 6902208
17:17:44 10464 8192000000 10773826160 11202981888 1829908608 18.259 98 13 26 0 1839010160 5607008 3494544
17:18:02 8698 8192000000 10773508896 11207741440 1865321360 18.546 100 12 24 1 1874627296 5410048 3895888
17:18:18 9966 8192000000 10754500624 11187761152 1794037664 17.965 96 23 47 0 1805593904 5306064 6250176
17:18:36 10728 8192000000 10746340576 11176992768 1753204016 17.628 94 14 27 1 1762429584 5445184 3780384
17:18:56 7598 8192000000 10736952848 11161677824 1810949760 18.104 99 19 38 1 1822513568 6470608 5093200
17:19:10 15191 8192000000 10721206160 11128832000 1706366752 17.238 93 28 52 2 1718792144 4554880 7870512
17:19:32 81984 8192000000 10699149232 11119579136 1612064624 16.442 88 32 62 0 1625665120 5338848 8261648
17:21:00 9676 8192000000 10737152112 11145568256 1780432480 17.853 98 39 77 3 1797960256 6343760 11184016
17:21:18 7628 8192000000 10673999648 11089899520 1709625296 17.266 95 33 66 1 1725487312 5008928 10853088
17:21:33 8501 8192000000 10680865776 11096408064 1756997248 17.660 98 22 44 0 1768863984 5970352 5896384
17:21:48 6674 8192000000 10728015776 11138314240 1777893248 17.832 99 19 38 1 1792943552 9946688 5103616
17:22:01 4064 8192000000 10753921280 11159801856 1819600592 18.174 100 41 84 2 1837298352 5702928 11994832
17:22:15 6266 8192000000 10713215168 11129106432 1784527408 17.887 98 16 32 1 1794607520 5619168 4460944
17:22:27 11671 8192000000 10721711360 11137724416 1775447584 17.812 98 17 33 3 1786219200 5809696 4961920
17:22:47 8900 8192000000 10736289904 11143073792 1800332048 18.017 99 25 49 2 1812748944 5148288 7268608
17:23:06 9023 8192000000 10719160016 11141971968 1810860336 18.103 100 25 50 0 1823492048 5387472 7244240
17:23:22 9285 8192000000 10747554192 11167215616 1831489664 18.271 100 34 63 3 1846037200 5290096 9257440
17:23:40 10365 8192000000 10746665024 11175731200 1832795040 18.282 100 21 41 2 1843766256 5069552 5901664
17:23:57 7692 8192000000 10758438400 11180789760 1843929792 18.373 100 23 44 2 1856035008 5006384 7098832
17:24:13 15713 8192000000 10767556688 11190648832 1851501136 18.434 100 21 39 2 1863569520 5722912 6345472
17:24:37 70102 8192000000 10780164896 11206348800 1863579920 18.532 100 39 76 1 1880534368 5371840 11582608
17:25:56 8631 8192000000 10780145664 11210514432 1868452496 18.572 100 22 44 0 1880538768 5386224 6700048
17:26:10 9032 8192000000 10785119120 11214356480 1871744528 18.598 100 22 44 1 1883451904 5528176 6179200
17:26:26 10318 8192000000 10792864560 11222536192 1875560384 18.629 100 23 46 0 1887740320 5108976 7070960
17:26:42 6538 8192000000 10783841536 11222609920 1881241920 18.675 100 17 34 0 1891513536 5631840 4639776
17:26:55 7005 8192000000 10798331200 11228332032 1883165248 18.691 100 23 47 0 1895821104 5606368 7049488
17:27:10 10359 8192000000 10817423424 11246415872 1899830320 18.825 100 21 42 1 1910733520 5434976 5468224
17:27:30 23364 8192000000 10842718304 11261444096 1913591232 18.935 100 43 86 1 1931453344 5450672 12411440
17:28:10 7615 8192000000 10859761040 11273420800 1923119168 19.012 100 49 98 1 1947076416 9440192 14517056
17:28:27 33107 8192000000 10867095840 11288383488 1931315824 19.077 100 56 112 4 1958674224 11511616 15846784
17:29:08 17332 8192000000 10868884656 11288104960 1917756176 18.969 99 45 88 2 1941635472 11456416 12422880
17:29:36 28126 8192000000 10860692832 11293290496 1936041856 19.115 100 46 90 2 1961805744 12545200 13218688
17:30:12 40908 8192000000 10879994336 11305689088 1927224384 19.045 99 28 56 1 1948871776 13260240 8387152
17:31:00 30968 8192000000 10895396176 11321716736 1949808944 19.225 100 47 93 0 1976159488 13622432 12728112
17:31:39 2867 8192000000 10909691920 11331481600 1960553888 19.310 100 65 129 0 1997008800 17997632 18457280
17:31:54 32617 8192000000 10912647248 11337867264 1966393280 19.357 100 61 122 2 2002348464 18721600 17233584
17:32:35 13980 8192000000 10915077072 11344097280 1970351168 19.388 100 56 112 0 2004800560 18576224 15873168
17:33:06 11249 8192000000 10909240320 11339051008 1958881184 19.297 99 64 125 5 1995486784 19576128 17029472
17:33:33 8061 8192000000 10918754656 11340718080 1970480528 19.389 100 58 110 2 2009520208 23351552 15688128
17:33:52 17178 8192000000 10938502080 11364028416 1982199088 19.482 100 56 110 1 2021882960 23768000 15915872
17:34:17 9464 8192000000 10932854720 11362050048 1983063680 19.489 100 54 107 2 2022162608 23825392 15273536
17:34:34 3874 8192000000 10950822240 11371565056 1991557072 19.556 100 58 113 1 2033354544 25657008 16140464
17:34:45 2879 8192000000 10949007584 11371814912 1992579744 19.564 100 62 124 0 2037399952 26478480 18341728
17:34:55 4888 8192000000 10952817808 11374022656 1990434960 19.547 100 72 141 2 2038680080 27550464 20694656
17:35:08 7190 8192000000 10948156384 11372642304 1994411904 19.579 100 61 122 1 2040629824 28480512 17737408
17:35:23 1663 8192000000 10954888656 11375988736 1997552896 19.603 100 77 155 1 2047492656 27612416 22327344
17:35:35 5042 8192000000 10960238912 11383402496 1999461840 19.618 100 63 126 0 2046618704 28669920 18486944
17:35:47 2920 8192000000 10965458624 11385655296 2003266832 19.648 100 69 134 0 2051679856 29185616 19227408
17:35:58 3090 8192000000 10960764496 11384582144 2002232768 19.640 100 78 155 1 2055569872 29402640 23934464
17:36:13 11820 8192000000 10963229104 11388129280 2004281472 19.656 100 71 137 2 2054856208 30291888 20282848
17:36:33 10713 8192000000 10963878816 11390562304 2008089776 19.686 100 68 137 0 2058651808 30107968 20454064
17:36:51 4257 8192000000 10965391104 11392372736 2009937776 19.701 100 66 132 0 2060305840 31124624 19243440
17:37:02 8775 8192000000 10969491552 11395682304 1992807120 19.566 99 63 125 0 2043410096 31181040 19421936
17:37:17 4990 8192000000 10986436832 11404869632 2012347696 19.720 100 69 138 0 2065721696 31987808 21386192
17:37:30 5218 8192000000 10987627568 11411292160 2017492864 19.760 100 72 143 1 2072049440 33001792 21554784
17:37:43 2745 8192000000 10986422784 11412729856 2019064720 19.773 100 73 144 3 2076994672 36555072 21374880
17:37:55 9518 8192000000 10957999408 11388432384 1987803280 19.526 99 60 120 1 2037172512 31360352 18008880
17:38:12 5487 8192000000 10966172320 11390660608 2004289408 19.657 100 60 119 1 2052509168 30452944 17766816
17:38:25 5396 8192000000 10971410640 11395969024 2011725488 19.715 100 70 138 0 2063146464 31353056 20067920
17:38:38 6607 8192000000 10970584704 11396505600 2004617696 19.659 100 63 127 2 2056406784 32840560 18948528
17:38:54 3498 8192000000 10941788688 11372089344 1984999168 19.504 99 62 124 1 2036141008 32531872 18609968
17:39:08 7009 8192000000 10972105312 11393941504 2001286400 19.633 100 62 124 2 2052629952 32906304 18437248
17:39:22 4599 8192000000 10979584576 11402063872 2007728736 19.684 100 71 142 1 2064664864 35505168 21430960
17:39:34 3698 8192000000 10982126384 11408551936 2011302336 19.712 100 67 133 1 2067911328 36565936 20043056
17:39:45 6479 8192000000 10982768944 11405815808 1994709072 19.581 99 74 145 3 2053543856 36528352 22306432
17:40:00 2702 8192000000 10961631904 11380776960 1988044304 19.528 99 66 130 1 2045232816 38020784 19167728
17:40:11 3185 8192000000 10984060640 11401895936 2005055648 19.663 100 73 146 0 2065716816 38557584 22103584
17:40:21 2902 8192000000 10971756432 11397615616 2002347888 19.641 100 76 151 1 2068865104 42882016 23635200
17:40:31 9509 8192000000 10981474832 11411615744 2007675072 19.683 100 61 122 1 2067204528 40267488 19261968
17:40:48 2951 8192000000 10969122304 11399421952 2002968176 19.646 100 51 102 1 2054997696 36197648 15831872
17:40:58 15057 8192000000 10975517712 11408236544 2012269376 19.719 100 55 110 1 2067345968 36721408 18355184
17:41:27 4675 8192000000 11000049488 11427864576 2019600464 19.777 100 60 120 0 2078844944 40581904 18662576
17:41:39 5725 8192000000 10962196832 11388846080 1986379328 19.515 99 68 136 1 2052207632 44921312 20906992
17:42:00 5182 8192000000 10980082800 11404726272 1996168640 19.593 100 65 129 0 2062086288 45559584 20358064
17:42:16 3440 8192000000 10961685616 11384778752 1978924704 19.456 99 74 146 4 2042645456 40886944 22833808
17:42:29 4662 8192000000 10969101456 11391016960 1991089632 19.552 100 73 146 0 2056834240 42513232 23231376
17:42:43 3192 8192000000 10991090944 11406753792 2002055808 19.639 100 75 151 2 2069296512 43914912 23325792
17:42:58 3735 8192000000 10963074304 11383549952 1965327520 19.348 98 63 124 1 2029851984 44916480 19607984
17:43:09 2427 8192000000 10950408144 11370926080 1956344048 19.277 99 66 130 1 2020465440 42960352 21161040
17:43:19 4942 8192000000 10960140144 11380547584 1979878672 19.464 100 75 151 0 2047724208 43785232 24060304
17:43:35 4276 8192000000 10970746624 11386961920 1983252848 19.490 100 68 135 0 2051697152 46588224 21856080
17:43:47 1677 8192000000 10973721136 11380600832 1979301136 19.459 100 86 173 3 2050806720 45194672 26310912
17:43:56 5902 8192000000 10951440592 11362611200 1947526112 19.207 98 79 155 1 2018605184 47154256 23924816
17:44:10 2807 8192000000 10962511632 11368423424 1964584528 19.342 99 82 164 3 2038284944 48307392 25393024
17:44:19 2839 8192000000 10977472592 11384020992 1977232912 19.443 100 88 176 1 2055004656 50311824 27459920
17:44:29 4220 8192000000 10965163760 11390701568 1979688224 19.462 100 65 130 0 2050649232 50091600 20869408
17:44:55 9287 8192000000 10948882480 11378073600 1949347472 19.221 99 50 97 2 2014094448 47999472 16747504
17:45:11 15049 8192000000 10952848992 11385868288 1970148160 19.387 100 37 74 2 2030498560 47890928 12459472
17:45:34 8543 8192000000 10970936208 11393740800 1976057696 19.433 100 57 114 0 2041960464 46778320 19124448
17:45:50 6718 8192000000 10982689728 11410403328 1992700912 19.565 100 56 112 2 2061251744 50054256 18496576
17:46:04 2801 8192000000 10995649280 11416768512 1996786000 19.597 100 79 158 0 2073088224 51340512 24961712
17:46:14 4901 8192000000 10999545280 11414806528 1990453632 19.547 100 85 171 1 2073608176 55863216 27291328
17:46:25 2455 8192000000 10989586592 11402678272 1980399760 19.468 100 87 169 2 2066515840 58384480 27731600
17:46:35 8560 8192000000 10955929264 11397996544 1975815872 19.432 100 50 101 1 2051339056 58114912 17408272
17:46:49 16165 8192000000 10957517056 11390828544 1953334368 19.253 99 42 84 3 2023307216 55492416 14480432
17:47:13 13383 8192000000 10933250384 11376414720 1945280224 19.189 99 34 67 0 2008304400 50702864 12321312
17:47:36 12267 8192000000 10949735264 11403243520 1971145808 19.395 100 35 70 2 2038912976 55569440 12197728
17:48:05 8257 8192000000 10920220496 11361669120 1950780768 19.233 99 32 64 4 1992854144 31772496 10300880
17:48:21 10969 8192000000 10935366128 11381223424 1972806368 19.408 100 30 60 1 2016183152 33686928 9689856
17:48:47 15826 8192000000 10920300240 11371130880 1936299312 19.117 98 25 50 1 1979059104 34649488 8110304
17:49:24 16304 8192000000 10906664144 11351339008 1926381136 19.038 98 24 48 1 1967943632 34360432 7202064
17:49:48 16336 8192000000 10908730192 11351515136 1936158720 19.116 99 41 80 3 1986015696 36435376 13421600
17:50:13 14017 8192000000 10929429904 11380248576 1961585008 19.319 100 36 71 1 2013541280 39908592 12047680
17:50:39 28456 8192000000 10926158768 11394134016 1968811040 19.376 100 26 52 1 2019518544 41230880 9476624
17:51:15 25070 8192000000 10907757568 11355140096 1932700848 19.088 99 17 34 0 1972939712 34225648 6013216
17:51:50 27584 8192000000 10921590704 11363565568 1954548304 19.263 100 26 52 2 1995063872 31791920 8723648
17:52:26 30292 8192000000 10918334816 11380350976 1959798928 19.304 100 23 46 4 2002695120 35308784 7587408
17:53:02 40266 8192000000 10897422144 11367137280 1941226016 19.157 99 11 22 0 1977625568 32351824 4047728
17:53:53 41611 8192000000 10860048544 11338420224 1886462608 18.717 97 10 20 0 1910852832 21116896 3273328
17:54:43 46341 8192000000 10868902000 11337084928 1936126944 19.116 100 10 20 0 1956026384 17256192 2643248
17:55:36 16808 8192000000 10870670976 11298447360 1888135360 18.731 97 52 104 3 1914490400 10787392 15567648
17:56:09 52511 8192000000 10848355152 11304054784 1877283648 18.643 97 30 55 2 1899376016 14973168 7119200
17:57:08 46227 8192000000 10868002848 11317649408 1913627904 18.936 99 7 12 0 1931737376 16451040 1658432
17:58:05 44072 8192000000 10875620896 11325284352 1915055216 18.947 98 21 42 1 1932082896 11157552 5870128
17:59:07 66721 8192000000 10890452320 11327336448 1917840096 18.970 98 39 78 1 1941043648 10895584 12307968
18:00:31 135896 8192000000 10878428976 11337805824 1884861168 18.704 97 9 18 0 1902050400 15162000 2027232
18:03:06 104316 8192000000 10901626576 11357392896 1970276576 19.388 100 37 73 0 1989133856 7644624 11212656
18:04:58 15006 8192000000 10899752480 11355336704 1970526592 19.390 100 28 56 5 1986230784 8197968 7506224
18:05:22 16556 8192000000 10919597152 11366051840 1980536944 19.469 100 36 73 0 2001139648 10360976 10241728
18:05:46 11953 8192000000 10886547968 11354079232 1952277520 19.245 99 15 30 0 1966974448 10322608 4374320
18:06:07 15575 8192000000 10884421280 11352961024 1946832416 19.201 99 10 20 1 1959227376 9715248 2679712
18:06:31 25257 8192000000 10876294496 11349053440 1944026688 19.179 99 13 26 1 1959705264 11744800 3933776
18:07:06 32145 8192000000 10899301248 11362365440 1968063104 19.370 100 27 54 1 1985998304 10040976 7894224
18:07:45 23090 8192000000 10884043264 11355455488 1948407792 19.214 99 16 33 0 1965730000 12432832 4889376
18:08:14 48172 8192000000 10889316896 11346124800 1929471920 19.063 98 13 25 0 1939407456 6433504 3502032
18:09:09 50359 8192000000 10888513456 11333836800 1928878016 19.058 98 29 55 3 1943803520 7193248 7732256
18:10:05 33247 8192000000 10876051552 11341385728 1944541504 19.183 99 19 38 1 1959422512 9093264 5787744
18:10:45 32773 8192000000 10882768400 11354292224 1964621232 19.343 100 6 11 0 1975123488 8934784 1567472
18:11:26 43875 8192000000 10879892080 11351769088 1948866352 19.217 99 11 22 0 1958808176 7152928 2788896
18:12:23 71862 8192000000 10893791168 11354779648 1951624128 19.239 99 16 32 0 1962580096 6262736 4693232
18:13:41 97324 8192000000 10891790192 11364069376 1957206944 19.284 99 22 44 1 1971654720 7673904 6773872
18:15:35 60772 8192000000 10892698416 11372548096 1975101936 19.426 100 22 44 0 1997696832 15198896 7396000
18:16:42 2104 8192000000 10893586464 11373019136 1973778144 19.415 100 12 24 0 1989737088 12811216 3147728
18:16:51 8338 8192000000 10897774848 11365609472 1980299440 19.467 100 27 48 4 1994890208 8019104 6571664
18:17:10 23916 8192000000 10921101648 11385909248 1992175504 19.561 100 35 71 2 2013261664 10889200 10196960
18:17:44 34198 8192000000 10905800736 11376680960 1972988240 19.409 99 15 30 0 1989079600 11891536 4199824
18:18:26 71388 8192000000 10894120112 11372023808 1946186352 19.196 98 17 34 0 1966043264 14502480 5354432
18:20:30 47059 8192000000 10902805392 11376840704 1979171872 19.458 100 8 16 0 1992528112 11257120 2099120
18:21:23 39982 8192000000 10896838048 11370479616 1953814288 19.257 99 17 33 2 1969251456 10272448 5164720
18:22:11 37048 8192000000 10926290192 11380404224 1967879168 19.369 99 35 70 1 1991592608 14197632 9515808
18:22:54 11246 8192000000 10937394176 11395018752 1989253856 19.538 100 41 82 3 2024495392 23430400 11811136
18:23:13 30028 8192000000 10903516080 11358441472 1920435488 18.990 97 29 59 1 1945600160 16824896 8339776
18:24:07 59898 8192000000 10914548064 11395948544 1975585616 19.430 100 19 38 0 2001219840 19918096 5716128
18:25:13 87587 8192000000 10897950256 11368423424 1894167520 18.779 96 15 30 0 1917147408 18943184 4036704
18:26:54 50115 8192000000 10863656416 11330019328 1858243600 18.489 95 19 38 1 1874863168 11642704 4976864
18:27:54 40070 8192000000 10888291488 11335671808 1889923776 18.745 97 23 46 1 1916822208 20927072 5971360
18:28:40 60887 8192000000 10896280064 11349303296 1902412608 18.846 97 27 54 1 1928436032 17604048 8419376
18:29:47 79193 8192000000 10893150064 11362975744 1911268832 18.917 98 5 10 0 1929390544 16626816 1494896
18:31:12 71618 8192000000 10904754256 11368890368 1934571152 19.103 98 16 32 0 1958244704 19579408 4094144
18:32:30 54362 8192000000 10849321424 11317702656 1848986544 18.414 95 8 16 0 1869499232 18245424 2267264
18:33:49 47235 8192000000 10862015408 11309666304 1880370368 18.668 97 28 56 0 1897713680 9418640 7924672
18:34:43 107017 8192000000 10855803056 11323113472 1902258496 18.844 98 24 48 1 1919031136 9874080 6898560
18:36:55 34068 8192000000 10875311632 11320659968 1897374672 18.805 97 31 62 1 1915987280 9694048 8918560
18:37:36 28003 8192000000 10890644048 11339542528 1926626480 19.040 99 30 59 0 1945975904 11309088 8040336
18:38:10 11613 8192000000 10894490048 11337269248 1946902960 19.202 100 55 111 2 1976314304 13396784 16014560
18:39:48 38503 8192000000 10858499216 11340419072 1933579504 19.095 100 8 16 0 1952317488 16575504 2162480
18:40:33 38746 8192000000 10838961744 11305701376 1894657712 18.783 98 12 24 0 1909199312 10951424 3590176
18:41:27 53134 8192000000 10857386176 11327148032 1894294192 18.780 98 20 40 0 1914187712 13986880 5906640
18:42:28 67391 8192000000 10874994784 11343568896 1946464272 19.198 100 16 32 0 1961103120 9906688 4732160
18:43:42 67030 8192000000 10831664080 11304435712 1865810848 18.550 96 13 26 0 1879227920 9677520 3739552
18:45:06 65820 8192000000 10867335488 11345367040 1882488848 18.685 98 6 12 1 1899707120 15882352 1335920
18:46:21 55139 8192000000 10873849808 11351244800 1940300672 19.149 100 18 36 1 1963723920 18006336 5416912
18:47:41 53508 8192000000 10892069040 11358998528 1953924928 19.258 100 13 26 0 1970287808 12603104 3759776
18:48:41 33910 8192000000 10903958752 11360514048 1945249216 19.189 99 25 50 0 1964915232 11776064 7889952
18:49:21 27777 8192000000 10869227408 11361566720 1936821984 19.121 99 18 36 0 1960836016 18369840 5644192
18:49:59 95068 8192000000 10886332736 11355508736 1876665648 18.638 96 13 26 0 1893534368 12796640 4072080
18:51:42 57445 8192000000 10865109872 11345633280 1917667376 18.968 98 16 32 0 1934077168 12021232 4388560
18:52:49 39755 8192000000 10899824224 11361382400 1961268112 19.316 100 21 42 1 1979112048 11163984 6679952
18:53:34 46394 8192000000 10894392912 11367088128 1946160560 19.196 99 19 38 2 1968804016 16916752 5726704
18:54:32 43730 8192000000 10921339600 11379474432 1960059936 19.307 100 39 78 2 1988598800 16211856 12327008
18:55:27 124504 8192000000 10900866032 11367186432 1910182208 18.908 97 13 26 0 1934592960 20342160 4068592
18:57:47 110795 8192000000 10909991408 11372814336 1986611008 19.517 100 46 91 0 2008446272 9338048 12497216
18:59:44 39887 8192000000 10896914672 11345162240 1931633712 19.080 98 50 100 1 1954836992 9818480 13384800
19:01:39 58274 8192000000 10884344000 11373338624 1969655088 19.383 100 10 20 2 1983593104 11207168 2730848
19:02:44 69214 8192000000 10898230480 11375857664 1957297088 19.285 99 18 36 0 1973787168 11080736 5409344
19:04:00 90401 8192000000 10917056512 11406888960 1992409552 19.563 100 14 28 1 2016876352 19817744 4649056
19:06:54 46876 8192000000 10894329328 11371040768 1949592944 19.223 98 22 44 0 1968754176 12982912 6178320
19:07:47 111197 8192000000 10877597392 11358560256 1906697792 18.880 96 10 21 0 1924691040 14629344 3363904
19:09:54 32359 8192000000 10918065952 11381268480 1979638016 19.462 100 26 52 1 1993366320 6459552 7268752
19:10:32 37804 8192000000 10916660512 11383263232 1966081776 19.354 99 23 46 1 1982442048 9966624 6393648
19:11:16 37373 8192000000 10925811232 11378233344 1944987296 19.187 98 55 109 1 1972640864 12001952 15651616
19:12:01 53584 8192000000 10894167184 11378434048 1953012976 19.250 99 27 53 1 1971212624 10886768 7312880
19:13:01 143808 8192000000 10902518416 11383500800 1836257664 18.310 93 13 26 0 1858583600 18734896 3591040
19:16:01 71066 8192000000 10876594992 11328741376 1847094768 18.399 94 28 56 4 1863962288 9721568 7145952
19:17:21 60738 8192000000 10862750592 11341537280 1862910096 18.527 96 26 52 0 1889633824 19616704 7107024
19:18:28 71748 8192000000 10860033760 11325952000 1873181248 18.610 97 17 34 0 1893034640 15204720 4648672
19:19:46 113930 8192000000 10846428672 11324346368 1877838848 18.648 97 30 60 2 1899267696 12992368 8436480
19:21:54 45767 8192000000 10845105376 11325784064 1892652864 18.767 98 21 42 0 1910781456 11758576 6370016
19:23:10 45323 8192000000 10848991312 11336818688 1932262112 19.085 100 10 20 0 1943990480 8875728 2852640
19:24:34 23060 8192000000 10835276608 11318284288 1916808448 18.961 99 9 18 0 1929506800 10311808 2386544
19:25:34 103278 8192000000 10573155824 11033481216 1631836688 16.610 84 13 26 0 1648381232 12459008 4085536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-01-2021 19:29:23 to 21-01-2021 19:29:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-01-2021 19:29:55 to 21-01-2021 19:29:57.

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          238859
MON$OLDEST_ACTIVE               239349
MON$OLDEST_SNAPSHOT             239349
MON$NEXT_TRANSACTION            239349
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                       2031072
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:187: 
:188: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:25 2021
:189:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:190: 
:191: 
:192: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:30 2021
:193:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:194: 
:195: 
:196: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:33 2021
:197:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:198: 
:199: 
:200: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:33 2021
:201:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:202: 
:203: 
:204: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:38 2021
:205:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:206: 
:207: 
:208: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:38 2021
:209:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:210: 
:211: 
:212: mscs-test-161.budzdorov.ru    Thu Jan 21 19:27:38 2021
:213:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:214: 
--- end of diff output ---

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

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