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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-30 16:27:27
DTS_END                         2021-03-30 16:27:27.7030
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39512
TRN_ID                          242248
ATT_ID                          722
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: 9013.63 20534 1081636
customer order: creation 177.68 354 21321
customer order: refuse 15.13 343 1816
order to supplier: creation 46.83 1341 5619
order to supplier: removal 3.22 98590 386
invoice (draft): creation 47.07 3377 5648
invoice (draft): removal 51.10 737 6132
invoice accept: apply 42.40 18912 5088
invoice accept: cancel 46.21 853 5545
customer reserve: creation 3778.58 195 453430
customer reserve: removal 4508.01 55 540961
realization accept: apply 85.18 195 10222
realization accept: cancel 77.84 113 9341
payment from customer: creation 62.74 123 7529
payment from customer: removal 5.51 73 661
payment to supplier: creation 50.08 129 6010
payment to supplier: removal 3.78 84 454
service: total inventory turnovers 4.47 1375 537
service: total monetary turnovers 6.90 25 828
service: aggregate perf. data 0.87 20073 104
service: refresh index statistics 0.03 263723 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-03-2021 16:29:51 to 30-03-2021 16:29:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8775
TEST_TIME 2 6925
TEST_TIME 3 8108
TEST_TIME 4 7159
TEST_TIME 5 7573
TEST_TIME 6 7481
TEST_TIME 7 7305
TEST_TIME 8 7134
TEST_TIME 9 6892
TEST_TIME 10 6727
TEST_TIME 11 6589
TEST_TIME 12 6457
TEST_TIME 13 6445
TEST_TIME 14 6490
TEST_TIME 15 6571
TEST_TIME 16 6576
TEST_TIME 17 6883
TEST_TIME 18 7081
TEST_TIME 19 7466
TEST_TIME 20 7745
TEST_TIME 21 8115
TEST_TIME 22 8132
TEST_TIME 23 8500
TEST_TIME 24 8679
TEST_TIME 25 8888
TEST_TIME 26 9027
TEST_TIME 27 9138
TEST_TIME 28 9312
TEST_TIME 29 9734
TEST_TIME 30 9784
TEST_TIME 31 9834
TEST_TIME 32 9866
TEST_TIME 33 10197
TEST_TIME 34 10172
TEST_TIME 35 10055
TEST_TIME 36 9814
TEST_TIME 37 9749
TEST_TIME 38 9817
TEST_TIME 39 9686
TEST_TIME 40 9563
TEST_TIME 41 9477
TEST_TIME 42 9475
TEST_TIME 43 9509
TEST_TIME 44 9351
TEST_TIME 45 9395
TEST_TIME 46 9396
TEST_TIME 47 9245
TEST_TIME 48 9367
TEST_TIME 49 9291
TEST_TIME 50 9164
TEST_TIME 51 9197
TEST_TIME 52 9128
TEST_TIME 53 9030
TEST_TIME 54 8921
TEST_TIME 55 8853
TEST_TIME 56 8845
TEST_TIME 57 8875
TEST_TIME 58 8819
TEST_TIME 59 8809
TEST_TIME 60 8789
TEST_TIME 61 8738
TEST_TIME 62 8872
TEST_TIME 63 8930
TEST_TIME 64 8972
TEST_TIME 65 9066
TEST_TIME 66 9022
TEST_TIME 67 9102
TEST_TIME 68 9156
TEST_TIME 69 9097
TEST_TIME 70 9177
TEST_TIME 71 9205
TEST_TIME 72 9231
TEST_TIME 73 9177
TEST_TIME 74 9077
TEST_TIME 75 9050
TEST_TIME 76 9045
TEST_TIME 77 9059
TEST_TIME 78 9030
TEST_TIME 79 8982
TEST_TIME 80 8956
TEST_TIME 81 8908
TEST_TIME 82 8910
TEST_TIME 83 8884
TEST_TIME 84 8881
TEST_TIME 85 8871
TEST_TIME 86 8911
TEST_TIME 87 8936
TEST_TIME 88 8955
TEST_TIME 89 9037
TEST_TIME 90 9003
TEST_TIME 91 9029
TEST_TIME 92 9041
TEST_TIME 93 9050
TEST_TIME 94 9061
TEST_TIME 95 9141
TEST_TIME 96 9142
TEST_TIME 97 9148
TEST_TIME 98 9088
TEST_TIME 99 9042
TEST_TIME 100 9003
TEST_TIME 101 8993
TEST_TIME 102 8998
TEST_TIME 103 9001
TEST_TIME 104 8984
TEST_TIME 105 8983
TEST_TIME 106 8967
TEST_TIME 107 8935
TEST_TIME 108 8940
TEST_TIME 109 8980
TEST_TIME 110 8958
TEST_TIME 111 8936
TEST_TIME 112 8968
TEST_TIME 113 9059
TEST_TIME 114 9025
TEST_TIME 115 9009
TEST_TIME 116 9025
TEST_TIME 117 8999
TEST_TIME 118 9093
TEST_TIME 119 9088
TEST_TIME 120 9028

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-03-2021 16:29:54 to 30-03-2021 16: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 1503507 1503507 0 0.00 0 16629 7 0 0
doc_list_biud 1503503 1503503 0 0.00 0 22765 26 0 0
sp_add_invoice_to_stock 5189 5088 101 1.94 25 244357 18913 0 101
sp_cancel_adding_invoice 5545 5545 0 0.00 3 95300 853 0 0
sp_cancel_client_order 1816 1816 0 0.00 4 12532 344 0 0
sp_cancel_customer_reserve 540961 540961 0 0.00 1 22767 56 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 2 3747 74 0 0
sp_cancel_pay_to_supplier 454 454 0 0.00 3 3287 84 0 0
sp_cancel_supplier_invoice 6140 6132 8 0.13 1 13925 737 0 8
sp_cancel_supplier_order 386 386 0 0.00 6 787109 98591 0 0
sp_cancel_write_off 9341 9341 0 0.00 1 9136 113 0 0
sp_client_order 21321 21321 0 0.00 3 17919 355 0 0
sp_customer_reserve 453430 453430 0 0.00 0 46046 195 0 0
sp_fill_shopping_cart 32573 32573 0 0.00 1 15267 39 0 0
sp_fill_shopping_cart_clo_res 453409 453409 0 0.00 0 18896 15 0 0
sp_get_clo_for_invoice 5063 5063 0 0.00 0 21110 303 0 0
sp_kill_cost_storno 16001 16001 0 0.00 0 6955 55 0 0
sp_kill_qstorno_ret_qs2qd 1097781 1097781 0 0.00 0 22763 30 0 0
sp_kill_qty_storno 579466 579466 0 0.00 0 22765 66 0 0
sp_lock_selected_doc 21187 21187 0 0.00 0 7139 4 0 0
sp_make_cost_storno 28824 28824 0 0.00 0 11209 61 0 0
sp_multiply_rows_for_pdistr 28824 28824 0 0.00 0 6950 29 0 0
sp_multiply_rows_for_qdistr 21320 21320 0 0.00 0 13707 156 0 0
sp_pay_from_customer 7529 7529 0 0.00 4 14567 123 0 0
sp_pay_to_supplier 6010 6010 0 0.00 5 11480 130 0 0
sp_payment_common 13538 13538 0 0.00 1 9809 31 0 0
sp_qd_handle_on_cancel_clo 1816 1816 0 0.00 0 12526 311 0 0
sp_qd_handle_on_invoice_upd_sts 10608 10608 0 0.00 0 16682 320 0 0
sp_qd_handle_on_reserve_upd_sts 10222 10222 0 0.00 0 13000 64 0 0
sp_reserve_write_off 10222 10222 0 0.00 6 13693 196 0 0
sp_supplier_invoice 5648 5648 0 0.00 6 65987 3378 0 0
sp_supplier_order 5619 5619 0 0.00 4 50293 1342 0 0
srv_aggregate_perf_data 104 104 0 0.00 2950 335456 20074 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1107 130243 31539 0 0
srv_find_qd_qs_mism 1034172 1034172 0 0.00 0 16628 6 0 0
srv_make_invnt_saldo 537 537 0 0.00 30 75691 1376 0 0
srv_make_money_saldo 828 828 0 0.00 0 2532 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 79772 541051 263723 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5089 5089 0 0.00 0 19611 160 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 2876 88 0 0
t$perf-norm:sp_cancel_client_order 1816 1816 0 0.00 0 8272 18 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 2570 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 505 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 454 454 0 0.00 0 13791 34 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 3777 21 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 22810 1738 0 0
t$perf-norm:sp_cancel_write_off 1063 1063 0 0.00 0 888 5 0 0
t$perf-norm:sp_client_order 21321 21321 0 0.00 0 16871 19 0 0
t$perf-norm:sp_customer_reserve 1105 1105 0 0.00 0 1268 6 0 0
t$perf-norm:sp_pay_from_customer 7529 7529 0 0.00 0 10687 10 0 0
t$perf-norm:sp_pay_to_supplier 6010 6010 0 0.00 0 4241 8 0 0
t$perf-norm:sp_reserve_write_off 10222 10222 0 0.00 0 10967 11 0 0
t$perf-norm:sp_supplier_invoice 5648 5648 0 0.00 0 17010 21 0 0
t$perf-norm:sp_supplier_order 5619 5619 0 0.00 0 8798 20 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 191 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 430 7 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 2584 36 0 0
t$perf-norm:srv_make_money_saldo 828 828 0 0.00 0 2392 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 5 0 0
v_add_invoice_to_stock 10328 10126 202 1.95 0 4330 18 0 202
v_all_customers 39304 39304 0 0.00 0 20 1 0 0
v_all_suppliers 30842 30842 0 0.00 0 17 1 0 0
v_all_wares 42640 42640 0 0.00 0 71 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 597 6 0 0
v_cancel_client_order 3632 3632 0 0.00 0 7042 9 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 3714 10 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 788 4 0 0
v_cancel_payment_to_supplier 908 908 0 0.00 0 3280 11 0 0
v_cancel_supplier_invoice 884 868 16 1.80 0 1576 15 0 16
v_cancel_supplier_order 772 772 0 0.00 0 2024 8 0 0
v_cancel_write_off 2126 2126 0 0.00 0 9128 21 0 0
v_max_id_clo_ord 5612 5612 0 0.00 0 111 1 0 0
v_max_id_clo_res 1105 1105 0 0.00 0 1962 10 0 0
v_max_id_ord_sup 5640 5640 0 0.00 0 4176 4 0 0
v_max_non_paid_invoice 1841 1841 0 0.00 0 538 2 0 0
v_max_non_paid_realizn 3900 3900 0 0.00 0 1161 3 0 0
v_min_id_clo_ord 5612 5612 0 0.00 0 3317 7 0 0
v_min_id_clo_res 1105 1105 0 0.00 0 5040 13 0 0
v_min_id_ord_sup 5640 5640 0 0.00 0 8037 10 0 0
v_min_non_paid_invoice 6010 6010 0 0.00 0 4891 20 0 0
v_min_non_paid_realizn 7528 7528 0 0.00 0 6709 21 0 0
v_our_firm 10592 10592 0 0.00 0 135 1 0 0
v_reserve_write_off 20444 20444 0 0.00 0 3745 7 0 0
x_lock_depdocs_on_canc_invoice 11243 11243 0 0.00 0 16309 111 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 13421 350 0 0
x_make_qstorno_1000_1200 5619 5619 0 0.00 1 50282 1266 0 0
x_make_qstorno_1200_2000 5648 5648 0 0.00 3 65975 3235 0 0
x_make_qstorno_2100_3300 453430 453430 0 0.00 0 45133 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2021 16:29:59 to 30-03-2021 16: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
13:57:30 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:36 23040 8192000000 10273640464 10585272320 916945536 10.066 71 51 104 0 935778608 2420656 16412416
13:58:08 24956 8192000000 10364742560 10681794560 1411664976 14.699 100 90 180 0 1446075328 5552720 28857632
13:58:46 9095 8192000000 10377389312 10699149312 1435703984 14.912 100 89 178 0 1471973776 7216592 29053200
13:59:05 23412 8192000000 10399285520 10725498880 1448623536 15.026 100 87 175 0 1484367712 7503808 28240368
13:59:41 24002 8192000000 10418385632 10748473344 1468778880 15.203 100 87 174 1 1505340688 8444384 28117424
14:00:16 20667 8192000000 10426543664 10759118848 1485172608 15.347 100 87 174 0 1522484576 8856960 28455008
14:00:46 33114 8192000000 10463457696 10800582656 1505181216 15.521 100 82 162 2 1540518848 9277440 26060192
14:01:28 18813 8192000000 10470626048 10816258048 1527313328 15.714 100 79 156 1 1561961744 9565824 25082592
14:02:00 17516 8192000000 10501356496 10850701312 1559708656 15.994 100 78 156 1 1594041920 10073168 24260096
14:02:30 11951 8192000000 10532215136 10888781824 1589708272 16.251 100 69 138 0 1620678208 10278128 20691808
14:02:55 12767 8192000000 10565732320 10925043712 1622039504 16.527 100 79 158 1 1656527712 10592960 23895248
14:03:18 10977 8192000000 10581568304 10944122880 1642025200 16.697 100 81 162 0 1677153008 10971792 24156016
14:03:39 14230 8192000000 10608916320 10978430976 1660312912 16.852 100 78 155 2 1694324912 10708064 23303936
14:04:01 9351 8192000000 10634125360 11002281984 1689816128 17.100 100 80 158 3 1724254480 11057152 23381200
14:04:18 7389 8192000000 10654943840 11023433728 1708536864 17.257 100 83 166 0 1744802976 12206544 24059568
14:04:33 8856 8192000000 10668079488 11036753920 1719031328 17.344 100 86 173 0 1757159536 13499936 24628272
14:04:49 8809 8192000000 10681311760 11052974080 1732499616 17.456 100 79 158 1 1768424736 13747344 22177776
14:05:05 6264 8192000000 10681111280 11054333952 1745153024 17.561 100 84 168 1 1783004560 14419152 23432384
14:05:18 4941 8192000000 10691862080 11068014592 1749654368 17.599 100 79 158 0 1785602384 13925072 22022944
14:05:30 5984 8192000000 10704263296 11081945088 1764999472 17.726 100 81 163 0 1802226272 13677584 23549216
14:05:43 2978 8192000000 10704506080 11082407936 1773772288 17.798 100 80 157 2 1808935600 13174192 21989120
14:05:52 4782 8192000000 10717377904 11094867968 1778283728 17.835 100 88 176 1 1817956000 14266752 25405520
14:06:04 3495 8192000000 10721474592 11107008512 1784817696 17.889 100 83 164 4 1821079872 13248432 23013744
14:06:15 2726 8192000000 10735391392 11117568000 1795222496 17.975 100 85 169 1 1831385104 13046096 23116512
14:06:24 4521 8192000000 10745155808 11126009856 1804804960 18.053 100 82 164 3 1839041728 10888352 23348416
14:06:36 2528 8192000000 10746158160 11128799232 1807344576 18.074 100 86 171 1 1842386624 10546032 24496016
14:06:45 7309 8192000000 10745788272 11133014016 1813339776 18.123 100 74 145 1 1845091872 11035808 20716288
14:06:59 3085 8192000000 10769636432 11157168128 1826098624 18.227 100 83 165 2 1861159584 11809664 23251296
14:07:09 2836 8192000000 10781079680 11165642752 1838015184 18.325 100 87 174 0 1875569808 13106128 24448496
14:07:18 1927 8192000000 10781371472 11168075776 1839316608 18.335 100 88 176 0 1878822816 14119984 25386224
14:07:26 2866 8192000000 10790568096 11179950080 1848513152 18.410 100 88 176 0 1887006176 13885568 24607456
14:07:35 2175 8192000000 10795417024 11182419968 1852930512 18.446 100 96 192 3 1893590992 13355632 27304848
14:07:44 2598 8192000000 10790504736 11183427584 1858225408 18.489 100 90 180 1 1897631040 13698336 25707296
14:07:53 2133 8192000000 10797595296 11187769344 1857022432 18.479 100 89 181 1 1896761296 13662512 26076352
14:08:02 1735 8192000000 10805677312 11195559936 1865237120 18.546 100 92 186 0 1904098160 13044512 25816528
14:08:11 1642 8192000000 10806711136 11198947328 1866741056 18.558 100 93 186 0 1906645216 13582064 26322096
14:08:19 1465 8192000000 10811321840 11202572288 1870509184 18.588 100 92 184 1 1910297984 13929696 25859104
14:08:27 2156 8192000000 10822836896 11212095488 1878735424 18.655 100 87 172 3 1915715840 12225456 24754960
14:08:35 11132 8192000000 10812652688 11208613888 1876695168 18.638 100 68 134 1 1907778832 12224144 18859520
14:08:53 6336 8192000000 10815407520 11215216640 1876929280 18.640 100 65 130 4 1905504080 11065248 17509552
14:09:06 2229 8192000000 10813850064 11217190912 1881688464 18.679 100 68 136 1 1913033072 12405536 18939072
14:09:15 3345 8192000000 10798992800 11216097280 1879185584 18.659 100 54 108 1 1905629648 11483760 14960304
14:09:26 3026 8192000000 10803461184 11215867904 1883657296 18.695 100 63 127 1 1912307152 10686656 17963200
14:09:39 5282 8192000000 10817586128 11220860928 1883778944 18.696 100 64 128 1 1913104272 11702256 17623072
14:09:50 3287 8192000000 10793152640 11214843904 1879740656 18.663 100 47 94 1 1902649984 9811856 13097472
14:10:01 9088 8192000000 10789754928 11215970304 1877742336 18.647 100 36 72 0 1896590688 9051120 9797232
14:10:19 3928 8192000000 10803425520 11223511040 1887833984 18.728 100 46 92 0 1913664592 11789248 14041360
14:10:31 46879 8192000000 10815812944 11232034816 1879519040 18.661 100 21 42 0 1891160112 5526864 6114208
14:11:24 15380 8192000000 10827068416 11237384192 1889973952 18.746 100 54 109 0 1915721488 9270832 16476704
14:11:46 10370 8192000000 10800034688 11236323328 1884782992 18.704 100 28 56 1 1898739792 6466160 7490640
14:12:03 7823 8192000000 10801930992 11230646272 1886887568 18.721 100 35 68 1 1903856496 7060400 9908528
14:12:18 9267 8192000000 10797390432 11230322688 1887403792 18.725 100 21 42 1 1899595872 5970144 6221936
14:12:35 9757 8192000000 10796976112 11234365440 1887536176 18.726 100 21 41 3 1899348512 6078592 5733744
14:12:53 6877 8192000000 10809829504 11239800832 1892314896 18.764 100 31 62 2 1907649840 6919424 8415520
14:13:06 5365 8192000000 10802810384 11236192256 1895258960 18.788 100 25 50 1 1908448160 6338848 6850352
14:13:21 8889 8192000000 10806991152 11240706048 1893782272 18.776 100 20 38 1 1904623088 5807728 5033088
14:13:38 10443 8192000000 10818431696 11246718976 1900275440 18.829 100 27 54 0 1914092448 5371280 8445728
14:13:57 11573 8192000000 10817881136 11253727232 1903958432 18.858 100 24 48 2 1920874928 10504784 6411712
14:14:17 7993 8192000000 10820502880 11252719616 1903245024 18.852 100 20 40 1 1914794368 6546608 5002736
14:14:33 5691 8192000000 10813337424 11250995200 1903422928 18.854 100 19 38 2 1914846192 5996704 5426560
14:14:48 14474 8192000000 10795936672 11238494208 1878688672 18.655 99 12 24 1 1887540352 5154928 3696752
14:15:09 18732 8192000000 10823536192 11256700928 1901154688 18.836 100 13 26 1 1910027168 4995392 3877088
14:15:34 70716 8192000000 10827777120 11259502592 1894431136 18.781 99 32 62 2 1908731648 5215552 9084960
14:16:53 6343 8192000000 10819370256 11256156160 1894935136 18.786 99 25 51 1 1909062080 6249200 7877744
14:17:09 6937 8192000000 10827069328 11258990592 1907090064 18.883 100 19 37 0 1917919696 5781456 5048176
14:17:25 6703 8192000000 10819742800 11253100544 1886552736 18.718 99 22 44 1 1899571600 6915584 6103280
14:17:39 4137 8192000000 10838551648 11268399104 1910025920 18.907 100 32 64 2 1930513360 11882800 8604640
14:17:50 5422 8192000000 10812940736 11244564480 1896492224 18.798 100 26 53 2 1910342592 6664432 7185936
14:18:06 5294 8192000000 10751204928 11179606016 1795942896 17.981 95 26 53 1 1814245616 10133984 8168736
14:18:18 6121 8192000000 10773705376 11212263424 1868661328 18.573 100 27 54 1 1883242016 6451408 8129280
14:18:31 6139 8192000000 10762870256 11191164928 1837823536 18.323 99 20 39 2 1849550464 6145312 5581616
14:18:47 8022 8192000000 10766633760 11195392000 1816120192 18.146 97 16 32 1 1826377472 5629216 4628064
14:19:01 8711 8192000000 10769422032 11191730176 1803422256 18.042 97 16 32 1 1813749408 5242624 5084528
14:19:18 8492 8192000000 10774136480 11197743104 1819600288 18.174 98 18 36 0 1830411184 5523632 5287264
14:19:36 7661 8192000000 10735316224 11158470656 1753246240 17.628 95 24 49 1 1765871392 5545888 7079264
14:19:54 11978 8192000000 10735981664 11163160576 1796988320 17.989 98 19 38 1 1807978704 5428624 5561760
14:20:13 15339 8192000000 10721232608 11128610816 1746118896 17.569 96 25 49 1 1760720208 5318048 9283264
14:20:34 63774 8192000000 10690636416 11115913216 1740984336 17.527 96 29 57 2 1753922848 4743312 8195200
14:21:46 9598 8192000000 10706217856 11116552192 1688856880 17.092 93 32 64 1 1704112208 6404640 8850688
14:22:03 4264 8192000000 10719677040 11138084864 1794454320 17.968 99 33 65 5 1810552768 6640432 9458016
14:22:17 8664 8192000000 10727512688 11134996480 1733307936 17.463 96 22 44 1 1745835216 6282176 6245104
14:22:33 4685 8192000000 10697728576 11108274176 1741616624 17.532 97 42 82 1 1759123216 5968832 11537760
14:22:45 8799 8192000000 10721592912 11134197760 1770288960 17.769 98 28 56 0 1784531104 6188432 8053712
14:23:01 6985 8192000000 10710113552 11128483840 1768666704 17.756 98 21 43 2 1779693504 4917072 6109728
14:23:16 9344 8192000000 10722649904 11149565952 1814769584 18.135 100 15 28 2 1824290880 5214496 4306800
14:23:32 6024 8192000000 10732023120 11163463680 1828924608 18.251 100 34 68 2 1844923792 5656048 10343136
14:23:48 8325 8192000000 10744378160 11169984512 1831040496 18.268 100 21 42 1 1843036432 6551776 5444160
14:24:07 9940 8192000000 10745910864 11176448000 1838958416 18.332 100 25 50 0 1852159424 6636384 6564624
14:24:24 13505 8192000000 10767264992 11186577408 1828455856 18.247 99 23 46 2 1840413312 5684480 6272976
14:24:47 9184 8192000000 10767225920 11187978240 1844845984 18.380 100 19 38 2 1855498224 5652352 4999888
14:25:02 11453 8192000000 10764596624 11183484928 1848206736 18.408 100 33 64 1 1864337328 5431920 10698672
14:25:23 75457 8192000000 10761982576 11192147968 1852848960 18.445 100 38 76 1 1869230944 5120448 11261536
14:26:44 9038 8192000000 10780517136 11203493888 1857097392 18.480 100 30 60 1 1872586960 6759232 8730336
14:27:02 8747 8192000000 10783253824 11209625600 1864187040 18.537 100 23 46 0 1875832064 5096864 6548160
14:27:19 5080 8192000000 10799762992 11215859712 1861045104 18.512 99 35 70 2 1876131168 6476960 8609104
14:27:33 12394 8192000000 10821504432 11230912512 1880098624 18.666 100 50 100 1 1901042112 6634176 14309312
14:27:53 21069 8192000000 10830295712 11238535168 1893498544 18.774 100 65 130 0 1921521664 9199280 18823840
14:28:22 15832 8192000000 10838818704 11252703232 1902371936 18.845 100 69 139 2 1932942960 10261312 20309712
14:28:46 6133 8192000000 10852976272 11264602112 1911288368 18.917 100 76 150 3 1944191696 10742592 22160736
14:29:03 4500 8192000000 10842128976 11261059072 1910288224 18.909 100 57 113 1 1937133600 10792528 16052848
14:29:15 15029 8192000000 10836246560 11262791680 1911090368 18.915 100 41 82 2 1931672992 8747952 11834672
14:29:39 5999 8192000000 10851802960 11272282112 1920409216 18.990 100 61 122 0 1948135536 9898560 17827760
14:29:54 24263 8192000000 10855255584 11275120640 1927245808 19.045 100 53 101 4 1952306576 10760352 14300416
14:30:25 17993 8192000000 10849830464 11281526784 1925706384 19.033 100 36 72 0 1945935392 9610096 10618912
14:31:21 15264 8192000000 10861261664 11291435008 1929663504 19.064 100 41 81 1 1950498208 9026832 11807872
14:31:49 9167 8192000000 10867956816 11294744576 1933841312 19.098 100 45 90 1 1957341504 10299776 13200416
14:32:13 26733 8192000000 10866726480 11296972800 1919871312 18.986 99 45 90 1 1942884256 10566784 12446160
14:32:49 6437 8192000000 10881213472 11303985152 1941220576 19.156 100 59 117 1 1968746256 10496752 17028928
14:33:03 16160 8192000000 10896065216 11318968320 1950401408 19.230 100 60 120 1 1981361120 13351792 17607920
14:33:27 5008 8192000000 10889159104 11313713152 1935431072 19.110 99 63 124 4 1964975696 11787568 17757056
14:33:46 12329 8192000000 10897008672 11324682240 1955693184 19.272 100 63 125 2 1986384880 12690992 18000704
14:34:07 6265 8192000000 10906751840 11331997696 1961836464 19.321 100 57 114 1 1992716752 14526064 16354224
14:34:22 39651 8192000000 10898631696 11333652480 1965252992 19.348 100 51 102 1 1993791632 14287696 14250944
14:35:11 21306 8192000000 10900355184 11338903552 1967041648 19.362 100 46 92 2 1994818128 14305840 13470640
14:35:41 11157 8192000000 10892407920 11336544256 1962382688 19.325 100 39 78 0 1988139648 14794608 10962352
14:36:02 14024 8192000000 10880952288 11319721984 1936622672 19.120 99 46 90 3 1962405824 12703056 13080096
14:36:31 11889 8192000000 10896088256 11330650112 1958974592 19.298 100 50 98 0 1986582144 13936832 13670720
14:36:53 11589 8192000000 10907202816 11339411456 1965105264 19.347 100 56 111 0 1996806880 15570272 16131344
14:37:26 34304 8192000000 10903172528 11344388096 1971851872 19.400 100 41 84 2 1997888992 14506944 11530176
14:38:18 24961 8192000000 10882758864 11335364608 1946522128 19.199 99 22 44 0 1966885776 13883856 6479792
14:38:53 3269 8192000000 10910522720 11346436096 1972830176 19.408 100 48 96 1 2001695776 13536720 15328880
14:39:04 5939 8192000000 10903194480 11340443648 1967729264 19.367 100 40 79 1 1994527280 14694096 12103920
14:39:17 10563 8192000000 10898575632 11335872512 1940851312 19.154 98 57 114 1 1972534192 15121200 16561680
14:39:37 11891 8192000000 10907759232 11336482816 1954564832 19.263 99 50 97 1 1986650944 17810768 14275344
14:39:56 11169 8192000000 10923394896 11364167680 1975689856 19.431 100 45 91 4 2007426816 18708688 13028272
14:40:17 3687 8192000000 10900267552 11332997120 1961571296 19.319 99 53 104 3 1994626512 16538560 16516656
14:40:28 5175 8192000000 10927006240 11352924160 1964966864 19.346 99 56 112 1 2000936656 19024304 16945488
14:40:40 4678 8192000000 10914138256 11338522624 1954619440 19.263 99 66 130 2 1994300624 19130688 20550496
14:40:55 2146 8192000000 10927457728 11348557824 1972042320 19.402 100 65 128 3 2011500224 20464496 18993408
14:41:05 2664 8192000000 10930092032 11354005504 1976975152 19.441 100 62 124 2 2015736400 19875728 18885520
14:41:19 1501 8192000000 10930196848 11343470592 1967504912 19.366 100 76 152 1 2011853408 20952784 23395712
14:41:29 9226 8192000000 10926050592 11349442560 1970667776 19.391 100 59 116 0 2009898432 21856864 17373792
14:41:45 4258 8192000000 10919966112 11349000192 1973754624 19.415 100 65 129 2 2015864672 22220944 19889104
14:41:56 4167 8192000000 10941091840 11363295232 1984302656 19.499 100 72 141 1 2028955280 22831920 21820704
14:42:08 13832 8192000000 10941957200 11367612416 1983481696 19.492 100 71 139 2 2029775680 24960080 21333904
14:42:29 2670 8192000000 10960438496 11374391296 1991642576 19.557 100 93 185 0 2044847264 25938064 27266624
14:42:38 3164 8192000000 10939977904 11362963456 1980204336 19.466 100 73 143 2 2027617232 25690544 21722352
14:42:48 3430 8192000000 10925844480 11345309696 1964515248 19.342 99 66 132 0 2010037616 25437296 20085072
14:42:59 4497 8192000000 10940359536 11363504128 1978089792 19.450 100 65 129 0 2024238304 26169552 19978960
14:43:13 4088 8192000000 10953410464 11369439232 1985845360 19.511 100 76 149 3 2036558912 27421904 23291648
14:43:24 2400 8192000000 10953897312 11372072960 1990182208 19.545 100 74 148 0 2041533600 28892000 22459392
14:43:34 8562 8192000000 10954913904 11379982336 1988166544 19.529 100 68 136 3 2040867072 31158816 21541712
14:43:51 6955 8192000000 10952747184 11380523008 1983277776 19.491 100 57 114 1 2030882896 29487808 18117312
14:44:05 11730 8192000000 10923867120 11350818816 1953492496 19.254 99 62 124 1 2000205728 27017360 19695872
14:44:24 2710 8192000000 10937509280 11358937088 1972934656 19.409 100 70 138 1 2023471056 28763056 21773344
14:44:34 5183 8192000000 10933683472 11351425024 1950274560 19.229 99 78 155 1 2005298928 30371808 24652560
14:44:48 5427 8192000000 10921470976 11341991936 1940770960 19.153 99 73 144 1 1993359520 29980384 22608176
14:45:01 9990 8192000000 10917835024 11342503936 1934129872 19.100 99 74 147 2 1989113744 30980832 24003040
14:45:39 6476 8192000000 10917131744 11340312576 1950048688 19.227 100 70 138 3 2002971248 30573680 22348880
14:46:00 5001 8192000000 10918199008 11345698816 1953041248 19.251 100 70 139 1 2006922560 31845552 22035760
14:46:14 4311 8192000000 10899655552 11325276160 1921009488 18.995 99 64 128 0 1979291312 38092384 20189440
14:46:27 2944 8192000000 10915047472 11327885312 1924713776 19.025 99 74 148 0 1982460320 34312976 23433568
14:46:38 2922 8192000000 10924564112 11343736832 1954485872 19.262 100 73 145 1 2007388096 30501968 22400256
14:46:54 3627 8192000000 10925265808 11344035840 1943272320 19.173 99 73 146 3 1994776256 28654464 22849472
14:47:04 1234 8192000000 10924978064 11330940928 1947380800 19.206 100 94 186 0 2004692656 28572304 28739552
14:47:11 3320 8192000000 10908948320 11317948416 1927328656 19.046 99 88 176 0 1984230592 29248912 27653024
14:47:22 3225 8192000000 10893102064 11314565120 1920445968 18.990 99 65 129 1 1970124656 29548352 20130336
14:47:32 3349 8192000000 10922575344 11332960256 1943813568 19.177 100 87 175 2 2001401136 30624208 26963360
14:47:46 2539 8192000000 10903706944 11320037376 1933154880 19.092 100 71 141 1 1984329728 29846768 21328080
14:47:58 4001 8192000000 10893616960 11317002240 1930618320 19.072 100 67 131 0 1979849232 29480880 19750032
14:48:08 4561 8192000000 10904717904 11329568768 1939276176 19.141 100 57 115 0 1985911184 29038000 17597008
14:48:24 2975 8192000000 10885598192 11303043072 1919395712 18.982 99 61 118 3 1966087920 28319872 18372336
14:48:35 7089 8192000000 10881710672 11312365568 1912205664 18.924 99 58 116 0 1961895840 31854384 17835792
14:48:51 16703 8192000000 10864228080 11304845312 1887652592 18.727 98 37 74 2 1928542240 28898288 11991360
14:49:30 4388 8192000000 10889734928 11309285376 1928652400 19.056 100 58 115 4 1971929424 25636800 17640224
14:49:42 1400 8192000000 10917154528 11322900480 1940242048 19.149 100 76 149 1 1989758208 27219072 22297088
14:49:52 1932 8192000000 10909316080 11332890624 1940980448 19.155 100 66 131 1 1991830688 30120928 20729312
14:50:02 9415 8192000000 10900999648 11334537216 1940156704 19.148 100 51 101 3 1988371392 32149856 16064832
14:50:25 12409 8192000000 10877143168 11313860608 1921764480 19.001 99 32 64 3 1962197232 30054976 10377776
14:50:54 13679 8192000000 10902743712 11346919424 1944159200 19.180 100 38 76 1 1995314368 38560112 12595056
14:51:16 13505 8192000000 10901983744 11337871360 1950855392 19.233 100 36 72 1 1992655280 29902560 11897328
14:51:42 16073 8192000000 10898111584 11340546048 1935036896 19.107 99 31 59 4 1974252384 27520576 11694912
14:52:05 15428 8192000000 10901268208 11332116480 1912664304 18.928 98 43 84 0 1950667104 24848320 13154480
14:52:27 18808 8192000000 10896449680 11330039808 1912623056 18.928 98 39 78 3 1948894464 24677664 11593744
14:53:00 6835 8192000000 10900116240 11337965568 1946704832 19.200 100 40 80 0 1987686368 28280096 12701440
14:53:14 10593 8192000000 10909560448 11351465984 1952602640 19.247 100 32 64 0 1993808608 30893696 10312272
14:53:33 6504 8192000000 10912987056 11357478912 1957280464 19.284 100 30 60 1 1998955104 30726064 10948576
14:53:48 14144 8192000000 10908997872 11359817728 1964816064 19.344 100 41 83 1 2008121776 30301472 13004240
14:54:11 18130 8192000000 10905221312 11352219648 1937904528 19.130 99 26 52 1 1979944768 32524096 9516144
14:54:36 20851 8192000000 10905460256 11360026624 1949567936 19.223 100 23 46 2 1989782288 32610912 7603440
14:55:14 12821 8192000000 10916319200 11368529920 1951938720 19.242 100 25 50 0 2000192768 39779552 8474496
14:55:34 16419 8192000000 10917815536 11364503552 1938235472 19.133 99 28 56 2 1986113520 38410320 9467728
14:55:59 28503 8192000000 10904771904 11366920192 1956763120 19.280 100 22 44 1 1994273840 29968864 7541856
14:56:43 13686 8192000000 10909333232 11366551552 1968281728 19.372 100 44 88 2 2008166864 25638752 14246384
14:57:15 30855 8192000000 10910645920 11363536896 1952443344 19.246 99 18 36 0 1980821728 22305984 6072400
14:57:52 37806 8192000000 10899588288 11354890240 1939982256 19.147 99 18 34 1 1969443216 24233376 5227584
14:58:46 25211 8192000000 10923291152 11372163072 1959738144 19.304 100 25 50 1 1999657856 31863424 8056288
14:59:26 28462 8192000000 10902526752 11343814656 1914806480 18.945 97 31 62 1 1948285856 24420656 9058720
15:00:02 23679 8192000000 10866343040 11320418304 1914578864 18.943 98 22 44 1 1939388448 18809872 5999712
15:00:32 52778 8192000000 10905751968 11343777792 1932245136 19.085 99 41 78 0 1960532928 17190464 11097328
15:01:39 2617 8192000000 10919592768 11352051712 1968522400 19.374 100 58 116 2 1998434160 13329680 16582080
15:01:58 41181 8192000000 10876892944 11332554752 1923661584 19.016 98 23 46 0 1940819840 10838736 6319520
15:03:28 128435 8192000000 10896391808 11373862912 1950074224 19.227 99 19 38 1 1971642352 16381744 5186384
15:05:43 70615 8192000000 10899967568 11373387776 1953633744 19.255 99 9 18 0 1970310480 13865456 2811280
15:07:13 1105 8192000000 10912892992 11342356480 1946695488 19.200 98 87 171 5 1979157296 7683728 24778080
15:07:53 78366 8192000000 10902246864 11359866880 1956388832 19.277 99 37 75 1 1982843744 15451248 11003664
15:09:54 68184 8192000000 10905677888 11378163712 1952717168 19.248 99 10 20 0 1969224400 13867248 2639984
15:11:20 55633 8192000000 10936967472 11390132224 1974655184 19.422 99 28 56 1 2000329376 17065376 8608816
15:12:31 82629 8192000000 10925181056 11411660800 1992132704 19.561 100 9 18 1 2016056352 20996672 2926976
15:14:56 50137 8192000000 10934335680 11405963264 1991483888 19.556 100 20 39 2 2022423056 23850000 7089168
15:15:54 91489 8192000000 10916216208 11379625984 1979463120 19.460 99 18 36 1 1998402544 14220592 4718832
15:17:48 53126 8192000000 10939724416 11396689920 1995804944 19.590 100 31 62 0 2015723968 11199600 8719424
15:18:51 50598 8192000000 10911651536 11396829184 1996434080 19.595 100 7 14 0 2008428816 10191728 1803008
15:19:48 57502 8192000000 10923351872 11395178496 2005021648 19.662 100 31 63 1 2020946064 6998768 8925648
15:20:55 68923 8192000000 10953771680 11407577088 2009928096 19.701 100 47 93 0 2031946816 8187280 13831440
15:22:10 58370 8192000000 10954577520 11419242496 2014643952 19.738 100 25 49 1 2036368400 14662848 7061600
15:23:15 55865 8192000000 10924530656 11408060416 1993763232 19.574 99 17 34 0 2014849088 16264304 4821552
15:24:20 48450 8192000000 10917067216 11411931136 1999658752 19.620 100 10 21 0 2015937776 13518064 2760960
15:25:15 32604 8192000000 10903449888 11386597376 1979964368 19.464 99 4 8 0 1990780960 9739040 1077552
15:25:55 33902 8192000000 10911374672 11388116992 1981476544 19.476 99 12 24 1 1991884080 7153440 3254096
15:26:35 45355 8192000000 10924645040 11388047360 1943011456 19.171 97 12 24 0 1956631104 10340320 3279328
15:27:28 56528 8192000000 10915762800 11390611456 1965164976 19.347 98 19 38 1 1984127072 13349232 5612864
15:28:39 76245 8192000000 10912166256 11393355776 1939548144 19.143 97 16 33 1 1964454624 20293184 4613296
15:30:09 74138 8192000000 10897056432 11373457408 1883111808 18.690 95 16 32 0 1902196448 14961216 4123424
15:31:34 79914 8192000000 10886737984 11352027136 1889691488 18.743 96 19 38 1 1910708944 15766880 5250576
15:33:05 34148 8192000000 10898075616 11349504000 1905350928 18.869 97 27 54 0 1921189904 8394608 7444368
15:33:46 24370 8192000000 10871068208 11307577344 1843743056 18.371 94 46 91 1 1865545744 8596464 13206224
15:34:22 20202 8192000000 10863327872 11323617280 1903145600 18.852 98 46 92 0 1930425072 14011040 13268432
15:34:55 72027 8192000000 10823244640 11281346560 1790611376 17.937 93 15 30 2 1811284720 16247296 4426048
15:36:14 97847 8192000000 10860530304 11318751232 1850877200 18.429 96 13 26 0 1868683376 14352720 3453456
15:37:58 86169 8192000000 10870352576 11334070272 1858553136 18.492 96 16 31 0 1875542352 12494208 4495008
15:39:33 50414 8192000000 10858907024 11305000960 1839004928 18.333 95 24 48 1 1855052528 9739936 6307664
15:40:34 81823 8192000000 10865094368 11311198208 1923403520 19.014 100 46 92 1 1945701568 9434976 12863072
15:42:11 106142 8192000000 10853807104 11327246336 1887392624 18.725 97 24 48 0 1908407360 14166432 6848304
15:44:04 39646 8192000000 10855932176 11337039872 1908736368 18.897 99 10 20 3 1929712368 18070256 2905744
15:44:54 50284 8192000000 10837844592 11323482112 1890796384 18.752 98 10 20 1 1909503104 15798368 2908352
15:45:50 9538 8192000000 10861533520 11323531264 1930338096 19.070 100 20 40 2 1947552832 11621520 5593216
15:46:07 49195 8192000000 10857486992 11327242240 1921928432 19.002 99 14 27 1 1936768240 11344400 3495408
15:47:11 59637 8192000000 10848577376 11319173120 1904249328 18.860 98 15 30 0 1916912848 7660816 5002704
15:48:17 58787 8192000000 10844691472 11314323456 1895579072 18.791 98 8 17 0 1907178384 9178656 2420656
15:49:22 67125 8192000000 10832839760 11304124416 1871458976 18.596 97 21 42 1 1884634144 7065248 6109920
15:50:39 57744 8192000000 10886342688 11347161088 1945137568 19.188 100 22 43 1 1963212800 11661648 6413584
15:52:09 51183 8192000000 10856031440 11320819712 1882628528 18.686 97 17 34 2 1903346128 15309856 5407744
15:53:16 54804 8192000000 10855932784 11319783424 1897140240 18.803 98 21 42 2 1916353888 12963952 6249696
15:54:21 30585 8192000000 10879989968 11340873728 1944428352 19.182 100 16 32 1 1961048816 12040688 4579776
15:54:58 58164 8192000000 10893399872 11366322176 1951306464 19.237 100 14 28 1 1967891856 12855376 3730016
15:56:10 73861 8192000000 10894724352 11361042432 1956161824 19.276 100 18 34 2 1971655296 10588784 4904688
15:57:33 27541 8192000000 10897634624 11346706432 1935718560 19.113 98 38 77 1 1955295584 9438992 10138032
15:58:11 42103 8192000000 10892866912 11357175808 1936746496 19.121 99 21 42 0 1953473840 11037312 5690032
15:59:22 54765 8192000000 10899463712 11353264128 1923510400 19.015 98 22 44 0 1938777984 9294976 5972608
16:00:24 40244 8192000000 10892930512 11364884480 1925707536 19.033 98 24 48 0 1944781792 12348912 6725344
16:01:17 111825 8192000000 10901790464 11369312256 1952944144 19.250 99 12 24 0 1969812816 13087440 3781232
16:03:23 80077 8192000000 10911201040 11374858240 1920134384 18.988 97 22 42 2 1936904768 11326000 5444384
16:04:52 130243 8192000000 10895983552 11365289984 1919127040 18.980 97 32 64 1 1936722016 8374208 9220768
16:07:13 62040 8192000000 10907900176 11381166080 1979358096 19.460 100 36 72 1 1998443792 9485056 9600640
16:08:23 71053 8192000000 10919140816 11397222400 1976116048 19.434 99 17 34 1 1992602032 10930640 5555344
16:09:59 55039 8192000000 10918811632 11410554880 1991266176 19.554 100 13 26 2 2011700400 16770272 3663952
16:11:07 62754 8192000000 10897680016 11378245632 1941237168 19.157 97 16 31 1 1959122624 13421392 4464064
16:12:16 62321 8192000000 10888572288 11361574912 1916278112 18.957 97 15 30 0 1930567600 9726336 4563152
16:13:26 48817 8192000000 10876690160 11360944128 1923750224 19.017 98 10 18 1 1935111360 8683200 2677936
16:14:24 57196 8192000000 10863616400 11344453632 1892730768 18.768 97 6 12 0 1908097440 13826960 1539712
16:15:28 41925 8192000000 10892931504 11343548416 1896645328 18.799 97 20 40 1 1915702224 12822480 6234416
16:16:18 50123 8192000000 10875044640 11360395264 1914332848 18.941 98 30 61 3 1934416864 11828288 8255728
16:17:20 42736 8192000000 10888304304 11351404544 1887336800 18.724 96 21 40 1 1904428688 11529936 5561952
16:18:12 54028 8192000000 10883040960 11351478272 1920902816 18.994 98 29 57 2 1943797360 14183664 8710880
16:19:14 77661 8192000000 10872044288 11354980352 1922152576 19.004 98 22 44 0 1945540016 16765520 6621920
16:21:46 50127 8192000000 10862113616 11320881152 1869113680 18.577 96 28 56 0 1890043584 12993040 7936864
16:22:44 44523 8192000000 10855995312 11307724800 1854836256 18.461 96 25 50 1 1881713632 19636144 7241232
16:23:36 31645 8192000000 10871506368 11323846656 1879909200 18.664 98 30 59 1 1902181424 14435824 7836400
16:24:14 36285 8192000000 10884670512 11337682944 1935222592 19.109 100 32 64 2 1959681344 15476624 8982128
16:25:04 75284 8192000000 10857040080 11335880704 1855264192 18.465 96 15 30 0 1877924640 18930432 3730016
16:26:25 77654 8192000000 10620357120 11071844352 1702409552 17.205 88 19 37 1 1716665712 9222080 5034080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-03-2021 16:30:05 to 30-03-2021 16:30:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-03-2021 16:30:37 to 30-03-2021 16: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          241728
MON$OLDEST_ACTIVE               242382
MON$OLDEST_SNAPSHOT             242382
MON$NEXT_TRANSACTION            242382
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                       2016192
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:182: 
:183: mscs-test-161.budzdorov.ru    Tue Mar 30 16:27:47 2021
:184:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:185: 
:186: 
:187: mscs-test-161.budzdorov.ru    Tue Mar 30 16:28:23 2021
:188:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:189: 
--- end of diff output ---

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

30.03.21 16: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-03-30 16:30:43 No severe PSQL-related problems occured
30.03.21 16:30:44. End of report.