Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.11.2020 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 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 17653928 kB
MemAvailable 31497516 kB
Buffers 0 kB
Cached 14047492 kB
SwapCached 2868 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-03 16:30:41
DTS_END                         2020-11-03 16:30:41.4510
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45852
TRN_ID                          233793
ATT_ID                          651
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: 9063.83 18239 1087659
customer order: creation 170.10 350 20412
customer order: refuse 14.25 339 1710
order to supplier: creation 45.70 1269 5484
order to supplier: removal 3.38 101136 405
invoice (draft): creation 45.93 3439 5511
invoice (draft): removal 51.71 762 6205
invoice accept: apply 40.85 18941 4902
invoice accept: cancel 46.13 874 5536
customer reserve: creation 3817.86 187 458143
customer reserve: removal 4531.65 59 543798
realization accept: apply 83.04 169 9965
realization accept: cancel 84.46 103 10135
payment from customer: creation 58.62 117 7034
payment from customer: removal 5.55 80 666
payment to supplier: creation 48.92 129 5870
payment to supplier: removal 3.61 58 433
service: total inventory turnovers 4.78 961 574
service: total monetary turnovers 6.43 23 771
service: aggregate perf. data 0.84 17338 101
service: refresh index statistics 0.03 218444 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3594
TEST_TIME 2 4182
TEST_TIME 3 4090
TEST_TIME 4 4110
TEST_TIME 5 4694
TEST_TIME 6 5086
TEST_TIME 7 5738
TEST_TIME 8 5929
TEST_TIME 9 6087
TEST_TIME 10 5909
TEST_TIME 11 5842
TEST_TIME 12 5925
TEST_TIME 13 6031
TEST_TIME 14 6159
TEST_TIME 15 6018
TEST_TIME 16 6170
TEST_TIME 17 6410
TEST_TIME 18 6961
TEST_TIME 19 7149
TEST_TIME 20 7321
TEST_TIME 21 7373
TEST_TIME 22 7908
TEST_TIME 23 7942
TEST_TIME 24 8014
TEST_TIME 25 8278
TEST_TIME 26 8500
TEST_TIME 27 8645
TEST_TIME 28 8827
TEST_TIME 29 9193
TEST_TIME 30 9170
TEST_TIME 31 9347
TEST_TIME 32 9633
TEST_TIME 33 9771
TEST_TIME 34 9493
TEST_TIME 35 9428
TEST_TIME 36 9271
TEST_TIME 37 9252
TEST_TIME 38 9301
TEST_TIME 39 9236
TEST_TIME 40 9091
TEST_TIME 41 9047
TEST_TIME 42 9118
TEST_TIME 43 9037
TEST_TIME 44 9115
TEST_TIME 45 9044
TEST_TIME 46 8917
TEST_TIME 47 8806
TEST_TIME 48 8736
TEST_TIME 49 8675
TEST_TIME 50 8755
TEST_TIME 51 8782
TEST_TIME 52 8731
TEST_TIME 53 8680
TEST_TIME 54 8853
TEST_TIME 55 8784
TEST_TIME 56 8865
TEST_TIME 57 8883
TEST_TIME 58 8929
TEST_TIME 59 9044
TEST_TIME 60 9107
TEST_TIME 61 9110
TEST_TIME 62 9070
TEST_TIME 63 9201
TEST_TIME 64 9182
TEST_TIME 65 9180
TEST_TIME 66 9093
TEST_TIME 67 9071
TEST_TIME 68 9133
TEST_TIME 69 9122
TEST_TIME 70 9129
TEST_TIME 71 9056
TEST_TIME 72 9039
TEST_TIME 73 8980
TEST_TIME 74 9038
TEST_TIME 75 8987
TEST_TIME 76 8938
TEST_TIME 77 8943
TEST_TIME 78 8929
TEST_TIME 79 8906
TEST_TIME 80 8856
TEST_TIME 81 8806
TEST_TIME 82 8889
TEST_TIME 83 8856
TEST_TIME 84 8845
TEST_TIME 85 8896
TEST_TIME 86 8904
TEST_TIME 87 8936
TEST_TIME 88 8962
TEST_TIME 89 8973
TEST_TIME 90 8994
TEST_TIME 91 9017
TEST_TIME 92 8992
TEST_TIME 93 9064
TEST_TIME 94 9109
TEST_TIME 95 9104
TEST_TIME 96 9170
TEST_TIME 97 9171
TEST_TIME 98 9092
TEST_TIME 99 9072
TEST_TIME 100 9065
TEST_TIME 101 9042
TEST_TIME 102 8989
TEST_TIME 103 8964
TEST_TIME 104 8994
TEST_TIME 105 8981
TEST_TIME 106 8972
TEST_TIME 107 8966
TEST_TIME 108 8993
TEST_TIME 109 8992
TEST_TIME 110 8988
TEST_TIME 111 9015
TEST_TIME 112 8985
TEST_TIME 113 9062
TEST_TIME 114 9048
TEST_TIME 115 9054
TEST_TIME 116 9047
TEST_TIME 117 9038
TEST_TIME 118 9105
TEST_TIME 119 9116
TEST_TIME 120 9069

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-11-2020 16:32:32 to 03-11-2020 16:32:35.

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 1511386 1511386 0 0.00 0 19213 6 0 0
doc_list_biud 1511385 1511385 0 0.00 0 31347 27 0 0
sp_add_invoice_to_stock 5002 4902 100 1.99 35 173141 18941 0 100
sp_cancel_adding_invoice 5536 5536 0 0.00 4 107575 875 0 0
sp_cancel_client_order 1710 1710 0 0.00 4 13868 340 0 0
sp_cancel_customer_reserve 543798 543798 0 0.00 1 31349 59 0 0
sp_cancel_pay_from_customer 666 666 0 0.00 3 2905 81 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 4429 58 0 0
sp_cancel_supplier_invoice 6209 6205 4 0.06 1 26203 763 0 4
sp_cancel_supplier_order 405 405 0 0.00 6 919816 101137 0 0
sp_cancel_write_off 10135 10135 0 0.00 1 9085 104 0 0
sp_client_order 20412 20412 0 0.00 4 31843 351 0 0
sp_customer_reserve 458143 458143 0 0.00 0 63177 187 0 0
sp_fill_shopping_cart 31399 31399 0 0.00 1 11053 34 0 0
sp_fill_shopping_cart_clo_res 458136 458136 0 0.00 0 14446 12 0 0
sp_get_clo_for_invoice 4887 4887 0 0.00 0 18891 261 0 0
sp_kill_cost_storno 16770 16770 0 0.00 0 19203 58 0 0
sp_kill_qstorno_ret_qs2qd 1104341 1104341 0 0.00 0 31062 32 0 0
sp_kill_qty_storno 582641 582641 0 0.00 0 31346 69 0 0
sp_lock_selected_doc 20511 20511 0 0.00 0 10022 5 0 0
sp_make_cost_storno 27756 27756 0 0.00 0 13710 49 0 0
sp_multiply_rows_for_pdistr 27756 27756 0 0.00 0 8336 32 0 0
sp_multiply_rows_for_qdistr 20412 20412 0 0.00 0 31836 161 0 0
sp_pay_from_customer 7034 7034 0 0.00 4 11253 118 0 0
sp_pay_to_supplier 5870 5870 0 0.00 5 9924 130 0 0
sp_payment_common 12904 12904 0 0.00 1 9475 31 0 0
sp_qd_handle_on_cancel_clo 1710 1710 0 0.00 0 13858 309 0 0
sp_qd_handle_on_invoice_upd_sts 10423 10423 0 0.00 0 23188 344 0 0
sp_qd_handle_on_reserve_upd_sts 9965 9965 0 0.00 0 8410 52 0 0
sp_reserve_write_off 9965 9965 0 0.00 6 16026 170 0 0
sp_supplier_invoice 5511 5511 0 0.00 6 98852 3439 0 0
sp_supplier_order 5484 5484 0 0.00 5 83102 1270 0 0
srv_aggregate_perf_data 101 101 0 0.00 2532 151634 17339 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1311 128748 31692 0 0
srv_find_qd_qs_mism 1040018 1040018 0 0.00 0 12133 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 31 22233 962 0 0
srv_make_money_saldo 771 771 0 0.00 1 604 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 99854 453266 218444 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4903 4903 0 0.00 0 12717 198 0 0
t$perf-norm:sp_cancel_adding_invoice 384 384 0 0.00 0 5924 92 0 0
t$perf-norm:sp_cancel_client_order 1710 1710 0 0.00 0 3962 14 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 608 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 666 666 0 0.00 0 842 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 531 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 325 12 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 27932 1879 0 0
t$perf-norm:sp_cancel_write_off 959 959 0 0.00 0 1169 6 0 0
t$perf-norm:sp_client_order 20412 20412 0 0.00 0 9518 20 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 1907 7 0 0
t$perf-norm:sp_pay_from_customer 7034 7034 0 0.00 0 8209 11 0 0
t$perf-norm:sp_pay_to_supplier 5870 5870 0 0.00 0 2715 8 0 0
t$perf-norm:sp_reserve_write_off 9965 9965 0 0.00 0 3586 10 0 0
t$perf-norm:sp_supplier_invoice 5511 5511 0 0.00 0 5225 23 0 0
t$perf-norm:sp_supplier_order 5484 5484 0 0.00 0 4177 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 590 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 1785 25 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 1126 24 0 0
t$perf-norm:srv_make_money_saldo 771 771 0 0.00 0 638 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 5 4 0 0
v_add_invoice_to_stock 9974 9774 200 2.00 0 3494 17 0 200
v_all_customers 37020 37020 0 0.00 0 58 1 0 0
v_all_suppliers 30800 30800 0 0.00 0 52 1 0 0
v_all_wares 40824 40824 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 768 768 0 0.00 0 1653 9 0 0
v_cancel_client_order 3420 3420 0 0.00 0 2378 6 0 0
v_cancel_customer_prepayment 1332 1332 0 0.00 0 2876 9 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 773 3 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 4181 9 0 0
v_cancel_supplier_invoice 802 794 8 0.99 0 2659 17 0 8
v_cancel_supplier_order 810 810 0 0.00 0 1469 8 0 0
v_cancel_write_off 1918 1918 0 0.00 0 1288 12 0 0
v_max_id_clo_ord 5482 5482 0 0.00 0 580 1 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 4835 16 0 0
v_max_id_ord_sup 5505 5505 0 0.00 0 4568 4 0 0
v_max_non_paid_invoice 1456 1456 0 0.00 0 2684 4 0 0
v_max_non_paid_realizn 3820 3820 0 0.00 0 5238 7 0 0
v_min_id_clo_ord 5481 5481 0 0.00 0 3893 6 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 2086 6 0 0
v_min_id_ord_sup 5505 5505 0 0.00 0 7060 4 0 0
v_min_non_paid_invoice 5870 5870 0 0.00 0 7179 18 0 0
v_min_non_paid_realizn 7034 7034 0 0.00 0 7843 20 0 0
v_our_firm 10232 10232 0 0.00 0 18 1 0 0
v_reserve_write_off 19930 19930 0 0.00 0 5743 5 0 0
x_lock_depdocs_on_canc_invoice 11344 11344 0 0.00 0 13561 117 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 13788 398 0 0
x_make_qstorno_1000_1200 5484 5484 0 0.00 2 83092 1195 0 0
x_make_qstorno_1200_2000 5511 5511 0 0.00 3 98831 3319 0 0
x_make_qstorno_2100_3300 458143 458143 0 0.00 0 63175 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-11-2020 16:32:36 to 03-11-2020 16:32:40.

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:00:44 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:00:51 16226 8192000000 10216240720 10514464768 939878528 10.292 77 56 109 1 961004816 2619920 18506368
14:01:16 26627 8192000000 10327800752 10644643840 1364699296 14.280 100 77 155 1 1393875104 4257600 24918208
14:01:54 23305 8192000000 10372787280 10694463488 1430515808 14.866 100 91 182 0 1466169280 6004848 29648624
14:02:26 19243 8192000000 10394330416 10720116736 1449331344 15.032 100 84 168 1 1483790960 7047184 27412432
14:02:57 22572 8192000000 10409285024 10737438720 1464575776 15.166 100 88 176 0 1500662768 7555728 28531264
14:03:27 31727 8192000000 10433955808 10764242944 1486293088 15.356 100 87 174 0 1522096416 7989680 27813648
14:04:10 17868 8192000000 10447498592 10783432704 1502828320 15.501 100 91 182 1 1540986592 8972704 29185568
14:04:45 13532 8192000000 10471209088 10808561664 1523341632 15.679 100 88 176 1 1560634192 9572336 27720224
14:05:16 16646 8192000000 10487058064 10835718144 1549871664 15.909 100 73 146 2 1582749152 10242464 22635024
14:05:44 16483 8192000000 10534087648 10887569408 1592726336 16.277 100 85 171 0 1629016512 10161504 26128672
14:06:13 9033 8192000000 10548874912 10903736320 1611659616 16.439 100 86 173 1 1648585712 10985520 25940576
14:06:30 12557 8192000000 10566571696 10928029696 1625065824 16.553 100 85 170 2 1661964032 11561984 25336224
14:06:52 10992 8192000000 10592699744 10955165696 1646575488 16.735 100 83 166 0 1683512992 11880112 25057392
14:07:10 11323 8192000000 10604559088 10973937664 1661775664 16.864 100 69 138 0 1693911632 11774896 20361072
14:07:30 12097 8192000000 10635955008 11003359232 1689038976 17.093 100 86 170 0 1726148496 12479904 24629616
14:07:53 7354 8192000000 10652746128 11022770176 1704107200 17.219 100 76 152 1 1738905456 12381760 22416496
14:08:11 7107 8192000000 10674490000 11045646336 1723761296 17.384 100 82 165 2 1760101792 12702656 23637840
14:08:26 7685 8192000000 10678888480 11056009216 1740455888 17.522 100 81 160 0 1776159872 13247824 22456160
14:08:41 7714 8192000000 10692593088 11068956672 1753715120 17.632 100 81 162 1 1790074400 13348064 23011216
14:08:57 4503 8192000000 10695609120 11076501504 1759425008 17.680 100 77 154 1 1794563856 13009920 22128928
14:09:11 5426 8192000000 10705645760 11086745600 1769902720 17.766 100 75 149 0 1803821216 13466992 20451504
14:09:25 4234 8192000000 10715603424 11100614656 1780789216 17.856 100 79 156 1 1815674416 12883216 22001984
14:09:36 5757 8192000000 10727450448 11109183488 1782557808 17.871 100 77 154 0 1817714032 13593952 21562272
14:09:49 3911 8192000000 10735690352 11115343872 1795303744 17.975 100 82 164 1 1830195328 12525136 22366448
14:10:00 2832 8192000000 10741000352 11124191232 1804354304 18.050 100 82 164 0 1839039888 11949488 22736096
14:10:09 3591 8192000000 10748577632 11134488576 1811335232 18.107 100 88 175 1 1848466592 13317776 23813584
14:10:21 4041 8192000000 10751669584 11139043328 1817295072 18.156 100 86 174 0 1854540912 13243312 24002528
14:10:32 2775 8192000000 10770737392 11153383424 1823016304 18.202 100 83 163 0 1859218448 12788656 23413488
14:10:41 2053 8192000000 10769942752 11154161664 1826235152 18.229 100 85 170 1 1863557360 14024336 23297872
14:10:49 7113 8192000000 10775896480 11164315648 1833063904 18.284 100 81 161 2 1868595120 14294496 21236720
14:11:03 4215 8192000000 10789056592 11175227392 1838229248 18.326 100 82 162 3 1875228656 14825344 22174064
14:11:15 1814 8192000000 10797974128 11186987008 1852465408 18.442 100 88 177 0 1891354000 14253328 24635264
14:11:23 2449 8192000000 10803134528 11188600832 1858098832 18.488 100 89 178 1 1897398560 12634448 26665280
14:11:32 2784 8192000000 10804481856 11196071936 1865221408 18.546 100 93 185 1 1904208864 13016960 25970496
14:11:42 2329 8192000000 10811885872 11204833280 1865487744 18.548 100 89 178 2 1909003088 18060496 25454848
14:11:50 2856 8192000000 10807579280 11202326528 1869678272 18.582 100 92 184 1 1908009072 11916624 26414176
14:12:00 2072 8192000000 10807979904 11203076096 1872681184 18.606 100 92 185 1 1911207248 11271744 27254320
14:12:08 1548 8192000000 10816739088 11209990144 1874873088 18.624 100 85 168 3 1910279328 10963840 24442400
14:12:16 23775 8192000000 10814482704 11217215488 1874956048 18.624 100 56 111 2 1904080960 13412928 15711984
14:12:46 2135 8192000000 10812855504 11217334272 1881628704 18.678 100 72 144 1 1912777216 11082336 20066176
14:12:55 2967 8192000000 10801733088 11216969728 1879002528 18.657 100 61 122 1 1906238624 10009328 17226768
14:13:05 1818 8192000000 10815301552 11221917696 1882534528 18.686 100 60 120 2 1909753856 10314832 16904496
14:13:13 2136 8192000000 10817600576 11227934720 1887703520 18.727 100 61 122 0 1916961584 11968016 17290048
14:13:21 2991 8192000000 10822221184 11231350784 1887069280 18.722 100 50 100 2 1911155968 9413504 14673184
14:13:31 3681 8192000000 10810990096 11224551424 1887751904 18.728 100 50 101 3 1911083472 8684224 14647344
14:13:45 9374 8192000000 10792065296 11224424448 1884767712 18.704 100 25 50 0 1898057712 6402656 6887344
14:14:00 7276 8192000000 10805222256 11228995584 1888502768 18.734 100 33 66 1 1905226448 7770512 8953168
14:14:14 3243 8192000000 10812490528 11231916032 1894950496 18.786 100 51 103 0 1917713088 8481056 14281536
14:14:27 5798 8192000000 10796282688 11232505856 1891599408 18.759 100 22 43 4 1904259056 6957920 5701728
14:14:45 12416 8192000000 10799432112 11233906688 1892507760 18.766 100 20 41 0 1905040304 7077136 5455408
14:15:04 23227 8192000000 10790306160 11236327424 1895936512 18.794 100 40 78 1 1912748336 5345712 11466112
14:15:33 52794 8192000000 10807699232 11241725952 1893456608 18.774 100 25 50 1 1910196640 9105392 7634640
14:16:37 10270 8192000000 10803250848 11242827776 1895700352 18.792 100 21 42 2 1908323136 6662080 5960704
14:16:56 6325 8192000000 10813723712 11244634112 1900459504 18.830 100 29 58 4 1914691504 5902352 8329648
14:17:11 4485 8192000000 10817767632 11249315840 1900308688 18.829 100 29 58 2 1914962752 6419776 8234288
14:17:23 4852 8192000000 10825678112 11256131584 1907192352 18.884 100 51 103 1 1929999152 8024640 14782160
14:17:36 3437 8192000000 10829639888 11255468032 1907061488 18.883 100 44 88 2 1926421312 7300480 12059344
14:17:48 6003 8192000000 10821002352 11253780480 1905089936 18.867 100 33 66 1 1921564768 7136416 9338416
14:18:02 5134 8192000000 10817460528 11250880512 1905528912 18.871 100 33 66 1 1922178832 7166784 9483136
14:18:19 3838 8192000000 10818809888 11254616064 1905662256 18.872 100 29 58 0 1920988976 7406800 7919920
14:18:33 9784 8192000000 10830182240 11257614336 1906859872 18.881 100 28 56 0 1921198816 6708256 7630688
14:18:52 5293 8192000000 10829657280 11263062016 1911240912 18.917 100 35 70 2 1929428560 8215856 9971792
14:19:04 7624 8192000000 10825010944 11263975424 1909750352 18.905 100 25 50 1 1922803584 6209712 6843520
14:19:18 8072 8192000000 10814343264 11247157248 1888674400 18.735 99 32 64 1 1903922864 5616272 9632192
14:19:34 4809 8192000000 10810599120 11248238592 1899185120 18.820 100 31 61 0 1918906832 10306912 9414800
14:19:45 22328 8192000000 10799082704 11246039040 1888818800 18.736 99 28 56 1 1903566912 5875984 8872128
14:20:34 21662 8192000000 10826998640 11223228416 1883793792 18.696 99 77 152 2 1911923024 5601392 22527840
14:21:02 8540 8192000000 10793988720 11231051776 1873129008 18.610 99 33 66 2 1890780592 8237760 9413824
14:21:19 5118 8192000000 10804506048 11222642688 1835266352 18.302 97 36 73 0 1851945248 6153216 10525680
14:21:30 6397 8192000000 10786798368 11216416768 1857866320 18.486 99 30 59 2 1873751712 6999632 8885760
14:21:43 4861 8192000000 10790121024 11221008384 1872637152 18.606 100 30 58 3 1888096128 6491520 8967456
14:21:54 7149 8192000000 10775301584 11203002368 1834529040 18.296 98 24 46 0 1847567680 6179920 6858720
14:22:08 3234 8192000000 10764173440 11180273664 1832416768 18.279 99 43 86 1 1850947776 6204720 12326288
14:22:20 4859 8192000000 10757778576 11176923136 1828936304 18.251 99 43 86 2 1848294128 6126784 13231040
14:22:32 6125 8192000000 10748054592 11169599488 1820378864 18.181 99 27 54 0 1834737568 6453296 7905408
14:22:45 7353 8192000000 10742445168 11168690176 1818769088 18.168 99 29 58 1 1833012880 6133728 8110064
14:23:02 3641 8192000000 10741302864 11164958720 1798626528 18.003 97 41 81 0 1817635232 6925968 12082736
14:23:14 5237 8192000000 10740356896 11164459008 1803027728 18.039 98 26 52 3 1815799440 4881744 7889968
14:23:26 6175 8192000000 10735724320 11163897856 1815255312 18.139 99 16 32 0 1825887136 5143888 5487936
14:23:46 8944 8192000000 10714319360 11128758272 1732971616 17.460 95 17 34 1 1751666928 14090640 4604672
14:24:01 65881 8192000000 10697057456 11121078272 1709235248 17.262 94 18 36 0 1719995968 5899168 4861552
14:25:14 9888 8192000000 10709270032 11120656384 1689369216 17.096 93 30 60 0 1703730000 6229936 8130848
14:25:31 7338 8192000000 10715137056 11122561024 1767869456 17.749 99 37 74 2 1785176544 7065504 10241584
14:25:46 4839 8192000000 10742154848 11158233088 1818620128 18.166 100 41 83 0 1838008912 7401936 11986848
14:25:59 6044 8192000000 10698068000 11112857600 1747332912 17.579 96 36 71 1 1764926512 7093600 10500000
14:26:11 3783 8192000000 10718943376 11130335232 1787464832 17.911 99 37 74 3 1805239888 7051200 10723856
14:26:23 5342 8192000000 10733686432 11146424320 1805444192 18.059 100 24 48 0 1818199136 5589280 7165664
14:26:36 10202 8192000000 10741750880 11158642688 1827194672 18.236 100 21 42 4 1838744208 5642896 5906640
14:26:54 7777 8192000000 10739529488 11162075136 1826494576 18.231 100 24 48 2 1839925968 6655360 6776032
14:27:11 7666 8192000000 10761595520 11174440960 1835214864 18.302 100 24 48 1 1847438336 5089760 7133712
14:27:26 8641 8192000000 10756262960 11182264320 1830950096 18.267 99 33 66 2 1846969040 6201760 9817184
14:27:41 10417 8192000000 10771627280 11193802752 1847440208 18.401 100 24 48 1 1860657680 6202160 7015312
14:27:58 17124 8192000000 10758509040 11186974720 1832886240 18.283 99 15 30 0 1842382960 5096896 4399824
14:28:23 28136 8192000000 10766151136 11195764736 1854494032 18.459 100 23 46 1 1867161392 5601520 7065840
14:29:23 31646 8192000000 10775656352 11209912320 1866388480 18.555 100 31 62 1 1883912304 9385600 8138224
14:30:01 11026 8192000000 10797266272 11224297472 1875707200 18.630 100 23 46 0 1886796976 5373344 5716432
14:30:18 10296 8192000000 10797241360 11223904256 1882527152 18.686 100 22 44 2 1894648704 5369920 6751632
14:30:36 15200 8192000000 10816852432 11234230272 1891965728 18.762 100 31 61 0 1905995792 5206272 8823792
14:31:01 24015 8192000000 10817437104 11245154304 1900411808 18.830 100 29 59 0 1915294752 6445552 8437392
14:31:34 21510 8192000000 10833682208 11259707392 1907160608 18.884 100 37 73 0 1925084464 7594928 10328928
14:32:05 27753 8192000000 10855399584 11273007104 1915963568 18.954 100 44 89 1 1937600416 9287232 12349616
14:32:41 15478 8192000000 10855920016 11277131776 1924765104 19.025 100 57 114 1 1950091344 9171728 16154512
14:33:10 33663 8192000000 10858858432 11283427328 1930004656 19.067 100 44 88 2 1952159792 9255344 12899792
14:34:06 19494 8192000000 10869281136 11299930112 1942407344 19.166 100 50 96 1 1967644864 11588160 13649360
14:34:35 28113 8192000000 10888312336 11316195328 1952251536 19.244 100 47 96 0 1979020336 13073344 13695456
14:35:15 12175 8192000000 10897732944 11322245120 1954672352 19.264 100 44 88 1 1980194432 12780800 12741280
14:35:35 10814 8192000000 10914079568 11334135808 1965325968 19.348 100 54 107 2 1995080320 14123664 15630688
14:35:53 9226 8192000000 10906745824 11333218304 1969647600 19.383 100 53 106 0 2000667792 15220304 15799888
14:36:11 19858 8192000000 10902804288 11337449472 1977460160 19.445 100 68 134 2 2010767952 13700240 19607552
14:36:40 15749 8192000000 10909901776 11343511552 1972812864 19.408 100 46 92 0 2001036288 14808688 13414736
14:37:29 14971 8192000000 10927873568 11354656768 1983532624 19.493 100 56 110 2 2017645424 17512960 16599840
14:37:56 16239 8192000000 10931419360 11359875072 1986412384 19.515 100 55 106 1 2018177040 16193824 15570832
14:38:21 13294 8192000000 10931249424 11363139584 1986020912 19.512 100 49 98 2 2018087136 17430320 14635904
14:38:41 12475 8192000000 10916186960 11351154688 1971231840 19.395 99 57 111 1 2006555568 17951072 17372656
14:39:09 10570 8192000000 10920646784 11358212096 1969417312 19.381 99 54 106 2 2007041328 21994192 15629824
14:39:27 9422 8192000000 10930101248 11360849920 1985496304 19.508 100 53 106 0 2018246704 17741792 15008608
14:39:51 23694 8192000000 10927806080 11367104512 1987269200 19.522 100 39 78 2 2015092432 16429472 11393760
14:40:27 9741 8192000000 10931610304 11370786816 1990773568 19.550 100 40 78 1 2018392944 15727632 11891744
14:40:45 14398 8192000000 10940583168 11373330432 1997809472 19.605 100 46 91 0 2028972704 17534576 13628656
14:41:07 11453 8192000000 10939060000 11379544064 2000551376 19.627 100 52 104 1 2034581888 18755808 15274704
14:41:28 8689 8192000000 10947971952 11377643520 1980735312 19.471 99 50 98 2 2013391424 18055744 14600368
14:41:45 10200 8192000000 10922088832 11358105600 1978949824 19.456 100 50 99 2 2012793808 19461872 14382112
14:42:08 6281 8192000000 10934868512 11371270144 1991089488 19.552 100 54 107 0 2030005200 22866560 16049152
14:42:25 3379 8192000000 10940322640 11367227392 1987586592 19.525 100 61 116 1 2027013280 22400640 17026048
14:42:38 9638 8192000000 10947634960 11375357952 1990534608 19.548 100 58 115 2 2030621904 23157344 16929952
14:42:56 6271 8192000000 10952665712 11389120512 2000431040 19.626 100 57 114 1 2041265520 23606992 17227488
14:43:18 2073 8192000000 10976589584 11398107136 2009289392 19.696 100 63 125 2 2050925232 22785264 18850576
14:43:31 5102 8192000000 10975852256 11411722240 2020166768 19.781 100 59 114 1 2063762992 26127728 17468496
14:43:56 14097 8192000000 10959234496 11399880704 2007595120 19.683 100 53 106 1 2049801936 25276656 16930160
14:44:24 6911 8192000000 10960517648 11400568832 2012200192 19.719 100 48 94 1 2049353712 22621952 14531568
14:44:39 8291 8192000000 10967440912 11400626176 2001599744 19.635 99 59 118 2 2041916240 22437264 17879232
14:44:57 5627 8192000000 10981590976 11411652608 2018001024 19.764 100 72 144 2 2064212464 24619840 21591600
14:45:22 5506 8192000000 10973308112 11407601664 2016000688 19.749 100 60 119 0 2061665872 27003408 18661776
14:45:35 1866 8192000000 10989971840 11414757376 2020019568 19.780 100 74 148 0 2069651424 27259312 22372544
14:45:43 3092 8192000000 10987414400 11416330240 2021269728 19.790 100 80 160 3 2075669632 29943136 24456768
14:46:01 3955 8192000000 10989138368 11420479488 2019134608 19.773 100 68 133 0 2069361536 29585440 20641488
14:46:20 4337 8192000000 10969991136 11409379328 2011611792 19.714 100 65 128 1 2062586704 31227440 19747472
14:46:35 16678 8192000000 10983549200 11419357184 2019662576 19.777 100 67 132 1 2071088352 30810608 20615168
14:47:03 10482 8192000000 10982160592 11416379392 2008283008 19.688 99 61 122 2 2062685888 35090240 19312640
14:47:21 5341 8192000000 10983967792 11423379456 2018680560 19.770 100 64 126 1 2075976432 36348976 20946896
14:47:34 2627 8192000000 10997239552 11426574336 2023596960 19.808 100 75 148 3 2081148704 34967392 22584352
14:47:47 8881 8192000000 10990321472 11427229696 2019901680 19.779 100 57 114 1 2070902960 33095552 17905728
14:48:12 7542 8192000000 10966127952 11411472384 2003659296 19.652 100 53 106 0 2056585840 35241792 17684752
14:48:27 7152 8192000000 10959240800 11397578752 1996989088 19.599 100 53 106 0 2045522720 31091568 17442064
14:48:41 5059 8192000000 10957840496 11389849600 1985057568 19.505 99 64 127 2 2033252288 28719024 19475696
14:48:54 13160 8192000000 10962603552 11390705664 1994337920 19.578 100 68 133 1 2043081952 28825248 19918784
14:49:16 2807 8192000000 10962633376 11389652992 1988257200 19.530 99 78 156 0 2040521968 27552768 24712000
14:49:25 4111 8192000000 10967106512 11398246400 2002714384 19.644 100 84 166 0 2056448928 28565472 25169072
14:49:36 4588 8192000000 10960060400 11379326976 1971738320 19.399 99 78 153 2 2024932432 29292880 23901232
14:49:49 2667 8192000000 10965857632 11388059648 1994973344 19.583 100 77 155 3 2045477440 27287376 23216720
14:50:00 2685 8192000000 10963709392 11379843072 1987061824 19.521 100 89 180 1 2043769904 29455056 27253024
14:50:10 5305 8192000000 10951949488 11368902656 1978038656 19.449 100 75 149 0 2030192672 29169200 22984816
14:50:23 2958 8192000000 10972900016 11387957248 1990910800 19.551 100 85 170 2 2047834128 31256416 25666912
14:50:34 2924 8192000000 10952215616 11365588992 1958519232 19.294 99 86 173 0 2014924624 30719088 25686304
14:50:45 6008 8192000000 10946666432 11364904960 1971576336 19.398 100 90 179 1 2028706880 29833248 27297296
14:50:59 1481 8192000000 10960033200 11374567424 1981360432 19.475 100 91 183 0 2040865456 31898272 27606752
14:51:08 4944 8192000000 10962652304 11384090624 1987139632 19.521 100 82 164 2 2045128304 32714336 25274336
14:51:24 2515 8192000000 10963221008 11383255040 1985193104 19.506 100 82 164 2 2044009344 32421568 26394672
14:51:34 7616 8192000000 10960192704 11384938496 1970811904 19.392 99 72 143 1 2025506656 32977696 21717056
14:51:50 3286 8192000000 10937812992 11356069888 1962019696 19.322 99 74 148 1 2020494320 35294864 23179760
14:52:01 1311 8192000000 10953241200 11365535744 1973053984 19.410 100 81 161 2 2033582880 35527856 25001040
14:52:10 2315 8192000000 10967476960 11377983488 1974629168 19.422 100 95 190 0 2042286976 38046064 29611744
14:52:20 6216 8192000000 10946306336 11379011584 1974463664 19.421 100 67 134 0 2035638624 39433856 21741104
14:52:41 3765 8192000000 10927492928 11356778496 1948809488 19.217 99 64 127 2 1999345152 30213168 20322496
14:52:52 2083 8192000000 10922994960 11355865088 1964621472 19.343 100 50 101 0 2009116784 28096016 16399296
14:53:01 22198 8192000000 10920835488 11362181120 1943915232 19.178 99 35 68 2 1980596608 25247600 11433776
14:53:38 2297 8192000000 10927219808 11360329728 1970324032 19.388 100 41 82 1 2007709536 24115328 13270176
14:53:48 5882 8192000000 10943353792 11380707328 1980884704 19.472 100 50 100 0 2026514144 29919392 15710048
14:54:05 6100 8192000000 10938801344 11374784512 1981223616 19.474 100 51 102 1 2024619104 27432000 15963488
14:54:20 2236 8192000000 10941776448 11373805568 1975858320 19.432 100 58 116 0 2024253728 30178624 18216784
14:54:30 15249 8192000000 10923875152 11367641088 1957804720 19.289 99 41 82 1 1998035408 26949952 13280736
14:54:55 1949 8192000000 10915273008 11342409728 1933786768 19.097 98 53 106 0 1979698704 28737104 17174832
14:55:05 9765 8192000000 10941994768 11379736576 1949116224 19.219 99 51 102 1 2013960608 48751152 16093232
14:55:22 6815 8192000000 10915928272 11356737536 1946229472 19.196 99 55 110 1 1996748736 32405488 18113776
14:55:52 13819 8192000000 10901694176 11339132928 1936282176 19.117 99 36 72 0 1977576896 29704288 11590432
14:56:25 8842 8192000000 10887009696 11333214208 1934050352 19.099 100 24 48 0 1974986544 31702640 9233552
14:56:48 25787 8192000000 10884139456 11339509760 1933992496 19.099 100 19 38 0 1973832640 33644848 6195296
14:57:24 15480 8192000000 10871404960 11312648192 1913198064 18.932 99 26 51 0 1947622112 26185824 8238224
14:57:46 14583 8192000000 10895246800 11336650752 1935016512 19.107 100 29 58 0 1974640544 29399600 10224432
14:58:08 12967 8192000000 10869220208 11309772800 1903570128 18.855 99 25 50 0 1944452912 32072352 8810432
14:58:32 21653 8192000000 10884765456 11325800448 1908042272 18.891 99 25 50 2 1949171456 31437600 9691584
14:59:02 14898 8192000000 10865863200 11329843200 1910406384 18.910 99 48 97 0 1960899936 35070496 15423056
14:59:33 22519 8192000000 10864005584 11311312896 1913442288 18.934 100 19 38 1 1939562944 19797968 6322688
15:00:10 28992 8192000000 10850416896 11287937024 1892070400 18.762 99 22 43 1 1921064544 21975104 7019040
15:00:49 33838 8192000000 10857106928 11299946496 1882884800 18.688 98 19 37 2 1914828144 25885728 6057616
15:01:33 38038 8192000000 10875439824 11323813888 1929377488 19.062 100 17 34 2 1959848784 25928144 4543152
15:02:26 30213 8192000000 10861181968 11304083456 1890566560 18.750 98 11 22 1 1918250176 24484368 3199248
15:03:09 3434 8192000000 10870769360 11308224512 1924504032 19.023 100 36 73 2 1955332416 20246176 10582208
15:03:29 35046 8192000000 10840830864 11307061248 1891896496 18.761 99 7 14 1 1911679552 18098816 1684240
15:04:11 98921 8192000000 10816504912 11255545856 1817151936 18.154 95 29 58 1 1832733088 6715904 8865248
15:06:55 27548 8192000000 10841183872 11288965120 1881697152 18.679 98 30 60 2 1899476416 8910992 8868272
15:07:34 18717 8192000000 10861364656 11295866880 1869026720 18.576 97 40 80 1 1891548176 10942192 11579264
15:08:05 9161 8192000000 10872202656 11305619456 1926224912 19.037 100 67 129 1 1955241264 9694576 19321776
15:08:23 8108 8192000000 10856807568 11313573888 1927523904 19.047 100 38 74 0 1949440944 11318928 10598112
15:08:38 67345 8192000000 10863171632 11324792832 1892351952 18.765 98 14 28 0 1912012080 15747904 3912224
15:10:02 68885 8192000000 10884329248 11337928704 1927501968 19.047 99 25 50 2 1951251168 16872992 6876208
15:11:20 41356 8192000000 10899064880 11346493440 1951826112 19.241 100 31 63 0 1977966784 17026160 9114512
15:12:08 35158 8192000000 10876340704 11347767296 1953127680 19.251 100 21 42 1 1975014576 15241776 6645120
15:12:54 79809 8192000000 10881426512 11340836864 1931775648 19.081 99 13 26 1 1950193424 14452592 3965184
15:14:21 43389 8192000000 10864625952 11318456320 1917564256 18.967 99 9 18 1 1929437616 9544976 2328384
15:15:12 51878 8192000000 10854846720 11324411904 1939575808 19.143 100 17 32 1 1952111840 7804352 4731680
15:16:10 52741 8192000000 10875092800 11342503936 1946849376 19.201 100 10 20 1 1956720208 6930736 2940096
15:17:09 29877 8192000000 10882185584 11352035328 1963244288 19.332 100 20 40 0 1980490864 11461872 5784704
15:17:45 44253 8192000000 10884128928 11353714688 1961954032 19.322 100 20 40 0 1980029552 12384224 5691296
15:18:36 62821 8192000000 10906138064 11362275328 1967845776 19.368 100 25 50 0 1993197904 18141520 7210608
15:19:48 68563 8192000000 10880922368 11366719488 1962519984 19.326 100 16 31 0 1978778384 10923488 5334912
15:21:11 49865 8192000000 10866546000 11345588224 1921174448 18.996 98 9 18 2 1931242176 7423152 2644576
15:22:07 40079 8192000000 10904564672 11353624576 1926106736 19.036 98 30 60 2 1945145552 10336272 8702544
15:23:27 72200 8192000000 10879968880 11369766912 1927463152 19.047 98 11 22 1 1946047200 15607328 2976720
15:25:05 69207 8192000000 10897370400 11368923136 1954031888 19.259 99 12 24 0 1974289648 16723312 3534448
15:26:21 59475 8192000000 10903603760 11361525760 1944684064 19.184 99 19 38 0 1967983904 17547440 5752400
15:27:30 39818 8192000000 10909354928 11371401216 1948431216 19.214 99 24 48 0 1969884528 14839376 6613936
15:28:20 108330 8192000000 10899373072 11368697856 1914760048 18.945 97 8 16 0 1933413088 15951248 2701792
15:30:14 68901 8192000000 10912915952 11370315776 1961760368 19.320 99 17 34 0 1979322592 13325728 4236496
15:31:30 13842 8192000000 10907514432 11355877376 1940475072 19.151 98 33 66 0 1957891776 8347520 9069184
15:31:52 66379 8192000000 10922291632 11375497216 1959238512 19.300 99 29 58 1 1979521072 12770784 7511776
15:33:09 39848 8192000000 10914689456 11389489152 1978783696 19.455 100 23 46 2 2002222576 16800080 6638800
15:34:08 81737 8192000000 10904326480 11375132672 1881595984 18.678 95 7 14 0 1898076048 14586432 1893632
15:35:56 128748 8192000000 10904363616 11377868800 1960392544 19.309 99 43 86 1 1987448608 14910112 12145952
15:38:19 69152 8192000000 10901974560 11381510144 1962911088 19.329 100 20 40 0 1994705456 25853568 5940800
15:39:36 25739 8192000000 10896094784 11354075136 1937540864 19.127 99 20 40 0 1959847840 16700416 5606560
15:40:19 60765 8192000000 10886162448 11367149568 1969273936 19.380 100 17 34 0 1982157968 8540048 4343984
15:41:26 59105 8192000000 10846221760 11317288960 1895230208 18.788 96 7 14 0 1905108192 7918944 1959040
15:42:31 53046 8192000000 10861746688 11326861312 1904992496 18.866 98 8 16 0 1916803248 9176112 2634640
15:43:39 40485 8192000000 10859641616 11332161536 1920333984 18.990 99 20 40 0 1940317008 13791168 6191856
15:44:46 34941 8192000000 10854673600 11331129344 1924070368 19.019 99 13 26 0 1937488032 9722896 3694768
15:45:28 58317 8192000000 10828806400 11295756288 1875809696 18.631 97 25 49 1 1891864144 8658480 7395968
15:46:35 84898 8192000000 10853056432 11329060864 1904253568 18.860 98 13 24 0 1922418160 14706176 3458416
15:48:08 42755 8192000000 10861431488 11335593984 1910413296 18.910 98 20 40 1 1928463808 12352288 5698224
15:49:01 68530 8192000000 10875701584 11349139456 1931992752 19.083 99 11 22 0 1946411472 11398304 3020416
15:50:25 72793 8192000000 10877416976 11346259968 1913406464 18.934 98 14 28 1 1933760032 15871904 4481664
15:51:56 95326 8192000000 10838203248 11296849920 1766226304 17.736 91 6 12 0 1778979200 11062144 1690752
15:53:56 19552 8192000000 10856463728 11307487232 1901631472 18.839 98 39 78 0 1921964736 8822848 11510416
15:54:33 54920 8192000000 10846824000 11306274816 1851055376 18.431 96 30 60 0 1867993696 8496912 8441408
15:55:37 46453 8192000000 10856953600 11320721408 1904914128 18.866 99 24 48 1 1924363584 12863792 6585664
15:56:30 46505 8192000000 10877194288 11331858432 1920428448 18.990 99 29 58 3 1938614400 10309744 7876208
15:57:24 35182 8192000000 10868756576 11336376320 1921914304 19.002 99 29 58 2 1942277840 12325088 8038448
15:58:21 65105 8192000000 10854165808 11310440448 1815724800 18.143 94 20 40 1 1829697760 8522656 5450304
15:59:38 43876 8192000000 10843432416 11298910208 1871038880 18.593 97 31 61 1 1896469104 17453184 7977040
16:00:30 41770 8192000000 10860051360 11306594304 1885459808 18.709 98 42 84 1 1909262624 12340880 11461936
16:01:19 61752 8192000000 10869156416 11320950784 1860694352 18.509 96 22 42 3 1876454432 9589488 6170592
16:02:33 83875 8192000000 10859016352 11332091904 1897229872 18.804 98 26 52 0 1922910064 18268256 7411936
16:04:10 91155 8192000000 10886653024 11352326144 1919148448 18.980 99 11 22 0 1934589984 12785040 2656496
16:05:48 92206 8192000000 10883920064 11347718144 1910218448 18.908 98 11 22 0 1931092368 17761344 3112576
16:07:34 46847 8192000000 10868650560 11342864384 1945066160 19.187 100 7 14 0 1959103728 11988944 2048624
16:08:31 84898 8192000000 10881472176 11349188608 1937404064 19.126 99 20 40 0 1952867968 10001200 5462704
16:10:06 1944 8192000000 10887915136 11343937536 1938843616 19.138 99 35 69 0 1958228832 9748672 9636544
16:10:14 32846 8192000000 10849071936 11319902208 1910464080 18.910 98 13 26 0 1923382464 9332720 3585664
16:10:55 35372 8192000000 10851871984 11323781120 1908241056 18.893 98 13 26 0 1918670384 7267616 3161712
16:11:36 53266 8192000000 10861791664 11331657728 1923784864 19.017 99 10 20 0 1935966800 9343184 2838752
16:13:05 64751 8192000000 10893957024 11343532032 1945863376 19.194 100 16 32 2 1967312448 16436432 5012640
16:14:16 73070 8192000000 10870319312 11351535616 1953485248 19.254 100 15 29 1 1974029376 16681680 3862448
16:15:41 37113 8192000000 10874212176 11342725120 1937490432 19.127 99 25 49 2 1953327216 9338672 6498112
16:16:24 67578 8192000000 10867408336 11345068032 1918480272 18.975 98 16 32 0 1934037872 10849824 4707776
16:17:38 91444 8192000000 10886894592 11353333760 1887833504 18.728 96 17 34 2 1904183024 11640128 4709392
16:19:31 52004 8192000000 10892957824 11340210176 1924953936 19.027 98 32 64 1 1943918704 9349136 9615632
16:20:36 65683 8192000000 10895983776 11361832960 1948451584 19.214 99 22 44 3 1966408448 11829424 6127440
16:21:48 54540 8192000000 10917931184 11383926784 1978603072 19.454 100 26 50 2 1997863472 12199760 7060640
16:23:05 38397 8192000000 10915059584 11374542848 1964148208 19.339 99 32 65 1 1985511168 12341984 9020976
16:23:50 61523 8192000000 10928134928 11375435776 1979648672 19.462 100 14 28 1 1990951440 7570720 3732048
16:24:58 19231 8192000000 10910289536 11366141952 1931575968 19.079 97 24 48 1 1950957072 12634080 6747024
16:25:28 56709 8192000000 10870367632 11340804096 1893028128 18.770 96 28 56 3 1911281088 10499088 7753872
16:26:41 50637 8192000000 10877678768 11341406208 1882976672 18.689 96 23 46 0 1904820928 15786880 6057376
16:27:38 103797 8192000000 10899687072 11356626944 1914552960 18.943 98 15 30 0 1938499056 20023344 3922752
16:29:34 103641 8192000000 8848750656 8982437888 26636784 0.324 2 2 4 0 30160640 3019968 503888

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-11-2020 16:32:42 to 03-11-2020 16:33:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-11-2020 16:33:15 to 03-11-2020 16:33:17.

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          232803
MON$OLDEST_ACTIVE               234181
MON$OLDEST_SNAPSHOT             234181
MON$NEXT_TRANSACTION            234181
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                       2006912
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33384 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33384 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33384 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33384 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    Tue Nov  3 16:31:19 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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