Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.2021 16:32
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17287164 kB
MemAvailable 31557748 kB
Buffers 0 kB
Cached 14353328 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-12 16:31:41
DTS_END                         2021-03-12 16:31:41.1510
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42698
TRN_ID                          240665
ATT_ID                          654
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: 9644.78 19078 1157373
customer order: creation 174.72 338 20966
customer order: refuse 14.67 332 1760
order to supplier: creation 46.48 1391 5577
order to supplier: removal 3.68 93684 442
invoice (draft): creation 46.73 3395 5608
invoice (draft): removal 55.51 746 6661
invoice accept: apply 42.60 18843 5112
invoice accept: cancel 50.10 737 6012
customer reserve: creation 3952.48 185 474298
customer reserve: removal 4951.25 54 594150
realization accept: apply 86.37 180 10364
realization accept: cancel 91.63 100 10995
payment from customer: creation 59.94 133 7193
payment from customer: removal 5.71 103 685
payment to supplier: creation 47.53 145 5703
payment to supplier: removal 3.28 99 394
service: total inventory turnovers 4.63 1302 556
service: total monetary turnovers 6.67 31 800
service: aggregate perf. data 0.78 22119 93
service: refresh index statistics 0.03 237646 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2021 16:32:27 to 12-03-2021 16:32:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5089
TEST_TIME 2 4236
TEST_TIME 3 5667
TEST_TIME 4 6267
TEST_TIME 5 6232
TEST_TIME 6 6333
TEST_TIME 7 6996
TEST_TIME 8 6576
TEST_TIME 9 6799
TEST_TIME 10 6722
TEST_TIME 11 6647
TEST_TIME 12 6597
TEST_TIME 13 6640
TEST_TIME 14 6701
TEST_TIME 15 6840
TEST_TIME 16 6870
TEST_TIME 17 7582
TEST_TIME 18 8061
TEST_TIME 19 7993
TEST_TIME 20 8494
TEST_TIME 21 8360
TEST_TIME 22 8836
TEST_TIME 23 8894
TEST_TIME 24 8929
TEST_TIME 25 9056
TEST_TIME 26 9216
TEST_TIME 27 9070
TEST_TIME 28 9255
TEST_TIME 29 9318
TEST_TIME 30 10332
TEST_TIME 31 10629
TEST_TIME 32 11199
TEST_TIME 33 10999
TEST_TIME 34 10859
TEST_TIME 35 11131
TEST_TIME 36 10979
TEST_TIME 37 10844
TEST_TIME 38 10709
TEST_TIME 39 10662
TEST_TIME 40 10667
TEST_TIME 41 10476
TEST_TIME 42 10317
TEST_TIME 43 10353
TEST_TIME 44 10340
TEST_TIME 45 10176
TEST_TIME 46 10192
TEST_TIME 47 10141
TEST_TIME 48 10072
TEST_TIME 49 10121
TEST_TIME 50 10186
TEST_TIME 51 10155
TEST_TIME 52 10089
TEST_TIME 53 10015
TEST_TIME 54 9849
TEST_TIME 55 9967
TEST_TIME 56 9851
TEST_TIME 57 9816
TEST_TIME 58 9784
TEST_TIME 59 9814
TEST_TIME 60 9818
TEST_TIME 61 9828
TEST_TIME 62 9823
TEST_TIME 63 10063
TEST_TIME 64 10012
TEST_TIME 65 9972
TEST_TIME 66 9990
TEST_TIME 67 10075
TEST_TIME 68 10047
TEST_TIME 69 10004
TEST_TIME 70 10052
TEST_TIME 71 10107
TEST_TIME 72 10137
TEST_TIME 73 10064
TEST_TIME 74 9966
TEST_TIME 75 9941
TEST_TIME 76 9893
TEST_TIME 77 9853
TEST_TIME 78 9813
TEST_TIME 79 9802
TEST_TIME 80 9726
TEST_TIME 81 9738
TEST_TIME 82 9718
TEST_TIME 83 9662
TEST_TIME 84 9666
TEST_TIME 85 9642
TEST_TIME 86 9631
TEST_TIME 87 9631
TEST_TIME 88 9690
TEST_TIME 89 9664
TEST_TIME 90 9666
TEST_TIME 91 9758
TEST_TIME 92 9757
TEST_TIME 93 9802
TEST_TIME 94 9758
TEST_TIME 95 9824
TEST_TIME 96 9802
TEST_TIME 97 9832
TEST_TIME 98 9859
TEST_TIME 99 9819
TEST_TIME 100 9755
TEST_TIME 101 9784
TEST_TIME 102 9741
TEST_TIME 103 9702
TEST_TIME 104 9723
TEST_TIME 105 9664
TEST_TIME 106 9662
TEST_TIME 107 9677
TEST_TIME 108 9641
TEST_TIME 109 9575
TEST_TIME 110 9618
TEST_TIME 111 9578
TEST_TIME 112 9546
TEST_TIME 113 9588
TEST_TIME 114 9578
TEST_TIME 115 9556
TEST_TIME 116 9598
TEST_TIME 117 9605
TEST_TIME 118 9614
TEST_TIME 119 9652
TEST_TIME 120 9647

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-03-2021 16:32:30 to 12-03-2021 16:32:34.

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 1595566 1595566 0 0.00 0 18187 6 0 0
doc_list_biud 1595563 1595563 0 0.00 0 56976 26 0 0
sp_add_invoice_to_stock 5233 5112 121 2.31 32 205412 18844 0 121
sp_cancel_adding_invoice 6012 6012 0 0.00 3 93386 737 0 0
sp_cancel_client_order 1760 1760 0 0.00 4 15662 332 0 0
sp_cancel_customer_reserve 594150 594150 0 0.00 1 56979 55 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 3 6830 104 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 5427 100 0 0
sp_cancel_supplier_invoice 6666 6661 5 0.07 2 14926 747 0 5
sp_cancel_supplier_order 442 442 0 0.00 5 1036977 93684 0 0
sp_cancel_write_off 10995 10995 0 0.00 1 9327 101 0 0
sp_client_order 20966 20966 0 0.00 4 16157 339 0 0
sp_customer_reserve 474298 474298 0 0.00 0 84324 186 0 0
sp_fill_shopping_cart 32145 32145 0 0.00 1 11656 35 0 0
sp_fill_shopping_cart_clo_res 474293 474293 0 0.00 0 24173 13 0 0
sp_get_clo_for_invoice 5107 5107 0 0.00 0 19249 258 0 0
sp_kill_cost_storno 18086 18086 0 0.00 0 7670 52 0 0
sp_kill_qstorno_ret_qs2qd 1206398 1206398 0 0.00 0 56969 30 0 0
sp_kill_qty_storno 635489 635489 0 0.00 0 56974 64 0 0
sp_lock_selected_doc 21339 21339 0 0.00 0 11587 6 0 0
sp_make_cost_storno 28367 28367 0 0.00 0 13108 62 0 0
sp_multiply_rows_for_pdistr 28367 28367 0 0.00 0 7297 30 0 0
sp_multiply_rows_for_qdistr 20966 20966 0 0.00 0 13508 148 0 0
sp_pay_from_customer 7193 7193 0 0.00 4 14039 134 0 0
sp_pay_to_supplier 5703 5703 0 0.00 5 12110 146 0 0
sp_payment_common 12896 12896 0 0.00 1 14034 41 0 0
sp_qd_handle_on_cancel_clo 1760 1760 0 0.00 0 15486 300 0 0
sp_qd_handle_on_invoice_upd_sts 11117 11117 0 0.00 0 16801 306 0 0
sp_qd_handle_on_reserve_upd_sts 10364 10364 0 0.00 0 13724 55 0 0
sp_reserve_write_off 10364 10364 0 0.00 6 13747 180 0 0
sp_supplier_invoice 5608 5608 0 0.00 7 79090 3396 0 0
sp_supplier_order 5577 5577 0 0.00 5 27671 1392 0 0
srv_aggregate_perf_data 94 93 1 1.06 2938 213892 22120 0 1
srv_fill_mon_cache_memory 176 176 0 0.00 1017 119288 29437 0 0
srv_find_qd_qs_mism 1108544 1108544 0 0.00 0 18187 5 0 0
srv_make_invnt_saldo 556 556 0 0.00 61 131711 1303 0 0
srv_make_money_saldo 800 800 0 0.00 0 2078 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 95918 373034 237646 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 5112 5112 0 0.00 0 10165 183 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 7179 147 0 0
t$perf-norm:sp_cancel_client_order 1760 1760 0 0.00 0 2376 19 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 2376 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 599 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 1465 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 3113 24 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 23198 1546 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 1863 13 0 0
t$perf-norm:sp_client_order 20966 20966 0 0.00 0 7256 20 0 0
t$perf-norm:sp_customer_reserve 1036 1036 0 0.00 0 2242 5 0 0
t$perf-norm:sp_pay_from_customer 7193 7193 0 0.00 0 6550 15 0 0
t$perf-norm:sp_pay_to_supplier 5703 5703 0 0.00 0 6170 11 0 0
t$perf-norm:sp_reserve_write_off 10364 10364 0 0.00 0 20994 16 0 0
t$perf-norm:sp_supplier_invoice 5608 5608 0 0.00 0 2398 17 0 0
t$perf-norm:sp_supplier_order 5577 5577 0 0.00 0 7038 18 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 70 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 1407 19 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 1070 22 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 20191 40 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10452 10210 242 2.31 0 7387 24 0 242
v_all_customers 37988 37988 0 0.00 0 30 1 0 0
v_all_suppliers 30418 30418 0 0.00 0 32 1 0 0
v_all_wares 41932 41932 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 1654 10 0 0
v_cancel_client_order 3520 3520 0 0.00 0 3354 5 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 5633 13 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 3473 14 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 3925 14 0 0
v_cancel_supplier_invoice 822 812 10 1.21 0 1159 18 0 10
v_cancel_supplier_order 884 884 0 0.00 0 1278 7 0 0
v_cancel_write_off 2140 2140 0 0.00 0 4673 21 0 0
v_max_id_clo_ord 5577 5577 0 0.00 0 4859 3 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 6645 16 0 0
v_max_id_ord_sup 5602 5602 0 0.00 0 4464 2 0 0
v_max_non_paid_invoice 1673 1673 0 0.00 0 494 4 0 0
v_max_non_paid_realizn 3985 3985 0 0.00 0 2114 4 0 0
v_min_id_clo_ord 5577 5577 0 0.00 0 4001 8 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 3665 5 0 0
v_min_id_ord_sup 5602 5602 0 0.00 0 4127 4 0 0
v_min_non_paid_invoice 5703 5703 0 0.00 0 8173 25 0 0
v_min_non_paid_realizn 7193 7193 0 0.00 0 12483 27 0 0
v_our_firm 10358 10358 0 0.00 0 19 1 0 0
v_reserve_write_off 20728 20728 0 0.00 0 4647 9 0 0
x_lock_depdocs_on_canc_invoice 12267 12267 0 0.00 0 21163 114 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 4236 314 0 0
x_make_qstorno_1000_1200 5577 5577 0 0.00 2 27665 1300 0 0
x_make_qstorno_1200_2000 5608 5608 0 0.00 3 78066 3284 0 0
x_make_qstorno_2100_3300 474298 474298 0 0.00 0 84323 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2021 16:32:35 to 12-03-2021 16:32:39.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:44 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:51 7509 8192000000 10153157808 10449051648 920728448 10.103 75 62 124 1 945306816 2736464 21841904
14:02:19 32886 8192000000 10344411632 10659037184 1378589648 14.404 100 86 172 0 1411497552 5108416 27799488
14:03:02 20752 8192000000 10360047216 10682556416 1425106016 14.818 100 83 166 0 1458782720 6524416 27152288
14:03:31 18665 8192000000 10391354432 10716008448 1447710368 15.018 100 86 173 0 1482939264 7273408 27955488
14:04:00 19265 8192000000 10416581376 10746089472 1470635376 15.219 100 87 172 1 1506571552 7858320 28077856
14:04:35 23823 8192000000 10444034704 10776363008 1498873856 15.466 100 92 184 1 1536913200 8722672 29316672
14:05:10 16238 8192000000 10465644512 10798989312 1516696800 15.622 100 90 180 1 1554380672 8898416 28785456
14:05:34 25010 8192000000 10487980368 10826981376 1539798704 15.822 100 88 176 1 1576321872 9145408 27377760
14:06:16 18455 8192000000 10515760816 10859929600 1564205952 16.032 100 74 148 1 1596662752 9917936 22538864
14:06:44 14373 8192000000 10524073280 10875990016 1584708208 16.209 100 80 160 1 1619939184 10454704 24776272
14:07:15 10591 8192000000 10539766800 10897043456 1605438832 16.386 100 73 146 0 1637587872 9566928 22582112
14:07:34 13286 8192000000 10572793440 10932027392 1633508864 16.625 100 75 148 4 1665356432 9889392 21958176
14:07:54 13269 8192000000 10594011760 10960990208 1653777248 16.796 100 75 150 0 1686569456 10244592 22547616
14:08:21 9016 8192000000 10620476960 10992214016 1691786176 17.116 100 74 148 1 1723667424 9989488 21891760
14:08:39 10162 8192000000 10641073424 11013795840 1706948640 17.243 100 70 138 0 1737476384 10573056 19954688
14:08:57 9692 8192000000 10659010976 11037356032 1727804016 17.417 100 68 136 2 1758156144 10987872 19364256
14:09:15 5847 8192000000 10676026672 11056304128 1750223840 17.603 100 76 152 1 1782975120 11580768 21170512
14:09:28 8278 8192000000 10700103232 11079618560 1762385760 17.704 100 79 158 1 1797092320 12237408 22469152
14:09:45 6469 8192000000 10711489904 11091714048 1774022944 17.800 100 83 166 0 1810729008 13438704 23267360
14:09:59 4701 8192000000 10718947488 11102294016 1782763040 17.872 100 84 168 1 1819888032 13596480 23528512
14:10:12 8256 8192000000 10720284048 11103051776 1786817680 17.906 100 82 163 0 1823723168 14361136 22544352
14:10:30 3871 8192000000 10743443328 11125596160 1805318000 18.058 100 84 168 3 1843987808 14619536 24050272
14:10:41 3467 8192000000 10753627296 11136032768 1808818416 18.086 100 76 150 2 1844989504 14721744 21449344
14:10:51 3590 8192000000 10770023936 11151667200 1822665456 18.199 100 93 187 1 1863590544 14677600 26247488
14:11:02 2785 8192000000 10764177328 11154063360 1824020640 18.211 100 83 165 0 1861564032 14918288 22625104
14:11:12 2859 8192000000 10771768880 11156328448 1829117328 18.252 100 87 176 1 1867942480 13444064 25381088
14:11:21 2904 8192000000 10763324384 11159302144 1832293104 18.278 100 74 145 3 1865197712 12698288 20206320
14:11:31 2164 8192000000 10781782336 11166048256 1839283056 18.335 100 86 172 0 1876825424 12875024 24667344
14:11:40 2539 8192000000 10780215024 11169644544 1846939632 18.397 100 89 178 1 1884415648 12316752 25159264
14:11:49 2464 8192000000 10790043072 11174952960 1845824560 18.388 100 92 184 2 1883916448 12629840 25462048
14:11:58 2765 8192000000 10782585216 11174371328 1850251520 18.424 100 79 154 3 1884566672 13068144 21247008
14:12:08 2413 8192000000 10791608768 11178012672 1850515536 18.426 100 85 170 1 1888268832 13441488 24311808
14:12:17 1491 8192000000 10806179568 11190865920 1859234272 18.497 100 93 186 1 1899956672 14561696 26160704
14:12:24 1962 8192000000 10809280288 11193323520 1862056800 18.520 100 95 188 0 1904017216 16066624 25893792
14:12:33 1714 8192000000 10811931344 11197231104 1866047920 18.552 100 95 190 1 1908194128 16009264 26136944
14:12:41 2380 8192000000 10812711264 11198509056 1865507568 18.548 100 94 189 2 1907974048 15206464 27260016
14:12:50 1748 8192000000 10813258128 11200450560 1867962992 18.568 100 90 181 1 1908718752 13979440 26776320
14:12:58 1643 8192000000 10817797392 11204915200 1872497632 18.604 100 96 192 1 1913468032 12705984 28264416
14:13:05 2177 8192000000 10819468208 11206479872 1875820320 18.631 100 92 185 1 1915910288 13981472 26108496
14:13:14 41096 8192000000 10787139264 11199889408 1873056240 18.609 100 64 126 1 1903709328 12462624 18190464
14:14:03 9695 8192000000 10827624048 11219988480 1881223824 18.675 100 87 175 1 1916313728 9469440 25620464
14:14:18 12586 8192000000 10780970240 11207856128 1871676128 18.598 100 35 69 1 1890335392 9208832 9450432
14:14:38 2261 8192000000 10804771392 11216203776 1876224416 18.635 100 43 84 1 1899213616 10665344 12323856
14:14:46 4951 8192000000 10790970016 11212300288 1875761232 18.631 100 37 74 0 1894445328 8510048 10174048
14:14:57 5464 8192000000 10788308736 11212025856 1875601088 18.630 100 35 70 0 1893144640 7330368 10213184
14:15:12 7218 8192000000 10797836384 11221950464 1878460704 18.653 100 35 70 2 1900032256 12002736 9568816
14:15:31 5360 8192000000 10789636736 11217629184 1878716224 18.655 100 31 58 4 1893941536 6953280 8272032
14:15:44 8040 8192000000 10788815360 11219337216 1883525968 18.694 100 28 56 0 1898822848 7350176 7946704
14:16:03 4486 8192000000 10803166176 11221864448 1885406816 18.709 100 37 73 2 1902666480 7452144 9807520
14:16:17 7770 8192000000 10815248368 11230842880 1888516768 18.734 100 31 62 0 1903784288 5770608 9496912
14:16:33 10500 8192000000 10807321456 11232497664 1890890720 18.753 100 21 43 0 1903152784 6298608 5963456
14:16:50 11698 8192000000 10804979456 11236794368 1894733808 18.784 100 19 38 2 1906171552 5796160 5641584
14:17:12 18737 8192000000 10805517632 11239280640 1894457248 18.782 100 11 22 1 1907288960 10030016 2801696
14:17:37 8618 8192000000 10806181392 11242012672 1896717152 18.800 100 15 29 1 1906736432 6307904 3711376
14:17:57 77568 8192000000 10825078160 11254173696 1902835296 18.849 100 28 54 1 1916754528 6026128 7893104
14:19:22 13097 8192000000 10823684352 11253702656 1904406128 18.862 100 21 40 0 1915654928 5674000 5574800
14:19:43 7085 8192000000 10828622288 11259080704 1908979600 18.898 100 28 56 2 1922845488 6271792 7594096
14:19:58 5841 8192000000 10833106768 11262947328 1911666384 18.920 100 36 72 2 1928944784 7433728 9844672
14:20:13 7856 8192000000 10821115664 11254628352 1890877536 18.753 99 21 41 2 1903806192 5813120 7115536
14:20:28 7128 8192000000 10815111248 11248939008 1889693488 18.743 99 30 60 0 1903511088 5282096 8535504
14:20:42 6269 8192000000 10816804880 11253309440 1907107056 18.883 100 30 59 1 1922006336 6712256 8187024
14:20:55 5337 8192000000 10811346192 11254349824 1906014608 18.875 100 22 42 0 1918622064 6570752 6036704
14:21:10 7310 8192000000 10815086032 11245735936 1896274112 18.796 100 15 30 0 1906530096 5994064 4261920
14:21:24 6689 8192000000 10804230880 11242549248 1896117568 18.795 100 20 38 1 1907080112 5535856 5426688
14:21:40 9886 8192000000 10814916784 11250696192 1882296096 18.684 99 18 35 2 1892917136 5383136 5237904
14:21:57 6098 8192000000 10815930368 11248168960 1897581856 18.807 100 19 38 0 1909359008 6729440 5047712
14:22:11 8998 8192000000 10806022496 11229097984 1838859408 18.332 97 21 43 1 1851134992 5796448 6479136
14:22:26 8214 8192000000 10754982928 11188543488 1772864208 17.791 94 19 38 4 1783822816 5574032 5384576
14:22:40 6685 8192000000 10760073696 11188146176 1815209088 18.139 98 18 32 4 1825559472 5289264 5061120
14:22:54 6120 8192000000 10761706128 11182006272 1813941360 18.128 98 23 45 2 1830087696 10142896 6003440
14:23:07 17824 8192000000 10678153728 11090386944 1667437040 16.912 90 19 39 0 1678162320 4875088 5850192
14:23:32 65757 8192000000 10689354384 11105419264 1648604800 16.753 91 30 61 0 1662590768 5524320 8461648
14:24:46 10804 8192000000 10721025200 11138154496 1759644864 17.681 98 20 36 2 1770044720 4597328 5802528
14:25:04 9246 8192000000 10746138640 11168079872 1822399728 18.197 100 29 58 1 1841249520 11013520 7836272
14:25:21 6104 8192000000 10736359296 11160387584 1822957344 18.202 100 35 68 1 1839098512 6702224 9438944
14:25:33 8632 8192000000 10717224720 11143749632 1737131168 17.495 95 22 44 1 1748859568 5842960 5885440
14:25:48 8145 8192000000 10703838864 11111825408 1731093408 17.445 96 25 50 1 1743188384 5176160 6918816
14:26:04 11112 8192000000 10697496720 11117961216 1746925584 17.576 97 22 44 2 1758979600 5812304 6241712
14:26:25 9729 8192000000 10680826640 11089317888 1722776928 17.375 96 19 38 0 1733594016 5234640 5582448
14:26:46 10070 8192000000 10725770624 11144605696 1788176528 17.917 99 19 36 1 1798669904 5268448 5224928
14:27:02 9165 8192000000 10733902448 11152510976 1778988928 17.841 98 25 49 0 1791684752 5107312 7588512
14:27:18 12455 8192000000 10718159968 11141808128 1760178704 17.686 97 18 36 2 1770712336 4978160 5555472
14:27:38 12962 8192000000 10726150480 11149832192 1796803600 17.988 99 18 37 2 1807732848 5397584 5531664
14:27:59 8272 8192000000 10753001056 11171872768 1824284656 18.213 100 18 36 1 1834936896 5139760 5512480
14:28:20 11691 8192000000 10761010752 11173933056 1821636864 18.191 99 40 83 4 1839027760 5208080 12182816
14:28:38 73212 8192000000 10754803936 11182477312 1838416816 18.328 100 25 50 2 1850248464 4998112 6833536
14:29:58 12675 8192000000 10757711232 11180871680 1826861904 18.234 99 24 46 2 1839573744 6586432 6125408
14:30:19 10029 8192000000 10772221152 11191201792 1845820192 18.388 100 32 64 1 1861239104 5984944 9433968
14:30:36 6825 8192000000 10764978624 11190792192 1850100064 18.423 100 29 58 0 1864797584 5964368 8733152
14:30:51 5152 8192000000 10770292912 11195404288 1853510384 18.451 100 32 64 0 1869627392 7043040 9073968
14:31:03 7465 8192000000 10780592016 11207348224 1868994592 18.576 100 28 56 1 1882471600 4984416 8492592
14:31:16 7407 8192000000 10789539872 11215867904 1876416592 18.636 100 22 42 2 1887053248 4966976 5669680
14:31:32 14534 8192000000 10792246624 11222999040 1879751040 18.663 100 18 36 0 1890177696 4771072 5655584
14:32:10 4229 8192000000 10835974384 11245277184 1899368784 18.821 100 58 115 1 1923021088 6936560 16715744
14:32:31 12628 8192000000 10842076160 11257077760 1905441248 18.870 100 54 104 2 1931016224 10800784 14774192
14:33:05 55098 8192000000 10851556992 11273461760 1915704704 18.952 100 42 84 2 1938454288 11038944 11710640
14:34:15 9652 8192000000 10865419152 11282137088 1924738608 19.025 100 44 88 0 1949365232 12303552 12323072
14:34:32 7106 8192000000 10875043840 11289858048 1924880912 19.026 100 49 99 0 1951303008 11348624 15073472
14:34:47 31002 8192000000 10855799968 11293646848 1929719504 19.065 100 45 90 1 1955175168 12326368 13129296
14:35:25 3979 8192000000 10870244832 11299770368 1936837920 19.122 100 48 96 1 1961497584 11103056 13556608
14:35:38 16516 8192000000 10878575184 11305095168 1941554384 19.159 100 58 116 2 1970884384 12947008 16382992
14:36:20 12984 8192000000 10869211184 11288576000 1917271888 18.965 99 52 105 1 1947294544 15098208 14924448
14:36:42 16315 8192000000 10890804864 11308290048 1942067360 19.163 100 60 119 2 1977118816 18729488 16321968
14:37:06 7829 8192000000 10885035168 11315507200 1946969472 19.202 100 72 145 1 1986718752 19440416 20308864
14:37:23 5433 8192000000 10899126192 11324669952 1952341152 19.245 100 69 138 1 1992476512 19490704 20644656
14:37:36 8411 8192000000 10896869952 11323867136 1952206064 19.244 100 56 112 1 1987368080 19098672 16063344
14:38:08 5147 8192000000 10911455776 11334561792 1960535968 19.310 100 56 111 1 1996278800 19192944 16549888
14:38:33 9458 8192000000 10902475344 11340615680 1963843968 19.337 100 48 94 2 1998746160 20878576 14023616
14:38:55 4718 8192000000 10926418544 11343642624 1975002576 19.425 100 75 148 1 2012883984 16523024 21358384
14:39:07 10248 8192000000 10915433888 11343687680 1972303712 19.404 100 58 116 3 2005965920 17065424 16596784
14:39:34 15433 8192000000 10910371616 11347083264 1971955824 19.401 100 45 88 1 2002634672 17884320 12794528
14:39:56 8623 8192000000 10923746320 11359301632 1980820784 19.471 100 52 104 0 2017464944 20920352 15723808
14:40:28 5714 8192000000 10929286944 11358871552 1983289040 19.491 100 57 114 2 2019528720 18939728 17299952
14:40:40 9972 8192000000 10931045680 11364040704 1987313152 19.523 100 65 124 0 2024718912 18776624 18629136
14:41:02 10351 8192000000 10932543952 11366019072 1987200976 19.522 100 55 110 1 2023794240 19956208 16637056
14:41:23 6668 8192000000 10930568048 11366326272 1983444128 19.492 100 48 96 1 2017995152 20945216 13605808
14:41:38 7834 8192000000 10936477632 11367555072 1987653984 19.525 100 52 104 1 2023787104 20472336 15660784
14:41:53 5580 8192000000 10929419712 11357294592 1951100384 19.235 98 53 106 1 1986661616 19717056 15844176
14:42:06 5500 8192000000 10927864656 11350663168 1971485984 19.397 100 70 140 2 2013942704 21427824 21028896
14:42:19 11104 8192000000 10916280240 11342938112 1964425872 19.341 100 52 104 0 2002248432 22209280 15613280
14:42:46 11102 8192000000 10900585008 11328458752 1949776544 19.225 99 48 94 0 1985551360 21368608 14406208
14:43:05 11097 8192000000 10906234832 11336581120 1941537040 19.159 99 47 94 1 1977927664 22001840 14388784
14:43:24 6454 8192000000 10920763728 11348533248 1968253120 19.372 100 59 113 3 2007579584 21520144 17806320
14:43:37 8973 8192000000 10903720032 11330551808 1956810080 19.281 100 59 118 3 1997338320 22621376 17906864
14:43:55 7105 8192000000 10913656144 11336364032 1961052480 19.314 100 62 124 1 2002311920 22812096 18447344
14:44:14 9344 8192000000 10917697280 11344961536 1965504752 19.350 100 55 107 0 2005709488 23922560 16282176
14:44:33 1594 8192000000 10920305968 11336818688 1961224592 19.316 100 69 137 3 2005288272 23701120 20362560
14:44:42 5668 8192000000 10931181680 11350540288 1966025264 19.354 100 67 134 0 2015711072 29678368 20007440
14:44:57 2415 8192000000 10942911888 11361226752 1977003184 19.441 100 72 144 0 2025619728 26822176 21794368
14:45:07 4471 8192000000 10933598752 11355029504 1956789312 19.281 99 71 142 2 2005350064 27501184 21059568
14:45:22 4841 8192000000 10930289824 11355947008 1976346704 19.436 100 72 145 2 2024000976 25287984 22366288
14:45:35 7099 8192000000 10953774560 11369721856 1984479664 19.500 100 91 182 0 2039698704 27392336 27826704
14:45:49 4752 8192000000 10922935312 11349065728 1964400800 19.341 100 58 116 1 2010877072 28651472 17824800
14:46:02 15427 8192000000 10918010000 11350106112 1966673328 19.359 100 59 118 2 2013466208 28553520 18239360
14:46:26 7021 8192000000 10888269696 11311620096 1925688912 19.032 98 51 102 0 1971744096 30121392 15933792
14:46:42 5676 8192000000 10917907456 11338813440 1949903952 19.226 100 62 124 2 1999005696 29982416 19119328
14:46:55 7243 8192000000 10907717024 11336142848 1952799968 19.249 100 58 114 1 2002745712 31815104 18130640
14:47:10 3760 8192000000 10902844624 11317387264 1917175792 18.964 98 70 139 0 1971663792 33180752 21307248
14:47:20 3605 8192000000 10927250832 11341770752 1953143440 19.252 100 86 172 2 2012555088 32667792 26743856
14:47:30 7095 8192000000 10933077600 11348692992 1959173856 19.299 100 66 131 3 2013577520 34374320 20029344
14:47:45 7083 8192000000 10919615072 11334414336 1928990976 19.059 98 74 147 0 1988717360 37767312 21959072
14:47:59 1645 8192000000 10930521216 11351420928 1956285920 19.277 100 76 149 2 2017874592 37851472 23737200
14:48:13 2702 8192000000 10945587536 11354062848 1960726864 19.312 100 82 163 2 2021808512 36326560 24755088
14:48:23 3030 8192000000 10939813520 11355549696 1961932016 19.321 100 80 161 1 2022663264 36095072 24636176
14:48:33 3553 8192000000 10937999728 11348746240 1957886688 19.289 100 89 178 1 2018915504 33040224 27988592
14:48:43 1016 8192000000 10935732016 11342950400 1954703584 19.264 100 94 188 2 2017515968 33919600 28892784
14:48:51 1059 8192000000 10926304688 11333066752 1945014208 19.187 99 94 190 1 2008121872 34373088 28734576
14:48:59 2823 8192000000 10908144368 11324743680 1912953664 18.930 98 74 148 2 1970459264 35110416 22395184
14:49:09 9274 8192000000 10870245696 11306553344 1907293008 18.885 99 41 81 1 1953038224 32904288 12840928
14:49:28 2947 8192000000 10901152896 11315761152 1928419360 19.054 100 70 138 1 1983694752 33245344 22030048
14:49:38 5678 8192000000 10902649680 11317231616 1930975920 19.075 100 75 147 1 1989524416 35349936 23198560
14:49:51 1952 8192000000 10892145104 11290419200 1893266336 18.772 99 87 174 0 1955374416 35588064 26520016
14:49:59 6281 8192000000 10881825520 11301023744 1911728752 18.921 100 52 104 1 1964598576 36831664 16038160
14:50:14 6114 8192000000 10853533120 11263164416 1826820816 18.233 95 66 132 3 1881156816 33439152 20896848
14:50:26 4988 8192000000 10869913824 11286032384 1896401360 18.797 100 68 135 0 1952097584 34445920 21250304
14:50:41 3349 8192000000 10869970624 11283996672 1889941344 18.745 99 66 132 1 1946822736 36427168 20454224
14:50:54 3007 8192000000 10897771888 11301822464 1908423984 18.894 100 88 174 3 1976862624 41134896 27303744
14:51:06 4961 8192000000 10890640384 11294552064 1894992912 18.786 99 83 166 5 1965539712 45353152 25193648
14:51:19 2036 8192000000 10906729424 11314581504 1915584896 18.951 100 90 180 5 1989937184 46482128 27870160
14:51:27 2102 8192000000 10907358336 11314323456 1921479360 18.999 100 78 156 0 1990726736 45716352 23531024
14:51:36 2509 8192000000 10915260880 11331817472 1930226208 19.069 100 68 136 1 1995357360 44016224 21114928
14:51:50 2262 8192000000 10910953456 11332476928 1930673472 19.072 100 54 108 1 1989793056 42638992 16480592
14:52:08 3155 8192000000 10910172928 11324514304 1930882288 19.074 100 78 155 3 1995892240 39692112 25317840
14:52:26 4439 8192000000 10919784800 11328434176 1919864240 18.986 99 74 151 1 1987065696 44062704 23138752
14:52:37 3362 8192000000 10933263712 11341393920 1940388608 19.150 100 77 154 1 2011874160 47494240 23991312
14:52:50 3492 8192000000 10931971632 11341742080 1941061792 19.155 100 82 164 1 2013662640 46799680 25801168
14:53:00 6171 8192000000 10927429792 11343462400 1925103904 19.028 99 71 142 0 1995954208 48403920 22446384
14:53:12 10446 8192000000 10913972288 11345514496 1935817232 19.113 100 49 98 2 1999903232 47799136 16286864
14:53:36 9812 8192000000 10899524496 11338592256 1934664192 19.104 100 39 78 3 1987495568 39260032 13571344
14:53:55 14082 8192000000 10867280608 11296038912 1883640032 18.694 97 42 84 0 1933993616 36705328 13648256
14:54:21 14269 8192000000 10891949280 11317112832 1914486416 18.943 100 47 95 1 1970403040 40516704 15399920
14:54:43 5998 8192000000 10873914192 11289911296 1887635392 18.727 99 58 115 1 1949229696 43160128 18434176
14:55:02 3936 8192000000 10869784368 11288821760 1893988416 18.778 99 56 108 3 1952027648 40881744 17157488
14:55:16 3564 8192000000 10901135904 11326234624 1922286560 19.005 100 53 104 0 1986258176 47530416 16441200
14:55:34 4498 8192000000 10900833776 11325857792 1928535024 19.055 100 51 101 1 1985379104 40595408 16248672
14:55:46 4135 8192000000 10896606384 11322441728 1909264704 18.901 99 45 90 0 1965042016 41434032 14343280
14:56:12 8300 8192000000 10887224608 11319308288 1904150256 18.860 99 41 82 0 1960699376 42240544 14308576
14:56:33 5637 8192000000 10898406976 11327066112 1896721056 18.800 98 58 116 2 1960226448 44752544 18752848
14:56:45 3422 8192000000 10893064912 11321208832 1904938096 18.866 99 46 92 1 1959839584 39535504 15365984
14:56:54 5598 8192000000 10895300288 11325272064 1921479472 18.999 100 44 88 1 1976205136 40512864 14212800
14:57:15 11868 8192000000 10886401232 11334201344 1925098464 19.028 100 25 49 1 1973133760 39255616 8779680
14:57:34 19066 8192000000 10887527648 11318894592 1917590896 18.968 99 34 68 0 1966266640 37488896 11186848
14:58:03 23571 8192000000 10898869536 11338723328 1934969808 19.107 100 25 50 0 1982360368 39230064 8160496
14:58:33 19845 8192000000 10893257584 11330183168 1915198720 18.948 99 30 60 4 1968313488 43240368 9874400
14:59:14 25392 8192000000 10905014256 11355262976 1925691664 19.032 100 28 56 0 1991264928 55142080 10431184
14:59:57 30243 8192000000 10912053072 11354664960 1920556208 18.991 100 24 48 1 1987721488 57540704 9624576
15:00:40 27545 8192000000 10904958880 11352035328 1923977216 19.019 100 28 56 0 1998924928 64297344 10650368
15:01:24 32482 8192000000 10894096704 11355869184 1939117472 19.140 100 23 45 3 1982606448 35922816 7566160
15:02:07 42224 8192000000 10892742864 11357044736 1938409680 19.134 100 15 30 1 1976973584 33806256 4757648
15:02:56 50319 8192000000 10877610496 11351121920 1936690112 19.120 100 7 14 0 1974862032 36215712 1956208
15:03:54 58870 8192000000 10887369904 11328999424 1929931808 19.066 99 12 24 1 1941865584 8874608 3059168
15:05:00 23654 8192000000 10905066992 11351420928 1962120256 19.323 100 32 62 0 1980033568 10032912 7880400
15:05:37 31216 8192000000 10906519856 11365416960 1965097728 19.347 100 12 25 0 1981019056 12692912 3228416
15:06:14 68069 8192000000 10899029328 11353989120 1963743520 19.336 100 8 16 1 1978567264 12825776 1997968
15:07:29 29033 8192000000 10929101856 11369795584 1973316016 19.412 100 30 58 2 1990079280 8105264 8658000
15:08:04 54305 8192000000 10942032256 11381063680 1983833088 19.495 100 34 64 2 1999701376 7264992 8603296
15:09:34 89366 8192000000 10917919248 11388227584 1968628448 19.375 99 27 54 3 1993932608 17512128 7792032
15:11:10 48970 8192000000 10916183856 11376222208 1966622448 19.359 99 26 53 1 1983685328 10522160 6540720
15:12:06 81237 8192000000 10919758304 11383799808 1985486352 19.508 100 22 39 2 1997665616 6747200 5432064
15:13:34 86231 8192000000 10932198592 11410329600 1977486816 19.445 99 27 53 1 2000377872 15760000 7131056
15:15:08 64667 8192000000 10919329472 11397103616 1993986944 19.575 100 28 56 0 2018462368 16390688 8084736
15:16:32 27831 8192000000 10922583648 11388579840 1978057712 19.449 99 27 54 1 1993818640 8301328 7459600
15:17:06 36864 8192000000 10908050208 11385675776 1972023888 19.401 99 14 28 2 1985397520 9427040 3946592
15:18:08 27087 8192000000 10923504768 11396501504 1994400176 19.579 100 39 78 1 2021486768 15133600 11952992
15:18:44 21378 8192000000 10930384672 11383250944 1962590000 19.327 98 35 71 2 1983653360 9699184 11364176
15:19:26 56439 8192000000 10943501664 11408359424 1995284688 19.586 100 40 80 0 2023041888 16094496 11662704
15:22:25 42531 8192000000 10893825696 11383840768 1960061856 19.307 99 5 8 0 1973000416 11270704 1667856
15:23:14 18791 8192000000 10900458816 11373735936 1981565072 19.477 100 17 27 3 1991097792 6237488 3295232
15:23:38 33102 8192000000 10888926720 11366559744 1946274800 19.197 98 12 24 1 1955978688 6198560 3505328
15:24:18 74818 8192000000 10906074448 11382706176 1967222000 19.363 99 22 44 1 1982999872 9566576 6211296
15:26:00 83539 8192000000 10904987808 11402588160 1985437312 19.508 100 21 42 0 2005066864 13765328 5864224
15:27:30 23969 8192000000 10889051776 11369570304 1946332160 19.197 98 10 20 1 1963658640 14720816 2605664
15:28:05 85952 8192000000 10884358368 11378499584 1960033456 19.306 99 14 28 0 1974691168 10436544 4221168
15:29:38 43707 8192000000 10839498672 11313217536 1872706992 18.606 95 7 14 0 1886918320 12241696 1969632
15:30:33 81969 8192000000 10883030496 11373101056 1932277232 19.085 99 14 28 0 1954901328 18406992 4217104
15:32:01 100297 8192000000 10898924448 11384729600 1869563648 18.581 95 15 30 0 1898550352 24851344 4135360
15:33:47 82129 8192000000 10905636224 11373314048 1946403408 19.198 99 12 24 0 1971938608 22655776 2879424
15:35:21 26845 8192000000 10890045856 11354542080 1933623248 19.096 98 13 26 2 1944844144 7833136 3387760
15:35:54 35626 8192000000 10901392688 11351564288 1872972320 18.608 95 25 50 0 1891827648 11394192 7461136
15:36:45 16308 8192000000 10908564608 11363160064 1962830464 19.329 100 53 105 1 1991330672 13752944 14747264
15:37:14 48925 8192000000 10914298576 11375464448 1969068544 19.378 100 47 94 0 2001738720 19595056 13075120
15:38:10 90403 8192000000 10905305952 11347111936 1830993984 18.267 93 23 44 0 1853927968 16814880 6119104
15:39:50 44920 8192000000 10795731392 11249606656 1704763456 17.225 89 21 42 0 1720194016 9483728 5946832
15:40:45 34385 8192000000 10850031152 11302699008 1884138192 18.699 99 28 56 2 1903254256 11403744 7712320
15:41:27 23302 8192000000 10848205408 11306094592 1870906416 18.592 98 34 68 0 1895476384 14006992 10562976
15:42:00 78695 8192000000 10837465568 11311955968 1852489344 18.442 97 20 40 0 1874999360 17136720 5373296
15:44:06 71624 8192000000 10876567376 11322859520 1896151104 18.795 98 20 40 0 1908907520 7661824 5094592
15:45:30 88081 8192000000 10828021264 11293552640 1875784400 18.631 97 38 75 2 1895738624 8991552 10962672
15:47:10 46017 8192000000 10858230208 11310391296 1880468032 18.669 98 22 44 1 1894502528 8759296 5275200
15:48:05 70698 8192000000 10854531648 11322900480 1922903136 19.010 100 20 40 1 1936869360 8803296 5162928
15:49:24 53296 8192000000 10832140384 11313967104 1874741184 18.623 97 18 36 2 1891856080 11917424 5197472
15:50:38 81080 8192000000 10844500848 11306582016 1896030320 18.794 99 9 18 0 1911502176 12978400 2493456
15:52:08 38421 8192000000 10857991488 11332079616 1924748256 19.025 100 24 49 1 1947443584 15562416 7132912
15:52:55 58059 8192000000 10858682400 11337043968 1941198096 19.156 100 17 34 0 1959928560 12978944 5751520
15:54:08 65355 8192000000 10858941232 11342737408 1923425776 19.014 99 19 40 0 1940457568 10753168 6278624
15:55:19 51149 8192000000 10846403488 11331354624 1915050272 18.947 99 12 24 0 1928876144 10941040 2884832
15:56:17 34079 8192000000 10860087424 11330969600 1921558576 18.999 99 24 48 2 1937252672 8462304 7231792
15:56:58 75439 8192000000 10878004640 11360837632 1951990128 19.242 100 18 36 1 1965927936 8971104 4966704
15:58:29 39220 8192000000 10888921680 11357601792 1962315648 19.324 100 22 44 1 1978599328 9952480 6331200
15:59:56 40377 8192000000 10901822672 11370422272 1952047632 19.243 99 23 46 2 1967162720 9052032 6063056
16:00:42 65190 8192000000 10918773072 11397820416 1982302720 19.483 100 21 42 2 1998372832 10078512 5991600
16:01:53 56398 8192000000 10891366960 11382317056 1953170992 19.252 99 10 20 0 1968405056 12918784 2315280
16:02:56 56877 8192000000 10920797168 11389550592 1985181168 19.506 100 22 44 2 2001770672 9860176 6729328
16:03:59 47267 8192000000 10902377472 11374665728 1962677888 19.327 99 13 26 0 1974987744 9089552 3220304
16:04:55 91756 8192000000 10909816624 11395817472 1930857936 19.074 97 14 28 1 1945496288 10959504 3678848
16:06:46 33292 8192000000 10929468512 11391942656 1984334368 19.499 100 17 34 0 2000457536 11487360 4635808
16:07:34 39501 8192000000 10904876176 11392733184 1953133568 19.251 98 21 42 0 1972470800 13350752 5986480
16:08:28 119288 8192000000 10922030656 11391610880 1949596096 19.223 98 15 30 1 1967316864 13496384 4224384
16:10:34 35921 8192000000 10935580384 11406573568 2003748448 19.652 100 43 86 4 2027729312 11274896 12705968
16:12:01 112824 8192000000 10927146304 11421814784 1998462896 19.611 100 14 28 0 2017718960 14990848 4265216
16:14:01 12912 8192000000 10921757984 11416817664 1982800880 19.487 99 10 20 1 2002889776 17069376 3019520
16:14:20 58030 8192000000 10914764176 11398488064 1967414144 19.365 98 19 36 1 1986093456 13636192 5043120
16:15:25 54443 8192000000 10904641616 11395899392 1952291744 19.245 98 6 12 0 1968157312 14136976 1728592
16:16:49 48807 8192000000 10905443296 11380400128 1980651840 19.470 100 21 42 0 1999107120 11919760 6535520
16:17:50 43977 8192000000 10909495408 11384958976 1964229680 19.340 99 19 33 1 1975350032 6928928 4191424
16:18:45 51041 8192000000 10894862896 11371413504 1913235440 18.933 96 19 38 0 1932680768 13951776 5493552
16:19:43 79536 8192000000 10890249296 11360481280 1891140688 18.755 96 13 26 0 1904588256 9541712 3905856
16:21:18 63310 8192000000 10884293680 11377184768 1941732432 19.161 99 10 20 0 1957240672 12849648 2658592
16:22:27 68866 8192000000 10902683040 11400237056 1963044688 19.330 100 5 10 0 1979609600 15144944 1419968
16:23:42 30687 8192000000 10914607072 11389489152 1957778528 19.288 99 22 43 3 1982079232 17550384 6750320
16:24:20 78662 8192000000 10865052512 11345055744 1835491552 18.304 93 14 28 1 1857695872 17438944 4765376
16:25:46 56641 8192000000 10901112992 11365715968 1937398352 19.126 99 31 62 2 1958281584 12142832 8740400
16:26:55 54999 8192000000 10903708640 11378880512 1964635296 19.343 100 34 68 1 1984874656 10830432 9408928
16:28:02 30056 8192000000 10887817216 11349172224 1892121040 18.763 96 33 66 0 1912843328 11531920 9190368
16:28:39 55028 8192000000 10894910112 11366232064 1937735280 19.129 99 34 68 1 1959864096 12772464 9356352
16:29:45 32117 8192000000 10900009696 11351076864 1904779824 18.865 97 39 78 1 1926920560 11285568 10855168
16:30:24 55934 8192000000 10873111728 11362537472 1894192912 18.780 97 22 44 1 1913054352 12972624 5888816
16:31:27 25034 8192000000 9440608784 9744711680 587058000 6.687 30 3 6 0 591645056 4106192 480864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-03-2021 16:32:41 to 12-03-2021 16:33:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 121 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2021 16:33:14 to 12-03-2021 16:33:16.

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

12.03.21 16:33:17. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-12 16:33:19 No severe PSQL-related problems occured
12.03.21 16:33:20. End of report.