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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17132368 kB
MemAvailable 31381104 kB
Buffers 0 kB
Cached 14585156 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-14 01:27:12
DTS_END                         2021-01-14 01:27:12.0050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44746
TRN_ID                          235707
ATT_ID                          690
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: 9433.80 25937 1132056
customer order: creation 166.78 374 20013
customer order: refuse 14.06 368 1687
order to supplier: creation 44.72 1264 5366
order to supplier: removal 3.62 101434 434
invoice (draft): creation 46.06 3546 5527
invoice (draft): removal 56.07 723 6728
invoice accept: apply 41.42 19857 4970
invoice accept: cancel 50.23 817 6028
customer reserve: creation 3852.80 196 462336
customer reserve: removal 4858.65 60 583038
realization accept: apply 81.41 189 9769
realization accept: cancel 90.86 102 10903
payment from customer: creation 57.93 117 6952
payment from customer: removal 6.01 77 721
payment to supplier: creation 48.08 137 5770
payment to supplier: removal 3.29 76 395
service: total inventory turnovers 4.59 1214 551
service: total monetary turnovers 6.41 26 769
service: aggregate perf. data 0.79 19057 95
service: refresh index statistics 0.03 369115 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-01-2021 01:29:21 to 14-01-2021 01:29:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3528
TEST_TIME 2 4168
TEST_TIME 3 5649
TEST_TIME 4 5795
TEST_TIME 5 5584
TEST_TIME 6 5550
TEST_TIME 7 5493
TEST_TIME 8 5428
TEST_TIME 9 6062
TEST_TIME 10 6165
TEST_TIME 11 6222
TEST_TIME 12 6576
TEST_TIME 13 6544
TEST_TIME 14 6542
TEST_TIME 15 6974
TEST_TIME 16 7209
TEST_TIME 17 7411
TEST_TIME 18 7997
TEST_TIME 19 8338
TEST_TIME 20 8908
TEST_TIME 21 8965
TEST_TIME 22 8909
TEST_TIME 23 9029
TEST_TIME 24 9013
TEST_TIME 25 9281
TEST_TIME 26 9415
TEST_TIME 27 9502
TEST_TIME 28 9891
TEST_TIME 29 10585
TEST_TIME 30 10833
TEST_TIME 31 10717
TEST_TIME 32 10665
TEST_TIME 33 10857
TEST_TIME 34 11033
TEST_TIME 35 10915
TEST_TIME 36 10821
TEST_TIME 37 10662
TEST_TIME 38 10415
TEST_TIME 39 10502
TEST_TIME 40 10472
TEST_TIME 41 10398
TEST_TIME 42 10345
TEST_TIME 43 10338
TEST_TIME 44 10246
TEST_TIME 45 10107
TEST_TIME 46 10205
TEST_TIME 47 10285
TEST_TIME 48 10209
TEST_TIME 49 10139
TEST_TIME 50 10119
TEST_TIME 51 9992
TEST_TIME 52 9920
TEST_TIME 53 9867
TEST_TIME 54 9856
TEST_TIME 55 9744
TEST_TIME 56 9888
TEST_TIME 57 9807
TEST_TIME 58 9836
TEST_TIME 59 9736
TEST_TIME 60 9841
TEST_TIME 61 9998
TEST_TIME 62 9976
TEST_TIME 63 9961
TEST_TIME 64 10022
TEST_TIME 65 10126
TEST_TIME 66 10084
TEST_TIME 67 10001
TEST_TIME 68 9932
TEST_TIME 69 9858
TEST_TIME 70 9846
TEST_TIME 71 9803
TEST_TIME 72 9814
TEST_TIME 73 9747
TEST_TIME 74 9678
TEST_TIME 75 9633
TEST_TIME 76 9635
TEST_TIME 77 9611
TEST_TIME 78 9584
TEST_TIME 79 9585
TEST_TIME 80 9653
TEST_TIME 81 9710
TEST_TIME 82 9709
TEST_TIME 83 9688
TEST_TIME 84 9716
TEST_TIME 85 9721
TEST_TIME 86 9704
TEST_TIME 87 9826
TEST_TIME 88 9842
TEST_TIME 89 9825
TEST_TIME 90 9754
TEST_TIME 91 9716
TEST_TIME 92 9684
TEST_TIME 93 9652
TEST_TIME 94 9580
TEST_TIME 95 9552
TEST_TIME 96 9546
TEST_TIME 97 9524
TEST_TIME 98 9582
TEST_TIME 99 9599
TEST_TIME 100 9581
TEST_TIME 101 9597
TEST_TIME 102 9594
TEST_TIME 103 9573
TEST_TIME 104 9643
TEST_TIME 105 9658
TEST_TIME 106 9658
TEST_TIME 107 9647
TEST_TIME 108 9672
TEST_TIME 109 9693
TEST_TIME 110 9751
TEST_TIME 111 9694
TEST_TIME 112 9617
TEST_TIME 113 9633
TEST_TIME 114 9585
TEST_TIME 115 9589
TEST_TIME 116 9588
TEST_TIME 117 9540
TEST_TIME 118 9508
TEST_TIME 119 9512
TEST_TIME 120 9434

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-01-2021 01:29:24 to 14-01-2021 01:29:28.

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 1559779 1559779 0 0.00 0 22095 6 0 0
doc_list_biud 1559750 1559750 0 0.00 0 37720 28 0 0
sp_add_invoice_to_stock 5106 4970 136 2.66 48 176698 19858 0 136
sp_cancel_adding_invoice 6028 6028 0 0.00 2 55442 817 0 0
sp_cancel_client_order 1687 1687 0 0.00 4 19744 368 0 0
sp_cancel_customer_reserve 583038 583038 0 0.00 1 29104 60 0 0
sp_cancel_pay_from_customer 721 721 0 0.00 3 10161 78 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 1900 76 0 0
sp_cancel_supplier_invoice 6737 6728 9 0.13 1 26393 723 0 9
sp_cancel_supplier_order 434 434 0 0.00 7 910599 101434 0 0
sp_cancel_write_off 10903 10903 0 0.00 1 15541 103 0 0
sp_client_order 20013 20013 0 0.00 3 24716 375 0 0
sp_customer_reserve 462336 462336 0 0.00 0 99667 197 0 0
sp_fill_shopping_cart 30896 30896 0 0.00 1 9015 37 0 0
sp_fill_shopping_cart_clo_res 462336 462336 0 0.00 0 20966 13 0 0
sp_get_clo_for_invoice 4970 4970 0 0.00 0 16064 257 0 0
sp_kill_cost_storno 18047 18047 0 0.00 0 9775 52 0 0
sp_kill_qstorno_ret_qs2qd 1184141 1184141 0 0.00 0 29087 32 0 0
sp_kill_qty_storno 623538 623538 0 0.00 0 37714 70 0 0
sp_lock_selected_doc 20444 20444 0 0.00 0 7985 5 0 0
sp_make_cost_storno 27461 27461 0 0.00 0 22093 59 0 0
sp_multiply_rows_for_pdistr 27432 27432 0 0.00 0 5830 26 0 0
sp_multiply_rows_for_qdistr 20013 20013 0 0.00 0 11011 187 0 0
sp_pay_from_customer 6952 6952 0 0.00 4 22100 117 0 0
sp_pay_to_supplier 5770 5770 0 0.00 5 22781 138 0 0
sp_payment_common 12712 12712 0 0.00 2 22761 23 0 0
sp_qd_handle_on_cancel_clo 1687 1687 0 0.00 0 19736 329 0 0
sp_qd_handle_on_invoice_upd_sts 10989 10989 0 0.00 0 37705 344 0 0
sp_qd_handle_on_reserve_upd_sts 9759 9759 0 0.00 0 20178 65 0 0
sp_reserve_write_off 9769 9769 0 0.00 6 20321 189 0 0
sp_supplier_invoice 5527 5527 0 0.00 6 109962 3547 0 0
sp_supplier_order 5366 5366 0 0.00 5 30278 1264 0 0
srv_aggregate_perf_data 95 95 0 0.00 2484 172048 19057 0 0
srv_fill_mon_cache_memory 178 178 0 0.00 1281 110601 29131 0 0
srv_find_qd_qs_mism 1084734 1084734 0 0.00 0 15093 6 0 0
srv_make_invnt_saldo 551 551 0 0.00 7 66643 1215 0 0
srv_make_money_saldo 769 769 0 0.00 1 1626 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 143496 671062 369115 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4970 4970 0 0.00 0 14612 183 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 3832 113 0 0
t$perf-norm:sp_cancel_client_order 1687 1687 0 0.00 0 4640 14 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 9216 37 0 0
t$perf-norm:sp_cancel_pay_from_customer 721 721 0 0.00 0 4668 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 4970 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 5508 31 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 19031 1604 0 0
t$perf-norm:sp_cancel_write_off 965 965 0 0.00 0 3128 6 0 0
t$perf-norm:sp_client_order 20013 20013 0 0.00 0 8227 19 0 0
t$perf-norm:sp_customer_reserve 977 977 0 0.00 0 4634 19 0 0
t$perf-norm:sp_pay_from_customer 6952 6952 0 0.00 0 13586 15 0 0
t$perf-norm:sp_pay_to_supplier 5770 5770 0 0.00 0 7467 11 0 0
t$perf-norm:sp_reserve_write_off 9769 9769 0 0.00 0 7112 15 0 0
t$perf-norm:sp_supplier_invoice 5527 5527 0 0.00 0 12597 27 0 0
t$perf-norm:sp_supplier_order 5366 5366 0 0.00 0 6576 17 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 283 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 178 178 0 0.00 0 1605 34 0 0
t$perf-norm:srv_make_invnt_saldo 551 551 0 0.00 0 830 23 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 5338 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 100 27 0 0
v_add_invoice_to_stock 10194 9922 272 2.66 0 16932 25 0 272
v_all_customers 36360 36360 0 0.00 0 25 1 0 0
v_all_suppliers 30246 30246 0 0.00 0 16 1 0 0
v_all_wares 40026 40026 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 1518 9 0 0
v_cancel_client_order 3374 3374 0 0.00 0 13657 12 0 0
v_cancel_customer_prepayment 1442 1442 0 0.00 0 10145 14 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 5708 8 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 1894 6 0 0
v_cancel_supplier_invoice 846 828 18 2.12 0 2633 21 0 18
v_cancel_supplier_order 868 868 0 0.00 0 329 3 0 0
v_cancel_write_off 1930 1930 0 0.00 0 15526 21 0 0
v_max_id_clo_ord 5366 5366 0 0.00 0 700 1 0 0
v_max_id_clo_res 977 977 0 0.00 0 1491 16 0 0
v_max_id_ord_sup 5517 5517 0 0.00 0 3513 4 0 0
v_max_non_paid_invoice 1522 1522 0 0.00 0 407 2 0 0
v_max_non_paid_realizn 3767 3767 0 0.00 0 2532 3 0 0
v_min_id_clo_ord 5366 5366 0 0.00 0 4812 9 0 0
v_min_id_clo_res 977 977 0 0.00 0 3246 5 0 0
v_min_id_ord_sup 5517 5517 0 0.00 0 6888 6 0 0
v_min_non_paid_invoice 5762 5762 0 0.00 0 22756 18 0 0
v_min_non_paid_realizn 6950 6950 0 0.00 0 4046 11 0 0
v_our_firm 10032 10032 0 0.00 0 13 1 0 0
v_reserve_write_off 19518 19518 0 0.00 0 14280 9 0 0
x_lock_depdocs_on_canc_invoice 12342 12342 0 0.00 0 16437 110 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 28410 422 0 0
x_make_qstorno_1000_1200 5366 5366 0 0.00 2 30273 1176 0 0
x_make_qstorno_1200_2000 5527 5527 0 0.00 3 109949 3425 0 0
x_make_qstorno_2100_3300 462336 462336 0 0.00 0 99666 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-01-2021 01:29:29 to 14-01-2021 01:29:33.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 25213 8192000000 10296499776 10610737152 919521184 10.091 69 58 118 0 940450432 2639280 18289968
22:57:56 27590 8192000000 10371683488 10696298496 1416616768 14.743 100 81 162 0 1448779712 5681168 26481776
22:58:36 17540 8192000000 10403164912 10729234432 1456309296 15.093 100 86 172 0 1491787712 7370752 28107664
22:59:05 29539 8192000000 10422965040 10754764800 1472060880 15.232 100 93 186 0 1510819072 8567152 30191040
22:59:49 17348 8192000000 10442237984 10777157632 1490862912 15.396 100 89 178 1 1528880688 9006896 29010880
23:00:19 19288 8192000000 10454109392 10792730624 1510353632 15.566 100 88 175 0 1547849824 9321504 28174688
23:00:52 19194 8192000000 10481421344 10829283328 1533340256 15.766 100 81 162 1 1568459168 9493488 25625424
23:01:44 15707 8192000000 10520893040 10870087680 1576380864 16.137 100 86 172 1 1613664880 10546064 26737952
23:02:10 16096 8192000000 10532733248 10885021696 1590036416 16.254 100 87 174 0 1627838256 11075968 26725872
23:02:37 20385 8192000000 10550573712 10911961088 1605008352 16.382 100 75 148 2 1638416144 10875216 22532576
23:03:07 14906 8192000000 10578204784 10934665216 1630197248 16.597 100 79 157 0 1664362960 11094208 23071504
23:03:31 15079 8192000000 10600288816 10961342464 1650040048 16.765 100 84 167 1 1687270224 12450432 24779744
23:03:54 10406 8192000000 10612728816 10976141312 1666024336 16.900 100 87 174 2 1704849776 13177360 25648080
23:04:18 8875 8192000000 10623857920 10990407680 1678616800 17.006 100 80 160 0 1715255328 13274096 23364432
23:04:34 8528 8192000000 10640960512 11009359872 1699229664 17.179 100 82 163 1 1736045424 13308304 23507456
23:04:50 10111 8192000000 10659852608 11034595328 1711149984 17.278 100 82 164 0 1748441008 13665104 23625920
23:05:07 10422 8192000000 10677086416 11050696704 1735494080 17.481 100 84 166 5 1772652608 13521824 23636704
23:05:25 5243 8192000000 10686248944 11061481472 1748153456 17.586 100 80 158 2 1784568128 13898864 22515808
23:05:37 5930 8192000000 10696564864 11077619712 1758574752 17.673 100 86 170 4 1796878672 14431360 23872560
23:05:51 5857 8192000000 10714159184 11089457152 1771629296 17.780 100 87 174 1 1809530832 12881760 25019776
23:06:03 4851 8192000000 10714166304 11094728704 1772700944 17.789 100 76 152 0 1806808416 12807472 21300000
23:06:15 2237 8192000000 10717530032 11096080384 1778244944 17.835 100 79 159 0 1813981616 13054672 22682000
23:06:24 2348 8192000000 10734075600 11112935424 1786831904 17.906 100 85 170 0 1824583120 13060000 24691216
23:06:33 2829 8192000000 10737701344 11117477888 1796507536 17.985 100 91 182 0 1835545840 13593296 25445008
23:06:43 3625 8192000000 10733162096 11115421696 1796495184 17.985 100 84 169 1 1833195936 13064800 23635952
23:06:54 2870 8192000000 10733539568 11123929088 1801902272 18.030 100 75 148 1 1835769424 12715264 21151888
23:07:04 3246 8192000000 10757095200 11135983616 1810174336 18.097 100 87 174 0 1846439312 12159008 24105968
23:07:14 2181 8192000000 10763048880 11143876608 1818077648 18.162 100 94 187 3 1856656752 12562112 26016992
23:07:23 6702 8192000000 10758835376 11139428352 1815554768 18.141 100 78 158 0 1850771616 13361328 21855520
23:07:36 5053 8192000000 10761953088 11141632000 1817093312 18.154 100 85 170 0 1853641104 13263184 23284608
23:07:48 2876 8192000000 10779937952 11164966912 1835410464 18.303 100 92 184 2 1875344464 13646640 26287360
23:07:57 2067 8192000000 10786750544 11171512320 1844726384 18.379 100 94 189 1 1884305008 13583328 25995296
23:08:05 2513 8192000000 10783461040 11175112704 1845121904 18.382 100 88 176 0 1883275616 13471568 24682144
23:08:14 2191 8192000000 10790559248 11179487232 1850309776 18.425 100 86 172 0 1886369488 12219456 23840256
23:08:23 1789 8192000000 10801349664 11189026816 1858512160 18.491 100 91 180 1 1896737168 11951616 26273392
23:08:31 1643 8192000000 10802256768 11192336384 1859956208 18.503 100 93 187 0 1899246240 12853616 26436416
23:08:39 1716 8192000000 10810956032 11198279680 1863416176 18.531 100 95 190 2 1903809536 13469936 26923424
23:08:47 1526 8192000000 10801590848 11192537088 1863748336 18.534 100 95 191 2 1904512960 13825296 26939328
23:08:55 2138 8192000000 10795445392 11184918528 1865750336 18.550 100 92 185 2 1904161040 13247584 25163120
23:09:03 27685 8192000000 10792032704 11197857792 1859271824 18.497 100 63 126 1 1889226528 12251936 17702768
23:09:57 1970 8192000000 10816143392 11206230016 1868675312 18.574 100 89 178 3 1905718560 10022768 27020480
23:10:05 2234 8192000000 10793055344 11203645440 1864221088 18.537 100 55 106 2 1891197440 11499088 15477264
23:10:15 5851 8192000000 10779820128 11197444096 1860911616 18.511 100 39 78 0 1885762320 13731392 11119312
23:10:27 3536 8192000000 10784436944 11202977792 1867875712 18.567 100 44 89 1 1888565040 8672976 12016352
23:10:37 7337 8192000000 10791758208 11207434240 1864249888 18.538 100 29 58 0 1879362800 6850368 8262544
23:10:52 11795 8192000000 10778318464 11202371584 1863865472 18.535 100 28 56 1 1877766432 6664176 7236784
23:11:11 8814 8192000000 10780685280 11206377472 1865690640 18.549 100 19 39 1 1877606992 6053296 5863056
23:11:28 13970 8192000000 10788007552 11209076736 1870497680 18.588 100 30 60 3 1885881920 7102432 8281808
23:11:50 6508 8192000000 10780870880 11211091968 1873205376 18.610 100 32 64 3 1889183728 6614912 9363440
23:12:04 8766 8192000000 10783872976 11212472320 1873301168 18.611 100 25 49 3 1887059488 6999760 6758560
23:12:21 3219 8192000000 10806685072 11222249472 1879759600 18.663 100 41 80 3 1896418272 6177264 10481408
23:12:30 11763 8192000000 10776967280 11214020608 1874961952 18.624 100 16 32 1 1885958224 6744720 4251552
23:12:49 69465 8192000000 10820462752 11232796672 1887289056 18.724 100 37 75 1 1903374400 5840896 10244448
23:14:05 1814 8192000000 10832580688 11245740032 1900086944 18.827 100 81 161 1 1934251408 10227664 23936800
23:14:21 7165 8192000000 10807505072 11231936512 1887086176 18.722 100 25 49 1 1899983856 5574656 7323024
23:14:36 5918 8192000000 10806683648 11234963456 1890690304 18.751 100 29 58 1 1905414224 7135968 7587952
23:14:50 8893 8192000000 10803418272 11237187584 1891916624 18.761 100 20 39 1 1903477712 6166880 5394208
23:15:05 7082 8192000000 10796695984 11235160064 1891923296 18.761 100 21 43 1 1904151904 6564016 5664592
23:15:20 5412 8192000000 10817873376 11244552192 1894521952 18.782 100 26 52 1 1908425488 6253744 7649792
23:15:32 7671 8192000000 10807923456 11240157184 1894358016 18.781 100 25 50 1 1907547968 6376112 6813840
23:15:47 8809 8192000000 10807083024 11240534016 1893169408 18.771 100 12 24 1 1902168688 5740128 3259152
23:16:03 4960 8192000000 10810519584 11243204608 1897280720 18.804 100 27 54 0 1910377680 5693616 7403344
23:16:16 12847 8192000000 10813861024 11246432256 1897478768 18.806 100 17 34 2 1908145792 5821456 4845568
23:16:36 8708 8192000000 10811557568 11248910336 1903604272 18.855 100 26 50 3 1916615584 5409168 7602144
23:16:53 8157 8192000000 10816793936 11253125120 1904046848 18.859 100 25 50 0 1917258384 5717296 7494240
23:17:07 54486 8192000000 10810445456 11237429248 1861735712 18.517 98 25 50 4 1874385936 4824864 7825360
23:18:08 13858 8192000000 10803616272 11241586688 1891593760 18.759 100 35 67 1 1906980272 5893760 9492752
23:18:30 13233 8192000000 10802043840 11232890880 1852683888 18.444 98 27 53 4 1866171152 5598912 7888352
23:18:51 9707 8192000000 10795708720 11220049920 1846384288 18.393 98 25 50 0 1859335296 6342352 6608656
23:19:11 4113 8192000000 10772689920 11192061952 1838504400 18.329 99 36 72 0 1855653584 6919216 10229968
23:19:24 9374 8192000000 10742580176 11177091072 1794586016 17.969 97 26 52 0 1808727792 6624976 7516800
23:19:40 9196 8192000000 10768091376 11196358656 1851577248 18.435 100 25 48 6 1865907040 6963152 7366640
23:19:59 6752 8192000000 10710376336 11118559232 1709872624 17.268 93 24 47 2 1722195552 5508752 6814176
23:20:17 7066 8192000000 10675012480 11081453568 1705820160 17.234 95 32 64 1 1721298320 6320864 9157296
23:20:33 6987 8192000000 10688584592 11100602368 1729209184 17.429 97 30 61 1 1743411328 5229120 8973024
23:20:47 10782 8192000000 10686221584 11102654464 1711800528 17.284 96 17 35 1 1725976944 9466976 4709440
23:21:05 9809 8192000000 10687401376 11097751552 1739977824 17.518 98 19 38 1 1751700560 6108656 5614080
23:21:21 7612 8192000000 10700837744 11116040192 1769392832 17.762 99 10 20 1 1777859216 5755200 2711184
23:21:35 5652 8192000000 10706709344 11112935424 1756657248 17.657 98 21 41 4 1767974576 5560944 5756384
23:21:48 16105 8192000000 10708181152 11119669248 1763572720 17.714 98 37 74 4 1780599744 6121168 10905856
23:22:11 60656 8192000000 10703642784 11127984128 1753803408 17.633 97 34 67 1 1769071440 5630832 9637200
23:23:20 9055 8192000000 10718364304 11143540736 1811873792 18.111 100 38 76 3 1828888416 6351664 10662960
23:23:37 5989 8192000000 10724111584 11149664256 1797808336 17.996 99 29 58 5 1816264496 10543808 7912352
23:23:51 7363 8192000000 10740353808 11161837568 1805488848 18.059 99 28 56 0 1819271040 5321408 8460784
23:24:05 5941 8192000000 10722030272 11146534912 1802773376 18.037 99 27 53 1 1816050320 4899024 8377920
23:24:17 7543 8192000000 10718757120 11144536064 1812266192 18.114 100 19 38 0 1822913360 5153872 5493296
23:24:32 7100 8192000000 10748840736 11171090432 1829258304 18.253 100 32 64 0 1849442656 11588288 8596064
23:24:48 6621 8192000000 10753522976 11179761664 1841007296 18.349 100 23 45 1 1854192800 5622672 7562832
23:25:01 8862 8192000000 10758891248 11186212864 1846663120 18.395 100 25 50 2 1859754256 6263616 6827520
23:25:17 8768 8192000000 10764372832 11199164416 1861750256 18.517 100 37 74 2 1877844672 5185984 10908432
23:25:35 9948 8192000000 10764768576 11197554688 1859987312 18.503 100 22 44 2 1872207520 5489792 6730416
23:25:54 13733 8192000000 10783999808 11208105984 1863663536 18.533 100 14 28 0 1873412000 4944576 4803888
23:26:14 12218 8192000000 10774529056 11210760192 1867642544 18.565 100 14 28 0 1876881504 5371600 3867360
23:26:32 7446 8192000000 10789718704 11218182144 1872670992 18.606 100 11 22 0 1880718624 5069008 2978624
23:26:49 52124 8192000000 10812639824 11239165952 1883738000 18.695 100 21 41 2 1895732160 5557936 6436224
23:27:51 43368 8192000000 10846260976 11260760064 1913955536 18.938 100 49 97 1 1934132800 6264928 13912336
23:28:42 23061 8192000000 10859654800 11280113664 1927006992 19.043 100 66 131 2 1955131776 9703104 18421680
23:29:11 7433 8192000000 10873824992 11285966848 1932260288 19.085 100 54 108 0 1956589584 9934592 14394704
23:29:28 12228 8192000000 10868607168 11290927104 1936956064 19.122 100 58 116 0 1964490144 10889920 16644160
23:29:52 18517 8192000000 10877330352 11302264832 1943972000 19.178 100 54 108 1 1970906800 11811552 15123248
23:30:18 5783 8192000000 10880223424 11304349696 1947583408 19.207 100 52 104 1 1974381696 10628224 16170064
23:30:32 6746 8192000000 10879507952 11308081152 1951107328 19.235 100 57 111 0 1976308448 9489136 15711984
23:30:52 3953 8192000000 10880636128 11311235072 1957167264 19.284 100 56 113 2 1981497168 8292912 16036992
23:31:04 4159 8192000000 10894114000 11319521280 1960283056 19.308 100 59 118 2 1986886352 9618608 16984688
23:31:17 19306 8192000000 10903996336 11327516672 1966740368 19.360 100 68 135 0 1997726432 11556608 19429456
23:31:47 9312 8192000000 10907579424 11334832128 1969520864 19.382 100 55 110 0 1998749024 13286224 15941936
23:32:06 8804 8192000000 10903664688 11335680000 1971450800 19.397 100 48 96 1 1998806320 13592640 13762880
23:32:27 14905 8192000000 10904477328 11338661888 1976818688 19.440 100 49 96 1 2004396064 13230464 14346912
23:33:03 43963 8192000000 10907050784 11348123648 1977263568 19.443 100 41 82 2 2003108016 13713664 12130784
23:33:56 7298 8192000000 10945232448 11361124352 1987478432 19.524 100 64 128 2 2023505152 16780000 19246720
23:34:15 14232 8192000000 10925078480 11360227328 1987371120 19.523 100 57 111 1 2020490192 16822048 16297024
23:34:37 5422 8192000000 10942348848 11364720640 1996042976 19.592 100 60 118 1 2032723824 19690448 16990400
23:34:52 4380 8192000000 10946229360 11371171840 1998340464 19.610 100 72 142 1 2043326080 23434256 21551360
23:35:03 12909 8192000000 10944029696 11373948928 1999056704 19.615 100 60 118 0 2039812240 23748592 17006944
23:35:23 6195 8192000000 10945100480 11368861696 1982006560 19.481 99 66 132 2 2025162592 23764096 19391936
23:35:37 28321 8192000000 10952110112 11387908096 1996785952 19.597 100 53 106 1 2038984464 26100000 16098512
23:36:17 14763 8192000000 10950191216 11388526592 2002365632 19.641 100 50 100 0 2044641808 27000864 15275312
23:36:42 9106 8192000000 10950891232 11387899904 2003951552 19.654 100 52 103 0 2045345408 25363760 16030096
23:36:58 4393 8192000000 10973495648 11398238208 2010365440 19.704 100 60 122 0 2054178272 25318912 18493920
23:37:12 14957 8192000000 10977119600 11406020608 2018120416 19.765 100 67 134 0 2068695216 30629280 19945520
23:37:36 7494 8192000000 10966357328 11400560640 2014991344 19.741 100 60 120 2 2061225232 27929472 18304416
23:37:54 8026 8192000000 10968061552 11403165696 2014426528 19.736 100 56 112 0 2058762112 26640096 17695488
23:38:11 2789 8192000000 10968524160 11399413760 2010762800 19.708 100 58 111 1 2052392432 24717328 16912304
23:38:21 12007 8192000000 10968254016 11395657728 2009983872 19.701 100 61 118 1 2053947040 25447696 18515472
23:38:41 5266 8192000000 10967674400 11400036352 2014288544 19.735 100 56 111 1 2058311872 27401312 16622016
23:38:58 8481 8192000000 10978570288 11412271104 2022152224 19.797 100 60 120 2 2069094192 28648752 18293216
23:39:18 6870 8192000000 10984807520 11412774912 2026631904 19.832 100 76 152 1 2075716928 26110208 22974816
23:39:38 14662 8192000000 10974586640 11414323200 2022854784 19.803 100 49 98 1 2063021888 25294992 14872112
23:40:00 4964 8192000000 10986592912 11418501120 2028890256 19.850 100 61 122 0 2073849280 26187968 18771056
23:40:12 4623 8192000000 10984325552 11413282816 2024318128 19.814 100 74 149 2 2072871024 25411712 23141184
23:40:31 8171 8192000000 10970131168 11405619200 2003605776 19.651 99 56 110 1 2046617456 26424880 16586800
23:40:47 6942 8192000000 10961510592 11400990720 2004748096 19.660 100 46 92 1 2046550736 27476704 14325936
23:41:03 5660 8192000000 10968351008 11394273280 2002324528 19.641 100 63 126 0 2049397696 27859360 19213808
23:41:17 12733 8192000000 10970146016 11408379904 2014309440 19.735 100 53 106 0 2060199344 29253008 16636896
23:41:39 4249 8192000000 10980111536 11414126592 2017810384 19.763 100 55 109 1 2066192512 31354640 17027488
23:42:00 1279 8192000000 11004828592 11422261248 2026439472 19.831 100 84 169 0 2084416224 31978160 25998592
23:42:12 3765 8192000000 10994369520 11422535680 2014674336 19.738 99 85 167 1 2074859792 34135904 26049552
23:42:23 2342 8192000000 10997401136 11419975680 2023349344 19.806 100 84 168 3 2084643312 34669728 26624240
23:42:34 2152 8192000000 10984244096 11408216064 2010219344 19.703 100 83 164 1 2071202768 36081968 24901456
23:42:46 2302 8192000000 10983548080 11402969088 1999539072 19.619 99 84 166 1 2060303232 35644208 25119952
23:42:57 7990 8192000000 10983271600 11406151680 2007645104 19.683 100 85 168 0 2064067760 30793200 25629456
23:43:13 9801 8192000000 10973712496 11406532608 2008452176 19.689 100 64 127 4 2061401568 33300256 19649136
23:43:31 2097 8192000000 10985956512 11408134144 2012224224 19.719 100 78 155 2 2071037456 33899968 24913264
23:43:41 3223 8192000000 10977764736 11397029888 1999862080 19.622 100 82 162 0 2061482192 35608640 26011472
23:43:51 1513 8192000000 10979207696 11398508544 2003167520 19.648 100 83 164 1 2064592960 35386240 26039200
23:44:00 3324 8192000000 10980272816 11404390400 2005287488 19.664 100 73 146 3 2062202848 34834848 22080512
23:44:13 1757 8192000000 10967712896 11388489728 1990927184 19.551 100 77 150 0 2050080256 35510368 23642704
23:44:22 1830 8192000000 10963100784 11374489600 1966831600 19.360 99 86 170 0 2029464080 36418048 26214432
23:44:31 1568 8192000000 10953755712 11367743488 1972703264 19.407 100 81 162 3 2040588432 42471840 25413328
23:44:39 2914 8192000000 10940927808 11354980352 1946692272 19.200 99 85 169 1 2014498208 42084272 25721664
23:44:49 2405 8192000000 10949310944 11362140160 1967307248 19.364 100 80 157 1 2030056736 38812944 23936544
23:45:01 2983 8192000000 10964365024 11381424128 1980931984 19.472 100 88 176 0 2050032128 41209200 27890944
23:45:13 5845 8192000000 10946725024 11382272000 1978706768 19.454 100 63 125 1 2040066832 40372768 20987296
23:45:27 6385 8192000000 10947175248 11382472704 1983383360 19.491 100 53 103 0 2037581888 37783184 16415344
23:45:42 1951 8192000000 10962908352 11375423488 1972326144 19.404 100 78 156 4 2041699888 43944864 25428880
23:45:51 7166 8192000000 10925826208 11361325056 1946641280 19.200 99 61 121 2 2007094592 40949536 19503776
23:46:06 2461 8192000000 10930264064 11347955712 1940440080 19.150 99 77 151 2 2003150704 39195600 23515024
23:46:16 3528 8192000000 10936408208 11350196224 1936274208 19.117 99 79 158 0 2003280640 41917728 25088704
23:46:27 2132 8192000000 10939244304 11347345408 1933985456 19.099 99 86 169 0 2005844944 46163104 25696384
23:46:37 3496 8192000000 10934842800 11359911936 1952728128 19.248 100 68 136 1 2021046128 45974096 22343904
23:46:49 8507 8192000000 10932542800 11364413440 1956420176 19.278 100 54 108 2 2013890528 40609184 16861168
23:47:11 13125 8192000000 10920464560 11368390656 1963735152 19.336 100 47 94 1 2017443040 38100704 15607184
23:47:32 8708 8192000000 10931781600 11369132032 1966855712 19.360 100 40 80 1 2014996768 35016928 13124128
23:47:51 9623 8192000000 10915683904 11355541504 1935500016 19.111 98 40 80 1 1976936544 28741744 12694784
23:48:13 10377 8192000000 10921832832 11362680832 1950295920 19.229 99 33 66 0 1990638560 29535760 10806880
23:48:31 8435 8192000000 10908849648 11342168064 1937072576 19.123 99 38 76 0 1980417520 30922800 12422144
23:48:47 2632 8192000000 10938892752 11357626368 1965176000 19.347 100 73 146 2 2017070096 29266560 22627536
23:48:58 2285 8192000000 10942636400 11368550400 1974434560 19.421 100 67 134 1 2028378720 32277632 21666528
23:49:15 9268 8192000000 10943525792 11376193536 1980776272 19.471 100 56 113 1 2034162288 34591376 18794640
23:49:34 4386 8192000000 10965841200 11386937344 1975380352 19.428 99 74 146 4 2033882736 34989792 23512592
23:49:45 3345 8192000000 10949554736 11361370112 1966847904 19.360 100 73 146 1 2025683296 35853408 22981984
23:49:55 3111 8192000000 10973080752 11386929152 1984759712 19.502 100 80 160 0 2048970704 38116960 26094032
23:50:05 7484 8192000000 10938706000 11365597184 1951241072 19.236 99 63 126 0 2013726064 42132448 20352544
23:50:18 12061 8192000000 10940549712 11379474432 1971637152 19.398 100 42 84 1 2025580928 39938496 14005280
23:50:52 13463 8192000000 10942421680 11370557440 1967648064 19.367 100 55 111 0 2025245824 38956224 18641536
23:51:25 28705 8192000000 10925857008 11372724224 1966629424 19.359 100 36 72 0 2019615472 40367184 12618864
23:52:06 3476 8192000000 10942837600 11377364992 1969188288 19.379 100 45 88 2 2025289936 40747616 15354032
23:52:24 11452 8192000000 10941654432 11375284224 1967509072 19.366 100 50 97 1 2025888912 41341840 17038000
23:52:42 20201 8192000000 10934421008 11380932608 1968363552 19.372 100 40 80 0 2021007600 39360288 13283760
23:53:08 16677 8192000000 10924837584 11375095808 1948700224 19.216 99 34 66 5 2001225696 41187744 11337728
23:53:50 15204 8192000000 10922485968 11367038976 1952237840 19.244 100 34 68 0 2003216608 39768160 11210608
23:54:34 29986 8192000000 10899768736 11356512256 1932233680 19.085 100 23 46 0 1988162640 47452848 8476112
23:55:10 12177 8192000000 10892347728 11365453824 1929206128 19.061 100 17 34 1 1984816656 49264432 6346096
23:55:38 16294 8192000000 10872432384 11331489792 1884413216 18.701 98 19 37 1 1931919744 40769232 6737296
23:56:02 21595 8192000000 10891463264 11340865536 1916587008 18.959 100 16 32 1 1962538176 40688704 5262464
23:56:33 31834 8192000000 10858748160 11315130368 1892080848 18.763 99 14 29 0 1920830608 24776736 3973024
23:57:14 40371 8192000000 10882840672 11313303552 1916886896 18.962 99 31 61 0 1935104080 9725312 8491872
23:58:08 28252 8192000000 10861196288 11303514112 1897745632 18.808 98 12 24 0 1909328192 8465088 3117472
23:58:43 30888 8192000000 10898818560 11322310656 1922492720 19.007 99 33 66 0 1945212288 13225728 9493840
23:59:24 21559 8192000000 10894675024 11342147584 1953277184 19.253 100 45 90 1 1981354848 14494432 13583232
23:59:54 34508 8192000000 10897521488 11357503488 1933112848 19.092 99 9 18 2 1954114144 18554864 2446432
00:01:50 29987 8192000000 10861098480 11309240320 1908095888 18.891 98 11 22 0 1926288672 14872416 3320368
00:02:26 88354 8192000000 10881609248 11327922176 1916183024 18.956 98 25 49 0 1937683872 14827792 6673056
00:04:07 98231 8192000000 10884956432 11329138688 1953772272 19.257 100 42 80 3 1975109232 9429104 11907856
00:05:52 58213 8192000000 10905087328 11342295040 1954469344 19.262 100 26 52 0 1969524416 8118560 6936512
00:06:57 10886 8192000000 10904711952 11353886720 1971445472 19.397 100 51 102 0 1997810928 11371616 14993840
00:07:14 35855 8192000000 10892699600 11350827008 1950372352 19.229 99 26 52 0 1968400960 11135456 6893152
00:07:57 32660 8192000000 10898430400 11357790208 1965785888 19.352 100 17 35 3 1984439200 13142336 5510976
00:08:38 87695 8192000000 10903391584 11367010304 1977166528 19.442 100 20 40 3 1997144928 13870992 6107408
00:10:12 67488 8192000000 10905832208 11370061824 1953011168 19.250 98 16 33 1 1967176672 9996336 4169168
00:11:26 8848 8192000000 10906142432 11370221568 1979022992 19.457 100 16 31 0 1994392592 11196704 4172896
00:11:48 9259 8192000000 10909326640 11375398912 1982391968 19.484 100 10 20 3 1997078032 11809488 2876576
00:12:04 7803 8192000000 10909094384 11373424640 1966694224 19.359 99 11 22 2 1982641824 12415152 3532448
00:12:21 21612 8192000000 10934599296 11369463808 1982321392 19.483 99 59 117 0 2013735072 13442400 17971280
00:12:53 35380 8192000000 10929666432 11400282112 1995822000 19.590 100 53 104 3 2030817056 19399984 15595072
00:13:43 41906 8192000000 10900161024 11391758336 1971146320 19.395 99 10 20 0 1988061424 13763296 3151808
00:14:34 37183 8192000000 10912550480 11400073216 1986742944 19.518 100 10 20 1 2002587280 13017136 2827200
00:15:17 17515 8192000000 10909643632 11393904640 1988530048 19.532 100 6 12 0 1999420288 9227232 1663008
00:15:41 68560 8192000000 10924621776 11388710912 1974217264 19.419 99 10 19 1 1985465632 8791760 2456608
00:16:58 47877 8192000000 10916580304 11397840896 1997086400 19.600 100 17 33 1 2010461984 9073728 4301856
00:18:34 75673 8192000000 10916373632 11369803776 1961391776 19.317 98 23 46 0 1977283408 9237728 6653904
00:19:55 61471 8192000000 10911546608 11386949632 1972667104 19.407 99 8 16 1 1983955664 9196592 2091968
00:21:07 63954 8192000000 10922056032 11408719872 1995499376 19.587 100 20 41 1 2010340704 9129104 5712224
00:22:21 50463 8192000000 10910784624 11382530048 1904169328 18.860 95 21 42 2 1922652624 12404336 6078960
00:23:28 43113 8192000000 10926525408 11414728704 1992806048 19.566 100 15 29 1 2012077872 14269248 5002576
00:24:36 47392 8192000000 10922519568 11390468096 1924359136 19.022 96 21 43 2 1949697792 18841488 6497168
00:25:30 51440 8192000000 10888309072 11354980352 1889381888 18.741 96 13 26 1 1912574688 19420112 3772688
00:26:36 72581 8192000000 10887743600 11362541568 1925499040 19.031 98 20 40 1 1957138912 25300304 6339568
00:28:00 74516 8192000000 10862330624 11334991872 1859215440 18.497 95 9 18 0 1881476512 19321040 2940032
00:29:21 64395 8192000000 10890530512 11349757952 1861929184 18.519 95 20 40 0 1873273152 6932624 4411344
00:30:35 47017 8192000000 10877300736 11347152896 1921587872 19.000 98 13 26 0 1940845808 15540736 3717200
00:31:29 38402 8192000000 10888641616 11360071680 1942252112 19.165 100 11 22 0 1969864032 24634944 2976976
00:32:14 38242 8192000000 10895895728 11361939456 1959309120 19.301 100 16 32 0 1975427120 11326720 4791280
00:32:59 69578 8192000000 10927949904 11365261312 1943672336 19.176 98 48 97 5 1967402496 10757984 12972176
00:34:16 22872 8192000000 10913742384 11344248832 1920773840 18.993 97 67 132 1 1950530848 10876016 18880992
00:34:45 95878 8192000000 10887956880 11347066880 1942729232 19.169 99 39 78 2 1967571392 13741152 11101008
00:36:37 55426 8192000000 10861947504 11334463488 1892941552 18.769 97 24 48 0 1918558224 18832880 6783792
00:37:48 18077 8192000000 10872104048 11340111872 1936106896 19.116 100 26 50 2 1961711120 18612704 6991520
00:38:14 26983 8192000000 10875288880 11338121216 1935896976 19.114 100 30 60 2 1964742336 20873072 7972288
00:39:06 38800 8192000000 10861719808 11342798848 1937429216 19.126 100 16 32 0 1952453120 10345616 4678288
00:39:57 74196 8192000000 10856879840 11332087808 1857580576 18.484 95 13 26 0 1874902320 13571168 3750576
00:41:43 63173 8192000000 10851025216 11322871808 1901843392 18.841 98 18 35 0 1915987728 9459472 4684864
00:43:10 67663 8192000000 10873560912 11347386368 1920946512 18.994 99 12 24 1 1936308560 11900560 3461488
00:44:24 33099 8192000000 10880179264 11348783104 1935184672 19.108 99 22 44 0 1954436784 12381888 6870224
00:45:05 60974 8192000000 10880152128 11346141184 1891537520 18.758 97 19 38 0 1912310624 14904480 5868624
00:46:16 53724 8192000000 10846256768 11322388480 1863675760 18.533 96 14 28 2 1888806080 20911504 4218816
00:47:27 70116 8192000000 10860610368 11333881856 1916673520 18.960 99 14 28 1 1931847984 10861520 4312944
00:48:45 48363 8192000000 10886660784 11331227648 1923521616 19.015 99 34 67 1 1942601968 9589760 9490592
00:49:40 27612 8192000000 10895846544 11349504000 1951446064 19.238 100 33 66 2 1972029760 11710944 8872752
00:50:17 45101 8192000000 10903077088 11361562624 1956208560 19.276 100 38 76 2 1981135408 14371712 10555136
00:51:18 84443 8192000000 10904541184 11368828928 1944578048 19.183 99 22 44 0 1967928144 17556944 5793152
00:52:48 26911 8192000000 10900468464 11361341440 1933929328 19.098 98 46 93 2 1957789392 10761872 13098192
00:53:25 34478 8192000000 10908556704 11365642240 1956402128 19.277 100 37 74 0 1983712128 17103488 10206512
00:54:07 45895 8192000000 10916277552 11390574592 1966576272 19.358 100 32 64 0 1999329728 23862704 8890752
00:55:51 47996 8192000000 10899900672 11361808384 1927553216 19.047 98 29 58 2 1948849104 12946384 8349504
00:56:45 102867 8192000000 10885806224 11359129600 1961062160 19.314 100 28 56 0 1977418048 8277440 8078448
00:59:09 52207 8192000000 10879172720 11360698368 1963496800 19.334 100 19 38 0 1977834448 9218672 5118976
01:00:15 26047 8192000000 10889917024 11368390656 1971576336 19.398 100 11 22 0 1983178336 8589968 3012032
01:00:49 31578 8192000000 10888082768 11368919040 1972667264 19.407 100 7 14 0 1982997824 8291152 2039408
01:01:27 31276 8192000000 10890261424 11373891584 1977934768 19.448 100 8 16 0 1987348400 7241712 2171920
01:02:05 22914 8192000000 10886371056 11370803200 1962091184 19.323 99 15 29 0 1974043504 7758784 4193536
01:02:34 16285 8192000000 10896240256 11372494848 1958839344 19.297 99 18 37 2 1972295968 8972720 4483904
01:03:13 67929 8192000000 10895887104 11376533504 1939219232 19.141 98 19 38 1 1952783552 8618032 4946288
01:04:31 54555 8192000000 10903834320 11383357440 1958958096 19.298 99 8 16 1 1973503328 12755488 1789744
01:05:37 85289 8192000000 10890084880 11376902144 1905181120 18.868 96 12 24 2 1922682640 14407264 3094256
01:07:09 80108 8192000000 10910603760 11375239168 1911882128 18.922 97 21 41 0 1925974208 8685360 5406720
01:08:39 40799 8192000000 10874652736 11351961600 1918528704 18.975 98 18 36 0 1932557888 8670272 5358912
01:09:26 45019 8192000000 10887078576 11346272256 1919471536 18.983 98 22 44 1 1938076672 12871504 5733632
01:10:22 108657 8192000000 10915504272 11390382080 1968536000 19.374 100 23 46 1 1991675552 16641232 6498320
01:12:20 38137 8192000000 10912847280 11382534144 1961339808 19.317 99 18 36 1 1976490096 10734576 4415712
01:13:09 18738 8192000000 10925609872 11385925632 1962109392 19.323 99 28 56 0 1979639696 9845904 7684400
01:13:37 62179 8192000000 10917929184 11373920256 1922473504 19.007 97 32 63 3 1941507376 10266928 8766944
01:14:47 45157 8192000000 10894677888 11364663296 1920392496 18.990 97 32 64 1 1940678848 11412320 8874032
01:15:45 110601 8192000000 10888092128 11369754624 1867517856 18.564 95 9 18 0 1885091104 15205264 2367984
01:18:15 101068 8192000000 10900276704 11367739392 1942111664 19.164 99 32 64 1 1970207712 18769024 9327024
01:20:22 79007 8192000000 10896177824 11362922496 1926196384 19.036 98 23 46 1 1945764448 12586864 6981200
01:21:51 12640 8192000000 10900533280 11369648128 1964079104 19.338 100 27 54 2 1988708608 16735200 7894304
01:22:10 13596 8192000000 10893519520 11371028480 1966004736 19.354 100 15 30 1 1986540400 15884736 4650928
01:22:30 21919 8192000000 10907111120 11385839616 1969535680 19.382 100 12 24 0 1988665952 16032672 3097600
01:22:58 55478 8192000000 10896007744 11383525376 1955024176 19.266 99 16 32 0 1976044128 16086816 4933136
01:24:01 60360 8192000000 10892024448 11365543936 1933926048 19.098 98 10 20 1 1949781920 13315728 2540144
01:25:08 80483 8192000000 10882332080 11366207488 1931632480 19.080 98 11 22 0 1944038464 9184848 3221136

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-01-2021 01:29:35 to 14-01-2021 01:30:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 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 14-01-2021 01:30:08 to 14-01-2021 01:30:10.

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          235631
MON$OLDEST_ACTIVE               235923
MON$OLDEST_SNAPSHOT             235923
MON$NEXT_TRANSACTION            235923
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                       2045920
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 ---
:893: 
:894: mscs-test-161.budzdorov.ru    Thu Jan 14 01:27:33 2021
:895:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:896: 
:897: 
:898: mscs-test-161.budzdorov.ru    Thu Jan 14 01:27:33 2021
:899:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:900: 
--- end of diff output ---

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

14.01.21 01:30:11. 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-14 01:30:14 No severe PSQL-related problems occured
14.01.21 01:30:15. End of report.