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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17009136 kB
MemAvailable 31088628 kB
Buffers 0 kB
Cached 14673836 kB
SwapCached 3256 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-02-25 22:27:21
DTS_END                         2021-02-25 22:27:21.9890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53196
TRN_ID                          236949
ATT_ID                          672
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: 9302.52 21832 1116302
customer order: creation 169.67 397 20360
customer order: refuse 15.02 336 1802
order to supplier: creation 44.94 1446 5393
order to supplier: removal 3.43 94401 412
invoice (draft): creation 44.79 3568 5375
invoice (draft): removal 53.93 766 6471
invoice accept: apply 41.48 18531 4977
invoice accept: cancel 48.62 656 5834
customer reserve: creation 3839.39 183 460727
customer reserve: removal 4747.52 52 569703
realization accept: apply 82.24 161 9869
realization accept: cancel 83.97 103 10076
payment from customer: creation 57.58 116 6909
payment from customer: removal 5.65 63 678
payment to supplier: creation 48.72 138 5846
payment to supplier: removal 3.37 75 404
service: total inventory turnovers 4.92 888 590
service: total monetary turnovers 6.40 20 768
service: aggregate perf. data 0.87 15360 104
service: refresh index statistics 0.03 299378 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-02-2021 22:28:11 to 25-02-2021 22:28:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7067
TEST_TIME 2 4366
TEST_TIME 3 5771
TEST_TIME 4 5305
TEST_TIME 5 6219
TEST_TIME 6 5766
TEST_TIME 7 5825
TEST_TIME 8 6014
TEST_TIME 9 6040
TEST_TIME 10 6136
TEST_TIME 11 6012
TEST_TIME 12 6181
TEST_TIME 13 6305
TEST_TIME 14 6397
TEST_TIME 15 6425
TEST_TIME 16 6796
TEST_TIME 17 6740
TEST_TIME 18 6638
TEST_TIME 19 7020
TEST_TIME 20 7356
TEST_TIME 21 7864
TEST_TIME 22 7932
TEST_TIME 23 8243
TEST_TIME 24 8116
TEST_TIME 25 9342
TEST_TIME 26 9697
TEST_TIME 27 9944
TEST_TIME 28 10420
TEST_TIME 29 10275
TEST_TIME 30 10360
TEST_TIME 31 10097
TEST_TIME 32 9924
TEST_TIME 33 9881
TEST_TIME 34 9787
TEST_TIME 35 9665
TEST_TIME 36 9595
TEST_TIME 37 9604
TEST_TIME 38 9700
TEST_TIME 39 9737
TEST_TIME 40 9788
TEST_TIME 41 9688
TEST_TIME 42 9560
TEST_TIME 43 9535
TEST_TIME 44 9343
TEST_TIME 45 9440
TEST_TIME 46 9494
TEST_TIME 47 9514
TEST_TIME 48 9565
TEST_TIME 49 9535
TEST_TIME 50 9514
TEST_TIME 51 9553
TEST_TIME 52 9548
TEST_TIME 53 9506
TEST_TIME 54 9488
TEST_TIME 55 9599
TEST_TIME 56 9739
TEST_TIME 57 9703
TEST_TIME 58 9742
TEST_TIME 59 9751
TEST_TIME 60 9597
TEST_TIME 61 9545
TEST_TIME 62 9472
TEST_TIME 63 9412
TEST_TIME 64 9398
TEST_TIME 65 9443
TEST_TIME 66 9358
TEST_TIME 67 9274
TEST_TIME 68 9237
TEST_TIME 69 9421
TEST_TIME 70 9413
TEST_TIME 71 9387
TEST_TIME 72 9335
TEST_TIME 73 9364
TEST_TIME 74 9432
TEST_TIME 75 9409
TEST_TIME 76 9443
TEST_TIME 77 9494
TEST_TIME 78 9535
TEST_TIME 79 9545
TEST_TIME 80 9522
TEST_TIME 81 9508
TEST_TIME 82 9406
TEST_TIME 83 9362
TEST_TIME 84 9356
TEST_TIME 85 9347
TEST_TIME 86 9294
TEST_TIME 87 9270
TEST_TIME 88 9234
TEST_TIME 89 9264
TEST_TIME 90 9227
TEST_TIME 91 9234
TEST_TIME 92 9226
TEST_TIME 93 9287
TEST_TIME 94 9307
TEST_TIME 95 9347
TEST_TIME 96 9350
TEST_TIME 97 9419
TEST_TIME 98 9428
TEST_TIME 99 9444
TEST_TIME 100 9434
TEST_TIME 101 9409
TEST_TIME 102 9421
TEST_TIME 103 9440
TEST_TIME 104 9363
TEST_TIME 105 9336
TEST_TIME 106 9347
TEST_TIME 107 9316
TEST_TIME 108 9273
TEST_TIME 109 9253
TEST_TIME 110 9233
TEST_TIME 111 9204
TEST_TIME 112 9179
TEST_TIME 113 9248
TEST_TIME 114 9237
TEST_TIME 115 9282
TEST_TIME 116 9252
TEST_TIME 117 9287
TEST_TIME 118 9285
TEST_TIME 119 9319
TEST_TIME 120 9304

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2021 22:28:15 to 25-02-2021 22:28:18.

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 1543181 1543181 0 0.00 0 29714 7 0 0
doc_list_biud 1543180 1543180 0 0.00 0 74975 25 0 0
sp_add_invoice_to_stock 5144 4977 167 3.24 37 198262 18532 0 167
sp_cancel_adding_invoice 5834 5834 0 0.00 4 69462 657 0 0
sp_cancel_client_order 1802 1802 0 0.00 4 13297 337 0 0
sp_cancel_customer_reserve 569703 569703 0 0.00 1 35564 53 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 3 2102 64 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 3 6625 75 0 0
sp_cancel_supplier_invoice 6485 6471 14 0.21 2 74993 767 0 14
sp_cancel_supplier_order 412 412 0 0.00 8 1117906 94402 0 0
sp_cancel_write_off 10076 10076 0 0.00 1 12263 103 0 0
sp_client_order 20360 20360 0 0.00 3 29473 397 0 0
sp_customer_reserve 460727 460727 0 0.00 0 51011 184 0 0
sp_fill_shopping_cart 31124 31124 0 0.00 1 17076 36 0 0
sp_fill_shopping_cart_clo_res 460724 460724 0 0.00 0 12532 14 0 0
sp_get_clo_for_invoice 4973 4973 0 0.00 0 22616 305 0 0
sp_kill_cost_storno 16992 16992 0 0.00 0 12252 54 0 0
sp_kill_qstorno_ret_qs2qd 1156365 1156365 0 0.00 0 74965 29 0 0
sp_kill_qty_storno 609140 609140 0 0.00 0 74971 63 0 0
sp_lock_selected_doc 20572 20572 0 0.00 0 6724 6 0 0
sp_make_cost_storno 27597 27597 0 0.00 0 21117 57 0 0
sp_multiply_rows_for_pdistr 27597 27597 0 0.00 0 8628 29 0 0
sp_multiply_rows_for_qdistr 20360 20360 0 0.00 0 22068 183 0 0
sp_pay_from_customer 6909 6909 0 0.00 4 19705 117 0 0
sp_pay_to_supplier 5846 5846 0 0.00 5 19809 138 0 0
sp_payment_common 12755 12755 0 0.00 1 10091 28 0 0
sp_qd_handle_on_cancel_clo 1802 1802 0 0.00 0 13287 310 0 0
sp_qd_handle_on_invoice_upd_sts 10807 10807 0 0.00 0 13825 297 0 0
sp_qd_handle_on_reserve_upd_sts 9869 9869 0 0.00 0 10586 48 0 0
sp_reserve_write_off 9869 9869 0 0.00 6 17655 161 0 0
sp_supplier_invoice 5375 5375 0 0.00 6 86024 3569 0 0
sp_supplier_order 5393 5393 0 0.00 5 61078 1446 0 0
srv_aggregate_perf_data 105 104 1 0.95 3555 146269 15361 0 1
srv_fill_mon_cache_memory 163 163 0 0.00 1048 209488 31790 0 0
srv_find_qd_qs_mism 1069245 1069245 0 0.00 0 29713 6 0 0
srv_make_invnt_saldo 590 590 0 0.00 50 20142 888 0 0
srv_make_money_saldo 768 768 0 0.00 1 266 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 119548 495422 299379 0 0
t$perf-abend:sp_add_invoice_to_stock 167 167 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4977 4977 0 0.00 0 32443 158 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 1 7961 125 0 0
t$perf-norm:sp_cancel_client_order 1802 1802 0 0.00 0 3397 11 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 498 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 9514 27 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 575 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 1371 19 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 20494 1246 0 0
t$perf-norm:sp_cancel_write_off 982 982 0 0.00 0 4943 10 0 0
t$perf-norm:sp_client_order 20360 20360 0 0.00 0 10402 18 0 0
t$perf-norm:sp_customer_reserve 971 971 0 0.00 0 5309 9 0 0
t$perf-norm:sp_pay_from_customer 6909 6909 0 0.00 0 5871 12 0 0
t$perf-norm:sp_pay_to_supplier 5846 5846 0 0.00 0 5293 10 0 0
t$perf-norm:sp_reserve_write_off 9869 9869 0 0.00 0 5818 9 0 0
t$perf-norm:sp_supplier_invoice 5375 5375 0 0.00 0 8395 13 0 0
t$perf-norm:sp_supplier_order 5393 5393 0 0.00 0 5697 19 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 228 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1595 17 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 2427 21 0 0
t$perf-norm:srv_make_money_saldo 768 768 0 0.00 0 617 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 10280 9946 334 3.24 0 3187 17 0 334
v_all_customers 37106 37106 0 0.00 0 14 1 0 0
v_all_suppliers 29922 29922 0 0.00 0 20 1 0 0
v_all_wares 40720 40720 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 90 5 0 0
v_cancel_client_order 3604 3604 0 0.00 0 3075 6 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 1989 5 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 1532 5 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 540 4 0 0
v_cancel_supplier_invoice 846 818 28 3.30 0 397 14 0 28
v_cancel_supplier_order 824 824 0 0.00 0 1117 10 0 0
v_cancel_write_off 1964 1964 0 0.00 0 3115 17 0 0
v_max_id_clo_ord 5393 5393 0 0.00 0 382 1 0 0
v_max_id_clo_res 971 971 0 0.00 0 1672 9 0 0
v_max_id_ord_sup 5370 5370 0 0.00 0 7777 5 0 0
v_max_non_paid_invoice 1647 1647 0 0.00 0 345 3 0 0
v_max_non_paid_realizn 3712 3712 0 0.00 0 4152 5 0 0
v_min_id_clo_ord 5393 5393 0 0.00 0 17043 12 0 0
v_min_id_clo_res 971 971 0 0.00 0 3168 5 0 0
v_min_id_ord_sup 5370 5370 0 0.00 0 8282 5 0 0
v_min_non_paid_invoice 5846 5846 0 0.00 0 5796 22 0 0
v_min_non_paid_realizn 6909 6909 0 0.00 0 8256 15 0 0
v_our_firm 10008 10008 0 0.00 0 20 1 0 0
v_reserve_write_off 19736 19736 0 0.00 0 5694 6 0 0
x_lock_depdocs_on_canc_invoice 11896 11896 0 0.00 0 13007 102 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 7511 310 0 0
x_make_qstorno_1000_1200 5393 5393 0 0.00 2 61075 1363 0 0
x_make_qstorno_1200_2000 5375 5375 0 0.00 3 78388 3446 0 0
x_make_qstorno_2100_3300 460727 460727 0 0.00 0 51009 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-02-2021 22:28:19 to 25-02-2021 22:28:23.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:25 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:31 8084 8192000000 10124155696 10412560384 742662560 8.312 61 43 90 0 759195664 1861584 14671520
19:57:47 34282 8192000000 10339440208 10651635712 1342227968 14.077 100 81 162 0 1372973776 4194544 26551264
19:58:31 32838 8192000000 10373470624 10694139904 1423248160 14.801 100 92 184 0 1459178480 5964784 29965536
19:59:11 28590 8192000000 10396196864 10721677312 1450301488 15.041 100 91 182 0 1487329792 7066752 29961552
19:59:50 34861 8192000000 10432143824 10762293248 1476552160 15.271 100 85 170 0 1512554208 8009264 27992784
20:00:34 23669 8192000000 10452436992 10787889152 1505753520 15.526 100 86 172 1 1542708592 8726576 28228496
20:01:09 19599 8192000000 10470452976 10811019264 1525374560 15.697 100 84 168 2 1561028432 9196832 26457040
20:01:38 22561 8192000000 10499947568 10845532160 1555505840 15.957 100 87 174 0 1592269024 9401616 27361568
20:02:11 15717 8192000000 10511637216 10864570368 1574635280 16.122 100 78 156 1 1608975680 9901008 24439392
20:02:36 9641 8192000000 10535271632 10886651904 1597029136 16.314 100 80 160 0 1631699008 10280800 24389072
20:02:57 10777 8192000000 10558880336 10915635200 1618964272 16.501 100 84 168 0 1655107584 10794144 25349168
20:03:17 16932 8192000000 10597820864 10958553088 1651677328 16.779 100 75 150 2 1684138400 10600192 21860880
20:03:43 10951 8192000000 10610877648 10975789056 1671840880 16.949 100 81 162 1 1708379824 12580784 23958160
20:04:03 12569 8192000000 10633468144 11000659968 1693928464 17.134 100 84 168 1 1731060432 12619632 24512336
20:04:23 9305 8192000000 10646552048 11018530816 1702061808 17.202 100 78 156 1 1738084384 13492752 22529824
20:04:39 8871 8192000000 10660895616 11033427968 1713900160 17.301 100 74 148 0 1748820832 13625584 21295088
20:04:56 7037 8192000000 10656355520 11036037120 1723431504 17.381 100 69 138 1 1755783120 13005392 19346224
20:05:13 7003 8192000000 10690992576 11066605568 1744442544 17.556 100 80 159 2 1780116688 13286752 22387392
20:05:28 3869 8192000000 10701956848 11078979584 1758697024 17.674 100 77 154 1 1793188928 13033920 21457984
20:05:42 12848 8192000000 10698125024 11084103680 1769315104 17.761 100 74 147 1 1802338112 12297408 20725600
20:06:02 6352 8192000000 10705805872 11094478848 1776649984 17.822 100 72 144 2 1808630624 11373248 20607392
20:06:16 3393 8192000000 10730566640 11118301184 1792762208 17.954 100 67 134 0 1823677840 12045040 18870592
20:06:26 3701 8192000000 10748883008 11132207104 1803494144 18.043 100 87 173 1 1840050112 12617568 23938400
20:06:37 4581 8192000000 10748805488 11138760704 1812483072 18.116 100 80 158 1 1847756272 12358480 22914720
20:06:51 3012 8192000000 10759838256 11144601600 1822044496 18.194 100 87 174 0 1860959312 13343008 25571808
20:07:01 3271 8192000000 10770233152 11155021824 1830666160 18.265 100 84 168 0 1866943392 12688528 23588704
20:07:11 2750 8192000000 10769796896 11159433216 1835939936 18.308 100 84 168 2 1873055216 13216288 23898992
20:07:21 3463 8192000000 10780544688 11169308672 1840443728 18.344 100 88 175 0 1878181760 13663696 24074336
20:07:32 2638 8192000000 10788162448 11173838848 1842834048 18.364 100 86 171 0 1880459872 13774640 23851184
20:07:42 2271 8192000000 10786642032 11175972864 1842171216 18.358 100 84 166 1 1879216816 13723952 23321648
20:07:51 2634 8192000000 10791280368 11182067712 1851198272 18.432 100 92 185 0 1890479728 14182208 25099248
20:08:00 2004 8192000000 10797155552 11184304128 1853117440 18.447 100 95 188 2 1894572384 14690656 26764288
20:08:09 1877 8192000000 10800542448 11185283072 1858002560 18.487 100 83 166 0 1895993520 14825936 23165024
20:08:18 1565 8192000000 10793115856 11184340992 1858062336 18.488 100 88 180 0 1896610704 13560288 24988080
20:08:26 2011 8192000000 10799550272 11188768768 1861635264 18.517 100 93 186 0 1904167056 16664464 25867328
20:08:36 1678 8192000000 10809700112 11194933248 1862693952 18.525 100 91 180 1 1901024416 12123168 26207296
20:08:44 3561 8192000000 10812456528 11202277376 1865834096 18.551 100 85 170 2 1902759520 13122704 23802720
20:08:54 1448 8192000000 10820824576 11206959104 1874751328 18.623 100 89 179 0 1913122080 13486192 24884560
20:09:02 1191 8192000000 10818878688 11206885376 1876925696 18.640 100 97 196 2 1918027104 13758704 27342704
20:09:11 23618 8192000000 10791851024 11195330560 1866999648 18.560 100 57 113 0 1892249696 8618096 16631952
20:09:43 17653 8192000000 10817914192 11209498624 1877719936 18.647 100 82 167 4 1909013024 8663440 22629648
20:10:07 1335 8192000000 10821983904 11214077952 1876325296 18.635 100 92 184 2 1913381232 11866112 25189824
20:10:15 2186 8192000000 10818368336 11214356480 1878343920 18.652 100 81 160 2 1913952432 13083424 22525088
20:10:23 11873 8192000000 10783869808 11205509120 1872974688 18.608 100 43 85 3 1894747584 10225824 11547072
20:10:47 4254 8192000000 10790428640 11204861952 1875573824 18.629 100 49 99 2 1895645536 5911456 14160256
20:10:58 9573 8192000000 10789996080 11219185664 1875805312 18.631 100 34 69 1 1896613792 11853456 8955024
20:11:14 4867 8192000000 10793396192 11219697664 1881359456 18.676 100 23 46 1 1894644304 6791904 6492944
20:11:28 4015 8192000000 10798605712 11221045248 1887009376 18.722 100 32 65 1 1902217328 6205952 9002000
20:11:41 7398 8192000000 10794644944 11225964544 1885282208 18.708 100 27 56 1 1903259824 10755040 7222576
20:11:55 9504 8192000000 10795297296 11225042944 1884042656 18.698 100 10 20 0 1892332768 5636496 2653616
20:12:12 10636 8192000000 10797885584 11228823552 1887574608 18.726 100 28 55 1 1906748192 11754528 7419056
20:12:32 9243 8192000000 10798561696 11227856896 1887328240 18.724 100 18 35 2 1898588112 5431584 5828288
20:12:47 5665 8192000000 10801349760 11228483584 1887869584 18.729 100 15 30 3 1896853664 5285520 3698560
20:13:04 8231 8192000000 10792152608 11230208000 1890343776 18.749 100 20 39 1 1902644368 7115552 5185040
20:13:18 9622 8192000000 10789491968 11227115520 1890767856 18.752 100 14 26 2 1901005248 5911680 4325712
20:13:39 10892 8192000000 10794633968 11230740480 1892593488 18.767 100 17 34 2 1904066992 6645648 4827856
20:13:56 15180 8192000000 10817750528 11242233856 1898744848 18.816 100 28 55 1 1913168528 5985488 8438192
20:14:45 31858 8192000000 10853462016 11253776384 1905523280 18.871 100 64 126 3 1930232720 5564720 19144720
20:15:23 7396 8192000000 10817740512 11251630080 1901545984 18.839 100 21 40 1 1914162320 6878608 5737728
20:15:41 6098 8192000000 10820748256 11254214656 1904768848 18.865 100 31 63 0 1920593488 6711296 9113344
20:15:56 8561 8192000000 10810411824 11251896320 1903752528 18.856 100 25 50 1 1917146656 6049328 7344800
20:16:11 8594 8192000000 10814951808 11259383808 1909006352 18.899 100 30 60 0 1924721056 7517696 8197008
20:16:25 5618 8192000000 10837404096 11262349312 1909891184 18.906 100 35 70 0 1927583104 8025152 9666768
20:16:38 5742 8192000000 10818421440 11250438144 1905094304 18.867 100 35 70 0 1922017936 5941872 10981760
20:16:50 4445 8192000000 10839140208 11263164416 1908872704 18.898 100 28 55 3 1922530768 6504672 7153392
20:17:02 4373 8192000000 10817893008 11240173568 1889363264 18.741 99 35 70 1 1905283456 6211616 9708576
20:17:15 6313 8192000000 10817329408 11236818944 1870452480 18.588 98 25 53 1 1884013024 6470816 7089728
20:17:27 9841 8192000000 10808992032 11245289472 1879907600 18.664 99 19 38 0 1892116064 6280160 5928304
20:17:46 14029 8192000000 10773879344 11199451136 1764833840 17.724 93 16 32 1 1775143776 5141984 5167952
20:18:09 8574 8192000000 10777660064 11201884160 1814081024 18.129 97 21 42 3 1829429024 9068352 6279648
20:18:26 10162 8192000000 10783674032 11201347584 1828549456 18.247 98 24 47 1 1840018896 4760768 6708672
20:18:44 64294 8192000000 10753224832 11185299456 1760542144 17.689 94 23 46 3 1771799216 5042592 6214480
20:19:56 7112 8192000000 10712392288 11129577472 1768190080 17.752 96 28 56 1 1782552448 6578304 7784064
20:20:09 4290 8192000000 10747410688 11161808896 1797983936 17.997 98 36 72 1 1813665568 5183168 10498464
20:20:20 5676 8192000000 10738957168 11155972096 1812269872 18.114 100 27 53 1 1827192592 7639088 7283632
20:20:31 5970 8192000000 10728774112 11154153472 1806892064 18.070 99 32 65 1 1822438400 6664896 8881440
20:20:46 10532 8192000000 10687671536 11108962304 1649923072 16.764 91 16 32 0 1660113120 5026432 5163616
20:21:03 8245 8192000000 10708474048 11115909120 1753103120 17.627 98 19 37 4 1763385712 5138896 5143696
20:21:18 6396 8192000000 10678674432 11083096064 1737396128 17.497 98 22 44 1 1749816448 6197616 6222704
20:21:30 11013 8192000000 10690517680 11104727040 1742182816 17.537 98 21 42 2 1753788944 6132304 5473824
20:21:50 5620 8192000000 10677331040 11085430784 1736247360 17.487 99 25 50 2 1748588976 5311920 7029696
20:22:03 8074 8192000000 10706576160 11118706688 1780767504 17.856 100 25 50 0 1793443408 5491152 7184752
20:22:17 11035 8192000000 10728822672 11145682944 1795117760 17.974 99 19 38 0 1810195504 9641168 5436576
20:22:34 8884 8192000000 10728038816 11143786496 1808432896 18.083 100 21 41 4 1820363248 5788816 6141536
20:22:49 10456 8192000000 10727795264 11151400960 1781297744 17.860 98 19 38 1 1793994912 5290256 7406912
20:23:06 18667 8192000000 10742676528 11160535040 1802788640 18.037 99 19 38 0 1818582896 10036064 5758192
20:23:33 65268 8192000000 10739845488 11170926592 1831653056 18.273 100 24 48 1 1843897648 5186448 7058144
20:24:45 3988 8192000000 10758859744 11180044288 1838856864 18.332 100 32 62 3 1854290784 6791312 8642608
20:24:59 8574 8192000000 10748771184 11171692544 1831706560 18.273 100 26 51 4 1844567952 5544048 7317344
20:25:13 9212 8192000000 10748770832 11174457344 1835962640 18.308 100 23 44 1 1847981392 5761552 6257200
20:25:32 4285 8192000000 10755012096 11181678592 1845658432 18.387 100 34 66 2 1862707744 6855248 10194064
20:25:45 3861 8192000000 10785301328 11198656512 1854844656 18.461 100 46 91 2 1874072400 6220000 13007744
20:25:59 8709 8192000000 10771910288 11195957248 1851357520 18.433 100 24 47 2 1863661040 5998416 6305104
20:26:17 10171 8192000000 10766507392 11200065536 1854892480 18.462 100 13 26 0 1863971392 5178752 3900160
20:26:35 6844 8192000000 10776844464 11205537792 1863398464 18.531 100 29 56 2 1876983232 5299088 8285680
20:26:48 9026 8192000000 10774949824 11206320128 1863430640 18.531 100 20 39 2 1874988432 5889088 5668704
20:27:04 7411 8192000000 10797750880 11220602880 1878255920 18.651 100 19 38 1 1888459872 5294208 4909744
20:27:20 9058 8192000000 10809996928 11233796096 1887516288 18.726 100 17 34 2 1898006928 5672896 4817744
20:27:40 7818 8192000000 10832438176 11245797376 1901364368 18.837 100 50 98 0 1921268064 6144944 13758752
20:27:55 22071 8192000000 10831990560 11252604928 1908854240 18.897 100 56 111 1 1932990128 7193184 16942704
20:28:30 55944 8192000000 10847468016 11268792320 1920371968 18.990 100 56 112 0 1945264672 8584224 16308480
20:30:02 32662 8192000000 10846007088 11279405056 1920564432 18.991 100 28 56 2 1938511328 9276656 8670240
20:30:42 4568 8192000000 10868697440 11288616960 1933814848 19.097 100 49 98 1 1953737328 6765536 13156944
20:30:54 4784 8192000000 10869798768 11294035968 1937410496 19.126 100 55 109 2 1963241488 8904080 16926912
20:31:20 13485 8192000000 10876169360 11307003904 1938348352 19.134 100 48 96 1 1963487808 11547184 13592272
20:31:41 25978 8192000000 10860914912 11303759872 1939698896 19.144 100 39 76 1 1962664128 11898976 11066256
20:32:14 10648 8192000000 10891695296 11313852416 1948645232 19.216 100 44 88 2 1974551280 12666384 13239664
20:32:36 13124 8192000000 10890686384 11319095296 1954402512 19.262 100 57 113 0 1981630976 10677008 16551456
20:32:57 24308 8192000000 10896690272 11330568192 1960834816 19.313 100 48 96 1 1989670320 14794176 14041328
20:33:35 6954 8192000000 10892846368 11332837376 1961862656 19.321 100 43 85 0 1989169920 14929008 12378256
20:33:53 14027 8192000000 10908253504 11339145216 1968995024 19.377 100 61 123 0 2001740336 13793952 18951360
20:34:18 3572 8192000000 10900400784 11321016320 1946352976 19.197 99 59 113 0 1981360160 16909104 18098080
20:34:29 2665 8192000000 10916125280 11342635008 1968894672 19.377 100 67 131 2 2006474464 18047696 19532096
20:34:39 11186 8192000000 10923351408 11350970368 1973855712 19.416 100 64 128 1 2011242240 18802432 18584096
20:35:02 9058 8192000000 10928398448 11357560832 1980915584 19.472 100 65 128 3 2020629568 20527024 19186960
20:35:20 4708 8192000000 10933309856 11354378240 1963767840 19.336 99 62 124 2 2002418032 19711120 18939072
20:35:33 7218 8192000000 10922520400 11354931200 1977779376 19.447 100 57 113 1 2014318976 19824016 16715584
20:35:49 28086 8192000000 10922580800 11362131968 1982976208 19.488 100 46 92 2 2016647776 19896192 13775376
20:36:36 16276 8192000000 10921253968 11363770368 1966454752 19.357 99 34 68 1 1999257328 22156192 10646384
20:37:07 5384 8192000000 10923768768 11365388288 1985010320 19.504 100 48 96 1 2017530576 18493312 14026944
20:37:21 2556 8192000000 10941545728 11372609536 1991264400 19.554 100 56 113 1 2026262032 19269296 15728336
20:37:30 7789 8192000000 10949017392 11379912704 1995852288 19.590 100 61 120 1 2033218816 20153968 17212560
20:37:50 9211 8192000000 10953852160 11385925632 2000012272 19.623 100 62 124 1 2040113056 22212400 17888384
20:38:09 9408 8192000000 10962545360 11396517888 2004476432 19.658 100 61 122 2 2046531552 24613808 17441312
20:38:27 16013 8192000000 10963432672 11395551232 2003706720 19.652 100 64 128 1 2048630432 26193344 18730368
20:38:52 8835 8192000000 10951952688 11387596800 1997658576 19.604 100 54 107 1 2039915408 26442080 15814752
20:39:10 1047 8192000000 10969583344 11399303168 2005801568 19.668 100 68 136 0 2054779600 28270960 20707072
20:39:19 5964 8192000000 10964913280 11401490432 2008297840 19.688 100 55 111 1 2053039392 28628272 16113280
20:39:35 4148 8192000000 10957733056 11392159744 1992877232 19.567 99 58 116 0 2039119408 29127136 17115040
20:39:49 3052 8192000000 10957353712 11387801600 2000523280 19.627 100 59 116 3 2046841632 27916944 18401408
20:39:59 6110 8192000000 10965077104 11400781824 2008691872 19.691 100 68 131 1 2057613104 29315664 19605568
20:40:12 5639 8192000000 10956149424 11382304768 1979359600 19.460 99 62 124 1 2026702608 28818672 18524336
20:40:27 6233 8192000000 10976676000 11397173248 2008803040 19.692 100 74 146 2 2059092144 29958704 20330400
20:40:41 3170 8192000000 10971856224 11392339968 1997922064 19.606 99 82 164 0 2054823552 31551328 25350160
20:40:51 3267 8192000000 10987624832 11410989056 2014025360 19.733 100 87 173 2 2072467680 32771456 25670864
20:41:03 6253 8192000000 10953199392 11376316416 1979053424 19.457 99 74 148 1 2034615600 33470400 22091776
20:41:25 4042 8192000000 10978033616 11403501568 2006341872 19.673 100 73 144 0 2061232416 33761696 21128848
20:41:37 11048 8192000000 10979806912 11407749120 2009840320 19.700 100 68 136 2 2064101536 33578784 20682432
20:41:57 4677 8192000000 10984098960 11411378176 2014037104 19.733 100 72 144 1 2069535680 33524464 21974112
20:42:08 5057 8192000000 10990874944 11414241280 2013096256 19.726 100 84 164 2 2073189776 35236288 24857232
20:42:21 1662 8192000000 11005293040 11420286976 2017967728 19.764 100 92 183 0 2081190000 36419440 26802832
20:42:29 3397 8192000000 10987459808 11407466496 2007018928 19.678 100 84 169 0 2070619904 38470576 25130400
20:42:40 3413 8192000000 10987292864 11409936384 2010434992 19.705 100 82 164 1 2073868480 38720624 24712864
20:42:51 2364 8192000000 10995534928 11417006080 2014961424 19.741 100 77 151 0 2076171104 38136896 23072784
20:43:01 5923 8192000000 10982556640 11402149888 2002130880 19.640 100 83 166 0 2067693648 39334608 26228160
20:43:15 4074 8192000000 10933655616 11354116096 1942120896 19.164 97 69 138 3 1998710160 35676304 20912960
20:43:26 4396 8192000000 10965165008 11389018112 1993489360 19.571 100 83 165 0 2053838912 35788448 24561104
20:43:37 3341 8192000000 10952232208 11375292416 1980784800 19.471 99 76 152 0 2039514256 35465840 23263616
20:43:48 6606 8192000000 10960572784 11383414784 1983361472 19.491 100 62 124 1 2038492752 35670896 19460384
20:44:03 4569 8192000000 10946859344 11379093504 1968202736 19.371 99 59 118 1 2023280944 36210384 18867824
20:44:16 6520 8192000000 10953797280 11380445184 1981204048 19.474 100 71 140 1 2040123088 37297696 21621344
20:44:33 3954 8192000000 10961983264 11376066560 1975657216 19.430 100 73 145 3 2037400704 37674080 24069408
20:44:44 5881 8192000000 10952715968 11378913280 1976653152 19.438 100 65 129 1 2036793920 39166368 20974400
20:44:58 4293 8192000000 10950492928 11378335744 1977423920 19.444 100 71 139 2 2039647648 39518752 22704976
20:45:12 5719 8192000000 10942806976 11372699648 1961956992 19.322 99 62 124 0 2021597376 40098064 19542320
20:45:27 2583 8192000000 10950145232 11360976896 1947051344 19.203 99 77 152 0 2014264496 42488464 24724688
20:45:39 3328 8192000000 10941035424 11351650304 1921580960 19.000 98 78 154 1 1990244640 44254784 24408896
20:45:50 3115 8192000000 10926357760 11339546624 1937091104 19.124 100 78 154 1 2007066992 45287104 24688784
20:46:00 3632 8192000000 10927105264 11342344192 1937882096 19.130 100 87 174 2 2013973152 47756096 28334960
20:46:12 5215 8192000000 10920943600 11328278528 1905576336 18.871 99 74 145 0 1977113456 48691456 22845664
20:46:25 3084 8192000000 10922149712 11330297856 1911282320 18.917 99 83 166 1 1988815072 50636272 26896480
20:46:41 2514 8192000000 10913937936 11318587392 1912889744 18.930 100 70 139 1 1986518576 50540000 23088832
20:46:51 7137 8192000000 10895868720 11317542912 1911315296 18.917 100 70 139 3 1986092784 52065648 22711840
20:47:04 3687 8192000000 10930130272 11341664256 1931370480 19.078 100 86 173 1 2007444320 49205632 26868208
20:47:15 2797 8192000000 10925524768 11337216000 1927946320 19.050 99 85 171 0 2005300464 50207504 27146640
20:47:25 3321 8192000000 10937348688 11350528000 1930543040 19.071 99 88 173 0 2009222400 51643392 27035968
20:47:35 11347 8192000000 10913518192 11346997248 1940054768 19.147 100 56 112 0 2009309376 50839040 18415568
20:47:56 3826 8192000000 10943242608 11369078784 1947591088 19.207 100 56 109 1 2020515584 55346352 17578144
20:48:06 5549 8192000000 10904787280 11331080192 1913871216 18.938 98 53 105 1 1982085472 50131744 18082512
20:48:24 11596 8192000000 10909267984 11340890112 1926271664 19.037 99 49 99 1 1981422896 38365584 16785648
20:48:52 24027 8192000000 10888243840 11329343488 1915818864 18.953 99 37 74 0 1964015248 35981568 12214816
20:49:26 6219 8192000000 10913859056 11328466944 1933066832 19.091 100 61 118 2 1989263712 38045936 18150944
20:49:41 6523 8192000000 10927462896 11351535616 1940739232 19.153 100 53 106 2 2008833696 51774688 16319776
20:49:58 4829 8192000000 10916939248 11350310912 1943962736 19.178 100 49 98 1 2003086544 43755616 15368192
20:50:13 11592 8192000000 10906453920 11351576576 1937470400 19.127 100 37 74 1 1998336944 47960880 12905664
20:50:42 25046 8192000000 10884055616 11326873600 1916097184 18.956 99 31 62 1 1970145504 43726416 10321904
20:51:17 19453 8192000000 10906724672 11354226688 1933623840 19.096 100 28 56 0 1993374256 48774688 10975728
20:52:01 35170 8192000000 10907001760 11379363840 1942709968 19.168 100 20 39 1 2000017088 50018096 7289024
20:52:43 28380 8192000000 10896067648 11370254336 1918858384 18.978 99 20 40 1 1970150128 44706352 6585392
20:53:19 27078 8192000000 10887847232 11349544960 1905191696 18.868 98 14 28 2 1948916656 39036176 4688784
20:53:52 20893 8192000000 10871484080 11335790592 1909289728 18.901 99 15 30 0 1943774560 29750512 4734320
20:55:01 64893 8192000000 10829704096 11297869824 1859193712 18.497 97 12 24 0 1884233424 21442336 3597376
20:56:12 39769 8192000000 10838075712 11284164608 1884479248 18.701 98 24 47 3 1899907792 8532240 6896304
20:56:59 28222 8192000000 10859633072 11319431168 1928515968 19.055 100 35 69 3 1949712736 11521952 9674816
20:57:35 33133 8192000000 10865906816 11322499072 1915448336 18.950 99 7 14 0 1928813376 11565328 1799712
20:58:14 53127 8192000000 10895985776 11336126464 1952372096 19.245 100 40 80 2 1976464640 12742128 11350416
20:59:14 74209 8192000000 10872322592 11334340608 1927407168 19.046 99 25 50 0 1946141120 11453216 7280736
21:00:42 123933 8192000000 10892145568 11352211456 1926000288 19.035 98 26 52 2 1943921712 10348752 7572672
21:02:53 50798 8192000000 10896010032 11357908992 1965207120 19.347 100 13 26 1 1982933280 13826080 3900080
21:03:50 5232 8192000000 10898214368 11348848640 1944872288 19.186 99 34 64 0 1971137280 17621632 8643360
21:04:03 6155 8192000000 10899804480 11361361920 1966318416 19.356 100 25 50 0 1989012608 15740832 6953360
21:04:16 32494 8192000000 10892547680 11343904768 1945118176 19.188 99 11 22 2 1965927856 17777744 3031936
21:05:06 34095 8192000000 10891794400 11355766784 1950440032 19.230 99 34 67 2 1975644528 15412016 9792480
21:05:49 34457 8192000000 10862813280 11311026176 1899841088 18.825 97 27 53 2 1918567776 10895424 7831264
21:06:33 61939 8192000000 10902549632 11356078080 1962146352 19.323 100 21 42 0 1982212736 13782864 6283520
21:07:46 37336 8192000000 10892680960 11364122624 1971311232 19.396 100 15 30 1 1988440960 12574848 4554880
21:08:32 33379 8192000000 10896622400 11364806656 1976664928 19.438 100 14 28 0 1989998816 9678080 3655808
21:09:19 45740 8192000000 10919205504 11385294848 1987308576 19.523 100 27 53 0 2008212880 12558304 8346000
21:10:11 59291 8192000000 10918551712 11391217664 1974252336 19.419 99 19 39 0 1999910976 20273904 5384736
21:11:18 55788 8192000000 10916546752 11382308864 1969390992 19.381 99 14 28 0 1994379216 20431200 4557024
21:13:30 55756 8192000000 10911624224 11392741376 1986770368 19.518 100 16 32 1 2012635856 20593776 5271712
21:14:37 55542 8192000000 10905475296 11388731392 1991411968 19.555 100 23 46 0 2013727952 15527168 6788816
21:15:49 17060 8192000000 10941327376 11384930304 1993137632 19.569 100 27 53 0 2006463264 6090160 7235472
21:16:13 27162 8192000000 10877204032 11335524352 1931635984 19.080 97 38 76 2 1951351008 8663152 11051872
21:16:55 69240 8192000000 10916090528 11394060288 1993672480 19.573 100 18 36 0 2008618832 9931568 5014784
21:18:48 84136 8192000000 10909390656 11370201088 1915287248 18.949 96 16 32 0 1928807936 9181680 4339008
21:20:20 49812 8192000000 10925867184 11390091264 1988173424 19.529 100 32 62 1 2010828976 14127456 8528096
21:21:16 44239 8192000000 10934330240 11401535488 1996744512 19.597 100 21 41 1 2018228624 15762400 5721712
21:22:08 57850 8192000000 10935322160 11415347200 1995871344 19.590 100 18 36 1 2021703472 20067392 5764736
21:23:36 63615 8192000000 10929083536 11407863808 1980831072 19.471 99 13 26 0 1998119296 14205488 3082736
21:24:48 39249 8192000000 10927079376 11382829056 1944389632 19.182 97 21 42 0 1965523280 15178848 5954800
21:25:34 88717 8192000000 10891735504 11372843008 1911219424 18.916 96 17 34 1 1929774704 13352896 5202384
21:27:14 104463 8192000000 10859383168 11311841280 1779493040 17.845 90 22 44 1 1793751440 8576032 5682368
21:29:07 69108 8192000000 10835664832 11285921792 1844853744 18.380 96 29 58 0 1867585744 14916592 7815408
21:30:22 15107 8192000000 10848730832 11302023168 1915062080 18.947 100 32 64 1 1937119376 13024272 9033024
21:30:48 81751 8192000000 10832250512 11308597248 1885454976 18.709 98 20 40 0 1906163920 15009552 5699392
21:32:16 35957 8192000000 10838973344 11325353984 1917709296 18.968 100 7 14 0 1934280672 15042064 1529312
21:33:01 11990 8192000000 10834737280 11314515968 1905175440 18.868 99 11 21 1 1921034432 13001312 2857680
21:33:36 41831 8192000000 10857228112 11320397824 1920209984 18.989 99 16 32 0 1935144736 10289168 4645584
21:34:35 63756 8192000000 10862944448 11320332288 1892821664 18.769 97 22 44 1 1915351120 16021456 6508000
21:36:23 41898 8192000000 10850840064 11342622720 1907238288 18.884 99 14 28 0 1936690784 25058096 4394400
21:37:20 81539 8192000000 10863043360 11331358720 1862123072 18.520 96 34 68 0 1881141920 9194160 9824688
21:38:47 35975 8192000000 10879473184 11334774784 1922296128 19.005 99 25 50 2 1938816672 9565952 6954592
21:39:37 58744 8192000000 10889526720 11331358720 1868610880 18.573 96 27 54 2 1888976064 13112736 7252448
21:40:47 33625 8192000000 10867221984 11331379200 1927803104 19.049 100 26 52 0 1949620896 14641792 7176000
21:41:30 36368 8192000000 10843181968 11307945984 1890549856 18.750 98 21 41 1 1915948960 18895920 6503184
21:42:37 23135 8192000000 10854371248 11308822528 1874261040 18.619 97 20 40 0 1887391984 7984784 5146160
21:43:09 17156 8192000000 10853436080 11294961664 1877060576 18.641 98 28 56 0 1894475056 9682448 7732032
21:43:35 45494 8192000000 10879065568 11338821632 1927542224 19.047 100 43 86 1 1959764416 20630688 11591504
21:44:29 68269 8192000000 10847745344 11318448128 1867684000 18.566 97 25 50 1 1902445712 28045152 6716560
21:45:59 60376 8192000000 10864969568 11315941376 1889734672 18.744 98 20 40 0 1907033280 11616080 5682528
21:47:07 209488 8192000000 10854654912 11316981760 1856441888 18.474 96 19 39 0 1874853888 13149952 5262048
21:50:43 54348 8192000000 10852158480 11326578688 1931283248 19.077 100 13 26 0 1948072416 13281552 3507616
21:53:02 54472 8192000000 10850239664 11330011136 1934166208 19.100 100 10 19 0 1944696912 7568320 2962384
21:54:17 72759 8192000000 10870058064 11329847296 1923815456 19.017 99 18 35 2 1936424496 7882032 4727008
21:55:36 63164 8192000000 10849694992 11335979008 1921470288 18.999 99 16 32 1 1936977872 11304320 4203264
21:57:06 44246 8192000000 10864791312 11313672192 1884272736 18.700 97 22 45 0 1899369776 8420112 6676928
21:57:58 31749 8192000000 10846315536 11309150208 1878644640 18.654 97 12 24 0 1888190272 6271024 3274608
21:58:37 40602 8192000000 10862688672 11326160896 1904825296 18.865 98 24 48 0 1920911104 8878000 7207808
21:59:24 70983 8192000000 10867926416 11319083008 1884363472 18.700 97 19 38 0 1900707456 11409872 4934112
22:00:44 42582 8192000000 10874732032 11347038208 1939901488 19.146 100 26 52 3 1957932080 10960432 7070160
22:01:42 67048 8192000000 10881648384 11362545664 1952518304 19.247 100 22 44 1 1973590048 14801104 6270640
22:03:01 104328 8192000000 10904483472 11391352832 1969375824 19.380 100 13 26 1 1998710096 25933504 3400768
22:04:51 78434 8192000000 10915227872 11383287808 1959211664 19.300 99 9 18 0 1971122816 9727024 2184128
22:06:16 95033 8192000000 10911897968 11382210560 1942976992 19.171 98 12 24 0 1961583424 15629968 2976464
22:08:01 25332 8192000000 10945101984 11397607424 1993481344 19.571 100 59 116 0 2022388944 12643152 16264448
22:08:33 101656 8192000000 10915087248 11400773632 1948347488 19.213 98 29 58 0 1970370544 14232880 7790176
22:10:22 108856 8192000000 10945578640 11401891840 1984331856 19.499 99 31 60 2 2002371568 10124144 7915568
22:12:30 60593 8192000000 10918193904 11403108352 1994947568 19.583 100 20 40 2 2014101152 13918304 5235280
22:14:58 49412 8192000000 10890239312 11370688512 1951537952 19.239 98 18 36 1 1964044224 7382000 5124272
22:15:54 42510 8192000000 10897027296 11379920896 1978780096 19.455 100 8 16 0 1989823168 8645792 2397280
22:16:43 26397 8192000000 10902165040 11389804544 1982890144 19.488 100 5 10 0 1995071472 10640128 1541200
22:18:26 76320 8192000000 10916339616 11397095424 1921360320 18.998 96 18 36 1 1939915152 13581920 4972912
22:19:48 68366 8192000000 10899429088 11392286720 1942817392 19.169 98 16 32 0 1961723008 14765024 4140592
22:21:03 58049 8192000000 10900547872 11365289984 1873704560 18.614 95 16 33 1 1893711296 14740928 5265808
22:22:10 49116 8192000000 10888565280 11357077504 1922960752 19.011 98 22 43 1 1941620096 12377568 6281776
22:23:08 44361 8192000000 10892955312 11358265344 1909074976 18.899 97 28 56 2 1930350128 13579312 7695840
22:24:00 70121 8192000000 10893451968 11378409472 1918741104 18.977 98 17 34 0 1941914144 18285232 4887808
22:25:25 55755 8192000000 10882183920 11352932352 1867453408 18.564 95 19 38 2 1895068912 22662576 4952928
22:26:29 57298 8192000000 10080914832 10471809024 1132502784 12.145 59 16 31 0 1144619792 8196000 3921008

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-02-2021 22:28:25 to 25-02-2021 22:28:56.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-02-2021 22:28:57 to 25-02-2021 22:28:59.

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          236646
MON$OLDEST_ACTIVE               237182
MON$OLDEST_SNAPSHOT             237182
MON$NEXT_TRANSACTION            237182
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                       2027424
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:300: 
:301: mscs-test-161.budzdorov.ru    Thu Feb 25 22:27:33 2021
:302:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:303: 
:304: 
:305: mscs-test-161.budzdorov.ru    Thu Feb 25 22:27:34 2021
:306:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:307: 
:308: 
:309: mscs-test-161.budzdorov.ru    Thu Feb 25 22:27:35 2021
:310:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:311: 
:312: 
:313: mscs-test-161.budzdorov.ru    Thu Feb 25 22:27:35 2021
:314:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:315: 
--- end of diff output ---

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

25.02.21 22:29:00. 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-02-25 22:29:02 No severe PSQL-related problems occured
25.02.21 22:29:04. End of report.