Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.11.2020 16:29
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 17625600 kB
MemAvailable 31534044 kB
Buffers 0 kB
Cached 14106892 kB
SwapCached 4780 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-11-19 16:27:07
DTS_END                         2020-11-19 16:27:07.8670
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/43504
TRN_ID                          234668
ATT_ID                          669
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: 8955.25 19498 1074630
customer order: creation 169.95 396 20394
customer order: refuse 14.30 358 1716
order to supplier: creation 45.19 1415 5423
order to supplier: removal 3.46 103427 415
invoice (draft): creation 44.25 3741 5310
invoice (draft): removal 50.76 960 6091
invoice accept: apply 40.63 20500 4875
invoice accept: cancel 45.64 917 5477
customer reserve: creation 3723.07 205 446768
customer reserve: removal 4525.33 61 543039
realization accept: apply 84.09 184 10091
realization accept: cancel 81.51 113 9781
payment from customer: creation 58.24 122 6989
payment from customer: removal 5.06 86 607
payment to supplier: creation 47.78 129 5733
payment to supplier: removal 3.30 78 396
service: total inventory turnovers 4.87 1145 584
service: total monetary turnovers 6.99 28 839
service: aggregate perf. data 0.82 22361 98
service: refresh index statistics 0.03 233730 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-11-2020 16:29:36 to 19-11-2020 16:29:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8876
TEST_TIME 2 7721
TEST_TIME 3 5703
TEST_TIME 4 5371
TEST_TIME 5 5963
TEST_TIME 6 6729
TEST_TIME 7 6707
TEST_TIME 8 6546
TEST_TIME 9 6369
TEST_TIME 10 6850
TEST_TIME 11 7011
TEST_TIME 12 6942
TEST_TIME 13 7185
TEST_TIME 14 7217
TEST_TIME 15 7274
TEST_TIME 16 7413
TEST_TIME 17 7533
TEST_TIME 18 7603
TEST_TIME 19 7834
TEST_TIME 20 8189
TEST_TIME 21 8105
TEST_TIME 22 8054
TEST_TIME 23 8345
TEST_TIME 24 8468
TEST_TIME 25 8715
TEST_TIME 26 8708
TEST_TIME 27 8988
TEST_TIME 28 9481
TEST_TIME 29 9812
TEST_TIME 30 10429
TEST_TIME 31 10509
TEST_TIME 32 10525
TEST_TIME 33 10416
TEST_TIME 34 10309
TEST_TIME 35 10041
TEST_TIME 36 9965
TEST_TIME 37 9861
TEST_TIME 38 9696
TEST_TIME 39 9480
TEST_TIME 40 9460
TEST_TIME 41 9336
TEST_TIME 42 9341
TEST_TIME 43 9374
TEST_TIME 44 9359
TEST_TIME 45 9308
TEST_TIME 46 9291
TEST_TIME 47 9169
TEST_TIME 48 9000
TEST_TIME 49 8914
TEST_TIME 50 8894
TEST_TIME 51 8912
TEST_TIME 52 8884
TEST_TIME 53 8812
TEST_TIME 54 8660
TEST_TIME 55 8750
TEST_TIME 56 8758
TEST_TIME 57 8725
TEST_TIME 58 8806
TEST_TIME 59 8817
TEST_TIME 60 8765
TEST_TIME 61 8790
TEST_TIME 62 8918
TEST_TIME 63 8953
TEST_TIME 64 9034
TEST_TIME 65 8978
TEST_TIME 66 9126
TEST_TIME 67 9138
TEST_TIME 68 9141
TEST_TIME 69 9201
TEST_TIME 70 9264
TEST_TIME 71 9281
TEST_TIME 72 9205
TEST_TIME 73 9140
TEST_TIME 74 9048
TEST_TIME 75 9047
TEST_TIME 76 9017
TEST_TIME 77 9005
TEST_TIME 78 8967
TEST_TIME 79 8940
TEST_TIME 80 8867
TEST_TIME 81 8868
TEST_TIME 82 8872
TEST_TIME 83 8862
TEST_TIME 84 8888
TEST_TIME 85 8905
TEST_TIME 86 8896
TEST_TIME 87 8932
TEST_TIME 88 8923
TEST_TIME 89 8866
TEST_TIME 90 8985
TEST_TIME 91 8991
TEST_TIME 92 9021
TEST_TIME 93 9037
TEST_TIME 94 9011
TEST_TIME 95 9008
TEST_TIME 96 9029
TEST_TIME 97 9016
TEST_TIME 98 8967
TEST_TIME 99 8937
TEST_TIME 100 8961
TEST_TIME 101 8901
TEST_TIME 102 8881
TEST_TIME 103 8844
TEST_TIME 104 8842
TEST_TIME 105 8828
TEST_TIME 106 8816
TEST_TIME 107 8831
TEST_TIME 108 8838
TEST_TIME 109 8926
TEST_TIME 110 8906
TEST_TIME 111 8887
TEST_TIME 112 8933
TEST_TIME 113 8880
TEST_TIME 114 8987
TEST_TIME 115 8998
TEST_TIME 116 8993
TEST_TIME 117 8976
TEST_TIME 118 9056
TEST_TIME 119 9039
TEST_TIME 120 8964

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-11-2020 16:29:40 to 19-11-2020 16:29:43.

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 1488245 1488245 0 0.00 0 30185 7 0 0
doc_list_biud 1488243 1488243 0 0.00 0 67198 29 0 0
sp_add_invoice_to_stock 4968 4875 93 1.87 23 215476 20500 0 93
sp_cancel_adding_invoice 5477 5477 0 0.00 4 71753 918 0 0
sp_cancel_client_order 1716 1716 0 0.00 4 11279 359 0 0
sp_cancel_customer_reserve 543039 543039 0 0.00 1 67200 61 0 0
sp_cancel_pay_from_customer 607 607 0 0.00 3 5494 87 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 3 1694 79 0 0
sp_cancel_supplier_invoice 6095 6091 4 0.06 2 22020 960 0 4
sp_cancel_supplier_order 415 415 0 0.00 7 1024621 103427 0 0
sp_cancel_write_off 9781 9781 0 0.00 1 10516 113 0 0
sp_client_order 20394 20394 0 0.00 3 27537 396 0 0
sp_customer_reserve 446768 446768 0 0.00 0 45318 206 0 0
sp_fill_shopping_cart 31122 31122 0 0.00 1 21752 42 0 0
sp_fill_shopping_cart_clo_res 446757 446757 0 0.00 0 13526 14 0 0
sp_get_clo_for_invoice 4864 4864 0 0.00 0 27710 333 0 0
sp_kill_cost_storno 16261 16261 0 0.00 0 30176 64 0 0
sp_kill_qstorno_ret_qs2qd 1102365 1102365 0 0.00 0 67192 34 0 0
sp_kill_qty_storno 581474 581474 0 0.00 0 67198 73 0 0
sp_lock_selected_doc 20457 20457 0 0.00 0 5805 5 0 0
sp_make_cost_storno 27677 27677 0 0.00 0 17333 53 0 0
sp_multiply_rows_for_pdistr 27677 27677 0 0.00 0 21599 32 0 0
sp_multiply_rows_for_qdistr 20394 20394 0 0.00 0 24936 156 0 0
sp_pay_from_customer 6989 6989 0 0.00 4 21542 123 0 0
sp_pay_to_supplier 5733 5733 0 0.00 5 24954 130 0 0
sp_payment_common 12722 12722 0 0.00 1 21534 41 0 0
sp_qd_handle_on_cancel_clo 1716 1716 0 0.00 0 9280 324 0 0
sp_qd_handle_on_invoice_upd_sts 10341 10341 0 0.00 0 21546 364 0 0
sp_qd_handle_on_reserve_upd_sts 10091 10091 0 0.00 0 13750 57 0 0
sp_reserve_write_off 10091 10091 0 0.00 6 21687 184 0 0
sp_supplier_invoice 5310 5310 0 0.00 8 80301 3742 0 0
sp_supplier_order 5423 5423 0 0.00 5 36235 1415 0 0
srv_aggregate_perf_data 98 98 0 0.00 2433 268913 22362 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 1217 147829 29966 0 0
srv_find_qd_qs_mism 1028001 1028001 0 0.00 0 19090 6 0 0
srv_make_invnt_saldo 584 584 0 0.00 45 106200 1146 0 0
srv_make_money_saldo 839 839 0 0.00 0 771 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 111222 325335 233731 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4876 4876 0 0.00 0 21474 184 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 0 4193 104 0 0
t$perf-norm:sp_cancel_client_order 1716 1716 0 0.00 0 6695 19 0 0
t$perf-norm:sp_cancel_customer_reserve 642 642 0 0.00 0 21342 49 0 0
t$perf-norm:sp_cancel_pay_from_customer 607 607 0 0.00 0 2265 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 547 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 378 378 0 0.00 0 604 12 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 21194 1639 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 2901 10 0 0
t$perf-norm:sp_client_order 20394 20394 0 0.00 0 21700 19 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 1935 8 0 0
t$perf-norm:sp_pay_from_customer 6989 6989 0 0.00 0 22248 22 0 0
t$perf-norm:sp_pay_to_supplier 5733 5733 0 0.00 0 8581 12 0 0
t$perf-norm:sp_reserve_write_off 10091 10091 0 0.00 0 19350 11 0 0
t$perf-norm:sp_supplier_invoice 5310 5310 0 0.00 0 10189 19 0 0
t$perf-norm:sp_supplier_order 5423 5423 0 0.00 0 8852 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 254 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 1272 12 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 2365 36 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 2041 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 9912 9726 186 1.87 0 4073 16 0 186
v_all_customers 36962 36962 0 0.00 0 33 1 0 0
v_all_suppliers 29626 29626 0 0.00 0 117 1 0 0
v_all_wares 40784 40784 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 958 7 0 0
v_cancel_client_order 3432 3432 0 0.00 0 10904 6 0 0
v_cancel_customer_prepayment 1214 1214 0 0.00 0 325 3 0 0
v_cancel_customer_reserve 1284 1284 0 0.00 0 1166 6 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 1486 6 0 0
v_cancel_supplier_invoice 764 756 8 1.04 0 822 14 0 8
v_cancel_supplier_order 830 830 0 0.00 0 353 3 0 0
v_cancel_write_off 1926 1926 0 0.00 0 5719 17 0 0
v_max_id_clo_ord 5420 5420 0 0.00 0 2933 2 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 2761 18 0 0
v_max_id_ord_sup 5309 5309 0 0.00 0 4286 5 0 0
v_max_non_paid_invoice 1649 1649 0 0.00 0 2481 4 0 0
v_max_non_paid_realizn 3763 3763 0 0.00 0 1159 3 0 0
v_min_id_clo_ord 5420 5420 0 0.00 0 4264 6 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 2888 9 0 0
v_min_id_ord_sup 5309 5309 0 0.00 0 5540 8 0 0
v_min_non_paid_invoice 5733 5733 0 0.00 0 21525 22 0 0
v_min_non_paid_realizn 6989 6989 0 0.00 0 21526 32 0 0
v_our_firm 10274 10274 0 0.00 0 19 1 0 0
v_reserve_write_off 20182 20182 0 0.00 0 5106 5 0 0
x_lock_depdocs_on_canc_invoice 11190 11190 0 0.00 0 25378 137 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 11922 333 0 0
x_make_qstorno_1000_1200 5423 5423 0 0.00 1 36217 1327 0 0
x_make_qstorno_1200_2000 5310 5310 0 0.00 4 80287 3587 0 0
x_make_qstorno_2100_3300 446768 446768 0 0.00 0 45316 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-11-2020 16:29:44 to 19-11-2020 16:29:48.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:17 9193 8192000000 10176635792 10472026112 802901856 8.926 65 54 109 0 824054144 2203040 18949248
13:57:41 33011 8192000000 10343721344 10660773888 1367894528 14.308 100 84 168 0 1400022416 4624240 27503648
13:58:25 33184 8192000000 10385234480 10707259392 1428641168 14.849 100 86 172 0 1463210960 6382800 28186992
13:59:09 24567 8192000000 10411437616 10735886336 1456488880 15.095 100 91 182 0 1494303552 7925312 29889360
13:59:41 23941 8192000000 10422217216 10749788160 1471188208 15.224 100 85 170 0 1506475152 8147936 27139008
14:00:15 28704 8192000000 10436428112 10770829312 1490628688 15.394 100 91 182 0 1528900144 9064992 29206464
14:00:56 26552 8192000000 10458556640 10795806720 1512266512 15.583 100 87 174 3 1549648240 9469216 27912512
14:01:36 17993 8192000000 10479780496 10822557696 1534276304 15.774 100 85 170 1 1571007616 10317328 26413984
14:02:04 14471 8192000000 10508608032 10858180608 1567371904 16.060 100 86 172 1 1603590736 10302896 25915936
14:02:32 13114 8192000000 10542336832 10897076224 1598558240 16.327 100 75 151 0 1631766736 11069584 22138912
14:02:56 9044 8192000000 10557858448 10916700160 1619623904 16.507 100 79 159 0 1654751712 11729104 23398704
14:03:19 9655 8192000000 10588134752 10950660096 1642918064 16.704 100 80 160 2 1678490112 12131712 23440336
14:03:36 9323 8192000000 10597561568 10962284544 1663242464 16.876 100 83 164 0 1699274288 11899472 24132352
14:03:52 10044 8192000000 10617267376 10984062976 1677523568 16.997 100 78 156 0 1712139472 11603104 23012800
14:04:10 7168 8192000000 10630552528 11004813312 1689113376 17.094 100 72 142 1 1721743968 11491504 21139088
14:04:24 13169 8192000000 10655599200 11027333120 1710297168 17.271 100 79 160 1 1745177488 12414144 22466176
14:04:44 5333 8192000000 10666816224 11040219136 1726358736 17.405 100 79 159 2 1762190720 13544928 22287056
14:04:59 7319 8192000000 10697674032 11070672896 1748647104 17.590 100 83 163 1 1784785072 13318560 22819408
14:05:14 5877 8192000000 10697437424 11078127616 1766057520 17.734 100 86 167 3 1802592992 13105696 23429776
14:05:26 5333 8192000000 10721390640 11097677824 1773267600 17.794 100 88 172 3 1810974640 13086848 24620192
14:05:39 4535 8192000000 10723555824 11105779712 1781273712 17.860 100 83 166 1 1818581488 14292352 23015424
14:05:50 4012 8192000000 10733124608 11116212224 1792879696 17.955 100 85 171 0 1831499760 14292192 24327872
14:06:00 3535 8192000000 10734215168 11117305856 1793373840 17.960 100 83 166 1 1830305360 14087920 22843600
14:06:10 2974 8192000000 10745057824 11125354496 1800842912 18.021 100 86 172 1 1839038224 14333616 23861696
14:06:21 2899 8192000000 10742712832 11128553472 1804410464 18.050 100 82 163 0 1840892144 14328112 22153568
14:06:31 2821 8192000000 10754707120 11137249280 1809139152 18.089 100 92 181 0 1849917808 15813728 24964928
14:06:40 10824 8192000000 10752981680 11138252800 1811818208 18.111 100 83 164 0 1849999504 15873504 22307792
14:06:58 2538 8192000000 10762137744 11150082048 1815169776 18.138 100 84 168 2 1853695712 15244384 23281552
14:07:07 2798 8192000000 10768060288 11154321408 1830405632 18.263 100 88 175 2 1869704464 14109280 25189552
14:07:16 1709 8192000000 10782381568 11165933568 1833089136 18.285 100 89 177 4 1870260976 12328848 24842992
14:07:24 3048 8192000000 10779997408 11175895040 1845220368 18.383 100 82 164 0 1881316192 12928368 23167456
14:07:34 2204 8192000000 10791583504 11183157248 1850650016 18.427 100 91 180 3 1888650448 11797040 26203392
14:07:43 2211 8192000000 10805809584 11193282560 1855843168 18.470 100 91 183 2 1893364880 12448448 25073264
14:07:51 1788 8192000000 10814484736 11200638976 1864459920 18.539 100 96 191 0 1904656992 13122928 27074144
14:08:00 1169 8192000000 10808439808 11200892928 1867891808 18.567 100 93 186 0 1907032032 12841696 26298528
14:08:07 2431 8192000000 10812061984 11202859008 1872783312 18.607 100 90 180 1 1911322400 13160992 25378096
14:08:16 1936 8192000000 10816313328 11206660096 1869578256 18.581 100 89 178 2 1908406432 13507872 25320304
14:08:24 2076 8192000000 10821503024 11211939840 1872171392 18.602 100 91 182 1 1913107456 15088640 25847424
14:08:33 2123 8192000000 10825612768 11215396864 1878461536 18.653 100 91 183 1 1917959120 13563760 25933824
14:08:41 3835 8192000000 10819360320 11213791232 1877777456 18.647 100 86 172 1 1915844800 13776720 24290624
14:08:52 2268 8192000000 10822146944 11215630336 1879161312 18.658 100 91 183 1 1916805664 12068976 25575376
14:09:01 6420 8192000000 10815005328 11212795904 1879348112 18.660 100 73 145 3 1911413744 12166656 19898976
14:09:14 1320 8192000000 10827613264 11221041152 1883698288 18.695 100 88 176 0 1921532864 12219088 25615488
14:09:21 47035 8192000000 10796160032 11214872576 1880680896 18.671 100 36 73 2 1898404960 7683232 10040832
14:10:15 8998 8192000000 10790785760 11220307968 1879128896 18.658 100 22 44 0 1896584224 11511040 5944288
14:10:35 6915 8192000000 10784839568 11216232448 1884361280 18.700 100 35 70 0 1902139280 8370656 9407344
14:10:49 7583 8192000000 10794818528 11222798336 1881820432 18.680 100 15 30 0 1891797424 5935840 4041152
14:11:03 6293 8192000000 10794603344 11222929408 1887856144 18.728 100 27 54 1 1900837072 5760928 7220000
14:11:18 12688 8192000000 10784527216 11224948736 1884778992 18.704 100 13 26 4 1894616832 6506176 3331664
14:11:41 11029 8192000000 10794309776 11231846400 1890793840 18.752 100 16 30 3 1900951648 5734176 4423632
14:11:59 10167 8192000000 10786777104 11229446144 1891473984 18.758 100 20 38 3 1902689120 5799328 5415808
14:12:17 8348 8192000000 10799465056 11237445632 1899019232 18.818 100 25 48 3 1912696272 6250944 7426096
14:12:32 15310 8192000000 10805466672 11239546880 1895611808 18.791 100 12 24 0 1904123904 5332368 3179728
14:12:53 13226 8192000000 10797717264 11237715968 1901020560 18.835 100 14 27 0 1909945824 5374336 3550928
14:13:13 16668 8192000000 10806953984 11239026688 1895428448 18.790 100 13 26 0 1905548992 6645344 3475200
14:13:35 10384 8192000000 10804555824 11241680896 1900449760 18.830 100 17 34 1 1911600848 6771344 4379744
14:13:54 8895 8192000000 10799274096 11241283584 1900583552 18.831 100 16 32 1 1911691520 6061312 5046656
14:14:15 2345 8192000000 10831367040 11253596160 1911491232 18.919 100 57 110 0 1934103072 5347104 17264736
14:14:24 72117 8192000000 10812161392 11241304064 1868974768 18.576 98 42 82 3 1885584256 5810384 10799104
14:15:42 6572 8192000000 10819387280 11254181888 1898323040 18.813 100 40 80 0 1922069248 12966528 10779680
14:15:55 9298 8192000000 10816182272 11254132736 1899203648 18.820 100 27 54 1 1913589456 7047760 7338048
14:16:11 4143 8192000000 10806505232 11234349056 1867796432 18.566 98 32 65 0 1883603776 7074352 8732992
14:16:22 6040 8192000000 10817468992 11249999872 1896433328 18.798 100 21 42 0 1908380528 6091552 5855648
14:16:34 6177 8192000000 10822759504 11256967168 1901531328 18.839 100 35 70 0 1919105232 7767216 9806688
14:16:47 4491 8192000000 10815791648 11253518336 1900713664 18.832 100 29 59 1 1915954048 6941488 8298896
14:16:58 11258 8192000000 10830315952 11258642432 1898577616 18.815 100 17 34 0 1909777968 6271808 4928544
14:17:16 9207 8192000000 10807335808 11243307008 1879896544 18.664 99 19 36 1 1890473648 5483712 5093392
14:17:33 12368 8192000000 10778789728 11213402112 1810921728 18.103 96 14 28 1 1824371808 10076000 3374080
14:17:53 8776 8192000000 10777932592 11208138752 1840248320 18.343 98 22 41 5 1851757312 5296944 6212048
14:18:08 7308 8192000000 10782966096 11216547840 1857389248 18.482 99 21 43 4 1868883520 4911072 6583200
14:18:23 10493 8192000000 10781724704 11215646720 1845095616 18.382 98 17 34 2 1855658608 5752400 4810592
14:18:40 9941 8192000000 10749770128 11175727104 1773300320 17.794 96 16 32 2 1783125712 5626720 4198672
14:18:56 8963 8192000000 10761114864 11181449216 1801935248 18.030 97 24 48 1 1814773200 5482944 7355008
14:19:14 70021 8192000000 10719236320 11139837952 1644577632 16.719 89 22 44 1 1655236528 4880464 5778432
14:20:33 5544 8192000000 10719727136 11139416064 1791641440 17.945 99 42 84 1 1811643120 7933376 12068304
14:20:45 6049 8192000000 10716816720 11132583936 1763201328 17.711 97 41 82 1 1782575840 8164000 11210512
14:20:58 8129 8192000000 10735228624 11146170368 1783389008 17.877 98 28 57 1 1797112816 5292976 8430832
14:21:15 6054 8192000000 10682428384 11088732160 1762356336 17.704 98 23 46 2 1775736256 6312672 7067248
14:21:29 7369 8192000000 10696490400 11103068160 1671978736 16.950 93 28 58 0 1684479984 4260720 8240528
14:21:45 6108 8192000000 10704830176 11115642880 1778252976 17.835 100 18 36 2 1789019632 5335600 5431056
14:21:57 6682 8192000000 10721307664 11135533056 1783934608 17.882 99 23 46 1 1795739360 5216432 6588320
14:22:11 5947 8192000000 10724847952 11140009984 1792060272 17.949 99 27 54 2 1805589664 5209680 8319712
14:22:25 6219 8192000000 10703579168 11121504256 1771100624 17.776 98 23 45 2 1782708928 4797632 6810672
14:22:39 7791 8192000000 10726563984 11139629056 1788001088 17.915 99 17 34 1 1798643856 5506304 5136464
14:22:57 4578 8192000000 10742099216 11162832896 1828172384 18.244 100 32 64 0 1844777808 7031024 9574400
14:23:09 11342 8192000000 10750214304 11164332032 1824089856 18.211 100 18 36 0 1834776224 5536304 5150064
14:23:28 14850 8192000000 10737917040 11166986240 1816779760 18.151 99 22 44 1 1829094016 5405968 6908288
14:23:50 21222 8192000000 10752722608 11178774528 1844601344 18.378 100 42 82 2 1862705392 6295776 11808272
14:24:54 31824 8192000000 10759073584 11186544640 1847238640 18.400 100 16 32 0 1857543280 5444832 4859808
14:25:32 12435 8192000000 10775208896 11198349312 1854889744 18.462 100 31 59 5 1869920944 6389712 8641488
14:25:52 7366 8192000000 10768223552 11195154432 1852468496 18.442 100 29 57 2 1867011104 5944448 8598160
14:26:08 7042 8192000000 10776437200 11201921024 1860928048 18.511 100 26 52 4 1874207504 5458560 7820896
14:26:25 3945 8192000000 10783938624 11203608576 1848356032 18.409 99 36 73 0 1865444176 6576912 10511232
14:26:38 7614 8192000000 10780942928 11206082560 1863572192 18.532 100 24 48 1 1876196080 5943936 6679952
14:26:53 8959 8192000000 10775765888 11207761920 1864108144 18.537 100 21 41 2 1875076704 5194000 5774560
14:27:10 4953 8192000000 10829325952 11239583744 1892372944 18.765 100 44 87 2 1911219488 5698976 13147568
14:27:27 30522 8192000000 10827911456 11247550464 1899845344 18.825 100 42 83 1 1918474320 6496656 12132320
14:28:05 7181 8192000000 10842920160 11257540608 1910096576 18.907 100 55 110 3 1933337664 7468192 15772896
14:28:21 8398 8192000000 10853604448 11269242880 1918789200 18.977 100 58 116 0 1945212320 9805760 16617360
14:28:38 3754 8192000000 10867313472 11277803520 1923822256 19.017 100 67 134 0 1952786064 10193984 18769824
14:28:48 7944 8192000000 10867801040 11279843328 1927405920 19.046 100 67 134 1 1958316320 11101408 19808992
14:29:19 107021 8192000000 10853191136 11292647424 1927662960 19.048 100 28 56 2 1943556208 7806528 8086720
14:31:15 20308 8192000000 10873992768 11300818944 1941457088 19.158 100 43 85 1 1964477264 10768496 12251680
14:31:48 35598 8192000000 10873482240 11306102784 1943656496 19.176 100 38 76 2 1968058912 12773552 11628864
14:32:34 19393 8192000000 10882401984 11314106368 1947678656 19.208 100 43 83 0 1973794592 14274608 11841328
14:33:05 6335 8192000000 10903035616 11321778176 1954779664 19.265 100 54 108 1 1984971488 14576944 15614880
14:33:19 13469 8192000000 10896514384 11323813888 1959972368 19.306 100 52 103 0 1990881504 15212912 15696224
14:33:41 8184 8192000000 10906969824 11337953280 1967247216 19.364 100 60 114 3 1996909984 11690736 17972032
14:34:00 23172 8192000000 10898314288 11330318336 1946181040 19.196 99 42 84 3 1970372048 11935648 12255360
14:34:32 4598 8192000000 10905480928 11333890048 1964408704 19.341 100 49 98 0 1991416768 12196704 14811360
14:34:43 8354 8192000000 10893535680 11319414784 1946720992 19.200 99 62 122 1 1978485888 12700320 19064576
14:35:00 2712 8192000000 10911335056 11328503808 1959235232 19.300 100 62 125 1 1988630368 12232912 17162224
14:35:09 6969 8192000000 10909359152 11335049216 1966000176 19.354 100 62 122 1 1996994832 14146704 16847952
14:35:32 5637 8192000000 10921481088 11343097856 1972256672 19.403 100 69 139 0 2008112768 15342688 20513408
14:35:44 9404 8192000000 10912918176 11338489856 1973450288 19.413 100 80 156 3 2010907200 15657280 21799632
14:36:01 3516 8192000000 10915170176 11330985984 1965034224 19.346 100 77 154 2 2004050784 17270944 21745616
14:36:12 27230 8192000000 10908587408 11333300224 1960573088 19.311 100 63 126 0 1995770496 17414416 17782992
14:36:47 9565 8192000000 10911647200 11340664832 1964380176 19.341 100 52 104 1 1998322096 18857456 15084464
14:37:05 2677 8192000000 10919677920 11342872576 1970718592 19.391 100 59 117 1 2005524592 18071904 16734096
14:37:15 4663 8192000000 10932089968 11356499968 1981893728 19.480 100 72 144 1 2021250752 18554960 20802064
14:37:26 8672 8192000000 10941347584 11362213888 1986579792 19.517 100 71 142 1 2027227648 19566480 21081376
14:37:42 3366 8192000000 10947439312 11366285312 1990023136 19.544 100 78 152 2 2032322064 19675872 22623056
14:37:52 10486 8192000000 10946057792 11369123840 1989722368 19.542 100 69 137 2 2028202400 18983952 19496080
14:38:10 11820 8192000000 10942043120 11367731200 1990612912 19.549 100 67 134 1 2028136608 18520560 19003136
14:38:29 2322 8192000000 10941353296 11362045952 1976352880 19.436 99 83 166 4 2019741712 19057056 24331776
14:38:38 2931 8192000000 10944371488 11363250176 1985130240 19.505 100 73 145 1 2025812160 19510368 21171552
14:38:48 6187 8192000000 10942015664 11364864000 1983934512 19.496 100 83 165 1 2031974480 23807680 24232288
14:39:06 3845 8192000000 10912490576 11334201344 1943199760 19.172 98 66 129 1 1980499936 18751280 18548896
14:39:17 4334 8192000000 10938987744 11361468416 1980796896 19.471 100 71 137 0 2022996032 21771760 20427376
14:39:33 2567 8192000000 10942423616 11367829504 1984586176 19.501 100 69 138 0 2027123472 22528928 20008368
14:39:44 9073 8192000000 10956328960 11379236864 1991892160 19.559 100 69 136 3 2037858864 25916800 20049904
14:40:02 4753 8192000000 10955617584 11383398400 1996754528 19.597 100 64 128 0 2043101712 27304976 19042208
14:40:16 3428 8192000000 10966484704 11394969600 2000148944 19.624 100 61 122 0 2046397808 28505376 17743488
14:40:27 4429 8192000000 10935884208 11355582464 1965826976 19.352 98 73 145 2 2019158976 32161904 21170096
14:40:39 5514 8192000000 10951536000 11379109888 1991339216 19.554 100 67 133 0 2039997680 29091088 19567376
14:40:51 3338 8192000000 10957542480 11379658752 1994799152 19.582 100 70 139 2 2044343792 28960912 20583728
14:41:02 6323 8192000000 10935503568 11352772608 1961335728 19.317 99 81 163 0 2015844096 29363344 25145024
14:41:20 2660 8192000000 10934367504 11349835776 1965414816 19.349 100 78 149 1 2018094448 30844000 21835632
14:41:31 2725 8192000000 10943629552 11352735744 1965774928 19.352 100 90 179 2 2025609584 32878992 26955664
14:41:48 3289 8192000000 10940419536 11362484224 1971874992 19.400 100 62 122 0 2023725808 32436784 19414032
14:41:59 3499 8192000000 10920885520 11332493312 1932354208 19.086 98 74 147 1 1988086464 32539632 23192624
14:42:10 4311 8192000000 10938823296 11349561344 1960607504 19.311 100 86 172 0 2021578976 34487616 26483856
14:42:21 2834 8192000000 10943005616 11354992640 1967521216 19.366 100 84 166 3 2026791184 34288608 24981360
14:42:31 2268 8192000000 10951280064 11364409344 1975707520 19.431 100 75 148 2 2033522608 34976752 22838336
14:42:40 2442 8192000000 10953298656 11368042496 1977972944 19.449 100 79 158 1 2038579296 36113456 24492896
14:42:52 5925 8192000000 10947637744 11359961088 1971857024 19.400 100 79 152 1 2030635136 36206672 22571440
14:43:06 2720 8192000000 10972933472 11385126912 1990677248 19.549 100 78 156 0 2052120480 36175360 25267872
14:43:16 1667 8192000000 10977658080 11389075456 1998586160 19.612 100 83 165 1 2057338784 33157424 25595200
14:43:24 5235 8192000000 10976554768 11394674688 1988222656 19.530 99 83 166 0 2049766112 35218400 26325056
14:43:37 3361 8192000000 10984356416 11401551872 2005772992 19.668 100 71 143 0 2064549264 37298480 21477792
14:43:47 1646 8192000000 10967698880 11385028608 1989431344 19.539 100 70 140 0 2048497008 37821792 21243872
14:43:57 5678 8192000000 10977067104 11393232896 1997671232 19.604 100 74 143 0 2060743024 40235168 22836624
14:44:10 3983 8192000000 10970616608 11391266816 1995416736 19.587 100 76 152 0 2055202752 36219824 23566192
14:44:20 5594 8192000000 10988769728 11402608640 2002582848 19.643 100 81 162 0 2065080752 36729664 25768240
14:44:34 5972 8192000000 10977756896 11396546560 1998733712 19.613 100 83 165 1 2062786304 38429408 25623184
14:44:47 4232 8192000000 10974811616 11390001152 1992619472 19.564 100 78 156 4 2056273376 39456880 24197024
14:44:58 2215 8192000000 10960478400 11367874560 1962765680 19.328 98 78 157 1 2027369024 39857584 24745760
14:45:09 3914 8192000000 10960242800 11380989952 1982375952 19.484 100 80 159 1 2048124144 40802144 24946048
14:45:20 3135 8192000000 10978847152 11394187264 1986617072 19.517 100 74 148 0 2052325584 42052784 23655728
14:45:30 3800 8192000000 10985772528 11398053888 1991590384 19.556 100 80 160 0 2060752528 43972208 25189936
14:45:41 4692 8192000000 10952735360 11361062912 1961218112 19.316 100 82 164 3 2030497568 44229728 25049728
14:45:52 6083 8192000000 10957642160 11364524032 1965071088 19.346 100 81 159 2 2034109200 44719808 24318304
14:46:06 5067 8192000000 10953012992 11365244928 1952315408 19.245 99 83 167 0 2023206928 45485984 25405536
14:46:20 3542 8192000000 10948103472 11364081664 1949334544 19.221 99 80 158 4 2018454816 45420256 23700016
14:46:31 2275 8192000000 10971709328 11384127488 1977349488 19.444 100 91 180 3 2051928672 46230272 28348912
14:46:40 1215 8192000000 10984114832 11389906944 1982169888 19.482 100 85 168 3 2055545616 47490048 25885680
14:46:49 2215 8192000000 10959149344 11369242624 1971110608 19.394 100 84 169 0 2040740816 42687968 26942240
14:46:58 4069 8192000000 10975765088 11387506688 1982828064 19.487 100 87 174 0 2053300688 43534240 26938384
14:47:09 2787 8192000000 10983729440 11392372736 1990106992 19.545 100 89 173 1 2058990800 43133424 25750384
14:47:19 3514 8192000000 10986757456 11393871872 1987916176 19.527 100 87 172 1 2058735440 43933312 26885952
14:47:29 2856 8192000000 10997275696 11403022336 2003052400 19.647 100 89 181 1 2074099152 43165824 27880928
14:47:39 10772 8192000000 10979952128 11394371584 1979357456 19.460 99 69 139 2 2042055968 41454992 21243520
14:47:57 6828 8192000000 10970028272 11399864320 1997067248 19.600 100 60 120 2 2056876544 41043264 18766032
14:48:13 7326 8192000000 10958360432 11400482816 1994885472 19.582 100 45 90 0 2048774592 39218032 14671088
14:48:33 3545 8192000000 10959381568 11387678720 1971436288 19.397 99 48 94 0 2027189104 39825088 15927728
14:48:47 10590 8192000000 10945786672 11381911552 1976373968 19.436 100 40 80 1 2031828144 41937792 13516384
14:49:07 5714 8192000000 10945688304 11377799168 1966965344 19.361 100 44 88 3 2025746192 44088416 14692432
14:49:21 3935 8192000000 10961728928 11380883456 1965927376 19.353 100 63 123 1 2039084240 52879968 20276896
14:49:32 3802 8192000000 10972956032 11390234624 1977440064 19.444 100 75 149 0 2052354432 51033104 23881264
14:49:43 4766 8192000000 10965126544 11394048000 1978418592 19.452 100 57 114 0 2049297472 52198048 18680832
14:49:58 6333 8192000000 10964016032 11389042688 1959773504 19.304 99 56 113 1 2029399344 50710208 18915632
14:50:11 12355 8192000000 10941030288 11379216384 1948597776 19.215 99 49 98 1 2016953232 51726864 16628592
14:50:37 7646 8192000000 10962446496 11392196608 1978129104 19.450 100 50 98 1 2042283632 47384496 16770032
14:50:52 3059 8192000000 10971662576 11394486272 1985540736 19.509 100 61 122 1 2052414704 47596336 19277632
14:51:03 5754 8192000000 10975833568 11401613312 1989605744 19.541 100 66 132 2 2060569328 49611872 21351712
14:51:15 3031 8192000000 10993634160 11407241216 1997919456 19.606 100 80 162 0 2071926256 49624992 24381808
14:51:28 7775 8192000000 10985504288 11414675456 1994240624 19.577 100 56 110 3 2066203680 53694304 18268752
14:51:49 7753 8192000000 10974272480 11410014208 1984048528 19.497 100 53 106 1 2059323744 57574784 17700432
14:52:26 13436 8192000000 10946357088 11379367936 1955222208 19.268 99 40 80 2 2021237888 51834768 14180912
14:52:54 16111 8192000000 10946732432 11387031552 1955771488 19.272 99 31 61 2 2018365024 52419552 10173984
14:53:21 10014 8192000000 10951385072 11392086016 1961242912 19.316 100 34 66 4 2028762736 56214752 11305072
14:53:38 7900 8192000000 10955892560 11397726208 1963203264 19.331 100 34 68 1 2034775888 59209440 12363184
14:53:52 12898 8192000000 10942712912 11380666368 1951609056 19.239 99 38 76 0 2024303920 59202400 13492464
14:54:13 15324 8192000000 10952379440 11394596864 1965498592 19.350 100 36 72 0 2035642128 57194592 12948944
14:54:35 19904 8192000000 10946904672 11395956736 1965456208 19.349 100 25 50 0 2027088240 52029296 9602736
14:55:02 24144 8192000000 10936557888 11398971392 1967573520 19.366 100 28 56 2 2025421888 47866912 9981456
14:55:41 33403 8192000000 10923245568 11383529472 1939544944 19.143 99 19 38 0 1995062496 48498544 7019008
14:56:50 53576 8192000000 10892464352 11366166528 1898198880 18.812 97 13 27 1 1944564976 41870800 4495296
14:57:51 37035 8192000000 10881505728 11347582976 1930291664 19.069 99 23 46 1 1961653520 24349472 7012384
14:58:36 27400 8192000000 10874072208 11308138496 1910208000 18.908 98 41 84 1 1941727504 18424960 13094544
14:59:09 30632 8192000000 10868477168 11309682688 1911960752 18.922 99 27 53 1 1927547344 8753680 6832912
14:59:55 51449 8192000000 10848681872 11311923200 1929704432 19.065 100 29 58 3 1950782368 12538048 8539888
15:01:03 77146 8192000000 10845294640 11299860480 1908168512 18.892 100 6 12 1 1923140464 13404784 1567168
15:02:26 93666 8192000000 10850083376 11310153728 1874578784 18.621 97 13 26 1 1886328672 8284256 3465632
15:04:06 77002 8192000000 10856515504 11312279552 1872079904 18.601 97 19 39 1 1887725536 10017040 5628592
15:05:38 94390 8192000000 10881711488 11321925632 1884966288 18.705 97 14 28 0 1901335056 12720640 3648128
15:07:19 33888 8192000000 10856901824 11319336960 1936327344 19.117 100 31 62 2 1960707360 15364192 9015824
15:08:00 28318 8192000000 10863869696 11319873536 1916357200 18.958 99 13 26 1 1933196656 12636112 4203344
15:08:38 63751 8192000000 10893331424 11332354048 1933713248 19.097 100 24 48 2 1960518432 19046256 7758928
15:10:30 72071 8192000000 10900685760 11352104960 1960452576 19.310 100 36 70 2 1981979728 11109072 10418080
15:11:59 59685 8192000000 10879962224 11351166976 1940213808 19.148 99 17 34 1 1954344336 9513856 4616672
15:13:06 40101 8192000000 10877109824 11357376512 1953982240 19.258 100 4 8 0 1966065248 11216288 866720
15:13:52 55420 8192000000 10875508448 11334619136 1940901616 19.154 99 9 19 1 1955128976 12060928 2166432
15:15:05 145854 8192000000 10900696832 11374092288 1967102800 19.362 100 22 44 1 1982482992 9077568 6302624
15:17:37 74748 8192000000 10878015104 11356049408 1937588624 19.128 98 17 34 2 1955856208 13185776 5081808
15:18:58 30127 8192000000 10886865632 11357765632 1961409712 19.317 100 4 8 0 1969960624 7132672 1418240
15:19:39 42104 8192000000 10902552752 11373084672 1980067040 19.465 100 21 42 1 1994757136 8178336 6511760
15:20:30 36862 8192000000 10896668288 11372417024 1966483040 19.358 99 16 32 0 1982676720 11233536 4960144
15:22:10 69386 8192000000 10881052224 11369205760 1933248752 19.093 98 7 14 0 1945596304 10361664 1985888
15:23:26 68139 8192000000 10898959296 11375964160 1973329888 19.412 100 17 34 1 1988227888 10332656 4565344
15:24:44 71411 8192000000 10879520992 11363393536 1934279344 19.101 98 11 22 0 1948127600 10813728 3034528
15:26:08 67469 8192000000 10897302448 11363835904 1907044880 18.883 97 13 26 1 1922668464 12093488 3530096
15:27:23 50030 8192000000 10895159760 11368357888 1924902976 19.026 97 32 64 1 1946062256 12148256 9011024
15:28:19 61470 8192000000 10873745472 11342761984 1893290384 18.772 96 19 38 0 1916002256 17629072 5082800
15:29:27 63542 8192000000 10887552128 11352477696 1912664480 18.928 98 18 36 2 1929443248 11629584 5149184
15:30:36 143247 8192000000 10907001184 11368808448 1876683040 18.638 95 13 26 0 1897924352 17477088 3764224
15:33:22 55755 8192000000 10881765904 11362004992 1913577504 18.935 98 10 20 2 1937235136 20675120 2982512
15:34:25 37904 8192000000 10909647744 11372154880 1943928720 19.178 99 31 62 2 1966598848 13978784 8691344
15:35:11 46381 8192000000 10904164320 11348484096 1896537072 18.798 97 27 54 1 1918776064 14959392 7279600
15:36:04 61676 8192000000 10887191808 11353702400 1886309792 18.716 96 13 26 2 1906140064 16243552 3586720
15:37:13 49290 8192000000 10891853072 11357716480 1884912496 18.705 97 14 28 0 1907154112 18282016 3959600
15:38:12 147828 8192000000 10913191136 11352428544 1891432000 18.757 97 15 30 0 1915829568 20086880 4310688
15:41:01 59580 8192000000 10871655472 11338969088 1899832784 18.825 97 24 48 0 1915779536 8996720 6950032
15:42:31 24967 8192000000 10835212880 11307249664 1879448048 18.661 97 11 22 0 1892311088 9589648 3273392
15:43:02 45652 8192000000 10823647488 11305283584 1911763824 18.921 100 10 20 0 1923633168 8884480 2984864
15:43:54 24686 8192000000 10847955168 11319607296 1919312912 18.981 100 10 19 1 1933946208 12352512 2280784
15:44:28 53674 8192000000 10823958736 11299618816 1868137536 18.569 97 9 17 0 1878430672 7889216 2403920
15:45:29 66037 8192000000 10851208400 11314348032 1894422592 18.781 98 12 24 1 1906853520 8904400 3526528
15:47:49 29052 8192000000 10860412416 11339018240 1934640400 19.104 100 13 27 2 1949050416 10857872 3552144
15:48:25 57156 8192000000 10866938192 11340365824 1941923824 19.162 100 14 28 1 1954022416 8443280 3655312
15:49:28 55153 8192000000 10851033664 11325513728 1928131744 19.052 99 17 32 0 1941793808 9047712 4614352
15:50:32 66662 8192000000 10882226496 11353341952 1939439808 19.142 99 18 36 0 1951983184 7235120 5308256
15:51:45 37773 8192000000 10859006768 11323412480 1889568560 18.742 97 22 44 2 1904917232 9366944 5981728
15:52:33 41343 8192000000 10853178448 11315122176 1881546768 18.678 97 19 36 2 1896448672 9833088 5068816
15:53:21 34924 8192000000 10879499216 11337039872 1924005952 19.019 99 33 66 2 1942246480 9244336 8996192
15:54:43 70188 8192000000 10869807664 11334352896 1900894480 18.833 97 16 32 0 1916214352 10808992 4510880
15:56:06 31581 8192000000 10891052496 11338551296 1929941152 19.066 98 32 64 1 1947694992 9132640 8621200
15:57:18 51079 8192000000 10867287952 11326709760 1871294768 18.595 96 16 32 0 1889351648 13998576 4058304
15:58:16 39760 8192000000 10891117008 11346587648 1939657776 19.144 100 32 64 0 1957811664 9523952 8629936
15:59:08 79465 8192000000 10871348112 11340623872 1874885968 18.624 96 21 42 2 1891493696 11450080 5157648
16:00:34 84524 8192000000 10890391696 11338633216 1866188288 18.553 95 20 40 1 1880288064 9038928 5060848
16:02:08 31870 8192000000 10890704048 11344302080 1932446832 19.086 99 29 58 0 1955070000 14947632 7675536
16:02:47 142926 8192000000 10892728624 11361087488 1958529568 19.294 100 23 46 1 1979756736 15116320 6110848
16:05:19 86177 8192000000 10874410176 11329638400 1892941328 18.769 96 28 56 0 1912337152 11382272 8013552
16:06:51 81937 8192000000 10854152064 11336671232 1891770784 18.760 97 19 38 3 1911186912 13585552 5830576
16:08:19 53342 8192000000 10883100368 11355365376 1954418560 19.262 100 9 18 1 1971780080 14936032 2425488
16:09:21 33708 8192000000 10877243616 11357073408 1940544368 19.151 99 8 16 1 1959155392 16794896 1816128
16:10:01 10288 8192000000 10878500688 11354189824 1937457456 19.126 99 9 18 0 1956828000 17010208 2360336
16:11:01 88248 8192000000 10894951792 11374985216 1963473296 19.334 100 17 34 0 1985752064 17517776 4760992
16:12:46 59599 8192000000 10893716512 11373015040 1941593712 19.159 98 11 22 0 1962764288 17582272 3588304
16:14:02 58028 8192000000 10900279200 11359531008 1920968448 18.995 97 30 60 1 1940890704 10699728 9222528
16:15:07 50711 8192000000 10895179792 11367809024 1932492672 19.087 98 19 38 1 1950882544 12970848 5419024
16:16:04 70605 8192000000 10883420752 11353948160 1905834736 18.873 97 19 38 0 1921813856 10488032 5491088
16:17:29 8691 8192000000 10930079520 11372662784 1977266416 19.443 100 53 106 1 2000317824 7737840 15313568
16:17:44 28949 8192000000 10894953552 11356409856 1913127392 18.932 97 45 91 3 1936437296 10479536 12830368
16:18:23 83365 8192000000 10869265968 11349782528 1887765648 18.728 96 19 38 0 1907527952 14227536 5534768
16:19:53 57679 8192000000 10912257392 11366100992 1961704016 19.320 100 33 66 0 1983997648 12318400 9975232
16:21:00 65351 8192000000 10897856528 11385180160 1956193184 19.276 99 34 68 0 1982253488 16428880 9631424
16:22:22 74077 8192000000 10904134768 11361943552 1892995344 18.770 96 14 28 0 1906585456 9932976 3657136
16:24:36 46122 8192000000 10892594544 11367272448 1921954720 19.002 98 35 70 2 1947316864 15399552 9962592
16:25:29 109561 8192000000 10406948688 10844454912 1497531584 15.455 77 8 16 0 1520246688 20658112 2056992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-11-2020 16:29:50 to 19-11-2020 16:30:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 93 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-11-2020 16:30:23 to 19-11-2020 16:30:25.

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          234595
MON$OLDEST_ACTIVE               234822
MON$OLDEST_SNAPSHOT             234822
MON$NEXT_TRANSACTION            234822
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                       2012416
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:62: 
:63: mscs-test-161.budzdorov.ru    Thu Nov 19 16:27:34 2020
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Thu Nov 19 16:27:36 2020
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Thu Nov 19 16:28:00 2020
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Thu Nov 19 16:28:01 2020
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:77: 
:78: 
:79: mscs-test-161.budzdorov.ru    Thu Nov 19 16:28:01 2020
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
--- end of diff output ---

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

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