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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-12 19:27:15
DTS_END                         2021-02-12 19:27:15.0970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46686
TRN_ID                          245817
ATT_ID                          605
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: 9709.76 19106 1165171
customer order: creation 182.63 326 21916
customer order: refuse 15.97 330 1916
order to supplier: creation 47.54 1234 5705
order to supplier: removal 3.55 102604 426
invoice (draft): creation 46.92 3320 5630
invoice (draft): removal 54.14 767 6497
invoice accept: apply 44.39 17819 5327
invoice accept: cancel 48.73 786 5847
customer reserve: creation 4145.15 175 497418
customer reserve: removal 4808.68 59 577041
realization accept: apply 88.83 175 10660
realization accept: cancel 88.48 115 10617
payment from customer: creation 60.80 103 7296
payment from customer: removal 6.04 91 725
payment to supplier: creation 50.88 136 6106
payment to supplier: removal 3.73 107 447
service: total inventory turnovers 5.02 1189 602
service: total monetary turnovers 7.40 26 888
service: aggregate perf. data 0.86 19651 103
service: refresh index statistics 0.03 233110 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-02-2021 19:28:35 to 12-02-2021 19:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4180
TEST_TIME 2 3663
TEST_TIME 3 3996
TEST_TIME 4 3648
TEST_TIME 5 3311
TEST_TIME 6 4102
TEST_TIME 7 4636
TEST_TIME 8 4812
TEST_TIME 9 5254
TEST_TIME 10 5634
TEST_TIME 11 6023
TEST_TIME 12 6627
TEST_TIME 13 6664
TEST_TIME 14 6615
TEST_TIME 15 7003
TEST_TIME 16 7277
TEST_TIME 17 7345
TEST_TIME 18 7444
TEST_TIME 19 8126
TEST_TIME 20 8463
TEST_TIME 21 8650
TEST_TIME 22 9079
TEST_TIME 23 9879
TEST_TIME 24 10325
TEST_TIME 25 10505
TEST_TIME 26 11305
TEST_TIME 27 11113
TEST_TIME 28 11133
TEST_TIME 29 11071
TEST_TIME 30 10886
TEST_TIME 31 10981
TEST_TIME 32 10987
TEST_TIME 33 10903
TEST_TIME 34 10804
TEST_TIME 35 11037
TEST_TIME 36 10961
TEST_TIME 37 10765
TEST_TIME 38 10700
TEST_TIME 39 10559
TEST_TIME 40 10672
TEST_TIME 41 10488
TEST_TIME 42 10386
TEST_TIME 43 10370
TEST_TIME 44 10306
TEST_TIME 45 10240
TEST_TIME 46 10411
TEST_TIME 47 10391
TEST_TIME 48 10375
TEST_TIME 49 10263
TEST_TIME 50 10187
TEST_TIME 51 10102
TEST_TIME 52 10061
TEST_TIME 53 10097
TEST_TIME 54 10036
TEST_TIME 55 9955
TEST_TIME 56 9928
TEST_TIME 57 9903
TEST_TIME 58 9830
TEST_TIME 59 9765
TEST_TIME 60 9972
TEST_TIME 61 9939
TEST_TIME 62 10005
TEST_TIME 63 9941
TEST_TIME 64 10089
TEST_TIME 65 10100
TEST_TIME 66 10087
TEST_TIME 67 10188
TEST_TIME 68 10169
TEST_TIME 69 10167
TEST_TIME 70 10207
TEST_TIME 71 10183
TEST_TIME 72 10199
TEST_TIME 73 10104
TEST_TIME 74 10068
TEST_TIME 75 10001
TEST_TIME 76 9987
TEST_TIME 77 9937
TEST_TIME 78 9927
TEST_TIME 79 9861
TEST_TIME 80 9807
TEST_TIME 81 9806
TEST_TIME 82 9760
TEST_TIME 83 9792
TEST_TIME 84 9759
TEST_TIME 85 9776
TEST_TIME 86 9776
TEST_TIME 87 9826
TEST_TIME 88 9801
TEST_TIME 89 9850
TEST_TIME 90 9869
TEST_TIME 91 9877
TEST_TIME 92 9952
TEST_TIME 93 9962
TEST_TIME 94 10026
TEST_TIME 95 10060
TEST_TIME 96 10027
TEST_TIME 97 9954
TEST_TIME 98 9920
TEST_TIME 99 9890
TEST_TIME 100 9872
TEST_TIME 101 9817
TEST_TIME 102 9790
TEST_TIME 103 9767
TEST_TIME 104 9699
TEST_TIME 105 9671
TEST_TIME 106 9749
TEST_TIME 107 9769
TEST_TIME 108 9775
TEST_TIME 109 9788
TEST_TIME 110 9779
TEST_TIME 111 9788
TEST_TIME 112 9817
TEST_TIME 113 9802
TEST_TIME 114 9782
TEST_TIME 115 9728
TEST_TIME 116 9841
TEST_TIME 117 9854
TEST_TIME 118 9833
TEST_TIME 119 9769
TEST_TIME 120 9711

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-02-2021 19:28:39 to 12-02-2021 19:28:42.

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 1625019 1625019 0 0.00 0 19393 6 0 0
doc_list_biud 1625019 1625019 0 0.00 0 53617 27 0 0
sp_add_invoice_to_stock 5491 5327 164 2.98 33 242900 17820 0 164
sp_cancel_adding_invoice 5847 5847 0 0.00 4 65429 786 0 0
sp_cancel_client_order 1916 1916 0 0.00 4 12789 331 0 0
sp_cancel_customer_reserve 577041 577041 0 0.00 1 53619 60 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 3 8384 92 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 9097 107 0 0
sp_cancel_supplier_invoice 6510 6497 13 0.19 2 28358 767 0 13
sp_cancel_supplier_order 426 426 0 0.00 6 1136210 102604 0 0
sp_cancel_write_off 10617 10617 0 0.00 1 24617 115 0 0
sp_client_order 21916 21916 0 0.00 4 14782 327 0 0
sp_customer_reserve 497418 497418 0 0.00 0 93885 176 0 0
sp_fill_shopping_cart 33250 33250 0 0.00 1 16061 36 0 0
sp_fill_shopping_cart_clo_res 497417 497417 0 0.00 0 13798 12 0 0
sp_get_clo_for_invoice 5325 5325 0 0.00 0 20220 274 0 0
sp_kill_cost_storno 17636 17636 0 0.00 0 8275 56 0 0
sp_kill_qstorno_ret_qs2qd 1171622 1171622 0 0.00 0 53613 32 0 0
sp_kill_qty_storno 618329 618329 0 0.00 0 53617 69 0 0
sp_lock_selected_doc 22109 22109 0 0.00 0 8373 6 0 0
sp_make_cost_storno 29387 29387 0 0.00 0 16436 55 0 0
sp_multiply_rows_for_pdistr 29387 29387 0 0.00 0 14439 33 0 0
sp_multiply_rows_for_qdistr 21916 21916 0 0.00 0 13075 150 0 0
sp_pay_from_customer 7296 7296 0 0.00 4 13663 104 0 0
sp_pay_to_supplier 6106 6106 0 0.00 5 16454 137 0 0
sp_payment_common 13402 13402 0 0.00 2 14294 35 0 0
sp_qd_handle_on_cancel_clo 1916 1916 0 0.00 0 12779 296 0 0
sp_qd_handle_on_invoice_upd_sts 11172 11172 0 0.00 0 15792 316 0 0
sp_qd_handle_on_reserve_upd_sts 10660 10660 0 0.00 0 20968 50 0 0
sp_reserve_write_off 10660 10660 0 0.00 6 21002 175 0 0
sp_supplier_invoice 5630 5630 0 0.00 8 85806 3320 0 0
sp_supplier_order 5705 5705 0 0.00 5 29236 1235 0 0
srv_aggregate_perf_data 103 103 0 0.00 2571 154683 19652 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1160 139623 31693 0 0
srv_find_qd_qs_mism 1114388 1114388 0 0.00 0 19392 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 45 130842 1189 0 0
srv_make_money_saldo 888 888 0 0.00 1 1239 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 182829 281230 233110 0 0
t$perf-abend:sp_add_invoice_to_stock 164 164 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5328 5328 0 0.00 0 16090 153 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 0 2444 97 0 0
t$perf-norm:sp_cancel_client_order 1916 1916 0 0.00 0 6116 19 0 0
t$perf-norm:sp_cancel_customer_reserve 743 743 0 0.00 0 2767 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 262 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 2125 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 438 438 0 0.00 0 885 11 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 19693 1521 0 0
t$perf-norm:sp_cancel_write_off 1041 1041 0 0.00 0 1846 8 0 0
t$perf-norm:sp_client_order 21916 21916 0 0.00 0 10082 15 0 0
t$perf-norm:sp_customer_reserve 1074 1074 0 0.00 0 4625 11 0 0
t$perf-norm:sp_pay_from_customer 7296 7296 0 0.00 0 3875 8 0 0
t$perf-norm:sp_pay_to_supplier 6106 6106 0 0.00 0 9252 10 0 0
t$perf-norm:sp_reserve_write_off 10660 10660 0 0.00 0 15744 11 0 0
t$perf-norm:sp_supplier_invoice 5630 5630 0 0.00 0 4365 16 0 0
t$perf-norm:sp_supplier_order 5705 5705 0 0.00 0 6499 16 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 431 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 198 6 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 2307 24 0 0
t$perf-norm:srv_make_money_saldo 888 888 0 0.00 0 3714 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10978 10650 328 2.98 0 8410 21 0 328
v_all_customers 39754 39754 0 0.00 0 19 1 0 0
v_all_suppliers 31708 31708 0 0.00 0 21 1 0 0
v_all_wares 43832 43832 0 0.00 0 162 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 995 8 0 0
v_cancel_client_order 3832 3832 0 0.00 0 2512 6 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 2146 7 0 0
v_cancel_customer_reserve 1486 1486 0 0.00 0 3214 6 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 1213 6 0 0
v_cancel_supplier_invoice 902 876 26 2.88 0 5227 21 0 26
v_cancel_supplier_order 852 852 0 0.00 0 830 6 0 0
v_cancel_write_off 2082 2082 0 0.00 0 4735 20 0 0
v_max_id_clo_ord 5705 5705 0 0.00 0 692 1 0 0
v_max_id_clo_res 1074 1074 0 0.00 0 2441 13 0 0
v_max_id_ord_sup 5629 5629 0 0.00 0 6889 5 0 0
v_max_non_paid_invoice 1586 1586 0 0.00 0 268 2 0 0
v_max_non_paid_realizn 3874 3874 0 0.00 0 1032 3 0 0
v_min_id_clo_ord 5705 5705 0 0.00 0 9405 10 0 0
v_min_id_clo_res 1074 1074 0 0.00 0 1164 5 0 0
v_min_id_ord_sup 5629 5629 0 0.00 0 4276 5 0 0
v_min_non_paid_invoice 6106 6106 0 0.00 0 14282 25 0 0
v_min_non_paid_realizn 7296 7296 0 0.00 0 12613 23 0 0
v_our_firm 10922 10922 0 0.00 0 23 1 0 0
v_reserve_write_off 21320 21320 0 0.00 0 4566 7 0 0
x_lock_depdocs_on_canc_invoice 11906 11906 0 0.00 0 16403 115 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 6718 348 0 0
x_make_qstorno_1000_1200 5705 5705 0 0.00 2 29211 1147 0 0
x_make_qstorno_1200_2000 5630 5630 0 0.00 3 85790 3204 0 0
x_make_qstorno_2100_3300 497418 497418 0 0.00 0 93329 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-02-2021 19:28:43 to 12-02-2021 19:28:47.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 3 8192000000 8800966736 8812265472 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 19173 8192000000 10244957840 10549764096 991638080 10.797 77 62 124 1 1015770528 2838640 21293808
16:57:54 18868 8192000000 10322194336 10633228288 1366430352 14.295 100 80 160 0 1397637744 4252240 26955152
16:58:25 22206 8192000000 10352457008 10674008064 1409951584 14.684 100 85 169 1 1443454112 5625792 27876736
16:58:56 26857 8192000000 10385711584 10708533248 1438725888 14.938 100 88 176 0 1473862112 6234752 28901472
16:59:32 18668 8192000000 10405760992 10731208704 1454604640 15.078 100 84 168 0 1488599216 6524848 27469728
17:00:18 11660 8192000000 10431546480 10762063872 1483460016 15.332 100 84 168 0 1521756240 11417728 26878496
17:00:41 23840 8192000000 10462614672 10797760512 1514274384 15.600 100 87 173 1 1549990128 7875664 27840080
17:01:11 17620 8192000000 10487083648 10826862592 1537730480 15.804 100 83 166 2 1571814576 8011952 26072144
17:01:38 14200 8192000000 10513842752 10861039616 1572677456 16.105 100 83 166 0 1607370304 8592848 26100000
17:02:02 18272 8192000000 10546185424 10905550848 1592335904 16.274 100 69 136 1 1622179888 8640832 21203152
17:02:32 14332 8192000000 10588309536 10949582848 1653834592 16.797 100 80 160 0 1687338480 9518400 23985488
17:02:59 17546 8192000000 10617893936 10984230912 1675828720 16.982 100 77 154 0 1708879264 10458288 22592256
17:03:24 11281 8192000000 10630013632 10998169600 1696085824 17.152 100 82 164 1 1731327760 10816672 24425264
17:03:46 9434 8192000000 10650657008 11017908224 1708255952 17.254 100 79 157 0 1742180032 11307584 22616496
17:04:02 9578 8192000000 10660720288 11028840448 1718304176 17.338 100 83 166 2 1755168144 13014384 23849584
17:04:19 8827 8192000000 10673941152 11045924864 1730963024 17.444 100 88 176 1 1770320000 13749536 25607440
17:04:36 10906 8192000000 10681507280 11057676288 1739170800 17.512 100 79 158 1 1775337968 13584896 22582272
17:04:53 7512 8192000000 10691710800 11068272640 1750397312 17.605 100 81 163 1 1786377696 12248752 23731632
17:05:07 5127 8192000000 10706361712 11081768960 1762549552 17.705 100 79 156 1 1796863408 12437792 21876064
17:05:19 7898 8192000000 10708308496 11087376384 1770787904 17.774 100 78 155 1 1804920320 12358288 21774128
17:05:34 4518 8192000000 10712786256 11091791872 1775202640 17.810 100 87 173 1 1813976800 13835568 24938592
17:05:48 3046 8192000000 10725399824 11101388800 1782054704 17.866 100 82 163 1 1818152672 13432960 22665008
17:05:59 3888 8192000000 10730167312 11109691392 1787564064 17.912 100 82 165 0 1825039040 14403536 23071440
17:06:09 4246 8192000000 10727621056 11111403520 1795602704 17.978 100 84 166 1 1833421664 14478352 23340608
17:06:21 2609 8192000000 10739425184 11119644672 1803347600 18.041 100 90 180 0 1841844208 13503952 24992656
17:06:30 3604 8192000000 10745039824 11127349248 1803432416 18.042 100 77 154 3 1838754592 13000208 22321968
17:06:40 3719 8192000000 10748147344 11129618432 1808027536 18.080 100 87 176 0 1846035488 13820544 24187408
17:06:50 4106 8192000000 10759663712 11137802240 1810528848 18.100 100 81 162 3 1847497856 14478160 22490848
17:07:01 4179 8192000000 10772926240 11152736256 1815966768 18.145 100 88 172 3 1853770800 13704768 24099264
17:07:12 2578 8192000000 10775512544 11160227840 1829948480 18.259 100 82 164 1 1866537248 13520704 23068064
17:07:21 2999 8192000000 10776853696 11165446144 1836898016 18.316 100 93 186 0 1878408096 14829632 26680448
17:07:31 2228 8192000000 10774394576 11159789568 1843972528 18.373 100 90 180 1 1884070192 13300816 26796848
17:07:40 1968 8192000000 10786253248 11173154816 1843105808 18.366 100 84 168 2 1880401056 13628176 23667072
17:07:48 2089 8192000000 10790724000 11177725952 1847465712 18.402 100 89 177 1 1886101664 13391424 25244528
17:07:57 1894 8192000000 10800556320 11182989312 1852603360 18.443 100 93 186 1 1893174976 14525024 26046592
17:08:05 2944 8192000000 10802287952 11185254400 1857269968 18.481 100 90 178 0 1896067568 14349328 24448272
17:08:15 1920 8192000000 10805976512 11191431168 1856889360 18.478 100 92 185 0 1898105360 14653056 26562944
17:08:23 2184 8192000000 10810261968 11192438784 1860661312 18.509 100 92 182 1 1899484608 12873824 25949472
17:08:32 1869 8192000000 10813959680 11202265088 1866866224 18.559 100 90 180 0 1905102864 12292048 25944592
17:08:40 1748 8192000000 10802825216 11197820928 1866481568 18.556 100 84 166 2 1902954496 12872448 23600480
17:08:48 26186 8192000000 10802516880 11201568768 1865413648 18.547 100 52 103 1 1889328576 9536864 14378064
17:09:21 2558 8192000000 10818587520 11209293824 1875701184 18.630 100 85 168 2 1911624992 11987792 23936016
17:09:30 2612 8192000000 10795557088 11207929856 1870314624 18.587 100 55 110 1 1901405792 16026736 15064432
17:09:41 3103 8192000000 10798644624 11204009984 1874742528 18.623 100 60 119 1 1900413856 8966816 16704512
17:09:50 5625 8192000000 10803875456 11210518528 1874147216 18.618 100 44 88 0 1897376096 11200768 12028112
17:10:02 4433 8192000000 10800531072 11209404416 1874436736 18.620 100 40 80 0 1894826688 9184384 11205568
17:10:13 4108 8192000000 10802172768 11215978496 1878618384 18.654 100 43 85 3 1902102400 11988704 11495312
17:10:25 5202 8192000000 10796546512 11211190272 1877583280 18.646 100 33 66 4 1894873216 8381184 8908752
17:10:36 57645 8192000000 10808074704 11222519808 1882506352 18.685 100 52 104 1 1905459984 8135792 14817840
17:11:40 1802 8192000000 10832092064 11234701312 1894612752 18.783 100 92 186 3 1931292832 8768784 27911296
17:11:51 9308 8192000000 10801960240 11223687168 1882182960 18.683 100 26 53 2 1896407104 7161520 7062624
17:12:07 4382 8192000000 10798712112 11225325568 1886844864 18.720 100 34 68 1 1903907840 7737232 9325744
17:12:19 5428 8192000000 10793853968 11224387584 1884996688 18.705 100 25 50 3 1898507280 6234048 7276544
17:12:32 5769 8192000000 10806103920 11230289920 1889955648 18.745 100 37 74 0 1907263936 6886480 10421808
17:12:44 6416 8192000000 10796940512 11228368896 1889841664 18.745 100 29 59 1 1904437008 6541520 8053824
17:12:58 6541 8192000000 10818337936 11238723584 1894253120 18.780 100 31 62 1 1909721344 6953888 8514336
17:13:13 4789 8192000000 10810267984 11238670336 1895886176 18.793 100 24 48 0 1909150544 6385104 6879264
17:13:24 8700 8192000000 10806006272 11239784448 1897672800 18.808 100 33 66 0 1918784112 11931072 9180240
17:13:39 6291 8192000000 10804469296 11237789696 1897127920 18.803 100 29 59 1 1911960448 6760928 8071600
17:13:52 6608 8192000000 10814546064 11241467904 1900160544 18.828 100 29 59 2 1914912288 6610128 8141616
17:14:05 8543 8192000000 10814955872 11246239744 1903422208 18.854 100 33 66 1 1919467776 5763936 10281632
17:14:23 9086 8192000000 10810149232 11246952448 1904149584 18.860 100 23 47 1 1916884944 6105488 6629872
17:14:42 16421 8192000000 10820237568 11248115712 1909273312 18.901 100 25 50 1 1922613632 6290000 7050320
17:15:04 76803 8192000000 10817603552 11252027392 1907314912 18.885 100 27 52 1 1924284128 9336624 7632592
17:16:28 6944 8192000000 10821930592 11258789888 1910961872 18.914 100 29 59 1 1926343712 7498864 7882976
17:16:41 6369 8192000000 10842407264 11265429504 1914867344 18.946 100 33 66 2 1931225680 7317648 9040688
17:16:54 4272 8192000000 10821669264 11252678656 1908318448 18.893 100 48 97 2 1929907632 7741216 13847968
17:17:05 7984 8192000000 10821485472 11252105216 1906133776 18.876 100 19 36 1 1916568992 5172496 5262720
17:17:25 7969 8192000000 10796025872 11225444352 1869866512 18.583 99 18 35 1 1880493696 5919904 4707280
17:17:40 8936 8192000000 10797235760 11227639808 1875239136 18.627 99 35 70 4 1892286512 6425712 10621664
17:17:55 8330 8192000000 10787401264 11211669504 1831562128 18.272 97 22 44 0 1843917120 5783472 6571520
17:18:09 5029 8192000000 10784805632 11206279168 1840449984 18.344 98 25 49 2 1852912496 5570496 6892016
17:18:21 6733 8192000000 10755082288 11179323392 1811300880 18.107 97 22 44 3 1824130752 6576880 6252992
17:18:36 10699 8192000000 10748106496 11170762752 1790387808 17.935 97 28 56 1 1804003680 5372848 8243024
17:18:52 6639 8192000000 10769967568 11190079488 1835974480 18.308 99 29 56 0 1849797552 5767552 8055520
17:19:05 5670 8192000000 10750167408 11170541568 1795346176 17.976 97 27 54 4 1809155952 5868976 7940800
17:19:22 17542 8192000000 10721451904 11129614336 1691099792 17.111 92 22 45 2 1702215264 4521808 6593664
17:19:46 52764 8192000000 10746500320 11135905792 1723849376 17.384 94 47 94 1 1743907456 6218800 13839280
17:20:45 14623 8192000000 10679164784 11084550144 1639275888 16.674 91 35 70 1 1655432032 6622720 9533424
17:21:09 7173 8192000000 10710681184 11121164288 1772739888 17.790 99 23 45 0 1784963488 5947296 6276304
17:21:23 7244 8192000000 10696906384 11109490688 1705073120 17.228 95 32 64 0 1720716832 6083904 9559808
17:21:40 6169 8192000000 10683337456 11083837440 1728315632 17.421 97 31 62 0 1744061968 6814672 8931664
17:21:52 3803 8192000000 10703684800 11119308800 1774241824 17.802 99 34 68 2 1791006416 6131968 10632624
17:22:04 10153 8192000000 10700024464 11111297024 1750203952 17.603 97 33 66 2 1770262912 10392608 9666352
17:22:23 8852 8192000000 10714512384 11125207040 1746969872 17.576 97 26 52 0 1761221216 6391952 7859392
17:22:39 6939 8192000000 10711514000 11133050880 1794855584 17.972 100 20 40 0 1806352272 5960080 5536608
17:22:55 5265 8192000000 10722890016 11138097152 1793057040 17.957 99 14 28 0 1802172832 5072736 4043056
17:23:09 6222 8192000000 10729392480 11146358784 1810010512 18.096 100 22 45 3 1821761664 5476336 6274816
17:23:23 12869 8192000000 10735449664 11162853376 1807580976 18.076 99 25 48 2 1820609968 5797376 7231616
17:23:42 7915 8192000000 10756568720 11172212736 1831887072 18.275 100 24 48 1 1844583808 5431408 7265328
17:23:56 10439 8192000000 10755006624 11170004992 1815098784 18.138 99 16 32 1 1825130752 5406032 4625936
17:24:14 14736 8192000000 10758089472 11173539840 1835256576 18.302 100 17 34 4 1845852256 5712624 4883056
17:24:36 57684 8192000000 10744905104 11181580288 1842629248 18.362 100 34 68 1 1858864144 4960672 11274224
17:25:41 12760 8192000000 10762213296 11188875264 1849911552 18.421 100 19 38 0 1860661760 5269808 5480400
17:26:02 8408 8192000000 10781771536 11198324736 1856332304 18.474 100 29 58 1 1870322992 6122016 7868672
17:26:17 7944 8192000000 10773765040 11198750720 1860615616 18.508 100 32 65 3 1876297552 6860704 8821232
17:26:33 10880 8192000000 10781696944 11204120576 1862306192 18.522 100 26 52 0 1875057184 5608912 7142080
17:26:52 7090 8192000000 10765042576 11202019328 1863583920 18.532 100 22 44 0 1876584432 6489120 6511392
17:27:05 16637 8192000000 10808077824 11231830016 1881734144 18.679 100 16 32 3 1890586176 4352816 4499216
17:27:43 26617 8192000000 10832648352 11251064832 1903181232 18.852 100 43 85 1 1921476736 6189056 12106448
17:28:22 6149 8192000000 10853342768 11267031040 1917277456 18.965 100 51 102 1 1941064224 9203344 14583424
17:28:39 24227 8192000000 10858356288 11279499264 1924417024 19.022 100 54 106 2 1954326144 15824864 14084256
17:29:15 53136 8192000000 10877330720 11309154304 1939921120 19.146 100 48 96 0 1967451008 13986048 13543840
17:30:17 19374 8192000000 10889349648 11322339328 1956669792 19.280 100 48 96 2 1990154512 19710800 13773920
17:31:07 42209 8192000000 10902323696 11332911104 1962287744 19.324 100 50 99 1 1998923088 20392464 16242880
17:31:59 65496 8192000000 10897956480 11340255232 1962757200 19.328 100 37 72 2 1998042848 24015568 11270080
17:33:15 38746 8192000000 10910706544 11350769664 1963714816 19.336 100 25 50 0 1996333520 25229616 7389088
17:34:04 9617 8192000000 10921844672 11354128384 1972050944 19.402 100 52 104 2 2013911408 26873344 14987120
17:34:24 5645 8192000000 10936330400 11359879168 1975474288 19.429 100 52 104 1 2016005456 25396304 15134864
17:34:36 2272 8192000000 10946760448 11364519936 1985899856 19.511 100 87 174 2 2039162752 26903760 26359136
17:34:47 7351 8192000000 10948403792 11371429888 1987547968 19.524 100 67 132 1 2034802912 28115104 19139840
17:35:01 8987 8192000000 10944345472 11371728896 1987148816 19.521 100 60 121 2 2033221264 28636432 17436016
17:35:31 12056 8192000000 10953565280 11386929152 1994818400 19.582 100 54 108 3 2043972112 32486416 16667296
17:35:57 2836 8192000000 10971995088 11392446464 2000583600 19.627 100 60 120 0 2050820896 31788480 18448816
17:36:08 10216 8192000000 10954785808 11394793472 2000262944 19.625 100 59 118 3 2049844560 32261200 17320416
17:36:29 6607 8192000000 10965336224 11397554176 2002030416 19.639 100 62 122 0 2056053952 35632848 18390688
17:36:44 1192 8192000000 10975883008 11393282048 2000963472 19.630 100 86 173 4 2060618208 33811280 25843456
17:36:52 9656 8192000000 10965019888 11394191360 1998455280 19.611 100 65 127 2 2053447904 35917008 19075616
17:37:11 3567 8192000000 10990768288 11404906496 2009102656 19.694 100 86 171 3 2071669776 37630944 24936176
17:37:22 13997 8192000000 10971989088 11406532608 2004424672 19.658 100 64 128 2 2062610048 38703616 19481760
17:37:47 6528 8192000000 10973601584 11401293824 2001449408 19.634 100 52 103 0 2055701056 38561104 15690544
17:38:16 9927 8192000000 10966442464 11394629632 1956068944 19.275 97 66 132 0 2015673744 40225392 19379408
17:38:33 2282 8192000000 10987402160 11408580608 2007177664 19.679 100 71 142 0 2070146960 40924288 22045008
17:38:45 2362 8192000000 10999644320 11416698880 2013629088 19.730 100 79 157 0 2077221360 39609568 23982704
17:38:55 2161 8192000000 11002561216 11417300992 2016283264 19.751 100 86 173 0 2083387632 40908384 26195984
17:39:05 3158 8192000000 10978974064 11411640320 2009675264 19.699 100 77 155 1 2073151152 40278304 23197584
17:39:14 1552 8192000000 10987316144 11401666560 2000127168 19.624 100 91 178 0 2069515376 41608320 27779888
17:39:23 3106 8192000000 10981097104 11402272768 2005255328 19.664 100 82 164 0 2066973376 37069088 24648960
17:39:33 2625 8192000000 10955414208 11372630016 1965103024 19.347 98 82 164 1 2026773840 36850224 24820592
17:39:45 2135 8192000000 10969724144 11387281408 1975901296 19.432 99 82 164 1 2038006640 37011376 25093968
17:39:54 16189 8192000000 10957474544 11390058496 1974313952 19.420 99 65 130 0 2033047776 38130448 20603376
17:40:30 2609 8192000000 10959689936 11397754880 1995327392 19.586 100 58 112 1 2052051536 38591600 18132544
17:40:41 5452 8192000000 10962206336 11392450560 1990953376 19.551 100 58 116 2 2048408544 38473552 18981616
17:40:58 1411 8192000000 10994754768 11412451328 2009288400 19.696 100 88 176 3 2077018416 40286256 27443760
17:41:06 1697 8192000000 11010120128 11422289920 2015996416 19.749 100 89 179 4 2086729664 43253248 27480000
17:41:16 2489 8192000000 11010069536 11431641088 2020963856 19.788 100 78 156 0 2089473552 44498960 24010736
17:41:26 3004 8192000000 11015215408 11436105728 2028133408 19.844 100 81 163 1 2098067776 45456128 24478240
17:41:37 6153 8192000000 11017965360 11444142080 2031324576 19.869 100 75 150 2 2101246144 47135840 22785728
17:41:49 3912 8192000000 11017325344 11440152576 2027392864 19.838 100 75 150 2 2097545024 47184736 22967424
17:42:03 2108 8192000000 11008990144 11437191168 2020871168 19.787 100 78 154 0 2091363104 46529200 23962736
17:42:16 3620 8192000000 11004647024 11432161280 2015865936 19.748 100 82 162 1 2091803232 50432064 25505232
17:42:27 8560 8192000000 10981026880 11414306816 1986488352 19.516 99 62 122 0 2055056752 48953984 19614416
17:42:43 6820 8192000000 10998412304 11428638720 2008539616 19.690 100 62 124 0 2081160176 52500416 20120144
17:42:57 1967 8192000000 11013889136 11428884480 2003057536 19.647 99 87 172 1 2079810736 50090864 26662336
17:43:06 1902 8192000000 11008447728 11422126080 1997007120 19.599 99 86 173 2 2076734464 52550784 27176560
17:43:15 2357 8192000000 10992138080 11399917568 1987534896 19.524 99 92 185 4 2070425264 54645664 28244704
17:43:24 1638 8192000000 11003931504 11413848064 1995334416 19.586 99 86 173 2 2076309456 55052144 25922896
17:43:32 3324 8192000000 11013472064 11425263616 2007760608 19.684 100 93 186 1 2092389040 56439088 28189344
17:43:42 1158 8192000000 11020748112 11436871680 2021284352 19.790 100 93 184 1 2104879408 56004512 27590544
17:43:53 2669 8192000000 11022896912 11442745344 2024036208 19.812 100 82 164 2 2103049872 54722384 24291280
17:44:03 2827 8192000000 11022785072 11442618368 2024138256 19.813 100 72 143 0 2099262064 52726720 22397088
17:44:15 3790 8192000000 11025520992 11442302976 2021375056 19.791 100 80 158 0 2100643008 54813584 24454368
17:44:26 4599 8192000000 11031104368 11445813248 2025995520 19.827 100 86 171 2 2109066384 55993888 27076976
17:44:41 1966 8192000000 11031969552 11449008128 2029490928 19.855 100 80 156 2 2110831376 56786720 24553728
17:44:50 2401 8192000000 11028985744 11441618944 2015249392 19.743 99 86 173 2 2099702144 57351792 27100960
17:45:01 1859 8192000000 11033017120 11446784000 2024981600 19.819 100 91 182 4 2114934736 61243776 28709360
17:45:11 3532 8192000000 10995028848 11408982016 1977308512 19.443 98 80 160 0 2065217136 62264416 25644208
17:45:23 4380 8192000000 11012033616 11428777984 2008248416 19.688 100 89 178 2 2099095104 62820416 28026272
17:45:34 2545 8192000000 11000907168 11408506880 1972909136 19.409 98 94 184 1 2065390832 63473552 29008144
17:45:43 3003 8192000000 11026676592 11439861760 2005628816 19.667 100 91 182 0 2104337520 69491584 29217120
17:45:53 1918 8192000000 11027152192 11441807360 2012086032 19.718 100 90 178 0 2106475424 65448128 28941264
17:46:03 1867 8192000000 11026231776 11437658112 2006999488 19.678 100 94 187 5 2104775216 67970832 29804896
17:46:13 2133 8192000000 11012786576 11421040640 1987706464 19.526 100 91 182 1 2088702256 70920464 30075328
17:46:24 1771 8192000000 11008529792 11421032448 1992346368 19.562 100 84 168 0 2087564656 67789472 27428816
17:46:34 3358 8192000000 11007490336 11425452032 1993916432 19.575 100 76 152 0 2086996096 68626560 24453104
17:46:57 9051 8192000000 10989220608 11424841728 1980510464 19.469 99 53 105 2 2059641888 61240064 17891360
17:47:15 4214 8192000000 11006011680 11426066432 2001681360 19.636 100 71 143 2 2084468656 58997328 23789968
17:47:29 4683 8192000000 10996399760 11427037184 1995839392 19.590 100 63 124 0 2079563184 63112192 20611600
17:47:43 6850 8192000000 10981587424 11429146624 1990776416 19.550 100 39 78 1 2065471616 60689248 14005952
17:48:03 18107 8192000000 10974761840 11426336768 1979570064 19.461 99 45 90 1 2058943856 63228112 16145680
17:48:59 11519 8192000000 10955311264 11406991360 1973260992 19.411 100 32 64 0 2045694688 61220400 11213296
17:49:20 15731 8192000000 10950254976 11400118272 1963576624 19.334 100 31 62 1 2032034272 57310480 11147168
17:49:54 15580 8192000000 10928138896 11369926656 1920899872 18.994 98 40 80 0 1993861248 59471792 13489584
17:50:26 24594 8192000000 10916377152 11380744192 1948444624 19.214 100 24 48 5 2003392512 46428592 8519296
17:50:58 21579 8192000000 10915816640 11373207552 1948389008 19.214 100 22 44 0 2003832432 47465088 7978336
17:51:47 23522 8192000000 10907455664 11364626432 1950714448 19.232 100 13 26 2 1992458064 37489312 4254304
17:52:17 30453 8192000000 10899231872 11364880384 1942117456 19.164 100 14 28 0 1982377440 35395424 4864560
17:52:59 13117 8192000000 10907439328 11372269568 1943711632 19.176 100 13 26 0 1992819504 44930944 4176928
17:53:18 31691 8192000000 10866382704 11335876608 1910103520 18.907 98 14 27 2 1933152304 19817104 3231680
17:53:56 38577 8192000000 10871246768 11324403712 1888555888 18.734 97 11 22 2 1901916816 10199808 3161120
17:54:41 54225 8192000000 10877862368 11336159232 1904370576 18.861 98 21 42 0 1924220720 13484512 6365632
17:55:54 107255 8192000000 10860570560 11315453952 1836668256 18.314 95 15 30 0 1855511408 14839232 4003920
17:57:51 30250 8192000000 10874650240 11328335872 1914459792 18.942 99 10 21 1 1924356720 7144032 2752896
17:58:27 127779 8192000000 10834265968 11281977344 1765655632 17.731 91 14 28 0 1782834784 13746176 3432976
18:00:53 83146 8192000000 10883872640 11349819392 1920302160 18.989 99 7 14 0 1940814032 18708704 1803168
18:02:26 60644 8192000000 10884675568 11355729920 1934898800 19.106 99 18 36 1 1954866160 14231616 5735744
18:03:34 139623 8192000000 10891087056 11351068672 1899024544 18.818 97 16 32 0 1914253472 10772000 4456928
18:06:10 56926 8192000000 10914044256 11359313920 1932121360 19.084 98 30 60 0 1952166064 11561696 8483008
18:07:18 127260 8192000000 10900243712 11354451968 1939113248 19.140 99 35 70 1 1967281104 17743744 10424112
18:09:33 40010 8192000000 10908430608 11372670976 1961133408 19.315 99 48 97 0 1988148272 13171856 13843008
18:10:23 64406 8192000000 10919921296 11380322304 1980186960 19.466 100 29 58 0 2003925792 14841248 8897584
18:11:49 41014 8192000000 10943708640 11397701632 1988529360 19.532 100 49 98 1 2023385600 19605520 15250720
18:12:36 63475 8192000000 10939932992 11395833856 1980358480 19.468 100 17 34 1 2004884992 19056368 5470144
18:13:50 119292 8192000000 10884355168 11368525824 1903957120 18.858 96 8 16 0 1913560288 7430976 2172192
18:16:01 20881 8192000000 10893586656 11363266560 1950438576 19.230 99 6 12 1 1959278432 7202896 1636960
18:16:28 36028 8192000000 10887388784 11365285888 1954583744 19.263 99 13 26 1 1968402448 10116480 3702224
18:17:11 41739 8192000000 10878089664 11359588352 1945997280 19.195 99 14 28 0 1961708960 11355552 4356128
18:18:32 53251 8192000000 10904491024 11383672832 1972565472 19.406 100 26 53 0 1993311552 13162208 7583872
18:19:44 37287 8192000000 10902872464 11389050880 1977258752 19.443 100 9 18 1 1996399280 16257184 2883344
18:20:57 22373 8192000000 10896469840 11377328128 1968397536 19.373 99 18 36 0 1980993952 7796512 4799904
18:22:21 85687 8192000000 10900590224 11394818048 1988591696 19.533 100 17 34 2 2003206624 9778624 4836304
18:24:11 58406 8192000000 10902914416 11385167872 1946552496 19.199 98 7 14 0 1955463888 7004880 1906512
18:25:22 14913 8192000000 10903193872 11376386048 1979340128 19.459 100 22 44 0 1995105632 9365424 6400080
18:25:45 22350 8192000000 10910460896 11375669248 1968469440 19.373 99 37 71 1 1989267536 11115488 9682608
18:26:21 16518 8192000000 10929701616 11391635456 1990521328 19.548 100 53 107 2 2019218992 13933744 14763920
18:26:51 70435 8192000000 10886358624 11373043712 1965685312 19.351 99 21 42 1 1985693104 14143584 5864208
18:28:08 18734 8192000000 10897321072 11359485952 1907417696 18.886 96 27 54 0 1921228448 6604384 7206368
18:28:38 24735 8192000000 10891686864 11353821184 1920028560 18.987 97 32 64 0 1940333040 11554368 8750112
18:29:11 31519 8192000000 10912478464 11376943104 1943446352 19.174 99 23 46 2 1960665232 11096688 6122192
18:29:51 48268 8192000000 10883480672 11350712320 1878000912 18.649 95 17 34 3 1899898032 17288096 4609024
18:30:55 58598 8192000000 10851749184 11323863040 1825579424 18.223 94 7 14 0 1844101872 16561488 1960960
18:32:04 90569 8192000000 10890302144 11346268160 1769706704 17.765 91 18 35 0 1794228592 19603408 4918480
18:33:54 65275 8192000000 10857363984 11325378560 1893254224 18.772 98 14 28 0 1913087072 16127744 3705104
18:35:06 41733 8192000000 10878466608 11332595712 1922842160 19.010 99 35 69 1 1942266496 10062736 9361600
18:35:58 27075 8192000000 10871840768 11322765312 1907866592 18.890 98 42 83 2 1930610112 11122560 11620960
18:36:31 9122 8192000000 10887414800 11336245248 1943351808 19.173 100 45 90 0 1966013024 10525776 12135440
18:36:49 8964 8192000000 10892790608 11333074944 1928700752 19.056 99 52 103 0 1952593488 10309440 13583296
18:37:05 13590 8192000000 10895707472 11335077888 1930607472 19.072 99 59 119 1 1960223120 13556208 16059440
18:37:26 57899 8192000000 10871799808 11330621440 1886820032 18.720 97 22 44 1 1902423136 10050720 5552384
18:38:30 65268 8192000000 10863771488 11343769600 1891264528 18.756 97 26 52 1 1911271952 12552848 7454576
18:39:42 67482 8192000000 10854731648 11319554048 1918939664 18.978 99 13 26 1 1934425392 12397488 3088240
18:40:58 78702 8192000000 10861805024 11320680448 1852619600 18.443 95 27 54 1 1866917584 6873264 7424720
18:42:24 39358 8192000000 10855012560 11321737216 1917150528 18.964 99 23 46 0 1934199104 10842464 6206112
18:43:10 9165 8192000000 10848426368 11324469248 1930862976 19.074 100 5 10 0 1940859968 8736704 1260288
18:43:28 12159 8192000000 10851178640 11330174976 1940584368 19.151 100 17 35 1 1952016832 6674560 4757904
18:43:48 56060 8192000000 10850301104 11328098304 1892205616 18.764 97 23 46 1 1908434112 9080400 7148096
18:45:01 45902 8192000000 10849128768 11330322432 1913086528 18.931 99 10 20 1 1923796464 7512128 3197808
18:45:55 70282 8192000000 10845901392 11318435840 1894614048 18.783 98 16 29 2 1905960208 7613712 3732448
18:47:12 61974 8192000000 10847727392 11323854848 1909815152 18.905 99 5 10 0 1919179440 7869600 1494688
18:48:20 54935 8192000000 10848541984 11335897088 1874361696 18.620 97 8 17 0 1888963744 12756512 1845536
18:49:27 36553 8192000000 10855039776 11324010496 1896079120 18.795 98 20 40 0 1911875408 10510112 5286176
18:50:11 35127 8192000000 10848212544 11316678656 1878703872 18.655 97 27 54 4 1894452688 8380784 7368032
18:50:54 24902 8192000000 10843855312 11315916800 1912092688 18.923 99 18 36 4 1924409312 7240080 5076544
18:51:29 45787 8192000000 10870977936 11336527872 1918484928 18.975 99 39 79 0 1939382864 9448448 11449488
18:52:21 53572 8192000000 10886110720 11350769664 1936155680 19.116 99 32 66 1 1957885280 12106592 9623008
18:53:34 50643 8192000000 10870015392 11358085120 1949515904 19.223 100 18 37 1 1965184800 10771728 4897168
18:54:30 63396 8192000000 10883761552 11348549632 1912851808 18.930 98 13 26 0 1924814336 8107264 3855264
18:55:40 23725 8192000000 10893593040 11352395776 1942449072 19.166 99 42 84 2 1963156784 8535152 12172560
18:56:12 24155 8192000000 10888581824 11358294016 1951272272 19.237 100 22 44 0 1967298736 9873840 6152624
18:56:43 33743 8192000000 10885898208 11347533824 1921920896 19.002 98 29 58 1 1938659936 9213120 7525920
18:57:23 92051 8192000000 10900410240 11379007488 1927650528 19.048 98 15 30 0 1945469456 13339504 4479424
18:59:01 112293 8192000000 10905096832 11379994624 1922009344 19.003 97 11 20 2 1934292464 9934240 2348880
19:01:40 81335 8192000000 10915820640 11396370432 1931041120 19.075 97 15 30 1 1954226432 19256608 3928704
19:03:08 41488 8192000000 10921915344 11378515968 1924871600 19.026 97 26 52 2 1946244544 14140944 7232000
19:04:22 87808 8192000000 10905889456 11374317568 1904774272 18.865 96 31 62 0 1920403856 6919152 8710432
19:05:58 64447 8192000000 10888450608 11369533440 1958098448 19.291 99 16 32 0 1977477536 14702496 4676592
19:07:08 6340 8192000000 10894703056 11382038528 1973569680 19.414 100 8 16 0 1990934416 15232144 2132592
19:07:21 24841 8192000000 10907257488 11382059008 1976628992 19.438 100 24 47 0 1996811792 13455984 6726816
19:07:52 35517 8192000000 10885669936 11373957120 1938894544 19.138 98 12 24 0 1951911760 9786480 3230736
19:09:04 61886 8192000000 10920855296 11392761856 1959327360 19.301 99 19 38 1 1981310640 16884800 5098480
19:10:15 77171 8192000000 10899988112 11380895744 1957900848 19.289 99 16 32 0 1977795792 15189024 4705920
19:11:38 76283 8192000000 10882608592 11368869888 1943310960 19.173 98 27 53 1 1972346976 20767568 8268448
19:13:28 79347 8192000000 10884781520 11359301632 1915404352 18.950 98 16 33 0 1941903456 21833104 4666000
19:15:07 75903 8192000000 10884130112 11350663168 1917470800 18.967 98 20 40 2 1939059312 14879680 6708832
19:16:32 64320 8192000000 10864763984 11332898816 1870211088 18.586 96 15 30 2 1885543568 11007648 4324832
19:17:46 43112 8192000000 10850013744 11321257984 1844169248 18.375 95 18 36 2 1859113808 9780304 5164256
19:18:35 61700 8192000000 10828219424 11301478400 1845496112 18.386 96 17 34 1 1859925312 9904224 4524976
19:19:43 36116 8192000000 10839155360 11296546816 1859115584 18.496 97 29 58 1 1875482928 8851040 7516304
19:20:28 33736 8192000000 10844257824 11303534592 1865395680 18.547 97 34 68 0 1886746432 12009056 9341696
19:21:11 44578 8192000000 10865159152 11326832640 1899626576 18.823 99 33 66 1 1924353616 15568432 9158608
19:22:03 29397 8192000000 10877065024 11321802752 1847324896 18.400 96 45 90 1 1880155328 19575936 13254496
19:22:40 30452 8192000000 10886736800 11334733824 1923534560 19.015 100 50 98 0 1960188896 22589744 14064592
19:23:23 36575 8192000000 10873545952 11324792832 1925088128 19.028 100 24 48 0 1947532272 15964976 6479168
19:24:09 50156 8192000000 10843781648 11321466880 1889911184 18.745 98 26 52 2 1908797232 12304928 6581120
19:25:13 21609 8192000000 10855616736 11320979456 1922531920 19.007 100 23 46 2 1935902256 7216800 6153536
19:25:41 98833 8192000000 10081136352 10471485440 1197678048 12.755 62 17 32 1 1207181216 4859088 4644080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-02-2021 19:28:49 to 12-02-2021 19:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 164 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-02-2021 19:29:22 to 12-02-2021 19:29:24.

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          244986
MON$OLDEST_ACTIVE               246049
MON$OLDEST_SNAPSHOT             246049
MON$NEXT_TRANSACTION            246049
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                       2039904
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:267: 
:268: mscs-test-161.budzdorov.ru    Fri Feb 12 19:27:26 2021
:269:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:270: 
:271: 
:272: mscs-test-161.budzdorov.ru    Fri Feb 12 19:27:26 2021
:273:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:274: 
:275: 
:276: mscs-test-161.budzdorov.ru    Fri Feb 12 19:27:27 2021
:277:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:278: 
:279: 
:280: mscs-test-161.budzdorov.ru    Fri Feb 12 19:27:28 2021
:281:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:282: 
:283: 
:284: mscs-test-161.budzdorov.ru    Fri Feb 12 19:27:29 2021
:285:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:286: 
--- end of diff output ---

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

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