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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17685464 kB
MemAvailable 31567040 kB
Buffers 0 kB
Cached 13989112 kB
SwapCached 1968 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-05 16:32:15
DTS_END                         2020-12-05 16:32:15.5050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47012
TRN_ID                          246692
ATT_ID                          669
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: 9233.78 22673 1108053
customer order: creation 175.20 377 21024
customer order: refuse 14.93 328 1791
order to supplier: creation 46.56 1166 5587
order to supplier: removal 3.39 86321 407
invoice (draft): creation 46.93 3216 5631
invoice (draft): removal 52.31 689 6277
invoice accept: apply 42.36 17088 5083
invoice accept: cancel 46.71 724 5605
customer reserve: creation 3905.24 170 468629
customer reserve: removal 4608.99 49 553079
realization accept: apply 84.83 176 10180
realization accept: cancel 76.09 100 9131
payment from customer: creation 59.01 118 7081
payment from customer: removal 5.83 67 700
payment to supplier: creation 49.98 136 5997
payment to supplier: removal 3.57 78 428
service: total inventory turnovers 4.68 1248 561
service: total monetary turnovers 6.28 26 753
service: aggregate perf. data 0.88 19851 105
service: refresh index statistics 0.03 321541 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-12-2020 16:33:08 to 05-12-2020 16:33:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4537
TEST_TIME 2 4504
TEST_TIME 3 3779
TEST_TIME 4 4302
TEST_TIME 5 4194
TEST_TIME 6 4465
TEST_TIME 7 4702
TEST_TIME 8 5002
TEST_TIME 9 6168
TEST_TIME 10 6262
TEST_TIME 11 6754
TEST_TIME 12 6970
TEST_TIME 13 7669
TEST_TIME 14 8652
TEST_TIME 15 8645
TEST_TIME 16 8707
TEST_TIME 17 8975
TEST_TIME 18 9588
TEST_TIME 19 10200
TEST_TIME 20 10296
TEST_TIME 21 10575
TEST_TIME 22 10550
TEST_TIME 23 11204
TEST_TIME 24 11133
TEST_TIME 25 10850
TEST_TIME 26 10748
TEST_TIME 27 10385
TEST_TIME 28 10497
TEST_TIME 29 10831
TEST_TIME 30 10785
TEST_TIME 31 10654
TEST_TIME 32 10600
TEST_TIME 33 10561
TEST_TIME 34 10381
TEST_TIME 35 10269
TEST_TIME 36 10133
TEST_TIME 37 9953
TEST_TIME 38 9806
TEST_TIME 39 9785
TEST_TIME 40 9651
TEST_TIME 41 9492
TEST_TIME 42 9461
TEST_TIME 43 9333
TEST_TIME 44 9389
TEST_TIME 45 9293
TEST_TIME 46 9209
TEST_TIME 47 9357
TEST_TIME 48 9286
TEST_TIME 49 9403
TEST_TIME 50 9333
TEST_TIME 51 9402
TEST_TIME 52 9393
TEST_TIME 53 9365
TEST_TIME 54 9480
TEST_TIME 55 9495
TEST_TIME 56 9537
TEST_TIME 57 9544
TEST_TIME 58 9529
TEST_TIME 59 9448
TEST_TIME 60 9392
TEST_TIME 61 9466
TEST_TIME 62 9357
TEST_TIME 63 9367
TEST_TIME 64 9314
TEST_TIME 65 9225
TEST_TIME 66 9240
TEST_TIME 67 9223
TEST_TIME 68 9379
TEST_TIME 69 9311
TEST_TIME 70 9353
TEST_TIME 71 9399
TEST_TIME 72 9415
TEST_TIME 73 9435
TEST_TIME 74 9433
TEST_TIME 75 9397
TEST_TIME 76 9451
TEST_TIME 77 9479
TEST_TIME 78 9502
TEST_TIME 79 9445
TEST_TIME 80 9330
TEST_TIME 81 9344
TEST_TIME 82 9335
TEST_TIME 83 9303
TEST_TIME 84 9362
TEST_TIME 85 9304
TEST_TIME 86 9253
TEST_TIME 87 9243
TEST_TIME 88 9183
TEST_TIME 89 9248
TEST_TIME 90 9231
TEST_TIME 91 9281
TEST_TIME 92 9271
TEST_TIME 93 9306
TEST_TIME 94 9288
TEST_TIME 95 9376
TEST_TIME 96 9384
TEST_TIME 97 9380
TEST_TIME 98 9366
TEST_TIME 99 9421
TEST_TIME 100 9452
TEST_TIME 101 9443
TEST_TIME 102 9426
TEST_TIME 103 9441
TEST_TIME 104 9410
TEST_TIME 105 9378
TEST_TIME 106 9405
TEST_TIME 107 9364
TEST_TIME 108 9332
TEST_TIME 109 9295
TEST_TIME 110 9268
TEST_TIME 111 9234
TEST_TIME 112 9191
TEST_TIME 113 9164
TEST_TIME 114 9232
TEST_TIME 115 9214
TEST_TIME 116 9257
TEST_TIME 117 9239
TEST_TIME 118 9257
TEST_TIME 119 9273
TEST_TIME 120 9234

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-12-2020 16:33:12 to 05-12-2020 16:33:15.

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 1542715 1542715 0 0.00 0 21014 6 0 0
doc_list_biud 1542711 1542711 0 0.00 0 63978 23 0 0
sp_add_invoice_to_stock 5200 5083 117 2.25 30 175900 17089 0 117
sp_cancel_adding_invoice 5605 5605 0 0.00 4 50168 724 0 0
sp_cancel_client_order 1791 1791 0 0.00 4 11352 329 0 0
sp_cancel_customer_reserve 553079 553079 0 0.00 1 63980 50 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 3 4164 68 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 6809 78 0 0
sp_cancel_supplier_invoice 6283 6277 6 0.09 1 21547 690 0 6
sp_cancel_supplier_order 407 407 0 0.00 6 1017088 86322 0 0
sp_cancel_write_off 9131 9131 0 0.00 1 10955 100 0 0
sp_client_order 21024 21024 0 0.00 3 23717 377 0 0
sp_customer_reserve 468629 468629 0 0.00 0 46128 170 0 0
sp_fill_shopping_cart 32222 32222 0 0.00 1 12584 36 0 0
sp_fill_shopping_cart_clo_res 468629 468629 0 0.00 0 19261 14 0 0
sp_get_clo_for_invoice 5083 5083 0 0.00 0 26611 303 0 0
sp_kill_cost_storno 15864 15864 0 0.00 0 9488 49 0 0
sp_kill_qstorno_ret_qs2qd 1121973 1121973 0 0.00 0 63976 27 0 0
sp_kill_qty_storno 591551 591551 0 0.00 0 63978 59 0 0
sp_lock_selected_doc 21141 21141 0 0.00 0 8026 8 0 0
sp_make_cost_storno 28341 28341 0 0.00 0 20246 54 0 0
sp_multiply_rows_for_pdistr 28340 28340 0 0.00 0 17078 26 0 0
sp_multiply_rows_for_qdistr 21024 21024 0 0.00 0 13282 177 0 0
sp_pay_from_customer 7081 7081 0 0.00 4 21512 118 0 0
sp_pay_to_supplier 5997 5997 0 0.00 4 21546 137 0 0
sp_payment_common 13077 13077 0 0.00 1 16192 29 0 0
sp_qd_handle_on_cancel_clo 1791 1791 0 0.00 0 11343 291 0 0
sp_qd_handle_on_invoice_upd_sts 10687 10687 0 0.00 0 29073 309 0 0
sp_qd_handle_on_reserve_upd_sts 10179 10179 0 0.00 0 19544 58 0 0
sp_reserve_write_off 10180 10180 0 0.00 6 19562 177 0 0
sp_supplier_invoice 5631 5631 0 0.00 6 84103 3217 0 0
sp_supplier_order 5587 5587 0 0.00 5 21692 1167 0 0
srv_aggregate_perf_data 105 105 0 0.00 2272 339878 19851 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1176 131625 36021 0 0
srv_find_qd_qs_mism 1060038 1060038 0 0.00 0 15601 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 43 93787 1249 0 0
srv_make_money_saldo 753 753 0 0.00 0 3697 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 222739 419120 321542 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5085 5085 0 0.00 0 9145 134 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 3331 83 0 0
t$perf-norm:sp_cancel_client_order 1791 1791 0 0.00 0 24525 23 0 0
t$perf-norm:sp_cancel_customer_reserve 732 732 0 0.00 0 5434 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 6968 29 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 1513 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 368 6 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 29253 1506 0 0
t$perf-norm:sp_cancel_write_off 1031 1031 0 0.00 0 2704 10 0 0
t$perf-norm:sp_client_order 21024 21024 0 0.00 0 9823 14 0 0
t$perf-norm:sp_customer_reserve 991 991 0 0.00 0 1000 6 0 0
t$perf-norm:sp_pay_from_customer 7081 7081 0 0.00 0 9391 10 0 0
t$perf-norm:sp_pay_to_supplier 5997 5997 0 0.00 0 9427 12 0 0
t$perf-norm:sp_reserve_write_off 10180 10180 0 0.00 0 12052 13 0 0
t$perf-norm:sp_supplier_invoice 5631 5631 0 0.00 0 12821 16 0 0
t$perf-norm:sp_supplier_order 5587 5587 0 0.00 0 7236 14 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 101 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 3017 29 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 982 15 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 677 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10398 10164 234 2.25 0 6255 19 0 234
v_all_customers 37974 37974 0 0.00 0 25 0 0 0
v_all_suppliers 31250 31250 0 0.00 0 34 1 0 0
v_all_wares 42048 42048 0 0.00 0 67 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 5662 25 0 0
v_cancel_client_order 3582 3582 0 0.00 0 5712 10 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 4133 13 0 0
v_cancel_customer_reserve 1464 1464 0 0.00 0 2934 7 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 6457 11 0 0
v_cancel_supplier_invoice 772 760 12 1.55 0 3531 26 0 12
v_cancel_supplier_order 814 814 0 0.00 0 5688 10 0 0
v_cancel_write_off 2062 2062 0 0.00 0 5649 19 0 0
v_max_id_clo_ord 5585 5585 0 0.00 0 2004 2 0 0
v_max_id_clo_res 991 991 0 0.00 0 1416 9 0 0
v_max_id_ord_sup 5613 5613 0 0.00 0 3114 3 0 0
v_max_non_paid_invoice 1569 1569 0 0.00 0 984 3 0 0
v_max_non_paid_realizn 3910 3910 0 0.00 0 7957 5 0 0
v_min_id_clo_ord 5585 5585 0 0.00 0 2182 6 0 0
v_min_id_clo_res 991 991 0 0.00 0 4547 9 0 0
v_min_id_ord_sup 5613 5613 0 0.00 0 4059 7 0 0
v_min_non_paid_invoice 5996 5996 0 0.00 0 16181 17 0 0
v_min_non_paid_realizn 7081 7081 0 0.00 0 10212 18 0 0
v_our_firm 10416 10416 0 0.00 0 249 1 0 0
v_reserve_write_off 20358 20358 0 0.00 0 12540 9 0 0
x_lock_depdocs_on_canc_invoice 11502 11502 0 0.00 0 21415 105 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 22680 385 0 0
x_make_qstorno_1000_1200 5587 5587 0 0.00 2 21636 1090 0 0
x_make_qstorno_1200_2000 5631 5631 0 0.00 2 84000 3093 0 0
x_make_qstorno_2100_3300 468629 468629 0 0.00 0 45496 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-12-2020 16:33:16 to 05-12-2020 16:33:20.

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
14:02:19 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:25 11133 8192000000 10189121552 10490138624 1053851904 11.398 86 61 123 0 1077961952 2766544 21343504
14:02:45 17198 8192000000 10302641536 10619097088 1365249104 14.284 100 83 166 0 1397175632 4391392 27535136
14:03:14 35858 8192000000 10378330208 10701180928 1417202464 14.748 100 86 173 0 1450863040 5748224 27912352
14:03:59 33704 8192000000 10414109712 10741493760 1458614368 15.114 100 88 176 0 1493978048 6999936 28363744
14:04:41 20872 8192000000 10424550096 10756993024 1483596144 15.333 100 88 175 2 1519683360 7745008 28342208
14:05:11 18964 8192000000 10452535616 10785898496 1510292048 15.566 100 92 184 0 1548012608 8297136 29423424
14:05:45 9122 8192000000 10457898384 10792222720 1517642592 15.630 100 88 176 1 1554558272 8945728 27969952
14:06:06 22711 8192000000 10477459584 10817220608 1529622864 15.734 100 86 172 0 1565986176 9354304 27009008
14:06:40 8676 8192000000 10484095696 10831974400 1547499968 15.888 100 76 152 2 1580414896 9811920 23103008
14:07:00 17007 8192000000 10529042768 10885193728 1586932224 16.228 100 73 146 1 1619119280 9649376 22537680
14:07:24 16161 8192000000 10571007792 10927849472 1621647296 16.524 100 73 144 1 1653396784 10095392 21654096
14:07:47 8629 8192000000 10583945392 10946953216 1646732256 16.737 100 75 150 1 1680648240 11046624 22869360
14:08:08 11209 8192000000 10615174608 10976321536 1671774688 16.948 100 88 173 1 1708951328 11792800 25383840
14:08:27 9185 8192000000 10629356336 10996035584 1681995712 17.034 100 80 160 1 1717506976 12414592 23096672
14:08:44 3674 8192000000 10635905120 11004620800 1701222688 17.195 100 80 160 1 1736833888 12601312 23009888
14:08:57 5932 8192000000 10646681344 11016683520 1711373248 17.280 100 84 168 0 1748187472 12599904 24214320
14:09:14 7611 8192000000 10670588288 11041861632 1726243808 17.404 100 84 167 3 1763055264 13159104 23652352
14:09:29 4443 8192000000 10671278704 11047100416 1737422464 17.497 100 72 144 1 1770763248 12671024 20669760
14:09:41 6358 8192000000 10699521984 11079581696 1751017472 17.610 100 77 153 2 1785060384 11311760 22731152
14:09:56 6068 8192000000 10709776720 11087302656 1773582128 17.797 100 81 162 3 1808242688 11649760 23010800
14:10:09 4200 8192000000 10717263264 11102793728 1781430800 17.861 100 72 145 0 1817253088 15396144 20426144
14:10:20 4975 8192000000 10732106272 11115134976 1788065856 17.916 100 77 154 1 1821989040 11685840 22237344
14:10:32 4192 8192000000 10741819872 11125923840 1801089904 18.023 100 80 160 1 1834720512 11620544 22010064
14:10:44 4558 8192000000 10746732992 11130556416 1806614432 18.068 100 82 160 2 1841876352 12863120 22398800
14:10:56 3113 8192000000 10753413344 11140653056 1813075888 18.121 100 86 172 1 1850785024 14071472 23637664
14:11:05 3606 8192000000 10756152528 11138764800 1815583488 18.142 100 90 179 0 1854674464 14227104 24863872
14:11:15 2939 8192000000 10760436368 11144851456 1821260944 18.188 100 93 182 1 1861456256 14475136 25720176
14:11:25 5113 8192000000 10758767056 11146153984 1820345616 18.181 100 81 161 1 1856740896 14551696 21843584
14:11:37 5872 8192000000 10764570416 11152338944 1825832576 18.225 100 79 158 2 1861181168 13078512 22270080
14:11:49 1066 8192000000 10785690416 11173752832 1841474384 18.353 100 87 173 0 1879122624 13381168 24267072
14:11:57 2425 8192000000 10785434112 11172233216 1843883968 18.372 100 87 170 2 1881941568 13279168 24778432
14:12:05 1688 8192000000 10785520848 11176435712 1848274096 18.408 100 90 179 0 1886975824 12668816 26032912
14:12:14 1805 8192000000 10793176272 11179356160 1852697184 18.444 100 85 170 0 1889239808 12282640 24259984
14:12:22 2173 8192000000 10801034960 11185713152 1853720400 18.452 100 91 184 1 1893013696 12280624 27012672
14:12:31 1617 8192000000 10801089776 11190214656 1861155936 18.513 100 89 177 1 1898388544 12458400 24774208
14:12:38 1752 8192000000 10802496736 11195027456 1862458224 18.523 100 89 177 0 1899932912 12261456 25213232
14:12:47 1750 8192000000 10814915856 11203203072 1867779632 18.566 100 89 178 1 1905867008 12945984 25141392
14:12:55 1647 8192000000 10815894400 11205197824 1873723392 18.614 100 92 184 0 1913772160 13896928 26151840
14:13:03 7499 8192000000 10816409152 11208355840 1875672608 18.630 100 84 166 0 1912214800 13068336 23473856
14:13:17 39795 8192000000 10770123136 11202347008 1870417648 18.588 100 33 66 3 1888305248 8671376 9216224
14:14:03 7500 8192000000 10793830768 11211444224 1874844048 18.623 100 34 65 1 1890170368 6512032 8814288
14:14:19 3408 8192000000 10797533616 11214778368 1879273760 18.659 100 44 86 4 1899210784 8064496 11872528
14:14:29 6273 8192000000 10791502976 11219787776 1882608192 18.686 100 27 54 2 1902339232 12311008 7420032
14:14:41 7473 8192000000 10797295424 11227746304 1884812048 18.704 100 23 46 0 1902870080 11266976 6791056
14:15:00 5518 8192000000 10794318160 11226476544 1888466400 18.733 100 26 52 3 1905797696 10309024 7022272
14:15:12 5101 8192000000 10803313104 11228643328 1890874736 18.753 100 33 66 0 1907321168 7655312 8791120
14:15:27 9177 8192000000 10798966576 11234951168 1891061872 18.754 100 20 40 3 1907691024 10904752 5724400
14:15:42 5393 8192000000 10803107776 11229806592 1891277456 18.756 100 21 42 0 1904035696 6704272 6053968
14:15:54 12428 8192000000 10794592720 11232354304 1897334960 18.805 100 25 49 1 1910185232 6004080 6846192
14:16:12 8853 8192000000 10818472592 11244732416 1902114480 18.843 100 29 59 3 1917056560 6762224 8179856
14:16:28 16769 8192000000 10812374352 11245674496 1904056752 18.859 100 17 33 2 1914848544 5724080 5067712
14:16:51 7123 8192000000 10811244640 11247943680 1906423776 18.878 100 22 43 2 1919102736 6705728 5973232
14:17:09 13568 8192000000 10813812288 11250757632 1909724256 18.904 100 16 32 0 1920220800 6372512 4124032
14:17:33 17453 8192000000 10829771152 11258331136 1912972592 18.931 100 27 54 2 1926998880 5697728 8328560
14:18:00 76883 8192000000 10832432720 11269468160 1916206464 18.956 100 21 41 3 1926901088 4854784 5839840
14:19:23 5014 8192000000 10840242816 11273646080 1920990736 18.995 100 32 64 1 1936365312 6886848 8487728
14:19:34 5857 8192000000 10844201056 11277340672 1924012752 19.019 100 33 67 1 1940513552 7079680 9421120
14:19:47 2177 8192000000 10851132576 11281055744 1927725056 19.049 100 46 92 3 1948326512 7481600 13119856
14:19:56 5903 8192000000 10827918144 11263524864 1906640032 18.880 99 30 60 3 1921870192 6702512 8527648
14:20:09 5874 8192000000 10837296656 11276660736 1918036832 18.971 100 16 32 2 1928393424 6079824 4276768
14:20:23 6475 8192000000 10837120240 11271999488 1920689696 18.992 100 26 52 2 1933819504 5468912 7660896
14:20:37 6798 8192000000 10825894048 11264172032 1908994960 18.899 100 15 30 1 1918420672 5129360 4296352
14:20:50 6505 8192000000 10830620192 11263287296 1894885712 18.785 99 22 44 1 1907126128 5758704 6481712
14:21:05 12049 8192000000 10825422624 11261689856 1906188448 18.876 100 18 36 5 1916517872 5125120 5204304
14:21:24 12827 8192000000 10780601472 11212685312 1824633280 18.216 96 15 28 1 1834123600 5120208 4370112
14:21:43 7969 8192000000 10778553696 11210403840 1834457184 18.296 98 16 32 1 1844841968 5456848 4927936
14:21:57 10384 8192000000 10781668880 11203645440 1819535344 18.174 97 27 54 2 1833282624 6437008 7310272
14:22:14 3893 8192000000 10776083712 11206688768 1846202432 18.391 99 24 46 4 1858988960 6018384 6768144
14:22:24 9729 8192000000 10775179312 11199516672 1805484576 18.059 97 21 43 3 1817960720 6316416 6159728
14:22:40 14977 8192000000 10752832064 11184693248 1785072560 17.891 96 21 42 0 1796695152 5147088 6475504
14:23:02 9937 8192000000 10738502160 11164938240 1771224960 17.777 96 39 78 2 1788091728 5462736 11404032
14:23:19 66028 8192000000 10728571856 11139719168 1653125440 16.791 90 34 67 1 1667535312 4453456 9956416
14:24:33 15927 8192000000 10683779904 11106643968 1683506480 17.047 93 14 28 1 1692783600 5097616 4179504
14:24:56 9539 8192000000 10709377488 11108589568 1702363040 17.205 95 43 86 1 1725611632 10785536 12463056
14:25:13 4470 8192000000 10712675936 11126423552 1772104960 17.784 99 29 58 2 1786777680 6060336 8612384
14:25:27 8885 8192000000 10700622928 11117015040 1732468544 17.456 96 30 59 2 1746892320 5968176 8455600
14:25:43 5277 8192000000 10737754592 11154350080 1805863104 18.062 100 22 44 1 1822092288 9854128 6375056
14:25:55 7418 8192000000 10715508704 11137884160 1794508352 17.969 99 23 46 2 1806859984 5442576 6909056
14:26:10 5680 8192000000 10729087024 11145449472 1811339872 18.107 100 28 54 2 1824767296 5962928 7464496
14:26:22 6586 8192000000 10729053872 11153092608 1801140768 18.023 99 17 34 1 1812023392 5385760 5496864
14:26:36 10136 8192000000 10744582448 11168346112 1806238096 18.065 99 15 30 2 1816201888 5303744 4660048
14:26:53 12142 8192000000 10758618256 11181342720 1821717984 18.192 99 32 63 0 1836439792 4956752 9765056
14:27:11 8671 8192000000 10748314768 11170349056 1823162384 18.204 99 20 40 1 1835229536 5111472 6955680
14:27:30 11557 8192000000 10766697584 11190767616 1843479152 18.369 100 25 50 0 1856337328 5400736 7457440
14:27:47 10162 8192000000 10761157024 11194351616 1852659488 18.444 100 24 45 2 1865219232 5451216 7108528
14:28:06 14370 8192000000 10780100880 11198713856 1856667232 18.476 100 25 50 0 1869328176 5330832 7330112
14:28:29 59747 8192000000 10804345728 11208425472 1861544304 18.516 100 47 91 0 1880965440 5796944 13624192
14:29:35 18421 8192000000 10769375360 11207364608 1859795568 18.502 100 22 43 2 1876133728 10578672 5759488
14:30:01 6297 8192000000 10771403632 11205963776 1862981680 18.527 100 21 42 2 1874003088 5044048 5977360
14:30:16 8612 8192000000 10774924768 11206356992 1864552608 18.540 100 26 52 3 1878746576 6853952 7340016
14:30:32 5287 8192000000 10787257680 11211440128 1867283152 18.562 100 32 64 0 1883146208 6516880 9346176
14:30:46 5924 8192000000 10802722816 11224248320 1868577792 18.573 100 32 64 2 1884217456 5591520 10048144
14:31:02 10213 8192000000 10782853696 11218423808 1869827712 18.583 100 21 42 2 1881186496 4954032 6404752
14:31:19 12475 8192000000 10786789536 11220152320 1871584016 18.597 100 15 29 2 1881210096 4936656 4689424
14:31:38 7610 8192000000 10783380560 11222126592 1874748064 18.623 100 18 37 0 1885259584 5459776 5051744
14:31:54 10396 8192000000 10794683584 11223265280 1877737200 18.647 100 19 38 2 1887917424 5435776 4744448
14:32:10 22331 8192000000 10836700176 11251429376 1895922576 18.793 100 26 52 1 1913204640 9102768 8179296
14:32:43 11203 8192000000 10841708320 11253542912 1905581712 18.871 100 58 115 0 1929530512 7176800 16772000
14:33:03 9464 8192000000 10837030704 11249479680 1893680656 18.775 99 56 110 4 1918367040 8330736 16355648
14:33:20 25975 8192000000 10849354400 11271602176 1915885200 18.954 100 43 86 1 1939425328 11579456 11960672
14:33:53 47508 8192000000 10855009488 11284230144 1930532592 19.071 100 34 68 1 1954067248 13030592 10504064
14:34:48 15495 8192000000 10871932400 11297206272 1937838048 19.130 100 39 78 1 1963366832 13592960 11935824
14:35:12 80663 8192000000 10884723264 11314741248 1942414848 19.166 100 45 89 1 1972326928 16334432 13577648
14:36:46 17768 8192000000 10882983376 11324321792 1952252720 19.244 100 23 46 1 1974335696 15316496 6766480
14:37:13 9127 8192000000 10884458912 11317911552 1951274640 19.237 100 36 71 0 1976958448 15089408 10594400
14:37:33 10032 8192000000 10895614784 11324239872 1940642592 19.152 99 43 86 0 1969335824 15703728 12989504
14:37:54 23139 8192000000 10899592112 11335659520 1958890912 19.297 100 50 100 1 1992774384 18815088 15068384
14:38:24 34211 8192000000 10914333312 11348815872 1969464736 19.381 100 47 94 0 2006416400 22970288 13981376
14:39:13 12197 8192000000 10911871600 11350491136 1959579616 19.303 99 46 92 1 1996100832 22262672 14258544
14:39:34 16529 8192000000 10931212288 11359514624 1973338688 19.412 100 47 94 1 2014862256 27250032 14273536
14:39:59 9854 8192000000 10931801472 11365388288 1982384864 19.484 100 46 92 1 2021596544 24857904 14353776
14:40:19 6433 8192000000 10938922368 11370901504 1987471344 19.524 100 52 104 2 2028936336 25213088 16251904
14:40:32 8810 8192000000 10940148544 11366436864 1980867120 19.472 100 57 114 4 2025330720 27527856 16935744
14:40:48 5579 8192000000 10932094752 11359576064 1971608448 19.398 100 55 109 0 2016768800 28736848 16423504
14:41:00 3632 8192000000 10921920352 11339018240 1954183712 19.260 99 69 137 1 2004361616 29837744 20340160
14:41:11 7991 8192000000 10936751264 11357425664 1955970032 19.274 99 68 135 0 2006185344 29724720 20490592
14:41:27 9486 8192000000 10917466160 11347931136 1966119936 19.355 100 59 118 1 2010938272 26785344 18032992
14:41:54 15367 8192000000 10921247088 11359825920 1974300336 19.420 100 51 100 4 2014131712 25087008 14744368
14:42:18 3400 8192000000 10941745568 11371081728 1988692736 19.533 100 64 129 1 2031912960 24252976 18967248
14:42:30 4511 8192000000 10947678656 11371749376 1973194592 19.411 99 64 128 0 2019776752 27232512 19349648
14:42:42 2898 8192000000 10954936272 11369697280 1972335872 19.404 99 77 151 2 2022124848 27931920 21857056
14:42:51 2498 8192000000 10966005472 11381329920 1993979136 19.575 100 87 170 3 2050078512 30247968 25851408
14:43:01 3782 8192000000 10952976576 11371749376 1968741392 19.375 99 77 154 0 2023217552 31427360 23048800
14:43:12 5590 8192000000 10959962864 11377532928 1983869408 19.495 100 82 164 2 2039667536 31484272 24313856
14:43:24 2483 8192000000 10951161072 11370520576 1968691888 19.375 99 83 166 1 2026416064 33276528 24447648
14:43:34 2333 8192000000 10955713264 11364474880 1963120240 19.331 99 88 176 1 2023830944 34010368 26700336
14:43:43 1174 8192000000 10944149568 11353145344 1968761648 19.376 100 93 185 3 2029378432 34073344 26543440
14:43:52 3800 8192000000 10935271440 11344867328 1946769248 19.201 99 78 156 2 2004338336 32917840 24651248
14:44:06 4237 8192000000 10912880336 11334737920 1942255968 19.165 99 64 125 0 1994293248 32158864 19878416
14:44:18 5274 8192000000 10942873360 11361583104 1967827952 19.368 100 78 154 4 2027200048 35389984 23982112
14:44:30 3104 8192000000 10956761136 11366236160 1972497200 19.405 100 88 177 0 2036229856 36827584 26905072
14:44:43 1840 8192000000 10936608224 11346731008 1949054464 19.219 99 89 178 2 2013198992 37309120 26835408
14:44:51 2605 8192000000 10944034288 11358502912 1964023760 19.338 100 73 145 0 2024567728 38408240 22135728
14:45:02 6125 8192000000 10947288400 11364962304 1965638336 19.351 100 73 146 1 2028409072 40225728 22545008
14:45:22 10195 8192000000 10927521088 11356545024 1955765408 19.272 100 61 122 3 2016251808 40645360 19841040
14:45:39 8292 8192000000 10927848208 11353006080 1961926976 19.321 100 61 122 0 2012193328 30961888 19304464
14:45:56 2661 8192000000 10942403248 11357405184 1949257792 19.221 99 72 143 1 2003762832 32364432 22140608
14:46:05 3699 8192000000 10948398864 11358896128 1968184048 19.371 100 93 187 5 2027700928 31304016 28212864
14:46:16 3676 8192000000 10918724544 11331649536 1943423008 19.174 100 86 169 2 1999209328 31328816 24457504
14:46:32 8504 8192000000 10910654336 11343220736 1951147472 19.236 100 50 100 2 1998193392 31776272 15269648
14:47:15 23014 8192000000 10914961056 11351556096 1960022800 19.306 100 33 65 1 2000198320 29741168 10434352
14:47:46 4915 8192000000 10916430976 11331481600 1931579232 19.080 99 71 140 3 1983046288 28959120 22507936
14:47:58 5527 8192000000 10926679248 11351326720 1955481056 19.270 100 65 130 0 2006528544 30508896 20538592
14:48:11 3842 8192000000 10915546416 11328040960 1929466688 19.063 98 83 164 0 1988718320 34275872 24975760
14:48:23 2118 8192000000 10946232832 11364319232 1969168896 19.379 100 82 162 0 2029986176 35752800 25064480
14:48:32 3463 8192000000 10937662992 11360178176 1963192976 19.331 100 78 155 2 2024138096 36971520 23973600
14:48:41 1483 8192000000 10943101392 11356119040 1958503072 19.294 100 84 168 0 2022665744 38481280 25681392
14:48:55 12421 8192000000 10920768560 11365335040 1956257920 19.276 100 40 80 2 2011771504 42798496 12715088
14:49:24 7870 8192000000 10913300192 11346182144 1946234144 19.196 100 44 89 2 1994278592 33449104 14595344
14:49:40 12321 8192000000 10913441872 11351584768 1932140256 19.084 99 40 79 0 1981333808 36201952 12991600
14:50:00 13713 8192000000 10919066416 11353661440 1932388976 19.086 99 46 92 2 1989004192 40438032 16177184
14:50:24 17122 8192000000 10920121488 11365720064 1955228032 19.268 100 38 76 1 2009363328 41313616 12821680
14:50:52 9603 8192000000 10907161744 11347972096 1937028544 19.123 99 33 66 1 1985210976 37013408 11169024
14:51:09 7059 8192000000 10934003584 11366277120 1958909392 19.297 100 48 96 1 2012607920 38139088 15559440
14:51:28 17612 8192000000 10894203344 11346866176 1921845936 19.002 98 36 72 1 1971957248 38566880 11544432
14:52:15 15611 8192000000 10875136624 11323559936 1924707872 19.025 100 31 61 0 1964327392 30239344 9380176
14:52:37 28049 8192000000 10882047040 11338166272 1922778480 19.009 99 22 44 1 1958276672 28005328 7492864
14:53:11 10453 8192000000 10891941408 11344314368 1938485200 19.135 100 23 46 1 1973779328 27606672 7687456
14:53:41 15439 8192000000 10892952608 11349647360 1941908384 19.162 100 14 28 1 1971154304 24606144 4639776
14:54:30 26487 8192000000 10904916544 11362693120 1945047104 19.187 100 17 34 1 1981896960 31037632 5812224
14:55:45 29242 8192000000 10873083216 11337568256 1904167584 18.860 98 13 26 2 1940301728 31916240 4217904
14:56:24 11871 8192000000 10883215568 11338141696 1939957184 19.146 100 21 42 1 1967859312 21278352 6623776
14:56:58 16388 8192000000 10890617232 11342553088 1939982768 19.147 100 29 58 0 1973686464 24914464 8789232
14:57:28 100572 8192000000 10881183568 11350601728 1927266976 19.045 99 20 40 3 1960651232 27526720 5857536
15:00:22 35508 8192000000 10874275952 11338526720 1900083664 18.827 98 15 30 1 1946458112 41447552 4926896
15:01:07 30945 8192000000 10872422736 11326709760 1923911296 19.018 99 33 66 0 1964745952 31230784 9603872
15:01:55 63329 8192000000 10886645584 11345620992 1949291680 19.221 100 15 31 0 1971933392 18578704 4063008
15:03:11 106998 8192000000 10854540160 11317911552 1843490368 18.369 94 16 30 1 1860487472 13047968 3949136
15:05:05 66063 8192000000 10877802624 11334037504 1945865664 19.194 100 17 34 1 1963944832 13928528 4150640
15:06:34 74110 8192000000 10884260720 11346563072 1959186192 19.300 100 15 31 2 1971808752 8197584 4424976
15:08:10 93207 8192000000 10880036560 11343925248 1948024896 19.211 99 7 14 0 1956646896 6973088 1648912
15:09:55 17293 8192000000 10915657392 11353313280 1959283760 19.300 99 62 123 1 1983937472 5723376 18930336
15:10:18 36274 8192000000 10926670896 11363315712 1972822736 19.408 100 28 55 2 1990126272 9765616 7537920
15:11:03 79588 8192000000 10891652368 11371102208 1978140976 19.450 100 18 37 0 1991473040 8181520 5150544
15:14:05 63220 8192000000 10910515296 11384766464 1987989664 19.528 100 13 26 1 2006067232 14160304 3917264
15:15:14 68852 8192000000 10911171168 11397132288 1994068688 19.576 100 24 48 1 2019265792 17491728 7705376
15:16:56 24583 8192000000 10917013296 11389304832 1995561488 19.588 100 22 45 1 2015572832 13418688 6592656
15:17:27 71454 8192000000 10907092176 11385982976 1958854624 19.297 98 20 41 1 1978235664 13824992 5556048
15:18:44 73266 8192000000 10911052512 11393839104 1987386432 19.523 100 3 6 0 2002030976 14095904 548640
15:20:04 59280 8192000000 10901779008 11378405376 1935153040 19.108 97 10 20 1 1951566672 13747328 2666304
15:21:28 54881 8192000000 10931427216 11382480896 1994373328 19.578 100 37 73 1 2014375184 9012656 10989200
15:22:33 69210 8192000000 10910522800 11386720256 1963517792 19.334 98 19 38 2 1978509840 9696144 5295904
15:23:51 55266 8192000000 10901639328 11369230336 1948488288 19.214 98 18 36 4 1964234560 10594512 5151760
15:24:56 37383 8192000000 10910686800 11358842880 1933029376 19.091 97 33 66 0 1954544048 12094064 9420608
15:25:48 21768 8192000000 10913827392 11369033728 1966751088 19.360 99 47 94 4 1991004992 10704400 13549504
15:26:21 63881 8192000000 10892563312 11357663232 1917814640 18.969 97 22 44 0 1935890496 12034032 6041824
15:27:31 59664 8192000000 10892582864 11354058752 1894051664 18.778 96 21 42 0 1909142400 9282160 5808576
15:28:38 73233 8192000000 10898324192 11352743936 1908977456 18.898 97 18 36 1 1928046720 13793248 5276016
15:29:57 35174 8192000000 10888853424 11336876032 1888369376 18.733 96 36 72 2 1906598320 7932016 10296928
15:30:41 131625 8192000000 10872371472 11328581632 1877838096 18.648 96 31 62 0 1896914720 10205888 8870736
15:33:42 49157 8192000000 10860639440 11334782976 1920340784 18.990 99 14 27 0 1942203440 17960560 3902096
15:35:01 52947 8192000000 10854181280 11324219392 1912205568 18.924 98 14 28 0 1923205328 6925552 4074208
15:36:00 44489 8192000000 10854029248 11325624320 1919524544 18.983 99 12 24 0 1932726128 9843504 3358080
15:36:56 54551 8192000000 10855481248 11317415936 1878215744 18.651 97 12 24 1 1890706624 9314688 3176192
15:37:57 50998 8192000000 10847367136 11314024448 1861049520 18.512 96 21 42 1 1885580608 18965744 5565344
15:39:11 88735 8192000000 10851322464 11336876032 1871225488 18.594 97 15 30 0 1896097104 20522000 4349616
15:40:58 53547 8192000000 10864576368 11313975296 1881342448 18.676 97 26 52 1 1898638432 10350912 6945072
15:41:58 42495 8192000000 10878394800 11333255168 1922210288 19.005 99 34 69 1 1942934288 10707392 10016608
15:43:16 105783 8192000000 10871041216 11323371520 1854575008 18.459 95 13 26 0 1871616416 13092736 3948672
15:45:08 23172 8192000000 10866841552 11316682752 1903133008 18.851 98 20 40 0 1920456384 11390672 5932704
15:45:46 25950 8192000000 10860584000 11313512448 1926799344 19.041 100 27 53 0 1944803488 10800512 7203632
15:46:18 14688 8192000000 10879280720 11324588032 1921094464 18.996 99 41 82 1 1941774944 9531184 11149296
15:46:42 29113 8192000000 10869803488 11325915136 1901699888 18.840 98 34 68 0 1923753952 12609184 9444880
15:47:20 24416 8192000000 10876547808 11321479168 1887245328 18.724 97 34 68 1 1906681856 10179008 9257520
15:47:52 45550 8192000000 10869195408 11331579904 1901718720 18.840 98 34 67 1 1923107248 11545792 9842736
15:48:51 53985 8192000000 10875601152 11333500928 1911099840 18.915 98 35 70 1 1931267744 10766320 9401584
15:49:57 67290 8192000000 10869254064 11333263360 1898086848 18.811 98 11 22 0 1911571632 10225744 3259040
15:51:14 113749 8192000000 10891883504 11341213696 1948832832 19.217 100 40 79 2 1969900688 9400640 11667216
15:53:15 66507 8192000000 10879233200 11338780672 1941705728 19.160 99 26 52 0 1959603008 10422352 7474928
15:54:37 28948 8192000000 10889501344 11357257728 1964283184 19.340 100 23 46 2 1982833424 11992032 6558208
15:55:12 47380 8192000000 10876644048 11347693568 1956299760 19.277 100 13 26 0 1972018256 11673232 4045264
15:57:33 57097 8192000000 10870698368 11346624512 1942717328 19.168 99 12 24 2 1954625936 9069536 2839072
15:58:37 63900 8192000000 10899961584 11372830720 1974650592 19.422 100 15 31 1 1990813696 11540032 4623072
16:00:18 64852 8192000000 10912051200 11384311808 1965730320 19.352 99 14 29 0 1986209264 16067872 4411072
16:01:29 41459 8192000000 10905245280 11375919104 1939625296 19.144 98 15 30 0 1961541200 17375472 4540432
16:02:17 86002 8192000000 10899770608 11372216320 1945592336 19.191 98 26 52 2 1967992688 14793296 7607056
16:03:49 50645 8192000000 10913875408 11374145536 1942796928 19.169 98 15 30 0 1955894576 8888944 4208704
16:05:03 85540 8192000000 10926405552 11396202496 1959352784 19.301 98 13 26 1 1976578880 13875248 3350848
16:06:53 93583 8192000000 10921551680 11389046784 1958158768 19.291 98 13 25 1 1974620768 13032688 3429312
16:08:38 75691 8192000000 10927709904 11388424192 1953322784 19.253 98 25 48 1 1969775824 10099952 6353088
16:10:02 29628 8192000000 10941224048 11394584576 1994958256 19.583 100 27 54 1 2016893472 14145072 7790144
16:10:38 69796 8192000000 10940082752 11395743744 1958876128 19.297 98 27 54 2 1982405536 15443392 8086016
16:11:59 44675 8192000000 10922728528 11390058496 1953408496 19.254 98 24 48 1 1972458832 12697664 6352672
16:12:58 87810 8192000000 10900412016 11366146048 1928816384 19.057 97 27 54 3 1949128864 12909456 7403024
16:14:32 27682 8192000000 10878135616 11325751296 1843303248 18.368 93 19 37 2 1854275040 5941488 5030304
16:15:06 23165 8192000000 10898787776 11342901248 1936337280 19.118 99 41 82 1 1956189168 8880416 10971472
16:15:36 12326 8192000000 10882322240 11331039232 1922098688 19.004 98 33 66 0 1941123856 10049328 8975840
16:16:03 32443 8192000000 10889875840 11350409216 1952010032 19.242 100 29 57 0 1970832080 11158784 7663264
16:16:47 115598 8192000000 10886168288 11353518080 1907163552 18.884 97 23 46 1 1920666816 7346240 6157024
16:19:00 55970 8192000000 10884012224 11365445632 1946127600 19.196 99 21 42 0 1971685712 19985440 5572672
16:20:05 20326 8192000000 10870288192 11343527936 1939182080 19.140 99 10 20 1 1953871232 12295136 2394016
16:20:36 37857 8192000000 10883791344 11346776064 1940977456 19.155 99 12 24 0 1949546832 5031120 3538256
16:21:21 72969 8192000000 10873583760 11339808768 1891791120 18.760 96 18 36 0 1905898784 8910912 5196752
16:23:06 86788 8192000000 10871166608 11337965568 1915003312 18.947 98 8 16 1 1926992384 9578480 2410592
16:25:10 72877 8192000000 10864287312 11348062208 1893606032 18.775 97 11 22 2 1912685360 15623744 3455584
16:26:29 34575 8192000000 10825802592 11294355456 1843780704 18.372 96 13 26 0 1854347648 7007888 3559056
16:27:10 19322 8192000000 10840353936 11293302784 1910066768 18.907 100 29 58 2 1927192544 7547168 9578608
16:27:36 39061 8192000000 10857059520 11316142080 1907111280 18.883 99 26 50 3 1923274208 9491616 6671312
16:28:21 54299 8192000000 10864181024 11321683968 1894358320 18.781 98 19 38 1 1914959024 14828816 5771888
16:29:22 46847 8192000000 10865872304 11328757760 1906792688 18.881 98 30 60 2 1924197392 9337920 8066784
16:30:16 91942 8192000000 10872317088 11338350592 1882687152 18.687 97 18 37 0 1904038304 15850640 5500512
16:32:01 22931 8192000000 9625802272 9950003200 752169424 8.409 39 3 4 0 756405296 3733792 502080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-12-2020 16:33:22 to 05-12-2020 16:33:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 05-12-2020 16:33:53 to 05-12-2020 16:33:54.

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          247038
MON$OLDEST_ACTIVE               247039
MON$OLDEST_SNAPSHOT             247039
MON$NEXT_TRANSACTION            247039
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                       2006208
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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'

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