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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-13 16:31:53
DTS_END                         2021-03-13 16:31:53.2990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58112
TRN_ID                          230095
ATT_ID                          629
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: 8966.15 20299 1075938
customer order: creation 170.93 351 20512
customer order: refuse 13.98 394 1677
order to supplier: creation 46.03 1434 5524
order to supplier: removal 3.33 120890 400
invoice (draft): creation 44.85 3636 5382
invoice (draft): removal 49.58 1091 5949
invoice accept: apply 41.39 21329 4967
invoice accept: cancel 44.43 1028 5331
customer reserve: creation 3868.30 208 464196
customer reserve: removal 4394.63 70 527356
realization accept: apply 81.20 184 9744
realization accept: cancel 80.46 119 9655
payment from customer: creation 58.73 118 7048
payment from customer: removal 5.43 99 651
payment to supplier: creation 46.88 135 5626
payment to supplier: removal 3.41 83 409
service: total inventory turnovers 5.08 1129 609
service: total monetary turnovers 6.68 33 802
service: aggregate perf. data 0.80 24986 96
service: refresh index statistics 0.03 228657 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-03-2021 16:32:56 to 13-03-2021 16:32:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6357
TEST_TIME 2 4650
TEST_TIME 3 4807
TEST_TIME 4 5057
TEST_TIME 5 5830
TEST_TIME 6 5748
TEST_TIME 7 5685
TEST_TIME 8 5530
TEST_TIME 9 5423
TEST_TIME 10 5602
TEST_TIME 11 5834
TEST_TIME 12 5801
TEST_TIME 13 5855
TEST_TIME 14 6064
TEST_TIME 15 6263
TEST_TIME 16 6400
TEST_TIME 17 6816
TEST_TIME 18 7239
TEST_TIME 19 7261
TEST_TIME 20 7358
TEST_TIME 21 7357
TEST_TIME 22 7561
TEST_TIME 23 7902
TEST_TIME 24 7811
TEST_TIME 25 7671
TEST_TIME 26 7816
TEST_TIME 27 8240
TEST_TIME 28 8203
TEST_TIME 29 8190
TEST_TIME 30 8413
TEST_TIME 31 8563
TEST_TIME 32 9037
TEST_TIME 33 9161
TEST_TIME 34 10279
TEST_TIME 35 10845
TEST_TIME 36 10608
TEST_TIME 37 10354
TEST_TIME 38 10222
TEST_TIME 39 10085
TEST_TIME 40 9985
TEST_TIME 41 9818
TEST_TIME 42 9725
TEST_TIME 43 9705
TEST_TIME 44 9625
TEST_TIME 45 9580
TEST_TIME 46 9594
TEST_TIME 47 9572
TEST_TIME 48 9494
TEST_TIME 49 9394
TEST_TIME 50 9240
TEST_TIME 51 9335
TEST_TIME 52 9238
TEST_TIME 53 9130
TEST_TIME 54 9065
TEST_TIME 55 9054
TEST_TIME 56 9098
TEST_TIME 57 9055
TEST_TIME 58 9008
TEST_TIME 59 8934
TEST_TIME 60 8927
TEST_TIME 61 8868
TEST_TIME 62 8855
TEST_TIME 63 8848
TEST_TIME 64 8871
TEST_TIME 65 8837
TEST_TIME 66 8907
TEST_TIME 67 9007
TEST_TIME 68 8933
TEST_TIME 69 8936
TEST_TIME 70 9109
TEST_TIME 71 9035
TEST_TIME 72 9127
TEST_TIME 73 9120
TEST_TIME 74 9131
TEST_TIME 75 9079
TEST_TIME 76 9209
TEST_TIME 77 9231
TEST_TIME 78 9134
TEST_TIME 79 9077
TEST_TIME 80 9012
TEST_TIME 81 9019
TEST_TIME 82 9020
TEST_TIME 83 8973
TEST_TIME 84 8926
TEST_TIME 85 8862
TEST_TIME 86 8911
TEST_TIME 87 8897
TEST_TIME 88 8874
TEST_TIME 89 8859
TEST_TIME 90 8932
TEST_TIME 91 8918
TEST_TIME 92 8961
TEST_TIME 93 8978
TEST_TIME 94 9019
TEST_TIME 95 9037
TEST_TIME 96 8998
TEST_TIME 97 9058
TEST_TIME 98 9051
TEST_TIME 99 9024
TEST_TIME 100 9078
TEST_TIME 101 9156
TEST_TIME 102 9157
TEST_TIME 103 9158
TEST_TIME 104 9074
TEST_TIME 105 9060
TEST_TIME 106 9015
TEST_TIME 107 9005
TEST_TIME 108 9018
TEST_TIME 109 8985
TEST_TIME 110 8968
TEST_TIME 111 8921
TEST_TIME 112 8928
TEST_TIME 113 8890
TEST_TIME 114 8935
TEST_TIME 115 8998
TEST_TIME 116 8990
TEST_TIME 117 9012
TEST_TIME 118 9022
TEST_TIME 119 8988
TEST_TIME 120 8973

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-03-2021 16:33:00 to 13-03-2021 16:33:03.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1503984 1503984 0 0.00 0 17637 7 0 0
doc_list_biud 1503982 1503982 0 0.00 0 36141 32 0 0
sp_add_invoice_to_stock 5045 4967 78 1.54 39 250063 21330 0 78
sp_cancel_adding_invoice 5331 5331 0 0.00 5 62182 1028 0 0
sp_cancel_client_order 1677 1677 0 0.00 4 12743 395 0 0
sp_cancel_customer_reserve 527356 527356 0 0.00 1 23463 71 0 0
sp_cancel_pay_from_customer 651 651 0 0.00 3 3435 99 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 5017 83 0 0
sp_cancel_supplier_invoice 5961 5949 12 0.20 2 20015 1092 0 12
sp_cancel_supplier_order 400 400 0 0.00 6 1147058 120890 0 0
sp_cancel_write_off 9655 9655 0 0.00 1 8147 120 0 0
sp_client_order 20512 20512 0 0.00 3 24989 351 0 0
sp_customer_reserve 464196 464196 0 0.00 0 104824 208 0 0
sp_fill_shopping_cart 31408 31408 0 0.00 1 17383 42 0 0
sp_fill_shopping_cart_clo_res 464181 464181 0 0.00 0 19495 14 0 0
sp_get_clo_for_invoice 4952 4952 0 0.00 0 32798 299 0 0
sp_kill_cost_storno 16046 16046 0 0.00 0 8753 69 0 0
sp_kill_qstorno_ret_qs2qd 1070716 1070716 0 0.00 0 23459 39 0 0
sp_kill_qty_storno 565064 565064 0 0.00 0 36138 84 0 0
sp_lock_selected_doc 20327 20327 0 0.00 0 7755 4 0 0
sp_make_cost_storno 27370 27370 0 0.00 0 12227 54 0 0
sp_multiply_rows_for_pdistr 27370 27370 0 0.00 0 9549 30 0 0
sp_multiply_rows_for_qdistr 20512 20512 0 0.00 0 13897 143 0 0
sp_pay_from_customer 7048 7048 0 0.00 4 17464 118 0 0
sp_pay_to_supplier 5626 5626 0 0.00 5 13393 135 0 0
sp_payment_common 12674 12674 0 0.00 1 16739 30 0 0
sp_qd_handle_on_cancel_clo 1677 1677 0 0.00 0 12737 362 0 0
sp_qd_handle_on_invoice_upd_sts 10283 10283 0 0.00 0 36137 391 0 0
sp_qd_handle_on_reserve_upd_sts 9744 9744 0 0.00 0 12901 65 0 0
sp_reserve_write_off 9744 9744 0 0.00 6 13155 185 0 0
sp_supplier_invoice 5382 5382 0 0.00 6 115675 3637 0 0
sp_supplier_order 5524 5524 0 0.00 6 45309 1435 0 0
srv_aggregate_perf_data 96 96 0 0.00 2892 188728 24987 0 0
srv_fill_mon_cache_memory 184 184 0 0.00 845 144245 28032 0 0
srv_find_qd_qs_mism 1027663 1027663 0 0.00 0 17636 6 0 0
srv_make_invnt_saldo 609 609 0 0.00 44 49070 1130 0 0
srv_make_money_saldo 802 802 0 0.00 0 2512 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 118127 300544 228658 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4967 4967 0 0.00 0 12823 213 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 1 3438 106 0 0
t$perf-norm:sp_cancel_client_order 1677 1677 0 0.00 0 2495 18 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 3891 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 651 651 0 0.00 0 4858 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 1211 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1798 34 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 31502 2131 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 2099 13 0 0
t$perf-norm:sp_client_order 20512 20512 0 0.00 0 19581 24 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 616 4 0 0
t$perf-norm:sp_pay_from_customer 7048 7048 0 0.00 0 5756 11 0 0
t$perf-norm:sp_pay_to_supplier 5626 5626 0 0.00 0 4792 12 0 0
t$perf-norm:sp_reserve_write_off 9744 9744 0 0.00 0 6718 13 0 0
t$perf-norm:sp_supplier_invoice 5382 5382 0 0.00 0 12650 23 0 0
t$perf-norm:sp_supplier_order 5524 5524 0 0.00 0 7441 20 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 191 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 184 184 0 0.00 0 266 5 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 5148 38 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 783 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10060 9904 156 1.55 0 3524 18 0 156
v_all_customers 37358 37358 0 0.00 0 21 1 0 0
v_all_suppliers 29892 29892 0 0.00 0 27 1 0 0
v_all_wares 41024 41024 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 791 7 0 0
v_cancel_client_order 3354 3354 0 0.00 0 4697 10 0 0
v_cancel_customer_prepayment 1302 1302 0 0.00 0 3409 15 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 1942 8 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 549 3 0 0
v_cancel_supplier_invoice 806 782 24 2.97 0 5639 36 0 24
v_cancel_supplier_order 800 800 0 0.00 0 3125 11 0 0
v_cancel_write_off 1938 1938 0 0.00 0 2171 15 0 0
v_max_id_clo_ord 5522 5522 0 0.00 0 739 1 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 1748 11 0 0
v_max_id_ord_sup 5374 5374 0 0.00 0 4773 4 0 0
v_max_non_paid_invoice 1576 1576 0 0.00 0 4796 7 0 0
v_max_non_paid_realizn 3736 3736 0 0.00 0 11132 7 0 0
v_min_id_clo_ord 5522 5522 0 0.00 0 1937 5 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 2431 5 0 0
v_min_id_ord_sup 5374 5374 0 0.00 0 8544 6 0 0
v_min_non_paid_invoice 5626 5626 0 0.00 0 5930 19 0 0
v_min_non_paid_realizn 7048 7048 0 0.00 0 11369 15 0 0
v_our_firm 10290 10290 0 0.00 0 19 1 0 0
v_reserve_write_off 19488 19488 0 0.00 0 3287 6 0 0
x_lock_depdocs_on_canc_invoice 10889 10889 0 0.00 0 28118 154 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 12262 444 0 0
x_make_qstorno_1000_1200 5524 5524 0 0.00 2 45280 1341 0 0
x_make_qstorno_1200_2000 5382 5382 0 0.00 3 115660 3485 0 0
x_make_qstorno_2100_3300 464196 464196 0 0.00 0 104770 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2021 16:33:04 to 13-03-2021 16:33:08.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:57 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:03 11466 8192000000 10216506656 10520104960 958033472 10.470 77 54 108 0 979612544 2400080 19178992
14:02:24 40235 8192000000 10340301744 10654949376 1385592608 14.467 100 85 170 0 1417953856 4623472 27737776
14:03:15 20191 8192000000 10375619440 10695397376 1427864704 14.842 100 89 178 0 1463469728 6513808 29091216
14:03:49 16329 8192000000 10387892464 10711339008 1444726800 14.991 100 87 174 0 1480752176 7440032 28585344
14:04:15 29708 8192000000 10416980768 10743484416 1462194240 15.145 100 85 170 1 1497773008 7879664 27699104
14:04:53 25423 8192000000 10426790256 10757988352 1484565136 15.341 100 89 178 0 1521905808 8948080 28392592
14:05:29 29774 8192000000 10445263744 10779115520 1500224368 15.478 100 92 184 0 1539410448 9531088 29654992
14:06:21 18509 8192000000 10472765664 10812657664 1522756320 15.674 100 82 165 1 1558423280 9719792 25947168
14:06:49 20605 8192000000 10492212592 10841882624 1556593104 15.967 100 75 151 0 1589332800 9737360 23002336
14:07:17 8550 8192000000 10523225888 10875080704 1584977664 16.211 100 80 161 0 1618536944 9340656 24218624
14:07:34 12023 8192000000 10548059216 10900832256 1593584320 16.285 100 78 156 1 1628311616 10414112 24313184
14:07:56 14630 8192000000 10569054240 10926653440 1624884544 16.551 100 80 159 0 1659286880 11285248 23117088
14:08:19 7849 8192000000 10577282032 10942332928 1641818352 16.695 100 80 159 1 1676577840 11331040 23428448
14:08:36 7777 8192000000 10604424368 10972200960 1674350224 16.970 100 79 158 0 1709353328 11909936 23093168
14:08:51 9752 8192000000 10629339728 10996944896 1690356384 17.104 100 81 163 1 1725484064 12360736 22766944
14:09:08 9280 8192000000 10651449104 11019071488 1706545264 17.240 100 83 166 1 1743204368 13401088 23258016
14:09:26 6837 8192000000 10661208144 11031711744 1720743536 17.358 100 82 163 1 1757953072 13957392 23252144
14:09:40 6214 8192000000 10672141200 11043106816 1728199952 17.421 100 75 150 0 1763261184 13918368 21142864
14:09:54 7165 8192000000 10683767808 11056422912 1741290864 17.529 100 86 172 0 1779207472 13713792 24202816
14:10:09 5277 8192000000 10697136336 11069988864 1753079696 17.627 100 84 168 1 1790685456 13740336 23865424
14:10:22 4438 8192000000 10700362208 11075383296 1759823024 17.683 100 86 170 3 1798217328 14190160 24204144
14:10:33 3692 8192000000 10714084432 11088384000 1771218560 17.777 100 81 161 1 1806943136 13247408 22477168
14:10:44 4853 8192000000 10720527360 11098763264 1779103552 17.842 100 87 172 2 1817414080 13580592 24729936
14:10:56 3927 8192000000 10725642768 11103338496 1787401504 17.910 100 82 164 0 1823546144 13636976 22507664
14:11:07 2662 8192000000 10737154688 11117330432 1793399392 17.960 100 92 179 2 1832758784 14425984 24933408
14:11:17 4717 8192000000 10748695312 11128889344 1803927888 18.046 100 82 161 1 1839060480 12205936 22926656
14:11:28 3933 8192000000 10746095232 11129507840 1809913840 18.095 100 87 173 1 1847553856 12831184 24808832
14:11:39 10347 8192000000 10740364976 11133992960 1811343264 18.107 100 70 138 1 1843737440 12877584 19516592
14:11:57 4698 8192000000 10762548128 11151474688 1819558960 18.174 100 78 156 0 1853538512 11615088 22364464
14:12:08 3110 8192000000 10771033968 11159437312 1834549904 18.296 100 83 166 0 1869733888 11257760 23926224
14:12:18 3602 8192000000 10778395856 11166789632 1842101648 18.358 100 83 167 0 1877622752 11704032 23817072
14:12:28 2761 8192000000 10792476496 11177181184 1850231408 18.424 100 90 181 2 1888560880 12925472 25404000
14:12:38 2533 8192000000 10801012864 11187666944 1856624368 18.476 100 94 188 2 1897754048 15098848 26030832
14:12:47 3203 8192000000 10802950880 11190661120 1862684224 18.525 100 91 182 2 1903358992 15256752 25418016
14:12:57 2343 8192000000 10809055360 11197177856 1864402688 18.539 100 90 180 1 1904262544 15134416 24725440
14:13:05 2160 8192000000 10804240592 11197091840 1865768336 18.550 100 89 179 1 1905275088 14428400 25078352
14:13:14 1876 8192000000 10811567488 11203829760 1870301120 18.587 100 93 185 0 1909389088 12492160 26595808
14:13:22 3380 8192000000 10817035344 11205677056 1873757072 18.615 100 92 183 1 1912005968 12527264 25721632
14:13:32 2607 8192000000 10818034480 11209785344 1874125584 18.618 100 90 176 0 1912034560 13033040 24875936
14:13:41 2536 8192000000 10823597408 11212746752 1880830576 18.672 100 93 187 2 1918949328 11345280 26773472
14:13:50 1522 8192000000 10818907392 11209953280 1880695952 18.671 100 89 178 3 1917541360 11629744 25215664
14:13:58 1606 8192000000 10812968160 11214299136 1875412464 18.628 100 80 161 1 1911514736 12967280 23134992
14:14:06 20885 8192000000 10820307344 11214991360 1875846768 18.632 100 80 161 1 1909289408 11590512 21852128
14:14:33 1497 8192000000 10828763152 11218612224 1881508544 18.677 100 90 180 0 1919968880 12752464 25707872
14:14:41 2271 8192000000 10809787008 11219726336 1879872064 18.664 100 76 154 1 1914129296 13392576 20864656
14:14:52 5205 8192000000 10803357600 11213873152 1879880576 18.664 100 47 95 0 1903776912 11211360 12684976
14:15:03 8763 8192000000 10789197584 11213697024 1876203664 18.634 100 25 50 0 1894532304 11290944 7037696
14:15:18 4067 8192000000 10799827248 11217891328 1881799584 18.680 100 43 84 2 1901590720 8235872 11555264
14:15:31 6465 8192000000 10792555680 11220422656 1884016320 18.698 100 32 64 2 1901526368 8266864 9243184
14:15:45 19223 8192000000 10808491968 11230527488 1889953456 18.745 100 39 76 5 1907441376 5980784 11507136
14:16:39 46483 8192000000 10817365216 11241189376 1896738800 18.800 100 35 69 1 1912667328 5418944 10509584
14:17:31 6372 8192000000 10830023536 11250733056 1902574000 18.847 100 42 85 2 1921252240 6602864 12075376
14:17:46 7560 8192000000 10815056032 11249876992 1900011232 18.826 100 20 40 3 1911697600 5985776 5700592
14:18:02 4419 8192000000 10815682288 11251503104 1904655728 18.864 100 28 57 0 1919812432 7307664 7849040
14:18:13 8067 8192000000 10814112976 11254075392 1909802272 18.905 100 20 40 2 1921745744 6048688 5894784
14:18:29 10909 8192000000 10830936672 11262246912 1912309248 18.925 100 18 36 0 1923246592 5763040 5174304
14:18:47 10578 8192000000 10831401280 11264339968 1913630720 18.936 100 20 40 2 1924718096 5443856 5643520
14:19:05 11278 8192000000 10825511232 11264462848 1914732000 18.945 100 18 36 1 1926182336 6050528 5399808
14:19:24 6060 8192000000 10839412672 11266330624 1916124816 18.956 100 25 51 0 1929508608 6080112 7303680
14:19:39 15426 8192000000 10832810384 11265974272 1914414400 18.942 100 16 32 1 1924335616 5343872 4577344
14:20:01 8768 8192000000 10828441104 11266445312 1915086528 18.947 100 18 36 1 1926630272 6348240 5195504
14:20:19 9687 8192000000 10826168208 11262181376 1909967600 18.906 100 13 27 0 1920004496 5844048 4192848
14:20:35 7470 8192000000 10827006256 11264991232 1913246144 18.933 100 22 44 3 1925317280 5961088 6110048
14:20:53 15896 8192000000 10825758768 11267264512 1916984368 18.963 100 21 42 0 1929661152 6025424 6651360
14:21:15 70372 8192000000 10816925968 11260112896 1898731664 18.816 99 24 48 1 1911432896 5277312 7423920
14:22:31 7261 8192000000 10842274864 11267276800 1914437472 18.942 100 34 69 2 1930174208 6494064 9242672
14:22:47 5520 8192000000 10838291392 11265658880 1916077280 18.955 100 31 63 0 1931532816 7270736 8184800
14:23:00 6546 8192000000 10817237744 11251437568 1890744496 18.752 99 31 62 0 1905444288 5562256 9137536
14:23:16 5885 8192000000 10815989312 11255250944 1904842272 18.865 100 29 58 1 1919759376 6633776 8283328
14:23:30 9047 8192000000 10806961232 11235528704 1877024320 18.641 99 28 56 1 1891095632 6689856 7381456
14:23:45 8807 8192000000 10785263536 11221266432 1859869552 18.502 99 18 35 2 1871001152 6052288 5079312
14:24:04 11613 8192000000 10782695808 11203874816 1789679152 17.929 95 26 52 1 1802829712 5525248 7625312
14:24:23 9299 8192000000 10766067552 11199979520 1831458608 18.271 98 22 44 0 1846808464 9492256 5857600
14:24:41 7093 8192000000 10725769472 11157684224 1738951776 17.510 94 23 44 2 1751280288 5340608 6987904
14:24:57 12275 8192000000 10757022512 11175124992 1829676960 18.257 100 23 46 1 1845780000 9490800 6612240
14:25:19 7310 8192000000 10723660576 11140014080 1769938592 17.767 97 15 30 3 1778684416 4855424 3890400
14:25:32 7500 8192000000 10719775072 11136737280 1763202384 17.711 97 23 46 0 1775942624 5146464 7593776
14:25:47 15880 8192000000 10705839088 11107069952 1711082512 17.278 96 15 27 1 1720186592 5038032 4066048
14:26:10 63831 8192000000 10698287040 11094671360 1701007216 17.194 94 54 111 4 1721702032 4769200 15925616
14:27:20 14978 8192000000 10682546896 11105538048 1730019984 17.436 97 13 26 1 1739903040 6182288 3700768
14:27:41 8494 8192000000 10701474080 11117793280 1745472016 17.564 97 39 78 0 1767652272 10710944 11469312
14:27:58 9839 8192000000 10713164096 11122847744 1758441456 17.671 98 30 60 4 1772456848 5813952 8201440
14:28:16 8152 8192000000 10723828864 11136888832 1798346832 18.000 100 19 38 0 1809180272 5422272 5411168
14:28:33 7098 8192000000 10728807344 11141537792 1792006800 17.948 99 28 56 3 1806840176 6293040 8540336
14:28:47 10953 8192000000 10735846928 11154690048 1799426128 18.009 99 27 54 0 1812888272 5513200 7948944
14:29:08 8092 8192000000 10738809792 11155279872 1816959392 18.153 100 24 48 1 1829894800 6427424 6507984
14:29:24 8275 8192000000 10750469216 11169005568 1830420272 18.263 100 20 41 3 1841306608 5407808 5478528
14:29:38 7101 8192000000 10746481056 11171295232 1835155888 18.301 100 28 56 2 1848480048 4706272 8617888
14:29:52 13561 8192000000 10755069456 11179315200 1841973600 18.357 100 27 52 3 1854627008 5335248 7318160
14:30:15 10241 8192000000 10759544976 11186192384 1847958736 18.406 100 27 54 1 1861521120 4788672 8773712
14:30:32 7386 8192000000 10762960768 11188391936 1848951488 18.414 100 17 33 0 1858697728 4795664 4950576
14:30:47 21447 8192000000 10773477744 11197947904 1856286432 18.473 100 30 60 0 1871152464 6433552 8432480
14:31:52 35934 8192000000 10808220528 11225489408 1876685392 18.638 100 32 64 0 1892754112 6447264 9621456
14:32:38 4674 8192000000 10836773888 11246653440 1895873680 18.793 100 57 112 3 1921065248 9043856 16147712
14:32:50 1556 8192000000 10852070416 11257008128 1906590336 18.879 100 77 156 3 1939567168 9819536 23157296
14:33:00 16836 8192000000 10850601520 11264614400 1909667968 18.904 100 63 124 1 1937615632 10947328 17000336
14:33:44 8182 8192000000 10855709680 11271671808 1915413760 18.950 100 62 124 0 1946557536 13829664 17314112
14:34:02 7085 8192000000 10863663008 11279388672 1920633648 18.992 100 73 145 0 1955109616 13870528 20605440
14:34:27 14706 8192000000 10869888464 11284926464 1925356544 19.030 100 63 124 0 1956481056 13751424 17373088
14:34:50 15796 8192000000 10861450416 11284017152 1928632304 19.056 100 64 129 1 1961048800 14365776 18050720
14:35:14 23037 8192000000 10882797984 11293810688 1935301920 19.109 100 68 135 2 1968647328 14308256 19037152
14:35:52 12304 8192000000 10862686768 11298140160 1935091664 19.108 100 52 102 0 1965052240 15649040 14311536
14:36:13 6240 8192000000 10883190752 11299553280 1941489712 19.159 100 57 115 1 1969857888 12165584 16202592
14:36:27 9569 8192000000 10882495152 11308511232 1944105376 19.180 100 59 118 2 1974365600 13540016 16720208
14:36:48 21709 8192000000 10894310368 11316957184 1952237136 19.244 100 68 135 3 1986180080 13734496 20208448
14:37:34 15715 8192000000 10895568336 11325177856 1956186880 19.276 100 49 98 0 1987375824 16776848 14412096
14:37:57 47565 8192000000 10891870624 11336749056 1959431696 19.302 100 47 93 0 1988137120 15078128 13627296
14:38:53 34237 8192000000 10894870848 11335892992 1949195392 19.220 99 27 53 0 1972835488 15784208 7855888
14:39:38 14799 8192000000 10914196912 11347103744 1972928256 19.409 100 45 90 1 2004241184 18300128 13012800
14:40:00 8353 8192000000 10918778000 11351302144 1977747232 19.447 100 58 117 2 2014517616 19757280 17013104
14:40:15 7500 8192000000 10931475248 11359105024 1980131440 19.466 100 60 120 1 2018531984 20701504 17699040
14:40:30 5570 8192000000 10931168480 11357900800 1982780672 19.487 100 66 128 3 2022528816 20519376 19228768
14:40:49 13533 8192000000 10931136688 11360247808 1982327296 19.483 100 66 132 1 2024965888 23362736 19275856
14:41:15 8800 8192000000 10930049520 11359854592 1980904896 19.472 100 53 106 1 2019649056 23278880 15465280
14:41:30 12793 8192000000 10939632640 11370627072 1983564512 19.493 100 54 106 2 2026115184 26590192 15960480
14:41:51 17156 8192000000 10927463088 11366715392 1987475840 19.524 100 51 102 0 2024745600 22135920 15133840
14:42:33 8494 8192000000 10944422432 11379671040 1992924400 19.567 100 49 98 2 2029707120 22773200 14009520
14:42:48 11701 8192000000 10955886112 11379994624 1999548768 19.619 100 63 126 2 2041984304 23636512 18799024
14:43:07 5574 8192000000 10962178096 11389407232 2002469296 19.642 100 67 134 1 2045469952 22846608 20154048
14:43:19 7188 8192000000 10964253488 11391627264 2007640480 19.683 100 77 154 2 2055164800 24653648 22870672
14:43:34 10503 8192000000 10975508528 11397697536 2010043552 19.702 100 76 152 1 2059438064 26856480 22538032
14:43:53 10043 8192000000 10969178016 11400052736 2012467024 19.721 100 70 140 1 2058985840 25819136 20699680
14:44:10 2912 8192000000 10966820848 11397435392 2010272640 19.704 100 65 129 0 2056094928 25943856 19878432
14:44:22 2891 8192000000 10974658656 11401842688 2012638160 19.722 100 76 151 2 2060761632 25435904 22687568
14:44:32 4717 8192000000 10976501344 11407441920 2014724752 19.739 100 72 143 0 2061817328 25978016 21114560
14:44:45 13185 8192000000 10970836608 11405479936 2017694624 19.762 100 75 150 1 2066723680 26781312 22247744
14:45:06 3134 8192000000 10977230912 11406053376 2011932320 19.717 100 69 134 1 2062499760 28827808 21739632
14:45:17 8198 8192000000 10969866688 11395866624 1997800160 19.605 99 75 147 1 2050897680 30354816 22742704
14:45:34 17400 8192000000 10968524592 11403993088 2009396512 19.697 100 70 140 2 2060481472 29329936 21755024
14:46:02 5954 8192000000 10970531840 11408396288 2012448048 19.721 100 73 139 1 2064366720 30113520 21805152
14:46:21 15130 8192000000 10970464528 11413532672 2011824720 19.716 100 46 88 5 2054562848 28456368 14281760
14:46:48 6383 8192000000 10977282128 11418132480 2017165744 19.758 100 57 112 1 2065590688 30778608 17646336
14:47:02 7547 8192000000 10989102896 11423260672 2019898608 19.779 100 66 129 2 2073386784 32754528 20733648
14:47:18 6506 8192000000 10964827008 11402620928 1980335136 19.467 98 67 134 2 2032210096 30577328 21297632
14:47:33 5460 8192000000 10983057744 11413004288 2011777488 19.716 100 78 154 3 2068132800 32679360 23675952
14:47:47 7690 8192000000 10994942784 11423244288 2018304912 19.767 100 70 140 2 2073690400 34074624 21310864
14:48:03 6201 8192000000 10976988000 11412742144 1996014688 19.591 99 74 147 1 2053492464 35193584 22284192
14:48:18 3304 8192000000 10991513360 11423129600 2015771552 19.747 100 77 152 0 2074764768 36691648 22301568
14:48:28 2764 8192000000 10995985328 11420499968 2014246448 19.735 100 85 168 2 2077396144 37621552 25528144
14:48:43 3838 8192000000 11010528176 11433902080 2024354928 19.814 100 89 178 2 2091171344 39840480 26975936
14:48:53 1989 8192000000 11010297504 11432808448 2024085776 19.812 100 91 182 0 2090074464 38087632 27901056
14:49:02 1799 8192000000 11014835904 11436044288 2028984224 19.851 100 87 172 1 2089339056 34945696 25409136
14:49:11 1066 8192000000 11000387072 11421696000 2010855296 19.708 99 93 187 2 2073556960 35914928 26786736
14:49:19 3122 8192000000 10980388752 11408236544 1998873088 19.614 99 88 176 2 2056325856 31137184 26315584
14:49:29 9796 8192000000 10975454912 11407228928 2008909952 19.693 100 67 133 0 2058561936 30121264 19530720
14:49:46 4026 8192000000 10972464336 11413749760 2010513872 19.706 100 61 122 1 2061745008 32657776 18573360
14:50:04 2500 8192000000 10984554624 11417792512 2014282944 19.735 100 64 128 4 2067534208 33153808 20097456
14:50:16 3062 8192000000 10986840848 11412922368 1998052496 19.607 99 85 171 1 2058282704 34258832 25971376
14:50:26 9672 8192000000 10979041632 11411283968 1988601456 19.533 99 69 137 4 2043709184 35105648 20002080
14:50:45 8473 8192000000 10984279504 11410366464 2001560864 19.635 100 79 158 2 2062399760 37280384 23558512
14:51:01 2572 8192000000 10994963504 11416076288 2009220944 19.695 100 87 175 1 2071077936 36461680 25395312
14:51:10 14754 8192000000 10974125312 11399430144 1968367936 19.372 98 78 151 3 2029065408 37319584 23377888
14:51:32 6454 8192000000 10979400576 11409473536 2004161072 19.656 100 76 152 2 2066876160 39384912 23330176
14:51:47 3569 8192000000 10990617584 11420614656 2009110496 19.695 100 74 147 2 2072818848 40980432 22727920
14:51:58 1791 8192000000 10962747776 11392753664 1978066464 19.449 99 68 135 2 2037935152 39141424 20727264
14:52:12 9294 8192000000 10977715664 11411173376 1999251296 19.617 100 55 110 0 2057026544 40617344 17157904
14:52:29 2810 8192000000 10962392976 11378135040 1976545776 19.437 99 84 168 1 2044457104 42221552 25689776
14:52:39 4142 8192000000 10982169296 11411992576 2000699952 19.628 100 75 150 1 2067125360 43062320 23363088
14:52:51 2199 8192000000 10997581552 11413798912 2004140576 19.655 100 82 163 3 2073479184 44273664 25064944
14:53:04 3198 8192000000 10995653952 11420221440 2007031024 19.678 100 79 154 2 2077481568 45515744 24934800
14:53:18 1988 8192000000 10998205584 11422552064 2006380368 19.673 100 79 159 0 2076024368 45752368 23891632
14:53:29 2966 8192000000 10989915392 11410960384 2000768368 19.629 100 70 139 2 2069046544 46727184 21550992
14:53:39 1550 8192000000 10980963520 11401867264 1977205600 19.443 99 82 162 3 2049126928 46043680 25877648
14:53:56 2335 8192000000 10969474688 11385389056 1951055472 19.235 98 77 155 5 2014482400 39258976 24167952
14:54:10 4758 8192000000 10932184064 11365789696 1958259792 19.292 99 58 116 0 2016578144 40310240 18008112
14:54:23 4809 8192000000 10957820992 11385446400 1984057504 19.497 100 75 150 0 2044131328 36218048 23855776
14:54:44 10136 8192000000 10916535072 11353657344 1905341792 18.869 96 50 100 1 1956137520 34763904 16031824
14:55:06 10757 8192000000 10919493696 11356430336 1925862784 19.034 98 33 66 0 1970707824 33926368 10918672
14:55:24 8152 8192000000 10927995328 11362529280 1960206464 19.308 100 44 88 3 2009722640 35104112 14412064
14:55:40 5579 8192000000 10936899200 11367759872 1965221616 19.348 100 50 100 0 2018688304 37280192 16186496
14:55:53 4374 8192000000 10949923808 11374870528 1965563840 19.350 100 55 110 2 2022126400 38761360 17801200
14:56:07 4419 8192000000 10945131040 11358752768 1955429744 19.270 100 84 168 2 2025619744 43041360 27148640
14:56:19 1395 8192000000 10949487936 11361058816 1942644304 19.168 99 81 161 1 2012181696 44181584 25355808
14:56:27 2382 8192000000 10949801888 11362754560 1959256192 19.300 100 80 159 2 2030673616 45987024 25430400
14:56:37 2999 8192000000 10959019312 11369312256 1958766176 19.296 100 85 165 3 2034178096 49098976 26312944
14:56:48 1918 8192000000 10960814000 11371888640 1960719168 19.312 100 84 167 0 2038147088 51247312 26180608
14:57:00 10799 8192000000 10964909184 11379896320 1966331072 19.356 100 77 154 3 2042841936 52021936 24488928
14:57:18 7464 8192000000 10965118912 11387949056 1970853680 19.392 100 77 155 1 2046496096 51294528 24347888
14:57:35 845 8192000000 10970482528 11378778112 1969113648 19.378 100 83 163 2 2044397616 48399936 26884032
14:57:43 2893 8192000000 10977014368 11388452864 1978569568 19.453 100 86 171 3 2055190864 49651056 26970240
14:57:53 1573 8192000000 10980218560 11392311296 1983187552 19.490 100 84 168 1 2061699168 50797424 27714192
14:58:01 2441 8192000000 10985046560 11395698688 1975255856 19.427 100 93 181 1 2055344384 51363840 28724688
14:58:10 2214 8192000000 10996244208 11404189696 1985438496 19.508 100 87 171 2 2064112032 50673728 27999808
14:58:22 2484 8192000000 10979413152 11399925760 1982109088 19.481 100 71 141 2 2056333232 51711248 22512896
14:58:34 9676 8192000000 10941658976 11391500288 1975267536 19.427 100 48 96 6 2041940752 50250160 16423056
14:58:53 5063 8192000000 10966779376 11399319552 1984675824 19.502 100 48 96 1 2046160144 45315600 16168720
14:59:16 2914 8192000000 10982173712 11407994880 1992165552 19.561 100 69 138 0 2061896992 47451376 22280064
14:59:27 7215 8192000000 10986855120 11420438528 2001647024 19.636 100 61 121 0 2074046592 53260176 19139392
14:59:42 12822 8192000000 10967644768 11406524416 1953880800 19.257 98 41 82 2 2021698272 53449472 14368000
15:00:12 6660 8192000000 10977567104 11411222528 1992550288 19.564 100 55 110 2 2063316816 53113680 17652848
15:00:28 4742 8192000000 10991548720 11416760320 1992593328 19.564 100 60 120 0 2067715216 55430240 19691648
15:00:43 12263 8192000000 10967011632 11402919936 1969619776 19.382 99 45 90 1 2043848608 58555888 15672944
15:01:04 21512 8192000000 10967345744 11411173376 1979849504 19.464 100 41 82 0 2053120272 59042432 14228336
15:01:38 21693 8192000000 10979288784 11420262400 1986829696 19.519 100 38 76 1 2060128256 59693696 13604864
15:02:11 13324 8192000000 10972881152 11413086208 1979899904 19.464 100 35 70 3 2054438656 62071808 12466944
15:02:32 17685 8192000000 10985820080 11426553856 1986202208 19.514 100 38 76 0 2066061184 66063664 13795312
15:03:01 13356 8192000000 10965015328 11410178048 1960522304 19.310 99 34 68 0 2042242064 68860704 12859056
15:03:36 13321 8192000000 10960018208 11414298624 1967863440 19.368 100 29 58 2 2044349344 65392400 11093504
15:04:07 25035 8192000000 10940993328 11394224128 1937409952 19.126 99 21 42 0 2004951856 59636144 7905760
15:04:39 9659 8192000000 10957599920 11397767168 1937577712 19.127 99 36 72 0 2019601968 70085696 11938560
15:04:59 10393 8192000000 10920054832 11369926656 1910599824 18.911 99 27 54 1 1992548816 72318656 9630336
15:05:38 31007 8192000000 10891766720 11355754496 1925874320 19.034 100 17 34 0 1962490688 31255600 5360768
15:06:15 20209 8192000000 10876910304 11348455424 1936106576 19.116 100 17 34 1 1960222000 19253136 4862288
15:06:42 21012 8192000000 10858479936 11337342976 1911596032 18.919 99 4 8 0 1931512640 18851632 1064976
15:07:18 72083 8192000000 10842273008 11286929408 1861723504 18.517 96 31 58 2 1876914160 6781712 8408944
15:08:37 24923 8192000000 10880607808 11314130944 1928893152 19.058 100 59 120 0 1953817872 6850912 18073808
15:09:09 43660 8192000000 10870067872 11330867200 1940172640 19.148 100 35 70 0 1961153840 11025808 9955392
15:10:00 46228 8192000000 10873982016 11335188480 1929338752 19.062 99 12 24 0 1943563504 10727008 3497744
15:10:55 144245 8192000000 10871603952 11343282176 1890584272 18.750 97 14 28 1 1905418400 10933344 3900784
15:13:52 73377 8192000000 10881492032 11360276480 1945100416 19.187 99 21 42 0 1966665168 15318512 6246240
15:15:12 74761 8192000000 10884373776 11357364224 1942591456 19.167 99 14 28 1 1960648992 13830832 4226704
15:16:34 136758 8192000000 10877519744 11340562432 1890993552 18.754 96 17 34 0 1904369344 8289344 5086448
15:19:14 57511 8192000000 10894904208 11364470784 1949363056 19.221 99 20 40 1 1963789152 8837616 5588480
15:20:18 18372 8192000000 10898004304 11370205184 1970745184 19.391 100 9 18 0 1985162464 11521712 2895568
15:22:06 113175 8192000000 10895728896 11357134848 1925474368 19.031 98 22 44 1 1939918656 7857536 6586752
15:24:06 26029 8192000000 10898499936 11362172928 1970887552 19.392 100 28 56 2 1987197600 8610192 7699856
15:24:51 12063 8192000000 10897774480 11363135488 1973223424 19.411 100 33 66 0 1991931744 9116032 9592288
15:25:12 15740 8192000000 10903405520 11368284160 1975252352 19.427 100 31 62 1 1994447200 9887920 9306928
15:25:35 36792 8192000000 10919639984 11372761088 1982682288 19.486 100 45 88 2 2005898736 11240768 11975680
15:26:19 23285 8192000000 10923103408 11378614272 1981421520 19.476 100 53 106 1 2009817600 12057968 16338112
15:26:53 26019 8192000000 10912140192 11372224512 1964849872 19.345 99 45 90 0 1988834576 10951968 13032736
15:27:26 23012 8192000000 10916661056 11371651072 1981818224 19.479 100 42 85 0 2002934656 9293504 11822928
15:28:05 16102 8192000000 10915207952 11378290688 1984227584 19.498 100 33 64 1 2001772688 7351744 10193360
15:28:33 46432 8192000000 10893451840 11364700160 1957713584 19.288 99 16 32 0 1969837312 7673280 4450448
15:29:26 76273 8192000000 10900860816 11372429312 1962300992 19.324 99 14 28 0 1974548176 7959536 4287648
15:30:57 79919 8192000000 10891965344 11372326912 1971706656 19.399 100 14 28 1 1985483872 10141440 3635776
15:32:27 7818 8192000000 10897975792 11374579712 1978024304 19.449 100 13 24 0 1990952912 9547792 3380816
15:32:41 26937 8192000000 10889353440 11363577856 1958528656 19.294 99 9 16 0 1970859520 10455424 1875440
15:33:37 61391 8192000000 10889313872 11369922560 1958516304 19.294 99 12 24 1 1968521376 7553968 2451104
15:34:47 52736 8192000000 10899946736 11375595520 1944013712 19.179 98 8 16 1 1953731504 7827248 1890544
15:35:46 55418 8192000000 10906373120 11375009792 1936831360 19.121 97 10 20 0 1950661392 10596480 3233552
15:36:56 39899 8192000000 10918052592 11391303680 1968976640 19.377 99 23 46 0 1992946800 17232192 6737968
15:37:53 38070 8192000000 10892182368 11369799680 1921782288 19.001 97 14 28 0 1938653408 12465552 4405568
15:38:42 52418 8192000000 10872457424 11335991296 1909479664 18.902 97 16 32 0 1925943680 11680304 4783712
15:39:45 57968 8192000000 10900277168 11363590144 1965246560 19.348 100 40 80 0 1998185232 21174336 11764336
15:40:56 95165 8192000000 10870722352 11350892544 1822316880 18.197 93 10 20 0 1843697408 18570848 2809680
15:42:38 64970 8192000000 10890282608 11365543936 1938819936 19.137 99 21 42 0 1962914576 18100448 5994192
15:43:49 39276 8192000000 10908645024 11359502336 1948754608 19.217 99 30 60 1 1967855520 10944448 8156464
15:44:46 43906 8192000000 10899423248 11362357248 1948383392 19.214 99 34 67 0 1969180368 11346160 9450816
15:45:37 111349 8192000000 10907389488 11381829632 1919653184 18.984 97 18 34 0 1939190880 14967392 4570304
15:47:35 106478 8192000000 10878118592 11364851712 1892193664 18.763 96 10 19 2 1914945184 20348208 2403312
15:49:48 60347 8192000000 10855625456 11324735488 1892321920 18.764 97 23 46 2 1906496576 7775424 6399232
15:50:54 98917 8192000000 10851489632 11316822016 1846662480 18.395 95 20 40 3 1860807888 8191776 5953632
15:52:45 67410 8192000000 10852015728 11338313728 1939922848 19.146 100 12 24 0 1951889568 8257520 3709200
15:55:03 66233 8192000000 10845579472 11320184832 1851116896 18.431 95 11 23 0 1863674864 9547696 3010272
15:56:15 69961 8192000000 10852273552 11337732096 1922240016 19.005 99 20 39 1 1938555792 10943632 5372144
15:57:41 71964 8192000000 10859359568 11356565504 1939573504 19.143 100 5 11 0 1953567168 12696816 1296848
15:58:59 31892 8192000000 10842245472 11312697344 1843177824 18.367 95 11 21 0 1852504416 6605744 2720848
15:59:38 55084 8192000000 10866130304 11328069632 1877855552 18.648 97 21 42 1 1895231248 11511520 5864176
16:00:39 53066 8192000000 10859918704 11331575808 1893182576 18.771 98 13 25 0 1910614528 13729280 3702672
16:01:41 84650 8192000000 10892465040 11358228480 1933383856 19.094 99 20 40 1 1951622592 13314992 4923744
16:03:29 44621 8192000000 10896767600 11365744640 1930674704 19.072 98 19 38 0 1944250432 8651728 4924000
16:04:20 55950 8192000000 10860678800 11340148736 1850027136 18.422 94 21 42 1 1869110384 12683584 6399664
16:05:24 133839 8192000000 10861526176 11327856640 1821097152 18.187 94 7 14 0 1835558368 12865584 1595632
16:07:46 37915 8192000000 10875636784 11343855616 1924980032 19.027 99 31 62 0 1950764928 17334096 8450800
16:08:37 90809 8192000000 10886747456 11347632128 1910537088 18.911 98 31 62 0 1933049040 14052928 8459024
16:10:17 9426 8192000000 10900921440 11349557248 1954736768 19.264 100 52 103 1 1979976880 10395424 14844688
16:10:40 62997 8192000000 10910629632 11376668672 1940558224 19.151 99 38 76 3 1964873472 14107600 10207648
16:12:06 127806 8192000000 10904069344 11395678208 1948932016 19.218 99 15 30 1 1973636256 20310544 4393696
16:14:23 86243 8192000000 10881063744 11343798272 1930042992 19.067 98 8 16 0 1944646176 12435792 2167392
16:15:58 21850 8192000000 10898866976 11371810816 1970240304 19.387 100 35 66 1 1990524608 11111536 9172768
16:16:31 23531 8192000000 10917744656 11375206400 1981817312 19.479 100 64 119 1 2004975696 6040384 17118000
16:17:04 69483 8192000000 10895311344 11373158400 1925605808 19.032 97 36 74 1 1944839424 9243520 9990096
16:18:20 36210 8192000000 10895502992 11375509504 1976759024 19.439 100 25 50 2 1992906768 9006480 7141264
16:19:25 54468 8192000000 10874643552 11366256640 1947359328 19.205 99 6 12 1 1957427472 8118448 1949696
16:20:25 60952 8192000000 10877440400 11355934720 1915055264 18.947 97 24 48 0 1929227232 7536720 6635248
16:21:49 97940 8192000000 10885484624 11382169600 1947925584 19.210 99 10 20 1 1968093296 17134704 3033008
16:23:35 34002 8192000000 10898155584 11396128768 1966831632 19.360 100 9 18 0 1984622368 15218512 2572224
16:24:15 43195 8192000000 10897048448 11385335808 1935318352 19.109 98 13 26 0 1961500112 22843296 3338464
16:25:09 92500 8192000000 10882490224 11385147392 1883242800 18.691 96 10 20 0 1907568640 21735392 2590448
16:26:47 21599 8192000000 10894962960 11353387008 1925510496 19.031 98 41 82 3 1945580544 6417872 13652176
16:27:17 14567 8192000000 10899434512 11348512768 1922217152 19.005 98 46 92 0 1947488400 12086624 13184624
16:27:52 84974 8192000000 10875263568 11351638016 1890433680 18.749 97 25 50 1 1915402144 18187568 6780896
16:29:24 69930 8192000000 10882238976 11348639744 1894746112 18.784 97 29 58 0 1911852160 9604832 7501216
16:30:45 37487 8192000000 10906139744 11364261888 1938884592 19.138 99 39 78 3 1962723104 13159664 10678848
16:31:40 27895 8192000000 9118199680 9348308992 247842592 2.936 14 2 2 1 254382144 6117088 422464

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 13-03-2021 16:33:10 to 13-03-2021 16:33:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 78 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2021 16:33:44 to 13-03-2021 16:33:46.

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          230384
MON$OLDEST_ACTIVE               230385
MON$OLDEST_SNAPSHOT             230385
MON$NEXT_TRANSACTION            230385
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                       2045920
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Mar 13 16:32:12 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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