Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.12.2020 16: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 17533296 kB
MemAvailable 31470420 kB
Buffers 0 kB
Cached 14191024 kB
SwapCached 4820 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-29 16:27:09
DTS_END                         2020-12-29 16:27:09.0320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58658
TRN_ID                          236557
ATT_ID                          686
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: 8860.91 28904 1063309
customer order: creation 162.28 373 19474
customer order: refuse 14.48 397 1738
order to supplier: creation 43.97 1301 5276
order to supplier: removal 3.32 101777 398
invoice (draft): creation 44.84 3288 5381
invoice (draft): removal 49.58 778 5949
invoice accept: apply 40.29 17699 4835
invoice accept: cancel 44.82 894 5378
customer reserve: creation 3730.43 175 447651
customer reserve: removal 4442.02 60 533043
realization accept: apply 79.88 169 9586
realization accept: cancel 79.26 106 9511
payment from customer: creation 57.65 111 6918
payment from customer: removal 5.63 103 675
payment to supplier: creation 47.34 142 5681
payment to supplier: removal 3.57 64 428
service: total inventory turnovers 4.47 1393 537
service: total monetary turnovers 6.26 28 751
service: aggregate perf. data 0.79 20560 95
service: refresh index statistics 0.03 428670 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 29-12-2020 16:29:14 to 29-12-2020 16:29:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3079
TEST_TIME 2 2952
TEST_TIME 3 3875
TEST_TIME 4 4298
TEST_TIME 5 4514
TEST_TIME 6 4307
TEST_TIME 7 4824
TEST_TIME 8 4830
TEST_TIME 9 5104
TEST_TIME 10 5477
TEST_TIME 11 6186
TEST_TIME 12 6624
TEST_TIME 13 7101
TEST_TIME 14 7107
TEST_TIME 15 7065
TEST_TIME 16 7315
TEST_TIME 17 8425
TEST_TIME 18 8565
TEST_TIME 19 9035
TEST_TIME 20 8820
TEST_TIME 21 9169
TEST_TIME 22 9497
TEST_TIME 23 10156
TEST_TIME 24 10155
TEST_TIME 25 10946
TEST_TIME 26 10956
TEST_TIME 27 10710
TEST_TIME 28 10833
TEST_TIME 29 10545
TEST_TIME 30 10260
TEST_TIME 31 10265
TEST_TIME 32 10377
TEST_TIME 33 10180
TEST_TIME 34 10044
TEST_TIME 35 10047
TEST_TIME 36 9856
TEST_TIME 37 9636
TEST_TIME 38 9607
TEST_TIME 39 9743
TEST_TIME 40 9566
TEST_TIME 41 9457
TEST_TIME 42 9507
TEST_TIME 43 9553
TEST_TIME 44 9440
TEST_TIME 45 9331
TEST_TIME 46 9298
TEST_TIME 47 9169
TEST_TIME 48 9086
TEST_TIME 49 9245
TEST_TIME 50 9333
TEST_TIME 51 9309
TEST_TIME 52 9256
TEST_TIME 53 9305
TEST_TIME 54 9230
TEST_TIME 55 9247
TEST_TIME 56 9315
TEST_TIME 57 9328
TEST_TIME 58 9302
TEST_TIME 59 9352
TEST_TIME 60 9442
TEST_TIME 61 9465
TEST_TIME 62 9541
TEST_TIME 63 9423
TEST_TIME 64 9311
TEST_TIME 65 9222
TEST_TIME 66 9206
TEST_TIME 67 9178
TEST_TIME 68 9152
TEST_TIME 69 9108
TEST_TIME 70 9096
TEST_TIME 71 9148
TEST_TIME 72 9070
TEST_TIME 73 9112
TEST_TIME 74 9146
TEST_TIME 75 9122
TEST_TIME 76 9085
TEST_TIME 77 9203
TEST_TIME 78 9173
TEST_TIME 79 9202
TEST_TIME 80 9213
TEST_TIME 81 9218
TEST_TIME 82 9354
TEST_TIME 83 9341
TEST_TIME 84 9390
TEST_TIME 85 9288
TEST_TIME 86 9233
TEST_TIME 87 9146
TEST_TIME 88 9189
TEST_TIME 89 9190
TEST_TIME 90 9185
TEST_TIME 91 9145
TEST_TIME 92 9113
TEST_TIME 93 9056
TEST_TIME 94 9056
TEST_TIME 95 9085
TEST_TIME 96 9117
TEST_TIME 97 9103
TEST_TIME 98 9071
TEST_TIME 99 9166
TEST_TIME 100 9130
TEST_TIME 101 9111
TEST_TIME 102 9123
TEST_TIME 103 9123
TEST_TIME 104 9118
TEST_TIME 105 9162
TEST_TIME 106 9186
TEST_TIME 107 9160
TEST_TIME 108 9188
TEST_TIME 109 9228
TEST_TIME 110 9193
TEST_TIME 111 9136
TEST_TIME 112 9101
TEST_TIME 113 9081
TEST_TIME 114 9065
TEST_TIME 115 9053
TEST_TIME 116 9019
TEST_TIME 117 8987
TEST_TIME 118 8954
TEST_TIME 119 8935
TEST_TIME 120 8862

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-12-2020 16:29:18 to 29-12-2020 16:29:21.

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 1477390 1477390 0 0.00 0 20971 6 0 0
doc_list_biud 1477390 1477390 0 0.00 0 58639 28 0 0
sp_add_invoice_to_stock 4964 4835 129 2.59 35 154759 17700 0 129
sp_cancel_adding_invoice 5378 5378 0 0.00 4 66332 894 0 0
sp_cancel_client_order 1738 1738 0 0.00 4 26026 397 0 0
sp_cancel_customer_reserve 533043 533043 0 0.00 1 58640 61 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 6908 103 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 2508 64 0 0
sp_cancel_supplier_invoice 5959 5949 10 0.16 2 23510 778 0 10
sp_cancel_supplier_order 398 398 0 0.00 7 993279 101777 0 0
sp_cancel_write_off 9511 9511 0 0.00 1 8814 106 0 0
sp_client_order 19474 19474 0 0.00 4 35510 374 0 0
sp_customer_reserve 447651 447651 0 0.00 0 42339 175 0 0
sp_fill_shopping_cart 30122 30122 0 0.00 1 21885 39 0 0
sp_fill_shopping_cart_clo_res 447648 447648 0 0.00 0 21444 14 0 0
sp_get_clo_for_invoice 4832 4832 0 0.00 0 25139 353 0 0
sp_kill_cost_storno 15992 15992 0 0.00 0 6525 57 0 0
sp_kill_qstorno_ret_qs2qd 1081944 1081944 0 0.00 0 58637 33 0 0
sp_kill_qty_storno 570435 570435 0 0.00 0 58639 71 0 0
sp_lock_selected_doc 20187 20187 0 0.00 0 6479 3 0 0
sp_make_cost_storno 27017 27017 0 0.00 0 16808 50 0 0
sp_multiply_rows_for_pdistr 27017 27017 0 0.00 0 6786 29 0 0
sp_multiply_rows_for_qdistr 19474 19474 0 0.00 0 22498 155 0 0
sp_pay_from_customer 6918 6918 0 0.00 4 18896 111 0 0
sp_pay_to_supplier 5681 5681 0 0.00 5 28940 143 0 0
sp_payment_common 12599 12599 0 0.00 1 28913 31 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 26016 361 0 0
sp_qd_handle_on_invoice_upd_sts 10210 10210 0 0.00 0 25999 325 0 0
sp_qd_handle_on_reserve_upd_sts 9586 9586 0 0.00 0 26730 65 0 0
sp_reserve_write_off 9586 9586 0 0.00 6 27112 170 0 0
sp_supplier_invoice 5381 5381 0 0.00 6 74919 3288 0 0
sp_supplier_order 5276 5276 0 0.00 5 45680 1301 0 0
srv_aggregate_perf_data 96 95 1 1.04 1844 199904 20560 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 1087 169922 34683 0 0
srv_find_qd_qs_mism 1017067 1017067 0 0.00 0 11798 5 0 0
srv_make_invnt_saldo 537 537 0 0.00 29 123765 1394 0 0
srv_make_money_saldo 751 751 0 0.00 1 2457 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 384069 545329 428671 0 0
t$perf-abend:sp_add_invoice_to_stock 129 129 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4835 4835 0 0.00 0 21146 193 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 5030 98 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 5244 18 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 2409 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 826 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 1793 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 3051 33 0 0
t$perf-norm:sp_cancel_supplier_order 398 398 0 0.00 0 25656 1727 0 0
t$perf-norm:sp_cancel_write_off 1040 1040 0 0.00 0 3125 22 0 0
t$perf-norm:sp_client_order 19474 19474 0 0.00 0 9432 19 0 0
t$perf-norm:sp_customer_reserve 948 948 0 0.00 0 951 6 0 0
t$perf-norm:sp_pay_from_customer 6918 6918 0 0.00 0 4557 10 0 0
t$perf-norm:sp_pay_to_supplier 5681 5681 0 0.00 0 8569 16 0 0
t$perf-norm:sp_reserve_write_off 9586 9586 0 0.00 0 10697 9 0 0
t$perf-norm:sp_supplier_invoice 5381 5381 0 0.00 0 9628 21 0 0
t$perf-norm:sp_supplier_order 5276 5276 0 0.00 0 10967 22 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 128 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 90 1 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 1955 17 0 0
t$perf-norm:srv_make_money_saldo 751 751 0 0.00 0 2316 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 9922 9664 258 2.60 0 10499 23 0 258
v_all_customers 35668 35668 0 0.00 0 18 1 0 0
v_all_suppliers 29450 29450 0 0.00 0 109 1 0 0
v_all_wares 38948 38948 0 0.00 0 103 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 3564 11 0 0
v_cancel_client_order 3476 3476 0 0.00 0 7066 12 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 6893 16 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 6997 14 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 357 3 0 0
v_cancel_supplier_invoice 800 780 20 2.50 0 2913 20 0 20
v_cancel_supplier_order 796 796 0 0.00 0 6371 15 0 0
v_cancel_write_off 2080 2080 0 0.00 0 7101 15 0 0
v_max_id_clo_ord 5276 5276 0 0.00 0 6477 2 0 0
v_max_id_clo_res 948 948 0 0.00 0 9868 20 0 0
v_max_id_ord_sup 5372 5372 0 0.00 0 3614 5 0 0
v_max_non_paid_invoice 1604 1604 0 0.00 0 3887 8 0 0
v_max_non_paid_realizn 3702 3702 0 0.00 0 4842 5 0 0
v_min_id_clo_ord 5276 5276 0 0.00 0 3420 6 0 0
v_min_id_clo_res 948 948 0 0.00 0 3222 8 0 0
v_min_id_ord_sup 5372 5372 0 0.00 0 8402 8 0 0
v_min_non_paid_invoice 5681 5681 0 0.00 0 7111 20 0 0
v_min_non_paid_realizn 6918 6918 0 0.00 0 14061 20 0 0
v_our_firm 9712 9712 0 0.00 0 20 1 0 0
v_reserve_write_off 19172 19172 0 0.00 0 7062 6 0 0
x_lock_depdocs_on_canc_invoice 10937 10937 0 0.00 0 14846 127 0 0
x_lock_depdocs_on_canc_sup_ord 398 398 0 0.00 0 14018 481 0 0
x_make_qstorno_1000_1200 5276 5276 0 0.00 2 45673 1222 0 0
x_make_qstorno_1200_2000 5381 5381 0 0.00 2 74913 3151 0 0
x_make_qstorno_2100_3300 447651 447651 0 0.00 0 36655 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-12-2020 16:29:22 to 29-12-2020 16:29:26.

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
13:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:19 11359 8192000000 10187986176 10485714944 866558032 9.566 69 59 118 0 888789056 2525200 19705824
13:57:39 31579 8192000000 10311529152 10621935616 1349520656 14.143 100 84 168 0 1381860928 4473632 27866640
13:58:20 23847 8192000000 10347145168 10664181760 1404269744 14.633 100 93 186 0 1441828320 6284160 31274416
13:58:55 27685 8192000000 10379512112 10702274560 1424995488 14.817 100 88 176 2 1460953072 6841296 29116288
13:59:38 14302 8192000000 10406200928 10731347968 1453380336 15.068 100 88 176 0 1489349040 7528304 28440400
14:00:02 20075 8192000000 10424537280 10751963136 1474428416 15.253 100 93 187 0 1512746288 8121632 30196240
14:00:32 21448 8192000000 10443453184 10773696512 1487636048 15.368 100 85 170 0 1523294448 8620912 27037488
14:01:02 18479 8192000000 10453505712 10790543360 1512656736 15.586 100 84 168 0 1548973552 9368096 26948720
14:01:33 21203 8192000000 10482913568 10833522688 1536370336 15.792 100 71 142 0 1571957792 13991168 21596288
14:02:02 9492 8192000000 10508314736 10860744704 1562058064 16.014 100 77 155 0 1595995264 9894976 24042224
14:02:20 13981 8192000000 10544218512 10899189760 1608311216 16.410 100 76 152 0 1641557936 10359232 22887488
14:02:42 14194 8192000000 10557711680 10918891520 1616225680 16.478 100 77 154 0 1654657744 15408624 23023440
14:03:04 13727 8192000000 10586193744 10944671744 1637316432 16.657 100 85 168 2 1674123040 11825344 24981264
14:03:26 9857 8192000000 10609779600 10969247744 1656862000 16.822 100 84 168 1 1697745904 16299280 24584624
14:03:46 8934 8192000000 10616688512 10980642816 1673003184 16.958 100 80 160 0 1709124512 12448176 23673152
14:04:04 11106 8192000000 10629330960 10998902784 1688894192 17.092 100 81 162 2 1724868784 12050976 23923616
14:04:27 6864 8192000000 10647449408 11016835072 1707783952 17.250 100 81 160 1 1743188176 12454736 22949488
14:04:41 7514 8192000000 10660336416 11034656768 1722362560 17.372 100 80 160 2 1758060352 12748464 22949328
14:04:57 6089 8192000000 10677176000 11053916160 1738192768 17.504 100 81 160 0 1773567648 12264288 23110592
14:05:11 6231 8192000000 10692132576 11067256832 1750937040 17.609 100 81 160 1 1786758880 13420624 22401216
14:05:24 4788 8192000000 10694204144 11072991232 1754048976 17.635 100 77 154 1 1790373808 14205248 22119584
14:05:37 5036 8192000000 10709235248 11085127680 1765590464 17.731 100 90 181 1 1806596480 15036512 25969504
14:05:49 4490 8192000000 10701988816 11083718656 1771011712 17.775 100 75 149 2 1804640368 13107392 20521264
14:06:01 2845 8192000000 10713229168 11090984960 1774837328 17.807 100 85 166 2 1811575152 13103408 23634416
14:06:10 3521 8192000000 10723948928 11102969856 1781096192 17.859 100 82 163 3 1817045632 13615312 22334128
14:06:21 4165 8192000000 10731984096 11110215680 1787548352 17.912 100 86 169 1 1824915280 13389904 23977024
14:06:32 3180 8192000000 10738539200 11115646976 1795732480 17.979 100 87 173 0 1833084000 13531520 23820000
14:06:42 2587 8192000000 10740623360 11120623616 1797981456 17.997 100 83 167 1 1834952208 14267024 22703728
14:06:51 4869 8192000000 10735785760 11117928448 1797968896 17.997 100 82 164 1 1834849216 14041920 22838400
14:07:02 4919 8192000000 10747457424 11131973632 1804047712 18.047 100 82 160 1 1840813040 14580992 22184336
14:07:14 2438 8192000000 10760589696 11148820480 1819572528 18.174 100 88 175 2 1857746576 13903392 24270656
14:07:23 2522 8192000000 10757033600 11147137024 1827423328 18.238 100 80 160 1 1862361184 12906176 22031680
14:07:32 2465 8192000000 10786884336 11168124928 1833516976 18.288 100 88 175 2 1871537488 13437488 24583024
14:07:41 2418 8192000000 10797121856 11183325184 1850956656 18.430 100 96 192 3 1891924000 14094656 26872688
14:07:50 2131 8192000000 10804116624 11189653504 1851810800 18.437 100 88 176 0 1891311664 13963776 25537088
14:07:59 1742 8192000000 10805951152 11190743040 1855315456 18.465 100 88 175 1 1892664192 13004320 24344416
14:08:06 1027 8192000000 10805165504 11190824960 1860718832 18.509 100 98 197 1 1902046000 13375840 27951328
14:08:14 2464 8192000000 10801652192 11191406592 1858779840 18.493 100 93 182 1 1898085472 12328048 26977584
14:08:23 1613 8192000000 10811189904 11201028096 1865498592 18.548 100 90 180 3 1904178880 12717632 25962656
14:08:31 1689 8192000000 10805516512 11198091264 1866312320 18.554 100 88 176 2 1904462640 13507888 24642432
14:08:39 15093 8192000000 10804903584 11200446464 1869070304 18.577 100 87 174 0 1907743360 13611024 25062032
14:09:00 1234 8192000000 10819157968 11210694656 1876905376 18.640 100 90 180 2 1915356848 13728176 24723296
14:09:08 25259 8192000000 10783746752 11203682304 1869579376 18.581 100 64 128 1 1897795456 10693968 17522112
14:09:41 3547 8192000000 10810609584 11211886592 1876814224 18.639 100 58 116 0 1902984608 9503488 16666896
14:09:51 1814 8192000000 10807487568 11211272192 1874357072 18.620 100 56 112 0 1900766528 10754800 15654656
14:09:59 3567 8192000000 10800233792 11208986624 1874693616 18.622 100 58 117 0 1901269008 10117328 16458064
14:10:09 5060 8192000000 10791736672 11207716864 1872251200 18.602 100 38 77 0 1891017840 8156528 10610112
14:10:25 6432 8192000000 10787127184 11210309632 1873924000 18.616 100 36 72 2 1891711296 7189120 10598176
14:10:40 5403 8192000000 10783516672 11208945664 1877337280 18.644 100 33 65 2 1893455248 5883328 10234640
14:10:52 9945 8192000000 10789802816 11218984960 1877967520 18.649 100 29 55 4 1897008432 11242144 7798768
14:11:08 9097 8192000000 10795134976 11220946944 1883888496 18.696 100 27 54 0 1901662544 10508160 7265888
14:11:27 7520 8192000000 10791982816 11219828736 1881285328 18.675 100 23 46 0 1894058736 6590592 6182816
14:11:42 9075 8192000000 10791273280 11221041152 1882571936 18.686 100 14 28 2 1892483696 6159440 3752320
14:11:58 6195 8192000000 10801587600 11225501696 1885591120 18.710 100 18 36 0 1896526768 5974928 4960720
14:12:11 8731 8192000000 10799420496 11226501120 1885969824 18.713 100 21 43 1 1897922784 6112784 5840176
14:12:26 8944 8192000000 10801866848 11231105024 1892637696 18.767 100 31 63 1 1907388608 6104400 8646512
14:12:45 60205 8192000000 10815579696 11242635264 1894791312 18.784 100 27 54 0 1907672720 4715616 8165792
14:14:03 13843 8192000000 10807593344 11242176512 1897203648 18.804 100 30 60 0 1912682976 6780976 8698352
14:14:23 7688 8192000000 10804234656 11237515264 1888683376 18.735 100 20 40 0 1899887824 5633664 5570784
14:14:37 5181 8192000000 10812601488 11244716032 1890621984 18.751 100 28 56 4 1904358496 6443808 7292704
14:14:49 4006 8192000000 10815914592 11243155456 1894172512 18.779 100 34 68 0 1914766128 11590112 9003504
14:15:00 5616 8192000000 10816586752 11244605440 1894314080 18.781 100 27 54 1 1908097472 5541456 8241936
14:15:18 9225 8192000000 10815128848 11248967680 1893338544 18.773 100 15 27 3 1907252528 10131088 3782896
14:15:34 8578 8192000000 10811445408 11244490752 1894701536 18.784 100 26 53 2 1907711840 5550320 7459984
14:15:54 18325 8192000000 10797565792 11228422144 1834059728 18.292 97 8 16 1 1845826480 9721632 2045120
14:16:22 8822 8192000000 10787881712 11217735680 1843143280 18.366 98 16 32 0 1852910816 4952304 4815232
14:16:39 11956 8192000000 10781296880 11206819840 1842597200 18.362 98 19 38 1 1853622896 5150720 5874976
14:16:57 15100 8192000000 10784182272 11216961536 1838899936 18.332 98 12 23 0 1851806176 9381376 3524864
14:17:18 5975 8192000000 10791392608 11222736896 1876346848 18.636 100 31 62 2 1895985760 11099888 8539024
14:17:35 64413 8192000000 10772617920 11196776448 1783633312 17.879 95 25 49 1 1796192640 5448624 7110704
14:18:46 7427 8192000000 10741172384 11162894336 1762583696 17.706 95 26 50 1 1784705264 14228080 7893488
14:19:00 4540 8192000000 10761311184 11176169472 1826248112 18.229 99 47 94 1 1847641584 8491392 12902080
14:19:12 3732 8192000000 10732489008 11155996672 1806538496 18.068 99 33 64 2 1822560688 6019088 10003104
14:19:24 4392 8192000000 10730882496 11144663040 1799833040 18.013 99 44 88 3 1819156416 6414416 12908960
14:19:36 8784 8192000000 10722248272 11142627328 1805651408 18.060 99 32 64 0 1822092848 7271200 9170240
14:19:55 5261 8192000000 10713535856 11129872384 1784872112 17.890 99 22 44 2 1797312416 5959760 6480544
14:20:06 5803 8192000000 10704142672 11114602496 1712506128 17.290 95 37 74 1 1729119088 5532784 11080176
14:20:18 7155 8192000000 10707433552 11121938432 1762952448 17.709 98 21 42 4 1773600816 5091664 5556704
14:20:35 4925 8192000000 10696633056 11106848768 1749447568 17.597 98 34 68 0 1766007312 6234080 10325664
14:20:46 9435 8192000000 10696997424 11111780352 1764065344 17.718 99 22 44 1 1775786480 5038048 6683088
14:21:04 13193 8192000000 10717047712 11126087680 1749621136 17.598 97 23 46 0 1761593840 5090224 6882480
14:21:26 8048 8192000000 10699325856 11115855872 1744021024 17.552 97 22 44 1 1756516656 6633264 5862368
14:21:41 9002 8192000000 10718806144 11134267392 1796403120 17.984 100 19 38 2 1808287968 6210896 5673952
14:21:56 70778 8192000000 10727020208 11149012992 1782893232 17.873 98 22 44 1 1794946784 5508336 6545216
14:23:15 6837 8192000000 10757819248 11174813696 1832910912 18.283 100 40 80 0 1851975376 7941600 11122864
14:23:29 6151 8192000000 10756004128 11177857024 1834941312 18.300 100 29 58 3 1850309616 7089600 8278704
14:23:44 5219 8192000000 10768237600 11180937216 1840855296 18.348 100 37 74 0 1858190384 6474896 10860192
14:23:56 8176 8192000000 10766171824 11186130944 1847494912 18.402 100 33 66 1 1864111952 6845520 9771520
14:24:10 5432 8192000000 10765360016 11190689792 1850070256 18.423 100 23 47 1 1863228224 6378048 6779920
14:24:22 8237 8192000000 10777434256 11197841408 1855040128 18.463 100 30 60 2 1870206000 6175472 8990400
14:24:37 8350 8192000000 10773470992 11203633152 1859125856 18.496 100 30 60 1 1873399152 5381024 8892272
14:24:52 4956 8192000000 10789684160 11206606848 1864403536 18.539 100 33 66 1 1879939776 6405936 9130304
14:25:04 7110 8192000000 10791455216 11209043968 1866033520 18.552 100 26 52 4 1879437808 5464000 7940288
14:25:20 11324 8192000000 10773059408 11210125312 1868174560 18.570 100 26 52 2 1882701456 6397552 8129344
14:25:39 8973 8192000000 10781610224 11212029952 1869008912 18.576 100 15 30 0 1877951856 4978160 3964784
14:25:55 11745 8192000000 10784667424 11220033536 1874752464 18.623 100 24 49 4 1887528272 5808368 6967440
14:26:13 8412 8192000000 10793355152 11225452544 1878468656 18.653 100 25 50 0 1895942256 10463248 7010352
14:26:28 35918 8192000000 10779907840 11220152320 1877449104 18.645 100 16 32 0 1887682272 5144192 5088976
14:27:23 72792 8192000000 10838178864 11262889984 1893199904 18.772 99 44 87 2 1915803520 10156688 12446928
14:28:46 18693 8192000000 10865035280 11283636224 1926509920 19.039 100 48 96 0 1949738816 9638608 13590288
14:29:18 41634 8192000000 10887646128 11311702016 1946830272 19.201 100 47 94 0 1973077648 12364032 13883344
14:30:09 16439 8192000000 10888681280 11314061312 1955723856 19.272 100 42 84 1 1983550704 15543456 12283392
14:30:35 18915 8192000000 10903261968 11330101248 1961930848 19.321 100 44 88 0 1992351184 17804080 12616256
14:31:05 52571 8192000000 10896079088 11338203136 1961768320 19.320 100 25 50 3 1986377040 17010096 7598624
14:32:16 21486 8192000000 10911047936 11341602816 1974360832 19.420 100 30 60 4 1998261568 15132464 8768272
14:32:56 28699 8192000000 10927874016 11358019584 1984300352 19.499 100 45 90 0 2016227584 18336784 13590448
14:33:36 20044 8192000000 10933755328 11367202816 1992157776 19.561 100 53 106 1 2028767216 20289920 16319520
14:34:11 14490 8192000000 10935189184 11370143744 1995685232 19.589 100 45 87 0 2028356880 19253888 13417760
14:34:37 11020 8192000000 10936503760 11374215168 1996835328 19.598 100 45 90 3 2029257824 19026384 13396112
14:34:58 9921 8192000000 10941384592 11375345664 2000470816 19.626 100 57 114 0 2036979408 19305584 17203008
14:35:30 11964 8192000000 10929877200 11364085760 1987038624 19.520 100 48 96 3 2022014992 20806816 14169552
14:35:51 1087 8192000000 10942038448 11369140224 1988845568 19.535 100 57 114 1 2028465392 22686832 16932992
14:35:59 4414 8192000000 10951323344 11376885760 1995602608 19.588 100 63 123 4 2038516384 23884112 19029664
14:36:10 2046 8192000000 10963287424 11381063680 2000532640 19.627 100 67 125 2 2044585984 24826672 19226672
14:36:19 5616 8192000000 10963297760 11388411904 2006084304 19.671 100 64 128 1 2051385040 25768384 19532352
14:36:33 4430 8192000000 10963362096 11387330560 2007588544 19.683 100 63 126 1 2054043536 26689952 19765040
14:36:51 8415 8192000000 10959894240 11389939712 2008648624 19.691 100 62 122 1 2052541392 25614528 18278240
14:37:10 13337 8192000000 10964828176 11402797056 2015584752 19.745 100 56 112 0 2063224208 29450432 18189024
14:37:38 1638 8192000000 10996710416 11414749184 2007620960 19.683 99 80 155 2 2062284720 30833024 23830736
14:37:50 3965 8192000000 10978091552 11404029952 2013506160 19.729 100 79 156 1 2068850880 31378784 23965936
14:38:01 6534 8192000000 10973829312 11399593984 1997930352 19.606 99 73 145 3 2053642688 33440208 22272128
14:38:15 3684 8192000000 10978305856 11405774848 2007644400 19.683 100 65 127 2 2062092400 34972656 19475344
14:38:28 1431 8192000000 10993243568 11407859712 2011854240 19.716 100 82 159 2 2072289344 36047216 24387888
14:38:39 6022 8192000000 10992537040 11421179904 2018330080 19.767 100 67 134 2 2075027872 36299616 20398176
14:38:55 2048 8192000000 10996615952 11417063424 2007780016 19.684 99 84 168 0 2071705584 37939744 25985824
14:39:05 3011 8192000000 10989940736 11420409856 2019856928 19.779 100 68 136 0 2077882688 36508624 21517136
14:39:16 2922 8192000000 10980981392 11400355840 1998502000 19.611 99 77 154 1 2058712528 36115472 24095056
14:39:26 4323 8192000000 10991295968 11414777856 2012436416 19.721 100 76 149 2 2072799584 37615440 22747728
14:39:37 2989 8192000000 10990283600 11415986176 2013226128 19.727 100 77 149 2 2074466160 38704784 22535248
14:39:48 2964 8192000000 10978769632 11397402624 1997960336 19.607 99 78 156 0 2062494768 40586320 23948112
14:39:58 4011 8192000000 10982980144 11404939264 1997383392 19.602 99 81 160 1 2060479520 38075744 25020384
14:40:09 4850 8192000000 10988509728 11405451264 2012758160 19.723 100 80 160 1 2074986064 36985424 25242480
14:40:21 4630 8192000000 10986788864 11413467136 2009327040 19.696 100 65 130 0 2065960960 37048240 19585680
14:40:38 3233 8192000000 10980022272 11405709312 1992533840 19.564 99 79 158 1 2053639248 37159584 23945824
14:40:51 4143 8192000000 10970351216 11395379200 2002359328 19.641 100 73 146 1 2063456048 38279568 22817152
14:41:10 2831 8192000000 10964490144 11387224064 1981233952 19.474 99 68 134 0 2037441360 35254048 20953360
14:41:19 2156 8192000000 10968784096 11389296640 1995278432 19.585 100 76 152 2 2054624880 35307040 24039408
14:41:28 3816 8192000000 10974302128 11393253376 1996634160 19.596 100 79 158 2 2057762720 36488448 24640112
14:41:41 3378 8192000000 10980994848 11398172672 1995639424 19.588 100 81 162 1 2057944880 37514800 24790656
14:41:51 6317 8192000000 10967065040 11398107136 1995591376 19.588 100 66 132 2 2054810928 38939680 20279872
14:42:10 4335 8192000000 10941600800 11369611264 1961737840 19.320 99 62 124 0 2021458624 39964464 19756320
14:42:22 6987 8192000000 10937959632 11363323904 1956319072 19.277 99 65 127 0 2018052256 41312736 20420448
14:42:37 7208 8192000000 10947469376 11365453824 1946940704 19.202 98 84 168 1 2016179888 43044784 26194400
14:42:53 4636 8192000000 10950934272 11369377792 1959063680 19.299 99 74 148 1 2028213184 45708448 23441056
14:43:05 5878 8192000000 10963285792 11378397184 1972811968 19.408 100 73 146 0 2042370128 45508256 24049904
14:43:19 6782 8192000000 10956687280 11377672192 1969942400 19.385 100 79 157 2 2040897504 46423088 24532016
14:43:36 6736 8192000000 10949120896 11375247360 1966600400 19.358 100 70 139 3 2034999392 45020720 23378272
14:43:49 1821 8192000000 10928714832 11348828160 1943492048 19.175 100 69 137 2 2011954464 45538208 22924208
14:43:58 2293 8192000000 10930726912 11335983104 1922378096 19.006 98 77 153 0 1994657872 47199776 25080000
14:44:10 1647 8192000000 10935457024 11350949888 1949397200 19.222 100 74 146 3 2017128464 43551792 24179472
14:44:22 3709 8192000000 10964462928 11380531200 1971241696 19.395 100 85 164 0 2045261216 47613184 26406336
14:44:34 3510 8192000000 10948091568 11373383680 1968071568 19.370 100 73 146 0 2038847056 46721424 24054064
14:44:52 13174 8192000000 10905415072 11343904768 1934202128 19.100 99 40 80 1 1987509920 39829104 13478688
14:45:16 4096 8192000000 10932245968 11368136704 1956218992 19.276 100 43 86 4 2014650048 43691792 14739264
14:45:27 4879 8192000000 10896142736 11342696448 1929774784 19.065 99 43 84 0 1979282976 35530592 13977600
14:45:45 5763 8192000000 10933382896 11365949440 1940935952 19.154 99 55 111 0 2000414192 41491696 17986544
14:45:58 7580 8192000000 10909831568 11342659584 1940745936 19.153 100 55 110 0 1999152848 40374352 18032560
14:46:14 10390 8192000000 10915063008 11349901312 1933680720 19.096 99 53 104 0 1989780480 38723024 17376736
14:46:32 17760 8192000000 10892016160 11346280448 1905988336 18.874 98 30 58 1 1957207248 41661232 9557680
14:46:56 8552 8192000000 10890787152 11333402624 1917470432 18.967 99 30 60 3 1965924400 38861360 9592608
14:47:17 6063 8192000000 10905867712 11342794752 1938857488 19.138 100 44 86 1 1989416864 36614208 13945168
14:47:30 17783 8192000000 10909399920 11352629248 1942005600 19.163 100 31 62 1 1992494960 40701264 9788096
14:48:02 20773 8192000000 10890081296 11338588160 1922745472 19.009 99 25 50 2 1972830432 41162656 8922304
14:48:30 14279 8192000000 10903597488 11352506368 1939695248 19.144 100 28 56 1 1992689472 43025200 9969024
14:48:53 10070 8192000000 10925187536 11356295168 1931759680 19.081 99 43 86 1 1986846688 41078416 14008592
14:49:10 2699 8192000000 10926015408 11361153024 1948184400 19.212 100 75 151 1 2017474976 46677776 22612800
14:49:26 12918 8192000000 10908589408 11358756864 1947029056 19.203 100 39 78 0 2003040848 42831264 13180528
14:49:46 8883 8192000000 10914019008 11357868032 1927564448 19.047 99 26 51 0 1976722400 40842736 8315216
14:50:02 4959 8192000000 10919963328 11356717056 1942364080 19.166 100 37 74 0 1998579984 44367040 11848864
14:50:21 26022 8192000000 10911081712 11366039552 1949634016 19.224 100 23 45 0 2000210592 42448912 8127664
14:51:02 22876 8192000000 10891993216 11345862656 1923593792 19.016 99 24 48 2 1965312224 33678608 8039824
14:51:33 46888 8192000000 10867675520 11313913856 1892831248 18.769 98 17 34 0 1938653680 40083840 5738592
14:52:30 9074 8192000000 10907534208 11340963840 1933971104 19.099 100 48 94 2 1978637632 29341024 15325504
14:52:45 8032 8192000000 10886330896 11318919168 1918255616 18.973 99 42 82 1 1951215872 20221312 12738944
14:53:00 13831 8192000000 10888940672 11323142144 1935151232 19.108 100 44 90 0 1966210048 18164960 12893856
14:53:23 24118 8192000000 10865873648 11300339712 1892213200 18.764 98 48 95 2 1918202192 11126768 14862224
14:53:53 53316 8192000000 10861117088 11316224000 1924330672 19.022 100 25 50 0 1944175216 11974192 7870352
14:54:55 34531 8192000000 10844985504 11301367808 1901628896 18.839 99 17 34 0 1917272832 10632512 5011424
14:55:37 6958 8192000000 10844987552 11317809152 1919424432 18.982 100 12 24 1 1938954128 16072992 3456704
14:56:24 53498 8192000000 10850319184 11307950080 1891978080 18.762 98 19 36 1 1908797248 10963776 5855392
14:57:25 32601 8192000000 10868346144 11321020416 1932030144 19.083 100 15 30 0 1950319472 13680224 4609104
14:58:04 58771 8192000000 10880346384 11353366528 1945711616 19.192 100 14 28 2 1966952512 17329248 3911648
14:59:43 94341 8192000000 10880137488 11331719168 1879821632 18.664 96 19 36 0 1893583520 9122560 4639328
15:01:24 71195 8192000000 10880808656 11345739776 1952012848 19.243 100 17 34 0 1975105968 18632592 4460528
15:02:42 92301 8192000000 10890810048 11353907200 1960679360 19.311 100 16 32 2 1975624208 10718304 4226544
15:04:20 103968 8192000000 10890539712 11348697088 1949454704 19.222 99 30 60 1 1973611680 13975728 10181248
15:06:31 50898 8192000000 10882265440 11352174592 1962768624 19.328 100 8 16 1 1977826784 12985600 2072560
15:07:35 2900 8192000000 10891470576 11338207232 1946056768 19.195 99 38 76 4 1967426848 10822496 10547584
15:07:44 18060 8192000000 10890154416 11340406784 1943688896 19.176 99 38 75 1 1966529296 12311280 10529120
15:08:16 46795 8192000000 10890758240 11345879040 1946695360 19.200 99 33 66 1 1969919440 13818784 9405296
15:09:10 55901 8192000000 10889673120 11357986816 1960293632 19.308 100 25 50 1 1985377936 17547904 7536400
15:10:20 29259 8192000000 10892510672 11370532864 1963754160 19.336 100 14 28 1 1987523120 19623232 4145728
15:10:55 48458 8192000000 10880295552 11344838656 1948690768 19.216 99 12 24 0 1969230592 16982592 3557232
15:12:02 69530 8192000000 10898975728 11363287040 1956294016 19.277 99 14 28 1 1979253024 18920288 4038720
15:13:46 94777 8192000000 10922186448 11387908096 1987485856 19.524 100 16 32 1 2013083680 19909952 5687872
15:15:28 63115 8192000000 10913659456 11378339840 1967768496 19.368 99 34 69 1 2000798848 22677424 10352928
15:16:37 56164 8192000000 10899276224 11375861760 1977675456 19.446 100 12 24 0 1998600016 17512464 3412096
15:17:40 58434 8192000000 10916716336 11385913344 1974147392 19.418 99 26 52 0 1989781968 8193280 7441296
15:18:44 26138 8192000000 10940168176 11387138048 2003085888 19.647 100 46 92 0 2023042480 6354112 13602480
15:19:18 25248 8192000000 10933288432 11400675328 2008037968 19.686 100 40 77 2 2032405136 12797280 11569888
15:19:57 75914 8192000000 10935015152 11391549440 1981826064 19.479 99 26 50 1 1997253264 8513440 6913760
15:21:21 30445 8192000000 10942039472 11403030528 1991059904 19.552 99 39 78 1 2014271072 11873728 11337440
15:22:00 41018 8192000000 10946194752 11408314368 2003561312 19.651 100 32 64 3 2024831584 12155024 9115248
15:22:49 32270 8192000000 10947249376 11406405632 2010613440 19.706 100 33 63 2 2030227488 10099120 9514928
15:23:31 70323 8192000000 10931696176 11401433088 1989230928 19.538 99 25 50 1 2007817408 11669872 6916608
15:24:54 30433 8192000000 10948386448 11405058048 1992762368 19.566 99 28 56 0 2008559504 8458160 7338976
15:25:37 57237 8192000000 10912005600 11382697984 1946533376 19.199 97 29 58 0 1967532304 11798928 9200000
15:26:46 78754 8192000000 10918839888 11392544768 1965102976 19.347 99 8 16 0 1978800176 11854384 1842816
15:28:34 169922 8192000000 10882454416 11329400832 1784569392 17.887 90 12 24 0 1801056192 13440496 3046304
15:31:31 70168 8192000000 10888466912 11330277376 1939774032 19.145 99 38 74 0 1958652112 8329632 10548448
15:32:48 14352 8192000000 10893642096 11337224192 1954804432 19.265 100 48 92 2 1977324992 10049856 12470704
15:33:08 41681 8192000000 10879616960 11341312000 1936984032 19.123 99 30 58 1 1954211472 9535344 7692096
15:33:57 64887 8192000000 10862683904 11339059200 1918757520 18.977 98 8 16 0 1929825184 8548304 2519360
15:35:11 55280 8192000000 10859508048 11319394304 1839847216 18.340 94 17 34 2 1853959280 9345936 4766128
15:36:15 76129 8192000000 10854233664 11314683904 1886028928 18.714 97 17 34 0 1899551008 8312880 5209200
15:37:52 65895 8192000000 10834137552 11303911424 1835762752 18.306 95 8 16 0 1846277216 8317568 2196896
15:39:05 22460 8192000000 10836165504 11285389312 1859969184 18.503 97 26 52 1 1874393216 7500832 6923200
15:39:34 38046 8192000000 10865078464 11307778048 1905974112 18.874 99 50 100 0 1930308688 10271472 14063104
15:40:22 39430 8192000000 10853063600 11316781056 1910030112 18.907 99 35 70 0 1934076528 13651152 10395264
15:41:49 29107 8192000000 10867529856 11317391360 1916905264 18.962 99 25 50 2 1932180704 8085328 7190112
15:43:05 80505 8192000000 10872442848 11323424768 1915137280 18.948 99 19 38 0 1933321408 12552816 5631312
15:45:16 55000 8192000000 10860509712 11312168960 1864690160 18.541 96 28 56 1 1882816096 10222848 7903088
15:46:17 63347 8192000000 10826452800 11288096768 1813065488 18.121 94 23 47 0 1830722064 11192400 6464176
15:47:28 106189 8192000000 10867490512 11334967296 1911997120 18.923 99 16 32 1 1934678496 17713408 4967968
15:49:30 95369 8192000000 10863038080 11337195520 1875748976 18.631 97 12 24 2 1896052960 16896848 3407136
15:51:12 111581 8192000000 10872091632 11319013376 1871609984 18.597 97 12 24 1 1887690960 12439376 3641600
15:53:15 100556 8192000000 10878816528 11343831040 1940441280 19.150 100 21 42 2 1965822400 19456400 5924720
15:55:06 45014 8192000000 10896209984 11351842816 1932273088 19.085 99 17 34 0 1957221328 20135008 4813232
15:56:13 87101 8192000000 10866255472 11350872064 1939823056 19.145 100 10 20 0 1959547952 17419440 2305456
15:57:46 25382 8192000000 10872159440 11345006592 1935450784 19.110 99 14 28 2 1948827216 9787472 3588960
15:58:23 65734 8192000000 10885704656 11355869184 1950592592 19.231 99 24 48 2 1965544768 8576768 6375408
15:59:35 86219 8192000000 10888322320 11354398720 1918785472 18.977 97 20 39 3 1934253888 10343184 5125232
16:01:13 108852 8192000000 10900147552 11391123456 1964872400 19.345 100 14 28 0 1988743168 19651472 4219296
16:03:08 43229 8192000000 10921828896 11385602048 1982053072 19.481 100 23 45 1 1997081568 9138960 5889536
16:03:57 61793 8192000000 10920527120 11381592064 1953416864 19.254 98 25 50 0 1970009904 9166832 7426208
16:05:10 49657 8192000000 10921320640 11379482624 1969903536 19.385 99 26 52 1 1988358256 11601888 6852832
16:06:07 53078 8192000000 10911113984 11401539584 1992354704 19.562 100 42 84 0 2025535024 20533744 12646576
16:07:09 44148 8192000000 10917264704 11387457536 1988802992 19.534 100 18 36 1 2001153248 7089632 5260624
16:08:05 39894 8192000000 10932977536 11394727936 1998184224 19.608 100 34 68 1 2016461808 9025424 9252160
16:08:57 40361 8192000000 10932219296 11398963200 1981812560 19.479 99 30 60 3 2001583456 11184144 8586752
16:09:48 58101 8192000000 10911588544 11381665792 1956230128 19.276 98 22 44 1 1975244864 12229136 6785600
16:10:58 31628 8192000000 10923350624 11380301824 1986235504 19.514 100 39 76 0 2017823520 20659360 10928656
16:11:36 16764 8192000000 10919452128 11373977600 1976613328 19.438 100 25 50 4 1995936384 12414048 6909008
16:11:59 29255 8192000000 10930060912 11396358144 1985942496 19.512 100 26 52 1 2007301920 14080032 7279392
16:12:36 75017 8192000000 10916505264 11388076032 1952352832 19.245 98 11 22 1 1968171392 12942560 2876000
16:14:10 104353 8192000000 10914294224 11378405376 1910613808 18.912 96 23 46 1 1931466032 14701744 6150480
16:16:00 97327 8192000000 10868806352 11347976192 1859625488 18.500 94 14 28 0 1873884560 10320160 3938912
16:19:02 67309 8192000000 10876196240 11339739136 1938390848 19.134 99 19 38 0 1951231952 7643648 5197456
16:20:25 60437 8192000000 10857191488 11319296000 1890449168 18.749 96 31 62 1 1906596960 7023904 9123888
16:21:38 68427 8192000000 10834802816 11315138560 1810700176 18.102 93 9 18 1 1821965920 9131872 2133872
16:23:16 51876 8192000000 10833200752 11302547456 1875173696 18.626 97 13 27 1 1886423936 8028560 3221680
16:24:14 85330 8192000000 10854033024 11319402496 1886500160 18.718 97 20 40 2 1902461184 9737472 6223552
16:25:46 79824 8192000000 10866412608 11329081344 1934331952 19.102 100 14 28 0 1948360320 9360592 4667776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 29-12-2020 16:29:28 to 29-12-2020 16:29:59.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-12-2020 16:30:00 to 29-12-2020 16:30:02.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          236556
MON$OLDEST_ACTIVE               237145
MON$OLDEST_SNAPSHOT             237145
MON$NEXT_TRANSACTION            237145
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                       2013056
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:62: 
:63: mscs-test-161.budzdorov.ru    Tue Dec 29 16:27:38 2020
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
--- end of diff output ---

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

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