Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.11.2020 01: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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17030028 kB
MemAvailable 31467900 kB
Buffers 0 kB
Cached 14681676 kB
SwapCached 3456 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 2020-11-14 01:27:04
DTS_END                         2020-11-14 01:27:04.1300
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/39624
TRN_ID                          254896
ATT_ID                          721
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: 9602.64 19293 1152317
customer order: creation 188.28 321 22593
customer order: refuse 16.13 324 1936
order to supplier: creation 49.55 1219 5946
order to supplier: removal 3.53 88575 424
invoice (draft): creation 49.23 3198 5907
invoice (draft): removal 53.05 702 6366
invoice accept: apply 45.23 16122 5428
invoice accept: cancel 47.33 754 5679
customer reserve: creation 4178.28 159 501394
customer reserve: removal 4650.86 53 558103
realization accept: apply 93.73 176 11247
realization accept: cancel 85.23 96 10228
payment from customer: creation 65.42 109 7850
payment from customer: removal 6.18 71 742
payment to supplier: creation 53.93 119 6472
payment to supplier: removal 3.57 79 428
service: total inventory turnovers 5.21 1174 625
service: total monetary turnovers 7.08 48 850
service: aggregate perf. data 0.79 27137 95
service: refresh index statistics 0.03 245423 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-11-2020 01:28:42 to 14-11-2020 01:28:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14172
TEST_TIME 2 10964
TEST_TIME 3 8708
TEST_TIME 4 8441
TEST_TIME 5 7441
TEST_TIME 6 7064
TEST_TIME 7 7135
TEST_TIME 8 7610
TEST_TIME 9 7673
TEST_TIME 10 7796
TEST_TIME 11 7964
TEST_TIME 12 7760
TEST_TIME 13 7589
TEST_TIME 14 8091
TEST_TIME 15 8634
TEST_TIME 16 9063
TEST_TIME 17 9347
TEST_TIME 18 9603
TEST_TIME 19 9640
TEST_TIME 20 9841
TEST_TIME 21 9751
TEST_TIME 22 10248
TEST_TIME 23 10468
TEST_TIME 24 10970
TEST_TIME 25 11066
TEST_TIME 26 11318
TEST_TIME 27 11176
TEST_TIME 28 11141
TEST_TIME 29 11457
TEST_TIME 30 11655
TEST_TIME 31 11419
TEST_TIME 32 11366
TEST_TIME 33 11261
TEST_TIME 34 11175
TEST_TIME 35 11080
TEST_TIME 36 10888
TEST_TIME 37 10936
TEST_TIME 38 10971
TEST_TIME 39 10978
TEST_TIME 40 10891
TEST_TIME 41 10801
TEST_TIME 42 10615
TEST_TIME 43 10439
TEST_TIME 44 10444
TEST_TIME 45 10548
TEST_TIME 46 10394
TEST_TIME 47 10293
TEST_TIME 48 10207
TEST_TIME 49 10081
TEST_TIME 50 10002
TEST_TIME 51 10157
TEST_TIME 52 10166
TEST_TIME 53 10233
TEST_TIME 54 10213
TEST_TIME 55 10153
TEST_TIME 56 10062
TEST_TIME 57 10001
TEST_TIME 58 9902
TEST_TIME 59 9837
TEST_TIME 60 9757
TEST_TIME 61 9685
TEST_TIME 62 9761
TEST_TIME 63 9745
TEST_TIME 64 9893
TEST_TIME 65 9917
TEST_TIME 66 9933
TEST_TIME 67 10033
TEST_TIME 68 10058
TEST_TIME 69 10025
TEST_TIME 70 10036
TEST_TIME 71 10043
TEST_TIME 72 10113
TEST_TIME 73 10114
TEST_TIME 74 10066
TEST_TIME 75 9995
TEST_TIME 76 9932
TEST_TIME 77 9930
TEST_TIME 78 9922
TEST_TIME 79 9869
TEST_TIME 80 9804
TEST_TIME 81 9795
TEST_TIME 82 9772
TEST_TIME 83 9765
TEST_TIME 84 9767
TEST_TIME 85 9779
TEST_TIME 86 9804
TEST_TIME 87 9805
TEST_TIME 88 9813
TEST_TIME 89 9863
TEST_TIME 90 9881
TEST_TIME 91 9868
TEST_TIME 92 9898
TEST_TIME 93 9949
TEST_TIME 94 9850
TEST_TIME 95 9770
TEST_TIME 96 9882
TEST_TIME 97 9824
TEST_TIME 98 9826
TEST_TIME 99 9788
TEST_TIME 100 9749
TEST_TIME 101 9749
TEST_TIME 102 9723
TEST_TIME 103 9749
TEST_TIME 104 9725
TEST_TIME 105 9754
TEST_TIME 106 9755
TEST_TIME 107 9795
TEST_TIME 108 9766
TEST_TIME 109 9793
TEST_TIME 110 9804
TEST_TIME 111 9769
TEST_TIME 112 9815
TEST_TIME 113 9815
TEST_TIME 114 9755
TEST_TIME 115 9724
TEST_TIME 116 9670
TEST_TIME 117 9674
TEST_TIME 118 9724
TEST_TIME 119 9682
TEST_TIME 120 9603

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-11-2020 01:28:45 to 14-11-2020 01: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 1615891 1615891 0 0.00 0 18202 6 0 0
doc_list_biud 1615890 1615890 0 0.00 0 45886 24 0 0
sp_add_invoice_to_stock 5551 5428 123 2.21 51 147418 16123 0 123
sp_cancel_adding_invoice 5679 5679 0 0.00 5 67045 754 0 0
sp_cancel_client_order 1936 1936 0 0.00 4 14248 324 0 0
sp_cancel_customer_reserve 558103 558103 0 0.00 1 45888 53 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 2 6843 72 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 5899 80 0 0
sp_cancel_supplier_invoice 6378 6366 12 0.18 2 18916 703 0 12
sp_cancel_supplier_order 424 424 0 0.00 8 1049024 88576 0 0
sp_cancel_write_off 10228 10228 0 0.00 1 20272 96 0 0
sp_client_order 22593 22593 0 0.00 4 60648 321 0 0
sp_customer_reserve 501394 501394 0 0.00 0 120889 159 0 0
sp_fill_shopping_cart 34443 34443 0 0.00 1 12566 34 0 0
sp_fill_shopping_cart_clo_res 501392 501392 0 0.00 0 14725 11 0 0
sp_get_clo_for_invoice 5426 5426 0 0.00 0 18322 227 0 0
sp_kill_cost_storno 17077 17077 0 0.00 0 6179 50 0 0
sp_kill_qstorno_ret_qs2qd 1133224 1133224 0 0.00 0 45884 29 0 0
sp_kill_qty_storno 599409 599409 0 0.00 0 45886 63 0 0
sp_lock_selected_doc 22901 22901 0 0.00 0 8338 4 0 0
sp_make_cost_storno 30995 30995 0 0.00 0 10352 48 0 0
sp_multiply_rows_for_pdistr 30995 30995 0 0.00 0 9703 26 0 0
sp_multiply_rows_for_qdistr 22593 22593 0 0.00 0 10627 133 0 0
sp_pay_from_customer 7850 7850 0 0.00 4 12087 109 0 0
sp_pay_to_supplier 6472 6472 0 0.00 4 9984 120 0 0
sp_payment_common 14322 14322 0 0.00 1 12081 26 0 0
sp_qd_handle_on_cancel_clo 1936 1936 0 0.00 0 14230 296 0 0
sp_qd_handle_on_invoice_upd_sts 11105 11105 0 0.00 0 25671 327 0 0
sp_qd_handle_on_reserve_upd_sts 11247 11247 0 0.00 0 27744 71 0 0
sp_reserve_write_off 11247 11247 0 0.00 6 27787 177 0 0
sp_supplier_invoice 5907 5907 0 0.00 6 69874 3198 0 0
sp_supplier_order 5946 5946 0 0.00 5 33241 1219 0 0
srv_aggregate_perf_data 96 95 1 1.04 1854 881472 27138 0 1
srv_fill_mon_cache_memory 169 169 0 0.00 819 168954 30705 0 0
srv_find_qd_qs_mism 1099906 1099906 0 0.00 0 18201 5 0 0
srv_make_invnt_saldo 625 625 0 0.00 28 81706 1175 0 0
srv_make_money_saldo 850 850 0 0.00 1 11048 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 69882 352066 245423 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 5429 5429 0 0.00 0 5390 142 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 0 3537 75 0 0
t$perf-norm:sp_cancel_client_order 1936 1936 0 0.00 0 2866 16 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 9120 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 717 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 1434 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 601 9 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 28982 1659 0 0
t$perf-norm:sp_cancel_write_off 1087 1087 0 0.00 0 3345 7 0 0
t$perf-norm:sp_client_order 22593 22593 0 0.00 0 12351 17 0 0
t$perf-norm:sp_customer_reserve 1017 1017 0 0.00 0 3086 9 0 0
t$perf-norm:sp_pay_from_customer 7850 7850 0 0.00 0 7765 11 0 0
t$perf-norm:sp_pay_to_supplier 6472 6472 0 0.00 0 7091 11 0 0
t$perf-norm:sp_reserve_write_off 11247 11247 0 0.00 0 9116 11 0 0
t$perf-norm:sp_supplier_invoice 5907 5907 0 0.00 0 6913 17 0 0
t$perf-norm:sp_supplier_order 5946 5946 0 0.00 0 2562 14 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 312 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 6876 60 0 0
t$perf-norm:srv_make_invnt_saldo 625 625 0 0.00 0 1224 21 0 0
t$perf-norm:srv_make_money_saldo 850 850 0 0.00 0 1312 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 11098 10852 246 2.21 0 6734 18 0 246
v_all_customers 40906 40906 0 0.00 0 19 1 0 0
v_all_suppliers 33092 33092 0 0.00 0 106 1 0 0
v_all_wares 45186 45186 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 133 5 0 0
v_cancel_client_order 3872 3872 0 0.00 0 5852 6 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 6792 10 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 1128 5 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 5855 16 0 0
v_cancel_supplier_invoice 852 828 24 2.81 0 5825 23 0 24
v_cancel_supplier_order 848 848 0 0.00 0 2622 7 0 0
v_cancel_write_off 2174 2174 0 0.00 0 5362 17 0 0
v_max_id_clo_ord 5946 5946 0 0.00 0 324 1 0 0
v_max_id_clo_res 1017 1017 0 0.00 0 2180 12 0 0
v_max_id_ord_sup 5904 5904 0 0.00 0 1258 2 0 0
v_max_non_paid_invoice 1776 1776 0 0.00 0 2809 6 0 0
v_max_non_paid_realizn 4347 4347 0 0.00 0 12073 9 0 0
v_min_id_clo_ord 5946 5946 0 0.00 0 4512 6 0 0
v_min_id_clo_res 1017 1017 0 0.00 0 4628 9 0 0
v_min_id_ord_sup 5904 5904 0 0.00 0 3792 4 0 0
v_min_non_paid_invoice 6472 6472 0 0.00 0 8257 16 0 0
v_min_non_paid_realizn 7850 7850 0 0.00 0 6724 14 0 0
v_our_firm 11286 11286 0 0.00 0 13 1 0 0
v_reserve_write_off 22494 22494 0 0.00 0 6105 6 0 0
x_lock_depdocs_on_canc_invoice 11631 11631 0 0.00 0 29809 100 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 15975 384 0 0
x_make_qstorno_1000_1200 5946 5946 0 0.00 2 33234 1140 0 0
x_make_qstorno_1200_2000 5907 5907 0 0.00 2 66554 3084 0 0
x_make_qstorno_2100_3300 501394 501394 0 0.00 0 120888 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2020 01:28:50 to 14-11-2020 01: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
22:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 11639 8192000000 10213170880 10521530368 818108960 9.079 67 49 100 0 837416384 2286240 17021184
22:57:33 20999 8192000000 10342025968 10658930688 1387520480 14.484 100 88 176 0 1420485232 4287072 28677680
22:58:02 42358 8192000000 10397500080 10720354304 1440644032 14.955 100 91 182 0 1475570672 6124144 28802496
22:58:51 7772 8192000000 10409815168 10737221632 1468241344 15.198 100 89 178 1 1504265568 7400976 28623248
22:59:09 18995 8192000000 10425103408 10756521984 1480227120 15.303 100 86 172 0 1515362176 7746848 27388208
22:59:37 22526 8192000000 10449952672 10782912512 1500168176 15.478 100 91 183 0 1537282032 8165552 28948304
23:00:08 17206 8192000000 10466370384 10802274304 1516936720 15.624 100 89 178 0 1553606688 8945920 27724048
23:00:39 23180 8192000000 10482015488 10822447104 1536100784 15.790 100 91 182 1 1574174736 10054304 28019648
23:01:16 16347 8192000000 10504970336 10851692544 1560068640 15.997 100 89 179 0 1602272528 15021344 27182544
23:01:43 24253 8192000000 10532178336 10887159808 1583745376 16.200 100 77 154 3 1618402640 11418192 23239072
23:02:17 12698 8192000000 10560573312 10915491840 1612615376 16.447 100 83 165 1 1648555904 11083456 24857072
23:02:39 15144 8192000000 10575844640 10937495552 1630649232 16.600 100 77 154 1 1665182832 11455072 23078528
23:03:02 8693 8192000000 10593069120 10962337792 1651940368 16.781 100 76 152 2 1686093392 12110192 22042832
23:03:18 10570 8192000000 10619290336 10988924928 1679311248 17.012 100 80 160 0 1714811520 11791584 23708688
23:03:39 8725 8192000000 10651510912 11024416768 1705584288 17.232 100 72 144 1 1737874976 11430656 20860032
23:03:55 7668 8192000000 10671464800 11041189888 1724763968 17.392 100 81 162 1 1760764384 12355696 23644720
23:04:10 8918 8192000000 10680352192 11054727168 1742230192 17.537 100 86 172 1 1780004448 13284448 24489808
23:04:26 4740 8192000000 10686828032 11062611968 1749340272 17.596 100 86 172 1 1786728048 13321968 24065808
23:04:37 4519 8192000000 10691265328 11075280896 1756524560 17.656 100 80 161 1 1792225792 13077440 22623792
23:04:48 5623 8192000000 10707382256 11086696448 1765074256 17.726 100 88 175 2 1803720864 13329744 25316864
23:05:01 3099 8192000000 10706306752 11088113664 1769834576 17.766 100 77 153 1 1804260352 12616064 21809712
23:05:12 3724 8192000000 10724257040 11099127808 1782970224 17.874 100 88 173 4 1820321872 13087040 24264608
23:05:23 4409 8192000000 10721762848 11110248448 1796291296 17.983 100 81 162 1 1832913648 13648080 22974272
23:05:33 2523 8192000000 10735054432 11118895104 1798285456 18.000 100 83 166 2 1835050912 13885616 22879840
23:05:42 2682 8192000000 10743806928 11126382592 1807475808 18.075 100 95 190 3 1849019088 14621232 26922048
23:05:52 2289 8192000000 10757988448 11139510272 1813333072 18.123 100 91 183 0 1854172432 15035456 25803904
23:06:00 7892 8192000000 10755883456 11139629056 1817135360 18.154 100 82 163 0 1853187872 13427920 22624592
23:06:15 5994 8192000000 10768155200 11154993152 1819533216 18.174 100 91 179 2 1858329264 14561952 24234096
23:06:27 2601 8192000000 10773456400 11160866816 1832070720 18.276 100 80 161 0 1869055376 13776576 23208080
23:06:37 1764 8192000000 10785522224 11171876864 1841785104 18.355 100 87 174 3 1879752864 13381776 24585984
23:06:45 2281 8192000000 10792617632 11177807872 1843062928 18.366 100 93 186 2 1882481536 12434064 26984544
23:06:53 1801 8192000000 10794871728 11180146688 1843749344 18.371 100 89 178 0 1881728352 13009056 24969952
23:07:02 1929 8192000000 10790116512 11178659840 1848982944 18.414 100 93 186 1 1888975152 13760784 26231424
23:07:10 1790 8192000000 10788015264 11175206912 1849918576 18.421 100 88 175 1 1888018640 12587488 25512576
23:07:18 2147 8192000000 10789913584 11178274816 1849278944 18.416 100 89 178 2 1888215280 13502320 25434016
23:07:26 1435 8192000000 10802433600 11191189504 1854318896 18.457 100 94 189 0 1894220272 13025392 26875984
23:07:34 1652 8192000000 10802141072 11190005760 1856853200 18.478 100 88 177 1 1895733776 12913136 25967440
23:07:42 1852 8192000000 10807027216 11195314176 1861530704 18.516 100 88 176 2 1899279536 12388368 25360464
23:07:50 1596 8192000000 10812418144 11203870720 1871306336 18.595 100 94 187 1 1910443984 12507136 26630512
23:07:58 1825 8192000000 10819679504 11210043392 1875921840 18.632 100 93 186 2 1914072944 12164928 25986176
23:08:07 2397 8192000000 10817130784 11210489856 1875594272 18.630 100 90 180 1 1913822208 12891856 25336080
23:08:16 9573 8192000000 10818307728 11210895360 1876546512 18.637 100 81 161 1 1912527888 13616272 22365104
23:08:33 1563 8192000000 10824578112 11218362368 1881926432 18.681 100 91 182 3 1922421824 14370016 26125376
23:08:40 13222 8192000000 10813356480 11217616896 1877553984 18.645 100 62 125 0 1905645920 10340736 17751200
23:09:01 4117 8192000000 10806938416 11218112512 1881042208 18.674 100 58 116 0 1907929072 10582912 16303952
23:09:15 4034 8192000000 10790722400 11215118336 1882805872 18.688 100 46 92 1 1904794688 8456336 13532480
23:09:27 6246 8192000000 10803473840 11223977984 1886716352 18.719 100 46 92 2 1907820816 8624720 12479744
23:09:41 3899 8192000000 10813032256 11223584768 1888732640 18.736 100 46 92 1 1910909792 8077328 14099824
23:09:53 5283 8192000000 10793265104 11221790720 1885562608 18.710 100 29 58 0 1901702176 6861456 9278112
23:10:07 4591 8192000000 10792922688 11219243008 1886183536 18.715 100 25 52 0 1899880192 6255328 7441328
23:10:20 8455 8192000000 10797525152 11224670208 1886505584 18.718 100 24 48 0 1899869344 6755776 6607984
23:10:35 9238 8192000000 10787980448 11223232512 1888592464 18.734 100 22 44 1 1900851232 6268144 5990624
23:10:53 7820 8192000000 10794082000 11228749824 1889344608 18.740 100 21 41 1 1901330000 6431776 5553616
23:11:08 6763 8192000000 10804199728 11231973376 1891646288 18.759 100 19 38 2 1907271232 9929072 5695872
23:11:25 9186 8192000000 10793174560 11231391744 1892530656 18.766 100 20 39 1 1906161872 6483472 7147744
23:11:42 8780 8192000000 10809799648 11237978112 1899380096 18.821 100 24 46 3 1913065200 6171168 7513936
23:11:58 80773 8192000000 10826868384 11258245120 1904383632 18.862 100 29 58 0 1918068256 5854928 7829696
23:13:25 9815 8192000000 10810925872 11254239232 1904329280 18.861 100 18 36 2 1915801664 6388640 5083744
23:13:42 5470 8192000000 10823566784 11255463936 1905872960 18.874 100 26 52 0 1919711328 5864000 7974368
23:13:56 3258 8192000000 10833723552 11262537728 1909896048 18.906 100 40 80 0 1928412416 7529072 10987296
23:14:05 4211 8192000000 10837355488 11264794624 1912371984 18.926 100 36 72 2 1929331392 7017088 9942320
23:14:16 8056 8192000000 10822898368 11262148608 1910847488 18.913 100 24 48 2 1924260912 6988560 6424864
23:14:31 6950 8192000000 10821872800 11257733120 1903496288 18.854 100 19 38 2 1914898048 6434032 4967728
23:14:44 7138 8192000000 10814978064 11254546432 1903740240 18.856 100 27 54 1 1917873984 6599392 7534352
23:14:58 5713 8192000000 10826546208 11261333504 1909640112 18.904 100 22 44 4 1921168048 5196352 6331584
23:15:11 3682 8192000000 10819360592 11247030272 1880489600 18.669 99 34 66 1 1895604624 5458832 9656192
23:15:23 8326 8192000000 10827843184 11255021568 1903584176 18.855 100 31 63 0 1918355568 5039856 9731536
23:15:39 8133 8192000000 10822050144 11258490880 1901268640 18.836 100 12 24 1 1914318544 9823744 3226160
23:15:55 7978 8192000000 10818207936 11252441088 1887717232 18.727 99 20 40 1 1899779136 6352944 5708960
23:16:10 10574 8192000000 10810623456 11250630656 1875476416 18.629 98 21 41 1 1886798512 5346064 5976032
23:16:26 68989 8192000000 10776048064 11208916992 1758600256 17.673 92 37 74 3 1775016656 5102912 11313488
23:17:42 11929 8192000000 10760338736 11186876416 1801825136 18.029 96 16 30 2 1811491104 5555872 4110096
23:18:02 8882 8192000000 10786154640 11211964416 1825489056 18.223 97 33 65 2 1841428416 6896512 9042848
23:18:18 5943 8192000000 10778230656 11208650752 1840527936 18.345 98 32 62 1 1856189808 6538320 9123552
23:18:30 6958 8192000000 10762532976 11185610752 1807283248 18.074 97 20 40 0 1818567152 5440496 5843408
23:18:46 6902 8192000000 10744987760 11172442112 1810544096 18.100 98 39 76 2 1828182384 5757504 11880784
23:18:59 3032 8192000000 10730005104 11150041088 1801521936 18.026 99 31 62 1 1817415600 6730544 9163120
23:19:11 3438 8192000000 10728313968 11147120640 1778363360 17.836 97 31 62 2 1794089680 5289712 10436608
23:19:27 11808 8192000000 10670561536 11081306112 1660036000 16.849 91 19 38 1 1670481440 4996064 5449376
23:19:46 6209 8192000000 10685945168 11098263552 1728754416 17.425 97 26 51 1 1741876464 5987680 7134368
23:19:59 9032 8192000000 10658699120 11072139264 1693669584 17.132 95 30 59 1 1708314112 6055696 8588832
23:20:14 7888 8192000000 10673380032 11082256384 1734306912 17.471 98 26 52 4 1747415104 4955392 8152800
23:20:32 10899 8192000000 10671319344 11081797632 1694123072 17.136 95 24 48 2 1710660272 9504976 7032224
23:20:50 58395 8192000000 10711447680 11104677888 1714826992 17.309 96 35 68 4 1730272896 5572080 9873824
23:21:57 17600 8192000000 10710991152 11122851840 1777128608 17.826 99 30 60 3 1791207680 4832720 9246352
23:22:25 8232 8192000000 10720026656 11140841472 1792181392 17.950 99 22 44 0 1808272480 10148416 5942672
23:22:42 5023 8192000000 10735664960 11155124224 1819284496 18.172 100 36 72 3 1835153760 5721056 10148208
23:22:54 4740 8192000000 10734373648 11157053440 1811582528 18.109 99 42 84 3 1830961120 6302736 13075856
23:23:06 13080 8192000000 10735596336 11165573120 1828468496 18.247 100 27 54 2 1842718000 6718432 7531072
23:23:26 5919 8192000000 10759749552 11180908544 1834116576 18.293 100 31 62 5 1853089504 10133216 8839712
23:23:40 9897 8192000000 10752466048 11178819584 1836844240 18.315 100 22 44 1 1848269280 5404688 6020352
23:23:57 6544 8192000000 10750567504 11179294720 1839214208 18.334 100 18 35 3 1853333072 9144592 4974272
23:24:14 12463 8192000000 10756910144 11186425856 1843771648 18.371 100 16 32 0 1854249872 5779424 4698800
23:24:32 14789 8192000000 10761616208 11189207040 1849132640 18.415 100 13 26 0 1858020080 5178192 3709248
23:24:54 7869 8192000000 10776385056 11197190144 1854315280 18.457 100 19 38 2 1864950064 5534432 5100352
23:25:08 9789 8192000000 10770767376 11198648320 1854552272 18.459 100 16 32 1 1865408080 6152320 4703488
23:25:24 14303 8192000000 10767686432 11202056192 1855985680 18.471 100 13 25 1 1865301536 5588064 3727792
23:25:45 65975 8192000000 10782655376 11211067392 1866833968 18.559 100 26 51 0 1878685152 4688720 7162464
23:27:01 31300 8192000000 10808786640 11229859840 1879031344 18.657 100 35 68 1 1897310192 8486448 9792400
23:27:41 2348 8192000000 10836343216 11250872320 1900879888 18.833 100 60 119 4 1926665024 8091728 17693408
23:27:51 2581 8192000000 10855254800 11265069056 1914142096 18.940 100 73 146 0 1944473552 10790448 19541008
23:28:02 3328 8192000000 10852415456 11267485696 1915906400 18.954 100 57 114 0 1943504560 12010576 15587584
23:28:13 1780 8192000000 10865859968 11272175616 1920340496 18.990 100 69 138 3 1951837360 11300720 20196144
23:28:22 2182 8192000000 10879764768 11290034176 1931412112 19.078 100 78 156 3 1966756432 13576928 21767392
23:28:30 2730 8192000000 10878667952 11292065792 1938222256 19.133 100 79 156 1 1974972336 13932944 22817136
23:28:44 13021 8192000000 10874656752 11298177024 1935599488 19.112 100 63 127 3 1966781488 13392416 17789584
23:29:07 1981 8192000000 10882539424 11293265920 1934756432 19.105 100 62 124 1 1965585792 13353744 17475616
23:29:18 5109 8192000000 10884230976 11301539840 1940655824 19.152 100 64 128 1 1971844784 12588992 18599968
23:29:30 23926 8192000000 10874393616 11297083392 1946724112 19.200 100 57 114 0 1976904304 13237584 16942608
23:30:07 10840 8192000000 10891173344 11301609472 1944930768 19.186 100 56 110 2 1972792528 12023024 15838736
23:30:26 9159 8192000000 10889753840 11310592000 1949564624 19.223 100 57 114 2 1978773312 13262720 15945968
23:30:54 26304 8192000000 10888289584 11314536448 1937404176 19.126 99 55 108 2 1967131808 14510256 15217376
23:31:27 22121 8192000000 10875698672 11316457472 1954416896 19.262 100 48 95 2 1981333200 12767632 14148672
23:32:02 17308 8192000000 10884775968 11320958976 1941286384 19.157 99 29 59 0 1962412224 12718080 8407760
23:32:36 16221 8192000000 10894348912 11321184256 1944031328 19.179 99 49 96 3 1973337088 15177696 14128064
23:33:01 6828 8192000000 10890884128 11322724352 1956975584 19.282 100 42 84 1 1984676544 15359488 12341472
23:33:19 3383 8192000000 10908141920 11327930368 1959593248 19.303 100 65 131 1 1995609632 16065120 19951264
23:33:30 12396 8192000000 10894006464 11313401856 1932776848 19.089 99 54 108 0 1966188896 17675872 15736176
23:33:49 7813 8192000000 10904791392 11323383808 1951466224 19.238 100 57 110 3 1986744480 18986816 16291440
23:34:07 5723 8192000000 10890773392 11316535296 1949459392 19.222 100 51 102 5 1983844704 19115632 15269680
23:34:25 6435 8192000000 10908069792 11330699264 1959035024 19.298 100 50 98 1 1992200560 18129696 15035840
23:34:40 12211 8192000000 10906900208 11340517376 1966108752 19.355 100 57 112 0 2001740368 18716960 16914656
23:35:00 4063 8192000000 10921270112 11330113536 1954609024 19.263 99 67 133 0 1994223840 19580512 20034304
23:35:14 2357 8192000000 10917181840 11334692864 1965663952 19.351 100 80 158 3 2007442416 18244640 23533824
23:35:24 2465 8192000000 10927575328 11339669504 1957804000 19.289 99 83 169 3 2002033040 18873680 25355360
23:35:33 3945 8192000000 10934169872 11349069824 1977067952 19.441 100 76 150 0 2020415808 20817536 22530320
23:35:44 4064 8192000000 10924137776 11347816448 1976583472 19.438 100 65 130 0 2017523840 21384864 19555504
23:35:58 3545 8192000000 10934376368 11355164672 1977694704 19.446 100 66 131 0 2018773888 20717744 20361440
23:36:09 11670 8192000000 10928358448 11353526272 1976718656 19.439 100 59 118 0 2016392560 21847200 17826704
23:36:28 4996 8192000000 10914173312 11337080832 1951545792 19.239 99 66 127 2 1990649296 20305920 18797584
23:36:40 11302 8192000000 10908337696 11329970176 1947693904 19.208 99 63 126 0 1988443360 21691584 19057872
23:36:59 8823 8192000000 10903955808 11335888896 1945675792 19.192 99 49 98 1 1981525888 21433152 14416944
23:37:22 8836 8192000000 10911068224 11327840256 1945938832 19.194 99 58 113 2 1984314704 21026272 17349600
23:37:38 4956 8192000000 10921014272 11343302656 1964673360 19.343 100 65 129 0 2006255024 22310080 19271584
23:37:49 4602 8192000000 10930096896 11348729856 1966315456 19.356 100 79 156 1 2016227184 26459008 23452720
23:38:03 5400 8192000000 10936582768 11357495296 1971940784 19.401 100 70 140 1 2021660944 28169584 21550576
23:38:15 8067 8192000000 10921302096 11342602240 1957492880 19.286 99 73 145 1 2006290528 26625888 22171760
23:38:36 8421 8192000000 10920460304 11341611008 1949553120 19.223 99 70 140 1 1996050432 25727456 20769856
23:39:02 8849 8192000000 10913629872 11334660096 1942094288 19.163 99 68 134 2 1987213776 24912752 20206736
23:39:28 5518 8192000000 10908904928 11334836224 1954732144 19.264 100 53 106 0 1996248608 25007632 16508832
23:39:43 7005 8192000000 10911180624 11337216000 1952628608 19.247 100 56 110 1 1997004960 27041984 17334368
23:39:57 7161 8192000000 10933894880 11347476480 1961908512 19.321 100 65 128 0 2008630080 28151648 18569920
23:40:14 1909 8192000000 10936406304 11360550912 1972081728 19.402 100 60 119 2 2019734192 29634640 18017824
23:40:23 2162 8192000000 10948928256 11363721216 1976112656 19.434 100 75 150 0 2030813200 30628464 24072080
23:40:35 4050 8192000000 10947880032 11359072256 1957662016 19.287 99 79 157 2 2014554880 33405600 23487264
23:40:46 7267 8192000000 10937508688 11355262976 1950495760 19.230 99 72 143 2 2006959952 34788896 21675296
23:41:00 4300 8192000000 10944474064 11361705984 1967266848 19.364 100 70 140 2 2026132032 37469328 21395856
23:41:13 6163 8192000000 10931112576 11347353600 1958114896 19.291 100 69 137 1 2011944416 32923536 20905984
23:41:32 9878 8192000000 10921370288 11342802944 1953206816 19.252 100 70 140 2 2013213616 37645984 22360816
23:41:49 4856 8192000000 10912578688 11328135168 1924047760 19.019 99 68 135 2 1981285504 35833872 21403872
23:42:01 2933 8192000000 10885286160 11298824192 1907119664 18.884 99 71 143 0 1966397472 36972944 22304864
23:42:11 3355 8192000000 10903011952 11320930304 1929536336 19.063 100 67 132 8 1984869408 34419136 20913936
23:42:27 4836 8192000000 10900047728 11315941376 1931611296 19.080 100 62 124 1 1981620864 31151600 18857968
23:42:40 2426 8192000000 10909170896 11317723136 1928271680 19.053 99 81 159 1 1983859456 30215392 25372384
23:42:53 2140 8192000000 10897598880 11306016768 1907532592 18.887 98 87 173 3 1966332144 32066640 26732912
23:43:04 1898 8192000000 10920401952 11330359296 1941318304 19.157 100 71 138 1 1995854144 32504736 22031104
23:43:13 6512 8192000000 10902555424 11320377344 1933647520 19.096 100 62 124 0 1983869504 30562304 19659680
23:43:27 2671 8192000000 10876787520 11286290432 1910060352 18.907 100 75 150 1 1961531136 28074400 23396384
23:43:37 4380 8192000000 10890918448 11297337344 1906744368 18.881 99 78 153 1 1957498688 27855216 22899104
23:43:48 1715 8192000000 10914117296 11313422336 1936880672 19.122 100 95 191 2 1992830704 27340672 28609360
23:43:58 3481 8192000000 10920385040 11318575104 1937586176 19.127 100 86 170 0 1992842128 29733744 25522208
23:44:09 1154 8192000000 10923304048 11326783488 1945343472 19.189 100 90 181 0 2002821152 30511376 26966304
23:44:17 816 8192000000 10928282240 11328004096 1945226560 19.188 100 93 184 0 2004803520 31495152 28081808
23:44:24 1543 8192000000 10913625984 11313393664 1929860352 19.066 99 88 177 2 1988935936 31661936 27413648
23:44:32 4849 8192000000 10912895648 11331162112 1946784128 19.201 100 69 137 2 2000909088 33264672 20860288
23:44:44 8409 8192000000 10904118432 11336835072 1945017056 19.187 100 46 92 1 1991063472 31068720 14977696
23:44:59 2420 8192000000 10950152832 11354255360 1964415600 19.341 100 89 177 4 2020188192 27647152 28125440
23:45:09 3587 8192000000 10927971184 11331100672 1944937600 19.186 99 82 163 0 2000482608 30170240 25374768
23:45:20 10879 8192000000 10887926816 11323514880 1913533568 18.935 98 41 82 0 1956279056 29637408 13108080
23:45:42 11729 8192000000 10884493152 11326541824 1934314880 19.101 100 32 64 0 1978717600 33961536 10441184
23:46:02 11879 8192000000 10887682080 11319246848 1916311296 18.957 99 44 90 3 1962090720 31216192 14563232
23:46:21 2248 8192000000 10883736352 11309051904 1921404304 18.998 100 44 85 0 1967356976 31919536 14033136
23:46:31 14331 8192000000 10881352464 11306872832 1909397744 18.902 99 39 79 3 1954345968 31927488 13020736
23:46:57 2321 8192000000 10877416928 11292459008 1908907776 18.898 99 55 108 3 1954044416 28133792 17002848
23:47:07 3729 8192000000 10906535552 11324309504 1934083184 19.100 100 64 126 0 1986318240 33070864 19164192
23:47:17 9965 8192000000 10899592416 11332087808 1935568704 19.111 100 44 88 0 1983762928 34090144 14104080
23:47:39 8961 8192000000 10900208512 11340017664 1939895008 19.146 100 38 76 2 1983433312 31311648 12226656
23:47:58 9751 8192000000 10899272384 11319459840 1927289024 19.045 99 50 100 0 1973120720 29276336 16555360
23:48:14 4767 8192000000 10921655136 11338272768 1943463104 19.174 100 64 127 1 1996845840 33697536 19685200
23:48:35 12334 8192000000 10892798800 11329765376 1918268112 18.973 99 36 71 1 1965671120 35267904 12135104
23:48:59 12504 8192000000 10900609168 11325460480 1929733264 19.065 100 34 68 0 1975129584 32858144 12538176
23:49:24 5326 8192000000 10900049968 11339411456 1939949264 19.146 100 38 76 2 1981499984 29539888 12010832
23:49:39 15773 8192000000 10901155296 11346092032 1939410336 19.142 100 33 66 2 1988070864 37176704 11483824
23:50:13 20972 8192000000 10897726080 11339800576 1928084624 19.052 99 34 68 2 1973734464 34549632 11100208
23:50:44 10543 8192000000 10892174800 11332173824 1924258896 19.021 99 38 77 4 1967517664 30740096 12518672
23:51:05 4527 8192000000 10896089088 11322699776 1925864208 19.034 99 44 88 1 1969155744 29311264 13980272
23:51:22 11940 8192000000 10901066864 11346382848 1947018320 19.203 100 37 74 1 1988621920 29731360 11872240
23:51:40 20293 8192000000 10893090320 11341651968 1948502432 19.215 100 24 48 1 1978973120 22843040 7627648
23:52:07 19071 8192000000 10903751360 11349069824 1957043072 19.283 100 29 58 1 1989115760 23122752 8949936
23:52:32 28252 8192000000 10903765072 11351515136 1957511344 19.286 100 15 30 0 1986086224 23346144 5228736
23:53:07 20758 8192000000 10903215616 11349655552 1955472448 19.270 100 22 44 1 1989399904 27044032 6883424
23:54:36 38063 8192000000 10887104304 11348099072 1911665584 18.920 98 18 36 0 1945444752 28124096 5655072
23:55:21 42317 8192000000 10881632496 11338715136 1925628496 19.032 99 15 30 1 1949623664 19227552 4767616
23:56:09 53263 8192000000 10869011728 11346808832 1915887600 18.954 99 12 24 1 1950609984 30639264 4083120
23:57:24 70932 8192000000 10887650720 11339481088 1935585760 19.112 99 13 26 0 1950527568 12108064 2833744
23:58:51 64187 8192000000 10881863456 11335262208 1930510208 19.071 98 18 33 0 1941826848 7083696 4232944
00:00:09 79354 8192000000 10899797840 11359571968 1925781216 19.033 98 11 22 1 1936330176 7786208 2762752
00:01:36 110594 8192000000 10919267664 11365765120 1959731088 19.304 99 17 34 4 1978084192 13263136 5089968
00:03:33 66560 8192000000 10933700160 11403067392 1993110576 19.568 100 29 58 0 2014089408 13118368 7860464
00:04:48 41029 8192000000 10954524592 11390947328 1993596176 19.572 100 22 43 0 2013897312 13713808 6587328
00:05:39 34966 8192000000 10924388720 11387240448 1979610768 19.462 99 9 18 0 1991034368 8694272 2729328
00:06:31 72473 8192000000 10935065136 11394129920 1979797296 19.463 99 11 22 1 1992551360 10189584 2564480
00:07:58 70060 8192000000 10919860624 11363901440 1940858352 19.154 97 15 30 1 1953715056 8601648 4255056
00:09:16 94658 8192000000 10931071792 11389681664 1975964144 19.433 99 35 70 0 1994724320 8665168 10095008
00:11:40 64334 8192000000 10950433120 11408261120 1998809392 19.613 100 26 51 1 2027555840 20725840 8020608
00:12:56 95745 8192000000 10934998096 11393392640 1956070992 19.275 97 31 62 1 1973940912 8248208 9621712
00:14:38 1889 8192000000 10947486160 11397939200 1997682944 19.604 100 45 91 0 2026349424 14875600 13790880
00:14:46 54022 8192000000 10918938768 11388489728 1929454016 19.063 96 24 48 0 1951489312 15204512 6830784
00:15:52 51606 8192000000 10933762096 11398172672 1988675040 19.533 100 22 44 2 2014122768 18360848 7086880
00:16:54 34009 8192000000 10953702896 11397976064 1960392096 19.309 98 29 56 0 1990838112 20540992 9905024
00:17:36 34776 8192000000 10935026016 11406790656 1996066560 19.592 100 43 86 1 2035434608 26237536 13130512
00:18:36 168953 8192000000 10890495712 11365826560 1868753024 18.574 94 15 30 1 1885750960 13218752 3779184
00:21:33 29493 8192000000 10892453648 11373051904 1957570848 19.287 99 11 22 0 1972747456 12509760 2666848
00:22:08 11643 8192000000 10889561568 11373740032 1972232112 19.403 100 7 14 0 1982481376 8473360 1775904
00:22:47 52641 8192000000 10866847712 11348299776 1921432320 18.998 97 10 21 0 1932044176 7675504 2936352
00:23:46 13098 8192000000 10890179328 11366322176 1971237344 19.395 100 11 18 1 1981390656 7874720 2278592
00:24:06 31764 8192000000 10860334336 11345653760 1908528160 18.895 97 12 24 1 1920590720 8838144 3224416
00:24:44 10555 8192000000 10856522496 11327774720 1916453328 18.958 98 7 13 0 1926288912 8138528 1697056
00:25:06 52740 8192000000 10861077632 11343110144 1949189824 19.220 100 8 16 1 1960174192 8741072 2243296
00:26:30 35633 8192000000 10828420032 11306741760 1866073120 18.552 96 18 35 1 1877798896 6892496 4833280
00:27:14 57388 8192000000 10851737104 11322122240 1899405760 18.822 98 15 28 0 1912573664 8943232 4224672
00:29:07 64333 8192000000 10847534848 11335139328 1879184448 18.659 97 13 26 0 1897514624 14896288 3433888
00:30:18 48337 8192000000 10846269648 11313684480 1820627664 18.183 94 24 48 0 1839922336 12983216 6311456
00:31:19 71836 8192000000 10831322016 11301322752 1816655328 18.150 95 10 20 1 1836445280 16868416 2921536
00:32:37 87297 8192000000 10869636736 11349594112 1894740464 18.784 98 13 26 0 1912988960 14394880 3853616
00:34:20 34032 8192000000 10851189632 11320217600 1901818128 18.841 98 19 37 2 1920701824 13501472 5382224
00:35:01 66466 8192000000 10855266432 11307044864 1837659264 18.322 95 20 40 0 1858043360 14175504 6208592
00:36:17 30461 8192000000 10859294368 11295772672 1858560320 18.492 97 43 86 1 1880817904 9940736 12316848
00:36:54 21432 8192000000 10848918192 11297857536 1908618800 18.896 100 37 74 2 1930118720 11320896 10179024
00:37:23 30964 8192000000 10858194912 11310116864 1905573712 18.871 99 37 74 1 1926838640 11196256 10068672
00:38:00 16295 8192000000 10869302768 11313815552 1925129744 19.028 100 37 74 2 1946362288 10804544 10428000
00:38:23 35141 8192000000 10876559424 11332444160 1935228000 19.109 100 40 80 4 1961699328 14493328 11978000
00:39:14 77076 8192000000 10896484464 11341836288 1928901520 19.058 99 17 34 0 1944870368 11162192 4806656
00:40:38 44723 8192000000 10896970496 11347083264 1940619248 19.152 99 39 79 1 1959933472 8782640 10531584
00:41:29 91825 8192000000 10865101184 11330813952 1922251392 19.005 98 43 84 3 1944804160 10134032 12418736
00:44:07 49621 8192000000 10855892128 11333124096 1904850304 18.865 98 11 22 2 1920750656 12701104 3199248
00:45:39 63017 8192000000 10868577312 11354132480 1940324208 19.149 100 6 12 0 1955716080 13812592 1579280
00:47:46 116174 8192000000 10894661744 11360403456 1923233648 19.013 98 7 14 0 1935088880 9950608 1904624
00:49:49 60778 8192000000 10906419952 11380637696 1970882224 19.392 100 21 42 3 1990757984 13258144 6617616
00:51:25 62530 8192000000 10891247104 11379834880 1971268160 19.396 100 16 32 0 1988505216 12641984 4595072
00:52:39 20855 8192000000 10914015488 11377954816 1985610368 19.509 100 49 97 2 2007076176 7017776 14448032
00:53:09 26455 8192000000 10896275632 11361980416 1937919424 19.130 98 39 77 2 1960846416 12345312 10581680
00:53:42 110694 8192000000 10903883728 11374907392 1927005360 19.043 98 16 32 0 1943337920 11809728 4522832
00:56:13 60509 8192000000 10903273456 11372158976 1944179072 19.180 98 19 38 1 1967887408 18576672 5131664
00:57:20 74198 8192000000 10921086128 11381182464 1923656752 19.016 97 27 54 4 1939659904 9345072 6658080
00:58:43 22453 8192000000 10918029504 11373613056 1947999792 19.211 98 28 55 2 1964073216 8640576 7432848
00:59:12 75992 8192000000 10885263760 11362639872 1845034128 18.382 93 27 54 1 1868578944 16289008 7255808
01:00:34 78398 8192000000 10912160416 11379609600 1940355024 19.150 98 20 40 1 1958766416 12959840 5451552
01:02:17 60748 8192000000 10904625344 11381645312 1959523840 19.302 99 37 74 1 1991170816 20223712 11423264
01:03:40 52247 8192000000 10898480144 11399233536 1972169328 19.403 100 9 18 0 1997035824 21318112 3548384
01:04:56 86936 8192000000 10898023072 11394797568 1952126256 19.243 99 4 8 0 1969718080 16724464 867360
01:06:29 51590 8192000000 10898278144 11375714304 1915513984 18.951 97 10 20 0 1927611456 9344288 2753184
01:07:35 55197 8192000000 10877229680 11347173376 1879132608 18.658 95 26 51 4 1895590272 8340608 8117056
01:08:38 47062 8192000000 10896838064 11364073472 1955086160 19.267 100 16 32 1 1968637936 9244736 4307040
01:09:35 54575 8192000000 10876273872 11362009088 1921565824 18.999 97 37 74 1 1940935824 8810336 10559664
01:10:38 130487 8192000000 10886867216 11358502912 1833999648 18.292 93 10 20 0 1848719360 12320880 2398832
01:12:57 59482 8192000000 10887015392 11350409216 1914434944 18.942 98 8 16 1 1929107936 12039152 2633840
01:14:10 110534 8192000000 10860272208 11331174400 1771722768 17.781 91 11 22 1 1786771376 11979632 3068976
01:16:07 69171 8192000000 10816127936 11275759616 1775163056 17.810 92 17 34 0 1791726416 11704304 4859056
01:17:24 68870 8192000000 10837272112 11303473152 1823002608 18.202 96 3 6 0 1832992320 9405488 584224
01:18:41 50147 8192000000 10863795360 11330363392 1911190288 18.916 99 22 44 2 1927805408 10352464 6262656
01:19:38 102713 8192000000 10857178560 11330871296 1847541408 18.402 95 13 26 1 1863328016 12200144 3586464
01:22:16 76650 8192000000 10873227856 11341582336 1917621664 18.968 99 23 47 1 1936631776 12360704 6649408
01:23:39 47248 8192000000 10852823760 11339730944 1897610640 18.807 98 10 20 0 1915868752 15567968 2690144
01:24:35 53783 8192000000 10842470144 11320909824 1898328976 18.813 98 20 40 1 1919212544 14602432 6281136
01:25:42 61128 8192000000 10818326048 11301220352 1863300912 18.530 97 8 16 0 1875526880 10332096 1893872
01:26:49 24156 8192000000 9993178960 10380558336 1120970288 12.036 59 1 2 0 1129041216 8008800 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-11-2020 01:28:56 to 14-11-2020 01:29:28.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 123 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-11-2020 01:29:29 to 14-11-2020 01:29:31.

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          255216
MON$OLDEST_ACTIVE               255217
MON$OLDEST_SNAPSHOT             255217
MON$NEXT_TRANSACTION            255217
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                       2069024
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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'

14.11.20 01:29:32. 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
2020-11-14 01:29:34 No severe PSQL-related problems occured
14.11.20 01:29:35. End of report.