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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17163240 kB
MemAvailable 31423132 kB
Buffers 0 kB
Cached 14472764 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-03 22:27:23
DTS_END                         2021-04-03 22:27:23.8660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49086
TRN_ID                          244606
ATT_ID                          692
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: 9853.22 20359 1182386
customer order: creation 176.24 343 21149
customer order: refuse 15.10 349 1812
order to supplier: creation 48.76 1175 5851
order to supplier: removal 3.63 93897 436
invoice (draft): creation 47.99 3428 5759
invoice (draft): removal 57.33 736 6880
invoice accept: apply 43.36 17233 5203
invoice accept: cancel 51.59 802 6191
customer reserve: creation 4027.29 169 483275
customer reserve: removal 5068.67 53 608240
realization accept: apply 85.35 180 10242
realization accept: cancel 92.41 95 11089
payment from customer: creation 61.78 106 7413
payment from customer: removal 5.80 111 696
payment to supplier: creation 51.24 116 6149
payment to supplier: removal 3.53 108 424
service: total inventory turnovers 5.14 872 617
service: total monetary turnovers 7.08 23 850
service: aggregate perf. data 0.88 16692 106
service: refresh index statistics 0.03 270686 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-04-2021 22:28:41 to 03-04-2021 22:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5666
TEST_TIME 2 6367
TEST_TIME 3 5670
TEST_TIME 4 5067
TEST_TIME 5 5306
TEST_TIME 6 5331
TEST_TIME 7 5413
TEST_TIME 8 5488
TEST_TIME 9 5354
TEST_TIME 10 5686
TEST_TIME 11 5825
TEST_TIME 12 6148
TEST_TIME 13 6502
TEST_TIME 14 6647
TEST_TIME 15 7136
TEST_TIME 16 7314
TEST_TIME 17 7514
TEST_TIME 18 8154
TEST_TIME 19 8581
TEST_TIME 20 8687
TEST_TIME 21 9015
TEST_TIME 22 9085
TEST_TIME 23 9730
TEST_TIME 24 9641
TEST_TIME 25 9636
TEST_TIME 26 9895
TEST_TIME 27 10025
TEST_TIME 28 10885
TEST_TIME 29 10786
TEST_TIME 30 10914
TEST_TIME 31 10772
TEST_TIME 32 10750
TEST_TIME 33 10683
TEST_TIME 34 10691
TEST_TIME 35 10766
TEST_TIME 36 10627
TEST_TIME 37 10365
TEST_TIME 38 10313
TEST_TIME 39 10322
TEST_TIME 40 10250
TEST_TIME 41 10224
TEST_TIME 42 10134
TEST_TIME 43 10003
TEST_TIME 44 10294
TEST_TIME 45 10319
TEST_TIME 46 10224
TEST_TIME 47 10152
TEST_TIME 48 10057
TEST_TIME 49 9960
TEST_TIME 50 9833
TEST_TIME 51 9890
TEST_TIME 52 9834
TEST_TIME 53 9848
TEST_TIME 54 9727
TEST_TIME 55 9797
TEST_TIME 56 9723
TEST_TIME 57 9710
TEST_TIME 58 9748
TEST_TIME 59 9836
TEST_TIME 60 9911
TEST_TIME 61 9939
TEST_TIME 62 9991
TEST_TIME 63 9948
TEST_TIME 64 10064
TEST_TIME 65 10049
TEST_TIME 66 10089
TEST_TIME 67 10205
TEST_TIME 68 10125
TEST_TIME 69 10184
TEST_TIME 70 10090
TEST_TIME 71 9996
TEST_TIME 72 9970
TEST_TIME 73 9974
TEST_TIME 74 9982
TEST_TIME 75 9936
TEST_TIME 76 9876
TEST_TIME 77 9862
TEST_TIME 78 9824
TEST_TIME 79 9750
TEST_TIME 80 9744
TEST_TIME 81 9707
TEST_TIME 82 9702
TEST_TIME 83 9657
TEST_TIME 84 9699
TEST_TIME 85 9744
TEST_TIME 86 9677
TEST_TIME 87 9738
TEST_TIME 88 9752
TEST_TIME 89 9764
TEST_TIME 90 9761
TEST_TIME 91 9902
TEST_TIME 92 9868
TEST_TIME 93 9960
TEST_TIME 94 9956
TEST_TIME 95 9970
TEST_TIME 96 10001
TEST_TIME 97 9948
TEST_TIME 98 9882
TEST_TIME 99 9895
TEST_TIME 100 9875
TEST_TIME 101 9824
TEST_TIME 102 9786
TEST_TIME 103 9805
TEST_TIME 104 9792
TEST_TIME 105 9748
TEST_TIME 106 9698
TEST_TIME 107 9708
TEST_TIME 108 9734
TEST_TIME 109 9730
TEST_TIME 110 9713
TEST_TIME 111 9785
TEST_TIME 112 9764
TEST_TIME 113 9785
TEST_TIME 114 9825
TEST_TIME 115 9793
TEST_TIME 116 9816
TEST_TIME 117 9843
TEST_TIME 118 9840
TEST_TIME 119 9874
TEST_TIME 120 9860

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-04-2021 22:28:44 to 03-04-2021 22:28:48.

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 1628722 1628722 0 0.00 0 16598 6 0 0
doc_list_biud 1628722 1628722 0 0.00 0 96460 25 0 0
sp_add_invoice_to_stock 5311 5203 108 2.03 12 167680 17233 0 108
sp_cancel_adding_invoice 6191 6191 0 0.00 5 70133 803 0 0
sp_cancel_client_order 1812 1812 0 0.00 4 7693 349 0 0
sp_cancel_customer_reserve 608240 608240 0 0.00 1 53762 53 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 5378 112 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 4248 109 0 0
sp_cancel_supplier_invoice 6889 6880 9 0.13 2 96478 736 0 9
sp_cancel_supplier_order 436 436 0 0.00 10 1075646 93898 0 0
sp_cancel_write_off 11089 11089 0 0.00 1 7620 96 0 0
sp_client_order 21149 21149 0 0.00 4 23507 344 0 0
sp_customer_reserve 483275 483275 0 0.00 0 67639 169 0 0
sp_fill_shopping_cart 32739 32739 0 0.00 1 15037 35 0 0
sp_fill_shopping_cart_clo_res 483261 483261 0 0.00 0 17266 12 0 0
sp_get_clo_for_invoice 5189 5189 0 0.00 0 32781 294 0 0
sp_kill_cost_storno 18400 18400 0 0.00 0 5952 50 0 0
sp_kill_qstorno_ret_qs2qd 1234885 1234885 0 0.00 0 96451 29 0 0
sp_kill_qty_storno 650079 650079 0 0.00 0 96456 63 0 0
sp_lock_selected_doc 21359 21359 0 0.00 0 7501 6 0 0
sp_make_cost_storno 28993 28993 0 0.00 0 11097 51 0 0
sp_multiply_rows_for_pdistr 28993 28993 0 0.00 0 13836 26 0 0
sp_multiply_rows_for_qdistr 21149 21149 0 0.00 0 13651 165 0 0
sp_pay_from_customer 7413 7413 0 0.00 4 13847 107 0 0
sp_pay_to_supplier 6149 6149 0 0.00 5 15565 117 0 0
sp_payment_common 13562 13562 0 0.00 1 15457 30 0 0
sp_qd_handle_on_cancel_clo 1812 1812 0 0.00 0 7528 315 0 0
sp_qd_handle_on_invoice_upd_sts 11380 11380 0 0.00 0 29897 328 0 0
sp_qd_handle_on_reserve_upd_sts 10242 10242 0 0.00 0 17758 57 0 0
sp_reserve_write_off 10242 10242 0 0.00 5 17810 181 0 0
sp_supplier_invoice 5759 5759 0 0.00 6 87930 3429 0 0
sp_supplier_order 5851 5851 0 0.00 5 31532 1175 0 0
srv_aggregate_perf_data 106 106 0 0.00 2099 165544 16692 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1167 161684 31266 0 0
srv_find_qd_qs_mism 1132074 1132074 0 0.00 0 16594 5 0 0
srv_make_invnt_saldo 617 617 0 0.00 43 45752 873 0 0
srv_make_money_saldo 850 850 0 0.00 0 909 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 169656 322404 270687 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5203 5203 0 0.00 0 21143 163 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 6502 138 0 0
t$perf-norm:sp_cancel_client_order 1812 1812 0 0.00 0 5407 14 0 0
t$perf-norm:sp_cancel_customer_reserve 720 720 0 0.00 0 980 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 1878 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 1056 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1190 8 0 0
t$perf-norm:sp_cancel_supplier_order 436 436 0 0.00 0 20839 1495 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 5506 16 0 0
t$perf-norm:sp_client_order 21149 21149 0 0.00 0 5104 15 0 0
t$perf-norm:sp_customer_reserve 1027 1027 0 0.00 0 4258 17 0 0
t$perf-norm:sp_pay_from_customer 7413 7413 0 0.00 0 6801 11 0 0
t$perf-norm:sp_pay_to_supplier 6149 6149 0 0.00 0 7153 11 0 0
t$perf-norm:sp_reserve_write_off 10242 10242 0 0.00 0 8446 13 0 0
t$perf-norm:sp_supplier_invoice 5759 5759 0 0.00 0 4097 14 0 0
t$perf-norm:sp_supplier_order 5851 5851 0 0.00 0 6557 14 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 1468 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 4356 30 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 2620 20 0 0
t$perf-norm:srv_make_money_saldo 850 850 0 0.00 0 5389 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10590 10374 216 2.03 0 3597 15 0 216
v_all_customers 38524 38524 0 0.00 0 21 1 0 0
v_all_suppliers 32370 32370 0 0.00 0 93 1 0 0
v_all_wares 42288 42288 0 0.00 0 12 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 4618 17 0 0
v_cancel_client_order 3624 3624 0 0.00 0 2741 6 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 4482 18 0 0
v_cancel_customer_reserve 1440 1440 0 0.00 0 3153 7 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 2793 10 0 0
v_cancel_supplier_invoice 828 810 18 2.17 0 385 11 0 18
v_cancel_supplier_order 872 872 0 0.00 0 1644 6 0 0
v_cancel_write_off 2042 2042 0 0.00 0 2139 12 0 0
v_max_id_clo_ord 5850 5850 0 0.00 0 493 1 0 0
v_max_id_clo_res 1027 1027 0 0.00 0 23549 43 0 0
v_max_id_ord_sup 5745 5745 0 0.00 0 5572 3 0 0
v_max_non_paid_invoice 1559 1559 0 0.00 0 1472 4 0 0
v_max_non_paid_realizn 3968 3968 0 0.00 0 2737 4 0 0
v_min_id_clo_ord 5850 5850 0 0.00 0 4216 7 0 0
v_min_id_clo_res 1027 1027 0 0.00 0 6387 15 0 0
v_min_id_ord_sup 5745 5745 0 0.00 0 3274 3 0 0
v_min_non_paid_invoice 6149 6149 0 0.00 0 15449 22 0 0
v_min_non_paid_realizn 7413 7413 0 0.00 0 5919 18 0 0
v_our_firm 10654 10654 0 0.00 0 25 1 0 0
v_reserve_write_off 20480 20480 0 0.00 0 4333 7 0 0
x_lock_depdocs_on_canc_invoice 12666 12666 0 0.00 0 25198 111 0 0
x_lock_depdocs_on_canc_sup_ord 436 436 0 0.00 0 8166 377 0 0
x_make_qstorno_1000_1200 5851 5851 0 0.00 1 31526 1096 0 0
x_make_qstorno_1200_2000 5759 5759 0 0.00 3 87922 3306 0 0
x_make_qstorno_2100_3300 483275 483275 0 0.00 0 67638 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-04-2021 22:28:49 to 03-04-2021 22:28:53.

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
19:57:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:34 24032 8192000000 10269818192 10577825792 867484256 9.575 70 53 108 0 887686480 2351952 17850272
19:58:08 29115 8192000000 10368421360 10684506112 1406904128 14.656 100 89 178 0 1440839936 5124448 28811360
19:58:49 14758 8192000000 10378991920 10699157504 1434696624 14.903 100 90 180 0 1471470816 6682400 30091792
19:59:16 31203 8192000000 10402772656 10730979328 1456711344 15.097 100 87 174 0 1492832880 7485792 28635744
19:59:59 22928 8192000000 10429443856 10759024640 1478375984 15.287 100 88 175 1 1514836368 8367824 28092560
20:00:36 24514 8192000000 10453838656 10787590144 1500765440 15.483 100 88 176 0 1537521504 8844112 27911952
20:01:23 19160 8192000000 10485790592 10828496896 1536211968 15.791 100 82 164 0 1571850080 9692384 25945728
20:01:56 14730 8192000000 10525062240 10874605568 1567784432 16.063 100 80 160 1 1602521200 10618864 24117904
20:02:19 15972 8192000000 10564837264 10917085184 1615468496 16.471 100 89 178 1 1653376240 11212912 26694832
20:02:43 14381 8192000000 10582241168 10941345792 1634824288 16.636 100 82 164 0 1671180160 12057760 24298112
20:03:04 12086 8192000000 10594370288 10957828096 1651648592 16.778 100 84 168 2 1689515872 13022720 24844560
20:03:24 10712 8192000000 10615024272 10976968704 1664448368 16.886 100 81 162 0 1700761072 13201808 23110896
20:03:42 8951 8192000000 10630764624 10994352128 1682532800 17.039 100 86 172 1 1720879184 13465568 24880816
20:04:00 9044 8192000000 10639597008 11013070848 1703395696 17.214 100 77 154 1 1739269904 12994800 22879408
20:04:16 9871 8192000000 10652268672 11017564160 1709536128 17.265 100 76 152 0 1744865808 13786288 21543392
20:04:33 9044 8192000000 10665947232 11036917760 1724026096 17.386 100 83 165 3 1761350416 14390176 22934144
20:04:52 6861 8192000000 10683161104 11056046080 1740595984 17.524 100 83 165 3 1777049632 12741136 23712512
20:05:07 4835 8192000000 10680983552 11062202368 1750570464 17.606 100 74 146 1 1783362960 12066528 20725968
20:05:21 3647 8192000000 10705603136 11084849152 1769388240 17.762 100 86 172 1 1806097632 12431760 24277632
20:05:31 5308 8192000000 10712794848 11092344832 1773430992 17.795 100 77 154 1 1807692896 12392736 21869168
20:05:42 3613 8192000000 10722158976 11100758016 1778877600 17.840 100 79 158 0 1814287536 13514464 21895472
20:05:53 5590 8192000000 10719615888 11102715904 1785300912 17.893 100 73 143 0 1817425168 12646224 19478032
20:06:05 4044 8192000000 10727214176 11107745792 1792744592 17.954 100 93 186 0 1833346544 14589264 26012688
20:06:16 9731 8192000000 10737212112 11122118656 1798219280 17.999 100 83 164 1 1835373728 14876000 22278448
20:06:34 3313 8192000000 10749113408 11130433536 1800622384 18.019 100 80 160 1 1836705584 13924320 22158880
20:06:45 2661 8192000000 10757298080 11143868416 1814644640 18.134 100 85 168 1 1857048752 18167200 24236912
20:06:54 2058 8192000000 10760691984 11148296192 1820320368 18.180 100 85 170 2 1859040656 13319680 25400608
20:07:02 3734 8192000000 10765377360 11151638528 1825299392 18.221 100 89 176 0 1863556096 13564416 24692288
20:07:12 2777 8192000000 10778781760 11161948160 1834052192 18.292 100 86 171 2 1870725216 12061568 24611456
20:07:22 2501 8192000000 10791574768 11177426944 1845825328 18.388 100 93 185 2 1885481008 12456448 27199232
20:07:31 2077 8192000000 10785606912 11179290624 1851954224 18.438 100 85 168 0 1888403952 11856272 24593456
20:07:40 1555 8192000000 10798929616 11183976448 1856650096 18.476 100 90 180 2 1894062880 11524032 25888752
20:07:48 2251 8192000000 10798780720 11186769920 1859765936 18.501 100 85 170 1 1896502128 11320816 25415376
20:07:58 2881 8192000000 10808684512 11194720256 1860141056 18.504 100 94 186 0 1900315792 13932080 26242656
20:08:07 2029 8192000000 10808830000 11196944384 1862977216 18.527 100 93 186 3 1903633120 14485008 26170896
20:08:15 2302 8192000000 10820586976 11205644288 1869706512 18.582 100 95 191 1 1910954640 14052048 27196080
20:08:24 1611 8192000000 10822086368 11209740288 1873802208 18.615 100 90 182 0 1914013680 13722608 26488864
20:08:31 1634 8192000000 10822153776 11210063872 1877545328 18.645 100 94 190 2 1916265344 11981248 26738768
20:08:39 1934 8192000000 10810060528 11208392704 1877500320 18.645 100 86 173 2 1914205360 11792528 24912512
20:08:49 44088 8192000000 10797444368 11207499776 1874312000 18.619 100 58 117 0 1900634144 8907184 17414960
20:09:39 2352 8192000000 10835082320 11228762112 1894510128 18.782 100 84 168 1 1928831344 9927840 24393376
20:09:49 2023 8192000000 10831291968 11225944064 1892180592 18.763 100 91 182 2 1928906080 11630336 25095152
20:09:57 3970 8192000000 10825069120 11226349568 1889284768 18.740 100 68 136 2 1919494560 11158544 19051248
20:10:08 2114 8192000000 10814843984 11229188096 1888645568 18.735 100 63 126 1 1918874144 13039344 17189232
20:10:17 3259 8192000000 10810350304 11224297472 1889882672 18.745 100 48 96 0 1912740128 9296832 13560624
20:10:30 3605 8192000000 10803786640 11226599424 1888627216 18.735 100 47 94 0 1910398560 8840896 12930448
20:10:43 2755 8192000000 10807971872 11230093312 1891429680 18.757 100 49 99 0 1914633248 9440096 13763472
20:10:52 8278 8192000000 10798915216 11222990848 1887597120 18.726 100 40 80 1 1907927088 9107584 11222384
20:11:08 8235 8192000000 10803222480 11225878528 1883948320 18.697 100 22 43 3 1895573872 5713808 5911744
20:11:24 6523 8192000000 10794136288 11223789568 1887739984 18.728 100 23 46 0 1901267904 6726800 6801120
20:11:39 7362 8192000000 10795613776 11227987968 1891995088 18.762 100 24 48 2 1904631456 5807712 6828656
20:11:54 4688 8192000000 10803822912 11230212096 1895563712 18.791 100 34 68 0 1912585056 7040160 9981184
20:12:05 8208 8192000000 10794435376 11230380032 1893124240 18.771 100 22 44 0 1905368800 5864672 6379888
20:12:20 11565 8192000000 10799319488 11234086912 1895784112 18.792 100 17 33 1 1906100352 5822752 4493488
20:12:38 7957 8192000000 10812254800 11239587840 1897700544 18.808 100 28 55 2 1912375152 6893856 7780752
20:12:53 10777 8192000000 10802094528 11237019648 1897676688 18.808 100 13 26 1 1907099872 5580656 3842528
20:13:10 7915 8192000000 10814780640 11242774528 1899414448 18.822 100 21 42 0 1911415712 5550208 6451056
20:13:24 26534 8192000000 10812264864 11249537024 1903898832 18.858 100 35 69 1 1923205952 9848752 9458368
20:14:12 28423 8192000000 10846094368 11252400128 1906989856 18.882 100 62 124 2 1936170592 10900832 18279904
20:14:46 6099 8192000000 10824494592 11257421824 1904932368 18.866 100 41 82 0 1929794992 13779616 11083008
20:15:00 8727 8192000000 10821548480 11256565760 1907011280 18.883 100 36 73 0 1928230256 10916864 10302112
20:15:16 4194 8192000000 10826690160 11255386112 1906716976 18.880 100 35 70 2 1924434336 7715456 10001904
20:15:28 4004 8192000000 10819204240 11255971840 1906696624 18.880 100 38 76 3 1924697632 7051168 10949840
20:15:38 3813 8192000000 10825457408 11251281920 1904380608 18.862 100 32 64 1 1920589792 6686832 9522352
20:15:50 10233 8192000000 10818887968 11255222272 1907878496 18.890 100 29 58 0 1926334016 9438288 9017232
20:16:07 7819 8192000000 10816598528 11258249216 1910557024 18.911 100 31 62 3 1926084160 6488624 9038512
20:16:23 10334 8192000000 10823199600 11255021568 1901549040 18.839 100 19 38 2 1912861888 6151664 5161184
20:16:42 7337 8192000000 10809575456 11240022016 1881288224 18.676 99 31 62 1 1900165264 10013136 8863904
20:16:55 8526 8192000000 10799113008 11232411648 1861514160 18.516 98 25 50 1 1874475232 5748544 7212528
20:17:13 49961 8192000000 10804793760 11223969792 1817514816 18.157 96 28 57 1 1835446256 9777008 8154432
20:18:09 14946 8192000000 10780219616 11215945728 1842462512 18.361 98 16 33 1 1852319632 5162768 4694352
20:18:31 8996 8192000000 10745633584 11167973376 1739026304 17.511 93 28 57 2 1752200096 5138480 8035312
20:18:48 7676 8192000000 10711272752 11123855360 1751799840 17.617 96 31 62 1 1771189184 10938256 8451088
20:19:02 6226 8192000000 10732533392 11154456576 1816922752 18.153 100 26 51 1 1829543376 5696576 6924048
20:19:18 4748 8192000000 10747660752 11169525760 1819753696 18.176 99 36 73 2 1835658880 5841200 10063984
20:19:33 6973 8192000000 10735990768 11157315584 1795090288 17.974 98 31 60 3 1809686960 5625040 8971632
20:19:48 3876 8192000000 10731295968 11156357120 1801946848 18.030 99 36 72 1 1818748928 6604576 10197504
20:19:59 8088 8192000000 10720679616 11133005824 1739455456 17.514 96 19 38 0 1750618768 5874304 5289008
20:20:15 6770 8192000000 10708217072 11128291328 1768648736 17.756 98 23 46 1 1780167728 5130352 6388640
20:20:30 5907 8192000000 10733915328 11144273920 1771382960 17.778 97 31 61 0 1785637776 5317744 8937072
20:20:44 9183 8192000000 10703704208 11121799168 1730844016 17.443 96 27 54 2 1744661568 6214848 7602704
20:21:06 6700 8192000000 10693745184 11115917312 1768162016 17.752 99 14 27 1 1777419744 4993872 4263856
20:21:21 8329 8192000000 10687744208 11108491264 1740984080 17.527 97 29 59 1 1754552720 4898688 8669952
20:21:36 69594 8192000000 10701688576 11118739456 1724393056 17.389 95 41 81 0 1741559184 5040176 12125952
20:22:54 14689 8192000000 10714968528 11133669376 1764823712 17.724 98 22 44 1 1776254944 5725424 5705808
20:23:15 5265 8192000000 10718606928 11137433600 1790020336 17.932 99 30 60 0 1805324352 6817472 8486544
20:23:28 7013 8192000000 10718903776 11145211904 1788682816 17.921 98 28 56 0 1802623680 5507584 8433280
20:23:41 6912 8192000000 10739800864 11163017216 1825734928 18.225 100 38 76 1 1843949696 7143856 11070912
20:23:54 5305 8192000000 10757639184 11172024320 1832444224 18.279 100 30 59 3 1847216320 6229696 8542400
20:24:06 10681 8192000000 10760784416 11178917888 1837876496 18.324 100 21 42 0 1849168640 5133264 6158880
20:24:23 8293 8192000000 10755012288 11182579712 1840116208 18.342 100 24 48 0 1852810320 5724960 6969152
20:24:37 10379 8192000000 10766457232 11193614336 1847529680 18.402 100 27 56 1 1865745488 9809088 8406720
20:24:56 7569 8192000000 10782162400 11200069632 1847753856 18.404 100 34 68 3 1867133248 9437632 9941760
20:25:10 10325 8192000000 10767767248 11193712640 1849731744 18.420 100 16 30 1 1859364336 5181872 4450720
20:25:28 8123 8192000000 10771079056 11202371584 1859678608 18.501 100 20 40 1 1871059440 5641568 5739264
20:25:42 12242 8192000000 10770048368 11204448256 1859770960 18.501 100 11 22 0 1868130144 5380176 2979008
20:26:00 18124 8192000000 10770953248 11207081984 1862623776 18.525 100 10 20 1 1871228992 5777648 2827568
20:26:30 23536 8192000000 10775077200 11213176832 1869708160 18.582 100 32 63 2 1885876976 6117888 10050928
20:26:59 72327 8192000000 10814870192 11240902656 1889727024 18.744 100 46 92 1 1913662864 10332272 13603568
20:28:19 2170 8192000000 10853827200 11264888832 1916759728 18.961 100 65 123 3 1943249840 7461680 19028432
20:28:28 21290 8192000000 10847604208 11272536064 1922287248 19.005 100 56 108 2 1947482304 9176592 16018464
20:28:57 16518 8192000000 10844125456 11276414976 1924868032 19.026 100 40 78 1 1945137280 8664576 11604672
20:29:24 36467 8192000000 10867494944 11302248448 1935237616 19.109 100 43 86 1 1960850432 13143456 12469360
20:30:16 15360 8192000000 10868859328 11300163584 1941536896 19.159 100 30 61 4 1958044592 7940368 8567328
20:30:38 17725 8192000000 10865029392 11308806144 1946063648 19.195 100 36 70 1 1965168320 8755984 10348688
20:31:03 7834 8192000000 10885427456 11317006336 1954207184 19.260 100 47 93 2 1977694048 9973040 13513824
20:31:22 18083 8192000000 10893548384 11326660608 1958797600 19.296 100 41 82 1 1984354576 13961984 11594992
20:31:50 9925 8192000000 10892556848 11328417792 1961718400 19.320 100 42 84 1 1990201360 15128736 13354224
20:32:13 2711 8192000000 10904822256 11337121792 1968223280 19.371 100 57 114 2 2000119744 15069088 16827376
20:32:29 19977 8192000000 10913879952 11346022400 1972260992 19.403 100 45 90 2 2000611216 15104880 13245344
20:32:59 19383 8192000000 10925748208 11362291712 1980462752 19.468 100 51 102 2 2013862336 17988304 15411280
20:33:28 21837 8192000000 10921375712 11357368320 1982310256 19.483 100 44 86 1 2016662016 21117168 13234592
20:34:02 11039 8192000000 10918756624 11358814208 1983409312 19.492 100 42 84 0 2015305024 19210672 12685040
20:34:28 41687 8192000000 10918114208 11365998592 1980468768 19.468 100 37 72 0 2014354976 21482752 12403456
20:35:21 17418 8192000000 10933011920 11372376064 1974079328 19.418 99 46 92 2 2011459008 22251152 15128528
20:35:55 8415 8192000000 10943720752 11387416576 1997527120 19.603 100 43 86 1 2039252400 28422624 13302656
20:36:19 11491 8192000000 10947683104 11384066048 1998820608 19.613 100 47 94 1 2035824256 22562096 14441552
20:36:41 6398 8192000000 10951408016 11391000576 2004834944 19.661 100 53 104 0 2050262512 28374448 17053120
20:36:57 16097 8192000000 10959657248 11396370432 2005729696 19.668 100 49 96 3 2047278880 26345824 15203360
20:37:27 7875 8192000000 10978618864 11410403328 2013062544 19.726 100 59 118 0 2057175152 26045264 18067344
20:37:44 4174 8192000000 10980421760 11406200832 2018241376 19.766 100 72 142 1 2064882704 25637152 21004176
20:37:55 4550 8192000000 10977601824 11405873152 2013345744 19.728 100 62 124 2 2059188128 26939952 18902432
20:38:09 6985 8192000000 10978568656 11411722240 2018344032 19.767 100 72 141 1 2067912032 27674832 21893168
20:38:23 4109 8192000000 10972982032 11405328384 2012794528 19.724 100 72 144 1 2062960192 28384096 21781568
20:38:35 8604 8192000000 10969219328 11398770688 1994695648 19.581 99 71 140 2 2045825696 29129248 22000800
20:38:52 7984 8192000000 10977853104 11402240000 2010829888 19.708 100 68 136 0 2060522736 29141440 20551408
20:39:10 6557 8192000000 10982309552 11414265856 2017115280 19.757 100 64 127 2 2066506224 30629664 18761280
20:39:32 2519 8192000000 10987214560 11411419136 2017239296 19.758 100 85 170 2 2073088096 29747200 26101600
20:39:44 6866 8192000000 10995687344 11411562496 2016365792 19.752 100 77 152 1 2069484288 30030864 23087632
20:40:09 4049 8192000000 10964714496 11396128768 2000126064 19.624 99 63 125 0 2049546864 30590496 18830304
20:40:22 3695 8192000000 10972039504 11396063232 2000918320 19.630 99 75 148 0 2053016640 29612640 22485680
20:40:33 2488 8192000000 10988833760 11407859712 2011185088 19.711 100 87 174 2 2068638272 30550480 26902704
20:40:42 4192 8192000000 10965398256 11388366848 1992645776 19.565 100 83 165 0 2048855648 30680848 25529024
20:40:54 4432 8192000000 10967205360 11396857856 2000076032 19.623 100 81 162 0 2056297584 31429488 24792064
20:41:05 3254 8192000000 10968918688 11389726720 1995790080 19.590 100 81 161 0 2052682752 31245312 25647360
20:41:17 6604 8192000000 10959937152 11392237568 1974354368 19.420 99 69 138 0 2030532816 34693168 21485280
20:41:33 5113 8192000000 10960409840 11387551744 1989275664 19.538 100 71 138 1 2044841872 34567712 20998496
20:41:46 3551 8192000000 10969318688 11394289664 1993276112 19.570 100 69 138 0 2051093296 35976336 21840848
20:41:57 1160 8192000000 10955710464 11365629952 1952357296 19.245 98 91 179 2 2014825952 35412960 27055696
20:42:05 2135 8192000000 10940921072 11363864576 1963713504 19.336 99 75 147 3 2025828080 36762144 25352432
20:42:13 4261 8192000000 10971619680 11391062016 1990269184 19.546 100 80 159 0 2051794768 36844608 24680976
20:42:25 3841 8192000000 10968558896 11394592768 1992253120 19.562 100 71 141 1 2054127424 38904320 22969984
20:42:37 2250 8192000000 10969938272 11385597952 1990379936 19.547 100 89 178 2 2053990496 36945264 26665296
20:42:46 4428 8192000000 10973596128 11393019904 1991578368 19.556 100 90 179 0 2057529440 39397920 26553152
20:42:58 4462 8192000000 10974106112 11386646528 1980570096 19.469 99 81 162 2 2041181184 36278752 24332336
20:43:10 1317 8192000000 10987444048 11402608640 1999804848 19.621 100 87 174 1 2064937648 37816784 27316016
20:43:20 1495 8192000000 10989759936 11411222528 2006711792 19.676 100 83 163 1 2069632720 38884544 24036384
20:43:28 3910 8192000000 10951237936 11369443328 1959149648 19.299 98 77 152 1 2022233392 39006704 24077040
20:43:41 6517 8192000000 10953850576 11384655872 1979626576 19.462 100 57 112 2 2036296368 38318464 18351328
20:43:56 4204 8192000000 10960905440 11390328832 1990896752 19.551 100 64 128 0 2051148848 40062688 20189408
20:44:07 3123 8192000000 10993572608 11411533824 2004841792 19.661 100 83 166 2 2071701264 41014816 25844656
20:44:18 3334 8192000000 10973424416 11391967232 1987767168 19.526 100 73 146 0 2053289552 43100192 22422192
20:44:28 5386 8192000000 10973932864 11399868416 1994321504 19.578 100 77 154 0 2064012560 45146000 24545056
20:44:40 6966 8192000000 10975013872 11404304384 1995620480 19.588 100 70 138 1 2062179424 44823584 21735360
20:44:55 3588 8192000000 10963620896 11380936704 1979874512 19.464 99 84 168 0 2046001968 40105616 26021840
20:45:05 4464 8192000000 10980678384 11398094848 1992553392 19.564 100 81 155 3 2057474304 39538336 25382576
20:45:18 3861 8192000000 10980366672 11404210176 1996450096 19.595 100 75 150 3 2059945680 40187536 23308048
20:45:29 4942 8192000000 10982290496 11409174528 2000827776 19.629 100 70 139 0 2063997952 41699568 21470608
20:45:41 1896 8192000000 10987463744 11409317888 1998653136 19.612 100 79 156 0 2064812128 41958336 24200656
20:45:52 2206 8192000000 10978388080 11399774208 1991436912 19.555 100 76 150 2 2056982448 41908784 23636752
20:46:03 8224 8192000000 10951703776 11393490944 1973830320 19.416 99 46 92 2 2030786496 41263888 15692288
20:46:19 14996 8192000000 10932920368 11378233344 1950842144 19.233 98 40 80 2 2005424336 41264416 13317776
20:46:42 11822 8192000000 10938541696 11379314688 1960531504 19.310 99 35 70 1 2008030912 36297840 11201568
20:47:05 13721 8192000000 10930217872 11379699712 1953004736 19.250 99 30 60 2 2001603760 37901552 10697472
20:47:32 10904 8192000000 10923251872 11363442688 1946312608 19.197 99 39 78 1 1997975824 38387360 13275856
20:47:51 8123 8192000000 10916354592 11361710080 1941248640 19.157 99 34 68 1 1991630368 38590400 11791328
20:48:09 17074 8192000000 10918399664 11356442624 1922777936 19.009 98 31 61 1 1970568624 37284448 10506240
20:48:36 14633 8192000000 10897004896 11340632064 1893282608 18.772 97 35 71 2 1948215504 43275664 11657232
20:49:01 8164 8192000000 10895353568 11341586432 1917845216 18.970 99 39 78 3 1972375344 40529744 14000384
20:49:19 7841 8192000000 10896964880 11336896512 1919079504 18.979 99 33 64 2 1969632576 39548464 11004608
20:49:34 7463 8192000000 10885337760 11320446976 1880591552 18.670 97 36 72 0 1930380288 37582864 12205872
20:49:55 4781 8192000000 10920117568 11322658816 1907873600 18.890 99 72 141 1 1971549536 40992144 22683792
20:50:08 2159 8192000000 10921838112 11341635584 1935592880 19.112 100 75 150 1 2003488352 44216800 23678672
20:50:22 10209 8192000000 10915540976 11352346624 1941159952 19.156 100 42 82 1 1997956704 42942336 13854416
20:50:48 12864 8192000000 10855116704 11302649856 1860574608 18.508 97 27 54 0 1907040576 37460800 9005168
20:51:08 7450 8192000000 10858328544 11299115008 1886673824 18.719 99 29 56 0 1921471680 25906384 8891472
20:51:38 21889 8192000000 10860245200 11291037696 1862413536 18.523 97 37 74 0 1904077120 30250144 11413440
20:52:14 21693 8192000000 10872938256 11310641152 1889966544 18.746 99 32 64 0 1934786512 34372720 10447248
20:52:44 28250 8192000000 10870730720 11321450496 1908816608 18.897 100 22 44 0 1957450336 40645760 7987968
20:53:20 17440 8192000000 10872757312 11327332352 1913850752 18.938 100 19 38 1 1949357360 28918272 6588336
20:54:03 24013 8192000000 10872938160 11319398400 1895925920 18.794 99 21 42 0 1941582992 38135664 7521408
20:55:05 29723 8192000000 10848349696 11321176064 1878582096 18.654 98 18 36 0 1913363472 29139856 5641520
20:55:42 24618 8192000000 10849810400 11324043264 1913595936 18.936 100 12 24 2 1937045584 19914448 3535200
20:56:18 77444 8192000000 10839904528 11272970240 1878318496 18.652 98 22 44 2 1898027248 13549328 6159424
20:57:44 65146 8192000000 10855786368 11302912000 1892653456 18.767 98 23 46 0 1907055856 8268224 6134176
20:59:02 86652 8192000000 10855512896 11312873472 1894486608 18.782 98 15 30 0 1905821584 7400576 3934400
21:00:35 46845 8192000000 10867961696 11321200640 1908944336 18.898 98 10 20 0 1919310240 8205088 2160816
21:01:29 119943 8192000000 10887054736 11329650688 1908076736 18.891 98 14 28 1 1921518544 9275408 4166400
21:03:39 114642 8192000000 10904102064 11361050624 1968801888 19.376 100 30 58 2 1988364832 10719392 8843552
21:05:47 21863 8192000000 10925005696 11365634048 1976141280 19.434 100 54 108 3 2002960864 11601040 15218544
21:06:18 41664 8192000000 10910825504 11368058880 1980745648 19.471 100 41 82 0 2003682464 11263600 11673216
21:07:58 14154 8192000000 10908784368 11369254912 1974399648 19.420 100 26 52 0 1992465888 10503248 7562992
21:08:19 22497 8192000000 10901713696 11360813056 1973126640 19.410 100 20 40 0 1988752016 9990960 5634416
21:09:01 35404 8192000000 10940380368 11385475072 1985485248 19.508 100 21 42 1 2002821056 11207520 6128288
21:09:44 38571 8192000000 10949994240 11401990144 1997860448 19.606 100 30 61 0 2022181168 15405456 8915264
21:10:42 55487 8192000000 10919442224 11407757312 1987713616 19.526 100 17 34 1 2013473536 20295984 5463936
21:11:52 28673 8192000000 10907740832 11406299136 1959723040 19.304 99 9 18 0 1982368064 19881200 2763824
21:12:31 12331 8192000000 10898736304 11395887104 1979438288 19.460 100 7 14 0 1995934704 15077344 1419072
21:13:00 6246 8192000000 10904330368 11384868864 1981820496 19.479 100 7 14 1 1994040736 10855376 1364864
21:13:13 23087 8192000000 10897827216 11367211008 1962885312 19.329 99 13 26 1 1975986224 9003248 4097664
21:13:42 34843 8192000000 10886392720 11362467840 1954750944 19.264 99 8 16 0 1963463808 6269408 2443456
21:14:30 96880 8192000000 10908753248 11378159616 1965918256 19.353 99 22 43 0 1985551360 13464720 6168384
21:16:15 68835 8192000000 10924978032 11402178560 1987729520 19.526 100 20 40 0 2019333744 26172576 5431648
21:17:32 92857 8192000000 10898142864 11371286528 1946417024 19.198 98 16 32 2 1971838384 20436592 4984768
21:19:22 33315 8192000000 10929968592 11390873600 1986297712 19.515 100 23 46 2 2002977936 10204032 6476192
21:20:08 53611 8192000000 10861778912 11342454784 1929521040 19.063 97 29 58 2 1950714496 12703344 8490112
21:21:08 48177 8192000000 10866941056 11337932800 1924459776 19.023 98 10 20 0 1936578832 9124080 2994976
21:22:16 50945 8192000000 10857703856 11352199168 1918977200 18.979 98 11 22 1 1934249280 11617248 3654832
21:23:45 47318 8192000000 10869309840 11345231872 1922804864 19.009 97 20 39 1 1939923792 11015152 6103776
21:24:39 51428 8192000000 10912435488 11373379584 1947320448 19.205 99 18 36 0 1964385280 11267120 5797712
21:25:42 42237 8192000000 10896585280 11369529344 1920959312 18.995 97 24 48 0 1939967712 11800080 7208320
21:27:07 97326 8192000000 10857935728 11329196032 1828553568 18.248 93 12 24 0 1850265312 18083136 3628608
21:28:53 88049 8192000000 10850588064 11298623488 1775694496 17.814 91 24 47 3 1794088576 12480992 5913088
21:30:29 39963 8192000000 10859109728 11325153280 1883276960 18.692 97 20 40 0 1901507248 12958240 5272048
21:31:15 54762 8192000000 10857603536 11332308992 1863990800 18.536 96 13 26 2 1883316112 15812656 3512656
21:32:16 65743 8192000000 10859118512 11313451008 1812735184 18.118 94 13 26 1 1832398880 15848656 3815040
21:33:28 62356 8192000000 10825903888 11307167744 1821028096 18.186 95 8 16 0 1840886560 17528400 2330064
21:34:42 49993 8192000000 10858030480 11282706432 1818961952 18.169 95 37 74 0 1840957712 11518080 10477680
21:35:40 30033 8192000000 10860898128 11304804352 1870413328 18.588 98 42 84 0 1892231040 10269728 11547984
21:36:18 31147 8192000000 10864847312 11321204736 1915497744 18.951 100 33 66 3 1937562192 12249712 9814736
21:36:58 104344 8192000000 10883918256 11335270400 1913864512 18.938 99 45 90 0 1938530192 11512992 13152688
21:39:39 35676 8192000000 10837648368 11316539392 1899247664 18.820 99 8 16 1 1918717936 16997376 2472896
21:40:22 9612 8192000000 10820574672 11298336768 1897025680 18.802 99 8 13 1 1913350352 14586672 1738000
21:40:38 25728 8192000000 10846352864 11319767040 1917503808 18.967 100 37 74 2 1941667120 13260016 10903296
21:41:13 40868 8192000000 10810700096 11290652672 1894189424 18.780 99 7 10 2 1904384176 8747312 1447440
21:42:00 42661 8192000000 10829488832 11301904384 1897340912 18.805 99 19 38 2 1910915120 8208832 5365376
21:42:49 52196 8192000000 10834295344 11308703744 1880082544 18.666 98 6 12 1 1889040528 7431696 1526288
21:43:48 48251 8192000000 10845914480 11312549888 1909840320 18.905 99 14 28 0 1921375568 7126560 4408688
21:45:20 53735 8192000000 10857673264 11323949056 1930107200 19.068 100 12 24 1 1946568096 12897504 3563392
21:46:20 84168 8192000000 10852452240 11331043328 1893132832 18.771 98 15 30 1 1912561280 14945040 4483408
21:47:56 23628 8192000000 10848849712 11322634240 1922399408 19.006 100 14 28 1 1943353232 17213648 3740176
21:49:56 80715 8192000000 10872622944 11344949248 1908916256 18.898 98 16 32 1 1923010768 9066784 5027728
21:51:26 102385 8192000000 10881083280 11356991488 1949552160 19.223 100 15 30 0 1969209376 14978992 4678224
21:53:49 66847 8192000000 10894853952 11371151360 1969862640 19.384 100 23 45 3 1990137152 13522464 6752048
21:55:02 49407 8192000000 10889242960 11365576704 1931701072 19.080 98 19 38 0 1946603264 9678224 5223968
21:56:10 40004 8192000000 10901495744 11368378368 1935173664 19.108 98 38 75 2 1958381152 12914384 10293104
21:57:03 50765 8192000000 10917760624 11388694528 1972177936 19.403 100 24 48 2 1999089488 20246720 6664832
21:58:44 84769 8192000000 10921593840 11389374464 1946020512 19.195 98 18 36 1 1970258448 18914192 5323744
22:01:08 31741 8192000000 10941201840 11401506816 1993373408 19.570 100 26 52 2 2008686256 8214032 7098816
22:01:50 34446 8192000000 10957315456 11401195520 1979776240 19.463 99 39 78 1 2002288400 11722544 10789616
22:02:32 39030 8192000000 10909343696 11383721984 1915920944 18.954 96 27 54 1 1936493888 12800736 7772208
22:03:21 50921 8192000000 10915638080 11372052480 1946692384 19.200 98 32 64 0 1965001408 9049296 9259728
22:04:21 161684 8192000000 10907723808 11384320000 1927172144 19.044 97 28 56 1 1954245056 18733440 8339472
22:07:19 40568 8192000000 10893405856 11384672256 1969444288 19.381 100 11 22 0 1989217408 16653248 3119872
22:08:07 36186 8192000000 10915016656 11387940864 1964692816 19.343 99 22 44 0 1984349888 13663984 5993088
22:08:49 102784 8192000000 10892166720 11384442880 1931817248 19.081 97 13 26 0 1948358336 12832496 3708592
22:10:38 39856 8192000000 10892861696 11372875776 1954307552 19.261 99 11 22 0 1970822192 12878192 3636448
22:11:26 84488 8192000000 10903936224 11390156800 1980812880 19.471 100 13 26 0 2002531088 17413024 4305184
22:14:26 72683 8192000000 10910015056 11387248640 1914578816 18.943 96 11 22 0 1929921712 11903792 3439104
22:16:32 63339 8192000000 10880860224 11350544384 1852260624 18.440 94 26 51 0 1871865904 12773248 6832032
22:18:05 54694 8192000000 10855840304 11327311872 1853550144 18.451 95 20 40 1 1868387904 8868592 5969168
22:19:07 55294 8192000000 10873050448 11341869056 1835045232 18.300 94 21 42 2 1854362896 13234528 6083136
22:20:08 78481 8192000000 10865771008 11345199104 1873238608 18.610 97 20 39 2 1896038464 17268256 5531600
22:21:47 43395 8192000000 10882061440 11331923968 1903342064 18.853 98 33 64 1 1921164976 9301472 8521440
22:22:40 24677 8192000000 10870421248 11316912128 1889878448 18.745 98 55 110 1 1919651264 14427520 15345296
22:23:13 32662 8192000000 10869906880 11328565248 1907814784 18.889 99 39 78 1 1932750432 14077600 10858048
22:23:52 33843 8192000000 10885095552 11345448960 1905774448 18.873 99 41 82 0 1933522528 16491968 11256112
22:24:33 65340 8192000000 10860955472 11340382208 1912395120 18.926 99 13 26 1 1933812480 17332896 4084464
22:25:45 28412 8192000000 10858938368 11317862400 1908001808 18.891 98 35 68 0 1928499488 9750656 10747024
22:26:54 44634 8192000000 9171106240 9409093632 328211216 3.852 18 2 4 0 334639728 5913424 515088

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-04-2021 22:28:55 to 03-04-2021 22:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-04-2021 22:29:27 to 03-04-2021 22:29:29.

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          244877
MON$OLDEST_ACTIVE               244878
MON$OLDEST_SNAPSHOT             244878
MON$NEXT_TRANSACTION            244878
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                       2044064
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.33435 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33435 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33435 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33435 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Sat Apr  3 22:27:45 2021
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
--- end of diff output ---

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

03.04.21 22:29:30. 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-04-03 22:29:32 No severe PSQL-related problems occured
03.04.21 22:29:33. End of report.