Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.01.2021 22:29
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 17107164 kB
MemAvailable 31358684 kB
Buffers 0 kB
Cached 14612236 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-17 22:27:31
DTS_END                         2021-01-17 22:27:31.5360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43646
TRN_ID                          244482
ATT_ID                          708
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: 9349.70 18915 1121964
customer order: creation 175.21 348 21025
customer order: refuse 15.44 349 1853
order to supplier: creation 45.78 1238 5493
order to supplier: removal 3.49 108545 419
invoice (draft): creation 46.38 3469 5566
invoice (draft): removal 53.05 780 6366
invoice accept: apply 41.75 17803 5010
invoice accept: cancel 48.62 860 5834
customer reserve: creation 3824.28 177 458914
customer reserve: removal 4788.52 63 574622
realization accept: apply 84.54 185 10145
realization accept: cancel 89.93 116 10791
payment from customer: creation 60.92 111 7310
payment from customer: removal 5.66 84 679
payment to supplier: creation 50.32 130 6038
payment to supplier: removal 3.23 82 388
service: total inventory turnovers 5.05 1147 606
service: total monetary turnovers 6.72 31 806
service: aggregate perf. data 0.79 22934 95
service: refresh index statistics 0.03 219846 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-01-2021 22:29:51 to 17-01-2021 22:29:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4147
TEST_TIME 2 5079
TEST_TIME 3 5597
TEST_TIME 4 5306
TEST_TIME 5 5033
TEST_TIME 6 5333
TEST_TIME 7 5025
TEST_TIME 8 5091
TEST_TIME 9 5083
TEST_TIME 10 5086
TEST_TIME 11 5122
TEST_TIME 12 5437
TEST_TIME 13 5656
TEST_TIME 14 5700
TEST_TIME 15 6180
TEST_TIME 16 6939
TEST_TIME 17 6914
TEST_TIME 18 7324
TEST_TIME 19 7304
TEST_TIME 20 7406
TEST_TIME 21 7843
TEST_TIME 22 8252
TEST_TIME 23 8611
TEST_TIME 24 8766
TEST_TIME 25 9059
TEST_TIME 26 8898
TEST_TIME 27 9048
TEST_TIME 28 9978
TEST_TIME 29 10866
TEST_TIME 30 10945
TEST_TIME 31 11175
TEST_TIME 32 11046
TEST_TIME 33 10814
TEST_TIME 34 10872
TEST_TIME 35 10725
TEST_TIME 36 10573
TEST_TIME 37 10382
TEST_TIME 38 10270
TEST_TIME 39 10228
TEST_TIME 40 10087
TEST_TIME 41 10055
TEST_TIME 42 9969
TEST_TIME 43 9912
TEST_TIME 44 10028
TEST_TIME 45 10064
TEST_TIME 46 10042
TEST_TIME 47 9888
TEST_TIME 48 9881
TEST_TIME 49 9827
TEST_TIME 50 9918
TEST_TIME 51 9907
TEST_TIME 52 9969
TEST_TIME 53 9930
TEST_TIME 54 10068
TEST_TIME 55 10052
TEST_TIME 56 10084
TEST_TIME 57 10008
TEST_TIME 58 10142
TEST_TIME 59 10107
TEST_TIME 60 10178
TEST_TIME 61 10192
TEST_TIME 62 10050
TEST_TIME 63 9987
TEST_TIME 64 9910
TEST_TIME 65 9914
TEST_TIME 66 9918
TEST_TIME 67 9823
TEST_TIME 68 9762
TEST_TIME 69 9760
TEST_TIME 70 9777
TEST_TIME 71 9694
TEST_TIME 72 9653
TEST_TIME 73 9598
TEST_TIME 74 9598
TEST_TIME 75 9534
TEST_TIME 76 9487
TEST_TIME 77 9423
TEST_TIME 78 9454
TEST_TIME 79 9410
TEST_TIME 80 9439
TEST_TIME 81 9520
TEST_TIME 82 9577
TEST_TIME 83 9600
TEST_TIME 84 9568
TEST_TIME 85 9535
TEST_TIME 86 9556
TEST_TIME 87 9682
TEST_TIME 88 9664
TEST_TIME 89 9727
TEST_TIME 90 9657
TEST_TIME 91 9590
TEST_TIME 92 9542
TEST_TIME 93 9533
TEST_TIME 94 9541
TEST_TIME 95 9462
TEST_TIME 96 9397
TEST_TIME 97 9330
TEST_TIME 98 9508
TEST_TIME 99 9466
TEST_TIME 100 9439
TEST_TIME 101 9482
TEST_TIME 102 9487
TEST_TIME 103 9462
TEST_TIME 104 9525
TEST_TIME 105 9530
TEST_TIME 106 9594
TEST_TIME 107 9561
TEST_TIME 108 9564
TEST_TIME 109 9601
TEST_TIME 110 9573
TEST_TIME 111 9566
TEST_TIME 112 9531
TEST_TIME 113 9514
TEST_TIME 114 9496
TEST_TIME 115 9488
TEST_TIME 116 9466
TEST_TIME 117 9455
TEST_TIME 118 9441
TEST_TIME 119 9397
TEST_TIME 120 9350

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-01-2021 22:29:54 to 17-01-2021 22:29:58.

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 1549109 1549109 0 0.00 0 20670 6 0 0
doc_list_biud 1549109 1549109 0 0.00 0 27197 29 0 0
sp_add_invoice_to_stock 5136 5010 126 2.45 40 164060 17804 0 126
sp_cancel_adding_invoice 5834 5834 0 0.00 5 75258 861 0 0
sp_cancel_client_order 1853 1853 0 0.00 4 11694 349 0 0
sp_cancel_customer_reserve 574622 574622 0 0.00 1 25127 64 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 3 4564 85 0 0
sp_cancel_pay_to_supplier 388 388 0 0.00 3 8589 83 0 0
sp_cancel_supplier_invoice 6368 6366 2 0.03 1 11865 780 0 2
sp_cancel_supplier_order 419 419 0 0.00 11 1141294 108546 0 0
sp_cancel_write_off 10791 10791 0 0.00 1 12047 116 0 0
sp_client_order 21025 21025 0 0.00 3 30588 349 0 0
sp_customer_reserve 458914 458914 0 0.00 0 52949 178 0 0
sp_fill_shopping_cart 32061 32061 0 0.00 1 23484 36 0 0
sp_fill_shopping_cart_clo_res 458912 458912 0 0.00 0 15283 13 0 0
sp_get_clo_for_invoice 5008 5008 0 0.00 0 14815 285 0 0
sp_kill_cost_storno 17692 17692 0 0.00 0 20667 59 0 0
sp_kill_qstorno_ret_qs2qd 1166820 1166820 0 0.00 0 25098 34 0 0
sp_kill_qty_storno 615038 615038 0 0.00 0 27196 73 0 0
sp_lock_selected_doc 21004 21004 0 0.00 0 9633 7 0 0
sp_make_cost_storno 28501 28501 0 0.00 0 18035 51 0 0
sp_multiply_rows_for_pdistr 28501 28501 0 0.00 0 8998 27 0 0
sp_multiply_rows_for_qdistr 21025 21025 0 0.00 0 14761 159 0 0
sp_pay_from_customer 7310 7310 0 0.00 3 10494 112 0 0
sp_pay_to_supplier 6038 6038 0 0.00 5 18045 131 0 0
sp_payment_common 13348 13348 0 0.00 2 11907 27 0 0
sp_qd_handle_on_cancel_clo 1853 1853 0 0.00 0 11686 318 0 0
sp_qd_handle_on_invoice_upd_sts 10842 10842 0 0.00 0 12439 308 0 0
sp_qd_handle_on_reserve_upd_sts 10145 10145 0 0.00 0 27196 69 0 0
sp_reserve_write_off 10145 10145 0 0.00 6 27210 186 0 0
sp_supplier_invoice 5566 5566 0 0.00 5 82595 3470 0 0
sp_supplier_order 5493 5493 0 0.00 5 32494 1239 0 0
srv_aggregate_perf_data 96 95 1 1.04 2629 465149 22934 0 1
srv_fill_mon_cache_memory 164 164 0 0.00 1381 187924 31448 0 0
srv_find_qd_qs_mism 1074873 1074873 0 0.00 0 18197 5 0 0
srv_make_invnt_saldo 606 606 0 0.00 30 58764 1147 0 0
srv_make_money_saldo 806 806 0 0.00 0 5375 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 123977 309963 219846 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 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 5010 5010 0 0.00 0 17536 182 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 20546 154 0 0
t$perf-norm:sp_cancel_client_order 1853 1853 0 0.00 0 4894 17 0 0
t$perf-norm:sp_cancel_customer_reserve 714 714 0 0.00 0 1836 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 1414 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 388 388 0 0.00 0 1931 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 3293 23 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 40459 1879 0 0
t$perf-norm:sp_cancel_write_off 982 982 0 0.00 0 8124 19 0 0
t$perf-norm:sp_client_order 21025 21025 0 0.00 0 15279 20 0 0
t$perf-norm:sp_customer_reserve 1073 1073 0 0.00 0 2635 6 0 0
t$perf-norm:sp_pay_from_customer 7310 7310 0 0.00 0 29304 22 0 0
t$perf-norm:sp_pay_to_supplier 6038 6038 0 0.00 0 10774 14 0 0
t$perf-norm:sp_reserve_write_off 10145 10145 0 0.00 0 6570 12 0 0
t$perf-norm:sp_supplier_invoice 5566 5566 0 0.00 0 15066 23 0 0
t$perf-norm:sp_supplier_order 5493 5493 0 0.00 0 6187 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 367 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 102 2 0 0
t$perf-norm:srv_make_invnt_saldo 606 606 0 0.00 0 736 17 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 2032 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10268 10016 252 2.45 0 4631 19 0 252
v_all_customers 38258 38258 0 0.00 0 39 1 0 0
v_all_suppliers 30530 30530 0 0.00 0 86 1 0 0
v_all_wares 42050 42050 0 0.00 0 105 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 774 7 0 0
v_cancel_client_order 3706 3706 0 0.00 0 5318 7 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 2677 8 0 0
v_cancel_customer_reserve 1428 1428 0 0.00 0 1547 5 0 0
v_cancel_payment_to_supplier 776 776 0 0.00 0 1659 5 0 0
v_cancel_supplier_invoice 794 790 4 0.50 0 1187 18 0 4
v_cancel_supplier_order 838 838 0 0.00 0 339 4 0 0
v_cancel_write_off 1964 1964 0 0.00 0 2735 17 0 0
v_max_id_clo_ord 5492 5492 0 0.00 0 931 1 0 0
v_max_id_clo_res 1073 1073 0 0.00 0 3650 13 0 0
v_max_id_ord_sup 5544 5544 0 0.00 0 6760 5 0 0
v_max_non_paid_invoice 1809 1809 0 0.00 0 4175 6 0 0
v_max_non_paid_realizn 3898 3898 0 0.00 0 769 3 0 0
v_min_id_clo_ord 5492 5492 0 0.00 0 4859 8 0 0
v_min_id_clo_res 1073 1073 0 0.00 0 13604 29 0 0
v_min_id_ord_sup 5544 5544 0 0.00 0 7285 6 0 0
v_min_non_paid_invoice 6038 6038 0 0.00 0 11904 16 0 0
v_min_non_paid_realizn 7310 7310 0 0.00 0 10468 17 0 0
v_our_firm 10616 10616 0 0.00 0 23 1 0 0
v_reserve_write_off 20290 20290 0 0.00 0 5319 7 0 0
x_lock_depdocs_on_canc_invoice 11805 11805 0 0.00 0 22418 126 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 3177 303 0 0
x_make_qstorno_1000_1200 5493 5493 0 0.00 1 32457 1162 0 0
x_make_qstorno_1200_2000 5566 5566 0 0.00 2 79277 3324 0 0
x_make_qstorno_2100_3300 458914 458914 0 0.00 0 52948 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-01-2021 22:29:59 to 17-01-2021 22:30:03.

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:35 2 8192000000 8798715952 8809250816 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:41 10410 8192000000 10178647696 10480963584 873381072 9.634 69 54 112 0 893775264 2410928 17983264
19:57:59 33986 8192000000 10339015744 10654834688 1368053728 14.310 100 92 183 1 1403345888 4597568 30694592
19:58:41 31235 8192000000 10373782544 10700230656 1425518640 14.822 100 84 168 0 1459398800 6556160 27324000
19:59:23 22257 8192000000 10403622832 10732556288 1458649184 15.114 100 82 164 1 1492530320 7404336 26476800
19:59:58 12141 8192000000 10424266144 10754199552 1477192688 15.277 100 87 174 0 1513765808 8187136 28385984
20:00:19 23742 8192000000 10448225344 10781241344 1495825072 15.440 100 91 182 1 1534019568 9019056 29175440
20:00:54 11700 8192000000 10449276240 10786889728 1507188400 15.539 100 84 168 0 1543626416 9617136 26820880
20:01:15 18032 8192000000 10472254736 10812256256 1523067744 15.677 100 85 170 0 1559811888 9634848 27109296
20:01:42 9854 8192000000 10486136576 10830966784 1544580960 15.863 100 82 164 0 1580285856 10188816 25516080
20:02:02 14929 8192000000 10512656944 10861289472 1566440448 16.052 100 80 160 0 1601588160 10718688 24429024
20:02:25 11624 8192000000 10534254320 10886508544 1581064896 16.177 100 77 152 2 1615027744 10831536 23131312
20:02:48 9518 8192000000 10561127952 10918121472 1619159088 16.503 100 84 168 0 1655658688 11200400 25299200
20:03:06 12538 8192000000 10584033232 10940366848 1636227328 16.648 100 76 152 0 1670823824 11570976 23025520
20:03:29 13639 8192000000 10611951376 10974437376 1671325184 16.944 100 84 168 1 1708177856 12462544 24390128
20:03:56 11277 8192000000 10638983888 11009085440 1693654784 17.132 100 84 168 1 1732138976 13574928 24909264
20:04:15 9210 8192000000 10647237088 11020599296 1706601008 17.240 100 79 160 0 1742985712 12878688 23506016
20:04:32 9007 8192000000 10656306192 11028885504 1718063728 17.336 100 84 168 1 1755318016 12832304 24421984
20:04:51 5459 8192000000 10676903280 11052408832 1732014048 17.452 100 81 161 0 1767977440 13356848 22606544
20:05:03 3945 8192000000 10689785248 11061121024 1742529712 17.540 100 88 176 2 1782114384 14413920 25170752
20:05:14 7163 8192000000 10694597680 11073748992 1750403792 17.605 100 86 172 0 1788567520 13748848 24414880
20:05:28 4323 8192000000 10709508672 11083677696 1761380448 17.696 100 88 174 0 1800038064 14041280 24616336
20:05:39 4012 8192000000 10714734960 11091419136 1770658384 17.772 100 89 176 2 1808416944 13783808 23974752
20:05:50 3889 8192000000 10719680592 11100430336 1776714816 17.822 100 79 158 0 1811958560 13557216 21686528
20:06:01 5275 8192000000 10723872368 11106775040 1787450976 17.911 100 82 164 3 1823828336 13884544 22492816
20:06:13 3516 8192000000 10743062976 11125501952 1799348240 18.009 100 86 172 0 1837378512 13979040 24051232
20:06:23 1704 8192000000 10742355248 11123896320 1800168224 18.015 100 88 175 0 1838769552 14297312 24304016
20:06:31 7364 8192000000 10744677296 11129675776 1805462240 18.059 100 84 167 1 1842540896 13599616 23479040
20:06:46 2058 8192000000 10749316656 11135983616 1812215232 18.114 100 87 174 1 1849698160 13360112 24122816
20:06:55 2841 8192000000 10765446768 11150344192 1821789296 18.192 100 90 181 3 1861787904 14416224 25582384
20:07:04 2121 8192000000 10766617104 11156258816 1833082768 18.284 100 93 186 0 1872974032 13098080 26793184
20:07:12 2394 8192000000 10776324000 11162759168 1836498944 18.312 100 92 181 2 1875231040 13087232 25644864
20:07:21 1566 8192000000 10781475456 11169398784 1843225504 18.367 100 92 184 0 1881724800 12251344 26247952
20:07:29 1632 8192000000 10791300848 11174191104 1841925088 18.356 100 93 188 2 1881581120 13664688 25991344
20:07:37 1482 8192000000 10794440832 11180675072 1848191984 18.407 100 96 193 0 1890339680 14522656 27625040
20:07:45 2171 8192000000 10793592400 11180007424 1848105520 18.407 100 96 192 0 1887339152 12848048 26385584
20:07:54 1446 8192000000 10797077744 11183681536 1855641680 18.468 100 97 194 0 1897899600 14839664 27418256
20:08:02 1251 8192000000 10800892608 11190165504 1853246624 18.448 100 88 177 1 1895169392 17256144 24666624
20:08:10 17556 8192000000 10783366080 11180126208 1855957200 18.470 100 71 141 2 1885798688 10758800 19082688
20:08:38 12453 8192000000 10806005072 11195453440 1860192832 18.505 100 81 160 3 1894073488 11483232 22397424
20:08:56 16362 8192000000 10778682672 11197022208 1864056416 18.536 100 63 127 0 1893718816 11492432 18169968
20:09:19 17996 8192000000 10780762704 11194925056 1865827248 18.550 100 40 81 0 1883165712 5340832 11997632
20:09:44 6709 8192000000 10780360432 11208941568 1867563008 18.565 100 32 64 1 1885172224 8674352 8934864
20:09:59 4669 8192000000 10786908384 11207303168 1871965360 18.600 100 32 65 2 1888661952 7510080 9186512
20:10:12 5875 8192000000 10784265264 11210727424 1874464192 18.620 100 35 70 1 1892650208 8308480 9877536
20:10:25 9328 8192000000 10777213232 11207778304 1872253424 18.603 100 18 36 0 1883365920 5870736 5241760
20:10:42 7935 8192000000 10780167824 11211919360 1876064464 18.633 100 12 22 1 1884988640 5862096 3062080
20:11:01 7160 8192000000 10798381792 11225645056 1887393616 18.725 100 17 34 0 1897450976 5637392 4419968
20:11:14 5376 8192000000 10795981088 11226906624 1889348624 18.741 100 18 37 1 1904491024 9949648 5192752
20:11:29 11592 8192000000 10800499776 11233579008 1891367504 18.757 100 20 40 2 1903627136 6335360 5924272
20:11:53 10153 8192000000 10790747968 11233562624 1892526848 18.766 100 11 22 2 1901205232 5259296 3419088
20:12:10 5592 8192000000 10803609088 11237470208 1899711664 18.824 100 21 42 1 1911796112 6133552 5950896
20:12:22 9304 8192000000 10808578992 11242307584 1900909552 18.834 100 21 40 3 1912617408 5914080 5793776
20:12:39 18122 8192000000 10811221008 11242119168 1901061728 18.835 100 14 28 0 1910621968 5226960 4333280
20:13:08 57964 8192000000 10846624976 11266629632 1908460272 18.894 100 19 38 1 1918960736 5132064 5368400
20:14:12 7167 8192000000 10818678832 11262087168 1911533920 18.919 100 26 52 2 1926740880 8406848 6800112
20:14:26 5446 8192000000 10813303808 11257585664 1910845152 18.913 100 23 46 2 1923467632 5992896 6629584
20:14:38 7686 8192000000 10818143248 11257630720 1911766480 18.921 100 29 57 1 1925549648 5559648 8223520
20:14:52 5741 8192000000 10831567536 11265101824 1915298400 18.949 100 35 70 1 1931205824 6599040 9308384
20:15:07 6335 8192000000 10826851616 11267289088 1915533984 18.951 100 32 64 0 1931262192 6829328 8898880
20:15:20 8740 8192000000 10837342912 11270209536 1917024544 18.963 100 26 50 3 1930511472 6315776 7171152
20:15:36 5879 8192000000 10828089120 11267051520 1898020816 18.810 99 30 60 1 1912754672 6420048 8313808
20:15:48 7450 8192000000 10822015952 11261788160 1911205664 18.916 100 23 46 2 1923743488 5819280 6718544
20:16:02 10496 8192000000 10815457792 11256238080 1892696912 18.768 99 21 42 0 1904914624 6312784 5904928
20:16:21 7813 8192000000 10823981840 11255201792 1888944720 18.737 99 30 60 1 1903191568 5755712 8491136
20:16:35 9271 8192000000 10811983168 11242176512 1879125376 18.658 99 25 51 2 1892525040 5652864 7746800
20:16:51 8737 8192000000 10818501152 11243618304 1882923184 18.689 99 27 54 2 1896928496 6588368 7416944
20:17:09 8744 8192000000 10752396752 11181649920 1785394528 17.894 95 17 34 4 1796147680 5942112 4811040
20:17:25 20228 8192000000 10756983536 11178352640 1717406640 17.331 91 22 44 0 1729809808 5481712 6921456
20:17:51 64945 8192000000 10776514864 11203387392 1778470032 17.837 95 26 50 0 1790741776 5661264 6610480
20:19:03 8853 8192000000 10773630080 11199729664 1831056384 18.268 98 38 77 2 1849287840 7849872 10381584
20:19:19 3203 8192000000 10775776592 11184697344 1791391296 17.943 97 43 86 1 1811701040 7851536 12458208
20:19:28 2909 8192000000 10767314992 11178881024 1840717776 18.347 100 48 96 3 1862526992 8578528 13230688
20:19:38 3338 8192000000 10783350368 11199188992 1856388592 18.474 100 45 88 0 1877155328 7930272 12836464
20:19:52 5547 8192000000 10757276800 11175145472 1824120544 18.211 99 28 54 4 1838305568 5618720 8566304
20:20:05 8098 8192000000 10692201744 11102580736 1727701888 17.416 95 24 48 0 1739697664 4843456 7152320
20:20:20 8167 8192000000 10696660368 11116314624 1703285760 17.213 94 28 56 0 1716325296 5166064 7873472
20:20:34 7853 8192000000 10690770464 11112128512 1742433472 17.539 97 22 43 2 1753425568 5388544 5603552
20:20:52 10248 8192000000 10701918640 11121004544 1747100512 17.578 97 28 56 2 1760928672 5295392 8532768
20:21:08 6713 8192000000 10711712608 11118796800 1755283456 17.645 97 28 54 1 1768775104 4889520 8602128
20:21:21 6016 8192000000 10719724640 11131904000 1785045600 17.891 99 22 46 0 1797442016 5461776 6934640
20:21:36 5329 8192000000 10728172448 11148046336 1813705920 18.126 100 27 55 2 1827471808 6013360 7752528
20:21:48 8337 8192000000 10749817984 11168837632 1829521776 18.255 100 24 48 0 1842508832 5788944 7198112
20:22:06 16296 8192000000 10737688752 11161034752 1797535632 17.994 98 27 56 0 1810728768 5481888 7711248
20:22:28 58870 8192000000 10753488928 11173158912 1817602128 18.158 99 23 45 0 1829380032 5750768 6027136
20:23:33 8835 8192000000 10747982144 11175563264 1838436144 18.328 100 24 48 0 1851871520 6286448 7148928
20:23:48 6697 8192000000 10756010848 11183136768 1843419568 18.369 100 24 48 1 1857155072 6693856 7041648
20:24:01 6487 8192000000 10765536672 11194286080 1847530384 18.402 100 24 48 0 1864821344 10345216 6945744
20:24:14 7936 8192000000 10792124960 11206520832 1855264720 18.465 100 30 60 3 1869951728 6319840 8367168
20:24:29 8636 8192000000 10766566240 11199664128 1856774784 18.477 100 24 49 4 1869409120 5878848 6755488
20:24:45 6406 8192000000 10777485840 11209699328 1864080864 18.536 100 25 50 1 1878535296 6697264 7757168
20:25:00 7318 8192000000 10772076112 11202813952 1849188704 18.416 99 22 44 1 1861613264 6293296 6131264
20:25:15 8741 8192000000 10787956096 11210256384 1866392704 18.555 100 30 58 4 1881079792 6322864 8364224
20:25:30 5826 8192000000 10781568832 11213115392 1871713936 18.598 100 20 40 3 1883206736 5619104 5873696
20:25:45 12187 8192000000 10797384592 11224805376 1876359408 18.636 100 28 56 1 1895385104 11126688 7899008
20:26:09 10897 8192000000 10789319056 11222360064 1878496464 18.653 100 19 36 0 1888819168 4961488 5361216
20:26:26 14459 8192000000 10783828032 11224440832 1883120512 18.690 100 18 34 3 1893597712 5374240 5102960
20:26:53 19780 8192000000 10805361584 11239129088 1891455984 18.758 100 20 40 0 1901979424 4885264 5638176
20:27:19 85276 8192000000 10849484080 11273773056 1915087968 18.947 100 43 87 0 1934449168 6858752 12502448
20:28:51 12633 8192000000 10864782240 11286274048 1930533792 19.071 100 45 90 0 1953617920 9938672 13145456
20:29:12 21818 8192000000 10871039520 11295227904 1936749920 19.121 100 51 102 0 1961991600 10715808 14525872
20:29:44 10633 8192000000 10872010224 11302395904 1941890848 19.162 100 49 98 1 1967520032 11241120 14388064
20:30:03 1900 8192000000 10884953616 11305832448 1946616176 19.200 100 53 106 0 1972702944 11367824 14718944
20:30:12 31497 8192000000 10879520880 11310710784 1942048000 19.163 100 47 92 1 1972018688 17302960 12667728
20:30:50 10275 8192000000 10889066992 11319468032 1950339024 19.229 100 54 104 1 1983731872 18418448 14974400
20:31:21 24682 8192000000 10893758848 11326402560 1956508816 19.278 100 47 93 1 1988752752 19297936 12946000
20:31:54 15058 8192000000 10897081584 11327152128 1957121344 19.283 100 48 94 0 1988747488 18040768 13585376
20:32:30 23002 8192000000 10899499520 11335876608 1949193552 19.220 99 43 85 1 1981658736 20588176 11877008
20:33:03 10645 8192000000 10908838816 11337154560 1950327760 19.229 99 43 86 2 1983701216 20083248 13290208
20:33:31 8659 8192000000 10924375904 11352092672 1979146448 19.458 100 49 98 0 2016150000 21835104 15168448
20:33:47 5277 8192000000 10918110128 11342508032 1953537920 19.255 99 50 100 0 1989848384 21418608 14891856
20:34:02 19152 8192000000 10889739376 11330772992 1956521824 19.278 100 34 68 0 1988763840 22253248 9988768
20:34:32 12417 8192000000 10911135312 11339698176 1949958288 19.226 99 44 86 1 1985759984 23092704 12708992
20:34:52 9856 8192000000 10927089952 11357220864 1974567264 19.422 100 44 88 2 2011520448 24292976 12660208
20:35:13 7706 8192000000 10933178384 11366371328 1984539840 19.501 100 60 118 0 2030370528 28713568 17117120
20:35:29 8313 8192000000 10935928896 11365130240 1984029568 19.497 100 50 100 2 2024073856 25481536 14562752
20:35:50 8446 8192000000 10951528176 11378458624 1992184608 19.561 100 61 122 1 2040155696 30646656 17324432
20:36:06 5621 8192000000 10945368720 11370405888 1974701968 19.423 99 65 130 2 2020212464 26626192 18884304
20:36:25 14092 8192000000 10944675872 11373195264 1989317328 19.538 100 62 123 0 2033958192 26318096 18322768
20:36:45 10590 8192000000 10936337632 11370524672 1987939280 19.528 100 49 98 1 2028946800 26220896 14786624
20:37:10 8196 8192000000 10940328816 11373748224 1987624544 19.525 100 47 94 3 2027893648 26422144 13846960
20:37:27 10993 8192000000 10936778976 11374100480 1975231808 19.427 99 51 100 1 2017780304 27477968 15070528
20:37:48 4478 8192000000 10953974912 11382988800 1996561776 19.596 100 54 107 0 2039363760 26766176 16035808
20:38:02 2774 8192000000 10938981024 11359731712 1978228816 19.451 99 68 132 1 2024079056 26400256 19449984
20:38:13 4833 8192000000 10955402976 11379703808 1992152608 19.561 100 65 130 1 2041098576 29079616 19866352
20:38:26 7978 8192000000 10942489616 11362283520 1951864544 19.241 98 70 139 1 2003620704 30630304 21125856
20:38:43 7864 8192000000 10936777728 11357581312 1966186096 19.355 99 63 126 1 2017254480 31665840 19402544
20:38:59 4118 8192000000 10937707808 11363868672 1974117536 19.418 100 68 133 3 2027787584 32357920 21312128
20:39:15 17369 8192000000 10945146432 11370733568 1980687904 19.470 100 66 132 1 2031853888 31211296 19954688
20:39:39 10060 8192000000 10951999280 11379040256 1984593184 19.501 100 61 122 3 2040302576 36050112 19659280
20:39:59 8600 8192000000 10935553648 11373539328 1961631424 19.319 99 50 97 2 2016162912 39556256 14975232
20:40:16 1966 8192000000 10954519392 11373760512 1981747088 19.479 100 88 176 3 2041388688 33784608 25856992
20:40:25 2266 8192000000 10958598880 11369689088 1978918656 19.456 100 85 172 0 2041117760 35822320 26376784
20:40:34 9269 8192000000 10940208720 11360149504 1968920352 19.377 100 65 130 1 2023938592 35255616 19762624
20:40:53 6527 8192000000 10944375952 11365994496 1974747024 19.423 100 80 160 1 2035306560 36402048 24157488
20:41:09 4376 8192000000 10946526896 11361865728 1970642336 19.391 100 63 125 1 2026943008 37297200 19003472
20:41:23 4162 8192000000 10970339024 11388563456 1986876176 19.519 100 80 161 3 2051677792 40363392 24438224
20:41:34 6772 8192000000 10967399024 11389435904 1987506432 19.524 100 70 140 3 2052277008 42876864 21893712
20:41:48 3115 8192000000 10944474816 11358171136 1947600512 19.207 99 74 149 4 2015473568 43676944 24196112
20:41:59 8995 8192000000 10942314400 11370573824 1963930976 19.337 100 59 118 2 2028298192 45400480 18966736
20:42:20 8619 8192000000 10933199216 11351822336 1922602448 19.008 98 69 135 0 1988010224 43923392 21484384
20:42:35 9471 8192000000 10929202048 11349782528 1932552848 19.087 99 63 124 3 1996163344 43814592 19795904
20:42:54 1572 8192000000 10934042576 11347705856 1943900016 19.178 100 73 146 0 2014096672 46830512 23366144
20:43:06 3578 8192000000 10932463392 11352141824 1950714320 19.232 100 74 146 0 2017204032 43031056 23458656
20:43:18 7362 8192000000 10941158928 11363999744 1962140400 19.323 100 64 127 2 2019953024 37155792 20656832
20:43:33 4127 8192000000 10945749584 11371446272 1970898016 19.393 100 64 126 3 2029405264 39111472 19395776
20:43:44 12223 8192000000 10944503056 11381010432 1976083776 19.434 100 47 94 1 2031533072 40483872 14965424
20:44:06 2928 8192000000 10954273168 11386519552 1985458784 19.508 100 63 126 4 2043632336 37813888 20359664
20:44:18 2413 8192000000 10945375664 11355426816 1947057440 19.203 98 71 140 3 2009156848 40089200 22010208
20:44:28 2405 8192000000 10953199616 11366068224 1964726224 19.344 99 83 165 1 2031688208 42539424 24422560
20:44:42 1927 8192000000 10961404496 11377754112 1976461472 19.437 100 78 157 2 2044071696 44369136 23241088
20:44:51 6575 8192000000 10970770528 11387461632 1979968592 19.464 100 73 147 1 2047233040 44434208 22830240
20:45:05 1380 8192000000 10958434240 11375624192 1960925184 19.313 99 84 168 3 2032160672 45089072 26146416
20:45:14 5095 8192000000 10935407040 11368419328 1947612400 19.207 99 48 96 0 2009797680 46464288 15720992
20:45:28 16023 8192000000 10935249808 11373989888 1964180560 19.339 100 45 88 0 2029962352 50648688 15133104
20:46:08 2174 8192000000 10939745984 11347972096 1936489184 19.119 98 76 152 4 2009100208 48457072 24153952
20:46:17 5071 8192000000 10955851856 11372101632 1963564272 19.334 100 77 155 4 2038355776 50605568 24185936
20:46:30 3345 8192000000 10965243136 11379064832 1969567312 19.382 100 86 173 1 2049059312 52374208 27117792
20:46:41 2535 8192000000 10975001824 11385782272 1973240080 19.411 100 78 154 8 2050731136 53385968 24105088
20:46:49 3639 8192000000 10960019856 11369340928 1951170624 19.236 99 86 170 4 2032536416 54221984 27143808
20:47:00 3365 8192000000 10977839024 11390033920 1973406064 19.412 100 82 164 1 2055641872 56239968 25995840
20:47:10 4080 8192000000 10968167632 11381350400 1962282672 19.324 100 83 167 3 2046611488 58060800 26268016
20:47:21 2783 8192000000 10985025360 11388743680 1973545920 19.414 100 95 191 2 2061549328 58615520 29387888
20:47:32 3453 8192000000 10983832864 11390218240 1957573248 19.287 99 89 175 2 2046849584 61691808 27584528
20:47:42 3508 8192000000 10990659216 11404775424 1977112480 19.442 100 78 153 2 2064329984 62628000 24589504
20:47:53 1835 8192000000 10996326368 11408777216 1984530272 19.501 100 91 180 1 2076565536 63360480 28674784
20:48:01 2223 8192000000 11000307024 11417174016 1989242464 19.538 100 83 162 0 2079124496 63421008 26461024
20:48:10 2576 8192000000 10993432016 11409895424 1987490080 19.524 100 78 157 1 2076376192 64654592 24231520
20:48:24 5791 8192000000 10983118128 11406528512 1978448736 19.452 100 63 125 1 2064145648 65706304 19990608
20:48:38 2821 8192000000 11003275648 11414315008 1983890896 19.495 100 81 162 2 2077073392 67354496 25828000
20:48:52 5383 8192000000 11002256096 11426848768 1992918352 19.567 100 70 138 0 2083923376 68739472 22265552
20:49:07 9689 8192000000 10975956880 11424108544 1988012688 19.528 100 44 88 0 2068033008 65108080 14912240
20:49:36 12541 8192000000 10987608160 11418402816 1997837888 19.606 100 48 95 0 2067051792 53130192 16083712
20:50:02 11489 8192000000 10979835200 11429478400 1997568352 19.604 100 40 80 1 2068991168 57877312 13545504
20:50:23 10241 8192000000 10965482208 11412803584 1995788096 19.590 100 43 86 1 2054862592 45174128 13900368
20:50:40 8725 8192000000 10966265456 11404443648 1988093136 19.529 100 36 72 2 2045376624 45373600 11909888
20:50:56 7051 8192000000 10968190512 11411030016 1992447344 19.563 100 39 78 2 2052945056 47572608 12925104
20:51:10 12756 8192000000 10959571344 11408269312 1971080160 19.394 99 36 72 4 2031532080 48114608 12337312
20:51:37 24073 8192000000 10946090960 11396841472 1960659136 19.311 99 29 59 0 2019507136 48812768 10035232
20:52:09 13718 8192000000 10936395088 11391619072 1946836656 19.201 99 28 57 2 2007401056 51158432 9405968
20:52:44 21197 8192000000 10924860752 11382247424 1952746864 19.248 100 25 50 1 2011396256 49792064 8857328
20:53:12 16694 8192000000 10927239568 11381473280 1947341936 19.205 100 20 40 0 2009003088 54312080 7349072
20:53:35 23077 8192000000 10927689616 11380002816 1941613920 19.160 100 22 42 1 2006381344 56546128 8221296
20:55:03 35913 8192000000 10949663408 11394789376 1907903728 18.890 98 26 51 1 1996284240 78319952 10060560
20:55:46 23270 8192000000 10886344544 11343384576 1906480000 18.878 98 18 37 0 1952617424 38724080 7413344
20:56:15 27481 8192000000 10880269872 11347320832 1937582208 19.127 100 15 29 3 1962659008 20582672 4494128
20:56:49 45607 8192000000 10884549904 11354570752 1942895424 19.170 100 16 33 0 1968704400 21232112 4576864
20:58:06 116652 8192000000 10891792080 11359318016 1943315232 19.173 99 11 22 2 1964655264 18815088 2524944
21:00:15 43011 8192000000 10928379600 11354533888 1935004512 19.107 98 56 110 1 1960120384 8262144 16853728
21:01:18 20679 8192000000 10902475712 11363749888 1968742464 19.375 100 21 42 3 1985806880 11319120 5745296
21:01:56 187923 8192000000 10890112944 11336130560 1875093744 18.625 95 23 47 0 1888339936 6622544 6623648
21:05:33 55037 8192000000 10899531552 11350966272 1960540768 19.310 100 28 56 3 1975497296 7320032 7636496
21:06:37 67929 8192000000 10860866896 11321425920 1901902496 18.842 97 17 34 1 1917228192 10240704 5084992
21:07:59 8388 8192000000 10880414464 11325837312 1915379504 18.950 98 37 74 2 1935947024 9551376 11016144
21:08:15 7606 8192000000 10893180576 11344695296 1963265712 19.332 100 45 89 0 1988254976 12478288 12510976
21:08:30 55863 8192000000 10908021120 11370336256 1974250112 19.419 100 16 32 1 1990128640 11431264 4447264
21:09:32 49227 8192000000 10941701248 11376324608 1964600752 19.343 99 31 60 0 1986493376 12933744 8958880
21:10:31 60277 8192000000 10911968304 11377004544 1966196832 19.355 99 31 62 2 1996384688 20995920 9191936
21:11:41 38518 8192000000 10891970624 11377033216 1953887584 19.257 99 12 24 1 1981090208 23457536 3745088
21:12:28 14708 8192000000 10886613040 11373928448 1949895184 19.226 99 11 22 0 1970276784 17012352 3369248
21:14:27 52900 8192000000 10889983184 11361193984 1963331088 19.333 99 13 26 1 1981334624 14219008 3784528
21:15:26 73430 8192000000 10897411216 11379994624 1975343584 19.428 100 8 16 3 1989995120 12807376 1844160
21:16:46 80110 8192000000 10928649072 11404177408 1974344752 19.420 99 13 25 0 1994313136 16490752 3477632
21:18:12 46484 8192000000 10914242992 11367694336 1909346304 18.901 96 27 52 1 1935039856 17607664 8085888
21:19:09 54237 8192000000 10910740304 11384360960 1960738016 19.312 99 23 46 1 1985017840 16933072 7346752
21:20:10 38164 8192000000 10916346208 11369385984 1928630736 19.056 97 40 80 0 1954885536 14014656 12240144
21:21:07 57859 8192000000 10909174144 11379167232 1973759664 19.415 100 21 42 0 1994443760 14654048 6030048
21:22:11 110661 8192000000 10880368848 11354648576 1851900000 18.438 94 12 24 0 1870776496 15715792 3160704
21:24:45 93987 8192000000 10876732976 11351019520 1895844256 18.793 97 15 30 1 1913209056 13329328 4035472
21:26:26 76630 8192000000 10877404080 11344007168 1859619392 18.500 95 16 32 1 1883998352 20017408 4361552
21:28:07 40466 8192000000 10887564752 11347533824 1923866080 19.018 98 12 24 0 1938376736 11233248 3277408
21:29:04 94786 8192000000 10896365904 11347243008 1926093616 19.036 98 26 52 1 1943098672 8930048 8075008
21:30:45 37832 8192000000 10887950288 11346681856 1941265184 19.157 99 37 74 3 1962573296 10704656 10603456
21:31:31 8499 8192000000 10896276224 11347079168 1957745824 19.288 100 43 84 2 1981364336 11932368 11686144
21:31:46 13510 8192000000 10878953008 11340374016 1938405888 19.134 99 36 72 1 1962541376 13578016 10557472
21:32:54 69094 8192000000 10850044752 11332120576 1873083616 18.609 96 16 32 0 1894392704 17179792 4129296
21:34:34 79617 8192000000 10889809056 11360907264 1959280064 19.300 100 14 28 3 1982411744 18711728 4419952
21:36:11 52815 8192000000 10876931856 11354320896 1931926000 19.082 98 16 32 0 1947057904 11276672 3855232
21:37:35 67584 8192000000 10866081360 11345092608 1915775568 18.953 98 10 20 1 1933668880 14391456 3501856
21:38:58 25392 8192000000 10881366016 11341426688 1948532000 19.215 100 28 56 1 1963281056 6544496 8204560
21:39:32 49161 8192000000 10892762512 11362099200 1943928800 19.178 99 17 34 0 1957024480 8214672 4881008
21:40:33 61421 8192000000 10868477440 11350290432 1930110112 19.068 98 26 52 2 1946672960 9512256 7050592
21:41:58 68841 8192000000 10875141344 11359502336 1958304912 19.293 100 9 19 0 1971890544 10908768 2676864
21:43:13 28924 8192000000 10848168784 11329732608 1894584704 18.783 97 13 26 1 1910584096 11978400 4020992
21:43:48 42637 8192000000 10886500336 11338838016 1917747008 18.969 98 19 38 0 1929447968 6508192 5192768
21:44:38 53160 8192000000 10881373408 11358683136 1943018368 19.171 99 16 32 2 1956089872 8764864 4306640
21:46:09 42692 8192000000 10904429760 11358248960 1935341040 19.110 99 28 56 0 1950852240 8009968 7501232
21:47:25 29717 8192000000 10892703248 11355516928 1942759808 19.169 99 31 62 3 1966451728 15106448 8585472
21:48:02 59794 8192000000 10875119184 11355598848 1907075952 18.883 98 12 24 1 1924341200 13889824 3375424
21:49:09 47110 8192000000 10868311232 11348963328 1937037120 19.123 99 26 53 3 1955070992 10184752 7849120
21:50:04 93787 8192000000 10904087392 11363635200 1919381216 18.982 98 19 38 2 1933332400 8777648 5173536
21:51:44 32689 8192000000 10876380592 11347124224 1923839520 19.018 98 26 52 2 1939451152 8285120 7326512
21:52:30 79208 8192000000 10899907456 11376005120 1954375504 19.261 99 23 46 2 1976578048 15378256 6824288
21:54:07 65977 8192000000 10882900400 11340451840 1944725232 19.184 99 10 20 1 1960605680 13293344 2587104
21:55:20 26474 8192000000 10886549792 11340845056 1911306896 18.917 97 45 90 0 1934092544 9329920 13455728
21:55:58 54330 8192000000 10869388000 11352805376 1938218256 19.133 99 25 50 2 1958452400 13071264 7162880
21:57:04 125554 8192000000 10873552416 11338682368 1900442080 18.830 97 18 35 1 1913576160 8345936 4788144
21:59:17 48220 8192000000 10894160896 11357974528 1970423632 19.389 100 28 54 2 1986269200 7591856 8253712
22:00:11 45684 8192000000 10867714304 11338354688 1928498672 19.055 98 20 40 1 1941840096 7504992 5836432
22:01:07 120182 8192000000 10917214736 11374903296 1939895456 19.146 98 13 26 0 1958860928 14905760 4059712
22:03:46 62803 8192000000 10931056400 11399274496 1992176032 19.561 100 26 52 2 2015470208 16027888 7266288
22:04:55 62064 8192000000 10896009264 11406184448 1958385968 19.293 99 6 12 0 1976903424 16719584 1797872
22:06:04 59980 8192000000 10908040576 11377106944 1964743392 19.344 99 17 34 0 1977156448 8094304 4318752
22:07:11 19537 8192000000 10923638496 11381436416 1969855856 19.384 99 29 57 2 1987406496 9265040 8285600
22:07:59 68827 8192000000 10900596320 11376271360 1960592944 19.311 99 17 34 0 1978176656 12710320 4873392
22:09:24 90667 8192000000 10905921312 11375521792 1923443936 19.014 97 16 32 1 1947904080 19992400 4467744
22:11:02 68469 8192000000 10886351568 11346280448 1883278928 18.692 96 22 38 3 1912260928 22339952 6642048
22:12:20 24387 8192000000 10900979552 11353976832 1946545440 19.199 99 39 78 2 1968415648 10744144 11126064
22:13:00 33773 8192000000 10904295984 11377004544 1962641824 19.327 100 31 62 2 1990526224 19120224 8764176
22:13:43 57898 8192000000 10886629216 11346804736 1889100832 18.739 96 19 38 1 1905933616 11152368 5680416
22:14:47 36784 8192000000 10892486352 11343450112 1897399280 18.805 97 39 76 1 1917471376 8945168 11126928
22:15:35 41504 8192000000 10885585232 11351695360 1931076640 19.075 99 24 48 3 1950972528 13215984 6679904
22:16:45 44729 8192000000 10901446144 11362148352 1941130752 19.156 99 21 41 1 1956990784 9648944 6211088
22:17:39 47113 8192000000 10875993328 11336077312 1865577472 18.548 95 28 56 0 1884160032 11046240 7536320
22:18:36 123705 8192000000 10863117984 11310247936 1824885632 18.218 94 31 61 1 1845151280 10579328 9686320
22:20:47 24071 8192000000 10872273520 11324301312 1921972688 19.003 99 43 85 0 1943532912 8605056 12955168
22:21:20 60702 8192000000 10877210288 11342749696 1937698384 19.128 100 40 80 1 1960267328 11380720 11188224
22:22:29 32521 8192000000 10869195408 11341312000 1931455392 19.079 99 29 58 3 1951236368 11598912 8182064
22:23:19 56440 8192000000 10856696832 11339296768 1925941888 19.034 99 9 18 0 1939859008 11371664 2545456
22:24:22 41263 8192000000 10839210288 11318185984 1865197760 18.545 96 13 26 0 1885023136 15782512 4042864
22:25:09 28320 8192000000 10857320176 11328315392 1924640560 19.024 100 11 22 0 1941311472 13261792 3409120
22:26:45 60197 8192000000 9688665280 10030481408 832375120 9.223 44 10 17 1 842466208 7717440 2373648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-01-2021 22:30:05 to 17-01-2021 22:30:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 126 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-01-2021 22:30:37 to 17-01-2021 22:30:39.

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          243570
MON$OLDEST_ACTIVE               244711
MON$OLDEST_SNAPSHOT             244711
MON$NEXT_TRANSACTION            244711
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                       2046560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:1020: 
:1021: mscs-test-161.budzdorov.ru    Sun Jan 17 22:28:06 2021
:1022:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1023: 
:1024: 
:1025: mscs-test-161.budzdorov.ru    Sun Jan 17 22:28:07 2021
:1026:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1027: 
:1028: 
:1029: mscs-test-161.budzdorov.ru    Sun Jan 17 22:28:07 2021
:1030:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1031: 
:1032: 
:1033: mscs-test-161.budzdorov.ru    Sun Jan 17 22:28:07 2021
:1034:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1035: 
:1036: 
:1037: mscs-test-161.budzdorov.ru    Sun Jan 17 22:28:07 2021
:1038:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1039: 
--- end of diff output ---

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

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