Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.01.2021 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 17231396 kB
MemAvailable 31268544 kB
Buffers 0 kB
Cached 14436204 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-24 01:27:12
DTS_END                         2021-01-24 01:27:12.7350
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/54822
TRN_ID                          244586
ATT_ID                          736
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: 9482.17 20177 1137861
customer order: creation 178.73 371 21448
customer order: refuse 15.18 343 1821
order to supplier: creation 47.78 1277 5734
order to supplier: removal 3.62 87278 434
invoice (draft): creation 47.84 3360 5741
invoice (draft): removal 53.11 748 6373
invoice accept: apply 43.80 17229 5256
invoice accept: cancel 48.03 784 5763
customer reserve: creation 3989.23 172 478708
customer reserve: removal 4758.24 53 570989
realization accept: apply 87.78 169 10533
realization accept: cancel 75.26 113 9031
payment from customer: creation 60.96 119 7315
payment from customer: removal 5.74 84 689
payment to supplier: creation 50.72 112 6086
payment to supplier: removal 3.67 63 440
service: total inventory turnovers 4.95 1134 594
service: total monetary turnovers 6.73 26 808
service: aggregate perf. data 0.78 23291 94
service: refresh index statistics 0.03 266816 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-01-2021 01:28:21 to 24-01-2021 01:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1938
TEST_TIME 2 2585
TEST_TIME 3 3001
TEST_TIME 4 3541
TEST_TIME 5 3929
TEST_TIME 6 4249
TEST_TIME 7 4541
TEST_TIME 8 4733
TEST_TIME 9 4677
TEST_TIME 10 5156
TEST_TIME 11 5362
TEST_TIME 12 5648
TEST_TIME 13 6767
TEST_TIME 14 6828
TEST_TIME 15 7026
TEST_TIME 16 7232
TEST_TIME 17 7622
TEST_TIME 18 7903
TEST_TIME 19 8257
TEST_TIME 20 8612
TEST_TIME 21 9414
TEST_TIME 22 9763
TEST_TIME 23 10123
TEST_TIME 24 10335
TEST_TIME 25 10344
TEST_TIME 26 10336
TEST_TIME 27 10319
TEST_TIME 28 10044
TEST_TIME 29 9980
TEST_TIME 30 9924
TEST_TIME 31 9886
TEST_TIME 32 9698
TEST_TIME 33 9750
TEST_TIME 34 9775
TEST_TIME 35 9763
TEST_TIME 36 9634
TEST_TIME 37 9650
TEST_TIME 38 9605
TEST_TIME 39 9544
TEST_TIME 40 9320
TEST_TIME 41 9338
TEST_TIME 42 9275
TEST_TIME 43 9299
TEST_TIME 44 9226
TEST_TIME 45 9324
TEST_TIME 46 9265
TEST_TIME 47 9261
TEST_TIME 48 9347
TEST_TIME 49 9531
TEST_TIME 50 9549
TEST_TIME 51 9561
TEST_TIME 52 9533
TEST_TIME 53 9601
TEST_TIME 54 9638
TEST_TIME 55 9666
TEST_TIME 56 9658
TEST_TIME 57 9632
TEST_TIME 58 9561
TEST_TIME 59 9583
TEST_TIME 60 9507
TEST_TIME 61 9581
TEST_TIME 62 9465
TEST_TIME 63 9480
TEST_TIME 64 9475
TEST_TIME 65 9420
TEST_TIME 66 9373
TEST_TIME 67 9351
TEST_TIME 68 9432
TEST_TIME 69 9510
TEST_TIME 70 9527
TEST_TIME 71 9675
TEST_TIME 72 9677
TEST_TIME 73 9671
TEST_TIME 74 9811
TEST_TIME 75 9795
TEST_TIME 76 9838
TEST_TIME 77 9845
TEST_TIME 78 9816
TEST_TIME 79 9804
TEST_TIME 80 9738
TEST_TIME 81 9747
TEST_TIME 82 9760
TEST_TIME 83 9730
TEST_TIME 84 9670
TEST_TIME 85 9648
TEST_TIME 86 9616
TEST_TIME 87 9554
TEST_TIME 88 9512
TEST_TIME 89 9465
TEST_TIME 90 9490
TEST_TIME 91 9494
TEST_TIME 92 9518
TEST_TIME 93 9507
TEST_TIME 94 9511
TEST_TIME 95 9625
TEST_TIME 96 9616
TEST_TIME 97 9618
TEST_TIME 98 9626
TEST_TIME 99 9634
TEST_TIME 100 9649
TEST_TIME 101 9660
TEST_TIME 102 9682
TEST_TIME 103 9664
TEST_TIME 104 9697
TEST_TIME 105 9658
TEST_TIME 106 9600
TEST_TIME 107 9545
TEST_TIME 108 9542
TEST_TIME 109 9506
TEST_TIME 110 9443
TEST_TIME 111 9397
TEST_TIME 112 9458
TEST_TIME 113 9453
TEST_TIME 114 9464
TEST_TIME 115 9456
TEST_TIME 116 9484
TEST_TIME 117 9469
TEST_TIME 118 9466
TEST_TIME 119 9511
TEST_TIME 120 9482

