Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.11.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 17101916 kB
MemAvailable 31401440 kB
Buffers 0 kB
Cached 14539716 kB
SwapCached 2912 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-10 19:27:02
DTS_END                         2020-11-10 19:27:02.0310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44746
TRN_ID                          248236
ATT_ID                          656
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: 9629.39 17568 1155527
customer order: creation 183.93 316 22072
customer order: refuse 15.23 313 1828
order to supplier: creation 48.13 1292 5775
order to supplier: removal 3.75 95829 450
invoice (draft): creation 47.90 3235 5748
invoice (draft): removal 56.78 779 6813
invoice accept: apply 42.95 16750 5154
invoice accept: cancel 51.29 777 6155
customer reserve: creation 3907.53 168 468904
customer reserve: removal 4967.18 56 596062
realization accept: apply 89.76 169 10771
realization accept: cancel 79.48 111 9538
payment from customer: creation 62.66 90 7519
payment from customer: removal 5.53 82 663
payment to supplier: creation 51.38 113 6166
payment to supplier: removal 3.77 59 452
service: total inventory turnovers 4.71 1125 565
service: total monetary turnovers 6.57 34 788
service: aggregate perf. data 0.83 22781 100
service: refresh index statistics 0.03 207286 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-11-2020 19:28:04 to 10-11-2020 19:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6192
TEST_TIME 2 5907
TEST_TIME 3 5106
TEST_TIME 4 6103
TEST_TIME 5 6231
TEST_TIME 6 5910
TEST_TIME 7 5658
TEST_TIME 8 5821
TEST_TIME 9 5794
TEST_TIME 10 5713
TEST_TIME 11 6257
TEST_TIME 12 6344
TEST_TIME 13 6925
TEST_TIME 14 7381
TEST_TIME 15 7701
TEST_TIME 16 7954
TEST_TIME 17 7978
TEST_TIME 18 8192
TEST_TIME 19 8489
TEST_TIME 20 8397
TEST_TIME 21 8566
TEST_TIME 22 8850
TEST_TIME 23 9344
TEST_TIME 24 10262
TEST_TIME 25 10586
TEST_TIME 26 10900
TEST_TIME 27 10699
TEST_TIME 28 10807
TEST_TIME 29 11058
TEST_TIME 30 11164
TEST_TIME 31 11189
TEST_TIME 32 10991
TEST_TIME 33 10896
TEST_TIME 34 10832
TEST_TIME 35 10684
TEST_TIME 36 10740
TEST_TIME 37 10773
TEST_TIME 38 10697
TEST_TIME 39 10628
TEST_TIME 40 10574
TEST_TIME 41 10558
TEST_TIME 42 10553
TEST_TIME 43 10575
TEST_TIME 44 10513
TEST_TIME 45 10448
TEST_TIME 46 10291
TEST_TIME 47 10136
TEST_TIME 48 10215
TEST_TIME 49 10199
TEST_TIME 50 10132
TEST_TIME 51 10103
TEST_TIME 52 9992
TEST_TIME 53 10014
TEST_TIME 54 10147
TEST_TIME 55 10120
TEST_TIME 56 10054
TEST_TIME 57 10006
TEST_TIME 58 9954
TEST_TIME 59 9902
TEST_TIME 60 9911
TEST_TIME 61 9818
TEST_TIME 62 9841
TEST_TIME 63 9856
TEST_TIME 64 9831
TEST_TIME 65 9814
TEST_TIME 66 9814
TEST_TIME 67 9901
TEST_TIME 68 9895
TEST_TIME 69 9933
TEST_TIME 70 9932
TEST_TIME 71 9980
TEST_TIME 72 9934
TEST_TIME 73 9953
TEST_TIME 74 10019
TEST_TIME 75 10001
TEST_TIME 76 10039
TEST_TIME 77 10068
TEST_TIME 78 9960
TEST_TIME 79 9916
TEST_TIME 80 9965
TEST_TIME 81 9893
TEST_TIME 82 9899
TEST_TIME 83 9862
TEST_TIME 84 9801
TEST_TIME 85 9756
TEST_TIME 86 9722
TEST_TIME 87 9714
TEST_TIME 88 9727
TEST_TIME 89 9696
TEST_TIME 90 9747
TEST_TIME 91 9735
TEST_TIME 92 9747
TEST_TIME 93 9793
TEST_TIME 94 9824
TEST_TIME 95 9840
TEST_TIME 96 9825
TEST_TIME 97 9843
TEST_TIME 98 9821
TEST_TIME 99 9851
TEST_TIME 100 9913
TEST_TIME 101 9920
TEST_TIME 102 9940
TEST_TIME 103 9870
TEST_TIME 104 9841
TEST_TIME 105 9779
TEST_TIME 106 9768
TEST_TIME 107 9750
TEST_TIME 108 9754
TEST_TIME 109 9726
TEST_TIME 110 9707
TEST_TIME 111 9694
TEST_TIME 112 9659
TEST_TIME 113 9637
TEST_TIME 114 9700
TEST_TIME 115 9650
TEST_TIME 116 9700
TEST_TIME 117 9673
TEST_TIME 118 9717
TEST_TIME 119 9713
TEST_TIME 120 9633

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-11-2020 19:28:07 to 10-11-2020 19:28:11.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1591843 1591843 0 0.00 0 20102 6 0 0
doc_list_biud 1591843 1591843 0 0.00 0 30480 27 0 0
sp_add_invoice_to_stock 5295 5154 141 2.66 42 172558 16750 0 141
sp_cancel_adding_invoice 6155 6155 0 0.00 4 89027 778 0 0
sp_cancel_client_order 1828 1828 0 0.00 4 10731 313 0 0
sp_cancel_customer_reserve 596062 596062 0 0.00 1 24412 57 0 0
sp_cancel_pay_from_customer 663 663 0 0.00 3 7127 82 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 1943 60 0 0
sp_cancel_supplier_invoice 6821 6813 8 0.11 2 12650 780 0 8
sp_cancel_supplier_order 450 450 0 0.00 6 1120613 95829 0 0
sp_cancel_write_off 9538 9538 0 0.00 1 10066 111 0 0
sp_client_order 22072 22072 0 0.00 3 24165 317 0 0
sp_customer_reserve 468904 468904 0 0.00 0 86346 169 0 0
sp_fill_shopping_cart 33585 33585 0 0.00 1 18365 39 0 0
sp_fill_shopping_cart_clo_res 468899 468899 0 0.00 0 14516 11 0 0
sp_get_clo_for_invoice 5148 5148 0 0.00 0 22344 244 0 0
sp_kill_cost_storno 16808 16808 0 0.00 0 8964 54 0 0
sp_kill_qstorno_ret_qs2qd 1208925 1208925 0 0.00 0 24392 31 0 0
sp_kill_qty_storno 636765 636765 0 0.00 0 30479 67 0 0
sp_lock_selected_doc 21928 21928 0 0.00 0 8042 6 0 0
sp_make_cost_storno 29604 29604 0 0.00 0 11581 48 0 0
sp_multiply_rows_for_pdistr 29604 29604 0 0.00 0 6162 25 0 0
sp_multiply_rows_for_qdistr 22072 22072 0 0.00 0 24154 151 0 0
sp_pay_from_customer 7519 7519 0 0.00 4 8490 91 0 0
sp_pay_to_supplier 6166 6166 0 0.00 5 9472 113 0 0
sp_payment_common 13685 13685 0 0.00 1 7012 21 0 0
sp_qd_handle_on_cancel_clo 1828 1828 0 0.00 0 10721 287 0 0
sp_qd_handle_on_invoice_upd_sts 11303 11303 0 0.00 0 30476 334 0 0
sp_qd_handle_on_reserve_upd_sts 10771 10771 0 0.00 0 16365 63 0 0
sp_reserve_write_off 10771 10771 0 0.00 6 16775 170 0 0
sp_supplier_invoice 5748 5748 0 0.00 6 85476 3236 0 0
sp_supplier_order 5775 5775 0 0.00 5 40287 1292 0 0
srv_aggregate_perf_data 100 100 0 0.00 2387 510984 22781 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1554 126905 33080 0 0
srv_find_qd_qs_mism 1106911 1106911 0 0.00 0 20102 5 0 0
srv_make_invnt_saldo 565 565 0 0.00 46 69054 1126 0 0
srv_make_money_saldo 788 788 0 0.00 1 9620 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 149373 262829 207286 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5154 5154 0 0.00 0 16880 167 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 1 4209 85 0 0
t$perf-norm:sp_cancel_client_order 1828 1828 0 0.00 0 5863 18 0 0
t$perf-norm:sp_cancel_customer_reserve 745 745 0 0.00 0 2668 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 663 663 0 0.00 0 1764 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 899 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 2158 28 0 0
t$perf-norm:sp_cancel_supplier_order 450 450 0 0.00 0 35249 1603 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 5905 10 0 0
t$perf-norm:sp_client_order 22072 22072 0 0.00 0 9043 16 0 0
t$perf-norm:sp_customer_reserve 1033 1033 0 0.00 0 3917 12 0 0
t$perf-norm:sp_pay_from_customer 7519 7519 0 0.00 0 9101 12 0 0
t$perf-norm:sp_pay_to_supplier 6166 6166 0 0.00 0 5834 9 0 0
t$perf-norm:sp_reserve_write_off 10771 10771 0 0.00 0 9225 13 0 0
t$perf-norm:sp_supplier_invoice 5748 5748 0 0.00 0 9300 20 0 0
t$perf-norm:sp_supplier_order 5775 5775 0 0.00 0 9667 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 65 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 176 3 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 1488 14 0 0
t$perf-norm:srv_make_money_saldo 788 788 0 0.00 0 1714 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 10578 10296 282 2.66 0 7770 18 0 282
v_all_customers 39984 39984 0 0.00 0 29 1 0 0
v_all_suppliers 31796 31796 0 0.00 0 29 1 0 0
v_all_wares 44144 44144 0 0.00 0 173 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 251 6 0 0
v_cancel_client_order 3656 3656 0 0.00 0 1872 5 0 0
v_cancel_customer_prepayment 1326 1326 0 0.00 0 1597 4 0 0
v_cancel_customer_reserve 1490 1490 0 0.00 0 679 4 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 733 4 0 0
v_cancel_supplier_invoice 864 848 16 1.85 0 3679 22 0 16
v_cancel_supplier_order 900 900 0 0.00 0 1985 6 0 0
v_cancel_write_off 1998 1998 0 0.00 0 1355 13 0 0
v_max_id_clo_ord 5775 5775 0 0.00 0 640 1 0 0
v_max_id_clo_res 1033 1033 0 0.00 0 3059 18 0 0
v_max_id_ord_sup 5737 5737 0 0.00 0 3517 4 0 0
v_max_non_paid_invoice 1780 1780 0 0.00 0 127 2 0 0
v_max_non_paid_realizn 4142 4142 0 0.00 0 676 3 0 0
v_min_id_clo_ord 5775 5775 0 0.00 0 15232 20 0 0
v_min_id_clo_res 1033 1033 0 0.00 0 2268 6 0 0
v_min_id_ord_sup 5737 5737 0 0.00 0 5974 7 0 0
v_min_non_paid_invoice 6166 6166 0 0.00 0 7005 13 0 0
v_min_non_paid_realizn 7519 7519 0 0.00 0 6506 10 0 0
v_our_firm 10914 10914 0 0.00 0 16 1 0 0
v_reserve_write_off 21542 21542 0 0.00 0 3590 4 0 0
x_lock_depdocs_on_canc_invoice 12544 12544 0 0.00 0 20129 112 0 0
x_lock_depdocs_on_canc_sup_ord 450 450 0 0.00 0 16202 327 0 0
x_make_qstorno_1000_1200 5775 5775 0 0.00 2 40277 1196 0 0
x_make_qstorno_1200_2000 5748 5748 0 0.00 3 85434 3104 0 0
x_make_qstorno_2100_3300 468904 468904 0 0.00 0 86329 155 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:12 15690 8192000000 10268596032 10581139456 1100545728 11.843 86 61 122 0 1124200672 3095584 20559360
16:57:35 36049 8192000000 10362676064 10684493824 1407022656 14.657 100 88 176 2 1440654480 5099488 28532336
16:58:23 21326 8192000000 10392921664 10719358976 1442876128 14.975 100 87 174 0 1478681040 7074880 28730032
16:58:54 26482 8192000000 10435080640 10763669504 1474992256 15.258 100 90 180 0 1512268480 8167424 29108800
16:59:43 8404 8192000000 10448785024 10781855744 1502119264 15.495 100 88 176 0 1538976576 8757376 28099936
17:00:00 26916 8192000000 10461844896 10799443968 1515210640 15.609 100 85 170 0 1551427728 9300672 26916416
17:00:37 21433 8192000000 10474083520 10811326464 1526007504 15.702 100 85 170 1 1562706208 9689296 27009408
17:01:07 18154 8192000000 10496438480 10837291008 1538693200 15.812 100 86 172 0 1575397248 10023632 26680416
17:01:36 14913 8192000000 10510975136 10859352064 1572887232 16.107 100 89 177 0 1610567488 10569104 27111152
17:01:58 14264 8192000000 10524559360 10878533632 1585789936 16.218 100 77 154 0 1619992720 10765040 23437744
17:02:20 11853 8192000000 10551585840 10904674304 1603083232 16.366 100 78 156 1 1637599680 10750912 23765536
17:02:41 12736 8192000000 10563536144 10926604288 1628387904 16.581 100 83 166 1 1664864768 11640320 24836544
17:03:10 14242 8192000000 10600739184 10967937024 1649067808 16.757 100 78 154 1 1683972624 12188624 22716192
17:03:34 11209 8192000000 10632492784 11000229888 1685510976 17.064 100 80 160 1 1721141232 11975792 23654464
17:03:53 7577 8192000000 10648520512 11018600448 1708207072 17.254 100 82 164 1 1744670400 12631248 23832080
17:04:09 8000 8192000000 10652545904 11025592320 1714511344 17.306 100 82 165 3 1751247408 13401168 23334896
17:04:24 6133 8192000000 10672276256 11044065280 1726105664 17.403 100 82 163 1 1761805264 12664976 23034624
17:04:38 4615 8192000000 10677780912 11054092288 1740685696 17.524 100 78 156 1 1775139984 12453936 22000352
17:04:51 5735 8192000000 10691649920 11070361600 1755861936 17.650 100 83 166 1 1792858224 13911152 23085136
17:05:04 5345 8192000000 10706009680 11083444224 1763792752 17.716 100 83 164 1 1800921856 14002160 23126944
17:05:18 4213 8192000000 10714306528 11094310912 1773122912 17.793 100 93 187 1 1814759968 15118560 26518496
17:05:29 3101 8192000000 10720748528 11103346688 1778820176 17.840 100 85 171 1 1816762928 14057696 23885056
17:05:39 3289 8192000000 10729517056 11108986880 1789797888 17.930 100 82 165 3 1825960864 14003728 22159248
17:05:49 4156 8192000000 10730330736 11116933120 1796308384 17.984 100 81 162 2 1833207008 14668480 22230144
17:06:00 2915 8192000000 10733701680 11120623616 1802682224 18.036 100 85 170 1 1840399568 13946976 23770368
17:06:10 3171 8192000000 10745704560 11127889920 1803740288 18.045 100 77 154 1 1838187504 13151776 21295440
17:06:20 4997 8192000000 10754701184 11136016384 1809130800 18.089 100 78 157 1 1843803248 13032912 21639536
17:06:31 2591 8192000000 10773299552 11156475904 1826829104 18.233 100 90 180 2 1866476368 14401936 25245328
17:06:40 1964 8192000000 10777207328 11159646208 1833733920 18.290 100 88 174 1 1871790544 13624784 24431840
17:06:49 2206 8192000000 10777817184 11163189248 1838273728 18.327 100 91 183 0 1877622896 13125664 26223504
17:06:57 1819 8192000000 10793408128 11176398848 1844016336 18.373 100 95 189 3 1884957984 14057360 26884288
17:07:06 1935 8192000000 10789033280 11174703104 1847552768 18.402 100 88 178 1 1886833568 14527280 24753520
17:07:14 1453 8192000000 10796528800 11181256704 1852232528 18.440 100 90 181 0 1892070752 14896080 24942144
17:07:22 1971 8192000000 10795703104 11183075328 1851494176 18.434 100 93 183 1 1890947216 13890624 25562416
17:07:30 2052 8192000000 10803116912 11190665216 1856363296 18.474 100 88 174 0 1895580576 13493168 25724112
17:07:39 2471 8192000000 10805208768 11193602048 1860321600 18.506 100 93 189 1 1904802144 18195728 26284816
17:07:48 1687 8192000000 10802697456 11193028608 1860408880 18.507 100 86 173 1 1896670128 11766928 24494320
17:07:56 2258 8192000000 10811352416 11199324160 1864769280 18.542 100 92 186 1 1904197232 12779856 26648096
17:08:05 1515 8192000000 10820347440 11207802880 1871327376 18.595 100 90 180 0 1910355504 12484960 26543168
17:08:13 1676 8192000000 10813581680 11206410240 1871846784 18.599 100 78 156 0 1906988240 12566128 22575328
17:08:21 2261 8192000000 10805572736 11200712704 1869064160 18.577 100 71 143 6 1900447008 9902256 21480592
17:08:31 38246 8192000000 10798926608 11202342912 1868327472 18.571 100 56 111 1 1892077600 7176768 16573360
17:09:15 13725 8192000000 10792471600 11207864320 1875657568 18.630 100 57 115 0 1900778688 8830224 16290896
17:09:39 4583 8192000000 10788754224 11212038144 1872877920 18.608 100 31 62 0 1889251088 7794224 8578944
17:09:50 5866 8192000000 10778107872 11212988416 1877685152 18.646 100 32 62 3 1894537424 7569264 9283008
17:10:02 5349 8192000000 10783668400 11212746752 1877220432 18.643 100 26 52 0 1891694768 6288480 8185856
17:10:14 5413 8192000000 10785874512 11215118336 1881308816 18.676 100 38 77 1 1898443648 6453120 10681712
17:10:31 9175 8192000000 10798759792 11220774912 1883428336 18.693 100 27 54 0 1897486816 7067104 6991376
17:10:48 2660 8192000000 10811714160 11227156480 1885512112 18.710 100 47 92 1 1906868976 8506832 12850032
17:10:58 5609 8192000000 10799806272 11223977984 1884961440 18.705 100 30 58 1 1899715824 6566832 8187552
17:11:11 9833 8192000000 10790383184 11226624000 1887799712 18.728 100 21 42 1 1900484112 5947264 6737136
17:11:28 5535 8192000000 10805206096 11231313920 1890943248 18.753 100 29 58 1 1906398560 7243328 8211984
17:11:43 10524 8192000000 10790184528 11231518720 1891856512 18.761 100 21 42 1 1908791344 11442560 5492272
17:12:00 8742 8192000000 10805536128 11233509376 1892894880 18.769 100 20 39 2 1904381200 5908784 5577536
17:12:15 10827 8192000000 10803681712 11236114432 1895119040 18.787 100 23 45 3 1908870320 6508656 7242624
17:12:32 16375 8192000000 10803078720 11240759296 1896467712 18.798 100 17 33 3 1907244192 5242896 5533584
17:12:55 10889 8192000000 10813575568 11239084032 1902366208 18.845 100 43 86 2 1919810400 5647440 11796752
17:13:15 59840 8192000000 10833235920 11255943168 1901368560 18.837 100 28 56 1 1915287840 5541824 8377456
17:14:22 3887 8192000000 10828126864 11259150336 1906935600 18.882 100 48 96 1 1930210672 10100016 13175056
17:14:33 7628 8192000000 10821720192 11256741888 1902789680 18.849 100 27 54 1 1917548816 7440400 7318736
17:14:49 4233 8192000000 10847017712 11262468096 1909535184 18.903 100 49 98 2 1931330896 8298688 13497024
17:15:00 5155 8192000000 10832435344 11264610304 1913460912 18.934 100 35 68 0 1931640704 8510672 9669120
17:15:12 4821 8192000000 10836243728 11267670016 1915018464 18.947 100 38 76 1 1933322960 7535536 10768960
17:15:25 5703 8192000000 10843860992 11267571712 1917062672 18.963 100 29 57 3 1930717536 5118720 8536144
17:15:38 6910 8192000000 10838693168 11265982464 1896865520 18.801 99 30 60 1 1911865008 6585056 8414432
17:15:51 12642 8192000000 10813524576 11247759360 1867293600 18.562 98 24 48 1 1884558720 10528992 6736128
17:16:10 5932 8192000000 10825990832 11257589760 1903120720 18.851 100 21 42 3 1914155696 5568416 5466560
17:16:23 7723 8192000000 10801460048 11236134912 1876543648 18.637 99 7 12 0 1883719056 5006400 2169008
17:16:42 7375 8192000000 10813274832 11247308800 1897971504 18.810 100 26 52 1 1911175648 5891328 7312816
17:16:58 9536 8192000000 10793664128 11225874432 1854267696 18.457 98 21 40 2 1865961072 5548320 6145056
17:17:17 10321 8192000000 10803969280 11233239040 1854576000 18.459 98 28 57 2 1867849920 4949216 8324704
17:18:04 23075 8192000000 10765993968 11180634112 1777076784 17.825 94 56 111 2 1799453152 6213344 16163024
17:18:33 5881 8192000000 10760087568 11190149120 1817416560 18.157 98 27 53 2 1832044736 7259344 7368832
17:18:48 7373 8192000000 10766026752 11182239744 1786344944 17.902 96 38 75 3 1803436880 5920272 11171664
17:19:01 5553 8192000000 10762483808 11179257856 1834879136 18.299 100 41 80 0 1853763888 7706272 11178480
17:19:14 4440 8192000000 10722097664 11139612672 1774375648 17.803 98 39 77 1 1801435840 16125264 10934928
17:19:26 6994 8192000000 10736819760 11152285696 1734110656 17.470 95 16 32 2 1742672208 4674832 3886720
17:19:40 6650 8192000000 10725004032 11139022848 1738068912 17.503 95 33 66 0 1753945648 5268080 10608656
17:19:53 4932 8192000000 10707125024 11116441600 1759852128 17.683 98 37 74 1 1777154368 6470928 10831312
17:20:07 5413 8192000000 10689252576 11105300480 1761722880 17.699 98 29 57 0 1777079072 5736784 9619408
17:20:22 11511 8192000000 10705948144 11118981120 1726168192 17.404 96 25 49 1 1738974368 5680752 7125424
17:20:44 8984 8192000000 10694710720 11103563776 1757146560 17.661 99 23 46 0 1769372704 5150992 7075152
17:21:01 8357 8192000000 10710792528 11126689792 1776122640 17.818 99 17 34 2 1786690848 5727232 4840976
17:21:18 9562 8192000000 10711516592 11124817920 1791845744 17.947 100 29 58 1 1806266688 5826832 8594112
17:21:35 8622 8192000000 10721849136 11137204224 1789569712 17.928 99 25 50 2 1803073600 5937184 7566704
17:21:53 69787 8192000000 10723103952 11148333056 1726283856 17.405 95 22 42 0 1737377520 5172480 5921184
17:23:11 11505 8192000000 10772945200 11177697280 1833582160 18.289 100 38 75 5 1850346832 6444656 10320016
17:23:29 4199 8192000000 10764243312 11173261312 1825217312 18.220 99 37 74 3 1841880592 5482656 11180624
17:23:41 6843 8192000000 10752418064 11182907392 1842260928 18.359 100 36 72 1 1863365728 10288912 10815888
17:23:54 8813 8192000000 10772367600 11191586816 1848180592 18.407 100 28 56 0 1862116000 6437392 7498016
17:24:12 5800 8192000000 10769040192 11194408960 1853969392 18.454 100 24 48 1 1866430720 5264560 7196768
17:24:25 5906 8192000000 10779481280 11206729728 1863169344 18.529 100 15 30 0 1872764960 5580064 4015552
17:24:38 7130 8192000000 10770685344 11208089600 1870605008 18.589 100 32 64 1 1886657280 6152512 9899760
17:24:53 12056 8192000000 10783926080 11216551936 1869730064 18.582 100 16 32 0 1879344448 5401152 4213232
17:25:11 8716 8192000000 10778907488 11213860864 1872968176 18.608 100 16 29 1 1882466096 5570368 3927552
17:25:27 18420 8192000000 10782193136 11215507456 1875373472 18.628 100 19 38 0 1886618880 5943936 5301472
17:25:55 10876 8192000000 10803470624 11225939968 1880748560 18.671 100 24 48 1 1893438144 5097984 7591600
17:26:12 5201 8192000000 10798273792 11227832320 1882860464 18.688 100 30 57 3 1896291648 5121376 8309808
17:26:30 83944 8192000000 10826971632 11249311744 1887815776 18.728 100 27 54 1 1900789152 5624256 7349120
17:28:00 8471 8192000000 10848485616 11259449344 1913261408 18.933 100 53 106 0 1937842544 9504768 15076368
17:28:15 18948 8192000000 10862659744 11286286336 1922426352 19.006 100 43 84 1 1945366496 10534736 12405408
17:28:53 14539 8192000000 10863487680 11294048256 1936209968 19.117 100 40 78 2 1958324048 11246704 10867376
17:29:21 16560 8192000000 10871461712 11300974592 1943727200 19.176 100 41 82 2 1965658432 10421360 11509872
17:29:44 5500 8192000000 10901070432 11322310656 1957090992 19.283 100 61 122 1 1987048192 12461008 17496192
17:30:00 20396 8192000000 10900917408 11328995328 1962097504 19.323 100 62 121 4 1993231008 13273872 17859632
17:30:32 27016 8192000000 10903959904 11331072000 1952476752 19.246 99 54 106 2 1982518176 14910400 15131024
17:31:06 12976 8192000000 10910751728 11345707008 1971931776 19.401 100 50 101 0 2000534192 14764800 13837616
17:31:26 12820 8192000000 10906132240 11339628544 1973858048 19.416 100 49 98 0 2002143072 14124336 14160688
17:31:47 7588 8192000000 10915627248 11345616896 1977342496 19.444 100 54 109 1 2008602032 15451536 15808000
17:32:13 7425 8192000000 10916060784 11349069824 1980622400 19.470 100 53 104 0 2009718976 14505392 14591184
17:32:30 17393 8192000000 10920561536 11354939392 1985924128 19.512 100 46 92 1 2013628592 14752608 12951856
17:33:05 15638 8192000000 10927583216 11355320320 1982974976 19.488 100 44 88 1 2011434512 14449712 14009824
17:33:30 22283 8192000000 10934732160 11362746368 1990690288 19.549 100 35 70 0 2015295040 13654016 10950736
17:34:03 14476 8192000000 10928538160 11364720640 1979276128 19.459 99 48 96 0 2009945504 16202688 14466688
17:34:27 16725 8192000000 10929870416 11367784448 1992843744 19.566 100 41 80 3 2021307136 16320752 12142640
17:34:58 4589 8192000000 10939383680 11369127936 1984379184 19.499 99 67 133 0 2022721744 17427456 20915104
17:35:17 5518 8192000000 10944069408 11370057728 1982813232 19.487 99 63 126 1 2020702320 19013312 18875776
17:35:30 12528 8192000000 10957237056 11383861248 2003594016 19.651 100 59 117 2 2041026112 20498352 16933744
17:36:00 11150 8192000000 10959110128 11392421888 2009445584 19.697 100 55 110 1 2046873040 21555472 15871984
17:36:31 7586 8192000000 10965993008 11397971968 2016286592 19.751 100 61 122 0 2055879520 21799120 17793808
17:36:54 9947 8192000000 10971491360 11405488128 2021140688 19.789 100 53 106 3 2058736544 21911792 15684064
17:37:15 6824 8192000000 10971204640 11410018304 2016576512 19.753 100 48 96 2 2059650688 29036784 14037392
17:37:30 2645 8192000000 10960468368 11389689856 2000489696 19.627 99 66 130 5 2046089040 26107024 19492320
17:37:43 4742 8192000000 10964728176 11392331776 2006770080 19.676 100 67 134 0 2054219360 27616720 19832560
17:37:58 6993 8192000000 10969584048 11402637312 2009599872 19.698 100 56 111 2 2054974928 28913024 16462032
17:38:13 3012 8192000000 10962050112 11389984768 2008648736 19.691 100 67 133 3 2054205120 26267280 19289104
17:38:22 3548 8192000000 10974152608 11394150400 2010507184 19.706 100 90 178 0 2065209392 27975168 26727040
17:38:33 4174 8192000000 10965906656 11387981824 1985910624 19.511 99 79 159 2 2042969664 32518976 24540064
17:38:48 1552 8192000000 10965374784 11381432320 1990102800 19.545 99 87 171 3 2043694400 28976384 24615216
17:39:04 3580 8192000000 10944677696 11364556800 1962662864 19.327 98 73 146 0 2015528192 30244864 22620464
17:39:18 3568 8192000000 10960224880 11384143872 1991898752 19.559 100 68 136 1 2044624352 31032720 21692880
17:39:28 2576 8192000000 10959843120 11389837312 2002217408 19.640 100 67 133 0 2055031632 31208112 21606112
17:39:38 7471 8192000000 10952345792 11377455104 1961307472 19.316 98 69 136 2 2016403344 32989728 22106144
17:39:53 3752 8192000000 10961518496 11378634752 1985218000 19.506 100 79 158 1 2045056192 35059120 24779072
17:40:04 8723 8192000000 10940340464 11368574976 1968374608 19.373 99 63 123 1 2021989504 33565792 20049104
17:40:23 9828 8192000000 10956770976 11384684544 1988505952 19.532 100 56 112 0 2039278352 33026064 17746336
17:40:40 3540 8192000000 10947723872 11365724160 1973657888 19.414 99 78 153 1 2030150768 32028048 24464832
17:40:52 7414 8192000000 10961586320 11386216448 1994830576 19.582 100 69 137 1 2050721280 34175872 21714832
17:41:10 6149 8192000000 10979792576 11401342976 2003136384 19.647 100 68 136 1 2059855280 36401248 20317648
17:41:24 4232 8192000000 10964092368 11372478464 1966336848 19.356 99 82 164 2 2029855072 38562608 24955616
17:41:35 3358 8192000000 10944380736 11358310400 1951879248 19.241 99 80 158 1 2013891312 37115520 24896544
17:41:46 2109 8192000000 10944709568 11359211520 1964983952 19.346 100 82 165 0 2028110960 38363440 24763568
17:41:55 2706 8192000000 10952576608 11367272448 1976654336 19.438 100 87 174 2 2038686496 36296064 25736096
17:42:06 10510 8192000000 10941534512 11364409344 1959269552 19.300 99 64 128 2 2011961712 33672000 19020160
17:42:25 13865 8192000000 10952210320 11378839552 1978238400 19.451 100 63 125 2 2032777744 35556032 18983312
17:42:47 3553 8192000000 10951982944 11380441088 1983479648 19.492 100 56 108 0 2036608224 36142640 16985936
17:42:58 2326 8192000000 10952661216 11373649920 1974048656 19.418 100 76 151 1 2038343984 40249792 24045536
17:43:07 3813 8192000000 10962108000 11382599680 1979261536 19.459 100 78 155 2 2043106048 40000368 23844144
17:43:18 4228 8192000000 10958913888 11376283648 1977778784 19.447 100 76 152 0 2040705520 39147808 23778928
17:43:30 8021 8192000000 10960877792 11376914432 1984360288 19.499 100 74 145 0 2039447328 32964752 22122288
17:43:45 3323 8192000000 10973677776 11384987648 1990448400 19.547 100 75 146 1 2048451568 34205712 23797456
17:43:55 4236 8192000000 10955161520 11374809088 1983365344 19.491 100 70 137 1 2038368016 34058048 20944624
17:44:16 5553 8192000000 10936688256 11356504064 1964306432 19.340 99 63 124 3 2021696384 37501072 19888880
17:44:34 4067 8192000000 10950273584 11380412416 1986320128 19.515 100 64 129 0 2041801312 35640000 19841184
17:44:45 2642 8192000000 10969503520 11390062592 1993684032 19.573 100 72 141 2 2052229184 36542128 22003024
17:45:00 2284 8192000000 10976979744 11397062656 1999505024 19.619 100 69 138 1 2056473872 35207952 21760896
17:45:09 2165 8192000000 10978169008 11400527872 1999098192 19.616 100 70 139 1 2055450016 34368880 21982944
17:45:20 8798 8192000000 10957719392 11399593984 1995571664 19.588 100 41 82 1 2043860736 34267888 14021184
17:45:35 5931 8192000000 10950582912 11387387904 1989189616 19.537 100 49 96 1 2039378464 33602928 16585920
17:45:53 1953 8192000000 10968611360 11386200064 1990215568 19.545 100 66 129 1 2048356592 37737168 20403856
17:46:02 7416 8192000000 10943423840 11383562240 1969754560 19.384 99 42 83 1 2018671680 36004400 12912720
17:46:24 30338 8192000000 10917996736 11355451392 1888950160 18.737 95 36 72 1 1934472944 33900688 11622096
17:47:04 4597 8192000000 10938198224 11365691392 1971053248 19.394 100 42 83 1 2017427024 32970656 13403120
17:47:17 2166 8192000000 10971885568 11383750656 1987269936 19.522 100 82 163 0 2049418096 36641600 25506560
17:47:27 2005 8192000000 10987104112 11396042752 1997803776 19.605 100 87 173 0 2063398784 39313616 26281392
17:47:38 6996 8192000000 10963742192 11395035136 1975192496 19.427 99 53 105 1 2033416512 41180160 17043856
17:47:59 4117 8192000000 10965381120 11397259264 1990413216 19.547 100 48 96 1 2048816736 42161072 16242448
17:48:12 8345 8192000000 10955478720 11395014656 1971062736 19.394 99 42 83 3 2032494480 46226592 15205152
17:48:29 9650 8192000000 10945812736 11377467392 1964719360 19.344 99 42 83 0 2025498848 46035408 14744080
17:48:48 8305 8192000000 10950260528 11389591552 1971533504 19.398 100 45 90 1 2035809888 48749568 15526816
17:49:05 12606 8192000000 10955054704 11394015232 1973364592 19.412 100 32 64 0 2034522112 49358112 11799408
17:49:29 22495 8192000000 10947868592 11395825664 1971290304 19.396 100 38 76 4 2040414208 55398320 13725584
17:50:24 2501 8192000000 10956353200 11378647040 1943446368 19.174 99 75 147 0 2026330560 57752464 25131728
17:50:42 8725 8192000000 10924816896 11379855360 1948640192 19.216 100 35 69 1 2015668224 54544464 12483568
17:51:03 6421 8192000000 10929935664 11367989248 1929519376 19.063 99 37 74 0 1994697424 51389984 13788064
17:51:16 22517 8192000000 10867159088 11327582208 1893187520 18.771 98 24 48 1 1950101696 47684208 9229968
17:52:02 32216 8192000000 10889577808 11344121856 1913152880 18.932 99 23 46 3 1959215936 38128848 7934208
17:52:42 21707 8192000000 10891470368 11352453120 1933137440 19.092 100 21 42 1 1973119584 32976768 7005376
17:53:11 74999 8192000000 10911866032 11351605248 1942072512 19.163 100 24 48 0 1987889232 37775184 8041536
17:54:36 34415 8192000000 10913211472 11365023744 1958471248 19.294 100 37 74 1 1996149200 26195008 11482944
17:55:17 18324 8192000000 10914033968 11368583168 1963255568 19.332 100 36 72 1 1999743152 25888976 10598608
17:55:53 14896 8192000000 10904607680 11372007424 1964031792 19.338 100 21 42 0 1995243440 24632272 6579376
17:56:19 13667 8192000000 10910335888 11371958272 1960748416 19.312 100 18 36 1 1996476816 29840608 5887792
17:56:41 19457 8192000000 10907406944 11387129856 1956622512 19.279 100 10 21 1 1986294384 26480160 3191712
17:58:48 67132 8192000000 10906309200 11351146496 1946220112 19.196 99 30 62 2 1967594256 13272976 8101168
18:00:08 47589 8192000000 10876228128 11329454080 1890020752 18.746 96 29 57 0 1907188912 9075968 8092192
18:01:07 95621 8192000000 10897130256 11346423808 1913659616 18.936 98 13 26 1 1925367104 8534464 3173024
18:02:49 100099 8192000000 10901910432 11386716160 1965539280 19.350 100 15 30 0 1984175328 14491504 4144544
18:04:38 80890 8192000000 10890822672 11339116544 1912217312 18.924 97 26 43 2 1928246336 10111568 5917456
18:06:09 28630 8192000000 10895899264 11347898368 1940755120 19.153 99 44 88 1 1963363184 10345616 12262448
18:06:50 31156 8192000000 10875989904 11335958528 1922223744 19.005 98 15 30 0 1940520112 14383440 3912928
18:07:34 60597 8192000000 10885388288 11346956288 1940291760 19.149 99 7 12 1 1951429040 9634240 1503040
18:08:41 78628 8192000000 10896238096 11358814208 1968678176 19.375 100 7 14 1 1984385168 13783456 1923536
18:10:14 48005 8192000000 10899008928 11369373696 1942676992 19.168 98 13 24 2 1959288688 13584672 3027024
18:11:15 103033 8192000000 10914174608 11364433920 1920343392 18.990 97 19 38 0 1935957008 9240432 6373184
18:13:05 91858 8192000000 10908623520 11364630528 1940103376 19.148 98 24 49 0 1953660448 6920704 6636368
18:15:05 29201 8192000000 10945669488 11387428864 1983649472 19.494 100 48 95 2 2008956256 12109600 13197184
18:16:17 77376 8192000000 10900121248 11370102784 1921827552 19.001 97 18 36 0 1938338640 11049488 5461600
18:17:42 49343 8192000000 10900365904 11364560896 1945666336 19.192 98 21 41 1 1960606352 9074528 5865488
18:18:41 75926 8192000000 10903569936 11350716416 1926135632 19.036 97 32 64 1 1954580704 18482592 9962480
18:20:06 33837 8192000000 10919844688 11370053632 1940614656 19.152 98 47 94 0 1967940816 13635392 13690768
18:20:59 61000 8192000000 10914755056 11393478656 1976696864 19.439 100 27 54 0 2006442336 21005872 8739600
18:22:07 28339 8192000000 10895894800 11374239744 1958058416 19.291 99 11 22 0 1977832592 16902240 2871936
18:23:57 126905 8192000000 10900408416 11382476800 1944802064 19.185 98 15 31 0 1960570112 11814080 3953968
18:26:10 57031 8192000000 10900222144 11380346880 1958782720 19.296 99 17 32 3 1977739104 14033856 4922528
18:27:24 18492 8192000000 10932479536 11381510144 1989581728 19.540 100 50 100 1 2011770032 8758992 13429312
18:27:50 37815 8192000000 10868898000 11338850304 1911398400 18.918 96 22 44 1 1930668992 13307760 5962832
18:28:39 38605 8192000000 10888133088 11362217984 1954055312 19.259 99 20 40 0 1975776656 16524656 5196688
18:29:25 40838 8192000000 10870427104 11358826496 1917149472 18.964 98 13 26 1 1940397600 19411264 3836864
18:30:31 69071 8192000000 10855479600 11336650752 1827523408 18.239 93 17 36 1 1840283744 8388480 4371856
18:31:46 30951 8192000000 10887668000 11351203840 1933437472 19.094 99 38 77 2 1951847088 7380352 11029264
18:32:47 38393 8192000000 10877176560 11340652544 1891710864 18.760 96 38 76 0 1913998160 10845792 11441504
18:33:56 48459 8192000000 10844911888 11305844736 1786602896 17.904 92 16 32 1 1804863552 13648304 4612352
18:34:52 48202 8192000000 10854750224 11313070080 1833236416 18.286 95 23 46 0 1851377232 11309088 6831728
18:35:46 62999 8192000000 10850102640 11331207168 1910411792 18.910 99 13 26 0 1925723920 11785744 3526384
18:37:08 28557 8192000000 10873387264 11330969600 1920809248 18.993 99 34 68 2 1940183920 9877296 9497376
18:38:04 81177 8192000000 10859754848 11326312448 1864004000 18.536 96 17 34 0 1879276000 10854352 4417648
18:39:32 36500 8192000000 10892987424 11340636160 1914631808 18.944 98 33 66 1 1935052656 10978960 9441888
18:40:16 67933 8192000000 10880159680 11349352448 1910006496 18.907 98 24 48 0 1929149920 12708656 6434768
18:41:30 43361 8192000000 10863868272 11330772992 1886009264 18.714 97 28 56 2 1907218080 13696256 7512560
18:42:21 25628 8192000000 10860534752 11319353344 1881609312 18.678 97 27 54 1 1897766976 8406672 7750992
18:42:54 69966 8192000000 10866283904 11344220160 1877366912 18.644 97 15 30 0 1897151552 15355392 4429248
18:44:11 126377 8192000000 10860826304 11309793280 1860604464 18.508 96 21 42 0 1882617552 15852288 6160800
18:46:26 85713 8192000000 10857241840 11333292032 1918633984 18.976 99 32 64 1 1937580272 9833184 9113104
18:47:58 49724 8192000000 10860005584 11344265216 1938133680 19.132 100 7 14 2 1953703920 13675040 1895200
18:48:54 21569 8192000000 10887520096 11345358848 1950665424 19.232 100 29 57 1 1969331872 10613296 8053152
18:49:31 38677 8192000000 10852620128 11331170304 1909101680 18.899 98 29 58 1 1927959168 10638496 8218992
18:51:19 62675 8192000000 10884346576 11355590656 1958508480 19.294 100 20 39 2 1974958816 10274720 6175616
18:52:28 60743 8192000000 10871341200 11339468800 1920622400 18.992 98 15 30 1 1940630352 14521328 5486624
18:53:35 62660 8192000000 10872598592 11351957504 1954390704 19.261 100 14 29 1 1971111360 12416784 4303872
18:54:58 70094 8192000000 10888823920 11383635968 1969533136 19.382 100 15 30 0 1990640240 16662272 4444832
18:56:18 79897 8192000000 10881863024 11364478976 1891656976 18.759 96 21 42 3 1912755840 15054384 6044480
18:57:45 77083 8192000000 10900338752 11376214016 1952048288 19.243 99 15 30 0 1965965008 9735136 4181584
18:59:09 68477 8192000000 10896001744 11367571456 1916146720 18.956 97 14 28 0 1934694384 14394624 4153040
19:00:34 46153 8192000000 10887686160 11370938368 1941856816 19.162 99 14 28 0 1959558768 13868416 3833536
19:01:54 70473 8192000000 10904172992 11368419328 1937799488 19.129 98 30 60 2 1958043152 11796400 8447264
19:03:17 17728 8192000000 10884185376 11345145856 1925165984 19.028 98 28 56 2 1942242224 9563200 7513040
19:03:42 60838 8192000000 10905059360 11381411840 1967940432 19.369 100 27 54 2 1986356768 11212752 7203584
19:04:49 39858 8192000000 10922302592 11379363840 1963308992 19.332 99 33 67 1 1981597248 9035456 9252800
19:05:36 91136 8192000000 10898232224 11372474368 1883983184 18.697 95 28 55 0 1905155520 14010304 7162032
19:07:16 125337 8192000000 10896120816 11369836544 1852382080 18.441 94 9 18 2 1873818112 19005536 2430496
19:09:28 67275 8192000000 10867161008 11341582336 1897826608 18.809 96 23 45 1 1914725040 10455728 6442704
19:11:38 65130 8192000000 10903298224 11370557440 1947549712 19.207 99 28 56 1 1970234224 15016496 7668016
19:13:02 2661 8192000000 10891287600 11364429824 1964006624 19.338 100 22 44 1 1980341392 10069664 6265104
19:13:14 46746 8192000000 10892199392 11374288896 1969422112 19.381 100 36 72 1 1989494336 10176464 9895760
19:14:09 82220 8192000000 10861765184 11345428480 1887594656 18.726 96 12 24 0 1903988560 13244672 3149232
19:15:37 63211 8192000000 10871531264 11352735744 1909422048 18.902 98 16 31 1 1924687984 11333296 3932640
19:16:47 70513 8192000000 10876522128 11352014848 1916162640 18.956 98 12 25 0 1931354096 11241024 3950432
19:18:14 75114 8192000000 10863522416 11336646656 1888485712 18.734 97 15 30 0 1905299920 12112224 4701984
19:19:35 64631 8192000000 10865578160 11341103104 1920329744 18.989 99 15 31 0 1935727808 10694640 4703424
19:21:01 49683 8192000000 10841985168 11316617216 1889477872 18.742 98 7 14 0 1901760976 9895008 2388096
19:21:56 33137 8192000000 10870235088 11324579840 1879860800 18.664 97 30 60 0 1895890112 7789312 8240000
19:22:36 54954 8192000000 10849669216 11310424064 1888420912 18.733 98 35 70 1 1913683120 15786960 9475248
19:23:42 59693 8192000000 10872804832 11334107136 1912733248 18.929 99 20 40 1 1927432176 9131376 5567552
19:24:48 76204 8192000000 10850983120 11323858944 1866968000 18.560 96 20 40 3 1885720256 13242704 5509552
19:26:16 48296 8192000000 10649192976 11094581248 1694412816 17.138 88 27 54 4 1715560656 13462896 7684944

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-11-2020 19:28:17 to 10-11-2020 19:28:49.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-11-2020 19:28:49 to 10-11-2020 19:28:51.

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          248432
MON$OLDEST_ACTIVE               248433
MON$OLDEST_SNAPSHOT             248433
MON$NEXT_TRANSACTION            248433
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                       2054752
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:215: 
:216: mscs-test-161.budzdorov.ru    Tue Nov 10 19:27:15 2020
:217:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:218: 
:219: 
:220: mscs-test-161.budzdorov.ru    Tue Nov 10 19:27:17 2020
:221:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:222: 
:223: 
:224: mscs-test-161.budzdorov.ru    Tue Nov 10 19:27:17 2020
:225:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:226: 
--- end of diff output ---

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

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