Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.02.2021 01:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17204248 kB
MemAvailable 31137820 kB
Buffers 0 kB
Cached 14483128 kB
SwapCached 4112 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-02-18 01:27:20
DTS_END                         2021-02-18 01:27:20.4840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43406
TRN_ID                          229890
ATT_ID                          655
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: 9249.22 22955 1109906
customer order: creation 160.48 380 19257
customer order: refuse 13.67 390 1640
order to supplier: creation 43.61 1349 5233
order to supplier: removal 3.25 105098 390
invoice (draft): creation 42.55 3482 5106
invoice (draft): removal 52.78 749 6334
invoice accept: apply 39.38 19654 4726
invoice accept: cancel 48.07 750 5768
customer reserve: creation 3775.57 188 453068
customer reserve: removal 4786.68 56 574402
realization accept: apply 77.00 213 9240
realization accept: cancel 83.31 113 9997
payment from customer: creation 55.86 152 6703
payment from customer: removal 5.63 87 675
payment to supplier: creation 46.36 158 5563
payment to supplier: removal 3.32 57 398
service: total inventory turnovers 4.58 1313 549
service: total monetary turnovers 6.27 33 752
service: aggregate perf. data 0.84 21620 101
service: refresh index statistics 0.03 303260 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2021 01:28:11 to 18-02-2021 01:28:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3869
TEST_TIME 2 3687
TEST_TIME 3 3904
TEST_TIME 4 3937
TEST_TIME 5 4869
TEST_TIME 6 4716
TEST_TIME 7 4833
TEST_TIME 8 4906
TEST_TIME 9 4989
TEST_TIME 10 5457
TEST_TIME 11 5450
TEST_TIME 12 5704
TEST_TIME 13 5911
TEST_TIME 14 6221
TEST_TIME 15 6586
TEST_TIME 16 6841
TEST_TIME 17 7211
TEST_TIME 18 7514
TEST_TIME 19 7933
TEST_TIME 20 8604
TEST_TIME 21 8856
TEST_TIME 22 9101
TEST_TIME 23 9006
TEST_TIME 24 9473
TEST_TIME 25 9855
TEST_TIME 26 10809
TEST_TIME 27 10653
TEST_TIME 28 10578
TEST_TIME 29 10288
TEST_TIME 30 10407
TEST_TIME 31 10255
TEST_TIME 32 10087
TEST_TIME 33 10114
TEST_TIME 34 9975
TEST_TIME 35 9774
TEST_TIME 36 9675
TEST_TIME 37 9788
TEST_TIME 38 9676
TEST_TIME 39 9674
TEST_TIME 40 9495
TEST_TIME 41 9463
TEST_TIME 42 9367
TEST_TIME 43 9256
TEST_TIME 44 9344
TEST_TIME 45 9442
TEST_TIME 46 9457
TEST_TIME 47 9381
TEST_TIME 48 9510
TEST_TIME 49 9405
TEST_TIME 50 9381
TEST_TIME 51 9530
TEST_TIME 52 9697
TEST_TIME 53 9700
TEST_TIME 54 9696
TEST_TIME 55 9840
TEST_TIME 56 9788
TEST_TIME 57 9689
TEST_TIME 58 9565
TEST_TIME 59 9480
TEST_TIME 60 9482
TEST_TIME 61 9462
TEST_TIME 62 9435
TEST_TIME 63 9417
TEST_TIME 64 9397
TEST_TIME 65 9342
TEST_TIME 66 9371
TEST_TIME 67 9445
TEST_TIME 68 9423
TEST_TIME 69 9374
TEST_TIME 70 9506
TEST_TIME 71 9502
TEST_TIME 72 9512
TEST_TIME 73 9502
TEST_TIME 74 9514
TEST_TIME 75 9542
TEST_TIME 76 9506
TEST_TIME 77 9488
TEST_TIME 78 9478
TEST_TIME 79 9412
TEST_TIME 80 9415
TEST_TIME 81 9333
TEST_TIME 82 9310
TEST_TIME 83 9300
TEST_TIME 84 9282
TEST_TIME 85 9298
TEST_TIME 86 9258
TEST_TIME 87 9325
TEST_TIME 88 9320
TEST_TIME 89 9342
TEST_TIME 90 9376
TEST_TIME 91 9357
TEST_TIME 92 9430
TEST_TIME 93 9447
TEST_TIME 94 9421
TEST_TIME 95 9401
TEST_TIME 96 9437
TEST_TIME 97 9446
TEST_TIME 98 9482
TEST_TIME 99 9471
TEST_TIME 100 9469
TEST_TIME 101 9602
TEST_TIME 102 9522
TEST_TIME 103 9473
TEST_TIME 104 9415
TEST_TIME 105 9410
TEST_TIME 106 9381
TEST_TIME 107 9359
TEST_TIME 108 9330
TEST_TIME 109 9320
TEST_TIME 110 9285
TEST_TIME 111 9256
TEST_TIME 112 9269
TEST_TIME 113 9277
TEST_TIME 114 9271
TEST_TIME 115 9249
TEST_TIME 116 9239
TEST_TIME 117 9209
TEST_TIME 118 9296
TEST_TIME 119 9276
TEST_TIME 120 9250

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2021 01:28:15 to 18-02-2021 01:28:18.

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 1527474 1527474 0 0.00 0 26019 7 0 0
doc_list_biud 1527464 1527464 0 0.00 0 33849 27 0 0
sp_add_invoice_to_stock 4821 4726 95 1.97 41 258719 19654 0 95
sp_cancel_adding_invoice 5768 5768 0 0.00 5 59265 751 0 0
sp_cancel_client_order 1640 1640 0 0.00 4 15982 390 0 0
sp_cancel_customer_reserve 574402 574402 0 0.00 1 33850 56 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 4378 87 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 1522 57 0 0
sp_cancel_supplier_invoice 6339 6334 5 0.07 2 28302 750 0 5
sp_cancel_supplier_order 390 390 0 0.00 9 1028367 105098 0 0
sp_cancel_write_off 9997 9997 0 0.00 1 12253 113 0 0
sp_client_order 19257 19257 0 0.00 3 15390 381 0 0
sp_customer_reserve 453068 453068 0 0.00 0 109311 188 0 0
sp_fill_shopping_cart 29590 29590 0 0.00 1 11108 39 0 0
sp_fill_shopping_cart_clo_res 453066 453066 0 0.00 0 29686 14 0 0
sp_get_clo_for_invoice 4724 4724 0 0.00 0 21674 300 0 0
sp_kill_cost_storno 16838 16838 0 0.00 0 10671 55 0 0
sp_kill_qstorno_ret_qs2qd 1165525 1165525 0 0.00 0 33819 30 0 0
sp_kill_qty_storno 612490 612490 0 0.00 0 33849 66 0 0
sp_lock_selected_doc 19371 19371 0 0.00 0 8059 5 0 0
sp_make_cost_storno 26230 26230 0 0.00 0 25679 73 0 0
sp_multiply_rows_for_pdistr 26228 26228 0 0.00 0 24821 38 0 0
sp_multiply_rows_for_qdistr 19257 19257 0 0.00 0 11631 164 0 0
sp_pay_from_customer 6703 6703 0 0.00 4 26315 153 0 0
sp_pay_to_supplier 5563 5563 0 0.00 5 25841 159 0 0
sp_payment_common 12266 12266 0 0.00 1 26299 35 0 0
sp_qd_handle_on_cancel_clo 1640 1640 0 0.00 0 15955 354 0 0
sp_qd_handle_on_invoice_upd_sts 10490 10490 0 0.00 0 28259 325 0 0
sp_qd_handle_on_reserve_upd_sts 9237 9237 0 0.00 0 19617 64 0 0
sp_reserve_write_off 9240 9240 0 0.00 6 25709 214 0 0
sp_supplier_invoice 5106 5106 0 0.00 8 81510 3482 0 0
sp_supplier_order 5233 5233 0 0.00 6 34883 1349 0 0
srv_aggregate_perf_data 101 101 0 0.00 2558 359871 21621 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 975 178114 33662 0 0
srv_find_qd_qs_mism 1063312 1063312 0 0.00 0 17302 5 0 0
srv_make_invnt_saldo 549 549 0 0.00 46 67878 1313 0 0
srv_make_money_saldo 752 752 0 0.00 1 8808 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 202745 417560 303261 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4726 4726 0 0.00 0 26897 175 0 0
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 0 9243 176 0 0
t$perf-norm:sp_cancel_client_order 1640 1640 0 0.00 0 2401 10 0 0
t$perf-norm:sp_cancel_customer_reserve 644 644 0 0.00 0 456 4 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 3162 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 757 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 362 362 0 0.00 0 2336 32 0 0
t$perf-norm:sp_cancel_supplier_order 390 390 0 0.00 0 17220 1661 0 0
t$perf-norm:sp_cancel_write_off 940 940 0 0.00 0 1406 6 0 0
t$perf-norm:sp_client_order 19257 19257 0 0.00 0 25142 21 0 0
t$perf-norm:sp_customer_reserve 936 936 0 0.00 0 4442 9 0 0
t$perf-norm:sp_pay_from_customer 6703 6703 0 0.00 0 25139 20 0 0
t$perf-norm:sp_pay_to_supplier 5563 5563 0 0.00 0 4908 8 0 0
t$perf-norm:sp_reserve_write_off 9240 9240 0 0.00 0 12832 12 0 0
t$perf-norm:sp_supplier_invoice 5106 5106 0 0.00 0 6487 17 0 0
t$perf-norm:sp_supplier_order 5233 5233 0 0.00 0 6688 20 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 292 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 504 9 0 0
t$perf-norm:srv_make_invnt_saldo 549 549 0 0.00 0 1412 25 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 799 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 317 82 0 0
v_add_invoice_to_stock 9634 9444 190 1.97 0 5630 22 0 190
v_all_customers 35210 35210 0 0.00 0 17 1 0 0
v_all_suppliers 29074 29074 0 0.00 0 83 1 0 0
v_all_wares 38512 38512 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 726 726 0 0.00 0 2808 11 0 0
v_cancel_client_order 3280 3280 0 0.00 0 4596 11 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 4354 15 0 0
v_cancel_customer_reserve 1288 1288 0 0.00 0 2069 7 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 974 4 0 0
v_cancel_supplier_invoice 734 724 10 1.36 0 8978 29 0 10
v_cancel_supplier_order 780 780 0 0.00 0 4106 15 0 0
v_cancel_write_off 1880 1880 0 0.00 0 3616 19 0 0
v_max_id_clo_ord 5232 5232 0 0.00 0 378 1 0 0
v_max_id_clo_res 936 936 0 0.00 0 2822 9 0 0
v_max_id_ord_sup 5102 5102 0 0.00 0 4989 3 0 0
v_max_non_paid_invoice 1359 1359 0 0.00 0 1570 4 0 0
v_max_non_paid_realizn 3494 3494 0 0.00 0 2156 4 0 0
v_min_id_clo_ord 5232 5232 0 0.00 0 10344 12 0 0
v_min_id_clo_res 936 936 0 0.00 0 3128 10 0 0
v_min_id_ord_sup 5102 5102 0 0.00 0 3757 8 0 0
v_min_non_paid_invoice 5562 5562 0 0.00 0 10861 20 0 0
v_min_non_paid_realizn 6703 6703 0 0.00 0 26295 22 0 0
v_our_firm 9720 9720 0 0.00 0 17 1 0 0
v_reserve_write_off 18474 18474 0 0.00 0 9600 9 0 0
x_lock_depdocs_on_canc_invoice 11740 11740 0 0.00 0 18369 120 0 0
x_lock_depdocs_on_canc_sup_ord 390 390 0 0.00 0 7597 319 0 0
x_make_qstorno_1000_1200 5233 5233 0 0.00 2 34871 1265 0 0
x_make_qstorno_1200_2000 5106 5106 0 0.00 4 81422 3344 0 0
x_make_qstorno_2100_3300 453068 453068 0 0.00 0 109310 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2021 01:28:19 to 18-02-2021 01:28:23.

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
22:57:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:30 13210 8192000000 10214519760 10516451328 773186016 8.624 63 44 92 0 789236656 1981104 14069536
22:57:50 27466 8192000000 10337589968 10651074560 1370447232 14.331 100 89 179 0 1404033296 4291440 29294624
22:58:26 39552 8192000000 10379486016 10701021184 1434048608 14.897 100 91 182 0 1470569472 6492704 30028160
22:59:13 16235 8192000000 10401299472 10722684928 1446819808 15.010 100 88 176 0 1483213280 7440960 28952512
22:59:39 23853 8192000000 10412034352 10743504896 1458687056 15.114 100 86 172 0 1494615568 8214880 27713632
23:00:15 21399 8192000000 10435253216 10769465344 1487712960 15.369 100 88 176 0 1524918672 8995040 28210672
23:00:45 23329 8192000000 10446865152 10785026048 1504913456 15.519 100 87 174 1 1542294816 9734112 27647248
23:01:17 17251 8192000000 10467629520 10810335232 1523577392 15.681 100 74 148 1 1556112688 9581200 22954096
23:01:42 20659 8192000000 10512502112 10857160704 1554488128 15.949 100 85 169 2 1591250976 10175664 26587184
23:02:12 15493 8192000000 10531220176 10881937408 1579645584 16.165 100 80 160 1 1615110400 10668688 24796128
23:02:40 13507 8192000000 10550118112 10906386432 1603547872 16.370 100 75 150 1 1637288464 10699120 23041472
23:03:03 12393 8192000000 10573358784 10931769344 1632488640 16.616 100 82 164 0 1668493184 11102192 24902352
23:03:27 11801 8192000000 10587188768 10954399744 1651698352 16.779 100 79 157 2 1686679136 11769664 23211120
23:03:52 8985 8192000000 10613997360 10983133184 1675930096 16.983 100 77 154 0 1710534304 11936544 22667664
23:04:12 9974 8192000000 10644825824 11018129408 1699691232 17.183 100 71 142 0 1731818256 11334688 20792336
23:04:31 7580 8192000000 10660238144 11037843456 1722410448 17.372 100 76 152 0 1756736736 12407440 21918848
23:04:50 5062 8192000000 10669884848 11051048960 1736499440 17.490 100 72 143 1 1768738592 11438256 20800896
23:05:03 8461 8192000000 10681150560 11067248640 1751070656 17.610 100 71 141 1 1782628320 10848288 20709376
23:05:19 5030 8192000000 10691252432 11076603904 1763810064 17.716 100 69 138 1 1793198336 10285744 19102528
23:05:32 14153 8192000000 10715318544 11097255936 1777705024 17.831 100 67 133 2 1808020448 11847488 18467936
23:05:56 5241 8192000000 10727843136 11116085248 1798027952 17.998 100 78 156 1 1832373712 12975840 21369920
23:06:08 4284 8192000000 10748696896 11130535936 1805306224 18.057 100 84 168 2 1843679024 14959104 23413696
23:06:20 3189 8192000000 10754185824 11138220032 1810584736 18.101 100 83 164 1 1847553520 14187888 22780896
23:06:29 4714 8192000000 10761976288 11146342400 1819737120 18.176 100 88 176 2 1858585040 14537344 24310576
23:06:41 2967 8192000000 10768035408 11154403328 1825958368 18.226 100 82 164 0 1862634848 14136480 22540000
23:06:51 2467 8192000000 10767144448 11154423808 1827545248 18.239 100 90 180 0 1867554896 14142576 25867072
23:07:00 1310 8192000000 10773147568 11158450176 1832679088 18.281 100 86 173 2 1870771536 13414384 24678064
23:07:08 2050 8192000000 10780160864 11164917760 1835201376 18.302 100 75 149 1 1868491824 12589456 20700992
23:07:17 2573 8192000000 10787917696 11172151296 1844228544 18.375 100 88 177 1 1881515616 12987792 24299280
23:07:26 3258 8192000000 10786914704 11171110912 1842135296 18.358 100 84 168 0 1878736400 12564128 24036976
23:07:36 2783 8192000000 10798990592 11182268416 1852068272 18.439 100 90 181 2 1890631776 12530400 26033104
23:07:45 1748 8192000000 10790414656 11177959424 1854145680 18.456 100 82 165 1 1890329104 12884192 23299232
23:07:53 1621 8192000000 10793764640 11183620096 1856597344 18.476 100 84 168 4 1892235024 12214144 23423536
23:08:01 2470 8192000000 10815770624 11201228800 1867753184 18.566 100 90 177 2 1905602128 12828528 25020416
23:08:10 1472 8192000000 10813753792 11201130496 1868234496 18.570 100 96 190 1 1908068352 11957152 27876704
23:08:18 1097 8192000000 10820740736 11207700480 1872647536 18.606 100 94 188 0 1912803872 13066880 27089456
23:08:26 6914 8192000000 10805744784 11202805760 1870662240 18.590 100 72 145 0 1902723024 12143024 19917760
23:08:39 2878 8192000000 10814150672 11211743232 1877382096 18.644 100 90 180 1 1915650464 12887008 25381360
23:08:48 3237 8192000000 10798595616 11204845568 1871956352 18.600 100 64 131 1 1901376512 11576352 17843808
23:08:58 27168 8192000000 10789089840 11201695744 1873491648 18.613 100 54 108 1 1896039664 6873264 15674752
23:09:33 16653 8192000000 10781257136 11202334720 1869692384 18.582 100 36 71 2 1885560384 5370864 10497136
23:09:56 16805 8192000000 10786194560 11206778880 1871143888 18.594 100 25 50 0 1883827280 5156192 7527200
23:10:22 5548 8192000000 10783982336 11213725696 1878751440 18.655 100 25 51 2 1892656960 6774656 7130864
23:10:34 3936 8192000000 10805885088 11219931136 1880776352 18.671 100 29 54 2 1893912768 5278704 7857712
23:10:44 6170 8192000000 10796525120 11217764352 1881979104 18.681 100 29 59 0 1897464816 6920464 8565248
23:10:57 5549 8192000000 10800134800 11224530944 1888649056 18.735 100 39 79 2 1907961536 8174864 11137616
23:11:09 3645 8192000000 10809575456 11232673792 1893679440 18.775 100 45 90 0 1914727024 8143328 12904256
23:11:23 5075 8192000000 10793682656 11227189248 1888764192 18.736 100 20 39 2 1900655248 6535760 5355296
23:11:35 6415 8192000000 10797598256 11230875648 1892863808 18.769 100 26 53 1 1906513968 6175424 7474736
23:11:48 11532 8192000000 10799661440 11231526912 1892198800 18.763 100 16 32 1 1902712704 6387328 4126576
23:12:05 6396 8192000000 10798619808 11234725888 1894888368 18.785 100 29 58 2 1909533808 6596592 8048848
23:12:19 8189 8192000000 10808900960 11238998016 1898749552 18.816 100 26 53 1 1912717408 5734144 8233712
23:12:36 11069 8192000000 10804877792 11238510592 1899782224 18.825 100 16 32 3 1911137872 6019824 5335824
23:12:56 3497 8192000000 10822818896 11244072960 1904164752 18.860 100 32 64 2 1919177376 6131136 8881488
23:13:08 9870 8192000000 10811025520 11244109824 1903676416 18.856 100 13 26 0 1913480352 5690576 4113360
23:13:24 9674 8192000000 10815592944 11247869952 1905321504 18.869 100 23 46 2 1918018192 6245152 6451536
23:13:40 61694 8192000000 10825703808 11257520128 1907260672 18.885 100 22 44 0 1918759120 5179008 6319440
23:14:48 7038 8192000000 10836005376 11265118208 1916253968 18.957 100 34 68 2 1931898016 6112848 9531200
23:15:03 3472 8192000000 10831861984 11266748416 1914634464 18.944 100 28 56 1 1929590656 6953488 8002704
23:15:14 6679 8192000000 10825890384 11265572864 1916222384 18.957 100 22 44 0 1929116960 6236512 6658064
23:15:30 7385 8192000000 10837560608 11270426624 1916344400 18.958 100 23 46 0 1929134608 6241584 6548624
23:15:50 6895 8192000000 10834807232 11267411968 1917849952 18.970 100 19 36 2 1927274336 4991168 4433216
23:16:04 8645 8192000000 10844272576 11274969088 1924189296 19.020 100 31 62 2 1939846928 7279552 8378080
23:16:19 5187 8192000000 10835112896 11266899968 1917489040 18.967 100 26 52 1 1931700448 7057680 7153728
23:16:31 5706 8192000000 10825287504 11262173184 1902516192 18.847 99 33 66 3 1918691712 6145296 10030224
23:16:43 8270 8192000000 10826409712 11258826752 1911975712 18.923 100 18 36 1 1922430848 5548496 4906640
23:16:58 7561 8192000000 10821326112 11252617216 1873624848 18.614 98 15 30 0 1884175216 5396448 5153920
23:17:14 6039 8192000000 10799557744 11227922432 1868557840 18.573 98 20 39 0 1880727296 6173776 5995680
23:17:33 6353 8192000000 10799256992 11231883264 1884777216 18.704 99 25 50 1 1898062176 5995760 7289200
23:17:49 7286 8192000000 10791622768 11224932352 1872847328 18.607 99 33 66 2 1889543232 7147184 9548720
23:18:06 42647 8192000000 10789772544 11206111232 1820838544 18.185 97 14 28 0 1830154800 5032496 4283760
23:19:14 5742 8192000000 10769478432 11190566912 1808370912 18.083 97 42 83 4 1828762336 8071840 12319584
23:19:31 11788 8192000000 10737923424 11159216128 1739142256 17.512 94 18 36 0 1750203856 5810176 5251424
23:19:50 6931 8192000000 10707597904 11128422400 1740423280 17.522 96 23 46 1 1753097184 6340480 6333424
23:20:05 7260 8192000000 10708241312 11119894528 1724385184 17.389 95 26 52 1 1737388656 5489648 7513824
23:20:21 6527 8192000000 10706953200 11131252736 1763209520 17.711 97 39 78 2 1781129072 6084192 11835360
23:20:35 8367 8192000000 10705998032 11123568640 1717752048 17.333 95 17 34 1 1728591968 5231664 5608256
23:20:54 6414 8192000000 10682675984 11095597056 1734612656 17.474 97 26 52 0 1747233440 5220288 7400496
23:21:10 8094 8192000000 10689125904 11104940032 1725373136 17.397 97 14 28 2 1733908080 5006720 3528224
23:21:26 7662 8192000000 10673825616 11078320128 1684631264 17.056 95 18 36 0 1695501520 5452992 5417264
23:21:42 10126 8192000000 10718724096 11131834368 1794429552 17.968 100 33 66 1 1810140080 5862672 9847856
23:22:00 10367 8192000000 10714999152 11131838464 1766926304 17.742 98 21 42 0 1778845408 4775856 7143248
23:22:23 13715 8192000000 10743867296 11167260672 1820269904 18.180 100 14 27 2 1830485248 5444896 4770448
23:22:47 68523 8192000000 10744520768 11171594240 1811413616 18.107 99 27 54 0 1824077296 4790096 7873584
23:24:04 8872 8192000000 10734139344 11162300416 1822347408 18.197 99 24 48 1 1835013664 6048416 6617840
23:24:22 5947 8192000000 10766275888 11188502528 1847966704 18.406 100 51 102 1 1870487936 6727280 15793952
23:24:34 5024 8192000000 10783632512 11195637760 1849208864 18.416 100 33 66 1 1864554336 4938688 10406784
23:24:46 7701 8192000000 10776233552 11202322432 1856422416 18.474 100 38 75 4 1874163984 6796352 10945216
23:25:00 11628 8192000000 10778050912 11206135808 1861370656 18.514 100 21 42 3 1873347392 5915520 6061216
23:25:20 11637 8192000000 10782055920 11215880192 1869063632 18.577 100 25 50 1 1881935984 5619808 7252544
23:25:43 10484 8192000000 10784722384 11218317312 1873106288 18.609 100 33 66 3 1888175584 4873824 10195472
23:26:00 7345 8192000000 10792529344 11214118912 1871829856 18.599 100 28 56 0 1886255840 5058480 9367504
23:26:14 6999 8192000000 10787858272 11220668416 1873620752 18.614 100 22 44 0 1885471808 5208416 6642640
23:26:28 12075 8192000000 10781975008 11220148224 1874534640 18.621 100 14 28 0 1883906160 5571920 3799600
23:26:48 10878 8192000000 10798122000 11227770880 1874638016 18.622 100 13 26 0 1883623520 5232624 3752880
23:27:06 12383 8192000000 10803117376 11239141376 1893962656 18.778 100 15 30 0 1903345840 5102768 4280416
23:27:26 37741 8192000000 10844987872 11266043904 1919448096 18.982 100 47 94 2 1939806176 6095184 14262896
23:28:11 105434 8192000000 10838126576 11284004864 1926380320 19.038 100 46 91 1 1947428960 7650512 13398128
23:30:03 37376 8192000000 10871465712 11301502976 1938414560 19.134 100 45 90 0 1962065872 10532304 13119008
23:30:50 2927 8192000000 10892168544 11315204096 1951492752 19.238 100 65 130 0 1984044944 13598272 18953920
23:31:01 15127 8192000000 10895944832 11323826176 1954314144 19.261 100 56 110 2 1984896320 15322288 15259888
23:31:25 21113 8192000000 10907894688 11329802240 1959869264 19.305 100 66 132 0 1996962032 19415856 17676912
23:31:53 15285 8192000000 10901037536 11330121728 1959685664 19.304 100 56 113 1 1995996736 20526480 15784592
23:32:18 26871 8192000000 10902789648 11335622656 1963660416 19.335 100 41 81 1 1992306704 17344320 11301968
23:33:00 29827 8192000000 10911019296 11347869696 1975085136 19.426 100 45 91 1 2007898896 18988768 13824992
23:33:37 7198 8192000000 10921525984 11353325568 1979212160 19.458 100 54 108 0 2014940832 19502928 16225744
23:33:55 13132 8192000000 10928927728 11357147136 1981237728 19.474 100 50 100 0 2015394640 19696960 14459952
23:34:17 17360 8192000000 10936445712 11365658624 1987845264 19.527 100 50 99 0 2024570864 22137744 14587856
23:34:41 15897 8192000000 10937100944 11373297664 1992728592 19.565 100 59 117 1 2034912800 24347216 17836992
23:35:09 22583 8192000000 10931166960 11381297152 1994443872 19.579 100 35 70 0 2026732736 21868288 10420576
23:35:41 13236 8192000000 10950192096 11387678720 2003481520 19.650 100 49 93 1 2040130880 21762512 14886848
23:36:03 11710 8192000000 10963158080 11399852032 2012323696 19.720 100 52 104 0 2054669040 26798048 15547296
23:36:23 7244 8192000000 10972261008 11403816960 2014730448 19.739 100 59 119 3 2060468624 27383072 18355104
23:36:41 9023 8192000000 10959284800 11400560640 2013506240 19.729 100 47 93 1 2054022512 26163264 14353008
23:37:08 9041 8192000000 10983699024 11417563136 2022500032 19.800 100 55 110 1 2072402528 33299776 16602720
23:37:30 7326 8192000000 10991756096 11420790784 2024676832 19.817 100 56 112 1 2074826064 33322928 16826304
23:37:45 4993 8192000000 10989456928 11423358976 2027708496 19.841 100 66 130 3 2081058112 33332464 20017152
23:37:57 3577 8192000000 10986360544 11423637504 2027668640 19.840 100 57 114 0 2076863120 32144240 17050240
23:38:10 5363 8192000000 10982159808 11409686528 1990293328 19.546 98 68 136 0 2043054736 32855680 19905728
23:38:25 4568 8192000000 10990668848 11416764416 2021926176 19.795 100 66 129 1 2074614448 33887920 18800352
23:38:40 2700 8192000000 10988466704 11417743360 2022652480 19.801 100 73 146 0 2079437712 35192288 21592944
23:38:50 3675 8192000000 10971746640 11400032256 2004567808 19.659 99 72 144 0 2061342096 34883088 21891200
23:39:05 3072 8192000000 10999730416 11419086848 2026222816 19.829 100 87 173 1 2088531952 36312480 25996656
23:39:15 6182 8192000000 11008023504 11431473152 2029927520 19.858 100 83 166 4 2093362384 37680528 25754336
23:39:30 3458 8192000000 11000077328 11430146048 2028182592 19.844 100 71 142 1 2088528800 38997776 21348432
23:39:43 4776 8192000000 11010271904 11437150208 2033501728 19.886 100 69 137 1 2093437456 39354096 20581632
23:39:54 5232 8192000000 10992343840 11428761600 2022615664 19.801 100 66 132 0 2081717632 38002992 21098976
23:40:07 5412 8192000000 10999070768 11433885696 2027881232 19.842 100 63 124 1 2086361104 38363088 20116784
23:40:20 4543 8192000000 10997605200 11429912576 2026042624 19.828 100 66 132 1 2085025648 38216096 20766928
23:40:32 2114 8192000000 11006637872 11436896256 2029645680 19.856 100 73 141 2 2090650272 37953040 23051552
23:40:45 7830 8192000000 11015762368 11445800960 2033299072 19.884 100 67 135 1 2093797152 39610736 20887344
23:41:00 2456 8192000000 11006577488 11423637504 2012522208 19.721 99 85 171 1 2083060448 44070272 26467968
23:41:11 2839 8192000000 11018352784 11435864064 2025299792 19.822 100 84 169 0 2096555440 45140304 26115344
23:41:26 1662 8192000000 11008091712 11426402304 2019599296 19.777 100 79 158 2 2088591360 44808480 24183584
23:41:35 1799 8192000000 11007417808 11426922496 2018480672 19.768 100 80 160 1 2089279584 46023008 24775904
23:41:45 4104 8192000000 10995978240 11417038848 1998984160 19.615 99 84 170 0 2069676480 44787744 25904576
23:41:58 3453 8192000000 10996793216 11418853376 2014024864 19.733 100 72 144 2 2080163792 44117744 22021184
23:42:08 1362 8192000000 11013345600 11428986880 2021504080 19.792 100 93 186 0 2096370752 45532064 29334608
23:42:16 2129 8192000000 11003175104 11424587776 2020368416 19.783 100 86 173 1 2086485824 39151728 26965680
23:42:29 4087 8192000000 10999824304 11421474816 2015521024 19.745 100 78 155 0 2080404176 40857696 24025456
23:42:40 7762 8192000000 11007744688 11429060608 2018908896 19.772 100 82 165 3 2089899376 44708544 26281936
23:43:05 2703 8192000000 10988114624 11413000192 1991732272 19.557 99 76 150 0 2061394720 45409984 24252464
23:43:15 2642 8192000000 10999692912 11422208000 2011603840 19.714 100 72 144 0 2077012608 43170640 22238128
23:43:25 3219 8192000000 10992227632 11424432128 2015026752 19.741 100 68 134 1 2080370144 43651280 21692112
23:43:36 3775 8192000000 10999857808 11424665600 2013978752 19.733 100 82 164 1 2084498784 45511520 25008512
23:43:51 3613 8192000000 10995318128 11416166400 2003158528 19.648 100 74 148 1 2073999168 47619072 23221568
23:44:02 1297 8192000000 10998417424 11419189248 2006890624 19.677 100 88 173 3 2083637264 49366224 27380416
23:44:10 3481 8192000000 11005412256 11425828864 2007317056 19.680 100 86 172 2 2082727936 48356880 27054000
23:44:25 2758 8192000000 10982904896 11400912896 1988496224 19.532 100 72 144 1 2058231504 47051040 22684240
23:44:34 1630 8192000000 10989406384 11404328960 1993981648 19.575 100 84 164 3 2066412352 46259424 26171280
23:44:45 11058 8192000000 10982207264 11409547264 1996395104 19.594 100 66 132 3 2063035424 46045888 20594432
23:45:10 4020 8192000000 10975306544 11401764864 1961360368 19.317 98 70 138 2 2035646736 51300816 22985552
23:45:22 1740 8192000000 10988635024 11405041664 1959675504 19.303 98 87 174 0 2040994416 53846064 27472848
23:45:30 1551 8192000000 10976843472 11387879424 1969273984 19.380 99 89 179 2 2047063056 49977232 27811840
23:45:38 966 8192000000 10962739376 11373416448 1954226640 19.260 99 91 182 1 2035342640 52754560 28361440
23:45:47 4773 8192000000 10943565696 11365318656 1941340224 19.157 99 65 129 3 2015336864 53407696 20588944
23:46:20 3694 8192000000 10951117152 11383238656 1960869888 19.313 100 53 104 1 2032128528 54130000 17128640
23:46:33 3658 8192000000 10949888848 11375091712 1952457456 19.246 100 62 124 1 2027115088 53947264 20710368
23:46:44 19380 8192000000 10927631440 11361288192 1901032272 18.835 97 49 98 1 1974351744 56293760 17025712
23:47:12 10941 8192000000 10926116384 11378626560 1948531328 19.215 100 34 68 1 2018333120 57737056 12064736
23:47:31 4704 8192000000 10923539200 11373850624 1950264416 19.229 100 43 86 1 2017184368 52562016 14357936
23:47:42 4526 8192000000 10912089952 11346354176 1926522640 19.039 99 48 95 2 1982715584 40798464 15394480
23:47:55 2684 8192000000 10912064112 11334635520 1917420240 18.966 99 63 125 2 1978740688 42056224 19264224
23:48:11 25754 8192000000 10858871424 11306094592 1882599152 18.686 98 35 70 0 1936570944 42592304 11379488
23:48:45 7972 8192000000 10888692000 11330383872 1916818288 18.961 100 33 66 0 1972183648 44097376 11267984
23:48:59 5063 8192000000 10877361536 11320303616 1911508240 18.919 100 31 62 4 1966747264 44622800 10616224
23:49:37 19372 8192000000 10889891664 11345985536 1923891920 19.018 100 23 47 0 1970506528 39138224 7476384
23:50:04 9716 8192000000 10888694704 11334119424 1915079280 18.947 99 31 62 1 1965271200 40000640 10191280
23:50:25 19744 8192000000 10892976752 11341369344 1909833728 18.905 99 25 50 2 1963408656 44707056 8867872
23:51:03 20537 8192000000 10881281792 11334782976 1904384160 18.862 99 23 46 0 1958085520 46008352 7693008
23:51:33 28194 8192000000 10901483776 11355447296 1931141824 19.076 100 21 42 1 1979240848 40447792 7651232
23:52:12 31307 8192000000 10892095248 11359543296 1916441952 18.958 99 13 26 0 1958064128 36821936 4800240
23:52:53 35978 8192000000 10886191824 11348905984 1908927312 18.898 99 11 22 0 1952303872 39236896 4139664
23:53:35 21797 8192000000 10869391152 11324252160 1912817520 18.929 99 13 26 2 1934355008 17971024 3566464
23:54:07 17922 8192000000 10890044688 11331022848 1947724656 19.208 100 56 111 0 1977261168 12264016 17272496
23:54:57 57681 8192000000 10871306224 11327926272 1897856880 18.809 98 13 26 0 1917780304 15566752 4356672
23:56:01 89967 8192000000 10864574800 11317854208 1901091360 18.835 98 31 58 2 1927364336 18292960 7980016
23:57:38 61954 8192000000 10879654720 11321233408 1897205968 18.804 97 40 81 0 1914669408 6611952 10851488
23:58:46 55366 8192000000 10888498400 11331448832 1926389312 19.038 99 34 67 0 1943125008 6753776 9981920
23:59:51 14803 8192000000 10892385056 11331252224 1935518576 19.111 99 45 91 0 1956804944 8811120 12475248
00:00:13 9789 8192000000 10875793312 11337129984 1952232736 19.244 100 41 80 2 1974435792 10638592 11564464
00:01:06 56896 8192000000 10874331888 11336712192 1915663152 18.952 98 13 26 0 1928326816 9236272 3427392
00:02:11 60365 8192000000 10874744960 11335389184 1922594016 19.008 98 12 24 1 1936224816 10155680 3475120
00:03:18 35403 8192000000 10881887872 11344482304 1955172192 19.268 100 13 26 0 1971957632 13064336 3721104
00:04:05 29541 8192000000 10883201616 11349532672 1955380896 19.269 100 28 57 2 1978664192 15013648 8269648
00:04:41 178073 8192000000 10862782944 11335061504 1902503664 18.846 97 12 24 0 1913967968 7944768 3519536
00:07:46 33538 8192000000 10894385776 11335475200 1938569696 19.135 99 46 91 3 1960585536 7961216 14054624
00:08:26 51921 8192000000 10884394656 11351822336 1939587280 19.143 99 28 56 0 1963062704 15644800 7830624
00:09:25 78953 8192000000 10886504080 11366395904 1959949696 19.306 100 8 16 0 1975585920 13176720 2459504
00:10:56 45816 8192000000 10907046048 11391643648 1976115760 19.434 100 27 54 0 1996642688 12650784 7876144
00:12:05 61792 8192000000 10897031680 11371749376 1954516768 19.262 99 15 30 1 1977806304 18868160 4421376
00:13:43 31666 8192000000 10905395920 11363971072 1974352032 19.420 100 19 38 1 1990331584 10724336 5255216
00:14:21 22751 8192000000 10930790352 11385319424 1990399392 19.547 100 48 97 1 2014965616 10280224 14286000
00:14:50 58347 8192000000 10911476176 11398094848 1991186352 19.553 100 24 48 0 2013262496 15014704 7061440
00:15:54 64061 8192000000 10936269088 11391021056 1958958912 19.298 98 19 38 1 1978430864 14251984 5219968
00:17:15 62856 8192000000 10932383472 11417657344 2002204976 19.640 100 17 34 1 2027087344 19670832 5211536
00:18:30 82425 8192000000 10914651312 11392438272 1952569056 19.247 98 6 12 0 1972902960 18804032 1529872
00:19:59 106215 8192000000 10940875648 11408949248 1999495552 19.619 100 15 30 0 2020398784 16650608 4252624
00:21:52 77386 8192000000 10936087792 11419009024 1990929392 19.551 99 18 36 2 2015124336 18790400 5404544
00:23:35 9580 8192000000 10964074480 11408052224 2017797328 19.763 100 70 134 4 2043983776 7416944 18769504
00:23:56 43284 8192000000 10923228032 11383808000 1969168624 19.379 98 41 82 1 1991584912 11470208 10946080
00:24:49 92829 8192000000 10950716560 11397627904 2001114912 19.632 100 32 64 0 2020196624 9963584 9118128
00:26:34 48817 8192000000 10954938448 11415506944 2012904400 19.724 100 40 80 1 2038762240 14723616 11134224
00:27:30 23086 8192000000 10953261776 11422613504 2017182016 19.758 100 23 46 1 2037099856 13843104 6074736
00:28:01 35869 8192000000 10939329600 11417419776 1996298128 19.594 99 14 28 1 2013176928 12918896 3959904
00:28:44 73665 8192000000 10930667984 11426078720 1992021120 19.560 99 15 30 0 2022629344 26616592 3991632
00:30:05 20506 8192000000 10929571504 11425079296 2005361136 19.665 100 8 16 0 2022560464 15387952 1811376
00:31:03 59883 8192000000 10926628240 11413913600 1972064400 19.402 98 13 26 0 1983010176 7267472 3678304
00:32:10 62793 8192000000 10907838016 11377217536 1933438080 19.094 96 22 44 0 1949284400 9583456 6262864
00:33:23 62204 8192000000 10876780976 11346460672 1820345216 18.181 92 19 38 0 1834141712 8541696 5254800
00:34:33 76107 8192000000 10873397744 11344273408 1863497248 18.532 95 11 22 0 1880516224 14108864 2910112
00:35:55 47146 8192000000 10872708176 11336003584 1880233120 18.667 96 23 46 0 1897652064 10329872 7089072
00:36:54 105746 8192000000 10868304048 11344592896 1856905152 18.478 96 10 20 1 1873736832 14195888 2635792
00:38:47 75540 8192000000 10863913936 11340673024 1826230992 18.229 94 11 22 0 1845982112 16667648 3083472
00:40:09 43841 8192000000 10846060928 11296477184 1871957776 18.600 97 16 32 0 1891672656 15866480 3848400
00:41:03 44369 8192000000 10867533600 11323150336 1887838768 18.728 98 31 62 0 1911104480 14846544 8419168
00:42:01 80311 8192000000 10860925920 11322527744 1875414016 18.628 97 18 35 1 1892345440 11582480 5348944
00:43:27 46877 8192000000 10891094832 11331829760 1935994896 19.115 100 18 36 1 1952958544 11257104 5706544
00:44:20 17779 8192000000 10881871024 11327315968 1910347760 18.909 98 42 84 2 1932249088 10094624 11806704
00:44:48 14452 8192000000 10890360272 11332296704 1925100992 19.028 99 47 94 2 1950456384 12365344 12990048
00:45:19 43202 8192000000 10889759776 11340005376 1945692240 19.192 100 43 86 2 1974777056 16716992 12367824
00:46:10 134406 8192000000 10815702160 11281326080 1808024832 18.080 94 23 46 1 1825525472 11083888 6416752
00:48:44 41779 8192000000 10869299472 11305164800 1884272464 18.700 98 30 61 1 1904328880 11513920 8542496
00:49:42 52309 8192000000 10822555952 11287568384 1856038176 18.471 97 19 38 0 1877121136 15748064 5334896
00:50:41 46764 8192000000 10811152016 11272843264 1866907968 18.559 98 16 32 1 1884225008 12316304 5000736
00:51:42 28791 8192000000 10828242912 11298107392 1905840048 18.873 100 13 25 1 1921888624 12150240 3898336
00:52:28 29722 8192000000 10843153632 11314298880 1914553568 18.943 100 21 42 0 1935202656 14170880 6478208
00:54:02 68615 8192000000 10845567888 11321307136 1893436720 18.773 99 16 32 0 1911349248 13400896 4511632
00:55:25 70752 8192000000 10861324064 11328172032 1926545760 19.039 100 26 52 0 1956314832 21647360 8121712
00:56:45 50670 8192000000 10856228304 11325661184 1925322368 19.029 100 10 20 1 1944860336 16326976 3210992
00:57:42 48252 8192000000 10891669376 11345461248 1950607360 19.231 100 23 46 0 1963731440 6864960 6259120
00:58:38 87877 8192000000 10865613760 11341316096 1883852048 18.696 96 16 32 0 1900304688 11980864 4471776
01:00:12 82047 8192000000 10872396336 11318693888 1868691056 18.574 96 11 22 0 1882895520 11187344 3017120
01:01:41 23295 8192000000 10887939184 11339497472 1947338768 19.205 100 33 66 0 1964781824 8319376 9123680
01:02:30 45137 8192000000 10911466000 11365908480 1959644544 19.303 100 37 74 3 1983220224 13437648 10138032
01:03:23 87572 8192000000 10911473104 11379245056 1955843824 19.273 99 27 54 0 1982452240 18809440 7798976
01:05:03 95939 8192000000 10894616448 11360063488 1908384576 18.894 97 13 24 1 1927879504 16232784 3262144
01:06:46 48829 8192000000 10898163808 11364261888 1934522160 19.103 98 29 58 1 1954569840 12304848 7742832
01:07:44 89105 8192000000 10903260400 11396464640 1963001424 19.330 100 6 12 0 1982435408 17811056 1622928
01:09:52 104734 8192000000 10906261840 11371524096 1975013888 19.425 100 18 36 0 1989981488 9522752 5444848
01:11:44 3359 8192000000 10921715088 11374219264 1983430880 19.492 100 43 86 0 2004952736 9145184 12376672
01:11:55 42516 8192000000 10914887872 11390160896 1987146912 19.521 100 28 56 2 2004512016 9878672 7486432
01:12:54 55764 8192000000 10909265088 11398602752 1984173536 19.498 100 7 14 0 2005369376 19037056 2158784
01:13:56 18027 8192000000 10913527632 11407929344 1985000048 19.504 100 8 16 0 2008049568 20575344 2474176
01:14:20 4288 8192000000 10910863680 11408232448 1987144384 19.521 100 7 14 1 2008052288 18734784 2173120
01:15:05 7849 8192000000 10919618672 11409313792 1996975328 19.599 100 25 49 0 2018381504 14131216 7274960
01:15:38 74968 8192000000 10915617824 11397320704 1974097296 19.418 99 12 24 0 1988399904 11168112 3134496
01:17:16 74125 8192000000 10929113648 11396710400 1993314240 19.570 100 23 47 0 2012809824 12199504 7296080
01:18:47 59096 8192000000 10930538960 11399720960 1981742576 19.478 99 22 44 1 1999112400 11356400 6013424
01:20:00 91478 8192000000 10906085152 11404361728 1953420688 19.254 98 10 20 0 1971547008 15162304 2964016
01:21:40 45108 8192000000 10883279760 11358208000 1894809440 18.785 96 17 34 0 1909531168 10314400 4407328
01:22:32 49616 8192000000 10880698176 11352076288 1911946688 18.922 97 22 44 2 1927272544 9301408 6024448
01:23:32 51149 8192000000 10890274032 11357650944 1929271552 19.061 98 23 46 0 1945254128 9695968 6286608
01:24:29 94256 8192000000 10892772912 11366862848 1939896096 19.146 98 28 56 0 1962019824 13816768 8306960
01:26:19 49653 8192000000 10901351632 11367968768 1911217952 18.916 97 22 44 1 1928839632 11328992 6292688
01:27:20 5481 8192000000 9062244160 9272659968 227231760 2.698 12 3 5 0 230996432 3284272 480400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-02-2021 01:28:25 to 18-02-2021 01:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2021 01:28:57 to 18-02-2021 01:28:59.

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          230211
MON$OLDEST_ACTIVE               230212
MON$OLDEST_SNAPSHOT             230212
MON$NEXT_TRANSACTION            230212
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                       2011648
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:85: 
:86: mscs-test-161.budzdorov.ru    Thu Feb 18 01:27:28 2021
:87:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:88: 
--- end of diff output ---

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

18.02.21 01:29:00. 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-02-18 01:29:03 No severe PSQL-related problems occured
18.02.21 01:29:04. End of report.