Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.04.2021 19: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 17234360 kB
MemAvailable 31420760 kB
Buffers 0 kB
Cached 14402456 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-04-03 19:27:27
DTS_END                         2021-04-03 19:27:27.6750
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/46808
TRN_ID                          240282
ATT_ID                          628
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: 9122.55 24550 1094706
customer order: creation 168.86 392 20263
customer order: refuse 14.58 396 1750
order to supplier: creation 45.83 1274 5499
order to supplier: removal 3.38 102330 405
invoice (draft): creation 45.79 3598 5495
invoice (draft): removal 52.48 805 6298
invoice accept: apply 41.43 18118 4971
invoice accept: cancel 47.32 741 5678
customer reserve: creation 3805.13 180 456616
customer reserve: removal 4601.62 59 552194
realization accept: apply 83.43 179 10011
realization accept: cancel 85.20 113 10224
payment from customer: creation 58.28 113 6993
payment from customer: removal 5.45 82 654
payment to supplier: creation 48.22 116 5786
payment to supplier: removal 3.28 82 394
service: total inventory turnovers 4.91 1097 589
service: total monetary turnovers 6.43 88 772
service: aggregate perf. data 0.92 13838 110
service: refresh index statistics 0.03 347403 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-04-2021 19:28:42 to 03-04-2021 19:28:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2964
TEST_TIME 2 4718
TEST_TIME 3 3329
TEST_TIME 4 4951
TEST_TIME 5 4449
TEST_TIME 6 4265
TEST_TIME 7 5401
TEST_TIME 8 5267
TEST_TIME 9 6057
TEST_TIME 10 6005
TEST_TIME 11 6314
TEST_TIME 12 6610
TEST_TIME 13 6953
TEST_TIME 14 7370
TEST_TIME 15 7510
TEST_TIME 16 7477
TEST_TIME 17 7919
TEST_TIME 18 8317
TEST_TIME 19 8304
TEST_TIME 20 8224
TEST_TIME 21 8685
TEST_TIME 22 8675
TEST_TIME 23 8720
TEST_TIME 24 9067
TEST_TIME 25 9361
TEST_TIME 26 9351
TEST_TIME 27 10117
TEST_TIME 28 10672
TEST_TIME 29 10840
TEST_TIME 30 10871
TEST_TIME 31 10626
TEST_TIME 32 10446
TEST_TIME 33 10351
TEST_TIME 34 10161
TEST_TIME 35 9947
TEST_TIME 36 9901
TEST_TIME 37 9854
TEST_TIME 38 9884
TEST_TIME 39 9942
TEST_TIME 40 9976
TEST_TIME 41 9932
TEST_TIME 42 9798
TEST_TIME 43 9750
TEST_TIME 44 9668
TEST_TIME 45 9608
TEST_TIME 46 9575
TEST_TIME 47 9491
TEST_TIME 48 9402
TEST_TIME 49 9324
TEST_TIME 50 9412
TEST_TIME 51 9456
TEST_TIME 52 9440
TEST_TIME 53 9448
TEST_TIME 54 9568
TEST_TIME 55 9568
TEST_TIME 56 9637
TEST_TIME 57 9665
TEST_TIME 58 9665
TEST_TIME 59 9662
TEST_TIME 60 9755
TEST_TIME 61 9744
TEST_TIME 62 9672
TEST_TIME 63 9558
TEST_TIME 64 9677
TEST_TIME 65 9603
TEST_TIME 66 9576
TEST_TIME 67 9494
TEST_TIME 68 9427
TEST_TIME 69 9372
TEST_TIME 70 9296
TEST_TIME 71 9263
TEST_TIME 72 9237
TEST_TIME 73 9202
TEST_TIME 74 9139
TEST_TIME 75 9140
TEST_TIME 76 9077
TEST_TIME 77 9114
TEST_TIME 78 9103
TEST_TIME 79 9199
TEST_TIME 80 9161
TEST_TIME 81 9294
TEST_TIME 82 9426
TEST_TIME 83 9409
TEST_TIME 84 9408
TEST_TIME 85 9495
TEST_TIME 86 9472
TEST_TIME 87 9436
TEST_TIME 88 9355
TEST_TIME 89 9329
TEST_TIME 90 9280
TEST_TIME 91 9267
TEST_TIME 92 9225
TEST_TIME 93 9208
TEST_TIME 94 9184
TEST_TIME 95 9210
TEST_TIME 96 9148
TEST_TIME 97 9205
TEST_TIME 98 9275
TEST_TIME 99 9249
TEST_TIME 100 9328
TEST_TIME 101 9301
TEST_TIME 102 9259
TEST_TIME 103 9283
TEST_TIME 104 9320
TEST_TIME 105 9333
TEST_TIME 106 9327
TEST_TIME 107 9312
TEST_TIME 108 9319
TEST_TIME 109 9239
TEST_TIME 110 9255
TEST_TIME 111 9242
TEST_TIME 112 9209
TEST_TIME 113 9156
TEST_TIME 114 9104
TEST_TIME 115 9095
TEST_TIME 116 9093
TEST_TIME 117 9203
TEST_TIME 118 9202
TEST_TIME 119 9177
TEST_TIME 120 9125

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-04-2021 19:28:46 to 03-04-2021 19:28:49.

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 1516231 1516231 0 0.00 0 20388 6 0 0
doc_list_biud 1516231 1516231 0 0.00 0 22904 27 0 0
sp_add_invoice_to_stock 5028 4971 57 1.13 25 205475 18119 0 57
sp_cancel_adding_invoice 5678 5678 0 0.00 3 71310 741 0 0
sp_cancel_client_order 1750 1750 0 0.00 4 24066 396 0 0
sp_cancel_customer_reserve 552194 552194 0 0.00 1 22908 59 0 0
sp_cancel_pay_from_customer 654 654 0 0.00 2 3483 82 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 4413 82 0 0
sp_cancel_supplier_invoice 6301 6298 3 0.04 2 12675 805 0 3
sp_cancel_supplier_order 405 405 0 0.00 7 1013569 102330 0 0
sp_cancel_write_off 10224 10224 0 0.00 1 12534 114 0 0
sp_client_order 20263 20263 0 0.00 3 26075 392 0 0
sp_customer_reserve 456616 456616 0 0.00 0 109510 180 0 0
sp_fill_shopping_cart 31251 31251 0 0.00 1 14228 41 0 0
sp_fill_shopping_cart_clo_res 456611 456611 0 0.00 0 15293 15 0 0
sp_get_clo_for_invoice 4966 4966 0 0.00 0 25294 329 0 0
sp_kill_cost_storno 16950 16950 0 0.00 0 20373 53 0 0
sp_kill_qstorno_ret_qs2qd 1121315 1121315 0 0.00 0 22901 32 0 0
sp_kill_qty_storno 591526 591526 0 0.00 0 22904 69 0 0
sp_lock_selected_doc 20679 20679 0 0.00 0 9519 8 0 0
sp_make_cost_storno 27756 27756 0 0.00 0 12210 50 0 0
sp_multiply_rows_for_pdistr 27756 27756 0 0.00 0 8035 26 0 0
sp_multiply_rows_for_qdistr 20263 20263 0 0.00 0 24666 203 0 0
sp_pay_from_customer 6993 6993 0 0.00 4 14797 113 0 0
sp_pay_to_supplier 5786 5786 0 0.00 5 11889 116 0 0
sp_payment_common 12779 12779 0 0.00 2 13692 28 0 0
sp_qd_handle_on_cancel_clo 1750 1750 0 0.00 0 22041 332 0 0
sp_qd_handle_on_invoice_upd_sts 10644 10644 0 0.00 0 21873 321 0 0
sp_qd_handle_on_reserve_upd_sts 10011 10011 0 0.00 0 17698 53 0 0
sp_reserve_write_off 10011 10011 0 0.00 6 17718 179 0 0
sp_supplier_invoice 5495 5495 0 0.00 8 87446 3599 0 0
sp_supplier_order 5499 5499 0 0.00 5 28181 1275 0 0
srv_aggregate_perf_data 111 110 1 0.90 2619 142320 13838 0 1
srv_fill_mon_cache_memory 161 161 0 0.00 990 192453 33162 0 0
srv_find_qd_qs_mism 1046969 1046969 0 0.00 0 18373 5 0 0
srv_make_invnt_saldo 589 589 0 0.00 26 57192 1098 0 0
srv_make_money_saldo 772 772 0 0.00 1 47800 89 0 0
srv_recalc_idx_stat 4 4 0 0.00 307867 387280 347403 0 0
t$perf-abend:sp_add_invoice_to_stock 57 57 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4971 4971 0 0.00 0 27149 209 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 6069 88 0 0
t$perf-norm:sp_cancel_client_order 1750 1750 0 0.00 0 5437 19 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 7418 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 654 654 0 0.00 0 2522 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 739 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1280 14 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 38774 1842 0 0
t$perf-norm:sp_cancel_write_off 975 975 0 0.00 0 2752 8 0 0
t$perf-norm:sp_client_order 20263 20263 0 0.00 0 10602 20 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 2888 13 0 0
t$perf-norm:sp_pay_from_customer 6993 6993 0 0.00 0 5063 11 0 0
t$perf-norm:sp_pay_to_supplier 5786 5786 0 0.00 0 7758 14 0 0
t$perf-norm:sp_reserve_write_off 10011 10011 0 0.00 0 7445 13 0 0
t$perf-norm:sp_supplier_invoice 5495 5495 0 0.00 0 8471 23 0 0
t$perf-norm:sp_supplier_order 5499 5499 0 0.00 0 9729 19 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 293 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 5259 38 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 1475 22 0 0
t$perf-norm:srv_make_money_saldo 772 772 0 0.00 0 3421 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10046 9932 114 1.13 0 6214 24 0 114
v_all_customers 37020 37020 0 0.00 0 58 1 0 0
v_all_suppliers 30060 30060 0 0.00 0 26 1 0 0
v_all_wares 40526 40526 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 13160 34 0 0
v_cancel_client_order 3500 3500 0 0.00 0 4102 11 0 0
v_cancel_customer_prepayment 1308 1308 0 0.00 0 3040 10 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 4095 9 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 4404 14 0 0
v_cancel_supplier_invoice 804 798 6 0.74 0 3876 27 0 6
v_cancel_supplier_order 810 810 0 0.00 0 3398 11 0 0
v_cancel_write_off 1950 1950 0 0.00 0 4400 24 0 0
v_max_id_clo_ord 5498 5498 0 0.00 0 857 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 4235 16 0 0
v_max_id_ord_sup 5489 5489 0 0.00 0 3754 6 0 0
v_max_non_paid_invoice 1743 1743 0 0.00 0 2257 5 0 0
v_max_non_paid_realizn 3720 3720 0 0.00 0 1034 3 0 0
v_min_id_clo_ord 5498 5498 0 0.00 0 1636 5 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 1555 8 0 0
v_min_id_ord_sup 5489 5489 0 0.00 0 6198 9 0 0
v_min_non_paid_invoice 5786 5786 0 0.00 0 8016 15 0 0
v_min_non_paid_realizn 6993 6993 0 0.00 0 13688 21 0 0
v_our_firm 10052 10052 0 0.00 0 21 1 0 0
v_reserve_write_off 20022 20022 0 0.00 0 4450 9 0 0
x_lock_depdocs_on_canc_invoice 11577 11577 0 0.00 0 28204 121 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 34513 378 0 0
x_make_qstorno_1000_1200 5499 5499 0 0.00 1 28170 1194 0 0
x_make_qstorno_1200_2000 5495 5495 0 0.00 3 85724 3451 0 0
x_make_qstorno_2100_3300 456616 456616 0 0.00 0 109506 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-04-2021 19:28:50 to 03-04-2021 19:28:54.

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
16:57:31 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:37 17962 8192000000 10266833936 10573676544 1022796976 11.099 79 66 132 1 1048150944 2812224 22541744
16:58:04 30391 8192000000 10354972640 10674290688 1393462976 14.537 100 87 174 0 1427381408 5307184 28611248
16:58:44 17408 8192000000 10370752592 10695356416 1432119824 14.880 100 86 172 0 1466694832 6709520 27865488
16:59:12 27481 8192000000 10405520880 10731155456 1456382944 15.094 100 95 190 0 1494830656 7594304 30853408
17:00:00 6985 8192000000 10410466656 10740891648 1471290000 15.225 100 87 174 0 1508097504 8391104 28416400
17:00:27 12770 8192000000 10433105520 10765287424 1488588256 15.377 100 91 182 0 1526725504 8877824 29259424
17:00:49 17192 8192000000 10443264064 10780905472 1500942048 15.484 100 87 174 0 1538403728 9168064 28293616
17:01:16 2277 8192000000 10465233392 10801545216 1522992416 15.676 100 87 174 0 1560280912 9861568 27426928
17:01:26 15610 8192000000 10484125888 10823434240 1534519488 15.776 100 88 174 2 1572284672 10479024 27286160
17:01:50 13875 8192000000 10488014752 10832277504 1547886512 15.892 100 85 170 1 1585654000 11141248 26626240
17:02:14 18478 8192000000 10522784064 10871771136 1575743808 16.132 100 83 166 2 1611871472 10827296 25300368
17:02:49 14351 8192000000 10562523152 10919833600 1615778432 16.474 100 81 161 0 1650644752 11192208 23674112
17:03:12 13655 8192000000 10596786384 10956554240 1642147728 16.698 100 81 162 0 1677913936 11454592 24311616
17:03:35 8388 8192000000 10610176656 10976989184 1663535168 16.879 100 83 167 3 1700597440 12393504 24668768
17:03:54 8592 8192000000 10631326016 10996858880 1683942672 17.050 100 77 153 1 1718649664 12354400 22352592
17:04:11 8063 8192000000 10646357872 11015364608 1702003760 17.202 100 81 162 1 1738673312 13005120 23664432
17:04:25 8763 8192000000 10654206384 11026460672 1714213024 17.304 100 80 161 2 1749934608 13056336 22665248
17:04:42 8402 8192000000 10670586016 11041169408 1723940320 17.385 100 75 150 1 1758356192 12322320 22093552
17:04:59 5126 8192000000 10679846624 11056103424 1739748272 17.517 100 70 140 0 1772070976 12748368 19574336
17:05:10 4562 8192000000 10688848288 11067879424 1750727152 17.608 100 79 158 1 1786487712 13973792 21786768
17:05:22 4462 8192000000 10707969904 11082240000 1760194832 17.686 100 84 169 0 1797584784 14061712 23328240
17:05:34 4951 8192000000 10708508656 11086409728 1770915840 17.775 100 80 159 1 1806002464 12736448 22350176
17:05:45 3684 8192000000 10718201440 11099652096 1777684256 17.830 100 82 164 0 1813099824 12467520 22948048
17:05:55 4035 8192000000 10737351312 11115241472 1784825440 17.889 100 79 157 0 1819718240 12835008 22057792
17:06:07 2764 8192000000 10735707472 11122278400 1795529440 17.977 100 81 160 0 1830807824 12790672 22487712
17:06:18 2728 8192000000 10740375136 11124277248 1803558880 18.043 100 83 164 0 1839112352 12922832 22630640
17:06:27 2487 8192000000 10745326464 11130019840 1811197632 18.106 100 80 160 0 1846000640 13070688 21732320
17:06:36 5404 8192000000 10743139792 11133149184 1812061136 18.113 100 80 160 2 1847243536 13207328 21975072
17:06:48 2884 8192000000 10770679024 11156762624 1817920752 18.161 100 86 172 0 1855420144 13728992 23770400
17:06:58 2002 8192000000 10785769488 11171016704 1835938624 18.308 100 88 176 0 1874814224 14427424 24448176
17:07:06 2104 8192000000 10780461712 11170525184 1842895008 18.364 100 85 168 1 1880212624 13696224 23621392
17:07:15 1282 8192000000 10790010512 11175276544 1846292512 18.392 100 92 184 0 1885035616 13215328 25527776
17:07:22 2245 8192000000 10791410160 11182366720 1851185680 18.432 100 91 179 0 1889859920 13619552 25054688
17:07:31 1789 8192000000 10798307760 11184611328 1854978384 18.463 100 90 182 0 1894458992 13935936 25544672
17:07:39 1384 8192000000 10802031776 11190046720 1854868208 18.462 100 94 186 3 1894849104 13716704 26264192
17:07:47 1812 8192000000 10802300528 11194564608 1862974112 18.527 100 89 177 1 1900327168 13120736 24232320
17:07:55 1382 8192000000 10812783408 11198140416 1866709120 18.558 100 96 192 2 1906557600 13029600 26818880
17:08:04 1941 8192000000 10816910144 11202564096 1868092208 18.569 100 95 191 0 1909595056 14604688 26898160
17:08:12 2158 8192000000 10827114448 11217190912 1879583088 18.662 100 95 191 0 1921409616 14056800 27769728
17:08:20 2153 8192000000 10812860656 11213836288 1877054016 18.641 100 74 148 2 1911495936 14209392 20232528
17:08:30 1658 8192000000 10827646128 11216449536 1882544832 18.686 100 92 184 0 1920073504 11603088 25925584
17:08:37 6217 8192000000 10804040816 11215769600 1876821328 18.639 100 51 103 2 1903110304 11114496 15174480
17:08:50 30776 8192000000 10809487552 11218210816 1882778400 18.688 100 53 106 2 1904652800 5881648 15992752
17:09:28 17904 8192000000 10812037712 11221803008 1884348352 18.700 100 46 89 0 1905422512 8784320 12289840
17:09:52 8603 8192000000 10800447360 11227844608 1886825328 18.720 100 35 70 0 1905120128 8728480 9566320
17:10:08 8243 8192000000 10805939472 11226902528 1888915152 18.737 100 34 69 0 1905996864 7375520 9706192
17:10:27 5106 8192000000 10794860848 11227734016 1889003456 18.738 100 24 48 1 1903502816 7619264 6880096
17:10:39 9041 8192000000 10787222176 11227607040 1887539696 18.726 100 18 36 2 1898110608 5945840 4625072
17:10:54 8428 8192000000 10803598432 11234537472 1896348352 18.797 100 27 54 1 1913198512 7077952 9772208
17:11:10 9740 8192000000 10803276064 11237638144 1896778224 18.800 100 19 38 1 1908423504 6281008 5364272
17:11:26 7167 8192000000 10811505536 11243053056 1902986112 18.850 100 27 52 2 1916499136 5894544 7618480
17:11:41 10937 8192000000 10804839312 11241570304 1899796064 18.825 100 13 26 4 1909187664 5614720 3776880
17:11:58 9833 8192000000 10811761360 11244498944 1903166432 18.852 100 28 56 4 1917524320 6665152 7692736
17:12:15 8403 8192000000 10814930208 11246481408 1904623584 18.863 100 20 41 2 1915542496 5101072 5817840
17:12:34 8482 8192000000 10817761952 11254886400 1910313776 18.909 100 21 42 2 1922585744 6249184 6022784
17:12:53 10820 8192000000 10817623664 11255640064 1914830240 18.945 100 13 26 2 1923699824 5465120 3404464
17:13:12 13416 8192000000 10831057712 11263369216 1924145072 19.020 100 34 69 2 1939301216 6266480 8889664
17:13:42 60820 8192000000 10831758240 11269246976 1919336784 18.982 100 33 66 2 1934635408 5307184 9991440
17:14:56 11271 8192000000 10839569424 11271860224 1916340240 18.958 100 17 34 1 1926937040 5919776 4677024
17:15:15 11474 8192000000 10830122496 11273211904 1920535488 18.991 100 23 46 0 1933140784 5416224 7189072
17:15:33 7048 8192000000 10849615872 11276242944 1921129520 18.996 100 28 55 1 1934557456 5573008 7854928
17:15:47 6794 8192000000 10838596976 11276173312 1922753232 19.009 100 25 50 3 1936475120 5458480 8263408
17:16:03 7833 8192000000 10843506992 11279654912 1924422560 19.022 100 28 55 0 1939189184 7198656 7567968
17:16:19 5928 8192000000 10842765824 11282628608 1906639136 18.880 99 33 64 2 1925890464 10429664 8821664
17:16:32 12749 8192000000 10817457280 11262078976 1914201872 18.940 100 20 40 2 1925604912 5371168 6031872
17:16:51 4858 8192000000 10814969216 11243368448 1868531664 18.572 98 27 54 1 1882512224 6376800 7603760
17:17:03 7006 8192000000 10794817088 11230027776 1868183120 18.570 99 27 54 3 1881707760 5189056 8335584
17:17:19 9646 8192000000 10781204992 11208138752 1809559760 18.092 96 17 34 0 1819697776 5307776 4830240
17:17:39 12489 8192000000 10790288496 11211329536 1789188208 17.925 95 14 29 0 1798891328 5270960 4432160
17:18:04 11555 8192000000 10776261184 11205296128 1820551680 18.182 97 12 24 2 1829707600 5066784 4089136
17:18:22 12779 8192000000 10758125680 11183374336 1756163440 17.653 94 23 43 2 1768318208 4812512 7342256
17:18:41 64353 8192000000 10721727712 11144323072 1707932736 17.251 93 26 52 2 1720369152 4947712 7488704
17:19:52 10801 8192000000 10705949200 11123167232 1713699024 17.300 94 22 44 1 1726388720 5568080 7121616
17:20:11 7641 8192000000 10698793840 11110625280 1735833056 17.484 97 33 66 1 1751320240 6322704 9164480
17:20:27 5760 8192000000 10685063376 11100381184 1736305024 17.488 97 29 56 2 1750406592 5629584 8471984
17:20:41 5858 8192000000 10702801152 11106516992 1746168512 17.570 98 25 51 0 1758960688 5596976 7195200
17:20:54 5109 8192000000 10687483632 11105218560 1772807536 17.790 100 23 46 2 1789209200 9617184 6784480
17:21:08 7976 8192000000 10684937952 11097690112 1736253728 17.488 97 32 64 1 1752092864 6883072 8956064
17:21:23 5784 8192000000 10709498960 11111563264 1731962592 17.452 97 28 54 2 1744316976 4691104 7663280
17:21:36 5900 8192000000 10704576864 11119468544 1792412960 17.952 100 32 64 2 1807093696 5304336 9376400
17:21:53 6848 8192000000 10709229024 11125903360 1774076480 17.801 99 22 44 2 1786072672 5429632 6566560
17:22:07 7762 8192000000 10714128928 11136081920 1789242160 17.926 99 34 68 0 1805973440 6471616 10259664
17:22:21 10447 8192000000 10719431056 11145588736 1795817360 17.980 99 28 55 2 1809467408 5076416 8573632
17:22:38 7373 8192000000 10742303712 11158843392 1808064320 18.080 99 33 66 3 1823510832 5490000 9956512
17:22:54 13179 8192000000 10753119616 11177652224 1821449760 18.190 99 27 54 1 1835636992 6152784 8034448
17:23:14 5957 8192000000 10764111968 11183828992 1839773872 18.339 100 24 47 3 1852470624 5114272 7582480
17:23:28 28520 8192000000 10745274624 11181543424 1825748096 18.225 99 24 49 1 1839495008 5431104 8315808
17:24:31 27018 8192000000 10761290960 11189968896 1844814944 18.380 100 25 48 1 1857126832 5954576 6357312
17:25:04 12155 8192000000 10770315616 11201028096 1854340736 18.457 100 21 42 1 1870970720 11029088 5600896
17:25:23 5664 8192000000 10782174768 11201560576 1860970000 18.511 100 37 73 1 1879485328 5433184 13082144
17:25:40 9083 8192000000 10789893664 11210866688 1865710896 18.550 100 30 60 0 1880054096 5832976 8510224
17:25:56 11394 8192000000 10778826896 11207888896 1866534336 18.556 100 26 52 2 1880293712 5264064 8495312
17:26:17 5956 8192000000 10781460992 11214295040 1868788640 18.574 100 21 40 0 1881065056 6959520 5316896
17:26:30 8339 8192000000 10782828960 11217031168 1871199520 18.594 100 21 41 1 1882380144 5157072 6023552
17:26:45 5157 8192000000 10784112288 11216887808 1872893696 18.608 100 19 38 1 1884292512 5276800 6122016
17:27:00 13097 8192000000 10800441168 11231666176 1879050208 18.657 100 27 54 1 1892516096 5784704 7681184
17:27:20 12326 8192000000 10826900080 11247767552 1896242448 18.796 100 23 46 2 1908200496 5218736 6739312
17:27:48 30566 8192000000 10838208560 11264430080 1911849328 18.921 100 40 79 3 1929795632 6589712 11356592
17:28:31 31607 8192000000 10854133296 11278213120 1917173424 18.964 100 32 61 0 1933402816 8145408 8083984
17:29:14 17989 8192000000 10871291968 11298963456 1938920496 19.138 100 43 86 0 1964653616 13439552 12293568
17:29:40 8482 8192000000 10883628608 11306127360 1945548992 19.191 100 46 91 0 1970217968 11968112 12700864
17:29:56 71397 8192000000 10883797408 11314769920 1950756944 19.233 100 51 102 3 1980442720 14942368 14743408
17:31:14 31014 8192000000 10877932128 11318267904 1947384320 19.206 100 28 56 1 1974435568 18740880 8310368
17:31:53 16518 8192000000 10877778352 11320020992 1949473248 19.222 100 28 55 1 1970633056 13487952 7671856
17:32:26 14473 8192000000 10899668912 11332259840 1959885472 19.305 100 37 74 2 1986181520 15213920 11082128
17:33:01 21897 8192000000 10909687792 11345162240 1969091616 19.378 100 40 78 3 1996900016 16168544 11639856
17:33:30 14613 8192000000 10925393632 11350958080 1972957072 19.409 100 54 108 1 2009443632 20888704 15597856
17:33:53 12907 8192000000 10926204288 11354210304 1973573680 19.414 100 55 109 1 2009614720 19561184 16479856
17:34:20 26660 8192000000 10927293856 11362017280 1977526688 19.445 100 46 92 0 2009475136 18686688 13261760
17:34:54 2569 8192000000 10935877248 11353534464 1967291424 19.364 99 71 140 0 2006735600 18940512 20503664
17:35:05 5366 8192000000 10930302320 11356979200 1980018928 19.465 100 65 131 1 2019948016 20134848 19794240
17:35:22 10183 8192000000 10945323936 11371716608 1988546688 19.532 100 68 134 4 2031155568 22580592 20028288
17:35:41 18563 8192000000 10947523568 11376246784 1990579312 19.548 100 55 109 1 2029848080 23517568 15751200
17:36:09 11179 8192000000 10944737648 11372752896 1988396752 19.531 100 62 123 1 2030357760 23394848 18566160
17:36:30 4437 8192000000 10914898064 11335303168 1944342624 19.181 98 67 134 0 1988410544 24160624 19907296
17:36:41 10097 8192000000 10939341616 11360219136 1981033152 19.473 100 66 132 2 2023110720 22719424 19358144
17:36:58 2837 8192000000 10942380208 11366076416 1982147760 19.482 100 62 122 2 2021481408 21688272 17645376
17:37:09 25546 8192000000 10949657968 11382562816 1994466400 19.579 100 55 110 0 2038053136 27161424 16425312
17:37:41 3266 8192000000 10962787536 11377446912 1975597584 19.430 99 80 161 0 2027695712 27383904 24714224
17:37:55 7219 8192000000 10941492304 11367669760 1962966416 19.330 99 69 137 2 2012906752 28454016 21486320
17:38:11 9060 8192000000 10952346416 11374362624 1984951424 19.504 100 67 132 1 2034817520 29495152 20370944
17:38:27 2507 8192000000 10969687888 11388612608 1996836592 19.598 100 87 173 0 2053960384 31586144 25537648
17:38:36 1420 8192000000 10990587520 11404632064 2007462528 19.682 100 92 179 0 2066166352 31926896 26776928
17:38:45 6974 8192000000 10972154656 11395022848 1999380288 19.618 100 74 148 5 2053038608 31529648 22128672
17:39:00 9826 8192000000 10958641104 11390857216 1996515136 19.595 100 77 154 0 2052617216 32263728 23838352
17:39:20 4172 8192000000 10970818032 11398942720 2001601952 19.635 100 61 121 0 2053090032 32480416 19007664
17:39:33 2634 8192000000 10984919472 11403399168 2007537680 19.682 100 77 153 1 2063928992 32737360 23653952
17:39:44 2718 8192000000 10982671104 11407273984 2007003568 19.678 100 77 154 0 2062556336 32003264 23549504
17:39:54 8454 8192000000 10967871040 11396980736 1990584880 19.548 99 70 140 1 2045182448 32537680 22059888
17:40:09 1797 8192000000 10988513104 11413372928 2011857216 19.716 100 75 150 2 2066826320 33281232 21687872
17:40:18 7308 8192000000 10948824016 11379175424 1961934896 19.321 98 76 152 0 2020859056 35611936 23312224
17:40:32 2145 8192000000 10963143440 11387944960 1996865200 19.598 100 83 166 1 2054805648 31396304 26544144
17:40:43 5432 8192000000 10959390848 11381575680 1967014208 19.362 99 72 142 0 2021813696 32155168 22644320
17:40:59 2835 8192000000 10941535008 11357700096 1930445024 19.070 97 79 158 1 1987684448 32403536 24835888
17:41:09 5515 8192000000 10955073616 11378102272 1980289072 19.467 100 81 162 2 2039353504 33969152 25095280
17:41:21 3082 8192000000 10932373072 11354394624 1955019408 19.266 99 81 158 1 2012804560 33809904 23975248
17:41:32 5303 8192000000 10934420032 11347697664 1940440688 19.150 98 83 166 3 2004393248 37787984 26164576
17:41:48 6585 8192000000 10952975904 11375542272 1971469792 19.397 100 73 146 0 2029242416 35043952 22728672
17:42:01 10970 8192000000 10951193456 11380527104 1979153648 19.458 100 58 116 2 2032383904 35268832 17961424
17:42:24 9962 8192000000 10927906544 11359686656 1957317920 19.285 99 53 103 0 2007124608 33272672 16534016
17:42:42 8786 8192000000 10938545760 11372503040 1958054096 19.291 99 57 114 0 2012810368 36263904 18492368
17:43:00 12172 8192000000 10924011728 11354722304 1952698288 19.248 99 50 100 1 2004713616 35896896 16118432
17:43:23 5395 8192000000 10952150496 11380051968 1973038320 19.410 100 61 120 1 2030761472 39093344 18629808
17:43:38 3358 8192000000 10947637232 11377020928 1974478512 19.421 100 69 134 1 2039450816 44123680 20848624
17:43:50 4102 8192000000 10966799216 11393294336 1985840880 19.511 100 74 148 1 2051858048 42573120 23444048
17:44:06 3576 8192000000 10982636656 11403284480 1994194192 19.577 100 83 166 2 2065229152 45091104 25943856
17:44:18 989 8192000000 10985736624 11398897664 1982832768 19.487 99 89 178 1 2050925888 40409344 27683776
17:44:26 1779 8192000000 10966693984 11375300608 1971791728 19.400 99 88 174 1 2038485952 40486336 26207888
17:44:34 1577 8192000000 10973471984 11390394368 1987107488 19.521 100 87 174 1 2054659424 41281728 26270208
17:44:44 2157 8192000000 10972155504 11385212928 1981960864 19.480 100 83 167 0 2050160576 41361840 26837872
17:44:53 7578 8192000000 10947991200 11380482048 1959994160 19.306 99 65 130 2 2024212432 43555856 20662416
17:45:18 9355 8192000000 10919068304 11366899712 1947952944 19.210 99 43 86 0 2002304480 40352080 13999456
17:45:34 9172 8192000000 10913822240 11360747520 1956839696 19.281 100 32 64 2 2003665696 36199904 10626096
17:45:49 12186 8192000000 10909092576 11348021248 1923955808 19.019 98 38 75 1 1972965792 36987568 12022416
17:46:10 4884 8192000000 10934178480 11357364224 1954284736 19.261 100 53 106 1 2008336848 37795632 16256480
17:46:37 8970 8192000000 10895343408 11336200192 1923069040 19.011 99 36 72 0 1973979744 39274528 11636176
17:46:54 14127 8192000000 10897939936 11335786496 1903330144 18.853 98 31 62 1 1954869136 41223744 10315248
17:47:21 17989 8192000000 10907624272 11346046976 1934778400 19.105 100 36 72 1 1991236592 44270416 12187776
17:47:51 6574 8192000000 10894516432 11329900544 1910481984 18.911 99 42 84 1 1970932496 45915664 14534848
17:48:05 5463 8192000000 10920864768 11352334336 1935379824 19.110 100 46 90 0 1999247056 48420480 15446752
17:48:17 22565 8192000000 10878680912 11315101696 1895722640 18.792 98 37 75 1 1961836800 53235568 12878592
17:48:55 20570 8192000000 10901389536 11340406784 1913433792 18.934 99 31 61 0 1964397376 40626832 10336752
17:49:25 12203 8192000000 10893525232 11317866496 1916855536 18.962 99 33 65 2 1970013600 41729248 11428816
17:49:45 2001 8192000000 10926437248 11345235968 1942442736 19.166 100 78 156 0 2009027744 41978080 24606928
17:49:55 5407 8192000000 10924807424 11356098560 1947125776 19.204 100 54 108 2 2008745088 44775616 16843696
17:50:27 16766 8192000000 10914307312 11351756800 1938377744 19.134 100 35 70 1 1996642352 46321856 11942752
17:50:55 6652 8192000000 10899838672 11330945024 1911884096 18.922 99 33 64 0 1970575920 47384880 11306944
17:51:11 9668 8192000000 10915550288 11348729856 1932945712 19.090 100 41 80 1 1991605632 45392416 13267504
17:51:37 18210 8192000000 10903670944 11348783104 1933099424 19.092 100 38 76 2 1987595712 41245344 13250944
17:52:01 17861 8192000000 10894847584 11340939264 1917240896 18.965 99 29 58 2 1970337552 43125840 9970816
17:52:34 28791 8192000000 10882812720 11332358144 1913405504 18.934 100 18 36 1 1966074928 46045872 6623552
17:53:18 21631 8192000000 10882636656 11318784000 1883894240 18.697 99 26 52 1 1943183488 50163648 9125600
17:53:46 26586 8192000000 10874789552 11339259904 1907277824 18.885 100 21 42 1 1970386560 55230288 7878448
17:54:21 26283 8192000000 10866229024 11336224768 1908621440 18.896 100 12 24 0 1954615424 41695456 4298528
17:55:01 34129 8192000000 10855668528 11322548224 1894059456 18.778 99 18 36 1 1937079632 36843040 6177136
17:56:03 24332 8192000000 10863048832 11319234560 1925199520 19.028 100 19 36 0 1940994672 10630736 5164416
17:56:38 46510 8192000000 10857553184 11315130368 1909597008 18.903 99 26 48 0 1925161232 8103440 7460784
17:57:54 38508 8192000000 10888902416 11328233472 1913227952 18.933 98 11 23 1 1924225888 8370320 2627616
17:58:40 61155 8192000000 10891951056 11329507328 1932878400 19.090 99 30 58 5 1949714352 9122704 7713248
17:59:50 97473 8192000000 10890930896 11343507456 1956541552 19.279 100 41 82 1 1976528560 7906176 12080832
18:01:38 192453 8192000000 10917090288 11379163136 1954260384 19.260 99 25 50 1 1972613872 10461664 7891824
18:04:57 47391 8192000000 10922578688 11377602560 1986167680 19.514 100 21 42 0 2006846080 14235632 6442768
18:05:58 32178 8192000000 10909373360 11367153664 1970415600 19.389 99 21 42 0 1990916224 14509008 5991616
18:06:39 45124 8192000000 10918571952 11381264384 1988104528 19.529 100 20 40 1 2004393456 10593600 5695328
18:07:35 44265 8192000000 10894107952 11374075904 1963452720 19.333 99 12 24 1 1975533616 8854736 3226160
18:08:28 26201 8192000000 10887361248 11366641664 1963077552 19.330 99 9 18 1 1974164208 8776384 2310272
18:09:08 39983 8192000000 10904650304 11377152000 1984672112 19.502 100 10 20 0 1995685424 7709696 3303616
18:09:59 43725 8192000000 10916621056 11392389120 1994443840 19.579 100 19 37 2 2008700896 8849872 5407184
18:10:54 46317 8192000000 10910239024 11395313664 1992083936 19.560 100 8 16 0 2004528672 10106464 2338272
18:12:17 43564 8192000000 10918758208 11384729600 1994262096 19.577 100 27 55 0 2008951712 6833056 7856560
18:13:07 28344 8192000000 10919679504 11387109376 1995829888 19.590 100 34 69 3 2013584880 8503056 9251936
18:13:48 40823 8192000000 10903016240 11377876992 1978251584 19.451 99 15 31 2 1989601376 7394944 3954848
18:14:35 46238 8192000000 10896117488 11376328704 1967146928 19.363 99 20 40 0 1980122736 7043968 5931840
18:15:33 56984 8192000000 10908797744 11397611520 1973194656 19.411 99 11 22 0 1988221488 11879280 3147552
18:16:37 36851 8192000000 10911702480 11400609792 1985699360 19.510 100 4 8 0 2000737632 13828528 1209744
18:17:20 8323 8192000000 10905601104 11404816384 1986197408 19.514 100 4 8 0 2002455584 15015280 1242896
18:17:34 21943 8192000000 10903279744 11401543680 1981913600 19.480 100 5 10 0 1997329632 13907568 1508464
18:18:05 42406 8192000000 10897404416 11380080640 1933403392 19.094 97 14 28 2 1949359376 12149888 3806096
18:18:54 27857 8192000000 10907548736 11388211200 1953051792 19.251 99 5 10 0 1971649200 16832256 1765152
18:19:28 28079 8192000000 10922242032 11378708480 1956589408 19.279 99 19 39 1 1977370272 15622400 5158464
18:20:07 32753 8192000000 10917220128 11394928640 1986541712 19.516 100 30 58 0 2009263904 14362144 8360048
18:20:54 72698 8192000000 10882718960 11361751040 1883399904 18.693 95 10 20 0 1902043312 15549472 3093936
18:22:15 59915 8192000000 10903034128 11382194176 1936866384 19.122 98 16 32 0 1952602480 11043024 4693072
18:23:24 52765 8192000000 10899352880 11366260736 1947783392 19.209 99 12 24 0 1968865984 16861744 4220848
18:24:24 26569 8192000000 10906436192 11374936064 1949350304 19.221 99 23 46 0 1963614864 7637632 6626928
18:25:03 37476 8192000000 10910631680 11383619584 1976827072 19.440 100 20 40 2 1993341296 10861312 5652912
18:25:50 37218 8192000000 10937454304 11377057792 1940946384 19.154 98 43 86 1 1964850256 11294224 12609648
18:26:37 21388 8192000000 10917190880 11371724800 1953689248 19.256 99 50 97 1 1977436960 10482480 13265232
18:27:05 31486 8192000000 10878837904 11341275136 1903369744 18.853 97 27 54 0 1922255472 11573696 7312032
18:27:42 110454 8192000000 10840573664 11309101056 1769901104 17.766 90 14 28 0 1788213184 14961600 3350480
18:29:47 132693 8192000000 10820111856 11302191104 1816083856 18.146 94 28 55 1 1842765792 19192528 7489408
18:32:07 19558 8192000000 10822673312 11290316800 1873684336 18.614 98 18 36 1 1891565312 13460256 4420720
18:32:33 46762 8192000000 10814304048 11282640896 1855161040 18.464 97 16 32 0 1868934832 9101344 4672448
18:33:33 36626 8192000000 10802501504 11280683008 1867125744 18.561 98 2 4 0 1875873424 8331168 416512
18:35:17 85907 8192000000 10828889248 11299926016 1866927776 18.559 97 15 28 1 1877591856 7218192 3445888
18:37:04 60198 8192000000 10819834928 11284529152 1863802768 18.534 97 20 39 0 1879038576 9339120 5896688
18:38:13 71849 8192000000 10830153408 11292246016 1904374496 18.861 99 19 38 0 1922026480 11745872 5906112
18:39:40 55157 8192000000 10859000864 11332886528 1940927936 19.154 100 25 50 0 1956379984 8417248 7034800
18:40:42 46365 8192000000 10841936432 11317301248 1904407952 18.862 98 9 18 0 1914718320 7598128 2712240
18:41:34 75827 8192000000 10830939648 11310551040 1795076864 17.973 93 9 18 0 1805473760 8037760 2359136
18:43:02 43709 8192000000 10836672736 11296395264 1841515888 18.353 96 17 34 0 1859124016 12745168 4862960
18:43:52 67478 8192000000 10852813472 11324760064 1900985104 18.834 99 21 41 1 1922066368 14617488 6463776
18:45:09 62451 8192000000 10871815056 11337814016 1913698112 18.936 99 27 54 1 1937496912 15929664 7869136
18:46:21 46103 8192000000 10886347152 11351957504 1940330080 19.149 100 26 52 0 1963746400 16074480 7341840
18:47:18 51376 8192000000 10893181808 11348553728 1912956912 18.930 98 28 56 3 1938708592 18307936 7443744
18:48:19 28938 8192000000 10909441120 11370868736 1955130768 19.267 100 43 86 1 1989607920 22095056 12382096
18:48:56 43289 8192000000 10896486736 11379453952 1960465680 19.310 100 31 62 1 1987880528 18534960 8879888
18:50:06 94182 8192000000 10894595632 11374317568 1924863264 19.026 98 21 42 1 1946725792 16223728 5638800
18:51:50 24558 8192000000 10923413216 11380719616 1973530736 19.413 100 46 92 0 1997590048 10068816 13990496
18:52:24 73798 8192000000 10904057744 11388788736 1976596800 19.438 100 26 52 0 1999394432 15658224 7139408
18:53:44 56469 8192000000 10926732752 11380121600 1937637344 19.128 98 13 26 0 1952627008 11135104 3854560
18:54:47 18974 8192000000 10917950768 11373789184 1978100848 19.450 100 52 105 1 2004598688 11858832 14639008
18:55:12 106877 8192000000 10888776384 11358928896 1953881872 19.257 99 33 66 2 1974245248 10867376 9496000
18:57:07 11082 8192000000 10879358528 11346395136 1951942448 19.242 99 27 55 1 1966387712 7082016 7363248
18:57:25 42354 8192000000 10905345728 11375149056 1963303056 19.332 99 47 95 1 1986126640 9457856 13365728
18:58:19 47852 8192000000 10894025696 11375661056 1957482048 19.286 99 17 34 1 1973713200 11967552 4263600
19:00:24 68292 8192000000 10877373168 11361632256 1925416784 19.030 98 4 8 0 1937499472 11140688 942000
19:01:39 46821 8192000000 10902342352 11379773440 1970164896 19.387 100 21 39 3 1992478848 16747520 5566432
19:02:45 44612 8192000000 10912040448 11379691520 1959298992 19.300 99 11 22 0 1978072672 15759920 3013760
19:03:37 60190 8192000000 10922708528 11399290880 1984262896 19.498 100 28 55 2 2008051312 15426704 8361712
19:04:45 57762 8192000000 10908470112 11402866688 1973180416 19.411 99 18 36 0 1997030240 17749216 6100608
19:05:51 57554 8192000000 10918045120 11391934464 1950354384 19.229 98 19 38 1 1969373904 13911888 5107632
19:07:05 105774 8192000000 10908711968 11384279040 1919709296 18.985 97 11 22 0 1939228880 16657904 2861680
19:09:03 38739 8192000000 10913335472 11365474304 1924660896 19.024 97 38 73 4 1945050848 10298272 10091680
19:09:48 27319 8192000000 10897487472 11358089216 1926957648 19.043 98 36 72 1 1949353552 12498208 9897696
19:10:22 96893 8192000000 10905744624 11384152064 1945291568 19.189 99 21 42 0 1967061584 16546864 5223152
19:12:06 29791 8192000000 10898539168 11362324480 1917671200 18.968 97 31 58 3 1934667440 8712720 8283520
19:12:42 69873 8192000000 10844942736 11313651712 1802531264 18.035 92 15 28 1 1815553328 9591392 3430672
19:13:59 74136 8192000000 10876988432 11344441344 1895549456 18.790 97 22 44 1 1910626576 8903248 6173872
19:16:48 87758 8192000000 10872890000 11356925952 1920712336 18.993 98 20 40 0 1939605744 12521584 6371824
19:18:31 29600 8192000000 10854186784 11340259328 1890091664 18.747 97 23 44 3 1909844384 11967232 7785488
19:19:11 52526 8192000000 10861042032 11342127104 1923775408 19.017 99 12 24 0 1936944192 9832688 3336096
19:20:41 52183 8192000000 10876078832 11348209664 1913724000 18.937 98 9 18 0 1926749120 10895744 2129376
19:22:02 98403 8192000000 10871982368 11353640960 1901648640 18.840 98 11 22 0 1923030848 18097232 3284976
19:23:46 88744 8192000000 10873773024 11365363712 1941064176 19.155 100 18 36 0 1963686592 16963088 5659328
19:25:22 69637 8192000000 10864442624 11336671232 1891324768 18.756 97 13 25 1 1904210064 9538528 3346768
19:26:42 52232 8192000000 9991174144 10366259200 1086428400 11.709 56 16 32 2 1100896384 10317408 4150576

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-04-2021 19:28:56 to 03-04-2021 19:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 57 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-04-2021 19:29:28 to 03-04-2021 19:29:30.

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          239812
MON$OLDEST_ACTIVE               241076
MON$OLDEST_SNAPSHOT             241076
MON$NEXT_TRANSACTION            241076
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                       2034912
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.33435 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33435 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33435 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33435 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Apr  3 19:27:49 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

03.04.21 19:29:31. 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-03 19:29:34 No severe PSQL-related problems occured
03.04.21 19:29:35. End of report.