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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17284272 kB
MemAvailable 31355208 kB
Buffers 0 kB
Cached 14435012 kB
SwapCached 4864 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-18 16:31:41
DTS_END                         2021-01-18 16:31:41.1330
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/55458
TRN_ID                          231954
ATT_ID                          665
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: 9230.80 26902 1107696
customer order: creation 159.07 377 19089
customer order: refuse 14.08 350 1689
order to supplier: creation 41.68 1283 5001
order to supplier: removal 3.33 102801 399
invoice (draft): creation 43.23 3326 5188
invoice (draft): removal 54.20 755 6504
invoice accept: apply 39.57 18354 4748
invoice accept: cancel 49.58 741 5950
customer reserve: creation 3671.03 182 440523
customer reserve: removal 4866.48 55 583978
realization accept: apply 78.95 198 9474
realization accept: cancel 89.23 98 10708
payment from customer: creation 55.38 102 6645
payment from customer: removal 5.28 82 633
payment to supplier: creation 45.00 119 5400
payment to supplier: removal 3.17 118 380
service: total inventory turnovers 4.78 1207 574
service: total monetary turnovers 6.07 26 728
service: aggregate perf. data 0.68 24988 81
service: refresh index statistics 0.03 382882 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-01-2021 16:33:12 to 18-01-2021 16:33:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6305
TEST_TIME 2 5530
TEST_TIME 3 5117
TEST_TIME 4 5371
TEST_TIME 5 5775
TEST_TIME 6 5690
TEST_TIME 7 5930
TEST_TIME 8 5967
TEST_TIME 9 6017
TEST_TIME 10 5925
TEST_TIME 11 6411
TEST_TIME 12 6619
TEST_TIME 13 6665
TEST_TIME 14 6765
TEST_TIME 15 6812
TEST_TIME 16 6938
TEST_TIME 17 7131
TEST_TIME 18 7197
TEST_TIME 19 7585
TEST_TIME 20 7691
TEST_TIME 21 8148
TEST_TIME 22 8463
TEST_TIME 23 8910
TEST_TIME 24 9375
TEST_TIME 25 9869
TEST_TIME 26 10763
TEST_TIME 27 10866
TEST_TIME 28 10745
TEST_TIME 29 10636
TEST_TIME 30 10560
TEST_TIME 31 10393
TEST_TIME 32 10281
TEST_TIME 33 10139
TEST_TIME 34 9972
TEST_TIME 35 9830
TEST_TIME 36 10043
TEST_TIME 37 9837
TEST_TIME 38 9804
TEST_TIME 39 9691
TEST_TIME 40 9624
TEST_TIME 41 9679
TEST_TIME 42 9600
TEST_TIME 43 9436
TEST_TIME 44 9718
TEST_TIME 45 9905
TEST_TIME 46 9839
TEST_TIME 47 9705
TEST_TIME 48 9875
TEST_TIME 49 10041
TEST_TIME 50 10087
TEST_TIME 51 10036
TEST_TIME 52 10017
TEST_TIME 53 9989
TEST_TIME 54 9960
TEST_TIME 55 9960
TEST_TIME 56 9999
TEST_TIME 57 9891
TEST_TIME 58 9826
TEST_TIME 59 9739
TEST_TIME 60 9702
TEST_TIME 61 9668
TEST_TIME 62 9630
TEST_TIME 63 9674
TEST_TIME 64 9650
TEST_TIME 65 9542
TEST_TIME 66 9440
TEST_TIME 67 9473
TEST_TIME 68 9561
TEST_TIME 69 9632
TEST_TIME 70 9619
TEST_TIME 71 9568
TEST_TIME 72 9657
TEST_TIME 73 9707
TEST_TIME 74 9670
TEST_TIME 75 9672
TEST_TIME 76 9664
TEST_TIME 77 9705
TEST_TIME 78 9674
TEST_TIME 79 9762
TEST_TIME 80 9887
TEST_TIME 81 9897
TEST_TIME 82 9816
TEST_TIME 83 9723
TEST_TIME 84 9736
TEST_TIME 85 9649
TEST_TIME 86 9628
TEST_TIME 87 9607
TEST_TIME 88 9547
TEST_TIME 89 9544
TEST_TIME 90 9517
TEST_TIME 91 9470
TEST_TIME 92 9492
TEST_TIME 93 9436
TEST_TIME 94 9474
TEST_TIME 95 9466
TEST_TIME 96 9424
TEST_TIME 97 9433
TEST_TIME 98 9434
TEST_TIME 99 9435
TEST_TIME 100 9434
TEST_TIME 101 9479
TEST_TIME 102 9446
TEST_TIME 103 9446
TEST_TIME 104 9470
TEST_TIME 105 9487
TEST_TIME 106 9471
TEST_TIME 107 9486
TEST_TIME 108 9537
TEST_TIME 109 9466
TEST_TIME 110 9432
TEST_TIME 111 9390
TEST_TIME 112 9353
TEST_TIME 113 9358
TEST_TIME 114 9316
TEST_TIME 115 9303
TEST_TIME 116 9264
TEST_TIME 117 9260
TEST_TIME 118 9212
TEST_TIME 119 9254
TEST_TIME 120 9234

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-01-2021 16:33:16 to 18-01-2021 16:33:19.

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 1514441 1514441 0 0.00 0 24008 6 0 0
doc_list_biud 1514441 1514441 0 0.00 0 22173 27 0 0
sp_add_invoice_to_stock 4884 4748 136 2.78 42 199523 18355 0 136
sp_cancel_adding_invoice 5950 5950 0 0.00 4 76088 742 0 0
sp_cancel_client_order 1689 1689 0 0.00 4 12860 351 0 0
sp_cancel_customer_reserve 583978 583978 0 0.00 1 22175 56 0 0
sp_cancel_pay_from_customer 633 633 0 0.00 2 12868 82 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 2 10987 119 0 0
sp_cancel_supplier_invoice 6511 6504 7 0.10 2 14830 756 0 7
sp_cancel_supplier_order 399 399 0 0.00 8 1124728 102801 0 0
sp_cancel_write_off 10708 10708 0 0.00 1 9281 98 0 0
sp_client_order 19089 19089 0 0.00 4 24015 378 0 0
sp_customer_reserve 440523 440523 0 0.00 0 106581 182 0 0
sp_fill_shopping_cart 29260 29260 0 0.00 1 9621 33 0 0
sp_fill_shopping_cart_clo_res 440505 440505 0 0.00 0 15218 12 0 0
sp_get_clo_for_invoice 4730 4730 0 0.00 0 31001 274 0 0
sp_kill_cost_storno 17671 17671 0 0.00 0 14562 52 0 0
sp_kill_qstorno_ret_qs2qd 1185567 1185567 0 0.00 0 22068 30 0 0
sp_kill_qty_storno 623432 623432 0 0.00 0 22173 65 0 0
sp_lock_selected_doc 19652 19652 0 0.00 0 9116 5 0 0
sp_make_cost_storno 26249 26249 0 0.00 0 24007 56 0 0
sp_multiply_rows_for_pdistr 26249 26249 0 0.00 0 12595 24 0 0
sp_multiply_rows_for_qdistr 19089 19089 0 0.00 0 10621 150 0 0
sp_pay_from_customer 6645 6645 0 0.00 4 12736 102 0 0
sp_pay_to_supplier 5400 5400 0 0.00 5 24014 120 0 0
sp_payment_common 12045 12045 0 0.00 1 13242 21 0 0
sp_qd_handle_on_cancel_clo 1689 1689 0 0.00 0 8565 310 0 0
sp_qd_handle_on_invoice_upd_sts 10680 10680 0 0.00 0 15343 314 0 0
sp_qd_handle_on_reserve_upd_sts 9474 9474 0 0.00 0 15578 72 0 0
sp_reserve_write_off 9474 9474 0 0.00 6 15949 199 0 0
sp_supplier_invoice 5188 5188 0 0.00 5 74645 3327 0 0
sp_supplier_order 5001 5001 0 0.00 5 21674 1283 0 0
srv_aggregate_perf_data 81 81 0 0.00 2451 483697 24989 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1934 153674 36068 0 0
srv_find_qd_qs_mism 1062424 1062424 0 0.00 0 19784 6 0 0
srv_make_invnt_saldo 574 574 0 0.00 23 63178 1207 0 0
srv_make_money_saldo 728 728 0 0.00 1 2341 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 196280 580474 382883 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4748 4748 0 0.00 0 14241 169 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 0 3611 94 0 0
t$perf-norm:sp_cancel_client_order 1689 1689 0 0.00 0 9845 18 0 0
t$perf-norm:sp_cancel_customer_reserve 650 650 0 0.00 0 723 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 633 633 0 0.00 0 1677 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 1538 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 464 11 0 0
t$perf-norm:sp_cancel_supplier_order 399 399 0 0.00 0 30503 1386 0 0
t$perf-norm:sp_cancel_write_off 918 918 0 0.00 0 4114 17 0 0
t$perf-norm:sp_client_order 19089 19089 0 0.00 0 8988 18 0 0
t$perf-norm:sp_customer_reserve 952 952 0 0.00 0 1014 3 0 0
t$perf-norm:sp_pay_from_customer 6645 6645 0 0.00 0 9493 8 0 0
t$perf-norm:sp_pay_to_supplier 5400 5400 0 0.00 0 17693 17 0 0
t$perf-norm:sp_reserve_write_off 9474 9474 0 0.00 0 5994 11 0 0
t$perf-norm:sp_supplier_invoice 5188 5188 0 0.00 0 3370 13 0 0
t$perf-norm:sp_supplier_order 5001 5001 0 0.00 0 5368 13 0 0
t$perf-norm:srv_aggregate_perf_data 81 81 0 0.00 0 619 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 743 10 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 2869 21 0 0
t$perf-norm:srv_make_money_saldo 728 728 0 0.00 0 2977 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 15 5 0 0
v_add_invoice_to_stock 9732 9460 272 2.79 0 7906 24 0 272
v_all_customers 34896 34896 0 0.00 0 79 0 0 0
v_all_suppliers 27928 27928 0 0.00 0 15 1 0 0
v_all_wares 38172 38172 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 13107 21 0 0
v_cancel_client_order 3378 3378 0 0.00 0 12590 10 0 0
v_cancel_customer_prepayment 1266 1266 0 0.00 0 969 4 0 0
v_cancel_customer_reserve 1300 1300 0 0.00 0 5850 8 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 5536 17 0 0
v_cancel_supplier_invoice 794 780 14 1.76 0 4131 24 0 14
v_cancel_supplier_order 798 798 0 0.00 0 2012 6 0 0
v_cancel_write_off 1836 1836 0 0.00 0 7541 19 0 0
v_max_id_clo_ord 4999 4999 0 0.00 0 273 1 0 0
v_max_id_clo_res 952 952 0 0.00 0 1112 15 0 0
v_max_id_ord_sup 5173 5173 0 0.00 0 6838 4 0 0
v_max_non_paid_invoice 1608 1608 0 0.00 0 341 2 0 0
v_max_non_paid_realizn 3523 3523 0 0.00 0 2078 4 0 0
v_min_id_clo_ord 4999 4999 0 0.00 0 5218 7 0 0
v_min_id_clo_res 952 952 0 0.00 0 6564 26 0 0
v_min_id_ord_sup 5173 5173 0 0.00 0 3690 4 0 0
v_min_non_paid_invoice 5400 5400 0 0.00 0 13239 11 0 0
v_min_non_paid_realizn 6645 6645 0 0.00 0 3946 9 0 0
v_our_firm 9520 9520 0 0.00 0 25 1 0 0
v_reserve_write_off 18948 18948 0 0.00 0 13703 12 0 0
x_lock_depdocs_on_canc_invoice 12064 12064 0 0.00 0 13169 109 0 0
x_lock_depdocs_on_canc_sup_ord 399 399 0 0.00 0 14594 375 0 0
x_make_qstorno_1000_1200 5001 5001 0 0.00 1 21640 1213 0 0
x_make_qstorno_1200_2000 5188 5188 0 0.00 3 74638 3208 0 0
x_make_qstorno_2100_3300 440523 440523 0 0.00 0 106580 168 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-01-2021 16:33:20 to 18-01-2021 16:33:25.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:44 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:51 10813 8192000000 10204175632 10506436608 798144928 8.877 63 50 101 0 816610416 2142592 16322896
14:02:10 19126 8192000000 10315411664 10630643712 1355397216 14.196 100 81 162 1 1386888048 4191856 27298976
14:02:45 36023 8192000000 10381606864 10702012416 1427115952 14.836 100 91 182 0 1463953376 6566608 30270816
14:03:29 23409 8192000000 10403498880 10728116224 1448999760 15.029 100 88 176 0 1485768080 7406656 29361664
14:04:11 20800 8192000000 10419493680 10747133952 1472347088 15.234 100 88 176 0 1508989728 8223088 28419552
14:04:42 20754 8192000000 10429851184 10763599872 1488808544 15.378 100 88 175 1 1526081936 8959408 28313984
14:05:19 16955 8192000000 10457543408 10797572096 1514825760 15.605 100 89 179 0 1552730752 9680992 28224000
14:05:47 14055 8192000000 10479122528 10820145152 1528234832 15.722 100 86 172 0 1565235408 10262864 26737712
14:06:11 16647 8192000000 10495445488 10842603520 1550937952 15.918 100 81 162 1 1586453728 10334672 25181104
14:06:42 10439 8192000000 10515359184 10867408896 1579257824 16.162 100 83 164 1 1614669152 10346992 25064336
14:07:01 10802 8192000000 10529332624 10884235264 1589408608 16.249 100 76 152 1 1623578672 10267408 23902656
14:07:21 14425 8192000000 10564004032 10919247872 1617576288 16.489 100 76 152 0 1651453888 10964752 22912848
14:07:43 11345 8192000000 10576886880 10944495616 1643556496 16.710 100 76 150 4 1677080848 11583808 21940544
14:08:02 11456 8192000000 10609795536 10977751040 1674953712 16.975 100 82 164 1 1711131392 12178224 23999456
14:08:21 8160 8192000000 10630990112 10999689216 1690188768 17.103 100 78 153 1 1723805952 11673904 21943280
14:08:37 8129 8192000000 10637664288 11009638400 1704359600 17.222 100 81 162 2 1740107152 13039024 22708528
14:08:53 8116 8192000000 10657784240 11028209664 1714114928 17.303 100 83 166 4 1751602672 13574656 23913088
14:09:09 6435 8192000000 10669311680 11042058240 1723274592 17.379 100 75 150 2 1757520000 13075968 21169440
14:09:25 4995 8192000000 10684834448 11057627136 1739857168 17.517 100 84 168 0 1777620720 13571392 24192160
14:09:37 6112 8192000000 10686577728 11064487936 1746182144 17.570 100 75 147 1 1779492704 13152656 20157904
14:09:50 4262 8192000000 10702974016 11080937472 1761495296 17.697 100 86 172 0 1799884752 14310736 24078720
14:10:02 3389 8192000000 10705450976 11088375808 1769956512 17.767 100 80 158 1 1805582720 13494032 22132176
14:10:12 3362 8192000000 10718732528 11095150592 1776103456 17.817 100 84 168 1 1813220864 13811504 23305904
14:10:23 3170 8192000000 10722875024 11102388224 1785044976 17.891 100 83 165 1 1821856992 13055344 23756672
14:10:33 2960 8192000000 10737820784 11112521728 1792036864 17.949 100 89 180 0 1830776480 13648192 25091424
14:10:42 7654 8192000000 10730380880 11118391296 1800756960 18.020 100 82 163 3 1836078240 12764000 22557280
14:10:56 4913 8192000000 10746141120 11129851904 1806175312 18.065 100 80 160 1 1842477808 13688160 22614336
14:11:08 1978 8192000000 10765686736 11147825152 1819934016 18.177 100 91 179 1 1859516128 14316848 25265264
14:11:16 2353 8192000000 10767469328 11150635008 1825062816 18.219 100 90 180 1 1864103456 13611040 25429600
14:11:25 1817 8192000000 10773727984 11157909504 1828577888 18.248 100 86 171 1 1866757088 14491120 23688080
14:11:33 1853 8192000000 10777987968 11162796032 1835952880 18.308 100 95 190 3 1879092048 15857536 27281632
14:11:42 1313 8192000000 10790168432 11172442112 1843331808 18.368 100 91 183 0 1883000368 13763120 25905440
14:11:50 1487 8192000000 10789513344 11175542784 1844554000 18.378 100 85 169 1 1880047424 12156256 23337168
14:11:57 1172 8192000000 10802276128 11187736576 1856822880 18.478 100 94 186 1 1896471296 13701120 25947296
14:12:05 2117 8192000000 10806235184 11192918016 1858424960 18.491 100 92 184 2 1898638256 14116352 26096944
14:12:14 1437 8192000000 10803714192 11191267328 1860268512 18.505 100 91 178 1 1897481968 12068512 25144944
14:12:22 1843 8192000000 10808075104 11194998784 1861146240 18.513 100 89 178 2 1899813952 13389664 25278048
14:12:41 23283 8192000000 10790842720 11194343424 1861425104 18.515 100 55 110 2 1884931424 7936880 15569440
14:13:17 11690 8192000000 10777223376 11200716800 1863535872 18.532 100 34 67 2 1880424928 7862896 9026160
14:13:40 5016 8192000000 10768734224 11199545344 1868334064 18.571 100 41 81 2 1886890544 6680304 11876176
14:13:54 4445 8192000000 10799242288 11214917632 1873317168 18.611 100 41 83 1 1895993872 10910832 11765872
14:14:09 4948 8192000000 10792813728 11214295040 1875980048 18.633 100 30 60 0 1893317120 7205328 10131744
14:14:20 5002 8192000000 10792659104 11219120128 1879678896 18.663 100 25 50 2 1897655344 11034208 6942240
14:14:32 8231 8192000000 10796532208 11224719360 1882686624 18.687 100 24 48 0 1896554768 7034192 6833952
14:14:50 5235 8192000000 10794234320 11226148864 1889208512 18.739 100 27 54 0 1903585104 6998816 7377776
14:15:07 6561 8192000000 10803068512 11234140160 1892314544 18.764 100 21 42 1 1904494720 5758464 6421712
14:15:19 7122 8192000000 10800507792 11232301056 1893491472 18.774 100 18 35 3 1908553872 10263408 4798992
14:15:33 12946 8192000000 10814888608 11241889792 1894032384 18.778 100 20 38 0 1909384256 10248992 5102880
14:15:53 9938 8192000000 10798343696 11235180544 1893341360 18.773 100 13 26 1 1903031072 6035936 3653776
14:16:10 11940 8192000000 10801813152 11244437504 1899108400 18.819 100 16 33 1 1913795536 10755984 3931152
14:16:31 12197 8192000000 10814791568 11245428736 1903502528 18.854 100 23 47 2 1916417200 5983664 6931008
14:16:50 12756 8192000000 10811986432 11247779840 1905620096 18.871 100 36 71 2 1922625424 5747632 11257696
14:17:10 57620 8192000000 10847099856 11260792832 1911127104 18.916 100 58 117 2 1934422368 5786096 17509168
14:18:14 6203 8192000000 10832380736 11262586880 1906918448 18.882 100 33 66 0 1923729936 7718576 9092912
14:18:32 4608 8192000000 10820777968 11257954304 1910820800 18.913 100 33 67 0 1926625728 6756848 9048080
14:18:47 8006 8192000000 10840983696 11266441216 1911310944 18.917 100 26 52 0 1926213152 7578128 7324080
14:19:06 4546 8192000000 10827503296 11261939712 1912915648 18.930 100 29 58 0 1927226880 6509920 7801312
14:19:17 6218 8192000000 10832805120 11266031616 1914599168 18.944 100 31 60 3 1929474768 6811632 8063968
14:19:29 9140 8192000000 10832956208 11262414848 1911991168 18.923 100 39 76 1 1934128320 10659040 11478112
14:19:45 9471 8192000000 10832012224 11265449984 1916302672 18.957 100 23 45 1 1928851152 5224256 7324224
14:20:02 12401 8192000000 10819278944 11258748928 1892292176 18.764 99 22 44 1 1909064912 10828800 5943936
14:20:25 5775 8192000000 10831200400 11262337024 1913199504 18.932 100 35 71 2 1928642464 5144352 10298608
14:20:37 5031 8192000000 10841367200 11267686400 1916827936 18.961 100 33 66 0 1938208240 11292336 10087968
14:20:50 9708 8192000000 10831537440 11265581056 1899893152 18.825 99 21 41 1 1916253648 10497232 5863264
14:21:06 8793 8192000000 10818655312 11247915008 1858483776 18.491 97 29 59 1 1876248400 9550208 8214416
14:21:22 13834 8192000000 10780518752 11205410816 1800945728 18.022 95 24 48 1 1818099152 9873824 7279600
14:21:43 51133 8192000000 10792312832 11216478208 1820000896 18.178 96 35 69 0 1835258736 5272064 9985776
14:22:59 5440 8192000000 10774381808 11208982528 1866787968 18.558 100 23 47 2 1879732928 6024256 6920704
14:23:11 6264 8192000000 10758445872 11186978816 1833709488 18.290 99 30 60 1 1849222416 7361360 8151568
14:23:25 6243 8192000000 10742052192 11158941696 1774289264 17.802 96 31 62 1 1788973008 5770496 8913248
14:23:39 6429 8192000000 10740222768 11139735552 1781084160 17.858 97 37 74 0 1801701696 10658464 9959072
14:23:53 3885 8192000000 10698985504 11107278848 1735362256 17.480 96 41 82 0 1758257120 11144704 11750160
14:24:03 8111 8192000000 10711872928 11126034432 1736039376 17.486 96 33 67 1 1751437616 6138048 9260192
14:24:17 6029 8192000000 10667468768 11078836224 1724288000 17.388 96 29 58 2 1738880720 6484640 8108080
14:24:31 5704 8192000000 10709688080 11117129728 1750416912 17.605 97 47 92 2 1770964272 5160336 15387024
14:24:44 5343 8192000000 10702690480 11114577920 1745194192 17.562 97 18 36 0 1755826848 5171760 5460896
14:24:55 6700 8192000000 10706059536 11123204096 1776740752 17.823 99 24 48 2 1789850512 5624304 7485456
14:25:09 7092 8192000000 10719130256 11130908672 1779897856 17.849 99 28 56 0 1794794560 6233280 8663424
14:25:25 10023 8192000000 10717954096 11136385024 1783751888 17.880 99 19 38 0 1794579376 5370512 5456976
14:25:43 9974 8192000000 10713897184 11129847808 1794193360 17.966 99 21 42 2 1805413136 5025408 6194368
14:26:01 8854 8192000000 10725827584 11146043392 1809613504 18.093 100 23 45 2 1822956000 6311312 7031184
14:26:19 69465 8192000000 10741429824 11169665024 1833786064 18.290 100 42 84 2 1851905344 5875760 12243520
14:27:35 11783 8192000000 10746390160 11174305792 1814464896 18.132 99 24 46 2 1827103024 5844480 6793648
14:27:56 5752 8192000000 10753719696 11171225600 1833229616 18.286 100 36 72 0 1850715008 7495344 9990048
14:28:11 8239 8192000000 10769233568 11188252672 1842175776 18.359 100 27 54 0 1861004304 11263504 7565024
14:28:25 6868 8192000000 10780799088 11196391424 1852413792 18.442 100 38 76 2 1869409424 6144032 10851600
14:28:41 6765 8192000000 10766972688 11199016960 1856634848 18.476 100 27 54 1 1869848944 5561504 7652592
14:28:53 8666 8192000000 10790154400 11206266880 1859533728 18.499 100 24 48 0 1872262672 5480544 7248400
14:29:10 6390 8192000000 10772896512 11209326592 1867703488 18.566 100 23 46 1 1881109568 6530640 6875440
14:29:23 5336 8192000000 10780236528 11209830400 1870214800 18.586 100 17 33 0 1880618080 5468832 4934448
14:29:35 9863 8192000000 10801745744 11219226624 1871796992 18.599 100 24 48 1 1885110320 5456144 7857184
14:29:51 10458 8192000000 10784408192 11216867328 1873431776 18.612 100 22 44 1 1885736224 5491120 6813328
14:30:09 15117 8192000000 10788952608 11221745664 1875593248 18.630 100 18 36 0 1886939024 5468880 5876896
14:30:30 7424 8192000000 10794513168 11222208512 1875341296 18.627 100 29 58 1 1889615280 5550384 8723600
14:30:47 51719 8192000000 10803445936 11230568448 1879956048 18.665 100 27 54 2 1894049072 5737696 8355328
14:31:51 37673 8192000000 10817825952 11250057216 1901988912 18.842 100 29 58 0 1915078416 4661184 8428320
14:32:50 10941 8192000000 10848841808 11270348800 1918314928 18.973 100 38 76 1 1935786944 6680544 10791472
14:33:12 3820 8192000000 10861229920 11284697088 1928711824 19.057 100 52 101 3 1950916736 7939088 14265824
14:33:28 9565 8192000000 10863561280 11289763840 1937414672 19.126 100 50 100 0 1959698448 8444560 13839216
14:33:52 18757 8192000000 10888859984 11307753472 1947398704 19.206 100 53 106 0 1971862064 9573696 14889664
14:34:23 12346 8192000000 10890734512 11315707904 1952564736 19.247 100 52 104 1 1978303072 11077200 14661136
14:34:45 15806 8192000000 10888474560 11316264960 1955822336 19.273 100 50 99 0 1981933696 11469344 14642016
14:35:17 6122 8192000000 10894092688 11319664640 1958699216 19.296 100 55 108 1 1984043152 10214656 15129280
14:35:31 29507 8192000000 10908232848 11333742592 1964379760 19.341 100 52 104 0 1992038048 12992864 14665424
14:36:13 15635 8192000000 10905508976 11340918784 1968341584 19.372 100 46 92 1 1997859664 16000544 13517536
14:36:36 12392 8192000000 10911998688 11345899520 1975093856 19.426 100 43 86 1 2003945232 15946832 12904544
14:37:08 7540 8192000000 10920345456 11349434368 1960630912 19.311 99 50 97 1 1991088848 15885200 14572736
14:37:23 3338 8192000000 10925899952 11350405120 1981087088 19.473 100 61 121 1 2016590480 17525664 17977728
14:37:33 10512 8192000000 10926508784 11352678400 1980788240 19.471 100 64 127 3 2017886816 18904624 18193952
14:37:53 6252 8192000000 10922747840 11349934080 1974846000 19.424 100 60 120 1 2012939008 20167056 17925952
14:38:06 38041 8192000000 10931717728 11364229120 1976994144 19.441 100 43 86 1 2009156512 19871728 12290640
14:38:53 7938 8192000000 10921099840 11360116736 1969441904 19.381 99 41 82 1 2002383952 21087792 11854256
14:39:10 7310 8192000000 10933149232 11363221504 1986089440 19.513 100 53 105 1 2022477344 20973984 15413920
14:39:27 15660 8192000000 10941894448 11372421120 1988876592 19.535 100 59 118 1 2028097808 21215920 18005296
14:40:06 4078 8192000000 10953779488 11381850112 1999808752 19.621 100 64 128 1 2044027648 25227760 18991136
14:40:19 9604 8192000000 10947561216 11380297728 1996114736 19.592 100 60 120 1 2039272928 25631024 17527168
14:40:36 9238 8192000000 10953693248 11377553408 1995171424 19.585 100 53 106 1 2036289648 25157888 15960336
14:40:55 16187 8192000000 10955126064 11392249856 2000922896 19.630 100 50 100 0 2043135952 27428736 14784320
14:41:21 7576 8192000000 10964720224 11400077312 2014029808 19.733 100 52 102 0 2056801424 27868208 14903408
14:41:37 7316 8192000000 10970904400 11402870784 2012232960 19.719 100 66 132 3 2064184752 32020544 19931248
14:41:57 3766 8192000000 10980793856 11410132992 1999346560 19.618 99 64 127 3 2051381680 32989408 19045712
14:42:07 2730 8192000000 10980505808 11400765440 1997712512 19.605 99 73 146 1 2054578576 34206128 22659936
14:42:16 7959 8192000000 10967443824 11392040960 1995878560 19.590 100 77 151 4 2055580240 35868832 23832848
14:42:35 7823 8192000000 10963036752 11395624960 1986400560 19.515 99 59 118 2 2038459728 33861760 18197408
14:42:51 2679 8192000000 10975559984 11404500992 2011263568 19.711 100 78 156 1 2067601456 33036160 23301728
14:43:01 3508 8192000000 10958165184 11380633600 1987837136 19.527 99 74 146 1 2042792720 32131840 22823744
14:43:12 2951 8192000000 10969448368 11390976000 1985237440 19.506 99 75 150 0 2041841392 34135824 22468128
14:43:22 2463 8192000000 10984659616 11397541888 1989352560 19.539 99 91 182 4 2052603200 36288624 26962016
14:43:33 4362 8192000000 10984146272 11406610432 2007849616 19.685 100 76 152 1 2069257680 38790528 22617536
14:43:47 6480 8192000000 10988757104 11407482880 2011766576 19.715 100 78 155 0 2073621088 39047408 22807104
14:44:00 4622 8192000000 10975130960 11394674688 1997538016 19.603 100 78 153 1 2058602144 37063424 24000704
14:44:13 15219 8192000000 10972261984 11404152832 2002190944 19.640 100 59 118 0 2057338784 36957728 18190112
14:44:37 22506 8192000000 10956864288 11395723264 1994652320 19.581 100 54 109 0 2052390032 40885024 16852688
14:45:07 8591 8192000000 10932904608 11373453312 1961421312 19.317 99 44 86 3 2014373744 39699088 13253344
14:45:26 30664 8192000000 10949611120 11388686336 1981132784 19.474 100 47 93 1 2033617616 37680560 14804272
14:46:05 8744 8192000000 10937346000 11376623616 1961893520 19.321 99 41 82 1 2019528352 44448048 13186784
14:46:21 7686 8192000000 10963968080 11395567616 1965882608 19.353 99 50 100 0 2029528672 47514032 16132032
14:46:38 5234 8192000000 10942000384 11374940160 1961349568 19.317 99 55 109 0 2026791984 49037136 16405280
14:46:50 2630 8192000000 10966185904 11394162688 1983901664 19.496 100 57 113 0 2048991744 47820496 17269584
14:47:27 3395 8192000000 10965779776 11386851328 1983925536 19.496 100 67 134 2 2045179408 40365152 20888720
14:47:37 1993 8192000000 10980181584 11398565888 1995159216 19.585 100 80 159 0 2060474784 41631776 23683792
14:47:53 2517 8192000000 10967974032 11380539392 1961083408 19.315 98 86 169 1 2029925264 42881072 25960784
14:48:07 3012 8192000000 10994670704 11407241216 1999585728 19.619 100 81 159 1 2071124736 47702016 23836992
14:48:17 5504 8192000000 10982868752 11408371712 2000027216 19.623 100 67 134 0 2068874032 47963504 20883312
14:48:31 1932 8192000000 10982143584 11405475840 1985123584 19.505 99 70 139 0 2052951376 46517968 21309824
14:48:40 7357 8192000000 10963508208 11403857920 1992383712 19.563 100 51 100 0 2054553168 46143024 16026432
14:48:57 6923 8192000000 10959849504 11396304896 1986100608 19.513 100 42 84 0 2046104176 46038480 13965088
14:49:12 4961 8192000000 10973390480 11393609728 1984597280 19.501 100 70 141 2 2054589312 47232848 22759184
14:49:23 12860 8192000000 10973094256 11403816960 1990695248 19.549 100 53 103 0 2060357408 51837168 17824992
14:49:44 16161 8192000000 10965109024 11400220672 1972666896 19.407 99 52 104 1 2043522816 53995856 16860064
14:50:08 15483 8192000000 10953643184 11394498560 1964169024 19.339 99 35 70 1 2027177184 51320608 11687552
14:50:31 7509 8192000000 10956376304 11392073728 1958216832 19.292 99 41 81 2 2025668384 53601536 13850016
14:50:47 10366 8192000000 10938085680 11381977088 1962856224 19.329 100 34 67 1 2027672208 52407888 12408096
14:51:05 10437 8192000000 10954074352 11383967744 1962560400 19.326 100 48 96 0 2031636496 53464176 15611920
14:51:22 4286 8192000000 10926323168 11347419136 1921407776 18.998 98 58 115 0 1995987440 56212704 18366960
14:51:36 8147 8192000000 10938874896 11368251392 1949762336 19.225 100 46 92 1 2018877168 54257760 14857072
14:51:51 11748 8192000000 10956427296 11390308352 1961682864 19.319 100 50 99 1 2037095040 59913056 15499120
14:52:10 4489 8192000000 10918697440 11351199744 1875677760 18.630 96 42 84 0 1956162064 66424128 14060176
14:52:21 4780 8192000000 10917495568 11348647936 1922100640 19.004 100 36 72 3 1998146832 63633440 12412752
14:52:39 11860 8192000000 10946538000 11389685760 1946317184 19.197 100 43 86 0 2034123440 73359824 14446432
14:52:58 19256 8192000000 10922516448 11368468480 1928640224 19.056 99 34 69 0 2004636112 64764432 11231456
14:53:32 7331 8192000000 10931271184 11362742272 1936492576 19.119 100 41 82 2 2007212784 56530336 14189872
14:53:52 27474 8192000000 10915167856 11365695488 1933271936 19.093 100 29 56 2 2006907568 63505376 10130256
14:54:33 21206 8192000000 10930047808 11379593216 1944991536 19.187 100 41 82 2 2024876048 65936608 13947904
14:55:01 31010 8192000000 10903779232 11357126656 1921359616 18.998 99 23 46 0 1982928400 52880784 8688000
14:55:39 19256 8192000000 10912590944 11360444416 1939212208 19.140 100 24 47 0 1995409776 47308768 8888800
14:56:06 23798 8192000000 10894220352 11358834688 1905308464 18.869 98 20 40 1 1962917120 50264480 7344176
14:56:43 56007 8192000000 10851246032 11327913984 1867707920 18.566 96 12 24 1 1894055200 21874464 4472816
14:57:45 4941 8192000000 10890332048 11329462272 1936811968 19.121 100 37 73 3 1962019968 14678960 10529040
14:58:01 21578 8192000000 10848191520 11300655104 1877474544 18.645 97 18 35 1 1893255136 10981392 4799200
14:58:30 29554 8192000000 10852004384 11305213952 1900437632 18.830 99 23 47 1 1917786928 10505024 6844272
14:59:08 41378 8192000000 10844044032 11296858112 1880874416 18.672 98 20 40 1 1899232432 12914224 5443792
15:00:03 66110 8192000000 10840290752 11290689536 1865297168 18.546 97 18 37 0 1877873840 7859616 4717056
15:01:15 40450 8192000000 10868493472 11325624320 1924728416 19.025 100 13 26 1 1936715392 8717232 3269744
15:02:03 70685 8192000000 10876209664 11334172672 1930393552 19.070 99 19 38 3 1949705488 13793392 5518544
15:03:23 131566 8192000000 10876793696 11340148736 1940325824 19.149 99 39 79 1 1960919664 8060144 12533696
15:05:45 35511 8192000000 10885746496 11346165760 1940418160 19.150 99 13 26 0 1953760992 9932512 3410320
15:06:41 101420 8192000000 10890922784 11358597120 1948022480 19.211 99 22 44 0 1972491376 17463136 7005760
15:08:31 42217 8192000000 10917129808 11369234432 1974059200 19.418 100 27 53 2 1995825552 13463760 8302592
15:09:20 42561 8192000000 10896661424 11357818880 1940653488 19.152 98 31 62 1 1965071168 14540496 9877184
15:10:14 37030 8192000000 10915848928 11375321088 1959316992 19.301 99 24 47 1 1983546320 16815280 7414048
15:10:59 10372 8192000000 10946618768 11385708544 1985781776 19.510 100 54 108 1 2022672528 20128400 16762352
15:11:19 58321 8192000000 10922512480 11384819712 1968141488 19.371 99 44 88 0 2003883504 21799248 13942768
15:12:35 153674 8192000000 10889333600 11346399232 1925983504 19.035 97 15 30 0 1951827280 21249824 4593952
15:15:34 56657 8192000000 10885619632 11393986560 1951398480 19.238 100 7 14 0 1974302352 20689408 2214464
15:16:37 32250 8192000000 10899422400 11343699968 1925799616 19.033 98 28 57 2 1941146704 7822928 7524160
15:17:16 11682 8192000000 10924424032 11364724736 1975505024 19.429 100 68 135 1 2008964848 12436064 21023760
15:17:35 27490 8192000000 10900950496 11354910720 1927662112 19.048 98 21 42 1 1947144768 13058256 6424400
15:18:09 43566 8192000000 10912511040 11354968064 1954921776 19.266 99 34 68 2 1980181776 15872944 9387056
15:19:05 32150 8192000000 10918124784 11379867648 1976856064 19.440 100 46 93 1 2014149712 23740976 13552672
15:19:46 48068 8192000000 10898531760 11367886848 1953409920 19.254 99 16 32 0 1973441344 14962448 5068976
15:20:40 134960 8192000000 10923797728 11385765888 1968599216 19.374 100 2 4 0 1989637680 20644544 393920
15:23:02 50967 8192000000 10911512944 11380596736 1943117600 19.172 98 7 14 1 1959431920 14056304 2258016
15:23:59 93796 8192000000 10902210256 11373260800 1944585824 19.183 98 16 32 2 1966781872 17836976 4359072
15:25:43 34828 8192000000 10956255296 11396091904 1993061776 19.568 100 43 86 2 2018121056 12784896 12274384
15:26:32 64696 8192000000 10936418160 11404218368 1949683136 19.224 98 24 48 1 1975201232 19089088 6429008
15:27:43 107226 8192000000 10910249840 11378200576 1977862736 19.448 100 16 32 0 2004839072 22110560 4865776
15:29:36 85804 8192000000 10925550384 11398946816 1969337328 19.380 99 19 35 2 1990469392 16136352 4995712
15:31:17 46992 8192000000 10898438144 11369349120 1948443424 19.214 98 20 40 0 1971457936 17006448 6008064
15:32:11 31386 8192000000 10899796112 11351805952 1931000784 19.075 98 20 40 1 1951228224 15194464 5032976
15:32:49 44174 8192000000 10891716832 11355279360 1927563008 19.047 98 34 68 0 1956044224 19139616 9341600
15:33:48 65692 8192000000 10860608464 11340959744 1902210608 18.844 98 11 22 1 1928652992 23013040 3429344
15:35:00 31994 8192000000 10885115504 11351420928 1944025920 19.179 100 23 46 2 1963064048 12695152 6342976
15:35:42 40821 8192000000 10880685840 11340480512 1921472512 18.999 98 14 25 2 1938014096 12515248 4026336
15:36:41 57052 8192000000 10859273904 11326001152 1898815264 18.817 98 18 36 0 1918239104 14127936 5295904
15:37:49 47300 8192000000 10881903216 11348193280 1915189504 18.948 98 13 26 0 1932648752 13252592 4206656
15:39:16 61285 8192000000 10867150400 11336818688 1886166672 18.715 97 11 22 0 1905287968 16052272 3069024
15:40:33 70814 8192000000 10848769248 11317534720 1903286960 18.853 98 13 26 0 1919377392 12763184 3327248
15:42:02 38125 8192000000 10888745056 11341590528 1908580800 18.895 98 39 77 1 1932811824 12550384 11680640
15:43:11 24711 8192000000 10902412976 11355766784 1938023776 19.131 99 43 86 0 1972665872 22294816 12347280
15:43:47 43733 8192000000 10874850944 11344138240 1921221936 18.997 99 13 26 0 1940192032 15372192 3597904
15:44:36 66699 8192000000 10894957920 11343552512 1908739136 18.897 98 29 56 1 1930788400 12893808 9155456
15:45:54 70808 8192000000 10896305200 11350790144 1907769024 18.889 98 19 38 0 1926439120 13534224 5135872
15:47:13 54291 8192000000 10887828800 11345252352 1892254752 18.764 97 34 68 1 1918666896 16293280 10118864
15:48:27 74632 8192000000 10880368800 11330277376 1865017824 18.544 96 23 46 1 1885747808 14701600 6028384
15:50:05 47102 8192000000 10911665696 11369746432 1949932624 19.226 100 34 68 2 1981494576 22336640 9225312
15:51:04 71995 8192000000 10888280288 11371458560 1894582240 18.783 97 12 24 1 1920005296 22096992 3326064
15:52:24 85068 8192000000 10885702672 11364978688 1903703792 18.856 98 7 14 2 1926652304 20902640 2045872
15:54:04 86482 8192000000 10889122176 11354570752 1956303344 19.277 100 32 64 0 1982436320 16867776 9265200
15:56:14 28365 8192000000 10885287472 11347120128 1947699488 19.208 100 26 52 0 1965730768 10717568 7313712
15:56:50 15108 8192000000 10881880384 11337322496 1950334080 19.229 100 41 83 1 1971113040 9012720 11766240
15:57:12 40145 8192000000 10875361616 11341369344 1932192224 19.084 99 27 54 0 1952830000 12893088 7744688
15:58:10 93585 8192000000 10867108032 11342057472 1917059616 18.963 98 14 28 2 1930481792 9451520 3970656
15:59:50 31786 8192000000 10888826672 11361796096 1956214560 19.276 100 10 20 0 1974545248 15386352 2944336
16:00:34 52916 8192000000 10882718336 11365281792 1945782208 19.193 99 19 38 1 1964998240 13817088 5398944
16:01:34 69508 8192000000 10870916112 11336015872 1920465568 18.991 98 19 38 2 1940404512 14895472 5043472
16:02:50 71558 8192000000 10847742624 11317125120 1888022864 18.730 97 13 26 0 1905496048 12864944 4608240
16:04:11 65877 8192000000 10865037312 11327815680 1898370800 18.813 98 24 48 2 1911658560 6672784 6614976
16:05:34 67796 8192000000 10876469344 11351760896 1939761024 19.145 100 11 22 0 1952156784 9959920 2435840
16:06:50 20000 8192000000 10875546720 11342286848 1935020896 19.107 99 20 39 2 1946758352 5893968 5843488
16:07:19 39414 8192000000 10900835616 11363373056 1963579424 19.334 100 23 46 2 1979468880 8888080 7001376
16:08:08 46977 8192000000 10893900704 11370487808 1935351840 19.110 98 28 56 1 1952485456 9391104 7742512
16:09:01 100201 8192000000 10911125344 11388739584 1956898736 19.281 99 12 26 0 1976127056 15304496 3923824
16:10:53 126844 8192000000 10919285840 11403358208 1929586656 19.064 97 12 24 0 1953354992 20050544 3717792
16:13:07 89483 8192000000 10928096240 11384504320 1946892848 19.202 98 22 42 2 1965396352 12522832 5980672
16:14:43 43646 8192000000 10917275504 11386478592 1969303728 19.380 99 28 56 2 1989891424 12592080 7995616
16:15:42 56913 8192000000 10916478064 11378827264 1946541392 19.199 98 22 44 1 1965242992 12374352 6327248
16:17:31 37363 8192000000 10923712592 11384684544 1960546848 19.310 99 34 67 2 1979729728 9874160 9308720
16:18:21 32203 8192000000 10926156288 11398582272 1972985376 19.409 99 41 80 3 2000349280 15666784 11697120
16:19:09 126413 8192000000 10904223136 11373150208 1920528560 18.991 97 20 40 0 1942754160 16332352 5893248
16:21:39 87450 8192000000 10871938960 11338010624 1914339088 18.941 97 16 32 0 1926955600 8499600 4116912
16:23:15 65077 8192000000 10884194384 11365388288 1949000080 19.219 99 17 34 2 1965029808 11270848 4758880
16:24:36 97152 8192000000 10891317296 11371565056 1943239968 19.173 99 12 24 0 1965600128 19087920 3272240
16:26:23 57926 8192000000 10864647472 11342139392 1880210288 18.667 96 12 24 1 1903092848 19181632 3700928
16:27:44 67128 8192000000 10855901840 11338248192 1904231856 18.860 98 15 30 0 1921309392 12560352 4517184
16:29:05 64204 8192000000 10857174320 11328966656 1898358096 18.813 98 21 42 0 1918947440 14521968 6067376
16:30:30 79617 8192000000 9536694832 9858273280 685835792 7.725 36 3 6 0 693601952 7202128 564032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-01-2021 16:33:26 to 18-01-2021 16:33:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-01-2021 16:33:58 to 18-01-2021 16:34:00.

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          232279
MON$OLDEST_ACTIVE               232280
MON$OLDEST_SNAPSHOT             232280
MON$NEXT_TRANSACTION            232280
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                       2023488
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'

18.01.21 16:34:01. 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-18 16:34:03 No severe PSQL-related problems occured
18.01.21 16:34:04. End of report.