Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.01.2021 19: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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17251388 kB
MemAvailable 31460956 kB
Buffers 0 kB
Cached 14472544 kB
SwapCached 4864 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-01-01 19:27:10
DTS_END                         2021-01-01 19:27:10.9820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50888
TRN_ID                          234205
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: 9627.78 16971 1155333
customer order: creation 171.15 364 20538
customer order: refuse 14.89 385 1787
order to supplier: creation 45.28 1315 5433
order to supplier: removal 3.74 100513 449
invoice (draft): creation 45.54 3361 5465
invoice (draft): removal 57.74 735 6929
invoice accept: apply 41.47 18316 4976
invoice accept: cancel 51.79 681 6215
customer reserve: creation 3781.12 184 453734
customer reserve: removal 5113.27 58 613593
realization accept: apply 82.44 171 9893
realization accept: cancel 93.49 105 11219
payment from customer: creation 57.88 115 6946
payment from customer: removal 5.30 79 636
payment to supplier: creation 47.53 129 5703
payment to supplier: removal 3.33 97 399
service: total inventory turnovers 4.84 933 581
service: total monetary turnovers 6.05 28 726
service: aggregate perf. data 0.89 20463 107
service: refresh index statistics 0.03 191381 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-01-2021 19:29:03 to 01-01-2021 19:29:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6996
TEST_TIME 2 6163
TEST_TIME 3 5541
TEST_TIME 4 6276
TEST_TIME 5 5728
TEST_TIME 6 5950
TEST_TIME 7 6148
TEST_TIME 8 6379
TEST_TIME 9 6494
TEST_TIME 10 6444
TEST_TIME 11 6375
TEST_TIME 12 6219
TEST_TIME 13 6344
TEST_TIME 14 6543
TEST_TIME 15 6722
TEST_TIME 16 7187
TEST_TIME 17 7445
TEST_TIME 18 8163
TEST_TIME 19 8425
TEST_TIME 20 8828
TEST_TIME 21 8892
TEST_TIME 22 9512
TEST_TIME 23 9956
TEST_TIME 24 10032
TEST_TIME 25 9805
TEST_TIME 26 10097
TEST_TIME 27 10296
TEST_TIME 28 10349
TEST_TIME 29 10533
TEST_TIME 30 10999
TEST_TIME 31 11079
TEST_TIME 32 11028
TEST_TIME 33 10864
TEST_TIME 34 11003
TEST_TIME 35 10897
TEST_TIME 36 10736
TEST_TIME 37 10642
TEST_TIME 38 10444
TEST_TIME 39 10386
TEST_TIME 40 10380
TEST_TIME 41 10327
TEST_TIME 42 10255
TEST_TIME 43 10215
TEST_TIME 44 10099
TEST_TIME 45 10100
TEST_TIME 46 10249
TEST_TIME 47 10241
TEST_TIME 48 10210
TEST_TIME 49 10183
TEST_TIME 50 10111
TEST_TIME 51 9981
TEST_TIME 52 9894
TEST_TIME 53 9969
TEST_TIME 54 9854
TEST_TIME 55 9925
TEST_TIME 56 9892
TEST_TIME 57 9839
TEST_TIME 58 9772
TEST_TIME 59 9777
TEST_TIME 60 9735
TEST_TIME 61 9887
TEST_TIME 62 9934
TEST_TIME 63 9992
TEST_TIME 64 9978
TEST_TIME 65 9932
TEST_TIME 66 10046
TEST_TIME 67 10050
TEST_TIME 68 10048
TEST_TIME 69 10079
TEST_TIME 70 10077
TEST_TIME 71 10093
TEST_TIME 72 9990
TEST_TIME 73 9977
TEST_TIME 74 9934
TEST_TIME 75 9887
TEST_TIME 76 9850
TEST_TIME 77 9845
TEST_TIME 78 9801
TEST_TIME 79 9744
TEST_TIME 80 9712
TEST_TIME 81 9615
TEST_TIME 82 9640
TEST_TIME 83 9769
TEST_TIME 84 9743
TEST_TIME 85 9768
TEST_TIME 86 9765
TEST_TIME 87 9851
TEST_TIME 88 9806
TEST_TIME 89 9840
TEST_TIME 90 9827
TEST_TIME 91 9876
TEST_TIME 92 9872
TEST_TIME 93 9918
TEST_TIME 94 9928
TEST_TIME 95 9922
TEST_TIME 96 9869
TEST_TIME 97 9808
TEST_TIME 98 9803
TEST_TIME 99 9753
TEST_TIME 100 9778
TEST_TIME 101 9733
TEST_TIME 102 9695
TEST_TIME 103 9715
TEST_TIME 104 9640
TEST_TIME 105 9609
TEST_TIME 106 9628
TEST_TIME 107 9634
TEST_TIME 108 9670
TEST_TIME 109 9646
TEST_TIME 110 9642
TEST_TIME 111 9641
TEST_TIME 112 9673
TEST_TIME 113 9647
TEST_TIME 114 9739
TEST_TIME 115 9801
TEST_TIME 116 9764
TEST_TIME 117 9786
TEST_TIME 118 9762
TEST_TIME 119 9698
TEST_TIME 120 9630

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-01-2021 19:29:06 to 01-01-2021 19:29:09.

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 1578075 1578075 0 0.00 0 23989 6 0 0
doc_list_biud 1578071 1578071 0 0.00 0 77422 28 0 0
sp_add_invoice_to_stock 5133 4976 157 3.05 37 172354 18317 0 157
sp_cancel_adding_invoice 6215 6215 0 0.00 5 67201 681 0 0
sp_cancel_client_order 1787 1787 0 0.00 4 10984 385 0 0
sp_cancel_customer_reserve 613593 613593 0 0.00 1 24628 58 0 0
sp_cancel_pay_from_customer 636 636 0 0.00 3 5785 79 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 4697 97 0 0
sp_cancel_supplier_invoice 6945 6929 16 0.23 1 77425 735 0 16
sp_cancel_supplier_order 449 449 0 0.00 6 1003289 100513 0 0
sp_cancel_write_off 11219 11219 0 0.00 1 10010 105 0 0
sp_client_order 20538 20538 0 0.00 3 16515 364 0 0
sp_customer_reserve 453734 453734 0 0.00 0 56808 184 0 0
sp_fill_shopping_cart 31416 31416 0 0.00 1 18040 34 0 0
sp_fill_shopping_cart_clo_res 453722 453722 0 0.00 0 18094 13 0 0
sp_get_clo_for_invoice 4964 4964 0 0.00 0 27508 279 0 0
sp_kill_cost_storno 18469 18469 0 0.00 0 10433 55 0 0
sp_kill_qstorno_ret_qs2qd 1245783 1245783 0 0.00 0 77421 31 0 0
sp_kill_qty_storno 655047 655047 0 0.00 0 77422 67 0 0
sp_lock_selected_doc 20567 20567 0 0.00 0 8578 7 0 0
sp_make_cost_storno 27506 27506 0 0.00 0 23985 55 0 0
sp_multiply_rows_for_pdistr 27502 27502 0 0.00 0 7375 28 0 0
sp_multiply_rows_for_qdistr 20538 20538 0 0.00 0 11525 167 0 0
sp_pay_from_customer 6946 6946 0 0.00 3 23996 115 0 0
sp_pay_to_supplier 5703 5703 0 0.00 5 15344 130 0 0
sp_payment_common 12647 12647 0 0.00 1 12505 30 0 0
sp_qd_handle_on_cancel_clo 1787 1787 0 0.00 0 10978 354 0 0
sp_qd_handle_on_invoice_upd_sts 11178 11178 0 0.00 0 37417 303 0 0
sp_qd_handle_on_reserve_upd_sts 9892 9892 0 0.00 0 13500 52 0 0
sp_reserve_write_off 9893 9893 0 0.00 6 13517 171 0 0
sp_supplier_invoice 5465 5465 0 0.00 6 80593 3361 0 0
sp_supplier_order 5433 5433 0 0.00 4 69051 1316 0 0
srv_aggregate_perf_data 107 107 0 0.00 2846 558788 20464 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 923 132101 34055 0 0
srv_find_qd_qs_mism 1109729 1109729 0 0.00 0 13583 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 24 43494 933 0 0
srv_make_money_saldo 726 726 0 0.00 0 2424 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 147378 232404 191382 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4976 4976 0 0.00 0 16345 161 0 0
t$perf-norm:sp_cancel_adding_invoice 378 378 0 0.00 1 5586 113 0 0
t$perf-norm:sp_cancel_client_order 1787 1787 0 0.00 0 1769 12 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 8053 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 636 636 0 0.00 0 2102 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 1609 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1657 20 0 0
t$perf-norm:sp_cancel_supplier_order 449 449 0 0.00 0 30479 1588 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 1119 5 0 0
t$perf-norm:sp_client_order 20538 20538 0 0.00 0 12373 18 0 0
t$perf-norm:sp_customer_reserve 976 976 0 0.00 0 740 4 0 0
t$perf-norm:sp_pay_from_customer 6946 6946 0 0.00 0 7057 10 0 0
t$perf-norm:sp_pay_to_supplier 5704 5704 0 0.00 0 7418 12 0 0
t$perf-norm:sp_reserve_write_off 9893 9893 0 0.00 0 7009 10 0 0
t$perf-norm:sp_supplier_invoice 5465 5465 0 0.00 0 5306 15 0 0
t$perf-norm:sp_supplier_order 5433 5433 0 0.00 0 2744 14 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 594 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 4758 37 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 839 13 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 2349 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 10240 9926 314 3.06 0 6242 18 0 314
v_all_customers 37768 37768 0 0.00 0 242 1 0 0
v_all_suppliers 30324 30324 0 0.00 0 18 1 0 0
v_all_wares 41076 41076 0 0.00 0 242 1 0 0
v_cancel_adding_invoice 756 756 0 0.00 0 2166 8 0 0
v_cancel_client_order 3574 3574 0 0.00 0 2771 5 0 0
v_cancel_customer_prepayment 1272 1272 0 0.00 0 5162 9 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 2018 6 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 3556 12 0 0
v_cancel_supplier_invoice 830 798 32 3.85 0 5782 28 0 32
v_cancel_supplier_order 898 898 0 0.00 0 877 4 0 0
v_cancel_write_off 1988 1988 0 0.00 0 4311 15 0 0
v_max_id_clo_ord 5431 5431 0 0.00 0 793 1 0 0
v_max_id_clo_res 976 976 0 0.00 0 1878 11 0 0
v_max_id_ord_sup 5447 5447 0 0.00 0 2174 2 0 0
v_max_non_paid_invoice 1419 1419 0 0.00 0 634 3 0 0
v_max_non_paid_realizn 3495 3495 0 0.00 0 2929 3 0 0
v_min_id_clo_ord 5431 5431 0 0.00 0 2522 6 0 0
v_min_id_clo_res 976 976 0 0.00 0 666 4 0 0
v_min_id_ord_sup 5447 5447 0 0.00 0 4268 4 0 0
v_min_non_paid_invoice 5703 5703 0 0.00 0 7844 17 0 0
v_min_non_paid_realizn 6944 6944 0 0.00 0 6815 19 0 0
v_our_firm 10206 10206 0 0.00 0 64 1 0 0
v_reserve_write_off 19784 19784 0 0.00 0 8009 6 0 0
x_lock_depdocs_on_canc_invoice 12745 12745 0 0.00 0 19467 104 0 0
x_lock_depdocs_on_canc_sup_ord 449 449 0 0.00 0 20404 340 0 0
x_make_qstorno_1000_1200 5433 5433 0 0.00 1 69033 1240 0 0
x_make_qstorno_1200_2000 5465 5465 0 0.00 3 80563 3240 0 0
x_make_qstorno_2100_3300 453734 453734 0 0.00 0 56807 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-01-2021 19:29:11 to 01-01-2021 19:29:15.

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
16:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 22784 8192000000 10264602384 10580164608 1049400560 11.355 81 66 132 0 1074844368 3134592 22309216
16:57:51 14094 8192000000 10342208672 10658185216 1395828672 14.558 100 83 166 0 1427153632 4906944 26418016
16:58:19 32573 8192000000 10387967440 10714185728 1437772752 14.930 100 91 181 1 1474286144 6700960 29812432
16:59:02 26521 8192000000 10410880464 10741071872 1461654160 15.140 100 85 170 0 1497530272 7845280 28030832
16:59:40 36777 8192000000 10459817520 10792071168 1499959952 15.476 100 93 186 1 1538243472 8882992 29400528
17:00:26 22181 8192000000 10473781904 10812235776 1523636928 15.682 100 88 177 2 1560947024 9281376 28028720
17:01:05 6423 8192000000 10480955360 10821394432 1537692672 15.804 100 91 182 0 1577111472 10014480 29404320
17:01:26 19605 8192000000 10509436976 10858790912 1565431328 16.043 100 81 163 1 1600748400 10121344 25195728
17:01:58 10924 8192000000 10534086624 10886123520 1589749376 16.252 100 79 158 1 1624018544 10307152 23962016
17:02:16 14504 8192000000 10550246000 10904797184 1608365152 16.411 100 83 167 0 1644322864 10733824 25223888
17:02:45 19449 8192000000 10571055024 10933166080 1634429984 16.632 100 82 164 1 1669708944 10994896 24284064
17:03:14 14659 8192000000 10603602048 10969251840 1663071216 16.875 100 78 156 0 1698090864 11852688 23166960
17:03:40 10936 8192000000 10614684128 10983690240 1680825984 17.024 100 85 170 0 1718850880 12916560 25108336
17:03:59 9614 8192000000 10639293408 11008503808 1697371488 17.163 100 82 164 1 1734506992 13371232 23764272
17:04:17 10311 8192000000 10659149040 11034730496 1720670416 17.358 100 72 144 2 1754097136 12373264 21053456
17:04:34 11043 8192000000 10682356816 11057688576 1740858064 17.526 100 81 162 0 1776952944 13122704 22972176
17:04:52 6922 8192000000 10682544240 11063070720 1748313424 17.588 100 77 154 0 1783917744 13323152 22281168
17:05:10 4049 8192000000 10692082272 11075719168 1756472544 17.655 100 73 146 1 1790350128 13006256 20871328
17:05:22 5393 8192000000 10700993040 11084058624 1764773120 17.724 100 76 152 0 1798525600 12295552 21456928
17:05:34 4569 8192000000 10716471888 11098836992 1774848640 17.807 100 79 159 0 1809306032 12103712 22353680
17:05:46 3307 8192000000 10723215296 11104710656 1782393680 17.869 100 78 156 0 1817476816 13423408 21659728
17:05:56 4316 8192000000 10729699328 11107414016 1788342960 17.918 100 81 162 2 1824348560 14112000 21893600
17:06:09 7692 8192000000 10731271968 11115978752 1792813488 17.955 100 84 168 2 1830587440 15016320 22757632
17:06:25 5352 8192000000 10748181984 11128369152 1797806048 17.996 100 89 179 0 1838072912 14803056 25463808
17:06:37 3107 8192000000 10764430304 11149434880 1818357040 18.164 100 81 160 1 1853760688 13167792 22235856
17:06:47 2855 8192000000 10764468752 11150680064 1822864848 18.201 100 81 162 5 1859339808 13484944 22990016
17:06:56 2683 8192000000 10768222000 11157987328 1834680096 18.297 100 86 173 2 1870313424 12701136 22932192
17:07:06 2909 8192000000 10782143760 11168264192 1835438112 18.304 100 84 168 0 1873115120 13258864 24418144
17:07:16 2036 8192000000 10783459312 11166957568 1840060720 18.341 100 88 175 0 1877342608 12552208 24729680
17:07:24 2542 8192000000 10788525280 11171442688 1841468064 18.353 100 93 186 1 1880397296 12721104 26208128
17:07:33 1961 8192000000 10789989024 11179474944 1846164656 18.391 100 91 182 1 1886000640 13703888 26132096
17:07:41 1279 8192000000 10797653392 11184910336 1847373664 18.401 100 90 180 0 1885140208 12260304 25506240
17:07:49 2121 8192000000 10793169840 11178799104 1851910576 18.438 100 86 172 1 1887505440 12272064 23322800
17:07:58 1427 8192000000 10807253696 11192963072 1854685008 18.460 100 95 190 1 1899493600 18742448 26066144
17:08:05 2022 8192000000 10803945968 11188846592 1855157760 18.464 100 91 183 1 1894407024 13907488 25341776
17:08:14 1533 8192000000 10802274496 11190501376 1858458512 18.491 100 93 184 0 1899153584 13687024 27008048
17:08:21 1584 8192000000 10803668976 11192496128 1861811920 18.518 100 92 184 0 1902378320 13497952 27068448
17:08:29 2976 8192000000 10806076592 11193921536 1863921712 18.535 100 87 175 2 1902188784 13156960 25110112
17:08:38 1728 8192000000 10816518688 11204132864 1867506672 18.564 100 97 196 3 1906731648 11907760 27317216
17:08:46 16015 8192000000 10788418848 11196067840 1861134960 18.512 100 59 118 0 1889553936 11751184 16667792
17:09:09 1248 8192000000 10818333392 11208409088 1872760576 18.607 100 96 192 3 1912831184 11762144 28308464
17:09:16 16037 8192000000 10791196880 11201925120 1866547168 18.556 100 42 82 1 1885253760 7212624 11493968
17:09:39 8834 8192000000 10777721840 11203399680 1866064480 18.552 100 34 68 2 1883501248 8301184 9135584
17:09:54 3676 8192000000 10788507872 11207892992 1872211584 18.602 100 45 90 1 1893363072 8687072 12464416
17:10:04 5789 8192000000 10801484448 11211759616 1871399920 18.596 100 37 74 0 1888842656 6731872 10710864
17:10:17 8798 8192000000 10782052544 11204489216 1869988432 18.584 100 23 46 1 1882908560 6395744 6524384
17:10:35 5551 8192000000 10791693872 11213156352 1875676288 18.630 100 52 104 4 1899733264 9182320 14874656
17:10:50 3544 8192000000 10794538992 11216883712 1876316416 18.635 100 32 63 4 1893461792 7819184 9326192
17:11:01 3836 8192000000 10791557072 11217772544 1877157568 18.642 100 37 74 0 1894476048 7307008 10011472
17:11:12 7456 8192000000 10792851904 11223871488 1878790208 18.655 100 32 64 0 1899498832 12085824 8622800
17:11:28 4243 8192000000 10795556080 11222335488 1885466704 18.709 100 34 68 1 1902178784 7243728 9468352
17:11:41 7178 8192000000 10800341072 11222601728 1884736976 18.703 100 31 62 0 1898967408 5057904 9172528
17:11:59 4189 8192000000 10798254000 11224944640 1887996416 18.730 100 32 62 2 1902817168 4913040 9907712
17:12:13 6498 8192000000 10786906512 11225612288 1887649952 18.727 100 18 37 0 1898634992 6314784 4670256
17:12:30 10835 8192000000 10807108608 11224166400 1885685936 18.711 100 18 36 0 1896873584 5899952 5287696
17:12:48 26003 8192000000 10796489600 11239444480 1892446176 18.765 100 41 82 1 1910810240 5995680 12368384
17:13:34 30943 8192000000 10852912144 11252047872 1900727056 18.832 100 78 161 1 1929829056 5911952 23190048
17:14:11 5659 8192000000 10820478000 11246374912 1897454368 18.806 100 47 94 2 1920414784 10221472 12738944
17:14:24 4995 8192000000 10819788976 11245215744 1896196624 18.796 100 39 79 1 1915715904 8259136 11260144
17:14:35 4159 8192000000 10812360768 11246030848 1896927232 18.802 100 36 72 0 1915090768 7391824 10771712
17:14:47 8020 8192000000 10818024928 11247869952 1897499120 18.806 100 33 67 0 1913764912 6367296 9898496
17:15:04 9494 8192000000 10824189584 11255820288 1901677360 18.840 100 26 53 1 1920202224 10988496 7536368
17:15:20 5660 8192000000 10835511520 11264319488 1907746976 18.889 100 38 77 1 1929704240 11650752 10306512
17:15:33 3656 8192000000 10814181792 11255250944 1906087760 18.875 100 28 56 2 1920672944 6568000 8017184
17:15:46 8638 8192000000 10795014736 11233533952 1885002272 18.705 99 27 54 0 1899487584 6427280 8058032
17:16:02 7696 8192000000 10796140080 11234365440 1875639632 18.630 99 14 28 1 1885209216 5062976 4506608
17:16:16 3771 8192000000 10802073216 11233591296 1875625600 18.630 99 38 77 0 1892906160 6466768 10813792
17:16:28 9546 8192000000 10793499504 11230068736 1858283584 18.489 98 24 46 7 1871073920 5844784 6945552
17:16:44 53145 8192000000 10805168384 11236638720 1873110816 18.609 99 27 54 2 1890075408 9774192 7190400
17:17:51 13084 8192000000 10775769296 11215589376 1858689904 18.493 99 15 30 1 1868028832 4795056 4543872
17:18:10 10833 8192000000 10778563280 11204571136 1860081968 18.504 99 27 54 1 1873931936 5898592 7951376
17:18:28 7989 8192000000 10788702448 11218132992 1856091968 18.472 99 34 68 0 1873447824 8410560 8945296
17:18:45 9795 8192000000 10764661232 11194392576 1832214368 18.277 98 22 43 1 1844010800 5441216 6355216
17:19:02 4881 8192000000 10737084768 11149258752 1753741824 17.633 95 47 94 1 1774606624 5791280 15073520
17:19:15 6638 8192000000 10723649632 11147165696 1808970112 18.087 99 25 50 1 1822281200 5921872 7389216
17:19:29 5129 8192000000 10718638608 11140866048 1792244448 17.950 99 26 50 1 1804718016 5635424 6838144
17:19:41 7819 8192000000 10708659904 11118735360 1769455888 17.763 98 26 50 3 1782082544 5521936 7104720
17:19:57 6896 8192000000 10719453328 11141509120 1805600016 18.060 100 22 43 0 1818403520 7189824 5613680
17:20:11 6704 8192000000 10722339584 11145822208 1813112176 18.121 100 26 52 0 1826863680 6336944 7414560
17:20:25 15186 8192000000 10678985008 11090321408 1633589504 16.625 90 15 30 0 1643003616 5440624 3973488
17:20:52 11926 8192000000 10703433632 11117260800 1726476048 17.406 96 25 50 2 1740018512 6178976 7363488
17:21:11 17669 8192000000 10694606848 11090354176 1719527472 17.348 97 12 24 0 1727882416 4489456 3865488
17:21:36 56002 8192000000 10668964080 11087581184 1709877136 17.268 96 36 72 0 1726467408 6005264 10585008
17:22:38 10556 8192000000 10691179040 11104661504 1746756192 17.575 98 23 45 2 1758777488 5149616 6871680
17:22:57 11037 8192000000 10703747440 11124203520 1764282544 17.720 98 15 30 3 1774074064 5618640 4172880
17:23:15 5276 8192000000 10719857312 11145109504 1813162480 18.122 100 30 58 3 1828240976 6884240 8194256
17:23:27 7662 8192000000 10746584464 11155861504 1798159248 17.999 98 36 70 2 1813594368 5937632 9497488
17:23:41 6840 8192000000 10739696816 11163230208 1825242752 18.221 100 29 59 0 1840723376 7480992 7999632
17:23:59 10368 8192000000 10749990432 11166687232 1817757616 18.159 99 28 53 1 1832300768 5590592 8952560
17:24:18 9770 8192000000 10758966528 11177603072 1841889456 18.356 100 22 44 1 1854052512 5590080 6572976
17:24:34 8374 8192000000 10759616128 11186642944 1848213936 18.408 100 24 48 1 1861052048 6488048 6350064
17:24:52 10157 8192000000 10758896368 11193810944 1853736000 18.452 100 21 43 0 1865654144 5794592 6123552
17:25:11 9907 8192000000 10775476880 11194691584 1857982896 18.487 100 26 52 1 1871214736 5367792 7864048
17:25:28 11122 8192000000 10776376288 11196555264 1858658208 18.492 100 26 52 0 1872290992 5320816 8311968
17:25:47 12279 8192000000 10773233440 11200745472 1855844176 18.470 100 8 16 0 1864107024 5769520 2493328
17:26:08 23167 8192000000 10772830240 11205771264 1863457488 18.531 100 22 45 2 1875354960 4756448 7141024
17:27:08 78312 8192000000 10845111552 11261599744 1894791424 18.784 100 34 68 1 1910564720 6591952 9181344
17:28:36 14632 8192000000 10850713856 11269611520 1919503920 18.983 100 59 114 2 1946445920 11458160 15483840
17:29:05 9454 8192000000 10857180208 11279560704 1926669152 19.040 100 57 114 1 1955613056 13119520 15824384
17:29:21 19604 8192000000 10863052960 11286241280 1928080960 19.052 100 46 92 0 1952398288 11643536 12673792
17:29:48 8456 8192000000 10864740672 11286085632 1933746080 19.097 100 55 110 2 1961676560 12260784 15669696
17:30:14 11676 8192000000 10872898384 11301777408 1941468064 19.158 100 43 86 1 1966951856 12431104 13052688
17:30:34 28023 8192000000 10892487840 11315499008 1949393104 19.222 100 48 96 1 1978626896 15576816 13656976
17:31:09 28124 8192000000 10879456672 11319525376 1953410608 19.254 100 37 74 0 1981079472 16445136 11223728
17:31:49 22125 8192000000 10909048000 11340734464 1966186016 19.355 100 38 76 0 1995246864 18063600 10997248
17:32:23 24905 8192000000 10918242320 11345764352 1974191168 19.419 100 47 94 1 2004776160 15744688 14840304
17:33:01 11154 8192000000 10926898224 11355238400 1981712800 19.478 100 39 76 1 2010703888 17833856 11157232
17:33:20 3180 8192000000 10935280272 11361648640 1988990480 19.536 100 65 129 1 2026463568 18392656 19080432
17:33:34 5266 8192000000 10931991328 11353206784 1980120736 19.466 100 69 138 1 2020954672 21521856 19312080
17:33:48 8948 8192000000 10944655840 11362537472 1987005312 19.520 100 74 148 2 2030163776 22601072 20557392
17:34:15 13384 8192000000 10933816240 11360727040 1969226592 19.379 99 59 118 1 2010246384 23771408 17248384
17:34:38 18974 8192000000 10923841344 11362623488 1983261200 19.491 100 50 99 3 2021671360 24305312 14104848
17:35:11 6490 8192000000 10915396528 11347836928 1969622464 19.382 99 50 99 1 2009329200 25140272 14566464
17:35:30 15193 8192000000 10938295200 11371175936 1983729920 19.494 100 63 126 0 2030252784 27095536 19427328
17:35:55 5459 8192000000 10942626800 11366576128 1970200864 19.387 99 63 124 5 2019734976 30731408 18802704
17:36:09 5412 8192000000 10951755280 11371458560 1988049952 19.528 100 63 126 4 2034512528 27464784 18997792
17:36:24 12333 8192000000 10944531456 11376840704 1994020736 19.576 100 61 120 1 2038414800 26101392 18292672
17:36:44 10775 8192000000 10962015552 11391397888 2006929984 19.677 100 70 140 1 2059101760 31434224 20737552
17:37:04 6520 8192000000 10966517744 11395096576 2004185424 19.656 100 60 120 2 2053816240 31792048 17838768
17:37:21 12319 8192000000 10961656432 11397177344 2006648608 19.675 100 60 120 0 2056280784 32070752 17561424
17:37:42 8385 8192000000 10966283776 11399364608 1994336848 19.578 99 59 118 0 2046340736 33941232 18062656
17:37:57 2835 8192000000 10981614240 11403276288 2011306368 19.712 100 71 141 1 2067388576 34452736 21629472
17:38:07 5999 8192000000 10983938688 11405422592 2013516272 19.729 100 63 124 0 2066969568 34693648 18759648
17:38:24 11997 8192000000 10982345888 11412664320 2016444800 19.752 100 59 119 0 2070644256 36619040 17580416
17:38:48 3483 8192000000 10983872464 11419815936 2021227760 19.790 100 55 110 0 2074949296 37182144 16539392
17:39:01 9444 8192000000 10997611312 11427057664 2027783216 19.841 100 72 143 0 2086668752 37421760 21463776
17:39:28 10046 8192000000 11002962800 11432198144 2032185376 19.876 100 63 126 0 2092263792 40920848 19157568
17:39:46 4314 8192000000 10999375376 11437019136 2033342992 19.885 100 58 115 2 2092000288 40938416 17718880
17:40:02 4135 8192000000 11007294880 11425611776 2021324736 19.791 100 67 134 2 2084047504 41853616 20869152
17:40:14 1940 8192000000 11007085504 11434213376 2027686288 19.840 100 67 134 0 2092232080 43556528 20989264
17:40:23 7528 8192000000 11000162880 11436654592 2031255104 19.868 100 62 124 0 2095532496 44703280 19574112
17:40:37 2621 8192000000 11014095728 11442409472 2035229568 19.900 100 70 140 2 2101998544 44469136 22299840
17:40:49 5007 8192000000 10996523584 11427143680 2007970752 19.686 99 65 130 1 2075320864 46566272 20783840
17:41:03 5354 8192000000 10995523920 11417890816 2010536080 19.706 100 70 138 3 2079186256 46164352 22485824
17:41:15 9225 8192000000 11002442640 11436015616 2023452384 19.807 100 71 142 2 2098589248 51857856 23279008
17:41:37 6772 8192000000 11012504160 11439230976 2025287024 19.822 100 70 139 0 2095350768 47940256 22123488
17:41:51 4675 8192000000 11018340032 11445059584 2032079200 19.875 100 82 162 1 2106826624 48884640 25862784
17:42:06 6046 8192000000 11011432752 11449073664 2030938560 19.866 100 62 122 0 2101860832 50294096 20628176
17:42:21 5934 8192000000 10995240704 11435573248 2006151664 19.671 99 57 115 0 2072254288 47579728 18522896
17:42:35 8964 8192000000 10997707440 11432345600 2016000064 19.749 100 63 123 1 2085893680 49857824 20035792
17:42:55 4686 8192000000 11016555136 11444649984 2024408368 19.815 100 71 142 0 2097442160 50339712 22694080
17:43:08 3326 8192000000 11014650816 11437309952 2021473456 19.792 100 80 159 1 2096176496 49147584 25555456
17:43:23 6528 8192000000 11021034752 11447619584 2027977968 19.843 100 71 142 1 2102205728 51617472 22610288
17:43:37 7579 8192000000 10998555648 11428835328 1997445408 19.603 99 72 144 0 2072219696 52305824 22468464
17:43:58 3330 8192000000 10997291792 11424923648 2014111840 19.734 100 84 162 2 2083006960 43140368 25754752
17:44:09 3418 8192000000 11002756096 11420299264 2011497840 19.713 100 93 184 2 2084429456 44398624 28532992
17:44:19 1595 8192000000 10990874752 11408146432 1996898864 19.598 99 88 174 1 2065545248 42541168 26105216
17:44:32 3994 8192000000 10979366032 11397390336 1989852064 19.543 100 80 158 1 2059552592 44618560 25081968
17:44:44 3566 8192000000 10979177424 11392970752 1977149008 19.442 99 78 156 0 2048637392 46671232 24817152
17:44:57 3449 8192000000 10985692560 11411312640 1990733216 19.550 100 73 145 1 2065719568 51881344 23105008
17:45:12 13302 8192000000 10941988912 11392765952 1962455664 19.326 99 36 72 2 2022434112 47432976 12545472
17:45:37 13596 8192000000 10947590016 11396468736 1984011728 19.496 100 29 58 2 2034702704 40557200 10133776
17:46:00 18313 8192000000 10947491504 11401072640 1984311024 19.499 100 28 56 1 2037013216 42812560 9889632
17:46:35 19189 8192000000 10937741840 11392978944 1962039920 19.322 99 27 54 2 2010634960 38907680 9687360
17:47:04 13509 8192000000 10955197648 11401658368 1971742336 19.399 99 34 68 0 2023540016 40612240 11185440
17:47:26 2082 8192000000 10977833264 11398094848 1989369648 19.539 100 76 154 0 2054507808 41304016 23834144
17:47:35 18350 8192000000 10934608432 11384868864 1945633184 19.192 98 39 78 1 1995766608 37343712 12789712
17:48:03 5961 8192000000 10931048528 11377074176 1961444160 19.318 100 33 66 2 2012212720 39919600 10848960
17:48:19 12568 8192000000 10921644320 11368255488 1933488192 19.095 98 38 76 0 1989038416 43083424 12466800
17:48:42 12197 8192000000 10906737088 11343855616 1893428896 18.773 97 39 78 1 1953064544 46387632 13248016
17:49:11 11644 8192000000 10901240528 11341430784 1931878272 19.082 100 34 68 0 1987992640 44721168 11393200
17:49:44 10978 8192000000 10880662560 11320840192 1897182432 18.804 98 37 74 1 1942810704 33754464 11873808
17:50:08 9569 8192000000 10892884848 11336511488 1935694352 19.112 100 40 80 1 1982526112 34145536 12686224
17:50:50 13376 8192000000 10848975664 11295019008 1845424976 18.385 95 23 46 1 1880711008 27511680 7774352
17:51:18 3917 8192000000 10907178080 11325378560 1930620944 19.072 100 60 120 0 1978310384 28670656 19018784
17:51:31 2962 8192000000 10922015472 11337084928 1948245232 19.212 100 64 126 0 1998927296 30948800 19733264
17:51:40 5148 8192000000 10889193168 11313680384 1917140352 18.964 99 52 104 0 1968992912 34955264 16897296
17:51:55 19489 8192000000 10893937936 11332980736 1940943264 19.154 100 37 74 0 1982268624 29167520 12157840
17:52:35 14461 8192000000 10924960272 11347894272 1930737664 19.073 99 50 98 0 1981444848 34953856 15753328
17:52:57 7719 8192000000 10903515312 11335966720 1921511648 18.999 99 49 98 2 1973408464 36267520 15629296
17:53:13 46137 8192000000 10899299872 11358404608 1937236752 19.125 100 27 54 0 1983591056 36878096 9476208
17:54:07 29823 8192000000 10893650704 11350937600 1935548320 19.111 100 20 40 1 1976832432 34449408 6834704
17:54:56 56547 8192000000 10901239856 11362889728 1942161728 19.164 100 23 46 0 1992415872 41954320 8299824
17:56:06 18120 8192000000 10829018016 11295952896 1823736240 18.208 96 11 22 0 1873705872 45513616 4456016
17:56:33 11847 8192000000 10865338656 11330834432 1891417552 18.757 100 17 35 0 1951578416 53888864 6272000
17:57:20 31808 8192000000 10876965856 11324792832 1908006240 18.891 100 15 30 1 1932837648 20869728 3961680
17:57:59 76771 8192000000 10861385632 11323990016 1892783744 18.768 98 12 24 1 1915987216 20050480 3152992
17:59:22 63944 8192000000 10904039472 11346251776 1930334800 19.070 99 23 44 2 1946751584 9557312 6859472
18:00:40 11210 8192000000 10892784496 11341520896 1931266960 19.077 98 39 75 2 1948721056 7426240 10027856
18:01:05 85574 8192000000 10897957984 11371802624 1938722576 19.137 99 6 12 0 1955850224 14750608 2377040
18:02:37 67246 8192000000 10919214624 11360481280 1974493456 19.421 100 33 64 2 1994873952 11601120 8779376
18:04:39 91771 8192000000 10893407440 11336921088 1906848480 18.881 97 39 72 1 1924605072 6172416 11584176
18:06:18 91560 8192000000 10908130928 11354423296 1941096336 19.156 99 20 40 0 1957396960 10121760 6178864
18:07:58 30843 8192000000 10896936480 11357732864 1955308480 19.269 99 26 50 2 1970913120 8639888 6964752
18:08:36 39406 8192000000 10898391856 11360616448 1972085008 19.402 100 24 48 1 1987602784 8456720 7061056
18:09:22 30160 8192000000 10900451920 11367649280 1974085888 19.418 100 17 34 3 1988851504 9712608 5053008
18:10:10 36825 8192000000 10895568384 11355914240 1943937792 19.178 98 37 74 0 1963700000 8822528 10939680
18:10:53 68073 8192000000 10913092224 11363721216 1937194128 19.124 98 14 28 1 1956954352 15754880 4005344
18:12:08 22385 8192000000 10922732208 11381817344 1981604608 19.477 100 35 68 1 2009414576 17266608 10543360
18:12:41 13556 8192000000 10944854288 11388342272 1990460240 19.547 100 51 101 0 2029487504 24161952 14865312
18:13:02 46500 8192000000 10926422656 11396718592 1996346784 19.594 100 49 97 1 2029582304 19030784 14204736
18:14:00 39946 8192000000 10915854832 11407933440 1987031440 19.520 100 14 28 1 2011491872 19897264 4563168
18:14:46 20753 8192000000 10929316352 11411234816 1988737744 19.534 100 24 50 3 2019013056 23334880 6940432
18:15:17 16727 8192000000 10921996928 11415945216 1987881744 19.527 100 11 21 1 2014847824 24916656 2049424
18:15:40 51270 8192000000 10913734000 11393765376 1989590272 19.541 100 12 24 1 2012263504 19774080 2899152
18:16:39 45219 8192000000 10921807216 11388731392 1981624560 19.478 99 25 51 1 1995398960 7309616 6464784
18:17:34 65922 8192000000 10923218752 11398463488 1981824032 19.479 99 15 30 0 1996352512 9827040 4701440
18:18:56 83888 8192000000 10934080992 11424632832 2002021872 19.639 100 22 44 0 2025228720 17323152 5883696
18:20:37 93915 8192000000 10893435488 11364708352 1934716784 19.105 97 22 44 1 1957690544 16508032 6465728
18:22:17 92699 8192000000 10910164384 11401875456 1978004496 19.449 100 10 18 1 1995538848 14541936 2992416
18:25:21 62416 8192000000 10915473344 11395883008 1965431648 19.349 98 20 40 2 1982812944 11571904 5809392
18:26:31 69420 8192000000 10921798992 11391283200 1943120768 19.172 97 22 44 2 1970280448 21232752 5926928
18:27:46 93770 8192000000 10932324640 11420270592 1993297792 19.570 99 23 46 0 2015945616 16254720 6393104
18:29:27 77176 8192000000 10907575248 11391127552 1925479232 19.031 96 13 26 0 1942377008 13673552 3224224
18:30:57 50723 8192000000 10933101008 11389595648 1956032320 19.274 98 15 30 2 1970757664 10372448 4352896
18:31:54 38221 8192000000 10900795344 11370360832 1913110272 18.932 96 21 42 2 1930423248 11441744 5871232
18:32:38 42220 8192000000 10928054384 11384324096 1945458416 19.190 98 30 60 0 1970985840 17684272 7843152
18:33:27 62856 8192000000 10910166272 11384561664 1956352000 19.277 99 17 34 1 1975458144 14498336 4607808
18:34:48 12571 8192000000 10877717312 11328462848 1907214288 18.884 97 34 68 1 1923975920 7176944 9584688
18:35:07 20909 8192000000 10908016768 11359203328 1945135792 19.188 99 36 72 0 1966800848 11581856 10083200
18:35:37 53374 8192000000 10856969056 11331813376 1872785328 18.607 96 29 58 1 1896307296 15437488 8084480
18:36:37 52510 8192000000 10881685856 11329859584 1873297392 18.611 96 21 42 0 1887123280 8195152 5630736
18:37:36 65959 8192000000 10841720288 11299950592 1824859904 18.217 94 15 30 0 1844131824 14773760 4498160
18:39:38 85619 8192000000 10839494256 11301646336 1829932752 18.259 95 26 52 0 1848667936 11179808 7555376
18:41:13 64663 8192000000 10844118928 11297169408 1849075600 18.415 96 35 70 0 1869271520 9314624 10881296
18:42:41 73321 8192000000 10825205552 11287183360 1860036224 18.504 97 18 36 2 1873827168 8625760 5165184
18:44:01 95854 8192000000 10846179472 11306618880 1887667264 18.727 98 18 36 0 1908670496 15644032 5359200
18:45:43 57119 8192000000 10882550576 11342819328 1916684064 18.960 99 21 42 3 1937248560 14706240 5858256
18:47:02 91742 8192000000 10893244720 11357650944 1950101200 19.227 100 9 18 0 1973658848 20941536 2616112
18:48:48 70977 8192000000 10908836992 11378307072 1961212624 19.316 100 17 34 0 1985158240 18856080 5089536
18:50:44 53636 8192000000 10864632064 11330805760 1882133600 18.682 96 16 32 1 1904925648 17791808 5000240
18:51:44 53742 8192000000 10872352976 11336282112 1915344000 18.950 99 22 44 0 1936056304 14105808 6606496
18:52:45 84980 8192000000 10864722224 11333472256 1911121184 18.916 98 8 16 0 1930615728 17093584 2400960
18:54:19 52075 8192000000 10875142768 11327815680 1896732320 18.800 98 15 30 0 1909921264 9203696 3985248
18:55:20 32312 8192000000 10876133008 11319951360 1888016304 18.730 97 48 96 0 1912880000 11378624 13485072
18:56:21 46247 8192000000 10867979408 11328409600 1905174496 18.868 98 31 62 0 1925522608 11858384 8489728
18:57:14 67501 8192000000 10901010800 11346845696 1939032320 19.139 99 35 70 1 1959818608 11314496 9471792
18:58:28 128660 8192000000 10894318512 11354271744 1906292176 18.877 97 24 48 1 1940752240 28023440 6436624
19:01:34 31575 8192000000 10920289520 11379580928 1976423328 19.436 100 27 55 0 1995972352 11831472 7717552
19:02:15 48646 8192000000 10906486304 11368534016 1953295888 19.253 99 13 26 3 1969294976 12648528 3350560
19:03:23 132100 8192000000 10891168848 11372445696 1976159888 19.434 100 25 50 1 1995113376 10051104 8902384
19:05:49 29915 8192000000 10896317840 11374587904 1977846368 19.448 100 12 24 0 1989666192 8927888 2891936
19:06:25 923 8192000000 10906148192 11370438656 1978489744 19.453 100 24 48 0 1992189776 7030592 6669440
19:06:32 7792 8192000000 10901151632 11357835264 1965415008 19.349 100 28 56 1 1981875440 8921344 7539088
19:06:47 36333 8192000000 10885194080 11359760384 1958214016 19.292 99 49 98 0 1982419040 9875904 14329120
19:07:29 105504 8192000000 10900428544 11380445184 1976064160 19.434 100 14 28 0 1989619408 9807920 3747328
19:09:22 42929 8192000000 10908089136 11385692160 1988638768 19.533 100 16 33 1 2006798256 13379712 4779776
19:10:18 58029 8192000000 10868410896 11356237824 1940415328 19.150 98 15 31 1 1956659840 11808096 4436416
19:11:23 58616 8192000000 10908908400 11377061888 1950473808 19.230 99 12 24 0 1963164400 9502480 3188112
19:12:28 119561 8192000000 10906959504 11382173696 1965435168 19.349 99 16 32 0 1989299568 19614240 4250160
19:14:39 73557 8192000000 10908643712 11385503744 1962463696 19.326 99 19 38 1 1983162096 15216016 5482384
19:15:59 42091 8192000000 10923894368 11370622976 1927042784 19.043 97 28 57 0 1941900608 6770544 8087280
19:16:48 22721 8192000000 10917951488 11387822080 1989717456 19.542 100 41 82 1 2009456960 8939232 10800272
19:17:19 51576 8192000000 10914433328 11396116480 1989957456 19.543 100 28 56 3 2007452160 9518784 7975920
19:18:32 77048 8192000000 10916841536 11392114688 1937289280 19.125 97 17 34 1 1957556736 15449728 4817728
19:20:03 70391 8192000000 10904654368 11377852416 1898681200 18.816 96 20 40 1 1927248032 22783824 5783008
19:21:28 50982 8192000000 10885849008 11364126720 1908469616 18.894 97 6 12 0 1927448624 17417232 1561776
19:22:29 61812 8192000000 10916932960 11364806656 1927174672 19.044 98 26 51 1 1946275936 12710528 6390736
19:23:55 22101 8192000000 10935772016 11386179584 1978867360 19.456 100 44 88 1 2001789280 11191984 11729936
19:24:27 14953 8192000000 10914373872 11361132544 1934950576 19.106 98 45 90 1 1960382960 12957328 12475056
19:24:54 57971 8192000000 10902155296 11329134592 1825388848 18.222 93 54 107 1 1851409392 10983584 15036960
19:26:01 79063 8192000000 9726612080 10069463040 869014304 9.590 45 29 54 1 882266720 5452672 7799744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 01-01-2021 19:29:16 to 01-01-2021 19:29:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 157 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-01-2021 19:29:48 to 01-01-2021 19:29:50.

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          234510
MON$OLDEST_ACTIVE               234511
MON$OLDEST_SNAPSHOT             234511
MON$NEXT_TRANSACTION            234511
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                       2039328
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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'

01.01.21 19:29:51. 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-01-01 19:29:53 No severe PSQL-related problems occured
01.01.21 19:29:54. End of report.