Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2021 16:28
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 17415160 kB
MemAvailable 31550552 kB
Buffers 0 kB
Cached 14270812 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-21 16:27:29
DTS_END                         2021-03-21 16:27:22.5590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40528
TRN_ID                          232977
ATT_ID                          274
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: 9053.50 20958 1086420
customer order: creation 163.38 355 19606
customer order: refuse 14.65 339 1758
order to supplier: creation 44.60 1315 5352
order to supplier: removal 3.29 115817 395
invoice (draft): creation 42.74 3131 5129
invoice (draft): removal 52.12 817 6254
invoice accept: apply 39.77 18589 4772
invoice accept: cancel 47.12 784 5654
customer reserve: creation 3694.58 182 443349
customer reserve: removal 4666.22 63 559946
realization accept: apply 80.62 187 9674
realization accept: cancel 79.01 119 9481
payment from customer: creation 57.53 135 6903
payment from customer: removal 5.40 108 648
payment to supplier: creation 47.18 148 5661
payment to supplier: removal 3.15 80 378
service: total inventory turnovers 4.93 1073 592
service: total monetary turnovers 6.38 28 766
service: aggregate perf. data 0.82 20059 98
service: refresh index statistics 0.03 255839 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4167
TEST_TIME 2 6047
TEST_TIME 3 5697
TEST_TIME 4 5215
TEST_TIME 5 5425
TEST_TIME 6 5118
TEST_TIME 7 5573
TEST_TIME 8 5932
TEST_TIME 9 5854
TEST_TIME 10 6207
TEST_TIME 11 6598
TEST_TIME 12 6670
TEST_TIME 13 6533
TEST_TIME 14 6903
TEST_TIME 15 6874
TEST_TIME 16 6985
TEST_TIME 17 7253
TEST_TIME 18 7513
TEST_TIME 19 7571
TEST_TIME 20 8037
TEST_TIME 21 8159
TEST_TIME 22 8763
TEST_TIME 23 8976
TEST_TIME 24 8853
TEST_TIME 25 8686
TEST_TIME 26 9347
TEST_TIME 27 9454
TEST_TIME 28 9824
TEST_TIME 29 11292
TEST_TIME 30 11187
TEST_TIME 31 10961
TEST_TIME 32 11044
TEST_TIME 33 11133
TEST_TIME 34 10996
TEST_TIME 35 10958
TEST_TIME 36 10690
TEST_TIME 37 10515
TEST_TIME 38 10453
TEST_TIME 39 10277
TEST_TIME 40 10141
TEST_TIME 41 10046
TEST_TIME 42 10001
TEST_TIME 43 9903
TEST_TIME 44 9891
TEST_TIME 45 9852
TEST_TIME 46 9709
TEST_TIME 47 9586
TEST_TIME 48 9636
TEST_TIME 49 9547
TEST_TIME 50 9434
TEST_TIME 51 9370
TEST_TIME 52 9359
TEST_TIME 53 9402
TEST_TIME 54 9298
TEST_TIME 55 9340
TEST_TIME 56 9412
TEST_TIME 57 9381
TEST_TIME 58 9305
TEST_TIME 59 9383
TEST_TIME 60 9356
TEST_TIME 61 9498
TEST_TIME 62 9518
TEST_TIME 63 9580
TEST_TIME 64 9518
TEST_TIME 65 9507
TEST_TIME 66 9564
TEST_TIME 67 9559
TEST_TIME 68 9602
TEST_TIME 69 9543
TEST_TIME 70 9464
TEST_TIME 71 9452
TEST_TIME 72 9486
TEST_TIME 73 9426
TEST_TIME 74 9367
TEST_TIME 75 9355
TEST_TIME 76 9345
TEST_TIME 77 9321
TEST_TIME 78 9260
TEST_TIME 79 9272
TEST_TIME 80 9206
TEST_TIME 81 9244
TEST_TIME 82 9269
TEST_TIME 83 9228
TEST_TIME 84 9243
TEST_TIME 85 9280
TEST_TIME 86 9293
TEST_TIME 87 9275
TEST_TIME 88 9314
TEST_TIME 89 9312
TEST_TIME 90 9308
TEST_TIME 91 9313
TEST_TIME 92 9303
TEST_TIME 93 9300
TEST_TIME 94 9211
TEST_TIME 95 9205
TEST_TIME 96 9185
TEST_TIME 97 9115
TEST_TIME 98 9114
TEST_TIME 99 9081
TEST_TIME 100 9088
TEST_TIME 101 9070
TEST_TIME 102 9082
TEST_TIME 103 9078
TEST_TIME 104 9115
TEST_TIME 105 9114
TEST_TIME 106 9144
TEST_TIME 107 9154
TEST_TIME 108 9131
TEST_TIME 109 9227
TEST_TIME 110 9240
TEST_TIME 111 9253
TEST_TIME 112 9267
TEST_TIME 113 9295
TEST_TIME 114 9218
TEST_TIME 115 9209
TEST_TIME 116 9177
TEST_TIME 117 9153
TEST_TIME 118 9101
TEST_TIME 119 9108
TEST_TIME 120 9057

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2021 16:29:04 to 21-03-2021 16:29:07.

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 1496382 1496382 0 0.00 0 34520 6 0 0
doc_list_biud 1496380 1496380 0 0.00 0 46506 30 0 0
sp_add_invoice_to_stock 4914 4772 142 2.88 36 203597 18589 0 142
sp_cancel_adding_invoice 5654 5654 0 0.00 4 76697 785 0 0
sp_cancel_client_order 1758 1758 0 0.00 4 22983 339 0 0
sp_cancel_customer_reserve 559946 559946 0 0.00 1 34033 64 0 0
sp_cancel_pay_from_customer 648 648 0 0.00 3 16185 108 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 3 2804 80 0 0
sp_cancel_supplier_invoice 6266 6254 12 0.19 2 35392 818 0 12
sp_cancel_supplier_order 395 395 0 0.00 12 1029653 115818 0 0
sp_cancel_write_off 9481 9481 0 0.00 1 23682 119 0 0
sp_client_order 19606 19606 0 0.00 3 34710 355 0 0
sp_customer_reserve 443349 443349 0 0.00 0 127981 183 0 0
sp_fill_shopping_cart 30084 30084 0 0.00 1 13925 34 0 0
sp_fill_shopping_cart_clo_res 443345 443345 0 0.00 0 12190 12 0 0
sp_get_clo_for_invoice 4764 4764 0 0.00 0 31719 312 0 0
sp_kill_cost_storno 16161 16161 0 0.00 0 21658 66 0 0
sp_kill_qstorno_ret_qs2qd 1136022 1136022 0 0.00 0 35373 34 0 0
sp_kill_qty_storno 597924 597924 0 0.00 0 46505 74 0 0
sp_lock_selected_doc 19993 19993 0 0.00 0 6064 6 0 0
sp_make_cost_storno 27001 27001 0 0.00 0 12719 56 0 0
sp_multiply_rows_for_pdistr 27001 27001 0 0.00 0 7578 33 0 0
sp_multiply_rows_for_qdistr 19606 19606 0 0.00 0 11859 139 0 0
sp_pay_from_customer 6903 6903 0 0.00 4 22809 135 0 0
sp_pay_to_supplier 5661 5661 0 0.00 5 29924 149 0 0
sp_payment_common 12564 12564 0 0.00 1 10698 26 0 0
sp_qd_handle_on_cancel_clo 1758 1758 0 0.00 0 8260 299 0 0
sp_qd_handle_on_invoice_upd_sts 10417 10417 0 0.00 0 46505 355 0 0
sp_qd_handle_on_reserve_upd_sts 9673 9673 0 0.00 0 17553 63 0 0
sp_reserve_write_off 9674 9674 0 0.00 6 23416 187 0 0
sp_supplier_invoice 5129 5129 0 0.00 8 96423 3132 0 0
sp_supplier_order 5352 5352 0 0.00 6 39524 1316 0 0
srv_aggregate_perf_data 98 98 0 0.00 2529 162941 20059 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1592 167106 34294 0 0
srv_find_qd_qs_mism 1040360 1040360 0 0.00 0 34519 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 35 66462 1073 0 0
srv_make_money_saldo 766 766 0 0.00 1 1297 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 168027 440868 255839 0 0
t$perf-abend:sp_add_invoice_to_stock 142 142 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4772 4772 0 0.00 0 14764 172 0 0
t$perf-norm:sp_cancel_adding_invoice 349 349 0 0.00 0 3661 118 0 0
t$perf-norm:sp_cancel_client_order 1758 1758 0 0.00 0 2954 15 0 0
t$perf-norm:sp_cancel_customer_reserve 691 691 0 0.00 0 987 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 648 648 0 0.00 0 472 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 135 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 686 13 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 36007 2084 0 0
t$perf-norm:sp_cancel_write_off 947 947 0 0.00 0 3254 10 0 0
t$perf-norm:sp_client_order 19606 19606 0 0.00 0 17948 22 0 0
t$perf-norm:sp_customer_reserve 962 962 0 0.00 0 4395 8 0 0
t$perf-norm:sp_pay_from_customer 6903 6903 0 0.00 0 8347 10 0 0
t$perf-norm:sp_pay_to_supplier 5661 5661 0 0.00 0 15690 17 0 0
t$perf-norm:sp_reserve_write_off 9674 9674 0 0.00 0 6598 13 0 0
t$perf-norm:sp_supplier_invoice 5129 5129 0 0.00 0 9632 30 0 0
t$perf-norm:sp_supplier_order 5352 5352 0 0.00 0 5532 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 2030 43 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 4978 40 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 1276 26 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 593 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 9810 9526 284 2.89 0 22153 25 0 284
v_all_customers 36156 36156 0 0.00 0 149 1 0 0
v_all_suppliers 29372 29372 0 0.00 0 17 1 0 0
v_all_wares 39210 39210 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 698 698 0 0.00 0 13653 26 0 0
v_cancel_client_order 3516 3516 0 0.00 0 22767 14 0 0
v_cancel_customer_prepayment 1296 1296 0 0.00 0 16152 18 0 0
v_cancel_customer_reserve 1382 1382 0 0.00 0 4514 11 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 2784 13 0 0
v_cancel_supplier_invoice 806 782 24 2.97 0 1704 16 0 24
v_cancel_supplier_order 790 790 0 0.00 0 2181 8 0 0
v_cancel_write_off 1894 1894 0 0.00 0 23485 26 0 0
v_max_id_clo_ord 5351 5351 0 0.00 0 1022 1 0 0
v_max_id_clo_res 962 962 0 0.00 0 7144 22 0 0
v_max_id_ord_sup 5128 5128 0 0.00 0 3511 2 0 0
v_max_non_paid_invoice 1454 1454 0 0.00 0 225 2 0 0
v_max_non_paid_realizn 3600 3600 0 0.00 0 1261 3 0 0
v_min_id_clo_ord 5351 5351 0 0.00 0 1137 4 0 0
v_min_id_clo_res 962 962 0 0.00 0 2203 10 0 0
v_min_id_ord_sup 5128 5128 0 0.00 0 4159 6 0 0
v_min_non_paid_invoice 5661 5661 0 0.00 0 10195 15 0 0
v_min_non_paid_realizn 6903 6903 0 0.00 0 8818 19 0 0
v_our_firm 9660 9660 0 0.00 0 25 1 0 0
v_reserve_write_off 19346 19346 0 0.00 0 23309 8 0 0
x_lock_depdocs_on_canc_invoice 11517 11517 0 0.00 0 31069 130 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 19839 405 0 0
x_make_qstorno_1000_1200 5352 5352 0 0.00 2 39512 1233 0 0
x_make_qstorno_1200_2000 5129 5129 0 0.00 3 92197 3021 0 0
x_make_qstorno_2100_3300 443349 443349 0 0.00 0 127980 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2021 16:29:08 to 21-03-2021 16:29:12.

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:25 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:32 10110 8192000000 10212310720 10517004288 836282048 9.262 67 50 100 0 854943936 2200240 16461648
13:57:53 26255 8192000000 10339366512 10661318656 1389924144 14.505 100 79 158 0 1419362560 4570224 24868192
13:58:32 18941 8192000000 10389413840 10710781952 1440379104 14.953 100 91 182 0 1476594704 6724400 29491200
13:59:00 9347 8192000000 10396275488 10723254272 1457627632 15.105 100 89 178 1 1494076880 7355568 29093680
13:59:17 26624 8192000000 10433346112 10764361728 1489281344 15.383 100 88 176 1 1525374128 8097792 27994992
13:59:59 22482 8192000000 10466582944 10803412992 1513631408 15.595 100 87 174 0 1550229440 8954448 27643584
14:00:34 20462 8192000000 10482029568 10822762496 1535488256 15.785 100 88 176 0 1573248816 9601776 28158784
14:01:05 23768 8192000000 10492225312 10837979136 1550726512 15.916 100 82 164 0 1586651136 9773744 26150880
14:01:43 13007 8192000000 10505363328 10855485440 1563820272 16.029 100 81 162 0 1600149552 10369376 25959904
14:02:07 19232 8192000000 10524665520 10875891712 1579518320 16.164 100 79 158 1 1614522704 9942160 25062224
14:02:44 18922 8192000000 10536988912 10897764352 1600253392 16.342 100 78 155 2 1634905408 10289696 24362320
14:03:11 9429 8192000000 10570637984 10932199424 1633238688 16.622 100 74 148 0 1666484816 10583616 22662512
14:03:31 11969 8192000000 10595966112 10957430784 1652367168 16.784 100 78 155 1 1686574656 11931344 22276144
14:03:50 10223 8192000000 10625511120 10990030848 1675390368 16.979 100 83 165 3 1710749344 12035856 23323120
14:04:10 9673 8192000000 10623771248 10994503680 1691374464 17.113 100 77 152 2 1726310544 13088784 21847296
14:04:29 7280 8192000000 10660475168 11029422080 1712069744 17.286 100 77 153 2 1746411536 12296320 22045472
14:04:44 4817 8192000000 10656535104 11034361856 1721791808 17.367 100 75 150 3 1756347888 13264384 21291696
14:04:56 6372 8192000000 10678488432 11050004480 1734052304 17.469 100 78 156 0 1768927408 13280816 21594288
14:05:09 5495 8192000000 10679786368 11056844800 1743336336 17.546 100 84 165 1 1780287392 13470336 23480720
14:05:22 5258 8192000000 10698029280 11076964352 1756183680 17.653 100 72 144 0 1789832800 13552400 20096720
14:05:34 4722 8192000000 10708420512 11085357056 1766826448 17.741 100 77 154 1 1802477120 14349280 21301392
14:05:46 6605 8192000000 10712814512 11097735168 1775293504 17.811 100 71 142 0 1808519280 13133792 20091984
14:05:59 3561 8192000000 10730908992 11112386560 1791192912 17.942 100 84 169 0 1828509184 13426656 23889616
14:06:09 10277 8192000000 10720704384 11113697280 1793542064 17.961 100 72 144 1 1831091248 17586976 19962208
14:06:26 4809 8192000000 10733510640 11120316416 1797917952 17.997 100 71 142 0 1829859440 12096320 19845168
14:06:37 3088 8192000000 10750728848 11136774144 1811276928 18.106 100 82 163 4 1846705776 12371744 23057104
14:06:47 3164 8192000000 10757643280 11146444800 1818348048 18.164 100 85 170 0 1856805584 14052800 24404736
14:06:57 3865 8192000000 10764266192 11151540224 1823365200 18.205 100 84 168 0 1861850320 14259696 24225424
14:07:08 3621 8192000000 10773921728 11163750400 1830904336 18.267 100 90 180 2 1870289984 13668704 25716944
14:07:18 2701 8192000000 10779282992 11164991488 1834566768 18.297 100 89 177 1 1873488432 14337344 24584320
14:07:27 1651 8192000000 10773322368 11164987392 1836968592 18.316 100 88 176 0 1876825712 14569984 25287136
14:07:36 3080 8192000000 10783290416 11169603584 1842033680 18.357 100 87 173 1 1879951792 13001520 24916592
14:07:45 2222 8192000000 10788604912 11181248512 1849315872 18.417 100 85 170 1 1884318352 11057808 23944672
14:07:54 2751 8192000000 10796970160 11184160768 1857653392 18.484 100 88 177 1 1893590432 11323104 24613936
14:08:04 2139 8192000000 10807987584 11193643008 1861797040 18.518 100 88 175 1 1899597728 12468560 25332128
14:08:12 1703 8192000000 10804592240 11190030336 1860618848 18.508 100 91 182 0 1900938304 13613792 26705664
14:08:20 2015 8192000000 10806036688 11193053184 1860922032 18.511 100 88 176 0 1898108528 11668288 25518208
14:08:29 1256 8192000000 10813855088 11203321856 1870931488 18.592 100 92 185 1 1909044592 11761408 26351696
14:08:36 1089 8192000000 10813175104 11202682880 1870645984 18.590 100 87 178 0 1906947040 11054688 25246368
14:08:44 1434 8192000000 10818180544 11206176768 1874912496 18.624 100 97 196 0 1913622544 11089056 27620992
14:08:51 32090 8192000000 10819522624 11212984320 1871672592 18.598 100 62 125 1 1897088496 8418192 16997712
14:09:30 2369 8192000000 10826324176 11221929984 1877268864 18.643 100 84 167 2 1909865872 8643632 23953376
14:09:40 2350 8192000000 10802502480 11215716352 1878719920 18.655 100 53 108 0 1902435936 8785248 14930768
14:09:49 3463 8192000000 10811774704 11218153472 1881091184 18.674 100 54 109 1 1906372016 9047824 16233008
14:10:01 3623 8192000000 10810923504 11222687744 1883429504 18.693 100 48 96 0 1905646736 8872368 13344864
14:10:11 7418 8192000000 10803679600 11223134208 1885516960 18.710 100 39 75 2 1903196032 7343248 10335824
14:10:26 4004 8192000000 10790904080 11221680128 1886414768 18.717 100 38 76 3 1904688256 7590464 10683024
14:10:37 3510 8192000000 10802814928 11230470144 1888296672 18.732 100 36 73 0 1906148080 7592480 10258928
14:10:49 3995 8192000000 10816141024 11232051200 1891165008 18.755 100 33 65 3 1907775248 7071200 9539040
14:11:00 7148 8192000000 10810065680 11238662144 1894380800 18.781 100 31 63 2 1913691328 10904336 8406192
14:11:13 13829 8192000000 10810650784 11236270080 1891245920 18.756 100 20 40 1 1903963616 7340544 5377152
14:11:35 10829 8192000000 10802738320 11233337344 1891104432 18.755 100 13 26 1 1900496512 5687936 3704144
14:11:52 60136 8192000000 10815339968 11244306432 1897000656 18.802 100 37 70 1 1913347824 5287536 11059632
14:12:58 12512 8192000000 10810300032 11243479040 1897706800 18.808 100 22 44 1 1909403664 5648576 6048288
14:13:18 4150 8192000000 10824161008 11252797440 1902618768 18.847 100 42 84 3 1921721584 7052528 12050288
14:13:30 7407 8192000000 10821108368 11251609600 1903108096 18.851 100 31 62 1 1923507312 11879072 8520144
14:13:45 10378 8192000000 10818937808 11251630080 1901574112 18.839 100 24 48 1 1918879840 10645040 6660688
14:14:02 7732 8192000000 10819006144 11255668736 1904859424 18.865 100 31 62 0 1921263856 7167328 9237104
14:14:16 6047 8192000000 10820137024 11254693888 1905684000 18.872 100 29 58 0 1919950240 6472496 7793744
14:14:29 3437 8192000000 10825895856 11257139200 1909410912 18.902 100 38 75 0 1928371616 7542512 11418192
14:14:39 5863 8192000000 10817491888 11254509568 1907240432 18.884 100 20 40 0 1919330064 5883984 6205648
14:14:52 11401 8192000000 10826038496 11266080768 1909257312 18.901 100 19 38 2 1920660944 6290672 5112960
14:15:10 7603 8192000000 10830433120 11261362176 1911258960 18.917 100 20 40 2 1924469040 5873840 7336240
14:15:28 5246 8192000000 10821868304 11256557568 1893856272 18.777 99 26 52 1 1908546672 6854736 7835664
14:15:39 7580 8192000000 10825187456 11262070784 1912617536 18.928 100 29 58 2 1928584816 7169872 8797408
14:15:53 14636 8192000000 10818750672 11252047872 1895762304 18.792 99 20 40 1 1907240112 5278800 6199008
14:16:15 65842 8192000000 10816667440 11231412224 1822956496 18.202 95 38 75 2 1839399664 4544928 11898240
14:17:29 13963 8192000000 10798494400 11231035392 1858666288 18.492 98 20 38 4 1869754480 5797136 5291056
14:17:50 8415 8192000000 10792147424 11223855104 1838975280 18.332 97 26 52 1 1852447712 6560784 6911648
14:18:06 6284 8192000000 10793769984 11225247744 1877274592 18.643 100 31 61 1 1892544672 6947232 8322848
14:18:20 3696 8192000000 10777374016 11206082560 1841281360 18.351 98 36 71 2 1858592016 6417712 10892944
14:18:32 4419 8192000000 10767860976 11182997504 1822549344 18.199 99 23 46 2 1835258352 5471376 7237632
14:18:44 5798 8192000000 10744392496 11164901376 1761714864 17.699 95 25 48 2 1775381376 5213136 8453376
14:18:58 4014 8192000000 10743094576 11152523264 1770738144 17.773 96 39 78 0 1789550288 8055568 10756576
14:19:12 7045 8192000000 10721747568 11144884224 1757356208 17.663 96 23 44 2 1770103760 6206400 6541152
14:19:27 6567 8192000000 10726606384 11152035840 1806968784 18.071 99 25 49 2 1819742048 5770560 7002704
14:19:41 9414 8192000000 10709860768 11127541760 1721614080 17.366 94 13 24 1 1731004288 5652512 3737696
14:19:59 8161 8192000000 10712581232 11126452224 1748151440 17.586 96 25 50 1 1761372016 6205760 7014816
14:20:14 9868 8192000000 10712602336 11129335808 1723344320 17.380 95 26 53 0 1736065168 5428304 7292544
14:20:30 6006 8192000000 10707961072 11123359744 1753041984 17.627 97 26 51 2 1765327392 5184352 7101056
14:20:46 11558 8192000000 10699900288 11123752960 1749269408 17.596 97 22 44 1 1762259936 6917968 6072560
14:21:09 16679 8192000000 10707125968 11115421696 1743618688 17.549 97 27 54 0 1757137088 5279424 8238976
14:21:34 65482 8192000000 10697809280 11119824896 1710938912 17.277 95 24 48 2 1723005344 5056736 7009696
14:22:48 8539 8192000000 10734520048 11138310144 1775761328 17.815 98 33 66 2 1791949936 6494224 9694384
14:23:02 5341 8192000000 10738603520 11149606912 1800313904 18.016 99 46 91 2 1821996208 8089552 13592752
14:23:16 6617 8192000000 10742879904 11155988480 1810300528 18.098 99 42 82 0 1828984400 7311152 11372720
14:23:30 8140 8192000000 10744073744 11165048832 1815526688 18.141 99 30 60 3 1830654672 6761712 8366272
14:23:48 6849 8192000000 10762587696 11180539904 1842981424 18.365 100 35 71 1 1858222448 4873712 10367312
14:24:03 5122 8192000000 10765395104 11186053120 1849650112 18.419 100 43 84 4 1868755584 6532448 12573024
14:24:19 8093 8192000000 10767482976 11189338112 1849272672 18.416 100 33 67 1 1865241040 6740768 9227600
14:24:34 9119 8192000000 10767810400 11189661696 1851258848 18.432 100 28 55 4 1864430896 5402000 7770048
14:24:49 9643 8192000000 10763868608 11191500800 1850799120 18.429 100 19 38 1 1862218960 5984288 5435552
14:25:05 5188 8192000000 10782810480 11200335872 1857127712 18.480 100 29 57 1 1871857568 5751200 8978656
14:25:19 10319 8192000000 10793607216 11209105408 1863227792 18.529 100 23 46 2 1875243184 5338960 6676432
14:25:38 7200 8192000000 10779361776 11209928704 1870455200 18.588 100 29 60 0 1884755312 6345424 7954688
14:25:56 10086 8192000000 10787322224 11216986112 1875073984 18.625 100 27 54 0 1888984864 5736256 8174624
14:26:16 71892 8192000000 10815059616 11241267200 1885958032 18.713 100 23 46 1 1898544928 4971360 7615536
14:27:40 59447 8192000000 10861927632 11279011840 1920060352 18.987 100 52 105 1 1946772768 11697808 15014608
14:28:47 17798 8192000000 10851122848 11284496384 1925198368 19.028 100 50 100 2 1951779632 12468176 14113088
14:29:15 6212 8192000000 10860100560 11287412736 1933614992 19.096 100 49 97 1 1958231392 11048000 13568400
14:29:29 2867 8192000000 10887468320 11304198144 1943022688 19.171 100 67 134 1 1973445968 10956656 19466624
14:29:39 15078 8192000000 10878262016 11304747008 1943397152 19.174 100 50 99 1 1969513840 12220768 13895920
14:30:01 11636 8192000000 10887489936 11308711936 1948529808 19.215 100 56 112 1 1979320208 13334480 17455920
14:31:14 31190 8192000000 10897431952 11332366336 1959453248 19.302 100 47 94 3 1987449792 14407984 13588560
14:31:52 24267 8192000000 10908234064 11343134720 1970851168 19.392 100 49 93 1 2000683872 16557488 13275216
14:32:27 15214 8192000000 10916020464 11352199168 1972943952 19.409 100 39 77 2 2004166048 19774016 11448080
14:32:50 5204 8192000000 10918829184 11353337856 1978180240 19.450 100 56 109 1 2018957712 24672080 16105392
14:33:04 7994 8192000000 10929486000 11359744000 1981986880 19.480 100 62 124 1 2020958096 20725904 18245312
14:33:20 10717 8192000000 10936769040 11365744640 1982916384 19.488 100 57 114 0 2022075600 22714416 16444800
14:33:37 5166 8192000000 10945995152 11370962944 1986465840 19.516 100 69 134 1 2030052768 23700512 19886416
14:34:02 3375 8192000000 10938481504 11375722496 1985807600 19.511 100 54 108 0 2033165584 31215488 16142496
14:34:13 3215 8192000000 10935522400 11368894464 1985549280 19.509 100 49 98 1 2027013680 27254336 14210064
14:34:32 8490 8192000000 10929421024 11360849920 1981935152 19.480 100 56 112 3 2020103008 22043216 16124640
14:34:50 7747 8192000000 10949845712 11365580800 1985344224 19.507 100 79 157 2 2034600208 26887216 22368768
14:35:04 3986 8192000000 10947041504 11362803712 1984937968 19.504 100 85 169 1 2038504704 28596256 24970480
14:35:18 13433 8192000000 10943062832 11367575552 1986506496 19.516 100 70 140 0 2036074352 28509488 21058368
14:35:39 15187 8192000000 10939879376 11372584960 1987884608 19.527 100 61 122 0 2034285920 28028560 18372752
14:36:04 20417 8192000000 10933593616 11373801472 1984702736 19.502 100 32 64 1 2022565296 26250768 11611792
14:36:31 24863 8192000000 10958526416 11396374528 2002809264 19.645 100 47 94 3 2047919616 29808192 15302160
14:37:05 10549 8192000000 10962873488 11393327104 1986209008 19.514 99 53 106 5 2032848464 29653008 16986448
14:37:24 14767 8192000000 10965172864 11400663040 2008096864 19.687 100 68 137 1 2058973360 29864800 21011696
14:37:50 9271 8192000000 10967750176 11399446528 1993869392 19.574 99 59 118 0 2043491296 31419376 18202528
14:38:07 4610 8192000000 10980672096 11409932288 2012006544 19.717 100 57 114 1 2061150512 32219920 16924048
14:38:19 2851 8192000000 10966506752 11404267520 1997997856 19.607 99 58 117 0 2047292288 31968144 17326288
14:38:32 4868 8192000000 10955438720 11389288448 1992474192 19.563 100 57 112 2 2041383856 32000512 16909152
14:38:44 2584 8192000000 10929859280 11348566016 1945838912 19.193 97 74 147 0 2000887280 32689888 22358480
14:39:07 23563 8192000000 10941898400 11383263232 1987134736 19.521 100 50 100 2 2029697552 27837552 14725264
14:39:40 3162 8192000000 10968268688 11389456384 1998644720 19.612 100 67 131 4 2045718160 27548944 19524496
14:39:52 4810 8192000000 10953120112 11385384960 1993997936 19.575 100 64 127 1 2040979616 28072336 18909344
14:40:04 7733 8192000000 10964003776 11393445888 2000569152 19.627 100 59 117 0 2046994528 28861792 17563584
14:40:32 5907 8192000000 10974798208 11397562368 2004512432 19.658 100 76 152 1 2059108704 31457312 23138960
14:40:46 2886 8192000000 10980150112 11406630912 2008938288 19.693 100 79 158 2 2065045200 32659536 23447376
14:40:57 5358 8192000000 10978440976 11403956224 2005915712 19.669 100 74 149 1 2062885296 33562448 23407136
14:41:09 7541 8192000000 10979548384 11405471744 1998585904 19.612 100 69 139 1 2057787840 38842928 20359008
14:41:24 2104 8192000000 10996176576 11416915968 2012626576 19.722 100 88 175 0 2081036768 42104144 26306048
14:41:35 3272 8192000000 10981513744 11405344768 2006254960 19.672 100 70 139 2 2064937808 37944416 20738432
14:41:45 1615 8192000000 10971209152 11387428864 1973901328 19.416 98 80 158 0 2034690816 36993872 23795616
14:41:54 2132 8192000000 10984598208 11409842176 2007995856 19.686 100 72 145 2 2066823424 37505296 21322272
14:42:04 3539 8192000000 10993119488 11416473600 2013617936 19.730 100 78 154 1 2073637872 37162256 22857680
14:42:19 7236 8192000000 10996178464 11421147136 2018244880 19.766 100 80 160 0 2081011376 39020560 23745936
14:42:34 11293 8192000000 10973410016 11403804672 1992081488 19.560 99 69 136 1 2052578240 39790080 20706672
14:42:55 6131 8192000000 10924618880 11356581888 1940498080 19.151 99 62 122 3 1998969088 39886528 18584480
14:43:10 2363 8192000000 10959216832 11373793280 1976312096 19.435 100 76 150 1 2038430640 39625312 22493232
14:43:20 6381 8192000000 10960775120 11382329344 1983551920 19.493 100 79 152 2 2049049024 41627456 23869648
14:43:33 6213 8192000000 10973727440 11386527744 1970901856 19.393 99 83 166 2 2041484592 44762352 25820384
14:43:48 3467 8192000000 10974869216 11391594496 1986897264 19.519 100 84 168 3 2056638016 43892608 25848144
14:43:58 1591 8192000000 10927193456 11339821056 1932059520 19.083 97 83 165 0 2002735280 45062528 25613232
14:44:09 4942 8192000000 10944565088 11365269504 1946230592 19.196 99 63 126 0 2012102144 46091360 19780192
14:44:21 2206 8192000000 10937708144 11342856192 1949566560 19.223 99 81 158 2 2015639792 41830768 24242464
14:44:30 8847 8192000000 10960507808 11371016192 1968705344 19.375 100 81 162 0 2037822832 43483520 25633968
14:44:45 4219 8192000000 10951273648 11365199872 1966016128 19.354 100 81 159 1 2036269584 44598464 25654992
14:44:57 8727 8192000000 10953937984 11374354432 1972445968 19.405 100 70 139 0 2040277520 46428752 21402800
14:45:13 2656 8192000000 10959773632 11375902720 1976957360 19.441 100 82 158 3 2045417664 43717968 24742336
14:45:24 2798 8192000000 10962553504 11379093504 1977643152 19.446 100 81 162 1 2047510432 43996864 25870416
14:45:36 2553 8192000000 10974041568 11381329920 1951404320 19.238 98 92 184 2 2027946944 48115632 28426992
14:45:48 5562 8192000000 10959446992 11386093568 1976806080 19.439 100 68 136 0 2048458096 49701504 21950512
14:46:04 2010 8192000000 10958488416 11363598336 1960398000 19.309 100 86 172 1 2038159856 50128592 27633264
14:46:13 2211 8192000000 10970521344 11387875328 1975943984 19.433 100 84 167 2 2055816848 52846128 27026736
14:46:24 10500 8192000000 10968301664 11391463424 1974131776 19.418 100 65 127 0 2048666592 54610560 19924256
14:46:43 7054 8192000000 10987807280 11405897728 1989130672 19.537 100 69 137 1 2068414320 57019408 22264240
14:46:58 2898 8192000000 10975440736 11399032832 1980803120 19.471 100 74 146 1 2060915248 57669792 22442336
14:47:08 6642 8192000000 10979972000 11398868992 1980690992 19.470 100 77 153 2 2064361216 59283584 24386640
14:47:24 3286 8192000000 10987261648 11401080832 1983348464 19.491 100 87 174 2 2069197552 57874336 27974752
14:47:33 4542 8192000000 10969750960 11391938560 1966848848 19.360 99 68 134 1 2044608256 56591264 21168144
14:47:49 4609 8192000000 10962384688 11381522432 1965367536 19.349 100 66 132 1 2042969312 56140464 21461312
14:48:02 5783 8192000000 10955740032 11373342720 1948636896 19.216 99 71 138 3 2025851408 54321280 22893232
14:48:16 8324 8192000000 10947998976 11377856512 1963217120 19.332 100 44 88 0 2033661904 55476832 14967952
14:48:32 4117 8192000000 10959055520 11379994624 1950497968 19.230 99 65 129 4 2028611792 56515968 21597856
14:48:43 2418 8192000000 10983265904 11395952640 1977652352 19.446 100 79 158 0 2062859152 58979184 26227616
14:48:52 1993 8192000000 10989522576 11405410304 1983120368 19.489 100 84 166 2 2071513280 60993408 27399504
14:49:05 3748 8192000000 10983416656 11406192640 1985944736 19.512 100 74 150 0 2067785424 57235376 24605312
14:49:19 5552 8192000000 10963031616 11401781248 1983185840 19.490 100 49 98 0 2051014560 51212704 16616016
14:49:39 14246 8192000000 10959600592 11403284480 1966281328 19.356 99 45 90 2 2032297792 50715600 15300864
14:50:12 3320 8192000000 10977763488 11408576512 1991692304 19.557 100 62 122 1 2060270480 47756784 20821392
14:50:22 7534 8192000000 10984636176 11405119488 1989570288 19.540 100 68 135 0 2063416608 51079216 22767104
14:50:37 2634 8192000000 11002145312 11418095616 1999782576 19.621 100 93 183 0 2085227024 57446272 27998176
14:50:46 5136 8192000000 10986186048 11415584768 1999513024 19.619 100 71 142 1 2070890240 49167232 22209984
14:50:58 9251 8192000000 10989112704 11425968128 2005147344 19.663 100 61 122 0 2072783648 48567344 19068960
14:51:34 31897 8192000000 10966005760 11404378112 1971557760 19.398 99 39 78 1 2037049296 51948928 13542608
14:52:13 17522 8192000000 10969790704 11406245888 1981540112 19.477 100 38 76 0 2047432816 52862336 13030368
14:52:37 9884 8192000000 10976425408 11414269952 1988036176 19.528 100 52 104 0 2062859008 57038096 17784736
14:53:03 12066 8192000000 10974853728 11417714688 1988155152 19.529 100 48 96 1 2066353328 61467696 16730480
14:53:36 17327 8192000000 10962709360 11438096384 1987180400 19.522 100 32 64 2 2062932832 63859616 11892816
14:54:14 21099 8192000000 10953155728 11414011904 1982919568 19.488 100 23 46 1 2042877664 52195744 7762352
14:55:17 24350 8192000000 10946263024 11414544384 1958849008 19.297 100 21 41 0 2033616112 66407760 8359344
14:55:49 15393 8192000000 10944378592 11423375360 1955653744 19.271 100 14 28 0 2027858288 66500912 5703632
14:56:12 13274 8192000000 10927614960 11392016384 1947111792 19.203 100 17 34 3 2015510096 62289776 6108528
14:56:32 26731 8192000000 10897793552 11391942656 1948515152 19.215 100 15 30 4 1997334224 43817328 5001744
14:57:05 67443 8192000000 10892496800 11351044096 1914356224 18.942 98 8 16 0 1930064800 14045872 1662704
14:58:22 19567 8192000000 10917999088 11354595328 1951822576 19.241 99 45 83 2 1975897264 12075440 11999248
14:58:49 14768 8192000000 10905143328 11358449664 1969149824 19.379 100 26 52 2 1989341904 12374848 7817232
14:59:49 48952 8192000000 10901111712 11376484352 1950758384 19.233 99 9 18 1 1963864400 11035872 2070144
15:00:45 77914 8192000000 10890742336 11346137088 1880231632 18.667 95 12 24 0 1896832208 13281632 3318944
15:02:30 114470 8192000000 10903753984 11348250624 1936800176 19.121 98 31 60 4 1956359248 9901904 9657168
15:04:31 42504 8192000000 10891528272 11348574208 1950772112 19.233 100 39 76 1 1973284912 11647312 10865488
15:05:28 26704 8192000000 10879060320 11355213824 1952590576 19.247 100 9 18 1 1965817968 10485968 2741424
15:06:15 167106 8192000000 10881058880 11349757952 1889462736 18.741 96 21 43 0 1909150304 13531760 6155808
15:09:08 78956 8192000000 10886766240 11362914304 1947992352 19.210 99 18 36 0 1968776624 15430288 5353984
15:11:17 132251 8192000000 10900687488 11372036096 1923400336 19.014 97 14 28 0 1937428752 10293488 3734928
15:13:51 112944 8192000000 10908384000 11390164992 1981964432 19.480 100 24 49 1 2002225712 13268560 6992720
15:16:07 39632 8192000000 10902692464 11383971840 1976888288 19.440 100 20 41 0 1995751104 13501952 5360864
15:16:52 6853 8192000000 10896301568 11383324672 1960799312 19.312 99 12 24 1 1980315536 16076272 3439952
15:17:13 44350 8192000000 10915066864 11380338688 1964517280 19.342 99 23 46 0 1985571632 14352672 6701680
15:18:03 88250 8192000000 10898776768 11390050304 1957540048 19.286 99 9 18 0 1982799856 22316208 2943600
15:19:41 56272 8192000000 10897460352 11391774720 1955346720 19.269 99 14 28 0 1983765296 24323520 4095056
15:20:56 56511 8192000000 10913601152 11389612032 1981928176 19.480 100 12 24 1 2002092032 16679584 3484272
15:22:20 74849 8192000000 10935418880 11402932224 1997136000 19.600 100 21 41 0 2023133808 18881936 7115872
15:23:42 41051 8192000000 10928196672 11402932224 1985971616 19.512 99 28 56 2 2002097952 8501072 7625264
15:24:40 50182 8192000000 10946408368 11411910656 2006845808 19.677 100 30 60 0 2024031344 8805616 8379920
15:25:43 69845 8192000000 10922825264 11409018880 1977296976 19.443 98 29 58 0 1999243824 13762256 8184592
15:26:59 48835 8192000000 10930945648 11399540736 1945965152 19.194 97 19 36 1 1965802928 15285408 4552368
15:27:55 106127 8192000000 10902295472 11388710912 1877833856 18.648 94 16 32 1 1900549616 18771360 3944400
15:29:48 116370 8192000000 10887400192 11351089152 1815310976 18.139 92 9 18 0 1827809584 10643520 1855088
15:31:54 76930 8192000000 10919909120 11379003392 1917382944 18.966 97 23 46 1 1935071552 11204752 6483856
15:33:17 124416 8192000000 10862115568 11332812800 1691154112 17.111 86 15 30 0 1710616080 15621312 3840656
15:35:42 140828 8192000000 10893884544 11337629696 1910526256 18.911 98 19 38 2 1930390944 14490384 5374304
15:38:12 85575 8192000000 10895865360 11343048704 1895368368 18.789 97 26 53 2 1916390080 13538368 7483344
15:39:53 52161 8192000000 10886876320 11356422144 1963186624 19.331 100 32 64 1 1981989760 10293600 8509536
15:41:02 31612 8192000000 10885036912 11334115328 1895104160 18.787 96 35 71 0 1913276512 8495088 9677264
15:41:41 56967 8192000000 10857313056 11330887680 1892990528 18.770 97 36 72 0 1914644048 11509312 10144208
15:43:22 72996 8192000000 10839914624 11319762944 1880636736 18.670 96 9 18 0 1895992032 12487920 2867376
15:44:45 45731 8192000000 10861846672 11343093760 1928873232 19.058 99 16 32 2 1943124624 9370688 4880704
15:45:37 26927 8192000000 10865036064 11348537344 1947976128 19.210 100 6 12 0 1962215648 12351472 1888048
15:46:11 33631 8192000000 10857284224 11341430784 1942186224 19.164 100 7 14 0 1956254448 11545280 2522944
15:47:12 42058 8192000000 10866154512 11343933440 1926885280 19.042 99 5 10 0 1936293600 8923248 485072
15:48:02 44043 8192000000 10848973232 11324010496 1905471344 18.870 98 20 40 0 1918808800 8021376 5316080
15:49:02 63273 8192000000 10848341440 11339485184 1886866928 18.721 97 16 33 2 1904200800 12758464 4575408
15:50:16 12787 8192000000 10880057344 11338067968 1946172016 19.196 100 44 87 2 1970049280 10281680 13595584
15:50:35 24011 8192000000 10870919472 11342041088 1943999168 19.179 100 29 58 2 1960485472 7710720 8775584
15:51:17 102342 8192000000 10865614288 11352485888 1897392512 18.805 97 13 26 1 1913410624 12205296 3812816
15:53:07 120282 8192000000 10872612848 11349598208 1860812688 18.510 95 12 24 1 1875749216 11952096 2984432
15:55:13 72302 8192000000 10880001104 11356057600 1907512592 18.887 98 11 22 1 1925548208 14551488 3484128
15:56:33 122193 8192000000 10867116048 11341541376 1814323360 18.131 93 11 22 0 1835732016 18804448 2604208
15:58:42 67276 8192000000 10866116592 11337003008 1864853216 18.543 96 13 26 0 1876947728 9111808 2982704
16:00:01 70668 8192000000 10889456752 11340525568 1894032800 18.778 97 28 56 4 1919485744 16687024 8765920
16:01:37 136119 8192000000 10875581360 11355299840 1942836304 19.169 99 42 84 0 1969485456 14992320 11656832
16:04:18 51523 8192000000 10884585360 11372048384 1964269568 19.340 100 9 17 1 1980704720 13649904 2785248
16:05:18 31232 8192000000 10888285168 11382321152 1966487344 19.358 100 9 18 0 1988989648 20345120 2157184
16:06:00 31463 8192000000 10888486080 11379146752 1970673952 19.391 100 12 24 0 1986000432 12309488 3016992
16:06:39 36717 8192000000 10884337776 11362103296 1936666848 19.120 98 13 26 0 1952256128 12083664 3505616
16:07:29 49992 8192000000 10900355584 11371200512 1949986160 19.226 99 16 32 0 1964637968 10886912 3764896
16:08:28 61838 8192000000 10908732800 11388694528 1935975696 19.115 98 12 23 1 1948338944 8919824 3443424
16:09:40 98423 8192000000 10923083168 11386957824 1960931888 19.313 99 14 28 1 1981072112 16096832 4043392
16:11:29 34076 8192000000 10887157760 11362394112 1934771008 19.105 98 17 34 1 1958383904 18448416 5164480
16:12:20 96069 8192000000 10893803120 11361099776 1907068208 18.883 97 23 46 0 1927550784 13747728 6734848
16:14:02 57721 8192000000 10889115568 11354697728 1929734640 19.065 98 16 32 0 1946853776 12361248 4757888
16:15:10 48990 8192000000 10880083056 11350097920 1917121952 18.964 98 21 42 1 1936922240 13585584 6214704
16:16:11 60274 8192000000 10882162512 11366191104 1931232384 19.077 99 9 18 0 1944805104 11026640 2546080
16:17:26 95047 8192000000 10902201104 11376623616 1910668656 18.912 97 13 26 0 1927699648 13409904 3621088
16:19:10 155082 8192000000 10857252912 11342888960 1778073280 17.834 90 9 19 0 1793836752 13415168 2348304
16:22:00 94402 8192000000 10877056320 11357138944 1935559136 19.111 100 17 34 0 1954564800 14116288 4889376
16:23:57 73991 8192000000 10861118848 11342475264 1892620896 18.767 97 9 19 1 1907718464 13122144 1975424
16:25:20 55420 8192000000 10876095200 11360915456 1953348192 19.253 100 9 18 0 1969268800 13370272 2550336
16:26:22 55048 8192000000 10861109856 11330859008 1871129376 18.593 96 7 14 1 1883149984 10116480 1904128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 21-03-2021 16:29:14 to 21-03-2021 16:29:45.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 142 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2021 16:29:46 to 21-03-2021 16:29:48.

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          235700
MON$OLDEST_ACTIVE               235701
MON$OLDEST_SNAPSHOT             235701
MON$NEXT_TRANSACTION            235701
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                       2030368
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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'

21.03.21 16:29:49. 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-21 16:29:51 No severe PSQL-related problems occured
21.03.21 16:29:52. End of report.