Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.03.2021 22: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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17625672 kB
MemAvailable 31471496 kB
Buffers 0 kB
Cached 14047768 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-30 22:27:27
DTS_END                         2021-03-30 22:27:27.0410
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/43402
TRN_ID                          233882
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: 8910.48 19136 1069258
customer order: creation 169.28 329 20313
customer order: refuse 14.77 328 1772
order to supplier: creation 43.37 1301 5204
order to supplier: removal 3.42 96740 410
invoice (draft): creation 46.68 3430 5602
invoice (draft): removal 49.34 815 5921
invoice accept: apply 40.93 19198 4912
invoice accept: cancel 44.08 812 5289
customer reserve: creation 3829.86 190 459583
customer reserve: removal 4387.55 59 526506
realization accept: apply 82.03 174 9843
realization accept: cancel 72.54 113 8705
payment from customer: creation 57.98 110 6958
payment from customer: removal 5.59 65 671
payment to supplier: creation 48.23 128 5788
payment to supplier: removal 3.18 107 381
service: total inventory turnovers 4.54 1072 545
service: total monetary turnovers 6.33 35 760
service: aggregate perf. data 0.76 20544 91
service: refresh index statistics 0.03 237166 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-03-2021 22:28:52 to 30-03-2021 22:28:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5548
TEST_TIME 2 5992
TEST_TIME 3 5308
TEST_TIME 4 6101
TEST_TIME 5 5667
TEST_TIME 6 5788
TEST_TIME 7 5972
TEST_TIME 8 5826
TEST_TIME 9 5794
TEST_TIME 10 6003
TEST_TIME 11 6232
TEST_TIME 12 6241
TEST_TIME 13 6559
TEST_TIME 14 6763
TEST_TIME 15 7118
TEST_TIME 16 7251
TEST_TIME 17 7988
TEST_TIME 18 8552
TEST_TIME 19 8342
TEST_TIME 20 8651
TEST_TIME 21 9067
TEST_TIME 22 9157
TEST_TIME 23 9191
TEST_TIME 24 9312
TEST_TIME 25 9677
TEST_TIME 26 10335
TEST_TIME 27 10539
TEST_TIME 28 10516
TEST_TIME 29 10339
TEST_TIME 30 10213
TEST_TIME 31 10204
TEST_TIME 32 10074
TEST_TIME 33 9934
TEST_TIME 34 9819
TEST_TIME 35 9581
TEST_TIME 36 9669
TEST_TIME 37 9647
TEST_TIME 38 9534
TEST_TIME 39 9417
TEST_TIME 40 9376
TEST_TIME 41 9344
TEST_TIME 42 9320
TEST_TIME 43 9354
TEST_TIME 44 9186
TEST_TIME 45 9086
TEST_TIME 46 9240
TEST_TIME 47 9287
TEST_TIME 48 9264
TEST_TIME 49 9249
TEST_TIME 50 9327
TEST_TIME 51 9241
TEST_TIME 52 9429
TEST_TIME 53 9450
TEST_TIME 54 9478
TEST_TIME 55 9430
TEST_TIME 56 9346
TEST_TIME 57 9475
TEST_TIME 58 9532
TEST_TIME 59 9579
TEST_TIME 60 9558
TEST_TIME 61 9424
TEST_TIME 62 9403
TEST_TIME 63 9300
TEST_TIME 64 9241
TEST_TIME 65 9301
TEST_TIME 66 9290
TEST_TIME 67 9272
TEST_TIME 68 9208
TEST_TIME 69 9216
TEST_TIME 70 9176
TEST_TIME 71 9284
TEST_TIME 72 9269
TEST_TIME 73 9252
TEST_TIME 74 9275
TEST_TIME 75 9256
TEST_TIME 76 9247
TEST_TIME 77 9200
TEST_TIME 78 9284
TEST_TIME 79 9351
TEST_TIME 80 9326
TEST_TIME 81 9335
TEST_TIME 82 9306
TEST_TIME 83 9356
TEST_TIME 84 9272
TEST_TIME 85 9276
TEST_TIME 86 9222
TEST_TIME 87 9186
TEST_TIME 88 9149
TEST_TIME 89 9090
TEST_TIME 90 9053
TEST_TIME 91 9012
TEST_TIME 92 9054
TEST_TIME 93 9063
TEST_TIME 94 9102
TEST_TIME 95 9092
TEST_TIME 96 9117
TEST_TIME 97 9146
TEST_TIME 98 9141
TEST_TIME 99 9170
TEST_TIME 100 9132
TEST_TIME 101 9171
TEST_TIME 102 9157
TEST_TIME 103 9151
TEST_TIME 104 9226
TEST_TIME 105 9239
TEST_TIME 106 9275
TEST_TIME 107 9260
TEST_TIME 108 9187
TEST_TIME 109 9140
TEST_TIME 110 9102
TEST_TIME 111 9088
TEST_TIME 112 9037
TEST_TIME 113 9013
TEST_TIME 114 9046
TEST_TIME 115 9042
TEST_TIME 116 9007
TEST_TIME 117 8977
TEST_TIME 118 8940
TEST_TIME 119 8939
TEST_TIME 120 8922

