Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.03.2021 16:28
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17452684 kB
MemAvailable 31523808 kB
Buffers 0 kB
Cached 14232604 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-24 16:27:23
DTS_END                         2021-03-24 16:27:23.5320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60734
TRN_ID                          228997
ATT_ID                          685
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: 9035.06 23523 1084207
customer order: creation 161.29 411 19355
customer order: refuse 13.71 374 1645
order to supplier: creation 42.66 1302 5119
order to supplier: removal 3.22 123266 386
invoice (draft): creation 42.73 3801 5127
invoice (draft): removal 52.65 875 6318
invoice accept: apply 38.87 19786 4664
invoice accept: cancel 47.75 912 5730
customer reserve: creation 3626.19 195 435143
customer reserve: removal 4726.40 66 567168
realization accept: apply 77.99 178 9359
realization accept: cancel 80.91 122 9709
payment from customer: creation 55.16 111 6619
payment from customer: removal 5.13 79 615
payment to supplier: creation 45.64 104 5477
payment to supplier: removal 3.43 83 411
service: total inventory turnovers 4.43 1132 532
service: total monetary turnovers 6.08 30 729
service: aggregate perf. data 0.81 22473 97
service: refresh index statistics 0.03 295160 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2021 16:28:53 to 24-03-2021 16:28:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3612
TEST_TIME 2 3929
TEST_TIME 3 4438
TEST_TIME 4 5758
TEST_TIME 5 5691
TEST_TIME 6 5639
TEST_TIME 7 5287
TEST_TIME 8 5354
TEST_TIME 9 5420
TEST_TIME 10 5281
TEST_TIME 11 5434
TEST_TIME 12 5830
TEST_TIME 13 5919
TEST_TIME 14 6191
TEST_TIME 15 6884
TEST_TIME 16 7048
TEST_TIME 17 7531
TEST_TIME 18 8059
TEST_TIME 19 8315
TEST_TIME 20 8224
TEST_TIME 21 8315
TEST_TIME 22 8151
TEST_TIME 23 8661
TEST_TIME 24 8689
TEST_TIME 25 9190
TEST_TIME 26 9146
TEST_TIME 27 9497
TEST_TIME 28 11612
TEST_TIME 29 11275
TEST_TIME 30 11142
TEST_TIME 31 11292
TEST_TIME 32 11079
TEST_TIME 33 10897
TEST_TIME 34 10716
TEST_TIME 35 10513
TEST_TIME 36 10367
TEST_TIME 37 10264
TEST_TIME 38 10312
TEST_TIME 39 10180
TEST_TIME 40 9983
TEST_TIME 41 9842
TEST_TIME 42 9822
TEST_TIME 43 9743
TEST_TIME 44 9675
TEST_TIME 45 9569
TEST_TIME 46 9553
TEST_TIME 47 9422
TEST_TIME 48 9256
TEST_TIME 49 9233
TEST_TIME 50 9200
TEST_TIME 51 9436
TEST_TIME 52 9431
TEST_TIME 53 9387
TEST_TIME 54 9351
TEST_TIME 55 9329
TEST_TIME 56 9322
TEST_TIME 57 9335
TEST_TIME 58 9353
TEST_TIME 59 9487
TEST_TIME 60 9425
TEST_TIME 61 9406
TEST_TIME 62 9436
TEST_TIME 63 9391
TEST_TIME 64 9485
TEST_TIME 65 9381
TEST_TIME 66 9270
TEST_TIME 67 9239
TEST_TIME 68 9243
TEST_TIME 69 9176
TEST_TIME 70 9135
TEST_TIME 71 9237
TEST_TIME 72 9192
TEST_TIME 73 9190
TEST_TIME 74 9145
TEST_TIME 75 9120
TEST_TIME 76 9172
TEST_TIME 77 9127
TEST_TIME 78 9185
TEST_TIME 79 9182
TEST_TIME 80 9287
TEST_TIME 81 9237
TEST_TIME 82 9278
TEST_TIME 83 9271
TEST_TIME 84 9273
TEST_TIME 85 9419
TEST_TIME 86 9442
TEST_TIME 87 9513
TEST_TIME 88 9411
TEST_TIME 89 9326
TEST_TIME 90 9318
TEST_TIME 91 9259
TEST_TIME 92 9242
TEST_TIME 93 9193
TEST_TIME 94 9188
TEST_TIME 95 9148
TEST_TIME 96 9163
TEST_TIME 97 9138
TEST_TIME 98 9249
TEST_TIME 99 9225
TEST_TIME 100 9199
TEST_TIME 101 9218
TEST_TIME 102 9214
TEST_TIME 103 9236
TEST_TIME 104 9216
TEST_TIME 105 9252
TEST_TIME 106 9245
TEST_TIME 107 9294
TEST_TIME 108 9261
TEST_TIME 109 9264
TEST_TIME 110 9300
TEST_TIME 111 9225
TEST_TIME 112 9182
TEST_TIME 113 9160
TEST_TIME 114 9121
TEST_TIME 115 9134
TEST_TIME 116 9088
TEST_TIME 117 9060
TEST_TIME 118 9086
TEST_TIME 119 9050
TEST_TIME 120 9037

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-03-2021 16:28:56 to 24-03-2021 16:29:00.

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 1487978 1487978 0 0.00 0 17351 7 0 0
doc_list_biud 1487978 1487978 0 0.00 0 45692 31 0 0
sp_add_invoice_to_stock 4798 4664 134 2.79 24 186917 19787 0 134
sp_cancel_adding_invoice 5730 5730 0 0.00 5 65076 912 0 0
sp_cancel_client_order 1645 1645 0 0.00 5 12332 374 0 0
sp_cancel_customer_reserve 567168 567168 0 0.00 1 45693 66 0 0
sp_cancel_pay_from_customer 615 615 0 0.00 3 2650 79 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 2 4563 83 0 0
sp_cancel_supplier_invoice 6328 6318 10 0.15 2 16232 876 0 10
sp_cancel_supplier_order 386 386 0 0.00 14 1153415 123266 0 0
sp_cancel_write_off 9709 9709 0 0.00 1 15407 122 0 0
sp_client_order 19355 19355 0 0.00 4 94082 412 0 0
sp_customer_reserve 435143 435143 0 0.00 0 39052 195 0 0
sp_fill_shopping_cart 29600 29600 0 0.00 1 16919 42 0 0
sp_fill_shopping_cart_clo_res 435141 435141 0 0.00 0 15691 14 0 0
sp_get_clo_for_invoice 4660 4660 0 0.00 0 27066 342 0 0
sp_kill_cost_storno 16465 16465 0 0.00 0 15398 63 0 0
sp_kill_qstorno_ret_qs2qd 1150749 1150749 0 0.00 0 45691 36 0 0
sp_kill_qty_storno 604973 604973 0 0.00 0 45692 76 0 0
sp_lock_selected_doc 19538 19538 0 0.00 0 8888 6 0 0
sp_make_cost_storno 26113 26113 0 0.00 0 13496 51 0 0
sp_multiply_rows_for_pdistr 26113 26113 0 0.00 0 9588 30 0 0
sp_multiply_rows_for_qdistr 19355 19355 0 0.00 0 94073 175 0 0
sp_pay_from_customer 6619 6619 0 0.00 4 10028 112 0 0
sp_pay_to_supplier 5477 5477 0 0.00 5 9702 105 0 0
sp_payment_common 12096 12096 0 0.00 1 10020 28 0 0
sp_qd_handle_on_cancel_clo 1645 1645 0 0.00 0 12324 331 0 0
sp_qd_handle_on_invoice_upd_sts 10388 10388 0 0.00 0 28633 365 0 0
sp_qd_handle_on_reserve_upd_sts 9359 9359 0 0.00 0 9923 62 0 0
sp_reserve_write_off 9359 9359 0 0.00 7 11443 179 0 0
sp_supplier_invoice 5127 5127 0 0.00 7 78279 3802 0 0
sp_supplier_order 5119 5119 0 0.00 5 31826 1303 0 0
srv_aggregate_perf_data 97 97 0 0.00 2893 551922 22474 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1599 128225 31540 0 0
srv_find_qd_qs_mism 1039916 1039916 0 0.00 0 17347 6 0 0
srv_make_invnt_saldo 532 532 0 0.00 16 37307 1132 0 0
srv_make_money_saldo 729 729 0 0.00 1 1853 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 107096 465434 295160 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 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 4665 4665 0 0.00 0 13842 198 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 2078 85 0 0
t$perf-norm:sp_cancel_client_order 1645 1645 0 0.00 0 10121 19 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 1261 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 615 615 0 0.00 0 649 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 1252 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 10097 66 0 0
t$perf-norm:sp_cancel_supplier_order 386 386 0 0.00 0 35421 1843 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 10069 43 0 0
t$perf-norm:sp_client_order 19355 19355 0 0.00 0 10703 19 0 0
t$perf-norm:sp_customer_reserve 957 957 0 0.00 0 7796 16 0 0
t$perf-norm:sp_pay_from_customer 6619 6619 0 0.00 0 10021 12 0 0
t$perf-norm:sp_pay_to_supplier 5477 5477 0 0.00 0 9280 13 0 0
t$perf-norm:sp_reserve_write_off 9359 9359 0 0.00 0 9642 13 0 0
t$perf-norm:sp_supplier_invoice 5127 5127 0 0.00 0 11321 22 0 0
t$perf-norm:sp_supplier_order 5119 5119 0 0.00 0 9411 19 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 242 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 584 11 0 0
t$perf-norm:srv_make_invnt_saldo 532 532 0 0.00 0 786 20 0 0
t$perf-norm:srv_make_money_saldo 729 729 0 0.00 0 3177 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 9584 9316 268 2.79 0 11300 24 0 268
v_all_customers 35612 35612 0 0.00 0 20 1 0 0
v_all_suppliers 28554 28554 0 0.00 0 121 1 0 0
v_all_wares 38710 38710 0 0.00 0 139 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 9771 25 0 0
v_cancel_client_order 3290 3290 0 0.00 0 1180 4 0 0
v_cancel_customer_prepayment 1230 1230 0 0.00 0 2643 8 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 3650 6 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 520 4 0 0
v_cancel_supplier_invoice 818 798 20 2.44 0 2044 18 0 20
v_cancel_supplier_order 772 772 0 0.00 0 2106 7 0 0
v_cancel_write_off 1938 1938 0 0.00 0 2746 14 0 0
v_max_id_clo_ord 5119 5119 0 0.00 0 554 1 0 0
v_max_id_clo_res 957 957 0 0.00 0 8757 28 0 0
v_max_id_ord_sup 5126 5126 0 0.00 0 5631 6 0 0
v_max_non_paid_invoice 1445 1445 0 0.00 0 3067 4 0 0
v_max_non_paid_realizn 3363 3363 0 0.00 0 8615 5 0 0
v_min_id_clo_ord 5119 5119 0 0.00 0 4361 7 0 0
v_min_id_clo_res 957 957 0 0.00 0 2965 6 0 0
v_min_id_ord_sup 5126 5126 0 0.00 0 7745 10 0 0
v_min_non_paid_invoice 5477 5477 0 0.00 0 7919 10 0 0
v_min_non_paid_realizn 6619 6619 0 0.00 0 8712 20 0 0
v_our_firm 9610 9610 0 0.00 0 20 1 0 0
v_reserve_write_off 18718 18718 0 0.00 0 3514 6 0 0
x_lock_depdocs_on_canc_invoice 11649 11649 0 0.00 0 20344 132 0 0
x_lock_depdocs_on_canc_sup_ord 386 386 0 0.00 0 5964 392 0 0
x_make_qstorno_1000_1200 5119 5119 0 0.00 2 31793 1223 0 0
x_make_qstorno_1200_2000 5127 5127 0 0.00 3 77578 3645 0 0
x_make_qstorno_2100_3300 435143 435143 0 0.00 0 39050 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2021 16:29:01 to 24-03-2021 16:29:05.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:27 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:33 12217 8192000000 10202710272 10504085504 842467712 9.325 68 53 106 0 863043904 2453456 18122736
13:57:56 20756 8192000000 10320654256 10636533760 1369229600 14.320 100 82 164 0 1400338768 4606272 26502896
13:58:26 12447 8192000000 10367999536 10687078400 1421021072 14.782 100 89 178 1 1456527424 6193408 29312944
13:58:50 34055 8192000000 10396179744 10722369536 1448366512 15.023 100 88 176 0 1484654288 7012144 29275632
13:59:32 25256 8192000000 10418135552 10746970112 1476175424 15.268 100 92 184 0 1514520480 8507600 29837456
14:00:08 17058 8192000000 10431462064 10761289728 1482650736 15.325 100 92 184 0 1521472720 8971776 29850208
14:00:34 11143 8192000000 10433025712 10766241792 1491510048 15.402 100 88 176 0 1529767280 9798576 28458656
14:00:56 19542 8192000000 10455867392 10788491264 1503778400 15.509 100 88 176 0 1542317856 10278384 28261072
14:01:25 17902 8192000000 10466045056 10807103488 1520441920 15.654 100 89 178 0 1559272768 10758112 28072736
14:01:53 16002 8192000000 10488000304 10835779584 1547463408 15.888 100 84 168 1 1584347232 10707344 26176480
14:02:15 18275 8192000000 10509869104 10863591424 1576397824 16.137 100 79 158 0 1611058720 11048992 23611904
14:02:44 9804 8192000000 10533894672 10888531968 1596664768 16.311 100 80 160 0 1632032256 11479184 23888304
14:03:03 15283 8192000000 10559284752 10919186432 1614940400 16.467 100 75 150 2 1648582448 11473936 22168112
14:03:26 12475 8192000000 10578592448 10940145664 1635173552 16.639 100 73 146 2 1668448080 11800208 21474320
14:03:47 8279 8192000000 10590963744 10956713984 1655042544 16.807 100 78 156 4 1690424048 12096288 23285216
14:04:05 8623 8192000000 10617949920 10983350272 1675413312 16.979 100 81 161 1 1712269952 12884976 23971664
14:04:21 7679 8192000000 10631871840 11002880000 1690075120 17.102 100 78 156 0 1725782064 12700528 23006416
14:04:35 6615 8192000000 10640661936 11012890624 1707713568 17.250 100 83 166 1 1745737424 13855600 24168256
14:04:49 9551 8192000000 10656292576 11029331968 1717807360 17.334 100 74 148 1 1752380896 13564800 21008736
14:05:07 7086 8192000000 10667289904 11046744064 1731668928 17.449 100 78 156 0 1767459168 13864496 21925744
14:05:24 6299 8192000000 10686675152 11064946688 1748827008 17.592 100 83 166 1 1785867744 13413520 23627216
14:05:37 4096 8192000000 10702537680 11083669504 1766426544 17.738 100 82 164 0 1803122032 13789760 22905728
14:05:49 4395 8192000000 10717576384 11094896640 1777917936 17.832 100 83 163 3 1814642720 13741056 22983728
14:06:01 3943 8192000000 10723537184 11102060544 1779482048 17.845 100 85 168 0 1817454160 14125648 23846464
14:06:11 2917 8192000000 10728772768 11109199872 1791662000 17.945 100 89 178 1 1830228464 13974144 24592320
14:06:22 9248 8192000000 10728648896 11115040768 1793461376 17.960 100 77 155 0 1827641360 12488160 21691824
14:06:39 4675 8192000000 10754094064 11138285568 1804386352 18.050 100 85 167 1 1840655008 13130608 23138048
14:06:50 1937 8192000000 10757088016 11142545408 1817580560 18.158 100 88 176 1 1855642112 12985712 25075840
14:07:00 3721 8192000000 10775461696 11158904832 1828008912 18.243 100 87 174 1 1865990912 13780512 24201488
14:07:10 1842 8192000000 10774157520 11159932928 1835371760 18.303 100 92 182 2 1874210480 13935856 24902864
14:07:19 3158 8192000000 10782791760 11167666176 1839306880 18.335 100 93 186 1 1880376896 14494048 26575968
14:07:29 2797 8192000000 10786437264 11176927232 1848463456 18.410 100 86 171 0 1885631520 13672304 23495760
14:07:38 2197 8192000000 10799492208 11182829568 1850882480 18.429 100 94 187 3 1890010240 13103152 26024608
14:07:46 2163 8192000000 10799492224 11187646464 1854147776 18.456 100 88 177 0 1891590048 12836480 24605792
14:07:55 1209 8192000000 10804874864 11190415360 1859697472 18.501 100 91 182 1 1899586048 13735824 26152752
14:08:03 2774 8192000000 10807145104 11194847232 1858651072 18.492 100 87 173 1 1895374192 12145872 24577248
14:08:12 2406 8192000000 10811147424 11197939712 1860733296 18.509 100 91 182 2 1900087344 13150848 26203200
14:08:20 1387 8192000000 10808891584 11196305408 1866820224 18.559 100 94 189 1 1907738432 14686096 26232112
14:08:28 1347 8192000000 10814940256 11201413120 1866536288 18.556 100 96 190 2 1909041872 14920304 27585280
14:08:36 1199 8192000000 10808521232 11198136320 1870862512 18.591 100 86 172 0 1908722176 13400304 24459360
14:08:43 2514 8192000000 10806326480 11199528960 1872258608 18.603 100 93 187 2 1910047040 10698544 27089888
14:08:52 1984 8192000000 10811960896 11206885376 1869702752 18.582 100 81 160 3 1904131408 11878816 22549840
14:09:02 12630 8192000000 10813702912 11200225280 1873953984 18.616 100 86 169 1 1910210560 11763024 24493552
14:09:21 4053 8192000000 10801913632 11210072064 1874339872 18.619 100 75 151 2 1907645120 12858352 20446896
14:09:48 14278 8192000000 10761524432 11195924480 1867318992 18.563 100 33 67 1 1883898720 6754368 9825360
14:10:10 5739 8192000000 10785096192 11202650112 1872869840 18.607 100 36 71 0 1890960144 7495824 10594480
14:10:23 7577 8192000000 10781961728 11205038080 1870845952 18.591 100 26 51 0 1885892096 7455616 7590528
14:10:40 10018 8192000000 10784697008 11209920512 1871695632 18.598 100 23 46 1 1884573792 6559824 6318336
14:10:56 9153 8192000000 10776448960 11211051008 1872888288 18.608 100 23 46 2 1886978368 6904384 7185696
14:11:13 11819 8192000000 10774055776 11208286208 1876871040 18.640 100 14 28 0 1886881872 5999040 4011792
14:11:36 10769 8192000000 10794306544 11220692992 1879568640 18.662 100 9 18 0 1888063120 5742416 2752064
14:11:57 8221 8192000000 10793188528 11224600576 1886071408 18.714 100 14 27 2 1896378224 6101824 4204992
14:12:14 7673 8192000000 10789151200 11229233152 1890362432 18.749 100 15 30 1 1901520944 7052224 4106288
14:12:29 16212 8192000000 10798156768 11231653888 1890824144 18.752 100 18 35 1 1901757776 6624304 4309328
14:12:54 21252 8192000000 10819674160 11234197504 1894545168 18.782 100 17 34 2 1904517888 5660368 4312352
14:13:22 55761 8192000000 10813154240 11250507776 1901954176 18.842 100 34 69 1 1918228320 6464880 9809264
14:14:29 24068 8192000000 10825788480 11260436480 1903481664 18.854 100 33 66 2 1919984656 7571456 8931536
14:15:00 5078 8192000000 10814266864 11252289536 1904912864 18.866 100 32 64 0 1921272160 6591872 9767424
14:15:12 8978 8192000000 10815568128 11252277248 1903116672 18.851 100 18 36 1 1913722608 5670080 4935856
14:15:31 7053 8192000000 10822119072 11257745408 1910238864 18.909 100 23 47 2 1922071104 5501776 6330464
14:15:44 5979 8192000000 10834052848 11264495616 1909743888 18.905 100 32 63 1 1929152336 10943152 8465296
14:15:59 5158 8192000000 10815020912 11256320000 1910451072 18.910 100 27 54 1 1928984432 10629856 7903504
14:16:16 11378 8192000000 10824758096 11264651264 1911001200 18.915 100 20 40 3 1926920336 9675664 6243472
14:16:33 6028 8192000000 10826390288 11260137472 1895062320 18.787 99 34 67 4 1911178416 6340208 9775888
14:16:50 11575 8192000000 10814290544 11247173632 1867665456 18.565 98 19 39 1 1878869824 6132672 5071696
14:17:09 8112 8192000000 10799068560 11240529920 1856560544 18.475 98 20 40 1 1872739728 10546800 5632384
14:17:23 10781 8192000000 10781187056 11210698752 1835122960 18.301 97 18 36 1 1846172096 5973552 5075584
14:17:48 12380 8192000000 10783291440 11207581696 1821993280 18.194 97 21 42 3 1833197136 4984560 6219296
14:18:07 16165 8192000000 10750557056 11179442176 1765531344 17.730 95 9 18 1 1773395808 4860368 3004096
14:18:31 69000 8192000000 10743759008 11166609408 1765248112 17.728 95 35 70 0 1780558352 5153504 10156736
14:19:49 11730 8192000000 10727245936 11148587008 1767254128 17.744 96 25 48 3 1779878752 6199248 6425376
14:20:07 3564 8192000000 10728163968 11146940416 1791574880 17.945 98 46 91 3 1812207024 7491312 13140832
14:20:18 6125 8192000000 10695324720 11104444416 1711316576 17.280 95 28 56 0 1725478736 6661024 7501136
14:20:31 6487 8192000000 10663646688 11071311872 1716784032 17.325 96 32 63 3 1732000560 6682048 8534480
14:20:45 6496 8192000000 10697792064 11116904448 1759273392 17.678 98 30 60 3 1774196432 6407120 8515920
14:20:58 6762 8192000000 10727140592 11146846208 1806327184 18.066 100 31 62 1 1820975024 6190272 8457568
14:21:12 9142 8192000000 10729004928 11146448896 1796690112 17.987 99 21 42 0 1808444304 5849968 5904224
14:21:30 7062 8192000000 10734993888 11145175040 1794419344 17.968 99 18 34 2 1804078784 5065872 4593568
14:21:44 8080 8192000000 10698878864 11114606592 1738506336 17.506 97 11 22 0 1746325360 4861344 2957680
14:22:01 5023 8192000000 10698083344 11115151360 1783091792 17.875 100 22 44 1 1799715648 10399232 6224624
14:22:12 11416 8192000000 10696420448 11116339200 1770902720 17.774 98 18 36 1 1781890096 5820640 5166736
14:22:30 8728 8192000000 10720220336 11148787712 1815152080 18.138 100 20 40 0 1830877264 9836176 5889008
14:22:45 10251 8192000000 10724567008 11144675328 1796560528 17.986 99 27 54 1 1810659456 5451856 8647072
14:23:01 11538 8192000000 10748910592 11170488320 1826878112 18.234 100 25 50 2 1839870176 5269424 7722640
14:23:24 14764 8192000000 10735933968 11163418624 1811961872 18.112 99 17 34 1 1821945440 5137680 4845888
14:23:46 71326 8192000000 10788861776 11179880448 1826867424 18.234 99 63 130 2 1851952944 5248848 19836672
14:25:03 11251 8192000000 10752934672 11177443328 1841338576 18.352 100 23 46 2 1854492912 6889200 6265136
14:25:22 6500 8192000000 10759743552 11187036160 1846873424 18.397 100 30 58 0 1861735296 6925360 7936512
14:25:36 5785 8192000000 10778401792 11199881216 1856231472 18.473 100 40 79 2 1875540592 8668352 10640768
14:25:48 6287 8192000000 10777125248 11200802816 1858684112 18.493 100 37 72 1 1876139088 5891568 11563408
14:26:00 6069 8192000000 10771103504 11201114112 1858759632 18.493 100 24 48 1 1875409760 9783760 6866368
14:26:14 7333 8192000000 10779290240 11205697536 1863107840 18.528 100 30 60 1 1882184512 9867856 9208816
14:26:28 8017 8192000000 10774817952 11210842112 1866169280 18.553 100 26 52 0 1884407472 10809952 7428240
14:26:43 5309 8192000000 10787612704 11213107200 1871418352 18.596 100 31 62 1 1885891936 5033264 9440320
14:27:00 11185 8192000000 10805784576 11229761536 1879741344 18.663 100 21 42 1 1890168032 4664592 5762096
14:27:18 21564 8192000000 10815550624 11240787968 1891561104 18.758 100 18 37 0 1901219520 4639152 5019264
14:27:58 22435 8192000000 10844280992 11259891712 1906769504 18.881 100 39 75 1 1926540224 8513568 11257152
14:28:31 10466 8192000000 10867012512 11279515648 1918096576 18.972 100 51 102 0 1949118272 16390464 14631232
14:28:49 13849 8192000000 10872555808 11290648576 1930477984 19.071 100 59 118 3 1961038192 13829088 16731120
14:29:13 10790 8192000000 10874732496 11295969280 1935666992 19.112 100 65 131 3 1968522256 14055008 18800256
14:29:37 49785 8192000000 10880236160 11301957632 1939550784 19.143 100 54 108 1 1969647840 15442896 14654160
14:31:03 13915 8192000000 10889438576 11312439296 1943365568 19.174 100 38 75 0 1970489904 15755216 11369120
14:31:32 16774 8192000000 10891769760 11320946688 1946631680 19.200 100 29 58 4 1971944592 16089488 9223424
14:31:59 8762 8192000000 10895058496 11324047360 1958456304 19.294 100 56 112 0 1992266496 17011040 16799152
14:32:16 5348 8192000000 10905438880 11326930944 1962878144 19.329 100 46 92 3 1992246704 16312176 13056384
14:32:29 8396 8192000000 10914103328 11338833920 1967649296 19.367 100 60 118 0 2002562144 17709920 17202928
14:32:45 5988 8192000000 10914275040 11341422592 1971133040 19.394 100 50 99 1 2005529776 20239968 14156768
14:33:05 17835 8192000000 10927139984 11359531008 1979865872 19.464 100 51 102 2 2016663792 22116816 14681104
14:33:31 7327 8192000000 10931283920 11363602432 1984731600 19.502 100 55 109 1 2023154480 21898256 16524624
14:34:09 16609 8192000000 10936299248 11373678592 1988969328 19.536 100 38 76 0 2020478032 20272224 11236480
14:34:40 18023 8192000000 10960179824 11390185472 1999112944 19.616 100 53 104 2 2044506688 30048800 15344944
14:35:09 3612 8192000000 10957568864 11387355136 2003912240 19.654 100 65 129 0 2050752224 27413568 19426416
14:35:20 6879 8192000000 10951356512 11385810944 2006187392 19.671 100 65 129 3 2052976720 26962368 19826960
14:35:36 8397 8192000000 10957529968 11383574528 1988603744 19.533 99 60 118 2 2032427168 26351984 17471440
14:35:54 23345 8192000000 10947633104 11389358080 2000699744 19.628 100 49 98 3 2042758352 26961232 15097376
14:36:25 12393 8192000000 10955538496 11396698112 2004019104 19.654 100 46 92 2 2046892624 28105456 14768064
14:36:45 11656 8192000000 10969147360 11404931072 2010809392 19.708 100 51 102 4 2055702352 29141200 15751760
14:37:04 5619 8192000000 10983300560 11414192128 2022302288 19.798 100 80 160 1 2077371856 30351232 24718336
14:37:24 4952 8192000000 10972770816 11404058624 2001045312 19.631 99 67 134 1 2052484976 31412848 20026816
14:37:36 3557 8192000000 10975143328 11407224832 2015890192 19.748 100 61 122 1 2065489616 31009456 18589968
14:37:55 4675 8192000000 10984163232 11412959232 2020493680 19.784 100 66 128 2 2071359696 32208192 18657824
14:38:08 2829 8192000000 10985032896 11408064512 2014857520 19.740 100 74 147 0 2070009776 32930240 22222016
14:38:18 6536 8192000000 10982553632 11413663744 2020468016 19.784 100 74 147 0 2077697520 34506704 22722800
14:38:32 4480 8192000000 10991481824 11415736320 2020480176 19.784 100 76 150 3 2079418672 35745136 23193360
14:38:43 1598 8192000000 11006174624 11420897280 2024874192 19.818 100 88 176 0 2088341616 37607088 25860336
14:38:52 1628 8192000000 11007905840 11426459648 2025824368 19.826 100 85 170 0 2091206848 39702544 25679936
14:39:01 4850 8192000000 11002543552 11432116224 2027542336 19.839 100 80 158 0 2092136192 40157648 24436208
14:39:14 11214 8192000000 11004944656 11436097536 2029794576 19.857 100 65 130 1 2093070064 43950640 19324848
14:39:35 2562 8192000000 11007518368 11423039488 2013056640 19.726 99 82 163 1 2079325664 41919584 24349440
14:39:49 12006 8192000000 10997696416 11425210368 2011147584 19.711 99 70 138 2 2072810768 40796608 20866576
14:40:08 4141 8192000000 11016075328 11444420608 2033641936 19.887 100 70 140 1 2098263568 43138304 21483328
14:40:20 7829 8192000000 11001989552 11437342720 2026861824 19.834 100 63 123 1 2092100320 45221216 20017280
14:40:37 3197 8192000000 11024496736 11447787520 2035161760 19.899 100 79 156 0 2105723280 47042304 23519216
14:40:47 1881 8192000000 11014452960 11440939008 2012418336 19.721 99 81 162 2 2085643264 48353568 24871360
14:40:56 2433 8192000000 11000790384 11426226176 2014344832 19.736 100 79 158 2 2088055072 49595216 24115024
14:41:08 4497 8192000000 11011193984 11437395968 2021120880 19.789 100 79 157 1 2095994976 50438928 24435168
14:41:19 2806 8192000000 11003563152 11423027200 2009233648 19.695 99 81 160 2 2084988864 51122864 24632352
14:41:29 2571 8192000000 11010972400 11429728256 2007344304 19.681 99 91 179 3 2089653296 54962160 27346832
14:41:38 3284 8192000000 11007113712 11424260096 1989465040 19.540 99 83 164 0 2071088496 56496960 25126496
14:41:49 2153 8192000000 11010080864 11429584896 2010436192 19.705 100 86 172 2 2093716944 56076128 27204624
14:41:58 3782 8192000000 10998374608 11417735168 1998530928 19.611 100 79 158 4 2079011792 57022064 23458800
14:42:09 3842 8192000000 10983045888 11399770112 1978425712 19.452 100 88 174 0 2065201424 59919696 26856016
14:42:20 1924 8192000000 10999828016 11414802432 1992315664 19.562 100 84 168 0 2077920448 59884208 25720576
14:42:29 1638 8192000000 10987453008 11404947456 1988906704 19.535 100 87 174 1 2069924448 53839360 27178384
14:42:38 4506 8192000000 10982598880 11407417344 1988179088 19.529 100 78 156 2 2066184608 53193808 24811712
14:42:49 3174 8192000000 10993311200 11412860928 1991680240 19.557 100 80 160 2 2074613280 56844704 26088336
14:43:05 7233 8192000000 10964893584 11396411392 1977241104 19.443 100 65 130 1 2054001520 55730992 21029424
14:43:22 8458 8192000000 10973581504 11405385728 1984590976 19.501 100 61 122 2 2060737200 55596000 20550224
14:43:38 4950 8192000000 10983908144 11414188032 1991776704 19.558 100 63 125 0 2068284912 55782144 20726064
14:43:52 4781 8192000000 10945844944 11372863488 1951833744 19.241 98 60 118 1 2030378880 58406432 20138704
14:44:04 2744 8192000000 10988633840 11413909504 1986068624 19.513 100 76 151 1 2069623792 59238688 24316480
14:44:15 7704 8192000000 10979851680 11395010560 1972366880 19.404 100 76 152 0 2054017088 57392416 24257792
14:44:29 7898 8192000000 10981759872 11403468800 1984376160 19.499 100 72 144 2 2066861792 59383104 23102528
14:44:44 3229 8192000000 10984332272 11405529088 1987686560 19.526 100 85 168 1 2070805824 57500544 25618720
14:44:54 1747 8192000000 10997035968 11411292160 1988546240 19.532 100 88 174 0 2076805232 61614864 26644128
14:45:02 6920 8192000000 10993265728 11404918784 1980014992 19.465 100 84 166 2 2068718704 62888144 25815568
14:45:15 4665 8192000000 10972140528 11386626048 1962582768 19.327 100 81 158 2 2050408960 63424944 24401248
14:45:30 4597 8192000000 10979980864 11394707456 1973652768 19.414 100 81 162 0 2059296528 60319136 25324624
14:45:43 8530 8192000000 10974902368 11395907584 1975003728 19.425 100 69 138 0 2056895056 60578832 21312496
14:45:59 3556 8192000000 10980776000 11403685888 1984548192 19.501 100 76 153 1 2065938752 57668016 23722544
14:46:12 4592 8192000000 10984497248 11396898816 1982404016 19.484 100 84 168 1 2065517008 57011040 26101952
14:46:25 3922 8192000000 10973145088 11395129344 1980400048 19.468 100 73 146 0 2056372112 53268288 22703776
14:46:41 6131 8192000000 10976072704 11397132288 1983345472 19.491 100 74 147 1 2060267744 54522416 22399856
14:46:54 8668 8192000000 10958274352 11400826880 1979153744 19.458 100 51 102 0 2052370800 56610400 16606656
14:47:18 7767 8192000000 10963922496 11400912896 1977009600 19.441 100 43 86 0 2048066432 56974160 14082672
14:47:32 12261 8192000000 10975593376 11412594688 1985907536 19.511 100 45 90 0 2059578176 58028256 15642384
14:47:55 12344 8192000000 10970569136 11415318528 1971797328 19.400 99 42 84 0 2046452512 60452256 14202928
14:48:16 6613 8192000000 10993219472 11423002624 1990525104 19.548 100 50 100 1 2069251104 61787248 16938752
14:48:30 10980 8192000000 10987875520 11437756416 1996047168 19.592 100 48 95 2 2076813120 65506480 15259472
14:48:51 13175 8192000000 10990072224 11432034304 2001872848 19.638 100 42 84 3 2078763264 62499728 14390688
14:49:17 14044 8192000000 10971300016 11408932864 1973774896 19.415 100 38 76 0 2049974832 63002048 13197888
14:49:48 14945 8192000000 10995458048 11434700800 1988305264 19.530 100 48 92 4 2076796992 72261280 16230448
14:50:21 18704 8192000000 10977910144 11426668544 1988175008 19.529 100 31 62 1 2061944512 63199296 10570208
14:50:48 10615 8192000000 10957028768 11399340032 1930312912 19.069 97 40 80 0 2009107248 65174144 13620192
14:51:05 15681 8192000000 10959773088 11403825152 1962597632 19.327 100 33 66 1 2044036304 69327968 12110704
14:51:30 14227 8192000000 10977248208 11422998528 1972765424 19.407 100 41 81 4 2054719680 68235904 13718352
14:51:54 10619 8192000000 10987887296 11431096320 1981680160 19.478 100 38 77 0 2067965200 72751616 13533424
14:52:35 27347 8192000000 10963603152 11424350208 1969749568 19.383 100 27 54 4 2048300816 68857456 9693792
14:53:28 17878 8192000000 10955313632 11415388160 1956449952 19.278 100 29 59 2 2038188576 70430992 11307632
14:54:00 29321 8192000000 10953422032 11415752704 1916523968 18.959 98 26 52 0 2017357408 90106592 10726848
14:54:41 21460 8192000000 10960200256 11423666176 1939906592 19.146 100 29 58 1 2044052960 92773712 11372656
14:55:14 22979 8192000000 10894648304 11406925824 1936176064 19.116 100 17 34 2 2006275584 64013984 6085536
14:55:43 36601 8192000000 10865610448 11321565184 1896388768 18.797 98 23 49 3 1915984416 12420736 7174912
14:56:35 54631 8192000000 10888046960 11338113024 1925354032 19.030 99 40 80 3 1953015632 16323104 11338496
14:57:36 3103 8192000000 10890225408 11327451136 1939137712 19.140 99 53 102 2 1965242848 12110640 13994496
14:57:48 3012 8192000000 10911949312 11337850880 1940092512 19.147 99 69 140 2 1974885296 14289264 20503520
14:57:58 7354 8192000000 10890515760 11337850880 1948589600 19.215 100 32 64 0 1972266496 14676176 9000720
14:58:12 43535 8192000000 10880120176 11335815168 1910211840 18.908 98 22 44 2 1928361056 11501968 6647248
14:59:02 65545 8192000000 10872210768 11332501504 1936576464 19.119 99 9 18 0 1948101008 9376176 2148368
15:00:39 101049 8192000000 10890444944 11349630976 1915371888 18.950 97 20 39 0 1929888992 8779936 5737168
15:03:05 74467 8192000000 10889581920 11348664320 1941734544 19.161 99 15 30 1 1956204048 10284128 4185376
15:04:35 65681 8192000000 10889126048 11346636800 1938426256 19.134 99 15 30 0 1958466736 16021568 4018912
15:06:16 128225 8192000000 10880059680 11332513792 1904188928 18.860 97 29 57 1 1919802832 7788112 7825792
15:08:31 64037 8192000000 10878179424 11338539008 1941274816 19.157 99 58 116 1 1968493200 10342096 16876288
15:09:44 39160 8192000000 10858505632 11324960768 1916080512 18.955 98 18 36 1 1927751360 6970784 4700064
15:10:41 27260 8192000000 10896567296 11344330752 1954239488 19.260 100 25 50 2 1968399520 6975888 7184144
15:11:18 70568 8192000000 10883374864 11354206208 1946045824 19.195 99 19 38 3 1961549968 9832912 5671232
15:12:41 53248 8192000000 10894436512 11367374848 1954386112 19.261 99 20 40 1 1971339840 10718032 6235696
15:13:40 78315 8192000000 10906800768 11382247424 1963974720 19.338 99 11 22 1 1983332224 15961552 3395952
15:15:05 51526 8192000000 10906908896 11374391296 1963197312 19.331 99 13 26 0 1985723184 18506528 4019344
15:17:14 51656 8192000000 10917502768 11397021696 1984168304 19.498 100 15 29 1 2007692736 18569840 4954592
15:18:12 106747 8192000000 10900079024 11383877632 1965538448 19.350 99 9 18 2 1978104048 10157488 2408112
15:20:06 60370 8192000000 10929687856 11393347584 1993097264 19.568 100 22 44 2 2006566784 8177008 5292512
15:21:14 44857 8192000000 10934549152 11396399104 1995108496 19.584 100 15 30 2 2008216976 8597424 4511056
15:22:05 24676 8192000000 10947706656 11405381632 2002160512 19.640 100 36 72 1 2021500944 9734928 9605504
15:22:38 62474 8192000000 10928080064 11400409088 1973869232 19.416 98 40 80 4 1996315552 11492592 10953728
15:23:49 45184 8192000000 10947139536 11412287488 2008661952 19.691 100 32 64 1 2029371760 11250688 9459120
15:24:46 51310 8192000000 10922375728 11394748416 1957095136 19.283 97 33 66 1 1980231920 13777136 9359648
15:25:44 37031 8192000000 10945667824 11402805248 1998484128 19.611 100 27 54 0 2021097120 14538112 8074880
15:26:31 54483 8192000000 10908891216 11390664704 1977809424 19.447 99 10 20 0 1990691536 10796080 2086032
15:27:31 28524 8192000000 10922576912 11383861248 1949913888 19.226 97 21 42 0 1961768784 6537968 5316928
15:28:06 59369 8192000000 10931169840 11396964352 1945190576 19.188 97 29 58 1 1966045216 13086816 7767824
15:29:15 66907 8192000000 10925346064 11387551744 1959663808 19.303 98 19 39 1 1974408848 9541136 5203904
15:30:30 22849 8192000000 10915458688 11376312320 1958369184 19.293 98 29 58 1 1979975760 13353280 8253296
15:30:59 69113 8192000000 10895573296 11379564544 1947213312 19.204 98 23 46 1 1966709200 13092704 6403184
15:32:16 81418 8192000000 10834005456 11303550976 1858331360 18.490 94 17 34 1 1874577104 11339120 4906624
15:33:49 80200 8192000000 10892433584 11377385472 1948982832 19.218 99 21 42 2 1971587760 16335008 6269920
15:35:15 7513 8192000000 10886157504 11356573696 1959274832 19.300 100 16 32 1 1977761248 13781456 4704960
15:35:33 76561 8192000000 10872359904 11350253568 1915519904 18.951 97 21 42 0 1933705280 12002656 6182720
15:37:34 59455 8192000000 10884862256 11358724096 1920295120 18.989 98 7 14 0 1935175936 12611872 2268944
15:38:42 80929 8192000000 10866209008 11346026496 1920069280 18.987 98 11 22 1 1931803104 8610992 3122832
15:40:09 74616 8192000000 10854875152 11333500928 1839243152 18.335 94 6 10 0 1849668480 8312720 2112608
15:42:21 49356 8192000000 10892160672 11348865024 1917071424 18.963 98 20 40 0 1933536864 10677184 5788256
15:43:21 91463 8192000000 10890167040 11357446144 1885345296 18.708 96 13 26 1 1902133664 13098432 3689936
15:45:04 42500 8192000000 10868930688 11335389184 1874502560 18.621 95 35 70 1 1898661200 14001232 10157408
15:45:58 96949 8192000000 10857105856 11335929856 1860422512 18.507 96 22 44 0 1877663104 11352000 5888592
15:47:47 91414 8192000000 10836892240 11293052928 1776588752 17.821 92 16 32 0 1794165520 12757328 4819440
15:49:32 42432 8192000000 10843369248 11312189440 1911998320 18.923 100 38 76 3 1937752032 14982368 10771344
15:50:23 41011 8192000000 10891364864 11329830912 1916036800 18.955 99 31 62 2 1935515776 10560064 8918912
15:51:10 30115 8192000000 10875186288 11339649024 1933245056 19.093 100 23 46 2 1954173440 14276144 6652240
15:51:52 61954 8192000000 10864459680 11335528448 1900458816 18.830 98 26 52 2 1923914816 15980608 7475392
15:53:00 96033 8192000000 10880997008 11359244288 1923792768 19.017 99 11 21 2 1945823136 19152544 2877824
15:54:43 99121 8192000000 10840589120 11307585536 1877881520 18.648 97 11 22 0 1895722432 14753136 3087776
15:56:28 29951 8192000000 10868789504 11327737856 1931543968 19.079 100 32 63 1 1949817168 9191120 9082080
15:57:10 37924 8192000000 10868103264 11344793600 1949004080 19.219 100 19 38 1 1962018512 8217024 4797408
15:57:54 41861 8192000000 10863072528 11336155136 1899801840 18.825 97 7 14 1 1910776928 9511056 1464032
15:59:03 77216 8192000000 10860716272 11336982528 1932634656 19.088 99 12 25 1 1945283408 9747600 2901152
16:00:26 25240 8192000000 10867431776 11348389888 1950004864 19.227 100 6 12 0 1964664192 13378000 1281328
16:00:58 35444 8192000000 10868066352 11355533312 1942489776 19.167 100 8 16 0 1956460736 12234240 1736720
16:01:39 8594 8192000000 10864805872 11351552000 1941391552 19.158 100 7 14 0 1957347888 14179664 1776672
16:01:54 21960 8192000000 10877069632 11352760320 1943709344 19.176 100 9 18 0 1960809344 14923520 2176480
16:02:32 49237 8192000000 10888565408 11360518144 1943890016 19.178 99 19 38 1 1961303040 11842640 5570384
16:03:45 117801 8192000000 10885659744 11389964288 1934349840 19.102 98 14 28 1 1951950928 13753984 3847104
16:05:49 47655 8192000000 10902084784 11375677440 1957027120 19.282 99 15 30 2 1969150624 7859600 4263904
16:07:20 25645 8192000000 10919317920 11379302400 1965688656 19.351 99 33 65 0 1986087616 11030080 9368880
16:08:03 63904 8192000000 10922461280 11389747200 1969148064 19.379 99 30 58 2 1991114544 14122768 7843712
16:09:13 28197 8192000000 10920575904 11389554688 1986581648 19.517 100 30 61 2 2005255648 9960176 8713824
16:09:50 76147 8192000000 10924789904 11409494016 1971158560 19.395 99 23 46 0 1991534592 14590608 5785424
16:11:14 40967 8192000000 10947641392 11414994944 2000995024 19.631 100 32 64 2 2029732352 19959392 8777936
16:12:04 34759 8192000000 10942730976 11417755648 1981359520 19.475 99 35 68 1 2012508448 21291008 9857920
16:12:45 31556 8192000000 10943475264 11406475264 1996103392 19.592 100 30 60 2 2017996848 13853776 8039680
16:13:24 23096 8192000000 10933128688 11392593920 1972158112 19.403 99 47 94 1 1998060816 12907120 12995584
16:13:59 86066 8192000000 10907645360 11391655936 1943163760 19.172 98 19 38 0 1963620800 15149664 5307376
16:15:39 26523 8192000000 10946619344 11383119872 1952028160 19.243 98 35 70 0 1971366816 9301792 10036864
16:16:14 23499 8192000000 10926391936 11380940800 1953062032 19.251 98 53 106 2 1982044928 13814864 15168032
16:16:49 124899 8192000000 10919535616 11397492736 1980218512 19.466 100 21 42 1 2002060752 16240912 5601328
16:19:09 75801 8192000000 10935758224 11409227776 2001071216 19.631 100 25 48 3 2014555584 7287296 6197072
16:20:31 76958 8192000000 10899578416 11390533632 1959413856 19.301 98 23 45 0 1976678000 10553632 6710512
16:21:59 47659 8192000000 10909018096 11400282112 1950209104 19.228 98 7 14 0 1965159680 12688240 2262336
16:22:56 36156 8192000000 10907084704 11398877184 1969140928 19.379 99 10 20 0 1987383072 15255360 2986784
16:23:41 58435 8192000000 10887114544 11370942464 1928599472 19.056 97 17 34 0 1944379328 10852960 4926896
16:24:52 87156 8192000000 10895014144 11376578560 1932888080 19.090 98 10 20 0 1948985024 13150128 2946816
16:26:25 66691 8192000000 9618452784 9959182336 741346992 8.298 38 6 12 0 750839920 8299456 1193472

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-03-2021 16:29:07 to 24-03-2021 16:29:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 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-03-2021 16:29:39 to 24-03-2021 16:29:41.

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          228755
MON$OLDEST_ACTIVE               229235
MON$OLDEST_SNAPSHOT             229235
MON$NEXT_TRANSACTION            229235
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                       2023296
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:214: 
:215: mscs-test-161.budzdorov.ru    Wed Mar 24 16:27:35 2021
:216:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:217: 
--- end of diff output ---

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

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