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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-04 19:31:12
DTS_END                         2021-03-04 19:31:12.5830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(301:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60410
TRN_ID                          238336
ATT_ID                          610
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: 9205.83 20016 1104700
customer order: creation 169.90 369 20388
customer order: refuse 14.02 338 1682
order to supplier: creation 44.32 1284 5318
order to supplier: removal 3.42 103905 410
invoice (draft): creation 45.27 3710 5432
invoice (draft): removal 53.26 775 6391
invoice accept: apply 40.43 19473 4852
invoice accept: cancel 48.44 794 5813
customer reserve: creation 3712.99 195 445559
customer reserve: removal 4786.42 59 574370
realization accept: apply 82.07 165 9848
realization accept: cancel 79.45 108 9534
payment from customer: creation 57.78 104 6934
payment from customer: removal 5.16 60 619
payment to supplier: creation 47.48 121 5698
payment to supplier: removal 3.31 54 397
service: total inventory turnovers 4.98 1015 598
service: total monetary turnovers 6.32 38 758
service: aggregate perf. data 0.79 18841 95
service: refresh index statistics 0.03 248903 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-03-2021 19:31:56 to 04-03-2021 19:31:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7343
TEST_TIME 2 5541
TEST_TIME 3 5407
TEST_TIME 4 6089
TEST_TIME 5 5975
TEST_TIME 6 6775
TEST_TIME 7 6333
TEST_TIME 8 6238
TEST_TIME 9 6469
TEST_TIME 10 6802
TEST_TIME 11 6864
TEST_TIME 12 7229
TEST_TIME 13 7148
TEST_TIME 14 7218
TEST_TIME 15 7434
TEST_TIME 16 7376
TEST_TIME 17 7773
TEST_TIME 18 7902
TEST_TIME 19 8682
TEST_TIME 20 8861
TEST_TIME 21 8917
TEST_TIME 22 9054
TEST_TIME 23 9640
TEST_TIME 24 10118
TEST_TIME 25 10082
TEST_TIME 26 10827
TEST_TIME 27 10834
TEST_TIME 28 10621
TEST_TIME 29 10374
TEST_TIME 30 10389
TEST_TIME 31 10383
TEST_TIME 32 10287
TEST_TIME 33 10282
TEST_TIME 34 10130
TEST_TIME 35 10010
TEST_TIME 36 9968
TEST_TIME 37 9742
TEST_TIME 38 9641
TEST_TIME 39 9537
TEST_TIME 40 9357
TEST_TIME 41 9356
TEST_TIME 42 9408
TEST_TIME 43 9314
TEST_TIME 44 9344
TEST_TIME 45 9270
TEST_TIME 46 9208
TEST_TIME 47 9197
TEST_TIME 48 9309
TEST_TIME 49 9544
TEST_TIME 50 9677
TEST_TIME 51 9670
TEST_TIME 52 9713
TEST_TIME 53 9793
TEST_TIME 54 9737
TEST_TIME 55 9748
TEST_TIME 56 9602
TEST_TIME 57 9585
TEST_TIME 58 9460
TEST_TIME 59 9399
TEST_TIME 60 9301
TEST_TIME 61 9261
TEST_TIME 62 9372
TEST_TIME 63 9374
TEST_TIME 64 9416
TEST_TIME 65 9419
TEST_TIME 66 9387
TEST_TIME 67 9420
TEST_TIME 68 9473
TEST_TIME 69 9571
TEST_TIME 70 9568
TEST_TIME 71 9643
TEST_TIME 72 9647
TEST_TIME 73 9733
TEST_TIME 74 9697
TEST_TIME 75 9718
TEST_TIME 76 9606
TEST_TIME 77 9575
TEST_TIME 78 9575
TEST_TIME 79 9486
TEST_TIME 80 9537
TEST_TIME 81 9472
TEST_TIME 82 9456
TEST_TIME 83 9399
TEST_TIME 84 9352
TEST_TIME 85 9276
TEST_TIME 86 9322
TEST_TIME 87 9295
TEST_TIME 88 9289
TEST_TIME 89 9252
TEST_TIME 90 9320
TEST_TIME 91 9391
TEST_TIME 92 9355
TEST_TIME 93 9377
TEST_TIME 94 9346
TEST_TIME 95 9446
TEST_TIME 96 9464
TEST_TIME 97 9479
TEST_TIME 98 9509
TEST_TIME 99 9494
TEST_TIME 100 9489
TEST_TIME 101 9463
TEST_TIME 102 9386
TEST_TIME 103 9380
TEST_TIME 104 9337
TEST_TIME 105 9320
TEST_TIME 106 9267
TEST_TIME 107 9236
TEST_TIME 108 9230
TEST_TIME 109 9193
TEST_TIME 110 9196
TEST_TIME 111 9176
TEST_TIME 112 9215
TEST_TIME 113 9199
TEST_TIME 114 9192
TEST_TIME 115 9167
TEST_TIME 116 9211
TEST_TIME 117 9233
TEST_TIME 118 9308
TEST_TIME 119 9280
TEST_TIME 120 9207

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-03-2021 19:31:59 to 04-03-2021 19:32:03.

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 1518187 1518187 0 0.00 0 25805 6 0 0
doc_list_biud 1518187 1518187 0 0.00 0 27562 28 0 0
sp_add_invoice_to_stock 4963 4852 111 2.23 32 255504 19473 0 111
sp_cancel_adding_invoice 5813 5813 0 0.00 5 72307 794 0 0
sp_cancel_client_order 1682 1682 0 0.00 4 15463 338 0 0
sp_cancel_customer_reserve 574370 574370 0 0.00 1 25747 59 0 0
sp_cancel_pay_from_customer 619 619 0 0.00 3 1819 60 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 622 54 0 0
sp_cancel_supplier_invoice 6400 6391 9 0.14 1 27567 775 0 9
sp_cancel_supplier_order 410 410 0 0.00 7 996174 103905 0 0
sp_cancel_write_off 9534 9534 0 0.00 1 17527 108 0 0
sp_client_order 20388 20388 0 0.00 4 20984 370 0 0
sp_customer_reserve 445559 445559 0 0.00 0 64068 196 0 0
sp_fill_shopping_cart 31116 31116 0 0.00 1 14376 41 0 0
sp_fill_shopping_cart_clo_res 445555 445555 0 0.00 0 20318 15 0 0
sp_get_clo_for_invoice 4845 4845 0 0.00 0 31209 320 0 0
sp_kill_cost_storno 16363 16363 0 0.00 0 11131 52 0 0
sp_kill_qstorno_ret_qs2qd 1165075 1165075 0 0.00 0 27559 32 0 0
sp_kill_qty_storno 612889 612889 0 0.00 0 27561 69 0 0
sp_lock_selected_doc 20245 20245 0 0.00 0 10379 4 0 0
sp_make_cost_storno 27321 27321 0 0.00 0 20462 48 0 0
sp_multiply_rows_for_pdistr 27321 27321 0 0.00 0 8890 26 0 0
sp_multiply_rows_for_qdistr 20388 20388 0 0.00 0 18682 170 0 0
sp_pay_from_customer 6934 6934 0 0.00 4 9576 104 0 0
sp_pay_to_supplier 5698 5698 0 0.00 5 9350 122 0 0
sp_payment_common 12632 12632 0 0.00 1 7122 24 0 0
sp_qd_handle_on_cancel_clo 1682 1682 0 0.00 0 15449 317 0 0
sp_qd_handle_on_invoice_upd_sts 10654 10654 0 0.00 0 17093 315 0 0
sp_qd_handle_on_reserve_upd_sts 9848 9848 0 0.00 0 8509 57 0 0
sp_reserve_write_off 9848 9848 0 0.00 5 18988 165 0 0
sp_supplier_invoice 5432 5432 0 0.00 7 97240 3711 0 0
sp_supplier_order 5318 5318 0 0.00 5 29082 1284 0 0
srv_aggregate_perf_data 96 95 1 1.04 3163 135666 18841 0 1
srv_fill_mon_cache_memory 159 159 0 0.00 1307 136732 33410 0 0
srv_find_qd_qs_mism 1058727 1058727 0 0.00 0 25805 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 22 34542 1016 0 0
srv_make_money_saldo 758 758 0 0.00 1 9230 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 178696 326902 248903 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 4852 4852 0 0.00 0 13836 185 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 0 5992 153 0 0
t$perf-norm:sp_cancel_client_order 1682 1682 0 0.00 0 6433 17 0 0
t$perf-norm:sp_cancel_customer_reserve 664 664 0 0.00 0 1491 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 619 619 0 0.00 0 2644 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 1614 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 378 378 0 0.00 0 663 14 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 20031 1704 0 0
t$perf-norm:sp_cancel_write_off 980 980 0 0.00 0 2160 7 0 0
t$perf-norm:sp_client_order 20388 20388 0 0.00 0 7862 18 0 0
t$perf-norm:sp_customer_reserve 987 987 0 0.00 0 2952 6 0 0
t$perf-norm:sp_pay_from_customer 6934 6934 0 0.00 0 7778 15 0 0
t$perf-norm:sp_pay_to_supplier 5698 5698 0 0.00 0 5661 11 0 0
t$perf-norm:sp_reserve_write_off 9848 9848 0 0.00 0 6918 12 0 0
t$perf-norm:sp_supplier_invoice 5432 5432 0 0.00 0 5762 18 0 0
t$perf-norm:sp_supplier_order 5318 5318 0 0.00 0 7000 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 97 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 178 4 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 3147 27 0 0
t$perf-norm:srv_make_money_saldo 758 758 0 0.00 0 2208 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9904 9682 222 2.24 0 4570 17 0 222
v_all_customers 36922 36922 0 0.00 0 22 1 0 0
v_all_suppliers 29698 29698 0 0.00 0 50 1 0 0
v_all_wares 40776 40776 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 1192 9 0 0
v_cancel_client_order 3364 3364 0 0.00 0 1998 4 0 0
v_cancel_customer_prepayment 1238 1238 0 0.00 0 1486 7 0 0
v_cancel_customer_reserve 1328 1328 0 0.00 0 9550 14 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 205 3 0 0
v_cancel_supplier_invoice 774 756 18 2.32 0 760 17 0 18
v_cancel_supplier_order 820 820 0 0.00 0 909 5 0 0
v_cancel_write_off 1960 1960 0 0.00 0 1269 14 0 0
v_max_id_clo_ord 5317 5317 0 0.00 0 408 1 0 0
v_max_id_clo_res 987 987 0 0.00 0 3902 20 0 0
v_max_id_ord_sup 5411 5411 0 0.00 0 6531 4 0 0
v_max_non_paid_invoice 1577 1577 0 0.00 0 154 2 0 0
v_max_non_paid_realizn 3722 3722 0 0.00 0 2422 4 0 0
v_min_id_clo_ord 5317 5317 0 0.00 0 1892 6 0 0
v_min_id_clo_res 987 987 0 0.00 0 5302 14 0 0
v_min_id_ord_sup 5411 5411 0 0.00 0 4886 10 0 0
v_min_non_paid_invoice 5698 5698 0 0.00 0 5472 15 0 0
v_min_non_paid_realizn 6934 6934 0 0.00 0 4582 14 0 0
v_our_firm 10278 10278 0 0.00 0 14 1 0 0
v_reserve_write_off 19696 19696 0 0.00 0 9556 7 0 0
x_lock_depdocs_on_canc_invoice 11826 11826 0 0.00 0 14267 114 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 32073 361 0 0
x_make_qstorno_1000_1200 5318 5318 0 0.00 1 29039 1203 0 0
x_make_qstorno_1200_2000 5432 5432 0 0.00 3 93410 3542 0 0
x_make_qstorno_2100_3300 445559 445559 0 0.00 0 64066 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-03-2021 19:32:04 to 04-03-2021 19:32:08.

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
17:01:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
17:01:22 13666 8192000000 10246021568 10548105216 886842496 9.768 70 56 112 0 909382832 2501536 20038800
17:01:43 34020 8192000000 10353617920 10675576832 1382642656 14.440 100 88 177 1 1416767616 4922496 29202464
17:02:32 42365 8192000000 10395716064 10721206272 1445363824 14.997 100 88 176 0 1480706304 6698768 28643712
17:03:24 30992 8192000000 10422202768 10750259200 1472761696 15.238 100 92 184 0 1510478816 7957040 29760080
17:04:03 30532 8192000000 10443277296 10775736320 1498546272 15.464 100 92 184 0 1537014352 8926608 29541472
17:04:44 20310 8192000000 10465075696 10801016832 1514830992 15.605 100 92 184 1 1553536288 9588304 29116992
17:05:14 23633 8192000000 10501144848 10845081600 1545759088 15.873 100 84 168 1 1581476320 9562416 26154816
17:05:46 10000 8192000000 10509660960 10859753472 1572570976 16.104 100 79 158 0 1606231520 10027664 23632880
17:06:06 14392 8192000000 10541704848 10892369920 1594145904 16.289 100 77 155 0 1627613520 10505472 22962144
17:06:29 11408 8192000000 10567905920 10926030848 1622315072 16.530 100 75 149 1 1655277616 10855584 22106960
17:06:50 11945 8192000000 10601316320 10960281600 1655116016 16.808 100 81 160 0 1690205856 11935552 23154288
17:07:10 10742 8192000000 10624996176 10987380736 1667230416 16.910 100 84 168 0 1704878432 13270656 24377360
17:07:29 8321 8192000000 10629848192 10993520640 1686610096 17.073 100 90 180 1 1730489792 18117344 25762352
17:07:46 13593 8192000000 10641762368 11011211264 1699968288 17.185 100 82 164 3 1737090096 14067008 23054800
17:08:07 8771 8192000000 10652729952 11025440768 1715956240 17.318 100 80 160 1 1752757760 13380688 23420832
17:08:31 9705 8192000000 10679669472 11053400064 1730699008 17.441 100 72 145 1 1763824992 12547056 20578928
17:08:48 5601 8192000000 10675532032 11053150208 1741261648 17.529 100 76 150 2 1775485568 12761936 21461984
17:09:01 3705 8192000000 10696966880 11076562944 1761179792 17.694 100 85 170 1 1798030176 12128848 24721536
17:09:13 5677 8192000000 10709450784 11087478784 1768283856 17.753 100 72 144 1 1800753056 12672992 19796208
17:09:27 3876 8192000000 10717026848 11098042368 1776398224 17.820 100 82 161 1 1812832048 14221984 22211840
17:09:38 3721 8192000000 10722148000 11108945920 1786639632 17.904 100 79 158 0 1821339648 13245120 21454896
17:09:49 7082 8192000000 10724011600 11106562048 1795726560 17.979 100 73 145 0 1832953872 17118544 20108768
17:10:04 3956 8192000000 10737148720 11125940224 1799561328 18.010 100 74 148 0 1832493600 12634400 20297872
17:10:16 2434 8192000000 10752344768 11140530176 1817055232 18.154 100 81 162 1 1851290368 11378048 22857088
17:10:25 1978 8192000000 10749634720 11137859584 1820367488 18.181 100 81 163 0 1856095968 12687472 23041008
17:10:33 3295 8192000000 10775392784 11159261184 1830673472 18.265 100 89 176 1 1868449552 13681600 24094480
17:10:43 1778 8192000000 10776063360 11160932352 1837981264 18.324 100 96 194 1 1879649344 14642224 27025856
17:10:52 1985 8192000000 10780538896 11168280576 1842456624 18.361 100 90 179 3 1882377728 14624080 25297024
17:11:00 3688 8192000000 10783822704 11173068800 1840334128 18.344 100 85 171 0 1877048240 13134752 23579360
17:11:11 1438 8192000000 10785936960 11176198144 1848136048 18.407 100 86 170 1 1885862304 12793984 24932272
17:11:19 2782 8192000000 10785402336 11179298816 1852288400 18.441 100 78 157 0 1884127072 10529776 21308896
17:11:29 1854 8192000000 10794705216 11189854208 1856974320 18.479 100 80 161 3 1890757664 11924528 21858816
17:11:37 1984 8192000000 10797828656 11192672256 1860069376 18.504 100 91 182 1 1897973824 12156288 25748160
17:11:45 1898 8192000000 10807710144 11197239296 1861005984 18.511 100 94 189 1 1900897712 13409392 26482336
17:11:54 2377 8192000000 10813322912 11200761856 1863962448 18.535 100 94 189 0 1905099072 14742608 26394016
17:12:03 4877 8192000000 10810411696 11199242240 1863211952 18.529 100 79 156 1 1898520480 14344416 20964112
17:12:14 15661 8192000000 10807109424 11198570496 1867835056 18.567 100 79 157 4 1900465984 10643840 21987088
17:12:37 10429 8192000000 10783107168 11197067264 1866084688 18.553 100 50 98 1 1889337088 8670080 14582320
17:12:54 4175 8192000000 10778248272 11199188992 1868196848 18.570 100 30 60 0 1883627344 7170080 8260416
17:13:05 5998 8192000000 10781099728 11201847296 1870940736 18.592 100 39 78 0 1890896384 8492752 11462896
17:13:19 5874 8192000000 10779836832 11203985408 1871035984 18.593 100 25 48 3 1883653920 6176416 6441520
17:13:32 1996 8192000000 10797026096 11212611584 1877506480 18.645 100 41 83 0 1897499648 8457184 11535984
17:13:43 2572 8192000000 10812095472 11215060992 1882777168 18.688 100 60 122 1 1907885872 7780960 17327744
17:13:53 3990 8192000000 10793251296 11211554816 1879233696 18.659 100 42 84 4 1899327344 8414160 11679488
17:14:03 8546 8192000000 10786912224 11215933440 1877883296 18.648 100 25 50 1 1896172448 11490352 6798800
17:14:22 10176 8192000000 10781667760 11217358848 1882955616 18.689 100 27 52 3 1896182848 6478480 6748752
17:14:39 8556 8192000000 10790695024 11220787200 1882573184 18.686 100 19 38 2 1894548784 6980848 4994752
17:14:55 7696 8192000000 10800869664 11226923008 1887962720 18.729 100 34 68 0 1908757136 11823696 8970720
17:15:09 8290 8192000000 10796435424 11230261248 1888785712 18.736 100 24 48 3 1901864848 6396096 6683040
17:15:24 12609 8192000000 10795163488 11230052352 1890927056 18.753 100 7 14 1 1898197920 5115504 2155360
17:15:48 11790 8192000000 10803251168 11235127296 1893370832 18.773 100 15 30 0 1907254432 9883072 4000528
17:16:11 55011 8192000000 10840618560 11250860032 1897491488 18.806 100 35 72 0 1914406160 4938688 11975984
17:17:12 12186 8192000000 10801905072 11246145536 1900075840 18.827 100 28 57 0 1916111072 8119888 7915344
17:17:34 5604 8192000000 10832434928 11254218752 1903715296 18.856 100 30 60 1 1918765728 6139984 8910448
17:17:46 5049 8192000000 10832544560 11262173184 1906941584 18.882 100 40 81 4 1926543248 8296992 11304672
17:17:57 3544 8192000000 10842324208 11265089536 1911397600 18.918 100 50 102 0 1933207248 8077856 13731792
17:18:08 10698 8192000000 10836196176 11264409600 1913232208 18.933 100 32 62 1 1928783920 7094976 8456736
17:18:25 9560 8192000000 10827162656 11265728512 1913156640 18.932 100 16 31 0 1922469744 4562208 4750896
17:18:42 7479 8192000000 10839609344 11269902336 1915403072 18.950 100 28 57 2 1929433888 5594272 8436544
17:18:55 6441 8192000000 10819091840 11257729024 1894549632 18.782 99 21 43 1 1906451232 6048592 5853008
17:19:10 5732 8192000000 10832049296 11264065536 1910930320 18.914 100 26 51 0 1923254464 4993776 7330368
17:19:23 8893 8192000000 10832745824 11266543616 1910499776 18.911 100 22 45 0 1922537312 5446352 6591184
17:19:39 11825 8192000000 10819188176 11252031488 1876049040 18.633 98 21 42 2 1888390848 5859504 6482304
17:19:57 5083 8192000000 10824213952 11253911552 1893348256 18.773 99 27 54 3 1907803888 6854128 7601504
17:20:12 18480 8192000000 10822608528 11224506368 1835629824 18.305 96 26 52 2 1848394928 5361232 7403872
17:20:38 58502 8192000000 10783685328 11227389952 1828114704 18.244 96 28 56 1 1841966576 6011696 7840176
17:21:43 14698 8192000000 10744872704 11166076928 1731652096 17.449 92 14 28 1 1740369216 4694512 4022608
17:22:05 5063 8192000000 10758578960 11180548096 1815066352 18.137 98 32 63 1 1830162784 6132800 8963632
17:22:16 4014 8192000000 10759656704 11179204608 1809412208 18.091 98 30 60 0 1824821072 7225696 8183168
17:22:28 5994 8192000000 10729907760 11149230080 1772191312 17.785 97 30 61 0 1786823760 6210416 8422032
17:22:43 6490 8192000000 10744479696 11162759168 1797145280 17.990 98 27 54 1 1811706336 6265504 8295552
17:22:58 11233 8192000000 10741469936 11163467776 1796776096 17.987 98 18 36 2 1807501024 5424576 5300352
17:23:17 12742 8192000000 10750149040 11181248512 1824551488 18.215 99 28 55 2 1839064032 5408176 9104368
17:23:36 7911 8192000000 10698334832 11114196992 1744293360 17.554 97 27 54 2 1757661424 5833344 7534720
17:23:51 9193 8192000000 10701053728 11123757056 1754238416 17.637 97 27 55 1 1768885392 7084512 7562464
17:24:06 6376 8192000000 10710497696 11125239808 1779470976 17.845 99 26 52 0 1792372112 5208240 7692896
17:24:20 10825 8192000000 10705349040 11121594368 1735619472 17.482 96 24 49 1 1747745936 5225744 6900720
17:24:37 9120 8192000000 10732326144 11142840320 1805253088 18.057 100 28 56 0 1819753264 5899504 8600672
17:24:53 17672 8192000000 10744942800 11157307392 1787337440 17.910 98 25 49 3 1798836528 4926816 6572272
17:25:17 76100 8192000000 10731227920 11163238400 1763292192 17.712 96 31 61 3 1778080096 5402624 9385280
17:26:39 8770 8192000000 10727016048 11154264064 1797143472 17.990 98 22 44 0 1808334704 5093744 6097488
17:26:56 5540 8192000000 10747163216 11157155840 1820988272 18.186 100 31 63 1 1837404400 6879616 9536512
17:27:10 5159 8192000000 10754754368 11176263680 1835531488 18.304 100 27 52 3 1849071536 6250224 7289824
17:27:22 7347 8192000000 10767813072 11185963008 1844693008 18.379 100 20 39 1 1855513072 5040864 5779200
17:27:38 7075 8192000000 10780175728 11198877696 1856683168 18.476 100 39 78 2 1874765824 6393232 11689424
17:27:52 7203 8192000000 10770273904 11196841984 1856234416 18.473 100 18 36 1 1866293680 4929280 5129984
17:28:08 5253 8192000000 10781149408 11208421376 1862871696 18.527 100 29 58 0 1877266272 5325648 9068928
17:28:21 9098 8192000000 10788262896 11214217216 1868759040 18.574 100 27 54 0 1881811392 5358272 7694080
17:28:36 10701 8192000000 10787570368 11216781312 1867155616 18.561 100 15 30 0 1885701184 14186512 4359056
17:28:57 12958 8192000000 10793678944 11217694720 1870332880 18.587 100 21 41 3 1882452816 5731344 6388592
17:29:18 12413 8192000000 10794575472 11223252992 1874693472 18.622 100 28 54 0 1888837456 5268032 8875952
17:29:37 5377 8192000000 10790886464 11225255936 1877814096 18.647 100 6 12 1 1884187840 4649376 1724368
17:29:48 14337 8192000000 10801908096 11235205120 1879011680 18.657 100 13 26 0 1892263552 9785104 3466768
17:30:12 19677 8192000000 10796008208 11230535680 1885084864 18.706 100 31 62 2 1900218848 5476384 9657600
17:30:39 64385 8192000000 10842285600 11256053760 1899138848 18.819 100 49 98 3 1918293648 5676608 13478192
17:31:51 18844 8192000000 10850116128 11271782400 1918616096 18.976 100 53 106 1 1942427264 9052528 14758640
17:32:47 7857 8192000000 10875179552 11298168832 1935009568 19.107 100 51 101 0 1961826688 12807568 14009552
17:33:07 22546 8192000000 10874350256 11302674432 1943537152 19.175 100 46 91 2 1964637680 8204512 12896016
17:33:37 33084 8192000000 10889026736 11317956608 1951471312 19.238 100 59 118 2 1984191568 15589136 17131120
17:34:40 41668 8192000000 10883963872 11328364544 1960939584 19.314 100 44 88 0 1988976432 15295408 12741440
17:35:32 8406 8192000000 10901846192 11335720960 1964040336 19.338 100 44 88 0 1995846064 18799408 13006320
17:35:47 15728 8192000000 10900846352 11339415552 1966658288 19.359 100 47 95 0 1995917088 15067280 14191520
17:36:11 8001 8192000000 10920880448 11350081536 1976611952 19.438 100 55 110 1 2009382384 16828208 15942224
17:36:30 3850 8192000000 10941397680 11359330304 1985871408 19.511 100 81 161 5 2027781696 18142416 23767872
17:36:41 7994 8192000000 10942696624 11365199872 1985763600 19.510 100 68 136 2 2025656544 20338240 19554704
17:37:17 16726 8192000000 10927710144 11366215680 1990893744 19.551 100 53 107 0 2024859152 18262112 15703296
17:37:43 18565 8192000000 10917536928 11360653312 1983992368 19.496 100 42 84 1 2013868128 16794832 13080928
17:38:10 21192 8192000000 10927468128 11370479616 1991432032 19.555 100 44 86 2 2022736864 18044928 13259904
17:38:43 3781 8192000000 10944897712 11379376128 1993063920 19.568 100 51 100 1 2027289424 19421312 14804192
17:38:54 11811 8192000000 10946187632 11382943744 1999596016 19.620 100 55 111 0 2038257520 21941136 16720368
17:39:34 5438 8192000000 10949858368 11383029760 1995457328 19.587 100 53 106 0 2037504592 25897920 16149344
17:39:46 3827 8192000000 10954444432 11379662848 1992923168 19.567 100 56 110 0 2035901648 26313472 16665008
17:39:58 1821 8192000000 10968251136 11388317696 2003575536 19.651 100 78 155 1 2058834960 32851904 22407520
17:40:08 11096 8192000000 10963230976 11393253376 2005402672 19.665 100 63 126 1 2053709664 29367680 18939312
17:40:27 3859 8192000000 10976331568 11403366400 2010174752 19.703 100 60 120 0 2057459456 29504096 17780608
17:40:38 5704 8192000000 10971312736 11405168640 2012119616 19.718 100 62 124 1 2060979232 30311552 18548064
17:40:51 2375 8192000000 10964493488 11397574656 2006086096 19.671 100 71 142 0 2057882928 30746000 21050832
17:41:01 5025 8192000000 10947550176 11370844160 1966740336 19.360 98 66 130 2 2018455808 31743424 19972048
17:41:13 8393 8192000000 10967613152 11384500224 1996144960 19.592 100 77 153 0 2052236384 33359024 22732400
17:41:31 1306 8192000000 10973404560 11396378624 2001930720 19.638 100 74 150 1 2058764448 33619008 23214720
17:41:41 5638 8192000000 10975325520 11399077888 2004330128 19.657 100 71 139 1 2057340688 31924368 21086192
17:42:10 9052 8192000000 10960613936 11392331776 1999001632 19.615 100 54 107 0 2047850960 32509536 16339792
17:42:27 4473 8192000000 10970536608 11404345344 2009443072 19.697 100 63 126 0 2059228928 31110880 18674976
17:42:39 2773 8192000000 10984559088 11405561856 2007605616 19.683 100 74 148 1 2062169600 32028608 22535376
17:42:49 15762 8192000000 10976755920 11406094336 2008087856 19.686 100 69 138 1 2061244656 33046080 20110720
17:43:15 7974 8192000000 10947504224 11372863488 1964762256 19.344 98 60 116 3 2013987184 31621152 17603776
17:43:34 1810 8192000000 10958838032 11381723136 1992770000 19.566 100 81 163 2 2048695904 32237104 23688800
17:43:45 1919 8192000000 10966509936 11386286080 1994231472 19.577 100 72 144 2 2048946160 32866400 21848288
17:43:54 4126 8192000000 10968322080 11398672384 1986745104 19.518 99 67 134 0 2040529552 33045744 20738704
17:44:06 4505 8192000000 10962708128 11389952000 1994244464 19.577 100 70 140 1 2046316976 31629056 20443456
17:44:19 7081 8192000000 10973225328 11401437184 2004006880 19.654 100 67 135 1 2062609680 37257360 21345440
17:44:33 9259 8192000000 10973610240 11401519104 2004079872 19.655 100 76 145 2 2060233088 33547904 22605312
17:44:50 3191 8192000000 10970873216 11401875456 2003795856 19.653 100 68 137 2 2058465344 33595680 21073808
17:45:00 3301 8192000000 10999485104 11417178112 2013025872 19.725 100 84 165 1 2073549792 34737008 25786912
17:45:10 3344 8192000000 10995846224 11414573056 2013715472 19.731 100 87 174 5 2076111904 35543552 26852880
17:45:21 3947 8192000000 11007210800 11423473664 2019668768 19.778 100 76 148 1 2080108960 36448192 23992000
17:45:33 3370 8192000000 11004352112 11426136064 2002142032 19.640 99 82 163 0 2065364016 38668960 24553024
17:45:43 2888 8192000000 10977799360 11391393792 1991415344 19.555 100 81 162 2 2056055824 39630288 25010192
17:45:52 2957 8192000000 10951642592 11363442688 1949666288 19.224 98 83 163 1 2014754736 40130800 24957648
17:46:04 3548 8192000000 10958461184 11362340864 1962694848 19.327 100 88 174 1 2031500736 42020672 26785216
17:46:16 3766 8192000000 10964857696 11376492544 1974786368 19.423 100 88 176 1 2045544320 42577360 28180592
17:46:26 3994 8192000000 10935657664 11350126592 1937145344 19.124 98 75 147 2 1999767168 38870304 23751520
17:46:37 3683 8192000000 10954266880 11364265984 1967423280 19.365 100 87 174 2 2034353328 39788080 27141968
17:46:51 4211 8192000000 10957258048 11365900288 1954009952 19.258 99 80 160 0 2018654432 39987728 24656752
17:47:03 9236 8192000000 10948934560 11366522880 1954821824 19.265 99 77 154 1 2019365232 41005024 23538384
17:47:23 12336 8192000000 10961799424 11386163200 1977282688 19.443 100 70 138 0 2044127248 45345280 21499280
17:47:46 8275 8192000000 10957135616 11381723136 1962052000 19.322 99 62 124 1 2031287152 48539776 20695376
17:48:01 2198 8192000000 10955700224 11374288896 1967489696 19.366 100 74 148 3 2040931424 49491824 23949904
17:48:12 2723 8192000000 10964932448 11372617728 1966848864 19.360 100 81 161 5 2043639248 50043008 26747376
17:48:22 3681 8192000000 10956002160 11379638272 1950678736 19.232 99 70 140 0 2026205440 51441184 24085520
17:48:32 2359 8192000000 10968463488 11380989952 1969738208 19.383 100 83 166 4 2046898480 49247776 27912496
17:48:43 2745 8192000000 10962516640 11378520064 1972108496 19.402 100 83 165 3 2042206896 43534912 26563488
17:48:52 3733 8192000000 10956864432 11369435136 1964747776 19.344 100 86 173 1 2039023072 46264704 28010592
17:49:03 3486 8192000000 10949988464 11364253696 1959115232 19.299 100 81 158 2 2032554160 47867344 25571584
17:49:16 4732 8192000000 10957732992 11371720704 1963956768 19.337 100 73 146 2 2036277008 48792768 23527472
17:49:28 3889 8192000000 10943758592 11364945920 1952151632 19.244 100 68 135 0 2026080016 52331200 21597184
17:49:40 3888 8192000000 10962284112 11376447488 1961996304 19.322 100 76 152 0 2041190560 53945920 25248336
17:49:51 6053 8192000000 10957657328 11385622528 1964905008 19.345 100 69 136 1 2040785216 53399888 22480320
17:50:07 7385 8192000000 10950689792 11385139200 1971269184 19.396 100 60 120 0 2043016928 52438048 19309696
17:50:22 18877 8192000000 10954548816 11401445376 1978718368 19.455 100 48 96 1 2045412880 50621616 16072896
17:50:51 18513 8192000000 10944899536 11377459200 1957322416 19.285 99 42 84 4 2022849280 51303440 14223424
17:51:16 11631 8192000000 10947972960 11392135168 1965736416 19.352 100 33 66 0 2023691760 46152064 11803280
17:51:36 17261 8192000000 10946598176 11391815680 1967101168 19.362 100 32 63 4 2028538704 50063296 11374240
17:52:03 9067 8192000000 10939462704 11379826688 1930838512 19.074 98 46 90 1 1992489200 46626880 15023808
17:52:23 9775 8192000000 10942498736 11385114624 1960258848 19.308 100 42 84 0 2023893744 49982208 13652688
17:52:39 10791 8192000000 10935569744 11382087680 1953034624 19.251 100 27 54 0 2015932256 53097408 9800224
17:53:00 23289 8192000000 10915641840 11358830592 1885961264 18.713 96 37 74 0 1960495120 61612976 12920880
17:53:30 11144 8192000000 10927911280 11363950592 1938026496 19.131 100 39 78 0 2005088544 53664304 13397744
17:53:48 35346 8192000000 10916344592 11377033216 1949441072 19.222 100 32 64 2 2016670912 56030624 11199216
17:54:36 17967 8192000000 10916944496 11379625984 1956042384 19.275 100 32 64 2 2015808000 48915584 10850032
17:55:15 17214 8192000000 10898369808 11357523968 1935895520 19.114 99 20 40 0 1977391088 34957536 6538032
17:55:44 21209 8192000000 10905548528 11362697216 1950850320 19.233 100 20 40 1 1990384736 33098368 6436048
17:56:18 38217 8192000000 10896597984 11358990336 1908499424 18.895 98 18 36 1 1958825872 43517632 6808816
17:57:03 26812 8192000000 10878150576 11337416704 1896503712 18.798 98 15 30 0 1934304512 32960464 4840336
17:58:08 48290 8192000000 10895399888 11320659968 1919671008 18.984 99 46 93 1 1941416576 7856704 13888864
17:59:13 87073 8192000000 10874615200 11317141504 1925783504 19.033 99 44 85 1 1948161248 10030672 12347072
18:00:47 8308 8192000000 10894140368 11330879488 1944386032 19.182 100 51 104 1 1971083440 11914864 14782544
18:01:02 13594 8192000000 10888732064 11335266304 1947097024 19.203 100 44 88 0 1974224304 14197440 12929840
18:01:21 13722 8192000000 10861757616 11317182464 1919143216 18.980 99 31 62 3 1942413072 14319728 8950128
18:01:44 30799 8192000000 10901085760 11326185472 1941842416 19.161 100 43 84 2 1964259152 9931152 12485584
18:02:21 14276 8192000000 10871329280 11321909248 1939073488 19.139 100 37 74 1 1960668256 10932096 10662672
18:02:51 92866 8192000000 10878147152 11333054464 1934805088 19.105 99 34 64 2 1953142704 10284704 8052912
18:04:42 40237 8192000000 10874823952 11353608192 1959355424 19.301 100 9 18 1 1969983248 8392016 2235808
18:05:55 47748 8192000000 10890815152 11356540928 1952638848 19.247 99 15 30 2 1963970800 7248320 4083632
18:06:57 14286 8192000000 10882337136 11351846912 1949573952 19.223 99 10 20 0 1959322544 7355344 2393248
18:07:18 12719 8192000000 10885830544 11358896128 1967432816 19.365 100 14 28 0 1980228144 8724272 4071056
18:08:34 107760 8192000000 10870160208 11353583616 1949629264 19.224 99 19 38 1 1964077040 8494848 5952928
18:10:31 85470 8192000000 10907085600 11373649920 1978071504 19.449 100 18 36 1 1990664400 7305968 5286928
18:12:33 60800 8192000000 10904265936 11389296640 1986474784 19.516 100 6 12 0 1997585328 9469264 1641280
18:13:40 49418 8192000000 10905484240 11380580352 1968236400 19.371 99 12 24 0 1983105072 11544400 3324272
18:14:41 73053 8192000000 10908590528 11380633600 1923370928 19.014 97 10 20 1 1937320016 11026736 2922352
18:16:04 31870 8192000000 10932170688 11385442304 1968875888 19.377 99 51 102 2 2003503136 19814880 14812368
18:16:49 28618 8192000000 10927103920 11393064960 1989366704 19.539 100 24 48 1 2013151552 16866896 6917952
18:17:23 35089 8192000000 10941241120 11407470592 1990929152 19.551 100 26 52 2 2015484000 16995392 7559456
18:18:05 49141 8192000000 10944151584 11412369408 1985133200 19.505 99 17 34 1 2011448144 20914448 5400496
18:19:26 84899 8192000000 10932267632 11422355456 1995266736 19.585 100 20 40 1 2027906624 26069280 6570608
18:21:18 64689 8192000000 10930922624 11399483392 1996229424 19.593 100 20 40 2 2018230432 16212448 5788560
18:22:52 84282 8192000000 10918557904 11403788288 1937455136 19.126 97 8 16 2 1958599872 18956480 2188256
18:24:22 91639 8192000000 10927724016 11381334016 1912940816 18.930 96 21 42 1 1935634416 16922464 5771136
18:26:07 61161 8192000000 10909783680 11376746496 1960930160 19.313 99 23 46 2 1977623136 10196336 6496640
18:27:19 91770 8192000000 10877927488 11354222592 1934020000 19.099 98 29 58 0 1956723296 14352320 8350976
18:28:59 41335 8192000000 10908822208 11356766208 1935948000 19.114 98 39 76 0 1956148976 9799392 10401584
18:29:46 80514 8192000000 10875497984 11355566080 1917087584 18.964 97 32 64 0 1940918000 14593856 9236560
18:31:35 77871 8192000000 10853275536 11325616128 1893719440 18.776 97 18 34 3 1916755280 17800624 5235216
18:33:07 49379 8192000000 10851857968 11328667648 1899378736 18.821 98 12 24 0 1921086880 18166688 3541456
18:34:03 73682 8192000000 10854511232 11324215296 1859036192 18.495 96 12 24 1 1871829792 9845616 2947984
18:35:23 87708 8192000000 10874556544 11347767296 1880569872 18.670 97 15 30 3 1892821568 8577152 3674544
18:38:07 64544 8192000000 10864519808 11337003008 1881944352 18.681 96 17 34 1 1906883776 20216208 4723216
18:39:19 43948 8192000000 10868763664 11330240512 1867103280 18.561 96 24 46 4 1892650320 18559024 6988016
18:40:10 54781 8192000000 10873071536 11335786496 1897030048 18.802 98 18 36 0 1922370592 20275024 5065520
18:41:13 43279 8192000000 10855895376 11311603712 1861008464 18.511 96 39 78 1 1882672464 10765168 10898832
18:42:10 133799 8192000000 10877704368 11349438464 1875127200 18.626 97 19 38 1 1898285664 17497184 5661280
18:44:30 84211 8192000000 10853136864 11321290752 1829135504 18.252 94 16 32 0 1853000608 19788976 4076128
18:46:01 136732 8192000000 10856133760 11315646464 1838387088 18.328 95 20 40 0 1858991408 15153216 5451104
18:48:36 94056 8192000000 10876095296 11341840384 1884482576 18.701 97 23 46 0 1903712016 13050496 6178944
18:50:37 9694 8192000000 10856132336 11319226368 1917956928 18.970 100 32 64 4 1946568208 19626048 8985232
18:50:56 33772 8192000000 10864269920 11319980032 1930752128 19.073 100 32 63 1 1956454592 15999744 9702720
18:51:37 56611 8192000000 10847892256 11324850176 1882438016 18.685 97 12 24 0 1898078320 12434160 3206144
18:52:40 40407 8192000000 10828180656 11301486592 1871246416 18.594 97 10 20 1 1882683872 9012816 2424640
18:53:53 47311 8192000000 10837501264 11313885184 1907530128 18.887 99 10 20 0 1922042896 11732784 2779984
18:54:46 26127 8192000000 10859491904 11327365120 1931302560 19.077 100 8 16 0 1945946128 12066048 2577520
18:56:12 96137 8192000000 10866408608 11349983232 1947830368 19.209 100 16 30 3 1962122064 10120720 4170976
18:57:55 61357 8192000000 10861168496 11333472256 1856537264 18.475 95 11 22 2 1867046160 7603328 2905568
18:59:03 63239 8192000000 10900061520 11363966976 1954663904 19.264 100 26 52 1 1974969376 12693856 7611616
19:00:17 28377 8192000000 10882728880 11351347200 1922260768 19.005 98 23 46 1 1940156160 11344400 6550992
19:00:56 71461 8192000000 10899470688 11382231040 1954240160 19.260 100 22 44 1 1976555136 16267632 6047344
19:02:19 60455 8192000000 10879481600 11348611072 1905790400 18.873 97 7 14 0 1920377120 12924432 1662288
19:03:25 28689 8192000000 10904468720 11361050624 1952111536 19.243 99 30 60 0 1967383728 7532160 7740032
19:04:03 40335 8192000000 10906402368 11374702592 1975895504 19.432 100 37 74 2 1996319952 10300608 10123840
19:04:57 30678 8192000000 10916956464 11385679872 1986999520 19.520 100 37 74 1 2011271408 13471520 10800368
19:05:42 79775 8192000000 10910411344 11386929152 1941006640 19.155 98 16 32 0 1961607184 15770384 4830160
19:07:25 79494 8192000000 10919616544 11395092480 1974363584 19.420 100 16 32 2 1989952192 10515376 5073232
19:08:53 59146 8192000000 10917903568 11397038080 1981982864 19.480 100 14 28 0 2004624560 18757904 3883792
19:10:03 61070 8192000000 10922799840 11387875328 1946370336 19.198 98 22 44 2 1967667856 15373424 5924096
19:11:17 49419 8192000000 10928888752 11394654208 1988144256 19.529 100 27 55 1 2006029680 10640848 7244576
19:12:19 7339 8192000000 10956014880 11402919936 2002168288 19.640 100 62 123 3 2029576464 9620384 17787792
19:12:41 81263 8192000000 10947176128 11410575360 2005028192 19.662 100 46 92 1 2027842112 9864784 12949136
19:14:14 75622 8192000000 10907310048 11393630208 1944345536 19.181 97 8 16 0 1954431648 7234208 2851904
19:15:36 52948 8192000000 10913777328 11394269184 1960674416 19.311 98 19 38 1 1978087328 12614496 4798416
19:16:35 41229 8192000000 10910855456 11400790016 1988820656 19.534 100 8 16 1 2006615840 15465552 2329632
19:17:29 66727 8192000000 10907278352 11383787520 1981133936 19.474 99 9 18 0 1994631760 10684432 2813392
19:18:42 42942 8192000000 10877405248 11365650432 1914254960 18.941 96 17 34 1 1929439408 10332368 4852080
19:19:37 74374 8192000000 10896019216 11383017472 1984259152 19.498 100 17 34 1 1997173008 8044464 4869392
19:21:14 52945 8192000000 10899355072 11361316864 1883550576 18.694 95 19 38 0 1896602576 8498704 4553296
19:22:14 37156 8192000000 10870058352 11343364096 1923693008 19.016 98 19 38 1 1937114096 7923152 5497936
19:23:02 86691 8192000000 10864156368 11338907648 1877878848 18.648 96 17 34 0 1898631072 15882224 4870000
19:24:36 41590 8192000000 10874219888 11344416768 1912518048 18.927 98 15 30 1 1926219312 9254624 4446640
19:25:27 46445 8192000000 10859992896 11318521856 1858122992 18.488 95 34 68 1 1878979088 10798592 10057504
19:26:20 23760 8192000000 10832137952 11279511552 1840238016 18.343 95 36 72 1 1862294048 12119312 9936720
19:26:52 37556 8192000000 10842256272 11302445056 1854421760 18.458 97 28 56 0 1877195328 15086848 7686720
19:27:35 105870 8192000000 10859377696 11336085504 1895666544 18.791 98 21 42 3 1921269264 19734000 5868720
19:29:38 79238 8192000000 10863562176 11322126336 1846373824 18.393 95 20 40 2 1860532816 8410160 5748832
19:31:03 11600 8192000000 10000847488 10374553600 1128075696 12.103 58 33 65 2 1143935248 7063600 8795952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-03-2021 19:32:10 to 04-03-2021 19:32:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 111 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 04-03-2021 19:32:42 to 04-03-2021 19:32:43.

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          238335
MON$OLDEST_ACTIVE               239081
MON$OLDEST_SNAPSHOT             239081
MON$NEXT_TRANSACTION            239081
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                       2012224
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Mar  4 19:31:18 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Mar  4 19:31:23 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Thu Mar  4 19:31:23 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Thu Mar  4 19:31:23 2021
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
--- end of diff output ---

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

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