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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17117892 kB
MemAvailable 31448716 kB
Buffers 0 kB
Cached 14509604 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-28 22:27:26
DTS_END                         2021-03-28 22:27:26.7480
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39806
TRN_ID                          238401
ATT_ID                          647
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: 9787.03 18982 1174443
customer order: creation 173.76 349 20851
customer order: refuse 14.32 410 1718
order to supplier: creation 46.29 1391 5555
order to supplier: removal 3.58 101686 430
invoice (draft): creation 45.63 3071 5475
invoice (draft): removal 58.81 700 7057
invoice accept: apply 41.68 16925 5001
invoice accept: cancel 53.12 722 6374
customer reserve: creation 3848.76 167 461851
customer reserve: removal 5199.63 56 623956
realization accept: apply 82.22 161 9866
realization accept: cancel 91.41 99 10969
payment from customer: creation 58.59 116 7031
payment from customer: removal 6.06 60 727
payment to supplier: creation 48.58 122 5830
payment to supplier: removal 3.17 58 380
service: total inventory turnovers 4.53 1118 544
service: total monetary turnovers 6.02 24 722
service: aggregate perf. data 0.85 20450 102
service: refresh index statistics 0.03 231956 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-03-2021 22:27:56 to 28-03-2021 22:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1061
TEST_TIME 2 2152
TEST_TIME 3 3902
TEST_TIME 4 4429
TEST_TIME 5 4497
TEST_TIME 6 4528
TEST_TIME 7 5040
TEST_TIME 8 5605
TEST_TIME 9 5651
TEST_TIME 10 6386
TEST_TIME 11 6777
TEST_TIME 12 6893
TEST_TIME 13 6786
TEST_TIME 14 7462
TEST_TIME 15 7462
TEST_TIME 16 7655
TEST_TIME 17 8003
TEST_TIME 18 8040
TEST_TIME 19 8488
TEST_TIME 20 8548
TEST_TIME 21 8897
TEST_TIME 22 8970
TEST_TIME 23 9528
TEST_TIME 24 9719
TEST_TIME 25 9732
TEST_TIME 26 10156
TEST_TIME 27 10337
TEST_TIME 28 10746
TEST_TIME 29 10990
TEST_TIME 30 10908
TEST_TIME 31 10700
TEST_TIME 32 10766
TEST_TIME 33 10642
TEST_TIME 34 10563
TEST_TIME 35 10631
TEST_TIME 36 10634
TEST_TIME 37 10634
TEST_TIME 38 10535
TEST_TIME 39 10565
TEST_TIME 40 10720
TEST_TIME 41 10543
TEST_TIME 42 10379
TEST_TIME 43 10337
TEST_TIME 44 10291
TEST_TIME 45 10389
TEST_TIME 46 10201
TEST_TIME 47 10161
TEST_TIME 48 10076
TEST_TIME 49 10054
TEST_TIME 50 10036
TEST_TIME 51 10034
TEST_TIME 52 10156
TEST_TIME 53 10151
TEST_TIME 54 10041
TEST_TIME 55 10060
TEST_TIME 56 9991
TEST_TIME 57 10033
TEST_TIME 58 9975
TEST_TIME 59 9960
TEST_TIME 60 10061
TEST_TIME 61 10068
TEST_TIME 62 10169
TEST_TIME 63 10169
TEST_TIME 64 10108
TEST_TIME 65 10119
TEST_TIME 66 10170
TEST_TIME 67 10131
TEST_TIME 68 10108
TEST_TIME 69 10153
TEST_TIME 70 10184
TEST_TIME 71 10159
TEST_TIME 72 10035
TEST_TIME 73 9998
TEST_TIME 74 9912
TEST_TIME 75 9906
TEST_TIME 76 9873
TEST_TIME 77 9872
TEST_TIME 78 9837
TEST_TIME 79 9768
TEST_TIME 80 9768
TEST_TIME 81 9713
TEST_TIME 82 9733
TEST_TIME 83 9722
TEST_TIME 84 9684
TEST_TIME 85 9727
TEST_TIME 86 9753
TEST_TIME 87 9772
TEST_TIME 88 9736
TEST_TIME 89 9784
TEST_TIME 90 9871
TEST_TIME 91 9830
TEST_TIME 92 9867
TEST_TIME 93 9825
TEST_TIME 94 9969
TEST_TIME 95 9915
TEST_TIME 96 9955
TEST_TIME 97 9938
TEST_TIME 98 9893
TEST_TIME 99 9803
TEST_TIME 100 9847
TEST_TIME 101 9784
TEST_TIME 102 9765
TEST_TIME 103 9721
TEST_TIME 104 9713
TEST_TIME 105 9703
TEST_TIME 106 9734
TEST_TIME 107 9667
TEST_TIME 108 9675
TEST_TIME 109 9659
TEST_TIME 110 9663
TEST_TIME 111 9669
TEST_TIME 112 9679
TEST_TIME 113 9692
TEST_TIME 114 9752
TEST_TIME 115 9740
TEST_TIME 116 9793
TEST_TIME 117 9805
TEST_TIME 118 9805
TEST_TIME 119 9830
TEST_TIME 120 9787

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2021 22:28:00 to 28-03-2021 22:28:03.

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 1603308 1603308 0 0.00 0 40679 5 0 0
doc_list_biud 1603302 1603302 0 0.00 0 50297 27 0 0
sp_add_invoice_to_stock 5085 5001 84 1.65 34 220540 16926 0 84
sp_cancel_adding_invoice 6374 6374 0 0.00 5 59925 722 0 0
sp_cancel_client_order 1718 1718 0 0.00 4 16349 411 0 0
sp_cancel_customer_reserve 623956 623956 0 0.00 1 24751 56 0 0
sp_cancel_pay_from_customer 727 727 0 0.00 2 3875 61 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 3 4221 59 0 0
sp_cancel_supplier_invoice 7066 7057 9 0.12 2 30228 701 0 9
sp_cancel_supplier_order 430 430 0 0.00 7 814045 101686 0 0
sp_cancel_write_off 10969 10969 0 0.00 1 50380 100 0 0
sp_client_order 20851 20851 0 0.00 3 43908 349 0 0
sp_customer_reserve 461851 461851 0 0.00 0 56140 168 0 0
sp_fill_shopping_cart 31878 31878 0 0.00 1 24887 35 0 0
sp_fill_shopping_cart_clo_res 461851 461851 0 0.00 0 20579 12 0 0
sp_get_clo_for_invoice 5001 5001 0 0.00 0 22597 256 0 0
sp_kill_cost_storno 18450 18450 0 0.00 0 14134 51 0 0
sp_kill_qstorno_ret_qs2qd 1266368 1266368 0 0.00 0 50296 30 0 0
sp_kill_qty_storno 665366 665366 0 0.00 0 50297 65 0 0
sp_lock_selected_doc 20533 20533 0 0.00 0 8863 6 0 0
sp_make_cost_storno 27728 27728 0 0.00 0 36018 56 0 0
sp_multiply_rows_for_pdistr 27722 27722 0 0.00 0 10608 27 0 0
sp_multiply_rows_for_qdistr 20851 20851 0 0.00 0 22778 158 0 0
sp_pay_from_customer 7031 7031 0 0.00 4 23708 116 0 0
sp_pay_to_supplier 5830 5830 0 0.00 5 13151 123 0 0
sp_payment_common 12860 12860 0 0.00 1 17400 31 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 16341 372 0 0
sp_qd_handle_on_invoice_upd_sts 11371 11371 0 0.00 0 17631 316 0 0
sp_qd_handle_on_reserve_upd_sts 9865 9865 0 0.00 0 15806 53 0 0
sp_reserve_write_off 9866 9866 0 0.00 6 15885 162 0 0
sp_supplier_invoice 5475 5475 0 0.00 8 82739 3072 0 0
sp_supplier_order 5555 5555 0 0.00 5 39700 1391 0 0
srv_aggregate_perf_data 102 102 0 0.00 2608 252812 20451 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1079 118331 33091 0 0
srv_find_qd_qs_mism 1127352 1127352 0 0.00 0 40678 4 0 0
srv_make_invnt_saldo 544 544 0 0.00 21 36455 1119 0 0
srv_make_money_saldo 722 722 0 0.00 1 1213 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 193022 257202 231956 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5001 5001 0 0.00 0 23397 152 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 8409 146 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 2265 13 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 12324 39 0 0
t$perf-norm:sp_cancel_pay_from_customer 727 727 0 0.00 0 2817 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 813 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 988 10 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 28265 1762 0 0
t$perf-norm:sp_cancel_write_off 974 974 0 0.00 0 1088 7 0 0
t$perf-norm:sp_client_order 20851 20851 0 0.00 0 14248 21 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 14471 24 0 0
t$perf-norm:sp_pay_from_customer 7031 7031 0 0.00 0 5999 14 0 0
t$perf-norm:sp_pay_to_supplier 5830 5830 0 0.00 0 4762 11 0 0
t$perf-norm:sp_reserve_write_off 9866 9866 0 0.00 0 35087 16 0 0
t$perf-norm:sp_supplier_invoice 5475 5475 0 0.00 0 8336 22 0 0
t$perf-norm:sp_supplier_order 5555 5555 0 0.00 0 9469 19 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 929 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 550 8 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 1032 22 0 0
t$perf-norm:srv_make_money_saldo 722 722 0 0.00 0 1847 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 24 9 0 0
v_add_invoice_to_stock 10162 9994 168 1.65 0 7489 18 0 168
v_all_customers 37820 37820 0 0.00 0 16 1 0 0
v_all_suppliers 30734 30734 0 0.00 0 84 1 0 0
v_all_wares 41702 41702 0 0.00 0 51 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 670 7 0 0
v_cancel_client_order 3436 3436 0 0.00 0 5447 6 0 0
v_cancel_customer_prepayment 1454 1454 0 0.00 0 442 3 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 619 3 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 378 3 0 0
v_cancel_supplier_invoice 780 762 18 2.30 0 426 12 0 18
v_cancel_supplier_order 860 860 0 0.00 0 1803 7 0 0
v_cancel_write_off 1948 1948 0 0.00 0 7400 21 0 0
v_max_id_clo_ord 5553 5553 0 0.00 0 2810 2 0 0
v_max_id_clo_res 997 997 0 0.00 0 2506 19 0 0
v_max_id_ord_sup 5474 5474 0 0.00 0 3619 3 0 0
v_max_non_paid_invoice 1487 1487 0 0.00 0 859 3 0 0
v_max_non_paid_realizn 3742 3742 0 0.00 0 1035 3 0 0
v_min_id_clo_ord 5553 5553 0 0.00 0 3704 7 0 0
v_min_id_clo_res 997 997 0 0.00 0 7992 21 0 0
v_min_id_ord_sup 5474 5474 0 0.00 0 7074 16 0 0
v_min_non_paid_invoice 5829 5829 0 0.00 0 7140 12 0 0
v_min_non_paid_realizn 7031 7031 0 0.00 0 13160 19 0 0
v_our_firm 10460 10460 0 0.00 0 16 1 0 0
v_reserve_write_off 19730 19730 0 0.00 0 4470 5 0 0
x_lock_depdocs_on_canc_invoice 13050 13050 0 0.00 0 19192 100 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 5136 293 0 0
x_make_qstorno_1000_1200 5555 5555 0 0.00 1 39689 1315 0 0
x_make_qstorno_1200_2000 5475 5475 0 0.00 4 82622 2948 0 0
x_make_qstorno_2100_3300 461851 461851 0 0.00 0 56115 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2021 22:28:04 to 28-03-2021 22:28:08.

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:30 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:36 8926 8192000000 10174571904 10471227392 844494080 9.345 67 52 101 0 863632704 2296640 16841984
19:57:54 26717 8192000000 10316840144 10632314880 1352070224 14.166 100 79 158 0 1382400656 4303392 26027040
19:58:33 25582 8192000000 10355093648 10673950720 1409402896 14.679 100 96 193 0 1447761824 5925808 32433120
19:59:11 33444 8192000000 10396528704 10721468416 1447128080 15.013 100 90 180 0 1483248416 6669296 29451040
19:59:58 17476 8192000000 10424523248 10752638976 1476394752 15.270 100 89 178 0 1512614272 7661280 28558240
20:00:23 15245 8192000000 10441256864 10772058112 1491213328 15.399 100 86 172 1 1526865984 8281040 27371616
20:00:53 20393 8192000000 10467603264 10803933184 1510702080 15.569 100 82 164 0 1545383968 8788512 25893376
20:01:23 9473 8192000000 10476535072 10819641344 1533287520 15.765 100 76 152 1 1566137584 9130784 23719280
20:01:41 21682 8192000000 10518528624 10866585600 1566463072 16.052 100 80 160 1 1600224656 9410256 24351328
20:02:12 12268 8192000000 10540126864 10891952128 1597377232 16.317 100 78 156 0 1630582128 9954640 23250256
20:02:32 5272 8192000000 10563635328 10919165952 1624628560 16.549 100 86 172 2 1661643696 10858400 26156736
20:02:49 5715 8192000000 10576091408 10933370880 1636392896 16.649 100 84 168 0 1673331184 11553792 25384496
20:03:03 12311 8192000000 10593915504 10955210752 1643358544 16.708 100 75 150 0 1677447040 11767536 22320960
20:03:22 9045 8192000000 10609328048 10971275264 1668622384 16.922 100 82 163 1 1705385488 12772656 23990448
20:03:38 10435 8192000000 10629848080 10996084736 1683262480 17.045 100 82 164 1 1720777488 12573664 24941344
20:03:58 7971 8192000000 10644468624 11012009984 1700641600 17.190 100 78 156 0 1735211968 11975776 22594592
20:04:15 7036 8192000000 10655728272 11026620416 1716090016 17.320 100 86 172 1 1752821728 11670208 25061504
20:04:30 7258 8192000000 10677843088 11047165952 1730302064 17.438 100 83 166 0 1766615312 13140640 23172608
20:04:44 7100 8192000000 10689710752 11061649408 1745249600 17.562 100 92 184 1 1785473856 14332544 25891712
20:05:00 6974 8192000000 10691738752 11068452864 1749449472 17.597 100 88 176 0 1789517632 14672880 25395280
20:05:14 5299 8192000000 10690595472 11075207168 1757506848 17.664 100 78 156 0 1794151968 14317808 22327312
20:05:25 5222 8192000000 10711121472 11088523264 1771588400 17.780 100 81 161 0 1807885888 13112912 23184576
20:05:37 4338 8192000000 10716611104 11097313280 1778574048 17.838 100 86 171 1 1817659856 14323600 24762208
20:05:49 5738 8192000000 10728134928 11112194048 1787196176 17.909 100 85 170 2 1824696976 14069440 23431360
20:06:01 3686 8192000000 10737061520 11118551040 1793401296 17.960 100 89 177 2 1832597872 13909856 25286720
20:06:13 3932 8192000000 10733700096 11116531712 1801573424 18.027 100 88 175 1 1839334976 12512560 25248992
20:06:24 4174 8192000000 10740305664 11129651200 1806734736 18.069 100 72 141 2 1838067552 11466096 19866720
20:06:35 5225 8192000000 10740660688 11135545344 1810221616 18.098 100 62 123 1 1839618560 12008224 17388720
20:06:48 2825 8192000000 10770623392 11158863872 1828327968 18.246 100 85 169 0 1864773296 12033808 24411520
20:06:58 2549 8192000000 10778278576 11162001408 1835873984 18.307 100 89 179 2 1874905936 13581200 25450752
20:07:07 2213 8192000000 10789647184 11176136704 1844139376 18.374 100 89 179 3 1881489840 13206624 24143840
20:07:15 2272 8192000000 10787538672 11177181184 1848181120 18.407 100 85 170 1 1886029840 14220432 23628288
20:07:24 2096 8192000000 10797504944 11180572672 1852473520 18.442 100 91 181 2 1891556992 13487344 25596128
20:07:32 1788 8192000000 10797692848 11183865856 1856748256 18.477 100 93 188 2 1894977776 12326864 25902656
20:07:41 1992 8192000000 10800342016 11188068352 1860551136 18.508 100 94 187 0 1900587808 13013968 27022704
20:07:49 1125 8192000000 10808782256 11195219968 1862324784 18.522 100 93 187 0 1900869424 12994784 25549856
20:07:56 1323 8192000000 10815860496 11201572864 1866114128 18.553 100 97 192 1 1907901776 14870592 26917056
20:08:05 1451 8192000000 10812214240 11200675840 1868974144 18.576 100 90 177 0 1907560784 13270320 25316320
20:08:12 1479 8192000000 10810008576 11198169088 1868484352 18.572 100 91 182 0 1907920848 12447008 26989488
20:08:23 1559 8192000000 10811381936 11201093632 1869605648 18.581 100 94 189 2 1908501872 11838080 27058144
20:08:31 1534 8192000000 10814715040 11205627904 1871361440 18.595 100 92 184 0 1911530368 13293056 26875872
20:08:39 2182 8192000000 10816552464 11208081408 1873713728 18.614 100 95 190 3 1914852400 14086576 27052096
20:08:48 1245 8192000000 10811187456 11204857856 1873363664 18.611 100 87 175 1 1911278768 12779968 25135136
20:08:56 47859 8192000000 10814661376 11209519104 1873775008 18.615 100 63 124 2 1901178064 9275312 18127744
20:09:50 2039 8192000000 10824389728 11221225472 1881412080 18.677 100 91 180 1 1917628608 10883200 25333328
20:09:58 4073 8192000000 10814818224 11214110720 1872678224 18.606 100 50 98 1 1897029264 10464272 13886768
20:10:09 10317 8192000000 10790232912 11215953920 1874732688 18.623 100 32 63 1 1891519296 7826752 8959856
20:10:29 6039 8192000000 10791312448 11215282176 1876759024 18.639 100 35 70 0 1894078624 7437600 9882000
20:10:44 3909 8192000000 10799653008 11224350720 1881553120 18.678 100 32 62 3 1898482400 8330016 8599264
20:10:54 10498 8192000000 10805852416 11231895552 1883813136 18.696 100 21 43 1 1899975680 10706064 5456480
20:11:11 9242 8192000000 10801888368 11232321536 1886482752 18.717 100 26 52 1 1904300192 10512368 7305072
20:11:33 12202 8192000000 10806724064 11234078720 1890293216 18.748 100 23 45 3 1902389472 5998480 6097776
20:11:51 10263 8192000000 10802799152 11237654528 1895764224 18.792 100 26 52 1 1910275360 7507440 7003696
20:12:09 13892 8192000000 10793145680 11232747520 1892560624 18.766 100 18 36 1 1903233312 5695664 4977024
20:12:29 11935 8192000000 10813655824 11241406464 1894863920 18.785 100 30 60 0 1909851392 6383584 8603888
20:12:48 18160 8192000000 10805440944 11240316928 1897434480 18.806 100 32 64 1 1914915504 8359168 9121856
20:13:46 24487 8192000000 10817784288 11248283648 1901570032 18.839 100 27 54 2 1915888656 6593648 7724976
20:14:17 5252 8192000000 10813049968 11253350400 1908409616 18.894 100 31 62 3 1923953760 6790784 8753360
20:14:29 4968 8192000000 10824238720 11256287232 1905132320 18.868 100 24 49 1 1918137408 6169552 6835536
20:14:40 2858 8192000000 10830077424 11260518400 1908371632 18.894 100 31 62 0 1922921824 6435344 8114848
20:14:49 7004 8192000000 10823812352 11258232832 1905941008 18.874 100 26 51 1 1919639152 6429872 7268272
20:15:03 6285 8192000000 10816090864 11252768768 1904545872 18.863 100 17 33 3 1915381840 5831488 5004480
20:15:16 5072 8192000000 10824970416 11259772928 1912268688 18.925 100 33 64 3 1928764144 6869088 9626368
20:15:30 8310 8192000000 10812274832 11251830784 1888961792 18.737 99 24 48 1 1901840400 6053024 6825584
20:15:45 7510 8192000000 10823947904 11255119872 1900079984 18.827 100 12 24 1 1907822160 4623968 3118208
20:16:01 5242 8192000000 10827126064 11254419456 1892848624 18.769 99 34 67 1 1908506832 5290496 10367712
20:16:13 8775 8192000000 10821467904 11257233408 1904657360 18.864 100 24 48 3 1916717104 4955536 7104208
20:16:29 13348 8192000000 10815257360 11249434624 1867221040 18.562 98 11 22 0 1875196112 4819680 3155392
20:16:51 12206 8192000000 10797106640 11229638656 1864173312 18.537 98 23 45 3 1876662656 5306016 7183328
20:17:10 11157 8192000000 10788057888 11220463616 1831306016 18.270 97 21 40 3 1842816624 6094416 5416192
20:17:28 59744 8192000000 10788420720 11210223616 1809066768 18.088 96 25 49 1 1821395312 5006640 7321904
20:18:35 19904 8192000000 10752553248 11190169600 1822398976 18.197 97 11 22 0 1830451232 5003680 3048576
20:19:01 10175 8192000000 10742397312 11155939328 1717818128 17.334 93 25 48 1 1729685840 4969840 6897872
20:19:19 3749 8192000000 10757645184 11175817216 1818158848 18.163 99 22 45 2 1830842912 6514096 6169968
20:19:30 4866 8192000000 10737370144 11160211456 1785431936 17.894 97 27 54 0 1800544064 6970432 8141696
20:19:44 7071 8192000000 10689632048 11103395840 1749576080 17.598 97 27 54 2 1762745552 4698592 8470880
20:19:58 6686 8192000000 10696749440 11101634560 1727309376 17.413 96 28 52 2 1740748432 5811008 7628048
20:20:12 4197 8192000000 10705810320 11107807232 1749306512 17.596 98 31 61 0 1763913792 5512416 9094864
20:20:24 8873 8192000000 10690444704 11107373056 1743528464 17.548 98 25 50 1 1757531632 6085712 7917456
20:20:42 7740 8192000000 10709262176 11127369728 1767746352 17.748 98 23 46 0 1780627760 6527680 6353728
20:20:56 9194 8192000000 10727416784 11148996608 1808314288 18.082 100 15 30 2 1817563408 4844928 4404192
20:21:12 6820 8192000000 10742983968 11157401600 1808470096 18.083 99 20 40 1 1819839952 6046400 5323456
20:21:28 7710 8192000000 10706282224 11128365056 1723561024 17.382 95 23 45 3 1735671232 5374448 6735760
20:21:42 7766 8192000000 10736694384 11148972032 1791998288 17.948 99 21 43 2 1803505392 4901856 6605248
20:22:00 5377 8192000000 10737416704 11159044096 1824036016 18.211 100 22 44 0 1835782720 5337264 6409440
20:22:12 7397 8192000000 10743847504 11164880896 1825671392 18.224 100 21 41 2 1836194016 5028912 5493712
20:22:29 60465 8192000000 10750827840 11160580096 1796084624 17.982 98 27 54 1 1809054384 4911792 8057968
20:23:38 21184 8192000000 10740768832 11169210368 1799688192 18.011 98 28 56 1 1812808320 5855824 7264304
20:24:06 8137 8192000000 10758650384 11177238528 1822023680 18.194 99 24 48 2 1834478496 5533136 6921680
20:24:23 3474 8192000000 10774601200 11192336384 1844719920 18.379 100 39 78 1 1868403488 12840064 10843504
20:24:32 5710 8192000000 10747487872 11181842432 1845462848 18.385 100 30 60 4 1860243312 5808624 8971840
20:24:46 5517 8192000000 10762654448 11190259712 1829669408 18.257 99 30 60 0 1845790944 8019472 8102064
20:24:58 6144 8192000000 10777545088 11196407808 1852014256 18.438 100 38 75 0 1869065056 6718224 10332576
20:25:10 7503 8192000000 10763975968 11188236288 1849173728 18.415 100 30 60 2 1864659088 6828784 8656576
20:25:24 12089 8192000000 10771472704 11198713856 1854932672 18.462 100 27 54 0 1869475248 6762736 7779840
20:25:45 7723 8192000000 10786557264 11200421888 1862613008 18.524 100 41 80 6 1879916448 4579664 12723776
20:26:04 7177 8192000000 10778932112 11207675904 1862833248 18.526 100 38 76 1 1880353120 5679424 11840448
20:26:20 9384 8192000000 10781362848 11208650752 1864951184 18.543 100 31 62 3 1880020656 5297792 9771680
20:26:37 13716 8192000000 10782180432 11208933376 1870843648 18.591 100 39 78 0 1892500288 10458848 11197792
20:27:02 86028 8192000000 10808765088 11235848192 1881261488 18.675 100 10 20 0 1888199456 4829504 2108464
20:28:46 8290 8192000000 10844309936 11261095936 1907186800 18.884 100 54 108 2 1932906736 9547888 16172048
20:29:09 6069 8192000000 10851332144 11269677056 1915614432 18.952 100 54 106 1 1942264960 11059792 15590736
20:29:23 26064 8192000000 10864174256 11282345984 1922558032 19.007 100 59 117 1 1951661664 12665280 16438352
20:30:00 20655 8192000000 10860917872 11287093248 1928628144 19.056 100 51 101 0 1955505568 12946032 13931392
20:30:29 14335 8192000000 10865678560 11292962816 1933148176 19.092 100 46 91 2 1959418496 12958576 13311744
20:30:51 56419 8192000000 10880847920 11314638848 1941086672 19.155 100 49 99 2 1968476400 12474384 14915344
20:32:22 13200 8192000000 10877107616 11323260928 1950065984 19.227 100 32 64 3 1974287824 14862128 9359712
20:32:54 26755 8192000000 10908530304 11336101888 1959727296 19.304 100 39 77 2 1985907392 14803632 11376464
20:33:32 13556 8192000000 10901750640 11334656000 1946361200 19.197 99 47 94 1 1977175328 17003504 13810624
20:33:55 5804 8192000000 10907501680 11335716864 1969892160 19.385 100 59 116 1 2005978288 18658576 17427552
20:34:14 8194 8192000000 10920164976 11349073920 1972179040 19.403 100 48 95 1 2007011600 20144768 14687792
20:34:29 5182 8192000000 10927688800 11355541504 1978888656 19.456 100 55 110 1 2016447936 20834912 16724368
20:34:41 7719 8192000000 10930425408 11355164672 1978788864 19.455 100 55 108 3 2013191216 18486624 15915728
20:34:56 6517 8192000000 10930276192 11360526336 1982288384 19.483 100 59 118 1 2020093968 20474736 17330848
20:35:15 8666 8192000000 10931351424 11364929536 1985731168 19.510 100 56 113 0 2023542544 20752928 17058448
20:35:33 10375 8192000000 10935687648 11368341504 1991346944 19.554 100 42 82 1 2028290832 24713696 12230192
20:35:51 3253 8192000000 10940887808 11368337408 1993358640 19.570 100 67 127 3 2032358624 19847168 19152816
20:36:04 3121 8192000000 10968470544 11382636544 2001266192 19.633 100 86 172 3 2048737440 22442688 25028560
20:36:14 4539 8192000000 10957780992 11384844288 2002884432 19.645 100 77 155 3 2049764080 24100960 22778688
20:36:27 2851 8192000000 10964374336 11391455232 2008031936 19.686 100 68 135 0 2052246432 24805184 19409312
20:36:37 1814 8192000000 10977362480 11392147456 2009747184 19.700 100 79 157 2 2058429632 26296160 22386288
20:36:47 2659 8192000000 10970251808 11399110656 2012289152 19.720 100 75 149 1 2060979008 26776192 21913664
20:37:06 8236 8192000000 10954271920 11395006464 1992358960 19.562 99 51 101 0 2034096080 26396464 15340656
20:37:23 2013 8192000000 10977026048 11397013504 2011019728 19.710 100 73 144 2 2057203904 24392128 21792048
20:37:32 1677 8192000000 10979972512 11400957952 2011493040 19.713 100 64 126 0 2055524576 24943296 19088240
20:37:42 4063 8192000000 10976833536 11400388608 2014261824 19.735 100 79 158 0 2063854896 25327840 24265232
20:37:54 5041 8192000000 10983127616 11410309120 2021653584 19.793 100 78 153 3 2070679104 25469472 23556048
20:38:07 6895 8192000000 10958490656 11385192448 1993191584 19.569 99 65 130 1 2039063008 26226752 19644672
20:38:24 3463 8192000000 10947852688 11364401152 1950185552 19.228 98 79 157 5 2000266960 26841952 23239456
20:38:35 7369 8192000000 10944661776 11370086400 1972445936 19.405 99 64 129 0 2019187520 27377456 19364128
20:38:50 1077 8192000000 10971557904 11385008128 1998185360 19.608 100 83 166 3 2051879968 27377024 26317584
20:38:59 3457 8192000000 10942921760 11364130816 1977617664 19.446 100 73 142 1 2027694896 28121904 21955328
20:39:11 2618 8192000000 10942966016 11356868608 1968015328 19.370 99 74 145 0 2021997536 31619504 22362704
20:39:21 5343 8192000000 10961771408 11376226304 1984930832 19.504 100 72 142 1 2038614816 31681648 22002336
20:39:33 4096 8192000000 10949214032 11376074752 1982958976 19.488 100 75 147 1 2036786912 30982176 22845760
20:39:46 4121 8192000000 10951250528 11377631232 1985968272 19.512 100 65 130 0 2036503776 30740224 19795280
20:39:59 10125 8192000000 10965440512 11387899904 1996179120 19.593 100 70 140 0 2049985424 33139584 20666720
20:40:23 7656 8192000000 10957764352 11383209984 1978118080 19.450 99 65 130 1 2031357312 33156960 20082272
20:40:38 6743 8192000000 10976031424 11402649600 1996463152 19.595 100 69 138 2 2053370080 36205552 20701376
20:40:53 6484 8192000000 10964833568 11386646528 1973278288 19.411 99 77 152 0 2035267552 38480464 23508800
20:41:13 4001 8192000000 10965763424 11385810944 1981888544 19.480 100 80 160 0 2047036480 40372544 24775392
20:41:26 1828 8192000000 10967951664 11385540608 1983718880 19.494 100 75 150 1 2047500464 40021952 23759632
20:41:37 6705 8192000000 10957060512 11390746624 1993575024 19.572 100 71 142 1 2048256896 32594880 22086992
20:42:00 5829 8192000000 10945424208 11373486080 1981408224 19.476 100 64 129 0 2031087872 30112752 19566896
20:42:14 16393 8192000000 10947771984 11379335168 1969474144 19.381 99 60 120 0 2021366864 33309168 18583552
20:42:41 6170 8192000000 10946107040 11371937792 1960849072 19.313 99 63 124 2 2015631248 35319792 19462384
20:42:55 5052 8192000000 10944716192 11371958272 1973464352 19.413 100 59 118 1 2028489680 36341008 18684320
20:43:10 3106 8192000000 10946941264 11367424000 1957014816 19.282 99 80 160 1 2018052752 36304160 24733776
20:43:22 4427 8192000000 10935639152 11354451968 1946117840 19.196 99 75 151 3 2007887472 38620624 23149008
20:43:39 2637 8192000000 10962211248 11379003392 1976235552 19.435 100 80 158 1 2041418432 40455600 24727280
20:43:49 1577 8192000000 10967576384 11378139136 1979981824 19.465 100 90 180 1 2051096288 42359744 28754720
20:44:02 14655 8192000000 10955375488 11386904576 1977871856 19.448 100 41 82 0 2033841152 42273632 13695664
20:44:27 5757 8192000000 10961328608 11387224064 1961390112 19.317 99 62 121 1 2025325536 44696112 19239312
20:44:41 6464 8192000000 10941721184 11369422848 1963931328 19.337 100 55 110 1 2025203856 42833184 18439344
20:44:54 4919 8192000000 10942915040 11369414656 1964097392 19.339 100 56 108 2 2026759392 44744784 17917216
20:45:05 4119 8192000000 10951961520 11375886336 1969369008 19.380 100 57 112 2 2032138336 44376192 18393136
20:45:16 7526 8192000000 10924462192 11347652608 1915340768 18.949 97 50 98 2 1972768304 41631472 15796064
20:45:33 4401 8192000000 10951452960 11372457984 1970863856 19.392 100 76 152 0 2039974272 44402480 24707936
20:45:46 4389 8192000000 10963454288 11379187712 1959244656 19.300 99 85 169 1 2032041872 45618976 27178240
20:45:58 4208 8192000000 10970902144 11388948480 1979702608 19.462 100 81 160 2 2053386640 48303808 25380224
20:46:11 3519 8192000000 10981230032 11397828608 1988732032 19.534 100 79 159 1 2057720448 44009776 24978640
20:46:23 2274 8192000000 10980667632 11391246336 1986959920 19.520 100 85 171 0 2059209472 45295264 26954288
20:46:32 4291 8192000000 10971321344 11395330048 1982543760 19.485 100 64 127 0 2047598128 44951552 20102816
20:46:54 8685 8192000000 10956120384 11398770688 1986586672 19.517 100 54 106 0 2047882192 43480448 17815072
20:47:18 18171 8192000000 10962710880 11409170432 1987894512 19.527 100 39 78 0 2044505984 42993632 13617840
20:47:43 13929 8192000000 10955713120 11399217152 1982364784 19.483 100 39 77 1 2041284160 45783984 13135392
20:48:17 8188 8192000000 10955937568 11392155648 1977081744 19.442 100 47 92 1 2036081600 43489840 15510016
20:48:37 4995 8192000000 10957737776 11395510272 1979889200 19.464 100 65 130 0 2049724704 48847984 20987520
20:48:58 12197 8192000000 10939044992 11378499584 1963595968 19.335 100 47 93 3 2025256736 45711248 15949520
20:49:18 10764 8192000000 10908811904 11347046400 1881316000 18.676 96 33 66 0 1937406256 44322704 11767552
20:49:40 3243 8192000000 10927254176 11349897216 1936864160 19.122 100 68 136 2 2003759632 45020896 21874576
20:49:49 8080 8192000000 10929722336 11371847680 1951271936 19.237 100 53 107 2 2019316240 50748736 17295568
20:50:08 12453 8192000000 10921957648 11373019136 1952412816 19.246 100 34 68 2 2010661168 46940720 11307632
20:50:33 16083 8192000000 10920005296 11375136768 1950294944 19.229 100 26 52 0 2002444848 43088960 9060944
20:51:12 19865 8192000000 10865758928 11307515904 1863997680 18.536 97 26 52 2 1917033200 44001584 9033936
20:51:46 43934 8192000000 10868061632 11318308864 1892428608 18.765 99 27 53 0 1939538032 37726560 9382864
20:52:41 21110 8192000000 10864578096 11312590848 1901138080 18.835 100 24 48 1 1950637168 41219408 8279680
20:53:12 23467 8192000000 10883367360 11331182592 1908469600 18.894 100 25 50 2 1961599520 44371392 8758528
20:54:16 19412 8192000000 10868229504 11326062592 1915636400 18.952 100 24 49 1 1952825824 29282320 7907104
20:54:42 34951 8192000000 10871014016 11336134656 1919172688 18.980 100 15 29 1 1955567088 31067904 5326496
20:55:27 16010 8192000000 10853783472 11324686336 1911665376 18.920 100 11 22 0 1938743072 22342416 4735280
20:55:50 44119 8192000000 10831515872 11304157184 1870540512 18.589 98 5 10 0 1894186064 21775312 1870240
20:56:41 77290 8192000000 10857622592 11315732480 1890225840 18.748 98 7 14 0 1904201888 12271072 1704976
20:58:07 113884 8192000000 10887742512 11362013184 1944149072 19.180 100 25 50 0 1961762896 11346400 6267424
21:00:11 59640 8192000000 10887612208 11342852096 1934669456 19.104 99 4 9 0 1945651264 10246208 735600
21:01:23 48717 8192000000 10896293616 11358941184 1956130560 19.275 100 11 22 1 1969102352 9978832 2992960
21:02:31 115139 8192000000 10906574368 11369222144 1903632960 18.856 97 11 22 1 1927138016 20353248 3151808
21:04:33 94267 8192000000 10900167104 11360669696 1910428608 18.910 97 5 10 1 1922868016 11046752 1392656
21:07:02 78530 8192000000 10901483104 11367075840 1945713200 19.192 99 10 19 0 1964140704 15710000 2717504
21:08:27 99595 8192000000 10854839840 11303870464 1857926192 18.486 94 38 76 0 1879364000 10007232 11430576
21:10:21 38989 8192000000 10888444128 11349164032 1946455024 19.198 100 41 83 1 1970965424 11769024 12741376
21:11:10 25597 8192000000 10907406880 11342520320 1942511696 19.167 99 59 111 1 1965885344 6776752 16596896
21:11:42 23918 8192000000 10922688576 11367149568 1969213216 19.379 100 43 84 4 1992944768 11891968 11839584
21:14:18 4395 8192000000 10915768880 11385131008 1966991296 19.362 99 25 50 2 1988379472 13716128 7672048
21:14:30 32907 8192000000 10925278384 11393290240 1982449792 19.484 100 23 46 0 2002592560 13615584 6527184
21:15:13 19579 8192000000 10944621776 11404181504 1994072368 19.576 100 28 55 0 2020155744 17740768 8342608
21:15:39 31312 8192000000 10946215696 11412684800 2004309312 19.657 100 35 67 3 2034911104 20328848 10272944
21:16:23 36025 8192000000 10934639552 11387904000 1968788832 19.376 98 37 74 1 2001490256 20777280 11924144
21:17:16 26386 8192000000 10959828832 11414683648 1998705152 19.613 100 57 115 2 2040934480 24648144 17581184
21:18:07 70427 8192000000 10938285184 11429838848 1988935376 19.535 100 14 28 0 2029165056 35115120 5114560
21:19:25 57988 8192000000 10930503424 11414548480 1990752448 19.550 100 10 20 1 2015292576 21788272 2751856
21:20:38 45782 8192000000 10919683824 11398909952 1969251552 19.380 99 12 24 1 1990669792 17795456 3622784
21:21:32 61133 8192000000 10912644464 11401277440 1985658496 19.509 100 7 14 2 2000360416 12809232 1892688
21:22:44 36738 8192000000 10914780480 11399974912 1988431344 19.531 100 9 18 0 1999892128 9216240 2244544
21:23:35 20834 8192000000 10912625056 11389984768 1956593568 19.279 98 15 30 2 1968753968 8194672 3965728
21:24:06 51827 8192000000 10884149632 11367661568 1921886672 19.002 97 18 36 0 1939977248 12573360 5517216
21:25:07 72155 8192000000 10909612320 11374997504 1937236576 19.125 98 20 42 0 1956640160 13605120 5798464
21:26:25 77776 8192000000 10878200336 11364184064 1861365392 18.514 94 21 42 1 1881422800 14092336 5965072
21:28:21 78387 8192000000 10881231120 11359653888 1885201680 18.707 96 13 26 0 1902199600 13683424 3314496
21:29:48 83232 8192000000 10886310704 11362021376 1904309520 18.861 97 10 20 1 1919125664 12263568 2552576
21:31:21 55306 8192000000 10908563632 11370876928 1900788208 18.833 96 33 66 0 1920845424 11154448 8902768
21:32:24 60912 8192000000 10899880304 11364499456 1919259952 18.981 98 20 40 0 1942385120 17536864 5588304
21:33:31 68793 8192000000 10892105280 11355430912 1906607504 18.879 97 23 47 0 1924614672 11042144 6965024
21:34:49 35532 8192000000 10885351216 11345690624 1917850768 18.970 98 36 72 0 1937389088 9712976 9825344
21:35:38 45475 8192000000 10881439344 11341688832 1893505744 18.774 97 33 66 3 1918315152 15217600 9591808
21:36:36 73600 8192000000 10887862864 11353481216 1863414368 18.531 96 25 51 0 1892009664 22398880 6196416
21:37:55 57199 8192000000 10866369024 11346231296 1915401488 18.950 99 14 29 1 1939764592 21102080 3261024
21:39:00 68019 8192000000 10860296192 11333099520 1917021344 18.963 99 12 24 0 1929980848 10021248 2938256
21:40:14 21763 8192000000 10839357952 11303219200 1857956160 18.487 96 13 26 1 1868532848 7281104 3295584
21:40:42 71158 8192000000 10857422144 11316432896 1891246800 18.756 98 24 47 0 1907349280 8866656 7235824
21:42:54 47881 8192000000 10857766000 11313328128 1896361312 18.797 99 52 104 1 1921020368 9667216 14991840
21:43:55 22511 8192000000 10856889680 11320889344 1929810960 19.065 100 36 72 2 1950165520 10822416 9532144
21:44:28 30018 8192000000 10861714704 11327721472 1927952480 19.051 100 32 63 3 1946951328 9764416 9234432
21:45:08 90424 8192000000 10858444736 11319087104 1864194896 18.537 96 19 38 1 1879432976 9500048 5738032
21:46:44 68987 8192000000 10844577584 11320487936 1894174608 18.779 98 19 38 0 1913013072 12894560 5943904
21:49:17 78762 8192000000 10847641408 11322458112 1876720544 18.639 97 19 38 1 1895037728 12908000 5409184
21:50:42 56864 8192000000 10850666000 11320717312 1849025616 18.414 96 21 42 1 1865676752 10803968 5847168
21:51:46 61737 8192000000 10861905024 11336589312 1911226128 18.916 99 20 40 2 1932569360 16277264 5065968
21:52:54 60835 8192000000 10860960720 11329433600 1897727248 18.808 98 22 45 0 1915516752 11437536 6351968
21:54:01 42959 8192000000 10866484640 11335208960 1892309616 18.764 98 13 27 1 1906008064 10105664 3592784
21:54:52 26671 8192000000 10881346624 11340746752 1905460656 18.870 98 28 56 0 1924675072 11279824 7934592
21:55:31 76506 8192000000 10885124464 11362705408 1929410064 19.062 99 21 40 1 1954948080 19833280 5704736
21:56:55 108758 8192000000 10903218288 11372748800 1918578752 18.975 98 12 24 1 1941354816 19479104 3296960
21:58:50 46607 8192000000 10886714928 11355365376 1916677952 18.960 97 23 46 2 1935181504 12066336 6437216
21:59:46 45450 8192000000 10900953680 11355017216 1938920240 19.138 99 30 56 2 1962046032 15320080 7805712
22:01:05 100532 8192000000 10907422144 11379392512 1952184352 19.244 99 14 28 2 1971218080 14823472 4210256
22:02:51 91842 8192000000 10907898496 11378667520 1912763040 18.929 97 13 26 0 1929696368 12701280 4232048
22:04:29 21293 8192000000 10887930400 11351924736 1922652848 19.008 98 22 44 0 1937640544 8461584 6526112
22:05:01 64809 8192000000 10889213744 11354951680 1954268704 19.260 100 23 46 1 1971428304 11024720 6134880
22:06:33 118330 8192000000 10888397632 11376500736 1935550656 19.111 98 25 50 2 1958902048 16650704 6700688
22:08:38 8165 8192000000 10897885088 11379245056 1963491440 19.334 100 19 38 0 1985220160 16366304 5362416
22:08:56 21576 8192000000 10907834912 11357069312 1944609088 19.184 99 21 42 0 1961324000 11000672 5714240
22:09:26 75502 8192000000 10896827328 11372797952 1929656128 19.064 98 20 40 1 1945938528 10442464 5839936
22:10:48 38481 8192000000 10889269536 11369791488 1942190544 19.164 99 7 14 0 1955829312 11603472 2035296
22:11:35 45170 8192000000 10860650800 11354423296 1917620928 18.968 98 15 30 0 1933938368 11911808 4405632
22:12:27 71164 8192000000 10865540480 11361304576 1936596704 19.120 99 16 31 0 1949519792 8818624 4104464
22:14:51 74914 8192000000 10871356752 11365474304 1902496064 18.846 97 14 28 0 1920184944 13499824 4189056
22:16:12 45345 8192000000 10881862496 11356774400 1908057264 18.891 98 9 18 1 1923675584 13059792 2558528
22:17:04 50517 8192000000 10873601760 11345141760 1918869488 18.978 98 35 70 1 1938222576 9111408 10241680
22:18:10 40139 8192000000 10861254272 11331604480 1898671520 18.816 98 29 58 2 1916691120 8923488 9096112
22:18:57 33366 8192000000 10876982928 11354599424 1925238736 19.029 99 31 62 2 1944192880 10169920 8784224
22:19:46 82655 8192000000 10886686480 11369865216 1923166080 19.012 98 17 34 2 1939666352 12062640 4437632
22:21:20 103465 8192000000 10882147680 11361968128 1881981232 18.681 96 8 16 0 1898180720 14190304 2009184
22:23:09 103134 8192000000 10878370992 11362193408 1900141120 18.827 97 14 28 1 1917159136 13272272 3745744
22:25:24 56851 8192000000 10861017616 11341914112 1894200720 18.780 97 18 36 1 1908855600 10114032 4540848
22:26:44 46257 8192000000 9017373936 9233092608 175729792 2.100 10 2 4 0 176906272 1027856 148624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-03-2021 22:28:10 to 28-03-2021 22:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 84 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-03-2021 22:28:42 to 28-03-2021 22:28:44.

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          238708
MON$OLDEST_ACTIVE               238709
MON$OLDEST_SNAPSHOT             238709
MON$NEXT_TRANSACTION            238709
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                       2053728
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
--- end of diff output ---

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

28.03.21 22:28:45. 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-28 22:28:47 No severe PSQL-related problems occured
28.03.21 22:28:49. End of report.