Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.01.2021 19:29
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 17338252 kB
MemAvailable 31438880 kB
Buffers 0 kB
Cached 14384608 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-03 19:27:10
DTS_END                         2021-01-03 19:27:10.9440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54280
TRN_ID                          236408
ATT_ID                          684
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: 8969.98 21302 1076398
customer order: creation 166.73 384 20007
customer order: refuse 14.48 371 1738
order to supplier: creation 44.65 1391 5358
order to supplier: removal 3.14 120252 377
invoice (draft): creation 44.36 3419 5323
invoice (draft): removal 51.51 764 6181
invoice accept: apply 41.30 19608 4956
invoice accept: cancel 47.06 816 5647
customer reserve: creation 3722.45 198 446694
customer reserve: removal 4546.18 66 545541
realization accept: apply 81.81 239 9817
realization accept: cancel 77.85 129 9342
payment from customer: creation 58.54 204 7025
payment from customer: removal 5.52 94 662
payment to supplier: creation 48.89 220 5867
payment to supplier: removal 3.43 161 411
service: total inventory turnovers 4.73 1084 568
service: total monetary turnovers 6.51 57 781
service: aggregate perf. data 0.83 19653 99
service: refresh index statistics 0.03 256927 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4338
TEST_TIME 2 3194
TEST_TIME 3 2895
TEST_TIME 4 3517
TEST_TIME 5 4059
TEST_TIME 6 4529
TEST_TIME 7 4775
TEST_TIME 8 5024
TEST_TIME 9 5149
TEST_TIME 10 6347
TEST_TIME 11 6670
TEST_TIME 12 6889
TEST_TIME 13 7372
TEST_TIME 14 7494
TEST_TIME 15 7567
TEST_TIME 16 7767
TEST_TIME 17 7908
TEST_TIME 18 8009
TEST_TIME 19 7901
TEST_TIME 20 8414
TEST_TIME 21 8462
TEST_TIME 22 8455
TEST_TIME 23 8511
TEST_TIME 24 8461
TEST_TIME 25 8351
TEST_TIME 26 8668
TEST_TIME 27 8929
TEST_TIME 28 9040
TEST_TIME 29 9303
TEST_TIME 30 10113
TEST_TIME 31 11165
TEST_TIME 32 10938
TEST_TIME 33 10788
TEST_TIME 34 10806
TEST_TIME 35 10570
TEST_TIME 36 10519
TEST_TIME 37 10363
TEST_TIME 38 10216
TEST_TIME 39 10057
TEST_TIME 40 10210
TEST_TIME 41 10062
TEST_TIME 42 10002
TEST_TIME 43 9845
TEST_TIME 44 9845
TEST_TIME 45 9759
TEST_TIME 46 9631
TEST_TIME 47 9719
TEST_TIME 48 9638
TEST_TIME 49 9677
TEST_TIME 50 9571
TEST_TIME 51 9420
TEST_TIME 52 9422
TEST_TIME 53 9450
TEST_TIME 54 9481
TEST_TIME 55 9545
TEST_TIME 56 9589
TEST_TIME 57 9548
TEST_TIME 58 9658
TEST_TIME 59 9594
TEST_TIME 60 9634
TEST_TIME 61 9655
TEST_TIME 62 9659
TEST_TIME 63 9680
TEST_TIME 64 9692
TEST_TIME 65 9679
TEST_TIME 66 9654
TEST_TIME 67 9649
TEST_TIME 68 9547
TEST_TIME 69 9523
TEST_TIME 70 9438
TEST_TIME 71 9391
TEST_TIME 72 9388
TEST_TIME 73 9397
TEST_TIME 74 9318
TEST_TIME 75 9327
TEST_TIME 76 9281
TEST_TIME 77 9306
TEST_TIME 78 9263
TEST_TIME 79 9339
TEST_TIME 80 9279
TEST_TIME 81 9287
TEST_TIME 82 9324
TEST_TIME 83 9444
TEST_TIME 84 9408
TEST_TIME 85 9438
TEST_TIME 86 9455
TEST_TIME 87 9401
TEST_TIME 88 9379
TEST_TIME 89 9483
TEST_TIME 90 9398
TEST_TIME 91 9312
TEST_TIME 92 9342
TEST_TIME 93 9331
TEST_TIME 94 9264
TEST_TIME 95 9257
TEST_TIME 96 9210
TEST_TIME 97 9158
TEST_TIME 98 9117
TEST_TIME 99 9101
TEST_TIME 100 9068
TEST_TIME 101 9084
TEST_TIME 102 9066
TEST_TIME 103 9075
TEST_TIME 104 9094
TEST_TIME 105 9083
TEST_TIME 106 9112
TEST_TIME 107 9100
TEST_TIME 108 9127
TEST_TIME 109 9137
TEST_TIME 110 9185
TEST_TIME 111 9151
TEST_TIME 112 9211
TEST_TIME 113 9214
TEST_TIME 114 9165
TEST_TIME 115 9104
TEST_TIME 116 9141
TEST_TIME 117 9119
TEST_TIME 118 9086
TEST_TIME 119 9048
TEST_TIME 120 8975

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-01-2021 19:29:33 to 03-01-2021 19:29:37.

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 1489874 1489874 0 0.00 0 35510 8 0 0
doc_list_biud 1489872 1489872 0 0.00 0 41567 30 0 0
sp_add_invoice_to_stock 5042 4956 86 1.70 20 225997 19608 0 86
sp_cancel_adding_invoice 5647 5647 0 0.00 5 81543 817 0 0
sp_cancel_client_order 1738 1738 0 0.00 4 19793 372 0 0
sp_cancel_customer_reserve 545541 545541 0 0.00 1 41569 66 0 0
sp_cancel_pay_from_customer 662 662 0 0.00 3 7580 94 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 30891 161 0 0
sp_cancel_supplier_invoice 6194 6181 13 0.20 2 12732 764 0 13
sp_cancel_supplier_order 377 377 0 0.00 7 984397 120253 0 0
sp_cancel_write_off 9342 9342 0 0.00 1 12642 129 0 0
sp_client_order 20007 20007 0 0.00 3 42697 384 0 0
sp_customer_reserve 446694 446694 0 0.00 0 119126 198 0 0
sp_fill_shopping_cart 30686 30686 0 0.00 1 18391 45 0 0
sp_fill_shopping_cart_clo_res 446689 446689 0 0.00 0 21418 13 0 0
sp_get_clo_for_invoice 4948 4948 0 0.00 0 24797 310 0 0
sp_kill_cost_storno 16062 16062 0 0.00 0 30881 65 0 0
sp_kill_qstorno_ret_qs2qd 1106982 1106982 0 0.00 0 41561 35 0 0
sp_kill_qty_storno 583591 583591 0 0.00 0 41565 75 0 0
sp_lock_selected_doc 20389 20389 0 0.00 0 8985 7 0 0
sp_make_cost_storno 27657 27657 0 0.00 0 33152 91 0 0
sp_multiply_rows_for_pdistr 27657 27657 0 0.00 0 32013 39 0 0
sp_multiply_rows_for_qdistr 20007 20007 0 0.00 0 40120 157 0 0
sp_pay_from_customer 7025 7025 0 0.00 4 34757 204 0 0
sp_pay_to_supplier 5867 5867 0 0.00 5 36370 221 0 0
sp_payment_common 12892 12892 0 0.00 1 32689 54 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 19785 341 0 0
sp_qd_handle_on_invoice_upd_sts 10595 10595 0 0.00 0 31870 353 0 0
sp_qd_handle_on_reserve_upd_sts 9817 9817 0 0.00 0 9458 62 0 0
sp_reserve_write_off 9817 9817 0 0.00 7 33355 240 0 0
sp_supplier_invoice 5323 5323 0 0.00 5 94847 3419 0 0
sp_supplier_order 5358 5358 0 0.00 6 41371 1391 0 0
srv_aggregate_perf_data 99 99 0 0.00 2673 247075 19654 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 996 162792 31204 0 0
srv_find_qd_qs_mism 1029753 1029753 0 0.00 0 27573 6 0 0
srv_make_invnt_saldo 568 568 0 0.00 39 56720 1084 0 0
srv_make_money_saldo 781 781 0 0.00 1 21431 58 0 0
srv_recalc_idx_stat 4 4 0 0.00 223050 311004 256927 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4956 4956 0 0.00 0 42087 209 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 38486 195 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 10816 25 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 7213 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 662 662 0 0.00 0 4557 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 5999 24 0 0
t$perf-norm:sp_cancel_supplier_invoice 388 388 0 0.00 0 2424 25 0 0
t$perf-norm:sp_cancel_supplier_order 377 377 0 0.00 0 29053 1768 0 0
t$perf-norm:sp_cancel_write_off 971 971 0 0.00 0 1702 6 0 0
t$perf-norm:sp_client_order 20007 20007 0 0.00 0 17759 19 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 17885 28 0 0
t$perf-norm:sp_pay_from_customer 7025 7025 0 0.00 0 8532 15 0 0
t$perf-norm:sp_pay_to_supplier 5867 5867 0 0.00 0 10727 16 0 0
t$perf-norm:sp_reserve_write_off 9817 9817 0 0.00 0 8169 14 0 0
t$perf-norm:sp_supplier_invoice 5323 5323 0 0.00 0 10410 23 0 0
t$perf-norm:sp_supplier_order 5358 5358 0 0.00 0 13678 19 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 446 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 1523 24 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 2307 34 0 0
t$perf-norm:srv_make_money_saldo 781 781 0 0.00 0 1184 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10068 9896 172 1.70 0 7441 18 0 172
v_all_customers 36334 36334 0 0.00 0 16 1 0 0
v_all_suppliers 29822 29822 0 0.00 0 23 1 0 0
v_all_wares 40014 40014 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 5899 21 0 0
v_cancel_client_order 3476 3476 0 0.00 0 5428 7 0 0
v_cancel_customer_prepayment 1324 1324 0 0.00 0 3913 8 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 5992 12 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 5905 18 0 0
v_cancel_supplier_invoice 802 776 26 3.24 0 4872 21 0 26
v_cancel_supplier_order 754 754 0 0.00 0 358 4 0 0
v_cancel_write_off 1942 1942 0 0.00 0 9126 18 0 0
v_max_id_clo_ord 5358 5358 0 0.00 0 520 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 1111 12 0 0
v_max_id_ord_sup 5321 5321 0 0.00 0 4003 5 0 0
v_max_non_paid_invoice 1635 1635 0 0.00 0 30742 21 0 0
v_max_non_paid_realizn 3891 3891 0 0.00 0 30742 13 0 0
v_min_id_clo_ord 5358 5358 0 0.00 0 12002 22 0 0
v_min_id_clo_res 981 981 0 0.00 0 4387 12 0 0
v_min_id_ord_sup 5321 5321 0 0.00 0 6404 8 0 0
v_min_non_paid_invoice 5867 5867 0 0.00 0 30957 26 0 0
v_min_non_paid_realizn 7025 7025 0 0.00 0 32506 35 0 0
v_our_firm 9948 9948 0 0.00 0 21 1 0 0
v_reserve_write_off 19634 19634 0 0.00 0 8457 9 0 0
x_lock_depdocs_on_canc_invoice 11440 11440 0 0.00 0 21445 145 0 0
x_lock_depdocs_on_canc_sup_ord 377 377 0 0.00 0 10679 425 0 0
x_make_qstorno_1000_1200 5358 5358 0 0.00 2 41367 1287 0 0
x_make_qstorno_1200_2000 5323 5323 0 0.00 2 94795 3269 0 0
x_make_qstorno_2100_3300 446694 446694 0 0.00 0 119102 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-01-2021 19:29:38 to 03-01-2021 19:29:42.

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:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:21 9183 8192000000 10139191504 10441875456 862891408 9.529 70 51 101 1 882016048 2430288 16694352
16:57:38 22895 8192000000 10306875776 10622586880 1349851280 14.146 100 85 171 0 1382341600 4058336 28431984
16:58:09 38177 8192000000 10373605648 10695892992 1415493792 14.733 100 91 182 1 1450863696 5838272 29531632
16:58:59 34616 8192000000 10408624720 10735792128 1452791088 15.062 100 87 174 0 1488916848 7502896 28622864
16:59:45 21259 8192000000 10419833744 10751180800 1476671648 15.272 100 89 178 1 1514062928 8447776 28943504
17:00:18 21969 8192000000 10449066608 10781523968 1500139616 15.477 100 92 184 0 1538654592 8669632 29845344
17:00:49 10944 8192000000 10448333520 10785456128 1509083072 15.555 100 84 168 1 1545840416 9535120 27222224
17:01:11 19858 8192000000 10465235264 10812542976 1527029968 15.711 100 81 162 1 1561828064 9421040 25377056
17:01:39 14787 8192000000 10506596768 10851041280 1556882432 15.969 100 81 162 1 1592086272 9466528 25737312
17:02:02 14715 8192000000 10515442944 10868391936 1579058528 16.160 100 82 162 1 1614354624 10201504 25094592
17:02:27 10547 8192000000 10549282048 10901803008 1598156080 16.324 100 73 146 1 1630766992 10806192 21804720
17:02:45 13598 8192000000 10570075376 10926780416 1627826192 16.576 100 81 163 1 1662886384 11281904 23778288
17:03:08 12161 8192000000 10600563280 10964176896 1651280128 16.775 100 79 158 1 1686540416 11927568 23332720
17:03:34 10527 8192000000 10620288160 10983866368 1682309120 17.037 100 78 156 0 1717966176 13162080 22494976
17:03:53 9610 8192000000 10641002976 11009347584 1692815024 17.125 100 86 170 2 1731390752 13834096 24741632
17:04:12 7817 8192000000 10648011744 11021987840 1710911568 17.276 100 76 152 0 1745553856 12993600 21648688
17:04:27 5664 8192000000 10661195024 11035656192 1720205344 17.354 100 78 151 1 1755040352 13276016 21558992
17:04:42 5744 8192000000 10679341248 11053391872 1739865792 17.518 100 82 164 1 1775787856 12703936 23218128
17:04:54 6592 8192000000 10688763584 11067125760 1750351696 17.605 100 78 157 2 1785580016 12466480 22761840
17:05:07 6772 8192000000 10715643440 11092070400 1765005904 17.726 100 77 155 0 1798987696 12033184 21948608
17:05:21 4417 8192000000 10703787856 11089182720 1775419072 17.812 100 68 133 1 1805489280 11498016 18572192
17:05:33 3517 8192000000 10726900144 11110596608 1785234576 17.893 100 81 162 3 1820070128 11901568 22933984
17:05:44 4035 8192000000 10730723488 11115732992 1798108640 17.998 100 83 164 2 1834137200 12924720 23103840
17:05:56 3687 8192000000 10742186432 11120144384 1800585216 18.019 100 85 168 0 1837670864 13356240 23729408
17:06:07 2481 8192000000 10750449952 11130204160 1808639664 18.085 100 89 176 1 1847348944 14277232 24432048
17:06:16 7530 8192000000 10748413536 11134357504 1810427232 18.099 100 88 175 0 1849552464 14757328 24367904
17:06:32 2711 8192000000 10769737488 11153227776 1814645664 18.134 100 83 166 0 1852264128 14927296 22691168
17:06:42 2442 8192000000 10772214576 11154382848 1829180016 18.253 100 87 174 1 1868068928 14913328 23975584
17:06:50 2471 8192000000 10776012464 11160354816 1834969648 18.300 100 93 186 1 1875517920 14437936 26110336
17:06:59 2496 8192000000 10774594944 11165835264 1837160128 18.318 100 81 162 1 1874036640 12991648 23884864
17:07:09 2273 8192000000 10780145344 11169243136 1841198384 18.351 100 86 171 1 1877643840 13088032 23357424
17:07:18 1661 8192000000 10787164448 11175149568 1847215056 18.399 100 87 174 1 1885570752 13378496 24977200
17:07:26 2795 8192000000 10798728720 11186384896 1855806464 18.469 100 95 188 1 1895973232 13920352 26246416
17:07:36 1637 8192000000 10800661888 11187970048 1857690320 18.485 100 93 185 0 1898053200 14363968 25998912
17:07:44 1954 8192000000 10802680144 11190439936 1858089728 18.488 100 90 179 5 1895861968 12703392 25068848
17:07:52 1682 8192000000 10800636576 11190370304 1857662000 18.484 100 86 172 2 1895507984 13154032 24691952
17:08:01 1479 8192000000 10804476688 11191902208 1866210752 18.554 100 93 186 2 1905751120 13805072 25735296
17:08:09 1177 8192000000 10806261888 11194552320 1864785408 18.542 100 95 192 4 1905770592 13457808 27527376
17:08:17 5544 8192000000 10795902352 11192672256 1863109488 18.528 100 77 152 0 1897463520 12546128 21807904
17:08:29 6488 8192000000 10812199568 11207168000 1869510320 18.580 100 79 159 1 1905031008 13250016 22270672
17:08:42 1955 8192000000 10812746048 11207110656 1872200272 18.602 100 89 178 2 1910929872 13837728 24891872
17:08:50 2004 8192000000 10809243792 11208966144 1873437248 18.612 100 72 145 1 1907460864 13955712 20067904
17:08:59 3499 8192000000 10811566192 11215597568 1874542096 18.621 100 61 123 0 1903136832 12097296 16497440
17:09:09 2514 8192000000 10815639280 11211583488 1876468192 18.637 100 63 127 0 1905245152 11158224 17618736
17:09:17 4524 8192000000 10817897920 11218366464 1881065648 18.674 100 73 146 2 1914433904 13181808 20186448
17:09:28 5139 8192000000 10792110432 11216539648 1878970592 18.657 100 48 96 0 1906549376 13854480 13724304
17:09:40 27019 8192000000 10815218448 11216175104 1879807104 18.664 100 52 105 3 1902101920 6407024 15887792
17:10:13 6826 8192000000 10793456240 11217080320 1877338608 18.644 100 24 46 1 1891022272 6524368 7159296
17:10:28 10367 8192000000 10784650592 11213344768 1878890160 18.656 100 22 44 0 1891255776 6401184 5964432
17:10:45 9393 8192000000 10785174960 11218546688 1878807424 18.655 100 18 37 1 1889681376 6365504 4508448
17:11:01 11026 8192000000 10783451360 11221819392 1880313616 18.668 100 17 34 1 1890550832 5319792 4917424
17:11:20 14889 8192000000 10795823360 11226800128 1887238448 18.724 100 18 36 0 1898449824 5732944 5478432
17:11:43 14802 8192000000 10787695504 11227435008 1889202448 18.739 100 20 40 3 1901817280 5991872 6622960
17:12:04 6498 8192000000 10801830560 11234381824 1893532576 18.774 100 23 45 1 1906178096 6198336 6447184
17:12:17 13599 8192000000 10797024528 11232845824 1892354464 18.765 100 13 26 1 1902469392 5397600 4717328
17:12:37 14509 8192000000 10811842304 11236675584 1894606496 18.783 100 19 38 2 1905873760 5202592 6064672
17:13:04 66602 8192000000 10823656608 11255582720 1903265824 18.853 100 27 54 1 1916189504 5287248 7636432
17:14:17 8616 8192000000 10813071968 11254706176 1903232592 18.852 100 22 44 1 1916438656 7281920 5924144
17:14:31 5245 8192000000 10821765296 11251449856 1903833344 18.857 100 26 52 1 1917192064 5521600 7837120
17:14:44 4865 8192000000 10813278240 11252703232 1903331008 18.853 100 23 46 2 1915282416 5378944 6572464
17:14:59 9562 8192000000 10811708656 11253719040 1905446096 18.870 100 24 48 0 1918901904 6739184 6716624
17:15:15 4583 8192000000 10831192512 11254960128 1904698528 18.864 100 28 56 2 1918808992 6309680 7800784
17:15:26 5810 8192000000 10819495088 11253768192 1901864864 18.841 100 30 60 1 1917561680 6171152 9525664
17:15:41 6707 8192000000 10831772384 11251306496 1885036224 18.706 99 30 60 4 1899319344 6016672 8266448
17:15:55 4371 8192000000 10811767568 11251568640 1907447600 18.886 100 48 97 2 1928623344 6411120 14764624
17:16:08 8382 8192000000 10811477488 11250233344 1902543520 18.847 100 17 34 1 1913601024 5753792 5303712
17:16:24 5208 8192000000 10815736864 11250475008 1899134416 18.819 100 19 38 0 1911567488 6902016 5531056
17:16:42 10298 8192000000 10794835456 11231002624 1856191840 18.472 98 22 44 2 1869375424 6410512 6773072
17:16:59 9714 8192000000 10796028048 11233460224 1886763008 18.720 100 19 38 1 1897715312 4983776 5968528
17:17:18 7828 8192000000 10792530464 11230625792 1870130848 18.585 99 21 40 4 1881781760 5186448 6464464
17:17:33 21272 8192000000 10784225232 11209449472 1796495264 17.985 95 25 49 3 1808445664 4950560 6999840
17:18:34 25200 8192000000 10774938768 11202297856 1814437792 18.132 97 17 34 0 1824740240 5333376 4969072
17:19:07 12755 8192000000 10728015376 11148910592 1695310624 17.146 92 21 41 4 1706654864 5347536 5996704
17:19:27 8770 8192000000 10719017440 11137966080 1746462160 17.572 96 18 36 1 1757056544 5298064 5296320
17:19:43 5854 8192000000 10701355536 11119812608 1784907680 17.890 99 26 52 2 1799157408 6391744 7857984
17:19:57 10980 8192000000 10695775808 11110133760 1715900560 17.318 96 30 61 0 1730920064 6008176 9011328
17:20:16 5955 8192000000 10707368864 11128623104 1756034608 17.652 97 24 46 2 1768725424 5727600 6963216
17:20:30 4248 8192000000 10710951584 11126861824 1783001024 17.874 99 41 82 0 1801195312 6329856 11864432
17:20:42 6055 8192000000 10698548256 11103924224 1702633904 17.207 95 28 58 0 1715323792 4459184 8230704
17:20:55 9287 8192000000 10689642032 11100930048 1715706224 17.316 96 24 48 2 1728050560 4952912 7391424
17:21:11 7121 8192000000 10685931344 11103178752 1746811616 17.575 98 38 76 2 1765313280 6753664 11748000
17:21:27 11251 8192000000 10689229616 11105112064 1757729808 17.666 98 26 52 0 1770516416 4941936 7844672
17:21:45 9110 8192000000 10718427840 11135565824 1787594432 17.912 99 18 36 1 1797243888 4761552 4887904
17:22:01 10553 8192000000 10707653456 11130691584 1785251584 17.893 99 29 58 2 1799285216 5325888 8707744
17:22:21 52260 8192000000 10758847696 11154460672 1817471136 18.157 100 34 67 1 1833276912 4961824 10843952
17:23:19 23875 8192000000 10729950304 11157098496 1811679632 18.110 99 26 53 1 1824356208 5304048 7372528
17:23:53 8195 8192000000 10750288064 11172409344 1828709760 18.249 100 33 66 0 1849550064 11216752 9623552
17:24:11 12069 8192000000 10755195456 11178332160 1839912880 18.340 100 35 70 2 1857487264 7680688 9893696
17:24:33 9109 8192000000 10747411968 11181858816 1844926384 18.381 100 30 59 0 1859968672 5703952 9338336
17:24:51 10574 8192000000 10758900704 11183894528 1848261056 18.408 100 25 49 1 1861112512 5737408 7114048
17:25:08 9312 8192000000 10767325776 11188719616 1850796512 18.429 100 30 60 2 1865666752 5352144 9518096
17:25:26 9373 8192000000 10767151136 11193290752 1853349168 18.449 100 32 65 2 1868400912 5386432 9665312
17:25:47 11743 8192000000 10767853328 11196665856 1857311136 18.481 100 18 37 2 1867274432 5159616 4803680
17:26:10 13865 8192000000 10776717360 11205079040 1860798336 18.510 100 23 46 2 1874071184 6436992 6835856
17:26:30 13233 8192000000 10779049696 11205824512 1864277232 18.538 100 25 46 3 1876299584 5307312 6715040
17:26:49 8765 8192000000 10771557344 11206000640 1862816800 18.526 100 19 38 0 1873753088 5714192 5222096
17:27:06 51303 8192000000 10819111616 11237175296 1884379328 18.700 100 24 48 0 1896120976 5369472 6372176
17:28:23 61880 8192000000 10841525376 11259723776 1910715056 18.912 100 40 80 2 1931627040 8501136 12410848
17:29:49 28550 8192000000 10851590016 11278635008 1921625920 19.000 100 39 71 5 1940727200 9118576 9982704
17:30:29 7147 8192000000 10854822192 11283550208 1927675952 19.048 100 43 86 1 1950247392 10297840 12273600
17:30:53 8859 8192000000 10867350512 11296047104 1936844112 19.122 100 41 82 2 1960710208 11860832 12005264
17:31:13 6766 8192000000 10872114080 11299983360 1941158544 19.156 100 49 98 0 1968311408 12544096 14608768
17:31:29 5891 8192000000 10885239552 11305103360 1943978736 19.178 100 49 98 3 1971029440 12468704 14582000
17:31:42 30128 8192000000 10881221120 11311071232 1946604304 19.199 100 47 94 1 1974282624 14615520 13062800
17:32:22 11539 8192000000 10880792272 11319799808 1953818000 19.257 100 41 82 0 1984497824 17991072 12688752
17:32:42 10910 8192000000 10894449312 11324633088 1957094576 19.283 100 43 86 2 1985057104 14676768 13285760
17:33:07 3296 8192000000 10917641360 11335225344 1969190400 19.379 100 58 116 2 2004007568 18099136 16718032
17:33:20 12000 8192000000 10924278832 11342692352 1970859808 19.392 100 57 114 3 2006378240 19069200 16449232
17:33:42 6230 8192000000 10921583264 11349004288 1978885536 19.456 100 65 130 0 2019082352 20715488 19481328
17:34:00 7684 8192000000 10929895632 11358121984 1979365776 19.460 100 53 106 0 2019022272 24379872 15276624
17:34:20 7901 8192000000 10934453184 11354202112 1982163296 19.482 100 52 103 3 2014808960 18168064 14477600
17:34:35 4228 8192000000 10928489120 11356250112 1983919280 19.496 100 58 116 2 2020301312 19403568 16978464
17:34:56 5712 8192000000 10930053440 11349164032 1961893008 19.321 99 58 115 1 1999852592 21604192 16355392
17:35:10 15918 8192000000 10935990384 11366207488 1984704976 19.502 100 59 118 0 2023182784 21505936 16971872
17:35:44 7180 8192000000 10929874800 11363024896 1985755328 19.510 100 53 106 0 2022779200 21580256 15443616
17:36:05 8071 8192000000 10939697952 11369811968 1990309616 19.546 100 61 122 0 2031222976 22754064 18159296
17:36:22 7145 8192000000 10938211392 11371716608 1988203376 19.530 100 48 96 1 2025282288 22629504 14449408
17:36:40 7291 8192000000 10940771696 11373191168 1992141472 19.561 100 54 106 2 2033257328 23638592 17477264
17:36:54 1399 8192000000 10947223184 11369447424 1975669040 19.430 99 71 140 0 2022011200 25135472 21206688
17:37:03 5881 8192000000 10958255056 11378089984 1993595104 19.572 100 72 144 2 2042377328 27577328 21204896
17:37:16 7267 8192000000 10940398720 11366764544 1984621632 19.501 100 76 151 1 2035226240 28188720 22415888
17:37:31 1712 8192000000 10953068480 11367968768 1985298816 19.507 100 81 162 1 2038749312 28617008 24833488
17:37:41 2793 8192000000 10941480368 11359617024 1982237088 19.482 100 77 151 0 2025150544 20772800 22140656
17:37:51 6189 8192000000 10938681184 11358502912 1985054560 19.505 100 69 136 1 2027145680 21609584 20481536
17:38:05 2016 8192000000 10929223632 11342188544 1960900832 19.313 99 85 165 0 2004831360 20580112 23350416
17:38:14 4678 8192000000 10908802448 11333865472 1960690512 19.312 100 65 130 1 2000147552 19973712 19483328
17:38:28 14715 8192000000 10927144832 11355627520 1971127648 19.394 100 53 105 1 2012978208 26817568 15032992
17:38:53 3331 8192000000 10945494464 11366486016 1980435392 19.468 100 56 112 0 2022437952 25233712 16768848
17:39:04 3257 8192000000 10939810176 11353665536 1975011264 19.425 100 81 160 2 2025499824 26027392 24461168
17:39:14 4307 8192000000 10945579184 11357368320 1959235936 19.300 99 85 170 0 2013195248 29485648 24473664
17:39:29 5118 8192000000 10933673232 11355045888 1968314032 19.372 100 75 148 1 2020545104 29494480 22736592
17:39:40 4253 8192000000 10923317888 11338956800 1952342368 19.245 99 83 163 2 2007061664 30278976 24440320
17:39:52 3787 8192000000 10933488800 11349823488 1969161328 19.379 100 77 152 0 2021492832 29269120 23062384
17:40:05 3407 8192000000 10922435200 11334950912 1954455632 19.262 100 77 154 1 2004486240 26955216 23075392
17:40:16 6782 8192000000 10923986800 11343548416 1962803184 19.328 100 69 138 0 2011178720 28292096 20083440
17:40:33 3282 8192000000 10915276544 11332059136 1948356096 19.213 99 72 143 0 1999587584 29281200 21950288
17:40:43 2296 8192000000 10943510080 11359158272 1975679712 19.430 100 83 165 2 2029696368 29805040 24211616
17:40:52 2461 8192000000 10931040672 11339231232 1956014016 19.274 99 90 180 1 2013378672 30139536 27225120
17:41:03 2788 8192000000 10923131424 11341996032 1946002192 19.195 99 74 145 0 1995074928 28043536 21029200
17:41:12 2685 8192000000 10887128608 11294228480 1914650048 18.944 98 79 158 0 1963096256 25330176 23116032
17:41:25 5376 8192000000 10907115760 11321376768 1942259312 19.165 100 69 135 3 1990492544 26907696 21325536
17:41:39 3607 8192000000 10915661072 11333050368 1947499792 19.207 100 74 147 1 1997496208 27663232 22333184
17:41:50 6482 8192000000 10927795936 11342221312 1958577968 19.295 100 72 144 2 2009089776 28287920 22223888
17:42:08 1592 8192000000 10932640496 11343298560 1958401104 19.293 100 75 148 1 2012206880 31015008 22790768
17:42:20 3172 8192000000 10927382000 11341086720 1943004784 19.171 99 79 160 1 1997382096 30525952 23851360
17:42:31 6874 8192000000 10941069200 11352756224 1964751472 19.344 100 85 168 1 2024671760 34001888 25918400
17:42:49 11358 8192000000 10949784816 11371626496 1968918224 19.377 100 72 143 1 2028405136 38008256 21478656
17:43:08 3163 8192000000 10921392144 11345600512 1940196320 19.148 99 65 130 1 1996719264 36763232 19759712
17:43:25 4446 8192000000 10936058800 11341156352 1952025120 19.243 100 84 168 1 2013116864 34898544 26193200
17:43:36 5840 8192000000 10936174976 11353010176 1958371104 19.293 100 74 144 0 2019589760 38760080 22458576
17:43:52 17849 8192000000 10944833472 11356119040 1951751264 19.240 99 68 135 2 2016917568 44167216 20999088
17:44:21 7497 8192000000 10951123296 11375955968 1969820864 19.384 100 55 110 1 2035636240 48129392 17685984
17:44:37 8674 8192000000 10942288400 11371823104 1947837552 19.209 99 55 110 1 2015308496 49611568 17859376
17:45:10 3462 8192000000 10961731872 11391397888 1982833680 19.487 100 57 111 2 2046444688 46298976 17312032
17:45:21 2342 8192000000 10964788496 11390865408 1980782192 19.471 100 55 110 1 2045237088 45618016 18836880
17:45:30 3350 8192000000 10977170208 11403382784 1993270336 19.570 100 62 124 0 2063360368 50839632 19250400
17:45:43 3744 8192000000 10956026800 11380797440 1970214768 19.387 100 62 122 1 2035117552 45560080 19342704
17:45:55 3758 8192000000 10971807776 11394699264 1985885424 19.511 100 71 142 1 2055771568 47682144 22204000
17:46:09 2284 8192000000 10989568208 11401617408 1991416448 19.555 100 89 177 2 2069238816 50216688 27605680
17:46:18 2587 8192000000 10961283392 11370135552 1963945552 19.337 99 82 162 1 2041095152 52149056 25000544
17:46:28 2109 8192000000 10964144896 11370909696 1965506496 19.350 99 77 154 1 2040276384 51882656 22887232
17:46:37 2733 8192000000 10990587488 11403186176 1990923808 19.551 100 92 185 0 2073646400 54467008 28255584
17:46:47 2842 8192000000 10996624096 11410317312 1993717920 19.573 100 84 168 0 2075250544 55422176 26110448
17:46:59 4672 8192000000 10995939728 11412324352 1994679792 19.581 100 81 160 1 2076450416 57137440 24633184
17:47:11 3827 8192000000 11013809904 11421282304 1999599088 19.620 100 88 176 0 2086411520 59050608 27761824
17:47:21 3127 8192000000 11013571760 11426365440 2006215424 19.672 100 90 178 2 2096926912 62771936 27939552
17:47:31 995 8192000000 10985302272 11390169088 1963582928 19.335 98 93 185 4 2055964464 63034256 29347280
17:47:39 1559 8192000000 11007647888 11418980352 1997541520 19.603 100 90 181 2 2089660384 63966224 28152640
17:47:47 1458 8192000000 10986582080 11421245440 1992276864 19.562 100 69 138 1 2071499264 57498304 21724096
17:47:59 1454 8192000000 10944859488 11361468416 1930291744 19.069 97 77 155 0 2006540864 52351952 23897168
17:48:09 9307 8192000000 10962873264 11385864192 1971305664 19.396 100 59 117 1 2043727456 54426640 17995152
17:48:29 5944 8192000000 10962667600 11398017024 1976343840 19.436 100 54 108 1 2049505456 55207024 17954592
17:48:47 20247 8192000000 10964729792 11401375744 1979890816 19.464 100 38 76 2 2048832480 55967232 12974432
17:49:20 6199 8192000000 10991561056 11408900096 1988067504 19.529 100 58 116 1 2065558160 58818832 18671824
17:49:33 2846 8192000000 10981266384 11405168640 1980954224 19.472 100 65 126 1 2061440208 60143296 20342688
17:49:46 7440 8192000000 10975506784 11398569984 1966299520 19.356 99 53 106 2 2039346128 56553072 16493536
17:50:03 7392 8192000000 10970472352 11383398400 1964853152 19.345 99 72 140 3 2045999456 58033104 23113200
17:50:17 4224 8192000000 10981512816 11408142336 1984661072 19.502 100 54 108 2 2061308144 58967376 17679696
17:50:33 7317 8192000000 10955508576 11388751872 1964053216 19.338 99 41 82 2 2037509904 59420640 14036048
17:50:49 9197 8192000000 10962724672 11397222400 1960331488 19.309 99 45 90 1 2032600880 57772624 14496768
17:51:05 10404 8192000000 10963655968 11397091328 1957525776 19.286 99 38 76 0 2028583168 58385968 12671424
17:51:24 8948 8192000000 10961087696 11401093120 1972638032 19.406 100 37 73 0 2044814864 60268800 11908032
17:51:51 18409 8192000000 10978161984 11413667840 1984154288 19.498 100 37 74 0 2059133520 61973792 13005440
17:52:27 8408 8192000000 10977723952 11409780736 1980077232 19.465 100 47 94 1 2061633760 65789600 15766928
17:52:43 12174 8192000000 10988428800 11424063488 1983894576 19.496 100 42 84 1 2068279376 69244960 15139840
17:53:02 15246 8192000000 10987027888 11426578432 1985641168 19.509 100 40 80 1 2071469488 71808848 14019472
17:53:30 14128 8192000000 10980660368 11435470848 1986906016 19.519 100 37 74 1 2067988352 68522800 12559536
17:53:53 12921 8192000000 10980011856 11429978112 1972146944 19.402 99 36 70 1 2049893440 65816864 11929632
17:54:13 8164 8192000000 10976451632 11432407040 1987000864 19.520 100 33 66 1 2064403952 65764688 11638400
17:54:46 32449 8192000000 10972545904 11425361920 1980637024 19.470 100 25 50 1 2054199904 64614016 8948864
17:56:14 44206 8192000000 10942699792 11407732736 1947857776 19.209 100 21 42 1 2024742272 68138064 8746432
17:57:22 22103 8192000000 10943222832 11402174464 1956664912 19.280 100 21 42 1 2028621552 64352368 7604272
17:57:54 23409 8192000000 10901805280 11367452672 1901396624 18.838 97 23 46 0 1957213552 49081824 6735104
17:58:56 16021 8192000000 10894503328 11326189568 1933194656 19.092 99 54 109 4 1954693072 5540368 15958048
17:59:26 15410 8192000000 10890368992 11325087744 1933393552 19.094 99 53 107 0 1957167600 9329632 14444416
17:59:51 25022 8192000000 10874681280 11308720128 1914613600 18.944 99 50 101 0 1939813616 10841312 14358704
18:00:22 59509 8192000000 10886655792 11325935616 1926321168 19.037 99 47 95 1 1949924720 9731328 13872224
18:01:30 10101 8192000000 10867425504 11329318912 1944874512 19.186 100 23 46 2 1961437360 9994416 6568432
18:01:46 49317 8192000000 10888083280 11339038720 1938682512 19.136 99 29 58 0 1953339120 6785104 7871504
18:02:43 147206 8192000000 10896544272 11349213184 1908271312 18.893 97 22 44 1 1921934864 8249296 5414256
18:05:18 162733 8192000000 10878719568 11358425088 1925953344 19.035 98 8 16 1 1944873968 16035504 2885120
18:08:08 105865 8192000000 10892604640 11362803712 1965940624 19.353 100 14 28 0 1978779856 8546736 4292496
18:10:21 123698 8192000000 10899906032 11385856000 1967383200 19.365 99 22 44 3 1988446848 14657840 6405808
18:12:43 44535 8192000000 10914318592 11387179008 1996095120 19.592 100 32 64 1 2018566768 12908976 9562672
18:13:33 8213 8192000000 10915859696 11385524224 1995936864 19.591 100 23 46 1 2013398064 11053824 6407376
18:13:50 36797 8192000000 10927139712 11402825728 2004863440 19.661 100 44 88 0 2031697040 13592752 13240848
18:14:52 36292 8192000000 10901616032 11357442048 1907620688 18.888 95 28 56 0 1924107840 8360032 8127120
18:15:36 34786 8192000000 10900433904 11369799680 1950053776 19.227 98 30 60 0 1971234032 12004112 9176144
18:16:22 21505 8192000000 10899522144 11368525824 1976735280 19.439 100 47 92 2 2002250352 10938000 14577072
18:16:55 53461 8192000000 10911940720 11379089408 1965929200 19.353 99 21 40 2 1982381584 10552000 5900384
18:17:55 80407 8192000000 10896398000 11362705408 1946035248 19.195 98 23 46 0 1973001936 19877056 7089632
18:20:37 75125 8192000000 10891432944 11370262528 1916582624 18.959 97 8 16 0 1935291664 16117216 2591824
18:22:07 50851 8192000000 10902976000 11370610688 1959530688 19.302 99 22 44 2 1976247472 10776432 5940352
18:23:04 75466 8192000000 10889990208 11367837696 1946327440 19.197 98 18 35 1 1965013456 13988816 4697200
18:24:27 34860 8192000000 10888972848 11342299136 1869510352 18.580 94 33 66 1 1888271312 9109200 9651760
18:25:08 84054 8192000000 10877474880 11353571328 1899667280 18.824 97 10 20 0 1912569312 10298560 2603472
18:26:38 84809 8192000000 10911536544 11385929728 1937852928 19.130 98 28 54 2 1966614896 21563760 7198208
18:28:10 147230 8192000000 10910140416 11386703872 1867710768 18.566 94 11 22 0 1885883824 15183232 2989824
18:30:48 66504 8192000000 10884437728 11344375808 1864631296 18.541 94 12 24 1 1875181888 7672976 2877616
18:32:00 52963 8192000000 10899579728 11344384000 1895612576 18.791 96 34 68 1 1914283904 9498000 9173328
18:33:00 25761 8192000000 10897268720 11346653184 1908664832 18.896 97 36 72 2 1930089216 11443984 9980400
18:33:39 54488 8192000000 10884358224 11348344832 1937280512 19.125 99 54 108 1 1969009792 15832944 15896336
18:35:08 76257 8192000000 10868921120 11328098304 1917089536 18.964 98 35 70 1 1935966592 8717776 10159280
18:36:33 64550 8192000000 10884402896 11339853824 1913386352 18.934 98 32 64 0 1935817520 13494240 8936928
18:37:50 45336 8192000000 10867108912 11345960960 1937097328 19.124 99 23 46 3 1956165248 12657952 6409968
18:38:56 70389 8192000000 10875138192 11361804288 1956033776 19.275 100 17 34 1 1979671168 17922224 5715168
18:40:15 44071 8192000000 10882013120 11357351936 1937735536 19.129 99 7 14 0 1951821520 12101648 1984336
18:41:07 91917 8192000000 10871549792 11349180416 1924844592 19.026 98 14 28 0 1937989728 8791280 4353856
18:43:24 104992 8192000000 10848667856 11318378496 1873896672 18.616 96 10 20 1 1893805168 17113152 2795344
18:45:28 65121 8192000000 10872335408 11331710976 1876549696 18.637 96 23 44 0 1894701264 12114800 6036768
18:46:53 83581 8192000000 10863365680 11334434816 1907460976 18.886 98 9 16 1 1920684672 10936592 2287104
18:48:25 134765 8192000000 10902411904 11371483136 1941956592 19.162 99 13 26 0 1967515712 21985424 3573696
18:50:50 63773 8192000000 10887439184 11343822848 1867890368 18.567 95 24 48 1 1885931440 10922176 7118896
18:52:10 94794 8192000000 10872057824 11341721600 1885208368 18.707 97 13 26 0 1898924304 10538864 3177072
18:53:51 53447 8192000000 10876023664 11312037888 1867914752 18.567 96 35 70 0 1890542768 13065408 9562608
18:54:55 16798 8192000000 10882421168 11321085952 1920352992 18.990 99 60 119 2 1949030976 12153280 16524704
18:55:22 27286 8192000000 10891742032 11342659584 1940478064 19.151 100 43 85 2 1963052560 10761872 11812624
18:55:56 87259 8192000000 10885721312 11352670208 1925381392 19.030 99 22 44 1 1952260912 20921344 5958176
18:57:30 138830 8192000000 10873473968 11349053440 1934188624 19.100 99 29 57 5 1957295312 15218608 7888080
19:00:08 114548 8192000000 10878982496 11362676736 1951992048 19.242 100 9 18 2 1975682960 21474880 2216032
19:02:09 38317 8192000000 10876633632 11365842944 1953720544 19.256 100 4 8 0 1973858800 18840304 1297952
19:02:55 46514 8192000000 10870772192 11344461824 1941780720 19.161 99 8 17 0 1950615152 6588800 2245632
19:03:52 52755 8192000000 10881948448 11348234240 1933675776 19.096 98 30 59 1 1948805392 7265984 7863632
19:05:46 81630 8192000000 10882202704 11373879296 1969327456 19.380 100 10 20 0 1983971440 11591744 3052240
19:07:29 51634 8192000000 10882824480 11365265408 1949936352 19.226 99 6 12 0 1964007696 12369376 1701968
19:08:32 50567 8192000000 10881743584 11352268800 1954551904 19.263 99 16 32 1 1970278144 11280064 4446176
19:09:39 38819 8192000000 10890445680 11365871616 1953248784 19.252 99 17 34 4 1969570240 11579872 4741584
19:10:26 47780 8192000000 10884914448 11357908992 1930839072 19.074 98 13 27 0 1948045856 12260064 4946720
19:11:21 40281 8192000000 10865660832 11329261568 1890568960 18.750 96 22 43 1 1904496960 7987200 5940800
19:12:17 29997 8192000000 10881476704 11342135296 1916783648 18.961 98 23 46 1 1931039312 8188336 6067328
19:13:00 69712 8192000000 10859035872 11334807552 1893977056 18.778 97 29 58 1 1915062576 12941472 8144048
19:14:18 58655 8192000000 10870533856 11347111936 1894442608 18.782 97 26 52 2 1913304288 11086944 7774736
19:15:23 134666 8192000000 10856810992 11335819264 1848846208 18.413 95 14 28 1 1872985456 19651120 4488128
19:18:29 61245 8192000000 10863315440 11344629760 1899402160 18.821 98 10 20 0 1919828960 17532112 2894688
19:19:36 93064 8192000000 10884477632 11331973120 1858510688 18.491 96 16 32 1 1877064432 14291120 4262624
19:22:15 86097 8192000000 10878609040 11342876672 1949299248 19.221 100 33 66 0 1971396592 12455232 9642112
19:23:50 40237 8192000000 10846639008 11306860544 1890650560 18.751 97 20 40 0 1907681712 11276224 5754928
19:24:39 46799 8192000000 10830237632 11304054784 1862288176 18.522 96 8 16 0 1872981600 8344496 2348928
19:25:32 45033 8192000000 10835021024 11311099904 1915815696 18.953 100 8 16 0 1926324128 8437808 2070624
19:26:24 14257 8192000000 10839892224 11313516544 1922502912 19.007 100 7 14 0 1935547280 11092032 1952336
19:26:45 6191 8192000000 10841658912 11319681024 1927034848 19.043 100 8 16 0 1940402848 11093488 2274512

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-01-2021 19:29:44 to 03-01-2021 19:30:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-01-2021 19:30:16 to 03-01-2021 19:30: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          236657
MON$OLDEST_ACTIVE               236658
MON$OLDEST_SNAPSHOT             236658
MON$NEXT_TRANSACTION            236658
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                       2030432
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 ---
:295: 
:296: mscs-test-161.budzdorov.ru    Sun Jan  3 19:27:26 2021
:297:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:298: 
:299: 
:300: mscs-test-161.budzdorov.ru    Sun Jan  3 19:27:26 2021
:301:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:302: 
:303: 
:304: mscs-test-161.budzdorov.ru    Sun Jan  3 19:27:27 2021
:305:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:306: 
:307: 
:308: mscs-test-161.budzdorov.ru    Sun Jan  3 19:27:37 2021
:309:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:310: 
--- end of diff output ---

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

03.01.21 19:30: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
2021-01-03 19:30:21 No severe PSQL-related problems occured
03.01.21 19:30:23. End of report.