Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.03.2021 16:29
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17563452 kB
MemAvailable 31527484 kB
Buffers 0 kB
Cached 14146164 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-28 16:27:24
DTS_END                         2021-03-28 16:27:24.8870
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35814
TRN_ID                          229610
ATT_ID                          616
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: 8876.02 18606 1065122
customer order: creation 165.36 382 19843
customer order: refuse 14.51 374 1741
order to supplier: creation 43.98 1270 5277
order to supplier: removal 3.43 105118 411
invoice (draft): creation 43.50 3528 5220
invoice (draft): removal 52.18 823 6262
invoice accept: apply 38.63 19337 4635
invoice accept: cancel 46.56 810 5587
customer reserve: creation 3592.53 189 431104
customer reserve: removal 4592.98 61 551157
realization accept: apply 78.42 184 9410
realization accept: cancel 81.95 115 9834
payment from customer: creation 55.86 137 6703
payment from customer: removal 5.46 107 655
payment to supplier: creation 46.13 162 5535
payment to supplier: removal 3.37 77 404
service: total inventory turnovers 4.03 1207 483
service: total monetary turnovers 6.30 41 756
service: aggregate perf. data 0.84 21283 101
service: refresh index statistics 0.03 216920 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-03-2021 16:30:14 to 28-03-2021 16:30:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3178
TEST_TIME 2 3317
TEST_TIME 3 5095
TEST_TIME 4 4573
TEST_TIME 5 4403
TEST_TIME 6 4262
TEST_TIME 7 4174
TEST_TIME 8 4519
TEST_TIME 9 4898
TEST_TIME 10 5408
TEST_TIME 11 5539
TEST_TIME 12 6832
TEST_TIME 13 6997
TEST_TIME 14 7069
TEST_TIME 15 7169
TEST_TIME 16 7496
TEST_TIME 17 7772
TEST_TIME 18 7738
TEST_TIME 19 7986
TEST_TIME 20 8367
TEST_TIME 21 8518
TEST_TIME 22 8618
TEST_TIME 23 8699
TEST_TIME 24 8945
TEST_TIME 25 8870
TEST_TIME 26 8978
TEST_TIME 27 9492
TEST_TIME 28 9870
TEST_TIME 29 10527
TEST_TIME 30 10434
TEST_TIME 31 10337
TEST_TIME 32 10132
TEST_TIME 33 9943
TEST_TIME 34 9865
TEST_TIME 35 9846
TEST_TIME 36 9747
TEST_TIME 37 9773
TEST_TIME 38 9708
TEST_TIME 39 9704
TEST_TIME 40 9536
TEST_TIME 41 9609
TEST_TIME 42 9470
TEST_TIME 43 9410
TEST_TIME 44 9339
TEST_TIME 45 9307
TEST_TIME 46 9239
TEST_TIME 47 9494
TEST_TIME 48 9340
TEST_TIME 49 9286
TEST_TIME 50 9152
TEST_TIME 51 9230
TEST_TIME 52 9236
TEST_TIME 53 9208
TEST_TIME 54 9134
TEST_TIME 55 9058
TEST_TIME 56 8935
TEST_TIME 57 8939
TEST_TIME 58 8835
TEST_TIME 59 8847
TEST_TIME 60 8878
TEST_TIME 61 8879
TEST_TIME 62 8835
TEST_TIME 63 8856
TEST_TIME 64 8933
TEST_TIME 65 8887
TEST_TIME 66 9028
TEST_TIME 67 9013
TEST_TIME 68 9078
TEST_TIME 69 9010
TEST_TIME 70 9040
TEST_TIME 71 9161
TEST_TIME 72 9174
TEST_TIME 73 9196
TEST_TIME 74 9135
TEST_TIME 75 9044
TEST_TIME 76 9016
TEST_TIME 77 8957
TEST_TIME 78 8926
TEST_TIME 79 8885
TEST_TIME 80 8910
TEST_TIME 81 8831
TEST_TIME 82 8801
TEST_TIME 83 8820
TEST_TIME 84 8956
TEST_TIME 85 9034
TEST_TIME 86 8998
TEST_TIME 87 9018
TEST_TIME 88 9010
TEST_TIME 89 9057
TEST_TIME 90 9070
TEST_TIME 91 9081
TEST_TIME 92 9115
TEST_TIME 93 9120
TEST_TIME 94 9088
TEST_TIME 95 9065
TEST_TIME 96 9011
TEST_TIME 97 8991
TEST_TIME 98 9002
TEST_TIME 99 8954
TEST_TIME 100 8890
TEST_TIME 101 8827
TEST_TIME 102 8807
TEST_TIME 103 8927
TEST_TIME 104 8941
TEST_TIME 105 8934
TEST_TIME 106 8946
TEST_TIME 107 8968
TEST_TIME 108 8959
TEST_TIME 109 9004
TEST_TIME 110 8982
TEST_TIME 111 8988
TEST_TIME 112 9015
TEST_TIME 113 9072
TEST_TIME 114 9056
TEST_TIME 115 9030
TEST_TIME 116 9056
TEST_TIME 117 9007
TEST_TIME 118 8958
TEST_TIME 119 8947
TEST_TIME 120 8878

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2021 16:30:18 to 28-03-2021 16:30:21.

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 1466183 1466183 0 0.00 0 35856 6 0 0
doc_list_biud 1466183 1466183 0 0.00 0 50702 29 0 0
sp_add_invoice_to_stock 4744 4635 109 2.29 64 241908 19338 0 109
sp_cancel_adding_invoice 5587 5587 0 0.00 4 55563 810 0 0
sp_cancel_client_order 1741 1741 0 0.00 4 9905 375 0 0
sp_cancel_customer_reserve 551157 551157 0 0.00 1 50705 62 0 0
sp_cancel_pay_from_customer 655 655 0 0.00 3 10077 108 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 2 4367 77 0 0
sp_cancel_supplier_invoice 6274 6262 12 0.19 2 35410 823 0 12
sp_cancel_supplier_order 411 411 0 0.00 8 955003 105119 0 0
sp_cancel_write_off 9834 9834 0 0.00 1 25156 115 0 0
sp_client_order 19843 19843 0 0.00 3 41507 382 0 0
sp_customer_reserve 431104 431104 0 0.00 0 62729 190 0 0
sp_fill_shopping_cart 30334 30334 0 0.00 1 15875 38 0 0
sp_fill_shopping_cart_clo_res 431101 431101 0 0.00 0 20688 14 0 0
sp_get_clo_for_invoice 4630 4630 0 0.00 0 26150 312 0 0
sp_kill_cost_storno 16480 16480 0 0.00 0 25154 62 0 0
sp_kill_qstorno_ret_qs2qd 1118821 1118821 0 0.00 0 47349 33 0 0
sp_kill_qty_storno 589032 589032 0 0.00 0 50701 72 0 0
sp_lock_selected_doc 19666 19666 0 0.00 0 9153 5 0 0
sp_make_cost_storno 26278 26278 0 0.00 0 14474 56 0 0
sp_multiply_rows_for_pdistr 26278 26278 0 0.00 0 22471 34 0 0
sp_multiply_rows_for_qdistr 19843 19843 0 0.00 0 19972 160 0 0
sp_pay_from_customer 6703 6703 0 0.00 4 15397 137 0 0
sp_pay_to_supplier 5535 5535 0 0.00 4 22518 162 0 0
sp_payment_common 12238 12238 0 0.00 1 15180 40 0 0
sp_qd_handle_on_cancel_clo 1741 1741 0 0.00 0 9899 341 0 0
sp_qd_handle_on_invoice_upd_sts 10217 10217 0 0.00 0 21897 347 0 0
sp_qd_handle_on_reserve_upd_sts 9410 9410 0 0.00 0 25257 61 0 0
sp_reserve_write_off 9410 9410 0 0.00 6 25330 185 0 0
sp_supplier_invoice 5220 5220 0 0.00 6 77777 3528 0 0
sp_supplier_order 5277 5277 0 0.00 5 51386 1270 0 0
srv_aggregate_perf_data 101 101 0 0.00 2472 290841 21284 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1006 122446 33194 0 0
srv_find_qd_qs_mism 1020963 1020963 0 0.00 0 35855 5 0 0
srv_make_invnt_saldo 483 483 0 0.00 31 33396 1207 0 0
srv_make_money_saldo 756 756 0 0.00 1 12080 42 0 0
srv_recalc_idx_stat 4 4 0 0.00 113058 353365 216920 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4635 4635 0 0.00 0 11813 173 0 0
t$perf-norm:sp_cancel_adding_invoice 341 341 0 0.00 1 3598 95 0 0
t$perf-norm:sp_cancel_client_order 1741 1741 0 0.00 0 1152 12 0 0
t$perf-norm:sp_cancel_customer_reserve 701 701 0 0.00 0 2613 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 655 655 0 0.00 0 451 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 1300 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 370 370 0 0.00 0 1575 19 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 20264 1486 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 2661 10 0 0
t$perf-norm:sp_client_order 19843 19843 0 0.00 0 12168 19 0 0
t$perf-norm:sp_customer_reserve 946 946 0 0.00 0 9541 18 0 0
t$perf-norm:sp_pay_from_customer 6703 6703 0 0.00 0 9338 12 0 0
t$perf-norm:sp_pay_to_supplier 5535 5535 0 0.00 0 3805 10 0 0
t$perf-norm:sp_reserve_write_off 9410 9410 0 0.00 0 8482 10 0 0
t$perf-norm:sp_supplier_invoice 5220 5220 0 0.00 0 4218 20 0 0
t$perf-norm:sp_supplier_order 5277 5277 0 0.00 0 6910 17 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 553 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 1557 22 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 824 27 0 0
t$perf-norm:srv_make_money_saldo 756 756 0 0.00 0 994 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 9478 9260 218 2.30 0 8569 22 0 218
v_all_customers 35748 35748 0 0.00 0 18 1 0 0
v_all_suppliers 29076 29076 0 0.00 0 16 1 0 0
v_all_wares 39684 39684 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 682 682 0 0.00 0 3241 18 0 0
v_cancel_client_order 3482 3482 0 0.00 0 6963 8 0 0
v_cancel_customer_prepayment 1310 1310 0 0.00 0 6276 14 0 0
v_cancel_customer_reserve 1402 1402 0 0.00 0 283 3 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 2019 7 0 0
v_cancel_supplier_invoice 764 740 24 3.14 0 1915 18 0 24
v_cancel_supplier_order 822 822 0 0.00 0 1249 5 0 0
v_cancel_write_off 2006 2006 0 0.00 0 2363 14 0 0
v_max_id_clo_ord 5275 5275 0 0.00 0 432 1 0 0
v_max_id_clo_res 946 946 0 0.00 0 8554 22 0 0
v_max_id_ord_sup 5215 5215 0 0.00 0 1300 2 0 0
v_max_non_paid_invoice 1487 1487 0 0.00 0 1168 3 0 0
v_max_non_paid_realizn 3663 3663 0 0.00 0 14014 11 0 0
v_min_id_clo_ord 5275 5275 0 0.00 0 8247 8 0 0
v_min_id_clo_res 946 946 0 0.00 0 1168 4 0 0
v_min_id_ord_sup 5215 5215 0 0.00 0 5301 6 0 0
v_min_non_paid_invoice 5535 5535 0 0.00 0 14409 22 0 0
v_min_non_paid_realizn 6703 6703 0 0.00 0 15174 25 0 0
v_our_firm 10016 10016 0 0.00 0 15 1 0 0
v_reserve_write_off 18820 18820 0 0.00 0 8145 7 0 0
x_lock_depdocs_on_canc_invoice 11479 11479 0 0.00 0 18373 136 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 21543 390 0 0
x_make_qstorno_1000_1200 5277 5277 0 0.00 2 51353 1183 0 0
x_make_qstorno_1200_2000 5220 5220 0 0.00 3 71306 3398 0 0
x_make_qstorno_2100_3300 431104 431104 0 0.00 0 62729 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2021 16:30:22 to 28-03-2021 16:30:26.

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
13:57:27 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:34 15629 8192000000 10221117184 10529759232 943890128 10.331 75 52 102 2 963964448 2657728 17416592
13:58:00 25231 8192000000 10335699568 10649964544 1390736992 14.512 100 90 180 0 1424540400 4843072 28960336
13:58:33 28321 8192000000 10373742784 10693824512 1418216672 14.757 100 83 167 0 1451905968 6371008 27318288
13:59:10 24139 8192000000 10409475040 10733060096 1451855104 15.054 100 86 172 1 1487465168 7540080 28069984
13:59:43 33366 8192000000 10428104848 10756681728 1476530448 15.271 100 90 180 0 1514001664 8134512 29336704
14:00:31 19258 8192000000 10442312160 10777923584 1500663968 15.482 100 88 176 1 1537535488 8516192 28355328
14:01:01 17958 8192000000 10458795488 10799398912 1515815312 15.614 100 83 166 2 1551191392 8989136 26386944
14:01:33 16858 8192000000 10485689440 10827538432 1539190128 15.817 100 79 158 1 1573655616 9624464 24841024
14:01:58 24105 8192000000 10501890528 10855231488 1557112816 15.971 100 78 156 2 1590900464 10034128 23753520
14:02:33 15146 8192000000 10537922256 10890346496 1589455888 16.249 100 79 156 2 1623831568 10605552 23770128
14:02:59 12887 8192000000 10558045664 10916515840 1611616544 16.439 100 78 156 2 1646200784 11316368 23267872
14:03:22 13426 8192000000 10595617344 10954317824 1640668992 16.685 100 81 162 3 1676180752 11936416 23575344
14:03:43 9431 8192000000 10613083472 10976456704 1664741136 16.889 100 79 157 0 1700472880 12887024 22844720
14:04:04 7053 8192000000 10625375104 10992791552 1686343920 17.071 100 82 165 0 1723446528 13515024 23587584
14:04:19 9873 8192000000 10632692624 11000803328 1690717536 17.107 100 83 166 2 1728907808 13997488 24192784
14:04:40 9014 8192000000 10639231936 11013931008 1701509552 17.198 100 76 152 0 1737351744 14083232 21758960
14:04:59 5975 8192000000 10665442256 11036676096 1720920816 17.360 100 78 156 2 1755848560 12419328 22508416
14:05:14 6564 8192000000 10678514656 11058634752 1736783216 17.492 100 69 138 0 1768651168 12157840 19710112
14:05:27 4120 8192000000 10685123472 11063287808 1748444800 17.589 100 79 158 0 1783472608 12503792 22524016
14:05:38 3140 8192000000 10696282448 11074576384 1754912304 17.642 100 76 152 1 1788828048 12096608 21819136
14:05:48 4385 8192000000 10697217040 11080204288 1765252128 17.728 100 80 161 1 1800433920 12467568 22714224
14:06:00 4823 8192000000 10711854176 11094646784 1774578144 17.805 100 76 153 2 1808027040 11861648 21587248
14:06:12 3993 8192000000 10725418992 11101745152 1784122256 17.883 100 80 159 1 1817489968 11278672 22089040
14:06:23 9077 8192000000 10723584144 11113869312 1793745568 17.963 100 67 133 1 1823312544 11160000 18406976
14:06:40 5549 8192000000 10740026816 11134099456 1803338800 18.041 100 76 151 0 1836378016 12407712 20631504
14:06:52 3304 8192000000 10767915408 11151458304 1821326000 18.189 100 84 166 1 1857308016 12534192 23447824
14:07:01 2188 8192000000 10772252656 11156090880 1831850160 18.274 100 86 172 0 1869535424 13675120 24010144
14:07:10 2830 8192000000 10783290800 11167043584 1838178320 18.326 100 87 174 1 1875845312 12991984 24675008
14:07:20 2074 8192000000 10779118480 11163238400 1842596256 18.362 100 91 183 3 1881773376 13318880 25858240
14:07:30 3314 8192000000 10790231152 11174277120 1847633280 18.403 100 94 188 1 1886187552 11904976 26649296
14:07:39 2264 8192000000 10795763264 11182632960 1852579008 18.443 100 88 175 1 1891627328 13876960 25171360
14:07:48 1371 8192000000 10794481008 11181371392 1851574976 18.435 100 92 184 1 1892011088 14784976 25651136
14:07:56 1088 8192000000 10797944272 11183636480 1855975360 18.471 100 91 182 1 1895024048 13888400 25160288
14:08:03 2124 8192000000 10803673680 11189329920 1857678368 18.484 100 91 180 3 1897349744 13562848 26108528
14:08:12 1603 8192000000 10802236064 11189690368 1858963392 18.495 100 91 180 3 1897916288 13311008 25641888
14:08:21 2636 8192000000 10808009696 11191705600 1860138464 18.504 100 88 175 2 1897393808 11888416 25366928
14:08:30 2123 8192000000 10806580336 11194535936 1865773472 18.550 100 85 171 0 1902612944 13040192 23799280
14:08:39 2094 8192000000 10812906064 11199504384 1865650960 18.549 100 87 174 0 1904172096 12989824 25531312
14:08:47 1850 8192000000 10817117936 11203895296 1871559776 18.597 100 97 195 1 1912491952 13897824 27034352
14:08:55 1855 8192000000 10817930384 11204018176 1870716016 18.590 100 98 198 2 1911850592 13434544 27700032
14:09:04 12413 8192000000 10774892960 11197591552 1867442864 18.564 100 65 131 1 1898295104 12669824 18182416
14:09:40 1365 8192000000 10802670416 11207872512 1871518784 18.597 100 71 143 0 1903032768 11125232 20388752
14:09:49 3272 8192000000 10795907504 11207786496 1868346816 18.571 100 44 88 1 1890706992 10156800 12203376
14:10:00 2396 8192000000 10782155008 11200741376 1869837824 18.583 100 41 82 1 1890343952 8626784 11879344
14:10:08 4913 8192000000 10787052928 11206905856 1873782928 18.615 100 44 88 4 1894908864 8810080 12315856
14:10:21 5657 8192000000 10791012464 11208273920 1872899280 18.608 100 26 53 3 1887047600 6855328 7292992
14:10:34 5585 8192000000 10791561744 11212070912 1876223424 18.635 100 34 68 2 1893847680 8098560 9525696
14:10:49 7904 8192000000 10793713952 11219927040 1878892720 18.656 100 28 56 1 1892554112 6121216 7540176
14:11:03 6110 8192000000 10794617280 11217379328 1879676576 18.662 100 33 65 2 1894588960 5598160 9314224
14:11:16 14394 8192000000 10781912224 11213398016 1882544208 18.686 100 44 87 1 1902045872 6515536 12986128
14:12:14 22098 8192000000 10803263776 11228819456 1886041968 18.714 100 28 56 0 1899891072 6083376 7765728
14:12:43 6236 8192000000 10822022512 11236503552 1889549760 18.742 100 37 74 1 1906855488 7442256 9863472
14:12:58 3597 8192000000 10813410240 11236012032 1889974064 18.746 100 43 86 2 1908909072 6388832 12546176
14:13:10 6058 8192000000 10800465760 11230904320 1887855280 18.728 100 24 49 1 1900846464 6517728 6473456
14:13:23 6887 8192000000 10807490288 11234123776 1890020720 18.746 100 33 65 3 1906231904 6958160 9253024
14:13:39 7213 8192000000 10821955168 11245735936 1892010016 18.762 100 24 46 1 1909644096 11017744 6616336
14:13:55 8719 8192000000 10806089808 11235151872 1893226688 18.772 100 23 46 0 1905910672 5719824 6964160
14:14:11 5293 8192000000 10808125536 11241811968 1898284192 18.812 100 41 82 3 1917563280 7675920 11603168
14:14:24 11139 8192000000 10813535072 11245948928 1894672160 18.783 100 17 34 1 1909119968 9896992 4550816
14:14:42 6906 8192000000 10805433728 11242283008 1896475712 18.798 100 18 34 1 1907752224 5870768 5405744
14:15:00 16755 8192000000 10802648160 11238793216 1876878912 18.640 99 11 22 0 1885634944 5866640 2889392
14:15:26 9906 8192000000 10811817456 11248824320 1897702544 18.808 100 14 28 1 1911614304 9784688 4127072
14:15:42 16598 8192000000 10803924432 11237888000 1881514560 18.677 99 30 61 1 1895651632 5174688 8962384
14:16:04 53525 8192000000 10833095712 11244937216 1885969088 18.713 99 61 121 3 1909761536 6047040 17745408
14:17:04 7128 8192000000 10804964928 11238395904 1894028448 18.778 100 28 56 2 1909500400 8032896 7439056
14:17:19 9266 8192000000 10807841232 11241410560 1895585712 18.791 100 28 56 2 1909617456 6571936 7459808
14:17:35 5888 8192000000 10811793984 11242754048 1896633456 18.799 100 22 44 1 1908905104 5920960 6350688
14:17:49 3570 8192000000 10819285360 11250806784 1903215008 18.852 100 30 60 1 1919092560 6513008 9364544
14:18:01 6858 8192000000 10789986224 11224920064 1865529264 18.548 98 21 42 0 1877829616 6736160 5564192
14:18:15 5364 8192000000 10789002480 11220799488 1846906864 18.397 98 29 58 0 1861504800 6782464 7815472
14:18:33 5578 8192000000 10780968896 11207663616 1849729568 18.420 99 24 48 1 1862685520 6150992 6804960
14:18:45 5551 8192000000 10790200464 11214798848 1869750752 18.582 100 22 45 2 1881070496 5352240 5967504
14:18:57 7334 8192000000 10736818096 11156434944 1723327072 17.380 93 21 42 0 1734646096 5125104 6193920
14:19:15 9942 8192000000 10681695680 11102408704 1678184080 17.002 93 25 49 0 1689527664 4807104 6536480
14:19:32 8049 8192000000 10686633328 11089367040 1706635456 17.241 95 26 52 1 1720379504 5579152 8164896
14:19:47 60028 8192000000 10670082160 11093942272 1655556144 16.811 92 24 46 1 1667753760 4630352 7567264
14:20:53 22185 8192000000 10681916928 11095207936 1675663056 16.981 93 17 34 0 1686178784 5633488 4882240
14:21:22 6604 8192000000 10668934816 11077525504 1719619376 17.349 97 19 37 1 1730652288 5508832 5524080
14:21:34 4780 8192000000 10654715680 11063525376 1704505920 17.223 97 29 57 2 1718384976 4847008 9032048
14:21:47 5952 8192000000 10689417200 11094536192 1740030848 17.519 98 28 56 1 1753903792 6266064 7606880
14:22:00 7406 8192000000 10689581984 11105198080 1765739872 17.732 99 31 62 1 1781031008 6038096 9253040
14:22:16 7363 8192000000 10696349504 11104100352 1761218336 17.694 98 32 65 3 1777059920 6296320 9545264
14:22:31 5167 8192000000 10728207680 11135504384 1790190032 17.933 99 40 80 4 1807268784 5857680 11221072
14:22:44 9808 8192000000 10715046448 11131142144 1789417216 17.927 99 26 52 1 1802667472 5582464 7667792
14:23:03 9718 8192000000 10711989872 11135107072 1797679264 17.995 99 29 58 2 1813231200 6987216 8564720
14:23:23 7459 8192000000 10753959280 11166535680 1824076912 18.211 100 22 44 0 1837469648 5729808 7662928
14:23:37 14900 8192000000 10751556352 11171913728 1829702752 18.257 100 15 30 1 1839598976 5427664 4468560
14:24:01 6652 8192000000 10766674752 11180969984 1842589952 18.362 100 23 45 0 1855660688 5655696 7415040
14:24:17 71592 8192000000 10756083456 11191795712 1854013968 18.455 100 35 70 1 1869867968 6266112 9587888
14:25:43 10654 8192000000 10763164544 11192672256 1852400368 18.442 100 21 42 2 1864424800 6343088 5681344
14:26:01 10618 8192000000 10774871936 11198808064 1856908624 18.478 100 22 42 3 1868740832 5394912 6437296
14:26:17 7621 8192000000 10782100240 11206279168 1863339408 18.530 100 32 64 1 1879346528 7413600 8593520
14:26:32 8437 8192000000 10785016848 11211235328 1864810432 18.542 100 24 48 0 1881626656 10022240 6793984
14:26:47 8674 8192000000 10781218448 11213803520 1867206448 18.562 100 24 48 2 1884132352 9971120 6954784
14:27:01 8887 8192000000 10793809232 11224977408 1877379056 18.644 100 24 50 1 1889251136 4764320 7107760
14:27:19 8272 8192000000 10807832016 11240415232 1895808112 18.793 100 21 43 0 1906587488 4479856 6299520
14:27:37 6978 8192000000 10839522896 11254784000 1911044464 18.915 100 53 104 4 1931224592 4607232 15572896
14:28:04 16705 8192000000 10850003216 11269627904 1921351216 18.998 100 53 105 1 1948042352 11783248 14907888
14:28:29 30447 8192000000 10869324496 11286970368 1925046352 19.027 100 56 110 4 1953787056 13380656 15360048
14:29:08 8406 8192000000 10861433456 11285643264 1931399680 19.078 100 53 106 1 1956865328 10136176 15329472
14:29:36 44614 8192000000 10868521088 11300085760 1935889392 19.114 100 40 80 0 1958562624 11102224 11571008
14:30:49 10878 8192000000 10874806016 11307560960 1947999312 19.211 100 40 80 1 1968771856 8835104 11937440
14:31:17 29104 8192000000 10891714544 11322908672 1956225136 19.276 100 36 72 2 1977627232 10427600 10974496
14:32:01 65006 8192000000 10903483344 11342274560 1963958912 19.337 100 31 62 1 1986214224 12555968 9699344
14:33:35 33956 8192000000 10907928112 11348602880 1973455216 19.413 100 36 70 1 1997245744 14221472 9569056
14:34:15 29676 8192000000 10921465392 11358461952 1976774512 19.439 100 32 62 1 2000285280 14398832 9111936
14:35:04 6704 8192000000 10934438528 11362603008 1991518416 19.556 100 65 130 1 2026214768 15922144 18774208
14:35:19 2932 8192000000 10940830416 11363282944 1990854784 19.551 100 61 118 1 2024986368 16841344 17290240
14:35:30 7798 8192000000 10933178528 11371036672 1994072208 19.576 100 61 121 0 2028282880 16421808 17788864
14:35:46 2495 8192000000 10955993280 11381145600 1999807344 19.621 100 69 138 1 2041700176 22133920 19758912
14:35:56 3309 8192000000 10946961520 11379003392 1999738208 19.621 100 56 112 1 2034139392 17848928 16552256
14:36:07 6962 8192000000 10952730352 11384025088 2003935456 19.654 100 56 111 0 2038757472 18262928 16559088
14:36:25 2938 8192000000 10953289200 11387502592 2006618112 19.675 100 60 119 1 2042951504 18979136 17354256
14:36:35 5576 8192000000 10963333040 11396120576 2010328352 19.704 100 62 122 0 2047458848 18911248 18219248
14:36:46 3430 8192000000 10976403520 11402395648 2016662544 19.754 100 73 145 2 2058668624 20871264 21134816
14:36:56 2133 8192000000 10959485280 11391148032 1997599024 19.604 99 65 130 1 2039214016 22263440 19351552
14:37:06 1946 8192000000 10976486592 11400646656 2014940832 19.740 100 77 154 1 2061252064 23919776 22391456
14:37:18 3775 8192000000 10962735168 11384782848 2013003408 19.725 100 86 171 0 2062223232 24725888 24493936
14:37:28 10174 8192000000 10962909856 11396608000 2007305296 19.680 100 66 132 0 2053448976 25384096 20759584
14:37:47 6033 8192000000 10955366704 11391873024 2011453680 19.713 100 72 143 2 2055242832 22489616 21299536
14:38:05 6578 8192000000 10969738768 11394207744 2006083856 19.671 100 64 126 0 2050825504 25756432 18985216
14:38:20 15377 8192000000 10961193088 11395833856 1988159024 19.529 99 51 102 0 2030066944 25784960 16122960
14:38:47 9864 8192000000 10974658640 11408699392 2016717216 19.754 100 73 146 1 2068760960 29779600 22264144
14:39:04 2661 8192000000 10977026016 11413954560 2019276400 19.774 100 64 126 1 2067881664 29537152 19068112
14:39:14 5234 8192000000 10974032896 11409694720 2017289200 19.759 100 59 118 0 2060096576 25133728 17673648
14:39:26 3985 8192000000 10991894288 11418071040 2024917664 19.819 100 78 155 1 2074936896 26658448 23360784
14:39:37 2327 8192000000 10980745904 11407216640 2002522080 19.643 99 76 152 2 2053977024 27649312 23805632
14:39:46 2706 8192000000 10985540272 11410149376 2017097984 19.757 100 88 173 1 2071934416 28084528 26751904
14:39:56 1789 8192000000 10982257104 11404496896 2015163872 19.742 100 85 171 0 2066773664 25788880 25820912
14:40:05 2261 8192000000 10960938000 11386499072 1989365152 19.539 99 73 145 3 2032639888 22259520 21015216
14:40:16 4952 8192000000 10964729456 11397713920 2010801584 19.708 100 67 134 1 2053500736 22955376 19743776
14:40:28 7559 8192000000 10969637200 11405701120 2016453824 19.752 100 62 124 1 2058100096 22830624 18815648
14:40:43 2894 8192000000 10967213856 11400572928 1995436240 19.587 99 59 118 1 2037825648 24833472 17555936
14:40:54 1002 8192000000 10981757792 11404734464 2016566352 19.753 100 70 136 2 2061970464 24512560 20891552
14:41:02 2570 8192000000 10999276304 11419557888 2026180608 19.829 100 79 158 2 2076164912 25889088 24095216
14:41:11 3614 8192000000 10995387184 11418009600 2020747136 19.786 100 74 148 1 2069218208 25911520 22559552
14:41:24 2675 8192000000 10962536016 11393003520 1974154928 19.418 98 62 124 1 2017530928 24846544 18529456
14:41:36 5685 8192000000 10956114848 11388485632 1999522912 19.619 100 64 127 0 2044232064 25418032 19291120
14:41:51 1788 8192000000 10976769648 11393511424 1988869888 19.535 99 86 171 0 2042479392 28696944 24912560
14:42:01 2196 8192000000 10971488064 11391913984 2000550544 19.627 100 83 166 1 2055542688 30289072 24703072
14:42:10 7098 8192000000 10963655088 11394764800 1999201088 19.616 100 70 140 1 2050923056 30431680 21290288
14:42:26 7911 8192000000 10966786800 11405631488 2009032800 19.694 100 58 116 1 2057245984 30053264 18159920
14:42:40 4413 8192000000 10916644112 11342602240 1947681216 19.208 98 57 112 0 1995771056 28571312 19518528
14:42:54 12015 8192000000 10942994320 11378073600 1983037120 19.489 100 57 114 0 2030689968 29159008 18493840
14:43:22 1335 8192000000 10968053200 11391832064 1991383120 19.555 100 73 145 1 2045844672 32140288 22321264
14:43:33 4940 8192000000 10970642976 11397398528 1998504304 19.611 100 63 124 1 2051757632 34008832 19244496
14:43:46 2296 8192000000 10947873760 11368251392 1953666640 19.256 98 82 164 3 2010330416 31779296 24884480
14:43:57 2649 8192000000 10932110752 11344797696 1919019872 18.979 97 89 177 1 1979514096 33265280 27228944
14:44:06 2299 8192000000 10944911040 11365416960 1952939984 19.250 99 82 164 0 2019096496 41324960 24831552
14:44:19 7022 8192000000 10927123520 11350450176 1965665456 19.351 100 77 153 4 2019552768 31030688 22856624
14:44:33 3196 8192000000 10924798352 11341979648 1943874592 19.178 99 79 159 0 1998934112 31396208 23663312
14:44:49 4445 8192000000 10927290144 11342446592 1947894864 19.210 100 70 136 3 2002845616 33809920 21140832
14:45:01 6641 8192000000 10919529840 11335720960 1930996432 19.075 99 75 150 2 1988118992 33356272 23766288
14:45:22 6940 8192000000 10927112896 11346538496 1949319888 19.221 100 66 132 0 2007692560 37439392 20933280
14:45:39 2826 8192000000 10927827680 11347361792 1935678672 19.112 99 73 146 1 1995158048 37483712 21995664
14:45:51 2610 8192000000 10933789184 11345596416 1945464864 19.190 100 88 175 0 2012792608 39399376 27928368
14:45:59 2252 8192000000 10936588704 11350609920 1950138832 19.228 100 74 144 0 2011867040 39394880 22333328
14:46:09 2837 8192000000 10928902832 11345477632 1942180864 19.164 99 85 171 1 2007202448 38433712 26587872
14:46:18 4423 8192000000 10939050208 11351699456 1953607440 19.255 100 82 164 0 2019278176 39585312 26085424
14:46:32 2480 8192000000 10946268672 11360354304 1960119328 19.307 100 83 163 0 2026215648 40831056 25265264
14:46:41 5895 8192000000 10941896352 11359965184 1956334320 19.277 100 64 126 2 2017677808 41475872 19867616
14:46:55 5553 8192000000 10914971360 11353239552 1950823856 19.233 100 55 110 1 2011408368 43020016 17564496
14:47:07 9141 8192000000 10922420736 11364933632 1957003264 19.282 100 42 83 2 2017359968 46301152 14055552
14:47:24 8666 8192000000 10926022512 11360141312 1962159136 19.323 100 41 82 0 2010888640 34408064 14321440
14:47:50 6814 8192000000 10927455072 11348848640 1942226592 19.165 99 62 120 1 1996291520 35066576 18998352
14:48:03 5685 8192000000 10922243824 11344052224 1949487248 19.222 100 56 112 2 2003191488 36380080 17324160
14:48:16 3556 8192000000 10947647408 11362115584 1962722976 19.328 100 67 129 1 2019913552 36396016 20794560
14:48:27 4251 8192000000 10944646064 11368898560 1970793280 19.392 100 52 104 0 2026514112 38551504 17169328
14:48:38 11403 8192000000 10940546832 11379859456 1975944560 19.433 100 51 102 2 2031717552 38611184 17161808
14:48:57 5240 8192000000 10941940208 11378315264 1974989136 19.425 100 51 100 3 2027553024 35707024 16856864
14:49:11 8338 8192000000 10945954448 11378708480 1977372576 19.444 100 53 106 1 2031269072 37171040 16725456
14:49:44 7409 8192000000 10939948112 11379081216 1976218144 19.435 100 49 98 4 2030122160 37785200 16118816
14:50:06 2663 8192000000 10949458848 11373707264 1973342752 19.412 100 57 112 0 2030207872 39089136 17775984
14:50:15 11479 8192000000 10941127840 11384500224 1980659248 19.470 100 41 82 3 2032132032 38484032 12988752
14:50:37 28023 8192000000 10938713600 11389247488 1976366608 19.436 100 31 63 0 2027035120 40239600 10428912
14:51:18 4540 8192000000 10960515600 11398062080 1988127584 19.529 100 53 106 1 2042981296 37891280 16962432
14:51:30 17017 8192000000 10930119776 11381182464 1965851712 19.353 99 32 64 2 2011642848 35267120 10524016
14:51:58 4969 8192000000 10947137792 11384381440 1966186320 19.355 99 57 113 1 2016534992 32077152 18271520
14:52:15 27011 8192000000 10937052096 11388747776 1978013536 19.449 100 25 50 1 2023946480 37283360 8649584
14:53:02 21372 8192000000 10950175952 11401568256 1981783616 19.479 100 26 52 1 2033650464 42800224 9066624
14:53:29 17674 8192000000 10922810448 11377381376 1948982256 19.218 99 20 40 1 1994943712 38476080 7485376
14:54:25 28692 8192000000 10913861344 11379220480 1952181536 19.244 100 26 53 0 2005056896 43494880 9380480
14:55:01 30603 8192000000 10892166224 11355635712 1888026992 18.730 97 19 38 1 1938909808 43906912 6975904
14:55:44 41137 8192000000 10887561856 11348426752 1895891520 18.793 98 14 28 4 1943624208 42783856 4948832
14:56:45 30337 8192000000 10866622448 11335548928 1911275840 18.917 99 18 36 1 1940892720 24247280 5369600
14:57:22 29564 8192000000 10861902128 11311235072 1946089184 19.195 100 19 38 2 1962020544 10649024 5282336
14:58:30 100756 8192000000 10894312496 11349848064 1965371296 19.349 100 20 40 1 1981659408 10238768 6049344
15:00:47 47330 8192000000 10880764016 11347935232 1932103392 19.084 98 34 67 0 1952595280 10994416 9497472
15:01:51 44978 8192000000 10910532128 11365978112 1971153216 19.395 100 31 61 4 1993034816 13235120 8646480
15:02:45 41808 8192000000 10920263200 11378163712 1978214528 19.451 100 16 32 2 1997994208 14644160 5135520
15:03:34 66423 8192000000 10942749680 11401519104 1998877120 19.614 100 31 61 0 2021462192 13217056 9368016
15:05:00 55220 8192000000 10897971696 11359645696 1972713392 19.407 99 28 55 0 1992870928 11734496 8423040
15:06:05 113935 8192000000 10896102272 11345993728 1941703968 19.160 98 12 23 1 1957272976 12535120 3033888
15:08:35 66381 8192000000 10895110240 11361038336 1956879488 19.281 99 19 38 2 1979971456 17223072 5868896
15:09:48 44592 8192000000 10914112448 11376721920 1981920992 19.480 100 19 38 0 2003699104 16017792 5760320
15:10:43 73594 8192000000 10905444512 11384938496 1964727408 19.344 99 16 32 1 1988192736 18454544 5010784
15:12:49 93516 8192000000 10922121952 11400015872 1989944624 19.543 100 31 62 3 2018379440 19448624 8986192
15:14:49 80593 8192000000 10921788944 11386490880 1996202928 19.593 100 20 40 1 2011348064 9543792 5601344
15:16:16 23800 8192000000 10936681808 11403104256 2006430064 19.673 100 28 56 1 2023657424 9455616 7771744
15:17:25 45088 8192000000 10927463360 11398778880 1997334960 19.602 99 38 74 0 2020807168 11788896 11683312
15:18:41 60292 8192000000 10926052016 11410759680 1981043376 19.473 99 7 14 0 2000081088 17381152 1656560
15:19:49 82300 8192000000 10918994864 11394502656 1982343680 19.483 99 12 24 0 1999277888 13937280 2996928
15:23:25 99169 8192000000 10915144320 11409469440 2006845072 19.677 100 17 35 1 2022031424 9743424 5442928
15:25:38 53973 8192000000 10911021856 11388186624 1973612096 19.414 99 9 18 1 1984645392 8187952 2845344
15:26:41 71342 8192000000 10914106944 11401175040 1982965520 19.488 99 13 26 0 1995665264 9002016 3697728
15:28:03 51342 8192000000 10919597440 11401678848 1987538784 19.524 99 11 22 1 1998751696 8808048 2404864
15:29:01 28314 8192000000 10908138224 11378094080 1963851088 19.337 98 37 74 2 1980304368 6291648 10161632
15:29:39 40032 8192000000 10905358480 11369549824 1934380672 19.102 97 23 46 0 1952176576 11638336 6157568
15:30:25 51248 8192000000 10906852224 11377180672 1937462528 19.127 98 17 35 0 1953651648 11279216 4909904
15:31:22 88394 8192000000 10891306240 11362521088 1865933152 18.551 94 13 26 1 1886611136 16881600 3796384
15:32:57 78128 8192000000 10911099088 11381891072 1937840288 19.130 98 19 38 0 1961060640 18208992 5011360
15:34:26 29207 8192000000 10918139392 11384623104 1970119568 19.386 99 37 74 0 1995552560 15517296 9915696
15:35:08 66077 8192000000 10869284000 11343642624 1865116608 18.545 94 12 24 0 1881302384 12816816 3368960
15:36:22 105247 8192000000 10874291568 11349147648 1831080320 18.268 93 30 58 2 1860246592 21005712 8160560
15:38:13 48248 8192000000 10859234272 11330519040 1875975264 18.633 97 3 6 0 1893842448 17253344 613840
15:39:23 100165 8192000000 10819977632 11283509248 1745893056 17.568 90 14 28 2 1759402336 9369360 4139920
15:41:13 105900 8192000000 10866726192 11315625984 1889835888 18.744 98 40 80 0 1910065376 8834432 11395056
15:43:06 80577 8192000000 10845524768 11303534592 1893203424 18.772 98 23 46 0 1909086512 9863344 6019744
15:44:37 9093 8192000000 10860333872 11311009792 1916949664 18.962 99 44 88 1 1939866480 10398576 12518240
15:44:52 33268 8192000000 10820996112 11294597120 1868090160 18.569 97 31 62 1 1889165216 12342816 8732240
15:45:38 43459 8192000000 10842156880 11314040832 1921052384 18.995 100 14 28 0 1937590736 12929872 3608480
15:46:41 49331 8192000000 10847723072 11314536448 1915004912 18.947 99 11 22 0 1934088576 15280320 3803344
15:48:10 50289 8192000000 10891116416 11365347328 1953113936 19.251 100 11 22 1 1980151584 23796240 3241408
15:49:07 68210 8192000000 10870075200 11337146368 1896309408 18.797 97 12 24 0 1925766928 25441696 4015824
15:50:23 59768 8192000000 10869508656 11339755520 1922422048 19.006 99 13 26 1 1950966448 24239392 4305008
15:51:34 37119 8192000000 10855002752 11344187392 1908327312 18.893 99 12 24 1 1934870544 22676464 3866768
15:52:21 101606 8192000000 10843967264 11299377152 1817285952 18.155 94 16 32 0 1830036224 8393328 4356944
15:54:14 81583 8192000000 10895944256 11336691712 1920418256 18.990 99 35 70 0 1944148720 13697680 10032784
15:55:51 86802 8192000000 10880722608 11340546048 1904180064 18.860 98 19 38 0 1919695712 10940832 4574816
15:57:24 77325 8192000000 10877942352 11337695232 1878208656 18.651 96 23 46 2 1896929872 12714544 6006672
15:58:48 79128 8192000000 10880201008 11338199040 1849559296 18.419 95 21 42 0 1868016944 12281872 6175776
16:00:13 38358 8192000000 10900349856 11342430208 1930883072 19.074 99 24 48 1 1945878688 8634144 6361472
16:00:58 43143 8192000000 10902657776 11359686656 1961604560 19.319 100 35 70 1 1984480096 13141088 9734448
16:01:49 122446 8192000000 10898237424 11363659776 1930858800 19.074 98 44 88 0 1961046064 17955344 12231920
16:04:01 62046 8192000000 10889380640 11365703680 1967274304 19.364 100 16 32 1 1982141680 10591392 4275984
16:05:53 28358 8192000000 10900546176 11378745344 1961159536 19.315 99 13 26 0 1980606992 15886784 3560672
16:06:39 92331 8192000000 10920232656 11393662976 1983703008 19.494 100 8 16 0 1999795952 13678336 2414608
16:08:35 101489 8192000000 10921849584 11410415616 1990057920 19.544 100 18 36 1 2018931856 23117600 5756336
16:11:17 33312 8192000000 10913383216 11379032064 1952366640 19.245 98 29 55 0 1971915808 11743616 7805552
16:12:10 91901 8192000000 10909503888 11382157312 1966357216 19.357 99 16 32 1 1984762000 12753552 5651232
16:13:49 79021 8192000000 10937903712 11408179200 1991302688 19.554 100 26 52 1 2006406432 7675280 7428464
16:15:19 33525 8192000000 10935667680 11409092608 2004305664 19.657 100 29 58 1 2024421168 11583344 8532160
16:15:59 101144 8192000000 10924551712 11395788800 1922944480 19.010 96 24 48 0 1943686832 13574384 7167968
16:17:47 74609 8192000000 10908546800 11376676864 1892746864 18.768 95 18 36 1 1907932512 10416912 4768736
16:19:15 69834 8192000000 10896356032 11373129728 1923773440 19.017 98 14 28 0 1942741360 15409344 3558576
16:20:31 116125 8192000000 10862583344 11326709760 1784071856 17.883 91 9 18 0 1805995840 19567408 2356576
16:22:36 39081 8192000000 10902267584 11364909056 1936590320 19.120 100 25 49 2 1957468416 13892880 6985216
16:23:21 98661 8192000000 10880738608 11351212032 1934571712 19.103 99 12 24 0 1952221792 14323056 3327024
16:25:17 46409 8192000000 10879110672 11337134080 1904418928 18.862 97 40 78 0 1926507040 10636912 11451200
16:26:10 37123 8192000000 10877993088 11354976256 1953072016 19.251 100 30 59 2 1978436832 16661280 8703536
16:26:53 48518 8192000000 10592362288 11048894464 1691978528 17.118 87 6 11 0 1704007840 10284512 1744800

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-03-2021 16:30:28 to 28-03-2021 16:30:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 109 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-03-2021 16:31:00 to 28-03-2021 16:31:02.

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          229772
MON$OLDEST_ACTIVE               230145
MON$OLDEST_SNAPSHOT             230145
MON$NEXT_TRANSACTION            230145
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                       2009216
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:66: 
:67: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:77: 
:78: 
:79: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
:82: 
:83: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:84:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:85: 
:86: 
:87: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:88:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:89: 
:90: 
:91: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:92:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:93: 
:94: 
:95: mscs-test-161.budzdorov.ru    Sun Mar 28 16:28:24 2021
:96:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:97: 
--- end of diff output ---

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

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