Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.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 17443164 kB
MemAvailable 31611340 kB
Buffers 0 kB
Cached 14192856 kB
SwapCached 1180 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 2020-11-29 01:27:02
DTS_END                         2020-11-29 01:27:02.1290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(108:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57268
TRN_ID                          238954
ATT_ID                          674
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: 9352.39 25089 1122287
customer order: creation 171.72 360 20606
customer order: refuse 15.16 353 1819
order to supplier: creation 45.26 1278 5431
order to supplier: removal 3.62 92871 434
invoice (draft): creation 46.24 3463 5549
invoice (draft): removal 53.98 729 6478
invoice accept: apply 40.81 18754 4897
invoice accept: cancel 48.52 845 5822
customer reserve: creation 3809.72 183 457166
customer reserve: removal 4824.69 54 578963
realization accept: apply 83.15 188 9978
realization accept: cancel 79.41 115 9529
payment from customer: creation 59.91 142 7189
payment from customer: removal 5.75 113 690
payment to supplier: creation 48.34 152 5801
payment to supplier: removal 3.49 150 419
service: total inventory turnovers 5.17 1045 620
service: total monetary turnovers 6.50 43 780
service: aggregate perf. data 0.93 17736 112
service: refresh index statistics 0.03 363203 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5625
TEST_TIME 2 4956
TEST_TIME 3 4403
TEST_TIME 4 4164
TEST_TIME 5 4540
TEST_TIME 6 4689
TEST_TIME 7 4837
TEST_TIME 8 5528
TEST_TIME 9 6033
TEST_TIME 10 6636
TEST_TIME 11 6667
TEST_TIME 12 7106
TEST_TIME 13 7317
TEST_TIME 14 7520
TEST_TIME 15 7762
TEST_TIME 16 8005
TEST_TIME 17 8554
TEST_TIME 18 8555
TEST_TIME 19 8669
TEST_TIME 20 9217
TEST_TIME 21 9212
TEST_TIME 22 9506
TEST_TIME 23 9573
TEST_TIME 24 9714
TEST_TIME 25 9954
TEST_TIME 26 10807
TEST_TIME 27 11197
TEST_TIME 28 11013
TEST_TIME 29 10957
TEST_TIME 30 10824
TEST_TIME 31 10678
TEST_TIME 32 10636
TEST_TIME 33 10574
TEST_TIME 34 10606
TEST_TIME 35 10478
TEST_TIME 36 10313
TEST_TIME 37 10280
TEST_TIME 38 10235
TEST_TIME 39 10231
TEST_TIME 40 10275
TEST_TIME 41 10193
TEST_TIME 42 10057
TEST_TIME 43 10037
TEST_TIME 44 9894
TEST_TIME 45 9930
TEST_TIME 46 9896
TEST_TIME 47 9793
TEST_TIME 48 9679
TEST_TIME 49 9623
TEST_TIME 50 9753
TEST_TIME 51 9815
TEST_TIME 52 9754
TEST_TIME 53 9777
TEST_TIME 54 9845
TEST_TIME 55 9836
TEST_TIME 56 9825
TEST_TIME 57 9767
TEST_TIME 58 9896
TEST_TIME 59 9845
TEST_TIME 60 10045
TEST_TIME 61 10066
TEST_TIME 62 10084
TEST_TIME 63 10265
TEST_TIME 64 10114
TEST_TIME 65 10025
TEST_TIME 66 10000
TEST_TIME 67 9924
TEST_TIME 68 9828
TEST_TIME 69 9761
TEST_TIME 70 9799
TEST_TIME 71 9737
TEST_TIME 72 9816
TEST_TIME 73 9826
TEST_TIME 74 9941
TEST_TIME 75 9848
TEST_TIME 76 9880
TEST_TIME 77 9852
TEST_TIME 78 9799
TEST_TIME 79 9882
TEST_TIME 80 9877
TEST_TIME 81 9857
TEST_TIME 82 9777
TEST_TIME 83 9709
TEST_TIME 84 9650
TEST_TIME 85 9679
TEST_TIME 86 9623
TEST_TIME 87 9609
TEST_TIME 88 9615
TEST_TIME 89 9569
TEST_TIME 90 9521
TEST_TIME 91 9476
TEST_TIME 92 9528
TEST_TIME 93 9544
TEST_TIME 94 9520
TEST_TIME 95 9582
TEST_TIME 96 9591
TEST_TIME 97 9609
TEST_TIME 98 9566
TEST_TIME 99 9639
TEST_TIME 100 9621
TEST_TIME 101 9626
TEST_TIME 102 9663
TEST_TIME 103 9619
TEST_TIME 104 9691
TEST_TIME 105 9658
TEST_TIME 106 9608
TEST_TIME 107 9551
TEST_TIME 108 9502
TEST_TIME 109 9513
TEST_TIME 110 9476
TEST_TIME 111 9438
TEST_TIME 112 9416
TEST_TIME 113 9383
TEST_TIME 114 9358
TEST_TIME 115 9397
TEST_TIME 116 9414
TEST_TIME 117 9389
TEST_TIME 118 9403
TEST_TIME 119 9437
TEST_TIME 120 9359

Performance per minute, chart


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

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 1546620 1546620 0 0.00 0 28932 6 0 0
doc_list_biud 1546613 1546613 0 0.00 0 35980 26 0 0
sp_add_invoice_to_stock 5025 4897 128 2.54 38 219360 18754 0 128
sp_cancel_adding_invoice 5822 5822 0 0.00 5 75532 845 0 0
sp_cancel_client_order 1819 1819 0 0.00 4 7254 354 0 0
sp_cancel_customer_reserve 578963 578963 0 0.00 1 23927 55 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 3 20664 114 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 14167 151 0 0
sp_cancel_supplier_invoice 6488 6478 10 0.15 1 16974 730 0 10
sp_cancel_supplier_order 434 434 0 0.00 6 941422 92872 0 0
sp_cancel_write_off 9529 9529 0 0.00 1 11410 115 0 0
sp_client_order 20606 20606 0 0.00 4 25814 361 0 0
sp_customer_reserve 457166 457166 0 0.00 0 62776 184 0 0
sp_fill_shopping_cart 31576 31576 0 0.00 1 22312 42 0 0
sp_fill_shopping_cart_clo_res 457155 457155 0 0.00 0 18935 14 0 0
sp_get_clo_for_invoice 4886 4886 0 0.00 0 16961 287 0 0
sp_kill_cost_storno 16460 16460 0 0.00 0 20654 58 0 0
sp_kill_qstorno_ret_qs2qd 1174367 1174367 0 0.00 0 23907 29 0 0
sp_kill_qty_storno 617909 617909 0 0.00 0 35976 65 0 0
sp_lock_selected_doc 20670 20670 0 0.00 0 10414 8 0 0
sp_make_cost_storno 27854 27854 0 0.00 0 28336 65 0 0
sp_multiply_rows_for_pdistr 27854 27854 0 0.00 0 16383 34 0 0
sp_multiply_rows_for_qdistr 20606 20606 0 0.00 0 25508 184 0 0
sp_pay_from_customer 7189 7189 0 0.00 4 26246 143 0 0
sp_pay_to_supplier 5801 5801 0 0.00 5 28501 152 0 0
sp_payment_common 12990 12990 0 0.00 1 26226 46 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 6340 312 0 0
sp_qd_handle_on_invoice_upd_sts 10708 10708 0 0.00 0 35970 361 0 0
sp_qd_handle_on_reserve_upd_sts 9978 9978 0 0.00 0 10517 54 0 0
sp_reserve_write_off 9978 9978 0 0.00 6 28492 189 0 0
sp_supplier_invoice 5549 5549 0 0.00 6 91617 3464 0 0
sp_supplier_order 5431 5431 0 0.00 5 52604 1278 0 0
srv_aggregate_perf_data 112 112 0 0.00 2658 165047 17736 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1344 142955 31516 0 0
srv_find_qd_qs_mism 1075221 1075221 0 0.00 0 18548 5 0 0
srv_make_invnt_saldo 620 620 0 0.00 39 64800 1045 0 0
srv_make_money_saldo 780 780 0 0.00 0 8125 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 253229 602934 363204 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4898 4898 0 0.00 0 19042 171 0 0
t$perf-norm:sp_cancel_adding_invoice 425 425 0 0.00 0 2318 79 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 5369 24 0 0
t$perf-norm:sp_cancel_customer_reserve 642 642 0 0.00 0 6582 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 6491 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 1217 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 300 9 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 30408 1420 0 0
t$perf-norm:sp_cancel_write_off 1031 1031 0 0.00 0 894 4 0 0
t$perf-norm:sp_client_order 20606 20606 0 0.00 0 19636 18 0 0
t$perf-norm:sp_customer_reserve 1030 1030 0 0.00 0 1634 6 0 0
t$perf-norm:sp_pay_from_customer 7189 7189 0 0.00 0 10458 10 0 0
t$perf-norm:sp_pay_to_supplier 5801 5801 0 0.00 0 12105 13 0 0
t$perf-norm:sp_reserve_write_off 9978 9978 0 0.00 0 8665 11 0 0
t$perf-norm:sp_supplier_invoice 5549 5549 0 0.00 0 12978 19 0 0
t$perf-norm:sp_supplier_order 5431 5431 0 0.00 0 6101 19 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 225 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 666 8 0 0
t$perf-norm:srv_make_invnt_saldo 620 620 0 0.00 0 1788 24 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 665 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 10024 9768 256 2.55 0 4643 20 0 256
v_all_customers 37460 37460 0 0.00 0 232 1 0 0
v_all_suppliers 30462 30462 0 0.00 0 16 1 0 0
v_all_wares 41212 41212 0 0.00 0 124 1 0 0
v_cancel_adding_invoice 850 850 0 0.00 0 2972 14 0 0
v_cancel_client_order 3638 3638 0 0.00 0 3254 11 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 3545 9 0 0
v_cancel_customer_reserve 1284 1284 0 0.00 0 2493 7 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 1127 7 0 0
v_cancel_supplier_invoice 716 696 20 2.79 0 3265 24 0 20
v_cancel_supplier_order 868 868 0 0.00 0 657 4 0 0
v_cancel_write_off 2062 2062 0 0.00 0 1880 13 0 0
v_max_id_clo_ord 5429 5429 0 0.00 0 222 1 0 0
v_max_id_clo_res 1030 1030 0 0.00 0 2743 14 0 0
v_max_id_ord_sup 5541 5541 0 0.00 0 8431 7 0 0
v_max_non_paid_invoice 1540 1540 0 0.00 0 2807 6 0 0
v_max_non_paid_realizn 3864 3864 0 0.00 0 13866 10 0 0
v_min_id_clo_ord 5429 5429 0 0.00 0 19661 17 0 0
v_min_id_clo_res 1030 1030 0 0.00 0 4816 8 0 0
v_min_id_ord_sup 5541 5541 0 0.00 0 8754 10 0 0
v_min_non_paid_invoice 5801 5801 0 0.00 0 14253 29 0 0
v_min_non_paid_realizn 7189 7189 0 0.00 0 13883 32 0 0
v_our_firm 10402 10402 0 0.00 0 16 1 0 0
v_reserve_write_off 19956 19956 0 0.00 0 3214 5 0 0
x_lock_depdocs_on_canc_invoice 11952 11952 0 0.00 0 15606 119 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 13423 357 0 0
x_make_qstorno_1000_1200 5431 5431 0 0.00 2 52583 1186 0 0
x_make_qstorno_1200_2000 5549 5549 0 0.00 3 85104 3322 0 0
x_make_qstorno_2100_3300 457166 457166 0 0.00 0 62772 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-11-2020 01:28:08 to 29-11-2020 01:28:12.

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:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:12 3979 8192000000 9908020192 10154696704 710575088 7.981 59 40 83 0 725984768 1962448 13447232
22:57:24 20523 8192000000 10288073472 10596945920 1311455712 13.799 100 76 153 0 1340912864 3876848 25580304
22:57:55 33840 8192000000 10358822624 10679443456 1404660224 14.636 100 85 170 1 1439755616 6515152 28580240
22:58:39 27347 8192000000 10391062464 10720878592 1437966000 14.932 100 79 158 4 1470829536 7192128 25671408
22:59:15 29484 8192000000 10429169760 10766143488 1484769216 15.343 100 88 176 0 1521056880 8042384 28245280
22:59:53 15674 8192000000 10450011664 10785837056 1501048544 15.485 100 92 184 0 1539286656 8677136 29560976
23:00:18 7209 8192000000 10455083264 10793889792 1513949792 15.598 100 81 162 0 1548922800 8845696 26127312
23:00:33 16597 8192000000 10471894720 10810368000 1527636640 15.717 100 86 172 1 1564318256 9214336 27467280
23:01:00 19516 8192000000 10504855376 10846351360 1542858016 15.848 100 84 168 0 1578899040 9488256 26552768
23:01:30 15186 8192000000 10502236784 10853199872 1564838992 16.038 100 84 168 1 1600776816 10234528 25703296
23:01:54 17293 8192000000 10534104992 10884943872 1590532240 16.258 100 84 168 0 1626052400 10477008 25043152
23:02:22 16444 8192000000 10560710176 10914807808 1609917584 16.424 100 83 166 1 1646139392 11521664 24700144
23:02:47 10835 8192000000 10582484176 10937761792 1635083984 16.638 100 88 175 2 1673203536 12037568 26081984
23:03:08 14216 8192000000 10587470096 10950819840 1650065072 16.765 100 81 163 1 1687110288 13126128 23919088
23:03:31 16529 8192000000 10606259296 10975383552 1665156960 16.892 100 78 156 1 1699616112 11955808 22503344
23:03:56 10932 8192000000 10615478992 10988412928 1681674032 17.031 100 77 154 1 1716578896 11733472 23171392
23:04:16 8173 8192000000 10641414144 11010596864 1705605328 17.232 100 81 162 0 1741563552 12586256 23371968
23:04:31 8944 8192000000 10663144064 11034284032 1722408320 17.372 100 87 174 1 1760946864 13654496 24884048
23:04:47 6484 8192000000 10679913984 11054587904 1743272608 17.546 100 79 154 5 1777678640 12925984 21480048
23:05:01 7863 8192000000 10700545328 11076370432 1760700048 17.690 100 87 169 2 1798074352 13918800 23455504
23:05:18 4590 8192000000 10711020720 11089768448 1769129296 17.760 100 79 158 0 1805024160 13937328 21957536
23:05:30 4125 8192000000 10717866816 11094085632 1778110576 17.834 100 89 179 2 1817463488 14096672 25256240
23:05:41 3184 8192000000 10718443872 11099742208 1782159312 17.867 100 80 160 0 1817875200 13295936 22419952
23:05:52 4076 8192000000 10728028960 11111653376 1793306064 17.959 100 84 168 1 1829589680 12399200 23884416
23:06:03 2971 8192000000 10744028704 11126677504 1802462576 18.034 100 87 173 1 1839634032 12731008 24440448
23:06:13 3663 8192000000 10744577824 11126575104 1804145680 18.048 100 80 160 2 1838952992 12587888 22219424
23:06:23 2936 8192000000 10749088752 11136012288 1813801520 18.127 100 86 171 3 1849810560 12921632 23087408
23:06:33 2303 8192000000 10755500672 11137511424 1818820368 18.168 100 90 180 0 1857695088 13709904 25164816
23:06:42 5940 8192000000 10756875744 11141894144 1816471904 18.149 100 78 157 5 1855949856 17644048 21833904
23:06:54 4694 8192000000 10760395840 11152994304 1824888944 18.218 100 83 166 1 1861373680 13378352 23106384
23:07:06 2451 8192000000 10785514032 11171803136 1837908784 18.324 100 85 168 3 1874208400 12939584 23360032
23:07:14 2033 8192000000 10789734816 11176554496 1849131200 18.415 100 91 175 2 1886706752 12919712 24655840
23:07:23 2066 8192000000 10794224256 11182714880 1852748896 18.444 100 91 179 1 1890909952 13077008 25084048
23:07:32 1760 8192000000 10802819856 11192791040 1859862352 18.502 100 85 170 1 1896538592 12356720 24319520
23:07:40 1705 8192000000 10808233200 11196153856 1860549584 18.508 100 92 185 0 1899700384 13256048 25894752
23:07:49 1738 8192000000 10814513360 11204001792 1868642224 18.573 100 93 186 1 1907215952 13087664 25486064
23:07:57 1414 8192000000 10814587888 11202416640 1871349232 18.595 100 98 198 1 1913490496 14047536 28093728
23:08:05 2881 8192000000 10816711872 11206946816 1871094624 18.593 100 87 171 0 1908370640 12868096 24407920
23:08:14 1171 8192000000 10815535744 11203416064 1872599472 18.605 100 86 172 1 1909400848 12690400 24110976
23:08:21 1351 8192000000 10818250272 11211120640 1872594800 18.605 100 83 167 1 1909220224 12035024 24590400
23:08:29 14208 8192000000 10805352592 11204345856 1871552496 18.597 100 73 148 1 1903926640 12005760 20368384
23:09:00 1378 8192000000 10814129280 11207241728 1877289984 18.643 100 90 181 1 1915806832 12708480 25808368
23:09:09 21544 8192000000 10788415120 11202928640 1870031744 18.585 100 44 88 1 1892503696 9835920 12636032
23:09:37 6043 8192000000 10795040032 11207335936 1869558208 18.581 100 44 88 0 1888845328 6644880 12642240
23:09:50 5370 8192000000 10783191488 11205451776 1866858560 18.559 100 27 54 1 1881773680 7452992 7462128
23:10:03 4012 8192000000 10776049664 11202719744 1867609280 18.565 100 25 49 3 1881246352 7073392 6563680
23:10:14 6777 8192000000 10787999216 11209895936 1874423712 18.620 100 40 81 2 1894650544 8624016 11602816
23:10:29 7971 8192000000 10781528368 11207278592 1872668576 18.606 100 23 43 1 1884427456 5926896 5831984
23:10:43 6139 8192000000 10788880304 11215253504 1876352496 18.636 100 28 54 2 1890696944 7097632 7246816
23:10:58 6344 8192000000 10788193264 11214254080 1880612448 18.670 100 35 68 1 1898284656 8087776 9584432
23:11:11 6260 8192000000 10784227344 11211051008 1878927616 18.656 100 19 37 2 1889593856 5211744 5454496
23:11:23 6855 8192000000 10787448336 11214979072 1877553952 18.645 100 20 40 2 1889262880 6315344 5393584
23:11:38 10406 8192000000 10784546272 11217182720 1881633024 18.678 100 16 32 1 1891716224 5538816 4544384
23:11:55 13410 8192000000 10787830144 11222503424 1882919024 18.689 100 17 32 3 1893665648 6204048 4542576
23:12:15 14510 8192000000 10794496880 11227156480 1888513792 18.734 100 23 45 4 1900681504 5995888 6171824
23:12:36 8904 8192000000 10798120624 11228672000 1891229856 18.756 100 12 24 0 1903672912 9635920 2807136
23:12:52 13670 8192000000 10798565216 11231494144 1897054896 18.803 100 24 48 2 1911050048 5673120 8322032
23:13:12 52166 8192000000 10825006672 11248136192 1901196032 18.836 100 39 73 2 1918320912 6094560 11030320
23:14:11 23266 8192000000 10818619904 11255603200 1903853408 18.857 100 30 60 1 1919981216 7857232 8270576
23:14:41 5089 8192000000 10821198016 11256344576 1911458112 18.918 100 36 69 5 1928899296 5850912 11590272
23:14:56 3009 8192000000 10833732000 11263705088 1908526384 18.895 100 33 67 0 1924643536 6679376 9437776
23:15:09 4782 8192000000 10831912256 11266658304 1912703472 18.928 100 35 70 0 1928998928 6357392 9938064
23:15:20 5230 8192000000 10833055072 11268165632 1913133856 18.932 100 28 57 1 1927831920 6521248 8176816
23:15:34 12198 8192000000 10823773008 11263967232 1913767840 18.937 100 21 42 1 1924962464 5527168 5667456
23:15:56 7762 8192000000 10814249456 11252170752 1901463632 18.838 100 19 38 2 1913076656 6083216 5529808
23:16:10 5641 8192000000 10825825984 11259027456 1906917248 18.882 100 15 29 2 1916701504 5500640 4283616
23:16:23 9908 8192000000 10815199264 11237789696 1869070160 18.577 98 16 32 0 1878758640 5026656 4661824
23:16:39 11714 8192000000 10792168000 11224375296 1831238080 18.269 96 29 58 1 1845714288 6593904 7882304
23:16:57 9002 8192000000 10795653600 11223658496 1868549856 18.573 99 20 40 1 1880264608 5803232 5911520
23:17:14 10754 8192000000 10805514480 11242586112 1878709744 18.655 99 14 28 0 1888312896 5671808 3931344
23:17:31 9608 8192000000 10794097280 11224461312 1843901840 18.373 97 25 50 0 1856433360 5582304 6949216
23:17:49 9067 8192000000 10776195360 11210399744 1815345680 18.140 96 17 32 0 1826047856 6162160 4540016
23:18:06 49592 8192000000 10740649152 11162222592 1802190064 18.032 97 22 44 0 1814485568 6098352 6197152
23:19:04 41280 8192000000 10707007920 11127631872 1605589552 16.387 86 26 51 3 1619178400 5768864 7819984
23:19:54 6061 8192000000 10728087744 11149848576 1799268560 18.008 99 33 64 1 1816141536 7345424 9527552
23:20:08 2469 8192000000 10732352720 11150397440 1804907600 18.054 99 31 62 0 1820546224 6689968 8948656
23:20:20 5425 8192000000 10722783904 11139162112 1782678624 17.872 98 28 56 1 1797212144 5982912 8550608
23:20:34 6329 8192000000 10700410304 11111936000 1726137760 17.403 96 31 63 1 1741268160 5859520 9270880
23:20:47 7813 8192000000 10709438032 11127447552 1741115360 17.528 96 33 66 1 1757240688 6477232 9648096
23:21:03 8030 8192000000 10681274000 11092287488 1638642240 16.668 91 23 46 3 1650661136 5347760 6671136
23:21:18 5263 8192000000 10701596096 11118694400 1785890240 17.898 100 29 58 1 1801340320 6119488 9330592
23:21:30 6619 8192000000 10719455328 11137425408 1788298496 17.918 99 24 47 5 1800287872 5038912 6950464
23:21:43 7096 8192000000 10733926480 11150774272 1797042864 17.990 99 23 46 3 1810178496 6269680 6865952
23:21:56 8496 8192000000 10733641424 11145760768 1798777008 18.004 99 26 52 1 1812258928 6342208 7139712
23:22:12 9407 8192000000 10736141232 11151290368 1787305200 17.910 98 39 78 0 1804849600 5976736 11567664
23:22:27 12018 8192000000 10725035744 11145854976 1782472304 17.870 98 18 36 1 1793038896 4911664 5654928
23:22:46 21386 8192000000 10772486800 11179724800 1833319264 18.286 100 23 47 4 1844945408 5192736 6433408
23:23:15 70414 8192000000 10772044016 11192635392 1849964912 18.422 100 39 77 2 1867608000 6643104 10999984
23:24:34 10141 8192000000 10761331408 11191386112 1851869568 18.437 100 19 38 0 1862440192 5425088 5145536
23:24:51 8588 8192000000 10773332976 11201556480 1858416400 18.490 100 26 52 3 1872011040 6402192 7192448
23:25:06 3706 8192000000 10777547568 11203502080 1860475984 18.507 100 41 82 3 1879310464 7379632 11454848
23:25:16 8660 8192000000 10770074816 11200589824 1858384656 18.490 100 22 43 1 1870099600 5467232 6247712
23:25:36 5728 8192000000 10778708528 11206746112 1864379536 18.539 100 27 50 2 1877098912 5852368 6867008
23:25:50 5551 8192000000 10785859600 11212914688 1868688384 18.574 100 33 65 1 1884932976 5871488 10373104
23:26:02 9285 8192000000 10788137376 11214565376 1865416000 18.547 100 16 31 2 1875541104 5252256 4872848
23:26:19 10712 8192000000 10786778720 11213611008 1868885552 18.575 100 15 30 1 1878298992 4841248 4572192
23:26:36 9506 8192000000 10788284448 11217707008 1873570512 18.613 100 25 51 1 1886393280 4977968 7844800
23:26:55 16615 8192000000 10797855232 11227201536 1878526848 18.653 100 30 60 3 1892518208 5780576 8210784
23:27:32 8196 8192000000 10829035168 11245432832 1896432960 18.798 100 39 78 1 1912471584 4974112 11064512
23:27:47 8335 8192000000 10843826672 11259375616 1910932672 18.914 100 56 111 6 1934651632 6771248 16947712
23:28:15 53713 8192000000 10856742016 11281068032 1922383104 19.006 100 39 78 0 1941497968 8137328 10977536
23:29:25 51064 8192000000 10867795168 11294646272 1937171552 19.124 100 37 73 1 1959064224 11442368 10450304
23:30:31 127786 8192000000 10874045552 11321118720 1949930320 19.226 100 30 60 2 1970150560 11478512 8741728
23:32:49 4101 8192000000 10886049440 11321413632 1956600224 19.279 100 38 70 1 1978447664 11113280 10734160
23:32:59 27337 8192000000 10903930864 11335704576 1966078000 19.354 100 43 86 0 1993770832 14627792 13065040
23:33:34 6520 8192000000 10905486896 11340562432 1968503152 19.374 100 39 78 2 1996603232 15817216 12282864
23:33:57 4385 8192000000 10923047008 11347476480 1981361104 19.475 100 67 132 2 2015779344 15050896 19367344
23:34:13 5582 8192000000 10916210272 11350827008 1978374592 19.452 100 57 111 1 2011001552 16378032 16248928
23:34:27 5411 8192000000 10926172880 11351355392 1976222480 19.435 100 62 120 2 2010922272 16533232 18166560
23:34:39 7294 8192000000 10927391280 11354935296 1979002496 19.457 100 63 126 1 2016750848 19301904 18446448
23:34:54 18688 8192000000 10934770192 11358924800 1977877472 19.448 100 69 139 1 2019920896 21022480 21020944
23:35:20 13467 8192000000 10929990384 11361046528 1978979984 19.457 100 55 111 0 2014916832 19654672 16282176
23:35:40 7306 8192000000 10925872512 11355287552 1983361760 19.491 100 58 116 1 2019441472 19384288 16695424
23:35:55 9322 8192000000 10935011200 11359387648 1969064080 19.378 99 68 136 1 2005668144 16589008 20015056
23:36:15 2879 8192000000 10948490960 11364855808 1991040752 19.552 100 84 166 0 2033594832 18235440 24318640
23:36:25 5069 8192000000 10937985024 11362246656 1986632032 19.517 100 67 134 0 2025987232 19482240 19872960
23:36:40 4841 8192000000 10940115984 11364786176 1987660448 19.525 100 65 130 1 2025884528 18559552 19664528
23:36:54 2497 8192000000 10942541552 11375177728 1988757888 19.534 100 60 119 0 2029777184 22633216 18386080
23:37:06 4001 8192000000 10949751088 11375153152 1996587024 19.596 100 67 133 2 2035082800 17742768 20753008
23:37:18 1803 8192000000 10955901568 11381235712 2006569120 19.675 100 79 157 1 2048922592 19262064 23091408
23:37:26 1870 8192000000 10965291872 11378225152 2003174048 19.648 100 82 164 1 2047989264 20509136 24306080
23:37:34 2667 8192000000 10939192048 11356631040 1987875616 19.527 99 78 153 1 2030872544 19994448 23002480
23:37:44 1973 8192000000 10967378512 11380760576 2000430096 19.626 100 84 164 3 2043984976 19461840 24093040
23:37:58 2241 8192000000 10954739616 11382927360 1999048096 19.615 100 62 124 0 2036757632 19117248 18592288
23:38:10 2533 8192000000 10972244480 11390099456 2007931344 19.685 100 81 162 3 2053441600 20617984 24892272
23:38:20 11573 8192000000 10951238384 11374903296 1969060944 19.378 98 70 140 0 2010976928 21673776 20242208
23:38:39 12764 8192000000 10955497280 11385475072 1999265904 19.617 100 70 140 2 2045207632 25325728 20616000
23:39:01 1599 8192000000 10964199296 11390431232 2007074672 19.678 100 87 175 0 2055710944 23246016 25390256
23:39:11 8046 8192000000 10975254560 11402723328 2012908416 19.724 100 80 159 0 2064223536 27188880 24126240
23:39:26 2501 8192000000 10980600384 11404636160 2020501104 19.784 100 78 155 0 2066264784 22678000 23085680
23:39:37 4710 8192000000 10969177968 11384963072 1990889392 19.551 99 77 150 1 2037326176 22492896 23943888
23:39:49 7420 8192000000 10962796320 11391897600 2005047968 19.663 100 65 130 0 2047057328 22350608 19658752
23:40:03 5524 8192000000 10968370736 11396927488 1992601680 19.564 99 67 134 0 2040602384 27928096 20072608
23:40:18 3938 8192000000 10979160640 11411496960 2016925904 19.756 100 66 132 1 2067306464 30130944 20249616
23:40:31 5180 8192000000 10991567648 11410386944 2011966080 19.717 100 86 172 2 2063822960 25568864 26288016
23:40:43 3580 8192000000 10989042176 11412160512 2020102944 19.781 100 79 156 3 2070806064 27160864 23542256
23:40:53 4323 8192000000 10993311856 11422060544 2025795392 19.826 100 74 148 0 2079001472 30539248 22666832
23:41:08 2483 8192000000 10986258480 11408289792 2000550976 19.627 99 71 142 0 2053239088 31107984 21580128
23:41:17 2089 8192000000 10986351456 11400499200 1994755392 19.581 99 87 174 1 2050732160 29787248 26189520
23:41:26 3713 8192000000 10976295024 11389673472 1995462128 19.587 99 78 156 1 2049858672 30400608 23995936
23:41:37 5368 8192000000 10964348416 11388665856 1991745728 19.558 99 76 152 3 2045476048 30096464 23633856
23:41:50 2538 8192000000 10956393648 11370180608 1979946272 19.464 100 84 168 0 2037908256 31871040 26090944
23:42:00 3658 8192000000 10968919728 11382689792 1987163840 19.521 100 88 175 2 2047643600 33252720 27227040
23:42:09 1343 8192000000 10947134208 11357847552 1965082816 19.346 99 90 177 4 2027775840 34551184 28141840
23:42:17 3597 8192000000 10935693472 11348480000 1952202800 19.244 99 88 176 4 2013527200 34078512 27245888
23:42:27 4349 8192000000 10938104304 11359842304 1969370976 19.380 100 73 146 1 2025057088 33300352 22385760
23:42:39 5388 8192000000 10946022240 11373383680 1977718752 19.447 100 72 142 1 2034093792 33398992 22976048
23:42:52 1484 8192000000 10946938912 11374440448 1981078880 19.473 100 70 139 0 2033520304 30253920 22187504
23:43:00 2044 8192000000 10974099216 11390517248 1993833600 19.574 100 88 176 0 2052066944 31427872 26805472
23:43:09 1651 8192000000 10958630032 11371327488 1968492096 19.373 99 90 180 1 2029452432 33415808 27544528
23:43:17 3566 8192000000 10962993072 11374034944 1975980944 19.433 100 85 168 1 2036469264 35308288 25180032
23:43:30 2416 8192000000 10981488240 11392622592 1995948384 19.591 100 91 182 1 2060599568 37598576 27052608
23:43:41 2194 8192000000 10982439040 11398770688 2000366112 19.626 100 88 172 0 2063922800 37692976 25863712
23:43:53 2241 8192000000 10984488896 11396874240 1984863088 19.503 99 89 178 0 2046677136 35797760 26016288
23:44:02 1397 8192000000 10981400064 11393036288 1996017088 19.591 100 91 181 6 2057658896 35150384 26491424
23:44:11 3733 8192000000 10973452960 11395178496 1998467312 19.611 100 89 177 1 2060360176 35500512 26392352
23:44:21 1424 8192000000 10968770176 11375190016 1975280624 19.427 100 94 187 2 2040898144 37971920 27645600
23:44:30 3568 8192000000 10953876528 11360817152 1963777056 19.336 99 87 173 2 2027763744 38796992 25189696
23:44:41 1939 8192000000 10956322128 11371143168 1958885936 19.297 99 85 169 0 2024252544 39675648 25690960
23:44:55 2061 8192000000 10929979056 11356794880 1967083520 19.362 100 63 126 3 2018821648 32725440 19012688
23:45:05 5274 8192000000 10895163904 11330494464 1925348080 19.030 98 39 78 1 1969082864 30893504 12841280
23:45:20 14155 8192000000 10913909664 11345743872 1937744384 19.129 99 45 90 0 1984081728 31766064 14571280
23:45:46 5890 8192000000 10914661760 11339198464 1943823328 19.177 100 64 129 0 1998748128 34420544 20504256
23:46:02 6212 8192000000 10927281696 11347869696 1949741968 19.224 100 71 143 3 2009787408 36314496 23730944
23:46:16 7752 8192000000 10929387520 11352657920 1948372912 19.214 100 65 130 1 2009757168 39715024 21669232
23:46:31 2190 8192000000 10944312656 11353706496 1953910480 19.258 100 85 168 0 2020865264 39992304 26962480
23:46:42 2426 8192000000 10945698816 11358019584 1956548800 19.279 100 82 163 1 2022123664 40120320 25454544
23:46:51 2825 8192000000 10933101136 11352072192 1953389248 19.253 100 75 150 1 2019699488 42462928 23847312
23:47:03 2680 8192000000 10935949360 11354873856 1952835984 19.249 100 77 153 0 2021012880 43319600 24857296
23:47:13 3908 8192000000 10906240192 11339984896 1938281440 19.133 100 47 93 0 1995282240 42030448 14970352
23:47:28 6641 8192000000 10892093984 11327209472 1917088672 18.964 99 39 78 3 1966025904 35693136 13244096
23:47:42 7897 8192000000 10900451616 11330875392 1931783616 19.081 100 51 102 1 1988140688 39650112 16706960
23:47:59 14483 8192000000 10894447328 11325493248 1914608112 18.944 99 32 64 0 1961929312 36230528 11090672
23:48:30 2609 8192000000 10919049616 11345129472 1940558256 19.151 100 50 99 2 1996682720 39498512 16625952
23:48:48 19978 8192000000 10906880736 11351851008 1928393632 19.054 99 42 84 0 1986776976 44171760 14211584
23:49:22 14654 8192000000 10899930112 11346116608 1942758080 19.169 100 34 68 1 1989536912 35924272 10854560
23:49:45 8143 8192000000 10880928496 11315204096 1914751888 18.945 99 34 68 1 1961180576 34983408 11445280
23:50:02 14311 8192000000 10880772080 11323531264 1907705792 18.888 99 33 66 2 1955847312 36247104 11894416
23:50:38 23902 8192000000 10854694656 11288510464 1878345024 18.652 99 29 58 0 1927339344 38764816 10229504
23:51:16 14752 8192000000 10861783584 11299110912 1891227280 18.756 100 31 62 1 1946461600 44268704 10965616
23:51:47 21021 8192000000 10864484016 11310526464 1893479120 18.774 100 24 48 1 1949410512 46907376 9024016
23:52:44 21517 8192000000 10855862384 11308208128 1888525408 18.734 100 16 31 1 1940779136 46107008 6146720
23:53:12 30371 8192000000 10835923264 11294855168 1871498384 18.596 99 9 18 0 1903409408 28919312 2991712
23:53:51 40520 8192000000 10817619536 11260334080 1849768560 18.420 98 17 34 0 1873921344 19440096 4712688
23:54:48 34396 8192000000 10817491424 11261517824 1867734624 18.566 99 4 8 0 1875856752 7195792 926336
23:55:29 46842 8192000000 10833360432 11277283328 1857002112 18.479 98 21 43 4 1874136432 10640736 6493584
23:56:23 52272 8192000000 10851736336 11287085056 1879990464 18.665 99 22 43 2 1898730128 12781264 5958400
23:57:21 96637 8192000000 10873408560 11307474944 1886780336 18.720 98 21 41 2 1907532736 14778944 5973456
23:59:38 110085 8192000000 10857976800 11309498368 1904556192 18.863 98 32 64 1 1926188736 11796512 9836032
00:01:38 94284 8192000000 10874651792 11339096064 1949192384 19.220 100 7 14 0 1961982240 10937360 1852496
00:03:19 23698 8192000000 10926936416 11350302720 1962657344 19.327 100 33 65 2 1982804336 10924160 9222832
00:03:49 13660 8192000000 10907127136 11355095040 1966237200 19.356 100 35 70 0 1985827808 9940160 9650448
00:04:16 91677 8192000000 10911432048 11365990400 1961821792 19.321 99 24 46 2 1976581392 8642240 6117360
00:06:12 49941 8192000000 10910726496 11387068416 1978447376 19.452 100 15 30 3 2000454304 16938416 5068512
00:07:09 22248 8192000000 10894175328 11381080064 1957109120 19.283 99 7 14 0 1971711552 12518464 2083968
00:07:56 13175 8192000000 10888251264 11364282368 1969648608 19.383 100 14 29 1 1980813904 7352400 3812896
00:08:19 12608 8192000000 10882949088 11359797248 1971520480 19.398 100 7 14 0 1980703136 7467088 1715568
00:08:38 27024 8192000000 10898248448 11361206272 1970918400 19.393 100 14 28 1 1980621728 5909456 3793872
00:09:11 65194 8192000000 10912196448 11382177792 1985526320 19.508 100 13 26 0 2003212864 13713600 3972944
00:11:51 117385 8192000000 10905334256 11390889984 1996173264 19.593 100 15 30 0 2015066608 14047392 4845952
00:13:55 25673 8192000000 10915782176 11397152768 1974483808 19.421 99 19 38 0 1991157312 11980976 4692528
00:14:27 17117 8192000000 10912617696 11387662336 1974022320 19.417 99 15 30 1 1991836416 12999184 4814912
00:14:56 44965 8192000000 10923318992 11392491520 1983122576 19.489 99 22 44 2 2001035488 11921344 5991568
00:16:49 93903 8192000000 10913081792 11404275712 1987335904 19.523 100 9 18 0 2002549456 12884288 2329264
00:20:02 30935 8192000000 10932721680 11404476416 2003814944 19.653 100 24 48 1 2021931664 11409376 6707344
00:20:42 32227 8192000000 10912527712 11386535936 1963396896 19.333 98 23 46 0 1983598064 13705792 6495376
00:21:21 27085 8192000000 10909254880 11376062464 1952028784 19.243 98 33 66 3 1969323280 8202128 9092368
00:22:00 53014 8192000000 10926216992 11400998912 1990968416 19.551 100 27 54 1 2009368288 10776960 7622912
00:23:07 41413 8192000000 10922353648 11389050880 1963238352 19.332 98 25 50 1 1982863504 12493392 7131760
00:24:24 34336 8192000000 10943418352 11408076800 1998301056 19.609 100 30 60 4 2024383088 17298224 8783808
00:25:13 62932 8192000000 10938570528 11405119488 1964719664 19.344 98 14 28 2 1985804944 16840864 4244416
00:26:28 64181 8192000000 10921252272 11400298496 1982427168 19.484 99 20 40 0 2007461152 19559312 5474672
00:27:38 86880 8192000000 10905742896 11391889408 1928117552 19.052 96 10 20 1 1944656016 14073168 2465296
00:29:11 96855 8192000000 10905197136 11383980032 1862727760 18.525 93 9 18 2 1885612176 20471200 2413216
00:30:55 86878 8192000000 10857434240 11312033792 1875531760 18.629 96 15 30 1 1896589440 17011712 4045968
00:33:06 68187 8192000000 10858256304 11340480512 1875407680 18.628 96 20 40 1 1892302864 11670208 5224976
00:34:22 33532 8192000000 10865823040 11353997312 1944013248 19.179 100 4 8 0 1955789744 10965280 811216
00:35:02 8380 8192000000 10862802832 11339345920 1926947648 19.042 99 5 8 1 1938622752 10964976 710128
00:35:16 69935 8192000000 10895701840 11352301568 1887729360 18.727 96 22 44 1 1903019488 9436016 5854112
00:36:33 41531 8192000000 10875372736 11351654400 1917874480 18.970 98 21 42 0 1942165232 17823648 6467104
00:37:43 34500 8192000000 10901304848 11368308736 1945785712 19.193 99 27 54 1 1967211984 13455664 7970608
00:38:28 50420 8192000000 10892987440 11375280128 1916720512 18.961 97 18 36 0 1941281712 18893552 5667648
00:39:34 98950 8192000000 10894458688 11375357952 1883510128 18.693 96 11 22 0 1918530496 31334960 3685408
00:41:20 46056 8192000000 10862071088 11311902720 1852478272 18.442 95 18 35 1 1871852480 14618080 4756128
00:42:13 17180 8192000000 10905721008 11346763776 1950974704 19.234 100 52 104 2 1974856960 8594240 15288016
00:42:36 9742 8192000000 10919532960 11357007872 1962367984 19.325 100 66 129 0 1990472752 10211632 17893136
00:42:56 9023 8192000000 10902030400 11343650816 1906108336 18.875 97 64 126 2 1940019616 15647280 18264000
00:43:14 49468 8192000000 10876695040 11341869056 1885489232 18.709 97 41 82 1 1909399072 12258176 11651664
00:44:14 31134 8192000000 10874623600 11327590400 1905252048 18.869 98 37 74 2 1925282320 9803360 10226912
00:44:54 39249 8192000000 10879196224 11321077760 1871479568 18.596 97 36 71 1 1896030320 15276336 9274416
00:45:40 17430 8192000000 10855526000 11296165888 1887016896 18.722 98 41 82 2 1914023216 15595088 11411232
00:46:04 22100 8192000000 10850595648 11313434624 1901489584 18.838 99 32 64 0 1921787696 11476240 8821872
00:46:39 57576 8192000000 10878868464 11332661248 1899305296 18.821 98 15 31 0 1920310848 17257040 3748512
00:47:43 19616 8192000000 10880028448 11343773696 1936794816 19.121 100 19 38 3 1962544720 20696576 5053328
00:48:12 142955 8192000000 10852049776 11317018624 1869157216 18.577 96 21 42 0 1886481200 11438160 5885824
00:50:42 59260 8192000000 10875613344 11326271488 1919328496 18.981 99 40 81 0 1941083888 10527408 11227984
00:52:07 47864 8192000000 10857567072 11336826880 1936828288 19.121 100 25 47 0 1956745040 13061632 6855120
00:53:01 67526 8192000000 10841523328 11312074752 1902245088 18.844 98 8 16 1 1920365248 15619472 2500688
00:54:15 46639 8192000000 10847888368 11318497280 1912449056 18.926 99 9 18 0 1925364848 10605168 2310624
00:55:08 86308 8192000000 10847481152 11316056064 1904570176 18.863 98 15 30 0 1916278272 7671408 4036688
00:56:41 72852 8192000000 10857630256 11326533632 1893397072 18.773 97 14 28 0 1909680384 12054560 4228752
00:58:43 93126 8192000000 10878749296 11371782144 1940308384 19.149 100 12 24 0 1956809120 13539504 2961232
01:00:23 85644 8192000000 10883836128 11356397568 1902336256 18.845 97 12 22 0 1921566784 16373200 2857328
01:02:00 89659 8192000000 10898965776 11367247872 1957512240 19.286 100 11 22 0 1971656672 11324448 2819984
01:03:36 60417 8192000000 10902210080 11368935424 1953785216 19.257 99 20 40 2 1971524848 12006832 5732800
01:04:42 59848 8192000000 10926114512 11378954240 1976800400 19.439 100 19 38 0 1994112080 11829568 5482112
01:05:51 48167 8192000000 10922504928 11396276224 1989763136 19.542 100 37 74 0 2014344336 14099456 10481744
01:06:53 134223 8192000000 10914851936 11387260928 1925221168 19.029 97 16 31 1 1943435472 14399472 3814832
01:09:18 87729 8192000000 10908545008 11356061696 1855624384 18.468 93 16 32 0 1871170720 11586528 3959808
01:10:53 77104 8192000000 10906717376 11393843200 1969282160 19.380 100 31 63 1 1993786704 15805072 8699472
01:12:18 123119 8192000000 10903630512 11378561024 1946244128 19.197 98 26 52 0 1965708112 12207824 7256160
01:14:41 49428 8192000000 10901059872 11364331520 1945986064 19.194 98 26 53 0 1960112112 7000816 7125232
01:15:36 38197 8192000000 10902844672 11371057152 1958552416 19.295 99 40 78 0 1979242176 9568336 11121424
01:17:12 53224 8192000000 10878711136 11364282368 1952783536 19.249 99 4 8 0 1960901632 7110752 1007344
01:19:14 42001 8192000000 10903370384 11379773440 1961728672 19.320 99 16 32 0 1975667456 9584672 4354112
01:20:02 67017 8192000000 10898481856 11379826688 1950883712 19.234 98 20 40 0 1967864736 11254032 5726992
01:21:33 79630 8192000000 10888630064 11363057664 1907182784 18.884 96 17 35 3 1926800400 14378416 5239200
01:23:04 59268 8192000000 10864922144 11337883648 1826457472 18.230 93 12 24 0 1838782352 8732576 3592304
01:24:09 66335 8192000000 10869498480 11334742016 1915443360 18.950 98 20 40 0 1929822240 8767328 5611552
01:25:22 75522 8192000000 10872318640 11345862656 1886746288 18.720 96 29 58 1 1903793488 8859808 8187392
01:26:46 24884 8192000000 9303854736 9580974080 445762432 5.160 24 2 4 0 450648400 4534720 351248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 29-11-2020 01:28:47 to 29-11-2020 01:28:48.

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          239233
MON$OLDEST_ACTIVE               239234
MON$OLDEST_SNAPSHOT             239234
MON$NEXT_TRANSACTION            239234
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                       2034400
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:67: 
:68: mscs-test-161.budzdorov.ru    Sun Nov 29 01:27:12 2020
:69:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:70: 
:71: 
:72: mscs-test-161.budzdorov.ru    Sun Nov 29 01:27:13 2020
:73:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:74: 
:75: 
:76: mscs-test-161.budzdorov.ru    Sun Nov 29 01:27:15 2020
:77:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:78: 
--- end of diff output ---

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

29.11.20 01:28:49. 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-29 01:28:52 No severe PSQL-related problems occured
29.11.20 01:28:53. End of report.