Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.02.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 17179028 kB
MemAvailable 31127552 kB
Buffers 0 kB
Cached 14547616 kB
SwapCached 3276 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-02-26 16:27:21
DTS_END                         2021-02-26 16:27:21.0630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36050
TRN_ID                          230618
ATT_ID                          596
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.85 20980 1074582
customer order: creation 165.76 376 19891
customer order: refuse 13.84 332 1661
order to supplier: creation 43.64 1348 5237
order to supplier: removal 3.28 96154 394
invoice (draft): creation 44.55 3529 5346
invoice (draft): removal 50.64 764 6077
invoice accept: apply 40.78 20909 4893
invoice accept: cancel 45.18 809 5422
customer reserve: creation 3819.16 204 458299
customer reserve: removal 4442.30 55 533076
realization accept: apply 81.07 176 9728
realization accept: cancel 79.59 105 9551
payment from customer: creation 57.04 115 6845
payment from customer: removal 5.63 62 676
payment to supplier: creation 46.86 135 5623
payment to supplier: removal 3.62 64 434
service: total inventory turnovers 4.83 1079 579
service: total monetary turnovers 6.30 25 756
service: aggregate perf. data 0.75 23872 90
service: refresh index statistics 0.03 269480 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 26-02-2021 16:28:50 to 26-02-2021 16:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3059
TEST_TIME 2 4322
TEST_TIME 3 3873
TEST_TIME 4 4845
TEST_TIME 5 4903
TEST_TIME 6 5173
TEST_TIME 7 5854
TEST_TIME 8 5625
TEST_TIME 9 5773
TEST_TIME 10 5699
TEST_TIME 11 5841
TEST_TIME 12 6087
TEST_TIME 13 6354
TEST_TIME 14 7116
TEST_TIME 15 7401
TEST_TIME 16 7462
TEST_TIME 17 7671
TEST_TIME 18 7894
TEST_TIME 19 8163
TEST_TIME 20 8809
TEST_TIME 21 9147
TEST_TIME 22 9527
TEST_TIME 23 9727
TEST_TIME 24 10170
TEST_TIME 25 10490
TEST_TIME 26 10499
TEST_TIME 27 10490
TEST_TIME 28 10641
TEST_TIME 29 10390
TEST_TIME 30 10692
TEST_TIME 31 10477
TEST_TIME 32 10289
TEST_TIME 33 10171
TEST_TIME 34 10026
TEST_TIME 35 9834
TEST_TIME 36 9789
TEST_TIME 37 9847
TEST_TIME 38 9741
TEST_TIME 39 9574
TEST_TIME 40 9640
TEST_TIME 41 9600
TEST_TIME 42 9481
TEST_TIME 43 9531
TEST_TIME 44 9403
TEST_TIME 45 9324
TEST_TIME 46 9229
TEST_TIME 47 9182
TEST_TIME 48 9346
TEST_TIME 49 9205
TEST_TIME 50 9212
TEST_TIME 51 9375
TEST_TIME 52 9285
TEST_TIME 53 9428
TEST_TIME 54 9391
TEST_TIME 55 9315
TEST_TIME 56 9266
TEST_TIME 57 9468
TEST_TIME 58 9432
TEST_TIME 59 9438
TEST_TIME 60 9526
TEST_TIME 61 9425
TEST_TIME 62 9475
TEST_TIME 63 9593
TEST_TIME 64 9543
TEST_TIME 65 9451
TEST_TIME 66 9353
TEST_TIME 67 9352
TEST_TIME 68 9305
TEST_TIME 69 9273
TEST_TIME 70 9241
TEST_TIME 71 9208
TEST_TIME 72 9169
TEST_TIME 73 9165
TEST_TIME 74 9058
TEST_TIME 75 9084
TEST_TIME 76 9103
TEST_TIME 77 9062
TEST_TIME 78 9058
TEST_TIME 79 9113
TEST_TIME 80 9075
TEST_TIME 81 9143
TEST_TIME 82 9180
TEST_TIME 83 9177
TEST_TIME 84 9167
TEST_TIME 85 9218
TEST_TIME 86 9243
TEST_TIME 87 9295
TEST_TIME 88 9276
TEST_TIME 89 9228
TEST_TIME 90 9185
TEST_TIME 91 9140
TEST_TIME 92 9099
TEST_TIME 93 9061
TEST_TIME 94 9067
TEST_TIME 95 9061
TEST_TIME 96 9026
TEST_TIME 97 9017
TEST_TIME 98 9014
TEST_TIME 99 9104
TEST_TIME 100 9075
TEST_TIME 101 9052
TEST_TIME 102 9065
TEST_TIME 103 9090
TEST_TIME 104 9131
TEST_TIME 105 9121
TEST_TIME 106 9116
TEST_TIME 107 9141
TEST_TIME 108 9180
TEST_TIME 109 9127
TEST_TIME 110 9149
TEST_TIME 111 9200
TEST_TIME 112 9124
TEST_TIME 113 9093
TEST_TIME 114 9064
TEST_TIME 115 9018
TEST_TIME 116 9023
TEST_TIME 117 8988
TEST_TIME 118 8974
TEST_TIME 119 8932
TEST_TIME 120 8957

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-02-2021 16:28:54 to 26-02-2021 16:28:57.

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 1497501 1497501 0 0.00 0 23026 7 0 0
doc_list_biud 1497501 1497501 0 0.00 0 24074 25 0 0
sp_add_invoice_to_stock 5010 4893 117 2.33 44 209442 20909 0 117
sp_cancel_adding_invoice 5422 5422 0 0.00 4 56618 809 0 0
sp_cancel_client_order 1661 1661 0 0.00 5 7196 332 0 0
sp_cancel_customer_reserve 533076 533076 0 0.00 1 24076 56 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 3 5263 63 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 2 1874 65 0 0
sp_cancel_supplier_invoice 6089 6077 12 0.19 1 16814 764 0 12
sp_cancel_supplier_order 394 394 0 0.00 12 966916 96155 0 0
sp_cancel_write_off 9551 9551 0 0.00 1 12984 105 0 0
sp_client_order 19891 19891 0 0.00 3 39970 377 0 0
sp_customer_reserve 458299 458299 0 0.00 0 52373 205 0 0
sp_fill_shopping_cart 30444 30444 0 0.00 1 28662 39 0 0
sp_fill_shopping_cart_clo_res 458290 458290 0 0.00 0 28762 16 0 0
sp_get_clo_for_invoice 4882 4882 0 0.00 0 47343 349 0 0
sp_kill_cost_storno 16083 16083 0 0.00 0 8714 56 0 0
sp_kill_qstorno_ret_qs2qd 1082174 1082174 0 0.00 0 24045 30 0 0
sp_kill_qty_storno 570790 570790 0 0.00 0 24073 66 0 0
sp_lock_selected_doc 20137 20137 0 0.00 0 7501 5 0 0
sp_make_cost_storno 27077 27077 0 0.00 0 21746 56 0 0
sp_multiply_rows_for_pdistr 27077 27077 0 0.00 0 7494 29 0 0
sp_multiply_rows_for_qdistr 19891 19891 0 0.00 0 15854 156 0 0
sp_pay_from_customer 6845 6845 0 0.00 4 15071 115 0 0
sp_pay_to_supplier 5623 5623 0 0.00 4 22980 135 0 0
sp_payment_common 12468 12468 0 0.00 1 13830 29 0 0
sp_qd_handle_on_cancel_clo 1661 1661 0 0.00 0 7134 305 0 0
sp_qd_handle_on_invoice_upd_sts 10303 10303 0 0.00 0 23873 349 0 0
sp_qd_handle_on_reserve_upd_sts 9728 9728 0 0.00 0 16412 57 0 0
sp_reserve_write_off 9728 9728 0 0.00 6 16431 177 0 0
sp_supplier_invoice 5346 5346 0 0.00 6 77291 3529 0 0
sp_supplier_order 5237 5237 0 0.00 6 39972 1348 0 0
srv_aggregate_perf_data 90 90 0 0.00 2416 313381 23873 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 872 145266 32278 0 0
srv_find_qd_qs_mism 1027370 1027370 0 0.00 0 10094 6 0 0
srv_make_invnt_saldo 579 579 0 0.00 38 45365 1079 0 0
srv_make_money_saldo 756 756 0 0.00 0 1437 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 110176 551712 269480 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4893 4893 0 0.00 0 10715 176 0 0
t$perf-norm:sp_cancel_adding_invoice 376 376 0 0.00 1 6196 131 0 0
t$perf-norm:sp_cancel_client_order 1661 1661 0 0.00 0 6784 20 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 1821 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 1486 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 1310 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 8485 42 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 44517 1816 0 0
t$perf-norm:sp_cancel_write_off 934 934 0 0.00 0 1839 6 0 0
t$perf-norm:sp_client_order 19891 19891 0 0.00 0 9120 18 0 0
t$perf-norm:sp_customer_reserve 884 884 0 0.00 0 1536 9 0 0
t$perf-norm:sp_pay_from_customer 6845 6845 0 0.00 0 5580 10 0 0
t$perf-norm:sp_pay_to_supplier 5623 5623 0 0.00 0 9483 13 0 0
t$perf-norm:sp_reserve_write_off 9728 9728 0 0.00 0 24121 15 0 0
t$perf-norm:sp_supplier_invoice 5346 5346 0 0.00 0 4967 20 0 0
t$perf-norm:sp_supplier_order 5237 5237 0 0.00 0 15197 20 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 332 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 2551 19 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 1157 19 0 0
t$perf-norm:srv_make_money_saldo 756 756 0 0.00 0 1030 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 1341 337 0 0
v_add_invoice_to_stock 9990 9756 234 2.34 0 6615 21 0 234
v_all_customers 36170 36170 0 0.00 0 21 1 0 0
v_all_suppliers 28900 28900 0 0.00 0 19 1 0 0
v_all_wares 39782 39782 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 752 752 0 0.00 0 1867 9 0 0
v_cancel_client_order 3322 3322 0 0.00 0 4023 8 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 560 4 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 1417 5 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 1168 7 0 0
v_cancel_supplier_invoice 818 794 24 2.93 0 2934 17 0 24
v_cancel_supplier_order 788 788 0 0.00 0 996 5 0 0
v_cancel_write_off 1868 1868 0 0.00 0 12942 19 0 0
v_max_id_clo_ord 5237 5237 0 0.00 0 411 1 0 0
v_max_id_clo_res 884 884 0 0.00 0 2654 12 0 0
v_max_id_ord_sup 5316 5316 0 0.00 0 4143 4 0 0
v_max_non_paid_invoice 1726 1726 0 0.00 0 284 2 0 0
v_max_non_paid_realizn 3630 3630 0 0.00 0 4249 4 0 0
v_min_id_clo_ord 5237 5237 0 0.00 0 1706 4 0 0
v_min_id_clo_res 884 884 0 0.00 0 6262 15 0 0
v_min_id_ord_sup 5316 5316 0 0.00 0 2977 6 0 0
v_min_non_paid_invoice 5623 5623 0 0.00 0 8171 18 0 0
v_min_non_paid_realizn 6845 6845 0 0.00 0 9413 15 0 0
v_our_firm 10042 10042 0 0.00 0 15 1 0 0
v_reserve_write_off 19456 19456 0 0.00 0 4626 6 0 0
x_lock_depdocs_on_canc_invoice 11102 11102 0 0.00 0 16294 113 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 6750 324 0 0
x_make_qstorno_1000_1200 5237 5237 0 0.00 2 39955 1264 0 0
x_make_qstorno_1200_2000 5346 5346 0 0.00 3 70164 3376 0 0
x_make_qstorno_2100_3300 458299 458299 0 0.00 0 47758 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-02-2021 16:28:58 to 26-02-2021 16:29:02.

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:24 7 8192000000 8804944416 8817119232 10526128 0.128 2 2 4 0 10717344 66704 124512
13:57:31 10407 8192000000 10206273664 10506444800 861738480 9.518 68 49 98 1 880183376 2287840 16157056
13:57:49 20233 8192000000 10331956176 10647711744 1378972064 14.407 100 82 164 1 1409617056 4279408 26365584
13:58:19 26465 8192000000 10389389840 10707816448 1430657216 14.867 100 89 178 0 1465284512 5526592 29100704
13:59:00 8319 8192000000 10405384208 10730328064 1468681360 15.202 100 88 176 0 1503392464 6755872 27955232
13:59:18 18153 8192000000 10418736096 10751967232 1480963728 15.310 100 81 161 1 1514838336 7363472 26511136
13:59:43 18437 8192000000 10453748176 10784043008 1497338048 15.453 100 86 172 0 1532067664 7769216 26960400
14:00:10 26057 8192000000 10468948400 10804432896 1519538800 15.646 100 88 176 0 1556049488 8710384 27800304
14:00:52 20265 8192000000 10492098464 10832789504 1538335568 15.809 100 87 173 0 1575099456 9055312 27708576
14:01:20 21882 8192000000 10514263424 10858520576 1561218720 16.007 100 76 152 0 1593857952 9079600 23559632
14:01:51 9955 8192000000 10533767200 10883158016 1595645984 16.302 100 84 168 0 1631024480 9624544 25753952
14:02:10 12935 8192000000 10558584224 10908774400 1606917712 16.398 100 83 166 1 1642626816 10235808 25473296
14:02:37 18142 8192000000 10576580160 10934411264 1631744928 16.610 100 85 170 2 1669044688 11162272 26137488
14:03:05 15030 8192000000 10590163600 10951098368 1646517072 16.735 100 73 146 0 1679275104 10811472 21946560
14:03:30 14253 8192000000 10615882432 10982756352 1673438016 16.962 100 70 141 0 1704608080 10752512 20417552
14:03:51 12719 8192000000 10631571344 11000274944 1694280832 17.137 100 80 158 1 1729381184 11968288 23132064
14:04:12 7845 8192000000 10653057568 11025436672 1708288880 17.254 100 77 153 1 1742941360 12503920 22148560
14:04:31 8335 8192000000 10661946576 11035734016 1726888480 17.410 100 77 154 0 1762581040 13282880 22409680
14:04:47 7345 8192000000 10681304560 11051114496 1733340992 17.463 100 85 170 2 1771128832 13805648 23982192
14:05:02 7564 8192000000 10677026096 11053760512 1746185520 17.570 100 89 178 1 1786655424 15276000 25193904
14:05:18 7297 8192000000 10698655008 11072450560 1757198288 17.661 100 79 158 1 1793966288 14596432 22171568
14:05:32 5777 8192000000 10700638720 11080130560 1763142800 17.710 100 75 149 5 1798512864 14202288 21167776
14:05:47 10070 8192000000 10699660336 11083210752 1768761488 17.757 100 69 137 0 1801006944 13350256 18895200
14:06:05 4723 8192000000 10732442048 11110862848 1792679744 17.954 100 89 178 0 1831613184 13242832 25690608
14:06:17 3738 8192000000 10739690400 11123384320 1798590176 18.002 100 74 148 0 1832177168 12341792 21245200
14:06:27 3978 8192000000 10738110512 11132596224 1809161984 18.089 100 75 147 4 1842443072 12419280 20861808
14:06:38 3671 8192000000 10768464144 11150331904 1818837264 18.168 100 85 169 4 1855565376 12786672 23941440
14:06:49 2815 8192000000 10767814752 11151921152 1826303552 18.229 100 79 158 0 1861534704 13014576 22216576
14:06:58 3716 8192000000 10774916912 11157401600 1827289024 18.237 100 86 172 1 1865892864 14139552 24464288
14:07:08 3833 8192000000 10776825856 11160432640 1836383088 18.311 100 87 174 1 1875350224 14747184 24219952
14:07:19 2766 8192000000 10784749984 11168071680 1834574080 18.297 100 90 180 0 1875406608 14849024 25983504
14:07:28 2018 8192000000 10789940000 11174825984 1846309824 18.392 100 92 186 2 1886024688 13343072 26371792
14:07:37 2297 8192000000 10789356224 11179167744 1845638816 18.387 100 84 167 1 1881764048 12540544 23584688
14:07:46 2435 8192000000 10797326832 11181211648 1850385568 18.425 100 89 179 2 1887994256 13262224 24346464
14:07:55 4255 8192000000 10805546704 11193274368 1859185120 18.497 100 88 175 2 1897275088 13298816 24791152
14:08:06 1787 8192000000 10807116384 11194519552 1866452016 18.556 100 92 184 1 1905340672 13269472 25619184
14:08:15 1776 8192000000 10812340496 11196960768 1863528784 18.532 100 94 187 1 1903979328 13481392 26969152
14:08:23 1944 8192000000 10806952192 11196706816 1873314304 18.611 100 93 184 0 1912429104 13612304 25502496
14:08:31 2615 8192000000 10817482960 11206443008 1871577056 18.597 100 87 174 2 1909754720 13754640 24423024
14:08:40 1529 8192000000 10817210544 11207176192 1873847296 18.615 100 90 180 2 1913052464 13546784 25658384
14:08:48 1841 8192000000 10823611984 11210702848 1878201488 18.651 100 97 194 1 1920704528 14179152 28323888
14:08:57 1404 8192000000 10824772096 11213312000 1880953408 18.673 100 97 196 1 1923279552 14354720 27971424
14:09:05 2382 8192000000 10828305824 11217219584 1883276112 18.692 100 90 181 0 1921866064 13034144 25555808
14:09:13 24015 8192000000 10826338336 11216777216 1878043680 18.649 100 60 120 2 1906265280 10781600 17440000
14:09:45 7554 8192000000 10824782752 11216830464 1885095792 18.706 100 72 132 3 1912521216 8869248 18556176
14:09:59 1941 8192000000 10815903936 11222208512 1885555648 18.710 100 64 127 2 1914700848 11649024 17496176
14:10:08 3400 8192000000 10815911456 11222892544 1885724336 18.711 100 77 153 0 1918318800 11191920 21402544
14:10:19 3357 8192000000 10815066560 11222638592 1883751120 18.695 100 64 128 0 1913000976 10435824 18814032
14:10:29 5979 8192000000 10786354000 11215728640 1880956352 18.673 100 30 60 1 1897393024 8505088 7931584
14:10:43 7511 8192000000 10788035312 11216916480 1879679520 18.663 100 24 48 0 1893325920 7240880 6405520
14:10:58 10781 8192000000 10789331392 11219058688 1883311200 18.692 100 21 42 3 1899294384 10720464 5262720
14:11:19 7505 8192000000 10796350528 11223654400 1886361760 18.716 100 22 44 0 1898445680 6578992 5504928
14:11:33 4967 8192000000 10796333744 11221184512 1890924016 18.753 100 39 76 6 1912398000 10146640 11327344
14:11:45 13751 8192000000 10803627696 11227099136 1891166768 18.755 100 30 60 2 1905378224 6436640 7774816
14:12:05 58217 8192000000 10838776976 11243421696 1901031984 18.835 100 55 109 2 1922807328 5018416 16756928
14:13:10 8905 8192000000 10799497040 11240353792 1895819248 18.793 100 22 43 1 1909343760 7492352 6032160
14:13:26 10801 8192000000 10815082304 11248312320 1901420800 18.838 100 30 60 0 1920806144 11284000 8101344
14:13:44 8239 8192000000 10823776352 11252502528 1903663968 18.856 100 35 70 2 1920375296 7293008 9418320
14:14:00 8458 8192000000 10818806832 11250159616 1904669248 18.864 100 29 57 1 1919150400 6340160 8140992
14:14:18 5134 8192000000 10815169488 11249881088 1906137280 18.876 100 34 68 0 1922383216 6323472 9922464
14:14:34 3433 8192000000 10823821168 11252633600 1906920672 18.882 100 30 60 5 1921766240 6521984 8323584
14:14:45 11722 8192000000 10830842432 11262865408 1906645808 18.880 100 21 42 2 1918916208 6068656 6201744
14:15:05 10470 8192000000 10824638064 11256430592 1907670048 18.888 100 19 38 2 1918888032 5919040 5298944
14:15:22 8911 8192000000 10817697456 11253469184 1908469440 18.894 100 21 41 2 1921250240 6349664 6431136
14:15:37 9391 8192000000 10810097056 11249897472 1892544688 18.766 99 9 18 1 1900088832 5226688 2317456
14:15:53 14875 8192000000 10820387312 11259555840 1910565760 18.911 100 17 34 1 1921620816 6178224 4876832
14:16:14 9599 8192000000 10827676608 11264724992 1911313344 18.917 100 14 28 1 1920640464 5684960 3642160
14:16:34 5558 8192000000 10828923824 11266273280 1917902720 18.970 100 23 46 0 1931212144 6974496 6334928
14:16:46 69662 8192000000 10786363600 11225239552 1844601152 18.378 96 27 54 2 1857929280 5390336 7937792
14:18:02 6876 8192000000 10804960816 11239956480 1866329600 18.555 98 34 68 1 1883620784 7378768 9912416
14:18:15 7533 8192000000 10809775040 11230236672 1868064640 18.569 99 24 48 1 1881463776 6206192 7192944
14:18:32 5622 8192000000 10788237072 11213520896 1862139056 18.521 99 33 66 1 1878034096 6691600 9203440
14:18:45 5795 8192000000 10798983264 11226873856 1883494416 18.693 100 25 50 0 1896665488 5199472 7971600
14:18:57 8398 8192000000 10772168448 11185913856 1761804128 17.699 93 26 52 1 1774223376 4852992 7566256
14:19:14 6587 8192000000 10735993136 11150868480 1779762976 17.848 97 29 58 0 1794294272 6042032 8489264
14:19:29 8693 8192000000 10720685312 11141292032 1709955808 17.268 93 23 46 3 1721820512 5764224 6100480
14:19:44 7833 8192000000 10716903840 11140165632 1775048656 17.809 98 20 40 0 1786593104 6146080 5398368
14:20:00 6629 8192000000 10695540832 11105370112 1746645680 17.574 97 31 62 1 1761679440 5710128 9323632
14:20:16 7778 8192000000 10720099008 11129950208 1790533968 17.936 99 39 78 1 1808836784 5583856 12718960
14:20:31 8345 8192000000 10710715200 11124334592 1734642096 17.474 96 18 36 3 1748777264 9472320 4662848
14:20:49 8979 8192000000 10686382016 11083423744 1710736816 17.275 96 19 37 5 1722314800 5681648 5896336
14:21:04 11060 8192000000 10684297120 11100098560 1715086912 17.311 96 13 26 0 1724192928 5643680 3462336
14:21:22 71606 8192000000 10690514704 11108593664 1699276976 17.179 95 24 48 0 1711391632 4997712 7116944
14:22:46 7941 8192000000 10697752336 11105435648 1741184304 17.528 97 21 42 1 1752616032 5514080 5917648
14:23:00 6980 8192000000 10727207392 11140513792 1803265072 18.041 100 50 101 0 1825498848 8317280 13916496
14:23:14 8244 8192000000 10717966160 11136421888 1793605264 17.961 99 32 64 3 1808982768 6273280 9104224
14:23:30 4863 8192000000 10727739152 11145986048 1800795088 18.020 99 39 77 1 1818218016 5912256 11510672
14:23:42 5359 8192000000 10736245360 11157991424 1819435440 18.173 100 29 59 0 1837460144 9443648 8581056
14:23:54 6037 8192000000 10720904960 11132280832 1784226128 17.884 98 27 54 2 1797737696 5685392 7826176
14:24:08 8114 8192000000 10744857664 11165351936 1829738832 18.257 100 33 66 0 1845018272 5425680 9853760
14:24:22 5409 8192000000 10743609552 11165884416 1831253264 18.270 100 27 55 2 1845223968 4833008 9137696
14:24:34 7656 8192000000 10761140656 11178541056 1842746784 18.363 100 32 65 3 1858540848 6048848 9745216
14:24:48 7829 8192000000 10764950528 11182460928 1842826640 18.364 100 35 70 0 1858972064 5096256 11049168
14:25:03 9317 8192000000 10757105296 11181809664 1840316960 18.343 100 26 52 0 1853462608 5678608 7467040
14:25:19 8274 8192000000 10753385120 11182981120 1842405136 18.360 100 15 30 2 1851954336 5060928 4488272
14:25:34 6640 8192000000 10758629168 11189985280 1845774000 18.388 100 25 50 4 1863579088 10173904 7631184
14:25:47 10839 8192000000 10760666544 11188555776 1849100528 18.415 100 18 36 2 1859382688 4925904 5356256
14:26:04 13821 8192000000 10767459088 11195293696 1852025232 18.439 100 17 34 2 1863048304 5114400 5908672
14:26:27 40101 8192000000 10791783280 11197665280 1858286176 18.489 100 21 40 2 1868434560 4515248 5633136
14:27:14 85666 8192000000 10822294880 11240513536 1890564752 18.750 100 48 96 2 1911004768 6868240 13571776
14:28:47 15147 8192000000 10837447792 11254697984 1907482368 18.886 100 46 93 1 1929319328 8914400 12922560
14:29:12 11321 8192000000 10844977696 11266301952 1918459648 18.974 100 51 97 1 1940446800 8960256 13026896
14:29:30 2570 8192000000 10860434192 11274776576 1928393136 19.054 100 67 135 1 1956251264 9226144 18631984
14:29:40 23610 8192000000 10881059136 11295612928 1932278512 19.085 100 55 110 1 1963453712 15300112 15875088
14:30:14 17144 8192000000 10874592656 11294715904 1939509120 19.143 100 59 118 0 1970216832 14616672 16091040
14:30:43 31428 8192000000 10874096896 11304493056 1940720496 19.153 100 53 104 3 1970947616 15463984 14763136
14:31:24 48249 8192000000 10875510784 11308179456 1944895344 19.186 100 31 62 1 1967967280 13331952 9739984
14:32:20 43244 8192000000 10880742288 11320709120 1948716672 19.216 100 41 82 3 1976520160 15479296 12324192
14:33:11 12625 8192000000 10902310512 11332284416 1956143872 19.275 100 42 84 2 1986102128 17120512 12837744
14:33:33 24911 8192000000 10901606528 11332358144 1959411920 19.301 100 44 89 0 1991362000 18825888 13124192
14:34:04 8449 8192000000 10900880432 11337072640 1960370160 19.309 100 43 85 2 1993241872 20764912 12106800
14:34:23 15629 8192000000 10902901952 11342565376 1967647856 19.367 100 51 102 0 2003634080 20404160 15582064
14:34:51 14383 8192000000 10902795216 11344039936 1967236560 19.364 100 32 64 0 1996530848 20014256 9280032
14:35:14 14697 8192000000 10924544112 11354759168 1978781280 19.455 100 55 106 3 2012472048 18978416 14712352
14:35:37 9195 8192000000 10931139568 11362406400 1984424448 19.500 100 58 116 0 2021054704 20043584 16586672
14:35:53 5488 8192000000 10940860192 11367079936 1987195840 19.522 100 62 123 1 2026656544 21567456 17893248
14:36:07 4691 8192000000 10944083152 11368845312 1990616192 19.549 100 60 120 0 2030996336 22945616 17434528
14:36:22 3585 8192000000 10937304528 11371548672 1991538624 19.556 100 56 112 1 2030273248 21828832 16905792
14:36:39 18021 8192000000 10938987776 11379351552 1994275984 19.578 100 50 100 1 2030367744 20189376 15902384
14:37:06 5300 8192000000 10948221648 11378999296 2000051888 19.623 100 53 104 1 2036239104 20621184 15566032
14:37:19 5131 8192000000 10956422592 11370565632 1994857632 19.582 100 73 147 0 2038786240 22097872 21830736
14:37:32 5231 8192000000 10947499264 11376168960 1993651168 19.573 100 59 116 0 2033487616 22743552 17092896
14:37:45 3361 8192000000 10953414992 11376881664 1998933104 19.614 100 71 142 1 2044104576 24094064 21077408
14:37:56 4082 8192000000 10961368576 11388420096 2001044368 19.631 100 77 153 2 2052996480 29186080 22766032
14:38:08 2151 8192000000 10956463216 11374358528 1986828416 19.519 100 69 139 2 2036270448 28493408 20948624
14:38:17 2941 8192000000 10944316368 11364315136 1981107424 19.473 100 71 142 1 2031130352 28908736 21114192
14:38:29 4224 8192000000 10955063824 11372556288 1986365184 19.515 100 76 153 0 2039617088 30673184 22578720
14:38:39 9997 8192000000 10952849424 11378425856 1989180464 19.537 100 71 142 1 2041150256 30544160 21425632
14:38:58 6487 8192000000 10947752992 11375493120 1984239296 19.498 100 61 122 0 2033573200 31136000 18197904
14:39:12 7376 8192000000 10949652912 11378364416 1990104384 19.545 100 73 144 0 2045814080 33659392 22050304
14:39:29 15548 8192000000 10960972816 11393335296 1993784640 19.574 100 59 118 0 2045588496 33188832 18615024
14:39:55 3591 8192000000 10965560784 11394592768 1998914400 19.614 100 72 144 1 2054983280 33188512 22880368
14:40:05 13477 8192000000 10940025488 11372789760 1953476000 19.254 98 60 120 1 2008189840 35334272 19379568
14:40:29 3419 8192000000 10944902096 11373068288 1966453424 19.357 99 58 114 3 2021002576 35556032 18993120
14:40:40 8202 8192000000 10965276352 11381637120 1985623936 19.509 100 69 138 2 2044371248 35948672 22798640
14:40:55 1967 8192000000 10963505088 11375489024 1974114544 19.418 99 72 141 3 2031288064 35642416 21531104
14:41:05 3770 8192000000 10981745328 11396853760 1998489888 19.611 100 80 160 2 2059806960 37018736 24298336
14:41:15 2727 8192000000 10975849680 11396321280 2002982336 19.646 100 86 171 1 2061740768 33319376 25439056
14:41:27 2710 8192000000 10973570128 11397373952 2000396368 19.626 100 84 168 2 2058871200 33013584 25461248
14:41:36 3499 8192000000 10983172288 11398037504 2004844448 19.661 100 87 169 1 2062364688 31538256 25981984
14:41:46 3352 8192000000 10975607664 11396337664 2000947472 19.630 100 84 166 0 2058983824 32305120 25731232
14:41:59 4500 8192000000 10977078768 11397042176 2003790912 19.653 100 87 173 3 2062309920 32681552 25837456
14:42:12 4039 8192000000 10961547792 11385962496 1977433632 19.444 99 72 143 0 2031497392 32787872 21275888
14:42:23 6604 8192000000 10966639776 11388211200 1980236720 19.467 99 81 163 1 2032106736 27379920 24490096
14:42:37 2528 8192000000 10967455968 11392790528 2001481616 19.634 100 81 161 0 2052774608 27801920 23491072
14:42:48 4232 8192000000 10963207616 11391127552 1998911040 19.614 100 69 138 0 2049518256 29895360 20711856
14:43:00 7402 8192000000 10957346880 11381002240 1975907248 19.432 99 66 131 1 2027081440 30807424 20366768
14:43:14 2447 8192000000 10979701408 11395829760 1999183344 19.616 100 83 165 2 2058384192 33662992 25537856
14:43:24 3369 8192000000 10976409824 11396517888 1987468528 19.524 99 76 151 2 2045694208 34203168 24022512
14:43:41 4047 8192000000 10975282336 11393445888 1997033584 19.599 100 81 160 1 2058996384 35927408 26035392
14:43:52 3687 8192000000 10944854992 11361345536 1963326448 19.332 98 71 140 0 2020865056 35619360 21919248
14:44:03 5459 8192000000 10958359776 11376574464 1982276240 19.483 100 73 146 1 2041502608 35981712 23244656
14:44:16 5492 8192000000 10963844848 11387424768 1990032896 19.544 100 70 137 4 2046364096 35108272 21222928
14:44:31 1971 8192000000 10986514768 11395788800 1998474272 19.611 100 80 161 1 2060610752 37767312 24369168
14:44:40 2755 8192000000 10989530944 11407048704 2004812512 19.661 100 88 176 1 2072307008 40597040 26897456
14:44:53 2907 8192000000 11000554400 11412152320 2008699056 19.691 100 86 172 1 2074899312 39413824 26786432
14:45:05 2543 8192000000 10989336000 11407560704 2007325152 19.680 100 88 175 2 2073858128 40027984 26504992
14:45:14 1473 8192000000 10980653600 11393105920 1996474832 19.595 99 92 182 1 2062731552 38248160 28008560
14:45:22 1698 8192000000 10979154384 11387736064 1981014752 19.473 99 87 174 0 2045568576 36860560 27693264
14:45:31 2537 8192000000 10971649376 11379011584 1970051728 19.386 99 91 181 0 2036332928 38648208 27632992
14:45:40 5639 8192000000 10959798624 11372675072 1972603312 19.406 100 83 165 1 2037384672 39479472 25301888
14:45:53 5566 8192000000 10972142624 11389550592 1982145904 19.482 100 77 154 1 2047884736 41774576 23964256
14:46:09 866 8192000000 10970651584 11383005184 1980205616 19.466 100 83 166 2 2047849776 41874240 25769920
14:46:18 2335 8192000000 10963290320 11384823808 1981894352 19.480 100 77 150 0 2046465552 41117760 23453440
14:46:28 3707 8192000000 10938009120 11365609472 1958699136 19.296 99 58 114 0 2015563840 39400880 17463824
14:46:38 7241 8192000000 10951589024 11389665280 1976959120 19.441 100 41 80 1 2034405872 44156272 13290480
14:46:52 6567 8192000000 10937120672 11378438144 1941920272 19.162 98 46 90 2 2000517504 44151632 14445600
14:47:12 16620 8192000000 10909965536 11354841088 1934777984 19.105 99 43 86 0 1996822496 47143552 14900960
14:47:43 15350 8192000000 10911727872 11355959296 1953323616 19.253 100 32 64 1 1999521584 35488224 10709744
14:48:09 6581 8192000000 10926658944 11365502976 1961465216 19.318 100 51 102 0 2015016832 36570976 16980640
14:48:22 6915 8192000000 10914304176 11357732864 1941113024 19.156 99 35 70 0 1988355888 35519808 11723056
14:48:40 14535 8192000000 10909970800 11360313344 1949273680 19.221 100 34 68 1 2003409456 42694208 11441568
14:49:03 4802 8192000000 10906050080 11344506880 1937465440 19.127 99 40 78 1 1983216496 33251328 12499728
14:49:17 14436 8192000000 10908304144 11361177600 1949948656 19.226 100 31 62 2 1998212256 36842832 11420768
14:49:49 9012 8192000000 10904313824 11349413888 1955414224 19.270 100 48 96 1 2003688032 33399936 14873872
14:50:05 24007 8192000000 10892481456 11345313792 1935536064 19.111 99 31 62 1 1974443040 28817264 10089712
14:50:43 20219 8192000000 10879573712 11330138112 1930958688 19.075 100 25 50 1 1968708128 29358272 8391168
14:51:10 26647 8192000000 10877184640 11335016448 1901036128 18.835 98 23 46 2 1941947072 32974432 7936512
14:51:47 23407 8192000000 10878539488 11331256320 1932541392 19.087 100 21 42 1 1965187504 25693392 6952720
14:52:17 10789 8192000000 10894819968 11337375744 1947713136 19.208 100 23 46 1 1974417648 19031952 7672560
14:52:37 15624 8192000000 10895024736 11341258752 1926246464 19.037 99 31 62 0 1959147440 22836720 10064256
14:52:59 22433 8192000000 10898502208 11353686016 1955917840 19.274 100 18 36 1 1983168224 21431024 5819360
14:53:27 87270 8192000000 10861975552 11320856576 1815908400 18.144 93 14 28 0 1845186608 24618768 4659440
14:55:01 30502 8192000000 10869441360 11317780480 1899820560 18.825 99 40 79 2 1935486704 23245712 12420432
14:56:16 84532 8192000000 10821143152 11295690752 1857755040 18.485 96 38 71 4 1881137184 12640608 10741536
14:57:47 51242 8192000000 10844626688 11287822336 1867117984 18.561 98 17 34 1 1884956480 12875104 4963392
14:58:44 52505 8192000000 10845040048 11288653824 1916441792 18.958 100 25 43 4 1929609168 8107312 5060064
14:59:44 17678 8192000000 10863201472 11300052992 1926374112 19.038 100 30 59 1 1941135744 7232320 7529312
15:00:12 45153 8192000000 10876104352 11321794560 1942319104 19.165 100 40 79 0 1960920800 7399968 11201728
15:01:40 45296 8192000000 10892273104 11342053376 1960895648 19.313 100 34 68 2 1980817712 10078960 9843104
15:02:34 47609 8192000000 10883248432 11354394624 1964177376 19.339 100 19 38 1 1980867664 11547568 5142720
15:03:28 20859 8192000000 10888595744 11355357184 1964787456 19.344 100 12 24 0 1981402016 13048432 3566128
15:04:30 36068 8192000000 10878694144 11353923584 1949397584 19.222 99 15 30 0 1965819376 11785200 4636592
15:05:34 27301 8192000000 10889600560 11354918912 1965374512 19.349 100 32 64 2 1985878720 10841600 9662608
15:06:08 66538 8192000000 10876706704 11339911168 1930977568 19.075 98 14 29 0 1946842544 11750592 4114384
15:07:30 32373 8192000000 10887634688 11370622976 1962039136 19.322 100 13 27 2 1986224672 20375840 3809696
15:08:56 40318 8192000000 10882606448 11343015936 1928962816 19.059 98 33 67 2 1946314960 6893456 10458688
15:09:51 49954 8192000000 10889036736 11351928832 1967847280 19.368 100 37 74 3 1988458352 10498768 10112304
15:11:06 74370 8192000000 10896409248 11357802496 1940082592 19.147 98 38 76 0 1964192608 13194160 10915856
15:12:30 47892 8192000000 10898738112 11353989120 1931910400 19.082 98 37 72 2 1959567904 17193120 10464384
15:13:35 96744 8192000000 10900717840 11381010432 1973127776 19.410 100 18 36 0 1998788672 20347808 5313088
15:15:18 24516 8192000000 10902503872 11383066624 1956787104 19.280 99 13 26 2 1984733712 22923968 5022640
15:15:54 21678 8192000000 10903552144 11385208832 1975614144 19.430 100 15 30 0 1998645840 18533904 4497792
15:16:56 47490 8192000000 10891930224 11374374912 1962552064 19.326 99 25 50 0 1986339872 16603968 7183840
15:17:49 37377 8192000000 10890087952 11386929152 1965840816 19.352 100 8 16 1 1989719664 21252032 2626816
15:18:36 120001 8192000000 10889517936 11388792832 1953608976 19.255 99 8 16 1 1974401488 18197472 2595040
15:20:47 56387 8192000000 10897813280 11361210368 1939685648 19.144 98 26 52 1 1956040336 8925840 7428848
15:21:57 53099 8192000000 10918233520 11380629504 1962079440 19.323 99 21 42 1 1980299632 12248512 5971680
15:22:56 73499 8192000000 10910357152 11383484416 1971580528 19.398 99 34 67 3 1997491200 16129616 9781056
15:24:22 40823 8192000000 10894510720 11366170624 1900454032 18.830 96 26 52 0 1918229152 10830080 6945040
15:25:10 65494 8192000000 10915139696 11379900416 1955561088 19.271 99 27 54 0 1974999440 12108912 7329440
15:26:25 54859 8192000000 10920413040 11389181952 1961995584 19.322 99 20 40 0 1980599280 13117488 5486208
15:27:27 36887 8192000000 10909615728 11387895808 1966484976 19.358 99 23 46 0 1984856608 12335680 6035952
15:28:10 25784 8192000000 10936044448 11377319936 1949808848 19.225 98 29 55 0 1968084160 10831360 7443952
15:28:43 31367 8192000000 10900292368 11354689536 1928622624 19.056 97 53 105 3 1956406304 12774064 15009616
15:29:35 91178 8192000000 10894033392 11379564544 1923343680 19.014 97 24 48 0 1951822592 21887904 6591008
15:31:12 60431 8192000000 10919527600 11365076992 1896499200 18.798 96 19 38 0 1908952048 7529072 4923776
15:32:22 73884 8192000000 10916613648 11359793152 1948463456 19.214 99 56 111 1 1976841936 13394352 14984128
15:33:49 75527 8192000000 10879011632 11347427328 1943338944 19.173 99 28 56 2 1963898016 12564352 7994720
15:35:10 36043 8192000000 10889013664 11361415168 1947134240 19.204 99 29 59 0 1969518192 13840640 8543312
15:36:00 55935 8192000000 10870063664 11347783680 1941540416 19.159 99 13 26 0 1955516096 10433136 3542544
15:37:04 46787 8192000000 10854975552 11337474048 1935505024 19.111 99 7 14 1 1949149472 11514576 2129872
15:37:58 47891 8192000000 10848197216 11323162624 1881410208 18.676 96 7 15 0 1891223648 7786576 2026864
15:38:52 67029 8192000000 10848975840 11325464576 1884549136 18.702 97 14 28 0 1896488752 7563792 4375824
15:40:07 89618 8192000000 10868214352 11346149376 1931997312 19.083 99 19 38 2 1949430368 12046784 5386272
15:41:43 71580 8192000000 10852385680 11329531904 1891743072 18.760 97 22 42 1 1913356416 14783056 6830288
15:43:02 53995 8192000000 10857887632 11340374016 1913730160 18.937 99 19 38 1 1930943168 11499072 5713936
15:44:19 77567 8192000000 10870844320 11340427264 1887930576 18.729 97 9 18 1 1907225296 16605920 2688800
15:45:49 52766 8192000000 10886696128 11326251008 1887839584 18.728 97 31 61 2 1906591328 10168432 8583312
15:46:49 41442 8192000000 10855769616 11317993472 1883186080 18.691 97 23 46 0 1901664448 12098736 6379632
15:47:37 84509 8192000000 10847079232 11314946048 1859197952 18.497 96 25 50 1 1878880864 13036192 6646720
15:49:08 133634 8192000000 10882747360 11362471936 1904306864 18.861 98 10 20 0 1929058528 21875520 2876144
15:51:27 57860 8192000000 10875479936 11342237696 1893190352 18.771 97 33 66 0 1917255056 14863024 9201680
15:52:34 25641 8192000000 10889761920 11342970880 1924576416 19.023 99 39 78 0 1948193216 13079424 10537376
15:53:06 52811 8192000000 10871260640 11336998912 1906239136 18.876 98 26 52 0 1926620320 13171008 7210176
15:54:09 65659 8192000000 10895856544 11339603968 1941288544 19.157 100 24 48 3 1960798608 11845040 7665024
15:55:25 14455 8192000000 10892657472 11335327744 1933395184 19.094 99 53 106 1 1959062256 9475728 16191344
15:55:46 34398 8192000000 10886793808 11344621568 1949206000 19.220 100 51 101 2 1976285424 13098752 13980672
15:56:28 135931 8192000000 10860068144 11324481536 1891312688 18.756 97 27 54 1 1912148784 13047968 7788128
15:59:06 64898 8192000000 10865939936 11346280448 1942118608 19.164 100 9 18 0 1956381968 11954448 2308912
16:00:33 15677 8192000000 10864785696 11349413888 1947585840 19.207 100 5 10 0 1959793200 11131680 1075680
16:00:55 17108 8192000000 10878909920 11359449088 1953125712 19.251 100 7 14 0 1966067968 11155952 1786304
16:01:18 38531 8192000000 10881946704 11362713600 1956654864 19.279 100 8 15 2 1974242192 15423248 2164080
16:02:03 36447 8192000000 10883316864 11360083968 1933005152 19.091 99 6 12 0 1945644112 11519712 1119248
16:02:50 34229 8192000000 10855997824 11320418304 1886138224 18.715 96 21 42 1 1898655248 6939584 5577440
16:03:30 67217 8192000000 10893756672 11360350208 1922791584 19.009 98 20 40 0 1938375024 10248224 5335216
16:04:47 45140 8192000000 10891396256 11363590144 1922649856 19.008 98 16 32 1 1939799296 12511344 4638096
16:06:00 72196 8192000000 10901308272 11350851584 1922690528 19.008 98 11 22 0 1940919536 15107824 3121184
16:07:23 19755 8192000000 10883629920 11343970304 1909391520 18.902 97 49 98 1 1931295008 8641312 13262176
16:08:00 28445 8192000000 10916658640 11365261312 1965165120 19.347 100 47 94 2 1988008688 9763792 13079776
16:08:39 11692 8192000000 10908162080 11362975744 1966520544 19.358 100 35 68 0 1986065232 10334720 9209968
16:08:59 42640 8192000000 10912681888 11372830720 1949866368 19.225 99 33 64 0 1968384240 9973504 8544368
16:09:48 145265 8192000000 10885028864 11361517568 1872119200 18.601 95 19 38 0 1891068864 13547344 5402320
16:12:27 69853 8192000000 10905084848 11368280064 1928739376 19.057 98 22 44 0 1945000832 10256784 6004672
16:13:47 67027 8192000000 10886292016 11353268224 1948680272 19.216 99 14 29 0 1963734560 11131968 3922320
16:15:00 80828 8192000000 10909294928 11375108096 1928431328 19.054 98 8 16 0 1942787232 12287616 2068288
16:16:27 61075 8192000000 10920471840 11391819776 1965961808 19.353 99 25 50 0 1994987408 21874752 7150848
16:18:09 71112 8192000000 10910021120 11401400320 1974939904 19.425 100 13 26 0 2000944688 22721056 3283728
16:20:06 61894 8192000000 10892300896 11372974080 1944135024 19.180 98 11 22 1 1956267168 9217360 2914784
16:21:16 22134 8192000000 10891022560 11375009792 1954330432 19.261 99 7 14 0 1967073104 11016512 1726160
16:21:45 28479 8192000000 10877280240 11356499968 1952540512 19.247 99 9 18 1 1966270064 11087472 2642080
16:23:06 36262 8192000000 10879925408 11364200448 1935993568 19.115 98 13 25 1 1948140304 8528256 3618480
16:23:49 57723 8192000000 10903756000 11371765760 1960657040 19.311 99 17 34 0 1974574000 9062576 4854384
16:24:53 38868 8192000000 10897381376 11370119168 1957695968 19.288 99 32 64 0 1981136192 14500848 8939376
16:25:58 71933 8192000000 10882192576 11365322752 1933783120 19.097 98 14 27 0 1954772448 17132096 3857232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-02-2021 16:29:04 to 26-02-2021 16:29:36.

Exceptions occured during test was in run

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

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

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          230263
MON$OLDEST_ACTIVE               230848
MON$OLDEST_SNAPSHOT             230848
MON$NEXT_TRANSACTION            230848
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                       2013632
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:330: 
:331: mscs-test-161.budzdorov.ru    Fri Feb 26 16:27:28 2021
:332:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:333: 
--- end of diff output ---

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

26.02.21 16:29:40. 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-02-26 16:29:42 No severe PSQL-related problems occured
26.02.21 16:29:44. End of report.