Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.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 17514284 kB
MemAvailable 31468168 kB
Buffers 0 kB
Cached 14158040 kB
SwapCached 3696 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-21 22:27:09
DTS_END                         2020-12-21 22:27:09.1350
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/49018
TRN_ID                          249431
ATT_ID                          720
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: 9397.73 19747 1127727
customer order: creation 178.73 344 21447
customer order: refuse 15.08 276 1810
order to supplier: creation 47.32 1223 5678
order to supplier: removal 3.54 86933 425
invoice (draft): creation 47.83 3206 5739
invoice (draft): removal 54.83 634 6579
invoice accept: apply 42.47 15943 5096
invoice accept: cancel 49.23 654 5907
customer reserve: creation 3883.00 160 465960
customer reserve: removal 4768.68 51 572241
realization accept: apply 86.28 175 10353
realization accept: cancel 86.38 100 10365
payment from customer: creation 60.85 111 7302
payment from customer: removal 5.83 64 699
payment to supplier: creation 51.95 115 6234
payment to supplier: removal 3.57 77 428
service: total inventory turnovers 4.83 914 580
service: total monetary turnovers 6.62 27 794
service: aggregate perf. data 0.72 22833 86
service: refresh index statistics 0.03 261104 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-12-2020 22:27:58 to 21-12-2020 22:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8180
TEST_TIME 2 6325
TEST_TIME 3 5863
TEST_TIME 4 6753
TEST_TIME 5 6905
TEST_TIME 6 6773
TEST_TIME 7 6925
TEST_TIME 8 7317
TEST_TIME 9 7544
TEST_TIME 10 8227
TEST_TIME 11 8127
TEST_TIME 12 8064
TEST_TIME 13 8386
TEST_TIME 14 9208
TEST_TIME 15 9172
TEST_TIME 16 9248
TEST_TIME 17 9222
TEST_TIME 18 9279
TEST_TIME 19 9816
TEST_TIME 20 10066
TEST_TIME 21 10382
TEST_TIME 22 10192
TEST_TIME 23 11589
TEST_TIME 24 12037
TEST_TIME 25 11777
TEST_TIME 26 11653
TEST_TIME 27 11476
TEST_TIME 28 11154
TEST_TIME 29 10888
TEST_TIME 30 10902
TEST_TIME 31 10823
TEST_TIME 32 10808
TEST_TIME 33 10538
TEST_TIME 34 10617
TEST_TIME 35 10531
TEST_TIME 36 10359
TEST_TIME 37 10297
TEST_TIME 38 10309
TEST_TIME 39 10181
TEST_TIME 40 9950
TEST_TIME 41 10082
TEST_TIME 42 9983
TEST_TIME 43 9887
TEST_TIME 44 9783
TEST_TIME 45 9723
TEST_TIME 46 9800
TEST_TIME 47 9703
TEST_TIME 48 9736
TEST_TIME 49 9725
TEST_TIME 50 9713
TEST_TIME 51 9743
TEST_TIME 52 9731
TEST_TIME 53 9793
TEST_TIME 54 9865
TEST_TIME 55 9793
TEST_TIME 56 9880
TEST_TIME 57 9956
TEST_TIME 58 9908
TEST_TIME 59 9814
TEST_TIME 60 9707
TEST_TIME 61 9739
TEST_TIME 62 9670
TEST_TIME 63 9611
TEST_TIME 64 9543
TEST_TIME 65 9531
TEST_TIME 66 9618
TEST_TIME 67 9566
TEST_TIME 68 9623
TEST_TIME 69 9648
TEST_TIME 70 9589
TEST_TIME 71 9606
TEST_TIME 72 9691
TEST_TIME 73 9640
TEST_TIME 74 9642
TEST_TIME 75 9683
TEST_TIME 76 9603
TEST_TIME 77 9745
TEST_TIME 78 9792
TEST_TIME 79 9759
TEST_TIME 80 9669
TEST_TIME 81 9614
TEST_TIME 82 9632
TEST_TIME 83 9616
TEST_TIME 84 9558
TEST_TIME 85 9495
TEST_TIME 86 9477
TEST_TIME 87 9428
TEST_TIME 88 9498
TEST_TIME 89 9508
TEST_TIME 90 9469
TEST_TIME 91 9412
TEST_TIME 92 9486
TEST_TIME 93 9519
TEST_TIME 94 9611
TEST_TIME 95 9616
TEST_TIME 96 9603
TEST_TIME 97 9566
TEST_TIME 98 9656
TEST_TIME 99 9661
TEST_TIME 100 9613
TEST_TIME 101 9704
TEST_TIME 102 9673
TEST_TIME 103 9600
TEST_TIME 104 9583
TEST_TIME 105 9551
TEST_TIME 106 9523
TEST_TIME 107 9495
TEST_TIME 108 9469
TEST_TIME 109 9443
TEST_TIME 110 9398
TEST_TIME 111 9350
TEST_TIME 112 9323
TEST_TIME 113 9343
TEST_TIME 114 9340
TEST_TIME 115 9403
TEST_TIME 116 9379
TEST_TIME 117 9375
TEST_TIME 118 9435
TEST_TIME 119 9472
TEST_TIME 120 9400

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-12-2020 22:28:02 to 21-12-2020 22:28:05.

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 1561368 1561368 0 0.00 0 16983 6 0 0
doc_list_biud 1561368 1561368 0 0.00 0 21477 24 0 0
sp_add_invoice_to_stock 5221 5096 125 2.39 39 158692 15943 0 125
sp_cancel_adding_invoice 5907 5907 0 0.00 4 76732 654 0 0
sp_cancel_client_order 1810 1810 0 0.00 4 18905 276 0 0
sp_cancel_customer_reserve 572241 572241 0 0.00 1 24608 51 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 2 3461 64 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 4937 77 0 0
sp_cancel_supplier_invoice 6586 6579 7 0.10 1 16055 635 0 7
sp_cancel_supplier_order 425 425 0 0.00 8 1002930 86934 0 0
sp_cancel_write_off 10365 10365 0 0.00 1 10246 101 0 0
sp_client_order 21447 21447 0 0.00 3 26795 345 0 0
sp_customer_reserve 465960 465960 0 0.00 0 77646 160 0 0
sp_fill_shopping_cart 32857 32857 0 0.00 1 24288 39 0 0
sp_fill_shopping_cart_clo_res 465959 465959 0 0.00 0 14672 14 0 0
sp_get_clo_for_invoice 5093 5093 0 0.00 0 37587 349 0 0
sp_kill_cost_storno 17399 17399 0 0.00 0 6676 44 0 0
sp_kill_qstorno_ret_qs2qd 1161851 1161851 0 0.00 0 21474 28 0 0
sp_kill_qty_storno 612772 612772 0 0.00 0 21477 60 0 0
sp_lock_selected_doc 21355 21355 0 0.00 0 9556 5 0 0
sp_make_cost_storno 28981 28981 0 0.00 0 16966 52 0 0
sp_multiply_rows_for_pdistr 28981 28981 0 0.00 0 10416 25 0 0
sp_multiply_rows_for_qdistr 21447 21447 0 0.00 0 24084 169 0 0
sp_pay_from_customer 7302 7302 0 0.00 4 11552 112 0 0
sp_pay_to_supplier 6234 6234 0 0.00 4 18508 116 0 0
sp_payment_common 13536 13536 0 0.00 1 10546 33 0 0
sp_qd_handle_on_cancel_clo 1810 1810 0 0.00 0 18899 242 0 0
sp_qd_handle_on_invoice_upd_sts 10999 10999 0 0.00 0 15598 269 0 0
sp_qd_handle_on_reserve_upd_sts 10353 10353 0 0.00 0 17862 58 0 0
sp_reserve_write_off 10353 10353 0 0.00 6 17878 176 0 0
sp_supplier_invoice 5739 5739 0 0.00 7 112390 3206 0 0
sp_supplier_order 5678 5678 0 0.00 5 42555 1223 0 0
srv_aggregate_perf_data 86 86 0 0.00 2922 636978 22834 0 0
srv_fill_mon_cache_memory 145 145 0 0.00 1034 168316 37445 0 0
srv_find_qd_qs_mism 1079741 1079741 0 0.00 0 13602 5 0 0
srv_make_invnt_saldo 580 580 0 0.00 34 20363 914 0 0
srv_make_money_saldo 794 794 0 0.00 1 2150 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 155057 339904 261105 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5096 5096 0 0.00 0 9345 149 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 1 6035 97 0 0
t$perf-norm:sp_cancel_client_order 1810 1810 0 0.00 0 1626 8 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 1385 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 1084 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 406 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 418 418 0 0.00 0 3807 31 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 19575 1420 0 0
t$perf-norm:sp_cancel_write_off 1028 1028 0 0.00 0 3006 7 0 0
t$perf-norm:sp_client_order 21447 21447 0 0.00 0 7786 15 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 5407 10 0 0
t$perf-norm:sp_pay_from_customer 7302 7302 0 0.00 0 7770 13 0 0
t$perf-norm:sp_pay_to_supplier 6234 6234 0 0.00 0 5319 10 0 0
t$perf-norm:sp_reserve_write_off 10353 10353 0 0.00 0 8954 12 0 0
t$perf-norm:sp_supplier_invoice 5739 5739 0 0.00 0 7670 20 0 0
t$perf-norm:sp_supplier_order 5678 5678 0 0.00 0 6535 17 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 200 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 145 145 0 0.00 0 596 7 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 6504 33 0 0
t$perf-norm:srv_make_money_saldo 794 794 0 0.00 0 339 4 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10432 10182 250 2.39 0 7087 18 0 250
v_all_customers 38790 38790 0 0.00 0 20 1 0 0
v_all_suppliers 31860 31860 0 0.00 0 18 1 0 0
v_all_wares 42894 42894 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 7095 18 0 0
v_cancel_client_order 3620 3620 0 0.00 0 5169 8 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 1907 5 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 2409 5 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 4053 11 0 0
v_cancel_supplier_invoice 850 836 14 1.64 0 1225 13 0 14
v_cancel_supplier_order 850 850 0 0.00 0 595 4 0 0
v_cancel_write_off 2056 2056 0 0.00 0 6328 19 0 0
v_max_id_clo_ord 5678 5678 0 0.00 0 1792 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 5232 23 0 0
v_max_id_ord_sup 5732 5732 0 0.00 0 6012 5 0 0
v_max_non_paid_invoice 1714 1714 0 0.00 0 222 2 0 0
v_max_non_paid_realizn 4004 4004 0 0.00 0 1885 4 0 0
v_min_id_clo_ord 5678 5678 0 0.00 0 3414 6 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 2734 10 0 0
v_min_id_ord_sup 5732 5732 0 0.00 0 7866 14 0 0
v_min_non_paid_invoice 6234 6234 0 0.00 0 8952 20 0 0
v_min_non_paid_realizn 7302 7302 0 0.00 0 10254 25 0 0
v_our_firm 10700 10700 0 0.00 0 17 1 0 0
v_reserve_write_off 20706 20706 0 0.00 0 7614 6 0 0
x_lock_depdocs_on_canc_invoice 12068 12068 0 0.00 0 14107 103 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 17921 312 0 0
x_make_qstorno_1000_1200 5678 5678 0 0.00 2 42481 1157 0 0
x_make_qstorno_1200_2000 5739 5739 0 0.00 2 101534 3057 0 0
x_make_qstorno_2100_3300 465960 465960 0 0.00 0 77645 144 0 0

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

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:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:19 26182 8192000000 10287969696 10600517632 1016944544 11.043 80 62 125 0 1040903984 2870096 21089344
19:57:57 23737 8192000000 10351753248 10667626496 1401346448 14.607 100 86 172 0 1434293600 5105024 27842128
19:58:30 32982 8192000000 10398792944 10721419264 1436865984 14.922 100 86 172 0 1471303456 6508176 27929296
19:59:18 16699 8192000000 10414600208 10741731328 1472534448 15.236 100 90 181 0 1509248160 7660976 29052736
19:59:47 11828 8192000000 10430198384 10760458240 1486872496 15.362 100 90 180 0 1523927104 8212704 28841904
20:00:08 25440 8192000000 10451934688 10783780864 1502652032 15.499 100 92 184 0 1540525952 8767568 29106352
20:00:42 14213 8192000000 10452273360 10790711296 1512812976 15.588 100 86 172 0 1548992064 9360672 26818416
20:01:04 15849 8192000000 10469138160 10811056128 1530684352 15.743 100 87 174 1 1567529040 9827024 27017664
20:01:28 14554 8192000000 10498018384 10845282304 1553649856 15.941 100 76 152 1 1586805600 10000768 23154976
20:01:56 16734 8192000000 10540195408 10892853248 1587457664 16.232 100 81 162 3 1622092560 10425600 24209296
20:02:22 12306 8192000000 10561765552 10919690240 1612550736 16.446 100 73 146 1 1644569840 10342128 21676976
20:02:44 11095 8192000000 10584223040 10947182592 1635281600 16.640 100 73 147 2 1667985280 11078832 21624848
20:03:03 6772 8192000000 10601440128 10967752704 1663091936 16.875 100 73 146 1 1695871936 11605648 21174352
20:03:19 9390 8192000000 10619645760 10989297664 1680520976 17.022 100 82 164 0 1716866624 12427888 23917760
20:03:37 7604 8192000000 10639473344 11010936832 1703584192 17.215 100 80 161 1 1738844048 12791376 22468480
20:03:52 6343 8192000000 10649925552 11025608704 1710892816 17.276 100 79 158 0 1746962368 13235200 22834352
20:04:14 7422 8192000000 10669883824 11046236160 1730704864 17.441 100 81 162 2 1766230208 13111040 22414304
20:04:30 4481 8192000000 10680770608 11060068352 1744073680 17.552 100 80 160 0 1780203840 14202928 21927232
20:04:43 4959 8192000000 10696312864 11077636096 1759786624 17.683 100 84 166 0 1796541312 13083776 23670912
20:04:56 3296 8192000000 10696204192 11077734400 1763513088 17.713 100 72 144 0 1797388528 13212432 20663008
20:05:05 3503 8192000000 10707352304 11093217280 1775749968 17.814 100 80 160 0 1810915984 12452352 22713664
20:05:16 4356 8192000000 10709101056 11098738688 1778559040 17.838 100 65 130 1 1808696096 12056224 18080832
20:05:27 4364 8192000000 10740286704 11129561088 1796167104 17.982 100 76 151 1 1829034544 11671200 21196240
20:05:39 2018 8192000000 10760019792 11142438912 1813599248 18.125 100 87 175 0 1851561904 13945792 24016864
20:05:48 1829 8192000000 10762734016 11146235904 1818371824 18.164 100 85 167 2 1856357296 14339520 23645952
20:05:56 2732 8192000000 10772388656 11155501056 1829140912 18.252 100 83 167 0 1866489296 14343984 23004400
20:06:05 2269 8192000000 10773122496 11159560192 1831268208 18.270 100 87 176 0 1869839168 14058432 24512528
20:06:14 1725 8192000000 10783739984 11168034816 1837682432 18.322 100 92 185 3 1878226928 14483824 26060672
20:06:23 1751 8192000000 10781039888 11169099776 1842304368 18.360 100 90 180 0 1880696512 14046464 24345680
20:06:31 1679 8192000000 10791091936 11177209856 1842575536 18.362 100 88 177 0 1881052592 13632992 24844064
20:06:39 1304 8192000000 10797708960 11181051904 1854022432 18.455 100 94 187 1 1893640128 13664352 25953344
20:06:47 1688 8192000000 10792504144 11185106944 1858796672 18.494 100 77 153 1 1891310880 11291088 21223120
20:06:55 1681 8192000000 10803038768 11192811520 1855645056 18.468 100 86 170 0 1892408064 12902288 23860720
20:07:03 6382 8192000000 10793981232 11186589696 1855134640 18.464 100 72 146 1 1887716960 11136656 21445664
20:07:16 1794 8192000000 10778156688 11184484352 1854527120 18.459 100 60 119 1 1883021904 11729744 16765040
20:07:25 3265 8192000000 10771665520 11185790976 1855220720 18.465 100 51 102 1 1879744192 10145232 14378240
20:07:36 5654 8192000000 10780085840 11188752384 1856259840 18.473 100 46 91 1 1878099968 9154848 12685280
20:07:48 5580 8192000000 10798780400 11192352768 1862739136 18.525 100 48 96 2 1885229760 9472592 13018032
20:08:01 5550 8192000000 10761304016 11186724864 1859029952 18.495 100 35 70 0 1877387808 8410880 9946976
20:08:15 14864 8192000000 10781319120 11197947904 1868505744 18.572 100 45 89 0 1888797520 5982304 14309472
20:08:36 5709 8192000000 10781969008 11205570560 1871284464 18.595 100 30 62 1 1886881824 7169312 8428048
20:08:49 51210 8192000000 10796789760 11218554880 1877600416 18.646 100 39 79 0 1894587616 5317408 11669792
20:09:46 5001 8192000000 10802099600 11226656768 1883675392 18.695 100 44 88 0 1905940768 10316880 11948496
20:09:59 5839 8192000000 10789844720 11222532096 1880222944 18.667 100 27 54 3 1894297632 6792912 7281776
20:10:11 8658 8192000000 10808454896 11233775616 1886496112 18.718 100 36 73 1 1904856832 8165216 10195504
20:10:28 5738 8192000000 10800724352 11231649792 1886987216 18.721 100 33 66 0 1903797696 6960768 9849712
20:10:44 6239 8192000000 10801062784 11229728768 1884934432 18.705 100 20 40 0 1896528400 5485248 6108720
20:10:59 7185 8192000000 10805503776 11235676160 1890392960 18.749 100 29 58 2 1904831456 6290352 8148144
20:11:13 5263 8192000000 10798300016 11237093376 1898158992 18.811 100 26 52 1 1911914928 6048208 7707728
20:11:26 5671 8192000000 10809328128 11242393600 1895615152 18.791 100 27 54 3 1909956928 6618368 7723408
20:11:39 12557 8192000000 10804484928 11238051840 1892862016 18.769 100 13 26 0 1901585360 5018144 3705200
20:12:03 10141 8192000000 10802476320 11239854080 1892866208 18.769 100 12 24 2 1901914320 5705376 3342736
20:12:20 13659 8192000000 10809956384 11247652864 1898551312 18.815 100 13 26 1 1908234384 5674832 4008240
20:12:42 9298 8192000000 10812154176 11250249728 1905686000 18.872 100 16 32 2 1916535232 5823472 5025760
20:13:04 11142 8192000000 10812192720 11253084160 1903321024 18.853 100 16 32 0 1913642432 5814672 4506736
20:13:22 22366 8192000000 10804447536 11250937856 1903420896 18.854 100 18 36 0 1914546272 5689264 5436112
20:13:56 37628 8192000000 10839158160 11256160256 1892019536 18.762 99 62 123 2 1916724224 6383696 18320992
20:14:45 11719 8192000000 10798945856 11239297024 1881474224 18.677 99 23 45 6 1893841120 5497264 6869632
20:15:06 7403 8192000000 10814988400 11250208768 1897750096 18.808 100 18 36 2 1908415792 5538896 5126800
20:15:19 6639 8192000000 10817693456 11254423552 1904359568 18.861 100 35 70 1 1922451808 8358800 9733440
20:15:34 7807 8192000000 10820748480 11251421184 1902236352 18.844 100 34 68 3 1918796928 6721456 9839120
20:15:49 6273 8192000000 10799996752 11223056384 1842160208 18.358 97 28 56 0 1855811792 5376208 8275376
20:16:02 12024 8192000000 10795330432 11230887936 1869901440 18.583 99 13 25 0 1878692624 5154384 3636800
20:16:20 10182 8192000000 10786453584 11218735104 1870051824 18.585 99 17 34 0 1880628816 5922592 4654400
20:16:39 10185 8192000000 10777677488 11210854400 1828729040 18.249 97 18 36 3 1839737632 5581504 5427088
20:16:57 6810 8192000000 10738918144 11159302144 1800933056 18.022 98 14 26 1 1809745280 5238352 3573872
20:17:11 8510 8192000000 10731535184 11154223104 1751756784 17.616 95 20 40 2 1762793008 5352496 5683728
20:17:29 6080 8192000000 10735449680 11159367680 1820629040 18.183 100 19 38 3 1831396704 5631120 5136544
20:17:42 11469 8192000000 10705004912 11124281344 1681562112 17.030 92 19 38 0 1692566832 5267984 5736736
20:18:07 5887 8192000000 10694276336 11098726400 1711085520 17.278 96 17 34 1 1721564912 5763088 4716304
20:18:19 14172 8192000000 10700750496 11108397056 1734663888 17.474 97 20 40 0 1746289248 6273680 5351680
20:18:40 29990 8192000000 10683988912 11108151296 1761420560 17.696 98 31 62 1 1776092576 5617792 9054224
20:19:34 23409 8192000000 10674467392 11094929408 1680211408 17.019 94 16 32 0 1689658688 5057392 4389888
20:20:04 7261 8192000000 10700323344 11115491328 1752668256 17.624 98 23 47 1 1764512976 6048144 5796576
20:20:20 7646 8192000000 10666850800 11076689920 1701629968 17.199 95 37 71 6 1718885776 6302800 10953008
20:20:34 7902 8192000000 10697134384 11103617024 1746358432 17.571 98 33 61 2 1760141216 5420880 8361904
20:20:49 7358 8192000000 10725225456 11128823808 1785114240 17.892 100 41 82 1 1807823680 11256064 11453376
20:21:03 6842 8192000000 10721892288 11125579776 1759088656 17.677 97 27 55 0 1772468128 5590832 7788640
20:21:17 7448 8192000000 10726952336 11141615616 1804830544 18.054 100 24 48 0 1818017936 6463952 6723440
20:21:33 12160 8192000000 10715878288 11139428352 1767939104 17.750 97 23 46 1 1780187072 5715600 6532368
20:21:52 5005 8192000000 10734905520 11158077440 1822564800 18.199 100 29 58 0 1836808672 5408096 8835776
20:22:04 8220 8192000000 10741680368 11165249536 1827138976 18.236 100 21 41 2 1839777600 4978832 7659792
20:22:20 6268 8192000000 10753737056 11176075264 1832002944 18.276 100 15 29 1 1845824160 9627056 4194160
20:22:37 10944 8192000000 10759304192 11184033792 1847384736 18.401 100 22 44 3 1859656960 5587312 6684912
20:22:56 10321 8192000000 10758939376 11187568640 1848975952 18.414 100 27 54 0 1862040096 5311648 7752496
20:23:13 11995 8192000000 10761221376 11186814976 1846924144 18.397 100 8 16 0 1853960736 4922944 2113648
20:23:36 44716 8192000000 10771700784 11199508480 1859405968 18.498 100 32 61 0 1877050160 5903728 11740464
20:24:44 12478 8192000000 10790983088 11211358208 1866666672 18.557 100 34 68 1 1882053648 6479280 8907696
20:25:05 8640 8192000000 10779021072 11209863168 1868873072 18.575 100 26 47 2 1882560672 6598480 7089120
20:25:20 6671 8192000000 10780750464 11209535488 1869359968 18.579 100 30 61 0 1883659808 5706800 8593040
20:25:36 7398 8192000000 10781872560 11216912384 1870941792 18.592 100 29 58 2 1890454512 10649984 8862736
20:25:51 10749 8192000000 10792908736 11220398080 1870598688 18.589 100 21 41 2 1886321840 9569872 6153280
20:26:08 10703 8192000000 10784708992 11214352384 1871413792 18.596 100 24 48 0 1884480224 6374000 6692432
20:26:25 9242 8192000000 10790324144 11216834560 1872180160 18.602 100 21 41 3 1883235888 5455088 5600640
20:26:43 9032 8192000000 10779755520 11214856192 1872935920 18.608 100 22 44 2 1885577136 6746448 5894768
20:27:00 9768 8192000000 10795891680 11223080960 1877292976 18.643 100 16 32 0 1886960240 4891440 4775824
20:27:29 30238 8192000000 10841017632 11257274368 1906809568 18.881 100 48 96 0 1927291328 6299552 14182208
20:28:06 17856 8192000000 10863842848 11280834560 1924263424 19.021 100 56 110 3 1950075872 9707728 16104720
20:28:30 12838 8192000000 10858432960 11288293376 1929762816 19.065 100 46 92 1 1951727104 9530288 12434000
20:29:03 19056 8192000000 10873084368 11296153600 1939706976 19.144 100 54 108 1 1967003008 11232176 16063856
20:29:30 12758 8192000000 10874052480 11300040704 1942613760 19.168 100 40 81 1 1963987456 9940992 11432704
20:29:56 65582 8192000000 10866838544 11310256128 1927668016 19.048 99 30 60 0 1947901456 12087536 8145904
20:31:11 27221 8192000000 10865267360 11317141504 1942416464 19.166 100 28 56 1 1966911744 16236976 8258304
20:31:45 13915 8192000000 10876958656 11315376128 1936951184 19.122 99 45 91 2 1963916704 13343760 13621760
20:32:06 14797 8192000000 10899968624 11327025152 1958501280 19.294 100 53 102 1 1986813120 13473536 14838304
20:32:35 4569 8192000000 10903614704 11335667712 1963105936 19.331 100 44 88 0 1987552144 12311696 12134512
20:32:48 4477 8192000000 10897397376 11327385600 1960308992 19.308 100 46 91 0 1986255264 13414112 12532160
20:33:00 6664 8192000000 10917019280 11343343616 1951684720 19.240 99 53 106 3 1985448496 18559888 15203888
20:33:14 1909 8192000000 10903455216 11331223552 1964298000 19.340 100 56 112 0 1994806464 14484064 16024400
20:33:30 2937 8192000000 10897419200 11323228160 1931416512 19.078 98 59 118 0 1963183040 15484416 16282112
20:33:41 10676 8192000000 10906172496 11333509120 1945965776 19.194 99 62 122 1 1981059936 17550960 17543200
20:33:59 7784 8192000000 10906097296 11335471104 1963195840 19.331 100 64 127 2 2001182272 19020560 18965872
20:34:14 2111 8192000000 10918383760 11340062720 1966144768 19.355 100 75 150 0 2008138160 19327312 22666080
20:34:23 14774 8192000000 10907846768 11331055616 1941909968 19.162 99 60 118 0 1978463888 19716592 16837328
20:34:49 8250 8192000000 10890520064 11318505472 1920981936 18.995 98 64 129 3 1962124816 22560928 18581952
20:35:06 9928 8192000000 10890858352 11315867648 1918689776 18.976 98 54 108 1 1958690128 24029136 15971216
20:35:41 4533 8192000000 10922578720 11337412608 1958557632 19.295 100 63 126 2 1999781248 22459104 18764512
20:35:55 16429 8192000000 10917344608 11347505152 1964966880 19.346 100 50 98 4 2002172096 22739392 14465824
20:36:20 2251 8192000000 10897611376 11323691008 1937367072 19.126 98 69 134 3 1983331920 25580448 20384400
20:36:29 4059 8192000000 10928726432 11342962688 1962453056 19.326 100 69 138 1 2009819792 26975040 20391696
20:36:41 2732 8192000000 10929452448 11347177472 1966386736 19.357 100 78 156 0 2018324672 28709344 23228592
20:36:51 5551 8192000000 10934862128 11342897152 1963130096 19.331 100 71 141 1 2011234320 27705392 20398832
20:37:03 2178 8192000000 10939498128 11349032960 1963071472 19.330 100 87 167 1 2015865168 28252960 24540736
20:37:12 3483 8192000000 10924423392 11345543168 1966712384 19.359 100 65 130 0 2009474528 23577456 19184688
20:37:22 3210 8192000000 10931735568 11351601152 1971870640 19.400 100 74 148 2 2017666496 24215632 21580224
20:37:33 5936 8192000000 10927105648 11347562496 1968551376 19.374 100 73 145 0 2013110480 23964656 20594448
20:37:48 14500 8192000000 10936980880 11364663296 1981259248 19.475 100 63 126 0 2023728976 23403216 19066512
20:38:14 3683 8192000000 10945268736 11366813696 1991456320 19.555 100 70 140 1 2034988320 22950016 20581984
20:38:25 2247 8192000000 10950518736 11377942528 1990427184 19.547 100 55 110 1 2032680640 25714656 16538800
20:38:34 5461 8192000000 10910949120 11334955008 1955791520 19.273 99 59 118 2 2000117008 25725424 18600064
20:38:47 3812 8192000000 10923948080 11338952704 1941796912 19.161 99 69 136 2 1989081536 26049792 21234832
20:38:58 2296 8192000000 10927927424 11340206080 1954234512 19.260 100 82 164 0 2011984176 32131344 25618320
20:39:07 3619 8192000000 10899856528 11314429952 1935480736 19.111 100 78 151 3 1987657600 28279760 23897104
20:39:19 4293 8192000000 10896345872 11312074752 1934174752 19.100 100 75 147 1 1986155984 29288544 22692688
20:39:35 6232 8192000000 10905029168 11324035072 1938239920 19.133 100 59 118 2 1988996704 32072000 18684784
20:39:49 6108 8192000000 10901477040 11320492032 1921869392 19.002 99 68 136 1 1976147728 32648640 21629696
20:40:03 4585 8192000000 10912311568 11315204096 1934852368 19.106 100 88 175 1 1995173584 32956752 27364464
20:40:15 9444 8192000000 10885657456 11294072832 1910410928 18.910 99 79 158 2 1970727008 36110832 24205248
20:40:35 2630 8192000000 10908955984 11316506624 1927071232 19.043 100 86 173 1 1994419520 39498880 27849408
20:40:45 2154 8192000000 10922169616 11327217664 1935492704 19.111 100 78 155 2 1998755168 39131680 24130784
20:40:54 1034 8192000000 10889330624 11285389312 1897996288 18.810 99 83 165 1 1963673264 39088464 26588512
20:41:02 1383 8192000000 10911080880 11312574464 1920747312 18.993 100 79 157 1 1985992752 39836896 25408544
20:41:09 3040 8192000000 10907077408 11314262016 1930662688 19.072 100 77 151 1 1989279904 35314880 23302336
20:41:19 5269 8192000000 10902039760 11313905664 1915574560 18.951 99 60 120 0 1965858352 31829536 18454256
20:41:32 8119 8192000000 10884602128 11314216960 1927383488 19.046 100 51 100 2 1974284304 31162288 15738528
20:41:54 2332 8192000000 10906024144 11316965376 1914468240 18.942 99 67 135 1 1969852944 33996576 21388128
20:42:04 4849 8192000000 10871821552 11288117248 1887834064 18.728 99 63 126 3 1943120128 35256928 20029136
20:42:18 4636 8192000000 10888875568 11311595520 1915806896 18.953 100 55 110 0 1975311952 41799728 17705328
20:42:29 2583 8192000000 10905395152 11318427648 1924335776 19.022 100 65 129 0 1988634192 43762848 20535568
20:42:45 12425 8192000000 10901169568 11335086080 1927338800 19.046 100 39 77 2 1983893040 43886608 12667632
20:43:05 5746 8192000000 10888864464 11326529536 1928396816 19.054 100 36 70 1 1980402640 39945360 12060464
20:43:24 5827 8192000000 10904163376 11336392704 1921618592 19.000 99 48 95 0 1981115728 44236672 15260464
20:43:37 10187 8192000000 10895900592 11330277376 1933633344 19.096 100 38 74 3 1984974624 38854368 12486912
20:43:54 17928 8192000000 10902880752 11341615104 1940431824 19.150 100 40 80 1 1993115616 39818176 12865616
20:44:24 10605 8192000000 10908246224 11340267520 1936637312 19.120 100 29 58 1 1989610624 42671888 10301424
20:44:44 10124 8192000000 10908466016 11350732800 1944204352 19.180 100 41 81 3 2001052192 43396768 13451072
20:45:11 21897 8192000000 10925858240 11370909696 1954711136 19.264 100 36 72 0 2012421344 45382960 12327248
20:45:42 12221 8192000000 10939337600 11372732416 1954055904 19.259 100 37 74 0 2015847776 48921072 12870800
20:46:08 14951 8192000000 10923469824 11368574976 1934464832 19.103 99 35 70 0 1999587984 53061808 12061344
20:46:35 11202 8192000000 10924741568 11378688000 1955898992 19.273 100 36 73 1 2017002224 48218208 12885024
20:47:05 22858 8192000000 10927057504 11374534656 1960599248 19.311 100 33 66 1 2014778224 43297520 10881456
20:47:35 11288 8192000000 10933367392 11378995200 1961969328 19.322 100 27 55 1 2012814432 41864992 8980112
20:47:57 27038 8192000000 10935426512 11387736064 1966147776 19.355 100 25 50 0 2020990560 46295968 8546816
20:48:54 25269 8192000000 10925488272 11371114496 1945063472 19.187 99 33 66 0 1999086608 43191728 10831408
20:49:43 20019 8192000000 10907162912 11361046528 1903993584 18.858 98 26 52 0 1968519136 54246944 10278608
20:50:15 36666 8192000000 10894855568 11368783872 1924045040 19.019 100 18 36 0 1979613824 48796640 6772144
20:51:08 48297 8192000000 10862500112 11321204736 1910617824 18.912 99 15 30 1 1925973248 11220912 4134512
20:52:11 39190 8192000000 10887602416 11340148736 1939554992 19.143 100 20 40 0 1955655648 10429056 5671600
20:52:59 94455 8192000000 10874697520 11353456640 1948862032 19.217 100 7 14 1 1963590304 12907488 1820784
20:54:46 32792 8192000000 10890392016 11354910720 1930258016 19.069 99 10 20 0 1944683632 11668656 2756960
20:55:26 22651 8192000000 10870976144 11341107200 1933049952 19.091 99 22 46 0 1952586928 12518752 7018224
20:56:06 80832 8192000000 10884198160 11340550144 1891171232 18.755 97 12 24 1 1913973424 19117024 3685168
20:57:34 119099 8192000000 10874365248 11343949824 1931024336 19.075 99 23 46 2 1958397408 20263088 7109984
20:59:52 44491 8192000000 10877319904 11325030400 1935356896 19.110 99 36 68 3 1950647552 5539776 9750880
21:00:43 168314 8192000000 10915831504 11371450368 1942901952 19.170 99 27 54 0 1962915152 13018720 6994480
21:03:55 77112 8192000000 10923622752 11369586688 1964889744 19.345 99 32 63 2 1985201792 10841376 9470672
21:05:19 24664 8192000000 10923679328 11388825600 1997922288 19.606 100 57 113 1 2032722832 17186016 17614528
21:05:58 53988 8192000000 10910148640 11395719168 1990644912 19.549 100 13 26 1 2009362864 14706608 4011344
21:06:59 25957 8192000000 10902845712 11379171328 1971050544 19.394 99 7 14 1 1986237616 13190928 1996144
21:07:31 78114 8192000000 10906718544 11390169088 1965329232 19.348 99 18 36 1 1989807760 19060896 5417632
21:09:17 77264 8192000000 10913112368 11383713792 1985357760 19.507 100 14 28 0 1997940048 8435328 4146960
21:10:41 41144 8192000000 10903356736 11383861248 1989710384 19.542 100 12 24 1 2004864288 12089856 3064048
21:11:38 77867 8192000000 10909079152 11399155712 1977965280 19.449 99 12 24 0 1993029104 11756704 3307120
21:13:02 71034 8192000000 10927760192 11415113728 1995266064 19.585 100 14 28 0 2017740800 18616528 3858208
21:14:19 38540 8192000000 10926256320 11401232384 1985129296 19.505 99 10 20 0 1998314400 10569904 2615200
21:15:04 99659 8192000000 10913984160 11382386688 1919737792 18.985 96 15 30 2 1935874896 11743760 4393344
21:16:57 20000 8192000000 10962482672 11401310208 2003311440 19.649 100 50 100 3 2025915680 8345360 14258880
21:17:23 43817 8192000000 10930700032 11400994816 1989861520 19.543 99 44 88 0 2013986288 11962560 12162208
21:18:17 85643 8192000000 10901112112 11381719040 1896993696 18.802 95 21 42 1 1917051840 13951936 6106208
21:19:52 33150 8192000000 10903940352 11367067648 1928698016 19.056 97 31 62 0 1948839424 11512928 8628480
21:20:32 55434 8192000000 10906548656 11379482624 1897093488 18.803 96 22 44 1 1917661712 14503536 6064688
21:21:36 93144 8192000000 10857826672 11323404288 1818299200 18.164 93 12 24 1 1839983760 18883648 2800912
21:23:16 42990 8192000000 10855781184 11320426496 1858786576 18.493 96 28 54 2 1882700480 15508512 8405392
21:24:10 153272 8192000000 10871158512 11333017600 1892520896 18.766 98 9 18 0 1913052528 18264112 2267520
21:27:11 29834 8192000000 10877335952 11336134656 1938631040 19.136 99 41 80 6 1956692048 5802400 12258608
21:27:53 65058 8192000000 10833250528 11299057664 1774186832 17.802 91 35 70 1 1801731168 18404880 9139456
21:29:19 7869 8192000000 10841216144 11309555712 1912758304 18.929 100 26 52 1 1935335168 15446032 7130832
21:30:02 29723 8192000000 10839361136 11306082304 1898190576 18.812 99 18 36 0 1912433824 9200560 5042688
21:32:23 48540 8192000000 10856887104 11340066816 1930519680 19.071 100 5 10 0 1945271152 12948688 1802784
21:33:18 50722 8192000000 10851462704 11323183104 1901524064 18.839 98 15 31 1 1914965552 8945312 4496176
21:34:24 70542 8192000000 10869382160 11337207808 1899725328 18.824 97 21 42 0 1920718352 14884784 6108240
21:35:55 99721 8192000000 10869083376 11348529152 1916911472 18.962 98 17 33 1 1932551088 10650688 4988928
21:37:53 45051 8192000000 10890514016 11358093312 1943209424 19.172 99 26 52 1 1963674160 13158720 7306016
21:39:22 113046 8192000000 10835991152 11291303936 1757074224 17.660 90 17 34 0 1776596320 14748064 4774032
21:41:27 104372 8192000000 10856943104 11330383872 1850806064 18.429 96 14 28 3 1868757008 14066256 3884688
21:43:17 37090 8192000000 10906815392 11349012480 1947999648 19.211 100 35 68 1 1975329680 17407744 9922288
21:44:05 41952 8192000000 10882583024 11341758464 1876535920 18.637 96 25 50 2 1900129104 16728624 6864560
21:44:53 55866 8192000000 10867092352 11329974272 1873854608 18.615 97 10 20 0 1897198352 20545248 2798496
21:46:00 132507 8192000000 10851099616 11308879872 1845388256 18.385 95 17 34 1 1862257536 12036784 4832496
21:48:18 65151 8192000000 10870382544 11332280320 1925081968 19.028 99 42 84 0 1949395808 12005776 12308064
21:49:30 9756 8192000000 10870983424 11334651904 1939157952 19.140 100 30 60 0 1957127200 9649696 8319552
21:49:47 28924 8192000000 10850733504 11325890560 1940303344 19.149 100 10 18 1 1950074256 6920800 2850112
21:50:23 37873 8192000000 10871366464 11338919936 1912515376 18.927 98 10 20 0 1924895984 9337168 3043440
21:51:07 58596 8192000000 10879335008 11352379392 1949376480 19.222 100 18 36 1 1968042800 13540384 5125936
21:52:29 68679 8192000000 10884612048 11362246656 1942064096 19.163 99 15 30 0 1964683856 18009776 4609984
21:54:10 117619 8192000000 10893649072 11373768704 1963912112 19.337 100 16 32 0 1982001440 13693024 4396304
21:56:20 103688 8192000000 10903893648 11378368512 1957912112 19.289 99 15 30 0 1976280048 14063744 4304192
21:58:16 56123 8192000000 10917488400 11381534720 1976304928 19.435 99 35 70 0 2001689520 15377760 10006832
21:59:32 88817 8192000000 10915212176 11391012864 1955776608 19.272 98 22 44 2 1976407024 13978576 6651840
22:01:07 60466 8192000000 10914772176 11389845504 1967025984 19.362 99 13 26 1 1984443808 13648944 3768880
22:02:26 82044 8192000000 10935707008 11398021120 1991333920 19.554 100 31 62 0 2011796000 11357360 9104720
22:03:59 52072 8192000000 10939086336 11393286144 1976051168 19.433 99 36 72 1 2000373888 13962432 10360288
22:04:57 16236 8192000000 10928192752 11381100544 1973134432 19.410 99 50 102 2 2002041072 14042160 14864480
22:05:28 64990 8192000000 10911583664 11379122176 1940935280 19.154 98 17 34 0 1962488864 16962272 4591312
22:06:39 64935 8192000000 10905789552 11376365568 1904062048 18.859 96 23 46 1 1934117520 23381968 6673504
22:07:57 87593 8192000000 10879816848 11353735168 1855179136 18.464 94 19 38 0 1871186960 10496784 5511040
22:09:30 113041 8192000000 10876227568 11342757888 1908185392 18.892 97 40 78 1 1927986080 8179824 11620864
22:11:42 68298 8192000000 10864064656 11337093120 1914713440 18.944 98 18 36 1 1928203184 8612928 4876816
22:13:03 46084 8192000000 10864777440 11333980160 1922246960 19.005 98 14 28 2 1932463936 6366928 3850048
22:13:56 61125 8192000000 10860999744 11341746176 1918271952 18.973 98 10 20 0 1929300752 7719392 3309408
22:15:36 41639 8192000000 10841807680 11309686784 1886298384 18.716 98 16 32 1 1898234624 7684224 4252016
22:16:25 71560 8192000000 10833838928 11309993984 1876568464 18.637 97 13 26 1 1886750144 6401136 3780544
22:18:19 61249 8192000000 10861764704 11336175616 1924556656 19.023 99 15 30 1 1939837552 11091232 4189664
22:19:26 83154 8192000000 10858480032 11330965504 1872887168 18.608 96 15 30 1 1894675888 16881200 4907520
22:21:06 88424 8192000000 10866783568 11331604480 1806856688 18.070 93 18 36 0 1824907232 12535216 5515328
22:22:44 53879 8192000000 10872402640 11336011776 1890036592 18.746 98 22 43 1 1909085936 13042736 6006608
22:23:56 66343 8192000000 10855265296 11320061952 1854096480 18.455 95 21 42 0 1876245536 15836992 6312064
22:25:08 41523 8192000000 10852113776 11326447616 1891063952 18.754 98 17 34 1 1914427392 17648480 5714960
22:25:56 51796 8192000000 10822264800 11283263488 1829011856 18.251 95 16 32 2 1850523088 16704816 4806416
22:26:54 13778 8192000000 10870929584 11313213440 1926639872 19.040 100 40 80 1 1947370560 9061040 11669648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-12-2020 22:28:43 to 21-12-2020 22:28:45.

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          249737
MON$OLDEST_ACTIVE               249738
MON$OLDEST_SNAPSHOT             249738
MON$NEXT_TRANSACTION            249738
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                       2012800
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
--- end of diff output ---

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

21.12.20 22:28:46. 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-21 22:28:48 No severe PSQL-related problems occured
21.12.20 22:28:49. End of report.