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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17304088 kB
MemAvailable 31689220 kB
Buffers 0 kB
Cached 14421864 kB
SwapCached 1916 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-27 16:31:38
DTS_END                         2020-11-27 16:31:38.3580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43660
TRN_ID                          240732
ATT_ID                          701
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: 9742.66 20615 1169119
customer order: creation 170.53 346 20464
customer order: refuse 14.48 323 1737
order to supplier: creation 46.69 1191 5603
order to supplier: removal 3.52 98338 422
invoice (draft): creation 45.71 3151 5485
invoice (draft): removal 58.23 704 6987
invoice accept: apply 41.19 17682 4943
invoice accept: cancel 53.54 710 6425
customer reserve: creation 3790.63 176 454875
customer reserve: removal 5211.24 50 625349
realization accept: apply 80.59 188 9671
realization accept: cancel 96.66 104 11599
payment from customer: creation 58.88 131 7065
payment from customer: removal 6.04 74 725
payment to supplier: creation 49.09 140 5891
payment to supplier: removal 3.25 72 390
service: total inventory turnovers 4.96 1192 595
service: total monetary turnovers 6.57 33 788
service: aggregate perf. data 0.84 20464 101
service: refresh index statistics 0.03 267238 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-11-2020 16:33:19 to 27-11-2020 16:33:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 924
TEST_TIME 2 2702
TEST_TIME 3 4076
TEST_TIME 4 5429
TEST_TIME 5 5966
TEST_TIME 6 5757
TEST_TIME 7 5882
TEST_TIME 8 6090
TEST_TIME 9 5997
TEST_TIME 10 6151
TEST_TIME 11 5921
TEST_TIME 12 5838
TEST_TIME 13 6057
TEST_TIME 14 6281
TEST_TIME 15 6557
TEST_TIME 16 6738
TEST_TIME 17 7268
TEST_TIME 18 7411
TEST_TIME 19 7500
TEST_TIME 20 8318
TEST_TIME 21 8438
TEST_TIME 22 8698
TEST_TIME 23 8815
TEST_TIME 24 9123
TEST_TIME 25 9266
TEST_TIME 26 9687
TEST_TIME 27 10461
TEST_TIME 28 11190
TEST_TIME 29 11067
TEST_TIME 30 10943
TEST_TIME 31 10912
TEST_TIME 32 11142
TEST_TIME 33 11009
TEST_TIME 34 10886
TEST_TIME 35 10859
TEST_TIME 36 10883
TEST_TIME 37 10679
TEST_TIME 38 10591
TEST_TIME 39 10476
TEST_TIME 40 10533
TEST_TIME 41 10461
TEST_TIME 42 10336
TEST_TIME 43 10338
TEST_TIME 44 10269
TEST_TIME 45 10216
TEST_TIME 46 10297
TEST_TIME 47 10208
TEST_TIME 48 10227
TEST_TIME 49 10124
TEST_TIME 50 10068
TEST_TIME 51 9945
TEST_TIME 52 10064
TEST_TIME 53 10030
TEST_TIME 54 10090
TEST_TIME 55 10015
TEST_TIME 56 10173
TEST_TIME 57 10131
TEST_TIME 58 10099
TEST_TIME 59 10205
TEST_TIME 60 10275
TEST_TIME 61 10269
TEST_TIME 62 10335
TEST_TIME 63 10259
TEST_TIME 64 10322
TEST_TIME 65 10320
TEST_TIME 66 10175
TEST_TIME 67 10137
TEST_TIME 68 10111
TEST_TIME 69 10006
TEST_TIME 70 9965
TEST_TIME 71 9933
TEST_TIME 72 9861
TEST_TIME 73 9918
TEST_TIME 74 9896
TEST_TIME 75 9836
TEST_TIME 76 9855
TEST_TIME 77 9877
TEST_TIME 78 9923
TEST_TIME 79 9875
TEST_TIME 80 9960
TEST_TIME 81 9959
TEST_TIME 82 9933
TEST_TIME 83 10041
TEST_TIME 84 10060
TEST_TIME 85 10015
TEST_TIME 86 9974
TEST_TIME 87 9952
TEST_TIME 88 9933
TEST_TIME 89 9883
TEST_TIME 90 9870
TEST_TIME 91 9794
TEST_TIME 92 9753
TEST_TIME 93 9701
TEST_TIME 94 9729
TEST_TIME 95 9735
TEST_TIME 96 9681
TEST_TIME 97 9734
TEST_TIME 98 9793
TEST_TIME 99 9887
TEST_TIME 100 9859
TEST_TIME 101 9824
TEST_TIME 102 9934
TEST_TIME 103 10023
TEST_TIME 104 9976
TEST_TIME 105 10004
TEST_TIME 106 9964
TEST_TIME 107 10008
TEST_TIME 108 9940
TEST_TIME 109 9901
TEST_TIME 110 9887
TEST_TIME 111 9823
TEST_TIME 112 9870
TEST_TIME 113 9792
TEST_TIME 114 9773
TEST_TIME 115 9760
TEST_TIME 116 9738
TEST_TIME 117 9759
TEST_TIME 118 9771
TEST_TIME 119 9744
TEST_TIME 120 9743

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-11-2020 16:33:23 to 27-11-2020 16:33:26.

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 1592771 1592771 0 0.00 0 24345 6 0 0
doc_list_biud 1592768 1592768 0 0.00 0 25059 26 0 0
sp_add_invoice_to_stock 5084 4943 141 2.77 31 172692 17682 0 141
sp_cancel_adding_invoice 6425 6425 0 0.00 4 51491 710 0 0
sp_cancel_client_order 1737 1737 0 0.00 4 18204 323 0 0
sp_cancel_customer_reserve 625349 625349 0 0.00 1 25064 51 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 2 3378 74 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 2114 72 0 0
sp_cancel_supplier_invoice 6994 6987 7 0.10 2 23052 704 0 7
sp_cancel_supplier_order 422 422 0 0.00 9 1060129 98339 0 0
sp_cancel_write_off 11599 11599 0 0.00 1 24770 105 0 0
sp_client_order 20464 20464 0 0.00 3 23870 346 0 0
sp_customer_reserve 454875 454875 0 0.00 0 64556 176 0 0
sp_fill_shopping_cart 31551 31551 0 0.00 1 22961 38 0 0
sp_fill_shopping_cart_clo_res 454875 454875 0 0.00 0 26648 13 0 0
sp_get_clo_for_invoice 4943 4943 0 0.00 0 29913 282 0 0
sp_kill_cost_storno 19139 19139 0 0.00 0 12237 53 0 0
sp_kill_qstorno_ret_qs2qd 1269706 1269706 0 0.00 0 24331 28 0 0
sp_kill_qty_storno 667130 667130 0 0.00 0 25058 60 0 0
sp_lock_selected_doc 20345 20345 0 0.00 0 10648 7 0 0
sp_make_cost_storno 27570 27570 0 0.00 0 24344 56 0 0
sp_multiply_rows_for_pdistr 27570 27570 0 0.00 0 6638 27 0 0
sp_multiply_rows_for_qdistr 20464 20464 0 0.00 0 17682 143 0 0
sp_pay_from_customer 7065 7065 0 0.00 4 12142 132 0 0
sp_pay_to_supplier 5891 5891 0 0.00 5 24350 141 0 0
sp_payment_common 12956 12956 0 0.00 1 11435 33 0 0
sp_qd_handle_on_cancel_clo 1737 1737 0 0.00 0 18190 298 0 0
sp_qd_handle_on_invoice_upd_sts 11368 11368 0 0.00 0 22676 331 0 0
sp_qd_handle_on_reserve_upd_sts 9668 9668 0 0.00 0 17353 63 0 0
sp_reserve_write_off 9671 9671 0 0.00 6 21257 189 0 0
sp_supplier_invoice 5485 5485 0 0.00 7 106209 3151 0 0
sp_supplier_order 5603 5603 0 0.00 4 38767 1192 0 0
srv_aggregate_perf_data 101 101 0 0.00 2576 430910 20465 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1162 149222 32347 0 0
srv_find_qd_qs_mism 1122914 1122914 0 0.00 0 19948 5 0 0
srv_make_invnt_saldo 595 595 0 0.00 28 111892 1192 0 0
srv_make_money_saldo 788 788 0 0.00 1 4847 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 158042 405576 267239 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4943 4943 0 0.00 0 15890 193 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 5429 94 0 0
t$perf-norm:sp_cancel_client_order 1737 1737 0 0.00 0 9278 15 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 7077 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 3979 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 505 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 4063 24 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 20761 1646 0 0
t$perf-norm:sp_cancel_write_off 1009 1009 0 0.00 0 6325 23 0 0
t$perf-norm:sp_client_order 20464 20464 0 0.00 0 7863 18 0 0
t$perf-norm:sp_customer_reserve 967 967 0 0.00 0 5950 20 0 0
t$perf-norm:sp_pay_from_customer 7065 7065 0 0.00 0 14938 13 0 0
t$perf-norm:sp_pay_to_supplier 5891 5891 0 0.00 0 8021 16 0 0
t$perf-norm:sp_reserve_write_off 9671 9671 0 0.00 0 5948 12 0 0
t$perf-norm:sp_supplier_invoice 5485 5485 0 0.00 0 17001 26 0 0
t$perf-norm:sp_supplier_order 5603 5603 0 0.00 0 5451 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 406 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 2546 18 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 1447 21 0 0
t$perf-norm:srv_make_money_saldo 788 788 0 0.00 0 1603 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10168 9886 282 2.77 0 9178 22 0 282
v_all_customers 37774 37774 0 0.00 0 18 1 0 0
v_all_suppliers 30486 30486 0 0.00 0 19 1 0 0
v_all_wares 40928 40928 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 636 8 0 0
v_cancel_client_order 3474 3474 0 0.00 0 2156 7 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 2738 6 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 5524 9 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 2099 8 0 0
v_cancel_supplier_invoice 760 746 14 1.84 0 5357 24 0 14
v_cancel_supplier_order 844 844 0 0.00 0 525 3 0 0
v_cancel_write_off 2018 2018 0 0.00 0 5756 16 0 0
v_max_id_clo_ord 5603 5603 0 0.00 0 516 1 0 0
v_max_id_clo_res 967 967 0 0.00 0 3408 13 0 0
v_max_id_ord_sup 5484 5484 0 0.00 0 3366 6 0 0
v_max_non_paid_invoice 1735 1735 0 0.00 0 1027 3 0 0
v_max_non_paid_realizn 3586 3586 0 0.00 0 3173 4 0 0
v_min_id_clo_ord 5603 5603 0 0.00 0 3352 5 0 0
v_min_id_clo_res 967 967 0 0.00 0 1530 4 0 0
v_min_id_ord_sup 5484 5484 0 0.00 0 4988 10 0 0
v_min_non_paid_invoice 5891 5891 0 0.00 0 10720 21 0 0
v_min_non_paid_realizn 7065 7065 0 0.00 0 11235 23 0 0
v_our_firm 10112 10112 0 0.00 0 17 1 0 0
v_reserve_write_off 19336 19336 0 0.00 0 5367 8 0 0
x_lock_depdocs_on_canc_invoice 13039 13039 0 0.00 0 14894 105 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 16182 419 0 0
x_make_qstorno_1000_1200 5603 5603 0 0.00 1 38760 1110 0 0
x_make_qstorno_1200_2000 5485 5485 0 0.00 3 106194 3020 0 0
x_make_qstorno_2100_3300 454875 454875 0 0.00 0 64555 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-11-2020 16:33:27 to 27-11-2020 16:33:31.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:41 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:48 29269 8192000000 10298125264 10612879360 968034272 10.568 73 59 118 0 989894768 2813776 19046720
14:02:27 29200 8192000000 10364199056 10683883520 1415094976 14.729 100 85 171 1 1448021904 5692912 27234016
14:03:06 30154 8192000000 10393308656 10721419264 1449645088 15.035 100 88 176 0 1486249312 7523280 29080944
14:03:48 13058 8192000000 10409814496 10738696192 1465893792 15.178 100 87 174 1 1502980448 8549168 28537488
14:04:12 24089 8192000000 10433047872 10765643776 1484136576 15.338 100 86 172 1 1521222736 9201104 27885056
14:04:45 23897 8192000000 10451283568 10784370688 1501374800 15.488 100 92 184 3 1541010688 9864000 29771888
14:05:22 14376 8192000000 10461040816 10800308224 1515009632 15.607 100 84 168 2 1551702464 10006672 26686160
14:05:58 10286 8192000000 10484612912 10832498688 1547806576 15.891 100 80 160 0 1583099936 10026512 25266848
14:06:18 23590 8192000000 10530677152 10883796992 1572918592 16.107 100 79 158 0 1607504080 10209184 24376304
14:06:50 12814 8192000000 10547224736 10903732224 1605503888 16.386 100 80 160 0 1641029280 11024672 24500720
14:07:12 13235 8192000000 10580996864 10936352768 1624476080 16.548 100 78 156 0 1659024304 11380640 23167584
14:07:33 11522 8192000000 10588835632 10949701632 1644328688 16.716 100 83 166 3 1681676528 12290256 25057584
14:07:51 14123 8192000000 10610572976 10972065792 1658957680 16.840 100 87 173 1 1697080448 12467600 25655168
14:08:14 8466 8192000000 10616398496 10985189376 1678043328 17.001 100 81 162 1 1714524640 12978640 23502672
14:08:30 8444 8192000000 10634358864 11000258560 1688090544 17.085 100 83 166 0 1725521264 13028656 24402064
14:08:47 5495 8192000000 10641348080 11011887104 1699025568 17.177 100 80 160 0 1735251264 12707920 23517776
14:09:00 7327 8192000000 10653658480 11025637376 1706634784 17.241 100 78 156 0 1741365728 11689808 23041136
14:09:14 6422 8192000000 10659811968 11039326208 1722808032 17.376 100 80 157 5 1757406720 11643552 22955136
14:09:28 5660 8192000000 10672260848 11046817792 1737150448 17.495 100 83 166 0 1772930976 12216608 23563920
14:09:41 6308 8192000000 10687171760 11064647680 1748005728 17.585 100 84 166 1 1783053120 12749408 22297984
14:09:55 4678 8192000000 10689322224 11064004608 1756373568 17.654 100 82 164 1 1792605168 13843056 22388544
14:10:09 4873 8192000000 10714443840 11092934656 1767299712 17.745 100 89 178 1 1806364800 14567408 24497680
14:10:20 3499 8192000000 10717934160 11093143552 1774548144 17.805 100 85 170 2 1812282352 14220224 23513984
14:10:31 3521 8192000000 10719033280 11098263552 1777431792 17.828 100 84 167 0 1814238560 14043920 22762848
14:10:41 4427 8192000000 10719894720 11106271232 1787899776 17.915 100 85 170 1 1825250272 13092624 24257872
14:10:52 2872 8192000000 10744713152 11124711424 1795677360 17.978 100 92 184 1 1835504224 13734272 26092592
14:11:01 8316 8192000000 10740927584 11124183040 1804942688 18.054 100 86 172 1 1842165024 13715728 23506608
14:11:18 4776 8192000000 10752036400 11139252224 1811922800 18.112 100 77 152 3 1846047344 13357216 20767328
14:11:30 2344 8192000000 10776257584 11160829952 1829366704 18.254 100 92 183 2 1869623344 14465632 25791008
14:11:38 1970 8192000000 10770462432 11157929984 1832854096 18.283 100 89 177 1 1872267360 14034288 25378976
14:11:47 2297 8192000000 10775587328 11165614080 1837862176 18.323 100 88 174 0 1876593232 13350688 25380368
14:11:55 2065 8192000000 10787190768 11174445056 1843939440 18.373 100 93 186 1 1884218064 13466160 26812464
14:12:04 2362 8192000000 10796507264 11181858816 1848558208 18.410 100 92 182 3 1888961648 14246368 26157072
14:12:13 1890 8192000000 10800255840 11188965376 1857486512 18.483 100 95 188 2 1898703888 14662496 26554880
14:12:21 1521 8192000000 10804861504 11194970112 1858910704 18.494 100 89 178 1 1897685232 13690224 25084304
14:12:29 2205 8192000000 10808650320 11199242240 1863849168 18.534 100 95 190 2 1904843072 13388272 27605632
14:12:38 1850 8192000000 10807579904 11194990592 1861231248 18.513 100 90 180 0 1899904336 12321680 26351408
14:12:46 2166 8192000000 10811369712 11199320064 1864093200 18.536 100 93 186 2 1903756016 13097920 26564896
14:12:55 1989 8192000000 10809627360 11200339968 1867768960 18.566 100 92 185 1 1907133376 13179216 26185200
14:13:03 2429 8192000000 10803546240 11204841472 1871586864 18.597 100 80 161 1 1906234304 12348576 22298864
14:13:14 35624 8192000000 10810213824 11209977856 1868827424 18.575 100 55 108 2 1890209904 5704304 15678176
14:13:56 20055 8192000000 10787056976 11208937472 1871320096 18.595 100 40 80 2 1890531488 7940768 11270624
14:14:23 9113 8192000000 10774563184 11206021120 1868583536 18.573 100 24 48 0 1882035072 6619872 6831664
14:14:41 5218 8192000000 10786524128 11214172160 1878056080 18.649 100 28 56 2 1892899280 7143024 7700176
14:14:52 7759 8192000000 10783552208 11215142912 1877970080 18.649 100 28 55 3 1891777248 6410224 7396944
14:15:13 2995 8192000000 10812785312 11228753920 1886232928 18.715 100 44 88 0 1905792352 7037808 12521616
14:15:26 6160 8192000000 10798183168 11226562560 1887508272 18.726 100 28 56 1 1902787504 7417184 7862048
14:15:40 6166 8192000000 10798024992 11231768576 1888344688 18.732 100 30 58 2 1903789408 6943728 8500992
14:15:53 9586 8192000000 10794697648 11229925376 1890032368 18.746 100 18 36 1 1901389840 5871520 5485952
14:16:09 9392 8192000000 10802391904 11232296960 1892281472 18.764 100 16 32 0 1902972736 5828912 4862352
14:16:27 8364 8192000000 10813139008 11243352064 1896038672 18.794 100 26 52 0 1914019424 10519184 7461568
14:16:42 13316 8192000000 10796223232 11236765696 1896897872 18.801 100 19 38 0 1908700544 5690816 6111856
14:17:03 9145 8192000000 10799122704 11242446848 1900831136 18.833 100 21 40 3 1913425904 6831888 5762880
14:17:21 8457 8192000000 10808711680 11245989888 1900158656 18.828 100 17 34 2 1911199952 6239952 4801344
14:17:36 11752 8192000000 10831209536 11254009856 1906390576 18.878 100 19 37 2 1917725440 6625536 4709328
14:17:55 71911 8192000000 10816881488 11260534784 1911189888 18.916 100 24 47 1 1924089728 5605888 7293952
14:19:17 6440 8192000000 10818765840 11261288448 1913864528 18.938 100 25 52 1 1926782688 5971168 6946992
14:19:31 5965 8192000000 10839338448 11272585216 1913682496 18.936 100 23 44 3 1929624640 9851984 6090160
14:19:44 4143 8192000000 10840186160 11274006528 1922020912 19.003 100 48 96 1 1943293232 7685632 13586688
14:20:01 6663 8192000000 10839776208 11277017088 1921306912 18.997 100 29 58 0 1935428240 6176224 7945104
14:20:14 6984 8192000000 10836056288 11277070336 1923392032 19.014 100 33 66 1 1938928688 6891776 8644880
14:20:28 6169 8192000000 10821928800 11267989504 1920842288 18.994 100 33 66 5 1936400736 6040992 9517456
14:20:41 9407 8192000000 10830882592 11264749568 1897981440 18.810 99 20 40 0 1908994864 5651088 5362336
14:20:57 9133 8192000000 10804638704 11247398912 1858723616 18.493 97 11 22 1 1867540512 5522320 3294576
14:21:17 6554 8192000000 10818644544 11254165504 1902595728 18.847 100 22 43 1 1914613632 6329088 5688816
14:21:29 9660 8192000000 10801185472 11232833536 1843752800 18.371 97 26 50 3 1855906592 5026592 7127200
14:21:49 12804 8192000000 10800688864 11225972736 1836600608 18.313 97 17 34 0 1846640960 5380528 4659824
14:22:08 9294 8192000000 10764090608 11196411904 1788939472 17.923 95 18 36 1 1799264640 5151664 5173504
14:22:24 73095 8192000000 10737237168 11167248384 1687700432 17.082 90 32 64 2 1702282080 4429712 10151936
14:23:44 10666 8192000000 10745542112 11161305088 1788494192 17.919 98 26 52 3 1805781520 10479584 6807744
14:24:03 9085 8192000000 10740563712 11154288640 1745527424 17.565 95 22 45 0 1757129696 5061936 6540336
14:24:21 5431 8192000000 10742035568 11164508160 1825600336 18.223 100 27 54 4 1839874592 6763968 7510288
14:24:33 6133 8192000000 10709363680 11123720192 1742329392 17.538 96 29 58 1 1757328928 5824608 9174928
14:24:47 3987 8192000000 10732986240 11156963328 1821866512 18.193 100 29 58 1 1836676768 6307792 8502464
14:24:59 5219 8192000000 10705725488 11117006848 1770268768 17.769 99 35 70 0 1785719456 5457504 9993184
14:25:11 6432 8192000000 10714182352 11116273664 1743070112 17.544 97 24 47 2 1755011472 4988800 6952560
14:25:23 9065 8192000000 10684647632 11098542080 1723651552 17.383 96 18 36 1 1734967296 5762048 5553696
14:25:39 6324 8192000000 10679626160 11092193280 1740655648 17.524 98 21 42 1 1752774672 6153504 5965520
14:25:52 5985 8192000000 10689015040 11098226688 1754290128 17.637 99 22 43 3 1766899328 6031344 6577856
14:26:07 8307 8192000000 10724792976 11137830912 1779134704 17.842 99 32 64 3 1794307984 5616192 9557088
14:26:22 7066 8192000000 10736486048 11143757824 1777614240 17.830 98 33 64 2 1791705360 4335824 9755296
14:26:37 14445 8192000000 10726280880 11146207232 1810341984 18.099 100 11 22 0 1818729696 5094736 3292976
14:26:57 68060 8192000000 10740681504 11169861632 1830564944 18.264 100 34 68 2 1844550288 4857104 9128240
14:28:14 6853 8192000000 10757651600 11180568576 1822194080 18.196 99 35 69 0 1844347104 11187568 10965456
14:28:28 5748 8192000000 10763776288 11183747072 1843242560 18.367 100 38 76 1 1861159072 7670912 10245600
14:28:41 7002 8192000000 10770353984 11189518336 1850643584 18.427 100 34 68 0 1866668208 5966896 10057728
14:28:56 4460 8192000000 10773291056 11195510784 1854912864 18.462 100 35 70 2 1871590304 6114496 10562944
14:29:08 8720 8192000000 10766584336 11196203008 1853090064 18.447 100 25 50 1 1866830624 6376592 7363968
14:29:23 9119 8192000000 10769478800 11195035648 1858101984 18.488 100 28 54 2 1872007360 5796960 8108416
14:29:40 7900 8192000000 10774770768 11197968384 1856560768 18.475 100 29 57 0 1871306688 5729968 9015952
14:29:54 8979 8192000000 10771512224 11199504384 1858147648 18.488 100 30 60 4 1872718784 6169216 8401920
14:30:14 8701 8192000000 10788796560 11211792384 1861075664 18.512 100 20 40 3 1875919504 9436784 5407056
14:30:33 5954 8192000000 10780426704 11208273920 1860926768 18.511 100 14 27 1 1869807376 4704992 4175616
14:30:47 12177 8192000000 10781738640 11211882496 1865071792 18.544 100 16 32 0 1874889552 5211552 4606208
14:31:08 6197 8192000000 10792779696 11222519808 1883875952 18.696 100 21 41 3 1895086320 5036000 6174368
14:31:20 9140 8192000000 10807446320 11232862208 1887666752 18.727 100 15 30 2 1896485520 4278224 4540544
14:31:36 109053 8192000000 10841934064 11260641280 1898296800 18.813 100 33 66 0 1912795472 4820960 9677712
14:33:36 15738 8192000000 10848824768 11269873664 1916693696 18.960 100 57 114 2 1941975216 9119616 16161904
14:34:00 10239 8192000000 10849742400 11272830976 1919141632 18.980 100 36 72 0 1938460672 9173456 10145584
14:34:17 6599 8192000000 10863881488 11282690048 1929720864 19.065 100 62 124 1 1957029632 9562544 17746224
14:34:30 5549 8192000000 10864687888 11283685376 1929609008 19.064 100 51 102 1 1953814336 9762944 14442384
14:34:42 19677 8192000000 10860142144 11289919488 1932119552 19.084 100 47 94 0 1956311872 10731936 13460384
14:35:09 6793 8192000000 10881649696 11303215104 1942249616 19.165 100 66 128 1 1971389232 9874544 19265072
14:35:25 11140 8192000000 10877044592 11302678528 1947121952 19.204 100 57 113 0 1972949552 9781232 16046368
14:35:45 7076 8192000000 10882160832 11307761664 1946577712 19.199 100 54 106 0 1972713648 9882240 16253696
14:35:58 28515 8192000000 10888661312 11316228096 1949582352 19.223 100 56 112 0 1976287184 11240800 15464032
14:36:34 8927 8192000000 10904985392 11330199552 1961196688 19.316 100 55 110 0 1992029808 14915456 15917664
14:36:50 6005 8192000000 10892991040 11324624896 1961703680 19.320 100 52 102 1 1988861568 12610512 14547376
14:37:04 4966 8192000000 10899896352 11328569344 1965885216 19.353 100 60 120 2 1997059808 13221424 17953168
14:37:16 3896 8192000000 10904178784 11324485632 1958730688 19.296 100 73 145 1 1992865696 13641968 20493040
14:37:36 7888 8192000000 10906914208 11327299584 1964474784 19.342 100 64 129 2 1996803472 14736608 17592080
14:37:55 10500 8192000000 10909148032 11336482816 1968240368 19.371 100 64 128 4 2003213280 16300064 18672848
14:38:16 10893 8192000000 10898318832 11331465216 1969925280 19.385 100 48 96 1 1998046864 14761024 13360560
14:38:43 10684 8192000000 10917162960 11343892480 1974362576 19.420 100 63 124 3 2011916416 19360480 18193360
14:39:01 9632 8192000000 10915835952 11337351168 1968292928 19.372 100 64 128 0 2003075440 16193600 18588912
14:39:19 2365 8192000000 10914632128 11328753664 1959309120 19.301 99 68 136 0 1996385488 16968816 20107552
14:39:30 19173 8192000000 10912241072 11348295680 1975427312 19.428 100 53 104 2 2005050000 14850848 14771840
14:40:00 5723 8192000000 10914703824 11335753728 1954829072 19.265 99 63 126 0 1990839232 17512576 18497584
14:40:15 37524 8192000000 10904268560 11340824576 1949457664 19.222 99 47 94 2 1981825472 18424384 13943424
14:41:01 9606 8192000000 10913068784 11350962176 1971980368 19.401 100 35 70 0 2004711744 22673264 10058112
14:41:19 9445 8192000000 10913953120 11351859200 1957450336 19.286 99 41 80 0 1987790496 18055504 12284656
14:41:36 4495 8192000000 10916886496 11359064064 1976752256 19.439 100 29 58 1 2008793888 23199904 8841728
14:41:55 13659 8192000000 10916203664 11358560256 1969821840 19.384 99 43 86 3 2006293504 23756880 12714784
14:42:16 12313 8192000000 10905036832 11343720448 1964969280 19.346 100 40 80 0 1997783248 20241104 12572864
14:42:47 14025 8192000000 10922767376 11360759808 1961437936 19.317 99 44 86 1 1996158688 21635248 13085504
14:43:13 13385 8192000000 10928296672 11359682560 1977577888 19.446 100 45 90 2 2016037904 24371008 14089008
14:43:35 8308 8192000000 10941322352 11377496064 1986822416 19.519 100 43 86 1 2028203344 28007632 13373296
14:43:53 9086 8192000000 10939407376 11379867648 1986176928 19.514 100 46 92 1 2030881088 30527632 14176528
14:44:10 6466 8192000000 10962014016 11391602688 1999067360 19.615 100 61 122 0 2046997376 29045360 18884656
14:44:24 14378 8192000000 10933402224 11360985088 1956481792 19.278 98 58 113 2 2004697632 30709904 17505936
14:44:48 3411 8192000000 10945453872 11359748096 1969375792 19.380 99 72 140 2 2025112976 34016336 21720848
14:45:00 6682 8192000000 10953516736 11379466240 1971399152 19.397 99 60 119 1 2023423632 33922240 18102240
14:45:15 6724 8192000000 10957973904 11385597952 1992027952 19.560 100 61 122 1 2045170672 34685120 18457600
14:45:31 3284 8192000000 10981036128 11391823872 1997748464 19.605 100 87 173 2 2061679776 38162048 25769264
14:45:41 2394 8192000000 10965876304 11381473280 1981671072 19.478 100 89 177 0 2047733808 38600592 27462144
14:45:50 1711 8192000000 10961452496 11372441600 1984362672 19.499 100 90 180 2 2047947056 37107184 26477200
14:46:00 3845 8192000000 10933875504 11343876096 1955170448 19.268 99 79 158 3 2016356640 36918816 24267376
14:46:14 3117 8192000000 10943821504 11364462592 1979050240 19.457 100 75 151 2 2038951504 37406304 22494960
14:46:26 2214 8192000000 10961947344 11377004544 1969136096 19.379 99 77 155 2 2035046176 42272768 23637312
14:46:35 2267 8192000000 10941864880 11355910144 1961319056 19.317 100 76 152 2 2026796832 42736768 22741008
14:46:48 2582 8192000000 10917293232 11328544768 1939813808 19.145 99 67 134 0 2001291392 40892720 20584864
14:46:58 5724 8192000000 10947370960 11359883264 1964535568 19.342 100 74 146 2 2026834688 39954400 22344720
14:47:13 3500 8192000000 10927995744 11337105408 1936931440 19.122 99 79 158 3 2002301440 40585904 24784096
14:47:23 3583 8192000000 10938315104 11348029440 1950629840 19.231 100 74 146 0 2014988992 41464448 22894704
14:47:34 2112 8192000000 10941718560 11347247104 1938682272 19.136 99 88 172 1 2009230784 43157440 27391072
14:47:44 3158 8192000000 10945721696 11350581248 1962022992 19.322 100 84 164 1 2031743504 43492448 26228064
14:47:53 1581 8192000000 10960659072 11365117952 1970103808 19.386 100 89 179 2 2042504784 45093376 27307600
14:48:01 5412 8192000000 10953190416 11356635136 1931732672 19.081 98 82 163 0 2001601088 44986688 24881728
14:48:15 2522 8192000000 10953877520 11362893824 1970053664 19.386 100 76 151 2 2036379552 44317920 22007968
14:48:24 1881 8192000000 10963537568 11368607744 1968948320 19.377 100 83 166 2 2041232928 47136608 25148000
14:48:32 6651 8192000000 10938675376 11364208640 1950700320 19.232 99 56 112 3 2014845536 46776752 17368464
14:48:47 7227 8192000000 10911023712 11330240512 1903832128 18.857 97 45 90 2 1962145680 43627568 14685984
14:49:04 1886 8192000000 10933456672 11345555456 1944444160 19.182 100 66 131 0 2011430992 45677792 21309040
14:49:14 6874 8192000000 10933088096 11352584192 1946353712 19.197 100 58 116 0 2012989008 47761776 18873520
14:49:27 2253 8192000000 10930210160 11345747968 1937457920 19.126 100 65 128 0 2007174480 49449264 20267296
14:49:39 3014 8192000000 10923126688 11333705728 1905577392 18.871 98 74 145 2 1980178240 51422064 23178784
14:49:55 1749 8192000000 10931832384 11343134720 1923118976 19.012 99 79 158 0 1999214880 51028368 25067536
14:50:04 2624 8192000000 10907516144 11312746496 1913499872 18.935 99 84 168 0 1992483424 52573408 26410144
14:50:14 3282 8192000000 10928243408 11331706880 1927275568 19.045 100 81 159 1 2005638672 53241392 25121712
14:50:23 4112 8192000000 10939284784 11339280384 1931309040 19.077 100 82 162 1 2011452352 54221696 25921616
14:50:36 3567 8192000000 10946709552 11355238400 1945789040 19.193 100 82 164 0 2027630368 55577504 26263824
14:50:50 3336 8192000000 10949988432 11362656256 1951393424 19.238 100 78 154 1 2032566048 57022160 24150464
14:51:01 1308 8192000000 10967469584 11368050688 1959589120 19.303 100 92 184 1 2044380464 56249904 28541440
14:51:09 1258 8192000000 10982269168 11381243904 1967806880 19.368 100 94 187 0 2054839840 58087904 28945056
14:51:18 4243 8192000000 10974385440 11384258560 1968845952 19.376 100 83 164 1 2054179488 59067520 26266016
14:51:29 2146 8192000000 10977660464 11387498496 1973280480 19.411 100 80 162 0 2056669120 57913424 25475216
14:51:38 7631 8192000000 10961743648 11395375104 1973031296 19.409 100 58 116 1 2050538752 58613088 18894368
14:51:56 10551 8192000000 10948194992 11386888192 1975381504 19.428 100 43 86 1 2038071376 48241728 14448144
14:52:14 14624 8192000000 10937457008 11361988608 1939856992 19.146 99 49 96 1 2003006096 46996336 16152768
14:52:35 10378 8192000000 10942411232 11379908608 1963083472 19.331 100 52 103 1 2031475792 50976272 17416048
14:52:54 5667 8192000000 10951211712 11384627200 1969976064 19.385 100 43 86 2 2034480064 49839280 14664720
14:53:10 15498 8192000000 10921505168 11361099776 1928270160 19.053 98 37 74 0 1989477696 48248784 12958752
14:53:35 14633 8192000000 10933058128 11369615360 1958036960 19.290 100 36 71 1 2016470784 46297104 12136720
14:53:59 14420 8192000000 10926218960 11370369024 1941219408 19.156 99 32 64 2 1999732768 47711184 10802176
14:54:46 27365 8192000000 10927220336 11374178304 1928141712 19.052 99 26 50 0 1995385824 58323600 8920512
14:55:19 23197 8192000000 10920833392 11371016192 1943094000 19.171 100 25 50 1 2006240096 54059808 9086288
14:55:55 9849 8192000000 10942568656 11387260928 1948811280 19.217 100 35 70 1 2019010768 57986960 12212528
14:56:25 9102 8192000000 10947932880 11393556480 1958481104 19.294 100 31 62 1 2033727936 63345008 11901824
14:56:41 16044 8192000000 10952899936 11406213120 1962594304 19.327 100 24 48 1 2034306336 62154928 9557104
14:57:03 31212 8192000000 10938138064 11392118784 1942184480 19.164 99 29 56 3 2012663152 59718096 10760576
14:57:41 27213 8192000000 10935613984 11385851904 1950506816 19.231 100 31 60 1 2016301696 55063072 10731808
14:58:19 45908 8192000000 10922170224 11385135104 1954179072 19.260 100 19 38 2 2013956176 52937488 6839616
14:59:11 73349 8192000000 10899976848 11354546176 1931046256 19.075 98 16 32 1 1946806112 10996896 4762960
15:00:34 48793 8192000000 10884406800 11346432000 1931057248 19.075 98 18 36 0 1951219248 14366480 5795520
15:01:37 55046 8192000000 10908055232 11361304576 1949267872 19.221 99 26 51 1 1968723456 12217328 7238256
15:02:38 87346 8192000000 10879606272 11350757376 1933113296 19.092 98 12 24 1 1950756880 14449312 3194272
15:04:12 69795 8192000000 10903265008 11357999104 1933931248 19.098 98 17 34 2 1948102864 10224176 3947440
15:05:30 32968 8192000000 10895995520 11357147136 1966467056 19.357 100 23 46 1 1983269184 10860720 5941408
15:06:12 111914 8192000000 10904151072 11372818432 1903356160 18.853 96 5 10 0 1914709408 10051328 1301920
15:08:10 41164 8192000000 10910658160 11350593536 1958499760 19.294 99 38 75 1 1979429584 10571280 10358544
15:09:14 149221 8192000000 10901141648 11365916672 1936267552 19.117 98 22 44 0 1957429744 13364544 7797648
15:11:51 48287 8192000000 10910188192 11383070720 1957332880 19.285 99 22 44 1 1975859872 12767072 5759920
15:12:55 89091 8192000000 10904818800 11374485504 1924148400 19.020 97 21 40 1 1939119920 8467888 6503632
15:14:32 28534 8192000000 10909621936 11368370176 1961630464 19.319 99 21 40 1 1976661968 9264912 5766592
15:15:10 17299 8192000000 10951420512 11384582144 1990635264 19.549 100 60 119 1 2016720672 9342544 16742864
15:15:37 35038 8192000000 10942342144 11395194880 1979050224 19.457 99 61 122 0 2007276944 11355968 16870752
15:16:20 60811 8192000000 10917266448 11399520256 1974890048 19.424 99 24 48 1 1997375760 15046496 7439216
15:17:28 42185 8192000000 10914128832 11393458176 1991367696 19.555 100 13 26 1 2005777536 10262432 4147408
15:18:17 29117 8192000000 10909216928 11389583360 1973460016 19.413 99 10 20 1 1985860464 9375264 3025184
15:18:53 33994 8192000000 10922221552 11400335360 1991007120 19.552 100 12 24 0 2003321936 9162560 3152256
15:19:33 23264 8192000000 10915243920 11403870208 1994609568 19.580 100 5 10 0 2004024192 8080352 1334272
15:20:02 1162 8192000000 10915334048 11403272192 1995177904 19.585 100 3 6 0 2004048704 8107328 763472
15:20:09 63223 8192000000 10915546288 11397021696 1976118608 19.434 99 13 26 0 1990491056 10303280 4069168
15:21:19 20418 8192000000 10915482208 11405570048 1992733056 19.565 100 8 16 0 2004223328 9126592 2363680
15:21:53 52103 8192000000 10922506032 11398336512 1980335344 19.467 99 20 38 0 1998138192 12276928 5525920
15:23:08 64349 8192000000 10924266368 11414016000 1980063776 19.465 99 15 30 1 2000063344 15880704 4118864
15:24:21 61862 8192000000 10923564976 11424641024 1999090048 19.616 100 10 20 0 2021740096 20025712 2624336
15:25:41 44257 8192000000 10910248000 11388579840 1938181664 19.132 97 10 19 1 1948446000 7652656 2611680
15:26:33 37674 8192000000 10936816480 11399712768 1995774768 19.589 100 28 56 0 2013618320 9938128 7905424
15:27:17 40841 8192000000 10908056880 11388133376 1950744512 19.232 98 16 32 0 1966270064 11002048 4523504
15:28:05 53911 8192000000 10930013200 11390283776 1940018000 19.147 97 30 61 3 1959947488 11175424 8754064
15:29:06 19437 8192000000 10926435072 11382239232 1973329472 19.412 100 50 100 0 2001012720 12909008 14774240
15:29:34 55781 8192000000 10916269776 11386363904 1960246816 19.308 99 33 66 2 1983777008 14456960 9073232
15:30:37 64543 8192000000 10879148784 11361570816 1895342800 18.789 96 15 30 3 1916727152 16820336 4564016
15:31:50 97827 8192000000 10895925984 11369394176 1878159024 18.650 95 13 26 0 1896051184 14362992 3529168
15:33:36 51840 8192000000 10896405344 11350687744 1878381120 18.652 96 9 18 0 1888012848 7845360 1786368
15:34:34 27429 8192000000 10921390880 11355299840 1915523456 18.951 97 48 96 1 1941587424 12668112 13395856
15:35:12 30833 8192000000 10881940784 11333763072 1910371808 18.910 98 34 68 1 1936581088 16517536 9691744
15:35:50 34713 8192000000 10850341216 11333861376 1893419024 18.773 98 15 30 0 1914725680 17258672 4047984
15:36:37 66726 8192000000 10847766480 11302731776 1877827824 18.648 97 28 56 0 1901797888 15333200 8636864
15:37:51 38701 8192000000 10861008928 11320307712 1915842144 18.954 99 33 65 0 1933915488 9177696 8895648
15:38:36 29156 8192000000 10876552704 11340394496 1941573328 19.159 100 24 47 2 1962748800 14834000 6341472
15:39:12 17226 8192000000 10859382416 11325714432 1903742384 18.856 98 31 62 0 1925440480 12888272 8809824
15:39:43 14882 8192000000 10854552128 11332517888 1931948656 19.082 100 7 13 0 1943482288 9548752 1984880
15:40:04 71135 8192000000 10856467264 11329343488 1884173216 18.699 97 10 20 0 1900489536 13763984 2552336
15:41:32 66666 8192000000 10858880032 11346038784 1929117120 19.060 100 8 16 0 1946125152 14757712 2250320
15:42:49 50363 8192000000 10844073184 11316912128 1874381232 18.620 97 15 30 0 1892143680 13654416 4108032
15:43:50 33472 8192000000 10832605392 11311341568 1868728944 18.574 97 12 23 1 1885216272 13390320 3097008
15:44:30 58020 8192000000 10836772592 11308376064 1884503136 18.701 98 20 39 3 1899501328 9557472 5440720
15:45:34 40239 8192000000 10839412768 11313430528 1901384928 18.837 99 11 22 0 1911131936 6877408 2869600
15:46:26 42606 8192000000 10881520848 11335847936 1920914320 18.994 99 35 69 1 1942128960 10728096 10486544
15:47:20 84478 8192000000 10868720848 11336470528 1902279872 18.845 98 13 25 2 1920225520 14442320 3503328
15:48:56 83545 8192000000 10875317664 11357229056 1911146000 18.916 98 17 34 2 1928268048 12521200 4600848
15:50:52 68377 8192000000 10876497552 11365441536 1942993664 19.171 99 26 52 3 1963701200 13583136 7124400
15:52:11 50434 8192000000 10890549728 11343794176 1907163680 18.884 98 16 32 1 1924149136 12901328 4084128
15:53:08 11543 8192000000 10915865024 11362627584 1955750400 19.272 100 42 84 1 1982676592 15502496 11423696
15:53:27 9116 8192000000 10901499664 11343413248 1916456320 18.958 98 55 109 0 1945201856 13748864 14996672
15:53:43 20661 8192000000 10907807008 11367071744 1954908224 19.266 100 46 92 0 1985609360 17697344 13003792
15:54:37 142402 8192000000 10899386240 11363213312 1925886560 19.034 99 11 22 1 1943273536 14840384 2546592
15:57:09 87556 8192000000 10891761504 11362889728 1946373120 19.198 99 17 34 0 1964208096 13150016 4684960
15:58:50 107738 8192000000 10903671760 11383234560 1972453264 19.405 100 19 38 1 1987553312 9561520 5538528
16:00:50 40007 8192000000 10913560608 11390464000 1990979296 19.552 100 39 79 0 2013951552 12336032 10636224
16:01:40 90403 8192000000 10909012176 11390902272 1974603808 19.422 99 11 22 0 1988839696 11582512 2653376
16:03:16 39627 8192000000 10918787744 11396050944 1994524240 19.580 100 10 20 0 2009649888 11994608 3131040
16:04:06 50772 8192000000 10920823600 11405410304 1997850768 19.606 100 15 30 1 2012970832 11302080 3817984
16:05:03 76003 8192000000 10918048416 11399729152 1934751120 19.105 97 11 22 2 1951256848 13751824 2753904
16:06:26 63276 8192000000 10919126336 11394879488 1915596704 18.952 96 20 37 0 1941511312 20270416 5644192
16:07:50 38156 8192000000 10961836128 11424370688 2008083648 19.686 100 43 87 1 2040280704 19847120 12349936
16:08:40 50536 8192000000 10941177920 11426058240 1995919760 19.591 100 15 30 0 2023114080 22741584 4452736
16:10:37 65461 8192000000 10945134576 11415539712 1999926800 19.622 100 24 46 1 2020453040 13834160 6692080
16:11:52 66072 8192000000 10940779152 11399565312 1914163296 18.940 95 26 52 0 1936108352 14539216 7405840
16:13:07 50837 8192000000 10925581952 11418009600 1968047856 19.370 99 10 20 0 1992480880 20594416 3838608
16:15:27 144304 8192000000 10916548336 11355709440 1786328880 17.902 90 22 44 0 1805140112 12903008 5908224
16:18:04 33943 8192000000 10906295056 11368984576 1936810272 19.121 99 35 70 0 1958761312 12408624 9542416
16:19:07 99083 8192000000 10888000336 11355975680 1924791024 19.025 98 30 60 1 1943966944 9931792 9244128
16:20:52 89820 8192000000 10874450720 11351085056 1898233728 18.812 97 14 28 1 1910039856 7652416 4153712
16:22:42 77215 8192000000 10874508880 11368628224 1935144624 19.108 99 11 22 2 1948152736 10001024 3007088
16:24:49 71066 8192000000 10884419792 11367157760 1930537968 19.071 98 21 42 2 1961581952 25072416 5971568
16:26:06 74756 8192000000 10876840816 11361894400 1928461824 19.055 98 14 28 0 1949226416 16572224 4192368
16:27:34 69437 8192000000 10883856144 11374886912 1940844224 19.153 99 18 36 1 1964019680 17322480 5852976
16:28:55 67602 8192000000 10890446976 11371884544 1937358928 19.126 99 19 38 0 1957107840 14594432 5154480
16:30:22 57840 8192000000 10874091712 11357728768 1928920848 19.058 99 21 42 2 1947527216 12666784 5939584
16:31:38 10778 8192000000 9318759408 9598943232 472670880 5.455 25 2 3 0 476539472 3317632 550960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-11-2020 16:33:33 to 27-11-2020 16:34:05.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-11-2020 16:34:06 to 27-11-2020 16:34: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          241002
MON$OLDEST_ACTIVE               241003
MON$OLDEST_SNAPSHOT             241003
MON$NEXT_TRANSACTION            241003
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                       2062368
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Fri Nov 27 16:31:55 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

27.11.20 16:34: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-11-27 16:34:11 No severe PSQL-related problems occured
27.11.20 16:34:12. End of report.