Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.02.2021 22:27
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 16753376 kB
MemAvailable 31126824 kB
Buffers 0 kB
Cached 14918704 kB
SwapCached 4064 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-02-18 22:27:19
DTS_END                         2021-02-18 22:27:19.9940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(751:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57262
TRN_ID                          247661
ATT_ID                          725
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: 9474.98 17547 1136997
customer order: creation 178.19 330 21383
customer order: refuse 15.03 343 1804
order to supplier: creation 47.98 1365 5758
order to supplier: removal 3.68 101919 441
invoice (draft): creation 47.48 3498 5698
invoice (draft): removal 54.85 829 6582
invoice accept: apply 41.67 18320 5000
invoice accept: cancel 49.45 766 5934
customer reserve: creation 3925.78 177 471093
customer reserve: removal 4806.02 60 576723
realization accept: apply 87.87 190 10544
realization accept: cancel 82.38 107 9885
payment from customer: creation 61.44 131 7373
payment from customer: removal 5.51 78 661
payment to supplier: creation 50.90 153 6108
payment to supplier: removal 3.43 107 411
service: total inventory turnovers 5.37 1117 644
service: total monetary turnovers 7.03 51 843
service: aggregate perf. data 0.90 18079 108
service: refresh index statistics 0.03 203329 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2021 22:28:21 to 18-02-2021 22:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7234
TEST_TIME 2 5147
TEST_TIME 3 4112
TEST_TIME 4 4560
TEST_TIME 5 5193
TEST_TIME 6 5049
TEST_TIME 7 5177
TEST_TIME 8 4848
TEST_TIME 9 5336
TEST_TIME 10 5416
TEST_TIME 11 5555
TEST_TIME 12 6650
TEST_TIME 13 6826
TEST_TIME 14 6986
TEST_TIME 15 7115
TEST_TIME 16 7205
TEST_TIME 17 7546
TEST_TIME 18 7507
TEST_TIME 19 7618
TEST_TIME 20 7700
TEST_TIME 21 7748
TEST_TIME 22 8218
TEST_TIME 23 8765
TEST_TIME 24 8962
TEST_TIME 25 9202
TEST_TIME 26 9708
TEST_TIME 27 9784
TEST_TIME 28 10198
TEST_TIME 29 10364
TEST_TIME 30 11233
TEST_TIME 31 11129
TEST_TIME 32 11014
TEST_TIME 33 11083
TEST_TIME 34 11011
TEST_TIME 35 10863
TEST_TIME 36 10701
TEST_TIME 37 10764
TEST_TIME 38 10868
TEST_TIME 39 10792
TEST_TIME 40 10635
TEST_TIME 41 10493
TEST_TIME 42 10345
TEST_TIME 43 10529
TEST_TIME 44 10348
TEST_TIME 45 10314
TEST_TIME 46 10300
TEST_TIME 47 10389
TEST_TIME 48 10353
TEST_TIME 49 10227
TEST_TIME 50 10192
TEST_TIME 51 10145
TEST_TIME 52 10049
TEST_TIME 53 9937
TEST_TIME 54 9859
TEST_TIME 55 9881
TEST_TIME 56 9803
TEST_TIME 57 9781
TEST_TIME 58 9767
TEST_TIME 59 9759
TEST_TIME 60 9752
TEST_TIME 61 9900
TEST_TIME 62 10000
TEST_TIME 63 9976
TEST_TIME 64 9971
TEST_TIME 65 10035
TEST_TIME 66 10052
TEST_TIME 67 10035
TEST_TIME 68 10087
TEST_TIME 69 10035
TEST_TIME 70 10077
TEST_TIME 71 10137
TEST_TIME 72 10048
TEST_TIME 73 9955
TEST_TIME 74 9965
TEST_TIME 75 9912
TEST_TIME 76 9823
TEST_TIME 77 9901
TEST_TIME 78 9839
TEST_TIME 79 9831
TEST_TIME 80 9775
TEST_TIME 81 9741
TEST_TIME 82 9644
TEST_TIME 83 9655
TEST_TIME 84 9625
TEST_TIME 85 9704
TEST_TIME 86 9672
TEST_TIME 87 9689
TEST_TIME 88 9798
TEST_TIME 89 9809
TEST_TIME 90 9789
TEST_TIME 91 9799
TEST_TIME 92 9846
TEST_TIME 93 9809
TEST_TIME 94 9860
TEST_TIME 95 9814
TEST_TIME 96 9824
TEST_TIME 97 9841
TEST_TIME 98 9858
TEST_TIME 99 9819
TEST_TIME 100 9814
TEST_TIME 101 9779
TEST_TIME 102 9806
TEST_TIME 103 9784
TEST_TIME 104 9770
TEST_TIME 105 9737
TEST_TIME 106 9711
TEST_TIME 107 9691
TEST_TIME 108 9662
TEST_TIME 109 9666
TEST_TIME 110 9651
TEST_TIME 111 9616
TEST_TIME 112 9553
TEST_TIME 113 9534
TEST_TIME 114 9518
TEST_TIME 115 9492
TEST_TIME 116 9486
TEST_TIME 117 9476
TEST_TIME 118 9496
TEST_TIME 119 9549
TEST_TIME 120 9477

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-02-2021 22:28:24 to 18-02-2021 22:28:28.

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 1573908 1573908 0 0.00 0 25481 6 0 0
doc_list_biud 1573908 1573908 0 0.00 0 73702 28 0 0
sp_add_invoice_to_stock 5104 5000 104 2.03 36 190555 18321 0 104
sp_cancel_adding_invoice 5934 5934 0 0.00 5 51599 767 0 0
sp_cancel_client_order 1804 1804 0 0.00 4 15796 344 0 0
sp_cancel_customer_reserve 576723 576723 0 0.00 1 73705 61 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 3 3670 79 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 7982 107 0 0
sp_cancel_supplier_invoice 6592 6582 10 0.15 2 23627 830 0 10
sp_cancel_supplier_order 441 441 0 0.00 7 1216337 101920 0 0
sp_cancel_write_off 9885 9885 0 0.00 1 10392 108 0 0
sp_client_order 21383 21383 0 0.00 4 37085 330 0 0
sp_customer_reserve 471093 471093 0 0.00 0 110848 177 0 0
sp_fill_shopping_cart 32834 32834 0 0.00 1 12670 40 0 0
sp_fill_shopping_cart_clo_res 471088 471088 0 0.00 0 12329 12 0 0
sp_get_clo_for_invoice 4995 4995 0 0.00 0 13984 240 0 0
sp_kill_cost_storno 16891 16891 0 0.00 0 9918 60 0 0
sp_kill_qstorno_ret_qs2qd 1170354 1170354 0 0.00 0 73697 33 0 0
sp_kill_qty_storno 616907 616907 0 0.00 0 73702 71 0 0
sp_lock_selected_doc 21348 21348 0 0.00 0 5874 4 0 0
sp_make_cost_storno 29019 29019 0 0.00 0 24590 67 0 0
sp_multiply_rows_for_pdistr 29019 29019 0 0.00 0 13005 33 0 0
sp_multiply_rows_for_qdistr 21383 21383 0 0.00 0 37068 140 0 0
sp_pay_from_customer 7373 7373 0 0.00 4 24354 131 0 0
sp_pay_to_supplier 6108 6108 0 0.00 5 25016 153 0 0
sp_payment_common 13481 13481 0 0.00 1 24852 39 0 0
sp_qd_handle_on_cancel_clo 1804 1804 0 0.00 0 15789 322 0 0
sp_qd_handle_on_invoice_upd_sts 10928 10928 0 0.00 0 22918 332 0 0
sp_qd_handle_on_reserve_upd_sts 10544 10544 0 0.00 0 8105 52 0 0
sp_reserve_write_off 10544 10544 0 0.00 6 18650 191 0 0
sp_supplier_invoice 5698 5698 0 0.00 7 98008 3498 0 0
sp_supplier_order 5758 5758 0 0.00 5 31261 1365 0 0
srv_aggregate_perf_data 109 108 1 0.91 2786 277584 18079 0 1
srv_fill_mon_cache_memory 174 174 0 0.00 1127 181705 29470 0 0
srv_find_qd_qs_mism 1088136 1088136 0 0.00 0 25452 5 0 0
srv_make_invnt_saldo 644 644 0 0.00 21 97276 1118 0 0
srv_make_money_saldo 843 843 0 0.00 1 16286 52 0 0
srv_recalc_idx_stat 4 4 0 0.00 179843 223796 203329 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 5000 5000 0 0.00 0 15326 220 0 0
t$perf-norm:sp_cancel_adding_invoice 398 398 0 0.00 1 5549 116 0 0
t$perf-norm:sp_cancel_client_order 1804 1804 0 0.00 0 5641 18 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 3242 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 5319 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 313 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 992 16 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 25871 1645 0 0
t$perf-norm:sp_cancel_write_off 985 985 0 0.00 0 626 5 0 0
t$perf-norm:sp_client_order 21383 21383 0 0.00 0 7938 20 0 0
t$perf-norm:sp_customer_reserve 1042 1042 0 0.00 0 9425 16 0 0
t$perf-norm:sp_pay_from_customer 7374 7374 0 0.00 0 7288 12 0 0
t$perf-norm:sp_pay_to_supplier 6109 6109 0 0.00 0 5257 13 0 0
t$perf-norm:sp_reserve_write_off 10544 10544 0 0.00 0 7878 13 0 0
t$perf-norm:sp_supplier_invoice 5698 5698 0 0.00 0 7408 15 0 0
t$perf-norm:sp_supplier_order 5758 5758 0 0.00 0 8311 22 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 537 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 1235 11 0 0
t$perf-norm:srv_make_invnt_saldo 644 644 0 0.00 0 4292 28 0 0
t$perf-norm:srv_make_money_saldo 843 843 0 0.00 0 1553 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10196 9988 208 2.04 0 4227 19 0 208
v_all_customers 38526 38526 0 0.00 0 40 1 0 0
v_all_suppliers 32110 32110 0 0.00 0 29 1 0 0
v_all_wares 42764 42764 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 796 796 0 0.00 0 2288 10 0 0
v_cancel_client_order 3608 3608 0 0.00 0 2243 4 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 1838 5 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 1723 7 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 218 4 0 0
v_cancel_supplier_invoice 848 828 20 2.35 0 1287 19 0 20
v_cancel_supplier_order 882 882 0 0.00 0 442 5 0 0
v_cancel_write_off 1970 1970 0 0.00 0 2695 16 0 0
v_max_id_clo_ord 5758 5758 0 0.00 0 466 1 0 0
v_max_id_clo_res 1041 1041 0 0.00 0 4559 11 0 0
v_max_id_ord_sup 5694 5694 0 0.00 0 12664 6 0 0
v_max_non_paid_invoice 1505 1505 0 0.00 0 666 4 0 0
v_max_non_paid_realizn 4084 4084 0 0.00 0 4978 6 0 0
v_min_id_clo_ord 5758 5758 0 0.00 0 5689 11 0 0
v_min_id_clo_res 1041 1041 0 0.00 0 6283 10 0 0
v_min_id_ord_sup 5694 5694 0 0.00 0 9605 9 0 0
v_min_non_paid_invoice 6108 6108 0 0.00 0 24844 29 0 0
v_min_non_paid_realizn 7373 7373 0 0.00 0 24317 27 0 0
v_our_firm 10816 10816 0 0.00 0 21 1 0 0
v_reserve_write_off 21088 21088 0 0.00 0 3708 7 0 0
x_lock_depdocs_on_canc_invoice 12102 12102 0 0.00 0 25551 133 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 22285 460 0 0
x_make_qstorno_1000_1200 5758 5758 0 0.00 1 31240 1274 0 0
x_make_qstorno_1200_2000 5698 5698 0 0.00 3 97950 3359 0 0
x_make_qstorno_2100_3300 471093 471093 0 0.00 0 110848 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2021 22:28:29 to 18-02-2021 22:28:33.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:23 3 8192000000 8804656272 8816791552 10294160 0.125 2 2 3 0 10472592 66144 112288
19:57:30 12306 8192000000 10226323760 10533404672 948879296 10.380 75 54 106 0 970149568 2803312 18466960
19:57:50 21997 8192000000 10341208800 10657148928 1376340112 14.384 100 81 162 0 1406650112 4455776 25854224
19:58:27 29539 8192000000 10399937904 10721787904 1446493792 15.007 100 92 185 0 1483768864 6688864 30586208
19:59:05 32844 8192000000 10414098928 10741805056 1470203168 15.216 100 92 184 0 1508133584 8022464 29907952
19:59:52 19225 8192000000 10429725472 10758553600 1482444192 15.323 100 92 184 1 1520920352 8732784 29743376
20:00:23 12245 8192000000 10445467456 10775560192 1494388512 15.427 100 90 180 0 1532902480 9547296 28966672
20:00:47 19234 8192000000 10457079008 10791645184 1507429392 15.541 100 90 180 2 1546355520 9878192 29047936
20:01:17 13568 8192000000 10472701392 10812395520 1530336176 15.740 100 87 174 0 1568437840 10592976 27508688
20:01:42 20593 8192000000 10515638320 10861441024 1558593488 15.984 100 79 158 1 1593376096 10893552 23889056
20:02:08 16520 8192000000 10546319936 10900103168 1595744688 16.303 100 83 166 2 1632220832 11494912 24981232
20:02:33 6530 8192000000 10565155936 10922930176 1617006768 16.484 100 77 154 0 1652673776 12470880 23196128
20:02:53 9518 8192000000 10584008352 10944167936 1638741504 16.669 100 83 166 0 1676131744 12741840 24648400
20:03:12 9498 8192000000 10598510016 10962112512 1656372144 16.818 100 79 156 2 1691580416 12592960 22615312
20:03:31 8255 8192000000 10630037904 10998165504 1676014720 16.984 100 76 153 1 1710577840 12584944 21978176
20:03:45 7826 8192000000 10631852384 11000795136 1693084912 17.127 100 82 164 0 1729859328 12591376 24183040
20:04:01 7131 8192000000 10640469504 11013079040 1705918816 17.235 100 77 154 0 1740913664 12667888 22326960
20:04:17 6953 8192000000 10651567552 11026116608 1720781984 17.359 100 82 164 0 1756868624 13336000 22750640
20:04:32 5267 8192000000 10673186688 11046768640 1729026624 17.427 100 82 164 0 1767483472 14853424 23603424
20:04:45 4901 8192000000 10681346864 11055599616 1741128592 17.528 100 88 176 0 1780305984 14036176 25141216
20:04:57 6473 8192000000 10678548832 11058401280 1745852496 17.567 100 72 144 3 1779612832 13297760 20462576
20:05:12 4120 8192000000 10702863888 11081109504 1762728208 17.707 100 80 160 0 1798647040 13712464 22206368
20:05:22 4058 8192000000 10705885152 11078717440 1763014464 17.709 100 81 162 1 1799457088 13709776 22732848
20:05:33 4971 8192000000 10720067952 11095199744 1778388160 17.836 100 86 169 1 1814683936 12636752 23659024
20:05:45 3357 8192000000 10727513776 11106283520 1785227856 17.893 100 83 164 2 1821475952 13437440 22810656
20:05:55 2642 8192000000 10727215552 11109064704 1791986144 17.948 100 90 180 0 1831408832 13740480 25682208
20:06:05 4105 8192000000 10737864272 11118514176 1795255744 17.975 100 94 185 4 1835286576 14320592 25710240
20:06:17 2405 8192000000 10742655872 11121795072 1804745024 18.053 100 87 174 1 1843366528 14218304 24403200
20:06:26 2289 8192000000 10746636592 11132821504 1808664016 18.085 100 88 172 0 1846206352 12873392 24668944
20:06:40 4394 8192000000 10746321776 11135524864 1818659424 18.167 100 85 169 1 1854433648 11860624 23913600
20:06:52 2084 8192000000 10765440096 11151876096 1828869056 18.250 100 92 183 0 1867608656 11752800 26986800
20:07:00 1830 8192000000 10782204192 11166236672 1834460160 18.296 100 86 171 2 1871333024 12905936 23966928
20:07:09 1670 8192000000 10781032704 11169722368 1843229408 18.367 100 89 178 0 1881735856 13671184 24835264
20:07:17 1815 8192000000 10795909056 11181178880 1848729920 18.412 100 96 189 0 1887876304 13026128 26120256
20:07:25 1567 8192000000 10803917520 11190579200 1855777232 18.469 100 95 190 1 1896220816 14444416 25999168
20:07:33 1270 8192000000 10805001920 11193356288 1858921952 18.495 100 90 181 0 1897861600 13806464 25133184
20:07:40 1970 8192000000 10810444080 11199148032 1864516928 18.540 100 92 182 0 1903043760 12222240 26304592
20:07:48 1718 8192000000 10821040480 11209867264 1873964512 18.616 100 89 177 2 1911512384 11837984 25709888
20:07:56 6400 8192000000 10805448944 11203719168 1871831408 18.599 100 69 138 0 1902405152 11794144 18779600
20:08:11 9780 8192000000 10809850064 11208609792 1874370320 18.620 100 63 126 0 1902649632 9298640 18980672
20:08:27 29021 8192000000 10801792080 11209728000 1877583504 18.646 100 64 128 2 1906646192 10413392 18649296
20:09:03 18220 8192000000 10779575152 11216113664 1878337728 18.652 100 43 86 1 1902987968 11968240 12682000
20:09:27 7141 8192000000 10794216576 11214950400 1883039728 18.690 100 38 76 1 1900770096 6148448 11581920
20:09:41 6026 8192000000 10800024464 11220475904 1880817584 18.672 100 27 54 1 1899018128 11163008 7037536
20:09:55 8442 8192000000 10787837600 11217010688 1883070768 18.690 100 21 41 0 1895235680 6769376 5395536
20:10:11 5636 8192000000 10791981136 11224125440 1884100032 18.698 100 19 38 1 1899700512 10371504 5228976
20:10:25 9673 8192000000 10795053632 11227394048 1891229696 18.756 100 23 46 1 1904237520 6156368 6851456
20:10:41 7688 8192000000 10800135632 11233046528 1897752544 18.808 100 31 63 5 1912915472 6470880 8692048
20:10:58 7486 8192000000 10806478800 11236175872 1896753408 18.800 100 15 30 0 1906439856 5257136 4429312
20:11:12 5144 8192000000 10804881104 11234938880 1900032208 18.827 100 30 60 1 1915024272 5947952 9044112
20:11:25 5315 8192000000 10808443440 11241676800 1901352160 18.837 100 28 56 2 1917054080 7684176 8017744
20:11:38 6166 8192000000 10810723872 11244359680 1902029776 18.843 100 25 50 1 1916313776 7661184 6622816
20:11:53 9110 8192000000 10825833568 11252051968 1907612784 18.887 100 26 52 2 1921016704 5952736 7451184
20:12:11 8665 8192000000 10818934000 11253555200 1905257616 18.869 100 13 26 0 1914557984 5889264 3411104
20:12:26 3875 8192000000 10817202560 11249352704 1907248608 18.885 100 23 46 0 1920456368 6851776 6355984
20:12:38 12905 8192000000 10808816016 11246989312 1906168144 18.876 100 17 34 0 1917789520 6446224 5175152
20:12:57 13768 8192000000 10820385168 11249065984 1908672752 18.896 100 32 64 2 1924799984 6835360 9291872
20:13:19 78830 8192000000 10836453088 11266670592 1911776864 18.921 100 23 46 4 1924132176 5452496 6902816
20:14:47 7950 8192000000 10842224848 11266121728 1912907648 18.930 100 28 56 0 1927470480 6618544 7944288
20:15:02 4675 8192000000 10839558032 11267981312 1915763968 18.953 100 42 84 4 1935438224 7917184 11757072
20:15:13 5770 8192000000 10827539488 11264475136 1914334064 18.941 100 28 56 1 1928762096 6590160 7837872
20:15:25 3459 8192000000 10837320592 11266953216 1915902080 18.954 100 36 72 1 1932858560 6557920 10398560
20:15:36 7884 8192000000 10843074512 11267805184 1902478720 18.846 99 35 70 1 1922344992 10096208 9770064
20:15:51 3609 8192000000 10852129024 11270221824 1915129744 18.948 100 34 68 1 1930445264 5125600 10189920
20:16:04 8455 8192000000 10843332352 11270868992 1900002592 18.826 99 34 68 2 1920378448 11379344 8996512
20:16:19 6177 8192000000 10825612112 11251654656 1889829872 18.744 99 24 48 2 1903181248 6289936 7061440
20:16:33 7427 8192000000 10789402848 11217489920 1843457152 18.369 97 26 53 0 1857829712 6421920 7950640
20:16:47 7998 8192000000 10782501024 11215114240 1846376640 18.393 98 22 44 3 1858840192 5745328 6718224
20:17:04 8591 8192000000 10792112544 11225128960 1869216384 18.578 99 26 51 2 1881754080 5169408 7368288
20:17:19 7100 8192000000 10785497744 11214200832 1857846240 18.486 99 19 38 1 1869098640 5735760 5516640
20:17:35 8379 8192000000 10765840576 11195793408 1798819152 18.004 96 26 52 2 1812809536 6419344 7571040
20:17:52 58310 8192000000 10725057024 11157209088 1740101536 17.519 94 23 46 2 1752242800 4936528 7204736
20:18:56 11549 8192000000 10700638480 11118874624 1692019408 17.118 93 24 46 0 1704196352 5583360 6593584
20:19:14 6741 8192000000 10739360144 11154264064 1800827632 18.021 99 39 79 2 1818842240 7440432 10574176
20:19:28 4161 8192000000 10725244672 11141775360 1791348256 17.943 99 35 70 0 1812503168 11196080 9958832
20:19:40 7059 8192000000 10665856048 11076296704 1676315472 16.986 94 38 76 1 1693512192 6092512 11104208
20:19:54 6802 8192000000 10694589600 11104653312 1734540384 17.473 97 42 84 3 1752088672 5113200 12435088
20:20:07 5354 8192000000 10710185136 11122667520 1783044688 17.875 100 27 53 1 1797888608 6329424 8514496
20:20:19 4899 8192000000 10742772528 11155562496 1817320000 18.156 100 41 82 1 1844632912 16140752 11172160
20:20:30 6191 8192000000 10722851792 11145101312 1767365536 17.745 97 19 39 0 1778178960 5472896 5340528
20:20:47 7094 8192000000 10712638848 11127881728 1738472752 17.506 96 23 46 0 1750557008 5288000 6796256
20:21:00 8682 8192000000 10722600864 11136565248 1787309120 17.910 99 26 49 3 1800043600 5542944 7191536
20:21:16 7243 8192000000 10707032784 11130212352 1768306016 17.753 98 15 27 2 1777933312 4900192 4727104
20:21:31 9972 8192000000 10744330272 11165614080 1830173200 18.261 100 33 66 0 1846406432 5625296 10607936
20:21:47 6535 8192000000 10736618272 11160698880 1813228720 18.122 99 25 46 2 1825274256 5235136 6810400
20:22:01 8348 8192000000 10737992496 11167551488 1827707056 18.241 100 27 52 0 1841485712 5507200 8271456
20:22:17 23252 8192000000 10749260352 11183448064 1837254496 18.318 100 25 50 1 1852592688 5487648 9850544
20:23:19 30134 8192000000 10764771376 11194843136 1834801440 18.298 99 22 44 1 1846910208 5874592 6234176
20:23:55 7435 8192000000 10764041104 11191492608 1851053328 18.431 100 26 52 2 1864571728 6249312 7269088
20:24:09 6009 8192000000 10776639168 11199262720 1857184656 18.480 100 30 59 4 1870887232 5483312 8219264
20:24:22 9412 8192000000 10766373872 11198484480 1845447408 18.385 99 25 50 2 1857898064 4877552 7573104
20:24:39 6481 8192000000 10787063760 11214376960 1866104352 18.553 100 35 70 2 1886848144 10581440 10162352
20:24:54 7433 8192000000 10782356992 11216080896 1869670336 18.582 100 26 51 5 1883201920 6352352 7179232
20:25:09 6443 8192000000 10783739296 11216855040 1872694448 18.606 100 32 64 1 1889089568 6958704 9436416
20:25:21 7948 8192000000 10783821808 11217817600 1873981280 18.616 100 31 62 3 1888274944 5362416 8931248
20:25:35 14272 8192000000 10798745344 11227185152 1874317728 18.619 100 20 40 1 1885872480 5854672 5700080
20:25:59 9222 8192000000 10798327888 11225731072 1881901952 18.680 100 22 45 1 1893699088 5247824 6549312
20:26:15 9398 8192000000 10800936080 11234209792 1884546688 18.702 100 20 40 1 1895980720 5855072 5578960
20:26:31 10134 8192000000 10801712944 11233624064 1883368160 18.692 100 13 26 0 1891922240 4959904 3594176
20:26:48 11090 8192000000 10798463568 11231928320 1883776768 18.696 100 14 28 1 1892631824 5168144 3686912
20:27:07 18058 8192000000 10811058880 11247865856 1899116208 18.819 100 11 22 0 1906540720 4968384 2456128
20:27:36 45555 8192000000 10846384016 11271081984 1913692800 18.936 100 29 56 0 1927770624 5157456 8920368
20:28:28 14277 8192000000 10856922752 11285413888 1930895744 19.074 100 46 92 2 1953022368 8786960 13339664
20:28:49 65623 8192000000 10870282672 11300003840 1942191584 19.164 100 58 115 1 1966673472 7899200 16582688
20:30:02 33455 8192000000 10882695680 11313205248 1948848128 19.217 100 50 98 2 1972419568 9926304 13645136
20:31:06 6020 8192000000 10905400256 11336798208 1967050928 19.362 100 52 101 1 1994671008 13608416 14011664
20:31:22 16154 8192000000 10906503008 11340312576 1972551824 19.406 100 55 110 1 2002600192 13821920 16226448
20:31:47 18705 8192000000 10912643216 11345727488 1977077184 19.442 100 51 101 0 2005464944 14298896 14088864
20:32:14 10260 8192000000 10909827168 11347468288 1977780416 19.447 100 44 86 3 2004603808 14021904 12801488
20:32:37 14160 8192000000 10909899616 11346055168 1978695088 19.454 100 41 80 0 2004524272 14115744 11713440
20:33:03 33363 8192000000 10913402112 11352203264 1980156384 19.466 100 42 83 0 2006265904 14079680 12029840
20:33:57 2849 8192000000 10927238496 11351347200 1964305280 19.340 99 73 143 2 2003229040 16756560 22167200
20:34:08 18068 8192000000 10922445568 11359236096 1984038464 19.497 100 50 99 1 2015938400 16702816 15197120
20:34:34 10874 8192000000 10932864416 11364376576 1988724144 19.534 100 61 118 1 2023133296 16921136 17488016
20:34:56 15397 8192000000 10939937248 11376377856 1992526064 19.564 100 50 100 0 2028462320 21157136 14779120
20:35:21 14064 8192000000 10933773920 11368161280 1989240688 19.538 100 55 109 0 2025973296 20648928 16083680
20:35:43 10053 8192000000 10943430976 11371405312 1988148400 19.529 100 67 133 1 2030605808 22845024 19612384
20:36:09 12969 8192000000 10943798544 11372810240 1988434416 19.531 100 62 124 0 2035048560 28042528 18571616
20:36:29 3272 8192000000 10946653536 11379339264 1991698736 19.557 100 59 119 0 2036613664 27228512 17686416
20:36:41 16133 8192000000 10948869440 11379036160 1980873840 19.472 99 62 124 0 2025222528 25604112 18744576
20:37:08 3148 8192000000 10955385232 11381227520 1998452032 19.611 100 67 134 0 2044692080 25817872 20422176
20:37:18 8041 8192000000 10954622688 11383873536 1976297584 19.435 99 65 130 0 2022342320 26820064 19224672
20:37:41 13128 8192000000 10951764000 11389267968 1995210048 19.585 100 53 105 1 2043607776 31340896 17056832
20:38:02 7640 8192000000 10942418480 11371122688 1957944448 19.290 98 52 104 1 2004680784 30580800 16155536
20:38:18 5723 8192000000 10951193856 11373416448 1987322240 19.523 100 65 130 2 2039208704 31332896 20553568
20:38:33 9133 8192000000 10933510416 11366825984 1973479104 19.413 100 59 117 4 2025433680 33426432 18528144
20:38:50 12316 8192000000 10954335664 11373248512 1983544448 19.493 100 68 132 2 2035188240 31361648 20282144
20:39:09 19538 8192000000 10944356080 11379785728 1981656864 19.478 100 45 90 1 2028475616 31892896 14925856
20:39:40 6307 8192000000 10933852128 11372212224 1983685184 19.494 100 42 83 2 2023274432 26368688 13220560
20:39:55 6826 8192000000 10941986752 11365269504 1981813232 19.479 100 66 131 1 2025267872 23730208 19724432
20:40:09 3182 8192000000 10950605824 11372859392 1989205216 19.538 100 78 155 1 2035969536 23721904 23042416
20:40:19 1849 8192000000 10932953216 11340505088 1947226320 19.204 99 91 182 1 1998110672 25297136 25587216
20:40:28 1434 8192000000 10919361088 11329331200 1933930304 19.098 99 85 169 1 1985311120 26485808 24895008
20:40:37 3538 8192000000 10914400704 11328335872 1950745440 19.232 100 86 171 1 2003135456 27601328 24788688
20:40:51 3799 8192000000 10919556976 11333877760 1950509568 19.231 100 85 167 0 2002482688 27379536 24593584
20:41:03 1700 8192000000 10907147984 11315838976 1934598224 19.104 99 84 166 1 1987240448 28506992 24135232
20:41:11 9652 8192000000 10916301712 11327381504 1945599344 19.191 100 80 158 1 1998875616 29485968 23790304
20:41:30 2721 8192000000 10928967824 11342544896 1955470608 19.270 100 76 152 0 2007684848 29534640 22679600
20:41:40 2803 8192000000 10917301088 11331092480 1947384512 19.206 100 77 151 1 2002523728 31968160 23171056
20:41:53 8012 8192000000 10918022464 11337461760 1951070848 19.235 100 80 158 1 2005742384 30557936 24113600
20:42:10 3328 8192000000 10900499344 11307778048 1923119040 19.012 99 66 132 2 1974854896 31264768 20471088
20:42:22 11402 8192000000 10883236064 11307057152 1908901664 18.898 98 58 116 4 1958974336 32583264 17489408
20:42:43 2824 8192000000 10871543952 11278417920 1878392784 18.652 97 80 155 4 1934150384 31710528 24047072
20:42:53 1601 8192000000 10909675344 11313762304 1916362832 18.958 99 87 172 1 1975384832 33296000 25726000
20:43:02 2881 8192000000 10905118768 11317870592 1931782224 19.081 100 78 153 0 1989217808 34298640 23136944
20:43:12 7478 8192000000 10905428816 11318579200 1923700448 19.016 100 81 161 1 1984048016 34868480 25479088
20:43:27 7592 8192000000 10899706352 11318370304 1926391168 19.038 100 64 126 2 1980755280 35333024 19031088
20:43:42 2453 8192000000 10920683504 11323658240 1917443184 18.966 99 83 164 0 1980211744 36698048 26070512
20:43:52 5515 8192000000 10927774272 11332665344 1943973616 19.178 100 84 166 0 2006361568 37150944 25237008
20:44:05 2045 8192000000 10915388928 11321155584 1933437648 19.094 100 85 170 1 1998351600 38226896 26687056
20:44:14 1124 8192000000 10902205008 11310911488 1922934544 19.010 100 89 180 2 1989140064 37552128 28653392
20:44:23 1963 8192000000 10905064144 11311116288 1920188192 18.988 100 87 173 0 1985994816 39260528 26546096
20:44:33 4388 8192000000 10896675200 11302342656 1912424896 18.926 99 77 152 0 1976758192 40739504 23593792
20:44:45 2176 8192000000 10926462016 11331059712 1936386976 19.118 100 82 164 1 2002523600 40727280 25409344
20:44:54 4069 8192000000 10931839392 11336536064 1943122480 19.172 100 84 168 0 2011132976 40434784 27575712
20:45:06 2424 8192000000 10939420624 11344064512 1951007760 19.235 100 90 177 5 2023105024 44923872 27173392
20:45:16 4092 8192000000 10950439760 11352592384 1956215792 19.276 100 86 169 0 2025189824 42153888 26820144
20:45:33 3282 8192000000 10954699424 11355701248 1959155824 19.299 100 84 165 1 2027063136 42548640 25358672
20:45:44 1531 8192000000 10955675280 11364646912 1969796336 19.384 100 92 186 3 2041374592 43120176 28458080
20:45:51 2884 8192000000 10940303728 11346120704 1937492064 19.127 99 86 171 3 2008944976 43664512 27788400
20:46:01 2681 8192000000 10914156912 11325333504 1919374784 18.982 99 82 162 1 1988777920 43998320 25404816
20:46:13 3000 8192000000 10934116176 11344846848 1945218960 19.188 100 83 164 1 2016399488 44725936 26454592
20:46:23 1940 8192000000 10952344896 11355000832 1953564432 19.255 100 87 173 0 2025167680 45492880 26110368
20:46:31 1565 8192000000 10961116384 11365871616 1962105360 19.323 100 91 182 3 2039270672 48154704 29010608
20:46:40 8634 8192000000 10956472320 11371257856 1965920816 19.353 100 77 153 3 2037646608 48264704 23461088
20:46:55 3839 8192000000 10965950416 11378634752 1971604896 19.398 100 80 159 0 2046552144 49970816 24976432
20:47:06 2356 8192000000 10960633904 11371761664 1964920800 19.345 100 73 146 3 2038937600 50645840 23370960
20:47:15 1181 8192000000 10969042144 11374952448 1974310672 19.420 100 94 185 1 2055360496 51834928 29214896
20:47:23 1631 8192000000 10979759440 11384037376 1974559904 19.422 100 94 186 0 2057274016 53670672 29043440
20:47:32 3809 8192000000 10969739744 11380666368 1968450624 19.373 100 80 161 1 2048100176 54664512 24985040
20:47:44 3253 8192000000 10960403328 11366400000 1958062336 19.291 100 92 182 3 2038771616 52667600 28041680
20:47:56 2083 8192000000 10957580688 11365715968 1956806416 19.281 100 92 184 1 2042630864 55986112 29838336
20:48:05 3861 8192000000 10969108080 11377590272 1965240560 19.348 100 83 164 0 2048594656 56923184 26430912
20:48:16 1810 8192000000 10977540288 11384893440 1967897312 19.369 100 94 188 1 2056602720 58754016 29951392
20:48:25 2957 8192000000 10969967504 11373809664 1961358416 19.317 100 87 174 1 2049958144 60119264 28480464
20:48:36 2693 8192000000 10977698064 11379142656 1959376592 19.301 100 88 175 0 2049760848 61981744 28402512
20:48:45 2780 8192000000 10962901056 11373260800 1955219520 19.268 100 83 165 0 2044572176 62406752 26945904
20:48:58 3205 8192000000 10973302080 11378724864 1959349456 19.301 100 82 163 2 2046890352 61432256 26108640
20:49:10 1767 8192000000 10978517184 11386855424 1967855472 19.368 100 84 167 1 2056443520 62230944 26357104
20:49:23 3920 8192000000 10980312960 11392249856 1966250064 19.356 100 83 166 1 2059173520 65426128 27497328
20:49:42 2493 8192000000 10999338880 11409080320 1980648240 19.470 100 85 170 2 2079333168 70816816 27868112
20:49:51 7988 8192000000 10977727360 11401625600 1973045088 19.410 100 68 136 1 2061440832 66659120 21736624
20:50:11 16337 8192000000 10955386704 11403792384 1968951344 19.377 100 40 80 1 2051554656 68260560 14342752
20:50:34 7905 8192000000 10965723072 11413098496 1973796864 19.416 100 46 92 0 2053018160 63774672 15446624
20:50:56 11153 8192000000 10974330560 11415154688 1982243760 19.482 100 44 88 2 2056649184 59874848 14530576
20:51:23 21364 8192000000 10964780400 11415265280 1981476752 19.476 100 37 74 2 2056413168 62022160 12914256
20:51:52 11396 8192000000 10966014224 11409772544 1978167168 19.450 100 37 74 1 2051786416 60655264 12963984
20:52:10 3877 8192000000 10963560304 11403681792 1973623344 19.414 100 41 82 0 2048895168 60983248 14288576
20:52:21 9323 8192000000 10960793760 11404460032 1969027424 19.378 100 36 72 2 2042950576 61029312 12893840
20:53:02 23985 8192000000 10951159344 11401965568 1971457856 19.397 100 27 54 1 2039399888 58375456 9566576
20:53:33 47482 8192000000 10925139280 11386847232 1944603664 19.183 99 27 54 2 2012864224 58508256 9752304
20:54:30 33434 8192000000 10938459072 11386073088 1936366080 19.118 99 23 46 1 1995872400 51486816 8019504
20:55:10 37321 8192000000 10911153616 11384107008 1928407088 19.054 99 15 30 0 1979812672 45758368 5647216
20:55:55 24420 8192000000 10900915056 11362312192 1915511840 18.951 99 14 28 0 1970119248 49426144 5181264
20:56:26 20968 8192000000 10904351792 11376791552 1927033056 19.043 100 11 22 0 1985422032 53959520 4429456
20:56:59 56821 8192000000 10877071968 11365691392 1911109760 18.916 99 13 26 0 1959460240 43845056 4505424
20:58:31 22237 8192000000 10896831696 11334397952 1950769632 19.233 100 28 54 1 1969197376 10579648 7848096
20:59:01 32948 8192000000 10915301040 11340955648 1946870352 19.202 99 41 80 2 1965993072 8254416 10868304
20:59:43 19564 8192000000 10891879120 11347369984 1963863296 19.337 100 34 67 1 1982325520 9016848 9445376
21:00:16 26347 8192000000 10886388800 11349872640 1954357488 19.261 100 15 30 0 1973909056 15019024 4532544
21:01:01 47261 8192000000 10910763408 11360722944 1961042832 19.314 100 13 26 0 1977796592 13313904 3439856
21:02:01 86303 8192000000 10911792720 11371237376 1958536464 19.294 99 17 35 1 1974132608 11417280 4178864
21:03:35 135067 8192000000 10900470656 11373281280 1920313840 18.989 97 22 44 3 1950709232 24046864 6348528
21:05:57 76649 8192000000 10914964624 11367833600 1959759856 19.304 99 12 24 1 1979381248 15854640 3766752
21:08:58 56613 8192000000 10961986528 11405103104 1996939312 19.599 100 43 86 2 2021925984 12681616 12305056
21:10:02 46890 8192000000 10916886320 11410399232 1996878736 19.598 100 28 56 4 2020406560 15744304 7783520
21:11:12 43446 8192000000 10916949680 11385565184 1990581488 19.548 100 14 28 0 2006472080 11784128 4106464
21:12:02 18825 8192000000 10930790064 11384643584 1957254640 19.284 98 31 60 0 1974034784 8772416 8007728
21:12:43 44661 8192000000 10937064528 11401043968 1975946800 19.433 99 19 38 2 1994423264 13138016 5338448
21:13:33 22101 8192000000 10926987664 11364925440 1968851760 19.376 99 29 56 2 1991899168 14148384 8899024
21:14:02 32366 8192000000 10951498976 11399008256 1995263104 19.585 100 48 96 0 2024092128 14808080 14020944
21:15:20 181704 8192000000 10884623744 11367849984 1832437280 18.279 92 12 24 0 1845062368 9177328 3447760
21:18:28 38910 8192000000 10897608144 11375300608 1978955152 19.456 100 15 30 0 1989765440 7001424 3808864
21:19:17 49531 8192000000 10908776704 11384578048 1987027152 19.520 100 17 34 0 2001059264 8797168 5234944
21:20:15 60923 8192000000 10873426672 11335069696 1876720576 18.639 94 30 60 0 1891836224 6534960 8580688
21:21:25 2876 8192000000 10904340992 11363659776 1975077456 19.426 100 49 95 0 1995894272 6783376 14033440
21:21:35 58145 8192000000 10901142544 11383635968 1976969360 19.441 100 23 46 1 1994064032 10088880 7005792
21:22:47 39891 8192000000 10878069504 11364278272 1935294608 19.109 98 6 11 1 1946151664 9325312 1531744
21:23:33 53444 8192000000 10890223040 11368726528 1948159872 19.212 99 8 13 1 1956571936 5806432 2605632
21:24:34 60550 8192000000 10897136640 11375861760 1884374960 18.700 95 15 30 0 1896276752 7607136 4294656
21:25:42 46263 8192000000 10907293424 11392237568 1957502080 19.286 99 22 44 0 1978447744 14350608 6595056
21:26:34 58472 8192000000 10871586000 11346030592 1878884736 18.656 95 12 24 0 1902914704 20670128 3359840
21:27:42 50964 8192000000 10879001088 11353255936 1887344688 18.724 97 17 34 0 1907994752 15848704 4801360
21:28:42 33511 8192000000 10882742576 11346669568 1912977056 18.931 98 24 48 0 1928006192 8269264 6759872
21:29:27 59165 8192000000 10875744384 11344359424 1883018944 18.689 96 15 30 1 1896950064 9767488 4163632
21:30:40 53212 8192000000 10876591008 11338113024 1892962032 18.770 97 25 49 1 1909271264 9022640 7286592
21:31:42 45280 8192000000 10877650704 11337195520 1892132160 18.763 97 41 82 0 1916041472 12313344 11595968
21:32:33 56465 8192000000 10878584544 11345768448 1894039856 18.778 98 14 28 0 1910820864 12877696 3903312
21:33:43 76194 8192000000 10884194144 11351285760 1865744144 18.550 96 10 20 1 1878283104 10345616 2193344
21:35:05 79930 8192000000 10864631968 11303010304 1787396896 17.910 92 20 40 2 1803096752 10420640 5279216
21:36:33 22985 8192000000 10876619072 11333521408 1931699632 19.080 100 31 62 1 1950148464 9660512 8788320
21:37:05 65949 8192000000 10873979520 11333816320 1879227280 18.659 97 17 34 0 1894181120 10131360 4822480
21:38:23 60556 8192000000 10873249040 11345743872 1922793056 19.009 99 9 18 1 1940255008 15120576 2341376
21:40:04 105578 8192000000 10867064064 11344211968 1898120224 18.811 98 30 60 1 1918066848 10017888 9928736
21:41:56 81518 8192000000 10868404736 11343654912 1917883104 18.970 99 11 22 0 1935710224 14763328 3063792
21:43:25 4134 8192000000 10867409840 11335360512 1933817664 19.097 100 21 42 0 1954389888 14212192 6360032
21:43:35 56505 8192000000 10844223680 11324485632 1879503744 18.661 97 35 70 3 1907108000 16853424 10750832
21:44:40 67600 8192000000 10849400640 11329089536 1921289216 18.997 99 14 28 0 1936415456 11143328 3982912
21:46:40 33311 8192000000 10868343232 11330150400 1907415280 18.886 98 32 64 1 1924912480 8009792 9487408
21:47:21 54537 8192000000 10860893456 11335970816 1921746976 19.001 99 14 28 1 1934963280 9035984 4180320
21:48:27 69247 8192000000 10874391040 11356327936 1947883200 19.210 100 18 36 2 1966898080 13275424 5739456
21:50:07 63811 8192000000 10872507536 11360395264 1938752928 19.137 99 16 32 1 1957742464 14197472 4792064
21:51:25 74997 8192000000 10881370192 11369824256 1962809472 19.328 100 16 32 0 1979990272 12027104 5153696
21:52:50 65931 8192000000 10895841984 11376398336 1931361808 19.078 98 14 28 1 1948178256 12549760 4266688
21:54:26 46904 8192000000 10889276496 11379732480 1941000592 19.155 99 30 60 1 1965887664 15636720 9250352
21:55:19 121591 8192000000 10892323520 11372802048 1916443728 18.958 98 11 22 1 1932549600 13306432 2799440
21:57:27 40271 8192000000 10878019712 11351629824 1894850336 18.785 96 21 42 3 1909089744 8759952 5479456
21:58:29 51445 8192000000 10892865664 11364454400 1954526224 19.263 100 13 24 0 1966913744 9485264 2902256
21:59:27 74101 8192000000 10899030800 11369508864 1929406112 19.062 98 18 36 1 1944510016 10270624 4833280
22:00:47 33374 8192000000 10905099648 11378847744 1949434656 19.222 99 34 68 0 1974979216 16102432 9442128
22:01:33 62853 8192000000 10920611088 11378274304 1948143808 19.212 99 29 57 1 1971733504 15626608 7963088
22:02:43 15226 8192000000 10932459888 11388280832 1983028032 19.489 100 46 92 1 2006423136 10495856 12899248
22:03:13 30376 8192000000 10920486768 11373760512 1958442432 19.294 99 44 88 0 1981840912 11685296 11713184
22:03:51 7339 8192000000 10900296848 11348688896 1944367152 19.182 99 53 105 1 1970789056 12372832 14049072
22:04:09 20234 8192000000 10886069712 11345674240 1934521184 19.103 99 35 70 2 1955757712 11782448 9454080
22:04:39 30828 8192000000 10916215680 11383721984 1969191584 19.379 100 26 52 1 1985393712 9299264 6902864
22:05:40 17998 8192000000 10926745600 11378409472 1971600848 19.398 100 54 108 3 1995122112 8291488 15229776
22:06:18 42097 8192000000 10928021600 11394289664 1982217424 19.482 100 39 78 0 2010851856 17476528 11157904
22:07:09 142018 8192000000 10917305088 11400069120 1965593712 19.350 99 17 34 0 1986547136 16413104 4540320
22:09:50 49726 8192000000 10895213792 11398881280 1952385360 19.245 99 9 18 0 1981070960 26096608 2588992
22:11:14 20619 8192000000 10886735872 11359051776 1955840080 19.273 99 30 60 1 1971192832 6941728 8411024
22:11:46 61112 8192000000 10873834080 11354136576 1947194560 19.204 99 13 26 1 1961244800 10047536 4002704
22:13:20 47465 8192000000 10896942352 11374501888 1934796736 19.105 98 17 34 0 1953159488 12926768 5435984
22:14:14 56640 8192000000 10842366848 11316838400 1832111344 18.277 93 17 34 0 1844711568 7795568 4804656
22:15:22 47273 8192000000 10865042416 11347009536 1940903904 19.154 100 12 22 2 1955978384 11214000 3860480
22:17:39 41287 8192000000 10827611360 11303317504 1849755744 18.420 95 15 30 0 1861056000 6084416 5215840
22:18:41 96559 8192000000 10816183456 11288879104 1838869024 18.332 96 10 20 0 1848785168 7416272 2499872
22:20:28 65327 8192000000 10818056656 11291602944 1817015520 18.153 95 13 26 0 1827676704 7352432 3308752
22:21:40 64403 8192000000 10829526960 11310555136 1835944816 18.308 96 8 16 0 1845372144 7309280 2118048
22:22:51 54915 8192000000 10875040368 11351744512 1911843792 18.921 99 24 48 1 1927108272 8505072 6759408
22:23:55 52564 8192000000 10878601760 11356708864 1918246736 18.973 98 30 60 2 1936813520 10131488 8435296
22:25:00 47480 8192000000 10885485120 11363926016 1937751840 19.129 99 19 38 0 1958796576 15707616 5337120
22:26:00 53550 8192000000 10855518592 11344789504 1885903200 18.713 97 16 30 1 1907322032 16284000 5134832
22:27:17 8520 8192000000 9217734880 9477496832 366429568 4.281 20 2 3 0 371305968 4454656 421744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 18-02-2021 22:28:35 to 18-02-2021 22:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 104 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2021 22:29:08 to 18-02-2021 22:29:10.

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

18.02.21 22:29:11. 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-02-18 22:29:14 No severe PSQL-related problems occured
18.02.21 22:29:15. End of report.