Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.11.2020 16:31
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 17548936 kB
MemAvailable 31429264 kB
Buffers 0 kB
Cached 14107852 kB
SwapCached 2828 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-05 16:30:42
DTS_END                         2020-11-05 16:30:42.1610
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/49202
TRN_ID                          231379
ATT_ID                          677
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: 8878.69 25133 1065443
customer order: creation 161.05 337 19326
customer order: refuse 13.27 408 1592
order to supplier: creation 43.04 1314 5165
order to supplier: removal 3.40 114848 408
invoice (draft): creation 44.40 3459 5328
invoice (draft): removal 51.84 881 6221
invoice accept: apply 39.98 18123 4798
invoice accept: cancel 46.24 813 5549
customer reserve: creation 3680.88 179 441705
customer reserve: removal 4514.12 68 541694
realization accept: apply 79.14 209 9497
realization accept: cancel 78.90 122 9468
payment from customer: creation 55.98 154 6718
payment from customer: removal 5.16 115 619
payment to supplier: creation 46.92 148 5630
payment to supplier: removal 3.25 87 390
service: total inventory turnovers 4.27 1256 512
service: total monetary turnovers 5.99 22 719
service: aggregate perf. data 0.83 20129 100
service: refresh index statistics 0.03 339979 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2020 16:31:31 to 05-11-2020 16:31:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2836
TEST_TIME 2 1652
TEST_TIME 3 1763
TEST_TIME 4 2220
TEST_TIME 5 2805
TEST_TIME 6 3855
TEST_TIME 7 3921
TEST_TIME 8 4323
TEST_TIME 9 4295
TEST_TIME 10 4416
TEST_TIME 11 4584
TEST_TIME 12 4771
TEST_TIME 13 4948
TEST_TIME 14 5218
TEST_TIME 15 5509
TEST_TIME 16 5731
TEST_TIME 17 5881
TEST_TIME 18 6149
TEST_TIME 19 6583
TEST_TIME 20 6924
TEST_TIME 21 6902
TEST_TIME 22 7181
TEST_TIME 23 7314
TEST_TIME 24 8021
TEST_TIME 25 7835
TEST_TIME 26 8395
TEST_TIME 27 8365
TEST_TIME 28 9252
TEST_TIME 29 10072
TEST_TIME 30 10021
TEST_TIME 31 9815
TEST_TIME 32 9718
TEST_TIME 33 9648
TEST_TIME 34 9515
TEST_TIME 35 9534
TEST_TIME 36 9438
TEST_TIME 37 9308
TEST_TIME 38 9181
TEST_TIME 39 9236
TEST_TIME 40 9128
TEST_TIME 41 9051
TEST_TIME 42 9016
TEST_TIME 43 8949
TEST_TIME 44 8772
TEST_TIME 45 8676
TEST_TIME 46 8627
TEST_TIME 47 8652
TEST_TIME 48 8591
TEST_TIME 49 8496
TEST_TIME 50 8422
TEST_TIME 51 8386
TEST_TIME 52 8403
TEST_TIME 53 8440
TEST_TIME 54 8335
TEST_TIME 55 8439
TEST_TIME 56 8512
TEST_TIME 57 8572
TEST_TIME 58 8551
TEST_TIME 59 8524
TEST_TIME 60 8567
TEST_TIME 61 8654
TEST_TIME 62 8692
TEST_TIME 63 8660
TEST_TIME 64 8690
TEST_TIME 65 8870
TEST_TIME 66 8851
TEST_TIME 67 8855
TEST_TIME 68 8874
TEST_TIME 69 8938
TEST_TIME 70 8983
TEST_TIME 71 8915
TEST_TIME 72 8840
TEST_TIME 73 8779
TEST_TIME 74 8806
TEST_TIME 75 8772
TEST_TIME 76 8723
TEST_TIME 77 8785
TEST_TIME 78 8813
TEST_TIME 79 8790
TEST_TIME 80 8803
TEST_TIME 81 8764
TEST_TIME 82 8690
TEST_TIME 83 8696
TEST_TIME 84 8731
TEST_TIME 85 8694
TEST_TIME 86 8668
TEST_TIME 87 8709
TEST_TIME 88 8692
TEST_TIME 89 8738
TEST_TIME 90 8729
TEST_TIME 91 8750
TEST_TIME 92 8797
TEST_TIME 93 8887
TEST_TIME 94 8881
TEST_TIME 95 8943
TEST_TIME 96 8989
TEST_TIME 97 9039
TEST_TIME 98 8990
TEST_TIME 99 8985
TEST_TIME 100 9034
TEST_TIME 101 9059
TEST_TIME 102 8991
TEST_TIME 103 8971
TEST_TIME 104 8943
TEST_TIME 105 8909
TEST_TIME 106 8917
TEST_TIME 107 8893
TEST_TIME 108 8843
TEST_TIME 109 8832
TEST_TIME 110 8796
TEST_TIME 111 8797
TEST_TIME 112 8793
TEST_TIME 113 8771
TEST_TIME 114 8791
TEST_TIME 115 8802
TEST_TIME 116 8791
TEST_TIME 117 8814
TEST_TIME 118 8893
TEST_TIME 119 8887
TEST_TIME 120 8884

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-11-2020 16:31:34 to 05-11-2020 16:31:38.

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 1473863 1473863 0 0.00 0 24339 6 0 0
doc_list_biud 1473863 1473863 0 0.00 0 31881 32 0 0
sp_add_invoice_to_stock 4881 4798 83 1.70 49 197167 18123 0 83
sp_cancel_adding_invoice 5549 5549 0 0.00 5 54236 813 0 0
sp_cancel_client_order 1592 1592 0 0.00 5 14365 408 0 0
sp_cancel_customer_reserve 541694 541694 0 0.00 1 21233 68 0 0
sp_cancel_pay_from_customer 619 619 0 0.00 2 7255 116 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 2 4368 87 0 0
sp_cancel_supplier_invoice 6224 6221 3 0.04 1 15570 882 0 3
sp_cancel_supplier_order 408 408 0 0.00 7 1178503 114849 0 0
sp_cancel_write_off 9468 9468 0 0.00 1 21411 123 0 0
sp_client_order 19326 19326 0 0.00 3 19903 337 0 0
sp_customer_reserve 441705 441705 0 0.00 0 44023 179 0 0
sp_fill_shopping_cart 29817 29817 0 0.00 1 32986 43 0 0
sp_fill_shopping_cart_clo_res 441703 441703 0 0.00 0 16862 13 0 0
sp_get_clo_for_invoice 4791 4791 0 0.00 0 16070 322 0 0
sp_kill_cost_storno 16026 16026 0 0.00 0 10324 61 0 0
sp_kill_qstorno_ret_qs2qd 1099485 1099485 0 0.00 0 21383 37 0 0
sp_kill_qty_storno 579220 579220 0 0.00 0 31879 80 0 0
sp_lock_selected_doc 19625 19625 0 0.00 0 6026 5 0 0
sp_make_cost_storno 26636 26636 0 0.00 0 22811 65 0 0
sp_multiply_rows_for_pdistr 26636 26636 0 0.00 0 20360 39 0 0
sp_multiply_rows_for_qdistr 19326 19326 0 0.00 0 19891 153 0 0
sp_pay_from_customer 6718 6718 0 0.00 4 31344 155 0 0
sp_pay_to_supplier 5630 5630 0 0.00 5 20176 149 0 0
sp_payment_common 12348 12348 0 0.00 1 31337 51 0 0
sp_qd_handle_on_cancel_clo 1592 1592 0 0.00 0 11421 359 0 0
sp_qd_handle_on_invoice_upd_sts 10340 10340 0 0.00 0 31873 361 0 0
sp_qd_handle_on_reserve_upd_sts 9497 9497 0 0.00 0 11941 59 0 0
sp_reserve_write_off 9497 9497 0 0.00 6 21927 209 0 0
sp_supplier_invoice 5328 5328 0 0.00 6 77247 3459 0 0
sp_supplier_order 5165 5165 0 0.00 5 56112 1314 0 0
srv_aggregate_perf_data 100 100 0 0.00 2648 189197 20130 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1128 131861 34834 0 0
srv_find_qd_qs_mism 1019864 1019864 0 0.00 0 11430 5 0 0
srv_make_invnt_saldo 512 512 0 0.00 31 40573 1257 0 0
srv_make_money_saldo 719 719 0 0.00 1 519 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 199958 470872 339980 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4798 4798 0 0.00 0 14512 188 0 0
t$perf-norm:sp_cancel_adding_invoice 383 383 0 0.00 1 12648 159 0 0
t$perf-norm:sp_cancel_client_order 1592 1592 0 0.00 0 5392 20 0 0
t$perf-norm:sp_cancel_customer_reserve 623 623 0 0.00 0 1747 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 619 619 0 0.00 0 2547 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 296 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 2860 25 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 27249 1665 0 0
t$perf-norm:sp_cancel_write_off 924 924 0 0.00 0 2619 8 0 0
t$perf-norm:sp_client_order 19326 19326 0 0.00 0 13661 22 0 0
t$perf-norm:sp_customer_reserve 955 955 0 0.00 0 2897 7 0 0
t$perf-norm:sp_pay_from_customer 6718 6718 0 0.00 0 12626 10 0 0
t$perf-norm:sp_pay_to_supplier 5630 5630 0 0.00 0 15654 11 0 0
t$perf-norm:sp_reserve_write_off 9497 9497 0 0.00 0 12614 15 0 0
t$perf-norm:sp_supplier_invoice 5328 5328 0 0.00 0 17220 20 0 0
t$perf-norm:sp_supplier_order 5165 5165 0 0.00 0 6972 20 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 415 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 12573 100 0 0
t$perf-norm:srv_make_invnt_saldo 512 512 0 0.00 0 2490 35 0 0
t$perf-norm:srv_make_money_saldo 719 719 0 0.00 0 743 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 9746 9580 166 1.70 0 12456 20 0 166
v_all_customers 35348 35348 0 0.00 0 15 1 0 0
v_all_suppliers 29162 29162 0 0.00 0 19 1 0 0
v_all_wares 38652 38652 0 0.00 0 97 1 0 0
v_cancel_adding_invoice 766 766 0 0.00 0 10901 22 0 0
v_cancel_client_order 3184 3184 0 0.00 0 13863 15 0 0
v_cancel_customer_prepayment 1238 1238 0 0.00 0 6983 15 0 0
v_cancel_customer_reserve 1246 1246 0 0.00 0 443 3 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 1856 4 0 0
v_cancel_supplier_invoice 806 800 6 0.74 0 1636 19 0 6
v_cancel_supplier_order 816 816 0 0.00 0 1124 8 0 0
v_cancel_write_off 1848 1848 0 0.00 0 2268 13 0 0
v_max_id_clo_ord 5163 5163 0 0.00 0 2782 2 0 0
v_max_id_clo_res 955 955 0 0.00 0 1272 6 0 0
v_max_id_ord_sup 5328 5328 0 0.00 0 5112 4 0 0
v_max_non_paid_invoice 1540 1540 0 0.00 0 2141 4 0 0
v_max_non_paid_realizn 3531 3531 0 0.00 0 5615 6 0 0
v_min_id_clo_ord 5163 5163 0 0.00 0 5629 10 0 0
v_min_id_clo_res 955 955 0 0.00 0 8718 31 0 0
v_min_id_ord_sup 5328 5328 0 0.00 0 5473 8 0 0
v_min_non_paid_invoice 5630 5630 0 0.00 0 20157 30 0 0
v_min_non_paid_realizn 6718 6718 0 0.00 0 19323 25 0 0
v_our_firm 9678 9678 0 0.00 0 12 1 0 0
v_reserve_write_off 18992 18992 0 0.00 0 18241 7 0 0
x_lock_depdocs_on_canc_invoice 11370 11370 0 0.00 0 19811 125 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 9161 374 0 0
x_make_qstorno_1000_1200 5165 5165 0 0.00 1 50573 1230 0 0
x_make_qstorno_1200_2000 5328 5328 0 0.00 3 77222 3302 0 0
x_make_qstorno_2100_3300 441705 441705 0 0.00 0 44022 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2020 16:31:39 to 05-11-2020 16:31:43.

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
14:00:45 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:00:52 14320 8192000000 10223756448 10532372480 805567520 8.953 62 42 85 0 821659872 2249712 13842640
14:01:14 26664 8192000000 10360370080 10686447616 1386866304 14.478 100 82 164 0 1418075760 4332176 26877280
14:01:53 29799 8192000000 10396705616 10727124992 1447603200 15.017 100 86 172 0 1482111168 6736368 27771600
14:02:37 29290 8192000000 10434017152 10767532032 1483687200 15.334 100 88 174 0 1520513232 8051056 28774976
14:03:15 19565 8192000000 10452969424 10786304000 1503958544 15.511 100 91 182 2 1541893552 8692448 29242560
14:03:50 20824 8192000000 10467893504 10807951360 1521115920 15.660 100 84 166 1 1557025680 9543856 26365904
14:04:23 20047 8192000000 10485721888 10830716928 1540318576 15.826 100 80 159 1 1575330896 9766272 25246048
14:04:50 16995 8192000000 10504742160 10856271872 1563029664 16.022 100 79 157 0 1596687392 9774000 23883728
14:05:14 16775 8192000000 10530210224 10881085440 1583952944 16.202 100 80 160 0 1623104720 14710496 24441280
14:05:39 16382 8192000000 10558851632 10911047680 1614228464 16.461 100 85 170 0 1651707920 11542720 25936736
14:06:04 14304 8192000000 10573629072 10933911552 1629117920 16.587 100 86 171 1 1667643536 12458608 26067008
14:06:26 15786 8192000000 10589542640 10951897088 1650590784 16.769 100 81 161 2 1687993968 12714240 24688944
14:06:55 13968 8192000000 10611135232 10977779712 1670206256 16.935 100 86 170 3 1707932336 12686944 25039136
14:07:17 11156 8192000000 10620047520 10992336896 1683670944 17.048 100 81 160 1 1720669712 13603488 23395280
14:07:36 9747 8192000000 10638267216 11008704512 1697079920 17.161 100 84 168 0 1735507488 13939568 24488000
14:07:54 8773 8192000000 10654128096 11021905920 1708040672 17.252 100 89 179 1 1748729504 14833520 25855312
14:08:11 5960 8192000000 10642702320 11015749632 1708811472 17.259 100 79 158 2 1746540496 15087984 22641040
14:08:24 4538 8192000000 10649137088 11024617472 1720212400 17.354 100 76 152 0 1755483968 14050208 21221360
14:08:35 7419 8192000000 10669852160 11050688512 1733421072 17.464 100 81 161 3 1769161920 12729184 23011664
14:08:51 8187 8192000000 10673280640 11055263744 1743812256 17.550 100 77 153 2 1777852256 12331200 21708800
14:09:06 5644 8192000000 10686186432 11070763008 1752500528 17.622 100 74 146 1 1785165136 11494704 21169904
14:09:20 5911 8192000000 10707763184 11090657280 1771968416 17.783 100 85 170 1 1808392992 12265664 24158912
14:09:33 5360 8192000000 10723041072 11103383552 1778253552 17.835 100 74 148 0 1810364704 11697136 20414016
14:09:46 3725 8192000000 10729094064 11112976384 1790910320 17.939 100 84 168 1 1827330944 13304112 23116512
14:09:56 3618 8192000000 10740067840 11121958912 1797982144 17.997 100 88 174 0 1836146592 13819680 24344768
14:10:07 3683 8192000000 10744764064 11127037952 1804104688 18.048 100 88 176 1 1842304848 13887280 24312880
14:10:17 3569 8192000000 10750352576 11134877696 1805917632 18.062 100 87 174 0 1844771696 14309424 24544640
14:10:27 7297 8192000000 10752013984 11137064960 1811104128 18.105 100 81 161 1 1847378864 13484096 22790640
14:10:42 7296 8192000000 10747099216 11139686400 1817024576 18.153 100 78 154 4 1851800176 13319264 21456336
14:10:55 3327 8192000000 10774051120 11165614080 1835902704 18.307 100 87 175 0 1873346656 12965760 24478192
14:11:06 2831 8192000000 10775355056 11164012544 1841106832 18.350 100 90 178 1 1879888400 13505264 25276304
14:11:15 2820 8192000000 10782654576 11173244928 1845003936 18.382 100 89 178 1 1883009120 13291264 24713920
14:11:25 1858 8192000000 10793631344 11178807296 1849226656 18.416 100 92 184 1 1889747504 13603104 26917744
14:11:33 2341 8192000000 10794367136 11182792704 1856133504 18.472 100 87 175 2 1893095936 12493808 24468624
14:11:41 2114 8192000000 10799984752 11192807424 1862299712 18.522 100 86 172 0 1900245168 12687904 25257552
14:11:50 2003 8192000000 10811534496 11196137472 1863945968 18.535 100 95 193 1 1903673392 13240752 26486672
14:11:59 3127 8192000000 10808630608 11199619072 1864137168 18.537 100 92 184 0 1903061632 13674704 25249760
14:12:08 1309 8192000000 10819176032 11205775360 1870260448 18.586 100 89 175 0 1907863440 12375392 25227600
14:12:16 1596 8192000000 10818544944 11207024640 1874756752 18.623 100 96 190 2 1914845808 13322048 26767008
14:12:24 4806 8192000000 10818923456 11213627392 1878622176 18.654 100 92 184 2 1918256368 13841344 25792848
14:12:35 1867 8192000000 10818460592 11209224192 1876584608 18.638 100 89 178 0 1915713472 14304944 24823920
14:12:44 1761 8192000000 10820428448 11212083200 1877891664 18.648 100 93 185 0 1917821424 13510416 26419344
14:12:52 31341 8192000000 10817641600 11215261696 1877419360 18.644 100 64 128 0 1905758992 9310624 19029008
14:13:30 2442 8192000000 10802422352 11216027648 1877936384 18.648 100 58 116 0 1905554272 11403824 16214064
14:13:41 2426 8192000000 10804410880 11218956288 1879958768 18.665 100 58 117 0 1906517120 10493296 16065056
14:13:51 5346 8192000000 10794161232 11214196736 1879021344 18.657 100 46 93 1 1901493536 9936368 12535824
14:14:02 3897 8192000000 10795661232 11216769024 1877228672 18.643 100 33 64 2 1895891744 7737296 10925776
14:14:14 6841 8192000000 10807010224 11225673728 1878353664 18.652 100 25 51 2 1892116768 6555984 7207120
14:14:28 10391 8192000000 10789869728 11219439616 1880821776 18.672 100 24 48 0 1895199472 7504432 6873264
14:14:45 2430 8192000000 10799057136 11222515712 1886141888 18.715 100 45 90 2 1905774608 6389472 13243248
14:14:54 7055 8192000000 10802970384 11227242496 1884647024 18.703 100 20 40 2 1900421792 10529216 5245552
14:15:07 4470 8192000000 10803811952 11229212672 1892057872 18.762 100 40 80 3 1910070864 7495280 10517712
14:15:19 11471 8192000000 10799635584 11229343744 1887951152 18.729 100 17 34 1 1898245840 5296240 4998448
14:15:38 16432 8192000000 10809363488 11233415168 1891738752 18.760 100 20 40 0 1904077008 6033872 6304384
14:16:04 77993 8192000000 10812237360 11241205760 1895957616 18.794 100 35 70 0 1912086816 5398608 10730592
14:17:28 19614 8192000000 10800038656 11243737088 1897982800 18.810 100 13 26 1 1911410960 9965808 3462352
14:17:54 8382 8192000000 10819339840 11252785152 1904010208 18.859 100 22 44 2 1916520288 6590704 5919376
14:18:08 7747 8192000000 10810392080 11248644096 1904851280 18.865 100 17 34 2 1914671936 5333600 4487056
14:18:24 5347 8192000000 10803255248 11233189888 1888756752 18.736 99 37 74 1 1906948912 7112304 11079856
14:18:41 9171 8192000000 10815829936 11244433408 1896645408 18.799 100 22 44 2 1907766672 4938880 6182384
14:18:57 6111 8192000000 10818916320 11250540544 1899175952 18.820 100 23 45 1 1915726208 10075680 6474576
14:19:10 9540 8192000000 10803329536 11244527616 1897320400 18.805 100 15 30 2 1906947440 5743712 3883328
14:19:30 8055 8192000000 10811628160 11246329856 1901319312 18.837 100 27 54 1 1914697536 5193520 8184704
14:19:52 13326 8192000000 10803386400 11243757568 1882675104 18.687 99 16 32 0 1893561696 5689264 5197328
14:20:12 6442 8192000000 10800304800 11238203392 1882448816 18.685 99 25 49 0 1895526864 6202576 6875472
14:20:25 6791 8192000000 10811241472 11238785024 1882647696 18.686 99 31 62 1 1897798352 5581088 9569568
14:20:40 10115 8192000000 10799476912 11232681984 1887781152 18.728 100 25 50 1 1900662560 5169984 7711424
14:21:00 66841 8192000000 10744259104 11152310272 1779553536 17.846 94 24 48 0 1791804592 4922800 7328256
14:22:13 9862 8192000000 10743689952 11175682048 1810116224 18.097 98 28 57 1 1823984352 5828464 8039664
14:22:31 8674 8192000000 10753212432 11189006336 1824833392 18.217 98 16 32 2 1835217920 5597840 4786688
14:22:46 5346 8192000000 10782555072 11206688768 1860891488 18.511 100 27 54 2 1875133792 5669072 8573232
14:22:57 2995 8192000000 10757199696 11182751744 1836501984 18.312 99 40 79 1 1853459888 5508128 11449776
14:23:08 3565 8192000000 10731436032 11143434240 1777460272 17.829 97 30 60 1 1792173120 6631792 8081056
14:23:21 8499 8192000000 10747201216 11160244224 1792099648 17.949 98 29 58 3 1810728480 10589664 8039168
14:23:40 7378 8192000000 10726628992 11152818176 1772966832 17.791 97 27 54 2 1786899072 6332672 7599568
14:23:55 11089 8192000000 10706765888 11121528832 1746084176 17.569 96 20 41 0 1758266016 5688992 6492848
14:24:12 13724 8192000000 10693240704 11099635712 1698661488 17.174 94 23 46 0 1710272816 4698080 6913248
14:24:34 10134 8192000000 10689066432 11098423296 1728964608 17.427 97 23 46 2 1741555936 6016560 6574768
14:24:52 11153 8192000000 10683178624 11098697728 1734915056 17.476 97 11 22 4 1743247200 5359712 2972432
14:25:10 10878 8192000000 10697170512 11116322816 1759094768 17.677 98 30 59 0 1773435056 5805952 8534336
14:25:27 9251 8192000000 10712146128 11128422400 1765142016 17.727 98 28 56 0 1778723360 5090240 8491104
14:25:44 56039 8192000000 10715469920 11123638272 1747273472 17.579 96 33 66 1 1761391824 5252208 8866144
14:26:47 30801 8192000000 10732675136 11161124864 1783839616 17.881 98 15 30 2 1793158720 5248960 4070144
14:27:27 5017 8192000000 10756921040 11162750976 1825793120 18.225 100 31 62 2 1840104512 5474976 8836416
14:27:39 7299 8192000000 10743409648 11163480064 1816155440 18.146 99 45 88 1 1835003776 6016608 12831728
14:27:52 8931 8192000000 10766443600 11176820736 1837262688 18.319 100 24 46 0 1849333920 5868320 6202912
14:28:08 6899 8192000000 10744169728 11172327424 1821997008 18.194 99 21 41 1 1833281680 5238240 6046432
14:28:23 9472 8192000000 10759628080 11188146176 1847012736 18.398 100 24 47 2 1859720368 5236880 7470752
14:28:42 8518 8192000000 10771655088 11193344000 1851199328 18.432 100 26 53 0 1864215408 4713728 8302352
14:28:57 9205 8192000000 10764092224 11193688064 1856068128 18.471 100 15 30 1 1865919872 5473520 4378224
14:29:15 16248 8192000000 10774025888 11202437120 1861518576 18.516 100 30 61 3 1875988000 5486304 8983120
14:29:38 12516 8192000000 10782232608 11212333056 1865524928 18.548 100 20 40 1 1881378960 10354624 5499408
14:29:59 9578 8192000000 10786581824 11213914112 1869061536 18.577 100 23 46 0 1884958000 9839072 6057392
14:30:18 18293 8192000000 10800769456 11227791360 1882678560 18.687 100 6 12 1 1888837664 4595584 1563520
14:30:48 106201 8192000000 10843803488 11258925056 1900585312 18.831 100 36 71 1 1916170224 4819760 10765152
14:33:16 10681 8192000000 10852958832 11272294400 1919400080 18.982 100 44 87 0 1943879136 12086512 12392544
14:33:35 19638 8192000000 10868281376 11282911232 1926875056 19.042 100 64 125 1 1961056048 14643936 19537056
14:34:08 6314 8192000000 10869271120 11286024192 1928787424 19.057 100 61 122 0 1962677424 16644096 17245904
14:34:22 16011 8192000000 10880197664 11297222656 1934297680 19.101 100 67 134 0 1972867728 19404112 19165936
14:34:48 23643 8192000000 10875550704 11299897344 1936528272 19.119 100 59 116 1 1973547024 20577648 16441104
14:35:26 19221 8192000000 10878090512 11300278272 1935049952 19.107 100 36 72 0 1963002672 17317104 10635616
14:35:54 10535 8192000000 10880349104 11300933632 1941548240 19.159 100 50 100 1 1975144224 18461568 15134416
14:36:14 11606 8192000000 10883555008 11310145536 1944680368 19.184 100 52 103 1 1978665088 19448224 14536496
14:36:37 9436 8192000000 10881511392 11310817280 1943741296 19.177 100 34 69 2 1972687760 17859424 11087040
14:36:55 10611 8192000000 10892283744 11319857152 1955742624 19.272 100 63 125 0 1991418848 17516192 18160032
14:37:13 5968 8192000000 10896423888 11323482112 1953426672 19.254 100 45 90 0 1985794624 18751840 13616112
14:37:28 18390 8192000000 10892931600 11328110592 1957631184 19.287 100 48 93 0 1990599056 19329536 13638336
14:37:55 11691 8192000000 10908561008 11334533120 1968757312 19.376 100 52 102 2 2002755984 18827120 15171552
14:38:13 10154 8192000000 10903776144 11336941568 1965409216 19.349 100 48 96 1 2000565360 20419792 14736352
14:38:33 31949 8192000000 10904323616 11341791232 1947969088 19.210 99 39 77 1 1976348672 17595024 10784560
14:39:18 25821 8192000000 10922731360 11356258304 1974793408 19.423 100 38 76 1 2011551152 24945856 11811888
14:39:52 5598 8192000000 10932327152 11364081664 1983578368 19.493 100 54 107 5 2026406624 26046288 16781968
14:40:12 17485 8192000000 10928475648 11360403456 1976883664 19.440 100 45 90 2 2018142864 27298832 13960368
14:40:38 10738 8192000000 10938782416 11368267776 1983959344 19.496 100 47 94 1 2025902720 27776224 14167152
14:40:58 2605 8192000000 10950227232 11375669248 1990523392 19.548 100 57 114 0 2036960624 28487568 17949664
14:41:07 4404 8192000000 10948814624 11378044928 1997036752 19.599 100 74 148 0 2050485280 30486512 22962016
14:41:20 9944 8192000000 10951575296 11377184768 1994515696 19.579 100 60 118 3 2042466480 30093360 17857424
14:41:45 8445 8192000000 10944023552 11363889152 1978860304 19.456 99 57 111 1 2026671792 30629456 17182032
14:42:00 4816 8192000000 10955968112 11381448704 1993455648 19.571 100 52 104 1 2040459632 31283088 15720896
14:42:13 24425 8192000000 10955425408 11391057920 1999927856 19.622 100 58 116 0 2049821664 32274224 17619584
14:42:44 4518 8192000000 10962051008 11392618496 2004242048 19.656 100 60 118 0 2055874944 33605216 18027680
14:43:02 5005 8192000000 10979875488 11405852672 2012952688 19.725 100 73 145 0 2070209776 35376496 21880592
14:43:18 5423 8192000000 10996313136 11406114816 2010306992 19.704 100 85 170 2 2073017792 37162416 25548384
14:43:31 11457 8192000000 10983804528 11407695872 2012875760 19.724 100 79 156 0 2074368848 38438768 23054320
14:43:48 3075 8192000000 10986454384 11409924096 2014774352 19.739 100 72 141 0 2074260048 38720576 20765120
14:43:59 4027 8192000000 10999480640 11419213824 2018247040 19.766 100 76 152 4 2082446688 41370016 22829632
14:44:10 2098 8192000000 10988110576 11397672960 1999794336 19.621 99 82 165 1 2067167840 42145520 25227984
14:44:19 3780 8192000000 10997958336 11412123648 2011906544 19.717 100 65 130 0 2073449552 41501760 20041248
14:44:31 4929 8192000000 10992908912 11413237760 2014418240 19.736 100 80 156 4 2079658240 41241264 23998736
14:44:43 3538 8192000000 10991105264 11413635072 2011177808 19.711 100 75 146 2 2075464176 41615968 22670400
14:44:54 2286 8192000000 10996490336 11418341376 2016051808 19.749 100 83 164 1 2082694320 41293024 25349488
14:45:04 2796 8192000000 10982598160 11401625600 1993888416 19.575 99 84 168 0 2057078864 37184544 26005904
14:45:20 19477 8192000000 10981382112 11411042304 2003531984 19.651 100 72 142 1 2068064208 42144000 22388224
14:45:49 9334 8192000000 10959304800 11386470400 1967845664 19.368 99 59 119 0 2033554192 46709296 18999232
14:46:07 11826 8192000000 10959241088 11393941504 1971089552 19.394 99 61 120 0 2036063360 45633392 19340416
14:46:30 2001 8192000000 10968162912 11387518976 1984492048 19.500 100 82 161 2 2056527968 47017392 25018528
14:46:40 7964 8192000000 10978879488 11405467648 1995021680 19.583 100 76 152 2 2067179936 48492576 23665680
14:46:54 1127 8192000000 10985551040 11408207872 1997719776 19.605 100 63 127 0 2068677168 49813680 21143712
14:47:04 3151 8192000000 10976252704 11398193152 1965375712 19.349 98 75 150 1 2039138832 50302288 23460832
14:47:15 3681 8192000000 10970167776 11384406016 1950521024 19.231 98 77 152 1 2028926208 53887088 24518096
14:47:31 4235 8192000000 10979579968 11399516160 1984627792 19.501 100 77 153 1 2065819328 57409248 23782288
14:47:44 4077 8192000000 10994298928 11404275712 1975758176 19.431 99 84 168 3 2059205776 57806672 25640928
14:47:55 1650 8192000000 10953550368 11363250176 1953721520 19.256 99 81 157 1 2034155696 55895792 24538384
14:48:08 8768 8192000000 10979356768 11395473408 1988807984 19.534 100 84 166 1 2073456848 57752976 26895888
14:48:24 1390 8192000000 10984830784 11397173248 1974116032 19.418 99 88 173 2 2061330272 59142752 28071488
14:48:33 3057 8192000000 10985419088 11406221312 1990054272 19.544 100 75 149 0 2069851888 56648048 23149568
14:48:46 3496 8192000000 10993017056 11403816960 1973676352 19.415 99 79 158 2 2056538752 57322192 25540208
14:48:58 3176 8192000000 10994201280 11411771392 1994838192 19.582 100 84 166 2 2079122976 57184016 27100768
14:49:09 3029 8192000000 11006751856 11415785472 1996837232 19.598 100 82 163 3 2081893648 58901392 26155024
14:49:23 8145 8192000000 10998608720 11417161728 1992884320 19.567 100 68 134 3 2075505904 60308704 22312880
14:49:39 5970 8192000000 10990628112 11416678400 1999775776 19.621 100 70 132 0 2080420112 58647344 21996992
14:49:56 4679 8192000000 10987486736 11411562496 1997168320 19.600 100 74 144 1 2072406672 51197504 24040848
14:50:08 1799 8192000000 10985553328 11407937536 1993360608 19.570 100 78 157 1 2067539696 49859632 24319456
14:50:20 1507 8192000000 10965624912 11379011584 1960895760 19.313 99 84 168 1 2041642224 54740256 26006208
14:50:28 3175 8192000000 10979556272 11404632064 1991306944 19.554 100 77 152 0 2067324880 51826976 24190960
14:50:42 4662 8192000000 10979478496 11404414976 1986560384 19.517 100 64 128 1 2059506656 52422336 20523936
14:50:54 11131 8192000000 10942008960 11382956032 1936610336 19.120 98 41 82 1 1999581696 49062352 13909008
14:51:13 8241 8192000000 10963498080 11390439424 1960512976 19.310 99 62 122 3 2033227888 52412480 20302432
14:51:28 15298 8192000000 10964692064 11394260992 1954492000 19.262 99 47 94 1 2024948880 54230928 16225952
14:51:52 4117 8192000000 10971616992 11403149312 1983185952 19.490 100 57 114 1 2055092032 53123872 18782208
14:52:17 10905 8192000000 10952069264 11392782336 1951892912 19.242 99 50 100 2 2024591488 55327200 17371376
14:52:42 4068 8192000000 10973737168 11399897088 1982164688 19.482 100 61 123 0 2054916976 52928224 19824064
14:52:53 3245 8192000000 10979632016 11398934528 1963475088 19.334 99 75 151 1 2043669680 55238368 24956224
14:53:04 3078 8192000000 10979267136 11404173312 1981713088 19.478 100 59 118 0 2056346448 55239856 19393504
14:53:19 4594 8192000000 10968892784 11395305472 1964862400 19.345 99 65 130 3 2042227440 55972336 21392704
14:53:33 8928 8192000000 10954115008 11389394944 1949238928 19.220 99 40 80 0 2018375904 55514096 13622880
14:53:49 8526 8192000000 10962804432 11398541312 1971216800 19.395 100 34 68 2 2040445440 56869872 12358768
14:54:09 12186 8192000000 10944017984 11377786880 1938965552 19.139 98 42 84 0 2011905632 58421696 14518384
14:54:36 18387 8192000000 10927588000 11381526528 1946789856 19.201 99 44 88 1 2018059152 56038528 15230768
14:55:07 10108 8192000000 10935010656 11377016832 1957684992 19.288 100 37 74 3 2019612400 49657072 12270336
14:55:24 26139 8192000000 10923692992 11363553280 1933329072 19.093 99 33 66 0 1994474480 49719952 11425456
14:56:02 14063 8192000000 10917219056 11361402880 1935993856 19.115 100 33 65 0 1999700928 52120160 11586912
14:56:23 5276 8192000000 10913861296 11363049472 1936723168 19.121 100 31 62 1 2002239760 54611584 10905008
14:56:43 15917 8192000000 10897081200 11348873216 1908986736 18.899 99 34 68 2 1972652256 51199488 12466032
14:57:05 21530 8192000000 10911365616 11357560832 1930383648 19.070 100 28 56 1 1991246496 49964288 10898560
14:57:34 32645 8192000000 10917718416 11368804352 1934805392 19.105 100 24 48 2 2004719376 60497536 9416448
14:58:42 34999 8192000000 10871423312 11343998976 1909083296 18.899 99 20 40 0 1952723088 36885440 6754352
14:59:28 37344 8192000000 10860594784 11314749440 1910073136 18.907 99 10 20 0 1930193376 17583696 2536544
15:00:21 15608 8192000000 10870113136 11321917440 1933834528 19.098 100 18 36 0 1952171440 12963360 5373552
15:00:45 22600 8192000000 10871225248 11330514944 1942469472 19.166 100 13 26 0 1958779360 12758208 3551680
15:01:19 102633 8192000000 10885517552 11337760768 1933630848 19.096 99 35 70 0 1954881056 10784464 10465744
15:03:18 2460 8192000000 10905626176 11345924096 1941290656 19.157 99 46 92 1 1967106368 12603280 13212432
15:03:27 56377 8192000000 10881626752 11353284608 1954324608 19.261 100 19 39 0 1970643296 11501744 4816944
15:04:31 114158 8192000000 10871042528 11329146880 1885492960 18.709 96 28 56 1 1899764432 6802912 7468560
15:06:35 41177 8192000000 10878462816 11332378624 1932558704 19.087 99 18 37 0 1944046144 7186256 4301184
15:07:29 66573 8192000000 10888011248 11338076160 1926899632 19.042 98 24 49 1 1941769840 7618208 7252000
15:08:48 56693 8192000000 10880841040 11348717568 1942730512 19.169 99 14 27 0 1961291392 14793856 3767024
15:09:57 95693 8192000000 10906027264 11360120832 1952019776 19.243 99 16 32 0 1964061600 7564464 4477360
15:11:40 59299 8192000000 10877312416 11332976640 1909636176 18.904 97 20 39 1 1924746464 9304800 5805488
15:13:17 125620 8192000000 10893741680 11344367616 1946825808 19.201 99 23 47 1 1961098368 7406064 6866496
15:15:43 97833 8192000000 10882323712 11343536128 1893886304 18.777 96 24 48 0 1909640544 8595168 7159072
15:17:27 27490 8192000000 10882440496 11345027072 1945874048 19.194 99 41 82 2 1966887584 9504736 11508800
15:18:06 92196 8192000000 10881303040 11340013568 1908345280 18.893 97 21 42 1 1921858384 7797536 5715568
15:19:50 6453 8192000000 10898241136 11343884288 1959640784 19.303 100 22 42 2 1975838160 9601776 6595600
15:20:04 27019 8192000000 10882583808 11334504448 1936529488 19.119 98 30 61 2 1958295120 12190736 9574896
15:20:44 40081 8192000000 10902303792 11361280000 1954066000 19.259 99 20 40 1 1976870080 16433168 6370912
15:21:47 63448 8192000000 10901100144 11366006784 1976089648 19.434 100 29 57 3 2000584608 15521728 8973232
15:23:16 28499 8192000000 10898980448 11370610688 1976673200 19.438 100 17 34 1 1997743200 15943552 5126448
15:24:03 86799 8192000000 10900315152 11385036800 1981579504 19.477 100 21 42 1 2006011040 17993264 6438272
15:25:49 37814 8192000000 10886272112 11363196928 1939308688 19.141 98 10 20 1 1959306448 17098928 2898832
15:26:38 117547 8192000000 10908825168 11369738240 1967076288 19.362 100 5 10 1 1980542304 12284064 1181952
15:28:48 60614 8192000000 10924836544 11380912128 1974185792 19.419 99 40 80 1 1998187808 13180512 10821504
15:29:59 85868 8192000000 10918225344 11390840832 1974166160 19.418 99 23 46 1 1998634880 18113168 6355552
15:31:33 92013 8192000000 10879716912 11351642112 1888103584 18.730 95 17 34 2 1905719648 13738432 3877632
15:33:11 70060 8192000000 10892579792 11353747456 1875151072 18.626 95 20 40 0 1894504896 13471936 5881888
15:34:27 63425 8192000000 10896408464 11366154240 1916738000 18.961 97 22 44 0 1939846272 16932048 6176224
15:35:49 124286 8192000000 10876075152 11345731584 1885422032 18.709 96 12 24 0 1907588016 19045312 3120672
15:38:00 107729 8192000000 10872168736 11347308544 1865962592 18.552 95 18 36 1 1882489616 11633808 4893216
15:39:54 131861 8192000000 10869839696 11329310720 1807552464 18.076 92 11 22 0 1822123280 11607536 2963280
15:42:15 72386 8192000000 10842118320 11299909632 1862929728 18.527 96 16 32 0 1876012544 8227824 4854992
15:43:34 100036 8192000000 10838624880 11280347136 1784465072 17.886 92 24 48 0 1803180272 11861024 6854176
15:45:24 79524 8192000000 10811179344 11269255168 1863503840 18.532 98 19 38 1 1883205504 13714608 5987056
15:47:02 31800 8192000000 10833210192 11277328384 1827506880 18.239 96 25 50 0 1850048096 15264816 7276400
15:47:41 8589 8192000000 10854024336 11295379456 1909245312 18.901 100 49 99 2 1939521312 15497472 14778528
15:47:58 49122 8192000000 10852879440 11316776960 1926692208 19.040 100 26 52 0 1945728640 10753056 8283376
15:48:53 77992 8192000000 10853580960 11309494272 1856460096 18.475 96 20 39 2 1871000544 8883168 5657280
15:50:34 84062 8192000000 10848476064 11314683904 1854410896 18.458 96 14 28 1 1867838352 9769504 3657952
15:52:22 39723 8192000000 10832573904 11294154752 1899884992 18.825 99 9 18 0 1918565888 15874480 2806416
15:53:49 88343 8192000000 10844033120 11321491456 1898584656 18.815 99 16 32 0 1917549792 14117776 4847360
15:55:53 78724 8192000000 10842308960 11315822592 1888808688 18.736 98 14 28 0 1908051728 15159008 4084032
15:57:17 99987 8192000000 10855422368 11313176576 1862784928 18.526 97 11 22 1 1886366416 20552000 3029488
15:59:13 36075 8192000000 10868820096 11321790464 1908331664 18.893 99 22 44 0 1929105600 14528624 6245312
15:59:56 54139 8192000000 10897245872 11348250624 1950523616 19.231 100 23 46 0 1967395408 10786928 6084864
16:00:57 52515 8192000000 10855535696 11316051968 1896929200 18.802 97 13 26 0 1913732400 13299072 3504128
16:01:56 62173 8192000000 10887350864 11347378176 1913844384 18.937 98 13 26 1 1931912160 14531616 3536160
16:03:05 43469 8192000000 10888396592 11365384192 1964668976 19.343 100 16 32 0 1982547040 13681856 4196208
16:04:03 71244 8192000000 10890617840 11354628096 1920268832 18.989 98 12 24 0 1935241472 12094320 2878320
16:05:25 43453 8192000000 10899939376 11369807872 1971203328 19.395 100 12 24 0 1987121152 12956896 2960928
16:06:25 107580 8192000000 10907591792 11365871616 1940640976 19.152 98 23 46 1 1965656160 18854352 6160832
16:08:21 25674 8192000000 10926200384 11367309312 1975655712 19.430 100 48 95 4 1999766912 11496160 12615040
16:08:53 29380 8192000000 10925954064 11377520640 1959910736 19.305 99 48 95 1 1986364288 12551792 13901760
16:09:29 13119 8192000000 10921418000 11362889728 1939134080 19.140 98 46 92 0 1962734656 11193296 12407280
16:09:49 15233 8192000000 10922969088 11366653952 1968505664 19.374 100 56 112 2 1999740944 15577936 15657344
16:10:20 24084 8192000000 10913837152 11375226880 1967457584 19.365 100 34 68 0 1994037568 16887600 9692384
16:10:50 98694 8192000000 10869916768 11341344768 1879592192 18.662 95 17 34 0 1899088576 14785744 4710640
16:13:08 71258 8192000000 10894562704 11357118464 1941682928 19.160 99 27 54 3 1957578800 8107392 7788480
16:14:25 71631 8192000000 10896167536 11370901504 1956109520 19.275 99 19 38 0 1971701920 10460624 5131776
16:15:52 32122 8192000000 10914224960 11371380736 1963957872 19.337 99 21 42 0 1979071520 9333152 5780496
16:16:34 62026 8192000000 10897941152 11383377920 1982185712 19.482 100 13 26 0 1994473408 8429920 3857776
16:17:46 53633 8192000000 10906177184 11366903808 1949291712 19.221 98 7 14 0 1962293616 10948640 2053264
16:18:59 49998 8192000000 10901457216 11375157248 1949369712 19.221 98 14 28 0 1964828784 11067808 4391264
16:20:06 79470 8192000000 10915990064 11390418944 1986410464 19.515 100 14 28 1 2003173392 12593776 4169152
16:21:48 32883 8192000000 10904447216 11384225792 1970918720 19.393 99 18 37 2 1982831488 6892784 5019984
16:23:53 103229 8192000000 10868281312 11342794752 1845688224 18.387 93 16 32 0 1862900576 12756560 4455792
16:25:58 79956 8192000000 10905013472 11376447488 1950862352 19.233 99 25 50 0 1970544768 12552752 7129664
16:27:56 85238 8192000000 10885816096 11370799104 1911177456 18.916 97 12 24 0 1931374256 16591280 3605520
16:29:29 79489 8192000000 9195638864 9442865152 339420880 3.978 18 3 6 0 342842144 2805776 615488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-11-2020 16:31:45 to 05-11-2020 16:32:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-11-2020 16:32:16 to 05-11-2020 16:32:18.

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          231651
MON$OLDEST_ACTIVE               231652
MON$OLDEST_SNAPSHOT             231652
MON$NEXT_TRANSACTION            231652
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                       2010816
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
:22: 
:23: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:24:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:25: 
:26: 
:27: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:28:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:29: 
:30: 
:31: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:32:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:33: 
:34: 
:35: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:36:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:37: 
:38: 
:39: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:40:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:41: 
:42: 
:43: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:44:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:45: 
:46: 
:47: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:48:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:49: 
:50: 
:51: mscs-test-161.budzdorov.ru    Thu Nov  5 16:30:51 2020
:52:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:53: 
--- end of diff output ---

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

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