Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.03.2021 22:28
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 17669268 kB
MemAvailable 31555600 kB
Buffers 0 kB
Cached 13982188 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-11 22:27:24
DTS_END                         2021-03-11 22:27:24.0860
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/59258
TRN_ID                          238337
ATT_ID                          665
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: 9150.58 24412 1098069
customer order: creation 170.31 378 20437
customer order: refuse 14.33 338 1719
order to supplier: creation 44.76 1327 5371
order to supplier: removal 3.34 96000 401
invoice (draft): creation 45.03 3329 5404
invoice (draft): removal 51.20 801 6144
invoice accept: apply 42.12 16637 5054
invoice accept: cancel 46.39 766 5567
customer reserve: creation 3864.93 164 463792
customer reserve: removal 4580.84 54 549701
realization accept: apply 82.74 176 9929
realization accept: cancel 76.08 114 9130
payment from customer: creation 59.46 118 7135
payment from customer: removal 5.71 97 685
payment to supplier: creation 47.63 126 5716
payment to supplier: removal 3.53 77 423
service: total inventory turnovers 4.90 1039 588
service: total monetary turnovers 6.41 18 769
service: aggregate perf. data 0.83 21596 100
service: refresh index statistics 0.03 345084 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2021 22:28:31 to 11-03-2021 22:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5045
TEST_TIME 2 5492
TEST_TIME 3 4808
TEST_TIME 4 5218
TEST_TIME 5 5479
TEST_TIME 6 4995
TEST_TIME 7 4992
TEST_TIME 8 4901
TEST_TIME 9 5363
TEST_TIME 10 5387
TEST_TIME 11 5401
TEST_TIME 12 5323
TEST_TIME 13 5559
TEST_TIME 14 5899
TEST_TIME 15 6483
TEST_TIME 16 6775
TEST_TIME 17 7269
TEST_TIME 18 7952
TEST_TIME 19 8006
TEST_TIME 20 8857
TEST_TIME 21 8781
TEST_TIME 22 8916
TEST_TIME 23 8704
TEST_TIME 24 8969
TEST_TIME 25 9525
TEST_TIME 26 9649
TEST_TIME 27 10129
TEST_TIME 28 10817
TEST_TIME 29 10582
TEST_TIME 30 10455
TEST_TIME 31 10272
TEST_TIME 32 10207
TEST_TIME 33 10265
TEST_TIME 34 10043
TEST_TIME 35 9912
TEST_TIME 36 9942
TEST_TIME 37 10005
TEST_TIME 38 9951
TEST_TIME 39 9807
TEST_TIME 40 9675
TEST_TIME 41 9634
TEST_TIME 42 9536
TEST_TIME 43 9493
TEST_TIME 44 9362
TEST_TIME 45 9372
TEST_TIME 46 9297
TEST_TIME 47 9217
TEST_TIME 48 9136
TEST_TIME 49 9084
TEST_TIME 50 9139
TEST_TIME 51 9113
TEST_TIME 52 9148
TEST_TIME 53 9122
TEST_TIME 54 9154
TEST_TIME 55 9172
TEST_TIME 56 9234
TEST_TIME 57 9270
TEST_TIME 58 9262
TEST_TIME 59 9500
TEST_TIME 60 9432
TEST_TIME 61 9582
TEST_TIME 62 9623
TEST_TIME 63 9514
TEST_TIME 64 9467
TEST_TIME 65 9428
TEST_TIME 66 9423
TEST_TIME 67 9333
TEST_TIME 68 9269
TEST_TIME 69 9222
TEST_TIME 70 9174
TEST_TIME 71 9178
TEST_TIME 72 9119
TEST_TIME 73 9107
TEST_TIME 74 9017
TEST_TIME 75 9014
TEST_TIME 76 9058
TEST_TIME 77 9034
TEST_TIME 78 9067
TEST_TIME 79 9043
TEST_TIME 80 9107
TEST_TIME 81 9168
TEST_TIME 82 9140
TEST_TIME 83 9189
TEST_TIME 84 9185
TEST_TIME 85 9246
TEST_TIME 86 9239
TEST_TIME 87 9242
TEST_TIME 88 9215
TEST_TIME 89 9214
TEST_TIME 90 9145
TEST_TIME 91 9149
TEST_TIME 92 9145
TEST_TIME 93 9123
TEST_TIME 94 9144
TEST_TIME 95 9137
TEST_TIME 96 9195
TEST_TIME 97 9169
TEST_TIME 98 9179
TEST_TIME 99 9233
TEST_TIME 100 9228
TEST_TIME 101 9230
TEST_TIME 102 9302
TEST_TIME 103 9272
TEST_TIME 104 9250
TEST_TIME 105 9249
TEST_TIME 106 9342
TEST_TIME 107 9325
TEST_TIME 108 9293
TEST_TIME 109 9247
TEST_TIME 110 9203
TEST_TIME 111 9218
TEST_TIME 112 9192
TEST_TIME 113 9195
TEST_TIME 114 9177
TEST_TIME 115 9173
TEST_TIME 116 9111
TEST_TIME 117 9169
TEST_TIME 118 9223
TEST_TIME 119 9209
TEST_TIME 120 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-03-2021 22:28:35 to 11-03-2021 22:28:38.

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 1526201 1526201 0 0.00 0 27744 6 0 0
doc_list_biud 1526201 1526201 0 0.00 0 55394 25 0 0
sp_add_invoice_to_stock 5127 5054 73 1.42 22 165875 16637 0 73
sp_cancel_adding_invoice 5567 5567 0 0.00 6 50399 767 0 0
sp_cancel_client_order 1719 1719 0 0.00 4 19802 338 0 0
sp_cancel_customer_reserve 549701 549701 0 0.00 1 55395 55 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 3 10364 97 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 2 6599 78 0 0
sp_cancel_supplier_invoice 6157 6144 13 0.21 2 24480 802 0 13
sp_cancel_supplier_order 401 401 0 0.00 6 999006 96001 0 0
sp_cancel_write_off 9130 9130 0 0.00 1 27745 115 0 0
sp_client_order 20437 20437 0 0.00 4 31585 378 0 0
sp_customer_reserve 463792 463792 0 0.00 0 45045 164 0 0
sp_fill_shopping_cart 31210 31210 0 0.00 1 9234 37 0 0
sp_fill_shopping_cart_clo_res 463784 463784 0 0.00 0 10872 14 0 0
sp_get_clo_for_invoice 5045 5045 0 0.00 0 28778 391 0 0
sp_kill_cost_storno 15805 15805 0 0.00 0 27742 60 0 0
sp_kill_qstorno_ret_qs2qd 1115077 1115077 0 0.00 0 55392 30 0 0
sp_kill_qty_storno 587636 587636 0 0.00 0 55394 65 0 0
sp_lock_selected_doc 20805 20805 0 0.00 0 6668 4 0 0
sp_make_cost_storno 27825 27825 0 0.00 0 13131 46 0 0
sp_multiply_rows_for_pdistr 27825 27825 0 0.00 0 14560 30 0 0
sp_multiply_rows_for_qdistr 20437 20437 0 0.00 0 10611 170 0 0
sp_pay_from_customer 7135 7135 0 0.00 4 15581 118 0 0
sp_pay_to_supplier 5716 5716 0 0.00 4 20618 127 0 0
sp_payment_common 12851 12851 0 0.00 1 15491 29 0 0
sp_qd_handle_on_cancel_clo 1719 1719 0 0.00 0 19791 305 0 0
sp_qd_handle_on_invoice_upd_sts 10612 10612 0 0.00 0 25684 338 0 0
sp_qd_handle_on_reserve_upd_sts 9929 9929 0 0.00 0 23266 59 0 0
sp_reserve_write_off 9929 9929 0 0.00 6 23302 176 0 0
sp_supplier_invoice 5404 5404 0 0.00 8 75247 3329 0 0
sp_supplier_order 5371 5371 0 0.00 5 57914 1328 0 0
srv_aggregate_perf_data 100 100 0 0.00 2916 486531 21596 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1236 119606 35363 0 0
srv_find_qd_qs_mism 1049944 1049944 0 0.00 0 17950 5 0 0
srv_make_invnt_saldo 588 588 0 0.00 38 36557 1040 0 0
srv_make_money_saldo 769 769 0 0.00 0 282 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 134865 648592 345085 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 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 5054 5054 0 0.00 0 13224 149 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 3028 67 0 0
t$perf-norm:sp_cancel_client_order 1719 1719 0 0.00 0 2335 11 0 0
t$perf-norm:sp_cancel_customer_reserve 730 730 0 0.00 0 6281 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 1850 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 378 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 418 418 0 0.00 0 623 11 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 37399 1686 0 0
t$perf-norm:sp_cancel_write_off 1046 1046 0 0.00 0 3186 10 0 0
t$perf-norm:sp_client_order 20437 20437 0 0.00 0 11612 15 0 0
t$perf-norm:sp_customer_reserve 998 998 0 0.00 0 10109 13 0 0
t$perf-norm:sp_pay_from_customer 7135 7135 0 0.00 0 5161 10 0 0
t$perf-norm:sp_pay_to_supplier 5716 5716 0 0.00 0 6129 12 0 0
t$perf-norm:sp_reserve_write_off 9929 9929 0 0.00 0 9278 10 0 0
t$perf-norm:sp_supplier_invoice 5404 5404 0 0.00 0 4534 17 0 0
t$perf-norm:sp_supplier_order 5371 5371 0 0.00 0 4454 14 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 174 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 250 3 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 1604 20 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 8130 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 10236 10090 146 1.42 0 17586 21 0 146
v_all_customers 37548 37548 0 0.00 0 151 1 0 0
v_all_suppliers 29806 29806 0 0.00 0 19 1 0 0
v_all_wares 40874 40874 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 2424 8 0 0
v_cancel_client_order 3438 3438 0 0.00 0 4984 10 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 10339 24 0 0
v_cancel_customer_reserve 1460 1460 0 0.00 0 2117 4 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 6503 13 0 0
v_cancel_supplier_invoice 862 836 26 3.01 0 3940 19 0 26
v_cancel_supplier_order 802 802 0 0.00 0 507 4 0 0
v_cancel_write_off 2092 2092 0 0.00 0 8146 18 0 0
v_max_id_clo_ord 5371 5371 0 0.00 0 949 1 0 0
v_max_id_clo_res 998 998 0 0.00 0 4093 16 0 0
v_max_id_ord_sup 5402 5402 0 0.00 0 2786 4 0 0
v_max_non_paid_invoice 1586 1586 0 0.00 0 309 2 0 0
v_max_non_paid_realizn 3710 3710 0 0.00 0 1517 3 0 0
v_min_id_clo_ord 5371 5371 0 0.00 0 3461 7 0 0
v_min_id_clo_res 998 998 0 0.00 0 3281 17 0 0
v_min_id_ord_sup 5402 5402 0 0.00 0 5170 5 0 0
v_min_non_paid_invoice 5716 5716 0 0.00 0 4550 15 0 0
v_min_non_paid_realizn 7135 7135 0 0.00 0 13221 19 0 0
v_our_firm 10176 10176 0 0.00 0 16 1 0 0
v_reserve_write_off 19858 19858 0 0.00 0 10643 10 0 0
x_lock_depdocs_on_canc_invoice 11293 11293 0 0.00 0 12471 110 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 5744 351 0 0
x_make_qstorno_1000_1200 5371 5371 0 0.00 2 57904 1251 0 0
x_make_qstorno_1200_2000 5404 5404 0 0.00 3 75216 3199 0 0
x_make_qstorno_2100_3300 463792 463792 0 0.00 0 45043 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2021 22:28:39 to 11-03-2021 22:28:43.

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
19:57:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:34 21889 8192000000 10267777968 10574999552 1022927696 11.100 80 63 129 0 1046538656 2876464 20734496
19:58:03 28537 8192000000 10340761040 10656559104 1378614688 14.404 100 84 168 0 1411890528 4673568 28602272
19:58:39 28266 8192000000 10379126624 10698477568 1432432336 14.883 100 92 184 0 1468959408 5787808 30739264
19:59:22 31692 8192000000 10432504016 10758660096 1477734896 15.282 100 86 172 0 1512987568 6977200 28275472
20:00:04 11098 8192000000 10433845504 10766503936 1493019072 15.415 100 87 174 0 1528523568 7511344 27993152
20:00:28 28034 8192000000 10455989584 10790428672 1508095648 15.547 100 87 173 1 1544121520 8155600 27870272
20:01:08 15705 8192000000 10471759168 10807746560 1528851904 15.727 100 89 178 1 1566143872 8968240 28323728
20:01:32 19275 8192000000 10481732272 10826248192 1539317760 15.818 100 81 162 2 1574029216 9732544 24978912
20:01:58 14550 8192000000 10513279168 10860109824 1564019728 16.031 100 79 158 0 1597914048 9655056 24239264
20:02:21 10363 8192000000 10533576400 10885136384 1593282896 16.282 100 78 156 0 1626310496 9754880 23272720
20:02:42 18934 8192000000 10568925712 10926043136 1616882448 16.483 100 82 164 0 1651602928 10288784 24431696
20:03:10 10667 8192000000 10586926448 10947330048 1642664176 16.702 100 77 154 0 1676060000 10726624 22669200
20:03:29 11729 8192000000 10609005216 10970075136 1668294144 16.919 100 79 157 2 1702563184 11615248 22653792
20:03:51 9411 8192000000 10639930240 11006070784 1689790608 17.100 100 82 164 0 1725358928 12284736 23283584
20:04:07 9193 8192000000 10653592048 11021950976 1712892448 17.293 100 86 172 2 1751079696 12977952 25209296
20:04:26 9109 8192000000 10667960160 11039502336 1729876976 17.434 100 85 170 1 1767577312 13232336 24468000
20:04:41 10257 8192000000 10670710720 11048300544 1735527872 17.481 100 79 157 0 1771455360 13664896 22262592
20:05:00 5751 8192000000 10685830272 11062067200 1746529776 17.573 100 84 168 2 1783276656 12706800 24040080
20:05:13 5114 8192000000 10685449216 11064954880 1752598336 17.623 100 75 149 1 1786318256 12683008 21036912
20:05:26 5440 8192000000 10703438864 11081990144 1768225600 17.752 100 85 169 1 1803138672 12050848 22862224
20:05:38 3952 8192000000 10723391744 11101265920 1779071088 17.842 100 85 170 1 1816503744 12912224 24520432
20:05:49 3007 8192000000 10722562544 11101450240 1781371440 17.861 100 85 168 1 1816600256 12056208 23172608
20:05:59 4512 8192000000 10730998496 11106078720 1792793424 17.955 100 85 168 0 1828405904 12487824 23124656
20:06:10 3366 8192000000 10736936880 11117170688 1795151296 17.974 100 91 180 2 1833833088 13776496 24905296
20:06:20 3873 8192000000 10741375968 11122724864 1800593632 18.019 100 90 180 2 1840184480 15042896 24547952
20:06:31 9456 8192000000 10744233104 11129405440 1806103744 18.064 100 88 174 0 1846009936 15404000 24502192
20:06:48 5570 8192000000 10760293776 11141369856 1809205360 18.089 100 87 173 2 1848321824 15553904 23562560
20:07:01 2303 8192000000 10771227264 11152609280 1824806528 18.217 100 92 184 0 1864788896 14362464 25619904
20:07:09 2478 8192000000 10777754176 11157508096 1826894048 18.234 100 95 190 1 1868348848 14225664 27229136
20:07:19 2181 8192000000 10769706848 11152941056 1831986704 18.276 100 91 180 1 1873043696 15477200 25579792
20:07:28 2476 8192000000 10776489680 11158487040 1832148656 18.277 100 89 179 1 1871471216 14102576 25219984
20:07:38 2261 8192000000 10785353056 11167186944 1840424912 18.344 100 92 183 5 1880673616 14791600 25457104
20:07:46 1692 8192000000 10787738384 11171737600 1841923888 18.356 100 86 171 0 1880167856 13745520 24498448
20:07:55 1756 8192000000 10794008736 11179380736 1852746704 18.444 100 94 187 4 1891582496 12406528 26429264
20:08:04 2224 8192000000 10794406560 11182092288 1852028384 18.439 100 94 189 0 1892589872 13017024 27544464
20:08:13 1766 8192000000 10802364832 11185668096 1855085056 18.463 100 87 174 1 1892719920 12560160 25074704
20:08:21 1771 8192000000 10801854528 11189039104 1859490544 18.499 100 86 171 0 1896598592 12514208 24593840
20:08:28 1461 8192000000 10809808864 11195412480 1864902432 18.543 100 96 190 0 1904873184 12587456 27383296
20:08:36 1317 8192000000 10815889568 11199541248 1870914528 18.592 100 93 190 3 1910471936 12870192 26687216
20:08:44 1526 8192000000 10815868016 11204616192 1875765328 18.631 100 88 175 2 1911415152 11534192 24115632
20:08:52 1487 8192000000 10824797680 11211780096 1882702128 18.687 100 93 186 2 1922133776 13028336 26403312
20:09:00 30498 8192000000 10804008272 11215687680 1872823488 18.607 100 57 115 2 1904742112 15273520 16645104
20:09:37 17791 8192000000 10818285392 11214528512 1880046432 18.665 100 77 151 1 1910219312 7653008 22519872
20:10:01 2745 8192000000 10832444272 11222163456 1885918928 18.713 100 86 174 1 1921000000 10464896 24616176
20:10:10 5387 8192000000 10807492992 11221483520 1882605920 18.686 100 57 114 2 1910799680 12607456 15586304
20:10:22 5252 8192000000 10812088240 11221442560 1882506320 18.685 100 43 84 1 1901451776 7092416 11853040
20:10:36 5267 8192000000 10789712240 11216027648 1879127504 18.658 100 32 67 0 1895768784 6934640 9706640
20:10:49 5284 8192000000 10805124896 11225698304 1885101664 18.706 100 35 68 4 1901960928 7216000 9643264
20:11:01 7962 8192000000 10798836720 11225878528 1886491264 18.717 100 24 49 0 1899565216 5911312 7162640
20:11:20 11602 8192000000 10807453056 11235246080 1894051840 18.778 100 24 47 0 1907702480 6972032 6678608
20:11:39 11579 8192000000 10801134080 11231719424 1891286224 18.756 100 13 25 1 1900688448 5749616 3652608
20:11:58 10467 8192000000 10806823888 11239297024 1897747200 18.808 100 29 58 0 1913193840 7254144 8192496
20:12:18 17557 8192000000 10804250544 11236855808 1896646992 18.799 100 13 26 1 1909374048 9478032 3249024
20:12:42 8374 8192000000 10802510384 11238060032 1895653696 18.791 100 11 22 0 1904546032 5759216 3133120
20:13:00 5401 8192000000 10815105264 11242270720 1899627552 18.823 100 23 46 5 1912543680 6756544 6159584
20:13:12 8637 8192000000 10805802416 11243405312 1898523248 18.814 100 11 22 1 1907217248 5693552 3000448
20:13:29 18232 8192000000 10809147952 11245785088 1902950288 18.850 100 13 26 0 1912474240 5985664 3538288
20:13:59 48422 8192000000 10828437760 11253956608 1909152272 18.900 100 24 49 0 1921059440 4825456 7081712
20:14:55 19954 8192000000 10811598496 11253129216 1904462320 18.862 100 21 42 0 1915918032 5475392 5980320
20:15:21 7139 8192000000 10826392848 11261919232 1909774384 18.905 100 27 54 1 1923738768 6606064 7358320
20:15:35 4762 8192000000 10830185488 11253866496 1893167648 18.771 99 43 86 2 1911343136 6897984 11277504
20:15:50 4277 8192000000 10822485072 11254476800 1905254176 18.869 100 29 58 0 1920587904 6689760 8643968
20:16:02 4964 8192000000 10830615760 11260309504 1908951456 18.898 100 32 63 3 1925020048 6697312 9371280
20:16:15 6461 8192000000 10820267296 11254861824 1907759024 18.889 100 35 70 1 1925062304 7361952 9941328
20:16:28 4906 8192000000 10809901376 11239624704 1871981968 18.600 98 32 64 1 1887238112 6132720 9123424
20:16:39 11603 8192000000 10813827856 11244785664 1882065104 18.682 99 23 45 0 1893677936 5240000 6372832
20:16:58 9124 8192000000 10811320576 11237892096 1875601344 18.630 99 27 54 1 1889330016 6596624 7132048
20:17:13 6204 8192000000 10816941200 11245723648 1892910736 18.769 100 29 59 1 1911192320 10283280 7998304
20:17:26 7297 8192000000 10807259472 11246387200 1901834944 18.841 100 28 54 5 1915865184 5747888 8282352
20:17:39 6389 8192000000 10791297936 11225788416 1867351456 18.563 99 16 32 0 1877720048 5916768 4451824
20:17:55 12540 8192000000 10757717840 11186724864 1771105536 17.776 94 22 44 0 1782877680 4944928 6827216
20:18:16 16024 8192000000 10775640192 11207151616 1818969472 18.169 97 17 34 1 1829564160 5684240 4910448
20:18:38 11963 8192000000 10739845216 11169562624 1759001120 17.676 95 11 22 0 1766977648 5006480 2970048
20:19:01 61518 8192000000 10754651152 11156545536 1755504240 17.647 95 48 95 2 1775364304 6045760 13814304
20:20:08 10381 8192000000 10706405088 11131383808 1765475856 17.730 97 20 40 0 1777568768 6482000 5610912
20:20:26 8820 8192000000 10694196720 11108290560 1707071248 17.244 94 17 34 2 1716848432 4790240 4986944
20:20:41 6365 8192000000 10698022288 11107135488 1733546320 17.465 97 37 74 3 1754457440 11083136 9827984
20:20:56 6263 8192000000 10714460416 11135447040 1753234448 17.628 97 28 56 0 1767781808 6342560 8204800
20:21:10 5041 8192000000 10713336768 11121635328 1790837440 17.939 100 36 69 2 1807294688 6510992 9946256
20:21:25 7548 8192000000 10697661632 11116081152 1748945120 17.593 98 13 26 2 1757908384 5259024 3704240
20:21:38 7082 8192000000 10667894240 11078537216 1719274768 17.346 96 28 57 2 1733022064 5472064 8275232
20:21:54 7225 8192000000 10722283760 11137605632 1796817264 17.988 100 28 56 1 1810933920 6344576 7772080
20:22:13 7063 8192000000 10735149232 11158953984 1820725296 18.184 100 31 63 2 1840148144 10579760 8843088
20:22:27 7425 8192000000 10752381360 11167215616 1795677296 17.978 98 26 52 0 1809468256 5389344 8401616
20:22:43 10815 8192000000 10747762384 11162959872 1789694752 17.929 98 31 62 1 1804289072 5675888 8918432
20:23:01 10695 8192000000 10736832704 11147280384 1791149728 17.941 98 30 60 1 1805805216 5356304 9299184
20:23:17 12185 8192000000 10748165584 11165376512 1816186608 18.147 99 26 53 2 1829639312 5624848 7827856
20:23:37 9754 8192000000 10751912272 11176341504 1837649808 18.322 100 20 40 0 1849171664 6048512 5473344
20:23:54 70899 8192000000 10747192608 11182137344 1844476608 18.377 100 33 66 0 1859254256 5592112 9185536
20:25:14 5759 8192000000 10763513440 11189882880 1848639264 18.411 100 24 48 2 1861003072 5826768 6537040
20:25:28 10300 8192000000 10769111888 11198316544 1856674864 18.476 100 27 54 0 1871057872 6448960 7934048
20:25:45 5999 8192000000 10764286912 11197509632 1857278960 18.481 100 23 44 2 1869699840 5129248 7291632
20:25:58 6293 8192000000 10785579536 11209392128 1866752784 18.558 100 40 80 1 1884840864 6928864 11159216
20:26:15 13953 8192000000 10792056816 11211071488 1864894384 18.543 100 21 42 0 1876859664 5927952 6037328
20:26:38 10283 8192000000 10789434064 11217772544 1870197104 18.586 100 19 38 3 1881071680 5387536 5487040
20:26:58 11115 8192000000 10799452016 11231227904 1881689200 18.679 100 24 47 2 1897058848 9224640 6145008
20:27:16 6551 8192000000 10809445184 11238223872 1893904864 18.777 100 23 46 0 1910666976 9519792 7242320
20:27:31 13935 8192000000 10825743248 11247079424 1901490896 18.838 100 37 72 1 1915641328 4553792 9596640
20:28:03 28566 8192000000 10844374672 11267756032 1916777696 18.961 100 38 76 2 1935248048 7015328 11455024
20:28:44 33320 8192000000 10851760704 11278802944 1927182080 19.044 100 45 89 1 1948949808 8387168 13380560
20:29:25 16642 8192000000 10868922288 11288940544 1934478496 19.103 100 41 83 0 1955661536 9094128 12088912
20:29:56 86463 8192000000 10866099120 11311558656 1939993792 19.147 100 35 71 0 1958373536 8061760 10317984
20:31:29 27246 8192000000 10872124960 11315978240 1945663424 19.192 100 27 52 1 1967732960 14018112 8051424
20:32:07 11962 8192000000 10886751712 11324190720 1954625808 19.263 100 45 90 2 1978519744 10874640 13019296
20:32:27 17269 8192000000 10889392080 11332390912 1962128240 19.323 100 36 71 3 1983513056 11267968 10116848
20:32:51 33518 8192000000 10902341856 11340832768 1966904096 19.361 100 28 56 1 1985107168 10077232 8125840
20:33:42 21830 8192000000 10928013632 11357040640 1981469248 19.476 100 54 107 4 2013092320 16367824 15255248
20:34:15 9192 8192000000 10923504480 11365208064 1987642096 19.525 100 45 90 0 2018199520 17603680 12953744
20:34:39 17197 8192000000 10938267360 11375554560 1994023440 19.576 100 46 92 3 2025172256 17170800 13978016
20:35:10 7506 8192000000 10945365184 11374182400 1984079104 19.497 99 57 111 2 2019857792 18948192 16830496
20:35:24 9146 8192000000 10945302160 11380420608 1998522400 19.611 100 54 108 0 2035412576 20594400 16295776
20:35:46 25544 8192000000 10960940864 11394654208 2006586512 19.675 100 61 122 0 2048082928 22717264 18779152
20:36:19 16885 8192000000 10960890624 11398295552 2009220176 19.695 100 46 90 2 2046928400 23452896 14255328
20:36:47 13947 8192000000 10961523072 11400724480 2012733424 19.723 100 50 100 1 2046995232 19410144 14851664
20:37:08 5017 8192000000 10966413776 11402498048 2016399648 19.752 100 51 100 0 2051089808 19743776 14946384
20:37:24 10052 8192000000 10956122880 11388334080 2001986816 19.638 99 58 117 0 2040823280 21559328 17277136
20:37:44 6163 8192000000 10961523648 11395588096 1996766896 19.597 99 61 122 0 2036878768 22051792 18060080
20:38:00 11132 8192000000 10970548960 11404374016 2016056512 19.749 100 59 119 0 2057578704 22643248 18878944
20:38:19 5575 8192000000 10967157168 11405524992 2016128304 19.750 100 50 100 1 2055142432 23694192 15319936
20:38:32 8849 8192000000 10976362672 11414122496 2021240688 19.790 100 66 130 1 2065276560 24425232 19610640
20:38:53 5027 8192000000 10964174912 11394502656 1979663088 19.462 98 63 125 1 2021213600 23064240 18486272
20:39:06 11064 8192000000 10969544272 11406028800 2014083888 19.734 100 51 102 2 2056358560 26856464 15418208
20:39:40 13708 8192000000 10976192320 11415162880 2021206592 19.790 100 51 100 1 2064756336 28078592 15471152
20:40:03 4320 8192000000 10987881680 11424923648 2027938704 19.842 100 61 121 1 2074990288 28915040 18136544
20:40:18 7900 8192000000 11000584112 11428368384 2026462288 19.831 100 74 147 2 2080649056 31177312 23009456
20:40:38 13900 8192000000 10975286016 11415977984 1983826752 19.495 98 62 121 2 2037459888 34524720 19108416
20:41:06 10036 8192000000 10986281104 11427749888 2021850592 19.795 100 58 115 2 2074913952 35121280 17942080
20:41:25 4525 8192000000 11001705552 11433496576 2029318512 19.853 100 70 139 0 2085951888 35440352 21193024
20:41:37 2508 8192000000 10984302848 11405815808 2001761024 19.637 99 77 155 2 2062564736 36724160 24079552
20:41:46 2694 8192000000 10997494480 11418263552 2011812560 19.716 100 94 184 2 2079066288 38046144 29207584
20:41:56 4325 8192000000 10978576976 11402305536 1999179664 19.616 100 91 182 1 2066272640 38823008 28269968
20:42:09 1235 8192000000 10987532864 11401736192 1999398688 19.618 100 94 186 1 2066669792 39251008 28020096
20:42:18 2254 8192000000 10996808000 11413716992 2004715904 19.660 100 90 179 0 2072709616 40916720 27076992
20:42:26 2914 8192000000 10998257152 11417255936 2014086128 19.734 100 88 174 2 2083293424 42715344 26491952
20:42:37 5230 8192000000 10983024400 11408621568 1989392160 19.539 99 76 150 1 2056593056 44265568 22935328
20:42:51 4678 8192000000 10961702144 11384090624 1979494384 19.461 99 71 142 0 2043639920 42474944 21670592
20:43:06 6330 8192000000 10975291488 11403022336 1993634480 19.573 100 65 130 1 2056944064 42820560 20489024
20:43:23 2658 8192000000 10980944768 11402887168 1995835776 19.590 100 72 139 1 2057738544 40414192 21488576
20:43:33 4628 8192000000 10972499056 11394887680 1985725552 19.510 100 81 162 2 2053280336 42582640 24972144
20:43:54 2745 8192000000 10969786704 11386118144 1970572672 19.390 99 84 168 1 2042866848 45268992 27025184
20:44:04 4657 8192000000 10964096608 11384352768 1976450864 19.437 100 78 156 0 2045930080 44959040 24520176
20:44:19 1638 8192000000 10968209216 11379208192 1972315424 19.404 100 82 164 1 2045413776 47389264 25709088
20:44:34 2756 8192000000 10952618064 11373957120 1958352672 19.293 99 72 144 3 2029822864 48452720 23017472
20:44:43 2735 8192000000 10968907520 11381592064 1976275008 19.435 100 73 144 2 2046672864 47724320 22673536
20:44:53 4492 8192000000 10956019520 11376619520 1966559488 19.358 100 78 155 2 2038211712 46666688 24985536
20:45:05 5243 8192000000 10968483104 11388809216 1976027200 19.433 100 81 160 2 2047735520 46004352 25703968
20:45:18 2935 8192000000 10967049872 11379658752 1974199712 19.419 100 85 170 3 2047572752 46361792 27011248
20:45:28 4636 8192000000 10961405344 11378257920 1969554608 19.382 100 83 166 0 2042845440 47354896 25935936
20:45:39 7724 8192000000 10943380752 11380916224 1974218944 19.419 100 55 109 2 2037205952 45147968 17839040
20:46:01 16875 8192000000 10950486672 11391975424 1958198912 19.292 99 33 66 0 2016126752 46313440 11614400
20:46:25 8074 8192000000 10963278416 11396202496 1963418496 19.333 99 64 127 1 2034904208 50792336 20693376
20:46:49 3002 8192000000 10944281216 11373305856 1948981872 19.218 99 64 127 0 2019478400 49488304 21008224
20:46:58 2242 8192000000 10951768544 11374673920 1955990016 19.274 99 78 157 0 2030088352 47251280 26847056
20:47:10 16288 8192000000 10898749504 11357589504 1909753744 18.905 97 36 72 1 1966321424 44598224 11969456
20:47:35 15731 8192000000 10916849456 11370360832 1952330512 19.245 100 21 42 1 1994500528 35224816 6945200
20:47:59 8281 8192000000 10892306192 11324612608 1907550848 18.887 98 34 67 2 1954184624 36191952 10441824
20:48:17 19006 8192000000 10908792912 11349483520 1926506400 19.039 99 42 85 0 1977297264 37899216 12891648
20:48:42 12971 8192000000 10906030112 11358871552 1948433472 19.214 100 29 57 0 1998905136 41463744 9007920
20:49:09 32121 8192000000 10911403024 11365097472 1955563952 19.271 100 29 58 1 2000674592 36230272 8880368
20:49:48 15881 8192000000 10925254848 11373600768 1960753952 19.312 100 24 46 1 2006316560 37648160 7914448
20:50:14 12204 8192000000 10931503936 11384061952 1965900192 19.353 100 21 42 0 2013602064 40532032 7169840
20:50:39 13843 8192000000 10936528576 11375353856 1945090416 19.187 99 36 72 1 2002640560 45648528 11901616
20:51:12 31263 8192000000 10938011904 11386511360 1946031856 19.195 99 37 74 2 2008140096 49796560 12311680
20:51:56 25003 8192000000 10910086704 11366084608 1919333776 18.982 98 27 54 2 1975027152 46329472 9363904
20:52:28 32758 8192000000 10906502704 11359744000 1933628624 19.096 99 26 52 0 1981519712 39134208 8756880
20:53:21 31916 8192000000 10898007648 11351363584 1890733072 18.752 97 21 42 2 1935933072 37998128 7201872
20:53:59 39959 8192000000 10889072816 11356717056 1891109520 18.755 98 21 42 0 1946313232 47491888 7711824
20:54:51 45431 8192000000 10863498800 11321946112 1880229456 18.667 98 10 21 0 1914365856 31111920 3024480
20:55:44 46507 8192000000 10857327392 11306512384 1883164784 18.691 98 18 37 0 1901988128 12966688 5856656
20:56:37 116419 8192000000 10854414752 11306655744 1868759472 18.574 97 29 58 0 1893488496 16156656 8572368
20:58:42 53935 8192000000 10859676544 11301285888 1910690240 18.912 99 36 72 0 1932674416 12076752 9907424
20:59:55 76263 8192000000 10837738928 11300552704 1888934016 18.737 98 13 26 1 1908372272 15852928 3585328
21:01:18 17716 8192000000 10872352256 11319676928 1936800784 19.121 100 22 45 3 1952377488 8850688 6726016
21:02:31 73267 8192000000 10877906288 11337621504 1946812080 19.201 100 25 49 2 1970839536 17371888 6655568
21:04:09 47861 8192000000 10865329024 11328262144 1947899024 19.210 100 13 26 0 1960837552 8856080 4082448
21:05:06 56001 8192000000 10871388464 11342905344 1939894624 19.146 99 12 24 1 1953686352 10236832 3554896
21:07:47 47648 8192000000 10876357056 11342282752 1943368064 19.174 99 15 30 1 1960221648 12721120 4132464
21:08:45 100364 8192000000 10899473232 11362447360 1951291408 19.237 99 21 42 1 1967199184 9579008 6328768
21:10:34 38691 8192000000 10870066560 11344007168 1950997264 19.234 99 24 47 1 1971180624 13540016 6643344
21:11:19 29048 8192000000 10889857024 11347251200 1931370384 19.078 98 24 48 2 1949618272 10880752 7367136
21:12:19 42612 8192000000 10876452272 11357519872 1947257280 19.205 99 11 22 0 1962084528 11955504 2871744
21:13:08 32104 8192000000 10872633648 11345387520 1946851216 19.201 99 13 26 0 1958466592 7895328 3720048
21:14:10 72694 8192000000 10893781408 11361595392 1970513072 19.390 100 16 32 0 1981620064 6551824 4555168
21:15:28 69762 8192000000 10910156000 11385602048 1981802192 19.479 100 25 49 0 1998998912 10358768 6837952
21:16:44 63499 8192000000 10894889296 11389423616 1964065200 19.338 99 8 16 0 1980047456 13876176 2106080
21:18:04 47604 8192000000 10908196032 11391840256 1983555280 19.493 100 13 25 0 2001108512 14070128 3483104
21:19:02 51112 8192000000 10895773392 11371470848 1945750960 19.193 98 18 36 0 1966338576 15695360 4892256
21:19:59 40282 8192000000 10904506384 11367104512 1965388464 19.349 99 26 52 2 1985251968 12882112 6981392
21:20:51 63615 8192000000 10924680320 11395022848 1990326624 19.546 100 24 48 1 2009703344 12115616 7261104
21:22:12 37340 8192000000 10935055312 11396071424 1989365280 19.539 100 20 40 1 2008836720 13941616 5529824
21:22:58 61708 8192000000 10925127440 11405733888 1994479936 19.579 100 17 34 1 2016779440 17222192 5077312
21:24:24 41939 8192000000 10939190000 11400265728 1983839408 19.495 99 31 62 1 2008145024 15191008 9114608
21:25:12 60502 8192000000 10901782496 11389632512 1913718176 18.936 96 15 30 0 1942017520 23899776 4399568
21:26:34 92166 8192000000 10913817952 11387912192 1944159280 19.180 98 20 40 2 1963329872 13814464 5356128
21:28:25 68409 8192000000 10892812480 11357114368 1920844592 18.994 97 16 32 1 1936332528 11275296 4212640
21:29:40 92197 8192000000 10888846848 11336900608 1840339744 18.344 93 19 38 1 1855569856 10325728 4904384
21:31:31 38263 8192000000 10926299056 11363762176 1959331840 19.301 99 58 113 1 1983295568 7939648 16024080
21:32:17 43405 8192000000 10885858080 11363401728 1960170640 19.307 99 42 84 0 1984477760 12464144 11842976
21:33:18 56605 8192000000 10883491520 11371958272 1973561520 19.414 100 8 16 0 1983303168 7651072 2090576
21:34:23 12768 8192000000 10890160512 11375443968 1979319296 19.459 100 6 12 0 1988226112 7071584 1835232
21:34:41 16763 8192000000 10894509200 11379838976 1980783216 19.471 100 5 10 0 1989713280 7667200 1262864
21:35:24 61848 8192000000 10885630976 11371270144 1958066912 19.291 99 4 8 0 1966337520 6847472 1423136
21:36:51 97260 8192000000 10853439264 11319742464 1876650384 18.638 95 19 37 0 1890320064 8305792 5363888
21:38:34 26482 8192000000 10843590080 11325460480 1896769328 18.800 97 33 66 0 1914254864 8023040 9462496
21:39:11 35249 8192000000 10868036144 11336052736 1916093008 18.956 98 22 44 0 1929795744 7326656 6376080
21:39:52 21898 8192000000 10875218976 11350712320 1952849760 19.249 100 16 32 1 1965357744 8150032 4357952
21:40:31 80094 8192000000 10892791840 11357220864 1932576800 19.087 98 19 39 1 1944869824 7338544 4954480
21:42:03 119606 8192000000 10851634992 11342753792 1845198000 18.383 94 8 16 1 1858857584 11248448 2411136
21:44:50 57074 8192000000 10835331296 11300397056 1836783216 18.315 94 16 32 0 1851622240 10308048 4530976
21:45:54 63777 8192000000 10855028000 11310391296 1829914928 18.259 95 17 34 0 1845691632 11003088 4773616
21:47:05 80456 8192000000 10845387344 11312545792 1825631472 18.224 95 30 60 0 1847431472 13456448 8343552
21:48:32 107329 8192000000 10858323088 11327942656 1877110592 18.642 97 20 40 2 1895487664 12554560 5822512
21:50:37 18181 8192000000 10892560832 11339251712 1926014592 19.035 99 48 96 2 1952661552 13388704 13258256
21:51:02 9423 8192000000 10881916160 11326128128 1908125088 18.892 98 50 100 0 1932148832 10458304 13565440
21:51:23 17953 8192000000 10841700128 11292299264 1889233728 18.740 99 44 88 0 1912852672 11533488 12085456
21:51:49 20332 8192000000 10864621184 11309531136 1901057456 18.835 99 43 86 1 1924217952 11355296 11805200
21:52:16 17604 8192000000 10886011696 11326464000 1932524176 19.087 100 52 104 1 1960142832 13195104 14423552
21:52:44 88436 8192000000 10863869168 11329642496 1893892720 18.777 98 24 48 0 1913283648 12865552 6525376
21:54:19 34471 8192000000 10876889984 11335847936 1923053424 19.011 99 17 34 1 1935398208 8173264 4171520
21:55:08 35365 8192000000 10869761568 11330224128 1923055920 19.011 99 31 61 1 1942820528 11106048 8658560
21:55:56 114146 8192000000 10868364832 11332063232 1923951968 19.018 99 21 42 0 1938511600 8279392 6280240
21:58:13 69842 8192000000 10850301600 11342118912 1937337824 19.126 100 7 13 1 1951582016 12431264 1812928
21:59:32 33577 8192000000 10858908064 11344027648 1922001872 19.003 99 2 4 0 1936607360 14480224 125264
22:00:12 2833 8192000000 10863620176 11349016576 1938683120 19.136 100 5 10 0 1953840912 14341472 816320
22:00:21 19499 8192000000 10864954416 11348307968 1941472512 19.159 100 7 14 2 1959587104 16496160 1618432
22:00:47 4389 8192000000 10871432752 11343351808 1941959712 19.162 100 6 12 0 1959754224 15670752 2123760
22:00:57 29353 8192000000 10873829936 11356610560 1942794528 19.169 100 6 12 0 1957300624 13247600 1258496
22:01:33 52984 8192000000 10898661712 11372642304 1975274576 19.427 100 17 34 5 1988311696 7875728 5161392
22:02:32 48503 8192000000 10903405728 11374870528 1975693392 19.431 100 15 31 1 1991215776 10799648 4722736
22:03:36 61813 8192000000 10928099200 11378388992 1962912784 19.329 99 20 40 0 1975897200 7929504 5054912
22:04:45 42299 8192000000 10904718400 11377913856 1968285488 19.372 99 41 82 0 1990558160 10169360 12103312
22:05:35 103604 8192000000 10904618816 11388100608 1962309840 19.324 99 28 56 0 1981553280 11471760 7771680
22:07:25 50034 8192000000 10911696832 11384573952 1949938784 19.226 98 31 62 1 1967008704 7352752 9717168
22:08:28 80423 8192000000 10908997744 11397320704 1968071904 19.370 99 14 28 0 1983046816 10676032 4298880
22:09:54 101271 8192000000 10880388080 11336753152 1803466880 18.042 91 21 42 0 1821019408 11719008 5833520
22:11:51 50319 8192000000 10907937792 11368574976 1950874288 19.233 99 34 68 0 1976078384 15259456 9944640
22:12:52 114574 8192000000 10887873520 11359764480 1908926512 18.898 97 12 24 3 1938015840 25539216 3550112
22:14:54 34570 8192000000 10899293440 11354562560 1948758496 19.217 99 36 72 1 1967683056 8218704 10705856
22:16:42 62941 8192000000 10857498240 11321430016 1897847056 18.809 97 18 36 1 1909693248 7021024 4825168
22:18:04 80649 8192000000 10873755920 11356033024 1922657472 19.008 98 19 38 0 1937867680 9157456 6052752
22:20:56 51638 8192000000 10882524544 11360501760 1941031472 19.155 99 16 30 0 1954408464 8748144 4628848
22:21:55 64251 8192000000 10882840800 11362844672 1931695072 19.080 98 14 28 1 1949056576 13049248 4312256
22:23:06 55410 8192000000 10884977552 11357040640 1924272048 19.021 98 10 20 0 1943644128 16192064 3180016
22:24:25 71319 8192000000 10868559488 11354947584 1918974384 18.979 98 11 22 2 1941994192 20014736 3005072
22:25:45 55956 8192000000 10861087424 11317633024 1826016064 18.227 94 15 30 2 1841062272 10932736 4113472
22:26:48 41480 8192000000 9436650480 9733070848 574216992 6.550 30 11 20 2 580786416 3594160 2975264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 11-03-2021 22:28:45 to 11-03-2021 22:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 73 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 11-03-2021 22:29:16 to 11-03-2021 22:29:18.

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          237803
MON$OLDEST_ACTIVE               238711
MON$OLDEST_SNAPSHOT             238711
MON$NEXT_TRANSACTION            238711
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                       2005248
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.33424 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33424 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33424 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33424 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 ---
--- end of diff output ---

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

11.03.21 22:29:19. 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-11 22:29:21 No severe PSQL-related problems occured
11.03.21 22:29:23. End of report.