Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.11.2020 01: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 17338740 kB
MemAvailable 31451424 kB
Buffers 0 kB
Cached 14328120 kB
SwapCached 2864 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-05 01:26:59
DTS_END                         2020-11-05 01:26:59.2050
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/39266
TRN_ID                          235189
ATT_ID                          643
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: 8838.31 22463 1060597
customer order: creation 167.06 364 20047
customer order: refuse 14.06 346 1687
order to supplier: creation 45.14 1363 5417
order to supplier: removal 3.49 97550 419
invoice (draft): creation 44.37 3662 5324
invoice (draft): removal 50.44 839 6053
invoice accept: apply 40.33 18822 4839
invoice accept: cancel 45.58 896 5470
customer reserve: creation 3673.22 188 440786
customer reserve: removal 4470.03 59 536404
realization accept: apply 81.71 188 9805
realization accept: cancel 78.13 104 9376
payment from customer: creation 56.24 139 6749
payment from customer: removal 5.27 99 632
payment to supplier: creation 48.31 146 5797
payment to supplier: removal 3.40 59 408
service: total inventory turnovers 4.34 1266 521
service: total monetary turnovers 6.36 33 763
service: aggregate perf. data 0.80 17679 96
service: refresh index statistics 0.03 305458 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2020 01:28:09 to 05-11-2020 01:28:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1956
TEST_TIME 2 2940
TEST_TIME 3 4578
TEST_TIME 4 4279
TEST_TIME 5 4017
TEST_TIME 6 4647
TEST_TIME 7 4214
TEST_TIME 8 4101
TEST_TIME 9 4679
TEST_TIME 10 4968
TEST_TIME 11 5233
TEST_TIME 12 5540
TEST_TIME 13 5759
TEST_TIME 14 6183
TEST_TIME 15 7046
TEST_TIME 16 7267
TEST_TIME 17 7826
TEST_TIME 18 7916
TEST_TIME 19 7919
TEST_TIME 20 8070
TEST_TIME 21 8490
TEST_TIME 22 8933
TEST_TIME 23 8951
TEST_TIME 24 9122
TEST_TIME 25 9387
TEST_TIME 26 9312
TEST_TIME 27 9534
TEST_TIME 28 9524
TEST_TIME 29 10116
TEST_TIME 30 10376
TEST_TIME 31 10254
TEST_TIME 32 10321
TEST_TIME 33 10303
TEST_TIME 34 10485
TEST_TIME 35 10487
TEST_TIME 36 10307
TEST_TIME 37 10305
TEST_TIME 38 10268
TEST_TIME 39 10313
TEST_TIME 40 10210
TEST_TIME 41 10072
TEST_TIME 42 9946
TEST_TIME 43 9889
TEST_TIME 44 9772
TEST_TIME 45 9626
TEST_TIME 46 9550
TEST_TIME 47 9553
TEST_TIME 48 9407
TEST_TIME 49 9292
TEST_TIME 50 9211
TEST_TIME 51 9313
TEST_TIME 52 9278
TEST_TIME 53 9206
TEST_TIME 54 9195
TEST_TIME 55 9094
TEST_TIME 56 9052
TEST_TIME 57 9035
TEST_TIME 58 8990
TEST_TIME 59 8955
TEST_TIME 60 8919
TEST_TIME 61 8944
TEST_TIME 62 8982
TEST_TIME 63 8955
TEST_TIME 64 8929
TEST_TIME 65 9080
TEST_TIME 66 9107
TEST_TIME 67 9058
TEST_TIME 68 9044
TEST_TIME 69 9018
TEST_TIME 70 9149
TEST_TIME 71 9124
TEST_TIME 72 9088
TEST_TIME 73 9179
TEST_TIME 74 9251
TEST_TIME 75 9234
TEST_TIME 76 9167
TEST_TIME 77 9070
TEST_TIME 78 9069
TEST_TIME 79 9075
TEST_TIME 80 9010
TEST_TIME 81 8987
TEST_TIME 82 8945
TEST_TIME 83 8899
TEST_TIME 84 8848
TEST_TIME 85 8923
TEST_TIME 86 8902
TEST_TIME 87 8886
TEST_TIME 88 8886
TEST_TIME 89 8856
TEST_TIME 90 8802
TEST_TIME 91 8791
TEST_TIME 92 8809
TEST_TIME 93 8846
TEST_TIME 94 8887
TEST_TIME 95 8867
TEST_TIME 96 8865
TEST_TIME 97 8916
TEST_TIME 98 8975
TEST_TIME 99 8952
TEST_TIME 100 8932
TEST_TIME 101 9005
TEST_TIME 102 9034
TEST_TIME 103 9032
TEST_TIME 104 9038
TEST_TIME 105 9066
TEST_TIME 106 9004
TEST_TIME 107 8965
TEST_TIME 108 8964
TEST_TIME 109 8942
TEST_TIME 110 8967
TEST_TIME 111 8937
TEST_TIME 112 8940
TEST_TIME 113 8917
TEST_TIME 114 8892
TEST_TIME 115 8858
TEST_TIME 116 8822
TEST_TIME 117 8802
TEST_TIME 118 8836
TEST_TIME 119 8841
TEST_TIME 120 8844

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2020 01:28:13 to 05-11-2020 01:28:16.

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 1469656 1469656 0 0.00 0 18286 6 0 0
doc_list_biud 1469654 1469654 0 0.00 0 59931 28 0 0
sp_add_invoice_to_stock 4949 4839 110 2.22 42 182959 18822 0 110
sp_cancel_adding_invoice 5470 5470 0 0.00 5 68742 897 0 0
sp_cancel_client_order 1687 1687 0 0.00 4 11659 346 0 0
sp_cancel_customer_reserve 536404 536404 0 0.00 1 34983 59 0 0
sp_cancel_pay_from_customer 632 632 0 0.00 3 4351 100 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 1004 59 0 0
sp_cancel_supplier_invoice 6068 6053 15 0.24 2 59937 840 0 15
sp_cancel_supplier_order 419 419 0 0.00 6 969907 97551 0 0
sp_cancel_write_off 9376 9376 0 0.00 1 7948 104 0 0
sp_client_order 20047 20047 0 0.00 3 26500 365 0 0
sp_customer_reserve 440786 440786 0 0.00 0 47149 189 0 0
sp_fill_shopping_cart 30787 30787 0 0.00 1 18625 43 0 0
sp_fill_shopping_cart_clo_res 440771 440771 0 0.00 0 14344 14 0 0
sp_get_clo_for_invoice 4823 4823 0 0.00 0 19626 320 0 0
sp_kill_cost_storno 15886 15886 0 0.00 0 16218 61 0 0
sp_kill_qstorno_ret_qs2qd 1088656 1088656 0 0.00 0 59927 32 0 0
sp_kill_qty_storno 574036 574036 0 0.00 0 59930 70 0 0
sp_lock_selected_doc 20213 20213 0 0.00 0 9181 5 0 0
sp_make_cost_storno 27174 27174 0 0.00 0 16250 52 0 0
sp_multiply_rows_for_pdistr 27174 27174 0 0.00 0 7638 30 0 0
sp_multiply_rows_for_qdistr 20047 20047 0 0.00 0 13377 138 0 0
sp_pay_from_customer 6749 6749 0 0.00 4 26449 139 0 0
sp_pay_to_supplier 5797 5797 0 0.00 5 26468 147 0 0
sp_payment_common 12546 12546 0 0.00 1 22000 30 0 0
sp_qd_handle_on_cancel_clo 1687 1687 0 0.00 0 9402 300 0 0
sp_qd_handle_on_invoice_upd_sts 10293 10293 0 0.00 0 25000 365 0 0
sp_qd_handle_on_reserve_upd_sts 9804 9804 0 0.00 0 15840 63 0 0
sp_reserve_write_off 9805 9805 0 0.00 6 16285 189 0 0
sp_supplier_invoice 5324 5324 0 0.00 6 74546 3663 0 0
sp_supplier_order 5417 5417 0 0.00 5 52760 1363 0 0
srv_aggregate_perf_data 96 96 0 0.00 2723 196658 17679 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1205 137894 30614 0 0
srv_find_qd_qs_mism 1015057 1015057 0 0.00 0 18284 5 0 0
srv_make_invnt_saldo 521 521 0 0.00 30 90479 1266 0 0
srv_make_money_saldo 763 763 0 0.00 1 2404 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 193115 568988 305458 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4840 4840 0 0.00 0 29066 191 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 1 5625 104 0 0
t$perf-norm:sp_cancel_client_order 1687 1687 0 0.00 0 3064 12 0 0
t$perf-norm:sp_cancel_customer_reserve 660 660 0 0.00 0 6565 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 632 632 0 0.00 0 2124 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 835 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 1219 15 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 24261 1505 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 1829 7 0 0
t$perf-norm:sp_client_order 20047 20047 0 0.00 0 17301 21 0 0
t$perf-norm:sp_customer_reserve 987 987 0 0.00 0 4247 12 0 0
t$perf-norm:sp_pay_from_customer 6749 6749 0 0.00 0 15538 13 0 0
t$perf-norm:sp_pay_to_supplier 5797 5797 0 0.00 0 4094 9 0 0
t$perf-norm:sp_reserve_write_off 9805 9805 0 0.00 0 17752 17 0 0
t$perf-norm:sp_supplier_invoice 5324 5324 0 0.00 0 6578 19 0 0
t$perf-norm:sp_supplier_order 5417 5417 0 0.00 0 6448 15 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 652 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 248 4 0 0
t$perf-norm:srv_make_invnt_saldo 521 521 0 0.00 0 10258 44 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 514 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9866 9646 220 2.22 0 8958 18 0 220
v_all_customers 36238 36238 0 0.00 0 77 1 0 0
v_all_suppliers 29676 29676 0 0.00 0 29 1 0 0
v_all_wares 40094 40094 0 0.00 0 77 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 234 5 0 0
v_cancel_client_order 3374 3374 0 0.00 0 5421 7 0 0
v_cancel_customer_prepayment 1264 1264 0 0.00 0 2770 7 0 0
v_cancel_customer_reserve 1320 1320 0 0.00 0 5993 9 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 752 4 0 0
v_cancel_supplier_invoice 776 746 30 3.86 0 522 14 0 30
v_cancel_supplier_order 838 838 0 0.00 0 9088 16 0 0
v_cancel_write_off 2008 2008 0 0.00 0 3251 17 0 0
v_max_id_clo_ord 5417 5417 0 0.00 0 4848 2 0 0
v_max_id_clo_res 987 987 0 0.00 0 1325 10 0 0
v_max_id_ord_sup 5323 5323 0 0.00 0 4678 5 0 0
v_max_non_paid_invoice 1699 1699 0 0.00 0 3729 6 0 0
v_max_non_paid_realizn 3670 3670 0 0.00 0 6637 4 0 0
v_min_id_clo_ord 5417 5417 0 0.00 0 2124 7 0 0
v_min_id_clo_res 987 987 0 0.00 0 3512 8 0 0
v_min_id_ord_sup 5323 5323 0 0.00 0 3197 8 0 0
v_min_non_paid_invoice 5797 5797 0 0.00 0 7600 15 0 0
v_min_non_paid_realizn 6749 6749 0 0.00 0 6236 19 0 0
v_our_firm 10014 10014 0 0.00 0 20 1 0 0
v_reserve_write_off 19608 19608 0 0.00 0 9121 7 0 0
x_lock_depdocs_on_canc_invoice 11150 11150 0 0.00 0 20694 131 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 22431 393 0 0
x_make_qstorno_1000_1200 5417 5417 0 0.00 1 52752 1273 0 0
x_make_qstorno_1200_2000 5324 5324 0 0.00 3 74347 3512 0 0
x_make_qstorno_2100_3300 440786 440786 0 0.00 0 41282 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2020 01:28:17 to 05-11-2020 01:28:21.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:09 6816 8192000000 10190784960 10487918592 849429536 9.394 66 52 108 0 868587280 2256208 16901536
22:57:24 17545 8192000000 10322808592 10635137024 1356258880 14.204 100 83 166 0 1386842640 3910928 26672832
22:57:53 29448 8192000000 10380166128 10701168640 1420364720 14.776 100 87 173 0 1455081664 6227328 28489616
22:58:31 29101 8192000000 10411110784 10739458048 1455222752 15.084 100 87 174 0 1490899408 7063808 28612848
22:59:11 29568 8192000000 10429193856 10763296768 1485776272 15.352 100 91 180 0 1522520080 7961072 28782736
22:59:50 36389 8192000000 10473852384 10810576896 1517265952 15.626 100 92 182 1 1555684304 9062960 29355392
23:00:51 23196 8192000000 10500076192 10849779712 1554131408 15.946 100 80 160 1 1588784768 10014112 24639248
23:01:26 17377 8192000000 10529930688 10881171456 1586088096 16.220 100 90 180 1 1624941680 11015568 27838016
23:01:57 19385 8192000000 10551807984 10908942336 1611987440 16.442 100 82 163 0 1647664608 11183344 24493824
23:02:26 18769 8192000000 10582687280 10944311296 1637157280 16.656 100 83 166 1 1673738928 11373840 25207808
23:02:54 12684 8192000000 10598045536 10963058688 1660438544 16.853 100 78 155 0 1695415184 11811584 23165056
23:03:16 8798 8192000000 10617507472 10985463808 1680000720 17.017 100 81 163 0 1716190720 12562464 23627536
23:03:36 9548 8192000000 10639808432 11011125248 1704348176 17.221 100 81 161 3 1740687360 12942272 23396912
23:03:53 11295 8192000000 10669836512 11038932992 1722675808 17.375 100 83 166 0 1758831280 12252480 23902992
23:04:13 8368 8192000000 10674613104 11050680320 1731717344 17.450 100 80 161 3 1767561872 12968336 22876192
23:04:31 6809 8192000000 10683209328 11057778688 1748993408 17.593 100 85 169 0 1786648896 13387056 24268432
23:04:46 4552 8192000000 10695861904 11074355200 1752541776 17.623 100 84 163 0 1789510720 14176816 22792128
23:04:58 6069 8192000000 10717396768 11095351296 1769860320 17.766 100 85 171 0 1807982000 13791776 24329904
23:05:11 5560 8192000000 10721850768 11098959872 1781199840 17.859 100 80 160 3 1818128256 14064256 22864160
23:05:24 3292 8192000000 10721723440 11106205696 1781613616 17.863 100 80 160 2 1818214480 13255296 23345568
23:05:34 3743 8192000000 10724633536 11102601216 1787245968 17.909 100 82 165 1 1823524400 13293936 22984496
23:05:45 3957 8192000000 10739021296 11118100480 1792296144 17.951 100 82 162 4 1828333760 13603728 22433888
23:05:55 3553 8192000000 10742963632 11124355072 1802120592 18.031 100 85 171 1 1838794288 13380416 23293280
23:06:05 7225 8192000000 10740808704 11129290752 1803620368 18.044 100 78 157 0 1838239520 12603488 22015664
23:06:20 2785 8192000000 10747651664 11135664128 1809108256 18.089 100 81 162 0 1844075808 12280768 22686784
23:06:32 2846 8192000000 10765080448 11148800000 1824345184 18.213 100 91 184 1 1863168544 12955184 25868176
23:06:42 2860 8192000000 10769421776 11152236544 1823912080 18.210 100 85 169 1 1860386704 12161216 24313408
23:06:51 2438 8192000000 10773378496 11158622208 1830267184 18.262 100 87 174 3 1866906368 12329440 24309744
23:07:00 2158 8192000000 10771951248 11157819392 1835687888 18.306 100 88 177 1 1872685184 12836656 24160640
23:07:08 1864 8192000000 10780137392 11169943552 1843937888 18.373 100 93 186 2 1883214080 13866896 25409296
23:07:17 2729 8192000000 10794243664 11179905024 1843823184 18.372 100 91 182 0 1884279760 15116256 25340320
23:07:26 1412 8192000000 10792471936 11179167744 1845975168 18.389 100 91 182 1 1887196224 15961936 25259120
23:07:34 1981 8192000000 10800825968 11186282496 1853209936 18.448 100 92 183 1 1892669552 14665616 24794000
23:07:42 2079 8192000000 10799168880 11184259072 1853510288 18.451 100 91 182 0 1891169984 12346992 25312704
23:07:51 1675 8192000000 10807665072 11192745984 1859742256 18.501 100 92 182 0 1898866800 13233904 25890640
23:08:00 1648 8192000000 10801258064 11201368064 1867609984 18.565 100 74 148 1 1901916736 13740272 20566480
23:08:08 25537 8192000000 10810630816 11205136384 1870243616 18.586 100 71 144 2 1901402208 11394112 19764480
23:08:40 2227 8192000000 10814312576 11213787136 1876201600 18.634 100 83 167 0 1912214464 11757472 24255392
23:08:50 2181 8192000000 10799106672 11208384512 1875588176 18.629 100 65 132 2 1903481408 9105264 18787968
23:08:58 4534 8192000000 10786164352 11206234112 1870212096 18.586 100 33 66 0 1891378656 12056432 9110128
23:09:10 8517 8192000000 10783272672 11201257472 1868862816 18.575 100 19 37 0 1880237872 5680608 5694448
23:09:26 4567 8192000000 10786446832 11209310208 1873737232 18.615 100 28 56 1 1888155712 6752464 7666016
23:09:37 3097 8192000000 10793834048 11211190272 1877162688 18.642 100 27 54 2 1890918448 6404160 7351600
23:09:48 7217 8192000000 10789157472 11215073280 1879770368 18.663 100 37 74 2 1898968784 8409264 10789152
23:10:03 11488 8192000000 10799306528 11224883200 1880487952 18.669 100 27 54 1 1894671488 6663888 7519648
23:10:21 22523 8192000000 10789735808 11226304512 1881530992 18.677 100 22 45 1 1893665280 5569136 6565152
23:11:12 31790 8192000000 10806424880 11236712448 1888335088 18.732 100 30 60 1 1902652000 6009472 8307440
23:11:51 10595 8192000000 10812282704 11236614144 1888533520 18.734 100 24 46 2 1900460560 5860944 6066096
23:12:08 6420 8192000000 10812928576 11237502976 1890901888 18.753 100 35 71 0 1907683616 7065104 9716624
23:12:21 4001 8192000000 10812522240 11240620032 1895775984 18.792 100 42 85 2 1915368256 7376704 12215568
23:12:31 2846 8192000000 10807905440 11242123264 1899815680 18.825 100 36 71 2 1916944528 7229520 9899328
23:12:42 6992 8192000000 10811669216 11245420544 1899696592 18.824 100 32 64 0 1915664624 6573376 9394656
23:12:55 7209 8192000000 10807272368 11243429888 1898174112 18.812 100 24 48 0 1910934304 6321696 6438496
23:13:08 6358 8192000000 10837040736 11257008128 1904790048 18.865 100 40 80 1 1922462944 6796560 10876336
23:13:21 5688 8192000000 10820389552 11249995776 1902470512 18.846 100 38 75 1 1920352192 6889584 10992096
23:13:33 10950 8192000000 10830502496 11250372608 1899953632 18.826 100 25 49 1 1912799648 5873600 6972416
23:13:58 4006 8192000000 10820374320 11248304128 1902455360 18.846 100 39 77 2 1918880272 5757232 10667680
23:14:08 4950 8192000000 10831821824 11261313024 1902270672 18.845 100 30 60 1 1921451232 11198464 7982096
23:14:21 13330 8192000000 10819018976 11255590912 1904211168 18.860 100 18 34 1 1919043664 9997088 4835408
23:14:43 13298 8192000000 10814926976 11253096448 1904689616 18.864 100 21 40 2 1915716496 5662432 5364448
23:15:06 49639 8192000000 10846276432 11261001728 1910508992 18.911 100 37 75 4 1926929024 4975344 11444688
23:16:02 13602 8192000000 10809296272 11243454464 1869489072 18.580 98 14 26 3 1878968336 5497120 3982144
23:16:23 7108 8192000000 10820968992 11254394880 1901679952 18.840 100 29 58 2 1924389344 14491984 8217408
23:16:36 6546 8192000000 10806986960 11234500608 1860362432 18.506 98 25 50 0 1872659456 5096368 7200656
23:16:50 11326 8192000000 10790153312 11225731072 1839265840 18.335 97 34 68 0 1856065152 7213472 9585840
23:17:07 8930 8192000000 10786344976 11218100224 1829872416 18.258 97 22 44 4 1846062496 9906880 6283200
23:17:22 5252 8192000000 10764745776 11192578048 1782288832 17.868 95 28 56 0 1796599296 6226272 8084192
23:17:37 6899 8192000000 10769283440 11196010496 1833349648 18.287 99 21 42 0 1845330496 5602320 6378528
23:17:50 8204 8192000000 10753920608 11181920256 1815816768 18.143 98 24 48 1 1829068624 6081040 7170816
23:18:09 9799 8192000000 10721130208 11137433600 1744685536 17.558 94 17 33 2 1755208656 4968656 5554464
23:18:26 6742 8192000000 10733936544 11163897856 1786979872 17.907 97 22 43 1 1799281632 5407616 6894144
23:18:39 5056 8192000000 10775228576 11192819712 1845953312 18.389 100 33 63 1 1859923712 5280176 8690224
23:18:51 14377 8192000000 10738160080 11160829952 1743579168 17.548 94 18 36 1 1754181328 4720912 5881248
23:19:15 5449 8192000000 10731146448 11161141248 1810013504 18.096 99 27 54 3 1824059520 6403216 7642800
23:19:26 13070 8192000000 10723770304 11141160960 1730578512 17.440 95 13 26 2 1739257120 5011888 3666720
23:19:46 28858 8192000000 10677695600 11103383552 1751645360 17.615 98 12 25 0 1759746304 4750368 3350576
23:20:36 29869 8192000000 10696160720 11117371392 1689783520 17.099 94 24 47 2 1702080608 5461872 6835216
23:21:12 8585 8192000000 10704337760 11127332864 1772903552 17.791 98 29 56 2 1787149632 5672720 8573360
23:21:27 4596 8192000000 10710236032 11115134976 1743058720 17.544 97 39 76 1 1759750336 6306800 10384816
23:21:38 8956 8192000000 10721761808 11131940864 1781201552 17.859 99 33 64 1 1797572240 6915680 9455008
23:21:54 6930 8192000000 10712550928 11128508416 1784376560 17.886 99 35 70 1 1801066880 6788880 9901440
23:22:10 8899 8192000000 10715917600 11133325312 1764392192 17.721 97 26 52 0 1777509440 5207920 7909328
23:22:25 4766 8192000000 10743486528 11158044672 1808452464 18.083 99 29 58 2 1822422512 5768080 8201968
23:22:40 7238 8192000000 10763786080 11179888640 1836356624 18.311 100 27 53 0 1849467392 5438352 7672416
23:22:56 6433 8192000000 10732831520 11161309184 1815487728 18.141 99 26 52 3 1829794336 6485216 7821392
23:23:12 11753 8192000000 10747210896 11179843584 1839804640 18.339 100 22 41 3 1852128464 5605568 6718256
23:23:29 7492 8192000000 10767455440 11185516544 1845482992 18.385 100 28 56 5 1860675152 6417200 8774960
23:23:44 9233 8192000000 10762419792 11187695616 1847789936 18.404 100 23 45 4 1859709664 4946992 6972736
23:24:00 14010 8192000000 10775298048 11198001152 1853570992 18.451 100 17 34 1 1867496608 9193008 4732608
23:24:23 9508 8192000000 10771052016 11201974272 1857110608 18.480 100 19 38 1 1868802624 6497136 5194880
23:24:39 73612 8192000000 10775374432 11207995392 1867773360 18.566 100 31 62 1 1882769312 5459888 9536064
23:26:01 5406 8192000000 10787438464 11220455424 1875868912 18.632 100 31 60 0 1891457360 7144592 8443856
23:26:14 12390 8192000000 10797304400 11221942272 1878717520 18.655 100 32 64 1 1893737728 6538720 8481488
23:26:35 8333 8192000000 10784367008 11219124224 1876905680 18.640 100 20 40 1 1888409376 5184304 6319392
23:26:51 36724 8192000000 10808573744 11229696000 1882036384 18.682 100 23 47 0 1893574432 5291824 6246224
23:27:46 11550 8192000000 10825056432 11248476160 1902637504 18.848 100 33 66 0 1919048480 6820896 9590080
23:28:05 15565 8192000000 10840687200 11260669952 1915522704 18.951 100 47 94 2 1940537024 12054672 12959648
23:28:31 8552 8192000000 10852473824 11269746688 1919727360 18.985 100 51 102 2 1942199520 8164048 14308112
23:28:53 19905 8192000000 10847727152 11275849728 1923993536 19.019 100 39 76 2 1944719120 9980864 10744720
23:29:22 24037 8192000000 10862794448 11292557312 1933336544 19.094 100 39 75 3 1955783600 12042912 10404144
23:29:53 19406 8192000000 10882401296 11303854080 1942443232 19.166 100 49 98 1 1968025312 11759008 13823072
23:30:26 10354 8192000000 10885161456 11308605440 1950365216 19.229 100 53 106 0 1978692416 13004480 15322720
23:30:44 33266 8192000000 10881232928 11318747136 1956442144 19.278 100 66 132 1 1989696064 14145584 19108336
23:31:53 61446 8192000000 10888317200 11339472896 1961674544 19.319 100 33 66 1 1987140432 15749632 9716256
23:33:02 36874 8192000000 10897562960 11343249408 1974788480 19.423 100 20 40 0 1996472752 15121040 6563232
23:33:52 17053 8192000000 10914884144 11351355392 1982533904 19.485 100 33 66 1 2011669568 18786496 10349168
23:34:15 15966 8192000000 10924150272 11354652672 1983054864 19.489 100 44 88 1 2017236768 21170512 13011392
23:34:50 9625 8192000000 10941205104 11365359616 1989419408 19.539 100 63 126 1 2028548464 20212448 18916608
23:35:07 9098 8192000000 10944055984 11366223872 1991724912 19.557 100 57 112 1 2034393616 25340160 17328544
23:35:26 8750 8192000000 10924069696 11354267648 1981332032 19.475 100 42 84 0 2011876832 17260848 13283952
23:35:42 5482 8192000000 10938945344 11362811904 1987553440 19.524 100 58 115 2 2024288416 19369424 17365552
23:36:00 14918 8192000000 10933913936 11367923712 1990192912 19.545 100 57 114 0 2028774192 21659328 16921952
23:36:27 4783 8192000000 10950639904 11374481408 1995372576 19.586 100 57 112 0 2036624400 23671856 17579968
23:36:39 3081 8192000000 10957752432 11382525952 2005643184 19.667 100 76 150 0 2050892384 22587488 22661712
23:36:50 10169 8192000000 10947028784 11379884032 1999365248 19.618 100 65 130 1 2043204736 24535376 19304112
23:37:11 9591 8192000000 10953903152 11385757696 2001830432 19.637 100 59 119 1 2043332288 23483232 18018624
23:37:34 4591 8192000000 10950487536 11389353984 2003192320 19.648 100 51 100 0 2041530544 23554768 14783456
23:37:47 11530 8192000000 10960378800 11396243456 2007641824 19.683 100 55 110 1 2047529488 23073200 16814464
23:38:14 4599 8192000000 10953904640 11388321792 1976745328 19.439 98 57 114 0 2018641776 24865984 17030464
23:38:27 9042 8192000000 10955474688 11388837888 1987071504 19.521 99 57 114 0 2030283616 26177520 17034592
23:38:44 3721 8192000000 10964892352 11394977792 2009323680 19.696 100 63 126 3 2059595056 29506512 20764864
23:38:55 3220 8192000000 10979049120 11400105984 2008649904 19.691 100 65 131 2 2057924752 30045200 19229648
23:39:08 5010 8192000000 10980964800 11408457728 2011815200 19.716 100 64 128 0 2066211744 35564304 18832240
23:39:20 2703 8192000000 10979327616 11403014144 2002835856 19.645 99 84 167 0 2059041744 31598752 24607136
23:39:31 5788 8192000000 10980055024 11400265728 2005930880 19.669 100 74 146 1 2060696208 32724736 22040592
23:39:47 3222 8192000000 10968933168 11394756608 2002155440 19.640 100 73 147 1 2058569504 33852176 22561888
23:39:57 2035 8192000000 10980428864 11397140480 2001941936 19.638 100 77 154 0 2060752288 35181600 23628752
23:40:07 10416 8192000000 10969408080 11394719744 1986271232 19.514 99 62 124 1 2040006784 34413440 19322112
23:40:26 2954 8192000000 10959656400 11372396544 1975289600 19.427 99 87 171 4 2037515584 35522240 26703744
23:40:36 3364 8192000000 10980954960 11391754240 1994493552 19.579 100 93 181 2 2058697280 37344992 26858736
23:40:46 2106 8192000000 10972324448 11385987072 1993710560 19.573 100 90 180 0 2059339648 38264112 27364976
23:40:54 3581 8192000000 10972249408 11387555840 1988453152 19.532 100 90 179 0 2055228208 39782720 26992336
23:41:05 1985 8192000000 10981468880 11393343488 1991944960 19.559 100 85 173 1 2056876528 39647408 25284160
23:41:14 1829 8192000000 10977609184 11397218304 2000165760 19.624 100 82 164 1 2069511456 43042576 26303120
23:41:25 1982 8192000000 10981928880 11399987200 1998597312 19.612 100 79 158 1 2065363200 42547232 24218656
23:41:35 10499 8192000000 10965389264 11388305408 1991213456 19.553 100 68 132 0 2048146800 37431024 19502320
23:41:52 1505 8192000000 10992403296 11409903616 2006619424 19.675 100 91 182 1 2073546768 38812096 28115248
23:42:01 3286 8192000000 10970881056 11389452288 1993560272 19.572 100 87 173 1 2055744592 36224032 25960288
23:42:12 2807 8192000000 10933645024 11355516928 1931282704 19.077 97 76 152 1 1990787200 36873408 22631088
23:42:22 5099 8192000000 10937244640 11355791360 1961292896 19.316 100 81 162 0 2020840528 34637648 24909984
23:42:35 3570 8192000000 10937464256 11356577792 1963493056 19.334 100 80 160 0 2024304032 35445328 25365648
23:42:48 1906 8192000000 10932321600 11340828672 1946103952 19.195 99 88 172 0 2008631056 35973472 26553632
23:42:57 2989 8192000000 10934647520 11348094976 1950872368 19.233 99 79 154 0 2012707632 38382288 23452976
23:43:07 3787 8192000000 10946851184 11360485376 1964187232 19.339 100 81 161 1 2027448224 39048160 24212832
23:43:19 1281 8192000000 10944165152 11362783232 1967320624 19.364 100 77 155 2 2030974320 39566880 24086816
23:43:29 2478 8192000000 10921763840 11338731520 1948295376 19.213 100 74 144 2 2010720272 41180656 21244240
23:43:39 2962 8192000000 10932506960 11345223680 1938367952 19.134 99 86 171 0 2007714560 42281936 27064672
23:43:50 9816 8192000000 10902349616 11336142848 1943977824 19.178 100 48 96 0 1998181296 39007904 15195568
23:44:10 7298 8192000000 10933343936 11361566720 1960175056 19.307 100 51 102 0 2014005744 36651136 17179552
23:44:26 9056 8192000000 10921428512 11351330816 1938627232 19.136 99 52 103 0 1997018608 42111264 16280112
23:44:43 6927 8192000000 10912068912 11325636608 1924913584 19.026 99 69 136 0 1984358816 38403312 21041920
23:44:59 2017 8192000000 10925108992 11334017024 1939293248 19.141 100 85 169 1 2006053968 40919056 25841664
23:45:08 3772 8192000000 10940074528 11345534976 1948142144 19.212 100 89 178 1 2019817072 43541264 28133664
23:45:19 7140 8192000000 10935063440 11351953408 1953699088 19.256 100 75 150 0 2021219712 43770512 23750112
23:45:34 9272 8192000000 10921268240 11338014720 1925324816 19.029 99 66 132 1 1993531152 47913504 20292832
23:45:49 1203 8192000000 10932119968 11334766592 1918025408 18.971 99 86 173 2 1994099968 48303696 27770864
23:45:57 2177 8192000000 10934390672 11343376384 1939022768 19.139 100 91 179 3 2016649104 49695232 27931104
23:46:08 2744 8192000000 10940427824 11350163456 1946050624 19.195 100 87 175 1 2021767424 49321504 26395296
23:46:18 3851 8192000000 10941248256 11359334400 1952504384 19.246 100 75 149 2 2026177408 50962064 22710960
23:46:32 2885 8192000000 10938335408 11357675520 1947038640 19.203 100 69 135 2 2018591328 49953184 21599504
23:46:46 6863 8192000000 10924877856 11355193344 1947698208 19.208 100 45 88 1 2011713184 48604928 15410048
23:46:59 2023 8192000000 10945349392 11356045312 1941116272 19.156 99 80 161 3 2015993488 49760608 25116608
23:47:08 2782 8192000000 10945227824 11370622976 1957401744 19.285 100 73 147 3 2034066112 53180256 23484112
23:47:19 5529 8192000000 10937199024 11369172992 1954031824 19.259 100 49 98 2 2021382384 51102176 16248384
23:47:33 2132 8192000000 10943560512 11365650432 1959624544 19.303 100 56 109 2 2023028864 45994784 17409536
23:47:45 6673 8192000000 10931432752 11354193920 1942957744 19.170 99 63 126 0 2008675408 45736944 19980720
23:48:04 11953 8192000000 10913625840 11356307456 1941534576 19.159 100 43 86 1 2000624032 45231360 13858096
23:48:23 14886 8192000000 10917794560 11360477184 1942425520 19.166 100 29 58 0 1996701120 44267792 10007808
23:48:53 7733 8192000000 10875790992 11313307648 1893036096 18.770 98 29 58 0 1938090048 35650112 9403840
23:49:18 8810 8192000000 10892752768 11333910528 1920173264 18.988 99 34 68 1 1971284592 39969344 11141984
23:49:34 8982 8192000000 10891005248 11334021120 1934269936 19.101 100 28 55 6 1978685088 35013152 9402000
23:49:51 5606 8192000000 10911169456 11344683008 1944293104 19.181 100 46 90 1 1995188800 36832240 14063456
23:50:03 10885 8192000000 10889309360 11335544832 1932243664 19.085 100 32 64 1 1981715680 38574608 10897408
23:50:21 19839 8192000000 10899034144 11340914688 1918038864 18.971 99 25 50 1 1970705920 44524272 8142784
23:50:48 13417 8192000000 10886615728 11332542464 1913781088 18.937 99 27 54 0 1961496544 39010096 8705360
23:51:09 23851 8192000000 10889542160 11340353536 1929506864 19.063 100 20 39 1 1973437600 36699088 7231648
23:51:39 18927 8192000000 10894978000 11343544320 1934554432 19.103 100 24 48 1 1980373344 37362976 8455936
23:52:05 7376 8192000000 10896566000 11344957440 1935708848 19.112 100 20 40 1 1979945952 37511936 6725168
23:52:20 25423 8192000000 10917302464 11360780288 1944550368 19.183 100 24 46 1 1996101904 43029552 8521984
23:53:01 23912 8192000000 10914603872 11363024896 1928461536 19.055 99 23 44 4 1980465008 44221232 7782240
23:53:43 8650 8192000000 10910750336 11355766784 1935310096 19.109 100 29 58 1 1993825456 48285728 10229632
23:54:00 19301 8192000000 10913132768 11360989184 1940267584 19.149 100 31 60 0 1994019424 43310496 10441344
23:54:27 19743 8192000000 10913178928 11359277056 1926354448 19.038 99 45 90 1 1988079392 47057248 14667696
23:54:53 26098 8192000000 10914200400 11373424640 1927418784 19.046 99 23 46 1 1984566096 49407392 7739920
23:55:44 28138 8192000000 10901711520 11371970560 1928487088 19.055 99 20 40 2 1976162160 40505296 7169776
23:56:19 15151 8192000000 10911757568 11370934272 1940024320 19.147 100 15 30 1 1990871504 45756304 5090880
23:56:53 25478 8192000000 10892783712 11363319808 1941425328 19.158 100 19 38 2 1981790384 34321664 6043392
23:57:27 24526 8192000000 10887361840 11336314880 1905533664 18.871 98 25 49 2 1943858128 30892720 7431744
23:57:59 33080 8192000000 10899729856 11344621568 1939542848 19.143 100 41 82 2 1982644672 30763824 12338000
23:58:40 18016 8192000000 10904340848 11367231488 1949176992 19.220 100 24 47 1 1994550080 37657520 7715568
23:59:06 12482 8192000000 10913490608 11375878144 1957907280 19.289 100 24 46 1 2004333744 39265216 7161248
00:00:04 38073 8192000000 10898208976 11366805504 1942363056 19.166 100 10 20 2 1984416304 38896752 3156496
00:00:49 16639 8192000000 10889226336 11360059392 1926069472 19.035 99 17 34 1 1965753792 34911872 4772448
00:01:40 67494 8192000000 10889387584 11333550080 1927932768 19.050 99 26 48 0 1950939040 17007472 5998800
00:03:03 22455 8192000000 10885588144 11338555392 1929726944 19.065 99 36 68 0 1960944592 21426480 9791168
00:03:33 65472 8192000000 10870879424 11337216000 1909523872 18.903 98 17 34 2 1932943760 18496144 4923744
00:04:45 123523 8192000000 10906199024 11338350592 1945418800 19.190 100 25 48 2 1964809760 12673696 6717264
00:06:55 29172 8192000000 10900148016 11333287936 1940843344 19.153 99 61 121 2 1964864560 6682752 17338464
00:07:33 15600 8192000000 10895007056 11350122496 1969872912 19.384 100 56 111 2 1995933264 9527392 16532960
00:07:59 12312 8192000000 10904099568 11350507520 1970844672 19.392 100 56 109 0 1995000480 8264304 15891504
00:08:33 51798 8192000000 10891905440 11361927168 1971764736 19.399 100 25 47 0 1988253904 9229696 7259472
00:09:54 31936 8192000000 10901506672 11349491712 1960052608 19.306 99 29 57 1 1977035600 9431680 7551312
00:10:42 70597 8192000000 10877005072 11336445952 1934565616 19.103 99 35 70 0 1954273360 10177728 9530016
00:11:59 51180 8192000000 10868535248 11335127040 1919818192 18.985 98 30 60 0 1941479216 12777504 8883520
00:13:08 91091 8192000000 10895373648 11367403520 1964707760 19.343 100 9 18 0 1977976032 10829552 2438720
00:14:45 36147 8192000000 10905456656 11366600704 1978084576 19.450 100 17 35 1 1996354560 12774848 5495136
00:15:33 116577 8192000000 10886800608 11373686784 1937697328 19.128 98 15 30 0 1960880640 17994032 5189280
00:17:35 86879 8192000000 10895382864 11356254208 1932302128 19.085 98 26 52 2 1949553600 9993856 7257616
00:19:14 46438 8192000000 10891579808 11353997312 1949937536 19.226 99 34 68 1 1974027168 14426224 9663408
00:20:48 43364 8192000000 10912096576 11367575552 1983531680 19.493 100 40 80 1 2004926704 9723600 11671424
00:21:38 48065 8192000000 10906020160 11369168896 1979049520 19.457 100 24 48 1 1997143904 11248288 6846096
00:22:35 74015 8192000000 10889053408 11368804352 1964873472 19.345 99 10 20 2 1979768992 11718864 3176656
00:24:28 52425 8192000000 10888592432 11362598912 1945461808 19.190 98 5 10 0 1958292368 11715136 1115424
00:25:27 77534 8192000000 10875715536 11362398208 1936304480 19.117 98 15 29 3 1951028064 10663744 4059840
00:26:55 106146 8192000000 10893165040 11379994624 1918647888 18.976 97 7 14 0 1932321392 12042048 1631456
00:28:57 57256 8192000000 10859306800 11325648896 1873271088 18.611 95 14 28 2 1884880928 8060688 3549152
00:30:19 42912 8192000000 10916103440 11358400512 1963513232 19.334 100 24 48 0 1981565664 11302736 6749696
00:31:12 66457 8192000000 10869271440 11348541440 1899148512 18.819 97 13 26 0 1917038640 14223504 3666624
00:32:39 34628 8192000000 10905645744 11345989632 1952064992 19.243 100 34 66 0 1968662080 6860576 9736512
00:33:27 38379 8192000000 10869498768 11320836096 1925995360 19.035 99 37 72 4 1946461136 10578976 9886800
00:35:04 31324 8192000000 10886784288 11337502720 1943770704 19.177 100 38 76 2 1968103152 13663872 10668576
00:35:45 48942 8192000000 10857547456 11306188800 1853567664 18.451 95 27 54 0 1877412224 16048816 7795744
00:36:40 92348 8192000000 10849473024 11290914816 1817717408 18.159 94 28 56 0 1842087920 16584992 7785520
00:38:21 43601 8192000000 10841801776 11306033152 1880625808 18.670 97 41 82 0 1905787024 13776592 11384624
00:39:23 68634 8192000000 10880762384 11339948032 1929886640 19.066 99 12 24 0 1948942752 15686992 3369120
00:41:35 61706 8192000000 10841579520 11287044096 1818823520 18.168 94 23 46 1 1838363232 12899200 6640512
00:42:43 103673 8192000000 10837331424 11280044032 1881961792 18.681 98 30 60 0 1901157008 10889776 8305440
00:44:33 83307 8192000000 10843463856 11317260288 1886007952 18.714 98 21 42 0 1914199952 21995328 6196672
00:46:03 26912 8192000000 10817768448 11285680128 1878390144 18.652 98 7 13 0 1897667376 17616464 1660768
00:46:37 24969 8192000000 10830527200 11291529216 1912618096 18.928 100 41 85 4 1933071200 7960224 12492880
00:47:25 59107 8192000000 10852097152 11317018624 1922693568 19.008 100 12 24 1 1935469136 9238656 3536912
00:49:48 60263 8192000000 10860492272 11326939136 1910737936 18.913 98 20 39 1 1931241952 14761232 5742784
00:50:59 80742 8192000000 10864815600 11321667584 1914817136 18.945 99 18 35 1 1930390320 10592464 4980720
00:52:32 41457 8192000000 10838058576 11309252608 1897327584 18.805 98 14 28 1 1909566944 8289840 3949520
00:53:21 49801 8192000000 10858958736 11327905792 1909140384 18.900 99 14 27 1 1920908080 7947376 3820320
00:54:29 46554 8192000000 10877623152 11335839744 1926538736 19.039 99 18 36 0 1940477344 8524736 5413872
00:55:26 68846 8192000000 10863942832 11337187328 1951043744 19.235 100 11 22 0 1962092368 7847968 3200656
00:59:00 61763 8192000000 10885493184 11350159360 1939786288 19.145 98 18 36 1 1953675008 9379792 4508928
01:00:11 52817 8192000000 10875895328 11337023488 1890465792 18.750 96 18 36 2 1903362128 7806608 5089728
01:01:11 50738 8192000000 10898842800 11364229120 1927235392 19.045 98 17 34 1 1946470464 14452960 4782112
01:02:34 55014 8192000000 10892413792 11361361920 1935091088 19.108 98 18 36 0 1955335120 15292192 4951840
01:03:40 106047 8192000000 10906701232 11367137280 1928645920 19.056 98 25 50 2 1949807568 14071552 7090096
01:05:33 29022 8192000000 10908909120 11354140672 1939195680 19.140 98 32 60 2 1957476480 10210736 8070064
01:06:08 19190 8192000000 10935067120 11380350976 1984729328 19.502 100 52 104 0 2011380640 12915504 13735808
01:06:41 22278 8192000000 10950995824 11391610880 1978134880 19.450 99 61 122 0 2010817744 15469680 17213184
01:07:16 78897 8192000000 10907783440 11394760704 1964881552 19.345 99 28 56 1 1991252208 18362672 8007984
01:08:41 81312 8192000000 10890985328 11350040576 1899312256 18.821 96 19 36 1 1915633952 10937216 5384480
01:10:12 68143 8192000000 10907375808 11371913216 1973023312 19.409 100 14 28 0 1985967824 9011904 3932608
01:11:29 67122 8192000000 10925604384 11372462080 1945763248 19.193 98 22 44 0 1960694464 9056384 5874832
01:12:44 137894 8192000000 10890699632 11352272896 1884618208 18.702 95 32 64 1 1905653696 11482592 9552896
01:15:15 62657 8192000000 10872633808 11342446592 1923831008 19.018 98 19 38 2 1940227184 11033440 5362736
01:16:24 58133 8192000000 10880860512 11361538048 1957893712 19.289 100 20 40 2 1974455888 10816080 5746096
01:17:28 83820 8192000000 10888232832 11371065344 1944090944 19.179 99 9 18 0 1960610928 14140160 2379824
01:18:59 36569 8192000000 10882969136 11345027072 1927526368 19.047 98 11 22 1 1938589120 8057168 3005584
01:19:46 81656 8192000000 10888629504 11363676160 1955583728 19.271 99 8 16 0 1964922288 7113696 2224864
01:21:43 78114 8192000000 10873133616 11345780736 1927780000 19.049 98 18 36 1 1945551152 12428304 5342848
01:23:22 65688 8192000000 10873605248 11349262336 1918554720 18.975 98 9 18 1 1935712160 14654080 2503360
01:24:39 79803 8192000000 10878116112 11349495808 1901819776 18.841 97 8 16 1 1914074272 10257776 1996720
01:26:09 29015 8192000000 10858224400 11331268608 1887797264 18.728 96 21 42 1 1901123760 7179584 6146912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-11-2020 01:28:23 to 05-11-2020 01:28:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 05-11-2020 01:28:56 to 05-11-2020 01:28:57.

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          234369
MON$OLDEST_ACTIVE               235355
MON$OLDEST_SNAPSHOT             235355
MON$NEXT_TRANSACTION            235355
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                       2038304
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.33385 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33385 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33385 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33385 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 ---
:25: 
:26: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:00 2020
:27:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:28: 
:29: 
:30: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:04 2020
:31:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:32: 
:33: 
:34: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:04 2020
:35:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:36: 
:37: 
:38: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:04 2020
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:04 2020
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Thu Nov  5 01:27:04 2020
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

05.11.20 01:28:58. 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-05 01:29:01 No severe PSQL-related problems occured
05.11.20 01:29:02. End of report.