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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17265204 kB
MemAvailable 31313492 kB
Buffers 0 kB
Cached 14415584 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 01:27:11
DTS_END                         2021-01-18 01:27:11.4430
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/45274
TRN_ID                          250152
ATT_ID                          623
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: 9412.15 19479 1129458
customer order: creation 183.83 335 22060
customer order: refuse 16.09 338 1931
order to supplier: creation 49.13 1183 5896
order to supplier: removal 3.44 94176 413
invoice (draft): creation 48.93 3504 5872
invoice (draft): removal 51.44 787 6173
invoice accept: apply 44.47 17376 5336
invoice accept: cancel 47.10 783 5652
customer reserve: creation 4049.60 173 485952
customer reserve: removal 4610.23 54 553228
realization accept: apply 89.95 159 10794
realization accept: cancel 78.53 109 9423
payment from customer: creation 63.84 113 7661
payment from customer: removal 5.96 80 715
payment to supplier: creation 52.78 133 6333
payment to supplier: removal 3.63 71 436
service: total inventory turnovers 5.28 900 634
service: total monetary turnovers 6.94 24 833
service: aggregate perf. data 0.93 19318 112
service: refresh index statistics 0.03 249971 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10202
TEST_TIME 2 7900
TEST_TIME 3 6752
TEST_TIME 4 6738
TEST_TIME 5 7086
TEST_TIME 6 7069
TEST_TIME 7 6729
TEST_TIME 8 6462
TEST_TIME 9 6427
TEST_TIME 10 6245
TEST_TIME 11 6659
TEST_TIME 12 6698
TEST_TIME 13 6961
TEST_TIME 14 7395
TEST_TIME 15 7559
TEST_TIME 16 7990
TEST_TIME 17 8433
TEST_TIME 18 8723
TEST_TIME 19 8969
TEST_TIME 20 8923
TEST_TIME 21 9299
TEST_TIME 22 9372
TEST_TIME 23 10455
TEST_TIME 24 10954
TEST_TIME 25 11043
TEST_TIME 26 11234
TEST_TIME 27 10969
TEST_TIME 28 10926
TEST_TIME 29 10905
TEST_TIME 30 11042
TEST_TIME 31 11041
TEST_TIME 32 10939
TEST_TIME 33 10677
TEST_TIME 34 10717
TEST_TIME 35 10631
TEST_TIME 36 10507
TEST_TIME 37 10335
TEST_TIME 38 10190
TEST_TIME 39 10195
TEST_TIME 40 10349
TEST_TIME 41 10275
TEST_TIME 42 10131
TEST_TIME 43 9990
TEST_TIME 44 10022
TEST_TIME 45 10084
TEST_TIME 46 10030
TEST_TIME 47 10091
TEST_TIME 48 9986
TEST_TIME 49 9855
TEST_TIME 50 9757
TEST_TIME 51 9701
TEST_TIME 52 9648
TEST_TIME 53 9646
TEST_TIME 54 9685
TEST_TIME 55 9644
TEST_TIME 56 9734
TEST_TIME 57 9804
TEST_TIME 58 9731
TEST_TIME 59 9738
TEST_TIME 60 9782
TEST_TIME 61 9884
TEST_TIME 62 9869
TEST_TIME 63 9868
TEST_TIME 64 10019
TEST_TIME 65 10091
TEST_TIME 66 9959
TEST_TIME 67 9842
TEST_TIME 68 9924
TEST_TIME 69 9853
TEST_TIME 70 9841
TEST_TIME 71 9779
TEST_TIME 72 9750
TEST_TIME 73 9688
TEST_TIME 74 9666
TEST_TIME 75 9643
TEST_TIME 76 9646
TEST_TIME 77 9678
TEST_TIME 78 9721
TEST_TIME 79 9693
TEST_TIME 80 9734
TEST_TIME 81 9709
TEST_TIME 82 9712
TEST_TIME 83 9782
TEST_TIME 84 9762
TEST_TIME 85 9898
TEST_TIME 86 9921
TEST_TIME 87 9890
TEST_TIME 88 9915
TEST_TIME 89 9827
TEST_TIME 90 9806
TEST_TIME 91 9729
TEST_TIME 92 9740
TEST_TIME 93 9681
TEST_TIME 94 9678
TEST_TIME 95 9688
TEST_TIME 96 9723
TEST_TIME 97 9702
TEST_TIME 98 9691
TEST_TIME 99 9731
TEST_TIME 100 9708
TEST_TIME 101 9709
TEST_TIME 102 9729
TEST_TIME 103 9742
TEST_TIME 104 9712
TEST_TIME 105 9745
TEST_TIME 106 9754
TEST_TIME 107 9765
TEST_TIME 108 9761
TEST_TIME 109 9727
TEST_TIME 110 9653
TEST_TIME 111 9662
TEST_TIME 112 9640
TEST_TIME 113 9615
TEST_TIME 114 9589
TEST_TIME 115 9580
TEST_TIME 116 9553
TEST_TIME 117 9527
TEST_TIME 118 9495
TEST_TIME 119 9478
TEST_TIME 120 9422

