Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.03.2021 16: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 17400544 kB
MemAvailable 31481224 kB
Buffers 0 kB
Cached 14251100 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-26 16:27:25
DTS_END                         2021-03-26 16:27:25.6100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33270
TRN_ID                          240651
ATT_ID                          662
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: 9145.32 25931 1097438
customer order: creation 170.70 367 20484
customer order: refuse 14.16 356 1699
order to supplier: creation 45.76 1305 5491
order to supplier: removal 3.33 110328 400
invoice (draft): creation 45.38 3483 5446
invoice (draft): removal 51.93 849 6232
invoice accept: apply 41.77 18106 5012
invoice accept: cancel 46.63 819 5596
customer reserve: creation 3825.08 179 459010
customer reserve: removal 4610.23 63 553228
realization accept: apply 83.26 171 9991
realization accept: cancel 78.76 118 9451
payment from customer: creation 58.68 117 7041
payment from customer: removal 5.53 63 664
payment to supplier: creation 48.12 135 5774
payment to supplier: removal 3.43 61 412
service: total inventory turnovers 4.50 1126 540
service: total monetary turnovers 7.18 20 861
service: aggregate perf. data 0.85 19636 102
service: refresh index statistics 0.03 361325 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 26-03-2021 16:28:27 to 26-03-2021 16:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4651
TEST_TIME 2 6249
TEST_TIME 3 4715
TEST_TIME 4 4711
TEST_TIME 5 5265
TEST_TIME 6 5035
TEST_TIME 7 4662
TEST_TIME 8 4706
TEST_TIME 9 5348
TEST_TIME 10 5280
TEST_TIME 11 5512
TEST_TIME 12 5523
TEST_TIME 13 5780
TEST_TIME 14 6313
TEST_TIME 15 6283
TEST_TIME 16 6365
TEST_TIME 17 6569
TEST_TIME 18 6756
TEST_TIME 19 6966
TEST_TIME 20 7024
TEST_TIME 21 7571
TEST_TIME 22 7559
TEST_TIME 23 7672
TEST_TIME 24 7925
TEST_TIME 25 8439
TEST_TIME 26 8387
TEST_TIME 27 8703
TEST_TIME 28 9582
TEST_TIME 29 10224
TEST_TIME 30 10165
TEST_TIME 31 10053
TEST_TIME 32 10019
TEST_TIME 33 9858
TEST_TIME 34 9632
TEST_TIME 35 9716
TEST_TIME 36 9769
TEST_TIME 37 9606
TEST_TIME 38 9526
TEST_TIME 39 9576
TEST_TIME 40 9549
TEST_TIME 41 9541
TEST_TIME 42 9544
TEST_TIME 43 9505
TEST_TIME 44 9436
TEST_TIME 45 9284
TEST_TIME 46 9441
TEST_TIME 47 9477
TEST_TIME 48 9556
TEST_TIME 49 9514
TEST_TIME 50 9454
TEST_TIME 51 9533
TEST_TIME 52 9560
TEST_TIME 53 9556
TEST_TIME 54 9595
TEST_TIME 55 9599
TEST_TIME 56 9537
TEST_TIME 57 9603
TEST_TIME 58 9626
TEST_TIME 59 9506
TEST_TIME 60 9487
TEST_TIME 61 9442
TEST_TIME 62 9355
TEST_TIME 63 9371
TEST_TIME 64 9298
TEST_TIME 65 9196
TEST_TIME 66 9108
TEST_TIME 67 9227
TEST_TIME 68 9192
TEST_TIME 69 9270
TEST_TIME 70 9266
TEST_TIME 71 9225
TEST_TIME 72 9363
TEST_TIME 73 9296
TEST_TIME 74 9325
TEST_TIME 75 9326
TEST_TIME 76 9291
TEST_TIME 77 9353
TEST_TIME 78 9401
TEST_TIME 79 9376
TEST_TIME 80 9294
TEST_TIME 81 9259
TEST_TIME 82 9309
TEST_TIME 83 9310
TEST_TIME 84 9282
TEST_TIME 85 9230
TEST_TIME 86 9216
TEST_TIME 87 9141
TEST_TIME 88 9140
TEST_TIME 89 9109
TEST_TIME 90 9082
TEST_TIME 91 9056
TEST_TIME 92 9131
TEST_TIME 93 9150
TEST_TIME 94 9195
TEST_TIME 95 9190
TEST_TIME 96 9209
TEST_TIME 97 9243
TEST_TIME 98 9281
TEST_TIME 99 9287
TEST_TIME 100 9327
TEST_TIME 101 9344
TEST_TIME 102 9354
TEST_TIME 103 9397
TEST_TIME 104 9424
TEST_TIME 105 9380
TEST_TIME 106 9351
TEST_TIME 107 9279
TEST_TIME 108 9247
TEST_TIME 109 9226
TEST_TIME 110 9174
TEST_TIME 111 9140
TEST_TIME 112 9175
TEST_TIME 113 9127
TEST_TIME 114 9128
TEST_TIME 115 9183
TEST_TIME 116 9174
TEST_TIME 117 9172
TEST_TIME 118 9150
TEST_TIME 119 9161
TEST_TIME 120 9146

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-03-2021 16:28:31 to 26-03-2021 16:28:34.

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 1523154 1523154 0 0.00 0 28474 6 0 0
doc_list_biud 1523153 1523153 0 0.00 0 39108 29 0 0
sp_add_invoice_to_stock 5098 5012 86 1.68 45 185393 18107 0 86
sp_cancel_adding_invoice 5596 5596 0 0.00 4 67198 820 0 0
sp_cancel_client_order 1699 1699 0 0.00 3 12910 356 0 0
sp_cancel_customer_reserve 553228 553228 0 0.00 1 39113 64 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 2 3824 63 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 1994 62 0 0
sp_cancel_supplier_invoice 6240 6232 8 0.12 2 39112 850 0 8
sp_cancel_supplier_order 400 400 0 0.00 8 1142306 110329 0 0
sp_cancel_write_off 9451 9451 0 0.00 1 16302 118 0 0
sp_client_order 20484 20484 0 0.00 4 28052 368 0 0
sp_customer_reserve 459010 459010 0 0.00 0 69558 180 0 0
sp_fill_shopping_cart 31414 31414 0 0.00 1 22426 39 0 0
sp_fill_shopping_cart_clo_res 459004 459004 0 0.00 0 14166 14 0 0
sp_get_clo_for_invoice 5006 5006 0 0.00 0 20328 302 0 0
sp_kill_cost_storno 16123 16123 0 0.00 0 6230 55 0 0
sp_kill_qstorno_ret_qs2qd 1122539 1122539 0 0.00 0 39085 35 0 0
sp_kill_qty_storno 591603 591603 0 0.00 0 39107 74 0 0
sp_lock_selected_doc 20708 20708 0 0.00 0 6074 4 0 0
sp_make_cost_storno 27812 27812 0 0.00 0 28464 54 0 0
sp_multiply_rows_for_pdistr 27812 27812 0 0.00 0 6411 29 0 0
sp_multiply_rows_for_qdistr 20484 20484 0 0.00 0 17172 174 0 0
sp_pay_from_customer 7041 7041 0 0.00 4 25665 118 0 0
sp_pay_to_supplier 5774 5774 0 0.00 4 24996 136 0 0
sp_payment_common 12814 12814 0 0.00 1 11812 26 0 0
sp_qd_handle_on_cancel_clo 1699 1699 0 0.00 0 12900 328 0 0
sp_qd_handle_on_invoice_upd_sts 10602 10602 0 0.00 0 35142 325 0 0
sp_qd_handle_on_reserve_upd_sts 9991 9991 0 0.00 0 23838 57 0 0
sp_reserve_write_off 9991 9991 0 0.00 6 23859 171 0 0
sp_supplier_invoice 5446 5446 0 0.00 6 103215 3483 0 0
sp_supplier_order 5491 5491 0 0.00 5 57826 1305 0 0
srv_aggregate_perf_data 102 102 0 0.00 2456 156986 19637 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1174 147539 32844 0 0
srv_find_qd_qs_mism 1050439 1050439 0 0.00 0 24222 6 0 0
srv_make_invnt_saldo 540 540 0 0.00 47 33955 1127 0 0
srv_make_money_saldo 861 861 0 0.00 1 919 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 119602 516509 361326 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5012 5012 0 0.00 0 12398 179 0 0
t$perf-norm:sp_cancel_adding_invoice 438 438 0 0.00 0 6246 105 0 0
t$perf-norm:sp_cancel_client_order 1699 1699 0 0.00 0 6963 15 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 6837 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 6856 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 487 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 1544 16 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 21620 1629 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 2199 10 0 0
t$perf-norm:sp_client_order 20484 20484 0 0.00 0 10337 22 0 0
t$perf-norm:sp_customer_reserve 1010 1010 0 0.00 0 3659 9 0 0
t$perf-norm:sp_pay_from_customer 7041 7041 0 0.00 0 6653 13 0 0
t$perf-norm:sp_pay_to_supplier 5774 5774 0 0.00 0 10244 11 0 0
t$perf-norm:sp_reserve_write_off 9991 9991 0 0.00 0 9091 13 0 0
t$perf-norm:sp_supplier_invoice 5446 5446 0 0.00 0 10288 21 0 0
t$perf-norm:sp_supplier_order 5491 5491 0 0.00 0 9227 17 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 84 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 1714 30 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 6257 36 0 0
t$perf-norm:srv_make_money_saldo 861 861 0 0.00 0 4503 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 10184 10012 172 1.68 0 6303 19 0 172
v_all_customers 37306 37306 0 0.00 0 127 1 0 0
v_all_suppliers 30030 30030 0 0.00 0 25 1 0 0
v_all_wares 40968 40968 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 876 876 0 0.00 0 5480 13 0 0
v_cancel_client_order 3398 3398 0 0.00 0 2808 4 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 1093 4 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 631 3 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 1941 7 0 0
v_cancel_supplier_invoice 820 804 16 1.95 0 1733 14 0 16
v_cancel_supplier_order 800 800 0 0.00 0 3156 10 0 0
v_cancel_write_off 1996 1996 0 0.00 0 3414 16 0 0
v_max_id_clo_ord 5491 5491 0 0.00 0 758 2 0 0
v_max_id_clo_res 1010 1010 0 0.00 0 2903 17 0 0
v_max_id_ord_sup 5438 5438 0 0.00 0 7398 9 0 0
v_max_non_paid_invoice 1688 1688 0 0.00 0 1203 3 0 0
v_max_non_paid_realizn 3777 3777 0 0.00 0 4517 4 0 0
v_min_id_clo_ord 5491 5491 0 0.00 0 7537 10 0 0
v_min_id_clo_res 1010 1010 0 0.00 0 7044 12 0 0
v_min_id_ord_sup 5438 5438 0 0.00 0 4821 7 0 0
v_min_non_paid_invoice 5774 5774 0 0.00 0 8474 14 0 0
v_min_non_paid_realizn 7040 7040 0 0.00 0 7610 17 0 0
v_our_firm 10188 10188 0 0.00 0 21 1 0 0
v_reserve_write_off 19982 19982 0 0.00 0 4783 6 0 0
x_lock_depdocs_on_canc_invoice 11426 11426 0 0.00 0 19016 132 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 23377 552 0 0
x_make_qstorno_1000_1200 5491 5491 0 0.00 2 57817 1221 0 0
x_make_qstorno_1200_2000 5446 5446 0 0.00 3 103168 3346 0 0
x_make_qstorno_2100_3300 459010 459010 0 0.00 0 65607 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2021 16:28:35 to 26-03-2021 16:28:39.

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
13:57:29 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:35 28217 8192000000 10294754544 10603991040 928971904 10.185 70 56 112 0 949230256 2556736 17701616
13:58:14 28388 8192000000 10354438928 10671083520 1397103184 14.569 100 89 178 0 1432436144 5716048 29616912
13:58:55 26714 8192000000 10375823664 10701594624 1430056928 14.862 100 90 179 2 1467018192 7165728 29795536
13:59:34 11717 8192000000 10404569584 10732494848 1457190720 15.101 100 91 182 0 1495510720 7968128 30351872
13:59:53 22944 8192000000 10424932064 10755457024 1476526320 15.271 100 91 182 1 1515673088 8971728 30175040
14:00:29 28832 8192000000 10439523872 10777083904 1493790096 15.422 100 85 170 0 1531216096 9931712 27494288
14:01:09 20017 8192000000 10459755104 10800955392 1515449472 15.611 100 80 160 0 1550998272 9708304 25840496
14:01:39 18184 8192000000 10496615456 10844807168 1540123616 15.825 100 70 141 0 1571702832 9887376 21691840
14:02:10 14180 8192000000 10530415072 10882490368 1585691920 16.217 100 84 168 0 1622960608 11552576 25716112
14:02:37 13706 8192000000 10534482128 10893557760 1597956336 16.322 100 82 164 0 1635635584 12588464 25090784
14:03:01 14733 8192000000 10560510016 10916151296 1619516096 16.506 100 79 158 1 1655174656 12385664 23272896
14:03:24 9496 8192000000 10575357728 10935312384 1624727744 16.550 100 80 160 1 1661339664 13225712 23386208
14:03:50 11963 8192000000 10590038912 10960207872 1656496640 16.819 100 75 149 3 1691360512 13131328 21732544
14:04:11 10137 8192000000 10605784192 10977132544 1673208400 16.960 100 74 148 0 1706432304 11789312 21434592
14:04:28 7405 8192000000 10622598672 10997923840 1690204224 17.103 100 79 157 1 1724638752 11826752 22607776
14:04:43 8935 8192000000 10637973424 11014471680 1703665136 17.216 100 68 136 2 1735533296 12388864 19479296
14:05:07 5027 8192000000 10655771296 11035471872 1726387200 17.405 100 72 142 2 1758442032 11475088 20579744
14:05:19 4721 8192000000 10666532368 11047747584 1736256416 17.488 100 66 132 2 1765463200 10489792 18716992
14:05:32 5247 8192000000 10681778064 11063881728 1749131280 17.594 100 68 136 0 1778908640 11231632 18545728
14:05:45 4401 8192000000 10699114608 11077877760 1765284160 17.728 100 80 160 0 1800379344 12287088 22808096
14:05:57 8395 8192000000 10707369312 11088101376 1769320704 17.761 100 78 154 0 1804003872 13228128 21455040
14:06:13 4550 8192000000 10721620704 11101298688 1784570448 17.887 100 87 173 1 1822932704 13992656 24369600
14:06:24 3844 8192000000 10732850784 11117318144 1798106224 17.998 100 85 172 1 1836270592 13037456 25126912
14:06:35 2683 8192000000 10744834576 11129176064 1805976224 18.063 100 84 169 1 1843063968 13095616 23992128
14:06:45 3040 8192000000 10749898752 11139375104 1810897568 18.103 100 85 168 0 1846994240 12227632 23869040
14:06:55 3048 8192000000 10763078720 11142619136 1817309040 18.156 100 86 169 3 1852484624 11448432 23727152
14:07:05 2094 8192000000 10755558720 11140288512 1816736160 18.151 100 72 143 1 1848760432 11948224 20076048
14:07:13 3518 8192000000 10776037968 11163394048 1828507552 18.247 100 88 177 0 1866970848 12612208 25851088
14:07:23 2089 8192000000 10778581296 11165278208 1836776448 18.315 100 77 154 0 1870855312 12102320 21976544
14:07:32 1696 8192000000 10788188352 11173236736 1843563648 18.370 100 90 178 3 1881560640 12987392 25009600
14:07:40 1664 8192000000 10789704128 11180732416 1847060352 18.398 100 83 164 1 1883080768 13466496 22553920
14:07:48 1889 8192000000 10796385456 11184865280 1853627424 18.452 100 93 186 0 1894192816 14624256 25941136
14:07:57 1817 8192000000 10798905280 11188666368 1855062256 18.463 100 90 180 1 1895195264 15540848 24592160
14:08:05 11936 8192000000 10800143744 11187478528 1859828880 18.502 100 77 154 3 1892017584 10129104 22059600
14:08:24 2996 8192000000 10808881472 11195363328 1863909024 18.535 100 85 172 2 1898279888 10520704 23850160
14:08:33 1304 8192000000 10804550160 11201761280 1865246544 18.546 100 75 150 0 1898822752 12495744 21080464
14:08:41 3443 8192000000 10799514272 11203362816 1865573120 18.548 100 59 115 1 1893703040 12392432 15737488
14:08:51 1969 8192000000 10800426448 11205226496 1872911456 18.608 100 71 142 0 1905431264 11801968 20717840
14:09:02 2642 8192000000 10790632864 11203940352 1868463696 18.572 100 58 116 2 1896455776 11605968 16386112
14:09:11 7855 8192000000 10773981120 11199344640 1864655968 18.541 100 28 57 0 1880510048 7946736 7907344
14:09:26 6132 8192000000 10772945488 11203416064 1869214704 18.578 100 30 60 2 1885283360 7622128 8446528
14:09:38 9805 8192000000 10804079344 11211583488 1869096240 18.577 100 24 48 1 1881627520 5746320 6784960
14:09:54 36394 8192000000 10801975728 11217960960 1877205440 18.643 100 29 57 3 1891804288 6347088 8251760
14:11:00 17583 8192000000 10803851104 11231408128 1883564544 18.694 100 28 55 2 1897470880 6843152 7063184
14:11:25 6701 8192000000 10816198240 11235917824 1884490976 18.701 100 26 50 4 1905738912 14471072 6776864
14:11:41 5266 8192000000 10798632928 11229753344 1884196720 18.699 100 20 40 0 1900304576 10771952 5335904
14:11:55 5083 8192000000 10802365376 11231604736 1890664000 18.751 100 29 58 0 1904689456 6091536 7933920
14:12:08 7304 8192000000 10803528448 11233755136 1890088448 18.746 100 33 65 1 1906317664 6786688 9442528
14:12:22 7078 8192000000 10803727696 11236339712 1891567456 18.758 100 27 54 2 1905648256 6265536 7815264
14:12:37 9218 8192000000 10803607792 11236872192 1892220080 18.764 100 24 47 1 1904034832 5402720 6412032
14:12:53 7208 8192000000 10800596800 11240345600 1892932960 18.769 100 18 36 1 1904490336 6578672 4978704
14:13:08 8286 8192000000 10807158672 11243237376 1896217104 18.796 100 28 56 1 1911606384 7758640 7630640
14:13:23 10809 8192000000 10811788048 11244363776 1896843536 18.801 100 17 34 5 1907258656 5477072 4938048
14:13:42 6017 8192000000 10799475904 11241705472 1898143440 18.811 100 24 47 3 1911055328 5975264 6936624
14:13:55 5027 8192000000 10824895712 11248115712 1900344272 18.829 100 36 72 4 1916858160 6994464 9519424
14:14:09 12342 8192000000 10810248240 11240701952 1899351168 18.821 100 18 36 1 1910741968 6060208 5330592
14:14:29 13776 8192000000 10811507312 11244048384 1898468784 18.814 100 16 32 0 1909417792 5728192 5220816
14:14:49 29379 8192000000 10811265344 11250524160 1905332240 18.869 100 37 75 0 1921997440 5908576 10756624
14:15:51 12162 8192000000 10849192560 11253956608 1908427840 18.894 100 65 130 1 1933417392 6003488 18986064
14:16:09 7580 8192000000 10817089440 11252424704 1903036784 18.851 100 33 64 1 1920407264 8662240 8708240
14:16:24 6051 8192000000 10798579648 11234484224 1865161728 18.545 98 20 39 1 1876867456 5150672 6555056
14:16:36 6266 8192000000 10812199216 11243220992 1877568304 18.645 99 28 57 1 1895561776 10643296 7350176
14:16:49 4887 8192000000 10796529136 11230138368 1871545120 18.597 99 27 55 2 1885172720 6379072 7248528
14:17:01 6461 8192000000 10789149312 11223937024 1855487136 18.467 98 28 56 4 1869426288 6034336 7904816
14:17:14 6311 8192000000 10783023264 11213369344 1859466128 18.499 99 24 46 2 1871832880 5411920 6954832
14:17:27 7715 8192000000 10777742992 11208855552 1838173120 18.326 98 16 32 0 1848179248 5037184 4968944
14:17:42 7029 8192000000 10774670368 11201683456 1860488160 18.507 99 37 76 3 1878261200 6721584 11051456
14:17:55 5788 8192000000 10758354752 11182682112 1772491008 17.788 95 15 29 1 1781824640 4854096 4479536
14:18:09 7392 8192000000 10734847552 11153846272 1780475824 17.853 96 20 40 4 1791787136 5401680 5909632
14:18:26 11679 8192000000 10744699952 11168219136 1730158960 17.437 93 16 32 0 1739632528 4830880 4642688
14:18:45 6646 8192000000 10692035536 11112202240 1700413792 17.189 93 15 30 0 1709718064 4987552 4316720
14:18:59 13527 8192000000 10713195648 11131392000 1741802960 17.534 96 9 18 0 1749395280 5027552 2564768
14:19:22 59411 8192000000 10707622336 11127914496 1705892928 17.234 94 39 78 2 1722408368 5068960 11446480
14:20:34 11273 8192000000 10663075904 11080216576 1686851776 17.075 94 20 40 2 1697756960 5601280 5303904
14:20:52 6929 8192000000 10703814864 11109138432 1735177984 17.479 97 39 77 1 1752789376 6936368 10675024
14:21:07 5535 8192000000 10712336256 11132456960 1786962544 17.907 99 33 64 0 1803409840 6804320 9642976
14:21:20 6181 8192000000 10678065872 11090366464 1751156400 17.611 98 28 56 2 1765341840 5903872 8281568
14:21:32 4621 8192000000 10704332384 11113795584 1760801040 17.691 98 49 98 2 1782955168 6788352 15365776
14:21:43 6882 8192000000 10719996240 11129413632 1769273536 17.761 98 32 64 1 1785286416 6118208 9894672
14:21:58 12074 8192000000 10699501536 11122049024 1778959776 17.841 99 37 74 2 1795547248 5481472 11106000
14:22:23 12177 8192000000 10706431472 11126259712 1784476752 17.886 99 19 36 1 1795661840 5669408 5515680
14:22:42 8850 8192000000 10736169056 11154595840 1783123280 17.875 98 29 58 4 1797065824 5946560 7995984
14:22:57 16482 8192000000 10726672064 11154071552 1790762928 17.938 98 18 36 2 1801895184 5618448 5513808
14:23:22 12430 8192000000 10759154896 11178225664 1835098848 18.301 100 15 30 1 1845451952 5748784 4604320
14:23:42 11961 8192000000 10758113200 11184656384 1844627792 18.378 100 9 18 0 1852391632 5464928 2298912
14:24:04 84856 8192000000 10759855088 11188678656 1850883760 18.429 100 25 51 0 1863632032 5040880 7707392
14:25:36 13125 8192000000 10787199520 11204325376 1858895104 18.494 100 20 40 1 1871258704 6122160 6241440
14:25:55 8896 8192000000 10771998832 11207172096 1864694464 18.541 100 21 42 0 1876827216 6153120 5979632
14:26:11 3857 8192000000 10790122592 11214798848 1870636320 18.589 100 35 70 2 1887274368 6836416 9801632
14:26:21 7312 8192000000 10789297744 11214905344 1874584192 18.621 100 37 74 1 1895991968 11178816 10228960
14:26:36 5658 8192000000 10779716432 11216863232 1870519728 18.588 100 19 38 2 1881845808 5612464 5713616
14:26:48 6625 8192000000 10778702336 11215892480 1871223888 18.594 100 13 26 1 1880037936 5339152 3474896
14:27:05 9529 8192000000 10802766144 11230859264 1885246256 18.707 100 13 26 2 1893927728 4645520 4035952
14:27:22 23071 8192000000 10830538000 11251015680 1904124784 18.859 100 38 75 3 1919686512 4935648 10626080
14:27:55 4664 8192000000 10847346528 11262197760 1914025616 18.939 100 50 99 0 1934093072 6835824 13231632
14:28:07 5619 8192000000 10853862640 11269632000 1919369360 18.982 100 55 110 0 1943743360 8518800 15855200
14:28:22 20627 8192000000 10862250912 11280146432 1922774224 19.009 100 54 108 1 1947985120 9949024 15261872
14:29:06 3568 8192000000 10865490528 11283103744 1930992320 19.075 100 61 118 4 1959162688 10486832 17683536
14:29:28 22901 8192000000 10857439248 11293503488 1935537888 19.111 100 52 104 1 1961262000 10693344 15030768
14:30:35 61511 8192000000 10865076144 11306295296 1942886720 19.170 100 31 62 2 1961083568 9184992 9011856
14:31:43 21119 8192000000 10879283392 11319324672 1952233776 19.244 100 39 78 0 1974016032 10653200 11129056
14:32:11 9641 8192000000 10886552128 11324596224 1958271712 19.292 100 40 76 2 1982021776 11423168 12326896
14:32:32 22456 8192000000 10893689024 11332984832 1964410672 19.341 100 34 66 2 1987498592 12916224 10171696
14:33:14 30264 8192000000 10907590768 11347984384 1976521536 19.437 100 38 74 4 1999927904 12322352 11084016
14:33:52 17675 8192000000 10901443552 11343097856 1965276448 19.348 99 36 72 0 1988918112 12595040 11046624
14:34:28 8174 8192000000 10917852848 11346538496 1978849184 19.456 100 56 113 0 2010523664 14785104 16889376
14:34:48 23848 8192000000 10929666080 11362979840 1987303520 19.522 100 53 106 1 2019204880 15659312 16242048
14:35:21 13877 8192000000 10930112960 11359760384 1971690560 19.399 99 50 100 0 2003800752 16978592 15131600
14:35:42 7535 8192000000 10924454096 11356110848 1969036176 19.378 99 55 110 1 2003317024 18055216 16225632
14:35:59 7514 8192000000 10924835472 11360026624 1982712736 19.486 100 49 98 1 2018572384 19597008 16262640
14:36:15 12147 8192000000 10917239040 11366776832 1985874096 19.511 100 45 90 1 2018443728 18717392 13852240
14:36:40 10057 8192000000 10934249632 11372138496 1977841600 19.448 99 52 104 2 2010447776 15621456 16984720
14:36:58 28038 8192000000 10944315312 11382558720 1993154224 19.569 100 48 96 1 2028163632 20096128 14913280
14:37:34 11563 8192000000 10948689456 11385159680 2000746736 19.629 100 49 95 2 2036577840 21442544 14388560
14:37:55 32941 8192000000 10926257408 11381567488 1994702224 19.581 100 45 89 1 2031505024 22381296 14421504
14:38:36 14597 8192000000 10927601696 11371589632 1990148960 19.545 100 36 72 1 2019116864 17927328 11040576
14:39:04 21728 8192000000 10921214400 11354271744 1973452752 19.413 99 48 96 1 2011624576 22494800 15677024
14:39:33 4165 8192000000 10941001920 11374620672 1992357664 19.562 100 50 98 0 2029828928 21352640 16118624
14:39:48 8217 8192000000 10951418784 11387854848 2004151216 19.655 100 55 110 1 2044523824 23319264 17053344
14:40:02 1753 8192000000 10958222304 11380342784 1969122304 19.378 98 67 134 1 2017414288 27363616 20928368
14:40:11 3855 8192000000 10969532112 11387813888 1977575552 19.445 99 73 146 2 2029377568 29605888 22196128
14:40:24 4340 8192000000 10940006688 11362680832 1937794288 19.129 97 71 142 1 1988834960 29896928 21143744
14:40:37 3919 8192000000 10961589744 11384627200 1991913072 19.559 100 72 144 0 2046767456 32493248 22361136
14:40:53 7068 8192000000 10971688160 11399884800 2002784720 19.645 100 76 152 1 2057632816 31718528 23129568
14:41:08 1814 8192000000 10981750688 11406651392 2011313024 19.712 100 87 174 2 2071101056 33761968 26026064
14:41:17 1852 8192000000 10964935888 11380101120 1987159136 19.521 99 85 168 1 2044058816 31523472 25376208
14:41:27 2611 8192000000 10956599376 11374063616 1968747904 19.376 99 85 166 1 2025367104 31112432 25506768
14:41:38 5372 8192000000 10924595728 11358195712 1962921024 19.329 99 66 130 3 2013941968 31201312 19819632
14:41:51 6578 8192000000 10927414656 11348455424 1949359760 19.221 99 68 134 0 1996670816 26605024 20706032
14:42:10 10456 8192000000 10946167264 11371347968 1974439968 19.421 100 62 123 1 2020761168 28550960 17770240
14:42:28 6311 8192000000 10966218864 11386806272 1994490304 19.579 100 84 166 3 2051878688 32287120 25101264
14:42:41 4714 8192000000 10967835568 11389399040 1997258736 19.601 100 75 147 0 2050873856 31067632 22547488
14:42:53 4784 8192000000 10959096784 11376488448 1977660592 19.446 99 81 162 1 2034131376 31119184 25351600
14:43:05 4540 8192000000 10963731040 11388334080 1996016208 19.591 100 79 158 1 2052723072 32839184 23867680
14:43:17 4375 8192000000 10966545616 11385671680 1992833840 19.566 100 86 169 2 2051492784 33361216 25297728
14:43:30 3021 8192000000 10959504064 11380862976 1971321488 19.396 99 75 150 2 2027986576 32962656 23702432
14:43:43 5846 8192000000 10961679552 11380436992 1972930464 19.409 99 76 151 3 2032978336 37515456 22532416
14:43:55 3266 8192000000 10948047136 11364917248 1958433536 19.294 99 74 146 0 2020091504 38680304 22977664
14:44:07 5665 8192000000 10948724080 11369951232 1971868976 19.400 100 74 148 0 2034045984 38301152 23875856
14:44:21 6512 8192000000 10944812592 11372306432 1976335184 19.436 100 68 134 2 2032423056 34577808 21510064
14:44:37 12473 8192000000 10941901952 11376599040 1961871168 19.321 99 50 100 0 2017348720 38638256 16839296
14:44:58 13585 8192000000 10931095360 11361300480 1961116016 19.315 99 45 90 0 2015080336 39008608 14955712
14:45:22 5298 8192000000 10945225296 11380817920 1975630224 19.430 100 51 100 3 2032897440 40804096 16463120
14:45:36 8576 8192000000 10934541104 11368824832 1967289376 19.364 100 52 104 4 2018988032 35697344 16001312
14:45:58 7944 8192000000 10938235840 11362795520 1963027408 19.330 100 62 124 2 2022243680 38870544 20345728
14:46:14 1850 8192000000 10920723200 11331829760 1928373232 19.054 98 79 157 2 1993527136 40503072 24650832
14:46:24 6543 8192000000 10920151152 11335684096 1931579712 19.080 100 76 152 3 1998121616 41509184 25032720
14:46:42 3334 8192000000 10932617712 11340722176 1945140048 19.188 100 89 173 1 2013925168 41823360 26961760
14:46:52 1172 8192000000 10943396816 11348754432 1952324832 19.245 100 90 179 2 2023369920 42169008 28876080
14:47:03 6189 8192000000 10954972096 11368022016 1968867664 19.376 100 85 170 0 2037647696 42955312 25824720
14:47:17 5193 8192000000 10964700688 11379507200 1978767712 19.455 100 86 172 2 2050626352 44255424 27603216
14:47:31 2013 8192000000 10982864928 11389960192 1981653504 19.478 100 92 184 1 2055637040 45102400 28881136
14:47:40 3712 8192000000 10977014960 11387604992 1983906336 19.496 100 93 185 2 2057108608 45116976 28085296
14:47:51 2975 8192000000 10976473776 11381583872 1974982736 19.425 100 89 177 2 2047133744 45280832 26870176
14:48:00 3352 8192000000 10967522784 11379163136 1975593472 19.430 100 87 172 2 2048502656 45549984 27359200
14:48:11 1951 8192000000 10980999120 11395076096 1986547200 19.517 100 91 181 1 2061941936 47340464 28054272
14:48:21 4961 8192000000 10954597776 11382824960 1980632176 19.470 100 64 128 0 2038314832 38153760 19528896
14:48:34 4478 8192000000 10951451504 11384086528 1984192240 19.498 100 60 120 0 2042471232 39152400 19126592
14:48:54 10287 8192000000 10943429600 11385794560 1980955296 19.472 100 40 80 0 2030432464 36228640 13248528
14:49:14 2643 8192000000 10948502656 11387555840 1984145664 19.498 100 42 84 0 2035605184 37705616 13753904
14:49:27 5637 8192000000 10957098640 11378585600 1976115024 19.434 100 68 135 2 2035260176 37207472 21937680
14:49:41 4679 8192000000 10950065088 11370741760 1966963840 19.361 100 65 128 1 2027293664 39928928 20400896
14:49:54 10260 8192000000 10930819040 11367223296 1964430512 19.341 100 48 96 3 2019968080 39438288 16099280
14:50:16 17676 8192000000 10928064912 11364220928 1939833808 19.145 99 38 76 2 1995567072 42022448 13710816
14:50:47 5135 8192000000 10924852784 11351355392 1906723712 18.880 97 45 90 1 1964808880 41876800 16208368
14:51:00 15975 8192000000 10907749984 11353616384 1929901680 19.066 99 38 76 3 1989209920 44888656 14419584
14:51:23 16785 8192000000 10909160576 11352322048 1929409600 19.062 99 33 66 2 1984218784 42650992 12158192
14:51:52 10455 8192000000 10923128960 11362066432 1949158912 19.220 100 40 80 1 2006830368 43174368 14497088
14:52:11 7088 8192000000 10920381040 11359281152 1951600368 19.239 100 55 111 0 2011370304 42373728 17396208
14:52:33 24252 8192000000 10893232704 11340152832 1923567568 19.015 99 30 59 0 1968136880 34173776 10395536
14:53:19 12691 8192000000 10886232288 11333165056 1913229392 18.933 99 23 46 1 1960450320 39355024 7865904
14:53:38 18198 8192000000 10887260640 11326152704 1906552032 18.879 99 22 44 1 1955252496 40876608 7823856
14:54:06 31554 8192000000 10867287600 11323961344 1886593344 18.718 99 23 46 0 1939953984 43873072 9487568
14:55:00 22676 8192000000 10888514048 11332050944 1898757024 18.816 99 24 49 1 1955554720 47995664 8802032
14:55:30 27910 8192000000 10858434608 11325194240 1879947264 18.665 98 18 36 0 1934492096 48228912 6315920
14:56:07 47528 8192000000 10839256560 11299299328 1891510960 18.758 99 9 19 0 1911362128 16777232 3073936
14:57:01 29508 8192000000 10859206976 11299700736 1908771168 18.897 99 23 45 0 1922572192 7477312 6323712
14:57:38 27440 8192000000 10866296448 11312615424 1928701776 19.056 100 16 32 1 1945021568 11905040 4414752
14:58:17 37992 8192000000 10901481776 11329257472 1949903344 19.226 100 38 74 0 1969594448 9178576 10512528
14:59:01 94877 8192000000 10889864592 11323854848 1870853440 18.591 95 34 68 0 1894455920 13270880 10331600
15:02:07 62671 8192000000 10882258352 11341127680 1944536096 19.183 100 32 64 1 1968775984 15144064 9095824
15:03:16 52812 8192000000 10877055616 11350040576 1949178176 19.220 100 11 22 0 1972588464 20646064 2764224
15:05:03 16831 8192000000 10892552944 11346014208 1949775440 19.225 99 31 62 2 1972696816 14066448 8854928
15:05:29 46168 8192000000 10895537360 11357233152 1932939712 19.090 98 23 46 2 1960664880 20115696 7609472
15:06:22 13200 8192000000 10906054864 11354988544 1966983888 19.362 100 18 36 1 1985848656 13396672 5468096
15:06:51 22385 8192000000 10916183216 11363074048 1982021072 19.481 100 52 104 0 2009243296 11094544 16127680
15:07:32 18896 8192000000 10905824320 11363868672 1977723968 19.447 100 44 89 0 2004954864 13942336 13288560
15:07:59 64341 8192000000 10913702576 11368615936 1976592048 19.438 100 19 36 1 1994714336 12484944 5637344
15:10:01 96408 8192000000 10902526160 11373195264 1977542464 19.445 100 14 28 0 1994967344 12952688 4472192
15:11:44 67462 8192000000 10904623152 11365986304 1959124016 19.299 99 14 29 0 1977337648 13831744 4381888
15:12:58 41640 8192000000 10879367600 11364503552 1932631152 19.088 98 5 10 1 1951960384 17803536 1525696
15:13:54 67828 8192000000 10909358032 11366735872 1971104336 19.394 100 17 34 0 1992857184 16847440 4905408
15:15:14 113535 8192000000 10922988080 11396677632 1986846960 19.519 100 12 24 0 2010185328 20081264 3257104
15:17:14 53139 8192000000 10930940064 11393122304 1978605568 19.454 99 17 34 0 1998372544 14728368 5038608
15:18:16 57586 8192000000 10892295040 11362328576 1923889136 19.018 97 7 14 1 1936863840 11398352 1576352
15:19:23 56381 8192000000 10887285328 11349057536 1903476192 18.854 96 23 46 0 1919237744 9183216 6578336
15:20:40 75816 8192000000 10888511968 11360714752 1896859584 18.801 96 21 42 1 1913220176 10441424 5919168
15:22:02 33261 8192000000 10878680816 11339046912 1910358640 18.910 97 19 38 1 1924736688 9266848 5111200
15:22:50 42078 8192000000 10879210784 11328978944 1878384656 18.652 96 28 56 4 1894345024 8864256 7096112
15:23:46 20475 8192000000 10911784816 11345022976 1956604576 19.279 100 52 104 2 1981747696 10112864 15030256
15:24:15 53357 8192000000 10907354304 11382075392 1950816896 19.233 99 39 78 0 1975463232 13748832 10897504
15:25:18 43188 8192000000 10914152432 11365539840 1938391088 19.134 98 10 20 0 1950823328 9955680 2476560
15:26:09 100185 8192000000 10913442512 11379580928 1968313888 19.372 99 39 78 0 1989779952 9876192 11589872
15:28:06 84285 8192000000 10900654432 11383263232 1961875104 19.321 99 12 24 1 1975725696 10832896 3017696
15:29:36 22467 8192000000 10878607744 11328339968 1892219856 18.764 96 20 40 1 1907164048 9178832 5765360
15:30:11 58967 8192000000 10853052240 11328217088 1905611856 18.871 97 17 34 1 1917252016 7384896 4255264
15:31:49 100309 8192000000 10894417568 11368599552 1959795744 19.304 99 20 37 1 1977185664 12072784 5317136
15:34:31 45101 8192000000 10866249328 11350298624 1906955712 18.882 97 11 23 0 1925370432 14901840 3512880
15:35:22 58259 8192000000 10882731984 11351564288 1914235920 18.941 98 15 30 1 1931309200 13099328 3973952
15:36:30 51614 8192000000 10895150272 11357904896 1937935392 19.130 99 17 34 2 1951498784 8693760 4869632
15:37:28 58144 8192000000 10901586592 11350560768 1883069600 18.690 95 24 48 0 1901020288 10443456 7507232
15:38:35 44967 8192000000 10867387824 11337199616 1878005440 18.649 96 30 60 0 1901302208 14565872 8730896
15:39:27 55880 8192000000 10883441072 11342172160 1915729008 18.953 99 13 26 4 1933712240 13939552 4043680
15:40:37 27658 8192000000 10888411024 11330371584 1891128560 18.755 97 39 79 0 1912176128 10737312 10310256
15:41:14 18445 8192000000 10891685296 11346227200 1944120592 19.180 100 44 88 1 1973315648 16527744 12667312
15:41:39 37460 8192000000 10872673872 11343564800 1923616176 19.016 99 24 48 1 1945403968 15353680 6434112
15:42:27 55587 8192000000 10861816320 11308773376 1826824240 18.233 94 36 70 1 1849571328 13062128 9684960
15:43:30 26327 8192000000 10832182768 11279577088 1850401856 18.425 97 36 72 0 1873542704 12794592 10346256
15:44:06 127891 8192000000 10851276384 11316768768 1875853312 18.632 98 19 37 1 1896099168 15271840 4974016
15:46:20 20385 8192000000 10878941328 11331473408 1916578352 18.959 99 22 45 2 1928506720 6350112 5578256
15:46:46 58327 8192000000 10869356048 11324432384 1903910864 18.858 98 31 62 2 1925079024 12351408 8816752
15:48:22 147538 8192000000 10863146912 11340894208 1885468960 18.709 97 22 42 2 1906675904 14612400 6594544
15:50:55 37062 8192000000 10868963120 11338416128 1944525568 19.183 100 23 46 2 1966715040 15052288 7137184
15:51:46 46113 8192000000 10870788160 11344420864 1953012576 19.250 100 15 29 0 1964909088 7747568 4148944
15:52:41 73758 8192000000 10865353296 11342409728 1900161184 18.828 97 9 18 2 1911362000 8240208 2960608
15:54:04 63099 8192000000 10875942880 11349979136 1956255120 19.276 100 15 30 1 1969310832 8662928 4392784
15:55:19 63949 8192000000 10868021856 11357474816 1953245312 19.252 100 7 14 0 1965929248 10078896 2605040
15:56:29 20399 8192000000 10857339152 11328126976 1901467056 18.838 97 18 35 2 1911933936 5410992 5055888
15:56:55 23900 8192000000 10875311232 11338866688 1942530160 19.167 100 23 46 1 1955272048 6507152 6234736
15:57:25 91160 8192000000 10902533072 11370258432 1947045904 19.203 99 19 38 0 1962314800 10015584 5253312
15:59:11 73063 8192000000 10900999040 11365691392 1951812208 19.241 99 23 46 1 1971759824 13340560 6607056
16:00:32 64085 8192000000 10884513792 11349696512 1932867984 19.090 98 19 38 0 1947002768 8718464 5416320
16:01:54 51832 8192000000 10895501584 11360436224 1919885328 18.986 97 18 35 0 1934166800 9501728 4779744
16:02:56 49151 8192000000 10918588672 11383296000 1978957680 19.456 100 25 50 0 1996469536 11040272 6471584
16:04:01 42726 8192000000 10908914032 11366813696 1920723168 18.993 97 13 26 0 1935189248 10467392 3998688
16:04:57 105006 8192000000 10920048560 11383644160 1936981248 19.123 98 8 16 1 1950032448 10959296 2091904
16:06:52 103087 8192000000 10887717024 11361980416 1901518176 18.839 96 14 28 1 1919434592 13994368 3922048
16:08:43 73305 8192000000 10927014048 11385163776 1956284800 19.276 99 27 52 1 1976895088 13723216 6887072
16:10:03 40097 8192000000 10911750432 11375878144 1941482640 19.159 98 35 70 0 1965611248 14657616 9470992
16:10:55 144121 8192000000 10880561184 11353292800 1877998784 18.649 95 16 32 1 1895887040 13289440 4598816
16:15:19 53477 8192000000 10895265488 11376472064 1947302688 19.205 98 16 32 0 1964042864 12412288 4327888
16:16:19 66733 8192000000 10904733296 11378540544 1964217216 19.340 99 12 24 0 1984497664 16574336 3706112
16:17:36 77915 8192000000 10915979776 11394093056 1968344736 19.372 99 18 36 1 1997604400 23444128 5815536
16:19:05 71906 8192000000 10912504208 11396710400 1965490688 19.350 99 14 28 0 1989580704 19749744 4340272
16:20:40 66422 8192000000 10918244496 11394101248 1990508560 19.548 100 21 42 0 2012601872 15863296 6230016
16:21:57 49738 8192000000 10919679728 11407163392 1986614240 19.517 100 14 28 0 2016385680 25615696 4155744
16:23:02 62836 8192000000 10900678304 11377532928 1936032640 19.115 97 9 18 0 1946555040 8026448 2495952
16:24:14 39165 8192000000 10893558176 11361427456 1905607248 18.871 96 16 32 0 1920151776 10527312 4017216
16:25:02 41762 8192000000 10871129248 11330715648 1878557376 18.653 96 17 34 2 1893107696 9895120 4655200
16:25:57 14313 8192000000 10881631920 11312193536 1881812128 18.680 97 60 120 2 1908461216 9150960 17498128
16:26:19 51048 8192000000 10868196320 11325952000 1898869056 18.817 98 40 80 2 1921631024 11674720 11087248
16:27:16 18507 8192000000 9431442128 9736818688 580528144 6.617 30 4 6 2 585493808 4075360 890304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-03-2021 16:28:41 to 26-03-2021 16:29:12.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2021 16:29:13 to 26-03-2021 16:29:15.

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          240902
MON$OLDEST_ACTIVE               240903
MON$OLDEST_SNAPSHOT             240903
MON$NEXT_TRANSACTION            240903
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                       2027104
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 ---
:313: 
:314: mscs-test-161.budzdorov.ru    Fri Mar 26 16:27:36 2021
:315:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:316: 
:317: 
:318: mscs-test-161.budzdorov.ru    Fri Mar 26 16:27:39 2021
:319:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:320: 
:321: 
:322: mscs-test-161.budzdorov.ru    Fri Mar 26 16:27:40 2021
:323:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:324: 
:325: 
:326: mscs-test-161.budzdorov.ru    Fri Mar 26 16:27:40 2021
:327:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:328: 
--- end of diff output ---

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

26.03.21 16:29:16. 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-26 16:29:18 No severe PSQL-related problems occured
26.03.21 16:29:20. End of report.