Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.11.2020 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 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 17413756 kB
MemAvailable 31459100 kB
Buffers 0 kB
Cached 14309100 kB
SwapCached 3484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-14 19:27:01
DTS_END                         2020-11-14 19:27:01.5070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51304
TRN_ID                          241066
ATT_ID                          667
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: 9045.33 23431 1085439
customer order: creation 174.73 375 20968
customer order: refuse 14.73 361 1767
order to supplier: creation 46.98 1347 5638
order to supplier: removal 3.27 96877 392
invoice (draft): creation 47.02 3622 5642
invoice (draft): removal 51.96 716 6235
invoice accept: apply 41.75 18017 5010
invoice accept: cancel 47.15 736 5658
customer reserve: creation 3766.38 182 451965
customer reserve: removal 4556.53 55 546784
realization accept: apply 83.71 168 10045
realization accept: cancel 80.38 91 9646
payment from customer: creation 60.05 117 7206
payment from customer: removal 5.73 81 688
payment to supplier: creation 48.95 134 5874
payment to supplier: removal 3.65 75 438
service: total inventory turnovers 4.71 985 565
service: total monetary turnovers 6.78 25 814
service: aggregate perf. data 0.83 15981 100
service: refresh index statistics 0.03 328666 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-11-2020 19:28:46 to 14-11-2020 19:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6137
TEST_TIME 2 6114
TEST_TIME 3 6631
TEST_TIME 4 5846
TEST_TIME 5 5936
TEST_TIME 6 5714
TEST_TIME 7 5577
TEST_TIME 8 6156
TEST_TIME 9 6139
TEST_TIME 10 6218
TEST_TIME 11 6602
TEST_TIME 12 6762
TEST_TIME 13 7215
TEST_TIME 14 7226
TEST_TIME 15 7627
TEST_TIME 16 7883
TEST_TIME 17 8149
TEST_TIME 18 8317
TEST_TIME 19 8913
TEST_TIME 20 9164
TEST_TIME 21 9871
TEST_TIME 22 10325
TEST_TIME 23 10530
TEST_TIME 24 10809
TEST_TIME 25 10778
TEST_TIME 26 10700
TEST_TIME 27 10835
TEST_TIME 28 10760
TEST_TIME 29 10538
TEST_TIME 30 10466
TEST_TIME 31 10411
TEST_TIME 32 10159
TEST_TIME 33 10071
TEST_TIME 34 9949
TEST_TIME 35 9937
TEST_TIME 36 9962
TEST_TIME 37 9793
TEST_TIME 38 9690
TEST_TIME 39 9654
TEST_TIME 40 9549
TEST_TIME 41 9511
TEST_TIME 42 9559
TEST_TIME 43 9392
TEST_TIME 44 9409
TEST_TIME 45 9434
TEST_TIME 46 9401
TEST_TIME 47 9353
TEST_TIME 48 9316
TEST_TIME 49 9217
TEST_TIME 50 9242
TEST_TIME 51 9385
TEST_TIME 52 9307
TEST_TIME 53 9307
TEST_TIME 54 9286
TEST_TIME 55 9307
TEST_TIME 56 9331
TEST_TIME 57 9384
TEST_TIME 58 9369
TEST_TIME 59 9480
TEST_TIME 60 9533
TEST_TIME 61 9611
TEST_TIME 62 9634
TEST_TIME 63 9522
TEST_TIME 64 9471
TEST_TIME 65 9372
TEST_TIME 66 9351
TEST_TIME 67 9295
TEST_TIME 68 9234
TEST_TIME 69 9314
TEST_TIME 70 9263
TEST_TIME 71 9195
TEST_TIME 72 9121
TEST_TIME 73 9066
TEST_TIME 74 9171
TEST_TIME 75 9129
TEST_TIME 76 9142
TEST_TIME 77 9133
TEST_TIME 78 9114
TEST_TIME 79 9075
TEST_TIME 80 9075
TEST_TIME 81 9141
TEST_TIME 82 9130
TEST_TIME 83 9116
TEST_TIME 84 9103
TEST_TIME 85 9205
TEST_TIME 86 9167
TEST_TIME 87 9277
TEST_TIME 88 9206
TEST_TIME 89 9224
TEST_TIME 90 9273
TEST_TIME 91 9300
TEST_TIME 92 9333
TEST_TIME 93 9324
TEST_TIME 94 9265
TEST_TIME 95 9211
TEST_TIME 96 9217
TEST_TIME 97 9173
TEST_TIME 98 9163
TEST_TIME 99 9117
TEST_TIME 100 9098
TEST_TIME 101 9091
TEST_TIME 102 9195
TEST_TIME 103 9143
TEST_TIME 104 9161
TEST_TIME 105 9140
TEST_TIME 106 9166
TEST_TIME 107 9154
TEST_TIME 108 9202
TEST_TIME 109 9187
TEST_TIME 110 9251
TEST_TIME 111 9265
TEST_TIME 112 9321
TEST_TIME 113 9267
TEST_TIME 114 9192
TEST_TIME 115 9163
TEST_TIME 116 9190
TEST_TIME 117 9149
TEST_TIME 118 9183
TEST_TIME 119 9126
TEST_TIME 120 9050

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-11-2020 19:28:49 to 14-11-2020 19:28:53.

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 1504152 1504152 0 0.00 0 19460 6 0 0
doc_list_biud 1504151 1504151 0 0.00 0 26861 25 0 0
sp_add_invoice_to_stock 5158 5010 148 2.86 32 163914 18018 0 148
sp_cancel_adding_invoice 5658 5658 0 0.00 5 63498 736 0 0
sp_cancel_client_order 1767 1767 0 0.00 4 9832 361 0 0
sp_cancel_customer_reserve 546784 546784 0 0.00 1 26864 55 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 2 7321 82 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 4634 76 0 0
sp_cancel_supplier_invoice 6247 6235 12 0.19 2 15257 716 0 12
sp_cancel_supplier_order 392 392 0 0.00 11 895506 96877 0 0
sp_cancel_write_off 9646 9646 0 0.00 1 7646 92 0 0
sp_client_order 20968 20968 0 0.00 3 19054 376 0 0
sp_customer_reserve 451965 451965 0 0.00 0 97878 183 0 0
sp_fill_shopping_cart 32247 32247 0 0.00 1 24536 42 0 0
sp_fill_shopping_cart_clo_res 451960 451960 0 0.00 0 11496 14 0 0
sp_get_clo_for_invoice 5000 5000 0 0.00 0 23340 336 0 0
sp_kill_cost_storno 16430 16430 0 0.00 0 7644 50 0 0
sp_kill_qstorno_ret_qs2qd 1109841 1109841 0 0.00 0 16753 30 0 0
sp_kill_qty_storno 585525 585525 0 0.00 0 26861 65 0 0
sp_lock_selected_doc 20837 20837 0 0.00 0 7275 4 0 0
sp_make_cost_storno 28123 28123 0 0.00 0 19457 48 0 0
sp_multiply_rows_for_pdistr 28123 28123 0 0.00 0 7066 28 0 0
sp_multiply_rows_for_qdistr 20968 20968 0 0.00 0 11114 154 0 0
sp_pay_from_customer 7206 7206 0 0.00 4 13706 118 0 0
sp_pay_to_supplier 5874 5874 0 0.00 5 19465 134 0 0
sp_payment_common 13080 13080 0 0.00 2 13699 26 0 0
sp_qd_handle_on_cancel_clo 1767 1767 0 0.00 0 9824 329 0 0
sp_qd_handle_on_invoice_upd_sts 10656 10656 0 0.00 0 17815 312 0 0
sp_qd_handle_on_reserve_upd_sts 10045 10045 0 0.00 0 11717 50 0 0
sp_reserve_write_off 10045 10045 0 0.00 6 14246 169 0 0
sp_supplier_invoice 5642 5642 0 0.00 5 88951 3622 0 0
sp_supplier_order 5638 5638 0 0.00 5 56409 1348 0 0
srv_aggregate_perf_data 100 100 0 0.00 2144 150380 15981 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1016 155766 32585 0 0
srv_find_qd_qs_mism 1037738 1037738 0 0.00 0 16773 5 0 0
srv_make_invnt_saldo 565 565 0 0.00 28 87466 985 0 0
srv_make_money_saldo 814 814 0 0.00 0 1194 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 164744 507691 328666 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 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 5010 5010 0 0.00 0 17638 165 0 0
t$perf-norm:sp_cancel_adding_invoice 452 452 0 0.00 0 4311 79 0 0
t$perf-norm:sp_cancel_client_order 1767 1767 0 0.00 0 3923 20 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 4179 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 1596 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 1974 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 2171 19 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 26055 1595 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 4710 20 0 0
t$perf-norm:sp_client_order 20968 20968 0 0.00 0 6322 18 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 5422 12 0 0
t$perf-norm:sp_pay_from_customer 7206 7206 0 0.00 0 9738 15 0 0
t$perf-norm:sp_pay_to_supplier 5874 5874 0 0.00 0 9842 17 0 0
t$perf-norm:sp_reserve_write_off 10045 10045 0 0.00 0 9835 13 0 0
t$perf-norm:sp_supplier_invoice 5642 5642 0 0.00 0 8779 22 0 0
t$perf-norm:sp_supplier_order 5638 5638 0 0.00 0 3883 14 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 209 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 357 3 0 0
t$perf-norm:srv_make_invnt_saldo 565 565 0 0.00 0 4009 29 0 0
t$perf-norm:srv_make_money_saldo 814 814 0 0.00 0 3508 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 5 0 0
v_add_invoice_to_stock 10292 9996 296 2.87 0 4014 20 0 296
v_all_customers 38160 38160 0 0.00 0 93 1 0 0
v_all_suppliers 30794 30794 0 0.00 0 19 1 0 0
v_all_wares 41936 41936 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 904 904 0 0.00 0 993 8 0 0
v_cancel_client_order 3534 3534 0 0.00 0 4218 7 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 1244 5 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 4229 7 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 1858 6 0 0
v_cancel_supplier_invoice 830 806 24 2.89 0 2797 19 0 24
v_cancel_supplier_order 784 784 0 0.00 0 2802 7 0 0
v_cancel_write_off 1938 1938 0 0.00 0 3630 17 0 0
v_max_id_clo_ord 5638 5638 0 0.00 0 1163 1 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 1116 8 0 0
v_max_id_ord_sup 5641 5641 0 0.00 0 4637 6 0 0
v_max_non_paid_invoice 1756 1756 0 0.00 0 253 2 0 0
v_max_non_paid_realizn 3907 3907 0 0.00 0 1961 5 0 0
v_min_id_clo_ord 5638 5638 0 0.00 0 2889 7 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 8695 19 0 0
v_min_id_ord_sup 5641 5641 0 0.00 0 8825 7 0 0
v_min_non_paid_invoice 5874 5874 0 0.00 0 7396 14 0 0
v_min_non_paid_realizn 7206 7206 0 0.00 0 13692 15 0 0
v_our_firm 10374 10374 0 0.00 0 21 1 0 0
v_reserve_write_off 20090 20090 0 0.00 0 3990 7 0 0
x_lock_depdocs_on_canc_invoice 11490 11490 0 0.00 0 11913 111 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 6295 381 0 0
x_make_qstorno_1000_1200 5638 5638 0 0.00 1 56386 1266 0 0
x_make_qstorno_1200_2000 5642 5642 0 0.00 3 88938 3472 0 0
x_make_qstorno_2100_3300 451965 451965 0 0.00 0 97877 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2020 19:28:54 to 14-11-2020 19:28:58.

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:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 12463 8192000000 10199847536 10511949824 948775968 10.379 76 52 105 0 968638304 2460896 17401440
16:57:32 32160 8192000000 10352119472 10671321088 1387522752 14.484 100 86 172 0 1420464528 4669968 28271808
16:58:16 16345 8192000000 10377235248 10701893632 1432184048 14.881 100 80 160 0 1464565360 6749136 25632176
16:58:40 25775 8192000000 10404982992 10732474368 1457979248 15.108 100 90 180 0 1494320064 7523824 28816992
16:59:20 22293 8192000000 10445788112 10776154112 1487579728 15.368 100 88 176 1 1524447088 8303280 28564080
16:59:56 19869 8192000000 10462524800 10799300608 1514233600 15.600 100 85 170 0 1550407536 9263840 26910096
17:00:31 16751 8192000000 10483963680 10823991296 1532168016 15.756 100 82 164 0 1567860560 9728160 25964384
17:01:00 21916 8192000000 10521487200 10864689152 1561997664 16.013 100 86 172 1 1599629536 10787968 26843904
17:01:32 18772 8192000000 10541945392 10892083200 1586628864 16.225 100 87 174 0 1623961936 11141216 26191856
17:02:05 16988 8192000000 10546883040 10904698880 1609328800 16.419 100 81 162 1 1645787776 11875584 24583392
17:02:32 10401 8192000000 10563256992 10924949504 1625880064 16.560 100 76 150 1 1659057680 11305824 21871792
17:02:52 12441 8192000000 10593791200 10955440128 1651675552 16.779 100 79 158 1 1686316816 11519888 23121376
17:03:12 10814 8192000000 10604000496 10971004928 1671270720 16.944 100 87 174 0 1709928512 12919408 25738384
17:03:34 10034 8192000000 10623244224 10991951872 1686812992 17.075 100 74 148 1 1720424944 12287504 21324448
17:03:51 8743 8192000000 10638131376 11006763008 1696702400 17.157 100 80 160 0 1732283200 12440240 23140560
17:04:09 8906 8192000000 10653989280 11029360640 1713106128 17.295 100 82 163 0 1749405680 13069104 23230448
17:04:25 7229 8192000000 10666786912 11039203328 1725800544 17.401 100 81 162 1 1762626320 13879744 22946032
17:04:41 8937 8192000000 10672897312 11048296448 1736458144 17.489 100 80 160 0 1772984576 13886752 22639680
17:04:58 7145 8192000000 10680084112 11056693248 1743867104 17.551 100 80 160 1 1779742768 13216192 22659472
17:05:12 4425 8192000000 10688785536 11066077184 1749952736 17.601 100 75 147 2 1784021216 13188864 20879616
17:05:23 4235 8192000000 10706132272 11084591104 1765502544 17.730 100 79 158 0 1799658784 11996144 22160096
17:05:36 3448 8192000000 10710123600 11089813504 1772932256 17.791 100 72 144 0 1805628704 12925552 19770896
17:05:47 3065 8192000000 10729321312 11105591296 1786021120 17.899 100 83 163 0 1821180336 12731280 22427936
17:05:56 3780 8192000000 10738549200 11121889280 1795733056 17.979 100 85 171 0 1833377968 13529088 24115824
17:06:07 6860 8192000000 10735294944 11119321088 1800203088 18.016 100 82 164 0 1837255552 14489024 22563440
17:06:22 3974 8192000000 10755935184 11136446464 1806248912 18.065 100 88 175 2 1845113648 14623152 24241584
17:06:33 2643 8192000000 10764429184 11144208384 1819926672 18.177 100 91 182 1 1859518576 14223312 25368592
17:06:42 2527 8192000000 10777108000 11156893696 1829792080 18.258 100 93 186 2 1870372448 14874208 25706160
17:06:51 2433 8192000000 10781241264 11165040640 1834601088 18.297 100 92 184 3 1875245856 15474688 25170080
17:07:00 3429 8192000000 10779698720 11165720576 1838608240 18.329 100 91 182 2 1878445792 14230912 25606640
17:07:10 2402 8192000000 10788976016 11173433344 1842439168 18.361 100 89 178 1 1881524000 13602272 25482560
17:07:19 1693 8192000000 10796797824 11183726592 1849609360 18.419 100 90 177 2 1886535968 11447536 25479072
17:07:27 2520 8192000000 10794374064 11181875200 1852799424 18.445 100 87 174 3 1889048736 11802304 24447008
17:07:36 1170 8192000000 10798486656 11182809088 1855159952 18.464 100 94 189 0 1894782896 13653568 25969376
17:07:44 1136 8192000000 10805099712 11188404224 1858540368 18.491 100 92 182 0 1898643008 14294752 25807888
17:07:51 1870 8192000000 10799031904 11187302400 1859195152 18.497 100 92 185 1 1900224624 14216784 26812688
17:08:00 1281 8192000000 10807265584 11196907520 1865202720 18.545 100 92 185 2 1905386736 13641904 26542112
17:08:07 2730 8192000000 10812290240 11197947904 1870938128 18.592 100 94 188 0 1910514704 12444656 27131920
17:08:16 7992 8192000000 10817441504 11204788224 1869132192 18.577 100 97 194 1 1910251536 12979968 28139376
17:08:31 1149 8192000000 10815512528 11203694592 1873807232 18.615 100 93 189 1 1912685776 12535728 26342816
17:08:38 1590 8192000000 10806047136 11204222976 1866954160 18.560 100 64 128 0 1897063536 12209440 17899936
17:08:46 2594 8192000000 10802965168 11205660672 1868285888 18.570 100 58 115 2 1893557584 9567440 15704256
17:08:55 1780 8192000000 10804781760 11208105984 1881629904 18.678 100 66 132 0 1914946208 14499440 18816864
17:09:03 2885 8192000000 10793041152 11205849088 1873505136 18.613 100 56 108 0 1899436320 10984544 14946640
17:09:14 3433 8192000000 10796411872 11206692864 1874487312 18.621 100 56 112 1 1900367008 9282976 16596720
17:09:24 5284 8192000000 10780718000 11206348800 1872428096 18.604 100 37 74 2 1891366528 8865440 10072992
17:09:38 4866 8192000000 10798473168 11208298496 1875478368 18.629 100 40 78 2 1892832048 6420592 10933088
17:09:50 6888 8192000000 10798263104 11216732160 1878433504 18.652 100 33 67 1 1900039152 12114800 9490848
17:10:03 5009 8192000000 10800595952 11213660160 1876893072 18.640 100 39 81 4 1893574368 5371872 11309424
17:10:14 3925 8192000000 10802533200 11216027648 1880230976 18.667 100 39 77 3 1898704288 7192592 11280720
17:10:28 10147 8192000000 10788997344 11222118400 1877811120 18.647 100 19 37 0 1893563344 10882256 4869968
17:10:44 14801 8192000000 10789494160 11219001344 1885496400 18.709 100 35 67 1 1901606512 5918672 10191440
17:11:05 59639 8192000000 10798111664 11231027200 1886539856 18.718 100 31 63 5 1900929488 5461696 8927936
17:12:11 22074 8192000000 10807394064 11240222720 1894903440 18.785 100 24 48 1 1907913264 6316128 6693696
17:12:40 7507 8192000000 10809122704 11238715392 1893283536 18.772 100 18 36 2 1904326400 5739344 5303520
17:12:55 5032 8192000000 10823510544 11250814976 1901218656 18.836 100 40 78 2 1918860912 6818480 10823776
17:13:06 4750 8192000000 10822890704 11252760576 1902892432 18.850 100 32 64 0 1919800640 8115760 8792448
17:13:18 5234 8192000000 10822975248 11253395456 1903142176 18.852 100 33 66 2 1919977488 7687888 9147424
17:13:30 6020 8192000000 10814534992 11249520640 1902111760 18.843 100 28 56 2 1917297696 6825792 8360144
17:13:43 7370 8192000000 10822906752 11253547008 1906228144 18.876 100 19 37 0 1916610688 5849808 4532736
17:13:59 10705 8192000000 10818424912 11257503744 1906559904 18.879 100 21 42 1 1919143264 6370000 6213360
17:14:16 10485 8192000000 10820207424 11254841344 1907565360 18.887 100 21 42 0 1919212112 5899104 5747648
17:14:32 12747 8192000000 10824138560 11257790464 1908102000 18.891 100 24 48 3 1919950800 5169664 6679136
17:14:53 8937 8192000000 10809616272 11251286016 1889879776 18.745 99 23 46 1 1902142624 5616896 6645952
17:15:08 19509 8192000000 10809754896 11245015040 1881512496 18.677 99 7 14 1 1888743408 5309072 1921840
17:15:35 21759 8192000000 10819620864 11255603200 1907162352 18.884 100 32 64 3 1923638464 6726624 9749488
17:16:20 33722 8192000000 10824176848 11256864768 1892154544 18.763 99 44 87 6 1912557728 7505744 12897440
17:17:01 7378 8192000000 10808559408 11246264320 1886822256 18.720 99 29 57 3 1900489808 5857296 7810256
17:17:18 9843 8192000000 10787190704 11217715200 1822322000 18.197 96 28 56 3 1837163888 6697904 8143984
17:17:35 7394 8192000000 10778064112 11201732608 1805992080 18.063 96 22 44 0 1818635824 6425568 6218176
17:17:51 6679 8192000000 10776047440 11198570496 1828752192 18.249 98 33 66 3 1844715088 6749616 9213280
17:18:05 7032 8192000000 10738993232 11154317312 1794484240 17.969 98 22 44 1 1806039472 5089184 6466048
17:18:22 7280 8192000000 10714862352 11129352192 1713244176 17.296 93 24 48 1 1725698016 5772912 6680928
17:18:36 4014 8192000000 10729055232 11145285632 1782411200 17.869 98 25 50 1 1794848768 5748592 6688976
17:18:46 4605 8192000000 10739313776 11145785344 1783857952 17.881 98 35 70 0 1799699232 5996752 9844528
17:19:01 6955 8192000000 10739170144 11154153472 1776644144 17.822 97 19 38 0 1787302864 5147472 5511248
17:19:14 5122 8192000000 10713657840 11139186688 1782748480 17.872 98 22 43 3 1795217472 6359648 6109344
17:19:26 8183 8192000000 10761845200 11172155392 1821288464 18.188 100 23 46 1 1833775520 5497504 6989552
17:19:42 7668 8192000000 10718233408 11141849088 1772709232 17.789 97 17 34 0 1782294160 5267728 4317200
17:19:57 10028 8192000000 10679528912 11095711744 1698450208 17.172 94 12 24 1 1706823360 5138704 3234448
17:20:18 5832 8192000000 10710382944 11122483200 1727794208 17.417 95 23 44 3 1738758336 5066608 5897520
17:20:37 11210 8192000000 10733747120 11141701632 1790364256 17.935 99 27 54 1 1802960832 5080976 7515600
17:20:55 15666 8192000000 10679834800 11095232512 1759545216 17.681 98 17 34 1 1769494176 5295664 4653296
17:21:41 33462 8192000000 10722873168 11146850304 1790552912 17.936 98 35 71 3 1806221120 5885408 9782800
17:22:22 15110 8192000000 10727717984 11137368064 1773715520 17.798 97 29 58 2 1787988624 5868800 8404304
17:22:45 5324 8192000000 10742884816 11160973312 1812167024 18.114 99 29 56 2 1826575440 5840496 8567920
17:22:56 4668 8192000000 10758164976 11171364864 1834784928 18.298 100 35 70 2 1851055504 6861840 9408736
17:23:09 6990 8192000000 10743947328 11169570816 1820035504 18.178 99 23 46 2 1832587808 5897744 6654560
17:23:25 6030 8192000000 10750815984 11175288832 1840547520 18.345 100 34 67 1 1861115984 10753952 9814512
17:23:39 7480 8192000000 10748967968 11179356160 1839747584 18.339 100 29 56 2 1855307840 7158448 8401808
17:23:53 9367 8192000000 10756084000 11177119744 1841031984 18.349 100 22 44 3 1852516272 5215520 6268768
17:24:11 6607 8192000000 10744561072 11176759296 1826620240 18.232 99 12 24 0 1835097760 4999248 3478272
17:24:23 7660 8192000000 10759256944 11187490816 1844826256 18.380 100 17 34 2 1858632368 9518608 4287504
17:24:37 7689 8192000000 10763964208 11191447552 1852869360 18.445 100 22 45 1 1864431008 5332512 6229136
17:24:53 10706 8192000000 10770888080 11196452864 1857484144 18.483 100 17 34 0 1867549024 4972656 5092224
17:25:14 12540 8192000000 10771553168 11201789952 1860925216 18.511 100 25 49 0 1873800528 5707712 7167600
17:25:32 9362 8192000000 10771790384 11202105344 1861433792 18.515 100 17 34 3 1871937264 5369792 5133680
17:25:55 38204 8192000000 10785207968 11217018880 1870536512 18.589 100 23 46 0 1882099520 5352032 6210976
17:27:08 25596 8192000000 10820898064 11241492480 1894383024 18.781 100 43 87 0 1917201232 10607296 12210912
17:27:49 3412 8192000000 10836690080 11248984064 1901846992 18.841 100 45 87 2 1924306448 9854080 12605376
17:28:00 9643 8192000000 10849583136 11264135168 1914957056 18.946 100 64 128 1 1945748000 10465056 20325888
17:28:17 17691 8192000000 10866527312 11282436096 1925137568 19.028 100 67 134 0 1956106096 12765520 18203008
17:28:45 13195 8192000000 10868867760 11285778432 1931486848 19.079 100 63 124 0 1962192160 13736368 16968944
17:29:07 8260 8192000000 10868021408 11291623424 1933212832 19.093 100 55 110 0 1962334640 13489440 15632368
17:29:24 16835 8192000000 10861022272 11292344320 1936445888 19.118 100 53 105 1 1963377984 11424720 15507376
17:29:49 21063 8192000000 10882993376 11305750528 1939876656 19.146 100 50 99 1 1967110784 12686128 14548000
17:30:21 27069 8192000000 10880335664 11316338688 1946835360 19.201 100 46 92 1 1976137712 15708128 13594224
17:31:02 59068 8192000000 10899745472 11332579328 1955980336 19.274 100 24 48 0 1977119008 14145664 6993008
17:32:12 19804 8192000000 10913783600 11345866752 1968193552 19.371 100 38 76 1 1998990992 18752048 12045392
17:32:40 12664 8192000000 10912882128 11349291008 1974544720 19.421 100 38 76 1 2004859248 19073472 11241056
17:33:04 9068 8192000000 10929405440 11358199808 1984084976 19.497 100 47 93 0 2018679760 20688592 13906192
17:33:21 3610 8192000000 10941598768 11363909632 1989123520 19.537 100 66 132 0 2029431872 21236032 19072320
17:33:32 4322 8192000000 10932062192 11365826560 1991232416 19.554 100 56 110 1 2030273680 22011104 17030160
17:33:44 21419 8192000000 10941134976 11370090496 1990242320 19.546 100 50 100 1 2027772544 22888256 14641968
17:34:16 10089 8192000000 10941258656 11372208128 1975957344 19.433 99 52 104 0 2022101248 30967824 15176080
17:34:36 5122 8192000000 10942886656 11370323968 1990607136 19.549 100 47 93 0 2031720080 27382688 13730256
17:34:48 11057 8192000000 10957532656 11380371456 1996693840 19.597 100 56 109 1 2039868640 27146928 16027872
17:35:06 9663 8192000000 10953748400 11387609088 2003989936 19.654 100 67 134 0 2053666960 29867776 19809248
17:35:24 2973 8192000000 10976795584 11397042176 2007084720 19.679 100 75 148 1 2057061424 27906112 22070592
17:35:35 7603 8192000000 10971619760 11394703360 2009624144 19.699 100 75 148 0 2058158960 27607440 20927376
17:35:50 3670 8192000000 10978150768 11400282112 2014330768 19.736 100 75 149 0 2066693648 30767600 21595280
17:36:01 7826 8192000000 10986419360 11405811712 2017501984 19.761 100 74 147 4 2070158608 31134496 21522128
17:36:18 6747 8192000000 10984918032 11413336064 2020358192 19.783 100 66 132 1 2070940688 31351984 19230512
17:36:34 3417 8192000000 10982841344 11412054016 2016977616 19.756 100 67 133 0 2067384320 31022752 19383952
17:36:44 3230 8192000000 10991147120 11416322048 2022633280 19.801 100 72 144 2 2075904288 31541152 21729856
17:36:56 12811 8192000000 10983684288 11413778432 2023473648 19.807 100 64 127 4 2074674272 32073504 19127120
17:37:16 5726 8192000000 10985724016 11413495808 2020277712 19.782 100 76 149 2 2075413232 32818848 22316672
17:37:29 11692 8192000000 10982962528 11414089728 2018921120 19.772 100 64 125 1 2071417216 33393488 19102608
17:37:48 5458 8192000000 10983302608 11412885504 2002006064 19.639 99 65 130 1 2056538864 34855872 19676928
17:38:05 5634 8192000000 10982671024 11414417408 2017781568 19.763 100 66 131 2 2074960432 37654864 19524000
17:38:20 3755 8192000000 10983325888 11410366464 2001080800 19.631 99 69 136 0 2060148976 37681296 21386880
17:38:33 3625 8192000000 10988314544 11418804224 2017073840 19.757 100 60 117 2 2074361552 37923904 19363808
17:38:45 12352 8192000000 11000233392 11428364288 2022511072 19.800 100 63 127 6 2081819776 39034640 20274064
17:39:07 3761 8192000000 10979188064 11416010752 2013175264 19.727 100 59 118 1 2070464288 38389264 18899760
17:39:21 3644 8192000000 10987451456 11415482368 1989709344 19.541 98 65 130 1 2050483280 39952464 20821472
17:39:32 13878 8192000000 10993092656 11433398272 2015782432 19.747 100 60 120 1 2079821552 44649520 19389600
17:39:56 3271 8192000000 10975959552 11412267008 1999749168 19.621 99 60 118 4 2060085072 41180832 19155072
17:40:09 3683 8192000000 10976902848 11410227200 2006586016 19.675 100 84 169 3 2072590048 38980416 27023616
17:40:22 10186 8192000000 10976759872 11412643840 2006391584 19.673 100 61 121 0 2068604192 43317584 18895024
17:40:40 9617 8192000000 10994172304 11422556160 2015018832 19.741 100 57 113 2 2073740080 39262304 19458944
17:40:59 4370 8192000000 10990391840 11418345472 2016330912 19.751 100 67 134 1 2077812768 39320608 22161248
17:41:14 3334 8192000000 11002526464 11424378880 2016295648 19.751 100 61 123 1 2075614672 39677616 19641408
17:41:25 5932 8192000000 10997549680 11427336192 2021509904 19.792 100 70 140 2 2083508560 40287088 21711568
17:41:38 2108 8192000000 10980168368 11395567616 1995109872 19.584 99 81 159 4 2062523840 41800576 25613392
17:41:47 1014 8192000000 10992741168 11406712832 2000886896 19.630 100 85 167 1 2070962592 43178720 26896976
17:41:57 2368 8192000000 11000020160 11419955200 2009460256 19.697 100 82 164 2 2080356624 45302352 25594016
17:42:07 1986 8192000000 10985358464 11403993088 1996230656 19.593 100 87 176 2 2068014464 45265008 26518800
17:42:16 1810 8192000000 10982412320 11404546048 2003050624 19.647 100 86 169 1 2067277568 37905760 26321184
17:42:25 6269 8192000000 10962359952 11383889920 1968285104 19.372 98 79 158 3 2030832224 38286480 24260640
17:42:38 3894 8192000000 10969128688 11386519552 1980636576 19.470 100 81 162 0 2045946688 40270944 25039168
17:42:50 1442 8192000000 10975253760 11393708032 1988133184 19.529 100 85 169 0 2059889472 46112528 25643760
17:42:58 5915 8192000000 10971346896 11394076672 1990766624 19.550 100 74 148 1 2056475744 43461824 22247296
17:43:13 7258 8192000000 10965024032 11393130496 1991144688 19.553 100 70 138 3 2054296800 42028992 21123120
17:43:28 5897 8192000000 10938878960 11354226688 1948131712 19.212 100 74 148 2 2014395712 43250160 23013840
17:43:45 1108 8192000000 10953035216 11367129088 1966662800 19.359 100 87 174 0 2038029888 44711184 26655904
17:43:55 7824 8192000000 10945623920 11373133824 1967263968 19.364 100 61 122 1 2030124928 43941840 18919120
17:44:12 7148 8192000000 10949090752 11381559296 1974016272 19.417 100 44 88 0 2025491840 37482704 13992864
17:44:28 13510 8192000000 10916291312 11355140096 1932373168 19.086 98 34 68 0 1979759616 36294608 11091840
17:44:49 4462 8192000000 10934486128 11357028352 1956983872 19.282 100 63 123 3 2014538672 37833776 19721024
17:45:00 6317 8192000000 10878567952 11313012736 1887448208 18.725 97 50 100 0 1942873456 39884112 15541136
17:45:14 9261 8192000000 10894244704 11329781760 1918376896 18.974 99 38 76 1 1971049792 40058960 12613936
17:45:32 19998 8192000000 10910168272 11341848576 1933911776 19.098 100 40 80 3 1984659632 37411392 13336464
17:46:02 1778 8192000000 10946951248 11358265344 1955626832 19.271 100 78 156 2 2021408960 41336608 24445520
17:46:10 12807 8192000000 10881728336 11321249792 1888696704 18.735 97 42 83 2 1944836064 42691936 13447424
17:46:42 6364 8192000000 10891647824 11329957888 1931305472 19.077 100 54 108 1 1987327488 38140768 17881248
17:46:59 8113 8192000000 10886341312 11315101696 1890717824 18.752 98 48 94 0 1944385296 38477072 15190400
17:47:13 9341 8192000000 10884098832 11320754176 1918860864 18.978 100 43 86 1 1974322432 41557904 13903664
17:47:32 12311 8192000000 10903087136 11336138752 1927801664 19.049 100 38 76 1 1983406880 43130192 12475024
17:47:56 19716 8192000000 10898480288 11349483520 1924143216 19.020 99 28 56 0 1972252832 38726064 9383552
17:48:30 22874 8192000000 10891860048 11342417920 1908687776 18.896 98 24 48 0 1952465040 35583712 8193552
17:49:04 30635 8192000000 10879418000 11325050880 1881793344 18.680 97 28 56 2 1922575616 30942624 9839648
17:49:40 28568 8192000000 10872638304 11334098944 1893808784 18.776 98 21 42 3 1927931216 27778704 6343728
17:50:18 33197 8192000000 10868638144 11318624256 1889258208 18.740 98 25 49 1 1924790768 27883168 7649392
17:50:57 16750 8192000000 10869050032 11313659904 1886136448 18.715 98 21 41 0 1922475040 29875104 6463488
17:51:20 24267 8192000000 10862292320 11315085312 1900282176 18.829 99 20 40 0 1929637856 23185136 6170544
17:52:40 15436 8192000000 10862689856 11315367936 1920381776 18.990 100 26 52 0 1949445664 21028640 8035248
17:53:12 19552 8192000000 10858146048 11292241920 1886731856 18.719 98 43 83 3 1916319328 17196336 12391136
17:53:44 3917 8192000000 10877347504 11301740544 1924225760 19.021 100 72 142 1 1957469584 11429536 21814288
17:53:54 14050 8192000000 10858036144 11311706112 1924616128 19.024 100 28 56 1 1947562000 14324144 8621728
17:54:21 24243 8192000000 10846083648 11312775168 1920542256 18.991 100 20 40 0 1940267200 13150608 6574336
17:55:09 93595 8192000000 10851126528 11298246656 1875580560 18.629 97 20 40 2 1892726464 11256384 5889520
17:56:52 25430 8192000000 10846719376 11305467904 1928442736 19.054 100 41 83 1 1947598192 7815936 11339520
17:57:24 82708 8192000000 10865858224 11324174336 1935401248 19.110 100 11 22 0 1947903744 9439232 3063264
17:59:13 63533 8192000000 10887738320 11335397376 1950374336 19.229 100 34 68 0 1971206928 11155552 9677040
18:00:24 6431 8192000000 10896218080 11336781824 1960546384 19.310 100 51 102 0 1986809136 12767184 13495568
18:00:37 47443 8192000000 10867929088 11320492032 1896593984 18.799 97 16 32 1 1908794256 8114480 4085792
18:01:30 57009 8192000000 10900245472 11346919424 1961240832 19.316 100 29 59 1 1980151616 10305120 8605664
18:02:36 57648 8192000000 10874006368 11329691648 1929570992 19.063 98 26 51 2 1945906320 8609184 7726144
18:03:40 36120 8192000000 10890870880 11346333696 1963973904 19.338 100 26 51 0 1979676576 8365296 7337376
18:04:22 24963 8192000000 10886301200 11346870272 1966685344 19.359 100 25 50 1 1982938384 8665600 7587440
18:05:39 2042 8192000000 10933715424 11370086400 1988727712 19.534 100 68 136 2 2017238320 8309776 20200832
18:05:52 11611 8192000000 10927993584 11372855296 1993356288 19.570 100 69 137 1 2023807440 10970848 19480304
18:06:14 35835 8192000000 10916192352 11376365568 1991288720 19.554 100 36 68 1 2015852656 14365600 10198336
18:07:13 28566 8192000000 10950086080 11382534144 1995858912 19.590 100 53 105 3 2024109168 12575296 15674960
18:08:02 26617 8192000000 10934340128 11394658304 2001960400 19.638 100 33 66 4 2030168032 17883664 10323968
18:08:44 155730 8192000000 10925311600 11391369216 1977547632 19.445 99 16 32 0 2002350208 19757232 5045344
18:11:27 107879 8192000000 10921776320 11395338240 1995754624 19.589 100 21 42 1 2019744736 17446144 6543968
18:13:21 43487 8192000000 10926597216 11386875904 1998916448 19.614 100 36 72 3 2017680176 8676112 10087616
18:14:20 24236 8192000000 10908991600 11386228736 1998593600 19.612 100 18 37 0 2011518016 7645424 5278992
18:14:54 41172 8192000000 10910447120 11393499136 1978587536 19.454 99 12 23 2 1989343984 7863248 2893200
18:15:42 56072 8192000000 10933688896 11394031616 1977773216 19.447 99 16 32 0 1994169584 11947440 4448928
18:16:48 63042 8192000000 10900266160 11375796224 1935286320 19.109 97 14 28 0 1955686160 16635504 3764336
18:18:47 49488 8192000000 10912931072 11360804864 1926575696 19.039 97 25 50 2 1943193504 9474560 7143248
18:19:44 19053 8192000000 10910106544 11366952960 1980359072 19.468 100 43 84 2 2000972048 8936576 11676400
18:20:10 19879 8192000000 10900345968 11357663232 1958413904 19.293 99 26 52 0 1974370320 8969328 6987088
18:20:42 58567 8192000000 10902474352 11364388864 1901594640 18.839 96 19 37 1 1916129120 9244672 5289808
18:21:47 60585 8192000000 10908597680 11367690240 1924265952 19.021 97 18 36 0 1943734240 14325472 5142816
18:23:09 51833 8192000000 10913139728 11384934400 1978244336 19.451 100 12 24 1 2000800832 19160144 3396352
18:24:14 64210 8192000000 10889408496 11348840448 1904642752 18.864 96 18 36 1 1920407328 10166992 5597584
18:25:29 47534 8192000000 10871521760 11332214784 1880763376 18.671 96 24 48 2 1900447776 12858384 6826016
18:26:38 70051 8192000000 10848789744 11308896256 1814726080 18.135 94 5 10 0 1827079008 11243296 1109632
18:27:55 116397 8192000000 10853906016 11316350976 1832857936 18.283 94 20 40 0 1851333920 13335904 5140080
18:29:58 39732 8192000000 10841297360 11296362496 1854062608 18.455 96 23 44 1 1868698576 8706288 5929680
18:31:03 74939 8192000000 10851812704 11294937088 1887429520 18.725 98 34 65 2 1904429072 7614656 9384896
18:32:31 34065 8192000000 10863899760 11315478528 1933084208 19.092 100 27 54 1 1948016320 7801552 7130560
18:33:12 21628 8192000000 10863831920 11308572672 1900596528 18.831 98 23 44 1 1915638096 8345568 6696000
18:33:40 29233 8192000000 10849241696 11305050112 1898728720 18.816 98 21 42 0 1916204800 11367904 6108176
18:34:44 82272 8192000000 10824059440 11290058752 1847829040 18.404 96 5 10 1 1861679424 12318560 1531824
18:36:13 51427 8192000000 10818821600 11288379392 1853297344 18.449 97 5 11 0 1864540128 9943200 1299584
18:37:17 41609 8192000000 10830874736 11275534336 1875154736 18.626 98 23 46 0 1891625680 9190256 7280688
18:38:05 136235 8192000000 10827931504 11288911872 1847531616 18.402 96 33 67 2 1870446736 13497824 9417296
18:40:28 59731 8192000000 10828012688 11303727104 1873548864 18.613 98 28 56 1 1896396768 15055216 7792688
18:41:36 47435 8192000000 10843091376 11316396032 1908054464 18.891 100 7 14 0 1929238672 19115456 2068752
18:42:30 38099 8192000000 10829885264 11288002560 1883102928 18.690 98 17 34 0 1904996384 16605488 5287968
18:43:20 44713 8192000000 10823688208 11282051072 1880593104 18.670 98 11 22 0 1895025600 11060112 3372384
18:44:12 29302 8192000000 10830234416 11297939456 1891999680 18.762 99 17 34 0 1912352368 15570128 4782560
18:44:48 34256 8192000000 10814571568 11281494016 1876941440 18.640 98 18 36 1 1894004608 11748160 5315008
18:45:55 60902 8192000000 10818226832 11273428992 1889118544 18.739 99 53 106 0 1913518560 8821920 15578096
18:47:11 56958 8192000000 10812856240 11284463616 1866612464 18.557 98 13 26 0 1886028880 15830304 3586112
18:48:15 58687 8192000000 10840971072 11307593728 1902078736 18.843 100 8 16 0 1922825968 18347696 2399536
18:49:28 56704 8192000000 10836587872 11307671552 1898876272 18.817 99 8 16 0 1919754176 18932768 1945136
18:50:31 56123 8192000000 10857093648 11325747200 1906935712 18.882 99 17 34 2 1923514032 11948208 4630112
18:51:34 24304 8192000000 10882825664 11327819776 1943733392 19.177 100 42 83 1 1968501776 13660896 11107488
18:52:09 11208 8192000000 10889386544 11341484032 1946345904 19.197 100 51 102 1 1979791968 19690064 13756000
18:52:32 31137 8192000000 10866510960 11340267520 1936500112 19.119 100 20 40 2 1958402912 16231856 5670944
18:53:15 34902 8192000000 10878451168 11332440064 1928579968 19.056 99 28 56 2 1945358192 8655008 8123216
18:54:03 28562 8192000000 10868412496 11326988288 1920346144 18.990 99 30 60 1 1941228288 12321456 8560688
18:55:11 58910 8192000000 10901352448 11343458304 1951013280 19.235 100 51 102 0 1976916992 11339296 14564416
18:56:21 68256 8192000000 10886286720 11350843392 1933628544 19.096 99 39 79 1 1958563888 14135824 10799520
18:57:41 41043 8192000000 10896703648 11361316864 1962574016 19.326 100 20 40 0 1977272336 9291424 5406896
18:58:28 116041 8192000000 10890946640 11355230208 1930446096 19.070 98 7 15 1 1942100304 10107856 1546352
19:00:31 155265 8192000000 10902657600 11376144384 1943690576 19.176 98 19 38 0 1957312736 8575680 5046480
19:03:14 57349 8192000000 10896862352 11383230464 1974444256 19.421 100 4 8 0 1987952576 12762032 746288
19:04:24 24436 8192000000 10897640592 11383676928 1978650656 19.454 100 4 8 0 1990621904 11293264 677984
19:04:55 51934 8192000000 10901280272 11368419328 1922356176 19.006 97 14 28 1 1936449120 11004304 3088640
19:06:02 53656 8192000000 10917082848 11379052544 1945770816 19.193 98 27 53 1 1964122064 11199472 7151776
19:07:18 56407 8192000000 10889993168 11355877376 1955077584 19.267 99 19 38 1 1972251008 11701024 5472400
19:08:30 101379 8192000000 10891353744 11373719552 1941477216 19.159 98 14 29 1 1962788512 17047728 4263568
19:10:21 22769 8192000000 10925881616 11356794880 1922472672 19.007 97 45 89 1 1944272912 9334448 12465792
19:10:52 49118 8192000000 10893907952 11355799552 1932400880 19.086 98 30 59 2 1949559696 8376272 8782544
19:11:51 30457 8192000000 10890772512 11352231936 1949744928 19.224 99 24 48 0 1965060368 8141264 7174176
19:12:29 36133 8192000000 10905603488 11345076224 1916511904 18.959 97 40 79 0 1935682288 8013312 11157072
19:13:14 45116 8192000000 10867213264 11330338816 1868957392 18.576 95 28 56 0 1888447152 11367024 8122736
19:14:09 48322 8192000000 10872832144 11327102976 1867104080 18.561 96 21 42 1 1885403248 12307584 5991584
19:15:05 76310 8192000000 10857222160 11324043264 1873974000 18.616 97 17 34 2 1889174272 10294880 4905392
19:16:45 120366 8192000000 10894452976 11360448512 1927717040 19.049 99 15 30 3 1945975328 14513488 3744800
19:18:52 50536 8192000000 10861621632 11322806272 1838639184 18.330 94 14 28 2 1857841328 15203792 3998352
19:19:53 102583 8192000000 10853308128 11325521920 1899724656 18.824 99 9 18 1 1920039856 18015760 2299440
19:21:42 96761 8192000000 10824390736 11294707712 1788059520 17.916 92 26 51 1 1808997136 13150160 7787456
19:23:29 39725 8192000000 10847700672 11320889344 1912635616 18.928 100 12 24 1 1931956288 15557600 3763072
19:24:16 21763 8192000000 10865186448 11318460416 1925292944 19.029 100 25 49 1 1947162928 14725296 7144688
19:24:43 107642 8192000000 10847283072 11314139136 1878640624 18.654 97 13 26 0 1899323344 17081408 3601312
19:26:37 30769 8192000000 9399276240 9689903104 551382608 6.306 29 9 18 2 563972800 10311296 2278896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-11-2020 19:28:59 to 14-11-2020 19:29:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 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 14-11-2020 19:29:32 to 14-11-2020 19:29:34.

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          241065
MON$OLDEST_ACTIVE               241335
MON$OLDEST_SNAPSHOT             241335
MON$NEXT_TRANSACTION            241335
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                       2026720
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:79: 
:80: mscs-test-161.budzdorov.ru    Sat Nov 14 19:27:14 2020
:81:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:82: 
:83: 
:84: mscs-test-161.budzdorov.ru    Sat Nov 14 19:27:19 2020
:85:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:86: 
--- end of diff output ---

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

14.11.20 19:29:35. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-11-14 19:29:37 No severe PSQL-related problems occured
14.11.20 19:29:39. End of report.