Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.02.2021 22: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 16731796 kB
MemAvailable 31135564 kB
Buffers 0 kB
Cached 14981896 kB
SwapCached 3860 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-02-24 22:27:16
DTS_END                         2021-02-24 22:27:16.4570
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/37600
TRN_ID                          242648
ATT_ID                          692
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: 9390.53 20917 1126863
customer order: creation 173.93 345 20871
customer order: refuse 15.24 363 1829
order to supplier: creation 44.71 1279 5365
order to supplier: removal 3.61 94735 433
invoice (draft): creation 47.03 3822 5644
invoice (draft): removal 54.39 803 6527
invoice accept: apply 42.49 17739 5099
invoice accept: cancel 48.73 730 5848
customer reserve: creation 3904.72 175 468566
customer reserve: removal 4760.41 56 571249
realization accept: apply 83.58 188 10030
realization accept: cancel 83.83 106 10060
payment from customer: creation 58.16 118 6979
payment from customer: removal 5.96 92 715
payment to supplier: creation 47.96 135 5755
payment to supplier: removal 3.48 80 418
service: total inventory turnovers 4.73 1145 568
service: total monetary turnovers 6.73 53 807
service: aggregate perf. data 0.80 25570 96
service: refresh index statistics 0.03 270800 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-02-2021 22:28:50 to 24-02-2021 22:28:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5193
TEST_TIME 2 4996
TEST_TIME 3 3841
TEST_TIME 4 3430
TEST_TIME 5 4196
TEST_TIME 6 4458
TEST_TIME 7 5034
TEST_TIME 8 5324
TEST_TIME 9 5216
TEST_TIME 10 5293
TEST_TIME 11 5940
TEST_TIME 12 6070
TEST_TIME 13 6710
TEST_TIME 14 6704
TEST_TIME 15 6982
TEST_TIME 16 7379
TEST_TIME 17 7764
TEST_TIME 18 8154
TEST_TIME 19 8541
TEST_TIME 20 8500
TEST_TIME 21 8635
TEST_TIME 22 8729
TEST_TIME 23 9050
TEST_TIME 24 9072
TEST_TIME 25 9019
TEST_TIME 26 9085
TEST_TIME 27 9359
TEST_TIME 28 9298
TEST_TIME 29 9518
TEST_TIME 30 9684
TEST_TIME 31 10819
TEST_TIME 32 10942
TEST_TIME 33 10836
TEST_TIME 34 10786
TEST_TIME 35 10675
TEST_TIME 36 10527
TEST_TIME 37 10402
TEST_TIME 38 10245
TEST_TIME 39 10189
TEST_TIME 40 10232
TEST_TIME 41 10276
TEST_TIME 42 10083
TEST_TIME 43 10010
TEST_TIME 44 9980
TEST_TIME 45 9848
TEST_TIME 46 10057
TEST_TIME 47 10092
TEST_TIME 48 10114
TEST_TIME 49 10081
TEST_TIME 50 9987
TEST_TIME 51 10017
TEST_TIME 52 9966
TEST_TIME 53 10001
TEST_TIME 54 9935
TEST_TIME 55 9989
TEST_TIME 56 9968
TEST_TIME 57 9978
TEST_TIME 58 10099
TEST_TIME 59 10053
TEST_TIME 60 10004
TEST_TIME 61 10096
TEST_TIME 62 9996
TEST_TIME 63 10060
TEST_TIME 64 10094
TEST_TIME 65 10034
TEST_TIME 66 9945
TEST_TIME 67 9909
TEST_TIME 68 9865
TEST_TIME 69 9827
TEST_TIME 70 9794
TEST_TIME 71 9804
TEST_TIME 72 9739
TEST_TIME 73 9726
TEST_TIME 74 9674
TEST_TIME 75 9637
TEST_TIME 76 9594
TEST_TIME 77 9551
TEST_TIME 78 9560
TEST_TIME 79 9501
TEST_TIME 80 9489
TEST_TIME 81 9501
TEST_TIME 82 9506
TEST_TIME 83 9490
TEST_TIME 84 9612
TEST_TIME 85 9587
TEST_TIME 86 9707
TEST_TIME 87 9722
TEST_TIME 88 9736
TEST_TIME 89 9745
TEST_TIME 90 9805
TEST_TIME 91 9794
TEST_TIME 92 9812
TEST_TIME 93 9712
TEST_TIME 94 9668
TEST_TIME 95 9616
TEST_TIME 96 9570
TEST_TIME 97 9556
TEST_TIME 98 9550
TEST_TIME 99 9495
TEST_TIME 100 9523
TEST_TIME 101 9574
TEST_TIME 102 9605
TEST_TIME 103 9574
TEST_TIME 104 9684
TEST_TIME 105 9625
TEST_TIME 106 9643
TEST_TIME 107 9703
TEST_TIME 108 9689
TEST_TIME 109 9655
TEST_TIME 110 9670
TEST_TIME 111 9653
TEST_TIME 112 9586
TEST_TIME 113 9580
TEST_TIME 114 9535
TEST_TIME 115 9569
TEST_TIME 116 9519
TEST_TIME 117 9499
TEST_TIME 118 9467
TEST_TIME 119 9462
TEST_TIME 120 9392

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-02-2021 22:28:54 to 24-02-2021 22:28:57.

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 1559640 1559640 0 0.00 0 31377 6 0 0
doc_list_biud 1559638 1559638 0 0.00 0 27836 26 0 0
sp_add_invoice_to_stock 5178 5099 79 1.52 38 223333 17740 0 79
sp_cancel_adding_invoice 5848 5848 0 0.00 4 63743 731 0 0
sp_cancel_client_order 1829 1829 0 0.00 5 10548 363 0 0
sp_cancel_customer_reserve 571249 571249 0 0.00 1 26542 56 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 3 10742 93 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 7050 80 0 0
sp_cancel_supplier_invoice 6533 6527 6 0.09 2 15581 804 0 6
sp_cancel_supplier_order 433 433 0 0.00 6 917498 94736 0 0
sp_cancel_write_off 10060 10060 0 0.00 1 26897 106 0 0
sp_client_order 20871 20871 0 0.00 3 32932 346 0 0
sp_customer_reserve 468566 468566 0 0.00 0 34105 176 0 0
sp_fill_shopping_cart 31870 31870 0 0.00 1 12327 40 0 0
sp_fill_shopping_cart_clo_res 468561 468561 0 0.00 0 28488 13 0 0
sp_get_clo_for_invoice 5094 5094 0 0.00 0 30632 256 0 0
sp_kill_cost_storno 17041 17041 0 0.00 0 31368 52 0 0
sp_kill_qstorno_ret_qs2qd 1159518 1159518 0 0.00 0 26884 31 0 0
sp_kill_qty_storno 611068 611068 0 0.00 0 27835 67 0 0
sp_lock_selected_doc 21014 21014 0 0.00 0 10927 6 0 0
sp_make_cost_storno 27856 27856 0 0.00 0 12662 57 0 0
sp_multiply_rows_for_pdistr 27855 27855 0 0.00 0 11290 30 0 0
sp_multiply_rows_for_qdistr 20871 20871 0 0.00 0 32924 163 0 0
sp_pay_from_customer 6979 6979 0 0.00 4 17494 119 0 0
sp_pay_to_supplier 5755 5755 0 0.00 5 10877 136 0 0
sp_payment_common 12733 12733 0 0.00 1 17442 31 0 0
sp_qd_handle_on_cancel_clo 1829 1829 0 0.00 0 8442 312 0 0
sp_qd_handle_on_invoice_upd_sts 10940 10940 0 0.00 0 27834 322 0 0
sp_qd_handle_on_reserve_upd_sts 10030 10030 0 0.00 0 26196 65 0 0
sp_reserve_write_off 10030 10030 0 0.00 7 26286 189 0 0
sp_supplier_invoice 5644 5644 0 0.00 7 101625 3823 0 0
sp_supplier_order 5365 5365 0 0.00 5 38874 1280 0 0
srv_aggregate_perf_data 96 96 0 0.00 3029 467479 25571 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1164 131053 31663 0 0
srv_find_qd_qs_mism 1078426 1078426 0 0.00 0 9704 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 20 71781 1145 0 0
srv_make_money_saldo 807 807 0 0.00 0 17796 53 0 0
srv_recalc_idx_stat 4 4 0 0.00 148466 529858 270800 0 0
t$perf-abend:sp_add_invoice_to_stock 79 79 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5099 5099 0 0.00 0 13955 179 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 2847 73 0 0
t$perf-norm:sp_cancel_client_order 1829 1829 0 0.00 0 1508 9 0 0
t$perf-norm:sp_cancel_customer_reserve 706 706 0 0.00 0 396 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 4104 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 1295 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 6552 43 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 20773 1822 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 1795 8 0 0
t$perf-norm:sp_client_order 20871 20871 0 0.00 0 11107 17 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 2831 17 0 0
t$perf-norm:sp_pay_from_customer 6979 6979 0 0.00 0 6240 12 0 0
t$perf-norm:sp_pay_to_supplier 5755 5755 0 0.00 0 8210 14 0 0
t$perf-norm:sp_reserve_write_off 10030 10030 0 0.00 0 4657 10 0 0
t$perf-norm:sp_supplier_invoice 5644 5644 0 0.00 0 3967 16 0 0
t$perf-norm:sp_supplier_order 5365 5365 0 0.00 0 5712 18 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 410 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 1847 20 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 2869 36 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 3290 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 10342 10184 158 1.52 0 6003 18 0 158
v_all_customers 37556 37556 0 0.00 0 68 1 0 0
v_all_suppliers 30212 30212 0 0.00 0 22 1 0 0
v_all_wares 41742 41742 0 0.00 0 104 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 1242 9 0 0
v_cancel_client_order 3658 3658 0 0.00 0 4617 8 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 5319 12 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 446 3 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 1072 4 0 0
v_cancel_supplier_invoice 782 770 12 1.53 0 4513 20 0 12
v_cancel_supplier_order 866 866 0 0.00 0 758 5 0 0
v_cancel_write_off 1996 1996 0 0.00 0 5986 15 0 0
v_max_id_clo_ord 5364 5364 0 0.00 0 1068 2 0 0
v_max_id_clo_res 999 999 0 0.00 0 2360 14 0 0
v_max_id_ord_sup 5633 5633 0 0.00 0 5531 5 0 0
v_max_non_paid_invoice 1645 1645 0 0.00 0 487 3 0 0
v_max_non_paid_realizn 3836 3836 0 0.00 0 3499 5 0 0
v_min_id_clo_ord 5364 5364 0 0.00 0 4518 7 0 0
v_min_id_clo_res 999 999 0 0.00 0 1140 3 0 0
v_min_id_ord_sup 5633 5633 0 0.00 0 12308 16 0 0
v_min_non_paid_invoice 5754 5754 0 0.00 0 7263 20 0 0
v_min_non_paid_realizn 6979 6979 0 0.00 0 5460 16 0 0
v_our_firm 10472 10472 0 0.00 0 12 1 0 0
v_reserve_write_off 20060 20060 0 0.00 0 5120 7 0 0
x_lock_depdocs_on_canc_invoice 11990 11990 0 0.00 0 12795 107 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 17142 425 0 0
x_make_qstorno_1000_1200 5365 5365 0 0.00 1 38866 1201 0 0
x_make_qstorno_1200_2000 5644 5644 0 0.00 3 101091 3672 0 0
x_make_qstorno_2100_3300 468566 468566 0 0.00 0 33351 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-02-2021 22:28:58 to 24-02-2021 22:29:02.

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
19:57:20 4 8192000000 8802517136 8814166016 8577104 0.104 2 1 2 0 8698336 58672 62560
19:57:27 11020 8192000000 10232637664 10536411136 1037345792 11.239 82 62 124 0 1061285040 2865936 21073312
19:57:45 15618 8192000000 10304357232 10618101760 1354847360 14.191 100 80 160 0 1385173904 4161280 26165264
19:58:09 34721 8192000000 10370135216 10692689920 1415696176 14.735 100 84 168 0 1448845936 5772256 27377504
19:58:53 20206 8192000000 10409142080 10738118656 1465870080 15.177 100 86 173 0 1500453520 6881296 27702144
19:59:23 25068 8192000000 10445513600 10778083328 1495768800 15.439 100 91 182 0 1533504448 8058288 29677360
19:59:57 21644 8192000000 10461844048 10798100480 1514801408 15.605 100 87 174 0 1551194704 8635440 27757856
20:00:28 18650 8192000000 10468482464 10808758272 1530731696 15.743 100 87 174 0 1567633600 9037632 27864272
20:00:56 19924 8192000000 10499382896 10840195072 1543717312 15.856 100 85 170 0 1579371696 8914224 26740160
20:01:24 27094 8192000000 10521129008 10866962432 1568424032 16.069 100 86 172 0 1604631008 9388880 26818096
20:02:04 15879 8192000000 10537943408 10888335360 1590411520 16.257 100 86 172 0 1627662768 10321488 26929760
20:02:33 14380 8192000000 10549470496 10909032448 1608812720 16.415 100 83 166 0 1643836688 10006496 25017472
20:02:55 16879 8192000000 10579628432 10940375040 1635647792 16.643 100 78 156 0 1669684544 10071600 23965152
20:03:23 7015 8192000000 10597016528 10962612224 1657202192 16.825 100 76 151 0 1690014848 11089536 21723120
20:03:39 9147 8192000000 10621765408 10987732992 1677148976 16.993 100 78 156 1 1711561472 12049200 22363296
20:03:57 7275 8192000000 10628898320 10998251520 1694327968 17.138 100 81 162 0 1729799104 12261152 23209984
20:04:15 8792 8192000000 10657003760 11024830464 1708855184 17.259 100 77 154 2 1743345968 12749184 21741600
20:04:32 8798 8192000000 10664831712 11041435648 1726746336 17.408 100 76 152 3 1761000864 12690160 21564368
20:04:48 8575 8192000000 10686528128 11066425344 1741556192 17.532 100 79 157 0 1781237632 17532976 22148464
20:05:04 4754 8192000000 10691559504 11070005248 1755689200 17.649 100 74 146 0 1789102800 12645152 20768448
20:05:17 5277 8192000000 10707397584 11084787712 1769031952 17.759 100 75 149 0 1802150048 12361312 20756784
20:05:29 8668 8192000000 10707133712 11090833408 1771172976 17.777 100 74 147 4 1804492672 13147040 20172656
20:05:44 4483 8192000000 10723348192 11107557376 1780247392 17.852 100 76 152 1 1814531648 12795056 21489200
20:05:55 3294 8192000000 10736330176 11116965888 1792486864 17.952 100 77 154 2 1828088736 13508624 22093248
20:06:06 4249 8192000000 10731999968 11118456832 1799525328 18.010 100 77 152 2 1834402480 13055280 21821872
20:06:20 3168 8192000000 10751391728 11134660608 1808855600 18.087 100 88 176 2 1847862528 13983552 25023376
20:06:29 3223 8192000000 10752988144 11137929216 1811030752 18.104 100 84 166 4 1848549856 13869680 23649424
20:06:40 2530 8192000000 10765443872 11146313728 1818850368 18.168 100 90 178 3 1858119552 14296944 24972240
20:06:49 2504 8192000000 10767762384 11149414400 1823162608 18.204 100 93 186 1 1865370864 15458752 26749504
20:06:59 2676 8192000000 10772284112 11155795968 1829355152 18.254 100 93 184 0 1870275024 15311280 25608592
20:07:08 2058 8192000000 10766260800 11155668992 1830057552 18.260 100 88 174 1 1869073808 15099232 23917024
20:07:17 1373 8192000000 10780206224 11163267072 1835620688 18.305 100 90 180 0 1874206240 13837136 24748416
20:07:25 1417 8192000000 10783505088 11169148928 1841628240 18.354 100 91 182 1 1881074528 13855536 25590752
20:07:33 1883 8192000000 10781176032 11168727040 1844433968 18.377 100 89 179 1 1882687568 12721856 25531744
20:07:42 1631 8192000000 10797512288 11183259648 1851281616 18.433 100 89 177 0 1887997840 11398304 25317920
20:07:50 2323 8192000000 10798285680 11181797376 1852266784 18.441 100 91 182 4 1889985920 12474592 25244544
20:07:59 2489 8192000000 10806552608 11190169600 1857285008 18.481 100 94 189 1 1897626272 13277760 27063504
20:08:08 2703 8192000000 10807984592 11197825024 1862126608 18.521 100 94 188 0 1903555792 14885120 26544064
20:08:17 1716 8192000000 10810652400 11196809216 1864685904 18.541 100 95 190 0 1906657280 14590576 27380800
20:08:25 1271 8192000000 10815643584 11199361024 1869329968 18.579 100 98 199 1 1911226336 14017824 27878544
20:08:32 2393 8192000000 10809483296 11202293760 1872046656 18.601 100 86 172 0 1908441792 11509472 24885664
20:08:41 37472 8192000000 10809611856 11209789440 1869953696 18.584 100 66 132 0 1902352752 12831040 19568016
20:09:25 10864 8192000000 10799622512 11205779456 1867929728 18.568 100 46 91 0 1889960320 9345232 12685360
20:09:42 22505 8192000000 10770197296 11204120576 1871222464 18.594 100 33 66 1 1887908256 6589712 10096080
20:10:13 9757 8192000000 10781013296 11212550144 1876895840 18.640 100 27 54 1 1891178320 6901872 7380608
20:10:30 3721 8192000000 10803039392 11220631552 1882788752 18.688 100 40 79 2 1899754640 5510656 11455232
20:10:43 5571 8192000000 10788921120 11222114304 1883986624 18.697 100 21 42 0 1896231824 6327120 5918080
20:10:54 8016 8192000000 10801674784 11228577792 1886589696 18.718 100 23 46 1 1899140400 6417760 6132944
20:11:11 6346 8192000000 10791330048 11222818816 1888111520 18.731 100 28 54 2 1901588960 5643296 7834144
20:11:26 6749 8192000000 10793024848 11226509312 1888561056 18.734 100 22 44 2 1900230560 5572768 6096736
20:11:39 7966 8192000000 10800016336 11233177600 1890613760 18.751 100 23 46 2 1903744368 6737424 6393184
20:11:54 11440 8192000000 10791538208 11230908416 1892741728 18.768 100 20 41 0 1905291744 6748720 5801296
20:12:12 11848 8192000000 10801351488 11234238464 1892799552 18.768 100 14 28 1 1902514896 5832240 3883104
20:12:34 9821 8192000000 10813963728 11242098688 1900833136 18.833 100 23 46 2 1913746816 6700208 6213472
20:12:50 11848 8192000000 10800686992 11238469632 1899282640 18.821 100 15 30 1 1908336624 5149936 3904048
20:13:08 6569 8192000000 10814439376 11244339200 1898880464 18.817 100 23 46 1 1911664096 6829264 5954368
20:13:21 6941 8192000000 10813494800 11242065920 1898591184 18.815 100 13 26 0 1908588416 5860384 4136848
20:13:34 12851 8192000000 10810085536 11247407104 1904643904 18.864 100 19 38 1 1916033568 5835376 5554288
20:13:53 69026 8192000000 10817940848 11258023936 1913681648 18.936 100 39 78 0 1931127152 5228992 12216512
20:15:09 18715 8192000000 10811902336 11255726080 1907375232 18.886 100 18 36 0 1918398928 6168736 4854960
20:15:34 8627 8192000000 10832711968 11264196608 1912256608 18.925 100 21 42 2 1923479648 5711280 5511760
20:15:51 8149 8192000000 10819833808 11256479744 1908680000 18.896 100 20 40 0 1920212784 5938128 5594656
20:16:06 5817 8192000000 10817592288 11251945472 1891294160 18.756 99 28 57 1 1904544608 5516720 7733728
20:16:18 10885 8192000000 10804578512 11229581312 1865161696 18.545 98 22 42 0 1876375792 5274592 5939504
20:16:38 4761 8192000000 10789142352 11222573056 1863447920 18.531 99 17 34 1 1874960544 6060640 5451984
20:16:50 7166 8192000000 10803028384 11234287616 1889680576 18.743 100 34 69 2 1905485840 5012800 10792464
20:17:05 8392 8192000000 10791470336 11221917696 1850557744 18.427 98 24 48 2 1862907056 5025424 7323888
20:17:21 5517 8192000000 10791028528 11220918272 1874746544 18.623 100 23 46 1 1887450880 6278928 6425408
20:17:33 13342 8192000000 10767322432 11196788736 1812579904 18.117 97 13 27 1 1821494192 4879456 4034832
20:17:52 12218 8192000000 10734557312 11156176896 1699736928 17.183 91 17 34 1 1709434240 4902736 4794576
20:18:15 8915 8192000000 10719733920 11148173312 1791561056 17.945 98 20 40 1 1802941296 5504560 5875680
20:18:33 11949 8192000000 10710908048 11133628416 1715050560 17.311 94 20 38 2 1725062272 4874624 5137088
20:18:58 52411 8192000000 10688878464 11106521088 1665382528 16.894 92 24 48 1 1678127040 5931488 6813024
20:20:00 14311 8192000000 10712467984 11126870016 1733969808 17.469 96 25 50 1 1747070720 6175200 6925712
20:20:22 5705 8192000000 10687393280 11102560256 1747837776 17.584 97 41 81 1 1767657328 7686048 12133504
20:20:35 6431 8192000000 10701851152 11105865728 1675330416 16.978 93 32 62 3 1690970336 5379632 10260288
20:20:50 4109 8192000000 10702460880 11111780352 1751656752 17.615 98 26 52 3 1765177424 5551376 7969296
20:21:04 7453 8192000000 10720783360 11132190720 1772735472 17.790 98 23 46 1 1785290064 5400288 7154304
20:21:18 7898 8192000000 10716317600 11132350464 1767179264 17.744 98 23 46 3 1779363152 5521200 6662688
20:21:33 6441 8192000000 10702549344 11122253824 1772725248 17.790 99 23 46 1 1784632480 5102432 6804800
20:21:46 8204 8192000000 10721902320 11143634944 1806834176 18.070 100 22 44 0 1818661232 5358224 6468832
20:22:00 6691 8192000000 10731100704 11154030592 1795955584 17.981 99 14 28 1 1805451504 5204160 4291760
20:22:16 11210 8192000000 10745539600 11159810048 1790732592 17.938 98 27 53 0 1804293440 5081824 8479024
20:22:35 15268 8192000000 10726432432 11158458368 1816057168 18.145 100 10 20 0 1823797696 5130000 2610528
20:22:57 16880 8192000000 10749587904 11174043648 1831955888 18.275 100 31 61 2 1847135280 5676992 9502400
20:23:25 74456 8192000000 10759361664 11190132736 1848513776 18.410 100 32 64 4 1863757472 5593888 9649808
20:24:49 7226 8192000000 10774432944 11200995328 1858294256 18.489 100 29 58 2 1873009040 5856688 8858096
20:25:05 5305 8192000000 10778327984 11203358720 1860554464 18.508 100 33 66 2 1877447744 7930160 8963120
20:25:16 8527 8192000000 10776594960 11200282624 1860070768 18.504 100 14 28 1 1869379504 5298304 4010432
20:25:32 8871 8192000000 10778125200 11205296128 1860894256 18.511 100 19 38 1 1871128672 5249520 4984896
20:25:49 11293 8192000000 10790296464 11214045184 1868316528 18.571 100 30 60 0 1883542688 6580752 8645408
20:26:09 8789 8192000000 10780655360 11211030528 1868490352 18.572 100 24 48 1 1881627328 6072688 7064288
20:26:24 8455 8192000000 10775703648 11212029952 1869454416 18.580 100 21 42 1 1881628336 5260656 6913264
20:26:43 9163 8192000000 10792744320 11219468288 1871654096 18.598 100 25 51 0 1884829344 5550064 7625184
20:27:02 9988 8192000000 10803991648 11232403456 1888870976 18.737 100 29 58 2 1902563776 5291552 8401248
20:27:18 11537 8192000000 10842897664 11255205888 1905326752 18.869 100 40 80 1 1921862272 5213328 11322192
20:27:41 22671 8192000000 10850338880 11270737920 1922362016 19.006 100 54 106 1 1944909456 6517936 16029504
20:28:20 14700 8192000000 10867264960 11281629184 1926245616 19.037 100 51 103 1 1949871392 8671408 14954368
20:28:42 36540 8192000000 10868117904 11290402816 1942634112 19.168 100 55 111 3 1967216288 9002624 15579552
20:29:27 30557 8192000000 10858931600 11300134912 1942930704 19.170 100 43 87 1 1963892064 8685856 12275504
20:30:08 111532 8192000000 10881958416 11314515968 1952892432 19.250 100 34 65 0 1973921712 11689216 9340064
20:32:06 20081 8192000000 10888082464 11323670528 1943838272 19.177 99 47 94 0 1973109248 15436816 13834160
20:32:39 39112 8192000000 10899241040 11338514432 1962146464 19.323 100 33 66 0 1989723888 17121984 10455440
20:33:26 7622 8192000000 10914178768 11343388672 1976092576 19.434 100 54 107 0 2006938032 14737616 16107840
20:33:41 10026 8192000000 10908629120 11345145856 1974827776 19.424 100 51 102 1 2007260816 17183312 15249728
20:33:59 7415 8192000000 10918342336 11354406912 1979173376 19.458 100 56 110 1 2014249024 18732272 16343376
20:34:13 17667 8192000000 10926990448 11360382976 1980329472 19.467 100 55 105 0 2018222656 22477904 15415280
20:34:37 8735 8192000000 10923890272 11361083392 1982522416 19.485 100 51 102 0 2017818144 19863168 15432560
20:34:54 9918 8192000000 10916039040 11361439744 1984257360 19.498 100 46 92 2 2014932224 16994944 13679920
20:35:14 5475 8192000000 10916009072 11347918848 1962681424 19.327 99 54 108 2 1993633584 14674368 16277792
20:35:28 13617 8192000000 10929415968 11359399936 1980411872 19.468 100 55 110 0 2017832288 20886400 16534016
20:35:50 11830 8192000000 10915418448 11351015424 1965978352 19.354 99 54 108 2 1999053232 17146400 15928480
20:36:21 11211 8192000000 10925958752 11356585984 1981197552 19.474 100 55 110 1 2015547568 18212608 16137408
20:36:44 15436 8192000000 10936351216 11365949440 1981733536 19.478 100 51 100 0 2018484112 21762192 14988384
20:37:09 6771 8192000000 10936091216 11368521728 1987400720 19.523 100 52 104 1 2026123184 23199200 15523264
20:37:24 15266 8192000000 10937732224 11375857664 1994570800 19.580 100 58 116 1 2036230848 24203952 17456096
20:37:47 6707 8192000000 10942293616 11379871744 1974006128 19.417 99 46 92 0 2018429440 30736768 13686544
20:38:04 3698 8192000000 10941810400 11377852416 1985205920 19.506 100 61 122 2 2035127216 31372768 18548528
20:38:15 8029 8192000000 10947581632 11370442752 1971718864 19.399 99 60 119 1 2015903728 26083104 18101760
20:38:31 3710 8192000000 10955735440 11375984640 1985255456 19.506 100 71 140 2 2033298176 26751488 21291232
20:38:43 5710 8192000000 10939361760 11364855808 1981012416 19.473 100 75 150 1 2027844384 25104672 21727296
20:38:55 3729 8192000000 10935125360 11347226624 1961674528 19.319 99 78 156 2 2010591680 25993776 22923376
20:39:06 4723 8192000000 10957364256 11374497792 1987212336 19.522 100 88 173 2 2039579184 27002368 25364480
20:39:18 3653 8192000000 10949590352 11373420544 1988552864 19.532 100 70 139 1 2035239088 26910896 19775328
20:39:29 1520 8192000000 10954783040 11376828416 1975385920 19.428 99 84 169 3 2026682288 27340704 23955664
20:39:39 4645 8192000000 10946491776 11369836544 1980872608 19.472 100 76 149 1 2030600448 28211872 21515968
20:39:54 1238 8192000000 10950522848 11375325184 1988655184 19.533 100 76 152 1 2040236192 29153504 22427504
20:40:04 5866 8192000000 10943752240 11369521152 1974461952 19.421 99 70 141 1 2027024320 31912400 20649968
20:40:17 10230 8192000000 10942975712 11376877568 1974626464 19.422 99 57 114 1 2022202608 30949280 16626864
20:40:36 3693 8192000000 10940477568 11377737728 1972103056 19.402 99 53 107 1 2019556208 31893824 15559328
20:40:46 4142 8192000000 10945875680 11377172480 1981056768 19.473 100 66 132 3 2033405264 32393728 19954768
20:40:59 4640 8192000000 10930976112 11352825856 1952252016 19.244 99 69 140 0 2001112176 27490640 21369520
20:41:11 2097 8192000000 10949352832 11365068800 1976014576 19.433 100 82 164 1 2030878480 29647808 25216096
20:41:23 6710 8192000000 10954759472 11376750592 1984912432 19.504 100 82 161 2 2040082016 31303840 23865744
20:41:37 2030 8192000000 10958463056 11381997568 1987222176 19.522 100 83 166 1 2043960096 31733952 25003968
20:41:49 7921 8192000000 10960301280 11383394304 1974031808 19.417 99 73 145 0 2030430192 34929168 21469216
20:42:05 2384 8192000000 10971281872 11391123456 1992580992 19.564 100 84 169 1 2054721344 36742624 25397728
20:42:15 1379 8192000000 10976261792 11391086592 1992649680 19.565 100 86 170 0 2054491056 36202880 25638496
20:42:23 5662 8192000000 10924006944 11341033472 1937717376 19.129 98 70 140 3 1993220560 34037136 21466048
20:42:36 5118 8192000000 10917576320 11333763072 1944148192 19.180 100 91 183 1 2005948064 34702896 27096976
20:42:49 2119 8192000000 10918072384 11328806912 1925537616 19.031 99 83 165 0 1987449120 36373408 25538096
20:42:57 2963 8192000000 10938151664 11351015424 1956654496 19.279 100 87 172 3 2021516608 37538080 27324032
20:43:07 3042 8192000000 10922976992 11338088448 1919352768 18.982 98 78 157 1 1984060512 40466496 24241248
20:43:16 1634 8192000000 10936009216 11348357120 1950290944 19.229 100 91 182 3 2017048368 39051376 27706048
20:43:24 3248 8192000000 10933493968 11345195008 1950341872 19.229 100 89 175 2 2017258704 40120784 26796048
20:43:35 1559 8192000000 10954589424 11363934208 1967459824 19.365 100 93 181 0 2035755056 41237808 27057424
20:43:43 5148 8192000000 10946751376 11360493568 1960412208 19.309 100 74 146 1 2022968304 40237760 22318336
20:43:56 9529 8192000000 10917989200 11343450112 1940064640 19.147 99 73 146 0 2006067008 43583744 22418624
20:44:15 1872 8192000000 10928244848 11338121216 1942338720 19.165 100 88 175 1 2010697808 40048944 28310144
20:44:24 1423 8192000000 10930379744 11334561792 1943049472 19.171 100 95 187 4 2007153600 35100256 29003872
20:44:33 2402 8192000000 10922349760 11325530112 1933214016 19.093 99 94 183 2 1996456208 36240752 27001440
20:44:42 1163 8192000000 10930227456 11339755520 1940267184 19.149 100 93 185 2 2008553104 40748800 27537120
20:44:53 6433 8192000000 10912117744 11331813376 1935986448 19.115 100 78 156 1 2001293296 41539472 23767376
20:45:07 3947 8192000000 10934062288 11340791808 1941891936 19.162 100 85 169 1 2013718912 45137536 26689440
20:45:18 7088 8192000000 10929857120 11345051648 1938969856 19.139 100 72 141 2 2005620640 45227648 21423136
20:45:34 8544 8192000000 10916188416 11338518528 1941524688 19.159 100 61 122 1 1999855616 39130368 19200560
20:45:48 1887 8192000000 10923762576 11338579968 1929760208 19.065 99 84 167 2 1996247888 40347888 26139792
20:45:58 3996 8192000000 10891948496 11307970560 1900182496 18.828 98 82 164 2 1966506400 40851712 25472192
20:46:09 2438 8192000000 10910819488 11321999360 1924190576 19.020 100 77 154 0 1990693376 42588848 23913952
20:46:18 11413 8192000000 10877703376 11300003840 1884695040 18.703 98 59 118 1 1944266480 40489408 19082032
20:46:37 17468 8192000000 10873543328 11314307072 1913266048 18.933 100 46 92 0 1970026272 42272384 14487840
20:47:11 8136 8192000000 10881537920 11316736000 1921806480 19.001 100 32 64 2 1968564848 35959232 10799136
20:47:26 10967 8192000000 10882450784 11309035520 1912933712 18.930 99 44 88 1 1964147584 37658016 13555856
20:47:49 4799 8192000000 10910571248 11330756608 1936214992 19.117 100 53 106 2 1992541968 39459376 16867600
20:48:01 2527 8192000000 10947771488 11353878528 1954830976 19.265 100 83 166 2 2021059840 40443056 25785808
20:48:10 5016 8192000000 10916988416 11343155200 1943807504 19.177 100 55 109 3 2001636976 41077344 16752128
20:48:22 13397 8192000000 10900810800 11341352960 1927488320 19.047 99 35 70 0 1978605424 40023456 11093648
20:48:42 6412 8192000000 10904332256 11338825728 1927521568 19.047 99 39 77 1 1980357888 40175088 12661232
20:49:12 5484 8192000000 10900349984 11333947392 1934492080 19.103 100 40 79 3 1988592864 41830784 12270000
20:49:31 9270 8192000000 10906313280 11333726208 1939381376 19.142 100 46 92 1 1991095024 37068992 14644656
20:49:54 2901 8192000000 10913126832 11332911104 1931468544 19.079 100 54 108 2 1986915936 39243856 16203536
20:50:04 6223 8192000000 10921434912 11343269888 1943518944 19.175 100 63 127 2 2004733968 41718528 19496496
20:50:17 10820 8192000000 10898231504 11324628992 1899939600 18.826 98 49 98 1 1958867056 43028480 15898976
20:50:36 11465 8192000000 10896856336 11339333632 1929188896 19.060 100 43 86 1 1989263360 45199792 14874672
20:51:01 7480 8192000000 10889837472 11317866496 1920298384 18.989 100 44 87 0 1970326624 36232240 13796000
20:51:32 5430 8192000000 10896860976 11323621376 1926254432 19.037 100 40 77 1 1971760080 33362000 12143648
20:51:45 3294 8192000000 10915139648 11338571776 1943856688 19.178 100 62 124 2 2002258784 37933584 20468512
20:51:58 17721 8192000000 10901181856 11343491072 1943548896 19.175 100 33 65 0 1991672272 37922960 10200416
20:52:28 17420 8192000000 10904655872 11343753216 1923789952 19.017 99 33 63 2 1975626160 41846752 9989456
20:53:11 21254 8192000000 10926189008 11365781504 1953570720 19.255 100 35 70 2 2007876752 43201616 11104416
20:53:40 25130 8192000000 10931269520 11381190656 1960960656 19.314 100 28 56 3 2017903168 47132224 9810288
20:54:18 30089 8192000000 10925891664 11380826112 1964750288 19.344 100 25 50 0 2015871568 42751536 8369744
20:55:11 30726 8192000000 10914662416 11365806080 1918344912 18.974 98 21 41 1 1966758704 40930832 7482960
20:55:48 18466 8192000000 10914910368 11362521088 1942575184 19.167 100 28 56 2 1998152432 46013008 9564240
20:56:17 35500 8192000000 10904506768 11369598976 1936269328 19.117 100 17 34 0 1991022512 48224448 6528736
20:56:59 21016 8192000000 10921891936 11369754624 1944173424 19.180 100 21 42 1 2003187200 51518640 7495136
20:57:37 38703 8192000000 10928090800 11380383744 1912905408 18.930 98 20 40 2 1975596144 55441056 7249680
20:58:26 100649 8192000000 10895737408 11360477184 1911243296 18.917 98 13 26 0 1937907584 22688112 3976176
21:00:51 68059 8192000000 10913998752 11355725824 1968686064 19.375 100 26 52 0 1985660784 9586736 7387984
21:02:06 37764 8192000000 10924503792 11364614144 1980090032 19.465 100 29 58 0 1994594160 6207136 8296992
21:02:50 23001 8192000000 10926439024 11364950016 1968762736 19.376 99 33 67 0 1984573776 6672448 9138592
21:03:25 16215 8192000000 10890019120 11348647936 1968222448 19.371 100 21 42 0 1981584624 7030176 6332000
21:03:47 103400 8192000000 10874108240 11333177344 1937542720 19.127 98 24 48 0 1951345088 6568336 7234032
21:06:08 22559 8192000000 10932740144 11370323968 1980906352 19.472 100 61 121 1 2008664032 8693344 19064336
21:06:40 56295 8192000000 10908958688 11380109312 1983190016 19.490 100 39 77 2 2006280544 11884640 11205888
21:07:43 46668 8192000000 10933741584 11378601984 1953229648 19.252 98 32 63 1 1972732576 11031328 8471600
21:08:38 95389 8192000000 10903766288 11371024384 1948492160 19.214 98 22 44 1 1969863680 13733872 7637648
21:10:20 4714 8192000000 10926983472 11382763520 1990982848 19.552 100 38 73 1 2013310784 11391264 10936672
21:11:01 52830 8192000000 10940124464 11401342976 1982625248 19.485 99 24 48 0 2005190560 15070256 7495056
21:12:00 44449 8192000000 10957864928 11416567808 2008888768 19.693 100 25 50 0 2033225888 16739296 7597824
21:12:57 59794 8192000000 10950458384 11432333312 2013976720 19.733 100 25 48 0 2048619440 26238784 8403936
21:14:48 42073 8192000000 10934477712 11423490048 2003854384 19.653 100 9 18 1 2024122624 17440608 2827632
21:15:37 46172 8192000000 10946930464 11430637568 2013572400 19.730 100 12 25 0 2036122544 19462720 3087424
21:18:15 95047 8192000000 10937111504 11412922368 1985476272 19.508 99 16 31 2 2003053360 13060000 4517088
21:20:42 36178 8192000000 10907560608 11371073536 1950107856 19.227 98 23 47 0 1967242976 11021024 6114096
21:21:24 32064 8192000000 10918449648 11391012864 1988573504 19.533 100 14 28 1 2001133120 8578736 3980880
21:22:08 61585 8192000000 10917061952 11396620288 1959516848 19.302 98 17 34 1 1978087712 13863424 4707440
21:23:21 52575 8192000000 10934226336 11392794624 1936843152 19.122 97 31 62 1 1959627136 14030144 8753840
21:24:23 57019 8192000000 10901501344 11365859328 1918226128 18.973 97 21 43 2 1938896816 14130768 6539920
21:25:26 102645 8192000000 10896595296 11357806592 1871292976 18.595 95 15 30 1 1886646352 10673616 4679760
21:27:25 42860 8192000000 10845041056 11296530432 1841519984 18.353 94 21 42 0 1857732768 10646784 5566000
21:28:16 94489 8192000000 10857333136 11310804992 1785375120 17.894 92 12 24 0 1803349904 14987440 2987344
21:30:00 93127 8192000000 10838036848 11289165824 1740751728 17.525 90 15 30 2 1758212032 13309536 4150768
21:31:42 56485 8192000000 10862563856 11316011008 1891191248 18.755 99 20 40 1 1908324320 11816400 5316672
21:33:34 99926 8192000000 10838794096 11307810816 1885460496 18.709 98 37 74 0 1907029520 10849632 10719392
21:35:22 41799 8192000000 10845139216 11310264320 1873535424 18.613 97 26 50 1 1891039808 10368496 7135888
21:36:14 41340 8192000000 10844070528 11306455040 1884089568 18.698 98 22 44 1 1897172768 6494416 6588784
21:37:02 19371 8192000000 10870629984 11328987136 1932507968 19.087 100 36 72 0 1955969040 13432064 10029008
21:37:35 29230 8192000000 10864849936 11329433600 1919372528 18.982 99 43 85 1 1941217904 9859632 11985744
21:38:19 62840 8192000000 10859617344 11333664768 1936382016 19.118 100 7 14 1 1947932272 9705312 1844944
21:39:28 59878 8192000000 10856669392 11318071296 1905287776 18.869 98 12 23 0 1916256368 7347024 3621568
21:40:42 25596 8192000000 10868909776 11343507456 1951340928 19.237 100 20 40 1 1967344064 9918368 6084768
21:41:20 54276 8192000000 10867377552 11348987904 1932674880 19.088 99 14 28 2 1948797632 11995952 4126800
21:43:21 85967 8192000000 10896762432 11363115008 1959389216 19.301 100 13 26 0 1975043520 11909296 3745008
21:44:53 79378 8192000000 10848399376 11335757824 1878434912 18.652 96 13 25 2 1894464032 12230560 3798560
21:46:25 38832 8192000000 10881486528 11342790656 1903297120 18.853 98 27 54 1 1917095808 6633328 7165360
21:47:26 78955 8192000000 10872503744 11356164096 1902811824 18.849 97 22 44 2 1924031072 14626208 6593040
21:48:58 50474 8192000000 10901377184 11369988096 1934326336 19.101 99 13 26 0 1962763728 24413312 4024080
21:49:56 78308 8192000000 10884367936 11361730560 1876168096 18.634 96 18 36 4 1903964624 21995040 5801488
21:51:25 60584 8192000000 10897754368 11358420992 1931822432 19.081 99 11 22 0 1952713424 17545456 3345536
21:52:32 47310 8192000000 10897801456 11368808448 1963019200 19.330 100 24 48 1 1986748992 17037120 6692672
21:53:27 58044 8192000000 10887274832 11371220992 1941911856 19.162 99 17 34 1 1961401792 14227872 5262064
21:54:31 50682 8192000000 10917485088 11383996416 1965233040 19.348 100 22 44 1 1981810608 10686624 5890944
21:55:34 53129 8192000000 10917628768 11389300736 1956097440 19.275 99 35 70 1 1983557680 17466496 9993744
21:56:36 34513 8192000000 10935132848 11403898880 1985605712 19.509 100 34 68 0 2010900128 15974592 9319824
21:57:19 79343 8192000000 10906309488 11381420032 1944472432 19.182 98 22 44 0 1964677920 14550144 5655344
21:58:45 126446 8192000000 10926731216 11407093760 1975195216 19.427 99 17 34 1 1994490448 14332592 4962640
22:01:24 77381 8192000000 10909323200 11399950336 1980295568 19.467 99 16 32 0 1996435488 11768496 4371424
22:02:52 90383 8192000000 10930992128 11423027200 2001527072 19.635 100 15 30 0 2018366112 12516752 4322288
22:04:29 66206 8192000000 10937223344 11429691392 2005259168 19.664 100 12 24 0 2024713056 15966000 3487888
22:05:42 63494 8192000000 10951882864 11429556224 2005900512 19.669 100 15 30 1 2023134448 13339200 3894736
22:06:54 52614 8192000000 10951685488 11429273600 1985871200 19.511 98 33 63 1 2010166592 15045936 9249456
22:08:08 71358 8192000000 10921646960 11426172928 1963057984 19.330 98 6 12 0 1986632560 21314976 2259600
22:09:31 51222 8192000000 10909265968 11389464576 1932139312 19.084 97 11 22 3 1944450208 9699888 2611008
22:10:49 26851 8192000000 10928020992 11400273920 1991623664 19.557 100 40 80 0 2018123232 14724784 11774784
22:12:07 128612 8192000000 10921615472 11423752192 1964721744 19.344 98 18 36 1 1997651664 27420864 5509056
22:14:39 111242 8192000000 10917180000 11380817920 1844145008 18.375 93 18 36 2 1862465504 13265344 5055152
22:16:42 38906 8192000000 10899684208 11346198528 1856488016 18.475 94 41 82 0 1880743088 12937456 11317616
22:17:30 25408 8192000000 10905746448 11369349120 1949589968 19.223 100 44 87 0 1976970880 15600208 11780704
22:18:06 26690 8192000000 10893787968 11362889728 1958569728 19.295 100 34 68 0 1983178864 14919536 9689600
22:18:39 131053 8192000000 10879645632 11361931264 1958966272 19.298 100 27 54 2 1979693536 13252208 7475056
22:21:01 35522 8192000000 10861715920 11333881856 1883822688 18.696 96 26 52 0 1899308272 8335696 7149888
22:21:42 21556 8192000000 10870836848 11342618624 1923232464 19.013 99 19 38 0 1936630336 8040432 5357440
22:22:15 65307 8192000000 10858958304 11348807680 1892654048 18.767 97 13 26 1 1913291328 16244192 4393088
22:23:26 35577 8192000000 10855572768 11351982080 1924672192 19.024 99 3 6 1 1936174272 10820896 681184
22:24:08 29060 8192000000 10857789680 11332677632 1914621696 18.944 99 8 14 2 1928115856 11547696 1946464
22:24:46 18866 8192000000 10833078336 11303641088 1875347360 18.628 97 8 16 0 1886259008 9283776 1627872
22:25:11 38036 8192000000 10841651056 11314245632 1903327696 18.853 99 13 26 0 1912651712 6268544 3055472
22:25:56 80751 8192000000 10796913088 11273560064 1802665120 18.036 93 14 28 0 1816813584 10348688 3799776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-02-2021 22:29:04 to 24-02-2021 22:29:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 79 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-02-2021 22:29:36 to 24-02-2021 22:29:38.

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          241893
MON$OLDEST_ACTIVE               242849
MON$OLDEST_SNAPSHOT             242849
MON$NEXT_TRANSACTION            242849
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                       2061088
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
--- end of diff output ---

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

24.02.21 22:29:39. 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-02-24 22:29:42 No severe PSQL-related problems occured
24.02.21 22:29:43. End of report.