Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.04.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 17403612 kB
MemAvailable 31416004 kB
Buffers 0 kB
Cached 14241432 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-04-04 19:27:27
DTS_END                         2021-04-04 19:27:27.6660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34448
TRN_ID                          241271
ATT_ID                          658
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: 9086.38 21365 1090366
customer order: creation 171.72 325 20606
customer order: refuse 14.31 336 1717
order to supplier: creation 45.23 1126 5427
order to supplier: removal 3.73 83729 447
invoice (draft): creation 44.82 3339 5378
invoice (draft): removal 50.92 696 6110
invoice accept: apply 42.65 18044 5118
invoice accept: cancel 46.36 896 5563
customer reserve: creation 3825.28 184 459034
customer reserve: removal 4552.23 54 546268
realization accept: apply 83.10 191 9972
realization accept: cancel 78.26 109 9391
payment from customer: creation 59.00 127 7080
payment from customer: removal 5.45 91 654
payment to supplier: creation 48.12 138 5774
payment to supplier: removal 3.48 101 418
service: total inventory turnovers 4.68 895 561
service: total monetary turnovers 6.18 37 741
service: aggregate perf. data 0.86 19441 103
service: refresh index statistics 0.03 297446 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2021 19:28:41 to 04-04-2021 19:28:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3217
TEST_TIME 2 3963
TEST_TIME 3 3530
TEST_TIME 4 4043
TEST_TIME 5 4269
TEST_TIME 6 4708
TEST_TIME 7 5097
TEST_TIME 8 5356
TEST_TIME 9 5422
TEST_TIME 10 5525
TEST_TIME 11 5602
TEST_TIME 12 6018
TEST_TIME 13 5996
TEST_TIME 14 5991
TEST_TIME 15 6483
TEST_TIME 16 6925
TEST_TIME 17 7016
TEST_TIME 18 7255
TEST_TIME 19 7681
TEST_TIME 20 8293
TEST_TIME 21 8577
TEST_TIME 22 8609
TEST_TIME 23 9018
TEST_TIME 24 8991
TEST_TIME 25 9261
TEST_TIME 26 9579
TEST_TIME 27 10152
TEST_TIME 28 10105
TEST_TIME 29 9976
TEST_TIME 30 9916
TEST_TIME 31 9757
TEST_TIME 32 9874
TEST_TIME 33 9756
TEST_TIME 34 9723
TEST_TIME 35 9583
TEST_TIME 36 9551
TEST_TIME 37 9455
TEST_TIME 38 9459
TEST_TIME 39 9474
TEST_TIME 40 9584
TEST_TIME 41 9540
TEST_TIME 42 9404
TEST_TIME 43 9392
TEST_TIME 44 9295
TEST_TIME 45 9301
TEST_TIME 46 9278
TEST_TIME 47 9169
TEST_TIME 48 9167
TEST_TIME 49 9211
TEST_TIME 50 9183
TEST_TIME 51 9195
TEST_TIME 52 9257
TEST_TIME 53 9262
TEST_TIME 54 9288
TEST_TIME 55 9281
TEST_TIME 56 9325
TEST_TIME 57 9341
TEST_TIME 58 9450
TEST_TIME 59 9412
TEST_TIME 60 9522
TEST_TIME 61 9533
TEST_TIME 62 9566
TEST_TIME 63 9429
TEST_TIME 64 9377
TEST_TIME 65 9347
TEST_TIME 66 9380
TEST_TIME 67 9327
TEST_TIME 68 9326
TEST_TIME 69 9289
TEST_TIME 70 9228
TEST_TIME 71 9194
TEST_TIME 72 9117
TEST_TIME 73 9111
TEST_TIME 74 9070
TEST_TIME 75 9180
TEST_TIME 76 9235
TEST_TIME 77 9202
TEST_TIME 78 9197
TEST_TIME 79 9202
TEST_TIME 80 9142
TEST_TIME 81 9329
TEST_TIME 82 9408
TEST_TIME 83 9390
TEST_TIME 84 9395
TEST_TIME 85 9416
TEST_TIME 86 9424
TEST_TIME 87 9488
TEST_TIME 88 9436
TEST_TIME 89 9355
TEST_TIME 90 9309
TEST_TIME 91 9279
TEST_TIME 92 9215
TEST_TIME 93 9212
TEST_TIME 94 9183
TEST_TIME 95 9160
TEST_TIME 96 9177
TEST_TIME 97 9150
TEST_TIME 98 9220
TEST_TIME 99 9167
TEST_TIME 100 9231
TEST_TIME 101 9219
TEST_TIME 102 9216
TEST_TIME 103 9193
TEST_TIME 104 9187
TEST_TIME 105 9252
TEST_TIME 106 9305
TEST_TIME 107 9278
TEST_TIME 108 9281
TEST_TIME 109 9320
TEST_TIME 110 9261
TEST_TIME 111 9236
TEST_TIME 112 9190
TEST_TIME 113 9182
TEST_TIME 114 9135
TEST_TIME 115 9158
TEST_TIME 116 9113
TEST_TIME 117 9103
TEST_TIME 118 9114
TEST_TIME 119 9139
TEST_TIME 120 9087

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2021 19:28:44 to 04-04-2021 19:28:48.

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 1515824 1515824 0 0.00 0 18731 6 0 0
doc_list_biud 1515824 1515824 0 0.00 0 31265 25 0 0
sp_add_invoice_to_stock 5228 5118 110 2.10 26 208281 18044 0 110
sp_cancel_adding_invoice 5563 5563 0 0.00 6 107066 897 0 0
sp_cancel_client_order 1717 1717 0 0.00 4 8384 337 0 0
sp_cancel_customer_reserve 546268 546268 0 0.00 1 31267 55 0 0
sp_cancel_pay_from_customer 654 654 0 0.00 3 6658 91 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 7235 101 0 0
sp_cancel_supplier_invoice 6118 6110 8 0.13 1 18675 697 0 8
sp_cancel_supplier_order 447 447 0 0.00 6 866966 83730 0 0
sp_cancel_write_off 9391 9391 0 0.00 1 24555 110 0 0
sp_client_order 20606 20606 0 0.00 3 19022 326 0 0
sp_customer_reserve 459034 459034 0 0.00 0 44599 184 0 0
sp_fill_shopping_cart 31410 31410 0 0.00 1 41355 37 0 0
sp_fill_shopping_cart_clo_res 459034 459034 0 0.00 0 19322 14 0 0
sp_get_clo_for_invoice 5117 5117 0 0.00 0 18812 308 0 0
sp_kill_cost_storno 16026 16026 0 0.00 0 18727 57 0 0
sp_kill_qstorno_ret_qs2qd 1108484 1108484 0 0.00 0 31247 29 0 0
sp_kill_qty_storno 584585 584585 0 0.00 0 31265 64 0 0
sp_lock_selected_doc 20813 20813 0 0.00 0 7024 6 0 0
sp_make_cost_storno 27943 27943 0 0.00 0 18321 53 0 0
sp_multiply_rows_for_pdistr 27943 27943 0 0.00 0 18396 32 0 0
sp_multiply_rows_for_qdistr 20606 20606 0 0.00 0 11604 148 0 0
sp_pay_from_customer 7080 7080 0 0.00 4 18956 127 0 0
sp_pay_to_supplier 5774 5774 0 0.00 5 17811 139 0 0
sp_payment_common 12854 12854 0 0.00 1 18193 38 0 0
sp_qd_handle_on_cancel_clo 1717 1717 0 0.00 0 8363 314 0 0
sp_qd_handle_on_invoice_upd_sts 10680 10680 0 0.00 0 24640 336 0 0
sp_qd_handle_on_reserve_upd_sts 9972 9972 0 0.00 0 10223 54 0 0
sp_reserve_write_off 9972 9972 0 0.00 6 19080 192 0 0
sp_supplier_invoice 5378 5378 0 0.00 7 103731 3340 0 0
sp_supplier_order 5427 5427 0 0.00 5 31461 1127 0 0
srv_aggregate_perf_data 103 103 0 0.00 2724 316941 19442 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1354 149269 31688 0 0
srv_find_qd_qs_mism 1043242 1043242 0 0.00 0 10518 6 0 0
srv_make_invnt_saldo 561 561 0 0.00 34 36824 895 0 0
srv_make_money_saldo 741 741 0 0.00 1 9072 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 222661 404760 297447 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5118 5118 0 0.00 0 10864 163 0 0
t$perf-norm:sp_cancel_adding_invoice 437 437 0 0.00 0 5581 127 0 0
t$perf-norm:sp_cancel_client_order 1717 1717 0 0.00 0 4338 16 0 0
t$perf-norm:sp_cancel_customer_reserve 636 636 0 0.00 0 3045 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 654 654 0 0.00 0 1684 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 871 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 443 12 0 0
t$perf-norm:sp_cancel_supplier_order 447 447 0 0.00 0 18538 1465 0 0
t$perf-norm:sp_cancel_write_off 1042 1042 0 0.00 0 1575 6 0 0
t$perf-norm:sp_client_order 20606 20606 0 0.00 0 8665 20 0 0
t$perf-norm:sp_customer_reserve 1083 1083 0 0.00 0 4040 9 0 0
t$perf-norm:sp_pay_from_customer 7080 7080 0 0.00 0 5239 11 0 0
t$perf-norm:sp_pay_to_supplier 5774 5774 0 0.00 0 7388 15 0 0
t$perf-norm:sp_reserve_write_off 9972 9972 0 0.00 0 7918 16 0 0
t$perf-norm:sp_supplier_invoice 5378 5378 0 0.00 0 8970 24 0 0
t$perf-norm:sp_supplier_order 5427 5427 0 0.00 0 4216 14 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 632 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 784 11 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 6093 35 0 0
t$perf-norm:srv_make_money_saldo 741 741 0 0.00 0 950 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 4 0 0
v_add_invoice_to_stock 10454 10234 220 2.10 0 18875 23 0 220
v_all_customers 37738 37738 0 0.00 0 22 1 0 0
v_all_suppliers 29448 29448 0 0.00 0 44 1 0 0
v_all_wares 41212 41212 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 874 874 0 0.00 0 708 6 0 0
v_cancel_client_order 3434 3434 0 0.00 0 2895 5 0 0
v_cancel_customer_prepayment 1308 1308 0 0.00 0 6603 13 0 0
v_cancel_customer_reserve 1272 1272 0 0.00 0 1111 5 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 1180 7 0 0
v_cancel_supplier_invoice 764 748 16 2.09 0 1697 20 0 16
v_cancel_supplier_order 894 894 0 0.00 0 4539 11 0 0
v_cancel_write_off 2084 2084 0 0.00 0 11438 22 0 0
v_max_id_clo_ord 5427 5427 0 0.00 0 3939 2 0 0
v_max_id_clo_res 1083 1083 0 0.00 0 2485 12 0 0
v_max_id_ord_sup 5377 5377 0 0.00 0 8699 4 0 0
v_max_non_paid_invoice 1854 1854 0 0.00 0 1724 4 0 0
v_max_non_paid_realizn 3776 3776 0 0.00 0 9912 7 0 0
v_min_id_clo_ord 5427 5427 0 0.00 0 4830 6 0 0
v_min_id_clo_res 1083 1083 0 0.00 0 9510 20 0 0
v_min_id_ord_sup 5377 5377 0 0.00 0 4494 5 0 0
v_min_non_paid_invoice 5774 5774 0 0.00 0 17588 23 0 0
v_min_non_paid_realizn 7080 7080 0 0.00 0 18186 27 0 0
v_our_firm 10082 10082 0 0.00 0 40 1 0 0
v_reserve_write_off 19942 19942 0 0.00 0 18927 11 0 0
x_lock_depdocs_on_canc_invoice 11299 11299 0 0.00 0 15595 114 0 0
x_lock_depdocs_on_canc_sup_ord 447 447 0 0.00 0 33374 414 0 0
x_make_qstorno_1000_1200 5427 5427 0 0.00 1 31455 1049 0 0
x_make_qstorno_1200_2000 5378 5378 0 0.00 3 103623 3206 0 0
x_make_qstorno_2100_3300 459034 459034 0 0.00 0 43730 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2021 19:28:49 to 04-04-2021 19:28:53.

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:31 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:37 14625 8192000000 10245075408 10549514240 1074337568 11.593 84 64 128 0 1098579056 3163584 21077904
16:57:59 27991 8192000000 10346975808 10664407040 1394860624 14.549 100 83 166 0 1426818672 4663584 27294464
16:58:39 43122 8192000000 10407688448 10732908544 1454544000 15.078 100 94 188 1 1491731616 6931104 30256512
16:59:30 12823 8192000000 10424853776 10753679360 1478238288 15.286 100 89 178 0 1515420304 7898592 29283424
16:59:54 14811 8192000000 10433159296 10762076160 1489337360 15.383 100 92 182 1 1527374576 8537808 29499408
17:00:19 19329 8192000000 10444393824 10776285184 1500330736 15.479 100 87 174 0 1536962176 9100208 27531232
17:00:47 17260 8192000000 10454909376 10789638144 1509650112 15.560 100 84 168 0 1545576144 9101472 26824560
17:01:23 18348 8192000000 10488042816 10826219520 1536520656 15.793 100 84 168 1 1572287024 9543984 26222384
17:01:50 14889 8192000000 10495187568 10840174592 1550145264 15.911 100 79 158 0 1584214192 9617056 24451872
17:02:14 15254 8192000000 10515752208 10862149632 1573496784 16.112 100 72 144 0 1604706560 9687152 21522624
17:02:37 7409 8192000000 10530460976 10884374528 1594450960 16.292 100 73 146 0 1626272960 9988640 21833360
17:02:55 9682 8192000000 10561242624 10916921344 1622304224 16.529 100 79 158 1 1656530144 10507952 23717968
17:03:13 9223 8192000000 10580611792 10940944384 1635958208 16.645 100 77 155 0 1669735920 10716064 23061648
17:03:33 8986 8192000000 10602282384 10965999616 1663249120 16.876 100 82 163 0 1699291376 11680064 24362192
17:03:52 8342 8192000000 10623055696 10988924928 1681078544 17.026 100 88 175 0 1719443776 12578432 25786800
17:04:09 8558 8192000000 10633555488 10999771136 1687938048 17.084 100 74 148 2 1722115328 12350880 21826400
17:04:25 7720 8192000000 10641530256 11015786496 1701596112 17.198 100 73 146 0 1735291984 12349792 21346080
17:04:40 7157 8192000000 10665523376 11039485952 1722075520 17.370 100 77 153 1 1756284256 12826000 21382736
17:04:54 5012 8192000000 10673114800 11045015552 1732890864 17.460 100 83 164 1 1770229024 13626064 23712096
17:05:07 6055 8192000000 10683475856 11056738304 1738875856 17.509 100 79 158 0 1775057888 13847344 22334688
17:05:20 4444 8192000000 10680954304 11057618944 1746686416 17.574 100 79 159 1 1781702848 12777360 22239072
17:05:31 5878 8192000000 10699121056 11078041600 1757664032 17.665 100 79 158 2 1793647088 13404048 22579008
17:05:44 6087 8192000000 10707456608 11086028800 1772187088 17.785 100 85 170 0 1809272208 13035616 24049504
17:05:57 3661 8192000000 10720577136 11098963968 1780335072 17.852 100 83 164 0 1816536480 12907088 23294320
17:06:08 3554 8192000000 10725263008 11107069952 1788581120 17.920 100 88 176 1 1826122896 13285808 24255968
17:06:18 2885 8192000000 10732791408 11118170112 1798474144 18.001 100 82 164 1 1835017904 13389856 23153904
17:06:28 2322 8192000000 10746925328 11126079488 1800962304 18.022 100 88 175 0 1839370752 13925840 24482608
17:06:36 2628 8192000000 10744950656 11130286080 1807212768 18.073 100 86 170 1 1849334880 18140832 23981280
17:06:51 4969 8192000000 10746227024 11136167936 1812905104 18.120 100 79 155 2 1845922800 11858944 21158752
17:07:05 2175 8192000000 10774298096 11157442560 1826022256 18.227 100 87 172 3 1862901568 12468640 24410672
17:07:13 2882 8192000000 10778755408 11161739264 1839651728 18.338 100 91 183 2 1877209680 12831152 24726800
17:07:23 3395 8192000000 10782309744 11165011968 1841532240 18.353 100 91 182 2 1881919072 14917680 25469152
17:07:32 2391 8192000000 10793439696 11179888640 1848628576 18.411 100 93 184 0 1890232432 15904320 25699536
17:07:41 1923 8192000000 10793351584 11177750528 1846728208 18.396 100 88 176 1 1884696912 13559136 24409568
17:07:50 1802 8192000000 10788292464 11177410560 1850928128 18.430 100 93 184 2 1891083536 14338224 25817184
17:07:58 1748 8192000000 10787423328 11178979328 1851147696 18.431 100 85 171 0 1891131456 16977744 23006016
17:08:06 1683 8192000000 10793054112 11182510080 1853523760 18.451 100 88 176 2 1888548848 11279472 23745616
17:08:14 1289 8192000000 10802233424 11189882880 1854905664 18.462 100 89 178 4 1892381104 12405728 25069712
17:08:22 1533 8192000000 10806107040 11190878208 1857447568 18.483 100 94 185 1 1897141584 13889472 25804544
17:08:30 1477 8192000000 10810979504 11196071936 1863517680 18.532 100 90 181 0 1902249872 12960736 25771456
17:08:38 1772 8192000000 10797563504 11189362688 1860518048 18.507 100 82 161 1 1894708288 11899488 22290752
17:08:46 1844 8192000000 10803191168 11198775296 1864794032 18.542 100 81 165 1 1901116960 12988336 23334592
17:08:54 40666 8192000000 10794800944 11203526656 1866136944 18.553 100 55 110 4 1890057456 7639408 16281104
17:09:42 10858 8192000000 10783169632 11199770624 1864411424 18.539 100 26 53 0 1878089488 6369520 7308544
17:10:01 4574 8192000000 10782729168 11203633152 1866313840 18.554 100 26 52 2 1881377712 8091648 6972224
17:10:12 9613 8192000000 10782933360 11206176768 1868748016 18.574 100 26 50 5 1883552448 7223376 7581056
17:10:28 7015 8192000000 10787817408 11207249920 1866596656 18.557 100 14 26 2 1875998048 6031168 3370224
17:10:41 4919 8192000000 10787780272 11211501568 1870007120 18.584 100 23 47 1 1884006624 7315712 6683792
17:10:52 6930 8192000000 10782574880 11210842112 1875172800 18.626 100 31 63 1 1890369984 6527136 8670048
17:11:06 7855 8192000000 10786872896 11215785984 1876569680 18.637 100 19 39 1 1887658896 5532992 5556224
17:11:22 6239 8192000000 10798082992 11220905984 1884274960 18.700 100 34 69 1 1901183408 7311040 9597408
17:11:35 5312 8192000000 10795702512 11223470080 1883329776 18.692 100 23 46 1 1897038224 6945504 6762944
17:11:50 10788 8192000000 10791324336 11223470080 1882679264 18.687 100 15 30 4 1892671424 5900208 4091952
17:12:07 12253 8192000000 10801171872 11231440896 1886927632 18.721 100 21 42 1 1903504608 10587056 5989920
17:12:25 6692 8192000000 10817782304 11230683136 1888441712 18.733 100 31 60 1 1902980624 4956480 9582432
17:12:40 11152 8192000000 10792699008 11227066368 1886177232 18.715 100 18 36 0 1896713008 5771488 4764288
17:12:57 55241 8192000000 10812117488 11234791424 1889254400 18.740 100 35 70 1 1904916464 4419648 11242416
17:14:00 20369 8192000000 10801852576 11233255424 1887860064 18.729 100 24 48 0 1901668096 6543120 7264912
17:14:26 7387 8192000000 10810945392 11242487808 1891862784 18.761 100 25 50 1 1904638656 5985504 6790368
17:14:41 4932 8192000000 10807810480 11240284160 1897521200 18.806 100 41 81 2 1916720992 7831504 11368288
17:14:53 3945 8192000000 10812443312 11243409408 1896236400 18.796 100 28 55 2 1911041888 6794960 8010528
17:15:03 5010 8192000000 10807952336 11242414080 1898070416 18.811 100 31 62 1 1913106400 6526192 8509792
17:15:15 4898 8192000000 10819245056 11246452736 1898767408 18.816 100 26 52 0 1913290896 7429712 7093776
17:15:26 5312 8192000000 10813828400 11248545792 1898033520 18.810 100 22 44 0 1910530688 6112896 6384272
17:15:42 5145 8192000000 10820173072 11255091200 1907527472 18.887 100 30 60 4 1922722128 6418272 8776384
17:15:54 7988 8192000000 10827536208 11249643520 1886603488 18.718 99 24 46 0 1899033808 5969424 6460896
17:16:10 10633 8192000000 10815411856 11243237376 1864511344 18.540 98 19 38 0 1875975168 6167024 5296800
17:16:28 8944 8192000000 10799101536 11229409280 1871022224 18.593 99 19 38 0 1881641696 5005920 5613552
17:16:45 6577 8192000000 10793482336 11226312704 1879747504 18.663 100 21 43 0 1895867744 10781088 5339152
17:16:57 3943 8192000000 10798720144 11229347840 1882086352 18.682 100 26 52 3 1896650080 7176240 7387488
17:17:07 10451 8192000000 10771812224 11202600960 1834845360 18.299 97 24 44 3 1847692704 6136912 6710432
17:17:25 6473 8192000000 10763597984 11188871168 1822090096 18.195 97 26 50 4 1834841264 4714288 8036880
17:17:37 7783 8192000000 10747171472 11174412288 1765133952 17.727 95 18 37 1 1775667920 5449072 5084896
17:17:53 59416 8192000000 10754938320 11185790976 1816358592 18.148 98 38 74 2 1833448944 6289216 10801136
17:18:59 7418 8192000000 10733798848 11164745728 1793892032 17.964 97 18 35 1 1804389376 5075296 5422048
17:19:16 4790 8192000000 10729024544 11132006400 1772488816 17.788 98 42 82 3 1790028736 6099408 11440512
17:19:27 3656 8192000000 10726805456 11126312960 1772172496 17.785 98 50 100 0 1793281872 6614640 14494736
17:19:42 8260 8192000000 10715956672 11127164928 1770037936 17.767 98 25 47 2 1781769536 4647888 7083712
17:19:56 8780 8192000000 10704676832 11121758208 1734284864 17.471 96 29 58 1 1749444016 6271904 8887248
17:20:12 5694 8192000000 10708050448 11127844864 1768484912 17.755 98 17 34 1 1779026688 5597824 4943952
17:20:24 6254 8192000000 10710209344 11122626560 1757971536 17.668 97 37 72 2 1774371344 5562048 10837760
17:20:40 7384 8192000000 10684444576 11101589504 1730663680 17.441 97 39 78 2 1748006752 6207520 11135552
17:20:54 7829 8192000000 10718582400 11137761280 1780197248 17.851 99 26 49 2 1792979328 5740240 7041840
17:21:12 8427 8192000000 10713769520 11136983040 1772848000 17.791 98 30 58 3 1787837456 6529024 8460432
17:21:27 8979 8192000000 10694413456 11109769216 1740810544 17.525 96 35 71 3 1761086720 10014784 10261392
17:21:43 8781 8192000000 10702917040 11121823744 1768312816 17.753 98 22 43 1 1780165168 5078112 6774240
17:22:00 11508 8192000000 10722754304 11138793472 1801033504 18.022 99 24 48 1 1813458448 5339696 7085248
17:22:18 17495 8192000000 10728310528 11161591808 1809894720 18.095 99 24 48 1 1821472816 5002032 6576064
17:22:43 17381 8192000000 10741655696 11166769152 1821397344 18.189 99 42 82 1 1840066192 6496640 12172208
17:23:13 46165 8192000000 10788174288 11179978752 1812746320 18.118 98 69 142 1 1838523264 5541136 20235808
17:24:05 7840 8192000000 10743087344 11172900864 1818854496 18.168 99 20 39 2 1829963776 5673328 5435952
17:24:23 5712 8192000000 10768598704 11188850688 1846956944 18.397 100 32 64 4 1861045856 5278816 8810096
17:24:37 5563 8192000000 10770354688 11186692096 1835650640 18.305 99 36 72 1 1853247104 7242144 10354320
17:24:52 9438 8192000000 10762021952 11193008128 1852814112 18.445 100 17 34 0 1863695376 5919408 4961856
17:25:07 7936 8192000000 10771414832 11196207104 1855714272 18.469 100 25 50 0 1872409504 9637056 7058176
17:25:22 5461 8192000000 10776516064 11198963712 1856817856 18.477 100 27 54 1 1870718064 6272144 7628064
17:25:35 5689 8192000000 10778677312 11205562368 1861510304 18.516 100 31 59 2 1880611200 10105904 8994992
17:25:51 8627 8192000000 10776537680 11207139328 1862105776 18.520 100 22 44 1 1874457200 5927184 6424240
17:26:06 11036 8192000000 10786347984 11215429632 1867201536 18.562 100 20 40 0 1879141408 5399120 6540752
17:26:24 11189 8192000000 10784923936 11217944576 1873099632 18.609 100 15 30 1 1882807888 5170864 4537392
17:26:42 5991 8192000000 10803466288 11228049408 1878393760 18.652 100 26 52 0 1892614464 6755744 7464960
17:26:56 9867 8192000000 10793682864 11230040064 1881408400 18.676 100 17 34 2 1890930272 4895792 4626080
17:27:12 7219 8192000000 10827388640 11242340352 1893431456 18.773 100 29 54 1 1905833136 4335472 8066208
17:27:28 24950 8192000000 10842805360 11260215296 1902285984 18.845 100 25 50 1 1914761808 5043616 7432208
17:28:13 28658 8192000000 10841957648 11271012352 1920314512 18.989 100 37 74 2 1937405344 6964832 10126000
17:28:53 49060 8192000000 10854823312 11287523328 1930407552 19.070 100 31 62 3 1946082208 6771280 8903376
17:29:51 98985 8192000000 10866903488 11309273088 1941087904 19.155 100 37 74 1 1960388256 8273472 11026880
17:31:42 9544 8192000000 10882223552 11315970048 1948112672 19.211 100 41 80 1 1969468048 9894256 11461120
17:32:00 25585 8192000000 10893853776 11328114688 1957430656 19.286 100 47 94 1 1982901456 11730272 13740528
17:32:41 14082 8192000000 10913737680 11343589376 1969970864 19.385 100 67 135 0 2002842416 12953408 19918144
17:33:04 5813 8192000000 10916116352 11343634432 1970736480 19.391 100 56 112 0 2002173696 15061184 16376032
17:33:26 19352 8192000000 10905022400 11344416768 1968351936 19.372 100 46 92 0 2001066608 19526704 13187968
17:33:54 10079 8192000000 10905601984 11344265216 1970415888 19.389 100 45 90 1 1998084544 14710880 12957776
17:34:14 5832 8192000000 10913608288 11347984384 1976013968 19.433 100 49 93 2 2004865952 15088960 13763024
17:34:29 10961 8192000000 10916039568 11353620480 1985645680 19.509 100 53 105 2 2014243168 13494832 15102656
17:34:49 10785 8192000000 10926874304 11359563776 1986989216 19.520 100 60 118 1 2019907280 14848928 18069136
17:35:16 14591 8192000000 10927616384 11362562048 1983036416 19.489 100 58 116 1 2017007920 16656592 17314912
17:35:43 12201 8192000000 10937312320 11367813120 1989012624 19.536 100 50 100 0 2018878224 15296096 14569504
17:36:09 10247 8192000000 10912806496 11349987328 1953069744 19.251 98 53 106 0 1984251568 15721344 15460480
17:36:30 5592 8192000000 10936156224 11365896192 1986865488 19.519 100 57 113 1 2018162480 15630128 15666864
17:36:46 4691 8192000000 10946482544 11371737088 1994197168 19.577 100 67 134 0 2031755808 18967984 18590656
17:36:58 6944 8192000000 10957073344 11380785152 1999186400 19.616 100 72 144 3 2040246128 20043280 21016448
17:37:15 13987 8192000000 10942744640 11374153728 1978911568 19.456 99 60 120 1 2018216320 21581280 17723472
17:37:38 14902 8192000000 10936567984 11371741184 1982319040 19.483 100 49 95 1 2017945488 21568176 14058272
17:38:03 8596 8192000000 10924149440 11365761024 1987400192 19.523 100 40 80 0 2018382368 18447248 12534928
17:38:20 13047 8192000000 10929677520 11373445120 1984335120 19.499 100 40 77 1 2016385728 19570304 12480304
17:38:43 14586 8192000000 10903592800 11348017152 1949585312 19.223 98 37 73 1 1983152368 21373584 12193472
17:39:08 17166 8192000000 10930877424 11370672128 1964561232 19.342 99 44 88 0 2002560160 24811216 13187712
17:39:34 4871 8192000000 10941835024 11375316992 1989124784 19.537 100 61 121 1 2025605088 18877952 17602352
17:39:50 5123 8192000000 10935153536 11366379520 1965545136 19.350 99 74 149 0 2011331696 24473008 21313552
17:40:02 1644 8192000000 10924215856 11346751488 1955900272 19.273 98 75 147 1 1998850080 20863696 22086112
17:40:12 3196 8192000000 10943953088 11366879232 1982175728 19.482 100 74 148 2 2026250976 22288880 21786368
17:40:23 1674 8192000000 10942880656 11369156608 1984354528 19.499 100 68 136 0 2028569520 23351248 20863744
17:40:33 4994 8192000000 10934452176 11357831168 1967911952 19.369 99 73 146 1 2023264432 33589136 21763344
17:40:49 3398 8192000000 10942008976 11362865152 1977904624 19.448 100 66 132 3 2022315488 24937472 19473392
17:41:00 9062 8192000000 10939696896 11370995712 1966966832 19.361 99 65 131 0 2013465488 26394448 20104208
17:41:28 5809 8192000000 10941828576 11365265408 1963275504 19.332 99 67 134 0 2008213920 24472336 20466080
17:41:42 2650 8192000000 10968137744 11381104640 1991439376 19.555 100 89 176 2 2045091296 26588928 27062992
17:41:55 3414 8192000000 10945205296 11360665600 1958110016 19.291 99 76 152 1 2010604928 28642448 23852464
17:42:07 6764 8192000000 10927481680 11351031808 1950025920 19.227 99 74 148 1 2001982912 28538640 23418352
17:42:21 2222 8192000000 10937704272 11363606528 1976857232 19.440 100 77 153 1 2027567056 27441328 23268496
17:42:30 3457 8192000000 10958287136 11372158976 1985873872 19.511 100 80 159 3 2036358944 25143680 25341392
17:42:42 8143 8192000000 10943661664 11370717184 1981420576 19.476 100 72 144 1 2030109168 26679648 22008944
17:42:59 10755 8192000000 10934253680 11367821312 1965700672 19.351 99 61 121 0 2013560704 28867664 18992368
17:43:19 4716 8192000000 10941309520 11367116800 1975598752 19.430 100 67 135 0 2024057536 27267120 21191664
17:43:31 2815 8192000000 10927533728 11348803584 1966597104 19.358 100 82 162 2 2015606688 24006560 25003024
17:43:41 1568 8192000000 10928497312 11352383488 1967635680 19.367 100 66 130 1 2013155872 25323696 20196496
17:43:52 5141 8192000000 10917080416 11343589376 1956559696 19.279 100 73 146 3 2005886240 26279616 23046928
17:44:04 3671 8192000000 10926950976 11343728640 1956637216 19.279 100 70 136 1 2004532832 26859136 21036480
17:44:16 1873 8192000000 10935536208 11341217792 1960270160 19.308 100 85 168 3 2012504608 27095440 25139008
17:44:25 1375 8192000000 10942457040 11349413888 1965843808 19.352 100 89 174 3 2019993584 27381584 26768192
17:44:33 1354 8192000000 10945638784 11350552576 1965164368 19.347 100 92 183 0 2022334272 28795792 28374112
17:44:42 3795 8192000000 10928179680 11342209024 1943361856 19.174 99 81 161 0 1998484368 30407152 24715360
17:45:00 4823 8192000000 10936313600 11348467712 1948970160 19.218 99 87 174 0 2007608496 32226816 26411520
17:45:14 3546 8192000000 10948838976 11359215616 1964066208 19.338 100 92 184 0 2027004512 34697504 28240800
17:45:27 2157 8192000000 10918942672 11333943296 1944080352 19.179 99 81 162 1 2006331056 36832080 25418624
17:45:37 1783 8192000000 10931662832 11347206144 1953189056 19.252 100 80 160 1 2015172896 36940160 25043680
17:45:48 5527 8192000000 10935301024 11351724032 1959666992 19.303 100 70 137 0 2016135216 35054240 21413984
17:46:00 4791 8192000000 10918144528 11328413696 1932104768 19.084 100 86 170 1 1996689056 38205088 26379200
17:46:12 2629 8192000000 10938102736 11348500480 1950084784 19.227 100 88 174 1 2017805328 41066240 26654304
17:46:22 4847 8192000000 10919560720 11336794112 1935538080 19.111 100 66 132 4 1999920688 43180080 21202528
17:46:38 3058 8192000000 10942346304 11358674944 1955701056 19.272 100 86 172 2 2026585856 43707376 27177424
17:46:49 4506 8192000000 10941454160 11358048256 1953580672 19.255 100 86 172 1 2025465280 43746768 28137840
17:47:00 3798 8192000000 10928079872 11345637376 1940330224 19.149 99 73 146 0 2002632512 39693664 22608624
17:47:12 3055 8192000000 10935020064 11347271680 1949671568 19.224 100 86 170 0 2015403936 38981168 26751200
17:47:22 2303 8192000000 10929157888 11340091392 1940787344 19.153 99 89 178 1 2008187888 38879440 28521104
17:47:31 2441 8192000000 10951900608 11367649280 1966692448 19.359 100 81 161 1 2033469168 40566352 26210368
17:47:40 6342 8192000000 10916079104 11346882560 1920241024 18.989 98 61 122 0 1980751600 40869408 19641168
17:47:53 6728 8192000000 10882676928 11313676288 1905537936 18.871 98 46 92 2 1956901728 35873792 15490000
17:48:08 25730 8192000000 10861422704 11305250816 1906648800 18.880 99 39 77 1 1955810160 36391920 12769440
17:48:40 13909 8192000000 10849820960 11300110336 1884263024 18.700 98 28 56 4 1927777808 34493520 9021264
17:49:17 7435 8192000000 10868241584 11312828416 1897929824 18.810 99 26 52 1 1942756304 35408960 9417520
17:49:36 13573 8192000000 10893830064 11331342336 1930009680 19.067 100 34 68 1 1977069936 35714192 11346064
17:49:56 8554 8192000000 10865617872 11301036032 1901492896 18.838 99 40 80 0 1948758800 34785056 12480848
17:50:17 7249 8192000000 10887360608 11329306624 1925010672 19.027 100 25 51 1 1969685216 36572720 8101824
17:50:33 20112 8192000000 10880568224 11333464064 1925470672 19.031 100 26 52 1 1973209440 38810240 8928528
17:51:00 15119 8192000000 10872970112 11312058368 1893066752 18.770 98 25 48 0 1930150432 28759776 8323904
17:51:28 17929 8192000000 10880384688 11321851904 1903031120 18.851 99 14 28 1 1937421456 29755808 4634528
17:51:53 19427 8192000000 10869764240 11318329344 1921607840 19.000 100 29 58 3 1961158112 30163664 9386608
17:52:20 41200 8192000000 10875629584 11326693376 1889547552 18.742 98 14 28 0 1927982848 34046816 4388480
17:53:09 32998 8192000000 10871499440 11329933312 1920182096 18.988 100 13 26 0 1959465696 34829568 4454032
17:53:48 31539 8192000000 10880454976 11340324864 1936830944 19.121 100 16 32 0 1969744592 27760592 5153056
17:54:48 40869 8192000000 10882494000 11331133440 1945085744 19.187 100 18 36 2 1960462704 9496736 5880224
17:55:35 40068 8192000000 10889417904 11321241600 1947073968 19.203 100 30 60 0 1966217392 9380960 9762464
17:56:21 33181 8192000000 10886308176 11318939648 1926767104 19.041 99 36 71 0 1944919232 8607936 9544192
17:57:13 76161 8192000000 10875805136 11311009792 1927675120 19.048 99 36 69 2 1948857216 11855088 9327008
17:58:46 87735 8192000000 10888610928 11334217728 1957952032 19.290 100 27 54 1 1977499296 11797280 7749984
18:00:20 113183 8192000000 10864634208 11326550016 1867280384 18.562 95 22 44 0 1882939376 8786144 6872848
18:02:23 6095 8192000000 10884351984 11332403200 1961290608 19.316 100 24 48 0 1976299184 8552048 6456528
18:02:36 25316 8192000000 10906920992 11348025344 1949546640 19.223 99 50 98 1 1973795568 9770416 14478512
18:03:38 63064 8192000000 10901424128 11356241920 1952678128 19.248 99 31 60 1 1973426688 11352496 9396064
18:04:48 20482 8192000000 10912229584 11369205760 1981775232 19.479 100 45 90 1 2013901088 18352128 13773728
18:06:03 26205 8192000000 10898936256 11365105664 1972284192 19.404 100 14 28 1 1989867296 13434384 4148720
18:07:38 29088 8192000000 10902756096 11358515200 1974722672 19.423 100 21 41 2 1988945712 8185568 6037472
18:08:17 32659 8192000000 10893131312 11357392896 1974743904 19.423 100 12 24 1 1987569872 9396480 3429488
18:08:57 21501 8192000000 10887415008 11357048832 1971435728 19.397 100 7 14 0 1982666096 9338608 1891760
18:09:25 17614 8192000000 10885782496 11352260608 1953109296 19.251 99 16 30 2 1967511376 9366368 5035712
18:09:48 66868 8192000000 10890708400 11363524608 1949295104 19.221 99 20 41 0 1968063888 13053888 5714896
18:11:06 44049 8192000000 10896671120 11370524672 1975752368 19.431 100 15 30 1 1991469440 11696864 4020208
18:12:37 86705 8192000000 10896973984 11384483840 1983323696 19.491 100 23 45 1 2001823824 12042160 6457968
18:14:13 48904 8192000000 10901488448 11383107584 1984270384 19.498 100 10 19 1 1997801392 10907104 2623904
18:15:10 50270 8192000000 10892712624 11376058368 1965389696 19.349 99 15 29 1 1979719376 9818368 4511312
18:16:09 74726 8192000000 10883356176 11361382400 1926691712 19.040 97 18 36 3 1942656272 10345856 5618704
18:17:38 45148 8192000000 10890892992 11355934720 1934162112 19.100 98 35 70 1 1956323024 12253216 9907696
18:18:40 19912 8192000000 10896237424 11359891456 1966960800 19.361 100 31 63 0 1986480112 10496384 9022928
18:19:11 46200 8192000000 10877807088 11350585344 1913292528 18.933 97 16 32 1 1930626784 13089648 4244608
18:20:38 55206 8192000000 10884142992 11360722944 1934889376 19.106 98 28 56 0 1952652224 9953488 7809360
18:22:02 49799 8192000000 10899755216 11354923008 1935312544 19.109 98 31 61 0 1953588736 9683968 8592224
18:23:16 73601 8192000000 10911380720 11383451648 1960576624 19.311 99 14 28 0 1978184784 13663520 3944640
18:24:36 56047 8192000000 10888035392 11368116224 1944596576 19.183 98 15 30 0 1964569680 15602912 4370192
18:25:48 55301 8192000000 10885325168 11337601024 1847934288 18.405 94 13 26 0 1864960880 13794880 3231712
18:27:05 82244 8192000000 10901558384 11384860672 1928455072 19.055 98 24 49 2 1952215856 17539584 6221200
18:28:36 111792 8192000000 10891983056 11359784960 1893887024 18.777 96 10 20 0 1913468496 16657680 2923792
18:30:52 50698 8192000000 10888522960 11348905984 1897644656 18.807 96 26 50 1 1915983600 11008512 7330432
18:31:53 82655 8192000000 10891297072 11375120384 1946456256 19.198 99 18 36 0 1980579808 29057248 5066304
18:33:59 22707 8192000000 10884775888 11339141120 1937098640 19.124 99 27 53 0 1955687280 10992288 7596352
18:34:28 22118 8192000000 10872345328 11340509184 1948977200 19.218 100 14 28 0 1963633728 10634528 4022000
18:35:05 73506 8192000000 10860321504 11334168576 1879874848 18.664 96 8 15 1 1888379824 6150560 2354416
18:36:25 38231 8192000000 10838892336 11305717760 1913261200 18.933 98 9 17 2 1922354464 6454192 2639072
18:37:10 36392 8192000000 10852740688 11306758144 1866758880 18.558 96 13 26 1 1877709472 6782480 4168112
18:37:54 58510 8192000000 10856130752 11325906944 1929422496 19.062 100 28 56 0 1946080496 8500480 8157520
18:39:07 59755 8192000000 10838142240 11306319872 1887195264 18.723 98 16 32 0 1905909280 14433776 4280240
18:40:13 1472 8192000000 10845987888 11312652288 1922775936 19.009 100 15 30 2 1941984128 14871008 4337184
18:40:22 50212 8192000000 10831616400 11294322688 1868294096 18.570 97 25 50 0 1894905808 19375056 7236656
18:41:21 68742 8192000000 10836125856 11320750080 1903321584 18.853 99 12 24 1 1918582240 11635472 3625184
18:42:42 93146 8192000000 10844288384 11316035584 1893464864 18.774 98 14 28 0 1907837408 10445072 3927472
18:44:22 22237 8192000000 10848104144 11302432768 1872844944 18.607 97 25 50 0 1886747280 6947552 6954784
18:44:52 27462 8192000000 10855852976 11291815936 1835070448 18.301 95 40 80 0 1857388832 11616976 10701408
18:45:27 13604 8192000000 10855968064 11304087552 1918704944 18.976 100 53 106 1 1948849664 14643488 15501232
18:45:47 29957 8192000000 10872253824 11324452864 1910867424 18.914 99 29 58 1 1935714352 16886912 7960016
18:46:33 31498 8192000000 10877532112 11340095488 1919347296 18.982 99 25 50 0 1944639392 18036304 7255792
18:47:25 19099 8192000000 10884817280 11338399744 1940980864 19.155 100 39 78 1 1969025072 16686480 11357728
18:47:55 66997 8192000000 10869429392 11357245440 1911531264 18.919 98 22 44 0 1936603840 19167136 5905440
18:49:12 69574 8192000000 10857785280 11337437184 1891761600 18.760 98 5 10 0 1911282624 17796928 1724096
18:50:43 31875 8192000000 10872533968 11334381568 1920771568 18.993 99 16 32 0 1936044224 10859936 4412720
18:51:27 41367 8192000000 10908531328 11335143424 1944839888 19.185 100 45 89 2 1973878448 15846336 13192224
18:52:17 14068 8192000000 10888983072 11344433152 1952957728 19.250 100 40 77 2 1973490400 10086496 10446176
18:52:42 35558 8192000000 10922076800 11362422784 1963206544 19.332 100 36 72 1 1983109488 10050096 9852848
18:53:24 65420 8192000000 10908267824 11380596736 1966689488 19.359 100 29 58 0 1989847376 15099104 8058784
18:54:47 149269 8192000000 10893981744 11351855104 1893106720 18.771 96 16 32 2 1908286528 9897856 5281952
18:57:33 24212 8192000000 10894961168 11364945920 1969802976 19.384 100 19 38 1 1982656672 7838976 5014720
18:58:12 56882 8192000000 10885270544 11361693696 1938872864 19.138 98 10 20 1 1949301168 7653968 2774336
18:59:15 67649 8192000000 10895803984 11378016256 1983053056 19.489 100 10 20 1 1994661552 8749536 2858960
19:00:34 35087 8192000000 10894044784 11380133888 1980581376 19.469 100 11 22 1 1991826064 7989760 3254928
19:01:43 36051 8192000000 10902312512 11377528832 1968557168 19.374 99 16 29 1 1977293888 5735536 3001184
19:02:42 70751 8192000000 10895482416 11366334464 1877536128 18.645 94 14 26 1 1888886512 7853680 3496704
19:04:13 56619 8192000000 10919714384 11391389696 1987006224 19.520 100 15 30 1 2003146128 11800496 4339408
19:05:16 62951 8192000000 10911343280 11398115328 1970828656 19.392 99 11 22 0 1984321104 10071872 3420576
19:06:30 34975 8192000000 10906831216 11366506496 1921444736 18.998 96 36 71 1 1941088064 9561216 10082112
19:07:16 77567 8192000000 10896554832 11379056640 1919536320 18.983 97 19 38 1 1937623904 12446752 5640832
19:08:41 46683 8192000000 10922472672 11380928512 1965709472 19.351 99 25 50 1 1981699824 9461152 6529200
19:09:40 30829 8192000000 10908826528 11366154240 1942890400 19.170 98 24 48 1 1959293024 9899824 6502800
19:10:17 35715 8192000000 10914729088 11356381184 1913470752 18.934 97 39 78 0 1933456368 9654832 10330784
19:11:06 19601 8192000000 10920605344 11371839488 1974016480 19.417 100 55 110 1 2001957456 11926048 16014928
19:11:36 47364 8192000000 10913593856 11380891648 1961208528 19.316 99 39 78 0 1986313424 14164208 10940688
19:12:37 102924 8192000000 10898798256 11383369728 1933764512 19.097 98 11 21 1 1947884320 11455264 2664544
19:14:27 34244 8192000000 10911938416 11368951808 1901877152 18.841 96 16 32 2 1914348960 8512048 3959760
19:15:09 48845 8192000000 10924110288 11385298944 1971008496 19.393 100 19 38 0 1990561056 14061504 5491056
19:16:09 101978 8192000000 10890725648 11366957056 1898331488 18.813 96 13 26 0 1914440752 12702096 3407168
19:19:24 46861 8192000000 10885930368 11345465344 1944405536 19.182 99 27 54 0 1961763616 9686448 7671632
19:20:18 85424 8192000000 10896026816 11376881664 1954890496 19.265 99 20 40 1 1971190496 10747392 5552608
19:23:13 59592 8192000000 10892294144 11369504768 1939447664 19.142 98 9 18 0 1955244576 13083776 2713136
19:24:24 69427 8192000000 10914571472 11394420736 1980831760 19.471 100 23 46 2 2002095584 14773104 6490720
19:25:40 102341 8192000000 10857070896 11318362112 1818737984 18.167 92 10 20 1 1835582352 14001184 2843184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-04-2021 19:28:55 to 04-04-2021 19:29:26.

Exceptions occured during test was in run

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

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

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          240437
MON$OLDEST_ACTIVE               241426
MON$OLDEST_SNAPSHOT             241426
MON$NEXT_TRANSACTION            241426
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                       2021312
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
:27: 
:28: mscs-test-161.budzdorov.ru    Sun Apr  4 19:27:31 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Sun Apr  4 19:27:31 2021
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
:35: 
:36: mscs-test-161.budzdorov.ru    Sun Apr  4 19:27:32 2021
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
:39: 
:40: mscs-test-161.budzdorov.ru    Sun Apr  4 19:27:32 2021
:41:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:42: 
:43: 
:44: mscs-test-161.budzdorov.ru    Sun Apr  4 19:27:32 2021
:45:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:46: 
--- end of diff output ---

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

04.04.21 19:29:30. 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-04-04 19:29:32 No severe PSQL-related problems occured
04.04.21 19:29:34. End of report.