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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-27 16:27:17
DTS_END                         2021-01-27 16:27:17.2200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54236
TRN_ID                          246325
ATT_ID                          640
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: 9297.29 22979 1115675
customer order: creation 180.84 377 21701
customer order: refuse 14.94 345 1793
order to supplier: creation 48.18 1307 5782
order to supplier: removal 3.50 106964 420
invoice (draft): creation 46.99 3732 5639
invoice (draft): removal 52.62 913 6314
invoice accept: apply 42.63 17333 5116
invoice accept: cancel 47.19 840 5663
customer reserve: creation 3884.62 172 466154
customer reserve: removal 4665.94 62 559913
realization accept: apply 86.05 186 10326
realization accept: cancel 88.35 117 10602
payment from customer: creation 62.44 114 7493
payment from customer: removal 5.91 108 709
payment to supplier: creation 51.09 129 6131
payment to supplier: removal 3.44 109 413
service: total inventory turnovers 4.80 1318 576
service: total monetary turnovers 6.78 26 814
service: aggregate perf. data 0.93 20997 112
service: refresh index statistics 0.03 304434 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-01-2021 16:28:08 to 27-01-2021 16:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 915
TEST_TIME 2 2106
TEST_TIME 3 3055
TEST_TIME 4 3706
TEST_TIME 5 4037
TEST_TIME 6 4053
TEST_TIME 7 4197
TEST_TIME 8 4362
TEST_TIME 9 4902
TEST_TIME 10 5204
TEST_TIME 11 5392
TEST_TIME 12 5749
TEST_TIME 13 5970
TEST_TIME 14 6189
TEST_TIME 15 6833
TEST_TIME 16 6891
TEST_TIME 17 7055
TEST_TIME 18 7889
TEST_TIME 19 8121
TEST_TIME 20 8163
TEST_TIME 21 8570
TEST_TIME 22 9339
TEST_TIME 23 9532
TEST_TIME 24 9501
TEST_TIME 25 9812
TEST_TIME 26 10062
TEST_TIME 27 10753
TEST_TIME 28 11403
TEST_TIME 29 11128
TEST_TIME 30 10984
TEST_TIME 31 10804
TEST_TIME 32 10629
TEST_TIME 33 10456
TEST_TIME 34 10281
TEST_TIME 35 10050
TEST_TIME 36 9786
TEST_TIME 37 9865
TEST_TIME 38 9722
TEST_TIME 39 9707
TEST_TIME 40 9684
TEST_TIME 41 9576
TEST_TIME 42 9462
TEST_TIME 43 9294
TEST_TIME 44 9296
TEST_TIME 45 9288
TEST_TIME 46 9338
TEST_TIME 47 9400
TEST_TIME 48 9441
TEST_TIME 49 9448
TEST_TIME 50 9464
TEST_TIME 51 9474
TEST_TIME 52 9566
TEST_TIME 53 9548
TEST_TIME 54 9651
TEST_TIME 55 9634
TEST_TIME 56 9759
TEST_TIME 57 9715
TEST_TIME 58 9589
TEST_TIME 59 9577
TEST_TIME 60 9537
TEST_TIME 61 9436
TEST_TIME 62 9479
TEST_TIME 63 9430
TEST_TIME 64 9403
TEST_TIME 65 9364
TEST_TIME 66 9356
TEST_TIME 67 9312
TEST_TIME 68 9344
TEST_TIME 69 9345
TEST_TIME 70 9414
TEST_TIME 71 9414
TEST_TIME 72 9441
TEST_TIME 73 9517
TEST_TIME 74 9510
TEST_TIME 75 9547
TEST_TIME 76 9495
TEST_TIME 77 9488
TEST_TIME 78 9519
TEST_TIME 79 9429
TEST_TIME 80 9435
TEST_TIME 81 9361
TEST_TIME 82 9338
TEST_TIME 83 9299
TEST_TIME 84 9258
TEST_TIME 85 9189
TEST_TIME 86 9233
TEST_TIME 87 9217
TEST_TIME 88 9200
TEST_TIME 89 9306
TEST_TIME 90 9278
TEST_TIME 91 9333
TEST_TIME 92 9334
TEST_TIME 93 9330
TEST_TIME 94 9305
TEST_TIME 95 9346
TEST_TIME 96 9392
TEST_TIME 97 9477
TEST_TIME 98 9516
TEST_TIME 99 9482
TEST_TIME 100 9467
TEST_TIME 101 9436
TEST_TIME 102 9360
TEST_TIME 103 9382
TEST_TIME 104 9344
TEST_TIME 105 9360
TEST_TIME 106 9314
TEST_TIME 107 9282
TEST_TIME 108 9278
TEST_TIME 109 9237
TEST_TIME 110 9257
TEST_TIME 111 9227
TEST_TIME 112 9217
TEST_TIME 113 9263
TEST_TIME 114 9247
TEST_TIME 115 9289
TEST_TIME 116 9309
TEST_TIME 117 9280
TEST_TIME 118 9298
TEST_TIME 119 9279
TEST_TIME 120 9298

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-01-2021 16:28:12 to 27-01-2021 16:28:15.

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 1549024 1549024 0 0.00 0 26708 6 0 0
doc_list_biud 1549024 1549024 0 0.00 0 31032 29 0 0
sp_add_invoice_to_stock 5290 5116 174 3.28 39 170672 17333 0 174
sp_cancel_adding_invoice 5663 5663 0 0.00 5 70303 841 0 0
sp_cancel_client_order 1793 1793 0 0.00 4 15086 345 0 0
sp_cancel_customer_reserve 559913 559913 0 0.00 1 31034 62 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 2 5950 108 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 6386 110 0 0
sp_cancel_supplier_invoice 6325 6314 11 0.17 2 18893 914 0 11
sp_cancel_supplier_order 420 420 0 0.00 5 1189298 106965 0 0
sp_cancel_write_off 10602 10602 0 0.00 1 12311 117 0 0
sp_client_order 21701 21701 0 0.00 4 19269 378 0 0
sp_customer_reserve 466154 466154 0 0.00 0 81567 172 0 0
sp_fill_shopping_cart 33110 33110 0 0.00 1 19976 38 0 0
sp_fill_shopping_cart_clo_res 466147 466147 0 0.00 0 38563 15 0 0
sp_get_clo_for_invoice 5109 5109 0 0.00 0 50126 360 0 0
sp_kill_cost_storno 17387 17387 0 0.00 0 9662 60 0 0
sp_kill_qstorno_ret_qs2qd 1137162 1137162 0 0.00 0 31026 34 0 0
sp_kill_qty_storno 600140 600140 0 0.00 0 31032 74 0 0
sp_lock_selected_doc 21375 21375 0 0.00 0 10514 8 0 0
sp_make_cost_storno 29059 29059 0 0.00 0 26697 50 0 0
sp_multiply_rows_for_pdistr 29059 29059 0 0.00 0 11184 28 0 0
sp_multiply_rows_for_qdistr 21701 21701 0 0.00 0 15958 176 0 0
sp_pay_from_customer 7493 7493 0 0.00 4 20108 115 0 0
sp_pay_to_supplier 6131 6131 0 0.00 5 11740 129 0 0
sp_payment_common 13624 13624 0 0.00 1 20103 33 0 0
sp_qd_handle_on_cancel_clo 1793 1793 0 0.00 0 15079 325 0 0
sp_qd_handle_on_invoice_upd_sts 10772 10772 0 0.00 0 30831 345 0 0
sp_qd_handle_on_reserve_upd_sts 10326 10326 0 0.00 0 19828 64 0 0
sp_reserve_write_off 10326 10326 0 0.00 7 19859 187 0 0
sp_supplier_invoice 5639 5639 0 0.00 5 131530 3733 0 0
sp_supplier_order 5782 5782 0 0.00 5 69330 1308 0 0
srv_aggregate_perf_data 112 112 0 0.00 2611 587349 20997 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1144 140300 29180 0 0
srv_find_qd_qs_mism 1067214 1067214 0 0.00 0 20413 5 0 0
srv_make_invnt_saldo 576 576 0 0.00 39 109659 1319 0 0
srv_make_money_saldo 814 814 0 0.00 0 1128 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 190620 403578 304435 0 0
t$perf-abend:sp_add_invoice_to_stock 174 174 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5116 5116 0 0.00 0 12074 175 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 10648 156 0 0
t$perf-norm:sp_cancel_client_order 1793 1793 0 0.00 0 3398 15 0 0
t$perf-norm:sp_cancel_customer_reserve 733 733 0 0.00 0 836 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 1393 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 1925 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 605 11 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 27957 1497 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 5066 15 0 0
t$perf-norm:sp_client_order 21701 21701 0 0.00 0 12297 18 0 0
t$perf-norm:sp_customer_reserve 1044 1044 0 0.00 0 10674 20 0 0
t$perf-norm:sp_pay_from_customer 7493 7493 0 0.00 0 3808 7 0 0
t$perf-norm:sp_pay_to_supplier 6131 6131 0 0.00 0 4597 10 0 0
t$perf-norm:sp_reserve_write_off 10326 10326 0 0.00 0 10121 13 0 0
t$perf-norm:sp_supplier_invoice 5639 5639 0 0.00 0 5300 16 0 0
t$perf-norm:sp_supplier_order 5782 5782 0 0.00 0 20577 19 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 267 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 459 9 0 0
t$perf-norm:srv_make_invnt_saldo 576 576 0 0.00 0 987 22 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 711 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 75 20 0 0
v_add_invoice_to_stock 10566 10218 348 3.29 0 11393 24 0 348
v_all_customers 39584 39584 0 0.00 0 29 1 0 0
v_all_suppliers 31756 31756 0 0.00 0 219 1 0 0
v_all_wares 43402 43402 0 0.00 0 121 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 345 6 0 0
v_cancel_client_order 3586 3586 0 0.00 0 1940 4 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 1913 8 0 0
v_cancel_customer_reserve 1466 1466 0 0.00 0 4917 8 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 1046 5 0 0
v_cancel_supplier_invoice 878 856 22 2.50 0 7279 24 0 22
v_cancel_supplier_order 840 840 0 0.00 0 3363 8 0 0
v_cancel_write_off 2032 2032 0 0.00 0 6387 19 0 0
v_max_id_clo_ord 5781 5781 0 0.00 0 304 1 0 0
v_max_id_clo_res 1044 1044 0 0.00 0 8889 23 0 0
v_max_id_ord_sup 5628 5628 0 0.00 0 4645 5 0 0
v_max_non_paid_invoice 1662 1662 0 0.00 0 782 3 0 0
v_max_non_paid_realizn 3971 3971 0 0.00 0 4481 5 0 0
v_min_id_clo_ord 5781 5781 0 0.00 0 2709 6 0 0
v_min_id_clo_res 1044 1044 0 0.00 0 7420 22 0 0
v_min_id_ord_sup 5628 5628 0 0.00 0 6196 8 0 0
v_min_non_paid_invoice 6131 6131 0 0.00 0 10820 21 0 0
v_min_non_paid_realizn 7493 7493 0 0.00 0 20098 21 0 0
v_our_firm 10862 10862 0 0.00 0 29 1 0 0
v_reserve_write_off 20652 20652 0 0.00 0 9998 7 0 0
x_lock_depdocs_on_canc_invoice 11549 11549 0 0.00 0 21683 133 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 9549 382 0 0
x_make_qstorno_1000_1200 5782 5782 0 0.00 2 69282 1233 0 0
x_make_qstorno_1200_2000 5639 5639 0 0.00 2 131455 3593 0 0
x_make_qstorno_2100_3300 466154 466154 0 0.00 0 81565 155 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 27-01-2021 16:28:16 to 27-01-2021 16:28:21.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:27 13900 8192000000 10208833600 10510458880 883906640 9.739 71 56 115 0 904910912 2354656 18649616
13:57:48 20279 8192000000 10299736160 10612404224 1352336592 14.168 100 87 175 0 1385189984 4121296 28732096
13:58:17 21779 8192000000 10348339184 10665361408 1401019648 14.604 100 84 168 0 1433960592 5592416 27348528
13:58:48 41711 8192000000 10393917056 10717044736 1434086096 14.897 100 86 172 0 1473186480 11058304 28042080
13:59:41 11868 8192000000 10409717744 10738642944 1467336880 15.190 100 88 176 0 1503622640 7635232 28650528
14:00:07 27050 8192000000 10439380944 10771320832 1491405248 15.401 100 93 186 1 1530270960 8705008 30160704
14:00:43 18028 8192000000 10458880976 10794504192 1515360848 15.610 100 91 182 0 1553251792 9113344 28777600
14:01:13 16388 8192000000 10474968624 10816774144 1535661520 15.786 100 88 176 3 1572817760 9438160 27718080
14:01:39 9171 8192000000 10485502160 10829787136 1545152208 15.868 100 80 161 1 1580027648 9774912 25100528
14:02:01 12334 8192000000 10535422880 10889052160 1586534128 16.224 100 78 157 2 1619880672 9602368 23744176
14:02:22 15975 8192000000 10571877952 10928832512 1627047472 16.570 100 84 168 2 1663619936 11078480 25493984
14:02:48 8060 8192000000 10586817456 10948698112 1648705248 16.753 100 89 178 2 1687130928 11626144 26799536
14:03:08 14202 8192000000 10604015776 10970427392 1661129776 16.858 100 77 154 3 1695504640 12002144 22372720
14:03:30 9612 8192000000 10617791472 10985381888 1678197568 17.002 100 77 154 0 1712527584 11621136 22708880
14:03:49 7027 8192000000 10629528592 11002064896 1697242080 17.162 100 80 159 1 1731753568 11641504 22869984
14:04:04 6755 8192000000 10644423104 11016892416 1706271968 17.238 100 75 150 3 1740637120 12297920 22067232
14:04:18 7160 8192000000 10671422016 11039449088 1721689184 17.366 100 83 166 0 1757999568 12710832 23599552
14:04:35 6573 8192000000 10671138896 11047223296 1735340544 17.480 100 70 140 1 1767130096 12122896 19666656
14:04:48 5289 8192000000 10685937680 11062874112 1751867552 17.617 100 82 162 3 1787430688 12972528 22590608
14:05:01 6763 8192000000 10713850192 11088347136 1764534176 17.722 100 87 174 2 1803391072 14306656 24550240
14:05:17 3142 8192000000 10708435024 11088793600 1771619744 17.780 100 86 172 1 1810388304 14807920 23960640
14:05:28 4664 8192000000 10725150640 11101892608 1781240160 17.860 100 88 173 2 1818699168 13883280 23575728
14:05:39 3040 8192000000 10730320928 11106906112 1787181792 17.909 100 83 165 2 1824605776 14206672 23217312
14:05:49 3927 8192000000 10731618256 11115225088 1797456112 17.993 100 87 171 2 1836037968 14761168 23820688
14:06:00 4151 8192000000 10735955984 11116093440 1797181088 17.991 100 87 173 0 1834586720 13707472 23698160
14:06:11 3039 8192000000 10750535584 11132170240 1804666288 18.052 100 92 184 0 1845041040 15195792 25178960
14:06:21 5025 8192000000 10744318928 11128733696 1802766368 18.037 100 82 164 1 1841061040 15695808 22598864
14:06:33 3782 8192000000 10752939808 11133456384 1807917936 18.079 100 84 168 1 1845277600 14653104 22706560
14:06:43 2097 8192000000 10769732016 11151683584 1824838368 18.217 100 92 179 3 1864003584 14321088 24844128
14:06:52 2060 8192000000 10770421296 11158970368 1824055536 18.211 100 87 171 2 1861534064 13375504 24103024
14:07:01 1738 8192000000 10773830160 11158515712 1831094608 18.268 100 95 188 2 1871236368 13174368 26967392
14:07:09 1473 8192000000 10775676352 11159240704 1831400720 18.271 100 90 179 1 1869991584 12583040 26007824
14:07:17 2367 8192000000 10782597792 11167191040 1833900336 18.291 100 92 182 2 1871424400 12527504 24996560
14:07:26 1841 8192000000 10785755296 11173212160 1838843328 18.331 100 88 176 1 1877003936 12771248 25389360
14:07:34 1502 8192000000 10794513600 11177988096 1846964160 18.397 100 96 191 0 1886261312 11951488 27345664
14:07:42 2088 8192000000 10794575280 11181068288 1853381632 18.450 100 89 179 2 1890899936 12269936 25248368
14:07:50 1349 8192000000 10795432304 11183005696 1855211552 18.464 100 91 180 2 1893385584 12301744 25872288
14:07:57 2176 8192000000 10798262144 11189354496 1858367120 18.490 100 86 172 1 1894086944 11629808 24090016
14:08:06 27277 8192000000 10799953824 11194978304 1864532592 18.540 100 81 158 2 1897985856 11649504 21803760
14:08:40 1590 8192000000 10819529184 11208335360 1875779696 18.631 100 91 183 4 1913988000 11551936 26656368
14:08:48 17370 8192000000 10783337920 11198648320 1864073376 18.536 100 41 82 1 1883739712 7964608 11701728
14:09:14 10266 8192000000 10771896720 11199156224 1864050384 18.536 100 34 68 0 1880732384 7057200 9624800
14:09:31 5203 8192000000 10787828704 11203796992 1870835472 18.591 100 35 70 1 1887935152 6906656 10193024
14:09:44 5394 8192000000 10784209472 11202646016 1869064752 18.577 100 29 58 3 1883969216 6772704 8131760
14:09:56 5538 8192000000 10781217552 11209515008 1873640736 18.614 100 26 52 2 1887368912 6496160 7232016
14:10:11 5949 8192000000 10784887168 11217633280 1878601120 18.654 100 30 61 1 1898738976 11901280 8236576
14:10:26 5991 8192000000 10792578784 11217661952 1879647200 18.662 100 28 57 3 1893916784 6375824 7893760
14:10:40 14454 8192000000 10787124800 11217412096 1879654768 18.662 100 14 28 1 1889562848 5813584 4094496
14:11:01 9063 8192000000 10788177744 11220738048 1883534816 18.694 100 18 36 0 1894822560 6554272 4733472
14:11:16 10145 8192000000 10788418640 11222204416 1885595232 18.710 100 15 29 0 1895693008 6230688 3867088
14:11:34 9006 8192000000 10799817824 11227463680 1886167296 18.715 100 15 30 1 1895972208 5335760 4469152
14:11:50 4952 8192000000 10797554656 11226038272 1892807648 18.768 100 25 50 0 1906204592 6610704 6786240
14:12:12 13887 8192000000 10812914464 11239010304 1900663200 18.832 100 45 91 1 1920455040 6256512 13535328
14:12:32 56597 8192000000 10828486256 11251908608 1904502976 18.862 100 41 83 1 1922225776 5183328 12539472
14:13:44 20862 8192000000 10825533856 11255123968 1903625488 18.855 100 22 44 1 1915521328 5921712 5974128
14:14:12 4883 8192000000 10816746944 11252219904 1904509936 18.863 100 22 44 0 1917538976 7184128 5844912
14:14:25 5208 8192000000 10819036560 11254284288 1907038816 18.883 100 29 58 3 1921855536 6591808 8224912
14:14:38 5716 8192000000 10818317296 11256954880 1907788144 18.889 100 32 66 0 1923619776 6801984 9029648
14:14:51 5007 8192000000 10830200080 11262947328 1911293232 18.917 100 38 75 0 1932921696 11344512 10283952
14:15:02 6909 8192000000 10827882624 11261345792 1911446880 18.918 100 31 62 1 1926423584 6283856 8692848
14:15:16 9436 8192000000 10831154880 11265568768 1913647952 18.936 100 24 46 1 1926040992 6115456 6277584
14:15:32 10029 8192000000 10834605376 11266985984 1914794816 18.945 100 26 52 2 1928360096 5887568 7677712
14:15:52 8089 8192000000 10838309472 11267059712 1917155808 18.964 100 25 49 1 1930078208 6392512 6529888
14:16:06 6449 8192000000 10815320272 11253858304 1906558656 18.879 100 19 38 0 1918683120 6338624 5785840
14:16:19 6666 8192000000 10797145136 11227217920 1863106896 18.528 98 25 51 0 1875724544 5240912 7376736
14:16:31 8357 8192000000 10801563552 11234394112 1858128080 18.488 98 21 42 0 1870435600 6167296 6140224
14:16:50 9981 8192000000 10792994688 11222990848 1836085840 18.309 97 6 11 2 1842813552 5065168 1662544
14:17:11 12032 8192000000 10756814400 11188408320 1796809936 17.988 96 24 46 3 1809433296 6454816 6168544
14:17:29 41714 8192000000 10761585008 11200692224 1799953200 18.014 96 24 47 0 1812820592 5755392 7112000
14:18:28 21305 8192000000 10748387696 11169185792 1708870816 17.259 91 39 76 0 1725818512 5822800 11124896
14:18:56 11392 8192000000 10740273120 11153403904 1711408096 17.281 93 25 50 2 1724299968 5474496 7417376
14:19:16 3524 8192000000 10720208816 11132706816 1759095664 17.677 97 38 76 2 1776818656 6222800 11500192
14:19:28 5237 8192000000 10726583872 11146326016 1782410144 17.869 98 33 63 4 1798366704 6943904 9012656
14:19:41 5608 8192000000 10727243200 11147161600 1798124592 17.999 99 32 64 1 1814244560 6983808 9136160
14:19:53 6992 8192000000 10724066992 11140030464 1800649040 18.019 99 23 45 0 1812129792 5121536 6359216
14:20:07 4512 8192000000 10733840096 11154944000 1779296176 17.844 97 37 74 0 1797642192 7841152 10504864
14:20:20 3146 8192000000 10727354336 11145707520 1796642816 17.986 99 31 63 1 1811393568 5708400 9042352
14:20:31 5589 8192000000 10697659568 11117658112 1755911040 17.651 97 17 34 1 1766633888 5746672 4976176
14:20:43 8690 8192000000 10722075616 11131371520 1767717072 17.748 98 34 67 1 1782674864 5604976 9352816
14:21:02 8601 8192000000 10702425968 11110334464 1736772416 17.492 97 31 60 2 1751241952 5398736 9070800
14:21:17 10355 8192000000 10728387664 11137400832 1754061024 17.635 97 23 45 1 1769715584 8837440 6817120
14:21:34 7823 8192000000 10717329264 11127525376 1768326112 17.753 98 36 72 0 1785337024 5139376 11871536
14:21:48 13486 8192000000 10726609360 11143684096 1792733488 17.954 99 27 54 0 1806595232 5559232 8302512
14:22:07 76266 8192000000 10736925360 11165405184 1822128816 18.195 100 23 46 2 1833854144 5277424 6447904
14:23:31 9626 8192000000 10760881344 11179003904 1838030992 18.325 100 36 72 2 1855449424 7510048 9908384
14:23:47 6874 8192000000 10760449008 11174404096 1832936048 18.283 100 37 75 0 1850899216 7204576 10758592
14:24:02 9178 8192000000 10764343808 11180994560 1840949120 18.349 100 29 58 2 1856325712 7775968 7600624
14:24:22 7806 8192000000 10758192320 11186802688 1848807312 18.412 100 25 50 1 1866219408 10432256 6979840
14:24:37 9631 8192000000 10752613328 11184275456 1830592992 18.264 99 20 38 2 1841550544 5286464 5671088
14:24:53 6540 8192000000 10758724112 11184394240 1848607104 18.411 100 28 56 3 1862486208 5394240 8484864
14:25:06 10346 8192000000 10762285968 11192668160 1852776624 18.445 100 26 52 1 1866239248 5931088 7531536
14:25:24 9297 8192000000 10770950176 11199705088 1854574192 18.459 100 12 24 0 1863097024 5377920 3144912
14:25:42 7033 8192000000 10778150992 11203739648 1860483104 18.507 100 31 60 1 1875112880 6284640 8345136
14:25:55 8325 8192000000 10776277312 11207696384 1863485680 18.532 100 16 31 1 1873106560 4980160 4640720
14:26:10 13066 8192000000 10789073024 11212771328 1871062272 18.593 100 28 56 2 1885874448 6928816 7883360
14:26:31 6888 8192000000 10790281536 11216248832 1868298256 18.571 100 20 41 0 1879531072 5555584 5677232
14:26:47 140300 8192000000 10829231728 11252867072 1885140160 18.707 100 35 69 2 1900558080 4884832 10533088
14:29:15 27266 8192000000 10848764176 11271979008 1919443072 18.982 100 57 114 0 1947672592 11717168 16512352
14:29:52 26416 8192000000 10858289056 11285913600 1928627776 19.056 100 40 80 2 1952546960 12680544 11238640
14:30:28 6433 8192000000 10865781808 11287687168 1936577104 19.119 100 50 100 4 1963853216 11522048 15754064
14:30:43 8192 8192000000 10867955584 11296530432 1939957888 19.146 100 47 93 0 1966327328 12451920 13917520
14:31:01 29241 8192000000 10880595792 11312115712 1946292976 19.197 100 48 96 1 1975527104 15865360 13368768
14:31:38 17556 8192000000 10888300080 11318870016 1951474288 19.238 100 47 94 1 1980089808 15864352 12751168
14:32:04 19309 8192000000 10905555712 11329818624 1962271168 19.324 100 58 114 0 1995955072 17004320 16679584
14:32:32 13702 8192000000 10916397664 11341893632 1966544944 19.358 100 55 109 0 2001937216 19707904 15684368
14:32:55 12806 8192000000 10922783552 11338436608 1969327968 19.380 100 48 96 1 2003695920 20129456 14238496
14:33:28 19169 8192000000 10915060368 11348996096 1975802400 19.431 100 44 88 0 2009547232 20005840 13738992
14:34:07 13250 8192000000 10928645392 11363360768 1983990304 19.496 100 45 90 0 2019489536 21925216 13574016
14:34:28 7404 8192000000 10941775680 11366395904 1987723408 19.526 100 48 95 1 2024983760 22926208 14334144
14:34:44 4692 8192000000 10943522528 11367669760 1990522528 19.548 100 53 106 2 2029385728 23154304 15708896
14:34:57 14998 8192000000 10947334368 11374313472 1996388416 19.594 100 64 126 1 2040574272 25754704 18431152
14:35:20 4938 8192000000 10956099792 11377164288 1996419264 19.594 100 59 118 2 2039912016 25540176 17952576
14:35:32 2161 8192000000 10959593168 11372617728 1981031056 19.473 99 74 146 2 2027693984 25681760 20981168
14:35:41 4826 8192000000 10952657888 11379392512 1996702832 19.597 100 63 124 0 2041990384 26570848 18716704
14:35:53 4879 8192000000 10954123904 11379326976 1999865872 19.622 100 56 112 1 2044497408 27678208 16953328
14:36:07 16718 8192000000 10962051232 11390529536 2004474000 19.658 100 61 120 1 2051919568 29281648 18163920
14:36:39 6039 8192000000 10972821088 11399868416 2012953952 19.725 100 62 124 2 2063163040 31895216 18313872
14:36:52 2327 8192000000 10984434512 11396984832 2009244576 19.696 100 72 142 4 2059627760 29673072 20710112
14:37:01 5989 8192000000 10952808320 11376832512 1988982864 19.536 99 64 129 0 2038797888 30640288 19174736
14:37:14 2667 8192000000 10942035984 11365953536 1980327104 19.467 99 75 148 3 2032882288 30084912 22470272
14:37:27 3153 8192000000 10965594224 11379970048 1983563616 19.493 99 79 154 2 2037338352 30304368 23470368
14:37:39 4334 8192000000 10956788272 11379228672 1992831456 19.566 100 67 134 1 2044395872 31360352 20204064
14:37:51 3216 8192000000 10959330272 11380109312 1992251040 19.562 100 74 147 0 2047445840 33016976 22177824
14:38:01 3343 8192000000 10970350272 11378536448 1989774160 19.542 100 84 166 1 2050449168 34870480 25804528
14:38:13 5171 8192000000 10943631024 11364130816 1970993536 19.393 99 72 143 1 2028829184 35926224 21909424
14:38:25 15859 8192000000 10959818016 11385876480 1990498448 19.548 100 70 140 2 2046970400 35796768 20675184
14:38:48 3402 8192000000 10968447824 11395960832 2000393296 19.626 100 63 121 1 2058209104 39012912 18802896
14:39:01 4902 8192000000 10986605136 11412496384 2008246976 19.688 100 65 127 2 2070969984 43853200 18869808
14:39:15 7660 8192000000 10981448528 11403771904 2006433344 19.673 100 69 138 1 2066828176 38196224 22198608
14:39:31 6761 8192000000 10975913232 11408355328 2007950704 19.685 100 54 108 1 2062946624 38209728 16786192
14:39:45 5976 8192000000 10981577760 11411562496 2015952400 19.748 100 73 146 2 2076443264 36659328 23831536
14:39:58 5003 8192000000 10999584096 11416162304 2019377232 19.775 100 68 133 3 2077407600 37292608 20737760
14:40:11 2535 8192000000 10993327616 11416080384 2015691424 19.746 100 87 173 0 2080325008 38301008 26332576
14:40:19 1751 8192000000 10994967200 11410350080 2012323920 19.720 100 85 164 1 2075670928 37124784 26222224
14:40:28 5516 8192000000 10996519088 11418701824 2017266944 19.759 100 81 162 1 2080842304 38514928 25060432
14:40:45 7337 8192000000 10990174016 11415334912 2011791184 19.716 100 69 138 0 2073025616 40169888 21064544
14:40:59 3310 8192000000 10986205472 11411578880 2004837216 19.661 100 65 130 1 2067894048 42915408 20141424
14:41:16 2597 8192000000 10991547520 11405520896 2006183952 19.671 100 71 144 2 2069452128 42856720 20411456
14:41:27 2379 8192000000 11006489968 11419705344 2014473360 19.737 100 90 179 0 2086939088 44200176 28265552
14:41:37 2054 8192000000 11002932816 11415756800 2010703936 19.707 100 93 181 1 2083810096 45007760 28098400
14:41:45 1140 8192000000 10994942160 11406221312 2002209776 19.640 100 93 183 3 2076670432 46359088 28101568
14:41:54 3486 8192000000 10971202016 11381129216 1976054960 19.433 99 83 166 1 2049517456 48016768 25445728
14:42:04 5635 8192000000 10963847344 11382026240 1980437856 19.468 99 78 156 1 2053119040 48323088 24358096
14:42:20 5621 8192000000 10984310032 11408629760 2001790160 19.637 100 68 136 1 2068535008 45037600 21707248
14:42:33 6420 8192000000 10972076576 11393814528 1982714560 19.486 100 67 134 1 2048766032 44699200 21352272
14:42:48 1466 8192000000 10977558464 11394367488 1987236272 19.522 100 81 163 0 2059097504 44944416 26916816
14:42:57 1580 8192000000 10982186736 11398283264 1999669104 19.620 100 84 168 0 2070195024 44159888 26366032
14:43:08 1454 8192000000 10987154608 11407585280 2001575712 19.635 100 80 158 2 2072789280 46506528 24707040
14:43:17 3957 8192000000 10992322928 11404726272 1998581008 19.612 100 86 169 0 2070045296 45756912 25707376
14:43:33 4105 8192000000 10995553712 11407941632 1984957776 19.504 99 83 165 0 2056587280 46456304 25173200
14:43:44 4762 8192000000 11010354464 11421663232 2006979200 19.678 100 90 180 0 2085434896 50609200 27846496
14:44:01 5781 8192000000 11004903664 11425071104 2008549936 19.690 100 84 166 0 2086428640 51953648 25925056
14:44:14 1685 8192000000 11000786096 11413659648 1988943584 19.535 99 84 163 2 2069345232 54810160 25591488
14:44:23 1733 8192000000 10969371568 11377995776 1951221168 19.236 98 84 165 3 2035562480 58277472 26063840
14:44:31 2918 8192000000 10972653296 11386470400 1967993456 19.370 100 89 176 3 2057320880 60390096 28937328
14:44:41 4614 8192000000 10976727584 11393400832 1976914256 19.440 100 75 150 1 2063303136 62167536 24221344
14:44:55 4718 8192000000 10992887360 11406004224 1981650320 19.478 100 80 160 0 2069096976 61904832 25541824
14:45:08 2144 8192000000 11006762448 11416018944 1991887104 19.559 100 89 179 3 2083074576 62163184 29024288
14:45:16 4623 8192000000 10990702896 11412090880 1985075920 19.505 100 70 140 0 2071423936 62939728 23408288
14:45:28 2469 8192000000 10984461744 11398881280 1979436176 19.460 100 87 174 0 2068597152 61691728 27469248
14:45:37 7577 8192000000 10986122128 11405860864 1983494432 19.492 100 72 144 0 2067510320 60848800 23167088
14:45:51 3427 8192000000 10977993536 11399647232 1980570848 19.469 100 77 154 2 2063667712 58955776 24141088
14:46:05 8637 8192000000 10956396784 11387633664 1970279200 19.388 100 57 114 0 2044114096 55430896 18404000
14:46:24 10496 8192000000 10956570000 11393347584 1967300496 19.364 100 38 75 1 2033634000 53747408 12586096
14:46:41 8848 8192000000 10926203408 11360264192 1916521568 18.959 98 45 88 1 1984505792 53324416 14659808
14:46:59 6190 8192000000 10955494576 11376070656 1955495520 19.270 100 66 132 3 2028650864 51633360 21521984
14:47:13 2249 8192000000 10968897328 11379482624 1968736304 19.375 100 86 170 2 2050257968 53991296 27530368
14:47:22 7318 8192000000 10963982688 11383783424 1961093664 19.315 100 83 164 1 2048393664 61182048 26117952
14:47:41 3104 8192000000 10973929808 11393236992 1964416672 19.341 100 71 141 1 2049845024 61988960 23439392
14:47:51 6604 8192000000 10960126368 11386675200 1959477600 19.302 100 57 114 3 2041056896 62327680 19251616
14:48:04 12136 8192000000 10954144752 11391569920 1962419296 19.325 100 47 94 1 2040501760 61801808 16280656
14:48:26 4938 8192000000 10934405888 11372003328 1940941952 19.154 100 42 84 0 2020262864 64586496 14734416
14:48:38 6320 8192000000 10944712656 11379707904 1953314688 19.253 100 46 92 2 2027548128 58313712 15919728
14:48:56 2398 8192000000 10953235696 11382284288 1956292816 19.277 100 54 108 4 2036646000 62042048 18311136
14:49:09 11626 8192000000 10923668384 11365761024 1930739968 19.073 99 38 75 2 2001339264 57177696 13421600
14:49:30 11955 8192000000 10929888640 11375833088 1949738544 19.224 100 33 66 2 2013854448 52456144 11659760
14:50:04 16820 8192000000 10940003696 11379441664 1965583616 19.350 100 32 64 2 2020949328 44257488 11108224
14:50:27 14315 8192000000 10929467312 11381067776 1945943264 19.194 99 34 68 2 1999860544 42398832 11518448
14:51:02 15218 8192000000 10927421200 11371433984 1940616928 19.152 99 34 68 0 1990573264 38436368 11519968
14:51:24 9687 8192000000 10925606960 11366805504 1955913680 19.274 100 29 58 0 2006056048 40375296 9767072
14:51:45 18856 8192000000 10932171856 11377934336 1956823120 19.281 100 28 56 1 2013989808 46976544 10190144
14:52:10 25732 8192000000 10903840928 11363237888 1911961504 18.922 98 23 46 1 1963452720 43255184 8236032
14:53:21 43058 8192000000 10902442608 11363799040 1931966816 19.083 100 19 38 0 1987065360 47319488 7779056
14:54:28 78422 8192000000 10867875824 11345063936 1902021360 18.843 98 13 26 0 1956412384 48743584 5647440
14:55:56 48203 8192000000 10892081664 11329597440 1906432240 18.878 98 28 59 0 1922020752 7027984 8560528
14:56:59 89029 8192000000 10827676976 11280384000 1860345120 18.506 96 30 60 1 1875595504 7517792 7732592
14:58:41 46309 8192000000 10854724144 11315671040 1920060080 18.987 99 11 22 1 1930517088 7571232 2885776
14:59:33 57721 8192000000 10867379584 11327635456 1927737088 19.049 99 16 32 0 1938112528 6545696 3829744
15:00:38 26104 8192000000 10872101376 11333185536 1931794816 19.081 99 4 8 0 1941054896 8448240 811840
15:01:11 11470 8192000000 10864838704 11329658880 1931548752 19.079 99 3 6 0 1941400144 9139744 711648
15:01:29 43937 8192000000 10865133984 11321180160 1917388784 18.966 98 12 24 1 1934632160 13914080 3329296
15:04:09 56927 8192000000 10870687168 11352084480 1940271392 19.149 99 15 30 1 1953774624 9079488 4423744
15:05:13 14661 8192000000 10897248752 11351339008 1965558736 19.350 100 25 50 1 1979853936 6969344 7325856
15:05:34 6240 8192000000 10919526736 11365453824 1980093168 19.465 100 66 133 1 2007384832 8148960 19142704
15:05:53 54755 8192000000 10893890544 11365888000 1955221696 19.268 99 26 53 0 1970470064 8020736 7227632
15:06:54 42589 8192000000 10891903600 11372388352 1976391216 19.436 100 12 24 0 1989336176 9321296 3623664
15:07:50 46474 8192000000 10904930704 11364823040 1944885344 19.186 98 15 29 1 1958902512 10367520 3649648
15:08:43 77954 8192000000 10922869808 11392749568 1987252416 19.522 100 21 42 0 2002069184 8765776 6050992
15:10:07 90626 8192000000 10921044768 11393458176 1957998720 19.290 98 33 66 0 1989489152 21183360 10307072
15:13:43 24757 8192000000 10887352080 11357917184 1951574016 19.239 99 24 48 1 1976128032 16139376 8414640
15:14:19 49668 8192000000 10915739840 11375046656 1963028288 19.330 99 26 52 0 1981158672 10522928 7607456
15:15:18 38745 8192000000 10914223104 11391037440 1972977008 19.409 100 27 54 1 1991654512 11629360 7048144
15:16:21 32357 8192000000 10930570592 11394248704 1993124944 19.568 100 26 52 2 2017820864 17270304 7425616
15:17:23 25605 8192000000 10904332544 11364941824 1938783200 19.137 97 43 85 1 1964117648 12803568 12530880
15:17:55 51644 8192000000 10926372160 11392634880 1964298080 19.340 99 24 48 1 1990829504 19857056 6674368
15:18:53 84979 8192000000 10913494768 11388506112 1968158176 19.371 99 14 28 0 1993130496 20831888 4140432
15:20:24 63377 8192000000 10919167552 11377143808 1923334384 19.014 97 26 51 0 1943770368 13526144 6909840
15:21:36 51046 8192000000 10897965824 11367968768 1951234080 19.236 99 14 28 1 1966779248 11828384 3716784
15:23:23 94736 8192000000 10917029680 11369132032 1927515712 19.047 97 26 52 0 1946187232 11658000 7013520
15:25:09 92877 8192000000 10901721760 11372318720 1956004400 19.274 99 24 48 1 1970350656 7759072 6587184
15:27:15 56614 8192000000 10913364432 11365470208 1924320304 19.021 97 54 104 2 1946787904 8009216 14458384
15:28:23 15742 8192000000 10910824656 11356332032 1944292736 19.181 98 50 98 2 1973908256 15500096 14115424
15:28:45 23843 8192000000 10917377136 11373117440 1980726624 19.470 100 34 68 1 2007093312 16713920 9652768
15:29:15 29147 8192000000 10886075648 11360919552 1924040272 19.019 97 20 40 2 1946386672 16901760 5444640
15:32:30 36840 8192000000 10870939856 11334119424 1868750048 18.574 95 22 44 1 1883247152 7912480 6584624
15:33:18 47696 8192000000 10865080016 11337392128 1899236336 18.820 97 24 48 0 1916554752 9981136 7337280
15:34:12 31088 8192000000 10879061552 11345145856 1929560176 19.063 99 12 24 0 1943558352 10806432 3191744
15:35:28 46178 8192000000 10871957616 11330174976 1895551344 18.790 97 26 51 2 1911227072 8343744 7331984
15:36:20 44341 8192000000 10884080528 11331428352 1874306016 18.619 96 39 78 0 1894051232 8801312 10943904
15:37:20 50657 8192000000 10856603680 11323502592 1853228896 18.448 96 15 30 2 1868267808 10878192 4160720
15:38:25 67538 8192000000 10865528928 11333402624 1890647888 18.751 98 14 28 1 1910627520 15972896 4006736
15:40:15 84118 8192000000 10845789808 11306684416 1812172336 18.114 94 9 18 1 1828980032 14591568 2216128
15:43:02 34482 8192000000 10884939744 11337117696 1909750672 18.905 98 16 31 1 1922724992 8760624 4213696
15:43:47 28103 8192000000 10886552368 11342462976 1930334208 19.070 99 27 54 0 1951504128 13226048 7943872
15:44:22 65542 8192000000 10893546080 11357347840 1954106528 19.259 100 21 42 1 1973509968 13364016 6039424
15:45:34 84148 8192000000 10894271984 11352158208 1958374512 19.293 100 24 48 2 1977952832 11843392 7734928
15:47:09 58901 8192000000 10870629664 11335208960 1887183392 18.723 96 29 58 2 1904974960 9251984 8539584
15:48:20 19129 8192000000 10881341536 11349504000 1951496464 19.238 100 24 47 0 1966584832 8516416 6571952
15:48:45 25990 8192000000 10875182016 11354107904 1961494768 19.318 100 20 40 2 1975943712 9116656 5332288
15:49:23 72088 8192000000 10882997280 11365392384 1930714816 19.073 98 7 14 0 1947060800 14391872 1954112
15:50:44 67864 8192000000 10889181216 11365076992 1952268016 19.245 99 17 34 0 1970278480 12685888 5324576
15:52:35 72978 8192000000 10897628608 11381669888 1970073664 19.386 100 18 36 1 1990127152 14584656 5468832
15:53:54 48860 8192000000 10885165872 11377602560 1929440912 19.062 98 12 24 0 1949962880 17087680 3434288
15:55:19 36015 8192000000 10887125040 11358601216 1931316160 19.077 98 24 48 1 1953023488 14400688 7306640
15:56:01 66957 8192000000 10860201328 11340476416 1879187760 18.659 96 15 31 3 1893874704 9815328 4871616
15:57:16 29082 8192000000 10907442784 11347619840 1930036608 19.067 98 44 87 2 1948833568 6839200 11957760
15:57:54 25835 8192000000 10905661536 11368919040 1975287184 19.427 100 39 78 1 1995823216 9865344 10670688
15:58:26 77407 8192000000 10909417424 11386765312 1963295360 19.332 99 14 28 1 1976798048 9450400 4052288
15:59:52 58676 8192000000 10913672576 11379249152 1925719440 19.033 97 24 49 0 1941781488 9970720 6091328
16:01:02 83577 8192000000 10905483792 11366752256 1924921872 19.026 97 24 49 1 1947195248 15726592 6546784
16:03:05 47622 8192000000 10911661936 11376537600 1935364032 19.110 98 19 38 1 1952437808 11095776 5978000
16:04:01 83980 8192000000 10899741696 11383382016 1931015216 19.075 98 12 23 2 1949071520 15126368 2929936
16:05:31 73752 8192000000 10919835536 11385905152 1963352816 19.333 99 15 30 1 1978656752 11450288 3853648
16:06:54 34739 8192000000 10918556464 11352977408 1895419696 18.789 95 29 58 0 1910955760 7879312 7656752
16:07:39 32676 8192000000 10919829200 11383070720 1977513104 19.445 100 22 44 2 1992157104 8813536 5830464
16:08:18 23762 8192000000 10932584720 11381080064 1957788960 19.288 98 29 58 1 1975560944 9794944 7977040
16:08:50 107617 8192000000 10921320784 11382964224 1965548224 19.350 99 30 60 1 1987637840 13219680 8869936
16:10:48 55374 8192000000 10923839808 11393843200 1977005664 19.441 99 32 64 1 2001272944 15510368 8756912
16:11:49 16101 8192000000 10914867056 11395903488 1984662880 19.502 100 13 26 1 2002488512 14313872 3511760
16:12:14 11858 8192000000 10885962864 11373649920 1965410112 19.349 100 6 12 1 1984357840 16797664 2150064
16:12:34 12615 8192000000 10877269792 11367460864 1948071536 19.211 99 9 18 0 1961180400 10819008 2289856
16:13:01 28970 8192000000 10879572688 11368710144 1962977312 19.330 100 5 10 0 1974327744 10085088 1265344
16:13:43 48623 8192000000 10884773984 11363594240 1952425152 19.246 99 9 18 0 1965801632 11179904 2196576
16:15:23 62865 8192000000 10906660864 11392331776 1984767216 19.502 100 9 18 1 1999707136 12149264 2790656
16:16:39 77797 8192000000 10868627120 11357474816 1846108800 18.391 93 13 26 1 1867591904 18188784 3294320
16:18:05 36867 8192000000 10880674544 11343740928 1900379824 18.829 97 19 36 3 1917415008 11739408 5295776
16:18:48 44848 8192000000 10896415648 11346935808 1917901056 18.970 98 24 48 1 1940820112 16134624 6784432
16:19:42 53745 8192000000 10886215952 11364454400 1907025520 18.883 97 29 59 0 1938314320 23110464 8178336
16:20:45 34261 8192000000 10909550336 11365314560 1949702608 19.224 99 31 61 1 1970847792 11691904 9453280
16:21:26 56711 8192000000 10856556512 11324825600 1873268048 18.611 96 20 40 1 1890426576 11418800 5739728
16:22:29 33035 8192000000 10834213072 11303964672 1834007120 18.292 95 17 34 1 1850689936 11850304 4832512
16:23:08 52313 8192000000 10857774688 11324710912 1902467568 18.846 99 28 56 0 1925400256 15479744 7452944
16:24:26 108079 8192000000 10881650224 11320373248 1838806000 18.331 95 19 38 0 1854454304 9584112 6064192
16:26:21 44939 8192000000 10862780016 11318308864 1910032304 18.907 99 34 68 2 1935781024 15950896 9797824
16:27:13 22001 8192000000 9182512160 9429487616 338320720 3.966 18 2 4 0 346448032 7592256 535056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 174 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-01-2021 16:28:56 to 27-01-2021 16:28:58.

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          247208
MON$OLDEST_ACTIVE               247209
MON$OLDEST_SNAPSHOT             247209
MON$NEXT_TRANSACTION            247209
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                       2017856
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:58: 
:59: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:38 2021
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:77: 
:78: 
:79: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
:82: 
:83: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:84:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:85: 
:86: 
:87: mscs-test-161.budzdorov.ru    Wed Jan 27 16:27:41 2021
:88:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:89: 
--- end of diff output ---

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

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