Performance per minute, chart


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

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 1578858 1578858 0 0.00 0 17937 6 0 0
doc_list_biud 1578858 1578858 0 0.00 0 28857 25 0 0
sp_add_invoice_to_stock 5496 5336 160 2.91 33 171215 17376 0 160
sp_cancel_adding_invoice 5652 5652 0 0.00 5 55033 783 0 0
sp_cancel_client_order 1931 1931 0 0.00 4 11537 339 0 0
sp_cancel_customer_reserve 553228 553228 0 0.00 1 28860 55 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 3 5041 80 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 2 4644 72 0 0
sp_cancel_supplier_invoice 6186 6173 13 0.21 1 18400 787 0 13
sp_cancel_supplier_order 413 413 0 0.00 8 1016546 94177 0 0
sp_cancel_write_off 9423 9423 0 0.00 1 11979 109 0 0
sp_client_order 22060 22060 0 0.00 3 27775 335 0 0
sp_customer_reserve 485952 485952 0 0.00 0 41413 174 0 0
sp_fill_shopping_cart 33814 33814 0 0.00 1 17584 37 0 0
sp_fill_shopping_cart_clo_res 485945 485945 0 0.00 0 15357 14 0 0
sp_get_clo_for_invoice 5322 5322 0 0.00 0 25845 283 0 0
sp_kill_cost_storno 16226 16226 0 0.00 0 17925 51 0 0
sp_kill_qstorno_ret_qs2qd 1122465 1122465 0 0.00 0 28840 30 0 0
sp_kill_qty_storno 592932 592932 0 0.00 0 28856 65 0 0
sp_lock_selected_doc 22287 22287 0 0.00 0 7500 9 0 0
sp_make_cost_storno 30106 30106 0 0.00 0 10315 49 0 0
sp_multiply_rows_for_pdistr 30106 30106 0 0.00 0 7395 29 0 0
sp_multiply_rows_for_qdistr 22060 22060 0 0.00 0 18846 159 0 0
sp_pay_from_customer 7661 7661 0 0.00 4 10611 114 0 0
sp_pay_to_supplier 6333 6333 0 0.00 4 18388 134 0 0
sp_payment_common 13994 13994 0 0.00 1 18371 27 0 0
sp_qd_handle_on_cancel_clo 1931 1931 0 0.00 0 11463 305 0 0
sp_qd_handle_on_invoice_upd_sts 10970 10970 0 0.00 0 15128 322 0 0
sp_qd_handle_on_reserve_upd_sts 10794 10794 0 0.00 0 16638 50 0 0
sp_reserve_write_off 10794 10794 0 0.00 6 16653 160 0 0
sp_supplier_invoice 5872 5872 0 0.00 6 97806 3505 0 0
sp_supplier_order 5896 5896 0 0.00 6 29719 1183 0 0
srv_aggregate_perf_data 112 112 0 0.00 2811 188324 19319 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1266 138344 31093 0 0
srv_find_qd_qs_mism 1078332 1078332 0 0.00 0 13425 5 0 0
srv_make_invnt_saldo 634 634 0 0.00 43 38034 901 0 0
srv_make_money_saldo 833 833 0 0.00 1 856 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 132605 356277 249972 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5336 5336 0 0.00 0 10305 189 0 0
t$perf-norm:sp_cancel_adding_invoice 440 440 0 0.00 0 5564 106 0 0
t$perf-norm:sp_cancel_client_order 1931 1931 0 0.00 0 9097 26 0 0
t$perf-norm:sp_cancel_customer_reserve 741 741 0 0.00 0 6582 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 5808 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 1212 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1576 21 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 26917 1756 0 0
t$perf-norm:sp_cancel_write_off 1094 1094 0 0.00 0 3102 13 0 0
t$perf-norm:sp_client_order 22060 22060 0 0.00 0 9743 19 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 944 5 0 0
t$perf-norm:sp_pay_from_customer 7661 7661 0 0.00 0 7802 15 0 0
t$perf-norm:sp_pay_to_supplier 6333 6333 0 0.00 0 8331 12 0 0
t$perf-norm:sp_reserve_write_off 10794 10794 0 0.00 0 6476 12 0 0
t$perf-norm:sp_supplier_invoice 5872 5872 0 0.00 0 5910 21 0 0
t$perf-norm:sp_supplier_order 5896 5896 0 0.00 0 8004 21 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 314 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 446 5 0 0
t$perf-norm:srv_make_invnt_saldo 634 634 0 0.00 0 2074 23 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 3985 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10956 10636 320 2.92 0 5124 19 0 320
v_all_customers 40228 40228 0 0.00 0 25 1 0 0
v_all_suppliers 32520 32520 0 0.00 0 24 1 0 0
v_all_wares 44120 44120 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 880 880 0 0.00 0 1989 8 0 0
v_cancel_client_order 3862 3862 0 0.00 0 1911 7 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 5022 8 0 0
v_cancel_customer_reserve 1482 1482 0 0.00 0 5138 9 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 1179 6 0 0
v_cancel_supplier_invoice 836 810 26 3.11 0 2287 16 0 26
v_cancel_supplier_order 826 826 0 0.00 0 2236 10 0 0
v_cancel_write_off 2188 2188 0 0.00 0 2482 14 0 0
v_max_id_clo_ord 5896 5896 0 0.00 0 233 1 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 1713 10 0 0
v_max_id_ord_sup 5856 5856 0 0.00 0 6036 6 0 0
v_max_non_paid_invoice 1825 1825 0 0.00 0 2959 4 0 0
v_max_non_paid_realizn 4189 4189 0 0.00 0 5297 5 0 0
v_min_id_clo_ord 5896 5896 0 0.00 0 3071 6 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 1290 4 0 0
v_min_id_ord_sup 5856 5856 0 0.00 0 5875 9 0 0
v_min_non_paid_invoice 6333 6333 0 0.00 0 18366 18 0 0
v_min_non_paid_realizn 7661 7661 0 0.00 0 2977 14 0 0
v_our_firm 10836 10836 0 0.00 0 13 1 0 0
v_reserve_write_off 21588 21588 0 0.00 0 5438 8 0 0
x_lock_depdocs_on_canc_invoice 11420 11420 0 0.00 0 12083 111 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 13962 410 0 0
x_make_qstorno_1000_1200 5896 5896 0 0.00 1 29697 1105 0 0
x_make_qstorno_1200_2000 5872 5872 0 0.00 3 96659 3361 0 0
x_make_qstorno_2100_3300 485952 485952 0 0.00 0 41411 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-01-2021 01:28:36 to 18-01-2021 01:28:40.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 15305 8192000000 10258263296 10563330048 899723600 9.896 71 53 109 0 919603216 2347392 17532224
22:57:45 29587 8192000000 10330486528 10645557248 1383721728 14.450 100 89 178 0 1416792592 4492912 28577952
22:58:26 24238 8192000000 10367368656 10687438848 1415903184 14.736 100 87 174 1 1450540320 6099120 28538016
22:58:58 469 8192000000 10372767472 10696065024 1433539152 14.893 100 87 174 0 1468682480 6773072 28370256
22:59:24 24113 8192000000 10411809056 10739314688 1462468272 15.148 100 93 186 0 1500862672 7584704 30809696
23:00:01 22595 8192000000 10428406672 10756333568 1481788224 15.317 100 93 186 0 1520212896 8026176 30398496
23:00:32 13017 8192000000 10427225792 10759495680 1485966288 15.354 100 89 178 0 1523218160 8428032 28823840
23:00:58 22761 8192000000 10447957936 10783621120 1502379984 15.497 100 89 178 3 1539490912 8673472 28437456
23:01:32 15562 8192000000 10456583792 10803032064 1515049552 15.607 100 80 160 0 1549404160 9251504 25103104
23:01:59 13149 8192000000 10487734224 10839089152 1546249904 15.878 100 71 142 0 1576953984 9256032 21448048
23:02:21 10545 8192000000 10529558688 10877849600 1588870560 16.244 100 85 170 0 1624250624 9912240 25467824
23:02:40 17074 8192000000 10559138304 10918182912 1613968336 16.459 100 84 168 1 1650407456 11103424 25335696
23:03:05 9920 8192000000 10582604512 10943000576 1645779440 16.729 100 86 173 1 1682963920 11805856 25378624
23:03:22 7661 8192000000 10599822560 10963271680 1652701264 16.787 100 80 157 1 1687715040 12062464 22951312
23:03:39 9729 8192000000 10629637472 10994532352 1681400608 17.029 100 83 166 0 1718053440 12300304 24352528
23:03:58 8851 8192000000 10644333696 11017269248 1706046368 17.236 100 81 162 1 1741997200 12402432 23548400
23:04:13 9860 8192000000 10660858112 11031240704 1716635232 17.324 100 74 148 0 1750490608 12734912 21120464
23:04:33 4480 8192000000 10672219696 11049684992 1733197424 17.462 100 79 157 3 1768915728 13184576 22533728
23:04:44 5254 8192000000 10682966192 11060748288 1745804416 17.567 100 77 154 1 1781015056 13231232 21979408
23:04:56 7214 8192000000 10702515328 11075907584 1755999792 17.651 100 86 172 0 1793803600 13798432 24005376
23:05:10 4395 8192000000 10703048448 11076374528 1761604896 17.698 100 86 173 1 1800495232 14843344 24046992
23:05:21 4356 8192000000 10698528336 11079020544 1765955328 17.734 100 83 166 0 1803749776 14548144 23246304
23:05:32 5213 8192000000 10718546320 11099435008 1775620752 17.813 100 81 156 1 1810368832 12798672 21949408
23:05:44 3445 8192000000 10720132256 11104399360 1783957552 17.882 100 83 163 3 1819155536 12747792 22450192
23:05:55 3445 8192000000 10733066320 11112583168 1789355376 17.926 100 83 164 2 1825727104 13235712 23136016
23:06:05 2678 8192000000 10736259760 11119493120 1799096688 18.006 100 89 178 1 1837978816 13653312 25228816
23:06:14 3881 8192000000 10738754832 11124027392 1800831360 18.021 100 84 168 3 1838345872 14460560 23053952
23:06:24 5912 8192000000 10745063056 11130359808 1804294688 18.049 100 76 152 1 1840344928 14580880 21469360
23:06:37 4469 8192000000 10764618512 11146194944 1811810672 18.111 100 89 178 3 1851085216 14996400 24278144
23:06:48 2364 8192000000 10770518976 11156606976 1826558912 18.231 100 92 183 2 1866687664 14840736 25288016
23:06:57 1593 8192000000 10777241136 11161763840 1830392976 18.263 100 87 174 0 1868712304 13815664 24503664
23:07:05 2140 8192000000 10782992880 11167625216 1837846624 18.323 100 92 181 3 1877296000 13616176 25833200
23:07:13 1735 8192000000 10786245664 11169386496 1840276112 18.343 100 93 185 1 1881627200 14411536 26939552
23:07:22 1524 8192000000 10793427872 11181064192 1847653632 18.403 100 94 188 3 1886951344 12207392 27090320
23:07:30 1188 8192000000 10800992160 11186176000 1853264464 18.449 100 92 183 2 1892194064 12665136 26264464
23:07:37 1085 8192000000 10801802272 11189657600 1859028752 18.495 100 93 188 2 1899061504 13505440 26527312
23:07:45 1095 8192000000 10811579904 11198414848 1862187376 18.521 100 92 184 1 1902167696 13665440 26314880
23:07:53 1984 8192000000 10815592048 11202727936 1865234576 18.546 100 90 181 0 1903440800 12894880 25311344
23:08:01 4640 8192000000 10804508160 11198042112 1864766752 18.542 100 82 162 1 1900867392 12393248 23707392
23:08:12 1254 8192000000 10811434576 11201134592 1867625680 18.565 100 88 177 0 1904712800 12908384 24178736
23:08:20 16725 8192000000 10796031248 11202371584 1868483264 18.572 100 65 130 1 1898726992 11951984 18291744
23:08:43 4534 8192000000 10785114496 11203493888 1865719440 18.550 100 47 94 0 1888210160 8964208 13526512
23:08:54 4443 8192000000 10791944624 11206422528 1874738048 18.623 100 65 131 0 1901549088 8535632 18275408
23:09:05 4821 8192000000 10785665088 11205373952 1870769568 18.591 100 37 74 0 1890082272 8844592 10468112
23:09:19 6116 8192000000 10778594576 11203997696 1870179168 18.586 100 28 56 1 1886121104 7959776 7982160
23:09:31 7690 8192000000 10780878464 11206557696 1871221632 18.594 100 28 56 2 1890607920 11834352 7551936
23:09:45 3566 8192000000 10784979872 11211927552 1874174512 18.618 100 31 60 2 1893150672 10771552 8204608
23:09:55 10497 8192000000 10780572288 11211689984 1873722608 18.614 100 18 36 3 1884259168 5494096 5042464
23:10:12 10887 8192000000 10786628848 11216867328 1878947248 18.657 100 18 35 2 1889498224 5119856 5431120
23:10:32 5562 8192000000 10783160176 11215990784 1884765776 18.704 100 25 50 3 1898582208 6968080 6848352
23:10:47 7013 8192000000 10791193696 11225497600 1881480880 18.677 100 20 41 0 1894331168 7432032 5418256
23:11:02 13693 8192000000 10801598480 11227222016 1884352512 18.700 100 18 36 2 1896402608 6154832 5895264
23:11:23 18585 8192000000 10798717056 11228876800 1888253856 18.732 100 23 46 0 1901055728 6056576 6745296
23:11:48 71830 8192000000 10799408240 11241242624 1897528624 18.806 100 40 79 1 1919166720 10441088 11197008
23:13:06 5081 8192000000 10824132032 11254964224 1899175392 18.820 100 33 62 2 1914656816 6381040 9100384
23:13:18 6394 8192000000 10804690896 11243872256 1896171504 18.795 100 21 42 0 1908560160 6439344 5949312
23:13:31 6919 8192000000 10825047888 11252379648 1902465744 18.846 100 26 52 0 1915721008 6265808 6989456
23:13:45 5166 8192000000 10822943408 11261190144 1903834896 18.857 100 26 52 0 1922212912 11196288 7181728
23:13:57 7141 8192000000 10827382864 11266355200 1909799600 18.905 100 18 36 2 1921339872 6349248 5191024
23:14:10 6097 8192000000 10838769312 11270574080 1912012880 18.923 100 28 56 1 1930287920 10472816 7802224
23:14:23 9096 8192000000 10832986896 11268288512 1911298176 18.917 100 21 43 1 1923238032 5646848 6293008
23:14:41 8081 8192000000 10817545920 11264667648 1914495136 18.943 100 24 48 0 1928044752 6284480 7265136
23:14:58 7310 8192000000 10830419456 11269152768 1915298912 18.949 100 20 40 0 1926742048 5979264 5463872
23:15:15 5498 8192000000 10832842672 11271499776 1918001184 18.971 100 25 50 1 1931880032 6392336 7486512
23:15:28 8516 8192000000 10820702032 11254587392 1883954128 18.697 98 18 36 3 1893981296 4811552 5215616
23:15:45 10411 8192000000 10809046992 11248123904 1874203856 18.618 98 16 32 1 1883622976 5094832 4324288
23:16:03 12358 8192000000 10831064032 11263004672 1911143952 18.916 100 32 64 2 1926964544 6121200 9699392
23:16:24 73933 8192000000 10717455632 11145113600 1744405616 17.555 91 42 79 3 1765909744 9481424 12022704
23:17:47 7608 8192000000 10729490464 11153690624 1799162880 18.007 97 23 47 2 1811732848 6049824 6520144
23:18:01 5844 8192000000 10762653808 11185315840 1833178544 18.285 99 29 59 2 1848252720 7225280 7848896
23:18:14 6739 8192000000 10757216752 11178680320 1807264560 18.073 98 29 58 2 1820762624 5556672 7941392
23:18:31 7087 8192000000 10708215936 11123630080 1714799104 17.309 94 28 55 2 1727903440 5791504 7312832
23:18:47 8345 8192000000 10724411904 11139366912 1789191440 17.925 99 34 69 0 1804613632 5448048 9974144
23:19:04 9396 8192000000 10689692848 11095724032 1707035440 17.244 95 22 43 2 1722389184 9094096 6259648
23:19:24 7761 8192000000 10675236272 11087646720 1728300448 17.421 98 25 49 0 1741604256 6037504 7266304
23:19:41 8499 8192000000 10688903360 11107614720 1729319504 17.430 97 20 40 2 1740466736 5366224 5781008
23:19:59 10510 8192000000 10711687072 11120459776 1771520544 17.780 99 23 45 2 1788623920 9968960 7134416
23:20:16 7704 8192000000 10715214256 11121868800 1761466176 17.697 98 21 42 1 1772912944 5355680 6091088
23:20:30 11318 8192000000 10687732000 11103563776 1730668304 17.441 96 26 52 1 1743647104 5039424 7939376
23:20:48 8262 8192000000 10702266448 11117862912 1760575728 17.689 98 21 42 0 1772395120 5470624 6348768
23:21:04 62773 8192000000 10711294800 11139354624 1753002240 17.626 97 23 46 1 1765029104 5542320 6484544
23:22:18 19235 8192000000 10722122720 11150737408 1813816272 18.127 100 16 31 1 1823369216 5575872 3977072
23:22:43 8659 8192000000 10744729328 11164164096 1808850816 18.086 99 39 78 2 1835354016 15383488 11119712
23:22:58 7700 8192000000 10751926848 11175653376 1836300848 18.311 100 34 67 1 1851193440 6139936 8752656
23:23:14 9340 8192000000 10759041040 11186307072 1848048272 18.406 100 26 52 0 1861961216 6133136 7779808
23:23:29 3899 8192000000 10745668576 11177721856 1840984288 18.349 100 18 36 1 1852173968 5642592 5547088
23:23:42 7872 8192000000 10764890000 11190681600 1850269440 18.424 100 24 48 4 1863408240 6752560 6386240
23:23:57 6773 8192000000 10753705616 11191545856 1850201728 18.424 100 16 32 1 1860704464 5506032 4996704
23:24:10 4855 8192000000 10774818672 11204354048 1859197456 18.497 100 28 56 1 1872500016 4491824 8810736
23:24:22 8868 8192000000 10774705824 11206062080 1861415632 18.515 100 24 49 2 1874240768 6168752 6656384
23:24:39 8174 8192000000 10775171248 11204780032 1865018512 18.544 100 28 56 2 1879479360 5421920 9038928
23:25:02 7055 8192000000 10800022048 11222831104 1875527632 18.629 100 31 62 3 1890872736 6254864 9090240
23:25:17 11251 8192000000 10797216400 11226722304 1872519952 18.605 100 16 32 0 1886965872 10185440 4260480
23:25:40 9497 8192000000 10781340624 11216850944 1874649360 18.622 100 19 37 1 1885226304 5189152 5387792
23:25:56 11663 8192000000 10783534272 11221966848 1876033008 18.633 100 15 30 0 1886185472 5639792 4512672
23:26:14 74737 8192000000 10840577840 11253358592 1888050608 18.730 100 43 85 0 1905875952 6313648 11511696
23:27:35 3995 8192000000 10854576688 11267207168 1914275872 18.941 100 64 130 0 1941104160 8582464 18245824
23:27:48 14820 8192000000 10853121552 11272118272 1915640096 18.952 100 52 103 1 1944542816 13949808 14952912
23:28:14 14027 8192000000 10854645280 11280543744 1923537568 19.015 100 46 92 5 1945575056 8927520 13109968
23:28:34 18733 8192000000 10855850576 11284250624 1930871360 19.074 100 45 89 1 1952558576 9213232 12473984
23:29:10 18539 8192000000 10875115968 11301588992 1941190768 19.156 100 45 90 1 1962769904 8667888 12911248
23:29:37 15506 8192000000 10880247712 11308318720 1948771504 19.217 100 57 114 2 1975709968 10293792 16644672
23:30:01 15926 8192000000 10894146912 11320315904 1954536944 19.263 100 47 94 2 1980414384 12604208 13273232
23:30:25 19076 8192000000 10901679648 11327557632 1961144976 19.315 100 56 113 2 1991439984 14162768 16132240
23:30:59 24847 8192000000 10895581280 11331747840 1963667040 19.335 100 43 85 1 1991564496 15653104 12244352
23:31:31 34072 8192000000 10909364736 11343376384 1973198736 19.411 100 46 92 1 2003744960 17040624 13505600
23:32:30 7276 8192000000 10920738864 11348709376 1983190576 19.490 100 52 100 0 2012948000 15493056 14264368
23:32:45 4121 8192000000 10940794432 11359354880 1988485776 19.532 100 70 135 1 2024518288 16938944 19093568
23:32:56 3895 8192000000 10932784992 11361984512 1987554512 19.524 100 55 108 0 2021727440 18565168 15607760
23:33:10 15829 8192000000 10933173024 11367239680 1991353344 19.554 100 55 109 3 2025316800 18448048 15515408
23:33:33 6138 8192000000 10922873792 11346812928 1974833184 19.424 99 54 105 2 2007092192 16654864 15604144
23:33:47 23131 8192000000 10939338656 11367305216 1997004000 19.599 100 62 124 1 2033895312 19032192 17859120
23:34:18 18433 8192000000 10943582464 11376705536 2001204496 19.632 100 53 106 2 2036036000 18609920 16221584
23:34:52 12919 8192000000 10947513872 11380150272 2005478496 19.666 100 51 100 0 2038842240 17910464 15453280
23:35:15 12488 8192000000 10947130384 11386716160 2007339184 19.681 100 44 88 0 2040676368 20296800 13040384
23:35:35 8063 8192000000 10965651552 11394334720 2014479536 19.737 100 64 128 1 2054952976 21481888 18991552
23:35:55 10545 8192000000 10971070960 11406553088 2015204832 19.742 100 49 98 0 2058794528 28995824 14593872
23:36:16 8004 8192000000 10978631696 11415339008 2022202896 19.797 100 51 98 0 2066997088 29476736 15317456
23:36:34 6033 8192000000 10968751840 11405541376 2022518288 19.800 100 48 96 1 2060699136 23679456 14501392
23:36:49 7437 8192000000 10967855392 11401756672 2017860496 19.763 100 54 109 2 2058340432 24638032 15841904
23:37:07 2798 8192000000 10983697168 11402579968 2019236256 19.774 100 78 156 1 2068983936 25638480 24109200
23:37:17 4773 8192000000 10969756448 11398402048 2009053344 19.694 100 62 123 2 2053541376 26586368 17901664
23:37:29 3034 8192000000 10982637296 11400298496 2016325152 19.751 100 79 155 0 2067907344 27587664 23994528
23:37:41 3584 8192000000 10960161216 11381907456 1996033056 19.591 99 75 152 1 2047670256 29007280 22629920
23:37:52 7337 8192000000 10950187792 11367100416 1983243936 19.490 99 67 133 4 2033869488 30615824 20009728
23:38:06 4438 8192000000 10961593984 11386834944 2004052288 19.655 100 67 134 1 2055624272 31072816 20499168
23:38:19 3343 8192000000 10986120320 11404902400 2011791120 19.716 100 70 140 2 2064888080 30956480 22140480
23:38:29 3451 8192000000 10971763632 11400130560 2010083728 19.702 100 64 128 1 2060885312 30682752 20118832
23:38:48 3365 8192000000 10974977168 11407872000 2018205296 19.766 100 68 137 0 2071746688 32548144 20993248
23:38:58 2991 8192000000 10965205744 11391377408 2006441872 19.674 100 62 124 0 2055112352 28936336 19734144
23:39:09 4964 8192000000 10963438064 11394600960 2009854800 19.700 100 62 125 1 2059156080 29596192 19705088
23:39:25 4367 8192000000 10979267536 11404009472 2012558400 19.722 100 60 121 1 2061851184 30745584 18547200
23:39:37 7492 8192000000 10971154224 11400204288 1994938560 19.583 99 60 120 0 2044950768 31755968 18256240
23:39:55 5860 8192000000 10962550352 11390558208 1973927856 19.417 98 56 112 0 2024192624 32868240 17396528
23:40:09 3414 8192000000 10972099584 11395313664 2003542992 19.651 100 75 150 3 2057705360 31273392 22888976
23:40:19 3393 8192000000 10989070560 11403493376 2010129344 19.703 100 82 164 2 2071672496 37417984 24125168
23:40:29 1431 8192000000 10979469792 11391037440 1997361440 19.602 100 83 166 1 2057742352 35077888 25303024
23:40:37 2304 8192000000 10956991952 11365486592 1949891648 19.226 98 84 165 0 2010598400 35898304 24808448
23:40:46 2642 8192000000 10957024928 11369197568 1977274544 19.443 100 89 178 1 2041412288 36891440 27246304
23:40:59 1520 8192000000 10950464352 11370074112 1966279296 19.356 99 86 172 0 2030731392 37555088 26897008
23:41:08 3079 8192000000 10949088256 11369472000 1960827360 19.313 99 77 155 3 2022571184 37894448 23849376
23:41:19 2854 8192000000 10944732352 11360661504 1967282528 19.364 100 69 138 0 2028507984 38888976 22336480
23:41:32 3071 8192000000 10947788896 11365183488 1971428064 19.397 100 76 152 0 2035333328 38825904 25079360
23:41:45 6132 8192000000 10951366672 11367518208 1969914144 19.385 100 76 153 1 2031477424 37613632 23949648
23:42:00 1494 8192000000 10971645712 11378466816 1986650288 19.517 100 89 178 0 2052138944 37490560 27998096
23:42:09 4414 8192000000 10963446288 11378868224 1975864992 19.432 100 72 144 1 2040659664 42703248 22091424
23:42:21 4231 8192000000 10942440032 11359997952 1967582336 19.366 100 73 141 4 2028873008 38828048 22462624
23:42:33 2289 8192000000 10936756064 11356262400 1948827872 19.217 99 75 145 1 2011296912 39615392 22853648
23:42:48 4536 8192000000 10921564160 11337154560 1940589280 19.151 100 71 142 0 2004827888 41572160 22666448
23:43:00 2323 8192000000 10937155888 11340750848 1947510576 19.207 100 83 163 1 2011803440 39888752 24404112
23:43:12 2156 8192000000 10930225328 11334000640 1947493408 19.207 100 84 168 1 2009542544 36558800 25490336
23:43:22 1585 8192000000 10916064032 11321733120 1929420448 19.062 99 83 166 1 1993717328 38785888 25510992
23:43:31 7104 8192000000 10898459728 11307790336 1902291296 18.845 98 73 146 2 1964451360 38263600 23896464
23:43:48 5718 8192000000 10908911008 11314995200 1919498480 18.983 99 83 167 1 1986411280 40152944 26759856
23:44:07 2245 8192000000 10903968272 11307302912 1912206832 18.924 99 82 162 2 1979939984 42195632 25537520
23:44:17 2442 8192000000 10916155120 11323170816 1930309856 19.069 100 79 155 2 1997180480 42051664 24818960
23:44:28 2392 8192000000 10931607216 11342028800 1949387984 19.222 100 89 175 1 2015803888 39569456 26846448
23:44:37 2012 8192000000 10933240496 11340742656 1947877552 19.210 100 89 174 0 2015873472 40358560 27637360
23:44:51 3489 8192000000 10899184000 11318296576 1911880832 18.922 98 59 118 0 1967940096 37628256 18431008
23:45:02 4423 8192000000 10928253952 11341242368 1945562880 19.191 100 70 138 2 2006142576 38631296 21948400
23:45:15 4090 8192000000 10902882160 11304210432 1912086128 18.923 99 84 167 0 1980011712 39767168 28158416
23:45:26 3600 8192000000 10901547536 11302092800 1911791984 18.921 100 83 166 2 1976630800 39297456 25541360
23:45:37 2743 8192000000 10906459344 11315499008 1923918160 19.018 100 80 160 2 1990599488 41734464 24946864
23:45:50 4100 8192000000 10916049488 11335442432 1939787968 19.145 100 67 134 3 2000627424 39938608 20900848
23:46:00 1263 8192000000 10914610752 11333152768 1940988736 19.155 100 62 120 1 1997849248 37164400 19696112
23:46:11 4537 8192000000 10885366064 11319279616 1931107328 19.076 100 37 74 0 1974443680 31480160 11856192
23:46:29 12098 8192000000 10878483200 11306774528 1906423696 18.878 99 52 102 0 1955559504 32650400 16485408
23:46:54 11131 8192000000 10882922752 11312185344 1922747424 19.009 100 32 62 1 1969098288 35059152 11291712
23:47:11 9582 8192000000 10895080416 11323678720 1931714384 19.081 100 42 84 2 1982381392 37012944 13654064
23:47:30 7446 8192000000 10895609536 11323379712 1911133888 18.916 99 43 86 1 1971485792 45667184 14684720
23:47:53 24164 8192000000 10898893824 11330863104 1916867968 18.962 100 36 71 4 1978995648 49669824 12457856
23:48:32 12702 8192000000 10893068736 11334512640 1929144512 19.060 100 39 78 1 1987261504 44140240 13976752
23:48:53 14839 8192000000 10883432880 11314896896 1889035552 18.738 98 40 80 3 1943287968 40133056 14119360
23:49:17 17227 8192000000 10874863184 11316338688 1899349632 18.821 99 31 62 4 1956115744 45233840 11532272
23:49:41 8105 8192000000 10892219680 11327664128 1912236496 18.925 100 37 74 1 1974106304 48391152 13478656
23:49:57 4510 8192000000 10897458720 11337560064 1919886240 18.986 100 29 58 1 1978681232 47533408 11261584
23:50:12 8417 8192000000 10889951264 11333074944 1924327424 19.021 100 33 66 1 1972939440 36742880 11869136
23:50:31 27324 8192000000 10868551008 11323830272 1909723856 18.904 99 29 58 1 1959647136 39814576 10108704
23:51:05 8790 8192000000 10872680240 11316338688 1925915280 19.034 100 36 72 3 1962258320 25489488 10853552
23:51:21 26742 8192000000 10861139152 11332571136 1926956096 19.043 100 15 30 1 1955204128 23420608 4827424
23:51:54 38826 8192000000 10848081552 11309494272 1887251696 18.724 98 9 18 0 1903381584 13391056 2738832
23:52:39 76994 8192000000 10852056816 11311046656 1879984000 18.665 98 4 8 0 1897772512 17106560 681952
23:54:29 47078 8192000000 10872590208 11314712576 1909908064 18.906 99 31 62 1 1934349952 15137776 9304112
23:55:39 6834 8192000000 10878439872 11323506688 1933348256 19.094 100 51 102 1 1964814656 16625264 14841136
23:55:54 27298 8192000000 10863186176 11323363328 1932076608 19.083 100 31 62 0 1956556288 15691600 8788080
23:56:40 24223 8192000000 10874054880 11326500864 1913237680 18.933 99 23 47 3 1936992608 16755056 6999872
23:57:11 65031 8192000000 10875333184 11343491072 1912896608 18.930 99 9 18 1 1934762048 19409488 2455952
23:58:23 63854 8192000000 10884753248 11318030336 1878016976 18.649 96 39 78 2 1900583936 11390752 11176208
23:59:34 129852 8192000000 10900081488 11350310912 1947273584 19.205 100 36 73 3 1971466496 13951264 10241648
00:03:44 32859 8192000000 10920628080 11369050112 1979980032 19.465 100 26 52 0 1995029312 7170288 7878992
00:04:26 10635 8192000000 10919052336 11376697344 1991542704 19.556 100 27 54 0 2008812624 8467760 8802160
00:04:44 24324 8192000000 10936033808 11386089472 1999506816 19.619 100 46 91 2 2023299952 10385712 13407424
00:05:15 15372 8192000000 10934707824 11392090112 2004237920 19.656 100 56 112 0 2033277168 11570144 17469104
00:05:49 24223 8192000000 10944904688 11400032256 2001931184 19.638 100 44 87 0 2030608128 15707280 12969664
00:06:20 44161 8192000000 10918946928 11402833920 1994290272 19.578 100 18 36 0 2015291312 15125040 5876000
00:07:23 37899 8192000000 10916686880 11399602176 1989813104 19.542 100 9 19 0 2004703600 11860272 3030224
00:08:11 21237 8192000000 10926569552 11395158016 2000996208 19.631 100 30 60 1 2020458912 10800944 8661760
00:08:38 84072 8192000000 10917513488 11390468096 1986480400 19.516 99 19 38 0 2002442528 10394816 5567312
00:10:09 49680 8192000000 10924844640 11395526656 1976396944 19.436 99 15 30 0 2000358864 19137552 4824368
00:11:05 27716 8192000000 10912510080 11389243392 1991663968 19.557 100 16 32 2 2009245248 12899168 4682112
00:11:44 113479 8192000000 10919589664 11398651904 1974331296 19.420 99 23 46 0 2002818704 21875456 6611952
00:13:45 40650 8192000000 10915552416 11403673600 1974759344 19.423 99 19 38 2 1996579744 16541344 5279056
00:14:33 35005 8192000000 10916517376 11390291968 1992440320 19.563 100 4 6 0 2002852176 9044976 1366880
00:15:34 73985 8192000000 10905772496 11389685760 1995194880 19.585 100 14 28 3 2008729760 8634976 4899904
00:17:15 76790 8192000000 10890983312 11376848896 1943438464 19.174 97 25 50 1 1958600624 7431712 7730448
00:18:46 66907 8192000000 10892590368 11375591424 1926203648 19.037 97 9 18 0 1938089856 9435568 2450640
00:19:59 67061 8192000000 10910760816 11384205312 1964041792 19.338 99 22 44 2 1984786416 15028832 5715792
00:22:03 24336 8192000000 10923857344 11387990016 1991015408 19.552 100 38 75 1 2010377488 9172496 10189584
00:22:34 42792 8192000000 10925911280 11402522624 1999106160 19.616 100 21 42 0 2013840960 8713984 6020816
00:23:26 58078 8192000000 10915774528 11391422464 1959250640 19.300 98 16 32 1 1975514080 11835376 4428064
00:24:34 40519 8192000000 10904118128 11368030208 1893889872 18.777 95 16 32 0 1909657840 11044512 4723456
00:25:43 101350 8192000000 10875477952 11349069824 1775376640 17.811 90 27 54 2 1795599136 12894112 7328384
00:27:40 52864 8192000000 10870945232 11354468352 1902256096 18.844 97 25 50 0 1925665888 16751472 6658320
00:28:40 43432 8192000000 10878115344 11335479296 1867766416 18.566 95 21 42 1 1880810976 7798256 5246304
00:29:34 47257 8192000000 10860894144 11320590336 1830221424 18.261 94 25 50 0 1848399280 11898304 6279552
00:30:28 57734 8192000000 10872813392 11341135872 1906030384 18.875 98 24 48 0 1931453008 18847392 6575232
00:31:35 117126 8192000000 10863122960 11327373312 1830068384 18.260 94 8 16 1 1844984576 12954896 1961296
00:33:41 138344 8192000000 10843159216 11303493632 1850280752 18.424 95 29 58 1 1869365744 10473792 8611200
00:36:10 17213 8192000000 10855438848 11316822016 1928146544 19.052 100 27 52 2 1945022768 8642544 8233680
00:36:34 46213 8192000000 10837867136 11314368512 1926324784 19.037 100 26 52 1 1941526864 8142976 7059104
00:37:28 33698 8192000000 10831004608 11304841216 1894932496 18.786 98 11 22 0 1904324864 6406192 2986176
00:38:10 38753 8192000000 10785294448 11251683328 1818981200 18.169 95 11 22 1 1829287040 7016032 3289808
00:39:16 20898 8192000000 10787541184 11253874688 1848444400 18.409 98 9 18 0 1860342816 9216560 2681856
00:39:51 48866 8192000000 10816506912 11289866240 1887128992 18.723 99 11 22 0 1898279280 8076416 3073872
00:41:00 42352 8192000000 10847694160 11316867072 1920038864 18.987 100 5 10 0 1929011504 7679696 1292944
00:41:49 38495 8192000000 10816994960 11285483520 1862603648 18.524 96 16 32 1 1874435344 6769152 5062544
00:42:34 28328 8192000000 10866587472 11316523008 1903202272 18.852 99 17 34 1 1917091824 9063104 4826448
00:43:10 48248 8192000000 10869838240 11332153344 1919460224 18.983 99 20 40 0 1941396784 16025808 5910752
00:44:06 36937 8192000000 10872682432 11335712768 1928542624 19.055 99 21 42 0 1946105904 11277648 6285632
00:44:52 67304 8192000000 10860038096 11340500992 1907033424 18.883 98 14 28 1 1922643696 11597632 4012640
00:46:08 44627 8192000000 10855380352 11321159680 1871712272 18.598 96 18 34 1 1888364224 12147760 4504192
00:47:03 43476 8192000000 10871218816 11337244672 1946716480 19.200 100 20 40 1 1963869744 11478656 5674608
00:47:52 78886 8192000000 10917183216 11374448640 1967552672 19.366 100 31 62 1 1988945392 12930128 8462592
00:49:17 27688 8192000000 10909004800 11371192320 1953944400 19.258 99 44 88 3 1983010656 16948720 12117536
00:49:56 83711 8192000000 10905020224 11377332224 1976644096 19.438 100 13 26 2 1995949696 15487056 3818544
00:51:26 70628 8192000000 10914032048 11392753664 1960970768 19.314 99 17 34 2 1989795136 23399664 5424704
00:52:44 88457 8192000000 10918606576 11396972544 1972569744 19.406 100 8 16 0 2003761936 29241120 1951072
00:54:27 31698 8192000000 10925448416 11395510272 1984659040 19.502 100 14 28 0 2002177360 13324512 4193808
00:55:13 94094 8192000000 10899881824 11368787968 1958916304 19.297 99 18 36 1 1974341792 10263168 5162320
00:57:24 67957 8192000000 10923034560 11395272704 1974160688 19.418 99 18 36 1 1990163120 11338512 4663920
00:58:38 24965 8192000000 10917376240 11387559936 1971864592 19.400 99 19 38 0 1992908368 15341984 5701792
00:59:16 81801 8192000000 10920510112 11412406272 1989298096 19.538 100 9 18 0 2009820208 18037168 2484944
01:00:57 40759 8192000000 10915650160 11412312064 1989400528 19.539 100 9 18 0 2007662704 15899072 2363104
01:01:44 22383 8192000000 10918059200 11410636800 1996976272 19.599 100 10 20 0 2016420992 16943184 2501536
01:02:15 39703 8192000000 10917483744 11392385024 1980080432 19.465 99 15 30 0 1992800064 8516608 4203024
01:03:24 45787 8192000000 10931461008 11402645504 1994079776 19.576 100 22 44 0 2007225872 6902928 6243168
01:04:16 35313 8192000000 10919258448 11388243968 1978039104 19.449 99 26 52 2 1992962240 7723680 7199456
01:04:57 29284 8192000000 10933000304 11390545920 1979868896 19.464 99 24 47 1 1993846160 7037024 6940240
01:05:34 54042 8192000000 10924761344 11394383872 1940902128 19.154 97 15 28 1 1954499920 10072544 3525248
01:06:34 42512 8192000000 10918745216 11403743232 1977644928 19.446 99 16 32 3 1994310464 12073504 4592032
01:07:23 45683 8192000000 10931034496 11387969536 1959371856 19.301 98 27 54 0 1973925920 7051840 7502224
01:08:16 58278 8192000000 10905404800 11373010944 1902845904 18.849 96 21 42 0 1921424368 12655664 5922800
01:09:30 79651 8192000000 10910498624 11382194176 1940877552 19.154 98 18 36 0 1957807072 11832736 5096784
01:10:56 51133 8192000000 10926949536 11387588608 1966249168 19.356 99 28 55 1 1984360000 10235952 7874880
01:11:54 48911 8192000000 10906316848 11385417728 1935938736 19.114 98 26 52 2 1959150816 15577488 7634592
01:12:54 46745 8192000000 10890427616 11353186304 1896545136 18.798 96 23 46 2 1917828528 14777920 6505472
01:13:52 69200 8192000000 10872528784 11339214848 1877690032 18.646 96 8 16 0 1889638928 9937408 2011488
01:15:08 113023 8192000000 10858154112 11322388480 1823449936 18.206 93 30 61 4 1845434544 13466208 8518400
01:17:11 119806 8192000000 10867773776 11336167424 1906344496 18.877 98 32 64 1 1928174304 12242320 9587488
01:19:35 39010 8192000000 10865381568 11307245568 1860298800 18.506 96 28 54 1 1878940128 10579072 8062256
01:20:34 78408 8192000000 10808865328 11281244160 1828587024 18.248 95 13 26 1 1849273280 16683840 4002416
01:21:59 37901 8192000000 10797269552 11281063936 1833656160 18.289 97 3 6 0 1846506592 12159408 691024
01:22:43 46191 8192000000 10842557408 11307499520 1885135184 18.707 99 21 41 1 1900367888 8886192 6346512
01:23:35 54141 8192000000 10818923488 11288784896 1861546672 18.516 97 14 28 0 1873746784 8259376 3940736
01:24:43 65489 8192000000 10862075888 11320389632 1901618288 18.839 99 14 28 0 1912446960 7123808 3704864
01:25:58 56388 8192000000 10838502560 11303063552 1847882848 18.405 96 18 36 2 1861564256 8031888 5649520
01:27:00 16418 8192000000 9062683088 9282248704 232845760 2.763 13 6 12 0 243664896 9089232 1729904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 160 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 18-01-2021 01:29:15 to 18-01-2021 01:29:16.

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          250884
MON$OLDEST_ACTIVE               250885
MON$OLDEST_SNAPSHOT             250885
MON$NEXT_TRANSACTION            250885
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                       2021888
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 01:29:17. 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 01:29:20 No severe PSQL-related problems occured
18.01.21 01:29:21. End of report.