Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.01.2021 01:29
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 17070232 kB
MemAvailable 31339028 kB
Buffers 0 kB
Cached 14645676 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-21 01:27:11
DTS_END                         2021-01-21 01:27:11.5120
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/36172
TRN_ID                          250824
ATT_ID                          688
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: 9521.68 18007 1142602
customer order: creation 184.76 339 22171
customer order: refuse 15.44 338 1853
order to supplier: creation 48.44 1201 5813
order to supplier: removal 3.62 96592 434
invoice (draft): creation 49.99 3358 5999
invoice (draft): removal 53.12 893 6374
invoice accept: apply 44.40 18365 5328
invoice accept: cancel 47.78 811 5734
customer reserve: creation 4091.00 182 490920
customer reserve: removal 4666.23 57 559948
realization accept: apply 89.18 184 10701
realization accept: cancel 90.11 110 10813
payment from customer: creation 62.08 107 7449
payment from customer: removal 6.28 88 753
payment to supplier: creation 52.33 140 6279
payment to supplier: removal 3.46 73 415
service: total inventory turnovers 5.15 977 618
service: total monetary turnovers 7.38 43 885
service: aggregate perf. data 0.93 17196 111
service: refresh index statistics 0.03 219078 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-01-2021 01:29:36 to 21-01-2021 01:29:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4900
TEST_TIME 2 3158
TEST_TIME 3 4201
TEST_TIME 4 4485
TEST_TIME 5 4894
TEST_TIME 6 5099
TEST_TIME 7 5754
TEST_TIME 8 6100
TEST_TIME 9 6445
TEST_TIME 10 6734
TEST_TIME 11 6848
TEST_TIME 12 7154
TEST_TIME 13 7113
TEST_TIME 14 7410
TEST_TIME 15 7487
TEST_TIME 16 7464
TEST_TIME 17 7607
TEST_TIME 18 7582
TEST_TIME 19 7985
TEST_TIME 20 8111
TEST_TIME 21 8273
TEST_TIME 22 8298
TEST_TIME 23 8751
TEST_TIME 24 8786
TEST_TIME 25 9016
TEST_TIME 26 9127
TEST_TIME 27 9243
TEST_TIME 28 9676
TEST_TIME 29 10726
TEST_TIME 30 10982
TEST_TIME 31 11018
TEST_TIME 32 10965
TEST_TIME 33 10986
TEST_TIME 34 11013
TEST_TIME 35 11063
TEST_TIME 36 10990
TEST_TIME 37 10845
TEST_TIME 38 10701
TEST_TIME 39 10636
TEST_TIME 40 10468
TEST_TIME 41 10354
TEST_TIME 42 10595
TEST_TIME 43 10640
TEST_TIME 44 10478
TEST_TIME 45 10328
TEST_TIME 46 10340
TEST_TIME 47 10222
TEST_TIME 48 10204
TEST_TIME 49 10337
TEST_TIME 50 10277
TEST_TIME 51 10182
TEST_TIME 52 10065
TEST_TIME 53 10013
TEST_TIME 54 10032
TEST_TIME 55 10046
TEST_TIME 56 10059
TEST_TIME 57 10015
TEST_TIME 58 9934
TEST_TIME 59 10072
TEST_TIME 60 10061
TEST_TIME 61 10078
TEST_TIME 62 10097
TEST_TIME 63 10116
TEST_TIME 64 10086
TEST_TIME 65 10220
TEST_TIME 66 10238
TEST_TIME 67 10233
TEST_TIME 68 10275
TEST_TIME 69 10270
TEST_TIME 70 10195
TEST_TIME 71 10121
TEST_TIME 72 10120
TEST_TIME 73 10070
TEST_TIME 74 9992
TEST_TIME 75 9991
TEST_TIME 76 9994
TEST_TIME 77 9927
TEST_TIME 78 9904
TEST_TIME 79 9828
TEST_TIME 80 9804
TEST_TIME 81 9790
TEST_TIME 82 9857
TEST_TIME 83 9842
TEST_TIME 84 9818
TEST_TIME 85 9898
TEST_TIME 86 9911
TEST_TIME 87 9880
TEST_TIME 88 9867
TEST_TIME 89 9907
TEST_TIME 90 9905
TEST_TIME 91 9934
TEST_TIME 92 9928
TEST_TIME 93 9917
TEST_TIME 94 9846
TEST_TIME 95 9816
TEST_TIME 96 9758
TEST_TIME 97 9748
TEST_TIME 98 9694
TEST_TIME 99 9668
TEST_TIME 100 9660
TEST_TIME 101 9709
TEST_TIME 102 9690
TEST_TIME 103 9685
TEST_TIME 104 9698
TEST_TIME 105 9685
TEST_TIME 106 9699
TEST_TIME 107 9708
TEST_TIME 108 9680
TEST_TIME 109 9710
TEST_TIME 110 9689
TEST_TIME 111 9711
TEST_TIME 112 9687
TEST_TIME 113 9739
TEST_TIME 114 9762
TEST_TIME 115 9753
TEST_TIME 116 9673
TEST_TIME 117 9641
TEST_TIME 118 9634
TEST_TIME 119 9597
TEST_TIME 120 9523

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-01-2021 01:29:40 to 21-01-2021 01:29: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 1597049 1597049 0 0.00 0 26296 7 0 0
doc_list_biud 1597049 1597049 0 0.00 0 83183 26 0 0
sp_add_invoice_to_stock 5496 5328 168 3.05 19 164426 18366 0 168
sp_cancel_adding_invoice 5734 5734 0 0.00 3 58393 811 0 0
sp_cancel_client_order 1853 1853 0 0.00 4 19870 339 0 0
sp_cancel_customer_reserve 559948 559948 0 0.00 1 71024 57 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 3 9526 88 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 4128 73 0 0
sp_cancel_supplier_invoice 6391 6374 17 0.26 2 83191 894 0 17
sp_cancel_supplier_order 434 434 0 0.00 8 1055829 96593 0 0
sp_cancel_write_off 10813 10813 0 0.00 1 14631 111 0 0
sp_client_order 22171 22171 0 0.00 3 21906 339 0 0
sp_customer_reserve 490920 490920 0 0.00 0 39789 182 0 0
sp_fill_shopping_cart 33980 33980 0 0.00 1 13708 39 0 0
sp_fill_shopping_cart_clo_res 490918 490918 0 0.00 0 12969 13 0 0
sp_get_clo_for_invoice 5326 5326 0 0.00 0 38344 247 0 0
sp_kill_cost_storno 17715 17715 0 0.00 0 11527 54 0 0
sp_kill_qstorno_ret_qs2qd 1137517 1137517 0 0.00 0 83179 32 0 0
sp_kill_qty_storno 601183 601183 0 0.00 0 83182 69 0 0
sp_lock_selected_doc 22236 22236 0 0.00 0 7014 4 0 0
sp_make_cost_storno 29755 29755 0 0.00 0 20536 54 0 0
sp_multiply_rows_for_pdistr 29755 29755 0 0.00 0 11259 29 0 0
sp_multiply_rows_for_qdistr 22171 22171 0 0.00 0 17687 142 0 0
sp_pay_from_customer 7449 7449 0 0.00 4 12740 107 0 0
sp_pay_to_supplier 6279 6279 0 0.00 4 19291 140 0 0
sp_payment_common 13728 13728 0 0.00 1 19238 35 0 0
sp_qd_handle_on_cancel_clo 1853 1853 0 0.00 0 19862 312 0 0
sp_qd_handle_on_invoice_upd_sts 11060 11060 0 0.00 0 36120 339 0 0
sp_qd_handle_on_reserve_upd_sts 10701 10701 0 0.00 0 20134 62 0 0
sp_reserve_write_off 10701 10701 0 0.00 6 20555 185 0 0
sp_supplier_invoice 5999 5999 0 0.00 5 107258 3358 0 0
sp_supplier_order 5813 5813 0 0.00 4 30675 1202 0 0
srv_aggregate_perf_data 111 111 0 0.00 2705 171905 17196 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1275 145299 32021 0 0
srv_find_qd_qs_mism 1091670 1091670 0 0.00 0 26292 6 0 0
srv_make_invnt_saldo 618 618 0 0.00 27 23693 977 0 0
srv_make_money_saldo 885 885 0 0.00 0 8350 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 137992 287375 219078 0 0
t$perf-abend:sp_add_invoice_to_stock 168 168 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5328 5328 0 0.00 0 24278 158 0 0
t$perf-norm:sp_cancel_adding_invoice 458 458 0 0.00 1 2313 56 0 0
t$perf-norm:sp_cancel_client_order 1853 1853 0 0.00 0 1030 9 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 746 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 2800 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 2805 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 2110 26 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 25562 1567 0 0
t$perf-norm:sp_cancel_write_off 1112 1112 0 0.00 0 2267 10 0 0
t$perf-norm:sp_client_order 22171 22171 0 0.00 0 26665 18 0 0
t$perf-norm:sp_customer_reserve 1058 1058 0 0.00 0 4367 11 0 0
t$perf-norm:sp_pay_from_customer 7449 7449 0 0.00 0 10875 11 0 0
t$perf-norm:sp_pay_to_supplier 6279 6279 0 0.00 0 3085 10 0 0
t$perf-norm:sp_reserve_write_off 10701 10701 0 0.00 0 15819 11 0 0
t$perf-norm:sp_supplier_invoice 5999 5999 0 0.00 0 7982 19 0 0
t$perf-norm:sp_supplier_order 5813 5813 0 0.00 0 4342 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 373 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 416 8 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 3291 24 0 0
t$perf-norm:srv_make_money_saldo 885 885 0 0.00 0 799 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10986 10650 336 3.05 0 4894 17 0 336
v_all_customers 40182 40182 0 0.00 0 70 1 0 0
v_all_suppliers 32824 32824 0 0.00 0 47 1 0 0
v_all_wares 44342 44342 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 916 916 0 0.00 0 1411 7 0 0
v_cancel_client_order 3706 3706 0 0.00 0 2156 4 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 595 3 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 604 4 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 1208 5 0 0
v_cancel_supplier_invoice 924 890 34 3.67 0 5425 19 0 34
v_cancel_supplier_order 868 868 0 0.00 0 2762 6 0 0
v_cancel_write_off 2224 2224 0 0.00 0 4957 16 0 0
v_max_id_clo_ord 5812 5812 0 0.00 0 329 1 0 0
v_max_id_clo_res 1058 1058 0 0.00 0 3567 13 0 0
v_max_id_ord_sup 5997 5997 0 0.00 0 11387 8 0 0
v_max_non_paid_invoice 1676 1676 0 0.00 0 3218 5 0 0
v_max_non_paid_realizn 4028 4028 0 0.00 0 9561 6 0 0
v_min_id_clo_ord 5812 5812 0 0.00 0 13294 18 0 0
v_min_id_clo_res 1058 1058 0 0.00 0 3349 9 0 0
v_min_id_ord_sup 5997 5997 0 0.00 0 9591 9 0 0
v_min_non_paid_invoice 6279 6279 0 0.00 0 19235 28 0 0
v_min_non_paid_realizn 7449 7449 0 0.00 0 9724 16 0 0
v_our_firm 11002 11002 0 0.00 0 17 1 0 0
v_reserve_write_off 21402 21402 0 0.00 0 12527 6 0 0
x_lock_depdocs_on_canc_invoice 11663 11663 0 0.00 0 21535 126 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 13077 342 0 0
x_make_qstorno_1000_1200 5813 5813 0 0.00 1 30553 1106 0 0
x_make_qstorno_1200_2000 5999 5999 0 0.00 3 107238 3231 0 0
x_make_qstorno_2100_3300 490920 490920 0 0.00 0 39786 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-01-2021 01:29:44 to 21-01-2021 01:29: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
22:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 17267 8192000000 10259706288 10576064512 975947520 10.645 77 57 115 0 998237216 2680400 19609296
22:57:46 17377 8192000000 10338370112 10654343168 1377266432 14.392 100 79 156 0 1406869232 4584912 25017888
22:58:15 25715 8192000000 10372402784 10696163328 1427220464 14.837 100 84 168 0 1461301424 6254352 27826608
22:58:52 15319 8192000000 10405086608 10732478464 1460076752 15.127 100 89 178 0 1496490288 7367696 29045840
22:59:18 25995 8192000000 10422322688 10751119360 1474688624 15.255 100 91 183 0 1512290592 7909376 29692592
23:00:06 23187 8192000000 10459913264 10795737088 1510033824 15.564 100 90 180 0 1547315712 8734560 28547328
23:00:49 24129 8192000000 10471100736 10816847872 1523866416 15.684 100 78 157 1 1558001008 9043056 25091536
23:01:23 10300 8192000000 10501178848 10848378880 1560817616 16.003 100 85 170 0 1596800144 9399904 26582624
23:01:40 15157 8192000000 10525036864 10875211776 1581609728 16.182 100 82 164 1 1616811088 10068496 25132864
23:02:03 17060 8192000000 10547884800 10904190976 1598093472 16.323 100 80 160 0 1633363376 10838208 24431696
23:02:34 17237 8192000000 10578775520 10938068992 1631470768 16.607 100 81 162 0 1667259728 11038640 24750320
23:03:02 17919 8192000000 10597558800 10964373504 1658949248 16.840 100 77 155 2 1694041648 12356816 22735584
23:03:28 10232 8192000000 10612013680 10980663296 1671498784 16.946 100 81 162 3 1708447936 12921472 24027680
23:03:45 10927 8192000000 10625111472 10995060736 1685807824 17.066 100 82 164 1 1722027920 12124144 24095952
23:04:04 10434 8192000000 10644032032 11013783552 1700592624 17.190 100 73 146 0 1734110832 11762848 21755360
23:04:22 10395 8192000000 10659413376 11027402752 1719122112 17.345 100 82 162 0 1754366400 12550272 22694016
23:04:40 7345 8192000000 10673823888 11046645760 1728688864 17.425 100 79 158 1 1764912512 12854576 23369072
23:04:56 5589 8192000000 10690046400 11065552896 1749235600 17.595 100 84 168 0 1786011808 13248864 23527344
23:05:09 4246 8192000000 10690252976 11067076608 1751420288 17.613 100 81 163 2 1788861200 14053808 23387104
23:05:22 5946 8192000000 10713068480 11085938688 1765628016 17.731 100 92 183 0 1806412272 15008736 25775520
23:05:35 4046 8192000000 10715996736 11094130688 1773175152 17.793 100 85 170 4 1811688544 14177600 24335792
23:05:45 2944 8192000000 10725642416 11107778560 1787877408 17.914 100 81 162 5 1824521616 13586800 23057408
23:05:55 3645 8192000000 10737811296 11118944256 1795267760 17.975 100 84 170 0 1832558928 13552944 23738224
23:06:06 2440 8192000000 10735627296 11123752960 1802292176 18.033 100 86 171 1 1839416352 13164176 23960000
23:06:15 3269 8192000000 10754361952 11136397312 1806448128 18.067 100 89 175 2 1844769120 13624064 24696928
23:06:25 7263 8192000000 10752262496 11141390336 1815218224 18.139 100 83 160 1 1850751728 13413392 22120112
23:06:41 4601 8192000000 10766952192 11151335424 1822399648 18.197 100 87 175 1 1859377712 13407936 23570128
23:06:52 2390 8192000000 10771243264 11159351296 1834264048 18.294 100 86 173 1 1872197696 14239568 23694080
23:07:01 2368 8192000000 10784250112 11169546240 1838674544 18.330 100 89 178 0 1877738992 14243696 24820752
23:07:10 2620 8192000000 10785943632 11176878080 1844285664 18.376 100 84 167 1 1881406112 14249616 22870832
23:07:19 2485 8192000000 10794621072 11183669248 1853556736 18.451 100 88 176 2 1892552288 13886208 25109344
23:07:28 2080 8192000000 10800530128 11190554624 1860015904 18.503 100 91 182 0 1899467056 14158192 25292960
23:07:36 2329 8192000000 10804863600 11196387328 1862582768 18.524 100 89 179 1 1900473056 13191152 24699136
23:07:45 1764 8192000000 10809833136 11198529536 1864298816 18.538 100 86 172 0 1900767712 12599680 23869216
23:07:53 1297 8192000000 10809739520 11200450560 1867673216 18.565 100 89 178 0 1905459568 12007152 25779200
23:08:01 2045 8192000000 10804323632 11200413696 1870699392 18.590 100 88 176 2 1908570464 12669456 25201616
23:08:10 2152 8192000000 10819063200 11209891840 1873458864 18.612 100 94 189 0 1913295856 13068432 26768560
23:08:19 1795 8192000000 10819158112 11211833344 1878505648 18.653 100 95 189 2 1918880432 12523728 27851056
23:08:27 1540 8192000000 10821299952 11214471168 1879912896 18.664 100 94 188 1 1919769984 12838256 27018832
23:08:34 5062 8192000000 10803094240 11211231232 1879747968 18.663 100 69 135 2 1909895232 12075616 18071648
23:08:46 38971 8192000000 10808700320 11216191488 1875747760 18.631 100 56 110 2 1899657088 6826352 17082976
23:09:31 18486 8192000000 10780875552 11214909440 1875414672 18.628 100 33 67 0 1891710096 6828720 9466704
23:09:56 6550 8192000000 10788232400 11216326656 1875989696 18.633 100 35 71 2 1892243904 5824256 10429952
23:10:13 7620 8192000000 10788670928 11219206144 1877534864 18.645 100 27 54 1 1892436288 7234320 7667104
23:10:29 10468 8192000000 10785894352 11222966272 1878947856 18.657 100 10 20 0 1886840992 5058944 2834192
23:10:47 6794 8192000000 10787301392 11223900160 1885335536 18.708 100 17 34 0 1896105952 6048048 4722368
23:11:00 10688 8192000000 10797706912 11230744576 1887939264 18.729 100 23 46 0 1901117552 6418672 6759616
23:11:20 6091 8192000000 10814435840 11236900864 1895847088 18.793 100 38 76 3 1914572704 7692880 11032736
23:11:32 13006 8192000000 10804484880 11236950016 1893500784 18.774 100 23 46 0 1906333872 5717312 7115776
23:11:53 10035 8192000000 10795263264 11236446208 1894188176 18.780 100 18 36 2 1905113840 5941232 4984432
23:12:10 8643 8192000000 10805646592 11239718912 1899002336 18.818 100 34 67 2 1915397136 6864192 9530608
23:12:24 8828 8192000000 10799881088 11241086976 1901780688 18.841 100 28 57 3 1915758256 5417936 8559632
23:12:42 10217 8192000000 10814776176 11246661632 1901025328 18.835 100 16 32 0 1911554576 5734720 4794528
23:12:59 5146 8192000000 10819986720 11252277248 1903608832 18.855 100 29 58 0 1919505376 8055104 7841440
23:13:11 10286 8192000000 10810411344 11247230976 1901534368 18.839 100 18 36 0 1913159360 6422288 5202704
23:13:28 8042 8192000000 10812900992 11247923200 1902970368 18.850 100 26 50 4 1916475744 6264736 7240640
23:13:44 55725 8192000000 10860715488 11263995904 1913288160 18.933 100 63 127 1 1941022624 9893088 17841376
23:14:46 16389 8192000000 10826408336 11262644224 1909852864 18.905 100 23 46 0 1926448496 10683552 5912080
23:15:17 7108 8192000000 10814296864 11242770432 1892398928 18.765 99 31 63 0 1907263648 6177312 8687408
23:15:32 5993 8192000000 10801175280 11235688448 1869850736 18.583 98 29 58 1 1885131472 6197120 9083616
23:15:45 6217 8192000000 10806059760 11245064192 1878843792 18.656 99 21 42 1 1894652368 10431808 5376768
23:16:01 8042 8192000000 10823078816 11257909248 1906294016 18.877 100 27 55 0 1919921856 5571328 8056512
23:16:16 8163 8192000000 10828033120 11261644800 1910174960 18.908 100 22 44 0 1922556816 5834496 6547360
23:16:33 6560 8192000000 10829001536 11268743168 1916737216 18.961 100 17 34 0 1926809040 5273248 4798576
23:16:47 6257 8192000000 10817149344 11249864704 1886676944 18.719 99 34 68 0 1902311616 5630896 10003776
23:17:03 10036 8192000000 10795533888 11236122624 1849516064 18.418 97 26 51 3 1862795152 5826576 7452512
23:17:22 10785 8192000000 10778239376 11211243520 1807110576 18.072 96 12 25 2 1815230400 4826048 3293776
23:17:40 9753 8192000000 10767238688 11196469248 1834930592 18.300 98 17 34 0 1845575808 5307056 5338160
23:17:55 9394 8192000000 10762814608 11192930304 1832864256 18.283 98 21 42 1 1848374192 10097040 5412896
23:18:11 8404 8192000000 10750574560 11168133120 1802664688 18.036 97 15 29 0 1812229456 5503776 4060992
23:18:26 64459 8192000000 10729626880 11158728704 1703910896 17.218 92 28 56 0 1717294032 5133040 8250096
23:19:40 9362 8192000000 10692403200 11104272384 1711501136 17.281 95 29 58 2 1726179104 6337248 8340720
23:19:56 6917 8192000000 10698206704 11109969920 1731514176 17.448 96 26 52 0 1744741552 5494368 7733008
23:20:09 5349 8192000000 10732454224 11143245824 1792428800 17.952 99 38 77 3 1810635168 7655056 10551312
23:20:21 6689 8192000000 10711428272 11124060160 1739495472 17.514 96 34 68 1 1755553120 6569200 9488448
23:20:36 5672 8192000000 10714338528 11138334720 1795533152 17.977 99 27 52 3 1809104736 5671680 7899904
23:20:47 6008 8192000000 10741593600 11159515136 1821927712 18.193 100 25 50 0 1835905488 6517920 7459856
23:21:01 4653 8192000000 10750405168 11172274176 1828363488 18.246 100 30 60 0 1843390256 6615408 8411360
23:21:12 9583 8192000000 10731183120 11158532096 1808543472 18.084 99 20 40 1 1820756000 5446720 6765808
23:21:31 10253 8192000000 10721416400 11143872512 1770745024 17.773 97 23 47 0 1783137584 5960720 6431840
23:21:49 10424 8192000000 10727418112 11141574656 1778317360 17.836 98 18 35 0 1789316096 5608944 5389792
23:22:08 12699 8192000000 10721060096 11136380928 1777562464 17.829 98 14 26 0 1786820720 5260880 3997376
23:22:29 7957 8192000000 10720973152 11142041600 1794908192 17.972 99 20 40 1 1806656752 5405040 6343520
23:22:46 5631 8192000000 10725695808 11148238848 1812353680 18.115 100 32 65 3 1827677072 6045952 9277440
23:22:58 13543 8192000000 10754453744 11170947072 1825057440 18.219 100 11 22 1 1832795488 4636592 3101456
23:23:18 68803 8192000000 10745282752 11181150208 1839611856 18.338 100 20 40 1 1850183296 4954752 5616688
23:24:33 11098 8192000000 10748952592 11187634176 1844857168 18.380 100 20 40 2 1856612096 6180576 5574352
23:24:50 6495 8192000000 10762901856 11194642432 1851496416 18.434 100 24 48 1 1863718608 5819632 6402560
23:25:03 9531 8192000000 10772742992 11201196032 1859415264 18.499 100 39 78 2 1877467696 5694304 12358128
23:25:19 8544 8192000000 10771710304 11202969600 1860502432 18.507 100 20 39 4 1872575840 5225440 6847968
23:25:34 7057 8192000000 10775706128 11210207232 1863754256 18.534 100 23 46 2 1876521104 6002912 6763936
23:25:48 9930 8192000000 10773461200 11206291456 1864660640 18.541 100 21 43 2 1876337504 5224736 6452128
23:26:05 9175 8192000000 10792593184 11215876096 1869214736 18.578 100 22 44 1 1880772896 5030048 6528112
23:26:27 7798 8192000000 10785271248 11219013632 1872967072 18.608 100 19 38 0 1884280816 5775760 5537984
23:26:43 12971 8192000000 10789533648 11225133056 1875412336 18.628 100 21 41 1 1888831312 6479184 6939792
23:27:04 27677 8192000000 10823948992 11245166592 1891063680 18.754 100 12 24 2 1898341424 3869776 3407968
23:27:51 2236 8192000000 10846699696 11260710912 1916345376 18.958 100 63 126 1 1941891344 5963696 19582272
23:28:00 64787 8192000000 10858545616 11283996672 1923882432 19.018 100 47 93 3 1945746992 8606000 13258560
23:29:48 88942 8192000000 10846471984 11303034880 1934052032 19.099 100 29 58 2 1953615984 11006208 8557744
23:31:26 39182 8192000000 10890984384 11315703808 1932566496 19.087 99 35 69 1 1958027984 15612000 9849488
23:32:14 9017 8192000000 10897738656 11322449920 1956571936 19.279 100 70 142 1 1991107328 14354992 20180400
23:32:34 16502 8192000000 10893454384 11322793984 1939873040 19.146 99 54 107 1 1971611984 16131632 15607312
23:32:59 35207 8192000000 10903040368 11335966720 1962919376 19.329 100 45 90 1 1993037136 16988944 13128816
23:33:43 12054 8192000000 10915037584 11348185088 1973878528 19.416 100 36 72 1 2001309136 16125424 11305184
23:34:04 9824 8192000000 10927044848 11357298688 1981121744 19.474 100 55 108 0 2014427120 16530688 16774688
23:34:22 8581 8192000000 10930323824 11363201024 1985742816 19.510 100 61 122 1 2021269296 18129264 17397216
23:34:38 13376 8192000000 10934965792 11369766912 1988041328 19.528 100 62 124 1 2023006720 16476704 18488688
23:35:02 5818 8192000000 10937578416 11363438592 1975911728 19.432 99 72 143 0 2013795184 17777264 20106192
23:35:18 12170 8192000000 10920705888 11354013696 1979254608 19.459 100 55 110 1 2011950080 16738832 15956640
23:35:42 3846 8192000000 10933788192 11363581952 1988391648 19.531 100 64 127 1 2024261504 16530352 19339504
23:35:53 3778 8192000000 10926063104 11354447872 1975887808 19.432 100 68 136 0 2022542064 26682752 19971504
23:36:03 3254 8192000000 10929247664 11343720448 1967000832 19.362 100 82 162 1 2009294240 18717408 23576000
23:36:13 5229 8192000000 10917390304 11337773056 1953063536 19.251 99 68 134 2 1992098784 19287984 19747264
23:36:25 9356 8192000000 10925863696 11350458368 1977229264 19.443 100 81 162 1 2022288592 20798400 24260928
23:36:47 11843 8192000000 10922615840 11351478272 1977650864 19.446 100 57 113 0 2017614048 23319104 16644080
23:37:08 2998 8192000000 10943039024 11368464384 1986421344 19.516 100 66 130 2 2029885168 24220512 19243312
23:37:19 3807 8192000000 10940971312 11369357312 1996084048 19.592 100 70 140 2 2034882576 17915472 20883056
23:37:31 10922 8192000000 10949913136 11377553408 1999159440 19.616 100 62 124 1 2035177856 18402608 17615808
23:37:50 15192 8192000000 10957129984 11389288448 2004066464 19.655 100 53 106 0 2039995808 19473120 16456224
23:38:12 11564 8192000000 10967846848 11402752000 2007239504 19.680 100 59 117 0 2052120992 27444272 17437216
23:38:31 7203 8192000000 10950649984 11390623744 1991231520 19.554 99 61 122 2 2033123568 23344368 18547680
23:38:49 8833 8192000000 10944192640 11374362624 1979355552 19.460 99 67 134 3 2020586144 21655872 19574720
23:39:12 4944 8192000000 10920484208 11356930048 1961187632 19.315 99 52 104 1 1998866000 22466784 15211584
23:39:26 3581 8192000000 10937953952 11358015488 1971295536 19.396 100 72 142 1 2015328160 22935120 21097504
23:39:38 4446 8192000000 10947932720 11361513472 1967729744 19.367 99 79 154 0 2012011440 21695744 22585952
23:39:49 3367 8192000000 10936801424 11355504640 1963379888 19.333 99 71 141 0 2006407792 22474864 20553040
23:40:00 2279 8192000000 10949540736 11365314560 1984151056 19.498 100 83 166 4 2032858128 23568112 25138960
23:40:09 7236 8192000000 10942938864 11362488320 1985579712 19.509 100 77 153 0 2033823936 24889136 23355088
23:40:25 3411 8192000000 10968113424 11385032704 1998450272 19.611 100 91 183 1 2052080736 25999984 27630480
23:40:36 3766 8192000000 10960582288 11376787456 1991250496 19.554 100 79 156 0 2040619840 26398496 22970848
23:40:46 7951 8192000000 10946925312 11365945344 1985023136 19.504 100 76 152 0 2034250640 26454992 22772512
23:41:03 2380 8192000000 10956439952 11371102208 1971399584 19.397 99 81 162 0 2023919184 27395360 25124240
23:41:16 8294 8192000000 10955911104 11382841344 1992350144 19.562 100 72 144 0 2042161232 27831792 21979296
23:41:32 2338 8192000000 10954325760 11373416448 1976284720 19.435 99 83 164 1 2026824096 25603760 24935616
23:41:42 3436 8192000000 10940839968 11357847552 1969136880 19.379 100 75 150 2 2018217936 25739072 23341984
23:41:52 2525 8192000000 10943580784 11350634496 1969629616 19.383 100 91 181 4 2024238976 27106448 27502912
23:42:03 2654 8192000000 10936124448 11346874368 1952681056 19.248 99 86 172 2 2008174272 28444640 27048576
23:42:13 10739 8192000000 10937937984 11359903744 1969717216 19.383 100 77 151 1 2021816896 29158224 22941456
23:42:35 6689 8192000000 10944187888 11362230272 1975454080 19.429 100 79 156 0 2030371632 30606288 24311264
23:42:51 6344 8192000000 10931299008 11354562560 1948708096 19.216 99 70 139 3 2000448928 30000656 21740176
23:43:05 5370 8192000000 10932914768 11349729280 1960166848 19.307 100 68 131 2 2011179504 30498848 20513808
23:43:17 1902 8192000000 10952271376 11362725888 1972154160 19.403 100 82 162 1 2030936864 32686288 26096416
23:43:26 5917 8192000000 10952019888 11370881024 1978391584 19.452 100 81 160 2 2039089888 36126976 24571328
23:43:42 9065 8192000000 10950070928 11381329920 1979926528 19.464 100 61 122 1 2036845296 37394288 19524480
23:44:01 12614 8192000000 10948906176 11378913280 1954876448 19.265 99 52 104 0 2009477264 37428704 17172112
23:44:30 9222 8192000000 10948880672 11370639360 1955572896 19.271 99 64 128 1 2011811472 35920896 20317680
23:44:46 3417 8192000000 10943498176 11364839424 1943117632 19.172 98 70 138 0 2000182704 35565600 21499472
23:44:56 5944 8192000000 10952230672 11378700288 1980604848 19.469 100 60 120 2 2037202128 37748736 18848544
23:45:09 4986 8192000000 10941258528 11357679616 1946016128 19.195 99 72 141 2 2007291712 38671344 22604240
23:45:21 6510 8192000000 10951302592 11374587904 1975945232 19.433 100 73 144 2 2038590368 40223632 22421504
23:45:36 4182 8192000000 10967924448 11383730176 1983683824 19.494 100 78 154 0 2046618240 39318144 23616272
23:45:58 3587 8192000000 10973723808 11389628416 1981240736 19.475 100 78 156 0 2051532816 46102192 24189888
23:46:08 1764 8192000000 10979863952 11393089536 1985748176 19.510 100 86 170 0 2055253504 43468368 26036960
23:46:17 4445 8192000000 10984599072 11395895296 1988301792 19.530 100 83 167 0 2058443664 43904320 26237552
23:46:31 2115 8192000000 10978349600 11397046272 1989231872 19.538 100 89 177 0 2063353296 46028560 28092864
23:46:40 3060 8192000000 10967480096 11373731840 1974124880 19.418 100 95 190 3 2043676864 39941248 29610736
23:46:50 4883 8192000000 10976467408 11388735488 1991686512 19.557 100 91 181 1 2060706336 40703136 28316688
23:47:01 2976 8192000000 10983689712 11394617344 1994711936 19.581 100 87 174 1 2060922768 39334368 26876464
23:47:11 15442 8192000000 10959622160 11388485632 1989600304 19.541 100 63 126 1 2049921168 40696592 19624272
23:47:38 7333 8192000000 10971547072 11402457088 1995138848 19.584 100 53 104 2 2052401104 40683744 16578512
23:48:09 6539 8192000000 10956627440 11391021056 1984683008 19.502 100 56 110 2 2046076672 42712288 18681376
23:48:26 10805 8192000000 10950156208 11378733056 1959471280 19.302 99 56 110 0 2019903872 42617664 17814928
23:48:45 9339 8192000000 10956392816 11382083584 1977629232 19.446 100 62 125 0 2042957664 44900928 20427504
23:49:04 4188 8192000000 10969809872 11395391488 1986655264 19.517 100 62 124 1 2050746928 44029712 20061952
23:49:17 4213 8192000000 10985273984 11399180288 1976884736 19.440 99 77 154 3 2049896672 48059712 24952224
23:49:31 3675 8192000000 10933987968 11353276416 1926367424 19.038 97 59 116 0 1992058048 46435728 19254896
23:49:43 2734 8192000000 10977708352 11388416000 1981444384 19.476 100 81 163 1 2054706048 47961824 25299840
23:49:53 6040 8192000000 10975488528 11399180288 1983717408 19.494 100 63 125 1 2054428256 50481568 20229280
23:50:08 4035 8192000000 10967482336 11400658944 1986709728 19.518 100 63 127 0 2058834832 51601744 20523360
23:50:18 13546 8192000000 10957197568 11394478080 1966650480 19.359 99 41 82 1 2026398720 46142912 13605328
23:50:40 13786 8192000000 10954873088 11398111232 1964411568 19.341 99 41 82 2 2025613360 47187008 14014784
23:51:10 11080 8192000000 10958035840 11396190208 1983854816 19.495 100 35 70 1 2037338256 41302512 12180928
23:51:32 6752 8192000000 10960702096 11398737920 1985000704 19.504 100 42 84 2 2041818672 43047584 13770384
23:51:50 14309 8192000000 10958677264 11394129920 1980793456 19.471 100 45 90 0 2041346384 44987872 15565056
23:52:29 11700 8192000000 10951104768 11397726208 1957862480 19.289 99 39 78 0 2020169312 49195424 13111408
23:52:59 33515 8192000000 10915949280 11357720576 1917632160 18.968 98 31 62 2 1977357648 48624256 11101232
23:53:42 15530 8192000000 10903827888 11352408064 1934529904 19.103 100 27 54 1 1997694288 52966688 10197696
23:54:04 17316 8192000000 10904274112 11354525696 1924362256 19.022 100 23 46 1 1983853920 50100960 9390704
23:54:31 30155 8192000000 10903800832 11354365952 1925980208 19.035 100 29 58 1 1990784880 53432480 11372192
23:55:12 27768 8192000000 10902051952 11365974016 1930186176 19.068 100 20 40 1 1991116000 53276448 7653376
23:55:52 23170 8192000000 10916938128 11378348032 1935128000 19.108 100 29 58 0 2001627312 56752608 9746704
23:56:39 17803 8192000000 10911344464 11372519424 1952557312 19.247 100 32 64 1 2005079856 42953072 9569472
23:57:03 22547 8192000000 10891545856 11356782592 1956001776 19.274 100 7 14 2 1971192128 13261968 1928384
23:57:35 54211 8192000000 10918289264 11372945408 1963911760 19.337 100 10 20 0 1984660368 17977392 2771216
23:58:36 58237 8192000000 10896957968 11358167040 1959066912 19.299 100 9 18 1 1982061200 20701072 2293216
00:00:28 112521 8192000000 10910155472 11375341568 1951783616 19.241 99 5 10 0 1970892848 17990704 1118528
00:03:21 129952 8192000000 10924248656 11383226368 1927374224 19.046 97 25 50 2 1950625776 16708336 6543216
00:05:49 117861 8192000000 10930020368 11393601536 1994502016 19.579 100 35 70 3 2019948624 14721616 10724992
00:07:54 145299 8192000000 10907479936 11392245760 1971373920 19.396 99 20 40 1 1993541696 15881744 6286032
00:10:30 72574 8192000000 10919460016 11387645952 1968878752 19.377 99 15 30 1 1982802496 10430512 3493232
00:11:53 15283 8192000000 10928584800 11388923904 1987060560 19.521 100 28 55 0 2008235856 13456736 7718560
00:12:16 14094 8192000000 10928425840 11387834368 1989445008 19.539 100 38 76 4 2014261216 14157456 10658752
00:12:40 1275 8192000000 10957071376 11394867200 2003114528 19.647 100 75 152 1 2032806064 8363616 21327920
00:12:48 15738 8192000000 10953982736 11395850240 2003129808 19.647 100 79 157 1 2036223264 11931728 21161728
00:13:14 38049 8192000000 10918172064 11381170176 1954565664 19.263 98 16 32 1 1967321856 8095344 4660848
00:13:58 47460 8192000000 10912394816 11375939584 1949866144 19.225 98 24 47 1 1967300192 10539232 6894816
00:14:53 64788 8192000000 10925587024 11386261504 1950476656 19.230 98 36 72 0 1978981648 17376960 11128032
00:16:20 41802 8192000000 10894567936 11386798080 1960409840 19.309 99 19 38 1 1981201136 15044752 5746544
00:17:39 37371 8192000000 10909448192 11383287808 1985338224 19.507 100 17 34 1 1997863120 7429120 5095776
00:18:22 53400 8192000000 10885850688 11365834752 1952181872 19.244 98 12 24 0 1967571712 11383408 4006432
00:19:22 35050 8192000000 10885623344 11352432640 1937207440 19.124 98 16 32 0 1958515440 16370768 4937232
00:20:52 52889 8192000000 10879820256 11361345536 1930756400 19.073 98 8 16 0 1942062784 9318624 1987760
00:21:52 75752 8192000000 10887644880 11373273088 1891529456 18.758 96 11 22 1 1908039504 13683648 2826400
00:23:33 69337 8192000000 10866726512 11334881280 1861843584 18.518 95 12 24 0 1872845312 7633680 3368048
00:24:49 38209 8192000000 10904915024 11352764416 1941106496 19.156 99 36 69 2 1959976400 9228720 9641184
00:25:37 36825 8192000000 10892797328 11364442112 1964854272 19.345 100 39 77 1 1988484592 12850640 10779680
00:26:30 59689 8192000000 10877317808 11353026560 1925116368 19.028 98 13 26 3 1938064128 9448464 3499296
00:27:36 101105 8192000000 10849688128 11318435840 1785579632 17.895 91 16 32 0 1799767744 10097808 4090304
00:29:26 57903 8192000000 10866010448 11324170240 1844814384 18.380 95 27 53 4 1862423536 10128720 7480432
00:30:30 62514 8192000000 10885984960 11344924672 1921199344 18.996 99 16 32 1 1941742384 15746320 4796720
00:31:39 86996 8192000000 10884141696 11351379968 1897468320 18.806 97 14 28 0 1918766144 17510320 3787504
00:33:12 58533 8192000000 10872248976 11348373504 1914195984 18.940 98 13 25 1 1928412528 10746336 3470208
00:34:18 63592 8192000000 10888604320 11351830528 1915790560 18.953 98 12 24 1 1929506224 10456096 3259568
00:35:28 40313 8192000000 10869987648 11341422592 1916297280 18.957 98 13 26 1 1930282288 10232880 3752128
00:36:14 55723 8192000000 10865508416 11325321216 1884924080 18.705 97 15 29 0 1898340736 9442288 3974368
00:37:23 46442 8192000000 10874000960 11333459968 1925588304 19.032 99 61 122 2 1954296432 10282640 18425488
00:39:31 103620 8192000000 10830618656 11307020288 1835508944 18.304 95 11 22 0 1850604592 12351952 2743696
00:41:21 8760 8192000000 10846632016 11325186048 1921012736 18.995 100 11 22 0 1938271424 14387600 2871088
00:41:39 33169 8192000000 10886352240 11337912320 1948712736 19.216 100 43 86 4 1970782032 10312304 11756992
00:42:49 62413 8192000000 10825873232 11306647552 1839383808 18.336 95 5 10 0 1850491952 9239392 1868752
00:43:58 34715 8192000000 10846790592 11325091840 1925214448 19.029 100 10 19 0 1938526320 10439984 2871888
00:44:44 51585 8192000000 10845593760 11317997568 1896454800 18.798 98 29 58 1 1916257808 11515952 8287056
00:45:49 73579 8192000000 10832937200 11297751040 1867149296 18.561 97 11 22 1 1883395328 13140160 3105872
00:47:08 30876 8192000000 10797041264 11267428352 1862990864 18.528 98 14 27 2 1879661312 12267792 4402656
00:47:47 45796 8192000000 10834842160 11309518848 1885743984 18.711 99 7 14 0 1901924768 14087616 2093168
00:48:56 43281 8192000000 10863815904 11319984128 1929439552 19.062 100 21 42 1 1948430528 13079296 5911680
00:49:54 43069 8192000000 10871213056 11322945536 1903758960 18.857 98 17 34 0 1916642896 7941664 4942272
00:50:45 30537 8192000000 10888776864 11346542592 1952832256 19.249 100 34 68 1 1973184640 10998256 9354128
00:51:48 32802 8192000000 10884563344 11353997312 1956980224 19.282 100 23 46 0 1978011664 14468944 6562496
00:52:27 79020 8192000000 10876044832 11358076928 1953846976 19.257 100 19 38 3 1975937136 16844864 5245296
00:53:54 43404 8192000000 10902814432 11361738752 1963379488 19.333 100 15 30 0 1976118064 8297408 4441168
00:54:48 96049 8192000000 10893520848 11366232064 1914525904 18.943 97 21 42 0 1934981408 14407632 6047872
00:57:20 65070 8192000000 10902831840 11372670976 1937559200 19.127 98 22 44 4 1953246016 9766960 5919856
00:58:33 45914 8192000000 10917151216 11381420032 1984491552 19.500 100 20 38 3 1998752208 8408752 5851904
00:59:25 15214 8192000000 10919033616 11380146176 1971351264 19.396 99 29 58 0 1991756560 12520336 7884960
00:59:46 46949 8192000000 10922186800 11374587904 1941675696 19.160 98 29 58 2 1959018640 9297792 8045152
01:00:42 130774 8192000000 10876710736 11345702912 1923451488 19.014 98 27 54 1 1939787408 8543728 7792192
01:02:59 38298 8192000000 10867825984 11316400128 1876249216 18.635 96 29 59 0 1891448768 7491744 7707808
01:03:45 35838 8192000000 10873570736 11332366336 1907234304 18.884 98 39 78 0 1930498720 11525936 11738480
01:04:37 56898 8192000000 10872059616 11348639744 1929982992 19.067 99 15 30 2 1946792144 13010256 3798896
01:05:40 69285 8192000000 10860053280 11322216448 1895300464 18.788 97 16 32 1 1914563648 14074560 5188624
01:07:02 79503 8192000000 10858352320 11342475264 1889906208 18.745 97 19 38 0 1920064800 24243744 5914848
01:08:46 61356 8192000000 10870851808 11364237312 1942086528 19.163 100 11 21 0 1959590976 14464144 3040304
01:09:53 39005 8192000000 10889867600 11345539072 1902181856 18.844 97 33 66 1 1919778624 8362672 9234096
01:10:48 66248 8192000000 10843952384 11314065408 1829243808 18.253 94 19 38 0 1843465600 8687056 5534736
01:12:04 55619 8192000000 10863660224 11328581632 1874046656 18.617 97 28 56 1 1895310576 13412896 7851024
01:13:06 51222 8192000000 10841650592 11311628288 1858974096 18.495 96 25 50 1 1880147552 13621584 7551872
01:14:07 49592 8192000000 10833063696 11299418112 1847464512 18.402 96 14 28 1 1869644672 18263936 3916224
01:15:04 25092 8192000000 10887819872 11322261504 1910021552 18.907 99 37 74 1 1928922640 8297552 10603536
01:15:35 22823 8192000000 10875666720 11326808064 1914529040 18.943 99 43 86 0 1936232112 10004000 11699072
01:16:06 57327 8192000000 10858455696 11328946176 1898788688 18.817 98 21 42 0 1917268080 12740816 5738576
01:17:15 68550 8192000000 10837299856 11309555712 1817931744 18.161 94 16 32 2 1839715728 16957248 4826736
01:18:30 41093 8192000000 10843777936 11304022016 1844442512 18.377 96 31 62 0 1861938272 9067568 8428192
01:19:20 36541 8192000000 10862874944 11314102272 1868244144 18.570 97 19 38 1 1883472752 10011168 5217440
01:20:05 92513 8192000000 10892348800 11346886656 1908224064 18.892 99 17 34 1 1924812912 11790432 4798416
01:21:43 95214 8192000000 10877207216 11368112128 1946251344 19.197 100 5 10 1 1969522192 22056064 1214784
01:23:25 76715 8192000000 10872924928 11336396800 1914006800 18.939 98 33 65 0 1931269232 7888544 9373888
01:24:48 45778 8192000000 10852984624 11332014080 1906933680 18.882 98 20 40 2 1924691808 12428272 5329856
01:25:40 46580 8192000000 10873782144 11359457280 1951046288 19.235 100 14 28 1 1963344624 8135040 4163296
01:26:33 39588 8192000000 10732189632 11198971904 1802239152 18.032 92 8 16 0 1815558240 11173632 2145456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-01-2021 01:29:50 to 21-01-2021 01:30:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 168 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-01-2021 01:30:23 to 21-01-2021 01:30:25.

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          249006
MON$OLDEST_ACTIVE               250956
MON$OLDEST_SNAPSHOT             250956
MON$NEXT_TRANSACTION            250956
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                       2045408
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:165: 
:166: mscs-test-161.budzdorov.ru    Thu Jan 21 01:27:33 2021
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
:169: 
:170: mscs-test-161.budzdorov.ru    Thu Jan 21 01:27:35 2021
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:172: 
--- end of diff output ---

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

21.01.21 01:30:26. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-21 01:30:28 No severe PSQL-related problems occured
21.01.21 01:30:29. End of report.