Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.11.2020 01:29
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 17486132 kB
MemAvailable 31518148 kB
Buffers 0 kB
Cached 14241304 kB
SwapCached 2872 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.7
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 2020-11-04 01:27:00
DTS_END                         2020-11-04 01:27:00.8260
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/51970
TRN_ID                          235651
ATT_ID                          699
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: 9299.36 17204 1115923
customer order: creation 173.36 373 20803
customer order: refuse 14.77 340 1772
order to supplier: creation 45.16 1379 5419
order to supplier: removal 3.53 90704 424
invoice (draft): creation 46.44 3735 5573
invoice (draft): removal 52.03 796 6243
invoice accept: apply 42.14 20338 5057
invoice accept: cancel 47.02 809 5642
customer reserve: creation 3947.04 199 473645
customer reserve: removal 4633.58 53 556030
realization accept: apply 84.69 182 10163
realization accept: cancel 79.53 108 9544
payment from customer: creation 59.58 119 7150
payment from customer: removal 5.76 83 691
payment to supplier: creation 49.07 138 5888
payment to supplier: removal 3.36 104 403
service: total inventory turnovers 4.63 1063 556
service: total monetary turnovers 6.69 29 803
service: aggregate perf. data 0.94 13823 113
service: refresh index statistics 0.03 209700 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-11-2020 01:29:31 to 04-11-2020 01:29:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5011
TEST_TIME 2 5646
TEST_TIME 3 5260
TEST_TIME 4 5043
TEST_TIME 5 4623
TEST_TIME 6 5241
TEST_TIME 7 5458
TEST_TIME 8 6715
TEST_TIME 9 7118
TEST_TIME 10 7605
TEST_TIME 11 7828
TEST_TIME 12 7702
TEST_TIME 13 8043
TEST_TIME 14 8281
TEST_TIME 15 8172
TEST_TIME 16 8516
TEST_TIME 17 8507
TEST_TIME 18 8675
TEST_TIME 19 9092
TEST_TIME 20 8880
TEST_TIME 21 8973
TEST_TIME 22 9090
TEST_TIME 23 9465
TEST_TIME 24 9330
TEST_TIME 25 9649
TEST_TIME 26 9596
TEST_TIME 27 9912
TEST_TIME 28 10582
TEST_TIME 29 10580
TEST_TIME 30 10437
TEST_TIME 31 10392
TEST_TIME 32 10646
TEST_TIME 33 10515
TEST_TIME 34 10505
TEST_TIME 35 10406
TEST_TIME 36 10264
TEST_TIME 37 10155
TEST_TIME 38 10133
TEST_TIME 39 10128
TEST_TIME 40 9954
TEST_TIME 41 9969
TEST_TIME 42 9947
TEST_TIME 43 9933
TEST_TIME 44 9915
TEST_TIME 45 9790
TEST_TIME 46 9882
TEST_TIME 47 9810
TEST_TIME 48 9661
TEST_TIME 49 9628
TEST_TIME 50 9791
TEST_TIME 51 9646
TEST_TIME 52 9586
TEST_TIME 53 9577
TEST_TIME 54 9680
TEST_TIME 55 9620
TEST_TIME 56 9633
TEST_TIME 57 9658
TEST_TIME 58 9747
TEST_TIME 59 9744
TEST_TIME 60 9724
TEST_TIME 61 9756
TEST_TIME 62 9807
TEST_TIME 63 9855
TEST_TIME 64 9826
TEST_TIME 65 9830
TEST_TIME 66 9983
TEST_TIME 67 9924
TEST_TIME 68 9802
TEST_TIME 69 9774
TEST_TIME 70 9692
TEST_TIME 71 9725
TEST_TIME 72 9714
TEST_TIME 73 9686
TEST_TIME 74 9648
TEST_TIME 75 9663
TEST_TIME 76 9576
TEST_TIME 77 9475
TEST_TIME 78 9468
TEST_TIME 79 9397
TEST_TIME 80 9423
TEST_TIME 81 9570
TEST_TIME 82 9559
TEST_TIME 83 9565
TEST_TIME 84 9552
TEST_TIME 85 9620
TEST_TIME 86 9605
TEST_TIME 87 9684
TEST_TIME 88 9708
TEST_TIME 89 9662
TEST_TIME 90 9690
TEST_TIME 91 9710
TEST_TIME 92 9672
TEST_TIME 93 9702
TEST_TIME 94 9620
TEST_TIME 95 9579
TEST_TIME 96 9578
TEST_TIME 97 9559
TEST_TIME 98 9530
TEST_TIME 99 9516
TEST_TIME 100 9477
TEST_TIME 101 9423
TEST_TIME 102 9363
TEST_TIME 103 9386
TEST_TIME 104 9383
TEST_TIME 105 9396
TEST_TIME 106 9410
TEST_TIME 107 9387
TEST_TIME 108 9428
TEST_TIME 109 9445
TEST_TIME 110 9443
TEST_TIME 111 9438
TEST_TIME 112 9482
TEST_TIME 113 9515
TEST_TIME 114 9510
TEST_TIME 115 9486
TEST_TIME 116 9449
TEST_TIME 117 9411
TEST_TIME 118 9406
TEST_TIME 119 9380
TEST_TIME 120 9302

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2020 01:29:35 to 04-11-2020 01:29:38.

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 1553553 1553553 0 0.00 0 22709 7 0 0
doc_list_biud 1553552 1553552 0 0.00 0 32206 25 0 0
sp_add_invoice_to_stock 5190 5057 133 2.56 45 213725 20339 0 133
sp_cancel_adding_invoice 5642 5642 0 0.00 5 77432 810 0 0
sp_cancel_client_order 1772 1772 0 0.00 3 5061 340 0 0
sp_cancel_customer_reserve 556030 556030 0 0.00 1 32208 54 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 2 6190 84 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 3 7856 104 0 0
sp_cancel_supplier_invoice 6261 6243 18 0.28 2 21779 797 0 18
sp_cancel_supplier_order 424 424 0 0.00 7 767597 90704 0 0
sp_cancel_write_off 9544 9544 0 0.00 1 12088 108 0 0
sp_client_order 20803 20803 0 0.00 4 25742 373 0 0
sp_customer_reserve 473645 473645 0 0.00 0 91246 200 0 0
sp_fill_shopping_cart 31788 31788 0 0.00 1 25502 43 0 0
sp_fill_shopping_cart_clo_res 473640 473640 0 0.00 0 16806 14 0 0
sp_get_clo_for_invoice 5052 5052 0 0.00 0 32666 312 0 0
sp_kill_cost_storno 16280 16280 0 0.00 0 19432 56 0 0
sp_kill_qstorno_ret_qs2qd 1128271 1128271 0 0.00 0 32203 30 0 0
sp_kill_qty_storno 594869 594869 0 0.00 0 32206 64 0 0
sp_lock_selected_doc 20938 20938 0 0.00 0 10280 5 0 0
sp_make_cost_storno 28253 28253 0 0.00 0 22679 62 0 0
sp_multiply_rows_for_pdistr 28252 28252 0 0.00 0 18778 33 0 0
sp_multiply_rows_for_qdistr 20803 20803 0 0.00 0 14964 166 0 0
sp_pay_from_customer 7150 7150 0 0.00 4 9573 120 0 0
sp_pay_to_supplier 5888 5888 0 0.00 3 18878 138 0 0
sp_payment_common 13038 13038 0 0.00 1 11263 28 0 0
sp_qd_handle_on_cancel_clo 1772 1772 0 0.00 0 5052 316 0 0
sp_qd_handle_on_invoice_upd_sts 10694 10694 0 0.00 0 21068 322 0 0
sp_qd_handle_on_reserve_upd_sts 10162 10162 0 0.00 0 13314 53 0 0
sp_reserve_write_off 10163 10163 0 0.00 7 13844 183 0 0
sp_supplier_invoice 5573 5573 0 0.00 5 118886 3736 0 0
sp_supplier_order 5419 5419 0 0.00 5 32754 1379 0 0
srv_aggregate_perf_data 113 113 0 0.00 2661 55724 13824 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1165 140130 28262 0 0
srv_find_qd_qs_mism 1067149 1067149 0 0.00 0 18551 6 0 0
srv_make_invnt_saldo 556 556 0 0.00 52 24801 1064 0 0
srv_make_money_saldo 803 803 0 0.00 1 3862 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 137662 311467 209701 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5057 5057 0 0.00 0 19965 165 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 3759 109 0 0
t$perf-norm:sp_cancel_client_order 1772 1772 0 0.00 0 11898 21 0 0
t$perf-norm:sp_cancel_customer_reserve 641 641 0 0.00 0 2415 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 2749 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 881 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 593 13 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 16146 1401 0 0
t$perf-norm:sp_cancel_write_off 996 996 0 0.00 0 4077 14 0 0
t$perf-norm:sp_client_order 20803 20803 0 0.00 0 16541 18 0 0
t$perf-norm:sp_customer_reserve 1036 1036 0 0.00 0 17072 25 0 0
t$perf-norm:sp_pay_from_customer 7150 7150 0 0.00 0 4679 9 0 0
t$perf-norm:sp_pay_to_supplier 5888 5888 0 0.00 0 4777 10 0 0
t$perf-norm:sp_reserve_write_off 10163 10163 0 0.00 0 7998 11 0 0
t$perf-norm:sp_supplier_invoice 5573 5573 0 0.00 0 5481 19 0 0
t$perf-norm:sp_supplier_order 5419 5419 0 0.00 0 4152 15 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 799 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 7173 56 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 1563 25 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 894 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 846 229 0 0
v_add_invoice_to_stock 10368 10102 266 2.56 0 8118 20 0 266
v_all_customers 37608 37608 0 0.00 0 29 1 0 0
v_all_suppliers 30708 30708 0 0.00 0 23 1 0 0
v_all_wares 41606 41606 0 0.00 0 140 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 3128 15 0 0
v_cancel_client_order 3544 3544 0 0.00 0 3646 7 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 6160 8 0 0
v_cancel_customer_reserve 1282 1282 0 0.00 0 1993 9 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 3539 8 0 0
v_cancel_supplier_invoice 822 786 36 4.37 0 2038 20 0 36
v_cancel_supplier_order 848 848 0 0.00 0 1923 12 0 0
v_cancel_write_off 1992 1992 0 0.00 0 7896 24 0 0
v_max_id_clo_ord 5419 5419 0 0.00 0 395 1 0 0
v_max_id_clo_res 1036 1036 0 0.00 0 2786 12 0 0
v_max_id_ord_sup 5566 5566 0 0.00 0 5416 10 0 0
v_max_non_paid_invoice 1519 1519 0 0.00 0 6979 8 0 0
v_max_non_paid_realizn 3920 3920 0 0.00 0 2135 4 0 0
v_min_id_clo_ord 5419 5419 0 0.00 0 3855 10 0 0
v_min_id_clo_res 1036 1036 0 0.00 0 4560 7 0 0
v_min_id_ord_sup 5566 5566 0 0.00 0 6999 6 0 0
v_min_non_paid_invoice 5888 5888 0 0.00 0 8267 15 0 0
v_min_non_paid_realizn 7150 7150 0 0.00 0 7849 17 0 0
v_our_firm 10458 10458 0 0.00 0 26 1 0 0
v_reserve_write_off 20324 20324 0 0.00 0 6385 7 0 0
x_lock_depdocs_on_canc_invoice 11492 11492 0 0.00 0 19785 106 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 13227 366 0 0
x_make_qstorno_1000_1200 5419 5419 0 0.00 2 32748 1291 0 0
x_make_qstorno_1200_2000 5573 5573 0 0.00 2 118855 3580 0 0
x_make_qstorno_2100_3300 473645 473645 0 0.00 0 90572 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2020 01:29:39 to 04-11-2020 01:29:43.

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:04 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:10 31159 8192000000 10295172528 10608463872 994158048 10.822 76 57 114 1 1015121856 2833616 18130192
22:57:51 23450 8192000000 10346746432 10666586112 1395932096 14.559 100 89 178 0 1430903280 5265296 29705888
22:58:28 18473 8192000000 10386005008 10708459520 1435504592 14.910 100 89 178 0 1471217904 6318112 29395200
22:59:00 27989 8192000000 10400190576 10731204608 1458127248 15.109 100 87 174 1 1493917200 7371664 28418288
22:59:37 20731 8192000000 10436385456 10771812352 1488955248 15.380 100 86 172 2 1524030832 7976400 27099184
23:00:13 15998 8192000000 10464972944 10801790976 1517291232 15.627 100 86 172 0 1554046272 8972880 27782160
23:00:48 13941 8192000000 10481184752 10820481024 1537740336 15.804 100 87 175 1 1575237872 9820352 27677184
23:01:11 14652 8192000000 10493569792 10837299200 1553177168 15.937 100 81 162 0 1588296848 9862592 25257088
23:01:53 17505 8192000000 10548414496 10903236608 1596934624 16.313 100 75 150 0 1629536320 9779280 22822416
23:02:22 9740 8192000000 10563131744 10919497728 1620413968 16.513 100 84 168 0 1656289488 10524928 25350592
23:02:41 13665 8192000000 10584137232 10941902848 1644760560 16.720 100 78 156 1 1678661104 10675232 23225312
23:03:07 9118 8192000000 10595854128 10956591104 1661504832 16.862 100 84 168 1 1697999888 11641120 24853936
23:03:25 10264 8192000000 10617071488 10981392384 1676520688 16.988 100 77 150 4 1709662240 11151344 21990208
23:03:44 11266 8192000000 10634707712 11006066688 1698179616 17.170 100 82 164 0 1733698880 12002544 23516720
23:04:01 9477 8192000000 10663314464 11029782528 1712831504 17.292 100 83 166 1 1749160896 12610704 23718688
23:04:18 6087 8192000000 10663212432 11035074560 1727042096 17.411 100 78 158 0 1761655792 12194320 22419376
23:04:32 7694 8192000000 10680878464 11054383104 1737040960 17.494 100 77 154 0 1771623632 12369680 22212992
23:04:48 8314 8192000000 10691693776 11068444672 1755185984 17.645 100 84 168 1 1792420864 13181616 24053264
23:05:04 4309 8192000000 10702280928 11080421376 1760278336 17.687 100 79 155 0 1794696736 12910016 21508384
23:05:17 5216 8192000000 10704431040 11083071488 1768580304 17.755 100 79 158 1 1803660192 13210352 21869536
23:05:29 4444 8192000000 10714707136 11092029440 1774799600 17.807 100 83 166 0 1811645216 13391472 23454144
23:05:40 3593 8192000000 10723041232 11100622848 1780130832 17.851 100 87 174 0 1818277472 14037216 24109424
23:05:51 4066 8192000000 10737080784 11115819008 1794321040 17.967 100 84 168 0 1831468048 14481152 22665856
23:06:01 5497 8192000000 10742169152 11120455680 1801864096 18.029 100 82 162 1 1837828608 13923408 22041104
23:06:13 2682 8192000000 10747373760 11129499648 1805644480 18.060 100 85 170 2 1843756592 14163760 23948352
23:06:23 3494 8192000000 10758940080 11139514368 1813785120 18.127 100 89 177 1 1852930768 14219904 24925744
23:06:33 6687 8192000000 10749527808 11139465216 1817963872 18.161 100 81 162 1 1853645808 13222064 22459872
23:06:47 3333 8192000000 10767438320 11150213120 1823031648 18.202 100 85 166 1 1858848208 13293808 22522752
23:06:58 2763 8192000000 10783655792 11171332096 1841016368 18.349 100 88 174 1 1879258496 14305280 23936848
23:07:07 2501 8192000000 10788162208 11177340928 1845541904 18.386 100 83 166 0 1882404560 13073888 23788768
23:07:16 2467 8192000000 10792669120 11184041984 1851328272 18.433 100 82 164 1 1887461488 13207552 22925664
23:07:25 2272 8192000000 10793994192 11186323456 1858020336 18.487 100 92 184 1 1897843776 13784288 26039152
23:07:34 1791 8192000000 10805503024 11191132160 1858712576 18.493 100 95 189 4 1898615088 12882656 27019856
23:07:43 2352 8192000000 10807405152 11194126336 1860345328 18.506 100 93 185 1 1899289584 13309680 25634576
23:07:52 2416 8192000000 10806415392 11194748928 1865214688 18.546 100 91 180 2 1904309216 13283504 25811024
23:08:00 2178 8192000000 10809113472 11198439424 1865935712 18.551 100 91 182 0 1904984720 13997536 25051472
23:08:09 1799 8192000000 10813078080 11199438848 1863829424 18.534 100 93 187 0 1903282816 12805552 26647840
23:08:18 1898 8192000000 10814445024 11202064384 1867776464 18.566 100 96 192 1 1908383776 12817824 27789488
23:08:26 1836 8192000000 10815009568 11203371008 1870702736 18.590 100 88 176 2 1908843888 12778160 25362992
23:08:35 1312 8192000000 10816658688 11203534848 1871198720 18.594 100 95 190 1 1911624256 13113616 27311920
23:08:43 2183 8192000000 10818844848 11208503296 1869933808 18.584 100 84 169 0 1906289008 13115136 23240064
23:08:51 2133 8192000000 10816415664 11206533120 1870781232 18.591 100 85 170 1 1909778576 15202112 23795232
23:09:00 14688 8192000000 10799452928 11203133440 1869398336 18.579 100 75 144 1 1901803360 10502752 21902272
23:09:21 14624 8192000000 10795988048 11200937984 1868358160 18.571 100 47 94 0 1891390624 9920192 13112272
23:09:42 1785 8192000000 10820149600 11213352960 1878200880 18.651 100 92 185 1 1915000304 9752672 27046752
23:09:50 4164 8192000000 10805443872 11209900032 1874207200 18.618 100 53 106 0 1900353200 11704224 14441776
23:10:01 3166 8192000000 10795091616 11209244672 1872713664 18.606 100 57 117 0 1899044544 10512976 15817904
23:10:10 5370 8192000000 10797272928 11206152192 1873188912 18.610 100 49 97 2 1894793488 7984960 13619616
23:10:25 6504 8192000000 10786181728 11209220096 1874138448 18.618 100 27 54 1 1888884384 7368112 7377824
23:10:40 3770 8192000000 10813493344 11217793024 1883359808 18.692 100 55 109 0 1910489008 10738784 16390416
23:10:50 6036 8192000000 10772983728 11208376320 1876985568 18.641 100 31 62 0 1893498032 7668448 8844016
23:11:02 10506 8192000000 10798460512 11216748544 1883629504 18.694 100 39 76 3 1900749440 5613184 11506752
23:11:19 57547 8192000000 10809932320 11228790784 1890440720 18.749 100 44 88 0 1910658000 7429152 12788128
23:12:24 6522 8192000000 10797822032 11227967488 1887537856 18.726 100 28 56 1 1901839568 6496848 7804864
23:12:40 3730 8192000000 10812132960 11232686080 1890710560 18.752 100 44 88 0 1910142480 7026816 12405104
23:12:53 5886 8192000000 10810554624 11235377152 1891183376 18.755 100 36 72 0 1913760224 12953632 9623216
23:13:06 4768 8192000000 10805564640 11231617024 1893657056 18.775 100 36 72 4 1911110976 6366912 11087008
23:13:17 7028 8192000000 10815138928 11238952960 1890983648 18.754 100 27 54 1 1905346512 6414976 7947888
23:13:31 7200 8192000000 10810888064 11239809024 1896542672 18.798 100 35 70 2 1912615856 5809952 10263232
23:13:44 6413 8192000000 10805509968 11240157184 1899720128 18.824 100 26 53 2 1912933328 5426944 7786256
23:14:02 8722 8192000000 10820452672 11250352128 1904390880 18.862 100 20 40 1 1915444368 5325680 5727808
23:14:19 9821 8192000000 10822387456 11256107008 1906664912 18.880 100 17 34 0 1917300464 5672320 4963232
23:14:38 6272 8192000000 10817821184 11256590336 1910651664 18.912 100 17 32 1 1921843456 6011664 5180128
23:14:54 10449 8192000000 10828840432 11259600896 1912264096 18.925 100 25 50 1 1926131648 5421008 8446544
23:15:11 12160 8192000000 10831746368 11262918656 1910554832 18.911 100 17 35 0 1920809760 5642656 4612272
23:15:30 12769 8192000000 10816707664 11260780544 1910847536 18.913 100 14 28 1 1920583008 6069776 3665696
23:15:55 52919 8192000000 10842280256 11269345280 1920006160 18.987 100 43 83 3 1939111600 6045072 13060368
23:16:56 2533 8192000000 10840988864 11253063680 1907574848 18.887 100 47 90 6 1926425696 5567008 13283840
23:17:06 10642 8192000000 10789549776 11221106688 1864995952 18.544 98 30 61 1 1883653632 10614560 8043120
23:17:23 5220 8192000000 10813726144 11241316352 1896299424 18.797 100 21 42 0 1908586032 6241872 6044736
23:17:37 4027 8192000000 10824272720 11245584384 1889199584 18.739 99 36 70 1 1907324960 7588448 10536928
23:17:47 8257 8192000000 10816561728 11239002112 1895058208 18.787 100 28 54 1 1908383872 5431120 7894544
23:18:03 7076 8192000000 10774503792 11201540096 1835240640 18.302 97 27 54 2 1848825360 5971232 7613488
23:18:20 9560 8192000000 10775767216 11210190848 1839710608 18.338 98 21 42 1 1851839280 5836608 6292064
23:18:37 4568 8192000000 10736407136 11148021760 1815707712 18.143 98 22 44 2 1830848384 9641200 5499472
23:18:48 5468 8192000000 10707984672 11128795136 1775889776 17.816 98 21 41 3 1787733248 5958592 5884880
23:19:00 8044 8192000000 10733786496 11151056896 1783380896 17.877 98 15 31 1 1792522656 4844272 4297488
23:19:18 12242 8192000000 10727593584 11144187904 1779919472 17.849 97 15 30 3 1789517504 5502704 4095328
23:19:37 15373 8192000000 10724051808 11148337152 1751799616 17.617 95 17 34 0 1762450928 5911760 4739552
23:19:59 9547 8192000000 10700449712 11118043136 1758169920 17.669 97 35 70 0 1774097840 5595360 10332560
23:20:15 61621 8192000000 10705812912 11110932480 1698156768 17.170 94 26 52 0 1711743152 5233568 8352816
23:21:22 24091 8192000000 10711740464 11130986496 1747429680 17.580 96 21 42 0 1759032336 5739664 5862992
23:21:53 6424 8192000000 10755173408 11164319744 1822158592 18.195 100 35 70 1 1838611104 5786128 10666384
23:22:08 7393 8192000000 10724694048 11126812672 1747650944 17.582 96 24 48 2 1759514288 5244448 6618896
23:22:22 6500 8192000000 10729369952 11142045696 1807335408 18.074 100 32 64 0 1822092256 5503248 9253600
23:22:36 12348 8192000000 10730809568 11145932800 1768175920 17.752 97 25 48 2 1781099648 5866096 7057632
23:22:55 5085 8192000000 10739045472 11159855104 1807788384 18.078 99 30 60 2 1823666656 7364512 8513760
23:23:06 7525 8192000000 10725214704 11141521408 1782923600 17.874 98 35 69 2 1798158992 5435424 9799968
23:23:22 6149 8192000000 10744624784 11162746880 1823364752 18.205 100 32 64 0 1838313056 5145952 9802352
23:23:38 9040 8192000000 10752299296 11172986880 1835495296 18.304 100 21 41 0 1846202032 4873104 5833632
23:23:59 4342 8192000000 10750510352 11164520448 1813929920 18.128 99 19 38 2 1824607392 5073920 5603552
23:24:11 10727 8192000000 10764396624 11182739456 1836173488 18.310 100 22 44 0 1848383424 5420640 6789296
23:24:34 11465 8192000000 10752838448 11183628288 1846109904 18.391 100 19 38 3 1857103968 5395392 5598672
23:24:51 13535 8192000000 10763447008 11188400128 1850398016 18.425 100 13 26 1 1859604736 5555808 3650912
23:25:11 62747 8192000000 10785754752 11197575168 1861885456 18.519 100 36 70 2 1878162912 5084096 11193360
23:26:20 7774 8192000000 10772479136 11206356992 1866152960 18.553 100 35 70 0 1884206160 8297408 9755792
23:26:36 7790 8192000000 10777236864 11207163904 1867889216 18.567 100 18 35 1 1879600672 5689824 6021632
23:26:50 8029 8192000000 10783306160 11214065664 1869370592 18.579 100 26 53 2 1882293488 5745888 7177008
23:27:06 6536 8192000000 10819282240 11233579008 1888651680 18.735 100 50 100 2 1909146400 5434864 15059856
23:27:20 29937 8192000000 10827342048 11243323392 1905316752 18.869 100 55 110 2 1928882528 7345184 16220592
23:27:59 26536 8192000000 10841159840 11259580416 1910529520 18.911 100 55 108 2 1935449712 9806064 15114128
23:28:35 13843 8192000000 10856947120 11274141696 1922645904 19.008 100 56 110 3 1949101296 11131056 15324336
23:29:02 22259 8192000000 10865038480 11280474112 1931082224 19.076 100 56 110 2 1958267216 11393248 15791744
23:29:54 36466 8192000000 10858665328 11291512832 1936739584 19.121 100 35 69 4 1957381232 10273616 10368032
23:30:38 12667 8192000000 10871681040 11299733504 1948358816 19.213 100 48 96 1 1972596192 9258320 14979056
23:31:04 22993 8192000000 10889999200 11319431168 1956609584 19.279 100 40 76 1 1979931904 11336992 11985328
23:31:35 21783 8192000000 10888963600 11322339328 1963998400 19.338 100 44 86 1 1987993088 11286192 12708496
23:32:03 7982 8192000000 10900920208 11332059136 1966890320 19.361 100 48 96 0 1997573168 16614048 14068800
23:32:19 11118 8192000000 10907834160 11334135808 1970198288 19.387 100 54 106 3 1999187504 13060416 15928800
23:32:48 35253 8192000000 10912578176 11346284544 1974134288 19.418 100 41 82 0 2001074528 14619024 12321216
23:33:33 6434 8192000000 10904054848 11344801792 1976489152 19.437 100 38 71 3 2000858224 13918960 10450112
23:33:50 5961 8192000000 10927069136 11350036480 1982556912 19.485 100 72 144 0 2019342368 15069008 21716448
23:34:07 2618 8192000000 10933464976 11352223744 1983859616 19.495 100 82 161 0 2023425072 15994048 23571408
23:34:26 10639 8192000000 10915419744 11351564288 1978990672 19.457 100 50 100 1 2012694160 18720208 14983280
23:35:01 14063 8192000000 10920847024 11356143616 1980122096 19.466 100 46 92 0 2013125312 18598672 14404544
23:35:23 4022 8192000000 10935324624 11362742272 1987325936 19.523 100 59 118 1 2024915552 18814704 18774912
23:35:35 5811 8192000000 10929865056 11361943552 1983074224 19.489 100 49 99 0 2019175808 20736240 15365344
23:35:50 13727 8192000000 10937179168 11371708416 1988145376 19.529 100 57 111 2 2024322144 19230880 16945888
23:36:18 8658 8192000000 10941632464 11375013888 1992044016 19.560 100 54 108 1 2027873856 19514720 16315120
23:36:34 2520 8192000000 10957396784 11375529984 1998467184 19.611 100 81 159 2 2041538784 18749424 24322176
23:36:46 1920 8192000000 10957412928 11379134464 1998682976 19.612 100 81 161 0 2042561824 19501216 24377632
23:36:55 2999 8192000000 10957512640 11376660480 2000286656 19.625 100 72 144 1 2041687600 20268480 21132464
23:37:05 1858 8192000000 10958695232 11384623104 2001355280 19.633 100 81 162 1 2045176080 20202944 23617856
23:37:14 2558 8192000000 10951388016 11380961280 2002098720 19.639 100 75 147 2 2041875888 18102768 21674400
23:37:24 4856 8192000000 10955714080 11383894016 2006068624 19.671 100 77 154 0 2045517008 16729552 22718832
23:37:47 8347 8192000000 10953333088 11387351040 2005020960 19.662 100 66 132 0 2042446704 18111232 19314512
23:38:04 8087 8192000000 10946397120 11383889920 2003269168 19.649 100 57 113 1 2035828912 16176768 16382976
23:38:26 8224 8192000000 10960098624 11393425408 2008140688 19.687 100 58 115 2 2041583024 16432224 17010112
23:38:42 1164 8192000000 10954195600 11383869440 1993484880 19.571 99 66 130 2 2027975744 15432528 19058336
23:38:52 14838 8192000000 10939418832 11374645248 1951529408 19.239 97 62 123 0 1986681488 17064528 18087552
23:39:23 2590 8192000000 10934324608 11363262464 1982947344 19.488 99 66 131 1 2020817840 18184976 19685520
23:39:32 4053 8192000000 10952129744 11383025664 2000026640 19.623 100 71 143 3 2040794448 19419824 21347984
23:39:44 2174 8192000000 10951903152 11373481984 1993352016 19.570 100 86 171 2 2039345856 20228336 25765504
23:39:53 5091 8192000000 10956190752 11382095872 1997841520 19.606 100 72 144 1 2041213488 22090752 21281216
23:40:04 4451 8192000000 10959088384 11380776960 1996643472 19.596 100 76 151 1 2039436464 20793056 21999936
23:40:15 2675 8192000000 10960326672 11381432320 1987786784 19.526 99 89 173 0 2035057040 21335008 25935248
23:40:25 5099 8192000000 10960266208 11383930880 2002222768 19.640 100 75 149 0 2045169536 21100320 21846448
23:40:39 8270 8192000000 10960359184 11388055552 2001499744 19.635 100 68 134 1 2043083872 22506128 19078000
23:40:54 7127 8192000000 10952159696 11388440576 1983251488 19.490 99 62 124 1 2024396944 22859920 18285536
23:41:13 5683 8192000000 10931143536 11368787968 1966052528 19.354 99 45 89 0 2000980912 20827600 14100784
23:41:26 4101 8192000000 10937808608 11369840640 1968666640 19.375 99 57 112 2 2007429760 21009360 17753760
23:41:43 3516 8192000000 10927293696 11364016128 1979237808 19.459 100 55 109 2 2018138176 22422192 16478176
23:42:04 2006 8192000000 10950579008 11376697344 1991603760 19.556 100 71 140 1 2033465904 20761456 21100688
23:42:12 5654 8192000000 10949110048 11378880512 1988936736 19.535 100 66 132 0 2031402896 22781584 19684576
23:42:27 1779 8192000000 10967252208 11379257344 1994924848 19.583 100 78 155 3 2041301488 23543776 22832864
23:42:35 2632 8192000000 10960347024 11374710784 1974132176 19.418 99 85 169 0 2026091248 25983056 25976016
23:42:45 1588 8192000000 10964069040 11381170176 1990208800 19.545 100 85 171 3 2042556992 25981168 26367024
23:42:53 3796 8192000000 10979488720 11390480384 2001932320 19.638 100 90 178 1 2056920352 27875824 27112208
23:43:04 1389 8192000000 10939380240 11357855744 1935728688 19.113 97 82 164 2 1988761200 28145440 24887072
23:43:18 4262 8192000000 10924143456 11352326144 1967812368 19.368 100 64 126 0 2013747344 26929248 19005728
23:43:30 4500 8192000000 10935928832 11358121984 1974169968 19.419 100 58 114 2 2015882304 24679232 17033104
23:43:42 6333 8192000000 10922858928 11358539776 1959252912 19.300 99 51 102 3 2000334896 25221248 15860736
23:43:55 4625 8192000000 10948257424 11364536320 1971291760 19.396 100 70 140 0 2018418240 25026256 22100224
23:44:07 3964 8192000000 10934179840 11352621056 1969660288 19.383 99 82 162 1 2020841904 26451984 24729632
23:44:19 3281 8192000000 10950638560 11361054720 1967558096 19.366 99 83 166 2 2021541744 28121520 25862128
23:44:28 2421 8192000000 10955337184 11368185856 1977583168 19.446 100 83 166 1 2034177968 30629088 25965712
23:44:40 3618 8192000000 10962971072 11376193536 1984032064 19.497 100 87 174 3 2041794960 31111968 26650928
23:44:51 2775 8192000000 10960706720 11369115648 1981735968 19.478 100 89 178 3 2039409408 31106400 26567040
23:45:02 14483 8192000000 10943918800 11363610624 1959101424 19.299 99 73 145 0 2011858912 30677232 22080256
23:45:25 2459 8192000000 10932428944 11338076160 1935146784 19.108 99 85 170 1 1996302320 34309680 26845856
23:45:34 3783 8192000000 10930155616 11346812928 1950633216 19.232 100 73 146 0 2009896080 35861344 23401520
23:45:45 2301 8192000000 10930731920 11339718656 1940679040 19.152 99 88 174 5 2005489120 36477712 28332368
23:45:55 1296 8192000000 10906962608 11313283072 1927625776 19.048 99 83 166 4 1987635360 33759136 26250448
23:46:05 5905 8192000000 10906101680 11321864192 1908131648 18.892 98 63 126 0 1960291248 32021424 20138176
23:46:17 4769 8192000000 10924872032 11339042816 1949394784 19.222 100 75 148 1 2004973632 32616272 22962576
23:46:28 6008 8192000000 10948604256 11363713024 1966332832 19.356 100 75 148 0 2025416672 36224032 22859808
23:46:41 17561 8192000000 10933755648 11370602496 1967332928 19.364 100 57 114 1 2025899840 40785056 17781856
23:47:17 4985 8192000000 10926567600 11350360064 1949267264 19.221 99 51 99 1 1994455728 29880416 15308048
23:47:29 7833 8192000000 10942800992 11363737600 1971512720 19.397 100 76 150 3 2028960416 34823248 22624448
23:47:46 4384 8192000000 10932811056 11364683776 1969635728 19.383 100 52 102 2 2018270016 32382352 16251936
23:47:57 5785 8192000000 10936193120 11369316352 1973006992 19.409 100 49 96 1 2021317120 32885872 15424256
23:48:10 7159 8192000000 10943354288 11375534080 1975257840 19.427 100 52 100 2 2023024192 32201392 15564960
23:48:25 3834 8192000000 10926669136 11351412736 1952970032 19.250 100 55 109 1 2002668496 32458896 17239568
23:48:40 3285 8192000000 10910600144 11333984256 1929090944 19.060 99 56 113 2 1980844080 33358048 18395088
23:48:59 17380 8192000000 10905284720 11346866176 1931196224 19.076 99 28 56 1 1974534320 33412096 9926000
23:49:25 8430 8192000000 10916678704 11351662592 1938983008 19.139 99 44 89 0 1988900384 35865264 14052112
23:49:55 11036 8192000000 10883877680 11319103488 1909856896 18.905 99 39 77 0 1958197760 35834304 12506560
23:50:13 4052 8192000000 10890201600 11325104128 1926918128 19.042 100 45 89 4 1978718208 37251232 14548848
23:50:25 12723 8192000000 10891938784 11340341248 1938309264 19.133 100 35 70 1 1985516352 34499040 12708048
23:50:45 6002 8192000000 10886948128 11319734272 1926460304 19.039 99 46 93 4 1968452336 28139360 13852672
23:50:58 14667 8192000000 10882548912 11333156864 1939933536 19.146 100 31 62 0 1977277216 27617392 9726288
23:51:27 19435 8192000000 10898157936 11335634944 1932615856 19.088 100 32 64 2 1975421616 32779584 10026176
23:51:53 20712 8192000000 10887369648 11335794688 1915902448 18.954 99 27 54 0 1960277536 35814816 8560272
23:52:27 20959 8192000000 10877012064 11338883072 1923966256 19.019 100 21 42 2 1972062416 40829280 7266880
23:53:01 18224 8192000000 10878091424 11334844416 1910433824 18.910 99 30 60 1 1954256720 34056464 9766432
23:53:28 27992 8192000000 10877246832 11326025728 1901890176 18.841 99 18 36 0 1945581056 37271120 6419760
23:54:09 26958 8192000000 10876517408 11324551168 1924041744 19.019 100 25 50 0 1962289680 30239376 8008560
23:54:43 25554 8192000000 10884818560 11342061568 1928142576 19.052 100 26 50 4 1966868048 30977968 7747504
23:55:15 55527 8192000000 10872682912 11349798912 1908305008 18.893 99 11 22 0 1936233088 24808288 3119792
23:56:28 49421 8192000000 10882195952 11336384512 1901551600 18.839 98 11 20 1 1916827840 12130368 3145872
23:57:38 27977 8192000000 10903187344 11354714112 1961289376 19.316 100 20 39 2 1986685184 19211216 6184592
23:58:26 65530 8192000000 10893072560 11357437952 1921380672 18.998 98 11 22 0 1945711568 20942048 3388848
23:59:40 54538 8192000000 10842026144 11297853440 1795691776 17.979 92 12 23 1 1807974512 9210192 3072544
00:00:47 52601 8192000000 10883717856 11309948928 1901644720 18.840 98 37 71 0 1922278016 10703520 9929776
00:01:54 53565 8192000000 10858208576 11306041344 1881511984 18.677 97 25 51 1 1900982624 11840976 7629664
00:02:54 140129 8192000000 10887836256 11339018240 1936691040 19.120 100 27 54 1 1958305312 13952112 7662160
00:05:23 57202 8192000000 10919125424 11359895552 1966095536 19.354 100 42 84 0 1990421648 12741984 11584128
00:06:32 93920 8192000000 10913793696 11363459072 1959291056 19.300 99 42 84 4 1983760256 12927840 11541360
00:08:12 12451 8192000000 10898606000 11356397568 1964645232 19.343 100 30 59 1 1984409392 11203536 8560624
00:08:32 50965 8192000000 10911831872 11372240896 1974401136 19.420 100 20 40 2 1994801264 14432368 5967760
00:09:34 47031 8192000000 10912865776 11370295296 1944176784 19.180 98 34 68 0 1968655984 14032240 10446960
00:10:32 12192 8192000000 10913364160 11377119232 1985026240 19.504 100 48 97 1 2013458128 14994224 13437664
00:11:44 26232 8192000000 10901782016 11385159680 1975561136 19.430 100 6 12 0 1994126496 16983184 1582176
00:12:23 13262 8192000000 10905355840 11386335232 1979655696 19.462 100 7 14 0 1997913792 16509696 1748400
00:12:42 10624 8192000000 10902965600 11370684416 1957956512 19.290 99 9 18 1 1979339616 18721888 2661216
00:13:01 27419 8192000000 10907297616 11381067776 1976337392 19.436 100 8 16 1 1994575248 15652320 2585536
00:13:36 3791 8192000000 10903116080 11382095872 1978615968 19.454 100 15 30 1 2000175456 17058288 4501200
00:13:46 7583 8192000000 10905093728 11385892864 1978442016 19.452 100 6 12 0 1998264064 18247344 1574704
00:14:00 1248 8192000000 10904376160 11388485632 1978520896 19.453 100 6 12 0 1994223264 14043584 1658784
00:14:08 1548 8192000000 10905527376 11392573440 1980731120 19.470 100 6 12 0 1998990256 16600624 1658512
00:14:15 2051 8192000000 10912721104 11388370944 1984617120 19.501 100 13 26 1 2002641584 14084816 3939648
00:14:23 18548 8192000000 10880898208 11359412224 1923026944 19.011 97 11 22 0 1935904160 9859376 3017840
00:16:27 61076 8192000000 10902945872 11368718336 1973705136 19.415 100 26 52 1 1995971040 14672592 7593312
00:17:35 22522 8192000000 10890528784 11379752960 1973795440 19.416 100 9 18 1 1989643488 13168400 2679648
00:18:04 47544 8192000000 10909306000 11361447936 1945420320 19.190 98 28 56 1 1960390128 7067104 7902704
00:18:58 46611 8192000000 10904387504 11377602560 1977199008 19.443 100 22 44 2 1992268608 8838656 6230944
00:19:57 53156 8192000000 10902760496 11358257152 1890462928 18.750 96 12 24 0 1904941536 10943520 3535088
00:20:57 58290 8192000000 10878995328 11358613504 1924282032 19.021 98 18 36 0 1945018880 14788608 5948240
00:22:04 82765 8192000000 10902583344 11366621184 1936506672 19.119 98 14 28 0 1950195552 9262896 4425984
00:23:36 45917 8192000000 10925329872 11380199424 1981790192 19.479 100 21 42 2 2000215504 12066144 6359168
00:24:32 39027 8192000000 10909822464 11380592640 1964390256 19.341 99 27 54 1 1985154000 13075376 7688368
00:25:17 94358 8192000000 10906195872 11375616000 1923534864 19.015 97 25 50 0 1947851600 17075472 7241264
00:27:00 52075 8192000000 10922430400 11379363840 1958246288 19.292 99 10 20 0 1973082864 12393680 2442896
00:28:38 47809 8192000000 10916700944 11384184832 1971638640 19.398 99 18 36 1 1991311040 15169488 4502912
00:30:03 55357 8192000000 10900137664 11362607104 1926091584 19.036 97 20 40 0 1942817552 11189488 5536480
00:31:09 38131 8192000000 10910305680 11373010944 1971962672 19.401 99 45 89 1 1995761648 11160304 12638672
00:31:57 40571 8192000000 10903528336 11369279488 1905608064 18.871 96 25 50 1 1925304160 12342080 7354016
00:32:50 61156 8192000000 10874308896 11355402240 1888330064 18.732 96 18 36 1 1909594848 16114192 5150592
00:34:00 121353 8192000000 10878640208 11328008192 1856928832 18.478 95 22 44 1 1874961008 11721168 6311008
00:36:22 53521 8192000000 10832537584 11284426752 1819368192 18.173 94 22 44 0 1842100304 16535936 6196176
00:39:36 43561 8192000000 10848145232 11320770560 1931746880 19.081 100 17 34 0 1945808400 9286784 4774736
00:40:27 55874 8192000000 10833054400 11310202880 1860087472 18.504 96 11 22 0 1871741264 8668352 2985440
00:41:34 57291 8192000000 10830907200 11301167104 1806598848 18.068 94 21 42 0 1820151136 7844048 5708240
00:44:05 98576 8192000000 10889435424 11355230208 1947409424 19.206 100 26 52 0 1968565920 13335856 7820640
00:46:32 64500 8192000000 10893340464 11368034304 1939414928 19.142 99 15 30 0 1969531168 25530544 4585696
00:47:47 56646 8192000000 10889091072 11355078656 1931984576 19.083 99 12 24 1 1964681600 28609952 4087072
00:49:32 41409 8192000000 10860015072 11317837824 1916280288 18.957 98 18 36 1 1933687040 12261056 5145696
00:50:19 65287 8192000000 10859132128 11326222336 1886850432 18.720 97 17 34 0 1905107920 13243936 5013552
00:51:31 52354 8192000000 10874316528 11339128832 1918596336 18.976 99 30 56 2 1941484672 14448864 8439472
00:53:13 41951 8192000000 10887060752 11342061568 1946318816 19.197 100 29 57 2 1970539200 16140992 8079392
00:54:17 33299 8192000000 10879909760 11356450816 1947568176 19.207 100 19 38 1 1964530432 11925888 5036368
00:54:56 45290 8192000000 10870014944 11349291008 1927940704 19.050 99 4 8 0 1942361376 13404912 1015760
00:55:58 61740 8192000000 10895880272 11340230656 1911864352 18.922 98 30 60 0 1929067200 9296384 7906464
00:57:08 14443 8192000000 10899371920 11341172736 1938265840 19.133 99 45 93 0 1964070304 13360352 12444112
00:57:29 58397 8192000000 10884147472 11346264064 1921506800 18.999 98 38 76 0 1951912512 20094416 10311296
00:58:35 41333 8192000000 10888943168 11340525568 1915061296 18.947 98 16 32 0 1928367344 9496736 3809312
00:59:26 29410 8192000000 10904421776 11349110784 1943416672 19.174 99 42 83 2 1964278752 9676640 11185440
01:00:05 18740 8192000000 10898816784 11348606976 1933261056 19.093 99 42 84 0 1957261040 12465008 11534976
01:00:33 67463 8192000000 10874789264 11339579392 1931898368 19.082 99 28 56 3 1955611264 15848064 7864832
01:02:00 80236 8192000000 10877371664 11343585280 1937890304 19.130 99 38 76 2 1965315664 16446432 10978928
01:03:52 37495 8192000000 10859301584 11347894272 1950124848 19.227 100 21 42 1 1967016256 11233008 5658400
01:05:44 78051 8192000000 10872904208 11357233152 1958923008 19.297 100 9 18 0 1969346736 7876448 2547280
01:07:20 56493 8192000000 10892595360 11363766272 1956265568 19.276 99 12 23 0 1965699504 6663760 2770176
01:08:26 83646 8192000000 10881772848 11355156480 1935138480 19.108 98 15 30 1 1947788944 8643568 4006896
01:09:57 105516 8192000000 10886755584 11356643328 1911143104 18.916 97 12 24 0 1924770544 10227952 3399488
01:12:02 32954 8192000000 10899466608 11364237312 1950156512 19.228 99 23 47 2 1964900608 7458352 7285744
01:12:44 43650 8192000000 10881044368 11347996672 1911553648 18.919 97 11 20 0 1925291184 10753200 2984336
01:13:38 59155 8192000000 10890635184 11360010240 1944853248 19.185 99 12 24 1 1958948352 10402864 3692240
01:14:44 77421 8192000000 10919532752 11387297792 1948589808 19.215 99 15 29 2 1964805264 11580960 4634496
01:16:07 80945 8192000000 10901932832 11372945408 1925164944 19.028 97 13 26 0 1939120864 10165904 3790016
01:18:01 46924 8192000000 10907616192 11376939008 1961601488 19.319 99 21 42 1 1982142064 14081840 6458736
01:18:55 35305 8192000000 10922005536 11387719680 1955263408 19.268 98 36 72 3 1976108800 10669872 10175520
01:19:42 57969 8192000000 10926087952 11394658304 1967799680 19.368 99 28 56 0 1991896032 16049856 8046496
01:20:53 80589 8192000000 10895784544 11351248896 1908835648 18.897 96 24 47 1 1926603712 11333216 6434848
01:22:21 21853 8192000000 10906737360 11357896704 1900327296 18.829 96 33 65 0 1918109888 9085744 8696848
01:22:54 46420 8192000000 10874437600 11321618432 1852887872 18.446 95 38 76 1 1878820000 14906624 11025504
01:24:01 98360 8192000000 10873265216 11332337664 1923557136 19.015 99 32 62 1 1943117408 10694848 8865424
01:27:00 11099 8192000000 9415152896 9714233344 573457056 6.542 30 3 3 1 577200240 2996848 746336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-11-2020 01:29:45 to 04-11-2020 01:30:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 133 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-11-2020 01:30:18 to 04-11-2020 01:30:20.

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          235898
MON$OLDEST_ACTIVE               235899
MON$OLDEST_SNAPSHOT             235899
MON$NEXT_TRANSACTION            235899
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                       2023616
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33384 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33384 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33384 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33384 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 ---
:45: 
:46: mscs-test-161.budzdorov.ru    Wed Nov  4 01:27:32 2020
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

04.11.20 01:30:21. 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
2020-11-04 01:30:24 No severe PSQL-related problems occured
04.11.20 01:30:25. End of report.