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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17214372 kB
MemAvailable 31489612 kB
Buffers 0 kB
Cached 14468848 kB
SwapCached 3696 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 2020-12-21 19:27:05
DTS_END                         2020-12-21 19:27:05.9510
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46778
TRN_ID                          250071
ATT_ID                          682
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: 9883.07 21847 1185968
customer order: creation 175.43 359 21051
customer order: refuse 15.45 288 1854
order to supplier: creation 47.03 1107 5643
order to supplier: removal 3.63 105442 435
invoice (draft): creation 48.08 2970 5769
invoice (draft): removal 59.66 760 7159
invoice accept: apply 42.03 14927 5043
invoice accept: cancel 53.37 633 6404
customer reserve: creation 3875.31 147 465037
customer reserve: removal 5242.49 58 629099
realization accept: apply 86.18 148 10342
realization accept: cancel 100.25 92 12030
payment from customer: creation 61.25 103 7350
payment from customer: removal 6.08 56 730
payment to supplier: creation 50.53 112 6063
payment to supplier: removal 3.63 63 436
service: total inventory turnovers 4.69 1170 563
service: total monetary turnovers 6.98 52 838
service: aggregate perf. data 0.98 19472 118
service: refresh index statistics 0.03 288983 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-12-2020 19:28:25 to 21-12-2020 19:28:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3388
TEST_TIME 2 3900
TEST_TIME 3 3744
TEST_TIME 4 3959
TEST_TIME 5 4497
TEST_TIME 6 4829
TEST_TIME 7 5451
TEST_TIME 8 5747
TEST_TIME 9 6522
TEST_TIME 10 6867
TEST_TIME 11 7213
TEST_TIME 12 7900
TEST_TIME 13 8158
TEST_TIME 14 8390
TEST_TIME 15 8897
TEST_TIME 16 8857
TEST_TIME 17 8713
TEST_TIME 18 8926
TEST_TIME 19 9185
TEST_TIME 20 9274
TEST_TIME 21 9290
TEST_TIME 22 9410
TEST_TIME 23 10843
TEST_TIME 24 12634
TEST_TIME 25 12555
TEST_TIME 26 12144
TEST_TIME 27 12270
TEST_TIME 28 12170
TEST_TIME 29 12142
TEST_TIME 30 11798
TEST_TIME 31 11573
TEST_TIME 32 11749
TEST_TIME 33 11482
TEST_TIME 34 11395
TEST_TIME 35 11217
TEST_TIME 36 11321
TEST_TIME 37 11144
TEST_TIME 38 10959
TEST_TIME 39 10921
TEST_TIME 40 10827
TEST_TIME 41 10654
TEST_TIME 42 10690
TEST_TIME 43 10608
TEST_TIME 44 10562
TEST_TIME 45 10476
TEST_TIME 46 10382
TEST_TIME 47 10367
TEST_TIME 48 10285
TEST_TIME 49 10321
TEST_TIME 50 10324
TEST_TIME 51 10263
TEST_TIME 52 10204
TEST_TIME 53 10163
TEST_TIME 54 10553
TEST_TIME 55 10535
TEST_TIME 56 10643
TEST_TIME 57 10562
TEST_TIME 58 10588
TEST_TIME 59 10732
TEST_TIME 60 10596
TEST_TIME 61 10491
TEST_TIME 62 10431
TEST_TIME 63 10423
TEST_TIME 64 10349
TEST_TIME 65 10260
TEST_TIME 66 10181
TEST_TIME 67 10183
TEST_TIME 68 10184
TEST_TIME 69 10186
TEST_TIME 70 10194
TEST_TIME 71 10184
TEST_TIME 72 10167
TEST_TIME 73 10151
TEST_TIME 74 10190
TEST_TIME 75 10235
TEST_TIME 76 10172
TEST_TIME 77 10252
TEST_TIME 78 10344
TEST_TIME 79 10369
TEST_TIME 80 10430
TEST_TIME 81 10380
TEST_TIME 82 10308
TEST_TIME 83 10259
TEST_TIME 84 10228
TEST_TIME 85 10201
TEST_TIME 86 10123
TEST_TIME 87 10113
TEST_TIME 88 10107
TEST_TIME 89 10114
TEST_TIME 90 10143
TEST_TIME 91 10103
TEST_TIME 92 10119
TEST_TIME 93 10095
TEST_TIME 94 10132
TEST_TIME 95 10117
TEST_TIME 96 10127
TEST_TIME 97 10148
TEST_TIME 98 10261
TEST_TIME 99 10258
TEST_TIME 100 10276
TEST_TIME 101 10279
TEST_TIME 102 10336
TEST_TIME 103 10301
TEST_TIME 104 10227
TEST_TIME 105 10214
TEST_TIME 106 10180
TEST_TIME 107 10181
TEST_TIME 108 10128
TEST_TIME 109 10090
TEST_TIME 110 10037
TEST_TIME 111 10038
TEST_TIME 112 9968
TEST_TIME 113 9999
TEST_TIME 114 9985
TEST_TIME 115 9950
TEST_TIME 116 9956
TEST_TIME 117 9995
TEST_TIME 118 9983
TEST_TIME 119 9957
TEST_TIME 120 9885

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 21-12-2020 19:28:29 to 21-12-2020 19:28:33.

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 1618795 1618795 0 0.00 0 15993 5 0 0
doc_list_biud 1618795 1618795 0 0.00 0 55706 28 0 0
sp_add_invoice_to_stock 5158 5043 115 2.22 33 174826 14927 0 115
sp_cancel_adding_invoice 6404 6404 0 0.00 5 49035 633 0 0
sp_cancel_client_order 1854 1854 0 0.00 4 17027 289 0 0
sp_cancel_customer_reserve 629099 629099 0 0.00 1 55708 58 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 2 4624 56 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 2 4681 63 0 0
sp_cancel_supplier_invoice 7172 7159 13 0.18 2 13247 760 0 13
sp_cancel_supplier_order 435 435 0 0.00 8 1189874 105443 0 0
sp_cancel_write_off 12030 12030 0 0.00 1 9642 93 0 0
sp_client_order 21051 21051 0 0.00 4 55545 359 0 0
sp_customer_reserve 465037 465037 0 0.00 0 49365 148 0 0
sp_fill_shopping_cart 32441 32441 0 0.00 1 15988 35 0 0
sp_fill_shopping_cart_clo_res 465033 465033 0 0.00 0 18912 14 0 0
sp_get_clo_for_invoice 5039 5039 0 0.00 0 21464 312 0 0
sp_kill_cost_storno 19600 19600 0 0.00 0 5563 43 0 0
sp_kill_qstorno_ret_qs2qd 1277822 1277822 0 0.00 0 55703 31 0 0
sp_kill_qty_storno 672362 672362 0 0.00 0 55706 66 0 0
sp_lock_selected_doc 21413 21413 0 0.00 0 8865 7 0 0
sp_make_cost_storno 28794 28794 0 0.00 0 15970 45 0 0
sp_multiply_rows_for_pdistr 28794 28794 0 0.00 0 6627 21 0 0
sp_multiply_rows_for_qdistr 21051 21051 0 0.00 0 55537 187 0 0
sp_pay_from_customer 7350 7350 0 0.00 4 12794 104 0 0
sp_pay_to_supplier 6063 6063 0 0.00 4 11936 113 0 0
sp_payment_common 13413 13413 0 0.00 1 10597 23 0 0
sp_qd_handle_on_cancel_clo 1854 1854 0 0.00 0 17013 267 0 0
sp_qd_handle_on_invoice_upd_sts 11443 11443 0 0.00 0 19752 282 0 0
sp_qd_handle_on_reserve_upd_sts 10342 10342 0 0.00 0 20187 47 0 0
sp_reserve_write_off 10342 10342 0 0.00 6 20223 148 0 0
sp_supplier_invoice 5769 5769 0 0.00 9 91230 2970 0 0
sp_supplier_order 5643 5643 0 0.00 5 25376 1107 0 0
srv_aggregate_perf_data 118 118 0 0.00 2899 350253 19472 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 972 135810 32939 0 0
srv_find_qd_qs_mism 1138300 1138300 0 0.00 0 9329 4 0 0
srv_make_invnt_saldo 563 563 0 0.00 22 112889 1170 0 0
srv_make_money_saldo 838 838 0 0.00 0 9038 52 0 0
srv_recalc_idx_stat 4 4 0 0.00 221824 384184 288983 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5043 5043 0 0.00 0 13246 150 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 1 7272 83 0 0
t$perf-norm:sp_cancel_client_order 1854 1854 0 0.00 0 2884 9 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 5343 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 5804 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 231 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 4298 29 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 17612 1465 0 0
t$perf-norm:sp_cancel_write_off 1026 1026 0 0.00 0 7377 19 0 0
t$perf-norm:sp_client_order 21051 21051 0 0.00 0 10308 18 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 2927 7 0 0
t$perf-norm:sp_pay_from_customer 7350 7350 0 0.00 0 10286 14 0 0
t$perf-norm:sp_pay_to_supplier 6063 6063 0 0.00 0 10253 19 0 0
t$perf-norm:sp_reserve_write_off 10342 10342 0 0.00 0 12684 15 0 0
t$perf-norm:sp_supplier_invoice 5769 5769 0 0.00 0 10353 19 0 0
t$perf-norm:sp_supplier_order 5643 5643 0 0.00 0 11151 16 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 225 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 3475 36 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 7288 21 0 0
t$perf-norm:srv_make_money_saldo 838 838 0 0.00 0 6198 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 465 118 0 0
v_add_invoice_to_stock 10308 10078 230 2.23 0 6754 18 0 230
v_all_customers 38690 38690 0 0.00 0 126 1 0 0
v_all_suppliers 31772 31772 0 0.00 0 79 1 0 0
v_all_wares 42100 42100 0 0.00 0 66 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 1317 7 0 0
v_cancel_client_order 3708 3708 0 0.00 0 4125 5 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 1235 4 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 6905 11 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 3475 8 0 0
v_cancel_supplier_invoice 856 830 26 3.03 0 2537 17 0 26
v_cancel_supplier_order 870 870 0 0.00 0 1569 5 0 0
v_cancel_write_off 2052 2052 0 0.00 0 4630 16 0 0
v_max_id_clo_ord 5643 5643 0 0.00 0 1342 1 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 5645 22 0 0
v_max_id_ord_sup 5748 5748 0 0.00 0 2786 3 0 0
v_max_non_paid_invoice 1568 1568 0 0.00 0 651 3 0 0
v_max_non_paid_realizn 3785 3785 0 0.00 0 2874 4 0 0
v_min_id_clo_ord 5643 5643 0 0.00 0 2719 6 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 9048 20 0 0
v_min_id_ord_sup 5748 5748 0 0.00 0 5566 7 0 0
v_min_non_paid_invoice 6063 6063 0 0.00 0 10167 12 0 0
v_min_non_paid_realizn 7350 7350 0 0.00 0 8807 14 0 0
v_our_firm 10540 10540 0 0.00 0 25 1 0 0
v_reserve_write_off 20684 20684 0 0.00 0 4938 6 0 0
x_lock_depdocs_on_canc_invoice 13148 13148 0 0.00 0 12855 103 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 15114 353 0 0
x_make_qstorno_1000_1200 5643 5643 0 0.00 1 25372 1042 0 0
x_make_qstorno_1200_2000 5769 5769 0 0.00 3 91193 2838 0 0
x_make_qstorno_2100_3300 465037 465037 0 0.00 0 49360 132 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-12-2020 19:28:34 to 21-12-2020 19:28:38.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:09 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 8927 8192000000 10199365888 10494861312 859648848 9.497 70 54 105 0 879927344 2362672 17915824
16:57:35 17745 8192000000 10314271168 10629459968 1365957008 14.291 100 78 156 0 1395487520 4273856 25256656
16:58:05 23938 8192000000 10372550368 10693017600 1420441728 14.777 100 85 170 0 1453329440 5592368 27295344
16:58:44 17248 8192000000 10391472480 10716741632 1455215840 15.084 100 88 176 0 1490741824 6913328 28612656
16:59:10 25550 8192000000 10418883904 10747715584 1468176848 15.198 100 82 164 0 1501691520 7432288 26082384
16:59:47 28096 8192000000 10447525600 10778845184 1498619264 15.464 100 88 176 0 1534811600 8200704 27991632
17:00:27 20455 8192000000 10466387024 10801577984 1518153648 15.634 100 83 166 0 1553279808 9373984 25752176
17:00:55 6945 8192000000 10475422752 10813792256 1535595360 15.785 100 85 170 0 1571499904 9391696 26512848
17:01:10 13214 8192000000 10501380528 10842906624 1557208176 15.972 100 89 178 1 1593785120 10031776 26545168
17:01:35 18819 8192000000 10535312752 10882723840 1579468880 16.164 100 89 178 1 1616557408 10939024 26149504
17:02:03 13376 8192000000 10550173472 10906218496 1616148768 16.477 100 86 172 1 1652707504 11553376 25005360
17:02:28 9633 8192000000 10573963152 10932793344 1632853680 16.619 100 81 160 1 1667793312 11678608 23261024
17:02:46 11595 8192000000 10597013952 10959912960 1654601056 16.803 100 83 166 1 1691242992 12477120 24164816
17:03:04 7894 8192000000 10612200864 10981421056 1677305232 16.995 100 75 148 3 1709834304 11411936 21117136
17:03:19 5178 8192000000 10636005888 11006357504 1693485472 17.131 100 78 156 0 1727115120 11177632 22452016
17:03:33 8556 8192000000 10656312080 11025690624 1711613968 17.282 100 84 166 1 1747338112 11746640 23977504
17:03:48 6121 8192000000 10664761680 11038425088 1722618240 17.374 100 77 154 1 1755306896 10666048 22022608
17:04:05 7689 8192000000 10683879200 11061850112 1747599936 17.582 100 79 156 2 1781500736 11309600 22591200
17:04:20 5384 8192000000 10705494656 11078881280 1756424272 17.655 100 77 154 1 1790164576 12285088 21455216
17:04:32 4488 8192000000 10709294848 11088592896 1769346272 17.762 100 84 168 2 1807513216 14154320 24012624
17:04:43 3840 8192000000 10713055776 11093823488 1775083872 17.809 100 82 162 2 1811670016 14215952 22370192
17:04:54 2443 8192000000 10723994160 11101630464 1784063536 17.883 100 84 168 0 1822299712 14496640 23739536
17:05:03 3803 8192000000 10735023376 11114885120 1792978576 17.956 100 82 165 0 1828885552 14031392 21875584
17:05:13 2751 8192000000 10740687008 11126308864 1801247504 18.024 100 86 171 1 1838015808 13275632 23492672
17:05:22 2359 8192000000 10750600400 11131236352 1811062000 18.105 100 89 178 0 1849618976 13834016 24722960
17:05:31 3027 8192000000 10760858016 11144286208 1817146608 18.154 100 91 183 2 1856480016 14296816 25036592
17:05:41 2924 8192000000 10753152256 11140136960 1815278512 18.139 100 81 162 0 1851968640 14804432 21885696
17:05:51 2102 8192000000 10774650496 11159576576 1820767888 18.184 100 88 174 1 1859782976 15224592 23790496
17:05:59 1985 8192000000 10783901680 11165593600 1837651376 18.322 100 96 192 0 1879845680 15590112 26604192
17:06:08 2735 8192000000 10781940960 11169009664 1841394512 18.352 100 83 167 2 1878387984 13987808 23005664
17:06:17 1632 8192000000 10794784528 11179466752 1847080768 18.398 100 89 178 0 1885834128 13694240 25059120
17:06:25 1567 8192000000 10793546432 11178790912 1850529952 18.426 100 91 182 1 1890139088 13853248 25755888
17:06:33 1824 8192000000 10794415184 11180150784 1852596352 18.443 100 91 181 1 1891975360 12837392 26541616
17:06:41 1211 8192000000 10798461088 11184361472 1857834512 18.486 100 95 191 0 1896685424 12105088 26745824
17:06:49 1519 8192000000 10806439920 11194425344 1863015312 18.528 100 93 183 0 1902524096 13559248 25949536
17:06:56 1102 8192000000 10818292400 11205185536 1870366544 18.587 100 96 192 1 1912801872 15017408 27417920
17:07:04 1641 8192000000 10815816048 11204403200 1873344048 18.611 100 97 191 1 1915114288 14806272 26963968
17:07:11 1888 8192000000 10820345664 11209125888 1874713216 18.622 100 92 184 1 1913361920 12441728 26206976
17:07:20 4893 8192000000 10804234608 11215003648 1874887296 18.624 100 77 155 0 1909478848 13055184 21536368
17:07:31 17317 8192000000 10815007968 11213438976 1874549632 18.621 100 63 128 0 1902547376 9360784 18636960
17:07:57 3998 8192000000 10786013904 11207806976 1872479872 18.604 100 42 84 0 1894160656 10062624 11618160
17:08:08 3772 8192000000 10795724736 11210395648 1872813008 18.607 100 37 75 2 1891237584 7495616 10928960
17:08:20 4104 8192000000 10779689440 11210670080 1872931360 18.608 100 30 58 2 1888604864 8006912 7666592
17:08:30 8818 8192000000 10789941568 11212541952 1877392672 18.644 100 41 82 0 1899411840 9735936 12283232
17:08:46 7454 8192000000 10787230032 11215720448 1878235936 18.651 100 32 64 2 1899144400 11218992 9689472
17:08:59 15762 8192000000 10780260352 11215773696 1877397968 18.644 100 17 35 0 1888971712 6541008 5032736
17:09:27 6004 8192000000 10790380704 11221213184 1883267856 18.691 100 31 62 1 1898640000 6711504 8660640
17:09:42 13424 8192000000 10784626112 11222798336 1879980432 18.665 100 13 26 1 1888847648 5496864 3370352
17:10:03 11658 8192000000 10792678976 11233132544 1890293952 18.748 100 20 41 1 1902117504 6460560 5362992
17:10:21 10197 8192000000 10800070608 11232088064 1892835824 18.769 100 18 36 1 1904201808 5911456 5454528
17:10:37 5998 8192000000 10801131280 11235065856 1891990688 18.762 100 13 25 0 1901487648 5538864 3958096
17:10:51 10667 8192000000 10809387008 11239809024 1899011824 18.818 100 13 26 1 1908138160 5640288 3486048
17:11:10 24293 8192000000 10799489776 11246469120 1901408320 18.838 100 20 40 0 1913111440 6346160 5356960
17:11:40 49154 8192000000 10830919280 11261956096 1905433760 18.870 100 31 56 2 1923321840 9966592 7921488
17:12:37 8036 8192000000 10822667360 11253784576 1903209472 18.852 100 28 55 2 1917343776 6062096 8072208
17:12:53 6818 8192000000 10820113520 11253395456 1903038976 18.851 100 24 47 2 1916721808 6254192 7428640
17:13:06 8054 8192000000 10822496784 11256967168 1903990288 18.858 100 24 48 1 1917347568 6767632 6589648
17:13:20 7073 8192000000 10821111312 11256377344 1905376768 18.870 100 19 38 1 1916024704 5573936 5074000
17:13:36 3665 8192000000 10831058800 11259895808 1908856208 18.897 100 35 69 2 1924935648 6519056 9560384
17:13:47 7083 8192000000 10819383872 11249758208 1888786816 18.736 99 34 68 3 1905164816 6898608 9479392
17:14:03 8317 8192000000 10814664240 11252944896 1905720320 18.872 100 29 58 0 1920022544 6284864 8017360
17:14:18 9707 8192000000 10818397072 11254140928 1904022368 18.859 100 31 61 1 1919064992 5710576 9332048
17:14:36 9836 8192000000 10818964112 11256233984 1901958288 18.842 100 23 44 3 1913294624 5222976 6113360
17:14:52 6167 8192000000 10808115936 11248254976 1900485792 18.830 100 18 36 2 1911132032 5718480 4927760
17:15:05 9791 8192000000 10815538528 11251589120 1888371552 18.733 99 17 34 0 1900074864 6789408 4913904
17:15:24 9416 8192000000 10818593312 11255353344 1897724112 18.808 100 15 30 1 1911275456 9782464 3768880
17:15:45 11346 8192000000 10804884928 11248779264 1896474336 18.798 100 15 30 1 1906560800 6088304 3998160
17:16:06 69176 8192000000 10769077440 11187572736 1708240304 17.254 90 29 59 1 1721990048 4514528 9235216
17:17:22 15594 8192000000 10745595680 11178434560 1769058224 17.759 95 17 34 1 1783078208 9403680 4616304
17:17:46 8953 8192000000 10704279952 11121942528 1709046736 17.261 93 23 45 2 1725125488 9699296 6379456
17:18:01 3934 8192000000 10742802688 11159801856 1790229744 17.934 98 43 86 1 1814614864 12379216 12005904
17:18:13 8045 8192000000 10725270160 11151577088 1751340032 17.613 96 25 50 1 1763932064 5257264 7334768
17:18:29 6258 8192000000 10704770240 11124502528 1764860624 17.725 97 19 38 0 1775765504 5455776 5449104
17:18:41 7587 8192000000 10688101952 11110457344 1734383984 17.472 97 20 40 2 1745920384 5672704 5863696
17:18:55 7342 8192000000 10690069392 11090399232 1706558000 17.240 95 23 46 2 1718195744 4920672 6717072
17:19:11 6445 8192000000 10681983920 11093843968 1733131728 17.462 97 20 40 1 1744195024 5645344 5417952
17:19:25 4473 8192000000 10685991920 11091685376 1761047232 17.693 99 47 94 1 1781080512 5914560 14118720
17:19:38 8275 8192000000 10677723552 11092004864 1721098352 17.361 97 17 34 2 1730675104 5089744 4487008
17:19:52 10516 8192000000 10707277712 11127009280 1787370784 17.910 100 23 46 0 1800317440 6349952 6596704
17:20:11 8181 8192000000 10727535408 11137384448 1800673440 18.019 100 38 76 1 1817352352 4979312 11699600
17:20:27 7503 8192000000 10718951056 11139874816 1789873328 17.931 99 24 48 1 1802478336 5509120 7095888
17:20:41 17692 8192000000 10728202896 11156111360 1816251632 18.147 100 16 32 1 1826547680 5244544 5051504
17:21:08 55791 8192000000 10760245552 11184996352 1836844064 18.315 100 36 72 1 1853813104 5594736 11374304
17:22:16 18449 8192000000 10760823568 11180871680 1839139232 18.334 100 22 44 2 1850711904 5511136 6061536
17:22:44 8037 8192000000 10762049152 11187302400 1846566848 18.394 100 39 76 2 1864370000 7709008 10094144
17:22:58 7327 8192000000 10764230608 11194912768 1849355104 18.417 100 32 64 1 1869817696 11545408 8917184
17:23:13 4469 8192000000 10756253936 11191001088 1852785344 18.445 100 28 56 2 1867118032 6328512 8004176
17:23:24 7285 8192000000 10770727888 11199881216 1857220832 18.481 100 27 54 0 1871099392 6216896 7661664
17:23:38 8449 8192000000 10767143088 11195924480 1856319104 18.473 100 18 36 1 1866617408 5122544 5175760
17:23:53 9492 8192000000 10765707248 11199651840 1859166704 18.497 100 29 58 1 1874011968 6457984 8387280
17:24:12 15910 8192000000 10778487040 11203952640 1859619312 18.500 100 13 26 0 1868480112 5175568 3685232
17:24:35 12758 8192000000 10776731152 11211472896 1867997376 18.568 100 17 34 1 1878122000 5206848 4917776
17:24:58 10749 8192000000 10784783120 11215831040 1871930064 18.600 100 35 70 2 1888231856 4901136 11400656
17:25:20 8731 8192000000 10782207104 11219181568 1874554544 18.621 100 26 51 0 1887550224 5262064 7733616
17:25:36 6357 8192000000 10786645392 11219656704 1874174304 18.618 100 15 30 2 1883958992 5505424 4279264
17:25:50 11282 8192000000 10780371552 11220451328 1874978976 18.625 100 12 23 1 1883824672 5414944 3430752
17:26:07 15168 8192000000 10808174032 11225612288 1879291024 18.659 100 17 34 0 1889350688 5465008 4594656
17:26:29 95151 8192000000 10838076640 11264274432 1894328912 18.781 100 39 78 1 1920071040 14148528 11593600
17:28:28 28989 8192000000 10859907120 11285811200 1931065104 19.075 100 37 74 2 1950483664 8571488 10847072
17:29:35 13497 8192000000 10849828544 11282984960 1903714480 18.856 98 42 85 0 1928849872 13321392 11814000
17:29:56 9627 8192000000 10872823024 11293286400 1935094608 19.108 100 34 66 1 1952504800 7226016 10184176
17:30:16 11929 8192000000 10870280112 11291897856 1929616464 19.064 99 49 98 1 1954478800 10616800 14245536
17:30:36 21573 8192000000 10883070928 11309481984 1950467744 19.230 100 51 102 2 1976820144 11942736 14409664
17:31:04 12841 8192000000 10887525568 11314610176 1946517056 19.199 100 52 104 0 1974256784 12819680 14920048
17:31:30 18520 8192000000 10882714688 11314974720 1947305440 19.205 100 45 91 0 1978070352 16973696 13791216
17:32:00 23163 8192000000 10895839008 11328831488 1960903936 19.313 100 45 90 3 1990175168 15404160 13867072
17:32:41 9566 8192000000 10916177424 11339558912 1969878064 19.384 100 42 84 2 1997153536 14708128 12567344
17:32:58 9390 8192000000 10922150928 11349999616 1977943008 19.448 100 59 115 2 2011792064 16715104 17133952
17:33:19 13491 8192000000 10923021008 11356938240 1981843872 19.479 100 46 92 3 2013600000 17993312 13762816
17:33:51 12755 8192000000 10920239648 11360768000 1982919008 19.488 100 41 82 1 2017163904 21463360 12781536
17:34:15 16248 8192000000 10930703472 11369967616 1989214496 19.538 100 41 82 0 2026929728 24954400 12760832
17:34:39 5918 8192000000 10936081744 11372109824 1994732528 19.581 100 50 100 0 2030039264 19871520 15435216
17:34:58 6449 8192000000 10951304592 11381014528 2001468400 19.634 100 61 120 2 2044004544 24348304 18187840
17:35:11 7877 8192000000 10939078016 11375288320 1995606032 19.588 100 53 106 2 2031091936 19605088 15880816
17:35:27 3764 8192000000 10964493936 11386556416 2007704912 19.683 100 71 140 1 2049678464 21361200 20612352
17:35:39 2051 8192000000 10969365152 11387297792 1994882400 19.582 99 85 167 0 2042851616 23066784 24902432
17:35:49 5909 8192000000 10959279088 11384852480 2002043456 19.639 100 77 154 0 2051593584 26002912 23547216
17:36:03 2002 8192000000 10973627792 11394654208 2004965248 19.662 100 73 146 1 2052644112 25958144 21720720
17:36:15 4393 8192000000 10951453472 11382919168 1980156112 19.466 99 64 127 1 2029403984 29489168 19758704
17:36:27 8260 8192000000 10954242064 11380682752 1994114352 19.576 100 67 133 2 2043492432 29062672 20315408
17:36:43 11412 8192000000 10950193312 11380736000 1999364208 19.618 100 70 137 2 2047333760 27499440 20470112
17:37:04 8383 8192000000 10964013552 11390795776 1998522736 19.611 100 69 134 1 2050610512 32307424 19780352
17:37:22 2545 8192000000 10980052848 11405066240 2008395856 19.689 100 71 142 4 2063131680 34179120 20556704
17:37:34 1581 8192000000 10989045424 11408809984 1999258144 19.617 99 84 166 0 2062301568 38177248 24866176
17:37:42 1089 8192000000 10958445584 11374198784 1980380336 19.468 99 78 156 0 2040871888 36666976 23824576
17:37:50 6749 8192000000 10958316976 11382444032 1976965776 19.441 99 75 150 1 2036687744 36879776 22842192
17:38:05 1594 8192000000 10946012240 11356176384 1965110592 19.347 99 87 170 1 2026372352 36987152 24274608
17:38:14 3459 8192000000 10957947216 11377373184 1981405616 19.476 100 74 148 1 2041025808 38060544 21559648
17:38:25 1980 8192000000 10973990288 11387596800 1992195264 19.561 100 80 160 1 2055092496 38534592 24362640
17:38:34 1975 8192000000 10974574656 11388407808 1990706752 19.549 100 93 186 4 2061085456 42188528 28190176
17:38:43 970 8192000000 10958701040 11365879808 1975319648 19.428 100 88 175 0 2043122608 42360112 25442848
17:38:51 4337 8192000000 10979177072 11388186624 1987319040 19.523 100 79 159 0 2057452320 46074768 24058512
17:39:02 1134 8192000000 10968693328 11381800960 1978122448 19.450 99 87 171 1 2050407184 45860864 26423872
17:39:10 1549 8192000000 10989085568 11397308416 1978674848 19.454 99 91 177 7 2052903968 47444192 26784928
17:39:18 1991 8192000000 10967957552 11386773504 1981168240 19.474 100 79 156 0 2053466800 47987328 24311232
17:39:32 3075 8192000000 10962817056 11390107648 1983368720 19.491 100 63 125 1 2049101568 46307200 19425648
17:39:46 3224 8192000000 10948798816 11367796736 1965703728 19.351 99 72 137 2 2032041872 44275152 22062992
17:39:56 2985 8192000000 10969853904 11389235200 1985195216 19.506 100 78 156 1 2055390960 46125840 24069904
17:40:09 2117 8192000000 10969708736 11388280832 1983365536 19.491 100 79 158 1 2056695440 48462992 24866912
17:40:18 2746 8192000000 10966868592 11381432320 1974518576 19.421 100 82 160 0 2050048640 50467280 25062784
17:40:28 1264 8192000000 10957645264 11372089344 1955907376 19.273 99 77 154 0 2032570016 51747504 24915136
17:40:38 3235 8192000000 10962966112 11390898176 1979061728 19.457 100 59 118 3 2053687072 55665632 18959712
17:40:48 6284 8192000000 10946534768 11382194176 1962624432 19.327 99 57 114 1 2036781184 55797456 18359296
17:41:06 3623 8192000000 10948170304 11376521216 1966182064 19.355 100 57 112 1 2034497936 49956384 18359488
17:41:17 2098 8192000000 10959584400 11383037952 1976105280 19.434 100 61 121 1 2042393584 47749392 18538912
17:41:33 8840 8192000000 10950573664 11383296000 1960833696 19.313 99 48 95 1 2026167488 49903216 15430576
17:41:51 11327 8192000000 10960611184 11402059776 1984531840 19.501 100 49 98 1 2055600208 54455216 16613152
17:42:13 11023 8192000000 10940991888 11369082880 1956843216 19.281 99 52 104 0 2025009872 51530464 16636192
17:42:32 6338 8192000000 10947784976 11381899264 1940018992 19.147 98 51 102 1 2012451968 55964208 16468768
17:42:45 8965 8192000000 10949020304 11392442368 1969921040 19.385 100 35 70 2 2038141504 56312336 11908128
17:43:09 4046 8192000000 10952076672 11379519488 1951522240 19.239 99 58 116 1 2025274096 54823696 18928160
17:43:21 6664 8192000000 10953567168 11387949056 1969607600 19.382 100 45 90 0 2036566432 52279568 14679264
17:43:35 6797 8192000000 10953737456 11391553536 1961035552 19.314 99 42 84 0 2028174288 53065616 14073120
17:43:48 5093 8192000000 10967115840 11392765952 1981647904 19.478 100 54 106 3 2053937968 54347616 17942448
17:44:01 4947 8192000000 10974251856 11407900672 1988291280 19.530 100 50 98 1 2060504464 55938032 16275152
17:44:15 9586 8192000000 10990115376 11422236672 2001482480 19.634 100 48 96 0 2074703392 57602512 15618400
17:44:34 3821 8192000000 10996573712 11426910208 2001335664 19.633 100 57 114 1 2079310128 58983680 18990784
17:44:44 4552 8192000000 11008637168 11434680320 2007364976 19.681 100 72 145 3 2092585744 60919792 24300976
17:44:56 3629 8192000000 11009303024 11432259584 2004149600 19.655 100 63 124 2 2087614960 63068768 20396592
17:45:08 11005 8192000000 10982243456 11427229696 1962849760 19.329 98 40 80 2 2042152032 65033280 14268992
17:45:30 10736 8192000000 10976476288 11421065216 1976761088 19.439 99 40 80 1 2051762448 61348656 13652704
17:45:52 21528 8192000000 10992512736 11429945344 1992404288 19.563 100 50 100 1 2076042512 66776192 16862032
17:46:42 15236 8192000000 10984535200 11425005568 1993581552 19.572 100 40 80 1 2069196336 62065296 13549488
17:47:11 15644 8192000000 10959030704 11397586944 1934188096 19.100 98 37 75 1 2011948528 64864768 12895664
17:47:45 14540 8192000000 10947537712 11396636672 1948195392 19.212 99 35 70 0 2029564192 68933424 12435376
17:48:29 12132 8192000000 10969475584 11416506368 1962997248 19.330 100 40 80 0 2051327040 74012032 14317760
17:48:51 16294 8192000000 10959007392 11407667200 1961424288 19.317 100 31 62 0 2050883648 77631136 11828224
17:49:44 27738 8192000000 10971127632 11424280576 1945746176 19.193 100 28 56 0 2047304912 89651984 11906752
17:50:58 25366 8192000000 10901410608 11378286592 1946515888 19.199 100 26 52 0 2018939936 63599312 8824736
17:51:30 50412 8192000000 10903655584 11358728192 1908218352 18.892 98 7 14 0 1923396272 13177632 2000288
17:52:26 49468 8192000000 10878303664 11348660224 1915686656 18.952 98 10 21 0 1932972816 14642288 2643872
17:53:31 71612 8192000000 10892416432 11359072256 1964285840 19.340 100 22 44 1 1981529872 11392832 5851200
17:54:50 40514 8192000000 10891123856 11350286336 1904668224 18.864 97 13 26 1 1919400752 10705472 4027056
17:56:00 95387 8192000000 10878330464 11340210176 1893529616 18.774 97 19 38 1 1910975984 10486944 6959424
17:58:27 92238 8192000000 10882445328 11367034880 1939246912 19.141 99 18 36 1 1959099680 14869184 4983584
18:00:09 16437 8192000000 10892918496 11368095744 1957049360 19.283 100 8 16 0 1975312128 16677264 1585504
18:00:33 4952 8192000000 10894233888 11368873984 1959505568 19.302 100 13 26 1 1979917632 16864192 3547872
18:00:46 8803 8192000000 10892972240 11355267072 1964717952 19.344 100 19 39 0 1983093728 12631344 5744432
18:01:02 7233 8192000000 10920029152 11364872192 1972324480 19.404 100 37 74 1 1989362112 7258896 9778736
18:01:15 67334 8192000000 10916842352 11373342720 1948333280 19.213 98 31 62 1 1964789760 7381536 9074944
18:02:36 35334 8192000000 10934150032 11373338624 1979972176 19.464 100 59 118 2 2008479744 11610320 16897248
18:03:19 48619 8192000000 10903425632 11376177152 1963134608 19.331 99 31 62 2 1982614400 10508288 8971504
18:05:27 37325 8192000000 10924419824 11397799936 1990249712 19.546 100 12 24 0 2005256848 11766224 3240912
18:06:23 54169 8192000000 10921573056 11394572288 1996989232 19.599 100 16 32 2 2012068848 10585584 4494032
18:07:29 48625 8192000000 10911615664 11390726144 1975042800 19.425 99 15 30 1 1989662160 10205824 4413536
18:08:49 38832 8192000000 10933503664 11401203712 1996540368 19.595 100 16 32 0 2011568480 10576784 4451328
18:09:36 52950 8192000000 10917967328 11387822080 1965696272 19.351 98 19 38 0 1979289456 8423312 5169872
18:10:35 41461 8192000000 10912292384 11388006400 1974275440 19.419 99 19 36 2 1992516352 12759616 5481296
18:11:47 50235 8192000000 10910870816 11388436480 1987247712 19.522 100 10 20 0 1997899200 8255376 2396112
18:13:18 62514 8192000000 10907576768 11395731456 1989412144 19.539 100 12 24 0 2002304816 9340208 3552464
18:15:04 32408 8192000000 10898139136 11369046016 1957247568 19.284 98 29 58 2 1973377984 8107152 8023264
18:15:43 43648 8192000000 10924512544 11388166144 1955300640 19.269 98 30 60 2 1972531312 8748368 8482304
18:16:36 20461 8192000000 10913612032 11380068352 1970639840 19.391 99 36 72 0 1990524624 9899536 9985248
18:17:07 24081 8192000000 10916061824 11380690944 1967161936 19.363 99 32 64 2 1986485696 9406928 9916832
18:17:42 16533 8192000000 10925498544 11396141056 1968912000 19.377 99 22 44 2 1989712880 14991136 5809744
18:18:05 30803 8192000000 10923948320 11394273280 1932079904 19.084 97 15 30 1 1951627392 15061392 4486096
18:18:42 45609 8192000000 10898925984 11360825344 1875047200 18.625 95 26 52 2 1907824480 25342304 7434976
18:19:48 52118 8192000000 10879896192 11351683072 1915324688 18.949 98 18 36 1 1948379360 27222144 5832528
18:20:49 58714 8192000000 10865314576 11339407360 1891602368 18.759 98 18 36 3 1937959200 40636640 5720192
18:22:05 40881 8192000000 10905369680 11358674944 1945975008 19.194 100 26 52 1 1963647968 10583952 7089008
18:23:19 72934 8192000000 10892570032 11351400448 1867149968 18.561 95 14 28 1 1883769744 12562288 4057488
18:24:43 50599 8192000000 10886544992 11352285184 1926166896 19.036 98 38 76 3 1953076464 15845456 11064112
18:25:44 41852 8192000000 10884361520 11360681984 1939412528 19.142 99 18 36 0 1965819680 21187360 5219792
18:26:32 135810 8192000000 10868851920 11332747264 1883584848 18.694 96 21 42 2 1900315056 11118112 5612096
18:29:53 31193 8192000000 10874279936 11344211968 1940344384 19.150 99 23 44 1 1953682144 7867024 5470736
18:30:36 34855 8192000000 10874018592 11347234816 1934636592 19.104 99 11 22 0 1944313824 7128736 2548496
18:31:27 41531 8192000000 10865879680 11334299648 1926243568 19.037 99 13 26 0 1940076240 10435600 3397072
18:32:18 39398 8192000000 10837339904 11310039040 1846531072 18.394 95 12 25 1 1860017360 10432912 3053376
18:33:11 67503 8192000000 10829064544 11292467200 1886300544 18.716 98 9 18 1 1895849808 7113696 2435568
18:34:26 57014 8192000000 10850914512 11321225216 1880051952 18.666 97 10 20 0 1894253264 11198928 3002384
18:35:32 34903 8192000000 10872693776 11336040448 1926860512 19.042 99 27 53 2 1942026960 7848176 7318272
18:36:13 47500 8192000000 10865979536 11332300800 1897032032 18.802 97 28 56 0 1915349776 10157744 8160000
18:37:13 49023 8192000000 10860095760 11323908096 1867158256 18.561 96 17 34 1 1879312512 7585248 4569008
18:38:10 29585 8192000000 10861195232 11322589184 1896760992 18.800 98 24 48 4 1912114064 8070688 7282384
18:38:46 62659 8192000000 10865674880 11321511936 1864574240 18.540 96 28 57 3 1882159648 9383280 8202128
18:39:58 61463 8192000000 10885738864 11338817536 1903861664 18.857 98 21 42 0 1922425744 13084272 5479808
18:41:19 79954 8192000000 10861161744 11342184448 1867885056 18.567 96 20 40 0 1889483248 16025600 5572592
18:42:46 26514 8192000000 10880647472 11328765952 1911261856 18.917 98 36 73 0 1929039280 7485440 10291984
18:43:19 43020 8192000000 10902217664 11353055232 1950816272 19.233 100 32 64 0 1971469712 11922208 8731232
18:44:17 85507 8192000000 10884602624 11366838272 1910124848 18.908 98 7 14 0 1932224688 19692304 2407536
18:45:50 82773 8192000000 10895822336 11384254464 1917428448 18.966 98 10 20 0 1939935904 19509760 2997696
18:47:23 51989 8192000000 10903877120 11376467968 1962112800 19.323 100 12 24 0 1982415584 16953920 3348864
18:48:22 121167 8192000000 10894168960 11369398272 1966149792 19.355 100 17 34 0 1982903216 12600160 4153264
18:50:37 41568 8192000000 10904997680 11373617152 1961523232 19.318 99 40 80 2 1983350480 10849248 10978000
18:51:33 15708 8192000000 10891015008 11368878080 1954560944 19.263 99 24 48 0 1969917456 8831920 6524592
18:51:56 35128 8192000000 10902161264 11381596160 1979019296 19.457 100 21 42 1 1994877648 8831088 7027264
18:52:41 90752 8192000000 10903577744 11390386176 1968902912 19.377 99 21 42 0 1987348288 12364496 6080880
18:54:18 48706 8192000000 10915857664 11393040384 1964357024 19.341 99 18 36 0 1981312992 11499296 5456672
18:55:27 80029 8192000000 10883880176 11369455616 1948090736 19.211 98 17 34 2 1967342496 13641264 5610496
18:57:38 48399 8192000000 10914834960 11386454016 1958865184 19.297 99 5 9 0 1969818432 9980256 972992
18:58:32 73481 8192000000 10880428896 11361763328 1852236176 18.440 93 17 34 0 1869742096 13147152 4358768
18:59:52 14029 8192000000 10895852720 11355037696 1955721584 19.272 100 31 61 0 1970422928 6186304 8515040
19:00:16 23594 8192000000 10878355504 11339735040 1911598160 18.919 97 29 57 0 1928212032 8713648 7900224
19:00:46 32224 8192000000 10886107552 11353915392 1908231872 18.892 97 37 74 0 1928938832 10179024 10527936
19:01:34 36149 8192000000 10902923568 11353468928 1939394000 19.142 99 21 41 1 1959666064 14011424 6260640
19:02:16 22777 8192000000 10925264192 11372810240 1956750128 19.280 99 54 107 0 1980109008 7801152 15557728
19:02:49 20723 8192000000 10918287712 11378667520 1981406128 19.476 100 46 93 1 2006103904 12089008 12608768
19:03:20 107398 8192000000 10892435520 11362578432 1867677424 18.565 94 18 36 1 1887268080 14158096 5432560
19:05:15 78689 8192000000 10899899424 11378069504 1903567744 18.855 97 11 22 0 1925881776 19138256 3175776
19:06:50 73204 8192000000 10902450672 11386310656 1951895376 19.242 99 14 28 1 1971506592 15427168 4184048
19:08:14 79329 8192000000 10914181792 11379351552 1945386240 19.190 98 16 32 0 1962254128 12626016 4241872
19:09:41 68537 8192000000 10926924400 11393134592 1978680496 19.454 100 20 40 0 1993521264 8533856 6306912
19:10:57 87141 8192000000 10918815888 11396444160 1968721440 19.375 99 8 16 0 1984984624 13990000 2273184
19:13:06 48700 8192000000 10896946944 11387351040 1973665360 19.415 100 15 30 1 1989443968 11802560 3976048
19:14:25 76204 8192000000 10891469664 11382149120 1939673520 19.144 98 12 24 4 1950704352 7633200 3397632
19:15:47 62149 8192000000 10890756944 11378450432 1966729712 19.359 99 9 18 1 1982907888 13730976 2447200
19:17:11 80669 8192000000 10895340112 11381657600 1928125440 19.052 97 18 36 0 1943283664 9872752 5285472
19:18:42 84964 8192000000 10881403136 11360292864 1912019728 18.923 97 15 30 1 1931233024 14314736 4898560
19:20:21 65572 8192000000 10867880048 11357392896 1925518320 19.031 98 13 25 3 1942202304 12958544 3725440
19:21:35 98077 8192000000 10884471168 11360612352 1908541696 18.895 97 12 24 1 1927389504 15240096 3607712
19:23:26 52316 8192000000 10849551072 11331616768 1864941776 18.543 96 14 28 0 1879854416 11009856 3902784
19:24:27 76395 8192000000 10843821136 11305033728 1804042656 18.047 93 18 36 0 1820295904 11001024 5252224
19:25:51 27693 8192000000 10870359536 11335675904 1933526496 19.095 100 34 68 2 1954067440 10591936 9949008
19:26:36 41865 8192000000 10019071376 10404454400 1143364736 12.247 58 18 32 2 1158006192 9766192 4875264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-12-2020 19:28:39 to 21-12-2020 19:29:11.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 21-12-2020 19:29:12 to 21-12-2020 19:29:13.

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          250369
MON$OLDEST_ACTIVE               250370
MON$OLDEST_SNAPSHOT             250370
MON$NEXT_TRANSACTION            250370
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                       2045792
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:191: 
:192: mscs-test-161.budzdorov.ru    Mon Dec 21 19:27:34 2020
:193:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:194: 
:195: 
:196: mscs-test-161.budzdorov.ru    Mon Dec 21 19:27:36 2020
:197:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:198: 
--- end of diff output ---

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

21.12.20 19:29:14. 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-12-21 19:29:17 No severe PSQL-related problems occured
21.12.20 19:29:18. End of report.