Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.04.2021 16:32
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17342840 kB
MemAvailable 31426492 kB
Buffers 0 kB
Cached 14285272 kB
SwapCached 0 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-04-01 16:32:15
DTS_END                         2021-04-01 16:32:15.2930
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/42182
TRN_ID                          247096
ATT_ID                          730
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: 9382.56 26679 1125907
customer order: creation 176.82 404 21218
customer order: refuse 15.80 327 1896
order to supplier: creation 47.28 1248 5673
order to supplier: removal 3.33 110607 400
invoice (draft): creation 48.52 3273 5822
invoice (draft): removal 52.38 873 6285
invoice accept: apply 42.99 18486 5159
invoice accept: cancel 47.60 821 5712
customer reserve: creation 3966.67 184 476000
customer reserve: removal 4662.93 61 559552
realization accept: apply 87.80 153 10536
realization accept: cancel 93.99 105 11279
payment from customer: creation 62.27 112 7472
payment from customer: removal 5.70 63 684
payment to supplier: creation 51.40 123 6168
payment to supplier: removal 3.75 88 450
service: total inventory turnovers 5.03 1039 603
service: total monetary turnovers 7.39 21 887
service: aggregate perf. data 0.89 22355 107
service: refresh index statistics 0.03 373241 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 01-04-2021 16:33:14 to 01-04-2021 16:33:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3101
TEST_TIME 2 5180
TEST_TIME 3 5166
TEST_TIME 4 6019
TEST_TIME 5 5771
TEST_TIME 6 5397
TEST_TIME 7 5358
TEST_TIME 8 5662
TEST_TIME 9 5718
TEST_TIME 10 5710
TEST_TIME 11 5931
TEST_TIME 12 5920
TEST_TIME 13 6007
TEST_TIME 14 6158
TEST_TIME 15 6597
TEST_TIME 16 7081
TEST_TIME 17 7464
TEST_TIME 18 7367
TEST_TIME 19 7677
TEST_TIME 20 7949
TEST_TIME 21 8249
TEST_TIME 22 8170
TEST_TIME 23 9415
TEST_TIME 24 9694
TEST_TIME 25 9533
TEST_TIME 26 10166
TEST_TIME 27 11073
TEST_TIME 28 10991
TEST_TIME 29 10783
TEST_TIME 30 10632
TEST_TIME 31 10357
TEST_TIME 32 10294
TEST_TIME 33 10314
TEST_TIME 34 10062
TEST_TIME 35 10144
TEST_TIME 36 10091
TEST_TIME 37 10176
TEST_TIME 38 10133
TEST_TIME 39 9977
TEST_TIME 40 9958
TEST_TIME 41 9963
TEST_TIME 42 9851
TEST_TIME 43 9935
TEST_TIME 44 9866
TEST_TIME 45 9754
TEST_TIME 46 9720
TEST_TIME 47 9622
TEST_TIME 48 9846
TEST_TIME 49 9781
TEST_TIME 50 9793
TEST_TIME 51 9781
TEST_TIME 52 9917
TEST_TIME 53 9905
TEST_TIME 54 9980
TEST_TIME 55 9943
TEST_TIME 56 9891
TEST_TIME 57 9963
TEST_TIME 58 10002
TEST_TIME 59 9937
TEST_TIME 60 9810
TEST_TIME 61 9832
TEST_TIME 62 9765
TEST_TIME 63 9763
TEST_TIME 64 9744
TEST_TIME 65 9681
TEST_TIME 66 9649
TEST_TIME 67 9650
TEST_TIME 68 9642
TEST_TIME 69 9613
TEST_TIME 70 9621
TEST_TIME 71 9707
TEST_TIME 72 9703
TEST_TIME 73 9840
TEST_TIME 74 9812
TEST_TIME 75 9870
TEST_TIME 76 9849
TEST_TIME 77 9811
TEST_TIME 78 9827
TEST_TIME 79 9836
TEST_TIME 80 9796
TEST_TIME 81 9730
TEST_TIME 82 9682
TEST_TIME 83 9625
TEST_TIME 84 9630
TEST_TIME 85 9609
TEST_TIME 86 9558
TEST_TIME 87 9576
TEST_TIME 88 9551
TEST_TIME 89 9502
TEST_TIME 90 9545
TEST_TIME 91 9510
TEST_TIME 92 9504
TEST_TIME 93 9576
TEST_TIME 94 9588
TEST_TIME 95 9629
TEST_TIME 96 9697
TEST_TIME 97 9677
TEST_TIME 98 9671
TEST_TIME 99 9699
TEST_TIME 100 9731
TEST_TIME 101 9684
TEST_TIME 102 9708
TEST_TIME 103 9634
TEST_TIME 104 9622
TEST_TIME 105 9608
TEST_TIME 106 9582
TEST_TIME 107 9534
TEST_TIME 108 9492
TEST_TIME 109 9480
TEST_TIME 110 9423
TEST_TIME 111 9374
TEST_TIME 112 9416
TEST_TIME 113 9423
TEST_TIME 114 9410
TEST_TIME 115 9446
TEST_TIME 116 9421
TEST_TIME 117 9457
TEST_TIME 118 9422
TEST_TIME 119 9424
TEST_TIME 120 9385

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-04-2021 16:33:18 to 01-04-2021 16:33:21.

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 1566559 1566559 0 0.00 0 17515 6 0 0
doc_list_biud 1566557 1566557 0 0.00 0 27938 28 0 0
sp_add_invoice_to_stock 5234 5159 75 1.43 28 222968 18486 0 75
sp_cancel_adding_invoice 5712 5712 0 0.00 4 50544 821 0 0
sp_cancel_client_order 1896 1896 0 0.00 4 10622 327 0 0
sp_cancel_customer_reserve 559552 559552 0 0.00 1 26862 62 0 0
sp_cancel_pay_from_customer 684 684 0 0.00 2 3916 64 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 3 5700 89 0 0
sp_cancel_supplier_invoice 6293 6285 8 0.12 2 21863 874 0 8
sp_cancel_supplier_order 400 400 0 0.00 6 1103499 110607 0 0
sp_cancel_write_off 11279 11279 0 0.00 1 7826 106 0 0
sp_client_order 21218 21218 0 0.00 3 23157 404 0 0
sp_customer_reserve 476000 476000 0 0.00 0 56281 185 0 0
sp_fill_shopping_cart 32695 32695 0 0.00 1 10936 38 0 0
sp_fill_shopping_cart_clo_res 475994 475994 0 0.00 0 13757 14 0 0
sp_get_clo_for_invoice 5153 5153 0 0.00 0 29286 323 0 0
sp_kill_cost_storno 18125 18125 0 0.00 0 10755 54 0 0
sp_kill_qstorno_ret_qs2qd 1137068 1137068 0 0.00 0 26843 34 0 0
sp_kill_qty_storno 600813 600813 0 0.00 0 27936 72 0 0
sp_lock_selected_doc 21751 21751 0 0.00 0 8169 4 0 0
sp_make_cost_storno 29329 29329 0 0.00 0 17500 47 0 0
sp_multiply_rows_for_pdistr 29329 29329 0 0.00 0 13334 28 0 0
sp_multiply_rows_for_qdistr 21218 21218 0 0.00 0 18985 201 0 0
sp_pay_from_customer 7472 7472 0 0.00 4 14473 112 0 0
sp_pay_to_supplier 6168 6168 0 0.00 5 13345 124 0 0
sp_payment_common 13640 13640 0 0.00 1 11588 25 0 0
sp_qd_handle_on_cancel_clo 1896 1896 0 0.00 0 10613 304 0 0
sp_qd_handle_on_invoice_upd_sts 10865 10865 0 0.00 0 27935 334 0 0
sp_qd_handle_on_reserve_upd_sts 10536 10536 0 0.00 0 17578 54 0 0
sp_reserve_write_off 10536 10536 0 0.00 6 17607 153 0 0
sp_supplier_invoice 5822 5822 0 0.00 7 72837 3274 0 0
sp_supplier_order 5673 5673 0 0.00 5 26554 1248 0 0
srv_aggregate_perf_data 107 107 0 0.00 2027 509649 22355 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 972 129635 30780 0 0
srv_find_qd_qs_mism 1076311 1076311 0 0.00 0 17039 5 0 0
srv_make_invnt_saldo 603 603 0 0.00 45 72075 1039 0 0
srv_make_money_saldo 887 887 0 0.00 1 948 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 214498 473990 373241 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 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 5159 5159 0 0.00 0 20473 176 0 0
t$perf-norm:sp_cancel_adding_invoice 447 447 0 0.00 0 3556 72 0 0
t$perf-norm:sp_cancel_client_order 1896 1896 0 0.00 0 8677 15 0 0
t$perf-norm:sp_cancel_customer_reserve 758 758 0 0.00 0 2873 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 684 684 0 0.00 0 276 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 441 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 5579 26 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 24671 1671 0 0
t$perf-norm:sp_cancel_write_off 1027 1027 0 0.00 0 2518 10 0 0
t$perf-norm:sp_client_order 21218 21218 0 0.00 0 11441 18 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 5848 13 0 0
t$perf-norm:sp_pay_from_customer 7472 7472 0 0.00 0 5742 12 0 0
t$perf-norm:sp_pay_to_supplier 6168 6168 0 0.00 0 5775 12 0 0
t$perf-norm:sp_reserve_write_off 10536 10536 0 0.00 0 11067 11 0 0
t$perf-norm:sp_supplier_invoice 5822 5822 0 0.00 0 3187 14 0 0
t$perf-norm:sp_supplier_order 5673 5673 0 0.00 0 4144 15 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 1935 42 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 117 1 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 1293 19 0 0
t$perf-norm:srv_make_money_saldo 887 887 0 0.00 0 3770 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 4 6 5 0 0
v_add_invoice_to_stock 10452 10302 150 1.43 0 5744 16 0 150
v_all_customers 39208 39208 0 0.00 0 54 1 0 0
v_all_suppliers 31948 31948 0 0.00 0 13 1 0 0
v_all_wares 42426 42426 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 894 894 0 0.00 0 5032 13 0 0
v_cancel_client_order 3792 3792 0 0.00 0 1723 5 0 0
v_cancel_customer_prepayment 1368 1368 0 0.00 0 3885 10 0 0
v_cancel_customer_reserve 1516 1516 0 0.00 0 4264 10 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 4219 8 0 0
v_cancel_supplier_invoice 820 804 16 1.95 0 3366 22 0 16
v_cancel_supplier_order 800 800 0 0.00 0 6512 20 0 0
v_cancel_write_off 2054 2054 0 0.00 0 671 11 0 0
v_max_id_clo_ord 5671 5671 0 0.00 0 995 2 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 1974 16 0 0
v_max_id_ord_sup 5811 5811 0 0.00 0 4273 5 0 0
v_max_non_paid_invoice 1676 1676 0 0.00 0 1369 3 0 0
v_max_non_paid_realizn 3777 3777 0 0.00 0 5753 7 0 0
v_min_id_clo_ord 5671 5671 0 0.00 0 6460 9 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 5661 25 0 0
v_min_id_ord_sup 5811 5811 0 0.00 0 4579 7 0 0
v_min_non_paid_invoice 6168 6168 0 0.00 0 4638 12 0 0
v_min_non_paid_realizn 7472 7472 0 0.00 0 11581 19 0 0
v_our_firm 10608 10608 0 0.00 0 64 1 0 0
v_reserve_write_off 21072 21072 0 0.00 0 5022 6 0 0
x_lock_depdocs_on_canc_invoice 11595 11595 0 0.00 0 17940 121 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 15675 397 0 0
x_make_qstorno_1000_1200 5673 5673 0 0.00 1 26545 1167 0 0
x_make_qstorno_1200_2000 5822 5822 0 0.00 3 72826 3139 0 0
x_make_qstorno_2100_3300 476000 476000 0 0.00 0 56277 167 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 01-04-2021 16:33:22 to 01-04-2021 16:33:27.

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
14:02:19 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:25 12969 8192000000 10217524576 10520772608 917315776 10.070 73 50 99 0 936472800 2417344 16739680
14:02:46 23425 8192000000 10344598256 10665189376 1377289712 14.392 100 84 168 0 1409459536 4491408 27678416
14:03:18 20431 8192000000 10377291744 10698440704 1432933712 14.887 100 88 176 0 1467270208 6161984 28174512
14:03:52 19717 8192000000 10403186080 10733981696 1458044560 15.109 100 79 156 2 1490340832 6951568 25344704
14:04:25 22423 8192000000 10436215008 10766737408 1487677536 15.369 100 86 172 0 1523166688 7976768 27512384
14:04:58 19937 8192000000 10456659424 10790064128 1509378128 15.558 100 85 170 0 1545270864 9156656 26736080
14:05:25 18154 8192000000 10474150640 10811695104 1527219296 15.713 100 85 170 1 1562895552 9211440 26464816
14:06:04 15948 8192000000 10496495968 10838859776 1548490032 15.897 100 84 168 1 1584666512 9810864 26365616
14:06:41 18024 8192000000 10518293696 10865324032 1570057152 16.083 100 82 164 1 1605631168 10547920 25026096
14:07:07 14706 8192000000 10538482960 10886320128 1587574000 16.233 100 84 168 0 1624227200 11440272 25212928
14:07:35 15116 8192000000 10566267264 10921676800 1617336256 16.487 100 87 173 1 1655850976 12354240 26160480
14:07:58 14275 8192000000 10581223376 10939949056 1636910976 16.654 100 84 168 3 1674389344 12374080 25104288
14:08:20 8898 8192000000 10601777328 10959695872 1656291456 16.818 100 81 162 0 1693136528 12244848 24600224
14:08:37 11276 8192000000 10613185152 10976718848 1675132112 16.976 100 90 180 0 1714661264 12989744 26539408
14:08:58 9678 8192000000 10618574448 10986520576 1682119760 17.035 100 79 158 3 1718688336 13238704 23329872
14:09:15 10236 8192000000 10648339056 11014483968 1691395200 17.113 100 75 150 1 1725210416 12460816 21354400
14:09:33 7044 8192000000 10648506720 11020951552 1711514128 17.281 100 76 151 0 1745637248 12437680 21685440
14:09:48 7860 8192000000 10671355792 11044487168 1732978464 17.460 100 79 156 1 1766642800 11911952 21752384
14:10:04 4026 8192000000 10677535312 11050188800 1743903136 17.551 100 87 172 2 1781998592 13341600 24753856
14:10:17 6281 8192000000 10698115232 11070705664 1752789056 17.625 100 84 169 0 1790266528 13605184 23872288
14:10:30 4438 8192000000 10703547984 11080921088 1763226176 17.711 100 77 154 1 1798040976 13114240 21700560
14:10:41 3427 8192000000 10707256368 11083763712 1767089168 17.743 100 86 173 0 1804887136 13440688 24357280
14:10:52 4858 8192000000 10716086176 11091382272 1776583568 17.821 100 80 159 0 1811666736 12642256 22440912
14:11:03 3647 8192000000 10732522656 11109806080 1786062080 17.899 100 81 161 2 1822139616 12287040 23790496
14:11:13 2183 8192000000 10729082672 11112701952 1794654160 17.970 100 85 170 0 1832296336 13055072 24587104
14:11:23 2662 8192000000 10747637744 11126439936 1802465104 18.034 100 87 172 0 1838671360 12619568 23586688
14:11:32 8042 8192000000 10741397024 11127275520 1803749008 18.045 100 80 159 1 1838449120 13141232 21558880
14:11:46 6256 8192000000 10747340080 11128905728 1808369312 18.083 100 82 163 2 1844541104 14170864 22000928
14:11:59 1515 8192000000 10760416464 11148607488 1823355712 18.205 100 86 171 1 1860670688 13479424 23835552
14:12:07 1781 8192000000 10765956848 11151704064 1827805760 18.241 100 85 170 1 1866456832 14234368 24416704
14:12:16 1735 8192000000 10780216224 11164647424 1836311472 18.311 100 86 174 0 1874259520 13825216 24122832
14:12:24 1448 8192000000 10784316160 11171672064 1840495104 18.345 100 93 185 3 1880888016 13326208 27066704
14:12:32 1519 8192000000 10784804464 11170410496 1844968624 18.381 100 89 176 0 1881564368 12130608 24465136
14:12:40 1046 8192000000 10795892192 11179261952 1847310800 18.400 100 90 180 1 1886853136 14148400 25393936
14:12:47 1636 8192000000 10798423696 11186499584 1854233584 18.457 100 90 180 0 1893681632 13589104 25858944
14:12:55 1138 8192000000 10804830960 11189039104 1855887584 18.470 100 92 183 2 1893667584 13226400 24553600
14:13:02 1061 8192000000 10810392752 11192967168 1862624576 18.525 100 94 188 2 1903623520 14512464 26486480
14:13:09 1459 8192000000 10812997328 11198472192 1866160128 18.553 100 96 192 2 1908372768 15164448 27048192
14:13:17 1307 8192000000 10815949712 11199225856 1864239488 18.538 100 95 194 0 1905855344 14251440 27364416
14:13:24 2653 8192000000 10785525392 11191386112 1865417088 18.547 100 61 122 0 1894467136 12098912 16951136
14:13:33 30046 8192000000 10787070336 11200839680 1863222224 18.529 100 46 92 1 1886430080 8499104 14708752
14:14:09 4244 8192000000 10807779920 11207172096 1871815280 18.599 100 65 131 3 1899419264 8836032 18767952
14:14:23 13147 8192000000 10800677712 11204067328 1868332080 18.571 100 28 55 1 1883639856 7222944 8084832
14:14:44 9057 8192000000 10779555776 11204476928 1866873824 18.559 100 16 30 1 1875983520 5522560 3587136
14:15:02 12417 8192000000 10778208608 11207462912 1868271760 18.570 100 20 40 0 1880762192 6623840 5866592
14:15:24 9696 8192000000 10774081456 11209007104 1870747952 18.590 100 19 38 2 1882741344 6409840 5583552
14:15:40 9378 8192000000 10779539360 11212419072 1875838032 18.631 100 23 46 2 1888715456 5901920 6975504
14:16:00 5694 8192000000 10781557040 11215376384 1877280480 18.643 100 16 32 0 1887182048 5803856 4097712
14:16:12 12661 8192000000 10786328192 11217317888 1878712240 18.655 100 17 32 2 1889482688 6121520 4648928
14:16:34 6612 8192000000 10790118016 11222147072 1881100016 18.674 100 14 28 1 1891107696 6065328 3942352
14:16:48 10629 8192000000 10787299952 11227987968 1884130656 18.698 100 16 32 1 1898818864 10094720 4593488
14:17:05 11960 8192000000 10787779792 11227983872 1888990640 18.738 100 15 30 0 1899868048 5940032 4937376
14:17:26 29770 8192000000 10807245792 11237875712 1890693184 18.751 100 23 46 0 1903736016 5770928 7271904
14:18:02 46439 8192000000 10840266208 11246743552 1898384432 18.813 100 64 129 3 1923851952 6492144 18975376
14:18:55 6998 8192000000 10824757408 11253522432 1897628112 18.807 100 38 73 3 1920617264 13030496 9958656
14:19:12 5217 8192000000 10818802000 11244670976 1896197584 18.796 100 23 47 1 1908696640 5591552 6907504
14:19:25 3652 8192000000 10821051984 11247116288 1899320112 18.821 100 38 75 5 1917032016 7033968 10677936
14:19:37 8511 8192000000 10822034192 11248218112 1897567840 18.807 100 27 55 1 1911752176 6544352 7639984
14:19:59 6371 8192000000 10815978160 11246297088 1901160208 18.836 100 24 48 3 1913605920 5733424 6712288
14:20:12 8868 8192000000 10826670832 11254095872 1906018400 18.875 100 28 57 2 1920272960 5464848 8789712
14:20:27 8670 8192000000 10810419120 11247345664 1888033312 18.730 99 31 62 1 1903940288 6425392 9481584
14:20:47 8406 8192000000 10818943456 11253288960 1905334592 18.869 100 25 50 1 1918612688 6397104 6880992
14:21:02 9357 8192000000 10804793696 11233021952 1865923088 18.551 98 19 38 0 1877152336 5665184 5564064
14:21:17 10510 8192000000 10783482448 11222003712 1856585936 18.476 98 17 36 0 1867586576 6333744 4666896
14:21:35 7680 8192000000 10813243728 11245387776 1896902176 18.801 100 30 60 0 1912967840 6858080 9207584
14:21:48 72448 8192000000 10774830896 11208884224 1782557728 17.871 94 25 50 2 1794491168 4679024 7254416
14:23:12 6723 8192000000 10760384560 11188207616 1824594624 18.215 98 32 62 3 1840420960 6482016 9344320
14:23:26 6961 8192000000 10754684400 11174514688 1808481152 18.083 98 35 70 2 1826031456 7811472 9738832
14:23:41 7809 8192000000 10743796304 11157422080 1764443232 17.721 96 32 64 2 1779539792 5937648 9158912
14:23:57 6982 8192000000 10705936496 11123458048 1759850832 17.683 97 19 38 1 1771178208 6156544 5170832
14:24:10 8983 8192000000 10706446368 11118276608 1749692864 17.599 97 31 62 0 1764737104 5875168 9169072
14:24:27 7973 8192000000 10703304880 11118219264 1759911232 17.684 98 28 56 1 1774904016 6346384 8646400
14:24:41 6036 8192000000 10708399104 11129847808 1754330560 17.637 97 28 57 1 1768285360 5584256 8370544
14:24:56 10381 8192000000 10703965568 11126624256 1792322528 17.951 99 14 28 1 1801828720 5431168 4075024
14:25:13 7250 8192000000 10687287664 11105390592 1745862384 17.567 98 20 37 3 1757132848 5334336 5936128
14:25:29 7803 8192000000 10683958368 11094056960 1669585344 16.930 93 18 36 2 1679688736 5099968 5003424
14:25:45 11247 8192000000 10676374528 11092054016 1700866096 17.192 95 13 26 0 1709883552 5427328 3590128
14:26:03 8540 8192000000 10678319568 11088183296 1730042096 17.436 97 24 46 2 1742847984 5435616 7370272
14:26:20 61804 8192000000 10708714480 11113484288 1712875376 17.293 95 36 72 0 1728846112 5235392 10735344
14:27:28 15057 8192000000 10705832096 11133124608 1798525008 18.002 100 22 44 2 1810995264 5861072 6609184
14:27:50 7523 8192000000 10723420384 11141820416 1802819088 18.037 100 24 48 1 1815679680 6069552 6791040
14:28:06 11302 8192000000 10737994912 11156504576 1818255632 18.163 100 21 43 2 1829962080 5803744 5902704
14:28:23 6854 8192000000 10739502528 11166502912 1830653088 18.265 100 25 50 0 1844442432 6584240 7205104
14:28:36 8170 8192000000 10740386112 11163672576 1797564864 17.994 98 24 49 1 1810380304 6601408 6214032
14:28:53 6530 8192000000 10737924416 11165298688 1817222976 18.155 99 30 60 3 1832721472 5623680 9874816
14:29:06 11246 8192000000 10749525056 11175247872 1839061584 18.333 100 31 62 0 1854187120 5701248 9424288
14:29:26 10446 8192000000 10760573616 11181940736 1838159584 18.326 100 18 34 0 1848485296 5336448 4989264
14:29:43 9017 8192000000 10770083952 11191279616 1845896320 18.389 100 19 38 1 1857644976 5681376 6067280
14:30:00 9848 8192000000 10755662800 11187372032 1847693488 18.403 100 16 32 0 1857805680 5667600 4444592
14:30:16 8469 8192000000 10772086032 11199754240 1852874416 18.445 100 26 52 0 1869353440 9540960 6938064
14:30:33 7232 8192000000 10775657536 11200110592 1857497472 18.483 100 21 42 2 1869384192 5325520 6561200
14:30:47 23393 8192000000 10767906976 11203960832 1860273584 18.505 100 14 28 0 1870227136 4828048 5125504
14:31:19 21253 8192000000 10787526736 11207049216 1865893840 18.551 100 22 43 1 1878004160 4972448 7137872
14:31:46 55372 8192000000 10818067216 11229290496 1876711792 18.639 100 41 82 2 1893993120 5152736 12128592
14:32:49 22554 8192000000 10821763232 11239505920 1893616864 18.775 100 50 99 3 1915204880 7637504 13950512
14:33:24 32845 8192000000 10834234224 11252637696 1901865024 18.841 100 45 88 0 1923679136 9721712 12092400
14:34:04 14026 8192000000 10837206608 11259768832 1908599936 18.895 100 43 86 1 1930418496 9586496 12232064
14:34:27 11383 8192000000 10840451552 11264774144 1915575232 18.951 100 43 86 0 1937127232 9289984 12262016
14:34:47 32050 8192000000 10854520432 11282690048 1923675216 19.016 100 53 106 1 1948416928 10076464 14665248
14:35:44 8540 8192000000 10869594224 11296710656 1935261248 19.109 100 43 86 1 1962773120 14475792 13036080
14:36:01 8467 8192000000 10874669840 11303280640 1940974848 19.155 100 50 99 3 1970976208 14933552 15067808
14:36:30 10207 8192000000 10873688240 11309211648 1944700736 19.184 100 44 87 0 1969853072 12666864 12485472
14:36:47 13051 8192000000 10887380064 11315236864 1948549808 19.215 100 44 88 0 1974894800 13526928 12818064
14:37:13 9442 8192000000 10888266288 11323711488 1956926816 19.282 100 53 106 1 1989223936 16845712 15451408
14:37:30 17355 8192000000 10903133648 11335184384 1963207424 19.332 100 51 98 4 1993773488 16566800 13999264
14:37:57 6226 8192000000 10919984704 11343147008 1972378000 19.404 100 60 120 0 2008093664 18015872 17699792
14:38:20 19760 8192000000 10921222416 11357122560 1975384880 19.428 100 48 96 1 2011224528 21901648 13938000
14:38:46 16487 8192000000 10924014848 11357179904 1977854432 19.448 100 46 91 1 2014951824 23813584 13283808
14:39:12 17840 8192000000 10934726784 11367915520 1983481920 19.492 100 50 100 0 2025314272 26573248 15259104
14:39:37 12486 8192000000 10934290400 11371544576 1985898608 19.511 100 49 98 2 2028367968 27600624 14868736
14:40:01 5467 8192000000 10954758832 11380977664 1991852560 19.558 100 53 107 1 2037564208 28991792 16719856
14:40:14 6930 8192000000 10966476736 11392892928 1998261472 19.609 100 65 130 1 2044053184 26381936 19409776
14:40:33 4761 8192000000 10958164544 11390050304 2003489600 19.650 100 62 124 0 2051448736 28784128 19175008
14:40:46 9070 8192000000 10967416960 11395936256 2005597680 19.667 100 62 120 0 2053143840 30151568 17394592
14:41:14 9203 8192000000 10976118336 11403460608 2010289632 19.704 100 63 126 0 2058724928 29232896 19202400
14:41:31 15859 8192000000 10963473392 11394301952 1974600304 19.422 98 62 123 0 2026540464 33333696 18606464
14:41:59 5014 8192000000 10957946624 11395854336 1986841152 19.519 99 65 129 1 2041511824 34631248 20039424
14:42:18 19379 8192000000 10962365376 11391942656 1995230048 19.585 100 57 112 2 2046135216 33887856 17017312
14:42:48 7328 8192000000 10975771280 11400679424 2004968224 19.662 100 65 130 1 2061176160 36598352 19609584
14:43:04 5471 8192000000 10976325344 11405586432 2010442464 19.705 100 63 124 0 2066234000 37376848 18414688
14:43:16 3487 8192000000 10982600144 11408596992 2010019616 19.702 100 65 130 0 2068241936 38472176 19750144
14:43:28 7716 8192000000 10971686624 11404627968 2004586112 19.659 100 63 125 1 2059591856 35692656 19313088
14:43:49 8767 8192000000 10969382656 11403309056 1992065600 19.560 99 50 100 2 2043358640 35932880 15360160
14:44:08 8157 8192000000 10987771008 11411197952 2009867216 19.700 100 56 112 0 2064166080 36672128 17626736
14:44:25 5366 8192000000 10967115360 11397578752 1984224736 19.498 99 74 146 0 2045939328 38304272 23410320
14:44:41 2811 8192000000 10988997184 11412525056 2011054096 19.710 100 80 160 1 2074617968 39039360 24524512
14:44:53 7757 8192000000 10983604080 11407732736 2006359616 19.673 100 68 133 0 2066866544 40032560 20474368
14:45:12 4090 8192000000 10996419344 11418288128 2015460240 19.744 100 76 152 3 2080468672 42081456 22926976
14:45:25 3423 8192000000 10977094608 11399933952 1999214128 19.617 100 79 156 2 2066152224 43593920 23344176
14:45:34 7688 8192000000 10977047648 11403464704 1997536752 19.603 100 79 153 2 2065344688 43784992 24022944
14:45:51 7542 8192000000 10961130416 11387240448 1971942512 19.401 99 64 128 2 2036776656 45271088 19563056
14:46:06 4000 8192000000 10996923872 11415379968 2009645232 19.699 100 84 166 1 2082137888 46434608 26058048
14:46:16 3905 8192000000 11005551792 11416735744 2007685248 19.683 100 84 167 0 2080906240 47554000 25666992
14:46:28 2760 8192000000 10977362272 11393044480 1961846112 19.321 98 79 158 2 2035889952 49121536 24922304
14:46:39 4111 8192000000 10972449888 11388420096 1973523184 19.413 100 77 153 3 2050263600 52972464 23767952
14:46:54 13184 8192000000 10946429616 11369684992 1955035984 19.267 99 61 122 0 2024150080 49425456 19688640
14:47:15 2360 8192000000 10962206912 11377872896 1968109536 19.370 100 67 135 1 2042000416 52666848 21224032
14:47:24 1801 8192000000 10967306352 11382865920 1962676000 19.327 99 78 154 1 2038914288 52718976 23519312
14:47:34 2291 8192000000 10965894320 11384160256 1970542928 19.390 100 73 146 2 2047496832 53635184 23318720
14:47:43 971 8192000000 10960895696 11368927232 1957382976 19.285 99 91 181 4 2040036368 54892752 27760640
14:47:51 5111 8192000000 10958300704 11379544064 1971867984 19.400 100 77 153 0 2049215664 53753696 23593984
14:48:03 1395 8192000000 10976463872 11392647168 1978690976 19.454 100 80 160 4 2054041760 50190320 25160464
14:48:12 2803 8192000000 10965923008 11384639488 1974620496 19.422 100 73 143 2 2044323200 48151888 21550816
14:48:22 8111 8192000000 10933711648 11346309120 1928183168 19.052 99 76 152 2 1999120912 48985648 21952096
14:48:44 4753 8192000000 10910149104 11327438848 1917567120 18.967 99 67 134 2 1991337440 52303712 21466608
14:48:56 2483 8192000000 10931686304 11348279296 1939085264 19.139 100 66 132 0 2011933472 51829424 21018784
14:49:07 1292 8192000000 10934782976 11349450752 1942500880 19.167 100 75 150 2 2018383456 52239248 23643328
14:49:26 2274 8192000000 10972725488 11385298944 1974006944 19.417 100 88 173 1 2050032352 49223152 26802256
14:49:35 12645 8192000000 10954974032 11389730816 1971723536 19.399 100 52 104 1 2039359424 50702016 16933872
14:49:56 6200 8192000000 10963825680 11394564096 1979539520 19.461 100 54 106 5 2048317872 50927472 17850880
14:50:09 7594 8192000000 10968429952 11402653696 1986214928 19.514 100 50 100 3 2054805632 52469712 16120992
14:50:25 9888 8192000000 10977146624 11412922368 1993478496 19.571 100 58 116 2 2067074352 53585392 20010464
14:50:43 4081 8192000000 11002321152 11424796672 1999408912 19.618 100 74 147 1 2078585120 55853776 23322432
14:50:55 5306 8192000000 10983208704 11404500992 1972342112 19.404 99 70 138 3 2051614624 57207280 22065232
14:51:08 1454 8192000000 11007018480 11423199232 2001048288 19.631 100 89 178 3 2087456432 58802864 27605280
14:51:19 2862 8192000000 11018206496 11428941824 2002930336 19.646 100 78 151 2 2086447888 60274656 23242896
14:51:30 1610 8192000000 10988808256 11395346432 1976744944 19.439 99 89 176 1 2061885984 57477552 27663488
14:51:38 4059 8192000000 10974616848 11391369216 1968443488 19.373 100 72 144 0 2051300176 60015392 22841296
14:51:53 3519 8192000000 10972552464 11395973120 1973599840 19.414 100 63 126 0 2053599616 59334160 20665616
14:52:05 5591 8192000000 10971554544 11403526144 1973101152 19.410 100 54 108 2 2052896960 61670528 18125280
14:52:26 4024 8192000000 10986637024 11415322624 1986968128 19.520 100 62 123 1 2069509360 62413920 20127312
14:52:39 10158 8192000000 10966641504 11402452992 1970792912 19.392 100 49 98 0 2052943696 65441088 16709696
14:53:06 7673 8192000000 10939685504 11368775680 1943418752 19.174 99 45 91 1 2022526688 63150256 15957680
14:53:27 16263 8192000000 10944224304 11384446976 1937811472 19.129 99 48 96 2 2021260928 66865520 16583936
14:53:57 19673 8192000000 10935080576 11378491392 1939054224 19.139 99 43 86 0 2015316096 60778816 15483056
14:54:32 21145 8192000000 10938472704 11374166016 1925086960 19.028 99 43 86 1 2006604944 66184784 15333200
14:55:00 10895 8192000000 10947148576 11387535360 1944452944 19.182 100 36 72 2 2026790304 68990208 13347152
14:55:26 21561 8192000000 10912879520 11373686784 1929593856 19.064 99 28 56 1 1989906464 50463104 9849504
14:55:53 16353 8192000000 10907992752 11366457344 1942032416 19.163 100 22 44 0 1990857312 40872016 7952880
14:56:16 18596 8192000000 10903005600 11364909056 1945549952 19.191 100 22 44 0 1995337968 41792512 7995504
14:56:42 36429 8192000000 10902817152 11359064064 1928833280 19.058 100 19 38 0 1978257680 42489408 6934992
14:57:24 29011 8192000000 10900962496 11356585984 1911378320 18.918 99 22 44 0 1969477696 50031712 8067664
14:58:05 18539 8192000000 10887290736 11351220224 1902435952 18.846 99 20 40 2 1961644192 52000720 7207520
14:59:03 52074 8192000000 10861805360 11302068224 1890702352 18.751 99 14 28 0 1919802736 24346416 4753968
15:00:07 31852 8192000000 10863647200 11323338752 1930775248 19.073 100 28 55 1 1948178000 9146640 8256112
15:01:32 42108 8192000000 10865686384 11312922624 1902913168 18.850 98 44 87 1 1921802832 6881008 12008656
15:02:34 115914 8192000000 10880978576 11337306112 1941791728 19.161 100 33 65 0 1956126336 6086912 8247696
15:04:37 39377 8192000000 10872712000 11331575808 1914254720 18.941 98 29 58 4 1932908992 10885712 7768560
15:05:27 37364 8192000000 10850465680 11320463360 1910236080 18.909 99 9 18 0 1926234912 13717504 2281328
15:06:10 73423 8192000000 10842545984 11302182912 1825939824 18.226 95 10 19 2 1843067200 13948176 3179200
15:07:38 19632 8192000000 10871329984 11323187200 1934568576 19.103 100 25 50 1 1953213120 11881296 6763248
15:08:05 13927 8192000000 10901785888 11329372160 1925126944 19.028 99 44 88 1 1949613248 11163152 13323152
15:08:27 12390 8192000000 10876802224 11318403072 1922847840 19.010 99 46 93 1 1948227168 12565776 12813552
15:08:47 14945 8192000000 10891689504 11322220544 1923534160 19.015 99 60 119 0 1954043760 13232928 17276672
15:09:10 26737 8192000000 10875571040 11330854912 1942859440 19.170 100 48 96 3 1971871904 15107312 13905152
15:09:56 18609 8192000000 10876974864 11350466560 1947474464 19.206 100 17 32 1 1966295808 13611888 5209456
15:10:21 20758 8192000000 10875212000 11350999040 1950547904 19.231 100 6 12 0 1964222208 11989328 1684976
15:10:48 38619 8192000000 10880097152 11343847424 1935002464 19.107 99 21 43 0 1956716576 15814128 5899984
15:11:40 39322 8192000000 10877279088 11355963392 1955184096 19.268 100 13 26 1 1971980320 12381712 4414512
15:12:32 22772 8192000000 10874682752 11338608640 1939354752 19.142 99 12 24 0 1954747104 11766816 3625536
15:13:11 27300 8192000000 10897111312 11352461312 1963974304 19.338 100 25 48 3 1981049696 9689072 7386320
15:13:44 55289 8192000000 10896456832 11360514048 1966570896 19.358 100 19 38 0 1984510432 12481264 5458272
15:14:49 94297 8192000000 10879588128 11358081024 1948972080 19.218 99 18 36 0 1967615984 12991328 5652576
15:16:36 32158 8192000000 10883089280 11350794240 1962448704 19.325 100 22 43 0 1976297824 8263232 5585888
15:17:18 59590 8192000000 10894860832 11361837056 1969157472 19.379 100 14 28 1 1980527744 7428720 3941552
15:18:24 22819 8192000000 10895551600 11370553344 1972893216 19.408 100 19 38 3 1987756816 9566544 5297056
15:18:59 55105 8192000000 10910720112 11384217600 1958823840 19.297 99 15 30 2 1978190800 14887392 4479568
15:20:02 63607 8192000000 10887364640 11363532800 1954421648 19.262 99 8 16 0 1973677072 16675472 2579952
15:21:18 45562 8192000000 10912112144 11386130432 1982082416 19.481 100 16 32 0 1998910576 11926512 4901648
15:22:09 66047 8192000000 10928458544 11396739072 1964246880 19.340 99 13 25 0 1984796032 17187600 3361552
15:23:22 53303 8192000000 10911432624 11379998720 1948687232 19.216 98 21 40 2 1973123360 17907184 6528944
15:24:28 47293 8192000000 10904380144 11360686080 1949443616 19.222 99 21 42 0 1972464304 16892176 6128512
15:25:23 29161 8192000000 10920277776 11377451008 1981695392 19.478 100 46 93 3 2002889744 8167424 13026928
15:25:59 79442 8192000000 10909026080 11376623616 1961498496 19.318 99 25 50 1 1981847136 13495792 6852848
15:27:25 37995 8192000000 10906447312 11365863424 1910105184 18.907 96 36 72 2 1930115888 10064304 9946400
15:28:09 16709 8192000000 10906949968 11361402880 1936720064 19.121 98 38 76 1 1955135648 8340048 10075536
15:28:32 22416 8192000000 10913512864 11367116800 1955706720 19.272 99 42 84 0 1978049888 10612896 11730272
15:29:01 105786 8192000000 10870985456 11341656064 1787901760 17.915 91 19 38 1 1805559360 12633264 5024336
15:30:55 32965 8192000000 10907903888 11362107392 1938518624 19.135 99 28 55 0 1958533360 11758192 8256544
15:31:36 109098 8192000000 10887139776 11355684864 1954561344 19.263 100 34 68 4 1980284448 15226512 10496592
15:33:31 51867 8192000000 10901807920 11354226688 1936851984 19.122 98 41 82 3 1955450144 7739760 10858400
15:34:30 27136 8192000000 10864843696 11324760064 1909912400 18.906 97 32 63 0 1927846400 9426496 8507504
15:35:03 46636 8192000000 10863063712 11340283904 1912086688 18.923 98 13 26 0 1926947872 11682448 3178736
15:36:04 48051 8192000000 10852731728 11336376320 1906250096 18.877 98 10 20 0 1922533536 13874752 2408688
15:36:59 6216 8192000000 10855695008 11342618624 1935177744 19.108 100 6 12 0 1949749504 13175168 1396592
15:37:13 1591 8192000000 10856558672 11344592896 1935403984 19.110 100 6 11 1 1950286720 13585376 1297360
15:37:20 1317 8192000000 10854767472 11345248256 1934827152 19.105 100 3 6 0 1948602432 13506032 269248
15:37:28 4001 8192000000 10856018736 11344269312 1935823376 19.113 100 8 16 0 1950214880 12757792 1633712
15:38:34 66711 8192000000 10860533808 11336826880 1834836672 18.299 94 12 24 1 1847335712 9797136 2701904
15:39:47 54125 8192000000 10862328800 11328884736 1892626976 18.767 97 20 40 1 1911255808 13072432 5556400
15:40:47 50456 8192000000 10877100688 11332046848 1891069696 18.754 97 25 50 0 1911658224 13928032 6660496
15:41:53 42126 8192000000 10879499408 11343159296 1892182144 18.763 97 21 42 1 1915615568 17360896 6072528
15:42:46 57137 8192000000 10866140672 11325374464 1847340416 18.401 95 10 20 0 1865070576 14919536 2810624
15:43:49 50025 8192000000 10885584768 11337515008 1905327312 18.869 98 24 48 1 1928781264 16273392 7180560
15:44:52 55937 8192000000 10839985056 11319967744 1837549696 18.321 95 21 42 0 1862589104 18544496 6494912
15:45:54 69401 8192000000 10841755712 11299004416 1847653552 18.403 96 18 36 0 1870342192 16751904 5936736
15:47:10 82356 8192000000 10833816640 11306532864 1836112752 18.309 96 14 28 1 1858271584 18208192 3950640
15:48:40 52438 8192000000 10884258448 11324256256 1883721312 18.695 97 41 82 2 1902907168 7345968 11839888
15:49:45 22466 8192000000 10894326432 11339239424 1927120960 19.044 99 55 111 1 1952599808 10565984 14912864
15:50:22 14662 8192000000 10890302896 11346243584 1933250592 19.093 99 34 68 1 1954979840 12381168 9348080
15:50:43 75544 8192000000 10887136016 11350605824 1918081440 18.971 98 18 36 2 1937168176 13763568 5323168
15:52:08 84513 8192000000 10891678544 11348078592 1955103008 19.267 100 17 34 0 1972072112 11978736 4990368
15:53:50 39431 8192000000 10876759664 11335458816 1915062656 18.947 98 37 70 4 1930732064 5996320 9673088
15:54:40 55360 8192000000 10887371936 11345833984 1941820944 19.161 99 43 86 0 1962303968 8483120 11999904
15:55:49 1806 8192000000 10915402256 11350024192 1946401952 19.198 99 93 188 3 1982335568 10070384 25863232
15:55:58 14862 8192000000 10905144704 11341389824 1925219200 19.029 98 61 121 2 1954730720 12313344 17198176
15:56:20 64835 8192000000 10871996928 11348402176 1958995728 19.298 100 15 30 0 1972890592 9296288 4598576
15:59:08 76171 8192000000 10868382608 11344068608 1907431024 18.886 97 13 26 1 1924117760 12912704 3774032
16:00:40 96493 8192000000 10889689200 11367940096 1959602480 19.303 100 11 22 1 1975072368 12112336 3357552
16:02:23 66649 8192000000 10902111104 11371036672 1955505856 19.270 99 12 24 0 1976380288 17522192 3352240
16:04:00 35466 8192000000 10931531728 11405201408 1997637264 19.604 100 26 52 0 2017841552 12216272 7988016
16:04:41 55336 8192000000 10942530000 11416702976 2005057312 19.663 100 19 38 0 2026589328 16063552 5468464
16:05:59 60513 8192000000 10914022272 11385720832 1960488864 19.310 99 18 35 2 1981941744 15560384 5892496
16:07:06 129635 8192000000 10918506256 11390447616 1953388704 19.253 98 14 28 0 1975449808 17753808 4307296
16:09:31 23618 8192000000 10920698784 11369279488 1915248640 18.949 96 42 84 0 1936281072 9354400 11678032
16:10:05 27965 8192000000 10917443568 11371425792 1940860464 19.154 98 40 80 2 1962169712 10156176 11153072
16:10:47 36930 8192000000 10925571664 11369656320 1936798960 19.121 98 54 108 1 1965226080 12557200 15869920
16:11:31 29796 8192000000 10894111344 11356827648 1898249920 18.812 97 35 70 0 1921849856 13977568 9622368
16:12:10 85680 8192000000 10879273296 11331493888 1860294832 18.506 95 22 44 0 1880847216 13815104 6737280
16:13:45 24146 8192000000 10893823328 11351953408 1957383008 19.285 100 27 54 2 1973696048 9026688 7286352
16:14:16 99228 8192000000 10877077152 11348684800 1887570672 18.726 96 14 28 2 1905449824 13717488 4161664
16:16:15 103067 8192000000 10882794368 11366682624 1955904112 19.273 100 15 30 1 1975172576 14604720 4663744
16:18:06 45452 8192000000 10880436960 11351494656 1949481360 19.222 100 12 22 2 1962988624 9784208 3723056
16:18:58 55091 8192000000 10877200336 11358523392 1960896544 19.313 100 9 18 0 1970551616 7163200 2491872
16:19:59 41131 8192000000 10869484336 11348062208 1935442128 19.110 99 7 14 0 1944415600 7298576 1674896
16:20:46 32114 8192000000 10867124176 11344875520 1934108432 19.100 99 13 26 0 1945564800 7248256 4208112
16:21:25 36101 8192000000 10878576928 11365736448 1956168608 19.276 100 13 26 0 1971373120 10694928 4509584
16:22:10 49916 8192000000 10881195968 11355197440 1898839888 18.817 97 15 30 2 1915256080 11881408 4534784
16:23:35 82183 8192000000 10869882288 11360681984 1923043584 19.011 99 13 27 0 1946394208 19606160 3744464
16:25:04 55169 8192000000 10862872864 11344723968 1889396736 18.741 97 14 28 0 1910225872 16602528 4226608
16:26:09 36212 8192000000 10851582432 11321958400 1887436912 18.725 97 34 69 2 1907836336 10197600 10201824
16:26:57 41007 8192000000 10854406528 11316404224 1841978880 18.357 95 21 42 1 1858281008 10569872 5732256
16:27:44 72913 8192000000 10867323120 11344912384 1875755856 18.631 97 11 22 1 1891157808 12625520 2776432
16:29:04 116424 8192000000 10864672032 11326586880 1843433536 18.369 95 18 36 1 1863174624 14590928 5150160
16:31:06 40050 8192000000 10874778368 11330744320 1901250704 18.836 98 39 78 2 1925672672 13381344 11040624
16:31:56 31416 8192000000 9241216192 9502068736 393019248 4.577 21 2 4 0 400401440 7038160 344032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 01-04-2021 16:33:28 to 01-04-2021 16:34:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 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:01, from 01-04-2021 16:34:02 to 01-04-2021 16:34:03.

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          247438
MON$OLDEST_ACTIVE               247439
MON$OLDEST_SNAPSHOT             247439
MON$NEXT_TRANSACTION            247439
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                       2019456
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.33430 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33430 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33430 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33430 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Apr  1 16:32:36 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Apr  1 16:32:39 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Thu Apr  1 16:32:39 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
--- end of diff output ---

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

01.04.21 16:34:04. 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-04-01 16:34:07 No severe PSQL-related problems occured
01.04.21 16:34:08. End of report.