Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.03.2021 19:28
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17605928 kB
MemAvailable 31495496 kB
Buffers 0 kB
Cached 14041136 kB
SwapCached 0 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 2021-03-22 19:27:23
DTS_END                         2021-03-22 19:27:23.3840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59578
TRN_ID                          235549
ATT_ID                          711
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: 8807.43 22276 1056892
customer order: creation 167.74 373 20129
customer order: refuse 14.48 407 1738
order to supplier: creation 45.23 1270 5427
order to supplier: removal 3.25 103678 390
invoice (draft): creation 45.92 3717 5510
invoice (draft): removal 48.82 804 5858
invoice accept: apply 40.62 19723 4874
invoice accept: cancel 43.97 932 5276
customer reserve: creation 3735.23 196 448227
customer reserve: removal 4379.66 60 525559
realization accept: apply 81.63 189 9796
realization accept: cancel 74.47 118 8936
payment from customer: creation 57.17 132 6860
payment from customer: removal 5.59 80 671
payment to supplier: creation 47.61 137 5713
payment to supplier: removal 3.63 175 436
service: total inventory turnovers 4.95 923 594
service: total monetary turnovers 6.58 24 789
service: aggregate perf. data 0.88 16993 105
service: refresh index statistics 0.03 295588 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2021 19:28:33 to 22-03-2021 19:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5551
TEST_TIME 2 6108
TEST_TIME 3 5423
TEST_TIME 4 5295
TEST_TIME 5 4808
TEST_TIME 6 4977
TEST_TIME 7 5327
TEST_TIME 8 5941
TEST_TIME 9 6178
TEST_TIME 10 6465
TEST_TIME 11 6767
TEST_TIME 12 6823
TEST_TIME 13 6633
TEST_TIME 14 6674
TEST_TIME 15 6750
TEST_TIME 16 7023
TEST_TIME 17 7459
TEST_TIME 18 7418
TEST_TIME 19 7911
TEST_TIME 20 8151
TEST_TIME 21 8584
TEST_TIME 22 9352
TEST_TIME 23 9816
TEST_TIME 24 10282
TEST_TIME 25 10719
TEST_TIME 26 10951
TEST_TIME 27 10788
TEST_TIME 28 10409
TEST_TIME 29 10334
TEST_TIME 30 10458
TEST_TIME 31 10261
TEST_TIME 32 10105
TEST_TIME 33 10034
TEST_TIME 34 10016
TEST_TIME 35 9815
TEST_TIME 36 9740
TEST_TIME 37 9569
TEST_TIME 38 9342
TEST_TIME 39 9269
TEST_TIME 40 9551
TEST_TIME 41 9419
TEST_TIME 42 9330
TEST_TIME 43 9166
TEST_TIME 44 9137
TEST_TIME 45 9032
TEST_TIME 46 8976
TEST_TIME 47 8905
TEST_TIME 48 8881
TEST_TIME 49 8908
TEST_TIME 50 8969
TEST_TIME 51 8894
TEST_TIME 52 8922
TEST_TIME 53 9055
TEST_TIME 54 9184
TEST_TIME 55 9295
TEST_TIME 56 9406
TEST_TIME 57 9381
TEST_TIME 58 9397
TEST_TIME 59 9392
TEST_TIME 60 9562
TEST_TIME 61 9459
TEST_TIME 62 9368
TEST_TIME 63 9295
TEST_TIME 64 9254
TEST_TIME 65 9242
TEST_TIME 66 9194
TEST_TIME 67 9142
TEST_TIME 68 9144
TEST_TIME 69 9075
TEST_TIME 70 9010
TEST_TIME 71 9024
TEST_TIME 72 9045
TEST_TIME 73 9017
TEST_TIME 74 8955
TEST_TIME 75 9002
TEST_TIME 76 8966
TEST_TIME 77 8987
TEST_TIME 78 9029
TEST_TIME 79 9054
TEST_TIME 80 9144
TEST_TIME 81 9133
TEST_TIME 82 9118
TEST_TIME 83 9136
TEST_TIME 84 9149
TEST_TIME 85 9212
TEST_TIME 86 9165
TEST_TIME 87 9142
TEST_TIME 88 9071
TEST_TIME 89 9077
TEST_TIME 90 9023
TEST_TIME 91 8959
TEST_TIME 92 8930
TEST_TIME 93 8947
TEST_TIME 94 8922
TEST_TIME 95 8910
TEST_TIME 96 8936
TEST_TIME 97 8929
TEST_TIME 98 8935
TEST_TIME 99 8902
TEST_TIME 100 9005
TEST_TIME 101 9020
TEST_TIME 102 9001
TEST_TIME 103 9021
TEST_TIME 104 8989
TEST_TIME 105 9020
TEST_TIME 106 9055
TEST_TIME 107 9077
TEST_TIME 108 9113
TEST_TIME 109 9060
TEST_TIME 110 8987
TEST_TIME 111 8946
TEST_TIME 112 8919
TEST_TIME 113 8884
TEST_TIME 114 8837
TEST_TIME 115 8859
TEST_TIME 116 8874
TEST_TIME 117 8863
TEST_TIME 118 8852
TEST_TIME 119 8843
TEST_TIME 120 8818

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2021 19:28:37 to 22-03-2021 19:28:40.

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 1471779 1471779 0 0.00 0 16280 7 0 0
doc_list_biud 1471779 1471779 0 0.00 0 28350 28 0 0
sp_add_invoice_to_stock 5017 4874 143 2.85 17 184816 19724 0 143
sp_cancel_adding_invoice 5276 5276 0 0.00 4 71416 933 0 0
sp_cancel_client_order 1738 1738 0 0.00 4 24160 407 0 0
sp_cancel_customer_reserve 525559 525559 0 0.00 1 28356 61 0 0
sp_cancel_pay_from_customer 671 671 0 0.00 3 5122 81 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 3 20363 175 0 0
sp_cancel_supplier_invoice 5870 5858 12 0.20 1 17682 805 0 12
sp_cancel_supplier_order 390 390 0 0.00 5 1301010 103678 0 0
sp_cancel_write_off 8936 8936 0 0.00 1 16319 118 0 0
sp_client_order 20129 20129 0 0.00 3 25550 374 0 0
sp_customer_reserve 448227 448227 0 0.00 0 48038 196 0 0
sp_fill_shopping_cart 31061 31061 0 0.00 1 24969 42 0 0
sp_fill_shopping_cart_clo_res 448205 448205 0 0.00 0 11508 14 0 0
sp_get_clo_for_invoice 4852 4852 0 0.00 0 22298 363 0 0
sp_kill_cost_storno 15319 15319 0 0.00 0 7065 56 0 0
sp_kill_qstorno_ret_qs2qd 1066302 1066302 0 0.00 0 28347 33 0 0
sp_kill_qty_storno 562405 562405 0 0.00 0 28349 71 0 0
sp_lock_selected_doc 20271 20271 0 0.00 0 9912 6 0 0
sp_make_cost_storno 27221 27221 0 0.00 0 16272 55 0 0
sp_multiply_rows_for_pdistr 27221 27221 0 0.00 0 15527 31 0 0
sp_multiply_rows_for_qdistr 20129 20129 0 0.00 0 16641 180 0 0
sp_pay_from_customer 6860 6860 0 0.00 4 27614 133 0 0
sp_pay_to_supplier 5713 5713 0 0.00 5 23996 138 0 0
sp_payment_common 12573 12573 0 0.00 2 10119 29 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 12247 342 0 0
sp_qd_handle_on_invoice_upd_sts 10128 10128 0 0.00 0 27690 364 0 0
sp_qd_handle_on_reserve_upd_sts 9796 9796 0 0.00 0 14253 54 0 0
sp_reserve_write_off 9796 9796 0 0.00 5 27500 190 0 0
sp_supplier_invoice 5510 5510 0 0.00 7 77534 3718 0 0
sp_supplier_order 5427 5427 0 0.00 6 26746 1271 0 0
srv_aggregate_perf_data 105 105 0 0.00 2465 165617 16993 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 985 142924 32061 0 0
srv_find_qd_qs_mism 1010264 1010264 0 0.00 0 15827 6 0 0
srv_make_invnt_saldo 594 594 0 0.00 37 38792 924 0 0
srv_make_money_saldo 789 789 0 0.00 1 632 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 105311 395899 295588 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4874 4874 0 0.00 0 12359 206 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 5633 114 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 2205 15 0 0
t$perf-norm:sp_cancel_customer_reserve 614 614 0 0.00 0 1916 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 671 671 0 0.00 0 598 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 683 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 803 16 0 0
t$perf-norm:sp_cancel_supplier_order 390 390 0 0.00 0 22241 1495 0 0
t$perf-norm:sp_cancel_write_off 966 966 0 0.00 0 1237 7 0 0
t$perf-norm:sp_client_order 20129 20129 0 0.00 0 11652 19 0 0
t$perf-norm:sp_customer_reserve 982 982 0 0.00 0 6908 18 0 0
t$perf-norm:sp_pay_from_customer 6860 6860 0 0.00 0 9887 12 0 0
t$perf-norm:sp_pay_to_supplier 5713 5713 0 0.00 0 10041 14 0 0
t$perf-norm:sp_reserve_write_off 9796 9796 0 0.00 0 9026 12 0 0
t$perf-norm:sp_supplier_invoice 5510 5510 0 0.00 0 7047 23 0 0
t$perf-norm:sp_supplier_order 5427 5427 0 0.00 0 7139 18 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 660 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 502 8 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 2417 26 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 2625 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 9990 9704 286 2.86 0 27453 28 0 286
v_all_customers 36250 36250 0 0.00 0 95 1 0 0
v_all_suppliers 30112 30112 0 0.00 0 187 1 0 0
v_all_wares 40258 40258 0 0.00 0 80 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 5779 15 0 0
v_cancel_client_order 3476 3476 0 0.00 0 24069 20 0 0
v_cancel_customer_prepayment 1342 1342 0 0.00 0 3314 8 0 0
v_cancel_customer_reserve 1228 1228 0 0.00 0 12796 25 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 20314 55 0 0
v_cancel_supplier_invoice 836 812 24 2.87 0 815 17 0 24
v_cancel_supplier_order 780 780 0 0.00 0 17680 38 0 0
v_cancel_write_off 1932 1932 0 0.00 0 13552 20 0 0
v_max_id_clo_ord 5427 5427 0 0.00 0 227 1 0 0
v_max_id_clo_res 982 982 0 0.00 0 4220 26 0 0
v_max_id_ord_sup 5505 5505 0 0.00 0 6086 7 0 0
v_max_non_paid_invoice 1589 1589 0 0.00 0 418 3 0 0
v_max_non_paid_realizn 3829 3829 0 0.00 0 1813 4 0 0
v_min_id_clo_ord 5427 5427 0 0.00 0 5781 9 0 0
v_min_id_clo_res 982 982 0 0.00 0 720 3 0 0
v_min_id_ord_sup 5505 5505 0 0.00 0 7108 8 0 0
v_min_non_paid_invoice 5713 5713 0 0.00 0 7666 18 0 0
v_min_non_paid_realizn 6860 6860 0 0.00 0 9316 21 0 0
v_our_firm 10070 10070 0 0.00 0 19 1 0 0
v_reserve_write_off 19592 19592 0 0.00 0 27291 14 0 0
x_lock_depdocs_on_canc_invoice 10728 10728 0 0.00 0 17896 133 0 0
x_lock_depdocs_on_canc_sup_ord 390 390 0 0.00 0 8916 366 0 0
x_make_qstorno_1000_1200 5427 5427 0 0.00 2 26730 1188 0 0
x_make_qstorno_1200_2000 5510 5510 0 0.00 3 77522 3569 0 0
x_make_qstorno_2100_3300 448227 448227 0 0.00 0 48011 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2021 19:28:41 to 22-03-2021 19:28:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:27 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 16403 8192000000 10241527568 10549882880 1010226016 10.978 79 62 123 1 1033808816 2829616 20753184
16:58:00 32013 8192000000 10353449168 10668556288 1388033600 14.488 100 85 170 0 1420350352 4918448 27398304
16:58:42 27823 8192000000 10382751168 10704261120 1433734640 14.894 100 90 180 0 1471291376 7296720 30260016
16:59:20 22185 8192000000 10412656144 10736459776 1448159200 15.022 100 88 176 0 1484828048 7979072 28689776
16:59:56 23027 8192000000 10425804336 10755186688 1476181120 15.268 100 91 182 2 1515412736 9254928 29976688
17:00:33 16521 8192000000 10441464512 10776219648 1490929648 15.397 100 87 174 0 1529140704 10066688 28144368
17:01:01 26766 8192000000 10472044896 10811023360 1513098656 15.590 100 79 158 1 1548741120 10416736 25225728
17:01:42 22859 8192000000 10501063280 10850201600 1555233984 15.955 100 85 170 0 1593756400 11688960 26833456
17:02:14 17194 8192000000 10517116512 10868355072 1572726192 16.106 100 78 156 1 1608521776 11444336 24351248
17:02:38 11330 8192000000 10533064768 10886045696 1591504432 16.267 100 76 152 1 1626559728 11495728 23559568
17:02:58 14533 8192000000 10556039376 10912509952 1612568880 16.447 100 80 159 1 1647554016 11681520 23303616
17:03:22 10268 8192000000 10573089088 10931089408 1628428400 16.582 100 81 162 1 1665425696 12812368 24184928
17:03:43 12795 8192000000 10599952416 10965225472 1658254672 16.834 100 80 159 1 1693938048 12023792 23659584
17:04:08 12213 8192000000 10625556256 10993405952 1679665040 17.015 100 80 159 0 1715530464 12370176 23495248
17:04:31 7301 8192000000 10655724688 11021774848 1708149488 17.253 100 85 168 1 1746045552 13126624 24769440
17:04:46 7668 8192000000 10657190448 11033292800 1716474992 17.323 100 77 155 0 1752542960 13541712 22526256
17:05:00 7196 8192000000 10676301984 11048046592 1733969888 17.469 100 90 180 1 1773981536 14530656 25480992
17:05:14 7268 8192000000 10674724880 11051462656 1739730640 17.516 100 80 158 1 1775126560 13319312 22076608
17:05:32 4552 8192000000 10692104656 11067641856 1750740064 17.608 100 80 160 1 1785934320 12746560 22447696
17:05:45 3783 8192000000 10701220928 11077607424 1761305136 17.695 100 87 174 1 1799728992 13892896 24530960
17:05:55 3867 8192000000 10711376496 11084054528 1765138240 17.727 100 89 174 2 1803940912 14382080 24420592
17:06:05 4356 8192000000 10710353888 11085008896 1767708928 17.748 100 93 184 3 1808818256 15552032 25557296
17:06:16 6489 8192000000 10715956704 11092422656 1771648384 17.781 100 84 166 2 1809316320 14578000 23089936
17:06:29 2804 8192000000 10723929056 11099406336 1782623344 17.871 100 92 183 3 1821750944 13369072 25758528
17:06:38 2693 8192000000 10727230928 11102912512 1785147440 17.892 100 95 187 1 1824644560 13886064 25611056
17:06:48 8644 8192000000 10723038976 11114225664 1793480640 17.960 100 73 146 2 1826904368 13748624 19675104
17:07:03 4113 8192000000 10751990096 11134722048 1802610448 18.035 100 83 163 2 1839177232 13229872 23336912
17:07:14 3030 8192000000 10755466928 11142197248 1813614672 18.125 100 85 171 1 1850828256 13006768 24206816
17:07:24 2751 8192000000 10762022704 11145179136 1818810832 18.168 100 87 172 2 1856136608 12697856 24627920
17:07:34 2929 8192000000 10764808528 11148816384 1822242080 18.196 100 82 163 3 1857037456 12012848 22782528
17:07:43 2368 8192000000 10775202832 11158814720 1831529344 18.272 100 92 184 0 1871145472 13668752 25947376
17:07:52 1843 8192000000 10786458544 11168735232 1840749872 18.347 100 91 181 1 1879901792 12755504 26396416
17:08:01 2033 8192000000 10786649344 11172335616 1846383776 18.393 100 92 184 1 1884713616 12801328 25528512
17:08:10 2189 8192000000 10800854704 11184766976 1856640400 18.476 100 96 189 3 1896925360 13181248 27103712
17:08:18 1424 8192000000 10800268384 11186524160 1857160240 18.480 100 94 189 2 1896457520 12131568 27165712
17:08:26 1682 8192000000 10804127248 11189473280 1858555360 18.492 100 94 188 1 1897840304 12870016 26414928
17:08:34 1257 8192000000 10815366432 11201671168 1868470048 18.572 100 94 188 1 1906903856 12176912 26256896
17:08:41 1085 8192000000 10809697888 11200135168 1865186656 18.545 100 86 175 0 1902400016 12944944 24268416
17:08:49 25225 8192000000 10798930880 11200274432 1861889808 18.519 100 62 124 2 1890682464 11317648 17475008
17:09:20 3518 8192000000 10806034736 11208433664 1871530512 18.597 100 73 147 1 1902510832 10118672 20861648
17:09:42 1803 8192000000 10824310016 11214798848 1877521344 18.645 100 95 190 3 1916605680 11693904 27390432
17:09:50 4846 8192000000 10806284416 11210063872 1872832384 18.607 100 52 104 0 1898889520 11731648 14325488
17:10:02 4880 8192000000 10799040976 11215097856 1875287584 18.627 100 40 81 0 1894590192 7659584 11643024
17:10:14 6492 8192000000 10802708720 11214270464 1877270720 18.643 100 43 86 1 1898799648 8478256 13050672
17:10:28 3963 8192000000 10809862528 11224453120 1885231264 18.707 100 42 85 3 1904898704 8050288 11617152
17:10:38 8986 8192000000 10795159280 11220389888 1887027600 18.722 100 31 62 0 1902470672 6655248 8787824
17:10:54 64444 8192000000 10807782256 11236753408 1890486576 18.750 100 32 63 2 1904807728 5168272 9152880
17:12:10 15598 8192000000 10804800784 11236421632 1890382480 18.749 100 19 37 3 1901495280 6013360 5099440
17:12:32 6013 8192000000 10818790832 11246424064 1899872416 18.825 100 36 72 4 1921688080 11463488 10352176
17:12:46 5865 8192000000 10811562288 11241398272 1902477136 18.846 100 35 70 1 1919866992 6922208 10467648
17:12:59 9749 8192000000 10818031920 11249508352 1904762160 18.865 100 20 40 4 1916488976 6168960 5557856
17:13:16 2837 8192000000 10829604720 11252326400 1907639056 18.888 100 37 73 4 1924041664 6336720 10065888
17:13:28 10157 8192000000 10813716720 11251527680 1905223248 18.868 100 22 44 0 1917430928 5945840 6261840
17:13:45 8221 8192000000 10820191088 11254480896 1905251376 18.869 100 22 44 1 1917603872 5725200 6627296
17:14:04 6598 8192000000 10822218368 11252822016 1906439968 18.878 100 25 51 0 1920534864 6763888 7331008
17:14:17 10201 8192000000 10812562720 11250651136 1905700752 18.872 100 22 44 4 1918629728 6920832 6008144
17:14:35 6458 8192000000 10812552816 11251556352 1905438512 18.870 100 14 28 1 1919130544 9776800 3915232
17:14:51 6308 8192000000 10820363184 11257069568 1909146512 18.900 100 26 52 2 1927199616 10894144 7158960
17:15:04 17638 8192000000 10811714224 11248037888 1894745776 18.784 99 30 56 0 1910165200 5318304 10101120
17:15:30 49594 8192000000 10852800608 11262889984 1914255216 18.941 100 61 124 2 1937647120 5178208 18213696
17:16:25 14603 8192000000 10805992048 11244023808 1850535584 18.426 97 18 36 0 1860996144 5720544 4740016
17:16:46 10313 8192000000 10812982560 11240919040 1860095616 18.504 98 19 38 0 1871384576 5724688 5564272
17:17:08 3925 8192000000 10814987376 11230920704 1880387600 18.668 99 46 93 2 1900917008 7463168 13066240
17:17:19 7143 8192000000 10787485712 11215380480 1854520496 18.459 98 22 44 4 1866564080 5525136 6518448
17:17:33 9198 8192000000 10798909040 11231662080 1886126912 18.715 100 21 43 0 1898719744 6788016 5804816
17:17:49 9441 8192000000 10792887824 11223085056 1863808176 18.534 99 27 55 0 1878060112 5896272 8355664
17:18:07 6852 8192000000 10789797680 11228966912 1885765696 18.712 100 25 50 1 1899592192 6612896 7213600
17:18:20 9085 8192000000 10784090320 11218636800 1864782064 18.542 99 25 51 0 1877664112 5844432 7037616
17:18:38 8591 8192000000 10776093856 11203559424 1816309024 18.148 97 23 46 2 1828350352 6334512 5706816
17:18:59 5960 8192000000 10728855104 11155685376 1790110928 17.933 97 30 60 1 1805496944 6836176 8549840
17:19:12 6795 8192000000 10741714720 11164930048 1792465904 17.952 97 26 51 1 1805942912 5616608 7860400
17:19:26 7672 8192000000 10705014896 11121078272 1705724416 17.233 93 27 52 1 1718723776 4715024 8284336
17:19:41 60335 8192000000 10707035040 11103432704 1690255216 17.103 93 34 71 1 1705656192 4622224 10778752
17:20:48 14580 8192000000 10692473872 11108016128 1704687664 17.224 94 32 63 4 1718636240 4888864 9059712
17:21:12 11012 8192000000 10678902752 11091521536 1726281120 17.405 96 23 46 0 1738425248 5364288 6779840
17:21:31 7566 8192000000 10696748880 11101908992 1763826416 17.716 98 28 56 1 1777361856 5320816 8214624
17:21:45 8649 8192000000 10712696480 11126358016 1744905248 17.559 97 18 36 0 1754217280 4546080 4765952
17:22:05 5940 8192000000 10681214368 11096518656 1723380688 17.380 96 22 44 2 1734914464 5656832 5876944
17:22:17 7053 8192000000 10693930752 11114602496 1775265584 17.810 99 32 65 3 1790274960 5543936 9465440
17:22:31 8829 8192000000 10723823008 11144183808 1806068704 18.064 100 24 48 2 1818550480 5968944 6512832
17:22:46 8260 8192000000 10744964032 11159875584 1806498192 18.067 99 23 45 1 1818293504 5005104 6790208
17:23:01 9274 8192000000 10739947280 11156131840 1791186144 17.942 98 30 58 3 1804767952 5158368 8423440
17:23:17 13024 8192000000 10743819264 11169456128 1832736672 18.282 100 27 54 2 1846045456 5732528 7576256
17:23:40 8768 8192000000 10756428976 11182436352 1844807328 18.380 100 24 47 1 1856874144 5319632 6747184
17:23:55 8410 8192000000 10741286784 11172712448 1823604768 18.207 99 15 30 0 1833859680 6208240 4046672
17:24:10 8292 8192000000 10751961168 11184119808 1847684400 18.403 100 31 60 2 1863427840 6707552 9035888
17:24:25 10478 8192000000 10778464512 11195363328 1850856400 18.429 100 14 28 1 1860316576 5222128 4238048
17:24:44 19107 8192000000 10773325888 11201658880 1857212976 18.481 100 25 50 1 1870066032 5848672 7004384
17:25:10 54332 8192000000 10807109344 11212279808 1867451056 18.564 100 63 128 0 1893138048 5791392 19895600
17:26:11 22156 8192000000 10775684128 11208122368 1868214560 18.570 100 23 46 1 1880777504 5914656 6648288
17:26:39 9026 8192000000 10791501248 11217821696 1872518512 18.605 100 29 58 3 1891020320 10498912 8002896
17:26:56 9387 8192000000 10798720784 11222818816 1870485056 18.588 100 25 50 1 1883308080 6319872 6503152
17:27:11 6292 8192000000 10800862816 11226722304 1883795824 18.696 100 29 59 1 1897800496 5602848 8401824
17:27:25 9574 8192000000 10825211360 11239567360 1893969984 18.778 100 38 74 1 1910366128 5795088 10601056
17:27:43 1918 8192000000 10838781056 11253854208 1906124480 18.876 100 64 128 0 1930787328 6401072 18261776
17:27:57 48136 8192000000 10844075424 11261763584 1909974912 18.906 100 40 80 0 1931330336 10690944 10664480
17:28:52 10363 8192000000 10862608272 11277746176 1920076416 18.987 100 53 107 0 1946745408 11397600 15271392
17:29:14 16757 8192000000 10860677264 11283673088 1928744704 19.057 100 56 110 2 1956766592 12096160 15925728
17:29:44 3527 8192000000 10869016432 11291717632 1935758816 19.113 100 61 123 1 1969795808 15445856 18591136
17:29:54 14865 8192000000 10874511040 11296452608 1942609232 19.168 100 63 127 1 1972697312 11994368 18093712
17:30:15 14290 8192000000 10878360336 11303084032 1944850752 19.185 100 59 118 0 1974411776 12585952 16975072
17:30:41 55158 8192000000 10870499296 11312537600 1949002032 19.219 100 51 98 0 1976206272 12926832 14277408
17:31:49 27107 8192000000 10880653600 11319422976 1953838048 19.257 100 36 72 2 1977162256 13111936 10212272
17:32:32 8393 8192000000 10894836048 11329425408 1959801216 19.304 100 30 60 1 1982833408 14207056 8825136
17:32:50 14180 8192000000 10915420896 11338616832 1969706896 19.383 100 47 92 0 2001331312 18506944 13117472
17:33:12 11843 8192000000 10919748912 11346808832 1975796896 19.431 100 54 108 1 2012316496 20453792 16065808
17:33:36 6787 8192000000 10919238592 11348516864 1976621824 19.438 100 55 110 2 2013989536 20973440 16394272
17:33:52 11130 8192000000 10918058752 11351044096 1976231696 19.435 100 46 89 2 2011086096 21172080 13682320
17:34:19 17148 8192000000 10910524976 11343245312 1958613312 19.295 99 48 96 1 1994689600 21502608 14573680
17:34:44 8190 8192000000 10920996464 11346796544 1972843872 19.408 100 52 102 0 2009316256 21171616 15300768
17:35:01 10456 8192000000 10920989568 11350200320 1971059760 19.394 100 59 118 0 2010972160 22415616 17496784
17:35:30 3935 8192000000 10921784672 11354095616 1977647296 19.446 100 51 100 3 2013348416 21095008 14606112
17:35:41 4060 8192000000 10920788800 11352350720 1978934016 19.456 100 49 98 1 2013543712 20306368 14303328
17:35:53 7643 8192000000 10932007312 11361947648 1985710032 19.510 100 61 122 1 2025372448 21115520 18546896
17:36:11 2562 8192000000 10944190768 11358056448 1983686592 19.494 100 66 132 1 2029533984 26222640 19624752
17:36:21 4956 8192000000 10931770000 11353702400 1966543648 19.358 99 74 148 2 2010892960 23374960 20974352
17:36:33 3215 8192000000 10936731904 11358273536 1983285840 19.491 100 79 158 2 2030475904 23466112 23723952
17:36:45 2212 8192000000 10961315344 11370749952 1995769104 19.589 100 88 176 3 2046795856 24887184 26139568
17:36:54 1664 8192000000 10951891456 11364425728 1986468832 19.516 100 91 180 0 2038755088 25604880 26681376
17:37:02 1893 8192000000 10952685696 11369070592 1989986400 19.544 100 79 159 0 2038328416 25320864 23021152
17:37:12 1353 8192000000 10962853280 11375529984 1997480176 19.603 100 79 158 3 2047402928 25959872 23962880
17:37:23 4554 8192000000 10953753168 11375611904 1996222176 19.593 100 72 145 2 2043346640 26632480 20491984
17:37:36 1356 8192000000 10971998288 11387465728 2001541104 19.635 100 78 155 0 2051267488 26512640 23213744
17:37:45 14307 8192000000 10959824832 11392552960 1999808480 19.621 100 60 120 0 2044483328 26468848 18206000
17:38:08 2241 8192000000 10969038192 11388338176 2005083040 19.663 100 82 161 2 2057781632 27749344 24949248
17:38:17 8760 8192000000 10935424736 11362041856 1980088288 19.465 99 57 114 0 2025533920 27315360 18130272
17:38:33 6092 8192000000 10960957904 11385466880 1998406704 19.610 100 72 144 2 2046947488 27295120 21245664
17:38:48 7591 8192000000 10951735584 11380781056 1993777136 19.574 100 52 102 1 2034867248 25676256 15413856
17:39:03 2695 8192000000 10953705456 11372605440 1973867696 19.416 99 79 156 1 2023138816 26928224 22342896
17:39:14 2757 8192000000 10954219680 11373780992 1972005408 19.401 99 74 149 0 2021554240 27555968 21992864
17:39:25 6457 8192000000 10946747920 11370582016 1971094352 19.394 99 71 142 1 2020657888 28469936 21093600
17:39:40 8144 8192000000 10954559184 11377790976 1987440528 19.524 100 68 135 0 2035638304 28246944 19950832
17:39:55 3991 8192000000 10946741104 11372371968 1989361632 19.539 100 63 124 0 2035759008 28024640 18372736
17:40:06 12561 8192000000 10942570864 11364306944 1967444320 19.365 99 58 116 1 2014673856 29230672 17998864
17:40:28 4320 8192000000 10944875408 11375697920 1985462480 19.508 100 55 106 1 2033996288 32320768 16213040
17:40:53 5813 8192000000 10962415888 11385208832 1991426432 19.555 100 68 135 0 2046139584 33560960 21152192
17:41:10 4682 8192000000 10892413872 11299450880 1921580160 18.999 97 71 141 1 1975285488 31257616 22447712
17:41:22 5324 8192000000 10908066944 11315900416 1918864176 18.978 98 65 128 0 1971845616 32923392 20058048
17:41:37 5292 8192000000 10932343808 11350695936 1963480272 19.334 100 69 138 4 2020248480 34810624 21957584
17:41:49 2806 8192000000 10932423952 11351896064 1946335568 19.197 99 67 134 2 2005873440 37409904 22127968
17:41:59 5174 8192000000 10918573600 11342778368 1951962032 19.242 100 57 113 3 2005152320 35135760 18054528
17:42:12 10901 8192000000 10915095888 11343450112 1937657264 19.128 99 57 114 2 1990697184 34494320 18545600
17:42:37 7979 8192000000 10921566816 11338715136 1945882720 19.194 99 66 132 2 2005219264 37947296 21389248
17:42:53 6900 8192000000 10943490112 11364593664 1963738656 19.336 100 62 125 0 2024213264 40072464 20402144
17:43:07 2547 8192000000 10954270032 11371810816 1962000432 19.322 99 69 138 1 2027139024 42729760 22408832
17:43:17 2985 8192000000 10962889216 11370184704 1957751696 19.288 99 85 171 2 2028286304 44141648 26392960
17:43:28 2359 8192000000 10974302640 11384066048 1981677216 19.478 100 89 179 0 2054142224 43919424 28545584
17:43:37 1395 8192000000 10976337952 11385581568 1982798272 19.487 100 93 184 1 2058276512 46473872 29004368
17:43:46 3472 8192000000 10956870112 11361251328 1958136544 19.291 99 92 183 0 2034583136 47686624 28759968
17:43:57 3088 8192000000 10963684320 11382681600 1973693536 19.415 100 75 150 0 2046207584 48108592 24405456
17:44:08 1945 8192000000 10955294240 11371122688 1960935360 19.313 99 81 161 2 2032460576 46695536 24829680
17:44:16 2383 8192000000 10964112512 11369541632 1972213664 19.403 100 91 179 0 2048058080 46635200 29209216
17:44:26 3432 8192000000 10969544144 11384819712 1975735248 19.431 100 83 166 0 2048801600 46236640 26829712
17:44:37 2294 8192000000 10975471984 11387797504 1965522816 19.350 99 87 174 0 2040180096 47365024 27292256
17:44:49 4946 8192000000 10960837664 11375759360 1973382544 19.412 100 75 150 2 2043064432 44947312 24734576
17:45:02 3470 8192000000 10959509072 11369328640 1970494384 19.389 100 79 154 2 2038002304 42260144 25247776
17:45:15 5489 8192000000 10953328000 11364216832 1962739840 19.328 100 85 168 0 2033755584 44563424 26452320
17:45:27 3073 8192000000 10936486288 11348328448 1951765824 19.241 100 83 165 0 2024427376 45896608 26764944
17:45:37 3839 8192000000 10932878736 11341336576 1941078304 19.155 100 80 160 1 2014109248 47192016 25838928
17:45:48 4142 8192000000 10952365504 11359252480 1952486624 19.246 100 86 173 1 2028731984 48735728 27509632
17:46:00 981 8192000000 10937295056 11340361728 1941221776 19.157 99 95 188 2 2020001488 49136096 29643616
17:46:08 3508 8192000000 10945832928 11352702976 1934800816 19.105 99 87 173 1 2009280864 47411744 27068304
17:46:17 3700 8192000000 10940490640 11356454912 1951516224 19.239 100 76 152 0 2023559360 48193600 23849536
17:46:34 3963 8192000000 10953514656 11364048896 1956974080 19.282 100 74 148 0 2028699168 48702784 23022304
17:46:45 1870 8192000000 10946188448 11354009600 1946898528 19.202 99 77 154 0 2021184720 48758240 25527952
17:46:54 3211 8192000000 10948251600 11369529344 1958797376 19.296 100 74 149 2 2033210208 50427088 23985744
17:47:07 5453 8192000000 10937897104 11366547456 1958869840 19.297 100 53 105 1 2026025936 48981376 18174720
17:47:20 8205 8192000000 10929119632 11352817664 1919922368 18.986 98 48 95 1 1985301120 48875008 16503744
17:47:38 6406 8192000000 10927959488 11365081088 1952502224 19.246 100 54 107 3 2019670416 48904912 18263280
17:47:57 3359 8192000000 10933373728 11359780864 1934954496 19.106 99 52 107 1 2003248528 50682000 17612032
17:48:07 7508 8192000000 10934568256 11370254336 1954542176 19.263 100 48 96 0 2020161280 49841248 15777856
17:48:21 15967 8192000000 10918571584 11353997312 1909874944 18.906 98 32 64 0 1974178800 52248240 12055616
17:49:51 32406 8192000000 10876960304 11337728000 1896297632 18.797 98 34 68 1 1950066640 41832304 11936704
17:50:37 25897 8192000000 10849187008 11308224512 1875268496 18.627 98 16 32 1 1913614000 32890336 5455168
17:51:50 59464 8192000000 10836117664 11302805504 1862172896 18.521 98 12 23 1 1899938736 33410800 4355040
17:53:00 32984 8192000000 10839218272 11294908416 1879733424 18.663 99 16 31 2 1909049424 23936160 5379840
17:53:43 17008 8192000000 10899200448 11319693312 1929734336 19.065 100 45 90 2 1956484272 12761328 13988608
17:54:09 24815 8192000000 10879167872 11327373312 1945978944 19.194 100 52 103 1 1972492608 10984928 15528736
17:54:56 84782 8192000000 10877696976 11326529536 1922401120 19.006 99 33 66 3 1945552592 13506752 9644720
17:56:31 31242 8192000000 10860463600 11324567552 1919613664 18.984 99 25 50 2 1945279936 18077136 7589136
17:57:13 25297 8192000000 10858357664 11298807808 1879511264 18.661 97 19 38 0 1899267984 14423488 5333232
17:57:45 44484 8192000000 10863824448 11325841408 1925136880 19.028 99 17 34 1 1938316896 8708224 4471792
17:58:41 78464 8192000000 10871321888 11331723264 1914736640 18.945 98 24 47 2 1931366416 9987504 6642272
18:00:08 110667 8192000000 10878360320 11347337216 1939273408 19.141 99 15 30 2 1952310688 9078144 3959136
18:02:55 60212 8192000000 10885283904 11358728192 1953484448 19.254 99 29 58 2 1979468144 17150656 8833040
18:04:01 80383 8192000000 10888145152 11341246464 1925934528 19.034 98 30 60 0 1952080032 17251680 8893824
18:05:33 120438 8192000000 10879763616 11357474816 1935229584 19.109 99 27 55 2 1965581296 22170768 8180944
18:07:45 48330 8192000000 10872069904 11349405696 1961224368 19.316 100 20 40 2 1975945936 8847504 5874064
18:08:45 81199 8192000000 10877140640 11348779008 1963443184 19.333 100 10 20 0 1972707056 6824592 2439280
18:10:17 62671 8192000000 10864856240 11341549568 1940140720 19.148 99 15 30 0 1951826608 7091440 4594448
18:11:27 79313 8192000000 10890954704 11363971072 1947142576 19.204 99 18 36 1 1971454288 19171536 5140176
18:12:53 32903 8192000000 10883251872 11354607616 1948934144 19.218 99 25 50 1 1971172464 15250080 6988240
18:13:39 45390 8192000000 10884576160 11363676160 1965036096 19.346 100 11 22 0 1980593456 12725744 2831616
18:14:31 43607 8192000000 10901222976 11381596160 1971042768 19.394 100 12 24 1 1992647328 18043856 3560704
18:15:24 55944 8192000000 10877779824 11347582976 1891587616 18.759 96 5 10 0 1908421568 15364864 1469088
18:16:27 41999 8192000000 10891598800 11367473152 1930622016 19.072 98 21 42 0 1951990528 14990928 6377584
18:17:43 62694 8192000000 10903270544 11367395328 1941361504 19.158 98 24 48 1 1967367488 18847552 7158432
18:19:16 43568 8192000000 10904461104 11377598464 1954061600 19.259 99 24 48 1 1984074048 22174192 7838256
18:20:39 64588 8192000000 10904152608 11388133376 1961771264 19.320 99 18 36 0 1996014640 28076320 6167056
18:21:55 71912 8192000000 10913241792 11400417280 1980388912 19.468 100 7 14 0 1999767824 17431200 1947712
18:23:15 88306 8192000000 10924676720 11394912256 1987122256 19.521 100 16 32 2 2006090720 14497840 4470624
18:24:52 46796 8192000000 10918641648 11379609600 1929580432 19.064 97 28 56 0 1951655456 14072880 8002144
18:25:47 52088 8192000000 10893269920 11366608896 1898032144 18.810 96 18 36 1 1920546768 17914432 4600192
18:26:45 116710 8192000000 10900428928 11369947136 1934345504 19.102 98 13 26 0 1960193168 22086416 3761248
18:29:19 48682 8192000000 10877709472 11343798272 1905226720 18.868 96 33 64 0 1920051872 5952704 8872448
18:30:15 75576 8192000000 10911331120 11370582016 1965034208 19.346 99 44 89 2 1986272688 9206016 12032464
18:31:37 37995 8192000000 10892226208 11359371264 1940373808 19.150 98 23 44 0 1956845536 10370560 6101168
18:32:33 46975 8192000000 10869831632 11354529792 1925092736 19.028 98 9 18 0 1938079296 10833968 2152592
18:34:39 46315 8192000000 10878296704 11356336128 1944874144 19.186 99 14 28 0 1962338224 13330832 4133248
18:35:35 54994 8192000000 10863175312 11338403840 1930284528 19.069 98 15 31 0 1945480400 11145536 4050336
18:36:36 71373 8192000000 10887564720 11352317952 1941552544 19.159 99 21 42 1 1955730128 7885392 6292192
18:38:00 28136 8192000000 10872421440 11344736256 1926421040 19.038 98 22 44 1 1946300992 12686240 7193712
18:38:34 28566 8192000000 10859905584 11344523264 1928811296 19.057 99 5 10 1 1940771120 10637424 1322400
18:39:21 41216 8192000000 10865868624 11347742720 1912240480 18.925 98 16 32 2 1937183536 20748208 4194848
18:40:23 71582 8192000000 10896775920 11343659008 1914721984 18.945 98 11 20 0 1930877920 13942080 2213856
18:41:45 58907 8192000000 10893143872 11354914816 1917444912 18.966 98 27 54 1 1937834720 13353248 7036560
18:43:00 24580 8192000000 10890460112 11346427904 1940508832 19.151 99 32 62 1 1957236656 7901952 8825872
18:43:40 33143 8192000000 10876405392 11344183296 1906988320 18.882 97 30 60 0 1925347120 9988608 8370192
18:44:32 115346 8192000000 10842605808 11307786240 1793537200 17.961 92 14 28 1 1810852816 13366176 3949440
18:46:42 94161 8192000000 10844780976 11319189504 1860004944 18.503 96 20 40 0 1880986720 15140960 5840816
18:48:23 49046 8192000000 10881042032 11326640128 1887710224 18.727 97 41 82 1 1908017408 9044592 11262592
18:49:18 13009 8192000000 10886615680 11331612672 1927436576 19.046 99 52 105 0 1953303696 11470304 14396816
18:49:42 17082 8192000000 10886865632 11335884800 1936512240 19.119 100 46 92 0 1962399424 13361232 12525952
18:50:12 74977 8192000000 10851023520 11327344640 1883988128 18.697 97 39 78 1 1912301344 17750368 10562848
18:51:40 76087 8192000000 10858458048 11334148096 1868708496 18.574 96 16 32 1 1882648800 9666112 4274192
18:53:06 87779 8192000000 10876269904 11329847296 1886510704 18.718 97 19 38 0 1901746224 10043264 5192256
18:54:40 103459 8192000000 10875044048 11343953920 1933078624 19.091 99 31 62 0 1952944832 10801888 9064320
18:56:37 89857 8192000000 10876787072 11356463104 1925894896 19.034 98 15 31 2 1947532400 17194896 4442608
18:58:34 66201 8192000000 10884600992 11366342656 1968483440 19.373 100 10 20 0 1983386144 11927376 2975328
19:00:01 21306 8192000000 10870896928 11349147648 1949490768 19.222 99 5 10 0 1961618800 10959136 1168896
19:00:43 43626 8192000000 10865070896 11347206144 1928919792 19.058 98 8 16 0 1942573472 11824000 1829680
19:01:45 50084 8192000000 10873792704 11343237120 1904177568 18.860 97 18 34 0 1916059136 7213872 4667696
19:03:06 34739 8192000000 10881142112 11344273408 1949596624 19.223 100 18 36 2 1959978624 5879120 4502880
19:03:47 27711 8192000000 10903424080 11362836480 1956696464 19.280 99 48 94 2 1978380496 8030816 13653216
19:04:29 53910 8192000000 10913593360 11381665792 1984893024 19.503 100 28 56 2 2004654848 11143152 8618672
19:05:36 39923 8192000000 10923506240 11389132800 1973001024 19.409 99 20 40 0 1989539616 10701680 5836912
19:06:22 26400 8192000000 10918815424 11372052480 1962943744 19.329 99 36 71 3 1984938672 10868816 11126112
19:06:55 80694 8192000000 10894811616 11370434560 1922022944 19.003 97 20 39 1 1940941072 13128304 5789824
19:08:22 142924 8192000000 10891641744 11359875072 1878799632 18.655 95 10 20 0 1892893920 11744800 2349488
19:10:51 25312 8192000000 10910195104 11364659200 1930739936 19.073 98 32 64 1 1946866400 7472160 8654304
19:11:24 16057 8192000000 10930625728 11371311104 1983595152 19.493 100 66 132 0 2011750784 9507200 18648432
19:11:46 37050 8192000000 10926755648 11381624832 1958604448 19.295 99 43 86 1 1982949904 12696576 11648880
19:12:33 69665 8192000000 10904508544 11379134464 1937753952 19.129 98 27 54 1 1960209616 13717104 8738560
19:13:49 51940 8192000000 10885228864 11364184064 1928126032 19.052 98 11 22 1 1944893248 14113376 2653840
19:14:47 89649 8192000000 10881456016 11361796096 1908103648 18.891 97 8 16 2 1922050848 11496112 2451088
19:16:23 84271 8192000000 10884958896 11351343104 1958351072 19.293 100 17 34 0 1974014128 10838000 4825056
19:18:20 43829 8192000000 10853903712 11325104128 1905935408 18.874 97 36 72 1 1923767216 8011024 9820784
19:19:21 60751 8192000000 10861496656 11340218368 1948642688 19.216 100 6 12 0 1957395728 6804288 1948752
19:20:28 57373 8192000000 10841630976 11313549312 1896137808 18.795 97 13 26 1 1911509408 12350000 3021600
19:21:33 43305 8192000000 10858263856 11339689984 1925367088 19.030 99 19 39 2 1945140800 13997152 5776560
19:22:22 13278 8192000000 10854030624 11344429056 1937109776 19.124 100 5 10 1 1948090464 9467360 1513328
19:23:07 36570 8192000000 10866056000 11343466496 1926858000 19.042 99 26 51 1 1943715280 8707824 8149456
19:24:02 64010 8192000000 10871949200 11349946368 1915210864 18.948 98 9 18 0 1927335872 9673568 2451440
19:25:15 35809 8192000000 10859886096 11329904640 1897474496 18.806 97 29 58 2 1918078144 12458608 8145040
19:25:57 53726 8192000000 10862561728 11323981824 1886952304 18.721 97 21 42 1 1901610576 9071744 5586528
19:27:11 21138 8192000000 9232303216 9495302144 391516512 4.561 21 5 8 0 397171984 4361504 1293968

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-03-2021 19:28:47 to 22-03-2021 19:29:18.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2021 19:29:19 to 22-03-2021 19:29:21.

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          236371
MON$OLDEST_ACTIVE               236372
MON$OLDEST_SNAPSHOT             236372
MON$NEXT_TRANSACTION            236372
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                       2004736
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:131: 
:132: mscs-test-161.budzdorov.ru    Mon Mar 22 19:27:36 2021
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
:135: 
:136: mscs-test-161.budzdorov.ru    Mon Mar 22 19:27:43 2021
:137:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:138: 
--- end of diff output ---

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

22.03.21 19:29:22. 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
2021-03-22 19:29:24 No severe PSQL-related problems occured
22.03.21 19:29:25. End of report.