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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17326628 kB
MemAvailable 31395240 kB
Buffers 0 kB
Cached 14338064 kB
SwapCached 3488 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 2020-11-15 19:26:58
DTS_END                         2020-11-15 19:26:58.7570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38628
TRN_ID                          242057
ATT_ID                          671
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: 9407.48 25637 1128898
customer order: creation 175.94 341 21113
customer order: refuse 14.87 342 1784
order to supplier: creation 47.26 1201 5671
order to supplier: removal 3.46 97940 415
invoice (draft): creation 47.41 3055 5689
invoice (draft): removal 52.61 760 6313
invoice accept: apply 42.83 18265 5140
invoice accept: cancel 47.59 800 5711
customer reserve: creation 4004.33 178 480519
customer reserve: removal 4674.60 57 560952
realization accept: apply 85.43 177 10252
realization accept: cancel 78.03 114 9364
payment from customer: creation 60.46 97 7255
payment from customer: removal 5.80 56 696
payment to supplier: creation 50.77 111 6092
payment to supplier: removal 3.52 62 422
service: total inventory turnovers 5.02 1134 602
service: total monetary turnovers 6.63 54 795
service: aggregate perf. data 0.91 18207 109
service: refresh index statistics 0.03 369782 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 15-11-2020 19:27:36 to 15-11-2020 19:27:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1127
TEST_TIME 2 3198
TEST_TIME 3 3266
TEST_TIME 4 3868
TEST_TIME 5 4335
TEST_TIME 6 4374
TEST_TIME 7 4780
TEST_TIME 8 4961
TEST_TIME 9 5071
TEST_TIME 10 5143
TEST_TIME 11 6014
TEST_TIME 12 6818
TEST_TIME 13 7072
TEST_TIME 14 7398
TEST_TIME 15 7872
TEST_TIME 16 8199
TEST_TIME 17 8459
TEST_TIME 18 8431
TEST_TIME 19 8885
TEST_TIME 20 9082
TEST_TIME 21 8898
TEST_TIME 22 9408
TEST_TIME 23 9636
TEST_TIME 24 9713
TEST_TIME 25 9634
TEST_TIME 26 9916
TEST_TIME 27 10488
TEST_TIME 28 10526
TEST_TIME 29 11051
TEST_TIME 30 10965
TEST_TIME 31 10733
TEST_TIME 32 10862
TEST_TIME 33 10951
TEST_TIME 34 10741
TEST_TIME 35 10638
TEST_TIME 36 10744
TEST_TIME 37 10631
TEST_TIME 38 10622
TEST_TIME 39 10376
TEST_TIME 40 10209
TEST_TIME 41 10119
TEST_TIME 42 10021
TEST_TIME 43 10087
TEST_TIME 44 10031
TEST_TIME 45 9864
TEST_TIME 46 9904
TEST_TIME 47 9876
TEST_TIME 48 9819
TEST_TIME 49 9690
TEST_TIME 50 9559
TEST_TIME 51 9558
TEST_TIME 52 9575
TEST_TIME 53 9523
TEST_TIME 54 9455
TEST_TIME 55 9473
TEST_TIME 56 9483
TEST_TIME 57 9378
TEST_TIME 58 9341
TEST_TIME 59 9345
TEST_TIME 60 9298
TEST_TIME 61 9389
TEST_TIME 62 9396
TEST_TIME 63 9401
TEST_TIME 64 9516
TEST_TIME 65 9472
TEST_TIME 66 9497
TEST_TIME 67 9500
TEST_TIME 68 9558
TEST_TIME 69 9548
TEST_TIME 70 9579
TEST_TIME 71 9575
TEST_TIME 72 9637
TEST_TIME 73 9604
TEST_TIME 74 9567
TEST_TIME 75 9469
TEST_TIME 76 9465
TEST_TIME 77 9398
TEST_TIME 78 9436
TEST_TIME 79 9414
TEST_TIME 80 9341
TEST_TIME 81 9339
TEST_TIME 82 9294
TEST_TIME 83 9237
TEST_TIME 84 9302
TEST_TIME 85 9237
TEST_TIME 86 9244
TEST_TIME 87 9248
TEST_TIME 88 9241
TEST_TIME 89 9301
TEST_TIME 90 9320
TEST_TIME 91 9400
TEST_TIME 92 9374
TEST_TIME 93 9405
TEST_TIME 94 9506
TEST_TIME 95 9479
TEST_TIME 96 9450
TEST_TIME 97 9598
TEST_TIME 98 9568
TEST_TIME 99 9568
TEST_TIME 100 9546
TEST_TIME 101 9502
TEST_TIME 102 9497
TEST_TIME 103 9446
TEST_TIME 104 9461
TEST_TIME 105 9466
TEST_TIME 106 9424
TEST_TIME 107 9399
TEST_TIME 108 9382
TEST_TIME 109 9341
TEST_TIME 110 9333
TEST_TIME 111 9301
TEST_TIME 112 9346
TEST_TIME 113 9321
TEST_TIME 114 9359
TEST_TIME 115 9370
TEST_TIME 116 9401
TEST_TIME 117 9438
TEST_TIME 118 9432
TEST_TIME 119 9421
TEST_TIME 120 9408

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-11-2020 19:27:40 to 15-11-2020 19:27:43.

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 1573694 1573694 0 0.00 0 28532 6 0 0
doc_list_biud 1573694 1573694 0 0.00 0 68801 26 0 0
sp_add_invoice_to_stock 5295 5140 155 2.92 36 215857 18265 0 155
sp_cancel_adding_invoice 5711 5711 0 0.00 5 69338 800 0 0
sp_cancel_client_order 1784 1784 0 0.00 4 20698 342 0 0
sp_cancel_customer_reserve 560952 560952 0 0.00 1 29814 58 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 4483 57 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 6386 62 0 0
sp_cancel_supplier_invoice 6321 6313 8 0.12 2 68810 760 0 8
sp_cancel_supplier_order 415 415 0 0.00 6 987486 97941 0 0
sp_cancel_write_off 9364 9364 0 0.00 1 10800 115 0 0
sp_client_order 21113 21113 0 0.00 3 30135 341 0 0
sp_customer_reserve 480519 480519 0 0.00 0 47760 179 0 0
sp_fill_shopping_cart 32464 32464 0 0.00 1 9028 33 0 0
sp_fill_shopping_cart_clo_res 480515 480515 0 0.00 0 21883 14 0 0
sp_get_clo_for_invoice 5136 5136 0 0.00 0 27221 324 0 0
sp_kill_cost_storno 16193 16193 0 0.00 0 9527 56 0 0
sp_kill_qstorno_ret_qs2qd 1137996 1137996 0 0.00 0 68796 31 0 0
sp_kill_qty_storno 599925 599925 0 0.00 0 68799 68 0 0
sp_lock_selected_doc 21347 21347 0 0.00 0 8966 6 0 0
sp_make_cost_storno 28733 28733 0 0.00 0 27860 49 0 0
sp_multiply_rows_for_pdistr 28733 28733 0 0.00 0 9477 28 0 0
sp_multiply_rows_for_qdistr 21113 21113 0 0.00 0 16531 151 0 0
sp_pay_from_customer 7255 7255 0 0.00 4 7409 98 0 0
sp_pay_to_supplier 6092 6092 0 0.00 4 28538 111 0 0
sp_payment_common 13347 13347 0 0.00 1 7451 22 0 0
sp_qd_handle_on_cancel_clo 1784 1784 0 0.00 0 20691 326 0 0
sp_qd_handle_on_invoice_upd_sts 10845 10845 0 0.00 0 37034 313 0 0
sp_qd_handle_on_reserve_upd_sts 10252 10252 0 0.00 0 32110 68 0 0
sp_reserve_write_off 10252 10252 0 0.00 6 32154 177 0 0
sp_supplier_invoice 5689 5689 0 0.00 6 82165 3055 0 0
sp_supplier_order 5671 5671 0 0.00 5 34899 1201 0 0
srv_aggregate_perf_data 109 109 0 0.00 2775 141862 18207 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1174 138526 31485 0 0
srv_find_qd_qs_mism 1079582 1079582 0 0.00 0 9128 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 37 96529 1135 0 0
srv_make_money_saldo 795 795 0 0.00 1 19480 54 0 0
srv_recalc_idx_stat 4 4 0 0.00 276051 566701 369783 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5140 5140 0 0.00 0 23260 187 0 0
t$perf-norm:sp_cancel_adding_invoice 447 447 0 0.00 0 6048 97 0 0
t$perf-norm:sp_cancel_client_order 1784 1784 0 0.00 0 2181 10 0 0
t$perf-norm:sp_cancel_customer_reserve 714 714 0 0.00 0 1293 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 18029 33 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 660 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 425 425 0 0.00 0 955 11 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 29038 1813 0 0
t$perf-norm:sp_cancel_write_off 1058 1058 0 0.00 0 3486 7 0 0
t$perf-norm:sp_client_order 21113 21113 0 0.00 0 20519 17 0 0
t$perf-norm:sp_customer_reserve 1050 1050 0 0.00 0 1872 7 0 0
t$perf-norm:sp_pay_from_customer 7255 7255 0 0.00 0 14968 15 0 0
t$perf-norm:sp_pay_to_supplier 6092 6092 0 0.00 0 5248 12 0 0
t$perf-norm:sp_reserve_write_off 10252 10252 0 0.00 0 10545 12 0 0
t$perf-norm:sp_supplier_invoice 5689 5689 0 0.00 0 13481 17 0 0
t$perf-norm:sp_supplier_order 5671 5671 0 0.00 0 21960 21 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 510 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 827 10 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 882 23 0 0
t$perf-norm:srv_make_money_saldo 795 795 0 0.00 0 2393 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10578 10268 310 2.93 0 6171 18 0 310
v_all_customers 38128 38128 0 0.00 0 141 1 0 0
v_all_suppliers 31812 31812 0 0.00 0 176 1 0 0
v_all_wares 42226 42226 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 894 894 0 0.00 0 496 6 0 0
v_cancel_client_order 3568 3568 0 0.00 0 677 3 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 4472 7 0 0
v_cancel_customer_reserve 1428 1428 0 0.00 0 1396 4 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 1139 6 0 0
v_cancel_supplier_invoice 866 850 16 1.84 0 3228 17 0 16
v_cancel_supplier_order 830 830 0 0.00 0 665 5 0 0
v_cancel_write_off 2116 2116 0 0.00 0 3049 13 0 0
v_max_id_clo_ord 5671 5671 0 0.00 0 1329 1 0 0
v_max_id_clo_res 1050 1050 0 0.00 0 3680 20 0 0
v_max_id_ord_sup 5680 5680 0 0.00 0 2961 3 0 0
v_max_non_paid_invoice 1537 1537 0 0.00 0 632 3 0 0
v_max_non_paid_realizn 3945 3945 0 0.00 0 3222 4 0 0
v_min_id_clo_ord 5671 5671 0 0.00 0 3098 6 0 0
v_min_id_clo_res 1050 1050 0 0.00 0 858 4 0 0
v_min_id_ord_sup 5680 5680 0 0.00 0 5501 8 0 0
v_min_non_paid_invoice 6092 6092 0 0.00 0 7447 14 0 0
v_min_non_paid_realizn 7255 7255 0 0.00 0 4646 12 0 0
v_our_firm 10718 10718 0 0.00 0 23 1 0 0
v_reserve_write_off 20504 20504 0 0.00 0 6769 5 0 0
x_lock_depdocs_on_canc_invoice 11599 11599 0 0.00 0 17370 105 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 4990 301 0 0
x_make_qstorno_1000_1200 5671 5671 0 0.00 1 34891 1121 0 0
x_make_qstorno_1200_2000 5689 5689 0 0.00 3 82136 2949 0 0
x_make_qstorno_2100_3300 480519 480519 0 0.00 0 46499 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-11-2020 19:27:44 to 15-11-2020 19:27:48.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:02 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:08 14564 8192000000 10212550960 10510581760 780275584 8.696 63 48 100 0 798469872 2121376 16072912
16:57:34 40601 8192000000 10322164896 10636460032 1363869920 14.272 100 88 178 0 1397534464 4755328 28909216
16:58:22 36533 8192000000 10370002224 10690105344 1413132784 14.712 100 87 174 0 1447534224 6145344 28256096
16:59:08 20999 8192000000 10403874384 10731012096 1458186080 15.110 100 86 172 0 1492801920 7049856 27565984
16:59:39 20710 8192000000 10424588192 10755735552 1481368960 15.313 100 85 170 0 1517054336 7995840 27689536
17:00:14 30005 8192000000 10463355296 10801016832 1509469920 15.559 100 81 162 1 1543555520 8284608 25800992
17:00:52 14685 8192000000 10484573520 10824581120 1542911264 15.849 100 86 172 0 1578718096 8866064 26940768
17:01:21 14526 8192000000 10496714672 10845958144 1558412176 15.983 100 80 161 0 1592718768 9344896 24961696
17:01:44 9492 8192000000 10511571376 10863177728 1574975088 16.125 100 75 151 0 1606744928 8939440 22830400
17:02:02 13012 8192000000 10542047696 10894524416 1593066400 16.280 100 81 162 1 1626771024 9309296 24395328
17:02:25 12391 8192000000 10543576816 10904522752 1608699504 16.414 100 73 146 0 1640739840 9856192 22184144
17:02:49 11469 8192000000 10573835920 10937876480 1644323744 16.716 100 76 153 1 1677732960 10567072 22842144
17:03:09 12685 8192000000 10598527856 10960732160 1657886736 16.831 100 82 164 2 1693210304 11842432 23481136
17:03:31 8549 8192000000 10605480464 10976976896 1673483776 16.963 100 75 150 3 1707529200 12168576 21876848
17:03:57 7894 8192000000 10637888464 11011141632 1698820864 17.175 100 76 151 3 1732537968 11979824 21737280
17:04:13 9122 8192000000 10647138896 11023036416 1712501344 17.290 100 74 147 1 1745187232 11940848 20745040
17:04:30 7914 8192000000 10672768528 11048919040 1732230496 17.454 100 79 157 1 1767793888 13470832 22092560
17:04:46 6117 8192000000 10688580032 11064963072 1747254032 17.579 100 78 158 1 1782871664 14223744 21393888
17:04:59 3709 8192000000 10694519552 11073613824 1756186416 17.653 100 84 168 0 1793696912 13899120 23611376
17:05:09 6392 8192000000 10704511072 11086671872 1760887696 17.692 100 75 150 0 1795495168 13478368 21129104
17:05:28 8316 8192000000 10708621728 11088646144 1774078224 17.801 100 74 148 3 1807635328 13505472 20051632
17:05:45 3534 8192000000 10722213168 11108724736 1793523232 17.961 100 84 168 0 1832195168 14938368 23733568
17:05:56 5246 8192000000 10738349136 11126890496 1803513520 18.043 100 78 155 1 1838602384 13369920 21718944
17:06:08 3422 8192000000 10744488704 11135131648 1812546016 18.117 100 77 154 0 1847232096 12840352 21845728
17:06:18 3546 8192000000 10757254768 11146461184 1823053776 18.203 100 79 158 1 1858237856 12894160 22289920
17:06:29 2271 8192000000 10767710736 11158745088 1828557472 18.248 100 88 174 0 1865676992 12889520 24230000
17:06:38 2167 8192000000 10776327616 11166797824 1839473920 18.337 100 86 169 0 1876670848 12706960 24489968
17:06:47 3537 8192000000 10788686848 11172069376 1840736384 18.347 100 94 188 0 1881385056 15067680 25580992
17:06:56 2263 8192000000 10783593360 11172986880 1845139664 18.383 100 95 191 3 1887723024 15703648 26879712
17:07:05 1737 8192000000 10795805008 11180916736 1846338288 18.392 100 92 184 0 1886603600 14203808 26061504
17:07:14 1969 8192000000 10792499984 11179692032 1849287680 18.416 100 90 179 0 1887585552 13241920 25055952
17:07:23 1956 8192000000 10797623120 11183472640 1851306480 18.433 100 91 182 0 1889444160 12264256 25873424
17:07:31 2028 8192000000 10795808832 11180867584 1855666592 18.468 100 90 182 3 1894821776 12941936 26213248
17:07:40 2954 8192000000 10794495264 11185307648 1856437024 18.474 100 91 180 1 1895547728 13466432 25644272
17:07:49 2003 8192000000 10809158352 11198164992 1862448816 18.523 100 94 188 1 1903869744 14544544 26876384
17:07:58 1762 8192000000 10807996256 11197767680 1867729552 18.566 100 91 183 1 1906182736 13314752 25138432
17:08:06 1668 8192000000 10819275168 11206311936 1868271824 18.570 100 94 190 2 1909411888 14705536 26434528
17:08:13 31239 8192000000 10794634464 11203031040 1867810320 18.567 100 65 130 1 1897289664 11292512 18186832
17:09:01 1213 8192000000 10820551840 11211022336 1873339360 18.611 100 94 189 1 1911901792 12190896 26371536
17:09:09 4924 8192000000 10821160144 11213250560 1876167200 18.634 100 87 175 2 1913360720 12364736 24828784
17:09:20 18698 8192000000 10780187648 11203362816 1865864352 18.551 100 34 68 5 1884295696 8590096 9841248
17:09:46 9813 8192000000 10786781888 11214491648 1869013536 18.576 100 15 30 3 1878774448 6058144 3702768
17:10:03 9402 8192000000 10789944624 11215826944 1878990576 18.657 100 24 47 2 1892207808 6361488 6855744
17:10:21 7428 8192000000 10793470816 11217293312 1881720368 18.679 100 30 61 2 1897108512 6366448 9021696
17:10:34 7667 8192000000 10789085728 11220340736 1882386240 18.684 100 20 40 0 1893810480 6162656 5261584
17:10:54 8616 8192000000 10792480576 11226607616 1890545552 18.750 100 25 50 1 1903845440 6147600 7152288
17:11:12 8949 8192000000 10805222160 11232092160 1889723440 18.744 100 21 42 2 1901288464 6138368 5426656
17:11:31 20387 8192000000 10807760848 11239837696 1892990976 18.770 100 22 44 1 1909489616 10220688 6277952
17:11:59 13875 8192000000 10805107504 11237134336 1896638080 18.799 100 17 34 1 1907084176 5842800 4603296
17:12:19 8280 8192000000 10810552576 11240243200 1898289712 18.813 100 17 32 1 1909163600 6205104 4668784
17:12:34 14010 8192000000 10795538640 11236302848 1896811376 18.801 100 9 18 1 1905100688 5997376 2291936
17:12:54 52807 8192000000 10838987440 11255824384 1906069488 18.875 100 34 69 0 1921004416 5320208 9614720
17:13:58 19419 8192000000 10872568960 11274100736 1917740112 18.969 100 73 145 2 1944621648 4801760 22079776
17:14:24 6708 8192000000 10825114096 11262599168 1913806704 18.937 100 40 80 2 1933919504 9018128 11094672
17:14:38 5493 8192000000 10819881008 11258081280 1909889472 18.906 100 17 34 2 1921569920 5897520 5782928
17:14:51 6987 8192000000 10829277120 11260604416 1912666832 18.928 100 23 46 1 1924890960 5413120 6811008
17:15:07 6432 8192000000 10833758496 11262414848 1912273168 18.925 100 25 50 0 1925882384 6764032 6845184
17:15:20 6596 8192000000 10815562656 11261472768 1915305184 18.949 100 27 52 2 1929650656 6216336 8129136
17:15:34 7493 8192000000 10818049760 11259269120 1911109728 18.916 100 17 34 1 1921337248 5714624 4512896
17:15:49 5125 8192000000 10826810336 11246370816 1897168080 18.804 99 34 66 0 1913661664 7929584 8564000
17:16:01 3471 8192000000 10829712896 11264811008 1916660544 18.960 100 32 64 0 1933955744 7225168 10070032
17:16:13 7024 8192000000 10819714512 11253927936 1894012368 18.778 99 26 52 2 1911056288 9987216 7056704
17:16:27 10098 8192000000 10793011024 11222646784 1864145104 18.537 98 22 45 1 1875775488 5277984 6352400
17:16:45 10383 8192000000 10802157696 11224211456 1836914864 18.316 97 27 54 2 1852380688 7175680 8290144
17:17:04 6710 8192000000 10803796800 11238084608 1887679360 18.727 100 17 34 2 1897585440 5331152 4574928
17:17:21 62663 8192000000 10825192976 11231358976 1836909760 18.316 97 45 90 3 1857121248 6349168 13862320
17:18:30 9059 8192000000 10774212384 11206045696 1852968512 18.446 99 21 42 2 1865839216 7133872 5736832
17:18:47 7673 8192000000 10754373536 11171323904 1789942864 17.931 96 28 55 1 1803650832 6556752 7151216
17:19:01 6441 8192000000 10756451312 11170267136 1795638928 17.978 97 22 44 1 1807780992 5964816 6177248
17:19:14 7892 8192000000 10765764064 11191037952 1821264944 18.188 98 23 46 0 1833436640 5370144 6801552
17:19:29 7031 8192000000 10743397488 11165335552 1778607904 17.838 96 26 52 2 1796133136 9990464 7534768
17:19:43 6974 8192000000 10756647808 11175931904 1824472240 18.214 99 40 81 2 1842511152 5346864 12692048
17:19:57 5653 8192000000 10741696560 11160227840 1799435584 18.009 98 26 52 1 1812846480 6173440 7237456
17:20:09 5604 8192000000 10698102640 11109941248 1737661840 17.499 96 28 54 3 1751315904 5123248 8530816
17:20:24 7639 8192000000 10737185328 11154161664 1794008304 17.965 98 26 52 0 1807558704 6117456 7432944
17:20:39 6865 8192000000 10733194672 11152723968 1815575056 18.142 100 28 57 3 1829718896 5111568 9032272
17:20:57 11293 8192000000 10714261904 11138772992 1757717200 17.666 97 18 36 2 1772793744 10370960 4705584
17:21:15 23351 8192000000 10701675152 11118825472 1722793120 17.375 95 42 84 0 1740770080 5296896 12680064
17:22:05 38335 8192000000 10730782000 11151884288 1733776096 17.467 95 25 49 3 1750059648 9538080 6745472
17:22:52 11395 8192000000 10730735472 11144085504 1763414496 17.713 97 30 57 4 1781798144 10403600 7980048
17:23:11 6574 8192000000 10735550000 11144962048 1809022432 18.088 100 36 69 2 1826370400 7122624 10225344
17:23:26 8450 8192000000 10737998240 11155283968 1805499440 18.059 99 25 50 1 1818118832 5873632 6745760
17:23:43 9389 8192000000 10740192224 11161370624 1814574816 18.133 99 23 46 0 1826426560 5251472 6600272
17:23:59 6179 8192000000 10751542896 11180355584 1841934704 18.357 100 31 62 1 1857080912 6280240 8865968
17:24:12 8965 8192000000 10769489488 11195555840 1852100544 18.439 100 26 52 3 1866797520 7482400 7214576
17:24:28 11332 8192000000 10755668640 11191496704 1851973840 18.438 100 21 42 1 1862907920 5395840 5538240
17:24:45 9603 8192000000 10766849728 11197190144 1856496352 18.475 100 15 30 1 1866875008 5684976 4693680
17:25:05 12912 8192000000 10772799856 11203424256 1866093232 18.553 100 26 51 0 1879675936 5232880 8349824
17:25:27 8733 8192000000 10781859376 11210088448 1866205312 18.554 100 23 46 2 1879342336 5936464 7200560
17:25:44 73032 8192000000 10789970112 11208990720 1873724672 18.614 100 29 58 1 1889734576 6057728 9952176
17:27:04 34695 8192000000 10824809712 11245010944 1896767296 18.800 100 51 103 2 1919830544 8564368 14498880
17:28:03 37738 8192000000 10841761552 11271393280 1911897072 18.922 100 30 60 1 1932772352 12484320 8390960
17:28:50 28025 8192000000 10864147184 11287605248 1929527936 19.063 100 44 87 3 1953239392 11896528 11814928
17:29:26 33413 8192000000 10870028208 11299729408 1941774416 19.161 100 48 96 1 1970464768 14074432 14615920
17:30:12 15559 8192000000 10873862544 11304546304 1944198544 19.180 100 39 78 2 1969773088 13818608 11755936
17:30:35 17263 8192000000 10885930832 11315900416 1950949600 19.234 100 49 98 0 1980732960 16071680 13711680
17:31:02 22845 8192000000 10893043808 11323330560 1952157696 19.244 100 41 80 1 1980337456 16678208 11501552
17:31:40 13410 8192000000 10895409280 11325575168 1960903376 19.313 100 51 102 2 1993804272 17935568 14965328
17:32:03 10364 8192000000 10911827600 11327434752 1967293456 19.364 100 60 120 2 2002033888 17447056 17293376
17:32:21 5424 8192000000 10916763840 11332616192 1965295200 19.348 100 65 128 1 2002640112 18816320 18528592
17:32:34 20263 8192000000 10921030560 11344064512 1966105808 19.355 100 61 122 3 2003533008 19607824 17819376
17:33:03 14500 8192000000 10918340288 11345670144 1979955968 19.464 100 59 120 1 2016946096 19472848 17517280
17:33:34 35469 8192000000 10910841872 11351224320 1973768048 19.415 100 45 90 2 2008364880 21555600 13041232
17:34:25 2205 8192000000 10938946176 11360354304 1983426144 19.492 100 54 109 2 2021781808 21477808 16877856
17:34:36 4251 8192000000 10939513952 11366850560 1990310816 19.546 100 53 106 1 2029490240 23218880 15960544
17:34:49 2026 8192000000 10945574672 11370053632 1997838384 19.606 100 73 143 2 2043122304 24197376 21086544
17:35:00 17332 8192000000 10949753888 11383869440 1997735984 19.605 100 56 110 0 2043283264 29211984 16335296
17:35:32 19752 8192000000 10953871536 11392065536 2005956624 19.670 100 49 98 1 2049121408 27898048 15266736
17:35:59 3705 8192000000 10967889232 11395719168 2009546752 19.698 100 55 110 1 2054290848 27639296 17104800
17:36:13 13279 8192000000 10955115696 11390263296 2003550048 19.651 100 50 100 2 2048055280 28674368 15830864
17:36:38 9274 8192000000 10964889552 11393224704 2004399584 19.657 100 57 114 5 2053675440 31795360 17480496
17:36:57 4342 8192000000 10967828016 11395244032 2004817392 19.661 100 68 134 1 2058694336 33102432 20774512
17:37:10 2659 8192000000 10955629568 11382898688 1983743488 19.494 99 71 143 3 2036230224 31157680 21329056
17:37:21 8609 8192000000 10955739008 11390828544 2000697088 19.628 100 65 130 1 2051920720 30528016 20695616
17:37:39 3764 8192000000 10968396640 11398918144 2006112928 19.671 100 64 128 1 2057356688 31815616 19428144
17:37:50 1171 8192000000 10980375600 11400839168 2011773264 19.715 100 79 158 1 2065975504 31074880 23127360
17:37:58 2536 8192000000 10997105568 11411349504 2013959984 19.733 100 93 186 1 2075267936 33703872 27604080
17:38:08 5005 8192000000 10985376896 11409358848 2013936480 19.732 100 73 145 2 2070578656 34043056 22599120
17:38:22 2526 8192000000 10984136624 11410960384 2015524496 19.745 100 67 134 1 2070117856 34268944 20324416
17:38:31 6601 8192000000 10981867376 11411419136 2015456400 19.744 100 63 125 1 2067072144 33049600 18566144
17:38:45 3193 8192000000 10988126688 11411693568 2014360144 19.736 100 73 145 2 2074368384 38208896 21799344
17:38:55 6892 8192000000 10966413104 11387092992 1998264720 19.609 99 77 153 2 2045243552 24400000 22578832
17:39:09 6116 8192000000 10972169792 11393941504 2003218512 19.648 100 80 159 0 2052831312 25815936 23796864
17:39:22 3516 8192000000 10972269568 11393630208 2005025392 19.662 100 75 148 1 2052505424 25726048 21753984
17:39:34 2083 8192000000 10975096480 11401666560 2015769216 19.747 100 81 162 1 2066101872 25674256 24658400
17:39:44 2327 8192000000 10964619168 11385540608 1994014512 19.576 99 78 155 1 2042016928 23979072 24023344
17:39:55 6219 8192000000 10977315888 11400114176 2009272992 19.696 100 77 154 1 2059134928 26233568 23628368
17:40:15 3650 8192000000 10962560912 11390795776 1990001920 19.544 99 67 134 1 2039645344 29010368 20633056
17:40:28 2953 8192000000 10960720336 11383656448 1997226208 19.601 100 78 154 0 2053380240 30982688 25171344
17:40:39 1905 8192000000 10931367296 11348738048 1960350800 19.309 98 87 171 2 2016086416 29269104 26466512
17:40:48 2641 8192000000 10973516032 11389841408 1995374976 19.586 100 88 176 1 2052174096 29528592 27270528
17:40:58 7595 8192000000 10958038032 11385176064 1981869968 19.480 99 73 146 2 2036217600 31223808 23123824
17:41:13 3969 8192000000 10969167216 11393769472 1983205808 19.490 99 75 150 0 2037848304 31945856 22696640
17:41:24 7065 8192000000 10963135760 11387371520 1997182288 19.601 100 75 149 1 2046941104 27017712 22741104
17:41:41 4040 8192000000 10962993648 11377561600 1973486464 19.413 99 83 163 2 2026094912 27561376 25047072
17:41:51 1735 8192000000 10955363360 11371163648 1973340352 19.412 99 92 185 0 2029491888 28485824 27665712
17:42:02 1540 8192000000 10962586144 11380690944 1990402768 19.547 100 86 168 2 2044509840 28251440 25855632
17:42:10 2495 8192000000 10969354944 11383386112 1996440416 19.595 100 81 161 1 2045873648 25551552 23881680
17:42:19 6376 8192000000 10950922448 11371704320 1970037472 19.386 99 82 160 1 2022789504 29026880 23725152
17:42:34 1828 8192000000 10939093776 11349868544 1960445936 19.310 99 84 169 2 2015513216 29859840 25207440
17:42:44 2286 8192000000 10954755200 11366465536 1978236016 19.451 100 92 181 2 2035885840 30453472 27196352
17:42:54 3263 8192000000 10963192816 11371921408 1985656128 19.509 100 89 176 1 2042731120 30989312 26085680
17:43:07 3844 8192000000 10941784064 11361382400 1966803840 19.360 99 75 149 1 2016432064 27541680 22086544
17:43:18 4485 8192000000 10948454224 11366744064 1978309648 19.451 100 78 156 1 2030785648 28489952 23986048
17:43:29 10873 8192000000 10958246976 11377467392 1987780112 19.526 100 73 145 3 2041925536 31621440 22523984
17:43:48 4295 8192000000 10958867760 11369521152 1970613216 19.390 99 78 157 0 2025681952 31405008 23663728
17:43:59 3261 8192000000 10961388304 11371659264 1982408912 19.484 100 79 156 1 2038490224 32142240 23939072
17:44:09 2152 8192000000 10929401328 11344244736 1954084368 19.259 99 76 152 1 2009749440 31773520 23891552
17:44:20 1786 8192000000 10951070832 11368038400 1979878608 19.464 100 80 161 1 2035528064 30425600 25223856
17:44:29 1381 8192000000 10942346096 11356831744 1957971568 19.290 99 82 163 1 2014663296 32067552 24624176
17:44:38 3744 8192000000 10937064704 11355840512 1966620960 19.359 100 75 150 2 2023004384 32741968 23641456
17:44:49 2282 8192000000 10946267600 11350913024 1936984256 19.123 98 89 179 1 1997454272 33277792 27192224
17:44:58 4099 8192000000 10932838464 11346018304 1932154528 19.084 98 84 170 0 1992944544 34964496 25825520
17:45:12 5211 8192000000 10949448400 11365543936 1970894064 19.393 100 80 158 1 2032873088 37756416 24222608
17:45:25 2553 8192000000 10940126880 11361361920 1965883824 19.353 100 75 150 1 2027573616 38613968 23075824
17:45:42 15306 8192000000 10922850368 11362095104 1948839152 19.217 99 34 68 1 1997153728 36522320 11792256
17:46:08 12186 8192000000 10946414400 11373072384 1976438112 19.436 100 55 110 1 2025216640 31778144 17000384
17:46:30 5949 8192000000 10951937536 11385524224 1985715920 19.510 100 53 106 2 2038145760 35172848 17256992
17:46:48 16938 8192000000 10934466896 11378827264 1968351360 19.372 100 38 76 0 2017576608 36884016 12341232
17:47:15 11980 8192000000 10954406064 11385049088 1987241536 19.522 100 64 126 2 2042055568 34550576 20263456
17:47:35 6966 8192000000 10964718688 11386400768 1982103232 19.481 100 78 157 1 2047858304 41756416 23998656
17:47:49 5078 8192000000 10972184688 11394179072 1983648032 19.494 100 68 134 3 2048834032 44409968 20776032
17:48:02 2362 8192000000 10977983792 11397722112 1984509376 19.500 100 72 145 1 2056340512 48749584 23081552
17:48:15 4053 8192000000 10989430288 11405860864 1992255088 19.562 100 72 145 2 2065497360 50228304 23013968
17:48:32 4750 8192000000 10972376736 11404496896 1971936816 19.401 99 54 108 0 2041245760 51707856 17601088
17:48:45 9501 8192000000 10954736000 11395633152 1986808928 19.519 100 44 88 2 2046446688 44665168 14972592
17:49:09 12146 8192000000 10930279808 11369279488 1939276912 19.141 98 42 84 1 1997392064 43734800 14380352
17:49:30 15391 8192000000 10945256160 11381604352 1969527472 19.382 100 39 78 1 2032518432 50105360 12885600
17:49:53 16391 8192000000 10942958432 11392745472 1973252096 19.411 100 34 68 2 2029129984 43941456 11936432
17:50:36 21708 8192000000 10940545488 11378663424 1946846800 19.201 99 38 76 1 2000786608 41277648 12662160
17:51:13 47830 8192000000 10938379344 11389599744 1973902656 19.416 100 44 88 3 2034006912 45307344 14796912
17:52:20 29254 8192000000 10917995888 11373649920 1949792224 19.225 100 22 44 0 2000394096 42732240 7869632
17:53:37 18619 8192000000 10902918288 11388420096 1950560864 19.231 100 17 34 1 1994496320 38007920 5927536
17:54:04 37184 8192000000 10883036944 11364020224 1920438352 18.990 99 11 22 1 1958840224 34410192 3991680
17:54:47 31441 8192000000 10871435392 11355660288 1910124640 18.908 99 9 18 0 1948991520 35829744 3037136
17:55:37 97986 8192000000 10855278272 11314475008 1820753808 18.184 94 11 23 3 1843120080 19423088 2943184
17:57:22 54235 8192000000 10857438368 11312099328 1908144720 18.892 99 20 40 1 1926604160 12243776 6215664
17:58:22 49810 8192000000 10861786176 11331096576 1911513456 18.919 99 12 25 0 1931047440 15957344 3576640
17:59:52 108601 8192000000 10872265696 11315105792 1875747344 18.631 97 23 46 1 1901347104 19619152 5980608
18:01:49 21428 8192000000 10885462512 11327827968 1940271104 19.149 100 49 94 3 1964036944 10289888 13475952
18:02:17 43234 8192000000 10854022192 11323994112 1914000384 18.939 99 26 52 1 1934851856 13593456 7258016
18:03:09 59240 8192000000 10867014800 11312119808 1878616624 18.654 97 14 29 1 1890906800 8796960 3493216
18:04:19 32754 8192000000 10886347840 11347054592 1948129168 19.212 100 21 42 1 1971092992 17639216 5324608
18:05:04 116823 8192000000 10884979968 11343273984 1950832624 19.233 100 18 36 1 1970449408 13982320 5634464
18:07:17 47367 8192000000 10881007760 11341287424 1948341520 19.213 99 32 62 1 1963190288 6470784 8377984
18:08:21 57327 8192000000 10905265696 11377025024 1973579024 19.414 100 21 42 1 1992660272 12372640 6708608
18:09:40 60238 8192000000 10903226144 11393912832 1969742544 19.383 100 12 24 3 1995167360 21549088 3875728
18:10:47 10894 8192000000 10909946368 11393474560 1974443968 19.421 100 6 12 0 1995632112 19624048 1564096
18:11:05 59576 8192000000 10935830608 11385769984 1969451696 19.381 99 34 67 1 1990017712 11460176 9105840
18:12:45 98923 8192000000 10895820416 11366817792 1960085888 19.307 99 17 33 0 1974698160 10288768 4323504
18:14:34 78384 8192000000 10925517920 11398668288 1995230032 19.585 100 23 46 3 2021215968 19636944 6348992
18:16:45 99333 8192000000 10907975984 11373232128 1963329200 19.332 99 25 48 3 1983898176 13553680 7015296
18:18:32 48027 8192000000 10886480496 11362828288 1942496528 19.167 98 25 47 3 1962580736 13266208 6818000
18:19:43 48417 8192000000 10905179200 11380162560 1983448176 19.492 100 12 24 1 1996057488 9369872 3239440
18:20:37 22564 8192000000 10929927392 11390980096 1994975120 19.583 100 32 63 3 2013241440 8420128 9846192
18:21:06 75153 8192000000 10903400304 11399802880 1972258688 19.403 99 19 38 0 1990236576 12331392 5646496
18:22:27 32577 8192000000 10899799744 11389886464 1964339232 19.341 99 11 22 1 1982997216 15115744 3542240
18:23:10 70510 8192000000 10914409936 11383406592 1962308864 19.324 99 17 34 0 1978378512 11538528 4531120
18:24:32 60127 8192000000 10904226080 11397865472 1981581552 19.477 100 15 30 2 1996795840 11127216 4087072
18:25:38 16845 8192000000 10901193968 11396362240 1982319680 19.483 100 3 6 0 1994934720 11768320 846720
18:26:09 65207 8192000000 10902366240 11380183040 1935493184 19.111 97 19 37 1 1949133440 8560576 5079680
18:27:20 103262 8192000000 10921744544 11397353472 1909906288 18.906 96 17 34 3 1929204336 14646816 4651232
18:29:11 52976 8192000000 10908293728 11387494400 1956746368 19.280 98 24 48 0 1980841280 17771056 6323856
18:30:10 59278 8192000000 10883327184 11356463104 1878884240 18.656 95 15 30 0 1895396704 12706656 3805808
18:31:30 59573 8192000000 10873504304 11345342464 1887937872 18.729 96 10 20 2 1900910832 10468768 2504192
18:32:37 47627 8192000000 10883127728 11355930624 1907233680 18.884 97 9 18 0 1924644992 14907984 2503328
18:33:31 19464 8192000000 10892606432 11326648320 1906320768 18.877 97 43 83 3 1929352496 12046336 10985392
18:33:58 18938 8192000000 10906204048 11351601152 1954235536 19.260 100 58 116 0 1982843200 12270832 16336832
18:34:29 40094 8192000000 10880626656 11366289408 1958786480 19.296 100 38 75 1 1983213616 14149200 10277936
18:35:18 55044 8192000000 10881330944 11348500480 1897112576 18.803 97 19 38 0 1911832384 9399424 5320384
18:36:22 53771 8192000000 10881629760 11348082688 1919918416 18.986 98 27 54 0 1937719408 10175136 7625856
18:37:32 57600 8192000000 10871484016 11336192000 1902332656 18.845 97 17 34 0 1920150128 12509904 5307568
18:39:49 18017 8192000000 10883121728 11337281536 1935168400 19.108 100 26 52 2 1955313184 13055152 7089632
18:40:14 97817 8192000000 10877205520 11316973568 1868649936 18.573 96 42 81 1 1893754176 14049840 11054400
18:42:00 95518 8192000000 10873693104 11325743104 1904596752 18.863 98 24 48 0 1918810784 7284672 6929360
18:43:42 23279 8192000000 10885477920 11342909440 1931378608 19.078 99 42 82 3 1953641632 10233872 12029152
18:44:11 67486 8192000000 10856030784 11337641984 1906719520 18.880 98 9 18 1 1918600064 9068656 2811888
18:45:25 59108 8192000000 10873965248 11348021248 1923243168 19.013 99 5 9 0 1934014048 9738448 1032432
18:46:54 35593 8192000000 10856031632 11335405568 1914034032 18.939 98 20 39 1 1932664176 13177024 5453120
18:47:36 44081 8192000000 10854983152 11325554688 1898026176 18.810 98 15 30 1 1908839424 6773888 4039360
18:48:33 64566 8192000000 10860952800 11337162752 1941127888 19.156 100 10 20 0 1956136336 12029456 2978992
18:49:45 33564 8192000000 10860381024 11339223040 1935885552 19.114 100 15 30 1 1955166112 15144800 4135760
18:50:24 43754 8192000000 10840597072 11337465856 1897314848 18.805 98 11 22 0 1921980880 21713792 2952240
18:51:14 30985 8192000000 10865787984 11327471616 1914063904 18.939 99 12 24 0 1925503840 7844464 3595472
18:51:55 65256 8192000000 10829350720 11293949952 1822740912 18.200 94 11 22 2 1836095168 10092320 3261936
18:53:08 43935 8192000000 10831323984 11300569088 1858881504 18.494 97 23 46 1 1875254976 9851200 6522272
18:53:58 54709 8192000000 10855227312 11314696192 1885662672 18.711 98 26 52 0 1904648000 11189024 7796304
18:55:03 40539 8192000000 10865419312 11345408000 1938355808 19.134 100 14 28 0 1957570976 15099232 4115936
18:55:49 66840 8192000000 10868875760 11344076800 1924902704 19.026 99 18 36 2 1941548352 11693152 4952496
18:57:15 52593 8192000000 10878799152 11343020032 1911446176 18.918 98 14 28 0 1930044160 15065248 3532736
18:58:16 29531 8192000000 10895090720 11346395136 1915449088 18.950 98 34 69 0 1932664496 7996896 9218512
18:58:54 52446 8192000000 10887278400 11362607104 1939443136 19.142 99 27 54 2 1964348064 17205776 7699152
18:59:58 108694 8192000000 10905845952 11365335040 1946513136 19.199 99 16 32 0 1963218160 12499840 4205184
19:02:08 45194 8192000000 10919375376 11376209920 1961564608 19.318 99 30 60 0 1983880752 14031712 8284432
19:03:05 52798 8192000000 10904002976 11392413696 1959961232 19.306 99 12 24 2 1983623472 19859264 3802976
19:04:10 76718 8192000000 10938966176 11400314880 1987689376 19.526 100 21 42 0 2008877520 15516624 5671520
19:05:38 27715 8192000000 10919230448 11372310528 1932206592 19.085 97 36 71 0 1956420528 14601088 9612848
19:06:13 7964 8192000000 10925152688 11375378432 1978566624 19.453 100 40 78 1 1999724432 10616560 10541248
19:06:27 101406 8192000000 10907383520 11382661120 1985448656 19.508 100 38 76 0 2004374144 7836672 11088816
19:08:15 41372 8192000000 10928101648 11399491584 1993479088 19.571 100 19 38 2 2007060912 8832592 4749232
19:09:05 62101 8192000000 10949895856 11400237056 1987230240 19.522 99 49 98 2 2014466368 13764688 13471440
19:10:14 38466 8192000000 10910134304 11385167872 1939181392 19.140 97 24 48 3 1960031616 14096208 6754016
19:11:02 48321 8192000000 10882144384 11367604224 1960629328 19.311 99 15 30 2 1979729056 14312464 4787264
19:11:57 29010 8192000000 10868559664 11352883200 1914432848 18.942 97 5 9 2 1924302832 8906576 963408
19:12:32 37040 8192000000 10902669760 11369783296 1958146336 19.291 99 19 38 0 1970619760 6814304 5659120
19:13:26 45986 8192000000 10903719712 11370663936 1946127440 19.196 98 9 18 0 1956933360 8149632 2656288
19:15:41 69398 8192000000 10852922864 11335880704 1895774912 18.792 97 12 24 0 1905966016 6907568 3283536
19:16:57 41299 8192000000 10879784608 11345137664 1895530320 18.790 97 26 50 0 1911974128 9442432 7001376
19:17:47 77869 8192000000 10863532816 11338043392 1858383680 18.490 95 12 24 0 1874822512 13072624 3366208
19:19:11 31931 8192000000 10881106528 11346485248 1929585776 19.064 99 27 54 3 1945841680 8602432 7653472
19:19:56 63897 8192000000 10870484944 11343921152 1920813376 18.993 98 28 56 3 1939818320 10821712 8183232
19:21:08 31996 8192000000 10863334288 11328290816 1887729120 18.727 97 16 33 0 1906066448 14144208 4193120
19:21:47 16051 8192000000 10869313744 11319885824 1882806528 18.688 97 34 68 1 1904103344 11871488 9425328
19:22:10 27573 8192000000 10857351824 11313192960 1904659232 18.864 99 32 64 1 1929180992 14962240 9559520
19:22:53 138518 8192000000 10852871776 11317092352 1854360208 18.458 96 13 26 1 1869769472 12711728 2697536
19:25:24 47774 8192000000 10862496736 11313418240 1893479696 18.774 97 29 58 0 1911202784 9635184 8087904
19:26:19 23220 8192000000 10887103168 11334250496 1935738976 19.113 100 38 76 0 1956900832 10928976 10232880
19:26:49 17437 8192000000 9275130672 9537302528 427670320 4.961 23 5 10 0 432314528 3475360 1168848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-11-2020 19:27:50 to 15-11-2020 19:28:22.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-11-2020 19:28:22 to 15-11-2020 19:28:24.

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          240512
MON$OLDEST_ACTIVE               242343
MON$OLDEST_SNAPSHOT             242343
MON$NEXT_TRANSACTION            242343
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                       2030496
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:127: 
:128: mscs-test-161.budzdorov.ru    Sun Nov 15 19:27:09 2020
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
--- end of diff output ---

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

15.11.20 19:28:25. 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
2020-11-15 19:28:28 No severe PSQL-related problems occured
15.11.20 19:28:29. End of report.