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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-04 22:27:19
DTS_END                         2021-03-04 22:27:19.5960
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(601:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34170
TRN_ID                          237583
ATT_ID                          614
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: 8975.45 29055 1077054
customer order: creation 164.21 391 19705
customer order: refuse 14.37 401 1724
order to supplier: creation 45.19 1197 5423
order to supplier: removal 3.31 102649 397
invoice (draft): creation 44.38 3734 5325
invoice (draft): removal 51.36 775 6163
invoice accept: apply 39.94 18199 4793
invoice accept: cancel 46.32 782 5558
customer reserve: creation 3707.74 178 444929
customer reserve: removal 4576.02 58 549123
realization accept: apply 81.54 182 9785
realization accept: cancel 74.13 118 8895
payment from customer: creation 57.81 126 6937
payment from customer: removal 5.58 100 669
payment to supplier: creation 48.04 156 5765
payment to supplier: removal 3.28 62 394
service: total inventory turnovers 4.74 1061 569
service: total monetary turnovers 6.59 39 791
service: aggregate perf. data 0.88 16668 105
service: refresh index statistics 0.03 434215 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3919
TEST_TIME 2 4875
TEST_TIME 3 3947
TEST_TIME 4 4541
TEST_TIME 5 4618
TEST_TIME 6 4827
TEST_TIME 7 5243
TEST_TIME 8 5544
TEST_TIME 9 5455
TEST_TIME 10 6067
TEST_TIME 11 6051
TEST_TIME 12 6412
TEST_TIME 13 6534
TEST_TIME 14 6444
TEST_TIME 15 6519
TEST_TIME 16 6723
TEST_TIME 17 6969
TEST_TIME 18 7224
TEST_TIME 19 7560
TEST_TIME 20 7730
TEST_TIME 21 8071
TEST_TIME 22 8647
TEST_TIME 23 8959
TEST_TIME 24 8966
TEST_TIME 25 9616
TEST_TIME 26 10269
TEST_TIME 27 10306
TEST_TIME 28 10172
TEST_TIME 29 9920
TEST_TIME 30 9694
TEST_TIME 31 9726
TEST_TIME 32 9551
TEST_TIME 33 9431
TEST_TIME 34 9452
TEST_TIME 35 9405
TEST_TIME 36 9260
TEST_TIME 37 9162
TEST_TIME 38 9092
TEST_TIME 39 9005
TEST_TIME 40 8888
TEST_TIME 41 8769
TEST_TIME 42 8766
TEST_TIME 43 8761
TEST_TIME 44 8775
TEST_TIME 45 8735
TEST_TIME 46 8723
TEST_TIME 47 8759
TEST_TIME 48 8837
TEST_TIME 49 8804
TEST_TIME 50 8912
TEST_TIME 51 8933
TEST_TIME 52 8932
TEST_TIME 53 9033
TEST_TIME 54 9074
TEST_TIME 55 9107
TEST_TIME 56 9133
TEST_TIME 57 9168
TEST_TIME 58 9238
TEST_TIME 59 9096
TEST_TIME 60 9066
TEST_TIME 61 9002
TEST_TIME 62 8967
TEST_TIME 63 9002
TEST_TIME 64 8986
TEST_TIME 65 8905
TEST_TIME 66 8938
TEST_TIME 67 8917
TEST_TIME 68 8962
TEST_TIME 69 8951
TEST_TIME 70 8987
TEST_TIME 71 9003
TEST_TIME 72 9070
TEST_TIME 73 9101
TEST_TIME 74 9158
TEST_TIME 75 9104
TEST_TIME 76 9149
TEST_TIME 77 9223
TEST_TIME 78 9168
TEST_TIME 79 9238
TEST_TIME 80 9240
TEST_TIME 81 9226
TEST_TIME 82 9118
TEST_TIME 83 9067
TEST_TIME 84 9079
TEST_TIME 85 9081
TEST_TIME 86 9048
TEST_TIME 87 8997
TEST_TIME 88 8983
TEST_TIME 89 8946
TEST_TIME 90 8877
TEST_TIME 91 8883
TEST_TIME 92 8914
TEST_TIME 93 8907
TEST_TIME 94 8953
TEST_TIME 95 8991
TEST_TIME 96 9010
TEST_TIME 97 8999
TEST_TIME 98 8965
TEST_TIME 99 9174
TEST_TIME 100 9168
TEST_TIME 101 9175
TEST_TIME 102 9188
TEST_TIME 103 9207
TEST_TIME 104 9250
TEST_TIME 105 9245
TEST_TIME 106 9209
TEST_TIME 107 9149
TEST_TIME 108 9139
TEST_TIME 109 9161
TEST_TIME 110 9095
TEST_TIME 111 9095
TEST_TIME 112 9092
TEST_TIME 113 9080
TEST_TIME 114 9056
TEST_TIME 115 9007
TEST_TIME 116 9008
TEST_TIME 117 9020
TEST_TIME 118 9019
TEST_TIME 119 8997
TEST_TIME 120 8979

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-03-2021 22:28:37 to 04-03-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 1488376 1488376 0 0.00 0 24914 6 0 0
doc_list_biud 1488375 1488375 0 0.00 0 22436 27 0 0
sp_add_invoice_to_stock 4937 4793 144 2.91 47 185593 18200 0 144
sp_cancel_adding_invoice 5558 5558 0 0.00 5 77847 782 0 0
sp_cancel_client_order 1724 1724 0 0.00 4 14115 402 0 0
sp_cancel_customer_reserve 549123 549123 0 0.00 1 22438 59 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 2 13551 101 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 4205 62 0 0
sp_cancel_supplier_invoice 6173 6163 10 0.16 2 15208 775 0 10
sp_cancel_supplier_order 397 397 0 0.00 7 1046850 102649 0 0
sp_cancel_write_off 8895 8895 0 0.00 1 10483 119 0 0
sp_client_order 19705 19705 0 0.00 3 24864 391 0 0
sp_customer_reserve 444929 444929 0 0.00 0 77590 179 0 0
sp_fill_shopping_cart 30452 30452 0 0.00 1 21913 43 0 0
sp_fill_shopping_cart_clo_res 444925 444925 0 0.00 0 12664 15 0 0
sp_get_clo_for_invoice 4788 4788 0 0.00 0 26145 363 0 0
sp_kill_cost_storno 15516 15516 0 0.00 0 17664 58 0 0
sp_kill_qstorno_ret_qs2qd 1113701 1113701 0 0.00 0 22432 32 0 0
sp_kill_qty_storno 586431 586431 0 0.00 0 22436 68 0 0
sp_lock_selected_doc 20147 20147 0 0.00 0 10519 6 0 0
sp_make_cost_storno 27273 27273 0 0.00 0 17453 58 0 0
sp_multiply_rows_for_pdistr 27273 27273 0 0.00 0 24447 29 0 0
sp_multiply_rows_for_qdistr 19705 19705 0 0.00 0 24851 190 0 0
sp_pay_from_customer 6937 6937 0 0.00 4 24919 127 0 0
sp_pay_to_supplier 5765 5765 0 0.00 5 17541 156 0 0
sp_payment_common 12702 12702 0 0.00 1 16969 33 0 0
sp_qd_handle_on_cancel_clo 1724 1724 0 0.00 0 14107 350 0 0
sp_qd_handle_on_invoice_upd_sts 10344 10344 0 0.00 0 17812 330 0 0
sp_qd_handle_on_reserve_upd_sts 9785 9785 0 0.00 0 16525 52 0 0
sp_reserve_write_off 9785 9785 0 0.00 6 17159 183 0 0
sp_supplier_invoice 5325 5325 0 0.00 6 76437 3735 0 0
sp_supplier_order 5423 5423 0 0.00 6 23244 1198 0 0
srv_aggregate_perf_data 106 105 1 0.94 3163 143767 16669 0 1
srv_fill_mon_cache_memory 148 148 0 0.00 913 176245 35745 0 0
srv_find_qd_qs_mism 1030522 1030522 0 0.00 0 20529 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 34 50749 1061 0 0
srv_make_money_saldo 791 791 0 0.00 1 10168 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 277859 612736 434215 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 4794 4794 0 0.00 0 11749 174 0 0
t$perf-norm:sp_cancel_adding_invoice 362 362 0 0.00 1 6906 138 0 0
t$perf-norm:sp_cancel_client_order 1724 1724 0 0.00 0 2607 14 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 2970 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 3617 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 540 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 371 371 0 0.00 0 693 11 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 21398 1485 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 3319 7 0 0
t$perf-norm:sp_client_order 19705 19705 0 0.00 0 19051 18 0 0
t$perf-norm:sp_customer_reserve 991 991 0 0.00 0 5423 18 0 0
t$perf-norm:sp_pay_from_customer 6937 6937 0 0.00 0 19265 15 0 0
t$perf-norm:sp_pay_to_supplier 5765 5765 0 0.00 0 7434 8 0 0
t$perf-norm:sp_reserve_write_off 9785 9785 0 0.00 0 7136 10 0 0
t$perf-norm:sp_supplier_invoice 5325 5325 0 0.00 0 6293 16 0 0
t$perf-norm:sp_supplier_order 5423 5423 0 0.00 0 3030 16 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 789 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 148 148 0 0.00 0 307 5 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 889 18 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 476 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9860 9572 288 2.92 0 7837 25 0 288
v_all_customers 36120 36120 0 0.00 0 12 1 0 0
v_all_suppliers 29756 29756 0 0.00 0 24 1 0 0
v_all_wares 39410 39410 0 0.00 0 12 1 0 0
v_cancel_adding_invoice 724 724 0 0.00 0 4936 23 0 0
v_cancel_client_order 3448 3448 0 0.00 0 12966 16 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 13373 17 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 11866 15 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 4190 11 0 0
v_cancel_supplier_invoice 762 742 20 2.62 0 5328 29 0 20
v_cancel_supplier_order 794 794 0 0.00 0 1940 6 0 0
v_cancel_write_off 2006 2006 0 0.00 0 8368 17 0 0
v_max_id_clo_ord 5423 5423 0 0.00 0 2234 2 0 0
v_max_id_clo_res 991 991 0 0.00 0 3448 15 0 0
v_max_id_ord_sup 5324 5324 0 0.00 0 2017 3 0 0
v_max_non_paid_invoice 1634 1634 0 0.00 0 2927 7 0 0
v_max_non_paid_realizn 3728 3728 0 0.00 0 3909 4 0 0
v_min_id_clo_ord 5423 5423 0 0.00 0 6872 18 0 0
v_min_id_clo_res 991 991 0 0.00 0 750 3 0 0
v_min_id_ord_sup 5324 5324 0 0.00 0 4909 7 0 0
v_min_non_paid_invoice 5765 5765 0 0.00 0 6579 22 0 0
v_min_non_paid_realizn 6937 6937 0 0.00 0 16963 24 0 0
v_our_firm 9708 9708 0 0.00 0 15 1 0 0
v_reserve_write_off 19570 19570 0 0.00 0 15069 10 0 0
x_lock_depdocs_on_canc_invoice 11350 11350 0 0.00 0 27412 119 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 12920 364 0 0
x_make_qstorno_1000_1200 5423 5423 0 0.00 2 23224 1106 0 0
x_make_qstorno_1200_2000 5325 5325 0 0.00 2 76420 3588 0 0
x_make_qstorno_2100_3300 444929 444929 0 0.00 0 77584 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-03-2021 22:28:41 to 04-03-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:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:30 17305 8192000000 10212414464 10518040576 962929296 10.518 76 53 106 0 983285824 2818112 17538416
19:58:01 29992 8192000000 10347544016 10661199872 1389631200 14.503 100 87 173 0 1422664464 4719952 28313312
19:58:42 21226 8192000000 10382672752 10706305024 1435843504 14.913 100 85 169 2 1469353648 6036320 27473824
19:59:14 29227 8192000000 10416307856 10742935552 1471113744 15.224 100 93 186 0 1508300736 7392256 29794736
19:59:51 29648 8192000000 10453038624 10787557376 1496818640 15.448 100 85 170 0 1531181968 7641568 26721760
20:00:30 15498 8192000000 10468462864 10806812672 1519422528 15.645 100 82 164 0 1553347456 8211280 25713648
20:01:07 15310 8192000000 10487012960 10829307904 1546270032 15.878 100 84 168 0 1581294384 9402480 25621872
20:01:33 26198 8192000000 10533071680 10879627264 1575703648 16.131 100 84 168 0 1610648320 9288800 25655872
20:02:11 15930 8192000000 10543384336 10900881408 1602736528 16.363 100 77 154 0 1636482240 10321280 23424432
20:02:37 11858 8192000000 10580421952 10940960768 1633222304 16.622 100 74 147 4 1666184832 10412880 22549648
20:03:02 10332 8192000000 10600716320 10965192704 1659030560 16.841 100 78 156 0 1693506992 11559040 22917392
20:03:23 13054 8192000000 10629877584 10994999296 1682615104 17.039 100 78 157 1 1717561168 12212432 22733632
20:03:44 10156 8192000000 10641031840 11007574016 1696239488 17.154 100 86 172 0 1733980160 13012000 24728672
20:04:04 9791 8192000000 10655557264 11024236544 1711896912 17.285 100 82 164 0 1748759680 13290784 23571984
20:04:24 8155 8192000000 10670643184 11047034880 1730791888 17.442 100 73 146 1 1764558624 13278256 20488480
20:04:42 6728 8192000000 10689114768 11064209408 1742981648 17.543 100 81 163 1 1779212320 13220048 23010624
20:04:56 7088 8192000000 10688803504 11067514880 1753475840 17.630 100 73 146 0 1787095424 12916112 20703472
20:05:11 5422 8192000000 10702237920 11082915840 1764104960 17.718 100 77 155 1 1798190784 12753552 21332272
20:05:26 5068 8192000000 10716459776 11098787840 1774041040 17.800 100 75 150 3 1807274768 12328160 20905568
20:05:38 4981 8192000000 10715636848 11100876800 1785997328 17.899 100 77 154 1 1820015008 12601152 21416528
20:05:50 3841 8192000000 10729489552 11109945344 1790671520 17.937 100 89 180 2 1829151696 13885680 24594496
20:06:01 7723 8192000000 10736097504 11118321664 1793181984 17.958 100 81 162 0 1829829520 14859952 21787584
20:06:16 4741 8192000000 10744715360 11125702656 1799314144 18.008 100 76 150 2 1834161040 14080992 20765904
20:06:27 2983 8192000000 10757902064 11141455872 1818961184 18.169 100 85 169 1 1856607552 14868544 22777824
20:06:37 2168 8192000000 10769164784 11149717504 1819508848 18.174 100 90 179 0 1860750432 16183488 25058096
20:06:45 2895 8192000000 10771036672 11154845696 1824427632 18.214 100 90 179 1 1865062096 15779552 24854912
20:06:55 3400 8192000000 10780632160 11163824128 1832422640 18.279 100 86 173 0 1872064672 15926240 23715792
20:07:05 2235 8192000000 10772020624 11161149440 1836014224 18.308 100 89 175 2 1875839504 15116096 24709184
20:07:14 2268 8192000000 10779687680 11166113792 1841399776 18.352 100 84 169 0 1877455840 12184752 23871312
20:07:23 1748 8192000000 10786191616 11172200448 1843189120 18.367 100 95 190 0 1883508944 12757536 27562288
20:07:31 1735 8192000000 10786315136 11176841216 1847493456 18.402 100 89 178 2 1884544528 11829072 25222000
20:07:39 2246 8192000000 10799001984 11188662272 1858913856 18.494 100 91 179 3 1895581104 11374400 25292848
20:07:47 1775 8192000000 10808187520 11195604992 1867932528 18.568 100 94 187 4 1906007072 11877984 26196560
20:07:55 2618 8192000000 10805980512 11200868352 1867088416 18.561 100 83 164 1 1903303232 12563520 23651296
20:08:05 4146 8192000000 10818696160 11205570560 1872138016 18.602 100 98 198 3 1914181616 13806416 28237184
20:08:16 2657 8192000000 10813712416 11210960896 1873177952 18.610 100 83 167 2 1911384912 14521632 23685328
20:08:25 2492 8192000000 10805790496 11206975488 1871300224 18.595 100 52 104 1 1896890896 10207360 15383312
20:08:34 4116 8192000000 10790446768 11209691136 1872407664 18.604 100 55 108 1 1897740976 10479040 14854272
20:08:45 40899 8192000000 10809446672 11210375168 1874250096 18.619 100 61 120 1 1900441504 7306768 18884640
20:09:32 9605 8192000000 10829537824 11221983232 1883540544 18.694 100 77 152 2 1915767680 9131392 23095744
20:09:48 9924 8192000000 10785193600 11213471744 1874054608 18.617 100 35 70 0 1893719760 9722064 9943088
20:10:06 6818 8192000000 10793776288 11215699968 1879447424 18.661 100 43 86 0 1899823088 7874368 12501296
20:10:19 5194 8192000000 10793201344 11218399232 1880315120 18.668 100 37 74 1 1899345120 8524608 10505392
20:10:37 6714 8192000000 10787970464 11216154624 1882042864 18.682 100 36 72 0 1899109632 7559216 9507552
20:10:50 5635 8192000000 10813227392 11229556736 1884856640 18.704 100 34 66 3 1901204416 7309776 9038000
20:11:02 7213 8192000000 10795209216 11224256512 1887176464 18.723 100 23 46 0 1900765648 6138928 7450256
20:11:17 9714 8192000000 10798779568 11227766784 1887970832 18.729 100 31 62 2 1904012912 6456032 9586048
20:11:36 5982 8192000000 10797917840 11227713536 1888125456 18.731 100 22 44 1 1900018224 6008384 5884384
20:11:49 9603 8192000000 10794974160 11228176384 1887724336 18.727 100 21 42 1 1899109888 5624736 5760816
20:12:08 9549 8192000000 10801193616 11230617600 1889286416 18.740 100 21 42 0 1901311616 6031792 5993408
20:12:23 11614 8192000000 10806389456 11237699584 1893646384 18.775 100 22 44 0 1906135152 6140704 6348064
20:12:42 10684 8192000000 10818140544 11246723072 1896499424 18.798 100 22 44 1 1912438256 9860160 6078672
20:12:59 7075 8192000000 10809405552 11240685568 1897060448 18.803 100 17 34 1 1907236768 5583040 4593280
20:13:16 21263 8192000000 10805870736 11240689664 1898986208 18.818 100 20 40 0 1909729376 5368880 5374288
20:13:44 53614 8192000000 10832556944 11259502592 1907433696 18.886 100 17 34 2 1918238544 5325936 5478912
20:14:55 23212 8192000000 10823187344 11260379136 1910933600 18.914 100 25 50 1 1924737920 6733344 7070976
20:15:26 5570 8192000000 10826178144 11257077760 1914847920 18.946 100 28 57 1 1928828224 5891408 8088896
20:15:38 4405 8192000000 10847207776 11272581120 1919095456 18.980 100 36 72 0 1935982096 7010656 9875984
20:15:49 5086 8192000000 10840812624 11273666560 1919381856 18.982 100 40 80 1 1939651280 8604480 11664944
20:16:03 4828 8192000000 10822499120 11258073088 1896474880 18.798 99 30 60 0 1912162864 7219264 8468720
20:16:20 6637 8192000000 10820091248 11255083008 1897654016 18.807 99 34 66 3 1913937808 5442352 10841440
20:16:36 5612 8192000000 10834187408 11264667648 1908552096 18.895 100 23 44 1 1919872304 5316352 6003856
20:16:50 6036 8192000000 10810164176 11241205760 1872132080 18.602 98 34 67 2 1891604608 10026720 9445808
20:17:03 13053 8192000000 10806128080 11246452736 1882726704 18.687 99 20 39 2 1894036160 5276640 6032816
20:17:24 7541 8192000000 10819176160 11249569792 1886907376 18.721 99 22 44 3 1904223856 9799376 7517104
20:17:40 12197 8192000000 10807602048 11241443328 1865223520 18.546 98 19 37 0 1876215872 5347728 5644624
20:18:02 14310 8192000000 10766928240 11200499712 1775961216 17.816 94 24 46 2 1789370576 6247296 7162064
20:18:24 12616 8192000000 10742527680 11166351360 1783527184 17.879 96 26 52 0 1799087728 5512320 10048224
20:19:15 19931 8192000000 10768049648 11158212608 1772433024 17.787 96 65 126 2 1796148272 4832672 18882576
20:19:41 7493 8192000000 10718839600 11152769024 1802975344 18.038 99 23 46 2 1815725024 6986400 5763280
20:19:56 7339 8192000000 10675483568 11085897728 1676938720 16.992 92 22 45 2 1688588768 5423776 6226272
20:20:12 7802 8192000000 10705947072 11111243776 1667785744 16.915 92 31 62 0 1682613296 6235312 8592240
20:20:28 8287 8192000000 10725481232 11138797568 1768974624 17.759 98 38 77 3 1787068240 7170048 10923568
20:20:45 5372 8192000000 10633382272 11038040064 1676631296 16.989 94 27 54 0 1690180448 5600080 7949072
20:20:57 4050 8192000000 10690840080 11099652096 1772230144 17.785 100 35 68 6 1788385504 6779440 9375920
20:21:08 5321 8192000000 10700069792 11109249024 1768140032 17.752 99 40 79 0 1788174128 8418144 11615952
20:21:19 11472 8192000000 10692859776 11104993280 1736631520 17.491 97 19 37 3 1747014064 5138608 5243936
20:21:39 4723 8192000000 10717519808 11131531264 1783082160 17.875 99 32 64 1 1799257136 5959744 10215232
20:21:53 7543 8192000000 10725463648 11140386816 1807364240 18.074 100 27 52 2 1820073184 5417984 7290960
20:22:06 8986 8192000000 10715486608 11132661760 1759325248 17.679 97 18 35 3 1769287024 5241744 4720032
20:22:21 8623 8192000000 10722429040 11140562944 1793793152 17.963 99 32 64 1 1810168016 6671456 9703408
20:22:38 10833 8192000000 10713378240 11141570560 1809576816 18.092 100 26 52 0 1823403568 5689616 8137136
20:22:55 7066 8192000000 10728830368 11153440768 1816686000 18.151 100 23 45 1 1829445440 5451776 7307664
20:23:09 12163 8192000000 10735166640 11159703552 1828314224 18.246 100 23 46 1 1841323232 5473760 7535248
20:23:28 54490 8192000000 10744494112 11165937664 1815247488 18.139 99 30 60 1 1829897472 5355104 9294880
20:24:34 12484 8192000000 10737860400 11168792576 1833243072 18.286 100 26 52 4 1847522592 6428784 7850736
20:24:54 6533 8192000000 10751972784 11175084032 1837644752 18.322 100 31 62 2 1852963808 7025232 8293824
20:25:09 8407 8192000000 10761828400 11179393024 1839099872 18.333 100 31 62 1 1854955456 6586640 9268944
20:25:24 5537 8192000000 10779182880 11194605568 1847497936 18.402 100 34 68 0 1864380832 6540912 10341984
20:25:38 10784 8192000000 10774508656 11196092416 1849850176 18.421 100 30 60 2 1867900368 9781328 8268864
20:25:58 8689 8192000000 10770382000 11196575744 1856765808 18.477 100 27 55 1 1870014048 5505696 7742544
20:26:13 7073 8192000000 10768218080 11202686976 1857853376 18.486 100 14 28 1 1867112416 5679008 3580032
20:26:29 10309 8192000000 10773367696 11212140544 1868687488 18.574 100 33 66 1 1888476896 9979536 9809872
20:26:46 10750 8192000000 10781413648 11216392192 1868316912 18.571 100 15 30 0 1878025072 5298720 4409440
20:27:02 15365 8192000000 10801813248 11232014336 1884206624 18.699 100 15 30 0 1893095520 4722320 4166576
20:27:25 45648 8192000000 10818288576 11242192896 1894144896 18.779 100 21 42 0 1905293680 5324128 5824656
20:28:21 20922 8192000000 10840524176 11264475136 1912224240 18.924 100 41 82 2 1932813312 8948672 11640400
20:28:52 13372 8192000000 10853403296 11271843840 1918836016 18.978 100 44 86 1 1941498400 10076688 12585696
20:29:16 36271 8192000000 10857307376 11283423232 1924238096 19.021 100 46 92 1 1948257568 11132880 12886592
20:30:01 78727 8192000000 10860900320 11294285824 1933932576 19.098 100 39 78 0 1958051296 12622352 11496368
20:31:58 36360 8192000000 10872173088 11306598400 1939419856 19.142 100 30 59 2 1959732688 11999472 8313360
20:33:00 5494 8192000000 10903736576 11327053824 1958218048 19.292 100 49 98 1 1986322448 13268688 14835712
20:33:14 3843 8192000000 10902997344 11331203072 1965487408 19.350 100 64 129 2 1999090272 14890272 18712592
20:33:26 3895 8192000000 10902853952 11333386240 1964997472 19.346 100 64 128 0 1999314560 15276032 19041056
20:33:39 10517 8192000000 10906326272 11334463488 1964585536 19.342 100 51 102 0 1995981520 15570480 15825504
20:34:00 22091 8192000000 10914294688 11341238272 1969674960 19.383 100 53 106 0 2003340048 17688112 15976976
20:34:30 12888 8192000000 10908321568 11345100800 1967438864 19.365 100 48 96 0 1997751104 16277296 14034944
20:34:50 22521 8192000000 10920829088 11353554944 1972401376 19.404 100 48 96 1 2003298208 16289728 14607104
20:35:25 5521 8192000000 10933671488 11364618240 1983940752 19.496 100 53 104 3 2017432160 17837792 15653616
20:35:40 21678 8192000000 10918936496 11351818240 1973308288 19.412 100 49 98 0 2008315904 19500336 15507280
20:36:11 9856 8192000000 10920036320 11362041856 1982722000 19.486 100 50 100 1 2020042704 20863408 16457296
20:36:35 13005 8192000000 10943173552 11374813184 1991101056 19.552 100 52 103 2 2028381952 20676224 16604672
20:37:00 4242 8192000000 10950330400 11374120960 1975138688 19.426 99 52 103 1 2013603312 21969600 16495024
20:37:11 6464 8192000000 10933158480 11367960576 1974153264 19.418 99 54 108 3 2010016960 19555504 16308192
20:37:25 17817 8192000000 10933732736 11364315136 1984470208 19.500 100 51 102 0 2020859376 20911936 15477232
20:38:00 7628 8192000000 10941805296 11372564480 1992442304 19.563 100 51 101 0 2028368384 20803232 15122848
20:38:16 8274 8192000000 10930954080 11362140160 1974768656 19.423 99 46 90 2 2009038928 20717088 13553184
20:38:40 2331 8192000000 10946005744 11369979904 1974815152 19.424 99 64 128 3 2015869120 22052176 19001792
20:38:49 4366 8192000000 10943551776 11360075776 1972732096 19.407 99 81 160 3 2019642624 23378544 23531984
20:39:01 5582 8192000000 10950661200 11363115008 1988362880 19.531 100 88 175 1 2037106416 22276176 26467360
20:39:13 10394 8192000000 10930207424 11357310976 1965090848 19.346 99 66 132 0 2007616912 22716416 19809648
20:39:32 8462 8192000000 10931085232 11363360768 1981259728 19.475 100 62 121 1 2021565296 22265872 18039696
20:39:47 8177 8192000000 10934816208 11357110272 1981394896 19.476 100 65 128 3 2021428832 20968816 19065120
20:40:07 4711 8192000000 10946064608 11373056000 1988476352 19.532 100 63 124 1 2032251664 24405200 19370112
20:40:23 11387 8192000000 10936458656 11360325632 1969679216 19.383 99 63 125 1 2012156304 23667520 18809568
20:40:46 7214 8192000000 10946344368 11377553408 1994043552 19.576 100 58 116 0 2033402896 21691616 17667728
20:41:03 12701 8192000000 10956038720 11388182528 2005726496 19.668 100 63 126 0 2051581360 27451152 18403712
20:41:28 4118 8192000000 10958786256 11382120448 1982722752 19.486 99 74 148 3 2032129968 27082944 22324272
20:41:40 7014 8192000000 10977420224 11400187904 2007402416 19.681 100 74 145 2 2059708960 29249760 23056784
20:41:56 6735 8192000000 10975897504 11400310784 2011256608 19.711 100 74 148 1 2063460512 29478432 22725472
20:42:10 6767 8192000000 10962327744 11389382656 2000306896 19.625 100 74 147 1 2050329872 28126784 21896192
20:42:30 4206 8192000000 10970950272 11386638336 1990021008 19.544 99 77 154 0 2043807056 30490400 23295648
20:42:40 2783 8192000000 10992344528 11408830464 2015859376 19.748 100 87 171 2 2075363632 33690944 25813312
20:42:50 5495 8192000000 10990609712 11409829888 2018484352 19.768 100 75 149 1 2075269584 34324848 22460384
20:43:06 2741 8192000000 11009522736 11426467840 2027473328 19.839 100 86 172 1 2089820160 36080208 26266624
20:43:17 3349 8192000000 10996017584 11421863936 2020767632 19.786 100 78 157 0 2080602512 36378192 23456688
20:43:28 5370 8192000000 10995902112 11418591232 2018031744 19.765 100 79 156 1 2079437376 36988640 24416992
20:43:40 3646 8192000000 10978092240 11392462848 1993018048 19.568 99 77 150 0 2052915248 37151264 22745936
20:43:52 2081 8192000000 11012783728 11424481280 2022235200 19.798 100 90 180 6 2088943136 39161280 27546656
20:44:02 5785 8192000000 11008878544 11426713600 2023279488 19.806 100 80 158 1 2087141408 38945696 24916224
20:44:14 6724 8192000000 10978911168 11403112448 1992106496 19.560 99 65 130 1 2049343040 36416288 20820256
20:44:30 2579 8192000000 10994293344 11415769088 2017037792 19.757 100 81 162 1 2081175024 38712848 25424384
20:44:40 1117 8192000000 10988162416 11405893632 2007985296 19.686 100 85 170 2 2073878816 39567440 26326080
20:44:49 5317 8192000000 10971597520 11388198912 1986922736 19.519 99 78 154 2 2052167712 40454816 24790160
20:45:02 6386 8192000000 10981816448 11397316608 1971410560 19.397 98 81 162 2 2037729312 40885536 25433216
20:45:15 3196 8192000000 10965725872 11377704960 1969797504 19.384 99 87 175 1 2039097312 42066560 27233248
20:45:26 3616 8192000000 10967595184 11388489728 1988154656 19.529 100 74 148 0 2053302752 42032640 23115456
20:45:43 911 8192000000 10988043984 11396337664 1993253232 19.569 100 94 189 0 2067316048 44694496 29368320
20:45:52 1843 8192000000 10985484080 11397283840 1997581616 19.604 100 86 170 1 2067726608 43191216 26953776
20:46:03 2160 8192000000 10988895136 11403911168 2002255216 19.641 100 90 180 1 2071493120 40928096 28309808
20:46:11 6907 8192000000 10982146848 11395801088 1996687344 19.597 100 67 133 0 2055947984 38871968 20388672
20:46:29 1419 8192000000 10980568208 11403304960 1995582240 19.588 100 79 155 1 2062776192 41960912 25233040
20:46:38 2715 8192000000 10979195984 11391053824 1989429280 19.539 100 80 160 0 2058292864 43147168 25716416
20:46:49 3780 8192000000 10970777568 11389267968 1974113952 19.418 99 76 151 0 2043472864 44620704 24738208
20:47:02 6133 8192000000 10978611280 11398111232 1989124080 19.537 100 77 154 0 2059519920 45855072 24540768
20:47:16 4578 8192000000 10980009056 11402350592 1990588912 19.548 100 72 144 1 2061521888 47378592 23554384
20:47:29 5125 8192000000 10972932944 11397935104 1989739696 19.542 100 68 136 2 2060931664 48818832 22373136
20:47:46 6183 8192000000 10971950832 11401428992 1987247760 19.522 100 58 115 1 2056501456 50489008 18764688
20:48:12 14620 8192000000 10944395600 11378417664 1962574240 19.326 99 40 80 1 2024151952 47784256 13793456
20:48:34 10852 8192000000 10943207328 11384606720 1965784352 19.352 100 35 70 0 2029082336 50752560 12545424
20:48:56 14276 8192000000 10936901472 11377512448 1961282336 19.316 100 38 76 1 2023736656 48919056 13535264
20:49:28 20448 8192000000 10904723648 11356282880 1932133152 19.084 99 28 56 3 1986377312 44502128 9742032
20:49:59 18426 8192000000 10913491424 11358072832 1926998128 19.043 99 26 52 2 1980261072 44776544 8486400
20:50:26 26414 8192000000 10893835568 11343089664 1916304448 18.957 99 29 58 0 1969562240 43538192 9719600
20:51:05 20869 8192000000 10888168416 11339792384 1927380656 19.046 100 29 59 2 1982828752 45906448 9541648
20:51:33 15524 8192000000 10880704416 11328671744 1896363632 18.797 99 31 62 3 1953805792 46803408 10638752
20:51:56 19510 8192000000 10878080528 11328598016 1892234944 18.764 99 23 46 2 1953200560 52629360 8336256
20:52:22 22337 8192000000 10871279744 11324985344 1872783664 18.607 98 16 32 1 1930236224 50912448 6540112
20:52:54 22601 8192000000 10861145760 11314237440 1899775584 18.824 100 29 58 1 1947332432 38459696 9097152
20:53:54 39833 8192000000 10833621744 11271593984 1878720448 18.655 99 16 29 2 1894050416 11523600 3806368
20:54:42 17195 8192000000 10861336432 11283935232 1903360064 18.853 100 45 90 2 1927283920 10348832 13575024
20:55:18 75362 8192000000 10824949600 11289026560 1899633424 18.823 100 10 20 0 1910665248 8369456 2662368
20:58:03 91303 8192000000 10848776368 11307765760 1898795936 18.817 99 12 22 0 1910986848 9617952 2572960
20:59:59 70475 8192000000 10852164752 11316555776 1913281840 18.933 99 16 31 1 1927170688 10071424 3817424
21:01:15 29196 8192000000 10858035008 11312332800 1925773168 19.033 99 17 34 0 1940330784 10014064 4543552
21:01:54 50819 8192000000 10860486544 11330625536 1940717536 19.152 100 10 20 0 1952483088 9375904 2389648
21:02:51 43998 8192000000 10869374288 11333943296 1936834032 19.121 99 7 13 1 1945434032 7187248 1412752
21:03:41 43207 8192000000 10877749280 11330961408 1931549680 19.079 99 11 22 0 1942581696 7865760 3166256
21:04:31 34784 8192000000 10867857536 11325874176 1946237984 19.197 100 29 56 0 1966123024 11129792 8755248
21:05:16 61791 8192000000 10859745440 11324133376 1928803488 19.057 99 14 28 1 1941429728 8706048 3920192
21:06:33 65667 8192000000 10878001408 11339624448 1954036944 19.259 100 30 60 2 1973670560 10652864 8980752
21:07:49 36706 8192000000 10908142224 11356618752 1968335968 19.372 100 28 56 1 1987931536 11913152 7682416
21:08:34 71185 8192000000 10884994816 11359985664 1948554560 19.215 99 14 28 1 1967761936 14918304 4289072
21:10:35 79620 8192000000 10861909328 11349536768 1940425520 19.150 99 22 43 2 1963832240 17362896 6043824
21:12:05 45014 8192000000 10876941088 11352854528 1958926336 19.298 100 8 16 0 1968202592 7068928 2207328
21:13:02 57490 8192000000 10885221552 11352633344 1938256880 19.133 99 16 32 0 1961020464 18550080 4213504
21:14:28 40640 8192000000 10884470080 11346833408 1961597968 19.319 100 30 59 0 1979069680 8807744 8663968
21:15:15 60643 8192000000 10890249760 11359502336 1966353152 19.357 100 13 26 0 1980516864 9923872 4239840
21:16:25 56094 8192000000 10883396208 11345391616 1897744864 18.808 96 19 37 1 1914752224 10710864 6296496
21:17:50 68292 8192000000 10896060112 11355004928 1922764432 19.009 98 23 46 1 1941809456 11862944 7182080
21:19:15 46105 8192000000 10900446096 11364216832 1965899296 19.353 100 22 43 1 1988742704 17024192 5819216
21:20:07 35941 8192000000 10907170480 11379597312 1973213376 19.411 100 26 52 1 2000272784 19438208 7621200
21:21:31 57225 8192000000 10904427232 11364712448 1941785600 19.161 98 11 22 1 1960986336 15724640 3476096
21:22:40 47459 8192000000 10905172176 11358920704 1940679536 19.152 98 33 66 0 1964283600 13666336 9937728
21:23:41 68658 8192000000 10892988224 11355025408 1895341184 18.789 96 24 48 2 1913163392 11474592 6347616
21:24:59 141589 8192000000 10913760320 11371446272 1952612240 19.247 99 26 52 0 1975792112 15981184 7198688
21:27:27 78387 8192000000 10935777760 11394342912 1980118640 19.466 99 43 86 3 2008316464 16322128 11875696
21:28:52 38772 8192000000 10929154720 11388628992 1980287712 19.467 99 32 64 1 2003694992 14805024 8602256
21:29:38 43783 8192000000 10918850672 11384614912 1973933712 19.417 99 24 48 1 1997793936 16948480 6911744
21:31:58 34895 8192000000 10907251024 11382259712 1941540832 19.159 97 11 22 1 1955661280 11399872 2720576
21:32:39 71412 8192000000 10869140528 11345436672 1907462272 18.886 96 15 30 0 1925165584 13191712 4511600
21:34:01 60920 8192000000 10872418256 11340267520 1888269808 18.732 96 10 20 0 1908026640 17606176 2150656
21:35:08 45318 8192000000 10865468944 11335622656 1911020464 18.915 98 11 20 2 1925783344 12154720 2608160
21:35:59 45742 8192000000 10864027984 11328962560 1870166464 18.586 95 23 44 2 1885787632 9550480 6070688
21:36:52 37582 8192000000 10902718880 11353866240 1883180512 18.691 96 27 53 0 1907699248 16262176 8256560
21:37:40 70887 8192000000 10887984064 11358392320 1933024352 19.091 99 8 17 0 1954989536 19485200 2479984
21:38:57 54938 8192000000 10899155536 11340394496 1883233760 18.691 96 30 60 0 1912757728 20330176 9193792
21:40:00 28042 8192000000 10881085120 11330486272 1889802496 18.744 97 38 74 3 1908649888 8907200 9940192
21:40:38 21598 8192000000 10866772032 11325923328 1918966416 18.979 99 35 71 1 1940571936 11958864 9646656
21:42:26 45792 8192000000 10874000256 11331964928 1929642992 19.064 99 18 36 2 1945690224 10986432 5060800
21:43:18 64787 8192000000 10886904704 11354374144 1932161344 19.084 99 19 38 1 1951689440 14078912 5449184
21:44:29 176245 8192000000 10883098176 11353833472 1781952688 17.866 91 12 24 0 1801287680 16314768 3020224
21:47:31 118580 8192000000 10853957040 11317043200 1834781312 18.298 94 21 41 2 1856067600 14778640 6507648
21:49:38 133513 8192000000 10858505488 11328618496 1904569344 18.863 98 28 55 2 1928867744 16225600 8072800
21:51:58 20482 8192000000 10868109936 11324948480 1905597936 18.871 99 10 18 1 1924500720 16444672 2458112
21:52:30 39375 8192000000 10863306352 11331796992 1931964320 19.083 99 23 47 3 1948271424 10579568 5727536
21:53:16 52989 8192000000 10864423584 11336945664 1925469968 19.031 99 10 20 0 1934014544 5993760 2550816
21:54:29 55708 8192000000 10856295408 11332943872 1944739936 19.185 100 17 33 1 1957563584 7850320 4973328
21:55:37 78620 8192000000 10871114432 11336761344 1925673136 19.032 98 21 42 0 1940104608 8336256 6095216
21:57:05 87851 8192000000 10879683984 11357233152 1939424880 19.142 99 11 20 1 1955059392 12197376 3437136
21:58:46 65619 8192000000 10905123968 11374714880 1967632864 19.367 100 18 36 1 1991143808 18763920 4747024
22:00:00 47987 8192000000 10904595456 11370541056 1953139312 19.251 99 18 36 2 1970091920 11640992 5311616
22:00:56 53279 8192000000 10911066816 11388907520 1962229264 19.324 99 12 24 0 1976326224 10610656 3486304
22:02:31 82276 8192000000 10903717408 11362754560 1892290864 18.764 95 18 36 0 1913170784 16081712 4798208
22:04:01 44551 8192000000 10927703760 11397238784 1969650720 19.383 99 24 48 1 1995869040 19454816 6763504
22:05:14 65487 8192000000 10933398080 11419111424 1996038384 19.591 100 20 40 0 2027944016 25981920 5923712
22:06:34 55704 8192000000 10921662592 11396079616 1939885376 19.146 97 20 40 0 1952786432 8107472 4793584
22:07:59 65529 8192000000 10904734784 11377266688 1945704672 19.192 98 32 64 0 1966199600 10631424 9863504
22:09:10 84402 8192000000 10924800544 11383582720 1943974192 19.178 98 26 52 1 1961354848 10411888 6968768
22:10:45 22111 8192000000 10932674976 11391500288 1967589536 19.366 99 37 74 1 1989097776 11589440 9918800
22:11:16 21662 8192000000 10923963552 11381473280 1964844096 19.345 99 39 79 3 1989795488 13742160 11209232
22:11:44 86409 8192000000 10927592672 11392978944 1962771088 19.328 99 24 48 1 1981030528 12180464 6078976
22:13:25 120082 8192000000 10904390560 11381739520 1972814720 19.408 99 28 56 0 1998915152 17531952 8568480
22:15:48 59432 8192000000 10906244576 11387760640 1951786512 19.241 98 22 44 1 1971784432 13979424 6018496
22:17:04 39297 8192000000 10895046880 11373817856 1926846048 19.042 97 16 32 1 1945807536 14024384 4937104
22:17:53 48063 8192000000 10871389024 11352694784 1945792768 19.193 99 10 20 2 1958530816 9834912 2903136
22:18:48 59965 8192000000 10867273456 11347902464 1918745648 18.977 98 15 30 0 1931675408 9027712 3902048
22:19:59 58432 8192000000 10864729952 11346513920 1918571392 18.975 98 12 25 0 1931558640 9187840 3799408
22:21:04 75816 8192000000 10880063680 11363553280 1938447072 19.134 99 7 14 0 1948149456 7695280 2007104
22:22:27 63239 8192000000 10872270848 11352444928 1933175600 19.092 98 19 39 0 1947569360 9202416 5191344
22:23:37 49174 8192000000 10880208256 11353993216 1908527648 18.895 97 14 28 0 1919715456 7595280 3592528
22:24:33 75706 8192000000 10886142736 11358044160 1940663408 19.152 99 19 38 1 1957276688 10921040 5692240
22:26:04 84237 8192000000 9626309200 9958719488 738213296 8.266 38 6 12 0 751403296 11790224 1399776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 04-03-2021 22:28:47 to 04-03-2021 22:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 144 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          237869
MON$OLDEST_ACTIVE               237870
MON$OLDEST_SNAPSHOT             237870
MON$NEXT_TRANSACTION            237870
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                       2008960
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:27: 
:28: mscs-test-161.budzdorov.ru    Thu Mar  4 22:27:36 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
--- end of diff output ---

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

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