Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.03.2021 16:32
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17665044 kB
MemAvailable 31470448 kB
Buffers 0 kB
Cached 13990440 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-27 16:31:50
DTS_END                         2021-03-27 16:31:50.3240
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/48762
TRN_ID                          233556
ATT_ID                          618
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: 8811.63 20776 1057396
customer order: creation 169.10 396 20292
customer order: refuse 14.24 353 1709
order to supplier: creation 44.13 1362 5295
order to supplier: removal 3.13 111370 376
invoice (draft): creation 45.99 3524 5519
invoice (draft): removal 49.72 779 5966
invoice accept: apply 41.03 19563 4924
invoice accept: cancel 44.74 837 5369
customer reserve: creation 3770.08 195 452410
customer reserve: removal 4333.50 64 520020
realization accept: apply 83.63 177 10035
realization accept: cancel 86.29 108 10355
payment from customer: creation 57.78 127 6934
payment from customer: removal 5.53 75 664
payment to supplier: creation 46.80 135 5616
payment to supplier: removal 3.20 85 384
service: total inventory turnovers 4.92 1095 590
service: total monetary turnovers 6.98 43 837
service: aggregate perf. data 0.81 20650 97
service: refresh index statistics 0.03 254586 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2021 16:32:47 to 27-03-2021 16:32:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1144
TEST_TIME 2 2359
TEST_TIME 3 3426
TEST_TIME 4 3784
TEST_TIME 5 4093
TEST_TIME 6 4230
TEST_TIME 7 4788
TEST_TIME 8 5054
TEST_TIME 9 5332
TEST_TIME 10 5332
TEST_TIME 11 5369
TEST_TIME 12 5764
TEST_TIME 13 6148
TEST_TIME 14 6226
TEST_TIME 15 6377
TEST_TIME 16 6641
TEST_TIME 17 6857
TEST_TIME 18 7005
TEST_TIME 19 7611
TEST_TIME 20 7724
TEST_TIME 21 8162
TEST_TIME 22 8477
TEST_TIME 23 8747
TEST_TIME 24 9448
TEST_TIME 25 9823
TEST_TIME 26 10253
TEST_TIME 27 10192
TEST_TIME 28 10027
TEST_TIME 29 10005
TEST_TIME 30 9752
TEST_TIME 31 9720
TEST_TIME 32 9891
TEST_TIME 33 9759
TEST_TIME 34 9638
TEST_TIME 35 9534
TEST_TIME 36 9381
TEST_TIME 37 9276
TEST_TIME 38 9172
TEST_TIME 39 9037
TEST_TIME 40 8959
TEST_TIME 41 8897
TEST_TIME 42 8768
TEST_TIME 43 8703
TEST_TIME 44 8588
TEST_TIME 45 8514
TEST_TIME 46 8627
TEST_TIME 47 8716
TEST_TIME 48 8643
TEST_TIME 49 8782
TEST_TIME 50 8729
TEST_TIME 51 8823
TEST_TIME 52 8792
TEST_TIME 53 8766
TEST_TIME 54 8724
TEST_TIME 55 8770
TEST_TIME 56 8774
TEST_TIME 57 8801
TEST_TIME 58 8896
TEST_TIME 59 9042
TEST_TIME 60 8982
TEST_TIME 61 8865
TEST_TIME 62 8819
TEST_TIME 63 8753
TEST_TIME 64 8766
TEST_TIME 65 8707
TEST_TIME 66 8652
TEST_TIME 67 8661
TEST_TIME 68 8618
TEST_TIME 69 8654
TEST_TIME 70 8782
TEST_TIME 71 8774
TEST_TIME 72 8715
TEST_TIME 73 8791
TEST_TIME 74 8772
TEST_TIME 75 8837
TEST_TIME 76 8918
TEST_TIME 77 8861
TEST_TIME 78 8867
TEST_TIME 79 8900
TEST_TIME 80 8991
TEST_TIME 81 8939
TEST_TIME 82 8859
TEST_TIME 83 8836
TEST_TIME 84 8772
TEST_TIME 85 8745
TEST_TIME 86 8757
TEST_TIME 87 8748
TEST_TIME 88 8706
TEST_TIME 89 8707
TEST_TIME 90 8702
TEST_TIME 91 8705
TEST_TIME 92 8727
TEST_TIME 93 8724
TEST_TIME 94 8739
TEST_TIME 95 8711
TEST_TIME 96 8831
TEST_TIME 97 8829
TEST_TIME 98 8912
TEST_TIME 99 8958
TEST_TIME 100 8939
TEST_TIME 101 8946
TEST_TIME 102 8929
TEST_TIME 103 8953
TEST_TIME 104 8893
TEST_TIME 105 8838
TEST_TIME 106 8838
TEST_TIME 107 8794
TEST_TIME 108 8769
TEST_TIME 109 8724
TEST_TIME 110 8744
TEST_TIME 111 8682
TEST_TIME 112 8702
TEST_TIME 113 8718
TEST_TIME 114 8770
TEST_TIME 115 8765
TEST_TIME 116 8751
TEST_TIME 117 8786
TEST_TIME 118 8774
TEST_TIME 119 8785
TEST_TIME 120 8813

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-03-2021 16:32:50 to 27-03-2021 16:32:54.

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 1475439 1475439 0 0.00 0 42888 7 0 0
doc_list_biud 1475439 1475439 0 0.00 0 25411 28 0 0
sp_add_invoice_to_stock 5010 4924 86 1.71 35 276452 19563 0 86
sp_cancel_adding_invoice 5369 5369 0 0.00 4 57100 838 0 0
sp_cancel_client_order 1709 1709 0 0.00 5 14074 353 0 0
sp_cancel_customer_reserve 520020 520020 0 0.00 1 25328 64 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 2 5939 76 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 2 4368 85 0 0
sp_cancel_supplier_invoice 5972 5966 6 0.10 2 23134 780 0 6
sp_cancel_supplier_order 376 376 0 0.00 8 997116 111370 0 0
sp_cancel_write_off 10355 10355 0 0.00 1 13087 108 0 0
sp_client_order 20292 20292 0 0.00 3 17601 396 0 0
sp_customer_reserve 452410 452410 0 0.00 0 41221 196 0 0
sp_fill_shopping_cart 31103 31103 0 0.00 1 24571 44 0 0
sp_fill_shopping_cart_clo_res 452406 452406 0 0.00 0 14554 14 0 0
sp_get_clo_for_invoice 4920 4920 0 0.00 0 31908 326 0 0
sp_kill_cost_storno 16772 16772 0 0.00 0 10418 56 0 0
sp_kill_qstorno_ret_qs2qd 1056737 1056737 0 0.00 0 25322 34 0 0
sp_kill_qty_storno 558750 558750 0 0.00 0 25410 73 0 0
sp_lock_selected_doc 20534 20534 0 0.00 0 13549 6 0 0
sp_make_cost_storno 27505 27505 0 0.00 0 42880 56 0 0
sp_multiply_rows_for_pdistr 27505 27505 0 0.00 0 7485 31 0 0
sp_multiply_rows_for_qdistr 20292 20292 0 0.00 0 16422 181 0 0
sp_pay_from_customer 6934 6934 0 0.00 4 44322 127 0 0
sp_pay_to_supplier 5616 5616 0 0.00 5 13264 135 0 0
sp_payment_common 12550 12550 0 0.00 1 44315 36 0 0
sp_qd_handle_on_cancel_clo 1709 1709 0 0.00 0 8997 321 0 0
sp_qd_handle_on_invoice_upd_sts 10289 10289 0 0.00 0 25410 320 0 0
sp_qd_handle_on_reserve_upd_sts 10035 10035 0 0.00 0 15363 53 0 0
sp_reserve_write_off 10035 10035 0 0.00 6 17605 178 0 0
sp_supplier_invoice 5519 5519 0 0.00 6 86078 3524 0 0
sp_supplier_order 5295 5295 0 0.00 5 31562 1362 0 0
srv_aggregate_perf_data 97 97 0 0.00 2297 366613 20651 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1391 180491 30265 0 0
srv_find_qd_qs_mism 1010298 1010298 0 0.00 0 14821 7 0 0
srv_make_invnt_saldo 590 590 0 0.00 37 91519 1095 0 0
srv_make_money_saldo 837 837 0 0.00 1 11457 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 181402 434553 254586 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4925 4925 0 0.00 0 24273 177 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 22432 158 0 0
t$perf-norm:sp_cancel_client_order 1709 1709 0 0.00 0 24188 33 0 0
t$perf-norm:sp_cancel_customer_reserve 661 661 0 0.00 0 3088 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 2259 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 264 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 388 388 0 0.00 0 3282 28 0 0
t$perf-norm:sp_cancel_supplier_order 376 376 0 0.00 0 33409 1766 0 0
t$perf-norm:sp_cancel_write_off 991 991 0 0.00 0 2043 7 0 0
t$perf-norm:sp_client_order 20292 20292 0 0.00 0 14338 20 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 21333 60 0 0
t$perf-norm:sp_pay_from_customer 6934 6934 0 0.00 0 29102 16 0 0
t$perf-norm:sp_pay_to_supplier 5616 5616 0 0.00 0 12339 14 0 0
t$perf-norm:sp_reserve_write_off 10035 10035 0 0.00 0 23871 15 0 0
t$perf-norm:sp_supplier_invoice 5519 5519 0 0.00 0 11100 24 0 0
t$perf-norm:sp_supplier_order 5295 5295 0 0.00 0 8768 19 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 1435 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 974 10 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 1624 34 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 2524 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 7 5 0 0
v_add_invoice_to_stock 9998 9826 172 1.72 0 6143 18 0 172
v_all_customers 36812 36812 0 0.00 0 40 1 0 0
v_all_suppliers 29736 29736 0 0.00 0 15 1 0 0
v_all_wares 40584 40584 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 1021 7 0 0
v_cancel_client_order 3418 3418 0 0.00 0 2713 5 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 5897 13 0 0
v_cancel_customer_reserve 1322 1322 0 0.00 0 2337 5 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 1086 5 0 0
v_cancel_supplier_invoice 788 776 12 1.52 0 11811 30 0 12
v_cancel_supplier_order 752 752 0 0.00 0 2862 11 0 0
v_cancel_write_off 1982 1982 0 0.00 0 1191 13 0 0
v_max_id_clo_ord 5295 5295 0 0.00 0 5093 5 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 2407 13 0 0
v_max_id_ord_sup 5516 5516 0 0.00 0 4115 4 0 0
v_max_non_paid_invoice 1559 1559 0 0.00 0 2398 5 0 0
v_max_non_paid_realizn 3669 3669 0 0.00 0 2893 3 0 0
v_min_id_clo_ord 5295 5295 0 0.00 0 5216 9 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 6696 18 0 0
v_min_id_ord_sup 5516 5516 0 0.00 0 5822 8 0 0
v_min_non_paid_invoice 5616 5616 0 0.00 0 13226 20 0 0
v_min_non_paid_realizn 6934 6934 0 0.00 0 11379 26 0 0
v_our_firm 10302 10302 0 0.00 0 20 1 0 0
v_reserve_write_off 20070 20070 0 0.00 0 17507 6 0 0
x_lock_depdocs_on_canc_invoice 10947 10947 0 0.00 0 11954 139 0 0
x_lock_depdocs_on_canc_sup_ord 376 376 0 0.00 0 10991 398 0 0
x_make_qstorno_1000_1200 5295 5295 0 0.00 2 31538 1280 0 0
x_make_qstorno_1200_2000 5519 5519 0 0.00 3 83658 3361 0 0
x_make_qstorno_2100_3300 452410 452410 0 0.00 0 41220 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2021 16:32:55 to 27-03-2021 16:32:59.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:54 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:00 9938 8192000000 10214568208 10513346560 870280752 9.603 69 53 106 0 890283760 2344352 17658656
14:02:18 24834 8192000000 10314789648 10631229440 1364086160 14.274 100 86 172 0 1397551664 4937856 28527648
14:03:00 18550 8192000000 10368383312 10683871232 1409173904 14.677 100 88 176 0 1444914592 6679440 29061248
14:03:30 30867 8192000000 10403450832 10730254336 1449266816 15.031 100 88 176 0 1485633936 7838512 28528608
14:04:14 24351 8192000000 10433627984 10762964992 1485447472 15.349 100 89 178 1 1523180128 8972704 28759952
14:04:47 12011 8192000000 10444127792 10775392256 1497545408 15.455 100 93 185 1 1537461984 9573104 30343472
14:05:15 22810 8192000000 10461339408 10795839488 1508550832 15.551 100 87 173 1 1545874256 9691840 27631584
14:05:52 21186 8192000000 10489020368 10830237696 1536036448 15.789 100 81 162 0 1571478608 9975104 25467056
14:06:20 12128 8192000000 10503473088 10848960512 1557526528 15.975 100 76 152 0 1591225744 9936816 23762400
14:06:41 14381 8192000000 10542447984 10892120064 1593859888 16.287 100 83 166 0 1630087680 10833968 25393824
14:07:07 16261 8192000000 10554523888 10911952896 1614519328 16.463 100 83 163 2 1650444864 11730640 24194896
14:07:34 13156 8192000000 10594498240 10950340608 1641298576 16.691 100 84 168 0 1678703936 12339552 25065808
14:07:55 11046 8192000000 10596121936 10959962112 1657774000 16.830 100 79 158 1 1694346336 13214640 23357696
14:08:17 10138 8192000000 10614813744 10982158336 1673505792 16.963 100 83 166 1 1711220048 14101728 23612528
14:08:35 8107 8192000000 10636365040 11005267968 1692883168 17.125 100 85 170 3 1731282864 13582688 24817008
14:08:52 7514 8192000000 10651150112 11021459456 1704401088 17.222 100 79 159 1 1740824768 13272368 23151312
14:09:07 5924 8192000000 10666943264 11038461952 1722906864 17.376 100 83 166 2 1760536112 13994736 23634512
14:09:21 4890 8192000000 10684582048 11055034368 1734553296 17.473 100 80 159 1 1770679600 13696592 22429712
14:09:33 6131 8192000000 10674233824 11055095808 1742964240 17.543 100 80 159 0 1779361392 13306336 23090816
14:09:46 5298 8192000000 10695962272 11074285568 1757289584 17.662 100 79 158 0 1793319024 13209152 22820288
14:09:58 3532 8192000000 10719767648 11092078592 1773186368 17.793 100 89 179 2 1811850592 13132976 25531248
14:10:08 5181 8192000000 10714172864 11098517504 1775893392 17.816 100 72 141 0 1808608352 12583552 20131408
14:10:21 3431 8192000000 10735355808 11113254912 1791659664 17.945 100 90 178 3 1830043184 12042736 26340784
14:10:30 3085 8192000000 10738162480 11120566272 1798607968 18.002 100 91 178 2 1836781136 12244272 25928896
14:10:40 3371 8192000000 10748336864 11128688640 1808664144 18.085 100 89 178 0 1846477840 12700816 25112880
14:10:50 3397 8192000000 10748180000 11135913984 1811488848 18.108 100 82 164 1 1846631920 12056544 23086528
14:11:01 8732 8192000000 10758169680 11145998336 1820567776 18.182 100 82 160 2 1856183472 12841712 22773984
14:11:16 5183 8192000000 10771331856 11158986752 1824611424 18.215 100 80 160 0 1860202112 12929184 22661504
14:11:28 2198 8192000000 10789326032 11177078784 1848948752 18.414 100 87 173 4 1885864992 12783728 24132512
14:11:36 1334 8192000000 10793741600 11178397696 1842976560 18.365 100 86 173 0 1880902704 13715328 24210816
14:11:44 1764 8192000000 10786430768 11173670912 1846081120 18.390 100 82 164 1 1882284144 13159008 23044016
14:11:52 2207 8192000000 10795457808 11185156096 1855514672 18.467 100 88 176 0 1892927328 12290464 25122192
14:12:00 1758 8192000000 10795693296 11182661632 1854501568 18.459 100 91 184 0 1892641280 12959216 25180496
14:12:09 2331 8192000000 10804672448 11190542336 1856870688 18.478 100 98 196 1 1898728432 14104848 27752896
14:12:17 2478 8192000000 10799915552 11190890496 1861264416 18.514 100 88 178 1 1900807584 13356640 26186528
14:12:26 1898 8192000000 10813355152 11198578688 1867191920 18.562 100 93 187 0 1905344720 11764688 26388112
14:12:34 46109 8192000000 10795384256 11197636608 1863485808 18.532 100 51 105 2 1884240864 6998736 13756320
14:13:27 22003 8192000000 10770070992 11194363904 1860620240 18.508 100 28 56 0 1875216112 6703664 7892208
14:13:58 4946 8192000000 10791014848 11207168000 1870405008 18.588 100 38 77 3 1887125968 6534176 10186784
14:14:11 3784 8192000000 10811347408 11212550144 1877932880 18.648 100 59 114 3 1903747888 8081984 17733024
14:14:22 3771 8192000000 10802172592 11218214912 1878475856 18.653 100 54 104 1 1903878160 10792496 14609808
14:14:32 5546 8192000000 10798581920 11214249984 1879436672 18.661 100 43 87 0 1900659840 9070944 12152224
14:14:45 2686 8192000000 10804712384 11221196800 1884677472 18.703 100 55 108 1 1909964800 9618064 15669264
14:14:56 9171 8192000000 10791300192 11220484096 1880998352 18.673 100 31 62 3 1896903072 6868752 9035968
14:15:12 9720 8192000000 10805427488 11230908416 1887704528 18.727 100 37 74 2 1904331264 6270544 10356192
14:15:29 8467 8192000000 10798878208 11227107328 1887929312 18.729 100 32 63 1 1904256080 7763504 8563264
14:15:46 8938 8192000000 10803175280 11228098560 1888800848 18.736 100 28 54 3 1902994832 6399168 7794816
14:16:02 19972 8192000000 10794278064 11224797184 1889759776 18.744 100 15 30 0 1899701056 5672704 4268576
14:16:29 7567 8192000000 10802102400 11232239616 1892606864 18.767 100 27 53 3 1907050224 7169584 7273776
14:16:49 14844 8192000000 10805106432 11239981056 1894466576 18.782 100 21 42 0 1907289904 6878544 5944784
14:17:10 47011 8192000000 10813144128 11241676800 1903225856 18.852 100 30 60 0 1917447376 5716848 8504672
14:18:11 25090 8192000000 10802625408 11245256704 1899193888 18.820 100 24 47 1 1912206800 6202080 6810832
14:18:45 5780 8192000000 10814176560 11249307648 1904787632 18.865 100 36 72 1 1922280976 7155040 10338304
14:19:00 9376 8192000000 10817988624 11249782784 1903533792 18.855 100 30 61 1 1917300256 5349568 8416896
14:19:16 6875 8192000000 10832454272 11259985920 1908072656 18.891 100 44 87 5 1928227456 7374960 12779840
14:19:31 5102 8192000000 10819630240 11262566400 1911003344 18.915 100 31 62 1 1931659328 11068656 9587328
14:19:43 7410 8192000000 10822960624 11260710912 1912071920 18.923 100 31 62 1 1927112736 5550240 9490576
14:19:57 7192 8192000000 10839059280 11263471616 1914206048 18.940 100 24 48 0 1926917312 6081296 6629968
14:20:11 5611 8192000000 10817618576 11246874624 1897717552 18.808 99 33 66 1 1913872832 7241728 8913552
14:20:22 4545 8192000000 10821561408 11252162560 1901622096 18.839 100 25 50 0 1916095440 7551376 6921968
14:20:33 6694 8192000000 10829368992 11262255104 1905996160 18.874 100 28 55 3 1925004384 11009008 7999216
14:20:49 6140 8192000000 10829479680 11257200640 1906590720 18.879 100 26 52 0 1919936368 5987584 7358064
14:21:03 7814 8192000000 10815764144 11245809664 1873296944 18.611 98 30 60 4 1888107584 6476624 8334016
14:21:18 7288 8192000000 10802162816 11234172928 1860517872 18.507 98 25 51 0 1874847712 5754464 8575376
14:21:34 10407 8192000000 10803873856 11234447360 1886994400 18.722 100 24 47 1 1900648432 6683264 6970768
14:21:53 56571 8192000000 10800611984 11216769024 1807716256 18.077 96 27 54 2 1822082064 6020160 8345648
14:22:58 12488 8192000000 10817236128 11226820608 1867997456 18.568 99 77 152 3 1895645280 5136272 22511552
14:23:17 7675 8192000000 10764919504 11191209984 1806817824 18.070 96 26 51 3 1821055360 7161520 7076016
14:23:31 6160 8192000000 10736284880 11154219008 1774653472 17.805 96 28 52 2 1788085232 6224240 7207520
14:23:46 3079 8192000000 10761652000 11169091584 1788260704 17.917 97 37 70 1 1804559824 6847936 9451184
14:23:57 9175 8192000000 10731689632 11135344640 1752804944 17.625 95 32 65 1 1772112560 10445024 8862592
14:24:12 5393 8192000000 10725124096 11142864896 1801122016 18.023 99 35 70 0 1819272992 7799104 10351872
14:24:24 3045 8192000000 10764434192 11177177088 1841290464 18.351 100 37 72 2 1857480496 5405072 10784960
14:24:35 3742 8192000000 10763504224 11182411776 1843426624 18.369 100 40 79 1 1861996832 6902080 11668128
14:24:47 5714 8192000000 10723954192 11137482752 1764290928 17.720 97 17 34 0 1774433472 5144464 4998080
14:24:58 9794 8192000000 10692537904 11104063488 1725264416 17.396 96 20 40 3 1736979104 5218416 6496272
14:25:15 5002 8192000000 10692871680 11099492352 1762912848 17.708 98 36 71 1 1778736752 5359408 10464496
14:25:29 5807 8192000000 10717628912 11126603776 1769341872 17.762 98 33 66 2 1784860048 6295712 9222464
14:25:41 8192 8192000000 10691107136 11101863936 1745185872 17.562 97 15 30 1 1754670816 4924976 4559968
14:25:56 10014 8192000000 10719603616 11126755328 1758824704 17.675 97 34 68 0 1774764688 4967152 10972832
14:26:13 56508 8192000000 10710849152 11132379136 1739016288 17.510 96 37 71 3 1754455728 5436752 10002688
14:27:20 14445 8192000000 10735559824 11154739200 1811364064 18.107 100 23 46 1 1828218352 9361168 7493120
14:27:41 6171 8192000000 10724063056 11138482176 1776159536 17.818 98 32 65 2 1791372016 5507520 9704960
14:27:54 7146 8192000000 10756515600 11167526912 1830686784 18.265 100 47 94 2 1851523632 7116912 13719936
14:28:09 4805 8192000000 10757904272 11170975744 1830229264 18.261 100 25 49 3 1843089552 5741328 7118960
14:28:21 9449 8192000000 10764920992 11180638208 1839014752 18.333 100 31 62 1 1854061104 5931184 9115168
14:28:38 8581 8192000000 10758033200 11185377280 1847400320 18.401 100 26 52 0 1860345840 5286288 7659232
14:28:52 7478 8192000000 10773697392 11195994112 1852356720 18.441 100 26 52 2 1866059840 6088128 7614992
14:29:06 7103 8192000000 10780567408 11199836160 1854989472 18.463 100 35 70 1 1871304880 5747600 10567808
14:29:23 6615 8192000000 10779110032 11202494464 1858434976 18.491 100 34 69 2 1874886368 5439184 11012208
14:29:39 7911 8192000000 10779037360 11205279744 1861186304 18.513 100 27 52 1 1874131184 5468208 7476672
14:29:58 8185 8192000000 10778738976 11205697536 1861446016 18.515 100 22 44 2 1873405616 5137152 6822448
14:30:14 9950 8192000000 10771315632 11206098944 1861587744 18.516 100 17 34 0 1871821584 5338128 4895712
14:30:31 68225 8192000000 10792700720 11223195648 1874106208 18.617 100 28 56 0 1887212192 4881312 8224672
14:31:46 35533 8192000000 10812160368 11232821248 1888583248 18.734 100 22 42 1 1899495552 4773792 6138512
14:32:45 33878 8192000000 10855452832 11275595776 1919982032 18.987 100 52 104 1 1945525344 10472560 15070752
14:33:32 19966 8192000000 10855900592 11284283392 1923208160 19.013 100 41 82 0 1949018656 13610608 12199888
14:34:00 13056 8192000000 10862936256 11289055232 1928128784 19.052 100 48 96 1 1956489680 14108128 14252768
14:34:22 20100 8192000000 10868763392 11295514624 1932713888 19.089 100 54 108 0 1963800352 15440608 15645856
14:34:51 13352 8192000000 10872554896 11304431616 1934256992 19.101 100 46 92 1 1966641792 19042016 13342784
14:35:17 15546 8192000000 10877190160 11307487232 1937649088 19.128 100 44 88 2 1964931536 14802032 12480416
14:35:40 10425 8192000000 10884332800 11312164864 1946465648 19.198 100 50 100 0 1978413584 17162848 14785088
14:36:03 17842 8192000000 10898337328 11319685120 1948998560 19.219 100 56 112 0 1982971408 17998560 15974288
14:36:29 11144 8192000000 10899922752 11325591552 1955113872 19.267 100 66 132 0 1994080112 19490560 19475680
14:36:47 17304 8192000000 10893435120 11327750144 1955458912 19.270 100 52 105 2 1989266784 17964960 15842912
14:37:13 13734 8192000000 10902202464 11331874816 1959074928 19.299 100 48 93 3 1993725840 20672832 13978080
14:37:37 4144 8192000000 10906368496 11330949120 1956328800 19.277 100 58 115 1 1994790992 21580208 16881984
14:37:48 10824 8192000000 10921626720 11342327808 1964119648 19.339 100 63 126 2 2005744496 23627808 17997040
14:38:06 4072 8192000000 10926308336 11345956864 1968388912 19.373 100 70 138 0 2012803968 24409392 20005664
14:38:18 13254 8192000000 10925162016 11352150016 1969567984 19.382 100 59 118 1 2012126304 25458560 17099760
14:38:40 8093 8192000000 10928474544 11349577728 1976268832 19.435 100 69 135 4 2020428256 24281440 19877984
14:39:09 7212 8192000000 10936844160 11365011456 1980403552 19.468 100 68 136 1 2026021744 26322656 19295536
14:39:23 4363 8192000000 10937644976 11364921344 1982671904 19.486 100 65 126 0 2026790384 25788688 18329792
14:39:36 8333 8192000000 10941258384 11367591936 1981805840 19.479 100 72 141 1 2028328096 26051248 20471008
14:39:54 17410 8192000000 10935482576 11370848256 1983378160 19.491 100 54 108 1 2027768080 28649184 15740736
14:40:27 2576 8192000000 10935063360 11356532736 1967014480 19.362 99 62 120 2 2012433840 28068608 17350752
14:40:37 9108 8192000000 10956091600 11383189504 1989177264 19.537 100 66 131 0 2040561472 32452528 18931680
14:40:55 15206 8192000000 10948205648 11383934976 1998822752 19.613 100 64 127 0 2045318448 27911952 18583744
14:41:22 6101 8192000000 10960247280 11393302528 2004653920 19.659 100 58 116 1 2053902608 30589568 18659120
14:41:35 10939 8192000000 10965461968 11399655424 2005036944 19.662 100 60 120 2 2055025232 31924128 18064160
14:41:54 11323 8192000000 10982546784 11410837504 2008036400 19.686 100 71 142 1 2063103424 33981776 21085248
14:42:16 5370 8192000000 10982610368 11403280384 1993825504 19.574 99 65 130 1 2049414272 36064416 19524352
14:42:30 2456 8192000000 10983369440 11408338944 2007565920 19.682 100 75 151 1 2067192176 36760864 22865392
14:42:39 8227 8192000000 10974071952 11403800576 1991444752 19.555 99 67 134 1 2050245392 38445232 20355408
14:42:57 7031 8192000000 10988867824 11403456512 2004359776 19.657 100 77 153 0 2067162768 40015504 22787488
14:43:12 2232 8192000000 10986209936 11406049280 2006512336 19.674 100 82 163 2 2071605120 40855152 24237632
14:43:21 2923 8192000000 10991810816 11413532672 2008655904 19.691 100 82 164 2 2075149104 40320128 26173072
14:43:32 10938 8192000000 10973057264 11405221888 2006488688 19.674 100 63 126 2 2063623904 37673440 19461776
14:43:50 2590 8192000000 10984935376 11411296256 2007134896 19.679 100 64 126 2 2065103520 38448992 19519632
14:44:05 5993 8192000000 10985004480 11420741632 2015222928 19.743 100 71 141 1 2076296912 39490336 21583648
14:44:24 12465 8192000000 10987986976 11422814208 2020089376 19.781 100 74 146 4 2076624208 35018336 21516496
14:44:45 10801 8192000000 10991058064 11433127936 2023679632 19.809 100 56 110 1 2076267936 35434320 17153984
14:45:03 4948 8192000000 10992609568 11434029056 2027283328 19.837 100 60 119 1 2082631040 37101056 18246656
14:45:16 2582 8192000000 10992760560 11408891904 1994383920 19.578 99 76 151 4 2053471632 36278480 22809232
14:45:28 2337 8192000000 10988819088 11406336000 2001411088 19.634 99 71 137 2 2060206256 37323552 21471616
14:45:37 1542 8192000000 11000623776 11429232640 2024971648 19.819 100 83 167 1 2089403264 38948928 25482688
14:45:55 3026 8192000000 11005000736 11429208064 2022849536 19.803 100 74 148 2 2085902032 40427904 22624592
14:46:05 2277 8192000000 11010325440 11435298816 2028690320 19.848 100 79 157 0 2093787136 41454288 23642528
14:46:17 3383 8192000000 11003110320 11423850496 2018151792 19.766 100 83 165 0 2085899312 42162496 25585024
14:46:27 4576 8192000000 10995048400 11420917760 2003241168 19.648 99 76 151 2 2066741792 40639712 22860912
14:46:38 6649 8192000000 10988937744 11415478272 2011136208 19.710 100 80 162 1 2077179888 40214336 25829344
14:46:52 1391 8192000000 11006200752 11427962880 2023132368 19.805 100 82 164 1 2088957264 40722144 25102752
14:47:01 1482 8192000000 11026516784 11444277248 2034965936 19.898 100 91 177 2 2106922368 43416688 28539744
14:47:11 3104 8192000000 11016122832 11439407104 2016769184 19.755 99 84 166 3 2086219392 44006816 25443392
14:47:21 5601 8192000000 11008321840 11437625344 2026318528 19.830 100 73 144 0 2094309472 45333184 22657760
14:47:35 2142 8192000000 10987689136 11406651392 2001190992 19.632 99 74 148 0 2067251184 43322944 22737248
14:47:45 1943 8192000000 10992559344 11412520960 1999357776 19.618 100 84 168 1 2072465040 46576144 26531120
14:47:54 2433 8192000000 10986235600 11400142848 1969955584 19.385 98 89 176 1 2045123360 48063136 27104640
14:48:05 3208 8192000000 10973284480 11389419520 1972015888 19.401 99 73 146 1 2044235888 49616464 22603536
14:48:17 1936 8192000000 11007967232 11419648000 2004393616 19.657 100 93 186 4 2083221952 50150400 28677936
14:48:27 1508 8192000000 10958254160 11372855296 1949711712 19.224 97 92 183 2 2025955040 48306528 27936800
14:48:36 3720 8192000000 10980835024 11394686976 1981508384 19.477 100 87 171 2 2056818992 49666400 25644208
14:48:53 3182 8192000000 10997679984 11411668992 1997361872 19.602 100 86 170 0 2074647504 49824800 27460832
14:49:04 3131 8192000000 10992237056 11412148224 2003032592 19.647 100 85 169 1 2078969040 49604960 26331488
14:49:15 2756 8192000000 10983305936 11403169792 1988795904 19.534 100 87 172 1 2067081920 50832880 27453136
14:49:25 3981 8192000000 10990904800 11410235392 1993774288 19.574 100 80 159 0 2069300176 50266608 25259280
14:49:38 6735 8192000000 10970612880 11397951488 1954977696 19.266 98 72 144 3 2028755904 50185424 23592784
14:49:54 4708 8192000000 10970759552 11388338176 1975607232 19.430 100 77 154 2 2053865568 53219472 25038864
14:50:06 1778 8192000000 10979972912 11393310720 1977274000 19.443 100 85 170 2 2060393984 55024864 28095120
14:50:17 4267 8192000000 10982720112 11400638464 1981352976 19.475 100 81 162 3 2063270256 55266384 26650896
14:50:27 3835 8192000000 10983772512 11408482304 1986961488 19.520 100 73 145 1 2064435568 54331536 23142544
14:50:40 7570 8192000000 10972482576 11404820480 1992404176 19.563 100 65 129 0 2057658240 44496992 20757072
14:50:55 8052 8192000000 10958930208 11392012288 1978057456 19.449 100 57 114 1 2042356896 45916832 18382608
14:51:10 16264 8192000000 10952188320 11389595648 1944977680 19.186 98 54 109 0 2010135296 46992064 18165552
14:51:38 4140 8192000000 10958063904 11379388416 1976040608 19.433 100 81 159 1 2044646384 43090816 25514960
14:51:50 1946 8192000000 10978888608 11391152128 1965865408 19.353 99 93 183 1 2040864768 45621376 29377984
14:52:00 3394 8192000000 10967547280 11394363392 1979119520 19.458 100 71 142 0 2051162464 49612352 22430592
14:52:18 13891 8192000000 10935546560 11388542976 1969473488 19.381 100 44 88 1 2031887328 47429840 14984000
14:52:40 7627 8192000000 10942462992 11381981184 1972235344 19.403 100 45 88 1 2032265520 45736320 14293856
14:53:01 7923 8192000000 10967187264 11401793536 1987161824 19.521 100 57 113 1 2051216224 44871840 19182560
14:53:20 14400 8192000000 10953003696 11402813440 1969108816 19.378 99 39 78 0 2033298464 50884864 13304784
14:54:01 23017 8192000000 10949298704 11407331328 1982593808 19.485 100 28 56 1 2038137104 45662080 9881216
14:54:34 11682 8192000000 10926535040 11383246848 1950071376 19.227 99 33 66 1 2005780704 44078784 11630544
14:54:53 11293 8192000000 10933167040 11384381440 1961779712 19.320 100 31 62 0 2020134064 47199584 11154768
14:55:41 18862 8192000000 10896912688 11351924736 1929098976 19.060 99 23 47 0 1973725776 37155392 7471408
14:56:14 34828 8192000000 10907953936 11371704320 1941721840 19.160 100 15 30 0 1992490480 45446064 5322576
14:57:43 22866 8192000000 10855425152 11326558208 1891551248 18.758 97 41 84 0 1932364432 28234672 12578512
14:59:15 50364 8192000000 10861706336 11329273856 1908466336 18.894 98 23 46 0 1931343840 16439520 6437984
15:00:12 38048 8192000000 10855993952 11325734912 1918086256 18.972 99 7 14 3 1937614560 17070352 2457952
15:01:45 17850 8192000000 10884934672 11350425600 1951073840 19.235 100 12 24 0 1977645248 23043376 3528032
15:02:34 26874 8192000000 10901131856 11353669632 1960159728 19.307 100 21 44 1 1975311344 9707568 5444048
15:03:11 180491 8192000000 10858826544 11319631872 1822390528 18.197 93 15 30 1 1833889184 8397088 3101568
15:06:18 85295 8192000000 10851100112 11308019712 1905685728 18.872 98 17 34 0 1918916608 8861024 4369856
15:07:59 83514 8192000000 10850991168 11317297152 1901461616 18.838 98 14 28 1 1913528560 8439456 3627488
15:09:29 20286 8192000000 10877053056 11334131712 1949856336 19.225 100 43 86 0 1970296224 7909632 12530256
15:09:57 18763 8192000000 10890406384 11331350528 1948622576 19.216 100 41 79 2 1969496480 9849600 11024304
15:10:27 15173 8192000000 10874393248 11325497344 1934804224 19.105 99 56 110 2 1960317872 9171136 16342512
15:10:55 79727 8192000000 10852264736 11321769984 1902847472 18.849 98 31 62 0 1926314320 13593472 9873376
15:12:31 8071 8192000000 10859544816 11324055552 1928777472 19.057 99 22 45 1 1944217280 8849168 6590640
15:12:45 7255 8192000000 10861032496 11321745408 1936908480 19.122 100 18 36 3 1951894832 9774704 5211648
15:13:05 55202 8192000000 10869594144 11335634944 1947999696 19.211 100 14 28 0 1964432624 12307104 4125824
15:14:13 89934 8192000000 10873093568 11347181568 1928003152 19.051 99 14 28 1 1945040000 12970688 4066160
15:16:51 43839 8192000000 10860261472 11334270976 1919324800 18.981 99 10 20 0 1944612448 21733168 3554480
15:17:46 67581 8192000000 10887900944 11339026432 1924595744 19.024 99 12 24 1 1944401808 16075504 3730560
15:18:59 25768 8192000000 10863723024 11323547648 1922945040 19.010 98 35 70 1 1940731344 7992224 9794080
15:19:39 57898 8192000000 10874627200 11349151744 1954459648 19.262 100 23 46 1 1974262560 13029792 6773120
15:20:47 49306 8192000000 10858848592 11316015104 1922360224 19.006 98 33 66 0 1939178064 7644176 9173664
15:21:46 40927 8192000000 10889564464 11357073408 1964080048 19.338 100 31 62 1 1981511888 9165776 8266064
15:22:35 81516 8192000000 10879070880 11337818112 1872750912 18.607 95 25 49 1 1890061264 10173792 7136560
15:24:05 22170 8192000000 10897985120 11352338432 1964529392 19.342 100 24 48 2 1980260192 9219616 6511184
15:24:34 31038 8192000000 10913936064 11360837632 1969056000 19.378 100 27 54 1 1985888080 9218448 7613632
15:25:13 20765 8192000000 10905817520 11355127808 1934120064 19.100 98 35 70 1 1953151824 9576128 9455632
15:25:44 17921 8192000000 10918418528 11354910720 1949756576 19.225 99 48 95 2 1976345088 12552480 14036032
15:26:09 29369 8192000000 10894701056 11347365888 1926902304 19.042 98 31 62 1 1946142000 10716496 8523200
15:26:50 33782 8192000000 10909102080 11354316800 1967404496 19.365 100 42 84 0 1990303632 11493520 11405616
15:27:30 41548 8192000000 10905079456 11348160512 1927935072 19.050 98 40 80 0 1949837616 11203680 10698864
15:28:19 42855 8192000000 10880216384 11346399232 1940887376 19.154 99 27 54 1 1962616960 14260912 7468672
15:29:10 77941 8192000000 10878663968 11358457856 1898029648 18.810 97 18 36 3 1917780736 14504272 5246816
15:31:23 92571 8192000000 10866881232 11318988800 1935126688 19.108 100 9 18 0 1949377440 12093888 2156864
15:33:02 60398 8192000000 10869617024 11331682304 1897112576 18.803 97 23 47 1 1910374752 6583904 6678272
15:34:27 3098 8192000000 10898899680 11346907136 1957943856 19.290 100 52 101 1 1983341616 10704000 14693760
15:34:43 30697 8192000000 10883711664 11347623936 1954546816 19.263 100 29 58 2 1976042560 12661840 8833904
15:35:33 40407 8192000000 10860224768 11337306112 1930002608 19.067 99 15 30 0 1946934112 11643712 5287792
15:36:34 38998 8192000000 10846523920 11318222848 1907649360 18.888 98 7 14 1 1919261328 9734960 1877008
15:37:34 46600 8192000000 10865193504 11328950272 1904144592 18.860 98 20 39 0 1923441152 13431632 5864928
15:38:46 43661 8192000000 10868628112 11345522688 1929235376 19.061 99 13 27 2 1949617952 16058384 4324192
15:40:11 58545 8192000000 10835384912 11317399552 1872560192 18.605 97 19 39 1 1899543376 20929648 6053536
15:41:20 73276 8192000000 10854974128 11325181952 1879395568 18.660 97 16 32 1 1895908192 11408784 5103840
15:43:21 21820 8192000000 10890244976 11340910592 1955108384 19.267 100 55 110 0 1982439296 10441104 16889808
15:43:51 59707 8192000000 10861837520 11338043392 1914196416 18.940 98 21 43 0 1931512144 11488800 5826928
15:45:33 89856 8192000000 10882561152 11362988032 1912074608 18.923 98 16 32 0 1934784688 17877296 4832784
15:48:10 42621 8192000000 10897753920 11348762624 1932340048 19.086 99 32 64 0 1952291680 11375120 8576512
15:49:02 24862 8192000000 10888185088 11339149312 1919242144 18.981 98 28 56 1 1939056368 12025584 7788640
15:49:42 61640 8192000000 10883577968 11361464320 1910979728 18.915 98 18 36 0 1934918624 18896416 5042480
15:50:51 90828 8192000000 10867146224 11337396224 1867010192 18.560 96 5 10 1 1883470368 14962752 1497424
15:52:37 29267 8192000000 10887310528 11340521472 1951764272 19.241 100 43 86 0 1976386992 12423888 12198832
15:53:27 95265 8192000000 10848623776 11311783936 1889156928 18.739 97 17 34 1 1899723056 5592720 4973408
15:55:12 26485 8192000000 10859678304 11325005824 1934751696 19.105 100 26 50 1 1949261968 7631744 6878528
15:55:51 50631 8192000000 10864756896 11329757184 1930028848 19.067 99 25 48 2 1947885280 10378720 7477712
15:57:07 39852 8192000000 10864793200 11344564224 1951281536 19.237 100 14 27 0 1968574480 13121072 4171872
15:58:23 79909 8192000000 10863655152 11330871296 1900967104 18.834 97 11 22 0 1913638976 9394288 3277584
15:59:50 72244 8192000000 10871546832 11348729856 1949666592 19.224 100 16 32 0 1963826000 8995808 5163600
16:01:14 59661 8192000000 10872733616 11337256960 1901869328 18.841 97 18 35 0 1913029968 6759056 4401584
16:02:20 58925 8192000000 10834412832 11289358336 1853262064 18.449 95 29 56 2 1869375472 8329792 7783616
16:03:28 42995 8192000000 10854005616 11317030912 1864547760 18.540 96 19 37 1 1878373104 8662496 5162848
16:04:41 27580 8192000000 10867587248 11320692736 1913685824 18.936 99 29 58 1 1933132304 10017584 9428896
16:05:17 48314 8192000000 10879068768 11338776576 1924095440 19.020 99 18 36 2 1942879312 13822944 4960928
16:06:16 62804 8192000000 10896084960 11375087616 1938275648 19.133 99 9 18 1 1960022000 19434192 2312160
16:07:25 68325 8192000000 10896277456 11366834176 1929002032 19.059 98 20 40 1 1953886720 18948432 5936256
16:08:48 113658 8192000000 10895314096 11368689664 1925097472 19.028 98 10 20 0 1947312096 19323968 2890656
16:10:50 82408 8192000000 10902297872 11363852288 1929674832 19.064 98 19 38 0 1948746192 13746992 5324368
16:12:37 40713 8192000000 10903622048 11347939328 1922614496 19.008 98 40 78 2 1944628848 11325008 10689344
16:13:27 20477 8192000000 10904685392 11343167488 1935517520 19.111 99 47 94 1 1963419904 14601728 13300656
16:13:55 16632 8192000000 10910036224 11350417408 1952532160 19.247 100 46 92 1 1981776640 16352864 12891616
16:14:22 33835 8192000000 10902203904 11355942912 1946622480 19.200 99 43 86 1 1974355792 15950208 11783104
16:15:13 112209 8192000000 10903977456 11356803072 1950106896 19.227 99 39 78 1 1972882080 12113232 10661952
16:17:13 16131 8192000000 10916142768 11359551488 1969824640 19.384 100 54 108 1 1994767728 8867728 16075360
16:17:42 52829 8192000000 10885724784 11363262464 1975450400 19.429 100 27 54 0 1991947440 9571136 6925904
16:19:03 65825 8192000000 10877509088 11351461888 1940947824 19.154 98 11 22 0 1951459440 7716688 2794928
16:20:17 76903 8192000000 10892267168 11367952384 1937522448 19.127 98 16 32 0 1954280080 11827744 4929888
16:21:44 38131 8192000000 10890773568 11367944192 1964511312 19.342 100 11 22 1 1981702272 14074496 3116464
16:23:21 63115 8192000000 10913965648 11377713152 1959970624 19.306 99 15 30 0 1978188160 13943984 4273552
16:24:34 101778 8192000000 10890186192 11371520000 1917235984 18.965 97 15 30 1 1933842464 12381440 4225040
16:26:24 129314 8192000000 10889309344 11361058816 1877474720 18.645 95 20 40 2 1895583312 12412272 5696320
16:28:46 20469 8192000000 10855174448 11324583936 1878066128 18.649 96 15 30 1 1894427744 12042240 4319376
16:29:15 25970 8192000000 10896007872 11345997824 1950404768 19.230 100 37 74 2 1968264320 7515904 10343648
16:29:50 73294 8192000000 10868337200 11333443584 1863702592 18.533 95 20 39 1 1878604544 8761056 6140896
16:31:14 48566 8192000000 9555141824 9871433728 690718848 7.775 36 4 8 0 697476048 6079216 677984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-03-2021 16:33:01 to 27-03-2021 16:33:32.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-03-2021 16:33:33 to 27-03-2021 16:33:35.

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          232444
MON$OLDEST_ACTIVE               233792
MON$OLDEST_SNAPSHOT             233792
MON$NEXT_TRANSACTION            233792
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                       1993280
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Mar 27 16:32:05 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

27.03.21 16:33:36. 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-03-27 16:33:38 No severe PSQL-related problems occured
27.03.21 16:33:39. End of report.