Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.12.2020 22: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 17271632 kB
MemAvailable 31413080 kB
Buffers 0 kB
Cached 14390440 kB
SwapCached 4820 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-30 22:27:10
DTS_END                         2020-12-30 22:27:10.6050
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/49856
TRN_ID                          244027
ATT_ID                          650
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: 9323.58 21093 1118830
customer order: creation 176.36 358 21163
customer order: refuse 14.43 331 1731
order to supplier: creation 46.31 1278 5557
order to supplier: removal 3.41 107372 409
invoice (draft): creation 47.24 3421 5669
invoice (draft): removal 53.32 805 6398
invoice accept: apply 42.59 19105 5111
invoice accept: cancel 47.68 913 5722
customer reserve: creation 3930.52 189 471662
customer reserve: removal 4660.21 61 559225
realization accept: apply 84.70 205 10164
realization accept: cancel 83.21 114 9985
payment from customer: creation 60.34 141 7241
payment from customer: removal 6.31 93 757
payment to supplier: creation 50.37 148 6044
payment to supplier: removal 3.88 94 465
service: total inventory turnovers 5.06 1252 607
service: total monetary turnovers 6.76 31 811
service: aggregate perf. data 0.88 20191 105
service: refresh index statistics 0.03 265749 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 30-12-2020 22:28:16 to 30-12-2020 22:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7085
TEST_TIME 2 4656
TEST_TIME 3 5135
TEST_TIME 4 5532
TEST_TIME 5 5558
TEST_TIME 6 5690
TEST_TIME 7 5741
TEST_TIME 8 5663
TEST_TIME 9 5581
TEST_TIME 10 5873
TEST_TIME 11 5908
TEST_TIME 12 6078
TEST_TIME 13 6167
TEST_TIME 14 6166
TEST_TIME 15 6241
TEST_TIME 16 6297
TEST_TIME 17 6510
TEST_TIME 18 6492
TEST_TIME 19 6772
TEST_TIME 20 7172
TEST_TIME 21 7659
TEST_TIME 22 8860
TEST_TIME 23 8860
TEST_TIME 24 9121
TEST_TIME 25 9304
TEST_TIME 26 10126
TEST_TIME 27 10504
TEST_TIME 28 10711
TEST_TIME 29 10634
TEST_TIME 30 10505
TEST_TIME 31 10532
TEST_TIME 32 10494
TEST_TIME 33 10686
TEST_TIME 34 10636
TEST_TIME 35 10506
TEST_TIME 36 10264
TEST_TIME 37 10116
TEST_TIME 38 10064
TEST_TIME 39 10163
TEST_TIME 40 10022
TEST_TIME 41 9978
TEST_TIME 42 9897
TEST_TIME 43 9931
TEST_TIME 44 9942
TEST_TIME 45 9839
TEST_TIME 46 9781
TEST_TIME 47 9712
TEST_TIME 48 9827
TEST_TIME 49 9690
TEST_TIME 50 9606
TEST_TIME 51 9615
TEST_TIME 52 9594
TEST_TIME 53 9735
TEST_TIME 54 9648
TEST_TIME 55 9705
TEST_TIME 56 9784
TEST_TIME 57 9808
TEST_TIME 58 9794
TEST_TIME 59 9835
TEST_TIME 60 9834
TEST_TIME 61 9877
TEST_TIME 62 9929
TEST_TIME 63 9971
TEST_TIME 64 10006
TEST_TIME 65 10019
TEST_TIME 66 9891
TEST_TIME 67 9861
TEST_TIME 68 9840
TEST_TIME 69 9778
TEST_TIME 70 9775
TEST_TIME 71 9713
TEST_TIME 72 9660
TEST_TIME 73 9590
TEST_TIME 74 9527
TEST_TIME 75 9647
TEST_TIME 76 9565
TEST_TIME 77 9543
TEST_TIME 78 9656
TEST_TIME 79 9611
TEST_TIME 80 9705
TEST_TIME 81 9668
TEST_TIME 82 9642
TEST_TIME 83 9721
TEST_TIME 84 9663
TEST_TIME 85 9729
TEST_TIME 86 9718
TEST_TIME 87 9754
TEST_TIME 88 9691
TEST_TIME 89 9621
TEST_TIME 90 9583
TEST_TIME 91 9527
TEST_TIME 92 9521
TEST_TIME 93 9457
TEST_TIME 94 9390
TEST_TIME 95 9448
TEST_TIME 96 9400
TEST_TIME 97 9499
TEST_TIME 98 9483
TEST_TIME 99 9498
TEST_TIME 100 9531
TEST_TIME 101 9524
TEST_TIME 102 9475
TEST_TIME 103 9550
TEST_TIME 104 9591
TEST_TIME 105 9568
TEST_TIME 106 9616
TEST_TIME 107 9601
TEST_TIME 108 9547
TEST_TIME 109 9482
TEST_TIME 110 9528
TEST_TIME 111 9500
TEST_TIME 112 9446
TEST_TIME 113 9424
TEST_TIME 114 9405
TEST_TIME 115 9395
TEST_TIME 116 9398
TEST_TIME 117 9363
TEST_TIME 118 9351
TEST_TIME 119 9371
TEST_TIME 120 9326

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-12-2020 22:28:20 to 30-12-2020 22:28:23.

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 1557119 1557119 0 0.00 0 26284 7 0 0
doc_list_biud 1557118 1557118 0 0.00 0 18532 28 0 0
sp_add_invoice_to_stock 5230 5111 119 2.27 33 194949 19105 0 119
sp_cancel_adding_invoice 5722 5722 0 0.00 5 54792 913 0 0
sp_cancel_client_order 1731 1731 0 0.00 4 11487 332 0 0
sp_cancel_customer_reserve 559225 559225 0 0.00 1 18533 61 0 0
sp_cancel_pay_from_customer 757 757 0 0.00 3 5912 93 0 0
sp_cancel_pay_to_supplier 465 465 0 0.00 3 5771 94 0 0
sp_cancel_supplier_invoice 6410 6398 12 0.18 2 14746 805 0 12
sp_cancel_supplier_order 409 409 0 0.00 6 1136743 107372 0 0
sp_cancel_write_off 9985 9985 0 0.00 1 16663 115 0 0
sp_client_order 21163 21163 0 0.00 3 17799 359 0 0
sp_customer_reserve 471662 471662 0 0.00 0 73850 190 0 0
sp_fill_shopping_cart 32385 32385 0 0.00 1 13551 39 0 0
sp_fill_shopping_cart_clo_res 471660 471660 0 0.00 0 14462 13 0 0
sp_get_clo_for_invoice 5109 5109 0 0.00 0 24545 279 0 0
sp_kill_cost_storno 16929 16929 0 0.00 0 9664 66 0 0
sp_kill_qstorno_ret_qs2qd 1135242 1135242 0 0.00 0 16955 33 0 0
sp_kill_qty_storno 598743 598743 0 0.00 0 18531 72 0 0
sp_lock_selected_doc 21265 21265 0 0.00 0 9903 8 0 0
sp_make_cost_storno 28558 28558 0 0.00 0 26208 62 0 0
sp_multiply_rows_for_pdistr 28558 28558 0 0.00 0 11300 37 0 0
sp_multiply_rows_for_qdistr 21162 21162 0 0.00 0 11716 154 0 0
sp_pay_from_customer 7241 7241 0 0.00 4 10398 141 0 0
sp_pay_to_supplier 6044 6044 0 0.00 5 21366 148 0 0
sp_payment_common 13285 13285 0 0.00 1 21316 50 0 0
sp_qd_handle_on_cancel_clo 1731 1731 0 0.00 0 10630 309 0 0
sp_qd_handle_on_invoice_upd_sts 10831 10831 0 0.00 0 16274 359 0 0
sp_qd_handle_on_reserve_upd_sts 10164 10164 0 0.00 0 17419 56 0 0
sp_reserve_write_off 10164 10164 0 0.00 6 17459 205 0 0
sp_supplier_invoice 5669 5669 0 0.00 7 71887 3422 0 0
sp_supplier_order 5557 5557 0 0.00 5 21937 1278 0 0
srv_aggregate_perf_data 105 105 0 0.00 2611 386337 20191 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1317 109956 31085 0 0
srv_find_qd_qs_mism 1070679 1070679 0 0.00 0 19086 6 0 0
srv_make_invnt_saldo 607 607 0 0.00 35 114321 1253 0 0
srv_make_money_saldo 811 811 0 0.00 0 2053 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 188747 297173 265749 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5112 5112 0 0.00 0 21502 186 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 5116 114 0 0
t$perf-norm:sp_cancel_client_order 1731 1731 0 0.00 0 2623 13 0 0
t$perf-norm:sp_cancel_customer_reserve 738 738 0 0.00 0 2961 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 757 757 0 0.00 0 543 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 465 465 0 0.00 0 441 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 433 433 0 0.00 0 2670 20 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 26969 1650 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 4085 17 0 0
t$perf-norm:sp_client_order 21163 21163 0 0.00 0 6486 17 0 0
t$perf-norm:sp_customer_reserve 1069 1069 0 0.00 0 789 7 0 0
t$perf-norm:sp_pay_from_customer 7241 7241 0 0.00 0 5292 10 0 0
t$perf-norm:sp_pay_to_supplier 6044 6044 0 0.00 0 6978 12 0 0
t$perf-norm:sp_reserve_write_off 10164 10164 0 0.00 0 8857 12 0 0
t$perf-norm:sp_supplier_invoice 5669 5669 0 0.00 0 5068 17 0 0
t$perf-norm:sp_supplier_order 5557 5557 0 0.00 0 13768 20 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 231 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 304 6 0 0
t$perf-norm:srv_make_invnt_saldo 607 607 0 0.00 0 1236 28 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 5069 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10454 10216 238 2.27 0 4524 18 0 238
v_all_customers 38370 38370 0 0.00 0 18 1 0 0
v_all_suppliers 31060 31060 0 0.00 0 96 1 0 0
v_all_wares 42320 42320 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 1993 12 0 0
v_cancel_client_order 3462 3462 0 0.00 0 1565 4 0 0
v_cancel_customer_prepayment 1514 1514 0 0.00 0 1424 5 0 0
v_cancel_customer_reserve 1476 1476 0 0.00 0 1405 5 0 0
v_cancel_payment_to_supplier 930 930 0 0.00 0 2110 8 0 0
v_cancel_supplier_invoice 890 866 24 2.69 0 587 14 0 24
v_cancel_supplier_order 818 818 0 0.00 0 367 3 0 0
v_cancel_write_off 2118 2118 0 0.00 0 5339 22 0 0
v_max_id_clo_ord 5557 5557 0 0.00 0 1456 2 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 2994 14 0 0
v_max_id_ord_sup 5668 5668 0 0.00 0 4867 5 0 0
v_max_non_paid_invoice 1739 1739 0 0.00 0 4930 7 0 0
v_max_non_paid_realizn 3902 3902 0 0.00 0 6064 7 0 0
v_min_id_clo_ord 5557 5557 0 0.00 0 4501 6 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 6501 23 0 0
v_min_id_ord_sup 5668 5668 0 0.00 0 9287 16 0 0
v_min_non_paid_invoice 6044 6044 0 0.00 0 21313 35 0 0
v_min_non_paid_realizn 7241 7241 0 0.00 0 10313 38 0 0
v_our_firm 10628 10628 0 0.00 0 20 1 0 0
v_reserve_write_off 20326 20326 0 0.00 0 3425 5 0 0
x_lock_depdocs_on_canc_invoice 11687 11687 0 0.00 0 21046 121 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 5952 332 0 0
x_make_qstorno_1000_1200 5557 5557 0 0.00 2 21930 1196 0 0
x_make_qstorno_1200_2000 5669 5669 0 0.00 3 71836 3283 0 0
x_make_qstorno_2100_3300 471662 471662 0 0.00 0 73849 174 0 0

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

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
19:57:13 4 8192000000 8800931168 8812138496 6918096 0.084 2 1 2 0 7037472 56816 62560
19:57:20 8510 8192000000 10156829184 10450862080 875696992 9.657 72 53 106 0 896957728 2393328 18867408
19:57:37 21675 8192000000 10314390064 10628911104 1355126576 14.194 100 86 172 0 1388220000 4124080 28969344
19:58:09 41475 8192000000 10379637376 10700681216 1423155152 14.801 100 86 172 0 1456733680 5865280 27713248
19:59:02 11977 8192000000 10391615968 10716327936 1450490720 15.042 100 88 176 0 1486698672 6958624 29249328
19:59:23 14518 8192000000 10408148640 10734284800 1462572064 15.149 100 91 182 0 1499655232 7373616 29709552
19:59:46 23846 8192000000 10417182656 10747531264 1471147936 15.224 100 82 164 0 1505320144 7345008 26827200
20:00:21 17609 8192000000 10431482480 10763497472 1487550624 15.367 100 85 170 0 1522509344 7838320 27120400
20:00:50 11147 8192000000 10451642032 10784587776 1507993840 15.546 100 88 176 0 1543973856 8380448 27599568
20:01:12 26499 8192000000 10479089136 10819420160 1525188048 15.695 100 86 172 0 1561322144 8911808 27222288
20:01:55 13159 8192000000 10497361936 10847731712 1561081120 16.006 100 79 158 0 1595113872 9608336 24424416
20:02:19 14565 8192000000 10549901456 10905174016 1600591008 16.344 100 79 158 0 1633860112 9569040 23700064
20:02:45 14076 8192000000 10576714592 10935549952 1629395216 16.590 100 80 160 1 1663657904 10846480 23416208
20:03:06 11621 8192000000 10599357376 10958958592 1653766944 16.796 100 85 168 0 1690432768 12031712 24634112
20:03:25 12332 8192000000 10611362032 10975498240 1667514592 16.912 100 78 156 2 1702791824 13083568 22193664
20:03:46 7346 8192000000 10641387296 11006107648 1696998768 17.160 100 83 165 1 1733530272 12901376 23630128
20:04:02 9406 8192000000 10653725936 11024408576 1714400576 17.305 100 86 172 0 1751925568 12971008 24553984
20:04:18 7135 8192000000 10664851456 11035975680 1729012624 17.427 100 77 154 1 1763760752 13223584 21524544
20:04:33 6008 8192000000 10677243360 11050102784 1736931552 17.493 100 89 178 0 1776730416 14427648 25371216
20:04:45 6762 8192000000 10690272288 11061735424 1747320640 17.579 100 86 172 1 1785863568 14589376 23953552
20:05:00 5277 8192000000 10687927344 11067838464 1751608176 17.615 100 76 150 0 1786052064 13489520 20954368
20:05:12 4844 8192000000 10697357760 11071733760 1757540176 17.664 100 76 153 0 1792236896 13186240 21510480
20:05:24 3319 8192000000 10707492304 11085045760 1765060592 17.726 100 88 176 2 1803991104 13776000 25154512
20:05:34 3727 8192000000 10719530304 11095515136 1776521232 17.821 100 84 168 1 1814093104 13698560 23873312
20:05:45 4723 8192000000 10725505136 11104092160 1779848848 17.848 100 79 158 0 1815005264 13598880 21557536
20:05:57 3928 8192000000 10722408400 11108462592 1788162560 17.917 100 76 152 0 1822193840 12684816 21346464
20:06:07 2958 8192000000 10734342736 11113799680 1797931776 17.997 100 84 167 2 1833533904 12532048 23070080
20:06:17 8305 8192000000 10736712912 11123515392 1797282032 17.992 100 75 148 4 1830142464 12227728 20632704
20:06:33 5051 8192000000 10758722560 11145801728 1811399344 18.107 100 80 160 1 1846378384 13241504 21737536
20:06:44 2681 8192000000 10765480208 11146686464 1825350288 18.221 100 82 164 1 1860781712 12725280 22706144
20:06:54 1976 8192000000 10775794064 11163144192 1834495552 18.296 100 88 176 1 1872670864 12726112 25449200
20:07:02 2523 8192000000 10782030480 11170545664 1845650080 18.387 100 84 167 1 1882113280 12893040 23570160
20:07:11 1651 8192000000 10783756672 11169878016 1845538912 18.386 100 95 187 0 1887111152 14536016 27036224
20:07:20 2087 8192000000 10796948032 11184406528 1848501408 18.410 100 89 178 1 1889138160 14958224 25678528
20:07:28 1500 8192000000 10783236672 11179896832 1851334896 18.433 100 90 178 2 1892847856 15064032 26448928
20:07:37 1854 8192000000 10799298608 11185500160 1856528032 18.475 100 92 184 2 1896232160 14047648 25656480
20:07:45 1917 8192000000 10805874384 11192418304 1858990048 18.495 100 87 174 1 1896665360 13191296 24484016
20:07:53 1993 8192000000 10801793408 11188592640 1863987584 18.536 100 90 181 0 1902517088 12531920 25997584
20:08:01 1199 8192000000 10798104432 11193421824 1862886000 18.527 100 84 169 1 1897142976 11321392 22935584
20:08:09 2303 8192000000 10810410896 11197845504 1865616496 18.549 100 90 180 3 1904339280 13431808 25290976
20:08:18 2226 8192000000 10810552048 11202023424 1869661632 18.582 100 91 183 1 1910275760 14541856 26072272
20:08:27 2788 8192000000 10815809488 11204440064 1870954288 18.592 100 92 184 0 1911132048 14282768 25894992
20:08:37 1826 8192000000 10824558304 11212918784 1877348640 18.644 100 97 190 2 1918854864 15007728 26498496
20:08:45 1429 8192000000 10817964528 11208343552 1876797088 18.639 100 96 193 0 1918802688 13839600 28166000
20:08:53 22361 8192000000 10800475616 11206377472 1873847872 18.615 100 63 123 2 1903495104 10979504 18667728
20:09:23 14501 8192000000 10812404848 11211243520 1877169680 18.642 100 68 136 1 1905831984 8416368 20245936
20:09:44 1110 8192000000 10826897616 11226656768 1882145264 18.682 100 77 154 2 1914893024 10765392 21982368
20:09:51 7670 8192000000 10808051280 11220623360 1881584816 18.678 100 56 111 0 1908115024 10830160 15700048
20:10:05 5070 8192000000 10798213216 11217620992 1879233152 18.659 100 39 78 1 1898607408 8070464 11303792
20:10:18 8082 8192000000 10798656624 11221147648 1881423456 18.677 100 28 56 0 1897098928 7992544 7682928
20:10:32 4483 8192000000 10796010336 11220602880 1885306192 18.708 100 36 73 1 1903761856 8256896 10198768
20:10:43 6868 8192000000 10792650544 11223785472 1881077888 18.674 100 22 44 1 1893793088 6600848 6114352
20:10:56 9934 8192000000 10788115536 11222171648 1883723648 18.695 100 28 57 5 1897628032 6383216 7521168
20:11:12 8454 8192000000 10799158976 11227561984 1885065488 18.706 100 19 38 1 1896999472 6379792 5554192
20:11:30 7811 8192000000 10789531520 11229327360 1890622864 18.751 100 28 56 2 1905695984 6813408 8259712
20:11:44 8178 8192000000 10796857408 11231604736 1889431136 18.741 100 20 40 0 1901288560 5928864 5928560
20:11:58 8327 8192000000 10803069136 11238776832 1893444304 18.774 100 20 41 0 1905304912 6836384 5024224
20:12:16 11129 8192000000 10805836656 11240185856 1896675296 18.800 100 21 42 3 1909347936 6634032 6038608
20:12:37 6412 8192000000 10814660560 11244347392 1901333824 18.837 100 32 64 1 1917178960 6592224 9252912
20:12:51 14139 8192000000 10805871472 11246301184 1902675056 18.848 100 18 36 1 1914255536 6738864 4841616
20:13:13 70661 8192000000 10819193472 11259781120 1908589040 18.895 100 28 56 2 1922256560 5513360 8154160
20:14:30 9250 8192000000 10819862416 11262013440 1912516448 18.927 100 16 31 1 1922596192 4897232 5182512
20:14:46 5844 8192000000 10829137472 11267825664 1914730576 18.945 100 32 64 1 1930348800 5562784 10055440
20:15:00 4097 8192000000 10841207680 11270172672 1919414656 18.982 100 29 59 3 1934487312 7184304 7888352
20:15:11 5847 8192000000 10826393152 11257081856 1907897920 18.890 100 37 75 2 1925036544 6568688 10569936
20:15:23 6666 8192000000 10821695728 11257122816 1908940112 18.898 100 32 64 1 1925212208 7037616 9234480
20:15:37 7530 8192000000 10825595664 11257016320 1893404144 18.773 99 43 87 0 1912314320 6687344 12222832
20:15:54 6352 8192000000 10827734480 11263758336 1908952592 18.898 100 31 62 2 1923209424 6279232 7977600
20:16:08 5671 8192000000 10817083024 11255738368 1891922304 18.761 99 24 48 0 1905433024 6670576 6840144
20:16:21 10479 8192000000 10812762496 11253395456 1887665184 18.727 99 26 52 1 1901001664 5656192 7680288
20:16:38 8724 8192000000 10805601696 11247792128 1886154912 18.715 99 18 36 0 1896829056 5314512 5359632
20:16:59 5326 8192000000 10808159808 11238825984 1890192944 18.747 100 22 44 1 1902238896 6054256 5991696
20:17:11 13180 8192000000 10783587344 11214217216 1855098560 18.464 98 22 43 3 1866998800 5338096 6562144
20:17:34 13446 8192000000 10767476128 11202428928 1786680960 17.904 95 13 25 1 1795819408 5706576 3431872
20:17:54 72951 8192000000 10736040144 11160719360 1677168800 16.994 90 17 34 1 1686477504 4648176 4660528
20:19:13 11434 8192000000 10735599680 11158564864 1747298864 17.579 95 28 55 2 1761557632 6557856 7700912
20:19:35 4655 8192000000 10726791184 11147313152 1801904000 18.030 98 36 72 3 1820154368 6297696 11952672
20:19:46 5201 8192000000 10753342144 11162746880 1801961792 18.030 98 32 64 3 1818284352 6850816 9471744
20:19:57 6723 8192000000 10719454096 11141439488 1785559696 17.895 98 28 54 1 1799536096 5470944 8505456
20:20:13 9502 8192000000 10730941600 11141722112 1742590464 17.540 96 21 42 0 1754505360 5157168 6757728
20:20:28 9466 8192000000 10693609584 11107360768 1692651296 17.124 94 20 40 3 1704577600 5585648 6340656
20:20:44 7440 8192000000 10714748448 11133292544 1762698720 17.707 98 20 40 2 1773457008 5281280 5477008
20:21:01 6188 8192000000 10712793472 11119890432 1753593856 17.631 97 35 68 3 1769581856 5639104 10348896
20:21:18 5822 8192000000 10719257040 11137896448 1804483136 18.051 100 29 58 2 1819863552 6623328 8757088
20:21:33 8088 8192000000 10709415232 11129933824 1781480992 17.862 99 28 56 0 1795158640 5588528 8089120
20:21:49 9175 8192000000 10705318032 11115196416 1732140288 17.453 96 21 41 1 1743152880 5094544 5918048
20:22:04 9235 8192000000 10719621072 11128844288 1768629664 17.756 98 23 45 1 1780963840 4712256 7621920
20:22:19 13434 8192000000 10719512000 11137765376 1770329568 17.770 98 13 26 1 1779172096 5283728 3558800
20:22:41 9532 8192000000 10733423808 11146858496 1796619280 17.986 99 15 30 1 1806508992 5813408 4076304
20:22:57 62570 8192000000 10737097552 11162148864 1822326128 18.197 100 27 54 0 1836427584 5546576 8554880
20:24:08 7303 8192000000 10743287872 11172806656 1832590256 18.280 100 18 36 1 1843400992 5919184 4891552
20:24:24 6433 8192000000 10750465760 11175391232 1836200992 18.310 100 23 46 1 1848492704 5522960 6768752
20:24:42 4543 8192000000 10773089536 11185082368 1849514048 18.418 100 40 79 1 1868761344 6874928 12372368
20:24:53 5575 8192000000 10769747328 11189460992 1847519008 18.402 100 30 57 1 1861917008 5582096 8815904
20:25:05 7825 8192000000 10769443264 11191996416 1850847024 18.429 100 37 72 0 1867784288 6248544 10688720
20:25:19 5562 8192000000 10767024000 11187892224 1850459264 18.426 100 35 68 0 1866054032 5504000 10090768
20:25:31 5175 8192000000 10765800720 11190394880 1851254784 18.432 100 32 64 3 1866798400 5958128 9585488
20:25:43 9834 8192000000 10770199248 11191967744 1851186368 18.432 100 30 60 1 1864782656 4728800 8867488
20:26:00 9766 8192000000 10777894192 11196645376 1853284480 18.449 100 24 46 2 1864826864 4930080 6612304
20:26:18 11079 8192000000 10786793760 11204153344 1854984160 18.463 100 25 50 1 1867749536 5279168 7486208
20:26:36 8625 8192000000 10765814848 11201675264 1860083056 18.504 100 31 62 0 1874517904 5110240 9324608
20:26:50 11427 8192000000 10774670880 11205324800 1857147072 18.480 100 13 26 2 1866171584 5338912 3685600
20:27:08 14073 8192000000 10812631232 11228356608 1877345152 18.644 100 33 65 3 1892020944 4976064 9699728
20:27:32 37535 8192000000 10796540336 11216420864 1876030912 18.633 99 34 64 1 1891801504 5956992 9813600
20:28:18 16028 8192000000 10825608976 11243905024 1898554464 18.815 100 39 78 1 1916628448 7263536 10810448
20:28:55 70739 8192000000 10841821232 11269099520 1918804320 18.977 100 53 103 3 1942494080 9153504 14536256
20:30:12 27556 8192000000 10856311392 11281817600 1925699104 19.032 100 56 110 2 1953372832 11724096 15949632
20:30:51 19571 8192000000 10862128112 11287572480 1930846240 19.074 100 50 100 0 1956794544 12248912 13699392
20:31:18 13640 8192000000 10879220208 11296800768 1939183440 19.140 100 62 123 1 1971558240 14572128 17802672
20:31:39 8643 8192000000 10883279280 11304955904 1941549488 19.159 100 59 118 2 1973297920 14712576 17035856
20:31:56 20236 8192000000 10883659312 11312209920 1943435504 19.174 100 51 101 0 1972362224 14300768 14625952
20:32:39 8268 8192000000 10895768880 11327623168 1954058656 19.259 100 43 86 0 1989760208 23213696 12487856
20:32:59 10868 8192000000 10905186784 11327459328 1951919856 19.242 100 50 101 1 1989738288 22780496 15037936
20:33:16 17094 8192000000 10910784096 11335413760 1957770064 19.288 100 61 120 1 2000094592 24962160 17362368
20:33:50 6329 8192000000 10919382560 11344470016 1964338288 19.341 100 58 113 1 2010862496 29269744 17254464
20:34:04 11462 8192000000 10912708800 11336237056 1958448592 19.294 100 46 88 1 1998483440 27172368 12862480
20:34:23 4200 8192000000 10925392720 11344023552 1967210240 19.363 100 65 130 2 2013377152 27279504 18887408
20:34:40 8423 8192000000 10927360544 11348606976 1968275872 19.372 100 57 116 0 2012895344 27438768 17180704
20:34:55 3655 8192000000 10930665888 11348779008 1972376048 19.404 100 68 136 2 2020562208 28773568 19412592
20:35:06 19906 8192000000 10930207104 11360481280 1976113744 19.434 100 60 120 0 2024572736 31123104 17335888
20:35:38 15973 8192000000 10909745328 11342712832 1957007088 19.282 99 46 92 0 2000947520 30088896 13851536
20:36:06 4941 8192000000 10929854544 11356872704 1974959248 19.425 100 47 96 0 2020037520 31340848 13737424
20:36:21 4309 8192000000 10942021216 11368341504 1982006816 19.481 100 58 116 2 2030765648 31792384 16966448
20:36:39 13864 8192000000 10945163600 11372302336 1966102096 19.355 99 59 118 0 2021523312 38024672 17396544
20:37:02 13930 8192000000 10940351696 11372466176 1982547504 19.485 100 57 113 0 2033510656 34033872 16929280
20:37:25 11018 8192000000 10924216864 11359887360 1955955056 19.274 99 44 88 3 2005061040 35556784 13549200
20:37:51 9383 8192000000 10948615952 11362476032 1968589088 19.374 100 66 132 2 2027487568 39524832 19373648
20:38:07 5325 8192000000 10947770240 11367755776 1976747360 19.439 100 67 131 1 2033682944 37832032 19103552
20:38:21 6921 8192000000 10937035408 11353612288 1959697008 19.304 99 66 131 1 2016294272 37478048 19119216
20:38:35 3896 8192000000 10919666336 11342880768 1950028352 19.227 99 60 118 0 2004879808 37410608 17440848
20:38:49 9897 8192000000 10938005520 11365699584 1975354640 19.428 100 62 124 2 2031987824 37829248 18803936
20:39:05 3359 8192000000 10944958720 11363086336 1974671712 19.422 100 78 147 3 2034294784 37427840 22195232
20:39:15 2566 8192000000 10944086736 11366850560 1960490800 19.310 99 65 131 0 2019176224 38492336 20193088
20:39:27 7435 8192000000 10931827584 11357921280 1963476160 19.334 100 58 116 0 2019866560 39028672 17361728
20:39:47 6929 8192000000 10935934096 11363495936 1957778816 19.288 99 58 116 1 2015853376 39892192 18182368
20:40:03 2908 8192000000 10970889616 11377287168 1978306816 19.451 100 84 169 1 2044852560 40839616 25706128
20:40:13 3300 8192000000 10952609024 11365425152 1970855008 19.392 100 82 162 1 2037907104 41935824 25116272
20:40:24 6797 8192000000 10954812864 11375460352 1980202160 19.466 100 63 125 2 2041358112 42487712 18668240
20:40:39 1315 8192000000 10967575072 11383500800 1990941712 19.551 100 84 169 1 2057963936 41409568 25612656
20:40:49 2883 8192000000 10952957968 11373477888 1978106176 19.450 100 86 172 1 2045489536 41778992 25604368
20:40:59 3421 8192000000 10959366912 11373629440 1976000000 19.433 100 77 150 0 2042348240 42688768 23659472
20:41:09 6337 8192000000 10949773520 11368800256 1974098544 19.418 100 68 136 0 2039870544 45187040 20584960
20:41:23 4841 8192000000 10954309936 11372949504 1972776544 19.407 100 68 136 2 2041691168 47768256 21146368
20:41:36 6467 8192000000 10961479600 11373047808 1961389536 19.317 99 71 140 1 2027894320 45374368 21130416
20:41:51 5355 8192000000 10954471280 11374510080 1959233312 19.300 99 67 134 0 2028144832 47270592 21640928
20:42:05 6595 8192000000 10949265072 11372941312 1970419472 19.389 100 59 118 0 2037561040 47876064 19265504
20:42:20 3356 8192000000 10969503232 11388207104 1982888160 19.488 100 77 151 2 2054707872 47814784 24004928
20:42:43 8819 8192000000 10956972640 11387457536 1965989184 19.354 99 51 102 1 2032025232 49342704 16693344
20:42:59 5484 8192000000 10957878880 11377790976 1969323776 19.380 100 60 119 1 2039354096 50506576 19523744
20:43:13 4503 8192000000 10966296624 11382546432 1972962832 19.409 100 69 138 1 2047615424 52552752 22099840
20:43:25 2022 8192000000 10975883360 11381096448 1973040240 19.410 100 74 144 2 2047705664 52009520 22655904
20:43:34 4233 8192000000 10966758368 11384819712 1975439104 19.429 100 69 137 0 2049242288 52267584 21535600
20:43:45 2330 8192000000 10985337328 11390361600 1982004544 19.481 100 80 160 0 2060688688 53555664 25128480
20:43:55 4249 8192000000 10983700080 11398217728 1986268224 19.514 100 81 162 2 2066718640 55002752 25447664
20:44:08 3995 8192000000 10988990064 11407470592 1994455584 19.579 100 80 160 1 2072399728 52357136 25587008
20:44:19 3757 8192000000 10977702880 11394875392 1974733072 19.423 99 78 156 1 2054300944 55445680 24122192
20:44:30 2437 8192000000 10985779376 11395629056 1981364816 19.476 100 90 182 1 2064910336 56006320 27539200
20:44:40 1342 8192000000 10998377296 11407097856 1991532352 19.556 100 94 189 0 2077314064 56827344 28954368
20:44:50 2528 8192000000 10978853328 11382984704 1959777856 19.304 99 87 173 0 2044392976 57785104 26830016
20:45:00 1889 8192000000 10979379456 11389489152 1973506208 19.413 100 84 168 2 2058504832 58968544 26030080
20:45:10 1811 8192000000 10978664128 11389431808 1972079024 19.402 100 87 172 1 2059607008 60594272 26933712
20:45:21 5359 8192000000 10988677344 11400015872 1980433632 19.468 100 83 165 2 2068788512 62329008 26025872
20:45:37 4137 8192000000 10991304560 11404828672 1984819568 19.503 100 86 173 1 2076149328 64187504 27142256
20:45:49 3069 8192000000 11011647408 11421863936 1993831472 19.574 100 84 168 0 2091027952 70170912 27025568
20:45:59 2754 8192000000 10997954288 11409977344 1983665552 19.494 100 89 180 0 2083646400 68505280 31475568
20:46:10 3310 8192000000 10976283792 11384913920 1960186336 19.308 99 83 166 1 2057577408 68499920 28891152
20:46:21 5209 8192000000 10993056768 11403620352 1973406496 19.412 100 89 177 1 2075151360 72692336 29052528
20:46:34 3798 8192000000 10993915360 11403767808 1976124256 19.434 100 92 184 2 2082378240 75094128 31159856
20:46:46 7999 8192000000 10975027760 11398795264 1963283440 19.332 100 71 142 1 2063099376 76148224 23667712
20:47:02 1609 8192000000 10989928992 11404255232 1967682512 19.367 100 71 142 1 2068512848 77024800 23805536
20:47:11 2855 8192000000 10993817424 11410997248 1970970336 19.393 100 82 164 0 2077387664 78631120 27786208
20:47:21 3861 8192000000 10998067552 11412484096 1975089920 19.426 100 82 165 1 2080790624 77967856 27732848
20:47:35 3475 8192000000 10997620624 11423051776 1974852464 19.424 100 71 143 1 2080408272 80358512 25197296
20:47:47 2401 8192000000 11015845664 11428753408 1983521936 19.493 100 92 184 0 2093609392 79746320 30341136
20:47:57 4352 8192000000 11011206304 11429937152 1982996512 19.488 100 75 146 3 2087565856 80484000 24085344
20:48:10 4472 8192000000 11012934400 11431899136 1987733568 19.526 100 78 153 3 2094864480 81788432 25342480
20:48:23 6173 8192000000 11012634320 11428741120 1987037632 19.520 100 76 152 1 2091617408 79516672 25063104
20:48:36 3250 8192000000 11021247712 11439636480 1996906992 19.598 100 82 163 1 2100591088 77755008 25929088
20:48:46 1564 8192000000 11034616000 11450028032 2005787904 19.668 100 90 179 2 2114124080 79545296 28790880
20:48:55 2917 8192000000 11010909104 11429408768 1974457584 19.421 99 76 149 2 2077708064 78956736 24293744
20:49:06 3988 8192000000 11008348128 11438313472 1997584768 19.604 100 71 140 0 2092916880 72349296 22982816
20:49:25 19131 8192000000 10971744464 11429302272 1989761120 19.542 100 35 70 2 2064461856 62210816 12489920
20:49:54 23126 8192000000 10953282448 11414626304 1974308688 19.420 99 37 74 3 2033129664 46605840 12215136
20:50:37 31819 8192000000 10967905984 11418193920 1993042496 19.568 100 35 70 0 2047332592 42690976 11599120
20:51:27 19060 8192000000 10954984176 11410923520 1965073808 19.346 99 26 52 1 2021148544 46549040 9525696
20:51:52 25152 8192000000 10942014720 11407052800 1982563632 19.485 100 26 52 3 2036418560 44631376 9223552
20:52:42 22241 8192000000 10946600720 11421515776 1975685760 19.431 100 21 42 0 2035735488 52012528 8037200
20:53:17 25805 8192000000 10902888064 11381788672 1915089584 18.947 97 13 26 0 1954483840 35253904 4140352
20:53:49 25951 8192000000 10892780256 11353284608 1926847072 19.042 99 13 26 2 1963434624 32131696 4455856
20:54:35 26198 8192000000 10881708848 11372580864 1934759664 19.105 100 13 26 0 1979979536 40560016 4659856
20:55:08 32034 8192000000 10883934816 11347251200 1953296048 19.253 100 7 14 1 1963011840 8077136 1638656
20:55:46 65172 8192000000 10891495952 11359731712 1930729952 19.073 98 32 61 1 1951433168 11166336 9536880
20:57:14 104113 8192000000 10904165696 11366191104 1890251024 18.748 96 23 46 0 1910197296 13396736 6549536
20:59:10 61400 8192000000 10891009488 11352055808 1890251952 18.748 96 11 22 1 1912679328 19236816 3190560
21:01:09 98617 8192000000 10890242544 11343552512 1903749072 18.856 97 26 52 1 1928111968 17233936 7128960
21:02:54 93478 8192000000 10898566672 11352752128 1929443568 19.062 98 33 66 1 1945639152 7474080 8721504
21:04:35 33121 8192000000 10908017328 11361333248 1953945440 19.258 99 49 96 1 1975077040 7781632 13349968
21:05:14 91238 8192000000 10905833968 11382509568 1961463920 19.318 99 37 74 3 1985973888 13514368 10995600
21:06:58 64532 8192000000 10914149536 11364347904 1956254064 19.276 99 22 44 1 1973104416 10822224 6028128
21:08:10 27932 8192000000 10905651472 11373707264 1964741984 19.344 99 20 40 1 1979446624 9055088 5649552
21:08:45 22576 8192000000 10901779680 11368542208 1961043376 19.314 99 11 22 2 1973960784 9270496 3646912
21:09:52 40448 8192000000 10916710352 11381563392 1965893712 19.353 99 30 59 0 1987621584 12913408 8814464
21:10:41 11693 8192000000 10937372096 11383844864 1992214464 19.561 100 45 90 2 2013337744 8261504 12861776
21:11:00 17212 8192000000 10942690752 11400785920 2002716944 19.644 100 46 93 0 2030809440 15307024 12785472
21:11:34 106558 8192000000 10920294832 11396427776 1957233968 19.284 98 14 28 1 1977519696 16800368 3485360
21:13:39 28231 8192000000 10933107536 11401793536 1996309920 19.594 100 16 32 0 2014680672 13593584 4777168
21:14:14 59700 8192000000 10918436624 11381350400 1936275792 19.117 97 18 36 0 1960697664 18672944 5748928
21:15:20 40643 8192000000 10887795168 11359039488 1923201056 19.012 97 20 40 1 1936185472 7169472 5814944
21:16:08 64656 8192000000 10891471568 11373809664 1975446448 19.429 100 12 24 0 1990616384 11658048 3511888
21:17:35 48616 8192000000 10866501216 11354365952 1941092736 19.155 99 11 22 0 1953979408 9892080 2994592
21:18:38 61433 8192000000 10893572992 11361972224 1928981776 19.059 98 12 24 0 1942111376 9837072 3292528
21:19:46 68713 8192000000 10892209584 11364569088 1912426256 18.926 97 21 42 4 1932001184 13521600 6053328
21:21:05 52092 8192000000 10885575728 11342372864 1910305232 18.909 97 23 46 2 1928390336 11318400 6766704
21:22:05 34421 8192000000 10898079680 11360796672 1941486352 19.159 99 31 62 1 1967198608 16686784 9025472
21:22:50 80538 8192000000 10891682048 11368656896 1934058624 19.099 98 11 22 1 1958597408 21229344 3309440
21:24:17 38478 8192000000 10894822592 11365367808 1959282096 19.300 100 16 32 2 1979789728 15984784 4522848
21:25:07 18610 8192000000 10903735360 11351871488 1926972816 19.043 98 43 84 0 1950164720 11555232 11636672
21:25:36 11443 8192000000 10903501712 11354849280 1961970400 19.322 100 36 72 1 1982092656 9847952 10274304
21:25:58 30202 8192000000 10911806080 11374321664 1969903872 19.385 100 36 72 2 1995194992 14906864 10384256
21:27:11 26479 8192000000 10896291072 11351445504 1946148528 19.196 99 28 56 1 1966089904 12636944 7304432
21:27:49 57282 8192000000 10900115856 11360526336 1930910032 19.074 98 32 64 1 1954132528 14330256 8892240
21:28:55 103628 8192000000 10891425072 11368153088 1871153728 18.594 95 16 32 0 1889786064 14670256 3962080
21:30:45 56843 8192000000 10875050960 11336515584 1886582800 18.718 96 10 20 2 1900517632 10609104 3325728
21:31:50 62935 8192000000 10899421920 11360382976 1910738560 18.913 97 31 62 0 1930695024 10579456 9377008
21:33:37 72018 8192000000 10895227728 11346116608 1890405456 18.749 96 32 63 0 1908765072 9963328 8396288
21:34:58 43561 8192000000 10919361792 11362164736 1944335728 19.181 99 38 76 0 1970537488 15543056 10658704
21:35:56 29426 8192000000 10880930304 11336736768 1917888784 18.970 98 39 78 1 1938654816 10156288 10609744
21:36:34 4008 8192000000 10899039328 11344715776 1951215936 19.236 100 47 93 3 1974287856 9622448 13449472
21:36:45 37265 8192000000 10908166672 11366490112 1971431568 19.397 100 60 120 1 2003539888 15110048 16998272
21:37:51 68372 8192000000 10889199008 11364270080 1932360624 19.086 98 14 27 1 1949676768 13256176 4059968
21:39:06 81452 8192000000 10897025968 11371266048 1927904016 19.050 98 18 36 0 1946567856 13429088 5234752
21:40:34 59406 8192000000 10903802112 11385499648 1965531376 19.350 100 17 33 1 2001053840 29996816 5525648
21:41:39 25448 8192000000 10907577280 11387396096 1964426400 19.341 100 11 22 0 2001768432 33829264 3512768
21:42:44 61412 8192000000 10883191424 11357052928 1924037360 19.019 98 15 29 1 1940999072 12872656 4089056
21:43:52 93575 8192000000 10879587024 11361570816 1901646160 18.840 97 18 36 0 1924962448 18009520 5306768
21:45:42 84694 8192000000 10877027472 11345215488 1880416496 18.668 96 15 32 0 1899592368 15138912 4036960
21:47:19 109956 8192000000 10902840272 11350065152 1899019600 18.818 97 18 36 0 1914620624 10974832 4626192
21:49:15 70735 8192000000 10874655376 11354955776 1912348928 18.925 98 24 48 0 1933494080 14344816 6800336
21:50:32 72842 8192000000 10876329696 11340169216 1876139536 18.634 96 9 18 0 1896556048 17800656 2615856
21:51:53 61392 8192000000 10876353536 11349409792 1930974768 19.075 99 16 31 2 1948449792 13314912 4160112
21:53:04 28964 8192000000 10890074448 11351863296 1940930496 19.154 99 15 30 1 1953092096 7761104 4400496
21:53:46 78638 8192000000 10891772272 11369312256 1905084192 18.867 97 19 38 2 1927973888 17662688 5227008
21:55:11 85926 8192000000 10889842864 11344072704 1921274272 18.997 98 19 37 1 1934514544 7146800 6093472
21:56:47 60087 8192000000 10890212384 11361267712 1951424992 19.238 99 17 32 1 1961736256 5522128 4789136
21:57:53 41255 8192000000 10907921472 11373682688 1967083312 19.362 99 34 68 0 1986044000 9261424 9699264
21:58:42 30718 8192000000 10917550144 11382571008 1972591616 19.406 99 36 72 0 1996094320 13373344 10129360
21:59:30 57675 8192000000 10894055152 11375304704 1925856480 19.034 97 9 18 0 1940415248 11860096 2698672
22:00:36 59430 8192000000 10914815168 11392618496 1980802336 19.471 100 9 18 0 1994816528 11830480 2183712
22:03:14 81203 8192000000 10899947120 11399786496 1969433216 19.381 99 14 28 0 1992578656 19001456 4143984
22:05:18 51254 8192000000 10905472288 11387146240 1961738896 19.320 99 16 32 2 1980627120 13795920 5092304
22:06:40 47449 8192000000 10916970816 11389132800 1967584672 19.366 99 13 26 1 1981677936 10769632 3323632
22:07:34 75151 8192000000 10922785568 11404386304 1990197008 19.545 100 13 26 1 2007173136 13517392 3458736
22:08:55 36435 8192000000 10929446016 11390324736 1962840560 19.329 98 32 62 0 1979755952 8088320 8827072
22:09:47 40585 8192000000 10890647056 11374776320 1924564384 19.023 97 37 74 1 1950868048 15880752 10422912
22:10:49 40698 8192000000 10878058576 11339706368 1895821840 18.793 97 28 56 1 1914434736 10418528 8194368
22:12:14 45813 8192000000 10890821728 11347529728 1908416992 18.894 98 33 66 0 1926646560 9381440 8848128
22:13:11 31134 8192000000 10881229312 11353853952 1925447008 19.030 99 22 44 2 1946286576 14792512 6047056
22:13:50 89191 8192000000 10874104096 11333230592 1826723376 18.233 94 5 10 0 1841065872 12985888 1356608
22:15:26 91808 8192000000 10882816896 11338321920 1938438560 19.134 100 21 42 0 1956666272 12387136 5840576
22:18:40 56929 8192000000 10866030816 11340890112 1912218768 18.924 98 12 24 0 1924034208 8542848 3272592
22:20:28 75065 8192000000 10881605664 11367526400 1964462336 19.341 100 18 36 1 1982777920 13629264 4686320
22:21:50 80374 8192000000 10870881376 11360718848 1926950400 19.042 98 13 26 1 1943491040 13054880 3485760
22:23:20 78072 8192000000 10859467728 11330727936 1843717328 18.371 94 16 32 0 1859880864 11065072 5098464
22:25:06 31423 8192000000 10881689840 11349323776 1937475584 19.127 99 26 50 1 1956566032 11257568 7832880
22:25:54 42403 8192000000 10873676544 11336548352 1872125008 18.601 96 23 47 3 1893119072 13862672 7131392
22:26:43 33328 8192000000 9156259664 9395298304 319925792 3.758 17 2 3 0 322601072 2258080 417200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-12-2020 22:28:30 to 30-12-2020 22:29:02.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-12-2020 22:29:03 to 30-12-2020 22:29:05.

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          244304
MON$OLDEST_ACTIVE               244305
MON$OLDEST_SNAPSHOT             244305
MON$NEXT_TRANSACTION            244305
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                       2037088
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:136: 
:137: mscs-test-161.budzdorov.ru    Wed Dec 30 22:27:21 2020
:138:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139: 
:140: 
:141: mscs-test-161.budzdorov.ru    Wed Dec 30 22:27:21 2020
:142:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:143: 
--- end of diff output ---

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

30.12.20 22:29:06. 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-30 22:29:08 No severe PSQL-related problems occured
30.12.20 22:29:10. End of report.