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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-16 16:27:11
DTS_END                         2020-12-16 16:27:11.0980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49510
TRN_ID                          255709
ATT_ID                          737
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: 9585.08 20345 1150209
customer order: creation 185.92 344 22310
customer order: refuse 15.94 249 1913
order to supplier: creation 49.48 1287 5938
order to supplier: removal 3.56 84496 427
invoice (draft): creation 49.11 3249 5893
invoice (draft): removal 53.70 680 6444
invoice accept: apply 45.04 16627 5405
invoice accept: cancel 48.24 728 5789
customer reserve: creation 4091.30 168 490956
customer reserve: removal 4735.50 50 568260
realization accept: apply 90.38 145 10846
realization accept: cancel 80.88 90 9706
payment from customer: creation 62.67 108 7520
payment from customer: removal 5.86 90 703
payment to supplier: creation 50.72 113 6086
payment to supplier: removal 3.68 65 442
service: total inventory turnovers 4.88 921 586
service: total monetary turnovers 7.23 19 868
service: aggregate perf. data 0.94 20412 113
service: refresh index statistics 0.03 277063 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-12-2020 16:28:10 to 16-12-2020 16:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4722
TEST_TIME 2 5982
TEST_TIME 3 5866
TEST_TIME 4 5683
TEST_TIME 5 6370
TEST_TIME 6 7128
TEST_TIME 7 7246
TEST_TIME 8 7265
TEST_TIME 9 7530
TEST_TIME 10 7730
TEST_TIME 11 8480
TEST_TIME 12 8573
TEST_TIME 13 8912
TEST_TIME 14 9085
TEST_TIME 15 9489
TEST_TIME 16 9271
TEST_TIME 17 9898
TEST_TIME 18 9936
TEST_TIME 19 10110
TEST_TIME 20 10881
TEST_TIME 21 11200
TEST_TIME 22 11404
TEST_TIME 23 12398
TEST_TIME 24 12205
TEST_TIME 25 11920
TEST_TIME 26 11825
TEST_TIME 27 12036
TEST_TIME 28 11801
TEST_TIME 29 11617
TEST_TIME 30 11615
TEST_TIME 31 11288
TEST_TIME 32 11136
TEST_TIME 33 11017
TEST_TIME 34 10922
TEST_TIME 35 10778
TEST_TIME 36 10631
TEST_TIME 37 10586
TEST_TIME 38 10604
TEST_TIME 39 10540
TEST_TIME 40 10374
TEST_TIME 41 10268
TEST_TIME 42 10132
TEST_TIME 43 10236
TEST_TIME 44 10122
TEST_TIME 45 9981
TEST_TIME 46 10021
TEST_TIME 47 10076
TEST_TIME 48 10015
TEST_TIME 49 9985
TEST_TIME 50 9996
TEST_TIME 51 10055
TEST_TIME 52 10135
TEST_TIME 53 10099
TEST_TIME 54 10102
TEST_TIME 55 10164
TEST_TIME 56 10204
TEST_TIME 57 10194
TEST_TIME 58 10302
TEST_TIME 59 10258
TEST_TIME 60 10179
TEST_TIME 61 10099
TEST_TIME 62 10017
TEST_TIME 63 10005
TEST_TIME 64 9994
TEST_TIME 65 9969
TEST_TIME 66 9918
TEST_TIME 67 9815
TEST_TIME 68 9823
TEST_TIME 69 9761
TEST_TIME 70 9762
TEST_TIME 71 9726
TEST_TIME 72 9781
TEST_TIME 73 9855
TEST_TIME 74 9909
TEST_TIME 75 9871
TEST_TIME 76 9949
TEST_TIME 77 9947
TEST_TIME 78 9979
TEST_TIME 79 9962
TEST_TIME 80 9936
TEST_TIME 81 9894
TEST_TIME 82 9823
TEST_TIME 83 9814
TEST_TIME 84 9775
TEST_TIME 85 9718
TEST_TIME 86 9670
TEST_TIME 87 9639
TEST_TIME 88 9626
TEST_TIME 89 9659
TEST_TIME 90 9601
TEST_TIME 91 9554
TEST_TIME 92 9698
TEST_TIME 93 9707
TEST_TIME 94 9723
TEST_TIME 95 9717
TEST_TIME 96 9677
TEST_TIME 97 9775
TEST_TIME 98 9765
TEST_TIME 99 9767
TEST_TIME 100 9778
TEST_TIME 101 9752
TEST_TIME 102 9804
TEST_TIME 103 9733
TEST_TIME 104 9688
TEST_TIME 105 9641
TEST_TIME 106 9668
TEST_TIME 107 9618
TEST_TIME 108 9577
TEST_TIME 109 9568
TEST_TIME 110 9569
TEST_TIME 111 9545
TEST_TIME 112 9589
TEST_TIME 113 9595
TEST_TIME 114 9611
TEST_TIME 115 9609
TEST_TIME 116 9628
TEST_TIME 117 9640
TEST_TIME 118 9671
TEST_TIME 119 9635
TEST_TIME 120 9585

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-12-2020 16:28:13 to 16-12-2020 16:28:17.

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 1604908 1604908 0 0.00 0 25038 6 0 0
doc_list_biud 1604908 1604908 0 0.00 0 29403 23 0 0
sp_add_invoice_to_stock 5509 5405 104 1.88 33 189762 16627 0 104
sp_cancel_adding_invoice 5789 5789 0 0.00 6 51616 729 0 0
sp_cancel_client_order 1913 1913 0 0.00 4 9250 250 0 0
sp_cancel_customer_reserve 568260 568260 0 0.00 1 25320 51 0 0
sp_cancel_pay_from_customer 703 703 0 0.00 2 7915 90 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 3 3127 66 0 0
sp_cancel_supplier_invoice 6450 6444 6 0.09 2 29537 681 0 6
sp_cancel_supplier_order 427 427 0 0.00 5 945618 84497 0 0
sp_cancel_write_off 9706 9706 0 0.00 1 8915 90 0 0
sp_client_order 22310 22310 0 0.00 4 25127 344 0 0
sp_customer_reserve 490956 490956 0 0.00 0 62247 168 0 0
sp_fill_shopping_cart 34126 34126 0 0.00 1 21369 37 0 0
sp_fill_shopping_cart_clo_res 490956 490956 0 0.00 0 13975 14 0 0
sp_get_clo_for_invoice 5405 5405 0 0.00 0 42590 361 0 0
sp_kill_cost_storno 16640 16640 0 0.00 0 11258 47 0 0
sp_kill_qstorno_ret_qs2qd 1153097 1153097 0 0.00 0 29401 28 0 0
sp_kill_qty_storno 608790 608790 0 0.00 0 29402 59 0 0
sp_lock_selected_doc 22452 22452 0 0.00 0 6813 5 0 0
sp_make_cost_storno 29857 29857 0 0.00 0 25027 47 0 0
sp_multiply_rows_for_pdistr 29857 29857 0 0.00 0 15259 25 0 0
sp_multiply_rows_for_qdistr 22310 22310 0 0.00 0 12318 161 0 0
sp_pay_from_customer 7520 7520 0 0.00 4 15270 108 0 0
sp_pay_to_supplier 6086 6086 0 0.00 5 14452 114 0 0
sp_payment_common 13606 13606 0 0.00 1 14400 26 0 0
sp_qd_handle_on_cancel_clo 1913 1913 0 0.00 0 9237 225 0 0
sp_qd_handle_on_invoice_upd_sts 11194 11194 0 0.00 0 26087 257 0 0
sp_qd_handle_on_reserve_upd_sts 10846 10846 0 0.00 0 10850 47 0 0
sp_reserve_write_off 10846 10846 0 0.00 6 20506 146 0 0
sp_supplier_invoice 5893 5893 0 0.00 7 103255 3249 0 0
sp_supplier_order 5938 5938 0 0.00 5 33681 1288 0 0
srv_aggregate_perf_data 113 113 0 0.00 2305 219771 20413 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1151 110524 33735 0 0
srv_find_qd_qs_mism 1099478 1099478 0 0.00 0 12757 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 35 30890 921 0 0
srv_make_money_saldo 868 868 0 0.00 1 839 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 100949 397131 277064 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5405 5405 0 0.00 0 9143 140 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 0 15212 106 0 0
t$perf-norm:sp_cancel_client_order 1913 1913 0 0.00 0 3618 15 0 0
t$perf-norm:sp_cancel_customer_reserve 771 771 0 0.00 0 949 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 703 703 0 0.00 0 4466 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 5727 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 749 10 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 18513 1281 0 0
t$perf-norm:sp_cancel_write_off 1093 1093 0 0.00 0 14758 23 0 0
t$perf-norm:sp_client_order 22310 22310 0 0.00 0 16542 17 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 4834 13 0 0
t$perf-norm:sp_pay_from_customer 7520 7520 0 0.00 0 4989 8 0 0
t$perf-norm:sp_pay_to_supplier 6086 6086 0 0.00 0 5505 9 0 0
t$perf-norm:sp_reserve_write_off 10846 10846 0 0.00 0 10001 12 0 0
t$perf-norm:sp_supplier_invoice 5893 5893 0 0.00 0 11598 21 0 0
t$perf-norm:sp_supplier_order 5938 5938 0 0.00 0 3877 12 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 23 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 2473 24 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 755 16 0 0
t$perf-norm:srv_make_money_saldo 868 868 0 0.00 0 723 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 11018 10810 208 1.88 0 5031 19 0 208
v_all_customers 39970 39970 0 0.00 0 78 1 0 0
v_all_suppliers 32040 32040 0 0.00 0 18 1 0 0
v_all_wares 44620 44620 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 669 6 0 0
v_cancel_client_order 3826 3826 0 0.00 0 3307 6 0 0
v_cancel_customer_prepayment 1406 1406 0 0.00 0 4103 12 0 0
v_cancel_customer_reserve 1542 1542 0 0.00 0 1609 8 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 3107 8 0 0
v_cancel_supplier_invoice 868 856 12 1.38 0 1384 17 0 12
v_cancel_supplier_order 854 854 0 0.00 0 5426 14 0 0
v_cancel_write_off 2186 2186 0 0.00 0 2819 14 0 0
v_max_id_clo_ord 5934 5934 0 0.00 0 237 1 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 6751 30 0 0
v_max_id_ord_sup 5880 5880 0 0.00 0 6735 7 0 0
v_max_non_paid_invoice 1873 1873 0 0.00 0 107 2 0 0
v_max_non_paid_realizn 4111 4111 0 0.00 0 2651 3 0 0
v_min_id_clo_ord 5934 5934 0 0.00 0 2876 5 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 5286 16 0 0
v_min_id_ord_sup 5879 5879 0 0.00 0 4963 7 0 0
v_min_non_paid_invoice 6086 6086 0 0.00 0 7149 19 0 0
v_min_non_paid_realizn 7520 7520 0 0.00 0 7049 14 0 0
v_our_firm 11468 11468 0 0.00 0 21 1 0 0
v_reserve_write_off 21692 21692 0 0.00 0 4971 6 0 0
x_lock_depdocs_on_canc_invoice 11805 11805 0 0.00 0 15539 103 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 8163 236 0 0
x_make_qstorno_1000_1200 5938 5938 0 0.00 1 33675 1220 0 0
x_make_qstorno_1200_2000 5893 5893 0 0.00 4 103055 3109 0 0
x_make_qstorno_2100_3300 490956 490956 0 0.00 0 62245 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-12-2020 16:28:18 to 16-12-2020 16:28:22.

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:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 12056 8192000000 10216482000 10520125440 957912208 10.469 76 59 119 1 979965360 2653344 19399808
13:57:42 24922 8192000000 10327829440 10639155200 1365992512 14.291 100 84 168 0 1398031200 4790432 27248256
13:58:19 13700 8192000000 10341647616 10661081088 1401140320 14.605 100 79 157 0 1433264384 6433184 25690880
13:58:46 24742 8192000000 10387705120 10710462464 1436606336 14.920 100 86 173 0 1471799680 7208208 27985136
13:59:23 17370 8192000000 10410820048 10738196480 1457961328 15.108 100 90 180 0 1499614864 12548688 29104848
13:59:54 19749 8192000000 10424272096 10755477504 1473949504 15.248 100 86 172 0 1510565088 8742160 27873424
14:00:30 27818 8192000000 10454910192 10793279488 1506510928 15.533 100 91 182 0 1545011600 9433792 29066880
14:01:15 17338 8192000000 10502722688 10849386496 1552717568 15.933 100 82 164 0 1587872528 9865888 25289072
14:01:41 15233 8192000000 10519994496 10871930880 1583127280 16.195 100 84 169 0 1619396528 10262608 26006640
14:02:05 16184 8192000000 10561662416 10917068800 1603587984 16.370 100 80 159 1 1638199200 10621424 23989792
14:02:30 12381 8192000000 10580836240 10940149760 1631541440 16.608 100 79 158 1 1667051168 11304960 24204768
14:02:51 7473 8192000000 10608763616 10972692480 1666635920 16.905 100 78 155 0 1700886144 12037024 22213200
14:03:08 12105 8192000000 10639336096 11003789312 1686777168 17.074 100 88 176 1 1725218496 13086240 25355088
14:03:27 6239 8192000000 10649003968 11014361088 1702624544 17.207 100 81 162 0 1739329488 13406240 23298704
14:03:41 6877 8192000000 10660555168 11030863872 1713655296 17.299 100 85 170 1 1752063808 13833856 24574656
14:03:56 5700 8192000000 10673216496 11043852288 1726593296 17.407 100 85 170 1 1764415648 13755760 24066592
14:04:09 7629 8192000000 10680269088 11055644672 1737759264 17.500 100 86 170 1 1775762816 13474256 24529296
14:04:24 4994 8192000000 10686871552 11064500224 1744323376 17.555 100 84 168 1 1781675072 13204400 24147296
14:04:36 5499 8192000000 10689154528 11067506688 1757049536 17.660 100 75 149 2 1790801136 12677472 21074128
14:04:49 4431 8192000000 10701187088 11079163904 1765666128 17.731 100 83 166 1 1802378960 13046528 23666304
14:05:02 3388 8192000000 10718677216 11097063424 1774270864 17.802 100 84 168 1 1812108080 14350320 23486896
14:05:12 2968 8192000000 10720128672 11099918336 1778829888 17.840 100 88 176 1 1818376848 14315968 25230992
14:05:21 3083 8192000000 10723472736 11101241344 1787340976 17.910 100 90 180 0 1826557248 13541888 25674384
14:05:31 2141 8192000000 10732351664 11112771584 1789593664 17.928 100 82 164 1 1826328992 13627008 23108320
14:05:41 1854 8192000000 10738977600 11121541120 1799856848 18.013 100 82 162 0 1834549472 12098368 22594256
14:05:49 2566 8192000000 10748814144 11130281984 1806875392 18.070 100 93 187 0 1847991744 13926480 27189872
14:05:58 3374 8192000000 10741827088 11132485632 1810418512 18.099 100 87 174 0 1848600832 13677744 24504576
14:06:09 1543 8192000000 10756611648 11143221248 1826325280 18.229 100 82 163 2 1861285360 11686512 23273568
14:06:16 2681 8192000000 10768378352 11154219008 1825609504 18.224 100 90 180 2 1864536960 13290112 25637344
14:06:25 1283 8192000000 10772437696 11153276928 1829911664 18.259 100 96 191 1 1870122112 13100480 27109968
14:06:33 1455 8192000000 10785325856 11168419840 1838204336 18.326 100 90 180 0 1878048912 14267040 25577536
14:06:41 1274 8192000000 10786662032 11169234944 1841673536 18.354 100 96 194 1 1881874400 12729984 27470880
14:06:48 1555 8192000000 10790444432 11177205760 1849576320 18.419 100 92 186 0 1888754048 12446128 26731600
14:06:56 1564 8192000000 10793709824 11182227456 1855713744 18.469 100 92 184 1 1894531152 12938160 25879248
14:07:04 1587 8192000000 10806807232 11193503744 1862766800 18.526 100 92 183 1 1901145216 13307392 25071024
14:07:12 1320 8192000000 10809828768 11197681664 1867692736 18.566 100 94 189 0 1907779776 13466048 26620992
14:07:19 967 8192000000 10817316400 11204562944 1870216624 18.586 100 91 183 0 1909564896 13606256 25742016
14:07:26 1086 8192000000 10819744960 11209494528 1873567056 18.613 100 93 188 0 1913657104 13999904 26090144
14:07:34 39259 8192000000 10810475712 11210579968 1873248608 18.611 100 67 135 0 1902324608 9643440 19432560
14:08:19 11385 8192000000 10780018272 11206545408 1867471744 18.564 100 37 72 3 1885894784 7993584 10429456
14:08:41 7052 8192000000 10788442288 11211849728 1875916480 18.632 100 32 64 1 1892232976 6767072 9549424
14:08:56 4852 8192000000 10796631824 11218042880 1878178096 18.650 100 33 66 1 1895842768 8467024 9197648
14:09:14 9610 8192000000 10795325056 11222876160 1877692832 18.646 100 23 46 4 1890954864 6326624 6935408
14:09:30 4127 8192000000 10794565312 11223093248 1883210112 18.691 100 33 66 1 1899830032 7118176 9501744
14:09:44 9687 8192000000 10793594544 11224170496 1884503712 18.701 100 22 46 1 1896473296 5886352 6083232
14:10:05 9776 8192000000 10802469632 11226882048 1883955104 18.697 100 21 42 1 1896025136 5500224 6569808
14:10:22 9368 8192000000 10792947920 11227402240 1888363680 18.733 100 23 46 2 1900505456 5722352 6419424
14:10:39 12034 8192000000 10795960368 11232309248 1889841936 18.745 100 15 30 2 1899982816 5823040 4317840
14:11:00 10625 8192000000 10802047952 11237224448 1897453840 18.806 100 17 34 3 1907071056 5512368 4104848
14:11:23 8518 8192000000 10809074656 11243397120 1898341984 18.813 100 18 35 1 1909148288 6319088 4487216
14:11:37 11448 8192000000 10808508864 11243184128 1900927648 18.834 100 17 34 0 1911865744 5825680 5112416
14:11:55 52367 8192000000 10825875104 11251982336 1903831136 18.857 100 21 43 0 1915904192 5930944 6142112
14:12:56 24281 8192000000 10812191264 11255091200 1904270784 18.861 100 21 42 0 1920470272 9902064 6297424
14:13:26 8476 8192000000 10817813312 11255291904 1907181552 18.884 100 18 36 1 1917181728 5149664 4850512
14:13:41 7208 8192000000 10824536592 11258974208 1907075296 18.883 100 21 42 0 1918059104 5155808 5828000
14:13:55 10878 8192000000 10817026768 11252428800 1889937824 18.745 99 29 58 2 1906455808 6275440 10242544
14:14:14 5709 8192000000 10812745712 11253305344 1904829552 18.865 100 18 36 0 1915093056 5557968 4705536
14:14:26 6329 8192000000 10824581072 11258191872 1912740400 18.929 100 35 71 1 1928872848 6524144 9608304
14:14:41 6635 8192000000 10829296096 11262595072 1910515200 18.911 100 17 34 2 1921216752 5625776 5075776
14:14:54 7471 8192000000 10830227152 11266310144 1911772160 18.921 100 16 32 0 1922569008 6163152 4633696
14:15:08 6628 8192000000 10824003568 11265531904 1918930176 18.978 100 29 57 2 1932561824 5410576 8221072
14:15:21 9792 8192000000 10801413168 11238658048 1848646720 18.411 97 13 26 0 1861975472 9684448 3644304
14:15:38 9413 8192000000 10806489024 11242733568 1861053808 18.512 98 18 36 2 1871895904 6208976 4633120
14:15:54 8534 8192000000 10781302848 11215368192 1832246384 18.278 97 13 26 0 1841286944 5677984 3362576
14:16:09 12626 8192000000 10764271264 11194720256 1810321088 18.099 97 13 26 2 1819265584 5591136 3353360
14:16:34 15277 8192000000 10775672016 11192872960 1796030208 17.981 96 23 46 1 1808924464 5966720 6927536
14:16:56 62426 8192000000 10730299504 11150114816 1724272272 17.388 93 27 51 2 1735841872 4502848 7066752
14:18:05 6022 8192000000 10714512176 11138433024 1767750016 17.748 97 15 30 1 1777029360 5412256 3867088
14:18:18 9229 8192000000 10700381744 11125538816 1713365712 17.297 94 27 52 3 1726689056 5900896 7422448
14:18:35 9647 8192000000 10717466096 11138621440 1772275296 17.786 98 23 45 2 1784767696 5414080 7078320
14:18:56 6242 8192000000 10709497264 11122974720 1743393232 17.547 97 25 50 2 1757228672 6895616 6939824
14:19:11 6264 8192000000 10700410352 11122139136 1756232848 17.653 98 24 48 0 1769272656 6610704 6429104
14:19:24 6487 8192000000 10720652768 11129401344 1788003200 17.915 100 39 78 2 1806826000 7621920 11200880
14:19:39 6225 8192000000 10662987168 11072868352 1682674320 17.040 95 19 38 1 1693861936 5521424 5666192
14:19:51 7227 8192000000 10669396416 11072999424 1698089904 17.169 96 25 50 1 1710377376 5569216 6718256
14:20:06 9548 8192000000 10724148544 11130916864 1789305872 17.926 100 21 42 0 1801499792 5411696 6782224
14:20:24 10706 8192000000 10734504992 11148148736 1809577152 18.092 100 21 42 0 1822034448 5854208 6603088
14:20:45 11329 8192000000 10745106000 11163992064 1822730592 18.200 100 30 60 0 1837048000 5232880 9084528
14:21:05 14778 8192000000 10749142896 11170525184 1815210272 18.139 99 17 34 0 1825245264 5481920 4553072
14:21:28 16806 8192000000 10758062320 11176198144 1836900272 18.316 100 29 57 4 1850547824 5820400 7827152
14:21:51 67888 8192000000 10762561536 11189424128 1832158416 18.277 99 34 68 0 1847923312 5870640 9894256
14:23:09 9122 8192000000 10746801504 11173343232 1813053120 18.121 98 22 43 1 1828516912 9464944 5998848
14:23:24 8956 8192000000 10762139056 11192221696 1848931856 18.413 100 33 66 1 1869289312 11119776 9237680
14:23:41 7203 8192000000 10765252640 11199750144 1855285920 18.465 100 28 55 1 1869465088 6212048 7967120
14:23:57 10878 8192000000 10775922912 11205816320 1863523424 18.532 100 17 34 0 1874139152 5528448 5087280
14:24:14 7950 8192000000 10786744592 11215986688 1869435872 18.580 100 27 51 4 1886556432 9796928 7323632
14:24:31 7212 8192000000 10792866864 11220844544 1876811488 18.639 100 24 48 1 1890047696 5152576 8083632
14:24:47 11032 8192000000 10801144032 11225198592 1876732944 18.639 100 31 62 2 1895630608 10034112 8863552
14:25:04 12324 8192000000 10780077376 11217625088 1874340080 18.619 100 14 27 1 1884078800 5703616 4035104
14:25:23 11255 8192000000 10786847840 11225448448 1876311680 18.635 100 16 32 0 1889894960 9348304 4234976
14:25:44 8488 8192000000 10785367552 11222351872 1879943312 18.665 100 27 54 2 1894325072 6649488 7732272
14:26:01 15273 8192000000 10791761488 11226877952 1884365536 18.700 100 19 38 1 1894553696 5312512 4875648
14:26:28 13270 8192000000 10793431264 11226935296 1880955552 18.673 100 9 18 3 1889936688 5918048 3063088
14:26:50 22506 8192000000 10811264192 11238191104 1888765920 18.736 100 24 47 3 1900581088 5049824 6765344
14:27:18 62727 8192000000 10835730896 11263287296 1909729360 18.904 100 29 57 3 1922900448 4936704 8234384
14:28:32 3456 8192000000 10849448784 11263819776 1910673632 18.912 99 57 114 1 1934453296 8415088 15364576
14:28:44 34175 8192000000 10872146208 11291541504 1935852976 19.114 100 62 123 1 1963546096 10499184 17193936
14:29:26 2658 8192000000 10878530736 11300777984 1943048544 19.171 100 62 126 3 1972756816 12115008 17593264
14:29:36 12910 8192000000 10876520848 11306278912 1948475088 19.214 100 62 124 1 1977200112 11177488 17547536
14:30:02 5642 8192000000 10896047104 11312021504 1956283136 19.276 100 70 139 2 1988706464 13401344 19021984
14:30:15 25948 8192000000 10894132144 11317596160 1959010384 19.298 100 67 134 0 1992453600 13864096 19579120
14:30:53 10926 8192000000 10910092576 11328593920 1966567824 19.358 100 54 108 2 1994861504 13010176 15283504
14:31:10 26417 8192000000 10903537072 11316854784 1944655440 19.184 99 55 109 0 1974726480 14091840 15979200
14:31:52 6381 8192000000 10897965872 11318984704 1957980384 19.290 100 57 113 1 1990967568 16765952 16221232
14:32:06 6092 8192000000 10883603872 11301826560 1928162400 19.052 98 67 132 1 1964633744 16841344 19630000
14:32:25 4625 8192000000 10893785712 11325251584 1961711344 19.320 100 50 96 0 1992866032 16988656 14166032
14:32:37 2639 8192000000 10896806704 11313176576 1944387056 19.182 99 55 106 1 1977846240 17505936 15953248
14:32:46 8721 8192000000 10916590848 11329761280 1962382736 19.325 100 58 117 3 1998470656 19390864 16697056
14:33:04 9560 8192000000 10916421424 11338948608 1968073552 19.370 100 57 114 1 2004650320 19632352 16944416
14:33:26 5575 8192000000 10907024256 11336871936 1954493872 19.262 99 63 123 1 1995257232 21103200 19660160
14:33:44 11050 8192000000 10898239120 11326468096 1931598992 19.080 98 51 102 1 1965854480 17850432 16405056
14:34:04 9098 8192000000 10888173376 11323809792 1938062464 19.131 99 38 75 0 1967909408 18677376 11169568
14:34:23 19182 8192000000 10879399648 11311063040 1915512992 18.951 98 39 77 2 1943265264 16388800 11363472
14:34:53 9285 8192000000 10907514384 11332493312 1959109088 19.299 100 58 116 0 1994485408 18207264 17169056
14:35:09 3157 8192000000 10918673408 11340255232 1972659728 19.407 100 55 110 4 2007919808 18557664 16702416
14:35:20 3039 8192000000 10920258320 11334668288 1956055984 19.275 99 68 134 2 1994976256 19243040 19677232
14:35:30 2907 8192000000 10931412352 11345924096 1970881408 19.392 100 67 133 1 2011217584 19615648 20720528
14:35:40 13090 8192000000 10902508256 11328585728 1946920352 19.202 99 53 103 0 1983266112 19850464 16495296
14:36:04 1940 8192000000 10933060144 11343785984 1970140592 19.387 100 82 163 2 2017472592 22676464 24655536
14:36:13 7262 8192000000 10905657360 11334656000 1960700080 19.312 100 58 116 2 2002406368 23591072 18115216
14:36:29 3657 8192000000 10900497312 11323285504 1940656320 19.152 99 53 106 1 1982125744 24845728 16623696
14:36:43 4265 8192000000 10910582432 11322294272 1931230448 19.077 99 56 111 0 1974954976 26696192 17028336
14:36:54 9508 8192000000 10904181440 11324633088 1944518464 19.183 100 63 126 1 1991674464 27647248 19508752
14:37:23 7763 8192000000 10913287872 11338850304 1957374992 19.285 100 53 106 2 2001570304 28223152 15972160
14:37:38 12601 8192000000 10922765584 11351957504 1968328512 19.372 100 54 108 3 2013833648 28936752 16568384
14:37:59 2117 8192000000 10940114256 11363500032 1978931440 19.456 100 59 118 0 2025370352 27675536 18763376
14:38:08 2160 8192000000 10926245664 11339628544 1956544704 19.279 99 64 126 2 2004967360 28749424 19673232
14:38:16 2281 8192000000 10926757488 11343065088 1961733200 19.320 100 75 148 1 2014205792 30273056 22199536
14:38:26 1149 8192000000 10922268832 11327590400 1936609328 19.120 99 89 178 1 1991815632 29206368 25999936
14:38:34 1707 8192000000 10907357232 11320713216 1943226752 19.172 100 87 165 1 1996543552 28576448 24740352
14:38:45 2607 8192000000 10904182144 11314966528 1925804288 19.033 99 75 150 0 1977742176 29436496 22501392
14:38:55 4124 8192000000 10917620288 11325517824 1950891680 19.234 100 87 172 1 2003489504 26931440 25666384
14:39:06 16080 8192000000 10882642800 11311521792 1922916064 19.010 99 60 119 2 1968661824 28121776 17623984
14:39:34 7823 8192000000 10882276000 11300466688 1915896768 18.954 99 60 118 1 1962219088 28545680 17776640
14:39:49 3526 8192000000 10892615040 11308388352 1929721408 19.065 100 62 123 1 1976467280 28568064 18177808
14:40:01 2856 8192000000 10920924592 11336486912 1954495696 19.262 100 73 144 1 2005222816 28472960 22254160
14:40:20 1650 8192000000 10921254784 11333373952 1954994800 19.266 100 78 156 2 2007378064 29291888 23091376
14:40:29 2867 8192000000 10920746256 11327418368 1948786320 19.217 100 78 153 2 2003452832 31432848 23233664
14:40:42 8718 8192000000 10909697088 11335954432 1951767008 19.241 100 48 96 2 1998572672 31764496 15041168
14:41:02 4939 8192000000 10912129680 11334307840 1950016912 19.227 100 54 108 2 1997203840 30987312 16199616
14:41:15 4302 8192000000 10923407136 11345301504 1961476992 19.318 100 49 97 1 2007641616 31304960 14859664
14:41:28 8542 8192000000 10926459056 11350790144 1961250384 19.316 100 47 93 1 2009656576 33477056 14929136
14:41:44 2730 8192000000 10940291792 11363459072 1973666016 19.415 100 55 109 2 2025675712 34303504 17706192
14:41:56 2538 8192000000 10915868448 11327102976 1925646320 19.032 98 71 141 1 1982611632 35096944 21868368
14:42:06 2593 8192000000 10938568144 11344478208 1960239824 19.308 100 79 152 3 2015159312 30694144 24225344
14:42:18 2852 8192000000 10921142544 11340083200 1941152368 19.156 99 76 152 2 1999236480 34647744 23436368
14:42:35 15702 8192000000 10912768608 11350081536 1954345136 19.261 100 33 66 1 1998727072 33542128 10839808
14:43:10 4495 8192000000 10910351808 11337658368 1951855984 19.241 100 52 104 0 2004737520 36712144 16169392
14:43:25 4588 8192000000 10916831936 11336736768 1933224608 19.093 99 52 103 5 1987496208 37767808 16503792
14:43:43 3883 8192000000 10935163520 11346501632 1948938992 19.218 99 74 148 1 2015789536 43777760 23072784
14:43:59 3370 8192000000 10970221952 11381784576 1978875840 19.456 100 86 170 2 2053623520 48460752 26286928
14:44:09 2416 8192000000 10981364864 11389173760 1981279952 19.475 100 90 180 2 2060118256 50623760 28214544
14:44:18 3849 8192000000 10980061328 11391791104 1982912528 19.488 100 80 159 2 2058954416 51545008 24496880
14:44:33 4991 8192000000 10973008672 11395805184 1984736512 19.502 100 67 134 0 2059047648 52654384 21656752
14:44:44 3146 8192000000 10954781152 11391553536 1979753136 19.463 100 48 96 0 2042348992 47125744 15470112
14:44:54 15535 8192000000 10963418880 11396952064 1984214896 19.498 100 43 86 1 2045233168 46651472 14366800
14:45:17 12013 8192000000 10953349888 11398139904 1981714384 19.478 100 32 64 1 2038840960 46360416 10766160
14:45:36 8695 8192000000 10942688512 11378536448 1951099104 19.235 99 40 80 0 2015276912 50380112 13797696
14:45:55 11865 8192000000 10960660864 11400773632 1978106816 19.450 100 38 76 0 2038324624 47057424 13160384
14:46:14 4667 8192000000 10965694992 11408764928 1986070800 19.513 100 42 82 0 2053954736 53994304 13889632
14:46:27 9198 8192000000 10978005696 11418062848 1987880208 19.527 100 45 90 2 2059827072 56526336 15420528
14:46:48 25444 8192000000 10955012464 11408707584 1992598688 19.564 100 32 64 0 2067627120 63149600 11878832
14:47:29 17363 8192000000 10954351632 11410735104 1988503472 19.532 100 26 52 2 2036064960 38801680 8759808
14:48:11 33763 8192000000 10933138016 11393261568 1951034032 19.235 98 24 48 1 1996547296 38232912 7280352
14:49:13 22226 8192000000 10918001760 11376996352 1944526176 19.183 99 16 32 0 1991138768 40885152 5727440
14:49:42 37731 8192000000 10926512512 11392622592 1959958768 19.306 100 16 31 1 2011196592 45080176 6157648
14:50:26 28012 8192000000 10918627728 11382140928 1977585840 19.446 100 21 41 2 2007459216 23970976 5902400
14:51:02 48399 8192000000 10934307168 11381739520 1977869312 19.448 100 14 28 0 2007912704 25429536 4613856
14:52:04 48509 8192000000 10916594784 11370577920 1976553712 19.437 100 39 78 1 2005721856 17634592 11533552
14:52:59 69619 8192000000 10881610304 11360841728 1953891728 19.257 99 16 32 1 1973320336 13934976 5493632
14:54:32 89663 8192000000 10883075920 11353591808 1901839744 18.841 97 12 23 0 1917474288 13001360 2633184
14:56:08 80138 8192000000 10891936112 11366711296 1960280688 19.308 100 16 32 2 1978717664 13960400 4476576
14:57:37 107329 8192000000 10923181584 11373142016 1961351280 19.317 99 27 54 0 1985987232 17180848 7455104
14:59:38 65174 8192000000 10931121232 11361652736 1960423424 19.309 99 47 93 1 1984135904 10287584 13424896
15:00:49 8361 8192000000 10902004800 11353284608 1974803104 19.424 100 55 107 1 1998433088 8347584 15282400
15:01:17 68849 8192000000 10936703328 11385421824 1991499120 19.556 100 24 47 2 2005712608 7258160 6955328
15:02:45 82345 8192000000 10960664368 11406651392 2011626416 19.714 100 28 56 1 2029686320 9743648 8316256
15:04:34 13743 8192000000 10931361840 11403194368 2011752160 19.715 100 32 64 0 2035666336 14221456 9692720
15:04:55 67280 8192000000 10915240176 11383328768 1965631696 19.351 98 25 50 0 1984838832 11174752 8032384
15:06:11 34356 8192000000 10939425520 11403288576 1999650704 19.620 100 14 28 0 2010996416 7305696 4040016
15:06:59 59351 8192000000 10917781392 11386847232 1982648720 19.486 99 18 36 1 2000823488 12854432 5320336
15:08:49 54498 8192000000 10918582992 11397971968 1999660528 19.620 100 15 30 1 2019890480 15673856 4556096
15:09:50 72039 8192000000 10898775248 11382439936 1965499520 19.350 98 22 44 1 1991715984 18954704 7261760
15:11:09 53272 8192000000 10908636432 11386433536 1961782272 19.320 98 14 28 1 1982915376 17576768 3556336
15:12:13 55009 8192000000 10915559616 11388850176 1966680960 19.359 99 11 22 0 1985587536 15677616 3228960
15:13:25 92450 8192000000 10898994656 11387490304 1948335904 19.213 98 9 18 0 1967177104 15988800 2852400
15:15:04 50687 8192000000 10905427104 11377590272 1948418880 19.214 98 27 54 0 1964491472 7399376 8673216
15:16:12 48642 8192000000 10913190944 11381325824 1951863760 19.241 98 17 34 0 1966011856 9231664 4916432
15:17:11 57434 8192000000 10910984336 11383353344 1952287824 19.245 98 21 41 0 1971186912 13109488 5789600
15:18:46 38306 8192000000 10923495168 11382411264 1953377328 19.253 98 22 44 1 1972588592 12919984 6291280
15:19:30 52843 8192000000 10906988016 11376340992 1950477552 19.230 98 28 56 0 1971488000 12553360 8457088
15:20:30 52698 8192000000 10930226352 11390484480 1974216768 19.419 99 26 52 1 1994124240 12395120 7512352
15:21:52 22190 8192000000 10887606928 11344969728 1932258144 19.085 98 29 58 1 1951856608 11637056 7961408
15:22:32 17146 8192000000 10887294176 11351953408 1958225760 19.292 100 44 88 0 1981101056 10309184 12566112
15:22:58 56319 8192000000 10881603856 11353645056 1910417104 18.910 97 18 36 1 1925635648 10332160 4886384
15:24:02 34924 8192000000 10867013904 11319422976 1893569936 18.775 97 23 46 0 1914333200 14495616 6267648
15:24:49 60280 8192000000 10881748928 11365064704 1926104064 19.036 99 20 40 0 1951072080 19087808 5880208
15:25:55 38593 8192000000 10891392256 11331465216 1892297232 18.764 96 30 59 3 1908107696 8106208 7704256
15:26:40 40034 8192000000 10874990928 11317641216 1894366560 18.781 97 41 82 1 1916554336 10651232 11536544
15:27:38 110524 8192000000 10857616720 11325235200 1922199296 19.004 99 28 56 0 1938512288 9048400 7264592
15:29:35 31532 8192000000 10801714512 11247849472 1827632096 18.240 95 12 25 0 1836394048 5828960 2932992
15:30:31 52869 8192000000 10855984320 11304648704 1896192432 18.796 99 38 76 0 1918571136 11746816 10631888
15:31:31 52670 8192000000 10813116160 11290804224 1868093120 18.569 98 14 28 1 1884364144 12504288 3766736
15:32:30 22221 8192000000 10819709584 11298422784 1883555728 18.694 99 9 18 1 1895438192 9316080 2566384
15:33:09 44154 8192000000 10854012832 11319115776 1929627808 19.064 100 12 24 0 1943896784 10896848 3372128
15:34:17 73387 8192000000 10850582432 11320520704 1880938720 18.673 97 15 30 1 1893201296 8340080 3922496
15:35:41 47851 8192000000 10804556496 11256840192 1837122816 18.317 96 13 23 3 1846622384 6913520 2586048
15:36:37 11318 8192000000 10833662768 11288215552 1912232384 18.925 100 33 66 0 1928906048 7187568 9486096
15:36:57 26797 8192000000 10855667984 11314892800 1921108144 18.996 100 25 50 0 1938116800 10120320 6888336
15:37:40 55222 8192000000 10875861008 11343867904 1940311184 19.149 100 21 42 1 1965295584 19154192 5830208
15:38:42 70091 8192000000 10874924320 11338964992 1890583856 18.750 97 24 48 2 1920071936 21851872 7636208
15:40:04 57048 8192000000 10869168752 11335565312 1918227840 18.973 99 18 36 1 1943992976 20066416 5698720
15:41:30 38056 8192000000 10880572192 11341946880 1946809968 19.201 100 16 31 1 1963242864 11921184 4511712
15:42:19 60806 8192000000 10876933584 11344371712 1917211168 18.964 98 20 40 0 1937495984 14780592 5504224
15:43:34 85264 8192000000 10876183840 11331743744 1874151952 18.618 96 18 36 1 1894935664 15703760 5079952
15:45:08 19557 8192000000 10917092048 11356024832 1959187232 19.300 100 48 95 1 1982273584 9678544 13407808
15:45:33 59722 8192000000 10894504432 11359436800 1958541840 19.294 100 27 54 0 1979179776 13102512 7535424
15:46:45 11986 8192000000 10911093600 11352924160 1963678896 19.335 100 44 88 2 1982791488 6786736 12325856
15:47:05 41443 8192000000 10912050512 11364139008 1971731136 19.399 100 40 80 4 1994536544 11957184 10848224
15:47:55 96898 8192000000 10917565360 11371982848 1978220640 19.451 100 34 68 1 1999643680 11849056 9573984
15:49:44 61056 8192000000 10909039760 11377123328 1958376448 19.293 99 20 40 0 1973629408 10098640 5154320
15:52:14 57930 8192000000 10865949424 11349352448 1942147152 19.164 99 7 14 0 1952000304 7945872 1907280
15:53:31 51160 8192000000 10877352432 11356459008 1963000256 19.330 100 8 16 2 1972663600 7537904 2125440
15:54:33 29927 8192000000 10876683360 11348541440 1927821600 19.049 98 14 28 1 1937798672 6261072 3716000
15:55:15 73239 8192000000 10863950752 11342213120 1866367040 18.555 95 17 34 0 1879505632 8032992 5105600
15:57:05 80435 8192000000 10884611552 11347484672 1893019744 18.770 96 20 40 1 1909712160 11462528 5229888
15:58:35 103572 8192000000 10922219920 11384520704 1953088992 19.251 99 14 28 0 1968873008 11978624 3805392
16:00:25 98169 8192000000 10905174528 11381624832 1920672368 18.992 97 14 28 0 1940362032 15944256 3745408
16:02:09 55702 8192000000 10884928800 11349766144 1876735456 18.639 95 14 28 0 1889307552 8905200 3666896
16:03:13 36478 8192000000 10916393920 11357278208 1914230176 18.941 97 39 78 4 1939185248 12532224 12422848
16:03:56 50940 8192000000 10888734912 11359731712 1925982896 19.035 98 15 30 2 1942616640 12570128 4063616
16:04:57 65551 8192000000 10885907552 11353796608 1904745952 18.864 97 11 22 1 1917197888 9474688 2977248
16:06:11 96625 8192000000 10862092448 11328430080 1856498976 18.475 95 9 17 1 1867897632 9262320 2136336
16:07:55 55876 8192000000 10889054864 11341742080 1914903664 18.946 98 21 42 1 1928834016 8428816 5501536
16:08:57 31062 8192000000 10872565968 11332227072 1894315296 18.781 97 18 36 3 1908476432 8645104 5516032
16:09:37 59434 8192000000 10857053728 11321896960 1885468048 18.709 97 15 30 1 1900992176 10435504 5088624
16:11:21 60702 8192000000 10852757648 11310706688 1901004048 18.834 98 24 46 4 1914628352 6530000 7094304
16:12:44 53535 8192000000 10828798832 11301883904 1878003120 18.649 97 19 38 0 1891322704 7314720 6004864
16:13:45 61343 8192000000 10831000752 11312197632 1886001328 18.714 98 9 18 0 1900105008 11679616 2424064
16:14:56 41063 8192000000 10829643312 11299205120 1888011328 18.730 98 8 17 0 1901700976 11236752 2452896
16:15:44 50522 8192000000 10845966304 11306356736 1890378864 18.749 98 13 26 0 1905165392 11371104 3415424
16:17:50 46203 8192000000 10849512832 11315150848 1876279632 18.635 97 16 31 2 1894791472 14118640 4393200
16:18:42 64472 8192000000 10822234720 11289935872 1822433856 18.198 95 13 26 0 1839801776 13281584 4086336
16:19:53 57406 8192000000 10851909264 11318509568 1909728640 18.904 99 17 34 2 1924745312 9800112 5216560
16:20:57 52114 8192000000 10840074528 11299622912 1864162880 18.537 96 15 30 1 1881106688 12204320 4739488
16:21:55 49917 8192000000 10861741408 11322658816 1893745888 18.776 98 20 40 2 1914178320 15005680 5426752
16:23:23 56828 8192000000 10886600096 11329191936 1904633744 18.864 99 23 46 1 1924927584 13818944 6474896
16:24:27 45085 8192000000 10878060720 11333558272 1900982096 18.834 98 42 83 2 1932622640 19960880 11679664
16:25:21 70558 8192000000 10887353824 11339513856 1932404448 19.086 99 27 54 0 1953070176 13463488 7202240
16:26:41 39498 8192000000 9847030480 10205544448 973721232 10.623 50 17 32 1 988119136 9847136 4550768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 16-12-2020 16:28:24 to 16-12-2020 16:28:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 104 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-12-2020 16:28:55 to 16-12-2020 16:28:57.

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          253097
MON$OLDEST_ACTIVE               255929
MON$OLDEST_SNAPSHOT             255929
MON$NEXT_TRANSACTION            255929
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                       2027680
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:162: 
:163: mscs-test-161.budzdorov.ru    Wed Dec 16 16:27:33 2020
:164:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:165: 
--- end of diff output ---

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

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