Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2021 19: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 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 17676692 kB
MemAvailable 31527292 kB
Buffers 0 kB
Cached 13977040 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-17 19:27:22
DTS_END                         2021-03-17 19:27:22.9380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37954
TRN_ID                          243755
ATT_ID                          651
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: 9046.01 22406 1085521
customer order: creation 174.78 344 20973
customer order: refuse 14.43 338 1732
order to supplier: creation 45.45 1341 5454
order to supplier: removal 3.34 107882 401
invoice (draft): creation 47.56 3101 5707
invoice (draft): removal 51.12 968 6134
invoice accept: apply 42.23 17719 5067
invoice accept: cancel 45.23 755 5428
customer reserve: creation 3868.98 178 464278
customer reserve: removal 4454.94 63 534593
realization accept: apply 85.30 205 10236
realization accept: cancel 81.68 116 9802
payment from customer: creation 59.82 158 7178
payment from customer: removal 5.83 147 699
payment to supplier: creation 49.45 178 5934
payment to supplier: removal 3.59 86 431
service: total inventory turnovers 4.88 1071 585
service: total monetary turnovers 6.53 74 784
service: aggregate perf. data 0.84 21049 101
service: refresh index statistics 0.03 292343 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2021 19:28:05 to 17-03-2021 19:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4475
TEST_TIME 2 3146
TEST_TIME 3 3838
TEST_TIME 4 3677
TEST_TIME 5 3387
TEST_TIME 6 3903
TEST_TIME 7 3801
TEST_TIME 8 4018
TEST_TIME 9 4570
TEST_TIME 10 4935
TEST_TIME 11 4995
TEST_TIME 12 4991
TEST_TIME 13 5391
TEST_TIME 14 5435
TEST_TIME 15 5746
TEST_TIME 16 5858
TEST_TIME 17 6038
TEST_TIME 18 6487
TEST_TIME 19 6502
TEST_TIME 20 6698
TEST_TIME 21 7189
TEST_TIME 22 7855
TEST_TIME 23 8340
TEST_TIME 24 8514
TEST_TIME 25 9000
TEST_TIME 26 10221
TEST_TIME 27 10229
TEST_TIME 28 10307
TEST_TIME 29 10113
TEST_TIME 30 9926
TEST_TIME 31 9853
TEST_TIME 32 9573
TEST_TIME 33 9481
TEST_TIME 34 9456
TEST_TIME 35 9294
TEST_TIME 36 9204
TEST_TIME 37 9148
TEST_TIME 38 9183
TEST_TIME 39 9194
TEST_TIME 40 9067
TEST_TIME 41 8916
TEST_TIME 42 8895
TEST_TIME 43 9028
TEST_TIME 44 9012
TEST_TIME 45 9017
TEST_TIME 46 8942
TEST_TIME 47 9058
TEST_TIME 48 9061
TEST_TIME 49 9011
TEST_TIME 50 9021
TEST_TIME 51 8996
TEST_TIME 52 9185
TEST_TIME 53 9299
TEST_TIME 54 9355
TEST_TIME 55 9256
TEST_TIME 56 9374
TEST_TIME 57 9346
TEST_TIME 58 9268
TEST_TIME 59 9194
TEST_TIME 60 9140
TEST_TIME 61 9097
TEST_TIME 62 9031
TEST_TIME 63 8992
TEST_TIME 64 8952
TEST_TIME 65 8903
TEST_TIME 66 9059
TEST_TIME 67 8994
TEST_TIME 68 9065
TEST_TIME 69 9098
TEST_TIME 70 9098
TEST_TIME 71 9109
TEST_TIME 72 9109
TEST_TIME 73 9170
TEST_TIME 74 9134
TEST_TIME 75 9204
TEST_TIME 76 9240
TEST_TIME 77 9258
TEST_TIME 78 9208
TEST_TIME 79 9117
TEST_TIME 80 9107
TEST_TIME 81 9117
TEST_TIME 82 9078
TEST_TIME 83 9040
TEST_TIME 84 9034
TEST_TIME 85 9027
TEST_TIME 86 8991
TEST_TIME 87 8999
TEST_TIME 88 9000
TEST_TIME 89 8984
TEST_TIME 90 9076
TEST_TIME 91 9083
TEST_TIME 92 9058
TEST_TIME 93 9099
TEST_TIME 94 9124
TEST_TIME 95 9139
TEST_TIME 96 9167
TEST_TIME 97 9169
TEST_TIME 98 9205
TEST_TIME 99 9213
TEST_TIME 100 9182
TEST_TIME 101 9130
TEST_TIME 102 9079
TEST_TIME 103 9087
TEST_TIME 104 9061
TEST_TIME 105 9011
TEST_TIME 106 9003
TEST_TIME 107 8996
TEST_TIME 108 8992
TEST_TIME 109 8989
TEST_TIME 110 8967
TEST_TIME 111 8957
TEST_TIME 112 9002
TEST_TIME 113 9042
TEST_TIME 114 9049
TEST_TIME 115 9042
TEST_TIME 116 9080
TEST_TIME 117 9079
TEST_TIME 118 9074
TEST_TIME 119 9097
TEST_TIME 120 9048

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2021 19:28:09 to 17-03-2021 19:28:12.

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 1516068 1516068 0 0.00 0 41774 7 0 0
doc_list_biud 1516067 1516067 0 0.00 0 75492 28 0 0
sp_add_invoice_to_stock 5170 5067 103 1.99 40 219737 17720 0 103
sp_cancel_adding_invoice 5428 5428 0 0.00 3 76850 755 0 0
sp_cancel_client_order 1732 1732 0 0.00 4 17802 339 0 0
sp_cancel_customer_reserve 534593 534593 0 0.00 1 15913 63 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 30267 148 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 2 4775 87 0 0
sp_cancel_supplier_invoice 6141 6134 7 0.11 1 75495 969 0 7
sp_cancel_supplier_order 401 401 0 0.00 6 1178627 107883 0 0
sp_cancel_write_off 9802 9802 0 0.00 1 25445 117 0 0
sp_client_order 20973 20973 0 0.00 3 13587 345 0 0
sp_customer_reserve 464278 464278 0 0.00 0 55137 179 0 0
sp_fill_shopping_cart 32123 32123 0 0.00 1 12616 38 0 0
sp_fill_shopping_cart_clo_res 464277 464277 0 0.00 0 13968 15 0 0
sp_get_clo_for_invoice 5064 5064 0 0.00 0 20757 258 0 0
sp_kill_cost_storno 16360 16360 0 0.00 0 30252 62 0 0
sp_kill_qstorno_ret_qs2qd 1085523 1085523 0 0.00 0 75490 35 0 0
sp_kill_qty_storno 573389 573389 0 0.00 0 75491 75 0 0
sp_lock_selected_doc 21044 21044 0 0.00 0 8467 7 0 0
sp_make_cost_storno 28412 28412 0 0.00 0 41673 62 0 0
sp_multiply_rows_for_pdistr 28411 28411 0 0.00 0 31624 36 0 0
sp_multiply_rows_for_qdistr 20973 20973 0 0.00 0 12889 168 0 0
sp_pay_from_customer 7178 7178 0 0.00 4 40286 158 0 0
sp_pay_to_supplier 5934 5934 0 0.00 5 30690 179 0 0
sp_payment_common 13112 13112 0 0.00 1 40238 66 0 0
sp_qd_handle_on_cancel_clo 1732 1732 0 0.00 0 17795 308 0 0
sp_qd_handle_on_invoice_upd_sts 10492 10492 0 0.00 0 14570 302 0 0
sp_qd_handle_on_reserve_upd_sts 10235 10235 0 0.00 0 10981 54 0 0
sp_reserve_write_off 10236 10236 0 0.00 6 29733 206 0 0
sp_supplier_invoice 5707 5707 0 0.00 7 69986 3102 0 0
sp_supplier_order 5454 5454 0 0.00 5 65056 1342 0 0
srv_aggregate_perf_data 102 101 1 0.98 2146 582868 21050 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 1608 106345 33899 0 0
srv_find_qd_qs_mism 1037612 1037612 0 0.00 0 11388 5 0 0
srv_make_invnt_saldo 585 585 0 0.00 33 69245 1072 0 0
srv_make_money_saldo 784 784 0 0.00 1 36849 74 0 0
srv_recalc_idx_stat 4 4 0 0.00 159654 390633 292344 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5067 5067 0 0.00 0 13308 128 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 21272 123 0 0
t$perf-norm:sp_cancel_client_order 1732 1732 0 0.00 0 3901 14 0 0
t$perf-norm:sp_cancel_customer_reserve 633 633 0 0.00 0 1510 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 2014 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 346 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 2415 18 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 29399 1472 0 0
t$perf-norm:sp_cancel_write_off 1019 1019 0 0.00 0 2532 6 0 0
t$perf-norm:sp_client_order 20973 20973 0 0.00 0 23881 18 0 0
t$perf-norm:sp_customer_reserve 1095 1095 0 0.00 0 1544 6 0 0
t$perf-norm:sp_pay_from_customer 7178 7178 0 0.00 0 23878 15 0 0
t$perf-norm:sp_pay_to_supplier 5934 5934 0 0.00 0 3230 8 0 0
t$perf-norm:sp_reserve_write_off 10236 10236 0 0.00 0 10695 12 0 0
t$perf-norm:sp_supplier_invoice 5707 5707 0 0.00 0 26084 22 0 0
t$perf-norm:sp_supplier_order 5454 5454 0 0.00 0 5846 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 1035 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 2496 21 0 0
t$perf-norm:srv_make_invnt_saldo 585 585 0 0.00 0 3563 27 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 495 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10332 10126 206 1.99 0 6018 20 0 206
v_all_customers 38360 38360 0 0.00 0 13 0 0 0
v_all_suppliers 30998 30998 0 0.00 0 193 1 0 0
v_all_wares 41946 41946 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 1015 7 0 0
v_cancel_client_order 3464 3464 0 0.00 0 4526 6 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 1499 7 0 0
v_cancel_customer_reserve 1266 1266 0 0.00 0 909 5 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2857 8 0 0
v_cancel_supplier_invoice 858 844 14 1.63 0 5842 24 0 14
v_cancel_supplier_order 802 802 0 0.00 0 3986 7 0 0
v_cancel_write_off 2038 2038 0 0.00 0 4138 19 0 0
v_max_id_clo_ord 5454 5454 0 0.00 0 12566 3 0 0
v_max_id_clo_res 1095 1095 0 0.00 0 5680 15 0 0
v_max_id_ord_sup 5696 5696 0 0.00 0 9351 5 0 0
v_max_non_paid_invoice 1585 1585 0 0.00 0 3758 5 0 0
v_max_non_paid_realizn 3715 3715 0 0.00 0 3643 6 0 0
v_min_id_clo_ord 5454 5454 0 0.00 0 6037 9 0 0
v_min_id_clo_res 1095 1095 0 0.00 0 893 3 0 0
v_min_id_ord_sup 5696 5696 0 0.00 0 5781 5 0 0
v_min_non_paid_invoice 5934 5934 0 0.00 0 30242 60 0 0
v_min_non_paid_realizn 7178 7178 0 0.00 0 32293 48 0 0
v_our_firm 10512 10512 0 0.00 0 15 1 0 0
v_reserve_write_off 20470 20470 0 0.00 0 4718 7 0 0
x_lock_depdocs_on_canc_invoice 11140 11140 0 0.00 0 15668 110 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 22346 387 0 0
x_make_qstorno_1000_1200 5454 5454 0 0.00 2 65037 1271 0 0
x_make_qstorno_1200_2000 5707 5707 0 0.00 3 69962 2961 0 0
x_make_qstorno_2100_3300 464278 464278 0 0.00 0 55118 161 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:26 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:32 18815 8192000000 10275893408 10584977408 1026933760 11.139 80 57 114 0 1049370320 2749456 19687104
16:58:04 20323 8192000000 10333709232 10651000832 1391163248 14.516 100 84 168 1 1423667040 5080800 27422992
16:58:32 31558 8192000000 10381332784 10702393344 1431002144 14.870 100 91 182 0 1467218224 6373424 29842656
16:59:14 19985 8192000000 10399402528 10722848768 1450968176 15.046 100 87 174 0 1486339920 7444496 27927248
16:59:55 14419 8192000000 10429160304 10754101248 1484774464 15.343 100 92 184 1 1522471392 8383184 29313744
17:00:20 9416 8192000000 10442088432 10768994304 1496463248 15.445 100 93 186 0 1535297856 9006496 29828112
17:00:41 11475 8192000000 10449307392 10781425664 1507408096 15.541 100 93 186 0 1546039376 9190864 29440416
17:01:04 24883 8192000000 10468817568 10806034432 1516689696 15.621 100 89 178 0 1554077568 9385632 28002240
17:01:43 8787 8192000000 10489173824 10834022400 1549312400 15.904 100 80 160 1 1583243792 9762912 24168480
17:02:02 13055 8192000000 10517327824 10866573312 1576985616 16.142 100 80 160 0 1611253056 9800032 24467408
17:02:30 15889 8192000000 10544229184 10900611072 1603950192 16.373 100 75 150 0 1636875696 10277056 22648448
17:02:55 17327 8192000000 10590334000 10946199552 1632257968 16.614 100 77 155 1 1666421808 10754016 23409824
17:03:21 9150 8192000000 10588534080 10951147520 1650958816 16.772 100 77 154 2 1685659952 11837200 22863936
17:03:38 10582 8192000000 10597615040 10964713472 1665084816 16.892 100 79 158 1 1700926464 12449840 23391808
17:04:00 9798 8192000000 10624033072 10991693824 1681190640 17.027 100 76 151 1 1715484944 12084960 22209344
17:04:17 10810 8192000000 10637731776 11007844352 1694694480 17.141 100 74 148 1 1728314752 11913536 21706736
17:04:35 7367 8192000000 10648669008 11023007744 1714423344 17.306 100 72 144 1 1746512560 11769568 20319648
17:04:51 7607 8192000000 10671270976 11044696064 1731821008 17.451 100 74 147 1 1764501776 11608032 21072736
17:05:06 5111 8192000000 10680331808 11060613120 1743615696 17.549 100 67 134 1 1774500000 12060304 18824000
17:05:19 6422 8192000000 10694264320 11070377984 1756821712 17.658 100 80 158 1 1792210176 12694448 22694016
17:05:32 4152 8192000000 10701580560 11080970240 1764768064 17.724 100 75 148 1 1797386128 12783392 19834672
17:05:43 3863 8192000000 10715000976 11094863872 1774630864 17.805 100 77 153 1 1808039504 12893440 20515200
17:05:53 4989 8192000000 10719256048 11100676096 1781323472 17.860 100 80 160 1 1817031856 14041632 21666752
17:06:05 4332 8192000000 10718714928 11104256000 1785364880 17.894 100 79 158 1 1821449696 14383632 21701184
17:06:18 2963 8192000000 10740870848 11124940800 1799762816 18.012 100 88 176 0 1839528032 14769712 24995504
17:06:28 2552 8192000000 10749740224 11132563456 1807784976 18.078 100 82 165 1 1845277904 14196976 23295952
17:06:37 2423 8192000000 10750566560 11132735488 1816803984 18.152 100 85 168 2 1854446336 13813792 23828560
17:06:46 2192 8192000000 10765462688 11144601600 1819323392 18.172 100 83 166 0 1855623968 13907408 22393168
17:06:55 1449 8192000000 10760545008 11149799424 1826618080 18.232 100 86 172 1 1864947312 12885088 25444144
17:07:02 1801 8192000000 10765216752 11156180992 1830737536 18.265 100 85 169 0 1867155984 12827296 23591152
17:07:11 1829 8192000000 10775950624 11162472448 1837775824 18.323 100 92 183 4 1876708880 12598160 26334896
17:07:20 1389 8192000000 10783047568 11167203328 1839870192 18.340 100 86 170 1 1877409280 12674432 24864656
17:07:28 1612 8192000000 10773894656 11163000832 1839151040 18.334 100 84 167 1 1876203792 12973088 24079664
17:07:36 1873 8192000000 10786358032 11170344960 1846688192 18.395 100 89 180 1 1884534400 13121936 24724272
17:07:44 1755 8192000000 10788027904 11174903808 1847924912 18.405 100 90 179 3 1886542400 13401280 25216208
17:07:53 1889 8192000000 10803875040 11185442816 1853352896 18.449 100 92 186 1 1894633840 15059488 26221456
17:08:01 1226 8192000000 10788165024 11180752896 1849950144 18.422 100 86 173 3 1889032288 14157616 24924528
17:08:09 2140 8192000000 10801747296 11186900992 1854967328 18.462 100 93 186 3 1892259152 11518624 25773200
17:08:17 2220 8192000000 10801147424 11188322304 1858406896 18.490 100 88 177 1 1894853072 11168960 25277216
17:08:26 58007 8192000000 10747524912 11177869312 1850650176 18.427 100 37 74 2 1868456736 5581856 12224704
17:09:31 33737 8192000000 10762834016 11194531840 1860891040 18.511 100 32 64 4 1877046448 6891840 9263568
17:10:14 8567 8192000000 10774531008 11200983040 1863520064 18.532 100 25 48 2 1877058000 6498496 7039440
17:10:29 5877 8192000000 10787920480 11209846784 1869466032 18.580 100 40 80 1 1889167904 7744944 11956928
17:10:44 4400 8192000000 10792791888 11214008320 1875330544 18.627 100 37 74 1 1894141568 7018208 11792816
17:10:55 4157 8192000000 10795491920 11217883136 1876015472 18.633 100 33 66 1 1892570896 7776464 8778960
17:11:05 5657 8192000000 10801666480 11219369984 1880838976 18.672 100 40 81 0 1899625888 7619488 11167424
17:11:18 7444 8192000000 10795429232 11217981440 1878759296 18.655 100 25 49 3 1892551744 6013024 7779424
17:11:33 6003 8192000000 10789785696 11219550208 1880550864 18.670 100 31 62 0 1896891728 7620192 8720672
17:11:46 4628 8192000000 10799429728 11225432064 1883798096 18.696 100 27 54 1 1898030096 6551664 7680336
17:11:57 7436 8192000000 10797927040 11224158208 1884532192 18.702 100 23 47 3 1898202736 6186144 7484400
17:12:11 14627 8192000000 10798629792 11230806016 1886090528 18.714 100 19 38 3 1897029184 5628816 5309840
17:12:34 12815 8192000000 10793875104 11230044160 1892939008 18.769 100 26 50 2 1905756176 4927168 7890000
17:12:56 6684 8192000000 10803347840 11235590144 1895224480 18.788 100 26 50 2 1912203952 10075664 6903808
17:13:12 5308 8192000000 10808828416 11236118528 1896594112 18.799 100 35 73 1 1914008432 6488352 10925968
17:13:28 32563 8192000000 10810100128 11242483712 1893878720 18.777 100 16 31 1 1903645664 5184816 4582128
17:14:23 18329 8192000000 10852483728 11252822016 1910456992 18.910 100 71 142 3 1938520848 6005488 22058368
17:14:47 10551 8192000000 10808628880 11246530560 1899674208 18.824 100 17 33 1 1910563440 6515104 4374128
17:15:06 7592 8192000000 10820851616 11247276032 1902564368 18.847 100 32 64 4 1917412032 5816112 9031552
17:15:20 6267 8192000000 10813523664 11247702016 1902154176 18.844 100 29 57 3 1916636752 6216448 8266128
17:15:35 7671 8192000000 10810585776 11246424064 1903013696 18.851 100 33 66 2 1918603504 6168368 9421440
17:15:49 6444 8192000000 10810485968 11243937792 1886192848 18.715 99 19 38 1 1897383488 5052944 6137696
17:16:01 3968 8192000000 10817575328 11250958336 1905966176 18.874 100 28 57 0 1920022608 5893056 8163376
17:16:13 7371 8192000000 10805279392 11241136128 1884621344 18.702 99 21 41 2 1895973024 5247280 6104400
17:16:27 8574 8192000000 10816992544 11251986432 1901892480 18.842 100 30 60 3 1920327920 9511792 8923648
17:16:46 7151 8192000000 10809249744 11239895040 1883559328 18.694 99 21 40 3 1896254944 6366208 6329408
17:17:02 9648 8192000000 10785196016 11224158208 1856021728 18.471 98 17 34 0 1866477584 5445488 5010368
17:17:21 6696 8192000000 10747201712 11176894464 1792739136 17.954 96 22 44 0 1804329616 5486048 6104432
17:17:38 7284 8192000000 10757656768 11183599616 1800626080 18.019 96 31 62 1 1814821056 5268192 8926784
17:17:53 6427 8192000000 10757941088 11189841920 1824198688 18.212 98 36 73 0 1840520192 5697664 10623840
17:18:06 6762 8192000000 10755668256 11182342144 1833921168 18.291 99 21 42 4 1846296656 6167200 6208288
17:18:19 7189 8192000000 10739423712 11159797760 1813656176 18.126 98 48 96 4 1833794768 5663312 14475280
17:18:32 66809 8192000000 10754889360 11185717248 1814664384 18.134 98 40 80 1 1832416560 5807488 11944688
17:19:46 14272 8192000000 10719481536 11133050880 1719171312 17.345 93 13 26 0 1728066000 5113904 3780784
17:20:07 11201 8192000000 10711857312 11121803264 1679224272 17.011 92 25 51 2 1691506272 5829024 6452976
17:20:26 4542 8192000000 10711611952 11130474496 1795828768 17.980 100 21 40 3 1807578304 6249216 5500320
17:20:38 7453 8192000000 10707027328 11125800960 1719472976 17.348 95 19 36 4 1729060768 4825216 4762576
17:20:52 6407 8192000000 10724028352 11132362752 1786172032 17.900 99 28 56 2 1799731504 5144400 8415072
17:21:09 9276 8192000000 10706142112 11127902208 1786008768 17.899 99 26 52 3 1799467056 5232848 8225440
17:21:25 6990 8192000000 10721428400 11139346432 1793350288 17.959 99 22 44 1 1805534432 5969232 6214912
17:21:42 12207 8192000000 10705535504 11134439424 1761440960 17.696 97 14 28 0 1770479904 5098544 3940400
17:22:03 6549 8192000000 10699572144 11114872832 1753816032 17.633 97 22 44 1 1765248784 4871824 6560928
17:22:18 9465 8192000000 10712706048 11134042112 1764819680 17.724 98 17 34 0 1775340192 5200912 5319600
17:22:34 9738 8192000000 10735756224 11157815296 1819071696 18.170 100 18 34 1 1828528672 4917392 4539584
17:22:50 9550 8192000000 10746356544 11172409344 1827818240 18.242 100 11 22 1 1836751008 5853088 3079680
17:23:08 39084 8192000000 10748209344 11185250304 1848389904 18.409 100 27 54 1 1861993648 5665968 7937776
17:24:06 36755 8192000000 10752811472 11190894592 1847033232 18.398 100 23 46 1 1859283312 6049136 6200944
17:24:50 11642 8192000000 10765856160 11192750080 1852808608 18.445 100 29 56 2 1867683424 6266320 8608496
17:25:11 5260 8192000000 10757202752 11195826176 1854424352 18.458 100 21 42 0 1866710144 6138304 6147488
17:25:23 6533 8192000000 10776919600 11200397312 1859071072 18.496 100 22 44 0 1870916576 5541216 6304288
17:25:37 9789 8192000000 10783695552 11205824512 1862048784 18.520 100 31 60 1 1876239936 5583680 8607472
17:25:56 7369 8192000000 10770115280 11204648960 1863190288 18.529 100 27 54 0 1877301664 6487216 7624160
17:26:09 10744 8192000000 10782082848 11209637888 1866615712 18.557 100 21 40 3 1877685200 5828368 5241120
17:26:29 12393 8192000000 10772184592 11209199616 1868861696 18.575 100 20 40 1 1880410928 6161840 5387392
17:26:48 11652 8192000000 10777546816 11213746176 1872789744 18.607 100 23 46 1 1884536480 4879184 6867552
17:27:06 8073 8192000000 10803660944 11229175808 1887669344 18.727 100 29 58 2 1901675680 5546768 8459568
17:27:20 13935 8192000000 10824916400 11242405888 1897272384 18.804 100 31 62 0 1910547664 4266144 9009136
17:27:44 23289 8192000000 10843222304 11261091840 1910423424 18.910 100 50 98 1 1930682432 6516064 13742944
17:28:17 45809 8192000000 10852696064 11272986624 1917237984 18.965 100 46 92 1 1938612992 7998064 13376944
17:29:39 61682 8192000000 10846875360 11291062272 1931891296 19.082 100 28 56 0 1948527808 8535264 8101248
17:31:17 35890 8192000000 10873028448 11310391296 1947947008 19.210 100 35 70 1 1970242112 12041536 10253568
17:32:07 41904 8192000000 10907552752 11344666624 1966126944 19.355 100 43 84 6 2002147984 23228560 12792480
17:32:56 15277 8192000000 10912580912 11344547840 1979501472 19.461 100 62 121 1 2014908752 17111248 18296032
17:33:38 29103 8192000000 10910438576 11345936384 1955883632 19.273 99 37 74 3 1984808544 17787328 11137584
17:34:23 10116 8192000000 10920462848 11354030080 1978676992 19.454 100 54 101 4 2012308720 18962304 14669424
17:34:40 10396 8192000000 10931082384 11363016704 1984047680 19.497 100 49 96 0 2018417744 20054672 14315392
17:35:07 14932 8192000000 10938774000 11377983488 1995696176 19.589 100 58 116 4 2036504336 23508672 17299488
17:35:35 9718 8192000000 10949907232 11379216384 1993392448 19.571 100 47 93 1 2032189392 24777168 14019776
17:35:53 9262 8192000000 10951832624 11386032128 1996828656 19.598 100 49 98 1 2037906528 26439344 14638528
17:36:12 8428 8192000000 10941888256 11373850624 1976746528 19.439 99 51 100 0 2017294240 25442192 15105520
17:36:27 3930 8192000000 10955357392 11384778752 1997257408 19.601 100 57 114 1 2041185760 26830016 17098336
17:36:41 12683 8192000000 10959787728 11388313600 2002208864 19.640 100 60 120 1 2047883568 27597744 18076960
17:37:06 10597 8192000000 10949163056 11394437120 2004773968 19.660 100 57 110 2 2049535200 28017744 16743488
17:37:25 10788 8192000000 10955029824 11393904640 2006556272 19.674 100 50 100 2 2048518672 26084992 15877408
17:37:45 14617 8192000000 10967877264 11403833344 2011175472 19.711 100 46 92 0 2051074176 25001648 14897056
17:38:14 8458 8192000000 10948288752 11380809728 1973185520 19.411 98 60 120 0 2023200640 32147696 17867424
17:38:28 3310 8192000000 10963434640 11389202432 2002328240 19.641 100 69 139 0 2052339248 29002800 21008208
17:38:40 5994 8192000000 10960133280 11394490368 1989791664 19.542 99 60 116 0 2036749072 29772336 17185072
17:38:55 14589 8192000000 10974854640 11409301504 2008082752 19.686 100 53 106 1 2057950720 33735728 16132240
17:39:19 5579 8192000000 10984485104 11419312128 2017989472 19.764 100 60 117 1 2072665440 35899264 18776704
17:39:34 5779 8192000000 10984872256 11420422144 2018815760 19.771 100 61 121 0 2076070736 38730480 18524496
17:39:50 6364 8192000000 10992909552 11427573760 2020324944 19.783 100 53 104 2 2075760352 39913472 15521936
17:40:04 3863 8192000000 11011845152 11437752320 2032006544 19.874 100 80 157 1 2097079040 41278160 23794336
17:40:18 4865 8192000000 11004286544 11433287680 2029999680 19.859 100 70 136 2 2089916480 39391072 20525728
17:40:29 4035 8192000000 10986634112 11412246528 2016989792 19.756 100 73 142 2 2076785216 37507520 22287904
17:40:41 3358 8192000000 10995607872 11421503488 2022857808 19.803 100 64 127 1 2079636784 37677088 19101888
17:40:56 6477 8192000000 11013052560 11436560384 2032205088 19.876 100 78 156 0 2096280176 39788448 24286640
17:41:10 7099 8192000000 11008173744 11437846528 2032689520 19.880 100 70 141 1 2095659536 41859376 21110640
17:41:42 12294 8192000000 10995714288 11434745856 2024999856 19.819 100 61 119 1 2088997744 45448112 18549776
17:42:13 17656 8192000000 10984143216 11429027840 2002442352 19.642 99 50 100 2 2064790528 45854112 16494064
17:42:44 3471 8192000000 10980508624 11425042432 1995981776 19.591 99 46 93 1 2060716144 49251248 15483120
17:42:56 6605 8192000000 10997106496 11428622336 2003282464 19.649 99 67 134 1 2066632320 41885600 21464256
17:43:14 2650 8192000000 11003760880 11434803200 2023610944 19.809 100 62 124 0 2085448288 42554080 19283264
17:43:24 2374 8192000000 11014936896 11438338048 2007500400 19.682 99 89 174 3 2077727424 42729568 27497456
17:43:36 8452 8192000000 10997423072 11432718336 2025814064 19.826 100 68 135 2 2091962800 44755456 21393280
17:43:53 3959 8192000000 10973363360 11406082048 1969938032 19.385 98 53 106 0 2032605392 45535616 17131744
17:44:05 4144 8192000000 10988530256 11420782592 2011449120 19.713 100 61 122 4 2076707744 45750512 19508112
17:44:16 3779 8192000000 11009973568 11431432192 2018372096 19.767 100 83 165 0 2091064992 46828720 25864176
17:44:28 2849 8192000000 11006683072 11426447360 2012465136 19.721 100 83 166 1 2087557552 49823408 25269008
17:44:41 4494 8192000000 10989985264 11418501120 1990684784 19.549 99 75 150 0 2065018064 50308528 24024752
17:44:59 6181 8192000000 10984196064 11422691328 2005205808 19.664 100 55 110 2 2072767664 49879088 17682768
17:45:13 7609 8192000000 10971405936 11407564800 1993044032 19.568 99 57 113 1 2061769344 50323136 18402176
17:45:27 6557 8192000000 10953548544 11394105344 1964012112 19.338 98 36 72 1 2024979472 48050704 12916656
17:45:42 4853 8192000000 10949721808 11387682816 1953823584 19.257 98 56 110 1 2017647488 45715632 18108272
17:45:58 2215 8192000000 10962045584 11397206016 1985809248 19.511 100 50 100 1 2048913600 46660672 16443680
17:46:06 5899 8192000000 10981398112 11413676032 1997862240 19.606 100 55 110 1 2064303584 48670528 17770816
17:46:23 14823 8192000000 10976007664 11415441408 1994688672 19.581 100 46 92 0 2061919200 51468016 15762512
17:46:47 9042 8192000000 10969195344 11407753216 1988736656 19.534 100 52 104 2 2061508192 55009856 17761680
17:47:03 4061 8192000000 10946510032 11367780352 1946805328 19.201 98 54 106 1 2020698512 56356592 17536592
17:47:16 1607 8192000000 10979040144 11400171520 1977151984 19.442 100 74 149 1 2060960848 59577904 24230960
17:47:33 7572 8192000000 10938749008 11372818432 1950430640 19.230 99 50 100 4 2026323712 58980176 16912896
17:47:47 7745 8192000000 10948758928 11384524800 1931025040 19.075 98 54 108 0 2010195568 60753408 18417120
17:48:05 14508 8192000000 10949565056 11395538944 1960555344 19.310 100 42 84 1 2038480336 63060528 14864464
17:48:26 8483 8192000000 10923427296 11378827264 1929879920 19.066 99 30 60 2 1998937984 58121968 10936096
17:48:48 11027 8192000000 10937924592 11374694400 1937971456 19.131 99 43 86 0 2007661024 55146800 14542768
17:49:07 4727 8192000000 10927739072 11361931264 1937983120 19.131 99 44 88 1 2013694864 59949312 15762432
17:49:18 13321 8192000000 10938698400 11379830784 1933310528 19.093 99 38 76 2 2004730096 57781024 13638544
17:49:38 25838 8192000000 10908152368 11360849920 1894554160 18.782 97 36 72 2 1961985920 54996144 12435616
17:50:11 13698 8192000000 10915803312 11353165824 1935098752 19.108 100 37 74 0 1992201904 44642336 12460816
17:50:36 14772 8192000000 10885812608 11333033984 1891142640 18.755 98 23 46 0 1942557968 43433776 7981552
17:51:29 22104 8192000000 10891347104 11341414400 1903279440 18.853 99 28 56 1 1966682496 53072368 10330688
17:51:58 29199 8192000000 10869777728 11307130880 1829610976 18.256 96 22 41 1 1892517680 54239600 8667104
17:52:33 18026 8192000000 10867422208 11319799808 1876949424 18.640 99 25 50 2 1936719232 51000272 8769536
17:52:57 17185 8192000000 10858643808 11298975744 1828575504 18.248 96 29 58 0 1884792992 46095328 10122160
17:53:21 16478 8192000000 10856403600 11302838272 1881275728 18.675 99 19 38 0 1924330048 36538688 6515632
17:53:45 23615 8192000000 10823213184 11262259200 1842764224 18.363 97 23 46 4 1868958928 19003552 7191152
17:54:17 20668 8192000000 10840373120 11284717568 1898474336 18.814 100 22 44 1 1914713200 9229744 7009120
17:55:08 31571 8192000000 10842795104 11304669184 1915124224 18.948 100 20 39 2 1928865600 8352656 5388720
17:56:30 61422 8192000000 10800914224 11259760640 1839678192 18.338 96 20 40 3 1854479984 9395024 5406768
17:58:40 79454 8192000000 10856452176 11292676096 1901988816 18.842 99 41 81 1 1920825952 6678448 12158688
18:00:08 60072 8192000000 10876201344 11316686848 1929468112 19.063 100 35 67 3 1946767328 7611872 9687344
18:01:15 70499 8192000000 10870795792 11329748992 1929438608 19.062 99 18 36 1 1945228720 10679856 5110256
18:02:34 20589 8192000000 10878911760 11325579264 1926759968 19.041 99 34 68 2 1945240592 9313120 9167504
18:03:37 50733 8192000000 10857694576 11311812608 1890625472 18.751 97 24 48 1 1913728176 16361584 6741120
18:04:34 57581 8192000000 10861378080 11331284992 1932578736 19.087 100 13 26 0 1950443808 14122480 3742592
18:05:38 54007 8192000000 10871332192 11342745600 1922422224 19.006 99 11 22 2 1942600512 16583984 3594304
18:07:42 106345 8192000000 10895780944 11356803072 1936374432 19.118 99 19 38 0 1957081008 14670784 6035792
18:09:46 16323 8192000000 10888589664 11360964608 1953258128 19.252 100 10 20 1 1979921888 22939696 3724064
18:10:09 37982 8192000000 10890239536 11373867008 1953045728 19.251 100 6 13 1 1974661184 19884688 1730768
18:11:10 76239 8192000000 10903529584 11371532288 1973705984 19.415 100 29 58 0 1990781984 8969264 8106736
18:12:32 37316 8192000000 10921891360 11382775808 1986713376 19.518 100 21 42 0 2001743024 9167312 5862336
18:13:17 21347 8192000000 10944726640 11384778752 1993431360 19.571 100 46 91 0 2016669504 10220944 13017200
18:13:48 75484 8192000000 10904881424 11372879872 1967269520 19.364 99 15 30 0 1983274480 11975600 4029360
18:15:10 62995 8192000000 10914776624 11386945536 1974602992 19.422 99 14 28 3 1986321568 7840864 3877712
18:16:19 44017 8192000000 10949596400 11406417920 1996751840 19.597 100 27 54 2 2019225968 14983616 7490512
18:17:12 49063 8192000000 10925864928 11394535424 1964799296 19.344 98 21 42 5 1986485792 15514448 6172048
18:18:12 66352 8192000000 10948728576 11416387584 2003285920 19.649 100 30 59 0 2031534240 19575328 8672992
18:19:33 62300 8192000000 10945704640 11414429696 2005200704 19.664 100 17 34 1 2027327872 17026672 5100496
18:20:42 98451 8192000000 10942947296 11414589440 1974624352 19.422 98 7 14 0 1993285696 16600112 2061232
18:22:32 78185 8192000000 10935142464 11415031808 1978653344 19.454 98 22 43 2 1999351424 14230560 6467520
18:23:57 58894 8192000000 10956380336 11391643648 1949404272 19.222 97 22 44 1 1964079696 8155104 6520320
18:25:10 96355 8192000000 10911903216 11390177280 1984472432 19.500 99 30 60 0 2000244064 7147248 8624384
18:27:06 46152 8192000000 10903058256 11368697856 1928837520 19.058 96 38 75 0 1947115632 7764320 10513792
18:28:03 23691 8192000000 10918876416 11375722496 1981874720 19.480 100 38 74 2 2002355424 10190864 10289840
18:28:33 20396 8192000000 10904186960 11382902784 1987236512 19.522 100 28 56 2 2007697280 12748240 7712528
18:29:02 25940 8192000000 10904324496 11361730560 1934931040 19.106 97 29 58 2 1955077504 11440992 8705472
18:29:37 85863 8192000000 10866041904 11338870784 1885178320 18.707 95 23 46 0 1904881328 12858384 6844624
18:31:22 49053 8192000000 10874355648 11348369408 1926647552 19.040 98 18 36 2 1944766608 12909776 5209280
18:32:29 46631 8192000000 10897720928 11373023232 1945072800 19.187 99 15 30 0 1967495936 17870992 4552144
18:33:31 64491 8192000000 10895585424 11366846464 1906723952 18.880 97 20 40 0 1925591040 13467088 5400000
18:34:41 58528 8192000000 10883829920 11357827072 1909191712 18.900 97 22 46 0 1928203952 12649008 6363232
18:36:08 43656 8192000000 10828138912 11290099712 1829434192 18.255 95 15 30 3 1849330912 15463088 4433632
18:36:59 50964 8192000000 10855783136 11318087680 1899044544 18.819 99 26 52 0 1916679696 10590512 7044640
18:37:58 42582 8192000000 10884677376 11327950848 1902461312 18.846 98 39 78 2 1920974400 7599488 10913600
18:38:47 46062 8192000000 10866758624 11331567616 1905547008 18.871 98 42 84 0 1931823232 13840336 12435888
18:39:42 61315 8192000000 10851414464 11325710336 1871718944 18.598 97 16 31 0 1889543456 13744560 4079952
18:40:50 62424 8192000000 10847952000 11300102144 1793904752 17.964 93 30 60 0 1811610320 9428880 8276688
18:41:58 52939 8192000000 10830099744 11301285888 1872074080 18.601 98 12 24 0 1887055152 11745264 3235808
18:43:06 67064 8192000000 10859412256 11325067264 1919767680 18.985 100 20 40 1 1937125552 11832752 5525120
18:44:20 39138 8192000000 10853589088 11303268352 1853822672 18.453 96 42 84 1 1876992144 11121248 12048224
18:45:06 10726 8192000000 10861068224 11304636416 1915696288 18.952 100 38 76 1 1934843472 8897552 10249632
18:45:25 70691 8192000000 10869501616 11324989440 1917886064 18.970 99 47 94 0 1942339584 11382032 13071488
18:47:20 40447 8192000000 10853936768 11311239168 1906843408 18.881 99 41 82 0 1928859296 10918480 11097408
18:48:09 19433 8192000000 10869394192 11309314048 1904614080 18.863 99 60 120 1 1935120976 13412080 17094816
18:48:36 39995 8192000000 10800996592 11264557056 1851338160 18.433 97 26 50 2 1868986288 10789984 6858144
18:49:34 62704 8192000000 10816895200 11292626944 1888366576 18.733 99 9 18 0 1901469904 10393760 2709568
18:50:43 19722 8192000000 10806271584 11280306176 1877268864 18.643 99 4 8 0 1887987648 9512064 1206720
18:51:09 54679 8192000000 10823111872 11301294080 1905876416 18.874 100 16 32 0 1920149216 9772592 4500208
18:52:10 48905 8192000000 10836517136 11309117440 1908649312 18.896 100 9 17 0 1924975136 13791200 2534624
18:53:06 69423 8192000000 10880299184 11340922880 1936823776 19.121 100 21 42 1 1953778416 10445936 6508704
18:54:22 66617 8192000000 10873537104 11343003648 1926240112 19.037 99 11 22 0 1940682288 11238688 3203488
18:55:41 62894 8192000000 10876079920 11339247616 1887303120 18.724 97 24 48 1 1906124144 12186592 6634432
18:56:59 49769 8192000000 10874858816 11359776768 1947207904 19.204 100 14 28 1 1965243392 14152720 3882768
18:58:09 71209 8192000000 10877567856 11349434368 1904590752 18.863 97 8 16 0 1913458080 7079024 1788304
18:59:27 20664 8192000000 10909057728 11362578432 1967513408 19.366 100 34 68 4 1983786352 6812352 9460592
18:59:55 20061 8192000000 10908791312 11372670976 1972197952 19.403 100 31 62 2 1989587840 9279824 8110064
19:00:30 48623 8192000000 10904253264 11372027904 1961305088 19.316 99 13 26 2 1975159568 10159920 3694560
19:01:33 44845 8192000000 10911278704 11370553344 1944221456 19.180 98 25 50 3 1959951936 8411408 7319072
19:02:50 76122 8192000000 10918191312 11387478016 1965972064 19.353 99 20 40 0 1985059312 13892048 5195200
19:04:17 32646 8192000000 10922562912 11385069568 1966406368 19.357 99 25 50 2 1982360320 9300256 6653696
19:04:58 27804 8192000000 10932086512 11391369216 1970171216 19.387 99 36 72 0 1994061760 13805040 10085504
19:05:32 42681 8192000000 10930410640 11381731328 1984041808 19.497 100 34 68 2 2007602208 14278272 9282128
19:06:26 18346 8192000000 10916488576 11373457408 1945178224 19.188 98 44 88 1 1967750784 10718064 11854496
19:07:02 103152 8192000000 10902442752 11361501184 1959480512 19.302 99 20 41 2 1973723152 8187216 6055424
19:09:28 71489 8192000000 10896537328 11375722496 1969813024 19.384 100 24 48 2 1993293392 16844432 6635936
19:10:45 22638 8192000000 10890249440 11362340864 1957224336 19.284 99 11 22 0 1974153984 13406032 3523616
19:11:16 19250 8192000000 10888330672 11376640000 1957367520 19.285 99 9 18 0 1972777312 12928928 2480864
19:11:42 47509 8192000000 10888512688 11370266624 1954876288 19.265 99 11 22 0 1972515760 14769296 2870176
19:12:35 46279 8192000000 10897861856 11374956544 1956544160 19.279 99 10 19 1 1972103600 12803712 2755728
19:14:08 61809 8192000000 10899356064 11371839488 1939287696 19.141 98 14 29 0 1953552464 10326256 3938512
19:15:16 72861 8192000000 10901009232 11384561664 1936137296 19.116 98 12 24 1 1951958288 12003280 3817712
19:16:51 46302 8192000000 10890751680 11359059968 1913002128 18.931 97 15 30 0 1930153280 11416944 5734208
19:17:45 32262 8192000000 10891080512 11357966336 1909335280 18.901 97 14 28 0 1925294976 12308368 3651328
19:18:23 82922 8192000000 10849724288 11334279168 1804010352 18.047 92 19 38 1 1827320624 17517696 5792576
19:19:53 79453 8192000000 10869550352 11334660096 1862610832 18.524 96 12 25 0 1880192768 14154528 3427408
19:21:18 53235 8192000000 10892883824 11347779584 1910737136 18.913 98 26 52 1 1929949088 11706960 7504992
19:22:20 42218 8192000000 10869957024 11337682944 1896475632 18.798 97 52 104 3 1925684192 14279424 14929136
19:23:11 41320 8192000000 10844831936 11299663872 1865309216 18.546 98 15 30 0 1879087760 9957312 3821232
19:23:59 46216 8192000000 10859650768 11317047296 1909210880 18.900 100 28 55 0 1928267680 10788160 8268640
19:24:51 68930 8192000000 10829091696 11280236544 1793148400 17.958 93 30 60 0 1811659664 10525568 7985696
19:26:16 70053 8192000000 9919946032 10287964160 1014965904 11.023 53 13 25 1 1030047424 11411040 3670480

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-03-2021 19:28:19 to 17-03-2021 19:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 103 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2021 19:28:51 to 17-03-2021 19:28:53.

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          244252
MON$OLDEST_ACTIVE               244253
MON$OLDEST_SNAPSHOT             244253
MON$NEXT_TRANSACTION            244253
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                       2003328
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:19: 
:20: mscs-test-161.budzdorov.ru    Wed Mar 17 19:27:35 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

17.03.21 19:28:54. 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-17 19:28:56 No severe PSQL-related problems occured
17.03.21 19:28:58. End of report.