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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17142356 kB
MemAvailable 31247772 kB
Buffers 0 kB
Cached 14567512 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-03 19:27:13
DTS_END                         2021-02-03 19:27:13.5160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48264
TRN_ID                          244674
ATT_ID                          716
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: 9349.84 22952 1121981
customer order: creation 173.74 353 20849
customer order: refuse 14.54 356 1745
order to supplier: creation 47.18 1263 5661
order to supplier: removal 3.47 103377 416
invoice (draft): creation 45.80 3135 5496
invoice (draft): removal 52.74 811 6329
invoice accept: apply 42.42 19457 5090
invoice accept: cancel 47.51 816 5701
customer reserve: creation 3965.47 191 475856
customer reserve: removal 4655.23 61 558627
realization accept: apply 85.68 172 10281
realization accept: cancel 82.61 116 9913
payment from customer: creation 60.33 101 7240
payment from customer: removal 5.76 88 691
payment to supplier: creation 50.68 115 6082
payment to supplier: removal 3.68 63 441
service: total inventory turnovers 4.97 1060 597
service: total monetary turnovers 7.02 33 842
service: aggregate perf. data 1.00 17704 120
service: refresh index statistics 0.03 309767 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-02-2021 19:28:50 to 03-02-2021 19:28:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5089
TEST_TIME 2 4964
TEST_TIME 3 5663
TEST_TIME 4 5663
TEST_TIME 5 6030
TEST_TIME 6 6207
TEST_TIME 7 6560
TEST_TIME 8 6472
TEST_TIME 9 6486
TEST_TIME 10 6544
TEST_TIME 11 6640
TEST_TIME 12 6782
TEST_TIME 13 6679
TEST_TIME 14 7061
TEST_TIME 15 7390
TEST_TIME 16 7449
TEST_TIME 17 7691
TEST_TIME 18 7950
TEST_TIME 19 8697
TEST_TIME 20 9178
TEST_TIME 21 9324
TEST_TIME 22 9279
TEST_TIME 23 9928
TEST_TIME 24 9627
TEST_TIME 25 9721
TEST_TIME 26 9982
TEST_TIME 27 10266
TEST_TIME 28 11518
TEST_TIME 29 11434
TEST_TIME 30 11327
TEST_TIME 31 11225
TEST_TIME 32 10934
TEST_TIME 33 10966
TEST_TIME 34 10841
TEST_TIME 35 10721
TEST_TIME 36 10707
TEST_TIME 37 10477
TEST_TIME 38 10575
TEST_TIME 39 10473
TEST_TIME 40 10702
TEST_TIME 41 10644
TEST_TIME 42 10530
TEST_TIME 43 10452
TEST_TIME 44 10374
TEST_TIME 45 10281
TEST_TIME 46 10181
TEST_TIME 47 10062
TEST_TIME 48 10017
TEST_TIME 49 9886
TEST_TIME 50 9863
TEST_TIME 51 9753
TEST_TIME 52 9661
TEST_TIME 53 9623
TEST_TIME 54 9618
TEST_TIME 55 9641
TEST_TIME 56 9623
TEST_TIME 57 9763
TEST_TIME 58 9768
TEST_TIME 59 9769
TEST_TIME 60 9816
TEST_TIME 61 9937
TEST_TIME 62 9893
TEST_TIME 63 9976
TEST_TIME 64 10001
TEST_TIME 65 10012
TEST_TIME 66 10054
TEST_TIME 67 10066
TEST_TIME 68 9958
TEST_TIME 69 9904
TEST_TIME 70 9895
TEST_TIME 71 9854
TEST_TIME 72 9845
TEST_TIME 73 9822
TEST_TIME 74 9771
TEST_TIME 75 9686
TEST_TIME 76 9660
TEST_TIME 77 9602
TEST_TIME 78 9661
TEST_TIME 79 9621
TEST_TIME 80 9601
TEST_TIME 81 9612
TEST_TIME 82 9720
TEST_TIME 83 9644
TEST_TIME 84 9689
TEST_TIME 85 9681
TEST_TIME 86 9785
TEST_TIME 87 9769
TEST_TIME 88 9766
TEST_TIME 89 9819
TEST_TIME 90 9827
TEST_TIME 91 9875
TEST_TIME 92 9784
TEST_TIME 93 9697
TEST_TIME 94 9660
TEST_TIME 95 9641
TEST_TIME 96 9575
TEST_TIME 97 9582
TEST_TIME 98 9587
TEST_TIME 99 9557
TEST_TIME 100 9581
TEST_TIME 101 9530
TEST_TIME 102 9507
TEST_TIME 103 9610
TEST_TIME 104 9658
TEST_TIME 105 9624
TEST_TIME 106 9639
TEST_TIME 107 9676
TEST_TIME 108 9678
TEST_TIME 109 9696
TEST_TIME 110 9668
TEST_TIME 111 9610
TEST_TIME 112 9586
TEST_TIME 113 9541
TEST_TIME 114 9521
TEST_TIME 115 9477
TEST_TIME 116 9444
TEST_TIME 117 9402
TEST_TIME 118 9373
TEST_TIME 119 9397
TEST_TIME 120 9356

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-02-2021 19:28:53 to 03-02-2021 19:28:57.

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 1561936 1561936 0 0.00 0 27048 7 0 0
doc_list_biud 1561935 1561935 0 0.00 0 59356 28 0 0
sp_add_invoice_to_stock 5298 5090 208 3.92 39 170724 19457 0 208
sp_cancel_adding_invoice 5701 5701 0 0.00 3 82347 816 0 0
sp_cancel_client_order 1745 1745 0 0.00 4 15830 357 0 0
sp_cancel_customer_reserve 558627 558627 0 0.00 1 27531 61 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 3261 88 0 0
sp_cancel_pay_to_supplier 441 441 0 0.00 2 6527 64 0 0
sp_cancel_supplier_invoice 6350 6329 21 0.33 1 59360 812 0 21
sp_cancel_supplier_order 416 416 0 0.00 6 1137701 103377 0 0
sp_cancel_write_off 9913 9913 0 0.00 1 36762 116 0 0
sp_client_order 20849 20849 0 0.00 3 17626 353 0 0
sp_customer_reserve 475856 475856 0 0.00 0 44828 192 0 0
sp_fill_shopping_cart 32002 32002 0 0.00 1 19738 37 0 0
sp_fill_shopping_cart_clo_res 475848 475848 0 0.00 0 16877 14 0 0
sp_get_clo_for_invoice 5082 5082 0 0.00 0 12506 289 0 0
sp_kill_cost_storno 16746 16746 0 0.00 0 8404 58 0 0
sp_kill_qstorno_ret_qs2qd 1133912 1133912 0 0.00 0 59352 33 0 0
sp_kill_qty_storno 598093 598093 0 0.00 0 59355 71 0 0
sp_lock_selected_doc 21255 21255 0 0.00 0 7941 5 0 0
sp_make_cost_storno 28685 28685 0 0.00 0 27041 49 0 0
sp_multiply_rows_for_pdistr 28685 28685 0 0.00 0 7096 27 0 0
sp_multiply_rows_for_qdistr 20849 20849 0 0.00 0 11556 159 0 0
sp_pay_from_customer 7240 7240 0 0.00 4 9883 101 0 0
sp_pay_to_supplier 6082 6082 0 0.00 4 27293 115 0 0
sp_payment_common 13322 13322 0 0.00 1 7432 26 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 15822 338 0 0
sp_qd_handle_on_invoice_upd_sts 10782 10782 0 0.00 0 19690 329 0 0
sp_qd_handle_on_reserve_upd_sts 10281 10281 0 0.00 0 18379 57 0 0
sp_reserve_write_off 10281 10281 0 0.00 7 18402 173 0 0
sp_supplier_invoice 5496 5496 0 0.00 6 78745 3136 0 0
sp_supplier_order 5661 5661 0 0.00 6 45246 1263 0 0
srv_aggregate_perf_data 120 120 0 0.00 2889 157385 17704 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1326 158403 30098 0 0
srv_find_qd_qs_mism 1072790 1072790 0 0.00 0 14416 6 0 0
srv_make_invnt_saldo 597 597 0 0.00 34 39569 1060 0 0
srv_make_money_saldo 842 842 0 0.00 0 7071 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 236329 355741 309768 0 0
t$perf-abend:sp_add_invoice_to_stock 208 208 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 21 21 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5090 5090 0 0.00 0 24519 184 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 6964 112 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 10371 29 0 0
t$perf-norm:sp_cancel_customer_reserve 738 738 0 0.00 0 5862 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 2120 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 441 441 0 0.00 0 3458 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 439 439 0 0.00 0 2823 18 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 19100 1663 0 0
t$perf-norm:sp_cancel_write_off 1010 1010 0 0.00 0 1448 4 0 0
t$perf-norm:sp_client_order 20849 20849 0 0.00 0 6162 19 0 0
t$perf-norm:sp_customer_reserve 1076 1076 0 0.00 0 3572 6 0 0
t$perf-norm:sp_pay_from_customer 7240 7240 0 0.00 0 8359 10 0 0
t$perf-norm:sp_pay_to_supplier 6082 6082 0 0.00 0 9770 11 0 0
t$perf-norm:sp_reserve_write_off 10281 10281 0 0.00 0 9774 18 0 0
t$perf-norm:sp_supplier_invoice 5496 5496 0 0.00 0 5446 18 0 0
t$perf-norm:sp_supplier_order 5661 5661 0 0.00 0 5436 18 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 556 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1064 16 0 0
t$perf-norm:srv_make_invnt_saldo 597 597 0 0.00 0 2413 31 0 0
t$perf-norm:srv_make_money_saldo 842 842 0 0.00 0 2491 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 11 6 0 0
v_add_invoice_to_stock 10570 10154 416 3.93 0 6099 17 0 416
v_all_customers 38054 38054 0 0.00 0 52 1 0 0
v_all_suppliers 31122 31122 0 0.00 0 21 1 0 0
v_all_wares 41698 41698 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 768 10 0 0
v_cancel_client_order 3490 3490 0 0.00 0 5509 5 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 2132 9 0 0
v_cancel_customer_reserve 1476 1476 0 0.00 0 4629 6 0 0
v_cancel_payment_to_supplier 882 882 0 0.00 0 897 4 0 0
v_cancel_supplier_invoice 920 878 42 4.56 0 558 13 0 42
v_cancel_supplier_order 832 832 0 0.00 0 236 3 0 0
v_cancel_write_off 2020 2020 0 0.00 0 1787 14 0 0
v_max_id_clo_ord 5661 5661 0 0.00 0 3442 3 0 0
v_max_id_clo_res 1076 1076 0 0.00 0 6002 16 0 0
v_max_id_ord_sup 5492 5492 0 0.00 0 4822 5 0 0
v_max_non_paid_invoice 1674 1674 0 0.00 0 566 3 0 0
v_max_non_paid_realizn 3835 3835 0 0.00 0 3154 4 0 0
v_min_id_clo_ord 5661 5661 0 0.00 0 4701 6 0 0
v_min_id_clo_res 1076 1076 0 0.00 0 969 5 0 0
v_min_id_ord_sup 5492 5492 0 0.00 0 6765 4 0 0
v_min_non_paid_invoice 6082 6082 0 0.00 0 4535 14 0 0
v_min_non_paid_realizn 7240 7240 0 0.00 0 7428 16 0 0
v_our_firm 10454 10454 0 0.00 0 15 1 0 0
v_reserve_write_off 20562 20562 0 0.00 0 7650 5 0 0
x_lock_depdocs_on_canc_invoice 11591 11591 0 0.00 0 24522 107 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 7809 315 0 0
x_make_qstorno_1000_1200 5661 5661 0 0.00 1 45230 1179 0 0
x_make_qstorno_1200_2000 5496 5496 0 0.00 2 73882 3008 0 0
x_make_qstorno_2100_3300 475855 475855 0 0.00 0 44826 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-02-2021 19:28:58 to 03-02-2021 19:29:02.

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:17 14 8192000000 8829762400 8848257024 31795360 0.386 6 5 6 0 32156320 99472 261488
16:57:23 20601 8192000000 10262524304 10568896512 947044352 10.362 75 57 117 0 968413424 2660112 18708960
16:57:53 29410 8192000000 10341662656 10659348480 1384044176 14.453 100 88 176 0 1418499536 5420384 29034976
16:58:29 14003 8192000000 10357685760 10679799808 1419388688 14.767 100 88 176 0 1454514880 6579328 28546864
16:58:52 27946 8192000000 10385619472 10709454848 1439382800 14.944 100 94 188 1 1478472480 7651568 31438112
16:59:28 21916 8192000000 10401012592 10728181760 1453893536 15.072 100 86 172 1 1490534480 8278464 28362480
17:00:04 14483 8192000000 10427713584 10759208960 1482294512 15.321 100 88 174 0 1519186000 8696736 28194752
17:00:26 27294 8192000000 10462267728 10798047232 1509505888 15.559 100 90 180 0 1547909536 9423120 28980528
17:01:07 18844 8192000000 10479190192 10820472832 1536001824 15.789 100 86 172 0 1572792256 9720800 27069632
17:01:36 14143 8192000000 10506356832 10850820096 1563757936 16.029 100 85 170 1 1599707344 9749792 26199616
17:01:57 19135 8192000000 10522001376 10872147968 1577755376 16.149 100 81 162 1 1613684928 10775280 25154272
17:02:27 8761 8192000000 10541166336 10895876096 1603291808 16.367 100 82 164 1 1643168816 15361088 24515920
17:02:48 10724 8192000000 10567223696 10924773376 1625980784 16.561 100 81 162 0 1666063712 15883792 24199136
17:03:08 13134 8192000000 10584713200 10941272064 1640838480 16.687 100 79 158 2 1676537936 11975568 23723888
17:03:29 11308 8192000000 10597916992 10962317312 1653648176 16.795 100 77 153 1 1689309568 12863184 22798208
17:03:50 8676 8192000000 10617527664 10986303488 1679158608 17.010 100 72 144 1 1711876384 11300240 21417536
17:04:08 10340 8192000000 10638110176 11008073728 1700414960 17.189 100 79 156 1 1733957312 11007520 22534832
17:04:27 7714 8192000000 10659664528 11030159360 1716347152 17.322 100 72 144 1 1749176224 11890048 20939024
17:04:43 5968 8192000000 10675661088 11048296448 1732279264 17.454 100 79 158 1 1767669760 12973872 22416624
17:04:57 5160 8192000000 10683244576 11058671616 1745211456 17.562 100 84 166 1 1781524432 12940368 23372608
17:05:09 6531 8192000000 10700255616 11077857280 1759611568 17.681 100 82 164 2 1796458944 13829168 23018208
17:05:25 4249 8192000000 10704739744 11084423168 1768598400 17.755 100 83 166 0 1805803888 13843376 23362112
17:05:35 3196 8192000000 10708240400 11083890688 1770672688 17.773 100 88 172 4 1808791248 14584368 23534192
17:05:46 4074 8192000000 10720144368 11099045888 1785509424 17.895 100 89 177 1 1823773248 13988816 24275008
17:05:57 3210 8192000000 10737173936 11110789120 1791727520 17.946 100 90 181 1 1830904208 14590480 24586208
17:06:07 2182 8192000000 10743607152 11119730688 1795481856 17.977 100 89 179 1 1835415536 15317904 24615776
17:06:17 3162 8192000000 10742264368 11120017408 1799190176 18.007 100 89 178 0 1838313488 14584352 24538960
17:06:27 9008 8192000000 10748497264 11130097664 1806621312 18.068 100 81 161 0 1842145888 13176640 22347936
17:06:43 6584 8192000000 10740157008 11125981184 1807091952 18.072 100 78 154 2 1841661488 13805056 20764480
17:06:56 2802 8192000000 10766715280 11150372864 1826618560 18.232 100 87 175 3 1864394832 13336720 24439552
17:07:06 2601 8192000000 10766423376 11153776640 1827272592 18.237 100 85 169 1 1865128624 13951616 23904416
17:07:15 2905 8192000000 10778550800 11160211456 1833295120 18.286 100 93 185 3 1872505584 13538416 25672048
17:07:25 2186 8192000000 10777237216 11164164096 1841752912 18.355 100 87 174 0 1879470272 13782880 23934480
17:07:33 1608 8192000000 10790623984 11175890944 1845435760 18.385 100 93 187 2 1885569520 13073120 27060640
17:07:42 2409 8192000000 10794512112 11179155456 1847678016 18.403 100 96 193 1 1888347360 13912208 26757136
17:07:51 1326 8192000000 10794524320 11183726592 1857012912 18.479 100 92 181 0 1896448256 13219952 26215392
17:07:59 1526 8192000000 10802758240 11192479744 1861085424 18.512 100 90 180 1 1899148064 13883424 24179216
17:08:07 2603 8192000000 10793780160 11182206976 1859599040 18.500 100 91 183 0 1897951584 12128784 26223760
17:08:16 1588 8192000000 10802963664 11193860096 1862238064 18.521 100 91 181 1 1900612336 12281872 26092400
17:08:24 1702 8192000000 10813026176 11200139264 1866803040 18.558 100 90 181 2 1905679920 13113056 25763824
17:08:32 26816 8192000000 10767829504 11188183040 1858391648 18.490 100 56 112 3 1883975376 9805728 15778000
17:09:08 5688 8192000000 10766933664 11188269056 1856281792 18.473 100 20 40 1 1867691440 6340320 5069328
17:09:22 8089 8192000000 10775873696 11199332352 1864380400 18.539 100 34 69 3 1880805824 6847888 9577536
17:09:37 5379 8192000000 10777388272 11200602112 1869969440 18.584 100 38 76 1 1887579808 7026672 10583696
17:09:49 10645 8192000000 10778500464 11211304960 1868688400 18.574 100 19 39 2 1879454688 5779872 4986416
17:10:10 7787 8192000000 10777297440 11206303744 1872122416 18.601 100 17 33 1 1882722080 5883392 4716272
17:10:24 11337 8192000000 10783199648 11209166848 1874253600 18.619 100 20 40 0 1886204688 6226000 5725088
17:10:42 11942 8192000000 10775376576 11208564736 1874280864 18.619 100 9 18 0 1882208688 5570464 2357360
17:11:02 12960 8192000000 10783562624 11215659008 1879427872 18.660 100 19 39 0 1890244768 5359920 5456976
17:11:21 12492 8192000000 10783421728 11215396864 1879703184 18.663 100 10 20 1 1887691760 5120048 2868528
17:11:41 9026 8192000000 10781608768 11217960960 1880864128 18.672 100 15 30 0 1891023568 5868608 4290832
17:11:59 77147 8192000000 10809328752 11240747008 1886813376 18.720 100 41 80 1 1905364080 5748736 12801968
17:13:23 8855 8192000000 10801810752 11235368960 1888043216 18.730 100 17 33 2 1898486640 5995328 4448096
17:13:38 7070 8192000000 10822169696 11242278912 1891973232 18.762 100 38 76 0 1913808480 11343824 10491424
17:13:51 7103 8192000000 10812138848 11240669184 1890990768 18.754 100 31 62 1 1906806176 7235776 8579632
17:14:08 4977 8192000000 10815111616 11247624192 1892013088 18.762 100 36 72 0 1914315008 12332112 9969808
17:14:20 8761 8192000000 10808042320 11242770432 1892844528 18.769 100 27 54 0 1907557856 7050624 7662704
17:14:36 9074 8192000000 10802461136 11244167168 1891923680 18.761 100 14 28 1 1902068320 6406720 3737920
17:14:55 8025 8192000000 10814186048 11246641152 1895305744 18.789 100 26 52 1 1908631392 5666896 7658752
17:15:09 9382 8192000000 10810862720 11244773376 1880679696 18.671 99 31 62 1 1895597536 5511488 9406352
17:15:27 6624 8192000000 10813538224 11243245568 1894356768 18.781 100 22 44 2 1906170144 5115296 6698080
17:15:41 12502 8192000000 10819980528 11248791552 1877069616 18.641 99 18 36 0 1891289920 9647104 4573200
17:16:04 13912 8192000000 10799551008 11233075200 1854872576 18.462 98 19 38 0 1869834544 9833008 5128960
17:16:28 11543 8192000000 10781242736 11212963840 1828407120 18.246 97 17 34 1 1843705184 9838272 5459792
17:16:45 53521 8192000000 10791750784 11200090112 1824687248 18.216 97 50 100 0 1844479472 5620496 14171728
17:17:46 9841 8192000000 10772329936 11202220032 1831246528 18.269 98 20 40 1 1842827712 6225232 5355952
17:18:07 7058 8192000000 10752624640 11177250816 1798635104 18.003 97 33 65 1 1814150528 6121248 9394176
17:18:23 4947 8192000000 10743874608 11162660864 1795111856 17.974 97 37 74 1 1811862896 6397440 10353600
17:18:34 4897 8192000000 10763986096 11170635776 1801913696 18.030 98 33 66 3 1817646896 6968864 8764336
17:18:45 7847 8192000000 10766714256 11185737728 1811053056 18.105 98 26 52 1 1825199728 6775760 7370912
17:19:01 4753 8192000000 10724298816 11143847936 1763861264 17.716 96 36 72 2 1780234912 6298928 10074720
17:19:12 8502 8192000000 10709909840 11126411264 1737570592 17.498 96 25 50 0 1750704928 5602384 7531952
17:19:30 6259 8192000000 10695536928 11106295808 1678496416 17.005 93 30 60 3 1693340096 5539040 9304640
17:19:45 8973 8192000000 10688403360 11105591296 1733649792 17.466 97 23 46 1 1746163920 5646048 6868080
17:20:00 9686 8192000000 10696069792 11103518720 1724017264 17.386 96 17 34 2 1733850912 4565856 5267792
17:20:16 9489 8192000000 10709613728 11113463808 1722474480 17.373 96 30 60 0 1736630240 5574688 8581072
17:20:33 8773 8192000000 10711474592 11123609600 1759139632 17.677 98 35 70 2 1776266864 6434496 10692736
17:20:48 11535 8192000000 10718172192 11127025664 1744953936 17.560 97 24 47 0 1756954128 5156976 6843216
17:21:06 61327 8192000000 10715459408 11136647168 1766537168 17.738 98 29 58 0 1780324352 5441184 8346000
17:22:15 5495 8192000000 10731177856 11159011328 1820768912 18.184 100 19 38 0 1831627744 5903040 4955792
17:22:27 5619 8192000000 10746840752 11169333248 1831521568 18.272 100 45 88 2 1852843936 8491456 12830912
17:22:40 6000 8192000000 10748159088 11175395328 1832251184 18.278 100 19 36 1 1842822352 5520496 5050672
17:22:52 6485 8192000000 10764184656 11179438080 1835188016 18.302 100 28 56 0 1850065072 7366832 7510224
17:23:07 7483 8192000000 10755893152 11179356160 1822881120 18.201 99 31 62 2 1842766320 10098400 9786800
17:23:21 10081 8192000000 10763670576 11185758208 1826536064 18.231 99 27 53 1 1840418672 6863744 7018864
17:23:41 7926 8192000000 10768157600 11189739520 1847332800 18.400 100 29 58 3 1862000112 6066736 8600576
17:23:58 7570 8192000000 10772024608 11196567552 1856914208 18.478 100 23 44 1 1867785520 5001616 5869696
17:24:18 7520 8192000000 10775490176 11204059136 1857111184 18.480 100 18 36 1 1867852032 5940288 4800560
17:24:34 13853 8192000000 10775110848 11205554176 1861917248 18.519 100 17 34 0 1872218272 5016592 5284432
17:25:01 7442 8192000000 10785896352 11212800000 1867777968 18.566 100 24 48 1 1880555968 5245152 7532848
17:25:15 11420 8192000000 10777861808 11212234752 1868228416 18.570 100 13 26 0 1877205776 5580096 3397264
17:25:35 24354 8192000000 10780305456 11215384576 1871228144 18.594 100 13 26 1 1880018352 5139888 3650320
17:26:39 26298 8192000000 10794928976 11228139520 1878924624 18.656 100 22 44 1 1890786480 6030640 5831216
17:27:14 4439 8192000000 10833944864 11251204096 1902923056 18.850 100 46 88 3 1924153136 9307456 11922624
17:27:28 17650 8192000000 10849444000 11266228224 1912638912 18.928 100 57 114 3 1937167232 8418816 16109504
17:27:53 20339 8192000000 10859226576 11278381056 1918152512 18.972 100 55 110 0 1947913936 14898384 14863040
17:28:23 44615 8192000000 10868610528 11294130176 1927482720 19.047 100 57 112 1 1956020928 12901824 15636384
17:29:19 16924 8192000000 10880051600 11307442176 1937906464 19.130 100 50 99 0 1967481696 15442352 14132880
17:29:54 17435 8192000000 10878531328 11310440448 1942722240 19.168 100 45 90 1 1969941120 15176976 12041904
17:30:21 9555 8192000000 10877332624 11315425280 1949958048 19.226 100 35 70 0 1974643536 14138336 10547152
17:30:39 13657 8192000000 10891406944 11322515456 1953047968 19.251 100 44 85 1 1978874672 14352864 11473840
17:30:59 14680 8192000000 10907811072 11335131136 1963929584 19.337 100 62 123 0 1999015184 17210688 17874912
17:31:23 10011 8192000000 10924448928 11345453056 1970625008 19.390 100 62 122 1 2007480960 18322416 18533536
17:31:50 8515 8192000000 10917988800 11349884928 1975238224 19.427 100 57 115 1 2009237792 17511360 16488208
17:32:14 6317 8192000000 10910520768 11343413248 1968405696 19.373 100 48 96 1 1999138960 16913856 13819408
17:32:31 5839 8192000000 10922974880 11354243072 1979147232 19.458 100 63 126 2 2014595216 17299152 18148832
17:32:44 29312 8192000000 10924261712 11359039488 1980869536 19.472 100 53 106 2 2014458832 18116816 15472480
17:33:34 8605 8192000000 10931839888 11369213952 1987311552 19.523 100 48 96 2 2020567600 18054304 15201744
17:33:52 10583 8192000000 10936843056 11373412352 1993576464 19.572 100 58 112 0 2028426272 17914240 16935568
17:34:10 13393 8192000000 10934451376 11374792704 1998460016 19.611 100 57 113 2 2033774512 18583856 16730640
17:34:30 3148 8192000000 10942510432 11378204672 2002217888 19.640 100 61 120 1 2036526768 17373104 16935776
17:34:40 8599 8192000000 10951891120 11383590912 2003627664 19.651 100 63 124 2 2039399376 18011072 17760640
17:34:56 9119 8192000000 10960268624 11394551808 2008708432 19.691 100 60 120 0 2053412320 27358960 17344928
17:35:15 2701 8192000000 10963190400 11396452352 2013484592 19.729 100 74 147 3 2054990096 19568064 21937440
17:35:25 15215 8192000000 10962532800 11392032768 1996747728 19.597 99 63 127 0 2034619152 19255824 18615600
17:35:52 6902 8192000000 10947151600 11382280192 1977846976 19.448 98 59 118 0 2017894896 22345616 17702304
17:36:09 8487 8192000000 10968721120 11400253440 2014953504 19.740 100 64 125 0 2055891680 22277728 18660448
17:36:25 4581 8192000000 10986154288 11414384640 2022774224 19.802 100 66 132 2 2064801104 22793168 19233712
17:36:36 8827 8192000000 10981909968 11418828800 2026420720 19.831 100 58 116 1 2068750336 25619984 16709632
17:36:54 2006 8192000000 10989166128 11411390464 2026340592 19.830 100 78 157 0 2075951920 26485072 23126256
17:37:03 10803 8192000000 10985612000 11419176960 2026408784 19.830 100 68 135 0 2073477488 27337168 19731536
17:37:23 8550 8192000000 10971247648 11398746112 2011283296 19.712 99 66 132 0 2061627920 30620528 19724096
17:37:39 3059 8192000000 11000458352 11428769792 2031677888 19.872 100 76 150 2 2083629344 28270256 23681200
17:37:49 2128 8192000000 11005450048 11431432192 2036937520 19.913 100 83 164 3 2091946496 29925328 25083648
17:38:01 7071 8192000000 10995508896 11430555648 2038874464 19.928 100 67 133 1 2089109344 30681984 19552896
17:38:17 7034 8192000000 11001802800 11443568640 2042511760 19.957 100 69 136 0 2093961472 30572560 20877152
17:38:33 7485 8192000000 11002916912 11444862976 2042370432 19.955 100 60 119 0 2090730592 30146736 18213424
17:38:54 4475 8192000000 11004022976 11444867072 2045396784 19.979 100 66 129 0 2094665776 29890272 19378720
17:39:09 4758 8192000000 10989053072 11423608832 2012981264 19.725 99 69 138 1 2061624576 27564736 21078576
17:39:20 12096 8192000000 10961951680 11398615040 1964896976 19.345 97 63 125 2 2011470288 28166240 18407072
17:39:50 6854 8192000000 10974925216 11416518656 2018629616 19.769 100 58 116 2 2069341200 31935712 18775872
17:40:13 3296 8192000000 10988273328 11418701824 2020950352 19.788 100 68 138 1 2073132048 31893856 20287840
17:40:22 3924 8192000000 10986159408 11417665536 2008298864 19.688 99 76 152 2 2064820976 33424416 23097696
17:40:35 4646 8192000000 10970483984 11384369152 1974222576 19.419 98 77 153 0 2033192784 36060848 22909360
17:40:50 5754 8192000000 10971534800 11396657152 1995354368 19.586 100 73 146 1 2055652576 37165024 23133184
17:41:04 3743 8192000000 10971921984 11391528960 1979772944 19.463 99 72 144 0 2041773840 39896528 22104368
17:41:14 4272 8192000000 10956535968 11378786304 1978722896 19.455 99 68 134 1 2037861152 37728704 21409552
17:41:25 2878 8192000000 10964386208 11384397824 1974563120 19.422 99 85 168 1 2039373552 39106640 25703792
17:41:35 5188 8192000000 10937796720 11355881472 1952048384 19.243 98 75 149 3 2014793504 39583200 23161920
17:41:49 2405 8192000000 10971795920 11391852544 1989282496 19.538 100 77 153 1 2052946800 40122880 23541424
17:42:00 2588 8192000000 10984089312 11396415488 1996464992 19.595 100 89 171 3 2062862272 40188928 26208352
17:42:09 4580 8192000000 10977890624 11398324224 1989991344 19.544 100 71 140 0 2055501920 43518864 21991712
17:42:21 1594 8192000000 10966149552 11392184320 1990029840 19.544 100 74 147 2 2056652688 43107024 23515824
17:42:31 3163 8192000000 10967019008 11391660032 1979291072 19.459 99 67 133 3 2043039760 42712432 21036256
17:42:40 1503 8192000000 10961991776 11374751744 1970817008 19.392 99 88 176 0 2040266512 42088768 27360736
17:42:49 1662 8192000000 10964767328 11381891072 1979648112 19.462 100 82 164 1 2047531024 42726656 25156256
17:43:00 1579 8192000000 10974377152 11387953152 1984301840 19.499 100 88 176 2 2055310592 43602192 27406560
17:43:08 2000 8192000000 10947934240 11365830656 1961819328 19.320 99 85 168 0 2032953072 45082608 26051136
17:43:19 4146 8192000000 10944412352 11364204544 1953505904 19.254 99 74 148 1 2023796784 46279200 24011680
17:43:31 1326 8192000000 10953706160 11371417600 1964323952 19.340 100 84 166 1 2039391312 47611456 27455904
17:43:39 2289 8192000000 10956043504 11362713600 1961214736 19.316 100 84 167 1 2037191872 48705008 27272128
17:43:48 4661 8192000000 10935293712 11338526720 1938324720 19.133 100 87 174 0 2014733232 49553280 26855232
17:44:02 3030 8192000000 10933577616 11344216064 1937678464 19.128 100 78 157 1 2012921568 50180240 25062864
17:44:12 4662 8192000000 10936954560 11351838720 1944074608 19.179 100 80 157 0 2019795728 50949584 24771536
17:44:26 2688 8192000000 10948452192 11361607680 1952329728 19.245 100 77 153 1 2028740336 51576160 24834448
17:44:36 6992 8192000000 10941624096 11362439168 1954822624 19.265 100 66 132 0 2028980912 52212544 21945744
17:44:53 2379 8192000000 10955079296 11374190592 1964100880 19.339 100 85 170 1 2043703488 51525664 28076944
17:45:03 2001 8192000000 10930503024 11344191488 1931693264 19.080 100 76 151 0 2009633568 53326048 24614256
17:45:13 3242 8192000000 10928420432 11345555456 1941832784 19.161 100 65 127 0 2013278128 51535728 19909616
17:45:26 18077 8192000000 10927189920 11357122560 1929925232 19.066 99 52 104 0 2002108480 53743504 18439744
17:45:52 8916 8192000000 10946710736 11378728960 1955500640 19.270 100 51 99 2 2033108640 59772864 17835136
17:46:12 2831 8192000000 10964697408 11375255552 1959636736 19.303 100 84 171 4 2044542208 57579104 27326368
17:46:22 2807 8192000000 10945974464 11363651584 1945366768 19.190 99 82 161 1 2027405024 56286416 25751840
17:46:32 5435 8192000000 10928609024 11351977984 1930740528 19.073 99 68 133 0 2011224704 58373472 22110704
17:46:44 17086 8192000000 10926196160 11373531136 1950209968 19.228 100 41 82 2 2023238816 58771760 14257088
17:47:10 7702 8192000000 10929486656 11361939456 1932616384 19.088 99 50 97 2 2001741952 52964672 16160896
17:47:24 5134 8192000000 10943700288 11383345152 1961514320 19.318 100 45 91 1 2033087200 56464640 15108240
17:47:37 8289 8192000000 10939312624 11368591360 1946742432 19.201 99 51 100 2 2006199504 43506016 15951056
17:47:53 2779 8192000000 10951630336 11366772736 1959511904 19.302 100 80 158 3 2030534640 45773328 25249408
17:48:03 19051 8192000000 10927919568 11369922560 1944667424 19.184 99 44 86 1 2004605680 45875504 14062752
17:48:41 7565 8192000000 10931505872 11367546880 1947317520 19.205 99 46 92 2 2003433712 41505840 14610352
17:49:05 5334 8192000000 10946744640 11381776384 1968781904 19.376 100 54 108 0 2032294512 46050064 17462544
17:49:21 17105 8192000000 10940213504 11376607232 1955027280 19.266 99 41 82 1 2014663680 46192224 13444176
17:49:55 15613 8192000000 10959824512 11409346560 1967190496 19.363 100 32 64 0 2031117728 53239040 10688192
17:50:18 20875 8192000000 10949227776 11399188480 1956340768 19.277 99 35 70 1 2020389152 52494896 11553488
17:50:45 7088 8192000000 10935424496 11401469952 1968926016 19.377 100 23 46 1 2019588384 43142960 7519408
17:51:20 15012 8192000000 10928834288 11377995776 1958081808 19.291 100 24 48 1 2009385744 42951840 8352096
17:51:44 15166 8192000000 10945318384 11392303104 1968134736 19.371 100 30 60 1 2027901984 49615792 10151456
17:52:19 25671 8192000000 10945361264 11401768960 1974300272 19.420 100 31 62 1 2031293760 46835952 10157536
17:52:53 25326 8192000000 10932925248 11403771904 1966463776 19.357 100 21 42 1 2029696336 55343504 7889056
17:53:49 49027 8192000000 10916640464 11371614208 1908433360 18.894 98 19 38 1 1964496944 49256640 6806944
17:55:24 35388 8192000000 10871411152 11342692352 1911796576 18.921 99 11 22 0 1947037632 32123360 3117696
17:56:06 15793 8192000000 10873241280 11332214784 1938583856 19.135 100 15 30 0 1951574416 8755392 4235168
17:56:32 49906 8192000000 10919544688 11357061120 1954484416 19.262 100 27 54 0 1979597264 17824752 7288096
17:57:28 158403 8192000000 10934528944 11389841408 1977892176 19.448 100 26 52 0 1997977632 12965120 7120336
18:00:14 75332 8192000000 10924727312 11384299520 1970682160 19.391 99 28 56 1 1988529696 10250784 7596752
18:01:37 45982 8192000000 10946984608 11400523776 1997519344 19.603 100 28 56 0 2019450912 14793984 7137584
18:02:30 53459 8192000000 10932642256 11391565824 1950882160 19.234 98 29 58 1 1982581168 23567568 8131440
18:04:26 37639 8192000000 10923561344 11389009920 1974789296 19.423 100 10 20 1 1998725936 20933840 3002800
18:05:11 7308 8192000000 10948932160 11403784192 1998771024 19.613 100 55 110 2 2031567904 16840976 15955904
18:05:26 10107 8192000000 10951398912 11402903552 1999486208 19.619 100 39 75 1 2033793728 23107840 11199680
18:05:43 22367 8192000000 10922759248 11387392000 1961352704 19.317 98 46 90 1 1992301696 17879104 13069888
18:06:14 36967 8192000000 10924625856 11381936128 1952743872 19.248 98 43 86 0 1982924000 17059904 13120224
18:06:58 52232 8192000000 10950741664 11396800512 1985744912 19.510 100 53 106 1 2021168512 19987056 15436544
18:07:57 72340 8192000000 10909622496 11397488640 1959339488 19.301 99 13 26 0 1979515520 16652368 3523664
18:09:56 74921 8192000000 10913758448 11398946816 1976257488 19.435 99 19 38 0 1994796480 13190288 5348704
18:12:12 51993 8192000000 10917481456 11395739648 1996356208 19.594 100 15 31 1 2009023872 8446512 4221152
18:13:16 30652 8192000000 10907707392 11399581696 1994846608 19.582 100 2 4 0 2002902512 7638912 416992
18:13:54 76705 8192000000 10919407792 11398119424 1984595920 19.501 99 17 33 0 1995890640 6636784 4657936
18:16:31 3612 8192000000 10923931024 11395915776 1985953808 19.512 99 30 61 1 2002759568 7941184 8864576
18:16:48 42097 8192000000 10881132048 11364438016 1938516576 19.135 97 23 46 0 1952986464 7919584 6550304
18:17:36 29280 8192000000 10894496688 11376250880 1967403744 19.365 99 17 34 0 1978395584 6210944 4780896
18:18:15 67624 8192000000 10898502544 11374321664 1976093184 19.434 99 16 33 0 1987999600 6895472 5010944
18:19:31 43955 8192000000 10908210032 11400241152 1996594816 19.596 100 15 30 3 2010666576 10051536 4020224
18:20:25 73423 8192000000 10913275728 11413762048 1996257536 19.593 100 5 10 0 2008390128 10798528 1334064
18:21:47 36052 8192000000 10886127456 11361112064 1866590976 18.557 93 27 51 0 1881517136 8121424 6804736
18:22:34 24372 8192000000 10886521376 11363868672 1950641088 19.232 99 26 52 0 1968163728 9889392 7633248
18:23:04 18029 8192000000 10903615040 11370176512 1954820720 19.265 99 20 40 0 1969468224 8908688 5738816
18:23:32 44409 8192000000 10881100560 11368599552 1952265808 19.245 99 24 47 2 1970413440 10560208 7587424
18:24:52 20041 8192000000 10880841216 11339792384 1913747840 18.937 98 24 48 0 1932815232 12598304 6469088
18:25:23 42603 8192000000 10864942080 11333275648 1840147904 18.342 94 21 42 2 1856473808 10626320 5699584
18:26:15 36403 8192000000 10896596896 11348045824 1917134848 18.964 99 31 62 1 1939543232 13805920 8602464
18:26:58 46582 8192000000 10899757664 11376848896 1921268064 18.997 98 28 55 1 1953883296 24865840 7749392
18:27:50 108263 8192000000 10873880112 11341733888 1814654800 18.134 93 8 16 0 1832615808 15798320 2162688
18:29:47 41218 8192000000 10862778160 11326083072 1879045280 18.657 97 18 36 1 1896699312 12851120 4802912
18:31:32 58744 8192000000 10876140544 11332710400 1882936448 18.689 97 10 20 0 1896740880 10890768 2913664
18:32:42 42613 8192000000 10874279664 11329110016 1866080608 18.553 96 30 60 1 1887794928 12955616 8758704
18:33:34 22065 8192000000 10853273152 11321225216 1883257584 18.691 98 20 40 0 1902777088 14082992 5436512
18:34:02 86590 8192000000 10846148224 11301244928 1853539616 18.451 96 26 52 2 1874889296 13504704 7844976
18:35:38 72438 8192000000 10881533328 11329323008 1921572912 18.999 99 37 74 0 1940767120 9669936 9524272
18:37:00 37528 8192000000 10901131712 11341037568 1935954384 19.114 100 53 106 1 1966382784 15016592 15411808
18:37:46 44044 8192000000 10885406336 11340300288 1951244880 19.236 100 48 96 1 1977721584 13204464 13272240
18:38:37 35192 8192000000 10862360432 11340984320 1943358080 19.174 100 23 46 0 1959207968 9634112 6215776
18:40:54 42511 8192000000 10855327328 11339939840 1907801424 18.889 98 14 28 1 1924974912 13357952 3815536
18:41:43 47181 8192000000 10858267264 11342557184 1948315216 19.213 100 17 34 0 1964422176 11050304 5056656
18:42:47 77243 8192000000 10865409872 11355066368 1936379856 19.118 99 7 14 1 1945533648 7426144 1727648
18:44:10 65233 8192000000 10876109280 11362009088 1939569712 19.143 99 10 20 0 1952622768 10495504 2557552
18:45:28 61377 8192000000 10881771488 11354030080 1919893824 18.986 98 21 42 1 1941263952 15211584 6158544
18:46:39 45294 8192000000 10889376384 11355078656 1919467136 18.983 98 29 58 2 1938648048 11363104 7817808
18:47:30 67322 8192000000 10879645264 11364220928 1942243264 19.165 99 17 34 1 1961015008 14066288 4705456
18:48:44 32031 8192000000 10912560832 11378200576 1974174192 19.419 100 30 60 0 1993866208 11966080 7725936
18:49:27 54847 8192000000 10894017504 11379449856 1945978496 19.194 99 21 42 1 1970202960 18074336 6150128
18:50:49 66532 8192000000 10893776208 11374309376 1932565952 19.087 98 18 35 1 1949487184 11993520 4927712
18:52:04 66101 8192000000 10913798256 11382976512 1959587456 19.303 99 31 61 1 1984233072 15967104 8678512
18:54:04 66793 8192000000 10912243856 11389894656 1957587792 19.287 99 20 40 0 1977680368 14040448 6052128
18:55:18 114313 8192000000 10923025984 11411841024 1973046992 19.410 99 10 20 0 1989055872 12727840 3281040
18:58:17 121724 8192000000 10930119984 11398447104 1961144080 19.315 98 14 28 1 1978047888 13373712 3530096
19:00:29 40897 8192000000 10947041552 11415334912 2007124112 19.679 100 31 62 0 2028771632 13413184 8234336
19:01:17 27969 8192000000 10916509632 11402076160 1968073184 19.370 98 23 46 0 1987354976 13146976 6134816
19:02:05 66573 8192000000 10902885616 11393486848 1979205344 19.458 100 6 12 1 1997243664 16298848 1739472
19:03:18 73327 8192000000 10907636896 11410448384 1985288224 19.507 100 15 30 0 2006800352 17223888 4288240
19:05:00 71545 8192000000 10924154288 11419676672 2000028400 19.623 100 22 44 0 2022204240 15300528 6875312
19:06:21 61571 8192000000 10904895616 11396763648 1944933984 19.186 97 22 44 0 1964238256 12814672 6489600
19:07:28 64732 8192000000 10902577648 11379539968 1904598368 18.863 96 22 41 1 1922138736 11453680 6086688
19:08:39 65928 8192000000 10932954256 11404529664 1973613136 19.414 99 33 66 1 1999119184 15778976 9727072
19:10:13 82057 8192000000 10879970176 11364388864 1899672336 18.824 96 10 20 0 1914749024 12183216 2893472
19:11:44 41152 8192000000 10907669920 11357904896 1906983632 18.882 97 36 70 2 1927322064 10258704 10079728
19:12:32 38209 8192000000 10877377104 11338211328 1868480112 18.572 95 27 54 1 1889976016 14022592 7473312
19:13:38 67960 8192000000 10861844368 11341455360 1915758944 18.953 99 18 36 0 1935375568 14823072 4793552
19:15:13 13900 8192000000 10887749520 11338502144 1923055888 19.011 99 43 85 1 1943585616 9117040 11412688
19:15:35 28065 8192000000 10876042272 11338002432 1919295984 18.981 99 43 85 0 1945652960 14625744 11731232
19:16:11 67657 8192000000 10827869728 11305566208 1832383216 18.279 95 37 75 0 1858045600 15316128 10346256
19:17:42 32159 8192000000 10877841248 11332407296 1911102048 18.915 99 37 74 0 1930622976 9311424 10209504
19:18:20 112962 8192000000 10806442544 11268915200 1868424128 18.572 97 42 84 1 1890050144 9986160 11639856
19:21:03 65559 8192000000 10823556720 11307810816 1885314048 18.708 98 22 44 0 1898701904 6464512 6923344
19:22:24 85805 8192000000 10828692192 11301457920 1903770576 18.857 99 14 28 0 1914391664 6893552 3727536
19:23:56 73535 8192000000 10828570736 11300528128 1850129152 18.423 96 24 48 0 1867951536 9461424 8360960
19:25:18 69310 8192000000 10833450240 11321769984 1908148688 18.892 100 11 22 2 1926616720 15142560 3325472
19:26:47 42129 8192000000 10232220048 10661085184 1307746768 13.766 69 4 8 1 1325324864 16696848 881248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-02-2021 19:29:04 to 03-02-2021 19:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 208 v_add_invoice_to_stock 335544517
except 21 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-02-2021 19:29:36 to 03-02-2021 19:29:38.

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          244502
MON$OLDEST_ACTIVE               244840
MON$OLDEST_SNAPSHOT             244840
MON$NEXT_TRANSACTION            244840
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                       2028576
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:123: 
:124: mscs-test-161.budzdorov.ru    Wed Feb  3 19:27:33 2021
:125:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:126: 
:127: 
:128: mscs-test-161.budzdorov.ru    Wed Feb  3 19:27:33 2021
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
:131: 
:132: mscs-test-161.budzdorov.ru    Wed Feb  3 19:27:33 2021
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
:135: 
:136: mscs-test-161.budzdorov.ru    Wed Feb  3 19:27:33 2021
:137:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:138: 
--- end of diff output ---

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

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