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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-21 19:27:20
DTS_END                         2021-02-21 19:27:20.0170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45684
TRN_ID                          240849
ATT_ID                          712
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: 9255.33 20566 1110640
customer order: creation 176.18 361 21142
customer order: refuse 14.78 342 1773
order to supplier: creation 46.02 1324 5522
order to supplier: removal 3.62 113788 434
invoice (draft): creation 46.13 3722 5535
invoice (draft): removal 53.11 872 6373
invoice accept: apply 41.48 18760 4978
invoice accept: cancel 47.87 859 5744
customer reserve: creation 3854.66 183 462559
customer reserve: removal 4672.88 70 560746
realization accept: apply 84.56 205 10147
realization accept: cancel 84.44 128 10133
payment from customer: creation 59.95 134 7194
payment from customer: removal 5.57 59 668
payment to supplier: creation 48.44 179 5813
payment to supplier: removal 3.42 136 410
service: total inventory turnovers 4.83 1190 580
service: total monetary turnovers 6.48 41 777
service: aggregate perf. data 0.90 17255 108
service: refresh index statistics 0.03 251717 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3987
TEST_TIME 2 3399
TEST_TIME 3 5024
TEST_TIME 4 4917
TEST_TIME 5 4804
TEST_TIME 6 5181
TEST_TIME 7 5019
TEST_TIME 8 4860
TEST_TIME 9 5446
TEST_TIME 10 5590
TEST_TIME 11 5587
TEST_TIME 12 5953
TEST_TIME 13 6275
TEST_TIME 14 6901
TEST_TIME 15 7467
TEST_TIME 16 7679
TEST_TIME 17 7688
TEST_TIME 18 7739
TEST_TIME 19 8062
TEST_TIME 20 8340
TEST_TIME 21 8540
TEST_TIME 22 8404
TEST_TIME 23 8507
TEST_TIME 24 8516
TEST_TIME 25 8677
TEST_TIME 26 8520
TEST_TIME 27 8982
TEST_TIME 28 9438
TEST_TIME 29 9976
TEST_TIME 30 10609
TEST_TIME 31 11409
TEST_TIME 32 11130
TEST_TIME 33 11119
TEST_TIME 34 10977
TEST_TIME 35 10806
TEST_TIME 36 10811
TEST_TIME 37 10605
TEST_TIME 38 10553
TEST_TIME 39 10483
TEST_TIME 40 10307
TEST_TIME 41 10307
TEST_TIME 42 10355
TEST_TIME 43 10192
TEST_TIME 44 10137
TEST_TIME 45 10406
TEST_TIME 46 10434
TEST_TIME 47 10374
TEST_TIME 48 10347
TEST_TIME 49 10353
TEST_TIME 50 10209
TEST_TIME 51 10060
TEST_TIME 52 10066
TEST_TIME 53 9988
TEST_TIME 54 10066
TEST_TIME 55 9978
TEST_TIME 56 9902
TEST_TIME 57 9850
TEST_TIME 58 9857
TEST_TIME 59 9831
TEST_TIME 60 9863
TEST_TIME 61 9837
TEST_TIME 62 9777
TEST_TIME 63 9753
TEST_TIME 64 9673
TEST_TIME 65 9581
TEST_TIME 66 9607
TEST_TIME 67 9529
TEST_TIME 68 9601
TEST_TIME 69 9552
TEST_TIME 70 9561
TEST_TIME 71 9519
TEST_TIME 72 9432
TEST_TIME 73 9415
TEST_TIME 74 9369
TEST_TIME 75 9369
TEST_TIME 76 9457
TEST_TIME 77 9437
TEST_TIME 78 9449
TEST_TIME 79 9490
TEST_TIME 80 9483
TEST_TIME 81 9503
TEST_TIME 82 9544
TEST_TIME 83 9528
TEST_TIME 84 9624
TEST_TIME 85 9604
TEST_TIME 86 9624
TEST_TIME 87 9680
TEST_TIME 88 9630
TEST_TIME 89 9534
TEST_TIME 90 9509
TEST_TIME 91 9479
TEST_TIME 92 9493
TEST_TIME 93 9434
TEST_TIME 94 9402
TEST_TIME 95 9425
TEST_TIME 96 9405
TEST_TIME 97 9392
TEST_TIME 98 9442
TEST_TIME 99 9421
TEST_TIME 100 9403
TEST_TIME 101 9500
TEST_TIME 102 9473
TEST_TIME 103 9485
TEST_TIME 104 9503
TEST_TIME 105 9512
TEST_TIME 106 9499
TEST_TIME 107 9518
TEST_TIME 108 9492
TEST_TIME 109 9424
TEST_TIME 110 9406
TEST_TIME 111 9376
TEST_TIME 112 9355
TEST_TIME 113 9318
TEST_TIME 114 9294
TEST_TIME 115 9243
TEST_TIME 116 9308
TEST_TIME 117 9276
TEST_TIME 118 9313
TEST_TIME 119 9314
TEST_TIME 120 9263

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-02-2021 19:28:26 to 21-02-2021 19:28:30.

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 1538699 1538699 0 0.00 0 32739 6 0 0
doc_list_biud 1538699 1538699 0 0.00 0 52998 32 0 0
sp_add_invoice_to_stock 5093 4978 115 2.25 43 172067 18761 0 115
sp_cancel_adding_invoice 5744 5744 0 0.00 5 75852 859 0 0
sp_cancel_client_order 1773 1773 0 0.00 4 10845 343 0 0
sp_cancel_customer_reserve 560746 560746 0 0.00 1 32712 70 0 0
sp_cancel_pay_from_customer 668 668 0 0.00 2 8202 59 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 2 4837 136 0 0
sp_cancel_supplier_invoice 6384 6373 11 0.17 2 53005 872 0 11
sp_cancel_supplier_order 434 434 0 0.00 12 1096544 113788 0 0
sp_cancel_write_off 10133 10133 0 0.00 1 11457 128 0 0
sp_client_order 21142 21142 0 0.00 3 36840 361 0 0
sp_customer_reserve 462559 462559 0 0.00 0 121662 184 0 0
sp_fill_shopping_cart 32186 32186 0 0.00 1 11997 40 0 0
sp_fill_shopping_cart_clo_res 462554 462554 0 0.00 0 14683 14 0 0
sp_get_clo_for_invoice 4966 4966 0 0.00 0 23447 302 0 0
sp_kill_cost_storno 16955 16955 0 0.00 0 9272 67 0 0
sp_kill_qstorno_ret_qs2qd 1138432 1138432 0 0.00 0 52993 37 0 0
sp_kill_qty_storno 600316 600316 0 0.00 0 52996 80 0 0
sp_lock_selected_doc 20976 20976 0 0.00 0 8666 6 0 0
sp_make_cost_storno 28120 28120 0 0.00 0 19255 62 0 0
sp_multiply_rows_for_pdistr 28120 28120 0 0.00 0 11487 31 0 0
sp_multiply_rows_for_qdistr 21142 21142 0 0.00 0 21302 153 0 0
sp_pay_from_customer 7194 7194 0 0.00 4 13402 135 0 0
sp_pay_to_supplier 5813 5813 0 0.00 4 24206 179 0 0
sp_payment_common 13007 13007 0 0.00 1 24122 37 0 0
sp_qd_handle_on_cancel_clo 1773 1773 0 0.00 0 9812 295 0 0
sp_qd_handle_on_invoice_upd_sts 10710 10710 0 0.00 0 31548 367 0 0
sp_qd_handle_on_reserve_upd_sts 10147 10147 0 0.00 0 21107 68 0 0
sp_reserve_write_off 10147 10147 0 0.00 6 21122 205 0 0
sp_supplier_invoice 5535 5535 0 0.00 6 95202 3722 0 0
sp_supplier_order 5522 5522 0 0.00 6 51177 1325 0 0
srv_aggregate_perf_data 109 108 1 0.91 3056 155319 17256 0 1
srv_fill_mon_cache_memory 174 174 0 0.00 956 148480 29750 0 0
srv_find_qd_qs_mism 1062474 1062474 0 0.00 0 32737 5 0 0
srv_make_invnt_saldo 580 580 0 0.00 34 103834 1190 0 0
srv_make_money_saldo 777 777 0 0.00 1 10993 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 193153 323029 251718 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4978 4978 0 0.00 0 7552 162 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 0 7114 111 0 0
t$perf-norm:sp_cancel_client_order 1773 1773 0 0.00 0 5622 17 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 270 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 668 668 0 0.00 0 3424 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 281 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 2349 18 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 28230 1717 0 0
t$perf-norm:sp_cancel_write_off 1043 1043 0 0.00 0 3167 19 0 0
t$perf-norm:sp_client_order 21142 21142 0 0.00 0 7307 19 0 0
t$perf-norm:sp_customer_reserve 1024 1024 0 0.00 0 3891 12 0 0
t$perf-norm:sp_pay_from_customer 7194 7194 0 0.00 0 4614 9 0 0
t$perf-norm:sp_pay_to_supplier 5813 5813 0 0.00 0 5609 10 0 0
t$perf-norm:sp_reserve_write_off 10147 10147 0 0.00 0 4987 8 0 0
t$perf-norm:sp_supplier_invoice 5535 5535 0 0.00 0 6526 23 0 0
t$perf-norm:sp_supplier_order 5522 5522 0 0.00 0 6216 19 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 388 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 403 8 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 1818 26 0 0
t$perf-norm:srv_make_money_saldo 777 777 0 0.00 0 915 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 4 0 0
v_add_invoice_to_stock 10162 9932 230 2.26 0 17943 29 0 230
v_all_customers 38232 38232 0 0.00 0 20 1 0 0
v_all_suppliers 30704 30704 0 0.00 0 54 1 0 0
v_all_wares 42282 42282 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 5666 21 0 0
v_cancel_client_order 3546 3546 0 0.00 0 10642 13 0 0
v_cancel_customer_prepayment 1336 1336 0 0.00 0 534 4 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 4595 10 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 4816 20 0 0
v_cancel_supplier_invoice 866 844 22 2.54 0 7285 29 0 22
v_cancel_supplier_order 868 868 0 0.00 0 7253 17 0 0
v_cancel_write_off 2086 2086 0 0.00 0 8691 25 0 0
v_max_id_clo_ord 5522 5522 0 0.00 0 214 1 0 0
v_max_id_clo_res 1024 1024 0 0.00 0 3303 11 0 0
v_max_id_ord_sup 5523 5523 0 0.00 0 6389 6 0 0
v_max_non_paid_invoice 1506 1506 0 0.00 0 7146 8 0 0
v_max_non_paid_realizn 3882 3882 0 0.00 0 4344 6 0 0
v_min_id_clo_ord 5522 5522 0 0.00 0 4008 7 0 0
v_min_id_clo_res 1024 1024 0 0.00 0 6907 24 0 0
v_min_id_ord_sup 5523 5523 0 0.00 0 3644 5 0 0
v_min_non_paid_invoice 5813 5813 0 0.00 0 24118 24 0 0
v_min_non_paid_realizn 7194 7194 0 0.00 0 13198 23 0 0
v_our_firm 10674 10674 0 0.00 0 17 1 0 0
v_reserve_write_off 20294 20294 0 0.00 0 19785 13 0 0
x_lock_depdocs_on_canc_invoice 11695 11695 0 0.00 0 21152 140 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 11695 430 0 0
x_make_qstorno_1000_1200 5522 5522 0 0.00 1 51166 1245 0 0
x_make_qstorno_1200_2000 5535 5535 0 0.00 2 95189 3577 0 0
x_make_qstorno_2100_3300 462559 462559 0 0.00 0 121661 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2021 19:28:31 to 21-02-2021 19:28:35.

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:23 10 8192000000 8811090000 8824786944 15735184 0.191 3 3 5 0 15986784 77360 174240
16:57:30 9976 8192000000 10193249296 10490499072 833902672 9.238 67 52 106 0 855045824 2387888 18755264
16:57:48 25694 8192000000 10313208096 10627256320 1355650608 14.198 100 81 162 0 1386237968 4253984 26333376
16:58:22 27099 8192000000 10361414048 10680459264 1417050336 14.747 100 91 182 0 1452582560 5926240 29605984
16:58:59 26175 8192000000 10414832912 10739748864 1451929888 15.055 100 90 180 1 1488414736 7432560 29052288
16:59:35 28498 8192000000 10424836784 10757128192 1484562976 15.341 100 85 170 0 1520089920 8350160 27176784
17:00:14 19358 8192000000 10449160832 10783084544 1506130032 15.530 100 89 178 0 1543626064 9007328 28488704
17:00:48 17970 8192000000 10460822160 10803236864 1524397056 15.688 100 89 178 1 1562238064 9596912 28244096
17:01:15 15977 8192000000 10485098304 10830180352 1541136800 15.833 100 71 142 1 1572781504 9439504 22205200
17:01:39 9526 8192000000 10514770240 10859446272 1568803424 16.072 100 80 162 1 1603231152 9904096 24523632
17:01:56 15327 8192000000 10535671840 10889359360 1591216272 16.264 100 81 162 3 1626220592 10505232 24499088
17:02:25 3483 8192000000 10553863408 10909364224 1616946224 16.484 100 84 168 0 1652766912 10815056 25005632
17:02:38 11727 8192000000 10576569728 10933534720 1632575520 16.617 100 85 171 2 1669727952 11383808 25768624
17:02:56 13829 8192000000 10585459712 10946945024 1645075024 16.723 100 87 174 1 1682825328 11786560 25963744
17:03:17 7958 8192000000 10586723024 10951577600 1654974784 16.806 100 79 158 0 1689833536 11952128 22906624
17:03:33 9658 8192000000 10605490656 10971222016 1669709760 16.931 100 74 148 0 1702521664 11732464 21079440
17:03:50 9268 8192000000 10614183584 10984534016 1682977616 17.042 100 76 153 1 1716657136 11841280 21838240
17:04:06 7173 8192000000 10636667136 11007053824 1700997536 17.193 100 78 154 1 1734548448 11426688 22124224
17:04:21 7187 8192000000 10655695968 11023142912 1717322752 17.330 100 86 172 1 1754310528 12118144 24869632
17:04:35 5980 8192000000 10656681664 11033247744 1729439056 17.431 100 79 158 0 1764156528 12556448 22161024
17:04:49 4395 8192000000 10685234816 11055480832 1743045056 17.544 100 89 177 2 1780309680 12886352 24378272
17:05:01 4849 8192000000 10683958032 11061194752 1751317680 17.613 100 82 163 1 1787730080 13295456 23116944
17:05:13 5257 8192000000 10707302624 11082907648 1764066400 17.718 100 89 176 1 1803051344 14314160 24670784
17:05:25 3216 8192000000 10717762368 11094953984 1773683760 17.797 100 86 172 0 1815655632 17531968 24439904
17:05:35 3092 8192000000 10719383184 11098288128 1780667040 17.855 100 86 173 2 1819445344 14218432 24559872
17:05:46 3059 8192000000 10724755648 11103797248 1791399184 17.943 100 94 188 1 1832781648 14266928 27115536
17:05:55 3185 8192000000 10740024976 11119251456 1798257488 18.000 100 89 178 1 1837595344 14004864 25332992
17:06:05 3222 8192000000 10747288720 11126616064 1803118448 18.039 100 86 172 1 1841065664 14048640 23898576
17:06:16 9133 8192000000 10751051088 11132018688 1808164784 18.081 100 79 158 0 1844125328 14381968 21578576
17:06:32 4131 8192000000 10745809056 11129774080 1811550080 18.109 100 80 160 1 1847060416 13571888 21938448
17:06:42 2126 8192000000 10770619760 11151237120 1824123808 18.211 100 86 172 1 1861840656 13917728 23799120
17:06:51 3046 8192000000 10773468288 11158159360 1836712976 18.314 100 89 179 1 1875176624 13685520 24778128
17:07:00 1763 8192000000 10781155504 11168325632 1839386208 18.336 100 94 185 3 1879364736 13795616 26182912
17:07:08 2379 8192000000 10780841232 11168268288 1842639840 18.362 100 91 184 3 1882134480 14370464 25124176
17:07:17 1818 8192000000 10790374528 11176296448 1847095904 18.399 100 95 191 0 1887773648 13518416 27159328
17:07:25 1618 8192000000 10790670208 11175182336 1847371888 18.401 100 91 183 0 1886544864 13366352 25806624
17:07:33 1777 8192000000 10795800112 11181424640 1851655600 18.436 100 96 193 1 1892685360 13365696 27664064
17:07:41 2123 8192000000 10793241760 11179134976 1852066848 18.439 100 89 180 1 1892794224 15889664 24837712
17:07:49 2297 8192000000 10805103088 11190980608 1857175648 18.480 100 96 190 0 1898542976 14190368 27176960
17:07:58 1331 8192000000 10807405104 11193352192 1867998464 18.568 100 96 195 2 1909521264 13830656 27692144
17:08:06 1271 8192000000 10815547488 11202170880 1866018400 18.552 100 92 184 0 1905854416 13573280 26262736
17:08:13 1818 8192000000 10807231696 11197071360 1867744528 18.566 100 90 177 2 1904577920 11267232 25566160
17:08:21 4208 8192000000 10803700848 11207712768 1873221088 18.610 100 85 170 2 1910415792 13051072 24143632
17:08:46 17143 8192000000 10817163136 11209850880 1872322896 18.603 100 80 161 1 1904192640 8154336 23715408
17:09:09 4865 8192000000 10796988176 11206049792 1872390336 18.604 100 63 126 1 1900366592 9962448 18013808
17:09:21 4264 8192000000 10806775552 11210821632 1872546480 18.605 100 56 111 2 1896839888 8281456 16011952
17:09:35 3640 8192000000 10798377888 11212460032 1875312528 18.627 100 46 92 1 1897958496 10393552 12252416
17:09:45 5739 8192000000 10802152720 11210096640 1872909168 18.608 100 38 76 2 1891996208 8535536 10551504
17:09:57 8050 8192000000 10777625424 11205509120 1872703424 18.606 100 33 66 0 1890209568 8494896 9011248
17:10:16 5520 8192000000 10780371424 11210190848 1874142608 18.618 100 19 38 1 1885794224 5877456 5774160
17:10:30 14206 8192000000 10789339776 11218526208 1880398704 18.668 100 19 38 2 1891988816 6435456 5154656
17:10:51 11451 8192000000 10781561632 11222728704 1883751632 18.695 100 15 30 0 1894221984 6281824 4188528
17:11:13 12945 8192000000 10789244672 11226181632 1885585760 18.710 100 17 34 1 1900230272 10257600 4386912
17:11:32 12361 8192000000 10803643776 11232931840 1890905392 18.753 100 14 28 1 1900490992 6002992 3582608
17:11:51 14583 8192000000 10815482000 11233968128 1898227456 18.812 100 33 65 0 1912541248 5215632 9098160
17:12:12 74835 8192000000 10807192656 11242549248 1897981696 18.810 100 28 56 2 1911632128 5943728 7706704
17:13:34 5239 8192000000 10818821472 11257450496 1903351120 18.853 100 25 50 0 1921235184 11113792 6770272
17:13:45 7516 8192000000 10822698240 11250671616 1905550864 18.871 100 28 56 0 1920482096 6398160 8533072
17:13:59 7026 8192000000 10818612432 11256283136 1906322992 18.877 100 31 62 1 1921926352 7163024 8440336
17:14:14 7158 8192000000 10818465552 11254095872 1909647760 18.904 100 31 62 0 1924491536 5729152 9114624
17:14:28 8917 8192000000 10819396432 11256393728 1910691760 18.912 100 29 59 2 1925099936 5966272 8441904
17:14:44 9486 8192000000 10820208928 11261530112 1906953760 18.882 100 31 62 2 1926158512 9760832 9443920
17:14:59 9181 8192000000 10820418352 11253481472 1890492720 18.750 99 15 30 2 1900586416 5713312 4380384
17:15:18 10244 8192000000 10813233424 11242545152 1867625088 18.565 98 13 26 3 1876094688 4792496 3677104
17:15:37 8062 8192000000 10804066544 11241484288 1882525072 18.685 99 16 32 1 1893400000 5850272 5024656
17:15:51 11470 8192000000 10794298896 11228508160 1882487856 18.685 99 18 36 1 1893686928 5778608 5420464
17:16:09 11863 8192000000 10797051552 11233972224 1877239504 18.643 99 22 44 2 1890021264 6046352 6735408
17:16:32 11289 8192000000 10778128032 11211501568 1823971392 18.210 96 17 34 2 1835081344 6549552 4560400
17:16:49 8371 8192000000 10802731440 11221823488 1855151760 18.464 98 37 75 1 1871573552 5380160 11041632
17:17:10 58814 8192000000 10755861248 11182768128 1754444368 17.638 93 36 72 2 1770234816 5484720 10305728
17:18:17 8892 8192000000 10732518288 11148431360 1716571648 17.324 92 24 48 0 1729046640 5586704 6888288
17:18:32 6243 8192000000 10765810672 11186761728 1838160416 18.326 100 24 47 1 1850476624 5919952 6396256
17:18:48 5062 8192000000 10770907376 11186208768 1829972192 18.259 99 41 82 0 1849432016 8006704 11453120
17:19:00 3048 8192000000 10769448496 11190530048 1849788096 18.420 100 40 80 2 1869320640 7567488 11965056
17:19:11 10144 8192000000 10770652400 11188457472 1804670000 18.052 97 30 60 1 1819440336 6118032 8652304
17:19:29 6355 8192000000 10740047760 11161329664 1799367104 18.009 97 25 48 2 1812541360 6208656 6965600
17:19:44 5920 8192000000 10743743904 11167191040 1802263104 18.032 98 24 48 0 1814998592 5897008 6838480
17:19:58 9907 8192000000 10716417968 11127111680 1769395040 17.762 97 21 42 1 1781793680 5696752 6701888
17:20:14 12081 8192000000 10694173888 11106979840 1683663968 17.048 94 15 30 1 1693857824 5340784 4853072
17:20:34 8820 8192000000 10670960608 11085139968 1672159424 16.951 94 19 38 2 1682528848 4725296 5644128
17:20:51 12150 8192000000 10699774496 11118018560 1753997088 17.635 98 12 24 0 1762991520 5751168 3243264
17:21:12 6929 8192000000 10714339248 11132542976 1771013936 17.775 98 20 38 5 1782266528 5233488 6019104
17:21:27 20953 8192000000 10719749872 11143352320 1779710448 17.847 98 24 48 2 1792031568 5045104 7276016
17:21:57 70810 8192000000 10711735424 11132772352 1750544896 17.606 97 31 59 1 1764683600 5650144 8488560
17:23:15 5780 8192000000 10744088272 11161460736 1819793616 18.176 100 25 50 1 1837181744 10565264 6822864
17:23:28 5276 8192000000 10743340880 11168026624 1831232784 18.269 100 35 70 1 1847870416 6299920 10337712
17:23:42 10014 8192000000 10746771216 11161837568 1795277440 17.975 98 29 58 0 1809558576 5910784 8370352
17:23:58 8269 8192000000 10739597040 11164729344 1827495104 18.239 100 28 56 0 1843388576 7120256 8773216
17:24:13 7810 8192000000 10756860768 11178737664 1834263392 18.294 100 34 68 1 1855763104 12018848 9480864
17:24:30 9877 8192000000 10749268912 11176988672 1837503504 18.320 100 27 54 0 1851182512 5960544 7718464
17:24:45 7027 8192000000 10760973840 11182026752 1845457312 18.385 100 35 70 2 1866040464 10303040 10280112
17:25:00 7306 8192000000 10766692720 11189424128 1851363472 18.433 100 30 61 3 1865671184 5442896 8864816
17:25:16 9895 8192000000 10764703872 11193106432 1852084608 18.439 100 22 44 0 1864202416 5310608 6807200
17:25:33 7287 8192000000 10769617120 11196149760 1855719104 18.469 100 32 65 1 1870580576 4908240 9953232
17:25:46 8860 8192000000 10772300880 11203239936 1860315136 18.506 100 28 56 0 1877693392 9115424 8262832
17:26:04 8702 8192000000 10772281872 11202490368 1861917840 18.519 100 22 43 0 1873448224 5290336 6240048
17:26:20 9912 8192000000 10769987616 11204956160 1870115936 18.585 100 25 50 1 1883131376 5626192 7389248
17:26:39 29286 8192000000 10786709920 11213647872 1869395328 18.579 100 29 59 0 1884056624 5106800 9554496
17:27:42 58858 8192000000 10837643552 11257561088 1897677584 18.808 100 50 98 2 1923042016 11498416 13866016
17:29:23 15493 8192000000 10851940112 11274469376 1915611408 18.952 100 49 98 0 1940589312 11171536 13806368
17:29:46 10377 8192000000 10863500880 11281752064 1928285680 19.053 100 60 120 3 1960446224 15111072 17049472
17:30:06 13771 8192000000 10869793072 11294457856 1931571040 19.079 100 57 114 0 1963459376 15855552 16032784
17:30:33 18012 8192000000 10880197984 11305168896 1940750272 19.153 100 50 100 1 1969441584 14309632 14381680
17:31:02 15367 8192000000 10883555664 11310809088 1945046736 19.187 100 51 102 1 1974519904 14340256 15132912
17:31:25 15526 8192000000 10886190528 11320119296 1951480912 19.238 100 45 90 0 1985057920 20201760 13375248
17:32:00 8686 8192000000 10897178048 11326763008 1959882480 19.305 100 52 105 0 1990903168 14983008 16037680
17:32:21 13663 8192000000 10909392448 11335704576 1969481856 19.381 100 52 103 0 1999787856 15710368 14595632
17:32:43 6614 8192000000 10903396000 11338543104 1969072784 19.378 100 41 82 0 1997745456 16872128 11800544
17:32:57 13809 8192000000 10921756352 11351089152 1975834976 19.432 100 48 97 1 2007131680 16275072 15021632
17:33:20 3772 8192000000 10934049792 11356200960 1985263360 19.506 100 69 138 2 2024275936 18580048 20432528
17:33:37 6656 8192000000 10945541184 11367960576 1988690288 19.533 100 67 134 2 2028488864 19987168 19811408
17:33:52 8428 8192000000 10913981440 11349368832 1967755024 19.368 99 52 104 2 2000755248 17667024 15333200
17:34:33 11938 8192000000 10921965440 11354980352 1980638320 19.470 100 38 76 3 2010273264 17672208 11962736
17:35:02 7597 8192000000 10921403552 11358507008 1983942496 19.496 100 39 78 2 2015745632 18955248 12847888
17:35:17 4530 8192000000 10931233504 11364827136 1985847648 19.511 100 45 88 3 2018275536 19086224 13341664
17:35:31 20113 8192000000 10946838608 11373682688 1995375840 19.586 100 61 121 1 2033847040 20276496 18194704
17:36:01 4766 8192000000 10943837968 11377012736 1998769824 19.613 100 57 113 0 2037625760 22112048 16743888
17:36:15 4435 8192000000 10951331392 11378667520 2003105840 19.647 100 70 139 1 2045667728 21314384 21247504
17:36:29 3273 8192000000 10940203856 11363958784 1962435184 19.325 98 58 115 1 2005820000 26073120 17311696
17:36:39 5635 8192000000 10938560240 11370422272 1988936960 19.535 100 58 115 1 2032368864 25522352 17909552
17:36:54 4946 8192000000 10942299792 11366584320 1974807232 19.424 99 68 133 2 2017520416 22663248 20049936
17:37:07 4480 8192000000 10938754224 11364397056 1987318224 19.523 100 61 122 1 2026241168 21471232 17451712
17:37:20 2053 8192000000 10940929952 11360526336 1975656256 19.430 99 82 163 2 2021810144 21807280 24346608
17:37:30 7049 8192000000 10948912496 11371220992 1986819808 19.519 100 70 140 2 2030486384 23355152 20311424
17:37:44 5257 8192000000 10954081376 11369799680 1993205296 19.569 100 77 155 1 2039407280 23680304 22521680
17:37:56 13564 8192000000 10926149936 11349544960 1952392800 19.246 98 60 120 0 1994682576 24237296 18052480
17:38:21 14011 8192000000 10938981664 11353751552 1962454880 19.326 99 74 148 0 2012478608 27843328 22180400
17:38:43 2733 8192000000 10945421440 11366453248 1979503536 19.461 100 71 142 1 2033108864 31929632 21675696
17:38:53 11228 8192000000 10936525600 11366551552 1981107200 19.473 100 61 122 0 2029864656 29905616 18851840
17:39:14 1752 8192000000 10937028736 11353124864 1968246352 19.372 99 73 146 2 2022390464 31845616 22298496
17:39:22 4402 8192000000 10967507904 11376906240 1986957824 19.520 100 78 154 1 2044255648 33092320 24205504
17:39:35 4884 8192000000 10952865712 11379245056 1982748752 19.486 100 68 137 1 2038989792 35028320 21212720
17:39:52 4993 8192000000 10955109984 11379773440 1985144816 19.505 100 56 111 2 2038098656 34913728 18040112
17:40:05 2703 8192000000 10957781552 11388268544 1993189872 19.569 100 73 143 3 2052623104 36536800 22896432
17:40:16 2934 8192000000 10955254336 11379826688 1986843744 19.519 100 72 144 1 2044652688 35024272 22784672
17:40:26 3450 8192000000 10965421552 11386937344 1990147104 19.545 100 72 143 3 2049308176 36728560 22432512
17:40:37 11031 8192000000 10943727136 11369484288 1964259808 19.340 99 64 127 1 2023032832 39036800 19736224
17:40:58 3147 8192000000 10939196048 11354595328 1943727952 19.176 98 70 140 1 2004947536 37553584 23666000
17:41:09 2939 8192000000 10952544464 11373944832 1976454528 19.437 100 72 142 1 2037981568 38969280 22557760
17:41:21 3823 8192000000 10942081168 11372199936 1973070800 19.410 100 68 135 3 2034532480 40162832 21298848
17:41:31 1269 8192000000 10961484544 11380019200 1980750080 19.471 100 86 171 2 2043646432 36669104 26227248
17:41:40 4591 8192000000 10947194800 11381215232 1980498384 19.469 100 67 134 2 2037670544 35708432 21463728
17:41:52 954 8192000000 10947522416 11360063488 1951137840 19.236 98 86 166 2 2014143184 36658176 26347168
17:42:01 7174 8192000000 10934315280 11358384128 1958682000 19.296 99 66 132 1 2012939328 34171200 20086128
17:42:18 10026 8192000000 10945974384 11368042496 1970723616 19.391 100 75 150 2 2030128544 36562448 22842480
17:42:35 2773 8192000000 10936683904 11363368960 1951998048 19.242 99 64 126 1 2008342384 36508576 19835760
17:42:46 4397 8192000000 10926616192 11355627520 1959865264 19.305 100 60 120 0 2013934704 35494368 18575072
17:42:57 3433 8192000000 10938217520 11363106816 1933453024 19.094 98 72 145 2 1990298384 34707616 22137744
17:43:09 3691 8192000000 10935944928 11351306240 1945274208 19.189 99 72 142 1 2002826944 34740880 22811856
17:43:20 4504 8192000000 10948052368 11371282432 1972726752 19.407 100 77 153 1 2033323248 36483680 24112816
17:43:33 3550 8192000000 10941330064 11351740416 1937854864 19.130 98 81 159 3 2000178208 37507280 24816064
17:43:46 3792 8192000000 10946387296 11364675584 1961565632 19.318 100 78 156 1 2025411936 39558128 24288176
17:43:57 3018 8192000000 10933355280 11349999616 1954995696 19.266 100 75 150 1 2017608688 39402896 23210096
17:44:08 1669 8192000000 10923863440 11337584640 1938088496 19.131 99 82 163 2 2005364448 41800768 25475184
17:44:17 3045 8192000000 10938218640 11345784832 1949775696 19.225 99 81 161 0 2019920384 45326272 24818416
17:44:27 1927 8192000000 10954302992 11366330368 1963074480 19.330 100 88 173 1 2036226320 46801920 26349920
17:44:38 3507 8192000000 10952469728 11368337408 1959021344 19.298 100 73 145 0 2028359440 46892720 22445376
17:44:50 11796 8192000000 10958276688 11376545792 1967166576 19.363 100 73 146 2 2037240000 47626048 22447376
17:45:09 2678 8192000000 10979806704 11400982528 1983650976 19.494 100 78 156 0 2061570976 53632864 24287136
17:45:18 2660 8192000000 10983098368 11397058560 1980129344 19.466 100 80 160 0 2062300384 56946576 25224464
17:45:29 3089 8192000000 10992350400 11402055680 1988030352 19.528 100 94 188 0 2076788176 58958384 29799440
17:45:40 1521 8192000000 10992992448 11403087872 1987385424 19.523 100 88 172 2 2073695168 58747536 27562208
17:45:49 4968 8192000000 10983698752 11401203712 1968369488 19.373 99 75 146 2 2050078400 58881776 22827136
17:46:04 1612 8192000000 10962726016 11375624192 1948005488 19.211 98 81 163 2 2032716624 59544832 25166304
17:46:13 3070 8192000000 10990524656 11400519680 1978339424 19.452 100 92 184 2 2067845952 61183184 28323344
17:46:25 5487 8192000000 10976222256 11384860672 1971781728 19.400 100 89 177 1 2056300624 56590112 27928784
17:46:38 2942 8192000000 10957596240 11362603008 1955402096 19.269 99 87 170 1 2036212544 54055184 26755264
17:46:49 2092 8192000000 10985622096 11391123456 1975789280 19.431 100 85 169 1 2059226960 57022304 26415376
17:46:59 2821 8192000000 11000253616 11403821056 1986979792 19.520 100 89 178 1 2074071584 58423968 28667824
17:47:11 3207 8192000000 10997131280 11412205568 1990908192 19.551 100 85 170 0 2077319264 59619968 26791104
17:47:24 3128 8192000000 10990116976 11401715712 1977211296 19.443 99 83 165 0 2064868384 60914464 26742624
17:47:33 1687 8192000000 10991123520 11412328448 1990187216 19.545 100 76 150 0 2074805200 60471440 24146544
17:47:42 2228 8192000000 11004704704 11419971584 1991190736 19.553 100 82 164 1 2079993792 62738192 26064864
17:47:51 2707 8192000000 10979072912 11389546496 1959932368 19.306 99 71 140 0 2040319616 57581920 22805328
17:48:05 9049 8192000000 10971102384 11394244608 1977634560 19.446 100 62 125 0 2053649456 55680368 20334528
17:48:23 10205 8192000000 10963165392 11382530048 1971773168 19.400 100 55 111 2 2042870992 53762032 17335792
17:48:40 4040 8192000000 10960336432 11376906240 1964064240 19.338 100 72 144 2 2042309584 54520560 23724784
17:48:56 7608 8192000000 10953504688 11383721984 1963603856 19.335 100 47 94 0 2031511280 52942128 14965296
17:49:10 14809 8192000000 10956410512 11391537152 1974541888 19.421 100 39 78 0 2041680912 53715952 13423072
17:49:32 6053 8192000000 10971622368 11402964992 1988405776 19.531 100 48 94 3 2058893168 54638608 15848784
17:49:46 7658 8192000000 10992000848 11414659072 1995327136 19.586 100 63 123 4 2075977808 60811856 19838816
17:50:06 2697 8192000000 10994527440 11419426816 1997835136 19.606 100 62 124 1 2075829504 57434080 20560288
17:50:19 12637 8192000000 10994703872 11427733504 1998854448 19.614 100 56 112 0 2077074144 59996336 18223360
17:50:41 25602 8192000000 10988198288 11430027264 2000533728 19.627 100 42 84 0 2073858592 58902976 14421888
17:51:20 8726 8192000000 10998660736 11429048320 1983338240 19.491 99 49 97 1 2059781696 59644480 16798976
17:51:50 7236 8192000000 11003924128 11444822016 2004270240 19.656 100 40 81 1 2081899856 63657696 13971920
17:52:07 11859 8192000000 11008118560 11445178368 2005501824 19.666 100 46 90 0 2090058416 68231824 16324768
17:52:28 13128 8192000000 10998660976 11453509632 2004826816 19.661 100 38 76 1 2087940176 69997520 13115840
17:53:00 22560 8192000000 10977292496 11420573696 1963033872 19.330 99 32 64 1 2046285600 71958464 11293264
17:53:32 16836 8192000000 10982648400 11426844672 1971750832 19.399 100 32 64 2 2066527696 83322448 11454416
17:54:11 6627 8192000000 10996364304 11446763520 1981855824 19.479 100 37 74 2 2080825904 86067296 12902784
17:54:35 13723 8192000000 10983623344 11442581504 1976274048 19.435 100 49 98 1 2068840464 75705568 16860848
17:55:11 21850 8192000000 10978639984 11441090560 1975258128 19.427 100 33 66 2 2064457536 76858528 12340880
17:55:48 17894 8192000000 10953910592 11447754752 1974526144 19.421 100 24 48 0 2066633248 83279088 8828016
17:56:55 21388 8192000000 10951048208 11403444224 1950924048 19.234 100 20 40 1 2023439280 65110576 7404656
17:57:40 29815 8192000000 10911903120 11368366080 1935642368 19.112 99 20 36 4 1989920032 48644112 5633552
17:58:18 19534 8192000000 10864225808 11324149760 1904728752 18.864 97 13 26 2 1917395184 8578016 4088416
17:58:54 36311 8192000000 10894035504 11333390336 1951868528 19.241 100 48 97 1 1970910656 5423584 13618544
17:59:40 40066 8192000000 10870962016 11347701760 1954191984 19.260 100 25 50 1 1974003344 12184336 7627024
18:00:48 59097 8192000000 10902220464 11353280512 1949000112 19.219 99 34 68 0 1971168144 12784704 9383328
18:02:06 85320 8192000000 10910996912 11384840192 1971544336 19.398 100 12 24 0 1991558160 15704512 4309312
18:03:38 88495 8192000000 10922115200 11368136704 1943699136 19.176 98 31 62 2 1963332368 11304256 8328976
18:05:22 82852 8192000000 10914531728 11376656384 1958624096 19.295 99 21 41 1 1974183936 10384400 5175440
18:06:58 57964 8192000000 10931662032 11386277888 1947748560 19.209 98 30 60 1 1963744416 6769952 9225904
18:08:02 61276 8192000000 10903809488 11372957696 1945128720 19.188 98 24 47 4 1969160656 17034464 6997472
18:09:10 122797 8192000000 10938323408 11405520896 1966071360 19.354 99 8 16 0 1993379296 25013696 2294240
18:11:19 78297 8192000000 10904142496 11382964224 1906791664 18.881 96 17 34 0 1935631200 23323488 5516048
18:13:03 146134 8192000000 10902900720 11375878144 1951007952 19.235 99 4 8 0 1967259376 14850160 1401264
18:15:54 133638 8192000000 10926670784 11374538752 1927638576 19.048 97 18 35 1 1945404720 12302208 5463936
18:18:54 59371 8192000000 10906567984 11375411200 1983448176 19.492 100 40 80 1 2004962304 9818976 11695152
18:20:03 65801 8192000000 10916126960 11391156224 1967766128 19.368 99 33 66 1 1988226256 11190336 9269792
18:21:31 57461 8192000000 10929272416 11381321728 1951506032 19.238 98 28 56 3 1966766768 8026576 7234160
18:22:35 7681 8192000000 10956481056 11401707520 2004974176 19.662 100 77 155 1 2041078560 13869632 22234752
18:23:20 148480 8192000000 10849264800 11317805056 1773906256 17.799 89 22 44 1 1789117488 8713680 6497552
18:25:59 53764 8192000000 10899339840 11344515072 1929333568 19.062 99 26 53 0 1945728896 8710704 7684624
18:27:12 48764 8192000000 10879450256 11336376320 1885117984 18.706 96 36 72 0 1902657488 7681024 9858480
18:28:08 6571 8192000000 10901044608 11353452544 1967311488 19.364 100 40 80 0 1985922496 7479824 11131184
18:28:21 53404 8192000000 10892432176 11368890368 1968761872 19.376 100 28 54 1 1985239296 8808624 7668800
18:29:21 68492 8192000000 10868666752 11342667776 1874867888 18.624 95 11 22 0 1885830816 7685328 3277600
18:30:37 20541 8192000000 10874523680 11356078080 1938282240 19.133 99 8 16 0 1950131984 9843424 2006320
18:31:09 74049 8192000000 10878281776 11343867904 1907444320 18.886 97 16 32 2 1925785984 13844160 4497504
18:32:31 84494 8192000000 10882961168 11353579520 1921944256 19.002 98 22 44 0 1945419216 16844624 6630336
18:34:04 67012 8192000000 10890884656 11363807232 1948080352 19.211 99 28 55 0 1968104656 11995968 8028336
18:35:17 43762 8192000000 10882860752 11340767232 1891778192 18.760 96 22 45 0 1904980912 7029504 6173216
18:36:07 40549 8192000000 10890418448 11356672000 1942486400 19.167 99 41 83 0 1961874736 7473568 11914768
18:36:57 47234 8192000000 10869109936 11349188608 1941221456 19.157 99 17 33 2 1956635104 10591328 4822320
18:37:53 44793 8192000000 10872070608 11350540288 1938532832 19.135 99 19 36 2 1954686272 10318624 5834816
18:39:36 42063 8192000000 10829085936 11302981632 1862200576 18.521 95 21 42 1 1876738400 8959936 5577888
18:40:28 87569 8192000000 10836316592 11307778048 1840648704 18.346 96 12 24 0 1852511280 8480512 3382064
18:42:03 38706 8192000000 10847454336 11326255104 1893234416 18.772 98 20 40 2 1909689200 11187008 5267776
18:42:51 41926 8192000000 10867281840 11328778240 1887229648 18.723 98 29 58 0 1909402064 14248848 7923568
18:43:44 61003 8192000000 10869637520 11327463424 1880309920 18.668 97 22 42 3 1896456528 10265104 5881504
18:44:53 19298 8192000000 10884939664 11348144128 1942092736 19.163 100 30 60 2 1960033600 9951920 7988944
18:45:22 28067 8192000000 10852040784 11317788672 1888108880 18.731 97 35 70 1 1907800448 9880384 9811184
18:45:56 36605 8192000000 10861512960 11324481536 1895649600 18.791 98 35 70 1 1916451584 10991216 9810768
18:46:45 46977 8192000000 10896827696 11345752064 1924966768 19.027 99 23 46 0 1940994272 9584656 6442848
18:47:53 58437 8192000000 10881647344 11355422720 1953925600 19.258 100 14 28 1 1969524624 11625072 3973952
18:48:59 63693 8192000000 10895905184 11367493632 1941638672 19.160 99 16 32 0 1954190656 8564128 3987856
18:50:13 31165 8192000000 10902424592 11360964608 1941824656 19.161 99 26 52 1 1960336736 10601968 7910112
18:50:58 54126 8192000000 10874572304 11363094528 1924005552 19.019 98 25 50 0 1942538736 11684480 6848704
18:52:27 21703 8192000000 10895916224 11345846272 1917521648 18.967 98 33 65 1 1935631424 9066304 9043472
18:53:01 25678 8192000000 10905131168 11371913216 1957153008 19.283 100 16 32 1 1978579120 17037568 4388544
18:53:32 88872 8192000000 10905208992 11370512384 1946321376 19.197 99 17 33 1 1966434176 15256448 4856352
18:55:08 92241 8192000000 10872572544 11331239936 1909273872 18.901 97 17 34 2 1920254304 6567952 4412480
18:56:47 75670 8192000000 10873105520 11350769664 1901563024 18.839 97 37 74 0 1925676656 14175136 9938496
18:58:14 7637 8192000000 10869896032 11348733952 1946984608 19.202 100 22 44 2 1968177376 14902608 6290160
18:58:29 48146 8192000000 10868220944 11339952128 1919212112 18.981 98 31 62 1 1941306640 13536176 8558352
18:59:33 73016 8192000000 10878628864 11360542720 1938371504 19.134 99 11 22 0 1947627216 6203536 3052176
19:00:52 49684 8192000000 10863252000 11350355968 1922841456 19.010 98 7 14 0 1934279200 9928688 1509056
19:01:48 32983 8192000000 10863623584 11348996096 1932758112 19.089 99 6 12 0 1945252800 10740448 1754240
19:02:34 62960 8192000000 10892257872 11370680320 1945991056 19.195 99 6 12 0 1955204496 7842736 1370704
19:03:47 36329 8192000000 10894802240 11368546304 1953591616 19.255 99 19 38 1 1968059392 9125344 5342432
19:04:29 43707 8192000000 10896999408 11366236160 1919050448 18.979 97 26 52 3 1940193920 13741408 7402064
19:05:23 59246 8192000000 10881819872 11366469632 1922519648 19.007 98 18 36 1 1935487152 7898240 5069264
19:06:28 45328 8192000000 10909292080 11379273728 1954638736 19.263 99 27 53 2 1978781632 16342160 7800736
19:07:25 116009 8192000000 10871824384 11346808832 1825181040 18.220 93 20 40 1 1852558112 21840608 5536464
19:09:32 91519 8192000000 10884595712 11352141824 1916575120 18.959 98 20 40 0 1932603872 10894368 5134384
19:11:16 46271 8192000000 10874769536 11349827584 1923481888 19.015 98 17 34 2 1939534672 10885264 5167520
19:12:14 90671 8192000000 10886718640 11324309504 1815856032 18.144 93 27 54 1 1834839728 11622176 7361520
19:13:52 31979 8192000000 10870084544 11335045120 1930822640 19.073 100 31 62 0 1949843328 10240416 8780272
19:14:30 39993 8192000000 10879153280 11333165056 1882007296 18.681 97 18 36 1 1895348944 8601424 4740224
19:15:21 87848 8192000000 10871492352 11343364096 1947477728 19.206 100 21 42 1 1965252928 11504048 6271152
19:17:01 57094 8192000000 10874708224 11342405632 1932169776 19.084 99 30 60 0 1950117456 9127520 8820160
19:18:04 57276 8192000000 10879261120 11355766784 1951481008 19.238 100 22 44 0 1967213792 9246928 6485856
19:19:12 52069 8192000000 10880777456 11363094528 1963165568 19.331 100 8 16 0 1977946912 12313488 2467856
19:20:18 14101 8192000000 10868840368 11352432640 1922090128 19.004 98 10 19 0 1937344944 12591808 2663008
19:20:38 23243 8192000000 10863198736 11339223040 1924732960 19.025 99 10 20 1 1940666704 13099872 2833872
19:21:43 58162 8192000000 10875611216 11351162880 1954389424 19.261 100 13 26 0 1971907200 13857424 3660352
19:22:49 77659 8192000000 10856922688 11333795840 1867054336 18.560 96 9 19 0 1881559184 11573552 2931296
19:24:13 26578 8192000000 10866534608 11325825024 1885566080 18.710 97 26 51 1 1899958144 6983456 7408608
19:24:47 64117 8192000000 10846002144 11322679296 1892483440 18.766 98 22 45 0 1909797920 10239872 7074608
19:25:58 69025 8192000000 10871605072 11331342336 1871089744 18.593 97 16 32 0 1886033248 10279840 4663664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 21-02-2021 19:28:36 to 21-02-2021 19:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 115 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-02-2021 19:29:10 to 21-02-2021 19:29:12.

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          241115
MON$OLDEST_ACTIVE               241701
MON$OLDEST_SNAPSHOT             241701
MON$NEXT_TRANSACTION            241701
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                       2057888
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:99: 
:100: mscs-test-161.budzdorov.ru    Sun Feb 21 19:27:26 2021
:101:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:102: 
:103: 
:104: mscs-test-161.budzdorov.ru    Sun Feb 21 19:27:29 2021
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Sun Feb 21 19:27:29 2021
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
--- end of diff output ---

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

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