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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-03 16:27:10
DTS_END                         2021-01-03 16:27:10.4020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51976
TRN_ID                          240418
ATT_ID                          614
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: 9543.78 18306 1145254
customer order: creation 175.36 343 21043
customer order: refuse 14.63 323 1755
order to supplier: creation 45.29 1254 5435
order to supplier: removal 3.56 89404 427
invoice (draft): creation 47.24 3247 5669
invoice (draft): removal 53.77 725 6452
invoice accept: apply 42.21 18815 5065
invoice accept: cancel 48.31 719 5797
customer reserve: creation 3995.09 182 479411
customer reserve: removal 4820.92 51 578510
realization accept: apply 85.47 155 10256
realization accept: cancel 80.76 111 9691
payment from customer: creation 59.28 106 7114
payment from customer: removal 5.88 76 706
payment to supplier: creation 49.73 107 5968
payment to supplier: removal 3.59 76 431
service: total inventory turnovers 4.72 999 567
service: total monetary turnovers 7.13 20 856
service: aggregate perf. data 0.81 22849 97
service: refresh index statistics 0.03 226561 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2768
TEST_TIME 2 3682
TEST_TIME 3 4974
TEST_TIME 4 5311
TEST_TIME 5 5332
TEST_TIME 6 5446
TEST_TIME 7 5483
TEST_TIME 8 5521
TEST_TIME 9 5931
TEST_TIME 10 5796
TEST_TIME 11 6025
TEST_TIME 12 6291
TEST_TIME 13 6419
TEST_TIME 14 6607
TEST_TIME 15 6925
TEST_TIME 16 7369
TEST_TIME 17 7321
TEST_TIME 18 7672
TEST_TIME 19 7939
TEST_TIME 20 8177
TEST_TIME 21 8662
TEST_TIME 22 9360
TEST_TIME 23 9678
TEST_TIME 24 10442
TEST_TIME 25 10540
TEST_TIME 26 10314
TEST_TIME 27 10281
TEST_TIME 28 10162
TEST_TIME 29 10734
TEST_TIME 30 10511
TEST_TIME 31 10557
TEST_TIME 32 10507
TEST_TIME 33 10451
TEST_TIME 34 10317
TEST_TIME 35 10526
TEST_TIME 36 10438
TEST_TIME 37 10362
TEST_TIME 38 10452
TEST_TIME 39 10453
TEST_TIME 40 10466
TEST_TIME 41 10396
TEST_TIME 42 10356
TEST_TIME 43 10144
TEST_TIME 44 10122
TEST_TIME 45 10110
TEST_TIME 46 9993
TEST_TIME 47 9928
TEST_TIME 48 9951
TEST_TIME 49 9971
TEST_TIME 50 9905
TEST_TIME 51 9959
TEST_TIME 52 9889
TEST_TIME 53 9861
TEST_TIME 54 9717
TEST_TIME 55 9707
TEST_TIME 56 9751
TEST_TIME 57 9788
TEST_TIME 58 9770
TEST_TIME 59 9785
TEST_TIME 60 9982
TEST_TIME 61 9907
TEST_TIME 62 9976
TEST_TIME 63 9994
TEST_TIME 64 9980
TEST_TIME 65 10038
TEST_TIME 66 9987
TEST_TIME 67 10008
TEST_TIME 68 10034
TEST_TIME 69 10044
TEST_TIME 70 10055
TEST_TIME 71 10006
TEST_TIME 72 9897
TEST_TIME 73 9890
TEST_TIME 74 9876
TEST_TIME 75 9833
TEST_TIME 76 9855
TEST_TIME 77 9828
TEST_TIME 78 9781
TEST_TIME 79 9808
TEST_TIME 80 9740
TEST_TIME 81 9683
TEST_TIME 82 9628
TEST_TIME 83 9697
TEST_TIME 84 9650
TEST_TIME 85 9701
TEST_TIME 86 9729
TEST_TIME 87 9695
TEST_TIME 88 9689
TEST_TIME 89 9721
TEST_TIME 90 9742
TEST_TIME 91 9791
TEST_TIME 92 9809
TEST_TIME 93 9891
TEST_TIME 94 9884
TEST_TIME 95 9869
TEST_TIME 96 9849
TEST_TIME 97 9766
TEST_TIME 98 9748
TEST_TIME 99 9731
TEST_TIME 100 9736
TEST_TIME 101 9727
TEST_TIME 102 9688
TEST_TIME 103 9663
TEST_TIME 104 9659
TEST_TIME 105 9600
TEST_TIME 106 9566
TEST_TIME 107 9524
TEST_TIME 108 9515
TEST_TIME 109 9514
TEST_TIME 110 9528
TEST_TIME 111 9527
TEST_TIME 112 9542
TEST_TIME 113 9565
TEST_TIME 114 9586
TEST_TIME 115 9620
TEST_TIME 116 9606
TEST_TIME 117 9624
TEST_TIME 118 9621
TEST_TIME 119 9612
TEST_TIME 120 9544

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1586999 1586999 0 0.00 0 22971 6 0 0
doc_list_biud 1586999 1586999 0 0.00 0 60387 24 0 0
sp_add_invoice_to_stock 5175 5065 110 2.12 51 181069 18815 0 110
sp_cancel_adding_invoice 5797 5797 0 0.00 5 67657 719 0 0
sp_cancel_client_order 1755 1755 0 0.00 3 8656 323 0 0
sp_cancel_customer_reserve 578510 578510 0 0.00 1 21420 51 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 3 7361 77 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 3929 76 0 0
sp_cancel_supplier_invoice 6455 6452 3 0.04 2 60392 725 0 3
sp_cancel_supplier_order 427 427 0 0.00 9 1028413 89405 0 0
sp_cancel_write_off 9691 9691 0 0.00 1 16964 111 0 0
sp_client_order 21043 21043 0 0.00 3 26627 343 0 0
sp_customer_reserve 479411 479411 0 0.00 0 87968 183 0 0
sp_fill_shopping_cart 32132 32132 0 0.00 1 22058 36 0 0
sp_fill_shopping_cart_clo_res 479408 479408 0 0.00 0 20648 14 0 0
sp_get_clo_for_invoice 5061 5061 0 0.00 0 20749 282 0 0
sp_kill_cost_storno 16625 16625 0 0.00 0 19684 53 0 0
sp_kill_qstorno_ret_qs2qd 1173590 1173590 0 0.00 0 60384 28 0 0
sp_kill_qty_storno 617948 617948 0 0.00 0 60385 61 0 0
sp_lock_selected_doc 21159 21159 0 0.00 0 8668 5 0 0
sp_make_cost_storno 28398 28398 0 0.00 0 19925 48 0 0
sp_multiply_rows_for_pdistr 28398 28398 0 0.00 0 6962 27 0 0
sp_multiply_rows_for_qdistr 21043 21043 0 0.00 0 9604 151 0 0
sp_pay_from_customer 7114 7114 0 0.00 4 18067 106 0 0
sp_pay_to_supplier 5968 5968 0 0.00 5 11654 108 0 0
sp_payment_common 13082 13082 0 0.00 1 18059 26 0 0
sp_qd_handle_on_cancel_clo 1755 1755 0 0.00 0 8418 295 0 0
sp_qd_handle_on_invoice_upd_sts 10857 10857 0 0.00 0 26798 311 0 0
sp_qd_handle_on_reserve_upd_sts 10256 10256 0 0.00 0 11523 47 0 0
sp_reserve_write_off 10256 10256 0 0.00 6 20085 156 0 0
sp_supplier_invoice 5669 5669 0 0.00 6 107728 3248 0 0
sp_supplier_order 5435 5435 0 0.00 6 22195 1254 0 0
srv_aggregate_perf_data 97 97 0 0.00 2588 274882 22849 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1392 160839 34765 0 0
srv_find_qd_qs_mism 1095371 1095371 0 0.00 0 22971 5 0 0
srv_make_invnt_saldo 567 567 0 0.00 25 42316 999 0 0
srv_make_money_saldo 856 856 0 0.00 1 1906 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 136463 271076 226561 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5065 5065 0 0.00 0 9126 144 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 3655 94 0 0
t$perf-norm:sp_cancel_client_order 1755 1755 0 0.00 0 3398 11 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 2292 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 2240 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 1701 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 1812 21 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 34084 1616 0 0
t$perf-norm:sp_cancel_write_off 1012 1012 0 0.00 0 6561 12 0 0
t$perf-norm:sp_client_order 21043 21043 0 0.00 0 6660 16 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 3301 6 0 0
t$perf-norm:sp_pay_from_customer 7114 7114 0 0.00 0 19014 14 0 0
t$perf-norm:sp_pay_to_supplier 5968 5968 0 0.00 0 6483 9 0 0
t$perf-norm:sp_reserve_write_off 10256 10256 0 0.00 0 18698 11 0 0
t$perf-norm:sp_supplier_invoice 5669 5669 0 0.00 0 18648 21 0 0
t$perf-norm:sp_supplier_order 5435 5435 0 0.00 0 4268 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 157 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 3725 27 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 1042 17 0 0
t$perf-norm:srv_make_money_saldo 856 856 0 0.00 0 1742 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10340 10120 220 2.12 0 6101 18 0 220
v_all_customers 38164 38164 0 0.00 0 15 1 0 0
v_all_suppliers 30812 30812 0 0.00 0 17 1 0 0
v_all_wares 42086 42086 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 971 9 0 0
v_cancel_client_order 3510 3510 0 0.00 0 1654 4 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 3591 9 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 2344 4 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 3921 12 0 0
v_cancel_supplier_invoice 772 766 6 0.77 0 8100 26 0 6
v_cancel_supplier_order 854 854 0 0.00 0 956 4 0 0
v_cancel_write_off 2024 2024 0 0.00 0 5398 16 0 0
v_max_id_clo_ord 5435 5435 0 0.00 0 3044 3 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 4018 18 0 0
v_max_id_ord_sup 5654 5654 0 0.00 0 5890 3 0 0
v_max_non_paid_invoice 1651 1651 0 0.00 0 5078 5 0 0
v_max_non_paid_realizn 3839 3839 0 0.00 0 1785 3 0 0
v_min_id_clo_ord 5435 5435 0 0.00 0 1792 4 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 3891 7 0 0
v_min_id_ord_sup 5654 5654 0 0.00 0 7699 6 0 0
v_min_non_paid_invoice 5968 5968 0 0.00 0 5691 11 0 0
v_min_non_paid_realizn 7114 7114 0 0.00 0 18056 23 0 0
v_our_firm 10472 10472 0 0.00 0 18 1 0 0
v_reserve_write_off 20512 20512 0 0.00 0 5827 6 0 0
x_lock_depdocs_on_canc_invoice 11866 11866 0 0.00 0 22567 112 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 8643 280 0 0
x_make_qstorno_1000_1200 5435 5435 0 0.00 2 20636 1183 0 0
x_make_qstorno_1200_2000 5669 5669 0 0.00 3 107716 3107 0 0
x_make_qstorno_2100_3300 479411 479411 0 0.00 0 87955 166 0 0

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

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 13278 8192000000 10219068784 10530881536 872716608 9.627 69 54 108 0 893891008 2635248 18539152
13:57:43 40306 8192000000 10364990464 10682056704 1401037696 14.604 100 88 175 1 1434446144 5180000 28228448
13:58:38 12454 8192000000 10392275584 10717184000 1450319600 15.041 100 89 177 1 1486258144 6946368 28992176
13:59:09 15470 8192000000 10422031120 10753970176 1480240432 15.304 100 86 172 0 1515753360 8045056 27467872
13:59:39 24471 8192000000 10441325072 10774769664 1493530688 15.420 100 92 184 1 1531407744 8644224 29232832
14:00:13 4884 8192000000 10455134112 10789298176 1510234560 15.565 100 92 184 2 1548630864 8954064 29442240
14:00:32 14056 8192000000 10471312688 10807369728 1520268352 15.653 100 91 182 0 1558307360 9476928 28562080
14:00:54 21103 8192000000 10483307856 10826547200 1537216688 15.800 100 91 182 0 1575994928 10298112 28480128
14:01:24 12645 8192000000 10501897072 10848632832 1556544400 15.966 100 80 160 2 1591510000 10262320 24703280
14:01:48 19337 8192000000 10537916960 10892619776 1588886160 16.244 100 81 162 2 1624429712 10722000 24821552
14:02:16 11410 8192000000 10562090512 10919092224 1617710448 16.490 100 83 165 1 1653919728 11502080 24707200
14:02:38 11415 8192000000 10589328560 10951630848 1646381904 16.734 100 82 164 0 1682692688 11921136 24389648
14:02:58 14438 8192000000 10607921856 10973028352 1665592048 16.896 100 86 172 2 1703711744 12558416 25561280
14:03:21 8660 8192000000 10621811472 10992992256 1678287168 17.003 100 76 152 1 1713087184 12015312 22784704
14:03:37 8311 8192000000 10644631056 11010347008 1697479968 17.164 100 78 156 0 1732529936 11965888 23084080
14:03:53 5670 8192000000 10652783296 11025510400 1708855696 17.259 100 72 144 2 1742199232 12231984 21111552
14:04:06 7913 8192000000 10668243744 11043917824 1722369792 17.372 100 73 146 0 1755622848 12296288 20956768
14:04:25 6666 8192000000 10678800032 11056132096 1742463312 17.539 100 82 164 1 1777769872 11852672 23453888
14:04:38 6995 8192000000 10688831840 11066294272 1751068672 17.610 100 87 174 0 1789184864 13549632 24566560
14:04:53 4944 8192000000 10712210512 11090915328 1767134576 17.743 100 82 164 1 1803224912 13513440 22576896
14:05:05 5106 8192000000 10715874816 11096109056 1776307408 17.819 100 80 160 1 1812275056 13607504 22360144
14:05:17 5088 8192000000 10722906096 11105443840 1782192416 17.868 100 85 170 0 1820214912 14564592 23457904
14:05:29 3658 8192000000 10740044656 11118268416 1794786832 17.971 100 90 181 4 1834843040 14923776 25132432
14:05:39 3903 8192000000 10742920960 11122765824 1803315472 18.041 100 87 177 0 1840449360 13434336 23699552
14:05:49 4162 8192000000 10746518912 11130937344 1804187888 18.048 100 83 166 0 1841681328 14208736 23284704
14:06:01 8455 8192000000 10749033104 11140440064 1815341152 18.140 100 84 168 0 1851947184 13421856 23184176
14:06:18 3203 8192000000 10752545952 11143647232 1817889264 18.160 100 87 172 1 1855720672 13781088 24050320
14:06:29 1160 8192000000 10773053536 11157893120 1823075472 18.203 100 93 187 2 1862407136 13125392 26206272
14:06:37 3060 8192000000 10778802880 11165990912 1835323488 18.303 100 89 176 1 1873759456 14050944 24385024
14:06:47 2767 8192000000 10778602896 11169607680 1837662880 18.322 100 89 175 2 1875182080 13293472 24225728
14:06:56 2225 8192000000 10784984704 11175628800 1845059680 18.382 100 91 182 0 1884518944 13671872 25787392
14:07:05 2829 8192000000 10789870736 11179933696 1850300400 18.425 100 89 178 0 1888395216 12998592 25096224
14:07:14 1652 8192000000 10793264912 11181395968 1857486224 18.483 100 88 176 2 1895943184 13761616 24695344
14:07:22 2308 8192000000 10807520000 11193982976 1862029488 18.520 100 95 190 2 1902577168 14132384 26415296
14:07:31 1526 8192000000 10806265072 11199459328 1865710992 18.550 100 91 181 0 1905550048 15013568 24825488
14:07:39 1804 8192000000 10810074544 11199574016 1865672064 18.549 100 92 184 0 1906260752 14284864 26303824
14:07:48 1788 8192000000 10816209968 11204677632 1866832208 18.559 100 92 185 1 1906858368 14129296 25896864
14:07:56 1169 8192000000 10817832576 11206479872 1868857344 18.575 100 93 186 0 1908783104 12907280 27018480
14:08:04 2139 8192000000 10807888048 11204141056 1870098896 18.585 100 89 178 1 1907637536 12679776 24858864
14:08:12 1890 8192000000 10811237248 11204685824 1876274352 18.635 100 89 179 0 1914644336 13343088 25026896
14:08:20 1919 8192000000 10812560032 11208929280 1870542240 18.589 100 80 160 0 1906580528 13996880 22041408
14:08:29 35973 8192000000 10806259440 11211403264 1875019632 18.625 100 67 134 1 1902836240 9055088 18761520
14:09:11 1540 8192000000 10827802800 11220258816 1880310096 18.668 100 85 173 1 1914181008 9298992 24571920
14:09:19 9675 8192000000 10819573792 11214102528 1879075696 18.658 100 72 145 4 1909322704 9247856 20999152
14:09:35 2911 8192000000 10801753584 11217104896 1876428192 18.636 100 52 101 1 1901378176 11228656 13721328
14:09:45 5550 8192000000 10815886144 11219787776 1883502176 18.693 100 58 117 1 1909050624 8859152 16689296
14:09:56 5360 8192000000 10806211280 11215704064 1878278624 18.651 100 46 90 1 1900253968 9629936 12345408
14:10:11 5265 8192000000 10787684400 11214995456 1876408608 18.636 100 36 72 0 1895215056 9044320 9762128
14:10:22 8363 8192000000 10797806560 11217489920 1879251728 18.659 100 39 78 2 1897751936 7567120 10933088
14:10:38 4441 8192000000 10789378160 11219365888 1878439680 18.653 100 37 74 1 1896881712 8208272 10233760
14:10:50 6240 8192000000 10777586592 11215134720 1875526976 18.629 100 21 42 1 1888868512 7676368 5665168
14:11:06 7536 8192000000 10786945808 11217387520 1879853216 18.664 100 24 47 1 1892800928 6467392 6480320
14:11:20 8194 8192000000 10791035152 11220148224 1881478912 18.677 100 27 54 2 1896218048 6708304 8030832
14:11:37 5259 8192000000 10816174208 11229233152 1889788704 18.744 100 41 81 2 1908787408 6918816 12079888
14:11:50 10552 8192000000 10787776992 11223814144 1885663600 18.711 100 20 40 1 1898320368 7273968 5382800
14:12:10 6509 8192000000 10787284064 11224498176 1886058608 18.714 100 20 37 2 1897668752 5695552 5914592
14:12:23 3706 8192000000 10806339232 11229245440 1892859168 18.769 100 42 87 1 1911186640 5034288 13293184
14:12:34 57826 8192000000 10818017680 11241562112 1893382448 18.773 100 44 88 2 1912488528 5699104 13406976
14:13:42 9283 8192000000 10804770032 11236282368 1893356640 18.773 100 39 79 2 1910536176 6149328 11030208
14:13:59 9396 8192000000 10821259376 11246837760 1895572304 18.791 100 26 51 2 1908324864 5656976 7095584
14:14:17 7848 8192000000 10821420048 11250298880 1898011200 18.810 100 34 68 0 1914588400 7105312 9471888
14:14:35 3837 8192000000 10817014032 11248545792 1898621056 18.815 100 38 77 1 1916326848 6808336 10897456
14:14:45 4919 8192000000 10813230976 11245760512 1896258672 18.796 100 25 51 1 1909719808 6041168 7419968
14:14:59 6350 8192000000 10807496240 11244867584 1897093536 18.803 100 28 56 0 1911443344 6082416 8267392
14:15:12 3972 8192000000 10809680192 11245711360 1883260576 18.691 99 28 56 1 1901668880 10456256 7952048
14:15:22 6502 8192000000 10805109392 11236671488 1877405504 18.644 99 21 42 1 1889400080 5937472 6057104
14:15:34 8071 8192000000 10810656592 11242577920 1877269408 18.643 99 17 34 0 1888974816 6389520 5315888
14:15:55 6997 8192000000 10806856208 11229868032 1864354496 18.539 99 22 44 1 1876686144 5307360 7024288
14:16:08 13951 8192000000 10806767952 11242692608 1888096096 18.730 100 18 36 3 1898556176 5263792 5196288
14:16:32 6913 8192000000 10792537216 11227914240 1866654064 18.557 99 14 28 2 1876138112 5530128 3953920
14:16:48 12009 8192000000 10795860864 11228733440 1867482384 18.564 99 21 42 3 1879839760 5751360 6606016
14:17:09 72460 8192000000 10819784800 11242573824 1860832864 18.510 98 34 67 2 1877246448 5476336 10937248
14:18:28 3921 8192000000 10772192992 11203014656 1836456464 18.312 98 36 68 2 1854019808 8128640 9434704
14:18:38 4287 8192000000 10775789040 11209953280 1855494448 18.467 99 38 77 2 1872875360 6160352 11220560
14:18:49 5383 8192000000 10789143616 11215282176 1857419872 18.482 99 31 61 0 1872607280 6331632 8855776
14:19:04 7424 8192000000 10757295952 11175624704 1776987616 17.825 95 31 62 2 1791370112 5563648 8818848
14:19:18 6430 8192000000 10722396336 11143700480 1745217648 17.562 95 28 56 1 1759018544 4891072 8909824
14:19:32 6796 8192000000 10720169648 11138158592 1760771872 17.691 97 18 35 2 1771235216 5626816 4836528
14:19:46 10288 8192000000 10699363168 11106951168 1668150016 16.918 93 16 32 1 1678215008 4848976 5216016
14:20:03 6533 8192000000 10665558752 11081457664 1729359088 17.430 97 31 62 2 1743881552 5656352 8866112
14:20:21 6532 8192000000 10675386464 11096743936 1731155504 17.445 97 25 50 2 1744545728 5862672 7527552
14:20:33 8258 8192000000 10698116128 11113398272 1773338816 17.795 99 22 44 3 1785923920 5773856 6811248
14:20:48 8755 8192000000 10707997984 11119915008 1739857568 17.517 97 18 37 0 1750798592 5943968 4997056
14:21:05 6927 8192000000 10693173536 11104706560 1734003712 17.469 97 19 37 2 1745023840 5045616 5974512
14:21:19 11971 8192000000 10708381776 11125616640 1766766352 17.740 98 21 41 0 1778219936 5314144 6139440
14:21:37 10850 8192000000 10740013664 11150589952 1799674208 18.011 99 30 60 1 1814409344 5299344 9435792
14:21:57 64744 8192000000 10705956144 11133702144 1800374944 18.017 99 38 76 0 1821135280 9195088 11565248
14:23:08 5640 8192000000 10714222992 11136114688 1793240016 17.958 99 25 50 1 1806074000 5359664 7474320
14:23:20 13259 8192000000 10738239888 11153440768 1780733968 17.856 98 31 61 3 1793869584 5031600 8104016
14:23:40 7122 8192000000 10753622944 11163029504 1809807216 18.094 99 24 46 2 1822613152 6002960 6802976
14:23:54 5503 8192000000 10753652272 11171950592 1840418720 18.344 100 26 52 0 1853359648 5735712 7205216
14:24:07 7128 8192000000 10763992592 11187216384 1842680976 18.363 100 18 36 4 1854122400 5591888 5849536
14:24:21 6031 8192000000 10781877968 11193860096 1852343312 18.441 100 43 84 2 1870670544 6535984 11791248
14:24:38 7899 8192000000 10769799440 11190345728 1850045904 18.422 100 18 36 2 1860480896 4957584 5477408
14:24:54 7643 8192000000 10768496704 11197407232 1857843440 18.486 100 28 56 0 1871733344 5712880 8177024
14:25:08 13290 8192000000 10782769792 11207933952 1858176288 18.488 100 18 36 0 1869249600 5025312 6048000
14:25:28 5432 8192000000 10789293184 11207712768 1862940176 18.527 100 26 53 0 1876405360 5988656 7476528
14:25:40 6606 8192000000 10794120496 11210301440 1868759632 18.574 100 29 58 0 1883667152 5142800 9764720
14:25:57 7528 8192000000 10784782688 11213160448 1867586096 18.565 100 25 49 3 1880143264 5803040 6754128
14:26:13 9320 8192000000 10780047648 11215917056 1872888832 18.608 100 23 47 2 1885532800 5540384 7103584
14:26:28 11648 8192000000 10785762272 11218923520 1875555120 18.629 100 17 34 1 1885960000 5988480 4416400
14:26:50 106184 8192000000 10834144704 11257135104 1887674224 18.727 100 32 62 1 1901663088 5147056 8841808
14:28:42 8122 8192000000 10853359440 11273773056 1917233344 18.965 100 48 96 1 1941625424 12068928 12323152
14:29:00 12107 8192000000 10855465776 11278274560 1923639072 19.016 100 50 98 0 1946566656 9504592 13422992
14:29:29 17134 8192000000 10865207392 11290820608 1933411280 19.094 100 53 105 1 1958652688 10464384 14777024
14:30:03 20906 8192000000 10872587392 11300646912 1936743328 19.121 100 58 116 1 1968522832 15763168 16016336
14:30:31 25641 8192000000 10867948240 11304390656 1942488784 19.167 100 42 84 0 1965319264 11269616 11560864
14:31:04 12596 8192000000 10878442992 11310940160 1948630912 19.216 100 41 82 1 1971606976 11072224 11903840
14:31:25 19105 8192000000 10877300416 11312119808 1954874240 19.265 100 44 87 0 1978061248 8778848 14408160
14:31:53 20387 8192000000 10887265856 11318280192 1955492912 19.270 100 38 74 0 1976076976 10051872 10532192
14:32:20 15192 8192000000 10889110736 11323789312 1961341936 19.317 100 40 80 0 1985329584 11458032 12529616
14:32:45 14748 8192000000 10896435120 11330998272 1968805840 19.376 100 46 89 4 1991305952 9501184 12998928
14:33:12 16798 8192000000 10914025584 11346853888 1961728576 19.320 99 54 106 2 1994545632 16402928 16414128
14:33:40 9098 8192000000 10917128656 11355078656 1977733568 19.447 100 44 88 3 2006625920 16385856 12506496
14:34:01 31687 8192000000 10924883248 11364491264 1985116848 19.505 100 48 96 0 2016486256 17210144 14159264
14:34:40 7932 8192000000 10945744512 11375685632 1994168192 19.577 100 51 102 1 2031956832 22667312 15121328
14:35:00 11372 8192000000 10943250096 11378814976 1997867792 19.606 100 47 93 1 2032475376 20258816 14348768
14:35:20 27521 8192000000 10946479536 11382452224 1998688848 19.612 100 48 96 0 2035951840 22942272 14320720
14:36:09 15419 8192000000 10942656128 11385339904 2000790768 19.629 100 42 85 1 2038622976 24456176 13376032
14:36:34 11333 8192000000 10934238224 11375763456 1984475392 19.500 99 39 78 0 2021556304 25519952 11560960
14:36:57 7719 8192000000 10962630096 11392499712 2008000544 19.686 100 57 114 2 2048018096 23343184 16674368
14:37:12 3981 8192000000 10971102432 11398000640 2012006480 19.717 100 62 124 1 2054243472 24177888 18059104
14:37:23 3086 8192000000 10977709104 11401572352 2018761968 19.770 100 69 139 1 2064312816 25072000 20478848
14:37:34 7952 8192000000 10983286848 11401584640 2018189552 19.766 100 70 138 3 2063331200 25421312 19720336
14:37:52 6427 8192000000 10975985904 11407036416 2019311568 19.775 100 64 127 0 2064584080 26100256 19172256
14:38:07 4249 8192000000 10981034288 11404783616 2019821376 19.779 100 84 167 1 2072824784 28093152 24910256
14:38:20 5030 8192000000 10986810320 11409649664 2018684912 19.770 100 76 152 1 2070731664 29401408 22645344
14:38:32 11799 8192000000 10970559984 11405705216 2000835344 19.629 99 65 128 0 2050500080 29532320 20132416
14:38:52 7786 8192000000 10959501072 11388841984 2000861408 19.630 99 58 116 1 2046152304 26714864 18576032
14:39:08 2216 8192000000 10985463648 11417292800 2020746976 19.786 100 68 134 0 2072403904 30833904 20823024
14:39:18 10342 8192000000 10970541392 11403079680 1999796800 19.621 99 69 136 0 2051125232 30502816 20825616
14:39:42 7443 8192000000 10973208144 11412226048 2019843376 19.779 100 55 109 2 2063711472 26329408 17538688
14:39:58 3843 8192000000 10990037104 11415449600 2024711472 19.817 100 62 121 0 2070825808 26909136 19205200
14:40:11 9223 8192000000 10969197680 11393708032 2003004656 19.646 99 69 138 3 2054197360 29332160 21860544
14:40:27 5915 8192000000 10975812048 11410997248 2016053328 19.749 100 58 117 2 2062537680 28346240 18138112
14:40:40 5237 8192000000 10977992128 11404079104 2010096304 19.702 99 64 128 2 2059462480 28656592 20709584
14:40:53 5770 8192000000 10990016704 11417059328 2019710128 19.778 100 67 133 2 2069785664 29214960 20860576
14:41:07 2577 8192000000 11015035600 11436826624 2038340176 19.924 100 83 165 1 2094339696 31011360 24988160
14:41:19 4526 8192000000 11009662416 11439804416 2038316144 19.924 100 72 143 0 2092049728 31945952 21787632
14:41:31 4941 8192000000 10996783008 11423244288 2000796784 19.629 98 75 148 1 2056424544 33019888 22607872
14:41:43 1642 8192000000 10983700160 11406450688 2010327664 19.704 99 88 178 0 2069790544 32685328 26777552
14:41:53 2885 8192000000 11004957776 11423199232 2022876768 19.803 100 91 182 0 2085106256 33831904 28397584
14:42:03 2039 8192000000 11003110016 11422998528 2026131600 19.828 100 83 166 2 2086209024 34929168 25148256
14:42:13 1735 8192000000 11007688704 11423350784 2012728912 19.723 99 90 182 6 2074539520 34812864 26997744
14:42:22 3028 8192000000 11000204528 11422851072 2024657280 19.817 100 84 167 0 2087879600 36491392 26730928
14:42:35 4164 8192000000 11005179888 11427082240 2024924784 19.819 100 81 161 0 2084309024 34422192 24962048
14:42:51 3122 8192000000 11004922000 11431993344 2028669488 19.848 100 72 144 0 2086884736 35650592 22564656
14:43:03 1513 8192000000 11020501872 11442823168 2039573264 19.934 100 83 166 1 2098990768 33914912 25502592
14:43:12 3719 8192000000 10969409360 11384815616 1990873136 19.551 98 75 145 1 2046995776 33644656 22477984
14:43:23 5827 8192000000 10990727760 11424841728 2020970432 19.788 100 62 121 1 2076511536 35441136 20099968
14:43:36 8271 8192000000 10975944896 11429011456 2020667728 19.785 100 44 87 2 2069713504 34916320 14129456
14:43:56 13488 8192000000 10992554960 11426344960 2006588000 19.675 99 59 119 1 2058891888 33553392 18750496
14:44:21 3278 8192000000 10988028672 11412258816 2008221952 19.688 100 85 171 0 2071852496 35788880 27841664
14:44:35 1488 8192000000 10983236224 11410649088 2007354272 19.681 100 64 126 2 2062965072 35363280 20247520
14:44:45 6779 8192000000 10981002544 11410255872 2001974176 19.638 100 64 127 0 2059627664 37551184 20102304
14:45:01 4287 8192000000 10977861728 11406528512 2001486656 19.634 100 77 152 1 2064607184 38965120 24155408
14:45:12 2770 8192000000 10978903104 11399499776 1990513920 19.548 99 80 159 0 2055995584 39669600 25812064
14:45:23 2917 8192000000 10990822576 11402321920 1984028032 19.497 99 89 175 2 2053116160 41539856 27548272
14:45:34 3174 8192000000 10986754832 11409747968 2002020608 19.639 100 81 161 1 2070717840 43129968 25567264
14:45:45 3223 8192000000 10981165920 11399688192 1998158784 19.608 100 85 170 2 2063168960 39132000 25878176
14:45:58 3262 8192000000 10944289712 11354353664 1960290320 19.308 99 82 162 0 2022582608 38696192 23596096
14:46:09 2078 8192000000 10975672464 11388411904 1980675312 19.470 100 87 174 1 2049003056 40275568 28052176
14:46:20 3105 8192000000 10961964240 11383705600 1976975408 19.441 100 70 140 2 2040833184 42487872 21369904
14:46:31 2841 8192000000 10977272160 11399557120 1992527136 19.564 100 80 157 2 2057507216 41734256 23245824
14:46:43 6115 8192000000 10982563936 11404120064 1994276048 19.578 100 69 138 0 2060589936 43988256 22325632
14:46:56 1391 8192000000 10960850688 11381690368 1974878432 19.424 99 83 167 1 2039906176 39560384 25467360
14:47:04 4318 8192000000 10944468208 11372847104 1969876368 19.384 100 56 112 0 2029522592 41429488 18216736
14:47:15 7072 8192000000 10933998096 11362586624 1948277456 19.213 99 50 100 0 2006117088 41346080 16493552
14:47:32 22016 8192000000 10930132784 11376705536 1969178720 19.379 100 40 80 0 2020876096 38156512 13540864
14:48:00 17502 8192000000 10944706592 11394465792 1972984352 19.409 100 27 54 0 2027202352 44566912 9651088
14:48:28 14768 8192000000 10900882240 11350183936 1910886496 18.914 97 28 56 2 1964866160 44018192 9961472
14:48:53 16620 8192000000 10925735296 11365249024 1940430304 19.150 99 42 82 4 1994176992 40341600 13405088
14:49:16 5562 8192000000 10912556672 11353923584 1944244368 19.181 100 45 88 3 2002382080 43268256 14869456
14:49:29 24179 8192000000 10905892912 11369955328 1953673104 19.256 100 37 74 0 2012936896 46345056 12918736
14:50:04 21361 8192000000 10903270400 11361398784 1946048656 19.195 100 20 40 1 1990567952 37409136 7110160
14:50:42 26097 8192000000 10893533568 11361640448 1912056640 18.923 98 23 46 1 1954925856 35057888 7811328
14:51:15 25248 8192000000 10890598064 11345985536 1942869120 19.170 100 20 40 0 1979469728 30378336 6222272
14:51:49 50136 8192000000 10868023376 11319791616 1817295344 18.156 93 13 24 2 1841434160 20447952 3690864
14:52:46 25216 8192000000 10854991440 11314917376 1887243248 18.724 98 12 23 2 1910148432 18577696 4327488
14:53:19 47629 8192000000 10875208816 11333115904 1924795616 19.025 100 15 30 0 1949843952 20069552 4978784
14:54:13 32987 8192000000 10863796928 11315748864 1896665712 18.799 98 21 40 2 1924740336 21597216 6477408
14:54:53 31146 8192000000 10852244032 11303333888 1878562384 18.653 98 11 22 0 1906798112 24633056 3602672
14:57:29 28146 8192000000 10847434608 11289751552 1893922304 18.777 99 34 69 0 1918449024 15120416 9406304
14:58:19 138060 8192000000 10871511296 11336540160 1887990112 18.730 98 20 40 2 1919188496 25396560 5801824
15:00:43 73085 8192000000 10880199632 11329949696 1906190064 18.876 98 39 78 1 1930012576 11814016 12008496
15:02:12 109810 8192000000 10891175760 11357106176 1922730288 19.009 99 6 12 0 1943160288 18645168 1784832
15:04:17 116422 8192000000 10867802176 11324203008 1872516448 18.605 96 6 12 0 1890635328 16526640 1592240
15:07:23 99974 8192000000 10880992320 11335856128 1889659584 18.743 97 19 37 3 1905197568 10549312 4988672
15:09:14 132594 8192000000 10903072464 11355021312 1938852944 19.138 99 31 62 1 1959672432 12102896 8716592
15:11:38 109677 8192000000 10888384192 11356954624 1927686336 19.048 98 23 46 3 1948752336 14760944 6305056
15:13:34 31822 8192000000 10885892656 11355410432 1953106016 19.251 100 13 26 0 1970879520 13650976 4122528
15:14:14 40906 8192000000 10918378128 11370504192 1968929760 19.377 100 48 96 2 1992970784 9720928 14320096
15:15:02 28653 8192000000 10919648496 11371905024 1969583552 19.382 100 35 69 4 1991400032 11768928 10047552
15:15:38 18573 8192000000 10919966176 11374342144 1977467936 19.445 100 54 108 0 2003569264 10339872 15761456
15:16:04 58827 8192000000 10899512800 11357122560 1915092752 18.948 97 28 56 0 1932144176 9475856 7575568
15:17:18 75953 8192000000 10913468000 11378438144 1967912176 19.369 100 15 31 2 1981556128 9000560 4643392
15:18:48 27589 8192000000 10896957312 11378192384 1973936768 19.417 100 8 16 0 1985632960 9335856 2360336
15:19:22 28539 8192000000 10904524672 11383422976 1979037792 19.457 100 12 25 1 1996186112 13250048 3898272
15:19:57 16577 8192000000 10908003360 11381178368 1977434912 19.444 100 12 24 1 1994183632 13119312 3629408
15:20:20 33229 8192000000 10885269440 11367870464 1958031264 19.290 99 9 18 0 1974314416 13182848 3100304
15:21:02 118499 8192000000 10912542096 11386490880 1980793520 19.471 100 20 41 2 1998136032 11788800 5553712
15:23:07 51853 8192000000 10886358192 11374379008 1949705056 19.224 98 16 32 0 1969480576 14768864 5006656
15:24:12 80694 8192000000 10908829536 11393634304 1952269824 19.245 99 8 16 0 1967695632 13380832 2044976
15:25:43 88159 8192000000 10919517808 11389263872 1953579808 19.255 98 20 39 2 1980380992 21813680 4987504
15:27:18 61702 8192000000 10886862976 11374759936 1912124256 18.924 97 10 20 1 1934085536 19428096 2533184
15:28:26 42095 8192000000 10897122624 11356868608 1905964352 18.874 97 14 28 2 1921901728 12049216 3888160
15:29:17 94138 8192000000 10894326240 11359408128 1864856960 18.543 95 11 22 1 1877268704 9648336 2763408
15:30:58 50552 8192000000 10884715776 11347730432 1884002784 18.697 96 18 36 3 1899919856 11208864 4708208
15:31:54 84436 8192000000 10860102400 11322732544 1844701328 18.379 95 11 22 0 1866491312 18583520 3206464
15:33:26 43634 8192000000 10890544240 11328876544 1899466112 18.822 98 46 91 0 1921378256 9728752 12183392
15:34:16 17308 8192000000 10867529520 11313606656 1895738448 18.792 98 37 74 0 1917287968 11326000 10223520
15:34:42 77599 8192000000 10873411376 11312803840 1816029696 18.145 94 22 43 0 1831897104 9766768 6100640
15:36:07 42983 8192000000 10870536960 11322875904 1922557632 19.007 100 30 60 0 1946459504 15617488 8284384
15:37:06 44162 8192000000 10838569696 11294289920 1810113552 18.097 94 28 56 1 1827966976 10457568 7395856
15:38:00 27678 8192000000 10863088864 11307220992 1911787040 18.921 100 31 62 2 1931895264 11892096 8216128
15:38:35 87678 8192000000 10854893728 11305930752 1903411120 18.854 99 42 84 2 1928768064 13648480 11708464
15:40:25 99773 8192000000 10855636048 11324907520 1887746144 18.728 98 23 46 1 1905969664 12003856 6219664
15:42:23 39265 8192000000 10860150256 11322707968 1914560400 18.943 99 13 26 0 1932352880 13881616 3910864
15:43:23 53046 8192000000 10836246928 11320004608 1888206096 18.731 98 6 12 1 1902750112 12754672 1789344
15:44:31 59579 8192000000 10850007536 11315388416 1876263760 18.635 98 14 27 1 1888671456 8309248 4098448
15:45:38 50275 8192000000 10837567936 11299561472 1873949296 18.616 97 19 39 3 1891870128 12168656 5752176
15:46:36 66069 8192000000 10843630176 11321090048 1906660160 18.880 99 11 22 1 1921858224 12356352 2841712
15:47:48 38280 8192000000 10827549440 11289812992 1862478624 18.523 97 10 20 1 1877341328 11770720 3091984
15:48:45 44538 8192000000 10840012512 11305349120 1897343264 18.805 99 13 26 0 1911578336 11149936 3085136
15:49:36 55035 8192000000 10825352784 11303337984 1881409216 18.676 98 11 22 0 1894772192 9990352 3372624
15:50:37 62369 8192000000 10863192352 11318022144 1868000512 18.568 97 24 46 0 1881030048 6786848 6242688
15:51:51 44661 8192000000 10867770384 11330863104 1915189744 18.948 99 31 62 0 1936033248 12134032 8709472
15:53:32 77040 8192000000 10833780000 11298545664 1794216800 17.966 93 18 36 1 1812181584 12302304 5662480
15:54:55 12067 8192000000 10853304304 11311063040 1918268032 18.973 100 27 54 2 1933591760 8043584 7280144
15:55:13 16680 8192000000 10869191424 11319758848 1924462112 19.023 100 36 72 1 1943800112 9132720 10205280
15:55:43 72458 8192000000 10871472176 11336167424 1913381472 18.934 99 10 20 0 1926655696 10477520 2796704
15:57:02 48201 8192000000 10882594080 11336802304 1899180320 18.820 98 20 40 0 1914775792 10124784 5470688
15:57:58 160839 8192000000 10897153760 11381870592 1897026032 18.802 97 12 24 1 1921065024 20754240 3284752
16:00:46 96049 8192000000 10907444352 11361853440 1922973664 19.011 98 14 28 0 1943180496 16250352 3956480
16:02:34 61314 8192000000 10920039392 11376304128 1972228368 19.403 100 36 72 1 1997167136 14696000 10242768
16:03:44 146138 8192000000 10909889264 11375214592 1978647904 19.454 100 40 79 0 2000024704 9701328 11675472
16:06:42 41161 8192000000 10900314976 11375222784 1972929216 19.409 100 16 32 0 1985814624 8166304 4719104
16:07:32 37852 8192000000 10871982928 11346587648 1913581680 18.935 97 25 50 0 1929147968 8660032 6906256
16:08:18 43835 8192000000 10866503200 11349098496 1935131120 19.108 99 9 18 1 1945299360 7683536 2484704
16:09:14 40828 8192000000 10893803920 11373207552 1969620304 19.382 100 16 31 0 1981557280 7418768 4518208
16:10:10 59906 8192000000 10907114880 11380523008 1983851616 19.495 100 12 24 0 1996410544 8625600 3933328
16:11:16 77471 8192000000 10896874704 11387248640 1980745920 19.471 100 11 22 3 1992963776 9067968 3149888
16:12:40 27513 8192000000 10906692576 11371659264 1966818208 19.360 99 27 53 1 1979728352 5875680 7034464
16:13:14 17133 8192000000 10904322832 11376267264 1969855056 19.384 99 53 105 1 1992956880 7938880 15162944
16:13:38 62817 8192000000 10867866368 11355291648 1930812816 19.073 98 16 32 0 1943187344 8050832 4323696
16:14:52 21646 8192000000 10880336320 11368673280 1962337792 19.325 100 5 10 1 1972199792 8233600 1628400
16:15:32 61669 8192000000 10886868176 11379097600 1948149984 19.212 99 12 24 1 1963924672 12878128 2896560
16:16:40 42371 8192000000 10880348432 11354624000 1875132512 18.626 95 18 36 0 1892370304 12116192 5121600
16:17:33 68637 8192000000 10883434288 11359690752 1917708544 18.968 98 18 36 1 1931336224 9060480 4567200
16:18:54 85014 8192000000 10899015840 11364802560 1915893968 18.954 97 26 52 2 1938155872 15107040 7154864
16:20:29 72885 8192000000 10901232176 11372060672 1909731840 18.904 97 23 46 4 1934988624 17865984 7390800
16:21:54 35080 8192000000 10891684464 11373723648 1950265264 19.229 99 20 39 2 1968103648 11928864 5909520
16:23:23 15017 8192000000 10886989440 11347058688 1922077856 19.003 98 38 76 0 1941385936 8688656 10619424
16:23:50 44287 8192000000 10882893344 11355537408 1937039216 19.123 99 22 44 2 1954668160 11258928 6370016
16:24:44 19416 8192000000 10861468368 11312414720 1829011456 18.251 94 38 76 3 1853510256 13591952 10906848
16:25:13 27390 8192000000 10883557920 11319619584 1896374080 18.797 98 54 108 0 1923592416 12430896 14787440
16:25:53 56411 8192000000 10870398832 11320692736 1868149472 18.569 97 31 62 0 1887927280 11268304 8509504
16:26:58 20922 8192000000 9491305664 9794945024 634810640 7.191 33 17 33 0 646548448 7265920 4471888

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-01-2021 16:28:05 to 03-01-2021 16:28:36.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-01-2021 16:28:37 to 03-01-2021 16:28: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          240417
MON$OLDEST_ACTIVE               240666
MON$OLDEST_SNAPSHOT             240666
MON$NEXT_TRANSACTION            240666
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                       2036640
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:278: 
:279: mscs-test-161.budzdorov.ru    Sun Jan  3 16:27:23 2021
:280:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:281: 
:282: 
:283: mscs-test-161.budzdorov.ru    Sun Jan  3 16:27:23 2021
:284:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:285: 
:286: 
:287: mscs-test-161.budzdorov.ru    Sun Jan  3 16:27:27 2021
:288:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:289: 
--- end of diff output ---

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

03.01.21 16:28: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-01-03 16:28:42 No severe PSQL-related problems occured
03.01.21 16:28:43. End of report.