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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17075252 kB
MemAvailable 31128268 kB
Buffers 0 kB
Cached 14648932 kB
SwapCached 3256 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-02-26 01:27:19
DTS_END                         2021-02-26 01:27:19.7400
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/55060
TRN_ID                          236101
ATT_ID                          653
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: 9135.61 23227 1096273
customer order: creation 167.82 388 20138
customer order: refuse 15.16 332 1819
order to supplier: creation 44.92 1303 5390
order to supplier: removal 3.29 99274 395
invoice (draft): creation 45.16 3386 5419
invoice (draft): removal 52.28 681 6273
invoice accept: apply 41.92 16350 5030
invoice accept: cancel 47.63 769 5715
customer reserve: creation 3780.08 164 453609
customer reserve: removal 4639.08 56 556690
realization accept: apply 81.16 193 9739
realization accept: cancel 90.70 103 10884
payment from customer: creation 57.58 120 6910
payment from customer: removal 5.78 70 694
payment to supplier: creation 48.28 142 5793
payment to supplier: removal 3.07 52 368
service: total inventory turnovers 4.66 1130 559
service: total monetary turnovers 6.11 26 733
service: aggregate perf. data 0.93 16979 111
service: refresh index statistics 0.03 323023 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-02-2021 01:29:07 to 26-02-2021 01:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2789
TEST_TIME 2 4418
TEST_TIME 3 4735
TEST_TIME 4 4711
TEST_TIME 5 4575
TEST_TIME 6 4502
TEST_TIME 7 4492
TEST_TIME 8 4436
TEST_TIME 9 4965
TEST_TIME 10 5450
TEST_TIME 11 5628
TEST_TIME 12 6031
TEST_TIME 13 7014
TEST_TIME 14 7038
TEST_TIME 15 7371
TEST_TIME 16 8213
TEST_TIME 17 8769
TEST_TIME 18 9066
TEST_TIME 19 9350
TEST_TIME 20 9759
TEST_TIME 21 9627
TEST_TIME 22 9984
TEST_TIME 23 10068
TEST_TIME 24 10690
TEST_TIME 25 11038
TEST_TIME 26 10756
TEST_TIME 27 10604
TEST_TIME 28 10561
TEST_TIME 29 10822
TEST_TIME 30 10727
TEST_TIME 31 10653
TEST_TIME 32 10385
TEST_TIME 33 10421
TEST_TIME 34 10257
TEST_TIME 35 10258
TEST_TIME 36 10104
TEST_TIME 37 9967
TEST_TIME 38 9882
TEST_TIME 39 9828
TEST_TIME 40 9614
TEST_TIME 41 9551
TEST_TIME 42 9455
TEST_TIME 43 9427
TEST_TIME 44 9499
TEST_TIME 45 9478
TEST_TIME 46 9365
TEST_TIME 47 9212
TEST_TIME 48 9318
TEST_TIME 49 9220
TEST_TIME 50 9292
TEST_TIME 51 9218
TEST_TIME 52 9303
TEST_TIME 53 9336
TEST_TIME 54 9349
TEST_TIME 55 9346
TEST_TIME 56 9425
TEST_TIME 57 9346
TEST_TIME 58 9391
TEST_TIME 59 9503
TEST_TIME 60 9430
TEST_TIME 61 9611
TEST_TIME 62 9573
TEST_TIME 63 9479
TEST_TIME 64 9379
TEST_TIME 65 9412
TEST_TIME 66 9373
TEST_TIME 67 9345
TEST_TIME 68 9321
TEST_TIME 69 9247
TEST_TIME 70 9261
TEST_TIME 71 9217
TEST_TIME 72 9197
TEST_TIME 73 9154
TEST_TIME 74 9099
TEST_TIME 75 9066
TEST_TIME 76 9119
TEST_TIME 77 9100
TEST_TIME 78 9229
TEST_TIME 79 9216
TEST_TIME 80 9229
TEST_TIME 81 9203
TEST_TIME 82 9214
TEST_TIME 83 9241
TEST_TIME 84 9236
TEST_TIME 85 9323
TEST_TIME 86 9330
TEST_TIME 87 9255
TEST_TIME 88 9201
TEST_TIME 89 9197
TEST_TIME 90 9165
TEST_TIME 91 9139
TEST_TIME 92 9094
TEST_TIME 93 9077
TEST_TIME 94 9047
TEST_TIME 95 9075
TEST_TIME 96 9051
TEST_TIME 97 9128
TEST_TIME 98 9096
TEST_TIME 99 9113
TEST_TIME 100 9164
TEST_TIME 101 9160
TEST_TIME 102 9235
TEST_TIME 103 9271
TEST_TIME 104 9211
TEST_TIME 105 9306
TEST_TIME 106 9306
TEST_TIME 107 9343
TEST_TIME 108 9317
TEST_TIME 109 9376
TEST_TIME 110 9324
TEST_TIME 111 9264
TEST_TIME 112 9260
TEST_TIME 113 9224
TEST_TIME 114 9236
TEST_TIME 115 9242
TEST_TIME 116 9218
TEST_TIME 117 9194
TEST_TIME 118 9155
TEST_TIME 119 9128
TEST_TIME 120 9142

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-02-2021 01:29:10 to 26-02-2021 01:29:14.

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 1516151 1516151 0 0.00 0 17524 6 0 0
doc_list_biud 1516150 1516150 0 0.00 0 32167 26 0 0
sp_add_invoice_to_stock 5166 5030 136 2.63 24 205577 16351 0 136
sp_cancel_adding_invoice 5715 5715 0 0.00 4 60782 769 0 0
sp_cancel_client_order 1819 1819 0 0.00 5 13425 332 0 0
sp_cancel_customer_reserve 556690 556690 0 0.00 1 32169 56 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 3 2602 70 0 0
sp_cancel_pay_to_supplier 368 368 0 0.00 2 1134 52 0 0
sp_cancel_supplier_invoice 6286 6273 13 0.20 1 13186 681 0 13
sp_cancel_supplier_order 395 395 0 0.00 7 1004014 99275 0 0
sp_cancel_write_off 10884 10884 0 0.00 1 14098 103 0 0
sp_client_order 20138 20138 0 0.00 3 19337 388 0 0
sp_customer_reserve 453609 453609 0 0.00 0 38934 165 0 0
sp_fill_shopping_cart 30931 30931 0 0.00 1 18565 41 0 0
sp_fill_shopping_cart_clo_res 453600 453600 0 0.00 0 16612 14 0 0
sp_get_clo_for_invoice 5021 5021 0 0.00 0 40574 315 0 0
sp_kill_cost_storno 17661 17661 0 0.00 0 11271 52 0 0
sp_kill_qstorno_ret_qs2qd 1130932 1130932 0 0.00 0 32163 30 0 0
sp_kill_qty_storno 596535 596535 0 0.00 0 32167 66 0 0
sp_lock_selected_doc 20633 20633 0 0.00 0 7997 6 0 0
sp_make_cost_storno 27462 27462 0 0.00 0 14981 55 0 0
sp_multiply_rows_for_pdistr 27462 27462 0 0.00 0 6051 29 0 0
sp_multiply_rows_for_qdistr 20138 20138 0 0.00 0 10452 182 0 0
sp_pay_from_customer 6910 6910 0 0.00 4 25893 121 0 0
sp_pay_to_supplier 5793 5793 0 0.00 5 15106 143 0 0
sp_payment_common 12703 12703 0 0.00 1 25887 37 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 13418 300 0 0
sp_qd_handle_on_invoice_upd_sts 10735 10735 0 0.00 0 25828 344 0 0
sp_qd_handle_on_reserve_upd_sts 9739 9739 0 0.00 0 16074 64 0 0
sp_reserve_write_off 9739 9739 0 0.00 6 16154 194 0 0
sp_supplier_invoice 5419 5419 0 0.00 5 81443 3386 0 0
sp_supplier_order 5390 5390 0 0.00 6 35193 1304 0 0
srv_aggregate_perf_data 111 111 0 0.00 2165 111804 16979 0 0
srv_fill_mon_cache_memory 144 144 0 0.00 167 124862 36388 0 0
srv_find_qd_qs_mism 1049472 1049472 0 0.00 0 17524 5 0 0
srv_make_invnt_saldo 559 559 0 0.00 41 71207 1130 0 0
srv_make_money_saldo 733 733 0 0.00 1 3027 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 154858 573138 323023 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 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 5031 5031 0 0.00 0 11192 160 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 7362 145 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 4024 12 0 0
t$perf-norm:sp_cancel_customer_reserve 754 754 0 0.00 0 14965 52 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 1574 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 368 368 0 0.00 0 425 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 486 10 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 16728 1456 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 1266 4 0 0
t$perf-norm:sp_client_order 20138 20138 0 0.00 0 16128 22 0 0
t$perf-norm:sp_customer_reserve 990 990 0 0.00 0 15122 25 0 0
t$perf-norm:sp_pay_from_customer 6910 6910 0 0.00 0 7469 10 0 0
t$perf-norm:sp_pay_to_supplier 5793 5793 0 0.00 0 13785 19 0 0
t$perf-norm:sp_reserve_write_off 9739 9739 0 0.00 0 7161 14 0 0
t$perf-norm:sp_supplier_invoice 5419 5419 0 0.00 0 6482 19 0 0
t$perf-norm:sp_supplier_order 5390 5390 0 0.00 0 5387 14 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 262 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 144 144 0 0.00 0 172 2 0 0
t$perf-norm:srv_make_invnt_saldo 559 559 0 0.00 0 2936 26 0 0
t$perf-norm:srv_make_money_saldo 733 733 0 0.00 0 1641 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10312 10040 272 2.63 0 11864 22 0 272
v_all_customers 36670 36670 0 0.00 0 166 1 0 0
v_all_suppliers 29826 29826 0 0.00 0 158 1 0 0
v_all_wares 40274 40274 0 0.00 0 79 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 2910 14 0 0
v_cancel_client_order 3638 3638 0 0.00 0 3869 6 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 2564 6 0 0
v_cancel_customer_reserve 1508 1508 0 0.00 0 2958 6 0 0
v_cancel_payment_to_supplier 736 736 0 0.00 0 531 4 0 0
v_cancel_supplier_invoice 850 824 26 3.05 0 2920 19 0 26
v_cancel_supplier_order 790 790 0 0.00 0 1166 5 0 0
v_cancel_write_off 2004 2004 0 0.00 0 3829 14 0 0
v_max_id_clo_ord 5386 5386 0 0.00 0 5676 2 0 0
v_max_id_clo_res 990 990 0 0.00 0 2662 15 0 0
v_max_id_ord_sup 5407 5407 0 0.00 0 3106 2 0 0
v_max_non_paid_invoice 1673 1673 0 0.00 0 3342 5 0 0
v_max_non_paid_realizn 3590 3590 0 0.00 0 5943 8 0 0
v_min_id_clo_ord 5386 5386 0 0.00 0 5946 7 0 0
v_min_id_clo_res 990 990 0 0.00 0 2594 6 0 0
v_min_id_ord_sup 5407 5407 0 0.00 0 8847 7 0 0
v_min_non_paid_invoice 5793 5793 0 0.00 0 5695 22 0 0
v_min_non_paid_realizn 6910 6910 0 0.00 0 25883 26 0 0
v_our_firm 10244 10244 0 0.00 0 166 1 0 0
v_reserve_write_off 19478 19478 0 0.00 0 5335 8 0 0
x_lock_depdocs_on_canc_invoice 11576 11576 0 0.00 0 18015 122 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 8371 377 0 0
x_make_qstorno_1000_1200 5390 5390 0 0.00 1 35007 1221 0 0
x_make_qstorno_1200_2000 5419 5419 0 0.00 3 81424 3241 0 0
x_make_qstorno_2100_3300 453609 453609 0 0.00 0 38932 148 0 0

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

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
22:57:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:29 5030 8192000000 10129860256 10419044352 867892688 9.579 71 58 122 0 890006976 2408512 19705776
22:57:43 20873 8192000000 10308262768 10619604992 1348423232 14.133 100 78 156 0 1377608384 4269744 24915408
22:58:14 21738 8192000000 10341679728 10658516992 1399091824 14.587 100 88 176 0 1434077584 5911824 29073936
22:58:52 4587 8192000000 10363434560 10684006400 1422223216 14.792 100 92 184 0 1459761632 6740096 30798320
22:59:07 17503 8192000000 10381415456 10705649664 1433912320 14.896 100 83 166 0 1468922096 7185024 27824752
22:59:40 23972 8192000000 10406112368 10733219840 1457468000 15.104 100 88 176 0 1494360720 7970336 28922384
23:00:12 7390 8192000000 10414610224 10743476224 1473110688 15.241 100 89 178 0 1510538464 8250944 29176832
23:00:31 18099 8192000000 10429442240 10764017664 1487748864 15.369 100 88 176 0 1524874720 8473600 28652256
23:00:57 20818 8192000000 10455890480 10794586112 1509393792 15.558 100 78 156 0 1543132304 8681072 25057440
23:01:28 12719 8192000000 10477370704 10822713344 1535747904 15.787 100 84 168 2 1571548880 9343728 26457248
23:01:51 15952 8192000000 10509080720 10856062976 1561798736 16.012 100 73 146 0 1593752768 9364464 22589568
23:02:15 11867 8192000000 10530986560 10884665344 1587529200 16.233 100 84 167 0 1623321296 10260752 25531344
23:02:38 14007 8192000000 10561842400 10917842944 1613447024 16.454 100 84 168 1 1649782512 10766064 25569424
23:03:01 14401 8192000000 10574680256 10937077760 1635818144 16.644 100 75 150 0 1669026640 10735552 22472944
23:03:24 19325 8192000000 10611508368 10975121408 1663242432 16.876 100 84 168 0 1700046240 12078368 24725440
23:03:51 4583 8192000000 10614935344 10983034880 1675654080 16.981 100 79 158 1 1711680112 13149552 22876480
23:04:07 11148 8192000000 10625788192 10995249152 1690860544 17.109 100 82 164 0 1727558080 12863104 23834432
23:04:26 11787 8192000000 10640070640 11013840896 1696725936 17.158 100 78 156 0 1732813808 13503120 22584752
23:04:46 8019 8192000000 10657729856 11032842240 1718388448 17.339 100 73 146 1 1752743584 13649120 20706016
23:05:03 9262 8192000000 10653309856 11032297472 1728715072 17.425 100 80 160 0 1765378080 13664288 22998720
23:05:20 5309 8192000000 10669009136 11048120320 1737047456 17.494 100 67 134 0 1768577312 11989152 19540704
23:05:32 6794 8192000000 10693689696 11071614976 1754579088 17.640 100 75 146 1 1788064256 12755024 20730144
23:05:46 4960 8192000000 10701340992 11078758400 1761140816 17.694 100 68 134 2 1793254272 13222832 18890624
23:05:57 4960 8192000000 10709786160 11092664320 1775040400 17.809 100 77 152 0 1808794064 13218112 20535552
23:06:13 8769 8192000000 10701104864 11091075072 1777080016 17.825 100 78 154 1 1812033008 13136528 21816464
23:06:31 3849 8192000000 10708588768 11094425600 1780998048 17.858 100 71 141 0 1812301888 12108080 19195760
23:06:42 5841 8192000000 10744689344 11125907456 1797678528 17.995 100 80 160 0 1833576656 12728416 23169712
23:06:54 2670 8192000000 10740131936 11128147968 1806452480 18.067 100 77 154 0 1839531312 11813776 21265056
23:07:04 3730 8192000000 10754093488 11138686976 1816113440 18.146 100 74 147 1 1849077184 12585824 20377920
23:07:15 2696 8192000000 10767386880 11152408576 1821890288 18.193 100 88 177 1 1860755104 13760000 25104816
23:07:24 3676 8192000000 10768886320 11154059264 1827360912 18.238 100 88 175 1 1866279648 14912576 24006160
23:07:34 2172 8192000000 10776738464 11157934080 1829522416 18.255 100 93 186 1 1870670288 15015136 26132736
23:07:43 2061 8192000000 10787926144 11170861056 1838975968 18.332 100 87 174 2 1877242608 13442080 24824560
23:07:51 1930 8192000000 10786423040 11169775616 1845708784 18.387 100 87 173 1 1883605120 13262400 24633936
23:08:00 2179 8192000000 10790484352 11175546880 1843922224 18.373 100 80 161 1 1879131328 12247712 22961392
23:08:10 2042 8192000000 10796194496 11181813760 1854023104 18.455 100 85 170 1 1890947696 12889696 24034896
23:08:19 1911 8192000000 10798035984 11181387776 1857260544 18.481 100 89 179 2 1895341664 12490432 25590688
23:08:27 1891 8192000000 10798423312 11190845440 1858876272 18.494 100 93 186 1 1900500240 13197472 28426496
23:08:36 1167 8192000000 10804636080 11193884672 1862704048 18.525 100 90 179 1 1900478736 12575584 25199104
23:08:43 2099 8192000000 10812565984 11202736128 1865398608 18.547 100 89 178 0 1904746240 14173680 25173952
23:08:51 3362 8192000000 10801086416 11203502080 1865751312 18.550 100 77 154 0 1898906416 11438368 21716736
23:09:01 17746 8192000000 10801495344 11200638976 1866656416 18.557 100 60 119 2 1893699632 10436224 16606992
23:09:26 9751 8192000000 10810531824 11209211904 1873414640 18.612 100 71 142 1 1903363680 9286192 20662848
23:09:42 1980 8192000000 10826509776 11219550208 1884769072 18.704 100 92 186 0 1923253168 11690544 26793552
23:10:00 6785 8192000000 10792328816 11211644928 1876535024 18.637 100 51 102 1 1900694624 10121920 14037680
23:10:14 6038 8192000000 10800622528 11216125952 1879313056 18.660 100 51 98 1 1901876944 8878432 13685456
23:10:28 1900 8192000000 10802345136 11213148160 1876852304 18.640 100 35 69 0 1898682112 12576384 9253424
23:10:39 2440 8192000000 10808539808 11220905984 1886275648 18.716 100 62 122 3 1910958416 7253168 17429600
23:10:48 3437 8192000000 10806813008 11221450752 1886053472 18.714 100 43 87 2 1905340816 6883120 12404224
23:11:01 6472 8192000000 10787488560 11213930496 1878948752 18.657 100 23 46 1 1892856800 7675184 6232864
23:11:14 2731 8192000000 10811434016 11225452544 1886577392 18.718 100 48 95 2 1908540688 8625568 13337728
23:11:26 2347 8192000000 10804441728 11228487680 1891887280 18.761 100 51 103 0 1915511104 8942016 14681808
23:11:36 3589 8192000000 10797166800 11229163520 1890163840 18.747 100 31 62 1 1906779632 7850240 8765552
23:11:51 9416 8192000000 10795877152 11227762688 1893188448 18.771 100 24 48 0 1906102272 6073840 6839984
23:12:10 5134 8192000000 10803535264 11233976320 1895960320 18.794 100 27 54 1 1911584656 6993312 8631024
23:12:23 8821 8192000000 10809543200 11238055936 1895252512 18.788 100 18 36 1 1910773808 9865808 5655488
23:12:39 5533 8192000000 10812763408 11240411136 1897507632 18.806 100 31 62 0 1912842032 6147744 9186656
23:12:53 11235 8192000000 10807544768 11231936512 1898606400 18.815 100 25 50 2 1911739120 5640848 7491872
23:13:11 64129 8192000000 10836709984 11250626560 1900838016 18.833 100 40 80 2 1918228864 4994848 12396000
23:14:21 7971 8192000000 10815887520 11251318784 1901368960 18.837 100 34 68 0 1919572688 8954160 9249568
23:14:36 6017 8192000000 10822821200 11248001024 1901578736 18.839 100 29 58 0 1915589888 5936448 8074704
23:14:49 6290 8192000000 10823994176 11252744192 1906152656 18.876 100 34 67 2 1922427872 7139264 9135952
23:15:02 5124 8192000000 10821087216 11256012800 1904591312 18.863 100 35 70 1 1922416528 8073040 9752176
23:15:14 8136 8192000000 10826779552 11261071360 1908017088 18.891 100 25 50 1 1921792480 6739248 7036144
23:15:29 3424 8192000000 10839335280 11261071360 1910644272 18.912 100 40 76 3 1928545680 6344544 11556864
23:15:39 6796 8192000000 10828774448 11261501440 1913547152 18.935 100 37 75 2 1929953680 5859728 10546800
23:15:53 5788 8192000000 10836791360 11265712128 1910899920 18.914 100 19 38 2 1921865824 5810304 5155600
23:16:05 5848 8192000000 10814141744 11244736512 1884519264 18.702 99 14 28 0 1894005152 4941744 4544144
23:16:24 6454 8192000000 10804776336 11241156608 1884239904 18.699 99 30 60 1 1897626400 4591616 8794880
23:16:38 49789 8192000000 10830911088 11248877568 1870571904 18.589 98 35 70 3 1885516160 4437520 10506736
23:17:35 17244 8192000000 10794625104 11236012032 1868272688 18.570 98 19 38 0 1879619760 5669408 5677664
23:17:58 5618 8192000000 10794624640 11228151808 1871188192 18.594 99 41 81 1 1888896224 5783632 11924400
23:18:14 6838 8192000000 10777708368 11202981888 1847737776 18.404 99 44 87 0 1867168496 7603648 11827072
23:18:30 5252 8192000000 10755951008 11181309952 1803649104 18.044 97 24 48 1 1816503104 6020400 6833600
23:18:42 5908 8192000000 10750264128 11157078016 1785699856 17.896 97 37 74 2 1802600304 5692880 11207568
23:18:57 8544 8192000000 10717100944 11141763072 1781413552 17.861 98 14 28 0 1790998768 5356528 4228688
23:19:14 10177 8192000000 10740270240 11150655488 1770869344 17.774 97 19 38 0 1781812160 5514640 5428176
23:19:31 5452 8192000000 10700879472 11111075840 1746896000 17.576 96 32 64 3 1762158288 5427664 9834624
23:19:43 7809 8192000000 10713197120 11123642368 1740197840 17.520 96 28 56 0 1754414576 6095504 8121232
23:20:00 7336 8192000000 10695279504 11106484224 1754918592 17.642 98 26 52 1 1769332176 6864944 7548640
23:20:14 9901 8192000000 10692316544 11111288832 1732910080 17.460 96 27 54 0 1747347776 6541392 7896304
23:20:31 6080 8192000000 10705396640 11115266048 1730428304 17.439 96 25 47 0 1742149472 4950688 6770480
23:20:45 65112 8192000000 10696921856 11117842432 1739853216 17.517 96 33 66 1 1754612816 5146128 9613472
23:21:56 16814 8192000000 10705419056 11120422912 1740513520 17.523 97 27 54 1 1753209872 5584816 7111536
23:22:22 8988 8192000000 10725949680 11147689984 1796826112 17.988 99 21 41 2 1809515104 6544432 6144560
23:22:37 3991 8192000000 10738527568 11150651392 1789090384 17.924 98 38 75 1 1807269280 7833088 10345808
23:22:50 9030 8192000000 10749381488 11164966912 1824893808 18.218 100 29 58 2 1839708192 6640784 8173600
23:23:07 8066 8192000000 10734412848 11147993088 1772994656 17.792 97 27 54 1 1788579584 7566304 8018624
23:23:22 11301 8192000000 10727021024 11149758464 1797565376 17.994 99 16 30 1 1807953120 5340320 5047424
23:23:40 5453 8192000000 10737454096 11163361280 1826041136 18.227 100 23 46 2 1838075600 5329344 6705120
23:23:54 8620 8192000000 10742261840 11169591296 1831957552 18.275 100 19 38 2 1842852352 5090656 5804144
23:24:09 8960 8192000000 10744814192 11163791360 1818301392 18.164 99 22 44 0 1829466192 4963664 6201136
23:24:26 11883 8192000000 10750119296 11178565632 1840019424 18.341 100 27 54 2 1858802704 10801776 7981504
23:24:45 10886 8192000000 10768014800 11185963008 1850595120 18.427 100 40 80 4 1868175104 6213648 11366336
23:25:03 17607 8192000000 10766370032 11185549312 1846371056 18.393 100 19 37 1 1858286848 6005840 5909952
23:25:27 8197 8192000000 10767379056 11192688640 1850862976 18.429 100 33 64 4 1866119952 6331504 8925472
23:25:41 68570 8192000000 10775674336 11199135744 1858118304 18.488 100 39 78 0 1875137456 4989216 12029936
23:26:56 7369 8192000000 10771256496 11202465792 1862301568 18.522 100 36 72 2 1879613312 7235920 10075824
23:27:09 7784 8192000000 10797732768 11220762624 1883551744 18.694 100 27 54 0 1896198608 4505136 8141728
23:27:25 89495 8192000000 10840572272 11265331200 1901026336 18.835 100 38 76 0 1920952112 8950480 10975296
23:29:02 9247 8192000000 10853093168 11275784192 1919223312 18.981 100 42 83 0 1946345600 14155632 12966656
23:29:19 18225 8192000000 10861825328 11287633920 1927633456 19.048 100 48 96 2 1957236208 15961088 13641664
23:29:45 22284 8192000000 10871593312 11298824192 1934444240 19.102 100 46 93 3 1964731392 16622864 13664288
23:30:15 21648 8192000000 10878588000 11307126784 1943255776 19.173 100 48 95 0 1972705696 15469424 13980496
23:30:45 27478 8192000000 10884180048 11317551104 1948285392 19.213 100 40 80 2 1977652528 17381728 11985408
23:31:27 24898 8192000000 10905081888 11333787648 1959657600 19.303 100 37 74 1 1988738912 17257632 11823680
23:32:02 27209 8192000000 10902368256 11342471168 1966763280 19.360 100 40 80 0 1998487184 20084896 11639008
23:32:36 14193 8192000000 10915853888 11350364160 1975212304 19.427 100 41 82 1 2010463360 23187984 12063072
23:33:00 18962 8192000000 10931627808 11362791424 1983081056 19.489 100 51 100 2 2023743984 24656656 16006272
23:33:35 17672 8192000000 10930813344 11363962880 1983681344 19.494 100 56 110 1 2027315632 25933168 17701120
23:34:18 19826 8192000000 10943930672 11376836608 1985004208 19.504 100 41 80 2 2023657840 26653744 11999888
23:34:49 10021 8192000000 10948795904 11380109312 1996097296 19.592 100 54 108 1 2040509152 27697696 16714160
23:35:06 9509 8192000000 10955330032 11387158528 2001605472 19.635 100 49 97 1 2043896256 27802976 14487808
23:35:23 9843 8192000000 10931256240 11375386624 1983127968 19.489 99 47 92 2 2026532208 29160144 14244096
23:35:44 10494 8192000000 10956241648 11389325312 2007930240 19.685 100 53 106 0 2054648992 30118048 16600704
23:36:02 1591 8192000000 10970861440 11398508544 2009091072 19.694 100 67 133 0 2061323776 31498240 20734464
23:36:12 3421 8192000000 10965977856 11400310784 2007944512 19.685 100 52 105 0 2056080912 32212976 15923424
23:36:23 6171 8192000000 10978030304 11403042816 2014034432 19.733 100 74 147 0 2067052832 31178176 21840224
23:36:38 8714 8192000000 10979917888 11405115392 2011310624 19.712 100 80 159 1 2069480880 33601376 24568880
23:36:59 7452 8192000000 10977382592 11407486976 2010218336 19.703 100 60 119 0 2061198768 33059936 17920496
23:37:14 6538 8192000000 10978771328 11412193280 2015441920 19.744 100 56 112 1 2067718432 34897872 17378640
23:37:28 4511 8192000000 10975468336 11413798912 2020438272 19.784 100 61 122 1 2074623392 35516000 18669120
23:37:40 5168 8192000000 10968253920 11397132288 2006501136 19.674 99 76 152 1 2063308592 34329536 22477920
23:37:54 1696 8192000000 10984699056 11411066880 2018776368 19.771 100 71 141 1 2073406896 33246160 21384368
23:38:03 6059 8192000000 10999821440 11420921856 2021726448 19.794 100 76 153 2 2084166448 40394832 22045168
23:38:18 2251 8192000000 11005533312 11420733440 2022569024 19.800 100 88 176 0 2087201904 38147968 26484912
23:38:27 4483 8192000000 10987383280 11408969728 2005693744 19.668 99 79 160 1 2068341536 38252304 24395488
23:38:37 2291 8192000000 10998770144 11417665536 2016837312 19.755 100 81 161 0 2081151104 40248896 24064896
23:38:48 3266 8192000000 10988610496 11414429696 2014268528 19.735 100 81 162 0 2080736736 41509552 24958656
23:39:00 4312 8192000000 10979210816 11404103680 1990439440 19.547 99 69 136 2 2054643024 42821088 21382496
23:39:11 1433 8192000000 10979388224 11406811136 1988478800 19.532 99 74 148 1 2053926480 42018032 23429648
23:39:21 2942 8192000000 10987806016 11400966144 1997347536 19.602 100 84 166 0 2066876496 43545984 25982976
23:39:32 7031 8192000000 10972180480 11397165056 1993778928 19.574 100 73 146 1 2060332448 43524768 23028752
23:39:48 15974 8192000000 10961048112 11401433088 1993039216 19.568 100 64 128 1 2058575424 45548032 19988176
23:40:10 2276 8192000000 10953745376 11374141440 1970104992 19.386 98 69 135 0 2033942944 42532784 21305168
23:40:19 3387 8192000000 10976808608 11388706816 1992586816 19.564 100 88 176 1 2059817856 39935424 27295616
23:40:29 3940 8192000000 10979993632 11401039872 1995151904 19.584 100 89 177 1 2064757472 42432320 27173248
23:40:40 4496 8192000000 10969779600 11400429568 1997983632 19.607 100 77 152 0 2061649488 40037072 23628784
23:40:53 6324 8192000000 10969163872 11397451776 1989695952 19.541 100 67 134 0 2052265040 41566304 21002784
23:41:06 3672 8192000000 10950092688 11361148928 1965220032 19.348 99 81 158 2 2031145632 41318880 24606720
23:41:17 10524 8192000000 10948768816 11376230400 1970491408 19.389 100 63 126 3 2034215648 44272496 19451744
23:41:36 1498 8192000000 10948942624 11369467904 1960040976 19.306 99 67 132 1 2026270992 45198176 21031840
23:41:53 3564 8192000000 10979149712 11397345280 1984471312 19.500 100 68 136 1 2055086272 49844528 20770432
23:42:08 1471 8192000000 10980367472 11396804608 1981045472 19.473 100 81 160 1 2058361648 52015680 25300496
23:42:16 7851 8192000000 10972162880 11401793536 1988551824 19.532 100 68 136 0 2062957984 52734192 21671968
23:42:32 3585 8192000000 10954444064 11388166144 1956719248 19.280 99 60 118 2 2027255296 50476128 20059920
23:42:42 4692 8192000000 10937348608 11364773888 1940365888 19.150 99 63 123 1 2011150544 51127504 19657152
23:42:54 3506 8192000000 10947823776 11371196416 1957694832 19.288 100 81 160 5 2037083072 53225488 26162752
23:43:07 5957 8192000000 10928369600 11352494080 1938906976 19.138 99 64 128 1 2012047664 52216512 20924176
23:43:21 3572 8192000000 10901318416 11333165056 1919963520 18.987 99 53 107 0 1985653840 48816608 16873712
23:43:47 9734 8192000000 10924259456 11351101440 1935796048 19.113 99 59 118 1 1999062448 44640320 18626080
23:44:10 9919 8192000000 10908282032 11341885440 1911538528 18.919 98 40 80 2 1965195248 40891024 12765696
23:44:31 3436 8192000000 10916872512 11343785984 1932915120 19.090 99 53 105 0 1986098064 36411664 16771280
23:44:41 14053 8192000000 10906730320 11352449024 1941904080 19.162 100 34 68 1 1990849376 37566304 11378992
23:45:02 12600 8192000000 10901006736 11357204480 1939321136 19.141 100 28 54 1 1988212368 40095536 8795696
23:45:35 18261 8192000000 10888371056 11334569984 1918968208 18.979 99 31 61 1 1964676304 35297952 10410144
23:46:19 33335 8192000000 10903947424 11354656768 1939576304 19.143 99 39 77 0 1993624704 41467488 12580912
23:47:03 22039 8192000000 10913944032 11366690816 1957330848 19.285 100 34 68 2 2007014320 39002656 10680816
23:47:36 10999 8192000000 10906926400 11358232576 1954209008 19.260 100 35 69 1 1998559264 32165840 12184416
23:47:53 21222 8192000000 10886736736 11347021824 1916602160 18.960 98 22 44 2 1955105680 31100144 7403376
23:48:27 32827 8192000000 10890467424 11344887808 1934055296 19.099 100 25 50 0 1978393072 36904128 7433648
23:49:33 41482 8192000000 10894586016 11358445568 1941535232 19.159 100 23 46 1 1986851744 36956496 8360016
23:50:21 23037 8192000000 10892103088 11353436160 1922035392 19.003 99 23 46 0 1966326432 35617344 8673696
23:51:01 28328 8192000000 10918346992 11367370752 1924335712 19.022 99 21 42 2 1970490640 39013776 7141152
23:51:46 19273 8192000000 10898865120 11371266048 1953161152 19.252 100 15 30 2 1991056208 32847216 5047840
23:52:19 76691 8192000000 10898623648 11344191488 1937404416 19.126 99 32 62 3 1962670544 15067328 10198800
23:53:59 53535 8192000000 10879189248 11333066752 1917661568 18.968 98 47 95 0 1946760560 14686800 14412192
23:55:11 42465 8192000000 10862417072 11311067136 1905129312 18.868 98 42 82 0 1931998080 15069840 11798928
23:56:02 1941 8192000000 10919623680 11336404992 1943354640 19.174 100 83 165 1 1986603472 18374032 24874800
23:56:10 6753 8192000000 10884717760 11326484480 1929533232 19.063 99 57 114 0 1966978896 20642704 16802960
23:56:34 29812 8192000000 10874187616 11343794176 1940824224 19.153 100 17 34 1 1965179936 19545696 4810016
23:57:13 60932 8192000000 10886368992 11355123712 1950013984 19.227 100 19 38 1 1973723664 18449616 5260064
23:58:21 57539 8192000000 10881721472 11347025920 1940272864 19.149 99 16 30 0 1960302128 15922144 4107120
23:59:41 85775 8192000000 10885804528 11365933056 1968546272 19.374 100 32 64 0 1991770256 13891968 9332016
00:01:13 64932 8192000000 10885617040 11352207360 1950916512 19.234 99 16 32 0 1966480272 11518608 4045152
00:02:37 40514 8192000000 10906214544 11359612928 1926304976 19.037 98 17 32 0 1946820224 15981344 4533904
00:03:24 46940 8192000000 10901807520 11362992128 1972247536 19.403 100 33 66 1 1990685472 9603056 8834880
00:04:28 116286 8192000000 10886761568 11359637504 1974095136 19.418 100 19 38 0 1989742656 10091632 5555888
00:06:30 69588 8192000000 10924182832 11371425792 1981108656 19.473 100 38 75 1 2001114624 8931408 11074560
00:07:50 3580 8192000000 10926537072 11366387712 1977551072 19.445 100 61 121 1 2008742592 13252256 17939264
00:08:09 69708 8192000000 10877515376 11354206208 1915189392 18.948 97 24 48 2 1941250768 19125680 6935696
00:10:08 83638 8192000000 10884418720 11362488320 1943470672 19.174 99 10 20 1 1963703184 17139840 3092672
00:11:45 44089 8192000000 10865475696 11339886592 1920994016 18.995 98 12 24 0 1939288544 14867808 3426720
00:12:41 46957 8192000000 10884702640 11353219072 1942526416 19.167 99 17 34 0 1958754512 11500032 4728064
00:13:34 55506 8192000000 10900023568 11367903232 1971938800 19.401 100 19 38 1 1988822496 11830912 5052784
00:14:55 41271 8192000000 10890052304 11342438400 1919275776 18.981 97 39 79 5 1944685600 13824048 11585776
00:15:43 50811 8192000000 10874896192 11354685440 1962163648 19.323 100 15 30 1 1980958448 14560944 4233856
00:16:40 34091 8192000000 10920615648 11370000384 1964393760 19.341 99 41 79 0 1985305584 9625216 11286608
00:17:20 39754 8192000000 10866950528 11352084480 1917139824 18.964 97 14 28 1 1936355504 15278032 3937648
00:19:03 58305 8192000000 10895747424 11372765184 1965806320 19.352 100 17 34 1 1989101472 18496816 4798336
00:20:20 124861 8192000000 10909773408 11367997440 1901313968 18.837 96 11 22 1 1918976480 14589680 3072832
00:22:31 112761 8192000000 10911520016 11384152064 1959667536 19.303 99 23 45 1 1981660848 15464032 6529280
00:24:30 21404 8192000000 10935837632 11378425856 1993422064 19.571 100 37 70 1 2013032160 9494736 10115360
00:24:59 66680 8192000000 10915253328 11387138048 1918219712 18.973 96 22 44 0 1938157072 13836256 6101104
00:26:12 70191 8192000000 10882560352 11345874944 1879577264 18.662 95 16 31 2 1901038800 16921824 4539712
00:27:28 14406 8192000000 10909555968 11348316160 1925837264 19.034 98 51 102 2 1946722720 7584160 13301296
00:27:49 37901 8192000000 10904264080 11360088064 1941255504 19.157 99 38 76 1 1969657136 17943712 10457920
00:28:37 67242 8192000000 10866841808 11331506176 1864111216 18.537 95 6 12 0 1884340224 18654560 1574448
00:29:55 58090 8192000000 10857367616 11310223360 1859686224 18.501 95 33 67 2 1875840832 6808224 9346384
00:31:34 20155 8192000000 10873359008 11329007616 1937848512 19.130 100 44 87 3 1958722848 8220272 12654064
00:32:11 81495 8192000000 10846480256 11316932608 1888830432 18.736 98 26 51 2 1908660384 12789712 7040240
00:34:01 7984 8192000000 10855964992 11329744896 1923477840 19.015 100 28 56 0 1947705472 16555408 7672224
00:34:15 26945 8192000000 10839834896 11302670336 1872820576 18.607 98 21 42 0 1896302288 17777232 5704480
00:34:49 88308 8192000000 10828940592 11297738752 1849539776 18.418 96 21 42 0 1867430688 11279184 6611728
00:36:29 39577 8192000000 10845763984 11310604288 1880843616 18.672 98 20 41 1 1898132128 11803792 5484720
00:37:41 54052 8192000000 10828827984 11297828864 1887411872 18.725 99 7 14 0 1898556960 9299152 1845936
00:39:20 71145 8192000000 10831913920 11312713728 1899013744 18.818 99 10 20 0 1910968400 9046976 2907680
00:40:41 16109 8192000000 10830136624 11317534720 1918656640 18.976 100 1 2 0 1928533056 9814288 62128
00:41:03 167 8192000000 10830151776 11317469184 1918655248 18.976 100 1 2 0 1928499104 9781728 62128
00:41:58 67119 8192000000 10873526752 11323404288 1848701504 18.412 95 15 30 0 1861879168 8680112 4497552
00:43:11 86699 8192000000 10860759136 11335266304 1884385248 18.701 97 17 34 1 1902063680 12850960 4827472
00:44:44 54664 8192000000 10866038480 11333758976 1924015120 19.019 99 18 36 2 1941909808 12750704 5143984
00:45:45 95724 8192000000 10858397040 11333148672 1882095216 18.682 97 14 28 0 1896687360 10534496 4057648
00:47:31 90612 8192000000 10880605696 11333169152 1905270416 18.869 98 22 44 0 1922686944 10787872 6628656
00:49:12 21559 8192000000 10893993552 11345412096 1953303264 19.253 100 41 82 1 1974384816 9918128 11163424
00:49:41 20013 8192000000 10894539696 11343851520 1937883040 19.130 99 47 94 0 1963281952 12441808 12957104
00:50:07 20724 8192000000 10918599104 11362078720 1962577472 19.327 100 51 103 0 1988748352 12273136 13897744
00:50:35 52987 8192000000 10883134368 11337728000 1881384880 18.676 96 33 66 0 1902216000 11678064 9153056
00:51:34 27095 8192000000 10890708528 11353137152 1952327072 19.245 100 29 58 1 1973157392 12792720 8037600
00:52:13 72919 8192000000 10877804880 11357868032 1931355648 19.078 99 19 37 1 1954068224 17774704 4937872
00:53:33 111831 8192000000 10879630336 11345428480 1917275184 18.965 98 18 36 0 1934602768 12402704 4924880
00:56:02 79226 8192000000 10884877248 11353104384 1938054784 19.131 99 28 56 0 1955590432 9722400 7813248
00:57:27 48614 8192000000 10863259568 11348217856 1918354720 18.974 98 12 24 0 1933100496 11519008 3226768
00:58:54 49617 8192000000 10878096048 11357663232 1965112560 19.347 100 9 18 0 1973561024 6643568 1804896
00:59:54 79177 8192000000 10889598448 11377098752 1954482128 19.262 99 7 14 0 1965383616 9079504 1821984
01:01:19 55615 8192000000 10892364960 11369246720 1941668432 19.160 98 10 20 0 1953824448 9884208 2271808
01:02:38 122581 8192000000 10904648576 11380088832 1949177808 19.220 98 18 36 1 1964997664 11108976 4710880
01:04:49 68699 8192000000 10905187840 11374600192 1930601536 19.072 97 21 42 1 1947793808 11029120 6163152
01:06:04 67738 8192000000 10918548080 11382341632 1948733808 19.216 98 17 34 1 1970022576 16919136 4369632
01:07:24 49012 8192000000 10913354928 11380490240 1958972160 19.298 99 16 32 0 1976487136 13169632 4345344
01:08:23 77429 8192000000 10892834496 11371540480 1944283168 19.181 98 9 18 0 1960971264 13999136 2688960
01:09:49 95630 8192000000 10897245904 11368017920 1901227424 18.836 96 17 34 1 1922687808 16491280 4969104
01:11:54 56825 8192000000 10871612112 11351441408 1904403920 18.862 97 34 67 4 1928647984 14322304 9921760
01:13:10 100889 8192000000 10874252704 11349803008 1896219216 18.796 97 10 18 1 1910422960 11389552 2814192
01:15:04 31902 8192000000 10897636864 11353616384 1907956848 18.890 97 40 80 3 1933558448 13850672 11750928
01:15:59 105929 8192000000 10843373024 11324375040 1830443232 18.263 94 12 24 1 1849523472 15724304 3355936
01:19:19 38477 8192000000 10845517344 11306643456 1868451584 18.572 97 26 50 0 1883487648 7956192 7079872
01:20:24 53092 8192000000 10846212160 11319246848 1914951648 18.946 99 27 54 0 1934309520 12047040 7310832
01:21:30 32853 8192000000 10864612736 11336728576 1932814176 19.089 100 11 23 0 1950343664 14507712 3021776
01:23:15 53003 8192000000 10844617664 11310518272 1919329696 18.981 100 10 20 0 1931620912 9404304 2886912
01:24:14 63899 8192000000 10854631472 11331133440 1936250000 19.117 100 14 28 0 1950616672 10461824 3904848
01:25:28 78567 8192000000 10889899312 11353587712 1948163344 19.212 100 16 32 0 1966832320 13266048 5402928
01:27:06 30987 8192000000 9276690832 9550893056 432773936 5.017 23 2 4 0 439139344 5971280 394128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 26-02-2021 01:29:21 to 26-02-2021 01:29:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 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:01, from 26-02-2021 01:29:52 to 26-02-2021 01:29:53.

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          236410
MON$OLDEST_ACTIVE               236411
MON$OLDEST_SNAPSHOT             236411
MON$NEXT_TRANSACTION            236411
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                       2018624
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:321: 
:322: mscs-test-161.budzdorov.ru    Fri Feb 26 01:27:43 2021
:323:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:324: 
--- end of diff output ---

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

26.02.21 01:29:54. 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-02-26 01:29:57 No severe PSQL-related problems occured
26.02.21 01:29:58. End of report.