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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17443016 kB
MemAvailable 31555896 kB
Buffers 0 kB
Cached 14221984 kB
SwapCached 1980 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-06 19:27:02
DTS_END                         2020-12-06 19:27:02.9700
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36592
TRN_ID                          250902
ATT_ID                          711
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: 9706.04 16201 1164725
customer order: creation 180.81 378 21697
customer order: refuse 15.58 238 1869
order to supplier: creation 49.25 1138 5910
order to supplier: removal 3.46 82568 415
invoice (draft): creation 48.49 2670 5819
invoice (draft): removal 55.28 594 6633
invoice accept: apply 43.65 15482 5238
invoice accept: cancel 50.71 639 6085
customer reserve: creation 4043.17 153 485180
customer reserve: removal 4902.57 46 588308
realization accept: apply 87.05 159 10446
realization accept: cancel 90.35 90 10842
payment from customer: creation 62.10 108 7452
payment from customer: removal 6.17 89 740
payment to supplier: creation 50.88 134 6105
payment to supplier: removal 3.91 92 469
service: total inventory turnovers 5.03 962 603
service: total monetary turnovers 6.61 18 793
service: aggregate perf. data 0.98 17530 117
service: refresh index statistics 0.03 200931 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-12-2020 19:28:05 to 06-12-2020 19:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9950
TEST_TIME 2 7525
TEST_TIME 3 6715
TEST_TIME 4 6630
TEST_TIME 5 6117
TEST_TIME 6 5793
TEST_TIME 7 5881
TEST_TIME 8 5892
TEST_TIME 9 6260
TEST_TIME 10 6922
TEST_TIME 11 7130
TEST_TIME 12 7975
TEST_TIME 13 8186
TEST_TIME 14 8614
TEST_TIME 15 9608
TEST_TIME 16 9617
TEST_TIME 17 10259
TEST_TIME 18 10409
TEST_TIME 19 10599
TEST_TIME 20 12141
TEST_TIME 21 12311
TEST_TIME 22 12090
TEST_TIME 23 11949
TEST_TIME 24 12367
TEST_TIME 25 12013
TEST_TIME 26 11806
TEST_TIME 27 11692
TEST_TIME 28 11619
TEST_TIME 29 11771
TEST_TIME 30 11496
TEST_TIME 31 11478
TEST_TIME 32 11559
TEST_TIME 33 11477
TEST_TIME 34 11492
TEST_TIME 35 11347
TEST_TIME 36 11558
TEST_TIME 37 11433
TEST_TIME 38 11250
TEST_TIME 39 11066
TEST_TIME 40 11115
TEST_TIME 41 10934
TEST_TIME 42 10976
TEST_TIME 43 10843
TEST_TIME 44 10851
TEST_TIME 45 10895
TEST_TIME 46 10772
TEST_TIME 47 10664
TEST_TIME 48 10544
TEST_TIME 49 10436
TEST_TIME 50 10493
TEST_TIME 51 10433
TEST_TIME 52 10400
TEST_TIME 53 10350
TEST_TIME 54 10448
TEST_TIME 55 10473
TEST_TIME 56 10451
TEST_TIME 57 10375
TEST_TIME 58 10425
TEST_TIME 59 10480
TEST_TIME 60 10590
TEST_TIME 61 10529
TEST_TIME 62 10662
TEST_TIME 63 10686
TEST_TIME 64 10730
TEST_TIME 65 10646
TEST_TIME 66 10527
TEST_TIME 67 10548
TEST_TIME 68 10430
TEST_TIME 69 10445
TEST_TIME 70 10425
TEST_TIME 71 10345
TEST_TIME 72 10308
TEST_TIME 73 10297
TEST_TIME 74 10246
TEST_TIME 75 10144
TEST_TIME 76 10116
TEST_TIME 77 10134
TEST_TIME 78 10104
TEST_TIME 79 10154
TEST_TIME 80 10143
TEST_TIME 81 10165
TEST_TIME 82 10117
TEST_TIME 83 10106
TEST_TIME 84 10178
TEST_TIME 85 10227
TEST_TIME 86 10201
TEST_TIME 87 10219
TEST_TIME 88 10200
TEST_TIME 89 10169
TEST_TIME 90 10159
TEST_TIME 91 10090
TEST_TIME 92 10045
TEST_TIME 93 10012
TEST_TIME 94 9959
TEST_TIME 95 9947
TEST_TIME 96 9910
TEST_TIME 97 9911
TEST_TIME 98 9949
TEST_TIME 99 9970
TEST_TIME 100 9955
TEST_TIME 101 10007
TEST_TIME 102 10025
TEST_TIME 103 10033
TEST_TIME 104 9987
TEST_TIME 105 10023
TEST_TIME 106 10062
TEST_TIME 107 10051
TEST_TIME 108 10001
TEST_TIME 109 9963
TEST_TIME 110 9909
TEST_TIME 111 9882
TEST_TIME 112 9832
TEST_TIME 113 9760
TEST_TIME 114 9839
TEST_TIME 115 9800
TEST_TIME 116 9803
TEST_TIME 117 9819
TEST_TIME 118 9799
TEST_TIME 119 9792
TEST_TIME 120 9711

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-12-2020 19:28:09 to 06-12-2020 19:28:12.

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 1614699 1614699 0 0.00 0 36474 5 0 0
doc_list_biud 1614699 1614699 0 0.00 0 55393 21 0 0
sp_add_invoice_to_stock 5334 5238 96 1.79 39 195231 15482 0 96
sp_cancel_adding_invoice 6085 6085 0 0.00 3 105236 639 0 0
sp_cancel_client_order 1869 1869 0 0.00 4 6669 238 0 0
sp_cancel_customer_reserve 588308 588308 0 0.00 1 55394 46 0 0
sp_cancel_pay_from_customer 740 740 0 0.00 3 8266 90 0 0
sp_cancel_pay_to_supplier 469 469 0 0.00 3 8814 93 0 0
sp_cancel_supplier_invoice 6639 6633 6 0.09 1 28514 594 0 6
sp_cancel_supplier_order 415 415 0 0.00 5 886035 82569 0 0
sp_cancel_write_off 10842 10842 0 0.00 1 13788 91 0 0
sp_client_order 21697 21697 0 0.00 4 39121 379 0 0
sp_customer_reserve 485180 485180 0 0.00 0 123696 154 0 0
sp_fill_shopping_cart 33415 33415 0 0.00 1 8348 31 0 0
sp_fill_shopping_cart_clo_res 485174 485174 0 0.00 0 15185 13 0 0
sp_get_clo_for_invoice 5227 5227 0 0.00 0 21731 269 0 0
sp_kill_cost_storno 18136 18136 0 0.00 0 16608 45 0 0
sp_kill_qstorno_ret_qs2qd 1194506 1194506 0 0.00 0 55389 25 0 0
sp_kill_qty_storno 629823 629823 0 0.00 0 55393 54 0 0
sp_lock_selected_doc 21858 21858 0 0.00 0 9387 7 0 0
sp_make_cost_storno 29228 29228 0 0.00 0 36469 49 0 0
sp_multiply_rows_for_pdistr 29228 29228 0 0.00 0 17516 28 0 0
sp_multiply_rows_for_qdistr 21697 21697 0 0.00 0 16826 180 0 0
sp_pay_from_customer 7452 7452 0 0.00 4 17546 108 0 0
sp_pay_to_supplier 6105 6105 0 0.00 5 16919 135 0 0
sp_payment_common 13557 13557 0 0.00 1 11301 32 0 0
sp_qd_handle_on_cancel_clo 1869 1869 0 0.00 0 5498 213 0 0
sp_qd_handle_on_invoice_upd_sts 11310 11310 0 0.00 0 19101 258 0 0
sp_qd_handle_on_reserve_upd_sts 10446 10446 0 0.00 0 15240 54 0 0
sp_reserve_write_off 10446 10446 0 0.00 6 16813 159 0 0
sp_supplier_invoice 5819 5819 0 0.00 6 87191 2671 0 0
sp_supplier_order 5910 5910 0 0.00 5 43387 1139 0 0
srv_aggregate_perf_data 117 117 0 0.00 2647 162829 17531 0 0
srv_fill_mon_cache_memory 134 134 0 0.00 1026 156833 40325 0 0
srv_find_qd_qs_mism 1114885 1114885 0 0.00 0 20883 4 0 0
srv_make_invnt_saldo 603 603 0 0.00 42 48873 962 0 0
srv_make_money_saldo 793 793 0 0.00 1 512 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 139276 275594 200932 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5239 5239 0 0.00 0 8191 125 0 0
t$perf-norm:sp_cancel_adding_invoice 461 461 0 0.00 0 9453 103 0 0
t$perf-norm:sp_cancel_client_order 1869 1869 0 0.00 0 5523 14 0 0
t$perf-norm:sp_cancel_customer_reserve 744 744 0 0.00 0 12066 30 0 0
t$perf-norm:sp_cancel_pay_from_customer 740 740 0 0.00 0 2312 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 469 469 0 0.00 0 929 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 4878 26 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 14643 1317 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 4709 8 0 0
t$perf-norm:sp_client_order 21697 21697 0 0.00 0 5236 12 0 0
t$perf-norm:sp_customer_reserve 1074 1074 0 0.00 0 6666 11 0 0
t$perf-norm:sp_pay_from_customer 7452 7452 0 0.00 0 5108 8 0 0
t$perf-norm:sp_pay_to_supplier 6105 6105 0 0.00 0 6596 11 0 0
t$perf-norm:sp_reserve_write_off 10446 10446 0 0.00 0 9007 12 0 0
t$perf-norm:sp_supplier_invoice 5819 5819 0 0.00 0 6196 19 0 0
t$perf-norm:sp_supplier_order 5910 5910 0 0.00 0 6337 11 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 183 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 134 134 0 0.00 0 653 6 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 1734 16 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 6620 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10638 10446 192 1.80 0 5604 17 0 192
v_all_customers 39510 39510 0 0.00 0 19 0 0 0
v_all_suppliers 32564 32564 0 0.00 0 35 1 0 0
v_all_wares 43394 43394 0 0.00 0 49 1 0 0
v_cancel_adding_invoice 922 922 0 0.00 0 2078 10 0 0
v_cancel_client_order 3738 3738 0 0.00 0 3094 5 0 0
v_cancel_customer_prepayment 1480 1480 0 0.00 0 3873 8 0 0
v_cancel_customer_reserve 1488 1488 0 0.00 0 2649 7 0 0
v_cancel_payment_to_supplier 938 938 0 0.00 0 3556 16 0 0
v_cancel_supplier_invoice 884 872 12 1.35 0 525 12 0 12
v_cancel_supplier_order 830 830 0 0.00 0 2043 8 0 0
v_cancel_write_off 2110 2110 0 0.00 0 2110 14 0 0
v_max_id_clo_ord 5909 5909 0 0.00 0 134 1 0 0
v_max_id_clo_res 1074 1074 0 0.00 0 1371 10 0 0
v_max_id_ord_sup 5809 5809 0 0.00 0 2174 2 0 0
v_max_non_paid_invoice 1541 1541 0 0.00 0 3044 5 0 0
v_max_non_paid_realizn 4015 4015 0 0.00 0 4962 5 0 0
v_min_id_clo_ord 5909 5909 0 0.00 0 3028 6 0 0
v_min_id_clo_res 1074 1074 0 0.00 0 3124 11 0 0
v_min_id_ord_sup 5809 5809 0 0.00 0 4240 5 0 0
v_min_non_paid_invoice 6105 6105 0 0.00 0 8306 22 0 0
v_min_non_paid_realizn 7452 7452 0 0.00 0 10539 22 0 0
v_our_firm 10758 10758 0 0.00 0 13 1 0 0
v_reserve_write_off 20892 20892 0 0.00 0 3921 5 0 0
x_lock_depdocs_on_canc_invoice 12282 12282 0 0.00 0 22763 90 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 6436 252 0 0
x_make_qstorno_1000_1200 5910 5910 0 0.00 1 43375 1071 0 0
x_make_qstorno_1200_2000 5819 5819 0 0.00 3 87185 2569 0 0
x_make_qstorno_2100_3300 485180 485180 0 0.00 0 123695 139 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-12-2020 19:28:13 to 06-12-2020 19:28:17.

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:06 2 8192000000 8798851264 8809447424 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 18465 8192000000 10250745136 10562613248 981970768 10.703 76 57 114 1 1004586496 2870304 19745424
16:57:38 47926 8192000000 10374478896 10696282112 1408861664 14.674 100 88 176 1 1442142784 5110320 28170800
16:58:36 24634 8192000000 10407630000 10734104576 1454340736 15.076 100 91 183 0 1491643040 7441184 29861120
16:59:15 19990 8192000000 10426961296 10755063808 1475491280 15.262 100 94 188 0 1514269392 8438608 30339504
16:59:49 18470 8192000000 10436939728 10768990208 1491335984 15.401 100 91 182 0 1529565968 9283072 28946912
17:00:18 17637 8192000000 10443704208 10781794304 1499511760 15.472 100 85 170 0 1536550128 9712064 27326304
17:00:42 18707 8192000000 10466562960 10808664064 1525431280 15.697 100 85 170 0 1562361376 10149552 26780544
17:01:17 18666 8192000000 10500684784 10849861632 1552278384 15.930 100 82 164 0 1587930016 10588096 25063536
17:01:48 15293 8192000000 10529765856 10880327680 1584529312 16.207 100 84 169 0 1621483856 11332016 25622528
17:02:11 17131 8192000000 10549253072 10905141248 1604522528 16.378 100 83 166 1 1642369104 12309200 25537376
17:02:35 11015 8192000000 10562600400 10919174144 1616168736 16.477 100 80 160 0 1652015712 11895920 23951056
17:02:58 10057 8192000000 10585668144 10945511424 1638491248 16.667 100 83 166 1 1676662512 13309584 24861680
17:03:15 9814 8192000000 10608248192 10974826496 1663476512 16.878 100 81 163 0 1700347616 12709264 24161840
17:03:33 5543 8192000000 10630070080 10997321728 1680857600 17.025 100 84 167 0 1718587568 13117616 24612352
17:03:46 5124 8192000000 10627432000 10997477376 1691254656 17.112 100 82 164 2 1727672416 12475424 23942336
17:03:58 4931 8192000000 10645182096 11016916992 1704663632 17.224 100 79 158 1 1739949840 11787168 23499040
17:04:12 5752 8192000000 10662723680 11033731072 1725132336 17.395 100 82 163 1 1761872720 13396976 23343408
17:04:24 5377 8192000000 10675590688 11047616512 1737189648 17.495 100 78 154 2 1772325776 13281376 21854752
17:04:36 5286 8192000000 10682432176 11062652928 1753294112 17.629 100 78 156 1 1787627968 12823168 21510688
17:04:49 3533 8192000000 10703552864 11079507968 1762966208 17.709 100 86 172 1 1801811040 14471616 24373216
17:04:59 3050 8192000000 10707385680 11088252928 1767243136 17.744 100 83 166 1 1805156368 14704864 23208368
17:05:09 2639 8192000000 10725487696 11099668480 1775669056 17.814 100 88 175 1 1814627568 15106592 23851920
17:05:18 3510 8192000000 10723342592 11101151232 1778573344 17.838 100 85 170 0 1817621856 15798416 23250096
17:05:28 2661 8192000000 10729100208 11108245504 1784703856 17.888 100 88 176 0 1824891664 16228880 23958928
17:05:38 5493 8192000000 10734094736 11118063616 1793329184 17.959 100 85 169 0 1831282160 14546416 23406560
17:05:50 1598 8192000000 10740215728 11117694976 1798693728 18.003 100 89 178 2 1837707200 13354128 25659344
17:05:58 2208 8192000000 10747124704 11133382656 1808103920 18.080 100 86 173 0 1846965152 13636800 25224432
17:06:07 2346 8192000000 10759852864 11140083712 1817272992 18.155 100 81 162 1 1852980672 11750368 23957312
17:06:15 1977 8192000000 10763653040 11148877824 1824861440 18.217 100 88 175 0 1862438720 12588704 24988576
17:06:24 2331 8192000000 10768498736 11157532672 1831585408 18.272 100 87 174 0 1869752208 13769664 24397136
17:06:32 1786 8192000000 10782372384 11166187520 1839876320 18.340 100 92 182 1 1880934832 14176048 26882464
17:06:41 1964 8192000000 10787226576 11173126144 1846155328 18.391 100 94 189 1 1886548944 13749088 26644528
17:06:49 1294 8192000000 10795281568 11178381312 1849109216 18.415 100 90 182 1 1888939376 14115792 25714368
17:06:57 1383 8192000000 10793700576 11179270144 1852492592 18.442 100 91 182 0 1890425280 12915520 25017168
17:07:04 1739 8192000000 10801508176 11185770496 1851766752 18.436 100 95 190 1 1892198432 13217072 27214608
17:07:12 1260 8192000000 10790486256 11182501888 1852473344 18.442 100 82 166 2 1888939936 12237296 24229296
17:07:20 2341 8192000000 10800972160 11189272576 1856951456 18.479 100 84 168 2 1893166208 12876464 23338288
17:07:28 8146 8192000000 10799035024 11196182528 1859382864 18.498 100 82 164 1 1898465920 16036832 23046224
17:07:50 2459 8192000000 10789877568 11196080128 1861579984 18.516 100 66 133 1 1890954576 10711376 18663216
17:08:00 3478 8192000000 10781921888 11193499648 1861597328 18.516 100 55 110 1 1888723424 11191328 15934768
17:08:10 4953 8192000000 10776165952 11192528896 1860170976 18.505 100 46 90 0 1882760576 10386720 12202880
17:08:23 4495 8192000000 10776569872 11192197120 1861773648 18.518 100 38 76 1 1881696688 9342432 10580608
17:08:33 6323 8192000000 10786619744 11203674112 1867063536 18.561 100 41 85 2 1886673648 8226784 11383328
17:08:46 3414 8192000000 10786643840 11204583424 1874020656 18.617 100 43 87 2 1895252768 9104704 12127408
17:08:56 5259 8192000000 10781822432 11209625600 1877491072 18.645 100 36 72 0 1899608752 11751216 10366464
17:09:07 12735 8192000000 10790272928 11214872576 1875556832 18.629 100 23 47 0 1888133808 6016320 6560656
17:09:29 6492 8192000000 10785971344 11214008320 1882798608 18.688 100 20 40 0 1898116784 10378976 4939200
17:09:41 4665 8192000000 10781015328 11216764928 1881868848 18.680 100 26 54 1 1896414400 6548160 7997392
17:09:52 12655 8192000000 10787144704 11215622144 1881333200 18.676 100 9 18 0 1888818528 4977120 2508208
17:10:11 14910 8192000000 10807647616 11223777280 1885703888 18.711 100 32 65 0 1901799248 6928560 9166800
17:10:34 65794 8192000000 10797167840 11234172928 1887416624 18.725 100 28 56 0 1901334352 5797104 8120624
17:11:48 14981 8192000000 10820071360 11247726592 1892421904 18.765 100 22 44 0 1904648800 6051328 6175568
17:12:11 4639 8192000000 10822769344 11247898624 1904191936 18.860 100 39 76 2 1922059232 7069168 10798128
17:12:22 6704 8192000000 10832996304 11255455744 1903220768 18.852 100 37 74 1 1919531504 5897088 10413648
17:12:37 7336 8192000000 10830140128 11255820288 1907891008 18.890 100 35 70 2 1924928512 7113120 9924384
17:12:51 8583 8192000000 10823841280 11254661120 1903139520 18.852 100 21 42 1 1914741008 5397424 6204064
17:13:07 9830 8192000000 10818095168 11253293056 1905897776 18.874 100 30 58 1 1920325520 6021648 8406096
17:13:24 13770 8192000000 10825748560 11260563456 1906320320 18.877 100 16 33 1 1916078016 5414192 4343504
17:13:44 9662 8192000000 10815193008 11258245120 1909849040 18.905 100 20 40 1 1921296080 5767056 5679984
17:14:00 8969 8192000000 10820751872 11261726720 1910751664 18.913 100 11 23 2 1919622544 5902352 2968528
17:14:17 10539 8192000000 10822245376 11255414784 1887893696 18.729 99 28 57 0 1902129328 6960496 7275136
17:14:37 9410 8192000000 10810879616 11247001600 1885894112 18.713 99 12 24 0 1895615952 5875968 3845872
17:14:52 7441 8192000000 10800439520 11244212224 1883009584 18.689 99 15 30 2 1893014048 5411696 4592768
17:15:06 8981 8192000000 10814023168 11246931968 1894692752 18.784 100 19 38 0 1906503760 6259744 5551264
17:15:25 60699 8192000000 10810856944 11240943616 1834480736 18.296 96 38 74 0 1850454768 5291552 10682480
17:16:36 12056 8192000000 10795298240 11229487104 1834021568 18.292 97 18 36 1 1844431056 5231920 5177568
17:16:58 6681 8192000000 10777911312 11208216576 1835809280 18.307 98 21 42 4 1847054320 5253536 5991504
17:17:12 9006 8192000000 10793913920 11216830464 1843073008 18.366 98 33 67 1 1858505840 6248064 9184768
17:17:31 7048 8192000000 10783976384 11203313664 1826895344 18.234 97 31 60 3 1845488736 10838304 7755088
17:17:44 8696 8192000000 10770460224 11187720192 1800943280 18.022 97 15 30 1 1811364976 5561968 4859728
17:18:02 8859 8192000000 10782379888 11208798208 1863015776 18.528 100 31 61 0 1878103104 5296480 9790848
17:18:17 9463 8192000000 10752266096 11165167616 1758618608 17.673 95 25 50 1 1775631472 9809008 7203856
17:18:37 11924 8192000000 10684360992 11098431488 1630205856 16.597 90 20 39 0 1640661584 4893152 5562576
17:18:56 11438 8192000000 10673402960 11090309120 1688074640 17.085 95 22 44 2 1699556192 5038160 6443392
17:19:14 11033 8192000000 10692621536 11109748736 1751607968 17.615 98 25 49 2 1765164624 6375936 7180720
17:19:34 9768 8192000000 10687939680 11104284672 1719614736 17.349 96 26 46 4 1731603280 4842080 7146464
17:19:54 19008 8192000000 10702054480 11113259008 1757884416 17.667 99 21 40 0 1769166912 5477424 5805072
17:20:20 57699 8192000000 10707999088 11136782336 1764791024 17.724 98 31 62 5 1783598656 9485600 9322032
17:21:24 6528 8192000000 10731667232 11151962112 1815230224 18.139 100 29 57 1 1829984864 6916624 7838016
17:21:37 6464 8192000000 10736522080 11154554880 1805085504 18.056 99 29 58 0 1820553184 7766544 7701136
17:21:49 8519 8192000000 10747059808 11162923008 1820773952 18.184 100 20 39 2 1832147408 5613968 5759488
17:22:04 5901 8192000000 10745374400 11172671488 1829981280 18.259 100 20 40 3 1845984944 10603040 5400624
17:22:17 8387 8192000000 10753802480 11176964096 1841439296 18.353 100 30 59 3 1856051328 5623472 8988560
17:22:37 6578 8192000000 10762709008 11180204032 1841702032 18.355 100 35 70 1 1857652240 5670160 10280048
17:22:50 6131 8192000000 10760963952 11183587328 1847227680 18.400 100 31 61 5 1861603472 6049088 8326704
17:23:02 17151 8192000000 10762513072 11194138624 1847950032 18.405 100 20 39 3 1857779904 4675072 5154800
17:23:25 6340 8192000000 10773145408 11198193664 1854787984 18.461 100 19 38 1 1866266608 5213360 6265264
17:23:38 11724 8192000000 10772110688 11202756608 1859748384 18.501 100 17 32 1 1873565648 9187488 4629776
17:23:56 12213 8192000000 10769268416 11202179072 1863570096 18.532 100 18 36 0 1874144480 5278144 5296240
17:24:16 11692 8192000000 10778754112 11212054528 1868007600 18.568 100 19 38 2 1879512592 5730288 5774704
17:24:38 11413 8192000000 10778563616 11217694720 1871173520 18.594 100 22 43 2 1884329360 6587136 6568704
17:24:57 64795 8192000000 10811109968 11228893184 1880807104 18.672 100 29 58 0 1895418064 5079344 9531616
17:26:19 15358 8192000000 10797254800 11225751552 1883367296 18.692 100 21 41 0 1898604880 9976368 5261216
17:26:43 7660 8192000000 10799570880 11231522816 1884756880 18.704 100 28 56 1 1899303440 6748928 7797632
17:26:59 4128 8192000000 10811086816 11235086336 1888047664 18.730 100 31 62 0 1902820816 5415312 9357840
17:27:09 3182 8192000000 10821079584 11247988736 1905242272 18.868 100 36 73 3 1921987296 6055136 10689888
17:27:22 21883 8192000000 10849004832 11264569344 1916373504 18.958 100 47 95 1 1936207792 6375120 13459168
17:27:51 7628 8192000000 10852957104 11272794112 1927043568 19.043 100 48 95 1 1948090416 8078400 12968448
17:28:10 21813 8192000000 10860597872 11281801216 1915050560 18.947 99 47 94 0 1936581968 8476720 13054688
17:28:39 8477 8192000000 10856333968 11285168128 1931057808 19.075 100 40 80 0 1951403264 8407088 11938368
17:28:59 18132 8192000000 10855320960 11287195648 1918137760 18.972 99 40 80 2 1940831728 11143280 11550688
17:29:24 20647 8192000000 10857506240 11281928192 1917266368 18.965 99 38 74 0 1938860208 10699728 10894112
17:29:55 11168 8192000000 10863043040 11289063424 1925144096 19.028 99 45 90 3 1952537600 13896336 13497168
17:30:15 19890 8192000000 10901390288 11319599104 1947225600 19.204 100 56 109 1 1978298064 15215616 15856848
17:30:44 10416 8192000000 10884519024 11310784512 1935188224 19.108 99 47 94 1 1965208112 16667408 13352480
17:31:04 15207 8192000000 10900477280 11324739584 1952842848 19.249 100 48 94 1 1983432688 16276752 14313088
17:31:29 20700 8192000000 10903178144 11334557696 1962687488 19.327 100 47 93 1 1994442032 17933152 13821392
17:31:58 34818 8192000000 10897483584 11335856128 1966792320 19.360 100 50 98 2 1999258336 18198624 14267392
17:32:56 46025 8192000000 10903068736 11345981440 1956265712 19.276 99 33 64 1 1987309440 21660912 9382816
17:34:01 33251 8192000000 10918652784 11360706560 1963387280 19.333 99 35 69 0 2000850976 26582416 10881280
17:34:47 20397 8192000000 10914398400 11362217984 1975302432 19.427 100 31 60 0 2011580624 26310688 9967504
17:35:22 4934 8192000000 10945659600 11378692096 1991307904 19.554 100 51 100 2 2036178688 28804240 16066544
17:35:34 7843 8192000000 10943363344 11375943680 1980415024 19.468 99 51 100 3 2023638496 28425072 14798400
17:35:48 5982 8192000000 10959898592 11385090048 1996093456 19.592 100 61 122 0 2042938752 28085584 18759712
17:36:03 3357 8192000000 10966905456 11392593920 2004426432 19.658 100 69 139 1 2055437696 29791424 21219840
17:36:15 2229 8192000000 10965179104 11381460992 1996048880 19.592 100 74 148 2 2049999872 31297568 22653424
17:36:24 1928 8192000000 10930844224 11349164032 1943662128 19.176 98 66 132 0 1996645152 31784912 21198112
17:36:34 3384 8192000000 10952986064 11374538752 1980551424 19.469 100 65 130 3 2034344688 32998640 20794624
17:36:44 5733 8192000000 10949181232 11365670912 1980153600 19.466 100 67 134 1 2032505280 32676656 19675024
17:37:02 2975 8192000000 10944782224 11358887936 1937455632 19.126 97 78 155 1 1994832752 33891712 23485408
17:37:15 2855 8192000000 10952172496 11372138496 1986582592 19.517 100 75 150 1 2041102384 31669872 22849920
17:37:27 3177 8192000000 10949944480 11377913856 1988740352 19.534 100 60 119 4 2039321248 31671040 18909856
17:37:37 3183 8192000000 10957899744 11374977024 1986641248 19.517 100 68 135 0 2039701520 32309856 20750416
17:37:47 1024 8192000000 10966175312 11377418240 1992575120 19.564 100 84 168 2 2050736784 32496912 25664752
17:37:57 1857 8192000000 10958237872 11370053632 1985901248 19.511 100 89 178 3 2046109184 33228080 26979856
17:38:07 8531 8192000000 10957071248 11376541696 1985152032 19.505 100 75 150 1 2041776528 33855072 22769424
17:38:24 2567 8192000000 10968850992 11388125184 1994743456 19.581 100 78 155 0 2054506288 36070144 23692688
17:38:34 2252 8192000000 10982115360 11390394368 1995625856 19.588 100 90 181 2 2059545552 35957456 27962240
17:38:43 3006 8192000000 10947268304 11356344320 1966788736 19.360 99 87 175 2 2030523600 36817792 26917072
17:38:52 3163 8192000000 10946196720 11367165952 1961940896 19.321 99 77 153 2 2022932512 37903056 23088560
17:39:03 1036 8192000000 10963775088 11373740032 1976962768 19.441 100 95 190 3 2045477152 39300336 29214048
17:39:10 8673 8192000000 10938707584 11379191808 1982450528 19.484 100 48 94 1 2032126800 34998704 14677568
17:39:34 4350 8192000000 10943973536 11380994048 1979941536 19.464 100 49 98 1 2032989824 36840544 16207744
17:39:46 11664 8192000000 10949685712 11389378560 1983002672 19.488 100 34 68 1 2030326192 35958064 11365456
17:40:06 4490 8192000000 10948588688 11379023872 1941368336 19.158 97 56 112 0 1997115056 38016240 17730480
17:40:19 7899 8192000000 10946721632 11371130880 1977190480 19.442 100 67 133 2 2035916976 38069072 20657424
17:40:37 2575 8192000000 10946363728 11362340864 1967215040 19.363 100 89 177 0 2035494640 41063680 27215920
17:40:46 4277 8192000000 10948015456 11364323328 1950996656 19.234 99 80 159 0 2017407536 42122096 24288784
17:40:58 4716 8192000000 10955235104 11375165440 1970982048 19.393 100 79 158 2 2038800272 42979472 24838752
17:41:10 4749 8192000000 10956408400 11373228032 1971882880 19.400 100 77 154 1 2040605344 44694560 24027904
17:41:25 1351 8192000000 10955528896 11370483712 1954558480 19.263 99 77 154 0 2022825280 43701520 24565280
17:41:36 5461 8192000000 10956880272 11378003968 1971046272 19.394 100 68 136 1 2038020192 45571888 21402032
17:41:49 2006 8192000000 10975865808 11388698624 1985178288 19.506 100 83 166 1 2059170800 47530224 26462288
17:41:58 9450 8192000000 10943376224 11372081152 1970657888 19.391 100 64 128 0 2033488320 42960608 19869824
17:42:23 13153 8192000000 10911085200 11351506944 1887591888 18.726 96 39 78 0 1944331024 43428224 13310912
17:42:45 25306 8192000000 10898433104 11334189056 1925519744 19.031 99 32 64 3 1969730752 33268960 10942048
17:43:41 15978 8192000000 10924015856 11369754624 1945940160 19.194 99 31 61 1 1991458224 35688384 9829680
17:44:14 21389 8192000000 10905580208 11351093248 1937884144 19.130 99 25 50 1 1983226608 36816288 8526176
17:44:49 22627 8192000000 10906802848 11359444992 1957724176 19.288 100 26 52 1 1995231632 29291328 8216128
17:45:18 21513 8192000000 10905545104 11356901376 1954642560 19.263 100 29 58 1 1997261504 33144768 9474176
17:45:46 21302 8192000000 10880421664 11327877120 1887399872 18.725 97 22 44 1 1928267840 33145568 7722400
17:46:36 13839 8192000000 10899574272 11345862656 1925438432 19.030 100 21 42 0 1973824864 40248176 8138256
17:46:59 24403 8192000000 10913208848 11362996224 1903467760 18.854 98 25 50 2 1954983072 42585600 8929712
17:47:31 19060 8192000000 10901038560 11366604800 1933879312 19.098 99 22 44 1 1974328112 33138240 7310560
17:48:13 35655 8192000000 10859517680 11316482048 1863580848 18.532 96 9 18 1 1884637904 18158848 2898208
17:49:15 46411 8192000000 10863872256 11318910976 1909301360 18.901 99 25 50 0 1933756272 16539680 7915232
17:50:09 35384 8192000000 10862242992 11313311744 1918368288 18.974 100 28 56 2 1942692032 14995456 9328288
17:50:52 44346 8192000000 10829054304 11298336768 1869236832 18.578 98 18 36 2 1893955040 19500976 5217232
17:51:52 76396 8192000000 10836909776 11282579456 1815976608 18.145 95 10 20 2 1831574096 13048576 2548912
17:53:15 103717 8192000000 10864700480 11323645952 1902101200 18.843 99 34 69 1 1924707744 13266784 9339760
17:55:16 121989 8192000000 10896058848 11327029248 1923262224 19.013 99 31 62 1 1949623984 15977504 10384256
17:57:26 28322 8192000000 10917865504 11341049856 1952119168 19.243 100 42 83 2 1971673312 8703232 10850912
17:58:02 100644 8192000000 10879817776 11345260544 1920723232 18.993 98 21 42 1 1941810864 15819312 5268320
17:59:49 126403 8192000000 10902911088 11366817792 1940136384 19.148 99 5 10 1 1952760176 11713744 910048
18:02:06 156833 8192000000 10911729648 11380109312 1938448528 19.134 98 7 14 0 1962573264 22290064 1834672
18:04:49 61730 8192000000 10918578368 11377614848 1970830624 19.392 99 37 73 2 1994025664 12244256 10950784
18:06:56 81858 8192000000 10927578288 11395256320 1972107232 19.402 99 22 44 1 1990594144 12340624 6146288
18:08:29 26316 8192000000 10930285600 11390078976 2002800112 19.645 100 41 80 1 2025692416 11299344 11592960
18:09:45 89897 8192000000 10929546976 11396280320 1980255504 19.467 99 24 49 2 1998774016 11268592 7249920
18:11:38 65648 8192000000 10898612736 11363586048 1948925776 19.218 98 20 39 0 1968834112 14244192 5664144
18:12:51 29081 8192000000 10893996656 11361611776 1961802368 19.320 99 19 39 1 1975596144 8951648 4842128
18:13:37 103660 8192000000 10906125248 11387654144 1951112064 19.235 98 11 21 1 1962628016 8455632 3060320
18:15:26 98796 8192000000 10895707984 11375022080 1928389632 19.054 97 16 32 0 1947211680 14092928 4729120
18:17:25 58007 8192000000 10883634752 11360632832 1936912112 19.122 98 16 32 2 1949509120 7798480 4798528
18:19:55 65029 8192000000 10913971152 11390300160 1982880576 19.487 100 14 28 1 2000666816 13560272 4225968
18:21:06 60447 8192000000 10882604640 11365138432 1888356656 18.733 95 13 26 1 1908811840 16602752 3852432
18:22:15 74093 8192000000 10870177888 11343372288 1866511776 18.556 95 12 24 0 1881153552 11298016 3343760
18:23:35 66741 8192000000 10875905552 11329421312 1852530704 18.443 94 25 50 0 1871307216 11341264 7435248
18:25:05 62377 8192000000 10851419632 11316158464 1866989856 18.560 96 29 58 0 1902318464 26790320 8538288
18:26:35 122690 8192000000 10824973248 11286556672 1664732032 16.889 86 20 40 2 1681435504 11449296 5254176
18:28:44 61059 8192000000 10855477488 11311652864 1893721840 18.776 98 26 51 1 1921072288 19388976 7961472
18:29:51 16361 8192000000 10875731968 11320397824 1924276080 19.021 100 34 66 2 1941054160 7669952 9108128
18:30:14 56404 8192000000 10884108848 11345227776 1911269984 18.917 98 32 64 0 1932089072 12138752 8680336
18:31:17 49245 8192000000 10885326592 11330027520 1887783056 18.728 97 22 43 1 1902145024 8342752 6019216
18:32:13 11735 8192000000 10870272816 11310145536 1922874336 19.010 99 57 114 2 1948091232 8195136 17021760
18:32:31 70907 8192000000 10869211104 11326521344 1940173568 19.148 100 37 74 2 1962222768 10405296 11643904
18:34:19 63770 8192000000 10854941696 11331092480 1933249376 19.093 100 17 34 0 1950177792 12071456 4856960
18:35:31 5621 8192000000 10877848048 11326406656 1943696720 19.176 100 28 55 1 1960235888 8039520 8499648
18:35:43 41826 8192000000 10866975232 11326681088 1911551200 18.919 98 46 92 1 1935457008 10748032 13157776
18:36:36 97356 8192000000 10850804128 11320619008 1866776752 18.558 96 12 24 1 1879044320 8885328 3382240
18:38:20 74763 8192000000 10868825072 11336790016 1921954400 19.002 99 11 22 2 1934437312 9463760 3019152
18:39:43 48708 8192000000 10851823344 11323547648 1907323312 18.885 98 20 40 0 1925900768 12361232 6216224
18:40:38 79724 8192000000 10855013536 11328565248 1901747008 18.840 98 16 32 0 1919249440 13271888 4230544
18:42:09 90537 8192000000 10850928976 11323371520 1901248144 18.836 98 10 20 0 1915481024 11726496 2506384
18:43:47 66888 8192000000 10878171600 11359064064 1959347760 19.301 100 22 44 2 1979891200 13502096 7041344
18:45:16 61907 8192000000 10899299616 11366064128 1945394192 19.190 99 21 42 1 1966793488 14659872 6739424
18:46:26 49032 8192000000 10898664368 11364519936 1951586944 19.239 99 22 44 1 1970125600 12093680 6444976
18:47:23 34210 8192000000 10883244768 11348242432 1921555488 18.999 98 27 54 1 1940937920 11924272 7458160
18:48:29 30797 8192000000 10895020848 11349872640 1943735760 19.177 99 26 52 1 1961251856 10562976 6953120
18:49:06 25327 8192000000 10912559712 11371630592 1968774288 19.376 100 39 78 2 1990186848 10412096 11000464
18:50:14 33925 8192000000 10929406416 11387604992 1983822096 19.495 100 42 84 1 2011052832 15407712 11823024
18:50:56 32287 8192000000 10917637824 11396280320 1990034480 19.544 100 23 46 1 2014520976 17921520 6564976
18:51:52 63376 8192000000 10905093792 11390828544 1965189696 19.347 99 8 16 0 1985008704 17806272 2012736
18:53:07 83618 8192000000 10914400128 11380498432 1946372896 19.198 98 16 32 0 1964363408 13748928 4241584
18:54:39 74717 8192000000 10912431056 11359780864 1893049616 18.770 95 17 34 0 1911598704 14082480 4466608
18:56:07 88586 8192000000 10925996448 11383660544 1980774384 19.471 100 24 48 0 2001636688 13336560 7525744
18:57:44 88155 8192000000 10914774560 11372359680 1934683280 19.104 97 23 46 0 1949420816 7948080 6789456
18:59:19 61142 8192000000 10900282784 11379290112 1973408032 19.412 99 22 44 0 1989520912 10467616 5645264
19:00:26 60293 8192000000 10895660576 11375554560 1959961440 19.306 99 9 18 0 1970367456 7676208 2729808
19:02:42 70925 8192000000 10906522480 11373117440 1921442096 18.998 96 11 22 2 1938682256 13927456 3312704
19:04:17 58000 8192000000 10918023600 11396616192 1954091648 19.259 98 17 32 2 1977634240 18373872 5168720
19:05:21 79264 8192000000 10926690560 11400957952 1976908448 19.440 99 17 34 0 2000737728 18783408 5045872
19:06:47 59737 8192000000 10936701472 11410677760 1987851328 19.527 99 18 36 0 2006818800 13481984 5485488
19:07:54 54186 8192000000 10912453664 11391442944 1978138384 19.450 99 11 22 0 1993432784 12240896 3053504
19:09:17 48324 8192000000 10906308016 11383701504 1959331792 19.301 98 23 44 0 1974387888 8279168 6776928
19:10:16 89556 8192000000 10892508592 11332780032 1793380336 17.960 90 23 46 0 1807192832 7557200 6255296
19:11:55 20322 8192000000 10896752592 11338018816 1918243520 18.973 98 48 94 2 1949699296 17777200 13678576
19:12:23 43310 8192000000 10863037184 11339632640 1906912128 18.882 98 25 50 1 1927208368 13093360 7202880
19:13:16 90772 8192000000 10859991856 11321909248 1810663264 18.101 93 10 20 0 1829917136 16828448 2425424
19:14:58 18903 8192000000 10872166656 11311628288 1913435648 18.934 99 34 68 1 1931365328 7690208 10239472
19:15:27 85553 8192000000 10865612544 11321528320 1885304128 18.708 97 45 90 1 1907697552 10095472 12297952
19:17:00 63579 8192000000 10873361840 11329896448 1902646656 18.848 98 34 64 2 1919305504 7966464 8692384
19:18:19 78867 8192000000 10878694240 11362254848 1952746704 19.248 100 10 20 1 1972185696 16618416 2820576
19:21:00 50174 8192000000 10850911632 11323834368 1906907392 18.882 98 14 28 2 1927591152 17114560 3569200
19:21:56 56580 8192000000 10838098720 11299631104 1859127424 18.496 96 26 52 1 1877706160 10995680 7583056
19:23:00 83487 8192000000 10843516304 11326021632 1893183744 18.771 98 11 22 1 1910442240 13711168 3547328
19:24:55 103565 8192000000 10858992528 11314937856 1846944896 18.397 95 10 20 0 1857035024 7285776 2804352
19:26:46 24554 8192000000 8987067040 9176440832 160983392 1.927 9 2 4 0 164795328 3391248 420688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:28, from 06-12-2020 19:28:19 to 06-12-2020 19:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-12-2020 19:28:48 to 06-12-2020 19:28:50.

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          251197
MON$OLDEST_ACTIVE               251198
MON$OLDEST_SNAPSHOT             251198
MON$NEXT_TRANSACTION            251198
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                       2030048
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:63: 
:64: mscs-test-161.budzdorov.ru    Sun Dec  6 19:27:14 2020
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
:67: 
:68: mscs-test-161.budzdorov.ru    Sun Dec  6 19:27:14 2020
:69:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:70: 
:71: 
:72: mscs-test-161.budzdorov.ru    Sun Dec  6 19:27:14 2020
:73:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:74: 
:75: 
:76: mscs-test-161.budzdorov.ru    Sun Dec  6 19:27:14 2020
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
:79: 
:80: mscs-test-161.budzdorov.ru    Sun Dec  6 19:27:14 2020
:81:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:82: 
--- end of diff output ---

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

06.12.20 19:28:51. 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-06 19:28:53 No severe PSQL-related problems occured
06.12.20 19:28:55. End of report.