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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-05 22:27:10
DTS_END                         2021-01-05 22:27:10.5320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(451:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59260
TRN_ID                          246898
ATT_ID                          709
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: 9284.99 18221 1114199
customer order: creation 177.46 342 21295
customer order: refuse 15.70 335 1884
order to supplier: creation 47.47 1324 5696
order to supplier: removal 3.66 79521 439
invoice (draft): creation 47.42 3510 5690
invoice (draft): removal 52.84 706 6341
invoice accept: apply 42.78 16646 5134
invoice accept: cancel 47.48 790 5697
customer reserve: creation 3882.45 167 465894
customer reserve: removal 4668.43 48 560212
realization accept: apply 86.33 187 10359
realization accept: cancel 77.74 103 9329
payment from customer: creation 61.68 110 7401
payment from customer: removal 5.68 74 681
payment to supplier: creation 51.45 132 6174
payment to supplier: removal 3.52 61 422
service: total inventory turnovers 4.93 906 591
service: total monetary turnovers 7.10 27 852
service: aggregate perf. data 0.87 15806 104
service: refresh index statistics 0.03 243623 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-01-2021 22:28:15 to 05-01-2021 22:28:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9004
TEST_TIME 2 6690
TEST_TIME 3 6438
TEST_TIME 4 5750
TEST_TIME 5 6075
TEST_TIME 6 5601
TEST_TIME 7 6190
TEST_TIME 8 6050
TEST_TIME 9 6369
TEST_TIME 10 6173
TEST_TIME 11 6349
TEST_TIME 12 6539
TEST_TIME 13 6820
TEST_TIME 14 7093
TEST_TIME 15 7486
TEST_TIME 16 7796
TEST_TIME 17 7981
TEST_TIME 18 7919
TEST_TIME 19 8426
TEST_TIME 20 8307
TEST_TIME 21 8671
TEST_TIME 22 8667
TEST_TIME 23 8689
TEST_TIME 24 8909
TEST_TIME 25 8808
TEST_TIME 26 8993
TEST_TIME 27 9323
TEST_TIME 28 9171
TEST_TIME 29 8980
TEST_TIME 30 9010
TEST_TIME 31 8981
TEST_TIME 32 9097
TEST_TIME 33 9291
TEST_TIME 34 9193
TEST_TIME 35 9227
TEST_TIME 36 9085
TEST_TIME 37 9158
TEST_TIME 38 9108
TEST_TIME 39 9033
TEST_TIME 40 9169
TEST_TIME 41 9243
TEST_TIME 42 9190
TEST_TIME 43 9157
TEST_TIME 44 9333
TEST_TIME 45 9353
TEST_TIME 46 9417
TEST_TIME 47 9479
TEST_TIME 48 9531
TEST_TIME 49 9387
TEST_TIME 50 9290
TEST_TIME 51 9214
TEST_TIME 52 9288
TEST_TIME 53 9284
TEST_TIME 54 9260
TEST_TIME 55 9280
TEST_TIME 56 9284
TEST_TIME 57 9260
TEST_TIME 58 9212
TEST_TIME 59 9119
TEST_TIME 60 9084
TEST_TIME 61 9039
TEST_TIME 62 9117
TEST_TIME 63 9112
TEST_TIME 64 9147
TEST_TIME 65 9126
TEST_TIME 66 9205
TEST_TIME 67 9178
TEST_TIME 68 9203
TEST_TIME 69 9268
TEST_TIME 70 9288
TEST_TIME 71 9369
TEST_TIME 72 9379
TEST_TIME 73 9387
TEST_TIME 74 9363
TEST_TIME 75 9436
TEST_TIME 76 9492
TEST_TIME 77 9434
TEST_TIME 78 9391
TEST_TIME 79 9334
TEST_TIME 80 9338
TEST_TIME 81 9352
TEST_TIME 82 9347
TEST_TIME 83 9284
TEST_TIME 84 9258
TEST_TIME 85 9241
TEST_TIME 86 9154
TEST_TIME 87 9115
TEST_TIME 88 9113
TEST_TIME 89 9175
TEST_TIME 90 9204
TEST_TIME 91 9228
TEST_TIME 92 9275
TEST_TIME 93 9278
TEST_TIME 94 9338
TEST_TIME 95 9300
TEST_TIME 96 9390
TEST_TIME 97 9397
TEST_TIME 98 9361
TEST_TIME 99 9410
TEST_TIME 100 9474
TEST_TIME 101 9449
TEST_TIME 102 9452
TEST_TIME 103 9493
TEST_TIME 104 9414
TEST_TIME 105 9424
TEST_TIME 106 9409
TEST_TIME 107 9393
TEST_TIME 108 9372
TEST_TIME 109 9416
TEST_TIME 110 9362
TEST_TIME 111 9355
TEST_TIME 112 9324
TEST_TIME 113 9275
TEST_TIME 114 9271
TEST_TIME 115 9268
TEST_TIME 116 9327
TEST_TIME 117 9294
TEST_TIME 118 9301
TEST_TIME 119 9346
TEST_TIME 120 9293

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-01-2021 22:28:18 to 05-01-2021 22:28:22.

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 1548269 1548269 0 0.00 0 25244 6 0 0
doc_list_biud 1548266 1548266 0 0.00 0 54705 23 0 0
sp_add_invoice_to_stock 5275 5134 141 2.67 51 161332 16646 0 141
sp_cancel_adding_invoice 5697 5697 0 0.00 4 73278 790 0 0
sp_cancel_client_order 1884 1884 0 0.00 4 9090 336 0 0
sp_cancel_customer_reserve 560212 560212 0 0.00 1 54711 49 0 0
sp_cancel_pay_from_customer 681 681 0 0.00 3 5446 74 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 2088 61 0 0
sp_cancel_supplier_invoice 6351 6341 10 0.15 2 20394 707 0 10
sp_cancel_supplier_order 439 439 0 0.00 10 690482 79522 0 0
sp_cancel_write_off 9329 9329 0 0.00 1 24691 104 0 0
sp_client_order 21295 21295 0 0.00 4 18595 342 0 0
sp_customer_reserve 465894 465894 0 0.00 0 160174 167 0 0
sp_fill_shopping_cart 32680 32680 0 0.00 1 18227 38 0 0
sp_fill_shopping_cart_clo_res 465883 465883 0 0.00 0 15615 13 0 0
sp_get_clo_for_invoice 5121 5121 0 0.00 0 40525 286 0 0
sp_kill_cost_storno 16129 16129 0 0.00 0 11352 52 0 0
sp_kill_qstorno_ret_qs2qd 1136533 1136533 0 0.00 0 54699 27 0 0
sp_kill_qty_storno 599382 599382 0 0.00 0 54703 59 0 0
sp_lock_selected_doc 21575 21575 0 0.00 0 7941 5 0 0
sp_make_cost_storno 29055 29055 0 0.00 0 14563 53 0 0
sp_multiply_rows_for_pdistr 29055 29055 0 0.00 0 11498 32 0 0
sp_multiply_rows_for_qdistr 21295 21295 0 0.00 0 14906 143 0 0
sp_pay_from_customer 7401 7401 0 0.00 4 11515 110 0 0
sp_pay_to_supplier 6174 6174 0 0.00 5 11283 132 0 0
sp_payment_common 13575 13575 0 0.00 1 6986 26 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 9085 311 0 0
sp_qd_handle_on_invoice_upd_sts 10818 10818 0 0.00 0 19023 293 0 0
sp_qd_handle_on_reserve_upd_sts 10359 10359 0 0.00 0 21965 65 0 0
sp_reserve_write_off 10359 10359 0 0.00 6 21984 188 0 0
sp_supplier_invoice 5690 5690 0 0.00 7 83226 3511 0 0
sp_supplier_order 5696 5696 0 0.00 5 28637 1325 0 0
srv_aggregate_perf_data 105 104 1 0.95 3244 110759 15807 0 1
srv_fill_mon_cache_memory 150 150 0 0.00 953 158859 34902 0 0
srv_find_qd_qs_mism 1066488 1066488 0 0.00 0 25235 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 36 20045 907 0 0
srv_make_money_saldo 852 852 0 0.00 0 7900 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 148665 362765 243624 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 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 5134 5134 0 0.00 0 17112 158 0 0
t$perf-norm:sp_cancel_adding_invoice 452 452 0 0.00 1 1707 75 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 5512 13 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 4315 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 681 681 0 0.00 0 802 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 686 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 1183 21 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 25456 1645 0 0
t$perf-norm:sp_cancel_write_off 1060 1060 0 0.00 0 992 4 0 0
t$perf-norm:sp_client_order 21295 21295 0 0.00 0 10654 16 0 0
t$perf-norm:sp_customer_reserve 1018 1018 0 0.00 0 2115 6 0 0
t$perf-norm:sp_pay_from_customer 7401 7401 0 0.00 0 3477 9 0 0
t$perf-norm:sp_pay_to_supplier 6174 6174 0 0.00 0 12618 15 0 0
t$perf-norm:sp_reserve_write_off 10359 10359 0 0.00 0 12347 14 0 0
t$perf-norm:sp_supplier_invoice 5690 5690 0 0.00 0 6182 18 0 0
t$perf-norm:sp_supplier_order 5696 5696 0 0.00 0 9710 19 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 312 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 1442 13 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 2322 19 0 0
t$perf-norm:srv_make_money_saldo 852 852 0 0.00 0 2589 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 10 6 0 0
v_add_invoice_to_stock 10524 10242 282 2.67 0 5237 18 0 282
v_all_customers 38848 38848 0 0.00 0 16 1 0 0
v_all_suppliers 31608 31608 0 0.00 0 21 1 0 0
v_all_wares 42590 42590 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 904 904 0 0.00 0 1329 7 0 0
v_cancel_client_order 3768 3768 0 0.00 0 4788 5 0 0
v_cancel_customer_prepayment 1362 1362 0 0.00 0 5439 11 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 1788 5 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 1937 4 0 0
v_cancel_supplier_invoice 866 846 20 2.30 0 4057 23 0 20
v_cancel_supplier_order 878 878 0 0.00 0 459 3 0 0
v_cancel_write_off 2120 2120 0 0.00 0 4059 19 0 0
v_max_id_clo_ord 5696 5696 0 0.00 0 320 1 0 0
v_max_id_clo_res 1018 1018 0 0.00 0 2803 14 0 0
v_max_id_ord_sup 5689 5689 0 0.00 0 9210 5 0 0
v_max_non_paid_invoice 1755 1755 0 0.00 0 964 3 0 0
v_max_non_paid_realizn 3964 3964 0 0.00 0 1563 3 0 0
v_min_id_clo_ord 5696 5696 0 0.00 0 9510 10 0 0
v_min_id_clo_res 1018 1018 0 0.00 0 8383 21 0 0
v_min_id_ord_sup 5689 5689 0 0.00 0 4977 7 0 0
v_min_non_paid_invoice 6174 6174 0 0.00 0 6899 20 0 0
v_min_non_paid_realizn 7401 7401 0 0.00 0 6072 17 0 0
v_our_firm 10616 10616 0 0.00 0 14 1 0 0
v_reserve_write_off 20718 20718 0 0.00 0 3964 7 0 0
x_lock_depdocs_on_canc_invoice 11615 11615 0 0.00 0 15297 103 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 6570 299 0 0
x_make_qstorno_1000_1200 5696 5696 0 0.00 1 28633 1247 0 0
x_make_qstorno_1200_2000 5690 5690 0 0.00 3 83216 3373 0 0
x_make_qstorno_2100_3300 465894 465894 0 0.00 0 160174 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-01-2021 22:28:23 to 05-01-2021 22:28:27.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:20 28748 8192000000 10301014480 10619437056 1100390784 11.841 84 65 130 0 1124283488 3030320 20862384
19:57:57 28568 8192000000 10365548544 10686300160 1415844672 14.736 100 82 164 0 1447272832 5573056 25855104
19:58:37 17137 8192000000 10404612768 10728353792 1449091664 15.030 100 89 178 1 1485059152 7171504 28795984
19:59:11 11781 8192000000 10413668784 10741506048 1462938480 15.152 100 86 172 0 1499468784 8526208 28004096
19:59:33 22856 8192000000 10429305776 10758766592 1482950672 15.327 100 91 182 1 1521418336 9063376 29404288
20:00:03 17203 8192000000 10446362864 10778341376 1497194176 15.452 100 92 183 0 1536135376 9468080 29473120
20:00:31 16893 8192000000 10456665696 10792484864 1511922720 15.580 100 92 184 2 1551978384 10288256 29767408
20:01:00 17134 8192000000 10466020064 10808401920 1520220192 15.652 100 84 168 0 1557877632 10670016 26987424
20:01:25 17599 8192000000 10488443632 10837749760 1546484160 15.880 100 86 172 1 1584672720 10999712 27188848
20:01:55 16609 8192000000 10496766000 10852315136 1557919728 15.978 100 75 150 0 1592348256 11031232 23397296
20:02:21 10208 8192000000 10523431424 10879266816 1587423312 16.232 100 79 158 2 1622433920 10821568 24189040
20:02:41 14636 8192000000 10564576688 10923511808 1618471568 16.497 100 81 163 1 1654749872 11101680 25176624
20:03:04 8925 8192000000 10586094576 10948530176 1641224560 16.690 100 84 168 0 1679460368 12584224 25651584
20:03:21 12243 8192000000 10600829600 10963279872 1657699728 16.829 100 83 167 1 1696074064 13088192 25286144
20:03:41 9588 8192000000 10615445312 10980724736 1671444544 16.945 100 83 167 1 1709425184 12934160 25046480
20:03:58 8863 8192000000 10641103248 11008409600 1691535632 17.114 100 85 168 1 1729846800 13364896 24946272
20:04:14 6761 8192000000 10644699328 11017846784 1702595264 17.207 100 81 162 2 1739049184 13278832 23175088
20:04:28 6518 8192000000 10657466048 11028504576 1718921040 17.343 100 82 163 1 1759744656 18151072 22672544
20:04:42 5943 8192000000 10669045568 11039952896 1728344272 17.422 100 84 168 0 1766024224 14173040 23506912
20:04:55 5399 8192000000 10675308528 11051237376 1736921216 17.493 100 84 166 0 1774185136 13627920 23636000
20:05:07 3959 8192000000 10693486400 11067273216 1746343184 17.571 100 89 179 0 1785306560 14134736 24828640
20:05:17 4338 8192000000 10693939056 11071778816 1755345936 17.646 100 75 150 4 1789442160 13536944 20559280
20:05:28 3921 8192000000 10695731712 11076984832 1760061568 17.685 100 79 157 1 1796579408 14152496 22365344
20:05:39 2745 8192000000 10706377104 11084214272 1771262240 17.777 100 88 172 0 1808550384 13625360 23662784
20:05:49 3806 8192000000 10720645376 11104604160 1782675600 17.872 100 87 174 1 1820967872 13864816 24427456
20:06:00 2975 8192000000 10726573040 11108777984 1788964160 17.923 100 83 166 0 1825629872 13756704 22909008
20:06:09 10673 8192000000 10735304704 11126530048 1799346704 18.009 100 85 168 1 1836007248 13770656 22889888
20:06:26 2602 8192000000 10742988144 11124080640 1803116512 18.039 100 89 178 1 1840716544 13181408 24418624
20:06:35 3622 8192000000 10765304448 11143700480 1808659376 18.085 100 86 172 3 1845520928 12793696 24067856
20:06:45 1727 8192000000 10765497776 11150479360 1823599872 18.207 100 92 183 0 1863358720 14272976 25485872
20:06:54 2346 8192000000 10777102560 11162894336 1832780912 18.282 100 93 187 1 1874476096 15418336 26276848
20:07:03 1876 8192000000 10790214208 11176398848 1847237184 18.400 100 96 193 3 1890677056 16220368 27219504
20:07:11 1929 8192000000 10789586320 11179405312 1851247328 18.432 100 91 182 0 1891256160 13827632 26181200
20:07:20 1166 8192000000 10797639184 11184508928 1854825552 18.461 100 93 187 1 1892470064 11870096 25774416
20:07:27 1670 8192000000 10800153536 11189239808 1860473808 18.507 100 96 190 0 1897982272 11447952 26060512
20:07:35 2388 8192000000 10805235296 11198234624 1868080384 18.569 100 91 184 0 1906422000 12683696 25657920
20:07:44 1653 8192000000 10814872368 11204845568 1868594560 18.573 100 85 171 2 1904826864 12601904 23630400
20:07:52 1678 8192000000 10819863728 11209728000 1874598976 18.621 100 89 179 1 1912418352 12222512 25596864
20:08:01 5262 8192000000 10807531104 11211517952 1873610512 18.613 100 66 134 1 1903851344 11906272 18334560
20:08:23 1570 8192000000 10824591936 11217829888 1884991280 18.705 100 93 186 3 1924867520 13771072 26105168
20:08:30 33651 8192000000 10788699872 11207192576 1872444864 18.604 100 37 75 0 1892179712 9761744 9973104
20:09:10 23907 8192000000 10778685008 11211857920 1876486976 18.637 100 27 54 0 1891115584 6661376 7967232
20:09:46 5198 8192000000 10796430592 11213410304 1884437152 18.701 100 27 54 1 1898018176 5674496 7906528
20:09:58 6434 8192000000 10796332960 11224043520 1886953168 18.721 100 23 46 1 1900308080 6750464 6604448
20:10:16 5270 8192000000 10791332512 11225923584 1889607904 18.743 100 27 53 5 1903535232 6024336 7902992
20:10:27 12698 8192000000 10807624208 11232690176 1890505344 18.750 100 31 60 1 1906500672 7170288 8825040
20:10:47 7702 8192000000 10802518544 11232661504 1890597504 18.751 100 17 33 1 1900716416 5624560 4494352
20:11:03 3142 8192000000 10807032608 11236851712 1897683280 18.808 100 43 85 1 1917548912 7339792 12525840
20:11:13 7107 8192000000 10801618352 11233730560 1895427840 18.790 100 27 54 1 1909344480 6642384 7274256
20:11:27 11600 8192000000 10806193168 11239272448 1897140464 18.803 100 27 52 0 1911803232 7403696 7259072
20:11:48 10102 8192000000 10802133920 11238567936 1896366304 18.797 100 15 31 0 1906327456 6049984 3911168
20:12:04 9696 8192000000 10814482400 11240120320 1900698880 18.832 100 23 44 0 1913730816 6136048 6895888
20:12:20 11310 8192000000 10811365744 11245395968 1901756080 18.840 100 26 52 0 1916495488 6498160 8241248
20:12:41 12257 8192000000 10806599152 11247292416 1903133664 18.851 100 12 23 2 1912129680 5370336 3625680
20:12:59 11399 8192000000 10812287680 11250368512 1906292784 18.877 100 15 30 0 1915888640 5638048 3957808
20:13:17 53917 8192000000 10826500080 11261964288 1910878240 18.914 100 40 79 1 1927460608 5136096 11446272
20:14:28 21055 8192000000 10836955120 11269734400 1911194800 18.916 100 18 36 0 1922358288 6029472 5134016
20:14:55 3309 8192000000 10819335216 11264851968 1913393120 18.934 100 20 38 1 1925305824 6763328 5149376
20:15:04 4292 8192000000 10833697408 11264745472 1910683632 18.912 100 34 68 2 1926754224 6725264 9345328
20:15:17 5509 8192000000 10828449536 11265036288 1910005776 18.907 100 27 54 1 1923828560 6575440 7247344
20:15:28 4788 8192000000 10832498992 11268243456 1913764544 18.937 100 32 64 2 1929877232 6672112 9440576
20:15:42 4428 8192000000 10824943408 11260260352 1894736112 18.784 99 26 51 2 1908901088 6805728 7359248
20:15:56 7780 8192000000 10829069520 11251671040 1899283728 18.821 100 25 48 1 1912138928 5633552 7221648
20:16:11 7676 8192000000 10805593344 11248656384 1899188480 18.820 100 32 64 0 1915206256 6848144 9169632
20:16:25 7712 8192000000 10798157584 11227856896 1826237856 18.229 96 25 50 1 1839442384 5313360 7891168
20:16:39 9498 8192000000 10794455248 11227635712 1857492944 18.483 99 18 36 2 1868623216 5638544 5491728
20:16:58 11480 8192000000 10792322624 11222835200 1831924352 18.275 97 24 48 0 1844434384 5698080 6811952
20:17:16 6867 8192000000 10776049312 11202002944 1826890960 18.234 98 25 50 0 1844135328 10410400 6833968
20:17:30 11081 8192000000 10761424240 11196465152 1836034384 18.309 99 30 60 2 1851667504 6540720 9092400
20:17:47 21013 8192000000 10762807888 11197464576 1796823024 17.988 96 12 24 1 1805566640 5537168 3206448
20:18:14 31938 8192000000 10663210480 11080568832 1637580752 16.659 88 22 43 3 1649273648 4600720 7092176
20:19:21 19053 8192000000 10708830704 11132362752 1719008288 17.344 95 28 56 0 1732103856 4693568 8402000
20:19:48 11936 8192000000 10737749904 11141734400 1750837552 17.609 96 33 66 1 1766944992 6665264 9442176
20:20:07 5174 8192000000 10730686880 11135406080 1777021664 17.825 98 50 98 1 1800890544 9880400 13988480
20:20:19 4196 8192000000 10736829680 11154329600 1814827120 18.135 100 36 72 2 1833505968 8698064 9980784
20:20:30 4354 8192000000 10721738816 11128553472 1744200176 17.553 96 27 52 2 1762238608 11081296 6957136
20:20:42 4808 8192000000 10708359072 11118092288 1774579776 17.805 99 37 75 1 1791427376 6304816 10542784
20:20:55 5274 8192000000 10668162880 11072327680 1694012096 17.135 94 41 82 0 1713995696 7366896 12616704
20:21:06 8688 8192000000 10695750416 11118718976 1768025072 17.751 99 22 42 3 1784024048 9935968 6063008
20:21:22 6949 8192000000 10701477072 11109552128 1746584800 17.573 98 20 38 2 1757527888 5533728 5409360
20:21:37 6737 8192000000 10708462480 11127939072 1795475632 17.977 100 31 63 1 1811539312 6618352 9445328
20:21:53 10229 8192000000 10728543360 11145314304 1794232464 17.967 99 23 46 0 1807010384 5814992 6962928
20:22:09 7758 8192000000 10740130768 11160694784 1801263296 18.024 99 20 40 1 1813004672 5080128 6661248
20:22:23 11651 8192000000 10744774544 11161063424 1807971728 18.079 99 28 55 0 1822203440 5679472 8552240
20:22:42 7371 8192000000 10755311584 11169771520 1834672656 18.297 100 32 64 0 1850155680 5842208 9640816
20:23:01 56034 8192000000 10765280304 11174625280 1818391248 18.165 99 32 62 2 1837558992 9225744 9942000
20:24:05 23434 8192000000 10745062704 11174821888 1831928752 18.275 100 15 30 1 1841570976 5494528 4147696
20:24:39 7756 8192000000 10774512608 11192860672 1846955504 18.397 100 36 72 0 1864860304 8096864 9807936
20:24:53 5843 8192000000 10767328320 11188342784 1846538928 18.394 100 27 54 1 1861073088 7000512 7533648
20:25:06 7523 8192000000 10776992816 11190607872 1847101152 18.399 100 24 48 3 1859524352 6119936 6303264
20:25:19 5490 8192000000 10762179104 11191173120 1851833184 18.437 100 25 50 0 1865411232 5865088 7712960
20:25:31 5335 8192000000 10777137632 11200073728 1858093008 18.488 100 33 66 2 1874857472 7592400 9172064
20:25:43 8633 8192000000 10784670896 11203895296 1857801168 18.485 100 23 46 3 1870592240 5285552 7505520
20:25:58 5189 8192000000 10781044336 11208454144 1865899600 18.551 100 19 37 2 1875596544 4733984 4962960
20:26:10 16726 8192000000 10780215776 11213443072 1868157328 18.569 100 14 28 2 1877179376 4957088 4064960
20:26:33 12319 8192000000 10789140976 11218354176 1873270240 18.611 100 19 37 0 1884453648 5483680 5699728
20:26:52 13962 8192000000 10805739008 11227467776 1876734560 18.639 100 19 38 1 1888230800 5186976 6309264
20:27:16 3656 8192000000 10830536096 11250565120 1904079776 18.859 100 37 74 1 1919968352 5218784 10669792
20:27:46 4318 8192000000 10847440128 11265466368 1913491856 18.935 100 42 83 3 1935847632 11074144 11281632
20:27:58 6618 8192000000 10857849904 11274092544 1922421200 19.006 100 50 99 0 1945468256 8241680 14805376
20:28:13 89293 8192000000 10867259264 11294052352 1928124688 19.052 100 42 84 0 1947606768 7161280 12320800
20:30:03 29733 8192000000 10870955024 11303378944 1924630512 19.024 99 43 86 1 1949902752 12856608 12415632
20:30:43 15373 8192000000 10886111072 11311181824 1952409344 19.246 100 46 92 1 1975422848 9833504 13180000
20:31:07 10738 8192000000 10882503520 11307499520 1938554976 19.135 99 48 96 0 1962523248 10460736 13507536
20:31:26 27109 8192000000 10880594704 11309998080 1951858224 19.241 100 47 94 1 1976538416 10709648 13970544
20:32:15 13135 8192000000 10897075440 11327676416 1963284320 19.332 100 41 82 0 1986850992 11152160 12414512
20:32:48 4378 8192000000 10888938480 11317460992 1944767520 19.185 99 54 107 2 1970398032 10614640 15015872
20:33:01 2676 8192000000 10915563136 11330433024 1968073360 19.370 100 77 154 2 2001457536 11952272 21431904
20:33:24 15226 8192000000 10915252800 11335249920 1969959920 19.385 100 63 125 0 2002099584 13949840 18189824
20:33:57 13249 8192000000 10915261904 11340398592 1966905360 19.361 100 49 98 1 1997040352 15426608 14708384
20:34:23 20444 8192000000 10907091296 11343716352 1973191168 19.411 100 54 108 2 2004671584 15018592 16461824
20:34:57 6379 8192000000 10915565648 11346464768 1977117728 19.442 100 52 104 0 2006525648 13825136 15582784
20:35:14 7787 8192000000 10924800048 11353223168 1982583120 19.485 100 49 98 0 2012002224 15038864 14380240
20:35:44 8991 8192000000 10916832816 11351220224 1982045856 19.481 100 49 97 0 2012612896 15782784 14784256
20:36:01 9396 8192000000 10922907632 11356307456 1984935504 19.504 100 54 108 1 2017672992 16274624 16462864
20:36:18 10912 8192000000 10926449280 11356905472 1973037360 19.410 99 51 102 2 2002514480 14137728 15339392
20:36:38 7794 8192000000 10939500944 11364573184 1992509552 19.564 100 62 120 3 2026965936 15849104 18607280
20:36:58 18657 8192000000 10934182128 11368955904 1991226384 19.553 100 51 102 1 2023014704 15962736 15825584
20:37:27 19755 8192000000 10919164400 11355283456 1947475120 19.206 98 38 76 0 1975207904 15848704 11884080
20:37:58 13947 8192000000 10913171024 11352936448 1965349760 19.349 99 50 100 1 2002952304 21794400 15808144
20:38:20 7357 8192000000 10932376000 11358212096 1980392176 19.468 100 49 98 0 2011207392 15298384 15516832
20:38:41 6311 8192000000 10938953680 11367706624 1989162304 19.537 100 54 106 2 2023023872 17035344 16826224
20:38:54 3814 8192000000 10960676928 11379617792 1998812160 19.613 100 77 152 0 2041121456 18619344 23689952
20:39:08 9387 8192000000 10937717456 11368681472 1992148496 19.561 100 67 133 2 2031876592 19284416 20443680
20:39:24 11439 8192000000 10935733056 11362467840 1974370768 19.420 99 58 116 1 2012704608 19559696 18774144
20:39:47 6155 8192000000 10916812496 11339866112 1961371408 19.317 100 51 101 0 1998293664 20921648 16000608
20:40:00 11003 8192000000 10916573904 11338559488 1962657648 19.327 100 61 119 1 2001858320 20749104 18451568
20:40:19 4062 8192000000 10926418912 11355156480 1970376816 19.388 100 64 128 2 2010895872 20271200 20247856
20:40:39 28171 8192000000 10912769040 11359031296 1968782592 19.376 100 45 90 0 2004474320 21321056 14370672
20:41:15 28299 8192000000 10907564496 11355279360 1969054336 19.378 100 34 68 1 1997218688 16788512 11375840
20:41:53 10297 8192000000 10917489872 11351203840 1955271600 19.268 99 43 86 1 1985626592 17133984 13221008
20:42:10 2468 8192000000 10936542368 11364319232 1980899216 19.472 100 68 136 2 2020357664 19001664 20456784
20:42:19 4365 8192000000 10912181808 11335168000 1949119696 19.219 99 67 132 0 1986634928 17925360 19589872
20:42:36 1364 8192000000 10933329296 11348500480 1972223104 19.403 100 94 185 0 2019395856 19340224 27832528
20:42:44 2465 8192000000 10935288064 11357646848 1977404512 19.444 100 74 149 1 2019516320 20717424 21394384
20:42:53 953 8192000000 10931412416 11342503936 1966791520 19.360 99 91 180 0 2014263600 21376800 26095280
20:43:01 3487 8192000000 10931604496 11355664384 1971358160 19.396 100 68 136 1 2014157520 22413472 20385888
20:43:21 6784 8192000000 10912115328 11351818240 1969903536 19.385 100 43 84 1 1999130400 16469184 12757680
20:43:36 6212 8192000000 10926966384 11360313344 1976993744 19.441 100 48 96 1 2008820128 16246144 15580240
20:43:50 6658 8192000000 10876691296 11306614784 1920791088 18.993 97 49 97 2 1952080016 16846400 14442528
20:44:17 2826 8192000000 10908752576 11337441280 1956572304 19.279 99 60 120 0 1994074608 18842672 18659632
20:44:27 1932 8192000000 10922466848 11347169280 1966312928 19.356 100 66 134 0 2003292624 16875328 20104368
20:44:38 3540 8192000000 10925120912 11353399296 1973320656 19.412 100 69 138 1 2013014864 17619568 22074640
20:44:59 10990 8192000000 10886657328 11328405504 1945093376 19.187 100 34 68 1 1974973664 18938048 10942240
20:45:17 9039 8192000000 10901202944 11333947392 1936681888 19.120 99 48 96 0 1976431232 25524288 14225056
20:45:37 8305 8192000000 10903426912 11327467520 1936687040 19.120 100 52 104 1 1974674768 22190608 15797120
20:45:52 3304 8192000000 10908992800 11328045056 1939794144 19.145 100 72 144 0 1987375936 25562848 22018944
20:46:03 2682 8192000000 10899266000 11314180096 1919474560 18.983 99 86 172 2 1972945616 26183184 27287872
20:46:13 3162 8192000000 10890140560 11302731776 1911216944 18.916 99 76 154 0 1960879616 26007728 23654944
20:46:24 7227 8192000000 10861566048 11290857472 1910473888 18.910 100 53 106 2 1947721696 20776992 16470816
20:46:39 8385 8192000000 10861253712 11289006080 1905143056 18.868 100 37 74 1 1936600016 19425024 12031936
20:47:02 5199 8192000000 10878033488 11299483648 1920561248 18.991 100 53 106 0 1956584320 19946224 16076848
20:47:16 2807 8192000000 10858826032 11270037504 1897274544 18.804 99 72 144 3 1939874160 20784848 21814768
20:47:29 3348 8192000000 10874355024 11297746944 1916006880 18.955 100 61 121 1 1956749728 22255488 18487360
20:47:42 2751 8192000000 10867891936 11277639680 1894235888 18.780 99 64 127 0 1936013312 22800736 18976688
20:47:53 3174 8192000000 10895284080 11317694464 1932697776 19.088 100 68 136 1 1978010288 25115936 20196576
20:48:03 5701 8192000000 10876815792 11305852928 1911682080 18.920 99 58 117 2 1953995200 24275120 18038000
20:48:20 11572 8192000000 10864166688 11303219200 1902407536 18.846 99 30 60 1 1933748064 22085824 9254704
20:48:44 9794 8192000000 10875577168 11306151936 1925024832 19.027 100 33 66 0 1954847120 19105088 10717200
20:49:10 2030 8192000000 10884770208 11305738240 1926549280 19.039 100 63 122 3 1964260656 19018256 18693120
20:49:22 5593 8192000000 10872322816 11306885120 1915197056 18.948 99 41 82 2 1949208224 21247136 12764032
20:49:33 5215 8192000000 10864492688 11289030656 1898903232 18.817 98 57 115 0 1937372608 20727776 17741600
20:49:49 3358 8192000000 10886615360 11305758720 1913625104 18.936 99 65 129 4 1954036912 20980800 19431008
20:50:00 11957 8192000000 10848321104 11297382400 1906610352 18.879 99 31 62 0 1938458944 21750848 10097744
20:50:35 18560 8192000000 10879540464 11321896960 1929007168 19.059 100 29 58 1 1964383040 25548000 9827872
20:51:08 25009 8192000000 10888366304 11332485120 1935964816 19.115 100 27 54 2 1973867040 28495888 9406336
20:51:47 35506 8192000000 10882781040 11329675264 1931191504 19.076 100 19 38 2 1962099904 24376320 6532080
20:52:33 30320 8192000000 10887966320 11335131136 1936257360 19.117 100 31 62 0 1974066928 27975440 9834128
20:53:35 10112 8192000000 10853839856 11300290560 1901409680 18.838 99 20 39 0 1932996240 25494880 6091680
20:54:12 5035 8192000000 10861669088 11310571520 1914628768 18.944 100 41 80 1 1953983104 26269360 13084976
20:54:23 22142 8192000000 10838267376 11301142528 1891805280 18.760 99 21 42 0 1923881824 25553024 6523520
20:54:58 24572 8192000000 10837200912 11264495616 1859504736 18.499 98 23 45 0 1882701744 16718368 6478640
20:55:31 10412 8192000000 10833878560 11278413824 1902343168 18.845 100 40 81 1 1933040704 17879136 12818400
20:55:53 75521 8192000000 10823151536 11258281984 1810765840 18.102 95 24 48 2 1838706384 20012992 7927552
20:57:15 25949 8192000000 10840850912 11285630976 1895240576 18.788 100 20 40 1 1924992864 23887840 5864448
20:57:47 37772 8192000000 10842597424 11283525632 1887787184 18.728 99 26 52 1 1915002032 19786384 7428464
20:58:37 21227 8192000000 10833170624 11271991296 1898848880 18.817 99 31 62 0 1924329408 15858480 9622048
20:59:20 24339 8192000000 10848022416 11300921344 1920356768 18.990 100 18 37 2 1944566976 18642656 5567552
20:59:53 17150 8192000000 10866615840 11312140288 1932523808 19.087 100 24 47 0 1956873472 17699648 6650016
21:00:16 34373 8192000000 10860146400 11325034496 1939178032 19.140 100 8 16 0 1954514048 13417360 1918656
21:00:57 25177 8192000000 10869620992 11309764608 1910832288 18.913 98 33 66 0 1928115312 6782016 10501008
21:01:30 51586 8192000000 10875967024 11329875968 1927786576 19.049 99 18 36 1 1941052608 7932800 5333232
21:02:27 74600 8192000000 10902947488 11333263360 1942636576 19.168 99 27 49 3 1956197488 6708304 6852608
21:03:51 12113 8192000000 10908774832 11342102528 1949696016 19.224 99 51 101 0 1971769456 7725904 14347536
21:04:09 17343 8192000000 10869073760 11309211648 1934315744 19.101 99 35 70 0 1953682592 9519968 9846880
21:04:39 80041 8192000000 10910912704 11335327744 1941133904 19.156 99 30 60 1 1959637152 9645536 8857712
21:06:05 9546 8192000000 10926886672 11353907200 1978014784 19.449 100 66 132 3 2007313024 10083568 19214672
21:06:27 33755 8192000000 10911246464 11362013184 1975368016 19.428 100 33 66 0 1998100160 13586864 9145280
21:07:19 78791 8192000000 10892821856 11354722304 1931844272 19.082 98 10 20 0 1952377264 17687664 2845328
21:08:47 78211 8192000000 10913001136 11370213376 1977957856 19.449 100 15 30 1 1990526560 8293952 4274752
21:10:20 81199 8192000000 10912369472 11390386176 1993617104 19.572 100 12 24 0 2010784640 13072160 4095376
21:11:48 130495 8192000000 10912007040 11383623680 1904929200 18.866 96 7 14 0 1916341008 9872000 1539808
21:14:07 141099 8192000000 10917253712 11392729088 1925864208 19.034 97 10 20 0 1945700848 16981136 2855504
21:16:39 109718 8192000000 10933687520 11389935616 1975526208 19.429 99 30 60 0 1996847824 12351552 8970064
21:20:27 71473 8192000000 10923189504 11377242112 1931003360 19.075 97 30 62 1 1947937008 7487568 9446080
21:22:00 29553 8192000000 10892649312 11363315712 1957585856 19.287 99 20 40 2 1973911712 10832960 5492896
21:22:46 54391 8192000000 10883543808 11360305152 1934797168 19.105 98 12 24 1 1947883552 9593136 3493248
21:23:47 158845 8192000000 10895153504 11375554560 1922058448 19.003 97 19 38 0 1935839600 7754976 6026176
21:26:32 58523 8192000000 10862222416 11324125184 1854765536 18.461 94 14 28 1 1872477488 13271632 4440320
21:27:39 82372 8192000000 10888637712 11362017280 1959690080 19.304 100 19 38 1 1976582480 11644976 5247424
21:29:18 50051 8192000000 10854429456 11324772352 1865653568 18.549 95 10 20 1 1878064528 9020144 3390816
21:30:14 26696 8192000000 10872498000 11333140480 1933693952 19.096 99 12 22 1 1942650800 5994736 2962112
21:30:49 50018 8192000000 10866039840 11340308480 1891427552 18.757 96 12 24 0 1907388864 12813840 3147472
21:31:50 22752 8192000000 10867564608 11329359872 1892062192 18.762 97 23 46 0 1904593984 6018576 6513216
21:32:21 33535 8192000000 10896502720 11348631552 1904731632 18.864 97 38 72 2 1923300112 8096656 10471824
21:33:02 14447 8192000000 10882135872 11336282112 1917191888 18.964 98 40 80 1 1943134464 14917424 11025152
21:33:23 22658 8192000000 10870773888 11331854336 1926421872 19.038 99 27 54 0 1944240640 10196464 7622304
21:33:53 43495 8192000000 10849775440 11316551680 1846358016 18.393 95 21 42 0 1868064816 16194400 5512400
21:34:54 39035 8192000000 10869703472 11331866624 1925009696 19.027 100 27 54 2 1949410512 17010592 7390224
21:35:39 61311 8192000000 10822866768 11286089728 1835725824 18.306 95 20 40 0 1862569696 21459840 5384032
21:36:53 48835 8192000000 10825327168 11277115392 1782739040 17.872 93 29 58 0 1801822864 10349744 8734080
21:37:50 49881 8192000000 10856801840 11326758912 1910391600 18.910 100 27 52 1 1930773840 12639264 7742976
21:39:00 48100 8192000000 10845395296 11308953600 1887469040 18.725 98 20 40 0 1905842080 12762848 5610192
21:39:54 116743 8192000000 10869375024 11328327680 1815616848 18.142 94 15 30 1 1829796640 10377936 3801856
21:42:25 58793 8192000000 10894706672 11352666112 1942487776 19.167 100 24 46 0 1970152032 20383904 7280352
21:43:30 44853 8192000000 10898586464 11346231296 1935433968 19.110 99 20 40 1 1953621840 12316336 5871536
21:44:25 129389 8192000000 10869062656 11335294976 1896738080 18.800 97 22 44 0 1913410304 10460976 6211248
21:46:57 63796 8192000000 10869799728 11343405056 1930284736 19.069 99 32 64 1 1958590480 19273072 9032672
21:48:49 71674 8192000000 10853481504 11329077248 1903839392 18.857 98 15 30 1 1916267888 7989152 4439344
21:50:08 42035 8192000000 10857688400 11332112384 1924187376 19.020 99 10 18 1 1935072480 8210784 2674320
21:50:56 47895 8192000000 10879228560 11347267584 1951425424 19.238 100 16 32 2 1964703392 9029184 4248784
21:52:03 70536 8192000000 10898878864 11372023808 1958065008 19.291 99 16 32 1 1974940544 11432368 5443168
21:53:19 121136 8192000000 10904756656 11374477312 1955610304 19.271 99 23 46 2 1977879552 15465216 6804032
21:55:27 16118 8192000000 10893048592 11367686144 1965521776 19.350 100 18 36 2 1990541504 19378864 5640864
21:55:53 40827 8192000000 10900618816 11379453952 1968889408 19.377 100 14 28 0 1988597088 15018656 4689024
21:57:01 68729 8192000000 10916640352 11381432320 1943553824 19.175 98 14 26 2 1955771472 9130704 3086944
21:59:04 66067 8192000000 10930434640 11406467072 1998193200 19.608 100 19 38 1 2016143392 12710256 5239936
22:00:39 114222 8192000000 10932287888 11406647296 1972560768 19.406 99 13 26 0 1987269776 11402400 3306608
22:02:39 43530 8192000000 10930132960 11394150400 1943649296 19.176 97 27 54 1 1970389456 19375008 7365152
22:03:34 66198 8192000000 10916502208 11392004096 1953422384 19.254 98 22 44 0 1974210752 14305472 6482896
22:04:46 20420 8192000000 10932508560 11382263808 1935774240 19.113 97 27 54 0 1955182496 11573056 7835200
22:05:14 55203 8192000000 10921098496 11390844928 1949930224 19.226 98 33 66 1 1974253824 15169520 9154080
22:06:28 51282 8192000000 10929790944 11381350400 1927543216 19.047 97 29 58 1 1950086528 14217152 8326160
22:07:29 97589 8192000000 10914976752 11383709696 1941755712 19.161 98 20 40 0 1958234000 11084768 5393520
22:09:13 24702 8192000000 10923199504 11383283712 1962511424 19.326 99 32 63 1 1979734144 8395136 8827584
22:09:47 52867 8192000000 10910766240 11371802624 1920276912 18.989 97 20 40 1 1939514576 13496768 5740896
22:10:46 93821 8192000000 10881993728 11338616832 1909391584 18.902 97 31 61 2 1926650304 7957072 9301648
22:12:32 87678 8192000000 10892727152 11374514176 1949095968 19.219 99 20 40 0 1967597840 11744128 6757744
22:14:15 39426 8192000000 10890340496 11370090496 1955263408 19.268 99 21 42 2 1975517424 14297408 5956608
22:15:01 53345 8192000000 10899808976 11376214016 1959743088 19.304 99 15 29 0 1980228720 15990160 4495472
22:16:39 110591 8192000000 10859082368 11324510208 1826056064 18.227 93 12 24 0 1843776208 14392048 3328096
22:18:36 57574 8192000000 10856611200 11331805184 1902419664 18.846 98 12 24 1 1917406880 11451728 3535488
22:20:50 43235 8192000000 10871462544 11331317760 1914932784 18.946 99 19 38 0 1933836768 12953904 5950080
22:21:42 62137 8192000000 10855862432 11329191936 1889267840 18.740 97 11 22 2 1907489120 15053456 3167824
22:23:04 84451 8192000000 10862193328 11318120448 1835313760 18.303 95 9 18 1 1846781504 9050560 2417184
22:24:35 52989 8192000000 10854195312 11318050816 1890993440 18.754 98 18 36 1 1909665600 13314240 5357920
22:25:34 103036 8192000000 9664330944 9999380480 792759536 8.823 42 8 16 0 804976240 9659440 2557264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-01-2021 22:28:29 to 05-01-2021 22:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 141 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 05-01-2021 22:29:00 to 05-01-2021 22:29:02.

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          247229
MON$OLDEST_ACTIVE               247230
MON$OLDEST_SNAPSHOT             247230
MON$NEXT_TRANSACTION            247230
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                       2031392
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
--- end of diff output ---

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

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