Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.03.2021 22: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 17340160 kB
MemAvailable 31526284 kB
Buffers 0 kB
Cached 14362112 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-26 22:27:23
DTS_END                         2021-03-26 22:27:23.6040
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/37148
TRN_ID                          240824
ATT_ID                          636
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: 9280.71 21372 1113685
customer order: creation 172.35 384 20682
customer order: refuse 14.70 350 1764
order to supplier: creation 45.57 1336 5468
order to supplier: removal 3.48 96657 418
invoice (draft): creation 46.11 3277 5533
invoice (draft): removal 54.97 731 6596
invoice accept: apply 41.48 17897 4977
invoice accept: cancel 48.98 821 5877
customer reserve: creation 3759.17 181 451100
customer reserve: removal 4798.39 55 575807
realization accept: apply 82.53 200 9903
realization accept: cancel 84.08 100 10089
payment from customer: creation 59.50 128 7140
payment from customer: removal 5.49 50 659
payment to supplier: creation 48.43 133 5812
payment to supplier: removal 3.49 85 419
service: total inventory turnovers 4.89 1204 587
service: total monetary turnovers 6.24 30 749
service: aggregate perf. data 0.84 18858 101
service: refresh index statistics 0.03 284955 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-03-2021 22:29:04 to 26-03-2021 22:29:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5437
TEST_TIME 2 5220
TEST_TIME 3 4706
TEST_TIME 4 4715
TEST_TIME 5 4894
TEST_TIME 6 4782
TEST_TIME 7 4691
TEST_TIME 8 5045
TEST_TIME 9 5117
TEST_TIME 10 5271
TEST_TIME 11 5958
TEST_TIME 12 6286
TEST_TIME 13 6487
TEST_TIME 14 6727
TEST_TIME 15 6876
TEST_TIME 16 6737
TEST_TIME 17 6674
TEST_TIME 18 6998
TEST_TIME 19 7161
TEST_TIME 20 7372
TEST_TIME 21 7605
TEST_TIME 22 7656
TEST_TIME 23 8098
TEST_TIME 24 8591
TEST_TIME 25 8977
TEST_TIME 26 8981
TEST_TIME 27 9628
TEST_TIME 28 10042
TEST_TIME 29 9895
TEST_TIME 30 9874
TEST_TIME 31 10006
TEST_TIME 32 10002
TEST_TIME 33 10085
TEST_TIME 34 10073
TEST_TIME 35 9979
TEST_TIME 36 9887
TEST_TIME 37 9903
TEST_TIME 38 9817
TEST_TIME 39 9690
TEST_TIME 40 9679
TEST_TIME 41 9618
TEST_TIME 42 9501
TEST_TIME 43 9434
TEST_TIME 44 9389
TEST_TIME 45 9325
TEST_TIME 46 9282
TEST_TIME 47 9511
TEST_TIME 48 9530
TEST_TIME 49 9492
TEST_TIME 50 9456
TEST_TIME 51 9417
TEST_TIME 52 9441
TEST_TIME 53 9454
TEST_TIME 54 9451
TEST_TIME 55 9413
TEST_TIME 56 9398
TEST_TIME 57 9493
TEST_TIME 58 9574
TEST_TIME 59 9613
TEST_TIME 60 9644
TEST_TIME 61 9746
TEST_TIME 62 9756
TEST_TIME 63 9766
TEST_TIME 64 9739
TEST_TIME 65 9880
TEST_TIME 66 9767
TEST_TIME 67 9661
TEST_TIME 68 9687
TEST_TIME 69 9591
TEST_TIME 70 9591
TEST_TIME 71 9595
TEST_TIME 72 9558
TEST_TIME 73 9546
TEST_TIME 74 9478
TEST_TIME 75 9395
TEST_TIME 76 9341
TEST_TIME 77 9339
TEST_TIME 78 9320
TEST_TIME 79 9424
TEST_TIME 80 9476
TEST_TIME 81 9498
TEST_TIME 82 9462
TEST_TIME 83 9452
TEST_TIME 84 9468
TEST_TIME 85 9508
TEST_TIME 86 9468
TEST_TIME 87 9535
TEST_TIME 88 9538
TEST_TIME 89 9558
TEST_TIME 90 9566
TEST_TIME 91 9562
TEST_TIME 92 9469
TEST_TIME 93 9405
TEST_TIME 94 9386
TEST_TIME 95 9367
TEST_TIME 96 9348
TEST_TIME 97 9323
TEST_TIME 98 9274
TEST_TIME 99 9265
TEST_TIME 100 9344
TEST_TIME 101 9355
TEST_TIME 102 9379
TEST_TIME 103 9355
TEST_TIME 104 9381
TEST_TIME 105 9368
TEST_TIME 106 9421
TEST_TIME 107 9475
TEST_TIME 108 9524
TEST_TIME 109 9524
TEST_TIME 110 9516
TEST_TIME 111 9444
TEST_TIME 112 9425
TEST_TIME 113 9394
TEST_TIME 114 9386
TEST_TIME 115 9326
TEST_TIME 116 9299
TEST_TIME 117 9295
TEST_TIME 118 9303
TEST_TIME 119 9328
TEST_TIME 120 9285

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-03-2021 22:29:07 to 26-03-2021 22:29:11.

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 1533530 1533530 0 0.00 0 21814 6 0 0
doc_list_biud 1533530 1533530 0 0.00 0 68155 27 0 0
sp_add_invoice_to_stock 5157 4977 180 3.49 28 199621 17898 0 180
sp_cancel_adding_invoice 5877 5877 0 0.00 5 79552 822 0 0
sp_cancel_client_order 1764 1764 0 0.00 4 15587 350 0 0
sp_cancel_customer_reserve 575807 575807 0 0.00 1 68156 56 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 2 1200 50 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 6568 86 0 0
sp_cancel_supplier_invoice 6608 6596 12 0.18 2 28005 731 0 12
sp_cancel_supplier_order 418 418 0 0.00 13 1001697 96658 0 0
sp_cancel_write_off 10089 10089 0 0.00 1 8830 100 0 0
sp_client_order 20682 20682 0 0.00 3 53761 384 0 0
sp_customer_reserve 451100 451100 0 0.00 0 148590 181 0 0
sp_fill_shopping_cart 31673 31673 0 0.00 1 18082 39 0 0
sp_fill_shopping_cart_clo_res 451091 451091 0 0.00 0 16852 12 0 0
sp_get_clo_for_invoice 4967 4967 0 0.00 0 26687 292 0 0
sp_kill_cost_storno 17044 17044 0 0.00 0 13417 50 0 0
sp_kill_qstorno_ret_qs2qd 1168717 1168717 0 0.00 0 68145 30 0 0
sp_kill_qty_storno 615421 615421 0 0.00 0 68154 66 0 0
sp_lock_selected_doc 20703 20703 0 0.00 0 10221 7 0 0
sp_make_cost_storno 27822 27822 0 0.00 0 17854 60 0 0
sp_multiply_rows_for_pdistr 27822 27822 0 0.00 0 14899 32 0 0
sp_multiply_rows_for_qdistr 20682 20682 0 0.00 0 51658 183 0 0
sp_pay_from_customer 7140 7140 0 0.00 4 16073 128 0 0
sp_pay_to_supplier 5812 5812 0 0.00 4 15979 133 0 0
sp_payment_common 12952 12952 0 0.00 1 16068 35 0 0
sp_qd_handle_on_cancel_clo 1764 1764 0 0.00 0 15582 327 0 0
sp_qd_handle_on_invoice_upd_sts 10844 10844 0 0.00 0 21292 333 0 0
sp_qd_handle_on_reserve_upd_sts 9903 9903 0 0.00 0 19990 73 0 0
sp_reserve_write_off 9903 9903 0 0.00 6 22901 201 0 0
sp_supplier_invoice 5533 5533 0 0.00 7 77489 3278 0 0
sp_supplier_order 5468 5468 0 0.00 5 26185 1337 0 0
srv_aggregate_perf_data 101 101 0 0.00 2052 193880 18859 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1186 184015 34085 0 0
srv_find_qd_qs_mism 1067468 1067468 0 0.00 0 11811 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 39 49696 1204 0 0
srv_make_money_saldo 749 749 0 0.00 1 2919 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 151779 413318 284955 0 0
t$perf-abend:sp_add_invoice_to_stock 180 180 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4977 4977 0 0.00 0 19919 189 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 16561 209 0 0
t$perf-norm:sp_cancel_client_order 1764 1764 0 0.00 0 7298 21 0 0
t$perf-norm:sp_cancel_customer_reserve 715 715 0 0.00 0 703 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 3658 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 2095 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 1220 15 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 23608 1519 0 0
t$perf-norm:sp_cancel_write_off 1008 1008 0 0.00 0 2748 6 0 0
t$perf-norm:sp_client_order 20682 20682 0 0.00 0 7658 20 0 0
t$perf-norm:sp_customer_reserve 991 991 0 0.00 0 4241 15 0 0
t$perf-norm:sp_pay_from_customer 7140 7140 0 0.00 0 6417 12 0 0
t$perf-norm:sp_pay_to_supplier 5812 5812 0 0.00 0 14363 18 0 0
t$perf-norm:sp_reserve_write_off 9903 9903 0 0.00 0 16977 15 0 0
t$perf-norm:sp_supplier_invoice 5533 5533 0 0.00 0 4101 16 0 0
t$perf-norm:sp_supplier_order 5468 5468 0 0.00 0 9286 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 996 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1026 11 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 627 16 0 0
t$perf-norm:srv_make_money_saldo 749 749 0 0.00 0 2529 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 19 6 0 0
v_add_invoice_to_stock 10292 9932 360 3.49 0 3735 17 0 360
v_all_customers 37576 37576 0 0.00 0 73 1 0 0
v_all_suppliers 30314 30314 0 0.00 0 106 1 0 0
v_all_wares 41364 41364 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 812 7 0 0
v_cancel_client_order 3528 3528 0 0.00 0 3425 6 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 318 2 0 0
v_cancel_customer_reserve 1430 1430 0 0.00 0 2622 9 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 589 3 0 0
v_cancel_supplier_invoice 892 868 24 2.69 0 2552 22 0 24
v_cancel_supplier_order 836 836 0 0.00 0 7402 12 0 0
v_cancel_write_off 2016 2016 0 0.00 0 3343 16 0 0
v_max_id_clo_ord 5467 5467 0 0.00 0 806 1 0 0
v_max_id_clo_res 991 991 0 0.00 0 2013 12 0 0
v_max_id_ord_sup 5524 5524 0 0.00 0 3407 4 0 0
v_max_non_paid_invoice 1646 1646 0 0.00 0 1669 4 0 0
v_max_non_paid_realizn 3771 3771 0 0.00 0 6204 7 0 0
v_min_id_clo_ord 5467 5467 0 0.00 0 15807 22 0 0
v_min_id_clo_res 991 991 0 0.00 0 660 3 0 0
v_min_id_ord_sup 5524 5524 0 0.00 0 1991 3 0 0
v_min_non_paid_invoice 5812 5812 0 0.00 0 12019 19 0 0
v_min_non_paid_realizn 7140 7140 0 0.00 0 16060 25 0 0
v_our_firm 10526 10526 0 0.00 0 73 1 0 0
v_reserve_write_off 19806 19806 0 0.00 0 7335 6 0 0
x_lock_depdocs_on_canc_invoice 12039 12039 0 0.00 0 17870 117 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 5969 318 0 0
x_make_qstorno_1000_1200 5468 5468 0 0.00 2 22046 1237 0 0
x_make_qstorno_1200_2000 5533 5533 0 0.00 3 76917 3152 0 0
x_make_qstorno_2100_3300 451100 451100 0 0.00 0 148589 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2021 22:29:12 to 26-03-2021 22:29:16.

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:26 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 12319 8192000000 10199509440 10500894720 792652448 8.822 63 54 107 0 812807440 2096736 18058256
19:57:54 24383 8192000000 10312928144 10626494464 1352160592 14.167 100 77 155 1 1381465456 4303456 25001408
19:58:29 32277 8192000000 10382236544 10705133568 1426447936 14.830 100 90 180 0 1461454976 5918304 29088736
19:59:16 25786 8192000000 10417351728 10743476224 1471689472 15.229 100 92 184 0 1509675536 7821632 30164432
20:00:00 23725 8192000000 10428123552 10755338240 1482126640 15.320 100 87 174 0 1519346720 8596096 28623984
20:00:38 17277 8192000000 10455922832 10789847040 1502183264 15.495 100 81 162 1 1537069856 9056800 25829792
20:01:13 25916 8192000000 10494093072 10832134144 1537540896 15.802 100 87 174 1 1574641696 9928352 27172448
20:01:45 12959 8192000000 10506917312 10851176448 1558591808 15.984 100 85 170 2 1595071808 10367856 26112144
20:02:17 14316 8192000000 10531391392 10881384448 1582895472 16.193 100 84 167 0 1618868672 10629728 25343472
20:02:41 11661 8192000000 10550060736 10904317952 1609255376 16.418 100 78 156 2 1643822176 10960896 23605904
20:03:03 16636 8192000000 10577538144 10933116928 1626914288 16.569 100 77 154 1 1661276544 11198864 23163392
20:03:29 12839 8192000000 10593027504 10956673024 1657643120 16.829 100 80 160 2 1693438896 12095216 23700560
20:03:51 9186 8192000000 10615315968 10981900288 1675157984 16.977 100 77 154 1 1709381040 11988928 22234128
20:04:08 7054 8192000000 10630252528 11003027456 1696338192 17.154 100 81 162 2 1732973856 12515104 24120560
20:04:27 11205 8192000000 10658756992 11026837504 1709856992 17.268 100 74 148 1 1744320640 13123152 21340496
20:04:46 6195 8192000000 10665292416 11040448512 1728169584 17.420 100 82 164 1 1764738848 13782176 22787088
20:04:59 7446 8192000000 10677531120 11049537536 1737363680 17.497 100 82 165 0 1775240032 14794544 23081808
20:05:14 5310 8192000000 10680711184 11057049600 1747635360 17.582 100 83 166 1 1785284304 14332976 23315968
20:05:26 4620 8192000000 10695963184 11072643072 1757163504 17.661 100 79 157 2 1792717984 13174784 22379696
20:05:38 4951 8192000000 10693735936 11078000640 1760999616 17.693 100 65 130 1 1791223008 11706656 18516736
20:05:50 4771 8192000000 10713305072 11093856256 1775095856 17.809 100 81 161 0 1809711360 11876720 22738784
20:06:02 3269 8192000000 10713966944 11096616960 1781683376 17.863 100 87 172 2 1818748320 13364016 23700928
20:06:16 6254 8192000000 10734865808 11113218048 1786932400 17.907 100 83 166 3 1823832976 14017184 22883392
20:06:30 3825 8192000000 10747321632 11133820928 1804004336 18.047 100 82 162 1 1844975392 18172720 22798336
20:06:41 2988 8192000000 10753992752 11136995328 1813039024 18.121 100 84 167 3 1850289952 12009344 25241584
20:06:50 2013 8192000000 10759398848 11144978432 1822849664 18.201 100 84 168 2 1859591424 12897072 23844688
20:06:59 2542 8192000000 10771981936 11155415040 1827888688 18.242 100 87 174 0 1865872944 12834112 25150144
20:07:09 2665 8192000000 10780358720 11163099136 1834988224 18.300 100 91 182 2 1873914560 13439632 25486704
20:07:18 1589 8192000000 10778873920 11164307456 1839584800 18.337 100 95 190 1 1880298800 13377344 27336656
20:07:26 1775 8192000000 10788655520 11172225024 1843479216 18.369 100 95 191 1 1884450784 14104816 26866752
20:07:34 2017 8192000000 10786649744 11171012608 1845295376 18.384 100 82 163 1 1880726576 12958240 22472960
20:07:43 3179 8192000000 10792172144 11178987520 1850443504 18.426 100 94 188 1 1891818928 14895600 26479824
20:07:53 2318 8192000000 10799383408 11186180096 1853731808 18.452 100 89 179 0 1893603872 14886736 24985328
20:08:01 2151 8192000000 10803343872 11189141504 1855901808 18.470 100 92 185 0 1896916464 15320672 25693984
20:08:10 1474 8192000000 10802136928 11189547008 1862807456 18.526 100 96 192 1 1905508848 15277488 27423904
20:08:18 2008 8192000000 10809174704 11194191872 1862345136 18.522 100 96 193 4 1902743168 12548336 27849696
20:08:26 1546 8192000000 10815909056 11200372736 1865920256 18.551 100 92 185 1 1903346512 11857408 25568848
20:08:34 2329 8192000000 10817852784 11204931584 1867273232 18.562 100 92 180 2 1906578576 12761376 26543968
20:08:43 2983 8192000000 10815894656 11206172672 1866919424 18.559 100 83 166 3 1903304736 12919760 23465552
20:08:53 26573 8192000000 10792267856 11200331776 1863739792 18.534 100 58 114 2 1888763408 8284464 16739152
20:09:30 22962 8192000000 10797202256 11206295552 1874990752 18.625 100 66 132 5 1902043536 7423456 19629328
20:09:59 1393 8192000000 10824800240 11217584128 1879748736 18.663 100 84 168 1 1914790816 11786144 23255936
20:10:08 22970 8192000000 10766927536 11202179072 1870649728 18.590 100 36 72 2 1889646592 8879152 10117712
20:10:38 8763 8192000000 10778960256 11206365184 1871534528 18.597 100 19 36 1 1881577776 5013664 5029584
20:10:55 7047 8192000000 10795285680 11220082688 1884387776 18.701 100 28 55 1 1899095328 6902880 7804672
20:11:09 2261 8192000000 10808054640 11229605888 1888396784 18.733 100 45 90 1 1909307392 8313600 12597008
20:11:19 7524 8192000000 10796713216 11223257088 1885620528 18.710 100 29 58 2 1901104192 6986816 8496848
20:11:36 8926 8192000000 10808365520 11231506432 1888063072 18.730 100 27 53 2 1901957536 5963856 7930608
20:11:51 7588 8192000000 10796291312 11227987968 1890320960 18.748 100 24 48 2 1903367328 5979136 7067232
20:12:05 9377 8192000000 10799732944 11233603584 1889343344 18.740 100 14 28 1 1903675392 10100000 4232048
20:12:20 11949 8192000000 10806895696 11239358464 1893830720 18.777 100 18 36 1 1908468720 9782080 4855920
20:12:41 7537 8192000000 10800182320 11235389440 1896165536 18.795 100 28 56 1 1911167184 6378912 8622736
20:12:57 13072 8192000000 10796840064 11234369536 1893389136 18.773 100 15 30 1 1903324480 5590576 4344768
20:13:21 9304 8192000000 10795878224 11235872768 1894963408 18.786 100 22 44 0 1907656656 6268208 6425040
20:13:38 15105 8192000000 10808093456 11242930176 1896119136 18.795 100 21 42 1 1911995552 10373616 5502800
20:13:59 10494 8192000000 10805872080 11242975232 1900628384 18.831 100 23 45 3 1913072896 6021136 6423376
20:14:20 68351 8192000000 10853409312 11262701568 1913648480 18.936 100 42 88 0 1932353600 6429296 12275824
20:15:34 9065 8192000000 10814259376 11252645888 1906711200 18.880 100 37 74 1 1926601264 9092192 10797872
20:15:50 7907 8192000000 10815544496 11254562816 1906602016 18.879 100 33 64 1 1920897088 6181504 8113568
20:16:04 6179 8192000000 10824748608 11260911616 1906102608 18.875 100 19 38 3 1922018800 10602896 5313296
20:16:17 6846 8192000000 10834661392 11259158528 1909644304 18.904 100 26 52 1 1923417408 6092576 7680528
20:16:31 9441 8192000000 10804749056 11235942400 1852065424 18.439 97 29 58 1 1866702416 6441632 8195360
20:16:47 8523 8192000000 10807102976 11244277760 1897176320 18.804 100 28 56 2 1916029216 10479904 8372992
20:17:02 3495 8192000000 10810289328 11238989824 1882472864 18.685 99 29 57 4 1897572640 5291968 9807808
20:17:21 8200 8192000000 10786367424 11220250624 1852246016 18.440 98 20 40 2 1863547008 5884976 5416016
20:17:36 7162 8192000000 10788116752 11215650816 1863507584 18.532 99 31 62 2 1877968672 5697808 8763280
20:17:51 4887 8192000000 10804267360 11224436736 1869247568 18.578 99 34 67 1 1885281504 6143072 9890864
20:18:03 14558 8192000000 10788807984 11220029440 1812734048 18.118 96 22 44 1 1823656400 5264544 5657808
20:18:26 8154 8192000000 10767328528 11196198912 1827789440 18.241 97 16 32 1 1837891664 5181680 4920544
20:18:45 12814 8192000000 10764147536 11193933824 1793628048 17.962 96 15 30 1 1803414832 5586176 4200608
20:19:04 59037 8192000000 10686301648 11105964032 1587440800 16.232 86 24 48 0 1599907312 5690960 6775552
20:20:12 13167 8192000000 10700631232 11105710080 1681578336 17.031 93 24 47 1 1693316208 5148960 6588912
20:20:34 8798 8192000000 10684778752 11101155328 1730845792 17.443 96 24 49 0 1746950176 9352272 6752112
20:20:53 5017 8192000000 10707312144 11119108096 1747512736 17.581 97 36 72 1 1764668240 6469680 10685824
20:21:04 3658 8192000000 10694974640 11099332608 1747517120 17.581 99 31 57 2 1761767136 4982848 9267168
20:21:16 6682 8192000000 10682736912 11093553152 1713395200 17.297 96 33 64 2 1729581040 6981904 9203936
20:21:30 7616 8192000000 10698735152 11115397120 1755679856 17.649 98 29 57 2 1769700704 5623600 8397248
20:21:47 7753 8192000000 10694061264 11096039424 1736985216 17.494 97 25 50 3 1750945968 6521520 7439232
20:22:02 6811 8192000000 10711025328 11131174912 1784910928 17.890 99 24 48 0 1796504416 5110496 6482992
20:22:15 6796 8192000000 10734256208 11145920512 1792646656 17.954 99 24 48 0 1805140480 5895312 6598512
20:22:28 10326 8192000000 10742631888 11153436672 1813572224 18.125 100 26 53 1 1827215712 5506224 8137264
20:22:48 8885 8192000000 10754858896 11174227968 1830510352 18.263 100 29 58 0 1844878448 5250848 9117248
20:23:04 11721 8192000000 10740601696 11166961664 1830945104 18.267 100 15 30 1 1840802928 4899456 4958368
20:23:26 15185 8192000000 10758396976 11181084672 1840415856 18.344 100 20 40 2 1851638880 5236512 5986512
20:23:48 46077 8192000000 10798348528 11202224128 1855468400 18.467 100 44 88 4 1874509968 5452400 13589168
20:24:42 46032 8192000000 10779396352 11202560000 1834478368 18.296 99 18 36 0 1849099616 9853648 4767600
20:25:35 8339 8192000000 10792794928 11215060992 1868314960 18.571 100 45 90 2 1887937040 6734352 12887728
20:25:49 12551 8192000000 10788024720 11214794752 1867986048 18.568 100 24 48 0 1880325312 6318224 6021040
20:26:09 7086 8192000000 10784080048 11211763712 1871288112 18.595 100 25 50 0 1885031536 6910720 6832704
20:26:24 10736 8192000000 10783222672 11214204928 1873070976 18.609 100 26 52 1 1886588944 5288576 8229392
20:26:43 4938 8192000000 10793497776 11220779008 1875277760 18.627 100 29 58 1 1890041696 6577216 8186720
20:26:54 7762 8192000000 10787244720 11218501632 1875883104 18.632 100 23 46 2 1888936016 5826768 7226144
20:27:08 7885 8192000000 10820539056 11244146688 1892839712 18.769 100 22 43 2 1904205344 4536848 6828784
20:27:24 32005 8192000000 10831090320 11254169600 1907521760 18.887 100 30 60 4 1921130736 5297616 8311360
20:28:07 24357 8192000000 10842425808 11270258688 1918253680 18.973 100 42 84 0 1937908240 7265952 12388608
20:28:45 11228 8192000000 10856039072 11280560128 1927054096 19.043 100 53 106 0 1951613424 9424368 15134960
20:29:07 13047 8192000000 10861394416 11284955136 1929869952 19.066 100 53 106 2 1954044800 9310016 14864832
20:29:29 36914 8192000000 10854489216 11289612288 1937346448 19.126 100 49 98 1 1962412944 10356016 14710480
20:30:15 85380 8192000000 10861617952 11291844608 1919955808 18.986 99 39 76 1 1940351296 9232176 11163312
20:31:49 39405 8192000000 10856512592 11306160128 1940019184 19.147 100 37 72 4 1961579952 11524496 10036272
20:32:35 11386 8192000000 10885048368 11312848896 1948167776 19.212 100 37 74 1 1968260656 9744368 10348512
20:32:58 7862 8192000000 10891235184 11322626048 1958364848 19.293 100 55 110 2 1985572944 11366000 15842096
20:33:16 15990 8192000000 10896254704 11326062592 1960870896 19.313 100 50 97 0 1984766592 11012272 12883424
20:33:40 2897 8192000000 10910755472 11330924544 1970195648 19.387 100 71 134 2 2002432432 11910368 20326416
20:33:53 14697 8192000000 10915977936 11344125952 1971696656 19.399 100 49 98 0 1999830400 14522208 13611536
20:34:27 14861 8192000000 10919168160 11346550784 1973062528 19.410 100 50 100 2 2004298784 16379296 14856960
20:34:56 7905 8192000000 10920119280 11355496448 1981555920 19.477 100 44 88 0 2011743760 17446368 12741472
20:35:13 2919 8192000000 10915060576 11337113600 1964991296 19.346 99 62 124 1 2001004304 17370752 18642256
20:35:27 6471 8192000000 10924457696 11351019520 1978571840 19.453 100 57 113 3 2013175200 17908592 16694768
20:35:40 3435 8192000000 10925628720 11344355328 1966359936 19.357 99 71 140 1 2007620944 19522192 21738816
20:35:56 10799 8192000000 10925726560 11352891392 1976363536 19.436 100 58 114 3 2012099216 18954688 16780992
20:36:21 9401 8192000000 10943889552 11372294144 1985022800 19.504 100 60 120 2 2028468032 25843472 17601760
20:36:38 18923 8192000000 10944147840 11375185920 1988408992 19.531 100 51 101 0 2027822736 24617744 14796000
20:37:10 17827 8192000000 10946381024 11380785152 1997960128 19.607 100 52 104 0 2038539088 24757952 15821008
20:37:34 12097 8192000000 10959262208 11389812736 1997146608 19.600 100 51 103 1 2041345408 28652288 15546512
20:37:53 5010 8192000000 10954890720 11388764160 2000659472 19.628 100 52 104 1 2045249744 28118240 16472032
20:38:06 2724 8192000000 10965496896 11391168512 2004217200 19.656 100 63 123 3 2046964016 24494032 18252784
20:38:17 4262 8192000000 10959563904 11387310080 2001952592 19.638 100 69 138 3 2046351552 24236656 20162304
20:38:29 4936 8192000000 10952964320 11377029120 1982368400 19.483 99 58 115 0 2023577456 24684704 16524352
20:38:44 2798 8192000000 10977265600 11394162688 2007532784 19.682 100 78 155 1 2055670928 25667760 22470384
20:38:53 3781 8192000000 10959398832 11383562240 1997606832 19.604 100 75 149 1 2045407680 26262272 21538576
20:39:09 1913 8192000000 10954726560 11378446336 1992292832 19.562 100 76 152 2 2041603024 26853136 22457056
20:39:19 3230 8192000000 10957395856 11382931456 1997316848 19.602 100 77 149 4 2047584352 27693248 22574256
20:39:29 3649 8192000000 10945474848 11368206336 1982684352 19.486 100 72 143 1 2029845664 25794304 21367008
20:39:40 2711 8192000000 10951657584 11375312896 1988184688 19.529 100 71 141 1 2034688832 25073600 21430544
20:39:50 4087 8192000000 10935225728 11350130688 1967371552 19.365 99 66 132 2 2011743792 24679696 19692544
20:40:02 1680 8192000000 10949609648 11374505984 1988849440 19.535 100 74 148 1 2037353712 26261776 22242496
20:40:16 2158 8192000000 10950884080 11364950016 1979772736 19.463 99 84 168 2 2032664784 27533744 25358304
20:40:28 5917 8192000000 10938099040 11357245440 1948363808 19.213 98 78 155 0 2001318544 29162000 23792736
20:40:43 1330 8192000000 10938522800 11346804736 1963805200 19.336 100 87 174 1 2018001664 28101744 26094720
20:40:51 1529 8192000000 10928981840 11341549568 1934814080 19.105 98 89 177 2 1990748096 29601840 26332176
20:40:59 5606 8192000000 10923130928 11335262208 1945182752 19.188 99 84 165 0 1999259664 29650208 24426704
20:41:12 3631 8192000000 10940526080 11354505216 1970190960 19.387 100 86 172 0 2023959840 28047776 25721104
20:41:24 3086 8192000000 10937643776 11353391104 1969730960 19.383 100 87 173 2 2023568608 28773216 25064432
20:41:35 3700 8192000000 10930793184 11342176256 1953660528 19.256 99 85 170 1 2008735408 29264112 25810768
20:41:46 20282 8192000000 10910283792 11333971968 1944815024 19.185 99 65 129 2 1993855728 29798720 19241984
20:42:13 24424 8192000000 10928115520 11364118528 1972628880 19.406 100 49 97 1 2017596000 30114368 14852752
20:42:46 3038 8192000000 10931179088 11368198144 1973403584 19.412 100 46 90 0 2017018544 29992368 13622592
20:43:00 12484 8192000000 10930962608 11366576128 1971955920 19.401 100 42 85 1 2016399456 31103744 13339792
20:43:26 8613 8192000000 10944568624 11380436992 1984575888 19.501 100 50 100 1 2036325872 34747680 17002304
20:43:43 6250 8192000000 10965422432 11394453504 1993179760 19.569 100 56 112 3 2049465536 37944496 18341280
20:43:56 8657 8192000000 10953149504 11397697536 1994375792 19.578 100 47 94 0 2048018448 38124480 15518176
20:44:15 6461 8192000000 10956066224 11395526656 1992787792 19.566 100 47 94 0 2046118544 37902000 15428752
20:44:32 4684 8192000000 10943855600 11377491968 1963548080 19.334 99 57 112 2 2021125536 39598608 17978848
20:44:47 5247 8192000000 10947528704 11372933120 1956121680 19.275 99 70 139 1 2018122768 40421328 21579760
20:45:00 4339 8192000000 10947533488 11377442816 1975283984 19.427 100 60 117 2 2030084208 35914176 18886048
20:45:27 9321 8192000000 10955060224 11387527168 1980348720 19.467 100 60 119 1 2039714432 41200592 18165120
20:45:44 3280 8192000000 10962956272 11380649984 1976608016 19.438 100 65 127 3 2037030608 38851024 21571568
20:45:55 3041 8192000000 10963789872 11382308864 1979826688 19.463 100 84 167 1 2046564400 40168624 26569088
20:46:05 2274 8192000000 10972195136 11384045568 1978901520 19.456 100 86 170 2 2046171328 42001792 25268016
20:46:14 1872 8192000000 10960920256 11381366784 1980935648 19.472 100 74 146 0 2044402512 39439248 24027616
20:46:23 2602 8192000000 10967414624 11389939712 1988901232 19.535 100 82 162 1 2052763952 39666000 24196720
20:46:33 2606 8192000000 10912876096 11316117504 1919327360 18.981 97 75 150 2 1982384864 40341376 22716128
20:46:44 4324 8192000000 10953027120 11369590784 1965511136 19.350 100 82 160 2 2031713424 41045792 25156496
20:46:57 3942 8192000000 10957805104 11379847168 1971153584 19.395 100 75 149 1 2036645360 42264240 23227536
20:47:08 4720 8192000000 10933933664 11367198720 1964727008 19.344 100 57 113 1 2022432464 40109680 17595776
20:47:24 6579 8192000000 10933239808 11371507712 1968698816 19.375 100 41 84 0 2020705008 38546576 13459616
20:47:38 6309 8192000000 10912048080 11354583040 1931121936 19.076 98 33 66 1 1980353664 38564416 10667312
20:47:53 8497 8192000000 10918530800 11349618688 1935558432 19.111 99 58 116 2 1994132016 40032544 18541040
20:48:13 9771 8192000000 10885933600 11316797440 1890792048 18.752 97 47 95 0 1946903376 41520016 14591312
20:48:29 13450 8192000000 10894547648 11324424192 1912464064 18.926 99 35 70 0 1960376864 36109488 11803312
20:48:51 11001 8192000000 10909071200 11333357568 1923348048 19.014 99 44 86 2 1979265136 41970992 13946096
20:49:09 6647 8192000000 10914837520 11345428480 1950903616 19.234 100 48 96 0 2005410640 39113136 15393888
20:49:24 11235 8192000000 10894257968 11331022848 1913906416 18.938 99 39 77 0 1967394384 39687056 13800912
20:49:43 12569 8192000000 10909435088 11347914752 1939869040 19.146 100 35 70 1 1995956288 43222496 12864752
20:50:06 7520 8192000000 10923092384 11350687744 1929069760 19.059 99 52 104 1 1993186736 46326992 17789984
20:50:20 2978 8192000000 10936855824 11360501760 1941050992 19.155 99 80 160 2 2014865536 46650928 27163616
20:50:30 7432 8192000000 10918262336 11360247808 1952296448 19.245 100 40 80 0 2008763136 43553952 12912736
20:50:49 14112 8192000000 10911198880 11353645056 1931455904 19.079 99 39 78 1 1987423680 42793856 13173920
20:51:20 3270 8192000000 10917597632 11338723328 1932098000 19.084 100 76 150 2 2002544448 46450688 23995760
20:51:30 1176 8192000000 10933505248 11347718144 1934002272 19.099 100 77 154 0 2007176256 47812640 25361344
20:51:38 6818 8192000000 10904306256 11336589312 1929493472 19.063 100 52 104 0 1992162032 45774336 16894224
20:51:51 19007 8192000000 10891336432 11332730880 1910205904 18.908 99 26 52 2 1963370896 43908736 9256256
20:52:16 10913 8192000000 10882501472 11326455808 1912045232 18.923 99 22 44 1 1955858960 36348608 7465120
20:52:46 16815 8192000000 10879610448 11321643008 1927874768 19.050 100 30 60 1 1969767424 32346176 9546480
20:53:21 38476 8192000000 10876596400 11320991744 1884759072 18.704 98 25 49 2 1927531856 34725616 8047168
20:54:19 19159 8192000000 10865938320 11326251008 1913532800 18.935 100 19 38 0 1962870544 43051312 6286432
20:54:45 30874 8192000000 10851807136 11315150848 1914578896 18.943 100 12 24 0 1948092896 29251072 4262928
20:55:32 66391 8192000000 10865736000 11305771008 1852723456 18.444 96 30 61 0 1872658320 11702416 8232448
20:56:54 71162 8192000000 10873576592 11311046656 1896818944 18.801 99 20 40 0 1919336560 17022816 5494800
20:58:29 33459 8192000000 10859808080 11310690304 1910106224 18.907 99 21 43 2 1934340640 17971792 6262624
20:59:09 184015 8192000000 10866317888 11331162112 1836857616 18.315 95 9 18 0 1857201984 18526576 1817792
21:02:19 46262 8192000000 10871062080 11324878848 1909467280 18.902 98 20 40 0 1928479168 13063120 5948768
21:03:14 32675 8192000000 10912918064 11342213120 1936481152 19.119 99 42 81 0 1958820800 10288640 12051008
21:04:00 51055 8192000000 10872619136 11336466432 1929477024 19.063 99 13 27 1 1946690464 13259440 3954000
21:04:57 107771 8192000000 10885529088 11336376320 1949754976 19.225 100 18 36 1 1971002128 15631232 5615920
21:06:56 52064 8192000000 10900661648 11348344832 1953903312 19.258 100 38 76 2 1973716544 8804688 11008544
21:07:57 19528 8192000000 10902319376 11361128448 1971378656 19.396 100 55 111 2 1997493264 8310304 17804304
21:08:27 155711 8192000000 10925221312 11381321728 1943532960 19.175 98 41 80 5 1970773568 16383072 10857536
21:11:11 28643 8192000000 10926247232 11387592704 1986263824 19.514 100 33 66 0 2016286368 20332784 9689760
21:11:53 45264 8192000000 10933424608 11391459328 1975600064 19.430 99 41 82 1 2009384752 20926512 12858176
21:13:29 56615 8192000000 10913010800 11403440128 1987693856 19.526 100 16 32 0 2019449824 26155856 5600112
21:14:35 41880 8192000000 10913052976 11395067904 1991393520 19.555 100 15 30 0 2007749792 12046384 4309888
21:15:30 50027 8192000000 10894186704 11360759808 1954623616 19.263 98 17 34 2 1968606864 9002208 4981040
21:16:27 78266 8192000000 10880184160 11357458432 1958387920 19.293 99 4 8 0 1968156896 8605840 1163136
21:18:17 60283 8192000000 10878954560 11361652736 1923736480 19.017 97 11 22 0 1937502992 9994880 3771632
21:19:27 35715 8192000000 10885447424 11353239552 1932065296 19.083 98 24 48 0 1946344400 7784256 6494848
21:20:18 57432 8192000000 10857065216 11326050304 1900603792 18.831 97 16 32 3 1915417568 9707232 5106544
21:21:22 28204 8192000000 10871316032 11335315456 1934198560 19.100 99 29 58 0 1950218560 8124000 7896000
21:21:56 24556 8192000000 10874230912 11334701056 1912855696 18.930 98 14 27 0 1923187696 6965728 3366272
21:22:35 33615 8192000000 10869255808 11336376320 1888831792 18.736 96 31 62 2 1911424384 13827696 8764896
21:23:20 68888 8192000000 10884876848 11355971584 1888275296 18.732 97 12 24 0 1908015056 16343280 3396480
21:24:35 141474 8192000000 10880465424 11349790720 1886422640 18.717 96 16 32 2 1915125680 24018256 4684784
21:27:06 53152 8192000000 10892432128 11359096832 1942550080 19.167 99 28 56 0 1961820896 11629408 7641408
21:28:05 62692 8192000000 10865599504 11340660736 1891658032 18.759 97 12 23 0 1908020368 13365856 2996480
21:29:19 60735 8192000000 10851516176 11324940288 1829012336 18.251 94 8 16 1 1840826432 9833280 1980816
21:30:26 72153 8192000000 10903778512 11354615808 1915121088 18.948 98 17 34 0 1927957392 8125264 4711040
21:31:49 43845 8192000000 10887751504 11353280512 1908410000 18.894 97 19 38 0 1928734896 14779312 5545584
21:32:39 78375 8192000000 10874436544 11355611136 1945444176 19.190 100 10 20 0 1962507600 14181056 2882368
21:34:10 66797 8192000000 10866161728 11327746048 1893349408 18.773 97 25 50 2 1908494480 8120880 7024192
21:35:25 58388 8192000000 10883242816 11333476352 1912602912 18.928 98 24 48 1 1929747904 10251056 6893936
21:36:32 48615 8192000000 10910547152 11359182848 1963057136 19.330 100 50 100 0 1994428352 17311968 14059248
21:37:34 28935 8192000000 10877088560 11352203264 1918528944 18.975 98 24 48 0 1936500224 11282848 6688432
21:38:18 24521 8192000000 10855484608 11326746624 1929806240 19.065 99 13 26 1 1941137008 7657856 3672912
21:38:49 31612 8192000000 10871308336 11336392704 1917415904 18.966 98 29 58 0 1936144720 10507840 8220976
21:39:31 75131 8192000000 10836545520 11297554432 1843895056 18.373 95 17 34 2 1856614880 7835776 4884048
21:41:10 43243 8192000000 10854012336 11317276672 1898441584 18.814 98 20 40 0 1917794784 12935568 6417632
21:42:53 84882 8192000000 10874146064 11337723904 1888307552 18.732 97 15 30 0 1909731600 16744016 4680032
21:45:14 71644 8192000000 10886715536 11360186368 1926053728 19.035 99 37 74 2 1960428256 22279392 12095136
21:46:43 130539 8192000000 10846530176 11325591552 1793998912 17.965 93 8 16 0 1814861648 18643600 2219136
21:49:00 40260 8192000000 10875086224 11332108288 1935573024 19.111 100 24 48 1 1953153648 10687168 6893456
21:49:55 31268 8192000000 10895397056 11329441792 1883324096 18.692 97 34 68 2 1906358976 13596768 9438112
21:50:34 67732 8192000000 10865194640 11329495040 1902582736 18.847 98 31 62 0 1922406416 11475024 8348656
21:51:47 33675 8192000000 10868243920 11327705088 1902148528 18.844 98 33 66 1 1923011568 11465200 9397840
21:52:58 46367 8192000000 10881925920 11329277952 1864727376 18.542 96 33 66 0 1883623312 9789568 9106368
21:54:07 31654 8192000000 10891117200 11346534400 1938972960 19.139 100 47 94 0 1971512752 19990816 12548976
21:54:53 92425 8192000000 10900198976 11359477760 1945635424 19.192 100 16 33 1 1962740832 12975984 4129424
21:57:39 99225 8192000000 10895519072 11369996288 1965277808 19.348 100 16 32 1 1985011664 15564992 4168864
21:59:50 56906 8192000000 10904198432 11359092736 1933760592 19.097 98 29 58 0 1949273808 7590528 7922688
22:00:54 27346 8192000000 10903705264 11368140800 1972067392 19.402 100 29 58 0 1989653984 9622832 7963760
22:01:33 67565 8192000000 10872382464 11347791872 1917899232 18.970 97 8 16 1 1931058304 11299056 1860016
22:02:52 43493 8192000000 10880118272 11367301120 1957970752 19.290 100 6 12 0 1976191504 16639648 1581104
22:03:44 6690 8192000000 10880653232 11372429312 1959332064 19.301 100 2 4 0 1972590480 13133792 124624
22:03:57 28183 8192000000 10854812736 11328897024 1904027920 18.859 97 16 32 1 1918620480 10287152 4305408
22:04:40 73802 8192000000 10906185696 11378642944 1951804512 19.241 99 20 40 1 1971680864 14125968 5750384
22:06:00 58351 8192000000 10901789248 11367505920 1938006976 19.131 98 29 58 1 1960665568 13802080 8856512
22:07:05 59945 8192000000 10885741152 11366580224 1921941952 19.002 98 12 24 0 1940012848 14506352 3564544
22:08:19 73656 8192000000 10879216080 11348615168 1885332752 18.708 96 19 38 0 1899717440 9488688 4896000
22:09:41 69048 8192000000 10889648832 11363848192 1943867264 19.178 99 20 40 1 1961405440 12024704 5513472
22:11:01 74254 8192000000 10904984624 11361714176 1951720192 19.240 99 23 46 1 1966563712 8708736 6134784
22:12:21 51204 8192000000 10925155616 11389202432 1971543104 19.398 100 37 73 2 1994270656 13216784 9510768
22:13:19 63090 8192000000 10907789760 11398660096 1957429824 19.286 99 23 46 2 1988670672 24708016 6532832
22:14:29 26914 8192000000 10928139904 11393445888 1968770400 19.376 100 10 18 0 1991493328 20180432 2542496
22:15:06 75277 8192000000 10891679120 11372040192 1918386240 18.974 97 9 18 0 1935725552 14093088 3246224
22:16:27 136842 8192000000 10876320528 11356856320 1848179328 18.407 94 11 22 1 1870148256 19231696 2737232
22:19:00 88929 8192000000 10856862048 11303526400 1845965952 18.389 95 30 59 0 1864088560 10349360 7773248
22:20:35 61641 8192000000 10850728816 11324305408 1897089344 18.803 98 25 50 1 1918549232 14432160 7027728
22:21:47 74497 8192000000 10844176576 11315965952 1894989920 18.786 98 18 36 2 1916111712 15656432 5465360
22:23:09 82525 8192000000 10862133920 11329994752 1900217376 18.828 98 22 44 2 1922754208 15930048 6606784
22:24:38 92928 8192000000 10852459152 11329368064 1883558912 18.694 97 18 36 0 1904538352 15335632 5643808
22:26:17 68788 8192000000 10434987248 10929213440 1471786032 15.229 76 18 34 2 1485497968 8700848 5011088

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 26-03-2021 22:29:18 to 26-03-2021 22:29:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 180 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2021 22:29:49 to 26-03-2021 22:29:51.

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          240502
MON$OLDEST_ACTIVE               241112
MON$OLDEST_SNAPSHOT             241112
MON$NEXT_TRANSACTION            241112
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                       2038752
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 ---
:355: 
:356: mscs-test-161.budzdorov.ru    Fri Mar 26 22:27:37 2021
:357:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:358: 
:359: 
:360: mscs-test-161.budzdorov.ru    Fri Mar 26 22:27:38 2021
:361:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:362: 
--- end of diff output ---

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

26.03.21 22:29:52. 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-26 22:29:54 No severe PSQL-related problems occured
26.03.21 22:29:56. End of report.