Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.01.2021 19: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 17441480 kB
MemAvailable 31318464 kB
Buffers 0 kB
Cached 14222496 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-14 19:27:08
DTS_END                         2021-01-14 19:27:08.4880
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51210
TRN_ID                          235400
ATT_ID                          680
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: 9034.80 19154 1084176
customer order: creation 168.63 337 20236
customer order: refuse 14.55 301 1746
order to supplier: creation 45.40 1216 5448
order to supplier: removal 3.44 104090 413
invoice (draft): creation 45.98 3509 5517
invoice (draft): removal 53.03 874 6364
invoice accept: apply 40.30 18313 4836
invoice accept: cancel 47.62 722 5714
customer reserve: creation 3633.81 186 436057
customer reserve: removal 4689.79 59 562775
realization accept: apply 80.76 153 9691
realization accept: cancel 85.93 99 10312
payment from customer: creation 57.90 97 6948
payment from customer: removal 5.43 63 651
payment to supplier: creation 47.38 118 5686
payment to supplier: removal 3.27 75 392
service: total inventory turnovers 4.59 1211 551
service: total monetary turnovers 6.11 24 733
service: aggregate perf. data 0.85 15175 102
service: refresh index statistics 0.03 236460 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-01-2021 19:27:45 to 14-01-2021 19:27:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2201
TEST_TIME 2 3277
TEST_TIME 3 3960
TEST_TIME 4 3989
TEST_TIME 5 4233
TEST_TIME 6 4685
TEST_TIME 7 5028
TEST_TIME 8 5201
TEST_TIME 9 5434
TEST_TIME 10 5845
TEST_TIME 11 5856
TEST_TIME 12 6307
TEST_TIME 13 6348
TEST_TIME 14 6359
TEST_TIME 15 6563
TEST_TIME 16 6790
TEST_TIME 17 6887
TEST_TIME 18 7261
TEST_TIME 19 7302
TEST_TIME 20 8278
TEST_TIME 21 8410
TEST_TIME 22 8651
TEST_TIME 23 9225
TEST_TIME 24 10049
TEST_TIME 25 10409
TEST_TIME 26 11249
TEST_TIME 27 11091
TEST_TIME 28 10820
TEST_TIME 29 10660
TEST_TIME 30 10435
TEST_TIME 31 10269
TEST_TIME 32 10128
TEST_TIME 33 9924
TEST_TIME 34 9956
TEST_TIME 35 9761
TEST_TIME 36 9819
TEST_TIME 37 9690
TEST_TIME 38 9653
TEST_TIME 39 9542
TEST_TIME 40 9492
TEST_TIME 41 9303
TEST_TIME 42 9220
TEST_TIME 43 9214
TEST_TIME 44 9261
TEST_TIME 45 9224
TEST_TIME 46 9295
TEST_TIME 47 9317
TEST_TIME 48 9298
TEST_TIME 49 9429
TEST_TIME 50 9339
TEST_TIME 51 9301
TEST_TIME 52 9251
TEST_TIME 53 9398
TEST_TIME 54 9309
TEST_TIME 55 9310
TEST_TIME 56 9198
TEST_TIME 57 9174
TEST_TIME 58 9108
TEST_TIME 59 9015
TEST_TIME 60 8982
TEST_TIME 61 8957
TEST_TIME 62 8918
TEST_TIME 63 8880
TEST_TIME 64 8948
TEST_TIME 65 8987
TEST_TIME 66 9040
TEST_TIME 67 9040
TEST_TIME 68 9087
TEST_TIME 69 9176
TEST_TIME 70 9183
TEST_TIME 71 9173
TEST_TIME 72 9202
TEST_TIME 73 9227
TEST_TIME 74 9212
TEST_TIME 75 9199
TEST_TIME 76 9232
TEST_TIME 77 9134
TEST_TIME 78 9098
TEST_TIME 79 9080
TEST_TIME 80 9061
TEST_TIME 81 8991
TEST_TIME 82 9040
TEST_TIME 83 8997
TEST_TIME 84 8960
TEST_TIME 85 8918
TEST_TIME 86 8942
TEST_TIME 87 8911
TEST_TIME 88 8971
TEST_TIME 89 8945
TEST_TIME 90 8953
TEST_TIME 91 8959
TEST_TIME 92 9043
TEST_TIME 93 9036
TEST_TIME 94 9069
TEST_TIME 95 9130
TEST_TIME 96 9154
TEST_TIME 97 9121
TEST_TIME 98 9182
TEST_TIME 99 9203
TEST_TIME 100 9134
TEST_TIME 101 9088
TEST_TIME 102 9073
TEST_TIME 103 9036
TEST_TIME 104 8996
TEST_TIME 105 8941
TEST_TIME 106 8971
TEST_TIME 107 8934
TEST_TIME 108 8944
TEST_TIME 109 8995
TEST_TIME 110 8971
TEST_TIME 111 8994
TEST_TIME 112 9025
TEST_TIME 113 8987
TEST_TIME 114 9106
TEST_TIME 115 9093
TEST_TIME 116 9092
TEST_TIME 117 9097
TEST_TIME 118 9109
TEST_TIME 119 9107
TEST_TIME 120 9041

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-01-2021 19:27:48 to 14-01-2021 19:27:52.

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 1490407 1490407 0 0.00 0 15910 6 0 0
doc_list_biud 1490400 1490400 0 0.00 0 36290 28 0 0
sp_add_invoice_to_stock 4964 4836 128 2.57 46 177909 18314 0 128
sp_cancel_adding_invoice 5714 5714 0 0.00 4 54645 722 0 0
sp_cancel_client_order 1746 1746 0 0.00 4 10929 302 0 0
sp_cancel_customer_reserve 562775 562775 0 0.00 1 27142 59 0 0
sp_cancel_pay_from_customer 651 651 0 0.00 3 3274 63 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 2 6416 75 0 0
sp_cancel_supplier_invoice 6375 6364 11 0.17 2 36300 875 0 11
sp_cancel_supplier_order 413 413 0 0.00 7 1153282 104091 0 0
sp_cancel_write_off 10312 10312 0 0.00 1 8586 99 0 0
sp_client_order 20236 20236 0 0.00 3 40229 337 0 0
sp_customer_reserve 436057 436057 0 0.00 0 54063 187 0 0
sp_fill_shopping_cart 31173 31173 0 0.00 1 31238 38 0 0
sp_fill_shopping_cart_clo_res 436043 436043 0 0.00 0 27092 14 0 0
sp_get_clo_for_invoice 4822 4822 0 0.00 0 26077 302 0 0
sp_kill_cost_storno 17069 17069 0 0.00 0 5012 50 0 0
sp_kill_qstorno_ret_qs2qd 1142639 1142639 0 0.00 0 36285 33 0 0
sp_kill_qty_storno 601830 601830 0 0.00 0 36288 70 0 0
sp_lock_selected_doc 20128 20128 0 0.00 0 4940 3 0 0
sp_make_cost_storno 27147 27147 0 0.00 0 15900 46 0 0
sp_multiply_rows_for_pdistr 27140 27140 0 0.00 0 10819 24 0 0
sp_multiply_rows_for_qdistr 20236 20236 0 0.00 0 13688 157 0 0
sp_pay_from_customer 6948 6948 0 0.00 4 25178 98 0 0
sp_pay_to_supplier 5686 5686 0 0.00 4 21117 118 0 0
sp_payment_common 12634 12634 0 0.00 1 25123 24 0 0
sp_qd_handle_on_cancel_clo 1746 1746 0 0.00 0 10921 282 0 0
sp_qd_handle_on_invoice_upd_sts 10531 10531 0 0.00 0 27728 318 0 0
sp_qd_handle_on_reserve_upd_sts 9689 9689 0 0.00 0 10158 56 0 0
sp_reserve_write_off 9691 9691 0 0.00 6 11197 154 0 0
sp_supplier_invoice 5517 5517 0 0.00 7 120176 3510 0 0
sp_supplier_order 5448 5448 0 0.00 5 34500 1216 0 0
srv_aggregate_perf_data 103 102 1 0.97 2608 153026 15176 0 1
srv_fill_mon_cache_memory 151 151 0 0.00 1463 160706 36017 0 0
srv_find_qd_qs_mism 1039288 1039288 0 0.00 0 11380 5 0 0
srv_make_invnt_saldo 551 551 0 0.00 41 177514 1211 0 0
srv_make_money_saldo 733 733 0 0.00 1 2657 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 142090 276172 236460 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4836 4836 0 0.00 0 7950 141 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 1 2004 78 0 0
t$perf-norm:sp_cancel_client_order 1746 1746 0 0.00 0 2601 16 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 9502 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 651 651 0 0.00 0 2098 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 880 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 3639 38 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 28268 1434 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 1133 6 0 0
t$perf-norm:sp_client_order 20236 20236 0 0.00 0 6286 16 0 0
t$perf-norm:sp_customer_reserve 992 992 0 0.00 0 2589 10 0 0
t$perf-norm:sp_pay_from_customer 6948 6948 0 0.00 0 4223 7 0 0
t$perf-norm:sp_pay_to_supplier 5686 5686 0 0.00 0 10870 11 0 0
t$perf-norm:sp_reserve_write_off 9691 9691 0 0.00 0 7304 10 0 0
t$perf-norm:sp_supplier_invoice 5517 5517 0 0.00 0 4880 21 0 0
t$perf-norm:sp_supplier_order 5448 5448 0 0.00 0 2524 13 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 765 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 42 1 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 887 15 0 0
t$perf-norm:srv_make_money_saldo 733 733 0 0.00 0 2121 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 4 0 0
v_add_invoice_to_stock 9890 9634 256 2.58 0 6789 18 0 256
v_all_customers 36884 36884 0 0.00 0 17 1 0 0
v_all_suppliers 30054 30054 0 0.00 0 17 1 0 0
v_all_wares 40472 40472 0 0.00 0 61 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 415 6 0 0
v_cancel_client_order 3492 3492 0 0.00 0 1793 5 0 0
v_cancel_customer_prepayment 1302 1302 0 0.00 0 1935 6 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 2516 5 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 6362 12 0 0
v_cancel_supplier_invoice 760 738 22 2.89 0 1469 19 0 22
v_cancel_supplier_order 826 826 0 0.00 0 1148 4 0 0
v_cancel_write_off 1926 1926 0 0.00 0 2489 15 0 0
v_max_id_clo_ord 5444 5444 0 0.00 0 9321 3 0 0
v_max_id_clo_res 992 992 0 0.00 0 1285 9 0 0
v_max_id_ord_sup 5492 5492 0 0.00 0 4045 6 0 0
v_max_non_paid_invoice 1595 1595 0 0.00 0 390 2 0 0
v_max_non_paid_realizn 3599 3599 0 0.00 0 2258 4 0 0
v_min_id_clo_ord 5444 5444 0 0.00 0 2975 7 0 0
v_min_id_clo_res 992 992 0 0.00 0 4604 11 0 0
v_min_id_ord_sup 5492 5492 0 0.00 0 6717 6 0 0
v_min_non_paid_invoice 5686 5686 0 0.00 0 5085 11 0 0
v_min_non_paid_realizn 6948 6948 0 0.00 0 17025 12 0 0
v_our_firm 10286 10286 0 0.00 0 12 1 0 0
v_reserve_write_off 19378 19378 0 0.00 0 8494 4 0 0
x_lock_depdocs_on_canc_invoice 11709 11709 0 0.00 0 19367 113 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 11283 329 0 0
x_make_qstorno_1000_1200 5448 5448 0 0.00 2 34314 1141 0 0
x_make_qstorno_1200_2000 5517 5517 0 0.00 4 119692 3361 0 0
x_make_qstorno_2100_3300 436057 436057 0 0.00 0 54061 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-01-2021 19:27:53 to 14-01-2021 19:27:57.

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
16:57:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:18 16763 8192000000 10241026976 10550452224 822757744 9.126 65 52 104 0 842755056 2494144 17503168
16:57:43 31236 8192000000 10353964976 10674958336 1376458976 14.385 100 84 168 0 1408493632 4844208 27190448
16:58:22 18624 8192000000 10382599232 10707431424 1442956688 14.976 100 89 178 0 1478898544 7027424 28914432
16:58:57 29345 8192000000 10419204768 10750898176 1470239456 15.216 100 91 182 0 1508159872 8377776 29542640
16:59:35 11918 8192000000 10432995760 10767470592 1489646208 15.386 100 92 185 0 1528293472 9136960 29510304
16:59:58 22807 8192000000 10449146688 10783100928 1496707088 15.447 100 91 182 0 1536064688 10070032 29287568
17:00:35 21400 8192000000 10468409328 10809741312 1517527504 15.629 100 90 180 1 1557002688 10850080 28625104
17:01:18 10747 8192000000 10499284304 10847338496 1560850000 16.004 100 79 158 0 1596292000 10926896 24515104
17:01:41 13669 8192000000 10512987344 10865033216 1568083088 16.066 100 75 150 1 1602486656 11336272 23067296
17:02:05 16409 8192000000 10540925744 10895618048 1589253440 16.247 100 82 165 0 1626123632 11788560 25081632
17:02:29 13620 8192000000 10562820576 10922557440 1615348768 16.470 100 79 157 1 1650513472 11688576 23476128
17:02:54 12014 8192000000 10578326448 10941231104 1636023264 16.646 100 82 165 1 1672522064 11977696 24521104
17:03:22 15387 8192000000 10591149888 10960261120 1651263664 16.775 100 75 150 3 1684801872 11674832 21863376
17:03:50 9054 8192000000 10617325728 10986467328 1681333616 17.029 100 73 145 1 1713621712 11380736 20907360
17:04:10 7587 8192000000 10640568784 11012300800 1701284336 17.196 100 77 152 1 1734596784 11926784 21385664
17:04:27 8522 8192000000 10648636576 11024846848 1712553104 17.290 100 76 150 1 1747480000 13498400 21428496
17:04:45 6375 8192000000 10669644816 11045351424 1731762592 17.450 100 77 151 1 1765965344 12565664 21637088
17:05:00 7173 8192000000 10672886608 11053281280 1738983536 17.510 100 68 131 3 1770011200 12282368 18745296
17:05:14 8127 8192000000 10677860864 11062542336 1747442112 17.580 100 72 144 0 1780224944 12659936 20122896
17:05:29 3155 8192000000 10699098864 11080019968 1761633120 17.698 100 86 172 0 1797716288 12863200 23219968
17:05:40 9096 8192000000 10690556928 11078230016 1766094896 17.735 100 76 151 2 1800133184 13454544 20583744
17:05:56 7063 8192000000 10721923488 11107139584 1775170864 17.810 100 75 148 2 1809495568 13654336 20670368
17:06:10 3410 8192000000 10728292768 11116986368 1791932992 17.948 100 80 158 0 1828482240 14206240 22343008
17:06:21 2408 8192000000 10736125328 11123261440 1799045168 18.006 100 79 158 0 1834113008 12779920 22287920
17:06:30 3091 8192000000 10744737360 11129995264 1803535472 18.043 100 86 172 1 1841500272 12955552 25009248
17:06:40 3228 8192000000 10752873680 11137601536 1815436784 18.140 100 90 180 2 1852944496 12402288 25105424
17:06:50 3110 8192000000 10766950704 11150458880 1820567264 18.182 100 86 172 0 1858137328 13956368 23613696
17:07:00 2458 8192000000 10773132672 11157151744 1825400800 18.222 100 92 184 0 1869058048 18095248 25562000
17:07:08 2048 8192000000 10775895872 11162546176 1837699088 18.322 100 91 180 2 1877058656 13986592 25372976
17:07:17 2439 8192000000 10776884160 11162832896 1837707200 18.322 100 81 159 0 1873306672 12608368 22991104
17:07:26 2760 8192000000 10785915936 11171745792 1842535264 18.361 100 88 175 3 1880053840 12641152 24877424
17:07:35 2153 8192000000 10777517216 11169533952 1844519360 18.378 100 86 170 2 1881692768 13094288 24079120
17:07:44 2399 8192000000 10797993984 11181342720 1849124592 18.415 100 91 183 0 1888297680 13392528 25780560
17:07:53 2772 8192000000 10796449504 11183271936 1847802016 18.404 100 89 178 1 1887514224 14898960 24813248
17:08:02 1381 8192000000 10803909152 11191353344 1861051184 18.512 100 93 187 1 1901183744 14305104 25827456
17:08:09 2439 8192000000 10810461088 11197870080 1862159312 18.521 100 91 180 1 1901419760 13914224 25346224
17:08:18 1285 8192000000 10812002832 11200417792 1866177728 18.553 100 87 174 0 1903712080 12547136 24987216
17:08:26 39880 8192000000 10791822976 11194732544 1860824336 18.510 100 61 120 2 1889140368 10978304 17337728
17:09:12 1305 8192000000 10809501392 11204890624 1869370128 18.579 100 89 176 2 1906127088 11795264 24961696
17:09:21 5575 8192000000 10775718848 11196735488 1861805616 18.518 100 45 90 0 1883889360 9626912 12456832
17:09:34 8930 8192000000 10781914560 11204308992 1863718032 18.533 100 35 70 0 1886309904 12338448 10253424
17:09:49 4397 8192000000 10770350656 11200540672 1865689536 18.549 100 26 50 3 1879706448 6920288 7096624
17:10:03 10733 8192000000 10778063616 11206193152 1872679152 18.606 100 22 44 2 1883858576 5379376 5800048
17:10:20 3599 8192000000 10786466624 11214376960 1878450704 18.653 100 38 77 2 1896455936 7489600 10515632
17:10:34 7675 8192000000 10792215584 11217551360 1878724880 18.655 100 24 48 0 1891212096 5463248 7023968
17:10:48 15152 8192000000 10791276928 11221004288 1880197552 18.667 100 19 38 2 1891495360 5793424 5504384
17:11:09 7566 8192000000 10797699120 11225591808 1885317696 18.708 100 23 44 1 1896899632 5723376 5858560
17:11:23 13711 8192000000 10814145472 11232735232 1888188784 18.731 100 31 61 5 1902676752 5531856 8956112
17:11:43 48819 8192000000 10828234528 11239968768 1893149712 18.771 100 52 102 0 1913726352 5521216 15055424
17:12:38 4663 8192000000 10801476400 11237560320 1890866336 18.753 100 35 70 0 1909662896 9256592 9539968
17:12:49 7543 8192000000 10798431648 11235127296 1890806080 18.752 100 17 34 1 1901719824 5519184 5394560
17:13:04 9485 8192000000 10807833216 11241361408 1895261568 18.788 100 29 58 1 1910497456 7008672 8227216
17:13:20 5221 8192000000 10814470288 11244879872 1899492288 18.822 100 38 76 1 1917303552 6470544 11340720
17:13:33 5690 8192000000 10818495232 11244544000 1900221840 18.828 100 30 60 1 1915368992 6624720 8522432
17:13:46 6173 8192000000 10814743008 11247968256 1899346640 18.821 100 29 58 0 1918433536 11286368 7800528
17:14:01 5499 8192000000 10811727360 11252543488 1900476368 18.830 100 27 54 0 1918821216 10614112 7730736
17:14:15 13797 8192000000 10809260864 11250724864 1903507600 18.854 100 27 54 2 1921210096 10319712 7382784
17:14:35 12063 8192000000 10809284496 11246501888 1900722656 18.832 100 19 38 1 1911935392 5903328 5309408
17:14:56 10336 8192000000 10810783728 11245301760 1885175232 18.707 99 26 51 0 1898125056 4811840 8137984
17:15:16 11825 8192000000 10811166816 11245416448 1894557568 18.782 100 13 24 1 1903311200 5564544 3189088
17:15:35 11101 8192000000 10806632144 11245887488 1898575904 18.815 100 8 16 1 1906215792 5446256 2193632
17:15:52 14302 8192000000 10818409616 11253874688 1908173936 18.892 100 26 52 2 1921583552 6550528 6859088
17:16:17 9390 8192000000 10816088720 11256086528 1906659680 18.880 100 29 58 4 1920764736 5612064 8492992
17:16:35 54152 8192000000 10788633984 11209736192 1813700912 18.126 95 36 70 0 1829191552 4852960 10637680
17:17:35 9555 8192000000 10775420144 11208916992 1811780304 18.110 96 31 62 3 1827937728 7351904 8805520
17:17:52 9628 8192000000 10736136384 11153543168 1727323840 17.413 93 24 46 2 1738908320 5672848 5911632
17:18:08 3740 8192000000 10762882688 11183489024 1829209344 18.253 99 34 69 1 1850065360 10427520 10428496
17:18:20 7911 8192000000 10744526224 11172454400 1796526880 17.985 97 34 68 2 1811804640 5023920 10253840
17:18:34 5676 8192000000 10734013584 11159924736 1801748096 18.028 98 27 54 0 1815485360 6159248 7578016
17:18:47 8602 8192000000 10723872400 11143454720 1737614752 17.499 95 15 30 2 1746904208 5178848 4110608
17:19:05 11759 8192000000 10718008720 11138310144 1782724912 17.872 98 19 38 2 1794136368 5535536 5875920
17:19:24 12888 8192000000 10735562368 11158519808 1776412032 17.820 97 13 26 1 1785178016 5266032 3499952
17:19:44 12067 8192000000 10704772288 11128967168 1688403504 17.088 92 28 55 2 1705184256 8613520 8167232
17:20:02 10428 8192000000 10700649760 11120152576 1731408944 17.447 96 19 38 0 1742739680 5397200 5933536
17:20:19 9384 8192000000 10703055024 11118391296 1742986800 17.543 97 25 50 1 1756439856 6223792 7229264
17:20:34 13534 8192000000 10718460624 11131355136 1763300672 17.712 98 34 67 0 1779371136 4899344 11171120
17:20:58 10960 8192000000 10719771744 11136937984 1764892080 17.725 97 20 40 2 1775776832 4904032 5980720
17:21:17 68743 8192000000 10710596736 11134259200 1722739760 17.375 95 25 51 0 1736249392 4878816 8630816
17:22:40 10750 8192000000 10736127456 11154227200 1803433584 18.042 99 24 48 2 1816160560 5535280 7191696
17:22:57 8624 8192000000 10738069584 11164553216 1825871424 18.226 100 18 35 3 1836970736 5804432 5294880
17:23:12 8313 8192000000 10757898064 11178704896 1835388480 18.303 100 20 40 2 1846629408 5679856 5561072
17:23:29 5651 8192000000 10747317824 11169755136 1832084080 18.276 100 19 36 2 1843011376 5316768 5610528
17:23:42 11201 8192000000 10772750352 11188998144 1846547760 18.394 100 23 46 0 1858670144 5932080 6190304
17:24:01 10565 8192000000 10760114784 11189645312 1851775312 18.437 100 23 46 4 1864676640 5856320 7045008
17:24:21 7916 8192000000 10763412016 11195678720 1855018112 18.463 100 22 43 0 1867889200 6226720 6644368
17:24:36 10588 8192000000 10773598976 11200544768 1855357088 18.466 100 19 36 1 1865824048 5110960 5356000
17:24:57 8470 8192000000 10771810624 11203866624 1860943376 18.511 100 23 46 2 1874012976 5854784 7214816
17:25:11 5707 8192000000 10778800288 11205726208 1863908496 18.535 100 25 49 0 1877543952 6233328 7402128
17:25:24 6777 8192000000 10769651344 11204493312 1864906448 18.543 100 22 42 1 1877329984 6085536 6338000
17:25:37 10516 8192000000 10782188704 11210506240 1868476288 18.572 100 25 50 0 1881869488 6040944 7352256
17:25:53 9298 8192000000 10784313136 11216269312 1872975408 18.608 100 24 48 0 1889880016 10315392 6589216
17:26:09 11600 8192000000 10787579232 11219390464 1874089664 18.617 100 17 34 0 1888695984 9553008 5053312
17:26:31 160705 8192000000 10843815888 11269861376 1898856800 18.817 100 47 94 0 1921344480 8901568 13586112
17:29:20 25371 8192000000 10872377952 11289849856 1922190032 19.004 100 40 79 1 1950651200 17196304 11264864
17:29:54 34264 8192000000 10861845520 11293712384 1929904448 19.066 100 40 79 0 1955948336 13871440 12172448
17:30:36 24311 8192000000 10874507088 11305291776 1941442768 19.158 100 36 72 0 1965208880 13684768 10081344
17:31:13 17773 8192000000 10893758512 11320492032 1954169568 19.260 100 49 96 0 1984132480 14776208 15186704
17:31:38 10906 8192000000 10896624208 11321331712 1957352704 19.285 100 46 92 1 1987637584 15986560 14298320
17:31:56 26200 8192000000 10900730464 11329486848 1963410912 19.333 100 60 120 2 1997953552 17313600 17229040
17:32:29 15359 8192000000 10900368144 11334811648 1962810992 19.328 100 42 84 1 1993937856 18824400 12302464
17:32:53 9706 8192000000 10908649744 11337805824 1966846176 19.360 100 41 82 1 1998147664 18040240 13261248
17:33:13 14114 8192000000 10908097376 11340541952 1969666320 19.383 100 47 87 1 2000672720 17702016 13304384
17:33:46 10678 8192000000 10919751488 11356717056 1977866432 19.448 100 43 84 0 2010079616 19742080 12471104
17:34:07 7330 8192000000 10938049136 11366305792 1988326736 19.531 100 61 123 0 2026958912 20538432 18093744
17:34:27 14968 8192000000 10932533520 11370029056 1988655968 19.533 100 51 103 1 2027541664 23435408 15450288
17:34:52 9137 8192000000 10923442224 11359096832 1968638816 19.375 99 45 90 2 2005697024 23018800 14039408
17:35:15 19263 8192000000 10946180272 11379613696 1987164880 19.521 100 56 111 1 2027065920 23395360 16505680
17:35:47 3299 8192000000 10958384608 11385511936 2002098032 19.639 100 57 112 1 2042937376 23741856 17097488
17:35:58 4611 8192000000 10964822672 11391275008 2010468960 19.705 100 70 140 1 2056045312 24949552 20626800
17:36:10 4496 8192000000 10973506064 11399266304 2014690784 19.738 100 68 135 1 2062437776 27342032 20404960
17:36:23 6294 8192000000 10970388208 11399352320 2012682128 19.723 100 62 124 1 2058315312 27462464 18170720
17:36:39 4186 8192000000 10975796080 11402240000 2016176480 19.750 100 63 126 0 2063442896 27445888 19820528
17:36:52 9767 8192000000 10953164368 11389984768 1993285168 19.570 99 52 100 4 2035360496 26561136 15514192
17:37:10 9920 8192000000 10934416528 11369754624 1952319216 19.245 97 54 107 2 1997188720 29009648 15859856
17:37:33 18658 8192000000 10964108224 11394707456 1978533008 19.453 99 57 112 1 2024920656 28774016 17613632
17:38:05 7834 8192000000 10963529008 11393957888 1997821216 19.606 100 64 128 2 2058872880 41790912 19260752
17:38:28 4400 8192000000 10963656832 11388833792 1984205920 19.498 99 61 120 0 2037229312 34657936 18365456
17:38:40 4841 8192000000 10981460176 11405004800 2001694688 19.636 100 77 154 0 2060369376 36075136 22599552
17:38:54 4440 8192000000 10976854448 11403378688 2004534640 19.658 100 64 128 2 2061154144 37351712 19267792
17:39:09 4731 8192000000 10988981728 11412160512 2012183360 19.719 100 76 152 0 2073279712 38059344 23037008
17:39:20 9901 8192000000 10982649456 11416211456 2019987952 19.780 100 77 154 2 2078821648 35553248 23280448
17:39:38 2452 8192000000 11003873488 11424538624 2026287200 19.830 100 77 151 2 2085018752 35138048 23593504
17:39:47 1903 8192000000 11002335120 11420356608 2023852144 19.810 100 83 163 2 2084687568 36005664 24829760
17:39:57 1985 8192000000 11017948528 11431587840 2032421344 19.878 100 91 178 3 2095189168 36237584 26530240
17:40:06 6903 8192000000 10993650816 11415769088 2019387472 19.775 100 71 142 0 2076715760 36007456 21320832
17:40:20 6228 8192000000 10987084112 11409801216 2009783504 19.700 100 77 151 1 2069520864 37057920 22679440
17:40:37 7743 8192000000 10977529040 11407421440 2003161760 19.648 100 60 119 0 2060703664 38543808 18998096
17:40:52 9282 8192000000 10979319456 11410030592 1995713552 19.589 99 69 138 2 2056585840 38914800 21957488
17:41:11 3025 8192000000 11003895104 11423416320 2023978672 19.811 100 86 173 1 2091015984 40056208 26981104
17:41:21 11867 8192000000 10998460656 11426955264 2017913600 19.764 100 73 145 1 2082700816 42107808 22679408
17:41:43 4213 8192000000 11010757184 11435601920 2031265936 19.869 100 82 161 0 2097942368 40986080 25690352
17:41:56 3449 8192000000 11010741632 11436306432 2015575984 19.745 99 66 132 0 2078841040 42138560 21126496
17:42:07 5574 8192000000 11013384544 11438870528 2015712464 19.746 99 73 146 1 2082987664 43473216 23801984
17:42:19 4697 8192000000 11008780688 11436466176 2030690736 19.864 100 79 156 1 2096979376 41154288 25134352
17:42:31 2705 8192000000 11018535248 11442184192 2031996720 19.874 100 78 156 0 2098699584 42346528 24356336
17:42:42 5732 8192000000 11004802448 11438505984 2029157808 19.852 100 73 143 4 2095571744 43526992 22886944
17:43:14 4557 8192000000 11013103264 11436441600 2027724416 19.841 100 78 153 1 2099655664 47744096 24187152
17:43:26 1704 8192000000 11013444192 11440701440 2024448752 19.815 100 79 158 0 2098836000 49754896 24632352
17:43:35 3979 8192000000 11018818048 11444887552 2024367328 19.814 100 71 140 0 2095522192 48995888 22158976
17:43:51 1513 8192000000 11007883200 11430928384 2001329760 19.633 99 80 154 0 2073203504 47230064 24643680
17:44:01 4730 8192000000 10979468272 11406462976 1989653712 19.541 99 66 133 0 2061015088 50044912 21316464
17:44:14 2800 8192000000 10976343072 11389210624 1981084832 19.473 99 83 164 2 2058799824 50237216 27477776
17:44:24 5561 8192000000 10984635584 11399200768 1958183952 19.292 98 77 151 2 2034679264 52482176 24013136
17:44:36 1462 8192000000 10989565984 11400847360 1972039856 19.402 99 83 166 0 2052155456 53901136 26214464
17:44:44 1901 8192000000 10999430832 11412627456 1995709552 19.589 100 86 172 0 2079752752 56538976 27504224
17:44:54 2163 8192000000 10995286320 11410948096 1991927440 19.559 100 87 173 0 2075761648 56375712 27458496
17:45:02 3898 8192000000 10975015328 11407138816 1987538576 19.524 100 71 141 0 2068931616 58888896 22504144
17:45:16 7562 8192000000 10968906416 11399630848 1982684832 19.486 100 53 104 1 2053679152 53816768 17177552
17:45:37 5871 8192000000 10991795440 11422961664 1996795504 19.597 100 60 117 2 2073390624 56896944 19698176
17:45:53 6492 8192000000 10976205072 11398320128 1953485392 19.254 98 65 129 0 2032780656 58391728 20903536
17:46:07 6453 8192000000 10970832896 11399921664 1960421440 19.309 99 62 121 2 2045620816 64750080 20449296
17:46:27 2159 8192000000 10979486336 11394224128 1971465568 19.397 100 67 134 0 2056644992 62569008 22610416
17:46:38 1935 8192000000 10988857408 11401158656 1974398400 19.420 100 84 165 1 2066200320 64377984 27423936
17:46:47 2754 8192000000 10987198560 11400785920 1975863376 19.432 100 89 176 0 2068025600 64491744 27670480
17:46:57 3171 8192000000 10978919728 11389837312 1963428592 19.333 100 84 169 0 2057033648 66550624 27054432
17:47:11 4064 8192000000 10970509232 11396866048 1969055120 19.378 100 66 132 1 2052164944 61284256 21825568
17:47:23 18064 8192000000 10946318512 11400306688 1960835584 19.313 99 47 94 0 2041454112 64409664 16208864
17:47:54 14728 8192000000 10929734992 11369181184 1929011776 19.059 98 39 78 0 1995811408 52870720 13928912
17:48:21 9201 8192000000 10933375760 11380023296 1952246704 19.244 100 43 86 2 2025177536 57171728 15759104
17:48:36 17663 8192000000 10935892752 11367428096 1916269376 18.957 98 41 82 2 1984563968 53828448 14466144
17:49:07 26554 8192000000 10916366816 11364110336 1938847504 19.138 100 33 65 0 2004318544 53254688 12216352
17:49:40 26668 8192000000 10922326992 11367698432 1936706544 19.120 100 31 62 1 2004224736 55801520 11716672
17:50:15 11012 8192000000 10915234768 11364708352 1930714704 19.073 100 32 64 2 2004262864 61542704 12005456
17:50:38 31097 8192000000 10910030576 11361423360 1900422048 18.830 98 34 71 0 1964725856 52897152 11406656
17:51:17 36806 8192000000 10884046384 11351691264 1911800256 18.921 99 23 46 1 1964718960 45122768 7795936
17:52:02 38716 8192000000 10882601744 11341979648 1887010064 18.722 98 15 30 0 1935239040 42584960 5644016
17:52:48 39684 8192000000 10851379408 11316965376 1843865024 18.372 96 18 36 1 1886085584 36405536 5815024
17:53:35 83535 8192000000 10814619392 11275059200 1809529952 18.092 95 16 32 1 1830005440 16159072 4316416
17:55:20 117664 8192000000 10851060944 11313864704 1895175216 18.787 99 25 50 2 1909960992 8254336 6531440
17:57:43 41145 8192000000 10858010432 11325833216 1937001344 19.123 100 15 30 0 1947358032 6669920 3686768
17:58:36 58179 8192000000 10872834256 11339567104 1935223136 19.109 99 11 22 1 1949148128 10693472 3231520
17:59:40 88645 8192000000 10884971840 11351531520 1936260896 19.117 99 17 34 0 1956466352 15274128 4931328
18:01:31 76835 8192000000 10893191280 11366150144 1959845456 19.305 100 15 30 0 1981089072 16494400 4749216
18:02:55 127408 8192000000 10888961904 11368374272 1971042320 19.394 100 18 36 0 1990700128 14226864 5430944
18:05:20 45606 8192000000 10877035024 11352952832 1925851184 19.034 98 12 24 0 1938723936 9972192 2900560
18:06:14 50805 8192000000 10887281360 11345682432 1906540896 18.879 97 24 48 0 1924047808 10699312 6807600
18:07:29 64136 8192000000 10881670096 11358498816 1958751456 19.296 100 15 30 2 1977182544 14168128 4262960
18:08:40 42067 8192000000 10885246816 11358994432 1960594112 19.311 100 7 14 0 1977150192 14421552 2134528
18:09:28 45669 8192000000 10879738512 11361370112 1940563760 19.151 99 16 30 4 1963631056 18638704 4428592
18:10:37 32547 8192000000 10885398912 11359293440 1941347184 19.158 99 12 24 1 1958749248 14242096 3159968
18:11:16 42162 8192000000 10915825040 11363794944 1950701024 19.232 99 14 28 1 1965843488 11697472 3444992
18:12:06 106632 8192000000 10908519024 11389419520 1963750352 19.336 99 17 34 0 1982560432 13960096 4849984
18:14:01 31103 8192000000 10921586288 11371745280 1947435712 19.206 98 29 56 1 1967611600 11900176 8275712
18:14:42 52226 8192000000 10917644384 11390025728 1981308128 19.475 100 34 67 2 2007755696 17183072 9264496
18:15:41 45877 8192000000 10918373168 11394281472 1985557296 19.509 100 31 62 1 2007859024 13728544 8573184
18:16:36 54395 8192000000 10914764224 11370373120 1945629360 19.192 98 16 32 0 1957617232 7980288 4007584
18:17:43 22190 8192000000 10930759552 11381796864 1969683440 19.383 99 33 66 0 1990080640 11312784 9084416
18:18:16 33230 8192000000 10929137376 11391078400 1987918560 19.527 100 41 82 2 2018209712 19117104 11174048
18:18:56 94015 8192000000 10924444512 11406340096 1991104016 19.553 100 23 46 0 2017188720 19138896 6945808
18:20:36 33080 8192000000 10952098816 11386466304 1961344272 19.317 98 57 114 0 1989382928 11244304 16794352
18:21:18 7348 8192000000 10943842464 11389558784 1990280272 19.546 100 50 100 3 2013424912 9742256 13402384
18:21:35 14143 8192000000 10947504720 11389247488 1971832944 19.400 99 51 102 0 1997453312 11697168 13923200
18:21:56 12021 8192000000 10939342224 11382657024 1983970064 19.496 100 51 102 1 2011339312 13138896 14230352
18:22:17 38188 8192000000 10939476944 11382226944 1973566816 19.414 99 48 96 3 1999774320 13106272 13101232
18:23:12 96229 8192000000 10895958608 11368706048 1945266944 19.189 98 25 50 0 1961809072 9460352 7081776
18:24:55 27971 8192000000 10885422880 11356835840 1934989840 19.107 98 29 58 1 1951902368 8520256 8392272
18:25:47 66299 8192000000 10869923024 11349651456 1933672624 19.096 98 12 24 0 1945779504 8489520 3617360
18:28:36 50277 8192000000 10908313648 11374391296 1941477280 19.159 98 16 32 0 1951586608 5919168 4190160
18:29:34 37409 8192000000 10906252016 11375747072 1944503344 19.183 98 15 30 1 1958006576 9605680 3897552
18:30:18 59679 8192000000 10921486272 11401854976 1988782240 19.534 100 19 38 1 2009736752 15414848 5539664
18:31:27 62578 8192000000 10891878720 11368042496 1904134304 18.860 96 14 28 0 1923353536 15236976 3982256
18:32:57 56885 8192000000 10891398304 11371847680 1931824864 19.081 98 18 36 1 1946572240 9378016 5369360
18:34:40 81047 8192000000 10899684720 11374419968 1914159952 18.940 97 21 42 0 1940851872 20395536 6296384
18:36:08 59347 8192000000 10884422160 11355512832 1917486448 18.967 98 9 18 1 1940675744 20471680 2717616
18:37:15 21118 8192000000 10882318288 11339243520 1900112464 18.827 97 39 78 0 1919298576 8399312 10786800
18:37:42 55129 8192000000 10881431904 11339874304 1860294816 18.506 96 15 30 2 1874188384 9778192 4115376
18:38:44 48699 8192000000 10874570208 11333087232 1866812672 18.558 96 31 60 3 1892852080 17751200 8288208
18:39:44 106273 8192000000 10860325872 11324518400 1792206432 17.950 92 20 40 1 1807288096 9904560 5177104
18:41:39 51009 8192000000 10855272160 11303153664 1796327264 17.984 93 40 78 3 1817102496 10331248 10443984
18:42:37 133420 8192000000 10834720240 11307114496 1843640240 18.370 96 14 28 0 1861163888 13725376 3798272
18:44:57 81735 8192000000 10849450672 11313287168 1854073184 18.455 96 17 34 0 1871586752 12926544 4587024
18:46:25 35702 8192000000 10844830096 11320111104 1921394352 18.998 100 13 26 1 1942124928 16823472 3907104
18:47:07 18815 8192000000 10852613504 11334950912 1927379008 19.046 100 9 18 1 1949880544 19875232 2626304
18:47:35 13378 8192000000 10856838896 11339882496 1930703088 19.072 100 7 14 0 1951389696 18922944 1763664
18:47:56 77496 8192000000 10854327488 11328843776 1893406416 18.773 98 6 12 1 1913573536 18345296 1821824
18:49:20 26419 8192000000 10846792608 11334189056 1921716432 19.001 100 4 8 0 1943184480 20600400 867648
18:49:52 17354 8192000000 10826301152 11293679616 1847774720 18.404 96 8 16 1 1860113632 9845424 2493488
18:50:18 58238 8192000000 10853202944 11314343936 1919391968 18.982 100 26 52 2 1932810992 6012672 7406352
18:51:23 92546 8192000000 10857403824 11335839744 1874149616 18.618 97 16 33 1 1890033456 10662112 5221728
18:53:01 60023 8192000000 10849698896 11331923968 1914930912 18.946 99 5 10 0 1931101856 14635648 1535296
18:54:09 29033 8192000000 10870358032 11318210560 1911319888 18.917 99 36 74 1 1936361408 15103968 9937552
18:54:53 56478 8192000000 10841526384 11316154368 1895896480 18.793 98 25 50 0 1912011184 9118064 6996640
18:55:56 47980 8192000000 10878214144 11338567680 1906251760 18.877 98 21 42 0 1927084080 14630752 6201568
18:56:59 31196 8192000000 10893289488 11353788416 1950742496 19.232 100 26 52 1 1973533696 15279376 7511824
18:57:44 55434 8192000000 10881214576 11352252416 1898352192 18.813 97 15 30 0 1919738144 17032176 4353776
18:58:47 92563 8192000000 10873102448 11338551296 1913316144 18.933 98 9 18 0 1930337920 14795104 2226672
19:00:26 38305 8192000000 10912617248 11365392384 1944391248 19.182 99 26 52 1 1965093152 13770128 6931776
19:01:19 48772 8192000000 10918507872 11385794560 1972068848 19.402 100 34 68 0 2003570992 22207840 9294304
19:02:21 44535 8192000000 10913691120 11384643584 1976155696 19.434 100 23 46 0 1997665472 15146304 6363472
19:03:13 45485 8192000000 10911805680 11372146688 1938997024 19.139 98 19 38 0 1955966576 11400288 5569264
19:04:09 33777 8192000000 10937398320 11382910976 1964521984 19.342 99 55 108 1 1990126768 9767232 15837552
19:04:52 31360 8192000000 10924545536 11388018688 1982165616 19.482 100 44 88 0 2009809664 15319136 12324912
19:05:34 157421 8192000000 10899086528 11366481920 1924508864 19.023 97 13 26 3 1940649200 12351360 3788976
19:08:25 102851 8192000000 10911307808 11390242816 1965192592 19.347 99 33 67 1 1985983280 11327840 9462848
19:11:31 49514 8192000000 10902953888 11385864192 1963605344 19.335 99 12 25 0 1976950000 10501888 2842768
19:14:04 51663 8192000000 10918491472 11396116480 1967735792 19.367 99 13 26 1 1989497152 17626160 4135200
19:15:18 128493 8192000000 10906083328 11387920384 1963615952 19.335 99 13 26 1 1985727424 18181744 3929728
19:17:33 62503 8192000000 10903276432 11384455168 1925710272 19.033 97 20 40 0 1944968896 13958560 5300064
19:18:43 102862 8192000000 10884855216 11355410432 1877594384 18.646 95 13 26 0 1898184432 16765488 3824560
19:21:03 52356 8192000000 10891595584 11384549376 1962875744 19.329 100 9 18 1 1987654144 21534752 3243648
19:22:03 139170 8192000000 10887407040 11355512832 1819272512 18.172 92 9 18 0 1835429232 13621840 2534880
19:24:31 140842 8192000000 10880437488 11355598848 1839016432 18.333 94 18 36 0 1856410800 12461312 4933056
19:26:58 19649 8192000000 9345008288 9616146432 493489184 5.681 26 2 4 0 496667344 2711264 466896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 14-01-2021 19:27:59 to 14-01-2021 19:28:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 128 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-01-2021 19:28:29 to 14-01-2021 19:28:31.

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          235875
MON$OLDEST_ACTIVE               235876
MON$OLDEST_SNAPSHOT             235876
MON$NEXT_TRANSACTION            235876
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                       2007808
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 ---
:915: 
:916: mscs-test-161.budzdorov.ru    Thu Jan 14 19:27:19 2021
:917:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:918: 
:919: 
:920: mscs-test-161.budzdorov.ru    Thu Jan 14 19:27:19 2021
:921:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:922: 
:923: 
:924: mscs-test-161.budzdorov.ru    Thu Jan 14 19:27:19 2021
:925:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:926: 
--- end of diff output ---

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

14.01.21 19:28:32. 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-14 19:28:35 No severe PSQL-related problems occured
14.01.21 19:28:36. End of report.