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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-13 16:27:17
DTS_END                         2021-02-13 16:27:17.3660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60538
TRN_ID                          241166
ATT_ID                          677
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: 8957.46 22567 1074895
customer order: creation 170.17 380 20420
customer order: refuse 14.62 349 1754
order to supplier: creation 45.33 1290 5439
order to supplier: removal 3.37 109450 404
invoice (draft): creation 46.17 3512 5540
invoice (draft): removal 50.12 833 6014
invoice accept: apply 41.77 19271 5012
invoice accept: cancel 45.17 913 5420
customer reserve: creation 3800.86 194 456103
customer reserve: removal 4446.05 66 533526
realization accept: apply 82.87 186 9944
realization accept: cancel 81.00 113 9720
payment from customer: creation 59.07 134 7088
payment from customer: removal 5.87 102 704
payment to supplier: creation 48.97 139 5876
payment to supplier: removal 3.53 71 424
service: total inventory turnovers 4.81 981 577
service: total monetary turnovers 6.91 48 829
service: aggregate perf. data 0.81 22889 97
service: refresh index statistics 0.03 290422 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-02-2021 16:28:40 to 13-02-2021 16:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7417
TEST_TIME 2 5809
TEST_TIME 3 5239
TEST_TIME 4 5716
TEST_TIME 5 5813
TEST_TIME 6 5437
TEST_TIME 7 5718
TEST_TIME 8 6255
TEST_TIME 9 6491
TEST_TIME 10 6608
TEST_TIME 11 7080
TEST_TIME 12 6960
TEST_TIME 13 6939
TEST_TIME 14 7095
TEST_TIME 15 6966
TEST_TIME 16 6919
TEST_TIME 17 6968
TEST_TIME 18 7322
TEST_TIME 19 7580
TEST_TIME 20 8228
TEST_TIME 21 8367
TEST_TIME 22 8391
TEST_TIME 23 8573
TEST_TIME 24 9052
TEST_TIME 25 9272
TEST_TIME 26 10140
TEST_TIME 27 10876
TEST_TIME 28 10828
TEST_TIME 29 10498
TEST_TIME 30 10154
TEST_TIME 31 10187
TEST_TIME 32 10393
TEST_TIME 33 10364
TEST_TIME 34 10188
TEST_TIME 35 10037
TEST_TIME 36 9949
TEST_TIME 37 9875
TEST_TIME 38 9850
TEST_TIME 39 9718
TEST_TIME 40 9622
TEST_TIME 41 9463
TEST_TIME 42 9413
TEST_TIME 43 9377
TEST_TIME 44 9223
TEST_TIME 45 9168
TEST_TIME 46 9078
TEST_TIME 47 9018
TEST_TIME 48 9184
TEST_TIME 49 9303
TEST_TIME 50 9210
TEST_TIME 51 9167
TEST_TIME 52 9200
TEST_TIME 53 9155
TEST_TIME 54 9178
TEST_TIME 55 9198
TEST_TIME 56 9238
TEST_TIME 57 9207
TEST_TIME 58 9344
TEST_TIME 59 9367
TEST_TIME 60 9346
TEST_TIME 61 9341
TEST_TIME 62 9403
TEST_TIME 63 9352
TEST_TIME 64 9378
TEST_TIME 65 9315
TEST_TIME 66 9306
TEST_TIME 67 9262
TEST_TIME 68 9247
TEST_TIME 69 9195
TEST_TIME 70 9138
TEST_TIME 71 9167
TEST_TIME 72 9089
TEST_TIME 73 9194
TEST_TIME 74 9139
TEST_TIME 75 9208
TEST_TIME 76 9196
TEST_TIME 77 9264
TEST_TIME 78 9222
TEST_TIME 79 9226
TEST_TIME 80 9186
TEST_TIME 81 9251
TEST_TIME 82 9317
TEST_TIME 83 9408
TEST_TIME 84 9366
TEST_TIME 85 9394
TEST_TIME 86 9423
TEST_TIME 87 9354
TEST_TIME 88 9303
TEST_TIME 89 9309
TEST_TIME 90 9253
TEST_TIME 91 9243
TEST_TIME 92 9227
TEST_TIME 93 9162
TEST_TIME 94 9094
TEST_TIME 95 9137
TEST_TIME 96 9102
TEST_TIME 97 9087
TEST_TIME 98 9118
TEST_TIME 99 9156
TEST_TIME 100 9165
TEST_TIME 101 9172
TEST_TIME 102 9190
TEST_TIME 103 9160
TEST_TIME 104 9145
TEST_TIME 105 9215
TEST_TIME 106 9188
TEST_TIME 107 9245
TEST_TIME 108 9221
TEST_TIME 109 9192
TEST_TIME 110 9152
TEST_TIME 111 9113
TEST_TIME 112 9126
TEST_TIME 113 9090
TEST_TIME 114 9048
TEST_TIME 115 9014
TEST_TIME 116 8988
TEST_TIME 117 9011
TEST_TIME 118 8986
TEST_TIME 119 9025
TEST_TIME 120 8960

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-02-2021 16:28:43 to 13-02-2021 16:28:47.

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 1497789 1497789 0 0.00 0 17775 7 0 0
doc_list_biud 1497786 1497786 0 0.00 0 39187 30 0 0
sp_add_invoice_to_stock 5153 5012 141 2.73 56 204742 19272 0 141
sp_cancel_adding_invoice 5420 5420 0 0.00 4 62697 914 0 0
sp_cancel_client_order 1754 1754 0 0.00 4 13178 349 0 0
sp_cancel_customer_reserve 533526 533526 0 0.00 1 31217 66 0 0
sp_cancel_pay_from_customer 704 704 0 0.00 2 8079 103 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 2 3740 71 0 0
sp_cancel_supplier_invoice 6025 6014 11 0.18 1 26838 834 0 11
sp_cancel_supplier_order 404 404 0 0.00 8 1201489 109451 0 0
sp_cancel_write_off 9720 9720 0 0.00 1 14131 114 0 0
sp_client_order 20420 20420 0 0.00 4 30953 380 0 0
sp_customer_reserve 456103 456103 0 0.00 0 82480 195 0 0
sp_fill_shopping_cart 31392 31392 0 0.00 1 19734 40 0 0
sp_fill_shopping_cart_clo_res 456090 456090 0 0.00 0 23634 15 0 0
sp_get_clo_for_invoice 4999 4999 0 0.00 0 31470 318 0 0
sp_kill_cost_storno 16268 16268 0 0.00 0 6117 59 0 0
sp_kill_qstorno_ret_qs2qd 1083190 1083190 0 0.00 0 26823 36 0 0
sp_kill_qty_storno 571781 571781 0 0.00 0 39185 77 0 0
sp_lock_selected_doc 20789 20789 0 0.00 0 7999 8 0 0
sp_make_cost_storno 27907 27907 0 0.00 0 16802 58 0 0
sp_multiply_rows_for_pdistr 27907 27907 0 0.00 0 11292 27 0 0
sp_multiply_rows_for_qdistr 20420 20420 0 0.00 0 20953 169 0 0
sp_pay_from_customer 7088 7088 0 0.00 4 25327 135 0 0
sp_pay_to_supplier 5876 5876 0 0.00 4 14600 140 0 0
sp_payment_common 12964 12964 0 0.00 1 25318 34 0 0
sp_qd_handle_on_cancel_clo 1754 1754 0 0.00 0 13168 313 0 0
sp_qd_handle_on_invoice_upd_sts 10419 10419 0 0.00 0 39183 367 0 0
sp_qd_handle_on_reserve_upd_sts 9944 9944 0 0.00 0 20200 58 0 0
sp_reserve_write_off 9944 9944 0 0.00 6 23167 186 0 0
sp_supplier_invoice 5540 5540 0 0.00 6 101080 3513 0 0
sp_supplier_order 5439 5439 0 0.00 5 37156 1291 0 0
srv_aggregate_perf_data 97 97 0 0.00 2636 496819 22890 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 718 133198 32053 0 0
srv_find_qd_qs_mism 1027744 1027744 0 0.00 0 17774 6 0 0
srv_make_invnt_saldo 577 577 0 0.00 40 31028 982 0 0
srv_make_money_saldo 829 829 0 0.00 1 20742 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 182315 465025 290422 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5012 5012 0 0.00 0 18780 168 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 19672 144 0 0
t$perf-norm:sp_cancel_client_order 1754 1754 0 0.00 0 7928 12 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 2235 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 704 704 0 0.00 0 465 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 4997 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 430 430 0 0.00 0 1047 14 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 37153 1673 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 13371 25 0 0
t$perf-norm:sp_client_order 20420 20420 0 0.00 0 12963 20 0 0
t$perf-norm:sp_customer_reserve 976 976 0 0.00 0 1234 6 0 0
t$perf-norm:sp_pay_from_customer 7088 7088 0 0.00 0 13252 15 0 0
t$perf-norm:sp_pay_to_supplier 5876 5876 0 0.00 0 12907 18 0 0
t$perf-norm:sp_reserve_write_off 9944 9944 0 0.00 0 5374 8 0 0
t$perf-norm:sp_supplier_invoice 5540 5540 0 0.00 0 16794 23 0 0
t$perf-norm:sp_supplier_order 5439 5439 0 0.00 0 6795 20 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 730 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 194 2 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 925 19 0 0
t$perf-norm:srv_make_money_saldo 829 829 0 0.00 0 663 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 10280 9998 282 2.74 0 6632 19 0 282
v_all_customers 37304 37304 0 0.00 0 66 1 0 0
v_all_suppliers 30294 30294 0 0.00 0 66 1 0 0
v_all_wares 40840 40840 0 0.00 0 196 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 6643 24 0 0
v_cancel_client_order 3508 3508 0 0.00 0 3945 9 0 0
v_cancel_customer_prepayment 1408 1408 0 0.00 0 2010 7 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 958 6 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 419 4 0 0
v_cancel_supplier_invoice 882 860 22 2.49 0 2705 23 0 22
v_cancel_supplier_order 808 808 0 0.00 0 1009 5 0 0
v_cancel_write_off 1998 1998 0 0.00 0 4043 16 0 0
v_max_id_clo_ord 5439 5439 0 0.00 0 314 1 0 0
v_max_id_clo_res 976 976 0 0.00 0 5493 21 0 0
v_max_id_ord_sup 5533 5533 0 0.00 0 3213 5 0 0
v_max_non_paid_invoice 1701 1701 0 0.00 0 349 2 0 0
v_max_non_paid_realizn 3781 3781 0 0.00 0 4372 4 0 0
v_min_id_clo_ord 5439 5439 0 0.00 0 7472 8 0 0
v_min_id_clo_res 976 976 0 0.00 0 3231 9 0 0
v_min_id_ord_sup 5533 5533 0 0.00 0 5034 5 0 0
v_min_non_paid_invoice 5876 5876 0 0.00 0 14477 20 0 0
v_min_non_paid_realizn 7088 7088 0 0.00 0 18746 20 0 0
v_our_firm 10150 10150 0 0.00 0 13 1 0 0
v_reserve_write_off 19888 19888 0 0.00 0 6481 8 0 0
x_lock_depdocs_on_canc_invoice 11004 11004 0 0.00 0 8400 111 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 6246 334 0 0
x_make_qstorno_1000_1200 5439 5439 0 0.00 1 37144 1204 0 0
x_make_qstorno_1200_2000 5540 5540 0 0.00 3 101028 3371 0 0
x_make_qstorno_2100_3300 456103 456103 0 0.00 0 82479 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-02-2021 16:28:48 to 13-02-2021 16:28:52.

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
13:57:21 18 8192000000 8818880496 8834752512 22488976 0.273 4 4 5 0 22788192 87456 211760
13:57:27 14410 8192000000 10182143968 10479132672 730186208 8.183 60 48 97 1 748572624 1939648 16446768
13:57:48 19522 8192000000 10285550896 10595602432 1335112112 14.013 100 84 169 0 1366491936 3812176 27567648
13:58:20 11793 8192000000 10347802320 10663100416 1410481360 14.688 100 89 178 0 1445037968 5282384 29274224
13:58:45 18433 8192000000 10381053360 10701303808 1435361328 14.909 100 92 184 0 1471589824 6335840 29892656
13:59:14 27074 8192000000 10407557248 10729119744 1456991200 15.099 100 93 186 1 1494599008 7349696 30258112
13:59:52 20280 8192000000 10414340144 10740137984 1465406576 15.173 100 88 176 2 1502358944 8492464 28459904
14:00:29 16441 8192000000 10429526832 10759225344 1484484112 15.341 100 90 180 1 1522503248 9024016 28995120
14:01:03 17700 8192000000 10458908688 10794266624 1507737904 15.544 100 85 171 1 1544146832 9294000 27114928
14:01:29 17573 8192000000 10488377152 10830233600 1537768672 15.804 100 85 171 0 1573001360 8989264 26243424
14:02:04 18810 8192000000 10529927296 10878181376 1586443696 16.223 100 81 162 2 1621003712 10212528 24347488
14:02:36 14827 8192000000 10571663264 10928517120 1635131296 16.638 100 83 166 2 1671110496 11888336 24090864
14:02:57 10927 8192000000 10592916672 10955911168 1651861680 16.780 100 83 166 2 1688951232 12724864 24364688
14:03:17 11757 8192000000 10611687328 10971828224 1668716880 16.922 100 85 170 0 1706428544 12904960 24806704
14:03:36 12616 8192000000 10623201168 10987970560 1681521664 17.030 100 80 160 1 1716986304 12960192 22504448
14:03:57 8759 8192000000 10640446096 11009417216 1695537568 17.148 100 82 164 1 1733344112 14055264 23751280
14:04:13 9998 8192000000 10662084416 11029876736 1707779712 17.250 100 82 165 0 1746094016 14564752 23749552
14:04:30 9873 8192000000 10662761776 11032981504 1722318496 17.372 100 81 162 0 1760556352 14970992 23266864
14:04:47 6967 8192000000 10679956624 11050348544 1735986752 17.485 100 89 176 1 1775447408 14629344 24831312
14:05:01 7851 8192000000 10684806400 11057934336 1746233952 17.570 100 81 161 0 1782256416 13797536 22224928
14:05:16 5876 8192000000 10697665584 11072757760 1757718816 17.666 100 76 153 0 1791632320 12579536 21333968
14:05:29 6159 8192000000 10707553936 11089297408 1768346784 17.753 100 74 148 1 1801320848 12112368 20861696
14:05:42 3211 8192000000 10707967744 11086970880 1776816192 17.823 100 87 173 0 1814584608 13844928 23923488
14:05:52 4892 8192000000 10726275136 11108282368 1785223568 17.892 100 83 166 5 1822572384 14326992 23021824
14:06:03 3734 8192000000 10729829072 11110682624 1792093568 17.949 100 81 162 1 1828370912 13163872 23113472
14:06:14 2618 8192000000 10749416656 11126583296 1800234256 18.016 100 90 181 0 1839858112 14495376 25128480
14:06:23 2279 8192000000 10746138720 11134013440 1808645968 18.085 100 86 173 0 1846716272 13938128 24132176
14:06:32 2314 8192000000 10751349712 11137826816 1819736176 18.176 100 90 179 0 1857401600 12115600 25549824
14:06:41 2503 8192000000 10767851536 11148595200 1822994032 18.202 100 82 163 1 1858179024 11819072 23365920
14:06:50 4123 8192000000 10754753824 11146821632 1823937824 18.210 100 70 140 1 1855580096 12920176 18722096
14:07:02 2279 8192000000 10777579088 11164778496 1829439040 18.255 100 86 169 2 1866374544 13416080 23519424
14:07:10 1767 8192000000 10787479024 11171209216 1843381488 18.368 100 95 190 1 1884666448 14475648 26809312
14:07:18 2542 8192000000 10788921168 11175587840 1844527056 18.378 100 90 180 2 1883999520 13747888 25724576
14:07:28 2718 8192000000 10792886688 11178643456 1850201584 18.424 100 92 183 0 1889823712 13660336 25961792
14:07:38 1574 8192000000 10794593344 11181551616 1851717392 18.436 100 87 176 0 1891564880 15095920 24751568
14:07:46 1880 8192000000 10794285632 11184951296 1853185360 18.448 100 89 178 0 1893196256 15333440 24677456
14:07:54 1639 8192000000 10798463760 11189751808 1861752816 18.517 100 93 188 2 1902133648 14432288 25948544
14:08:02 1469 8192000000 10801882496 11188424704 1865928256 18.551 100 96 193 1 1904687920 11768384 26991280
14:08:10 1650 8192000000 10802515184 11189731328 1863021664 18.528 100 86 172 2 1899626720 12190448 24414608
14:08:18 1855 8192000000 10802888272 11193024512 1866135824 18.553 100 93 185 0 1905486320 12198928 27151568
14:08:26 1878 8192000000 10818866832 11208679424 1869209664 18.578 100 85 170 0 1904967616 10920432 24837520
14:08:34 21548 8192000000 10809584256 11206840320 1871031696 18.593 100 76 154 2 1904106816 11265808 21809312
14:09:02 902 8192000000 10810938944 11208179712 1876128416 18.634 100 76 153 1 1909904496 12155632 21620448
14:09:09 37065 8192000000 10785086672 11210555392 1874168320 18.618 100 53 106 1 1897381872 7736192 15477360
14:09:55 10351 8192000000 10792619824 11210612736 1879114032 18.658 100 41 82 0 1897190864 6831072 11245760
14:10:11 8066 8192000000 10779876224 11211165696 1875082544 18.625 100 22 44 1 1887987392 6901696 6003152
14:10:25 3540 8192000000 10792978128 11217731584 1883184800 18.691 100 35 70 0 1900707904 7594848 9928256
14:10:36 5221 8192000000 10798349792 11218804736 1879480368 18.661 100 30 60 2 1894963344 7054384 8428592
14:10:50 8789 8192000000 10789160176 11220856832 1881565424 18.678 100 26 52 1 1899362384 10740192 7056768
14:11:07 8275 8192000000 10805374672 11228479488 1884285968 18.700 100 20 40 1 1896249472 6514432 5449072
14:11:21 6070 8192000000 10804147840 11229147136 1889288480 18.740 100 38 76 0 1908542064 8817008 10436576
14:11:34 13277 8192000000 10801517328 11228098560 1888920688 18.737 100 22 43 1 1900837632 5808624 6108320
14:11:56 17225 8192000000 10804446464 11233570816 1892572304 18.767 100 25 50 0 1905893296 6194176 7126816
14:12:26 5627 8192000000 10794243952 11231772672 1893836944 18.777 100 18 36 0 1905160624 6195632 5128048
14:12:40 6463 8192000000 10805147632 11234361344 1891788944 18.760 100 17 34 0 1902793472 5786064 5218464
14:12:56 6786 8192000000 10804012752 11235815424 1895094944 18.787 100 18 36 1 1906264320 6079488 5089888
14:13:11 8421 8192000000 10802853504 11238158336 1895397152 18.789 100 20 39 2 1907870912 6531408 5942352
14:13:28 10663 8192000000 10807481520 11243216896 1903543536 18.855 100 31 62 0 1917733456 5393728 8796192
14:13:45 56266 8192000000 10848500560 11254751232 1903068688 18.851 100 48 95 0 1922897392 5072464 14756240
14:14:47 7717 8192000000 10817617824 11252977664 1902159312 18.844 100 40 80 2 1922313056 9211456 10942288
14:15:01 6771 8192000000 10818137840 11249688576 1901376992 18.837 100 38 74 2 1918650128 7113152 10159984
14:15:16 5613 8192000000 10813550144 11247013888 1897462288 18.806 100 39 78 1 1916629488 7979168 11188032
14:15:30 4837 8192000000 10809925200 11235606528 1889338288 18.740 100 32 65 2 1904718928 6454608 8926032
14:15:41 8704 8192000000 10801472320 11232743424 1876468432 18.637 99 27 55 2 1890051920 6080512 7502976
14:15:56 4829 8192000000 10817025616 11242598400 1892313856 18.764 100 25 50 1 1905806320 6237632 7254832
14:16:10 12161 8192000000 10806297840 11241574400 1895444480 18.790 100 25 49 1 1907970928 5698064 6828384
14:16:29 8281 8192000000 10808562368 11245391872 1896360096 18.797 100 20 40 1 1908198800 5864752 5973952
14:16:44 8270 8192000000 10809283008 11247374336 1899435744 18.822 100 20 38 3 1910984800 5361904 6187152
14:17:00 7261 8192000000 10792014848 11217207296 1833809456 18.290 97 27 54 3 1847018064 5684704 7523904
14:17:15 15422 8192000000 10789782352 11208437760 1840959968 18.349 98 18 35 1 1851052032 5197920 4894144
14:17:38 51485 8192000000 10737160432 11169202176 1733521824 17.465 93 25 50 2 1749467232 9541824 6403584
14:18:36 13684 8192000000 10727754816 11137515520 1772558608 17.788 96 21 41 3 1783232240 5561712 5111920
14:18:57 6337 8192000000 10728489280 11142553600 1729266720 17.429 94 31 62 2 1743575200 5907856 8400624
14:19:12 4570 8192000000 10745285952 11157704704 1800246576 18.016 99 27 52 2 1814363952 6727808 7389568
14:19:25 9956 8192000000 10730619632 11156398080 1777744800 17.831 97 33 66 0 1796948528 10021584 9182144
14:19:42 7743 8192000000 10712875904 11132760064 1763987552 17.717 97 25 50 3 1777864560 6488576 7388432
14:20:03 5390 8192000000 10712514496 11133136896 1787834384 17.914 99 26 52 0 1801964736 5834768 8295584
14:20:15 6153 8192000000 10724430240 11148603392 1798375792 18.001 99 28 55 3 1812111248 6004352 7731104
14:20:28 6890 8192000000 10693740224 11110445056 1701308992 17.196 94 33 66 0 1716349472 5178688 9861792
14:20:42 9923 8192000000 10691017984 11105501184 1714328080 17.305 95 23 45 3 1726963184 6118704 6516400
14:20:58 9586 8192000000 10661443664 11079483392 1641918288 16.696 92 16 32 1 1652170656 5355552 4896816
14:21:14 8171 8192000000 10699528672 11117379584 1783559984 17.879 100 15 30 1 1793864320 5378016 4926320
14:21:31 8309 8192000000 10723608768 11143086080 1798679040 18.003 100 14 28 0 1807957040 5224560 4053440
14:21:46 12911 8192000000 10722681088 11148001280 1797837824 17.996 99 22 45 2 1809405616 5158736 6409056
14:22:06 67812 8192000000 10744941568 11169595392 1831858512 18.274 100 25 48 2 1845127488 5698240 7570736
14:23:24 10366 8192000000 10764162640 11183239168 1824336880 18.213 99 26 51 2 1837338032 5565520 7435632
14:23:42 8344 8192000000 10757544032 11182473216 1839481056 18.337 100 20 40 3 1850917792 5599008 5837728
14:23:57 7977 8192000000 10775775792 11193987072 1850362896 18.425 100 29 58 0 1865933328 7750816 7819616
14:24:13 7487 8192000000 10775944816 11200454656 1857519696 18.483 100 27 54 0 1871591456 5230336 8841424
14:24:27 6752 8192000000 10772714096 11204153344 1858998320 18.495 100 24 48 2 1871926512 5804048 7124144
14:24:40 11300 8192000000 10767226320 11202883584 1860570288 18.508 100 20 40 3 1872142304 6192352 5379664
14:24:58 9453 8192000000 10781939712 11209646080 1865031312 18.544 100 25 48 0 1877574512 5229888 7313312
14:25:16 9169 8192000000 10781581520 11212632064 1863639920 18.533 100 15 30 0 1873737840 6062512 4035408
14:25:35 6574 8192000000 10787944400 11217870848 1872626064 18.606 100 27 54 1 1885320800 5354240 7340496
14:25:48 10767 8192000000 10783529840 11218333696 1872827376 18.607 100 12 24 3 1881686128 5490656 3368096
14:26:05 12667 8192000000 10787911008 11222601728 1877758192 18.647 100 17 34 1 1888241520 5860128 4623200
14:26:25 12974 8192000000 10783596032 11224039424 1878077728 18.650 100 20 40 2 1888806304 4989312 5739264
14:26:46 11791 8192000000 10799847328 11230097408 1881572128 18.678 100 14 28 0 1892336256 5506432 5257696
14:27:07 64981 8192000000 10851467664 11267248128 1910716608 18.912 100 55 108 1 1932291808 5578944 15996256
14:28:20 2831 8192000000 10857068656 11273187328 1918429840 18.974 100 68 133 1 1947004176 9675936 18898400
14:28:30 19370 8192000000 10847674000 11272753152 1919395008 18.982 100 39 78 1 1937479888 7540384 10544496
14:29:07 22700 8192000000 10856276608 11284512768 1928048352 19.051 100 38 75 1 1949067936 10159824 10859760
14:29:43 14027 8192000000 10869140336 11290644480 1934309264 19.101 100 39 78 2 1954932256 8949840 11673152
14:30:05 5670 8192000000 10886665104 11307601920 1947731952 19.208 100 62 121 1 1976137360 11125824 17279584
14:30:27 9009 8192000000 10892585344 11316047872 1947970160 19.210 100 53 104 1 1976958800 13375216 15613424
14:30:44 30656 8192000000 10885746512 11321860096 1956234384 19.276 100 53 105 3 1984885568 13616208 15034976
14:31:33 18177 8192000000 10899253904 11333554176 1964404608 19.341 100 40 80 1 1990433104 14249728 11778768
14:32:01 25438 8192000000 10902225680 11345797120 1968789136 19.376 100 37 74 2 1995738592 16482400 10467056
14:32:40 23150 8192000000 10901345440 11343650816 1972367392 19.404 100 32 64 0 1997401088 15825504 9208192
14:33:10 20415 8192000000 10901785088 11341037568 1958152256 19.291 99 40 80 0 1985589184 15458640 11978288
14:33:41 20536 8192000000 10912936368 11347398656 1959404000 19.301 99 47 94 1 1990083200 16850016 13829184
14:34:14 9274 8192000000 10913866992 11358314496 1975206688 19.427 100 35 70 0 2005514832 19680656 10627488
14:34:37 14653 8192000000 10930060128 11363364864 1986300000 19.515 100 51 100 2 2018034864 16804272 14930592
14:34:58 6607 8192000000 10924399968 11358318592 1982463440 19.484 100 56 111 0 2017301472 18467120 16370912
14:35:13 5129 8192000000 10932327264 11366854656 1986091600 19.513 100 51 99 3 2018916064 18476736 14347728
14:35:25 4802 8192000000 10948594048 11373604864 1994711680 19.581 100 71 139 1 2035704240 20337232 20655328
14:35:38 5032 8192000000 10937505360 11364896768 1985376272 19.507 100 60 120 1 2024025104 20731488 17917344
14:35:50 2137 8192000000 10955740976 11382652928 2000210624 19.624 100 74 147 0 2040332560 19755920 20366016
14:36:04 4182 8192000000 10955464336 11377958912 1998831376 19.614 100 83 165 5 2043502576 20576064 24095136
14:36:17 1923 8192000000 10962695328 11382472704 1999090176 19.616 100 75 151 1 2043529984 22697232 21742576
14:36:27 7092 8192000000 10955650608 11385602048 2000267296 19.625 100 65 131 1 2043324448 23315280 19741872
14:36:42 5659 8192000000 10950079856 11379404800 1994762112 19.581 100 63 126 0 2036233984 22901680 18570192
14:36:54 7868 8192000000 10940434448 11374493696 1976357024 19.436 99 58 116 2 2017311280 23023120 17931136
14:37:12 5713 8192000000 10932155824 11365969920 1970873904 19.392 99 54 108 1 2011767712 23816352 17077456
14:37:25 10689 8192000000 10928093936 11359432704 1962260032 19.324 99 64 126 0 2006605088 25216480 19128576
14:37:44 7291 8192000000 10934699344 11370741760 1985259600 19.506 100 60 119 2 2031103296 27179536 18664160
14:38:00 9527 8192000000 10938850784 11365453824 1950835552 19.233 98 69 136 3 1994164416 23264816 20064048
14:38:22 7898 8192000000 10923835072 11351601152 1961096432 19.315 99 59 118 0 2008164800 29135680 17932688
14:38:38 7156 8192000000 10932625296 11368349696 1978361728 19.452 100 57 113 1 2020600768 25117040 17122000
14:39:00 3848 8192000000 10948748528 11377987584 1991397904 19.555 100 58 115 0 2030285872 22042304 16845664
14:39:11 7899 8192000000 10953994144 11378151424 1987532416 19.524 100 72 144 1 2036558720 27053296 21973008
14:39:29 9100 8192000000 10949616144 11384078336 1992443200 19.563 100 54 108 1 2035866448 26951264 16471984
14:39:45 7334 8192000000 10949536128 11381563392 1990665904 19.549 100 60 120 2 2036532576 27890704 17975968
14:40:11 3785 8192000000 10958287824 11384438784 1991418576 19.555 100 75 147 3 2040426960 26459504 22548880
14:40:22 8092 8192000000 10964043760 11391729664 1999795360 19.621 100 68 132 0 2046372624 26788560 19788704
14:40:42 7885 8192000000 10965950976 11398111232 2004068224 19.655 100 58 114 1 2050386928 29263680 17055024
14:40:59 3232 8192000000 10963602000 11396399104 2000805984 19.629 100 61 122 0 2050053184 29939888 19307312
14:41:16 5852 8192000000 10956770224 11392524288 1986221280 19.514 99 55 111 0 2030059360 26550832 17287248
14:41:40 2972 8192000000 10952238320 11372814336 1969902464 19.385 99 57 114 3 2014190864 26919296 17369104
14:41:50 5756 8192000000 10949392912 11376353280 1987328320 19.523 100 77 153 3 2038401664 28224448 22848896
14:42:04 9194 8192000000 10952429392 11380744192 1973602624 19.414 99 58 114 0 2022126672 31125952 17398096
14:42:21 4217 8192000000 10967152080 11389083648 1990546240 19.548 100 76 151 2 2046612240 33141136 22924864
14:42:34 3864 8192000000 10964653664 11378753536 1971271616 19.396 99 81 159 2 2030180832 34124656 24784560
14:42:45 1999 8192000000 10962890032 11380076544 1968600960 19.374 99 74 144 2 2028180768 37505344 22074464
14:42:54 2469 8192000000 10967723104 11383246848 1988114240 19.529 100 80 153 0 2054033120 42569872 23349008
14:43:04 2296 8192000000 10972379856 11389399040 1989887200 19.543 100 79 157 1 2054432448 39813824 24731424
14:43:16 6075 8192000000 10953372720 11374489600 1964213264 19.340 99 67 134 0 2025231104 40019072 20998768
14:43:33 4953 8192000000 10941220912 11363356672 1933654128 19.096 98 68 136 1 1998370128 43346736 21369264
14:43:49 3289 8192000000 10953760672 11373920256 1971771728 19.400 100 74 148 3 2038061216 43859168 22430320
14:43:58 4825 8192000000 10977129584 11389112320 1982581536 19.485 100 83 166 0 2057146864 48549072 26016256
14:44:12 2640 8192000000 10971279088 11377582080 1957677136 19.288 99 81 162 2 2031697360 48099920 25920304
14:44:22 2088 8192000000 10949687696 11362476032 1958190192 19.292 100 74 146 0 2030685792 49204432 23291168
14:44:31 3469 8192000000 10959235200 11375697920 1965240480 19.348 100 75 150 2 2039818256 50173536 24404240
14:44:44 1726 8192000000 10965425984 11377926144 1968388432 19.373 100 85 169 0 2048454128 52572640 27493056
14:44:54 2373 8192000000 10977922736 11387797504 1976353648 19.436 100 84 168 2 2057324256 53509904 27460704
14:45:04 3652 8192000000 10950036816 11356565504 1941102464 19.156 99 79 154 1 2016717008 51623552 23990992
14:45:19 2863 8192000000 10970024064 11382452224 1969854544 19.384 100 80 160 3 2048948848 53310112 25784192
14:45:30 1849 8192000000 10987840688 11395166208 1981688448 19.478 100 87 174 2 2065217504 55909904 27619152
14:45:44 3511 8192000000 10969410368 11383279616 1960256992 19.308 99 78 156 0 2042853024 57233760 25362272
14:45:55 1732 8192000000 10963268320 11367981056 1957156880 19.283 100 89 178 1 2039032544 53720480 28155184
14:46:05 2075 8192000000 10953091440 11364188160 1957344624 19.285 100 79 157 3 2034539008 52011232 25183152
14:46:15 1094 8192000000 10958150640 11362639872 1940743984 19.153 99 85 170 2 2020835536 52664752 27426800
14:46:25 1500 8192000000 10970022576 11378319360 1964273952 19.340 100 95 190 0 2048616592 54141824 30200816
14:46:33 3427 8192000000 10954038848 11371397120 1959866032 19.305 100 85 167 1 2041578432 55305312 26407088
14:46:46 3064 8192000000 10972888192 11378016256 1962845648 19.329 100 84 165 2 2045099216 54630160 27623408
14:46:57 3527 8192000000 10974844704 11383173120 1968838512 19.376 100 83 165 1 2049574416 54688944 26046960
14:47:07 2798 8192000000 10979419232 11391746048 1969107552 19.378 100 86 172 1 2053298720 55687600 28503568
14:47:21 3089 8192000000 10971365744 11392569344 1973700816 19.415 100 77 154 0 2056549664 57927936 24920912
14:47:36 4829 8192000000 10935074672 11338297344 1924995296 19.027 98 85 169 1 2009855184 57349856 27510032
14:47:47 4062 8192000000 10949638224 11374325760 1954026464 19.259 100 73 146 0 2034592784 56553232 24013088
14:48:02 6683 8192000000 10918673760 11339059200 1930692976 19.072 99 56 112 2 1999257280 49666000 18898304
14:48:21 6038 8192000000 10945725408 11365388288 1952945904 19.250 100 73 146 1 2025155376 47954352 24255120
14:48:35 20295 8192000000 10925548352 11363250176 1947811616 19.209 100 45 90 1 2012554800 49856560 14886624
14:49:08 3794 8192000000 10932315616 11364360192 1948386368 19.214 100 46 92 0 2015293472 51426736 15480368
14:49:28 7637 8192000000 10926988768 11359195136 1924598800 19.024 99 43 84 0 1991935056 52784448 14551808
14:49:42 10311 8192000000 10915054832 11356127232 1914891472 18.946 99 36 72 2 1983423728 55498816 13033440
14:50:03 22983 8192000000 10913890176 11357372416 1939718896 19.145 100 34 68 1 2002078752 50083840 12276016
14:50:39 16656 8192000000 10930022816 11368665088 1942902896 19.170 100 31 62 1 2009770736 56129232 10738608
14:51:02 896 8192000000 10939144704 11366928384 1944633792 19.184 100 56 112 1 2021109568 58001488 18474288
14:51:20 21010 8192000000 10883388800 11338022912 1900100800 18.827 99 33 65 2 1969332464 57524512 11707152
14:51:48 20912 8192000000 10880067264 11317297152 1863064912 18.528 97 31 62 1 1926832960 52636016 11132032
14:52:35 12415 8192000000 10872335136 11320934400 1903693392 18.856 100 21 42 1 1959907872 48105328 8109152
14:53:05 12380 8192000000 10875065904 11315896320 1866220368 18.554 98 29 58 1 1927016816 50516752 10279696
14:53:37 24369 8192000000 10841062288 11308204032 1874766736 18.623 99 14 28 2 1918057968 37969712 5321520
14:54:14 34397 8192000000 10853050752 11302957056 1850034032 18.422 98 20 40 3 1893274960 35935536 7305392
14:54:56 18139 8192000000 10840371472 11301806080 1900707600 18.832 100 13 26 0 1925782384 21259776 3815008
14:56:10 104337 8192000000 10856265232 11290132480 1873732160 18.614 98 28 57 2 1912020016 29784832 8503024
14:58:01 55416 8192000000 10827290544 11272126464 1852735072 18.444 97 32 62 1 1883389536 22180864 8473600
14:59:10 35502 8192000000 10833490240 11299270656 1901963776 18.842 100 14 28 0 1926510816 20294848 4252192
15:00:00 72781 8192000000 10845657088 11296219136 1885151552 18.707 98 15 30 0 1900549872 11319680 4078640
15:01:26 92320 8192000000 10863683984 11320381440 1891837120 18.761 98 15 30 1 1911923792 16454528 3632144
15:03:41 81236 8192000000 10865117600 11327524864 1908192064 18.892 98 12 24 0 1918637392 7275808 3169520
15:05:27 107665 8192000000 10870729840 11320492032 1893363552 18.773 97 28 56 0 1908341504 7431280 7546672
15:08:26 69848 8192000000 10890337216 11337400320 1952324080 19.245 100 25 50 1 1966780032 7387696 7068256
15:09:43 81996 8192000000 10878928032 11350188032 1945886240 19.194 99 21 42 0 1961451984 9650016 5915728
15:11:11 29473 8192000000 10875344848 11341897728 1949428336 19.222 99 16 32 0 1965035488 10974624 4632528
15:11:53 5612 8192000000 10887798064 11350499328 1965113120 19.347 100 25 49 0 1981422240 9002288 7306832
15:12:06 717 8192000000 10902024880 11355648000 1966514944 19.358 100 44 89 0 1994624944 15752912 12357088
15:12:14 10591 8192000000 10914641584 11361574912 1980072160 19.465 100 54 108 1 2007293584 12058336 15163088
15:12:46 41673 8192000000 10886924128 11351277568 1946606752 19.199 99 23 46 3 1965273808 11830480 6836576
15:13:43 25960 8192000000 10913687568 11364442112 1979501568 19.461 100 48 96 3 2006100976 11484400 15115008
15:14:17 59803 8192000000 10909318912 11378810880 1980384176 19.468 100 18 36 0 2003439584 16965504 6089904
15:15:38 56387 8192000000 10886626528 11371200512 1953994544 19.258 99 12 24 0 1971853872 14054944 3804384
15:16:47 69715 8192000000 10886904224 11359301632 1967804064 19.368 100 15 30 0 1980537088 8443264 4289760
15:18:11 75755 8192000000 10904824736 11359313920 1932343824 19.086 98 17 34 1 1948119072 10959104 4816144
15:19:35 53376 8192000000 10900376688 11374223360 1971059968 19.394 100 21 42 0 1989876368 12972912 5843488
15:20:41 78302 8192000000 10906214864 11376312320 1937559296 19.127 98 14 28 0 1956448784 15005728 3883760
15:22:09 93091 8192000000 10896031696 11379154944 1905132624 18.868 96 14 28 0 1923106304 14274864 3698816
15:24:21 27323 8192000000 10926200528 11382120448 1983923888 19.496 100 34 68 2 2009067296 15283664 9859744
15:24:55 69124 8192000000 10886096720 11367862272 1920223984 18.989 97 27 53 1 1943556912 15955728 7377200
15:26:11 94867 8192000000 10894018976 11350458368 1864072384 18.536 94 18 36 1 1879268656 9813184 5383088
15:27:52 60586 8192000000 10891960976 11357188096 1929602912 19.064 98 44 87 2 1953305472 11688304 12014256
15:28:58 59389 8192000000 10897803584 11366551552 1920804336 18.993 98 19 37 1 1939067472 13454848 4808288
15:30:04 92166 8192000000 10899677136 11373010944 1900248848 18.828 96 18 36 3 1916026512 10911088 4866576
15:31:43 130215 8192000000 10888952368 11348701184 1908414496 18.894 97 11 22 0 1929553840 17639072 3500272
15:34:11 43748 8192000000 10884272352 11337674752 1924509248 19.023 98 38 76 0 1950290160 15452640 10328272
15:35:04 41621 8192000000 10886308048 11346116608 1944075168 19.179 99 43 86 3 1973971408 18094496 11801744
15:35:52 20827 8192000000 10889636352 11353468928 1942983664 19.171 99 33 66 1 1971133744 18584448 9565632
15:36:27 64255 8192000000 10898741232 11368636416 1964163536 19.339 100 16 30 3 1984690160 15814944 4711680
15:37:38 56833 8192000000 10889732480 11357102080 1930448112 19.070 98 21 43 1 1955356800 18686800 6221888
15:38:58 69856 8192000000 10883078640 11360239616 1935076336 19.107 99 17 34 1 1964686160 24559664 5050160
15:41:40 64912 8192000000 10861148016 11324104704 1888526096 18.734 97 20 40 0 1903334864 9197168 5611600
15:42:53 20478 8192000000 10850377488 11313737728 1895325984 18.789 98 17 34 2 1906893568 6621264 4946320
15:43:21 42937 8192000000 10863634912 11326746624 1897278384 18.804 98 19 38 0 1912442032 9496544 5667104
15:44:13 98046 8192000000 10856254032 11312275456 1833533008 18.288 95 19 39 0 1860621664 21681072 5407584
15:46:01 33429 8192000000 10858241760 11319812096 1905012992 18.867 99 33 65 0 1924136048 9604080 9518976
15:46:47 33311 8192000000 10864668064 11318476800 1921252112 18.997 100 36 72 0 1945326640 14214384 9860144
15:47:34 54743 8192000000 10859778944 11330740224 1895523184 18.790 98 30 60 4 1920984896 16864928 8596784
15:48:44 133198 8192000000 10851336624 11333447680 1832483776 18.280 95 11 22 1 1853586048 18217088 2885184
15:51:04 60629 8192000000 10882184416 11329720320 1863136272 18.529 96 32 64 0 1881953280 10622608 8194400
15:52:11 45555 8192000000 10864176144 11328679936 1891082576 18.755 98 36 72 0 1915908448 14665856 10160016
15:53:11 74060 8192000000 10856978800 11335639040 1899008208 18.818 98 23 46 1 1918540080 13520608 6011264
15:54:32 108744 8192000000 10850494688 11319025664 1881619968 18.678 97 23 46 2 1895534400 7989504 5924928
15:56:27 53787 8192000000 10895543456 11334139904 1929521360 19.063 99 44 87 4 1948660096 7776048 11362688
15:57:28 61569 8192000000 10867926000 11337580544 1925111872 19.028 98 29 58 0 1940895872 8166400 7617600
15:58:50 61636 8192000000 10867125968 11348455424 1937134688 19.124 99 15 29 1 1951606752 9742480 4729584
15:59:58 64750 8192000000 10881729296 11356098560 1959631200 19.303 100 9 18 0 1973746720 11684528 2430992
16:01:09 33785 8192000000 10860035008 11332030464 1932279424 19.085 99 10 20 0 1946942176 11912768 2749984
16:01:49 59327 8192000000 10869103376 11358793728 1950934528 19.234 100 12 24 0 1965546976 11611216 3001232
16:02:55 47668 8192000000 10893921136 11362676736 1949640272 19.224 99 11 21 0 1961675184 9401280 2633632
16:03:51 17964 8192000000 10916892544 11381317632 1970915728 19.393 99 33 66 1 1990831472 10547248 9368496
16:04:22 88833 8192000000 10927424624 11396386816 1968616528 19.374 99 24 48 0 1991913712 16672704 6624480
16:06:01 64075 8192000000 10926332704 11381538816 1962663408 19.327 99 11 23 0 1973784912 8134320 2987184
16:07:11 51522 8192000000 10904266016 11382833152 1950112944 19.227 98 28 57 2 1966800016 9256048 7431024
16:08:09 58755 8192000000 10904071552 11382116352 1960854624 19.313 99 11 22 0 1973750880 9910288 2985968
16:09:15 35790 8192000000 10895940080 11363209216 1904191232 18.860 96 19 38 1 1917895216 8316112 5387872
16:09:57 66220 8192000000 10923951968 11366592512 1917638896 18.968 97 40 80 2 1939349424 10307248 11403280
16:11:10 31854 8192000000 10927625344 11381518336 1972777392 19.407 100 42 84 1 1995564896 11260816 11526688
16:11:48 25845 8192000000 10922680112 11383590912 1966238288 19.356 99 41 82 1 1990974512 13073920 11662304
16:12:22 66452 8192000000 10903574096 11390324736 1959055312 19.299 99 27 54 0 1979518768 13546352 6917104
16:13:34 15182 8192000000 10905921472 11358380032 1912031280 18.923 96 56 112 0 1935159664 6924944 16203440
16:13:58 40535 8192000000 10899189104 11368611840 1961833392 19.321 100 25 50 1 1978978176 10450064 6694720
16:14:51 84280 8192000000 10921350192 11389542400 1954501280 19.262 99 13 26 1 1969331328 11449152 3380896
16:16:26 92220 8192000000 10875028272 11339907072 1901136928 18.835 96 44 88 0 1926171760 12422944 12611888
16:18:17 55217 8192000000 10842460032 11311628288 1896647152 18.799 97 10 19 1 1909838736 10579312 2612272
16:19:19 31654 8192000000 10833130832 11307896832 1881045232 18.674 97 22 42 0 1896078704 9083648 5949824
16:19:58 65118 8192000000 10847423936 11325476864 1915432272 18.950 99 7 14 1 1926623344 9488544 1702528
16:21:10 81701 8192000000 10866565744 11343499264 1947153216 19.204 100 17 34 0 1962816448 10726208 4937024
16:23:08 43078 8192000000 10847021040 11328016384 1891518304 18.758 97 12 24 1 1907027872 11830896 3678672
16:24:15 71325 8192000000 10872355456 11353550848 1901020624 18.835 98 14 28 1 1919876176 14624256 4231296
16:25:50 32052 8192000000 10872379056 11348254720 1930990672 19.075 99 18 36 0 1945546208 9790624 4764912
16:26:34 49154 8192000000 9758603600 10105077760 888026304 9.779 45 10 20 0 895822288 4927136 2868848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 13-02-2021 16:28:54 to 13-02-2021 16:29:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-02-2021 16:29:26 to 13-02-2021 16:29:28.

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          239168
MON$OLDEST_ACTIVE               241426
MON$OLDEST_SNAPSHOT             241426
MON$NEXT_TRANSACTION            241426
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                       2014464
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:318: 
:319: mscs-test-161.budzdorov.ru    Sat Feb 13 16:27:24 2021
:320:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:321: 
:322: 
:323: mscs-test-161.budzdorov.ru    Sat Feb 13 16:27:24 2021
:324:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:325: 
--- end of diff output ---

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

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