Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.02.2021 16:27
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 17354884 kB
MemAvailable 31089084 kB
Buffers 0 kB
Cached 14321732 kB
SwapCached 3892 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-23 16:27:19
DTS_END                         2021-02-23 16:27:19.9810
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46056
TRN_ID                          235452
ATT_ID                          592
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: 9019.62 20123 1082354
customer order: creation 170.24 390 20429
customer order: refuse 14.62 337 1754
order to supplier: creation 45.15 1304 5418
order to supplier: removal 3.28 104770 394
invoice (draft): creation 44.77 3155 5372
invoice (draft): removal 49.08 872 5890
invoice accept: apply 41.72 18755 5006
invoice accept: cancel 44.78 805 5373
customer reserve: creation 3924.11 183 470893
customer reserve: removal 4387.91 61 526549
realization accept: apply 82.49 169 9899
realization accept: cancel 82.32 124 9878
payment from customer: creation 59.48 121 7138
payment from customer: removal 5.62 95 674
payment to supplier: creation 48.03 126 5763
payment to supplier: removal 3.50 101 420
service: total inventory turnovers 5.09 868 611
service: total monetary turnovers 6.55 22 786
service: aggregate perf. data 0.86 16426 103
service: refresh index statistics 0.03 253771 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2021 16:28:03 to 23-02-2021 16:28:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5017
TEST_TIME 2 5570
TEST_TIME 3 5321
TEST_TIME 4 5455
TEST_TIME 5 5381
TEST_TIME 6 6020
TEST_TIME 7 6083
TEST_TIME 8 6058
TEST_TIME 9 5859
TEST_TIME 10 6226
TEST_TIME 11 6205
TEST_TIME 12 6269
TEST_TIME 13 6649
TEST_TIME 14 6858
TEST_TIME 15 7395
TEST_TIME 16 7780
TEST_TIME 17 8305
TEST_TIME 18 8255
TEST_TIME 19 8288
TEST_TIME 20 8412
TEST_TIME 21 8659
TEST_TIME 22 8990
TEST_TIME 23 9717
TEST_TIME 24 10028
TEST_TIME 25 10356
TEST_TIME 26 11053
TEST_TIME 27 10770
TEST_TIME 28 10829
TEST_TIME 29 10657
TEST_TIME 30 10456
TEST_TIME 31 10220
TEST_TIME 32 10043
TEST_TIME 33 10131
TEST_TIME 34 10027
TEST_TIME 35 9945
TEST_TIME 36 9693
TEST_TIME 37 9636
TEST_TIME 38 9479
TEST_TIME 39 9340
TEST_TIME 40 9310
TEST_TIME 41 9379
TEST_TIME 42 9376
TEST_TIME 43 9328
TEST_TIME 44 9176
TEST_TIME 45 9131
TEST_TIME 46 9239
TEST_TIME 47 9207
TEST_TIME 48 9192
TEST_TIME 49 9362
TEST_TIME 50 9397
TEST_TIME 51 9353
TEST_TIME 52 9349
TEST_TIME 53 9340
TEST_TIME 54 9430
TEST_TIME 55 9434
TEST_TIME 56 9428
TEST_TIME 57 9407
TEST_TIME 58 9354
TEST_TIME 59 9245
TEST_TIME 60 9199
TEST_TIME 61 9179
TEST_TIME 62 9111
TEST_TIME 63 9034
TEST_TIME 64 8946
TEST_TIME 65 8915
TEST_TIME 66 8988
TEST_TIME 67 9147
TEST_TIME 68 9089
TEST_TIME 69 9116
TEST_TIME 70 9113
TEST_TIME 71 9138
TEST_TIME 72 9086
TEST_TIME 73 9160
TEST_TIME 74 9203
TEST_TIME 75 9183
TEST_TIME 76 9345
TEST_TIME 77 9275
TEST_TIME 78 9302
TEST_TIME 79 9205
TEST_TIME 80 9124
TEST_TIME 81 9111
TEST_TIME 82 9066
TEST_TIME 83 9070
TEST_TIME 84 9040
TEST_TIME 85 8957
TEST_TIME 86 9001
TEST_TIME 87 8988
TEST_TIME 88 8994
TEST_TIME 89 8968
TEST_TIME 90 8941
TEST_TIME 91 8968
TEST_TIME 92 9017
TEST_TIME 93 9029
TEST_TIME 94 9032
TEST_TIME 95 9056
TEST_TIME 96 9064
TEST_TIME 97 9042
TEST_TIME 98 9079
TEST_TIME 99 9063
TEST_TIME 100 9089
TEST_TIME 101 9024
TEST_TIME 102 8946
TEST_TIME 103 9002
TEST_TIME 104 9042
TEST_TIME 105 8999
TEST_TIME 106 8984
TEST_TIME 107 8979
TEST_TIME 108 8939
TEST_TIME 109 8987
TEST_TIME 110 8985
TEST_TIME 111 8996
TEST_TIME 112 9002
TEST_TIME 113 9007
TEST_TIME 114 8993
TEST_TIME 115 8978
TEST_TIME 116 9029
TEST_TIME 117 9028
TEST_TIME 118 9006
TEST_TIME 119 9043
TEST_TIME 120 9029

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-02-2021 16:28:06 to 23-02-2021 16:28:10.

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 1516540 1516540 0 0.00 0 34056 7 0 0
doc_list_biud 1516540 1516540 0 0.00 0 28684 27 0 0
sp_add_invoice_to_stock 5154 5006 148 2.87 36 249597 18756 0 148
sp_cancel_adding_invoice 5373 5373 0 0.00 5 79120 806 0 0
sp_cancel_client_order 1754 1754 0 0.00 4 8639 337 0 0
sp_cancel_customer_reserve 526549 526549 0 0.00 1 26700 62 0 0
sp_cancel_pay_from_customer 674 674 0 0.00 3 7462 96 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 3 12219 102 0 0
sp_cancel_supplier_invoice 5905 5890 15 0.25 2 27749 872 0 15
sp_cancel_supplier_order 394 394 0 0.00 6 954969 104770 0 0
sp_cancel_write_off 9878 9878 0 0.00 1 24389 124 0 0
sp_client_order 20429 20429 0 0.00 3 31708 391 0 0
sp_customer_reserve 470893 470893 0 0.00 0 113478 183 0 0
sp_fill_shopping_cart 31212 31212 0 0.00 1 11326 36 0 0
sp_fill_shopping_cart_clo_res 470874 470874 0 0.00 0 22829 15 0 0
sp_get_clo_for_invoice 4987 4987 0 0.00 0 26552 308 0 0
sp_kill_cost_storno 16345 16345 0 0.00 0 23545 68 0 0
sp_kill_qstorno_ret_qs2qd 1069260 1069260 0 0.00 0 27741 34 0 0
sp_kill_qty_storno 564724 564724 0 0.00 0 28683 72 0 0
sp_lock_selected_doc 20612 20612 0 0.00 0 9094 5 0 0
sp_make_cost_storno 27787 27787 0 0.00 0 34023 55 0 0
sp_multiply_rows_for_pdistr 27787 27787 0 0.00 0 11285 25 0 0
sp_multiply_rows_for_qdistr 20429 20429 0 0.00 0 17592 164 0 0
sp_pay_from_customer 7138 7138 0 0.00 4 37976 122 0 0
sp_pay_to_supplier 5763 5763 0 0.00 5 28533 127 0 0
sp_payment_common 12901 12901 0 0.00 1 37971 27 0 0
sp_qd_handle_on_cancel_clo 1754 1754 0 0.00 0 8587 317 0 0
sp_qd_handle_on_invoice_upd_sts 10360 10360 0 0.00 0 28681 309 0 0
sp_qd_handle_on_reserve_upd_sts 9899 9899 0 0.00 0 10108 53 0 0
sp_reserve_write_off 9899 9899 0 0.00 6 17601 170 0 0
sp_supplier_invoice 5372 5372 0 0.00 6 87058 3156 0 0
sp_supplier_order 5418 5418 0 0.00 5 38799 1305 0 0
srv_aggregate_perf_data 103 103 0 0.00 2820 141668 16427 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1337 156049 36297 0 0
srv_find_qd_qs_mism 1033646 1033646 0 0.00 0 19537 6 0 0
srv_make_invnt_saldo 611 611 0 0.00 40 25398 869 0 0
srv_make_money_saldo 786 786 0 0.00 1 3148 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 178097 304540 253772 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5006 5006 0 0.00 0 11993 145 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 1 5745 107 0 0
t$perf-norm:sp_cancel_client_order 1754 1754 0 0.00 0 2908 13 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 3700 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 674 674 0 0.00 0 1287 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 726 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 1493 23 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 13553 1456 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 4741 13 0 0
t$perf-norm:sp_client_order 20429 20429 0 0.00 0 16174 16 0 0
t$perf-norm:sp_customer_reserve 955 955 0 0.00 0 6421 10 0 0
t$perf-norm:sp_pay_from_customer 7138 7138 0 0.00 0 16173 14 0 0
t$perf-norm:sp_pay_to_supplier 5763 5763 0 0.00 0 5409 10 0 0
t$perf-norm:sp_reserve_write_off 9899 9899 0 0.00 0 11598 12 0 0
t$perf-norm:sp_supplier_invoice 5372 5372 0 0.00 0 5786 19 0 0
t$perf-norm:sp_supplier_order 5419 5419 0 0.00 0 7005 20 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 243 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 770 6 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 2175 22 0 0
t$perf-norm:srv_make_money_saldo 786 786 0 0.00 0 2281 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10262 9966 296 2.88 0 11218 20 0 296
v_all_customers 37864 37864 0 0.00 0 265 1 0 0
v_all_suppliers 29914 29914 0 0.00 0 16 1 0 0
v_all_wares 40858 40858 0 0.00 0 122 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 5223 19 0 0
v_cancel_client_order 3508 3508 0 0.00 0 1307 4 0 0
v_cancel_customer_prepayment 1348 1348 0 0.00 0 4382 10 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 6897 11 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 1969 6 0 0
v_cancel_supplier_invoice 802 772 30 3.74 0 2177 18 0 30
v_cancel_supplier_order 788 788 0 0.00 0 3218 12 0 0
v_cancel_write_off 2008 2008 0 0.00 0 903 13 0 0
v_max_id_clo_ord 5416 5416 0 0.00 0 1480 2 0 0
v_max_id_clo_res 955 955 0 0.00 0 3082 11 0 0
v_max_id_ord_sup 5367 5367 0 0.00 0 5537 4 0 0
v_max_non_paid_invoice 1589 1589 0 0.00 0 951 3 0 0
v_max_non_paid_realizn 3578 3578 0 0.00 0 3316 5 0 0
v_min_id_clo_ord 5416 5416 0 0.00 0 2975 5 0 0
v_min_id_clo_res 955 955 0 0.00 0 1484 7 0 0
v_min_id_ord_sup 5367 5367 0 0.00 0 3856 6 0 0
v_min_non_paid_invoice 5763 5763 0 0.00 0 8357 15 0 0
v_min_non_paid_realizn 7138 7138 0 0.00 0 37969 18 0 0
v_our_firm 10114 10114 0 0.00 0 38 1 0 0
v_reserve_write_off 19796 19796 0 0.00 0 11456 8 0 0
x_lock_depdocs_on_canc_invoice 10877 10877 0 0.00 0 26553 123 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 20990 428 0 0
x_make_qstorno_1000_1200 5418 5418 0 0.00 1 38764 1231 0 0
x_make_qstorno_1200_2000 5372 5372 0 0.00 3 87053 3027 0 0
x_make_qstorno_2100_3300 470893 470893 0 0.00 0 113478 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2021 16:28:11 to 23-02-2021 16:28:15.

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
13:57:23 2 8192000000 8799090208 8809906176 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:30 20826 8192000000 10262288480 10570833920 878596224 9.686 69 54 108 1 899548368 2685920 18266224
13:58:03 41065 8192000000 10353652992 10671099904 1400632704 14.601 100 91 181 1 1436666288 5942192 30091392
13:58:52 28693 8192000000 10380161248 10704093184 1435340736 14.909 100 93 187 0 1473513088 7458528 30713824
13:59:35 14439 8192000000 10399366736 10726465536 1454418912 15.077 100 86 172 0 1490631280 8105152 28107216
14:00:02 10344 8192000000 10420485872 10747146240 1475985008 15.266 100 91 182 1 1514430720 8692112 29753600
14:00:24 12597 8192000000 10428284592 10759417856 1480957616 15.310 100 86 172 0 1518295824 9044528 28293680
14:00:46 30277 8192000000 10446450656 10785370112 1502991984 15.502 100 82 164 0 1538417776 9303392 26122400
14:01:26 12653 8192000000 10462923008 10805043200 1524006176 15.685 100 80 160 0 1558282688 9406624 24869888
14:01:50 24715 8192000000 10513008768 10860204032 1557174048 15.972 100 84 167 2 1593504688 10237648 26092992
14:02:27 18786 8192000000 10533286752 10890235904 1594023088 16.288 100 83 166 4 1630091536 10872752 25195696
14:02:56 16910 8192000000 10576989584 10935275520 1635384064 16.641 100 83 168 0 1671429088 11337856 24707168
14:03:21 13529 8192000000 10596600656 10954936320 1654211104 16.800 100 88 177 0 1693122832 12692832 26218896
14:03:45 9478 8192000000 10610286976 10974806016 1671400992 16.945 100 83 165 0 1707907136 12526736 23979408
14:04:01 9432 8192000000 10631250416 10999173120 1685073008 17.060 100 80 159 3 1721080816 12713504 23294304
14:04:18 7254 8192000000 10650290576 11018846208 1707157104 17.245 100 78 156 1 1742317072 12193760 22966208
14:04:33 6806 8192000000 10667549376 11039240192 1726488304 17.406 100 86 170 0 1762443296 11844016 24110976
14:04:48 7553 8192000000 10666195632 11041476608 1734492480 17.473 100 74 148 1 1767434544 12095184 20846880
14:05:03 5766 8192000000 10689099872 11063181312 1749953184 17.601 100 82 158 2 1784450544 11620288 22877072
14:05:16 5806 8192000000 10711330416 11084300288 1769477488 17.763 100 89 178 1 1807667408 12986048 25203872
14:05:29 5159 8192000000 10711144608 11089203200 1773747264 17.798 100 82 164 3 1810934672 14472512 22714896
14:05:41 4692 8192000000 10718149232 11095273472 1779011760 17.841 100 82 161 2 1815775888 14658800 22105328
14:05:52 5052 8192000000 10728777488 11105845248 1782365744 17.869 100 85 170 0 1820470848 14876656 23228448
14:06:05 4263 8192000000 10738652816 11116953600 1788830288 17.922 100 81 162 2 1826394320 14893504 22670528
14:06:17 8002 8192000000 10736336496 11117604864 1797364272 17.992 100 84 166 1 1833792064 14107024 22320768
14:06:32 6425 8192000000 10741721776 11121422336 1800886544 18.021 100 80 160 0 1838055120 14775456 22393120
14:06:45 2457 8192000000 10760632320 11146878976 1820702656 18.183 100 83 165 1 1857523936 13727840 23093440
14:06:54 2731 8192000000 10773527776 11155095552 1829112752 18.252 100 83 161 1 1864113712 13184944 21816016
14:07:04 3023 8192000000 10771752096 11156602880 1832959952 18.283 100 85 170 2 1870686720 13712544 24014224
14:07:14 3243 8192000000 10775498640 11161391104 1836958224 18.316 100 89 176 3 1876079072 14203168 24917680
14:07:23 1818 8192000000 10787905360 11170594816 1838838240 18.331 100 92 184 2 1878219744 13466160 25915344
14:07:32 2337 8192000000 10788304256 11172306944 1845539424 18.386 100 89 178 0 1884451168 14206192 24705552
14:07:40 3104 8192000000 10797647552 11179843584 1856895648 18.478 100 93 187 0 1897297584 13442832 26959104
14:07:51 3270 8192000000 10788896480 11179974656 1854390320 18.458 100 87 172 1 1891867168 12448176 25028672
14:08:02 2920 8192000000 10791360272 11182305280 1855497760 18.467 100 82 166 1 1895266528 16557952 23210816
14:08:12 2358 8192000000 10803784064 11192176640 1858987376 18.495 100 91 181 2 1897243840 12424272 25832192
14:08:20 1604 8192000000 10806730768 11193229312 1860178352 18.505 100 92 185 1 1898799408 12765712 25855344
14:08:28 1907 8192000000 10807150944 11199057920 1866161776 18.553 100 92 183 1 1904734880 13026432 25546672
14:08:36 2701 8192000000 10809281024 11197992960 1866080288 18.553 100 90 178 0 1905355168 13852928 25421952
14:08:46 2950 8192000000 10815106080 11205369856 1873043872 18.609 100 94 187 0 1912977856 13808368 26125616
14:08:55 1248 8192000000 10819682096 11207360512 1871705696 18.598 100 86 172 4 1909203008 13118704 24378608
14:09:03 23062 8192000000 10804223840 11205574656 1871093088 18.593 100 64 128 1 1900476144 10957184 18425872
14:09:34 13240 8192000000 10812223392 11209437184 1872901808 18.608 100 73 145 4 1903483632 10312624 20269200
14:09:53 1991 8192000000 10826118272 11218743296 1883340352 18.692 100 91 182 2 1922091600 12070272 26680976
14:10:02 6629 8192000000 10830226352 11221110784 1882377984 18.684 100 86 174 0 1921514368 13955344 25181040
14:10:14 1911 8192000000 10832350080 11225305088 1888433104 18.733 100 85 170 1 1925843872 12603216 24807552
14:10:25 4020 8192000000 10817637216 11230179328 1883500656 18.693 100 57 111 1 1910132880 10879600 15752624
14:10:36 2979 8192000000 10808565584 11220992000 1885065200 18.706 100 50 99 1 1907605776 8632016 13908560
14:10:46 4819 8192000000 10803646512 11220275200 1884402496 18.701 100 37 74 2 1903807568 9465808 9939264
14:10:59 3207 8192000000 10802506416 11224924160 1888307568 18.732 100 46 92 0 1910970448 10040736 12622144
14:11:09 9564 8192000000 10788747840 11220434944 1885444320 18.709 100 30 60 0 1900404384 6380704 8579360
14:11:25 5551 8192000000 10819877856 11226726400 1889646928 18.743 100 31 62 0 1904707616 6183072 8877616
14:11:38 8090 8192000000 10808855504 11231830016 1893560880 18.774 100 33 66 1 1910541616 8105840 8874896
14:11:55 5557 8192000000 10805271120 11231784960 1896621872 18.799 100 30 60 2 1912901920 7304848 8975200
14:12:08 6530 8192000000 10803032096 11230879744 1895136864 18.787 100 25 50 1 1908840720 6576912 7126944
14:12:25 7199 8192000000 10802118304 11236917248 1897492768 18.806 100 32 61 2 1914364832 7288048 9584016
14:12:40 6812 8192000000 10814673936 11240325120 1896445792 18.798 100 26 51 2 1910090528 6171504 7473232
14:12:57 8653 8192000000 10797350064 11235909632 1895832592 18.793 100 14 28 0 1906022064 5497952 4691520
14:13:12 65186 8192000000 10836431904 11252690944 1905647072 18.872 100 48 95 4 1924970016 4651056 14671888
14:14:23 4471 8192000000 10829181200 11259289600 1913136928 18.932 100 62 124 2 1940703312 9729088 17837296
14:14:34 3890 8192000000 10830559792 11254341632 1910568128 18.911 100 34 67 1 1925972336 5752896 9651312
14:14:45 7875 8192000000 10834556848 11258114048 1908578608 18.895 100 30 59 2 1924312832 7896112 7838112
14:15:02 5212 8192000000 10831264960 11256414208 1909927424 18.906 100 30 59 1 1924848560 6115024 8806112
14:15:13 8501 8192000000 10814770848 11254124544 1910824432 18.913 100 24 48 0 1923443776 6221152 6398192
14:15:28 7253 8192000000 10823534096 11253882880 1907301824 18.885 100 34 68 0 1924357120 7167392 9887904
14:15:42 7665 8192000000 10825260656 11259092992 1910743920 18.913 100 35 68 2 1927949216 7919760 9285536
14:15:57 2864 8192000000 10828497648 11252723712 1910567424 18.911 100 42 84 2 1928421664 6388096 11466144
14:16:06 10539 8192000000 10812684240 11256352768 1907715152 18.888 100 20 40 1 1920162336 6290000 6157184
14:16:27 52035 8192000000 10831478704 11248779264 1893733008 18.776 99 33 65 0 1908186704 4522480 9931216
14:17:25 8920 8192000000 10804963760 11241676800 1878712176 18.655 99 26 51 1 1895893312 10046672 7134464
14:17:40 6181 8192000000 10800567584 11235147776 1856724032 18.477 98 26 52 0 1870508304 6658832 7125440
14:17:54 5217 8192000000 10792955728 11215642624 1859436432 18.499 99 27 55 1 1877464240 10567216 7460592
14:18:10 6118 8192000000 10765581568 11189616640 1850719520 18.428 100 21 42 0 1862263152 6021616 5522016
14:18:23 6902 8192000000 10766226192 11197509632 1855513104 18.467 100 24 48 2 1868528208 6220768 6794336
14:18:42 6588 8192000000 10731231776 11151622144 1760702528 17.690 96 36 69 3 1777113344 5751056 10659760
14:18:56 6435 8192000000 10742458256 11166015488 1819630912 18.175 99 23 46 1 1836281680 10333392 6317376
14:19:09 8663 8192000000 10731071280 11152596992 1785837312 17.898 98 15 30 0 1795614240 5362112 4414816
14:19:25 9334 8192000000 10730845504 11152723968 1764959504 17.725 96 20 40 0 1776659552 5704032 5996016
14:19:42 10112 8192000000 10742959760 11150209024 1742325296 17.538 96 26 52 2 1754711712 4950176 7436240
14:20:10 10414 8192000000 10727447456 11145404416 1765289168 17.728 97 35 71 1 1781748096 5281952 11176976
14:20:27 7279 8192000000 10716152736 11116732416 1745546656 17.565 97 26 52 1 1758730384 5233760 7949968
14:20:42 64010 8192000000 10698240096 11103617024 1694585152 17.140 94 19 36 1 1705195456 4902976 5707328
14:21:52 13282 8192000000 10731193104 11152211968 1811890208 18.111 100 31 61 0 1826711760 6398416 8423136
14:22:13 4637 8192000000 10723903968 11137708032 1778012416 17.833 98 47 91 1 1797479152 5640848 13825888
14:22:26 5507 8192000000 10714434448 11127517184 1774097680 17.801 98 21 43 4 1785900752 5330000 6473072
14:22:38 5905 8192000000 10742096272 11151126528 1786821696 17.906 98 43 86 1 1805885328 6817120 12246512
14:22:50 6261 8192000000 10731076368 11150274560 1787310272 17.910 98 31 62 0 1802049952 5561728 9177952
14:23:03 6167 8192000000 10742047584 11160117248 1818334320 18.164 100 20 40 2 1829980272 5004800 6641152
14:23:16 8309 8192000000 10737705888 11158732800 1805450688 18.059 99 29 58 2 1820537856 6793440 8293728
14:23:32 7914 8192000000 10730115408 11157520384 1792779760 17.955 98 22 45 2 1804901008 6209008 5912240
14:23:46 8316 8192000000 10748701424 11167956992 1829787216 18.258 100 30 60 1 1843903024 5766640 8349168
14:24:01 7098 8192000000 10754013824 11178631168 1835809008 18.307 100 43 85 1 1854577296 5108736 13659552
14:24:16 9165 8192000000 10764722368 11188748288 1849051136 18.414 100 28 56 1 1864059792 6100992 8907664
14:24:35 9363 8192000000 10759374544 11190517760 1849041904 18.414 100 19 38 2 1860347280 5662096 5643280
14:24:50 7785 8192000000 10782033968 11197464576 1852900640 18.446 100 22 44 1 1864800880 5477760 6422480
14:25:06 23048 8192000000 10773060720 11193446400 1853341872 18.449 100 13 26 1 1863185184 5627536 4215776
14:25:40 75448 8192000000 10768515152 11210162176 1866580016 18.557 100 41 80 2 1885197440 6062800 12554624
14:27:01 8949 8192000000 10795663824 11221442560 1874314064 18.619 100 26 52 0 1887398416 5648016 7436336
14:27:18 11378 8192000000 10812538448 11230777344 1889423008 18.741 100 36 72 1 1906009184 6654400 9931776
14:27:47 16261 8192000000 10835893184 11253895168 1901582048 18.839 100 45 90 4 1922345552 7901808 12861696
14:28:25 24754 8192000000 10846474560 11268505600 1910632304 18.912 100 46 90 2 1933964528 10830976 12501248
14:28:56 22815 8192000000 10854213936 11277434880 1920817504 18.993 100 51 102 1 1948754656 12765136 15172016
14:29:28 11086 8192000000 10853437920 11284578304 1927684896 19.048 100 38 76 0 1950194512 11479776 11029840
14:29:47 12183 8192000000 10868096064 11289636864 1932320752 19.085 100 40 80 0 1954730000 11064016 11345232
14:30:07 36741 8192000000 10869173280 11300528128 1939244992 19.141 100 50 101 3 1967014048 12967488 14801568
14:31:08 21450 8192000000 10869948736 11307900928 1942929536 19.170 100 34 66 1 1965356128 12634048 9792544
14:31:43 45467 8192000000 10883788032 11323482112 1952286416 19.245 100 33 66 1 1977872384 15881120 9704848
14:32:34 52309 8192000000 10909860528 11346366464 1962522944 19.326 100 40 80 0 1995568848 19469552 13576352
14:33:35 29411 8192000000 10893707552 11338981376 1947729616 19.208 99 31 62 2 1977692128 20480048 9482464
14:34:11 22695 8192000000 10907966560 11350384640 1973792144 19.416 100 37 74 3 2003831920 18777696 11262080
14:34:47 16056 8192000000 10924295776 11362578432 1982429408 19.484 100 47 92 0 2017839120 21383792 14025920
14:35:13 10836 8192000000 10938863008 11371433984 1987092896 19.521 100 54 106 2 2026930256 23434688 16402672
14:35:45 14787 8192000000 10944291712 11382534144 1993607024 19.572 100 52 102 0 2035289040 26685248 14996768
14:36:08 5812 8192000000 10960039616 11387953152 1999349696 19.618 100 68 135 2 2047730544 28239760 20141088
14:36:21 10298 8192000000 10962275984 11395526656 2000050256 19.623 100 63 124 0 2053121712 33566720 19504736
14:36:40 5654 8192000000 10960345504 11396820992 2000489840 19.627 100 58 116 0 2049775584 31874720 17411024
14:37:07 4830 8192000000 10969192480 11402702848 2004666544 19.660 100 57 111 2 2054723088 32434704 17621840
14:37:19 5156 8192000000 10982535680 11408433152 2009450656 19.697 100 76 150 1 2066813280 33643120 23719504
14:37:32 12600 8192000000 10963587216 11403997184 2006279296 19.672 100 57 114 1 2057857808 33359568 18218944
14:37:53 17488 8192000000 10959636848 11397541888 2001756496 19.637 100 49 98 1 2045790944 29074304 14960144
14:38:25 8510 8192000000 10964057472 11394011136 2000365504 19.626 100 67 130 1 2051652832 31392320 19895008
14:38:40 4033 8192000000 10964681936 11394871296 1987974096 19.528 99 64 127 1 2039761040 32829200 18957744
14:38:53 2905 8192000000 10974938976 11402076160 2007781424 19.684 100 74 146 2 2064384432 34241648 22361360
14:39:10 5150 8192000000 10985188336 11403493376 1991685184 19.557 99 74 146 0 2047935696 33590528 22659984
14:39:22 9974 8192000000 10971671696 11396608000 1983795392 19.495 99 69 138 1 2039574928 35225840 20553696
14:39:40 1366 8192000000 10996358032 11413721088 2012440032 19.721 100 82 164 2 2073311808 35742336 25129440
14:39:50 5234 8192000000 10995550432 11417686016 2016938592 19.756 100 79 159 0 2077899008 37311680 23648736
14:40:04 2474 8192000000 11004946960 11425423360 2025120928 19.820 100 88 175 1 2091057232 39567472 26368832
14:40:13 2045 8192000000 10998318496 11420794880 2021232400 19.790 100 85 167 3 2087797728 40407024 26158304
14:40:22 1967 8192000000 11001349664 11421200384 2019143024 19.773 100 92 184 0 2088640448 42000832 27496592
14:40:31 2136 8192000000 11011180144 11427930112 2020265920 19.782 100 88 176 0 2089874912 42495056 27113936
14:40:40 4158 8192000000 10998004976 11420655616 2000192384 19.624 99 80 160 2 2067631136 43048592 24390160
14:40:54 4550 8192000000 10995238912 11415060480 2012454000 19.721 100 84 169 2 2079819168 41463744 25901424
14:41:09 1795 8192000000 11001841072 11424436224 2017657120 19.762 100 79 159 0 2084819104 42452512 24709472
14:41:21 3947 8192000000 11000936752 11427262464 2018751536 19.770 100 74 143 2 2084430784 43316000 22363248
14:41:33 4387 8192000000 10998034928 11415371776 2000610720 19.628 99 76 153 1 2069584448 44156096 24817632
14:41:47 4864 8192000000 10986286304 11417878528 1994482896 19.579 99 63 125 1 2058387344 43797344 20107104
14:42:00 1801 8192000000 10985386192 11411226624 1998821424 19.613 99 77 154 1 2068696272 44475024 25399824
14:42:10 4283 8192000000 10992350304 11418923008 2002741904 19.644 100 67 134 0 2070510656 46539712 21229040
14:42:21 5161 8192000000 10997277952 11419398144 2007762352 19.684 100 90 178 3 2085269648 49052720 28454576
14:42:34 1335 8192000000 11014547600 11433660416 2015974432 19.749 100 85 170 0 2094103456 51217488 26911536
14:42:43 1718 8192000000 10976486272 11399352320 1989944080 19.543 100 84 168 0 2063418288 46434096 27040112
14:42:51 2759 8192000000 10970080928 11400003584 1987517632 19.524 100 67 135 0 2056454192 47116704 21819856
14:43:01 5293 8192000000 10969029600 11401641984 1974405840 19.420 99 71 142 2 2045831568 48163264 23262464
14:43:17 4144 8192000000 10960573472 11386834944 1975557520 19.430 100 73 145 3 2046510752 48186384 22766848
14:43:32 2856 8192000000 10952128080 11379519488 1965914528 19.353 100 61 122 1 2035192864 49730112 19548224
14:43:43 7971 8192000000 10945946496 11390078976 1956830064 19.281 99 54 108 0 2028542112 54618608 17093440
14:44:15 2680 8192000000 10952677696 11376848896 1961470944 19.318 100 70 141 3 2034438704 50818608 22149152
14:44:25 12032 8192000000 10930301728 11371085824 1947663968 19.208 99 54 109 2 2013132080 47888144 17579968
14:44:44 12088 8192000000 10924120000 11369783296 1956384512 19.277 100 33 64 0 2011063264 43982112 10696640
14:45:04 8786 8192000000 10926538336 11365687296 1943485728 19.175 99 38 76 3 2001625504 45426896 12712880
14:45:21 5497 8192000000 10952825936 11368660992 1932023776 19.083 98 52 103 1 1993826752 45856112 15946864
14:45:34 4709 8192000000 10970139488 11390750720 1978375664 19.452 100 76 152 2 2050795856 48478592 23941600
14:45:46 3689 8192000000 10970103712 11388059648 1974867552 19.424 100 84 166 2 2052715056 51531280 26316224
14:46:00 13954 8192000000 10969664400 11393179648 1957343120 19.285 99 65 131 1 2031866576 53700896 20822560
14:46:21 13274 8192000000 10944021104 11387375616 1956584720 19.279 99 46 92 1 2024873872 53145712 15143440
14:46:48 15274 8192000000 10948112400 11397607424 1973396672 19.412 100 45 90 2 2046705872 56942128 16367072
14:47:13 15844 8192000000 10950966416 11394011136 1964627008 19.343 100 31 62 1 2030675168 55356096 10692064
14:47:43 17804 8192000000 10958552896 11400228864 1969317104 19.380 100 35 70 1 2040329920 58684864 12327952
14:48:16 23771 8192000000 10953656528 11407544320 1957651936 19.287 99 29 58 1 2030583120 62537728 10393456
14:48:47 41345 8192000000 10951961872 11400056832 1935310800 19.109 98 29 58 3 2006595184 60952464 10331920
14:49:49 14082 8192000000 10924861664 11381825536 1937206944 19.124 99 30 58 1 2001112560 53518096 10387520
14:50:33 25398 8192000000 10906011744 11370688512 1946667152 19.200 100 24 49 0 2001316288 45980848 8668288
14:51:22 41949 8192000000 10883701824 11346071552 1872612128 18.605 96 31 62 0 1928059920 45365312 10082480
14:52:44 22137 8192000000 10869310528 11325710336 1867298480 18.562 97 19 38 2 1914546832 40629072 6619280
14:53:14 70231 8192000000 10838904240 11284639744 1841574400 18.354 96 16 32 0 1860810192 14696208 4539584
14:54:37 29061 8192000000 10844214976 11288317952 1894314720 18.781 99 48 92 1 1919276320 11152368 13809232
14:55:13 52086 8192000000 10854750048 11307757568 1902308016 18.845 99 26 52 2 1920560176 11086864 7165296
14:56:19 19493 8192000000 10846732144 11313852416 1924259792 19.021 100 23 46 1 1941791520 11118416 6413312
14:56:56 75703 8192000000 10839587728 11304321024 1883431440 18.693 98 7 14 0 1893973520 8863280 1678800
14:58:18 132265 8192000000 10816616432 11275575296 1830608192 18.264 95 18 37 0 1841870224 6746240 4515792
15:00:38 48268 8192000000 10852760768 11303129088 1893675216 18.775 98 25 49 0 1912638768 12465824 6497728
15:01:33 156049 8192000000 10874447728 11337125888 1911615792 18.920 98 22 43 3 1927819312 9823536 6379984
15:04:20 82184 8192000000 10870860960 11334135808 1895941536 18.794 97 20 39 1 1909515120 7744992 5828592
15:05:49 15296 8192000000 10865576592 11333607424 1949518720 19.223 100 16 32 0 1961952880 7799712 4634448
15:06:16 42325 8192000000 10885962320 11347963904 1959660592 19.303 100 20 40 0 1975576976 9985552 5930832
15:07:07 64734 8192000000 10865517408 11336708096 1908812624 18.897 97 33 66 3 1933119200 14715200 9591376
15:08:24 53965 8192000000 10874033312 11353006080 1954873168 19.265 100 16 32 1 1979662160 19950912 4838080
15:09:25 62963 8192000000 10875715456 11355353088 1955345072 19.269 100 11 22 0 1968737632 10119200 3273360
15:10:43 50794 8192000000 10866482480 11339218944 1935298848 19.109 99 14 28 0 1948726320 8875904 4551568
15:12:06 47404 8192000000 10863217488 11331969024 1915987200 18.955 98 10 20 0 1931225376 12592128 2646048
15:13:00 19266 8192000000 10862811200 11335606272 1905161632 18.868 98 8 16 0 1924590848 16908880 2520336
15:13:26 49763 8192000000 10883483424 11364466688 1948908800 19.218 100 15 30 1 1972176128 18777072 4490256
15:14:21 68608 8192000000 10900749952 11366625280 1943536848 19.175 99 26 52 0 1968466272 17210512 7718912
15:15:36 62399 8192000000 10889422544 11366842368 1963484384 19.334 100 17 34 0 1987082624 18637152 4961088
15:16:46 37152 8192000000 10895739184 11360342016 1965024656 19.346 100 16 32 1 1980407360 10940768 4441936
15:17:29 28140 8192000000 10889470336 11360944128 1950332416 19.229 99 27 55 1 1968007440 9909040 7765984
15:18:07 83156 8192000000 10915209488 11381919744 1979533504 19.461 100 22 44 0 1995939696 10142224 6263968
15:19:37 31892 8192000000 10925476592 11363291136 1957961792 19.290 99 43 82 1 1978791568 9032592 11797184
15:20:18 49041 8192000000 10915591504 11383410688 1976096448 19.434 100 33 66 0 2001660448 16304384 9259616
15:21:15 109631 8192000000 10905623632 11376996352 1966904336 19.361 99 16 32 0 1986862752 15926816 4031600
15:23:11 61273 8192000000 10938862976 11385884672 1985447792 19.508 100 33 66 1 2003286112 8656384 9181936
15:24:24 25126 8192000000 10941254832 11387166720 1974037008 19.417 99 52 104 1 1999923200 11920800 13965392
15:24:59 19148 8192000000 10922912240 11374002176 1982913536 19.488 100 38 76 1 2004757440 11017968 10825936
15:25:30 102927 8192000000 10900695408 11362603008 1969684592 19.383 99 49 98 1 1996954880 13928416 13341872
15:27:19 35895 8192000000 10906357616 11367043072 1965793632 19.352 99 32 63 3 1981651824 8389552 7468640
15:28:10 3616 8192000000 10918872864 11374907392 1987009552 19.520 100 36 67 0 2004660768 8402752 9248464
15:28:19 33703 8192000000 10887584272 11358040064 1943314208 19.173 98 32 64 1 1963824976 11823920 8686848
15:29:07 57030 8192000000 10894876848 11368923136 1949466944 19.222 98 14 28 0 1966249536 13130752 3651840
15:30:10 32336 8192000000 10893244624 11369631744 1962099984 19.323 99 10 20 0 1973989856 9257552 2632320
15:30:56 37627 8192000000 10911382832 11380436992 1984312576 19.499 100 12 22 3 2001054624 13532976 3209072
15:31:39 54920 8192000000 10900135232 11373989888 1912091760 18.923 96 25 51 1 1937784496 18024912 7667824
15:32:47 84199 8192000000 10870056272 11357278208 1839344720 18.335 93 10 20 1 1867138752 24842544 2951488
15:34:21 88207 8192000000 10884958704 11338653696 1877875920 18.648 96 19 38 1 1893243664 10236240 5131504
15:36:01 40525 8192000000 10859152288 11328622592 1892165104 18.763 97 28 54 2 1908999680 9235120 7599456
15:36:52 55077 8192000000 10888004208 11339546624 1938706176 19.136 99 33 64 2 1956299472 8932112 8661184
15:38:07 39395 8192000000 10856004528 11321294848 1869677472 18.582 96 26 52 1 1886735104 9671968 7385664
15:39:03 29022 8192000000 10862655280 11315122176 1889217616 18.739 97 29 58 2 1904061200 6864752 7978832
15:39:44 15549 8192000000 10895866880 11345260544 1945600608 19.191 100 51 99 0 1976637008 17005680 14030720
15:40:11 61437 8192000000 10859127504 11328679936 1885186112 18.707 97 21 42 1 1906566528 15011104 6369312
15:41:19 83370 8192000000 10876561040 11337752576 1869813600 18.583 97 14 28 0 1891634016 18271824 3548592
15:42:54 94820 8192000000 10870564288 11320823808 1839207088 18.334 95 14 28 0 1861377600 18059744 4110768
15:44:36 25656 8192000000 10851563168 11298394112 1851959328 18.438 96 34 68 2 1872105952 10743248 9403376
15:45:19 71233 8192000000 10829236256 11310551040 1910999376 18.915 100 12 24 0 1926295744 12022560 3273808
15:46:55 93218 8192000000 10871385168 11336732672 1933106304 19.092 100 32 64 3 1957649072 15614800 8927968
15:48:35 27211 8192000000 10859285568 11335823360 1920421728 18.990 99 9 18 0 1939898400 17314896 2161776
15:49:19 54169 8192000000 10845906560 11316473856 1899471728 18.822 98 6 12 0 1913311168 12129456 1709984
15:50:29 30161 8192000000 10836365056 11313238016 1907987280 18.890 99 4 8 0 1915341600 6415248 939072
15:51:28 104169 8192000000 10846629008 11319525376 1905605408 18.871 98 19 37 2 1919527600 8020000 5902192
15:53:20 72512 8192000000 10855227936 11333414912 1910615712 18.912 99 11 22 2 1924542784 10883184 3043888
15:54:39 53512 8192000000 10860853984 11329036288 1897530976 18.806 98 10 20 0 1908910928 8038112 3341840
15:55:55 37336 8192000000 10861826304 11321733120 1916419968 18.958 99 27 52 0 1933336752 8179872 8736912
15:56:42 19555 8192000000 10868657296 11326599168 1919191872 18.980 99 44 86 2 1942428528 10309520 12927136
15:57:07 47847 8192000000 10891172816 11345084416 1943166832 19.172 100 26 52 2 1963542448 13325632 7049984
15:58:02 89938 8192000000 10878522992 11343970304 1904328048 18.861 97 17 34 2 1924095392 15384304 4383040
15:59:39 19663 8192000000 10895753808 11343163392 1921409216 18.998 98 42 84 2 1939799696 6942864 11447616
16:00:09 28640 8192000000 10891744768 11346669568 1939939248 19.146 99 45 88 1 1962167264 9883312 12344704
16:00:53 48374 8192000000 10896508416 11357302784 1944848480 19.185 99 25 50 0 1960095056 8593776 6652800
16:01:48 43216 8192000000 10905096976 11375800320 1967425216 19.365 100 26 53 2 1986954240 12307664 7221360
16:02:37 49857 8192000000 10903477024 11366461440 1936692528 19.120 98 24 48 2 1953332208 9585344 7054336
16:03:44 40566 8192000000 10910739440 11352023040 1914516640 18.943 97 45 88 1 1935453680 8057680 12879360
16:04:37 109971 8192000000 10901645920 11368112128 1947976656 19.210 99 11 22 0 1959655248 8714560 2964032
16:06:45 64793 8192000000 10929291232 11399049216 1951265408 19.237 99 23 46 0 1974062784 16518080 6279296
16:08:16 117860 8192000000 10920882080 11397189632 1975898912 19.432 100 21 42 1 2011561680 28827056 6835712
16:11:01 13689 8192000000 10897765968 11366449152 1956079344 19.275 99 22 44 0 1984371104 21057680 7234080
16:11:22 64418 8192000000 10893262944 11362897920 1937594128 19.128 98 20 40 0 1954601488 11530960 5476400
16:12:43 82519 8192000000 10891128384 11371282432 1951105504 19.235 99 15 30 0 1970907840 15446416 4355920
16:14:12 54704 8192000000 10898816624 11376660480 1952181776 19.244 99 14 27 1 1972943008 16875664 3885568
16:15:16 41099 8192000000 10910417232 11377668096 1975006560 19.425 100 11 22 1 1992583184 14368144 3208480
16:16:14 50367 8192000000 10891134720 11358703616 1922207168 19.005 97 18 36 0 1944139072 16988704 4943200
16:17:11 86824 8192000000 10881530432 11353563136 1869087904 18.577 95 20 40 0 1888932656 13934352 5910400
16:18:44 101241 8192000000 10911748144 11383361536 1972401232 19.404 100 14 28 1 1994153696 18057248 3695216
16:20:36 28584 8192000000 10900306192 11344736256 1942284192 19.165 98 40 80 1 1961987296 8240896 11462208
16:21:16 22125 8192000000 10885901184 11343781888 1924421632 19.022 98 32 62 1 1941072672 8201696 8449344
16:21:45 74531 8192000000 10905361088 11371061248 1949220160 19.220 99 32 63 0 1971537712 13153424 9164128
16:23:06 37188 8192000000 10883254688 11354390528 1941179552 19.156 99 23 46 0 1956195392 8874336 6141504
16:23:52 77322 8192000000 10868088336 11328180224 1822926048 18.202 93 17 34 1 1842523328 14876304 4720976
16:25:16 26499 8192000000 10862070208 11304558592 1874342144 18.619 97 23 46 0 1891946544 10850336 6754064
16:25:49 71455 8192000000 10844769712 11302154240 1817685504 18.159 95 18 36 0 1837614128 15341712 4586912
16:27:07 26560 8192000000 9405189472 9695416320 544241008 6.229 29 2 4 0 554743728 10378096 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 23-02-2021 16:28:17 to 23-02-2021 16:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-02-2021 16:28:48 to 23-02-2021 16:28:50.

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          234669
MON$OLDEST_ACTIVE               235703
MON$OLDEST_SNAPSHOT             235703
MON$NEXT_TRANSACTION            235703
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                       1987904
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 ---
:190: 
:191: mscs-test-161.budzdorov.ru    Tue Feb 23 16:27:36 2021
:192:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:193: 
--- end of diff output ---

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

23.02.21 16:28:51. 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-23 16:28:53 No severe PSQL-related problems occured
23.02.21 16:28:54. End of report.