Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.01.2021 22: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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16939656 kB
MemAvailable 31321120 kB
Buffers 0 kB
Cached 14762956 kB
SwapCached 4868 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-01-21 22:27:11
DTS_END                         2021-01-21 22:27:11.2150
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/49668
TRN_ID                          245114
ATT_ID                          656
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: 9604.37 21011 1152524
customer order: creation 177.74 348 21329
customer order: refuse 16.02 307 1923
order to supplier: creation 47.43 1249 5692
order to supplier: removal 3.47 106258 416
invoice (draft): creation 47.04 3596 5645
invoice (draft): removal 54.78 786 6574
invoice accept: apply 43.68 17718 5241
invoice accept: cancel 49.62 793 5954
customer reserve: creation 3982.84 177 477941
customer reserve: removal 4875.10 59 585012
realization accept: apply 87.05 179 10446
realization accept: cancel 85.72 107 10286
payment from customer: creation 61.02 114 7322
payment from customer: removal 5.75 67 690
payment to supplier: creation 50.89 128 6107
payment to supplier: removal 3.43 92 412
service: total inventory turnovers 4.94 1113 593
service: total monetary turnovers 6.93 39 832
service: aggregate perf. data 0.88 17073 105
service: refresh index statistics 0.03 270025 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-01-2021 22:29:06 to 21-01-2021 22:29:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6501
TEST_TIME 2 5603
TEST_TIME 3 5210
TEST_TIME 4 5135
TEST_TIME 5 5226
TEST_TIME 6 4988
TEST_TIME 7 5478
TEST_TIME 8 5782
TEST_TIME 9 5697
TEST_TIME 10 6134
TEST_TIME 11 6138
TEST_TIME 12 6676
TEST_TIME 13 6756
TEST_TIME 14 6654
TEST_TIME 15 6885
TEST_TIME 16 6923
TEST_TIME 17 7213
TEST_TIME 18 7638
TEST_TIME 19 8012
TEST_TIME 20 8088
TEST_TIME 21 8398
TEST_TIME 22 8755
TEST_TIME 23 8776
TEST_TIME 24 9194
TEST_TIME 25 9224
TEST_TIME 26 10087
TEST_TIME 27 10052
TEST_TIME 28 10144
TEST_TIME 29 10875
TEST_TIME 30 10679
TEST_TIME 31 10995
TEST_TIME 32 10784
TEST_TIME 33 10850
TEST_TIME 34 10683
TEST_TIME 35 10774
TEST_TIME 36 10752
TEST_TIME 37 10647
TEST_TIME 38 10495
TEST_TIME 39 10357
TEST_TIME 40 10549
TEST_TIME 41 10495
TEST_TIME 42 10282
TEST_TIME 43 10119
TEST_TIME 44 10119
TEST_TIME 45 9935
TEST_TIME 46 9910
TEST_TIME 47 9803
TEST_TIME 48 9795
TEST_TIME 49 10021
TEST_TIME 50 9950
TEST_TIME 51 9868
TEST_TIME 52 9749
TEST_TIME 53 9748
TEST_TIME 54 9745
TEST_TIME 55 9833
TEST_TIME 56 9816
TEST_TIME 57 9712
TEST_TIME 58 9874
TEST_TIME 59 9882
TEST_TIME 60 9859
TEST_TIME 61 9918
TEST_TIME 62 9948
TEST_TIME 63 9941
TEST_TIME 64 9944
TEST_TIME 65 9907
TEST_TIME 66 10028
TEST_TIME 67 10101
TEST_TIME 68 10024
TEST_TIME 69 9919
TEST_TIME 70 9871
TEST_TIME 71 9913
TEST_TIME 72 9839
TEST_TIME 73 9832
TEST_TIME 74 9779
TEST_TIME 75 9777
TEST_TIME 76 9720
TEST_TIME 77 9710
TEST_TIME 78 9674
TEST_TIME 79 9614
TEST_TIME 80 9572
TEST_TIME 81 9534
TEST_TIME 82 9510
TEST_TIME 83 9476
TEST_TIME 84 9549
TEST_TIME 85 9550
TEST_TIME 86 9594
TEST_TIME 87 9599
TEST_TIME 88 9577
TEST_TIME 89 9646
TEST_TIME 90 9679
TEST_TIME 91 9694
TEST_TIME 92 9711
TEST_TIME 93 9746
TEST_TIME 94 9794
TEST_TIME 95 9836
TEST_TIME 96 9838
TEST_TIME 97 9759
TEST_TIME 98 9753
TEST_TIME 99 9684
TEST_TIME 100 9675
TEST_TIME 101 9619
TEST_TIME 102 9556
TEST_TIME 103 9589
TEST_TIME 104 9595
TEST_TIME 105 9628
TEST_TIME 106 9610
TEST_TIME 107 9590
TEST_TIME 108 9595
TEST_TIME 109 9596
TEST_TIME 110 9588
TEST_TIME 111 9625
TEST_TIME 112 9632
TEST_TIME 113 9766
TEST_TIME 114 9758
TEST_TIME 115 9760
TEST_TIME 116 9766
TEST_TIME 117 9756
TEST_TIME 118 9704
TEST_TIME 119 9684
TEST_TIME 120 9608

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-01-2021 22:29:10 to 21-01-2021 22:29:13.

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 1595750 1595750 0 0.00 0 26239 6 0 0
doc_list_biud 1595750 1595750 0 0.00 0 23404 27 0 0
sp_add_invoice_to_stock 5393 5241 152 2.81 23 174536 17719 0 152
sp_cancel_adding_invoice 5954 5954 0 0.00 4 64044 793 0 0
sp_cancel_client_order 1923 1923 0 0.00 4 4801 307 0 0
sp_cancel_customer_reserve 585012 585012 0 0.00 1 19950 59 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 3 3635 68 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 6924 93 0 0
sp_cancel_supplier_invoice 6586 6574 12 0.18 2 15792 786 0 12
sp_cancel_supplier_order 416 416 0 0.00 6 1170537 106259 0 0
sp_cancel_write_off 10286 10286 0 0.00 1 9150 107 0 0
sp_client_order 21329 21329 0 0.00 3 22466 348 0 0
sp_customer_reserve 477941 477941 0 0.00 0 59633 178 0 0
sp_fill_shopping_cart 32658 32658 0 0.00 1 16754 40 0 0
sp_fill_shopping_cart_clo_res 477939 477939 0 0.00 0 26463 14 0 0
sp_get_clo_for_invoice 5236 5236 0 0.00 0 22527 259 0 0
sp_kill_cost_storno 17342 17342 0 0.00 0 7153 59 0 0
sp_kill_qstorno_ret_qs2qd 1187300 1187300 0 0.00 0 19934 32 0 0
sp_kill_qty_storno 625847 625847 0 0.00 0 23404 69 0 0
sp_lock_selected_doc 21768 21768 0 0.00 0 7405 7 0 0
sp_make_cost_storno 29111 29111 0 0.00 0 13638 58 0 0
sp_multiply_rows_for_pdistr 29111 29111 0 0.00 0 8477 31 0 0
sp_multiply_rows_for_qdistr 21329 21329 0 0.00 0 13242 151 0 0
sp_pay_from_customer 7322 7322 0 0.00 4 9912 115 0 0
sp_pay_to_supplier 6107 6107 0 0.00 5 12164 129 0 0
sp_payment_common 13429 13429 0 0.00 1 8182 32 0 0
sp_qd_handle_on_cancel_clo 1923 1923 0 0.00 0 4491 287 0 0
sp_qd_handle_on_invoice_upd_sts 11190 11190 0 0.00 0 14573 345 0 0
sp_qd_handle_on_reserve_upd_sts 10446 10446 0 0.00 0 23403 56 0 0
sp_reserve_write_off 10446 10446 0 0.00 7 23415 180 0 0
sp_supplier_invoice 5645 5645 0 0.00 6 84957 3597 0 0
sp_supplier_order 5692 5692 0 0.00 5 77830 1250 0 0
srv_aggregate_perf_data 105 105 0 0.00 2804 80667 17073 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 915 125834 30014 0 0
srv_find_qd_qs_mism 1103538 1103538 0 0.00 0 26237 5 0 0
srv_make_invnt_saldo 593 593 0 0.00 31 65652 1113 0 0
srv_make_money_saldo 832 832 0 0.00 0 7511 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 156787 421637 270025 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5241 5241 0 0.00 0 13924 159 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 3527 86 0 0
t$perf-norm:sp_cancel_client_order 1923 1923 0 0.00 0 21584 22 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 1200 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 385 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 4932 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 437 437 0 0.00 0 1277 14 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 23475 1911 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 2552 8 0 0
t$perf-norm:sp_client_order 21329 21329 0 0.00 0 22887 18 0 0
t$perf-norm:sp_customer_reserve 976 976 0 0.00 0 3501 6 0 0
t$perf-norm:sp_pay_from_customer 7322 7322 0 0.00 0 3553 7 0 0
t$perf-norm:sp_pay_to_supplier 6107 6107 0 0.00 0 5257 8 0 0
t$perf-norm:sp_reserve_write_off 10446 10446 0 0.00 0 21865 14 0 0
t$perf-norm:sp_supplier_invoice 5645 5645 0 0.00 0 15317 24 0 0
t$perf-norm:sp_supplier_order 5692 5692 0 0.00 0 15216 18 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 630 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 1005 16 0 0
t$perf-norm:srv_make_invnt_saldo 593 593 0 0.00 0 3360 24 0 0
t$perf-norm:srv_make_money_saldo 832 832 0 0.00 0 538 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10776 10472 304 2.82 0 3754 17 0 304
v_all_customers 38904 38904 0 0.00 0 32 1 0 0
v_all_suppliers 31422 31422 0 0.00 0 18 1 0 0
v_all_wares 42658 42658 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 368 5 0 0
v_cancel_client_order 3846 3846 0 0.00 0 1110 3 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 2157 4 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 1049 3 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 854 4 0 0
v_cancel_supplier_invoice 898 874 24 2.67 0 2860 17 0 24
v_cancel_supplier_order 832 832 0 0.00 0 382 4 0 0
v_cancel_write_off 2110 2110 0 0.00 0 2244 13 0 0
v_max_id_clo_ord 5691 5691 0 0.00 0 165 1 0 0
v_max_id_clo_res 976 976 0 0.00 0 3047 14 0 0
v_max_id_ord_sup 5638 5638 0 0.00 0 2703 2 0 0
v_max_non_paid_invoice 1725 1725 0 0.00 0 1081 3 0 0
v_max_non_paid_realizn 3977 3977 0 0.00 0 5049 7 0 0
v_min_id_clo_ord 5691 5691 0 0.00 0 7193 11 0 0
v_min_id_clo_res 976 976 0 0.00 0 6579 10 0 0
v_min_id_ord_sup 5638 5638 0 0.00 0 12788 24 0 0
v_min_non_paid_invoice 6107 6107 0 0.00 0 6137 23 0 0
v_min_non_paid_realizn 7322 7322 0 0.00 0 8176 19 0 0
v_our_firm 10444 10444 0 0.00 0 48 1 0 0
v_reserve_write_off 20892 20892 0 0.00 0 2231 4 0 0
x_lock_depdocs_on_canc_invoice 12091 12091 0 0.00 0 10991 110 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 3557 293 0 0
x_make_qstorno_1000_1200 5692 5692 0 0.00 2 77816 1167 0 0
x_make_qstorno_1200_2000 5645 5645 0 0.00 2 82564 3448 0 0
x_make_qstorno_2100_3300 477941 477941 0 0.00 0 59632 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-01-2021 22:29:14 to 21-01-2021 22:29:18.

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
19:57:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:21 20076 8192000000 10266783360 10576433152 916840944 10.065 72 57 114 0 938459376 2850640 18767792
19:57:53 34606 8192000000 10363133088 10679431168 1394044544 14.542 100 82 164 0 1425363344 5123984 26194816
19:58:37 19695 8192000000 10384785648 10709118976 1438567232 14.937 100 84 168 1 1473149840 6859840 27722768
19:59:08 21268 8192000000 10414329648 10740977664 1467315744 15.190 100 89 178 0 1503507168 7753616 28437808
19:59:43 22229 8192000000 10442371408 10772258816 1487209296 15.364 100 86 172 0 1523374976 8792528 27373152
20:00:22 18691 8192000000 10460781024 10796244992 1514029968 15.598 100 89 178 0 1551732032 9742192 27959872
20:00:50 21217 8192000000 10482200016 10819977216 1524218896 15.687 100 84 165 1 1560648944 10289824 26140224
20:01:23 15555 8192000000 10499827632 10842877952 1554531712 15.949 100 85 170 0 1591555088 10601888 26421488
20:01:47 20669 8192000000 10524324528 10875863040 1582539616 16.190 100 82 164 1 1618192656 10913296 24739744
20:02:15 14376 8192000000 10541212944 10897379328 1599920992 16.339 100 75 150 0 1633590880 11099728 22570160
20:02:36 13674 8192000000 10572392384 10926034944 1620931904 16.518 100 84 168 0 1657602528 11523216 25147408
20:02:58 11278 8192000000 10572442896 10934710272 1635571344 16.642 100 81 162 2 1672016160 12244144 24200672
20:03:17 9246 8192000000 10590242272 10956288000 1657353008 16.827 100 78 156 4 1692961824 12571104 23037712
20:03:35 9657 8192000000 10617564752 10983092224 1673337824 16.961 100 79 157 2 1708792752 12459760 22995168
20:03:56 6454 8192000000 10632229616 10999427072 1689431920 17.097 100 79 158 1 1725854528 13442784 22979824
20:04:10 5161 8192000000 10651869456 11018747904 1712618944 17.291 100 88 178 0 1751358352 13246160 25493248
20:04:22 9617 8192000000 10658013440 11030261760 1714184816 17.304 100 79 156 2 1749826352 13128848 22512688
20:04:41 6757 8192000000 10666248112 11045810176 1731222272 17.446 100 74 148 0 1764990016 12443392 21324352
20:04:55 5769 8192000000 10673060288 11054100480 1742086144 17.536 100 74 148 1 1776229808 12490400 21653264
20:05:09 4245 8192000000 10688008000 11065270272 1752244784 17.620 100 74 149 0 1786029856 12274784 21510288
20:05:19 3457 8192000000 10693509088 11068903424 1755572432 17.648 100 85 169 1 1792516000 13196640 23746928
20:05:30 5380 8192000000 10702881344 11083784192 1769403632 17.762 100 83 166 5 1806883232 14211008 23268592
20:05:43 3949 8192000000 10708671920 11092860928 1777246064 17.827 100 82 165 0 1812883328 12140048 23497216
20:05:54 8824 8192000000 10724540112 11110334464 1790359328 17.935 100 80 160 2 1824858704 11921024 22578352
20:06:13 4145 8192000000 10745427472 11129831424 1796660720 17.987 100 87 174 1 1833951824 12950192 24340912
20:06:24 2983 8192000000 10750518688 11134611456 1808284768 18.082 100 76 152 0 1843047248 13249488 21512992
20:06:34 3547 8192000000 10757067008 11141971968 1814702096 18.134 100 80 160 0 1851019360 14223984 22093280
20:06:45 3478 8192000000 10761873184 11147259904 1821793520 18.192 100 85 169 2 1859529632 14141424 23594688
20:06:55 2511 8192000000 10774375664 11161608192 1831368080 18.270 100 85 168 0 1868500096 13240640 23891376
20:07:04 2564 8192000000 10780916528 11164364800 1839588704 18.337 100 91 181 2 1878067680 12992816 25486160
20:07:13 3273 8192000000 10778005184 11165999104 1843172768 18.367 100 81 162 1 1879569584 13494752 22902064
20:07:23 1869 8192000000 10789264864 11172204544 1841334640 18.352 100 86 173 2 1881607504 15244272 25028592
20:07:32 2614 8192000000 10794814960 11180003328 1853211024 18.448 100 90 180 2 1890628032 12907216 24509792
20:07:41 1863 8192000000 10798358016 11186266112 1857380416 18.482 100 94 189 0 1895923280 12861088 25681776
20:07:50 1498 8192000000 10801132256 11189583872 1857696384 18.485 100 90 181 2 1896357520 13262928 25398208
20:07:58 1694 8192000000 10805509056 11194490880 1858157776 18.488 100 91 183 2 1902579424 18015120 26406528
20:08:06 1997 8192000000 10800142000 11192860672 1859497168 18.499 100 93 187 0 1900796128 14710400 26588560
20:08:14 2297 8192000000 10799368256 11189534720 1860616224 18.508 100 90 180 1 1898851056 12887856 25346976
20:08:23 2197 8192000000 10804904048 11194449920 1861168512 18.513 100 91 179 4 1899842480 12325776 26348192
20:08:31 12545 8192000000 10805898480 11203407872 1865414576 18.547 100 69 139 1 1896662560 12014656 19233328
20:08:50 5408 8192000000 10794131360 11198431232 1871140016 18.593 100 80 160 1 1907052112 12932768 22979328
20:09:05 11384 8192000000 10814137616 11205783552 1875291584 18.627 100 82 166 3 1908341648 9821632 23228432
20:09:22 13055 8192000000 10782248800 11206946816 1882418192 18.685 100 88 178 0 1918680016 10679040 25582784
20:09:49 3295 8192000000 10795149904 11206807552 1874315088 18.619 100 48 94 0 1896726608 9050400 13361120
20:10:05 1740 8192000000 10790763120 11209158656 1876143472 18.634 100 47 94 0 1901185216 11941072 13100672
20:10:17 6484 8192000000 10792882224 11211960320 1875772144 18.631 100 42 83 1 1895667424 8768256 11127024
20:10:32 6805 8192000000 10792488528 11210870784 1879466592 18.661 100 51 100 2 1903299152 8936576 14895984
20:10:47 7649 8192000000 10783900528 11213418496 1875989264 18.633 100 20 40 2 1887736224 6344752 5402208
20:11:02 5691 8192000000 10791057040 11219468288 1877960096 18.649 100 19 38 1 1889829616 6225168 5644352
20:11:17 8244 8192000000 10791045648 11220664320 1882668336 18.687 100 23 46 0 1895814800 5933888 7212576
20:11:31 11436 8192000000 10786316848 11221823488 1886534928 18.718 100 18 36 1 1897616048 6409968 4671152
20:11:53 11666 8192000000 10790391216 11224358912 1885671568 18.711 100 16 32 0 1896478976 5469376 5338032
20:12:12 10753 8192000000 10800413472 11229720576 1891031984 18.754 100 17 34 1 1901581232 5824736 4724512
20:12:33 10965 8192000000 10797055392 11233738752 1896510256 18.798 100 21 42 4 1908274960 6112864 5651840
20:12:50 9842 8192000000 10812412576 11245850624 1900214032 18.828 100 14 28 2 1909453632 5182560 4057040
20:13:09 11686 8192000000 10805378432 11241201664 1886645264 18.719 99 31 62 4 1906949600 10657840 9646496
20:13:30 39071 8192000000 10813967680 11246247936 1898603072 18.815 100 18 34 2 1908755120 5245456 4906592
20:14:16 32388 8192000000 10849221712 11259473920 1908812640 18.897 100 49 96 4 1928996112 5992944 14190528
20:14:55 6909 8192000000 10828597712 11264106496 1910578080 18.911 100 37 75 0 1929322432 8527776 10216576
20:15:09 10853 8192000000 10828548592 11256233984 1907380080 18.886 100 31 62 0 1923104672 6651120 9073472
20:15:26 4484 8192000000 10820645728 11261489152 1910293440 18.909 100 32 63 2 1925811888 7004784 8513664
20:15:41 8152 8192000000 10823049696 11263004672 1912477552 18.927 100 28 55 1 1928036976 7392976 8166448
20:15:55 5326 8192000000 10821513936 11262562304 1910899552 18.914 100 21 43 1 1922998880 6454400 5644928
20:16:10 3738 8192000000 10826947984 11261747200 1908783264 18.897 100 27 52 1 1923157888 6849648 7524976
20:16:21 10150 8192000000 10809186800 11243257856 1865162400 18.545 98 35 69 2 1882378784 7262032 9954352
20:16:39 9357 8192000000 10805391952 11236585472 1877749360 18.647 99 26 52 2 1890870704 5513152 7608192
20:17:02 12498 8192000000 10808771360 11237654528 1889557584 18.742 100 16 31 1 1899360800 5183712 4619504
20:17:22 13772 8192000000 10788889840 11221143552 1845401616 18.385 98 22 44 3 1857426240 5390208 6634416
20:17:44 10659 8192000000 10770538688 11191296000 1835176656 18.302 98 16 32 3 1845040496 5594720 4269120
20:18:02 67999 8192000000 10762666896 11191103488 1764384256 17.721 94 25 50 1 1777442032 5010496 8047280
20:19:21 7428 8192000000 10780160096 11207512064 1833915040 18.291 98 35 68 3 1850223696 6466672 9841984
20:19:38 5441 8192000000 10744640256 11159445504 1777141376 17.826 96 26 52 2 1790380432 5997344 7241712
20:19:52 7943 8192000000 10747606544 11168759808 1771894288 17.783 96 35 70 1 1788584736 6005264 10685184
20:20:06 7886 8192000000 10725475632 11152203776 1788391632 17.919 98 19 38 3 1800734640 6198368 6144640
20:20:20 6825 8192000000 10649574704 11057610752 1669360128 16.928 93 39 75 2 1686402768 6119168 10923472
20:20:36 5804 8192000000 10683605360 11102990336 1753659904 17.632 99 24 48 1 1766620752 5862976 7097872
20:20:48 6404 8192000000 10682361776 11090579456 1751200272 17.612 98 32 64 1 1766853456 6703376 8949808
20:21:01 4841 8192000000 10685565136 11091791872 1747193376 17.578 98 27 54 1 1761555344 6084768 8277200
20:21:16 8926 8192000000 10706195504 11129241600 1775352144 17.811 99 18 36 3 1785883408 5606624 4924640
20:21:35 6407 8192000000 10713952576 11130630144 1785960176 17.899 99 25 49 2 1798695584 5383008 7352400
20:21:48 12272 8192000000 10719237312 11133919232 1753010304 17.627 97 21 42 1 1765089504 5436608 6642592
20:22:08 14364 8192000000 10728116512 11154632704 1816473520 18.149 100 19 39 2 1827066784 5093264 5500000
20:22:28 25213 8192000000 10726772688 11151675392 1804822000 18.053 99 29 57 1 1819433184 5326464 9284720
20:23:31 15004 8192000000 10728373952 11156111360 1768867856 17.758 97 12 24 0 1777285664 4770512 3647296
20:23:53 9641 8192000000 10731122944 11160092672 1812078976 18.113 99 18 35 2 1823109328 5417632 5612720
20:24:11 9396 8192000000 10755500752 11179016192 1838529712 18.329 100 18 35 1 1849503456 5730992 5242752
20:24:26 8550 8192000000 10770444464 11189432320 1848130176 18.407 100 41 80 3 1866639104 7082304 11426624
20:24:44 10851 8192000000 10765099968 11189837824 1848637232 18.411 100 19 38 1 1859584752 5408464 5539056
20:25:03 5619 8192000000 10783781936 11195011072 1855296800 18.465 100 33 66 1 1871120848 6128608 9695440
20:25:20 8450 8192000000 10765186144 11193892864 1852973424 18.446 100 11 22 0 1861719248 5763472 2982352
20:25:35 8715 8192000000 10765934304 11195580416 1855284976 18.465 100 22 42 3 1867061200 6034592 5741632
20:25:50 10942 8192000000 10766759552 11198631936 1855571840 18.467 100 18 36 1 1866488384 5384512 5532032
20:26:08 8021 8192000000 10770589328 11197366272 1857583584 18.484 100 27 54 0 1871491568 5631376 8276608
20:26:26 11596 8192000000 10773084128 11203837952 1858973920 18.495 100 17 34 2 1869383408 5516192 4893296
20:26:45 16944 8192000000 10773107360 11200581632 1838709984 18.330 99 10 20 1 1851562480 10186656 2665840
20:27:09 8013 8192000000 10813110512 11232555008 1880199328 18.667 100 32 65 1 1898341584 9055344 9086912
20:27:37 22491 8192000000 10823019728 11239661568 1893702672 18.776 100 45 91 1 1912077936 5360320 13014944
20:28:07 44785 8192000000 10837198784 11266838528 1910905808 18.914 100 57 113 2 1938480096 11144528 16429760
20:29:01 38350 8192000000 10848014800 11270234112 1920217920 18.989 100 47 94 1 1943273488 10029040 13026528
20:29:46 3515 8192000000 10860754608 11280543744 1923227456 19.013 100 52 101 1 1949102832 11249152 14626224
20:30:01 8299 8192000000 10875065952 11290103808 1931486032 19.079 100 60 119 0 1960607648 12140832 16980784
20:30:16 2425 8192000000 10892629360 11303079936 1942922512 19.170 100 78 155 0 1979172304 13914432 22335360
20:30:26 28976 8192000000 10887085392 11307089920 1939476016 19.143 100 59 118 1 1969991472 14332144 16183312
20:31:04 6984 8192000000 10889802016 11311882240 1944325728 19.181 100 56 112 0 1979078960 19323792 15429440
20:31:19 22648 8192000000 10898338208 11315412992 1951149744 19.236 100 58 116 2 1982601600 15012224 16439632
20:32:05 11915 8192000000 10891466032 11319058432 1954917456 19.266 100 48 95 0 1986064720 17670336 13476928
20:32:25 20872 8192000000 10902868880 11329482752 1960419440 19.309 100 50 100 0 1994288352 19422240 14446672
20:32:54 10444 8192000000 10897205168 11324084224 1943536112 19.175 99 46 92 0 1975736160 19335040 12865008
20:33:16 16690 8192000000 10902385232 11329437696 1960446976 19.310 100 43 86 0 1993122960 19124016 13551968
20:33:49 35819 8192000000 10911861920 11348234240 1969045568 19.378 100 43 86 1 2006785584 24225056 13514960
20:34:36 15244 8192000000 10925534864 11356790784 1979112944 19.458 100 44 88 6 2016066160 22967600 13985616
20:35:00 13322 8192000000 10925852368 11365228544 1979852080 19.464 100 40 80 1 2020762576 28224608 12685888
20:35:26 3388 8192000000 10936645856 11361591296 1987685744 19.526 100 63 124 3 2029300208 22980624 18633840
20:35:37 4002 8192000000 10941048960 11370729472 1990512160 19.548 100 62 123 1 2032859072 23848160 18498752
20:35:47 4635 8192000000 10939533392 11367206912 1992070048 19.560 100 67 133 1 2036109680 24419488 19620144
20:36:01 5855 8192000000 10934774336 11360276480 1983890832 19.495 100 62 123 1 2028229024 25675440 18662752
20:36:14 24798 8192000000 10942265392 11374059520 1984203040 19.498 100 60 118 1 2030390128 27774560 18412528
20:36:45 19446 8192000000 10953942000 11383394304 1992021744 19.560 100 53 106 1 2038826528 29938640 16866144
20:37:11 5301 8192000000 10956993632 11386245120 2000075488 19.623 100 48 96 2 2044364544 29185344 15103712
20:37:25 11014 8192000000 10963060064 11394113536 2005768944 19.668 100 57 114 0 2050536976 27074896 17693136
20:37:50 6385 8192000000 10954958112 11388407808 1988760048 19.534 99 53 106 0 2036616528 31340736 16515744
20:38:06 8243 8192000000 10969541808 11401670656 2007101120 19.679 100 61 121 1 2058123136 32029520 18992496
20:38:22 10820 8192000000 10983992112 11414409216 2015177936 19.742 100 63 126 1 2069758416 34281504 20298976
20:38:41 4359 8192000000 10980547872 11410579456 1999072016 19.615 99 55 110 0 2054592512 38529808 16990688
20:38:59 5651 8192000000 10975317312 11411951616 2000593792 19.627 99 57 110 2 2057110832 39303600 17213440
20:39:11 3163 8192000000 10977872192 11409371136 2013045760 19.725 100 63 126 0 2067405040 34894704 19464576
20:39:25 4121 8192000000 10974096208 11403501568 2010727600 19.707 100 59 119 1 2061917504 33040800 18149104
20:39:38 6081 8192000000 10972313984 11403313152 2008151600 19.687 100 66 131 0 2062907792 35570736 19185456
20:39:53 6634 8192000000 10978747552 11403350016 1991695696 19.557 99 68 135 1 2045169344 33986976 19486672
20:40:07 6094 8192000000 10977424496 11410194432 2015130464 19.742 100 65 130 2 2069419872 34457312 19832096
20:40:22 3638 8192000000 10993426672 11413606400 2014329136 19.736 100 72 143 0 2070558880 34394544 21835200
20:40:36 6044 8192000000 10971989184 11400089600 1989191264 19.537 99 67 134 0 2043725568 34092640 20441664
20:40:53 3216 8192000000 10988786944 11404111872 2006717248 19.676 100 77 154 0 2065105616 35264976 23123392
20:41:04 5794 8192000000 10989281280 11410448384 2013065952 19.726 100 76 150 0 2071977376 35661568 23249856
20:41:16 3241 8192000000 10998447936 11412242432 2016099456 19.749 100 76 152 0 2075998416 37099808 22799152
20:41:30 2802 8192000000 10997696832 11414712320 2015841872 19.747 100 82 162 2 2077646336 37652640 24151824
20:41:40 3089 8192000000 10991574944 11410694144 2013474928 19.729 100 76 153 0 2074619392 37498192 23646272
20:41:53 5206 8192000000 10997216512 11413250048 2014145680 19.734 100 84 168 0 2078008000 38803904 25058416
20:42:10 1613 8192000000 11000476208 11420422144 2016193456 19.750 100 73 146 1 2079798320 41668528 21936336
20:42:18 4988 8192000000 11000966704 11428638720 2022987744 19.804 100 67 134 1 2085549584 41588960 20972880
20:42:32 3397 8192000000 10992870048 11422879744 2018431232 19.768 100 72 142 1 2082751104 41742192 22577680
20:42:46 2722 8192000000 11012568928 11423670272 2023407360 19.807 100 88 175 0 2091198192 41540880 26249952
20:42:56 4720 8192000000 10990847968 11412934656 2009895392 19.701 100 86 172 0 2078800560 42582336 26322832
20:43:12 5351 8192000000 10999184176 11421196288 2015271296 19.743 100 79 158 1 2084336144 44607552 24457296
20:43:25 1719 8192000000 11003222240 11419279360 2007057824 19.678 100 79 157 0 2076737584 45601296 24078464
20:43:33 4977 8192000000 10980399504 11409403904 1986478464 19.516 99 75 150 1 2054547024 44528480 23540080
20:43:45 3569 8192000000 10988551920 11409440768 2001703264 19.636 100 86 172 0 2074049616 45382352 26964000
20:43:58 3935 8192000000 10972768240 11396759552 1988591280 19.533 100 74 148 1 2060964320 48895072 23477968
20:44:10 3897 8192000000 10960804960 11385495552 1976008592 19.433 100 67 134 0 2044380576 45732128 22639856
20:44:25 6539 8192000000 10945683360 11371192320 1933894160 19.098 98 62 124 0 2004220480 50323552 20002768
20:44:41 2897 8192000000 10950903632 11364380672 1959016944 19.298 99 78 156 0 2033970224 48169408 26783872
20:44:52 6412 8192000000 10965800256 11385241600 1960312800 19.309 99 66 132 1 2031041264 48665072 22063392
20:45:08 4081 8192000000 10980135664 11388289024 1973750592 19.415 100 87 169 0 2051910768 51716384 26443792
20:45:20 2611 8192000000 10968420784 11378212864 1967476016 19.365 100 87 172 0 2046865472 51881232 27508224
20:45:31 4307 8192000000 10955135216 11365928960 1932715424 19.089 98 78 156 3 2007435840 50882128 23838288
20:45:42 913 8192000000 10978251152 11387109376 1973741152 19.415 100 91 181 1 2054378688 52188896 28448640
20:45:50 2667 8192000000 10966338448 11375173632 1967180848 19.363 100 92 184 1 2049371760 53195504 28995408
20:46:00 2810 8192000000 10955737744 11365224448 1958333040 19.293 100 86 170 2 2031890144 46738800 26818304
20:46:10 2282 8192000000 10957646880 11363282944 1957823744 19.289 100 92 183 2 2034903040 48259408 28819888
20:46:20 5839 8192000000 10929250720 11355279360 1941744096 19.161 99 67 134 0 2011897248 48624304 21528848
20:46:35 5753 8192000000 10914851504 11341975552 1923690112 19.016 98 52 103 1 1982965712 42573632 16701968
20:46:49 8140 8192000000 10922954752 11353571328 1931832896 19.082 99 54 107 3 1994875552 45984656 17058000
20:47:07 5739 8192000000 10946487280 11365425152 1953898928 19.258 100 71 140 2 2025204560 48667008 22638624
20:47:28 8161 8192000000 10963772016 11383382016 1962375008 19.325 100 66 131 1 2039144560 55173632 21595920
20:47:43 3004 8192000000 10973516288 11393183744 1977910576 19.448 100 80 159 0 2059038432 55188144 25939712
20:47:53 2635 8192000000 10975765632 11396902912 1977498928 19.445 100 77 152 1 2054268336 52510304 24259104
20:48:06 2558 8192000000 10975038304 11387420672 1968524560 19.374 100 81 158 2 2049172096 56050336 24597200
20:48:14 13798 8192000000 10954848576 11398082560 1969598480 19.382 100 59 118 0 2050934384 62216256 19119648
20:48:48 7817 8192000000 10920208608 11356790784 1925854832 19.034 99 43 86 1 1992361536 51990688 14516016
20:49:21 2019 8192000000 10977323920 11387400192 1970856736 19.392 100 89 177 2 2051664464 52784432 28023296
20:49:30 2669 8192000000 10973527808 11387289600 1970780976 19.392 100 79 158 0 2047458112 52132800 24544336
20:49:40 11449 8192000000 10929944912 11360874496 1946716560 19.200 100 52 104 1 2014979776 51956224 16306992
20:50:06 6969 8192000000 10930388592 11367428096 1951586144 19.239 100 48 96 0 2013596224 46278448 15731632
20:50:22 7229 8192000000 10939126560 11359789056 1945614864 19.192 100 56 112 0 2015072432 51656144 17801424
20:50:36 8261 8192000000 10924168528 11352674304 1929100480 19.060 99 49 95 1 1992498576 47532160 15865936
20:50:55 3583 8192000000 10944279712 11368263680 1954138960 19.259 100 54 110 0 2023395488 51567872 17688656
20:51:07 1501 8192000000 10947269248 11364073472 1949796592 19.225 99 78 156 3 2026700512 52009408 24894512
20:51:15 4347 8192000000 10960844848 11390943232 1966920480 19.361 100 62 124 2 2040913936 54418336 19575120
20:51:31 10584 8192000000 10942205744 11387494400 1971700192 19.399 100 39 78 2 2035213376 51313824 12199360
20:52:00 13308 8192000000 10943698624 11392983040 1976307888 19.435 100 39 78 2 2036317856 46660368 13349600
20:52:28 10481 8192000000 10944589456 11386720256 1951584608 19.239 99 37 74 1 2012594496 48092416 12917472
20:53:07 23697 8192000000 10930783184 11393581056 1961145424 19.315 100 29 58 0 2029680672 58245104 10290144
20:54:06 29116 8192000000 10879579424 11341950976 1890912208 18.753 97 21 42 1 1937040912 38691792 7436912
20:54:42 40826 8192000000 10880792032 11338911744 1914984816 18.947 100 15 30 1 1965194528 44212656 5997056
20:55:32 10450 8192000000 10868530912 11307728896 1884287904 18.700 98 26 52 0 1930764272 36849392 9626976
20:56:04 10748 8192000000 10895293792 11321151488 1904640304 18.864 99 40 76 2 1954185536 37702768 11842464
20:56:23 7525 8192000000 10898977888 11331543040 1903735216 18.856 99 45 90 1 1960575568 43012832 13827520
20:56:38 43708 8192000000 10850121776 11311562752 1884556688 18.702 98 22 43 2 1921092320 29726352 6809280
20:57:28 43841 8192000000 10865987152 11330109440 1921045520 18.995 100 13 26 2 1945523872 21047568 3430784
20:58:19 94642 8192000000 10847864064 11300192256 1840844240 18.348 95 14 28 1 1859056384 14491584 3720560
21:00:06 103608 8192000000 10857900928 11312959488 1883982400 18.697 98 12 24 1 1898892192 11736240 3173552
21:01:57 115248 8192000000 10872183680 11330293760 1903167936 18.852 98 8 17 0 1918584368 13534016 1882416
21:04:04 67998 8192000000 10868086896 11316490240 1890127632 18.747 97 29 58 1 1905688192 8191600 7368960
21:05:43 15000 8192000000 10902008784 11335065600 1952799792 19.249 100 58 116 3 1976639584 7677488 16162304
21:06:05 22035 8192000000 10905590464 11340918784 1935452960 19.110 99 53 106 1 1960823472 10466352 14904160
21:06:34 9202 8192000000 10917894672 11344855040 1958448608 19.294 100 60 117 1 1988680256 13019968 17211680
21:06:54 33246 8192000000 10885273888 11355865088 1958508576 19.294 100 47 93 1 1988515184 16710912 13295696
21:07:38 125833 8192000000 10897063408 11352317952 1938101472 19.132 99 12 24 0 1957271216 15323296 3846448
21:10:29 78944 8192000000 10886163296 11364904960 1946493632 19.199 99 24 48 0 1962316864 8659504 7163728
21:13:09 4404 8192000000 10924334096 11369992192 1972605952 19.406 100 42 86 4 1999362224 14282480 12473792
21:13:20 9326 8192000000 10916572096 11370606592 1974834016 19.424 100 38 76 1 2001116816 15738784 10544016
21:14:17 34559 8192000000 10948870288 11399749632 1994834736 19.582 100 50 100 1 2026294912 16404096 15056080
21:15:11 69134 8192000000 10926736320 11406258176 1973411520 19.413 99 16 32 1 1999360576 21064848 4884208
21:17:15 67883 8192000000 10923179104 11392897024 1967051024 19.362 99 14 29 0 1985191568 14367120 3773424
21:18:29 75266 8192000000 10936284720 11406946304 1980753792 19.471 99 16 31 0 1994594672 9132480 4708400
21:19:50 50638 8192000000 10918460720 11401220096 1981865760 19.479 99 13 26 0 2000606544 14256752 4484032
21:21:37 64786 8192000000 10898270272 11381137408 1978436672 19.452 100 16 32 1 1997198048 14556768 4204608
21:22:51 45886 8192000000 10899436016 11377733632 1941125520 19.156 98 8 16 1 1950272976 7095536 2051920
21:23:43 42909 8192000000 10939281552 11392679936 1971411712 19.397 99 38 75 2 1997141168 14620512 11108944
21:24:32 29506 8192000000 10918138208 11378675712 1944008208 19.179 98 46 92 1 1968011424 10461904 13541312
21:25:07 52534 8192000000 10888069200 11369623552 1927008064 19.043 98 16 32 2 1946820784 15092512 4720208
21:26:14 64290 8192000000 10881407520 11343065088 1863082336 18.528 95 17 34 0 1878171504 10653808 4435360
21:27:26 65421 8192000000 10897310624 11374202880 1961768976 19.320 100 20 40 1 1978595392 11112320 5714096
21:28:37 47996 8192000000 10885143360 11352576000 1891982736 18.762 96 25 50 1 1906589712 8019536 6587440
21:29:47 66502 8192000000 10895626048 11357376512 1878555680 18.653 96 19 38 1 1897314880 13707456 5051744
21:31:03 72426 8192000000 10881941920 11345969152 1831721392 18.273 93 32 63 1 1856158320 15139936 9296992
21:32:23 71488 8192000000 10903116928 11355013120 1877683056 18.646 96 22 44 0 1899327152 14816352 6827744
21:33:40 56011 8192000000 10871481152 11352875008 1905190608 18.868 98 11 22 0 1926654544 18479568 2984368
21:34:42 73852 8192000000 10850583408 11319709696 1824450784 18.214 94 9 18 0 1840003312 13278912 2273616
21:36:04 102414 8192000000 10852180256 11310964736 1853009312 18.447 96 24 47 1 1867087424 7129120 6948992
21:37:53 88392 8192000000 10847328256 11321122816 1895307632 18.789 98 25 50 0 1911232416 9209008 6715776
21:39:28 8151 8192000000 10856555776 11333955584 1934451216 19.102 100 14 28 2 1948759728 10553776 3754736
21:39:42 10565 8192000000 10848203280 11324735488 1914434128 18.942 99 9 18 1 1926217088 9274576 2508384
21:39:59 20819 8192000000 10857441760 11301113856 1873740384 18.615 97 44 89 0 1893412256 6951440 12720432
21:40:36 29439 8192000000 10842831696 11308249088 1887533984 18.726 98 20 40 0 1902850400 10099232 5217184
21:41:17 60539 8192000000 10842746496 11304603648 1890661888 18.751 98 13 26 0 1901701632 7268352 3771392
21:42:40 50690 8192000000 10842106816 11310874624 1918968112 18.979 100 17 34 1 1933272256 9376688 4927456
21:43:40 71676 8192000000 10844814640 11312939008 1906542688 18.879 99 16 31 0 1918850816 8009312 4298816
21:46:38 59960 8192000000 10831107168 11317448704 1916176368 18.956 100 10 20 1 1930989632 12171632 2641632
21:47:49 38234 8192000000 10833889264 11298840576 1887398112 18.725 98 16 32 1 1898319280 6573408 4347760
21:48:41 51405 8192000000 10856047488 11331289088 1927600800 19.048 100 7 14 0 1936081088 6702384 1777904
21:49:39 72762 8192000000 10868148160 11329015808 1899832816 18.825 98 10 20 1 1914970240 12285744 2851680
21:50:58 44616 8192000000 10864552160 11331964928 1899707328 18.824 98 24 48 0 1920772800 13941248 7124224
21:51:59 33814 8192000000 10870984032 11330265088 1902226576 18.844 98 38 75 1 1921231808 8854784 10150448
21:53:06 95508 8192000000 10876522192 11341897728 1883225568 18.691 97 25 50 0 1904385584 13950816 7209200
21:54:48 39216 8192000000 10873812768 11341172736 1927712768 19.049 99 30 60 0 1946492192 10553760 8225664
21:55:34 27762 8192000000 10895776576 11342315520 1942540432 19.167 99 51 101 1 1968868944 12076368 14252144
21:56:13 64208 8192000000 10875417120 11360710656 1916730144 18.961 98 23 46 0 1938700336 15271904 6698288
21:57:42 79387 8192000000 10918166432 11357605888 1919506800 18.983 98 19 37 3 1936094944 12313920 4274224
21:59:09 30218 8192000000 10903024768 11365363712 1971808768 19.400 100 21 42 0 1986253424 8616688 5827968
21:59:46 52574 8192000000 10912810672 11384188928 1968987536 19.377 100 15 30 1 1987908560 15323776 3597248
22:00:50 105447 8192000000 10921267424 11400339456 1947349216 19.205 98 11 22 0 1964562576 14605264 2608096
22:02:49 51245 8192000000 10927553232 11390840832 1967772608 19.368 100 18 36 0 1986011904 13160048 5079248
22:03:53 36167 8192000000 10923179248 11385061376 1984394224 19.499 100 48 96 2 2011736288 12947984 14394080
22:05:19 69419 8192000000 10891883520 11365826560 1906915040 18.882 96 19 38 1 1923916480 11392976 5608464
22:06:35 19929 8192000000 10907279792 11381403648 1951615776 19.239 99 18 36 4 1977163264 20027984 5519504
22:07:01 61599 8192000000 10882142176 11363045376 1948056256 19.211 99 19 38 1 1976146352 22529312 5560784
22:08:24 77222 8192000000 10882476928 11352834048 1908647584 18.896 97 17 34 0 1932797040 19123040 5026416
22:09:53 78887 8192000000 10899603712 11377905664 1964041024 19.338 100 15 30 1 1983678496 15653568 3983904
22:11:26 107189 8192000000 10890642944 11386257408 1937951424 19.130 98 13 27 0 1959319456 17714928 3653104
22:13:21 41802 8192000000 10882033760 11347161088 1866656736 18.557 95 16 32 1 1879924128 9176464 4090928
22:14:09 44173 8192000000 10893546912 11369369600 1962617232 19.327 100 29 59 1 1981566992 10968032 7981728
22:15:22 58216 8192000000 10887912256 11362336768 1933358960 19.094 98 20 39 0 1949724000 11180272 5184768
22:16:29 73036 8192000000 10917394704 11378941952 1914354512 18.942 97 15 30 0 1934508960 16014912 4139536
22:17:54 57254 8192000000 10890188224 11369299968 1894863312 18.785 96 21 42 0 1919625440 18623632 6138496
22:18:58 72569 8192000000 10891752144 11358015488 1933255200 19.093 99 10 20 1 1957538416 21233648 3049568
22:20:20 58567 8192000000 10871045648 11347259392 1849443024 18.418 95 17 34 1 1868078176 14093664 4541488
22:21:25 34510 8192000000 10876376240 11339186176 1898687520 18.816 98 36 69 3 1919759840 10552960 10519360
22:22:18 60552 8192000000 10877657008 11324026880 1829271968 18.253 94 22 44 0 1844899888 9257408 6370512
22:23:27 18482 8192000000 10875699408 11317231616 1910919216 18.914 99 47 94 1 1937066000 13299536 12847248
22:25:03 79214 8192000000 10871178928 11320164352 1911909184 18.922 99 36 72 2 1931065088 9519488 9636416
22:26:58 27833 8192000000 9436650000 9735606272 587596208 6.692 31 3 6 0 592861408 4706368 558832

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-01-2021 22:29:20 to 21-01-2021 22:29:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-01-2021 22:29:53 to 21-01-2021 22:29:55.

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

Database statistics

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

Database validation

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

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

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

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

21.01.21 22:29:56. 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-01-21 22:29:59 No severe PSQL-related problems occured
21.01.21 22:30:00. End of report.