Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.11.2020 22:27
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 17442920 kB
MemAvailable 31415040 kB
Buffers 0 kB
Cached 14204632 kB
SwapCached 2832 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-07 22:27:00
DTS_END                         2020-11-07 22:27:00.5810
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/55814
TRN_ID                          238196
ATT_ID                          632
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: 9188.64 23344 1102637
customer order: creation 168.47 387 20216
customer order: refuse 14.61 344 1753
order to supplier: creation 44.88 1258 5385
order to supplier: removal 3.49 103496 419
invoice (draft): creation 45.61 3412 5473
invoice (draft): removal 53.46 758 6415
invoice accept: apply 40.73 18515 4887
invoice accept: cancel 48.46 822 5815
customer reserve: creation 3747.48 184 449698
customer reserve: removal 4720.52 61 566463
realization accept: apply 82.36 205 9883
realization accept: cancel 90.23 110 10827
payment from customer: creation 58.28 134 6993
payment from customer: removal 5.23 81 627
payment to supplier: creation 48.89 134 5867
payment to supplier: removal 3.31 58 397
service: total inventory turnovers 5.08 941 609
service: total monetary turnovers 6.73 22 808
service: aggregate perf. data 0.82 24139 98
service: refresh index statistics 0.03 311818 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-11-2020 22:27:56 to 07-11-2020 22:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5644
TEST_TIME 2 5677
TEST_TIME 3 5597
TEST_TIME 4 5188
TEST_TIME 5 5283
TEST_TIME 6 5483
TEST_TIME 7 5477
TEST_TIME 8 5824
TEST_TIME 9 5926
TEST_TIME 10 5942
TEST_TIME 11 6099
TEST_TIME 12 6164
TEST_TIME 13 6351
TEST_TIME 14 6641
TEST_TIME 15 6606
TEST_TIME 16 6732
TEST_TIME 17 7194
TEST_TIME 18 7959
TEST_TIME 19 8088
TEST_TIME 20 8720
TEST_TIME 21 8827
TEST_TIME 22 9012
TEST_TIME 23 9616
TEST_TIME 24 9955
TEST_TIME 25 10149
TEST_TIME 26 10780
TEST_TIME 27 10738
TEST_TIME 28 10382
TEST_TIME 29 10323
TEST_TIME 30 10285
TEST_TIME 31 10411
TEST_TIME 32 10620
TEST_TIME 33 10460
TEST_TIME 34 10403
TEST_TIME 35 10183
TEST_TIME 36 10161
TEST_TIME 37 10162
TEST_TIME 38 10049
TEST_TIME 39 10091
TEST_TIME 40 10004
TEST_TIME 41 9942
TEST_TIME 42 9888
TEST_TIME 43 9846
TEST_TIME 44 9724
TEST_TIME 45 9620
TEST_TIME 46 9580
TEST_TIME 47 9573
TEST_TIME 48 9560
TEST_TIME 49 9522
TEST_TIME 50 9478
TEST_TIME 51 9454
TEST_TIME 52 9331
TEST_TIME 53 9200
TEST_TIME 54 9160
TEST_TIME 55 9145
TEST_TIME 56 9071
TEST_TIME 57 9162
TEST_TIME 58 9217
TEST_TIME 59 9173
TEST_TIME 60 9235
TEST_TIME 61 9356
TEST_TIME 62 9324
TEST_TIME 63 9394
TEST_TIME 64 9523
TEST_TIME 65 9566
TEST_TIME 66 9567
TEST_TIME 67 9601
TEST_TIME 68 9567
TEST_TIME 69 9536
TEST_TIME 70 9526
TEST_TIME 71 9512
TEST_TIME 72 9424
TEST_TIME 73 9395
TEST_TIME 74 9313
TEST_TIME 75 9301
TEST_TIME 76 9250
TEST_TIME 77 9293
TEST_TIME 78 9258
TEST_TIME 79 9234
TEST_TIME 80 9206
TEST_TIME 81 9123
TEST_TIME 82 9099
TEST_TIME 83 9031
TEST_TIME 84 9019
TEST_TIME 85 9006
TEST_TIME 86 9065
TEST_TIME 87 9105
TEST_TIME 88 9102
TEST_TIME 89 9132
TEST_TIME 90 9145
TEST_TIME 91 9170
TEST_TIME 92 9154
TEST_TIME 93 9219
TEST_TIME 94 9289
TEST_TIME 95 9256
TEST_TIME 96 9337
TEST_TIME 97 9347
TEST_TIME 98 9343
TEST_TIME 99 9433
TEST_TIME 100 9428
TEST_TIME 101 9361
TEST_TIME 102 9321
TEST_TIME 103 9282
TEST_TIME 104 9279
TEST_TIME 105 9258
TEST_TIME 106 9222
TEST_TIME 107 9194
TEST_TIME 108 9193
TEST_TIME 109 9165
TEST_TIME 110 9147
TEST_TIME 111 9128
TEST_TIME 112 9155
TEST_TIME 113 9128
TEST_TIME 114 9159
TEST_TIME 115 9255
TEST_TIME 116 9259
TEST_TIME 117 9268
TEST_TIME 118 9229
TEST_TIME 119 9274
TEST_TIME 120 9197

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-11-2020 22:27:59 to 07-11-2020 22:28:03.

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 1520734 1520734 0 0.00 0 30938 7 0 0
doc_list_biud 1520730 1520730 0 0.00 0 29655 29 0 0
sp_add_invoice_to_stock 4979 4887 92 1.84 21 166625 18515 0 92
sp_cancel_adding_invoice 5815 5815 0 0.00 5 91000 823 0 0
sp_cancel_client_order 1753 1753 0 0.00 4 19647 345 0 0
sp_cancel_customer_reserve 566463 566463 0 0.00 1 22148 61 0 0
sp_cancel_pay_from_customer 627 627 0 0.00 2 6163 82 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 2636 58 0 0
sp_cancel_supplier_invoice 6422 6415 7 0.10 1 29734 759 0 7
sp_cancel_supplier_order 419 419 0 0.00 6 1186686 103497 0 0
sp_cancel_write_off 10827 10827 0 0.00 1 20088 111 0 0
sp_client_order 20216 20216 0 0.00 3 30424 387 0 0
sp_customer_reserve 449698 449698 0 0.00 0 36379 185 0 0
sp_fill_shopping_cart 31066 31066 0 0.00 1 26393 42 0 0
sp_fill_shopping_cart_clo_res 449688 449688 0 0.00 0 15159 14 0 0
sp_get_clo_for_invoice 4875 4875 0 0.00 0 33018 299 0 0
sp_kill_cost_storno 17666 17666 0 0.00 0 20309 57 0 0
sp_kill_qstorno_ret_qs2qd 1150587 1150587 0 0.00 0 29653 33 0 0
sp_kill_qty_storno 606450 606450 0 0.00 0 29655 71 0 0
sp_lock_selected_doc 20455 20455 0 0.00 0 8230 6 0 0
sp_make_cost_storno 27618 27618 0 0.00 0 30932 59 0 0
sp_multiply_rows_for_pdistr 27618 27618 0 0.00 0 8462 28 0 0
sp_multiply_rows_for_qdistr 20216 20216 0 0.00 0 13276 173 0 0
sp_pay_from_customer 6993 6993 0 0.00 4 17995 135 0 0
sp_pay_to_supplier 5867 5867 0 0.00 5 27169 134 0 0
sp_payment_common 12858 12858 0 0.00 1 27157 43 0 0
sp_qd_handle_on_cancel_clo 1753 1753 0 0.00 0 19638 317 0 0
sp_qd_handle_on_invoice_upd_sts 10690 10690 0 0.00 0 28917 335 0 0
sp_qd_handle_on_reserve_upd_sts 9883 9883 0 0.00 0 25280 79 0 0
sp_reserve_write_off 9883 9883 0 0.00 6 25321 205 0 0
sp_supplier_invoice 5473 5473 0 0.00 6 92517 3412 0 0
sp_supplier_order 5385 5385 0 0.00 4 44697 1258 0 0
srv_aggregate_perf_data 98 98 0 0.00 2870 314310 24140 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1547 131199 34153 0 0
srv_find_qd_qs_mism 1056656 1056656 0 0.00 0 19686 6 0 0
srv_make_invnt_saldo 609 609 0 0.00 28 54357 942 0 0
srv_make_money_saldo 808 808 0 0.00 0 1093 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 130862 491595 311819 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4887 4887 0 0.00 0 16657 205 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 9090 139 0 0
t$perf-norm:sp_cancel_client_order 1753 1753 0 0.00 0 2161 11 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 4117 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 627 627 0 0.00 0 227 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 3078 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 2041 23 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 22186 1696 0 0
t$perf-norm:sp_cancel_write_off 944 944 0 0.00 0 5392 20 0 0
t$perf-norm:sp_client_order 20216 20216 0 0.00 0 8188 19 0 0
t$perf-norm:sp_customer_reserve 945 945 0 0.00 0 7014 15 0 0
t$perf-norm:sp_pay_from_customer 6993 6993 0 0.00 0 6129 11 0 0
t$perf-norm:sp_pay_to_supplier 5867 5867 0 0.00 0 8105 13 0 0
t$perf-norm:sp_reserve_write_off 9883 9883 0 0.00 0 8681 13 0 0
t$perf-norm:sp_supplier_invoice 5473 5473 0 0.00 0 6459 23 0 0
t$perf-norm:sp_supplier_order 5385 5385 0 0.00 0 4563 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 1525 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 265 4 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 1175 16 0 0
t$perf-norm:srv_make_money_saldo 808 808 0 0.00 0 2629 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9934 9750 184 1.85 0 6151 17 0 184
v_all_customers 36816 36816 0 0.00 0 14 1 0 0
v_all_suppliers 30470 30470 0 0.00 0 100 1 0 0
v_all_wares 40428 40428 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 234 6 0 0
v_cancel_client_order 3506 3506 0 0.00 0 4274 8 0 0
v_cancel_customer_prepayment 1254 1254 0 0.00 0 1411 5 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 7503 15 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 2502 10 0 0
v_cancel_supplier_invoice 852 838 14 1.64 0 3591 20 0 14
v_cancel_supplier_order 838 838 0 0.00 0 274 4 0 0
v_cancel_write_off 1888 1888 0 0.00 0 2919 16 0 0
v_max_id_clo_ord 5384 5384 0 0.00 0 2242 1 0 0
v_max_id_clo_res 945 945 0 0.00 0 1608 12 0 0
v_max_id_ord_sup 5468 5468 0 0.00 0 3833 5 0 0
v_max_non_paid_invoice 1482 1482 0 0.00 0 320 2 0 0
v_max_non_paid_realizn 3759 3759 0 0.00 0 9005 12 0 0
v_min_id_clo_ord 5384 5384 0 0.00 0 3213 9 0 0
v_min_id_clo_res 945 945 0 0.00 0 3339 10 0 0
v_min_id_ord_sup 5468 5468 0 0.00 0 7329 6 0 0
v_min_non_paid_invoice 5866 5866 0 0.00 0 27155 29 0 0
v_min_non_paid_realizn 6992 6992 0 0.00 0 17981 26 0 0
v_our_firm 10078 10078 0 0.00 0 15 1 0 0
v_reserve_write_off 19766 19766 0 0.00 0 7601 8 0 0
x_lock_depdocs_on_canc_invoice 11811 11811 0 0.00 0 12532 109 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 14264 408 0 0
x_make_qstorno_1000_1200 5385 5385 0 0.00 1 44672 1173 0 0
x_make_qstorno_1200_2000 5473 5473 0 0.00 3 81966 3260 0 0
x_make_qstorno_2100_3300 449698 449698 0 0.00 0 36377 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2020 22:28:04 to 07-11-2020 22:28:08.

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:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:10 20244 8192000000 10273950400 10584317952 987630016 10.758 77 53 107 0 1007289648 2630000 17029632
19:57:38 25994 8192000000 10369381552 10688016384 1399477584 14.590 100 82 166 0 1430662960 4883792 26301584
19:58:17 19441 8192000000 10398255952 10726477824 1451335136 15.050 100 85 170 0 1485398992 6513488 27550368
19:58:48 18063 8192000000 10437705648 10766528512 1491204528 15.399 100 90 180 1 1527465584 7586960 28674096
19:59:16 22555 8192000000 10455194128 10789994496 1507947696 15.545 100 85 170 0 1542979344 8298992 26732656
19:59:48 6678 8192000000 10458729008 10794266624 1515514192 15.611 100 86 172 0 1551422736 8930896 26977648
20:00:06 22268 8192000000 10474559952 10813157376 1528374416 15.723 100 87 174 1 1565178688 9466304 27337968
20:00:39 21363 8192000000 10500404000 10841133056 1553801440 15.943 100 96 192 2 1594034784 10351904 29881440
20:01:07 20612 8192000000 10518886240 10863583232 1568944528 16.073 100 87 174 0 1606073072 10621840 26506704
20:01:38 15678 8192000000 10542738800 10892943360 1583586656 16.199 100 81 162 1 1618957792 10728736 24642400
20:02:05 16804 8192000000 10558138032 10917867520 1621037136 16.519 100 83 166 1 1657029792 11243168 24749488
20:02:31 14105 8192000000 10586475600 10948575232 1647564784 16.744 100 83 166 2 1683879344 11639456 24675104
20:02:52 12580 8192000000 10612852016 10973986816 1662785648 16.872 100 82 164 0 1699078368 12169424 24123296
20:03:13 9021 8192000000 10618547328 10986201088 1679867936 17.016 100 83 165 2 1716663248 13267632 23527680
20:03:31 10553 8192000000 10635738544 11005087744 1691329040 17.112 100 73 145 2 1725296512 12799328 21168144
20:03:50 10982 8192000000 10636788208 11009421312 1703588704 17.215 100 85 171 0 1741625200 13401728 24634768
20:04:11 7387 8192000000 10659159728 11034431488 1713749936 17.300 100 76 151 2 1748116928 12770288 21596704
20:04:27 5554 8192000000 10669892512 11053428736 1743775008 17.550 100 72 145 1 1775341488 11247472 20319008
20:04:41 6492 8192000000 10697723440 11077300224 1758976512 17.676 100 73 146 2 1791151616 12136272 20038832
20:04:54 6155 8192000000 10708480480 11087794176 1774199680 17.802 100 81 162 1 1810111888 12953760 22958448
20:05:07 5793 8192000000 10710841776 11094609920 1778809824 17.840 100 80 159 1 1814403568 13120112 22473632
20:05:20 4567 8192000000 10714556032 11096698880 1784878576 17.890 100 78 157 3 1820112048 13910848 21322624
20:05:32 3546 8192000000 10734068096 11112243200 1790228256 17.934 100 85 169 0 1828220192 14700192 23291744
20:05:42 11813 8192000000 10730321600 11117535232 1793104592 17.957 100 76 152 1 1829178560 14672864 21401104
20:06:00 3251 8192000000 10749421776 11136266240 1797653728 17.995 100 80 161 0 1834552272 14402336 22496208
20:06:10 4356 8192000000 10759021568 11144667136 1817080432 18.154 100 80 160 0 1853052816 14232256 21740128
20:06:22 2753 8192000000 10761019584 11151933440 1823759552 18.208 100 79 155 0 1858735696 13229024 21747120
20:06:31 2947 8192000000 10775182672 11163553792 1832171984 18.277 100 89 176 4 1871631136 13838464 25620688
20:06:40 3147 8192000000 10774602512 11164233728 1840454272 18.345 100 78 156 1 1874099360 11718528 21926560
20:06:50 2186 8192000000 10786262720 11174969344 1846422112 18.393 100 83 167 0 1882121760 13030304 22669344
20:06:59 2834 8192000000 10796189968 11182764032 1856384096 18.474 100 94 187 2 1895852992 12959456 26509440
20:07:09 2286 8192000000 10798135632 11184988160 1855599568 18.468 100 87 172 3 1893074464 13884352 23590544
20:07:17 1640 8192000000 10804913568 11191447552 1857149152 18.480 100 94 186 3 1896822352 12591472 27081728
20:07:25 1541 8192000000 10797816608 11187396608 1863346704 18.530 100 91 180 0 1901530048 13135776 25047568
20:07:34 1136 8192000000 10804799376 11193110528 1864396304 18.539 100 91 178 0 1903060352 12861008 25803040
20:07:42 1490 8192000000 10808295344 11193163776 1862595456 18.524 100 90 180 2 1900884304 12337360 25951488
20:07:51 2070 8192000000 10803728848 11194437632 1862959744 18.527 100 84 167 2 1898236736 12414224 22862768
20:07:59 2046 8192000000 10811223216 11199283200 1868218864 18.570 100 92 186 2 1906656256 11677520 26759872
20:08:08 1526 8192000000 10809560016 11196723200 1870237824 18.586 100 91 182 3 1907943424 12029712 25675888
20:08:16 6928 8192000000 10810949456 11203846144 1872295264 18.603 100 80 158 1 1906898960 12544064 22059632
20:08:30 24171 8192000000 10777947840 11199201280 1865393488 18.547 100 43 87 1 1887231840 10017664 11820688
20:09:02 5021 8192000000 10775740192 11197505536 1867414000 18.563 100 32 64 2 1882100720 5991744 8694976
20:09:14 6103 8192000000 10788790640 11205505024 1869673104 18.582 100 34 66 3 1887207936 8243168 9291664
20:09:29 7218 8192000000 10781786672 11207311360 1874503824 18.621 100 27 52 0 1889081440 6271264 8306352
20:09:43 6501 8192000000 10785668880 11209166848 1876896656 18.640 100 29 58 1 1890805184 5799376 8109152
20:09:56 6595 8192000000 10791783744 11215441920 1877651712 18.646 100 33 65 2 1894262816 7715984 8895120
20:10:11 6774 8192000000 10787071888 11212156928 1877630912 18.646 100 24 48 2 1891077424 6686400 6760112
20:10:25 7761 8192000000 10788098576 11214704640 1880365632 18.668 100 19 37 0 1890508592 5671696 4471264
20:10:42 13109 8192000000 10799769888 11221045248 1881089696 18.674 100 18 36 2 1891892080 5826560 4975824
20:11:01 6817 8192000000 10789649936 11221823488 1885881376 18.713 100 24 48 1 1898829584 6061536 6886672
20:11:15 8743 8192000000 10794421600 11221549056 1883184288 18.691 100 20 40 1 1895335952 6501568 5650096
20:11:31 7638 8192000000 10792322528 11223199744 1885048208 18.706 100 23 46 0 1902083696 10914320 6121168
20:11:45 9039 8192000000 10800138112 11231924224 1890104096 18.747 100 24 48 1 1907648288 10899536 6644656
20:12:00 9441 8192000000 10795699744 11229900800 1892457904 18.766 100 19 33 5 1903659280 5490400 5710976
20:12:16 8561 8192000000 10804668448 11238281216 1897282416 18.804 100 30 60 1 1913296816 7392784 8621616
20:12:31 66158 8192000000 10856400656 11257999360 1903303168 18.853 100 51 99 1 1922762000 4483136 14975696
20:13:43 4710 8192000000 10816887520 11247681536 1902725120 18.848 100 43 86 1 1923885216 8848976 12311120
20:13:54 4248 8192000000 10808113184 11248394240 1899168224 18.820 100 18 36 2 1910655968 6138816 5348928
20:14:04 6175 8192000000 10806803360 11250216960 1904012800 18.859 100 28 57 3 1918109584 6129056 7967728
20:14:17 4091 8192000000 10826869360 11254910976 1907961936 18.890 100 38 75 2 1925241360 5376992 11902432
20:14:28 6427 8192000000 10817244288 11254796288 1905734576 18.872 100 23 47 0 1918435792 6250784 6450432
20:14:42 6250 8192000000 10810413536 11246448640 1887758656 18.728 99 31 60 1 1903251440 7079776 8413008
20:14:58 5539 8192000000 10822619840 11255611392 1906692752 18.880 100 28 53 0 1926587200 11502016 8392432
20:15:12 6634 8192000000 10826589776 11257864192 1908293280 18.893 100 40 78 4 1927273392 5985120 12994992
20:15:25 7049 8192000000 10818869168 11258048512 1910905984 18.914 100 33 64 1 1926059792 6026144 9127664
20:15:38 9380 8192000000 10808614928 11243749376 1880437216 18.669 99 26 52 0 1893825776 6084096 7304464
20:15:57 5074 8192000000 10820642928 11250159616 1897749488 18.808 100 29 58 1 1916744992 10962320 8033184
20:16:08 16613 8192000000 10807427984 11226021888 1862885072 18.527 98 21 41 3 1873713264 4993888 5834304
20:16:36 60967 8192000000 10784950624 11212234752 1813650032 18.126 96 26 52 3 1826279568 5184352 7445184
20:17:46 10221 8192000000 10764728384 11199164416 1800494560 18.018 96 16 32 2 1811414416 6347264 4572592
20:18:03 6854 8192000000 10773626544 11199344640 1838439968 18.328 99 33 66 0 1854952816 7506928 9005920
20:18:21 6167 8192000000 10770667360 11189112832 1829981568 18.259 99 31 62 5 1845819472 7190672 8647232
20:18:34 5337 8192000000 10769152416 11197202432 1854271104 18.457 100 37 72 0 1872421408 7556992 10593312
20:18:51 7072 8192000000 10718279952 11134640128 1762053808 17.701 97 19 38 0 1773591504 4745104 6792592
20:19:04 9570 8192000000 10683849520 11094192128 1686479872 17.072 94 24 48 1 1699137056 5349792 7307392
20:19:20 10997 8192000000 10716794832 11136192512 1785668896 17.896 99 13 26 0 1795118448 5191024 4258528
20:19:37 8295 8192000000 10711272720 11127967744 1764653568 17.723 98 29 56 2 1779316960 6442416 8220976
20:19:52 10135 8192000000 10691674160 11111165952 1725627264 17.399 96 15 30 0 1735767824 5921392 4219168
20:20:09 9041 8192000000 10701218016 11108663296 1752853600 17.625 97 33 66 0 1767233328 4707664 9672064
20:20:25 10001 8192000000 10692772576 11115008000 1761525472 17.697 98 19 38 2 1773976992 5723104 6728416
20:20:41 9119 8192000000 10709310336 11120246784 1774688656 17.806 99 19 38 1 1785363792 5384000 5291136
20:20:58 59469 8192000000 10663449072 11074392064 1718060048 17.336 95 41 83 0 1739246688 9478672 11707968
20:22:06 10014 8192000000 10712127584 11136065536 1803392304 18.042 100 25 50 1 1816389136 6098256 6898576
20:22:28 7593 8192000000 10728667088 11140620288 1791811104 17.947 99 36 72 2 1809992960 7425728 10756128
20:22:43 4503 8192000000 10713928944 11132289024 1800692720 18.020 100 31 62 1 1816124112 6012032 9419360
20:22:57 7283 8192000000 10710127520 11139616768 1808715744 18.085 100 35 71 1 1824776496 5858736 10202016
20:23:11 6701 8192000000 10731785280 11153948672 1817401296 18.156 100 14 29 2 1826817024 5373152 4042576
20:23:26 6232 8192000000 10759348512 11176996864 1840830400 18.348 100 33 66 1 1855707776 5083040 9794336
20:23:41 6825 8192000000 10762620032 11186094080 1844049552 18.374 100 28 56 1 1857320672 4890432 8380688
20:23:55 4480 8192000000 10764072688 11189702656 1848276992 18.408 100 29 57 3 1863379120 6834112 8268016
20:24:10 9447 8192000000 10760285184 11189190656 1851510064 18.434 100 24 47 2 1864705456 6123472 7071920
20:24:27 9905 8192000000 10765517952 11195097088 1854131808 18.456 100 20 39 2 1865531216 5182432 6216976
20:24:43 9477 8192000000 10778537920 11203612672 1859058608 18.496 100 16 33 0 1868946448 5546032 4341808
20:25:01 10512 8192000000 10776446144 11206533120 1864045712 18.536 100 17 34 2 1875688752 6300976 5342064
20:25:21 15504 8192000000 10778717600 11209371648 1867671680 18.565 100 15 30 1 1877502672 5521664 4309328
20:25:46 68420 8192000000 10786731248 11219030016 1874011264 18.617 100 38 77 1 1890906080 5606944 11287872
20:27:01 15270 8192000000 10803196704 11225919488 1880508784 18.669 100 29 57 5 1893405200 4751200 8145216
20:27:26 42413 8192000000 10828770704 11248201728 1900975488 18.834 100 45 90 1 1920315328 6660336 12679504
20:28:18 22114 8192000000 10847481744 11271467008 1910563792 18.911 100 42 84 2 1936124192 14320016 11240384
20:28:53 10678 8192000000 10861249920 11284074496 1925571200 19.031 100 42 84 0 1950108480 12561296 11975984
20:29:19 25449 8192000000 10876887744 11302735872 1936650320 19.120 100 46 91 3 1963875920 14467504 12758096
20:30:00 30347 8192000000 10873388496 11304103936 1943791888 19.177 100 40 80 1 1970521696 15365536 11364272
20:30:44 31141 8192000000 10885530480 11317014528 1953800560 19.257 100 38 76 2 1979797024 15031264 10965200
20:31:36 22111 8192000000 10910563776 11339968512 1967406432 19.365 100 51 102 3 2000113648 17601296 15105920
20:32:06 14256 8192000000 10906429408 11337568256 1969059824 19.378 100 50 97 2 2000902832 16866544 14976464
20:32:39 10392 8192000000 10920760672 11351457792 1977265520 19.443 100 52 104 2 2010630928 18025696 15339712
20:32:57 7896 8192000000 10923509104 11352289280 1980471440 19.468 100 51 101 2 2013945856 18783200 14691216
20:33:21 19189 8192000000 10929777520 11360251904 1985834192 19.511 100 54 108 2 2021191920 19362576 15995152
20:33:47 27901 8192000000 10930189376 11367583744 1986733216 19.518 100 47 94 3 2021000512 20161488 14105808
20:34:33 16305 8192000000 10925976784 11362549760 1981271184 19.475 100 34 68 2 2011644672 19912944 10460544
20:34:58 13953 8192000000 10928719968 11364356096 1984921520 19.504 100 39 77 0 2015303424 18668880 11713024
20:35:19 4829 8192000000 10934333312 11369009152 1990244928 19.546 100 52 100 2 2023605872 19215248 14145696
20:35:31 6629 8192000000 10950957568 11374395392 1998239968 19.609 100 64 128 3 2034335088 18157056 17938064
20:35:46 8407 8192000000 10952070000 11379220480 1995061120 19.584 100 60 120 1 2033083584 19776832 18245632
20:36:05 2240 8192000000 10952410400 11384217600 2004331584 19.657 100 72 145 2 2046663568 20316464 22015520
20:36:18 2336 8192000000 10960057584 11382038528 2010190432 19.703 100 84 164 0 2056020864 20429952 25400480
20:36:32 8161 8192000000 10947470960 11384700928 1987306272 19.523 99 53 106 2 2023468832 20743296 15419264
20:36:50 9275 8192000000 10948490784 11380105216 1996010656 19.591 100 52 104 2 2034568880 22495904 16062320
20:37:09 7488 8192000000 10945478752 11383226368 1999917440 19.622 100 53 106 1 2040058304 23550960 16589904
20:37:24 6267 8192000000 10952856512 11387473920 1984826768 19.503 99 50 98 3 2025179696 24686768 15666160
20:37:38 7506 8192000000 10950935584 11389820928 2001766320 19.637 100 50 100 1 2042197232 25057840 15373072
20:37:52 8035 8192000000 10959341424 11394244608 2006407328 19.673 100 61 122 0 2050991168 26268672 18315168
20:38:17 2633 8192000000 10959540976 11390615552 2002671024 19.644 100 66 133 0 2049076704 25471744 20933936
20:38:27 20962 8192000000 10968925184 11403837440 2013023904 19.725 100 66 131 2 2058558656 25501936 20032816
20:38:58 2635 8192000000 10960994608 11387219968 1990096560 19.545 99 55 108 1 2032266112 25880384 16289168
20:39:07 7803 8192000000 10971798544 11396055040 2002910480 19.646 100 66 130 3 2050007552 27355648 19741424
20:39:22 3801 8192000000 10954460576 11374505984 1984771328 19.502 99 78 155 1 2036580896 27851584 23957984
20:39:34 5008 8192000000 10959788192 11380645888 1978677760 19.454 99 80 159 0 2030463520 27661568 24124192
20:39:46 6401 8192000000 10952507536 11377508352 1991646832 19.557 100 63 126 2 2039315504 28559808 19108864
20:40:00 16499 8192000000 10959571040 11382464512 1993988592 19.575 100 67 134 3 2045833600 31181168 20663840
20:40:26 2373 8192000000 10974153872 11399557120 2003585104 19.651 100 67 134 1 2060509568 36336944 20587520
20:40:39 7120 8192000000 10964801200 11394441216 1985681904 19.510 99 63 126 0 2040980048 35535216 19762928
20:40:58 3832 8192000000 10957769936 11377741824 1986301968 19.515 100 67 134 1 2041777872 35099888 20376016
20:41:11 1547 8192000000 10977724560 11393724416 1998122160 19.608 100 77 154 1 2058735856 36069760 24543936
20:41:20 2896 8192000000 10976914944 11394682880 1986063120 19.513 99 80 160 4 2046951392 36785456 24102816
20:41:31 2543 8192000000 10987791872 11401781248 1998389312 19.610 99 90 179 2 2061736304 35860064 27486928
20:41:40 3348 8192000000 10991219680 11409563648 2009638032 19.699 100 79 155 0 2070167776 36380048 24149696
20:41:51 3150 8192000000 10995948480 11420102656 2021400528 19.791 100 72 142 2 2079854368 36247600 22206240
20:42:02 4879 8192000000 10966228448 11387101184 1970923344 19.393 98 72 144 2 2029852176 36144800 22784032
20:42:14 2092 8192000000 10986377760 11404161024 1999658112 19.620 100 80 161 2 2061699056 37283456 24757488
20:42:23 1652 8192000000 11001456704 11415773184 2011074368 19.710 100 85 170 0 2076568928 38765904 26728656
20:42:33 3846 8192000000 11002164192 11416383488 2013958000 19.733 100 83 167 0 2081426448 41020880 26447568
20:42:44 3011 8192000000 11001110656 11422973952 2016774800 19.755 100 77 154 1 2082700832 41260112 24665920
20:42:54 1698 8192000000 10982041824 11391614976 1988031616 19.528 99 88 176 1 2061080320 44427424 28621280
20:43:03 1846 8192000000 10992319760 11409178624 1997688608 19.605 100 85 169 1 2069893984 46009600 26195776
20:43:12 3126 8192000000 11001195488 11418284032 2008540896 19.690 100 87 174 2 2083163520 46957184 27665440
20:43:24 2561 8192000000 11001668560 11422670848 2009958368 19.701 100 75 150 0 2081188000 47077392 24152240
20:43:37 3422 8192000000 11009366640 11424075776 2007676848 19.683 100 77 154 1 2080696800 48433568 24586384
20:43:49 3046 8192000000 11001800784 11416444928 1990388608 19.547 99 86 172 2 2068447184 50114640 27943936
20:43:59 6686 8192000000 10984277520 11407163392 1989770704 19.542 99 86 172 1 2070130640 52345184 28014752
20:44:16 7244 8192000000 10988521584 11415437312 1997721264 19.605 100 80 160 1 2075029200 51569920 25738016
20:44:33 3039 8192000000 10992091632 11412885504 1998716544 19.613 100 82 163 0 2075997504 50743344 26537616
20:44:43 3228 8192000000 10990341408 11416735744 2002182544 19.640 100 76 151 1 2074973008 48226592 24563872
20:44:55 2170 8192000000 10979831616 11403681792 1985033328 19.505 100 71 143 0 2058877376 50266656 23577392
20:45:03 3945 8192000000 10963558656 11385110528 1970648688 19.391 100 72 143 2 2045135680 50940496 23546496
20:45:14 2803 8192000000 10986141840 11397390336 1981964352 19.480 100 85 168 3 2061546896 52541136 27041408
20:45:24 2673 8192000000 10947441792 11368329216 1959018592 19.298 100 85 170 2 2036435616 49541568 27875456
20:45:37 5739 8192000000 10937917056 11358728192 1940811808 19.153 99 62 124 2 2012252544 50898624 20542112
20:45:50 5451 8192000000 10937467392 11354230784 1955522480 19.270 100 80 158 4 2021785040 41353632 24908928
20:46:08 2754 8192000000 10957198528 11376873472 1970720368 19.391 100 78 154 4 2038467168 43782080 23964720
20:46:19 3801 8192000000 10960764352 11373764608 1975170384 19.426 100 78 155 0 2040965952 41224288 24571280
20:46:30 4746 8192000000 10952464352 11373289472 1970809104 19.392 100 70 140 3 2036406272 43357776 22239392
20:46:54 2670 8192000000 10953704112 11378884608 1970288416 19.388 100 72 145 2 2038742048 45747776 22705856
20:47:04 8494 8192000000 10945493504 11385503744 1969607904 19.382 100 58 116 0 2037015456 48864256 18543296
20:47:19 13219 8192000000 10932107152 11387043840 1971271216 19.396 100 40 80 3 2028126752 43981520 12874016
20:47:41 13364 8192000000 10934052976 11380047872 1976989968 19.441 100 36 72 0 2028110960 38998128 12122864
20:48:12 16150 8192000000 10923196896 11378372608 1955041312 19.267 99 34 66 3 2004779328 38502192 11235824
20:48:39 14482 8192000000 10909917184 11356459008 1915697376 18.952 98 29 58 0 1967909440 41668960 10543104
20:49:04 24148 8192000000 10907883424 11364618240 1949275760 19.221 100 29 58 0 1998889280 39172752 10440768
20:49:47 16672 8192000000 10926610464 11375026176 1945164288 19.188 99 31 62 0 1998139232 42147232 10827712
20:50:11 21092 8192000000 10895063824 11356377088 1934188832 19.100 99 23 45 2 1980760768 38582496 7989440
20:50:40 22183 8192000000 10916028320 11365797888 1948232992 19.212 100 25 50 0 1990608576 33907536 8468048
20:51:11 33645 8192000000 10916415184 11371855872 1939522000 19.143 99 24 48 0 1985663136 37603008 8538128
20:51:51 19157 8192000000 10912385824 11372904448 1938598544 19.136 99 19 38 3 1981262272 36067424 6596304
20:52:16 30292 8192000000 10883648672 11339530240 1879935664 18.665 96 19 36 0 1914559424 28500720 6123040
20:53:17 24085 8192000000 10884908208 11361226752 1937123120 19.124 100 23 46 2 1979581856 34790512 7668224
20:53:50 111988 8192000000 10889521520 11347603456 1914440448 18.942 98 20 40 2 1950877424 29954784 6482192
20:56:24 37426 8192000000 10880487744 11332083712 1931637520 19.080 100 27 52 0 1965561488 25973840 7950128
20:57:10 23629 8192000000 10917612336 11365179392 1945265552 19.189 99 46 92 1 1982880768 23370720 14244496
20:57:48 18972 8192000000 10939150224 11373850624 1972759424 19.407 100 50 100 1 2011902448 24392544 14750480
20:58:49 38785 8192000000 10900929024 11364433920 1958868736 19.297 100 15 29 1 1982786608 19385104 4532768
21:00:21 59929 8192000000 10892488480 11364712448 1949347728 19.221 99 8 16 1 1964850624 13605056 1897840
21:01:39 49006 8192000000 10882746752 11354771456 1927685712 19.048 98 11 22 0 1941228416 10306864 3235840
21:02:42 82615 8192000000 10904488976 11373735936 1979324656 19.459 100 20 41 0 1994893056 9754080 5814320
21:05:31 104973 8192000000 10908878160 11380158464 1947846656 19.209 98 16 33 1 1966065952 12763600 5455696
21:07:28 101741 8192000000 10889116784 11359318016 1924377328 19.022 97 30 60 1 1945534096 12172544 8984224
21:09:16 82803 8192000000 10922032256 11375837184 1954751968 19.264 99 29 57 0 1974263728 12186864 7324896
21:10:45 52965 8192000000 10882100000 11345731584 1939218176 19.141 98 35 72 1 1957383824 7787024 10378624
21:11:46 15235 8192000000 10898975120 11359342592 1971946272 19.401 100 26 52 0 1987413952 8495680 6972000
21:12:19 22284 8192000000 10893343440 11359117312 1973585904 19.414 100 21 42 1 1987523088 7596320 6340864
21:12:48 30117 8192000000 10902170960 11352289280 1963877264 19.337 100 36 73 0 1987871872 13233072 10761536
21:13:26 42996 8192000000 10898532720 11362336768 1970266272 19.388 100 25 50 2 1984822192 7921024 6634896
21:14:16 36632 8192000000 10922114880 11368640512 1977878368 19.448 100 31 62 0 1995916544 9209056 8829120
21:15:00 33292 8192000000 10908036816 11367481344 1981045104 19.473 100 22 44 1 1993576608 6536000 5995504
21:15:47 43992 8192000000 10901638128 11360759808 1955742704 19.272 99 20 40 1 1970073568 8270368 6060496
21:16:45 90378 8192000000 10868972080 11340787712 1910565984 18.911 97 18 36 0 1923351840 7694272 5091584
21:18:22 59957 8192000000 10872085888 11351597056 1958035248 19.290 100 7 14 0 1969775776 9665184 2075344
21:19:28 25689 8192000000 10870830352 11344330752 1942205344 19.164 99 7 14 0 1951747904 7969696 1572864
21:20:03 110006 8192000000 10889563296 11356774400 1953778784 19.257 99 18 35 0 1966979072 8120336 5079952
21:22:01 52267 8192000000 10893243696 11368677376 1957327664 19.285 99 18 36 2 1976893104 14275424 5290016
21:23:17 74644 8192000000 10902509744 11388760064 1975188160 19.427 100 11 21 2 1994296080 15964640 3143280
21:24:38 62002 8192000000 10894477136 11379777536 1956998720 19.282 99 11 22 1 1975694352 15308928 3386704
21:25:47 40068 8192000000 10909718880 11370958848 1960064000 19.307 99 18 36 2 1981328464 16057040 5207424
21:26:33 56748 8192000000 10904937312 11387564032 1958541824 19.294 99 23 46 2 1987330512 21855584 6933104
21:27:40 93973 8192000000 10913620752 11372470272 1927732496 19.049 97 18 36 0 1947769056 14717712 5318848
21:29:24 80549 8192000000 10912044352 11385417728 1925574736 19.031 97 19 38 2 1945984304 15080864 5328704
21:30:51 82453 8192000000 10884586224 11362996224 1927097888 19.044 97 14 29 1 1951119904 20331040 3690976
21:32:20 80327 8192000000 10893354720 11363835904 1916940416 18.962 97 24 47 2 1932791184 9409696 6441072
21:33:51 73497 8192000000 10866305120 11331395584 1847644176 18.403 94 20 40 2 1862065200 9002672 5418352
21:35:11 29782 8192000000 10891396928 11336572928 1923659840 19.016 98 51 102 0 1947110448 9409184 14041424
21:35:49 29077 8192000000 10889723616 11326636032 1918394416 18.974 98 41 79 0 1939262928 10453856 10414656
21:36:28 25137 8192000000 10881937504 11335782400 1936428160 19.118 99 47 94 0 1959825664 11009968 12387536
21:37:00 26521 8192000000 10884962320 11334402048 1877762096 18.647 96 37 74 0 1898855040 11067088 10025856
21:37:35 76316 8192000000 10861684736 11311849472 1878599632 18.654 96 36 72 0 1908458800 19530816 10328352
21:38:59 87991 8192000000 10851027232 11313209344 1899704528 18.824 98 34 68 1 1919698016 10512688 9480800
21:40:33 80116 8192000000 10853357552 11298701312 1822948160 18.202 94 30 60 2 1839542048 8569776 8024112
21:42:04 17127 8192000000 10862197968 11303673856 1918637888 18.976 99 42 85 2 1941846480 11185088 12023504
21:42:30 71015 8192000000 10834818576 11297300480 1879659344 18.662 97 29 58 1 1900094352 11606544 8828464
21:43:47 64849 8192000000 10816696704 11296014336 1879170784 18.658 98 11 22 0 1895840224 13396752 3272688
21:45:39 64921 8192000000 10850217472 11308949504 1876953856 18.641 97 14 28 0 1888601376 7518592 4128928
21:46:51 47361 8192000000 10845080768 11325091840 1934355936 19.102 100 7 14 0 1946478432 10107488 2015008
21:47:55 69484 8192000000 10861090464 11327778816 1939743008 19.145 100 6 12 0 1947741680 6498720 1499952
21:49:13 64295 8192000000 10860033328 11338694656 1944796576 19.185 100 20 40 2 1960665296 10022592 5846128
21:50:27 63926 8192000000 10875769088 11351052288 1955382304 19.269 100 17 34 0 1976193344 16303312 4507728
21:51:37 66300 8192000000 10857510272 11342209024 1892809808 18.768 97 8 16 0 1911540512 16598656 2132048
21:52:49 72363 8192000000 10857397296 11328008192 1879103664 18.658 97 9 18 0 1891244000 9760896 2379440
21:54:11 32943 8192000000 10858147792 11316342784 1863939776 18.535 96 22 41 2 1881379184 10978048 6461360
21:54:50 58702 8192000000 10854895072 11328262144 1914454512 18.942 99 15 30 1 1928021296 9176672 4390112
21:55:55 45763 8192000000 10861476880 11324997632 1924762016 19.025 99 21 42 0 1940242816 9793168 5687632
21:56:53 38452 8192000000 10867623664 11318489088 1891049024 18.754 97 24 48 0 1904665360 7501136 6115200
21:57:39 46049 8192000000 10872155120 11331264512 1896631536 18.799 97 31 62 3 1917211760 12423872 8156352
21:58:32 65268 8192000000 10886369504 11334815744 1874428624 18.620 96 26 52 1 1893890752 12559168 6902960
21:59:45 71978 8192000000 10861468832 11328139264 1906868000 18.881 98 27 54 1 1929452144 14818608 7765536
22:01:52 41233 8192000000 10899164736 11344113664 1938214288 19.133 99 20 40 1 1952077840 8634688 5228864
22:02:41 19511 8192000000 10898385776 11352350720 1962471744 19.326 100 42 84 1 1985158960 10866144 11821072
22:03:17 131199 8192000000 10892559776 11369287680 1926670256 19.040 98 10 18 1 1942831296 13729088 2431952
22:05:42 109419 8192000000 10881780320 11354480640 1870334496 18.587 95 15 30 0 1889022208 14109520 4578192
22:07:37 102723 8192000000 10889710080 11346173952 1957320464 19.285 100 18 36 2 1974650784 11825328 5504992
22:09:51 62951 8192000000 10903329008 11364634624 1955516352 19.270 99 33 65 4 1973745632 8878032 9351248
22:11:00 25132 8192000000 10907216368 11375685632 1977922928 19.448 100 37 74 0 1998709456 10333200 10453328
22:11:45 42165 8192000000 10847272272 11317039104 1850360160 18.425 94 12 24 0 1858955232 5585136 3009936
22:12:38 90262 8192000000 10862938544 11335188480 1932518480 19.087 99 12 24 0 1942337888 6470656 3348752
22:14:15 50951 8192000000 10892411888 11361951744 1971748304 19.399 100 20 39 1 1986335360 8611232 5975824
22:15:19 63604 8192000000 10887425616 11363745792 1968050304 19.370 100 9 18 1 1979760960 9052672 2657984
22:16:44 54281 8192000000 10892195536 11363012608 1957047264 19.283 99 28 56 3 1972100720 7107664 7945792
22:17:47 57681 8192000000 10888424784 11360432128 1920857184 18.994 97 26 52 1 1935686288 7447088 7382016
22:18:51 78853 8192000000 10896086032 11370520576 1921853696 19.002 97 16 32 2 1943049280 16107104 5088480
22:20:35 46077 8192000000 10890375760 11358392320 1957256032 19.284 99 30 60 1 1981151072 15656784 8238256
22:21:33 75715 8192000000 10918751712 11396104192 1970982256 19.393 100 14 29 2 1992041808 16955440 4104112
22:23:09 84777 8192000000 10860862448 11331805184 1834100272 18.293 93 11 22 0 1845833936 8777984 2955680
22:24:44 44546 8192000000 10883938208 11341463552 1896132576 18.795 97 26 52 2 1913409984 9649136 7628272
22:25:35 36100 8192000000 10867434960 11325841408 1905852944 18.873 98 38 76 2 1930626096 14088592 10684560
22:26:38 38749 8192000000 9525821680 9838972928 663004112 7.487 34 6 12 0 674528576 10104192 1420272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 07-11-2020 22:28:10 to 07-11-2020 22:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-11-2020 22:28:41 to 07-11-2020 22:28:43.

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          238445
MON$OLDEST_ACTIVE               238446
MON$OLDEST_SNAPSHOT             238446
MON$NEXT_TRANSACTION            238446
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                       2016384
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:40: 
:41: mscs-test-161.budzdorov.ru    Sat Nov  7 22:27:25 2020
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Nov  7 22:27:25 2020
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
--- end of diff output ---

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

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