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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17292484 kB
MemAvailable 31535592 kB
Buffers 0 kB
Cached 14374424 kB
SwapCached 3708 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 2020-12-11 01:27:03
DTS_END                         2020-12-11 01:27:03.8180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47792
TRN_ID                          251832
ATT_ID                          735
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: 9551.67 24286 1146201
customer order: creation 175.16 359 21019
customer order: refuse 15.46 314 1855
order to supplier: creation 47.12 1197 5654
order to supplier: removal 3.58 83836 429
invoice (draft): creation 47.18 3071 5662
invoice (draft): removal 55.38 624 6645
invoice accept: apply 42.61 17018 5113
invoice accept: cancel 49.62 763 5954
customer reserve: creation 3965.42 168 475850
customer reserve: removal 4838.16 49 580579
realization accept: apply 87.19 163 10463
realization accept: cancel 92.03 90 11043
payment from customer: creation 60.70 104 7284
payment from customer: removal 5.88 64 706
payment to supplier: creation 50.61 113 6073
payment to supplier: removal 3.37 50 404
service: total inventory turnovers 5.12 1170 614
service: total monetary turnovers 6.35 25 762
service: aggregate perf. data 0.73 22395 88
service: refresh index statistics 0.03 354145 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-12-2020 01:28:04 to 11-12-2020 01:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8327
TEST_TIME 2 7203
TEST_TIME 3 5914
TEST_TIME 4 5513
TEST_TIME 5 5520
TEST_TIME 6 5943
TEST_TIME 7 5921
TEST_TIME 8 5920
TEST_TIME 9 7160
TEST_TIME 10 7140
TEST_TIME 11 7707
TEST_TIME 12 7787
TEST_TIME 13 8233
TEST_TIME 14 8401
TEST_TIME 15 9325
TEST_TIME 16 9985
TEST_TIME 17 9814
TEST_TIME 18 10275
TEST_TIME 19 10447
TEST_TIME 20 10526
TEST_TIME 21 10574
TEST_TIME 22 11332
TEST_TIME 23 11485
TEST_TIME 24 11986
TEST_TIME 25 11882
TEST_TIME 26 11612
TEST_TIME 27 11680
TEST_TIME 28 11439
TEST_TIME 29 11314
TEST_TIME 30 11061
TEST_TIME 31 11001
TEST_TIME 32 10933
TEST_TIME 33 10758
TEST_TIME 34 10609
TEST_TIME 35 10427
TEST_TIME 36 10377
TEST_TIME 37 10420
TEST_TIME 38 10468
TEST_TIME 39 10463
TEST_TIME 40 10390
TEST_TIME 41 10263
TEST_TIME 42 10277
TEST_TIME 43 10234
TEST_TIME 44 10445
TEST_TIME 45 10426
TEST_TIME 46 10423
TEST_TIME 47 10399
TEST_TIME 48 10457
TEST_TIME 49 10422
TEST_TIME 50 10429
TEST_TIME 51 10334
TEST_TIME 52 10165
TEST_TIME 53 10131
TEST_TIME 54 10099
TEST_TIME 55 10089
TEST_TIME 56 10085
TEST_TIME 57 10024
TEST_TIME 58 9921
TEST_TIME 59 9839
TEST_TIME 60 9913
TEST_TIME 61 9877
TEST_TIME 62 9987
TEST_TIME 63 9958
TEST_TIME 64 9914
TEST_TIME 65 9996
TEST_TIME 66 10016
TEST_TIME 67 10046
TEST_TIME 68 10026
TEST_TIME 69 9998
TEST_TIME 70 9981
TEST_TIME 71 10116
TEST_TIME 72 10056
TEST_TIME 73 10167
TEST_TIME 74 10237
TEST_TIME 75 10183
TEST_TIME 76 10063
TEST_TIME 77 10074
TEST_TIME 78 10017
TEST_TIME 79 10002
TEST_TIME 80 9995
TEST_TIME 81 9921
TEST_TIME 82 9867
TEST_TIME 83 9844
TEST_TIME 84 9832
TEST_TIME 85 9830
TEST_TIME 86 9838
TEST_TIME 87 9761
TEST_TIME 88 9737
TEST_TIME 89 9758
TEST_TIME 90 9753
TEST_TIME 91 9785
TEST_TIME 92 9763
TEST_TIME 93 9723
TEST_TIME 94 9890
TEST_TIME 95 9862
TEST_TIME 96 9859
TEST_TIME 97 9873
TEST_TIME 98 9923
TEST_TIME 99 9909
TEST_TIME 100 9942
TEST_TIME 101 9972
TEST_TIME 102 9976
TEST_TIME 103 9966
TEST_TIME 104 9881
TEST_TIME 105 9842
TEST_TIME 106 9821
TEST_TIME 107 9807
TEST_TIME 108 9771
TEST_TIME 109 9748
TEST_TIME 110 9720
TEST_TIME 111 9664
TEST_TIME 112 9634
TEST_TIME 113 9628
TEST_TIME 114 9581
TEST_TIME 115 9603
TEST_TIME 116 9576
TEST_TIME 117 9558
TEST_TIME 118 9605
TEST_TIME 119 9628
TEST_TIME 120 9555

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-12-2020 01:28:08 to 11-12-2020 01:28:11.

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 1587159 1587159 0 0.00 0 21785 6 0 0
doc_list_biud 1587159 1587159 0 0.00 0 54134 23 0 0
sp_add_invoice_to_stock 5241 5113 128 2.44 17 178185 17018 0 128
sp_cancel_adding_invoice 5954 5954 0 0.00 5 62886 764 0 0
sp_cancel_client_order 1855 1855 0 0.00 4 10409 315 0 0
sp_cancel_customer_reserve 580579 580579 0 0.00 1 61383 50 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 2 2302 65 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 2 3098 50 0 0
sp_cancel_supplier_invoice 6655 6645 10 0.15 2 23966 624 0 10
sp_cancel_supplier_order 429 429 0 0.00 6 898227 83837 0 0
sp_cancel_write_off 11043 11043 0 0.00 1 8422 91 0 0
sp_client_order 21019 21019 0 0.00 3 50778 359 0 0
sp_customer_reserve 475850 475850 0 0.00 0 39941 169 0 0
sp_fill_shopping_cart 32330 32330 0 0.00 1 13512 38 0 0
sp_fill_shopping_cart_clo_res 475844 475844 0 0.00 0 16373 13 0 0
sp_get_clo_for_invoice 5106 5106 0 0.00 0 24393 268 0 0
sp_kill_cost_storno 18107 18107 0 0.00 0 6220 40 0 0
sp_kill_qstorno_ret_qs2qd 1179275 1179275 0 0.00 0 54132 27 0 0
sp_kill_qty_storno 622074 622074 0 0.00 0 54134 59 0 0
sp_lock_selected_doc 21591 21591 0 0.00 0 6648 4 0 0
sp_make_cost_storno 28926 28926 0 0.00 0 14076 44 0 0
sp_multiply_rows_for_pdistr 28926 28926 0 0.00 0 12101 28 0 0
sp_multiply_rows_for_qdistr 21019 21019 0 0.00 0 50769 157 0 0
sp_pay_from_customer 7284 7284 0 0.00 4 10460 104 0 0
sp_pay_to_supplier 6073 6073 0 0.00 4 14143 114 0 0
sp_payment_common 13357 13357 0 0.00 1 10737 26 0 0
sp_qd_handle_on_cancel_clo 1855 1855 0 0.00 0 10401 284 0 0
sp_qd_handle_on_invoice_upd_sts 11060 11060 0 0.00 0 27942 313 0 0
sp_qd_handle_on_reserve_upd_sts 10463 10463 0 0.00 0 22159 57 0 0
sp_reserve_write_off 10463 10463 0 0.00 6 22203 163 0 0
sp_supplier_invoice 5662 5662 0 0.00 6 85264 3072 0 0
sp_supplier_order 5654 5654 0 0.00 5 61869 1198 0 0
srv_aggregate_perf_data 88 88 0 0.00 3280 211629 22396 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 988 134963 33861 0 0
srv_find_qd_qs_mism 1097387 1097387 0 0.00 0 21779 5 0 0
srv_make_invnt_saldo 614 614 0 0.00 24 112373 1170 0 0
srv_make_money_saldo 762 762 0 0.00 1 2184 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 160529 535547 354146 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 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 5114 5114 0 0.00 0 19689 156 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 1 5981 115 0 0
t$perf-norm:sp_cancel_client_order 1855 1855 0 0.00 0 3210 15 0 0
t$perf-norm:sp_cancel_customer_reserve 737 737 0 0.00 0 1116 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 8288 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 2790 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 3140 24 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 27943 1494 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 4720 8 0 0
t$perf-norm:sp_client_order 21019 21019 0 0.00 0 10148 15 0 0
t$perf-norm:sp_customer_reserve 1010 1010 0 0.00 0 4222 10 0 0
t$perf-norm:sp_pay_from_customer 7284 7284 0 0.00 0 9053 11 0 0
t$perf-norm:sp_pay_to_supplier 6073 6073 0 0.00 0 10641 10 0 0
t$perf-norm:sp_reserve_write_off 10463 10463 0 0.00 0 7355 10 0 0
t$perf-norm:sp_supplier_invoice 5662 5662 0 0.00 0 8064 16 0 0
t$perf-norm:sp_supplier_order 5654 5654 0 0.00 0 8347 20 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 601 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 1875 24 0 0
t$perf-norm:srv_make_invnt_saldo 614 614 0 0.00 0 956 16 0 0
t$perf-norm:srv_make_money_saldo 762 762 0 0.00 0 864 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10468 10212 256 2.44 0 10434 18 0 256
v_all_customers 37518 37518 0 0.00 0 19 1 0 0
v_all_suppliers 31404 31404 0 0.00 0 21 1 0 0
v_all_wares 42038 42038 0 0.00 0 131 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 2384 9 0 0
v_cancel_client_order 3710 3710 0 0.00 0 4028 8 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 2264 8 0 0
v_cancel_customer_reserve 1474 1474 0 0.00 0 1942 4 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 689 3 0 0
v_cancel_supplier_invoice 840 820 20 2.38 0 2128 16 0 20
v_cancel_supplier_order 858 858 0 0.00 0 656 3 0 0
v_cancel_write_off 2140 2140 0 0.00 0 4611 17 0 0
v_max_id_clo_ord 5652 5652 0 0.00 0 763 2 0 0
v_max_id_clo_res 1010 1010 0 0.00 0 4237 13 0 0
v_max_id_ord_sup 5659 5659 0 0.00 0 3892 4 0 0
v_max_non_paid_invoice 1682 1682 0 0.00 0 660 3 0 0
v_max_non_paid_realizn 4184 4184 0 0.00 0 3227 4 0 0
v_min_id_clo_ord 5652 5652 0 0.00 0 8150 13 0 0
v_min_id_clo_res 1010 1010 0 0.00 0 6230 22 0 0
v_min_id_ord_sup 5659 5659 0 0.00 0 5160 7 0 0
v_min_non_paid_invoice 6073 6073 0 0.00 0 10722 17 0 0
v_min_non_paid_realizn 7284 7284 0 0.00 0 6421 15 0 0
v_our_firm 10720 10720 0 0.00 0 15 1 0 0
v_reserve_write_off 20926 20926 0 0.00 0 12750 7 0 0
x_lock_depdocs_on_canc_invoice 12189 12189 0 0.00 0 10874 98 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 5522 270 0 0
x_make_qstorno_1000_1200 5654 5654 0 0.00 1 61860 1115 0 0
x_make_qstorno_1200_2000 5662 5662 0 0.00 3 85232 2944 0 0
x_make_qstorno_2100_3300 475850 475850 0 0.00 0 38784 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-12-2020 01:28:12 to 11-12-2020 01:28:16.

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:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 19368 8192000000 10245879968 10552041472 992868176 10.809 77 59 118 0 1015530736 2792448 19870112
22:57:41 21075 8192000000 10336030176 10652155904 1383606432 14.449 100 86 172 0 1416223472 4529216 28087824
22:58:13 26022 8192000000 10375721712 10694991872 1423703600 14.806 100 88 176 0 1458795184 6064272 29027312
22:58:50 16314 8192000000 10405223152 10729316352 1459126800 15.118 100 85 170 0 1493111872 6725776 27259296
22:59:17 17812 8192000000 10420984512 10747314176 1476663952 15.272 100 87 174 0 1512530256 7854272 28012032
22:59:44 27626 8192000000 10428269312 10763472896 1491402384 15.401 100 81 162 0 1525560368 8386656 25771328
23:00:23 15755 8192000000 10459444432 10797514752 1514552704 15.603 100 82 165 0 1548957616 8835472 25569440
23:00:52 14134 8192000000 10480154352 10823503872 1541677728 15.838 100 80 159 0 1575936336 9510752 24747856
23:01:16 16965 8192000000 10497850768 10848358400 1557341376 15.973 100 80 159 1 1592328592 9868528 25118688
23:01:41 12733 8192000000 10520804064 10870169600 1582258192 16.188 100 76 152 1 1615069824 9630640 23180992
23:02:06 13523 8192000000 10549410192 10907242496 1608496224 16.412 100 75 150 1 1641474800 10088240 22890336
23:02:27 11032 8192000000 10565058048 10925977600 1626033264 16.561 100 79 157 2 1659723504 10018848 23671392
23:02:46 12606 8192000000 10586239248 10951942144 1643046272 16.706 100 71 142 0 1675000128 10766832 21187024
23:03:06 10816 8192000000 10620416288 10981969920 1673364560 16.962 100 80 160 0 1708743904 11385968 23993376
23:03:27 7404 8192000000 10628213936 10996699136 1685569136 17.064 100 76 152 0 1720142096 12572608 22000352
23:03:41 7290 8192000000 10639532688 11014549504 1709885840 17.268 100 70 140 1 1742348912 12580128 19882944
23:03:56 4409 8192000000 10654548880 11028930560 1717429840 17.331 100 73 146 1 1751455696 12853056 21172800
23:04:08 6577 8192000000 10662512192 11045048320 1727202800 17.412 100 68 133 1 1762155440 15849728 19102912
23:04:22 5395 8192000000 10686477408 11061587968 1747608576 17.582 100 78 156 1 1782218896 12472352 22137968
23:04:34 5508 8192000000 10698144016 11080052736 1759587488 17.681 100 69 139 2 1790520640 11547280 19385872
23:04:46 3496 8192000000 10708124000 11091357696 1773950288 17.800 100 72 144 0 1806284400 11908864 20425248
23:04:58 3487 8192000000 10729758192 11106856960 1787021680 17.907 100 78 156 1 1821073232 12018784 22032768
23:05:08 10028 8192000000 10721995392 11108802560 1796659728 17.986 100 79 158 1 1831598080 13270592 21667760
23:05:26 4402 8192000000 10736609744 11126784000 1799838672 18.013 100 71 142 2 1832458016 12691184 19928160
23:05:37 3094 8192000000 10757197376 11142230016 1818154752 18.163 100 84 168 1 1854602128 12634432 23812944
23:05:46 3203 8192000000 10762685984 11149918208 1823016624 18.202 100 86 172 1 1861325920 14520720 23788576
23:05:56 2354 8192000000 10771564416 11158437888 1830337296 18.262 100 87 173 1 1868935936 14590272 24008368
23:06:05 2043 8192000000 10774622528 11161620480 1833319200 18.286 100 79 157 1 1868702304 13096864 22286240
23:06:13 2154 8192000000 10780241264 11172777984 1840489504 18.345 100 80 161 1 1874925664 11042816 23393344
23:06:22 1659 8192000000 10795692112 11180789760 1852406448 18.442 100 96 194 3 1892230448 12438032 27385968
23:06:30 1035 8192000000 10801538624 11186372608 1857503936 18.483 100 96 192 1 1898123216 13457520 27161760
23:06:37 1373 8192000000 10808202496 11194970112 1861724352 18.517 100 90 180 1 1901129872 13686016 25719504
23:06:45 1555 8192000000 10797882928 11191308288 1864336336 18.538 100 84 165 1 1899342688 12324896 22681456
23:06:52 13423 8192000000 10795283168 11190366208 1858744960 18.493 100 61 122 1 1887831792 11993840 17092992
23:07:12 3484 8192000000 10785744560 11194363904 1859543536 18.500 100 52 102 2 1885509504 11711904 14254064
23:07:22 1189 8192000000 10787394656 11197775872 1868945376 18.576 100 63 127 0 1898282784 10890224 18447184
23:07:30 1942 8192000000 10790536720 11202932736 1866913808 18.559 100 60 120 1 1894117728 10089920 17114000
23:07:39 2671 8192000000 10793060720 11203682304 1867916704 18.567 100 46 92 1 1890108704 8821248 13370752
23:07:49 3850 8192000000 10782255280 11202039808 1867905472 18.567 100 35 70 3 1886940496 9233168 9801856
23:08:00 4261 8192000000 10787603152 11206344704 1869941280 18.584 100 43 85 1 1889717232 7993120 11782832
23:08:10 4950 8192000000 10774710992 11202424832 1870640544 18.589 100 29 58 1 1886510496 7906800 7963152
23:08:23 4674 8192000000 10784589520 11207557120 1871396000 18.596 100 33 67 1 1888455472 7750048 9309424
23:08:36 7895 8192000000 10783334896 11210596352 1876181136 18.634 100 22 44 4 1889501184 6509440 6810608
23:08:55 10564 8192000000 10783281792 11209555968 1877288304 18.643 100 21 41 1 1888291680 5114880 5888496
23:09:11 9136 8192000000 10788468224 11216830464 1881745856 18.679 100 40 79 3 1904000576 10909856 11344864
23:09:27 60453 8192000000 10795602224 11227799552 1879822128 18.664 100 35 68 1 1895130624 5216736 10091760
23:10:35 15843 8192000000 10800081552 11232186368 1882872752 18.688 100 24 48 1 1896350960 6562608 6915600
23:11:01 5565 8192000000 10802407648 11235246080 1887942464 18.729 100 35 69 0 1904550544 7440368 9167712
23:11:13 6874 8192000000 10808866064 11235422208 1888044592 18.730 100 35 68 1 1904867472 6991840 9831040
23:11:27 2590 8192000000 10815082032 11238162432 1891028848 18.754 100 48 97 1 1913113088 8336272 13747968
23:11:36 6095 8192000000 10809515952 11235995648 1889343440 18.740 100 42 80 0 1912786992 11584768 11858784
23:11:49 5153 8192000000 10812922960 11238846464 1887670368 18.727 100 32 65 0 1903260288 6383168 9206752
23:12:03 7064 8192000000 10808999536 11235180544 1887145024 18.723 100 28 56 0 1901734736 6410976 8178736
23:12:16 5279 8192000000 10806881824 11238019072 1888065120 18.730 100 19 37 1 1899070880 5134864 5870896
23:12:30 7623 8192000000 10800053552 11238846464 1893641456 18.775 100 30 59 2 1908836448 6291968 8903024
23:12:48 7809 8192000000 10820465808 11252412416 1897177584 18.804 100 24 48 1 1909371216 5506672 6686960
23:13:02 9941 8192000000 10821346112 11254104064 1897758448 18.808 100 22 44 0 1909862912 5743104 6361360
23:13:21 8297 8192000000 10832870544 11261779968 1900353312 18.829 100 23 46 1 1920551072 14056560 6141200
23:13:41 3050 8192000000 10832851744 11260268544 1903333968 18.853 100 37 74 2 1925259472 11893440 10032064
23:13:54 56677 8192000000 10781186816 11217829888 1836240928 18.310 97 25 50 2 1847281008 4464688 6575392
23:14:57 9008 8192000000 10799992368 11234009088 1882671296 18.687 100 28 57 0 1901289840 10306448 8312096
23:15:12 6838 8192000000 10794433104 11229376512 1881746560 18.679 100 29 60 0 1896350464 5730000 8873904
23:15:30 4821 8192000000 10792558880 11224784896 1869339296 18.579 99 28 56 0 1884213040 6380112 8493632
23:15:42 5105 8192000000 10794173472 11217702912 1858544880 18.491 99 21 43 2 1870945616 6216288 6184448
23:15:54 6902 8192000000 10807547888 11234385920 1881972640 18.681 100 23 46 0 1894029504 6017056 6039808
23:16:10 6651 8192000000 10774859504 11200438272 1817953904 18.161 97 27 53 2 1830540048 5286288 7299856
23:16:23 8321 8192000000 10755548624 11182211072 1825130704 18.220 98 20 40 0 1840474320 9474000 5869616
23:16:39 9275 8192000000 10746997856 11175047168 1809486496 18.092 98 24 47 2 1821752688 5401024 6865168
23:16:58 7708 8192000000 10722118928 11152744448 1750703920 17.607 95 22 43 0 1762873120 6074128 6095072
23:17:13 5757 8192000000 10758278928 11174027264 1818550064 18.166 99 26 51 0 1831327472 5851680 6925728
23:17:25 8375 8192000000 10733358848 11155787776 1787251664 17.909 97 19 37 2 1798813024 5935184 5626176
23:17:42 7668 8192000000 10713164608 11126673408 1741032400 17.527 96 31 60 2 1756270880 6329344 8909136
23:17:56 6735 8192000000 10711047536 11132665856 1763848400 17.716 98 26 52 2 1780681616 9401488 7431728
23:18:12 10757 8192000000 10686047168 11106177024 1679709888 17.015 93 22 43 4 1691576096 5378144 6488064
23:18:29 15596 8192000000 10669739216 11078266880 1665413264 16.895 94 26 53 2 1679692240 5804864 8474112
23:18:51 66512 8192000000 10674040512 11087613952 1630407984 16.598 92 25 48 0 1642233136 4689792 7135360
23:20:07 4464 8192000000 10683917408 11104415744 1775752944 17.814 100 22 44 1 1788648496 6121616 6773936
23:20:22 6376 8192000000 10718560128 11128221696 1791091776 17.941 100 36 71 2 1808560624 6813728 10655120
23:20:36 6352 8192000000 10721443504 11122876416 1777652256 17.830 99 25 50 0 1791125024 6125536 7347232
23:20:48 6183 8192000000 10711582608 11125071872 1771613040 17.780 98 35 68 1 1787847392 6037520 10196832
23:21:02 11046 8192000000 10716080080 11132760064 1772116080 17.784 98 17 35 1 1781434752 4675632 4643040
23:21:23 9856 8192000000 10729556000 11155038208 1820091024 18.178 100 24 49 1 1832055008 5904800 6059184
23:21:39 7216 8192000000 10725399568 11152515072 1818328256 18.164 100 19 38 2 1828902640 5171856 5402528
23:21:53 15543 8192000000 10746636416 11171512320 1828663408 18.248 100 23 46 1 1841376608 6424144 6289056
23:22:15 10968 8192000000 10771517920 11186257920 1843713472 18.371 100 31 62 2 1858702256 5278976 9709808
23:22:32 9527 8192000000 10757437616 11182702592 1844091696 18.374 100 27 54 1 1858387776 5641568 8654512
23:22:54 18456 8192000000 10755881344 11185647616 1843450128 18.369 100 14 28 1 1853025856 5618000 3957728
23:23:20 22508 8192000000 10763199008 11189334016 1846264192 18.392 100 19 37 1 1857694080 5600624 5829264
23:23:48 56108 8192000000 10772662128 11196141568 1861236112 18.513 100 43 85 1 1879329712 5315088 12778512
23:24:54 14040 8192000000 10772964016 11201019904 1856016224 18.471 100 25 49 2 1868285424 5733232 6535968
23:25:19 7820 8192000000 10770344080 11200724992 1856911744 18.478 100 19 38 2 1867240848 4669952 5659152
23:25:36 7837 8192000000 10782905424 11208753152 1863584752 18.532 100 30 60 2 1878939328 6990176 8364400
23:25:53 6039 8192000000 10788718000 11207000064 1864483920 18.540 100 28 54 4 1878235808 5704048 8047840
23:26:09 9884 8192000000 10773937328 11206946816 1864148096 18.537 100 17 34 0 1875015696 5811024 5056576
23:26:25 8536 8192000000 10793823408 11215228928 1867913248 18.567 100 30 58 1 1882952880 6815184 8224448
23:26:39 6584 8192000000 10788216928 11218837504 1872692864 18.606 100 26 53 2 1886654800 6729680 7232256
23:26:54 12459 8192000000 10792286080 11226460160 1877989760 18.649 100 18 36 2 1888241664 5444336 4807568
23:27:14 29907 8192000000 10810739760 11238047744 1894809760 18.785 100 31 62 2 1908657488 4723680 9124048
23:27:54 4457 8192000000 10845593632 11253534720 1903940912 18.858 100 58 116 4 1929407920 8720256 16746752
23:28:05 1739 8192000000 10869722384 11270819840 1918845744 18.978 100 79 156 1 1952178064 10841536 22490784
23:28:13 9149 8192000000 10854084336 11273498624 1917827936 18.969 100 56 111 1 1945628368 11639248 16161184
23:28:35 49033 8192000000 10848939520 11279523840 1910635504 18.912 99 44 88 4 1934369792 10852240 12882048
23:29:44 29356 8192000000 10866962800 11297574912 1932922656 19.090 100 37 75 1 1955444784 11894240 10627888
23:30:21 11947 8192000000 10872819872 11299557376 1942098832 19.164 100 39 78 1 1965339488 12343264 10897392
23:30:53 12258 8192000000 10877397536 11310735360 1947747648 19.209 100 40 78 3 1971821360 12657952 11415760
23:31:18 33905 8192000000 10889093200 11323469824 1953163072 19.252 100 40 79 5 1977457152 12873088 11420992
23:32:02 9504 8192000000 10901363360 11330121728 1963823408 19.336 100 47 94 1 1994493568 17106112 13564048
23:32:19 21917 8192000000 10897180384 11327373312 1948412800 19.214 99 48 94 2 1980693536 18660976 13619760
23:32:52 4761 8192000000 10892257216 11313410048 1945537904 19.191 99 47 94 1 1978352336 19007536 13806896
23:33:10 13050 8192000000 10912486096 11334242304 1964632928 19.343 100 47 94 0 1995631936 17249632 13749376
23:33:30 3034 8192000000 10908698256 11341950976 1972144272 19.402 100 52 103 0 2004853040 17750608 14958160
23:33:47 8074 8192000000 10920999072 11348156416 1971460672 19.397 100 51 102 0 2008769216 22788608 14519936
23:34:02 19316 8192000000 10908840272 11338887168 1938714720 19.136 98 55 110 1 1978998688 23933136 16350832
23:34:29 15437 8192000000 10899144960 11327438848 1956143232 19.275 100 47 95 2 1990613504 20081760 14388512
23:34:52 5265 8192000000 10903696016 11326046208 1940679552 19.152 99 49 98 1 1975954368 20395648 14879168
23:35:07 14844 8192000000 10904983712 11329142784 1947270240 19.205 99 61 121 1 1989167040 23816880 18079920
23:35:32 7078 8192000000 10895678384 11317989376 1944614320 19.184 99 57 112 1 1987815584 25812800 17388464
23:35:47 10485 8192000000 10906385600 11335827456 1942787264 19.169 99 52 104 4 1984074832 25012848 16274720
23:36:07 3635 8192000000 10908916880 11322159104 1946902624 19.202 99 72 144 1 1996207280 26923232 22381424
23:36:19 6892 8192000000 10911663616 11335098368 1945542128 19.191 99 58 116 1 1984211344 21132112 17537104
23:36:32 2844 8192000000 10895456480 11319746560 1943927184 19.178 99 58 115 0 1986505360 25543424 17034752
23:36:44 4261 8192000000 10899568400 11329404928 1957614848 19.287 100 56 112 0 1995148880 20738496 16795536
23:36:56 4927 8192000000 10899364560 11323670528 1948979984 19.218 100 52 104 1 1986525392 20842256 16703152
23:37:09 4318 8192000000 10897878784 11318931456 1944397024 19.182 99 63 124 2 1983024304 20435040 18192240
23:37:19 5870 8192000000 10906642576 11334586368 1958975664 19.298 100 59 118 0 1999655152 22541232 18138256
23:37:33 4974 8192000000 10895775856 11317514240 1916255296 18.957 98 66 130 2 1959516576 23571248 19690032
23:37:45 10377 8192000000 10907936016 11328897024 1950520592 19.231 100 57 114 0 1991994048 24268784 17204672
23:38:02 3735 8192000000 10899912064 11324444672 1947137040 19.204 100 57 114 0 1988944576 23804016 18003520
23:38:13 13789 8192000000 10908219184 11333996544 1955602064 19.271 100 70 140 0 2000782624 23786208 21394352
23:38:33 987 8192000000 10933207744 11337658368 1952122816 19.243 99 90 182 1 2002838976 24194352 26521808
23:38:41 1308 8192000000 10933168832 11339280384 1948427696 19.214 99 88 178 0 2004591808 29167424 26996688
23:38:49 2301 8192000000 10928435808 11335270400 1940191888 19.148 99 93 186 0 1998741584 30793680 27756016
23:38:59 5849 8192000000 10908320560 11328270336 1934321296 19.101 99 65 128 3 1980548560 27055936 19171328
23:39:12 1722 8192000000 10929319328 11334123520 1956514912 19.278 100 85 171 0 2008846432 27296688 25034832
23:39:20 6338 8192000000 10902427488 11316670464 1936534000 19.119 100 74 146 2 1986914640 27666496 22714144
23:39:34 4348 8192000000 10909087104 11322519552 1927894032 19.050 99 75 147 2 1980085600 29689776 22501792
23:39:45 5272 8192000000 10906981488 11324084224 1941071376 19.155 100 63 126 3 1990720080 29717440 19931264
23:40:06 3305 8192000000 10903545136 11312545792 1929625344 19.064 99 72 144 0 1983664192 32034912 22003936
23:40:17 3351 8192000000 10893719008 11300126720 1920838096 18.994 99 75 148 5 1976316464 32209232 23269136
23:40:28 2631 8192000000 10908827152 11314282496 1932058512 19.083 100 72 141 1 1986764944 32963440 21742992
23:40:38 2444 8192000000 10883519872 11290431488 1907381728 18.886 100 83 165 0 1966550704 33529200 25639776
23:40:47 1793 8192000000 10899456768 11298025472 1914870000 18.946 100 93 184 2 1976650592 33976496 27804096
23:40:57 3174 8192000000 10884060752 11288834048 1897517216 18.806 99 77 151 1 1955381856 33989776 23874864
23:41:08 2078 8192000000 10899912528 11307782144 1927211536 19.045 100 78 157 0 1985865344 34491696 24162112
23:41:17 1613 8192000000 10907441040 11312472064 1923409936 19.014 100 81 162 0 1985604448 36711872 25482640
23:41:26 3435 8192000000 10918506720 11325419520 1931599520 19.080 100 82 162 3 1996451200 39013616 25838064
23:41:37 4274 8192000000 10899263664 11310030848 1922475536 19.007 100 74 144 0 1984632208 39020752 23135920
23:41:51 9390 8192000000 10882903664 11299246080 1900905168 18.834 99 73 143 3 1963941680 39649728 23386784
23:42:09 4407 8192000000 10886777664 11299979264 1912861520 18.930 100 70 139 2 1974512368 39094160 22556688
23:42:20 2682 8192000000 10900223680 11306500096 1922643120 19.008 100 85 171 2 1983356784 33614032 27099632
23:42:29 7490 8192000000 10903979712 11318943744 1933501904 19.095 100 72 144 2 1989882464 33912752 22467808
23:42:45 3500 8192000000 10902885680 11320770560 1935016448 19.107 100 63 125 1 1988228256 33470064 19741744
23:42:55 3516 8192000000 10902130848 11325919232 1938831968 19.137 100 60 116 2 1985309280 28496560 17980752
23:43:06 3765 8192000000 10877955264 11304009728 1913431664 18.934 99 49 98 0 1950221008 20932784 15856560
23:43:36 13851 8192000000 10876199824 11310874624 1931203552 19.077 100 32 64 0 1961298272 20115776 9978944
23:43:57 8814 8192000000 10874021776 11309916160 1928952912 19.059 100 37 74 1 1963834512 22632512 12249088
23:44:13 12445 8192000000 10876864736 11319701504 1923267136 19.013 99 34 68 0 1958919152 24901968 10750048
23:44:32 13016 8192000000 10864913104 11296333824 1885029776 18.706 98 24 48 3 1919157312 25772976 8354560
23:44:55 2616 8192000000 10890699792 11303186432 1922670880 19.008 100 64 128 2 1969181760 26954800 19556080
23:45:06 1643 8192000000 10898490944 11318882304 1933408048 19.094 100 65 131 0 1983738960 29872480 20458432
23:45:21 7475 8192000000 10920486336 11341881344 1951469440 19.238 100 71 139 1 2005504512 32322032 21713040
23:45:36 2031 8192000000 10930666304 11348103168 1955652048 19.271 100 77 153 0 2013617824 34557904 23407872
23:45:46 14307 8192000000 10912357008 11357364224 1953707808 19.256 100 38 76 1 1998914256 32564544 12641904
23:46:07 15829 8192000000 10883282816 11325542400 1917187728 18.964 98 32 64 1 1954271264 26207360 10876176
23:46:29 14259 8192000000 10893879264 11329404928 1946493312 19.199 100 38 76 0 1981932544 22816512 12622720
23:46:55 15278 8192000000 10897562640 11344408576 1949052736 19.219 100 32 64 0 1984084656 24726976 10304944
23:47:17 5917 8192000000 10893792160 11338579968 1944111312 19.180 100 30 60 0 1977169888 23542288 9516288
23:47:30 23940 8192000000 10905533664 11344617472 1945995840 19.195 100 26 52 0 1976452176 22289824 8166512
23:48:01 14175 8192000000 10901670896 11345907712 1955817248 19.273 100 31 62 1 1989582096 23441296 10323552
23:48:31 9860 8192000000 10921682464 11360198656 1964127792 19.339 100 34 68 1 1998968096 23428848 11411456
23:48:49 17558 8192000000 10927853200 11372687360 1969209872 19.379 100 30 60 1 2007142480 28001824 9930784
23:49:29 20725 8192000000 10916140896 11363975168 1952763024 19.248 99 24 48 0 1989775536 28858480 8154032
23:49:57 16917 8192000000 10911373456 11364237312 1964524896 19.342 100 22 43 3 1994989952 23010864 7454192
23:50:20 18473 8192000000 10913482480 11371905024 1973251792 19.411 100 25 50 0 2012933072 31330480 8350800
23:50:44 19627 8192000000 10913837984 11374661632 1965723728 19.352 100 22 44 3 1996147680 23256944 7167008
23:51:10 33480 8192000000 10908966416 11377311744 1948488624 19.214 99 17 34 0 1983282864 28954800 5839440
23:51:50 26159 8192000000 10876270880 11354329088 1921515072 18.999 99 8 15 1 1943297648 19177008 2605568
23:52:44 109268 8192000000 10887125344 11343417344 1934214560 19.101 99 32 64 0 1961807056 18226000 9366496
23:54:42 78901 8192000000 10879115856 11339636736 1937096816 19.124 99 21 43 2 1951695248 8621344 5977088
23:56:07 50975 8192000000 10895239792 11353772032 1964282400 19.340 100 38 76 2 1983768544 9224464 10261680
23:57:16 71689 8192000000 10911156432 11376115712 1978465888 19.453 100 20 40 0 1994088448 10209504 5413056
23:58:38 45326 8192000000 10897584992 11368484864 1967351216 19.364 99 13 27 0 1980521056 9667488 3502352
23:59:37 24493 8192000000 10899003024 11376005120 1980756640 19.471 100 8 15 0 1989066800 6701664 1608496
00:00:08 30464 8192000000 10913723328 11381997568 1993693328 19.573 100 15 28 1 2005704256 8277472 3733456
00:00:52 50759 8192000000 10930074272 11398602752 2006214880 19.672 100 23 46 0 2021347696 8222048 6910768
00:01:49 32966 8192000000 10926476672 11385729024 1966406576 19.357 98 15 30 0 1982211680 11519888 4285216
00:02:34 57784 8192000000 10913624480 11391807488 1992232144 19.561 100 17 34 1 2011071104 14090912 4748048
00:04:02 59368 8192000000 10937920528 11398328320 1993515520 19.572 100 23 46 0 2011915600 11628896 6771184
00:05:07 58180 8192000000 10916243712 11396661248 1996553200 19.596 100 12 24 2 2013976944 14250880 3172864
00:06:13 44953 8192000000 10907226384 11388817408 1983772592 19.495 99 20 40 1 1996581312 6767056 6041664
00:07:04 32089 8192000000 10933123280 11401216000 1984166928 19.498 99 31 62 1 2008407008 15280640 8959440
00:08:50 69409 8192000000 10935380336 11389837312 1956783856 19.280 98 23 47 1 1982783552 18750512 7249184
00:10:06 26634 8192000000 10942175808 11392008192 1999820592 19.621 100 41 78 3 2027530624 16161040 11548992
00:10:42 37211 8192000000 10925651264 11387887616 1962686672 19.327 98 23 46 2 1983331056 14044560 6599824
00:11:46 93628 8192000000 10873816656 11347554304 1860805840 18.510 94 12 24 0 1876407152 12273280 3328032
00:13:27 52613 8192000000 10901718272 11371442176 1965544528 19.350 100 14 29 1 1980669152 11040928 4083696
00:14:33 68312 8192000000 10916438304 11393019904 1970035360 19.386 99 27 54 0 1991785648 13853296 7896992
00:15:53 81134 8192000000 10919228384 11384078336 1928117536 19.052 97 16 30 2 1944962016 12864160 3980320
00:17:29 88416 8192000000 10897021824 11348348928 1845463232 18.385 93 17 33 1 1859510320 8942032 5105056
00:19:11 97896 8192000000 10880434992 11344834560 1907645760 18.888 97 23 46 1 1929136704 14742032 6748912
00:20:56 96146 8192000000 10883713312 11369152512 1939483056 19.143 99 24 48 0 1972518512 25943280 7092176
00:23:04 21013 8192000000 10849677760 11304546304 1851248960 18.432 95 9 18 0 1869990912 16700656 2041296
00:23:32 47300 8192000000 10835944608 11297488896 1861541024 18.516 96 15 30 1 1875643136 9823040 4279072
00:24:28 61780 8192000000 10843482208 11308396544 1866826848 18.559 96 8 16 1 1877768528 9090720 1850960
00:25:56 51802 8192000000 10838764496 11308466176 1860598640 18.508 96 10 20 0 1877705872 13838096 3269136
00:26:57 21497 8192000000 10831898112 11312111616 1917280192 18.965 100 9 18 0 1933369344 13709040 2380112
00:27:31 8255 8192000000 10837668016 11317895168 1919346656 18.982 100 9 18 0 1937046208 15213312 2486240
00:27:48 18847 8192000000 10839890352 11316736000 1904566352 18.863 99 5 10 1 1918800096 12771840 1461904
00:28:19 43806 8192000000 10860380688 11335245824 1916509808 18.959 99 15 30 0 1935444544 14541760 4392976
00:29:11 49942 8192000000 10834321360 11317075968 1877427632 18.644 97 5 10 1 1894090224 15418576 1244016
00:30:08 77549 8192000000 10867031696 11322236928 1853833168 18.453 96 20 40 1 1869949248 10877136 5238944
00:31:32 53608 8192000000 10855461920 11315150848 1844072112 18.374 95 19 38 0 1860212512 11008976 5131424
00:32:32 54715 8192000000 10846966208 11311976448 1870894416 18.592 97 7 14 0 1886743296 14251968 1596912
00:33:33 39718 8192000000 10889448944 11343601664 1942565360 19.167 100 25 50 0 1957821104 8110672 7145072
00:34:19 35272 8192000000 10898303200 11359842304 1960064560 19.307 100 33 66 1 1981833088 12967744 8800784
00:35:03 25197 8192000000 10838976352 11283427328 1770621152 17.772 91 31 62 1 1787762880 8728928 8412800
00:35:34 35863 8192000000 10855954800 11314954240 1899548144 18.823 99 29 57 2 1916972352 9873008 7551200
00:36:17 18551 8192000000 10875251856 11313266688 1917610768 18.968 99 52 102 1 1943228528 10807328 14810432
00:36:42 64851 8192000000 10895647728 11335675904 1914373216 18.942 98 47 94 0 1940819136 13539280 12906640
00:37:54 45677 8192000000 10871992704 11346612224 1946013840 19.195 100 38 76 1 1978465568 20986032 11465696
00:38:57 75643 8192000000 10890201552 11366920192 1908409200 18.894 98 8 16 1 1936753728 25919248 2425280
00:40:33 123809 8192000000 10887372912 11356336128 1930667472 19.072 99 9 18 0 1955793088 22699088 2426528
00:42:44 91739 8192000000 10898110464 11360641024 1974579968 19.422 100 37 74 0 1994785584 8717024 11488592
00:44:21 95347 8192000000 10910514512 11376078848 1960810432 19.312 99 19 38 0 1976619600 10328336 5480832
00:46:55 86277 8192000000 10905907504 11388829696 1978586624 19.454 100 17 34 0 1993986112 10736544 4662944
00:48:39 54023 8192000000 10914705232 11390353408 1973852848 19.416 99 20 40 2 1991574272 11759808 5961616
00:49:44 72437 8192000000 10905390784 11388186624 1970423312 19.389 99 16 32 0 1987487728 12188992 4875424
00:51:10 72573 8192000000 10907296928 11391946752 1982995520 19.488 100 15 30 4 2002188192 14720528 4472144
00:52:38 50375 8192000000 10891972224 11375104000 1945302464 19.189 98 18 36 3 1966675248 16184048 5188736
00:54:15 69363 8192000000 10887621600 11365277696 1955096368 19.267 99 12 24 0 1967440272 9167568 3176336
00:55:47 103714 8192000000 10916424816 11399745536 1987046224 19.520 100 17 34 2 2004253840 12350144 4857472
00:57:37 36562 8192000000 10920877584 11394113536 2003263936 19.648 100 38 76 1 2025026944 11097600 10665408
00:58:22 67930 8192000000 10908858432 11368955904 1925487312 19.031 96 12 24 0 1934732704 6447872 2797520
00:59:36 22712 8192000000 10911227984 11382763520 1968934832 19.377 99 20 39 2 1985211968 10616704 5660432
01:00:08 74376 8192000000 10892289520 11368898560 1884536928 18.702 95 9 18 1 1898498752 11580096 2381728
01:01:34 92154 8192000000 10898746128 11374755840 1892143840 18.763 96 7 14 0 1905801808 11732624 1925344
01:03:12 46323 8192000000 10923986944 11387899904 1975443552 19.429 99 36 72 3 1999929008 14096080 10389376
01:04:04 31381 8192000000 10939406704 11403018240 1998810832 19.613 100 61 122 0 2030491360 13542256 18138272
01:04:43 45748 8192000000 10945473360 11412938752 1995472464 19.587 100 27 54 1 2016076544 13454112 7149968
01:05:40 88803 8192000000 10926625616 11396624384 1957645728 19.287 98 31 62 2 1982223040 16069792 8507520
01:07:24 73802 8192000000 10922709536 11384467456 1945527312 19.191 98 14 28 0 1965552048 16118656 3906080
01:08:45 71363 8192000000 10903946688 11376398336 1906787728 18.881 96 23 46 2 1928116224 15100896 6227600
01:10:03 134962 8192000000 10860222560 11329757184 1894461856 18.782 96 29 58 1 1913212528 10341808 8408864
01:12:44 32821 8192000000 10880599984 11364896768 1966607808 19.359 100 28 56 3 1984868208 9828608 8431792
01:13:39 38610 8192000000 10878461296 11364016128 1925572752 19.031 98 10 19 1 1944526800 16632832 2321216
01:14:34 37929 8192000000 10859272208 11345248256 1914120992 18.940 98 5 10 0 1926303872 10881184 1301696
01:15:58 68999 8192000000 10816738752 11288592384 1837657712 18.322 94 6 12 0 1846565280 7476288 1431280
01:17:13 47520 8192000000 10833317888 11288137728 1793577968 17.961 93 13 25 1 1804998400 7886880 3533552
01:18:10 109142 8192000000 10831381248 11301310464 1899472400 18.822 99 21 44 1 1912614224 7660960 5480864
01:20:16 69358 8192000000 10807960096 11283030016 1821330784 18.189 94 13 26 0 1832271136 7152688 3787664
01:21:49 72038 8192000000 10827608288 11307257856 1875226336 18.627 98 12 24 0 1889527136 10966000 3334800
01:23:08 33084 8192000000 10858089904 11318853632 1907987280 18.890 99 32 64 3 1926655200 9724176 8943744
01:23:47 22702 8192000000 10844290208 11302162432 1871395408 18.596 97 31 62 1 1890430016 10554048 8480560
01:24:22 37232 8192000000 10857952432 11312410624 1886899008 18.721 98 42 84 1 1913303344 14814608 11589728
01:25:05 92998 8192000000 10855355264 11330547712 1930279728 19.069 100 30 60 1 1951996848 12918304 8798816
01:26:44 27919 8192000000 9171379120 9417261056 336661808 3.947 18 1 2 0 338208688 1470976 75904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-12-2020 01:28:18 to 11-12-2020 01:28:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 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 11-12-2020 01:28:50 to 11-12-2020 01:28:52.

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

11.12.20 01:28:53. 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
2020-12-11 01:28:55 No severe PSQL-related problems occured
11.12.20 01:28:57. End of report.