Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.12.2020 01: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 17526816 kB
MemAvailable 31601884 kB
Buffers 0 kB
Cached 14201892 kB
SwapCached 3704 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 2020-12-10 01:27:02
DTS_END                         2020-12-10 01:27:02.9420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(570:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59670
TRN_ID                          251022
ATT_ID                          702
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: 9898.66 16584 1187839
customer order: creation 181.53 364 21783
customer order: refuse 14.80 308 1776
order to supplier: creation 49.81 1248 5977
order to supplier: removal 3.54 84109 425
invoice (draft): creation 48.10 2719 5772
invoice (draft): removal 54.95 740 6594
invoice accept: apply 44.26 15888 5311
invoice accept: cancel 50.69 679 6083
customer reserve: creation 4118.03 156 494164
customer reserve: removal 5019.11 46 602293
realization accept: apply 86.39 162 10367
realization accept: cancel 90.98 95 10918
payment from customer: creation 62.37 95 7484
payment from customer: removal 5.77 59 692
payment to supplier: creation 52.28 110 6273
payment to supplier: removal 3.70 48 444
service: total inventory turnovers 4.74 1142 569
service: total monetary turnovers 6.58 21 789
service: aggregate perf. data 1.01 16808 121
service: refresh index statistics 0.03 206887 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-12-2020 01:29:10 to 10-12-2020 01:29:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6871
TEST_TIME 2 5686
TEST_TIME 3 5457
TEST_TIME 4 5136
TEST_TIME 5 4992
TEST_TIME 6 4834
TEST_TIME 7 5045
TEST_TIME 8 5615
TEST_TIME 9 5787
TEST_TIME 10 5846
TEST_TIME 11 6690
TEST_TIME 12 6853
TEST_TIME 13 7519
TEST_TIME 14 8153
TEST_TIME 15 8711
TEST_TIME 16 9361
TEST_TIME 17 9528
TEST_TIME 18 10393
TEST_TIME 19 11423
TEST_TIME 20 11580
TEST_TIME 21 11800
TEST_TIME 22 11763
TEST_TIME 23 11813
TEST_TIME 24 11653
TEST_TIME 25 11201
TEST_TIME 26 11362
TEST_TIME 27 11016
TEST_TIME 28 10966
TEST_TIME 29 11002
TEST_TIME 30 11015
TEST_TIME 31 10836
TEST_TIME 32 10725
TEST_TIME 33 10640
TEST_TIME 34 10375
TEST_TIME 35 10292
TEST_TIME 36 10096
TEST_TIME 37 10142
TEST_TIME 38 10084
TEST_TIME 39 10147
TEST_TIME 40 10173
TEST_TIME 41 10162
TEST_TIME 42 10230
TEST_TIME 43 10179
TEST_TIME 44 10195
TEST_TIME 45 10286
TEST_TIME 46 10315
TEST_TIME 47 10232
TEST_TIME 48 10307
TEST_TIME 49 10479
TEST_TIME 50 10469
TEST_TIME 51 10444
TEST_TIME 52 10332
TEST_TIME 53 10404
TEST_TIME 54 10322
TEST_TIME 55 10284
TEST_TIME 56 10246
TEST_TIME 57 10167
TEST_TIME 58 10127
TEST_TIME 59 10044
TEST_TIME 60 9966
TEST_TIME 61 9978
TEST_TIME 62 10089
TEST_TIME 63 10006
TEST_TIME 64 10166
TEST_TIME 65 10085
TEST_TIME 66 10073
TEST_TIME 67 10085
TEST_TIME 68 10219
TEST_TIME 69 10186
TEST_TIME 70 10223
TEST_TIME 71 10317
TEST_TIME 72 10282
TEST_TIME 73 10339
TEST_TIME 74 10327
TEST_TIME 75 10203
TEST_TIME 76 10145
TEST_TIME 77 10081
TEST_TIME 78 10020
TEST_TIME 79 10079
TEST_TIME 80 10021
TEST_TIME 81 9989
TEST_TIME 82 9971
TEST_TIME 83 9961
TEST_TIME 84 9956
TEST_TIME 85 10006
TEST_TIME 86 9965
TEST_TIME 87 10037
TEST_TIME 88 10028
TEST_TIME 89 10079
TEST_TIME 90 10062
TEST_TIME 91 10071
TEST_TIME 92 10115
TEST_TIME 93 10199
TEST_TIME 94 10233
TEST_TIME 95 10204
TEST_TIME 96 10202
TEST_TIME 97 10119
TEST_TIME 98 10081
TEST_TIME 99 10037
TEST_TIME 100 10069
TEST_TIME 101 10003
TEST_TIME 102 10002
TEST_TIME 103 9964
TEST_TIME 104 9957
TEST_TIME 105 9899
TEST_TIME 106 9903
TEST_TIME 107 9899
TEST_TIME 108 9908
TEST_TIME 109 9894
TEST_TIME 110 9906
TEST_TIME 111 9888
TEST_TIME 112 9916
TEST_TIME 113 9933
TEST_TIME 114 9952
TEST_TIME 115 9917
TEST_TIME 116 9932
TEST_TIME 117 9976
TEST_TIME 118 9989
TEST_TIME 119 9989
TEST_TIME 120 9906

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-12-2020 01:29:14 to 10-12-2020 01:29:17.

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 1644958 1644958 0 0.00 0 27079 5 0 0
doc_list_biud 1644957 1644957 0 0.00 0 30005 22 0 0
sp_add_invoice_to_stock 5469 5311 158 2.88 28 139909 15888 0 158
sp_cancel_adding_invoice 6083 6083 0 0.00 5 50738 679 0 0
sp_cancel_client_order 1776 1776 0 0.00 4 16311 308 0 0
sp_cancel_customer_reserve 602293 602293 0 0.00 1 18524 46 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 3 3011 59 0 0
sp_cancel_pay_to_supplier 444 444 0 0.00 3 2621 49 0 0
sp_cancel_supplier_invoice 6608 6594 14 0.21 2 30021 741 0 14
sp_cancel_supplier_order 425 425 0 0.00 5 1009803 84109 0 0
sp_cancel_write_off 10918 10918 0 0.00 1 16397 96 0 0
sp_client_order 21783 21783 0 0.00 4 26468 365 0 0
sp_customer_reserve 494164 494164 0 0.00 0 80263 157 0 0
sp_fill_shopping_cart 33522 33522 0 0.00 1 11536 37 0 0
sp_fill_shopping_cart_clo_res 494142 494142 0 0.00 0 12063 13 0 0
sp_get_clo_for_invoice 5289 5289 0 0.00 0 25509 294 0 0
sp_kill_cost_storno 18137 18137 0 0.00 0 7027 42 0 0
sp_kill_qstorno_ret_qs2qd 1222523 1222523 0 0.00 0 29996 25 0 0
sp_kill_qty_storno 643745 643745 0 0.00 0 30003 56 0 0
sp_lock_selected_doc 21628 21628 0 0.00 0 8935 5 0 0
sp_make_cost_storno 29413 29413 0 0.00 0 26856 45 0 0
sp_multiply_rows_for_pdistr 29413 29413 0 0.00 0 15943 26 0 0
sp_multiply_rows_for_qdistr 21783 21783 0 0.00 0 25691 169 0 0
sp_pay_from_customer 7484 7484 0 0.00 4 16040 96 0 0
sp_pay_to_supplier 6273 6273 0 0.00 5 16106 110 0 0
sp_payment_common 13757 13757 0 0.00 1 15960 24 0 0
sp_qd_handle_on_cancel_clo 1776 1776 0 0.00 0 16306 275 0 0
sp_qd_handle_on_invoice_upd_sts 11372 11372 0 0.00 0 13070 275 0 0
sp_qd_handle_on_reserve_upd_sts 10367 10367 0 0.00 0 23948 53 0 0
sp_reserve_write_off 10367 10367 0 0.00 6 23988 162 0 0
sp_supplier_invoice 5772 5772 0 0.00 6 83093 2719 0 0
sp_supplier_order 5977 5977 0 0.00 5 50607 1249 0 0
srv_aggregate_perf_data 122 121 1 0.81 2789 248530 16808 0 1
srv_fill_mon_cache_memory 141 141 0 0.00 1074 136588 38555 0 0
srv_find_qd_qs_mism 1136914 1136914 0 0.00 0 11351 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 38 51368 1142 0 0
srv_make_money_saldo 789 789 0 0.00 1 2287 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 185060 245293 206888 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 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 5311 5311 0 0.00 0 15361 158 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 3041 90 0 0
t$perf-norm:sp_cancel_client_order 1776 1776 0 0.00 0 3466 15 0 0
t$perf-norm:sp_cancel_customer_reserve 706 706 0 0.00 0 1002 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 2534 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 444 444 0 0.00 0 517 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1813 15 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 21702 1395 0 0
t$perf-norm:sp_cancel_write_off 1099 1099 0 0.00 0 2651 6 0 0
t$perf-norm:sp_client_order 21783 21783 0 0.00 0 6239 14 0 0
t$perf-norm:sp_customer_reserve 1084 1084 0 0.00 0 930 3 0 0
t$perf-norm:sp_pay_from_customer 7484 7484 0 0.00 0 5400 7 0 0
t$perf-norm:sp_pay_to_supplier 6273 6273 0 0.00 0 7996 10 0 0
t$perf-norm:sp_reserve_write_off 10367 10367 0 0.00 0 6534 10 0 0
t$perf-norm:sp_supplier_invoice 5772 5772 0 0.00 0 3532 14 0 0
t$perf-norm:sp_supplier_order 5977 5977 0 0.00 0 3822 13 0 0
t$perf-norm:srv_aggregate_perf_data 121 121 0 0.00 0 77 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 141 141 0 0.00 0 2663 24 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1076 15 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 435 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10894 10578 316 2.90 0 6737 20 0 316
v_all_customers 40128 40128 0 0.00 0 203 1 0 0
v_all_suppliers 32498 32498 0 0.00 0 122 1 0 0
v_all_wares 43566 43566 0 0.00 0 121 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 1813 8 0 0
v_cancel_client_order 3552 3552 0 0.00 0 6205 5 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 2889 8 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 2032 5 0 0
v_cancel_payment_to_supplier 888 888 0 0.00 0 2600 5 0 0
v_cancel_supplier_invoice 824 796 28 3.39 0 4179 26 0 28
v_cancel_supplier_order 850 850 0 0.00 0 6135 10 0 0
v_cancel_write_off 2198 2198 0 0.00 0 3981 15 0 0
v_max_id_clo_ord 5976 5976 0 0.00 0 427 1 0 0
v_max_id_clo_res 1084 1084 0 0.00 0 2408 17 0 0
v_max_id_ord_sup 5763 5763 0 0.00 0 8315 8 0 0
v_max_non_paid_invoice 1763 1763 0 0.00 0 448 2 0 0
v_max_non_paid_realizn 3732 3732 0 0.00 0 619 3 0 0
v_min_id_clo_ord 5976 5976 0 0.00 0 11065 11 0 0
v_min_id_clo_res 1084 1084 0 0.00 0 3211 7 0 0
v_min_id_ord_sup 5763 5763 0 0.00 0 5372 5 0 0
v_min_non_paid_invoice 6273 6273 0 0.00 0 12413 14 0 0
v_min_non_paid_realizn 7484 7484 0 0.00 0 12480 17 0 0
v_our_firm 10942 10942 0 0.00 0 216 1 0 0
v_reserve_write_off 20734 20734 0 0.00 0 6551 7 0 0
x_lock_depdocs_on_canc_invoice 12279 12279 0 0.00 0 15449 102 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 5102 249 0 0
x_make_qstorno_1000_1200 5977 5977 0 0.00 1 50596 1176 0 0
x_make_qstorno_1200_2000 5772 5772 0 0.00 3 83072 2592 0 0
x_make_qstorno_2100_3300 494164 494164 0 0.00 0 80260 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-12-2020 01:29:18 to 10-12-2020 01:29:22.

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
22:57:06 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 13086 8192000000 10238751248 10548764672 995057888 10.831 75 58 116 0 1016447584 2727664 18662032
22:57:35 28909 8192000000 10359208720 10675908608 1392458640 14.528 100 81 162 0 1423717520 4787328 26471552
22:58:14 32991 8192000000 10416726144 10742956032 1460225200 15.128 100 90 180 0 1495120384 6455264 28439920
22:59:00 29404 8192000000 10438932736 10770702336 1494937520 15.432 100 93 186 0 1532342976 7697168 29708288
22:59:41 30594 8192000000 10471260432 10807062528 1506761248 15.535 100 83 166 2 1541888736 8190048 26937440
23:00:23 12577 8192000000 10487257360 10827649024 1541256976 15.834 100 90 180 0 1578836112 9126032 28453104
23:00:47 20208 8192000000 10502900880 10845540352 1555622656 15.958 100 84 168 0 1591067008 9464320 25980032
23:01:23 15386 8192000000 10520421872 10866569216 1573040656 16.108 100 83 166 0 1608561104 10368048 25152400
23:01:47 11116 8192000000 10544861472 10895683584 1598710000 16.328 100 82 164 0 1634327472 10738224 24879248
23:02:10 12671 8192000000 10562654832 10920898560 1618809776 16.500 100 74 145 3 1651325888 10888208 21627904
23:02:31 13559 8192000000 10587684784 10949001216 1635713856 16.643 100 75 150 3 1668956112 11426816 21815440
23:02:56 9604 8192000000 10609499552 10973421568 1666120384 16.900 100 82 165 3 1703101040 12635856 24344800
23:03:16 8696 8192000000 10622294448 10992205824 1685439024 17.063 100 77 154 0 1719920688 12308288 22173376
23:03:33 7003 8192000000 10641192640 11013406720 1707365440 17.247 100 82 164 1 1743947088 12802704 23778944
23:03:48 7598 8192000000 10661589488 11033518080 1721253856 17.363 100 74 147 3 1754933600 12718512 20961232
23:04:02 6144 8192000000 10660560800 11035250688 1729211424 17.429 100 76 149 2 1763579120 13318288 21049408
23:04:16 6979 8192000000 10673721584 11054985216 1740221600 17.520 100 75 150 0 1774942176 13355760 21364816
23:04:29 6200 8192000000 10684863056 11063840768 1753736112 17.633 100 74 148 1 1786957312 12344688 20876512
23:04:42 5038 8192000000 10705352080 11082711040 1763176928 17.711 100 78 156 1 1797697040 13098640 21421472
23:04:53 4723 8192000000 10709538864 11088584704 1773662528 17.797 100 86 170 1 1810784640 13928032 23194080
23:05:10 6401 8192000000 10719472528 11102003200 1780349696 17.852 100 77 153 2 1814240656 13053632 20837328
23:05:23 3303 8192000000 10742875856 11127738368 1801547696 18.027 100 88 174 1 1839829456 12913360 25368400
23:05:34 3038 8192000000 10746446544 11133022208 1810375008 18.099 100 81 161 0 1846729056 13273168 23080880
23:05:44 3236 8192000000 10758343392 11148021760 1821717776 18.192 100 85 171 2 1858292576 12276560 24298240
23:05:55 2651 8192000000 10773784176 11160145920 1830446160 18.263 100 85 171 0 1866649712 11978480 24225072
23:06:04 3022 8192000000 10777248544 11166416896 1836398304 18.311 100 81 163 2 1872868816 13356800 23113712
23:06:14 1778 8192000000 10787474368 11173953536 1843264832 18.367 100 91 185 0 1883418736 14078640 26075264
23:06:22 2297 8192000000 10791654720 11176411136 1843032832 18.365 100 86 173 0 1881194448 14439792 23721824
23:06:31 2492 8192000000 10795105648 11180032000 1844563232 18.378 100 85 167 1 1882793904 14051200 24179472
23:06:40 2015 8192000000 10791607760 11184136192 1849421056 18.417 100 87 172 1 1887710464 13422912 24866496
23:06:48 1586 8192000000 10799555200 11189792768 1856277488 18.473 100 89 178 2 1893880336 12707504 24895344
23:06:56 1548 8192000000 10807764976 11191754752 1858584640 18.492 100 91 182 0 1898096352 12640800 26870912
23:07:04 1683 8192000000 10798984816 11187077120 1857434064 18.482 100 89 179 2 1894663312 12529936 24699312
23:07:12 2284 8192000000 10805533488 11194540032 1863237440 18.530 100 87 174 1 1898698480 11815792 23645248
23:07:21 1951 8192000000 10811087840 11198779392 1864641184 18.541 100 85 171 2 1901521840 12792976 24087680
23:07:29 2316 8192000000 10793967056 11196850176 1867167680 18.561 100 84 168 0 1904138544 13070912 23899952
23:07:43 2256 8192000000 10797872688 11201187840 1865265536 18.546 100 61 122 0 1893721360 10586432 17869392
23:07:52 4218 8192000000 10788394048 11199496192 1865307408 18.546 100 45 88 1 1887692976 9860592 12524976
23:08:04 1749 8192000000 10813660336 11214147584 1874616832 18.622 100 74 148 4 1905179040 9245504 21316704
23:08:12 1734 8192000000 10802061376 11211644928 1876544688 18.637 100 64 129 0 1906567936 11917152 18106096
23:08:21 2599 8192000000 10808553184 11213512704 1875919552 18.632 100 62 122 1 1903418592 10782304 16716736
23:08:31 5578 8192000000 10787928832 11205963776 1874071552 18.617 100 36 72 0 1892254304 7862736 10320016
23:08:43 5065 8192000000 10790679760 11205791744 1873196432 18.610 100 32 62 2 1888808864 5844864 9767568
23:08:54 8963 8192000000 10781077936 11208921088 1875656784 18.630 100 32 63 2 1891767648 7333056 8777808
23:09:15 6435 8192000000 10779782256 11214106624 1878915760 18.656 100 21 42 2 1891076160 6547120 5613280
23:09:28 5961 8192000000 10783405664 11215953920 1879208208 18.659 100 25 51 3 1893210976 6956912 7045856
23:09:44 8628 8192000000 10781737952 11213590528 1876681872 18.638 100 10 20 2 1885163968 5861872 2620224
23:09:59 13093 8192000000 10796412112 11216621568 1880012720 18.665 100 14 28 0 1889371680 5386864 3972096
23:10:18 29000 8192000000 10797398816 11229507584 1882462480 18.685 100 19 39 4 1893396656 5699904 5234272
23:11:19 5341 8192000000 10814763104 11234443264 1889479552 18.742 100 49 93 3 1909857792 6974000 13404240
23:11:32 7522 8192000000 10791432096 11232604160 1887906592 18.729 100 25 49 1 1901338960 6848592 6583776
23:11:46 5215 8192000000 10815141136 11238539264 1890838784 18.753 100 32 66 0 1907137120 7470288 8828048
23:12:00 9930 8192000000 10807319648 11239518208 1892003984 18.762 100 25 50 2 1905070704 6171952 6894768
23:12:18 5252 8192000000 10814018592 11243765760 1895237952 18.788 100 41 82 2 1915145136 8181472 11725712
23:12:29 7653 8192000000 10811757600 11240853504 1892372608 18.765 100 25 50 3 1905277024 5747440 7156976
23:12:46 5987 8192000000 10812477808 11243233280 1893720768 18.776 100 24 48 2 1906595840 5157376 7717696
23:13:01 8662 8192000000 10797881552 11238375424 1895049696 18.786 100 21 42 2 1906375600 5768656 5557248
23:13:15 11274 8192000000 10802082816 11241840640 1896652848 18.799 100 15 29 3 1906135088 5521952 3960288
23:13:35 6807 8192000000 10805343520 11242418176 1897314112 18.805 100 29 59 0 1911459568 5658400 8487056
23:13:50 6297 8192000000 10803917760 11235663872 1876226480 18.635 99 22 44 1 1888704944 6071936 6406528
23:14:07 9747 8192000000 10800831264 11240865792 1894414656 18.781 100 29 53 4 1908595872 5549232 8631984
23:14:24 7205 8192000000 10807049936 11241385984 1893794176 18.776 100 18 37 2 1904361856 5375872 5191808
23:14:40 7041 8192000000 10815639264 11247857664 1894668848 18.783 100 22 43 2 1910756192 10320640 5766704
23:14:53 13485 8192000000 10799585712 11234811904 1862245248 18.521 98 22 44 0 1873204768 4964832 5994688
23:15:16 59445 8192000000 10815340608 11231440896 1858130512 18.488 98 30 60 1 1872359072 5279472 8949088
23:16:21 9064 8192000000 10781970032 11222724608 1868105440 18.569 99 17 34 1 1878450784 5799616 4545728
23:16:37 8258 8192000000 10793843248 11226021888 1843014736 18.365 98 23 46 0 1863431168 14404080 6012352
23:16:52 6863 8192000000 10763174448 11193892864 1800417040 18.017 96 24 48 1 1812315968 5029728 6869200
23:17:08 8273 8192000000 10775995312 11204067328 1861722672 18.517 100 35 70 7 1878094928 7308992 9063264
23:17:23 7583 8192000000 10763789968 11186094080 1793223360 17.958 96 25 50 0 1806627008 6033296 7370352
23:17:39 6301 8192000000 10769935472 11190910976 1822725584 18.200 98 27 54 2 1836594160 5621792 8246784
23:17:52 5069 8192000000 10740342848 11166281728 1818473072 18.165 99 29 58 1 1833024432 6328144 8223216
23:18:05 8979 8192000000 10669490416 11081379840 1693685744 17.132 93 36 72 0 1710323824 5536032 11102048
23:18:24 13419 8192000000 10696074848 11110404096 1705227440 17.229 95 15 30 2 1714989264 5586256 4175568
23:18:47 10788 8192000000 10720450064 11137908736 1784627680 17.888 99 18 36 2 1794532144 5033312 4871152
23:19:05 16712 8192000000 10683744896 11103674368 1673542976 16.963 93 13 26 1 1682365680 5153696 3669008
23:19:33 26118 8192000000 10704041856 11127652352 1762636768 17.706 98 23 46 2 1775035616 5495648 6903200
23:20:35 19055 8192000000 10696907008 11124842496 1730100048 17.436 96 11 22 1 1738084208 4928400 3055760
23:21:00 13237 8192000000 10714672304 11137798144 1772769904 17.790 98 13 25 2 1782064064 5987568 3306592
23:21:19 6314 8192000000 10726078656 11139706880 1788985296 17.923 99 29 58 0 1803374768 6145792 8243680
23:21:33 7584 8192000000 10741289840 11162353664 1824721136 18.216 100 36 72 2 1841923120 7164272 10037712
23:21:49 4326 8192000000 10743411152 11166519296 1832128976 18.277 100 35 69 1 1849072608 7317136 9626496
23:22:01 7493 8192000000 10753547040 11173089280 1836342176 18.311 100 21 42 0 1848143440 5656592 6144672
23:22:16 9436 8192000000 10766039440 11184558080 1843109184 18.366 100 19 38 2 1853688672 5626752 4952736
23:22:32 9494 8192000000 10747409632 11176202240 1840063616 18.341 100 20 39 1 1851086016 5465216 5557184
23:22:47 14000 8192000000 10770572544 11195863040 1852793072 18.445 100 23 45 4 1868452336 9757392 5901872
23:23:09 11777 8192000000 10756331632 11187912704 1851048048 18.431 100 17 34 0 1861392608 5194304 5150256
23:23:29 11512 8192000000 10765107504 11196522496 1856423328 18.474 100 14 27 1 1866419808 5723696 4272784
23:23:47 7508 8192000000 10777177440 11204026368 1864365696 18.539 100 29 58 3 1877795024 4857936 8571392
23:24:02 9089 8192000000 10779182992 11207258112 1863303952 18.530 100 11 22 0 1872581216 5530976 3746288
23:24:19 15253 8192000000 10771421584 11207933952 1864194496 18.537 100 15 29 1 1873617040 5689840 3732704
23:24:40 13947 8192000000 10797177328 11217104896 1874476960 18.620 100 35 69 0 1890992400 6744704 9770736
23:25:03 66095 8192000000 10789958528 11222990848 1876623856 18.638 100 25 50 3 1889387856 5839680 6924320
23:26:17 7491 8192000000 10798282144 11227533312 1882924432 18.689 100 29 58 1 1897174832 6146176 8104224
23:26:31 7487 8192000000 10800529360 11230420992 1885055376 18.706 100 31 62 2 1899645216 6170672 8419168
23:26:45 4406 8192000000 10806780880 11234660352 1887505520 18.726 100 36 72 2 1908389344 11082688 9801136
23:26:56 6160 8192000000 10815343472 11235315712 1886953024 18.721 100 26 52 4 1900463168 5930064 7580080
23:27:27 37217 8192000000 10841401408 11266805760 1912158640 18.924 100 37 73 1 1928900688 6907040 9835008
23:28:13 19111 8192000000 10859809376 11282862080 1929519536 19.063 100 61 120 2 1959499968 11384464 18595968
23:28:48 4847 8192000000 10870452528 11293831168 1936455536 19.118 100 57 112 3 1964107776 11667824 15984416
23:29:00 29805 8192000000 10870404128 11298643968 1940076224 19.147 100 49 96 0 1964701712 11549056 13076432
23:29:36 7756 8192000000 10889656912 11308150784 1948060208 19.211 100 54 103 0 1976113936 14187824 13865904
23:29:53 18770 8192000000 10905137008 11327692800 1959131920 19.299 100 54 107 0 1994328048 20111152 15084976
23:30:23 25626 8192000000 10896285024 11326115840 1943503488 19.175 99 58 116 0 1980888960 21003568 16381904
23:31:02 22293 8192000000 10899840240 11336294400 1962278224 19.324 100 32 64 0 1993744080 21851872 9613984
23:31:52 27146 8192000000 10895246432 11333206016 1945394976 19.190 99 39 77 0 1980818592 23622336 11801280
23:32:34 42582 8192000000 10903353872 11346731008 1965191920 19.347 100 27 54 1 1998608736 25134128 8282688
23:33:24 9070 8192000000 10920494000 11357290496 1974350352 19.420 100 35 68 2 2009125168 25085472 9689344
23:33:47 14407 8192000000 10923698384 11359498240 1977856432 19.448 100 43 86 2 2018783152 27667808 13258912
23:34:08 13807 8192000000 10937952960 11371081728 1984065904 19.497 100 41 82 2 2026650960 30135072 12449984
23:34:31 12299 8192000000 10935494064 11368415232 1966030832 19.354 99 49 96 1 2010479680 29325344 15123504
23:35:00 18098 8192000000 10952467648 11388203008 1996254128 19.593 100 54 108 0 2048360224 35363760 16742336
23:35:24 4783 8192000000 10965440992 11388067840 1998606336 19.612 100 52 103 2 2049701936 35571808 15523792
23:35:36 1664 8192000000 10969217152 11381305344 1990060512 19.544 99 78 154 2 2049130864 34540864 24529488
23:35:47 1960 8192000000 10984373568 11405299712 2006722976 19.676 100 68 137 0 2067272048 40266048 20283024
23:35:56 12400 8192000000 10964525008 11397132288 1985421360 19.508 99 54 108 0 2039402944 37544176 16437408
23:36:23 4103 8192000000 10974882368 11398664192 2004885632 19.661 100 59 115 2 2057888304 35829296 17173376
23:36:34 6545 8192000000 10964267488 11395227648 2001307632 19.633 100 67 134 1 2058521568 36523840 20690096
23:36:49 3216 8192000000 10971326384 11394555904 1999895888 19.622 100 69 138 2 2058611744 37056160 21659696
23:37:00 4490 8192000000 10974799840 11400855552 2005264864 19.664 100 67 134 2 2064217248 38365120 20587264
23:37:15 1571 8192000000 10995891904 11406331904 2009953360 19.701 100 80 158 1 2074594384 39489520 25151504
23:37:24 1073 8192000000 10984847008 11410468864 2013567264 19.730 100 72 143 1 2074891824 39343200 21981360
23:37:33 2247 8192000000 10960948144 11379945472 1986911904 19.519 99 78 156 0 2050979648 40770672 23297072
23:37:43 4988 8192000000 10964661744 11384692736 1976049648 19.433 99 69 137 2 2039043984 41718224 21276112
23:37:58 2229 8192000000 10987127648 11405766656 2002570208 19.643 100 87 169 1 2071816992 43813232 25433552
23:38:10 2817 8192000000 10960855120 11378470912 1990170400 19.545 99 77 154 2 2053815872 39705184 23940288
23:38:20 4060 8192000000 10976412976 11404873728 2005345232 19.665 100 68 137 0 2066193472 39967504 20880736
23:38:32 2494 8192000000 10993583552 11411849216 2014599760 19.738 100 78 154 1 2079228912 40811808 23817344
23:38:43 1081 8192000000 10993976176 11404132352 2004994288 19.662 99 86 173 5 2071960656 40784480 26181888
23:38:51 3113 8192000000 10998963280 11416371200 2016450080 19.752 100 88 174 1 2085973984 42305808 27218096
23:39:02 1814 8192000000 10990549760 11406872576 1978628816 19.454 98 81 160 1 2048348432 43258224 26461392
23:39:11 6695 8192000000 10984927888 11405516800 2002931952 19.646 100 70 140 1 2070620192 45696048 21992192
23:39:27 3968 8192000000 10956579072 11379712000 1960073440 19.307 98 66 132 1 2028103792 46713920 21316432
23:39:42 4444 8192000000 10982148256 11407941632 1995869712 19.590 100 71 141 0 2064419312 46459360 22090240
23:39:54 3736 8192000000 10980114320 11405590528 1996346512 19.594 100 75 147 1 2071794960 52945728 22502720
23:40:08 1589 8192000000 10954490544 11366461440 1963005872 19.330 99 85 168 2 2038790192 49206912 26577408
23:40:16 1847 8192000000 10964801440 11382644736 1961383744 19.317 99 80 158 0 2035291328 48885712 25021872
23:40:25 2091 8192000000 10971500928 11382370304 1975088272 19.426 100 87 171 4 2049971232 48939488 25943472
23:40:33 1827 8192000000 10970103152 11376218112 1955148128 19.267 99 92 185 3 2038606000 55184800 28273072
23:40:43 4530 8192000000 10955628144 11372122112 1963714960 19.336 100 84 166 2 2041738784 51726112 26297712
23:40:55 4359 8192000000 10966438880 11387240448 1979521552 19.461 100 79 155 0 2051664560 48330512 23812496
23:41:06 5720 8192000000 10972529056 11394097152 1989629088 19.541 100 70 140 0 2061963280 50148016 22186176
23:41:25 2856 8192000000 10974002752 11388035072 1976832928 19.440 100 84 169 1 2057103216 54237104 26033184
23:41:35 3432 8192000000 10951215696 11362144256 1958001968 19.290 100 79 157 1 2032183344 50133296 24048080
23:41:45 6700 8192000000 10947159616 11365281792 1953440320 19.254 99 67 134 1 2028333424 53398320 21494784
23:41:59 11249 8192000000 10937174352 11372072960 1962546480 19.326 100 45 90 1 2025189632 47637616 15005536
23:42:17 13300 8192000000 10923166896 11356028928 1911465920 18.918 98 34 68 0 1975181776 51396752 12319104
23:42:40 8103 8192000000 10926072800 11359264768 1950758944 19.233 100 47 92 1 2012550272 46069136 15722192
23:42:56 13434 8192000000 10914726688 11348717568 1925754992 19.033 99 33 66 2 1988029696 50006768 12267936
23:43:19 14479 8192000000 10879246528 11329658880 1906670656 18.880 98 29 58 1 1959598736 42656464 10271616
23:43:39 14184 8192000000 10893082784 11335811072 1933159200 19.092 100 31 62 3 1983722272 40054528 10508544
23:44:00 16353 8192000000 10891083296 11329052672 1898725568 18.816 98 37 74 2 1953644176 41566848 13351760
23:44:35 21787 8192000000 10889643280 11328659456 1917573296 18.967 100 28 56 0 1976283392 48538032 10172064
23:45:04 14874 8192000000 10886046208 11324125184 1880507392 18.669 98 30 60 0 1936946592 45664432 10774768
23:45:26 29684 8192000000 10857130288 11307376640 1824118240 18.211 95 25 50 1 1877688816 44828688 8741888
23:46:04 21106 8192000000 10849943440 11290103808 1881059632 18.674 99 17 34 1 1914907712 27985504 5862576
23:46:32 51726 8192000000 10863741680 11311849472 1890723696 18.752 99 18 36 0 1925074560 28863440 5487424
23:48:00 36886 8192000000 10838249936 11289337856 1854218208 18.456 97 9 19 0 1877857776 20430976 3208592
23:48:43 29120 8192000000 10841047408 11289137152 1889542704 18.742 99 22 45 1 1909730304 14026688 6160912
23:49:19 48037 8192000000 10836629568 11304468480 1891314912 18.756 99 11 21 0 1917909456 22398864 4195680
23:50:29 128227 8192000000 10866652192 11323871232 1924125952 19.020 100 24 49 3 1946192336 15509856 6556528
23:52:48 97321 8192000000 10865298416 11322281984 1906946192 18.882 99 15 30 0 1920287280 8880816 4460272
23:54:43 97970 8192000000 10874283968 11320242176 1882072688 18.682 97 34 68 0 1899286208 7864176 9349344
23:56:36 115533 8192000000 10836816336 11305955328 1822124080 18.195 94 11 22 0 1837579184 12412576 3042528
23:58:38 16608 8192000000 10853619536 11322961920 1937701408 19.128 100 8 16 1 1948391248 8922496 1767344
23:59:02 9467 8192000000 10863869456 11319910400 1939269632 19.141 100 8 16 1 1950319584 9185648 1864304
23:59:20 31608 8192000000 10882216080 11341414400 1954619760 19.263 100 37 73 1 1972188496 8198480 9370256
00:00:09 36775 8192000000 10875395408 11337842688 1954453088 19.262 100 13 26 1 1964733232 6884672 3395472
00:00:52 79225 8192000000 10896025920 11352227840 1961416624 19.317 100 28 56 0 1979698160 11107680 7173856
00:02:30 54460 8192000000 10886814384 11363618816 1968796384 19.376 100 12 24 0 1979534688 7870384 2867920
00:04:04 51414 8192000000 10882528192 11345453056 1930582576 19.072 98 9 18 0 1940234528 7650864 2001088
00:05:04 42049 8192000000 10912972368 11375349760 1973002560 19.409 100 16 32 1 1985952512 8602896 4347056
00:05:53 54766 8192000000 10923045056 11379183616 1945581680 19.191 98 21 42 2 1964057936 12673072 5803184
00:06:57 27565 8192000000 10905333488 11366469632 1962314976 19.324 99 29 58 1 1982674256 12320448 8038832
00:07:31 44187 8192000000 10905670704 11379535872 1961869744 19.321 99 23 46 0 1977628128 9463456 6294928
00:08:26 85375 8192000000 10903623856 11383283712 1945739888 19.193 98 23 46 1 1968832512 16718240 6374384
00:09:59 20483 8192000000 10942555984 11389464576 1996618528 19.596 100 59 120 2 2021043072 8014048 16410496
00:10:27 23583 8192000000 10935739760 11394244608 2001117072 19.632 100 48 96 3 2026015376 11621200 13277104
00:11:00 37747 8192000000 10946763776 11405520896 1999206416 19.616 100 28 56 2 2018694816 11663456 7824944
00:11:53 63764 8192000000 10932812448 11410628608 2004251376 19.656 100 19 38 2 2023515024 13582560 5681088
00:13:03 91000 8192000000 10969375536 11427139584 1993309008 19.570 99 27 54 2 2016748192 15416496 8022688
00:14:42 54356 8192000000 10952293952 11435974656 2017452944 19.760 100 17 34 1 2043869728 21191296 5225488
00:15:52 53150 8192000000 10906877968 11384070144 1924881424 19.026 96 6 12 0 1940493632 14264240 1347968
00:17:04 36821 8192000000 10944189968 11395272704 1978024720 19.449 99 21 43 0 1996376656 12674064 5677872
00:17:48 29401 8192000000 10926440368 11402571776 1957255824 19.284 98 26 52 1 1986376064 21934144 7186096
00:19:53 75281 8192000000 10903554464 11358445568 1894738256 18.784 95 26 51 2 1914023520 12000992 7284272
00:21:27 52151 8192000000 10874605680 11353694208 1944523024 19.183 99 19 38 1 1961200608 11112560 5565024
00:22:26 73340 8192000000 10878709632 11360911360 1927411568 19.046 98 5 10 1 1939000336 10474320 1114448
00:23:50 53164 8192000000 10883219600 11361767424 1928775616 19.057 98 8 16 0 1941925472 11049936 2099920
00:24:56 59457 8192000000 10844176208 11322753024 1867765824 18.566 95 10 20 1 1880425168 9837520 2821824
00:26:14 43801 8192000000 10832084288 11292151808 1845518224 18.386 95 22 44 2 1858121232 6846896 5756112
00:27:17 54291 8192000000 10851195840 11310510080 1866450432 18.556 96 17 34 0 1883153584 12498672 4204480
00:29:11 68783 8192000000 10866870896 11325894656 1842471504 18.361 95 12 24 1 1853715152 8194128 3049520
00:30:51 46342 8192000000 10837699536 11306385408 1872220096 18.602 97 22 43 1 1886666784 8514128 5932560
00:31:49 38413 8192000000 10882618880 11344715776 1943381488 19.174 100 26 50 3 1962192320 11821296 6989536
00:32:43 31075 8192000000 10858741360 11320557568 1878877488 18.656 97 33 66 0 1902488112 14475824 9134800
00:33:21 63041 8192000000 10860421424 11324891136 1870020256 18.584 97 37 74 1 1900958240 20909648 10028336
00:34:52 96553 8192000000 10847890288 11303759872 1866462704 18.556 97 21 42 0 1894379280 21972272 5944304
00:36:35 50774 8192000000 10851733808 11298709504 1869678384 18.582 97 34 68 1 1889936304 10918656 9339264
00:37:33 110552 8192000000 10867054720 11325251584 1859462896 18.499 97 8 16 2 1881855392 20106384 2286112
00:39:32 83858 8192000000 10848232912 11314966528 1859699920 18.501 97 17 34 2 1884222640 19638112 4884608
00:41:02 136587 8192000000 10861972512 11317952512 1895860144 18.793 98 18 36 0 1910438880 9887808 4690928
00:43:27 55950 8192000000 10874765360 11328118784 1897748240 18.808 98 17 34 0 1913156016 10877824 4529952
00:44:43 46064 8192000000 10881551264 11341230080 1929313952 19.061 99 33 66 0 1954832800 16348112 9170736
00:45:52 38565 8192000000 10876711296 11349504000 1919861632 18.986 98 35 70 1 1945465184 15157840 10445712
00:46:40 45099 8192000000 10864073200 11349995520 1948292752 19.213 100 8 16 0 1963571888 12876048 2403088
00:47:46 78222 8192000000 10880647952 11356979200 1953428160 19.254 100 9 18 0 1968599296 12676464 2494672
00:49:16 67783 8192000000 10886035520 11374870528 1961532304 19.318 100 11 22 0 1979193168 14156704 3504160
00:50:30 71050 8192000000 10908717824 11365052416 1952911168 19.250 99 18 36 0 1969350928 10731872 5707888
00:51:51 44961 8192000000 10910865168 11376410624 1956559744 19.279 99 42 84 3 1976741040 8323728 11857568
00:52:46 45814 8192000000 10910489472 11381772288 1982026912 19.481 100 16 32 1 1999018736 11904848 5086976
00:53:59 71200 8192000000 10912587360 11368906752 1946992464 19.203 98 25 50 2 1966674112 12547648 7134000
00:55:22 58190 8192000000 10903892608 11373768704 1938850944 19.138 98 27 54 2 1959320976 13017360 7452672
00:56:30 50557 8192000000 10891233712 11366166528 1944216592 19.180 99 12 24 0 1959801104 12550864 3033648
00:58:00 45990 8192000000 10923226784 11383808000 1954480400 19.262 98 26 52 2 1971810016 10541136 6788480
00:58:52 40114 8192000000 10919665840 11394863104 1986384928 19.515 100 22 44 0 2005970832 13671600 5914304
00:59:41 44941 8192000000 10920017664 11393970176 1953667472 19.256 98 18 36 0 1973828176 15237360 4923344
01:00:33 68023 8192000000 10948687024 11423256576 1995537312 19.588 100 17 34 0 2017955536 17368288 5049936
01:01:50 67506 8192000000 10927486032 11404521472 1962928608 19.329 98 18 36 3 1985861920 17674720 5258592
01:03:03 100569 8192000000 10907228880 11374297088 1965454464 19.349 99 14 28 0 1978319488 8765008 4100016
01:05:00 117135 8192000000 10952835232 11426459648 2005464000 19.666 100 29 58 1 2030856512 17334560 8057952
01:07:19 21642 8192000000 10936293808 11423977472 1988969776 19.536 99 25 50 1 2019868768 23528656 7370336
01:07:47 32436 8192000000 10932918736 11432030208 2000485520 19.627 100 6 12 0 2028233520 26270720 1477280
01:08:32 71514 8192000000 10909277056 11385782272 1963041776 19.330 98 10 20 1 1976317072 10257520 3017776
01:10:33 56806 8192000000 10882044208 11351470080 1933013328 19.091 97 19 39 0 1950059248 10853088 6192832
01:11:42 78169 8192000000 10890224368 11358781440 1920322768 18.989 97 12 24 1 1934696976 11169312 3204896
01:13:09 69882 8192000000 10885610768 11366313984 1951493392 19.238 99 14 27 0 1965043696 10084432 3465872
01:14:26 75504 8192000000 10878290864 11347279872 1868904048 18.575 95 9 18 1 1882664528 11565856 2194624
01:15:50 53724 8192000000 10879295184 11344658432 1903498848 18.854 97 35 70 0 1920935136 7360320 10075968
01:16:51 45041 8192000000 10893192096 11364061184 1945652336 19.192 99 25 50 3 1965350576 12830208 6868032
01:17:42 87688 8192000000 10871165520 11336257536 1844953712 18.381 94 14 28 1 1863440560 14901008 3585840
01:19:23 44667 8192000000 10872826784 11329314816 1896663392 18.799 98 28 56 0 1921540112 17450560 7426160
01:20:20 59328 8192000000 10841852944 11302191104 1827130368 18.236 94 16 32 0 1841589792 9694560 4764864
01:21:30 65552 8192000000 10853248320 11298705408 1813459616 18.124 94 23 46 1 1837584704 17896672 6228416
01:22:42 29193 8192000000 10855744416 11304534016 1829030832 18.251 95 40 80 1 1851481824 11138880 11312112
01:23:29 31983 8192000000 10838146256 11311050752 1890811280 18.752 99 26 52 0 1914388928 15524208 8053440
01:24:16 97219 8192000000 10812608928 11272441856 1776767264 17.823 93 12 24 0 1791342144 11283920 3290960
01:26:00 70020 8192000000 9849971632 10204295168 896651008 9.865 47 12 24 0 906288464 6424096 3213360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 10-12-2020 01:29:24 to 10-12-2020 01:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 158 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-12-2020 01:29:54 to 10-12-2020 01:29:56.

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          250402
MON$OLDEST_ACTIVE               251264
MON$OLDEST_SNAPSHOT             251264
MON$NEXT_TRANSACTION            251264
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                       2028192
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:249: 
:250: mscs-test-161.budzdorov.ru    Thu Dec 10 01:27:30 2020
:251:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:252: 
:253: 
:254: mscs-test-161.budzdorov.ru    Thu Dec 10 01:27:35 2020
:255:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:256: 
:257: 
:258: mscs-test-161.budzdorov.ru    Thu Dec 10 01:27:39 2020
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
--- end of diff output ---

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

10.12.20 01:29:57. 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
2020-12-10 01:29:59 No severe PSQL-related problems occured
10.12.20 01:30:00. End of report.