Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.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 17411088 kB
MemAvailable 31470648 kB
Buffers 0 kB
Cached 14257608 kB
SwapCached 2868 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.7
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-03 19:27:01
DTS_END                         2020-11-03 19:27:01.5400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(108:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47894
TRN_ID                          243697
ATT_ID                          679
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: 9519.97 23713 1142396
customer order: creation 177.82 349 21338
customer order: refuse 16.18 343 1941
order to supplier: creation 47.55 1191 5706
order to supplier: removal 3.73 89191 447
invoice (draft): creation 48.90 3065 5868
invoice (draft): removal 53.07 721 6368
invoice accept: apply 43.33 17291 5200
invoice accept: cancel 47.70 826 5724
customer reserve: creation 4106.97 166 492836
customer reserve: removal 4672.08 57 560649
realization accept: apply 86.05 151 10326
realization accept: cancel 80.45 107 9654
payment from customer: creation 62.23 94 7467
payment from customer: removal 5.98 80 718
payment to supplier: creation 51.04 104 6125
payment to supplier: removal 3.39 72 407
service: total inventory turnovers 5.15 903 618
service: total monetary turnovers 7.32 39 878
service: aggregate perf. data 1.02 13388 122
service: refresh index statistics 0.03 346114 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-11-2020 19:27:56 to 03-11-2020 19:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6791
TEST_TIME 2 5574
TEST_TIME 3 5379
TEST_TIME 4 5263
TEST_TIME 5 5108
TEST_TIME 6 4843
TEST_TIME 7 4975
TEST_TIME 8 4837
TEST_TIME 9 5639
TEST_TIME 10 5884
TEST_TIME 11 6825
TEST_TIME 12 7698
TEST_TIME 13 7950
TEST_TIME 14 8174
TEST_TIME 15 8493
TEST_TIME 16 8639
TEST_TIME 17 9227
TEST_TIME 18 9251
TEST_TIME 19 9222
TEST_TIME 20 9753
TEST_TIME 21 10069
TEST_TIME 22 9936
TEST_TIME 23 10137
TEST_TIME 24 10843
TEST_TIME 25 11268
TEST_TIME 26 11654
TEST_TIME 27 11519
TEST_TIME 28 11279
TEST_TIME 29 11004
TEST_TIME 30 10802
TEST_TIME 31 10826
TEST_TIME 32 10712
TEST_TIME 33 10790
TEST_TIME 34 10628
TEST_TIME 35 10497
TEST_TIME 36 10372
TEST_TIME 37 10431
TEST_TIME 38 10423
TEST_TIME 39 10586
TEST_TIME 40 10383
TEST_TIME 41 10373
TEST_TIME 42 10393
TEST_TIME 43 10349
TEST_TIME 44 10391
TEST_TIME 45 10365
TEST_TIME 46 10367
TEST_TIME 47 10225
TEST_TIME 48 10440
TEST_TIME 49 10389
TEST_TIME 50 10451
TEST_TIME 51 10375
TEST_TIME 52 10375
TEST_TIME 53 10405
TEST_TIME 54 10499
TEST_TIME 55 10497
TEST_TIME 56 10525
TEST_TIME 57 10358
TEST_TIME 58 10282
TEST_TIME 59 10236
TEST_TIME 60 10166
TEST_TIME 61 10211
TEST_TIME 62 10167
TEST_TIME 63 10112
TEST_TIME 64 10068
TEST_TIME 65 10018
TEST_TIME 66 9975
TEST_TIME 67 9983
TEST_TIME 68 10033
TEST_TIME 69 9946
TEST_TIME 70 10005
TEST_TIME 71 10052
TEST_TIME 72 10120
TEST_TIME 73 10067
TEST_TIME 74 10079
TEST_TIME 75 10070
TEST_TIME 76 10054
TEST_TIME 77 10070
TEST_TIME 78 10072
TEST_TIME 79 10149
TEST_TIME 80 10032
TEST_TIME 81 9967
TEST_TIME 82 9890
TEST_TIME 83 9861
TEST_TIME 84 9876
TEST_TIME 85 9844
TEST_TIME 86 9773
TEST_TIME 87 9758
TEST_TIME 88 9676
TEST_TIME 89 9743
TEST_TIME 90 9733
TEST_TIME 91 9745
TEST_TIME 92 9743
TEST_TIME 93 9748
TEST_TIME 94 9770
TEST_TIME 95 9786
TEST_TIME 96 9731
TEST_TIME 97 9778
TEST_TIME 98 9832
TEST_TIME 99 9844
TEST_TIME 100 9860
TEST_TIME 101 9876
TEST_TIME 102 9838
TEST_TIME 103 9834
TEST_TIME 104 9785
TEST_TIME 105 9749
TEST_TIME 106 9695
TEST_TIME 107 9668
TEST_TIME 108 9636
TEST_TIME 109 9593
TEST_TIME 110 9593
TEST_TIME 111 9573
TEST_TIME 112 9549
TEST_TIME 113 9533
TEST_TIME 114 9510
TEST_TIME 115 9517
TEST_TIME 116 9542
TEST_TIME 117 9549
TEST_TIME 118 9548
TEST_TIME 119 9606
TEST_TIME 120 9526

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-11-2020 19:27:59 to 03-11-2020 19:28:03.

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 1598039 1598039 0 0.00 0 30310 6 0 0
doc_list_biud 1598039 1598039 0 0.00 0 28541 25 0 0
sp_add_invoice_to_stock 5278 5200 78 1.47 48 197536 17291 0 78
sp_cancel_adding_invoice 5724 5724 0 0.00 5 98305 826 0 0
sp_cancel_client_order 1941 1941 0 0.00 4 9837 344 0 0
sp_cancel_customer_reserve 560649 560649 0 0.00 1 28406 58 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 10000 80 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 2408 72 0 0
sp_cancel_supplier_invoice 6371 6368 3 0.04 2 14452 721 0 3
sp_cancel_supplier_order 447 447 0 0.00 8 1132879 89192 0 0
sp_cancel_write_off 9654 9654 0 0.00 1 10622 107 0 0
sp_client_order 21338 21338 0 0.00 3 11224 350 0 0
sp_customer_reserve 492836 492836 0 0.00 0 49256 167 0 0
sp_fill_shopping_cart 32912 32912 0 0.00 1 9756 36 0 0
sp_fill_shopping_cart_clo_res 492821 492821 0 0.00 0 12658 15 0 0
sp_get_clo_for_invoice 5185 5185 0 0.00 0 30234 302 0 0
sp_kill_cost_storno 16503 16503 0 0.00 0 10618 52 0 0
sp_kill_qstorno_ret_qs2qd 1137767 1137767 0 0.00 0 27529 31 0 0
sp_kill_qty_storno 600294 600294 0 0.00 0 28540 67 0 0
sp_lock_selected_doc 21692 21692 0 0.00 0 9990 6 0 0
sp_make_cost_storno 29103 29103 0 0.00 0 30303 44 0 0
sp_multiply_rows_for_pdistr 29103 29103 0 0.00 0 6499 24 0 0
sp_multiply_rows_for_qdistr 21338 21338 0 0.00 0 11212 173 0 0
sp_pay_from_customer 7467 7467 0 0.00 4 10074 95 0 0
sp_pay_to_supplier 6125 6125 0 0.00 5 30345 105 0 0
sp_payment_common 13592 13592 0 0.00 1 12493 20 0 0
sp_qd_handle_on_cancel_clo 1941 1941 0 0.00 0 9829 316 0 0
sp_qd_handle_on_invoice_upd_sts 10909 10909 0 0.00 0 23186 312 0 0
sp_qd_handle_on_reserve_upd_sts 10326 10326 0 0.00 0 28539 53 0 0
sp_reserve_write_off 10326 10326 0 0.00 7 28562 151 0 0
sp_supplier_invoice 5868 5868 0 0.00 6 82844 3065 0 0
sp_supplier_order 5706 5706 0 0.00 5 50603 1192 0 0
srv_aggregate_perf_data 122 122 0 0.00 2626 123311 13388 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1390 141971 31693 0 0
srv_find_qd_qs_mism 1091813 1091813 0 0.00 0 9516 5 0 0
srv_make_invnt_saldo 618 618 0 0.00 36 41555 903 0 0
srv_make_money_saldo 878 878 0 0.00 1 13851 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 273814 402104 346115 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5200 5200 0 0.00 0 13432 173 0 0
t$perf-norm:sp_cancel_adding_invoice 456 456 0 0.00 0 3430 97 0 0
t$perf-norm:sp_cancel_client_order 1941 1941 0 0.00 0 2890 13 0 0
t$perf-norm:sp_cancel_customer_reserve 749 749 0 0.00 0 6212 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 7618 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 2901 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 1300 19 0 0
t$perf-norm:sp_cancel_supplier_order 447 447 0 0.00 0 37684 1503 0 0
t$perf-norm:sp_cancel_write_off 1058 1058 0 0.00 0 8375 20 0 0
t$perf-norm:sp_client_order 21338 21338 0 0.00 0 23848 23 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 1635 8 0 0
t$perf-norm:sp_pay_from_customer 7467 7467 0 0.00 0 23844 18 0 0
t$perf-norm:sp_pay_to_supplier 6125 6125 0 0.00 0 7637 11 0 0
t$perf-norm:sp_reserve_write_off 10326 10326 0 0.00 0 11583 12 0 0
t$perf-norm:sp_supplier_invoice 5868 5868 0 0.00 0 10260 21 0 0
t$perf-norm:sp_supplier_order 5706 5706 0 0.00 0 11814 18 0 0
t$perf-norm:srv_aggregate_perf_data 122 122 0 0.00 0 397 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 2612 17 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 1120 18 0 0
t$perf-norm:srv_make_money_saldo 878 878 0 0.00 0 912 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 10516 10360 156 1.48 0 3740 15 0 156
v_all_customers 38912 38912 0 0.00 0 34 1 0 0
v_all_suppliers 32058 32058 0 0.00 0 30 1 0 0
v_all_wares 42676 42676 0 0.00 0 74 1 0 0
v_cancel_adding_invoice 912 912 0 0.00 0 2743 12 0 0
v_cancel_client_order 3882 3882 0 0.00 0 3451 6 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 3892 12 0 0
v_cancel_customer_reserve 1498 1498 0 0.00 0 1051 4 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 712 4 0 0
v_cancel_supplier_invoice 826 820 6 0.72 0 11504 30 0 6
v_cancel_supplier_order 894 894 0 0.00 0 736 5 0 0
v_cancel_write_off 2116 2116 0 0.00 0 1580 12 0 0
v_max_id_clo_ord 5706 5706 0 0.00 0 631 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 2746 20 0 0
v_max_id_ord_sup 5868 5868 0 0.00 0 4062 5 0 0
v_max_non_paid_invoice 1670 1670 0 0.00 0 314 2 0 0
v_max_non_paid_realizn 3994 3994 0 0.00 0 2332 4 0 0
v_min_id_clo_ord 5706 5706 0 0.00 0 8353 5 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 4102 11 0 0
v_min_id_ord_sup 5868 5868 0 0.00 0 4103 5 0 0
v_min_non_paid_invoice 6125 6125 0 0.00 0 12490 10 0 0
v_min_non_paid_realizn 7467 7467 0 0.00 0 9026 11 0 0
v_our_firm 10710 10710 0 0.00 0 15 1 0 0
v_reserve_write_off 20650 20650 0 0.00 0 3894 6 0 0
x_lock_depdocs_on_canc_invoice 11682 11682 0 0.00 0 13626 108 0 0
x_lock_depdocs_on_canc_sup_ord 447 447 0 0.00 0 13500 342 0 0
x_make_qstorno_1000_1200 5706 5706 0 0.00 2 50599 1116 0 0
x_make_qstorno_1200_2000 5868 5868 0 0.00 3 82814 2941 0 0
x_make_qstorno_2100_3300 492836 492836 0 0.00 0 49253 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-11-2020 19:28:04 to 03-11-2020 19:28:08.

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:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 22271 8192000000 10275578864 10581827584 949578976 10.387 73 52 105 0 969318928 2719360 17020592
16:57:42 36094 8192000000 10357458304 10676195328 1393534800 14.537 100 85 170 0 1426630320 5404560 27690960
16:58:27 32184 8192000000 10390392096 10718261248 1439257152 14.943 100 87 174 2 1479002032 11219952 28524928
16:59:14 14355 8192000000 10422234352 10755338240 1478083376 15.285 100 86 172 0 1513236528 7634128 27519024
16:59:42 22391 8192000000 10446617248 10781069312 1499380528 15.471 100 87 174 0 1535650784 8516192 27754064
17:00:15 10973 8192000000 10454586848 10792591360 1515777024 15.614 100 90 180 1 1553412224 9115520 28519680
17:00:36 26646 8192000000 10481622832 10821480448 1532640048 15.760 100 89 178 1 1570513696 9745760 28127888
17:01:11 13726 8192000000 10489945248 10836410368 1547418640 15.888 100 83 166 1 1583527488 10135920 25972928
17:01:37 2813 8192000000 10510936448 10856996864 1569798304 16.081 100 89 178 0 1607419456 10278608 27342544
17:01:49 13708 8192000000 10529611568 10882031616 1584285856 16.205 100 81 162 0 1619378944 10409824 24683264
17:02:10 16695 8192000000 10550083984 10907820032 1602486064 16.361 100 76 152 0 1635793744 10311440 22996240
17:02:39 11670 8192000000 10567141648 10932228096 1636765536 16.652 100 74 147 3 1669207664 10638880 21803248
17:03:02 12652 8192000000 10609503312 10973794304 1660744432 16.855 100 76 150 1 1694501360 11795216 21961712
17:03:22 10696 8192000000 10623426416 10991030272 1684018240 17.051 100 81 162 0 1719548976 12193984 23336752
17:03:42 9333 8192000000 10641404064 11009892352 1699823280 17.184 100 83 166 0 1737336192 13139376 24373536
17:04:00 8925 8192000000 10648600208 11017228288 1708292624 17.254 100 83 166 1 1746389760 14039344 24057792
17:04:16 6332 8192000000 10652581872 11024314368 1712571408 17.290 100 78 154 3 1748937136 14220784 22144944
17:04:30 6285 8192000000 10672271008 11045703680 1730350688 17.438 100 76 151 0 1765607264 13973632 21282944
17:04:45 6203 8192000000 10687607024 11063091200 1747459936 17.581 100 74 148 1 1780836416 12061792 21314688
17:05:00 6822 8192000000 10694988944 11071909888 1756184928 17.653 100 75 150 1 1790251488 12665744 21400816
17:05:13 5161 8192000000 10711523008 11093172224 1767880976 17.750 100 72 142 0 1799433024 11773264 19778784
17:05:26 4624 8192000000 10716188432 11096035328 1785581696 17.895 100 82 163 1 1821124848 12617760 22925392
17:05:37 6449 8192000000 10727433920 11108515840 1783801376 17.881 100 74 147 0 1817457968 13058256 20598336
17:05:50 3314 8192000000 10734834896 11113156608 1791325248 17.943 100 84 169 0 1827206080 12611968 23268864
17:06:00 10731 8192000000 10721594000 11110539264 1793643216 17.962 100 78 154 1 1828886368 13928912 21314240
17:06:18 3384 8192000000 10732406720 11120664576 1800294608 18.016 100 72 140 3 1832591424 12745248 19551568
17:06:29 3693 8192000000 10761627664 11144245248 1819625920 18.175 100 84 168 3 1857028496 14370256 23032320
17:06:39 3708 8192000000 10770090976 11153412096 1823916400 18.210 100 83 166 0 1861958528 14825712 23216416
17:06:50 3515 8192000000 10771037616 11157884928 1827300864 18.237 100 78 156 0 1862561760 12982864 22278032
17:07:00 2479 8192000000 10770419984 11156647936 1833164800 18.285 100 88 174 1 1871021408 13572864 24283744
17:07:09 2149 8192000000 10781311040 11171344384 1840276768 18.343 100 86 170 1 1878261136 13736320 24248048
17:07:19 2711 8192000000 10792104320 11179409408 1852130432 18.439 100 81 162 1 1887892176 11917216 23844528
17:07:28 2726 8192000000 10788827072 11179474944 1852121360 18.439 100 82 161 2 1886320288 11298176 22900752
17:07:37 2133 8192000000 10806678288 11192356864 1858138048 18.488 100 91 180 0 1895473504 12622128 24713328
17:07:46 2012 8192000000 10809400704 11197497344 1865569360 18.548 100 93 184 1 1906088880 13614384 26905136
17:07:54 1849 8192000000 10808277472 11196678144 1863029136 18.528 100 92 185 5 1902142112 13758336 25354640
17:08:03 1497 8192000000 10813550272 11202383872 1865307280 18.546 100 94 187 1 1906067472 13876432 26883760
17:08:11 2249 8192000000 10811527168 11200933888 1866329904 18.555 100 86 172 0 1904865408 13659344 24876160
17:08:19 1584 8192000000 10820151280 11207430144 1871734704 18.598 100 94 186 1 1912589248 14584528 26270016
17:08:27 4949 8192000000 10811438032 11204509696 1869258672 18.578 100 84 168 0 1905351296 12576464 23516160
17:08:38 2390 8192000000 10820582432 11209347072 1875418256 18.628 100 90 180 1 1913817280 12707632 25691392
17:08:47 1808 8192000000 10815641200 11209691136 1874923376 18.624 100 93 189 3 1913439088 11469248 27046464
17:09:07 9222 8192000000 10790886288 11204763648 1871529360 18.597 100 64 128 1 1898892560 9544640 17818560
17:09:23 4224 8192000000 10788009312 11203268608 1867853312 18.567 100 48 96 1 1890033984 8974384 13206288
17:09:36 5058 8192000000 10794428400 11209527296 1870235536 18.586 100 41 82 1 1890273296 8242880 11794880
17:09:48 2631 8192000000 10798851744 11215892480 1872680720 18.606 100 46 92 0 1899646320 14511088 12454512
17:09:58 2032 8192000000 10792428960 11210571776 1871015984 18.592 100 38 73 2 1889453408 8112448 10324976
17:10:06 6638 8192000000 10785498576 11208613888 1870860784 18.591 100 30 58 2 1885977296 6627536 8488976
17:10:20 6139 8192000000 10789719776 11212484608 1875753792 18.631 100 33 66 0 1893467120 8562528 9150800
17:10:33 3153 8192000000 10796985456 11217330176 1881305360 18.676 100 27 55 0 1895209344 5713984 8190000
17:10:43 7077 8192000000 10797140768 11218722816 1879975088 18.665 100 32 64 1 1896681360 8113440 8592832
17:10:57 8131 8192000000 10785235504 11218636800 1878371824 18.652 100 20 40 0 1890591344 6093168 6126352
17:11:12 1740 8192000000 10818664048 11227693056 1888092352 18.730 100 52 102 3 1909417728 6307232 15018144
17:11:21 5589 8192000000 10807378976 11229667328 1889819824 18.744 100 35 71 1 1907796544 7917072 10059648
17:11:33 8736 8192000000 10802769376 11225694208 1890031488 18.746 100 34 66 2 1905134464 6300096 8802880
17:11:51 18225 8192000000 10795795360 11230089216 1886536560 18.718 100 13 26 1 1895716672 5556496 3623616
17:12:20 53037 8192000000 10848625968 11251372032 1894895216 18.785 100 42 84 1 1913039888 5133792 13010880
17:13:19 15182 8192000000 10806976832 11241938944 1893169936 18.771 100 25 49 1 1906705952 6860912 6675104
17:13:42 8670 8192000000 10805714896 11240484864 1896216912 18.796 100 21 41 0 1908369856 6743072 5409872
17:13:57 5199 8192000000 10822789696 11251933184 1903368768 18.853 100 42 83 2 1924685632 9707120 11609744
17:14:11 4306 8192000000 10815940656 11246067712 1901194144 18.836 100 32 65 0 1916801072 6877872 8729056
17:14:22 6343 8192000000 10817164992 11248807936 1902687760 18.848 100 30 60 1 1919007680 6158432 10161488
17:14:35 5417 8192000000 10825688944 11255926784 1907248256 18.885 100 42 82 0 1927480304 8405568 11826480
17:14:48 5367 8192000000 10822134848 11255140352 1909607136 18.903 100 43 85 1 1929109136 6121392 13380608
17:15:01 4807 8192000000 10820724448 11255332864 1907123520 18.884 100 33 66 2 1923203280 6352384 9727376
17:15:12 7313 8192000000 10809869744 11250413568 1906648352 18.880 100 24 48 1 1919393792 5906016 6839424
17:15:26 10889 8192000000 10811369296 11257618432 1910518976 18.911 100 16 33 0 1925521760 9888528 5114256
17:15:43 9005 8192000000 10830097472 11265286144 1909966320 18.906 100 13 26 1 1922893472 9471056 3456096
17:15:58 7655 8192000000 10829116240 11267338240 1914516512 18.943 100 24 47 0 1926875520 5776864 6582144
17:16:12 9728 8192000000 10837571888 11260567552 1898080672 18.811 99 20 40 1 1909098176 5049904 5967600
17:16:28 12587 8192000000 10826443168 11264540672 1917440896 18.966 100 26 51 2 1931141904 6384112 7316896
17:16:50 48338 8192000000 10821229168 11225014272 1855186384 18.464 98 48 90 3 1874170432 6087936 12896112
17:17:44 7967 8192000000 10786928224 11220606976 1874778448 18.623 100 15 30 1 1884217456 5093952 4345056
17:17:58 7442 8192000000 10782354352 11210031104 1844178080 18.375 98 34 69 0 1860249376 6850160 9221136
17:18:14 6906 8192000000 10820038880 11238334464 1884568192 18.702 100 26 53 1 1897811776 5612976 7630608
17:18:28 7559 8192000000 10780614320 11208929280 1827550784 18.239 97 18 36 2 1837985312 5500016 4934512
17:18:41 5613 8192000000 10776902800 11201785856 1820531408 18.182 97 29 58 1 1835182240 5763056 8887776
17:18:53 5401 8192000000 10776218704 11200073728 1832788528 18.282 98 34 66 0 1855805168 14547648 8468992
17:19:09 8631 8192000000 10770971536 11188404224 1790828112 17.939 96 29 58 0 1805410016 5999536 8582368
17:19:23 11370 8192000000 10742608240 11160272896 1767857904 17.749 96 26 52 1 1780774256 5152320 7764032
17:19:42 12250 8192000000 10691993328 11100987392 1653168144 16.791 90 24 48 1 1666406896 5804672 7434080
17:20:00 12897 8192000000 10683169776 11094306816 1618933248 16.501 90 17 34 1 1628724544 4504528 5286768
17:20:21 15195 8192000000 10693896736 11104546816 1661636704 16.863 93 20 40 0 1673125232 4801328 6687200
17:20:43 5270 8192000000 10719829312 11127582720 1761825152 17.699 98 23 47 3 1774240352 5494688 6920512
17:20:54 6763 8192000000 10698866176 11110928384 1735628080 17.482 97 20 40 1 1746831216 5613856 5589280
17:21:08 65066 8192000000 10713609600 11134177280 1775521840 17.813 98 25 50 2 1788076736 5570928 6983968
17:22:21 9827 8192000000 10687097360 11107762176 1716346672 17.322 95 18 36 0 1727351408 5530128 5474608
17:22:39 13416 8192000000 10731574016 11146391552 1772958880 17.791 98 26 52 1 1785980128 5408608 7612640
17:23:00 7361 8192000000 10728812704 11146768384 1800852256 18.021 99 32 62 0 1815406544 5498432 9055856
17:23:17 5853 8192000000 10730547664 11151544320 1815345824 18.140 100 30 60 1 1831131648 7214928 8570896
17:23:30 5278 8192000000 10740656064 11162353664 1807377760 18.074 99 23 46 1 1819422912 5572256 6472896
17:23:43 5290 8192000000 10740476080 11167744000 1829896832 18.258 100 24 49 0 1842162992 5588080 6678080
17:23:55 3226 8192000000 10752185184 11168989184 1834616464 18.297 100 50 103 1 1855845216 6913584 14315168
17:24:06 10245 8192000000 10754945792 11179831296 1837101232 18.317 100 14 28 2 1846342272 5253488 3987552
17:24:23 9294 8192000000 10769013840 11194167296 1852681968 18.444 100 26 51 0 1865825664 5541360 7602336
17:24:39 10551 8192000000 10777292576 11200794624 1857517424 18.483 100 25 51 3 1871104784 5093472 8493888
17:24:55 9093 8192000000 10785726640 11209076736 1859237520 18.497 100 15 30 3 1869175856 5515632 4422704
17:25:11 6041 8192000000 10765412704 11198636032 1860177936 18.505 100 17 34 1 1871508784 5753680 5577168
17:25:23 12047 8192000000 10772478224 11203395584 1864482272 18.540 100 20 40 1 1875527392 5508976 5536144
17:25:45 48869 8192000000 10783307856 11210579968 1871969904 18.600 100 29 58 0 1886462704 4649664 9843136
17:26:49 33989 8192000000 10809180112 11230736384 1871789200 18.599 100 21 42 0 1883073184 5343632 5940352
17:27:33 10892 8192000000 10825564320 11245735936 1900530512 18.831 100 51 100 2 1922149664 7094928 14524224
17:27:50 11266 8192000000 10838833296 11258544128 1910088944 18.907 100 51 102 2 1932487376 8485696 13912736
17:28:11 7436 8192000000 10842284480 11263754240 1913652368 18.936 100 44 86 1 1934625744 9316288 11657088
17:28:28 17860 8192000000 10847467024 11272409088 1919088304 18.980 100 43 82 2 1938945632 8246000 11611328
17:29:02 27158 8192000000 10862103920 11289628672 1930503056 19.071 100 37 74 2 1950897392 10613168 9781168
17:29:40 33578 8192000000 10874397696 11307106304 1943439696 19.174 100 39 78 1 1965650352 10889520 11321136
17:30:20 13584 8192000000 10877641312 11310362624 1948738192 19.216 100 40 80 1 1972859440 12102512 12018736
17:31:02 20953 8192000000 10902360032 11330146304 1961454864 19.318 100 37 75 2 1987032832 14395600 11182368
17:31:30 5936 8192000000 10923530032 11334602752 1968647760 19.375 100 58 116 0 2001643168 16037376 16958032
17:31:44 5526 8192000000 10911658688 11338686464 1973481904 19.413 100 56 112 0 2007394560 17177536 16735120
17:31:57 11620 8192000000 10917759328 11348832256 1975371360 19.428 100 54 106 1 2008845808 17992096 15482352
17:32:18 16038 8192000000 10934063872 11357929472 1985373664 19.507 100 49 98 1 2019279520 19393968 14511888
17:32:42 16369 8192000000 10926311072 11359047680 1984904576 19.504 100 39 78 1 2016274400 19429696 11940128
17:33:06 13679 8192000000 10938791632 11370868736 1991486816 19.556 100 49 98 2 2031078224 25137648 14453760
17:33:29 18392 8192000000 10941436416 11372929024 1992776784 19.566 100 52 104 1 2030753776 22182544 15794448
17:33:55 29775 8192000000 10938097760 11377205248 1993942768 19.575 100 37 74 1 2029584992 23649664 11992560
17:34:40 10718 8192000000 10942912192 11384119296 1999602896 19.620 100 32 64 3 2034691184 24531984 10556304
17:35:00 9750 8192000000 10946289520 11384426496 2001346720 19.633 100 38 75 1 2036825392 23688480 11790192
17:35:20 10500 8192000000 10959443264 11394793472 2011771504 19.715 100 60 118 3 2056945120 26074064 19099552
17:35:40 23045 8192000000 10958253152 11399786496 2009323040 19.696 100 47 93 1 2051547648 27071024 15153584
17:36:16 10013 8192000000 10960987312 11397095424 2007598912 19.683 100 40 80 0 2045038704 24978608 12461184
17:36:34 6379 8192000000 10976410160 11399049216 2014344528 19.736 100 58 115 1 2057737232 25104224 18288480
17:36:48 3087 8192000000 10974107088 11396407296 1999794176 19.621 99 76 153 4 2048028928 24848880 23385872
17:37:01 9866 8192000000 10965549712 11396038656 2008391312 19.689 100 60 120 0 2052783472 26121360 18270800
17:37:20 2491 8192000000 10977142704 11402031104 2015244400 19.743 100 67 131 1 2064589664 29837536 19507728
17:37:30 2709 8192000000 10989178240 11411066880 2023137808 19.805 100 91 180 0 2081722720 31284112 27300800
17:37:40 4414 8192000000 10996684336 11412295680 2021727296 19.794 100 83 168 1 2080452576 32308208 26417072
17:37:52 1765 8192000000 10990655168 11407568896 2004350768 19.657 99 89 175 0 2064642256 34194048 26097440
17:38:01 1442 8192000000 10994257552 11412541440 2019782624 19.778 100 91 184 2 2081748128 34050704 27914800
17:38:09 2730 8192000000 10991331232 11413065728 2018956096 19.772 100 78 156 0 2077320720 34722880 23641744
17:38:20 2486 8192000000 10999044528 11421114368 2027993776 19.843 100 91 184 0 2091135552 35338672 27803104
17:38:30 3749 8192000000 11000772864 11420749824 2023747136 19.810 100 78 156 0 2085407664 37063616 24596912
17:38:41 1935 8192000000 10976525824 11397062656 1979115776 19.458 98 82 163 0 2037141456 33805328 24220352
17:38:51 4157 8192000000 10977624896 11405504512 2009068880 19.694 100 76 150 0 2065064400 33231264 22764256
17:39:04 9354 8192000000 10984055056 11412758528 2012722256 19.723 100 71 142 0 2068692128 34450816 21519056
17:39:25 1599 8192000000 10993895488 11409252352 1999412768 19.618 99 92 181 2 2060761568 34259888 27088912
17:39:33 2336 8192000000 10992778976 11415293952 2020753584 19.786 100 87 174 0 2080084480 33008336 26322560
17:39:42 2539 8192000000 10976744864 11402375168 2004621136 19.659 100 78 156 1 2059520208 31355856 23543216
17:39:51 2229 8192000000 10974390832 11400527872 2010211520 19.703 100 91 183 1 2069394000 31780016 27402464
17:40:00 3080 8192000000 10951182656 11379089408 1987181680 19.522 99 74 147 1 2040080128 30686512 22211936
17:40:11 2339 8192000000 10965149696 11390803968 1996985872 19.599 100 73 148 0 2047330976 29083104 21262000
17:40:31 6341 8192000000 10959839344 11383373824 1991246336 19.554 100 77 153 2 2045417040 30747376 23423328
17:40:45 3066 8192000000 10971085184 11392319488 2000992944 19.631 100 80 159 1 2055559248 30491040 24075264
17:40:56 3753 8192000000 10972023040 11385155584 1993059008 19.568 100 74 147 0 2044739648 30123184 21557456
17:41:09 3330 8192000000 10955750336 11375902720 1983268720 19.491 99 84 166 0 2038983248 30779600 24934928
17:41:21 7947 8192000000 10944640704 11370364928 1982307232 19.483 100 74 148 1 2032969536 28408928 22253376
17:41:36 6893 8192000000 10959728304 11381923840 1988571472 19.533 100 75 150 0 2043159600 31547856 23040272
17:41:52 4102 8192000000 10930196704 11350269952 1931054544 19.075 97 81 159 0 1989983696 34077776 24851376
17:42:04 1907 8192000000 10970849536 11383136256 1988353376 19.531 100 82 163 3 2046149264 33726352 24069536
17:42:13 1788 8192000000 10975724512 11386011648 1988246672 19.530 100 89 178 1 2050049088 34964512 26837904
17:42:22 2394 8192000000 10973009264 11386789888 1991644512 19.557 100 88 174 3 2054424432 35624576 27155344
17:42:31 2185 8192000000 10941837888 11365048320 1958761280 19.296 99 75 151 0 2019542464 36830016 23951168
17:42:42 9304 8192000000 10922437632 11355971584 1946789456 19.201 99 58 112 0 1998727568 34754720 17183392
17:43:00 1963 8192000000 10969615840 11383926784 1987907680 19.527 100 90 179 0 2056074384 39272720 28893984
17:43:10 2869 8192000000 10959517312 11386490880 1984874768 19.503 100 54 108 1 2042187584 40380400 16932416
17:43:20 1595 8192000000 10985563392 11396816896 1994632464 19.580 100 86 173 4 2061593168 41118256 25842448
17:43:30 3481 8192000000 10968779440 11395825664 1995658912 19.588 100 65 130 1 2055095584 39889568 19547104
17:43:42 1717 8192000000 10970564640 11378266112 1975411824 19.428 99 89 180 1 2040699552 37815056 27472672
17:43:53 2415 8192000000 10959768384 11379339264 1966134192 19.355 99 86 171 1 2031969712 38976864 26858656
17:44:04 5259 8192000000 10965830176 11377930240 1982539856 19.485 100 81 161 2 2046346816 39943488 23863472
17:44:16 1388 8192000000 10979751056 11391324160 1994315488 19.578 100 88 175 0 2056149888 35769120 26065280
17:44:25 3339 8192000000 10943831888 11373522944 1964716928 19.344 99 62 123 1 2018917424 35578960 18621536
17:44:41 5427 8192000000 10943582240 11379576832 1980167776 19.466 100 48 92 2 2030517104 35719456 14629872
17:45:00 4695 8192000000 10966586128 11387850752 1987836992 19.527 100 68 136 2 2045096352 35985040 21274320
17:45:12 7779 8192000000 10947779920 11382231040 1967554752 19.366 99 40 80 0 2018050608 37365984 13129872
17:45:28 5017 8192000000 10917928832 11354021888 1943903376 19.178 99 46 92 0 1996979040 37712784 15362880
17:45:54 5956 8192000000 10923391856 11356463104 1947874448 19.210 100 39 78 0 1999230128 38714208 12641472
17:46:10 10006 8192000000 10918698944 11349278720 1930814144 19.073 99 39 77 2 1988152800 44192512 13146144
17:46:32 9799 8192000000 10940649376 11370520576 1964018368 19.338 100 44 88 4 2021031808 42259760 14753680
17:46:51 10945 8192000000 10945589648 11377029120 1965848688 19.353 100 45 90 2 2025765840 44757664 15159488
17:47:10 14213 8192000000 10938361488 11378102272 1968669904 19.375 100 48 96 0 2029746592 45179632 15897056
17:47:32 10587 8192000000 10936273248 11382128640 1971263152 19.395 100 27 54 0 2014954336 33775824 9915360
17:47:54 5429 8192000000 10945269248 11375366144 1973198176 19.411 100 53 104 2 2026518528 35622544 17697808
17:48:07 23539 8192000000 10903475056 11334709248 1911471872 18.918 97 45 90 1 1963005856 36962928 14571056
17:48:38 21276 8192000000 10912825184 11365916672 1958663888 19.295 100 32 64 1 2007589552 38343200 10582464
17:49:07 37008 8192000000 10917682304 11372351488 1941805776 19.161 99 27 54 0 1986959888 35967040 9187072
17:49:52 34347 8192000000 10914184080 11369320448 1940908496 19.154 99 19 38 0 1990574016 42989216 6676304
17:50:32 22324 8192000000 10901145600 11351711744 1927633136 19.048 99 23 46 2 1980916272 44586720 8696416
17:51:03 21971 8192000000 10895078528 11343568896 1923045232 19.011 99 26 52 2 1974346608 41638048 9663328
17:51:36 19098 8192000000 10890303696 11365187584 1933605824 19.096 100 21 42 1 1985587888 44324272 7657792
17:52:09 52536 8192000000 10847548864 11308961792 1847677152 18.403 96 12 24 0 1880687264 28800208 4209904
17:53:24 79690 8192000000 10819070240 11262926848 1794213472 17.966 94 14 29 1 1809822128 11350896 4257760
17:55:04 141881 8192000000 10827627552 11261796352 1819073456 18.170 95 40 79 0 1837926608 7484656 11368496
17:57:32 58949 8192000000 10881308688 11314655232 1903848528 18.857 99 44 87 0 1927048960 10460336 12740096
17:58:41 58767 8192000000 10868308960 11310276608 1908009312 18.891 98 31 62 0 1931087520 14105472 8972736
17:59:51 51059 8192000000 10890889440 11354140672 1963396288 19.333 100 30 60 3 1986236608 13285232 9555088
18:01:46 33776 8192000000 10898489696 11333136384 1947468272 19.206 99 33 66 1 1968309792 11537440 9304080
18:02:26 9714 8192000000 10895639936 11349880832 1964986000 19.346 100 32 63 1 1986963536 12981328 8996208
18:02:45 19629 8192000000 10902594992 11358887936 1971118160 19.394 100 20 39 1 1989402480 12519024 5765296
18:03:11 17098 8192000000 10923401456 11366969344 1979503904 19.461 100 37 73 1 2005013104 14566000 10943200
18:03:51 31195 8192000000 10927634272 11379568640 1990085392 19.544 100 54 108 1 2025955136 18670496 17199248
18:04:46 44132 8192000000 10908627872 11385864192 1970517616 19.390 99 41 82 3 2006433696 23558080 12358000
18:05:55 32414 8192000000 10908744448 11388170240 1980278672 19.467 100 19 38 0 2005903232 19010336 6614224
18:06:40 32869 8192000000 10908730512 11378487296 1984359968 19.499 100 11 22 0 1999391104 11786256 3244880
18:07:22 32227 8192000000 10913612064 11384016896 1991621968 19.557 100 10 20 1 2006840848 12251808 2967072
18:08:00 58224 8192000000 10915071888 11394842624 1998766176 19.613 100 22 44 2 2021200512 15358256 7076080
18:09:05 32912 8192000000 10914529488 11402489856 1989952768 19.543 100 6 12 0 2004642416 12761952 1927696
18:09:47 58169 8192000000 10907422096 11375984640 1932112576 19.084 97 14 28 0 1949350000 12952928 4284496
18:10:53 28910 8192000000 10901734544 11374997504 1955662512 19.272 99 22 41 1 1976266272 14299456 6304304
18:11:31 29760 8192000000 10910355088 11381551104 1982293104 19.483 100 32 64 2 2000413120 9491104 8628912
18:12:11 64683 8192000000 10899958096 11371175936 1930805136 19.073 97 29 58 2 1948262368 9668480 7788752
18:13:23 79588 8192000000 10908952272 11381911552 1933218928 19.093 98 14 28 1 1946711184 9701424 3790832
18:15:03 62894 8192000000 10904476208 11383099392 1976033936 19.433 100 10 20 1 1993966512 14518064 3414512
18:16:13 27714 8192000000 10920005232 11386806272 1985719328 19.510 100 28 56 0 2004180320 10634496 7826496
18:16:48 96458 8192000000 10903185488 11379535872 1948619296 19.215 98 6 12 0 1962054672 11989552 1445824
18:18:37 53274 8192000000 10935194064 11390525440 1929066064 19.059 97 24 47 2 1947079312 10736272 7276976
18:19:38 83145 8192000000 10911591424 11376627712 1929390256 19.062 97 11 22 1 1951499504 18836912 3272336
18:21:08 67264 8192000000 10914373760 11393908736 1956642432 19.279 99 8 16 0 1973032752 13811040 2579280
18:22:22 47763 8192000000 10925812592 11397713920 1941173040 19.156 98 24 47 1 1969145824 20874384 7098400
18:23:22 115140 8192000000 10905031216 11373735936 1958177488 19.292 99 24 48 1 1980640912 15155440 7307984
18:25:29 104096 8192000000 10897845472 11354087424 1923978256 19.019 97 21 41 2 1941489408 11313920 6197232
18:27:19 1406 8192000000 10893577920 11326783488 1911390080 18.918 97 83 169 5 1943404640 8435744 23578816
18:27:30 42292 8192000000 10905473536 11352592384 1950456720 19.230 100 43 84 2 1974590368 12412320 11721328
18:28:31 72267 8192000000 10884022560 11366653952 1946937760 19.202 99 11 22 1 1964643344 14572864 3132720
18:29:49 28564 8192000000 10865449344 11344781312 1927356656 19.046 98 9 18 1 1941145632 10510240 3278736
18:30:24 7169 8192000000 10864000096 11347083264 1946408432 19.198 100 3 6 0 1956337280 9521856 406992
18:30:38 31225 8192000000 10833948480 11303649280 1857619216 18.484 95 8 16 1 1869588896 10169696 1799984
18:31:15 42653 8192000000 10846937232 11321307136 1901795184 18.841 98 12 24 1 1912348944 7388288 3165472
18:32:05 34329 8192000000 10832283136 11315523584 1922064208 19.003 100 7 14 0 1931384880 7798352 1522320
18:32:51 65180 8192000000 10875949408 11345186816 1921962720 19.003 98 16 32 1 1932663760 6391248 4309792
18:34:03 45233 8192000000 10875826736 11342487552 1903839312 18.857 97 16 32 0 1919292736 10724032 4729392
18:34:54 33773 8192000000 10888265728 11359350784 1950077120 19.227 100 19 38 0 1966589216 10668240 5843856
18:36:01 40851 8192000000 10885562736 11324960768 1878609312 18.654 96 37 74 2 1902592880 13080032 10903536
18:36:51 20739 8192000000 10883821280 11338493952 1923937600 19.018 99 50 100 1 1957271136 18207568 15125968
18:37:33 75199 8192000000 10820284144 11276460032 1821354000 18.189 94 24 49 0 1840053040 12027600 6671440
18:38:54 71915 8192000000 10836906608 11284389888 1821892416 18.193 95 10 20 1 1836693296 12323280 2477600
18:40:16 60399 8192000000 10862520080 11330740224 1914402176 18.942 99 22 44 1 1930756272 9528112 6825984
18:41:26 69560 8192000000 10836033280 11288633344 1772699936 17.789 92 26 52 1 1795368752 15558800 7110016
18:42:42 56200 8192000000 10858618976 11300372480 1875600080 18.630 98 24 48 0 1893193952 11023696 6570176
18:43:44 27471 8192000000 10869321280 11321065472 1919946592 18.986 100 35 68 2 1942665488 13073312 9645584
18:44:18 90692 8192000000 10878216928 11341258752 1892468128 18.766 98 25 50 1 1914080704 14758432 6854144
18:45:55 71011 8192000000 10861737088 11341737984 1884094288 18.698 97 24 48 0 1907618496 15861936 7662272
18:47:42 95003 8192000000 10882583808 11339882496 1922725856 19.009 99 28 56 0 1939249712 8227344 8296512
18:49:34 43375 8192000000 10887015712 11345199104 1940257088 19.149 99 26 52 0 1959931776 12437248 7237440
18:50:27 20163 8192000000 10878236336 11340963840 1949538704 19.223 100 27 54 2 1970785664 14003728 7243232
18:50:55 67705 8192000000 10849414816 11328438272 1870879808 18.591 96 10 21 0 1888247072 14006480 3360784
18:52:13 50494 8192000000 10851873984 11331362816 1929255120 19.061 100 5 10 2 1944166368 13395696 1515552
18:53:13 25330 8192000000 10848439216 11322482688 1896985552 18.802 98 6 12 0 1914350272 15601520 1763200
18:53:45 39871 8192000000 10856822384 11334877184 1931279056 19.077 100 5 10 0 1948517920 15296704 1942160
18:54:31 69974 8192000000 10871989728 11342716928 1940582992 19.151 100 10 20 1 1959220784 15470336 3167456
18:56:44 97754 8192000000 10885190160 11366211584 1940677232 19.152 99 15 30 1 1959340784 13920032 4743520
18:58:28 53650 8192000000 10891116672 11361603584 1934368416 19.102 98 13 25 1 1947517472 10118352 3030704
18:59:51 63370 8192000000 10905247024 11379523584 1964333104 19.340 99 10 20 0 1976025184 8837936 2854144
19:01:06 90892 8192000000 10909800992 11390169088 1961863088 19.321 99 16 32 0 1977894448 11453072 4578288
19:02:43 39900 8192000000 10940906400 11390726144 1978058800 19.449 99 39 77 2 1998525456 9575200 10891456
19:03:30 21238 8192000000 10948822448 11400028160 1986637856 19.517 99 47 93 0 2012008912 11989776 13381280
19:03:59 59690 8192000000 10932755344 11405828096 1984085696 19.497 99 30 60 0 2009064000 16427552 8550752
19:05:15 141971 8192000000 10917611936 11392524288 1937705680 19.128 97 8 16 1 1953872016 13756240 2410096
19:09:33 50260 8192000000 10911265344 11376713728 1935289520 19.109 97 28 56 0 1952132752 9017584 7825648
19:10:30 46394 8192000000 10911494592 11364237312 1930000672 19.067 97 39 80 2 1950747536 9822224 10924640
19:11:25 19923 8192000000 10910013344 11362631680 1962411216 19.325 99 61 121 1 1989335744 9649520 17275008
19:12:09 92387 8192000000 10901935440 11387940864 1981991808 19.480 100 20 41 2 1997844560 10400752 5452000
19:15:00 55445 8192000000 10883598720 11367874560 1957986416 19.290 99 24 48 2 1974149952 9986768 6176768
19:16:01 33418 8192000000 10879708912 11361767424 1964652784 19.343 100 6 12 0 1976153216 9513840 1986592
19:16:50 50591 8192000000 10897209536 11374669824 1971701024 19.399 100 10 20 0 1986396352 11106672 3588656
19:17:47 45129 8192000000 10886564928 11364872192 1938291296 19.133 98 14 27 1 1949341712 6608704 4441712
19:18:43 39411 8192000000 10858837216 11332882432 1870759248 18.590 95 11 22 0 1880927072 7350192 2817632
19:19:29 63965 8192000000 10838229984 11308892160 1774266352 17.802 91 5 9 1 1782233168 6342576 1624240
19:20:43 21318 8192000000 10865772368 11321524224 1929862816 19.066 100 46 92 0 1950673760 7346240 13464704
19:21:19 14868 8192000000 10861154112 11314126848 1916071664 18.955 99 41 82 1 1937475200 9456752 11946784
19:21:53 39372 8192000000 10841532672 11302883328 1875856432 18.632 97 30 59 2 1894750224 9637280 9256512
19:22:42 42184 8192000000 10858772672 11327721472 1934405920 19.102 100 25 50 0 1950700416 9021104 7273392
19:23:39 58573 8192000000 10868980768 11336732672 1904402880 18.862 98 22 44 1 1924815104 13507344 6904880
19:24:45 61362 8192000000 10882691664 11345215488 1946644640 19.200 100 18 34 1 1965041840 13146544 5250656
19:25:57 76594 8192000000 9563787776 9910407168 671000416 7.570 35 3 6 0 676076032 4405872 669744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-11-2020 19:28:10 to 03-11-2020 19:28:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 78 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-11-2020 19:28:43 to 03-11-2020 19:28:45.

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          244021
MON$OLDEST_ACTIVE               244022
MON$OLDEST_SNAPSHOT             244022
MON$NEXT_TRANSACTION            244022
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                       2025952
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33384 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33384 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33384 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33384 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Tue Nov  3 19:27:18 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Tue Nov  3 19:27:18 2020
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Tue Nov  3 19:27:18 2020
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

03.11.20 19:28:46. 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-03 19:28:48 No severe PSQL-related problems occured
03.11.20 19:28:49. End of report.