Performance per minute, chart


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

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 1582093 1582093 0 0.00 0 9699 6 0 0
doc_list_biud 1582070 1582070 0 0.00 0 42590 25 0 0
sp_add_invoice_to_stock 5393 5256 137 2.54 25 196429 17230 0 137
sp_cancel_adding_invoice 5763 5763 0 0.00 4 83449 784 0 0
sp_cancel_client_order 1821 1821 0 0.00 4 12420 343 0 0
sp_cancel_customer_reserve 570989 570989 0 0.00 1 35880 53 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 2 4585 84 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 3 2663 64 0 0
sp_cancel_supplier_invoice 6385 6373 12 0.18 2 29937 749 0 12
sp_cancel_supplier_order 434 434 0 0.00 10 1039764 87278 0 0
sp_cancel_write_off 9031 9031 0 0.00 1 24203 114 0 0
sp_client_order 21448 21448 0 0.00 3 30048 372 0 0
sp_customer_reserve 478708 478708 0 0.00 0 41444 173 0 0
sp_fill_shopping_cart 32897 32897 0 0.00 1 14617 35 0 0
sp_fill_shopping_cart_clo_res 478704 478704 0 0.00 0 28208 15 0 0
sp_get_clo_for_invoice 5252 5252 0 0.00 0 15979 310 0 0
sp_kill_cost_storno 15923 15923 0 0.00 0 7890 52 0 0
sp_kill_qstorno_ret_qs2qd 1157816 1157816 0 0.00 0 35861 29 0 0
sp_kill_qty_storno 610196 610196 0 0.00 0 42588 64 0 0
sp_lock_selected_doc 21815 21815 0 0.00 0 7300 6 0 0
sp_make_cost_storno 29186 29186 0 0.00 0 9197 44 0 0
sp_multiply_rows_for_pdistr 29186 29186 0 0.00 0 7833 27 0 0
sp_multiply_rows_for_qdistr 21448 21448 0 0.00 0 13582 177 0 0
sp_pay_from_customer 7315 7315 0 0.00 4 36081 120 0 0
sp_pay_to_supplier 6086 6086 0 0.00 4 11164 112 0 0
sp_payment_common 13396 13396 0 0.00 1 36075 27 0 0
sp_qd_handle_on_cancel_clo 1821 1821 0 0.00 0 12413 311 0 0
sp_qd_handle_on_invoice_upd_sts 11015 11015 0 0.00 0 42588 326 0 0
sp_qd_handle_on_reserve_upd_sts 10533 10533 0 0.00 0 28692 65 0 0
sp_reserve_write_off 10533 10533 0 0.00 6 28727 170 0 0
sp_supplier_invoice 5741 5741 0 0.00 5 80958 3360 0 0
sp_supplier_order 5734 5734 0 0.00 4 41621 1277 0 0
srv_aggregate_perf_data 94 94 0 0.00 3077 351851 23292 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1211 143272 32876 0 0
srv_find_qd_qs_mism 1088885 1088885 0 0.00 0 9553 5 0 0
srv_make_invnt_saldo 594 594 0 0.00 28 66982 1134 0 0
srv_make_money_saldo 808 808 0 0.00 1 4356 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 219119 331855 266816 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5256 5256 0 0.00 0 15482 130 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 3303 90 0 0
t$perf-norm:sp_cancel_client_order 1821 1821 0 0.00 0 3771 17 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 969 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 976 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 793 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 454 454 0 0.00 0 2458 25 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 26541 1384 0 0
t$perf-norm:sp_cancel_write_off 1053 1053 0 0.00 0 5284 12 0 0
t$perf-norm:sp_client_order 21448 21448 0 0.00 0 22740 17 0 0
t$perf-norm:sp_customer_reserve 1095 1095 0 0.00 0 420 4 0 0
t$perf-norm:sp_pay_from_customer 7315 7315 0 0.00 0 4086 8 0 0
t$perf-norm:sp_pay_to_supplier 6086 6086 0 0.00 0 3397 7 0 0
t$perf-norm:sp_reserve_write_off 10533 10533 0 0.00 0 10208 8 0 0
t$perf-norm:sp_supplier_invoice 5741 5741 0 0.00 0 9632 16 0 0
t$perf-norm:sp_supplier_order 5734 5734 0 0.00 0 4154 14 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 70 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 474 9 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 2099 19 0 0
t$perf-norm:srv_make_money_saldo 808 808 0 0.00 0 6148 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 16 7 0 0
v_add_invoice_to_stock 10771 10497 274 2.54 0 9695 17 0 274
v_all_customers 38528 38528 0 0.00 0 16 1 0 0
v_all_suppliers 31414 31414 0 0.00 0 13 1 0 0
v_all_wares 42878 42878 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 192 5 0 0
v_cancel_client_order 3642 3642 0 0.00 0 2999 6 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 3163 10 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 1237 4 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 146 2 0 0
v_cancel_supplier_invoice 932 908 24 2.57 0 2272 13 0 24
v_cancel_supplier_order 868 868 0 0.00 0 2151 6 0 0
v_cancel_write_off 2106 2106 0 0.00 0 3368 14 0 0
v_max_id_clo_ord 5729 5729 0 0.00 0 3747 2 0 0
v_max_id_clo_res 1095 1095 0 0.00 0 6069 20 0 0
v_max_id_ord_sup 5728 5728 0 0.00 0 7720 5 0 0
v_max_non_paid_invoice 1833 1833 0 0.00 0 991 3 0 0
v_max_non_paid_realizn 4159 4159 0 0.00 0 2777 3 0 0
v_min_id_clo_ord 5729 5729 0 0.00 0 2003 5 0 0
v_min_id_clo_res 1095 1095 0 0.00 0 4815 12 0 0
v_min_id_ord_sup 5728 5728 0 0.00 0 10046 6 0 0
v_min_non_paid_invoice 6083 6083 0 0.00 0 7992 14 0 0
v_min_non_paid_realizn 7312 7312 0 0.00 0 36071 19 0 0
v_our_firm 10656 10656 0 0.00 0 57 1 0 0
v_reserve_write_off 21060 21060 0 0.00 0 4554 5 0 0
x_lock_depdocs_on_canc_invoice 11682 11682 0 0.00 0 14424 91 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 5957 284 0 0
x_make_qstorno_1000_1200 5734 5734 0 0.00 2 41596 1202 0 0
x_make_qstorno_1200_2000 5741 5741 0 0.00 2 80245 3226 0 0
x_make_qstorno_2100_3300 478708 478708 0 0.00 0 41442 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-01-2021 01:28:29 to 24-01-2021 01:28:33.

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:16 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:22 15011 8192000000 10236167040 10542288896 862258096 9.523 68 57 117 0 882986480 2175264 18553120
22:57:45 22323 8192000000 10322782640 10638446592 1351437056 14.160 100 83 166 0 1383341184 4596512 27307616
22:58:15 15754 8192000000 10341488752 10663325696 1403126496 14.623 100 90 180 0 1438692672 6196336 29369840
22:58:39 24833 8192000000 10386100912 10709938176 1434879008 14.904 100 83 166 1 1469133648 7104192 27150448
22:59:11 32853 8192000000 10411081632 10744029184 1467016544 15.188 100 87 174 2 1503120368 8356224 27747600
22:59:54 23276 8192000000 10432794800 10764075008 1485266992 15.348 100 90 180 2 1523074752 9121344 28686416
23:00:30 9970 8192000000 10438684176 10777473024 1502170496 15.495 100 87 173 3 1539689728 9388480 28130752
23:00:50 24853 8192000000 10471184496 10811092992 1521143712 15.660 100 83 166 1 1556582800 9584416 25854672
23:01:28 18044 8192000000 10503212400 10848411648 1556125904 15.963 100 79 158 0 1590470112 9687984 24656224
23:01:56 19962 8192000000 10526275360 10879614976 1581558672 16.182 100 73 146 1 1614621808 10139168 22923968
23:02:27 12833 8192000000 10544392368 10905239552 1609229520 16.418 100 77 154 2 1642888176 10271856 23386800
23:02:49 8119 8192000000 10567556816 10927792128 1631151456 16.605 100 72 144 1 1663705440 10916656 21637328
23:03:05 12761 8192000000 10582419904 10947231744 1645199920 16.724 100 73 146 0 1677321440 10777104 21344416
23:03:28 12858 8192000000 10603233792 10968276992 1667660000 16.913 100 86 172 0 1705369232 12212736 25496496
23:03:57 6944 8192000000 10626338176 10997096448 1688376848 17.088 100 81 162 1 1724265344 12585680 23302816
23:04:13 8753 8192000000 10643606272 11014184960 1711517104 17.281 100 74 148 1 1745030880 11902880 21610896
23:04:29 5411 8192000000 10657266048 11031908352 1723199264 17.379 100 90 180 0 1762642544 13146288 26296992
23:04:42 7297 8192000000 10671408528 11047936000 1728445664 17.423 100 72 141 1 1760471744 11824864 20201216
23:04:59 4820 8192000000 10694215552 11067633664 1746210864 17.570 100 77 153 1 1779443968 11937632 21295472
23:05:11 3579 8192000000 10707387424 11080744960 1760437856 17.688 100 87 174 2 1799253696 14472768 24343072
23:05:22 4841 8192000000 10706438080 11083956224 1766399856 17.737 100 90 181 2 1806060864 14280112 25380896
23:05:34 5754 8192000000 10715277360 11094159360 1774525568 17.804 100 86 171 0 1813127968 14035920 24566480
23:05:47 3755 8192000000 10728572688 11105579008 1782192912 17.868 100 87 173 2 1820409536 14475440 23741184
23:05:57 2724 8192000000 10727236896 11112775680 1790209872 17.934 100 89 176 2 1829730208 14447536 25072800
23:06:07 2820 8192000000 10741247088 11121917952 1800364144 18.017 100 92 184 1 1839163440 13358144 25441152
23:06:17 2546 8192000000 10755196320 11134259200 1810189824 18.097 100 90 180 0 1850317920 15154896 24973200
23:06:26 1669 8192000000 10754662288 11134156800 1811533088 18.108 100 91 180 2 1851855792 15160112 25162592
23:06:34 1827 8192000000 10761083856 11139645440 1817666112 18.159 100 87 171 0 1856371136 14645040 24059984
23:06:42 7819 8192000000 10763318032 11146100736 1818112688 18.162 100 86 170 1 1856917936 15225104 23580144
23:06:57 3284 8192000000 10771900832 11151372288 1822813104 18.201 100 90 180 0 1862972304 15373520 24785680
23:07:06 2085 8192000000 10773704624 11161759744 1836620096 18.313 100 83 164 1 1873978272 13340240 24017936
23:07:14 1351 8192000000 10788732896 11170402304 1839870128 18.340 100 86 172 1 1878444736 14078928 24495680
23:07:22 1422 8192000000 10784264800 11170447360 1844367840 18.376 100 91 182 0 1882362048 12710784 25283424
23:07:30 1526 8192000000 10796232080 11180589056 1852109408 18.439 100 89 179 1 1889586592 12223824 25253360
23:07:38 1077 8192000000 10800470480 11188703232 1859063776 18.496 100 88 176 0 1897418720 12166992 26187952
23:07:45 1513 8192000000 10808352784 11195383808 1861344736 18.514 100 91 181 2 1898937088 12292432 25299920
23:07:53 1696 8192000000 10810886896 11200503808 1867548576 18.564 100 89 175 2 1904334416 12297456 24488384
23:08:01 6527 8192000000 10788162096 11201658880 1865240464 18.546 100 58 117 1 1892835728 11474320 16120944
23:08:18 24956 8192000000 10799194320 11202830336 1871008496 18.592 100 59 118 1 1895375920 6217984 18149440
23:08:49 27958 8192000000 10778510768 11199021056 1865077840 18.544 100 30 60 2 1880521136 6563776 8879520
23:09:26 4072 8192000000 10774755968 11204079616 1869096032 18.577 100 18 36 3 1880995264 6558272 5340960
23:09:37 8746 8192000000 10781886240 11213606912 1872204368 18.602 100 22 44 0 1884614048 6386368 6023312
23:09:55 7431 8192000000 10786789952 11214864384 1879332816 18.660 100 16 31 2 1889321920 5699344 4289760
23:10:10 7678 8192000000 10790289504 11226566656 1883794944 18.696 100 26 52 0 1897658352 7084080 6779328
23:10:27 8172 8192000000 10788798432 11224743936 1886659248 18.719 100 18 36 0 1897049408 5662576 4727584
23:10:42 11094 8192000000 10793154704 11227082752 1889107808 18.739 100 20 43 0 1900856752 6128896 5620048
23:11:03 15669 8192000000 10811011200 11235454976 1895771824 18.792 100 22 43 4 1907749552 5561952 6415776
23:11:28 10409 8192000000 10802135440 11236663296 1892005840 18.762 100 13 26 1 1902134480 6099152 4029488
23:11:44 5879 8192000000 10796650688 11232428032 1893937792 18.778 100 20 41 1 1905154640 5264048 5952800
23:11:58 10038 8192000000 10810783120 11240435712 1896239072 18.796 100 18 36 1 1906780928 5023488 5518368
23:12:18 10741 8192000000 10804687776 11239170048 1898065424 18.811 100 13 26 0 1907330080 5605936 3658720
23:12:35 10315 8192000000 10803777536 11244208128 1902372224 18.845 100 15 30 0 1912385888 6010128 4003536
23:12:54 16445 8192000000 10820603488 11255676928 1903684368 18.856 100 26 52 2 1921741072 10265728 7790976
23:13:18 58930 8192000000 10857910112 11267166208 1913797472 18.937 100 52 104 1 1934581600 5375280 15408848
23:14:23 9082 8192000000 10822745392 11262541824 1912633504 18.928 100 28 56 3 1927490416 7191936 7664976
23:14:42 7618 8192000000 10836959136 11262459904 1912754608 18.929 100 22 44 0 1925196912 5537712 6904592
23:14:58 6952 8192000000 10821736272 11264278528 1916518384 18.959 100 34 68 1 1933268496 7017504 9732608
23:15:11 11990 8192000000 10829017856 11268194304 1915449616 18.950 100 21 42 3 1927555584 6264208 5841760
23:15:29 7875 8192000000 10818695632 11256565760 1895735664 18.792 99 14 29 0 1904870928 5009520 4125744
23:15:43 7570 8192000000 10832400464 11266002944 1912075120 18.923 100 17 34 1 1922843456 5737040 5031296
23:15:57 5397 8192000000 10815270912 11251048448 1898711456 18.816 99 32 64 0 1915660304 6496112 10452736
23:16:15 8222 8192000000 10811554096 11242233856 1867287520 18.562 98 24 50 3 1879123168 5450896 6384752
23:16:36 7343 8192000000 10812423200 11244376064 1868844736 18.575 98 22 44 3 1881622432 6010080 6767616
23:16:51 6615 8192000000 10797950016 11234140160 1862738512 18.525 98 23 46 1 1874834784 5568384 6527888
23:17:04 14031 8192000000 10797454992 11235188736 1858773056 18.493 98 24 48 0 1870988784 5484912 6730816
23:17:25 6997 8192000000 10762180896 11193675776 1836930992 18.316 99 20 40 1 1848529616 5973824 5624800
23:17:39 69103 8192000000 10740667568 11163934720 1700655040 17.191 91 29 56 0 1713518032 4690640 8172352
23:18:54 12007 8192000000 10744716576 11161538560 1746806592 17.575 95 21 42 1 1758937840 5409792 6721456
23:19:15 4728 8192000000 10760541184 11182653440 1807742240 18.077 98 28 56 1 1827185744 11707040 7736464
23:19:27 8671 8192000000 10766355152 11183685632 1820815376 18.184 99 26 53 0 1833871904 5874832 7181696
23:19:42 6246 8192000000 10737770016 11166769152 1828605680 18.248 100 27 54 3 1842146768 5616592 7924496
23:19:55 5049 8192000000 10739342432 11161214976 1817348256 18.156 99 25 50 3 1831416848 6923344 7145248
23:20:06 5764 8192000000 10710764704 11117821952 1741770032 17.533 96 27 54 0 1756078496 6123600 8184864
23:20:19 7556 8192000000 10708002416 11118317568 1741266304 17.529 96 31 61 1 1755107024 5317376 8523344
23:20:39 5866 8192000000 10722577856 11128360960 1735943344 17.485 96 36 72 0 1753065232 6754288 10367600
23:20:53 4417 8192000000 10727629184 11137925120 1792213296 17.950 99 41 82 1 1812080192 8394048 11472848
23:21:03 10651 8192000000 10707295952 11121147904 1712236112 17.287 95 27 53 3 1730250112 10422608 7591392
23:21:25 9119 8192000000 10711459248 11125972992 1780491632 17.854 99 19 38 1 1791978192 5916368 5570192
23:21:41 7938 8192000000 10725047856 11139444736 1780550144 17.854 98 33 66 0 1797493376 6748768 10194464
23:21:55 9049 8192000000 10744859040 11154251776 1803580048 18.043 99 35 70 1 1820285952 5920080 10785824
23:22:12 66452 8192000000 10754253872 11183181824 1823841872 18.209 99 31 62 3 1837296848 5249408 8205568
23:23:26 11570 8192000000 10761650192 11187978240 1830723568 18.265 99 22 43 1 1842473488 5834736 5915184
23:23:46 6339 8192000000 10768066176 11194277888 1835222992 18.302 99 43 86 2 1856137984 9005808 11909184
23:23:59 6251 8192000000 10772814032 11199406080 1856789232 18.477 100 31 63 4 1872130944 6732912 8608800
23:24:14 6669 8192000000 10787125616 11209207808 1865076400 18.544 100 30 60 2 1879795120 6546928 8171792
23:24:27 8530 8192000000 10795862288 11217035264 1872771520 18.607 100 33 66 2 1888349024 6696784 8880720
23:24:44 7986 8192000000 10792179024 11218173952 1873284544 18.611 100 33 66 1 1889247024 6671184 9291296
23:25:02 5556 8192000000 10803314576 11222798336 1876611840 18.638 100 40 80 1 1896101088 7495472 11993776
23:25:16 6215 8192000000 10794839760 11219730432 1875954608 18.632 100 26 52 1 1889297248 6158432 7184208
23:25:31 14106 8192000000 10787408848 11223437312 1880031152 18.665 100 24 48 3 1892389776 5589168 6769456
23:25:55 7455 8192000000 10805692816 11227271168 1883424400 18.693 100 18 35 2 1893674272 5015600 5234272
23:26:12 9317 8192000000 10807843568 11234648064 1886210096 18.715 100 17 34 0 1896618224 5604256 4803872
23:26:28 7455 8192000000 10805184848 11233406976 1885776912 18.712 100 14 26 1 1894472864 5176064 3519888
23:26:44 81811 8192000000 10828374352 11251818496 1899170608 18.820 100 36 73 0 1915740224 5534368 11035248
23:28:17 58871 8192000000 10846764928 11276173312 1922853408 19.010 100 31 62 1 1938740112 6750208 9136496
23:29:28 27272 8192000000 10871388304 11297284096 1934622128 19.104 100 44 88 0 1955729728 8894368 12213232
23:30:02 20646 8192000000 10872627168 11299237888 1942625328 19.168 100 37 74 1 1961968640 9262416 10080896
23:30:32 22462 8192000000 10889981200 11316457472 1952882784 19.249 100 43 86 0 1976967568 11761616 12323168
23:31:07 2921 8192000000 10898541776 11320844288 1960086928 19.307 100 49 99 2 1987288160 13132624 14068608
23:31:28 9120 8192000000 10897010864 11327868928 1964376992 19.341 100 47 94 0 1991768000 14152560 13238448
23:31:45 20632 8192000000 10906999920 11328122880 1967947632 19.369 100 56 108 2 1998240400 14605808 15686960
23:32:12 13220 8192000000 10908121200 11337428992 1970072864 19.386 100 48 91 1 1997940992 14858800 13009328
23:32:33 16433 8192000000 10909270016 11338530816 1973377920 19.412 100 50 100 1 2004617168 16115760 15123488
23:33:08 8435 8192000000 10924642688 11351412736 1979487616 19.461 100 51 102 2 2010209168 15253824 15467728
23:33:26 10465 8192000000 10931267120 11362615296 1983520912 19.493 100 55 106 3 2022646096 23022608 16102576
23:33:45 10487 8192000000 10919052320 11357368320 1985388544 19.507 100 51 102 2 2022265808 22194016 14683248
23:34:05 7443 8192000000 10934912672 11364139008 1989495744 19.540 100 49 98 1 2021015680 17457616 14062320
23:34:40 11049 8192000000 10940747664 11379884032 1997573232 19.604 100 46 88 1 2028698800 18190832 12934736
23:35:02 12522 8192000000 10947841328 11384066048 2003405088 19.650 100 47 92 0 2036202976 18711568 14086320
23:35:25 16846 8192000000 10953985376 11393527808 2012432304 19.721 100 52 104 1 2046969872 18487504 16050064
23:35:53 18136 8192000000 10952461632 11399991296 2017536064 19.761 100 49 95 1 2050846656 19097872 14212720
23:36:20 7060 8192000000 10975562080 11406278656 2025508160 19.823 100 52 105 3 2061187088 19975984 15702944
23:36:34 3611 8192000000 10992898112 11415834624 2031759904 19.872 100 59 118 0 2069950736 20179184 18011648
23:36:46 3297 8192000000 10988707264 11418112000 2028765376 19.849 100 73 147 1 2077532144 26782800 21983968
23:36:56 4463 8192000000 10986975824 11412258816 2030193952 19.860 100 76 152 2 2075481136 23452752 21834432
23:37:07 3495 8192000000 10986356208 11411644416 2029763344 19.857 100 74 147 0 2076202688 24370128 22069216
23:37:19 2937 8192000000 10980110800 11406102528 2020523376 19.784 100 73 146 0 2068775616 25180224 23072016
23:37:29 8687 8192000000 10980423376 11413557248 2026510320 19.831 100 68 136 0 2072883808 25833856 20539632
23:37:45 2527 8192000000 11003371760 11425218560 2037339728 19.916 100 85 169 2 2088932064 26306832 25285504
23:37:55 5613 8192000000 10982045216 11407409152 2018829296 19.771 100 66 132 0 2065315792 26621920 19864576
23:38:08 7750 8192000000 10972457776 11400695808 2000347664 19.625 99 72 143 1 2049277664 27114752 21815248
23:38:23 10745 8192000000 10974867312 11398365184 1994651504 19.581 99 67 134 1 2043567696 28160832 20755360
23:38:42 17535 8192000000 10977464592 11411062784 2011375504 19.712 100 58 116 2 2062796528 32632848 18788176
23:39:09 5372 8192000000 10984001472 11417124864 2016251216 19.751 100 63 124 3 2069081712 32360992 20469504
23:39:24 4306 8192000000 10992953408 11424808960 2024251264 19.814 100 71 142 3 2080270016 33991072 22027680
23:39:36 13604 8192000000 10989748752 11426463744 2010860944 19.708 99 69 138 0 2068749168 36611584 21276640
23:40:03 1993 8192000000 10997837232 11425746944 2021042704 19.788 100 73 147 2 2081321920 37419680 22859536
23:40:16 1683 8192000000 10968230960 11394293760 1959934976 19.306 97 80 158 0 2022956304 38461952 24559376
23:40:26 4505 8192000000 10958493888 11378909184 1980702256 19.470 99 78 156 0 2040161088 35743504 23715328
23:40:39 2727 8192000000 10973737088 11390689280 1983951248 19.496 99 79 159 0 2037572176 30009136 23611792
23:40:47 1208 8192000000 10973401264 11391762432 1987079264 19.521 99 85 170 0 2043708368 30911664 25717440
23:40:56 3543 8192000000 10975934464 11398799360 2007530432 19.682 100 80 158 1 2061554720 30759216 23265072
23:41:08 2039 8192000000 10996293664 11415498752 2021701056 19.794 100 86 167 0 2078746544 30992656 26052832
23:41:17 4064 8192000000 10991948608 11409580032 2014391744 19.736 100 86 168 0 2072096320 32186752 25517824
23:41:30 4016 8192000000 10989422800 11410915328 2016854384 19.755 100 75 151 1 2073812416 34135264 22822768
23:41:41 3948 8192000000 10993074976 11415896064 2018729040 19.770 100 82 161 1 2075965664 33308640 23927984
23:41:53 2599 8192000000 10985398336 11410288640 2003402400 19.650 99 78 155 3 2059527552 32204448 23920704
23:42:02 7861 8192000000 10989440096 11417600000 2019442992 19.776 100 76 152 3 2076665824 33908256 23314576
23:42:19 4667 8192000000 10990003488 11420483584 2021524816 19.792 100 71 142 0 2076803408 33152736 22125856
23:42:31 3687 8192000000 10994911616 11422961664 2020926464 19.787 100 71 142 2 2076075024 33369168 21779392
23:42:42 3894 8192000000 10992347824 11419242496 2017778144 19.763 100 84 168 1 2078787264 34409360 26599760
23:42:55 4819 8192000000 10975922256 11404574720 2005633904 19.667 100 73 147 0 2062153008 34261472 22257632
23:43:11 3122 8192000000 10999245936 11420340224 2016616800 19.754 100 82 164 0 2078151056 35935184 25599072
23:43:22 4367 8192000000 10932651184 11349417984 1929572560 19.063 97 72 145 1 1987830944 36282016 21976368
23:43:35 2909 8192000000 10953208336 11369885696 1972971504 19.409 99 88 176 1 2036714848 36894624 26848720
23:43:45 4043 8192000000 10973920736 11396616192 1996650160 19.596 100 76 151 1 2058232320 38343056 23239104
23:43:56 3119 8192000000 10975649392 11394600960 1996185840 19.593 100 80 160 1 2059599440 38745280 24668320
23:44:06 2533 8192000000 10975733040 11389968384 1985997024 19.512 99 92 183 0 2050119136 35574848 28547264
23:44:15 7070 8192000000 10951773472 11391598592 1975222048 19.427 99 60 118 0 2031751328 37504416 19024864
23:44:29 5084 8192000000 10965567184 11392991232 1991571440 19.556 100 57 111 1 2042156816 33237248 17348128
23:44:45 3330 8192000000 10966254384 11389583360 1975303536 19.427 99 71 142 2 2032920880 35453664 22163680
23:44:55 15065 8192000000 10946312224 11382427648 1946497440 19.199 98 41 81 3 1998392192 38214256 13680496
23:45:18 5889 8192000000 10922075632 11360071680 1940372240 19.150 99 54 108 0 1993852176 35945200 17534736
23:45:37 7782 8192000000 10909427168 11338067968 1919930656 18.986 98 55 110 3 1975862976 38034272 17898048
23:45:53 2071 8192000000 10936315488 11356999680 1947468256 19.206 100 75 151 0 2011011536 39795824 23747456
23:46:07 9360 8192000000 10918041488 11350708224 1943847872 19.177 100 52 104 1 2003039248 41228992 17962384
23:46:25 3946 8192000000 10936503776 11368452096 1964344864 19.341 100 67 131 0 2025498768 39897568 21256336
23:46:37 7444 8192000000 10939508080 11377561600 1968789696 19.376 100 56 113 1 2027811984 40268416 18753872
23:46:53 11261 8192000000 10924235248 11365261312 1954847952 19.265 100 51 99 4 2011779440 40087008 16844480
23:47:19 7125 8192000000 10927426400 11360731136 1942867328 19.170 99 46 92 0 1998017424 39021984 16128112
23:47:34 18349 8192000000 10893965680 11342098432 1920977808 18.995 99 37 74 2 1971792688 38057584 12757296
23:48:01 15011 8192000000 10887680352 11323326464 1902176336 18.844 98 35 70 1 1938945808 25527664 11241808
23:48:28 12515 8192000000 10884932416 11338469376 1943290992 19.173 100 32 64 0 1984261472 29979648 10990832
23:48:47 19401 8192000000 10886853712 11344154624 1944452160 19.182 100 23 46 1 1976668128 24106928 8109040
23:49:17 25381 8192000000 10882345088 11332108288 1895872400 18.793 98 19 37 0 1938819392 35863952 7083040
23:49:51 27543 8192000000 10848688736 11301863424 1875673824 18.630 98 15 30 0 1902762336 21729360 5359152
23:50:26 39153 8192000000 10842912752 11303358464 1874125488 18.618 98 11 22 0 1895925152 18645056 3154608
23:51:14 24011 8192000000 10845872480 11301806080 1898650512 18.815 99 29 58 1 1921641952 14251776 8739664
23:51:47 19808 8192000000 10865133152 11312533504 1911400848 18.918 99 23 47 2 1931941328 13901200 6639280
23:52:47 31561 8192000000 10848943232 11318259712 1906796112 18.881 99 6 12 0 1922277376 13695536 1785728
23:53:25 56477 8192000000 10850808336 11294425088 1887674784 18.727 98 34 68 3 1908281856 9511312 11095760
23:55:04 143271 8192000000 10856225248 11309248512 1850926160 18.430 96 27 51 4 1868333280 9957232 7449888
23:57:46 50611 8192000000 10880067264 11337596928 1954475312 19.262 100 26 50 1 1970768080 9470736 6822032
23:58:57 41412 8192000000 10896120416 11339812864 1959690464 19.304 100 30 61 0 1978200816 9845408 8664944
23:59:48 1412 8192000000 10907699696 11335618560 1958367472 19.293 100 79 154 0 1990775824 9929520 22478832
23:59:57 9647 8192000000 10920738352 11349843968 1964966016 19.345 100 57 112 0 1993351680 13132448 15253216
00:00:12 35763 8192000000 10880835168 11343056896 1947489904 19.206 99 30 60 3 1968055680 12002352 8563424
00:01:01 25701 8192000000 10911188192 11360337920 1969646128 19.383 100 41 78 2 1993007184 11717248 11643808
00:01:37 36190 8192000000 10893412320 11365781504 1966334208 19.356 100 16 32 1 1983792416 13307808 4150400
00:02:41 68395 8192000000 10913514976 11367596032 1953707424 19.256 99 21 42 0 1973953760 14278272 5968064
00:03:57 55416 8192000000 10881830304 11353432064 1949146672 19.220 99 16 32 1 1965476096 11458128 4871296
00:04:58 34275 8192000000 10876976032 11346456576 1946882224 19.202 99 11 22 0 1957053344 7559056 2612064
00:05:39 11429 8192000000 10888725728 11349184512 1965402240 19.349 100 18 36 1 1978617840 7442416 5773184
00:06:04 32856 8192000000 10890009248 11359100928 1954429184 19.262 99 20 40 1 1967187184 7175104 5582896
00:07:05 78969 8192000000 10894397680 11360796672 1971888784 19.400 100 22 44 0 1985153168 7465520 5798864
00:08:31 53295 8192000000 10880359232 11357876224 1972972288 19.409 100 19 38 0 1987029584 8753552 5303744
00:09:35 30301 8192000000 10870534256 11335868416 1918050784 18.971 97 21 40 1 1929928960 6452160 5426016
00:10:12 84442 8192000000 10882527584 11357933568 1926073664 19.035 98 13 26 0 1937760992 7616832 4070496
00:12:16 52702 8192000000 10883573616 11345010688 1933781120 19.097 98 19 36 1 1947932672 9358448 4793104
00:13:16 26197 8192000000 10903197008 11365793792 1958532064 19.294 99 19 38 1 1975180752 11376752 5271936
00:13:59 38083 8192000000 10919401328 11377926144 1966009856 19.354 99 30 60 6 1990374656 15571888 8792912
00:15:06 58737 8192000000 10902459776 11374968832 1949892160 19.226 99 17 34 1 1974365072 19268368 5204544
00:16:11 12278 8192000000 10938320048 11368513536 1959456000 19.302 99 52 104 3 1986414816 11213584 15745232
00:16:32 17543 8192000000 10889272240 11340988416 1915879648 18.954 97 41 81 2 1937399136 9650192 11869296
00:17:02 88617 8192000000 10888234752 11350261760 1942750832 19.169 99 22 44 1 1958734064 9682768 6300464
00:18:41 26445 8192000000 10898883312 11346075648 1949873808 19.225 99 28 57 0 1967722576 9731664 8117104
00:19:15 27129 8192000000 10912607584 11358412800 1954791344 19.265 99 35 70 0 1978116912 12699952 10625616
00:19:52 27221 8192000000 10904287552 11350380544 1926441536 19.038 98 27 54 0 1946680368 12885360 7353472
00:20:26 50364 8192000000 10885484704 11353694208 1919279104 18.981 98 30 59 1 1940746048 13191824 8275120
00:21:26 21971 8192000000 10884587120 11337138176 1928742912 19.057 98 33 66 1 1946976224 9285568 8947744
00:21:57 62078 8192000000 10878732736 11335159808 1875979536 18.633 96 29 58 2 1895171744 11368432 7823776
00:23:05 78073 8192000000 10869234592 11336978432 1897111472 18.803 97 25 50 0 1917613024 13523152 6978400
00:24:31 91013 8192000000 10858132192 11318374400 1903086352 18.851 98 15 30 0 1919544192 12539040 3918800
00:26:28 55624 8192000000 10880185104 11353440256 1949720192 19.224 100 16 32 0 1970964432 16769984 4474256
00:27:30 33338 8192000000 10884773312 11338203136 1901796336 18.841 97 21 42 0 1922330880 14487696 6046848
00:28:27 39011 8192000000 10846644992 11326435328 1913660832 18.936 99 13 26 2 1938500256 21355232 3484192
00:30:28 51008 8192000000 10813681120 11279204352 1801427264 18.026 93 14 27 0 1818037552 12617584 3992704
00:31:33 50636 8192000000 10840736480 11297910784 1828866448 18.250 95 13 26 1 1842406432 10047872 3492112
00:32:34 69579 8192000000 10858865184 11309211648 1852246192 18.440 96 28 56 1 1875705200 15541664 7917344
00:34:03 45907 8192000000 10843350096 11298660352 1845431568 18.385 97 21 42 3 1869097088 17564672 6100848
00:34:56 22046 8192000000 10878402416 11319496704 1922289232 19.005 100 57 112 4 1963689568 24425872 16974464
00:35:29 60454 8192000000 10829521520 11291275264 1856175664 18.472 96 28 56 0 1888703040 24187264 8340112
00:36:36 70672 8192000000 10838518224 11312820224 1838361456 18.327 96 12 24 2 1870671904 28615472 3694976
00:37:54 53355 8192000000 10838553360 11314765824 1871228864 18.594 98 26 52 0 1908329152 29593840 7506448
00:38:56 67896 8192000000 10878510256 11345530880 1922679664 19.008 100 12 24 0 1959867456 33788896 3398896
00:40:10 38407 8192000000 10883140976 11347193856 1934304624 19.101 100 23 46 2 1971876720 31231728 6340368
00:42:22 53385 8192000000 10869072368 11326119936 1881978752 18.681 97 12 24 0 1899936544 14583712 3374080
00:43:22 88076 8192000000 10876457312 11335852032 1890952640 18.753 97 26 51 1 1911387152 13647232 6787280
00:44:58 111604 8192000000 10883071056 11356528640 1901693824 18.840 97 26 48 1 1928985216 20206304 7085088
00:47:33 85203 8192000000 10886413072 11364868096 1938401104 19.134 99 16 32 0 1959197440 16255648 4540688
00:50:13 50152 8192000000 10873266880 11349282816 1943337072 19.173 99 10 20 0 1952511424 6671136 2503216
00:51:10 34769 8192000000 10874345648 11348733952 1958001168 19.290 100 15 30 1 1969090896 6940272 4149456
00:51:51 40548 8192000000 10891399984 11367419904 1966221968 19.355 100 18 36 0 1985776912 14965408 4589536
00:53:19 57103 8192000000 10884280400 11365163008 1969165024 19.379 100 12 24 0 1982208352 9528528 3514800
00:54:42 57112 8192000000 10889709312 11359473664 1951683456 19.240 99 15 29 0 1962084112 6339440 4061216
00:55:54 74697 8192000000 10891324864 11367002112 1960861456 19.313 99 18 36 0 1975143904 9140208 5142240
00:57:53 58991 8192000000 10892988800 11364044800 1935235088 19.109 98 7 14 0 1944383472 6841888 2306496
00:59:08 97108 8192000000 10920491088 11393028096 1964034400 19.338 99 15 30 0 1982480800 14258240 4188160
01:00:51 45948 8192000000 10923023600 11394379776 1962823328 19.328 98 17 34 0 1980320432 12699568 4797536
01:01:45 79007 8192000000 10904214768 11369807872 1915335824 18.949 96 16 32 0 1933816928 14519312 3961792
01:03:13 56311 8192000000 10922791520 11383529472 1980490208 19.469 100 17 34 1 1994022016 8570480 4961328
01:04:16 65582 8192000000 10895630992 11381436416 1928789968 19.057 97 24 48 1 1946976720 11286896 6899856
01:05:29 39817 8192000000 10931379696 11386720256 1987574864 19.525 100 33 64 1 2005566032 9274432 8716736
01:06:19 49557 8192000000 10925359456 11385040896 1976563424 19.437 99 37 74 2 1996873232 10054432 10255376
01:07:24 86327 8192000000 10896865216 11371675648 1930843024 19.074 97 13 26 0 1945793248 11603312 3346912
01:08:57 33505 8192000000 10921874784 11376205824 1931742944 19.081 97 37 74 2 1951038112 8906368 10388800
01:10:19 37394 8192000000 10918187504 11361988608 1934744128 19.105 98 29 54 2 1952456048 9644304 8067616
01:11:07 54304 8192000000 10880180464 11356192768 1939540000 19.143 99 22 44 1 1957437104 11449680 6447424
01:12:08 134185 8192000000 10887641504 11350347776 1945264240 19.189 99 26 50 1 1960993840 7843360 7886240
01:14:29 65699 8192000000 10910724208 11376844800 1971057712 19.394 100 23 46 0 1992925776 15584896 6283168
01:15:51 56523 8192000000 10889806208 11375808512 1956881392 19.281 99 9 18 1 1978498848 18858624 2758832
01:16:54 37723 8192000000 10881458800 11359809536 1906340544 18.877 97 7 14 0 1926487168 18090688 2055936
01:17:38 62928 8192000000 10886940080 11357736960 1915087040 18.947 98 12 24 0 1939154544 20511488 3556016
01:18:48 80688 8192000000 10864607904 11341910016 1892986592 18.770 97 16 32 0 1917201184 19634224 4580368
01:21:08 34352 8192000000 10843884032 11317776384 1853654496 18.452 95 16 32 1 1866482288 8152528 4675264
01:21:49 92098 8192000000 10840111264 11303669760 1761776528 17.699 91 15 30 0 1775260272 8501744 4982000
01:23:47 47596 8192000000 10867246160 11312455680 1849510992 18.418 96 27 54 1 1866073856 8782864 7780000
01:24:50 45955 8192000000 10841021888 11300237312 1864452656 18.539 97 25 49 0 1886307808 14482288 7372864
01:25:49 62601 8192000000 10863904624 11324039168 1905332992 18.869 99 22 44 1 1928340784 16298608 6709184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-01-2021 01:28:35 to 24-01-2021 01:29:06.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-01-2021 01:29:06 to 24-01-2021 01:29:08.

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          243654
MON$OLDEST_ACTIVE               244831
MON$OLDEST_SNAPSHOT             244831
MON$NEXT_TRANSACTION            244831
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                       2022144
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:361: 
:362: mscs-test-161.budzdorov.ru    Sun Jan 24 01:27:22 2021
:363:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:364: 
:365: 
:366: mscs-test-161.budzdorov.ru    Sun Jan 24 01:27:33 2021
:367:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:368: 
:369: 
:370: mscs-test-161.budzdorov.ru    Sun Jan 24 01:27:33 2021
:371:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:372: 
--- end of diff output ---

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

24.01.21 01:29:09. 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-24 01:29:12 No severe PSQL-related problems occured
24.01.21 01:29:13. End of report.