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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-06 16:27:19
DTS_END                         2021-03-06 16:27:19.5700
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/33936
TRN_ID                          251198
ATT_ID                          714
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: 9730.85 15696 1167702
customer order: creation 190.46 318 22855
customer order: refuse 15.78 313 1893
order to supplier: creation 50.37 1201 6044
order to supplier: removal 3.79 86568 455
invoice (draft): creation 49.92 3121 5990
invoice (draft): removal 55.23 688 6628
invoice accept: apply 45.57 16201 5468
invoice accept: cancel 49.96 753 5995
customer reserve: creation 4107.59 166 492911
customer reserve: removal 4841.35 53 580962
realization accept: apply 91.53 154 10984
realization accept: cancel 88.78 99 10653
payment from customer: creation 64.52 100 7742
payment from customer: removal 5.90 88 708
payment to supplier: creation 53.00 121 6360
payment to supplier: removal 3.75 55 450
service: total inventory turnovers 5.09 981 611
service: total monetary turnovers 7.33 24 880
service: aggregate perf. data 0.91 19647 109
service: refresh index statistics 0.03 183278 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-03-2021 16:27:59 to 06-03-2021 16:28:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6431
TEST_TIME 2 6517
TEST_TIME 3 5834
TEST_TIME 4 6047
TEST_TIME 5 5969
TEST_TIME 6 5429
TEST_TIME 7 5410
TEST_TIME 8 5710
TEST_TIME 9 6293
TEST_TIME 10 6155
TEST_TIME 11 6494
TEST_TIME 12 6315
TEST_TIME 13 6524
TEST_TIME 14 7053
TEST_TIME 15 7113
TEST_TIME 16 7114
TEST_TIME 17 7627
TEST_TIME 18 7574
TEST_TIME 19 8592
TEST_TIME 20 8801
TEST_TIME 21 8809
TEST_TIME 22 9029
TEST_TIME 23 9344
TEST_TIME 24 9485
TEST_TIME 25 10093
TEST_TIME 26 9919
TEST_TIME 27 10682
TEST_TIME 28 11050
TEST_TIME 29 10850
TEST_TIME 30 10843
TEST_TIME 31 10692
TEST_TIME 32 10652
TEST_TIME 33 10669
TEST_TIME 34 10634
TEST_TIME 35 10565
TEST_TIME 36 10604
TEST_TIME 37 10703
TEST_TIME 38 10673
TEST_TIME 39 10538
TEST_TIME 40 10297
TEST_TIME 41 10296
TEST_TIME 42 10351
TEST_TIME 43 10239
TEST_TIME 44 10171
TEST_TIME 45 10170
TEST_TIME 46 10112
TEST_TIME 47 10053
TEST_TIME 48 10208
TEST_TIME 49 10114
TEST_TIME 50 9985
TEST_TIME 51 9997
TEST_TIME 52 10011
TEST_TIME 53 10027
TEST_TIME 54 9899
TEST_TIME 55 9828
TEST_TIME 56 9777
TEST_TIME 57 9721
TEST_TIME 58 9679
TEST_TIME 59 9657
TEST_TIME 60 9692
TEST_TIME 61 9708
TEST_TIME 62 9725
TEST_TIME 63 9788
TEST_TIME 64 9811
TEST_TIME 65 9794
TEST_TIME 66 9797
TEST_TIME 67 9926
TEST_TIME 68 9942
TEST_TIME 69 9950
TEST_TIME 70 9942
TEST_TIME 71 9906
TEST_TIME 72 9934
TEST_TIME 73 9934
TEST_TIME 74 9817
TEST_TIME 75 9861
TEST_TIME 76 9795
TEST_TIME 77 9799
TEST_TIME 78 9753
TEST_TIME 79 9701
TEST_TIME 80 9648
TEST_TIME 81 9635
TEST_TIME 82 9646
TEST_TIME 83 9633
TEST_TIME 84 9649
TEST_TIME 85 9623
TEST_TIME 86 9672
TEST_TIME 87 9642
TEST_TIME 88 9652
TEST_TIME 89 9656
TEST_TIME 90 9669
TEST_TIME 91 9684
TEST_TIME 92 9814
TEST_TIME 93 9808
TEST_TIME 94 9853
TEST_TIME 95 9798
TEST_TIME 96 9903
TEST_TIME 97 9819
TEST_TIME 98 9767
TEST_TIME 99 9726
TEST_TIME 100 9676
TEST_TIME 101 9709
TEST_TIME 102 9665
TEST_TIME 103 9648
TEST_TIME 104 9595
TEST_TIME 105 9578
TEST_TIME 106 9516
TEST_TIME 107 9578
TEST_TIME 108 9564
TEST_TIME 109 9569
TEST_TIME 110 9582
TEST_TIME 111 9567
TEST_TIME 112 9612
TEST_TIME 113 9594
TEST_TIME 114 9623
TEST_TIME 115 9603
TEST_TIME 116 9731
TEST_TIME 117 9740
TEST_TIME 118 9764
TEST_TIME 119 9804
TEST_TIME 120 9739

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-03-2021 16:28:03 to 06-03-2021 16:28:06.

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 1624816 1624816 0 0.00 0 13256 6 0 0
doc_list_biud 1624816 1624816 0 0.00 0 28764 24 0 0
sp_add_invoice_to_stock 5578 5468 110 1.97 20 168257 16202 0 110
sp_cancel_adding_invoice 5995 5995 0 0.00 4 74454 754 0 0
sp_cancel_client_order 1893 1893 0 0.00 4 13652 313 0 0
sp_cancel_customer_reserve 580962 580962 0 0.00 1 28766 54 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 2 6058 89 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 3 2156 55 0 0
sp_cancel_supplier_invoice 6638 6628 10 0.15 2 13233 689 0 10
sp_cancel_supplier_order 455 455 0 0.00 9 983811 86569 0 0
sp_cancel_write_off 10653 10653 0 0.00 1 11048 99 0 0
sp_client_order 22855 22855 0 0.00 4 20203 318 0 0
sp_customer_reserve 492911 492911 0 0.00 0 140851 166 0 0
sp_fill_shopping_cart 34885 34885 0 0.00 1 14656 34 0 0
sp_fill_shopping_cart_clo_res 492904 492904 0 0.00 0 10583 11 0 0
sp_get_clo_for_invoice 5456 5456 0 0.00 0 13960 240 0 0
sp_kill_cost_storno 17806 17806 0 0.00 0 7272 50 0 0
sp_kill_qstorno_ret_qs2qd 1179660 1179660 0 0.00 0 27403 29 0 0
sp_kill_qty_storno 623026 623026 0 0.00 0 28764 63 0 0
sp_lock_selected_doc 22722 22722 0 0.00 0 8232 4 0 0
sp_make_cost_storno 30542 30542 0 0.00 0 13254 44 0 0
sp_multiply_rows_for_pdistr 30542 30542 0 0.00 0 6405 29 0 0
sp_multiply_rows_for_qdistr 22855 22855 0 0.00 0 10329 151 0 0
sp_pay_from_customer 7742 7742 0 0.00 4 7955 101 0 0
sp_pay_to_supplier 6360 6360 0 0.00 4 11064 121 0 0
sp_payment_common 14102 14102 0 0.00 1 10807 29 0 0
sp_qd_handle_on_cancel_clo 1893 1893 0 0.00 0 13644 296 0 0
sp_qd_handle_on_invoice_upd_sts 11451 11451 0 0.00 0 14665 292 0 0
sp_qd_handle_on_reserve_upd_sts 10984 10984 0 0.00 0 15923 51 0 0
sp_reserve_write_off 10984 10984 0 0.00 6 15967 154 0 0
sp_supplier_invoice 5990 5990 0 0.00 6 75550 3121 0 0
sp_supplier_order 6044 6044 0 0.00 5 25972 1201 0 0
srv_aggregate_perf_data 109 109 0 0.00 2777 161799 19648 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1689 172808 32293 0 0
srv_find_qd_qs_mism 1116295 1116295 0 0.00 0 11077 5 0 0
srv_make_invnt_saldo 611 611 0 0.00 45 37693 982 0 0
srv_make_money_saldo 880 880 0 0.00 1 2896 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 116057 265065 183279 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5468 5468 0 0.00 0 24966 143 0 0
t$perf-norm:sp_cancel_adding_invoice 473 473 0 0.00 0 2156 79 0 0
t$perf-norm:sp_cancel_client_order 1893 1893 0 0.00 0 3460 14 0 0
t$perf-norm:sp_cancel_customer_reserve 737 737 0 0.00 0 5852 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 439 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 16069 40 0 0
t$perf-norm:sp_cancel_supplier_invoice 439 439 0 0.00 0 452 10 0 0
t$perf-norm:sp_cancel_supplier_order 455 455 0 0.00 0 47092 1716 0 0
t$perf-norm:sp_cancel_write_off 1127 1127 0 0.00 0 1739 7 0 0
t$perf-norm:sp_client_order 22855 22855 0 0.00 0 11767 17 0 0
t$perf-norm:sp_customer_reserve 1030 1030 0 0.00 0 849 3 0 0
t$perf-norm:sp_pay_from_customer 7742 7742 0 0.00 0 10720 12 0 0
t$perf-norm:sp_pay_to_supplier 6360 6360 0 0.00 0 9596 12 0 0
t$perf-norm:sp_reserve_write_off 10984 10984 0 0.00 0 9250 10 0 0
t$perf-norm:sp_supplier_invoice 5990 5990 0 0.00 0 6204 15 0 0
t$perf-norm:sp_supplier_order 6044 6044 0 0.00 0 7619 18 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 1261 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1656 15 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 7720 29 0 0
t$perf-norm:srv_make_money_saldo 880 880 0 0.00 0 816 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11130 10910 220 1.97 0 9490 16 0 220
v_all_customers 41734 41734 0 0.00 0 58 1 0 0
v_all_suppliers 32942 32942 0 0.00 0 15 1 0 0
v_all_wares 45710 45710 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 946 946 0 0.00 0 1449 7 0 0
v_cancel_client_order 3786 3786 0 0.00 0 3753 3 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 1333 5 0 0
v_cancel_customer_reserve 1474 1474 0 0.00 0 3710 12 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 907 4 0 0
v_cancel_supplier_invoice 898 878 20 2.22 0 2915 19 0 20
v_cancel_supplier_order 910 910 0 0.00 0 600 5 0 0
v_cancel_write_off 2254 2254 0 0.00 0 3773 13 0 0
v_max_id_clo_ord 6044 6044 0 0.00 0 5518 2 0 0
v_max_id_clo_res 1030 1030 0 0.00 0 2114 13 0 0
v_max_id_ord_sup 5986 5986 0 0.00 0 5181 4 0 0
v_max_non_paid_invoice 1919 1919 0 0.00 0 880 3 0 0
v_max_non_paid_realizn 4073 4073 0 0.00 0 4444 5 0 0
v_min_id_clo_ord 6044 6044 0 0.00 0 4775 7 0 0
v_min_id_clo_res 1030 1030 0 0.00 0 5701 14 0 0
v_min_id_ord_sup 5986 5986 0 0.00 0 3606 7 0 0
v_min_non_paid_invoice 6360 6360 0 0.00 0 10784 20 0 0
v_min_non_paid_realizn 7742 7742 0 0.00 0 6669 19 0 0
v_our_firm 11314 11314 0 0.00 0 13 1 0 0
v_reserve_write_off 21968 21968 0 0.00 0 3797 5 0 0
x_lock_depdocs_on_canc_invoice 12184 12184 0 0.00 0 18743 100 0 0
x_lock_depdocs_on_canc_sup_ord 455 455 0 0.00 0 7646 288 0 0
x_make_qstorno_1000_1200 6044 6044 0 0.00 2 25950 1125 0 0
x_make_qstorno_1200_2000 5990 5990 0 0.00 3 75538 3000 0 0
x_make_qstorno_2100_3300 492911 492911 0 0.00 0 140849 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-03-2021 16:28:07 to 06-03-2021 16:28:11.

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
13:57:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 12422 8192000000 10224026224 10522136576 799275072 8.889 65 51 104 0 820407008 2238720 18893216
13:57:49 21800 8192000000 10337036016 10646855680 1362371936 14.259 100 88 176 0 1395999648 4387264 29240448
13:58:23 15273 8192000000 10344725152 10658721792 1404985152 14.639 100 92 184 0 1441364080 6176576 30202352
13:58:49 31057 8192000000 10366752272 10690154496 1422375568 14.794 100 88 176 0 1458181344 6783440 29022336
13:59:33 27723 8192000000 10398030608 10723676160 1450475760 15.042 100 89 178 1 1487556192 7880624 29199808
14:00:09 32673 8192000000 10422999952 10755203072 1471395328 15.226 100 86 172 0 1507963792 8647168 27921296
14:00:51 9031 8192000000 10451055264 10782773248 1500873488 15.484 100 93 185 0 1539754336 9424496 29456352
14:01:11 20752 8192000000 10476360064 10816630784 1529512208 15.733 100 80 160 1 1564046448 9449472 25084768
14:01:44 14931 8192000000 10507086480 10852278272 1559352912 15.991 100 76 151 4 1592287616 9858032 23076672
14:02:06 11778 8192000000 10522536960 10874130432 1584347248 16.205 100 79 158 1 1620035712 10470784 25217680
14:02:28 13463 8192000000 10565063648 10921889792 1618554912 16.498 100 79 158 0 1653141216 10804192 23782112
14:02:50 15567 8192000000 10579544416 10939863040 1640892608 16.687 100 85 170 0 1678116400 11473536 25750256
14:03:12 12374 8192000000 10607614928 10969018368 1666885616 16.907 100 84 168 2 1703515216 12104480 24525120
14:03:38 8641 8192000000 10622680048 10991620096 1679425728 17.013 100 72 144 0 1712226224 11401040 21399456
14:03:53 10626 8192000000 10647616624 11012943872 1695516480 17.148 100 73 146 0 1728301824 11928224 20857120
14:04:12 7611 8192000000 10655301616 11027365888 1717783360 17.334 100 81 163 2 1753950528 12306896 23860272
14:04:27 5690 8192000000 10672527984 11041890304 1730835984 17.442 100 80 160 0 1766607184 12664736 23106464
14:04:40 4340 8192000000 10676255008 11048980480 1738932976 17.510 100 74 148 1 1772337888 12545152 20859760
14:04:53 5356 8192000000 10696280160 11070320640 1755773280 17.649 100 88 175 2 1793465232 12898032 24793920
14:05:06 6316 8192000000 10705427920 11081863168 1767265344 17.744 100 86 169 1 1804581216 13719888 23595984
14:05:19 3448 8192000000 10716248704 11095269376 1773966224 17.800 100 84 169 0 1810767024 13382720 23418080
14:05:29 5785 8192000000 10716847200 11099435008 1780889232 17.857 100 75 150 1 1815407776 13597232 20921312
14:05:41 3947 8192000000 10729350800 11106185216 1792694656 17.954 100 90 181 2 1831931312 14419312 24817344
14:05:52 4091 8192000000 10740694016 11118309376 1796320816 17.984 100 79 156 0 1830669248 12680976 21667456
14:06:03 3261 8192000000 10746848096 11125616640 1802941408 18.038 100 82 163 3 1839246976 13221328 23084240
14:06:13 7495 8192000000 10743783056 11130691584 1811970176 18.112 100 77 155 1 1846632832 13114656 21548000
14:06:28 3931 8192000000 10758450960 11142926336 1813970128 18.128 100 78 156 1 1847028816 11453312 21605376
14:06:38 2843 8192000000 10774629168 11154055168 1824907520 18.218 100 91 182 0 1863570176 12900256 25762400
14:06:48 2875 8192000000 10773035008 11155472384 1830588304 18.264 100 91 182 0 1870040176 13939760 25512112
14:06:57 2390 8192000000 10781641024 11164672000 1833106528 18.285 100 89 178 1 1871359968 13330528 24922912
14:07:05 2933 8192000000 10784367776 11169472512 1843086560 18.366 100 87 173 1 1880178304 12602144 24489600
14:07:15 2605 8192000000 10789944336 11176587264 1849344976 18.417 100 94 187 0 1888027088 12918448 25763664
14:07:24 1830 8192000000 10798946512 11181809664 1849287888 18.416 100 95 191 0 1890214544 14083120 26843536
14:07:32 1994 8192000000 10792389200 11178561536 1851636304 18.435 100 95 187 2 1890464416 13001616 25826496
14:07:40 1526 8192000000 10801621824 11188166656 1861514352 18.516 100 95 190 3 1901164320 13470240 26179728
14:07:48 1650 8192000000 10798053296 11192066048 1859877008 18.502 100 83 167 0 1897363712 13746368 23740336
14:07:56 23354 8192000000 10808472704 11197804544 1866084400 18.553 100 72 143 0 1898037376 12516592 19436384
14:08:26 3001 8192000000 10796054496 11201601536 1866556720 18.556 100 59 118 1 1894718896 11895152 16267024
14:08:37 2058 8192000000 10806503216 11201867776 1869804864 18.583 100 74 149 4 1901483664 10628848 21049952
14:08:45 3631 8192000000 10790516032 11198300160 1866617968 18.557 100 46 92 1 1888744960 9191888 12935104
14:08:55 3208 8192000000 10794122144 11204198400 1869968160 18.584 100 43 85 0 1891218560 9615872 11634528
14:09:05 3016 8192000000 10797812432 11206623232 1873109088 18.609 100 46 90 2 1894541008 8820560 12611360
14:09:18 5153 8192000000 10792522336 11209785344 1875999520 18.633 100 43 82 3 1896095168 8575936 11519712
14:09:32 2800 8192000000 10789118688 11209420800 1877451968 18.645 100 36 73 1 1894452592 6870080 10130544
14:09:41 6318 8192000000 10785150608 11212316672 1879460336 18.661 100 35 69 3 1894729664 6199728 9069600
14:09:54 5777 8192000000 10796548944 11218677760 1883104016 18.690 100 35 67 0 1900290160 8265056 8921088
14:10:08 6733 8192000000 10793385808 11219869696 1884781744 18.704 100 29 58 1 1899254608 6395984 8076880
14:10:22 5607 8192000000 10788304112 11219877888 1884784896 18.704 100 20 41 1 1896955648 5777664 6393088
14:10:34 14002 8192000000 10794326912 11223769088 1888125856 18.731 100 21 41 1 1904650704 10571808 5953040
14:10:57 11972 8192000000 10811366928 11231842304 1891655456 18.759 100 36 72 2 1912309936 10213552 10440928
14:11:15 80119 8192000000 10798613056 11234291712 1889607232 18.743 100 23 46 2 1902495328 6170784 6717312
14:12:41 5066 8192000000 10819151664 11241578496 1897107744 18.803 100 41 84 3 1915279344 7425712 10745888
14:12:54 2934 8192000000 10831056640 11253108736 1902342160 18.845 100 54 109 2 1930852656 13716752 14793744
14:13:06 4268 8192000000 10819508912 11249807360 1901798128 18.841 100 36 72 0 1918743664 6920432 10025104
14:13:18 4432 8192000000 10822038992 11247136768 1901616304 18.839 100 35 69 1 1918492848 7238576 9637968
14:13:28 5155 8192000000 10811527680 11245158400 1900234800 18.828 100 26 52 1 1913580352 5532768 7812784
14:13:42 8552 8192000000 10805028864 11247407104 1902067680 18.843 100 23 46 1 1914575168 6329472 6178016
14:13:56 12310 8192000000 10808740800 11248410624 1905961664 18.874 100 23 46 0 1917568880 4977488 6629728
14:14:15 9430 8192000000 10818208864 11252961280 1905336928 18.869 100 23 45 3 1917143936 5698768 6108240
14:14:30 8695 8192000000 10813123472 11251671040 1905884736 18.874 100 17 34 0 1916758704 5914720 4959248
14:14:45 13423 8192000000 10811593712 11248201728 1889242656 18.740 99 23 46 1 1901116608 5608064 6265888
14:15:05 7973 8192000000 10822784512 11255119872 1887974192 18.729 99 16 32 0 1902169920 9474528 4721200
14:15:21 9308 8192000000 10824953104 11254382592 1906672608 18.880 100 23 45 1 1919760256 6724016 6363632
14:15:37 30264 8192000000 10812187552 11249860608 1870453232 18.588 98 38 76 1 1892100240 10768032 10878976
14:16:14 37480 8192000000 10849684528 11263922176 1915633568 18.952 100 60 120 0 1940616976 5630064 19353344
14:16:57 7833 8192000000 10823873968 11261919232 1910991184 18.915 100 24 48 2 1924293968 7088976 6213808
14:17:14 8046 8192000000 10825478384 11259211776 1911913728 18.922 100 21 41 3 1923588000 5237344 6436928
14:17:31 4102 8192000000 10800806016 11231252480 1847679456 18.403 97 28 56 0 1861673872 5960448 8033968
14:17:45 6818 8192000000 10802936240 11221999616 1865051488 18.544 99 29 55 1 1880048224 6897808 8098928
14:18:02 6452 8192000000 10772459712 11207782400 1815612576 18.142 96 24 48 3 1829508752 6630240 7265936
14:18:15 8327 8192000000 10802034384 11228368896 1864607584 18.541 99 29 58 3 1881930128 9284208 8038336
14:18:29 4490 8192000000 10786511600 11208626176 1869574176 18.581 100 36 72 3 1886795328 6729296 10491856
14:18:40 6932 8192000000 10733387792 11149484032 1769884480 17.766 96 27 54 4 1783303056 5589152 7829424
14:18:53 8531 8192000000 10746989040 11163869184 1767823248 17.749 96 21 42 0 1779522048 5568048 6130752
14:19:12 6732 8192000000 10725825072 11130703872 1752156480 17.619 95 31 62 0 1766594112 5600144 8837488
14:19:28 6626 8192000000 10680023456 11090845696 1687840576 17.083 93 23 46 1 1699896496 5610064 6445856
14:19:41 9284 8192000000 10700094000 11114905600 1717639584 17.333 96 26 52 0 1731181664 5359120 8182960
14:19:58 11193 8192000000 10734804448 11141201920 1758178304 17.669 97 22 45 0 1773729152 9308864 6241984
14:20:20 6721 8192000000 10728145440 11131420672 1751921200 17.618 97 25 50 0 1765458416 4533712 9003504
14:21:08 37031 8192000000 10693403424 11114508288 1721823792 17.367 95 31 61 0 1735966144 4660416 9481936
14:21:52 10310 8192000000 10708528064 11122962432 1753532800 17.631 97 33 64 1 1768448992 5941264 8974928
14:22:09 3760 8192000000 10730686128 11146907648 1807329920 18.074 100 42 82 1 1824433344 5489040 11614384
14:22:19 5025 8192000000 10740092208 11156234240 1806677376 18.069 99 33 67 0 1822873168 6861968 9333824
14:22:32 6234 8192000000 10735113152 11156221952 1794466176 17.968 98 41 84 0 1812685904 6976288 11243440
14:22:47 6594 8192000000 10756538128 11174834176 1837889120 18.324 100 37 73 2 1854606768 6856768 9860880
14:23:01 8592 8192000000 10738923200 11149287424 1761035728 17.693 96 32 64 2 1784002624 13555120 9411776
14:23:19 7234 8192000000 10750616512 11173560320 1835203104 18.302 100 25 50 0 1847902976 5405680 7294192
14:23:33 8049 8192000000 10759484576 11183947776 1845936768 18.389 100 27 54 3 1859487760 5958544 7592448
14:23:47 11589 8192000000 10762244800 11191484416 1850919408 18.430 100 19 38 1 1861911984 5237504 5755072
14:24:06 11400 8192000000 10776460880 11200155648 1858814608 18.494 100 25 48 2 1872503456 6090464 7598384
14:24:33 8552 8192000000 10777487584 11205337088 1862117264 18.520 100 14 28 0 1872873968 5586608 5170096
14:24:48 20288 8192000000 10775474128 11206807552 1866272368 18.554 100 15 30 2 1875890576 5480352 4137856
14:25:16 65989 8192000000 10781009680 11216433152 1868835296 18.575 100 25 51 0 1880836032 5039344 6961392
14:26:28 15843 8192000000 10790309536 11219333120 1869038800 18.576 100 10 20 2 1876968160 5451504 2477856
14:26:52 7682 8192000000 10814838528 11231956992 1883910416 18.697 100 43 86 0 1903881232 7677024 12293792
14:27:09 7044 8192000000 10825725680 11249688576 1896952976 18.802 100 40 80 2 1915532304 7218432 11360896
14:27:27 35524 8192000000 10833722880 11256647680 1907425024 18.886 100 34 68 3 1925516688 8687488 9404176
14:28:16 5624 8192000000 10854331312 11273113600 1919871712 18.986 100 52 102 0 1944623392 10495824 14255856
14:28:30 9610 8192000000 10866523344 11285069824 1927410112 19.046 100 60 116 1 1955701584 12359280 15932192
14:28:48 5512 8192000000 10879478464 11292758016 1934867888 19.106 100 66 132 1 1966138352 13034816 18235648
14:29:06 8876 8192000000 10875658928 11296645120 1937422000 19.126 100 54 108 0 1965721616 13019008 15280608
14:29:25 9189 8192000000 10879758592 11299950592 1943886464 19.178 100 52 105 0 1970792352 12099888 14806000
14:29:42 15243 8192000000 10883141648 11310346240 1949473184 19.222 100 58 116 1 1978665280 12893296 16298800
14:30:09 20092 8192000000 10889371968 11322363904 1954980592 19.266 100 51 102 1 1985228688 15427648 14820448
14:30:40 19276 8192000000 10886482624 11320463360 1956355600 19.277 100 40 80 3 1983127728 14945088 11827040
14:31:13 33586 8192000000 10912756624 11342860288 1972360896 19.404 100 44 86 2 2002507376 16180768 13965712
14:31:58 33077 8192000000 10919497808 11351478272 1974804768 19.424 100 35 70 0 2002796176 16803520 11187888
14:32:39 18346 8192000000 10911070112 11347652608 1977818096 19.447 100 48 94 2 2007715552 14697072 15200384
14:33:23 21072 8192000000 10925543936 11357216768 1983027680 19.489 100 44 87 0 2012541600 16678032 12835888
14:33:51 12253 8192000000 10938173776 11367415808 1991397664 19.555 100 54 107 0 2024842160 17638160 15806336
14:34:14 5256 8192000000 10947756096 11374731264 1997871424 19.606 100 61 122 1 2035365424 19529632 17964368
14:34:27 9292 8192000000 10947222896 11372351488 1997347872 19.602 100 72 144 2 2038407504 20531472 20528160
14:35:00 3975 8192000000 10942362816 11374637056 1995246480 19.585 100 52 102 2 2031637248 21210256 15180512
14:35:25 1771 8192000000 10944723568 11363954688 1985537808 19.509 99 75 151 0 2029987376 21869840 22579728
14:35:34 6155 8192000000 10946461776 11381092352 2000969376 19.630 100 65 129 2 2044616736 24330464 19316896
14:35:51 5596 8192000000 10954960992 11381547008 1982852896 19.487 99 60 119 2 2026324096 24971232 18499968
14:36:04 2585 8192000000 10973962640 11388915712 2004600512 19.659 100 74 146 1 2048509168 21630272 22278384
14:36:16 8438 8192000000 10948673520 11384123392 2002324384 19.641 100 51 101 1 2038245776 20509600 15411792
14:36:33 6611 8192000000 10950484448 11390730240 2007293744 19.680 100 49 96 1 2041178768 19282256 14602768
14:36:53 7284 8192000000 10959212096 11392872448 2007874416 19.685 100 57 114 0 2044698640 19700672 17123552
14:37:08 24185 8192000000 10945837056 11381305344 1996039040 19.591 100 50 97 1 2034754784 23337984 15377760
14:37:40 6516 8192000000 10962747824 11395002368 2005918464 19.669 100 46 92 3 2044808000 24295008 14594528
14:38:01 8708 8192000000 10965180080 11404165120 2013214960 19.727 100 47 93 3 2053942176 25625184 15102032
14:38:19 9427 8192000000 10982831792 11416723456 2021632720 19.793 100 53 105 2 2064313872 25978864 16702288
14:38:36 7548 8192000000 10981823952 11419594752 2027311232 19.838 100 66 129 1 2070396816 23086832 19998752
14:39:02 11318 8192000000 10965038256 11411496960 2019075488 19.773 100 45 90 1 2057493024 24325520 14092016
14:39:22 12484 8192000000 10975970880 11415592960 2019664560 19.778 100 54 108 4 2067223024 30299936 17258528
14:39:42 7651 8192000000 10979210432 11419340800 2025454496 19.823 100 56 112 2 2071427328 28130864 17841968
14:39:59 8181 8192000000 10991203920 11426050048 2030165440 19.860 100 59 118 0 2077880192 29267856 18446896
14:40:16 8119 8192000000 10976695488 11414241280 2016552320 19.753 100 57 114 2 2064729328 30505472 17671536
14:40:36 4439 8192000000 10983579712 11417280512 2020691584 19.786 100 64 127 0 2072518400 32283056 19543760
14:40:48 3874 8192000000 10996512176 11427102720 2012058816 19.718 99 69 136 1 2069835696 36199136 21577744
14:41:01 13520 8192000000 11012496832 11442446336 2032009536 19.874 100 65 128 0 2088240688 36286176 19944976
14:41:22 1902 8192000000 11002686784 11418677248 2003027152 19.647 99 87 174 0 2066924208 37188752 26708304
14:41:30 2225 8192000000 10984816416 11410448384 2006833392 19.677 100 68 135 1 2066646608 38796800 21016416
14:41:40 2390 8192000000 10997769904 11422502912 2023733024 19.809 100 90 178 0 2082915984 31288576 27894384
14:41:51 13397 8192000000 10972860656 11412537344 2015498736 19.745 100 57 113 1 2063153584 30109024 17545824
14:42:16 3142 8192000000 10987007792 11409510400 2011121104 19.710 100 67 134 0 2061428320 29886592 20420624
14:42:26 6906 8192000000 10967475856 11399208960 2000178944 19.624 99 60 120 1 2049058736 30206976 18672816
14:42:40 2720 8192000000 10939845968 11367022592 1960132896 19.307 99 63 125 0 2011868048 31831728 19903424
14:42:50 2644 8192000000 10961484288 11377504256 1968652272 19.375 99 82 162 0 2026237472 32526400 25058800
14:43:01 5057 8192000000 10968167408 11391987712 1994819216 19.582 100 66 132 2 2049907920 34596160 20492544
14:43:12 6717 8192000000 10952149584 11373940736 1951365632 19.237 98 69 138 0 2010777232 37492400 21919200
14:43:28 5219 8192000000 10964625248 11384930304 1981429600 19.476 100 71 140 1 2042755888 38776224 22550064
14:43:41 6812 8192000000 10966879088 11389976576 1983283728 19.491 100 66 130 1 2046142736 42143344 20715664
14:44:00 5297 8192000000 10969333024 11396960256 1989244256 19.538 100 65 130 0 2050333120 40549344 20539520
14:44:14 2329 8192000000 10959474832 11379585024 1965688032 19.351 99 83 163 1 2031499760 40581248 25230480
14:44:23 3276 8192000000 10956641456 11372449792 1960528128 19.310 99 82 164 2 2026915536 40615040 25772368
14:44:37 2204 8192000000 10969063376 11386847232 1981431104 19.476 100 86 173 0 2049602160 41564800 26606256
14:44:47 2781 8192000000 10937794736 11364937728 1953522784 19.255 99 63 126 1 2014317984 40021792 20773408
14:44:58 2485 8192000000 10928877392 11354816512 1940649184 19.152 99 54 109 0 1995966800 37962224 17355392
14:45:09 2717 8192000000 10955245104 11366584320 1961838128 19.321 100 87 173 1 2029998736 40807776 27352832
14:45:21 3346 8192000000 10924997216 11341672448 1920926496 18.994 99 71 142 0 1987397984 43775168 22696320
14:45:46 4211 8192000000 10941550544 11355865088 1949301760 19.221 100 87 173 3 2023490560 46615504 27573296
14:45:57 1687 8192000000 10956447952 11367510016 1959033072 19.298 100 84 165 1 2032020464 47555280 25432112
14:46:07 4622 8192000000 10955684176 11374567424 1971550480 19.398 100 76 152 0 2045547392 49976384 24020528
14:46:18 2108 8192000000 10971286112 11386630144 1972154048 19.403 100 87 173 3 2045091760 46572192 26365520
14:46:31 6079 8192000000 10939409104 11377631232 1971151936 19.395 100 54 107 1 2031798576 43844912 16801728
14:46:47 4896 8192000000 10927761840 11372257280 1969699424 19.383 100 51 102 1 2023501488 36790816 17011248
14:47:03 10235 8192000000 10929179040 11378028544 1970825360 19.392 100 35 66 1 2013704000 31841952 11036688
14:47:22 12384 8192000000 10920641136 11362492416 1949994464 19.226 99 31 62 0 1992630640 32355584 10280592
14:47:40 7022 8192000000 10910165664 11349684224 1927967552 19.051 98 41 82 2 1973536064 32399824 13168688
14:47:55 8767 8192000000 10917360944 11360878592 1961209680 19.316 100 37 74 0 2006912688 33398288 12304720
14:48:12 6741 8192000000 10928020528 11371732992 1966461584 19.357 100 40 80 0 2017425984 38400304 12564096
14:48:26 9697 8192000000 10921065296 11350921216 1945914368 19.194 99 49 99 0 2001547760 39966256 15667136
14:48:47 12364 8192000000 10895004080 11334279168 1904456464 18.862 97 36 72 1 1956183056 39809984 11916608
14:49:06 7123 8192000000 10909222064 11350663168 1927482240 19.047 99 33 66 1 1978493776 39754016 11257520
14:49:20 6750 8192000000 10910506976 11361914880 1953201680 19.252 100 32 64 2 1997627104 34264320 10161104
14:49:34 16317 8192000000 10902333264 11344732160 1914026160 18.939 98 28 55 0 1959999616 36798112 9175344
14:49:56 8245 8192000000 10901245856 11342012416 1922595056 19.008 99 34 66 0 1971576560 37857008 11124496
14:50:13 13177 8192000000 10897842624 11350491136 1921013472 18.995 99 29 58 1 1972876192 42067584 9795136
14:50:36 28077 8192000000 10906764432 11363508224 1947192432 19.204 100 28 56 1 1993653264 37226336 9234496
14:51:16 18516 8192000000 10897064560 11344945152 1909274304 18.901 98 26 52 2 1955723344 37642096 8806944
14:51:48 9414 8192000000 10912124624 11357073408 1939570912 19.143 100 32 64 1 1992229952 41924128 10734912
14:52:29 42991 8192000000 10872122880 11335622656 1902249248 18.844 98 19 38 1 1939366032 30493872 6622912
14:53:35 17829 8192000000 10881062720 11316117504 1887327232 18.724 98 38 76 2 1932507616 32404224 12776160
14:54:02 15639 8192000000 10892647648 11326013440 1916300464 18.957 100 38 72 0 1965591200 37633616 11657120
14:54:26 24135 8192000000 10869582944 11333349376 1909356752 18.901 100 20 39 2 1950949024 34610400 6981872
14:55:01 42246 8192000000 10860211904 11313770496 1922772816 19.009 100 15 30 1 1941068784 13744496 4551472
14:55:59 68126 8192000000 10870891600 11318824960 1903734000 18.856 98 25 49 0 1920533184 9877024 6922160
14:57:13 105535 8192000000 10877432640 11334836224 1883993248 18.697 97 14 26 1 1894923456 7821968 3108240
14:59:06 71667 8192000000 10863617136 11317026816 1904212944 18.860 98 23 46 1 1921361360 10566080 6582336
15:00:36 65765 8192000000 10883942304 11343400960 1936914304 19.122 99 18 36 1 1949434480 7851328 4668848
15:01:51 73608 8192000000 10908115216 11338915840 1865730256 18.550 95 18 34 0 1877439536 6739088 4970192
15:03:12 63961 8192000000 10897338848 11360206848 1943705120 19.176 99 16 32 1 1961439472 13097360 4636992
15:04:33 108738 8192000000 10891447152 11359076352 1945889024 19.194 99 8 16 0 1964411440 16120448 2401968
15:06:28 86728 8192000000 10901893696 11344859136 1931271920 19.077 98 30 60 1 1948676144 8757104 8647120
15:08:03 16522 8192000000 10913156800 11354083328 1949039472 19.219 99 64 127 1 1979607008 12581152 17986384
15:08:27 35963 8192000000 10932609248 11367690240 1975864464 19.432 100 52 105 3 2005314512 14834752 14615296
15:09:10 16925 8192000000 10914253184 11363684352 1955337920 19.269 99 48 96 2 1980067360 10566336 14163104
15:09:38 8124 8192000000 10929083840 11372900352 1976883632 19.440 100 54 108 0 2003405824 11255776 15266416
15:09:57 100468 8192000000 10916873040 11359727616 1962919152 19.329 99 28 53 1 1978534432 7894544 7720736
15:11:44 6308 8192000000 10924235472 11378745344 1987247120 19.522 100 48 95 0 2010625088 10026528 13351440
15:11:57 14045 8192000000 10935357360 11387777024 1995171984 19.585 100 49 98 2 2020999776 10853808 14973984
15:12:18 10385 8192000000 10918459744 11385053184 1989625696 19.541 100 29 57 2 2007534096 9028240 8880160
15:12:34 13041 8192000000 10928929008 11387916288 1989194800 19.537 100 23 46 1 2006232576 9392160 7645616
15:12:53 17008 8192000000 10931244032 11390824448 1991433504 19.555 100 19 38 1 2007213616 9821648 5958464
15:13:23 6003 8192000000 10924696352 11399151616 1998646608 19.612 100 23 46 1 2020168960 14177680 7344672
15:13:52 43716 8192000000 10953702208 11402969088 1983796976 19.495 99 48 96 3 2012456192 13284832 15374384
15:14:45 19998 8192000000 10924871760 11385700352 1968409840 19.373 99 46 88 1 1997716208 16421296 12885072
15:15:12 94619 8192000000 10902227200 11383246848 1972467760 19.405 100 13 26 0 1993993168 17543712 3981696
15:16:54 143777 8192000000 10890407856 11372945408 1925416512 19.030 97 15 30 0 1946074560 16296128 4361920
15:19:58 29385 8192000000 10883442176 11359035392 1937604096 19.128 99 18 36 1 1951788528 9503280 4681152
15:20:57 108216 8192000000 10903118016 11377700864 1955726000 19.272 99 24 48 2 1971026032 8197984 7102048
15:22:51 32043 8192000000 10858530000 11335811072 1902362528 18.845 97 12 24 0 1916297728 10684992 3250208
15:23:31 27987 8192000000 10858299936 11343097856 1942229792 19.165 100 8 16 0 1957757280 13024816 2502672
15:24:05 21443 8192000000 10860904960 11349377024 1945834528 19.193 100 5 10 0 1958148128 10941632 1371968
15:24:45 15934 8192000000 10862461824 11361353728 1946090816 19.195 100 7 14 0 1959351072 11250640 2009616
15:25:09 8216 8192000000 10863655504 11357728768 1945662752 19.192 100 1 2 0 1955591728 9866848 62128
15:25:39 51624 8192000000 10888251360 11357794304 1923820240 19.017 98 17 34 0 1935730496 7393344 4516912
15:26:38 58620 8192000000 10855415072 11324796928 1805938800 18.063 92 10 20 0 1815779360 6900928 2939632
15:27:43 31920 8192000000 10834390688 11299692544 1799698752 18.011 93 24 48 2 1813552336 7157136 6696448
15:28:22 54072 8192000000 10853993840 11314896896 1784729392 17.888 93 30 60 0 1800962016 8312384 7920240
15:29:30 55471 8192000000 10868858832 11336679424 1884957600 18.705 97 33 65 2 1904441824 10609376 8874848
15:30:32 42869 8192000000 10875850576 11342069760 1904822288 18.865 98 33 65 3 1928113152 14115664 9175200
15:31:21 63414 8192000000 10883440128 11345637376 1862920400 18.527 96 19 38 0 1879117632 11265824 4931408
15:32:31 13070 8192000000 10887066080 11340992512 1929988592 19.067 99 44 88 0 1952599600 10599952 12011056
15:32:50 15004 8192000000 10881886704 11340427264 1926419104 19.038 99 44 88 3 1951052752 12298336 12335312
15:33:19 21112 8192000000 10874431312 11327696896 1882427504 18.685 97 38 76 0 1906845168 14112816 10304848
15:33:49 37320 8192000000 10859850928 11332354048 1883186384 18.691 98 30 60 0 1908879664 17353040 8340240
15:34:33 101587 8192000000 10886396688 11345690624 1854834048 18.461 96 10 20 1 1869565168 11933728 2797392
15:36:23 39022 8192000000 10869525536 11340165120 1921702832 19.000 99 19 38 1 1938546576 11483824 5359920
15:37:09 84758 8192000000 10845119136 11301822464 1760886832 17.692 91 18 36 1 1774933696 8656816 5390048
15:38:41 27911 8192000000 10864027808 11320303616 1921092320 18.996 100 35 70 0 1939540992 8655904 9792768
15:39:23 50948 8192000000 10872365168 11339137024 1914122480 18.940 99 33 66 1 1934936720 11682832 9131408
15:40:22 47216 8192000000 10854117872 11325210624 1910979392 18.915 99 13 26 0 1929114896 14214704 3920800
15:42:01 93483 8192000000 10859919872 11321987072 1876047024 18.633 97 24 48 2 1892971392 10150736 6773632
15:43:43 45730 8192000000 10834478720 11308261376 1879983552 18.665 98 22 44 0 1900715424 13610496 7121376
15:44:41 20927 8192000000 10844761136 11319365632 1916686944 18.960 100 31 56 1 1932957328 8236160 8034224
15:45:18 63997 8192000000 10852199472 11328987136 1932943856 19.090 100 19 38 0 1948744656 10457296 5343504
15:46:38 66893 8192000000 10859693376 11346374656 1939763728 19.145 100 10 20 0 1952406048 10032320 2610000
15:48:58 82460 8192000000 10871023888 11361894400 1943988464 19.179 100 12 24 0 1957254080 9740144 3525472
15:50:32 33753 8192000000 10865157072 11334414336 1910078272 18.907 98 25 50 0 1926245008 8792688 7374048
15:51:14 62987 8192000000 10862492832 11335159808 1913265824 18.933 98 26 52 0 1931463312 10588208 7609280
15:52:26 80179 8192000000 10903723840 11376766976 1961006544 19.314 100 25 50 1 1978865296 11320224 6538528
15:53:56 47498 8192000000 10893448032 11361984512 1930476912 19.071 98 26 52 0 1948454272 10526336 7451024
15:54:51 40334 8192000000 10886501376 11365847040 1935082800 19.107 99 16 32 0 1950932496 11086544 4763152
15:55:41 58119 8192000000 10902190544 11370393600 1949005008 19.219 99 28 56 1 1970228448 13463136 7760304
15:57:05 106436 8192000000 10887278656 11369623552 1868632048 18.573 95 13 26 1 1882407904 10496640 3279216
15:58:57 126407 8192000000 10924626352 11409113088 1982216256 19.482 100 10 20 0 2007506992 22666960 2623776
16:01:10 56628 8192000000 10933988656 11394088960 1970413408 19.389 99 10 20 0 1987448048 14339424 2695216
16:02:15 30207 8192000000 10928459296 11379003392 1925277344 19.029 97 29 58 4 1941084352 8073472 7733536
16:02:52 28278 8192000000 10931302528 11389337600 1956637552 19.279 99 46 92 0 1982882192 13804944 12439696
16:03:31 92921 8192000000 10903404432 11386421248 1940115088 19.148 98 18 36 0 1959182592 14262992 4804512
16:05:14 93264 8192000000 10900127920 11373584384 1886211088 18.715 95 32 64 0 1905119344 9754864 9153392
16:07:04 24168 8192000000 10894460368 11349061632 1891508624 18.758 96 36 71 0 1912602336 10735152 10358560
16:07:35 77448 8192000000 10880753312 11373383680 1942859632 19.170 99 17 34 1 1959297088 11648272 4789184
16:09:04 34382 8192000000 10874917072 11367235584 1953043584 19.251 100 7 14 0 1969960224 14785232 2131408
16:09:44 18957 8192000000 10866382512 11351900160 1934884352 19.106 99 10 20 0 1950621776 12793040 2944384
16:10:22 50763 8192000000 10870748800 11340210176 1887191904 18.723 97 21 41 3 1899767648 7191872 5383872
16:11:23 112486 8192000000 10875308736 11362480128 1937234832 19.125 99 22 43 1 1955013552 11159056 6619664
16:13:33 56626 8192000000 10843009296 11343581184 1892374064 18.765 97 16 32 2 1908023328 11163264 4486000
16:14:40 50292 8192000000 10834032240 11309125632 1824639216 18.216 94 10 20 0 1835857984 8726528 2492240
16:15:39 33236 8192000000 10851990240 11329953792 1927367776 19.046 100 19 38 0 1941127056 8161392 5597888
16:16:28 48788 8192000000 10886534480 11352395776 1925495840 19.031 99 23 45 1 1944311520 11636496 7179184
16:17:23 47443 8192000000 10849230144 11319459840 1852391248 18.442 95 24 48 2 1873176928 13127920 7657760
16:18:21 71684 8192000000 10862838720 11346620416 1879116656 18.658 97 13 26 0 1896298416 12936576 4245184
16:19:39 60668 8192000000 10871973040 11339350016 1887745008 18.728 98 11 23 0 1901993632 11129440 3119184
16:20:54 79504 8192000000 10864412128 11338473472 1914338704 18.941 99 26 52 1 1938067504 16461152 7267648
16:22:23 57341 8192000000 10873419792 11341344768 1868441936 18.572 96 37 73 1 1892465296 14089248 9934112
16:23:31 172808 8192000000 10868808112 11365695488 1788213312 17.917 93 7 14 0 1808860192 18820272 1826608
16:26:38 48144 8192000000 9347909072 9622962176 492915808 5.675 26 2 4 0 498385840 5109168 360864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 06-03-2021 16:28:13 to 06-03-2021 16:28:45.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2021 16:28:46 to 06-03-2021 16:28:48.

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

06.03.21 16:28:49. 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-03-06 16:28:51 No severe PSQL-related problems occured
06.03.21 16:28:52. End of report.