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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17400028 kB
MemAvailable 31416568 kB
Buffers 0 kB
Cached 14264432 kB
SwapCached 2912 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-11 01:27:01
DTS_END                         2020-11-11 01:27:01.1560
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48902
TRN_ID                          243114
ATT_ID                          694
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: 9338.89 25038 1120667
customer order: creation 171.21 408 20545
customer order: refuse 14.24 326 1709
order to supplier: creation 45.16 1420 5419
order to supplier: removal 3.44 99675 413
invoice (draft): creation 45.38 3525 5446
invoice (draft): removal 53.83 773 6459
invoice accept: apply 41.33 19138 4959
invoice accept: cancel 48.20 818 5784
customer reserve: creation 3857.88 188 462946
customer reserve: removal 4759.81 55 571177
realization accept: apply 82.46 184 9895
realization accept: cancel 85.75 115 10290
payment from customer: creation 59.47 132 7136
payment from customer: removal 5.92 66 710
payment to supplier: creation 48.88 156 5865
payment to supplier: removal 3.75 103 450
service: total inventory turnovers 5.07 836 608
service: total monetary turnovers 6.32 51 758
service: aggregate perf. data 0.78 22220 94
service: refresh index statistics 0.03 350565 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2020 01:27:46 to 11-11-2020 01:27:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4106
TEST_TIME 2 3620
TEST_TIME 3 3729
TEST_TIME 4 4832
TEST_TIME 5 4852
TEST_TIME 6 5540
TEST_TIME 7 6103
TEST_TIME 8 6500
TEST_TIME 9 6491
TEST_TIME 10 6549
TEST_TIME 11 6755
TEST_TIME 12 6735
TEST_TIME 13 6809
TEST_TIME 14 6885
TEST_TIME 15 7115
TEST_TIME 16 7166
TEST_TIME 17 7780
TEST_TIME 18 8126
TEST_TIME 19 8421
TEST_TIME 20 8753
TEST_TIME 21 8682
TEST_TIME 22 9120
TEST_TIME 23 9100
TEST_TIME 24 9136
TEST_TIME 25 9335
TEST_TIME 26 9568
TEST_TIME 27 9642
TEST_TIME 28 10504
TEST_TIME 29 10486
TEST_TIME 30 10634
TEST_TIME 31 10692
TEST_TIME 32 10475
TEST_TIME 33 10247
TEST_TIME 34 10384
TEST_TIME 35 10153
TEST_TIME 36 10001
TEST_TIME 37 9908
TEST_TIME 38 9865
TEST_TIME 39 9872
TEST_TIME 40 9787
TEST_TIME 41 9703
TEST_TIME 42 9662
TEST_TIME 43 9622
TEST_TIME 44 9471
TEST_TIME 45 9428
TEST_TIME 46 9393
TEST_TIME 47 9356
TEST_TIME 48 9421
TEST_TIME 49 9433
TEST_TIME 50 9368
TEST_TIME 51 9443
TEST_TIME 52 9453
TEST_TIME 53 9390
TEST_TIME 54 9371
TEST_TIME 55 9577
TEST_TIME 56 9612
TEST_TIME 57 9700
TEST_TIME 58 9639
TEST_TIME 59 9716
TEST_TIME 60 9656
TEST_TIME 61 9537
TEST_TIME 62 9553
TEST_TIME 63 9534
TEST_TIME 64 9459
TEST_TIME 65 9410
TEST_TIME 66 9367
TEST_TIME 67 9306
TEST_TIME 68 9377
TEST_TIME 69 9348
TEST_TIME 70 9373
TEST_TIME 71 9431
TEST_TIME 72 9391
TEST_TIME 73 9389
TEST_TIME 74 9393
TEST_TIME 75 9531
TEST_TIME 76 9513
TEST_TIME 77 9505
TEST_TIME 78 9513
TEST_TIME 79 9603
TEST_TIME 80 9556
TEST_TIME 81 9468
TEST_TIME 82 9378
TEST_TIME 83 9429
TEST_TIME 84 9357
TEST_TIME 85 9387
TEST_TIME 86 9402
TEST_TIME 87 9431
TEST_TIME 88 9465
TEST_TIME 89 9425
TEST_TIME 90 9431
TEST_TIME 91 9490
TEST_TIME 92 9527
TEST_TIME 93 9526
TEST_TIME 94 9596
TEST_TIME 95 9569
TEST_TIME 96 9582
TEST_TIME 97 9576
TEST_TIME 98 9564
TEST_TIME 99 9532
TEST_TIME 100 9485
TEST_TIME 101 9469
TEST_TIME 102 9440
TEST_TIME 103 9388
TEST_TIME 104 9354
TEST_TIME 105 9338
TEST_TIME 106 9322
TEST_TIME 107 9308
TEST_TIME 108 9291
TEST_TIME 109 9267
TEST_TIME 110 9260
TEST_TIME 111 9226
TEST_TIME 112 9272
TEST_TIME 113 9348
TEST_TIME 114 9388
TEST_TIME 115 9412
TEST_TIME 116 9422
TEST_TIME 117 9416
TEST_TIME 118 9405
TEST_TIME 119 9422
TEST_TIME 120 9344

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-11-2020 01:27:50 to 11-11-2020 01:27:53.

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 1549868 1549868 0 0.00 0 22746 6 0 0
doc_list_biud 1549868 1549868 0 0.00 0 62632 26 0 0
sp_add_invoice_to_stock 5060 4959 101 1.99 30 224862 19138 0 101
sp_cancel_adding_invoice 5784 5784 0 0.00 2 103030 819 0 0
sp_cancel_client_order 1709 1709 0 0.00 4 21763 326 0 0
sp_cancel_customer_reserve 571177 571177 0 0.00 1 62633 56 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 2 4729 66 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 3 7383 104 0 0
sp_cancel_supplier_invoice 6467 6459 8 0.12 2 29467 774 0 8
sp_cancel_supplier_order 413 413 0 0.00 8 868491 99676 0 0
sp_cancel_write_off 10290 10290 0 0.00 1 17063 116 0 0
sp_client_order 20545 20545 0 0.00 4 31340 408 0 0
sp_customer_reserve 462946 462946 0 0.00 0 61243 188 0 0
sp_fill_shopping_cart 31408 31408 0 0.00 1 15201 36 0 0
sp_fill_shopping_cart_clo_res 462934 462934 0 0.00 0 18640 13 0 0
sp_get_clo_for_invoice 4947 4947 0 0.00 0 21673 288 0 0
sp_kill_cost_storno 17234 17234 0 0.00 0 13199 60 0 0
sp_kill_qstorno_ret_qs2qd 1159516 1159516 0 0.00 0 62628 30 0 0
sp_kill_qty_storno 610673 610673 0 0.00 0 62631 66 0 0
sp_lock_selected_doc 20606 20606 0 0.00 0 8256 5 0 0
sp_make_cost_storno 27842 27842 0 0.00 0 18893 60 0 0
sp_multiply_rows_for_pdistr 27842 27842 0 0.00 0 22722 33 0 0
sp_multiply_rows_for_qdistr 20545 20545 0 0.00 0 19517 185 0 0
sp_pay_from_customer 7136 7136 0 0.00 4 20842 132 0 0
sp_pay_to_supplier 5865 5865 0 0.00 4 22755 157 0 0
sp_payment_common 13001 13001 0 0.00 1 20907 38 0 0
sp_qd_handle_on_cancel_clo 1709 1709 0 0.00 0 21755 300 0 0
sp_qd_handle_on_invoice_upd_sts 10730 10730 0 0.00 0 31578 349 0 0
sp_qd_handle_on_reserve_upd_sts 9895 9895 0 0.00 0 18319 58 0 0
sp_reserve_write_off 9895 9895 0 0.00 6 22698 185 0 0
sp_supplier_invoice 5446 5446 0 0.00 7 107578 3526 0 0
sp_supplier_order 5419 5419 0 0.00 5 34717 1420 0 0
srv_aggregate_perf_data 94 94 0 0.00 2546 308596 22221 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1285 131088 31119 0 0
srv_find_qd_qs_mism 1073191 1073191 0 0.00 0 20818 5 0 0
srv_make_invnt_saldo 608 608 0 0.00 25 32715 836 0 0
srv_make_money_saldo 758 758 0 0.00 0 14877 52 0 0
srv_recalc_idx_stat 4 4 0 0.00 283168 393250 350565 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4959 4959 0 0.00 0 22462 208 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 0 4976 110 0 0
t$perf-norm:sp_cancel_client_order 1709 1709 0 0.00 0 2537 17 0 0
t$perf-norm:sp_cancel_customer_reserve 672 672 0 0.00 0 2126 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 1662 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 529 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 2680 17 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 17990 1672 0 0
t$perf-norm:sp_cancel_write_off 1018 1018 0 0.00 0 2446 8 0 0
t$perf-norm:sp_client_order 20545 20545 0 0.00 0 12401 17 0 0
t$perf-norm:sp_customer_reserve 1032 1032 0 0.00 0 4432 16 0 0
t$perf-norm:sp_pay_from_customer 7136 7136 0 0.00 0 17075 14 0 0
t$perf-norm:sp_pay_to_supplier 5865 5865 0 0.00 0 6367 8 0 0
t$perf-norm:sp_reserve_write_off 9895 9895 0 0.00 0 19137 14 0 0
t$perf-norm:sp_supplier_invoice 5446 5446 0 0.00 0 7069 26 0 0
t$perf-norm:sp_supplier_order 5419 5419 0 0.00 0 24363 21 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 43 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 3770 31 0 0
t$perf-norm:srv_make_invnt_saldo 608 608 0 0.00 0 1550 18 0 0
t$perf-norm:srv_make_money_saldo 758 758 0 0.00 0 4488 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10094 9892 202 2.00 0 6292 20 0 202
v_all_customers 37680 37680 0 0.00 0 17 1 0 0
v_all_suppliers 29986 29986 0 0.00 0 14 1 0 0
v_all_wares 41090 41090 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 1813 10 0 0
v_cancel_client_order 3418 3418 0 0.00 0 1554 6 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 4708 6 0 0
v_cancel_customer_reserve 1344 1344 0 0.00 0 1667 8 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 7352 13 0 0
v_cancel_supplier_invoice 814 798 16 1.96 0 3252 19 0 16
v_cancel_supplier_order 826 826 0 0.00 0 8321 18 0 0
v_cancel_write_off 2036 2036 0 0.00 0 2624 15 0 0
v_max_id_clo_ord 5419 5419 0 0.00 0 701 1 0 0
v_max_id_clo_res 1032 1032 0 0.00 0 1375 11 0 0
v_max_id_ord_sup 5443 5443 0 0.00 0 5835 4 0 0
v_max_non_paid_invoice 1734 1734 0 0.00 0 3815 6 0 0
v_max_non_paid_realizn 3671 3671 0 0.00 0 1091 3 0 0
v_min_id_clo_ord 5419 5419 0 0.00 0 5540 10 0 0
v_min_id_clo_res 1032 1032 0 0.00 0 5088 16 0 0
v_min_id_ord_sup 5443 5443 0 0.00 0 5787 7 0 0
v_min_non_paid_invoice 5865 5865 0 0.00 0 20896 28 0 0
v_min_non_paid_realizn 7136 7136 0 0.00 0 20797 26 0 0
v_our_firm 10340 10340 0 0.00 0 16 1 0 0
v_reserve_write_off 19790 19790 0 0.00 0 7382 9 0 0
x_lock_depdocs_on_canc_invoice 11844 11844 0 0.00 0 23796 122 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 14288 407 0 0
x_make_qstorno_1000_1200 5419 5419 0 0.00 1 34700 1346 0 0
x_make_qstorno_1200_2000 5446 5446 0 0.00 3 107423 3394 0 0
x_make_qstorno_2100_3300 462946 462946 0 0.00 0 61240 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2020 01:27:54 to 11-11-2020 01:27:58.

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 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:11 23707 8192000000 10262718832 10571862016 1010249536 10.978 77 68 137 0 1035934240 3004496 22680208
22:57:42 37722 8192000000 10360963104 10682458112 1389727904 14.503 100 87 174 0 1424221904 5555392 28938608
22:58:30 13546 8192000000 10389709984 10711207936 1440349168 14.953 100 93 186 0 1478126704 7123712 30653824
22:58:59 14422 8192000000 10406426208 10733871104 1459250752 15.119 100 90 180 0 1496908416 7956656 29701008
22:59:22 28391 8192000000 10433912704 10765586432 1472499968 15.236 100 84 168 0 1508122192 8576896 27045328
22:59:59 20803 8192000000 10459898592 10793803776 1511900016 15.580 100 88 176 0 1549542720 9713712 27928992
23:00:40 22900 8192000000 10487322768 10832326656 1539337520 15.818 100 87 174 0 1577541648 10257552 27946576
23:01:12 19226 8192000000 10507849488 10857144320 1567699168 16.062 100 84 168 1 1603964832 10368144 25897520
23:01:41 17007 8192000000 10535885984 10890035200 1589698128 16.251 100 80 160 2 1624956176 11261536 23996512
23:02:07 9157 8192000000 10552790896 10910367744 1612763936 16.448 100 81 163 0 1648235984 11227664 24244384
23:02:26 10574 8192000000 10569954048 10933010432 1626682080 16.567 100 80 158 3 1661822880 11985696 23155104
23:02:47 10882 8192000000 10595562400 10955026432 1654451632 16.802 100 82 164 0 1691404752 12882480 24070640
23:03:07 9878 8192000000 10614730848 10979987456 1667023040 16.908 100 79 158 1 1703086592 13357280 22706272
23:03:24 9282 8192000000 10629724992 10999730176 1685110672 17.060 100 75 150 0 1719509280 12654976 21743632
23:03:41 8751 8192000000 10642377712 11014103040 1699486368 17.181 100 78 156 1 1735584416 13254288 22843760
23:03:58 6540 8192000000 10661047568 11033313280 1711088192 17.278 100 78 154 3 1746028816 12881616 22059008
23:04:17 8085 8192000000 10659934384 11039498240 1723691824 17.383 100 71 142 2 1756608416 12162016 20754576
23:04:34 6456 8192000000 10677229232 11057246208 1741067856 17.527 100 71 142 2 1773186880 12082432 20036592
23:04:47 6726 8192000000 10687076048 11072204800 1757768832 17.666 100 74 148 2 1791171504 12437216 20965456
23:05:01 4726 8192000000 10708765904 11091431424 1774747568 17.806 100 78 156 3 1809466352 12588640 22130144
23:05:12 3524 8192000000 10725345136 11102842880 1783192688 17.876 100 81 161 2 1818614288 12090528 23331072
23:05:22 3969 8192000000 10716838832 11103248384 1785294368 17.893 100 75 150 2 1818676048 12525792 20855888
23:05:34 3519 8192000000 10735209248 11119898624 1791236448 17.942 100 73 146 0 1823863120 12343520 20283152
23:05:44 3363 8192000000 10743607584 11128332288 1805678592 18.060 100 81 161 0 1841021536 12813440 22529504
23:05:56 2996 8192000000 10752981216 11144605696 1819689280 18.175 100 72 146 0 1853629904 13147456 20793168
23:06:05 3574 8192000000 10765075520 11155116032 1826645040 18.232 100 85 169 4 1862870592 12548928 23676624
23:06:15 2260 8192000000 10765711200 11155906560 1834410800 18.295 100 87 172 2 1870814016 12514128 23889088
23:06:24 2255 8192000000 10785462624 11168980992 1838252608 18.327 100 87 172 0 1875755200 12975984 24526608
23:06:33 2632 8192000000 10782649664 11169464320 1844426832 18.377 100 90 180 0 1882423712 12988448 25008432
23:06:41 2383 8192000000 10784237408 11171262464 1845643504 18.387 100 92 181 3 1885300128 13965616 25691008
23:06:50 1624 8192000000 10790754000 11175583744 1851141792 18.431 100 96 190 1 1893216160 15452816 26621552
23:06:58 2319 8192000000 10799623104 11182825472 1850585104 18.427 100 84 167 1 1887676912 14083696 23008112
23:07:07 1714 8192000000 10793617488 11182944256 1855665200 18.468 100 93 184 1 1894510384 12941488 25903696
23:07:15 1794 8192000000 10799721760 11185438720 1858284512 18.489 100 93 186 1 1897504272 13269744 25950016
23:07:23 2207 8192000000 10803167296 11191111680 1860098960 18.504 100 94 189 1 1901819072 13586848 28133264
23:07:32 1299 8192000000 10813441520 11202195456 1867387712 18.563 100 92 185 0 1907959040 14153536 26417792
23:07:39 1852 8192000000 10820626144 11206365184 1869419072 18.580 100 94 189 3 1909869232 13418832 27031328
23:07:47 1748 8192000000 10814759344 11201933312 1870540912 18.589 100 87 173 1 1908085584 13490928 24053744
23:07:55 7562 8192000000 10779441872 11197145088 1864524000 18.540 100 58 116 1 1892197536 10666336 17007200
23:08:10 39015 8192000000 10806778576 11205701632 1869119728 18.577 100 63 128 3 1893268960 5525088 18624144
23:08:55 11265 8192000000 10777040240 11202830336 1867428864 18.563 100 34 68 4 1886535296 9173920 9932512
23:09:20 6964 8192000000 10780550848 11209093120 1870126016 18.585 100 26 52 0 1884777296 7623568 7027712
23:09:34 4362 8192000000 10795404432 11216003072 1881760624 18.679 100 54 111 1 1901941152 5392224 14788304
23:09:47 3952 8192000000 10784077504 11214565376 1879087280 18.658 100 25 49 1 1893017952 7109792 6820880
23:09:57 7300 8192000000 10788822896 11216531456 1879767648 18.663 100 32 64 2 1895307968 6685888 8854432
23:10:14 6211 8192000000 10785851872 11217870848 1881619744 18.678 100 22 43 2 1893538048 5362016 6556288
23:10:27 6445 8192000000 10796053536 11223371776 1883390128 18.692 100 25 50 2 1896793232 6643664 6759440
23:10:40 9502 8192000000 10792150688 11224252416 1883512384 18.693 100 12 23 2 1892924400 5975616 3436400
23:10:56 13599 8192000000 10797953216 11229904896 1886671792 18.719 100 16 32 1 1897147104 5560384 4914928
23:11:18 13435 8192000000 10788987920 11226251264 1887230896 18.723 100 14 28 1 1898061920 6106784 4724240
23:11:38 10832 8192000000 10797345152 11231039488 1891358720 18.757 100 13 26 0 1900630032 5619824 3651488
23:11:56 16734 8192000000 10799453728 11231899648 1891371408 18.757 100 15 30 2 1902421792 6327552 4722832
23:12:20 19303 8192000000 10813757264 11235905536 1906637168 18.880 100 33 66 2 1922566016 5545696 10383152
23:12:53 45062 8192000000 10845636848 11252314112 1904735408 18.864 100 50 101 2 1929277664 9619952 14922304
23:13:44 13094 8192000000 10796558048 11238412288 1883304576 18.692 99 26 52 1 1896777360 5887184 7585600
23:14:04 8080 8192000000 10806691952 11242749952 1895952704 18.794 100 19 37 1 1906342224 5206416 5183104
23:14:18 3352 8192000000 10828546736 11251032064 1904658016 18.864 100 47 93 4 1926886576 7929840 14298720
23:14:28 5876 8192000000 10821860080 11250364416 1902955840 18.850 100 34 67 1 1919126640 6462096 9708704
23:14:44 4185 8192000000 10823470288 11254448128 1907386336 18.886 100 37 74 2 1924962256 7734944 9840976
23:14:58 4990 8192000000 10816112864 11251236864 1906554752 18.879 100 38 75 2 1923483008 6367312 10560944
23:15:12 7015 8192000000 10824963072 11254607872 1903707024 18.856 100 14 28 0 1913240528 5771232 3762272
23:15:28 7739 8192000000 10806920192 11246866432 1890118144 18.747 99 15 30 0 1900984112 5892992 4972976
23:15:43 9377 8192000000 10808776560 11243810816 1849259184 18.416 97 17 34 2 1864713200 10166880 5287136
23:15:59 9588 8192000000 10806140656 11241230336 1875231152 18.627 99 16 32 1 1889447200 9958368 4257680
23:16:15 10093 8192000000 10793753776 11231346688 1855268512 18.465 98 14 28 0 1864811600 5680992 3862096
23:16:31 9091 8192000000 10791127184 11222073344 1860994992 18.511 99 10 20 2 1869578880 5746400 2837488
23:16:47 7428 8192000000 10779040080 11202748416 1818993792 18.169 97 20 40 2 1829934160 5196400 5743968
23:17:03 19062 8192000000 10736602896 11140628480 1721393984 17.364 92 22 44 2 1731409008 4612608 5402416
23:17:28 56339 8192000000 10748584512 11158155264 1797619488 17.994 98 37 72 2 1813056272 4880688 10556096
23:18:30 18056 8192000000 10687645904 11108732928 1607053136 16.400 88 18 36 2 1617398288 5353088 4992064
23:18:57 6355 8192000000 10720140960 11144097792 1805850896 18.062 100 31 62 0 1821472496 6558896 9062704
23:19:11 9007 8192000000 10712506720 11127341056 1767440896 17.746 98 38 76 1 1786229328 8028928 10759504
23:19:27 5729 8192000000 10701386352 11120087040 1773773552 17.798 99 31 62 3 1789485824 7177808 8534464
23:19:42 5871 8192000000 10714482944 11127570432 1754960640 17.643 97 27 54 1 1769616464 6688880 7966944
23:19:56 6408 8192000000 10662624336 11075833856 1669719376 16.931 93 29 58 2 1684397328 6429568 8248384
23:20:09 6997 8192000000 10700502624 11108061184 1776180240 17.818 100 35 70 1 1792742128 5896544 10665344
23:20:23 6062 8192000000 10692316064 11109330944 1758466464 17.672 98 26 52 4 1770795424 5478640 6850320
23:20:43 8201 8192000000 10717625664 11129667584 1793684304 17.962 100 26 51 2 1807010288 5959792 7366192
23:20:59 8333 8192000000 10727781408 11151470592 1815568528 18.141 100 26 52 1 1828659904 5170688 7920688
23:21:14 7874 8192000000 10720821552 11145809920 1810430320 18.099 100 26 50 0 1824042160 5507440 8104400
23:21:30 8218 8192000000 10729047472 11149217792 1816775280 18.151 100 27 55 0 1830044736 5926240 7343216
23:21:44 13305 8192000000 10737696416 11160969216 1811838112 18.111 99 11 22 1 1819726848 5320976 2567760
23:22:04 9325 8192000000 10733528096 11161579520 1825277376 18.221 100 11 20 0 1833672992 5552848 2842768
23:22:19 79014 8192000000 10738532912 11173425152 1836888720 18.315 100 37 74 2 1852216256 5070512 10257024
23:23:44 10608 8192000000 10759396848 11185262592 1847798912 18.404 100 31 62 2 1863257200 6923040 8535248
23:24:01 5181 8192000000 10768040464 11191119872 1848982544 18.414 100 21 42 2 1860742320 5892304 5867472
23:24:14 7708 8192000000 10764178912 11189993472 1851198096 18.432 100 30 60 2 1866439184 6498272 8742816
23:24:29 9211 8192000000 10779692784 11198472192 1852709136 18.444 100 31 62 1 1867541808 6175168 8657504
23:24:47 5882 8192000000 10781702896 11203825664 1858642512 18.492 100 31 63 2 1872894352 5451824 8800016
23:25:02 7269 8192000000 10767677136 11200262144 1859823296 18.502 100 19 38 1 1871092304 5857872 5411136
23:25:18 11131 8192000000 10790312560 11216134144 1865806576 18.550 100 23 45 4 1878155120 5398432 6950112
23:25:36 11153 8192000000 10791874544 11217395712 1870826496 18.591 100 32 64 4 1885468000 4932624 9708880
23:25:54 7653 8192000000 10799484912 11220635648 1872074784 18.601 100 28 57 1 1885949312 4754320 9120208
23:26:12 9465 8192000000 10783618864 11217555456 1873893488 18.616 100 30 59 2 1889260432 5732992 9633952
23:26:31 12859 8192000000 10791219120 11222605824 1876123584 18.634 100 22 43 2 1887090928 4805312 6162032
23:26:51 11313 8192000000 10806209712 11233243136 1879654320 18.662 100 18 37 2 1891004880 5335920 6014640
23:27:12 82352 8192000000 10831995568 11259469824 1897997456 18.810 100 44 88 0 1917525776 6596480 12931840
23:28:46 22448 8192000000 10854811232 11276095488 1923119904 19.012 100 39 77 4 1941966688 8153488 10693296
23:29:17 131087 8192000000 10865105520 11300470784 1933989872 19.099 100 46 91 0 1956262064 9119216 13152976
23:31:47 8437 8192000000 10880920752 11299762176 1931315776 19.077 99 56 108 1 1961001744 14893776 14792192
23:32:05 18772 8192000000 10878287392 11307069440 1947841168 19.209 100 53 105 1 1974224000 11438240 14944592
23:32:35 3756 8192000000 10892706496 11319414784 1959958432 19.306 100 59 116 2 1990320208 13880112 16481664
23:32:59 26414 8192000000 10903688912 11338731520 1965283344 19.348 100 44 88 0 1994894112 15824944 13785824
23:33:36 7691 8192000000 10920209312 11342905344 1974824848 19.424 100 65 129 0 2007999344 14686304 18488192
23:33:50 2253 8192000000 10923964320 11347791872 1978743392 19.455 100 70 141 1 2014761456 15572560 20445504
23:33:59 6992 8192000000 10914106592 11343368192 1963050048 19.330 99 61 122 0 1997153200 16051616 18051536
23:34:17 2436 8192000000 10927559728 11351494656 1980877408 19.472 100 73 146 1 2019932032 17880608 21174016
23:34:29 5788 8192000000 10926976240 11348856832 1983088944 19.489 100 75 149 1 2019934192 16118896 20726352
23:34:42 9537 8192000000 10925123392 11352698880 1980243728 19.467 100 57 114 1 2013739344 16993776 16501840
23:35:02 4048 8192000000 10927682368 11355901952 1984704480 19.502 100 61 122 0 2019587104 17002848 17879776
23:35:14 4380 8192000000 10935091264 11361484800 1987503136 19.524 100 67 132 4 2023717440 17012576 19201728
23:35:26 4515 8192000000 10932004128 11356028928 1970103216 19.386 99 67 134 1 2006319920 16414144 19802560
23:35:37 3693 8192000000 10937642528 11359227904 1984770528 19.502 100 67 130 0 2022368912 18072128 19526256
23:35:49 5132 8192000000 10941663408 11363143680 1990857264 19.551 100 69 137 0 2030180128 19732496 19590368
23:36:01 5546 8192000000 10928263984 11353853952 1978466400 19.453 100 57 114 0 2014919776 19559536 16893840
23:36:17 3928 8192000000 10932105904 11360546816 1983598352 19.493 100 59 117 0 2019236656 18399136 17239168
23:36:28 4259 8192000000 10940665024 11361644544 1982755408 19.487 100 75 149 2 2027976272 23445984 21774880
23:36:41 9506 8192000000 10925056816 11350708224 1963545408 19.334 99 59 118 1 2001632096 20700640 17386048
23:37:00 6717 8192000000 10919143376 11354411008 1979246768 19.459 100 54 108 1 2015718128 20391808 16079552
23:37:14 3661 8192000000 10945193456 11369766912 1990575776 19.548 100 70 139 0 2029383328 18783152 20024400
23:37:24 6174 8192000000 10943871760 11373125632 1991147760 19.553 100 57 114 1 2027654880 20017760 16489360
23:37:55 9669 8192000000 10939676384 11373678592 1991470800 19.555 100 59 117 1 2030373600 21351184 17551616
23:38:12 13059 8192000000 10938338960 11374501888 1999302336 19.617 100 61 118 3 2038412240 21257920 17851984
23:38:34 8774 8192000000 10931469456 11364835328 1990581680 19.548 100 49 99 0 2023949312 18841632 14526000
23:38:52 2852 8192000000 10928291760 11345399808 1971786480 19.400 99 65 126 3 2007541440 17148688 18606272
23:39:04 2876 8192000000 10940314976 11358003200 1972352496 19.404 99 69 137 0 2010638448 17730928 20555024
23:39:15 21054 8192000000 10922038800 11353747456 1934767840 19.105 97 67 131 1 1973810064 19289616 19752608
23:39:44 6131 8192000000 10942847616 11368804352 1989244304 19.538 100 63 124 2 2027178960 19483344 18451312
23:39:57 1992 8192000000 10958771648 11372093440 1991891472 19.559 100 77 154 3 2037820064 22660272 23268320
23:40:07 6224 8192000000 10924849024 11342057472 1960034352 19.306 100 71 139 0 2004009872 23410608 20564912
23:40:20 2446 8192000000 10927089184 11334713344 1958082784 19.291 99 81 162 0 2006355136 24118864 24153488
23:40:30 6614 8192000000 10898383440 11312078848 1919775520 18.985 98 68 136 2 1965228144 25443728 20008896
23:40:44 1285 8192000000 10909298752 11326427136 1938828096 19.137 99 78 154 1 1983848432 22470704 22549632
23:40:53 3744 8192000000 10926083584 11340136448 1960547968 19.310 100 80 159 3 2007153392 23423728 23181696
23:41:03 13725 8192000000 10908446064 11333423104 1940073648 19.147 99 65 130 3 1981964560 22764416 19126496
23:41:25 4568 8192000000 10923519392 11338854400 1947025456 19.203 99 77 153 1 1993642656 22808752 23808448
23:41:37 3361 8192000000 10923033200 11327995904 1949309040 19.221 100 76 152 0 1998285824 26158464 22818320
23:41:47 4173 8192000000 10911328224 11327754240 1934215952 19.101 99 72 144 1 1982995696 27255152 21524592
23:42:02 2822 8192000000 10915066960 11322540032 1942567152 19.167 100 84 167 2 1997080256 28145216 26367888
23:42:13 2168 8192000000 10894879216 11307151360 1905671248 18.872 98 76 152 1 1958157024 28822192 23663584
23:42:24 2503 8192000000 10919585584 11329294336 1947759552 19.209 100 79 158 3 2001575632 29907696 23908384
23:42:36 4197 8192000000 10930886016 11347881984 1958776336 19.296 100 80 160 1 2012380864 29242400 24362128
23:42:50 8683 8192000000 10932326512 11343831040 1957364480 19.285 100 79 159 2 2011809936 29867024 24578432
23:43:06 4094 8192000000 10941697424 11359014912 1964574400 19.342 100 76 151 0 2020231936 32023664 23633872
23:43:17 5308 8192000000 10930593088 11346870272 1958525072 19.294 100 71 137 0 2013781104 33232512 22023520
23:43:29 6164 8192000000 10945178032 11356925952 1965922352 19.353 100 74 148 2 2024017232 34439968 23654912
23:43:44 11451 8192000000 10932999280 11353874432 1945439760 19.190 99 74 147 3 2003422656 34993072 22989824
23:44:02 3128 8192000000 10936853664 11348807680 1955321984 19.269 100 81 162 1 2015730384 34577472 25830928
23:44:12 4786 8192000000 10925574992 11331252224 1942882608 19.170 99 90 180 2 2004832752 33853920 28096224
23:44:24 9705 8192000000 10930199984 11348541440 1935223744 19.109 99 65 130 1 1993805232 38447520 20133968
23:44:49 3276 8192000000 10917682816 11332464640 1924037536 19.019 99 77 154 0 1985621184 37416400 24167248
23:45:00 3363 8192000000 10915882080 11327037440 1924286112 19.021 99 83 167 0 1989776576 38431360 27059104
23:45:10 2854 8192000000 10889375280 11302629376 1902837920 18.849 98 86 170 1 1969067328 39671440 26557968
23:45:20 4384 8192000000 10891946608 11305893888 1908035792 18.891 99 82 164 1 1969885632 35888064 25961776
23:45:31 7332 8192000000 10890112384 11301408768 1911574800 18.919 100 72 145 1 1971282752 36461920 23246032
23:45:47 2464 8192000000 10895285200 11307413504 1912370704 18.926 100 71 141 2 1970913392 36400048 22142640
23:45:58 3397 8192000000 10910677408 11320868864 1926747472 19.041 100 85 167 2 1992819872 39998368 26074032
23:46:11 4233 8192000000 10902388128 11313803264 1928854352 19.058 100 69 138 0 1983696848 32840368 22002128
23:46:22 2760 8192000000 10905145536 11313975296 1915533184 18.951 99 78 154 2 1974874480 34501920 24839376
23:46:33 8698 8192000000 10920781104 11337687040 1941750752 19.161 100 65 130 1 1996844736 34067360 21026624
23:46:50 5819 8192000000 10925945168 11343425536 1950969584 19.234 100 75 150 4 2010574288 35687824 23916880
23:47:07 1901 8192000000 10938191920 11344531456 1941283424 19.157 99 80 161 1 2006625680 39487520 25854736
23:47:16 2877 8192000000 10921975584 11330523136 1936460464 19.119 99 86 172 0 2004977232 41203712 27313056
23:47:29 2320 8192000000 10922294944 11330056192 1937649568 19.128 100 80 154 1 2001382384 38933408 24799408
23:47:43 25079 8192000000 10885643824 11316678656 1895129888 18.787 98 44 88 1 1945220288 35314496 14775904
23:48:15 21877 8192000000 10882323248 11318718464 1913830928 18.937 100 45 90 1 1968629168 39571808 15226432
23:48:51 14964 8192000000 10894663776 11322953728 1919756528 18.985 100 49 95 1 1978058176 42540672 15760976
23:49:16 23825 8192000000 10882830176 11337535488 1922729056 19.009 100 34 68 2 1977184128 42762288 11692784
23:49:52 11024 8192000000 10904390928 11337572352 1936943680 19.122 100 49 99 2 1988188512 34787200 16457632
23:50:11 9605 8192000000 10894077696 11337658368 1937750496 19.129 100 35 68 0 1981496176 32618448 11127232
23:50:29 17439 8192000000 10903070128 11343458304 1942301216 19.165 100 34 68 1 1987278016 34293184 10683616
23:50:58 16503 8192000000 10893347840 11332513792 1915470608 18.951 99 32 61 1 1963833360 38200448 10162304
23:51:34 32232 8192000000 10896007888 11349848064 1935634464 19.112 100 30 60 1 1988961776 42880608 10446704
23:52:34 16172 8192000000 10892839296 11345354752 1929899360 19.066 100 26 52 1 1980732304 42261536 8571408
23:52:58 24933 8192000000 10881972528 11339771904 1913736720 18.937 99 23 46 3 1960138368 38534016 7867632
23:53:41 15207 8192000000 10880602176 11339321344 1910770928 18.913 100 17 34 0 1960904160 43628064 6505168
23:54:02 8386 8192000000 10863640608 11326717952 1891841376 18.761 99 16 32 0 1942930512 44777248 6311888
23:54:26 21333 8192000000 10880184416 11327934464 1888669328 18.735 99 15 30 1 1939964080 45986416 5308336
23:55:20 65809 8192000000 10840847728 11300478976 1883550704 18.694 98 25 50 1 1907003232 15513504 7939024
23:56:33 38824 8192000000 10854931776 11315388416 1917201952 18.964 100 15 30 1 1940737056 18456336 5078768
23:57:18 84174 8192000000 10902628272 11346419712 1944762336 19.185 100 14 28 0 1970174720 21474352 3938032
23:58:49 60026 8192000000 10878346912 11320111104 1879167424 18.658 96 26 52 2 1901940672 15889520 6883728
00:00:05 31884 8192000000 10900241808 11331764224 1947366848 19.206 100 31 62 0 1973109760 16843376 8899536
00:00:45 32660 8192000000 10910978496 11349557248 1961292976 19.316 100 52 105 3 1995526848 19241456 14992416
00:01:26 103756 8192000000 10891906704 11335561216 1938882240 19.138 99 30 60 1 1959539232 12194528 8462464
00:03:28 37949 8192000000 10890093360 11343065088 1961647968 19.319 100 26 52 3 1976079184 7281888 7149328
00:04:12 30498 8192000000 10892439472 11352592384 1966129856 19.355 100 13 26 2 1976985568 6806928 4048784
00:04:57 54003 8192000000 10904953888 11363127296 1971427248 19.397 100 46 92 1 1996221264 11269648 13524368
00:05:59 48242 8192000000 10898577504 11359031296 1968000720 19.370 100 16 32 1 1983098912 11101904 3996288
00:06:53 28633 8192000000 10896067296 11354599424 1953197088 19.252 99 32 65 0 1969557360 7091872 9268400
00:07:32 38076 8192000000 10895836400 11362885632 1978085056 19.450 100 47 92 1 1999129584 7624384 13420144
00:09:10 45728 8192000000 10903000288 11376463872 1975892544 19.432 100 9 18 0 1985591872 7283520 2415808
00:10:02 74926 8192000000 10901152544 11368579072 1970825392 19.392 99 15 30 1 1983450672 8232608 4392672
00:11:57 98716 8192000000 10904758368 11391025152 1983590592 19.493 100 14 28 1 1995391280 8014032 3786656
00:14:31 50309 8192000000 10913932752 11403042816 1975328896 19.428 99 6 12 0 1992145520 14941536 1875088
00:15:29 52918 8192000000 10913788608 11396657152 1996592064 19.596 100 8 16 1 2011147264 12796176 1759024
00:16:35 39287 8192000000 10926809152 11392098304 1960451088 19.310 98 19 38 0 1973009728 7405648 5152992
00:17:34 42797 8192000000 10926814944 11403489280 1983928576 19.496 99 22 44 1 1998946800 9131328 5886896
00:19:22 12104 8192000000 10938328816 11396280320 1989807328 19.542 99 30 62 0 2003660160 5570688 8282144
00:19:41 48306 8192000000 10946973008 11406802944 1977082384 19.442 98 33 65 2 1998968768 12224112 9662272
00:20:48 63652 8192000000 10946921520 11412361216 1977592240 19.446 98 18 36 1 2000772176 16950320 6229616
00:21:58 49870 8192000000 10931722032 11422601216 1977081392 19.442 99 13 26 1 2003590320 22366096 4142832
00:23:00 109659 8192000000 10923801440 11393806336 1958774512 19.296 98 15 30 0 1981383664 18053104 4556048
00:25:03 41049 8192000000 10933500960 11376869376 1956706912 19.280 98 32 64 1 1976060528 9865632 9487984
00:25:52 16244 8192000000 10938160624 11392815104 1996605088 19.596 100 47 94 1 2019934544 9869552 13459904
00:26:16 29623 8192000000 10895047856 11352367104 1889128544 18.739 95 20 40 2 1904580912 9749360 5703008
00:26:52 32817 8192000000 10887829856 11351035904 1907254304 18.885 97 18 36 1 1919926848 7826720 4845824
00:27:31 43718 8192000000 10892173888 11342491648 1901029088 18.835 96 43 86 1 1925506320 11773280 12703952
00:29:09 69840 8192000000 10881571552 11345776640 1919928640 18.986 98 30 58 0 1939372256 11839776 7603840
00:30:28 24694 8192000000 10891269280 11354333184 1929848704 19.066 98 35 70 0 1950263152 10403488 10010960
00:33:14 62135 8192000000 10871822416 11352010752 1941452192 19.158 99 10 20 2 1956389648 11789824 3147632
00:34:22 75805 8192000000 10859828640 11344908288 1877728720 18.647 96 13 26 0 1891780576 10486688 3565168
00:35:45 54428 8192000000 10869871136 11338866688 1906966096 18.882 98 11 22 0 1921024960 10814752 3244112
00:36:47 65162 8192000000 10856165600 11324383232 1846651872 18.395 95 31 62 0 1866534400 11576368 8306160
00:37:58 60986 8192000000 10834841184 11298627584 1840439872 18.344 95 25 50 0 1857617408 10290672 6886864
00:39:06 50113 8192000000 10847455280 11304054784 1858393536 18.490 96 34 68 3 1878064896 11029136 8642224
00:40:07 51841 8192000000 10842210624 11304153088 1863208944 18.529 97 24 48 2 1881934720 11970688 6755088
00:41:08 22076 8192000000 10843905504 11290136576 1841927312 18.356 96 30 60 2 1861501600 11037152 8537136
00:41:44 40655 8192000000 10852283328 11311554560 1893212768 18.772 99 35 70 2 1917109344 14036352 9860224
00:43:09 66819 8192000000 10857269776 11313582080 1875423808 18.628 98 16 32 0 1888838928 9427360 3987760
00:44:26 16065 8192000000 10872843456 11320487936 1924239424 19.021 100 20 40 0 1939129792 9088672 5801696
00:44:51 21271 8192000000 10882185184 11318697984 1917945888 18.970 99 41 82 1 1940568544 11052528 11570128
00:45:22 29299 8192000000 10886726688 11341475840 1945568128 19.191 100 43 86 1 1972181232 14619952 11993152
00:45:59 79422 8192000000 10863820576 11344060416 1878757600 18.655 97 15 30 1 1899986592 16974416 4254576
00:48:59 66982 8192000000 10873850592 11332853760 1889600976 18.743 97 24 48 1 1916708672 20020032 7087664
00:50:13 18096 8192000000 10858472496 11337494528 1929135072 19.060 100 15 30 1 1954364720 20893056 4336592
00:51:29 62355 8192000000 10863082912 11349581824 1933016112 19.091 100 9 18 0 1948517408 12741280 2760016
00:52:44 76542 8192000000 10884380112 11365281792 1944210000 19.180 100 11 22 0 1962460800 15026400 3224400
00:54:08 74726 8192000000 10859447712 11344826368 1932448560 19.086 99 15 30 1 1950136592 13102432 4585600
00:55:52 56885 8192000000 10893520480 11361558528 1939291872 19.141 99 22 44 1 1956625568 11332432 6001264
00:57:08 67135 8192000000 10902654400 11367063552 1931325232 19.077 98 24 48 0 1951943696 13908896 6709568
00:58:21 104223 8192000000 10909349808 11383369728 1970095072 19.386 100 17 33 0 1996323920 21324704 4904144
01:00:15 62608 8192000000 10907228016 11384086528 1983481408 19.492 100 27 54 0 2000682544 9555216 7645920
01:01:30 73233 8192000000 10917060224 11390128128 1970161232 19.387 99 16 32 0 1986690160 12321200 4207728
01:02:49 63721 8192000000 10932804208 11391975424 1958413136 19.293 98 24 48 1 1976071072 11287776 6370160
01:04:04 52734 8192000000 10919610768 11376218112 1938603376 19.136 97 32 64 0 1961111360 13728624 8779360
01:05:02 16678 8192000000 10935228064 11388739584 1973732000 19.415 99 40 80 1 1994342016 9886848 10723168
01:05:26 26670 8192000000 10942011984 11399766016 1991339200 19.554 100 33 66 2 2009680928 9695792 8645936
01:06:02 41560 8192000000 10928652960 11389779968 1981062416 19.473 99 47 94 0 2007197824 12687040 13448368
01:07:41 81369 8192000000 10886253760 11365515264 1924153072 19.020 97 11 22 0 1937906192 10678128 3074992
01:09:09 7618 8192000000 10886777968 11369046016 1966830752 19.360 100 6 12 1 1979822032 11510960 1480320
01:09:29 1889 8192000000 10877370832 11363086336 1957655408 19.287 100 4 8 1 1972302480 13487680 1159392
01:09:40 32518 8192000000 10875943024 11355111424 1945954288 19.194 99 12 24 0 1956889792 7582784 3352720
01:10:19 54018 8192000000 10890633552 11370094592 1968924608 19.377 100 7 14 1 1978515936 7719632 1871696
01:11:28 59024 8192000000 10894166704 11375108096 1945658352 19.192 98 14 30 0 1957714560 8303120 3753088
01:12:37 67574 8192000000 10905876064 11390783488 1987073968 19.521 100 14 26 2 1999389056 8495392 3819696
01:14:15 45475 8192000000 10899940320 11389411328 1982803456 19.487 100 17 35 0 1998862752 11394688 4664608
01:15:12 77944 8192000000 10911201776 11373973504 1926445952 19.038 97 12 24 1 1938636976 8546256 3644768
01:16:36 46367 8192000000 10905264848 11391389696 1966296224 19.356 99 18 35 0 1982124304 11126320 4701760
01:17:28 48068 8192000000 10907551184 11373158400 1887237104 18.724 95 26 50 0 1905358064 10550656 7570304
01:18:23 64783 8192000000 10897753104 11363368960 1896978368 18.802 96 24 48 0 1920779392 16780864 7020160
01:19:34 93805 8192000000 10855689600 11356049408 1865852096 18.551 95 23 45 2 1899715792 26975072 6888624
01:21:35 76845 8192000000 10854518688 11333046272 1875466576 18.628 97 10 20 0 1891474640 13376192 2631872
01:22:58 75343 8192000000 10872043920 11331928064 1875875648 18.632 96 26 52 1 1895149104 12009184 7264272
01:24:21 63619 8192000000 10882297008 11328991232 1845937632 18.389 95 25 50 1 1860855264 8053616 6864016
01:25:32 70685 8192000000 10876137904 11330244608 1862556144 18.524 96 38 76 0 1886882000 13137072 11188784
01:26:54 20371 8192000000 9123380512 9346076672 283795936 3.348 15 5 10 1 292148592 7254416 1098240

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-11-2020 01:28:00 to 11-11-2020 01:28:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-11-2020 01:28:32 to 11-11-2020 01:28:34.

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          243402
MON$OLDEST_ACTIVE               243403
MON$OLDEST_SNAPSHOT             243403
MON$NEXT_TRANSACTION            243403
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                       2025440
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.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:253: 
:254: mscs-test-161.budzdorov.ru    Wed Nov 11 01:27:18 2020
:255:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:256: 
--- end of diff output ---

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

11.11.20 01:28:35. 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-11 01:28:38 No severe PSQL-related problems occured
11.11.20 01:28:39. End of report.