Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.04.2021 01:27
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 17136232 kB
MemAvailable 31411560 kB
Buffers 0 kB
Cached 14496712 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 01:27:25
DTS_END                         2021-04-04 01:27:25.3850
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/51098
TRN_ID                          243313
ATT_ID                          689
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: 9538.64 22113 1144637
customer order: creation 178.72 352 21446
customer order: refuse 15.38 367 1846
order to supplier: creation 47.08 1230 5650
order to supplier: removal 3.68 97335 441
invoice (draft): creation 45.71 3288 5485
invoice (draft): removal 53.62 753 6434
invoice accept: apply 43.84 19799 5261
invoice accept: cancel 48.89 857 5867
customer reserve: creation 4009.51 199 481141
customer reserve: removal 4782.84 59 573941
realization accept: apply 87.98 180 10558
realization accept: cancel 88.55 108 10626
payment from customer: creation 60.64 114 7277
payment from customer: removal 6.07 75 728
payment to supplier: creation 49.25 116 5910
payment to supplier: removal 3.33 80 399
service: total inventory turnovers 5.32 977 638
service: total monetary turnovers 7.45 30 894
service: aggregate perf. data 0.76 22511 91
service: refresh index statistics 0.03 293824 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2021 01:28:01 to 04-04-2021 01:28:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1766
TEST_TIME 2 2717
TEST_TIME 3 4181
TEST_TIME 4 4343
TEST_TIME 5 4783
TEST_TIME 6 5091
TEST_TIME 7 5384
TEST_TIME 8 5931
TEST_TIME 9 6602
TEST_TIME 10 6678
TEST_TIME 11 6682
TEST_TIME 12 6758
TEST_TIME 13 6759
TEST_TIME 14 7111
TEST_TIME 15 7229
TEST_TIME 16 7505
TEST_TIME 17 7412
TEST_TIME 18 7939
TEST_TIME 19 8272
TEST_TIME 20 8457
TEST_TIME 21 8482
TEST_TIME 22 8595
TEST_TIME 23 9263
TEST_TIME 24 9625
TEST_TIME 25 9928
TEST_TIME 26 9825
TEST_TIME 27 9931
TEST_TIME 28 9975
TEST_TIME 29 10286
TEST_TIME 30 10523
TEST_TIME 31 10994
TEST_TIME 32 10904
TEST_TIME 33 11056
TEST_TIME 34 10904
TEST_TIME 35 11017
TEST_TIME 36 11061
TEST_TIME 37 11029
TEST_TIME 38 10797
TEST_TIME 39 10623
TEST_TIME 40 10523
TEST_TIME 41 10371
TEST_TIME 42 10338
TEST_TIME 43 10252
TEST_TIME 44 10135
TEST_TIME 45 10142
TEST_TIME 46 10112
TEST_TIME 47 10031
TEST_TIME 48 10115
TEST_TIME 49 10160
TEST_TIME 50 10032
TEST_TIME 51 9982
TEST_TIME 52 9891
TEST_TIME 53 9942
TEST_TIME 54 9851
TEST_TIME 55 9808
TEST_TIME 56 9871
TEST_TIME 57 9834
TEST_TIME 58 9799
TEST_TIME 59 9673
TEST_TIME 60 9599
TEST_TIME 61 9660
TEST_TIME 62 9582
TEST_TIME 63 9682
TEST_TIME 64 9691
TEST_TIME 65 9684
TEST_TIME 66 9851
TEST_TIME 67 9824
TEST_TIME 68 9775
TEST_TIME 69 9882
TEST_TIME 70 9803
TEST_TIME 71 9988
TEST_TIME 72 10044
TEST_TIME 73 10088
TEST_TIME 74 10056
TEST_TIME 75 10015
TEST_TIME 76 9910
TEST_TIME 77 9888
TEST_TIME 78 9861
TEST_TIME 79 9876
TEST_TIME 80 9804
TEST_TIME 81 9759
TEST_TIME 82 9754
TEST_TIME 83 9691
TEST_TIME 84 9633
TEST_TIME 85 9568
TEST_TIME 86 9609
TEST_TIME 87 9632
TEST_TIME 88 9613
TEST_TIME 89 9603
TEST_TIME 90 9614
TEST_TIME 91 9701
TEST_TIME 92 9685
TEST_TIME 93 9654
TEST_TIME 94 9719
TEST_TIME 95 9698
TEST_TIME 96 9692
TEST_TIME 97 9701
TEST_TIME 98 9727
TEST_TIME 99 9764
TEST_TIME 100 9717
TEST_TIME 101 9768
TEST_TIME 102 9687
TEST_TIME 103 9631
TEST_TIME 104 9565
TEST_TIME 105 9566
TEST_TIME 106 9585
TEST_TIME 107 9533
TEST_TIME 108 9500
TEST_TIME 109 9478
TEST_TIME 110 9492
TEST_TIME 111 9514
TEST_TIME 112 9514
TEST_TIME 113 9493
TEST_TIME 114 9487
TEST_TIME 115 9526
TEST_TIME 116 9524
TEST_TIME 117 9547
TEST_TIME 118 9587
TEST_TIME 119 9597
TEST_TIME 120 9541

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2021 01:28:04 to 04-04-2021 01:28:08.

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 1590265 1590265 0 0.00 0 25989 7 0 0
doc_list_biud 1590265 1590265 0 0.00 0 30491 27 0 0
sp_add_invoice_to_stock 5369 5261 108 2.01 12 196189 19800 0 108
sp_cancel_adding_invoice 5867 5867 0 0.00 5 61545 858 0 0
sp_cancel_client_order 1846 1846 0 0.00 4 23577 367 0 0
sp_cancel_customer_reserve 573941 573941 0 0.00 1 28482 60 0 0
sp_cancel_pay_from_customer 728 728 0 0.00 3 6080 75 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 3803 81 0 0
sp_cancel_supplier_invoice 6445 6434 11 0.17 2 15555 754 0 11
sp_cancel_supplier_order 441 441 0 0.00 9 1206923 97335 0 0
sp_cancel_write_off 10626 10626 0 0.00 1 29022 108 0 0
sp_client_order 21446 21446 0 0.00 3 87253 353 0 0
sp_customer_reserve 481141 481141 0 0.00 0 92476 199 0 0
sp_fill_shopping_cart 32570 32570 0 0.00 1 19681 34 0 0
sp_fill_shopping_cart_clo_res 481136 481136 0 0.00 0 12918 13 0 0
sp_get_clo_for_invoice 5256 5256 0 0.00 0 31146 282 0 0
sp_kill_cost_storno 17620 17620 0 0.00 0 9154 54 0 0
sp_kill_qstorno_ret_qs2qd 1165383 1165383 0 0.00 0 28974 32 0 0
sp_kill_qty_storno 614969 614969 0 0.00 0 30491 69 0 0
sp_lock_selected_doc 21750 21750 0 0.00 0 7264 5 0 0
sp_make_cost_storno 29001 29001 0 0.00 0 14988 51 0 0
sp_multiply_rows_for_pdistr 29001 29001 0 0.00 0 7863 29 0 0
sp_multiply_rows_for_qdistr 21446 21446 0 0.00 0 35291 145 0 0
sp_pay_from_customer 7277 7277 0 0.00 4 15022 115 0 0
sp_pay_to_supplier 5910 5910 0 0.00 5 11535 116 0 0
sp_payment_common 13187 13187 0 0.00 1 7504 22 0 0
sp_qd_handle_on_cancel_clo 1846 1846 0 0.00 0 23568 332 0 0
sp_qd_handle_on_invoice_upd_sts 11123 11123 0 0.00 0 30489 348 0 0
sp_qd_handle_on_reserve_upd_sts 10558 10558 0 0.00 0 19797 57 0 0
sp_reserve_write_off 10558 10558 0 0.00 6 19856 180 0 0
sp_supplier_invoice 5485 5485 0 0.00 6 97264 3288 0 0
sp_supplier_order 5650 5650 0 0.00 5 45134 1230 0 0
srv_aggregate_perf_data 91 91 0 0.00 2561 365796 22512 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1337 151005 28370 0 0
srv_find_qd_qs_mism 1095467 1095467 0 0.00 0 25111 6 0 0
srv_make_invnt_saldo 638 638 0 0.00 20 39659 977 0 0
srv_make_money_saldo 894 894 0 0.00 1 4338 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 212191 381889 293825 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5262 5262 0 0.00 0 17250 206 0 0
t$perf-norm:sp_cancel_adding_invoice 438 438 0 0.00 0 8423 119 0 0
t$perf-norm:sp_cancel_client_order 1846 1846 0 0.00 0 9484 21 0 0
t$perf-norm:sp_cancel_customer_reserve 694 694 0 0.00 0 1240 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 728 728 0 0.00 0 888 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 107 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 858 15 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 24118 1604 0 0
t$perf-norm:sp_cancel_write_off 1007 1007 0 0.00 0 3949 15 0 0
t$perf-norm:sp_client_order 21447 21447 0 0.00 0 15204 21 0 0
t$perf-norm:sp_customer_reserve 1068 1068 0 0.00 0 4048 8 0 0
t$perf-norm:sp_pay_from_customer 7280 7280 0 0.00 0 16555 14 0 0
t$perf-norm:sp_pay_to_supplier 5910 5910 0 0.00 0 27891 15 0 0
t$perf-norm:sp_reserve_write_off 10559 10559 0 0.00 0 16552 12 0 0
t$perf-norm:sp_supplier_invoice 5485 5485 0 0.00 0 8904 20 0 0
t$perf-norm:sp_supplier_order 5650 5650 0 0.00 0 5082 20 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 283 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 9688 84 0 0
t$perf-norm:srv_make_invnt_saldo 638 638 0 0.00 0 2018 26 0 0
t$perf-norm:srv_make_money_saldo 894 894 0 0.00 0 1655 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 11 4 0 0
v_add_invoice_to_stock 10720 10504 216 2.01 0 5941 19 0 216
v_all_customers 38622 38622 0 0.00 0 18 1 0 0
v_all_suppliers 30612 30612 0 0.00 0 19 1 0 0
v_all_wares 42882 42882 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 876 876 0 0.00 0 2261 9 0 0
v_cancel_client_order 3692 3692 0 0.00 0 4161 8 0 0
v_cancel_customer_prepayment 1456 1456 0 0.00 0 278 3 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 1434 5 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 2393 9 0 0
v_cancel_supplier_invoice 800 778 22 2.75 0 4521 23 0 22
v_cancel_supplier_order 882 882 0 0.00 0 640 4 0 0
v_cancel_write_off 2014 2014 0 0.00 0 4853 17 0 0
v_max_id_clo_ord 5647 5647 0 0.00 0 434 1 0 0
v_max_id_clo_res 1068 1068 0 0.00 0 2895 14 0 0
v_max_id_ord_sup 5482 5482 0 0.00 0 5312 4 0 0
v_max_non_paid_invoice 1733 1733 0 0.00 0 488 3 0 0
v_max_non_paid_realizn 3995 3995 0 0.00 0 3337 4 0 0
v_min_id_clo_ord 5647 5647 0 0.00 0 3223 6 0 0
v_min_id_clo_res 1068 1068 0 0.00 0 28063 39 0 0
v_min_id_ord_sup 5482 5482 0 0.00 0 9445 9 0 0
v_min_non_paid_invoice 5910 5910 0 0.00 0 3227 12 0 0
v_min_non_paid_realizn 7277 7277 0 0.00 0 4448 14 0 0
v_our_firm 10824 10824 0 0.00 0 16 1 0 0
v_reserve_write_off 21112 21112 0 0.00 0 4913 6 0 0
x_lock_depdocs_on_canc_invoice 11912 11912 0 0.00 0 16877 128 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 8244 320 0 0
x_make_qstorno_1000_1200 5650 5650 0 0.00 2 45125 1149 0 0
x_make_qstorno_1200_2000 5485 5485 0 0.00 3 97099 3167 0 0
x_make_qstorno_2100_3300 481141 481141 0 0.00 0 92475 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2021 01:28:09 to 04-04-2021 01:28:13.

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
22:57:29 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:35 16439 8192000000 10259051600 10567434240 1066509984 11.519 82 63 126 0 1090146624 3086704 20549936
22:58:00 33428 8192000000 10350828192 10668838912 1398936368 14.586 100 86 172 1 1431768416 5309760 27522288
22:58:46 26309 8192000000 10381335344 10705035264 1429583744 14.858 100 84 168 1 1464229328 6980544 27665040
22:59:21 23751 8192000000 10405709312 10732290048 1461548800 15.140 100 90 180 0 1498451072 7758288 29143984
22:59:53 25812 8192000000 10422633520 10751963136 1476208880 15.268 100 93 186 0 1515085808 8442560 30434368
23:00:29 22674 8192000000 10447431600 10776924160 1494610784 15.429 100 93 185 2 1533088400 8933440 29544176
23:01:01 20768 8192000000 10452239216 10790940672 1510670976 15.569 100 87 174 0 1548204336 9898528 27634832
23:01:32 11546 8192000000 10460710320 10804629504 1516934912 15.624 100 75 148 2 1549254016 9164272 23154832
23:01:50 16690 8192000000 10496721120 10838573056 1548518224 15.897 100 83 166 0 1584416544 9814672 26083648
23:02:17 18163 8192000000 10534339616 10883432448 1579578160 16.165 100 80 160 2 1614216384 10130576 24507648
23:02:46 9582 8192000000 10557602880 10906861568 1605975920 16.390 100 82 164 0 1641427120 10307744 25143456
23:03:06 15236 8192000000 10568314336 10929016832 1625957472 16.561 100 80 160 0 1661776896 11190208 24629216
23:03:29 12060 8192000000 10595319840 10959458304 1650544096 16.769 100 67 134 0 1681582192 11577552 19460544
23:03:51 9328 8192000000 10602206704 10972057600 1672565520 16.955 100 80 160 0 1708043904 12361200 23117184
23:04:07 10469 8192000000 10620759680 10990669824 1680399168 17.021 100 76 152 0 1714406352 12104432 21902752
23:04:24 6505 8192000000 10635356016 11005562880 1694522992 17.139 100 83 165 0 1731023616 12351008 24149616
23:04:39 4491 8192000000 10649774880 11021217792 1712710736 17.291 100 80 161 0 1748419968 12876384 22832848
23:04:50 5334 8192000000 10655747248 11030224896 1718731920 17.342 100 72 144 1 1751521872 12334144 20455808
23:05:03 5709 8192000000 10670926384 11047018496 1733367248 17.464 100 83 165 1 1769545056 13034960 23142848
23:05:18 4918 8192000000 10674986336 11050967040 1744088832 17.553 100 73 145 0 1777865312 13663376 20113104
23:05:29 4901 8192000000 10702508800 11075940352 1757442768 17.663 100 83 166 2 1795174224 14309408 23422048
23:05:41 4878 8192000000 10704219456 11085312000 1764527088 17.722 100 83 164 1 1801654496 13360736 23766672
23:05:52 3638 8192000000 10699437312 11089735680 1769090256 17.760 100 66 131 0 1799607616 11840656 18676704
23:06:03 3771 8192000000 10721804480 11104432128 1784639184 17.888 100 74 148 2 1816728688 11579840 20509664
23:06:14 3519 8192000000 10733577120 11114524672 1794977136 17.973 100 87 174 3 1831578496 12135072 24466288
23:06:23 11706 8192000000 10720582640 11110903808 1796348416 17.984 100 64 127 2 1825721168 12510112 16862640
23:06:43 2131 8192000000 10744595920 11126538240 1800937152 18.022 100 78 154 0 1834939984 12026944 21975888
23:06:53 3513 8192000000 10755847856 11143098368 1819091376 18.170 100 74 148 0 1851654336 11994064 20568896
23:07:04 4797 8192000000 10768706400 11153440768 1827968592 18.243 100 84 168 2 1864505360 13171408 23365360
23:07:16 2531 8192000000 10772384736 11161534464 1835749072 18.306 100 83 167 0 1872219904 13604464 22866368
23:07:25 2972 8192000000 10782241344 11164930048 1835623312 18.305 100 85 170 2 1871694688 12568400 23502976
23:07:34 3899 8192000000 10786464672 11168608256 1840996240 18.349 100 93 183 1 1880813824 14033360 25784224
23:07:45 2911 8192000000 10780912192 11167657984 1847436816 18.401 100 91 180 4 1886817584 14795600 24585168
23:07:54 2389 8192000000 10793096128 11176058880 1846283712 18.392 100 94 189 2 1887417296 14732016 26401568
23:08:03 1640 8192000000 10793244544 11181543424 1850454400 18.426 100 92 183 0 1890399456 14399152 25545904
23:08:11 1657 8192000000 10796985168 11182092288 1853055536 18.447 100 90 181 0 1891534544 13387984 25091024
23:08:20 1821 8192000000 10802179616 11187359744 1856558080 18.475 100 90 180 3 1895039088 12720976 25760032
23:08:28 2428 8192000000 10804810128 11192938496 1862663744 18.525 100 87 172 3 1900646160 13341344 24641072
23:08:37 1740 8192000000 10807307504 11195510784 1863057232 18.528 100 91 182 0 1902005152 13531888 25416032
23:08:45 2242 8192000000 10814767600 11200688128 1866086288 18.553 100 97 194 0 1908059408 14291472 27681648
23:08:54 2509 8192000000 10814275824 11200475136 1866950208 18.560 100 92 182 1 1906779088 13532288 26296592
23:09:02 1900 8192000000 10808483024 11200430080 1870547264 18.589 100 92 185 2 1910584848 13031248 27006336
23:09:11 1191 8192000000 10810154960 11205296128 1873460528 18.612 100 88 172 2 1910633216 12135264 25037424
23:09:18 28876 8192000000 10796535120 11201105920 1866822864 18.559 100 58 116 1 1894101680 9747024 17531792
23:09:53 2972 8192000000 10794461104 11202252800 1873513136 18.613 100 74 148 2 1905523824 10540960 21469728
23:10:05 1887 8192000000 10816150112 11207217152 1874743712 18.623 100 72 137 0 1904976512 11120048 19112752
23:10:13 2037 8192000000 10810115136 11209822208 1871962288 18.600 100 64 128 1 1901920416 11427184 18530944
23:10:21 4601 8192000000 10783623264 11202781184 1869207344 18.578 100 41 82 3 1890154160 9371776 11575040
23:10:33 5034 8192000000 10789429328 11200397312 1867823056 18.567 100 34 69 1 1884863328 7197344 9842928
23:10:45 5482 8192000000 10788899120 11210473472 1870122352 18.585 100 34 68 0 1888764976 8908304 9734320
23:10:58 3460 8192000000 10788867296 11208781824 1872511056 18.605 100 41 80 2 1890959808 6588624 11860128
23:11:09 6228 8192000000 10789838000 11210842112 1875712272 18.630 100 29 58 0 1890487792 6955888 7819632
23:11:23 6020 8192000000 10791133136 11215503360 1878362944 18.652 100 33 65 2 1895192768 7557648 9272176
23:11:38 9732 8192000000 10798060992 11217473536 1879157440 18.658 100 30 61 0 1895238896 7597264 8484192
23:11:53 8458 8192000000 10797831488 11217428480 1881855440 18.680 100 36 73 0 1898470992 5955616 10659936
23:12:09 8787 8192000000 10803083808 11226939392 1884413264 18.701 100 37 74 1 1907079712 12142480 10523968
23:12:24 16965 8192000000 10793384656 11220942848 1883228384 18.691 100 19 36 3 1894273424 5649920 5395120
23:12:50 15306 8192000000 10789825680 11227930624 1889258096 18.740 100 30 60 4 1904783216 6837056 8688064
23:13:14 66812 8192000000 10804714112 11236134912 1894737792 18.784 100 36 72 0 1910591248 5971264 9882192
23:14:27 9291 8192000000 10820863760 11237191680 1892641280 18.767 100 23 45 2 1904444096 5719872 6082944
23:14:43 5113 8192000000 10816592880 11242254336 1895546368 18.790 100 24 48 1 1907966064 5381456 7038240
23:14:54 2694 8192000000 10825972224 11252330496 1900200752 18.828 100 34 68 3 1921667104 12130032 9336320
23:15:04 3643 8192000000 10828883616 11250860032 1904206912 18.860 100 50 101 1 1925462016 6377872 14877232
23:15:15 5618 8192000000 10816840992 11248189440 1899892800 18.825 100 18 37 0 1910611904 5070656 5648448
23:15:28 7083 8192000000 10816837232 11249356800 1902488608 18.846 100 30 60 0 1918288848 7392048 8408192
23:15:43 6266 8192000000 10820774112 11246596096 1899288096 18.821 100 35 70 0 1917418368 7961536 10168736
23:15:57 8407 8192000000 10808495776 11249180672 1902355488 18.845 100 28 54 1 1916838240 7041264 7441488
23:16:11 8833 8192000000 10822914256 11254583296 1909430240 18.902 100 34 68 2 1925251872 5971712 9849920
23:16:26 7735 8192000000 10832742272 11258220544 1909360176 18.902 100 27 54 1 1924775728 5517440 9898112
23:16:42 4613 8192000000 10810455264 11245252608 1897252432 18.804 100 20 40 0 1908829168 5812512 5764224
23:16:55 7829 8192000000 10814474096 11244527616 1888247056 18.732 99 30 59 1 1903073568 5901136 8925376
23:17:11 7198 8192000000 10808865232 11235500032 1861346320 18.514 98 16 32 0 1870743920 4867408 4530192
23:17:26 65061 8192000000 10822952288 11232874496 1840069184 18.341 97 38 74 3 1855480144 5018304 10392656
23:18:37 14264 8192000000 10765814960 11200819200 1821025584 18.186 97 30 60 0 1835252208 5058576 9168048
23:19:00 6662 8192000000 10707032320 11124633600 1728419120 17.422 93 16 31 0 1738807680 5813280 4575280
23:19:15 7192 8192000000 10730384816 11151257600 1763198624 17.711 96 41 81 1 1780776464 6398928 11178912
23:19:30 7710 8192000000 10740329984 11155140608 1772012688 17.784 97 21 42 1 1783870976 5925744 5932544
23:19:45 7225 8192000000 10740739760 11162718208 1786979424 17.907 97 18 36 1 1801472896 9463344 5030128
23:20:00 6787 8192000000 10748222896 11165134848 1776703072 17.822 96 33 64 1 1792727088 5742288 10281728
23:20:13 6900 8192000000 10740358544 11156463616 1782698144 17.872 97 25 50 2 1795942720 4765040 8479536
23:20:27 9544 8192000000 10708935056 11111149568 1753535808 17.631 97 19 38 0 1763996192 4984432 5475952
23:20:44 6431 8192000000 10694546704 11105492992 1753144464 17.628 98 23 45 1 1766403152 5652336 7606352
23:20:59 14758 8192000000 10712635104 11122065408 1767009072 17.742 98 31 61 0 1781813792 5753424 9051296
23:21:21 11560 8192000000 10707061024 11131686912 1771118016 17.776 98 32 64 1 1786704000 5631536 9954448
23:21:39 6734 8192000000 10741493728 11157991424 1816555648 18.150 100 19 38 1 1827741008 5780656 5404704
23:21:52 8888 8192000000 10714241536 11133779968 1742876768 17.543 96 26 52 0 1755524720 5147424 7500528
23:22:08 9230 8192000000 10705456016 11129204736 1760676064 17.690 98 14 29 1 1769633536 5159136 3798336
23:22:27 74265 8192000000 10731405728 11157610496 1796818272 17.988 99 21 40 1 1807303712 5167520 5317920
23:23:47 11787 8192000000 10748841680 11167412224 1812155328 18.114 99 29 59 2 1827001952 6114544 8732080
23:24:07 5079 8192000000 10750948672 11179655168 1840370560 18.344 100 39 78 2 1859137824 7850224 10917040
23:24:18 6067 8192000000 10744487024 11172425728 1828243664 18.245 99 45 90 0 1848145104 5898288 14003152
23:24:33 3165 8192000000 10769982176 11185283072 1844725296 18.379 100 20 40 0 1856241984 5601072 5915616
23:24:45 2578 8192000000 10781237248 11197628416 1854112048 18.456 100 39 78 0 1873404128 8694816 10597264
23:24:56 11596 8192000000 10764371728 11193761792 1854396528 18.458 100 24 48 0 1867018832 5040048 7582256
23:25:19 5456 8192000000 10782916064 11203579904 1862345360 18.522 100 36 68 2 1879464784 6209744 10909680
23:25:33 5071 8192000000 10778525680 11208110080 1861066928 18.512 100 24 48 2 1874583648 6202816 7313904
23:25:48 9396 8192000000 10770675184 11207348224 1865111296 18.545 100 20 40 3 1875965552 5251360 5602896
23:26:07 9238 8192000000 10778232384 11209809920 1869133376 18.577 100 18 36 0 1879639744 5965024 4541344
23:26:25 16728 8192000000 10789080640 11218714624 1873794272 18.615 100 19 38 1 1885075904 5102512 6179120
23:26:49 105546 8192000000 10811970736 11240960000 1884578464 18.702 100 27 54 4 1897702336 5397760 7726112
23:28:44 46329 8192000000 10843508592 11270610944 1913615680 18.936 100 35 68 1 1936485184 13483872 9385632
23:29:37 10317 8192000000 10859459440 11281489920 1924797888 19.025 100 54 108 1 1951935968 10898640 16239440
23:29:57 5448 8192000000 10876229152 11292479488 1935161968 19.108 100 76 152 1 1969778336 13531488 21084880
23:30:15 8319 8192000000 10870011792 11295748096 1936471168 19.119 100 59 117 0 1966301024 12853440 16976416
23:30:33 3397 8192000000 10882812272 11301564416 1940494416 19.151 100 62 121 1 1970274960 12194512 17586032
23:30:44 14480 8192000000 10870772816 11300454400 1943068016 19.171 100 61 120 1 1973868112 12996544 17803552
23:31:09 19134 8192000000 10880545776 11303436288 1949646160 19.224 100 57 110 0 1977679600 11996816 16036624
23:31:40 24508 8192000000 10888565040 11318452224 1952295200 19.245 100 48 94 0 1980637840 15449696 12892944
23:32:18 22033 8192000000 10889250704 11326504960 1956095264 19.275 100 41 82 2 1985683152 17240912 12346976
23:32:50 22524 8192000000 10905139840 11336990720 1963425632 19.333 100 37 72 0 1992990832 18688816 10876384
23:33:22 2358 8192000000 10917358400 11342716928 1970867600 19.392 100 59 118 0 2007210384 18995680 17347104
23:33:32 3832 8192000000 10929453408 11351318528 1974751824 19.423 100 70 138 3 2016807488 21882688 20172976
23:33:43 4043 8192000000 10936877840 11352207360 1977549264 19.445 100 66 133 0 2018604768 22021920 19033584
23:33:55 22350 8192000000 10928379536 11358752768 1977966928 19.449 100 61 122 0 2018589472 23457904 17164640
23:34:24 11384 8192000000 10931023280 11362095104 1980282896 19.467 100 54 108 0 2020165216 24171680 15710640
23:34:43 9548 8192000000 10932952112 11361333248 1982510016 19.485 100 59 115 2 2023068144 23912688 16645440
23:35:00 5977 8192000000 10943091296 11366805504 1987021968 19.520 100 68 136 0 2030133296 23341424 19769904
23:35:13 4020 8192000000 10946125376 11363827712 1988728192 19.534 100 74 148 0 2033314096 23346144 21239760
23:35:25 11268 8192000000 10937856224 11365584896 1988235248 19.530 100 65 130 1 2030740192 23547680 18957264
23:35:46 4293 8192000000 10969137680 11383771136 1998548160 19.611 100 75 150 3 2047887072 26890480 22448432
23:35:57 2674 8192000000 10959857184 11380047872 1981116912 19.474 99 83 167 2 2032332656 27120192 24095552
23:36:06 4245 8192000000 10937406128 11363323904 1977945984 19.448 100 70 138 1 2023424384 26197104 19281296
23:36:18 3818 8192000000 10943196384 11355205632 1965391248 19.349 99 76 149 4 2012748208 26701424 20655536
23:36:28 2918 8192000000 10952281488 11365883904 1979856608 19.464 100 78 156 0 2031594720 27697520 24040592
23:36:38 2771 8192000000 10935568144 11360616448 1963755904 19.336 99 75 148 1 2013142336 28484496 20901936
23:36:48 6214 8192000000 10944311728 11365892096 1981725872 19.478 100 75 149 1 2029276912 25841648 21709392
23:37:01 1599 8192000000 10951550832 11371544576 1988387584 19.531 100 80 159 4 2038162880 26455280 23320016
23:37:12 5287 8192000000 10931440864 11369525248 1985593024 19.509 100 56 110 0 2027622000 25775408 16253568
23:37:27 16787 8192000000 10929360720 11371786240 1971981616 19.401 99 60 118 1 2016421040 27469392 16970032
23:38:09 7805 8192000000 10961385360 11386068992 1998218992 19.609 100 59 118 0 2045757824 30167712 17371120
23:38:27 9468 8192000000 10940233664 11372306432 1969784304 19.384 99 59 118 0 2015037584 27678240 17575040
23:38:45 4561 8192000000 10932683888 11361280000 1971493328 19.397 100 57 112 2 2016870768 28851984 16525456
23:39:02 5058 8192000000 10944922512 11362336768 1964676000 19.343 99 73 144 1 2017275152 31503904 21095248
23:39:20 7465 8192000000 10945480576 11368804352 1976287136 19.435 100 72 140 1 2029546704 32202144 21057424
23:39:35 2248 8192000000 10941856448 11368439808 1979506000 19.461 100 66 132 0 2031625056 32339312 19779744
23:39:45 3616 8192000000 10938005440 11350818816 1949800512 19.225 98 72 144 0 2002429200 31120624 21508064
23:39:57 3677 8192000000 10963885744 11373334528 1984232016 19.498 100 75 148 3 2039310464 33115264 21963184
23:40:07 7665 8192000000 10962942448 11386335232 1990183056 19.545 100 66 132 0 2044582064 34051472 20347536
23:40:24 4504 8192000000 10954666240 11378991104 1986111200 19.513 100 70 136 1 2040763408 33441968 21210240
23:40:35 3771 8192000000 10941159952 11364605952 1971761888 19.399 99 68 136 2 2026659152 33936000 20961264
23:40:46 5048 8192000000 10935940720 11358892032 1946179376 19.196 98 66 131 2 2000139456 34363072 19597008
23:41:00 5467 8192000000 10938191760 11356835840 1959204736 19.300 100 75 148 0 2016539472 35099648 22235088
23:41:14 2304 8192000000 10919037488 11340591104 1920716016 18.993 98 73 146 2 1978049088 35611728 21721344
23:41:25 3894 8192000000 10932638016 11355082752 1961568704 19.319 100 69 138 0 2019293008 36569776 21154528
23:41:35 3027 8192000000 10922267728 11330924544 1930445776 19.070 98 73 144 2 1989471328 36625488 22400064
23:41:45 1334 8192000000 10939223104 11346432000 1958104320 19.291 100 80 160 0 2014487776 32220784 24162672
23:41:53 2964 8192000000 10931083904 11345072128 1961470736 19.318 100 82 164 1 2021648000 33821936 26355328
23:42:03 1482 8192000000 10946470400 11354025984 1966753216 19.360 100 92 184 3 2028027104 34065360 27208528
23:42:13 3659 8192000000 10954698992 11363299328 1973049392 19.410 100 84 167 0 2033735568 34872032 25814144
23:42:25 4995 8192000000 10947574400 11362676736 1956042256 19.275 99 71 142 1 2011952176 34226560 21683360
23:42:40 3057 8192000000 10940679744 11352748032 1960655360 19.311 100 86 171 0 2023044544 34978432 27410752
23:42:55 8714 8192000000 10939599024 11357483008 1961052832 19.314 100 73 146 4 2024860256 40116880 23690544
23:43:10 5700 8192000000 10945315872 11368718336 1968829392 19.376 100 79 159 1 2033127312 39270304 25027616
23:43:25 11106 8192000000 10945522496 11368210432 1964432352 19.341 100 66 130 1 2026715264 40729472 21553440
23:43:43 12873 8192000000 10942337392 11374686208 1971777488 19.400 100 56 112 1 2029200176 39583536 17839152
23:44:08 7659 8192000000 10939892128 11365273600 1965181792 19.347 100 65 128 1 2027376784 41182384 21012608
23:44:22 8207 8192000000 10947548464 11362643968 1963739328 19.336 100 72 146 0 2030492832 43060240 23693264
23:44:38 3225 8192000000 10962980064 11376074752 1974089968 19.418 100 80 160 0 2044851360 45276512 25484880
23:44:48 4657 8192000000 10956823408 11371466752 1967970096 19.369 100 84 167 1 2042766864 47719168 27077600
23:45:02 4980 8192000000 10965816416 11388866560 1980407072 19.468 100 77 154 1 2052247104 47324320 24515712
23:45:15 5965 8192000000 10965183904 11386228736 1977247648 19.443 100 72 145 1 2044727328 45053472 22426208
23:45:30 2959 8192000000 10977411056 11397439488 1984195360 19.498 100 84 168 1 2057338880 46905424 26238096
23:45:41 2955 8192000000 10964703664 11375550464 1958312736 19.293 99 91 181 1 2033094384 46873168 27908480
23:45:55 2893 8192000000 10957328704 11365642240 1963832112 19.336 100 82 159 1 2031939824 42345120 25762592
23:46:06 2156 8192000000 10959265808 11371933696 1969758736 19.384 100 93 185 3 2040748960 42278080 28712144
23:46:16 2390 8192000000 10956652896 11363721216 1962176336 19.323 100 81 162 1 2028633744 41105328 25352080
23:46:25 3543 8192000000 10959917120 11368632320 1970562912 19.390 100 80 158 4 2034030544 39251824 24215808
23:46:35 1753 8192000000 10967115088 11379884032 1979369232 19.460 100 86 170 0 2045077824 39726384 25982208
23:46:44 5859 8192000000 10953627088 11384844288 1982872080 19.487 100 58 116 0 2039565824 38872608 17821136
23:47:00 1966 8192000000 10944279152 11367067648 1966166480 19.355 99 68 135 2 2025340592 38034336 21139776
23:47:12 2544 8192000000 10979262672 11389308928 1988500848 19.532 100 87 173 3 2056964560 41261392 27202320
23:47:21 3889 8192000000 10981362528 11390222336 1986743184 19.518 100 89 174 0 2057137440 43025280 27368976
23:47:33 2608 8192000000 10965445344 11379687424 1975713696 19.431 100 93 185 0 2049013856 45325936 27974224
23:47:43 6662 8192000000 10944449392 11380224000 1973915264 19.416 100 55 110 0 2036715168 44658176 18141728
23:48:12 8657 8192000000 10947341552 11380731904 1971722544 19.399 100 50 100 0 2032533344 44472624 16338176
23:48:31 11797 8192000000 10922466560 11366588416 1942690304 19.168 99 41 82 0 2004191280 47277792 14223184
23:48:54 5366 8192000000 10923254912 11357323264 1932191408 19.084 99 40 79 1 1992828752 46503280 14134064
23:49:07 3927 8192000000 10956582192 11372412928 1941191808 19.156 99 84 167 0 2014773648 47693408 25888432
23:49:19 2661 8192000000 10958688048 11378417664 1959877616 19.305 100 74 147 1 2037329248 53402272 24049360
23:49:38 3549 8192000000 10959043776 11381751808 1962998432 19.330 100 61 121 2 2037634112 55162320 19473360
23:49:50 6426 8192000000 10922863376 11360854016 1930915712 19.074 98 55 110 0 2005814496 56259728 18639056
23:50:10 17677 8192000000 10954625504 11386396672 1958755680 19.296 100 46 92 3 2031633984 56309680 16568624
23:50:34 2359 8192000000 10953045504 11368615936 1940116240 19.148 99 77 154 0 2025908688 60218608 25573840
23:50:45 8820 8192000000 10939822416 11382964224 1957754528 19.288 100 55 110 1 2034651296 58551744 18345024
23:51:01 4535 8192000000 10929538416 11374358528 1951622576 19.239 100 35 70 1 2013563552 49306352 12634624
23:51:21 6961 8192000000 10938632368 11368607744 1955464432 19.270 100 35 70 1 2014313504 46712976 12136096
23:51:34 15997 8192000000 10929823696 11366572032 1925326784 19.029 98 41 82 0 1986762288 47983552 13451952
23:52:03 5506 8192000000 10930304944 11368128512 1955756000 19.272 100 36 72 1 2011208576 43457648 11994928
23:52:16 14883 8192000000 10906982736 11346075648 1922334688 19.006 99 36 72 1 1975828272 41057520 12436064
23:52:44 35744 8192000000 10906140320 11360829440 1944280560 19.181 100 27 54 1 1990045968 36701728 9063680
23:53:42 31676 8192000000 10913800736 11374927872 1955356864 19.269 100 27 54 1 2004668448 40205344 9106240
23:54:32 24321 8192000000 10914713632 11371593728 1941692816 19.160 99 28 56 1 1986315824 35504368 9118640
23:55:05 24305 8192000000 10915747888 11374755840 1949326560 19.221 100 19 38 0 1993992608 37920128 6745920
23:55:36 19410 8192000000 10916151744 11375464448 1946835840 19.201 100 21 42 1 1991668784 38913088 5919856
23:56:03 25290 8192000000 10889570960 11351506944 1931398160 19.078 99 16 32 3 1974759504 38361056 5000288
23:56:37 23596 8192000000 10897721152 11360833536 1926604336 19.040 99 18 36 1 1977230272 44522336 6103600
23:57:13 30736 8192000000 10903703040 11360874496 1924109408 19.020 99 16 32 0 1965397360 35932336 5355616
23:57:50 38037 8192000000 10893057936 11357917184 1924043248 19.019 99 11 22 0 1957431920 29930752 3457920
23:58:34 63763 8192000000 10895338640 11348226048 1936790352 19.121 99 20 40 0 1952461712 10093328 5578032
23:59:50 86124 8192000000 10904646272 11378503680 1953302960 19.253 99 13 26 0 1966583872 10455264 2825648
00:01:29 151005 8192000000 10918964064 11404312576 1917376416 18.966 97 9 18 0 1947621696 28351856 1893424
00:04:09 97336 8192000000 10941706880 11369508864 1935954160 19.114 98 20 40 2 1965942288 24390560 5597568
00:06:01 125766 8192000000 10914980416 11379859456 1988948496 19.535 100 49 98 1 2013718512 9334640 15435376
00:08:22 26112 8192000000 10920977584 11375325184 1964223472 19.340 99 17 33 1 1975067584 6560352 4283760
00:08:56 62497 8192000000 10937886656 11388792832 1986935680 19.520 100 31 62 2 2004368832 9130288 8302864
00:10:31 13390 8192000000 10951283808 11394478080 1997561424 19.603 100 51 101 2 2021340400 9993536 13785440
00:11:07 9100 8192000000 10943486400 11399307264 1999895328 19.622 100 45 90 3 2023453536 11349120 12209088
00:11:26 25927 8192000000 10942883680 11402182656 2004340752 19.657 100 43 87 1 2029821008 13321376 12158880
00:11:59 8357 8192000000 10947258688 11405103104 2001932064 19.638 100 39 78 3 2024158304 10753248 11472992
00:12:18 28498 8192000000 10933838080 11406143488 2003473024 19.650 100 27 54 2 2022101984 10499040 8129920
00:13:03 38186 8192000000 10928395824 11404918784 1987200496 19.522 99 16 32 0 2005773120 13717440 4855184
00:13:48 19609 8192000000 10939627664 11409346560 2000726784 19.628 100 13 26 2 2017466096 13168576 3570736
00:14:15 21769 8192000000 10959010640 11417440256 2010271360 19.704 100 46 92 0 2038180672 14482384 13426928
00:14:45 26797 8192000000 10961264896 11417321472 2013256544 19.727 100 58 109 2 2046223072 15776704 17189824
00:15:20 23772 8192000000 10946353776 11404353536 1983423760 19.492 99 53 106 3 2016913616 17858192 15631664
00:15:56 40591 8192000000 10914247680 11408723968 1993506528 19.571 100 10 20 0 2014291968 17780592 3004848
00:16:43 24920 8192000000 10915496256 11400237056 1979147488 19.458 99 15 31 0 1996247664 12454496 4645680
00:17:58 58804 8192000000 10905187952 11386519552 1956571984 19.279 98 12 24 0 1971410064 11530080 3308000
00:19:03 51262 8192000000 10921078192 11394842624 1966030528 19.354 99 18 36 2 1983907248 12337936 5538784
00:20:27 45531 8192000000 10892740688 11369185280 1921499696 18.999 97 7 14 0 1935533392 11973120 2060576
00:21:19 108376 8192000000 10879756928 11367272448 1930807472 19.073 98 20 40 0 1952074816 15488240 5779104
00:23:51 65510 8192000000 10879783104 11354619904 1946632096 19.200 99 25 50 1 1960582992 6866032 7084864
00:25:06 26075 8192000000 10881977648 11353919488 1922400272 19.006 98 26 53 1 1939537200 9545552 7591376
00:25:41 36212 8192000000 10855537568 11340095488 1922604896 19.008 99 7 14 1 1937140064 12582896 1952272
00:26:24 25494 8192000000 10859814304 11336429568 1937926544 19.130 100 8 16 0 1952684320 12551024 2206752
00:26:59 55246 8192000000 10852154864 11333816320 1920021136 18.987 99 17 34 4 1936808672 12388432 4399104
00:28:05 47861 8192000000 10838951904 11329363968 1873797680 18.615 97 5 10 0 1887357568 12431632 1128256
00:28:59 48290 8192000000 10853449808 11325009920 1902024544 18.843 98 11 22 0 1913937104 8426688 3485872
00:29:56 36192 8192000000 10863803120 11338948608 1935764752 19.113 100 31 62 0 1954841424 10321440 8755232
00:30:39 40200 8192000000 10876326208 11358642176 1941370864 19.158 100 7 14 0 1952354576 9209744 1773968
00:31:52 64601 8192000000 10870739424 11346083840 1898910048 18.818 97 18 36 3 1920748736 16721664 5117024
00:33:07 37625 8192000000 10881908736 11332206592 1890005680 18.746 97 25 51 0 1917534752 19804336 7724736
00:33:53 59063 8192000000 10856099712 11318632448 1855078560 18.463 96 22 44 0 1870493024 9246480 6167984
00:35:08 51279 8192000000 10862476480 11322970112 1891538880 18.758 98 30 60 1 1915142816 15332480 8271456
00:36:14 21757 8192000000 10881295680 11328835584 1892550064 18.766 98 46 93 1 1925254368 19353296 13351008
00:36:42 36474 8192000000 10882379296 11346481152 1933345296 19.094 100 30 60 1 1958098304 16397584 8355424
00:37:34 64062 8192000000 10864565104 11333246976 1863967952 18.535 96 14 28 1 1885153584 16974000 4211632
00:38:46 107194 8192000000 10877153984 11353214976 1909021152 18.899 99 10 20 0 1928503776 16564704 2917920
00:40:45 56852 8192000000 10860560576 11343298560 1897658416 18.807 98 11 22 0 1923242432 22275936 3308080
00:41:57 59036 8192000000 10905985120 11364659200 1957774192 19.288 100 43 86 1 1982508368 13467456 11266720
00:43:03 89589 8192000000 10882189520 11354005504 1941265136 19.157 99 41 82 1 1965643632 11995744 12382752
00:45:43 45365 8192000000 10862779104 11331563520 1905480480 18.870 98 18 36 4 1924836640 14453872 4902288
00:46:46 56445 8192000000 10819606240 11294785536 1831649632 18.273 95 8 16 1 1840668400 6871360 2147408
00:47:50 90358 8192000000 10830417776 11307548672 1851851232 18.437 96 16 32 1 1864590192 7734160 5004800
00:49:27 74333 8192000000 10860192304 11336269824 1893813648 18.777 98 15 30 0 1912360320 14506448 4040224
00:50:47 79358 8192000000 10853788352 11331145728 1899618032 18.823 98 10 20 0 1917290816 14626448 3046336
00:54:12 67137 8192000000 10848514896 11328188416 1877034112 18.641 97 9 18 0 1889212832 9840752 2337968
00:55:33 31443 8192000000 10871318368 11330117632 1932073328 19.083 100 29 58 2 1947938288 7895456 7969504
00:56:12 50878 8192000000 10877069456 11351322624 1945574096 19.191 100 18 36 1 1960405888 9678720 5153072
00:57:15 62385 8192000000 10880447392 11360268288 1951036688 19.235 99 38 76 1 1973005952 11097184 10872080
00:58:36 71645 8192000000 10882334096 11356065792 1924632144 19.024 98 9 18 1 1939276784 12614688 2029952
00:59:54 22193 8192000000 10900061808 11361890304 1949019728 19.219 99 35 70 0 1969952176 11648720 9283728
01:00:25 27807 8192000000 10909046336 11364974592 1954726128 19.264 99 37 74 1 1977682784 13003440 9953216
01:01:01 27983 8192000000 10929080032 11392069632 1982565776 19.485 100 45 89 0 2008907408 12691792 13649840
01:01:41 45309 8192000000 10915052928 11390742528 1983587888 19.493 100 27 54 2 2004484096 13488896 7407312
01:02:33 30094 8192000000 10918649776 11378495488 1964892000 19.345 99 37 74 1 1988823440 14380800 9550640
01:03:13 32185 8192000000 10909552192 11374133248 1941683760 19.160 98 32 64 2 1960591344 10102592 8804992
01:03:57 15130 8192000000 10915676064 11365646336 1902393104 18.846 96 38 75 1 1920911232 8479728 10038400
01:04:19 22005 8192000000 10899646576 11365679104 1951195712 19.236 99 38 76 1 1971901552 10081072 10624768
01:04:49 42494 8192000000 10926004608 11382685696 1950705536 19.232 99 26 53 2 1968243456 9863152 7674768
01:05:43 103639 8192000000 10924866720 11389960192 1970693936 19.391 99 11 22 0 1983426112 10170720 2561456
01:07:33 24414 8192000000 10937161408 11389444096 1954825680 19.265 98 44 88 0 1976755296 9972800 11956816
01:08:11 41524 8192000000 10898235024 11384360960 1924901840 19.026 97 33 66 1 1946423504 12455376 9066288
01:09:39 60006 8192000000 10901467152 11379675136 1976584064 19.438 100 11 22 0 1987789392 8208688 2996640
01:12:00 61729 8192000000 10891762832 11383136256 1945915264 19.194 98 15 30 0 1961293696 10331168 5047264
01:13:10 62200 8192000000 10865534304 11365576704 1926978848 19.043 98 6 12 0 1937364960 8644592 1741520
01:14:50 75653 8192000000 10888304256 11363627008 1938312176 19.133 99 20 40 1 1953875936 9773248 5790512
01:16:17 61362 8192000000 10891027376 11370106880 1950360864 19.229 99 24 49 0 1966407824 9231232 6815728
01:17:24 78865 8192000000 10871813424 11364880384 1902575616 18.847 97 15 30 2 1924155680 17565392 4014672
01:18:58 33531 8192000000 10852447776 11320672256 1839817424 18.339 94 26 52 2 1853532608 6678672 7036512
01:19:46 49797 8192000000 10846539280 11318456320 1868643408 18.573 97 21 42 0 1886395936 11828064 5924464
01:20:46 25893 8192000000 10837584784 11293884416 1867993744 18.568 97 24 48 0 1884739168 9710736 7034688
01:21:21 50511 8192000000 10842635536 11325095936 1903494944 18.854 99 32 64 2 1926440608 13668944 9276720
01:22:31 47281 8192000000 10873268816 11332526080 1875935360 18.632 97 22 44 1 1890246928 8515600 5795968
01:23:25 66825 8192000000 10872684064 11342970880 1917126992 18.964 99 34 67 0 1941471120 14724672 9619456
01:25:06 105398 8192000000 10861443344 11347099648 1887738192 18.728 97 13 26 0 1904579744 13519248 3322304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 04-04-2021 01:28:14 to 04-04-2021 01:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-04-2021 01:28:48 to 04-04-2021 01:28:50.

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          242826
MON$OLDEST_ACTIVE               243634
MON$OLDEST_SNAPSHOT             243634
MON$NEXT_TRANSACTION            243634
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                       2046112
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.33435 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33435 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33435 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33435 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 ---
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:30 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
:73: 
:74: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:75:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:76: 
:77: 
:78: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:79:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:80: 
:81: 
:82: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:83:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:84: 
:85: 
:86: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:87:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:88: 
:89: 
:90: mscs-test-161.budzdorov.ru    Sun Apr  4 01:27:32 2021
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:92: 
--- end of diff output ---

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

04.04.21 01:28:51. 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 01:28:53 No severe PSQL-related problems occured
04.04.21 01:28:55. End of report.