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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17524320 kB
MemAvailable 31483556 kB
Buffers 0 kB
Cached 14157696 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-31 01:27:28
DTS_END                         2021-03-31 01:27:28.3660
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/45204
TRN_ID                          228676
ATT_ID                          664
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: 8904.52 22548 1068542
customer order: creation 160.82 359 19298
customer order: refuse 13.78 343 1654
order to supplier: creation 42.89 1401 5147
order to supplier: removal 3.50 101293 420
invoice (draft): creation 44.38 3656 5325
invoice (draft): removal 50.81 765 6097
invoice accept: apply 40.11 18771 4813
invoice accept: cancel 46.18 684 5542
customer reserve: creation 3726.78 184 447214
customer reserve: removal 4488.97 62 538676
realization accept: apply 78.92 174 9470
realization accept: cancel 83.38 117 10006
payment from customer: creation 55.81 116 6697
payment from customer: removal 5.54 66 665
payment to supplier: creation 47.19 125 5663
payment to supplier: removal 3.53 80 423
service: total inventory turnovers 4.72 977 567
service: total monetary turnovers 6.39 24 767
service: aggregate perf. data 0.78 22329 94
service: refresh index statistics 0.03 299426 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2021 01:28:51 to 31-03-2021 01:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3606
TEST_TIME 2 2200
TEST_TIME 3 3135
TEST_TIME 4 3518
TEST_TIME 5 3694
TEST_TIME 6 4170
TEST_TIME 7 4699
TEST_TIME 8 4945
TEST_TIME 9 5500
TEST_TIME 10 5734
TEST_TIME 11 5966
TEST_TIME 12 6257
TEST_TIME 13 6186
TEST_TIME 14 6442
TEST_TIME 15 7205
TEST_TIME 16 7394
TEST_TIME 17 7375
TEST_TIME 18 7586
TEST_TIME 19 7840
TEST_TIME 20 8001
TEST_TIME 21 8055
TEST_TIME 22 8553
TEST_TIME 23 9086
TEST_TIME 24 9186
TEST_TIME 25 9373
TEST_TIME 26 9590
TEST_TIME 27 9976
TEST_TIME 28 10995
TEST_TIME 29 10686
TEST_TIME 30 10406
TEST_TIME 31 10289
TEST_TIME 32 10158
TEST_TIME 33 10084
TEST_TIME 34 9972
TEST_TIME 35 9817
TEST_TIME 36 9639
TEST_TIME 37 9705
TEST_TIME 38 9577
TEST_TIME 39 9501
TEST_TIME 40 9359
TEST_TIME 41 9239
TEST_TIME 42 9284
TEST_TIME 43 9228
TEST_TIME 44 9237
TEST_TIME 45 9140
TEST_TIME 46 9215
TEST_TIME 47 9085
TEST_TIME 48 9046
TEST_TIME 49 9024
TEST_TIME 50 9119
TEST_TIME 51 9075
TEST_TIME 52 9144
TEST_TIME 53 9135
TEST_TIME 54 9136
TEST_TIME 55 9197
TEST_TIME 56 9232
TEST_TIME 57 9256
TEST_TIME 58 9173
TEST_TIME 59 9337
TEST_TIME 60 9326
TEST_TIME 61 9335
TEST_TIME 62 9236
TEST_TIME 63 9110
TEST_TIME 64 9110
TEST_TIME 65 9087
TEST_TIME 66 8994
TEST_TIME 67 8989
TEST_TIME 68 8890
TEST_TIME 69 9017
TEST_TIME 70 8973
TEST_TIME 71 8931
TEST_TIME 72 8974
TEST_TIME 73 8987
TEST_TIME 74 9036
TEST_TIME 75 9016
TEST_TIME 76 8971
TEST_TIME 77 8984
TEST_TIME 78 8979
TEST_TIME 79 9058
TEST_TIME 80 9029
TEST_TIME 81 9060
TEST_TIME 82 9122
TEST_TIME 83 9181
TEST_TIME 84 9085
TEST_TIME 85 9033
TEST_TIME 86 8997
TEST_TIME 87 8973
TEST_TIME 88 8900
TEST_TIME 89 8857
TEST_TIME 90 8812
TEST_TIME 91 8892
TEST_TIME 92 8926
TEST_TIME 93 8909
TEST_TIME 94 8937
TEST_TIME 95 9028
TEST_TIME 96 9020
TEST_TIME 97 9002
TEST_TIME 98 9054
TEST_TIME 99 9046
TEST_TIME 100 9031
TEST_TIME 101 9141
TEST_TIME 102 9093
TEST_TIME 103 9152
TEST_TIME 104 9163
TEST_TIME 105 9159
TEST_TIME 106 9161
TEST_TIME 107 9093
TEST_TIME 108 9092
TEST_TIME 109 9055
TEST_TIME 110 9056
TEST_TIME 111 9025
TEST_TIME 112 8989
TEST_TIME 113 8948
TEST_TIME 114 8925
TEST_TIME 115 8897
TEST_TIME 116 8961
TEST_TIME 117 8928
TEST_TIME 118 8947
TEST_TIME 119 8907
TEST_TIME 120 8909

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-03-2021 01:28:54 to 31-03-2021 01:28:58.

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 1482969 1482969 0 0.00 0 33041 6 0 0
doc_list_biud 1482969 1482969 0 0.00 0 61499 28 0 0
sp_add_invoice_to_stock 4881 4813 68 1.39 15 214271 18771 0 68
sp_cancel_adding_invoice 5542 5542 0 0.00 5 73131 684 0 0
sp_cancel_client_order 1654 1654 0 0.00 4 12712 344 0 0
sp_cancel_customer_reserve 538676 538676 0 0.00 1 32138 62 0 0
sp_cancel_pay_from_customer 665 665 0 0.00 3 2926 66 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 3 6544 80 0 0
sp_cancel_supplier_invoice 6102 6097 5 0.08 2 15330 766 0 5
sp_cancel_supplier_order 420 420 0 0.00 6 1203372 101293 0 0
sp_cancel_write_off 10006 10006 0 0.00 1 20855 118 0 0
sp_client_order 19298 19298 0 0.00 4 18300 360 0 0
sp_customer_reserve 447214 447214 0 0.00 0 89490 185 0 0
sp_fill_shopping_cart 29768 29768 0 0.00 1 22338 45 0 0
sp_fill_shopping_cart_clo_res 447200 447200 0 0.00 0 41544 14 0 0
sp_get_clo_for_invoice 4799 4799 0 0.00 0 21282 325 0 0
sp_kill_cost_storno 16636 16636 0 0.00 0 20809 59 0 0
sp_kill_qstorno_ret_qs2qd 1093875 1093875 0 0.00 0 32114 33 0 0
sp_kill_qty_storno 576664 576664 0 0.00 0 61499 72 0 0
sp_lock_selected_doc 19815 19815 0 0.00 0 6197 4 0 0
sp_make_cost_storno 26629 26629 0 0.00 0 17951 54 0 0
sp_multiply_rows_for_pdistr 26629 26629 0 0.00 0 18300 33 0 0
sp_multiply_rows_for_qdistr 19298 19298 0 0.00 0 15371 165 0 0
sp_pay_from_customer 6697 6697 0 0.00 4 32728 116 0 0
sp_pay_to_supplier 5663 5663 0 0.00 5 30135 125 0 0
sp_payment_common 12360 12360 0 0.00 2 22247 31 0 0
sp_qd_handle_on_cancel_clo 1654 1654 0 0.00 0 12705 312 0 0
sp_qd_handle_on_invoice_upd_sts 10341 10341 0 0.00 0 61494 337 0 0
sp_qd_handle_on_reserve_upd_sts 9470 9470 0 0.00 0 8878 54 0 0
sp_reserve_write_off 9470 9470 0 0.00 6 25780 175 0 0
sp_supplier_invoice 5325 5325 0 0.00 7 90242 3657 0 0
sp_supplier_order 5147 5147 0 0.00 5 49596 1401 0 0
srv_aggregate_perf_data 94 94 0 0.00 2459 300368 22330 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1174 148767 33985 0 0
srv_find_qd_qs_mism 1023100 1023100 0 0.00 0 23454 5 0 0
srv_make_invnt_saldo 567 567 0 0.00 45 51655 977 0 0
srv_make_money_saldo 767 767 0 0.00 1 1931 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 246542 410750 299427 0 0
t$perf-abend:sp_add_invoice_to_stock 68 68 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4813 4813 0 0.00 0 27930 233 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 9987 132 0 0
t$perf-norm:sp_cancel_client_order 1654 1654 0 0.00 0 17577 24 0 0
t$perf-norm:sp_cancel_customer_reserve 631 631 0 0.00 0 580 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 665 665 0 0.00 0 2127 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 421 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 11851 53 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 20461 1614 0 0
t$perf-norm:sp_cancel_write_off 924 924 0 0.00 0 7226 18 0 0
t$perf-norm:sp_client_order 19298 19298 0 0.00 0 16815 26 0 0
t$perf-norm:sp_customer_reserve 937 937 0 0.00 0 958 4 0 0
t$perf-norm:sp_pay_from_customer 6697 6697 0 0.00 0 10935 16 0 0
t$perf-norm:sp_pay_to_supplier 5663 5663 0 0.00 0 14534 18 0 0
t$perf-norm:sp_reserve_write_off 9470 9470 0 0.00 0 22230 17 0 0
t$perf-norm:sp_supplier_invoice 5325 5325 0 0.00 0 9079 20 0 0
t$perf-norm:sp_supplier_order 5147 5147 0 0.00 0 11918 19 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 94 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 160 3 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 1122 17 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 8942 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 7 4 0 0
v_add_invoice_to_stock 9734 9598 136 1.39 0 4137 17 0 136
v_all_customers 35216 35216 0 0.00 0 24 1 0 0
v_all_suppliers 28968 28968 0 0.00 0 22 1 0 0
v_all_wares 38596 38596 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 1449 7 0 0
v_cancel_client_order 3308 3308 0 0.00 0 3981 5 0 0
v_cancel_customer_prepayment 1330 1330 0 0.00 0 1363 6 0 0
v_cancel_customer_reserve 1262 1262 0 0.00 0 1067 4 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 828 4 0 0
v_cancel_supplier_invoice 826 816 10 1.21 0 3877 27 0 10
v_cancel_supplier_order 840 840 0 0.00 0 2146 8 0 0
v_cancel_write_off 1848 1848 0 0.00 0 3018 18 0 0
v_max_id_clo_ord 5147 5147 0 0.00 0 471 1 0 0
v_max_id_clo_res 937 937 0 0.00 0 1464 14 0 0
v_max_id_ord_sup 5323 5323 0 0.00 0 22334 9 0 0
v_max_non_paid_invoice 1649 1649 0 0.00 0 4625 7 0 0
v_max_non_paid_realizn 3563 3563 0 0.00 0 4995 4 0 0
v_min_id_clo_ord 5147 5147 0 0.00 0 3541 7 0 0
v_min_id_clo_res 937 937 0 0.00 0 36121 47 0 0
v_min_id_ord_sup 5323 5323 0 0.00 0 3596 6 0 0
v_min_non_paid_invoice 5663 5663 0 0.00 0 19602 19 0 0
v_min_non_paid_realizn 6697 6697 0 0.00 0 20814 20 0 0
v_our_firm 9648 9648 0 0.00 0 21 1 0 0
v_reserve_write_off 18940 18940 0 0.00 0 4377 6 0 0
x_lock_depdocs_on_canc_invoice 11231 11231 0 0.00 0 16895 131 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 10555 356 0 0
x_make_qstorno_1000_1200 5147 5147 0 0.00 1 49582 1323 0 0
x_make_qstorno_1200_2000 5325 5325 0 0.00 3 90223 3488 0 0
x_make_qstorno_2100_3300 447214 447214 0 0.00 0 89489 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2021 01:28:59 to 31-03-2021 01:29:03.

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:31 13 8192000000 8804656944 8816857088 8751472 0.106 3 1 2 0 8872176 58144 62560
22:57:37 11680 8192000000 10183728400 10489225216 751870448 8.406 61 46 96 0 769571152 2097424 15603280
22:57:56 28338 8192000000 10342602816 10663628800 1374834768 14.370 100 80 160 1 1405004128 4382704 25786656
22:58:36 23901 8192000000 10397901904 10726035456 1454658048 15.079 100 90 180 0 1494019696 10630720 28730928
22:59:09 15348 8192000000 10407577488 10738311168 1467940912 15.196 100 82 164 0 1502109296 7519600 26648784
22:59:36 20553 8192000000 10437800640 10766614528 1487129136 15.364 100 90 180 1 1524709200 8339312 29240752
23:00:14 29994 8192000000 10445531744 10778984448 1501515376 15.489 100 94 187 2 1541276480 9059904 30701200
23:00:58 23082 8192000000 10468872896 10806120448 1514109056 15.599 100 83 165 2 1550427584 9500000 26818528
23:01:32 13579 8192000000 10481680544 10829565952 1542488608 15.845 100 79 159 2 1577605056 9656720 25459728
23:01:57 15385 8192000000 10528774512 10879287296 1577249248 16.145 100 75 150 0 1610942304 10306240 23386816
23:02:22 15907 8192000000 10561644736 10917060608 1608391088 16.411 100 79 158 1 1643310416 10334304 24585024
23:02:49 9634 8192000000 10565714704 10921598976 1628925824 16.586 100 86 172 1 1666569504 11419856 26223824
23:03:09 8144 8192000000 10580449088 10941890560 1641432160 16.692 100 83 166 1 1678472432 11953632 25086640
23:03:25 13190 8192000000 10604063216 10963755008 1656702320 16.821 100 82 163 2 1693566112 12427488 24436304
23:03:48 8813 8192000000 10619194320 10983059456 1673523536 16.963 100 81 163 0 1710721344 13365216 23832592
23:04:04 14613 8192000000 10640827728 11006484480 1689972688 17.101 100 79 158 0 1725985984 13421088 22592208
23:04:27 9565 8192000000 10652658896 11024338944 1706467696 17.239 100 74 148 1 1740990640 13352656 21170288
23:04:43 9521 8192000000 10657086288 11032268800 1718370384 17.339 100 79 158 0 1755352192 14025872 22955936
23:05:00 6954 8192000000 10682100784 11059781632 1737859840 17.501 100 83 165 1 1774116464 13031408 23225216
23:05:15 6791 8192000000 10694883168 11071270912 1754338784 17.638 100 80 160 0 1790351232 12670400 23342048
23:05:29 6027 8192000000 10689332336 11073503232 1763124720 17.710 100 77 154 2 1797525104 12773232 21627152
23:05:43 4714 8192000000 10710626384 11090477056 1769732784 17.765 100 81 161 2 1806258960 13603680 22922496
23:05:54 4026 8192000000 10714812160 11090063360 1772873808 17.791 100 86 172 2 1810556080 14338816 23343456
23:06:05 3669 8192000000 10721342656 11101167616 1784286992 17.885 100 85 169 0 1822270368 14365760 23617616
23:06:16 4737 8192000000 10729234688 11110207488 1789319392 17.926 100 89 178 1 1829245712 15070960 24855360
23:06:28 2322 8192000000 10737512080 11115802624 1793445920 17.960 100 85 170 0 1831982032 15007408 23528704
23:06:36 2817 8192000000 10744646320 11122737152 1803563600 18.043 100 91 181 0 1843394880 14781568 25049712
23:06:46 2515 8192000000 10757881520 11137282048 1812013504 18.112 100 90 181 1 1852181936 15108208 25060224
23:06:55 2523 8192000000 10766710800 11146702848 1819698640 18.175 100 92 183 1 1859226368 13822720 25705008
23:07:04 7957 8192000000 10758485264 11148677120 1823446416 18.206 100 74 146 0 1855579664 11979040 20154208
23:07:19 3987 8192000000 10774509232 11163017216 1832245200 18.278 100 82 160 2 1868006368 13367440 22393728
23:07:29 2136 8192000000 10793912000 11180146688 1850592672 18.427 100 94 189 1 1890267024 13158032 26516320
23:07:38 1798 8192000000 10797181504 11185545216 1854870336 18.462 100 85 167 0 1892619456 13491504 24257616
23:07:46 1792 8192000000 10803695856 11192184832 1863187328 18.529 100 96 193 2 1903039920 13357040 26495552
23:07:54 2037 8192000000 10812027536 11204067328 1867240080 18.562 100 85 169 0 1904006608 12704496 24062032
23:08:02 1807 8192000000 10821096608 11209732096 1876444560 18.636 100 93 187 0 1915450640 12878656 26127424
23:08:10 1493 8192000000 10817921168 11208056832 1875094112 18.625 100 94 188 0 1914606608 13391280 26121216
23:08:18 2238 8192000000 10819813520 11210985472 1873463792 18.612 100 94 185 1 1913633648 13810912 26358944
23:08:26 1421 8192000000 10829225824 11217240064 1878425984 18.652 100 96 192 0 1919571056 13527104 27617968
23:08:34 1317 8192000000 10827369344 11217002496 1879847328 18.664 100 95 190 1 1921227072 13618000 27761744
23:08:41 36363 8192000000 10802674160 11214151680 1878735696 18.655 100 60 120 1 1906618368 10150256 17732416
23:09:25 11259 8192000000 10802148928 11219058688 1877574688 18.646 100 39 78 1 1895928560 7898752 10455120
23:09:42 3550 8192000000 10804529184 11220008960 1881271808 18.675 100 39 78 0 1901382880 9692752 10418320
23:09:52 3304 8192000000 10806437440 11221942272 1884387840 18.701 100 51 102 2 1908176400 9657136 14131424
23:10:03 7277 8192000000 10790920560 11219308544 1882954288 18.689 100 26 52 0 1897594176 7373040 7266848
23:10:20 4169 8192000000 10789492960 11221729280 1884491840 18.701 100 26 52 4 1899383360 6841456 8050064
23:10:31 8927 8192000000 10798861696 11222761472 1886094048 18.714 100 25 49 3 1899287536 6062304 7131184
23:10:47 6850 8192000000 10800506672 11224358912 1886299600 18.716 100 25 49 0 1899688944 6597840 6791504
23:11:03 13852 8192000000 10793576112 11226628096 1887961232 18.729 100 22 44 1 1900972608 6251152 6760224
23:11:25 15327 8192000000 10795275520 11232288768 1887844016 18.728 100 15 28 4 1897004848 5271920 3888912
23:11:53 11571 8192000000 10804890464 11237326848 1897248368 18.804 100 24 46 3 1909673024 5531088 6893568
23:12:12 11634 8192000000 10804058768 11240706048 1896711760 18.800 100 16 32 2 1907188000 5924608 4551632
23:12:30 17180 8192000000 10803802544 11241865216 1897138048 18.803 100 18 36 4 1907881792 5650528 5093216
23:12:54 20492 8192000000 10847416192 11257397248 1901633696 18.839 100 14 29 0 1911006864 5276528 4096640
23:13:23 59064 8192000000 10815229696 11257606144 1906240560 18.876 100 30 60 2 1920936960 6480512 8215888
23:14:28 16611 8192000000 10824845632 11254468608 1890442768 18.749 99 29 58 1 1904521904 6246352 7832784
23:14:53 5356 8192000000 10830238080 11261353984 1908122944 18.892 100 30 58 2 1928283072 10973552 9186576
23:15:09 8043 8192000000 10825967264 11260436480 1912926592 18.930 100 36 73 0 1930255728 7115744 10213392
23:15:26 6529 8192000000 10826184624 11260571648 1913406544 18.934 100 36 69 3 1930026704 6726416 9893744
23:15:42 4611 8192000000 10832102160 11265261568 1913239936 18.933 100 22 42 3 1924417712 5845360 5332416
23:15:56 8576 8192000000 10816618448 11259576320 1914026432 18.939 100 17 32 2 1924458832 5452896 4979504
23:16:11 7802 8192000000 10815750800 11258814464 1908768736 18.897 100 19 38 0 1919522768 5742432 5011600
23:16:27 10589 8192000000 10812781776 11249852416 1886161792 18.715 99 22 44 0 1898135056 4891920 7081344
23:16:44 10742 8192000000 10826744496 11259031552 1904946624 18.866 100 14 28 1 1914270672 5185616 4138432
23:17:03 12074 8192000000 10822432848 11251482624 1885711248 18.711 99 21 42 0 1897170528 5656736 5802544
23:17:21 12132 8192000000 10777504512 11214807040 1821344816 18.189 96 10 20 0 1829252608 5179024 2728768
23:17:40 8827 8192000000 10787534848 11213565952 1853340864 18.449 99 24 48 3 1866604336 5855824 7407648
23:17:56 19133 8192000000 10786553664 11205812224 1834724144 18.298 98 10 20 2 1842292624 5100272 2468208
23:18:22 48781 8192000000 10787840384 11197980672 1838485728 18.328 98 49 99 4 1858650896 6136256 14028912
23:19:21 8764 8192000000 10746038576 11176538112 1808238272 18.081 98 19 38 1 1819740352 6314528 5187552
23:19:36 5512 8192000000 10734856144 11157356544 1782071936 17.867 97 25 50 2 1795225696 6415248 6738512
23:19:50 7810 8192000000 10715935600 11132829696 1720676320 17.358 94 27 54 1 1734008608 6007184 7325104
23:20:06 5876 8192000000 10687489792 11103023104 1742852672 17.542 97 29 58 0 1758842960 7436912 8553376
23:20:20 8322 8192000000 10692056528 11107074048 1724195184 17.387 96 34 68 3 1739738816 5795280 9748352
23:20:35 10663 8192000000 10691982560 11109429248 1740732576 17.525 97 26 52 0 1754061744 5285536 8043632
23:20:52 11754 8192000000 10657902048 11063205888 1635109360 16.638 92 22 44 1 1646947824 5555232 6283232
23:21:11 5711 8192000000 10697200992 11114594304 1763176816 17.711 99 24 48 0 1777212144 7129328 6906000
23:21:24 7665 8192000000 10697499664 11113680896 1770827120 17.774 99 26 52 2 1783927424 5148048 7952256
23:21:40 6180 8192000000 10717388176 11137273856 1803244208 18.041 100 30 60 0 1817794224 5188912 9361104
23:21:55 8124 8192000000 10747905120 11164622848 1823699312 18.208 100 38 76 0 1842198544 6206880 12292352
23:22:11 16975 8192000000 10732369216 11152125952 1756400928 17.655 96 16 32 1 1766016416 5065488 4550000
23:22:37 14587 8192000000 10729835968 11152699392 1775193792 17.810 97 21 42 0 1786784448 5309408 6281248
23:22:59 58073 8192000000 10792155472 11182329856 1829528048 18.255 100 53 107 3 1852213664 6122192 16563424
23:24:03 8564 8192000000 10743164336 11168980992 1828443328 18.247 100 23 46 1 1841577872 6093440 7041104
23:24:20 11178 8192000000 10759029760 11178983424 1839385568 18.336 100 30 60 3 1853935936 6495328 8055040
23:24:41 5123 8192000000 10765799904 11194159104 1850245936 18.424 100 29 59 0 1865478304 7200944 8031424
23:24:52 6236 8192000000 10770495744 11196256256 1854587024 18.459 100 25 50 2 1866967216 5663008 6717184
23:25:05 8846 8192000000 10762323392 11191705600 1840742528 18.347 99 27 52 0 1853535808 5359616 7433664
23:25:20 11308 8192000000 10781796976 11204968448 1860056048 18.504 100 25 50 2 1873512624 5880224 7576352
23:25:42 9605 8192000000 10782000288 11206909952 1864078416 18.536 100 26 52 2 1877039040 5489184 7471440
23:26:00 6856 8192000000 10779710784 11212554240 1867684096 18.566 100 25 50 1 1881173856 5714560 7775200
23:26:15 8186 8192000000 10782607280 11212161024 1869698560 18.582 100 27 52 3 1882510384 5011568 7800256
23:26:30 9656 8192000000 10786929744 11215486976 1871229376 18.594 100 18 36 3 1883002336 5982048 5790912
23:26:47 15095 8192000000 10782049968 11220250624 1875265248 18.627 100 22 43 1 1887080880 5009600 6806032
23:27:10 10258 8192000000 10812362704 11239079936 1894878048 18.785 100 29 57 2 1908804352 6215968 7710336
23:27:29 17808 8192000000 10827614560 11244929024 1899714864 18.824 100 31 63 1 1913800112 4962224 9123024
23:27:55 148767 8192000000 10861825616 11291783168 1925069024 19.027 100 45 89 1 1947253584 9453760 12730800
23:30:35 19701 8192000000 10886412544 11308011520 1941286432 19.157 100 49 98 0 1968356000 13058912 14010656
23:31:02 14455 8192000000 10882502528 11310612480 1947836048 19.209 100 49 97 0 1976324640 14686656 13801936
23:31:30 16515 8192000000 10890640800 11319300096 1955653536 19.271 100 52 104 0 1985820048 15671520 14494992
23:32:00 14243 8192000000 10901384128 11328782336 1958993312 19.298 100 57 111 2 1990272576 15024256 16255008
23:32:25 14751 8192000000 10896953504 11330723840 1967849216 19.368 100 49 98 0 1998383008 16632528 13901264
23:32:49 6293 8192000000 10906766544 11335139328 1968743552 19.375 100 52 103 1 2000914736 16319296 15851888
23:33:03 8755 8192000000 10921489456 11341877248 1973210848 19.411 100 60 120 0 2008748144 17726512 17810784
23:33:19 2813 8192000000 10927821040 11343863808 1974741232 19.423 100 60 119 1 2010667712 18447680 17478800
23:33:29 4805 8192000000 10915567824 11329519616 1963962384 19.338 99 85 170 0 2007900288 19175184 24762720
23:33:44 1170 8192000000 10929978992 11348594688 1974712256 19.423 100 68 135 1 2013523376 19090800 19720320
23:33:56 7475 8192000000 10932304848 11354251264 1978430896 19.452 100 66 131 0 2017536240 20442640 18662704
23:34:13 6019 8192000000 10926346976 11354931200 1982801936 19.487 100 64 126 0 2022064288 20510992 18751360
23:34:26 19754 8192000000 10933042752 11361591296 1982741712 19.486 100 51 102 0 2016048352 18582416 14724224
23:34:57 2847 8192000000 10953879312 11369889792 1992604400 19.564 100 66 132 1 2033022464 20406384 20011680
23:35:12 7680 8192000000 10940201584 11372761088 1996963360 19.599 100 52 104 1 2031766768 19509936 15293472
23:35:27 2440 8192000000 10947052176 11374751744 1997240048 19.601 100 61 123 1 2034958752 19768656 17950048
23:35:37 2558 8192000000 10941797040 11373817856 2001451344 19.634 100 76 152 0 2044803584 20085664 23266576
23:35:51 9293 8192000000 10957359888 11372617728 2000538352 19.627 100 63 125 1 2039654160 20918160 18197648
23:36:11 5616 8192000000 10963155904 11390795776 2005176496 19.664 100 65 128 0 2049142464 24524096 19441872
23:36:25 3136 8192000000 10973518848 11396526080 2012034656 19.718 100 79 156 1 2061438432 25967248 23436528
23:36:35 21504 8192000000 10971642160 11399725056 2011096784 19.710 100 69 137 1 2056469504 24365344 21007376
23:37:05 14628 8192000000 10968731056 11401924608 2013576416 19.730 100 48 94 1 2050919632 22890208 14453008
23:37:34 7089 8192000000 10979789344 11410726912 2019837744 19.779 100 65 130 1 2064941808 25004288 20099776
23:37:58 13600 8192000000 10955226064 11393425408 1997997824 19.607 99 61 120 1 2041375120 25116432 18260864
23:38:20 6891 8192000000 10972566096 11407626240 2016635008 19.754 100 62 122 0 2061938400 27199200 18104192
23:38:34 1571 8192000000 10965440560 11393773568 2006049648 19.670 100 64 129 2 2051053408 25053696 19950064
23:38:43 3429 8192000000 10957155760 11375587328 1989283536 19.538 99 66 133 1 2036318448 26092832 20942080
23:38:55 8771 8192000000 10951313824 11381473280 1993721392 19.573 100 66 133 1 2041575696 28186720 19667584
23:39:18 9782 8192000000 10957538832 11399098368 2005566752 19.667 100 52 103 0 2052225792 30736016 15923024
23:39:38 6069 8192000000 10978061760 11409956864 1997205456 19.601 99 61 121 1 2047172064 31348096 18618512
23:39:51 10120 8192000000 10958712256 11393392640 1973926448 19.417 98 56 111 0 2023695056 32748464 17020144
23:40:08 5518 8192000000 10969902128 11403198464 1988591760 19.533 99 64 127 1 2043411456 35346208 19473488
23:40:23 8839 8192000000 10971047936 11400929280 1999894544 19.622 100 62 124 0 2055326576 36944944 18487088
23:40:40 7488 8192000000 10981405744 11405504512 1995014432 19.583 99 67 134 2 2054466912 38884336 20568144
23:40:55 4346 8192000000 10984822240 11413024768 2010846352 19.708 100 71 142 1 2074269184 41777040 21645792
23:41:08 4428 8192000000 10995690128 11413241856 2006527936 19.674 100 70 139 0 2066975440 39376672 21070832
23:41:21 2597 8192000000 10987999152 11416834048 2011838992 19.716 100 71 142 3 2071975408 37749904 22386512
23:41:31 2782 8192000000 10983412480 11412414464 1994522944 19.580 99 76 152 2 2057624224 39771936 23329344
23:41:41 4013 8192000000 10970203280 11393839104 1987658368 19.525 99 72 143 2 2051511536 41715792 22137376
23:41:52 2270 8192000000 11004624832 11421020160 2009088224 19.694 100 89 171 1 2078963184 43434544 26440416
23:42:03 3211 8192000000 10999669952 11419025408 2012632336 19.722 100 88 176 0 2079976432 40388432 26955664
23:42:15 2523 8192000000 10999358176 11422343168 2013836192 19.732 100 79 158 0 2077824768 39714176 24274400
23:42:25 7591 8192000000 10979522944 11403743232 1985834608 19.511 99 78 154 0 2052062416 42661616 23566192
23:42:42 2406 8192000000 10997345632 11420143616 2009330112 19.696 100 80 158 0 2077979744 43868432 24781200
23:42:52 1694 8192000000 10971276224 11387195392 1980929184 19.472 100 87 174 0 2046649568 39734960 25985424
23:43:01 1583 8192000000 10944974720 11355803648 1963246752 19.332 99 86 170 0 2027834608 39167920 25419936
23:43:09 4531 8192000000 10952676512 11365421056 1939651040 19.144 98 90 181 0 2005587360 37975008 27961312
23:43:21 6208 8192000000 10944874272 11360571392 1948856896 19.217 99 76 152 0 2011208224 38959248 23392080
23:43:34 6773 8192000000 10936235776 11352608768 1948130048 19.212 99 70 140 0 2009578064 39976816 21471200
23:43:49 5315 8192000000 10951119184 11373006848 1967403968 19.365 100 66 132 0 2030247968 42785760 20058240
23:44:04 3918 8192000000 10953510272 11376021504 1972786320 19.408 100 73 145 4 2036216304 40845232 22584752
23:44:20 6567 8192000000 10957756432 11381915648 1977453536 19.445 100 75 150 1 2042310784 41324848 23532400
23:44:38 4774 8192000000 10952935648 11374067712 1970020464 19.386 100 73 146 0 2036561360 43597040 22943856
23:44:50 2666 8192000000 10970018448 11390803968 1978668192 19.454 100 81 158 0 2050350048 46446784 25235072
23:45:01 1930 8192000000 10976841664 11393769472 1981289296 19.475 100 87 175 2 2058252592 49207552 27755744
23:45:11 4699 8192000000 10977640304 11396534272 1983973568 19.496 100 83 166 1 2061794368 51162528 26658272
23:45:22 4063 8192000000 10981098016 11399110656 1983705280 19.494 100 86 170 1 2062691424 51605424 27380720
23:45:35 4065 8192000000 10999105392 11414454272 1993787232 19.574 100 84 168 1 2073290272 53311856 26191184
23:45:49 2309 8192000000 10988402992 11399004160 1986175840 19.514 100 89 178 1 2065521296 51808304 27537152
23:45:58 1912 8192000000 10991401280 11408523264 1991946160 19.559 100 84 168 0 2068440688 50542640 25951888
23:46:07 3914 8192000000 10984801184 11400273920 1973996624 19.417 99 87 175 1 2054250352 53365024 26888704
23:46:17 2048 8192000000 10974275504 11385528320 1954012128 19.258 99 94 184 3 2037527616 54208688 29306800
23:46:26 1374 8192000000 10963144288 11373674496 1953722160 19.256 99 92 182 0 2031671184 49595408 28353616
23:46:34 4048 8192000000 10982105520 11392020480 1978212000 19.451 100 83 166 1 2054871424 51020048 25639376
23:46:45 7074 8192000000 10969388128 11399630848 1981308368 19.475 100 60 120 0 2050619168 49753664 19557136
23:46:58 5001 8192000000 10969459472 11396255744 1982439440 19.484 100 57 113 2 2050254256 49417456 18397360
23:47:13 3405 8192000000 10975623600 11408646144 1990459216 19.547 100 57 114 2 2062022720 52811168 18752336
23:47:25 12795 8192000000 10949708928 11382964224 1934988960 19.107 97 54 108 0 2007688848 54733568 17966320
23:47:46 4423 8192000000 10959349744 11387682816 1970384560 19.388 100 58 116 1 2041327632 52199360 18743712
23:47:58 9458 8192000000 10939032544 11375431680 1950396592 19.230 99 38 76 0 2014367552 50801632 13169328
23:48:19 3182 8192000000 10972282960 11387535360 1969105584 19.378 100 63 120 2 2044892912 56106752 19680576
23:48:37 7120 8192000000 10963293952 11388047360 1960705600 19.312 100 54 108 0 2037494928 58309600 18479728
23:48:51 11472 8192000000 10957791088 11398631424 1969975744 19.385 100 48 96 2 2048240768 61784240 16480784
23:49:14 7822 8192000000 10948450976 11386101760 1945709824 19.192 99 41 82 1 2023660256 63770448 14179984
23:49:31 12008 8192000000 10950219248 11391369216 1963302096 19.332 100 49 98 0 2037089584 57457376 16330112
23:50:04 13799 8192000000 10954741584 11396874240 1971406976 19.397 100 39 78 1 2041484656 55614128 14463552
23:50:44 30767 8192000000 10911283520 11371376640 1924687104 19.024 98 29 58 1 1989506368 54738240 10081024
23:51:33 33023 8192000000 10896022816 11340783616 1902427824 18.846 98 23 46 1 1957614560 47092000 8094736
23:52:12 21522 8192000000 10908743824 11366830080 1936529024 19.119 100 20 40 2 1996073024 52218224 7325776
23:52:41 20616 8192000000 10915670016 11372920832 1943973248 19.178 100 24 48 2 2003910704 51411904 8525552
23:53:41 19311 8192000000 10911876560 11383324672 1934437616 19.102 100 13 26 0 1993996928 54403296 5156016
23:54:08 11336 8192000000 10919256048 11391393792 1941287184 19.157 100 13 26 0 2001064160 54808864 4968112
23:54:25 1288 8192000000 10896184416 11365380096 1914179312 18.940 99 11 22 0 1977489344 58841008 4469024
23:54:56 26080 8192000000 10867279136 11329028096 1881965296 18.681 98 16 32 0 1920063008 33095872 5001840
23:55:35 78904 8192000000 10865475232 11312783360 1920451072 18.990 100 15 31 0 1935753200 10603152 4698976
23:57:23 25585 8192000000 10873995312 11314024448 1917050832 18.963 99 40 80 0 1938652464 9256352 12345280
23:57:55 68916 8192000000 10876410400 11323588608 1909714912 18.904 98 31 61 0 1933015264 14922368 8377984
23:59:10 75485 8192000000 10861842208 11329839104 1883001424 18.689 97 11 22 1 1900115552 14219696 2894432
00:00:32 128353 8192000000 10879822224 11349602304 1931533344 19.079 99 8 16 1 1944920320 11448352 1938624
00:02:47 36705 8192000000 10880269088 11344871424 1940675424 19.152 99 20 40 1 1957976096 11107760 6192912
00:03:30 58964 8192000000 10891754112 11362631680 1959040416 19.298 100 14 28 0 1976173712 12824240 4309056
00:04:50 26107 8192000000 10885478368 11320270848 1901125088 18.835 97 28 56 1 1916248208 7376144 7746976
00:05:30 106435 8192000000 10858566528 11331616768 1935161136 19.108 99 19 38 0 1950395600 9339952 5894512
00:07:22 71974 8192000000 10873514400 11339952128 1931181696 19.076 99 13 25 0 1943838272 8917808 3738768
00:08:41 57337 8192000000 10897047360 11354058752 1943240544 19.173 99 28 54 2 1960734720 9782112 7712064
00:09:44 90610 8192000000 10897431856 11359027200 1959628944 19.303 100 27 54 3 1981764096 14337424 7797728
00:11:27 50784 8192000000 10878731024 11350601728 1944033408 19.179 99 17 34 1 1960894704 11820720 5040576
00:12:26 61950 8192000000 10876688736 11356700672 1947731776 19.208 99 15 30 0 1964228288 12219136 4277376
00:15:12 46919 8192000000 10889821888 11366969344 1952894656 19.250 99 19 38 0 1965620176 7678624 5046896
00:16:05 87381 8192000000 10906076560 11384348672 1957262208 19.284 99 13 26 1 1970365536 9329200 3774128
00:17:39 45169 8192000000 10915430752 11380965376 1985059232 19.505 100 35 70 0 2004769648 9043552 10666864
00:18:34 66174 8192000000 10917783392 11393155072 1977083488 19.442 99 29 58 0 1998242960 13188512 7970960
00:20:00 40394 8192000000 10939408208 11392692224 1970636016 19.390 99 19 38 0 1986417712 10497472 5284224
00:20:50 58732 8192000000 10925771216 11398844416 1977930288 19.448 99 14 28 0 1997984112 15949376 4104448
00:22:08 53977 8192000000 10919428784 11392593920 1926002816 19.035 97 14 28 0 1955004304 24660112 4341376
00:23:09 61977 8192000000 10901340176 11373264896 1917976880 18.971 97 12 24 1 1935889648 14728256 3184512
00:24:17 48225 8192000000 10923563040 11379867648 1962403088 19.325 99 19 38 1 1978859136 11365392 5090656
00:25:13 15099 8192000000 10945826320 11387805696 1991972848 19.559 100 52 104 1 2019159728 12159664 15027216
00:25:35 14317 8192000000 10957625664 11395760128 1997572416 19.604 100 69 137 1 2034259552 17676592 19010544
00:25:56 35812 8192000000 10941741392 11404677120 1995483040 19.587 100 55 110 1 2032427232 21136208 15807984
00:27:08 97098 8192000000 10884548304 11344031744 1840348048 18.344 93 14 28 1 1855767792 11865616 3554128
00:28:51 62968 8192000000 10882131472 11358605312 1957814048 19.289 100 9 18 0 1974663376 14321056 2528272
00:30:22 78143 8192000000 10896805840 11371085824 1959421376 19.301 99 25 50 0 1980853808 14270864 7161568
00:31:46 43231 8192000000 10868562352 11339071488 1933167072 19.092 98 9 17 2 1947109312 11152096 2790144
00:32:36 39243 8192000000 10876296448 11351293952 1961906864 19.321 100 11 22 0 1972320496 7152064 3261568
00:33:21 54908 8192000000 10876897152 11350794240 1931456000 19.079 98 13 26 0 1945309888 9866992 3986896
00:34:22 41156 8192000000 10892555040 11367743488 1964044352 19.338 100 10 20 0 1981590480 14836064 2710064
00:35:09 41114 8192000000 10880920848 11352109056 1950027584 19.227 99 10 20 0 1964287392 11173696 3086112
00:36:09 38727 8192000000 10861876624 11357229056 1943657056 19.176 99 23 47 1 1966040592 14926112 7457424
00:36:57 62325 8192000000 10882780800 11347017728 1901450144 18.838 97 8 16 0 1910863696 7158560 2254992
00:38:05 52811 8192000000 10875770096 11329503232 1881691088 18.679 96 23 46 0 1895944944 7822416 6431440
00:39:04 67549 8192000000 10879218912 11345088512 1874776096 18.623 96 8 16 0 1889787904 12815280 2196528
00:40:22 67420 8192000000 10874649936 11359424512 1907964992 18.890 98 22 44 0 1926250592 12243024 6042576
00:41:48 82794 8192000000 10851665216 11313287168 1802352064 18.033 92 14 28 0 1814533472 8165136 4016272
00:43:18 43288 8192000000 10863035568 11316121600 1869589136 18.581 96 38 76 2 1889795824 9713840 10492848
00:44:07 28615 8192000000 10858809344 11316281344 1891028640 18.754 98 34 68 1 1914590112 14081680 9479792
00:44:45 70728 8192000000 10877784272 11340750848 1914272112 18.941 99 24 48 1 1931604960 10809024 6523824
00:46:22 76876 8192000000 10857349840 11319558144 1847601072 18.403 95 17 34 1 1864193808 11810768 4781968
00:47:52 89258 8192000000 10853337024 11314855936 1854245600 18.457 96 15 31 0 1872620864 14276576 4098688
00:49:33 47729 8192000000 10853132496 11310600192 1883899296 18.697 98 18 36 1 1902375152 12810736 5665120
00:50:30 71090 8192000000 10844770080 11316277248 1917717248 18.969 100 16 32 0 1936726928 14548832 4460848
00:52:18 86073 8192000000 10866481744 11337293824 1920806640 18.993 99 17 34 1 1934749232 9269696 4672896
00:54:42 99431 8192000000 10856569824 11335708672 1903592640 18.855 98 15 30 0 1918167392 10017520 4557232
00:56:27 68612 8192000000 10877261520 11346001920 1913016176 18.931 98 17 34 0 1930079392 11587856 5475360
00:57:42 68456 8192000000 10878586624 11372748800 1957182768 19.284 100 18 36 0 1979404400 16872208 5349424
00:58:57 86854 8192000000 10888629040 11355561984 1903017392 18.851 97 8 16 0 1918081024 13436304 1627328
01:00:30 123423 8192000000 10888252992 11370811392 1908181264 18.892 97 12 24 0 1933776416 21908432 3686720
01:02:39 97157 8192000000 10917610368 11365621760 1910693808 18.912 97 13 26 1 1924081632 9750496 3637328
01:04:23 62403 8192000000 10902682304 11376988160 1919862640 18.986 97 40 80 2 1942845840 11518256 11464944
01:05:33 57233 8192000000 10908692208 11373969408 1962160512 19.323 99 29 59 1 1980590304 10314464 8115328
01:06:40 48270 8192000000 10915396144 11388088320 1978301616 19.451 100 24 48 0 2002189952 17002896 6885440
01:07:40 66777 8192000000 10918760608 11403780096 1980250272 19.467 100 26 52 2 2003767296 16431056 7085968
01:08:53 47348 8192000000 10922834064 11380957184 1946019536 19.195 98 32 64 1 1965071056 10311776 8739744
01:09:47 89245 8192000000 10898696656 11376578560 1917432912 18.966 97 20 40 2 1937628240 14534512 5660816
01:11:26 110019 8192000000 10898623344 11366842368 1869176032 18.578 95 14 26 2 1882619440 9703104 3740304
01:13:29 119960 8192000000 10924339936 11387412480 1972899136 19.408 100 19 38 1 1994190064 16086208 5204720
01:15:53 52482 8192000000 10897987568 11371069440 1916225040 18.957 97 31 62 2 1941051312 16862672 7963600
01:16:58 52376 8192000000 10895066256 11365384192 1951537776 19.239 99 36 72 1 1970090880 8949136 9603968
01:19:00 30274 8192000000 10881997184 11366899712 1950564720 19.231 99 9 18 1 1960799296 7609760 2624816
01:19:56 85275 8192000000 10908465744 11387531264 1977728000 19.447 100 16 32 1 1991961728 9713904 4519824
01:21:29 97954 8192000000 10905356576 11392487424 1959558880 19.303 99 13 26 1 1980772736 17279120 3934736
01:23:25 53362 8192000000 10905222240 11369267200 1922336896 19.006 97 19 38 1 1939594736 11451424 5806416
01:24:26 33747 8192000000 10900973296 11377098752 1959622288 19.303 99 20 40 0 1973542640 8447856 5472496
01:25:10 53826 8192000000 10868544208 11345735680 1832569264 18.280 93 18 36 2 1849961024 11671472 5720288
01:26:10 36483 8192000000 10868912352 11334361088 1875675232 18.630 96 25 50 0 1894966864 11598608 7693024
01:27:02 38648 8192000000 9263027600 9529323520 420232224 4.879 22 7 14 0 434179296 11823056 2124016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 31-03-2021 01:29:05 to 31-03-2021 01:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 68 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-03-2021 01:29:36 to 31-03-2021 01:29:38.

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          231868
MON$OLDEST_ACTIVE               231869
MON$OLDEST_SNAPSHOT             231869
MON$NEXT_TRANSACTION            231869
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                       2012032
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 ---
:217: 
:218: mscs-test-161.budzdorov.ru    Wed Mar 31 01:27:57 2021
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
--- end of diff output ---

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

31.03.21 01:29:39. 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-31 01:29:42 No severe PSQL-related problems occured
31.03.21 01:29:43. End of report.