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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-20 16:27:14
DTS_END                         2021-01-20 16:27:14.2910
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/58456
TRN_ID                          241064
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: 9192.33 26888 1103080
customer order: creation 170.32 375 20438
customer order: refuse 15.19 318 1823
order to supplier: creation 45.47 1320 5456
order to supplier: removal 3.24 105414 389
invoice (draft): creation 46.78 3577 5614
invoice (draft): removal 51.23 786 6147
invoice accept: apply 42.60 17851 5112
invoice accept: cancel 46.25 809 5550
customer reserve: creation 3933.81 175 472057
customer reserve: removal 4541.38 59 544966
realization accept: apply 83.68 202 10042
realization accept: cancel 82.74 110 9929
payment from customer: creation 58.83 135 7059
payment from customer: removal 5.83 82 699
payment to supplier: creation 48.97 143 5876
payment to supplier: removal 3.25 80 390
service: total inventory turnovers 5.20 945 624
service: total monetary turnovers 6.83 38 820
service: aggregate perf. data 0.71 23532 85
service: refresh index statistics 0.03 381813 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 20-01-2021 16:28:09 to 20-01-2021 16:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3314
TEST_TIME 2 3214
TEST_TIME 3 3394
TEST_TIME 4 3039
TEST_TIME 5 3445
TEST_TIME 6 4180
TEST_TIME 7 4154
TEST_TIME 8 4665
TEST_TIME 9 5098
TEST_TIME 10 5305
TEST_TIME 11 5393
TEST_TIME 12 5625
TEST_TIME 13 6149
TEST_TIME 14 6759
TEST_TIME 15 6827
TEST_TIME 16 7010
TEST_TIME 17 7183
TEST_TIME 18 7216
TEST_TIME 19 7743
TEST_TIME 20 7891
TEST_TIME 21 8149
TEST_TIME 22 8467
TEST_TIME 23 8983
TEST_TIME 24 9163
TEST_TIME 25 9759
TEST_TIME 26 10163
TEST_TIME 27 10436
TEST_TIME 28 10834
TEST_TIME 29 10530
TEST_TIME 30 10454
TEST_TIME 31 10549
TEST_TIME 32 10550
TEST_TIME 33 10286
TEST_TIME 34 10138
TEST_TIME 35 10149
TEST_TIME 36 10117
TEST_TIME 37 10114
TEST_TIME 38 9922
TEST_TIME 39 9884
TEST_TIME 40 9802
TEST_TIME 41 9634
TEST_TIME 42 9549
TEST_TIME 43 9595
TEST_TIME 44 9639
TEST_TIME 45 9568
TEST_TIME 46 9437
TEST_TIME 47 9488
TEST_TIME 48 9427
TEST_TIME 49 9383
TEST_TIME 50 9443
TEST_TIME 51 9412
TEST_TIME 52 9419
TEST_TIME 53 9370
TEST_TIME 54 9447
TEST_TIME 55 9452
TEST_TIME 56 9500
TEST_TIME 57 9413
TEST_TIME 58 9519
TEST_TIME 59 9721
TEST_TIME 60 9815
TEST_TIME 61 9731
TEST_TIME 62 9603
TEST_TIME 63 9531
TEST_TIME 64 9478
TEST_TIME 65 9444
TEST_TIME 66 9442
TEST_TIME 67 9369
TEST_TIME 68 9326
TEST_TIME 69 9267
TEST_TIME 70 9334
TEST_TIME 71 9337
TEST_TIME 72 9275
TEST_TIME 73 9252
TEST_TIME 74 9374
TEST_TIME 75 9398
TEST_TIME 76 9398
TEST_TIME 77 9404
TEST_TIME 78 9457
TEST_TIME 79 9410
TEST_TIME 80 9488
TEST_TIME 81 9521
TEST_TIME 82 9552
TEST_TIME 83 9476
TEST_TIME 84 9466
TEST_TIME 85 9410
TEST_TIME 86 9418
TEST_TIME 87 9371
TEST_TIME 88 9305
TEST_TIME 89 9256
TEST_TIME 90 9260
TEST_TIME 91 9264
TEST_TIME 92 9324
TEST_TIME 93 9382
TEST_TIME 94 9386
TEST_TIME 95 9406
TEST_TIME 96 9429
TEST_TIME 97 9487
TEST_TIME 98 9451
TEST_TIME 99 9467
TEST_TIME 100 9473
TEST_TIME 101 9496
TEST_TIME 102 9558
TEST_TIME 103 9562
TEST_TIME 104 9477
TEST_TIME 105 9403
TEST_TIME 106 9437
TEST_TIME 107 9400
TEST_TIME 108 9363
TEST_TIME 109 9315
TEST_TIME 110 9292
TEST_TIME 111 9233
TEST_TIME 112 9240
TEST_TIME 113 9232
TEST_TIME 114 9197
TEST_TIME 115 9229
TEST_TIME 116 9236
TEST_TIME 117 9247
TEST_TIME 118 9240
TEST_TIME 119 9256
TEST_TIME 120 9193

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-01-2021 16:28:13 to 20-01-2021 16:28:17.

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 1539351 1539351 0 0.00 0 17955 6 0 0
doc_list_biud 1539349 1539349 0 0.00 0 88339 27 0 0
sp_add_invoice_to_stock 5224 5112 112 2.14 43 159286 17851 0 112
sp_cancel_adding_invoice 5550 5550 0 0.00 4 63805 810 0 0
sp_cancel_client_order 1823 1823 0 0.00 4 10550 318 0 0
sp_cancel_customer_reserve 544966 544966 0 0.00 1 91060 60 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 4600 82 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 2351 81 0 0
sp_cancel_supplier_invoice 6160 6147 13 0.21 2 19195 786 0 13
sp_cancel_supplier_order 389 389 0 0.00 9 1130453 105415 0 0
sp_cancel_write_off 9929 9929 0 0.00 1 17207 111 0 0
sp_client_order 20438 20438 0 0.00 3 21806 375 0 0
sp_customer_reserve 472057 472057 0 0.00 0 111120 175 0 0
sp_fill_shopping_cart 31502 31502 0 0.00 1 14352 43 0 0
sp_fill_shopping_cart_clo_res 472056 472056 0 0.00 0 18257 15 0 0
sp_get_clo_for_invoice 5111 5111 0 0.00 0 18657 333 0 0
sp_kill_cost_storno 16568 16568 0 0.00 0 8733 54 0 0
sp_kill_qstorno_ret_qs2qd 1106397 1106397 0 0.00 0 88333 32 0 0
sp_kill_qty_storno 583957 583957 0 0.00 0 88339 70 0 0
sp_lock_selected_doc 20959 20959 0 0.00 0 8719 7 0 0
sp_make_cost_storno 28088 28088 0 0.00 0 17948 62 0 0
sp_multiply_rows_for_pdistr 28088 28088 0 0.00 0 11416 32 0 0
sp_multiply_rows_for_qdistr 20438 20438 0 0.00 0 21783 178 0 0
sp_pay_from_customer 7059 7059 0 0.00 4 19142 136 0 0
sp_pay_to_supplier 5876 5876 0 0.00 5 15114 143 0 0
sp_payment_common 12935 12935 0 0.00 1 19128 42 0 0
sp_qd_handle_on_cancel_clo 1823 1823 0 0.00 0 10544 291 0 0
sp_qd_handle_on_invoice_upd_sts 10661 10661 0 0.00 0 19602 324 0 0
sp_qd_handle_on_reserve_upd_sts 10042 10042 0 0.00 0 19202 68 0 0
sp_reserve_write_off 10042 10042 0 0.00 6 19477 202 0 0
sp_supplier_invoice 5614 5614 0 0.00 6 132036 3578 0 0
sp_supplier_order 5456 5456 0 0.00 5 33565 1321 0 0
srv_aggregate_perf_data 85 85 0 0.00 2568 158099 23533 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1153 169094 32217 0 0
srv_find_qd_qs_mism 1054645 1054645 0 0.00 0 13615 5 0 0
srv_make_invnt_saldo 624 624 0 0.00 35 57656 945 0 0
srv_make_money_saldo 820 820 0 0.00 1 12834 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 296892 462330 381814 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5112 5112 0 0.00 0 13900 162 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 10527 108 0 0
t$perf-norm:sp_cancel_client_order 1823 1823 0 0.00 0 3984 20 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 10165 44 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 2390 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 2171 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 1247 17 0 0
t$perf-norm:sp_cancel_supplier_order 389 389 0 0.00 0 26827 1564 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 8404 17 0 0
t$perf-norm:sp_client_order 20438 20438 0 0.00 0 9297 17 0 0
t$perf-norm:sp_customer_reserve 1033 1033 0 0.00 0 1775 9 0 0
t$perf-norm:sp_pay_from_customer 7059 7059 0 0.00 0 9624 8 0 0
t$perf-norm:sp_pay_to_supplier 5876 5876 0 0.00 0 5591 11 0 0
t$perf-norm:sp_reserve_write_off 10042 10042 0 0.00 0 13607 14 0 0
t$perf-norm:sp_supplier_invoice 5614 5614 0 0.00 0 6451 27 0 0
t$perf-norm:sp_supplier_order 5456 5456 0 0.00 0 6812 18 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 328 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 622 11 0 0
t$perf-norm:srv_make_invnt_saldo 624 624 0 0.00 0 5344 30 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 2389 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 178 47 0 0
v_add_invoice_to_stock 10446 10222 224 2.14 0 11769 21 0 224
v_all_customers 37454 37454 0 0.00 0 30 1 0 0
v_all_suppliers 30490 30490 0 0.00 0 17 1 0 0
v_all_wares 40876 40876 0 0.00 0 145 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 2999 8 0 0
v_cancel_client_order 3646 3646 0 0.00 0 4522 6 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 3922 12 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 988 5 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 1937 8 0 0
v_cancel_supplier_invoice 884 858 26 2.94 0 3188 19 0 26
v_cancel_supplier_order 778 778 0 0.00 0 1940 9 0 0
v_cancel_write_off 1938 1938 0 0.00 0 2627 15 0 0
v_max_id_clo_ord 5456 5456 0 0.00 0 3813 2 0 0
v_max_id_clo_res 1033 1033 0 0.00 0 4990 18 0 0
v_max_id_ord_sup 5608 5608 0 0.00 0 5331 5 0 0
v_max_non_paid_invoice 1694 1694 0 0.00 0 650 3 0 0
v_max_non_paid_realizn 3684 3684 0 0.00 0 4669 5 0 0
v_min_id_clo_ord 5456 5456 0 0.00 0 9874 12 0 0
v_min_id_clo_res 1033 1033 0 0.00 0 7401 29 0 0
v_min_id_ord_sup 5608 5608 0 0.00 0 6759 8 0 0
v_min_non_paid_invoice 5876 5876 0 0.00 0 10192 26 0 0
v_min_non_paid_realizn 7059 7059 0 0.00 0 19124 28 0 0
v_our_firm 10172 10172 0 0.00 0 25 1 0 0
v_reserve_write_off 20084 20084 0 0.00 0 8284 7 0 0
x_lock_depdocs_on_canc_invoice 11268 11268 0 0.00 0 14672 118 0 0
x_lock_depdocs_on_canc_sup_ord 389 389 0 0.00 0 10940 420 0 0
x_make_qstorno_1000_1200 5456 5456 0 0.00 1 28266 1235 0 0
x_make_qstorno_1200_2000 5614 5614 0 0.00 3 131862 3423 0 0
x_make_qstorno_2100_3300 472057 472057 0 0.00 0 111080 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-01-2021 16:28:18 to 20-01-2021 16:28:22.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:24 8749 8192000000 10183050960 10478178304 836334576 9.263 67 51 102 0 855897552 2344704 17218272
13:57:40 29433 8192000000 10332576096 10650607616 1362497792 14.260 100 78 156 0 1392447056 4292960 25656304
13:58:18 23623 8192000000 10373886624 10695897088 1423224000 14.801 100 90 180 0 1458277760 5923312 29130448
13:58:53 28126 8192000000 10404494976 10730807296 1448837728 15.028 100 85 169 0 1484483216 7558160 28087328
13:59:34 22982 8192000000 10429088752 10763165696 1476653168 15.272 100 91 182 0 1514864816 8311840 29899808
14:00:05 22051 8192000000 10459185168 10796634112 1503257600 15.505 100 86 172 0 1539305488 8769248 27278640
14:00:39 12860 8192000000 10467404640 10807754752 1526372816 15.706 100 89 177 0 1563924400 9441696 28109888
14:01:05 16494 8192000000 10503272624 10849218560 1554369200 15.948 100 85 168 2 1594908656 14262720 26276736
14:01:32 16796 8192000000 10523077040 10872958976 1572536656 16.104 100 78 157 0 1607040448 10367360 24136432
14:02:02 11445 8192000000 10555000048 10909241344 1605534192 16.387 100 87 174 1 1647172592 15592160 26046240
14:02:22 13812 8192000000 10567282656 10926792704 1620837824 16.517 100 82 164 1 1657410352 11451104 25121424
14:02:46 13979 8192000000 10580363456 10945708032 1645438752 16.726 100 81 162 1 1681522512 12008416 24075344
14:03:09 11021 8192000000 10600026512 10964226048 1656248144 16.817 100 78 157 2 1691339904 11804896 23286864
14:03:27 10702 8192000000 10606743120 10974887936 1669020688 16.925 100 79 157 0 1704467232 12078192 23368352
14:03:47 9237 8192000000 10629120768 10995384320 1685879424 17.067 100 85 170 2 1724706896 13179344 25648128
14:04:06 13290 8192000000 10639021888 11012276224 1695004576 17.143 100 69 138 0 1727569472 12485776 20079120
14:04:30 6688 8192000000 10649513408 11027132416 1715721472 17.317 100 82 164 0 1752206256 13241824 23242960
14:04:43 7820 8192000000 10660199472 11034787840 1720543328 17.357 100 80 160 0 1756494384 13091280 22859776
14:04:58 9215 8192000000 10675800896 11053260800 1734589312 17.474 100 82 164 1 1771852176 14012064 23250800
14:05:15 7112 8192000000 10692029264 11068682240 1749686576 17.599 100 82 163 1 1786387712 13791888 22909248
14:05:29 4909 8192000000 10692131904 11075342336 1755888848 17.650 100 71 140 1 1789170528 13814128 19467552
14:05:41 3573 8192000000 10699226960 11084996608 1763283424 17.712 100 78 157 1 1799028368 13643920 22101024
14:05:53 4623 8192000000 10712164112 11093540864 1768043984 17.751 100 68 135 0 1800314560 13300624 18969952
14:06:05 5716 8192000000 10719349984 11100917760 1776789920 17.823 100 77 152 3 1811476368 13350288 21336160
14:06:19 10381 8192000000 10713961760 11104137216 1784672480 17.888 100 69 137 2 1815135232 11529744 18933008
14:06:37 4025 8192000000 10734314304 11126427648 1796187456 17.983 100 71 142 1 1826946384 10435376 20323552
14:06:48 3364 8192000000 10752264752 11138183168 1816307552 18.147 100 80 158 1 1851261392 11912784 23041056
14:06:58 2697 8192000000 10758858976 11142823936 1820767280 18.184 100 87 174 4 1856962720 11862048 24333392
14:07:08 3041 8192000000 10771428720 11152781312 1820892288 18.185 100 81 162 1 1857946304 14417728 22636288
14:07:18 2160 8192000000 10776841616 11163308032 1829651152 18.256 100 83 166 0 1866865312 14251840 22962320
14:07:27 3034 8192000000 10783528160 11166285824 1835346720 18.303 100 87 173 1 1874698096 14622368 24729008
14:07:36 1766 8192000000 10774489584 11162497024 1841545952 18.353 100 95 190 0 1881765984 13616208 26603824
14:07:44 1566 8192000000 10787946528 11171770368 1844915344 18.381 100 81 161 0 1880097136 12293296 22888496
14:07:53 2494 8192000000 10796431568 11182546944 1850303216 18.425 100 96 192 1 1890920272 13590832 27026224
14:08:01 1599 8192000000 10808982096 11194368000 1854305024 18.457 100 94 184 2 1895608016 15411200 25891792
14:08:09 1681 8192000000 10800084416 11192102912 1857996128 18.487 100 90 179 1 1897673120 14117264 25559728
14:08:18 1713 8192000000 10801153296 11190493184 1861334080 18.514 100 91 180 1 1900236752 13272432 25630240
14:08:26 1831 8192000000 10804573632 11193430016 1863271920 18.530 100 92 181 1 1901409968 12891664 25246384
14:08:35 6993 8192000000 10808135168 11193692160 1860601744 18.508 100 85 171 1 1898554640 14498016 23454880
14:08:48 1440 8192000000 10808868416 11196538880 1865199104 18.545 100 94 189 1 1906036800 14768160 26069536
14:08:55 20676 8192000000 10796548928 11197706240 1862424592 18.523 100 66 132 0 1893667280 12494288 18748400
14:09:22 10614 8192000000 10778493584 11194748928 1865204848 18.545 100 64 128 1 1892816112 9678336 17932928
14:09:39 17589 8192000000 10780266576 11192430592 1855683040 18.468 100 21 42 2 1866997168 5239568 6074560
14:10:04 4709 8192000000 10782312224 11199668224 1864461040 18.539 100 36 72 2 1883127136 8594816 10071280
14:10:15 8674 8192000000 10764971536 11198554112 1866276640 18.554 100 30 61 1 1882178336 7718800 8182896
14:10:30 10442 8192000000 10776453408 11205619712 1868762416 18.574 100 26 52 1 1882515248 6519312 7233520
14:10:47 5604 8192000000 10794865248 11219714048 1875990816 18.633 100 29 57 2 1894121152 10519952 7610384
14:11:06 5588 8192000000 10778046144 11210641408 1877266000 18.643 100 32 64 0 1897260192 11023568 8970624
14:11:18 9292 8192000000 10787959904 11213946880 1874086640 18.617 100 18 37 1 1889220864 10262256 4871968
14:11:34 7021 8192000000 10790207664 11214503936 1875305872 18.627 100 26 50 2 1893217200 10898064 7013264
14:11:48 6592 8192000000 10784263344 11218087936 1880737616 18.671 100 29 58 5 1897191248 7954272 8499360
14:12:03 5874 8192000000 10790308496 11220144128 1884120880 18.698 100 23 46 1 1896752336 6329696 6301760
14:12:15 5377 8192000000 10799386384 11225747456 1882525888 18.685 100 21 42 1 1895482144 7201712 5754544
14:12:30 9453 8192000000 10789997152 11223965696 1883630400 18.694 100 20 40 1 1895131840 6087024 5414416
14:12:46 12447 8192000000 10795512928 11228749824 1888645264 18.735 100 15 30 0 1898470464 5668416 4156784
14:13:11 15516 8192000000 10818301216 11238703104 1892311312 18.764 100 24 44 2 1903655008 4792848 6550848
14:13:34 44170 8192000000 10819804272 11244851200 1898522112 18.814 100 27 54 2 1912636816 6281184 7833520
14:14:24 17970 8192000000 10848492272 11254304768 1910977392 18.914 100 67 137 1 1938084416 6052896 21054128
14:14:49 3921 8192000000 10816112432 11251564544 1901914496 18.842 100 32 64 1 1919074176 7951568 9208112
14:14:59 8860 8192000000 10811690336 11250376704 1900482736 18.830 100 25 50 0 1914484240 5995824 8005680
14:15:14 5059 8192000000 10826039328 11257634816 1908973648 18.898 100 40 80 2 1927038576 4817904 13247024
14:15:26 6709 8192000000 10839537024 11261669376 1911039920 18.915 100 34 68 1 1926505248 6546608 8918720
14:15:39 8479 8192000000 10822711984 11260153856 1909205744 18.900 100 29 58 0 1924666512 7263616 8197152
14:15:55 6522 8192000000 10813311632 11244306432 1897046464 18.803 100 23 46 0 1909628544 5970992 6611088
14:16:11 5266 8192000000 10805071936 11230859264 1854882272 18.462 98 32 64 2 1874740032 11213504 8644256
14:16:22 7463 8192000000 10802071040 11220901888 1867861120 18.567 99 27 54 1 1885399072 10193712 7344240
14:16:36 7257 8192000000 10789717472 11229061120 1884248416 18.699 100 33 64 0 1900664864 7228960 9187488
14:16:49 7972 8192000000 10809422576 11232149504 1869377520 18.579 99 17 34 1 1878806896 4824944 4604432
14:17:08 11298 8192000000 10809490368 11244523520 1893831360 18.777 100 26 52 1 1907632592 6337584 7463648
14:17:25 12737 8192000000 10803189904 11229691904 1841685008 18.355 97 25 48 1 1854925248 6150864 7089376
14:17:44 9861 8192000000 10796904464 11232899072 1870795568 18.591 99 15 30 2 1880322160 5601968 3924624
14:18:01 50294 8192000000 10787897408 11204784128 1845917648 18.389 97 21 42 0 1856825136 4977376 5930112
14:18:57 23695 8192000000 10760126432 11195502592 1794961568 17.973 95 30 60 2 1809685344 5486752 9237024
14:19:29 8268 8192000000 10745604112 11173105664 1811985104 18.112 98 25 50 2 1824916000 5937040 6993856
14:19:44 5066 8192000000 10758070688 11178668032 1838368304 18.328 100 23 46 3 1850226128 5671792 6186032
14:19:57 6512 8192000000 10746302544 11158052864 1737818784 17.501 94 31 62 1 1752827200 6486944 8521472
14:20:11 4894 8192000000 10718809744 11122831360 1736311520 17.488 96 30 59 5 1752227264 6973200 8942544
14:20:27 7111 8192000000 10691970848 11113766912 1722187488 17.370 95 27 52 2 1735087600 5375920 7524192
14:20:45 6273 8192000000 10704809216 11118219264 1771211008 17.777 99 30 60 1 1786542784 5587616 9744160
14:21:00 9382 8192000000 10705662272 11125035008 1752927296 17.626 97 18 34 0 1762182208 4773264 4481648
14:21:16 4636 8192000000 10714327104 11126685696 1755334592 17.646 97 24 49 0 1768599232 5874560 7390080
14:21:28 6746 8192000000 10724444864 11141918720 1780882240 17.857 98 35 69 1 1798057776 6948912 10226624
14:21:43 6309 8192000000 10693932704 11101528064 1729013312 17.427 97 29 58 3 1744297072 6783600 8500160
14:21:57 8071 8192000000 10694373840 11112939520 1783358080 17.877 100 16 32 1 1793541648 5579920 4603648
14:22:13 11729 8192000000 10717494672 11133009920 1784271184 17.885 99 21 42 0 1796444016 6032144 6140688
14:22:32 11042 8192000000 10744230400 11159601152 1801481232 18.026 99 20 41 0 1812805568 5253360 6070976
14:22:49 57902 8192000000 10754941088 11170029568 1834394272 18.295 100 31 63 2 1848620224 4905152 9320800
14:23:57 20346 8192000000 10760669104 11177299968 1820588096 18.182 99 26 52 0 1833360640 5952816 6819728
14:24:25 6565 8192000000 10754383792 11181031424 1845080016 18.382 100 23 47 1 1857685136 6468096 6137024
14:24:38 5754 8192000000 10768923104 11189661696 1832324368 18.278 99 49 99 0 1856608896 10364640 13919888
14:24:50 5867 8192000000 10770096592 11189264384 1844872944 18.380 100 25 49 1 1857834032 5418032 7543056
14:25:04 6688 8192000000 10775018224 11195752448 1854586288 18.459 100 32 63 3 1870334912 4984704 10763920
14:25:17 8561 8192000000 10770007664 11195879424 1853041984 18.447 100 22 45 2 1865021008 5069808 6909216
14:25:35 11200 8192000000 10772129360 11201630208 1856962048 18.479 100 18 36 0 1868328624 5400272 5966304
14:25:53 9200 8192000000 10771319040 11199373312 1858772336 18.493 100 25 50 2 1871880016 4845904 8261776
14:26:08 7116 8192000000 10783883456 11208933376 1864423440 18.539 100 28 53 1 1877845440 5634768 7787232
14:26:22 8478 8192000000 10790144832 11214622720 1867944352 18.568 100 22 44 0 1879369392 5361200 6063840
14:26:40 8382 8192000000 10779879616 11213639680 1868807200 18.575 100 18 36 1 1879602096 5379360 5415536
14:26:54 12193 8192000000 10790082512 11219857408 1869955280 18.584 100 13 26 0 1878750832 4980976 3814576
14:27:13 41074 8192000000 10815790416 11237707776 1893552992 18.774 100 29 58 2 1907079840 5396096 8130752
14:28:04 18133 8192000000 10834076144 11253657600 1904003120 18.858 100 38 75 5 1922848064 8688336 10156608
14:28:37 72673 8192000000 10839635536 11273338880 1917474416 18.967 100 44 88 1 1940928320 11017744 12436160
14:30:36 83350 8192000000 10858316352 11297435648 1929436880 19.062 100 20 40 2 1948222192 12630016 6155296
14:32:06 15058 8192000000 10869850416 11306041344 1938282944 19.133 100 34 66 1 1965064016 17022496 9758576
14:32:35 59836 8192000000 10880093424 11317616640 1941445520 19.158 100 29 58 0 1967956352 18297072 8213760
14:33:42 12842 8192000000 10879990880 11316637696 1946941728 19.202 100 26 52 1 1970561216 15745792 7873696
14:34:04 22595 8192000000 10899740848 11326599168 1954598560 19.263 100 43 86 1 1982692352 15375216 12718576
14:34:38 32859 8192000000 10905602528 11345960960 1942664944 19.168 99 40 78 2 1979340448 25084816 11590688
14:35:22 8311 8192000000 10928508320 11354931200 1975086304 19.426 100 61 117 6 2016759904 24519360 17154240
14:35:38 1737 8192000000 10933591200 11359313920 1981165024 19.474 100 65 128 2 2026258656 24901104 20192528
14:35:46 3091 8192000000 10949085776 11369730048 1987516688 19.524 100 74 147 1 2035166576 26032368 21617520
14:36:02 8697 8192000000 10936729056 11363549184 1966654432 19.359 99 63 127 0 2013170544 27283280 19232832
14:36:17 8931 8192000000 10950709408 11371147264 1985740928 19.510 100 63 126 2 2034217536 29037392 19439216
14:36:34 16017 8192000000 10931396704 11364593664 1966393712 19.357 99 50 100 1 2010334240 28304544 15635984
14:37:01 6231 8192000000 10940733888 11367346176 1963875184 19.337 99 50 100 0 2009646256 30724240 15046832
14:37:16 5606 8192000000 10940759696 11366346752 1968437584 19.373 99 75 150 1 2018664528 28063536 22163408
14:37:36 4869 8192000000 10949556736 11372572672 1981769024 19.479 100 61 118 0 2028807168 28939472 18098672
14:37:48 6045 8192000000 10939792096 11373068288 1984531296 19.501 100 56 112 1 2030190224 28279312 17379616
14:38:02 4098 8192000000 10954003920 11382059008 1989706624 19.541 100 63 126 1 2040050816 30972240 19371952
14:38:13 4005 8192000000 10956050608 11378114560 1987436464 19.524 100 64 125 1 2036916880 30713296 18767120
14:38:23 7837 8192000000 10960564976 11388674048 1997939504 19.606 100 72 139 4 2051984128 32527840 21516784
14:38:47 10709 8192000000 10971596480 11395911680 2000819568 19.629 100 69 138 0 2056450416 34188528 21442320
14:39:06 5229 8192000000 10967366368 11391197184 1993554304 19.572 100 69 138 2 2052157152 37709952 20892896
14:39:18 5878 8192000000 10963251088 11394723840 1995506944 19.587 100 60 120 1 2050748144 36952960 18288240
14:39:33 8886 8192000000 10970846112 11402137600 2001465584 19.634 100 66 130 3 2060378016 38859696 20052736
14:39:54 3206 8192000000 10971877072 11395944448 1985237376 19.506 99 76 152 1 2048300208 39650656 23412176
14:40:05 3212 8192000000 10977312304 11393974272 1995048592 19.584 100 85 170 1 2061226384 40223904 25953888
14:40:16 2613 8192000000 10982518208 11396096000 1996868784 19.598 100 74 145 1 2060861952 41166864 22826304
14:40:27 5270 8192000000 10949261504 11376807936 1979522416 19.461 100 61 122 1 2037081696 39322624 18236656
14:40:40 5088 8192000000 10960762160 11378794496 1980853280 19.471 100 76 151 0 2043060976 39327616 22880080
14:40:53 1883 8192000000 10974884416 11392978944 1992630976 19.565 100 89 174 1 2060931968 41663152 26637840
14:41:02 3143 8192000000 10978573040 11396362240 2001912496 19.638 100 84 167 0 2063840352 36953568 24974288
14:41:12 5336 8192000000 10980481216 11397095424 1998007360 19.607 100 79 159 1 2058827920 37157888 23662672
14:41:25 1151 8192000000 10972730928 11393593344 2002897040 19.646 100 82 163 0 2062866048 35415792 24553216
14:41:36 3070 8192000000 10977652752 11404152832 2003822912 19.653 100 81 159 1 2063449392 35452672 24173808
14:41:46 3892 8192000000 10969420016 11408257024 2007082272 19.679 100 60 119 3 2060095856 35145696 17867888
14:41:57 6001 8192000000 10951660080 11384975360 1978924480 19.456 99 64 128 0 2031180304 31666240 20589584
14:42:11 6418 8192000000 10960990240 11387375616 1990794464 19.550 100 64 126 1 2043443712 32943808 19705440
14:42:26 3682 8192000000 10966099520 11396853760 1998233712 19.609 100 67 131 2 2052646288 34504448 19908128
14:42:43 2417 8192000000 10970929168 11397455872 1999554400 19.619 100 64 125 3 2054979920 35277360 20148160
14:42:52 1801 8192000000 10978635360 11392720896 1987267312 19.522 99 94 188 1 2051288432 35688800 28332320
14:43:10 3266 8192000000 10988650656 11412774912 2008847248 19.692 100 68 135 1 2066300896 36913616 20540032
14:43:21 1330 8192000000 11002753936 11415216128 2014211104 19.735 100 91 182 0 2080465472 38467936 27786432
14:43:29 2726 8192000000 10981891008 11403526144 1999377216 19.618 100 81 161 3 2061790608 37706720 24706672
14:43:41 3342 8192000000 10955939408 11373785088 1969896096 19.385 99 81 159 1 2032361632 37740896 24724640
14:43:52 2174 8192000000 10979877936 11396857856 1995282752 19.586 100 82 164 1 2057867552 37461808 25122992
14:44:01 2413 8192000000 10982252544 11396042752 1995787904 19.590 100 86 172 2 2061369568 39415696 26165968
14:44:10 2707 8192000000 10958715344 11370291200 1968454304 19.373 99 83 165 0 2033302192 39235232 25612656
14:44:19 10289 8192000000 10958945488 11377414144 1976438160 19.436 100 76 152 1 2040703216 42077040 22188016
14:44:37 1475 8192000000 10967744128 11385303040 1981121408 19.474 100 80 160 5 2048815056 43048864 24644784
14:44:48 2358 8192000000 10983398512 11397009408 1989703680 19.541 100 83 166 2 2058139360 42557264 25878416
14:45:01 2649 8192000000 10964783376 11381645312 1976253152 19.435 100 77 153 2 2041035120 42047024 22734944
14:45:11 2942 8192000000 10958933792 11379527680 1975303392 19.427 100 74 146 2 2042586592 44963376 22319824
14:45:21 3995 8192000000 10969735360 11392942080 1983399328 19.492 100 73 145 2 2049730640 44285984 22045328
14:45:31 2629 8192000000 10943251184 11357155328 1950881072 19.233 100 82 160 4 2020825248 43918192 26025984
14:45:42 1824 8192000000 10938240704 11339849728 1939081008 19.139 100 86 170 1 2010015280 45040496 25893776
14:45:52 1594 8192000000 10956152544 11363639296 1956466768 19.278 100 92 184 1 2032598944 47042896 29089280
14:46:02 3549 8192000000 10967701232 11381096448 1972874096 19.408 100 86 172 2 2048503648 48276928 27352624
14:46:12 1543 8192000000 10976101904 11385483264 1973934560 19.417 100 87 176 1 2051689968 49560608 28194800
14:46:20 4108 8192000000 10965833680 11383709696 1974913968 19.424 100 82 164 2 2052033168 50564864 26554336
14:46:32 1663 8192000000 10970410528 11381075968 1973134768 19.410 100 77 150 0 2043388144 47027920 23225456
14:46:43 3988 8192000000 10974345584 11393753088 1981309232 19.475 100 89 177 2 2060937584 51125696 28502656
14:46:57 9300 8192000000 10900266496 11341225984 1907946224 18.890 97 42 84 0 1967015568 45160816 13908528
14:47:26 22886 8192000000 10916501072 11360219136 1915695280 18.952 98 35 71 3 1973890512 46167712 12027520
14:47:56 8018 8192000000 10918017664 11341635584 1914707568 18.944 98 55 109 1 1979355360 45562992 19084800
14:48:11 6609 8192000000 10910553104 11340083200 1917421200 18.966 99 57 111 0 1985072192 49935936 17715056
14:48:29 5082 8192000000 10929217280 11347779584 1932373632 19.086 100 65 130 1 2005314672 51211024 21730016
14:48:41 2663 8192000000 10927605536 11345309696 1935626256 19.112 100 74 147 2 2006642608 47062560 23953792
14:48:51 9411 8192000000 10911432368 11347394560 1934239808 19.101 100 46 92 2 1998363648 48324064 15799776
14:49:18 11734 8192000000 10915471456 11356966912 1940073968 19.147 100 46 92 0 2004106432 48342976 15689488
14:49:40 14457 8192000000 10927163120 11367284736 1946134768 19.196 100 39 78 1 2010107744 50652736 13320240
14:50:11 13632 8192000000 10918163328 11373916160 1947853248 19.209 100 30 60 0 2003556448 45379344 10323856
14:51:05 25548 8192000000 10915199312 11363213312 1947985152 19.210 100 27 54 5 2000888224 43817776 9085296
14:51:40 23729 8192000000 10913923296 11376279552 1949483712 19.222 100 26 52 1 2008560048 49211088 9865248
14:52:16 23118 8192000000 10904685280 11369988096 1915315104 18.949 98 25 50 1 1972449888 48130656 9004128
14:52:50 34952 8192000000 10902946528 11359522816 1942853952 19.170 100 20 40 1 1988232864 38648544 6730368
14:53:33 44503 8192000000 10892648640 11364671488 1942955120 19.170 100 16 32 2 1985000080 36590704 5454256
14:54:23 38718 8192000000 10889007840 11366391808 1921630432 19.000 99 11 22 0 1961372560 35602848 4139280
14:56:23 20647 8192000000 10894672976 11335110656 1951369184 19.237 100 60 122 3 1975911936 6627840 17914912
14:57:37 92922 8192000000 10865954976 11324231680 1866232960 18.554 95 24 48 0 1882849408 9569568 7046880
14:59:22 96545 8192000000 10865406784 11329699840 1925888352 19.034 99 16 32 3 1941366848 10698912 4779584
15:01:06 29339 8192000000 10894506928 11328962560 1867600896 18.565 95 45 89 3 1889260528 9578992 12080640
15:02:00 32935 8192000000 10861903408 11309903872 1880979456 18.673 97 27 54 1 1902227792 12513536 8734800
15:02:41 18463 8192000000 10883041728 11320119296 1927072080 19.043 99 53 106 1 1950275904 7956592 15247232
15:03:07 16901 8192000000 10896923312 11327422464 1933243168 19.093 99 64 127 3 1958747216 7400176 18103872
15:03:32 41875 8192000000 10876438240 11332202496 1932886416 19.090 99 53 107 0 1963903664 16302864 14714384
15:04:27 45756 8192000000 10866077488 11336413184 1950530912 19.231 100 15 30 0 1963513648 8860240 4122496
15:05:38 24173 8192000000 10883182240 11355500544 1956105504 19.275 100 18 36 1 1971310160 10377696 4826960
15:07:24 59253 8192000000 10889846160 11353026560 1942858704 19.170 99 17 34 1 1959353184 11516832 4977648
15:08:32 169094 8192000000 10869035936 11351117824 1895514608 18.790 97 26 52 0 1918378656 15854144 7009904
15:11:28 45262 8192000000 10877233184 11336716288 1947032288 19.203 100 22 44 1 1964742624 11705920 6004416
15:12:21 3110 8192000000 10906726336 11334279168 1940453920 19.150 99 61 118 2 1965872272 7186640 18231712
15:12:31 19531 8192000000 10904592896 11351896064 1957468080 19.286 100 40 77 2 1978782688 10327536 10987072
15:12:57 54783 8192000000 10878402976 11349557248 1939863184 19.146 99 20 40 0 1957098496 11813968 5421344
15:14:09 47001 8192000000 10877301488 11361652736 1960983344 19.314 100 12 24 2 1977322768 13101856 3237568
15:15:02 45819 8192000000 10874795264 11350581248 1924278784 19.021 98 8 14 1 1937271616 11108752 1884080
15:15:57 35906 8192000000 10877513680 11344392192 1942578096 19.167 99 23 46 3 1958929104 8755648 7595360
15:16:55 63243 8192000000 10904494992 11370819584 1962851696 19.329 100 13 26 0 1973884384 6973040 4059648
15:18:06 17740 8192000000 10913820704 11369111552 1961508544 19.318 99 42 83 2 1983417904 10030032 11879328
15:18:31 51611 8192000000 10902465040 11380539392 1978314480 19.451 100 20 40 0 1997411088 12514528 6582080
15:19:39 63641 8192000000 10939791728 11384725504 1985761392 19.510 100 32 63 2 2011099760 15763728 9574640
15:20:52 19027 8192000000 10934492864 11389501440 1985538752 19.509 100 36 72 1 2010606384 14787184 10280448
15:21:17 24139 8192000000 10915094944 11367223296 1971180960 19.395 99 38 76 1 1996145872 13842704 11122208
15:21:49 46516 8192000000 10937455536 11398443008 1989863104 19.543 100 29 58 4 2010475824 12820672 7792048
15:22:44 59503 8192000000 10939697072 11412635648 1995218560 19.585 100 21 42 0 2017750144 16638544 5893040
15:23:49 34648 8192000000 10945228640 11383734272 1923856496 19.018 96 40 76 1 1951452640 16255648 11340496
15:24:31 44991 8192000000 10932237280 11408777216 1986285792 19.514 100 31 62 3 2019042224 23516192 9240240
15:25:22 66915 8192000000 10920999696 11396820992 1930976800 19.075 97 14 28 0 1966490848 31348368 4165680
15:26:36 85672 8192000000 10885527936 11363741696 1910007344 18.907 97 7 14 0 1932340224 20236464 2096416
15:28:08 48833 8192000000 10880910080 11333783552 1854082672 18.455 94 22 44 0 1867791984 8034448 5674864
15:29:03 84507 8192000000 10843654768 11309264896 1867352432 18.563 96 31 62 0 1883050736 7379600 8318704
15:30:34 28831 8192000000 10871496368 11318521856 1922452688 19.006 99 43 87 0 1943422192 8157392 12812112
15:31:09 24654 8192000000 10866913440 11322413056 1922719472 19.009 99 33 64 0 1940884496 9463520 8701504
15:32:26 79399 8192000000 10854655856 11332423680 1920961568 18.995 99 6 12 0 1931350080 8493952 1894560
15:33:54 31996 8192000000 10874518784 11344478208 1949927968 19.226 100 11 22 2 1962873648 10179264 2766416
15:34:35 63628 8192000000 10865016688 11338268672 1896983392 18.802 97 12 25 0 1915929232 15430880 3514960
15:35:45 52564 8192000000 10843705904 11313127424 1897062848 18.803 98 12 24 0 1914328432 13795248 3470336
15:37:22 48512 8192000000 10854938784 11331002368 1914316448 18.941 99 15 30 0 1928033008 9957232 3759328
15:38:20 69891 8192000000 10882963312 11347116032 1911084240 18.915 98 18 35 1 1924434080 8421488 4928352
15:39:45 32259 8192000000 10863066672 11318071296 1883545280 18.694 96 49 99 0 1909946288 12128992 14272016
15:40:47 79161 8192000000 10861428240 11321352192 1876833280 18.640 97 24 48 1 1898257856 14318208 7106368
15:42:20 58820 8192000000 10816807408 11281334272 1820088640 18.178 95 8 16 1 1833182432 10879904 2213888
15:43:28 65377 8192000000 10832395776 11300311040 1880746624 18.671 99 15 30 1 1898901776 13891408 4263744
15:44:42 23025 8192000000 10860567472 11308003328 1884873856 18.704 98 39 78 1 1907114240 11121280 11119104
15:45:18 45696 8192000000 10860630304 11306987520 1882839632 18.688 98 32 61 3 1904842480 13594992 8407856
15:46:11 23582 8192000000 10865425408 11315605504 1925499616 19.031 100 35 70 1 1944331952 9330832 9501504
15:46:42 33741 8192000000 10869870304 11331731456 1932952896 19.090 100 31 62 0 1956982576 15152528 8877152
15:47:25 55567 8192000000 10850301136 11321487360 1908578144 18.895 99 20 40 0 1931047472 16595568 5873760
15:48:30 86486 8192000000 10870576896 11328417792 1884141840 18.699 97 15 30 1 1901940064 13090560 4707664
15:50:02 15584 8192000000 10880914256 11336011776 1947794528 19.209 100 32 64 1 1967244064 10361072 9088464
15:50:29 91774 8192000000 10864702128 11343249408 1948777504 19.217 100 25 50 0 1968467648 12268352 7421792
15:52:08 47302 8192000000 10875983536 11334668288 1920820352 18.993 98 29 58 0 1935973728 7203376 7950000
15:53:03 35525 8192000000 10864843264 11318366208 1906001344 18.875 98 39 77 3 1926568784 8862816 11704624
15:53:45 72704 8192000000 10863674000 11342852096 1917097024 18.964 99 23 46 0 1940442800 15960736 7385040
15:55:04 25168 8192000000 10869745456 11348172800 1942673200 19.168 100 11 22 1 1967868560 22181968 3013392
15:55:36 22424 8192000000 10859442752 11329642496 1929705008 19.065 99 9 18 1 1949562800 17356992 2500800
15:56:27 68135 8192000000 10886136368 11356741632 1948732624 19.216 100 15 29 0 1971787520 18187872 4867024
15:57:41 60448 8192000000 10878827600 11361083392 1919037024 18.979 98 17 34 1 1940962352 16995600 4929728
15:58:47 60898 8192000000 10898576176 11358212096 1938679648 19.136 99 13 26 0 1963487376 21038464 3769264
16:00:03 99468 8192000000 10897279392 11362992128 1941136176 19.156 98 21 42 2 1959380592 12267216 5977200
16:02:02 29982 8192000000 10913717296 11380547584 1979491024 19.461 100 19 38 0 1996402560 11575968 5335568
16:02:38 55588 8192000000 10928775760 11389784064 1980965536 19.472 100 14 28 0 2002341328 17460800 3914992
16:03:43 56143 8192000000 10902769424 11382374400 1944693920 19.184 98 15 30 1 1962209504 13607008 3908576
16:04:47 46086 8192000000 10913479632 11378925568 1960811216 19.312 99 19 38 0 1975447824 9049424 5587184
16:05:40 57224 8192000000 10896637744 11368321024 1938475024 19.135 98 27 53 1 1957293376 11673200 7145152
16:06:45 59313 8192000000 10911033280 11363704832 1916539776 18.959 97 29 58 0 1938031280 13110992 8380512
16:08:01 29853 8192000000 10923422208 11368677376 1954154320 19.260 99 41 82 1 1979545712 13929776 11461616
16:09:17 117852 8192000000 10885180416 11366703104 1939889360 19.146 98 15 30 0 1963958560 19863248 4205952
16:11:39 86007 8192000000 10899303024 11367882752 1944752256 19.185 98 24 47 2 1960992464 9499568 6740640
16:13:16 42162 8192000000 10870667056 11362078720 1930249280 19.069 98 8 16 0 1941849792 9377200 2223312
16:14:15 58256 8192000000 10857227968 11332759552 1862098960 18.520 95 13 26 0 1873761360 7837104 3825296
16:15:31 89444 8192000000 10817523504 11295076352 1808098272 18.080 93 5 10 2 1817515008 8317216 1099520
16:17:07 60538 8192000000 10854221984 11331391488 1911507648 18.919 99 11 22 2 1922158096 7503216 3147232
16:18:13 82576 8192000000 10866104384 11348967424 1927616240 19.048 99 15 29 2 1940164160 8380032 4167888
16:19:54 53221 8192000000 10852005472 11318710272 1852011200 18.438 95 20 40 1 1865137008 7530368 5595440
16:21:07 40074 8192000000 10876999136 11338825728 1927259008 19.045 99 18 36 0 1945702736 13260752 5182976
16:21:59 58918 8192000000 10858723904 11332341760 1890195584 18.747 97 18 36 2 1905853696 10323968 5334144
16:23:10 41073 8192000000 10893551056 11349704704 1931113376 19.076 99 34 68 1 1951487984 10286048 10088560
16:24:17 50197 8192000000 10873112576 11344556032 1916523824 18.959 98 20 40 2 1929261824 7634368 5103632
16:25:13 58920 8192000000 10868805248 11323650048 1851366464 18.433 95 28 54 4 1870119296 10732080 8020752
16:26:29 42951 8192000000 10879615264 11332952064 1881903152 18.680 97 32 64 0 1900808816 10019536 8886128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-01-2021 16:28:24 to 20-01-2021 16:28:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-01-2021 16:28:56 to 20-01-2021 16:28:58.

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          237390
MON$OLDEST_ACTIVE               241200
MON$OLDEST_SNAPSHOT             241200
MON$NEXT_TRANSACTION            241200
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                       2023744
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:118: 
:119: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:15 2021
:120:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:121: 
:122: 
:123: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:15 2021
:124:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:125: 
:126: 
:127: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:16 2021
:128:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:129: 
:130: 
:131: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:17 2021
:132:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:133: 
:134: 
:135: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:17 2021
:136:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:137: 
:138: 
:139: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:17 2021
:140:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:141: 
:142: 
:143: mscs-test-161.budzdorov.ru    Wed Jan 20 16:27:19 2021
:144:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:145: 
--- end of diff output ---

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

20.01.21 16:28:59. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-20 16:29:02 No severe PSQL-related problems occured
20.01.21 16:29:03. End of report.