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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16987364 kB
MemAvailable 31270556 kB
Buffers 0 kB
Cached 14673516 kB
SwapCached 4868 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-01-24 16:27:11
DTS_END                         2021-01-24 16:27:11.5890
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/36342
TRN_ID                          235909
ATT_ID                          714
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: 9635.48 19620 1156258
customer order: creation 166.29 329 19955
customer order: refuse 13.77 319 1652
order to supplier: creation 44.08 1195 5289
order to supplier: removal 3.61 105227 433
invoice (draft): creation 43.26 3390 5191
invoice (draft): removal 58.28 790 6993
invoice accept: apply 39.88 16813 4785
invoice accept: cancel 53.20 679 6384
customer reserve: creation 3714.31 164 445717
customer reserve: removal 5199.32 56 623918
realization accept: apply 81.49 185 9779
realization accept: cancel 93.56 102 11227
payment from customer: creation 56.99 134 6839
payment from customer: removal 5.32 106 638
payment to supplier: creation 46.96 130 5635
payment to supplier: removal 3.50 86 420
service: total inventory turnovers 4.15 1078 498
service: total monetary turnovers 6.68 21 801
service: aggregate perf. data 0.83 24396 100
service: refresh index statistics 0.03 237206 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-01-2021 16:28:04 to 24-01-2021 16:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4585
TEST_TIME 2 4140
TEST_TIME 3 3000
TEST_TIME 4 3683
TEST_TIME 5 3744
TEST_TIME 6 4606
TEST_TIME 7 4451
TEST_TIME 8 5517
TEST_TIME 9 5524
TEST_TIME 10 5890
TEST_TIME 11 6029
TEST_TIME 12 6206
TEST_TIME 13 6155
TEST_TIME 14 6137
TEST_TIME 15 6730
TEST_TIME 16 7226
TEST_TIME 17 7387
TEST_TIME 18 7423
TEST_TIME 19 7982
TEST_TIME 20 8209
TEST_TIME 21 8049
TEST_TIME 22 8712
TEST_TIME 23 8570
TEST_TIME 24 8639
TEST_TIME 25 9674
TEST_TIME 26 9440
TEST_TIME 27 9680
TEST_TIME 28 9981
TEST_TIME 29 11609
TEST_TIME 30 11497
TEST_TIME 31 11493
TEST_TIME 32 11505
TEST_TIME 33 11340
TEST_TIME 34 11105
TEST_TIME 35 10881
TEST_TIME 36 10857
TEST_TIME 37 11008
TEST_TIME 38 10850
TEST_TIME 39 10712
TEST_TIME 40 10514
TEST_TIME 41 10560
TEST_TIME 42 10619
TEST_TIME 43 10538
TEST_TIME 44 10420
TEST_TIME 45 10310
TEST_TIME 46 10290
TEST_TIME 47 10230
TEST_TIME 48 10147
TEST_TIME 49 10083
TEST_TIME 50 10062
TEST_TIME 51 10046
TEST_TIME 52 9967
TEST_TIME 53 9908
TEST_TIME 54 9743
TEST_TIME 55 9752
TEST_TIME 56 9772
TEST_TIME 57 9827
TEST_TIME 58 9792
TEST_TIME 59 9851
TEST_TIME 60 9815
TEST_TIME 61 9893
TEST_TIME 62 9931
TEST_TIME 63 9956
TEST_TIME 64 9884
TEST_TIME 65 9902
TEST_TIME 66 10049
TEST_TIME 67 10056
TEST_TIME 68 10051
TEST_TIME 69 10111
TEST_TIME 70 10117
TEST_TIME 71 10105
TEST_TIME 72 9989
TEST_TIME 73 9985
TEST_TIME 74 9914
TEST_TIME 75 9923
TEST_TIME 76 9879
TEST_TIME 77 9792
TEST_TIME 78 9777
TEST_TIME 79 9756
TEST_TIME 80 9769
TEST_TIME 81 9744
TEST_TIME 82 9744
TEST_TIME 83 9715
TEST_TIME 84 9682
TEST_TIME 85 9617
TEST_TIME 86 9638
TEST_TIME 87 9627
TEST_TIME 88 9628
TEST_TIME 89 9591
TEST_TIME 90 9624
TEST_TIME 91 9685
TEST_TIME 92 9713
TEST_TIME 93 9697
TEST_TIME 94 9705
TEST_TIME 95 9747
TEST_TIME 96 9752
TEST_TIME 97 9781
TEST_TIME 98 9831
TEST_TIME 99 9828
TEST_TIME 100 9868
TEST_TIME 101 9971
TEST_TIME 102 9889
TEST_TIME 103 9813
TEST_TIME 104 9758
TEST_TIME 105 9780
TEST_TIME 106 9770
TEST_TIME 107 9741
TEST_TIME 108 9708
TEST_TIME 109 9669
TEST_TIME 110 9667
TEST_TIME 111 9670
TEST_TIME 112 9671
TEST_TIME 113 9668
TEST_TIME 114 9683
TEST_TIME 115 9653
TEST_TIME 116 9708
TEST_TIME 117 9699
TEST_TIME 118 9700
TEST_TIME 119 9711
TEST_TIME 120 9636

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-01-2021 16:28:07 to 24-01-2021 16:28:11.

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 1570660 1570660 0 0.00 0 42171 6 0 0
doc_list_biud 1570659 1570659 0 0.00 0 60697 28 0 0
sp_add_invoice_to_stock 4945 4785 160 3.23 44 167095 16814 0 160
sp_cancel_adding_invoice 6384 6384 0 0.00 4 56380 680 0 0
sp_cancel_client_order 1652 1652 0 0.00 4 7046 320 0 0
sp_cancel_customer_reserve 623918 623918 0 0.00 1 23838 57 0 0
sp_cancel_pay_from_customer 638 638 0 0.00 2 7151 107 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 2 4395 87 0 0
sp_cancel_supplier_invoice 7004 6993 11 0.15 1 60782 791 0 11
sp_cancel_supplier_order 433 433 0 0.00 13 1140132 105228 0 0
sp_cancel_write_off 11227 11227 0 0.00 1 44718 102 0 0
sp_client_order 19955 19955 0 0.00 4 23735 329 0 0
sp_customer_reserve 445717 445717 0 0.00 0 49949 165 0 0
sp_fill_shopping_cart 30433 30433 0 0.00 1 34071 41 0 0
sp_fill_shopping_cart_clo_res 445716 445716 0 0.00 0 16982 13 0 0
sp_get_clo_for_invoice 4784 4784 0 0.00 0 29337 314 0 0
sp_kill_cost_storno 18669 18669 0 0.00 0 7054 53 0 0
sp_kill_qstorno_ret_qs2qd 1266489 1266489 0 0.00 0 60695 31 0 0
sp_kill_qty_storno 665170 665170 0 0.00 0 60696 66 0 0
sp_lock_selected_doc 20101 20101 0 0.00 0 9446 5 0 0
sp_make_cost_storno 27037 27037 0 0.00 0 29390 61 0 0
sp_multiply_rows_for_pdistr 27037 27037 0 0.00 0 10163 30 0 0
sp_multiply_rows_for_qdistr 19955 19955 0 0.00 0 16722 144 0 0
sp_pay_from_customer 6839 6839 0 0.00 4 18796 134 0 0
sp_pay_to_supplier 5635 5635 0 0.00 4 21892 131 0 0
sp_payment_common 12474 12474 0 0.00 1 21878 38 0 0
sp_qd_handle_on_cancel_clo 1652 1652 0 0.00 0 7040 285 0 0
sp_qd_handle_on_invoice_upd_sts 11168 11168 0 0.00 0 16969 302 0 0
sp_qd_handle_on_reserve_upd_sts 9779 9779 0 0.00 0 28159 56 0 0
sp_reserve_write_off 9779 9779 0 0.00 6 28187 185 0 0
sp_supplier_invoice 5191 5191 0 0.00 7 106411 3391 0 0
sp_supplier_order 5289 5289 0 0.00 5 39353 1196 0 0
srv_aggregate_perf_data 101 100 1 0.99 2659 268598 24397 0 1
srv_fill_mon_cache_memory 159 159 0 0.00 778 133133 32138 0 0
srv_find_qd_qs_mism 1111150 1111150 0 0.00 0 42170 5 0 0
srv_make_invnt_saldo 498 498 0 0.00 50 40773 1078 0 0
srv_make_money_saldo 801 801 0 0.00 1 443 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 173091 343186 237206 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 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 4785 4785 0 0.00 0 49924 168 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 4694 124 0 0
t$perf-norm:sp_cancel_client_order 1652 1652 0 0.00 0 1644 10 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 2017 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 638 638 0 0.00 0 751 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 2902 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 1202 15 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 27490 1522 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 3835 11 0 0
t$perf-norm:sp_client_order 19955 19955 0 0.00 0 46841 19 0 0
t$perf-norm:sp_customer_reserve 979 979 0 0.00 0 2033 10 0 0
t$perf-norm:sp_pay_from_customer 6839 6839 0 0.00 0 8950 10 0 0
t$perf-norm:sp_pay_to_supplier 5635 5635 0 0.00 0 5871 9 0 0
t$perf-norm:sp_reserve_write_off 9779 9779 0 0.00 0 46713 18 0 0
t$perf-norm:sp_supplier_invoice 5191 5191 0 0.00 0 19440 19 0 0
t$perf-norm:sp_supplier_order 5289 5289 0 0.00 0 5399 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 2754 30 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 247 6 0 0
t$perf-norm:srv_make_invnt_saldo 498 498 0 0.00 0 2360 40 0 0
t$perf-norm:srv_make_money_saldo 801 801 0 0.00 0 1062 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9888 9568 320 3.23 0 5991 22 0 320
v_all_customers 36398 36398 0 0.00 0 109 1 0 0
v_all_suppliers 29262 29262 0 0.00 0 60 1 0 0
v_all_wares 39910 39910 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 241 5 0 0
v_cancel_client_order 3304 3304 0 0.00 0 4236 7 0 0
v_cancel_customer_prepayment 1276 1276 0 0.00 0 7105 21 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 339 3 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 4290 13 0 0
v_cancel_supplier_invoice 826 804 22 2.66 0 2078 17 0 22
v_cancel_supplier_order 866 866 0 0.00 0 3414 8 0 0
v_cancel_write_off 1938 1938 0 0.00 0 1375 13 0 0
v_max_id_clo_ord 5289 5289 0 0.00 0 1008 2 0 0
v_max_id_clo_res 979 979 0 0.00 0 1503 7 0 0
v_max_id_ord_sup 5189 5189 0 0.00 0 3038 5 0 0
v_max_non_paid_invoice 1482 1482 0 0.00 0 2100 6 0 0
v_max_non_paid_realizn 3526 3526 0 0.00 0 974 3 0 0
v_min_id_clo_ord 5289 5289 0 0.00 0 3460 9 0 0
v_min_id_clo_res 979 979 0 0.00 0 6582 17 0 0
v_min_id_ord_sup 5189 5189 0 0.00 0 5944 10 0 0
v_min_non_paid_invoice 5635 5635 0 0.00 0 21875 22 0 0
v_min_non_paid_realizn 6839 6839 0 0.00 0 9880 27 0 0
v_our_firm 10138 10138 0 0.00 0 14 1 0 0
v_reserve_write_off 19558 19558 0 0.00 0 5814 7 0 0
x_lock_depdocs_on_canc_invoice 12975 12975 0 0.00 0 23361 125 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 9054 354 0 0
x_make_qstorno_1000_1200 5289 5289 0 0.00 1 39341 1118 0 0
x_make_qstorno_1200_2000 5191 5191 0 0.00 3 106383 3234 0 0
x_make_qstorno_2100_3300 445717 445717 0 0.00 0 49528 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-01-2021 16:28:12 to 24-01-2021 16:28:16.

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
13:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:22 21883 8192000000 10284512464 10596319232 1072256096 11.574 82 60 120 0 1096080544 3171760 20652688
13:57:53 29934 8192000000 10355098624 10674970624 1400954928 14.603 100 88 176 0 1434115952 5033920 28127104
13:58:34 25962 8192000000 10396032176 10723950592 1447189872 15.013 100 85 169 1 1482109184 7197152 27722160
13:59:13 11903 8192000000 10422976432 10750631936 1475540288 15.262 100 94 188 0 1514233584 8107600 30585696
13:59:40 16620 8192000000 10426803392 10757558272 1483775824 15.334 100 92 184 0 1522806112 9173824 29856464
14:00:06 11092 8192000000 10436851008 10770542592 1492270576 15.409 100 85 170 0 1528880640 9586960 27023104
14:00:28 27315 8192000000 10457218272 10793246720 1508722464 15.552 100 86 172 0 1546082640 9668288 27691888
14:01:05 18090 8192000000 10466988608 10812837888 1526184080 15.704 100 80 160 0 1561512048 10148016 25179952
14:01:40 13988 8192000000 10497364272 10845818880 1551482912 15.923 100 83 166 1 1588344432 10785472 26076048
14:02:06 24800 8192000000 10535012848 10887315456 1589620512 16.251 100 83 166 0 1626668480 11057888 25990080
14:02:44 12864 8192000000 10555717136 10915315712 1618424464 16.496 100 77 152 1 1652608528 11341984 22842080
14:03:06 11739 8192000000 10572749296 10936217600 1636043616 16.646 100 74 148 1 1669906304 11892016 21970672
14:03:26 11153 8192000000 10591749408 10960904192 1652293008 16.784 100 77 154 2 1686633040 11725088 22614944
14:03:47 7281 8192000000 10615511824 10982793216 1676563472 16.988 100 78 156 1 1712069728 12042496 23463760
14:04:01 9048 8192000000 10629148272 11001622528 1692629040 17.123 100 76 147 3 1726797712 12419344 21749328
14:04:18 7240 8192000000 10656670432 11027750912 1711384176 17.280 100 87 174 1 1749287072 12934128 24968768
14:04:34 6558 8192000000 10656620800 11032752128 1720715440 17.358 100 75 148 1 1754835184 13022976 21096768
14:04:47 5591 8192000000 10666855456 11041931264 1727462848 17.414 100 83 164 2 1764522288 13878800 23180640
14:05:01 7532 8192000000 10682791552 11059048448 1739613328 17.515 100 68 136 0 1770603264 11938272 19051664
14:05:16 4566 8192000000 10694495696 11075928064 1754672912 17.640 100 73 146 0 1787759376 12633056 20453408
14:05:29 6695 8192000000 10703629312 11085299712 1764199776 17.719 100 75 148 0 1796797264 12037584 20559904
14:05:42 3616 8192000000 10715748112 11097415680 1776715616 17.822 100 82 164 1 1811839296 12408352 22715328
14:05:52 2763 8192000000 10728838208 11108687872 1786637520 17.904 100 82 163 1 1822365216 11891728 23835968
14:06:02 7678 8192000000 10725394672 11114070016 1786782496 17.905 100 63 126 0 1816062768 12169200 17111072
14:06:18 2908 8192000000 10744720480 11134537728 1809170256 18.089 100 88 176 2 1846834224 13087216 24576752
14:06:28 2125 8192000000 10758942288 11142512640 1819303136 18.172 100 86 172 1 1857428416 14483136 23642144
14:06:37 1944 8192000000 10772709952 11154952192 1826812160 18.233 100 90 179 1 1865027696 14061520 24154016
14:06:46 2294 8192000000 10776082064 11158614016 1833700304 18.289 100 96 193 0 1874938672 14557680 26680688
14:06:54 1687 8192000000 10780630624 11163013120 1833272288 18.286 100 96 191 1 1874461840 15046640 26142912
14:07:03 1930 8192000000 10784608240 11168509952 1839224352 18.334 100 90 177 0 1877444624 13479984 24740288
14:07:11 1611 8192000000 10795495680 11178397696 1845912128 18.389 100 91 182 0 1884611968 13145312 25554528
14:07:19 1698 8192000000 10797457600 11181113344 1854030224 18.455 100 95 190 0 1895180304 14206032 26944048
14:07:27 1926 8192000000 10803450640 11189174272 1859400096 18.498 100 95 188 4 1900362064 14903904 26058064
14:07:35 1480 8192000000 10806578240 11194847232 1860570080 18.508 100 92 184 1 1901631984 14748928 26312976
14:07:43 1101 8192000000 10810385200 11197853696 1865798992 18.550 100 97 196 2 1906251584 12871520 27581072
14:07:50 1552 8192000000 10817561024 11206742016 1872070512 18.601 100 94 189 2 1911115152 12906528 26138112
14:08:00 2948 8192000000 10803728592 11201843200 1867698032 18.566 100 76 152 0 1903079856 14071648 21310176
14:08:10 3841 8192000000 10805580672 11200401408 1872622944 18.605 100 77 152 1 1907011680 12888928 21499808
14:08:20 51027 8192000000 10803671792 11210866688 1864960960 18.543 100 50 100 4 1887145440 7550704 14633776
14:09:17 18915 8192000000 10790420000 11207282688 1870550560 18.589 100 31 62 0 1885509600 6058752 8900288
14:09:43 3953 8192000000 10805952944 11215388672 1877092368 18.642 100 52 104 1 1900538624 8556320 14889936
14:09:55 7469 8192000000 10799985392 11215851520 1876197872 18.634 100 32 66 3 1893456976 7652960 9606144
14:10:10 5674 8192000000 10787691568 11216756736 1880522928 18.669 100 30 61 0 1896020528 6888304 8609296
14:10:22 3238 8192000000 10796927152 11221749760 1882476256 18.685 100 38 76 1 1900845696 7095280 11274160
14:10:36 4284 8192000000 10786772912 11219664896 1883579792 18.694 100 35 70 1 1900866832 7120592 10166448
14:10:46 7286 8192000000 10794403280 11219779584 1883559280 18.694 100 34 68 3 1899504384 6712624 9232480
14:11:02 11597 8192000000 10789734848 11219218432 1882660224 18.687 100 29 58 3 1896612896 5524480 8428192
14:11:24 6169 8192000000 10789506944 11221573632 1886196960 18.715 100 27 54 0 1901579904 6737936 8645008
14:11:37 8462 8192000000 10792854928 11224690688 1884684672 18.703 100 20 41 0 1897150128 6930288 5535168
14:11:51 7753 8192000000 10789316976 11225456640 1884225232 18.699 100 17 34 0 1896169456 7454848 4489376
14:12:05 9833 8192000000 10782730320 11222859776 1885324320 18.708 100 16 32 1 1895805536 5839296 4641920
14:12:21 7636 8192000000 10797439632 11229519872 1886974480 18.721 100 17 34 1 1898026528 6313984 4738064
14:12:36 8724 8192000000 10786284656 11225075712 1888492528 18.734 100 24 48 1 1902468368 7199472 6776368
14:12:55 15896 8192000000 10808174736 11231248384 1896263488 18.796 100 23 45 1 1908028464 4536800 7228176
14:13:18 57697 8192000000 10847777168 11250921472 1901357376 18.837 100 61 124 2 1925286144 6092224 17836544
14:14:21 8464 8192000000 10806084352 11243356160 1897562640 18.807 100 37 74 0 1916641568 8228800 10850128
14:14:37 6536 8192000000 10811169232 11244916736 1897744320 18.808 100 27 52 2 1910160848 5675216 6741312
14:14:52 4702 8192000000 10820178704 11249623040 1903627248 18.855 100 37 74 1 1921456464 7974208 9855008
14:15:03 6014 8192000000 10819680320 11251810304 1903888576 18.858 100 33 65 0 1923981184 10980912 9111696
14:15:19 6079 8192000000 10816385040 11251593216 1905299984 18.869 100 21 42 0 1916992048 5580608 6111456
14:15:31 10474 8192000000 10810558832 11246137344 1885668000 18.711 99 18 36 0 1896302576 5445760 5188816
14:15:49 7448 8192000000 10814375968 11235020800 1884395024 18.701 99 27 54 1 1898353360 5376112 8582224
14:16:03 8792 8192000000 10783564176 11211862016 1797460416 17.993 95 23 44 3 1813914672 10042272 6411984
14:16:18 5228 8192000000 10784075296 11216969728 1871538608 18.597 100 23 46 1 1884497296 6843984 6114704
14:16:30 8249 8192000000 10787323152 11215413248 1863113696 18.529 99 33 66 2 1878801040 6066688 9620656
14:16:45 5345 8192000000 10792505088 11218980864 1862778080 18.526 99 26 51 0 1876226752 5876304 7572368
14:16:56 6585 8192000000 10760958144 11187666944 1823133440 18.203 97 30 60 0 1838325680 6283264 8908976
14:17:09 9400 8192000000 10769619728 11198910464 1841498880 18.353 99 18 34 1 1855555296 9387504 4668912
14:17:29 16309 8192000000 10765773488 11181842432 1778091792 17.834 95 28 55 3 1791335040 5517504 7725744
14:17:52 59998 8192000000 10743578000 11172671488 1808177408 18.081 98 29 58 2 1825581072 9443152 7960512
14:18:59 8384 8192000000 10744720240 11168059392 1790355312 17.935 97 14 26 1 1799134544 5090640 3688592
14:19:15 7753 8192000000 10711219040 11137126400 1750821280 17.608 96 29 60 1 1765109584 5425264 8863040
14:19:29 5096 8192000000 10729162640 11143708672 1767621696 17.747 97 39 77 3 1785126416 6379760 11124960
14:19:42 6058 8192000000 10706664240 11125379072 1740179824 17.520 95 23 46 3 1753140672 6652320 6308528
14:19:55 4975 8192000000 10695488128 11103592448 1720913936 17.360 96 31 62 2 1735975472 6314272 8747264
14:20:06 5727 8192000000 10712222448 11129507840 1779276784 17.844 99 29 58 2 1793423264 6512016 7634464
14:20:22 6241 8192000000 10703023872 11119566848 1744983776 17.560 97 28 56 1 1758506160 4847408 8674976
14:20:39 10602 8192000000 10690121776 11106312192 1742167968 17.537 97 26 52 0 1755499776 5498224 7833584
14:20:59 9899 8192000000 10691286304 11109740544 1750509408 17.606 97 23 45 0 1762425232 5093040 6822784
14:21:17 9156 8192000000 10711676192 11130150912 1755937792 17.651 97 29 57 1 1769681952 4657792 9086368
14:21:35 8079 8192000000 10721721680 11138502656 1799889248 18.013 100 17 33 3 1810972032 5942784 5140000
14:21:49 10290 8192000000 10717221200 11129151488 1757406048 17.663 97 33 65 1 1773516352 5362464 10747840
14:22:08 6223 8192000000 10733257328 11149213696 1796189104 17.983 99 18 36 0 1805772704 4968512 4615088
14:22:20 9517 8192000000 10734732576 11148296192 1793399184 17.960 99 20 40 0 1809050320 9669184 5981952
14:23:24 26786 8192000000 10742128288 11160137728 1790254144 17.934 98 16 32 1 1800011760 5417536 4340080
14:23:58 11348 8192000000 10758923696 11172696064 1832853200 18.283 100 23 45 2 1844373440 5578752 5941488
14:24:17 7507 8192000000 10750733616 11174707200 1840216912 18.343 100 25 51 0 1852735952 5698016 6821024
14:24:31 5529 8192000000 10760421280 11185238016 1845260832 18.384 100 36 73 1 1862411408 7191936 9958640
14:24:44 9279 8192000000 10759570192 11188101120 1844305504 18.376 100 19 36 1 1855685840 5797024 5583312
14:24:59 9770 8192000000 10768488752 11189882880 1849042736 18.414 100 22 42 0 1860750992 5260144 6448112
14:25:17 8351 8192000000 10764510336 11193720832 1852362288 18.441 100 25 50 0 1866073600 6180624 7530688
14:25:31 9712 8192000000 10776223584 11197698048 1854164096 18.456 100 25 50 1 1867696992 5374400 8158496
14:25:50 10612 8192000000 10769361632 11196743680 1855449552 18.466 100 22 44 2 1867165696 5237456 6478688
14:26:07 8547 8192000000 10780709136 11204259840 1859511808 18.499 100 34 66 4 1876207904 6789328 9906768
14:26:22 9486 8192000000 10777780352 11200270336 1857485024 18.483 100 20 41 0 1869345024 6105488 5754512
14:26:38 13261 8192000000 10765062272 11199758336 1857324368 18.482 100 11 21 1 1865732560 5223440 3184752
14:27:00 11554 8192000000 10784304176 11215794176 1872988016 18.608 100 16 32 0 1882103776 4258944 4856816
14:27:46 16760 8192000000 10825265824 11241684992 1894992352 18.786 100 35 68 2 1910756640 5819728 9944560
14:28:10 67630 8192000000 10851192288 11266617344 1904239184 18.860 100 39 78 0 1922775424 7383120 11153120
14:29:27 123624 8192000000 10876216272 11302866944 1935771408 19.113 100 49 98 3 1962380096 13640480 12968208
14:31:38 41716 8192000000 10869670560 11305644032 1937882704 19.130 100 34 66 1 1964222544 17129056 9210784
14:32:32 43080 8192000000 10894498816 11327594496 1948222992 19.212 100 48 95 1 1979173360 17681888 13268480
14:33:23 4626 8192000000 10895920000 11326881792 1940751600 19.153 99 51 97 0 1974174320 19043968 14378752
14:33:36 24989 8192000000 10893293232 11330084864 1956195536 19.276 100 46 92 2 1992251888 22814208 13242144
14:34:14 31652 8192000000 10900278960 11333517312 1941820512 19.161 99 36 72 2 1974997744 22423152 10754080
14:34:57 21931 8192000000 10895915088 11334934528 1941392016 19.158 99 40 79 0 1979340048 25611728 12336304
14:35:27 10566 8192000000 10916302080 11346702336 1963419680 19.333 100 45 90 2 1999872880 22967760 13485440
14:35:44 8944 8192000000 10921177984 11349520384 1971603856 19.398 100 57 113 0 2010345632 20638752 18103024
14:36:00 10210 8192000000 10927605648 11358220288 1980919072 19.472 100 54 108 1 2016443520 19642256 15882192
14:36:18 5291 8192000000 10939837344 11359240192 1978116832 19.450 100 62 123 0 2020701920 24691952 17893136
14:36:30 6441 8192000000 10920391936 11345223680 1956140320 19.275 99 65 127 0 1995252800 21112704 17999776
14:36:45 4699 8192000000 10935517696 11354255360 1979869456 19.464 100 70 140 0 2023797216 23574000 20353760
14:36:56 6626 8192000000 10939743776 11359801344 1984335984 19.499 100 73 146 1 2029384016 24083856 20964176
14:37:10 7863 8192000000 10948602096 11367428096 1989264800 19.538 100 78 153 0 2036223472 24761232 22197440
14:37:34 6407 8192000000 10954350032 11380879360 1995595984 19.588 100 66 131 0 2044962960 29643744 19723232
14:37:55 2684 8192000000 10951858656 11374010368 1989642480 19.541 100 62 122 0 2036862384 27923616 19296288
14:38:04 3111 8192000000 10958460592 11380166656 1996266880 19.593 100 70 140 0 2045979408 29084880 20627648
14:38:14 5274 8192000000 10948551136 11369279488 1971617040 19.398 99 65 126 1 2020237408 29590864 19029504
14:38:26 3378 8192000000 10956021520 11374276608 1988385120 19.531 100 70 139 1 2040279392 31139488 20754784
14:38:41 4020 8192000000 10930811520 11352121344 1952097088 19.243 98 59 117 1 2003944288 33653040 18194160
14:38:52 9809 8192000000 10948231696 11372945408 1987305424 19.522 100 64 126 0 2043872512 37954768 18612320
14:39:10 8773 8192000000 10942564000 11365195776 1972442048 19.405 99 63 124 0 2027901504 36158416 19301040
14:39:26 4712 8192000000 10945374912 11360354304 1967758480 19.368 99 77 153 1 2026115984 35714960 22642544
14:39:41 2189 8192000000 10957508816 11383054336 1986655216 19.517 100 75 149 3 2050327680 41564800 22107664
14:39:52 6053 8192000000 10963035904 11379884032 1987177152 19.521 100 70 138 1 2046773040 37758032 21837856
14:40:16 4035 8192000000 10964780592 11383271424 1988174224 19.529 100 68 134 1 2044311424 35376480 20760720
14:40:29 9747 8192000000 10949588080 11377364992 1967487360 19.366 99 57 114 0 2023593792 38501392 17605040
14:40:54 12882 8192000000 10954469168 11386228736 1960309776 19.309 99 57 114 0 2024465072 46359792 17795504
14:41:16 11706 8192000000 10944299840 11378520064 1979715504 19.462 100 59 118 2 2039687408 41092640 18879264
14:41:35 6142 8192000000 10975239536 11388960768 1987494032 19.524 100 76 153 4 2054797136 42647584 24655520
14:41:51 4471 8192000000 10966601568 11381202944 1978501344 19.453 100 74 148 2 2046065296 44612208 22951744
14:42:05 1671 8192000000 10972795792 11389423616 1983172512 19.490 100 78 157 0 2054119520 46187936 24759072
14:42:14 5014 8192000000 10964562048 11384717312 1968103120 19.370 99 69 138 0 2036428736 47088080 21237536
14:42:28 4588 8192000000 10966848256 11386380288 1981014416 19.473 100 69 138 1 2049727632 46770288 21942928
14:42:47 4482 8192000000 10945100592 11362631680 1946284032 19.197 98 67 133 1 2014939872 48180768 20475072
14:42:58 1574 8192000000 10975931968 11382448128 1982502560 19.485 100 89 179 1 2053755408 43620080 27632768
14:43:06 2424 8192000000 10980851344 11389906944 1986392496 19.515 100 93 186 0 2057804032 43453776 27957760
14:43:15 1571 8192000000 10981032864 11393187840 1991325888 19.554 100 86 173 1 2061221968 43167648 26728432
14:43:24 2128 8192000000 10983122528 11396939776 1997311056 19.602 100 86 172 1 2065919440 42403904 26204480
14:43:34 1313 8192000000 10987405696 11402878976 1999570048 19.619 100 80 160 0 2067039632 42798096 24671488
14:43:42 1628 8192000000 10979681552 11390713856 1985038688 19.505 99 92 180 1 2053732688 40809040 27884960
14:43:54 1001 8192000000 10972760272 11387604992 1985817456 19.511 100 77 154 2 2053683120 44180624 23685040
14:44:02 1309 8192000000 10978200128 11386064896 1980348192 19.467 100 89 177 1 2054652272 47353456 26950624
14:44:09 1997 8192000000 10956178656 11363213312 1962548960 19.326 99 86 169 1 2035700752 47638816 25512976
14:44:19 2881 8192000000 10964661920 11377844224 1959571376 19.303 99 79 158 0 2034456048 49579776 25304896
14:44:31 1916 8192000000 10964156384 11375099904 1966156176 19.355 100 81 160 1 2042461280 50984784 25320320
14:44:42 2051 8192000000 10956755952 11368095744 1947485712 19.206 99 81 162 2 2026712000 53856688 25369600
14:44:50 7144 8192000000 10957936016 11380703232 1966904992 19.361 100 65 129 2 2039945984 52561424 20479568
14:45:06 6679 8192000000 10959794576 11380903936 1972296800 19.404 100 77 154 1 2051384528 54203072 24884656
14:45:19 4414 8192000000 10943887808 11357581312 1946704352 19.200 99 76 152 2 2025371040 54827072 23839616
14:45:30 777 8192000000 10979574752 11386720256 1969763936 19.384 100 84 167 0 2054121408 57868128 26489344
14:45:41 3535 8192000000 10972486160 11386421248 1971208512 19.395 100 78 156 0 2055988064 59715888 25063664
14:45:51 2604 8192000000 10978553008 11389140992 1973945920 19.417 100 90 180 1 2063317152 61498912 27872320
14:46:02 2405 8192000000 10966013568 11389366272 1976047104 19.433 100 72 144 1 2056873856 58070864 22755888
14:46:14 4199 8192000000 10954177008 11374358528 1955963984 19.274 99 69 135 1 2033251520 56014160 21273376
14:46:26 4773 8192000000 10955438000 11385851904 1968118080 19.371 100 67 133 2 2046675920 56854880 21702960
14:46:43 10644 8192000000 10968529456 11397459968 1976798544 19.439 100 54 107 2 2054127248 60053264 17275440
14:47:00 8996 8192000000 10935658768 11368448000 1948932464 19.218 99 49 98 0 2019885872 54970432 15982976
14:47:16 10368 8192000000 10949612256 11390115840 1967629376 19.367 100 43 86 0 2039624912 57414896 14580640
14:47:34 7918 8192000000 10961112688 11401449472 1973664912 19.415 100 38 76 2 2040238784 54152160 12421712
14:47:50 9758 8192000000 10957236464 11397316608 1976198256 19.435 100 41 80 4 2045477392 56093040 13186096
14:48:10 8361 8192000000 10968474896 11405402112 1975802224 19.431 100 44 89 2 2051448464 60893488 14752752
14:48:28 10180 8192000000 10969168304 11406897152 1964376288 19.341 99 38 76 0 2038028576 60511456 13140832
14:48:46 5827 8192000000 10958549440 11389763584 1950448496 19.230 99 57 115 0 2031483824 62658912 18376416
14:49:00 10203 8192000000 10950498928 11388502016 1955586944 19.271 100 58 116 2 2042835296 68049680 19198672
14:49:18 18998 8192000000 10923759936 11364249600 1918405632 18.974 99 32 64 0 1994188992 64791584 10991776
14:49:43 11372 8192000000 10931945312 11371503616 1945012048 19.187 100 33 66 1 2015172352 58966080 11194224
14:50:04 11700 8192000000 10923227600 11363815424 1928386736 19.054 99 35 70 1 1998531136 58062624 12081776
14:50:22 8529 8192000000 10944461200 11375222784 1947859472 19.209 100 33 65 0 2019039376 59807680 11372224
14:50:37 10565 8192000000 10939847536 11371294720 1931730848 19.081 99 40 81 1 2008065088 62205696 14128544
14:50:54 10450 8192000000 10932502080 11373936640 1925050752 19.027 99 38 76 1 2005372800 66735856 13586192
14:51:16 4764 8192000000 10945571904 11378122752 1944844032 19.185 100 40 80 3 2028257088 69091760 14321296
14:51:30 10244 8192000000 10948248704 11379580928 1935022944 19.107 99 47 95 0 2022015952 71184224 15808784
14:51:49 12134 8192000000 10947738768 11389046784 1949024192 19.219 100 38 76 1 2034946000 71998976 13922832
14:52:22 19060 8192000000 10932457520 11378339840 1940278128 19.149 100 32 64 0 2016669440 64808016 11583296
14:52:58 25068 8192000000 10913775376 11365257216 1936020144 19.115 100 32 64 0 2004273344 57234624 11018576
14:53:32 15361 8192000000 10899717248 11349721088 1915797680 18.953 99 25 50 1 1985405088 60336560 9270848
14:54:39 28207 8192000000 10903927520 11361247232 1899076640 18.819 99 25 50 1 1974588848 65965328 9546880
14:55:14 19261 8192000000 10925150720 11377491968 1921582464 19.000 100 22 44 2 1995583216 65535200 8465552
14:56:05 9737 8192000000 10895519136 11382341632 1909211008 18.900 100 15 30 0 1986227808 70733568 6283232
14:56:21 11962 8192000000 10883562576 11352387584 1894413792 18.781 99 11 22 1 1958819280 60444224 3961264
14:56:40 58916 8192000000 10836997632 11295997952 1809520288 18.092 95 3 6 0 1830755104 20603872 630944
14:57:45 79168 8192000000 10870006704 11313561600 1846656832 18.395 96 13 27 0 1862120976 12634816 2829328
14:59:10 85868 8192000000 10879747248 11326398464 1936481392 19.119 100 9 17 0 1951827264 13327808 2018064
15:00:44 71609 8192000000 10907340624 11349032960 1943526432 19.175 99 24 48 0 1959121360 9077744 6517184
15:02:09 89120 8192000000 10918450352 11366981632 1968684624 19.375 100 50 98 3 2006671328 24852480 13134224
15:03:51 53258 8192000000 10893848032 11373879296 1965464992 19.349 100 27 53 2 1994803088 21442640 7895456
15:05:17 6566 8192000000 10903284240 11366817792 1971594032 19.398 100 25 50 0 1992922384 14180128 7148224
15:05:43 29810 8192000000 10890522048 11356569600 1968066672 19.370 100 13 26 0 1984002272 12326096 3609504
15:06:20 45215 8192000000 10893942080 11358777344 1954598928 19.263 99 17 34 1 1967886400 8667920 4619552
15:07:13 20889 8192000000 10905255088 11367440384 1972986912 19.409 100 15 30 0 1990255040 12872624 4395504
15:07:45 36225 8192000000 10909137440 11361763328 1976439648 19.437 100 53 106 1 2003913744 11598336 15875760
15:08:32 46997 8192000000 10904472784 11368808448 1958464384 19.294 99 34 69 0 1978564176 11059056 9040736
15:09:27 23220 8192000000 10881765456 11346964480 1945503744 19.191 99 17 34 0 1959827584 9209184 5114656
15:10:49 22735 8192000000 10884979152 11363766272 1967128256 19.363 100 9 18 0 1983222656 13529872 2564528
15:12:26 50880 8192000000 10899221744 11373473792 1964142496 19.339 99 10 20 1 1979989328 12832176 3014656
15:13:29 37171 8192000000 10900562304 11375067136 1977800960 19.447 100 12 22 2 1993099136 12007200 3290976
15:14:26 61664 8192000000 10917602384 11391311872 1988530864 19.532 100 16 32 1 2005812560 11895520 5386176
15:16:40 91076 8192000000 10913064448 11385475072 1955222464 19.268 98 30 60 2 1970519408 7703504 7593440
15:18:28 39014 8192000000 10906113888 11394195456 1985016320 19.504 100 9 18 1 1999969712 12307152 2646240
15:19:14 19922 8192000000 10910353200 11401633792 1992692000 19.565 100 11 22 1 2008068864 12718048 2658816
15:19:45 45339 8192000000 10906586912 11384582144 1978135296 19.450 99 17 32 1 1997608544 14111520 5361728
15:20:46 74383 8192000000 10906844672 11383304192 1974224656 19.419 99 13 26 0 1991671712 13584160 3862896
15:22:53 48511 8192000000 10918128928 11398213632 1994040896 19.576 100 16 32 1 2011446272 12494320 4911056
15:23:48 65834 8192000000 10884519200 11370090496 1910205984 18.908 96 10 20 0 1923511664 10207216 3098464
15:25:00 35272 8192000000 10921543168 11371708416 1922754880 19.009 97 28 56 0 1939306320 8433008 8118432
15:25:41 61409 8192000000 10903432912 11384901632 1956815168 19.281 99 24 48 0 1978629936 15031040 6783728
15:26:50 96245 8192000000 10909164496 11392237568 1931109840 19.076 97 18 36 3 1946268416 10940368 4218208
15:28:48 83692 8192000000 10916621248 11395907584 1931191392 19.076 97 11 22 0 1943410192 9594192 2624608
15:30:18 65752 8192000000 10912289200 11378647040 1932138512 19.084 97 14 28 1 1945826368 9614192 4073664
15:31:32 15367 8192000000 10917800784 11372601344 1980112160 19.466 100 39 78 2 2003538224 12939808 10486256
15:31:56 45198 8192000000 10906868304 11366494208 1929806672 19.065 97 42 84 1 1958895696 17775440 11313584
15:32:49 100982 8192000000 10904294128 11389272064 1927145056 19.044 98 11 22 1 1955860944 26105056 2610832
15:34:36 104145 8192000000 10888708560 11358490624 1802788016 18.037 91 10 20 0 1815204912 10288656 2128240
15:37:16 109139 8192000000 10830390032 11302064128 1840380272 18.344 94 18 36 1 1862713024 16883312 5449440
15:39:13 46964 8192000000 10846488256 11300081664 1882254688 18.683 97 45 90 3 1903520000 8051216 13214096
15:40:14 75112 8192000000 10829024768 11297419264 1866991008 18.560 98 21 42 2 1887183520 14763152 5429360
15:41:38 25199 8192000000 10840775904 11298463744 1888873360 18.737 99 15 30 1 1907419904 14699008 3847536
15:42:11 87828 8192000000 10818747984 11295678464 1780143344 17.851 93 14 28 0 1792007680 8472256 3392080
15:43:46 75026 8192000000 10832109408 11303964672 1852274752 18.441 97 8 16 0 1869007760 14471936 2261072
15:45:12 48126 8192000000 10789438176 11241861120 1796026928 17.981 94 25 50 0 1815495888 11971120 7497840
15:46:11 65378 8192000000 10799723680 11272458240 1842393408 18.360 98 12 24 0 1863745712 17340224 4012080
15:47:28 70247 8192000000 10832799552 11280539648 1846638848 18.395 98 26 52 2 1863138448 9273680 7225920
15:49:16 65101 8192000000 10820055728 11294060544 1894513616 18.782 100 11 22 0 1909123360 11728736 2881008
15:50:29 54812 8192000000 10827893264 11304263680 1910991168 18.915 100 19 38 0 1924414624 7619136 5804320
15:51:55 63392 8192000000 10824681520 11301609472 1897128208 18.803 99 10 20 1 1909729824 9302704 3298912
15:53:08 74865 8192000000 10834974048 11307933696 1882738336 18.687 98 8 16 1 1893592928 8430592 2424000
15:54:32 97255 8192000000 10840996576 11310235648 1864596544 18.541 97 12 24 2 1877987152 10282128 3108480
15:56:23 19985 8192000000 10873566736 11332116480 1915681712 18.952 99 31 62 2 1935278736 10966928 8630096
15:56:51 24495 8192000000 10898163120 11346808832 1947319504 19.205 100 49 98 2 1976263728 15440704 13503520
15:57:23 65098 8192000000 10881767744 11360337920 1939524832 19.143 99 26 52 1 1962483360 16603744 6354784
15:58:40 17084 8192000000 10891485152 11354505216 1958889824 19.297 100 30 59 1 1982201184 15559744 7751616
15:59:04 32637 8192000000 10886817184 11343802368 1927033472 19.043 98 33 66 1 1946462592 10635200 8793920
15:59:49 33266 8192000000 10910339136 11367473152 1963032912 19.330 100 29 58 0 1981142848 10428656 7681280
16:00:34 38255 8192000000 10901799456 11364503552 1951390352 19.238 99 28 56 1 1971116048 12009232 7716464
16:01:22 13863 8192000000 10912591280 11365208064 1972452720 19.405 100 33 66 1 1992174080 10908976 8812384
16:01:44 12915 8192000000 10923228560 11373797376 1962551504 19.326 99 47 94 2 1990667168 15618208 12497456
16:02:57 66285 8192000000 10910344016 11378221056 1941945840 19.162 98 21 41 0 1957536896 10079072 5511984
16:04:11 133133 8192000000 10893308448 11366477824 1922245744 19.005 97 12 24 0 1943023456 17720976 3056736
16:06:30 56191 8192000000 10922882000 11390533632 1984569088 19.501 100 27 55 0 2008001168 15173616 8258464
16:07:39 107150 8192000000 10899842016 11386912768 1947849120 19.209 98 15 30 1 1976148720 23604688 4694912
16:09:34 93992 8192000000 10916240768 11390083072 1978566432 19.453 100 16 32 0 2001196848 18362528 4267888
16:11:21 46080 8192000000 10913064224 11386978304 1991652304 19.557 100 19 38 1 2006291024 9274272 5364448
16:12:14 26632 8192000000 10925951360 11402145792 1995548400 19.588 100 22 44 1 2011138048 9161120 6428528
16:14:09 60338 8192000000 10925726592 11422027776 1979143744 19.458 99 9 18 0 1998760624 17206144 2410736
16:15:17 14789 8192000000 10932081968 11404312576 2002337680 19.641 100 13 26 4 2026167984 19253040 4577264
16:15:49 56483 8192000000 10928853280 11407278080 1965817328 19.352 98 15 30 2 1988211312 17982704 4411280
16:16:52 64656 8192000000 10921347280 11399917568 1975877424 19.432 99 17 34 1 1996637408 15007520 5752464
16:18:37 65726 8192000000 10879041248 11361665024 1923537872 19.015 97 19 38 0 1938258000 9433568 5286560
16:19:50 83919 8192000000 10897252000 11387031552 1936575568 19.119 98 7 14 2 1951223392 12628192 2019632
16:21:20 62467 8192000000 10910561408 11385835520 1948507024 19.215 98 11 22 0 1959774448 8204112 3063312
16:22:28 66502 8192000000 10899383392 11384774656 1928185808 19.052 97 14 27 1 1943717440 11417408 4114224
16:23:41 49259 8192000000 10897387696 11353034752 1876339360 18.636 95 22 44 1 1894126672 10955184 6832128
16:24:42 68246 8192000000 10854995600 11320770560 1806126688 18.064 92 20 40 1 1822365248 10634736 5603824
16:26:54 22996 8192000000 9121756992 9351061504 283999664 3.350 15 6 12 1 287026144 1665808 1360672

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-01-2021 16:28:18 to 24-01-2021 16:28:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 160 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 24-01-2021 16:28:50 to 24-01-2021 16:28:52.

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          237057
MON$OLDEST_ACTIVE               237058
MON$OLDEST_SNAPSHOT             237058
MON$NEXT_TRANSACTION            237058
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                       2053408
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:378: 
:379: mscs-test-161.budzdorov.ru    Sun Jan 24 16:27:19 2021
:380:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:381: 
--- end of diff output ---

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

24.01.21 16:28:53. 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-01-24 16:28:55 No severe PSQL-related problems occured
24.01.21 16:28:57. End of report.