Performance per minute, chart


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

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 1494603 1494603 0 0.00 0 18006 6 0 0
doc_list_biud 1494602 1494602 0 0.00 0 21126 27 0 0
sp_add_invoice_to_stock 4975 4912 63 1.26 30 204981 19198 0 63
sp_cancel_adding_invoice 5289 5289 0 0.00 4 71609 812 0 0
sp_cancel_client_order 1772 1772 0 0.00 4 9271 328 0 0
sp_cancel_customer_reserve 526506 526506 0 0.00 1 19577 60 0 0
sp_cancel_pay_from_customer 671 671 0 0.00 2 3754 66 0 0
sp_cancel_pay_to_supplier 381 381 0 0.00 3 9125 108 0 0
sp_cancel_supplier_invoice 5929 5921 8 0.13 2 21135 816 0 8
sp_cancel_supplier_order 410 410 0 0.00 6 889671 96741 0 0
sp_cancel_write_off 8705 8705 0 0.00 1 8029 113 0 0
sp_client_order 20313 20313 0 0.00 4 16015 329 0 0
sp_customer_reserve 459583 459583 0 0.00 0 63052 190 0 0
sp_fill_shopping_cart 31114 31114 0 0.00 1 21561 41 0 0
sp_fill_shopping_cart_clo_res 459578 459578 0 0.00 0 15862 14 0 0
sp_get_clo_for_invoice 4892 4892 0 0.00 0 33887 299 0 0
sp_kill_cost_storno 15046 15046 0 0.00 0 14837 56 0 0
sp_kill_qstorno_ret_qs2qd 1068048 1068048 0 0.00 0 21118 33 0 0
sp_kill_qty_storno 563337 563337 0 0.00 0 21123 70 0 0
sp_lock_selected_doc 20389 20389 0 0.00 0 8161 4 0 0
sp_make_cost_storno 27480 27480 0 0.00 0 15688 48 0 0
sp_multiply_rows_for_pdistr 27480 27480 0 0.00 0 9157 26 0 0
sp_multiply_rows_for_qdistr 20313 20313 0 0.00 0 11809 153 0 0
sp_pay_from_customer 6958 6958 0 0.00 4 15248 110 0 0
sp_pay_to_supplier 5788 5788 0 0.00 5 15521 129 0 0
sp_payment_common 12746 12746 0 0.00 1 13420 29 0 0
sp_qd_handle_on_cancel_clo 1772 1772 0 0.00 0 9242 306 0 0
sp_qd_handle_on_invoice_upd_sts 10180 10180 0 0.00 0 16173 308 0 0
sp_qd_handle_on_reserve_upd_sts 9843 9843 0 0.00 0 15115 58 0 0
sp_reserve_write_off 9843 9843 0 0.00 6 15781 175 0 0
sp_supplier_invoice 5602 5602 0 0.00 6 94945 3430 0 0
sp_supplier_order 5204 5204 0 0.00 5 19183 1301 0 0
srv_aggregate_perf_data 91 91 0 0.00 2607 399021 20544 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 2001 140014 33911 0 0
srv_find_qd_qs_mism 1022074 1022074 0 0.00 0 18006 6 0 0
srv_make_invnt_saldo 545 545 0 0.00 38 38057 1072 0 0
srv_make_money_saldo 760 760 0 0.00 1 10565 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 106096 427518 237167 0 0
t$perf-abend:sp_add_invoice_to_stock 63 63 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4912 4912 0 0.00 0 16034 184 0 0
t$perf-norm:sp_cancel_adding_invoice 373 373 0 0.00 0 15039 142 0 0
t$perf-norm:sp_cancel_client_order 1772 1772 0 0.00 0 4269 17 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 1579 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 671 671 0 0.00 0 824 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 381 381 0 0.00 0 1591 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 362 362 0 0.00 0 2419 16 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 24506 1696 0 0
t$perf-norm:sp_cancel_write_off 1027 1027 0 0.00 0 14206 36 0 0
t$perf-norm:sp_client_order 20313 20313 0 0.00 0 16411 23 0 0
t$perf-norm:sp_customer_reserve 984 984 0 0.00 0 4246 13 0 0
t$perf-norm:sp_pay_from_customer 6958 6958 0 0.00 0 3481 9 0 0
t$perf-norm:sp_pay_to_supplier 5788 5788 0 0.00 0 13468 18 0 0
t$perf-norm:sp_reserve_write_off 9843 9843 0 0.00 0 6792 12 0 0
t$perf-norm:sp_supplier_invoice 5602 5602 0 0.00 0 7313 23 0 0
t$perf-norm:sp_supplier_order 5204 5204 0 0.00 0 13837 25 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 287 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 760 19 0 0
t$perf-norm:srv_make_invnt_saldo 545 545 0 0.00 0 2730 45 0 0
t$perf-norm:srv_make_money_saldo 760 760 0 0.00 0 11171 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 9906 9780 126 1.27 0 2850 15 0 126
v_all_customers 37284 37284 0 0.00 0 17 1 0 0
v_all_suppliers 30360 30360 0 0.00 0 18 1 0 0
v_all_wares 40626 40626 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 746 746 0 0.00 0 1417 8 0 0
v_cancel_client_order 3544 3544 0 0.00 0 1444 4 0 0
v_cancel_customer_prepayment 1342 1342 0 0.00 0 3744 7 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 3310 7 0 0
v_cancel_payment_to_supplier 762 762 0 0.00 0 3344 14 0 0
v_cancel_supplier_invoice 740 724 16 2.16 0 2396 17 0 16
v_cancel_supplier_order 820 820 0 0.00 0 2166 6 0 0
v_cancel_write_off 2054 2054 0 0.00 0 2136 13 0 0
v_max_id_clo_ord 5204 5204 0 0.00 0 187 1 0 0
v_max_id_clo_res 984 984 0 0.00 0 1719 11 0 0
v_max_id_ord_sup 5596 5596 0 0.00 0 6801 6 0 0
v_max_non_paid_invoice 1408 1408 0 0.00 0 2888 5 0 0
v_max_non_paid_realizn 3570 3570 0 0.00 0 5016 6 0 0
v_min_id_clo_ord 5204 5204 0 0.00 0 9393 6 0 0
v_min_id_clo_res 984 984 0 0.00 0 5273 23 0 0
v_min_id_ord_sup 5596 5596 0 0.00 0 10085 11 0 0
v_min_non_paid_invoice 5788 5788 0 0.00 0 9246 18 0 0
v_min_non_paid_realizn 6958 6958 0 0.00 0 6626 15 0 0
v_our_firm 10118 10118 0 0.00 0 12 1 0 0
v_reserve_write_off 19686 19686 0 0.00 0 3469 6 0 0
x_lock_depdocs_on_canc_invoice 10848 10848 0 0.00 0 12534 119 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 21569 330 0 0
x_make_qstorno_1000_1200 5204 5204 0 0.00 2 19174 1229 0 0
x_make_qstorno_1200_2000 5602 5602 0 0.00 2 94655 3277 0 0
x_make_qstorno_2100_3300 459583 459583 0 0.00 0 63048 174 0 0

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

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:30 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:37 27071 8192000000 10257872448 10578567168 886275920 9.762 69 53 107 0 906889040 2568864 18044256
19:58:13 29392 8192000000 10350507504 10667122688 1398667056 14.583 100 84 168 0 1430161744 4717232 26777456
19:58:50 25905 8192000000 10393783344 10715758592 1449389760 15.032 100 91 182 0 1485043600 6560064 29093776
19:59:28 32906 8192000000 10417871776 10744115200 1468347808 15.199 100 90 181 0 1505967120 8039808 29579504
20:00:14 22607 8192000000 10445914976 10777522176 1492858128 15.414 100 93 186 0 1531014640 8550912 29605600
20:00:53 23008 8192000000 10467070848 10803322880 1513324448 15.592 100 84 168 0 1549417360 9813744 26279168
20:01:24 14481 8192000000 10488204192 10830749696 1541319024 15.835 100 85 171 0 1577804832 10121600 26364208
20:01:49 15662 8192000000 10511958704 10859581440 1570144160 16.084 100 86 170 1 1606721152 10240272 26336720
20:02:13 14782 8192000000 10529325152 10882162688 1585930816 16.219 100 82 164 0 1621739632 10959552 24849264
20:02:36 12281 8192000000 10551000320 10906333184 1608833088 16.415 100 83 166 1 1645300576 11946448 24521040
20:02:58 14091 8192000000 10582608720 10941865984 1640582704 16.685 100 87 174 1 1679115408 12803872 25728832
20:03:19 15883 8192000000 10607010672 10968268800 1662661200 16.871 100 90 180 1 1706964160 18080768 26222192
20:03:45 11094 8192000000 10611890592 10973466624 1674808624 16.974 100 87 173 1 1714306880 14161664 25336592
20:04:04 11567 8192000000 10635905584 11001245696 1692386640 17.121 100 85 170 1 1731081824 14037072 24658112
20:04:24 10167 8192000000 10643925664 11014205440 1702963856 17.210 100 86 172 1 1741300096 13577600 24758640
20:04:42 6029 8192000000 10651987984 11025768448 1714125312 17.303 100 81 160 1 1750840576 14268816 22446448
20:04:55 7577 8192000000 10669362944 11040940032 1728835184 17.426 100 87 174 1 1767236976 13406544 24995248
20:05:10 7367 8192000000 10685933936 11060969472 1746088656 17.569 100 85 170 0 1783319872 13051088 24180128
20:05:25 5166 8192000000 10690546608 11066327040 1756245808 17.653 100 83 167 0 1792746128 13446656 23053664
20:05:37 3679 8192000000 10708277584 11086094336 1768195264 17.752 100 82 163 1 1805035232 13433504 23406464
20:05:47 4195 8192000000 10712007200 11090604032 1770680736 17.773 100 77 154 2 1805413392 13398224 21334432
20:05:58 4688 8192000000 10718184080 11098103808 1782719248 17.872 100 81 162 1 1819243248 13271776 23252224
20:06:11 3747 8192000000 10735055792 11115114496 1794455696 17.968 100 91 182 2 1833031344 13822016 24753632
20:06:22 3400 8192000000 10745966016 11126325248 1801440080 18.026 100 90 180 0 1841109056 14791504 24877472
20:06:33 6414 8192000000 10732268576 11124166656 1802660000 18.036 100 81 159 0 1838505152 13471168 22373984
20:06:46 6230 8192000000 10751966704 11138871296 1812983584 18.120 100 81 162 1 1848885808 13420224 22482000
20:06:59 2045 8192000000 10763754048 11149008896 1829293248 18.254 100 89 178 0 1867443152 13057728 25092176
20:07:08 3280 8192000000 10774975904 11162099712 1833140416 18.285 100 94 189 1 1873350688 14642800 25567472
20:07:18 2768 8192000000 10777159408 11166244864 1840820016 18.347 100 86 170 1 1878131264 14227952 23083296
20:07:27 2184 8192000000 10784613232 11170140160 1840270896 18.343 100 87 175 2 1879243360 13583392 25389072
20:07:36 1771 8192000000 10783609712 11173711872 1846214400 18.391 100 91 180 1 1887077824 14602720 26260704
20:07:44 2304 8192000000 10795566784 11183702016 1852980560 18.446 100 88 177 1 1890859792 13582672 24296560
20:07:53 2183 8192000000 10801046496 11187646464 1855640368 18.468 100 89 177 1 1893902080 13646672 24615040
20:08:02 2834 8192000000 10794507264 11185577984 1855507664 18.467 100 88 177 1 1893927168 13783168 24636336
20:08:11 2777 8192000000 10804167760 11189682176 1858610976 18.492 100 88 174 2 1896938464 13225280 25102208
20:08:20 2295 8192000000 10803093584 11194400768 1861004304 18.511 100 89 178 0 1899947792 14151120 24792368
20:08:29 1594 8192000000 10812074128 11198672896 1865755632 18.550 100 97 193 2 1906904528 13559040 27589856
20:08:37 1680 8192000000 10813230816 11200643072 1865139216 18.545 100 84 169 0 1902308784 12655120 24514448
20:08:45 1313 8192000000 10814576144 11203674112 1870124224 18.585 100 90 179 2 1908194288 12286064 25784000
20:08:53 40457 8192000000 10794790816 11195875328 1865972896 18.552 100 60 120 3 1891702544 8810864 16918784
20:09:39 2032 8192000000 10809980880 11208523776 1874269760 18.619 100 92 185 1 1910406768 9597920 26539088
20:09:49 12318 8192000000 10807718528 11206758400 1872221584 18.602 100 63 127 2 1899555168 9721680 17611904
20:10:08 12591 8192000000 10781091792 11203268608 1872207312 18.602 100 47 96 5 1895472192 9568064 13696816
20:10:29 7461 8192000000 10784745984 11208888320 1873940448 18.616 100 31 58 0 1892602880 10087392 8575040
20:10:46 4735 8192000000 10799177024 11212107776 1879030976 18.657 100 45 90 1 1900137600 8926528 12180096
20:10:59 3964 8192000000 10793219728 11216232448 1877013536 18.641 100 40 80 0 1897125936 8531648 11580752
20:11:11 4510 8192000000 10790496208 11215339520 1877598592 18.646 100 35 70 1 1895538128 7875760 10063776
20:11:24 3680 8192000000 10787706512 11215233024 1879220160 18.659 100 42 85 3 1897965056 6717760 12027136
20:11:33 7716 8192000000 10791936912 11218358272 1880602288 18.670 100 32 64 2 1896529776 5981344 9946144
20:11:51 5901 8192000000 10788338032 11217670144 1883041024 18.690 100 30 60 3 1899208064 7791232 8375808
20:12:03 4174 8192000000 10806957824 11225407488 1884606624 18.702 100 34 64 3 1899884992 5607664 9670704
20:12:16 9615 8192000000 10786453008 11216478208 1883733136 18.695 100 27 54 2 1897614816 5487456 8394224
20:12:33 9823 8192000000 10784099984 11219484672 1882656272 18.687 100 13 26 2 1891700016 5264800 3778944
20:12:52 9773 8192000000 10795624832 11228798976 1889334368 18.740 100 19 38 1 1901702960 7056224 5312368
20:13:09 6384 8192000000 10803943136 11229921280 1891415280 18.757 100 23 46 1 1903963344 5826400 6721664
20:13:24 7154 8192000000 10805727600 11234934784 1895589648 18.791 100 30 60 4 1909434976 5371072 8474256
20:13:37 75066 8192000000 10839349840 11247136768 1900370704 18.829 100 50 101 0 1920682000 5824720 14486576
20:14:58 2124 8192000000 10840353872 11258482688 1911389680 18.918 100 78 158 3 1945525376 10333056 23802640
20:15:09 6910 8192000000 10813680944 11243921408 1899173120 18.820 100 25 50 4 1913358400 7148688 7036592
20:15:27 12960 8192000000 10817849888 11241054208 1878496832 18.653 99 42 81 2 1897257504 7274544 11486128
20:15:46 5741 8192000000 10809052672 11243524096 1897520576 18.806 100 31 61 0 1912392080 6708512 8162992
20:15:59 4292 8192000000 10810407680 11243540480 1898781536 18.816 100 32 59 4 1914319568 5707216 9830816
20:16:10 3910 8192000000 10828468544 11251441664 1903962240 18.858 100 46 92 2 1923694672 5280992 14451440
20:16:21 6380 8192000000 10815722576 11242020864 1895583520 18.791 100 27 54 3 1909805488 6667104 7554864
20:16:34 5427 8192000000 10822095600 11249147904 1899182576 18.820 100 22 44 1 1911198272 5329008 6686688
20:16:46 43881 8192000000 10834582256 11237793792 1884006352 18.697 99 32 63 6 1899495040 5617408 9871280
20:17:36 11754 8192000000 10804290080 11242049536 1875542336 18.629 99 16 32 0 1891065296 10506720 5016240
20:17:56 7738 8192000000 10805923104 11239669760 1880055632 18.666 99 39 78 5 1897783616 6279952 11448032
20:18:10 9717 8192000000 10791787920 11220975616 1834020608 18.292 97 26 52 1 1847508512 6176496 7311408
20:18:26 7633 8192000000 10801146688 11228078080 1884452272 18.701 100 35 70 1 1901435952 7264528 9719152
20:18:40 5782 8192000000 10759959200 11186663424 1795140704 17.974 96 27 54 1 1808818416 6031968 7645744
20:18:52 5158 8192000000 10751394512 11167178752 1791786256 17.946 97 26 52 1 1804874800 5640384 7448160
20:19:05 5014 8192000000 10755545824 11170828288 1805439520 18.059 98 21 42 3 1817537648 5905168 6192960
20:19:17 9040 8192000000 10746258928 11167948800 1814411296 18.132 99 25 50 0 1827027568 5128688 7487584
20:19:33 9926 8192000000 10734037856 11160444928 1767717392 17.748 96 22 45 1 1779893696 5716048 6460256
20:19:52 8302 8192000000 10717154384 11139051520 1767337232 17.745 97 16 32 1 1776575840 4762832 4475776
20:20:08 40725 8192000000 10683291552 11099344896 1736923968 17.493 96 23 46 0 1749645376 5719280 7002128
20:21:11 9555 8192000000 10691571744 11110936576 1747392576 17.580 97 26 52 2 1761123088 6130464 7600048
20:21:27 7925 8192000000 10702088384 11119865856 1762105584 17.702 98 30 58 1 1781252768 10540896 8606288
20:21:43 4043 8192000000 10705470432 11122954240 1780447360 17.853 99 38 75 3 1797892944 7082832 10362752
20:21:53 7952 8192000000 10689576000 11106365440 1776311952 17.819 99 28 55 1 1789503216 5265744 7925520
20:22:08 5450 8192000000 10714515520 11133886464 1783612896 17.879 99 23 45 0 1795716208 5629440 6473872
20:22:23 6606 8192000000 10693577504 11113975808 1785366432 17.894 99 41 81 1 1804129520 6196448 12566640
20:22:36 7602 8192000000 10706061824 11124723712 1767481968 17.746 98 31 62 0 1783022736 6270208 9270560
20:22:54 7187 8192000000 10705245440 11118600192 1781090192 17.858 99 29 58 0 1795142976 5657440 8395344
20:23:09 5587 8192000000 10722818848 11142262784 1808393312 18.083 100 28 57 4 1821663296 5241392 8028592
20:23:22 9783 8192000000 10734993424 11145859072 1801510400 18.026 99 22 44 1 1813436656 5176320 6749936
20:23:39 10985 8192000000 10744553632 11170201600 1834418320 18.295 100 27 55 1 1847964800 5107968 8438512
20:23:58 12215 8192000000 10749148416 11177041920 1819476800 18.173 99 12 23 1 1827809344 5413760 2918784
20:24:18 7718 8192000000 10756644336 11185848320 1844183456 18.375 100 20 40 4 1856492816 5919344 6390016
20:24:35 7570 8192000000 10764834496 11193729024 1850627344 18.427 100 23 45 1 1866828160 10314320 5886496
20:24:50 16280 8192000000 10781110320 11199668224 1858125056 18.488 100 31 62 2 1873388176 6090112 9173008
20:25:13 61473 8192000000 10781302256 11206565888 1858530400 18.491 100 22 41 2 1868855312 4073904 6251008
20:26:21 10084 8192000000 10781224624 11205111808 1858963344 18.495 100 21 40 0 1869853424 5283168 5606912
20:26:38 8500 8192000000 10786641024 11210461184 1862100592 18.520 100 27 54 3 1875162080 5499056 7562432
20:26:56 5607 8192000000 10783045408 11212681216 1864333888 18.538 100 15 30 1 1874811328 5675712 4801728
20:27:10 4572 8192000000 10800269616 11228626944 1886317504 18.716 100 34 68 3 1902510800 6731008 9462288
20:27:21 8244 8192000000 10818297584 11239907328 1893328144 18.773 100 30 60 2 1907790656 6203184 8259328
20:27:39 4695 8192000000 10838016608 11254616064 1905998032 18.875 100 51 102 4 1928174832 7933232 14243568
20:27:54 10016 8192000000 10851343680 11268444160 1912416304 18.926 100 59 118 2 1938600320 9468624 16715392
20:28:10 12366 8192000000 10845406736 11267387392 1918341040 18.974 100 54 108 2 1944066064 9815328 15909696
20:28:39 16533 8192000000 10866659376 11285495808 1926056832 19.035 100 59 118 1 1953572224 10457968 17057424
20:29:09 15212 8192000000 10867323904 11288428544 1933393648 19.094 100 58 114 2 1962870656 12613712 16863296
20:29:45 10628 8192000000 10882286768 11303473152 1942497664 19.167 100 58 114 0 1973194624 13838352 16858608
20:30:20 14280 8192000000 10896656720 11317190656 1948801888 19.217 100 53 104 0 1978437616 15495984 14139744
20:30:42 29272 8192000000 10886589776 11313381376 1947789824 19.209 100 45 89 1 1977285344 16325056 13170464
20:31:25 30117 8192000000 10883643040 11325587456 1950087072 19.227 100 39 77 0 1977276768 15479456 11710240
20:32:12 35994 8192000000 10902787376 11335516160 1959449856 19.302 100 40 80 2 1988640800 17118368 12072576
20:32:59 14122 8192000000 10911752672 11343851520 1968328080 19.372 100 49 97 2 2000739936 18221840 14190016
20:33:21 12910 8192000000 10928348272 11351891968 1974297648 19.420 100 59 116 0 2012136944 20666272 17173024
20:33:42 13075 8192000000 10919408144 11354402816 1976806048 19.439 100 51 100 0 2013392928 21565168 15021712
20:34:04 10823 8192000000 10930424896 11355373568 1978705712 19.454 100 51 102 0 2013422368 19743632 14973024
20:34:22 12098 8192000000 10928258128 11365175296 1984485408 19.500 100 54 108 2 2021478320 19776320 17216592
20:34:41 6698 8192000000 10934172816 11367145472 1987512736 19.524 100 60 118 1 2025103216 19473232 18117248
20:35:00 6196 8192000000 10939080352 11369852928 1991091504 19.552 100 62 121 2 2030184480 20926720 18166256
20:35:15 18607 8192000000 10940233872 11377287168 1992482848 19.563 100 48 93 2 2027713264 21402432 13827984
20:35:51 9193 8192000000 10943231760 11382976512 2000190880 19.624 100 44 88 0 2034917872 21218624 13508368
20:36:23 14204 8192000000 10971019552 11405320192 2014974640 19.741 100 63 122 0 2057437568 22717088 19745840
20:36:47 5050 8192000000 10968980944 11401502720 2016532656 19.753 100 63 126 3 2058038560 22830560 18675344
20:37:02 17419 8192000000 10975409888 11413569536 2020299168 19.783 100 55 110 0 2061793520 24464064 17030288
20:37:28 6057 8192000000 10985293344 11422859264 2028060016 19.843 100 59 116 1 2073967776 27857504 18050256
20:37:42 13177 8192000000 10974472128 11420385280 2028533456 19.847 100 52 103 0 2072215328 27512512 16169360
20:38:03 2757 8192000000 10975313744 11406082048 2013796944 19.731 99 69 136 1 2061052544 27048112 20207488
20:38:14 3510 8192000000 10992790704 11427225600 2028730720 19.849 100 71 140 1 2078565120 28413616 21420784
20:38:24 7250 8192000000 10976107152 11409743872 2019259024 19.774 100 62 124 1 2064388320 26624016 18505280
20:38:39 2959 8192000000 10979770000 11409072128 2022694080 19.801 100 69 137 1 2070725456 27632464 20398912
20:38:49 5147 8192000000 10984589056 11412250624 2020525008 19.784 100 76 152 0 2073084160 29065344 23493808
20:39:02 5082 8192000000 10989785776 11414867968 2019742128 19.778 100 81 162 0 2074346384 30550896 24053360
20:39:14 14637 8192000000 10996827696 11425783808 2025442336 19.823 100 74 147 1 2081837360 34229616 22165408
20:39:39 3209 8192000000 11005242336 11430899712 2033249184 19.884 100 85 171 0 2095047600 35883664 25914752
20:39:51 2604 8192000000 11010185968 11431706624 2032530080 19.878 100 78 157 0 2089083072 33110112 23442880
20:40:01 2756 8192000000 11006148128 11426725888 2027241312 19.837 100 86 173 1 2087584704 33430768 26912624
20:40:11 5852 8192000000 10986284400 11413315584 2011211200 19.711 100 71 142 1 2070338432 36729952 22397280
20:40:28 4506 8192000000 10983513872 11415146496 2016012720 19.749 100 69 137 1 2072139440 34636800 21489920
20:40:42 3618 8192000000 10993578672 11425206272 2023791728 19.810 100 71 140 2 2080786976 34906528 22088720
20:40:56 5586 8192000000 10987226096 11416109056 2013708432 19.731 100 59 118 2 2067693792 35254688 18730672
20:41:08 4041 8192000000 10991620976 11417300992 2007619712 19.683 99 67 134 4 2066100304 36207776 22272816
20:41:22 6816 8192000000 10999062480 11426668544 2021474480 19.792 100 76 150 2 2082208288 36754816 23978992
20:41:40 5320 8192000000 10988835264 11419586560 2000772608 19.629 99 68 134 0 2062127568 40620864 20734096
20:41:53 3210 8192000000 10988478496 11415457792 2013524208 19.729 100 75 150 0 2074770832 38604736 22641888
20:42:04 11463 8192000000 10996485264 11421507584 2014066272 19.734 100 67 134 0 2076321328 40703952 21551104
20:42:22 4178 8192000000 10969041696 11398127616 1991020048 19.552 99 59 117 3 2048763760 39098256 18645456
20:42:33 2000 8192000000 10986483184 11397398528 1996048064 19.592 99 90 179 2 2064964752 40635712 28280976
20:42:41 2943 8192000000 10998081824 11421069312 2012383552 19.720 100 88 176 2 2083108512 42449232 28275728
20:42:51 2153 8192000000 11005441152 11428110336 2020006896 19.780 100 84 168 3 2089491824 43270720 26214208
20:43:01 3713 8192000000 11005384192 11425030144 2022453376 19.799 100 85 170 0 2086962624 37712208 26797040
20:43:12 4479 8192000000 10974656496 11396288512 1969130496 19.379 98 85 169 0 2034617056 39150080 26336480
20:43:25 2365 8192000000 10979522768 11402833920 1997375280 19.602 100 78 155 0 2062263184 40687696 24200208
20:43:34 3774 8192000000 10984775280 11414036480 2005145968 19.663 100 81 160 3 2074242288 43433120 25663200
20:43:45 4125 8192000000 10989266384 11411623936 2001145440 19.632 100 81 162 2 2069156960 42514944 25496576
20:43:57 11606 8192000000 10969793344 11405058048 1993363840 19.570 100 63 126 0 2057803328 44234960 20204528
20:44:24 3718 8192000000 10973744128 11403358208 1992953744 19.567 100 72 144 1 2058394896 42645040 22796112
20:44:36 2952 8192000000 10952227376 11384733696 1969425920 19.381 99 69 137 1 2030217760 38394400 22397440
20:44:47 3295 8192000000 10951355856 11383967744 1983096432 19.489 100 61 120 2 2036842320 35207776 18538112
20:45:01 7539 8192000000 10935043664 11383455744 1977093952 19.442 100 36 72 1 2020651456 31888592 11668912
20:45:18 5702 8192000000 10944938224 11382767616 1961225056 19.316 99 51 101 5 2009974976 32908320 15841600
20:45:34 6940 8192000000 10945479760 11386175488 1982332544 19.483 100 52 104 1 2032950464 34311888 16306032
20:45:52 6414 8192000000 10945567664 11397341184 1990591760 19.548 100 41 82 1 2037223056 33225568 13405728
20:46:09 10615 8192000000 10958305216 11383894016 1984477552 19.500 100 53 100 0 2027482528 27119440 15885536
20:46:30 7384 8192000000 10952997264 11384119296 1987264192 19.522 100 71 139 1 2040045072 30603184 22177696
20:46:47 4603 8192000000 10958417376 11375312896 1949710928 19.224 98 78 156 0 2006613200 33179696 23722576
20:47:01 5193 8192000000 10927073184 11352023040 1950605456 19.231 100 63 126 3 2006961584 36203472 20152656
20:47:16 8018 8192000000 10918923088 11365134336 1956671728 19.280 100 46 92 1 2006330848 34866720 14792400
20:47:42 11044 8192000000 10894431488 11333320704 1906184784 18.876 97 41 80 0 1952897072 33962432 12749856
20:48:02 14908 8192000000 10886715488 11340972032 1926430848 19.038 99 25 50 0 1970288016 35157408 8699760
20:48:48 12884 8192000000 10908515472 11355107328 1939147472 19.140 99 32 64 1 1981898864 32314288 10437104
20:49:12 16880 8192000000 10885870672 11339046912 1900328752 18.829 97 24 48 3 1938193424 29852000 8012672
20:49:40 12128 8192000000 10860730224 11293782016 1823916560 18.210 94 27 54 1 1860556704 27709776 8930368
20:50:13 10477 8192000000 10869044912 11294322688 1887914128 18.729 99 36 72 1 1933206192 33471552 11820512
20:50:30 3820 8192000000 10901200656 11320975360 1920659184 18.992 100 68 136 1 1977984384 35388992 21936208
20:50:41 5445 8192000000 10897128256 11332427776 1926444432 19.038 100 48 96 0 1978374096 36301792 15627872
20:50:53 10872 8192000000 10879094096 11323465728 1905728144 18.872 99 31 62 0 1952877536 35868960 11280432
20:51:11 20095 8192000000 10860328720 11306778624 1878206048 18.651 98 29 59 1 1924467520 35907840 10353632
20:51:39 9060 8192000000 10855023376 11294056448 1879844848 18.664 99 28 56 3 1923859728 34192144 9822736
20:51:57 26784 8192000000 10847941024 11303415808 1886655504 18.719 99 30 61 2 1936482384 39596976 10229904
20:52:31 24097 8192000000 10836685056 11275128832 1873778512 18.615 99 20 40 2 1912701200 31234080 7688608
20:53:02 22608 8192000000 10850649456 11303796736 1902404224 18.846 100 20 40 0 1939609936 30509296 6696416
20:53:31 41804 8192000000 10851925344 11305844736 1884263280 18.700 99 15 30 0 1911756816 22388960 5104576
20:54:27 35094 8192000000 10827231024 11277623296 1873344480 18.611 98 21 42 2 1892677248 12152144 7180624
20:55:08 31866 8192000000 10805726608 11253108736 1864638128 18.541 99 13 24 0 1880136304 11872832 3625344
20:55:52 25976 8192000000 10832870576 11271188480 1882061296 18.682 99 28 56 1 1899930032 9922672 7946064
20:56:44 28034 8192000000 10837639616 11291656192 1897704496 18.808 99 16 32 1 1911155872 9040416 4410960
20:57:23 21606 8192000000 10837880736 11294777344 1912962944 18.930 100 7 14 1 1926935264 12014704 1957616
20:57:51 30161 8192000000 10826543072 11282190336 1895958688 18.794 99 5 10 0 1908100912 11029424 1112800
20:58:27 59556 8192000000 10836396624 11270844416 1829194720 18.253 96 15 26 2 1842409552 10372416 2842416
20:59:34 110991 8192000000 10856926480 11308605440 1913551200 18.935 99 24 48 0 1928068720 7622096 6895424
21:01:32 74670 8192000000 10850517008 11284660224 1841373584 18.352 95 38 76 1 1860221504 7611456 11236464
21:03:02 98902 8192000000 10860970720 11313987584 1904539856 18.863 99 27 54 1 1921654960 9807712 7307392
21:04:54 61269 8192000000 10846441408 11320926208 1928629008 19.056 100 16 32 0 1947764752 14578528 4557216
21:06:03 21226 8192000000 10839593552 11306180608 1905319984 18.869 99 6 12 0 1922146400 15066256 1760160
21:06:34 9548 8192000000 10854816160 11296301056 1910239680 18.909 99 24 49 1 1929167984 12749616 6178688
21:06:51 8280 8192000000 10876655056 11315568640 1919153344 18.980 99 61 118 1 1944896784 8882400 16861040
21:07:08 18751 8192000000 10867936688 11317026816 1923937456 19.018 99 43 86 0 1949314048 13268544 12108048
21:07:42 53012 8192000000 10850477392 11309420544 1924536112 19.023 99 24 48 1 1944299344 12229248 7533984
21:08:46 36803 8192000000 10886914336 11332612096 1946673536 19.200 100 29 58 1 1967788016 11994048 9120432
21:09:31 39028 8192000000 10880358224 11337351168 1952309040 19.245 100 42 84 0 1976178320 11835392 12033888
21:10:24 74476 8192000000 10880060304 11351519232 1963377520 19.333 100 13 26 0 1981858880 14163856 4317504
21:11:50 38319 8192000000 10881086048 11357540352 1961125328 19.315 100 8 16 1 1979059072 15462064 2471680
21:12:34 9079 8192000000 10884489152 11356045312 1964429792 19.341 100 13 23 2 1980634304 12785584 3418928
21:13:24 36339 8192000000 10880821056 11358347264 1963062896 19.330 100 11 20 0 1976551296 10163008 3325392
21:14:07 52088 8192000000 10879401952 11355328512 1947001184 19.203 99 18 36 1 1962258352 10051600 5205568
21:15:10 44652 8192000000 10903922192 11360567296 1974443776 19.421 100 21 43 0 1987849536 6952208 6453552
21:16:01 21343 8192000000 10904146528 11365986304 1983185648 19.490 100 46 89 1 2002957104 6362352 13409104
21:16:28 61913 8192000000 10899500784 11373604864 1966110528 19.355 99 30 60 0 1982849328 8883792 7855008
21:18:07 44072 8192000000 10927277776 11383701504 1988893472 19.535 100 22 45 2 2006916624 12035104 5988048
21:19:06 140014 8192000000 10910650640 11391221760 1950604480 19.231 98 12 24 1 1968971552 14710304 3656768
21:22:01 69003 8192000000 10902058096 11361542144 1900337008 18.829 96 15 30 1 1912952176 8452128 4163040
21:23:20 48487 8192000000 10937941728 11383762944 1963685280 19.335 99 34 67 1 1985975952 12954528 9336144
21:24:27 70805 8192000000 10911730208 11397988352 1984681392 19.502 100 15 30 1 2004812496 15998944 4132160
21:25:46 106002 8192000000 10927496240 11406266368 1968071312 19.370 99 10 20 1 1986600272 16170192 2358768
21:28:04 95831 8192000000 10911472016 11377311744 1956124944 19.275 98 21 42 0 1972332272 10211920 5995408
21:29:46 28042 8192000000 10922140752 11370913792 1914157472 18.940 96 33 66 1 1932204624 10016000 8031152
21:30:34 45822 8192000000 10940510288 11388678144 1986746464 19.518 100 48 95 3 2016752176 16705616 13300096
21:31:27 25140 8192000000 10923067456 11377426432 1956857904 19.281 98 38 75 2 1984069312 16708192 10503216
21:31:58 79473 8192000000 10907624368 11398402048 1991102080 19.553 100 27 52 1 2012003712 13619936 7281696
21:33:32 35509 8192000000 10906606064 11376558080 1951053728 19.235 98 14 28 0 1969634496 14689600 3891168
21:34:14 102811 8192000000 10870755424 11341008896 1861929264 18.519 94 16 32 0 1878051728 11021696 5100768
21:36:11 55777 8192000000 10847326128 11314995200 1868193040 18.570 96 11 23 0 1881689488 10842176 2654272
21:37:20 62155 8192000000 10831976144 11296825344 1827374208 18.238 94 17 33 2 1847186400 14705088 5107104
21:38:28 32691 8192000000 10845462400 11308417024 1886484560 18.717 98 15 30 2 1901884800 11202224 4198016
21:39:12 69601 8192000000 10871067264 11323219968 1839125376 18.334 95 19 38 0 1852205840 8326576 4753888
21:40:28 59860 8192000000 10855545760 11312984064 1874348608 18.619 97 31 62 0 1893124144 9999616 8775920
21:41:41 44896 8192000000 10819203152 11272585216 1784079440 17.883 93 22 44 3 1797769648 7417824 6272384
21:42:38 52072 8192000000 10825793312 11280338944 1825582512 18.223 96 28 56 2 1843225568 9648944 7994112
21:43:52 20157 8192000000 10835212176 11275288576 1854474240 18.458 98 44 88 1 1885482496 18733136 12275120
21:44:18 55307 8192000000 10834258512 11293769728 1876096432 18.634 99 39 78 0 1902051056 15143712 10810912
21:45:23 101609 8192000000 10804502752 11273330688 1765507792 17.730 93 12 24 0 1787498240 18734400 3256048
21:47:17 64550 8192000000 10827251968 11287949312 1860749744 18.509 98 16 32 0 1874653824 9705472 4198608
21:48:29 64207 8192000000 10844536480 11306569728 1876981872 18.641 98 29 58 0 1899352576 14209952 8160752
21:49:42 70920 8192000000 10834125984 11306373120 1878078416 18.650 98 21 42 3 1905799280 21307120 6413744
21:51:14 82894 8192000000 10832968064 11301785600 1878780736 18.655 98 23 46 0 1892684336 7898320 6005280
21:52:44 61161 8192000000 10850263648 11310018560 1917590320 18.968 100 19 38 1 1932643136 9205216 5847600
21:53:51 41925 8192000000 10836643056 11305705472 1871879936 18.599 97 28 56 1 1892005280 11788528 8336816
21:54:43 82373 8192000000 10846796512 11320606720 1892643312 18.767 98 15 30 0 1908505904 11562336 4300256
21:56:20 37043 8192000000 10851240848 11322011648 1929173920 19.060 100 11 22 0 1943853312 11528528 3150864
21:57:03 92376 8192000000 10873459744 11348787200 1943889856 19.178 100 15 30 2 1963825984 15451200 4484928
21:59:15 70637 8192000000 10888141136 11370475520 1957529856 19.286 100 12 24 0 1974221536 13712528 2979152
22:00:32 86919 8192000000 10884252416 11358662656 1928580016 19.056 98 10 20 0 1946416352 15056864 2779472
22:02:11 70517 8192000000 10892035264 11368095744 1949975328 19.226 99 20 41 1 1966777664 10909808 5892528
22:03:29 95119 8192000000 10907855824 11397222400 1974904432 19.424 100 11 23 0 1994785872 16924192 2957248
22:05:12 49520 8192000000 10900366096 11361886208 1935468576 19.111 98 23 46 0 1955634224 13736656 6428992
22:06:08 65782 8192000000 10908521376 11377373184 1936561664 19.119 98 17 34 2 1952258336 11218704 4477968
22:07:19 49561 8192000000 10925040336 11389718528 1982782528 19.487 100 39 78 1 2005651184 11739408 11129248
22:08:20 67536 8192000000 10917488576 11393302528 1966737920 19.360 99 25 49 5 1988303280 14793040 6772320
22:09:34 74956 8192000000 10930696992 11389911040 1951745408 19.240 98 34 68 1 1971977376 10689760 9542208
22:10:56 53418 8192000000 10916473840 11391500288 1971475456 19.397 99 33 66 1 1995190768 14340336 9374976
22:12:03 95188 8192000000 10899626368 11383152640 1898773072 18.816 96 20 40 2 1917530288 13398448 5358768
22:13:47 105914 8192000000 10891518432 11379896320 1932114752 19.084 98 2 4 0 1945543440 13084192 344496
22:15:47 100811 8192000000 10893288592 11371200512 1933242448 19.093 98 18 35 2 1949486208 10739568 5504192
22:17:45 28141 8192000000 10918727536 11390693376 1981795664 19.479 100 29 58 1 2005075216 14819632 8459920
22:18:19 62123 8192000000 10897727280 11383795712 1963339568 19.333 99 15 30 1 1981155760 13588944 4227248
22:19:31 64973 8192000000 10907560624 11394273280 1981204656 19.474 100 7 14 0 1996902496 13547168 2150672
22:20:42 58878 8192000000 10900679952 11393159168 1944833952 19.185 98 9 18 1 1962739328 15222640 2682736
22:21:49 73381 8192000000 10900107808 11388985344 1976109504 19.434 100 10 20 0 1989521872 10810992 2601376
22:23:11 62166 8192000000 10905792688 11390849024 1980966096 19.472 100 10 20 1 1992715344 8861040 2888208
22:24:29 59655 8192000000 10908475056 11387891712 1968490064 19.373 99 9 17 0 1976716704 6540592 1686048
22:25:37 41310 8192000000 10897300288 11376427008 1931363280 19.078 97 29 59 0 1946646496 7327488 7955728
22:26:25 73339 8192000000 9504211680 9889370112 574458960 6.552 29 6 12 0 579876624 3892160 1525504

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 30-03-2021 22:29:06 to 30-03-2021 22:29:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 63 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-03-2021 22:29:38 to 30-03-2021 22:29:40.

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          234185
MON$OLDEST_ACTIVE               234186
MON$OLDEST_SNAPSHOT             234186
MON$NEXT_TRANSACTION            234186
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                       1998848
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:208: 
:209: mscs-test-161.budzdorov.ru    Tue Mar 30 22:27:46 2021
:210:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:211: 
--- end of diff output ---

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

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