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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-22 19:27:11
DTS_END                         2021-01-22 19:27:11.0910
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34978
TRN_ID                          239488
ATT_ID                          667
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: 9122.46 19698 1094695
customer order: creation 177.04 362 21245
customer order: refuse 14.25 372 1710
order to supplier: creation 47.22 1272 5666
order to supplier: removal 3.34 103345 401
invoice (draft): creation 45.93 3257 5511
invoice (draft): removal 51.02 855 6122
invoice accept: apply 41.35 17475 4962
invoice accept: cancel 46.29 845 5555
customer reserve: creation 3787.19 174 454463
customer reserve: removal 4616.58 59 553989
realization accept: apply 83.99 181 10079
realization accept: cancel 76.37 116 9164
payment from customer: creation 60.04 135 7205
payment from customer: removal 5.56 110 667
payment to supplier: creation 50.36 144 6043
payment to supplier: removal 3.68 57 442
service: total inventory turnovers 4.93 1041 592
service: total monetary turnovers 6.43 31 772
service: aggregate perf. data 0.86 15979 103
service: refresh index statistics 0.03 248149 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-01-2021 19:28:49 to 22-01-2021 19:28:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4462
TEST_TIME 2 5063
TEST_TIME 3 4690
TEST_TIME 4 4978
TEST_TIME 5 5377
TEST_TIME 6 5128
TEST_TIME 7 5282
TEST_TIME 8 5502
TEST_TIME 9 5343
TEST_TIME 10 5251
TEST_TIME 11 5425
TEST_TIME 12 5638
TEST_TIME 13 6041
TEST_TIME 14 6116
TEST_TIME 15 6223
TEST_TIME 16 6956
TEST_TIME 17 7479
TEST_TIME 18 7589
TEST_TIME 19 8116
TEST_TIME 20 8024
TEST_TIME 21 7982
TEST_TIME 22 8694
TEST_TIME 23 9436
TEST_TIME 24 10238
TEST_TIME 25 10692
TEST_TIME 26 10403
TEST_TIME 27 10297
TEST_TIME 28 10112
TEST_TIME 29 10017
TEST_TIME 30 10163
TEST_TIME 31 9991
TEST_TIME 32 9861
TEST_TIME 33 9647
TEST_TIME 34 9641
TEST_TIME 35 9463
TEST_TIME 36 9372
TEST_TIME 37 9367
TEST_TIME 38 9375
TEST_TIME 39 9387
TEST_TIME 40 9261
TEST_TIME 41 9322
TEST_TIME 42 9376
TEST_TIME 43 9394
TEST_TIME 44 9319
TEST_TIME 45 9391
TEST_TIME 46 9373
TEST_TIME 47 9581
TEST_TIME 48 9612
TEST_TIME 49 9571
TEST_TIME 50 9623
TEST_TIME 51 9651
TEST_TIME 52 9659
TEST_TIME 53 9567
TEST_TIME 54 9438
TEST_TIME 55 9353
TEST_TIME 56 9321
TEST_TIME 57 9226
TEST_TIME 58 9245
TEST_TIME 59 9196
TEST_TIME 60 9280
TEST_TIME 61 9278
TEST_TIME 62 9215
TEST_TIME 63 9195
TEST_TIME 64 9256
TEST_TIME 65 9172
TEST_TIME 66 9220
TEST_TIME 67 9265
TEST_TIME 68 9296
TEST_TIME 69 9313
TEST_TIME 70 9272
TEST_TIME 71 9346
TEST_TIME 72 9276
TEST_TIME 73 9338
TEST_TIME 74 9508
TEST_TIME 75 9501
TEST_TIME 76 9401
TEST_TIME 77 9365
TEST_TIME 78 9298
TEST_TIME 79 9286
TEST_TIME 80 9270
TEST_TIME 81 9211
TEST_TIME 82 9193
TEST_TIME 83 9147
TEST_TIME 84 9170
TEST_TIME 85 9163
TEST_TIME 86 9182
TEST_TIME 87 9253
TEST_TIME 88 9214
TEST_TIME 89 9219
TEST_TIME 90 9238
TEST_TIME 91 9257
TEST_TIME 92 9330
TEST_TIME 93 9324
TEST_TIME 94 9340
TEST_TIME 95 9365
TEST_TIME 96 9424
TEST_TIME 97 9386
TEST_TIME 98 9321
TEST_TIME 99 9285
TEST_TIME 100 9238
TEST_TIME 101 9252
TEST_TIME 102 9191
TEST_TIME 103 9175
TEST_TIME 104 9154
TEST_TIME 105 9147
TEST_TIME 106 9196
TEST_TIME 107 9187
TEST_TIME 108 9172
TEST_TIME 109 9194
TEST_TIME 110 9215
TEST_TIME 111 9214
TEST_TIME 112 9199
TEST_TIME 113 9307
TEST_TIME 114 9269
TEST_TIME 115 9305
TEST_TIME 116 9306
TEST_TIME 117 9280
TEST_TIME 118 9236
TEST_TIME 119 9198
TEST_TIME 120 9127

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-01-2021 19:28:53 to 22-01-2021 19:28:56.

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 1517964 1517964 0 0.00 0 15243 6 0 0
doc_list_biud 1517963 1517963 0 0.00 0 44355 27 0 0
sp_add_invoice_to_stock 5110 4962 148 2.89 27 149679 17476 0 148
sp_cancel_adding_invoice 5555 5555 0 0.00 4 74724 845 0 0
sp_cancel_client_order 1710 1710 0 0.00 4 12163 372 0 0
sp_cancel_customer_reserve 553989 553989 0 0.00 1 27823 59 0 0
sp_cancel_pay_from_customer 667 667 0 0.00 3 10858 111 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 3 2329 57 0 0
sp_cancel_supplier_invoice 6140 6122 18 0.29 2 44426 855 0 18
sp_cancel_supplier_order 401 401 0 0.00 6 910992 103345 0 0
sp_cancel_write_off 9164 9164 0 0.00 1 10821 117 0 0
sp_client_order 21245 21245 0 0.00 4 36164 363 0 0
sp_customer_reserve 454463 454463 0 0.00 0 47741 174 0 0
sp_fill_shopping_cart 32405 32405 0 0.00 1 19102 39 0 0
sp_fill_shopping_cart_clo_res 454460 454460 0 0.00 0 18396 15 0 0
sp_get_clo_for_invoice 4957 4957 0 0.00 0 27267 285 0 0
sp_kill_cost_storno 15828 15828 0 0.00 0 7103 54 0 0
sp_kill_qstorno_ret_qs2qd 1123665 1123665 0 0.00 0 44353 32 0 0
sp_kill_qty_storno 591977 591977 0 0.00 0 44355 69 0 0
sp_lock_selected_doc 20754 20754 0 0.00 0 7969 6 0 0
sp_make_cost_storno 28284 28284 0 0.00 0 15085 60 0 0
sp_multiply_rows_for_pdistr 28284 28284 0 0.00 0 9547 27 0 0
sp_multiply_rows_for_qdistr 21245 21245 0 0.00 0 10091 155 0 0
sp_pay_from_customer 7205 7205 0 0.00 4 11659 136 0 0
sp_pay_to_supplier 6043 6043 0 0.00 4 15253 145 0 0
sp_payment_common 13248 13248 0 0.00 1 13570 31 0 0
sp_qd_handle_on_cancel_clo 1710 1710 0 0.00 0 12155 339 0 0
sp_qd_handle_on_invoice_upd_sts 10512 10512 0 0.00 0 17063 313 0 0
sp_qd_handle_on_reserve_upd_sts 10079 10079 0 0.00 0 18532 51 0 0
sp_reserve_write_off 10079 10079 0 0.00 6 18694 182 0 0
sp_supplier_invoice 5511 5511 0 0.00 7 72145 3257 0 0
sp_supplier_order 5666 5666 0 0.00 5 41780 1272 0 0
srv_aggregate_perf_data 104 103 1 0.96 2360 99051 15979 0 1
srv_fill_mon_cache_memory 158 158 0 0.00 1426 132968 34215 0 0
srv_find_qd_qs_mism 1047801 1047801 0 0.00 0 15114 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 29 80102 1041 0 0
srv_make_money_saldo 772 772 0 0.00 1 6618 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 165585 416511 248149 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 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 4962 4962 0 0.00 0 12141 151 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 16730 162 0 0
t$perf-norm:sp_cancel_client_order 1710 1710 0 0.00 0 4030 15 0 0
t$perf-norm:sp_cancel_customer_reserve 652 652 0 0.00 0 8111 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 667 667 0 0.00 0 3209 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 2662 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 5576 32 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 20952 1486 0 0
t$perf-norm:sp_cancel_write_off 1033 1033 0 0.00 0 3222 13 0 0
t$perf-norm:sp_client_order 21245 21245 0 0.00 0 7518 16 0 0
t$perf-norm:sp_customer_reserve 1062 1062 0 0.00 0 987 5 0 0
t$perf-norm:sp_pay_from_customer 7205 7205 0 0.00 0 8361 12 0 0
t$perf-norm:sp_pay_to_supplier 6043 6043 0 0.00 0 5490 12 0 0
t$perf-norm:sp_reserve_write_off 10079 10079 0 0.00 0 8756 11 0 0
t$perf-norm:sp_supplier_invoice 5511 5511 0 0.00 0 9679 21 0 0
t$perf-norm:sp_supplier_order 5666 5666 0 0.00 0 8730 17 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 634 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 5425 35 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 1211 14 0 0
t$perf-norm:srv_make_money_saldo 772 772 0 0.00 0 885 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 10210 9914 296 2.89 0 10242 22 0 296
v_all_customers 38740 38740 0 0.00 0 17 0 0 0
v_all_suppliers 31250 31250 0 0.00 0 126 1 0 0
v_all_wares 42490 42490 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 1038 7 0 0
v_cancel_client_order 3420 3420 0 0.00 0 4128 6 0 0
v_cancel_customer_prepayment 1334 1334 0 0.00 0 10831 23 0 0
v_cancel_customer_reserve 1304 1304 0 0.00 0 680 4 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 750 4 0 0
v_cancel_supplier_invoice 784 748 36 4.59 0 7671 28 0 36
v_cancel_supplier_order 802 802 0 0.00 0 2315 11 0 0
v_cancel_write_off 2066 2066 0 0.00 0 10788 18 0 0
v_max_id_clo_ord 5664 5664 0 0.00 0 1852 1 0 0
v_max_id_clo_res 1062 1062 0 0.00 0 1732 12 0 0
v_max_id_ord_sup 5496 5496 0 0.00 0 6522 9 0 0
v_max_non_paid_invoice 1578 1578 0 0.00 0 3981 6 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 4162 6 0 0
v_min_id_clo_ord 5664 5664 0 0.00 0 3189 6 0 0
v_min_id_clo_res 1062 1062 0 0.00 0 6107 17 0 0
v_min_id_ord_sup 5496 5496 0 0.00 0 6726 8 0 0
v_min_non_paid_invoice 6043 6043 0 0.00 0 7098 13 0 0
v_min_non_paid_realizn 7205 7205 0 0.00 0 7270 16 0 0
v_our_firm 10624 10624 0 0.00 0 52 1 0 0
v_reserve_write_off 20158 20158 0 0.00 0 7789 7 0 0
x_lock_depdocs_on_canc_invoice 11303 11303 0 0.00 0 26027 115 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 4090 310 0 0
x_make_qstorno_1000_1200 5666 5666 0 0.00 2 41745 1201 0 0
x_make_qstorno_1200_2000 5511 5511 0 0.00 4 67575 3104 0 0
x_make_qstorno_2100_3300 454463 454463 0 0.00 0 42184 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-01-2021 19:28:57 to 22-01-2021 19:29:01.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:21 19211 8192000000 10246947968 10557067264 832866208 9.228 64 45 91 0 850375072 2335008 15173856
16:57:48 27023 8192000000 10344248880 10659430400 1387754000 14.486 100 86 172 1 1420734672 4813760 28166912
16:58:30 28943 8192000000 10386679760 10709913600 1435331664 14.908 100 83 166 0 1468701040 6266912 27102464
16:59:10 21885 8192000000 10404819216 10731597824 1460860240 15.133 100 88 177 0 1496834368 7081648 28892480
16:59:41 26906 8192000000 10430659712 10765467648 1485906944 15.353 100 84 168 1 1520451952 7662704 26882304
17:00:16 21878 8192000000 10454759616 10789445632 1503008368 15.502 100 88 176 0 1539125984 8228864 27888752
17:00:54 18217 8192000000 10472837920 10813784064 1527899296 15.719 100 79 158 0 1561613856 8373200 25341360
17:01:22 16407 8192000000 10481224000 10827956224 1546760128 15.882 100 79 158 0 1580775008 8938176 25076704
17:01:52 12495 8192000000 10509699440 10858844160 1568765744 16.072 100 80 158 1 1602981088 9532096 24683248
17:02:14 14922 8192000000 10527453136 10883883008 1589490256 16.249 100 75 150 1 1622173888 9918160 22765472
17:02:38 13534 8192000000 10554033696 10913923072 1612779824 16.448 100 75 150 1 1645797296 10432848 22584624
17:02:59 10696 8192000000 10578210048 10938851328 1638461648 16.667 100 78 156 0 1672908960 10684800 23762512
17:03:18 9157 8192000000 10601426672 10963279872 1658913728 16.840 100 81 162 1 1694870352 11904192 24052432
17:03:35 10952 8192000000 10616502720 10984693760 1674337040 16.970 100 71 142 2 1706461616 11240912 20883664
17:03:54 7892 8192000000 10637298928 11001667584 1697815808 17.167 100 84 168 2 1734777840 12324976 24637056
17:04:09 8727 8192000000 10655495232 11025235968 1710669920 17.274 100 87 172 0 1748863360 13363200 24830240
17:04:25 6119 8192000000 10664813536 11037458432 1730399168 17.439 100 84 167 2 1767509392 13730032 23380192
17:04:39 6741 8192000000 10688567632 11059814400 1743823648 17.550 100 86 172 0 1782654368 13826384 25004336
17:04:53 4602 8192000000 10687336544 11069808640 1751717008 17.616 100 77 153 1 1786804064 13236272 21850784
17:05:05 6952 8192000000 10700701008 11077328896 1762106976 17.702 100 85 169 2 1799253504 13268896 23877632
17:05:20 4137 8192000000 10716365184 11092168704 1771540656 17.780 100 88 175 0 1809359872 13858272 23960944
17:05:31 5011 8192000000 10722489648 11097833472 1777666432 17.830 100 83 166 2 1814976320 14126704 23183184
17:05:44 4588 8192000000 10719486144 11100090368 1779086576 17.842 100 82 162 0 1814752368 12957568 22708224
17:05:56 2877 8192000000 10725472656 11105828864 1786713760 17.905 100 85 170 1 1824630416 13390224 24526432
17:06:06 3150 8192000000 10735096432 11117428736 1791772704 17.946 100 84 169 1 1828592064 13236688 23582672
17:06:16 2771 8192000000 10743700144 11121000448 1797613312 17.994 100 89 177 2 1834562160 12484272 24464576
17:06:27 3162 8192000000 10743950912 11121946624 1804310496 18.049 100 89 178 0 1843087440 13849936 24927008
17:06:37 13011 8192000000 10732512896 11122675712 1807916752 18.079 100 84 166 2 1845463488 14556176 22990560
17:06:57 3969 8192000000 10760191472 11147149312 1807853952 18.078 100 75 149 0 1841777392 13358080 20565360
17:07:07 2155 8192000000 10767052336 11148451840 1824707296 18.216 100 92 184 0 1865237760 14275952 26254512
17:07:16 3636 8192000000 10776886736 11159445504 1830123088 18.260 100 84 167 4 1865933728 13256016 22554624
17:07:27 2693 8192000000 10773428368 11160928256 1835023216 18.300 100 83 166 1 1871607776 13763616 22820944
17:07:36 3287 8192000000 10787204752 11173408768 1842700224 18.363 100 90 180 2 1881381008 13398256 25282528
17:07:46 2570 8192000000 10790647840 11176148992 1845906992 18.389 100 90 179 4 1884222400 13118624 25196784
17:07:55 2076 8192000000 10795642496 11180216320 1848255584 18.408 100 90 181 1 1887183920 13495584 25432752
17:08:03 2254 8192000000 10797746128 11188305920 1857818784 18.486 100 95 189 1 1897715008 13174944 26721280
17:08:12 1353 8192000000 10804049312 11191406592 1859312640 18.498 100 95 193 0 1899853472 13135136 27405696
17:08:20 2344 8192000000 10806259936 11192979456 1861194848 18.513 100 93 183 0 1900258576 13059024 26004704
17:08:29 1790 8192000000 10804742448 11193794560 1863845264 18.534 100 91 182 0 1903413792 13713424 25855104
17:08:37 2055 8192000000 10806095280 11198070784 1862738656 18.525 100 79 158 1 1898595392 13433536 22423200
17:08:46 29380 8192000000 10784126352 11193876480 1864018352 18.536 100 76 150 0 1895461168 9855312 21587504
17:09:22 18135 8192000000 10810933536 11203215360 1867740240 18.566 100 74 150 3 1899750336 10572448 21437648
17:09:47 1420 8192000000 10821501744 11210596352 1873538304 18.613 100 91 182 2 1911324928 12010592 25776032
17:09:55 5048 8192000000 10792845424 11202973696 1871644576 18.598 100 67 131 1 1902118336 12896208 17577552
17:10:14 8175 8192000000 10787880480 11199660032 1871018544 18.593 100 47 94 1 1891243472 6111632 14113296
17:10:29 2336 8192000000 10778950784 11200798720 1869504640 18.580 100 50 100 1 1892972704 9151232 14316832
17:10:39 5385 8192000000 10794624720 11209273344 1873361920 18.611 100 44 89 0 1894126112 7600496 13163696
17:10:51 2922 8192000000 10786462928 11208695808 1873367056 18.612 100 47 94 1 1895896592 9638624 12890912
17:11:04 8730 8192000000 10776171472 11204182016 1871632320 18.597 100 32 63 0 1887470336 7085120 8752896
17:11:21 6853 8192000000 10787916464 11211464704 1873780784 18.615 100 32 64 2 1889891952 7579152 8532016
17:11:37 8699 8192000000 10783277792 11212615680 1875259952 18.627 100 18 37 1 1886403584 6034336 5109296
17:11:56 7909 8192000000 10794095264 11219677184 1880745360 18.671 100 21 42 1 1893673760 6316848 6611552
17:12:12 10973 8192000000 10792729104 11221532672 1882605568 18.686 100 22 43 2 1898227760 9948608 5673584
17:12:30 5034 8192000000 10803043056 11229679616 1887388016 18.725 100 32 63 2 1903875520 7119184 9368320
17:12:41 8675 8192000000 10791222272 11225513984 1887109184 18.722 100 24 45 3 1899749392 6029568 6610640
17:12:58 6531 8192000000 10789357568 11225157632 1885964048 18.713 100 11 22 1 1893962192 4964336 3033808
17:13:10 9707 8192000000 10790689504 11225669632 1888024752 18.730 100 14 28 2 1897806976 5513440 4268784
17:13:27 13330 8192000000 10787264576 11225174016 1890007792 18.746 100 15 29 1 1899146496 5273728 3864976
17:13:49 77608 8192000000 10803144800 11245006848 1893413088 18.773 100 23 46 1 1905051536 5149184 6489264
17:15:15 6871 8192000000 10823208064 11251974144 1901169104 18.836 100 33 67 2 1917421520 7106144 9146272
17:15:31 6796 8192000000 10826426848 11255644160 1903338624 18.853 100 35 70 1 1919730112 6602368 9789120
17:15:44 6116 8192000000 10821511696 11254362112 1902749120 18.848 100 30 61 0 1918466096 6421472 9295504
17:15:59 3354 8192000000 10834862368 11259072512 1905349568 18.869 100 44 88 0 1925512432 7055024 13107840
17:16:09 7264 8192000000 10820906016 11255439360 1902566720 18.847 100 23 46 2 1915694368 6499648 6628000
17:16:23 7809 8192000000 10827081008 11258273792 1902237776 18.844 100 22 44 1 1914271936 5518832 6515328
17:16:41 7488 8192000000 10815763152 11253301248 1900656496 18.832 100 34 67 2 1921640208 10541696 10442016
17:16:56 6785 8192000000 10773728256 11192434688 1790737424 17.938 95 30 60 2 1809273328 9356992 9178912
17:17:09 8053 8192000000 10779502048 11206475776 1844364224 18.376 99 16 32 0 1854909696 5259920 5285552
17:17:23 8888 8192000000 10771366752 11203305472 1829479280 18.255 98 23 46 1 1845565856 10123200 5963376
17:17:39 11479 8192000000 10778423184 11214110720 1851194560 18.432 99 19 38 2 1862563392 5460176 5908656
17:17:57 10055 8192000000 10769287648 11197018112 1806057872 18.064 97 20 40 2 1821705728 9849888 5797968
17:18:15 8513 8192000000 10770690624 11200745472 1833735216 18.290 99 18 36 3 1849250592 10061136 5454240
17:18:30 22917 8192000000 10764887296 11184308224 1787417696 17.911 96 26 53 2 1800171184 4692048 8061440
17:18:59 48656 8192000000 10777344240 11188637696 1802743264 18.036 97 45 88 3 1821309920 4887792 13678864
17:19:54 10855 8192000000 10692912064 11119824896 1693289200 17.129 92 10 20 0 1704633248 9075728 2268320
17:20:12 10008 8192000000 10730952816 11139346432 1708090048 17.253 94 26 52 1 1720683952 5855440 6738464
17:20:29 7474 8192000000 10696710848 11111985152 1742613840 17.540 96 36 71 1 1759656768 7257936 9784992
17:20:44 8328 8192000000 10724401568 11137355776 1765628208 17.731 98 30 60 0 1784502848 10288976 8585664
17:20:59 6869 8192000000 10703888928 11115290624 1754700752 17.641 97 31 61 2 1769976048 6900512 8374784
17:21:18 8999 8192000000 10682530336 11088756736 1715543200 17.315 95 19 37 1 1726504144 5608640 5352304
17:21:34 9309 8192000000 10696619136 11113414656 1716563616 17.324 95 21 40 1 1727573696 5747584 5262496
17:21:51 6166 8192000000 10690897344 11093192704 1761528960 17.697 98 32 64 0 1777301088 5877232 9894896
17:22:05 8889 8192000000 10695146704 11117006848 1756140080 17.652 98 13 26 1 1765235568 5646320 3449168
17:22:21 12624 8192000000 10726570864 11146006528 1792483824 17.952 99 21 42 0 1803792832 5298784 6010224
17:22:41 8351 8192000000 10712648896 11139727360 1781846704 17.865 98 28 55 0 1796138848 6326624 7965520
17:22:59 8190 8192000000 10740732640 11154067456 1797806432 17.996 99 31 61 3 1812701344 5591904 9303008
17:23:13 6578 8192000000 10744793664 11167969280 1830896864 18.267 100 29 58 0 1844441824 5240288 8304672
17:23:27 15236 8192000000 10750736496 11174621184 1821830464 18.193 99 17 34 1 1832448800 4841344 5776992
17:23:51 62007 8192000000 10802127824 11191029760 1836539792 18.313 99 56 117 0 1859172000 6062800 16569408
17:24:59 5060 8192000000 10774048160 11196391424 1851470944 18.434 100 48 96 2 1873865552 9917792 12476816
17:25:10 11739 8192000000 10764550112 11197276160 1851468288 18.434 100 27 53 0 1865064800 5750064 7846448
17:25:28 7591 8192000000 10783703648 11206541312 1863856608 18.535 100 41 83 1 1887096816 11829584 11410624
17:25:42 8040 8192000000 10773143808 11204468736 1860095584 18.504 100 20 40 0 1872233904 6120896 6017424
17:25:58 6066 8192000000 10784462896 11211763712 1865424512 18.547 100 28 56 2 1879658192 6702736 7530944
17:26:12 6478 8192000000 10779475600 11207106560 1864688016 18.541 100 21 42 0 1876248176 5441136 6119024
17:26:25 10870 8192000000 10775714544 11210248192 1866221584 18.554 100 20 40 0 1877535088 5678096 5635408
17:26:43 10039 8192000000 10795999856 11215597568 1868040784 18.568 100 20 40 0 1879885024 5709520 6134720
17:27:00 8671 8192000000 10796396240 11220811776 1875096592 18.625 100 18 36 0 1885322160 5271648 4953920
17:27:19 30047 8192000000 10808781792 11233431552 1893517200 18.774 100 31 58 3 1907407904 5147696 8743008
17:27:57 23162 8192000000 10838444400 11257905152 1910223440 18.908 100 51 102 1 1932905088 7267360 15414288
17:28:41 18007 8192000000 10855645760 11271876608 1920950976 18.994 100 54 107 2 1946760832 11206272 14603584
17:29:06 77507 8192000000 10860358432 11290648576 1927982080 19.051 100 43 85 4 1950770080 10401472 12386528
17:30:35 7527 8192000000 10878001696 11306766336 1937934912 19.130 100 48 96 3 1963723024 11797424 13990688
17:30:51 9321 8192000000 10883834080 11305459712 1940943696 19.154 100 54 108 3 1969442752 12906144 15592912
17:31:07 6122 8192000000 10891340512 11309580288 1946574928 19.199 100 63 126 1 1979654848 14604944 18474976
17:31:20 5552 8192000000 10892514032 11312087040 1951964768 19.242 100 65 130 2 1985217056 15231184 18021104
17:31:33 14313 8192000000 10892111456 11315732480 1949399888 19.222 100 54 109 2 1979741088 14807680 15533520
17:31:57 16322 8192000000 10888428896 11319664640 1952329424 19.245 100 48 96 2 1981081056 14864816 13886816
17:32:36 28276 8192000000 10897782016 11333537792 1960663824 19.311 100 46 94 0 1988940912 14576928 13700160
17:33:14 39410 8192000000 10923795648 11351560192 1974368784 19.420 100 48 94 1 2003756800 15214656 14173360
17:34:04 16684 8192000000 10936746480 11362160640 1982980320 19.488 100 47 94 0 2014351920 17515472 13856128
17:34:29 17295 8192000000 10923932048 11361681408 1984715840 19.502 100 45 90 3 2016451776 18252464 13483472
17:34:56 12490 8192000000 10922328384 11365994496 1987490816 19.524 100 46 90 0 2016368240 15459040 13418384
17:35:20 19931 8192000000 10922633440 11363741696 1988559728 19.532 100 42 83 0 2016516688 14807152 13149808
17:35:50 32350 8192000000 10946367936 11380236288 1999121968 19.616 100 44 88 0 2036047488 22992496 13933024
17:36:38 5985 8192000000 10948719152 11385708544 2006752768 19.676 100 49 98 1 2041440992 19135152 15553072
17:36:52 12592 8192000000 10939775008 11382099968 2003273392 19.649 100 45 91 1 2036997888 19471376 14253120
17:37:11 17767 8192000000 10947885488 11388100608 1991038864 19.552 99 56 112 3 2029050208 20439008 17572336
17:37:38 13263 8192000000 10960626752 11396218880 2010682560 19.707 100 42 84 0 2047895872 23364736 13848576
17:37:58 3537 8192000000 10973073888 11405869056 2019221312 19.774 100 55 110 0 2062638400 26183968 17233120
17:38:08 3460 8192000000 10985203104 11414761472 2022376880 19.799 100 64 125 2 2068473728 27028112 19068736
17:38:18 5374 8192000000 10980768896 11408150528 2005341568 19.665 99 71 140 3 2056367856 29478240 21548048
17:38:31 1683 8192000000 10970448848 11390971904 1990250832 19.546 99 71 141 0 2042118704 30068560 21799312
17:38:40 3736 8192000000 10968861360 11394220032 2004263648 19.656 100 65 130 1 2056049040 31475664 20309728
17:38:53 5839 8192000000 10979896144 11403481088 2013683328 19.730 100 67 134 0 2065724880 31197888 20843664
17:39:09 10566 8192000000 10978774064 11402166272 1995904144 19.590 99 69 139 3 2050477616 33195456 21378016
17:39:27 6480 8192000000 10978694880 11408498688 2009274960 19.696 100 63 127 0 2062355664 33075968 20004736
17:39:43 5311 8192000000 10952492416 11382685696 1981223760 19.474 99 56 111 0 2030908880 32613536 17071584
17:39:58 6402 8192000000 10981142576 11414122496 2011609536 19.714 100 65 130 0 2065276032 33801600 19864896
17:40:13 7918 8192000000 10979851072 11417731072 2018296432 19.767 100 55 110 4 2069025968 33038800 17690736
17:40:28 8610 8192000000 10982491440 11417874432 2019998560 19.780 100 64 127 0 2072210176 31724976 20486640
17:40:44 5421 8192000000 10976893712 11408891904 2001049568 19.631 99 60 118 1 2050893184 30861760 18981856
17:41:12 7284 8192000000 10985587968 11419422720 2004764256 19.660 99 59 118 0 2059377040 35011600 19601184
17:41:27 3851 8192000000 10980300448 11414646784 2012967968 19.725 100 55 110 1 2065559328 34097472 18493888
17:41:38 4338 8192000000 11008972976 11431100416 2028043200 19.843 100 78 157 0 2088642272 35788688 24810384
17:41:50 2894 8192000000 11008736352 11435683840 2035834672 19.904 100 76 152 0 2098099568 38219312 24045584
17:42:00 3170 8192000000 11013990048 11434696704 2030303168 19.861 100 77 154 2 2093910320 39645552 23961600
17:42:12 3294 8192000000 11023503808 11445473280 2038899168 19.928 100 77 154 0 2102880272 39988032 23993072
17:42:22 3817 8192000000 11006020064 11430830080 2024356928 19.814 100 79 158 0 2089072080 40545376 24169776
17:42:33 2614 8192000000 11015713920 11438747648 2028967760 19.851 100 88 176 1 2098845136 42076480 27800896
17:42:44 9778 8192000000 11024092240 11441131520 2030745408 19.864 100 79 158 0 2101115504 44741104 25628992
17:43:04 5859 8192000000 11013825936 11439665152 2026316832 19.830 100 82 163 2 2099818496 47024256 26477408
17:43:19 1914 8192000000 10998588736 11414188032 2002128608 19.640 99 85 170 0 2078392752 48736080 27528064
17:43:28 2657 8192000000 11016888464 11433132032 2017330336 19.759 100 87 171 1 2092424304 48271392 26822576
17:43:39 1627 8192000000 10984973760 11399110656 1993789632 19.574 99 82 160 2 2060791424 41632544 25369248
17:43:48 3666 8192000000 10990714928 11422560256 2013950816 19.733 100 69 136 2 2078558608 41774304 22833488
17:44:01 1425 8192000000 11001768096 11426746368 2003151040 19.648 99 74 150 1 2066983904 39561376 24271488
17:44:09 4209 8192000000 10985689952 11418406912 2011743392 19.715 100 67 134 1 2068648080 36164192 20740496
17:44:28 9156 8192000000 10973893376 11407659008 1990714176 19.549 99 66 133 0 2048682192 37256720 20711296
17:44:46 4413 8192000000 10969829056 11400585216 1986601648 19.517 99 60 118 0 2038870064 33965984 18302432
17:44:59 3427 8192000000 10981955280 11402661888 2000271856 19.625 100 77 155 0 2060851408 35998288 24581264
17:45:09 3217 8192000000 10986133680 11406397440 2002853312 19.645 100 75 150 1 2064253136 37467728 23932096
17:45:19 3392 8192000000 10985545648 11400347648 1989956432 19.543 99 85 169 2 2055937088 39066800 26913856
17:45:29 1537 8192000000 10993287520 11409567744 2007452240 19.681 100 84 167 2 2073873568 40091728 26329600
17:45:39 5610 8192000000 10984347504 11411406848 2006920784 19.677 100 73 145 0 2070433968 40949552 22563632
17:45:52 9167 8192000000 10965491408 11398983680 1982207072 19.482 99 61 122 1 2042349952 40798368 19344512
17:46:11 2877 8192000000 10978000336 11393781760 1985939600 19.512 100 84 168 3 2050467936 37966656 26561680
17:46:22 5906 8192000000 10952371232 11383341056 1967784336 19.368 99 50 100 0 2022023648 37900208 16339104
17:46:36 12278 8192000000 10937088848 11381813248 1977372576 19.444 100 33 65 0 2026816336 38974128 10469632
17:46:56 6477 8192000000 10907419280 11335507968 1922486560 19.007 97 40 80 0 1968045152 32824032 12734560
17:47:11 4197 8192000000 10937520048 11375398912 1974538784 19.421 100 44 88 1 2022034112 33811264 13684064
17:47:23 9118 8192000000 10906532848 11340660736 1943019504 19.171 99 41 82 0 1991321344 34986096 13315744
17:47:41 3131 8192000000 10941873712 11362013184 1948421104 19.214 99 71 140 4 2007796208 36696304 22678800
17:47:50 4289 8192000000 10933252176 11366350848 1960510480 19.310 100 47 94 1 2016602224 40049040 16042704
17:48:01 20172 8192000000 10933909584 11372281856 1945921104 19.194 99 40 79 3 2001082960 41420512 13741344
17:48:38 22373 8192000000 10935525360 11376500736 1949793328 19.225 100 37 74 2 2016999264 53138800 14067136
17:49:22 31555 8192000000 10918411216 11371589632 1934514128 19.103 99 33 66 0 2004591184 57622432 12454624
17:50:10 8640 8192000000 10927160656 11374555136 1947607824 19.207 100 28 56 1 2008574128 50729888 10236416
17:50:26 6279 8192000000 10926904752 11386163200 1946226112 19.196 100 17 34 1 2005205520 51785616 7193792
17:50:48 32263 8192000000 10884540832 11341230080 1904842416 18.865 98 12 24 0 1939257840 30145280 4270144
17:51:35 32591 8192000000 10877264480 11331121152 1872325088 18.603 97 17 34 1 1907514560 28604608 6584864
17:52:14 17129 8192000000 10868774608 11329957888 1930363936 19.070 100 10 20 1 1953447056 19919904 3163216
17:52:37 20079 8192000000 10851342784 11300106240 1890873760 18.753 98 18 36 1 1906896272 10741568 5280944
17:53:05 5851 8192000000 10852328240 11292729344 1890933568 18.753 98 57 113 2 1916502256 8797696 16770992
17:53:54 79260 8192000000 10854524320 11300835328 1885988976 18.713 98 28 56 1 1904239408 9895136 8355296
17:55:21 106991 8192000000 10857194752 11322687488 1922859264 19.010 99 33 66 2 1944260800 11445904 9955632
17:57:23 30767 8192000000 10822916688 11291500544 1862642944 18.525 96 10 19 2 1877799264 12138736 3017584
17:58:08 47365 8192000000 10836864672 11299033088 1900372768 18.829 99 6 12 0 1913743472 12073264 1297440
17:59:02 15445 8192000000 10834122000 11297595392 1897381952 18.805 99 8 16 0 1912444256 12839056 2223248
17:59:24 25415 8192000000 10831329792 11290038272 1895312208 18.789 99 6 12 2 1913592160 16951088 1328864
17:59:56 16107 8192000000 10845546400 11305103360 1923731072 19.017 100 8 16 1 1936899392 11338256 1830064
18:00:33 29035 8192000000 10845794304 11302985728 1915072528 18.947 99 17 33 2 1934311392 14243808 4995056
18:01:12 41182 8192000000 10846820816 11305164800 1909373952 18.902 99 10 20 0 1925088320 13173344 2541024
18:02:01 53003 8192000000 10868256032 11320725504 1905689904 18.872 98 19 37 0 1920383440 9346400 5347136
18:03:26 55734 8192000000 10856807088 11319382016 1929619344 19.064 99 33 66 0 1948258576 9062080 9577152
18:04:40 31187 8192000000 10873437232 11320545280 1942921152 19.170 100 21 42 0 1959003232 10084064 5998016
18:05:18 55201 8192000000 10865806096 11344797696 1950979984 19.234 100 15 30 0 1964038736 8554208 4504544
18:06:21 40816 8192000000 10871883504 11344281600 1954492544 19.262 100 11 21 2 1969934544 12612768 2829232
18:07:13 52340 8192000000 10873498128 11333836800 1928451536 19.054 98 43 86 0 1950175040 9072720 12650784
18:08:12 43247 8192000000 10862829952 11334397952 1930039168 19.067 99 14 29 1 1944275200 10060784 4175248
18:09:06 76078 8192000000 10874719776 11339010048 1868035024 18.568 96 12 24 0 1889085456 18115328 2935104
18:10:29 56689 8192000000 10885066720 11330977792 1928864832 19.058 99 23 44 1 1946314464 10909584 6540048
18:11:33 72498 8192000000 10886568448 11350626304 1921589440 19.000 98 19 38 0 1943849872 16459040 5801392
18:13:33 100003 8192000000 10894545952 11379707904 1948530000 19.215 99 14 28 1 1969731344 16637760 4563584
18:15:19 83458 8192000000 10893869664 11360112640 1934149216 19.100 98 14 28 0 1950500160 12761952 3588992
18:16:51 83434 8192000000 10901578176 11353300992 1947557072 19.207 99 13 26 1 1961440768 10562960 3320736
18:18:23 95201 8192000000 10894118800 11354988544 1909391824 18.902 97 27 53 1 1930330464 13495424 7443216
18:20:05 96893 8192000000 10893576288 11358896128 1973022160 19.409 100 30 56 1 1988144432 7320112 7802160
18:23:14 67282 8192000000 10889050096 11361218560 1918324176 18.973 97 21 42 2 1936886288 12821424 5740688
18:24:32 27455 8192000000 10881493328 11360399360 1958558592 19.295 100 7 14 0 1979366672 18624352 2183728
18:26:25 48343 8192000000 10883123760 11358916608 1943349488 19.173 99 8 16 0 1958201600 12727072 2125040
18:27:20 37337 8192000000 10884862304 11351224320 1928190096 19.052 98 21 42 0 1948843184 14509072 6144016
18:28:03 66925 8192000000 10865047584 11350122496 1908014288 18.891 97 10 21 1 1919679568 8798064 2867216
18:29:16 58849 8192000000 10861776592 11330379776 1859325504 18.498 95 11 22 0 1873692624 11738144 2628976
18:30:27 48602 8192000000 10850454976 11312541696 1868064656 18.569 96 16 32 1 1880407776 7779600 4563520
18:31:31 47557 8192000000 10841925504 11303116800 1852565568 18.443 96 11 22 0 1868510832 12890976 3054288
18:32:24 31879 8192000000 10857436352 11299414016 1868612096 18.573 97 43 86 0 1891566720 11368816 11585808
18:33:03 20589 8192000000 10848874816 11297984512 1890911328 18.753 98 49 98 1 1919566176 14548832 14106016
18:33:31 24086 8192000000 10865064080 11315236864 1926501696 19.039 100 35 70 2 1945971056 9872336 9597024
18:34:02 27398 8192000000 10844928208 11309477888 1887440464 18.725 98 31 62 1 1907791120 12040064 8310592
18:34:35 59172 8192000000 10847536304 11317157888 1875400448 18.628 97 24 48 1 1894984176 12867168 6716560
18:35:40 38499 8192000000 10846918992 11307597824 1868360336 18.571 97 13 26 0 1886587728 14649328 3578064
18:36:25 41172 8192000000 10858140512 11317612544 1913929680 18.938 99 32 64 0 1932692416 10337584 8425152
18:37:13 22460 8192000000 10877589024 11313680384 1904497760 18.862 98 54 108 2 1933460944 13744192 15218992
18:37:44 27997 8192000000 10870821808 11324579840 1920590496 18.992 99 37 74 1 1946352528 15708208 10053824
18:38:20 65370 8192000000 10885082224 11343249408 1921964560 19.003 99 22 44 2 1937986080 10010400 6011120
18:39:31 76612 8192000000 10890711728 11366313984 1929990560 19.067 99 29 58 1 1959640304 21256368 8393376
18:40:54 115474 8192000000 10869771280 11327881216 1868649424 18.573 96 8 16 0 1894449424 23526304 2273696
18:42:56 132967 8192000000 10827084784 11284500480 1830214464 18.261 94 35 69 1 1850909488 10333328 10361696
18:45:15 50381 8192000000 10858984352 11300999168 1896231488 18.796 98 38 77 1 1914653440 7456864 10965088
18:46:12 57435 8192000000 10876114608 11341078528 1942776480 19.169 100 41 82 2 1968745936 14180512 11788944
18:47:17 44363 8192000000 10860561488 11340468224 1941217312 19.156 100 6 12 1 1954521984 11494752 1809920
18:48:08 72734 8192000000 10859466128 11335536640 1889053136 18.738 97 7 14 1 1903375632 12112352 2210144
18:49:44 61958 8192000000 10845085856 11315056640 1887224176 18.723 97 17 34 0 1903723712 11277520 5222016
18:51:00 29734 8192000000 10852258576 11330519040 1918982528 18.979 99 10 20 0 1931816272 9352656 3481088
18:51:39 58294 8192000000 10861259872 11328430080 1900517312 18.830 98 14 28 0 1913728112 9457008 3753792
18:52:45 51747 8192000000 10863893568 11336560640 1921837840 19.002 99 13 26 1 1934876800 9399824 3639136
18:53:43 58426 8192000000 10878061648 11349020672 1929748704 19.065 99 17 32 1 1946014848 11133920 5132224
18:55:24 58364 8192000000 10871973424 11335774208 1877976064 18.649 97 15 30 0 1894638848 12530256 4132528
18:56:39 79402 8192000000 10902612288 11368435712 1955248672 19.268 100 28 56 0 1978648256 15448080 7951504
18:58:12 47213 8192000000 10889888016 11354079232 1928279280 19.053 98 21 38 0 1945516896 12060624 5176992
18:59:06 131828 8192000000 10885336000 11355914240 1909028544 18.899 97 15 30 1 1925154480 11615200 4510736
19:01:24 67110 8192000000 10927419840 11375071232 1956527920 19.278 99 15 30 2 1974281456 13159456 4594080
19:02:40 56957 8192000000 10887543648 11370594304 1933697776 19.096 98 8 16 0 1954057456 18031072 2328608
19:03:47 30969 8192000000 10888028224 11352162304 1945241312 19.189 99 8 16 2 1954419024 7116752 2060960
19:04:29 20496 8192000000 10935389328 11373723648 1981043696 19.473 100 47 90 0 2001250048 6944256 13262096
19:05:00 97129 8192000000 10911486544 11374493696 1977410912 19.444 100 27 54 1 1995138528 10406800 7320816
19:06:49 74956 8192000000 10896981872 11371704320 1942759232 19.169 98 12 24 0 1957790640 11541904 3489504
19:08:11 57938 8192000000 10873557312 11353686016 1922898560 19.010 98 11 22 0 1937934144 12028480 3007104
19:09:36 60103 8192000000 10865555552 11345047552 1910322640 18.909 98 9 18 0 1926048800 13092752 2633408
19:10:42 47822 8192000000 10872508832 11349872640 1932983536 19.091 99 15 30 0 1953140912 15754672 4402704
19:11:58 21228 8192000000 10865107840 11341742080 1945988432 19.195 100 15 28 2 1962647920 12692080 3967408
19:12:29 64496 8192000000 10872634960 11359653888 1931579376 19.080 99 15 30 0 1948735760 12952560 4203824
19:13:44 35571 8192000000 10897661344 11346935808 1939867904 19.146 99 18 36 2 1954155664 9412112 4875648
19:14:40 28209 8192000000 10889557952 11349663744 1944478704 19.182 99 30 60 2 1961902816 8535888 8888224
19:15:16 40585 8192000000 10890602480 11348205568 1939248416 19.141 99 32 64 0 1964165360 15933552 8983392
19:16:03 60674 8192000000 10871902224 11338805248 1902532064 18.847 97 22 44 0 1920614720 11861648 6221008
19:17:14 63873 8192000000 10889599888 11354345472 1936422144 19.118 99 26 52 1 1952617744 9328560 6867040
19:18:24 40796 8192000000 10903448080 11372072960 1972157856 19.403 100 34 67 1 1993225136 11429392 9637888
19:19:13 31682 8192000000 10906312992 11366354944 1956065344 19.275 99 34 69 1 1979149968 12189456 10895168
19:19:52 61640 8192000000 10870683296 11355525120 1925631328 19.032 99 11 22 0 1944234400 15079472 3523600
19:21:12 46648 8192000000 10859315200 11311112192 1869815712 18.583 96 23 46 1 1883749248 8208560 5724976
19:22:06 56447 8192000000 10869629408 11340279808 1919228080 18.981 99 30 60 0 1942588016 15152032 8207904
19:23:11 88993 8192000000 10896750416 11345534976 1886481248 18.717 97 24 47 0 1904030928 11901072 5648608
19:24:50 104761 8192000000 10848595472 11318616064 1892457232 18.766 97 26 52 1 1910019008 9759088 7802688
19:26:51 25638 8192000000 9653642448 9982906368 798639968 8.883 42 6 12 0 803121744 2923856 1557920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-01-2021 19:29:03 to 22-01-2021 19:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 148 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-01-2021 19:29:35 to 22-01-2021 19:29:37.

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          240176
MON$OLDEST_ACTIVE               240177
MON$OLDEST_SNAPSHOT             240177
MON$NEXT_TRANSACTION            240177
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                       2004928
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:247: 
:248: mscs-test-161.budzdorov.ru    Fri Jan 22 19:27:18 2021
:249:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:250: 
:251: 
:252: mscs-test-161.budzdorov.ru    Fri Jan 22 19:27:18 2021
:253:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:254: 
:255: 
:256: mscs-test-161.budzdorov.ru    Fri Jan 22 19:27:18 2021
:257:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:258: 
:259: 
:260: mscs-test-161.budzdorov.ru    Fri Jan 22 19:27:18 2021
:261:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:262: 
:263: 
:264: mscs-test-161.budzdorov.ru    Fri Jan 22 19:27:18 2021
:265:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:266: 
--- end of diff output ---

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

22.01.21 19:29:38. 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-22 19:29:41 No severe PSQL-related problems occured
22.01.21 19:29:42. End of report.