Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.03.2021 19:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17434200 kB
MemAvailable 31572996 kB
Buffers 0 kB
Cached 14260364 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-18 19:27:22
DTS_END                         2021-03-18 19:27:22.9420
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/53666
TRN_ID                          245631
ATT_ID                          646
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: 9249.76 19998 1109971
customer order: creation 179.58 347 21549
customer order: refuse 15.54 344 1865
order to supplier: creation 47.45 1282 5694
order to supplier: removal 3.46 87985 415
invoice (draft): creation 49.03 3383 5884
invoice (draft): removal 51.85 777 6222
invoice accept: apply 43.23 15284 5187
invoice accept: cancel 46.76 791 5611
customer reserve: creation 3899.45 155 467934
customer reserve: removal 4613.06 50 553567
realization accept: apply 87.25 168 10470
realization accept: cancel 78.31 100 9397
payment from customer: creation 61.53 112 7383
payment from customer: removal 5.79 72 695
payment to supplier: creation 51.14 113 6137
payment to supplier: removal 3.63 74 435
service: total inventory turnovers 4.85 1234 582
service: total monetary turnovers 6.95 22 834
service: aggregate perf. data 0.88 20232 106
service: refresh index statistics 0.03 267443 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-03-2021 19:29:04 to 18-03-2021 19:29:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3608
TEST_TIME 2 3873
TEST_TIME 3 3747
TEST_TIME 4 4084
TEST_TIME 5 4485
TEST_TIME 6 5083
TEST_TIME 7 5026
TEST_TIME 8 4943
TEST_TIME 9 4922
TEST_TIME 10 5348
TEST_TIME 11 5615
TEST_TIME 12 5688
TEST_TIME 13 6478
TEST_TIME 14 6780
TEST_TIME 15 7121
TEST_TIME 16 7310
TEST_TIME 17 7863
TEST_TIME 18 8127
TEST_TIME 19 8622
TEST_TIME 20 8906
TEST_TIME 21 9223
TEST_TIME 22 9823
TEST_TIME 23 9539
TEST_TIME 24 9556
TEST_TIME 25 9536
TEST_TIME 26 9660
TEST_TIME 27 9695
TEST_TIME 28 9603
TEST_TIME 29 9765
TEST_TIME 30 10039
TEST_TIME 31 10001
TEST_TIME 32 10048
TEST_TIME 33 10026
TEST_TIME 34 10056
TEST_TIME 35 10093
TEST_TIME 36 10047
TEST_TIME 37 10031
TEST_TIME 38 9871
TEST_TIME 39 9778
TEST_TIME 40 9541
TEST_TIME 41 9736
TEST_TIME 42 9797
TEST_TIME 43 9598
TEST_TIME 44 9540
TEST_TIME 45 9477
TEST_TIME 46 9547
TEST_TIME 47 9597
TEST_TIME 48 9613
TEST_TIME 49 9543
TEST_TIME 50 9482
TEST_TIME 51 9451
TEST_TIME 52 9314
TEST_TIME 53 9372
TEST_TIME 54 9352
TEST_TIME 55 9363
TEST_TIME 56 9302
TEST_TIME 57 9350
TEST_TIME 58 9329
TEST_TIME 59 9291
TEST_TIME 60 9427
TEST_TIME 61 9384
TEST_TIME 62 9509
TEST_TIME 63 9489
TEST_TIME 64 9528
TEST_TIME 65 9502
TEST_TIME 66 9571
TEST_TIME 67 9623
TEST_TIME 68 9595
TEST_TIME 69 9637
TEST_TIME 70 9686
TEST_TIME 71 9796
TEST_TIME 72 9709
TEST_TIME 73 9607
TEST_TIME 74 9551
TEST_TIME 75 9524
TEST_TIME 76 9490
TEST_TIME 77 9440
TEST_TIME 78 9416
TEST_TIME 79 9391
TEST_TIME 80 9404
TEST_TIME 81 9406
TEST_TIME 82 9384
TEST_TIME 83 9333
TEST_TIME 84 9407
TEST_TIME 85 9385
TEST_TIME 86 9374
TEST_TIME 87 9353
TEST_TIME 88 9456
TEST_TIME 89 9461
TEST_TIME 90 9426
TEST_TIME 91 9389
TEST_TIME 92 9474
TEST_TIME 93 9479
TEST_TIME 94 9478
TEST_TIME 95 9442
TEST_TIME 96 9437
TEST_TIME 97 9376
TEST_TIME 98 9355
TEST_TIME 99 9310
TEST_TIME 100 9269
TEST_TIME 101 9274
TEST_TIME 102 9243
TEST_TIME 103 9223
TEST_TIME 104 9209
TEST_TIME 105 9210
TEST_TIME 106 9162
TEST_TIME 107 9189
TEST_TIME 108 9194
TEST_TIME 109 9194
TEST_TIME 110 9262
TEST_TIME 111 9278
TEST_TIME 112 9258
TEST_TIME 113 9273
TEST_TIME 114 9327
TEST_TIME 115 9344
TEST_TIME 116 9392
TEST_TIME 117 9412
TEST_TIME 118 9387
TEST_TIME 119 9332
TEST_TIME 120 9258

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-03-2021 19:29:07 to 18-03-2021 19:29:11.

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 1544894 1544894 0 0.00 0 16787 6 0 0
doc_list_biud 1544894 1544894 0 0.00 0 52371 24 0 0
sp_add_invoice_to_stock 5293 5187 106 2.00 27 280330 15284 0 106
sp_cancel_adding_invoice 5611 5611 0 0.00 6 50855 791 0 0
sp_cancel_client_order 1865 1865 0 0.00 4 10129 344 0 0
sp_cancel_customer_reserve 553567 553567 0 0.00 1 52447 51 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 2 6222 73 0 0
sp_cancel_pay_to_supplier 435 435 0 0.00 3 7200 75 0 0
sp_cancel_supplier_invoice 6226 6222 4 0.06 2 32306 778 0 4
sp_cancel_supplier_order 415 415 0 0.00 6 824463 87986 0 0
sp_cancel_write_off 9397 9397 0 0.00 1 16847 101 0 0
sp_client_order 21549 21549 0 0.00 3 51383 347 0 0
sp_customer_reserve 467934 467934 0 0.00 0 233834 155 0 0
sp_fill_shopping_cart 33127 33127 0 0.00 1 12721 37 0 0
sp_fill_shopping_cart_clo_res 467923 467923 0 0.00 0 27341 12 0 0
sp_get_clo_for_invoice 5176 5176 0 0.00 0 25105 250 0 0
sp_kill_cost_storno 16138 16138 0 0.00 0 16785 51 0 0
sp_kill_qstorno_ret_qs2qd 1123168 1123168 0 0.00 0 52367 28 0 0
sp_kill_qty_storno 592723 592723 0 0.00 0 52371 61 0 0
sp_lock_selected_doc 21741 21741 0 0.00 0 6665 4 0 0
sp_make_cost_storno 29166 29166 0 0.00 0 8950 48 0 0
sp_multiply_rows_for_pdistr 29166 29166 0 0.00 0 7988 28 0 0
sp_multiply_rows_for_qdistr 21549 21549 0 0.00 0 51374 166 0 0
sp_pay_from_customer 7383 7383 0 0.00 4 16750 113 0 0
sp_pay_to_supplier 6137 6137 0 0.00 5 13542 113 0 0
sp_payment_common 13520 13520 0 0.00 1 16745 28 0 0
sp_qd_handle_on_cancel_clo 1865 1865 0 0.00 0 10123 314 0 0
sp_qd_handle_on_invoice_upd_sts 10787 10787 0 0.00 0 39716 314 0 0
sp_qd_handle_on_reserve_upd_sts 10470 10470 0 0.00 0 18751 56 0 0
sp_reserve_write_off 10470 10470 0 0.00 6 18774 168 0 0
sp_supplier_invoice 5884 5884 0 0.00 6 103811 3384 0 0
sp_supplier_order 5694 5694 0 0.00 5 62292 1282 0 0
srv_aggregate_perf_data 106 106 0 0.00 2695 321991 20232 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1938 296939 34953 0 0
srv_find_qd_qs_mism 1061489 1061489 0 0.00 0 16756 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 52 42038 1234 0 0
srv_make_money_saldo 834 834 0 0.00 0 2305 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 161399 453998 267443 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5189 5189 0 0.00 0 20071 144 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 0 9671 93 0 0
t$perf-norm:sp_cancel_client_order 1865 1865 0 0.00 0 1518 9 0 0
t$perf-norm:sp_cancel_customer_reserve 781 781 0 0.00 0 5016 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 669 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 435 435 0 0.00 0 132 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 1252 24 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 34270 1437 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 608 4 0 0
t$perf-norm:sp_client_order 21549 21549 0 0.00 0 14390 15 0 0
t$perf-norm:sp_customer_reserve 1094 1094 0 0.00 0 817 4 0 0
t$perf-norm:sp_pay_from_customer 7383 7383 0 0.00 0 14431 10 0 0
t$perf-norm:sp_pay_to_supplier 6137 6137 0 0.00 0 10189 11 0 0
t$perf-norm:sp_reserve_write_off 10470 10470 0 0.00 0 7449 8 0 0
t$perf-norm:sp_supplier_invoice 5884 5884 0 0.00 0 8912 17 0 0
t$perf-norm:sp_supplier_order 5694 5694 0 0.00 0 4668 14 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 344 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 92 1 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 829 17 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 1026 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10564 10352 212 2.00 0 5094 16 0 212
v_all_customers 39166 39166 0 0.00 0 15 1 0 0
v_all_suppliers 31916 31916 0 0.00 0 116 1 0 0
v_all_wares 43098 43098 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 394 6 0 0
v_cancel_client_order 3730 3730 0 0.00 0 2227 4 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 660 3 0 0
v_cancel_customer_reserve 1562 1562 0 0.00 0 374 3 0 0
v_cancel_payment_to_supplier 870 870 0 0.00 0 5472 9 0 0
v_cancel_supplier_invoice 822 814 8 0.97 0 5082 27 0 8
v_cancel_supplier_order 830 830 0 0.00 0 330 3 0 0
v_cancel_write_off 2102 2102 0 0.00 0 2137 13 0 0
v_max_id_clo_ord 5694 5694 0 0.00 0 435 1 0 0
v_max_id_clo_res 1094 1094 0 0.00 0 4964 25 0 0
v_max_id_ord_sup 5884 5884 0 0.00 0 6122 6 0 0
v_max_non_paid_invoice 1757 1757 0 0.00 0 459 3 0 0
v_max_non_paid_realizn 3927 3927 0 0.00 0 3279 4 0 0
v_min_id_clo_ord 5694 5694 0 0.00 0 4385 8 0 0
v_min_id_clo_res 1094 1094 0 0.00 0 1024 6 0 0
v_min_id_ord_sup 5884 5884 0 0.00 0 5874 7 0 0
v_min_non_paid_invoice 6137 6137 0 0.00 0 5604 14 0 0
v_min_non_paid_realizn 7383 7383 0 0.00 0 16743 22 0 0
v_our_firm 10844 10844 0 0.00 0 14 1 0 0
v_reserve_write_off 20940 20940 0 0.00 0 5080 5 0 0
x_lock_depdocs_on_canc_invoice 11426 11426 0 0.00 0 27962 127 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 8792 324 0 0
x_make_qstorno_1000_1200 5694 5694 0 0.00 1 62279 1207 0 0
x_make_qstorno_1200_2000 5884 5884 0 0.00 3 103803 3249 0 0
x_make_qstorno_2100_3300 467934 467934 0 0.00 0 233825 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-03-2021 19:29:12 to 18-03-2021 19:29:16.

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:26 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 12293 8192000000 10207562624 10510249984 919721360 10.093 74 51 101 1 940192560 2514448 17956752
16:57:54 17114 8192000000 10304681648 10619158528 1365520992 14.287 100 79 158 1 1394701328 4241616 24938720
16:58:18 35994 8192000000 10369349136 10695438336 1412208784 14.704 100 87 174 0 1446893536 6090560 28594192
16:59:04 10139 8192000000 10392065040 10719145984 1452404496 15.059 100 82 164 0 1486463168 7233488 26825184
16:59:22 18587 8192000000 10421688224 10750582784 1476319376 15.269 100 87 173 1 1512242368 7986736 27936256
17:00:00 15461 8192000000 10443078752 10775318528 1498439712 15.463 100 91 182 1 1536943488 9005008 29498768
17:00:27 25171 8192000000 10460945376 10795655168 1510650192 15.569 100 89 178 1 1549183968 9979008 28554768
17:00:59 13212 8192000000 10465477328 10801655808 1521483696 15.663 100 93 186 1 1561851776 10491296 29876784
17:01:21 19061 8192000000 10473361952 10814672896 1525132848 15.695 100 81 162 1 1561524752 10565680 25826224
17:01:50 21404 8192000000 10504815344 10850435072 1558524496 15.984 100 85 170 0 1595924784 11060240 26340048
17:02:26 14980 8192000000 10544723408 10897928192 1595249664 16.299 100 76 150 2 1629469632 10952624 23267344
17:02:52 9214 8192000000 10582979072 10939699200 1632655744 16.617 100 86 172 1 1670068480 11483920 25928816
17:03:10 12114 8192000000 10583401136 10941042688 1641495280 16.692 100 79 158 1 1677337184 12007328 23834576
17:03:30 10933 8192000000 10604756656 10967674880 1660264320 16.851 100 81 162 0 1696733568 12250032 24219216
17:03:48 8737 8192000000 10612166928 10979549184 1673380048 16.962 100 80 160 0 1708819216 12180800 23258368
17:04:04 9306 8192000000 10638951680 11005882368 1697888192 17.167 100 80 162 1 1734026672 12436944 23701536
17:04:20 5403 8192000000 10661885024 11027972096 1709073712 17.261 100 87 174 3 1747187792 13021792 25092288
17:04:37 6571 8192000000 10659232448 11034128384 1723623616 17.382 100 79 158 1 1758835584 12867456 22344512
17:04:51 6078 8192000000 10670164800 11048230912 1735376864 17.480 100 84 168 2 1771974640 13109824 23487952
17:05:05 3486 8192000000 10680011136 11056250880 1747269536 17.579 100 83 163 3 1783524464 12358208 23896720
17:05:17 6236 8192000000 10699903504 11077292032 1760171024 17.686 100 85 168 2 1796629040 12802800 23655216
17:05:30 5703 8192000000 10708120384 11084161024 1761772576 17.699 100 83 164 2 1797124432 12891264 22460592
17:05:42 3272 8192000000 10711294160 11087859712 1774426320 17.804 100 86 169 0 1811246656 12972928 23847408
17:05:52 6733 8192000000 10729149408 11106054144 1782754400 17.872 100 87 173 0 1821405568 14368896 24282272
17:06:06 3037 8192000000 10731893408 11110694912 1789407808 17.927 100 83 166 1 1827034320 14483936 23142576
17:06:16 4692 8192000000 10744090288 11122679808 1798360320 18.000 100 86 172 1 1837101520 14762144 23979056
17:06:27 1534 8192000000 10737461872 11118141440 1805614288 18.060 100 92 179 1 1845169728 14055088 25500352
17:06:35 3357 8192000000 10746925552 11132772352 1810708352 18.102 100 84 167 0 1846760496 12093664 23958480
17:06:46 6174 8192000000 10750707696 11138609152 1814508128 18.133 100 73 146 1 1846770384 12267680 19994576
17:06:59 5310 8192000000 10771882192 11161485312 1826051776 18.227 100 83 166 1 1861640864 12055120 23533968
17:07:10 1773 8192000000 10782941984 11170213888 1843007408 18.365 100 88 176 0 1880793216 12736880 25048928
17:07:18 2089 8192000000 10791644240 11177607168 1846857936 18.397 100 87 171 1 1883897616 12727424 24312256
17:07:27 1922 8192000000 10795726128 11183878144 1852451264 18.442 100 90 184 1 1891685824 13711536 25523024
17:07:35 2206 8192000000 10801685504 11191738368 1856630480 18.476 100 88 176 2 1894967824 13650144 24687200
17:07:44 1855 8192000000 10796895328 11190013952 1859399952 18.498 100 90 180 1 1898886400 14206752 25279696
17:07:52 1616 8192000000 10809229424 11199496192 1864012048 18.536 100 88 175 1 1902348304 14391296 23944960
17:08:00 1900 8192000000 10816552144 11206905856 1868017088 18.568 100 87 174 2 1905658752 13977680 23663984
17:08:08 2261 8192000000 10823251888 11211624448 1876258528 18.635 100 86 171 1 1913810432 12792336 24759568
17:08:17 1497 8192000000 10822303264 11210907648 1877932096 18.648 100 89 181 0 1916807104 12793184 26081824
17:08:25 1851 8192000000 10829792544 11215929344 1879481856 18.661 100 97 194 1 1920736000 13975616 27278528
17:08:34 1881 8192000000 10824593200 11216072704 1879490720 18.661 100 90 178 2 1916447616 12524528 24432368
17:08:42 1469 8192000000 10830004272 11217690624 1883293680 18.692 100 91 182 1 1923767808 13972336 26501792
17:08:49 34487 8192000000 10819355088 11210575872 1875131808 18.626 100 59 118 0 1903987088 12546608 16308672
17:09:30 2001 8192000000 10821425008 11223511040 1885623392 18.710 100 87 175 1 1921286560 10355968 25307200
17:09:39 2906 8192000000 10810406816 11226841088 1880864560 18.672 100 52 103 0 1904650848 9988208 13798080
17:09:49 5781 8192000000 10801686704 11219664896 1881559696 18.678 100 41 82 2 1901112336 8366848 11185792
17:10:02 7369 8192000000 10799156896 11220123648 1881656128 18.678 100 34 68 1 1898773248 8114448 9002672
17:10:15 6330 8192000000 10808300512 11220025344 1883907792 18.697 100 29 59 2 1901699632 9585136 8206704
17:10:29 9000 8192000000 10804827488 11228532736 1890837600 18.753 100 30 60 3 1906118016 6381040 8899376
17:10:45 9448 8192000000 10815071760 11235061760 1894346576 18.781 100 29 58 2 1912866560 11016256 7503728
17:11:00 8831 8192000000 10807809456 11239231488 1895668368 18.791 100 27 55 0 1913836432 10611600 7556464
17:11:19 6767 8192000000 10811946800 11239153664 1898850320 18.817 100 28 56 2 1912933344 6578720 7504304
17:11:35 7419 8192000000 10809234448 11241963520 1900057248 18.827 100 26 51 3 1913982752 7110080 6815424
17:11:53 17142 8192000000 10823776960 11255033856 1902511024 18.846 100 17 34 1 1917073056 10195504 4366528
17:12:17 47155 8192000000 10847587440 11253596160 1910988944 18.915 100 55 106 3 1932673264 5252736 16431584
17:13:10 4199 8192000000 10843310096 11264352256 1913039136 18.931 100 47 94 2 1936504496 10302816 13162544
17:13:21 3629 8192000000 10821759472 11258494976 1911628976 18.920 100 41 81 0 1931042096 7865856 11547264
17:13:31 5658 8192000000 10828799216 11260346368 1912189568 18.924 100 37 77 2 1932726160 9982848 10553744
17:13:45 8229 8192000000 10825339472 11259170816 1911445504 18.918 100 25 51 1 1925234176 6976864 6811808
17:14:02 6633 8192000000 10836744112 11265601536 1916639184 18.960 100 35 68 2 1932069504 5588560 9841760
17:14:16 6495 8192000000 10836827104 11264360448 1915960928 18.954 100 35 70 3 1932832688 6982528 9889232
17:14:29 8914 8192000000 10821836288 11261100032 1914775632 18.945 100 21 42 2 1926666960 5911024 5980304
17:14:44 7275 8192000000 10833687744 11266637824 1918658816 18.976 100 21 42 0 1930115536 5998016 5458704
17:15:00 11020 8192000000 10825390704 11270430720 1917293552 18.965 100 17 34 0 1931926688 9825344 4807792
17:15:20 6620 8192000000 10827556528 11265310720 1918110528 18.972 100 19 38 1 1929290112 6082960 5096624
17:15:33 5205 8192000000 10830905904 11267833856 1920508832 18.991 100 23 46 1 1932628688 5461920 6657936
17:15:46 4543 8192000000 10831236272 11269525504 1922647392 19.008 100 26 50 3 1935796736 5659744 7489600
17:16:00 54144 8192000000 10823378336 11255345152 1886273200 18.716 98 25 50 1 1899385824 6271296 6841328
17:17:01 3343 8192000000 10817749792 11259260928 1914665840 18.944 100 26 50 2 1926774880 4931184 7177856
17:17:11 5454 8192000000 10837431440 11270959104 1918417968 18.974 100 30 60 0 1933838624 7183680 8236976
17:17:23 5420 8192000000 10821264080 11251228672 1879941408 18.665 98 32 63 2 1894538272 5712096 8884768
17:17:37 6388 8192000000 10810608976 11238748160 1866041728 18.552 98 25 50 0 1879741504 5971008 7728768
17:17:50 3170 8192000000 10818104480 11245735936 1894992208 18.786 100 39 78 1 1916877456 10494560 11390688
17:17:59 7205 8192000000 10794967056 11223642112 1826035072 18.227 96 26 52 0 1838779232 5472496 7271664
17:18:15 7015 8192000000 10780752048 11205206016 1825937168 18.226 97 32 61 2 1841366704 5523696 9905840
17:18:29 6486 8192000000 10779762096 11209777152 1840323376 18.343 98 38 75 2 1857874464 6116368 11434720
17:18:42 9709 8192000000 10778763200 11219886080 1858874032 18.494 99 19 38 0 1869412032 5371216 5166784
17:19:00 9365 8192000000 10735018064 11153616896 1736258272 17.488 94 28 56 2 1749786800 5141664 8386864
17:19:16 8312 8192000000 10757297712 11173208064 1830261104 18.261 100 27 54 0 1847195280 9252432 7681744
17:19:33 12690 8192000000 10722030080 11148967936 1747039712 17.577 95 25 50 0 1764308928 9840304 7428912
17:19:53 5649 8192000000 10730500448 11156373504 1809246304 18.090 99 24 48 1 1821560016 5325232 6988480
17:20:04 6120 8192000000 10691088496 11114049536 1731130192 17.445 95 24 48 3 1743263504 5470448 6662864
17:20:21 4123 8192000000 10716207104 11114573824 1740697984 17.524 96 49 96 1 1761170736 5079040 15393712
17:21:24 17956 8192000000 10695981792 11110002688 1728002736 17.419 95 15 30 0 1737108400 5006336 4099328
17:21:49 9245 8192000000 10666848176 11070771200 1674576064 16.972 94 26 51 1 1688019392 5098080 8345248
17:22:04 5875 8192000000 10712777040 11125202944 1795182864 17.974 100 33 64 2 1811203568 6520688 9500016
17:22:16 4626 8192000000 10710074368 11117215744 1747594320 17.582 97 38 76 2 1766276944 7629184 11053440
17:22:29 6159 8192000000 10721495344 11126620160 1782190320 17.868 99 30 60 2 1800340976 10120928 8029728
17:22:42 9942 8192000000 10734055040 11144794112 1810623408 18.101 100 36 69 2 1827033520 5545968 10864144
17:22:58 8221 8192000000 10740128240 11155980288 1807991968 18.079 99 27 54 0 1821319344 5349104 7978272
17:23:12 7928 8192000000 10741434480 11167424512 1823689120 18.208 100 19 38 1 1834967024 5379648 5898256
17:23:26 7832 8192000000 10752262752 11177648128 1837503072 18.320 100 25 50 1 1850534368 6085312 6945984
17:23:40 9087 8192000000 10750729264 11179163648 1841073392 18.350 100 17 34 0 1852086096 6279728 4732976
17:23:58 7526 8192000000 10775685408 11193884672 1851688176 18.436 100 36 72 1 1867266128 4994064 10583888
17:24:12 10295 8192000000 10767590320 11189895168 1850158064 18.423 100 23 46 1 1862547328 5522560 6866704
17:24:29 10381 8192000000 10760291296 11191177216 1852689664 18.444 100 23 45 1 1865456336 5960240 6806432
17:24:47 13817 8192000000 10769092256 11195965440 1856229200 18.473 100 12 23 1 1864624320 5036656 3358464
17:25:12 74183 8192000000 10769499056 11204403200 1864588560 18.540 100 24 48 2 1881737360 9732992 7415808
17:26:35 10710 8192000000 10786954608 11212537856 1864643920 18.541 100 19 38 1 1876524160 6084400 5795840
17:26:56 6880 8192000000 10787470560 11213381632 1870238016 18.586 100 23 46 2 1882469472 5865088 6366368
17:27:11 5859 8192000000 10815987584 11235889152 1887697152 18.727 100 31 59 0 1900977264 5951232 7328880
17:27:25 43589 8192000000 10823964048 11250503680 1900199376 18.828 100 37 71 1 1915508832 5082752 10226704
17:28:18 19194 8192000000 10830892432 11263021056 1910408032 18.910 100 38 76 1 1930071248 8229392 11433824
17:28:49 28109 8192000000 10857487712 11281788928 1923789712 19.017 100 39 76 0 1944515776 9968944 10757120
17:29:25 13115 8192000000 10867587072 11288666112 1932253536 19.085 100 49 96 2 1957252464 11255392 13743536
17:29:46 19876 8192000000 10869386320 11296604160 1939287264 19.141 100 49 98 3 1965924480 12122000 14515216
17:30:19 13338 8192000000 10878313808 11303284736 1941389152 19.158 100 46 92 1 1967482160 12913440 13179568
17:30:42 7363 8192000000 10894508128 11315998720 1949794512 19.225 100 52 104 0 1978849824 13855632 15199680
17:30:58 4127 8192000000 10896026656 11320201216 1957136896 19.283 100 56 111 2 1987639312 14187760 16314656
17:31:24 10627 8192000000 10894200512 11326582784 1963968032 19.338 100 58 116 0 1996030352 14700304 17362016
17:31:51 9290 8192000000 10903123072 11329773568 1965130544 19.347 100 52 104 3 1995997856 15820064 15047248
17:32:10 9017 8192000000 10905058016 11334877184 1965582144 19.350 100 50 97 1 1995845888 15166048 15097696
17:32:26 15750 8192000000 10900232224 11332771840 1964523808 19.342 100 40 80 2 1993162048 15685904 12952336
17:32:53 21217 8192000000 10909388800 11338141696 1970485296 19.389 100 51 100 2 2002565520 16158304 15921920
17:33:21 34935 8192000000 10902739632 11348783104 1976773936 19.439 100 46 90 3 2005450640 15001696 13675008
17:34:05 33097 8192000000 10905890032 11353628672 1977991728 19.449 100 30 60 0 2002607344 15708416 8907200
17:34:50 16837 8192000000 10920077152 11362095104 1987703504 19.526 100 41 81 1 2015887248 16323360 11860384
17:35:20 8873 8192000000 10933480864 11369226240 1990592064 19.548 100 42 84 0 2018978048 15683152 12702832
17:35:38 12192 8192000000 10942615536 11374833664 1994946848 19.583 100 52 104 2 2031501776 21373376 15181552
17:36:00 4291 8192000000 10936425024 11375796224 1999091984 19.616 100 55 108 2 2035748304 19288656 17367664
17:36:12 4584 8192000000 10949288896 11362238464 1963410720 19.333 98 64 128 0 2002330128 19696800 19222608
17:36:38 5664 8192000000 10942248464 11378827264 1993201616 19.569 100 49 99 0 2032503584 24385920 14916048
17:36:50 13823 8192000000 10948699936 11385729024 1998728480 19.613 100 51 100 1 2038815488 24908672 15178336
17:37:19 4429 8192000000 10957212240 11394326528 2006456608 19.674 100 49 98 2 2047942976 25905488 15580880
17:37:33 5422 8192000000 10966322192 11401654272 2013154272 19.726 100 51 101 0 2053616208 24771136 15690800
17:37:45 9680 8192000000 10981966432 11412975616 2020947328 19.788 100 64 125 1 2068240752 27209696 20083728
17:38:02 3706 8192000000 10975905456 11414753280 2022905664 19.803 100 63 126 2 2068345040 26380160 19059216
17:38:16 7387 8192000000 10983414496 11413999616 2008115712 19.687 99 67 134 0 2056848736 28317648 20415376
17:38:32 4138 8192000000 10978931296 11410763776 2021708880 19.794 100 65 125 0 2070396208 28797072 19890256
17:38:44 4176 8192000000 10985553504 11413397504 2022465808 19.800 100 70 139 0 2071900112 28383888 21050416
17:38:58 6019 8192000000 10986438544 11418509312 2025837104 19.826 100 72 143 2 2078639872 30490256 22312512
17:39:11 5956 8192000000 10995626304 11418079232 2010435792 19.705 99 81 162 1 2067929968 32729536 24764640
17:39:27 8360 8192000000 10986242736 11415744512 2007872272 19.685 99 70 140 0 2066362768 37384960 21105536
17:39:42 2760 8192000000 10993294464 11421122560 2023623328 19.809 100 81 162 0 2082537344 34067520 24846496
17:39:51 6613 8192000000 10981043888 11414544384 2016203744 19.750 100 74 148 3 2074896288 35052320 23640224
17:40:05 4060 8192000000 11000224304 11424694272 2021991808 19.796 100 74 146 0 2081016912 36354832 22670272
17:40:16 3439 8192000000 11004804128 11434487808 2026671040 19.833 100 81 162 1 2090256352 37975808 25609504
17:40:26 1936 8192000000 11002069392 11426848768 2021719808 19.794 100 80 156 1 2081766000 34461856 25584336
17:40:39 8107 8192000000 10973641168 11411337216 1996148848 19.592 99 55 110 0 2044842752 31788448 16905456
17:40:56 4572 8192000000 10974731200 11407585280 2007119056 19.679 100 61 122 0 2058115056 31353152 19642848
17:41:08 3750 8192000000 10963418960 11402719232 1989025712 19.536 99 57 113 0 2038704128 31695600 17982816
17:41:21 6782 8192000000 10956368592 11390529536 1971680528 19.399 98 59 116 2 2023425344 32806464 18938352
17:41:34 5513 8192000000 10969788512 11397791744 1997521840 19.603 100 74 148 2 2049006208 28998304 22486064
17:41:49 6026 8192000000 10965822512 11392266240 1993764752 19.574 100 71 142 0 2045462192 29225552 22471888
17:42:03 3543 8192000000 10983546176 11400052736 2006999984 19.678 100 90 179 0 2064689776 30606064 27083728
17:42:15 3171 8192000000 10943341600 11363434496 1961560672 19.318 98 70 140 1 2011573184 29201232 20811280
17:42:25 2881 8192000000 10943720800 11367256064 1975371152 19.428 100 79 159 1 2029746688 30043664 24331872
17:42:34 3685 8192000000 10936832704 11359780864 1967191392 19.363 100 72 142 4 2018948928 30131600 21625936
17:42:45 10673 8192000000 10935301024 11365310464 1969764528 19.384 100 68 136 1 2021790192 31465152 20560512
17:43:06 8982 8192000000 10917921600 11362041856 1962683104 19.327 100 41 82 0 2006081040 30586560 12811376
17:43:27 9673 8192000000 10877894768 11320442880 1878051488 18.649 96 36 72 1 1919933648 30227840 11654320
17:43:49 10408 8192000000 10912615744 11354365952 1951040352 19.235 100 37 74 0 1997833712 33867248 12926112
17:44:09 7989 8192000000 10925356544 11360518144 1964144400 19.339 100 43 86 3 2008855184 30269952 14440832
17:44:24 4167 8192000000 10898507408 11323826176 1920055040 18.987 98 62 123 1 1969264976 30096336 19113600
17:44:36 10342 8192000000 10908653072 11340251136 1930022528 19.067 99 53 106 2 1978116832 31345552 16748752
17:44:56 16067 8192000000 10897941904 11338027008 1927525632 19.047 99 32 64 1 1970104864 31415136 11164096
17:45:20 6001 8192000000 10909787936 11337564160 1940476448 19.151 100 53 106 2 1990516304 33690608 16349248
17:45:33 7368 8192000000 10939093488 11358699520 1954728432 19.264 100 65 129 0 2008358624 32449360 21180832
17:45:48 2197 8192000000 10920468976 11355217920 1956892160 19.281 100 59 118 2 2007822320 32848240 18081920
17:45:56 12047 8192000000 10899500368 11348041728 1950960608 19.234 100 35 70 3 1994612464 32301056 11350800
17:46:15 12097 8192000000 10890713584 11333218304 1935858400 19.114 100 31 62 0 1975037200 28891440 10287360
17:46:34 7485 8192000000 10901991808 11342290944 1947946912 19.210 100 41 81 1 1989868752 28782432 13139408
17:46:50 4923 8192000000 10902009360 11336200192 1937475344 19.127 100 53 106 3 1985716944 32165264 16076336
17:47:02 9176 8192000000 10897812208 11334189056 1927843952 19.050 99 50 97 1 1973388080 30651120 14893008
17:47:22 12964 8192000000 10885925104 11322273792 1905860864 18.873 98 28 56 2 1946177712 31055584 9261264
17:47:41 7093 8192000000 10868224784 11310694400 1897260864 18.804 98 27 54 2 1938837392 32738704 8837824
17:47:55 17615 8192000000 10893044160 11333218304 1914390240 18.942 99 34 66 1 1959172960 34127056 10655664
17:48:21 16789 8192000000 10879477504 11323502592 1907032160 18.883 99 27 54 2 1944314368 28736912 8545296
17:48:48 2176 8192000000 10900492960 11321102336 1915278736 18.949 99 60 116 1 1964665600 31853872 17532992
17:48:56 14487 8192000000 10877946256 11336572928 1915953872 18.954 99 45 89 1 1964585120 34789600 13841648
17:49:26 15112 8192000000 10863551088 11313250304 1917877680 18.970 100 20 40 1 1948140528 24265408 5997440
17:49:48 53124 8192000000 10882574128 11317956608 1915398176 18.950 99 32 66 2 1944225824 19060672 9766976
17:50:52 4963 8192000000 10901897824 11339264000 1945728912 19.192 100 56 111 1 1983615472 20965376 16921184
17:51:05 19514 8192000000 10873544688 11328155648 1933301936 19.093 100 21 42 0 1960159376 20718320 6139120
17:51:30 15440 8192000000 10875343824 11331727360 1940427312 19.150 100 20 39 1 1968019840 21505856 6086672
17:52:20 19758 8192000000 10898707456 11353718784 1932871632 19.090 99 31 62 1 1978472448 36574176 9026640
17:52:47 6538 8192000000 10904618640 11356028928 1950615552 19.231 100 21 42 0 1992375952 35252528 6507872
17:53:03 14960 8192000000 10905668416 11364380672 1955059616 19.267 100 24 48 2 1997400288 34805536 7535136
17:53:30 37082 8192000000 10891968736 11345371136 1918928896 18.978 98 23 45 0 1948148448 22107488 7112064
17:54:24 18345 8192000000 10903279824 11356106752 1962182224 19.323 100 25 50 1 1993896000 24000208 7713568
17:54:49 40130 8192000000 10898166416 11349282816 1938402832 19.134 99 19 39 1 1967180848 22101264 6676752
17:56:12 67351 8192000000 10894202144 11317510144 1865971424 18.552 96 26 52 1 1902582848 28833408 7778016
17:57:28 52186 8192000000 10836858768 11286777856 1846948432 18.397 96 23 46 1 1864719440 11663744 6107264
17:58:44 66671 8192000000 10866088224 11307909120 1883034320 18.690 98 6 12 0 1902776048 18132480 1609248
18:00:38 100927 8192000000 10878432416 11332681728 1906232176 18.876 98 9 18 0 1924283360 15137456 2913728
18:02:27 87068 8192000000 10889194368 11344293888 1940936128 19.154 99 10 20 0 1950712288 7196288 2579872
18:04:01 63276 8192000000 10895317056 11356762112 1946070912 19.195 99 9 18 1 1959325776 10975632 2279232
18:05:10 21002 8192000000 10904910784 11349966848 1954719376 19.264 99 35 68 2 1973635696 9494752 9421568
18:05:41 28001 8192000000 10921353728 11352854528 1972694176 19.407 100 38 74 3 1992995664 9377760 10923728
18:06:20 88952 8192000000 10910104448 11356102656 1976622016 19.438 100 43 86 3 2001149152 12158272 12368864
18:07:59 27162 8192000000 10908509904 11362250752 1977983808 19.449 100 51 97 2 2009268416 15658272 15626336
18:08:44 45109 8192000000 10928010304 11372793856 1966344624 19.356 99 26 52 2 1982511424 9050064 7116736
18:09:39 132198 8192000000 10926029840 11388694528 1971761328 19.399 99 18 36 1 1989696192 12695520 5239344
18:11:59 34402 8192000000 10937814800 11398471680 1981949024 19.480 99 19 37 1 2008934192 21519552 5465616
18:12:44 61629 8192000000 10928630784 11391193088 1984688384 19.502 99 32 62 0 2011871696 18275584 8907728
18:13:56 39839 8192000000 10916534208 11410579456 1989357904 19.539 100 10 20 0 2012145120 19822272 2964944
18:14:42 21663 8192000000 10925032480 11405361152 1993114192 19.568 100 11 23 0 2014864000 18603632 3146176
18:16:15 296933 8192000000 10905429104 11404103680 1935938112 19.114 97 15 30 0 1959833872 19544160 4351600
18:21:27 19258 8192000000 10926384000 11392155648 1997929664 19.606 100 23 46 1 2010778672 6609312 6239696
18:21:53 38627 8192000000 10912511136 11379359744 1980643792 19.470 99 25 50 0 1996020736 8409472 6967472
18:22:39 83402 8192000000 10905874880 11394818048 1957589120 19.287 98 5 10 2 1969760016 10977200 1193696
18:24:08 54030 8192000000 10904863776 11390857216 1951093024 19.235 98 9 18 0 1970041392 15863056 3085312
18:25:14 65685 8192000000 10875092384 11328638976 1810583360 18.101 91 27 54 1 1827228752 8761216 7884176
18:26:33 29585 8192000000 10858306176 11319283712 1880894688 18.672 96 38 75 4 1903552464 11617008 11040768
18:27:13 58515 8192000000 10849079216 11323432960 1843069664 18.366 95 11 22 0 1858076544 12006000 3000880
18:28:18 35945 8192000000 10839043616 11297910784 1856903232 18.478 96 16 32 2 1870289856 9158848 4227776
18:29:00 69258 8192000000 10856425008 11326496768 1869667456 18.582 97 27 54 1 1889876896 13137856 7071584
18:30:16 23839 8192000000 10869375072 11322589184 1903162576 18.852 98 11 22 2 1911691440 5798336 2730528
18:30:47 15183 8192000000 10868025120 11318378496 1903628720 18.855 98 35 70 0 1921888736 8510544 9749472
18:31:17 43803 8192000000 10866407568 11319029760 1898884784 18.817 98 27 53 1 1917048864 11105776 7058304
18:32:08 8069 8192000000 10901037040 11330867200 1938196800 19.132 100 74 145 3 1965926912 7545104 20185008
18:32:25 32829 8192000000 10887787776 11337355264 1913037088 18.931 98 49 98 2 1944112928 17356128 13719712
18:33:09 41805 8192000000 10862687952 11324104704 1857604576 18.484 96 24 48 0 1883455984 19397120 6454288
18:34:01 52139 8192000000 10853804336 11306401792 1846456768 18.393 96 16 32 3 1862213616 11492016 4264832
18:35:02 41868 8192000000 10853841424 11312193536 1873916512 18.616 97 23 46 0 1891146752 10827664 6402576
18:35:56 112655 8192000000 10870241584 11346731008 1920709744 18.993 99 22 44 0 1943477312 16361104 6406464
18:38:01 74052 8192000000 10842076304 11306352640 1853555360 18.451 96 8 16 1 1870283424 14487296 2240768
18:39:23 127772 8192000000 10861518240 11322384384 1896923824 18.802 98 30 59 3 1916817648 11210560 8683264
18:41:41 73512 8192000000 10873958064 11333873664 1898813568 18.817 98 35 70 0 1923660528 15287872 9559088
18:43:11 4717 8192000000 10866224416 11328790528 1928970128 19.059 100 31 62 1 1955603504 17633392 8999984
18:43:22 9259 8192000000 10844625440 11315425280 1905045392 18.867 99 12 24 0 1923420912 15067408 3308112
18:43:38 32552 8192000000 10855221920 11307134976 1907847632 18.889 99 27 54 0 1930267248 14224128 8195488
18:45:20 39825 8192000000 10864064304 11331280896 1921318640 18.997 99 20 39 0 1937043392 10425024 5299728
18:46:13 49452 8192000000 10867241824 11344863232 1923521296 19.015 99 16 32 0 1940157568 12002240 4634032
18:47:09 52968 8192000000 10872700432 11358248960 1954038832 19.259 100 13 26 0 1971974752 13942816 3993104
18:49:47 39100 8192000000 10881698800 11356217344 1923360304 19.014 98 18 36 1 1938611616 10399152 4852160
18:50:46 53602 8192000000 10882594848 11356471296 1935590048 19.112 99 20 40 2 1953251952 11956976 5704928
18:51:49 44185 8192000000 10897036208 11364405248 1963438256 19.333 100 19 38 1 1976193664 7568992 5186416
18:52:43 23311 8192000000 10892891440 11361148928 1954232736 19.260 99 27 54 0 1972871792 10580944 8058112
18:53:14 30574 8192000000 10896547568 11369664512 1956128544 19.275 99 41 80 1 1979246848 11428832 11689472
18:54:01 44401 8192000000 10912495840 11381223424 1970944592 19.393 100 36 72 0 1994952448 13253040 10754816
18:55:02 61905 8192000000 10877233056 11360067584 1931580880 19.080 99 8 16 2 1947091888 12972880 2538128
18:56:10 114440 8192000000 10915147664 11381088256 1953624672 19.255 99 14 28 1 1972617856 15127472 3865712
18:58:10 85811 8192000000 10910875760 11398729728 1986915872 19.519 100 17 34 0 2010051312 18678736 4456704
18:59:43 108015 8192000000 10913134432 11377152000 1913784256 18.937 96 24 48 3 1927878224 7423584 6670384
19:01:49 78021 8192000000 10925606048 11378630656 1959635520 19.303 98 30 58 2 1977899968 10440880 7823568
19:03:16 20616 8192000000 10940236496 11390947328 1975511296 19.429 99 36 72 0 1996366928 10581328 10274304
19:03:46 118413 8192000000 10899676864 11373596672 1909447488 18.902 96 11 22 0 1922849456 9727888 3674080
19:06:15 31063 8192000000 10902068816 11388768256 1984541232 19.501 100 12 24 1 1996865568 8532976 3791360
19:07:09 72524 8192000000 10879956992 11365978112 1926028160 19.035 97 12 24 1 1937407840 7435184 3944496
19:08:28 68834 8192000000 10861096704 11336417280 1895403456 18.789 96 16 31 0 1908903936 9311888 4188592
19:09:43 85745 8192000000 10885161424 11370229760 1963071456 19.330 100 15 30 0 1979850880 12074352 4705072
19:12:18 56673 8192000000 10822610112 11298996224 1766267536 17.736 91 9 18 0 1780244560 11572624 2404400
19:13:26 63047 8192000000 10855070000 11330031616 1900633296 18.831 98 20 40 0 1918579872 12163600 5782976
19:14:42 49656 8192000000 10844749120 11313156096 1817711632 18.159 94 11 22 1 1829921648 9391968 2818048
19:15:39 63672 8192000000 10877370816 11343208448 1908169504 18.892 99 19 38 1 1926204528 12589904 5445120
19:16:50 57220 8192000000 10854847840 11334107136 1897977264 18.810 97 28 56 2 1919259920 13126880 8155776
19:17:55 73362 8192000000 10850643088 11334533120 1856715376 18.477 96 9 18 0 1873967280 14618960 2632944
19:19:14 94638 8192000000 10842469440 11314118656 1859646176 18.500 96 13 25 2 1878717104 15183424 3887504
19:20:55 39047 8192000000 10865584176 11327188992 1882614592 18.686 98 26 52 0 1904110432 13805104 7690736
19:22:24 94131 8192000000 10849978688 11336499200 1876270544 18.635 98 9 18 0 1893526832 14906736 2349552
19:24:04 93618 8192000000 10857489264 11333586944 1909313664 18.901 99 6 12 0 1926189216 14841536 2034016
19:25:54 91351 8192000000 10767319856 11235893248 1838799120 18.331 95 18 36 0 1851807424 7720432 5287872

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

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

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          245170
MON$OLDEST_ACTIVE               245787
MON$OLDEST_SNAPSHOT             245787
MON$NEXT_TRANSACTION            245787
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                       2031840
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

18.03.21 19:29:53. 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-18 19:29:55 No severe PSQL-related problems occured
18.03.21 19:29:56. End of report.