Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.12.2020 01: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 17667136 kB
MemAvailable 31540708 kB
Buffers 0 kB
Cached 14014700 kB
SwapCached 3708 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-12-12 01:27:06
DTS_END                         2020-12-12 01:27:06.3870
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35342
TRN_ID                          243954
ATT_ID                          691
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: 9443.42 22477 1133211
customer order: creation 170.73 333 20487
customer order: refuse 14.63 280 1755
order to supplier: creation 44.21 1181 5305
order to supplier: removal 3.70 73126 444
invoice (draft): creation 46.35 3097 5562
invoice (draft): removal 54.88 604 6586
invoice accept: apply 42.63 15524 5116
invoice accept: cancel 49.87 682 5984
customer reserve: creation 3894.30 156 467316
customer reserve: removal 4820.58 44 578469
realization accept: apply 84.68 184 10161
realization accept: cancel 87.30 91 10476
payment from customer: creation 59.38 108 7126
payment from customer: removal 6.32 58 758
payment to supplier: creation 47.86 138 5743
payment to supplier: removal 3.53 68 423
service: total inventory turnovers 4.78 1120 574
service: total monetary turnovers 6.73 20 807
service: aggregate perf. data 0.96 18059 115
service: refresh index statistics 0.03 334671 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-12-2020 01:28:28 to 12-12-2020 01:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8365
TEST_TIME 2 7972
TEST_TIME 3 7181
TEST_TIME 4 7579
TEST_TIME 5 7068
TEST_TIME 6 6638
TEST_TIME 7 6708
TEST_TIME 8 8135
TEST_TIME 9 7981
TEST_TIME 10 8472
TEST_TIME 11 8686
TEST_TIME 12 9449
TEST_TIME 13 9700
TEST_TIME 14 10264
TEST_TIME 15 10597
TEST_TIME 16 10663
TEST_TIME 17 10799
TEST_TIME 18 11398
TEST_TIME 19 11771
TEST_TIME 20 12220
TEST_TIME 21 11932
TEST_TIME 22 12045
TEST_TIME 23 11774
TEST_TIME 24 11596
TEST_TIME 25 11427
TEST_TIME 26 11144
TEST_TIME 27 10870
TEST_TIME 28 10876
TEST_TIME 29 10699
TEST_TIME 30 10562
TEST_TIME 31 10571
TEST_TIME 32 10416
TEST_TIME 33 10451
TEST_TIME 34 10210
TEST_TIME 35 10392
TEST_TIME 36 10238
TEST_TIME 37 10569
TEST_TIME 38 10357
TEST_TIME 39 10322
TEST_TIME 40 10198
TEST_TIME 41 10122
TEST_TIME 42 10053
TEST_TIME 43 10171
TEST_TIME 44 10079
TEST_TIME 45 10037
TEST_TIME 46 9994
TEST_TIME 47 9976
TEST_TIME 48 10091
TEST_TIME 49 10062
TEST_TIME 50 10079
TEST_TIME 51 10106
TEST_TIME 52 10142
TEST_TIME 53 10198
TEST_TIME 54 10225
TEST_TIME 55 10152
TEST_TIME 56 9995
TEST_TIME 57 9925
TEST_TIME 58 9820
TEST_TIME 59 9811
TEST_TIME 60 9840
TEST_TIME 61 9831
TEST_TIME 62 9771
TEST_TIME 63 9690
TEST_TIME 64 9662
TEST_TIME 65 9639
TEST_TIME 66 9665
TEST_TIME 67 9671
TEST_TIME 68 9737
TEST_TIME 69 9729
TEST_TIME 70 9830
TEST_TIME 71 9818
TEST_TIME 72 9786
TEST_TIME 73 9813
TEST_TIME 74 9929
TEST_TIME 75 9877
TEST_TIME 76 9817
TEST_TIME 77 9972
TEST_TIME 78 9951
TEST_TIME 79 9981
TEST_TIME 80 9922
TEST_TIME 81 9821
TEST_TIME 82 9781
TEST_TIME 83 9709
TEST_TIME 84 9732
TEST_TIME 85 9675
TEST_TIME 86 9648
TEST_TIME 87 9596
TEST_TIME 88 9572
TEST_TIME 89 9542
TEST_TIME 90 9593
TEST_TIME 91 9551
TEST_TIME 92 9691
TEST_TIME 93 9677
TEST_TIME 94 9700
TEST_TIME 95 9707
TEST_TIME 96 9735
TEST_TIME 97 9697
TEST_TIME 98 9699
TEST_TIME 99 9801
TEST_TIME 100 9768
TEST_TIME 101 9740
TEST_TIME 102 9812
TEST_TIME 103 9830
TEST_TIME 104 9763
TEST_TIME 105 9734
TEST_TIME 106 9726
TEST_TIME 107 9680
TEST_TIME 108 9656
TEST_TIME 109 9616
TEST_TIME 110 9603
TEST_TIME 111 9572
TEST_TIME 112 9582
TEST_TIME 113 9531
TEST_TIME 114 9542
TEST_TIME 115 9522
TEST_TIME 116 9493
TEST_TIME 117 9499
TEST_TIME 118 9478
TEST_TIME 119 9519
TEST_TIME 120 9445

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-12-2020 01:28:31 to 12-12-2020 01:28:35.

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 1566550 1566550 0 0.00 0 22195 5 0 0
doc_list_biud 1566548 1566548 0 0.00 0 58899 21 0 0
sp_add_invoice_to_stock 5228 5116 112 2.14 29 160256 15524 0 112
sp_cancel_adding_invoice 5984 5984 0 0.00 4 36574 682 0 0
sp_cancel_client_order 1755 1755 0 0.00 3 12469 280 0 0
sp_cancel_customer_reserve 578469 578469 0 0.00 1 36109 44 0 0
sp_cancel_pay_from_customer 758 758 0 0.00 3 4556 59 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 6487 68 0 0
sp_cancel_supplier_invoice 6597 6586 11 0.16 2 60677 605 0 11
sp_cancel_supplier_order 444 444 0 0.00 6 759903 73127 0 0
sp_cancel_write_off 10476 10476 0 0.00 1 7484 92 0 0
sp_client_order 20487 20487 0 0.00 4 26171 334 0 0
sp_customer_reserve 467316 467316 0 0.00 0 42164 157 0 0
sp_fill_shopping_cart 31341 31341 0 0.00 1 15203 36 0 0
sp_fill_shopping_cart_clo_res 467305 467305 0 0.00 0 14130 12 0 0
sp_get_clo_for_invoice 5105 5105 0 0.00 0 26153 268 0 0
sp_kill_cost_storno 17641 17641 0 0.00 0 8252 40 0 0
sp_kill_qstorno_ret_qs2qd 1174444 1174444 0 0.00 0 58897 24 0 0
sp_kill_qty_storno 618980 618980 0 0.00 0 58898 53 0 0
sp_lock_selected_doc 21184 21184 0 0.00 0 10299 6 0 0
sp_make_cost_storno 28135 28135 0 0.00 0 22187 54 0 0
sp_multiply_rows_for_pdistr 28135 28135 0 0.00 0 8561 24 0 0
sp_multiply_rows_for_qdistr 20487 20487 0 0.00 0 26157 137 0 0
sp_pay_from_customer 7126 7126 0 0.00 4 46857 109 0 0
sp_pay_to_supplier 5743 5743 0 0.00 5 15642 138 0 0
sp_payment_common 12869 12869 0 0.00 2 46852 40 0 0
sp_qd_handle_on_cancel_clo 1755 1755 0 0.00 0 12461 247 0 0
sp_qd_handle_on_invoice_upd_sts 11089 11089 0 0.00 0 32803 296 0 0
sp_qd_handle_on_reserve_upd_sts 10161 10161 0 0.00 0 17367 64 0 0
sp_reserve_write_off 10161 10161 0 0.00 6 17416 184 0 0
sp_supplier_invoice 5562 5562 0 0.00 7 69945 3097 0 0
sp_supplier_order 5305 5305 0 0.00 5 45403 1182 0 0
srv_aggregate_perf_data 115 115 0 0.00 2740 226863 18059 0 0
srv_fill_mon_cache_memory 143 143 0 0.00 1422 140606 37551 0 0
srv_find_qd_qs_mism 1085748 1085748 0 0.00 0 16775 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 38 85514 1120 0 0
srv_make_money_saldo 807 807 0 0.00 0 1029 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 115852 502075 334672 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5116 5116 0 0.00 0 27571 166 0 0
t$perf-norm:sp_cancel_adding_invoice 452 452 0 0.00 0 12476 94 0 0
t$perf-norm:sp_cancel_client_order 1755 1755 0 0.00 0 5321 12 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 2808 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 758 758 0 0.00 0 4345 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 2851 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 364 8 0 0
t$perf-norm:sp_cancel_supplier_order 444 444 0 0.00 0 42718 1292 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 1167 4 0 0
t$perf-norm:sp_client_order 20487 20487 0 0.00 0 16807 17 0 0
t$perf-norm:sp_customer_reserve 967 967 0 0.00 0 7563 20 0 0
t$perf-norm:sp_pay_from_customer 7126 7126 0 0.00 0 3845 8 0 0
t$perf-norm:sp_pay_to_supplier 5743 5743 0 0.00 0 5506 14 0 0
t$perf-norm:sp_reserve_write_off 10161 10161 0 0.00 0 8993 14 0 0
t$perf-norm:sp_supplier_invoice 5562 5562 0 0.00 0 5175 19 0 0
t$perf-norm:sp_supplier_order 5305 5305 0 0.00 0 4281 15 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 170 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 143 143 0 0.00 0 3437 27 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 312 8 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 1692 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10430 10206 224 2.14 0 8448 17 0 224
v_all_customers 37686 37686 0 0.00 0 34 0 0 0
v_all_suppliers 29964 29964 0 0.00 0 17 1 0 0
v_all_wares 40972 40972 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 904 904 0 0.00 0 973 6 0 0
v_cancel_client_order 3510 3510 0 0.00 0 6880 9 0 0
v_cancel_customer_prepayment 1516 1516 0 0.00 0 1685 6 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 4886 10 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 6482 18 0 0
v_cancel_supplier_invoice 818 796 22 2.68 0 1637 18 0 22
v_cancel_supplier_order 888 888 0 0.00 0 1750 7 0 0
v_cancel_write_off 2046 2046 0 0.00 0 3591 18 0 0
v_max_id_clo_ord 5305 5305 0 0.00 0 421 1 0 0
v_max_id_clo_res 967 967 0 0.00 0 1961 6 0 0
v_max_id_ord_sup 5550 5550 0 0.00 0 2571 5 0 0
v_max_non_paid_invoice 1616 1616 0 0.00 0 2267 6 0 0
v_max_non_paid_realizn 3745 3745 0 0.00 0 4214 5 0 0
v_min_id_clo_ord 5305 5305 0 0.00 0 2159 5 0 0
v_min_id_clo_res 967 967 0 0.00 0 3986 17 0 0
v_min_id_ord_sup 5550 5550 0 0.00 0 3654 3 0 0
v_min_non_paid_invoice 5743 5743 0 0.00 0 6721 23 0 0
v_min_non_paid_realizn 7126 7126 0 0.00 0 46849 29 0 0
v_our_firm 10048 10048 0 0.00 0 15 1 0 0
v_reserve_write_off 20322 20322 0 0.00 0 9853 9 0 0
x_lock_depdocs_on_canc_invoice 12172 12172 0 0.00 0 23720 95 0 0
x_lock_depdocs_on_canc_sup_ord 444 444 0 0.00 0 2094 226 0 0
x_make_qstorno_1000_1200 5305 5305 0 0.00 2 45395 1117 0 0
x_make_qstorno_1200_2000 5562 5562 0 0.00 3 69442 2968 0 0
x_make_qstorno_2100_3300 467316 467316 0 0.00 0 42163 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-12-2020 01:28:36 to 12-12-2020 01:28:40.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:16 21494 8192000000 10245485056 10561581056 1039694192 11.262 82 62 127 0 1062672880 2728976 20249712
22:57:49 29588 8192000000 10338675984 10656317440 1385332544 14.464 100 79 158 0 1416398816 5020256 26046016
22:58:26 20881 8192000000 10370343152 10692169728 1427969392 14.843 100 88 176 0 1463954288 6381920 29602976
22:58:57 19036 8192000000 10405864720 10728308736 1457004832 15.100 100 92 184 0 1494531584 7323296 30203456
22:59:25 15542 8192000000 10408119072 10739965952 1470170048 15.215 100 84 168 1 1505587744 8036208 27381488
22:59:53 17201 8192000000 10446058832 10776768512 1499140208 15.469 100 92 184 0 1537103312 8396416 29566688
23:00:21 18463 8192000000 10458387248 10793984000 1513052512 15.590 100 88 176 0 1550285776 8961312 28271952
23:00:50 13959 8192000000 10472594960 10812710912 1530959120 15.745 100 82 164 0 1566370528 9310272 26101136
23:01:15 12248 8192000000 10504965136 10851258368 1562181312 16.015 100 81 163 0 1596812240 9435440 25195488
23:01:36 15137 8192000000 10523159328 10873012224 1580153904 16.169 100 81 162 0 1615146576 10206624 24786048
23:02:00 17863 8192000000 10554731808 10907770880 1604409392 16.377 100 84 168 0 1640794848 10653456 25732000
23:02:26 10719 8192000000 10560236304 10920095744 1618424224 16.496 100 74 148 0 1651504352 11008480 22071648
23:02:45 11457 8192000000 10590044096 10945359872 1641599536 16.693 100 82 165 2 1678019232 12027456 24392240
23:03:04 11123 8192000000 10597160256 10957393920 1655870480 16.814 100 85 170 0 1693942320 12935728 25136112
23:03:25 9255 8192000000 10612042544 10979135488 1679060256 17.009 100 83 166 2 1716220080 13701904 23457920
23:03:42 8423 8192000000 10647203904 11015196672 1700192080 17.187 100 83 167 1 1737823904 13790832 23840992
23:04:01 9193 8192000000 10659326848 11033075712 1720536144 17.357 100 80 159 0 1756670176 13758928 22375104
23:04:18 6067 8192000000 10672663712 11045052416 1733890208 17.468 100 89 178 3 1773125024 14043568 25191248
23:04:30 5268 8192000000 10680966368 11055251456 1742827216 17.542 100 79 158 0 1777903808 12773472 22303120
23:04:44 4391 8192000000 10683096624 11064856576 1753632016 17.632 100 72 145 1 1786433904 12247104 20554784
23:04:55 4199 8192000000 10703164608 11085246464 1765710768 17.732 100 76 150 2 1798888624 12298048 20879808
23:05:08 2543 8192000000 10712720864 11096236032 1777041408 17.825 100 74 148 0 1810457664 12925104 20491152
23:05:17 2936 8192000000 10727951152 11107561472 1793372368 17.959 100 84 169 2 1830722112 14029968 23319776
23:05:27 4561 8192000000 10735604160 11122233344 1796186736 17.983 100 86 170 1 1834727120 14599616 23940768
23:05:39 3442 8192000000 10742955648 11126042624 1804351824 18.050 100 73 143 2 1837058976 13353648 19353504
23:05:50 1838 8192000000 10754079472 11138138112 1815766816 18.143 100 80 160 2 1853653984 14118096 23769072
23:05:58 2184 8192000000 10760581328 11147739136 1820616640 18.183 100 80 158 0 1857238080 13538736 23082704
23:06:07 1704 8192000000 10772231312 11155693568 1828630928 18.248 100 89 178 2 1867011392 13329776 25050688
23:06:15 2355 8192000000 10771594928 11157569536 1834311408 18.294 100 90 176 0 1873247600 14031664 24904528
23:06:23 1797 8192000000 10781314432 11167019008 1842783952 18.363 100 90 180 1 1882095584 14091984 25219648
23:06:32 1904 8192000000 10789868896 11179708416 1848970816 18.414 100 87 172 1 1885915632 13449008 23495808
23:06:40 1432 8192000000 10799894336 11187937280 1860656096 18.509 100 95 191 0 1898838864 12013088 26169680
23:06:47 1250 8192000000 10807787328 11195711488 1862659824 18.525 100 99 200 2 1904339488 13520656 28159008
23:06:55 1844 8192000000 10806973136 11198058496 1865877008 18.551 100 92 184 0 1905685776 13349920 26458848
23:07:03 1482 8192000000 10812326112 11202355200 1868804272 18.575 100 92 185 0 1907341680 12814864 25722544
23:07:11 21342 8192000000 10794603168 11198353408 1866566688 18.556 100 61 122 4 1896390416 13344352 16479376
23:07:39 8424 8192000000 10796885360 11201503232 1871140208 18.593 100 57 113 1 1894215552 7052032 16023312
23:07:53 22602 8192000000 10770389408 11205238784 1871920160 18.600 100 43 87 0 1893301728 9343472 12038096
23:08:23 8291 8192000000 10783285168 11206561792 1872657840 18.606 100 27 54 0 1886126752 6052528 7416384
23:08:37 4211 8192000000 10794602144 11215949824 1879585504 18.662 100 39 76 2 1898439232 7644400 11209328
23:08:48 5062 8192000000 10787752848 11213705216 1881379584 18.676 100 30 59 3 1895805312 5928672 8497056
23:09:03 5977 8192000000 10798846656 11222581248 1883527872 18.694 100 30 60 0 1899792272 8004976 8259424
23:09:19 4422 8192000000 10794224912 11222003712 1885490320 18.709 100 31 62 1 1902464336 8184768 8789248
23:09:33 6147 8192000000 10794830944 11227090944 1886741408 18.720 100 20 41 3 1898475344 6077232 5656704
23:09:49 9557 8192000000 10795748240 11229413376 1890416208 18.749 100 32 63 1 1907135296 7723408 8995680
23:10:04 13214 8192000000 10800204240 11232247808 1890185584 18.747 100 15 30 0 1904259376 9735104 4338688
23:10:24 10409 8192000000 10801360960 11233615872 1890993312 18.754 100 9 18 1 1899770112 5678048 3098752
23:10:43 5350 8192000000 10814105168 11242102784 1900065360 18.827 100 28 56 2 1914440752 6274144 8101248
23:10:56 6290 8192000000 10803070112 11240996864 1899638848 18.823 100 19 38 1 1911112864 6326656 5147360
23:11:08 5526 8192000000 10819685808 11243302912 1901085424 18.835 100 25 48 1 1914950736 6979648 6885664
23:11:20 6886 8192000000 10813300192 11245957120 1902475648 18.846 100 25 51 0 1916853792 6588576 7789568
23:11:33 7248 8192000000 10808679728 11245510656 1902734688 18.848 100 15 30 0 1912725280 6015568 3975024
23:11:49 17486 8192000000 10819104512 11248414720 1902282464 18.845 100 18 35 1 1912448352 5594912 4570976
23:12:13 54374 8192000000 10856124976 11260276736 1912866544 18.930 100 68 140 4 1938550896 5070144 20614208
23:13:13 6671 8192000000 10821799024 11254849536 1906479920 18.878 100 23 46 0 1919416672 6365360 6571392
23:13:27 6211 8192000000 10823885296 11253837824 1907338928 18.885 100 21 42 1 1919135744 5093920 6702896
23:13:40 4574 8192000000 10824780064 11257262080 1908537056 18.895 100 27 54 1 1923379552 7097792 7744704
23:13:52 5475 8192000000 10828936480 11260035072 1912057456 18.923 100 39 78 0 1930910256 7324944 11527856
23:14:03 9937 8192000000 10824701744 11259252736 1915601680 18.952 100 32 65 5 1931839344 6862768 9374896
23:14:21 6248 8192000000 10827303088 11257339904 1897771248 18.808 99 45 90 0 1918451216 7814064 12865904
23:14:38 4590 8192000000 10835742160 11264598016 1912670832 18.928 100 36 73 2 1930223984 7072976 10480176
23:14:51 7199 8192000000 10829035520 11266129920 1914594016 18.944 100 35 71 3 1934696752 10149392 9953344
23:15:07 8177 8192000000 10819725904 11244339200 1886464720 18.717 99 19 37 1 1896868112 5395136 5008256
23:15:22 7192 8192000000 10789926592 11222138880 1841511904 18.353 97 26 52 2 1854616624 5234672 7870048
23:15:37 9137 8192000000 10795704400 11223257088 1853444912 18.450 98 22 43 0 1865623984 5889904 6289168
23:15:53 8304 8192000000 10791590416 11217555456 1847016400 18.398 98 29 54 1 1860559216 5451312 8091504
23:16:07 13542 8192000000 10778777504 11214356480 1844501872 18.377 98 18 36 1 1855368336 5919712 4946752
23:16:27 60323 8192000000 10774247312 11197325312 1769511456 17.763 94 31 61 1 1784306384 4853952 9940976
23:17:36 9658 8192000000 10744711616 11172737024 1764731088 17.724 95 23 46 0 1777275552 5913824 6630640
23:17:52 7405 8192000000 10719670560 11138981888 1762954800 17.709 97 25 50 1 1775984960 6138720 6891440
23:18:06 4841 8192000000 10720616384 11132379136 1750979552 17.610 97 37 74 2 1768678032 7422848 10275632
23:18:19 7485 8192000000 10720653936 11134431232 1745075968 17.561 96 39 77 2 1764235360 7868928 11290464
23:18:33 3868 8192000000 10712546096 11130355712 1782072528 17.867 99 31 61 2 1798743040 7113696 9556816
23:18:43 7333 8192000000 10734498464 11147018240 1811233280 18.106 100 29 58 1 1825953296 6602064 8117952
23:18:58 8217 8192000000 10707935968 11122409472 1760491664 17.688 97 31 62 1 1775587184 5499520 9596000
23:19:12 6385 8192000000 10691878864 11102273536 1755391072 17.646 97 26 52 2 1768310976 5220944 7698960
23:19:26 4460 8192000000 10710750368 11130068992 1800485568 18.018 100 27 54 2 1815130736 7161744 7483424
23:19:36 5126 8192000000 10695448384 11107291136 1768328496 17.753 99 48 96 0 1790435440 7781872 14325072
23:19:49 6177 8192000000 10710619728 11126788096 1792337088 17.951 100 27 54 3 1807737632 7534032 7866512
23:20:03 6951 8192000000 10720588624 11126050816 1741924064 17.535 96 34 67 3 1761783376 9301280 10558032
23:20:19 8731 8192000000 10718842640 11127500800 1749259264 17.595 97 23 46 1 1761662928 5752272 6651392
23:20:34 8236 8192000000 10707735888 11125469184 1780453120 17.853 99 23 45 1 1792070912 5123648 6494144
23:20:49 6853 8192000000 10726735632 11139182592 1793935280 17.964 99 26 53 1 1807421216 5435888 8050048
23:21:03 54817 8192000000 10741711888 11147350016 1783785712 17.881 98 34 67 2 1807745568 13474432 10485424
23:22:10 9731 8192000000 10735300704 11154690048 1821956544 18.194 100 23 46 1 1835141552 6444336 6740672
23:22:26 4659 8192000000 10741962912 11160961024 1826970768 18.235 100 37 74 1 1844103696 6378864 10754064
23:22:38 8599 8192000000 10757753328 11176280064 1835415632 18.303 100 25 50 0 1848468176 6288368 6764176
23:22:57 6867 8192000000 10769826912 11189215232 1844800112 18.380 100 29 56 1 1859087184 6498800 7788272
23:23:10 3780 8192000000 10778779312 11190571008 1849437376 18.418 100 32 65 3 1864651936 6277600 8936960
23:23:24 9206 8192000000 10755203600 11190255616 1850955424 18.430 100 32 63 2 1870857424 10333600 9568400
23:23:39 5267 8192000000 10781884800 11205234688 1858823456 18.494 100 37 72 1 1876724144 6817616 11083072
23:23:52 3757 8192000000 10786595552 11206320128 1865919760 18.551 100 26 52 1 1878810976 5430896 7460320
23:24:03 5627 8192000000 10782207472 11208302592 1867760032 18.566 100 31 61 0 1882466160 5776128 8930000
23:24:17 6559 8192000000 10789904160 11215556608 1876501584 18.637 100 22 43 2 1888473568 5569760 6402224
23:24:30 7334 8192000000 10786115664 11211591680 1872043984 18.601 100 19 38 1 1882877312 5399808 5433520
23:24:46 6318 8192000000 10801880944 11220738048 1875355744 18.628 100 26 52 0 1888169536 4929808 7883984
23:25:04 9838 8192000000 10788988944 11220049920 1876238640 18.635 100 23 46 3 1888494128 5805408 6450080
23:25:22 72504 8192000000 10801883696 11225415680 1876832528 18.640 100 27 52 2 1890061344 5042192 8186624
23:26:42 11001 8192000000 10784436704 11218595840 1879392224 18.660 100 23 46 1 1891983312 6467776 6123312
23:26:59 8382 8192000000 10812940048 11235860480 1888707984 18.735 100 21 40 3 1899389008 4582992 6098032
23:27:19 31234 8192000000 10842592592 11264454656 1913620624 18.936 100 47 95 1 1933573328 6774448 13178256
23:28:04 5005 8192000000 10866683296 11281281024 1930013856 19.067 100 55 110 2 1956351760 11426496 14911408
23:28:18 7188 8192000000 10862641392 11282259968 1927874352 19.050 100 53 105 1 1954569504 12336272 14358880
23:28:36 8741 8192000000 10881616256 11299647488 1943256368 19.173 100 61 120 1 1973526832 13153328 17117136
23:28:53 9394 8192000000 10876922448 11293523968 1929884240 19.066 99 61 123 2 1962038960 14089360 18065360
23:29:12 11474 8192000000 10889130752 11306262528 1947464848 19.206 100 60 120 0 1979104480 14184448 17455184
23:29:32 10547 8192000000 10887832672 11310784512 1948251088 19.213 100 50 99 1 1976546576 13460672 14834816
23:29:54 25582 8192000000 10887651792 11318607872 1952595008 19.247 100 49 98 0 1981591184 13631392 15364784
23:30:26 21683 8192000000 10870256912 11302035456 1917309632 18.965 98 46 92 1 1947487872 15722384 14455856
23:31:00 7790 8192000000 10916802384 11329216512 1964053008 19.338 100 73 146 2 2002368672 16749040 21566624
23:31:14 52071 8192000000 10880545216 11328827392 1942833104 19.169 99 38 76 1 1973882032 19401728 11647200
23:32:30 20860 8192000000 10900204352 11340877824 1966168256 19.355 100 23 46 0 1992538928 18423920 7946752
23:33:02 25317 8192000000 10910815056 11351425024 1974286640 19.419 100 42 84 1 2008081280 20268448 13526192
23:33:35 18152 8192000000 10911318112 11349815296 1961097072 19.315 99 44 87 1 1995535648 20541088 13897488
23:34:00 7472 8192000000 10926513056 11356868608 1981984768 19.480 100 49 95 2 2018956768 22194240 14777760
23:34:17 6468 8192000000 10927535824 11359789056 1980962000 19.472 100 53 106 1 2019317888 21514896 16840992
23:34:30 4619 8192000000 10891885168 11319447552 1945359568 19.190 99 61 122 1 1987397616 23772304 18265744
23:34:42 3117 8192000000 10919534848 11343917056 1964946800 19.345 100 60 118 0 2007357584 24966352 17444432
23:34:53 5426 8192000000 10926083840 11350020096 1972116032 19.402 100 72 144 1 2022259136 28451568 21691536
23:35:13 1421 8192000000 10944165152 11356237824 1978593888 19.454 100 73 146 1 2026664896 25971328 22099680
23:35:21 5031 8192000000 10948429968 11362328576 1979889328 19.464 100 73 146 0 2028866816 27545488 21432000
23:35:32 3254 8192000000 10947684704 11370242048 1989690832 19.541 100 72 145 1 2037688240 26831856 21165552
23:35:42 1729 8192000000 10958677984 11369529344 1988873312 19.535 100 87 172 1 2041899904 27687120 25339472
23:35:51 1951 8192000000 10959965856 11370606592 1990075696 19.544 100 85 169 1 2041839520 26881968 24881856
23:35:59 7078 8192000000 10957622048 11382042624 1996345040 19.594 100 76 151 1 2045769168 26906512 22517616
23:36:16 4800 8192000000 10951621328 11380731904 1993845728 19.574 100 69 138 2 2042087936 27805568 20436640
23:36:29 5714 8192000000 10937589536 11361107968 1979310064 19.459 100 66 131 1 2026540976 28343584 18887328
23:36:44 11574 8192000000 10959129648 11378376704 1974609344 19.422 99 71 142 1 2029042192 33330976 21101872
23:37:09 3625 8192000000 10961221760 11393204224 1995199904 19.585 100 60 120 0 2050608272 37084768 18323600
23:37:21 3294 8192000000 10980631840 11400007680 2007585232 19.683 100 78 153 1 2064767600 34194800 22987568
23:37:31 2100 8192000000 10957815408 11381174272 1998783856 19.613 100 74 148 0 2054161904 32699072 22678976
23:37:42 1760 8192000000 10941683888 11352416256 1965640944 19.351 99 82 165 1 2023946528 32652880 25652704
23:37:50 2189 8192000000 10949909152 11355410432 1969130320 19.379 100 85 172 0 2029394576 33455456 26808800
23:37:59 3549 8192000000 10955648032 11367661568 1977428000 19.444 100 84 168 0 2039153984 35974992 25750992
23:38:10 3551 8192000000 10960593232 11376054272 1977023616 19.441 100 81 162 1 2041261360 39429952 24807792
23:38:20 3025 8192000000 10957976784 11370409984 1979122352 19.458 100 88 176 1 2045956704 39522432 27311920
23:38:30 2137 8192000000 10958351424 11371216896 1978230992 19.451 100 80 160 0 2043704400 40826848 24646560
23:38:41 2264 8192000000 10933735904 11345448960 1942003328 19.163 99 77 153 1 2006758448 41078304 23676816
23:38:52 1988 8192000000 10946673568 11359342592 1949308864 19.221 99 79 153 2 2012837600 39132688 24396048
23:39:00 2722 8192000000 10955009904 11362525184 1961497360 19.318 100 83 164 2 2026968944 40317360 25154224
23:39:10 1658 8192000000 10942013008 11355049984 1965546816 19.350 100 85 169 0 2030431568 39191776 25692976
23:39:19 3313 8192000000 10943698784 11367784448 1970408192 19.389 100 70 139 1 2028930544 37438416 21083936
23:39:38 10631 8192000000 10921738496 11352997888 1956537968 19.279 100 36 70 0 2002043168 33626640 11878560
23:39:55 1819 8192000000 10926379536 11344990208 1944382544 19.182 99 81 163 3 2005712688 35936160 25393984
23:40:05 4993 8192000000 10908850064 11334598656 1927472080 19.047 99 57 113 1 1981554880 36503888 17578912
23:40:17 4354 8192000000 10910050272 11338612736 1942237104 19.165 100 57 114 2 1999743456 39240800 18265552
23:40:30 10348 8192000000 10902758688 11330953216 1903725808 18.856 97 45 89 3 1952941456 35174064 14041584
23:40:49 6143 8192000000 10886133888 11305308160 1908171584 18.892 98 46 92 0 1960607408 37296000 15139824
23:41:04 11789 8192000000 10905335488 11345321984 1942808288 19.169 100 38 76 2 1992460576 37046848 12605440
23:41:26 23738 8192000000 10885416576 11328438272 1913679504 18.936 99 34 68 0 1961359232 36481600 11198128
23:41:57 8059 8192000000 10890621248 11329941504 1940437136 19.150 100 31 60 0 1982505792 32140000 9928656
23:42:11 9286 8192000000 10872350032 11312353280 1908881072 18.898 99 31 60 1 1949956720 31391424 9684224
23:42:27 7945 8192000000 10864641552 11302588416 1885725856 18.711 98 33 65 0 1930260736 33333152 11201728
23:42:50 16305 8192000000 10835635376 11270582272 1875093408 18.625 98 27 54 2 1909303728 25845760 8364560
23:43:13 16138 8192000000 10850198624 11284721664 1899376256 18.821 100 24 48 1 1935555280 28084672 8094352
23:43:35 16341 8192000000 10842421456 11275833344 1850769024 18.428 97 27 54 0 1895655392 35618640 9267728
23:43:58 40667 8192000000 10840663120 11279876096 1847116144 18.399 97 24 48 1 1890615040 35764704 7734192
23:44:45 12656 8192000000 10859191712 11292700672 1893863168 18.777 100 26 52 1 1936666016 34233008 8569840
23:45:04 19646 8192000000 10861293632 11301052416 1851593840 18.435 97 22 44 0 1893562672 34822320 7146512
23:46:06 38665 8192000000 10867129808 11317485568 1923908352 19.018 100 18 36 4 1957035248 26942400 6184496
23:46:57 33532 8192000000 10866812128 11307749376 1902646480 18.848 99 14 28 0 1929052656 21495328 4910848
23:47:41 17752 8192000000 10864858336 11329417216 1931889152 19.082 100 32 64 0 1958266480 16930128 9447200
23:48:10 50708 8192000000 10858239024 11320082432 1915643920 18.952 99 18 36 1 1935681456 14012016 6025520
23:49:23 32502 8192000000 10856699648 11306303488 1901588544 18.839 98 42 84 0 1931071840 17018032 12465264
23:50:10 23380 8192000000 10836461952 11298693120 1912358928 18.926 99 23 46 0 1931889184 12400192 7130064
23:50:49 55360 8192000000 10845617616 11292983296 1867804912 18.567 97 24 46 2 1887174400 11211248 8158240
23:51:51 63150 8192000000 10836299648 11290075136 1902280992 18.845 99 36 70 1 1923390464 11149616 9959856
23:53:00 68560 8192000000 10864532992 11320115200 1924819696 19.025 100 19 38 0 1942920416 13275616 4825104
23:54:23 79667 8192000000 10860769312 11334193152 1922573232 19.007 99 19 38 1 1953326144 24770528 5982384
23:56:23 59679 8192000000 10886265952 11329388544 1926568016 19.039 99 29 58 0 1949347472 14916880 7862576
23:57:37 10566 8192000000 10907969184 11344945152 1967041280 19.362 100 53 106 3 1995882432 13513088 15328064
23:58:01 54504 8192000000 10890039488 11335815168 1933334496 19.094 98 43 85 0 1961718688 16220528 12163664
23:59:12 46082 8192000000 10906035776 11355992064 1943523456 19.175 99 17 34 2 1965734480 17620864 4590160
00:00:09 67378 8192000000 10914043680 11377143808 1976834000 19.440 100 15 30 1 2004452064 23347424 4270640
00:01:58 26928 8192000000 10918012240 11385085952 1983940160 19.496 100 19 38 1 2017472752 27832448 5700144
00:03:07 31719 8192000000 10913529488 11372646400 1983558624 19.493 100 27 53 1 2008114752 16605920 7950208
00:03:46 75375 8192000000 10910100976 11390361600 1981190976 19.474 100 19 39 0 2018747856 31290880 6266000
00:05:11 71703 8192000000 10911490512 11371896832 1970859968 19.392 99 16 32 0 1985242896 9834112 4548816
00:06:29 55947 8192000000 10899924992 11378757632 1969149312 19.379 99 17 35 0 1986684608 12277680 5257616
00:07:33 78225 8192000000 10908165392 11378503680 1944537088 19.183 98 16 31 2 1958856624 9562784 4756752
00:09:05 69145 8192000000 10939988656 11391893504 1995368448 19.586 100 35 69 1 2020081472 15396608 9316416
00:10:21 43275 8192000000 10907038144 11380088832 1974066896 19.418 99 15 30 0 1993737936 15877648 3793392
00:11:20 69514 8192000000 10926295312 11390590976 1982725040 19.486 99 10 20 2 1994976112 9526896 2724176
00:12:37 78568 8192000000 10928991456 11402502144 1989756880 19.542 99 21 42 0 2006549520 10905104 5887536
00:14:03 67806 8192000000 10942149552 11417972736 1997483440 19.603 99 24 48 1 2018217408 13201680 7532288
00:15:27 86573 8192000000 10955023248 11412623360 2011705728 19.715 100 24 48 0 2028178128 10377984 6094416
00:17:00 44722 8192000000 10944776272 11414667264 2015235680 19.743 100 38 76 1 2039052096 13383136 10433280
00:17:54 88245 8192000000 10920426496 11389042688 1947665280 19.208 97 13 24 0 1961578544 10855744 3057520
00:19:29 135930 8192000000 10945979920 11425984512 1956458176 19.278 98 10 20 2 1970936544 11572256 2906112
00:21:52 130423 8192000000 10906524592 11363446784 1882565568 18.686 94 19 38 2 1903961120 16047504 5348048
00:24:13 98251 8192000000 10909869408 11382624256 1954531104 19.263 99 17 34 0 1974967552 15419904 5016544
00:26:05 22044 8192000000 10927909312 11392368640 1967711280 19.367 99 8 16 0 1987351344 16802256 2837808
00:26:36 66870 8192000000 10883227056 11355901952 1889186048 18.739 95 8 16 0 1911466320 20142336 2137936
00:27:49 45672 8192000000 10871652400 11347529728 1917649152 18.968 98 10 20 0 1944565360 24286768 2629440
00:28:43 44210 8192000000 10841013280 11308933120 1844155728 18.375 94 7 14 0 1862724976 16647328 1921920
00:29:34 45951 8192000000 10839261584 11308908544 1903539456 18.855 98 9 19 0 1912507424 6342128 2625840
00:30:36 58772 8192000000 10845464624 11319652352 1881835152 18.680 97 9 18 0 1891520192 7501296 2183744
00:31:43 34868 8192000000 10843875056 11313352704 1874538480 18.621 97 3 6 0 1882580224 7644944 396800
00:32:24 47700 8192000000 10859712464 11319484416 1931184128 19.076 99 25 50 1 1946287296 8272960 6830208
00:33:20 41567 8192000000 10850094016 11317710848 1885303760 18.708 97 23 46 1 1901833488 9183872 7345856
00:34:44 74987 8192000000 10871004224 11317047296 1842443600 18.361 95 19 38 0 1858411312 10671552 5296160
00:36:06 21161 8192000000 10896458976 11339612160 1948127280 19.212 100 62 124 1 1976900032 11005248 17767504
00:36:34 22722 8192000000 10876991008 11330641920 1924203616 19.021 99 36 72 0 1948495968 14486112 9806240
00:37:40 49263 8192000000 10869632992 11331608576 1892961264 18.770 97 18 37 0 1913281280 15626608 4693408
00:38:42 83026 8192000000 10868994848 11321704448 1874054240 18.617 96 16 32 2 1887498752 9213680 4230832
00:40:15 11693 8192000000 10883172512 11332763648 1940119472 19.148 100 29 58 0 1959305632 10709312 8476848
00:40:37 39414 8192000000 10877345984 11337973760 1926212448 19.037 99 36 72 0 1950253888 13913536 10127904
00:41:29 85093 8192000000 10869930896 11319922688 1853528160 18.451 96 7 14 0 1866745216 11328544 1888512
00:43:05 29987 8192000000 10901820432 11335831552 1911163936 18.916 98 42 84 0 1937162992 13985552 12013504
00:43:47 28173 8192000000 10893017392 11348303872 1947733888 19.208 100 41 82 1 1980983888 20843760 12406240
00:45:24 85415 8192000000 10866837120 11345920000 1902122320 18.843 98 12 23 1 1919667120 14155040 3389760
00:46:56 46796 8192000000 10902558112 11336785920 1944833120 19.185 100 37 74 1 1963971968 8148576 10990272
00:48:13 85941 8192000000 10861602800 11327078400 1935006288 19.107 99 33 66 2 1951514496 7656064 8852144
00:49:48 42040 8192000000 10872122608 11329572864 1939878576 19.146 99 28 56 2 1954403104 6436560 8087968
00:50:36 21014 8192000000 10886626736 11346182144 1961852320 19.321 100 27 54 2 1977810080 8461040 7496720
00:51:10 28682 8192000000 10874467952 11347668992 1948623568 19.216 99 39 78 0 1968316976 8728512 10964896
00:52:06 61263 8192000000 10874620736 11349909504 1940425008 19.150 99 6 13 0 1950694352 8938448 1330896
00:53:33 96947 8192000000 10885838240 11349995520 1927516240 19.047 98 15 30 0 1944950160 13339360 4094560
00:55:16 56521 8192000000 10890725632 11362615296 1963360384 19.333 100 14 28 0 1975441808 8287264 3794160
00:58:01 111312 8192000000 10904904384 11397967872 1963285472 19.332 99 10 20 1 1983770896 17657168 2828256
00:59:58 68845 8192000000 10913630928 11385212928 1972563184 19.406 99 15 30 1 1985702128 8854128 4284816
01:01:14 78768 8192000000 10908837968 11380756480 1955961072 19.274 98 18 36 1 1969526768 8690640 4875056
01:02:38 59748 8192000000 10902288176 11374501888 1945824896 19.193 98 13 26 1 1959932192 10384688 3722608
01:03:44 41438 8192000000 10905188352 11372519424 1956733696 19.280 99 9 18 0 1968245200 9432160 2079344
01:04:35 51470 8192000000 10926871600 11367694336 1948799040 19.217 98 41 80 2 1971401664 11467984 11134640
01:05:38 42172 8192000000 10906314720 11354923008 1923056832 19.011 97 54 109 0 1953115616 14554944 15503840
01:06:31 74225 8192000000 10895625472 11380490240 1963450528 19.333 100 19 38 1 1986091888 17394240 5247120
01:07:51 37991 8192000000 10919453152 11378085888 1957928400 19.290 99 21 42 1 1974988032 11232144 5827488
01:08:35 54097 8192000000 10943141568 11396366336 1989366624 19.539 100 24 48 3 2013482432 17175472 6940336
01:09:43 75187 8192000000 10908731440 11373608960 1904524976 18.863 96 15 30 0 1920771808 12267600 3979232
01:11:04 140606 8192000000 10884675888 11358072832 1943626368 19.176 99 16 32 1 1961106512 12986112 4494032
01:13:49 27636 8192000000 10877775088 11358195712 1961098080 19.315 100 6 12 0 1971002288 8602240 1301968
01:14:33 39118 8192000000 10873100272 11345469440 1929785440 19.065 98 14 27 1 1940728000 6777376 4165184
01:15:30 65528 8192000000 10874852048 11353030656 1913182112 18.932 97 9 18 0 1923275712 7709904 2383696
01:16:50 50317 8192000000 10843620112 11312173056 1854126448 18.456 95 7 14 0 1862485488 6953376 1405664
01:17:54 69423 8192000000 10875666000 11335708672 1916419936 18.958 99 17 33 0 1928691792 7367536 4904320
01:20:08 76130 8192000000 10870795456 11340472320 1890090528 18.747 97 20 40 1 1908975248 13367184 5517536
01:21:30 73486 8192000000 10847097232 11323883520 1884908352 18.705 97 4 8 0 1894688496 8648784 1131360
01:23:19 48422 8192000000 10853356832 11310374912 1878416400 18.652 97 23 44 1 1892547600 7805232 6325968
01:24:20 45120 8192000000 10865637184 11330555904 1923130544 19.012 99 23 46 3 1939016464 9599392 6286528
01:25:11 89387 8192000000 10857251040 11325939712 1853162400 18.448 95 21 42 0 1868065104 9125904 5776800
01:26:54 26493 8192000000 9219760368 9468661760 378161888 4.412 20 2 4 0 384479280 5897632 419760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 12-12-2020 01:28:41 to 12-12-2020 01:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-12-2020 01:29:12 to 12-12-2020 01:29:14.

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          242823
MON$OLDEST_ACTIVE               245592
MON$OLDEST_SNAPSHOT             245592
MON$NEXT_TRANSACTION            245592
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                       2005504
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
--- end of diff output ---

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

12.12.20 01:29:15. 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-12-12 01:29:18 No severe PSQL-related problems occured
12.12.20 01:29:19. End of report.