Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.03.2021 16: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 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 17734932 kB
MemAvailable 31531428 kB
Buffers 0 kB
Cached 13917464 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-16 16:27:23
DTS_END                         2021-03-16 16:27:23.3070
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/48604
TRN_ID                          248181
ATT_ID                          696
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: 9051.00 22446 1086120
customer order: creation 181.93 361 21831
customer order: refuse 15.71 381 1885
order to supplier: creation 47.15 1347 5658
order to supplier: removal 3.33 83363 400
invoice (draft): creation 48.19 3258 5783
invoice (draft): removal 49.49 691 5939
invoice accept: apply 44.14 18181 5297
invoice accept: cancel 44.25 837 5310
customer reserve: creation 3986.68 184 478401
customer reserve: removal 4319.96 51 518395
realization accept: apply 90.51 174 10861
realization accept: cancel 81.72 102 9807
payment from customer: creation 63.15 124 7578
payment from customer: removal 6.35 82 762
payment to supplier: creation 51.85 146 6222
payment to supplier: removal 3.66 128 439
service: total inventory turnovers 5.13 981 616
service: total monetary turnovers 6.91 22 829
service: aggregate perf. data 0.86 17532 103
service: refresh index statistics 0.03 320967 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-03-2021 16:28:07 to 16-03-2021 16:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5487
TEST_TIME 2 4298
TEST_TIME 3 4181
TEST_TIME 4 4346
TEST_TIME 5 4432
TEST_TIME 6 4774
TEST_TIME 7 5163
TEST_TIME 8 5180
TEST_TIME 9 5281
TEST_TIME 10 5249
TEST_TIME 11 5315
TEST_TIME 12 5830
TEST_TIME 13 6356
TEST_TIME 14 6571
TEST_TIME 15 6834
TEST_TIME 16 7195
TEST_TIME 17 7914
TEST_TIME 18 8030
TEST_TIME 19 9105
TEST_TIME 20 9295
TEST_TIME 21 9318
TEST_TIME 22 9702
TEST_TIME 23 9813
TEST_TIME 24 10172
TEST_TIME 25 10175
TEST_TIME 26 10305
TEST_TIME 27 9977
TEST_TIME 28 9876
TEST_TIME 29 10076
TEST_TIME 30 9878
TEST_TIME 31 9695
TEST_TIME 32 9582
TEST_TIME 33 9708
TEST_TIME 34 9792
TEST_TIME 35 9578
TEST_TIME 36 9388
TEST_TIME 37 9401
TEST_TIME 38 9270
TEST_TIME 39 9195
TEST_TIME 40 9278
TEST_TIME 41 9298
TEST_TIME 42 9138
TEST_TIME 43 9269
TEST_TIME 44 9196
TEST_TIME 45 9291
TEST_TIME 46 9239
TEST_TIME 47 9281
TEST_TIME 48 9231
TEST_TIME 49 9248
TEST_TIME 50 9208
TEST_TIME 51 9351
TEST_TIME 52 9311
TEST_TIME 53 9427
TEST_TIME 54 9332
TEST_TIME 55 9238
TEST_TIME 56 9170
TEST_TIME 57 9135
TEST_TIME 58 9056
TEST_TIME 59 9062
TEST_TIME 60 9051
TEST_TIME 61 9027
TEST_TIME 62 8926
TEST_TIME 63 8982
TEST_TIME 64 8964
TEST_TIME 65 9081
TEST_TIME 66 9117
TEST_TIME 67 9101
TEST_TIME 68 9154
TEST_TIME 69 9158
TEST_TIME 70 9156
TEST_TIME 71 9208
TEST_TIME 72 9344
TEST_TIME 73 9361
TEST_TIME 74 9347
TEST_TIME 75 9355
TEST_TIME 76 9389
TEST_TIME 77 9321
TEST_TIME 78 9255
TEST_TIME 79 9230
TEST_TIME 80 9181
TEST_TIME 81 9189
TEST_TIME 82 9173
TEST_TIME 83 9139
TEST_TIME 84 9092
TEST_TIME 85 9059
TEST_TIME 86 9050
TEST_TIME 87 8995
TEST_TIME 88 9059
TEST_TIME 89 9040
TEST_TIME 90 9061
TEST_TIME 91 9028
TEST_TIME 92 9102
TEST_TIME 93 9159
TEST_TIME 94 9146
TEST_TIME 95 9156
TEST_TIME 96 9182
TEST_TIME 97 9175
TEST_TIME 98 9198
TEST_TIME 99 9136
TEST_TIME 100 9237
TEST_TIME 101 9214
TEST_TIME 102 9273
TEST_TIME 103 9210
TEST_TIME 104 9166
TEST_TIME 105 9120
TEST_TIME 106 9108
TEST_TIME 107 9065
TEST_TIME 108 9023
TEST_TIME 109 9045
TEST_TIME 110 9009
TEST_TIME 111 8983
TEST_TIME 112 8986
TEST_TIME 113 9014
TEST_TIME 114 9015
TEST_TIME 115 9036
TEST_TIME 116 9038
TEST_TIME 117 9057
TEST_TIME 118 9053
TEST_TIME 119 9079
TEST_TIME 120 9052

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-03-2021 16:28:11 to 16-03-2021 16:28:14.

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 1528408 1528408 0 0.00 0 17425 6 0 0
doc_list_biud 1528408 1528408 0 0.00 0 27812 22 0 0
sp_add_invoice_to_stock 5409 5297 112 2.07 30 150640 18181 0 112
sp_cancel_adding_invoice 5310 5310 0 0.00 4 95494 838 0 0
sp_cancel_client_order 1885 1885 0 0.00 4 17539 382 0 0
sp_cancel_customer_reserve 518395 518395 0 0.00 1 27814 51 0 0
sp_cancel_pay_from_customer 762 762 0 0.00 2 5903 83 0 0
sp_cancel_pay_to_supplier 439 439 0 0.00 2 12632 128 0 0
sp_cancel_supplier_invoice 5954 5939 15 0.25 2 27764 691 0 15
sp_cancel_supplier_order 400 400 0 0.00 9 961078 83363 0 0
sp_cancel_write_off 9807 9807 0 0.00 1 9338 102 0 0
sp_client_order 21831 21831 0 0.00 3 21733 362 0 0
sp_customer_reserve 478401 478401 0 0.00 0 40865 185 0 0
sp_fill_shopping_cart 33262 33262 0 0.00 1 26972 40 0 0
sp_fill_shopping_cart_clo_res 478395 478395 0 0.00 0 18250 14 0 0
sp_get_clo_for_invoice 5291 5291 0 0.00 0 30562 303 0 0
sp_kill_cost_storno 16318 16318 0 0.00 0 6864 48 0 0
sp_kill_qstorno_ret_qs2qd 1052936 1052936 0 0.00 0 27809 28 0 0
sp_kill_qty_storno 557887 557887 0 0.00 0 27812 61 0 0
sp_lock_selected_doc 22235 22235 0 0.00 0 7827 6 0 0
sp_make_cost_storno 29951 29951 0 0.00 0 11572 49 0 0
sp_multiply_rows_for_pdistr 29951 29951 0 0.00 0 11415 28 0 0
sp_multiply_rows_for_qdistr 21831 21831 0 0.00 0 12340 168 0 0
sp_pay_from_customer 7578 7578 0 0.00 4 21331 124 0 0
sp_pay_to_supplier 6222 6222 0 0.00 4 14712 147 0 0
sp_payment_common 13800 13800 0 0.00 1 13824 32 0 0
sp_qd_handle_on_cancel_clo 1885 1885 0 0.00 0 12156 335 0 0
sp_qd_handle_on_invoice_upd_sts 10600 10600 0 0.00 0 16932 291 0 0
sp_qd_handle_on_reserve_upd_sts 10861 10861 0 0.00 0 25135 52 0 0
sp_reserve_write_off 10861 10861 0 0.00 6 25221 174 0 0
sp_supplier_invoice 5783 5783 0 0.00 6 78462 3258 0 0
sp_supplier_order 5658 5658 0 0.00 6 36746 1347 0 0
srv_aggregate_perf_data 103 103 0 0.00 2974 154160 17533 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1038 132502 32546 0 0
srv_find_qd_qs_mism 1035653 1035653 0 0.00 0 17425 6 0 0
srv_make_invnt_saldo 616 616 0 0.00 27 67619 981 0 0
srv_make_money_saldo 829 829 0 0.00 1 795 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 195999 453625 320968 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5297 5297 0 0.00 0 14053 157 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 5271 126 0 0
t$perf-norm:sp_cancel_client_order 1885 1885 0 0.00 0 2801 15 0 0
t$perf-norm:sp_cancel_customer_reserve 748 748 0 0.00 0 2044 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 762 762 0 0.00 0 1504 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 439 439 0 0.00 0 914 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 3480 21 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 21538 1440 0 0
t$perf-norm:sp_cancel_write_off 1029 1029 0 0.00 0 2937 11 0 0
t$perf-norm:sp_client_order 21831 21831 0 0.00 0 10254 18 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 5117 8 0 0
t$perf-norm:sp_pay_from_customer 7578 7578 0 0.00 0 6249 8 0 0
t$perf-norm:sp_pay_to_supplier 6222 6222 0 0.00 0 4185 7 0 0
t$perf-norm:sp_reserve_write_off 10861 10861 0 0.00 0 7403 11 0 0
t$perf-norm:sp_supplier_invoice 5783 5783 0 0.00 0 6949 24 0 0
t$perf-norm:sp_supplier_order 5658 5658 0 0.00 0 3216 15 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 285 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 1389 10 0 0
t$perf-norm:srv_make_invnt_saldo 616 616 0 0.00 0 1525 22 0 0
t$perf-norm:srv_make_money_saldo 829 829 0 0.00 0 549 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10802 10578 224 2.07 0 20982 27 0 224
v_all_customers 39678 39678 0 0.00 0 24 1 0 0
v_all_suppliers 31682 31682 0 0.00 0 70 1 0 0
v_all_wares 43662 43662 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 2295 9 0 0
v_cancel_client_order 3770 3770 0 0.00 0 17195 13 0 0
v_cancel_customer_prepayment 1524 1524 0 0.00 0 2514 9 0 0
v_cancel_customer_reserve 1496 1496 0 0.00 0 294 3 0 0
v_cancel_payment_to_supplier 878 878 0 0.00 0 12533 22 0 0
v_cancel_supplier_invoice 862 832 30 3.48 0 17196 48 0 30
v_cancel_supplier_order 800 800 0 0.00 0 11732 23 0 0
v_cancel_write_off 2058 2058 0 0.00 0 9091 25 0 0
v_max_id_clo_ord 5655 5655 0 0.00 0 3831 2 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 3241 14 0 0
v_max_id_ord_sup 5776 5776 0 0.00 0 5443 6 0 0
v_max_non_paid_invoice 1812 1812 0 0.00 0 881 2 0 0
v_max_non_paid_realizn 4200 4200 0 0.00 0 3964 8 0 0
v_min_id_clo_ord 5655 5655 0 0.00 0 3749 8 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 7670 33 0 0
v_min_id_ord_sup 5776 5776 0 0.00 0 6610 7 0 0
v_min_non_paid_invoice 6222 6222 0 0.00 0 11356 22 0 0
v_min_non_paid_realizn 7578 7578 0 0.00 0 8584 15 0 0
v_our_firm 10740 10740 0 0.00 0 12 1 0 0
v_reserve_write_off 21722 21722 0 0.00 0 17356 11 0 0
x_lock_depdocs_on_canc_invoice 10833 10833 0 0.00 0 23039 115 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 10983 332 0 0
x_make_qstorno_1000_1200 5658 5658 0 0.00 1 36738 1262 0 0
x_make_qstorno_1200_2000 5783 5783 0 0.00 2 78450 3114 0 0
x_make_qstorno_2100_3300 478401 478401 0 0.00 0 40862 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-03-2021 16:28:15 to 16-03-2021 16:28:19.

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:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:33 14618 8192000000 10245823440 10556755968 859433216 9.494 68 42 86 0 875256736 2285312 13538208
13:57:55 35654 8192000000 10351851232 10670866432 1389347568 14.500 100 89 178 0 1422942320 4835456 28759296
13:58:37 25998 8192000000 10387958704 10709803008 1432731568 14.885 100 83 169 0 1466099104 6402064 26965472
13:59:18 24582 8192000000 10417452224 10745102336 1470282000 15.216 100 92 184 0 1508250528 7796288 30172240
13:59:55 17875 8192000000 10435449504 10765807616 1488248112 15.374 100 89 178 1 1525277872 8594208 28435552
14:00:37 7513 8192000000 10443471328 10775248896 1501774432 15.492 100 93 186 1 1540628848 9245568 29608848
14:01:01 13155 8192000000 10453069344 10789916672 1512003584 15.581 100 85 170 0 1548512288 9629632 26879072
14:01:22 16468 8192000000 10474383056 10812157952 1526470688 15.706 100 80 160 1 1561996208 10009616 25515904
14:01:49 13511 8192000000 10484521216 10827423744 1546441360 15.879 100 76 151 1 1579963120 10186944 23334816
14:02:11 21018 8192000000 10537009264 10881982464 1585081216 16.212 100 84 169 0 1621542368 10722000 25739152
14:02:41 10283 8192000000 10533049984 10886905856 1597035040 16.314 100 78 156 2 1631344496 10521088 23788368
14:02:59 9039 8192000000 10559353264 10915999744 1617668272 16.490 100 72 144 1 1649437216 10079216 21689728
14:03:18 13914 8192000000 10576446768 10936565760 1642436592 16.700 100 79 159 0 1676693744 10808048 23449104
14:03:42 11756 8192000000 10606796688 10970976256 1665298896 16.894 100 80 159 3 1700472944 11438752 23735296
14:04:03 8846 8192000000 10616237936 10984747008 1683535600 17.047 100 79 158 0 1718107328 11803472 22768256
14:04:18 9200 8192000000 10632391984 10997288960 1688933984 17.092 100 73 146 2 1722150112 11958896 21257232
14:04:36 13929 8192000000 10644332112 11015417856 1702651744 17.207 100 79 157 1 1737741712 12811904 22278064
14:04:57 8310 8192000000 10671250544 11042607104 1723616592 17.382 100 76 152 1 1757668672 12636896 21415184
14:05:14 4662 8192000000 10683749680 11054747648 1739878432 17.518 100 83 166 1 1778192544 13993984 24320128
14:05:27 5611 8192000000 10686127552 11061071872 1752407296 17.622 100 81 155 3 1786479680 12614432 21457952
14:05:39 7162 8192000000 10696686384 11072749568 1764994864 17.726 100 76 153 2 1798522960 12219120 21308976
14:05:53 4028 8192000000 10709468864 11091795968 1773182896 17.793 100 81 162 1 1809096816 12301264 23612656
14:06:04 3769 8192000000 10714250816 11092340736 1780625888 17.855 100 83 166 1 1816722928 13344992 22752048
14:06:15 3939 8192000000 10728225248 11107778560 1785633936 17.896 100 87 174 2 1824044912 14055712 24355264
14:06:26 3697 8192000000 10737489392 11120562176 1800185488 18.015 100 87 174 0 1837955296 13155808 24614000
14:06:36 3864 8192000000 10748291680 11129282560 1804248128 18.049 100 85 164 2 1839925792 12136512 23541152
14:06:46 2705 8192000000 10752838320 11132268544 1812981184 18.120 100 86 172 0 1849515952 12986736 23548032
14:06:56 2103 8192000000 10758266448 11140128768 1818555152 18.166 100 90 180 1 1856975664 14069008 24351504
14:07:06 3141 8192000000 10771693152 11150454784 1826505360 18.231 100 93 186 1 1867158560 14287952 26365248
14:07:15 10656 8192000000 10756565776 11148058624 1825499376 18.223 100 75 150 3 1861238208 15372352 20366480
14:07:32 3461 8192000000 10770706032 11156197376 1835805184 18.307 100 90 180 3 1876502928 15558432 25139312
14:07:42 2451 8192000000 10794200080 11178385408 1848803840 18.412 100 89 174 2 1886935776 14504432 23627504
14:07:51 1800 8192000000 10800251936 11184791552 1857748544 18.485 100 95 189 2 1898680480 14359776 26572160
14:08:00 2226 8192000000 10797728528 11189301248 1859703904 18.501 100 85 167 0 1897249264 12989072 24556288
14:08:08 1939 8192000000 10808919264 11193982976 1861998064 18.519 100 87 174 0 1899872464 13435648 24438752
14:08:16 1589 8192000000 10809188256 11196055552 1864336864 18.538 100 95 191 1 1905916400 14023568 27555968
14:08:24 1582 8192000000 10806947840 11198341120 1866770400 18.558 100 82 165 0 1902373616 12810768 22792448
14:08:32 1673 8192000000 10809595936 11198730240 1867232896 18.562 100 89 177 0 1905137856 13273568 24631392
14:08:40 1493 8192000000 10817287040 11202248704 1867985968 18.568 100 87 174 0 1905739952 13541744 24212240
14:08:48 2066 8192000000 10810996720 11202830336 1872183648 18.602 100 85 170 3 1910221392 13305792 24731952
14:08:57 6418 8192000000 10816493648 11208945664 1875032048 18.625 100 80 157 1 1911162496 13441984 22688464
14:09:09 2968 8192000000 10808277200 11216191488 1879870736 18.664 100 68 136 0 1911884272 13019200 18994336
14:09:19 27081 8192000000 10765605264 11205357568 1872141008 18.602 100 32 64 0 1889850880 9102224 8607648
14:09:55 7402 8192000000 10814900576 11220889600 1875965248 18.633 100 40 78 2 1897339040 9868112 11505680
14:10:10 6609 8192000000 10787892112 11214258176 1878219920 18.651 100 35 71 0 1899978864 11397264 10361680
14:10:26 9519 8192000000 10782545968 11214413824 1876200688 18.634 100 17 34 0 1887217616 6390032 4626896
14:10:44 4126 8192000000 10794595008 11221524480 1883792432 18.696 100 33 66 2 1901085424 8408224 8884768
14:10:56 7249 8192000000 10789365744 11219849216 1884108608 18.698 100 28 54 3 1899918896 7738656 8071632
14:11:11 7612 8192000000 10791090816 11223027712 1886076816 18.714 100 24 48 1 1899237664 6431376 6729472
14:11:26 9280 8192000000 10800888384 11229433856 1888878416 18.737 100 21 42 1 1901026480 6242848 5905216
14:11:42 18406 8192000000 10794799872 11232813056 1890402640 18.749 100 10 20 1 1898947888 5697888 2847360
14:12:06 10562 8192000000 10803988912 11234611200 1898653280 18.815 100 24 48 4 1912126544 6691408 6781856
14:12:24 14206 8192000000 10801357824 11237851136 1898633072 18.815 100 18 36 4 1909315600 5548800 5133728
14:12:45 4450 8192000000 10813888528 11243593728 1904503280 18.862 100 33 65 2 1921436496 7449680 9483536
14:12:59 7409 8192000000 10808566944 11245187072 1904577264 18.863 100 20 40 1 1916609696 5549104 6483328
14:13:12 7954 8192000000 10814476464 11247742976 1908545856 18.895 100 17 34 1 1918436304 5440528 4449920
14:13:29 45002 8192000000 10831063056 11254194176 1908410720 18.894 100 26 50 0 1921800272 5713920 7675632
14:14:51 1768 8192000000 10868011296 11273244672 1922546768 19.007 100 94 190 5 1959902128 9517008 27838352
14:15:02 7538 8192000000 10830877840 11261521920 1911444176 18.918 100 26 52 0 1926000416 7369136 7187104
14:15:18 5037 8192000000 10833794240 11262140416 1910101792 18.907 100 20 40 0 1921110688 5630960 5377936
14:15:32 5573 8192000000 10826655728 11262373888 1916823200 18.961 100 37 73 2 1933819056 6520512 10475344
14:15:44 7836 8192000000 10829392592 11263111168 1914428784 18.942 100 29 55 3 1928973856 6361536 8183536
14:15:59 5846 8192000000 10831304688 11262373888 1915461280 18.950 100 22 44 1 1927277568 5597968 6218320
14:16:16 8741 8192000000 10804019184 11237502976 1856000672 18.471 97 22 43 1 1868833488 6390176 6442640
14:16:32 10344 8192000000 10809456048 11245711360 1884016336 18.698 99 23 46 0 1900421120 10247472 6157312
14:16:53 6574 8192000000 10804789040 11241115648 1862595456 18.524 98 21 42 1 1875432864 6552336 6285072
14:17:06 7323 8192000000 10784769600 11209592832 1852962672 18.446 98 19 38 0 1864210592 6121744 5126176
14:17:22 9996 8192000000 10791536016 11221020672 1852683440 18.444 98 33 66 1 1868935520 5971392 10280688
14:17:39 11194 8192000000 10801061776 11231408128 1870051728 18.585 99 25 50 1 1887328400 10183200 7093472
14:17:59 51424 8192000000 10780017168 11208966144 1850638656 18.427 98 30 60 1 1864481952 5360608 8482688
14:18:57 22969 8192000000 10767576752 11205476352 1814673888 18.134 96 14 26 0 1823611216 5008592 3928736
14:19:27 10990 8192000000 10784190480 11213508608 1860000640 18.503 99 22 43 1 1871223056 5459200 5763216
14:19:44 5508 8192000000 10761667728 11178520576 1822171936 18.195 98 22 44 3 1834899424 6016512 6710976
14:19:57 10369 8192000000 10759022208 11185852416 1819884944 18.177 98 22 44 0 1832193520 6005968 6302608
14:20:14 6028 8192000000 10749333872 11179642880 1833051968 18.284 99 23 46 1 1846615696 5961088 7602640
14:20:27 4639 8192000000 10744389984 11150553088 1785459808 17.894 97 34 69 0 1800933744 5025248 10448688
14:20:41 6410 8192000000 10722428416 11133034496 1741344848 17.530 96 22 41 3 1753327520 5107856 6874816
14:20:55 6938 8192000000 10644592384 11042205696 1592557952 16.276 89 21 42 0 1603347392 4854080 5935360
14:21:09 8870 8192000000 10683963264 11087257600 1717768192 17.334 97 22 45 0 1729883776 5848528 6267056
14:21:27 6127 8192000000 10682103056 11096772608 1716283360 17.321 96 38 74 0 1733016384 5332624 11400400
14:21:39 6347 8192000000 10679141088 11087503360 1742189888 17.537 98 28 56 0 1756039248 5976640 7872720
14:21:52 8966 8192000000 10721518864 11135889408 1795216880 17.975 100 26 50 2 1813114176 10098384 7798912
14:22:09 9034 8192000000 10709036288 11116593152 1772917088 17.791 99 16 32 1 1782633664 5113904 4602672
14:22:27 11966 8192000000 10715998528 11134181376 1802222576 18.032 100 23 46 1 1814859600 5067696 7569328
14:22:45 18681 8192000000 10718330896 11130888192 1766989632 17.742 97 28 57 3 1781608608 5072832 9546144
14:23:10 68780 8192000000 10726293504 11147530240 1790115392 17.933 99 30 57 3 1805410256 4825968 10468896
14:24:27 6779 8192000000 10731750016 11157250048 1822560960 18.199 100 23 46 2 1834747632 6122816 6063856
14:24:43 7882 8192000000 10752699760 11170095104 1833009328 18.284 100 29 58 1 1848348528 7002800 8336400
14:24:59 7249 8192000000 10745163968 11168964608 1833395856 18.287 100 29 58 2 1847920224 5443184 9081184
14:25:14 7687 8192000000 10749274944 11173683200 1836235712 18.310 100 40 80 2 1858154192 10356240 11562240
14:25:29 8413 8192000000 10754506800 11173330944 1837648160 18.322 100 25 48 2 1849853056 5101616 7103280
14:25:43 4366 8192000000 10750588176 11176599552 1842014928 18.357 100 38 76 1 1859646096 6765376 10865792
14:25:54 6850 8192000000 10761177776 11182960640 1844187328 18.375 100 27 54 0 1858849904 5954416 8708160
14:26:08 8130 8192000000 10773135728 11192258560 1852785184 18.445 100 33 66 2 1869380144 7229456 9365504
14:26:29 9930 8192000000 10760418416 11191934976 1852561968 18.443 100 19 38 1 1862607360 4917488 5127904
14:26:45 7067 8192000000 10781101056 11201114112 1858924128 18.495 100 28 57 2 1873227360 6243408 8059824
14:27:00 11803 8192000000 10786628176 11210694656 1866239200 18.554 100 14 28 2 1875127472 4535456 4352816
14:27:19 12104 8192000000 10793408752 11220332544 1881963456 18.681 100 26 53 1 1895519920 5477744 8078720
14:27:40 7631 8192000000 10835800464 11238141952 1898464912 18.814 100 65 126 4 1923539664 5790400 19284352
14:27:55 102556 8192000000 10834392800 11263160320 1907105824 18.883 100 34 68 2 1930434320 14066784 9261712
14:29:46 47867 8192000000 10846240912 11274817536 1914925232 18.946 100 37 75 1 1935023008 9675888 10421888
14:30:41 17229 8192000000 10854035056 11285028864 1922970544 19.011 100 44 87 1 1948754224 12507632 13276048
14:31:09 23089 8192000000 10877698640 11302105088 1936146144 19.116 100 48 96 3 1967963376 17658112 14159120
14:31:42 3782 8192000000 10895668784 11307749376 1944164128 19.180 100 62 124 3 1981401472 18853312 18384032
14:31:53 5878 8192000000 10895056912 11313373184 1945865456 19.194 100 62 121 2 1983119024 20107696 17145872
14:32:11 15061 8192000000 10892082656 11315408896 1949410320 19.222 100 60 116 1 1987415024 20958320 17046384
14:32:37 6177 8192000000 10900990960 11324022784 1953930288 19.258 100 54 108 0 1992588096 23079920 15577888
14:32:50 7620 8192000000 10899764368 11325227008 1956635312 19.279 100 57 115 3 1996401728 23165648 16600768
14:33:10 10084 8192000000 10903048464 11330285568 1956664272 19.280 100 59 118 4 1998844000 24228928 17950800
14:33:28 4027 8192000000 10922058480 11338719232 1965303632 19.348 100 75 148 1 2010497664 23673920 21520112
14:33:41 13101 8192000000 10919097888 11338555392 1949124368 19.220 99 59 118 1 1990477280 24415008 16937904
14:34:03 9444 8192000000 10924203872 11345018880 1965543152 19.350 100 57 113 1 2007424704 25093248 16788304
14:34:21 5959 8192000000 10904077664 11334365184 1961481728 19.318 100 53 106 1 2002040768 24567488 15991552
14:34:35 10212 8192000000 10920519072 11348779008 1966116832 19.355 100 46 91 0 2006296064 27245024 12934208
14:34:54 3964 8192000000 10926347264 11345817600 1969834192 19.384 100 66 128 3 2014008384 25777456 18396736
14:35:12 13924 8192000000 10929140896 11358380032 1975291424 19.427 100 57 113 2 2020037776 27647440 17098912
14:35:41 12096 8192000000 10932369232 11359526912 1979898736 19.464 100 63 125 4 2026275392 28194064 18182592
14:36:02 20663 8192000000 10934288928 11368153088 1983081008 19.489 100 56 112 0 2031358432 31444288 16833136
14:36:34 7543 8192000000 10933847472 11372003328 1984528832 19.501 100 43 86 0 2027398752 30079456 12790464
14:36:51 4824 8192000000 10942389824 11374751744 1987895744 19.527 100 51 101 1 2034161152 29729344 16536064
14:37:03 20955 8192000000 10953102112 11387887616 1990271808 19.546 100 51 102 2 2036707264 31251808 15183648
14:37:32 2256 8192000000 10961351728 11387834368 2000063920 19.623 100 62 122 0 2051067792 32344512 18659360
14:37:44 5793 8192000000 10958137024 11386253312 1996046960 19.592 100 61 122 4 2047315776 32147120 19121696
14:38:00 6820 8192000000 10941125936 11370266624 1967638176 19.367 99 59 118 2 2021728752 36545376 17545200
14:38:16 2922 8192000000 10949698288 11377831936 1987628528 19.525 100 64 127 2 2040074928 33411632 19034768
14:38:27 7167 8192000000 10948361024 11367501824 1979347216 19.460 100 67 134 1 2033927248 34256080 20323952
14:38:41 5902 8192000000 10961435600 11385802752 1989373088 19.539 100 75 151 1 2049761312 37086352 23301872
14:38:54 2524 8192000000 10964072096 11385937920 1992594672 19.564 100 62 125 0 2049831456 37660816 19575968
14:39:04 4500 8192000000 10966339392 11393126400 1997360960 19.602 100 72 142 0 2057627936 38096832 22170144
14:39:15 1037 8192000000 10968163088 11378012160 1976797072 19.439 99 92 185 0 2045688832 41052272 27839488
14:39:23 4915 8192000000 10945093536 11361742848 1972121024 19.402 100 75 148 2 2032146928 37422672 22603232
14:39:34 3248 8192000000 10962934528 11379355648 1983636400 19.493 100 87 175 0 2049082240 38539424 26906416
14:39:44 3662 8192000000 10964534608 11373699072 1979744512 19.463 100 86 171 1 2043927040 39167760 25014768
14:39:54 2439 8192000000 10957425440 11378819072 1988944848 19.535 100 80 158 1 2052504016 39651568 23907600
14:40:04 2778 8192000000 10968903648 11383451648 1987935552 19.527 100 80 160 1 2051798944 39991904 23871488
14:40:13 2350 8192000000 10955543200 11361009664 1974034496 19.417 99 90 180 1 2042202176 40865952 27301728
14:40:24 3998 8192000000 10959852928 11380764672 1983526288 19.493 100 73 146 2 2046440512 40780608 22133616
14:40:35 3623 8192000000 10970820752 11391258624 1992664864 19.565 100 82 163 1 2058362544 40988864 24708816
14:40:47 2727 8192000000 10965796192 11383279616 1989195888 19.537 100 84 168 0 2050097920 35379920 25522112
14:40:58 2344 8192000000 10957976144 11375030272 1968115536 19.370 99 81 156 0 2028668576 35959104 24593936
14:41:08 3503 8192000000 10951287520 11366944768 1976168112 19.434 100 77 153 0 2036557568 36414128 23975328
14:41:22 2780 8192000000 10930720656 11347161088 1957161904 19.283 99 68 136 0 2014884624 37364976 20357744
14:41:39 2179 8192000000 10920007712 11333406720 1949155936 19.220 99 78 150 0 2009558304 37214416 23187952
14:41:48 2162 8192000000 10932732320 11344695296 1932586688 19.088 98 79 160 0 1994282832 37775168 23920976
14:41:59 6591 8192000000 10925228064 11345268736 1942124672 19.164 99 71 142 3 2003503568 39599760 21779136
14:42:14 4529 8192000000 10931177264 11352670208 1954892944 19.265 100 66 131 0 2015916528 40875200 20148384
14:42:25 3683 8192000000 10915998160 11339493376 1941886400 19.162 99 62 124 2 2008061472 46469936 19705136
14:42:37 3634 8192000000 10952076144 11368628224 1967908096 19.369 100 73 146 2 2034573232 43240544 23424592
14:42:48 6100 8192000000 10933437088 11369549824 1961662240 19.319 100 53 106 2 2028383136 48560192 18160704
14:43:03 7199 8192000000 10933305536 11363307520 1957314016 19.285 100 52 105 1 2016631232 42624880 16692336
14:43:18 2467 8192000000 10932488976 11355480064 1957013696 19.282 100 77 150 4 2023937264 42096784 24826784
14:43:29 3921 8192000000 10940884768 11361439744 1959739184 19.304 100 68 136 1 2020394640 38754752 21900704
14:43:41 1896 8192000000 10947905296 11362123776 1955893104 19.273 99 91 182 0 2024838928 40413520 28532304
14:43:50 2434 8192000000 10958394832 11371438080 1975804608 19.431 100 89 179 5 2044633536 41725552 27103376
14:43:59 1149 8192000000 10941864288 11347472384 1946966944 19.202 100 85 170 0 2015235728 42646816 25621968
14:44:09 8645 8192000000 10922216656 11340480512 1951871664 19.241 100 70 137 1 2008240144 34778432 21590048
14:44:25 4144 8192000000 10920800496 11346698240 1953031200 19.251 100 76 150 1 2010914448 34583712 23299536
14:44:42 2080 8192000000 10939719648 11348353024 1942066576 19.163 99 78 156 2 2003013376 36856672 24090128
14:44:54 7820 8192000000 10916634976 11341705216 1945805184 19.193 100 54 107 0 2001241184 38308736 17127264
14:45:14 2822 8192000000 10933794928 11354124288 1933544960 19.095 99 72 145 1 2002774640 45942080 23287600
14:45:24 1805 8192000000 10902338976 11304382464 1907648832 18.888 99 93 184 1 1979277856 42070928 29558096
14:45:33 2877 8192000000 10927806656 11334152192 1929492768 19.063 100 82 165 1 2001554640 45306608 26755264
14:45:43 3965 8192000000 10918327184 11340316672 1936505872 19.119 100 81 157 1 2005488352 43346160 25636320
14:45:57 2434 8192000000 10930786416 11349921792 1944460864 19.182 100 81 160 0 2013328272 43952192 24915216
14:46:06 1060 8192000000 10920504208 11336888320 1938284512 19.133 100 79 156 1 2003263456 39984960 24993984
14:46:14 2558 8192000000 10900385040 11327025152 1942189664 19.164 100 72 138 5 1992139776 28332592 21617520
14:46:24 20416 8192000000 10896247312 11326996480 1937960128 19.130 100 45 90 1 1985308224 34041440 13306656
14:46:52 7121 8192000000 10879537376 11313053696 1914065328 18.939 99 45 90 0 1951201392 23939136 13196928
14:47:06 6768 8192000000 10851429328 11291238400 1879233248 18.659 98 29 58 1 1912782352 24060576 9488528
14:47:21 9419 8192000000 10849729376 11291213824 1905295440 18.869 100 26 50 1 1937810208 23711072 8803696
14:47:44 23591 8192000000 10858153520 11304304640 1918370768 18.974 100 27 54 2 1948004368 21114384 8519216
14:48:22 18965 8192000000 10849136800 11294265344 1873739200 18.615 98 25 50 1 1903918128 21514848 8664080
14:48:50 17379 8192000000 10850476368 11300028416 1873333104 18.611 98 30 60 0 1907169920 24491824 9344992
14:49:24 22460 8192000000 10858388480 11314499584 1917784160 18.969 100 20 41 0 1945671968 21947936 5939872
14:50:10 12048 8192000000 10887350160 11330367488 1927465040 19.047 100 22 44 2 1961842416 27423136 6954240
14:50:29 25255 8192000000 10847654608 11299930112 1848594272 18.411 96 25 50 2 1880839088 24516416 7728400
14:51:01 14310 8192000000 10842236624 11286048768 1871092496 18.593 98 31 62 1 1900885760 19978112 9815152
14:51:24 30157 8192000000 10833693568 11282776064 1884317136 18.700 99 24 46 1 1908535504 17061936 7156432
14:52:01 25517 8192000000 10836547200 11285884928 1886570080 18.718 99 22 44 2 1912221760 18598384 7053296
14:52:36 49246 8192000000 10857862832 11311476736 1909064880 18.899 100 15 30 1 1937791232 24049952 4676400
14:54:02 70710 8192000000 10842976016 11298889728 1917132992 18.964 100 21 42 0 1937757040 14761792 5862256
14:55:19 51870 8192000000 10868577568 11312648192 1900724784 18.832 99 37 75 1 1924658880 12669568 11264528
14:56:17 15414 8192000000 10855687504 11307388928 1922813376 19.009 100 31 62 1 1946698416 14369104 9515936
14:57:02 75407 8192000000 10880997856 11326357504 1924369984 19.022 99 22 44 0 1944870512 14982128 5518400
14:58:24 54686 8192000000 10871026448 11329728512 1931402032 19.078 99 23 46 2 1954416240 16397456 6616752
14:59:58 40359 8192000000 10875566304 11335172096 1923625520 19.016 99 12 24 1 1947855264 20368976 3860768
15:00:47 16477 8192000000 10863783872 11325132800 1922398864 19.006 99 13 26 0 1944133504 18158304 3576336
15:01:10 15083 8192000000 10855571888 11325489152 1922533424 19.007 99 9 18 0 1941847904 16910224 2404256
15:01:32 31847 8192000000 10857251504 11311337472 1920976352 18.995 99 15 31 1 1933421952 8297472 4148128
15:02:28 111821 8192000000 10871048608 11328974848 1947191728 19.204 100 28 56 0 1967360208 12095296 8073184
15:04:26 26152 8192000000 10900006848 11359096832 1969310096 19.380 100 25 50 4 1993215312 17269552 6635664
15:05:02 42948 8192000000 10898677584 11356667904 1972336384 19.404 100 20 40 0 1989873840 11607808 5929648
15:05:57 66998 8192000000 10896173040 11362549760 1975265632 19.427 100 20 40 0 1994473248 13090720 6116896
15:07:10 68581 8192000000 10891475296 11369365504 1947929568 19.210 99 12 24 3 1969383584 17911904 3542112
15:08:34 55212 8192000000 10891001744 11367686144 1969267328 19.380 100 8 16 1 1986466640 15012224 2187088
15:09:35 18462 8192000000 10913542864 11356270592 1973947344 19.417 100 49 98 2 1998630128 11155376 13527408
15:09:59 43085 8192000000 10896140256 11372113920 1969950240 19.385 100 31 62 1 1991477424 12988416 8538768
15:10:49 82730 8192000000 10922519664 11385774080 1986053312 19.513 100 19 38 0 2007173888 15796736 5323840
15:13:21 64790 8192000000 10912065760 11378655232 1913957808 18.938 96 25 50 0 1932017616 11177152 6882656
15:14:35 59533 8192000000 10924496752 11374157824 1963305248 19.332 99 23 47 1 1977154352 7785664 6063440
15:15:42 33143 8192000000 10932613552 11370577920 1971415472 19.397 100 40 80 0 1992423984 10131568 10876944
15:16:46 54855 8192000000 10927418368 11389079552 1988757568 19.534 100 27 52 1 2006858848 11219616 6881664
15:17:50 80178 8192000000 10912867424 11389480960 1931093664 19.076 97 19 38 1 1956433952 19669216 5671072
15:19:20 75396 8192000000 10912747712 11370590208 1900379792 18.829 96 15 28 3 1921903744 17016624 4507328
15:20:44 97979 8192000000 10896067408 11351777280 1920239344 18.989 97 33 65 2 1937980272 8250416 9490512
15:23:53 73134 8192000000 10852075408 11328978944 1893404768 18.773 97 13 26 0 1912205296 14966208 3834320
15:25:14 8490 8192000000 10872560016 11337302016 1946576560 19.199 100 20 40 1 1963751952 11283248 5892144
15:25:37 51541 8192000000 10894842128 11375353856 1951986288 19.242 99 28 55 2 1973970384 13565520 8418576
15:26:37 56132 8192000000 10905357728 11385774080 1955142288 19.267 99 10 20 1 1978102624 20089712 2870624
15:27:41 25928 8192000000 10871730464 11349000192 1931425968 19.078 98 6 12 0 1952387456 19353984 1607504
15:28:22 31805 8192000000 10890251328 11368173568 1942580272 19.167 99 8 16 0 1963303600 18783200 1940128
15:29:03 70167 8192000000 10901161616 11369332736 1935264240 19.109 98 18 36 1 1956181680 15893648 5023792
15:30:27 64074 8192000000 10897429440 11359584256 1913592176 18.935 97 21 42 0 1929314192 10018912 5703104
15:31:46 59251 8192000000 10858492288 11331375104 1855068160 18.463 95 13 26 1 1869625744 10859904 3697680
15:32:57 58400 8192000000 10846617664 11292160000 1844814224 18.380 95 15 30 0 1856667504 8138576 3714704
15:34:01 97204 8192000000 10884788192 11343560704 1909114816 18.900 98 20 41 1 1926378592 11698080 5565696
15:35:51 49362 8192000000 10855498480 11314847744 1876426560 18.636 96 15 30 0 1896328576 15482752 4419264
15:36:47 52754 8192000000 10882035264 11318628352 1846754176 18.396 95 20 40 1 1872692080 19814288 6123616
15:38:02 31069 8192000000 10873849184 11325919232 1928175696 19.052 100 29 58 1 1950054976 13690176 8189104
15:39:05 44297 8192000000 10861170576 11336966144 1913113264 18.932 99 17 34 0 1931297520 13301488 4882768
15:40:01 47474 8192000000 10868463536 11328081920 1894535312 18.782 98 16 32 1 1914142304 14668640 4938352
15:40:56 99373 8192000000 10853538528 11306688512 1840592960 18.346 95 29 58 1 1861905984 13606880 7706144
15:42:42 84326 8192000000 10844174704 11308617728 1790713456 17.938 93 8 16 0 1804960208 12193648 2053104
15:44:13 64935 8192000000 10820856128 11273175040 1841069776 18.350 96 27 54 1 1860133936 10936000 8128160
15:46:09 54924 8192000000 10826648944 11283001344 1860395776 18.506 97 26 52 1 1877732704 9978672 7358256
15:47:12 66008 8192000000 10859740800 11304357888 1906669696 18.880 99 42 84 1 1929875776 11773488 11432592
15:48:25 29222 8192000000 10851233408 11304374272 1907012608 18.883 99 34 68 0 1929520608 13115424 9392576
15:49:01 14928 8192000000 10855457760 11310903296 1925538240 19.031 100 30 60 2 1943723184 9017808 9167136
15:49:23 66148 8192000000 10849372608 11318583296 1913981232 18.939 99 16 32 0 1925492576 7105200 4406144
15:50:38 40272 8192000000 10857824672 11326238720 1942225824 19.165 100 12 24 0 1952945696 6865888 3853984
15:51:43 58930 8192000000 10855105696 11324612608 1926059024 19.035 99 27 53 2 1943502048 10390384 7052640
15:52:49 48070 8192000000 10849019584 11328335872 1931939680 19.082 100 12 24 0 1944220288 8348144 3932464
15:53:43 52563 8192000000 10852296608 11331448832 1921509632 18.999 99 8 16 1 1932462768 8490256 2462880
15:54:41 53380 8192000000 10852825552 11336839168 1941882112 19.162 100 12 24 2 1956629536 10889856 3857568
15:56:00 22484 8192000000 10878672112 11347111936 1957209264 19.284 100 24 46 1 1971515200 6977536 7328400
15:56:37 63070 8192000000 10883191472 11348766720 1924584576 19.024 98 17 34 2 1938996848 9563216 4849056
15:57:46 55767 8192000000 10909501728 11366977536 1946880224 19.202 99 28 55 3 1967082160 13733392 6468544
15:58:52 108892 8192000000 10869132000 11350519808 1876912544 18.640 95 20 40 1 1903287184 20206112 6168528
16:00:50 45004 8192000000 10888506480 11342512128 1938575552 19.135 99 22 44 0 1952498432 8058272 5864608
16:01:42 37543 8192000000 10905542608 11355815936 1960765152 19.312 100 35 70 1 1980921424 10517312 9638960
16:02:26 26711 8192000000 10909643824 11365343232 1971012624 19.393 100 49 99 3 1996529840 11878448 13638768
16:03:00 52818 8192000000 10886180720 11342434304 1929240768 19.061 98 27 54 0 1948599456 12003760 7354928
16:04:24 41606 8192000000 10878011968 11334795264 1920924288 18.994 98 25 50 2 1937054512 8944000 7186224
16:05:18 84934 8192000000 10889524592 11339829248 1880086816 18.666 96 30 60 1 1899367024 11290224 7989984
16:07:01 27335 8192000000 10873960976 11335401472 1925749904 19.033 99 34 68 2 1952227584 16572896 9904784
16:07:39 33447 8192000000 10878375696 11337629696 1914268960 18.941 98 15 30 1 1926334640 7652032 4413648
16:08:40 85266 8192000000 10872539728 11347619840 1865193568 18.545 95 9 18 0 1877247696 9503056 2551072
16:10:12 93974 8192000000 10879776736 11332747264 1915500656 18.951 98 23 46 0 1929504848 7065920 6938272
16:11:52 66397 8192000000 10859560112 11316174848 1902173840 18.844 98 23 46 1 1917468752 8794368 6500544
16:13:05 54035 8192000000 10867321504 11333738496 1929275616 19.061 99 23 42 4 1945385856 9784560 6325680
16:14:05 74540 8192000000 10868873888 11345354752 1947512816 19.207 100 6 12 0 1961196432 11976240 1707376
16:15:41 43756 8192000000 10848706576 11331219456 1907482912 18.886 98 8 16 1 1921459360 11621760 2354688
16:16:31 33346 8192000000 10836114928 11309756416 1893331840 18.773 98 9 18 0 1904821264 8961232 2528192
16:17:11 35742 8192000000 10841101088 11304730624 1901452720 18.838 99 19 38 1 1913210768 6919168 4838880
16:17:53 54658 8192000000 10842894512 11313692672 1892021168 18.762 98 14 28 0 1903818112 8120016 3676928
16:18:56 72069 8192000000 10856199424 11327086592 1876693904 18.638 97 12 24 2 1888338208 8382112 3262192
16:20:22 77703 8192000000 10876880752 11321044992 1881784352 18.680 97 22 44 1 1895946784 7542848 6619584
16:21:47 56098 8192000000 10862435296 11331244032 1914677632 18.944 99 24 48 0 1931821152 10333440 6810080
16:23:07 84124 8192000000 10872341216 11337142272 1912476528 18.927 99 16 32 0 1926363296 9527424 4359344
16:24:40 132501 8192000000 10861648752 11340455936 1849656992 18.419 95 7 14 1 1865029040 13498240 1873808
16:26:59 31881 8192000000 9083964192 9300254720 241872848 2.867 13 1 2 0 245887376 3952400 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-03-2021 16:28:21 to 16-03-2021 16:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-03-2021 16:28:54 to 16-03-2021 16:28:56.

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          248502
MON$OLDEST_ACTIVE               248503
MON$OLDEST_SNAPSHOT             248503
MON$NEXT_TRANSACTION            248503
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                       1994304
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
--- end of diff output ---

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

16.03.21 16:28:57. 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-16 16:28:59 No severe PSQL-related problems occured
16.03.21 16:29:01. End of report.