Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.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 17677868 kB
MemAvailable 31578124 kB
Buffers 0 kB
Cached 14007460 kB
SwapCached 1972 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-05 22:27:03
DTS_END                         2020-12-05 22:27:03.4230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50864
TRN_ID                          238122
ATT_ID                          640
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: 9216.30 21109 1105956
customer order: creation 169.29 366 20315
customer order: refuse 14.53 315 1744
order to supplier: creation 44.44 1282 5333
order to supplier: removal 3.26 94595 391
invoice (draft): creation 44.63 3010 5355
invoice (draft): removal 51.15 724 6138
invoice accept: apply 41.47 17224 4976
invoice accept: cancel 45.88 745 5505
customer reserve: creation 3965.92 165 475910
customer reserve: removal 4550.96 53 546115
realization accept: apply 81.92 175 9830
realization accept: cancel 75.82 98 9098
payment from customer: creation 58.61 117 7033
payment from customer: removal 5.68 64 681
payment to supplier: creation 47.31 144 5677
payment to supplier: removal 3.22 79 386
service: total inventory turnovers 4.81 1026 577
service: total monetary turnovers 6.49 18 779
service: aggregate perf. data 0.91 16105 109
service: refresh index statistics 0.03 285876 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-12-2020 22:28:13 to 05-12-2020 22:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6087
TEST_TIME 2 5791
TEST_TIME 3 5414
TEST_TIME 4 6075
TEST_TIME 5 5642
TEST_TIME 6 6599
TEST_TIME 7 7327
TEST_TIME 8 7657
TEST_TIME 9 7453
TEST_TIME 10 7834
TEST_TIME 11 8469
TEST_TIME 12 8513
TEST_TIME 13 9006
TEST_TIME 14 9173
TEST_TIME 15 9536
TEST_TIME 16 9566
TEST_TIME 17 9463
TEST_TIME 18 9794
TEST_TIME 19 10146
TEST_TIME 20 10649
TEST_TIME 21 10674
TEST_TIME 22 11189
TEST_TIME 23 11468
TEST_TIME 24 11582
TEST_TIME 25 11825
TEST_TIME 26 11612
TEST_TIME 27 11307
TEST_TIME 28 11054
TEST_TIME 29 11055
TEST_TIME 30 10935
TEST_TIME 31 10782
TEST_TIME 32 10978
TEST_TIME 33 10883
TEST_TIME 34 10847
TEST_TIME 35 10682
TEST_TIME 36 10503
TEST_TIME 37 10359
TEST_TIME 38 10304
TEST_TIME 39 10162
TEST_TIME 40 9972
TEST_TIME 41 10387
TEST_TIME 42 10190
TEST_TIME 43 10138
TEST_TIME 44 10192
TEST_TIME 45 10085
TEST_TIME 46 9963
TEST_TIME 47 9815
TEST_TIME 48 9794
TEST_TIME 49 9804
TEST_TIME 50 9746
TEST_TIME 51 9638
TEST_TIME 52 9688
TEST_TIME 53 9687
TEST_TIME 54 9663
TEST_TIME 55 9746
TEST_TIME 56 9768
TEST_TIME 57 9744
TEST_TIME 58 9726
TEST_TIME 59 9792
TEST_TIME 60 9807
TEST_TIME 61 9784
TEST_TIME 62 9770
TEST_TIME 63 9832
TEST_TIME 64 9778
TEST_TIME 65 9664
TEST_TIME 66 9605
TEST_TIME 67 9586
TEST_TIME 68 9605
TEST_TIME 69 9577
TEST_TIME 70 9503
TEST_TIME 71 9470
TEST_TIME 72 9388
TEST_TIME 73 9402
TEST_TIME 74 9451
TEST_TIME 75 9490
TEST_TIME 76 9558
TEST_TIME 77 9538
TEST_TIME 78 9526
TEST_TIME 79 9576
TEST_TIME 80 9661
TEST_TIME 81 9646
TEST_TIME 82 9588
TEST_TIME 83 9706
TEST_TIME 84 9674
TEST_TIME 85 9666
TEST_TIME 86 9598
TEST_TIME 87 9556
TEST_TIME 88 9496
TEST_TIME 89 9508
TEST_TIME 90 9491
TEST_TIME 91 9422
TEST_TIME 92 9423
TEST_TIME 93 9419
TEST_TIME 94 9430
TEST_TIME 95 9411
TEST_TIME 96 9478
TEST_TIME 97 9470
TEST_TIME 98 9471
TEST_TIME 99 9426
TEST_TIME 100 9486
TEST_TIME 101 9512
TEST_TIME 102 9500
TEST_TIME 103 9521
TEST_TIME 104 9533
TEST_TIME 105 9561
TEST_TIME 106 9606
TEST_TIME 107 9584
TEST_TIME 108 9502
TEST_TIME 109 9490
TEST_TIME 110 9460
TEST_TIME 111 9434
TEST_TIME 112 9421
TEST_TIME 113 9394
TEST_TIME 114 9391
TEST_TIME 115 9343
TEST_TIME 116 9321
TEST_TIME 117 9304
TEST_TIME 118 9284
TEST_TIME 119 9297
TEST_TIME 120 9222

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-12-2020 22:28:16 to 05-12-2020 22:28:20.

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 1544092 1544092 0 0.00 0 25087 6 0 0
doc_list_biud 1544092 1544092 0 0.00 0 32532 24 0 0
sp_add_invoice_to_stock 5051 4976 75 1.48 38 190604 17225 0 75
sp_cancel_adding_invoice 5505 5505 0 0.00 5 83827 745 0 0
sp_cancel_client_order 1744 1744 0 0.00 4 11320 316 0 0
sp_cancel_customer_reserve 546115 546115 0 0.00 1 22948 54 0 0
sp_cancel_pay_from_customer 681 681 0 0.00 3 4654 65 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 3 4011 79 0 0
sp_cancel_supplier_invoice 6146 6138 8 0.13 1 17250 724 0 8
sp_cancel_supplier_order 391 391 0 0.00 4 855325 94596 0 0
sp_cancel_write_off 9098 9098 0 0.00 1 13863 99 0 0
sp_client_order 20315 20315 0 0.00 4 59280 367 0 0
sp_customer_reserve 475910 475910 0 0.00 0 94762 166 0 0
sp_fill_shopping_cart 31001 31001 0 0.00 1 13068 40 0 0
sp_fill_shopping_cart_clo_res 475901 475901 0 0.00 0 15193 14 0 0
sp_get_clo_for_invoice 4966 4966 0 0.00 0 24298 371 0 0
sp_kill_cost_storno 15670 15670 0 0.00 0 9034 50 0 0
sp_kill_qstorno_ret_qs2qd 1107857 1107857 0 0.00 0 32531 29 0 0
sp_kill_qty_storno 583787 583787 0 0.00 0 32532 63 0 0
sp_lock_selected_doc 20415 20415 0 0.00 0 7309 5 0 0
sp_make_cost_storno 27506 27506 0 0.00 0 25084 53 0 0
sp_multiply_rows_for_pdistr 27506 27506 0 0.00 0 11374 30 0 0
sp_multiply_rows_for_qdistr 20315 20315 0 0.00 0 59266 167 0 0
sp_pay_from_customer 7033 7033 0 0.00 4 15076 118 0 0
sp_pay_to_supplier 5677 5677 0 0.00 4 25098 145 0 0
sp_payment_common 12710 12710 0 0.00 1 13489 34 0 0
sp_qd_handle_on_cancel_clo 1744 1744 0 0.00 0 11312 287 0 0
sp_qd_handle_on_invoice_upd_sts 10471 10471 0 0.00 0 24188 304 0 0
sp_qd_handle_on_reserve_upd_sts 9830 9830 0 0.00 0 18228 59 0 0
sp_reserve_write_off 9830 9830 0 0.00 6 18254 176 0 0
sp_supplier_invoice 5355 5355 0 0.00 7 68965 3011 0 0
sp_supplier_order 5333 5333 0 0.00 5 30269 1283 0 0
srv_aggregate_perf_data 109 109 0 0.00 2569 143109 16105 0 0
srv_fill_mon_cache_memory 148 148 0 0.00 901 171575 35854 0 0
srv_find_qd_qs_mism 1057053 1057053 0 0.00 0 20764 5 0 0
srv_make_invnt_saldo 577 577 0 0.00 51 101913 1026 0 0
srv_make_money_saldo 779 779 0 0.00 0 158 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 226694 393814 285877 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4976 4976 0 0.00 0 24812 170 0 0
t$perf-norm:sp_cancel_adding_invoice 380 380 0 0.00 0 15399 162 0 0
t$perf-norm:sp_cancel_client_order 1744 1744 0 0.00 0 3763 15 0 0
t$perf-norm:sp_cancel_customer_reserve 660 660 0 0.00 0 5786 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 681 681 0 0.00 0 2613 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 2832 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 5104 24 0 0
t$perf-norm:sp_cancel_supplier_order 391 391 0 0.00 0 32853 1571 0 0
t$perf-norm:sp_cancel_write_off 944 944 0 0.00 0 1714 5 0 0
t$perf-norm:sp_client_order 20315 20315 0 0.00 0 8143 18 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 3713 11 0 0
t$perf-norm:sp_pay_from_customer 7033 7033 0 0.00 0 9397 12 0 0
t$perf-norm:sp_pay_to_supplier 5677 5677 0 0.00 0 3876 7 0 0
t$perf-norm:sp_reserve_write_off 9830 9830 0 0.00 0 9415 13 0 0
t$perf-norm:sp_supplier_invoice 5355 5355 0 0.00 0 6462 16 0 0
t$perf-norm:sp_supplier_order 5333 5333 0 0.00 0 6282 14 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 125 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 148 148 0 0.00 0 806 8 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 787 16 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 272 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10080 9930 150 1.48 0 4201 17 0 150
v_all_customers 37042 37042 0 0.00 0 20 1 0 0
v_all_suppliers 29850 29850 0 0.00 0 23 1 0 0
v_all_wares 40630 40630 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 760 760 0 0.00 0 1004 7 0 0
v_cancel_client_order 3488 3488 0 0.00 0 3359 5 0 0
v_cancel_customer_prepayment 1362 1362 0 0.00 0 922 4 0 0
v_cancel_customer_reserve 1320 1320 0 0.00 0 3635 19 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 3998 8 0 0
v_cancel_supplier_invoice 884 868 16 1.80 0 3541 17 0 16
v_cancel_supplier_order 782 782 0 0.00 0 3993 10 0 0
v_cancel_write_off 1888 1888 0 0.00 0 3214 17 0 0
v_max_id_clo_ord 5333 5333 0 0.00 0 2576 2 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 1554 9 0 0
v_max_id_ord_sup 5353 5353 0 0.00 0 4596 7 0 0
v_max_non_paid_invoice 1438 1438 0 0.00 0 767 2 0 0
v_max_non_paid_realizn 3727 3727 0 0.00 0 5074 6 0 0
v_min_id_clo_ord 5333 5333 0 0.00 0 3247 5 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 6569 18 0 0
v_min_id_ord_sup 5353 5353 0 0.00 0 5049 10 0 0
v_min_non_paid_invoice 5677 5677 0 0.00 0 8507 23 0 0
v_min_non_paid_realizn 7033 7033 0 0.00 0 8477 23 0 0
v_our_firm 10200 10200 0 0.00 0 23 1 0 0
v_reserve_write_off 19660 19660 0 0.00 0 4175 7 0 0
x_lock_depdocs_on_canc_invoice 11209 11209 0 0.00 0 16074 103 0 0
x_lock_depdocs_on_canc_sup_ord 391 391 0 0.00 0 15897 318 0 0
x_make_qstorno_1000_1200 5333 5333 0 0.00 2 30203 1209 0 0
x_make_qstorno_1200_2000 5355 5355 0 0.00 3 68581 2862 0 0
x_make_qstorno_2100_3300 475910 475910 0 0.00 0 94760 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-12-2020 22:28:21 to 05-12-2020 22:28:25.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 11095 8192000000 10183671904 10486341632 737926720 8.263 59 48 96 0 756094672 2046656 16121296
19:57:35 31305 8192000000 10339961008 10657681408 1379518272 14.412 100 82 164 0 1411392048 4806448 27067328
19:58:13 38609 8192000000 10400233488 10722611200 1440464672 14.954 100 88 175 1 1475605024 6557472 28582880
19:59:02 25333 8192000000 10421778832 10748284928 1466297232 15.181 100 90 180 0 1503069120 7726096 29045792
19:59:37 19257 8192000000 10439714144 10768752640 1483490848 15.332 100 84 168 0 1518762640 8170976 27100816
20:00:07 17799 8192000000 10457055056 10790924288 1507638800 15.543 100 84 168 0 1543004352 8872800 26492752
20:00:32 18107 8192000000 10467041552 10804502528 1519958480 15.650 100 86 172 2 1556711040 9501872 27250688
20:01:05 14476 8192000000 10498586944 10841083904 1546295712 15.878 100 83 166 1 1582270496 10079024 25895760
20:01:35 13866 8192000000 10524448848 10868248576 1573849888 16.115 100 88 176 1 1611244912 10938144 26456880
20:02:00 15206 8192000000 10537939264 10892550144 1598159008 16.324 100 86 172 1 1635787488 11967952 25660528
20:02:24 14944 8192000000 10562082464 10918019072 1609885344 16.424 100 81 162 0 1645885792 11691568 24308880
20:02:48 9678 8192000000 10585599200 10945056768 1638091104 16.664 100 81 162 0 1673875936 12356192 23428640
20:03:07 9024 8192000000 10596460944 10961399808 1658843808 16.839 100 74 148 1 1694245648 13144368 22257472
20:03:26 8203 8192000000 10619497056 10982080512 1675587936 16.980 100 83 167 2 1712986240 12915280 24483024
20:03:46 7974 8192000000 10627069968 10999369728 1686780880 17.074 100 73 146 0 1720705696 12501200 21423616
20:04:02 7647 8192000000 10638853264 11012796416 1704119408 17.220 100 75 150 2 1738533024 12185488 22228128
20:04:17 6356 8192000000 10654059744 11031265280 1722070880 17.369 100 71 142 0 1754704576 11883104 20750592
20:04:32 4172 8192000000 10666159168 11046907904 1731942880 17.452 100 72 145 1 1763849840 10321456 21585504
20:04:43 5854 8192000000 10685229344 11067154432 1752375920 17.621 100 74 148 0 1784431168 10665776 21389472
20:04:57 6398 8192000000 10701231552 11083087872 1764825504 17.724 100 70 139 2 1794715856 10323008 19567344
20:05:11 6259 8192000000 10706503840 11093225472 1778408240 17.836 100 71 144 2 1809499504 11230560 19860704
20:05:27 6731 8192000000 10711578304 11101114368 1784826976 17.889 100 75 150 3 1818204896 12484336 20893584
20:05:41 3242 8192000000 10737453552 11125968896 1799661312 18.011 100 81 162 1 1836506960 13017760 23827888
20:05:51 3075 8192000000 10746569024 11132874752 1809788144 18.094 100 87 174 2 1847657824 13660416 24209264
20:06:00 3603 8192000000 10747095184 11136733184 1811804320 18.111 100 79 158 2 1846916976 13172688 21939968
20:06:11 3298 8192000000 10759302272 11145519104 1819700912 18.175 100 85 170 2 1857434576 13379328 24354336
20:06:22 2518 8192000000 10757745664 11147550720 1822873296 18.201 100 85 170 3 1859748208 12954048 23920864
20:06:31 2361 8192000000 10763096848 11150606336 1823532384 18.207 100 80 160 0 1858583824 12938256 22113184
20:06:40 3468 8192000000 10773246208 11157135360 1831380080 18.271 100 84 167 0 1866470704 12499088 22591536
20:06:50 2134 8192000000 10782381712 11164741632 1838662464 18.330 100 90 181 0 1878396384 14731440 25002480
20:06:58 2160 8192000000 10785954976 11171844096 1842405232 18.360 100 95 190 3 1882945072 13482496 27057344
20:07:07 1915 8192000000 10790395392 11173969920 1844917936 18.381 100 91 183 2 1884183840 13159456 26106448
20:07:16 2303 8192000000 10791225904 11181649920 1848643184 18.411 100 85 171 1 1886285184 13200784 24441216
20:07:25 1306 8192000000 10794951440 11184328704 1855131600 18.464 100 88 176 0 1894162960 14210448 24820912
20:07:32 2400 8192000000 10803799056 11188834304 1859738560 18.501 100 93 186 3 1899374256 13017776 26617920
20:07:41 1430 8192000000 10803359760 11192434688 1857974256 18.487 100 88 176 1 1895390384 12307936 25108192
20:07:49 2210 8192000000 10804955600 11192389632 1861310656 18.514 100 89 178 2 1900404816 13281936 25812224
20:07:58 1411 8192000000 10813446032 11200811008 1867623712 18.565 100 91 182 4 1905822896 13005056 25194128
20:08:05 1730 8192000000 10816051696 11202949120 1866404848 18.555 100 87 176 1 1903042256 11579728 25057680
20:08:13 18321 8192000000 10785823664 11195805696 1864962704 18.543 100 55 112 0 1890133456 9516832 15653920
20:08:41 5084 8192000000 10786975296 11193253888 1864893744 18.543 100 40 81 3 1882377376 6488000 10995632
20:08:54 8922 8192000000 10774153696 11200040960 1862455424 18.523 100 24 48 0 1875549200 6808640 6285136
20:09:12 7150 8192000000 10770049632 11196993536 1863487328 18.532 100 29 57 3 1879521344 7771968 8262048
20:09:29 9578 8192000000 10762159440 11196997632 1868707840 18.574 100 28 57 1 1882651520 5758944 8184736
20:09:47 12005 8192000000 10769693856 11205468160 1871272640 18.595 100 21 42 1 1883975872 6911488 5791744
20:10:11 7564 8192000000 10786891888 11210403840 1875822912 18.631 100 34 68 2 1892413728 8118816 8472000
20:10:27 12327 8192000000 10783267472 11211849728 1879197248 18.659 100 32 63 2 1894149232 6034704 8917280
20:10:49 53092 8192000000 10812782816 11225477120 1880409712 18.668 100 34 68 1 1894988800 4662240 9916848
20:11:48 6968 8192000000 10796181200 11225956352 1881826704 18.680 100 31 62 0 1899184432 8598128 8759600
20:12:02 5612 8192000000 10799425648 11227234304 1883987776 18.697 100 26 51 0 1897869296 6636384 7245136
20:12:14 6163 8192000000 10787835616 11228577792 1885941824 18.713 100 27 53 2 1900609792 7245232 7422736
20:12:27 6974 8192000000 10792119344 11229151232 1885416144 18.709 100 21 42 1 1897708032 6204656 6087232
20:12:40 3576 8192000000 10825214576 11244273664 1891647584 18.759 100 40 80 2 1910208512 7927168 10633760
20:12:51 1907 8192000000 10834621376 11248308224 1899073840 18.819 100 56 112 1 1925871984 11160240 15637904
20:13:00 4167 8192000000 10820588784 11249111040 1896761936 18.800 100 44 89 1 1922688304 13331984 12594384
20:13:11 9699 8192000000 10811208288 11238944768 1892917968 18.769 100 26 52 2 1906444352 6353728 7172656
20:13:29 7509 8192000000 10813879552 11244695552 1893554080 18.774 100 21 42 0 1905964304 5553072 6857152
20:13:43 7662 8192000000 10827988736 11242942464 1897013168 18.802 100 34 67 2 1916905008 9499920 10391920
20:13:57 10459 8192000000 10809776240 11245895680 1897300752 18.805 100 27 54 3 1911329040 6192880 7835408
20:14:14 11049 8192000000 10809549296 11242934272 1896083024 18.795 100 21 42 0 1907514032 6091440 5339568
20:14:33 12874 8192000000 10804996592 11241558016 1879298448 18.659 99 22 43 2 1891249440 6118080 5832912
20:14:52 9803 8192000000 10792657728 11228676096 1854761888 18.461 98 15 30 1 1864249904 5235248 4252768
20:15:08 10288 8192000000 10802028576 11224506368 1864271280 18.538 99 21 42 1 1876962080 5514800 7176000
20:15:28 66829 8192000000 10793291056 11229712384 1836723424 18.314 97 17 34 2 1846158256 5009632 4425200
20:16:43 6897 8192000000 10774812336 11210477568 1827903008 18.242 97 26 52 0 1841618736 6418560 7297168
20:16:57 5426 8192000000 10784057296 11205971968 1857534432 18.483 99 31 58 2 1871806928 6346016 7926480
20:17:09 7632 8192000000 10784458192 11212275712 1840616416 18.346 98 40 78 0 1859513216 7802832 11093968
20:17:23 3568 8192000000 10783433120 11206549504 1849098416 18.415 99 34 68 4 1865798944 7237040 9463488
20:17:34 3430 8192000000 10764072448 11187814400 1847570272 18.402 100 25 50 0 1861537120 6766848 7200000
20:17:45 5660 8192000000 10763427488 11186159616 1820648432 18.183 98 30 60 1 1835409760 5643696 9117632
20:18:00 9318 8192000000 10733021536 11158327296 1793896800 17.964 98 27 53 0 1807659008 6008368 7753840
20:18:16 8316 8192000000 10711706064 11135078400 1725389664 17.397 94 15 30 1 1734511856 4797888 4324304
20:18:31 7955 8192000000 10711541264 11129925632 1756263760 17.653 96 23 46 3 1769165072 6026368 6874944
20:18:46 9447 8192000000 10737125792 11148890112 1748742512 17.591 96 19 38 0 1759601664 5134240 5724912
20:19:04 7705 8192000000 10718496256 11137196032 1775116864 17.809 98 23 46 0 1787426896 5170096 7139936
20:19:21 6671 8192000000 10734811680 11145531392 1766195952 17.736 97 29 57 3 1779514464 4911136 8407376
20:19:35 7556 8192000000 10702538304 11121963008 1761473600 17.697 98 16 32 0 1771973232 5830064 4669568
20:19:53 64764 8192000000 10657199728 11063676928 1617736320 16.491 90 25 51 1 1629753280 4749840 7267120
20:21:06 11445 8192000000 10690613984 11105693696 1753386304 17.630 98 32 65 1 1768674304 6460960 8827040
20:21:26 7412 8192000000 10703625536 11118829568 1785029888 17.891 99 44 88 3 1805242368 7499168 12713312
20:21:40 5055 8192000000 10724194544 11130433536 1794633424 17.970 99 32 63 1 1810529712 7449296 8446992
20:21:52 4591 8192000000 10729928176 11145699328 1811682416 18.110 100 42 85 2 1830271584 5089824 13499344
20:22:05 4889 8192000000 10738633920 11161575424 1828181888 18.244 100 35 69 4 1845299648 7517744 9600016
20:22:17 9861 8192000000 10747815392 11171401728 1817346816 18.156 99 19 38 0 1828141648 5244528 5550304
20:22:33 6394 8192000000 10768708240 11180949504 1823784816 18.209 99 23 45 2 1839991120 9745904 6460400
20:22:47 9336 8192000000 10763488464 11190833152 1851505952 18.434 100 20 38 1 1863165984 5860480 5799552
20:23:06 9293 8192000000 10793269072 11204526080 1856955008 18.479 100 37 75 2 1873696544 5287488 11454048
20:23:24 12580 8192000000 10784958208 11206672384 1860135440 18.504 100 22 44 0 1872612544 5454848 7022256
20:23:45 5875 8192000000 10777607120 11204685824 1862251680 18.522 100 28 56 3 1876140352 5526576 8362096
20:24:02 12461 8192000000 10768506032 11204333568 1861689312 18.517 100 14 28 3 1871122912 5854400 3579200
20:24:21 13374 8192000000 10781759808 11205136384 1866220720 18.554 100 18 36 5 1877677472 5696944 5759808
20:24:41 67001 8192000000 10774828880 11211288576 1876653232 18.638 100 28 57 0 1891014368 5569040 8792096
20:25:56 10724 8192000000 10791087664 11223060480 1874252000 18.619 100 26 52 2 1888481568 6432992 7796576
20:26:16 9133 8192000000 10787762432 11223343104 1878545360 18.653 100 27 55 1 1892614048 6480992 7587696
20:26:32 5361 8192000000 10801664080 11227430912 1881898576 18.680 100 36 71 1 1899265968 6717936 10649456
20:26:46 6718 8192000000 10794146704 11227738112 1882479760 18.685 100 32 64 0 1897900704 5607648 9813296
20:26:59 27631 8192000000 10812929744 11239403520 1888079408 18.730 100 27 52 2 1900486176 5030160 7376608
20:27:40 28175 8192000000 10839976128 11261288448 1910875536 18.914 100 39 77 0 1930931280 8415056 11640688
20:28:26 13008 8192000000 10855657296 11282460672 1929835344 19.066 100 46 92 2 1954445152 10679856 13929952
20:28:58 20364 8192000000 10870113472 11298754560 1942166560 19.164 100 44 88 1 1966369120 11786416 12416144
20:29:27 17456 8192000000 10885208064 11314266112 1951665696 19.240 100 50 101 0 1978856016 13142048 14048272
20:29:52 7130 8192000000 10894943072 11317997568 1959027680 19.298 100 49 98 0 1985341040 12536416 13776944
20:30:10 21611 8192000000 10896117552 11326312448 1956649184 19.279 100 52 102 0 1985233296 14164480 14419632
20:30:41 16849 8192000000 10903731920 11325669376 1965318592 19.348 100 54 107 1 1995140784 14735200 15086992
20:31:28 31996 8192000000 10901557904 11335299072 1966054512 19.354 100 39 78 1 1993689712 15503536 12131664
20:32:07 53770 8192000000 10912798208 11354468352 1974459200 19.421 100 36 69 1 2004915440 19627280 10828960
20:33:07 15853 8192000000 10909766848 11357016064 1976080352 19.434 100 36 72 0 2005236496 18476464 10679680
20:33:37 15420 8192000000 10918604288 11352371200 1978241840 19.451 100 33 66 2 2007319504 18680480 10397184
20:34:01 7337 8192000000 10923848400 11361017856 1987020144 19.520 100 51 100 1 2020125872 18096288 15009440
20:34:26 4063 8192000000 10940227072 11376029696 1997811456 19.605 100 59 118 1 2033628576 17918240 17898880
20:34:36 4999 8192000000 10930233712 11369693184 1996418448 19.594 100 49 96 1 2024538480 13913568 14206464
20:34:52 4861 8192000000 10941228496 11371634688 1995480896 19.587 100 66 131 0 2030886608 15754432 19651280
20:35:05 8198 8192000000 10943377424 11376930816 1995867808 19.590 100 56 111 3 2028420528 17045744 15506976
20:35:23 9538 8192000000 10958835104 11391963136 2006259696 19.672 100 58 117 1 2043770704 20286672 17224336
20:35:40 1485 8192000000 10956988416 11384311808 2002888608 19.646 100 84 169 2 2048920336 20488864 25542864
20:35:48 4255 8192000000 10911526864 11335565312 1961356800 19.317 98 54 103 2 1994708592 18184416 15167376
20:36:04 12553 8192000000 10953868000 11378073600 2000371152 19.626 100 67 134 0 2039239568 19266912 19601504
20:36:24 9930 8192000000 10936644176 11365675008 1962858992 19.329 98 64 128 5 2003755920 21686480 19210448
20:36:43 3563 8192000000 10941778864 11369836544 1975259296 19.427 99 64 128 0 2017670128 23279040 19131792
20:36:57 4842 8192000000 10954846080 11382099968 1997602112 19.604 100 64 127 0 2042191680 24375824 20213744
20:37:09 5279 8192000000 10959756304 11390722048 1999858720 19.622 100 64 128 0 2044778976 25205936 19714320
20:37:24 3398 8192000000 10948405152 11373379584 1983655760 19.494 99 65 124 0 2025039504 23402160 17981584
20:37:34 1074 8192000000 10976808240 11392716800 2007358912 19.681 100 78 156 0 2054901856 24257344 23285600
20:37:42 897 8192000000 10971483952 11382358016 1994307232 19.578 99 90 179 1 2046820864 26291040 26222592
20:37:50 3117 8192000000 10964743648 11387015168 1999289968 19.617 100 80 158 2 2050553424 27696336 23567120
20:38:01 1991 8192000000 10968423728 11383078912 1981531216 19.477 99 88 174 0 2037655072 28929968 27193888
20:38:10 10329 8192000000 10961495120 11384832000 1979890224 19.464 99 71 138 1 2031319696 30166624 21262848
20:38:28 2679 8192000000 10975533280 11392638976 2003222880 19.648 100 91 177 2 2061005936 30541824 27241232
20:38:38 1525 8192000000 10960415808 11379269632 1974725072 19.423 99 76 150 3 2026500928 28259616 23516240
20:38:47 2043 8192000000 10954595632 11380363264 2002406624 19.642 100 76 151 0 2049260640 23008480 23845536
20:38:55 10167 8192000000 10950250864 11363254272 1980698944 19.470 100 75 148 2 2025745792 23006192 22040656
20:39:12 11368 8192000000 10941445600 11371479040 1985101824 19.505 100 70 138 1 2032577632 26356880 21118928
20:39:32 3800 8192000000 10951468496 11369631744 1982293424 19.483 100 78 155 1 2032743440 26924624 23525392
20:39:45 7384 8192000000 10944674960 11363688448 1960010288 19.306 99 75 150 1 2014855680 32803552 22041840
20:39:59 9742 8192000000 10922031632 11350269952 1935122912 19.108 98 59 117 0 1981903456 28138480 18642064
20:40:16 3306 8192000000 10917782976 11338649600 1947591984 19.207 99 73 145 1 1997088608 26312512 23184112
20:40:26 4769 8192000000 10930524480 11357769728 1968287808 19.372 100 63 126 0 2016517952 28077792 20152352
20:40:40 1531 8192000000 10958605424 11369148416 1981586352 19.477 100 83 164 1 2037502112 30023024 25892736
20:40:48 1103 8192000000 10956675120 11379044352 1990228832 19.546 100 89 175 1 2048806000 30354112 28223056
20:40:57 2818 8192000000 10928613936 11340886016 1944002272 19.179 98 78 156 2 1996355792 27464848 24888672
20:41:08 2724 8192000000 10937358768 11346984960 1943240144 19.173 99 77 153 2 1996775456 29722352 23812960
20:41:18 9356 8192000000 10892991232 11330994176 1939464432 19.142 99 53 106 0 1985075760 28682544 16928784
20:41:41 3113 8192000000 10930773584 11344158720 1947046976 19.203 99 63 123 3 1992352432 26487648 18817808
20:42:00 21194 8192000000 10893839648 11339190272 1946338480 19.197 100 35 70 2 1985711936 27651168 11722288
20:42:28 8047 8192000000 10929114176 11352948736 1963395472 19.333 100 49 97 1 2006094992 26837056 15862464
20:42:43 17712 8192000000 10917958384 11356442624 1929420560 19.062 98 36 72 2 1967856192 26278000 12157632
20:43:09 2950 8192000000 10919959440 11349925888 1945569088 19.191 99 63 125 2 1995402800 29107072 20726640
20:43:21 2992 8192000000 10896647840 11323174912 1914646800 18.944 98 56 110 1 1962590416 30041440 17902176
20:43:34 6648 8192000000 10891759888 11308134400 1919568064 18.983 99 51 100 4 1962800496 27462800 15769632
20:43:47 4944 8192000000 10907698416 11330248704 1937674448 19.128 100 57 112 2 1985702560 30029072 17999040
20:44:05 10634 8192000000 10899188000 11321389056 1918673488 18.976 99 44 85 1 1964333424 31709216 13950720
20:44:23 1806 8192000000 10922282752 11340173312 1946341152 19.197 100 57 115 0 1997205376 32880256 17983968
20:44:32 11921 8192000000 10924548688 11352870912 1953042048 19.251 100 42 82 4 2003729008 36818128 13868832
20:44:54 9609 8192000000 10926263104 11357671424 1953718208 19.256 100 38 75 0 2003283872 37345584 12220080
20:45:12 10043 8192000000 10919396672 11357261824 1937846288 19.130 99 37 74 0 1986699840 36097120 12756432
20:45:31 12568 8192000000 10917496016 11354578944 1954451696 19.262 100 36 72 0 2002511552 35763904 12295952
20:45:50 6828 8192000000 10922506928 11361619968 1960642640 19.311 100 39 78 1 2009421952 35817888 12961424
20:46:07 6480 8192000000 10920452432 11352993792 1940983584 19.155 99 47 95 0 1990254880 33625728 15645568
20:46:23 15854 8192000000 10887211536 11322028032 1915993568 18.955 98 35 71 0 1958361472 30404704 11963200
20:46:51 11527 8192000000 10897836960 11339239424 1946996160 19.203 100 32 64 2 1991235600 33218080 11021360
20:47:10 3822 8192000000 10921093968 11350355968 1951308352 19.237 100 50 100 1 2002342688 34887696 16146640
20:47:24 14395 8192000000 10913478192 11356573696 1936934256 19.122 99 29 58 1 1981302576 34586208 9782112
20:47:46 25522 8192000000 10894053696 11343036416 1916609920 18.960 98 30 60 4 1958387824 31536656 10241248
20:48:32 13824 8192000000 10883222992 11324633088 1910425696 18.910 99 29 58 0 1955690496 34740272 10524528
20:48:53 11133 8192000000 10896736480 11332988928 1912385264 18.926 99 34 67 0 1960849488 36486432 11977792
20:49:14 14561 8192000000 10887162512 11333869568 1908812672 18.897 99 21 42 2 1951349296 34782672 7753952
20:50:12 30102 8192000000 10866064416 11322974208 1911466096 18.918 100 18 35 1 1951410752 33885456 6059200
20:50:50 22647 8192000000 10900529088 11319992320 1910753120 18.913 99 44 84 2 1949736608 25442144 13541344
20:51:19 40196 8192000000 10880274368 11317948416 1923250272 19.013 100 49 100 2 1965649152 27611008 14787872
20:52:23 12747 8192000000 10885024256 11320086528 1933148880 19.092 100 61 123 5 1971340480 20789120 17402480
20:52:42 14252 8192000000 10862805536 11322265600 1934153088 19.100 100 32 64 1 1955544736 12348928 9042720
20:53:03 24422 8192000000 10887197024 11325894656 1940438512 19.150 100 43 85 0 1965087008 12101344 12547152
20:53:34 56668 8192000000 10872269712 11324833792 1899967008 18.826 98 18 36 2 1918690016 13555184 5167824
20:54:43 131681 8192000000 10874675584 11351056384 1943469568 19.174 100 17 36 2 1969883856 21169936 5244352
20:57:07 81788 8192000000 10875916608 11337879552 1912510768 18.927 98 23 46 1 1936789456 18061392 6217296
20:59:29 171575 8192000000 10887419376 11344891904 1947723856 19.208 99 18 35 0 1968343472 15732592 4887024
21:02:27 19460 8192000000 10898400032 11358035968 1968400096 19.373 100 18 37 2 1985906096 11903344 5602656
21:03:04 54161 8192000000 10907727360 11356389376 1919623856 18.984 97 20 41 1 1942495696 16708816 6163024
21:04:07 40572 8192000000 10891970672 11342221312 1935461888 19.111 98 35 68 0 1964764768 19669872 9633008
21:05:31 72404 8192000000 10908766944 11377897472 1963808016 19.336 100 13 26 0 1997546688 30009344 3729328
21:06:51 56440 8192000000 10908345232 11377565696 1964346480 19.341 100 14 28 2 1997525776 28492736 4686560
21:07:55 33689 8192000000 10905594608 11384295424 1957858880 19.289 100 11 23 1 2004293824 42453328 3981616
21:08:50 32580 8192000000 10907124336 11351150592 1961491328 19.318 100 17 34 1 1978632160 11567024 5573808
21:09:38 26942 8192000000 10919403968 11360477184 1979441920 19.460 100 56 106 1 2005373296 10291728 15639648
21:10:20 76915 8192000000 10893076496 11372032000 1962373280 19.325 99 23 46 1 1982917008 13871216 6672512
21:12:24 92735 8192000000 10899865104 11372417024 1955231424 19.268 99 11 20 1 1967704096 9631984 2840688
21:14:15 112619 8192000000 10904550592 11380158464 1984422672 19.500 100 15 30 0 2000211312 11710208 4078432
21:16:17 72296 8192000000 10908428384 11401580544 1982550800 19.485 100 12 24 1 2009550704 23911296 3088608
21:17:39 44247 8192000000 10926445696 11396239360 1991290640 19.554 100 21 42 1 2008571392 10853360 6427392
21:18:38 34509 8192000000 10930471920 11394658304 1979784048 19.463 99 49 97 3 2005669424 12999472 12885904
21:19:29 93452 8192000000 10903115776 11376345088 1928072992 19.051 97 19 38 0 1943984768 10656016 5255760
21:21:09 72550 8192000000 10931141472 11401216000 1987909104 19.527 100 15 31 0 2006022096 14097744 4015248
21:22:38 93908 8192000000 10908292320 11382149120 1915422208 18.950 96 12 24 2 1933135776 14304160 3409408
21:24:26 65411 8192000000 10904321680 11368951808 1920948800 18.994 97 20 40 0 1936831968 10683312 5199856
21:25:55 48667 8192000000 10880894944 11367759872 1930617680 19.072 98 15 30 0 1948546160 13632000 4296480
21:26:51 88185 8192000000 10909939264 11380822016 1921492032 18.999 97 15 30 1 1935052848 9754560 3806256
21:28:47 39915 8192000000 10935415616 11388112896 1968722784 19.375 99 33 65 1 1987384304 9838304 8823216
21:29:39 89358 8192000000 10884569040 11344658432 1808754336 18.086 91 11 21 0 1824715968 13890448 2071184
21:31:18 41536 8192000000 10901026032 11351420928 1931228960 19.077 98 31 62 0 1950165952 9506288 9430704
21:32:30 93755 8192000000 10903827488 11378270208 1957951360 19.290 99 33 66 0 1976716352 9370480 9394512
21:34:14 59939 8192000000 10878439168 11361861632 1950480160 19.230 99 12 24 3 1971836608 17504464 3851984
21:35:25 49070 8192000000 10854526112 11336183808 1852833344 18.445 94 14 28 2 1868506864 11393520 4280000
21:36:20 35957 8192000000 10852318176 11327479808 1911610912 18.920 98 5 10 0 1924889280 12021808 1256560
21:37:06 39907 8192000000 10842076112 11311476736 1903604816 18.855 98 12 24 0 1919259440 12183696 3470928
21:37:57 53941 8192000000 10851819648 11325128704 1878749312 18.655 97 17 33 2 1896673712 12935680 4988720
21:38:57 44245 8192000000 10850854256 11324948480 1913913152 18.938 99 5 10 0 1930836400 15543120 1380128
21:40:05 73184 8192000000 10849307616 11324145664 1904291312 18.861 98 10 20 0 1923962288 16696688 2974288
21:41:25 88175 8192000000 10822546544 11289554944 1771069712 17.776 92 14 28 0 1790976688 15698480 4208496
21:43:01 73439 8192000000 10829759312 11302297600 1817890752 18.160 95 15 30 0 1837147696 14919888 4337056
21:44:29 65085 8192000000 10857479904 11314499584 1903813664 18.857 99 27 54 3 1930451456 18876800 7760992
21:45:47 84397 8192000000 10865482032 11342491648 1937814416 19.129 100 18 36 2 1957553040 14691600 5047024
21:47:23 100698 8192000000 10871897968 11319402496 1899893248 18.825 98 32 64 0 1921265696 12275184 9097264
21:49:15 39746 8192000000 10878977968 11317469184 1901173440 18.836 98 38 76 0 1922577968 10861664 10542864
21:50:17 97579 8192000000 10854247328 11311177728 1886490944 18.717 98 28 56 1 1910565376 16223024 7851408
21:52:29 115114 8192000000 10833906880 11283046400 1840023184 18.341 95 33 66 0 1859770064 9882784 9864096
21:54:56 42007 8192000000 10843955856 11295203328 1854271280 18.457 96 30 60 0 1870252032 7466592 8514160
21:55:44 18852 8192000000 10850691072 11304448000 1916031472 18.955 100 37 74 2 1937464416 10991968 10440976
21:56:20 36061 8192000000 10838320528 11312353280 1921033552 18.995 100 19 38 0 1936233664 9561648 5638464
21:57:02 38930 8192000000 10815242672 11277897728 1866967120 18.560 97 8 16 1 1882782736 13192832 2622784
21:57:47 60390 8192000000 10831896112 11304701952 1902888912 18.850 99 8 16 0 1916513344 11860832 1763600
21:59:53 42584 8192000000 10862454112 11319619584 1920256512 18.989 99 12 23 2 1931024528 8101376 2666640
22:00:50 52633 8192000000 10876617136 11345752064 1938211904 19.132 99 23 46 2 1951809232 7332016 6265312
22:01:52 31945 8192000000 10889087664 11354161152 1958183136 19.292 100 13 26 0 1968364432 6602288 3579008
22:02:31 90245 8192000000 10893003840 11359023104 1952879088 19.249 99 18 36 1 1970472832 11929920 5663824
22:04:13 46188 8192000000 10899454848 11358732288 1965000624 19.346 99 26 52 2 1981518864 9185696 7332544
22:05:08 86501 8192000000 10917611536 11374411776 1961568080 19.319 99 34 67 2 1982314384 10994688 9751616
22:06:43 21870 8192000000 10913623632 11355594752 1931623760 19.080 97 43 86 0 1954258768 9835248 12799760
22:07:14 39317 8192000000 10905075712 11380318208 1971444288 19.397 100 29 58 2 1992799040 13448224 7906528
22:08:00 124580 8192000000 10900363104 11374075904 1912582032 18.927 97 10 20 1 1926895568 11728528 2585008
22:10:12 35459 8192000000 10911492320 11376267264 1959245168 19.300 99 23 44 2 1978182080 12141360 6795552
22:11:10 45105 8192000000 10907536848 11350048768 1897667920 18.808 96 11 22 0 1908995408 8556736 2770752
22:12:01 59803 8192000000 10903238128 11366817792 1914023744 18.939 97 34 68 3 1934981600 11934528 9023328
22:13:07 102127 8192000000 10879420752 11358261248 1852401984 18.442 94 13 26 0 1872184672 16117040 3665648
22:15:33 62531 8192000000 10869464816 11338219520 1902007824 18.842 97 20 40 1 1915517472 8228032 5281616
22:16:48 39531 8192000000 10908492832 11362062336 1970121872 19.386 100 38 76 0 1989724992 9284224 10318896
22:17:33 44896 8192000000 10884982096 11358564352 1969306080 19.380 100 23 46 0 1985277728 9401280 6570368
22:18:25 32193 8192000000 10873115872 11346464768 1910532576 18.911 97 11 22 0 1922258912 8880400 2845936
22:19:07 28847 8192000000 10852704112 11332648960 1891655984 18.759 97 3 6 0 1899830864 7719600 455280
22:20:08 67057 8192000000 10850930016 11317432320 1867484000 18.564 96 11 22 2 1877359456 6707216 3168240
22:21:29 55307 8192000000 10854518864 11330306048 1922862384 19.010 99 11 22 0 1932523456 6777648 2883424
22:23:17 58835 8192000000 10868491728 11333734400 1895572032 18.791 97 11 22 0 1904962240 6224608 3165600
22:24:23 76536 8192000000 10869457120 11337486336 1898312512 18.813 97 25 50 1 1916994352 11667088 7014752
22:25:46 56550 8192000000 10884238096 11368407040 1943386240 19.174 99 15 30 0 1963141040 15174784 4580016
22:26:59 12986 8192000000 9176349568 9422385152 339317712 3.977 18 1 2 0 344060464 4680624 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-12-2020 22:28:26 to 05-12-2020 22:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          238423
MON$OLDEST_ACTIVE               238424
MON$OLDEST_SNAPSHOT             238424
MON$NEXT_TRANSACTION            238424
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                       2010496
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Sat Dec  5 22:27:17 2020
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
--- end of diff output ---

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

05.12.20 22:29:00. 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-05 22:29:03 No severe PSQL-related problems occured
05.12.20 22:29:04. End of report.