Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.04.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 17471924 kB
MemAvailable 31398924 kB
Buffers 0 kB
Cached 14166988 kB
SwapCached 96 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-04-06 16:31:54
DTS_END                         2021-04-06 16:31:54.9610
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/35448
TRN_ID                          241218
ATT_ID                          664
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: 9017.53 24856 1082104
customer order: creation 176.25 367 21150
customer order: refuse 15.24 357 1829
order to supplier: creation 46.86 1350 5623
order to supplier: removal 3.22 97156 386
invoice (draft): creation 46.89 3706 5627
invoice (draft): removal 49.17 794 5900
invoice accept: apply 42.65 16898 5118
invoice accept: cancel 44.89 892 5387
customer reserve: creation 3866.07 169 463928
customer reserve: removal 4425.88 55 531106
realization accept: apply 84.62 185 10154
realization accept: cancel 86.98 114 10437
payment from customer: creation 58.05 123 6966
payment from customer: removal 5.83 81 700
payment to supplier: creation 49.30 145 5916
payment to supplier: removal 3.57 87 428
service: total inventory turnovers 4.66 1343 559
service: total monetary turnovers 6.47 27 776
service: aggregate perf. data 0.92 17294 110
service: refresh index statistics 0.03 355982 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-04-2021 16:32:41 to 06-04-2021 16:32:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1872
TEST_TIME 2 2754
TEST_TIME 3 2664
TEST_TIME 4 2604
TEST_TIME 5 2763
TEST_TIME 6 3219
TEST_TIME 7 3868
TEST_TIME 8 4467
TEST_TIME 9 4556
TEST_TIME 10 5215
TEST_TIME 11 5454
TEST_TIME 12 6374
TEST_TIME 13 6444
TEST_TIME 14 6420
TEST_TIME 15 6781
TEST_TIME 16 7060
TEST_TIME 17 8129
TEST_TIME 18 8650
TEST_TIME 19 8754
TEST_TIME 20 8695
TEST_TIME 21 8911
TEST_TIME 22 9169
TEST_TIME 23 9444
TEST_TIME 24 9817
TEST_TIME 25 10237
TEST_TIME 26 10297
TEST_TIME 27 10129
TEST_TIME 28 10520
TEST_TIME 29 10679
TEST_TIME 30 10383
TEST_TIME 31 10301
TEST_TIME 32 10135
TEST_TIME 33 9998
TEST_TIME 34 9918
TEST_TIME 35 9945
TEST_TIME 36 9881
TEST_TIME 37 9870
TEST_TIME 38 9748
TEST_TIME 39 9580
TEST_TIME 40 9441
TEST_TIME 41 9279
TEST_TIME 42 9156
TEST_TIME 43 9313
TEST_TIME 44 9205
TEST_TIME 45 9173
TEST_TIME 46 9276
TEST_TIME 47 9344
TEST_TIME 48 9257
TEST_TIME 49 9273
TEST_TIME 50 9295
TEST_TIME 51 9268
TEST_TIME 52 9227
TEST_TIME 53 9333
TEST_TIME 54 9327
TEST_TIME 55 9322
TEST_TIME 56 9369
TEST_TIME 57 9276
TEST_TIME 58 9145
TEST_TIME 59 9124
TEST_TIME 60 9066
TEST_TIME 61 9036
TEST_TIME 62 9020
TEST_TIME 63 8980
TEST_TIME 64 8956
TEST_TIME 65 8898
TEST_TIME 66 8906
TEST_TIME 67 8904
TEST_TIME 68 8953
TEST_TIME 69 8972
TEST_TIME 70 8976
TEST_TIME 71 9014
TEST_TIME 72 8991
TEST_TIME 73 8951
TEST_TIME 74 9000
TEST_TIME 75 9018
TEST_TIME 76 9024
TEST_TIME 77 9023
TEST_TIME 78 9038
TEST_TIME 79 9060
TEST_TIME 80 8968
TEST_TIME 81 8966
TEST_TIME 82 8896
TEST_TIME 83 8917
TEST_TIME 84 8856
TEST_TIME 85 8801
TEST_TIME 86 8799
TEST_TIME 87 8783
TEST_TIME 88 8821
TEST_TIME 89 8816
TEST_TIME 90 8841
TEST_TIME 91 8858
TEST_TIME 92 8875
TEST_TIME 93 8971
TEST_TIME 94 8977
TEST_TIME 95 8981
TEST_TIME 96 9064
TEST_TIME 97 9056
TEST_TIME 98 9084
TEST_TIME 99 9104
TEST_TIME 100 9089
TEST_TIME 101 9054
TEST_TIME 102 9015
TEST_TIME 103 9036
TEST_TIME 104 9011
TEST_TIME 105 9007
TEST_TIME 106 8961
TEST_TIME 107 8924
TEST_TIME 108 8911
TEST_TIME 109 8858
TEST_TIME 110 8876
TEST_TIME 111 8879
TEST_TIME 112 8869
TEST_TIME 113 8874
TEST_TIME 114 8867
TEST_TIME 115 8922
TEST_TIME 116 8903
TEST_TIME 117 8872
TEST_TIME 118 8991
TEST_TIME 119 8992
TEST_TIME 120 9018

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-04-2021 16:32:45 to 06-04-2021 16:32:48.

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 1511788 1511788 0 0.00 0 26289 7 0 0
doc_list_biud 1511786 1511786 0 0.00 0 34386 25 0 0
sp_add_invoice_to_stock 5235 5118 117 2.23 15 150194 16898 0 117
sp_cancel_adding_invoice 5387 5387 0 0.00 3 72384 892 0 0
sp_cancel_client_order 1829 1829 0 0.00 4 16155 357 0 0
sp_cancel_customer_reserve 531106 531106 0 0.00 1 34387 55 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 2 9607 81 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 8781 87 0 0
sp_cancel_supplier_invoice 5913 5900 13 0.21 1 18009 795 0 13
sp_cancel_supplier_order 386 386 0 0.00 5 880217 97157 0 0
sp_cancel_write_off 10437 10437 0 0.00 1 24412 114 0 0
sp_client_order 21150 21150 0 0.00 4 32974 368 0 0
sp_customer_reserve 463928 463928 0 0.00 0 45322 169 0 0
sp_fill_shopping_cart 32380 32380 0 0.00 1 27391 44 0 0
sp_fill_shopping_cart_clo_res 463925 463925 0 0.00 0 20706 16 0 0
sp_get_clo_for_invoice 5115 5115 0 0.00 0 26374 352 0 0
sp_kill_cost_storno 16952 16952 0 0.00 0 24857 59 0 0
sp_kill_qstorno_ret_qs2qd 1078935 1078935 0 0.00 0 34383 30 0 0
sp_kill_qty_storno 570314 570314 0 0.00 0 34386 66 0 0
sp_lock_selected_doc 21072 21072 0 0.00 0 9569 5 0 0
sp_make_cost_storno 28151 28151 0 0.00 0 19876 64 0 0
sp_multiply_rows_for_pdistr 28151 28151 0 0.00 0 10873 30 0 0
sp_multiply_rows_for_qdistr 21150 21150 0 0.00 0 32922 175 0 0
sp_pay_from_customer 6966 6966 0 0.00 4 16682 124 0 0
sp_pay_to_supplier 5916 5916 0 0.00 5 21649 146 0 0
sp_payment_common 12882 12882 0 0.00 1 12381 30 0 0
sp_qd_handle_on_cancel_clo 1829 1829 0 0.00 0 16150 335 0 0
sp_qd_handle_on_invoice_upd_sts 10502 10502 0 0.00 0 23921 345 0 0
sp_qd_handle_on_reserve_upd_sts 10154 10154 0 0.00 0 16895 54 0 0
sp_reserve_write_off 10154 10154 0 0.00 6 19917 186 0 0
sp_supplier_invoice 5627 5627 0 0.00 7 98787 3706 0 0
sp_supplier_order 5623 5623 0 0.00 4 24609 1350 0 0
srv_aggregate_perf_data 110 110 0 0.00 2935 157415 17295 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1277 125987 32050 0 0
srv_find_qd_qs_mism 1034055 1034055 0 0.00 0 26278 5 0 0
srv_make_invnt_saldo 559 559 0 0.00 25 157179 1343 0 0
srv_make_money_saldo 776 776 0 0.00 1 1462 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 94205 530746 355983 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5118 5118 0 0.00 0 10321 167 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 8604 127 0 0
t$perf-norm:sp_cancel_client_order 1829 1829 0 0.00 0 3825 18 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 1891 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 6695 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 4104 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 356 356 0 0.00 0 2935 26 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 29694 1628 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 2644 11 0 0
t$perf-norm:sp_client_order 21150 21150 0 0.00 0 10902 17 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 5528 16 0 0
t$perf-norm:sp_pay_from_customer 6966 6966 0 0.00 0 5316 9 0 0
t$perf-norm:sp_pay_to_supplier 5916 5916 0 0.00 0 7544 13 0 0
t$perf-norm:sp_reserve_write_off 10154 10154 0 0.00 0 7890 12 0 0
t$perf-norm:sp_supplier_invoice 5627 5627 0 0.00 0 15287 33 0 0
t$perf-norm:sp_supplier_order 5623 5623 0 0.00 0 10211 18 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 294 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 161 3 0 0
t$perf-norm:srv_make_invnt_saldo 559 559 0 0.00 0 6095 40 0 0
t$perf-norm:srv_make_money_saldo 776 776 0 0.00 0 1733 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10464 10230 234 2.23 0 8792 18 0 234
v_all_customers 38226 38226 0 0.00 0 214 1 0 0
v_all_suppliers 30700 30700 0 0.00 0 28 1 0 0
v_all_wares 42300 42300 0 0.00 0 155 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 3203 12 0 0
v_cancel_client_order 3658 3658 0 0.00 0 2220 5 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 3200 8 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 1774 5 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 1026 6 0 0
v_cancel_supplier_invoice 738 712 26 3.52 0 1296 14 0 26
v_cancel_supplier_order 772 772 0 0.00 0 269 3 0 0
v_cancel_write_off 2010 2010 0 0.00 0 1755 14 0 0
v_max_id_clo_ord 5621 5621 0 0.00 0 620 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 3651 16 0 0
v_max_id_ord_sup 5609 5609 0 0.00 0 2724 4 0 0
v_max_non_paid_invoice 1796 1796 0 0.00 0 957 4 0 0
v_max_non_paid_realizn 3796 3796 0 0.00 0 984 3 0 0
v_min_id_clo_ord 5621 5621 0 0.00 0 4468 7 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 7759 25 0 0
v_min_id_ord_sup 5609 5609 0 0.00 0 8025 7 0 0
v_min_non_paid_invoice 5916 5916 0 0.00 0 10699 17 0 0
v_min_non_paid_realizn 6966 6966 0 0.00 0 12373 20 0 0
v_our_firm 10414 10414 0 0.00 0 15 1 0 0
v_reserve_write_off 20308 20308 0 0.00 0 5853 5 0 0
x_lock_depdocs_on_canc_invoice 10931 10931 0 0.00 0 28164 120 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 11197 359 0 0
x_make_qstorno_1000_1200 5623 5623 0 0.00 1 24596 1263 0 0
x_make_qstorno_1200_2000 5627 5627 0 0.00 3 84183 3546 0 0
x_make_qstorno_2100_3300 463928 463928 0 0.00 0 45295 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2021 16:32:49 to 06-04-2021 16:32:53.

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:58 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:04 23561 8192000000 10274153488 10578546688 955602928 10.446 75 56 113 0 976692880 2578064 18511888
14:02:35 27032 8192000000 10342362528 10662100992 1388018368 14.488 100 81 162 0 1419388640 5016320 26353952
14:03:09 28478 8192000000 10382521696 10708791296 1433398320 14.891 100 91 182 0 1468775184 6318192 29058672
14:03:48 28937 8192000000 10426515216 10756288512 1471906368 15.230 100 88 176 1 1508233584 7716352 28610864
14:04:36 26442 8192000000 10444183744 10778431488 1499926736 15.476 100 92 183 1 1537864112 8784080 29153296
14:05:24 13793 8192000000 10466625328 10806571008 1526030096 15.703 100 84 168 0 1562094448 9170944 26893408
14:06:02 6289 8192000000 10485530864 10829078528 1547253696 15.886 100 90 180 1 1585234768 9776624 28204448
14:06:20 13298 8192000000 10493082592 10843144192 1556464288 15.966 100 78 156 0 1590134752 9468624 24201840
14:06:44 19783 8192000000 10529716528 10885251072 1586145152 16.221 100 70 140 0 1617138704 9856512 21137040
14:07:12 14069 8192000000 10550388576 10908606464 1611159120 16.435 100 75 150 0 1645066464 10534736 23372608
14:07:36 14997 8192000000 10571462368 10933661696 1630579040 16.600 100 88 176 1 1668313120 11431520 26302560
14:08:06 11094 8192000000 10619832416 10981449728 1671295392 16.944 100 85 169 1 1708969728 12983872 24690464
14:08:26 13067 8192000000 10632810976 10999205888 1691234944 17.112 100 86 172 3 1729725152 13743712 24746496
14:08:46 10245 8192000000 10642459648 11015086080 1701026000 17.194 100 86 172 0 1739595520 13820592 24748928
14:09:03 9050 8192000000 10664973520 11033681920 1715185296 17.312 100 90 179 0 1755587920 14318496 26084128
14:09:19 6742 8192000000 10667118096 11041001472 1724297728 17.388 100 83 166 2 1762854544 14395328 24161488
14:09:36 6801 8192000000 10682619520 11055837184 1735206032 17.479 100 87 173 0 1773384480 13538720 24639728
14:09:51 8877 8192000000 10688103664 11065069568 1747580944 17.582 100 84 166 1 1784011072 13031712 23398416
14:10:06 4524 8192000000 10697682944 11074867200 1756202688 17.653 100 83 166 1 1792816752 12929968 23684096
14:10:18 2640 8192000000 10698164320 11080392704 1767820368 17.749 100 74 148 1 1799785328 10734400 21230560
14:10:28 4338 8192000000 10720040944 11102932992 1784893152 17.890 100 82 165 1 1818708096 11024176 22790768
14:10:38 3940 8192000000 10737964128 11116584960 1794488992 17.969 100 83 164 0 1829338640 12343568 22506080
14:10:49 4048 8192000000 10742031424 11123073024 1803407552 18.042 100 87 173 1 1840720576 12821616 24491408
14:11:00 3591 8192000000 10736948048 11123949568 1802603088 18.035 100 79 157 0 1837436704 13205760 21627856
14:11:10 4868 8192000000 10756463840 11139231744 1809430176 18.091 100 89 176 0 1848416608 14359344 24627088
14:11:22 7797 8192000000 10748263600 11136761856 1811495600 18.108 100 79 159 1 1848128480 14603840 22029040
14:11:36 6821 8192000000 10757365504 11141910528 1817514688 18.157 100 86 172 0 1857408736 16755888 23138160
14:11:49 2184 8192000000 10771509232 11160190976 1829956880 18.259 100 87 174 2 1869240528 15696368 23587280
14:11:59 2354 8192000000 10781288864 11167240192 1835280016 18.302 100 89 177 2 1873287312 13020640 24986656
14:12:07 1462 8192000000 10780239296 11167342592 1839976992 18.341 100 92 185 3 1878894192 11543200 27374000
14:12:15 1716 8192000000 10779115520 11170164736 1845151808 18.383 100 90 178 0 1883124416 11451024 26521584
14:12:24 1778 8192000000 10796075408 11180597248 1846340512 18.392 100 88 175 1 1883419632 11603344 25475776
14:12:32 2336 8192000000 10791143104 11180294144 1852587536 18.443 100 92 184 1 1891378272 12609168 26181568
14:12:41 1633 8192000000 10797439936 11183788032 1858783264 18.493 100 88 176 0 1896739088 13201792 24754032
14:12:49 1887 8192000000 10793454480 11181899776 1857535776 18.483 100 95 191 1 1898628384 14606896 26485712
14:12:57 1298 8192000000 10805409968 11193368576 1858979664 18.495 100 88 177 4 1897120560 13079488 25061408
14:13:04 1373 8192000000 10801924272 11192832000 1858183040 18.489 100 89 178 1 1897301488 12912368 26206080
14:13:12 1316 8192000000 10808903104 11196837888 1861062208 18.512 100 90 179 1 1898495456 12028800 25404448
14:13:20 43741 8192000000 10783538192 11197636608 1859663696 18.501 100 58 116 2 1887115088 9521184 17930208
14:14:10 14117 8192000000 10782544864 11203280896 1864487296 18.540 100 46 92 1 1886852176 9697984 12666896
14:14:34 9376 8192000000 10767164528 11197665280 1862024832 18.520 100 22 42 1 1873142448 5257216 5860400
14:14:50 6549 8192000000 10789406096 11206918144 1868518464 18.572 100 36 73 0 1884679296 6497008 9663824
14:15:04 9524 8192000000 10772615136 11204124672 1867350224 18.563 100 21 42 1 1879628608 6493744 5784640
14:15:20 9971 8192000000 10784634912 11214344192 1873649584 18.614 100 25 50 2 1886132432 6125408 6357440
14:15:36 6801 8192000000 10782846544 11211857920 1877747232 18.647 100 27 54 2 1891233104 5293296 8192576
14:15:54 11987 8192000000 10781799744 11213889536 1876392128 18.636 100 11 22 1 1884959136 5492848 3074160
14:16:14 6981 8192000000 10791508144 11219529728 1878917504 18.656 100 22 45 0 1890854512 5905312 6031696
14:16:36 8282 8192000000 10782704848 11223015424 1879928016 18.665 100 19 38 1 1895065232 9571152 5566064
14:16:50 20016 8192000000 10789659792 11225419776 1883470704 18.693 100 12 24 1 1892605568 5980832 3154032
14:17:20 7768 8192000000 10798404208 11231940608 1890700512 18.751 100 31 63 2 1906804448 7085824 9018112
14:17:34 10437 8192000000 10799450160 11233583104 1888989632 18.738 100 25 48 4 1904694176 9196208 6508336
14:17:59 10295 8192000000 10788924592 11231510528 1890521200 18.750 100 17 33 3 1901134528 6444288 4169040
14:18:15 69221 8192000000 10816829728 11237060608 1892982256 18.770 100 30 56 2 1905953184 4997264 7973664
14:19:31 13770 8192000000 10798575776 11235348480 1889919104 18.745 100 11 22 0 1898862848 5651536 3292208
14:19:54 9978 8192000000 10805627360 11240542208 1894058448 18.778 100 34 68 1 1910245184 6838384 9348352
14:20:10 8458 8192000000 10812184352 11244236800 1894248848 18.780 100 27 54 1 1908386400 6888176 7249376
14:20:26 6003 8192000000 10804012288 11241848832 1896191648 18.796 100 29 58 1 1910755904 5967680 8596576
14:20:43 5694 8192000000 10802936384 11238576128 1888489552 18.734 100 25 49 1 1901836880 6101104 7246224
14:20:57 3606 8192000000 10803110384 11240747008 1891945328 18.761 100 17 34 2 1901707136 5371920 4389888
14:21:08 5332 8192000000 10814897472 11244335104 1891657648 18.759 100 27 55 1 1909519456 10151744 7710064
14:21:20 5885 8192000000 10803468464 11242926080 1889754256 18.744 100 27 54 0 1908821600 11789584 7277760
14:21:35 11218 8192000000 10810599280 11236261888 1869504992 18.580 99 22 44 0 1881877232 5809088 6563152
14:21:53 15327 8192000000 10763056624 11198885888 1829295600 18.254 97 24 48 3 1841810176 5646544 6868032
14:22:14 9805 8192000000 10786945328 11216752640 1856988896 18.479 99 18 35 2 1867018496 5091248 4938352
14:22:30 7617 8192000000 10780698192 11209428992 1839569184 18.337 98 9 18 1 1847814608 5605664 2639760
14:22:45 10467 8192000000 10749377696 11177840640 1806198704 18.065 97 23 46 2 1818772144 5986304 6587136
14:23:02 23866 8192000000 10738056128 11165884416 1795653520 17.978 97 27 55 1 1809042048 5075472 8313056
14:24:00 25201 8192000000 10716936352 11147583488 1697081792 17.161 92 10 20 0 1704914160 4559088 3273280
14:24:38 3401 8192000000 10718814656 11125956608 1766308192 17.737 98 54 103 0 1788367840 7143184 14916464
14:24:49 4722 8192000000 10715468416 11122597888 1765444304 17.729 98 42 84 3 1786154512 9163616 11546592
14:25:00 7752 8192000000 10665423760 11083059200 1692919440 17.126 95 21 42 4 1705493824 6167760 6406624
14:25:17 5234 8192000000 10699959424 11103129600 1716342352 17.322 96 40 80 0 1738451760 10086368 12023040
14:25:30 5878 8192000000 10684032016 11098562560 1733707632 17.466 98 22 45 2 1745333104 5225360 6400112
14:25:42 8773 8192000000 10700522208 11111108608 1757623216 17.665 99 16 32 0 1767224928 4752400 4849312
14:25:57 6014 8192000000 10678862320 11086696448 1723890224 17.385 97 36 72 0 1740815024 5994480 10930320
14:26:10 8071 8192000000 10708741120 11112685568 1750391504 17.605 98 23 46 2 1763845168 5879456 7574208
14:26:25 6565 8192000000 10713957584 11135934464 1788103968 17.916 99 26 52 1 1801953200 6166512 7682720
14:26:41 8490 8192000000 10741474112 11155066880 1817512336 18.157 100 35 68 1 1833888320 5573712 10802272
14:26:57 14441 8192000000 10736517792 11146489856 1766650272 17.739 97 31 58 3 1780834480 5160112 9024096
14:27:18 12511 8192000000 10746302352 11165589504 1821555056 18.190 100 19 36 1 1832598176 5663584 5379536
14:27:41 6600 8192000000 10746368336 11175288832 1837059952 18.317 100 31 62 3 1852894512 6891120 8943440
14:27:54 74052 8192000000 10751700720 11179683840 1808134368 18.081 98 34 68 1 1823551824 5293568 10123888
14:29:20 9772 8192000000 10761114336 11184513024 1842342352 18.360 100 26 51 5 1855779888 6280624 7156912
14:29:36 8905 8192000000 10764452992 11192573952 1851574720 18.435 100 28 56 3 1866303776 6740192 7988864
14:29:53 5138 8192000000 10762443904 11192397824 1852418016 18.442 100 28 56 0 1867465024 6884464 8162544
14:30:04 7501 8192000000 10766315568 11198636032 1855764288 18.469 100 27 52 5 1870050000 6236560 8049152
14:30:21 10846 8192000000 10763967632 11201265664 1859204640 18.497 100 22 44 0 1871895184 6286080 6404464
14:30:46 9186 8192000000 10776041024 11207143424 1864030688 18.536 100 17 34 0 1874706416 5460112 5215616
14:31:02 10870 8192000000 10793851600 11222728704 1874519152 18.621 100 21 42 0 1886217376 5770624 5927600
14:31:22 8586 8192000000 10808462896 11233566720 1890208480 18.747 100 22 44 0 1900655584 4511680 5935424
14:31:41 10649 8192000000 10819256800 11245469696 1896921536 18.802 100 24 48 1 1909483184 4952960 7608688
14:32:00 43355 8192000000 10844706736 11262099456 1907092384 18.883 100 46 89 2 1926401440 5790528 13518528
14:32:52 24873 8192000000 10855199168 11278557184 1921303152 18.997 100 49 98 3 1942949504 7411392 14234960
14:33:32 12954 8192000000 10861186160 11286900736 1930075952 19.067 100 44 88 0 1956359232 13723936 12559344
14:33:53 30477 8192000000 10877961536 11298742272 1934444288 19.102 100 38 76 1 1962531248 16850752 11236208
14:34:55 75870 8192000000 10890838928 11324358656 1948396816 19.214 100 36 72 0 1979986576 20215296 11374464
14:36:22 6757 8192000000 10899961376 11330961408 1958125616 19.291 100 41 82 0 1990671600 20249312 12296672
14:36:40 33162 8192000000 10902784832 11337973760 1962905888 19.329 100 48 96 0 1999135328 22299696 13929744
14:37:24 13090 8192000000 10913155728 11347550208 1970066304 19.386 100 47 93 1 2006536896 22650096 13820496
14:37:49 19974 8192000000 10910129888 11348586496 1976376544 19.436 100 44 88 1 2011685264 21905504 13403216
14:38:15 11494 8192000000 10911071104 11344228352 1956361312 19.277 99 44 88 1 1991991328 22117328 13512688
14:38:35 1527 8192000000 10949591008 11361234944 1985032448 19.505 100 88 177 0 2034710320 23744944 25932928
14:38:43 2262 8192000000 10957425632 11368669184 1984883696 19.503 100 85 168 2 2036667520 26707104 25076720
14:38:53 1430 8192000000 10961065872 11374104576 1990258112 19.546 100 90 177 3 2045426464 28784176 26384176
14:39:01 2965 8192000000 10949959280 11370483712 1991323280 19.554 100 72 144 0 2038871792 26578352 20970160
14:39:12 2325 8192000000 10945249488 11370209280 1991616928 19.557 100 71 143 1 2039239600 26670624 20952048
14:39:24 5153 8192000000 10950783216 11374010368 1997382544 19.602 100 78 156 3 2046530400 26168928 22978928
14:39:39 3620 8192000000 10948457040 11375812608 1995845216 19.590 100 67 133 0 2043110768 27232160 20033392
14:39:59 11628 8192000000 10948623904 11383496704 1996122864 19.592 100 56 112 1 2042939120 29546176 17270080
14:40:23 20734 8192000000 10953536912 11387133952 1998368416 19.610 100 67 134 0 2051046672 31567968 21110288
14:40:55 7056 8192000000 10955097168 11390693376 1999441488 19.618 100 52 103 2 2047709584 31611248 16656848
14:41:14 2487 8192000000 10973129088 11395907584 1991366912 19.555 99 79 160 0 2046941472 31741296 23833264
14:41:28 4524 8192000000 10954965808 11381538816 1992094368 19.560 100 71 140 2 2043598032 29569408 21934256
14:41:39 2193 8192000000 10975093536 11394908160 2004172048 19.656 100 82 164 2 2059762080 30962992 24627040
14:41:50 4716 8192000000 10970173648 11397771264 2002688944 19.644 100 62 124 1 2053742992 31958448 19095600
14:42:05 7087 8192000000 10979797168 11404668928 2001452640 19.634 100 62 123 0 2056288128 35742800 19092688
14:42:19 4844 8192000000 10984532880 11408683008 2008166128 19.687 100 68 136 1 2065239344 36493360 20579856
14:42:31 1265 8192000000 10999907744 11414257664 2020672624 19.785 100 89 177 4 2083772656 37131888 25968144
14:42:40 4289 8192000000 10990687264 11418161152 2020709216 19.786 100 77 154 1 2082518080 38637216 23171648
14:42:52 3206 8192000000 10984016400 11413454848 2002085264 19.639 99 81 162 1 2065136608 39022768 24028576
14:43:03 11490 8192000000 10971716912 11410595840 2004842912 19.661 100 62 124 4 2062256016 38675872 18737232
14:43:23 7221 8192000000 10977257424 11405488128 1993153136 19.569 99 62 123 0 2043144352 31299968 18691248
14:43:46 7312 8192000000 10967086352 11403042816 2003204352 19.648 100 61 122 1 2053628320 32122560 18301408
14:44:01 4397 8192000000 10968851888 11404926976 2009077328 19.694 100 61 120 3 2058294720 31058416 18158976
14:44:14 3579 8192000000 10976858864 11414028288 2016711440 19.754 100 61 119 3 2065395072 30966224 17717408
14:44:26 2056 8192000000 10995672560 11422035968 2018438048 19.768 100 79 158 1 2079901712 37288480 24175184
14:44:36 2436 8192000000 10997229744 11418984448 2019861568 19.779 100 73 141 0 2074512256 33610672 21040016
14:44:47 1986 8192000000 10999573296 11419045888 2017335440 19.759 100 79 158 1 2075839440 35198272 23305728
14:44:57 4367 8192000000 10981995808 11419160576 2017004928 19.757 100 58 116 1 2069662096 35192128 17465040
14:45:09 6145 8192000000 10952971120 11385339904 1987192032 19.522 99 59 118 0 2039987584 34195568 18599984
14:45:29 9957 8192000000 10964927600 11395985408 1984143600 19.497 99 53 106 0 2036479200 36113616 16221984
14:45:50 5811 8192000000 10960742640 11391729664 1987149056 19.521 99 65 129 0 2045409088 37927200 20332832
14:46:02 1688 8192000000 10992659392 11411595264 2010735600 19.707 100 70 139 3 2071354384 38757088 21861696
14:46:14 2703 8192000000 10989739200 11418292224 2010906688 19.709 100 72 144 3 2073997056 40371952 22718416
14:46:25 2369 8192000000 11006003120 11425583104 2021819584 19.794 100 87 174 0 2090318832 41832192 26667056
14:46:34 2235 8192000000 11012186160 11426009088 2014236624 19.735 100 83 169 0 2083064992 43348464 25479904
14:46:43 2473 8192000000 11001315312 11428368384 2010964656 19.709 100 74 148 1 2081993072 48355120 22673296
14:46:56 3610 8192000000 10991711664 11413934080 1998023824 19.607 100 74 148 3 2068102304 45536048 24542432
14:47:07 6033 8192000000 10967484448 11392090112 1956464064 19.278 98 61 121 2 2021398224 45681648 19252512
14:47:22 4006 8192000000 10961139552 11400736768 1990619504 19.549 100 56 112 1 2052944000 44379984 17944512
14:47:35 3160 8192000000 10939039168 11359948800 1933436064 19.094 97 66 132 0 1997953232 44120240 20396928
14:47:48 5376 8192000000 10950219952 11376709632 1956500752 19.278 99 62 122 3 2022932272 46486288 19945232
14:48:13 3584 8192000000 10967272432 11393466368 1984831120 19.503 100 67 132 1 2048082464 42669824 20581520
14:48:25 2911 8192000000 10970924288 11393081344 1989501088 19.540 100 84 166 0 2055634016 39350816 26782112
14:48:36 6028 8192000000 10955792736 11387363328 1989468208 19.540 100 76 150 0 2045508992 32356832 23683952
14:48:53 3010 8192000000 10939225648 11363729408 1949774144 19.225 98 75 151 1 2005606368 32305648 23526576
14:49:04 1632 8192000000 10942359712 11366322176 1964167280 19.339 99 83 165 1 2019062336 29607168 25287888
14:49:14 2371 8192000000 10943048784 11365298176 1953383744 19.253 99 68 133 0 2005130272 30771376 20975152
14:49:24 1870 8192000000 10958490752 11375960064 1980271296 19.467 100 82 161 1 2037334160 31412256 25650608
14:49:33 2855 8192000000 10963849984 11379716096 1982440480 19.484 100 89 178 3 2042949520 33456816 27052224
14:49:43 1723 8192000000 10977360784 11390623744 1989984528 19.544 100 90 181 1 2053892816 35771504 28136784
14:49:52 15145 8192000000 10923659760 11384725504 1980330000 19.467 100 43 86 0 2027851264 33846800 13674464
14:50:15 14428 8192000000 10915678912 11369697280 1958711088 19.296 99 22 44 0 1991241616 25182112 7348416
14:50:38 11909 8192000000 10887303088 11327680512 1936740160 19.121 98 34 68 0 1973250320 25877008 10633152
14:50:57 3621 8192000000 10923218128 11336687616 1934010032 19.099 98 67 130 2 1981557104 26812688 20734384
14:51:10 3456 8192000000 10946916512 11366338560 1968336816 19.372 100 84 168 2 2025145264 31431376 25377072
14:51:20 1976 8192000000 10947601648 11362353152 1966417904 19.357 100 87 171 2 2023884928 32531824 24935200
14:51:31 3510 8192000000 10941008928 11351908352 1957405680 19.285 100 84 166 0 2017296192 34467680 25422832
14:51:40 2589 8192000000 10942905760 11349057536 1945164928 19.188 99 94 188 1 2009353616 35859696 28328992
14:51:49 2514 8192000000 10946780128 11366973440 1969599168 19.382 100 77 154 1 2029289808 36607584 23083056
14:52:01 6589 8192000000 10928593184 11370070016 1966566128 19.358 100 54 108 0 2019619872 36456672 16597072
14:52:15 10713 8192000000 10912234016 11353280512 1937846896 19.130 99 37 73 2 1984039872 34490624 11702352
14:52:36 9134 8192000000 10891734960 11331989504 1922603984 19.008 99 37 74 2 1970633584 35492832 12536768
14:53:00 7672 8192000000 10909663200 11339583488 1920490944 18.991 99 36 72 0 1975819776 43235824 12093008
14:53:14 18777 8192000000 10900227648 11357224960 1945165520 19.188 100 35 70 2 1997055392 40184736 11705136
14:54:00 12188 8192000000 10924955536 11361734656 1960331168 19.309 100 65 131 0 2019713376 38984720 20397488
14:54:21 25781 8192000000 10911446080 11359035392 1920035536 18.987 98 35 70 0 1975198928 42831888 12331504
14:54:54 12054 8192000000 10920070208 11360251904 1947830208 19.209 100 32 65 1 1998713440 40178896 10704336
14:55:14 4517 8192000000 10921004544 11363229696 1953697616 19.256 100 34 68 1 2003669696 38039536 11932544
14:55:25 9014 8192000000 10927966112 11370668032 1959589856 19.303 100 35 70 0 2010594592 39191120 11813616
14:55:43 13803 8192000000 10913544944 11364343808 1954214928 19.260 100 27 54 1 1999417520 36138176 9064416
14:56:11 27309 8192000000 10902269072 11371094016 1937691040 19.128 99 22 43 0 1980512064 36112272 6708752
14:56:45 34807 8192000000 10876675040 11333742592 1871423248 18.596 96 20 39 2 1909255760 31091184 6741328
14:57:29 37592 8192000000 10881375232 11314532352 1871070240 18.593 97 28 55 1 1909816000 29530192 9215568
14:58:34 36524 8192000000 10889190336 11335401472 1910337520 18.909 99 27 55 1 1954565936 35520832 8707584
14:59:17 16771 8192000000 10864884928 11342356480 1916590704 18.960 100 19 38 1 1961542432 38338432 6613296
14:59:45 22179 8192000000 10851512800 11322601472 1885311136 18.708 98 12 24 0 1907313616 18658048 3344432
15:00:16 47376 8192000000 10849920544 11292397568 1895741520 18.792 99 23 44 0 1911455056 9597856 6115680
15:01:17 47460 8192000000 10859514768 11305332736 1915174800 18.948 99 28 57 0 1934576176 11695760 7705616
15:02:10 14609 8192000000 10852562800 11312066560 1930115312 19.068 100 27 55 1 1951628464 14097296 7415856
15:02:31 7534 8192000000 10854194224 11313831936 1928084896 19.052 100 12 24 2 1943700864 12773312 2842656
15:02:45 26868 8192000000 10861315248 11321335808 1929767920 19.065 100 10 18 0 1944284032 12267024 2249088
15:03:20 54849 8192000000 10866445280 11334078464 1941941120 19.162 100 14 27 0 1962302736 16741120 3620496
15:05:13 76831 8192000000 10868558096 11333214208 1922199632 19.004 98 28 54 2 1939345552 10021008 7124912
15:06:40 90329 8192000000 10854954688 11320033280 1894428272 18.781 97 12 25 0 1909486096 12020864 3036960
15:08:18 69095 8192000000 10875812464 11338801152 1924403568 19.022 99 10 20 1 1941890896 15047824 2439504
15:09:34 67230 8192000000 10867068064 11319586816 1917936448 18.970 98 16 32 2 1931671744 8969056 4766240
15:10:59 91723 8192000000 10908922928 11342295040 1939130912 19.140 99 33 65 2 1960884720 12856912 8896896
15:12:41 69767 8192000000 10878643648 11344097280 1957288576 19.284 100 15 31 0 1975493376 14226000 3978800
15:13:59 45495 8192000000 10891345792 11362611200 1954926528 19.266 100 13 26 0 1982076608 23113072 4037008
15:14:52 33379 8192000000 10892035200 11354529792 1964715888 19.344 100 15 30 1 1982172528 13355344 4101296
15:15:37 44007 8192000000 10916461008 11370680320 1980701408 19.470 100 33 66 0 2007028064 16851008 9475648
15:16:38 121043 8192000000 10905621552 11378053120 1939760528 19.145 98 18 36 1 1962264656 16780720 5723408
15:18:47 82129 8192000000 10921738688 11378089984 1950154672 19.228 98 22 44 0 1971969728 15843552 5971504
15:20:15 74655 8192000000 10920095344 11389558784 1985824512 19.511 100 16 32 0 2000272672 9736592 4711568
15:21:37 110977 8192000000 10947721248 11407011840 2001974304 19.638 100 22 44 1 2018720016 10655936 6089776
15:23:34 111753 8192000000 10928327936 11412611072 1986271664 19.514 99 15 30 1 2010216208 19742784 4201760
15:25:48 96401 8192000000 10913711328 11392036864 1924055344 19.019 96 9 18 1 1937278064 10645360 2577360
15:27:37 95211 8192000000 10917214128 11398512640 1993627200 19.572 100 11 22 1 2016750672 19537760 3585712
15:29:45 54167 8192000000 10918625312 11394441216 1964021456 19.338 98 41 81 3 1982995968 7612240 11362272
15:30:53 58910 8192000000 10928653520 11396296704 1995164944 19.585 100 25 50 0 2014081936 12312912 6604080
15:31:58 4524 8192000000 10917228800 11391950848 1983202496 19.490 99 32 63 1 2000599568 9135408 8261664
15:32:10 14004 8192000000 10902271632 11381006336 1957849664 19.289 98 12 24 0 1969190240 8170016 3170560
15:32:34 21555 8192000000 10916963696 11393753088 2002362592 19.641 100 26 51 2 2018095232 9297904 6434736
15:33:17 51977 8192000000 10904284464 11395665920 1993454944 19.571 100 12 25 0 2007146560 10692816 2998800
15:34:15 44981 8192000000 10892633616 11380248576 1983503648 19.492 100 10 20 0 1994242128 8278528 2459952
15:36:33 65699 8192000000 10835461792 11300270080 1797808896 17.996 91 18 36 0 1810434912 7273824 5352192
15:37:45 74865 8192000000 10874404448 11348262912 1905324128 18.869 98 16 32 2 1921247424 11372432 4550864
15:39:07 33970 8192000000 10910570912 11361046528 1946172080 19.196 99 28 58 0 1964309456 9613488 8523888
15:39:58 61948 8192000000 10863299568 11335360512 1883083488 18.690 96 15 30 0 1899024912 11713600 4227824
15:41:31 38112 8192000000 10867107168 11337785344 1899676080 18.824 97 21 42 5 1915113296 9330736 6106480
15:42:16 125602 8192000000 10870261648 11335401472 1820594528 18.183 93 25 51 2 1839730208 11649280 7486400
15:44:28 44953 8192000000 10884148832 11331325952 1853080752 18.447 95 34 68 0 1875113024 12482656 9549616
15:45:28 61456 8192000000 10878834784 11332071424 1887772192 18.728 97 28 56 1 1906175584 9934064 8469328
15:46:36 64690 8192000000 10889612320 11342082048 1866812144 18.558 96 16 32 0 1879926080 8790304 4323632
15:48:15 22491 8192000000 10853570624 11311091712 1883946384 18.697 97 27 54 1 1899311232 7303216 8061632
15:48:44 26832 8192000000 10845522032 11296313344 1901492800 18.838 99 28 56 1 1919012912 9684656 7835456
15:49:21 34266 8192000000 10858054864 11319107584 1893843616 18.777 98 44 88 2 1918741248 12749280 12148352
15:50:20 125987 8192000000 10850432528 11311472640 1900875552 18.833 98 30 60 2 1919108048 9318912 8913584
15:52:35 70750 8192000000 10883526800 11344232448 1930446880 19.070 99 34 68 1 1955446112 14604192 10395040
15:53:52 21105 8192000000 10866249136 11333689344 1932475952 19.087 99 34 68 1 1956964576 14340528 10148096
15:54:32 56982 8192000000 10853091136 11331084288 1919424912 18.982 99 11 22 1 1934327408 11635104 3267392
15:56:44 11756 8192000000 10853878208 11317841920 1913446080 18.934 99 29 58 3 1928737888 6667904 8623904
15:58:16 46937 8192000000 10870293168 11336183808 1908138912 18.892 98 9 18 0 1922694304 11849888 2705504
15:59:10 31046 8192000000 10864700368 11328462848 1910930832 18.914 98 21 40 1 1926348464 10001120 5416512
15:59:55 31571 8192000000 10866698640 11321442304 1917685152 18.968 99 37 74 0 1938681264 9974608 11021504
16:00:43 74066 8192000000 10908656704 11361599488 1953709824 19.256 100 12 24 1 1970551968 13556016 3286128
16:02:05 56535 8192000000 10926675568 11395108864 1985981104 19.512 100 25 50 2 2006283648 13508656 6793888
16:03:28 85138 8192000000 10927460112 11419791360 1970057904 19.386 99 15 30 1 1995861344 21695728 4107712
16:04:59 69472 8192000000 10909367552 11380027392 1927954864 19.051 97 13 26 1 1947296896 15640048 3701984
16:06:15 72142 8192000000 10920811584 11403476992 1973436304 19.413 99 19 38 1 1999429648 20831296 5162048
16:07:37 89432 8192000000 10902507392 11367399424 1904744816 18.864 96 9 18 1 1919387232 12159504 2482912
16:09:12 116434 8192000000 10939524528 11385950208 1980221584 19.466 100 15 30 1 1996819760 12445888 4152288
16:11:18 68417 8192000000 10950252768 11416510464 2004137360 19.655 100 26 52 0 2023280080 11366464 7776256
16:12:49 113224 8192000000 10917161744 11413630976 1986067104 19.513 99 19 38 0 2007857600 15919920 5870576
16:15:02 15303 8192000000 10920137888 11389480960 1979151296 19.458 99 27 54 1 1996966016 9776752 8037968
16:15:41 34296 8192000000 10913028464 11399630848 1995986912 19.591 100 11 22 0 2012546192 13135328 3423952
16:16:24 57156 8192000000 10905527840 11392864256 1957936096 19.290 98 8 17 0 1974451344 14285872 2229376
16:17:27 24327 8192000000 10905597888 11398127616 1989655600 19.541 100 5 10 0 2000619728 9974912 989216
16:17:57 19336 8192000000 10895799424 11371073536 1971915616 19.401 99 5 10 1 1983126576 9665232 1545728
16:18:32 71549 8192000000 10900892736 11379421184 1935785824 19.113 97 18 36 0 1953128720 12008448 5334448
16:19:57 74456 8192000000 10918526800 11395866624 1967466096 19.365 99 19 38 4 1983935136 10901568 5567472
16:21:57 51503 8192000000 10888320848 11356344320 1916671728 18.960 97 15 29 1 1928251440 7802992 3776720
16:22:55 62467 8192000000 10880412160 11356151808 1909092736 18.899 97 19 38 0 1923148144 8738080 5317328
16:24:04 69128 8192000000 10889195920 11352014848 1887312368 18.724 96 19 37 1 1903442592 10508048 5622176
16:25:32 51582 8192000000 10852211168 11332608000 1857188928 18.480 95 12 24 0 1872625264 12128624 3307712
16:26:31 45924 8192000000 10872151152 11336417280 1870271696 18.586 96 22 44 0 1887838672 11275088 6291888
16:27:23 62070 8192000000 10891151136 11357618176 1939377456 19.142 99 22 44 1 1958295408 12086480 6831472
16:28:43 37705 8192000000 10871987392 11351252992 1914728544 18.945 98 25 50 0 1938576784 16072512 7775728
16:30:13 57526 8192000000 10842031360 11307356160 1856702432 18.477 95 7 14 0 1869422528 10726336 1993760
16:31:54 12467 8192000000 9141834528 9373274112 305064928 3.590 16 2 2 0 306530432 1341232 124272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-04-2021 16:32:55 to 06-04-2021 16:33:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

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

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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Tue Apr  6 16:32:08 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'

06.04.21 16:33:30. 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-04-06 16:33:32 No severe PSQL-related problems occured
06.04.21 16:33:34. End of report.