Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.01.2021 16: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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17391548 kB
MemAvailable 31316460 kB
Buffers 0 kB
Cached 14277500 kB
SwapCached 4864 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-01-16 16:27:14
DTS_END                         2021-01-16 16:27:14.9110
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52034
TRN_ID                          232829
ATT_ID                          673
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: 8954.98 27674 1074597
customer order: creation 156.90 381 18828
customer order: refuse 13.87 375 1664
order to supplier: creation 44.09 1290 5291
order to supplier: removal 3.31 103756 397
invoice (draft): creation 42.98 3543 5158
invoice (draft): removal 54.13 716 6495
invoice accept: apply 40.03 18457 4803
invoice accept: cancel 47.64 751 5717
customer reserve: creation 3643.43 186 437212
customer reserve: removal 4626.23 58 555148
realization accept: apply 78.02 178 9362
realization accept: cancel 83.70 109 10044
payment from customer: creation 55.35 103 6642
payment from customer: removal 4.93 70 592
payment to supplier: creation 45.80 140 5496
payment to supplier: removal 3.21 87 385
service: total inventory turnovers 4.28 1071 514
service: total monetary turnovers 6.22 20 746
service: aggregate perf. data 0.83 17176 99
service: refresh index statistics 0.03 405004 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4650
TEST_TIME 2 4913
TEST_TIME 3 4665
TEST_TIME 4 4197
TEST_TIME 5 4456
TEST_TIME 6 4763
TEST_TIME 7 4865
TEST_TIME 8 4992
TEST_TIME 9 5246
TEST_TIME 10 5166
TEST_TIME 11 5277
TEST_TIME 12 5356
TEST_TIME 13 5683
TEST_TIME 14 6304
TEST_TIME 15 6429
TEST_TIME 16 7425
TEST_TIME 17 7411
TEST_TIME 18 8216
TEST_TIME 19 8511
TEST_TIME 20 8516
TEST_TIME 21 8824
TEST_TIME 22 9149
TEST_TIME 23 9202
TEST_TIME 24 9696
TEST_TIME 25 10269
TEST_TIME 26 10574
TEST_TIME 27 10778
TEST_TIME 28 10500
TEST_TIME 29 10328
TEST_TIME 30 10272
TEST_TIME 31 10266
TEST_TIME 32 10165
TEST_TIME 33 9963
TEST_TIME 34 10258
TEST_TIME 35 10178
TEST_TIME 36 9972
TEST_TIME 37 10010
TEST_TIME 38 9886
TEST_TIME 39 9724
TEST_TIME 40 9665
TEST_TIME 41 9661
TEST_TIME 42 9602
TEST_TIME 43 9665
TEST_TIME 44 9665
TEST_TIME 45 9559
TEST_TIME 46 9541
TEST_TIME 47 9547
TEST_TIME 48 9534
TEST_TIME 49 9557
TEST_TIME 50 9484
TEST_TIME 51 9419
TEST_TIME 52 9493
TEST_TIME 53 9545
TEST_TIME 54 9574
TEST_TIME 55 9509
TEST_TIME 56 9463
TEST_TIME 57 9524
TEST_TIME 58 9541
TEST_TIME 59 9415
TEST_TIME 60 9364
TEST_TIME 61 9358
TEST_TIME 62 9345
TEST_TIME 63 9300
TEST_TIME 64 9313
TEST_TIME 65 9218
TEST_TIME 66 9194
TEST_TIME 67 9130
TEST_TIME 68 9081
TEST_TIME 69 9030
TEST_TIME 70 8961
TEST_TIME 71 8976
TEST_TIME 72 8908
TEST_TIME 73 8847
TEST_TIME 74 9053
TEST_TIME 75 9048
TEST_TIME 76 9018
TEST_TIME 77 9037
TEST_TIME 78 9051
TEST_TIME 79 9089
TEST_TIME 80 9056
TEST_TIME 81 9082
TEST_TIME 82 9144
TEST_TIME 83 9126
TEST_TIME 84 9148
TEST_TIME 85 9090
TEST_TIME 86 9010
TEST_TIME 87 9066
TEST_TIME 88 9021
TEST_TIME 89 9046
TEST_TIME 90 8974
TEST_TIME 91 8967
TEST_TIME 92 8912
TEST_TIME 93 8893
TEST_TIME 94 8880
TEST_TIME 95 8879
TEST_TIME 96 8929
TEST_TIME 97 8939
TEST_TIME 98 8944
TEST_TIME 99 9044
TEST_TIME 100 9017
TEST_TIME 101 9046
TEST_TIME 102 9097
TEST_TIME 103 9105
TEST_TIME 104 9109
TEST_TIME 105 9103
TEST_TIME 106 9116
TEST_TIME 107 9134
TEST_TIME 108 9181
TEST_TIME 109 9110
TEST_TIME 110 9105
TEST_TIME 111 9052
TEST_TIME 112 9051
TEST_TIME 113 9033
TEST_TIME 114 9028
TEST_TIME 115 8996
TEST_TIME 116 8979
TEST_TIME 117 8931
TEST_TIME 118 8917
TEST_TIME 119 8978
TEST_TIME 120 8958

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-01-2021 16:28:34 to 16-01-2021 16:28:37.

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 1479507 1479507 0 0.00 0 18649 6 0 0
doc_list_biud 1479500 1479500 0 0.00 0 42710 28 0 0
sp_add_invoice_to_stock 4939 4803 136 2.75 45 165452 18457 0 136
sp_cancel_adding_invoice 5717 5717 0 0.00 4 63324 751 0 0
sp_cancel_client_order 1664 1664 0 0.00 4 15351 376 0 0
sp_cancel_customer_reserve 555148 555148 0 0.00 1 42712 59 0 0
sp_cancel_pay_from_customer 592 592 0 0.00 2 4503 70 0 0
sp_cancel_pay_to_supplier 385 385 0 0.00 3 2529 88 0 0
sp_cancel_supplier_invoice 6510 6495 15 0.23 1 12980 717 0 15
sp_cancel_supplier_order 397 397 0 0.00 8 992724 103757 0 0
sp_cancel_write_off 10044 10044 0 0.00 1 15155 110 0 0
sp_client_order 18828 18828 0 0.00 4 67645 381 0 0
sp_customer_reserve 437212 437212 0 0.00 0 151279 186 0 0
sp_fill_shopping_cart 29255 29255 0 0.00 1 16553 42 0 0
sp_fill_shopping_cart_clo_res 437193 437193 0 0.00 0 20096 14 0 0
sp_get_clo_for_invoice 4784 4784 0 0.00 0 36133 372 0 0
sp_kill_cost_storno 16738 16738 0 0.00 0 15153 56 0 0
sp_kill_qstorno_ret_qs2qd 1127232 1127232 0 0.00 0 42706 32 0 0
sp_kill_qty_storno 593611 593611 0 0.00 0 42710 69 0 0
sp_lock_selected_doc 19576 19576 0 0.00 0 7492 5 0 0
sp_make_cost_storno 26284 26284 0 0.00 0 17289 49 0 0
sp_multiply_rows_for_pdistr 26284 26284 0 0.00 0 9261 27 0 0
sp_multiply_rows_for_qdistr 18828 18828 0 0.00 0 67634 181 0 0
sp_pay_from_customer 6642 6642 0 0.00 4 13187 104 0 0
sp_pay_to_supplier 5496 5496 0 0.00 5 14166 141 0 0
sp_payment_common 12138 12138 0 0.00 1 14132 27 0 0
sp_qd_handle_on_cancel_clo 1664 1664 0 0.00 0 15343 342 0 0
sp_qd_handle_on_invoice_upd_sts 10501 10501 0 0.00 0 22704 327 0 0
sp_qd_handle_on_reserve_upd_sts 9362 9362 0 0.00 0 17421 62 0 0
sp_reserve_write_off 9362 9362 0 0.00 6 17443 178 0 0
sp_supplier_invoice 5158 5158 0 0.00 6 104942 3544 0 0
sp_supplier_order 5291 5291 0 0.00 4 41630 1290 0 0
srv_aggregate_perf_data 99 99 0 0.00 2456 127838 17177 0 0
srv_fill_mon_cache_memory 142 142 0 0.00 1924 206713 36414 0 0
srv_find_qd_qs_mism 1030017 1030017 0 0.00 0 18648 5 0 0
srv_make_invnt_saldo 514 514 0 0.00 31 40704 1071 0 0
srv_make_money_saldo 746 746 0 0.00 0 541 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 250750 632834 405004 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4803 4803 0 0.00 0 12626 167 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 1 13510 107 0 0
t$perf-norm:sp_cancel_client_order 1664 1664 0 0.00 0 1880 11 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 5235 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 592 592 0 0.00 0 5027 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 385 385 0 0.00 0 125 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 7427 41 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 20930 1622 0 0
t$perf-norm:sp_cancel_write_off 958 958 0 0.00 0 13500 19 0 0
t$perf-norm:sp_client_order 18828 18828 0 0.00 0 13454 21 0 0
t$perf-norm:sp_customer_reserve 866 866 0 0.00 0 1377 7 0 0
t$perf-norm:sp_pay_from_customer 6642 6642 0 0.00 0 4028 7 0 0
t$perf-norm:sp_pay_to_supplier 5496 5496 0 0.00 0 14703 18 0 0
t$perf-norm:sp_reserve_write_off 9362 9362 0 0.00 0 8888 10 0 0
t$perf-norm:sp_supplier_invoice 5158 5158 0 0.00 0 14710 25 0 0
t$perf-norm:sp_supplier_order 5291 5291 0 0.00 0 7074 17 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 234 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 142 142 0 0.00 0 1037 10 0 0
t$perf-norm:srv_make_invnt_saldo 514 514 0 0.00 0 4948 21 0 0
t$perf-norm:srv_make_money_saldo 746 746 0 0.00 0 666 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9840 9568 272 2.76 0 3568 17 0 272
v_all_customers 34610 34610 0 0.00 0 15 1 0 0
v_all_suppliers 28846 28846 0 0.00 0 14 1 0 0
v_all_wares 37656 37656 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 1560 8 0 0
v_cancel_client_order 3328 3328 0 0.00 0 3579 8 0 0
v_cancel_customer_prepayment 1184 1184 0 0.00 0 1988 9 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 4356 10 0 0
v_cancel_payment_to_supplier 770 770 0 0.00 0 1540 12 0 0
v_cancel_supplier_invoice 808 778 30 3.71 0 11542 29 0 30
v_cancel_supplier_order 794 794 0 0.00 0 2021 6 0 0
v_cancel_write_off 1916 1916 0 0.00 0 4474 13 0 0
v_max_id_clo_ord 5280 5280 0 0.00 0 616 1 0 0
v_max_id_clo_res 866 866 0 0.00 0 2350 15 0 0
v_max_id_ord_sup 5147 5147 0 0.00 0 3354 4 0 0
v_max_non_paid_invoice 1499 1499 0 0.00 0 287 2 0 0
v_max_non_paid_realizn 3440 3440 0 0.00 0 4756 6 0 0
v_min_id_clo_ord 5280 5280 0 0.00 0 4995 6 0 0
v_min_id_clo_res 866 866 0 0.00 0 2445 5 0 0
v_min_id_ord_sup 5146 5146 0 0.00 0 5190 13 0 0
v_min_non_paid_invoice 5496 5496 0 0.00 0 14122 15 0 0
v_min_non_paid_realizn 6642 6642 0 0.00 0 9824 14 0 0
v_our_firm 9450 9450 0 0.00 0 11 1 0 0
v_reserve_write_off 18724 18724 0 0.00 0 11544 8 0 0
x_lock_depdocs_on_canc_invoice 11823 11823 0 0.00 0 23397 132 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 29540 511 0 0
x_make_qstorno_1000_1200 5291 5291 0 0.00 2 41607 1214 0 0
x_make_qstorno_1200_2000 5158 5158 0 0.00 2 104699 3389 0 0
x_make_qstorno_2100_3300 437212 437212 0 0.00 0 151277 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-01-2021 16:28:38 to 16-01-2021 16:28:42.

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:18 6 8192000000 8804624128 8816852992 9436176 0.115 3 1 2 0 9556912 58176 62560
13:57:25 17835 8192000000 10235072048 10543067136 898675360 9.885 70 54 107 0 918481520 2205168 17600992
13:57:51 10122 8192000000 10296394800 10611531776 1347973536 14.129 100 78 156 0 1378575600 4485776 26116288
13:58:11 21493 8192000000 10346059712 10667151360 1396452928 14.563 100 79 158 0 1428713792 5462128 26798736
13:58:44 29860 8192000000 10390244816 10716315648 1438633600 14.938 100 87 174 1 1473412864 6372608 28406656
13:59:27 24346 8192000000 10411257424 10743484416 1470600832 15.219 100 90 180 2 1507173472 7257664 29314976
14:00:01 22840 8192000000 10436783584 10769420288 1486152928 15.355 100 84 168 0 1520946688 7627168 27166592
14:00:35 16246 8192000000 10455459200 10793349120 1508094256 15.547 100 84 168 0 1542670704 7955424 26621024
14:01:02 18317 8192000000 10472396384 10813829120 1530929792 15.745 100 82 164 0 1565487040 8685072 25872176
14:01:29 17529 8192000000 10497870464 10847191040 1554629968 15.950 100 80 160 0 1588176192 8954112 24592112
14:01:56 19689 8192000000 10532403344 10883129344 1584435248 16.206 100 80 160 0 1618588048 9647632 24505168
14:02:23 14180 8192000000 10550183216 10905268224 1604443568 16.377 100 83 166 2 1640387216 10505904 25437744
14:02:48 9739 8192000000 10557410416 10917548032 1629117888 16.587 100 75 150 3 1662201712 11076992 22006832
14:03:06 16422 8192000000 10596114656 10960949248 1657153088 16.825 100 84 168 1 1694350736 12512624 24685024
14:03:32 9641 8192000000 10614093952 10981257216 1671845440 16.949 100 75 150 3 1706454176 12512176 22096560
14:03:49 6093 8192000000 10627231104 10997100544 1687839008 17.083 100 79 158 1 1723243584 12128656 23275920
14:04:03 9093 8192000000 10632810416 11008815104 1696847232 17.159 100 69 137 1 1728893328 11598464 20447632
14:04:20 6177 8192000000 10660953040 11031027712 1714864576 17.309 100 74 148 1 1747931072 11636112 21430384
14:04:34 5411 8192000000 10675718368 11043876864 1728572928 17.424 100 84 164 2 1764683904 12465952 23645024
14:04:52 6308 8192000000 10675580064 11051507712 1744754976 17.558 100 79 159 1 1779039216 11665424 22618816
14:05:06 4002 8192000000 10693612608 11069337600 1753452368 17.630 100 80 158 2 1786792384 11767392 21572624
14:05:17 4820 8192000000 10697810176 11077971968 1760756000 17.691 100 79 158 1 1795460560 12057328 22647232
14:05:29 5706 8192000000 10715951872 11095330816 1776485184 17.821 100 75 150 0 1809762560 11922592 21354784
14:05:43 4236 8192000000 10722028272 11103014912 1791506976 17.944 100 81 162 2 1826595840 12095808 22993056
14:05:54 5276 8192000000 10732535488 11117969408 1799971120 18.014 100 77 155 3 1835044928 13326320 21747488
14:06:06 3399 8192000000 10745356032 11127074816 1807113216 18.072 100 82 164 0 1843388736 12257280 24018240
14:06:16 3760 8192000000 10736670064 11126206464 1805821712 18.062 100 86 172 0 1842349168 11816464 24710992
14:06:27 5332 8192000000 10744790896 11133067264 1804580528 18.051 100 71 141 0 1835892560 11929072 19382960
14:06:39 6448 8192000000 10745179824 11136118784 1809634640 18.093 100 78 156 1 1844741824 13558720 21548464
14:06:52 3456 8192000000 10772489152 11158388736 1830775808 18.266 100 88 176 1 1869378592 14251520 24351264
14:07:02 2127 8192000000 10776553216 11162546176 1834782912 18.298 100 92 185 2 1876078832 15644656 25651264
14:07:11 2965 8192000000 10785224048 11168284672 1837762032 18.323 100 91 179 0 1878779648 15767648 25249968
14:07:21 2708 8192000000 10786186048 11172880384 1840268720 18.343 100 86 172 0 1879613472 15001984 24342768
14:07:30 1952 8192000000 10788625568 11176026112 1847216272 18.400 100 93 184 2 1888534864 15058352 26260240
14:07:38 1901 8192000000 10797495984 11182342144 1849277712 18.416 100 92 183 2 1889319824 14405312 25636800
14:07:47 2316 8192000000 10802190432 11188871168 1852814400 18.445 100 85 171 3 1890755920 12971760 24969760
14:07:55 2649 8192000000 10805159120 11193442304 1861138000 18.513 100 93 187 1 1899627056 12670032 25819024
14:08:04 1513 8192000000 10809349648 11194957824 1860516992 18.507 100 93 184 1 1903046384 16563472 25965920
14:08:12 2477 8192000000 10814117568 11199705088 1862928496 18.527 100 89 178 2 1900506928 12611840 24966592
14:08:21 2459 8192000000 10811871088 11197259776 1866363472 18.555 100 98 194 3 1908215136 13598240 28253424
14:08:29 1541 8192000000 10809462144 11198754816 1866940448 18.560 100 95 189 1 1907714176 14172928 26600800
14:08:37 1753 8192000000 10809375472 11202154496 1870948320 18.592 100 94 189 3 1911533312 13683632 26901360
14:08:45 38497 8192000000 10797667600 11204108288 1864896512 18.543 100 58 117 0 1891373792 10027136 16450144
14:09:30 2509 8192000000 10818961264 11217936384 1878089344 18.650 100 89 178 0 1915372544 11347920 25935280
14:09:42 6018 8192000000 10788668384 11208138752 1869231424 18.578 100 41 82 0 1889597584 8767216 11598944
14:09:57 3273 8192000000 10790207456 11216216064 1876239536 18.635 100 44 88 1 1901605152 13263600 12102016
14:10:07 10825 8192000000 10785779328 11214835712 1876124160 18.634 100 34 67 0 1893446864 7163472 10159232
14:10:24 4901 8192000000 10789283264 11215564800 1881776864 18.679 100 35 71 1 1898608704 7024480 9807360
14:10:36 8108 8192000000 10790035280 11217707008 1881150896 18.674 100 35 70 1 1897573280 6096240 10326144
14:10:50 6698 8192000000 10796898544 11224563712 1880777840 18.671 100 17 33 0 1891430512 6284176 4368496
14:11:04 6550 8192000000 10791003520 11221663744 1884585824 18.702 100 21 42 4 1896349632 5822752 5941056
14:11:18 9045 8192000000 10784200032 11225014272 1883933824 18.697 100 17 35 1 1895077072 6481408 4661840
14:11:34 10465 8192000000 10789573216 11225710592 1885100208 18.706 100 15 30 1 1895411952 6023472 4288272
14:11:53 8400 8192000000 10790980720 11226275840 1885735360 18.711 100 14 28 1 1895042304 5573808 3733136
14:12:07 8092 8192000000 10810214048 11236593664 1892513552 18.766 100 20 40 1 1905088272 6111744 6462976
14:12:22 14203 8192000000 10799935344 11237687296 1891570848 18.758 100 9 18 0 1899393520 5399472 2423200
14:12:42 23268 8192000000 10801189952 11241615360 1904610304 18.863 100 44 88 2 1923764080 6601200 12552576
14:13:48 28320 8192000000 10823058080 11254906880 1902896640 18.850 100 27 51 5 1920401008 10470672 7033696
14:14:25 6746 8192000000 10824458496 11247534080 1900753968 18.832 100 19 38 4 1911580896 5594160 5232768
14:14:38 5399 8192000000 10823981856 11255037952 1905977584 18.874 100 35 71 1 1922615904 6227440 10410880
14:14:52 5696 8192000000 10823217920 11257540608 1906424304 18.878 100 20 39 2 1918143584 5752288 5966992
14:15:08 7240 8192000000 10807382944 11241029632 1870867488 18.591 98 26 52 2 1884760176 6341808 7550880
14:15:23 7067 8192000000 10819275600 11248898048 1902497040 18.846 100 36 70 2 1919252992 6680768 10075184
14:15:37 5875 8192000000 10814897728 11247394816 1898741232 18.816 100 29 58 1 1912767904 5747280 8279392
14:15:50 6288 8192000000 10817373616 11248984064 1900952144 18.834 100 26 49 0 1913438848 5466848 7019856
14:16:05 4668 8192000000 10801246912 11227348992 1864223984 18.538 98 26 52 0 1877633552 6313040 7096528
14:16:18 10158 8192000000 10800116992 11235577856 1877173344 18.642 99 25 49 3 1889905568 5618112 7114112
14:16:34 8315 8192000000 10814189056 11242733568 1891261760 18.756 100 17 33 2 1902183600 6205424 4716416
14:16:50 10107 8192000000 10777643776 11213443072 1850232688 18.424 98 18 36 0 1860724896 4984816 5507392
14:17:07 8867 8192000000 10778592256 11211710464 1842362768 18.360 98 18 36 1 1853404656 5544432 5497456
14:17:22 5463 8192000000 10785733648 11203923968 1857774128 18.485 100 16 34 1 1870904976 9068864 4061984
14:17:34 61458 8192000000 10781516560 11195174912 1798840064 18.004 96 42 84 0 1816363872 4985312 12538496
14:18:42 8047 8192000000 10715951008 11150438400 1774746176 17.806 97 12 24 1 1783315136 5601952 2967008
14:18:56 9118 8192000000 10712726048 11127287808 1741469776 17.531 95 32 63 3 1756016608 5465888 9080944
14:19:12 3344 8192000000 10708546672 11120939008 1776538448 17.821 99 39 78 2 1795678496 8053104 11086944
14:19:22 5285 8192000000 10728228800 11150974976 1809256176 18.090 100 34 68 1 1830693840 12106736 9330928
14:19:35 9214 8192000000 10728301776 11138142208 1781809360 17.864 98 32 65 0 1796809648 5479232 9521056
14:19:51 8382 8192000000 10702561696 11119079424 1738746576 17.508 96 42 84 1 1756464384 5176944 12540864
14:20:07 8668 8192000000 10715926448 11140018176 1780160272 17.851 98 16 32 2 1790612352 5704336 4747744
14:20:25 7059 8192000000 10706448656 11123445760 1734948432 17.477 96 24 46 0 1752516640 11052192 6516016
14:20:39 9346 8192000000 10722662224 11140194304 1764914016 17.725 97 20 40 2 1775035552 4588480 5533056
14:20:55 12690 8192000000 10718665072 11135709184 1769637792 17.764 98 17 33 1 1781090928 5479520 5973616
14:21:14 6596 8192000000 10718260512 11136897024 1780885296 17.857 98 27 54 4 1794686960 5921056 7880608
14:21:29 11428 8192000000 10717217440 11139661824 1786968544 17.907 98 16 31 0 1796908192 5059184 4880464
14:21:51 11853 8192000000 10720298240 11141066752 1768140032 17.752 97 17 34 0 1782558368 9245136 5173200
14:22:11 79011 8192000000 10724907376 11153121280 1777025552 17.825 97 24 48 4 1788457968 4282272 7150144
14:23:37 9797 8192000000 10765441184 11180707840 1837197248 18.318 100 25 50 3 1849792768 5157344 7438176
14:23:53 7905 8192000000 10762760656 11187503104 1848100208 18.407 100 26 52 1 1861051728 5838080 7113440
14:24:09 4947 8192000000 10760893824 11189506048 1850949408 18.430 100 39 78 0 1870356592 8062880 11344304
14:24:21 11010 8192000000 10775552048 11197526016 1855808096 18.469 100 30 60 0 1870135712 5765568 8562048
14:24:41 7749 8192000000 10771116288 11199213568 1854635376 18.460 100 20 40 1 1866165856 5915024 5615456
14:24:57 8177 8192000000 10768226992 11200598016 1860800560 18.510 100 24 48 0 1873637712 5936784 6900368
14:25:17 9635 8192000000 10778168208 11206393856 1863404720 18.531 100 28 56 0 1878195024 6022880 8767424
14:25:36 11312 8192000000 10789320304 11217121280 1868788304 18.574 100 20 38 1 1879970640 5125808 6056528
14:25:55 5959 8192000000 10796649664 11221094400 1875031968 18.625 100 31 62 2 1890060448 5555888 9472592
14:26:07 11732 8192000000 10787686976 11222548480 1875610160 18.630 100 11 22 1 1883944016 5132080 3201776
14:26:25 5628 8192000000 10786859728 11222384640 1877929856 18.648 100 24 48 1 1891388496 5966672 7491968
14:26:38 10669 8192000000 10793178928 11227090944 1877074256 18.641 100 12 24 1 1885666528 5155488 3436784
14:26:58 18587 8192000000 10831854736 11249963008 1888475104 18.733 100 25 49 1 1900447456 4654816 7317536
14:28:09 23057 8192000000 10853590656 11269681152 1919285456 18.981 100 38 75 1 1935069200 5117696 10666048
14:28:42 18104 8192000000 10862458704 11280752640 1928340208 19.054 100 62 124 1 1953692608 6923392 18429008
14:29:18 5402 8192000000 10853930016 11283607552 1931200608 19.076 100 37 73 0 1948752592 7404464 10147520
14:29:31 10055 8192000000 10866768896 11293806592 1935744848 19.113 100 34 67 3 1952412368 6180496 10487024
14:29:54 20456 8192000000 10876096080 11308244992 1948592416 19.215 100 43 86 0 1971857088 10476144 12788528
14:30:24 28316 8192000000 10889268240 11323379712 1954569600 19.263 100 41 82 1 1979528448 13241760 11717088
14:31:06 10803 8192000000 10894961488 11329490944 1960997504 19.314 100 42 84 1 1991310880 17516128 12797248
14:31:28 41298 8192000000 10905778752 11339120640 1969984496 19.385 100 47 94 2 2003836576 20407328 13444752
14:32:22 19225 8192000000 10916270528 11350122496 1975702400 19.431 100 42 84 0 2006994656 18510736 12781520
14:33:00 17345 8192000000 10922030624 11352064000 1976240064 19.435 100 35 69 0 2005379808 18269808 10869936
14:33:31 8746 8192000000 10930169200 11361550336 1985266960 19.506 100 43 87 1 2018513888 19916368 13330560
14:33:48 25524 8192000000 10929965440 11359350784 1979894144 19.464 100 43 86 1 2014776480 21315280 13567056
14:34:22 19476 8192000000 10931348448 11367743488 1985528976 19.508 100 49 99 1 2020734496 19714272 15491248
14:34:49 6272 8192000000 10940429440 11374546944 1994395536 19.579 100 44 85 2 2028159680 20622176 13141968
14:35:19 4611 8192000000 10953929200 11381071872 1998424976 19.610 100 53 105 0 2035528720 20942512 16161232
14:35:37 8151 8192000000 10955811792 11388243968 2004982016 19.662 100 57 113 2 2045166416 23515920 16668480
14:35:53 10273 8192000000 10960018048 11392782336 2007915776 19.685 100 56 112 1 2049308560 24233952 17158832
14:36:15 8102 8192000000 10955138512 11392880640 2012305824 19.720 100 51 100 1 2049687120 22768544 14612752
14:36:30 13602 8192000000 10958009520 11393024000 2008472016 19.689 100 57 114 1 2049220512 23539712 17208784
14:36:54 9610 8192000000 10960360192 11396091904 2013935248 19.732 100 53 106 1 2052421200 22534576 15951376
14:37:16 3524 8192000000 10974349568 11404685312 2017861104 19.763 100 66 132 1 2061636064 24523056 19251904
14:37:40 5456 8192000000 10969470640 11401924608 2002041248 19.639 99 62 124 0 2046231392 25549728 18640416
14:37:54 9986 8192000000 10966987792 11398975488 1995498272 19.587 99 58 114 0 2040925600 27550128 17877200
14:38:11 5392 8192000000 10984019312 11406213120 2014516192 19.737 100 68 132 2 2061959584 27466736 19976656
14:38:26 14324 8192000000 10967437648 11399577600 1993766912 19.574 99 60 120 0 2043872176 31956816 18148448
14:38:48 4073 8192000000 10976062912 11408244736 2011634704 19.714 100 64 129 1 2064511552 32848336 20028512
14:39:03 2148 8192000000 10962569552 11382185984 1978396704 19.452 98 78 152 2 2034800016 33846880 22556432
14:39:18 3258 8192000000 10973635968 11393187840 1999674528 19.620 100 64 127 0 2054652960 35569328 19409104
14:39:28 2593 8192000000 10964195008 11382685696 1987345824 19.523 100 80 157 1 2047950752 36421200 24183728
14:39:37 9629 8192000000 10957126176 11385044992 1990216064 19.546 100 62 123 0 2047941392 38056384 19668944
14:39:59 9005 8192000000 10947648112 11367710720 1974930224 19.425 99 72 142 3 2037823424 41277216 21615984
14:40:17 4603 8192000000 10951491984 11382579200 1970522736 19.390 99 59 115 1 2029210192 39528096 19159360
14:40:40 4781 8192000000 10964854976 11395928064 1990631760 19.549 100 55 109 1 2050604576 41886592 18086224
14:40:52 4328 8192000000 10975263920 11398782976 1995629712 19.588 100 75 149 3 2061280992 42427056 23224224
14:41:04 5468 8192000000 10980050256 11404464128 1984545776 19.501 99 75 150 1 2052422048 44820688 23055584
14:41:19 3737 8192000000 10966825328 11391242240 1994235216 19.577 100 74 149 3 2058124112 40585648 23303248
14:41:31 1923 8192000000 10983536496 11405049856 2000052928 19.623 100 61 121 1 2058963360 40178736 18731696
14:41:41 3990 8192000000 10979047840 11400617984 1987355072 19.523 99 82 164 0 2052653104 40077872 25220160
14:41:52 6262 8192000000 10969961728 11394068480 1980731296 19.470 99 82 162 1 2047690944 41685520 25274128
14:42:05 4810 8192000000 10969633024 11389968384 1975549440 19.429 99 71 141 1 2039651856 42356208 21746208
14:42:16 3441 8192000000 10984074544 11401953280 1997818192 19.606 100 80 160 2 2067702032 45003008 24880832
14:42:28 3862 8192000000 10959054592 11379568640 1974241648 19.419 99 70 140 0 2041265440 44874368 22149424
14:42:40 5119 8192000000 10958451216 11382362112 1976375792 19.436 100 72 144 1 2045069152 45389744 23303616
14:42:58 5540 8192000000 10968808208 11391979520 1980731120 19.470 100 78 154 1 2053146848 47179808 25235920
14:43:11 2724 8192000000 10974261472 11395723264 1982105232 19.481 100 79 158 1 2056943664 49705712 25132720
14:43:21 2747 8192000000 10981631968 11393462272 1984602512 19.501 100 79 157 3 2056402384 46163056 25636816
14:43:31 2855 8192000000 10964780832 11388026880 1984023664 19.497 100 82 164 0 2052273632 42735440 25514528
14:43:41 2535 8192000000 10931531072 11341033472 1942495280 19.167 100 87 174 1 2009962720 40633968 26833472
14:43:50 5582 8192000000 10912485472 11336212480 1910138304 18.908 98 62 124 1 1968461440 39393488 18929648
14:44:06 4558 8192000000 10930828560 11342950400 1944200816 19.180 100 67 132 1 2011526800 46112640 21213344
14:44:18 2372 8192000000 10937014400 11354611712 1951556704 19.239 100 85 170 1 2020996400 42282448 27157248
14:44:28 3201 8192000000 10943565200 11351941120 1931813520 19.081 99 83 164 3 2003108896 45883184 25412192
14:44:38 3201 8192000000 10950266112 11361042432 1952072352 19.243 100 89 177 0 2026031488 47801792 26157344
14:44:49 5439 8192000000 10946673808 11366084608 1954304816 19.261 100 73 146 3 2026805344 49926240 22574288
14:45:19 6035 8192000000 10925714560 11365580800 1948891040 19.218 100 52 105 0 2017076800 51582032 16603728
14:45:34 10869 8192000000 10918434416 11369619456 1950798432 19.233 100 35 67 3 2008478880 46032960 11647488
14:45:59 17854 8192000000 10915668080 11351355392 1900059664 18.827 97 34 68 2 1951767712 40717456 10990592
14:46:30 7312 8192000000 10898702224 11325091840 1891636720 18.759 97 49 98 3 1946880512 39634160 15609632
14:46:44 24545 8192000000 10912582160 11350556672 1942147616 19.164 100 33 66 1 1992344000 39179504 11016880
14:47:19 8910 8192000000 10905285344 11349839872 1922866624 19.010 99 38 76 1 1979184464 43393728 12924112
14:47:37 11589 8192000000 10903195632 11352227840 1922875872 19.010 99 32 64 1 1977935568 44096192 10963504
14:48:19 14414 8192000000 10910366880 11365052416 1930623584 19.072 99 26 52 1 1980853344 41818128 8411632
14:48:48 10651 8192000000 10903350768 11355029504 1930171936 19.068 100 28 56 2 1984090112 44926512 8991664
14:49:10 32546 8192000000 10883795248 11329236992 1882457232 18.685 97 25 50 1 1932335440 41278368 8599840
14:49:48 19652 8192000000 10875473952 11326812160 1902158160 18.844 99 19 38 1 1950276144 41529472 6588512
14:50:15 23845 8192000000 10883248720 11333279744 1901335200 18.837 99 17 34 3 1945809088 38282064 6191824
14:50:47 20822 8192000000 10898068064 11348652032 1927300288 19.045 100 24 48 1 1981379968 45118320 8961360
14:51:16 9261 8192000000 10908984240 11353186304 1896861120 18.801 98 29 58 2 1958903968 51529728 10513120
14:51:40 18984 8192000000 10889285632 11350237184 1907551632 18.887 99 24 47 2 1959439648 43642704 8245312
14:52:25 47061 8192000000 10861514704 11315654656 1886157216 18.715 98 14 28 1 1915713280 25152912 4403152
14:55:33 49237 8192000000 10877401984 11320717312 1929887456 19.066 100 34 68 2 1956231488 16157344 10186688
14:56:42 43992 8192000000 10898483120 11335000064 1937871056 19.130 100 40 82 1 1967602432 18439008 11292368
14:57:33 206713 8192000000 10903182528 11366842368 1939691600 19.144 99 21 42 1 1968250256 21863024 6695632
15:01:24 118500 8192000000 10908583392 11357843456 1960587024 19.311 100 26 52 1 1981667248 13989440 7090784
15:03:30 16674 8192000000 10898422752 11341819904 1932767808 19.089 98 54 108 0 1959236144 10279424 16188912
15:04:00 54132 8192000000 10892525808 11354533888 1957965680 19.290 100 28 56 0 1973619040 7912480 7740880
15:05:03 59325 8192000000 10893689392 11357474816 1953966384 19.258 99 16 32 0 1967742144 9422048 4353712
15:06:08 59535 8192000000 10907402064 11369140224 1971926848 19.401 100 14 28 1 1988721200 12870224 3924128
15:07:25 6187 8192000000 10911935184 11369267200 1965748784 19.352 99 37 73 1 1990320832 14452176 10119872
15:07:39 42197 8192000000 10906618480 11361521664 1942047088 19.163 98 31 62 1 1963404096 11883056 9473952
15:08:32 86349 8192000000 10915280464 11382927360 1974346896 19.420 100 26 52 2 2000061264 17123744 8590624
15:10:05 42134 8192000000 10892319712 11376971776 1929802688 19.065 98 11 22 1 1952138064 18991584 3343792
15:11:07 59916 8192000000 10900315104 11392151552 1967318784 19.364 100 12 24 0 1986524128 15382368 3822976
15:12:15 43602 8192000000 10891478640 11382587392 1937030912 19.123 98 8 14 1 1957503344 18418576 2053856
15:13:16 39972 8192000000 10908246432 11356356608 1927198192 19.044 98 20 39 1 1943113728 10159504 5756032
15:14:04 52678 8192000000 10890518768 11354808320 1951097840 19.235 99 39 79 0 1972360048 10141856 11120352
15:15:04 63699 8192000000 10900874800 11372843008 1968259568 19.372 100 24 48 1 1989989472 15056144 6673760
15:16:14 97233 8192000000 10915474880 11376164864 1953816336 19.257 99 11 22 1 1968027264 11635664 2575264
15:18:01 28701 8192000000 10931213344 11380068352 1974466208 19.421 99 48 96 1 1999393152 11529792 13397152
15:18:40 48946 8192000000 10908002224 11382448128 1965008944 19.346 99 28 56 1 1985547600 12846928 7691728
15:19:35 76800 8192000000 10916704560 11391692800 1962815136 19.328 99 22 44 2 1985911152 16665840 6430176
15:21:01 121860 8192000000 10915370288 11371876352 1924563152 19.023 97 19 38 3 1943443424 13530112 5350160
15:23:09 31681 8192000000 10934890080 11379273728 1983765584 19.495 100 46 92 0 2006573568 10306560 12501424
15:23:47 33846 8192000000 10928875232 11388764160 1989298992 19.538 100 40 80 2 2012570784 11786016 11485776
15:24:32 95999 8192000000 10907880976 11379048448 1926458512 19.039 97 25 50 2 1947904864 14281872 7164480
15:27:14 131033 8192000000 10906409744 11402223616 1945012640 19.187 98 27 54 1 1973027136 20072352 7942144
15:29:32 32485 8192000000 10911130624 11400978432 1975505728 19.429 100 4 8 0 2000266320 23926800 833792
15:30:11 38168 8192000000 10902077536 11367215104 1961999904 19.322 99 23 46 1 1976516720 7523408 6993408
15:31:02 62004 8192000000 10869481568 11348750336 1936800512 19.121 98 15 30 1 1948768800 8174096 3794192
15:32:47 51650 8192000000 10845740592 11316645888 1912354720 18.926 97 12 24 1 1923024512 6733808 3935984
15:33:54 62335 8192000000 10861915616 11335516160 1940042224 19.147 99 9 17 0 1950365072 7569264 2753584
15:35:07 55023 8192000000 10857150992 11331629056 1902657920 18.848 97 16 32 0 1918298512 10992608 4647984
15:36:20 74380 8192000000 10870378752 11332399104 1915299264 18.949 98 24 49 1 1929471392 7408032 6764096
15:37:47 98360 8192000000 10870956368 11355734016 1917585360 18.967 98 11 22 0 1930462720 9894752 2982608
15:39:35 53638 8192000000 10906213392 11368624128 1952959040 19.250 99 18 36 1 1973337520 14606704 5771776
15:41:01 57056 8192000000 10886099344 11373940736 1926955232 19.043 98 13 26 0 1950356400 19354464 4046704
15:42:10 83672 8192000000 10872745264 11335757824 1853885504 18.454 94 23 46 1 1869638352 9572208 6180640
15:43:40 18217 8192000000 10894477680 11348508672 1937942720 19.130 99 36 70 1 1961511312 14287744 9280848
15:44:08 79893 8192000000 10841255968 11318255616 1828093056 18.244 94 16 32 0 1844032480 11536528 4402896
15:45:34 44337 8192000000 10833053264 11283070976 1847571328 18.402 96 24 48 1 1863611168 8830528 7209312
15:46:32 47313 8192000000 10847205280 11298795520 1881761952 18.679 98 29 58 0 1902348496 12511968 8074576
15:47:27 27404 8192000000 10860574144 11311054848 1903268464 18.853 99 38 77 0 1925444368 11356464 10819440
15:48:01 29951 8192000000 10863404144 11306332160 1850622416 18.427 96 42 84 0 1874394704 12186208 11586080
15:48:44 73239 8192000000 10846385760 11318050816 1854253184 18.457 97 26 52 0 1875089232 13430272 7405776
15:50:12 79707 8192000000 10886660992 11340275712 1932033248 19.083 100 26 51 0 1952338400 12755136 7550016
15:51:38 93435 8192000000 10863690736 11327590400 1876094784 18.634 96 19 39 1 1892319616 10758160 5466672
15:53:19 93297 8192000000 10866830688 11345506304 1918707376 18.976 99 19 37 1 1940904288 16610832 5586080
15:55:06 46095 8192000000 10878887232 11330629632 1918260112 18.973 99 18 36 0 1933792112 10898560 4633440
15:57:52 64020 8192000000 10856313648 11330916352 1936896144 19.122 100 15 27 0 1951871920 11576496 3399280
15:59:27 60957 8192000000 10855033808 11325054976 1941431424 19.158 100 11 22 1 1950613472 5253184 3928864
16:00:34 47725 8192000000 10876346144 11341127680 1913627696 18.936 98 11 22 0 1921766736 5413552 2725488
16:02:05 85634 8192000000 10901384064 11376889856 1947241504 19.205 99 24 48 1 1966973872 13445200 6287168
16:03:41 60047 8192000000 10902966160 11384385536 1978089808 19.450 100 18 35 0 2003922352 20924992 4907552
16:05:12 65164 8192000000 10904623456 11369803776 1918790336 18.977 97 16 32 0 1941902864 18656544 4455984
16:06:24 53590 8192000000 10911194160 11363385344 1950361264 19.229 99 22 41 1 1965442208 9456320 5624624
16:07:27 25901 8192000000 10943812080 11387555840 1981760672 19.479 100 45 88 0 2003344976 8749936 12834368
16:08:04 41188 8192000000 10911328320 11385065472 1967595696 19.366 99 26 52 1 1991710048 16623584 7490768
16:09:33 63769 8192000000 10910535136 11363762176 1949982480 19.226 99 26 51 2 1975838976 18846720 7009776
16:10:46 106066 8192000000 10897513632 11371216896 1957210160 19.284 99 13 26 1 1973072528 12416656 3445712
16:12:39 25275 8192000000 10889361760 11336192000 1863964720 18.535 94 29 58 0 1879971328 7568000 8438608
16:13:15 43002 8192000000 10886348976 11341533184 1899373600 18.821 97 25 50 0 1916142912 10428576 6340736
16:14:09 41510 8192000000 10911249856 11366854656 1965896352 19.353 100 34 69 0 1985490880 10784272 8810256
16:15:07 115947 8192000000 10881222320 11353346048 1922699888 19.008 98 16 32 0 1941914976 13664608 5550480
16:17:09 98464 8192000000 10901677264 11363729408 1953069424 19.251 99 25 50 0 1970850240 11359024 6421792
16:19:01 38862 8192000000 10901090512 11357532160 1960287488 19.308 99 42 85 1 1985857440 13798704 11771248
16:19:49 90028 8192000000 10879663904 11360100352 1935282928 19.109 98 15 30 1 1949989056 10321136 4384992
16:21:25 54767 8192000000 10892399776 11362234368 1965429248 19.349 100 12 24 2 1975664656 6971792 3263616
16:22:26 49440 8192000000 10898298000 11357888512 1915251520 18.949 97 24 48 2 1931096432 9164304 6680608
16:24:27 58101 8192000000 10895583296 11364884480 1928639200 19.056 98 23 46 1 1951305616 16139680 6526736
16:25:39 63918 8192000000 10890051776 11353440256 1930885584 19.074 99 18 37 1 1957642080 21149344 5607152
16:26:49 30744 8192000000 8868660960 9093902336 25476752 0.310 2 2 4 0 25986240 175616 333872

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 16-01-2021 16:28:44 to 16-01-2021 16:29:14.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-01-2021 16:29:14 to 16-01-2021 16:29:16.

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          233195
MON$OLDEST_ACTIVE               233196
MON$OLDEST_SNAPSHOT             233196
MON$NEXT_TRANSACTION            233196
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                       2009728
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
--- end of diff output ---

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

16.01.21 16:29:17. 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-01-16 16:29:20 No severe PSQL-related problems occured
16.01.21 16:29:21. End of report.