Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.12.2020 19: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 17298608 kB
MemAvailable 31493680 kB
Buffers 0 kB
Cached 14358716 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-15 19:27:06
DTS_END                         2020-12-15 19:27:06.2750
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35108
TRN_ID                          248588
ATT_ID                          659
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: 9690.67 22983 1162881
customer order: creation 172.17 383 20660
customer order: refuse 14.85 276 1782
order to supplier: creation 47.01 1156 5641
order to supplier: removal 3.75 85718 450
invoice (draft): creation 46.32 2687 5558
invoice (draft): removal 55.90 617 6708
invoice accept: apply 42.73 16536 5127
invoice accept: cancel 51.35 706 6162
customer reserve: creation 3907.93 166 468952
customer reserve: removal 5041.71 51 605005
realization accept: apply 83.66 171 10039
realization accept: cancel 92.18 105 11062
payment from customer: creation 59.76 108 7171
payment from customer: removal 5.75 113 690
payment to supplier: creation 49.63 128 5955
payment to supplier: removal 3.76 57 451
service: total inventory turnovers 5.13 1074 616
service: total monetary turnovers 6.25 27 750
service: aggregate perf. data 0.82 18329 98
service: refresh index statistics 0.03 331260 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-12-2020 19:28:21 to 15-12-2020 19:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4139
TEST_TIME 2 3296
TEST_TIME 3 5410
TEST_TIME 4 5381
TEST_TIME 5 5433
TEST_TIME 6 5323
TEST_TIME 7 5106
TEST_TIME 8 5750
TEST_TIME 9 6375
TEST_TIME 10 7195
TEST_TIME 11 7335
TEST_TIME 12 7277
TEST_TIME 13 8093
TEST_TIME 14 8364
TEST_TIME 15 8785
TEST_TIME 16 9117
TEST_TIME 17 9685
TEST_TIME 18 9852
TEST_TIME 19 9781
TEST_TIME 20 9954
TEST_TIME 21 10362
TEST_TIME 22 10535
TEST_TIME 23 10974
TEST_TIME 24 11908
TEST_TIME 25 11814
TEST_TIME 26 11771
TEST_TIME 27 11874
TEST_TIME 28 11990
TEST_TIME 29 11783
TEST_TIME 30 11423
TEST_TIME 31 11462
TEST_TIME 32 11261
TEST_TIME 33 11205
TEST_TIME 34 11064
TEST_TIME 35 11049
TEST_TIME 36 10951
TEST_TIME 37 10833
TEST_TIME 38 10651
TEST_TIME 39 10694
TEST_TIME 40 10716
TEST_TIME 41 10576
TEST_TIME 42 10401
TEST_TIME 43 10323
TEST_TIME 44 10261
TEST_TIME 45 10353
TEST_TIME 46 10263
TEST_TIME 47 10177
TEST_TIME 48 10075
TEST_TIME 49 10014
TEST_TIME 50 9966
TEST_TIME 51 9921
TEST_TIME 52 9923
TEST_TIME 53 9874
TEST_TIME 54 9876
TEST_TIME 55 9822
TEST_TIME 56 9965
TEST_TIME 57 9975
TEST_TIME 58 10057
TEST_TIME 59 10099
TEST_TIME 60 10140
TEST_TIME 61 10191
TEST_TIME 62 10219
TEST_TIME 63 10209
TEST_TIME 64 10264
TEST_TIME 65 10405
TEST_TIME 66 10359
TEST_TIME 67 10320
TEST_TIME 68 10240
TEST_TIME 69 10165
TEST_TIME 70 10100
TEST_TIME 71 10080
TEST_TIME 72 10051
TEST_TIME 73 10053
TEST_TIME 74 10004
TEST_TIME 75 9979
TEST_TIME 76 9912
TEST_TIME 77 9981
TEST_TIME 78 9986
TEST_TIME 79 9944
TEST_TIME 80 9944
TEST_TIME 81 9982
TEST_TIME 82 10059
TEST_TIME 83 10061
TEST_TIME 84 10072
TEST_TIME 85 10031
TEST_TIME 86 10089
TEST_TIME 87 10084
TEST_TIME 88 10177
TEST_TIME 89 10233
TEST_TIME 90 10122
TEST_TIME 91 10085
TEST_TIME 92 10049
TEST_TIME 93 10047
TEST_TIME 94 9988
TEST_TIME 95 9938
TEST_TIME 96 9907
TEST_TIME 97 9850
TEST_TIME 98 9949
TEST_TIME 99 9932
TEST_TIME 100 9957
TEST_TIME 101 9985
TEST_TIME 102 9996
TEST_TIME 103 10014
TEST_TIME 104 10007
TEST_TIME 105 9991
TEST_TIME 106 10023
TEST_TIME 107 10027
TEST_TIME 108 10037
TEST_TIME 109 10019
TEST_TIME 110 9935
TEST_TIME 111 9915
TEST_TIME 112 9896
TEST_TIME 113 9861
TEST_TIME 114 9831
TEST_TIME 115 9792
TEST_TIME 116 9773
TEST_TIME 117 9798
TEST_TIME 118 9762
TEST_TIME 119 9742
TEST_TIME 120 9693

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-12-2020 19:28:24 to 15-12-2020 19:28:28.

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 1598676 1598676 0 0.00 0 21993 6 0 0
doc_list_biud 1598675 1598675 0 0.00 0 58522 24 0 0
sp_add_invoice_to_stock 5234 5127 107 2.04 35 199157 16536 0 107
sp_cancel_adding_invoice 6162 6162 0 0.00 4 63573 706 0 0
sp_cancel_client_order 1782 1782 0 0.00 4 13650 276 0 0
sp_cancel_customer_reserve 605005 605005 0 0.00 1 58525 52 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 2 18262 113 0 0
sp_cancel_pay_to_supplier 451 451 0 0.00 3 1835 57 0 0
sp_cancel_supplier_invoice 6721 6708 13 0.19 2 18993 618 0 13
sp_cancel_supplier_order 450 450 0 0.00 6 959226 85718 0 0
sp_cancel_write_off 11062 11062 0 0.00 1 39000 106 0 0
sp_client_order 20660 20660 0 0.00 4 51039 384 0 0
sp_customer_reserve 468952 468952 0 0.00 0 74326 167 0 0
sp_fill_shopping_cart 31852 31852 0 0.00 1 14744 35 0 0
sp_fill_shopping_cart_clo_res 468946 468946 0 0.00 0 17301 14 0 0
sp_get_clo_for_invoice 5121 5121 0 0.00 0 31316 323 0 0
sp_kill_cost_storno 18365 18365 0 0.00 0 18254 50 0 0
sp_kill_qstorno_ret_qs2qd 1228230 1228230 0 0.00 0 58520 28 0 0
sp_kill_qty_storno 646328 646328 0 0.00 0 58522 59 0 0
sp_lock_selected_doc 21088 21088 0 0.00 0 9149 6 0 0
sp_make_cost_storno 28286 28286 0 0.00 0 21851 45 0 0
sp_multiply_rows_for_pdistr 28285 28285 0 0.00 0 21108 33 0 0
sp_multiply_rows_for_qdistr 20660 20660 0 0.00 0 51031 184 0 0
sp_pay_from_customer 7171 7171 0 0.00 4 20100 109 0 0
sp_pay_to_supplier 5955 5955 0 0.00 5 20151 128 0 0
sp_payment_common 13126 13126 0 0.00 1 20091 43 0 0
sp_qd_handle_on_cancel_clo 1782 1782 0 0.00 0 13642 245 0 0
sp_qd_handle_on_invoice_upd_sts 11282 11282 0 0.00 0 18514 274 0 0
sp_qd_handle_on_reserve_upd_sts 10039 10039 0 0.00 0 8162 57 0 0
sp_reserve_write_off 10039 10039 0 0.00 6 21348 171 0 0
sp_supplier_invoice 5558 5558 0 0.00 7 69975 2687 0 0
sp_supplier_order 5641 5641 0 0.00 5 37723 1157 0 0
srv_aggregate_perf_data 98 98 0 0.00 3428 121489 18330 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1134 151349 36370 0 0
srv_find_qd_qs_mism 1115371 1115371 0 0.00 0 15342 5 0 0
srv_make_invnt_saldo 616 616 0 0.00 39 45570 1075 0 0
srv_make_money_saldo 750 750 0 0.00 1 5713 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 165532 445950 331260 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 17465 131 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 2559 57 0 0
t$perf-norm:sp_cancel_client_order 1782 1782 0 0.00 0 5543 15 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 3386 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 1192 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 451 451 0 0.00 0 12114 34 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 2050 19 0 0
t$perf-norm:sp_cancel_supplier_order 450 450 0 0.00 0 29773 1410 0 0
t$perf-norm:sp_cancel_write_off 997 997 0 0.00 0 2520 12 0 0
t$perf-norm:sp_client_order 20660 20660 0 0.00 0 14077 14 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 1862 6 0 0
t$perf-norm:sp_pay_from_customer 7171 7171 0 0.00 0 4004 9 0 0
t$perf-norm:sp_pay_to_supplier 5955 5955 0 0.00 0 4235 8 0 0
t$perf-norm:sp_reserve_write_off 10039 10039 0 0.00 0 6864 10 0 0
t$perf-norm:sp_supplier_invoice 5558 5558 0 0.00 0 6202 14 0 0
t$perf-norm:sp_supplier_order 5641 5641 0 0.00 0 12125 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 184 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 972 10 0 0
t$perf-norm:srv_make_invnt_saldo 616 616 0 0.00 0 5025 15 0 0
t$perf-norm:srv_make_money_saldo 750 750 0 0.00 0 3035 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10454 10240 214 2.04 0 5363 18 0 214
v_all_customers 37674 37674 0 0.00 0 19 0 0 0
v_all_suppliers 30860 30860 0 0.00 0 19 1 0 0
v_all_wares 41320 41320 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 187 5 0 0
v_cancel_client_order 3564 3564 0 0.00 0 3107 5 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 4729 8 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 4755 7 0 0
v_cancel_payment_to_supplier 902 902 0 0.00 0 1679 7 0 0
v_cancel_supplier_invoice 856 830 26 3.03 0 1491 14 0 26
v_cancel_supplier_order 900 900 0 0.00 0 696 4 0 0
v_cancel_write_off 1994 1994 0 0.00 0 8885 20 0 0
v_max_id_clo_ord 5638 5638 0 0.00 0 2838 2 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 1906 9 0 0
v_max_id_ord_sup 5553 5553 0 0.00 0 6590 7 0 0
v_max_non_paid_invoice 1716 1716 0 0.00 0 739 3 0 0
v_max_non_paid_realizn 3847 3847 0 0.00 0 1215 3 0 0
v_min_id_clo_ord 5638 5638 0 0.00 0 4620 7 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 5679 15 0 0
v_min_id_ord_sup 5553 5553 0 0.00 0 4917 6 0 0
v_min_non_paid_invoice 5955 5955 0 0.00 0 19992 36 0 0
v_min_non_paid_realizn 7171 7171 0 0.00 0 20041 33 0 0
v_our_firm 10292 10292 0 0.00 0 131 1 0 0
v_reserve_write_off 20076 20076 0 0.00 0 5156 6 0 0
x_lock_depdocs_on_canc_invoice 12455 12455 0 0.00 0 13849 112 0 0
x_lock_depdocs_on_canc_sup_ord 450 450 0 0.00 0 11250 286 0 0
x_make_qstorno_1000_1200 5641 5641 0 0.00 2 37716 1086 0 0
x_make_qstorno_1200_2000 5558 5558 0 0.00 2 69958 2567 0 0
x_make_qstorno_2100_3300 468952 468952 0 0.00 0 74321 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-12-2020 19:28:29 to 15-12-2020 19:28:33.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 9853 8192000000 10199640848 10496495616 740095728 8.285 60 44 90 0 756933920 1948864 14889328
16:57:34 23365 8192000000 10300731504 10616156160 1354492800 14.188 100 83 165 1 1385351920 4006608 26852512
16:58:06 29117 8192000000 10368414032 10686910464 1406756256 14.655 100 86 172 0 1441561296 5981168 28823872
16:58:48 22534 8192000000 10399004080 10721800192 1448934896 15.028 100 90 180 0 1485759536 7071296 29753344
16:59:23 18745 8192000000 10415037520 10744025088 1470691232 15.220 100 88 176 1 1507431840 8030560 28710048
16:59:51 18868 8192000000 10442626288 10773110784 1491525232 15.402 100 90 180 0 1529327568 8716128 29086208
17:00:18 23913 8192000000 10457803808 10796609536 1515454752 15.611 100 85 170 0 1551757376 9315824 26986800
17:00:52 17782 8192000000 10489343760 10830766080 1541979504 15.841 100 84 168 0 1577997216 9881200 26136512
17:01:20 15219 8192000000 10516966336 10864590848 1572931568 16.107 100 86 172 0 1609325680 10162512 26231600
17:01:42 14122 8192000000 10534530128 10886193152 1592269312 16.273 100 78 156 0 1626218256 10464992 23483952
17:02:05 11435 8192000000 10556012048 10912268288 1616789440 16.483 100 81 161 1 1651938128 10865424 24283264
17:02:26 10766 8192000000 10573381424 10935816192 1634084816 16.630 100 78 156 1 1668683360 10790768 23807776
17:02:44 8447 8192000000 10586335920 10952376320 1650798960 16.771 100 74 148 1 1684304816 11214576 22291280
17:02:59 10521 8192000000 10607683680 10975744000 1670783488 16.940 100 74 148 0 1703532080 10879856 21868736
17:03:19 8157 8192000000 10644417456 11009871872 1696150304 17.153 100 75 150 1 1728604992 10423776 22030912
17:03:34 8239 8192000000 10664378976 11039277056 1724338912 17.388 100 70 140 0 1755501184 11472864 19689408
17:03:50 5675 8192000000 10672553904 11051651072 1736797344 17.492 100 75 150 1 1770659632 13081776 20780512
17:04:04 5508 8192000000 10685059120 11067027456 1751901872 17.617 100 73 146 0 1784979568 12513760 20563936
17:04:18 3890 8192000000 10699976560 11084070912 1766643040 17.739 100 83 166 1 1802925952 13201152 23081760
17:04:29 5294 8192000000 10707837200 11090292736 1771768128 17.782 100 82 162 0 1807708960 13553616 22387216
17:04:40 3250 8192000000 10722281024 11101413376 1779721008 17.847 100 80 160 1 1816115792 14296256 22098528
17:04:51 5575 8192000000 10720992480 11108990976 1786843040 17.906 100 79 158 2 1823491376 14773120 21875216
17:05:03 4621 8192000000 10735964864 11120775168 1790042960 17.932 100 79 158 0 1825779712 13993216 21743536
17:05:14 2228 8192000000 10739691968 11130454016 1810062576 18.096 100 80 161 0 1845629216 13134608 22432032
17:05:23 2515 8192000000 10755652528 11144380416 1817650272 18.158 100 81 157 2 1852885664 12382432 22852960
17:05:34 2067 8192000000 10771375104 11160666112 1829168528 18.253 100 83 164 1 1865445712 13122864 23154320
17:05:43 2769 8192000000 10778835024 11165077504 1833735216 18.290 100 86 171 2 1870232720 12553712 23943792
17:05:53 1733 8192000000 10783328656 11167346688 1836313456 18.311 100 88 174 1 1875593376 13557664 25722256
17:06:01 1607 8192000000 10788251856 11174383616 1841506928 18.353 100 89 180 0 1879858112 13484016 24867168
17:06:09 1672 8192000000 10781107344 11172192256 1849577440 18.419 100 89 179 1 1888161232 13247504 25336288
17:06:17 1454 8192000000 10798521184 11183288320 1852890624 18.446 100 88 176 3 1892090896 14165712 25034560
17:06:25 1917 8192000000 10798351904 11184963584 1854698464 18.460 100 91 181 2 1893579296 13565040 25315792
17:06:33 1205 8192000000 10799464992 11187286016 1861377792 18.514 100 90 177 1 1898780832 13149808 24253232
17:06:41 1261 8192000000 10803875120 11193516032 1858714432 18.493 100 92 181 0 1897264464 14420640 24129392
17:06:48 14259 8192000000 10792370080 11191480320 1861900016 18.519 100 73 144 1 1895831568 13514768 20416784
17:07:09 1335 8192000000 10810819152 11200483328 1865720672 18.550 100 91 183 0 1903593104 12737776 25134656
17:07:17 4424 8192000000 10782838544 11195584512 1864186256 18.537 100 50 99 0 1889311248 11082976 14042016
17:07:30 4536 8192000000 10789702752 11204861952 1868056464 18.569 100 56 112 0 1893208800 9505024 15647312
17:07:41 4477 8192000000 10805733472 11208757248 1873246320 18.611 100 63 125 0 1901031968 10169520 17616128
17:07:52 4598 8192000000 10785915936 11202535424 1875339536 18.627 100 50 99 1 1898249664 9721488 13188640
17:08:03 3400 8192000000 10807543904 11212488704 1872452544 18.604 100 43 86 1 1892373328 8397344 11523440
17:08:13 8025 8192000000 10793186016 11210244096 1878354768 18.652 100 36 72 0 1896490752 7721744 10414240
17:08:28 11251 8192000000 10783832848 11213156352 1875935024 18.632 100 19 37 0 1887094400 6187152 4972224
17:09:11 24573 8192000000 10828834256 11225038848 1887852512 18.728 100 66 134 4 1913093776 5598480 19642784
17:09:42 1380 8192000000 10830528288 11235127296 1892873760 18.769 100 85 171 3 1928072688 10359072 24839856
17:09:52 4565 8192000000 10801971456 11230441472 1885910352 18.713 100 44 89 1 1908028464 10487376 11630736
17:10:04 8395 8192000000 10800090704 11229372416 1885528208 18.710 100 32 64 0 1901515232 7037408 8949616
17:10:19 6351 8192000000 10797020272 11228528640 1887208240 18.723 100 28 56 1 1902756368 7238416 8309712
17:10:34 7090 8192000000 10800545008 11232231424 1888164352 18.731 100 26 52 1 1901490656 6274400 7051904
17:10:48 8549 8192000000 10796769200 11231621120 1887859136 18.729 100 20 40 1 1900002496 6648128 5495232
17:11:06 7232 8192000000 10798758160 11234959360 1890939504 18.753 100 22 45 3 1902667632 4929952 6798176
17:11:20 12946 8192000000 10802504112 11240103936 1890719328 18.752 100 19 38 0 1906843968 9762080 6362560
17:11:39 8371 8192000000 10811539632 11244527616 1892833472 18.769 100 23 46 0 1909657744 10472896 6351376
17:11:56 10982 8192000000 10813696720 11250049024 1896535760 18.798 100 15 28 1 1906069824 5462880 4071184
17:12:14 8802 8192000000 10811626304 11248160768 1904933744 18.866 100 22 44 3 1917237616 5739248 6564624
17:12:32 10264 8192000000 10816057792 11249844224 1904668800 18.864 100 20 40 2 1916853952 6564832 5620320
17:12:48 6670 8192000000 10804621632 11241656320 1884843600 18.704 99 21 42 1 1895397328 4873488 5680240
17:13:01 7724 8192000000 10820992672 11251855360 1902963088 18.850 100 22 44 3 1914133952 5515808 5655056
17:13:15 49190 8192000000 10823772464 11255324672 1905613232 18.871 100 22 44 0 1917880336 5857168 6409936
17:14:29 3412 8192000000 10843504864 11270529024 1920876848 18.994 100 74 149 1 1952514352 10370384 21267120
17:14:45 6993 8192000000 10821503040 11262767104 1912229872 18.925 100 29 58 2 1926773776 6184784 8359120
17:14:58 5960 8192000000 10816652336 11256152064 1909672928 18.904 100 37 74 0 1927164576 6883232 10608416
17:15:11 5733 8192000000 10823536416 11252629504 1889472224 18.742 99 36 73 0 1907075376 7645200 9957952
17:15:24 7749 8192000000 10816988080 11254390784 1899433472 18.822 100 18 36 3 1914204640 9616096 5155072
17:15:38 5793 8192000000 10815169792 11247161344 1885574592 18.710 99 32 64 2 1901580752 6776256 9229904
17:15:51 6209 8192000000 10819465520 11251671040 1891295296 18.756 99 35 68 2 1908308656 7782000 9231360
17:16:04 6048 8192000000 10791230560 11221426176 1876654624 18.638 99 28 56 0 1894668592 10394912 7619056
17:16:17 7588 8192000000 10789343680 11228098560 1869523424 18.580 99 22 45 1 1881663792 5556960 6583408
17:16:31 10418 8192000000 10804768832 11241132032 1875609392 18.630 99 20 40 0 1895597264 15030720 4957152
17:16:48 6969 8192000000 10774375520 11201863680 1782172752 17.867 94 19 38 2 1792755408 5613056 4969600
17:17:02 10893 8192000000 10773379392 11204489216 1854323856 18.457 99 13 26 1 1863097888 4785120 3988912
17:17:19 9290 8192000000 10756531424 11186413568 1800645424 18.019 96 16 31 1 1810444848 5125184 4674240
17:17:36 46065 8192000000 10780074192 11199987712 1819706592 18.175 97 23 46 1 1831508480 5003360 6798528
17:18:39 17387 8192000000 10754128432 11180199936 1751699040 17.616 94 19 38 0 1763100288 5791392 5609856
17:19:04 6529 8192000000 10692597344 11098820608 1704655936 17.224 95 24 46 1 1716565456 4917600 6991920
17:19:17 8533 8192000000 10685862416 11084775424 1635534304 16.642 91 34 71 0 1650263376 5318768 9410304
17:19:35 9356 8192000000 10702911504 11111944192 1735205984 17.479 97 27 53 2 1749169280 5341696 8621600
17:19:52 7053 8192000000 10712692752 11127099392 1791242864 17.942 100 22 44 0 1803244256 5626896 6374496
17:20:07 7504 8192000000 10706229360 11109253120 1709233216 17.262 95 22 43 2 1720810896 5944080 5633600
17:20:21 6036 8192000000 10734673952 11145019392 1791584416 17.945 99 24 48 3 1808338624 10269088 6485120
17:20:33 8836 8192000000 10721871168 11144417280 1795116848 17.974 99 15 30 1 1804538352 5334176 4087328
17:20:48 7141 8192000000 10732258240 11146121216 1812524384 18.117 100 36 72 1 1829134656 5584720 11025552
17:21:02 10087 8192000000 10748371488 11158364160 1805498992 18.059 99 31 62 0 1821263296 4771936 10992368
17:21:18 10114 8192000000 10754120976 11171160064 1832810000 18.282 100 20 40 1 1844441648 5782080 5849568
17:21:36 13573 8192000000 10742598640 11167645696 1819336240 18.172 99 26 52 4 1832941824 5320240 8285344
17:22:00 47707 8192000000 10758911936 11186585600 1848195920 18.407 100 26 52 2 1861200272 5219424 7784928
17:23:08 26277 8192000000 10773195360 11198836736 1856485904 18.475 100 23 46 2 1868615264 5560240 6569120
17:23:41 8307 8192000000 10774273776 11203534848 1862548752 18.524 100 28 56 1 1875879472 5767424 7563296
17:23:58 9194 8192000000 10778755040 11207401472 1865150944 18.545 100 31 61 1 1879998288 6682896 8164448
17:24:15 6459 8192000000 10780530064 11206561792 1867796256 18.566 100 32 64 1 1883662864 6680656 9185952
17:24:28 11730 8192000000 10782657200 11214585856 1871298880 18.595 100 29 58 1 1885913728 5615136 8999712
17:24:46 7120 8192000000 10784228064 11217448960 1873379792 18.612 100 25 50 1 1886628880 5802864 7446224
17:24:59 11470 8192000000 10791697008 11220844544 1874821872 18.623 100 22 44 1 1891460640 10208720 6430048
17:25:25 10520 8192000000 10799372512 11229097984 1877723808 18.647 100 15 27 1 1890700432 9267584 3709040
17:25:42 16756 8192000000 10795016912 11225300992 1884787856 18.704 100 28 56 3 1899520016 6496944 8235216
17:26:05 12455 8192000000 10805951904 11233009664 1887373776 18.725 100 25 50 2 1900580560 4852672 8354112
17:26:25 10136 8192000000 10790153232 11232108544 1887204032 18.723 100 17 34 0 1897799888 6102512 4493344
17:26:44 16916 8192000000 10801182256 11236405248 1888941776 18.737 100 11 22 0 1897795344 5747600 3105968
17:27:08 36125 8192000000 10846942752 11264028672 1910359728 18.910 100 36 71 3 1927908112 4817136 12731248
17:27:50 32537 8192000000 10858751312 11275788288 1928633216 19.056 100 41 82 2 1947611824 7348464 11630144
17:28:45 72203 8192000000 10851047024 11284013056 1932497632 19.087 100 44 86 2 1956013120 11385120 12130368
17:30:10 11708 8192000000 10886815376 11311079424 1945817520 19.193 100 49 96 1 1972319440 13425424 13076496
17:30:28 5601 8192000000 10898072608 11316101120 1954562064 19.263 100 59 116 0 1985829808 14808128 16459616
17:30:42 11956 8192000000 10887891744 11316482048 1953432272 19.254 100 54 108 1 1982261968 13730672 15099024
17:31:02 41369 8192000000 10899948096 11339296768 1969088480 19.378 100 51 102 1 1998905488 15737888 14079120
17:31:57 32890 8192000000 10889345072 11328958464 1952593536 19.247 99 37 74 2 1982374208 18966048 10814624
17:32:59 19541 8192000000 10907683216 11338977280 1935747312 19.113 98 34 68 0 1962608704 17031360 9830032
17:33:41 7104 8192000000 10918966544 11346255872 1971765440 19.399 100 51 102 0 2007429120 20379472 15284208
17:33:55 7879 8192000000 10914235872 11341963264 1968558720 19.374 100 51 100 2 2003525760 19581232 15385808
17:34:11 3436 8192000000 10910899568 11340791808 1964962688 19.345 100 53 106 3 2002293248 21500160 15830400
17:34:23 10796 8192000000 10927828048 11354263552 1974350400 19.420 100 62 124 0 2016280624 23498160 18432064
17:34:45 8056 8192000000 10940821728 11370926080 1985706096 19.510 100 58 116 4 2027201760 24559152 16936512
17:35:11 5440 8192000000 10938515312 11371610112 1989618896 19.541 100 52 104 1 2029712144 24709472 15383776
17:35:29 9096 8192000000 10934692336 11364139008 1974736208 19.423 99 56 112 0 2021392080 29574224 17081648
17:35:46 5794 8192000000 10932812768 11364814848 1985333360 19.507 100 60 119 0 2027049392 23512416 18203616
17:36:01 4803 8192000000 10933412384 11358048256 1978245248 19.451 100 55 110 3 2020671536 25153440 17272848
17:36:13 7357 8192000000 10927609888 11351846912 1972081104 19.402 100 60 120 1 2015444176 25092464 18270608
17:36:27 1899 8192000000 10961127184 11372695552 1990507520 19.548 100 78 156 0 2042560992 27409088 24644384
17:36:37 11626 8192000000 10943024096 11377287168 1988184304 19.529 100 59 117 1 2032306928 26465584 17657040
17:36:58 2170 8192000000 10951205360 11378630656 1995588384 19.588 100 71 142 2 2044830064 26464272 22777408
17:37:09 6932 8192000000 10937041136 11365826560 1976041648 19.433 100 56 111 0 2021143888 27879888 17222352
17:37:24 5940 8192000000 10944486192 11369799680 1980926864 19.472 100 64 128 1 2029963232 29318960 19717408
17:37:39 5654 8192000000 10964495344 11383689216 1992657168 19.565 100 78 156 0 2046185328 30067808 23460352
17:37:52 2702 8192000000 10950669568 11376267264 1994090448 19.576 100 67 134 1 2036426048 22431840 19903760
17:38:01 6112 8192000000 10952884304 11375378432 1997733104 19.605 100 69 138 1 2043236976 24657200 20846672
17:38:19 1734 8192000000 10946706384 11368927232 1983953168 19.496 100 75 149 2 2031977216 24746224 23277824
17:38:31 5701 8192000000 10947281296 11373912064 1986204592 19.514 100 66 132 1 2031625904 25023376 20397936
17:38:45 3994 8192000000 10951102848 11375280128 1988031872 19.528 100 68 135 2 2035586928 26948528 20606528
17:38:58 17321 8192000000 10948559248 11385475072 1992825680 19.566 100 53 106 0 2039591872 30478992 16287200
17:39:23 6180 8192000000 10945105648 11382267904 1976617744 19.438 99 53 105 1 2024073808 30919984 16536080
17:39:37 4329 8192000000 10951051856 11382685696 1976433888 19.436 99 49 96 1 2021564976 30107296 15023792
17:39:48 3014 8192000000 10966802288 11392704512 1997387136 19.602 100 68 135 1 2050858976 31975520 21496320
17:39:59 2649 8192000000 10976827440 11391094784 1995622336 19.588 100 72 144 1 2051551856 33106976 22822544
17:40:10 1757 8192000000 10979726704 11393314816 1984250464 19.498 99 86 172 5 2046141552 35020512 26870576
17:40:19 2295 8192000000 10973493040 11388760064 1988555712 19.532 100 76 152 1 2050461456 38612768 23292976
17:40:29 4236 8192000000 10956662512 11380736000 1969133088 19.379 99 70 137 3 2029160768 38904256 21123424
17:40:39 7226 8192000000 10924400080 11362680832 1963702624 19.335 100 48 94 2 2018626704 39768096 15155984
17:40:57 9293 8192000000 10921513936 11354058752 1952401248 19.246 99 46 92 2 1999277024 32224352 14651424
17:41:14 2072 8192000000 10942604832 11363528704 1966140544 19.355 100 78 153 1 2029938224 38826288 24971392
17:41:23 8398 8192000000 10886194992 11328430080 1908265136 18.893 98 47 94 1 1961469824 38036592 15168096
17:41:41 7248 8192000000 10910028400 11340259328 1939817392 19.145 100 41 82 0 1990279728 37061392 13400944
17:41:56 3477 8192000000 10903365360 11315064832 1912198080 18.924 98 74 145 3 1973321904 38040864 23082960
17:42:05 4966 8192000000 10929059792 11348197376 1939779760 19.145 99 74 148 2 2004285472 41828528 22677184
17:42:18 1358 8192000000 10921982864 11329155072 1915659824 18.952 98 86 171 0 1985319136 43913136 25746176
17:42:28 3988 8192000000 10913524656 11332624384 1927706672 19.049 99 59 117 1 1990613360 45308400 17598288
17:42:43 13896 8192000000 10884160448 11320315904 1894689264 18.784 98 33 66 1 1945066400 39400128 10977008
17:43:04 6492 8192000000 10916520640 11347574784 1944311776 19.181 100 50 100 3 1998783424 38538400 15933248
17:43:30 12168 8192000000 10906472560 11343237120 1916287280 18.957 98 43 86 2 1969986304 39502784 14196240
17:43:55 7027 8192000000 10898479296 11322167296 1918063440 18.971 99 57 115 3 1977712640 42147616 17501584
17:44:09 1133 8192000000 10919006880 11320287232 1917952048 18.970 99 89 175 2 1993090704 48586896 26551760
17:44:17 2707 8192000000 10933529440 11354103808 1937895296 19.130 100 76 153 0 2018896448 57281664 23719488
17:44:30 8356 8192000000 10914939296 11348340736 1926465168 19.039 99 41 83 0 1987709696 48765936 12478592
17:44:45 10791 8192000000 10920347520 11356422144 1942045232 19.163 100 32 64 0 2001302240 48807056 10449952
17:45:06 13784 8192000000 10906173696 11350863872 1908868448 18.898 98 32 63 3 1969585360 50081504 10635408
17:45:27 4209 8192000000 10904157040 11346423808 1920519536 18.991 99 46 92 3 1984905824 49340736 15045552
17:45:50 12637 8192000000 10899237376 11333517312 1914224736 18.941 99 33 66 1 1974169856 48816352 11128768
17:46:19 20530 8192000000 10893116720 11331325952 1902303984 18.845 99 29 57 1 1965502976 53277232 9921760
17:46:46 13058 8192000000 10905488272 11345928192 1924082288 19.020 100 30 60 0 1992066704 57904592 10079824
17:47:07 10314 8192000000 10906835216 11352813568 1929359344 19.062 100 24 48 2 1988477552 50995376 8122832
17:47:35 22790 8192000000 10922520864 11354464256 1936650000 19.120 100 37 73 0 1998017952 49753024 11614928
17:48:09 17991 8192000000 10890433520 11331514368 1892051264 18.762 98 30 60 3 1956992656 54616352 10325040
17:48:53 20290 8192000000 10888347344 11345293312 1908236816 18.892 100 17 34 2 1968899696 54243760 6419120
17:49:20 17873 8192000000 10893831568 11346939904 1912023008 18.923 100 16 32 0 1975155920 56813488 6319424
17:49:49 45224 8192000000 10877883280 11334045696 1904900592 18.866 100 19 38 0 1969261168 57385904 6974672
17:50:48 54657 8192000000 10855308944 11345788928 1879155264 18.658 98 11 22 1 1928237344 45038624 4043456
17:51:49 40276 8192000000 10858963984 11292590080 1878788768 18.655 98 15 30 0 1900595440 17550800 4255872
17:52:37 15869 8192000000 10879757920 11320664064 1935498400 19.111 100 43 86 1 1959482016 11398336 12585280
17:53:07 17263 8192000000 10869128640 11327877120 1940465712 19.150 100 30 60 1 1963659280 13677520 9516048
17:53:34 96013 8192000000 10853458064 11326091264 1873113264 18.609 97 13 26 1 1895921872 18922368 3886240
17:55:17 151349 8192000000 10851640640 11301171200 1893154304 18.771 98 15 30 1 1911122432 13255168 4712960
17:57:55 144238 8192000000 10883121632 11335307264 1933091344 19.092 99 22 44 0 1951393552 12519808 5782400
18:00:26 7912 8192000000 10909180800 11346161664 1964380864 19.341 100 52 103 4 1991954752 13080512 14493376
18:00:43 65365 8192000000 10894345664 11363872768 1964315968 19.340 100 14 29 1 1978989792 10459904 4213920
18:01:55 58253 8192000000 10891158656 11366367232 1970474720 19.389 100 12 24 0 1984129888 10162544 3492624
18:03:00 12752 8192000000 10889662480 11362033664 1955334752 19.269 99 6 12 1 1966899520 10129232 1435536
18:03:19 23385 8192000000 10892565344 11361521664 1969646592 19.383 100 23 47 2 1983877024 7638944 6591488
18:03:51 78388 8192000000 10899712192 11373604864 1970288096 19.388 99 20 40 1 1987139904 11333536 5518272
18:05:16 48952 8192000000 10908083376 11369590784 1962459600 19.326 99 19 38 1 1980201888 12041456 5700832
18:06:13 46906 8192000000 10901953632 11372417024 1975737040 19.431 100 15 30 2 1990902336 11294048 3871248
18:08:21 73031 8192000000 10887279424 11349549056 1943470704 19.174 98 13 26 1 1958102112 10704048 3927360
18:10:01 70746 8192000000 10918711152 11381780480 1984305408 19.499 100 29 58 1 2002256672 10109392 7841872
18:11:25 95564 8192000000 10895606144 11380199424 1964991072 19.346 99 33 64 1 1984799952 10633904 9174976
18:13:16 21357 8192000000 10897004608 11375931392 1983378432 19.491 100 15 30 1 1995968208 8173920 4415856
18:13:47 32112 8192000000 10905128528 11381055488 1982186560 19.482 100 13 26 1 1994411600 8797904 3427136
18:14:29 62956 8192000000 10897450864 11373174784 1971046176 19.394 99 11 22 0 1985506784 11124160 3336448
18:15:48 66400 8192000000 10919898176 11394158592 1983328608 19.491 99 16 32 1 1999944064 12275600 4339856
18:17:18 63671 8192000000 10929453360 11404550144 1998414832 19.610 100 28 56 3 2019460496 12490384 8555280
18:18:31 112309 8192000000 10898235216 11376963584 1943481008 19.175 97 15 30 1 1956882784 9251120 4150656
18:20:31 29999 8192000000 10882567344 11350581248 1873203888 18.610 94 21 42 1 1887788288 8799824 5784576
18:21:14 26653 8192000000 10931687456 11378040832 1977375472 19.444 100 42 84 0 1999925312 10558816 11991024
18:21:49 37109 8192000000 10896486736 11374379008 1960412304 19.309 99 26 52 0 1979006064 11570784 7022976
18:22:50 31056 8192000000 10900089824 11373371392 1940994224 19.155 98 34 69 0 1965248000 14605776 9648000
18:23:29 49880 8192000000 10881205120 11358728192 1913312800 18.933 97 19 38 1 1933961072 15113792 5534480
18:24:25 66942 8192000000 10864418960 11344748544 1904124144 18.859 97 13 26 0 1921699488 13967856 3607488
18:25:38 18069 8192000000 10878263472 11341131776 1937871808 19.130 99 23 47 0 1953429296 8793680 6763808
18:26:03 40792 8192000000 10898564096 11363848192 1949973824 19.226 99 30 60 0 1971863280 13324048 8565408
18:26:58 35314 8192000000 10893197264 11354824704 1922099904 19.004 98 20 40 2 1946228560 18745888 5382768
18:27:41 100272 8192000000 10856615920 11328311296 1818384112 18.164 93 15 30 0 1832478192 10027584 4066496
18:29:35 70943 8192000000 10858756128 11317043200 1795599632 17.978 92 18 36 0 1811272416 10732416 4940368
18:30:52 93265 8192000000 10861019776 11339177984 1844895936 18.381 95 11 22 0 1867131184 18783120 3452128
18:32:34 76806 8192000000 10859156288 11306131456 1779558912 17.846 92 11 22 0 1793385968 10317344 3509712
18:33:57 16954 8192000000 10854244720 11293564928 1888194656 18.731 98 41 81 4 1912694464 12939648 11560160
18:34:20 99182 8192000000 10805219200 11265896448 1842828544 18.364 96 41 82 0 1867874048 13590784 11454720
18:36:09 82842 8192000000 10818993280 11271454720 1757791488 17.666 92 23 46 0 1772363248 7989776 6581984
18:37:42 49830 8192000000 10785630704 11254726656 1814526960 18.133 96 18 36 0 1836849008 17372528 4949520
18:38:41 73276 8192000000 10824347552 11292090368 1880898992 18.672 99 11 22 1 1896678720 12652544 3127184
18:40:01 39253 8192000000 10843954640 11313893376 1915066416 18.947 100 11 22 0 1928254352 10364304 2823632
18:40:46 53462 8192000000 10860560160 11319799808 1908341536 18.893 99 14 28 1 1921765232 9549344 3874352
18:42:06 61956 8192000000 10827615744 11298803712 1902722656 18.848 98 13 26 0 1918825616 12108272 3994688
18:43:14 59512 8192000000 10858749600 11341324288 1941256944 19.157 100 13 26 1 1958826864 13817360 3752560
18:44:50 36261 8192000000 10878326288 11338403840 1935945440 19.114 99 40 79 1 1957042704 9855920 11241344
18:45:42 49525 8192000000 10882081600 11350458368 1950733456 19.232 100 10 20 0 1964854448 11326000 2794992
18:46:49 72716 8192000000 10872525568 11339530240 1867239536 18.562 95 25 49 2 1888835808 14630320 6965952
18:48:22 69364 8192000000 10885333584 11339841536 1906788000 18.881 98 22 45 0 1929934736 16599088 6547648
18:49:42 74472 8192000000 10902342592 11367161856 1959717808 19.304 100 22 44 3 1977293248 11394240 6181200
18:51:09 54167 8192000000 10919524256 11377807360 1974052544 19.418 100 34 68 2 1995236576 12084656 9099376
18:52:12 31022 8192000000 10920518416 11374141440 1960763312 19.312 99 40 78 0 1986393120 14778064 10851744
18:52:51 44488 8192000000 10947182496 11394342912 1984497776 19.500 100 37 74 1 2011335024 15928464 10908784
18:54:10 35917 8192000000 10928463008 11382841344 1964383184 19.341 99 28 56 1 1983086624 11257072 7446368
18:54:53 62899 8192000000 10920902464 11403550720 1969458992 19.381 99 31 62 1 1997072400 18121936 9491472
18:56:13 100407 8192000000 10911396480 11379126272 1939668432 19.144 98 11 22 0 1962987728 20332432 2986864
18:58:04 92645 8192000000 10921752592 11369885696 1927046464 19.043 97 38 76 0 1946512960 9149056 10317440
18:59:51 22485 8192000000 10904724416 11376717824 1985492064 19.508 100 36 72 0 2005330496 10222048 9616384
19:00:24 30083 8192000000 10904388096 11382534144 1988114976 19.529 100 15 30 0 2000073328 7176048 4782304
19:01:12 62874 8192000000 10918607792 11395678208 1992909456 19.567 100 11 22 1 2006258912 10391920 2957536
19:02:37 78616 8192000000 10922363984 11392557056 1950220576 19.228 98 12 24 1 1965984672 12411088 3353008
19:04:33 37341 8192000000 10908030960 11370221568 1937501520 19.127 97 33 66 1 1963941696 16122240 10317936
19:05:40 40609 8192000000 10914661376 11389652992 1984261552 19.498 100 21 42 0 2006561664 15377088 6923024
19:06:43 70087 8192000000 10908299232 11389648896 1931052560 19.075 97 22 44 0 1951000064 13748832 6198672
19:08:00 107483 8192000000 10906501200 11390803968 1948748416 19.217 98 11 22 1 1971361312 19034528 3578368
19:09:53 48587 8192000000 10901009680 11361566720 1917923296 18.970 97 17 33 0 1934367056 11867552 4576208
19:10:48 29390 8192000000 10904169200 11350880256 1935744656 19.113 98 45 90 2 1957051360 7968144 13338560
19:11:25 27327 8192000000 10901824768 11361312768 1943008656 19.171 99 36 73 2 1962840416 9953264 9878496
19:12:04 36856 8192000000 10896289264 11350585344 1926910256 19.042 98 32 65 2 1945718192 9979392 8828544
19:12:53 41492 8192000000 10899506416 11351994368 1897795840 18.809 97 39 78 1 1919613632 10747792 11070000
19:13:50 50314 8192000000 10885974176 11357790208 1951218800 19.236 100 13 26 2 1964867280 10245168 3403312
19:15:09 14147 8192000000 10905141520 11346145280 1954391168 19.261 100 43 84 0 1974546448 8254352 11900928
19:15:30 22556 8192000000 10876126656 11336110080 1903608800 18.855 97 35 69 1 1923326576 9970272 9747504
19:16:02 89309 8192000000 10861934192 11334152192 1888099312 18.730 97 13 26 2 1900002208 8489520 3413376
19:17:37 83509 8192000000 10835201536 11305676800 1863135360 18.529 96 32 63 0 1884059680 11183760 9740560
19:19:09 37144 8192000000 10839575264 11289825280 1842968400 18.365 96 16 32 0 1856859280 9406112 4484768
19:19:53 72539 8192000000 10835421664 11309244416 1881554752 18.678 98 13 26 2 1898226816 13173952 3498112
19:21:53 42834 8192000000 10849419232 11317313536 1916632400 18.960 100 13 26 1 1933780352 12765376 4382576
19:22:47 76807 8192000000 10849127296 11305938944 1816080400 18.146 94 24 48 0 1834086912 11013776 6992736
19:24:14 64695 8192000000 10814637088 11286253568 1833804240 18.290 96 18 36 0 1846734368 7589872 5340256
19:25:27 59198 8192000000 10843207392 11305627648 1868494512 18.572 98 15 30 0 1880604064 7846512 4263040
19:26:35 36332 8192000000 9556549824 9976037376 613867184 6.971 32 5 10 0 624310224 8949776 1493264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-12-2020 19:28:35 to 15-12-2020 19:29:05.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-12-2020 19:29:06 to 15-12-2020 19:29:08.

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          248881
MON$OLDEST_ACTIVE               248882
MON$OLDEST_SNAPSHOT             248882
MON$NEXT_TRANSACTION            248882
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                       2039712
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 ---
:87: 
:88: mscs-test-161.budzdorov.ru    Tue Dec 15 19:27:13 2020
:89:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:90: 
:91: 
:92: mscs-test-161.budzdorov.ru    Tue Dec 15 19:27:16 2020
:93:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:94: 
--- end of diff output ---

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

15.12.20 19:29:09. 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-15 19:29:12 No severe PSQL-related problems occured
15.12.20 19:29:13. End of report.