Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.12.2020 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 17568004 kB
MemAvailable 31590584 kB
Buffers 0 kB
Cached 14159476 kB
SwapCached 3704 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-10 19:27:03
DTS_END                         2020-12-10 19:27:03.3340
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/43354
TRN_ID                          242947
ATT_ID                          668
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: 9235.36 24265 1108243
customer order: creation 167.30 375 20076
customer order: refuse 14.78 291 1773
order to supplier: creation 46.38 1217 5565
order to supplier: removal 3.39 89507 407
invoice (draft): creation 45.75 3261 5490
invoice (draft): removal 54.68 682 6562
invoice accept: apply 39.94 16654 4793
invoice accept: cancel 49.03 734 5883
customer reserve: creation 3655.29 165 438635
customer reserve: removal 4868.46 48 584215
realization accept: apply 80.52 159 9662
realization accept: cancel 83.97 97 10076
payment from customer: creation 57.47 125 6896
payment from customer: removal 5.27 66 632
payment to supplier: creation 48.23 125 5788
payment to supplier: removal 3.31 91 397
service: total inventory turnovers 4.68 1091 561
service: total monetary turnovers 6.12 25 734
service: aggregate perf. data 0.78 22806 94
service: refresh index statistics 0.03 347783 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-12-2020 19:29:09 to 10-12-2020 19:29:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6966
TEST_TIME 2 7456
TEST_TIME 3 6543
TEST_TIME 4 6822
TEST_TIME 5 6612
TEST_TIME 6 6727
TEST_TIME 7 7233
TEST_TIME 8 7115
TEST_TIME 9 7066
TEST_TIME 10 7288
TEST_TIME 11 7438
TEST_TIME 12 7516
TEST_TIME 13 8062
TEST_TIME 14 9215
TEST_TIME 15 9099
TEST_TIME 16 9176
TEST_TIME 17 9280
TEST_TIME 18 9557
TEST_TIME 19 10217
TEST_TIME 20 10059
TEST_TIME 21 10749
TEST_TIME 22 11056
TEST_TIME 23 11268
TEST_TIME 24 11063
TEST_TIME 25 11031
TEST_TIME 26 10709
TEST_TIME 27 10562
TEST_TIME 28 10755
TEST_TIME 29 10605
TEST_TIME 30 10496
TEST_TIME 31 10433
TEST_TIME 32 10294
TEST_TIME 33 10466
TEST_TIME 34 10325
TEST_TIME 35 10356
TEST_TIME 36 10156
TEST_TIME 37 10060
TEST_TIME 38 10034
TEST_TIME 39 9995
TEST_TIME 40 9909
TEST_TIME 41 9861
TEST_TIME 42 9802
TEST_TIME 43 9765
TEST_TIME 44 9617
TEST_TIME 45 9672
TEST_TIME 46 9560
TEST_TIME 47 9428
TEST_TIME 48 9367
TEST_TIME 49 9277
TEST_TIME 50 9191
TEST_TIME 51 9171
TEST_TIME 52 9218
TEST_TIME 53 9297
TEST_TIME 54 9359
TEST_TIME 55 9491
TEST_TIME 56 9414
TEST_TIME 57 9468
TEST_TIME 58 9500
TEST_TIME 59 9434
TEST_TIME 60 9711
TEST_TIME 61 9761
TEST_TIME 62 9753
TEST_TIME 63 9763
TEST_TIME 64 9658
TEST_TIME 65 9602
TEST_TIME 66 9534
TEST_TIME 67 9505
TEST_TIME 68 9482
TEST_TIME 69 9421
TEST_TIME 70 9373
TEST_TIME 71 9446
TEST_TIME 72 9396
TEST_TIME 73 9413
TEST_TIME 74 9435
TEST_TIME 75 9427
TEST_TIME 76 9550
TEST_TIME 77 9536
TEST_TIME 78 9568
TEST_TIME 79 9518
TEST_TIME 80 9570
TEST_TIME 81 9644
TEST_TIME 82 9602
TEST_TIME 83 9575
TEST_TIME 84 9502
TEST_TIME 85 9520
TEST_TIME 86 9486
TEST_TIME 87 9433
TEST_TIME 88 9373
TEST_TIME 89 9419
TEST_TIME 90 9389
TEST_TIME 91 9359
TEST_TIME 92 9319
TEST_TIME 93 9351
TEST_TIME 94 9382
TEST_TIME 95 9380
TEST_TIME 96 9444
TEST_TIME 97 9460
TEST_TIME 98 9470
TEST_TIME 99 9454
TEST_TIME 100 9463
TEST_TIME 101 9442
TEST_TIME 102 9503
TEST_TIME 103 9551
TEST_TIME 104 9547
TEST_TIME 105 9577
TEST_TIME 106 9584
TEST_TIME 107 9567
TEST_TIME 108 9497
TEST_TIME 109 9464
TEST_TIME 110 9445
TEST_TIME 111 9476
TEST_TIME 112 9429
TEST_TIME 113 9400
TEST_TIME 114 9352
TEST_TIME 115 9345
TEST_TIME 116 9301
TEST_TIME 117 9293
TEST_TIME 118 9324
TEST_TIME 119 9311
TEST_TIME 120 9237

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-12-2020 19:29:12 to 10-12-2020 19:29:16.

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 1515975 1515975 0 0.00 0 14635 6 0 0
doc_list_biud 1515972 1515972 0 0.00 0 37084 24 0 0
sp_add_invoice_to_stock 4894 4793 101 2.06 45 213498 16655 0 101
sp_cancel_adding_invoice 5883 5883 0 0.00 5 53459 735 0 0
sp_cancel_client_order 1773 1773 0 0.00 5 9695 291 0 0
sp_cancel_customer_reserve 584215 584215 0 0.00 1 36814 49 0 0
sp_cancel_pay_from_customer 632 632 0 0.00 3 8639 66 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 5581 92 0 0
sp_cancel_supplier_invoice 6577 6562 15 0.22 2 37092 683 0 15
sp_cancel_supplier_order 407 407 0 0.00 8 689626 89508 0 0
sp_cancel_write_off 10076 10076 0 0.00 1 14917 98 0 0
sp_client_order 20076 20076 0 0.00 3 35889 376 0 0
sp_customer_reserve 438635 438635 0 0.00 0 43168 166 0 0
sp_fill_shopping_cart 31123 31123 0 0.00 1 42775 45 0 0
sp_fill_shopping_cart_clo_res 438632 438632 0 0.00 0 29678 16 0 0
sp_get_clo_for_invoice 4790 4790 0 0.00 0 25901 341 0 0
sp_kill_cost_storno 16988 16988 0 0.00 0 8560 47 0 0
sp_kill_qstorno_ret_qs2qd 1185475 1185475 0 0.00 0 37078 27 0 0
sp_kill_qty_storno 623365 623365 0 0.00 0 37082 58 0 0
sp_lock_selected_doc 20187 20187 0 0.00 0 7531 5 0 0
sp_make_cost_storno 27135 27135 0 0.00 0 14627 48 0 0
sp_multiply_rows_for_pdistr 27134 27134 0 0.00 0 8484 26 0 0
sp_multiply_rows_for_qdistr 20076 20076 0 0.00 0 12338 154 0 0
sp_pay_from_customer 6896 6896 0 0.00 4 20067 126 0 0
sp_pay_to_supplier 5788 5788 0 0.00 5 12256 125 0 0
sp_payment_common 12684 12684 0 0.00 1 8607 32 0 0
sp_qd_handle_on_cancel_clo 1773 1773 0 0.00 0 9433 246 0 0
sp_qd_handle_on_invoice_upd_sts 10670 10670 0 0.00 0 24387 304 0 0
sp_qd_handle_on_reserve_upd_sts 9662 9662 0 0.00 0 10788 51 0 0
sp_reserve_write_off 9662 9662 0 0.00 6 10815 160 0 0
sp_supplier_invoice 5490 5490 0 0.00 6 113829 3262 0 0
sp_supplier_order 5565 5565 0 0.00 5 34492 1218 0 0
srv_aggregate_perf_data 95 94 1 1.05 2976 361912 22807 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 1386 158254 35502 0 0
srv_find_qd_qs_mism 1062818 1062818 0 0.00 0 10039 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 14 127524 1091 0 0
srv_make_money_saldo 734 734 0 0.00 1 3109 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 245125 422174 347784 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 4793 4793 0 0.00 0 10872 156 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 11370 120 0 0
t$perf-norm:sp_cancel_client_order 1773 1773 0 0.00 0 4078 13 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 1264 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 632 632 0 0.00 0 4467 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 1223 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 2981 20 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 18673 1592 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 5897 10 0 0
t$perf-norm:sp_client_order 20076 20076 0 0.00 0 10816 15 0 0
t$perf-norm:sp_customer_reserve 965 965 0 0.00 0 6746 13 0 0
t$perf-norm:sp_pay_from_customer 6896 6896 0 0.00 0 7870 13 0 0
t$perf-norm:sp_pay_to_supplier 5788 5788 0 0.00 0 4293 11 0 0
t$perf-norm:sp_reserve_write_off 9662 9662 0 0.00 0 5819 12 0 0
t$perf-norm:sp_supplier_invoice 5490 5490 0 0.00 0 7945 17 0 0
t$perf-norm:sp_supplier_order 5565 5565 0 0.00 0 4532 14 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 978 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 839 12 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 858 15 0 0
t$perf-norm:srv_make_money_saldo 734 734 0 0.00 0 1761 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9774 9572 202 2.06 0 5233 22 0 202
v_all_customers 36438 36438 0 0.00 0 73 0 0 0
v_all_suppliers 30430 30430 0 0.00 0 19 1 0 0
v_all_wares 40152 40152 0 0.00 0 145 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 1805 13 0 0
v_cancel_client_order 3546 3546 0 0.00 0 9624 13 0 0
v_cancel_customer_prepayment 1264 1264 0 0.00 0 8460 10 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 3047 7 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 3998 11 0 0
v_cancel_supplier_invoice 862 832 30 3.48 0 9525 30 0 30
v_cancel_supplier_order 814 814 0 0.00 0 5632 11 0 0
v_cancel_write_off 2002 2002 0 0.00 0 5451 24 0 0
v_max_id_clo_ord 5563 5563 0 0.00 0 1942 2 0 0
v_max_id_clo_res 965 965 0 0.00 0 1143 8 0 0
v_max_id_ord_sup 5481 5481 0 0.00 0 1105 2 0 0
v_max_non_paid_invoice 1617 1617 0 0.00 0 1555 3 0 0
v_max_non_paid_realizn 3747 3747 0 0.00 0 3123 5 0 0
v_min_id_clo_ord 5563 5563 0 0.00 0 2369 6 0 0
v_min_id_clo_res 965 965 0 0.00 0 2031 10 0 0
v_min_id_ord_sup 5481 5481 0 0.00 0 9413 13 0 0
v_min_non_paid_invoice 5788 5788 0 0.00 0 8380 22 0 0
v_min_non_paid_realizn 6896 6896 0 0.00 0 8420 22 0 0
v_our_firm 10012 10012 0 0.00 0 14 1 0 0
v_reserve_write_off 19324 19324 0 0.00 0 8346 8 0 0
x_lock_depdocs_on_canc_invoice 12029 12029 0 0.00 0 20114 103 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 5053 295 0 0
x_make_qstorno_1000_1200 5565 5565 0 0.00 1 34478 1140 0 0
x_make_qstorno_1200_2000 5490 5490 0 0.00 3 92951 3097 0 0
x_make_qstorno_2100_3300 438635 438635 0 0.00 0 42458 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-12-2020 19:29:17 to 10-12-2020 19:29:21.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:13 21886 8192000000 10268228512 10577719296 901066752 9.909 69 51 104 0 919508160 2425904 16015504
16:57:45 17381 8192000000 10345702480 10658414592 1395795264 14.558 100 86 172 0 1427973184 4680784 27497136
16:58:13 28663 8192000000 10376161072 10693623808 1424336400 14.811 100 90 180 1 1460137552 6417616 29383536
16:58:50 30331 8192000000 10390846160 10715267072 1442601840 14.973 100 87 174 0 1478769376 7430656 28736880
16:59:37 27291 8192000000 10416498064 10743607296 1468595792 15.201 100 91 182 1 1506042976 8265232 29181952
17:00:14 19025 8192000000 10424481808 10755596288 1482749536 15.325 100 84 168 1 1518123568 8673776 26700256
17:00:41 17721 8192000000 10440068816 10778406912 1502090960 15.494 100 85 171 0 1538189200 9112720 26985520
17:01:18 13015 8192000000 10468939120 10815143936 1526363408 15.705 100 75 150 1 1559033472 9291456 23378608
17:01:40 12007 8192000000 10502419520 10851831808 1560147008 15.997 100 74 148 0 1592227760 9887856 22192896
17:01:59 11316 8192000000 10524707456 10876628992 1584395584 16.206 100 78 155 1 1618114672 10275680 23443408
17:02:21 16769 8192000000 10556472416 10917515264 1608184144 16.409 100 67 134 0 1638421360 10576064 19661152
17:02:47 12156 8192000000 10581387920 10946932736 1647209696 16.741 100 80 159 1 1682668752 11943952 23515104
17:03:07 8576 8192000000 10611847872 10976964608 1664212080 16.884 100 73 145 0 1696597024 11512000 20872944
17:03:24 7141 8192000000 10624707184 10994880512 1687923408 17.084 100 78 155 1 1721827280 12336304 21567568
17:03:38 8544 8192000000 10636286592 11013070848 1700528032 17.190 100 68 136 1 1732459504 11525360 20406112
17:03:54 5899 8192000000 10667772832 11043135488 1728488096 17.423 100 81 162 1 1763443456 11809088 23146272
17:04:07 6116 8192000000 10676320656 11055828992 1741176640 17.528 100 70 140 0 1772734432 11835808 19721984
17:04:24 4224 8192000000 10689268240 11069984768 1752314896 17.621 100 67 134 1 1783370624 11582240 19473488
17:04:35 3589 8192000000 10707298016 11087368192 1769197616 17.760 100 80 156 2 1803914240 12740576 21976048
17:04:46 3938 8192000000 10711533296 11091918848 1777368192 17.828 100 83 165 1 1812380448 12655968 22356288
17:04:57 4758 8192000000 10721713440 11110801408 1792605856 17.953 100 73 147 0 1824743008 12453424 19683728
17:05:09 4225 8192000000 10740134432 11126841344 1804704320 18.052 100 76 152 0 1837860016 12336368 20819328
17:05:19 8661 8192000000 10750263520 11135762432 1812095952 18.113 100 90 180 1 1851629232 14577872 24955408
17:05:37 3233 8192000000 10746810912 11135619072 1812760272 18.118 100 75 150 1 1847887008 14547056 20579680
17:05:48 2773 8192000000 10766715072 11156152320 1828254736 18.245 100 88 176 2 1865741520 12615184 24871600
17:05:57 2141 8192000000 10778010448 11164172288 1838142304 18.326 100 79 157 3 1872997376 12819824 22035248
17:06:06 2223 8192000000 10787887664 11171938304 1843705824 18.371 100 91 179 0 1882349600 12551744 26092032
17:06:15 2032 8192000000 10789360272 11177992192 1847942256 18.405 100 90 180 0 1886665264 13081920 25641088
17:06:24 2081 8192000000 10784117104 11177504768 1853136288 18.448 100 91 183 2 1890159680 11366944 25656448
17:06:33 2650 8192000000 10796714144 11186892800 1859979696 18.503 100 94 185 4 1899605040 14000592 25624752
17:06:42 1557 8192000000 10806717264 11192242176 1859106368 18.496 100 93 187 0 1899181808 14033184 26042256
17:06:50 1644 8192000000 10794448048 11186892800 1864863744 18.543 100 91 181 4 1902821792 13172752 24785296
17:06:58 1970 8192000000 10800838880 11197739008 1862739616 18.525 100 79 157 0 1898056960 13609296 21708048
17:07:07 1688 8192000000 10812317184 11203203072 1870420144 18.588 100 96 192 0 1911615040 13246528 27948368
17:07:15 2373 8192000000 10810664080 11204599808 1871117600 18.593 100 89 178 0 1909076704 12888256 25070848
17:07:24 2461 8192000000 10811730288 11208876032 1873189856 18.610 100 79 157 2 1909281824 13315024 22776944
17:07:33 1529 8192000000 10820492416 11212636160 1879112208 18.658 100 95 191 0 1919773904 14317440 26344256
17:07:41 1361 8192000000 10829362640 11218898944 1879946912 18.665 100 96 193 0 1921296384 14663936 26685536
17:07:49 1786 8192000000 10816124864 11210969088 1877946096 18.649 100 80 161 2 1914276416 14060400 22269920
17:07:58 4020 8192000000 10802885536 11207041024 1879003584 18.657 100 73 148 1 1909988144 10144176 20840384
17:08:09 3035 8192000000 10783333184 11204714496 1872138144 18.602 100 45 92 0 1893355264 8200272 13016848
17:08:19 4402 8192000000 10781408112 11202301952 1876270976 18.635 100 49 97 2 1895476512 5246224 13959312
17:08:31 5985 8192000000 10792617376 11206737920 1872777104 18.607 100 30 60 1 1888569712 7638736 8153872
17:08:47 7089 8192000000 10783075920 11208777728 1878636336 18.654 100 32 63 1 1893658208 5593776 9428096
17:09:00 4665 8192000000 10799731984 11220180992 1884882800 18.705 100 37 74 0 1902006944 6844112 10280032
17:09:13 8445 8192000000 10797765440 11223961600 1886916816 18.721 100 21 41 1 1904005744 11405072 5683856
17:09:32 7820 8192000000 10809671440 11224182784 1885704944 18.711 100 36 72 4 1905776752 10265504 9806304
17:09:47 68783 8192000000 10794908672 11235106816 1888732672 18.736 100 23 43 2 1900861424 5119312 7009440
17:11:02 10213 8192000000 10806515376 11241422848 1893446192 18.774 100 24 48 1 1906959712 6753488 6760032
17:11:19 3634 8192000000 10831659824 11251535872 1900828816 18.833 100 45 90 1 1922115792 8699328 12587648
17:11:30 5821 8192000000 10821036256 11251748864 1897665952 18.808 100 29 57 0 1917217296 11944400 7606944
17:11:44 5992 8192000000 10824941040 11250024448 1901893712 18.842 100 33 64 3 1917908304 6116048 9898544
17:11:58 6729 8192000000 10816030928 11249074176 1897978368 18.810 100 17 32 2 1908368848 5817664 4572816
17:12:11 4893 8192000000 10822719632 11254476800 1901247344 18.836 100 23 46 1 1913888560 6135712 6505504
17:12:22 10464 8192000000 10818580400 11254505472 1902950352 18.850 100 31 62 1 1918544464 6894208 8699904
17:12:39 4680 8192000000 10826906416 11258531840 1908985184 18.898 100 31 61 4 1923978160 6139664 8853312
17:12:50 7698 8192000000 10822255280 11254026240 1906588800 18.879 100 22 44 2 1919148784 6386368 6173616
17:13:05 9817 8192000000 10820328672 11256754176 1907949152 18.890 100 20 38 4 1918343968 5461632 4933184
17:13:21 7272 8192000000 10820015456 11256401920 1905629312 18.872 100 11 22 2 1913796368 5204048 2963008
17:13:34 12211 8192000000 10818659840 11258322944 1907822112 18.889 100 21 43 1 1919866464 6054128 5990224
17:13:55 8266 8192000000 10818214976 11252584448 1890353120 18.749 99 20 39 2 1901030240 5694704 4982416
17:14:09 38175 8192000000 10830876256 11258040320 1905118288 18.867 100 14 26 2 1915034000 5558160 4357552
17:15:11 9762 8192000000 10820356896 11256201216 1904301712 18.861 100 24 48 0 1916372256 4927856 7142688
17:15:30 5897 8192000000 10801240144 11226132480 1870645280 18.589 98 26 52 1 1884460272 6707760 7107232
17:15:42 6779 8192000000 10815764448 11252887552 1906669152 18.880 100 40 77 3 1923107312 5489152 10949008
17:15:56 3253 8192000000 10837473008 11260977152 1909799872 18.905 100 47 92 1 1930769120 7679680 13289568
17:16:06 4835 8192000000 10831006112 11257217024 1890614608 18.751 99 33 66 0 1908009600 7531920 9863072
17:16:21 7789 8192000000 10795431488 11215908864 1801759200 18.028 95 23 46 1 1813593904 5673280 6161424
17:16:39 9334 8192000000 10742785136 11172470784 1738357936 17.505 93 21 42 0 1749748176 5032336 6357904
17:16:55 6735 8192000000 10751742944 11176300544 1832031072 18.276 100 18 36 2 1842607200 5501920 5074208
17:17:08 8458 8192000000 10764955088 11189010432 1817263120 18.155 98 15 30 2 1827004688 5267600 4473968
17:17:25 5337 8192000000 10762938912 11183550464 1843014432 18.365 100 25 48 1 1856330064 5863424 7452208
17:17:38 6208 8192000000 10733525984 11155992576 1808587536 18.084 98 23 46 2 1820340288 5368448 6384304
17:17:52 8145 8192000000 10710538320 11127910400 1715751552 17.317 94 22 42 3 1727876944 5830496 6294896
17:18:06 13296 8192000000 10684543984 11102433280 1714635920 17.307 95 17 33 2 1724407984 4621552 5150512
17:18:29 10812 8192000000 10714150784 11123109888 1722430448 17.372 95 18 36 1 1733525968 5577120 5518400
17:18:47 63456 8192000000 10672934944 11091234816 1669019920 16.925 93 27 54 0 1682497088 5836448 7640720
17:19:59 7407 8192000000 10722797616 11130966016 1762183984 17.702 98 21 43 1 1773594896 4773152 6637760
17:20:13 7330 8192000000 10707678128 11119022080 1758476848 17.672 97 27 54 0 1773061840 6390096 8194896
17:20:29 5116 8192000000 10722334992 11139006464 1801796224 18.029 100 27 54 1 1820023872 10665456 7562192
17:20:40 8638 8192000000 10712453552 11125211136 1722006400 17.369 95 22 42 1 1733595712 5292384 6296928
17:20:57 6459 8192000000 10721758512 11136798720 1788653360 17.921 99 17 34 0 1799646736 5263424 5729952
17:21:12 9337 8192000000 10727455376 11144425472 1751654656 17.615 96 23 46 2 1763023920 5085168 6284096
17:21:28 6199 8192000000 10728017296 11143856128 1810631168 18.101 100 27 54 1 1823565472 5280768 7653536
17:21:41 5222 8192000000 10739202832 11154034688 1808183296 18.081 99 33 66 1 1823774544 6212912 9378336
17:21:55 17198 8192000000 10743777840 11172450304 1836242496 18.310 100 22 44 0 1847786624 5130880 6413248
17:22:18 8328 8192000000 10751240800 11170422784 1825212432 18.220 99 26 51 2 1841934096 9108256 7613408
17:22:34 9972 8192000000 10751122112 11176669184 1840660016 18.346 100 18 36 0 1851842320 5728048 5454256
17:22:50 9545 8192000000 10760656272 11184979968 1847329488 18.400 100 18 35 2 1859294480 5871392 6093600
17:23:06 10745 8192000000 10769135712 11195179008 1853741648 18.453 100 20 40 4 1865491104 5920160 5829296
17:23:28 74461 8192000000 10785973168 11206291456 1862879584 18.527 100 33 66 3 1878740336 5030432 10830320
17:24:49 11026 8192000000 10775208832 11206656000 1865234192 18.546 100 21 42 1 1877639872 6864096 5541584
17:25:10 8693 8192000000 10779400128 11210899456 1868159616 18.569 100 22 43 2 1879578704 5176480 6242608
17:25:25 7040 8192000000 10804714064 11218104320 1870626000 18.589 100 27 54 0 1884719808 6514256 7579552
17:25:38 8252 8192000000 10790897104 11215810560 1868751648 18.574 100 14 29 1 1878188592 5180320 4256624
17:25:56 2727 8192000000 10810855168 11227082752 1884053504 18.698 100 54 106 1 1907210720 7217072 15940144
17:26:06 10334 8192000000 10783297616 11220406272 1879755552 18.663 100 24 48 2 1892441056 5657600 7027904
17:26:23 9833 8192000000 10793464576 11222966272 1879091152 18.658 100 20 38 1 1889975568 5353040 5531376
17:26:41 18248 8192000000 10792782480 11227361280 1882061472 18.682 100 18 37 0 1892967360 5484752 5421136
17:27:06 2713 8192000000 10825737568 11242098688 1900722816 18.832 100 35 71 2 1916212160 5082464 10406880
17:27:17 13724 8192000000 10849653408 11264225280 1914155328 18.940 100 40 80 1 1936128752 10444928 11528496
17:27:42 13715 8192000000 10860869088 11274821632 1926339264 19.038 100 51 101 2 1948229072 7486368 14403440
17:28:06 42349 8192000000 10853634192 11282833408 1933468176 19.095 100 43 84 1 1955742560 10397840 11876544
17:28:54 20157 8192000000 10878267776 11298512896 1942025024 19.163 100 51 103 0 1967396512 10818368 14553120
17:29:24 32633 8192000000 10889081216 11309875200 1949386784 19.222 100 53 105 1 1975381824 10935344 15059696
17:30:07 45439 8192000000 10864873360 11301404672 1914615760 18.944 98 39 77 0 1933090704 8203088 10271856
17:31:04 19840 8192000000 10878906464 11315478528 1951288800 19.237 100 43 84 2 1973822320 10532688 12000832
17:31:34 3795 8192000000 10911184048 11325857792 1944021104 19.179 99 70 141 1 1977000400 11930080 21049216
17:31:46 21438 8192000000 10893218240 11326902272 1957394816 19.285 100 49 98 1 1982065760 10808192 13862752
17:32:22 11403 8192000000 10905093568 11333844992 1971841696 19.400 100 52 103 1 1998969344 11425024 15702624
17:32:48 4517 8192000000 10905232624 11335475200 1969071120 19.378 100 57 110 1 1997161952 11030720 17060112
17:33:01 18621 8192000000 10905279952 11337043968 1974727200 19.423 100 44 88 1 1999253696 11362544 13163952
17:33:29 5674 8192000000 10915902384 11347832832 1981766672 19.479 100 54 107 2 2010454064 12840928 15846464
17:33:41 4444 8192000000 10934423984 11360022528 1990196384 19.545 100 68 139 1 2024539648 13271712 21071552
17:33:56 7745 8192000000 10914006816 11350089728 1983521888 19.493 100 57 114 0 2014693632 14386096 16785648
17:34:11 5850 8192000000 10930468288 11358662656 1984889216 19.503 100 62 117 4 2019948288 17859680 17199392
17:34:27 8549 8192000000 10924345776 11363438592 1991174064 19.553 100 49 98 0 2025027024 19480432 14372528
17:34:51 7776 8192000000 10942555008 11372060672 1998399584 19.610 100 48 95 3 2025240096 13563728 13276784
17:35:06 5344 8192000000 10938946016 11367616512 1985632240 19.509 99 56 112 3 2016113760 13321536 17159984
17:35:22 10176 8192000000 10943757088 11378733056 2002633424 19.643 100 55 109 0 2033921344 15135376 16152544
17:35:40 3192 8192000000 10931099840 11361263616 1979582944 19.461 99 66 133 1 2015010752 16135248 19292560
17:35:50 4520 8192000000 10942083664 11360911360 1989535664 19.540 100 66 129 1 2024935216 16561152 18838400
17:36:04 1961 8192000000 10968747456 11381293056 2005796880 19.668 100 74 149 2 2044689024 17499024 21393120
17:36:23 5767 8192000000 10975748832 11400962048 2013452288 19.729 100 65 126 1 2055550544 23770528 18327728
17:36:38 7913 8192000000 10950488656 11386515456 2004876320 19.661 100 50 100 1 2041483520 21319696 15287504
17:36:55 3344 8192000000 10960489728 11399270400 2015424784 19.744 100 53 104 1 2054082400 22118384 16539232
17:37:09 4921 8192000000 10949963120 11383492608 2001945840 19.638 100 53 103 1 2038036032 20295120 15795072
17:37:28 5809 8192000000 10936389952 11369107456 1977860656 19.448 99 52 104 1 2016409728 22082832 16466240
17:37:43 4923 8192000000 10925963328 11353501696 1962780656 19.328 99 65 127 2 2003927904 22450304 18696944
17:37:57 2319 8192000000 10950037680 11367120896 1987780832 19.526 100 70 136 2 2029945280 21648544 20515904
17:38:07 4345 8192000000 10957909104 11379834880 1996131696 19.592 100 69 138 0 2041533104 24248128 21153280
17:38:19 5858 8192000000 10932247648 11358605312 1956163104 19.276 98 64 127 2 1999661952 24410032 19088816
17:38:32 9525 8192000000 10894131920 11310043136 1882766752 18.687 96 63 126 1 1926308256 24459744 19081760
17:38:50 1497 8192000000 10919989904 11335639040 1958595296 19.295 100 70 137 0 2006827056 26717696 21514064
17:38:58 1385 8192000000 10929699008 11345612800 1964004016 19.338 100 74 146 1 2012503776 27060096 21439664
17:39:08 3201 8192000000 10936041440 11354177536 1972038640 19.402 100 72 143 0 2022666576 28267440 22360496
17:39:19 2022 8192000000 10929467776 11333967872 1934690256 19.104 98 76 152 3 1987611216 29504576 23416384
17:39:28 2130 8192000000 10936265440 11342528512 1951374224 19.237 100 81 160 1 2006458656 30423584 24660848
17:39:37 4156 8192000000 10943687424 11356545024 1972830352 19.408 100 83 163 1 2029614384 30866800 25917232
17:39:49 3097 8192000000 10940364736 11352743936 1969726160 19.383 100 74 148 3 2025431152 32548080 23156912
17:40:01 2711 8192000000 10955229520 11362123776 1970634880 19.390 100 83 167 2 2031892912 34864528 26393504
17:40:11 3347 8192000000 10939093328 11354943488 1964934416 19.345 100 69 138 1 2023809792 36721536 22153840
17:40:21 2678 8192000000 10956871664 11368230912 1973221520 19.411 100 85 170 0 2043686912 42742208 27723184
17:40:36 4140 8192000000 10935565024 11355709440 1949225088 19.220 99 72 136 2 2007492896 36225744 22042064
17:40:48 1453 8192000000 10955103712 11361062912 1967986304 19.369 100 91 182 1 2032771264 37367664 27417296
17:40:56 3439 8192000000 10956511824 11370942464 1977298896 19.443 100 83 165 1 2040022384 36575360 26148128
17:41:08 9507 8192000000 10956446896 11382030336 1977646128 19.446 100 62 124 0 2030592368 33523536 19422704
17:41:27 18807 8192000000 10919029968 11372568576 1974268112 19.419 100 38 76 0 2020313888 33030592 13015184
17:42:00 4709 8192000000 10914714544 11342360576 1948470336 19.214 99 59 118 3 1989534656 23979024 17085296
17:42:13 7668 8192000000 10905627296 11335143424 1950418496 19.230 100 51 102 0 1994764640 28734816 15611328
17:42:28 2080 8192000000 10906975200 11337064448 1939243360 19.141 99 46 92 0 1983911648 29967408 14700880
17:42:37 4913 8192000000 10867644080 11297685504 1888770992 18.736 97 37 75 3 1931426784 30759008 11896784
17:42:55 11442 8192000000 10883921456 11317723136 1915982544 18.955 99 36 72 1 1957814112 30028544 11803024
17:43:18 10091 8192000000 10897129008 11334918144 1922616704 19.008 99 40 79 0 1973512576 37875392 13020480
17:43:36 7850 8192000000 10902234672 11338305536 1938794688 19.137 100 32 64 0 1982610352 32840560 10975104
17:43:51 5638 8192000000 10883378000 11318853632 1924786192 19.025 100 36 72 2 1972391168 35188576 12416400
17:44:09 13942 8192000000 10871698272 11310780416 1892236368 18.764 98 28 56 1 1935705936 33887312 9582256
17:44:34 13320 8192000000 10851584464 11288113152 1893277664 18.772 100 34 68 1 1944761952 40161616 11322672
17:44:54 10206 8192000000 10866610368 11295289344 1887308080 18.724 99 40 78 0 1937963152 37247056 13408016
17:45:13 24078 8192000000 10861035056 11291820032 1852375152 18.441 97 31 62 1 1906735536 43317536 11042848
17:45:44 18495 8192000000 10893164144 11329613824 1919298960 18.981 100 30 58 0 1970910720 41646016 9965744
17:46:14 22629 8192000000 10872722288 11319148544 1904228464 18.860 99 23 47 0 1949087168 36564032 8294672
17:46:45 7319 8192000000 10875157552 11314778112 1916833856 18.961 100 30 60 0 1963197520 35888832 10474832
17:47:00 8451 8192000000 10884140080 11324739584 1928468448 19.055 100 30 60 1 1971021904 32590304 9963152
17:47:16 16465 8192000000 10896509456 11336265728 1927329680 19.046 100 28 56 1 1972465504 35540848 9594976
17:47:46 23741 8192000000 10919647872 11362267136 1940616672 19.152 100 24 48 3 1996492224 47439344 8436208
17:48:19 20404 8192000000 10914546704 11373551616 1951918432 19.242 100 28 56 2 1996303808 34592864 9792512
17:48:54 46424 8192000000 10894799056 11349618688 1900268224 18.828 97 14 28 0 1933681184 28842320 4570640
17:49:59 35512 8192000000 10864554112 11323461632 1898220048 18.812 98 20 40 2 1929942704 25088784 6633872
17:52:01 33559 8192000000 10861788640 11325939712 1928353792 19.054 100 18 36 3 1949829984 16355024 5121168
17:52:42 35050 8192000000 10849217392 11303505920 1884777552 18.704 98 17 36 0 1903183648 13606080 4800016
17:53:34 52561 8192000000 10868420752 11323428864 1912184128 18.924 99 26 51 1 1942236256 22195632 7856496
17:54:37 65269 8192000000 10853246272 11323699200 1931374768 19.078 100 15 30 2 1951879456 15887792 4616896
17:55:48 59664 8192000000 10875915728 11338125312 1925824480 19.033 99 21 42 1 1941672576 9627504 6220592
17:57:28 48373 8192000000 10890594992 11349356544 1925504432 19.031 98 24 47 5 1949896464 17159600 7232432
17:58:23 98115 8192000000 10901585552 11364343808 1964529136 19.342 100 24 49 1 1992705328 21016400 7159792
18:00:17 35411 8192000000 10886030096 11346210816 1953608288 19.255 99 32 64 0 1974802240 12543232 8650720
18:00:59 58378 8192000000 10900473568 11359649792 1972904000 19.408 100 15 30 1 1986196944 9498208 3794736
18:02:10 73775 8192000000 10898547312 11363151872 1948332048 19.213 98 14 28 0 1960062288 8095632 3634608
18:03:31 14649 8192000000 10898122000 11365408768 1977033872 19.441 100 13 26 1 1990343600 9141264 4168464
18:04:36 40323 8192000000 10931491552 11384393728 1989300320 19.538 100 39 76 0 2015460800 15210768 10949712
18:05:24 40150 8192000000 10895585344 11356893184 1945155792 19.188 98 28 57 0 1969648976 16440960 8052224
18:07:39 64167 8192000000 10896238672 11373821952 1979329520 19.459 100 7 14 1 1994982096 13448032 2204544
18:08:50 31839 8192000000 10902604512 11377303552 1982144592 19.482 100 10 19 3 1997503184 12045648 3312944
18:09:34 66019 8192000000 10901754240 11367813120 1970730768 19.391 99 22 44 1 1987518736 10280112 6507856
18:10:55 66707 8192000000 10913989760 11390881792 1992729696 19.565 100 19 38 0 2014199472 16012416 5457360
18:12:08 83971 8192000000 10891147984 11361751040 1959282784 19.300 99 8 16 0 1970671248 9350144 2038320
18:13:41 76913 8192000000 10906079920 11360374784 1964597872 19.343 99 29 57 1 1980626576 6940192 9088512
18:15:06 49725 8192000000 10894087840 11367342080 1984692752 19.502 100 20 40 3 2001881296 11324352 5864192
18:16:13 40790 8192000000 10899891072 11374583808 1985290256 19.507 100 12 24 0 1994896160 6248160 3357744
18:17:06 72941 8192000000 10913657536 11383713792 1972062736 19.402 99 10 20 0 1983434512 8953008 2418768
18:18:32 55467 8192000000 10900680032 11369455616 1937975504 19.131 97 22 44 1 1958625760 14099584 6550672
18:19:41 48542 8192000000 10880852256 11362623488 1921279792 18.997 97 18 35 2 1942387536 15599312 5508432
18:20:38 82675 8192000000 10862622384 11333820416 1819122416 18.171 92 13 26 1 1835605376 12534208 3948752
18:23:00 41047 8192000000 10888065648 11338797056 1919303728 18.981 98 28 56 4 1934548608 7388064 7856816
18:23:50 69129 8192000000 10917037024 11368722432 1953569728 19.255 99 23 46 1 1973986368 13447296 6969344
18:25:08 47554 8192000000 10913477536 11372412928 1934565360 19.103 98 31 63 1 1958762720 15195904 9001456
18:26:08 85284 8192000000 10873281392 11337961472 1887349728 18.724 96 20 41 1 1912129232 19379856 5399648
18:27:42 66886 8192000000 10882078800 11350302720 1903583088 18.855 97 14 28 1 1919459808 12535696 3341024
18:28:55 71761 8192000000 10858263920 11323142144 1835231776 18.302 94 10 20 3 1847783312 10000272 2551264
18:30:14 40683 8192000000 10862776240 11308060672 1861592880 18.516 96 36 72 1 1881598960 9966320 10039760
18:31:01 81185 8192000000 10860823424 11315027968 1914250032 18.941 99 35 70 1 1934992208 11038112 9704064
18:32:32 46014 8192000000 10828683680 11293913088 1840516112 18.345 95 19 38 0 1854307120 8931904 4859104
18:33:24 64181 8192000000 10839040736 11306545152 1922059456 19.003 100 11 22 2 1937734256 12353760 3321040
18:34:34 62577 8192000000 10851459392 11336679424 1924035568 19.019 100 11 22 0 1944280400 17384896 2859936
18:35:43 12006 8192000000 10851158000 11335888896 1925541312 19.031 100 3 6 1 1943588304 17576032 470960
18:36:01 7509 8192000000 10826487200 11283038208 1870329120 18.587 97 20 36 0 1888639232 13981296 4328816
18:36:18 44253 8192000000 10874174208 11325378560 1917169088 18.964 99 20 39 2 1933059072 9479104 6410880
18:37:13 66668 8192000000 10873640128 11338227712 1909248224 18.901 98 25 50 0 1928755536 12162528 7344784
18:38:25 77993 8192000000 10873159856 11331125248 1872543872 18.605 96 13 26 1 1892490544 16122944 3823728
18:39:49 59594 8192000000 10844630592 11305205760 1849530112 18.418 95 23 46 0 1870158672 13681008 6947552
18:41:02 109590 8192000000 10874380048 11345907712 1921333376 18.998 99 11 22 1 1941576096 17038400 3204320
18:43:01 103751 8192000000 10854128448 11323293696 1791164768 17.941 92 17 32 1 1807969088 12661856 4142464
18:45:28 60041 8192000000 10870454944 11319406592 1871324688 18.595 96 28 53 2 1888350944 8951808 8074448
18:46:35 19673 8192000000 10887193216 11334385664 1942329312 19.165 100 41 82 3 1964732512 10642000 11761200
18:47:01 121132 8192000000 10888766288 11372433408 1946892512 19.202 100 24 48 2 1965246576 12114144 6239920
18:49:08 67526 8192000000 10880376608 11328503808 1827247904 18.237 93 21 42 2 1843607728 10283952 6075872
18:50:23 126581 8192000000 10869353680 11336077312 1909094848 18.899 98 30 57 2 1928322832 10873824 8354160
18:52:35 63137 8192000000 10884685712 11365134336 1949150800 19.220 100 6 12 0 1965809856 15335600 1323456
18:54:09 43135 8192000000 10898417728 11369553920 1960310576 19.309 99 35 70 1 1981410464 10948944 10150944
18:55:07 77563 8192000000 10883255296 11355131904 1951340240 19.237 99 12 24 1 1969933728 15010864 3582624
18:56:40 42982 8192000000 10911685904 11382071296 1974274544 19.419 100 23 46 2 1999033280 17999600 6759136
18:57:30 57817 8192000000 10913085696 11381456896 1988588576 19.533 100 20 40 0 2007625168 12865216 6171376
18:59:36 50100 8192000000 10920292544 11387617280 1977709376 19.447 99 16 32 0 1999829824 17402320 4718128
19:00:33 47668 8192000000 10913741696 11388841984 1974064544 19.418 99 14 27 0 1993335344 14619712 4651088
19:01:47 55398 8192000000 10915586896 11387154432 1973798704 19.416 99 18 36 1 1993323568 14661984 4862880
19:03:24 45607 8192000000 10928010016 11378176000 1961975472 19.322 98 19 39 1 1974971680 7562864 5433344
19:04:16 40665 8192000000 10916366528 11384786944 1958161456 19.291 98 20 40 3 1974251024 10319648 5769920
19:05:07 54596 8192000000 10936336000 11392299008 1994883840 19.582 100 22 44 1 2008901472 7982304 6035328
19:06:08 15587 8192000000 10944334960 11400830976 2009790512 19.700 100 51 100 2 2033846528 10171824 13884192
19:06:32 28679 8192000000 10930064416 11386408960 1944387392 19.182 97 37 73 1 1964154912 10000640 9766880
19:07:09 16360 8192000000 10930636416 11381698560 1987066784 19.521 100 36 72 0 2007232384 10102144 10063456
19:07:33 29536 8192000000 10908544688 11372462080 1972619344 19.406 99 29 58 1 1992463280 11741824 8102112
19:08:10 22797 8192000000 10936726608 11391832064 1973346752 19.412 99 30 60 0 1990846160 9280480 8218928
19:08:52 35174 8192000000 10922807888 11409174528 2000399632 19.626 100 28 56 1 2026870432 18595696 7875104
19:09:44 80741 8192000000 10926860512 11405635584 1928840176 19.058 96 21 42 0 1951948960 17131984 5976800
19:11:27 56414 8192000000 10937511888 11398168576 1978956320 19.456 99 18 36 2 2001019360 17254480 4808560
19:12:34 46680 8192000000 10930120992 11390578688 1939817184 19.145 97 21 42 1 1962446608 17028128 5601296
19:13:31 44341 8192000000 10897853392 11358330880 1884356928 18.700 95 37 74 0 1912359232 17431280 10571024
19:14:22 158254 8192000000 10888160912 11348914176 1896830240 18.801 96 22 44 1 1919106432 16203216 6072976
19:17:13 42153 8192000000 10875431648 11344138240 1933901952 19.098 99 23 45 0 1954744640 14315568 6527120
19:18:01 38727 8192000000 10869586624 11342467072 1919368768 18.982 99 16 32 0 1944713632 19918064 5426800
19:18:59 74357 8192000000 10847122368 11324989440 1877721872 18.647 96 8 16 0 1888204352 8634480 1848000
19:20:20 88921 8192000000 10816626576 11277058048 1831024528 18.268 94 9 18 0 1843822288 10346384 2451376
19:22:07 93085 8192000000 10838573904 11311919104 1868594848 18.573 97 9 19 0 1886133808 14992704 2546256
19:24:12 80733 8192000000 10885987056 11348041728 1922620464 19.008 99 19 38 1 1949286256 21020528 5645264
19:25:41 29524 8192000000 10857099936 11323219968 1896324032 18.797 97 23 46 5 1914166688 11114304 6728352
19:26:17 31820 8192000000 10846294368 11309887488 1903142656 18.852 98 24 48 1 1919462624 9335200 6984768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-12-2020 19:29:22 to 10-12-2020 19:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 101 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

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          241019
MON$OLDEST_ACTIVE               243084
MON$OLDEST_SNAPSHOT             243084
MON$NEXT_TRANSACTION            243084
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                       2022016
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.33399 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33399 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33399 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33399 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Thu Dec 10 19:27:11 2020
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Thu Dec 10 19:27:16 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
--- end of diff output ---

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

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