Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.11.2020 22: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 17199788 kB
MemAvailable 31455452 kB
Buffers 0 kB
Cached 14468004 kB
SwapCached 3300 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-24 22:27:05
DTS_END                         2020-11-24 22:27:05.3810
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42068
TRN_ID                          240580
ATT_ID                          710
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: 9198.67 25273 1103841
customer order: creation 171.15 350 20538
customer order: refuse 15.15 405 1818
order to supplier: creation 46.79 1291 5615
order to supplier: removal 3.43 112979 411
invoice (draft): creation 45.68 3679 5481
invoice (draft): removal 52.98 863 6357
invoice accept: apply 41.99 17651 5039
invoice accept: cancel 47.24 867 5669
customer reserve: creation 3845.18 175 461422
customer reserve: removal 4635.59 65 556271
realization accept: apply 83.94 196 10073
realization accept: cancel 78.51 126 9421
payment from customer: creation 59.12 116 7094
payment from customer: removal 6.08 69 730
payment to supplier: creation 50.05 125 6006
payment to supplier: removal 3.35 75 402
service: total inventory turnovers 4.83 1079 579
service: total monetary turnovers 6.78 27 813
service: aggregate perf. data 0.82 19723 98
service: refresh index statistics 0.03 345589 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-11-2020 22:28:14 to 24-11-2020 22:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2663
TEST_TIME 2 4002
TEST_TIME 3 5117
TEST_TIME 4 5364
TEST_TIME 5 5722
TEST_TIME 6 5553
TEST_TIME 7 5879
TEST_TIME 8 5777
TEST_TIME 9 5608
TEST_TIME 10 6141
TEST_TIME 11 6260
TEST_TIME 12 6408
TEST_TIME 13 6568
TEST_TIME 14 6804
TEST_TIME 15 6770
TEST_TIME 16 7355
TEST_TIME 17 7712
TEST_TIME 18 7697
TEST_TIME 19 7937
TEST_TIME 20 7754
TEST_TIME 21 8367
TEST_TIME 22 8312
TEST_TIME 23 9096
TEST_TIME 24 9350
TEST_TIME 25 9313
TEST_TIME 26 9300
TEST_TIME 27 9916
TEST_TIME 28 10373
TEST_TIME 29 11405
TEST_TIME 30 11459
TEST_TIME 31 11233
TEST_TIME 32 11196
TEST_TIME 33 11342
TEST_TIME 34 11217
TEST_TIME 35 11487
TEST_TIME 36 11182
TEST_TIME 37 11015
TEST_TIME 38 10855
TEST_TIME 39 10701
TEST_TIME 40 10489
TEST_TIME 41 10382
TEST_TIME 42 10274
TEST_TIME 43 10257
TEST_TIME 44 10137
TEST_TIME 45 10038
TEST_TIME 46 10081
TEST_TIME 47 10032
TEST_TIME 48 9991
TEST_TIME 49 9880
TEST_TIME 50 9748
TEST_TIME 51 9780
TEST_TIME 52 9757
TEST_TIME 53 9691
TEST_TIME 54 9575
TEST_TIME 55 9543
TEST_TIME 56 9508
TEST_TIME 57 9562
TEST_TIME 58 9539
TEST_TIME 59 9486
TEST_TIME 60 9397
TEST_TIME 61 9267
TEST_TIME 62 9217
TEST_TIME 63 9156
TEST_TIME 64 9135
TEST_TIME 65 9223
TEST_TIME 66 9202
TEST_TIME 67 9210
TEST_TIME 68 9244
TEST_TIME 69 9274
TEST_TIME 70 9217
TEST_TIME 71 9291
TEST_TIME 72 9247
TEST_TIME 73 9233
TEST_TIME 74 9403
TEST_TIME 75 9465
TEST_TIME 76 9447
TEST_TIME 77 9473
TEST_TIME 78 9428
TEST_TIME 79 9406
TEST_TIME 80 9378
TEST_TIME 81 9341
TEST_TIME 82 9334
TEST_TIME 83 9297
TEST_TIME 84 9262
TEST_TIME 85 9235
TEST_TIME 86 9199
TEST_TIME 87 9159
TEST_TIME 88 9198
TEST_TIME 89 9180
TEST_TIME 90 9151
TEST_TIME 91 9121
TEST_TIME 92 9170
TEST_TIME 93 9197
TEST_TIME 94 9235
TEST_TIME 95 9260
TEST_TIME 96 9277
TEST_TIME 97 9300
TEST_TIME 98 9298
TEST_TIME 99 9287
TEST_TIME 100 9363
TEST_TIME 101 9356
TEST_TIME 102 9312
TEST_TIME 103 9412
TEST_TIME 104 9422
TEST_TIME 105 9336
TEST_TIME 106 9303
TEST_TIME 107 9250
TEST_TIME 108 9321
TEST_TIME 109 9288
TEST_TIME 110 9250
TEST_TIME 111 9212
TEST_TIME 112 9213
TEST_TIME 113 9179
TEST_TIME 114 9212
TEST_TIME 115 9211
TEST_TIME 116 9203
TEST_TIME 117 9193
TEST_TIME 118 9228
TEST_TIME 119 9275
TEST_TIME 120 9200

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-11-2020 22:28:18 to 24-11-2020 22:28:21.

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 1531305 1531305 0 0.00 0 42577 6 0 0
doc_list_biud 1531303 1531303 0 0.00 0 51078 30 0 0
sp_add_invoice_to_stock 5158 5039 119 2.30 30 176572 17651 0 119
sp_cancel_adding_invoice 5669 5669 0 0.00 6 68079 868 0 0
sp_cancel_client_order 1818 1818 0 0.00 4 28652 405 0 0
sp_cancel_customer_reserve 556271 556271 0 0.00 1 51079 66 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 3 4012 70 0 0
sp_cancel_pay_to_supplier 402 402 0 0.00 3 4260 76 0 0
sp_cancel_supplier_invoice 6367 6357 10 0.15 2 16459 864 0 10
sp_cancel_supplier_order 411 411 0 0.00 10 1071736 112979 0 0
sp_cancel_write_off 9421 9421 0 0.00 1 26491 127 0 0
sp_client_order 20538 20538 0 0.00 4 27192 351 0 0
sp_customer_reserve 461422 461422 0 0.00 0 76418 176 0 0
sp_fill_shopping_cart 31625 31625 0 0.00 1 27926 43 0 0
sp_fill_shopping_cart_clo_res 461410 461410 0 0.00 0 22997 14 0 0
sp_get_clo_for_invoice 5027 5027 0 0.00 0 47004 306 0 0
sp_kill_cost_storno 16222 16222 0 0.00 0 6372 62 0 0
sp_kill_qstorno_ret_qs2qd 1128731 1128731 0 0.00 0 51074 36 0 0
sp_kill_qty_storno 595047 595047 0 0.00 0 51077 77 0 0
sp_lock_selected_doc 20993 20993 0 0.00 0 7428 5 0 0
sp_make_cost_storno 28200 28200 0 0.00 0 15067 52 0 0
sp_multiply_rows_for_pdistr 28200 28200 0 0.00 0 8182 27 0 0
sp_multiply_rows_for_qdistr 20538 20538 0 0.00 0 27181 143 0 0
sp_pay_from_customer 7094 7094 0 0.00 4 26250 116 0 0
sp_pay_to_supplier 6006 6006 0 0.00 4 15585 126 0 0
sp_payment_common 13100 13100 0 0.00 1 26241 32 0 0
sp_qd_handle_on_cancel_clo 1818 1818 0 0.00 0 28640 376 0 0
sp_qd_handle_on_invoice_upd_sts 10696 10696 0 0.00 0 30884 349 0 0
sp_qd_handle_on_reserve_upd_sts 10073 10073 0 0.00 0 25601 75 0 0
sp_reserve_write_off 10073 10073 0 0.00 6 26515 196 0 0
sp_supplier_invoice 5481 5481 0 0.00 6 91059 3679 0 0
sp_supplier_order 5615 5615 0 0.00 5 65289 1291 0 0
srv_aggregate_perf_data 98 98 0 0.00 2471 225862 19723 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1151 147186 30682 0 0
srv_find_qd_qs_mism 1056066 1056066 0 0.00 0 42577 5 0 0
srv_make_invnt_saldo 579 579 0 0.00 35 53253 1079 0 0
srv_make_money_saldo 813 813 0 0.00 1 674 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 213649 492733 345589 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 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 5039 5039 0 0.00 0 17022 174 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 3415 103 0 0
t$perf-norm:sp_cancel_client_order 1818 1818 0 0.00 0 15006 27 0 0
t$perf-norm:sp_cancel_customer_reserve 695 695 0 0.00 0 11121 39 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 194 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 402 402 0 0.00 0 899 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 1159 17 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 31812 1838 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 15091 38 0 0
t$perf-norm:sp_client_order 20538 20538 0 0.00 0 15078 25 0 0
t$perf-norm:sp_customer_reserve 1021 1021 0 0.00 0 1793 4 0 0
t$perf-norm:sp_pay_from_customer 7094 7094 0 0.00 0 8409 13 0 0
t$perf-norm:sp_pay_to_supplier 6006 6006 0 0.00 0 13067 17 0 0
t$perf-norm:sp_reserve_write_off 10073 10073 0 0.00 0 7737 14 0 0
t$perf-norm:sp_supplier_invoice 5481 5481 0 0.00 0 7912 24 0 0
t$perf-norm:sp_supplier_order 5615 5615 0 0.00 0 6947 21 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 314 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 708 9 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 837 21 0 0
t$perf-norm:srv_make_money_saldo 813 813 0 0.00 0 900 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10292 10054 238 2.31 0 13793 21 0 238
v_all_customers 37010 37010 0 0.00 0 22 1 0 0
v_all_suppliers 31052 31052 0 0.00 0 22 1 0 0
v_all_wares 41074 41074 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 1258 8 0 0
v_cancel_client_order 3636 3636 0 0.00 0 4146 6 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 1203 6 0 0
v_cancel_customer_reserve 1390 1390 0 0.00 0 5064 13 0 0
v_cancel_payment_to_supplier 804 804 0 0.00 0 1273 7 0 0
v_cancel_supplier_invoice 844 824 20 2.36 0 5690 30 0 20
v_cancel_supplier_order 822 822 0 0.00 0 889 5 0 0
v_cancel_write_off 2006 2006 0 0.00 0 5282 18 0 0
v_max_id_clo_ord 5615 5615 0 0.00 0 4612 2 0 0
v_max_id_clo_res 1021 1021 0 0.00 0 4327 26 0 0
v_max_id_ord_sup 5472 5472 0 0.00 0 7789 8 0 0
v_max_non_paid_invoice 1567 1567 0 0.00 0 2467 5 0 0
v_max_non_paid_realizn 3892 3892 0 0.00 0 19846 10 0 0
v_min_id_clo_ord 5615 5615 0 0.00 0 2395 6 0 0
v_min_id_clo_res 1021 1021 0 0.00 0 2347 9 0 0
v_min_id_ord_sup 5472 5472 0 0.00 0 5952 4 0 0
v_min_non_paid_invoice 6006 6006 0 0.00 0 8186 17 0 0
v_min_non_paid_realizn 7094 7094 0 0.00 0 6263 18 0 0
v_our_firm 10468 10468 0 0.00 0 22 1 0 0
v_reserve_write_off 20146 20146 0 0.00 0 5666 7 0 0
x_lock_depdocs_on_canc_invoice 11614 11614 0 0.00 0 18789 132 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 17117 454 0 0
x_make_qstorno_1000_1200 5615 5615 0 0.00 2 65278 1204 0 0
x_make_qstorno_1200_2000 5481 5481 0 0.00 3 89031 3523 0 0
x_make_qstorno_2100_3300 461422 461422 0 0.00 0 76417 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-11-2020 22:28:22 to 24-11-2020 22:28:26.

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
19:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 31008 8192000000 10308736368 10626789376 1211289968 12.881 90 76 151 1 1238864320 3500064 24074288
19:57:56 37218 8192000000 10376750928 10705117184 1433541760 14.893 100 86 172 0 1467189248 6208064 27439424
19:58:45 9427 8192000000 10411536480 10740318208 1462440448 15.147 100 85 170 0 1497060672 7252368 27367856
19:59:08 15720 8192000000 10432392480 10764570624 1483792080 15.335 100 85 170 0 1519050320 7944192 27314048
19:59:42 3282 8192000000 10453891040 10787479552 1511010976 15.572 100 91 182 0 1548431952 8917280 28503696
19:59:59 16784 8192000000 10466804720 10809266176 1527549024 15.716 100 87 173 1 1564069056 9242336 27277696
20:00:24 25574 8192000000 10495178832 10837155840 1542405488 15.844 100 87 174 2 1579372928 9879872 27087568
20:01:05 12139 8192000000 10512295472 10855194624 1561522464 16.009 100 87 174 0 1598767504 10356576 26888464
20:01:26 16617 8192000000 10516927536 10865463296 1577493216 16.147 100 84 168 0 1614177136 10975024 25708896
20:01:56 21709 8192000000 10553549552 10904920064 1603095568 16.366 100 84 168 0 1640059856 11271904 25692384
20:02:27 14838 8192000000 10565726896 10922668032 1620306160 16.513 100 83 166 1 1657338880 11704416 25328304
20:02:52 11098 8192000000 10586967120 10943574016 1634759280 16.635 100 79 158 0 1670558576 11869232 23930064
20:03:12 12639 8192000000 10603470080 10963472384 1652688048 16.787 100 80 160 0 1689408848 12428992 24291808
20:03:32 11241 8192000000 10620617968 10983452672 1673769584 16.965 100 90 178 1 1712931136 12251952 26909600
20:03:52 13044 8192000000 10628852496 10994188288 1687033904 17.076 100 80 160 0 1723180656 12566944 23579808
20:04:14 10835 8192000000 10641044720 11013447680 1701039392 17.194 100 72 143 1 1733693120 12410336 20243392
20:04:32 7603 8192000000 10655044656 11031728128 1714451728 17.306 100 70 136 4 1745795760 11632720 19711312
20:04:46 4905 8192000000 10673517872 11047337984 1741322704 17.530 100 80 157 2 1774959152 11406784 22229664
20:05:00 6213 8192000000 10680036160 11058515968 1749154928 17.595 100 73 146 1 1781452192 11556592 20740672
20:05:13 5363 8192000000 10704390976 11080396800 1758621472 17.673 100 74 147 0 1795871392 16043376 21206544
20:05:25 4056 8192000000 10706669296 11083603968 1771507648 17.779 100 82 162 0 1807386784 12610208 23268928
20:05:36 2957 8192000000 10718310544 11099766784 1778951056 17.841 100 87 170 1 1816802688 13311952 24539680
20:05:46 3738 8192000000 10719498608 11103047680 1785362832 17.894 100 82 160 1 1820890032 13032336 22494864
20:05:58 4683 8192000000 10730155472 11112804352 1793677008 17.962 100 87 175 0 1831994000 12833296 25483696
20:06:10 4244 8192000000 10743144848 11126444032 1799804352 18.012 100 88 175 1 1838418416 14260656 24353408
20:06:22 11899 8192000000 10739284976 11129528320 1805843200 18.062 100 76 152 1 1841634336 14472304 21318832
20:06:44 3274 8192000000 10757184960 11153338368 1826607120 18.232 100 78 155 0 1860916800 12482608 21827072
20:06:54 2720 8192000000 10780570704 11166994432 1835728064 18.306 100 88 177 1 1874595664 14159920 24707680
20:07:04 2135 8192000000 10776384864 11167453184 1845131216 18.383 100 83 164 2 1881007424 12785328 23090880
20:07:12 1851 8192000000 10786235872 11176103936 1846292592 18.392 100 89 178 0 1884629712 12902608 25434512
20:07:21 2585 8192000000 10795414224 11183685632 1850620688 18.427 100 86 172 3 1888680144 13448704 24610752
20:07:30 1137 8192000000 10797866592 11188162560 1857388496 18.482 100 96 192 2 1902096736 18151952 26556288
20:07:38 2060 8192000000 10798784096 11185967104 1862443520 18.523 100 89 179 1 1901715776 13960912 25311344
20:07:46 1731 8192000000 10803962304 11195629568 1864833536 18.542 100 94 189 1 1904054208 13087632 26133040
20:07:54 1345 8192000000 10808542928 11196420096 1868257344 18.570 100 91 183 0 1905484032 11633024 25593664
20:08:02 1279 8192000000 10813193136 11199430656 1868283168 18.570 100 82 160 3 1903785472 13533568 21968736
20:08:10 1948 8192000000 10814469152 11208228864 1873506192 18.613 100 88 177 0 1911240976 12800656 24934128
20:08:18 1583 8192000000 10815758816 11209375744 1874030192 18.617 100 86 176 0 1910724240 11695920 24998128
20:08:26 26913 8192000000 10817053936 11211702272 1871401440 18.596 100 68 136 1 1901199616 9633536 20164640
20:09:04 7154 8192000000 10794013952 11209637888 1870743072 18.590 100 35 70 1 1887710512 6861792 10105648
20:09:18 6500 8192000000 10801747728 11215159296 1873053648 18.609 100 40 78 1 1892725072 8219568 11451856
20:09:35 5169 8192000000 10789398288 11211665408 1873241616 18.610 100 35 70 0 1892130704 8857040 10032048
20:09:52 5302 8192000000 10789182624 11210194944 1873269216 18.611 100 34 68 1 1888997808 6051216 9677376
20:10:08 5725 8192000000 10784632112 11212984320 1872817056 18.607 100 21 42 0 1885692400 6871184 6004160
20:10:20 5843 8192000000 10795471088 11219685376 1879973296 18.665 100 28 55 0 1893448816 6016720 7458800
20:10:32 7582 8192000000 10796633184 11221848064 1881659408 18.679 100 28 56 0 1897030576 7858704 7512464
20:10:48 9093 8192000000 10792489072 11224801280 1885659616 18.711 100 27 53 0 1899868224 6863280 7345328
20:11:09 4047 8192000000 10799211504 11229458432 1889429872 18.741 100 23 46 0 1901504576 5874656 6200048
20:11:21 7323 8192000000 10805857856 11236286464 1892648704 18.767 100 23 46 0 1906345728 7380080 6316944
20:11:36 12563 8192000000 10803366160 11241046016 1896466816 18.798 100 22 44 0 1909543136 7267776 5808544
20:11:56 18047 8192000000 10802208704 11238617088 1898875536 18.817 100 29 58 2 1914419872 6168160 9376176
20:12:20 61157 8192000000 10823761904 11252064256 1900626544 18.831 100 31 61 1 1915619168 6489936 8502688
20:13:28 12243 8192000000 10804706144 11247616000 1899405296 18.822 100 24 46 0 1911427760 5760784 6261680
20:13:49 4986 8192000000 10823056464 11249102848 1900205184 18.828 100 25 50 2 1913046752 5785664 7055904
20:14:00 4154 8192000000 10823422672 11253428224 1900650752 18.832 100 25 50 0 1915147232 7507664 6988816
20:14:11 5266 8192000000 10815173680 11251736576 1901793056 18.841 100 22 43 1 1915298624 6422592 7082976
20:14:23 9706 8192000000 10817842048 11257081856 1905782848 18.873 100 24 48 3 1918827616 6278960 6765808
20:14:39 7838 8192000000 10820942160 11260731392 1909394736 18.902 100 22 44 1 1921478608 6161920 5921952
20:14:53 5553 8192000000 10826200304 11261796352 1911814064 18.921 100 27 54 1 1925092464 5804304 7474096
20:15:07 7585 8192000000 10818162096 11257135104 1907238256 18.884 100 24 48 2 1919931632 5514608 7178768
20:15:20 9911 8192000000 10822794656 11262222336 1906623648 18.880 100 14 28 0 1916294880 5712048 3959184
20:15:36 7401 8192000000 10810542528 11254591488 1906236112 18.876 100 23 46 3 1918315488 5212800 6866576
20:15:52 9538 8192000000 10818661296 11261747200 1911321904 18.917 100 20 40 1 1923162064 6289296 5550864
20:16:08 10613 8192000000 10819035936 11261558784 1909199088 18.900 100 13 26 1 1918691456 5587312 3905056
20:16:25 14414 8192000000 10798451760 11240677376 1880634208 18.670 99 14 28 1 1890444880 5415344 4395328
20:16:51 28662 8192000000 10784574704 11228733440 1851383968 18.433 98 19 38 1 1862682368 5736848 5561552
20:17:56 25550 8192000000 10781705200 11225255936 1835362816 18.303 97 25 50 1 1847764048 5553024 6848208
20:18:30 11391 8192000000 10764343824 11194744832 1769263760 17.761 94 12 24 1 1777322896 4976896 3082240
20:18:47 8108 8192000000 10719751872 11138338816 1726158528 17.404 94 35 70 1 1744208688 7752448 10297712
20:19:06 5963 8192000000 10670470864 11079012352 1720301920 17.355 95 24 48 1 1732641504 5149856 7189728
20:19:19 6421 8192000000 10675317904 11097309184 1733426592 17.464 97 24 46 1 1749477824 9720176 6331056
20:19:33 8900 8192000000 10694652416 11112484864 1756948080 17.659 98 29 56 2 1776008096 11094736 7965280
20:19:48 4471 8192000000 10670802512 11084656640 1741427168 17.530 98 27 54 2 1756017504 6887920 7702416
20:19:59 8191 8192000000 10681718976 11089498112 1693450176 17.130 95 22 44 2 1705501744 5412144 6639424
20:20:14 7155 8192000000 10683952144 11096694784 1731288992 17.446 97 24 46 3 1743045488 5535760 6220736
20:20:29 3477 8192000000 10686901776 11095040000 1729168400 17.429 97 21 43 1 1741150192 6077712 5904080
20:20:39 7207 8192000000 10699215392 11109580800 1762046144 17.701 99 25 51 3 1774930064 5792384 7091536
20:20:53 13420 8192000000 10693414496 11103313920 1718997584 17.344 96 29 57 3 1732686192 5727744 7960864
20:21:12 7934 8192000000 10709919056 11125321728 1773249536 17.794 99 24 48 1 1790252064 10153600 6848928
20:21:26 8375 8192000000 10713514720 11131473920 1792111168 17.949 100 18 36 0 1802809312 5830688 4867456
20:21:41 20115 8192000000 10717059376 11133841408 1787713008 17.913 99 25 49 2 1800339760 5985024 6641728
20:22:34 23297 8192000000 10717314384 11137863680 1776381344 17.820 98 35 70 1 1792596144 6389616 9825184
20:23:07 11187 8192000000 10720779184 11145920512 1808202576 18.081 100 14 27 1 1816902096 5330160 3369360
20:23:28 6342 8192000000 10747909072 11163820032 1826160448 18.228 100 19 38 0 1836791440 5605632 5025360
20:23:41 4183 8192000000 10750545904 11174055936 1832297216 18.278 100 41 82 0 1859359856 15904896 11157744
20:23:51 5909 8192000000 10760033984 11177738240 1831183200 18.269 100 29 59 0 1845922432 6488912 8250320
20:24:05 6432 8192000000 10770521856 11190800384 1844652704 18.379 100 41 82 0 1868917888 12463808 11801376
20:24:19 10671 8192000000 10758776192 11186737152 1846100624 18.390 100 25 50 0 1859310896 5862240 7348032
20:24:36 7823 8192000000 10774696992 11194806272 1852463200 18.442 100 29 58 2 1867110128 6151952 8494976
20:24:50 4385 8192000000 10775001312 11198631936 1854575408 18.459 100 22 42 0 1866791424 5701008 6515008
20:25:05 9729 8192000000 10783792224 11204616192 1860397248 18.507 100 38 76 1 1878150880 5584272 12169360
20:25:23 9254 8192000000 10781141440 11206754304 1865571888 18.548 100 30 60 2 1880913520 5363472 9978160
20:25:42 5174 8192000000 10798630816 11217809408 1872009440 18.601 100 37 74 3 1893995248 11345616 10640192
20:25:54 11539 8192000000 10793855232 11213438976 1854912304 18.462 99 24 47 2 1867958960 5291056 7755600
20:26:15 14949 8192000000 10786744336 11214737408 1873139872 18.610 100 13 26 0 1881960992 5131552 3689568
20:26:36 117626 8192000000 10834471904 11251789824 1889049392 18.738 100 28 56 1 1902040112 5392144 7598576
20:28:41 6196 8192000000 10857309872 11269988352 1915073728 18.947 100 57 114 0 1945298144 13804144 16420272
20:28:57 20081 8192000000 10857573296 11278811136 1923930272 19.018 100 61 120 1 1951688384 10914928 16843184
20:29:36 12290 8192000000 10856540016 11284791296 1930023552 19.067 100 55 107 2 1955547872 10812400 14711920
20:29:56 31035 8192000000 10860130256 11293802496 1934642704 19.104 100 38 76 2 1956725424 11111072 10971648
20:30:35 20133 8192000000 10879290688 11304296448 1942221312 19.164 100 38 76 2 1962794384 10001744 10571328
20:31:12 11134 8192000000 10905159088 11325853696 1956753984 19.280 100 59 118 1 1991295504 17321664 17219856
20:32:09 8465 8192000000 10906615760 11332538368 1970292672 19.388 100 66 132 2 2003259632 13464496 19502464
20:32:29 11352 8192000000 10910858720 11342135296 1974473216 19.421 100 58 116 0 2006435984 14245280 17717488
20:32:50 9210 8192000000 10918142640 11348471808 1977342816 19.444 100 51 102 6 2012567456 20588000 14636640
20:33:08 24881 8192000000 10924840336 11359662080 1980259632 19.467 100 47 94 2 2013614464 19616352 13738480
20:33:42 10285 8192000000 10935325568 11365314560 1990197104 19.545 100 63 126 2 2031267664 22351152 18719408
20:34:13 11100 8192000000 10942779920 11373027328 1992413488 19.563 100 59 118 0 2034022928 24287584 17321856
20:34:31 7909 8192000000 10942800896 11376803840 1999128928 19.616 100 54 108 0 2039357776 24348032 15880816
20:34:48 9244 8192000000 10950557120 11374637056 1980106912 19.466 99 55 110 0 2019627648 23449376 16071360
20:35:05 11775 8192000000 10950825056 11381571584 1997839856 19.606 100 54 107 1 2040673408 27005840 15827712
20:35:31 8870 8192000000 10955912880 11386884096 2000594176 19.627 100 48 94 0 2043161568 28300560 14266832
20:35:49 5677 8192000000 10954772896 11388780544 2004456816 19.658 100 49 98 1 2048346800 28550224 15339760
20:36:04 22538 8192000000 10950958784 11395870720 2009664320 19.699 100 52 104 1 2055168496 29175616 16328560
20:36:34 4203 8192000000 10958114800 11393556480 1990910992 19.551 99 47 93 2 2036447024 30919584 14616448
20:36:48 8907 8192000000 10958249552 11391553536 1999404272 19.618 100 53 106 0 2049406960 33515536 16487152
20:37:07 2219 8192000000 10976339632 11402698752 2010155392 19.703 100 69 137 3 2064915968 33480144 21280432
20:37:18 3649 8192000000 10985912944 11409829888 2012277840 19.719 100 73 144 1 2068971296 34472928 22220528
20:37:32 6948 8192000000 10981494832 11412471808 2021036352 19.788 100 66 130 0 2071491408 31579040 18876016
20:37:51 6507 8192000000 10973941792 11404886016 2000683472 19.628 99 60 119 0 2050046400 31937536 17425392
20:38:06 7594 8192000000 10981386896 11409219584 2017847744 19.763 100 68 133 1 2071701888 33316000 20538144
20:38:23 5013 8192000000 10967622960 11398746112 1996562160 19.596 99 60 122 0 2048178864 33913440 17703264
20:38:39 3872 8192000000 10991325984 11417657344 2016816768 19.755 100 69 137 3 2070110064 33248464 20044832
20:38:50 2789 8192000000 10999092704 11423698944 2029949552 19.858 100 86 173 3 2088759440 33656992 25152896
20:39:02 8213 8192000000 10990948944 11422777344 2024355952 19.814 100 58 115 2 2075546144 33972352 17217840
20:39:19 3889 8192000000 10986779936 11412807680 1992777584 19.566 98 67 134 3 2047721152 33823040 21120528
20:39:30 3692 8192000000 10984575264 11411820544 2012660672 19.722 100 61 122 3 2066545424 34422368 19462384
20:39:40 3717 8192000000 11001402496 11426410496 2023957984 19.811 100 82 166 2 2084362864 35306240 25098640
20:39:52 4689 8192000000 10994363328 11427880960 2022679744 19.801 100 57 113 0 2075951776 36226000 17046032
20:40:05 4855 8192000000 10996175696 11432620032 2030173440 19.860 100 60 119 0 2082649296 34532880 17942976
20:40:19 3734 8192000000 11000468128 11430760448 2015954112 19.748 99 63 124 0 2069912944 35186160 18772672
20:40:32 4698 8192000000 10997014688 11419750400 2012860208 19.724 99 75 150 1 2073511568 37599792 23051568
20:40:46 2131 8192000000 11018520208 11435069440 2027564016 19.840 100 89 176 1 2097104960 42763632 26777312
20:40:55 4146 8192000000 11017162144 11432521728 2028671984 19.848 100 92 182 1 2094753184 39188368 26892832
20:41:07 3758 8192000000 11016596688 11437432832 2030591392 19.863 100 85 169 2 2095673056 39465120 25616544
20:41:19 3634 8192000000 11012819456 11436060672 2032512048 19.878 100 79 158 0 2097071696 40654224 23905424
20:41:29 7755 8192000000 11008095792 11434680320 2027888320 19.842 100 81 162 2 2092636144 40539776 24208048
20:41:44 2180 8192000000 11011645344 11430694912 2030909344 19.866 100 79 155 2 2092732864 39057024 22766496
20:41:55 2539 8192000000 11010396032 11425169408 2022058544 19.796 100 89 175 1 2089245168 40624896 26561728
20:42:04 4392 8192000000 10998049248 11417210880 2000685872 19.628 99 86 168 0 2068758336 42296112 25776352
20:42:17 3062 8192000000 10976196576 11390988288 1985631824 19.509 99 83 160 3 2053282528 43155728 24494976
20:42:28 5328 8192000000 10981605424 11404947456 1998968544 19.615 100 81 162 2 2067913712 44397712 24547456
20:42:46 7017 8192000000 10982540448 11408658432 2003797280 19.653 100 68 133 0 2070076400 44857008 21422112
20:43:01 1805 8192000000 11003000240 11425464320 2011654032 19.715 100 79 158 3 2083637904 47025312 24958560
20:43:10 1435 8192000000 11001449952 11419836416 2008158272 19.687 100 82 165 1 2081885872 47791184 25936416
20:43:20 2422 8192000000 10993806240 11405983744 1998571232 19.611 100 82 160 1 2070065856 46728480 24766144
20:43:28 1150 8192000000 10985223344 11407106048 1998119008 19.608 100 80 159 2 2069661664 46996800 24545856
20:43:39 1539 8192000000 11006603088 11418701824 2007353744 19.681 100 87 173 1 2080337552 46695200 26288608
20:43:49 2532 8192000000 10976880544 11391807488 1983303424 19.491 100 86 172 1 2058706240 49150512 26252304
20:43:58 1639 8192000000 10989833936 11399106560 1992952144 19.567 100 85 168 0 2064534368 45528528 26053696
20:44:08 1407 8192000000 11000145472 11410644992 2004089392 19.655 100 94 188 1 2079990224 46592192 29308640
20:44:17 1236 8192000000 10981190720 11403059200 1991761824 19.558 100 75 151 0 2062892912 47314896 23816192
20:44:26 1340 8192000000 10994345952 11413979136 1998202800 19.609 100 69 139 0 2068590864 47978512 22409552
20:44:34 4675 8192000000 10977193552 11404382208 1992328128 19.562 100 58 112 2 2059781280 49449824 18003328
20:44:50 4215 8192000000 10967808288 11392299008 1973940048 19.417 99 58 116 1 2040502704 48356960 18205696
20:45:00 4148 8192000000 10967653248 11388588032 1971481216 19.397 99 67 129 1 2039015936 46472256 21062464
20:45:14 6184 8192000000 10963872400 11378876416 1967307120 19.364 100 69 137 0 2038110720 49326448 21477152
20:45:28 2183 8192000000 10974477392 11390963712 1979932432 19.464 100 81 163 1 2055322432 49714496 25675504
20:45:37 1936 8192000000 10980696432 11402571776 1988340432 19.531 100 73 142 2 2061181376 50222272 22618672
20:45:46 1850 8192000000 10972483072 11388280832 1975604896 19.430 100 85 169 4 2055568544 54147872 25815776
20:45:55 2008 8192000000 10958421120 11369426944 1956736832 19.280 100 89 179 1 2039348784 54943312 27668640
20:46:04 4215 8192000000 10975671104 11387940864 1971929584 19.401 100 78 156 0 2055299152 58422144 24947424
20:46:16 1542 8192000000 10985162992 11396739072 1979137568 19.458 100 86 173 3 2065777568 59178608 27461392
20:46:24 4329 8192000000 10969538672 11383324672 1963157088 19.331 100 70 140 1 2046413904 60584384 22672432
20:46:42 12432 8192000000 10962956128 11392020480 1968608640 19.374 100 50 100 1 2042896432 57372240 16915552
20:47:03 5616 8192000000 10976090656 11391823872 1955409424 19.270 99 65 128 2 2038076000 61030544 21636032
20:47:16 2430 8192000000 10992231488 11400761344 1977528224 19.445 100 91 180 2 2070813744 64133888 29151632
20:47:27 4447 8192000000 10984917312 11398639616 1972147328 19.402 100 75 150 2 2062735312 66548544 24039440
20:47:40 1431 8192000000 10996963248 11405574144 1975406064 19.428 100 94 186 0 2072951712 67857184 29688464
20:47:48 1280 8192000000 10989923264 11397230592 1965444752 19.349 100 87 173 2 2066210928 72544816 28221360
20:47:58 5232 8192000000 10980173984 11391361024 1956270352 19.276 100 70 140 1 2054038384 74625248 23142784
20:48:15 6458 8192000000 10958703424 11389472768 1939339600 19.141 99 56 112 2 2031286880 72950416 18996864
20:48:34 17049 8192000000 10936123152 11373264896 1913091520 18.931 98 46 90 2 1993381504 64742864 15547120
20:48:59 7298 8192000000 10954648128 11383975936 1952700656 19.248 100 47 94 1 2033981168 64799472 16481040
20:49:17 9788 8192000000 10965834592 11392172032 1961739312 19.320 100 62 124 1 2048555040 66146160 20669568
20:49:42 7892 8192000000 10965857936 11387494400 1955747584 19.272 100 53 105 2 2045237408 70954928 18534896
20:49:59 2281 8192000000 10981245744 11400896512 1966915680 19.361 100 77 154 1 2067111152 73472992 26722480
20:50:09 7047 8192000000 10976561520 11404128256 1962482288 19.326 100 51 99 3 2055478496 75566624 17429584
20:50:23 15319 8192000000 10959902320 11401887744 1956166144 19.276 100 48 96 1 2050176368 77048544 16961680
20:50:45 14750 8192000000 10948392544 11396726784 1958066752 19.291 100 44 88 0 2040973984 67184528 15722704
20:51:12 16400 8192000000 10918598032 11365314560 1932209536 19.085 99 38 76 0 1992718480 47508896 13000048
20:51:35 26220 8192000000 10931316768 11375120384 1949834368 19.225 100 42 84 2 2014510240 50192032 14483840
20:52:14 29360 8192000000 10929670112 11369594880 1922213328 19.005 98 42 84 1 1989426176 53272800 13940048
20:52:49 34859 8192000000 10923645408 11369279488 1930833936 19.074 100 34 67 0 2001715760 58594160 12287664
20:53:51 29560 8192000000 10913497904 11372331008 1910301488 18.909 99 28 56 1 1989194576 68774320 10118768
20:54:54 20853 8192000000 10895152480 11349815296 1898878096 18.817 99 16 32 1 1967024000 62178608 5967296
20:55:46 24046 8192000000 10860918896 11333615616 1882314224 18.684 99 15 29 1 1949776224 61982288 5479712
20:56:17 40837 8192000000 10842361456 11314040832 1876857904 18.640 98 23 46 2 1918449728 34234560 7357264
20:57:08 52969 8192000000 10857461520 11316502528 1920577888 18.991 100 19 38 0 1938878144 13264752 5035504
20:58:07 47641 8192000000 10872522944 11302850560 1872058352 18.601 97 15 30 0 1886519408 9676240 4784816
20:59:04 29168 8192000000 10861372400 11305316352 1860948544 18.511 96 20 40 1 1874712128 8263872 5499712
20:59:48 45114 8192000000 10881382432 11346677760 1937820832 19.129 100 9 18 3 1956981312 16580320 2580160
21:00:40 94711 8192000000 10871125680 11341135872 1870184096 18.586 96 5 10 0 1891715552 20364464 1166992
21:04:19 47499 8192000000 10888195200 11348062208 1955242384 19.268 100 23 46 0 1968941824 7104784 6594656
21:05:14 45791 8192000000 10888069616 11349311488 1941180352 19.156 99 17 34 1 1953323344 7507552 4635440
21:06:16 74472 8192000000 10888671360 11358736384 1963472640 19.334 100 11 23 1 1976857552 10168976 3215936
21:07:42 48707 8192000000 10902424864 11359940608 1964858464 19.345 100 15 32 0 1980238432 10105408 5274560
21:08:43 45344 8192000000 10923141104 11366690816 1975383616 19.428 100 41 82 1 1996688592 9002832 12302144
21:09:40 51917 8192000000 10933214464 11375718400 1975788816 19.431 100 30 59 0 2000543792 16322480 8432496
21:10:41 60120 8192000000 10935462912 11378208768 1979270720 19.459 100 32 64 0 2000360544 12128960 8960864
21:11:53 64745 8192000000 10907962832 11375480832 1964988928 19.346 99 21 43 0 1987245440 15886672 6369840
21:13:05 77750 8192000000 10905944896 11381542912 1982220064 19.482 100 12 24 1 1997714384 12072928 3421392
21:14:29 70744 8192000000 10891962288 11365941248 1943055776 19.171 98 7 14 0 1953573168 8673904 1843488
21:15:46 66440 8192000000 10904160032 11370926080 1962967328 19.330 99 17 34 1 1975057712 7158528 4931856
21:17:59 58901 8192000000 10914392352 11376414720 1990032720 19.544 100 35 68 2 2010099696 8612416 11454560
21:19:18 68143 8192000000 10913933312 11383742464 1975221968 19.427 99 32 64 0 1993503008 8934960 9346080
21:20:54 41682 8192000000 10912302800 11374886912 1968968944 19.377 99 23 46 1 1983374848 7439968 6965936
21:21:48 2260 8192000000 10915149664 11371999232 1979746400 19.463 100 33 66 0 1997835072 8396416 9692256
21:21:57 27796 8192000000 10910991040 11382079488 1987611856 19.525 100 28 56 2 2008798432 12909056 8277520
21:22:42 46389 8192000000 10883869072 11355029504 1932425072 19.086 98 18 36 0 1950023872 12220640 5378160
21:23:39 50350 8192000000 10899598096 11370319872 1951883504 19.241 99 12 24 0 1969304432 13598080 3822848
21:24:50 42723 8192000000 10882722688 11350802432 1909903152 18.906 97 9 18 0 1923141136 11300384 1937600
21:26:11 42062 8192000000 10859630480 11338162176 1932702096 19.088 99 11 21 1 1942420576 6953536 2764944
21:27:08 37258 8192000000 10857990800 11327336448 1941904256 19.162 99 17 34 2 1952044624 5725392 4414976
21:27:51 44684 8192000000 10866346192 11335671808 1944547168 19.183 99 8 16 0 1952202016 5481888 2172960
21:28:42 94187 8192000000 10877010976 11353677824 1941397984 19.158 99 16 31 1 1956379808 10575568 4406256
21:30:23 39136 8192000000 10870668336 11349340160 1921568592 18.999 98 6 11 1 1929735344 6423504 1743248
21:31:08 49561 8192000000 10893728624 11372892160 1953766864 19.256 99 10 20 3 1969346848 12984800 2595184
21:32:24 65193 8192000000 10874261648 11347636224 1860649312 18.509 94 8 16 0 1869952720 7573648 1729760
21:33:36 55257 8192000000 10869103664 11343134720 1907479504 18.886 97 12 23 0 1918861952 7666928 3715520
21:34:37 29318 8192000000 10884113744 11350016000 1960211248 19.308 100 20 40 1 1973250816 7761696 5277872
21:35:22 58009 8192000000 10876575280 11337863168 1903655808 18.856 97 21 42 0 1919246704 9418064 6172832
21:36:44 50052 8192000000 10860717232 11306553344 1824812960 18.217 94 25 50 2 1841401424 9369392 7219072
21:37:54 47993 8192000000 10860800960 11330322432 1910037376 18.907 99 31 62 2 1934837344 15992096 8807872
21:38:56 67873 8192000000 10852936432 11313856512 1841479056 18.353 95 15 30 0 1858840016 13121312 4239648
21:40:14 61098 8192000000 10860105312 11326648320 1861261904 18.514 96 26 52 0 1890508720 20871392 8375424
21:42:16 81107 8192000000 10835649632 11290210304 1779503216 17.845 93 18 36 1 1794492720 10279216 4710288
21:43:44 25821 8192000000 10865227104 11306893312 1883921584 18.697 98 31 61 2 1900570624 8016512 8632528
21:44:26 45713 8192000000 10838368384 11299778560 1862214640 18.521 97 38 76 1 1887448672 14926096 10307936
21:45:19 23077 8192000000 10863955680 11308122112 1919457136 18.982 100 52 104 1 1945192832 11272688 14463008
21:45:49 104138 8192000000 10845215840 11305009152 1902202432 18.844 99 31 62 2 1925895088 14839216 8853440
21:48:14 34640 8192000000 10858122288 11310583808 1916384448 18.958 100 33 66 2 1936469600 11101456 8983696
21:49:02 46533 8192000000 10859058656 11311017984 1920098832 18.988 100 38 76 0 1944538688 13998080 10441776
21:49:56 47002 8192000000 10837881696 11294998528 1907599184 18.887 99 22 44 0 1921265072 7458896 6206992
21:51:05 60422 8192000000 10835950896 11306942464 1894100432 18.779 98 14 28 3 1907384672 8965152 4319088
21:52:21 78846 8192000000 10850769536 11318915072 1897150496 18.803 98 18 35 0 1910002416 8250112 4601808
21:53:55 55482 8192000000 10857881040 11329216512 1918940832 18.978 99 16 31 3 1937209536 13145392 5123312
21:54:56 57901 8192000000 10845667920 11327533056 1930596560 19.072 100 16 32 0 1950212128 14443088 5172480
21:56:00 56648 8192000000 10854649728 11333410816 1939592016 19.144 100 15 30 3 1951154512 7403088 4159408
21:57:04 36881 8192000000 10885119664 11349839872 1928061344 19.051 99 12 24 0 1941395760 10463760 2870656
21:57:56 60684 8192000000 10911979104 11374206976 1966427952 19.357 100 12 24 1 1986103392 16411888 3263552
21:59:17 51245 8192000000 10903279088 11376488448 1973284528 19.411 100 15 30 1 1987860448 10156480 4419440
22:00:24 105590 8192000000 10921129408 11400400896 1958543728 19.294 99 11 22 0 1973151568 11817216 2790624
22:02:20 105390 8192000000 10913056256 11379822592 1943488928 19.175 98 12 24 0 1968579312 21759344 3331040
22:04:15 71664 8192000000 10920119808 11378950144 1946260432 19.197 98 38 76 0 1967641056 10258080 11122544
22:05:36 68323 8192000000 10928843632 11385253888 1911984224 18.923 96 31 62 1 1933071888 12616464 8471200
22:06:50 69559 8192000000 10905959344 11374669824 1937706784 19.128 98 25 50 0 1961544144 16720944 7116416
22:08:06 68366 8192000000 10905681600 11349692416 1878107136 18.650 95 20 40 0 1890390128 6797136 5485856
22:09:24 37058 8192000000 10902394864 11354501120 1937148736 19.124 98 46 90 0 1966025440 15704528 13172176
22:10:14 74624 8192000000 10896789952 11364421632 1930098848 19.068 98 21 42 2 1953381744 17747312 5535584
22:11:41 147186 8192000000 10890613360 11362103296 1897356048 18.805 96 23 46 1 1913919440 9821120 6742272
22:14:14 63200 8192000000 10889555328 11375591424 1961781168 19.320 100 10 20 0 1982352032 17577904 2992960
22:15:27 23164 8192000000 10887024176 11364536320 1965962512 19.353 100 17 34 0 1986096384 15362064 4771808
22:15:57 70431 8192000000 10888920384 11371630592 1936789824 19.121 98 10 20 1 1946279536 6289504 3200208
22:17:14 54393 8192000000 10857705856 11335266304 1905252928 18.869 97 13 26 0 1916024160 7137744 3633488
22:18:14 56785 8192000000 10859620560 11331039232 1901026432 18.835 97 18 36 1 1915212960 9294240 4892288
22:19:29 62579 8192000000 10868411872 11353649152 1943836336 19.177 100 10 20 1 1956947024 10043024 3067664
22:20:42 77123 8192000000 10855625120 11345575936 1882864080 18.688 96 14 28 0 1896028144 9099216 4064848
22:22:05 46784 8192000000 10869377120 11346808832 1910319808 18.909 98 13 26 0 1921130480 7893520 2917152
22:23:00 23313 8192000000 10869285264 11337887744 1921920736 19.002 98 21 42 1 1935358272 7773136 5664400
22:23:35 41866 8192000000 10873032880 11332771840 1823922384 18.210 93 30 59 2 1847862480 15123136 8816960
22:24:23 42144 8192000000 10882911344 11348721664 1936067296 19.115 100 17 34 1 1952460640 11105120 5288224
22:25:54 83909 8192000000 9488367072 9829957632 533034256 6.109 28 6 12 0 542289056 7710976 1543824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 119 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:02, from 24-11-2020 22:29:01 to 24-11-2020 22:29:03.

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          240825
MON$OLDEST_ACTIVE               240826
MON$OLDEST_SNAPSHOT             240826
MON$NEXT_TRANSACTION            240826
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                       2053088
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:200: 
:201: mscs-test-161.budzdorov.ru    Tue Nov 24 22:27:22 2020
:202:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:203: 
--- end of diff output ---

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

24.11.20 22:29:04. 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-24 22:29:06 No severe PSQL-related problems occured
24.11.20 22:29:07. End of report.