Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.06.2021 22: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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17003000 kB
MemAvailable 31373160 kB
Buffers 0 kB
Cached 14624504 kB
SwapCached 32 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-06-14 22:27:40
DTS_END                         2021-06-14 22:27:40.4590
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/48206
TRN_ID                          249043
ATT_ID                          653
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: 9575.80 19460 1149096
customer order: creation 185.61 310 22273
customer order: refuse 15.61 330 1873
order to supplier: creation 49.58 1270 5950
order to supplier: removal 3.58 94492 429
invoice (draft): creation 49.70 3076 5964
invoice (draft): removal 53.24 757 6389
invoice accept: apply 44.64 16842 5357
invoice accept: cancel 48.33 765 5800
customer reserve: creation 4057.68 169 486922
customer reserve: removal 4755.38 56 570646
realization accept: apply 90.26 166 10831
realization accept: cancel 82.89 114 9947
payment from customer: creation 63.40 118 7608
payment from customer: removal 5.93 79 711
payment to supplier: creation 53.27 139 6392
payment to supplier: removal 3.57 79 428
service: total inventory turnovers 5.23 1157 627
service: total monetary turnovers 6.94 36 833
service: aggregate perf. data 0.93 22758 112
service: refresh index statistics 0.03 246484 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-06-2021 22:28:33 to 14-06-2021 22:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8221
TEST_TIME 2 7361
TEST_TIME 3 7195
TEST_TIME 4 7606
TEST_TIME 5 7353
TEST_TIME 6 7073
TEST_TIME 7 6808
TEST_TIME 8 6713
TEST_TIME 9 6607
TEST_TIME 10 6739
TEST_TIME 11 6619
TEST_TIME 12 6576
TEST_TIME 13 6772
TEST_TIME 14 6709
TEST_TIME 15 6699
TEST_TIME 16 7182
TEST_TIME 17 7726
TEST_TIME 18 7772
TEST_TIME 19 7904
TEST_TIME 20 8432
TEST_TIME 21 8545
TEST_TIME 22 8625
TEST_TIME 23 9123
TEST_TIME 24 9172
TEST_TIME 25 9290
TEST_TIME 26 9528
TEST_TIME 27 9631
TEST_TIME 28 9713
TEST_TIME 29 10197
TEST_TIME 30 10652
TEST_TIME 31 10990
TEST_TIME 32 10905
TEST_TIME 33 10701
TEST_TIME 34 10723
TEST_TIME 35 10881
TEST_TIME 36 10717
TEST_TIME 37 10625
TEST_TIME 38 10656
TEST_TIME 39 10707
TEST_TIME 40 10694
TEST_TIME 41 10591
TEST_TIME 42 10411
TEST_TIME 43 10312
TEST_TIME 44 10347
TEST_TIME 45 10387
TEST_TIME 46 10239
TEST_TIME 47 10175
TEST_TIME 48 10119
TEST_TIME 49 10039
TEST_TIME 50 9929
TEST_TIME 51 10154
TEST_TIME 52 10110
TEST_TIME 53 10087
TEST_TIME 54 10031
TEST_TIME 55 9934
TEST_TIME 56 9888
TEST_TIME 57 9875
TEST_TIME 58 9809
TEST_TIME 59 9838
TEST_TIME 60 9775
TEST_TIME 61 9674
TEST_TIME 62 9667
TEST_TIME 63 9668
TEST_TIME 64 9785
TEST_TIME 65 9753
TEST_TIME 66 9765
TEST_TIME 67 9847
TEST_TIME 68 9832
TEST_TIME 69 9990
TEST_TIME 70 9980
TEST_TIME 71 9997
TEST_TIME 72 9989
TEST_TIME 73 10012
TEST_TIME 74 10065
TEST_TIME 75 10024
TEST_TIME 76 9922
TEST_TIME 77 9908
TEST_TIME 78 9905
TEST_TIME 79 9839
TEST_TIME 80 9825
TEST_TIME 81 9763
TEST_TIME 82 9743
TEST_TIME 83 9697
TEST_TIME 84 9651
TEST_TIME 85 9620
TEST_TIME 86 9631
TEST_TIME 87 9608
TEST_TIME 88 9614
TEST_TIME 89 9610
TEST_TIME 90 9653
TEST_TIME 91 9683
TEST_TIME 92 9719
TEST_TIME 93 9740
TEST_TIME 94 9749
TEST_TIME 95 9765
TEST_TIME 96 9871
TEST_TIME 97 9871
TEST_TIME 98 9818
TEST_TIME 99 9876
TEST_TIME 100 9892
TEST_TIME 101 9814
TEST_TIME 102 9799
TEST_TIME 103 9745
TEST_TIME 104 9770
TEST_TIME 105 9758
TEST_TIME 106 9719
TEST_TIME 107 9695
TEST_TIME 108 9676
TEST_TIME 109 9603
TEST_TIME 110 9598
TEST_TIME 111 9578
TEST_TIME 112 9590
TEST_TIME 113 9573
TEST_TIME 114 9575
TEST_TIME 115 9590
TEST_TIME 116 9588
TEST_TIME 117 9591
TEST_TIME 118 9605
TEST_TIME 119 9602
TEST_TIME 120 9579

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-06-2021 22:28:37 to 14-06-2021 22:28:40.

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 1601413 1601413 0 0.00 0 16262 6 0 0
doc_list_biud 1601413 1601413 0 0.00 0 25014 26 0 0
sp_add_invoice_to_stock 5504 5357 147 2.67 26 183807 16842 0 147
sp_cancel_adding_invoice 5800 5800 0 0.00 5 65529 766 0 0
sp_cancel_client_order 1873 1873 0 0.00 5 9242 331 0 0
sp_cancel_customer_reserve 570646 570646 0 0.00 1 23888 56 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 3 9723 80 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 2750 80 0 0
sp_cancel_supplier_invoice 6395 6389 6 0.09 2 14636 758 0 6
sp_cancel_supplier_order 429 429 0 0.00 5 1025048 94493 0 0
sp_cancel_write_off 9947 9947 0 0.00 1 7810 114 0 0
sp_client_order 22273 22273 0 0.00 3 15880 311 0 0
sp_customer_reserve 486922 486922 0 0.00 0 41412 170 0 0
sp_fill_shopping_cart 34177 34177 0 0.00 1 24899 37 0 0
sp_fill_shopping_cart_clo_res 486914 486914 0 0.00 0 11446 12 0 0
sp_get_clo_for_invoice 5349 5349 0 0.00 0 30641 284 0 0
sp_kill_cost_storno 16886 16886 0 0.00 0 7233 54 0 0
sp_kill_qstorno_ret_qs2qd 1158057 1158057 0 0.00 0 23882 31 0 0
sp_kill_qty_storno 611263 611263 0 0.00 0 25014 66 0 0
sp_lock_selected_doc 22413 22413 0 0.00 0 6886 4 0 0
sp_make_cost_storno 30179 30179 0 0.00 0 11903 50 0 0
sp_multiply_rows_for_pdistr 30179 30179 0 0.00 0 7383 27 0 0
sp_multiply_rows_for_qdistr 22273 22273 0 0.00 0 10707 153 0 0
sp_pay_from_customer 7608 7608 0 0.00 4 12361 118 0 0
sp_pay_to_supplier 6392 6392 0 0.00 5 11917 139 0 0
sp_payment_common 14000 14000 0 0.00 1 12357 36 0 0
sp_qd_handle_on_cancel_clo 1873 1873 0 0.00 0 9235 301 0 0
sp_qd_handle_on_invoice_upd_sts 11148 11148 0 0.00 0 22148 316 0 0
sp_qd_handle_on_reserve_upd_sts 10831 10831 0 0.00 0 25014 57 0 0
sp_reserve_write_off 10831 10831 0 0.00 6 25234 166 0 0
sp_supplier_invoice 5964 5964 0 0.00 6 77466 3076 0 0
sp_supplier_order 5950 5950 0 0.00 5 28142 1271 0 0
srv_aggregate_perf_data 113 112 1 0.88 2741 491112 22759 0 1
srv_fill_mon_cache_memory 169 169 0 0.00 1432 124579 30796 0 0
srv_find_qd_qs_mism 1098775 1098775 0 0.00 0 16233 5 0 0
srv_make_invnt_saldo 627 627 0 0.00 26 139110 1157 0 0
srv_make_money_saldo 833 833 0 0.00 1 7694 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 94861 386531 246485 0 0
t$perf-abend:sp_add_invoice_to_stock 147 147 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 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 5357 5357 0 0.00 0 11999 171 0 0
t$perf-norm:sp_cancel_adding_invoice 482 482 0 0.00 0 3922 85 0 0
t$perf-norm:sp_cancel_client_order 1873 1873 0 0.00 0 5788 19 0 0
t$perf-norm:sp_cancel_customer_reserve 781 781 0 0.00 0 1936 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 3454 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 4862 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 446 446 0 0.00 0 2308 27 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 25732 1634 0 0
t$perf-norm:sp_cancel_write_off 1084 1084 0 0.00 0 2344 9 0 0
t$perf-norm:sp_client_order 22273 22273 0 0.00 0 11577 19 0 0
t$perf-norm:sp_customer_reserve 1077 1077 0 0.00 0 3715 16 0 0
t$perf-norm:sp_pay_from_customer 7608 7608 0 0.00 0 12311 14 0 0
t$perf-norm:sp_pay_to_supplier 6392 6392 0 0.00 0 3997 13 0 0
t$perf-norm:sp_reserve_write_off 10831 10831 0 0.00 0 5739 12 0 0
t$perf-norm:sp_supplier_invoice 5964 5964 0 0.00 0 4361 19 0 0
t$perf-norm:sp_supplier_order 5950 5950 0 0.00 0 7459 19 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 373 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 4028 31 0 0
t$perf-norm:srv_make_invnt_saldo 627 627 0 0.00 0 871 18 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 3756 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 10990 10696 294 2.67 0 10678 18 0 294
v_all_customers 40402 40402 0 0.00 0 121 1 0 0
v_all_suppliers 32906 32906 0 0.00 0 19 1 0 0
v_all_wares 44546 44546 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 964 964 0 0.00 0 193 6 0 0
v_cancel_client_order 3746 3746 0 0.00 0 4865 6 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 1733 7 0 0
v_cancel_customer_reserve 1562 1562 0 0.00 0 1048 5 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 1720 4 0 0
v_cancel_supplier_invoice 904 892 12 1.32 0 990 16 0 12
v_cancel_supplier_order 858 858 0 0.00 0 1165 5 0 0
v_cancel_write_off 2168 2168 0 0.00 0 7053 22 0 0
v_max_id_clo_ord 5950 5950 0 0.00 0 316 1 0 0
v_max_id_clo_res 1077 1077 0 0.00 0 4127 17 0 0
v_max_id_ord_sup 5954 5954 0 0.00 0 4509 5 0 0
v_max_non_paid_invoice 1843 1843 0 0.00 0 765 3 0 0
v_max_non_paid_realizn 4112 4112 0 0.00 0 2599 4 0 0
v_min_id_clo_ord 5950 5950 0 0.00 0 4431 8 0 0
v_min_id_clo_res 1077 1077 0 0.00 0 1940 5 0 0
v_min_id_ord_sup 5954 5954 0 0.00 0 9874 14 0 0
v_min_non_paid_invoice 6392 6392 0 0.00 0 11589 22 0 0
v_min_non_paid_realizn 7608 7608 0 0.00 0 12353 29 0 0
v_our_firm 11136 11136 0 0.00 0 15 1 0 0
v_reserve_write_off 21662 21662 0 0.00 0 6153 6 0 0
x_lock_depdocs_on_canc_invoice 11743 11743 0 0.00 0 15476 108 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 3621 294 0 0
x_make_qstorno_1000_1200 5950 5950 0 0.00 1 28123 1185 0 0
x_make_qstorno_1200_2000 5964 5964 0 0.00 2 77414 2948 0 0
x_make_qstorno_2100_3300 486922 486922 0 0.00 0 41411 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-06-2021 22:28:41 to 14-06-2021 22:28:45.

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
19:57:44 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:50 7163 8192000000 10115501376 10403459072 759323216 8.482 63 55 110 0 780086752 2336432 18427104
19:58:06 27322 8192000000 10349784064 10663526400 1395753440 14.557 100 92 185 0 1429953408 4550816 29649152
19:58:44 27352 8192000000 10390377824 10714165248 1429865408 14.860 100 83 165 1 1463068384 6280160 26922816
19:59:22 26425 8192000000 10422551024 10752360448 1470729760 15.220 100 90 180 0 1507030720 7423504 28877456
20:00:03 15681 8192000000 10431655200 10761093120 1487876976 15.370 100 90 180 0 1526197360 8653328 29667056
20:00:35 24017 8192000000 10444377264 10780508160 1500554624 15.481 100 88 176 1 1538305024 9553920 28196480
20:01:11 14441 8192000000 10457885472 10795638784 1515591344 15.612 100 89 177 1 1554022640 9900976 28530320
20:01:35 22678 8192000000 10469659392 10813276160 1526761760 15.709 100 83 166 0 1562727584 9788656 26177168
20:02:08 14489 8192000000 10494001568 10842693632 1549541280 15.906 100 79 158 1 1584013520 9847392 24624848
20:02:31 19626 8192000000 10533817632 10885103616 1586035920 16.220 100 84 169 0 1622423296 10689200 25698176
20:02:58 16290 8192000000 10537002400 10895556608 1609995504 16.425 100 80 156 2 1644384656 10747024 23642128
20:03:23 15332 8192000000 10573637232 10935451648 1628209008 16.580 100 77 154 1 1662558432 11384368 22965056
20:03:47 10187 8192000000 10596545136 10958077952 1654987968 16.807 100 88 176 0 1694074368 12770448 26315952
20:04:06 9283 8192000000 10609431376 10975457280 1669144784 16.926 100 82 164 0 1705878704 12605344 24128576
20:04:23 12274 8192000000 10622288704 10992451584 1685727840 17.065 100 83 165 1 1722144288 12715840 23700608
20:04:46 6158 8192000000 10635396608 11008557056 1697366256 17.163 100 75 151 1 1732149120 13100832 21682032
20:05:00 8410 8192000000 10650824160 11023970304 1710954656 17.277 100 77 154 0 1745258624 11916480 22387488
20:05:16 8054 8192000000 10665654512 11040710656 1725781504 17.400 100 80 158 0 1760975072 12259792 22933776
20:05:30 5823 8192000000 10684929760 11058479104 1740049072 17.519 100 82 164 1 1775778240 12405328 23323840
20:05:44 8509 8192000000 10692218336 11070500864 1752334096 17.621 100 81 162 0 1788537680 13816704 22386880
20:06:00 4351 8192000000 10713387152 11088969728 1770600192 17.772 100 87 174 1 1809859808 14011856 25247760
20:06:11 4911 8192000000 10716702464 11096342528 1775965136 17.816 100 86 168 4 1811695056 12000784 23729136
20:06:23 3821 8192000000 10717997376 11098181632 1782167968 17.867 100 84 169 2 1818381328 12670480 23542880
20:06:34 3935 8192000000 10733185056 11112247296 1788846592 17.922 100 88 174 0 1827932528 13703536 25382400
20:06:44 2925 8192000000 10736339984 11116965888 1794445760 17.968 100 87 172 1 1831881248 13465584 23969904
20:06:54 2798 8192000000 10737681744 11122360320 1803599200 18.043 100 84 164 1 1838719008 11823600 23296208
20:07:04 2313 8192000000 10751927040 11135332352 1811671104 18.110 100 88 170 1 1847215104 11878352 23665648
20:07:13 2734 8192000000 10748355088 11129888768 1813158848 18.122 100 90 182 0 1851531504 13124128 25248528
20:07:23 3928 8192000000 10763513040 11149570048 1816485392 18.149 100 84 168 2 1855118992 14163872 24469728
20:07:34 1502 8192000000 10777359760 11158425600 1830863568 18.266 100 94 189 1 1871861328 14503360 26494400
20:07:42 2059 8192000000 10780952096 11164082176 1840353904 18.344 100 90 177 3 1878541136 13146928 25040304
20:07:51 2529 8192000000 10787193584 11173597184 1846903952 18.397 100 90 176 2 1885417488 13764496 24749040
20:07:59 1694 8192000000 10793935632 11179298816 1847958992 18.406 100 92 182 0 1886148192 12167936 26021264
20:08:07 2761 8192000000 10799099696 11189735424 1859329440 18.498 100 90 176 1 1896736032 12874496 24532096
20:08:16 2011 8192000000 10794559488 11188555776 1860011104 18.503 100 87 174 1 1897333696 12327872 24994720
20:08:25 1117 8192000000 10811292880 11202203648 1867008400 18.560 100 98 197 0 1907996720 13432848 27555472
20:08:32 2067 8192000000 10793967248 11193749504 1862239248 18.521 100 77 154 1 1897605680 13579440 21786992
20:08:45 17880 8192000000 10786656992 11198570496 1862211536 18.521 100 55 111 0 1888522432 10717840 15593056
20:09:11 4871 8192000000 10782232256 11193876480 1864465504 18.539 100 44 89 0 1885863136 9145888 12251744
20:09:25 4312 8192000000 10777983232 11201167360 1866961280 18.560 100 39 78 2 1886981920 9558400 10462240
20:09:36 6227 8192000000 10794472480 11202957312 1867451552 18.564 100 36 71 2 1884290080 6582512 10256016
20:09:50 8407 8192000000 10791769472 11202756608 1866833632 18.559 100 24 48 0 1880734880 7471184 6430064
20:10:06 4536 8192000000 10779633104 11203153920 1871345680 18.595 100 39 79 3 1889763280 7578208 10839392
20:10:16 7445 8192000000 10785873232 11210727424 1869654656 18.581 100 23 46 0 1887901632 11694032 6552944
20:10:31 12489 8192000000 10792401360 11212931072 1873927968 18.616 100 24 49 0 1886920576 6143056 6849552
20:10:51 6971 8192000000 10783616400 11214241792 1875676256 18.630 100 28 57 1 1891434864 8343072 7415536
20:11:05 12524 8192000000 10777984288 11215298560 1877473648 18.645 100 10 20 1 1885719120 5616656 2628816
20:11:24 13723 8192000000 10795425728 11222921216 1887865424 18.729 100 27 51 2 1902304576 6385168 8053984
20:11:46 48384 8192000000 10820499136 11231748096 1887524912 18.726 100 29 58 0 1901688960 5201456 8962592
20:12:49 19377 8192000000 10812216416 11242618880 1890901152 18.753 100 29 58 0 1905609504 6183392 8524960
20:13:18 3820 8192000000 10816292240 11245047808 1897220128 18.804 100 41 83 1 1916505552 7420720 11864704
20:13:32 4289 8192000000 10815387312 11245109248 1896147440 18.795 100 28 56 1 1910668560 6612368 7908752
20:13:42 3743 8192000000 10825671888 11249508352 1900501824 18.830 100 44 88 1 1920010864 6839664 12669376
20:13:54 6298 8192000000 10814543088 11249668096 1899208336 18.820 100 23 46 3 1911906672 5641776 7056560
20:14:07 4300 8192000000 10819053744 11252682752 1900266496 18.828 100 19 38 1 1912581728 6577728 5737504
20:14:21 5316 8192000000 10825079664 11261906944 1907513504 18.887 100 39 77 2 1929378176 11000032 10864640
20:14:34 10574 8192000000 10820600432 11256971264 1905879616 18.874 100 16 32 1 1915421408 4917872 4623920
20:14:52 9510 8192000000 10825256224 11259879424 1908168752 18.892 100 26 52 0 1922538096 7010928 7358416
20:15:08 5334 8192000000 10826700176 11258900480 1907790704 18.889 100 24 48 1 1921201520 6827552 6583264
20:15:21 8217 8192000000 10822821088 11260289024 1910132432 18.908 100 17 34 1 1920659648 5634848 4892368
20:15:35 8866 8192000000 10823845456 11260940288 1910951888 18.914 100 18 36 4 1921967072 5858240 5156944
20:15:51 12208 8192000000 10825441200 11264753664 1911546384 18.919 100 14 28 0 1921552224 5974112 4031728
20:16:11 7866 8192000000 10817208176 11258544128 1892010416 18.762 99 17 34 1 1902544672 5723808 4810448
20:16:27 64498 8192000000 10851366000 11269148672 1909924384 18.906 100 29 58 2 1925057568 6497824 8635360
20:17:39 12454 8192000000 10818453664 11258544128 1914870528 18.946 100 14 28 1 1923773552 5051264 3851760
20:17:58 10979 8192000000 10833132144 11259985920 1882635488 18.686 98 38 76 1 1899562256 7224208 9702560
20:18:16 6497 8192000000 10833774880 11262369792 1910776560 18.913 100 29 54 1 1924148880 5861952 7510368
20:18:28 6896 8192000000 10814176448 11237597184 1851630112 18.435 97 26 52 0 1864424384 5530528 7263744
20:18:46 10051 8192000000 10772182832 11192274944 1781405424 17.861 95 18 36 1 1791932480 5516800 5010256
20:19:03 8404 8192000000 10738433600 11168489472 1777130704 17.826 96 22 44 0 1789750592 6660336 5959552
20:19:17 11136 8192000000 10707062064 11132489728 1747433472 17.580 96 23 46 1 1759885200 5673024 6778704
20:19:35 11287 8192000000 10714323888 11137617920 1766964176 17.742 98 15 30 0 1776715696 5678160 4073360
20:19:54 6342 8192000000 10708112544 11134627840 1776865696 17.824 98 23 46 2 1790643888 6499264 7278928
20:20:08 5258 8192000000 10735938176 11159257088 1820431824 18.181 100 30 60 3 1835930544 5431664 10067056
20:20:22 10582 8192000000 10679099312 11094188032 1660641728 16.854 92 16 32 2 1670984096 5101008 5241360
20:20:40 7739 8192000000 10664317936 11068309504 1650869232 16.772 93 23 47 1 1663078640 4505744 7703664
20:20:54 12790 8192000000 10701402240 11110514688 1715444784 17.314 96 19 38 2 1726088624 5097408 5546432
20:21:14 18879 8192000000 10708340496 11118915584 1739990304 17.519 97 17 34 1 1750371040 5294464 5086272
20:21:44 61186 8192000000 10706979264 11128115200 1762349280 17.704 98 25 50 3 1775275856 5410192 7516384
20:22:55 9815 8192000000 10720094464 11140214784 1790522192 17.936 99 22 44 0 1802052976 5137616 6393168
20:23:11 9540 8192000000 10703191424 11123736576 1745787152 17.567 97 18 35 0 1756092448 5280960 5024336
20:23:27 6382 8192000000 10713585920 11133108224 1783916176 17.882 99 28 56 1 1798033664 5361616 8755872
20:23:41 5836 8192000000 10723173472 11151958016 1809267024 18.090 100 20 40 1 1821055152 6567152 5220976
20:23:53 8631 8192000000 10748246080 11167014912 1825481712 18.222 100 34 68 2 1841192592 5643392 10067488
20:24:08 8217 8192000000 10756157600 11175276544 1836647552 18.314 100 37 72 3 1852784448 5276288 10860608
20:24:23 10546 8192000000 10763149216 11182243840 1838143040 18.326 100 30 60 0 1852495840 5920000 8432800
20:24:39 6277 8192000000 10755158960 11182215168 1842239568 18.359 100 21 42 2 1854658336 6478192 5940576
20:24:53 9993 8192000000 10760893184 11183214592 1834762256 18.298 99 25 50 0 1847590592 5363040 7465296
20:25:10 15799 8192000000 10763112512 11193184256 1850691968 18.428 100 17 34 1 1861304480 5813328 4799184
20:25:34 7369 8192000000 10778289776 11203084288 1856712944 18.477 100 20 40 0 1868005920 5506048 5786928
20:25:49 8881 8192000000 10774533952 11208454144 1862618384 18.525 100 18 36 0 1873725568 5807456 5299728
20:26:05 8348 8192000000 10773173552 11206135808 1863482128 18.532 100 14 28 0 1872681840 5388368 3811344
20:26:20 69966 8192000000 10806977232 11224580096 1872528160 18.605 100 30 60 0 1886407312 5174128 8705024
20:27:36 7290 8192000000 10800086064 11229843456 1887126800 18.723 100 22 44 1 1899062800 4581360 7354640
20:28:03 12312 8192000000 10836796624 11257163776 1909533120 18.903 100 45 90 0 1929732608 7424400 12775088
20:28:23 6909 8192000000 10852784672 11272638464 1924171040 19.020 100 56 109 1 1948478928 8836192 15471696
20:28:37 2148 8192000000 10889137680 11295850496 1936868992 19.122 100 94 187 1 1975067744 10971968 27226784
20:28:54 4768 8192000000 10871819200 11291942912 1934705344 19.104 100 58 116 0 1961806112 10433680 16667088
20:29:05 28596 8192000000 10873876464 11298910208 1936721600 19.121 100 52 103 1 1961852208 10654016 14476592
20:29:44 9902 8192000000 10880531440 11307225088 1949492224 19.222 100 59 118 0 1978038160 11405360 17140576
20:30:02 20656 8192000000 10879406608 11315445760 1951607760 19.239 100 54 109 0 1979966384 12088480 16270144
20:30:33 15829 8192000000 10879394688 11312762880 1954201456 19.260 100 44 88 1 1976787808 9650384 12935968
20:30:59 37242 8192000000 10887875120 11322400768 1956799936 19.281 100 35 70 1 1977749712 10975792 9973984
20:31:43 6516 8192000000 10905219680 11330740224 1966803120 19.360 100 56 112 0 1993579792 9857904 16918768
20:32:00 10350 8192000000 10897402480 11331096576 1967202144 19.363 100 51 102 2 1991649808 9364384 15083280
20:32:20 2908 8192000000 10910696512 11337175040 1972090256 19.402 100 64 129 3 2001099792 10220448 18789088
20:32:30 10502 8192000000 10910191232 11341762560 1973874832 19.416 100 61 120 3 2001712992 10921344 16916816
20:32:54 10449 8192000000 10912161760 11344199680 1976267152 19.435 100 58 115 1 2003365312 11038656 16059504
20:33:26 5370 8192000000 10915204336 11347771392 1979945408 19.464 100 48 96 1 2004041424 10586128 13509888
20:33:39 12911 8192000000 10919614528 11358175232 1986743552 19.518 100 55 110 0 2015023136 11772992 16506592
20:34:13 7293 8192000000 10918399296 11352596480 1984003312 19.496 100 46 87 4 2007465984 10340864 13121808
20:34:28 7942 8192000000 10938235952 11365249024 1994244848 19.577 100 79 156 3 2028831264 11687776 22898640
20:34:42 21747 8192000000 10939783888 11371847680 1995149504 19.584 100 54 108 0 2024069472 13072992 15846976
20:35:24 9510 8192000000 10930188752 11367731200 1982735360 19.486 99 56 111 0 2011305520 12945104 15625056
20:35:43 8090 8192000000 10932711616 11371241472 1999771728 19.621 100 48 96 3 2027538464 12909424 14857312
20:36:01 6220 8192000000 10951691072 11383742464 2006264224 19.672 100 67 130 4 2044368112 17896880 20207008
20:36:17 15932 8192000000 10954158928 11389558784 2007118208 19.679 100 63 126 1 2039909712 14614160 18177344
20:36:39 5871 8192000000 10944631312 11378716672 1993532096 19.572 99 67 133 1 2031070864 17398784 20139984
20:36:53 4750 8192000000 10973089616 11391864832 2010516192 19.706 100 66 132 0 2047355968 18074944 18764832
20:37:04 12324 8192000000 10945888448 11377958912 2004607744 19.659 100 72 144 0 2044460768 18637552 21215472
20:37:27 2829 8192000000 10979763632 11396902912 2017758864 19.763 100 82 163 1 2061791344 20066320 23966160
20:37:39 9684 8192000000 10961520432 11397951488 2012719280 19.723 100 57 114 1 2049434288 19403968 17311040
20:37:57 17354 8192000000 10959795312 11401547776 2013601632 19.730 100 49 97 4 2049246352 19998928 15645792
20:38:30 11837 8192000000 10949869392 11387518976 1993315552 19.570 99 56 112 0 2032130000 21192272 17622176
20:38:53 8944 8192000000 10931098768 11377180672 1981588528 19.477 99 37 74 1 2015880848 22994832 11297488
20:39:11 9807 8192000000 10943013280 11388981248 2000500672 19.627 100 39 78 3 2036369488 22598624 13270192
20:39:31 3823 8192000000 10929149184 11342778368 1957104320 19.283 98 57 113 1 1997485984 23620288 16761376
20:39:42 5629 8192000000 10962959568 11382284288 1998200528 19.609 100 79 159 2 2048161952 26068128 23893296
20:40:01 3710 8192000000 10974431424 11393384448 2003934304 19.654 100 84 166 1 2055828288 27100176 24793808
20:40:19 7542 8192000000 10970690000 11389980672 2007413232 19.681 100 77 149 0 2055467136 26452336 21601568
20:40:37 2075 8192000000 10960964160 11390525440 2006902176 19.677 100 67 134 1 2054225824 26915952 20407696
20:40:50 6346 8192000000 10967667856 11401150464 2009951024 19.701 100 56 108 0 2055056176 28963968 16141184
20:41:04 4638 8192000000 10974168208 11404591104 2011393440 19.712 100 55 112 3 2056213312 28095104 16724768
20:41:20 10333 8192000000 10974927200 11409604608 2013702080 19.731 100 58 116 1 2061823264 30403168 17718016
20:41:42 4064 8192000000 10987965504 11415236608 2024080928 19.812 100 73 144 1 2074966688 28954064 21931696
20:41:59 4244 8192000000 10968998512 11400110080 2006169584 19.671 100 70 140 0 2059116784 31269680 21677520
20:42:13 11391 8192000000 10966950656 11401654272 1988250848 19.530 99 57 114 0 2039394192 32899632 18243712
20:42:32 8147 8192000000 10953356608 11394826240 1980985600 19.473 99 50 100 3 2030857152 33560672 16310880
20:42:48 4553 8192000000 10960811840 11395375104 1979092720 19.458 99 48 95 1 2028684016 33873680 15717616
20:43:01 4085 8192000000 10967062480 11396952064 1998535056 19.611 100 76 151 3 2057354992 34423904 24396032
20:43:14 3866 8192000000 10962567216 11393679360 1995064672 19.584 100 64 128 1 2049554560 34302688 20187200
20:43:28 3556 8192000000 10972227936 11404300288 2006947360 19.677 100 72 143 0 2062429808 31634608 23847840
20:43:40 4441 8192000000 10945476448 11359358976 1963492272 19.334 99 81 161 2 2020795152 32575904 24726976
20:43:56 3749 8192000000 10965807168 11386793984 1990606640 19.549 100 82 163 2 2048141952 33312320 24222992
20:44:11 3882 8192000000 10972863936 11397955584 1997084256 19.600 100 78 156 0 2055427792 34551344 23792192
20:44:22 1432 8192000000 10970460656 11391238144 1991165824 19.553 100 86 168 3 2054481104 37349920 25965360
20:44:31 8322 8192000000 10954118352 11394404352 1991153488 19.553 100 61 122 0 2043161760 33881840 18126432
20:44:54 1690 8192000000 10961603856 11385393152 1997239248 19.601 100 89 177 1 2054658080 30856688 26562144
20:45:03 3312 8192000000 10968470224 11387924480 1990863808 19.551 100 73 146 2 2044908112 31826416 22217888
20:45:14 5949 8192000000 10958142768 11386605568 1988346000 19.531 100 66 132 1 2042317616 33560304 20411312
20:45:38 3942 8192000000 10975139168 11402076160 2005126944 19.663 100 79 154 2 2063362384 34025808 24209632
20:45:51 7904 8192000000 10957507280 11389714432 1978625184 19.454 99 77 155 1 2039400752 36734592 24040976
20:46:07 3247 8192000000 10962045216 11389337600 1976816000 19.439 99 71 143 0 2036897232 38070976 22010256
20:46:19 9780 8192000000 10941732720 11379646464 1949903760 19.226 98 55 110 1 2005539120 38385744 17249616
20:46:38 14296 8192000000 10963831008 11394953216 1989224352 19.538 100 56 112 4 2045527632 38647792 17655488
20:46:58 3048 8192000000 10963508048 11386777600 1981104240 19.473 100 68 132 1 2042087744 39773584 21209920
20:47:08 6398 8192000000 10956867248 11375161344 1970368976 19.388 100 78 154 0 2037335616 41933200 25033440
20:47:21 4655 8192000000 10958281648 11385204736 1975123344 19.426 100 69 138 1 2041530208 44435232 21971632
20:47:40 3966 8192000000 10928856272 11366436864 1971027216 19.394 100 62 124 1 2026590080 35663184 19899680
20:47:57 6827 8192000000 10925684064 11368665088 1965426096 19.349 100 41 82 0 2017168928 38208256 13534576
20:48:18 3887 8192000000 10923830096 11345371136 1949575328 19.223 99 75 150 0 2008453472 34981952 23896192
20:48:28 7289 8192000000 10951647696 11370430464 1966178848 19.355 100 67 131 1 2030888240 44191024 20518368
20:48:42 2002 8192000000 10959135488 11379126272 1972862160 19.408 100 80 160 2 2041921808 42614016 26445632
20:48:54 7901 8192000000 10947981504 11387916288 1974578096 19.422 100 57 114 4 2036890208 43510704 18801408
20:49:24 5423 8192000000 10943779808 11382853632 1971978672 19.401 99 42 84 2 2028929536 42462032 14488832
20:49:38 4350 8192000000 10958171712 11382460416 1949055312 19.219 98 72 143 2 2015225200 42228144 23941744
20:49:51 10387 8192000000 10949009936 11378163712 1948507264 19.215 99 55 108 3 2013208288 47535696 17165328
20:50:11 4894 8192000000 10930173808 11366133760 1957295344 19.285 100 49 98 1 2016442944 43416848 15730752
20:50:26 3167 8192000000 10943505424 11369496576 1962912080 19.329 100 57 112 1 2023624976 43061136 17651760
20:50:37 2682 8192000000 10958128752 11384528896 1974259312 19.419 100 60 120 1 2037645552 43721488 19664752
20:50:50 15521 8192000000 10921181024 11375390720 1952885008 19.249 99 37 74 0 2008623664 43879712 11858944
20:51:25 8304 8192000000 10935440736 11366240256 1960793376 19.312 100 43 87 2 2014449328 39257072 14398880
20:51:41 10064 8192000000 10936352608 11374080000 1933908208 19.098 98 47 94 1 1993097088 43789152 15399728
20:52:01 15389 8192000000 10909980368 11353997312 1918519632 18.975 98 32 64 2 1972335264 42984720 10830912
20:52:24 29777 8192000000 10921226320 11362242560 1930952192 19.074 99 35 70 2 1991429280 48572032 11905056
20:53:10 19038 8192000000 10912421968 11352907776 1924358736 19.022 99 28 56 2 1980834432 46686640 9789056
20:53:41 39534 8192000000 10890724736 11342368768 1900390992 18.829 98 22 44 2 1954420416 46710512 7318912
20:54:30 43526 8192000000 10895916880 11327225856 1886379920 18.717 98 27 51 0 1933670672 38456640 8834112
20:55:31 13984 8192000000 10901530816 11343523840 1930819680 19.073 100 43 86 1 1989849328 45324496 13705152
20:55:56 10461 8192000000 10907732528 11351572480 1936555072 19.119 100 39 79 1 1990635008 41098560 12981376
20:56:13 23392 8192000000 10888033824 11351465984 1928101632 19.052 100 21 43 0 1983677952 48647168 6929152
20:56:44 16166 8192000000 10865394048 11322318848 1904658800 18.864 99 13 26 0 1941578480 32257280 4662400
20:57:27 38422 8192000000 10863267120 11328782336 1904397408 18.862 99 14 28 0 1934570224 26132576 4040240
20:58:15 75793 8192000000 10860521376 11309338624 1854651056 18.460 96 5 10 0 1865374032 9527584 1195392
20:59:37 59775 8192000000 10882558464 11318304768 1904729856 18.864 98 26 52 0 1927083040 14632048 7721136
21:00:59 123873 8192000000 10877240032 11353796608 1913175808 18.932 98 17 35 1 1932978064 15472592 4329664
21:03:33 97499 8192000000 10902805648 11353550848 1929113296 19.060 98 26 52 1 1949645024 13388512 7143216
21:05:31 68163 8192000000 10906246320 11374178304 1970098784 19.386 100 25 50 0 1988617120 11423728 7094608
21:06:48 122124 8192000000 10905943120 11364564992 1937496912 19.127 98 13 26 2 1956399728 14497344 4405472
21:08:57 124579 8192000000 10935667504 11391234048 1966044848 19.354 99 40 80 1 1988256768 10369440 11842480
21:11:11 82235 8192000000 10925271552 11381874688 1952098464 19.243 98 26 48 0 1969720288 10815712 6806112
21:13:07 38103 8192000000 10895107152 11365408768 1961067088 19.315 99 15 30 1 1975179360 10049376 4062896
21:13:54 25216 8192000000 10932724800 11386765312 1988777280 19.534 100 32 64 0 2008010816 9742272 9491264
21:14:27 45355 8192000000 10901371472 11368726528 1932985312 19.091 97 26 52 1 1950881840 10497488 7399040
21:15:20 50136 8192000000 10924805840 11386519552 1978447648 19.452 100 19 38 1 2000008432 15984192 5576592
21:16:17 34051 8192000000 10943528752 11403243520 1998383152 19.610 100 31 62 3 2021505440 13177520 9944768
21:16:58 28763 8192000000 10972951344 11413204992 2010402176 19.705 100 50 101 2 2040497904 14647568 15448160
21:17:33 55946 8192000000 10928194128 11416817664 2004019600 19.654 100 23 46 0 2030597600 19129680 7448320
21:18:37 38270 8192000000 10909658528 11403194368 1980208544 19.466 99 20 40 2 2007505008 20931552 6364912
21:19:21 24111 8192000000 10907068176 11396157440 1988263152 19.530 100 10 20 1 2003912512 12508592 3140768
21:19:52 16056 8192000000 10909789904 11395018752 1987128464 19.521 100 7 14 1 1999512576 10414416 1969696
21:20:27 45697 8192000000 10877116240 11341197312 1898896784 18.817 95 21 41 2 1911057088 6801568 5358736
21:21:24 53753 8192000000 10887459568 11365904384 1945862384 19.194 99 19 38 0 1958328976 7209024 5257568
21:22:24 52575 8192000000 10895755712 11371728896 1966949712 19.361 100 14 28 1 1978787568 7535280 4302576
21:23:28 75634 8192000000 10866552560 11342422016 1867960928 18.568 95 15 29 1 1878527312 6819600 3746784
21:24:50 35450 8192000000 10882467376 11344592896 1946549328 19.199 99 21 41 2 1962921872 10566208 5806336
21:25:35 46986 8192000000 10894619920 11367464960 1949612240 19.223 99 11 22 1 1959665808 7337968 2715600
21:27:25 59609 8192000000 10878122992 11357024256 1930472832 19.071 98 13 26 0 1941934976 7108240 4353904
21:28:55 64787 8192000000 10900481984 11374837760 1954975616 19.266 99 12 24 1 1972635472 14167968 3491888
21:30:24 36210 8192000000 10887666864 11355471872 1955659712 19.272 100 18 36 2 1972883200 12249008 4974480
21:31:07 43192 8192000000 10876217808 11353239552 1901573824 18.839 97 15 30 0 1924442144 18418368 4449952
21:31:56 14495 8192000000 10919003392 11369627648 1958692944 19.296 99 48 96 1 1979517984 7673536 13151504
21:32:23 18965 8192000000 10912586112 11372777472 1969914880 19.385 100 39 78 1 1993338816 12450544 10973392
21:32:49 37309 8192000000 10885309280 11358838784 1937802192 19.129 98 26 52 1 1959432384 13684864 7945328
21:33:46 71910 8192000000 10917675104 11396861952 1952263536 19.245 99 19 38 2 1976454704 18869120 5322048
21:36:00 43451 8192000000 10913262288 11369943040 1944505632 19.183 99 22 44 0 1965691648 14819040 6366976
21:36:51 26280 8192000000 10900938640 11364196352 1951889680 19.242 99 30 60 1 1968795328 8669728 8235920
21:37:25 19916 8192000000 10898432176 11354337280 1892738576 18.768 96 41 82 2 1914767488 10594144 11434768
21:37:55 54902 8192000000 10846795136 11315834880 1827843312 18.242 94 16 32 0 1845300736 13200352 4257072
21:38:59 25309 8192000000 10854347888 11310399488 1911388032 18.918 100 39 73 0 1932809200 11448288 9972880
21:39:32 10308 8192000000 10874111632 11323523072 1927727760 19.049 100 38 76 1 1947903440 9750400 10425280
21:39:53 11683 8192000000 10904147168 11340398592 1943627856 19.176 100 57 112 1 1969215424 10022624 15564944
21:40:14 68394 8192000000 10847159920 11327295488 1867391056 18.563 96 31 62 1 1888483712 12451488 8641168
21:41:32 72592 8192000000 10872570224 11330535424 1865614464 18.549 96 20 40 0 1881279552 10071344 5593744
21:42:55 102331 8192000000 10856886832 11324542976 1917700512 18.968 99 37 74 2 1938385328 9003488 11681328
21:44:59 79083 8192000000 10867178896 11343405056 1911596928 18.919 98 20 39 2 1927840224 10640688 5602608
21:46:24 16259 8192000000 10857436672 11324989440 1900884368 18.833 98 27 53 0 1917852048 9880896 7086784
21:46:55 35949 8192000000 10863366544 11340599296 1924347296 19.022 99 20 40 2 1938225568 8591728 5286544
21:47:37 59191 8192000000 10854425856 11340754944 1927072288 19.043 99 8 16 0 1938118256 8828656 2217312
21:48:42 66183 8192000000 10856621968 11342913536 1901604320 18.839 98 10 20 0 1916911344 12106176 3200848
21:49:55 81650 8192000000 10850187312 11328839680 1908527440 18.895 98 8 16 0 1919304960 8289840 2487680
21:51:23 57910 8192000000 10838579984 11324174336 1914692256 18.944 99 7 14 1 1925010752 8559312 1759184
21:52:27 44854 8192000000 10867472560 11355361280 1948446064 19.214 100 14 28 1 1959872368 7651200 3775104
21:53:25 82430 8192000000 10873611760 11345534976 1876358672 18.636 96 16 31 2 1891778800 10914816 4505312
21:54:53 54327 8192000000 10866184000 11344228352 1919309984 18.981 98 27 53 1 1940134640 12546032 8278624
21:56:05 51218 8192000000 10879060432 11357454336 1956246784 19.276 100 33 66 1 1979347392 13751216 9349392
21:57:03 52399 8192000000 10887732544 11354906624 1919300448 18.981 98 17 34 1 1944519360 20493888 4725024
21:58:02 48880 8192000000 10899883264 11371364352 1952225328 19.244 99 24 48 1 1971703392 12232288 7245776
21:59:09 64416 8192000000 10885456240 11371102208 1915021312 18.947 97 18 36 2 1931355904 11105600 5228992
22:00:22 96836 8192000000 10908978352 11375579136 1921481392 18.999 97 10 20 0 1934225344 10546800 2197152
22:02:05 56871 8192000000 10912611232 11397931008 1968237200 19.371 99 27 54 1 1985450864 9883920 7329744
22:03:16 61319 8192000000 10920435984 11417427968 1960793248 19.312 99 10 18 1 1983995472 20778768 2423456
22:04:24 84269 8192000000 10932851616 11387588608 1933800160 19.097 97 20 39 2 1951521472 12394592 5326720
22:05:55 54470 8192000000 10928860288 11408949248 1949570608 19.223 98 30 60 1 1974174032 16110880 8492544
22:06:59 92773 8192000000 10909346816 11397476352 1960546864 19.310 99 5 10 0 1981875072 20009744 1318464
22:08:42 71570 8192000000 10897242704 11364204544 1825144800 18.220 92 30 59 1 1840819200 8175808 7498592
22:11:16 53868 8192000000 10873957632 11363246080 1937492080 19.127 99 16 32 2 1960631056 18400624 4738352
22:12:33 61019 8192000000 10882050624 11360407552 1934697920 19.104 99 2 4 0 1941872016 6766640 407456
22:13:41 71951 8192000000 10901357520 11369697280 1935037552 19.107 98 14 28 1 1945991008 7248608 3704848
22:15:09 64187 8192000000 10895930928 11384389632 1973590400 19.414 100 10 20 1 1986439680 9870512 2978768
22:16:20 36711 8192000000 10910579456 11383115776 1978481632 19.453 100 11 22 0 1991724608 10150976 3092000
22:17:03 31212 8192000000 10911097664 11384934400 1957864720 19.289 99 16 32 1 1974635664 12174192 4596752
22:17:50 49523 8192000000 10896783728 11382542336 1942511056 19.167 98 10 20 1 1955192576 10049264 2632256
22:18:56 44850 8192000000 10897129360 11389739008 1971555104 19.398 100 10 20 0 1989119728 14525872 3038752
22:19:54 35440 8192000000 10898679776 11380453376 1962944320 19.329 99 12 24 0 1973139296 7385536 2809440
22:20:36 49064 8192000000 10875290384 11365756928 1901596144 18.839 96 17 33 4 1914712800 8614672 4501984
22:21:41 50634 8192000000 10858201568 11329011712 1874248448 18.619 96 18 36 3 1888317552 8518736 5550368
22:22:42 63629 8192000000 10868695728 11339866112 1848069664 18.406 95 15 30 1 1861508848 8930576 4508608
22:24:00 62699 8192000000 10832734864 11310522368 1819872720 18.177 94 19 38 1 1834888128 9381792 5633616
22:25:26 48671 8192000000 10894969888 11343294464 1898887216 18.817 98 28 56 1 1914498544 8284368 7326960
22:26:26 48968 8192000000 10874001664 11353731072 1929855152 19.066 99 20 40 1 1947951776 12707088 5389536
22:27:21 31991 8192000000 9162235744 9401548800 314613040 3.698 17 2 4 0 324934416 9953008 368368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-06-2021 22:28:47 to 14-06-2021 22:29:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 147 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-06-2021 22:29:20 to 14-06-2021 22:29:22.

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          249042
MON$OLDEST_ACTIVE               249529
MON$OLDEST_SNAPSHOT             249529
MON$NEXT_TRANSACTION            249529
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                       2052704
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:168: 
:169: mscs-test-161.budzdorov.ru    Mon Jun 14 22:27:55 2021
:170:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:171: 
:172: 
:173: mscs-test-161.budzdorov.ru    Mon Jun 14 22:28:00 2021
:174:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:175: 
--- end of diff output ---

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

14.06.21 22:29:23. 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-06-14 22:29:25 No severe PSQL-related problems occured
14.06.21 22:29:26. End of report.