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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17619864 kB
MemAvailable 31620192 kB
Buffers 0 kB
Cached 14060616 kB
SwapCached 2012 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-27 22:27:01
DTS_END                         2020-11-27 22:27:01.4710
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(108:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47830
TRN_ID                          250486
ATT_ID                          731
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: 9430.91 19613 1131709
customer order: creation 188.05 302 22566
customer order: refuse 16.70 331 2004
order to supplier: creation 49.54 1131 5945
order to supplier: removal 3.55 87153 426
invoice (draft): creation 50.09 3031 6011
invoice (draft): removal 52.18 734 6261
invoice accept: apply 45.56 18129 5467
invoice accept: cancel 47.64 774 5717
customer reserve: creation 4061.51 188 487381
customer reserve: removal 4605.00 53 552600
realization accept: apply 90.24 152 10829
realization accept: cancel 80.19 103 9623
payment from customer: creation 64.13 94 7696
payment from customer: removal 6.61 62 793
payment to supplier: creation 52.99 106 6359
payment to supplier: removal 3.51 92 421
service: total inventory turnovers 5.25 998 630
service: total monetary turnovers 7.17 19 860
service: aggregate perf. data 0.97 17256 116
service: refresh index statistics 0.03 261556 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-11-2020 22:28:04 to 27-11-2020 22:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11738
TEST_TIME 2 8025
TEST_TIME 3 7418
TEST_TIME 4 7104
TEST_TIME 5 6713
TEST_TIME 6 6696
TEST_TIME 7 6985
TEST_TIME 8 6966
TEST_TIME 9 6814
TEST_TIME 10 7026
TEST_TIME 11 7414
TEST_TIME 12 7520
TEST_TIME 13 8137
TEST_TIME 14 8847
TEST_TIME 15 8958
TEST_TIME 16 9446
TEST_TIME 17 9737
TEST_TIME 18 9531
TEST_TIME 19 9426
TEST_TIME 20 9745
TEST_TIME 21 9683
TEST_TIME 22 9675
TEST_TIME 23 10343
TEST_TIME 24 10427
TEST_TIME 25 10448
TEST_TIME 26 11074
TEST_TIME 27 11480
TEST_TIME 28 11270
TEST_TIME 29 11117
TEST_TIME 30 10933
TEST_TIME 31 10687
TEST_TIME 32 10705
TEST_TIME 33 10557
TEST_TIME 34 10736
TEST_TIME 35 10644
TEST_TIME 36 10559
TEST_TIME 37 10478
TEST_TIME 38 10432
TEST_TIME 39 10459
TEST_TIME 40 10358
TEST_TIME 41 10222
TEST_TIME 42 10014
TEST_TIME 43 10033
TEST_TIME 44 10047
TEST_TIME 45 10011
TEST_TIME 46 9993
TEST_TIME 47 10006
TEST_TIME 48 10116
TEST_TIME 49 10091
TEST_TIME 50 10100
TEST_TIME 51 10050
TEST_TIME 52 10048
TEST_TIME 53 10318
TEST_TIME 54 10307
TEST_TIME 55 10295
TEST_TIME 56 10233
TEST_TIME 57 10212
TEST_TIME 58 10080
TEST_TIME 59 10013
TEST_TIME 60 9941
TEST_TIME 61 9944
TEST_TIME 62 10029
TEST_TIME 63 9945
TEST_TIME 64 9860
TEST_TIME 65 9881
TEST_TIME 66 9865
TEST_TIME 67 9799
TEST_TIME 68 9822
TEST_TIME 69 9908
TEST_TIME 70 9937
TEST_TIME 71 9974
TEST_TIME 72 9929
TEST_TIME 73 9896
TEST_TIME 74 9913
TEST_TIME 75 9965
TEST_TIME 76 9959
TEST_TIME 77 9990
TEST_TIME 78 10077
TEST_TIME 79 10015
TEST_TIME 80 9932
TEST_TIME 81 9882
TEST_TIME 82 9870
TEST_TIME 83 9828
TEST_TIME 84 9807
TEST_TIME 85 9737
TEST_TIME 86 9685
TEST_TIME 87 9713
TEST_TIME 88 9641
TEST_TIME 89 9602
TEST_TIME 90 9624
TEST_TIME 91 9609
TEST_TIME 92 9595
TEST_TIME 93 9564
TEST_TIME 94 9660
TEST_TIME 95 9623
TEST_TIME 96 9677
TEST_TIME 97 9684
TEST_TIME 98 9659
TEST_TIME 99 9664
TEST_TIME 100 9652
TEST_TIME 101 9652
TEST_TIME 102 9634
TEST_TIME 103 9664
TEST_TIME 104 9640
TEST_TIME 105 9761
TEST_TIME 106 9673
TEST_TIME 107 9641
TEST_TIME 108 9598
TEST_TIME 109 9615
TEST_TIME 110 9574
TEST_TIME 111 9525
TEST_TIME 112 9467
TEST_TIME 113 9419
TEST_TIME 114 9401
TEST_TIME 115 9468
TEST_TIME 116 9502
TEST_TIME 117 9477
TEST_TIME 118 9466
TEST_TIME 119 9511
TEST_TIME 120 9432

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-11-2020 22:28:08 to 27-11-2020 22:28:11.

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 1584807 1584807 0 0.00 0 13407 7 0 0
doc_list_biud 1584807 1584807 0 0.00 0 23615 24 0 0
sp_add_invoice_to_stock 5625 5467 158 2.80 52 210479 18130 0 158
sp_cancel_adding_invoice 5717 5717 0 0.00 4 53529 774 0 0
sp_cancel_client_order 2004 2004 0 0.00 5 11716 332 0 0
sp_cancel_customer_reserve 552600 552600 0 0.00 1 23619 53 0 0
sp_cancel_pay_from_customer 793 793 0 0.00 3 3631 62 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 2978 92 0 0
sp_cancel_supplier_invoice 6269 6261 8 0.12 2 14113 734 0 8
sp_cancel_supplier_order 426 426 0 0.00 7 859534 87154 0 0
sp_cancel_write_off 9623 9623 0 0.00 1 8339 104 0 0
sp_client_order 22566 22566 0 0.00 3 12850 303 0 0
sp_customer_reserve 487381 487381 0 0.00 0 142078 189 0 0
sp_fill_shopping_cart 34484 34484 0 0.00 1 15332 34 0 0
sp_fill_shopping_cart_clo_res 487370 487370 0 0.00 0 12091 12 0 0
sp_get_clo_for_invoice 5456 5456 0 0.00 0 12910 220 0 0
sp_kill_cost_storno 16554 16554 0 0.00 0 6448 50 0 0
sp_kill_qstorno_ret_qs2qd 1121510 1121510 0 0.00 0 23602 29 0 0
sp_kill_qty_storno 592916 592916 0 0.00 0 23615 62 0 0
sp_lock_selected_doc 22736 22736 0 0.00 0 9168 6 0 0
sp_make_cost_storno 30340 30340 0 0.00 0 11571 39 0 0
sp_multiply_rows_for_pdistr 30340 30340 0 0.00 0 6804 25 0 0
sp_multiply_rows_for_qdistr 22566 22566 0 0.00 0 12480 150 0 0
sp_pay_from_customer 7696 7696 0 0.00 4 11590 94 0 0
sp_pay_to_supplier 6359 6359 0 0.00 5 23416 106 0 0
sp_payment_common 14055 14055 0 0.00 1 23401 27 0 0
sp_qd_handle_on_cancel_clo 2004 2004 0 0.00 0 11703 298 0 0
sp_qd_handle_on_invoice_upd_sts 11173 11173 0 0.00 0 13343 278 0 0
sp_qd_handle_on_reserve_upd_sts 10829 10829 0 0.00 0 18787 46 0 0
sp_reserve_write_off 10829 10829 0 0.00 5 18799 152 0 0
sp_supplier_invoice 6011 6011 0 0.00 7 93110 3031 0 0
sp_supplier_order 5945 5945 0 0.00 5 32966 1132 0 0
srv_aggregate_perf_data 116 116 0 0.00 2542 257208 17257 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1135 150491 32973 0 0
srv_find_qd_qs_mism 1081241 1081241 0 0.00 0 13405 7 0 0
srv_make_invnt_saldo 630 630 0 0.00 35 63504 998 0 0
srv_make_money_saldo 860 860 0 0.00 0 778 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 98961 468822 261557 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5467 5467 0 0.00 0 13682 159 0 0
t$perf-norm:sp_cancel_adding_invoice 483 483 0 0.00 0 1613 66 0 0
t$perf-norm:sp_cancel_client_order 2004 2004 0 0.00 0 3788 15 0 0
t$perf-norm:sp_cancel_customer_reserve 768 768 0 0.00 0 3875 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 793 793 0 0.00 0 1145 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 799 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 7407 34 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 19696 1370 0 0
t$perf-norm:sp_cancel_write_off 1128 1128 0 0.00 0 1117 4 0 0
t$perf-norm:sp_client_order 22566 22566 0 0.00 0 13685 19 0 0
t$perf-norm:sp_customer_reserve 1100 1100 0 0.00 0 9176 18 0 0
t$perf-norm:sp_pay_from_customer 7696 7696 0 0.00 0 9545 11 0 0
t$perf-norm:sp_pay_to_supplier 6359 6359 0 0.00 0 7622 11 0 0
t$perf-norm:sp_reserve_write_off 10829 10829 0 0.00 0 9775 11 0 0
t$perf-norm:sp_supplier_invoice 6011 6011 0 0.00 0 6215 15 0 0
t$perf-norm:sp_supplier_order 5945 5945 0 0.00 0 8215 16 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 623 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 821 10 0 0
t$perf-norm:srv_make_invnt_saldo 630 630 0 0.00 0 707 16 0 0
t$perf-norm:srv_make_money_saldo 860 860 0 0.00 0 11219 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 11228 10912 316 2.81 0 7383 20 0 316
v_all_customers 40966 40966 0 0.00 0 25 1 0 0
v_all_suppliers 32826 32826 0 0.00 0 23 1 0 0
v_all_wares 45124 45124 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 966 966 0 0.00 0 2824 11 0 0
v_cancel_client_order 4008 4008 0 0.00 0 6456 7 0 0
v_cancel_customer_prepayment 1586 1586 0 0.00 0 3592 6 0 0
v_cancel_customer_reserve 1536 1536 0 0.00 0 301 3 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 2949 16 0 0
v_cancel_supplier_invoice 872 856 16 1.83 0 916 14 0 16
v_cancel_supplier_order 852 852 0 0.00 0 4245 16 0 0
v_cancel_write_off 2256 2256 0 0.00 0 974 11 0 0
v_max_id_clo_ord 5934 5934 0 0.00 0 245 1 0 0
v_max_id_clo_res 1100 1100 0 0.00 0 2605 12 0 0
v_max_id_ord_sup 5988 5988 0 0.00 0 3236 3 0 0
v_max_non_paid_invoice 1868 1868 0 0.00 0 5276 6 0 0
v_max_non_paid_realizn 4134 4134 0 0.00 0 5796 4 0 0
v_min_id_clo_ord 5934 5934 0 0.00 0 2059 4 0 0
v_min_id_clo_res 1100 1100 0 0.00 0 4560 8 0 0
v_min_id_ord_sup 5988 5988 0 0.00 0 3721 3 0 0
v_min_non_paid_invoice 6359 6359 0 0.00 0 23396 19 0 0
v_min_non_paid_realizn 7696 7696 0 0.00 0 5794 15 0 0
v_our_firm 11282 11282 0 0.00 0 22 1 0 0
v_reserve_write_off 21658 21658 0 0.00 0 6599 6 0 0
x_lock_depdocs_on_canc_invoice 11550 11550 0 0.00 0 13151 116 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 26861 444 0 0
x_make_qstorno_1000_1200 5945 5945 0 0.00 2 32957 1057 0 0
x_make_qstorno_1200_2000 6011 6011 0 0.00 3 93094 2913 0 0
x_make_qstorno_2100_3300 487381 487381 0 0.00 0 142077 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-11-2020 22:28:12 to 27-11-2020 22:28:16.

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
19:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:11 16387 8192000000 10233151968 10541498368 925753360 10.153 73 56 110 1 946740832 2491040 18496432
19:57:38 19109 8192000000 10308920320 10624872448 1350885872 14.155 100 82 164 0 1383910992 4721744 28303376
19:58:05 33303 8192000000 10358186752 10678362112 1397971328 14.577 100 87 174 0 1433243168 6198768 29073072
19:58:48 15510 8192000000 10382286832 10708074496 1433500256 14.892 100 92 184 0 1471221920 7234528 30487136
19:59:14 20865 8192000000 10402831600 10733154304 1454501568 15.078 100 82 164 1 1489447712 7885040 27061104
19:59:43 6358 8192000000 10418249216 10748153856 1477747984 15.282 100 88 176 0 1514893392 8171440 28973968
20:00:01 22171 8192000000 10428759808 10760683520 1485659264 15.351 100 87 174 1 1522613488 8575200 28379024
20:00:37 18790 8192000000 10454304416 10789933056 1498239712 15.461 100 83 166 1 1534250144 9206080 26804352
20:01:08 8636 8192000000 10473399760 10814791680 1531913088 15.754 100 85 170 0 1572234560 13811552 26509920
20:01:28 21915 8192000000 10506177920 10850541568 1553665376 15.942 100 82 164 1 1588393344 9353152 25374816
20:01:57 19373 8192000000 10527408240 10878705664 1581501360 16.181 100 84 166 3 1616384576 9771088 25112128
20:02:26 18057 8192000000 10557239376 10914906112 1615617040 16.473 100 85 170 1 1652658960 11123872 25918048
20:02:58 13458 8192000000 10595981392 10954797056 1640955232 16.688 100 77 154 2 1675764752 12039600 22769920
20:03:19 9081 8192000000 10608853344 10970034176 1663548384 16.879 100 82 163 0 1699769984 13064336 23157264
20:03:36 11012 8192000000 10628529856 10990796800 1681420320 17.029 100 80 160 1 1717534192 12959376 23154496
20:03:54 7267 8192000000 10637305232 11001753600 1693757168 17.133 100 83 166 2 1731348368 13151168 24440032
20:04:11 7699 8192000000 10647747728 11018555392 1705776768 17.233 100 81 158 1 1741252064 12712544 22762752
20:04:27 6689 8192000000 10658400992 11029901312 1719645584 17.349 100 83 166 1 1756520736 13031920 23843232
20:04:40 7250 8192000000 10670327424 11044532224 1731987216 17.452 100 89 176 5 1768421072 11645488 24788368
20:04:56 6251 8192000000 10680135680 11055820800 1742843936 17.542 100 83 165 0 1779583680 12726544 24013200
20:05:09 6937 8192000000 10694469536 11069251584 1752110832 17.619 100 78 151 2 1785299488 12253152 20935504
20:05:23 3516 8192000000 10703386032 11080474624 1762453696 17.705 100 82 161 4 1798467744 13278256 22735792
20:05:34 3914 8192000000 10712148640 11087921152 1775149744 17.810 100 85 172 2 1811976672 12905872 23921056
20:05:44 3904 8192000000 10722602448 11102609408 1781914208 17.865 100 84 167 2 1817936448 13035248 22986992
20:05:55 3377 8192000000 10735164032 11111727104 1790597392 17.937 100 89 174 3 1828558192 13993920 23966880
20:06:05 3492 8192000000 10737806720 11118407680 1796057136 17.982 100 81 160 0 1832434352 14251632 22125584
20:06:15 3330 8192000000 10740893504 11123576832 1802882576 18.038 100 87 173 2 1841322752 14253472 24186704
20:06:25 3718 8192000000 10745843600 11126693888 1810704288 18.102 100 85 170 1 1847692224 13608400 23379536
20:06:36 6373 8192000000 10745971888 11133202432 1811230272 18.106 100 81 162 0 1848802016 15169824 22401920
20:06:49 5757 8192000000 10765859280 11148951552 1814784160 18.135 100 81 161 1 1850834000 13328608 22721232
20:07:01 3291 8192000000 10775878208 11162132480 1833541104 18.288 100 83 167 2 1869088544 11953472 23593968
20:07:11 2549 8192000000 10779753264 11166945280 1839338672 18.335 100 84 162 1 1875388128 11690128 24359328
20:07:20 2622 8192000000 10789443424 11174199296 1850798768 18.429 100 91 182 3 1891551632 13983472 26769392
20:07:29 2021 8192000000 10799353056 11183910912 1853573696 18.451 100 94 190 0 1894369776 13263760 27532320
20:07:37 2122 8192000000 10792858816 11183210496 1854023456 18.455 100 89 177 3 1892317200 13265040 25028704
20:07:46 2228 8192000000 10799729344 11189391360 1859799968 18.502 100 90 180 2 1897224096 12799568 24624560
20:07:55 1849 8192000000 10800409344 11189886976 1861596944 18.516 100 86 172 1 1899134560 13878624 23658992
20:08:03 2063 8192000000 10814204096 11200446464 1865008336 18.544 100 90 180 2 1904119808 13476576 25634896
20:08:11 6787 8192000000 10800004832 11198357504 1864872160 18.543 100 81 162 0 1900466144 12254960 23339024
20:08:24 1865 8192000000 10822667968 11208540160 1873491008 18.613 100 96 192 0 1914135408 13456256 27188144
20:08:32 4489 8192000000 10794656320 11194941440 1870801216 18.591 100 78 157 0 1906528672 13802800 21924656
20:08:44 36747 8192000000 10795177264 11203743744 1866563776 18.556 100 49 97 2 1888334448 7232480 14538192
20:09:28 5510 8192000000 10795176112 11201904640 1867262768 18.562 100 39 78 1 1887475840 8559584 11653488
20:09:42 3363 8192000000 10807813520 11213938688 1872373664 18.603 100 61 123 1 1900148288 10659968 17114656
20:09:54 2505 8192000000 10807543248 11214508032 1879647984 18.662 100 68 138 2 1907811504 9350336 18813184
20:10:03 4077 8192000000 10795145856 11210715136 1874791520 18.623 100 35 70 0 1892648544 8457648 9399376
20:10:14 8569 8192000000 10788993024 11211124736 1874057440 18.617 100 19 36 1 1885855120 6817904 4979776
20:10:29 10064 8192000000 10782650464 11211358208 1875752592 18.631 100 21 42 0 1887613568 6024992 5835984
20:10:46 5249 8192000000 10789952240 11218067456 1880621936 18.670 100 28 57 0 1894791632 6339392 7830304
20:10:58 7034 8192000000 10789924256 11220627456 1883067616 18.690 100 35 64 2 1900198432 6957648 10173168
20:11:13 9256 8192000000 10790981920 11222466560 1882277888 18.683 100 19 37 1 1894705888 6607488 5820512
20:11:29 13355 8192000000 10792894720 11222102016 1883809920 18.696 100 19 39 0 1895393472 6280128 5303424
20:11:49 9218 8192000000 10792109872 11222925312 1884261920 18.700 100 21 42 1 1896815280 6473280 6080080
20:12:07 69701 8192000000 10809812672 11237486592 1887360768 18.725 100 31 63 0 1902480768 6197888 8922112
20:13:25 8121 8192000000 10812938512 11236941824 1888377664 18.733 100 20 40 0 1899310896 5291952 5641280
20:13:40 6836 8192000000 10809175536 11240050688 1891782240 18.760 100 31 62 0 1906760032 6743440 8234352
20:13:57 5991 8192000000 10813532752 11243941888 1895460848 18.790 100 35 70 2 1912438880 7165632 9812400
20:14:09 8028 8192000000 10815042336 11245682688 1897915376 18.810 100 37 72 1 1920000368 12848752 9236240
20:14:23 5455 8192000000 10824586224 11250802688 1900611312 18.831 100 34 69 0 1917204000 5851088 10741600
20:14:35 11415 8192000000 10826493488 11250843648 1897842976 18.809 100 18 36 2 1908639856 5854224 4942656
20:14:53 7667 8192000000 10815852880 11245785088 1904780224 18.865 100 22 44 0 1916770768 5747248 6243296
20:15:08 6491 8192000000 10810415776 11246723072 1901940832 18.842 100 15 30 1 1911538480 5622672 3974976
20:15:21 13331 8192000000 10815528496 11248984064 1901816256 18.841 100 24 48 0 1915638016 5859360 7962400
20:15:40 11519 8192000000 10808673504 11247538176 1900677344 18.832 100 19 37 1 1910968912 5111424 5180144
20:15:58 10765 8192000000 10808680128 11236184064 1864760960 18.542 98 30 60 1 1878751376 5087296 8903120
20:16:16 11113 8192000000 10800123872 11234603008 1875074704 18.625 99 15 30 1 1885128704 5913136 4140864
20:16:38 14034 8192000000 10798644800 11217350656 1817579568 18.158 96 31 62 0 1831892464 5555120 8757776
20:17:00 65739 8192000000 10758059216 11195600896 1805429456 18.058 96 41 82 3 1826965232 10150448 11385328
20:18:13 8566 8192000000 10778284400 11209494528 1818413440 18.165 97 24 48 2 1835118896 10266688 6438768
20:18:27 8994 8192000000 10774339280 11197808640 1823556960 18.207 98 30 60 1 1842149856 10393936 8198960
20:18:42 4666 8192000000 10750203472 11176124416 1782890192 17.873 96 28 56 0 1796968064 6124736 7953136
20:19:00 4371 8192000000 10735391760 11151495168 1772355536 17.786 97 22 44 1 1784699696 6589280 5754880
20:19:12 5700 8192000000 10732131056 11143835648 1786678272 17.904 98 21 42 0 1798558496 5270624 6609600
20:19:25 4989 8192000000 10733520784 11142848512 1747056768 17.577 96 30 58 3 1760927840 5249376 8621696
20:19:40 2839 8192000000 10708416816 11115495424 1771359824 17.778 98 37 75 0 1788999504 6156416 11483264
20:19:50 17025 8192000000 10698164912 11118333952 1717209216 17.329 94 24 48 2 1729674528 5004496 7460816
20:20:14 6880 8192000000 10726049712 11141853184 1788376272 17.918 99 25 49 1 1801573712 6186400 7011040
20:20:28 8050 8192000000 10679739152 11101347840 1697485664 17.164 94 29 57 2 1711942160 5893440 8563056
20:20:42 7926 8192000000 10693603552 11108450304 1749229056 17.595 98 17 34 3 1759983184 5193360 5560768
20:20:56 9263 8192000000 10691369984 11113435136 1724170048 17.387 96 31 62 4 1739098112 5707456 9220608
20:21:21 8441 8192000000 10704181184 11117281280 1760113376 17.685 98 21 42 2 1771977328 5459664 6404288
20:21:37 71033 8192000000 10697659088 11116498944 1720695216 17.358 95 33 66 0 1739758272 9183200 9879856
20:22:59 5639 8192000000 10709863440 11125006336 1769757728 17.765 98 34 68 0 1786352560 7054608 9540224
20:23:14 3808 8192000000 10730050992 11137712128 1788253824 17.917 99 38 77 2 1810006816 10934464 10818528
20:23:28 7348 8192000000 10730265760 11146383360 1810396800 18.099 100 27 54 3 1824516160 6657648 7461712
20:23:42 6658 8192000000 10758867152 11173257216 1829384768 18.254 100 44 85 3 1851736960 10212688 12139504
20:23:56 6716 8192000000 10753477008 11173396480 1836281808 18.311 100 29 58 1 1849752416 5481552 7989056
20:24:09 9782 8192000000 10769494528 11182956544 1839415104 18.336 100 23 46 1 1850956800 4987296 6554400
20:24:27 19179 8192000000 10764447728 11192639488 1851715792 18.436 100 13 26 1 1860833360 5225984 3891584
20:24:52 6703 8192000000 10777502384 11199823872 1857281568 18.481 100 24 48 0 1870530944 6210416 7038960
20:25:05 8830 8192000000 10770137248 11200860160 1861079696 18.512 100 22 44 1 1872229440 4874272 6275472
20:25:22 7993 8192000000 10776926144 11204169728 1866630736 18.557 100 36 72 1 1883607024 5654848 11321440
20:25:36 10782 8192000000 10776669824 11208323072 1862185312 18.521 100 15 30 0 1872098496 5361680 4551504
20:25:54 9714 8192000000 10777090016 11208667136 1865190384 18.545 100 15 30 0 1875475344 5913472 4371488
20:26:13 65428 8192000000 10803737904 11226329088 1874997472 18.625 100 31 63 2 1889410816 5397216 9016128
20:27:28 7038 8192000000 10828645072 11242586112 1903403680 18.854 100 70 136 1 1931367248 7962192 20001376
20:27:42 3205 8192000000 10861216944 11267727360 1916229296 18.957 100 72 144 1 1945374928 8612080 20533552
20:27:56 12111 8192000000 10857707696 11271671808 1919220096 18.981 100 54 106 1 1943905200 9825488 14859616
20:28:16 22396 8192000000 10858985616 11278774272 1925872064 19.034 100 51 102 1 1950325136 9533712 14919360
20:28:48 5962 8192000000 10865861648 11290447872 1933047616 19.091 100 51 101 3 1957448064 9514016 14886432
20:29:03 14738 8192000000 10877719120 11299942400 1938953344 19.138 100 46 92 3 1962053296 9738208 13361744
20:29:27 15418 8192000000 10888373632 11306340352 1944890416 19.186 100 57 115 2 1977865424 16265424 16709584
20:30:00 19117 8192000000 10878832016 11304181760 1947050912 19.203 100 54 108 3 1974723792 11369120 16303760
20:30:29 18465 8192000000 10870530336 11305123840 1949096192 19.219 100 49 98 0 1974062048 10118192 14847664
20:30:55 36109 8192000000 10874197040 11317198848 1949754384 19.225 100 30 60 1 1968711536 10094048 8863104
20:31:46 22169 8192000000 10888502096 11324772352 1961205328 19.316 100 39 76 0 1983990224 11732688 11052208
20:32:21 11033 8192000000 10902870928 11332104192 1965573424 19.350 100 42 84 1 1990545664 12637168 12335072
20:32:39 7772 8192000000 10916896464 11344998400 1972694288 19.407 100 54 108 1 2002038896 13466752 15877856
20:32:54 31004 8192000000 10913805456 11345395712 1955467680 19.270 99 50 100 1 1984362256 14554832 14339744
20:33:34 17149 8192000000 10918243088 11355828224 1979379952 19.460 100 50 100 1 2009787312 15844064 14563296
20:33:59 22498 8192000000 10923926480 11361935360 1983381952 19.491 100 46 90 1 2013339504 16504624 13452928
20:34:42 6639 8192000000 10938532304 11369562112 1994311376 19.578 100 54 108 3 2026547184 15701056 16534752
20:34:55 6025 8192000000 10947272320 11374972928 1999552944 19.619 100 60 120 0 2034587072 17842272 17191856
20:35:09 6139 8192000000 10951252000 11375194112 2000796672 19.629 100 69 138 0 2035951440 15099856 20054912
20:35:42 10290 8192000000 10952489312 11385389056 2003145376 19.648 100 58 114 0 2036612496 16510416 16956704
20:36:00 4164 8192000000 10962052704 11388559360 2005401664 19.665 100 65 130 2 2045653504 21160032 19091808
20:36:12 8979 8192000000 10952237920 11379339264 2003869040 19.653 100 76 151 2 2043907040 17355360 22682640
20:36:31 17674 8192000000 10952690496 11385413632 2012511280 19.721 100 72 145 1 2052304496 18398416 21394800
20:37:04 2901 8192000000 10963476912 11394236416 2010024144 19.702 100 72 142 3 2054342256 23281200 21036912
20:37:17 1577 8192000000 10978231904 11396104192 2016465728 19.752 100 82 160 1 2062699600 23430160 22803712
20:37:25 2490 8192000000 10974351200 11401007104 2016753424 19.755 100 77 152 3 2063185968 24679872 21752672
20:37:36 9284 8192000000 10981567408 11409960960 2021403120 19.791 100 69 137 1 2066351360 25262976 19685264
20:37:53 1825 8192000000 10988741776 11412955136 2027799680 19.841 100 85 165 1 2076269248 24962224 23507344
20:38:01 3263 8192000000 10981212928 11399651328 1987246352 19.522 98 72 141 2 2033348288 25067376 21034560
20:38:11 2644 8192000000 10980621120 11390562304 1991922864 19.559 99 79 157 2 2041549888 26423616 23203408
20:38:20 3798 8192000000 10986722416 11403624448 2016638560 19.754 100 77 151 1 2065508368 26956752 21913056
20:38:32 4176 8192000000 10983231632 11407872000 2020200768 19.782 100 79 157 1 2072817504 29466016 23150720
20:38:43 3878 8192000000 10978427536 11401207808 2010055136 19.702 100 73 146 0 2062640240 30374576 22210528
20:38:59 4562 8192000000 10973797088 11394449408 1991063168 19.552 99 82 164 0 2046437856 30845056 24529632
20:39:11 4290 8192000000 10972583104 11394863104 2005982272 19.670 100 77 154 1 2061722912 32699648 23040992
20:39:27 5198 8192000000 10960339584 11392086016 1987164816 19.521 99 73 142 0 2041806720 32849488 21792416
20:39:47 7540 8192000000 10954792528 11379593216 1977165392 19.442 99 65 130 0 2030240496 32864432 20210672
20:40:04 3756 8192000000 10967025264 11388964864 1996366176 19.594 100 71 142 1 2052165504 34664048 21135280
20:40:16 5710 8192000000 10955302480 11385987072 1990367072 19.547 100 52 102 1 2039843952 33764784 15712096
20:40:30 4192 8192000000 10963864800 11397046272 1998912272 19.614 100 65 130 1 2051431584 31625232 20894080
20:40:43 1134 8192000000 10991053824 11412316160 2014574032 19.738 100 93 187 0 2075952192 33510032 27868128
20:40:50 2444 8192000000 10943360720 11361488896 1961641376 19.319 98 81 159 0 2022332736 36341408 24349952
20:41:00 2012 8192000000 10956145696 11380477952 1961101744 19.315 98 83 165 3 2021359488 33979136 26278608
20:41:12 1930 8192000000 10939213184 11357224960 1956379104 19.277 99 79 157 2 2015441824 35315632 23747088
20:41:21 2111 8192000000 10961298992 11376496640 1977996768 19.449 100 89 177 1 2044439312 38708928 27733616
20:41:32 7616 8192000000 10920003904 11351961600 1956315568 19.277 99 61 120 1 2005824832 31264752 18244512
20:41:48 8399 8192000000 10941934064 11361230848 1972847904 19.408 100 62 123 0 2020854064 28978448 19027712
20:42:04 7879 8192000000 10939655888 11353968640 1961391920 19.317 100 79 158 0 2018963712 32666336 24905456
20:42:19 2864 8192000000 10952202208 11365875712 1972482816 19.405 100 90 180 3 2034277680 34493680 27301184
20:42:29 7750 8192000000 10934424480 11357532160 1949655696 19.224 99 61 121 1 2005285472 36774208 18855568
20:42:46 1782 8192000000 10932124720 11338371072 1944177616 19.180 98 86 172 2 2006021824 35227248 26616960
20:42:55 1490 8192000000 10966973504 11378561024 1978409184 19.452 100 88 176 6 2041109168 35447376 27252608
20:43:03 3163 8192000000 10940795056 11357487104 1942069888 19.163 98 81 162 1 2001446688 34247152 25129648
20:43:13 6220 8192000000 10946623552 11361251328 1964293712 19.340 100 76 153 1 2016763376 29864912 22604752
20:43:26 1630 8192000000 10963149312 11371229184 1981319680 19.475 100 91 182 1 2040804800 31290672 28194448
20:43:34 3609 8192000000 10946064320 11365216256 1962538256 19.326 99 72 144 1 2016757488 32286160 21933072
20:43:46 2037 8192000000 10901893248 11316166656 1919469408 18.983 98 77 153 1 1975432032 31824880 24137744
20:43:55 1927 8192000000 10939031200 11344523264 1956911040 19.281 100 82 165 1 2017386624 34593232 25882352
20:44:04 1985 8192000000 10941565968 11357581312 1968312704 19.372 100 81 160 2 2026742816 33100112 25330000
20:44:12 2660 8192000000 10953230032 11365011456 1972049760 19.402 100 86 175 1 2034017632 34799376 27168496
20:44:22 5428 8192000000 10953130096 11369852928 1977010720 19.441 100 86 172 1 2038722896 35466608 26245568
20:44:34 11517 8192000000 10941681904 11371954176 1973270848 19.411 100 52 104 0 2021197408 31771440 16155120
20:44:53 27114 8192000000 10915191312 11356246016 1931484496 19.079 98 32 64 1 1971987840 30174352 10328992
20:45:28 15713 8192000000 10920654992 11354312704 1933125376 19.092 98 48 96 1 1978790752 30590208 15075168
20:45:55 7765 8192000000 10937094192 11367374848 1969178512 19.379 100 55 110 1 2020587312 33716560 17692240
20:46:12 7906 8192000000 10917748448 11355418624 1958526304 19.294 100 47 94 2 2008394560 34787504 15080752
20:46:35 7794 8192000000 10892241072 11325095936 1902272592 18.845 98 49 98 0 1953624976 35490816 15861568
20:46:51 8708 8192000000 10899418448 11335323648 1934255088 19.101 100 38 76 1 1986461936 39834048 12372800
20:47:08 7073 8192000000 10918316352 11347587072 1947293488 19.205 100 50 100 0 2000328736 36869984 16165264
20:47:25 13138 8192000000 10910872432 11350638592 1952850448 19.249 100 40 80 5 1998065536 32349344 12865744
20:48:07 23134 8192000000 10914115664 11351547904 1938438976 19.134 99 27 53 1 1983201728 35559360 9203392
20:48:37 16787 8192000000 10914107008 11347537920 1927224656 19.045 99 37 74 2 1984170992 44434736 12511600
20:49:11 17114 8192000000 10916620240 11349975040 1929412016 19.062 99 37 73 3 1981878656 39963152 12503488
20:49:36 3997 8192000000 10926017840 11355254784 1932742896 19.089 99 45 90 0 1991653040 43692096 15218048
20:49:49 8537 8192000000 10906572960 11344547840 1921328400 18.997 99 34 66 2 1976745888 43417824 11999664
20:50:05 22342 8192000000 10899154048 11344453632 1928207472 19.053 99 39 78 0 1979649056 38391472 13050112
20:50:34 27884 8192000000 10885354912 11339251712 1913994880 18.939 99 22 44 2 1954921696 33650496 7276320
20:51:08 53508 8192000000 10889367088 11344560128 1882105600 18.682 97 22 44 0 1925931520 36584896 7241024
20:52:08 27363 8192000000 10898707056 11348512768 1929678416 19.064 100 18 36 1 1977267056 40783024 6805616
20:52:42 29848 8192000000 10895920752 11353669632 1914456064 18.942 99 20 40 0 1961965616 40320304 7189248
20:54:23 49868 8192000000 10833446752 11275395072 1817637744 18.158 94 11 22 1 1833447296 12583760 3225792
20:55:19 48862 8192000000 10834859712 11285155840 1867972816 18.568 98 37 71 1 1886365904 7698768 10694320
20:56:14 33147 8192000000 10853051584 11285200896 1903379680 18.853 99 38 76 2 1923150816 9649120 10122016
20:56:57 102796 8192000000 10864915184 11313684480 1897112304 18.803 98 31 63 1 1916507104 10643312 8751488
20:58:47 92064 8192000000 10863566480 11318140928 1875273184 18.627 96 19 38 1 1890886992 10465792 5148016
21:00:25 69500 8192000000 10898113712 11348787200 1923589024 19.016 98 25 50 1 1949980576 19070896 7320656
21:01:46 150490 8192000000 10893792576 11341746176 1832241952 18.278 94 15 30 1 1845018912 8742192 4034768
21:04:22 24980 8192000000 10904667088 11357478912 1972281392 19.404 100 50 101 1 1995438736 9187504 13969840
21:05:04 60273 8192000000 10907105920 11370348544 1973588608 19.414 100 25 50 0 1992385584 11464912 7332064
21:06:29 107194 8192000000 10896336576 11378991104 1981047888 19.473 100 9 18 0 1992234768 8765952 2420928
21:08:26 31033 8192000000 10910849328 11383975936 1986942352 19.520 100 11 22 1 1996969520 6952432 3074736
21:09:05 50824 8192000000 10911684928 11380654080 1973686368 19.415 99 17 34 0 1987830864 9465008 4679488
21:10:03 54609 8192000000 10901905376 11384930304 1982608384 19.485 100 8 16 0 1997172000 12233584 2330032
21:11:03 60070 8192000000 10876242816 11363487744 1919968352 18.987 97 10 20 1 1939605184 16748304 2888528
21:12:10 46728 8192000000 10921725728 11379822592 1982156384 19.482 100 27 54 1 1998465776 8171552 8137840
21:13:04 39088 8192000000 10911708848 11370807296 1968975664 19.377 99 37 74 0 1990131424 10208608 10947152
21:13:50 24471 8192000000 10932931328 11392753664 1995308864 19.586 100 31 62 0 2015552448 11938480 8305104
21:14:34 49899 8192000000 10936842896 11405766656 1996162592 19.592 100 25 50 0 2017594816 14580560 6851664
21:15:31 63182 8192000000 10916425008 11405189120 1974374800 19.420 99 15 30 0 1992132752 13760432 3997520
21:16:40 74500 8192000000 10895816592 11370610688 1916388656 18.958 96 17 34 2 1933092800 12023168 4680976
21:18:01 43747 8192000000 10917626736 11374993408 1926308016 19.037 97 26 52 0 1942656608 8938416 7410176
21:19:12 57538 8192000000 10924515600 11396935680 1986630784 19.517 100 18 36 0 2013736304 22206224 4899296
21:20:28 83148 8192000000 10894795152 11370725376 1936566736 19.119 97 14 28 0 1957198848 16439920 4192192
21:21:58 64421 8192000000 10891165008 11359113216 1892685440 18.767 96 16 32 0 1911990368 14978096 4326832
21:23:35 14202 8192000000 10915329280 11363573760 1954023904 19.259 99 38 76 0 1974017728 9726800 10267024
21:23:59 24463 8192000000 10922374272 11375792128 1970126304 19.386 100 41 82 0 1994392416 12899840 11366272
21:24:33 131267 8192000000 10875322112 11340595200 1836530336 18.313 93 35 70 3 1857957088 11765712 9661040
21:26:52 89735 8192000000 10890186656 11365023744 1958035024 19.290 100 32 64 2 1986877200 19556176 9286000
21:28:28 37320 8192000000 10896883808 11366760448 1955666224 19.272 100 14 28 0 1977799232 18292256 3840752
21:29:26 46591 8192000000 10871111424 11362930688 1921560384 18.999 98 5 10 0 1937811568 15251568 999616
21:30:52 41665 8192000000 10850190992 11325468672 1893972816 18.778 97 9 18 0 1902894000 6500160 2421024
21:31:40 82243 8192000000 10874633488 11355553792 1934270704 19.101 99 14 28 1 1949547392 11406656 3870032
21:33:12 69369 8192000000 10898840432 11366248448 1925119888 19.028 98 13 26 0 1942431024 13888416 3422720
21:34:28 101453 8192000000 10906225600 11375849472 1903160320 18.852 96 21 42 0 1926053072 16827264 6065488
21:36:34 45169 8192000000 10870571008 11335852032 1849041488 18.414 94 20 40 0 1868500192 14199808 5258896
21:37:37 50345 8192000000 10866031216 11325575168 1905921808 18.874 99 40 79 1 1935525392 18434480 11169104
21:38:36 31008 8192000000 10858053760 11313672192 1863388128 18.531 97 34 68 1 1884811616 12286272 9137216
21:39:22 13573 8192000000 10872532912 11309441024 1920243088 18.989 100 40 80 0 1940434304 8979744 11211472
21:39:45 20176 8192000000 10866532624 11311181824 1905917552 18.874 99 39 78 1 1927404352 10869664 10617136
21:40:14 10349 8192000000 10886789472 11328450560 1930128112 19.068 100 38 76 1 1951140400 10832896 10179392
21:40:36 10301 8192000000 10870849536 11313954816 1880214320 18.667 97 39 78 0 1901616784 10769280 10633184
21:40:54 21453 8192000000 10877020688 11316219904 1900427936 18.830 99 53 105 1 1930854432 16236752 14189744
21:41:22 30811 8192000000 10875875968 11322007552 1897358464 18.805 98 44 88 1 1928129792 18642560 12128768
21:42:01 82777 8192000000 10848298848 11305783296 1806140560 18.064 94 12 24 0 1819033968 9771792 3121616
21:43:30 43567 8192000000 10838774768 11302879232 1863170400 18.529 97 32 64 5 1882424032 10259280 8994352
21:45:03 117603 8192000000 10860508208 11334144000 1882604384 18.686 98 13 26 0 1902665472 15693856 4367232
21:47:09 112213 8192000000 10853945376 11310559232 1873993792 18.617 97 16 32 1 1893838448 15470464 4374192
21:49:20 48598 8192000000 10854644704 11330347008 1927017056 19.043 100 17 34 1 1948459760 16622896 4819808
21:50:17 7548 8192000000 10858923376 11334938624 1928940640 19.058 100 10 20 1 1948946464 17244928 2760896
21:50:40 60689 8192000000 10838422384 11309117440 1915410528 18.950 99 14 27 1 1926323328 6460528 4452272
21:51:54 41452 8192000000 10860186624 11328778240 1943099840 19.171 100 9 17 0 1953114960 7848864 2166256
21:52:42 63293 8192000000 10882049904 11351244800 1956461024 19.278 100 16 32 0 1969821712 8520272 4840416
21:53:56 59334 8192000000 10883995024 11360063488 1946250240 19.197 99 9 18 0 1958908848 9845984 2812624
21:55:58 33822 8192000000 10894548768 11362365440 1968578864 19.374 100 16 33 0 1982476064 9088992 4808208
21:57:11 83835 8192000000 10875577072 11350601728 1910919120 18.914 97 15 30 1 1924391376 9398448 4073808
21:58:48 42538 8192000000 10877636208 11345915904 1911298384 18.917 97 16 30 1 1923646384 8256688 4091312
21:59:41 71207 8192000000 10913694784 11375562752 1934224656 19.101 98 20 40 0 1952291664 12511104 5555904
22:01:00 68050 8192000000 10919320016 11375767552 1955445824 19.270 99 15 28 1 1970487392 11067776 3973792
22:02:19 70706 8192000000 10909148656 11378061312 1963887104 19.337 99 23 46 1 1980151040 9727056 6536880
22:03:40 85966 8192000000 10899816768 11362205696 1923115360 19.012 97 9 18 0 1936786624 11144272 2526992
22:05:12 31767 8192000000 10930099424 11378561024 1967574720 19.366 99 37 74 1 1986681808 9003088 10104000
22:05:53 28554 8192000000 10895736512 11355131904 1892524560 18.766 95 31 62 0 1911272432 10472496 8275376
22:06:34 52634 8192000000 10889871408 11347316736 1890267488 18.748 96 30 60 1 1907854464 9344816 8242160
22:07:39 71896 8192000000 10921988544 11382198272 1961442448 19.318 99 17 33 2 1975921952 9587680 4891824
22:09:03 33262 8192000000 10934128256 11389710336 1974153456 19.418 99 29 58 1 1990210240 8174016 7882768
22:09:43 27459 8192000000 10911718640 11373891584 1932677664 19.088 97 30 60 0 1954565504 13308016 8579824
22:10:17 113271 8192000000 10909959440 11367993344 1870643504 18.589 94 26 52 0 1891026384 13598992 6783888
22:12:51 99693 8192000000 10876974160 11341266944 1927084544 19.044 98 15 30 0 1944023536 12550336 4388656
22:14:38 64327 8192000000 10875055152 11349053440 1924519392 19.023 98 15 30 0 1938420400 9838592 4062416
22:15:52 1586 8192000000 10898923824 11357523968 1961311408 19.316 100 40 80 0 1982826160 10584368 10930384
22:16:00 22472 8192000000 10874201152 11341815808 1924894112 19.026 98 34 68 1 1945902928 11700464 9308352
22:16:38 56263 8192000000 10856253152 11340525568 1922963776 19.011 99 5 10 0 1933080064 8719136 1397152
22:17:42 46018 8192000000 10853676144 11326799872 1896000128 18.794 97 9 18 0 1906299248 8304272 1994848
22:18:34 34909 8192000000 10859316256 11330441216 1910155840 18.908 98 10 20 1 1921168160 8020880 2991440
22:19:30 77862 8192000000 10884331648 11353239552 1954440752 19.262 100 20 40 0 1973926432 13599856 5885824
22:22:07 65725 8192000000 10848796416 11328020480 1889176992 18.739 97 18 36 0 1913260016 18474944 5608080
22:23:21 19324 8192000000 10867076528 11331792896 1927095536 19.044 99 24 48 0 1940681696 6715024 6871136
22:23:47 46976 8192000000 10884849280 11337609216 1878137984 18.650 96 18 36 3 1894310720 10788288 5384448
22:24:41 24559 8192000000 10887642960 11330592768 1909966416 18.906 98 32 63 2 1929690896 10810512 8913968
22:25:13 42822 8192000000 10863055344 11321131008 1879489296 18.661 97 39 77 2 1904828992 14308720 11030976
22:26:12 57005 8192000000 9032686208 9264607232 190546672 2.273 11 1 2 0 192162816 1554016 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-11-2020 22:28:18 to 27-11-2020 22:28:49.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-11-2020 22:28:50 to 27-11-2020 22:28:52.

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          250819
MON$OLDEST_ACTIVE               250820
MON$OLDEST_SNAPSHOT             250820
MON$NEXT_TRANSACTION            250820
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                       2014720
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Fri Nov 27 22:27:11 2020
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Fri Nov 27 22:27:11 2020
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
--- end of diff output ---

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

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