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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-08 01:27:17
DTS_END                         2021-03-08 01:27:17.9080
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55212
TRN_ID                          246708
ATT_ID                          680
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: 8898.83 21584 1067859
customer order: creation 178.69 343 21443
customer order: refuse 14.88 348 1786
order to supplier: creation 47.09 1252 5651
order to supplier: removal 3.27 98610 392
invoice (draft): creation 48.08 3458 5769
invoice (draft): removal 49.22 814 5906
invoice accept: apply 42.95 18395 5154
invoice accept: cancel 44.30 810 5316
customer reserve: creation 3828.75 189 459450
customer reserve: removal 4336.97 57 520436
realization accept: apply 86.38 176 10366
realization accept: cancel 84.05 117 10086
payment from customer: creation 61.50 126 7380
payment from customer: removal 5.94 75 713
payment to supplier: creation 50.28 157 6034
payment to supplier: removal 3.93 89 471
service: total inventory turnovers 4.92 928 590
service: total monetary turnovers 6.86 22 823
service: aggregate perf. data 0.74 22268 89
service: refresh index statistics 0.03 283450 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5277
TEST_TIME 2 2819
TEST_TIME 3 2679
TEST_TIME 4 4367
TEST_TIME 5 4274
TEST_TIME 6 4697
TEST_TIME 7 5282
TEST_TIME 8 6075
TEST_TIME 9 6613
TEST_TIME 10 6532
TEST_TIME 11 6530
TEST_TIME 12 6702
TEST_TIME 13 6848
TEST_TIME 14 6960
TEST_TIME 15 7228
TEST_TIME 16 7667
TEST_TIME 17 7656
TEST_TIME 18 7764
TEST_TIME 19 8142
TEST_TIME 20 8559
TEST_TIME 21 8952
TEST_TIME 22 8855
TEST_TIME 23 9721
TEST_TIME 24 9656
TEST_TIME 25 9513
TEST_TIME 26 10579
TEST_TIME 27 10395
TEST_TIME 28 10312
TEST_TIME 29 10224
TEST_TIME 30 10094
TEST_TIME 31 10013
TEST_TIME 32 9789
TEST_TIME 33 9644
TEST_TIME 34 9496
TEST_TIME 35 9678
TEST_TIME 36 9641
TEST_TIME 37 9523
TEST_TIME 38 9438
TEST_TIME 39 9408
TEST_TIME 40 9335
TEST_TIME 41 9298
TEST_TIME 42 9188
TEST_TIME 43 9343
TEST_TIME 44 9433
TEST_TIME 45 9452
TEST_TIME 46 9452
TEST_TIME 47 9451
TEST_TIME 48 9411
TEST_TIME 49 9402
TEST_TIME 50 9367
TEST_TIME 51 9431
TEST_TIME 52 9420
TEST_TIME 53 9397
TEST_TIME 54 9323
TEST_TIME 55 9259
TEST_TIME 56 9227
TEST_TIME 57 9144
TEST_TIME 58 9116
TEST_TIME 59 9024
TEST_TIME 60 9079
TEST_TIME 61 8999
TEST_TIME 62 9009
TEST_TIME 63 9105
TEST_TIME 64 9147
TEST_TIME 65 9134
TEST_TIME 66 9069
TEST_TIME 67 8993
TEST_TIME 68 9289
TEST_TIME 69 9228
TEST_TIME 70 9227
TEST_TIME 71 9187
TEST_TIME 72 9318
TEST_TIME 73 9285
TEST_TIME 74 9255
TEST_TIME 75 9288
TEST_TIME 76 9273
TEST_TIME 77 9217
TEST_TIME 78 9167
TEST_TIME 79 9167
TEST_TIME 80 9092
TEST_TIME 81 9146
TEST_TIME 82 9072
TEST_TIME 83 9099
TEST_TIME 84 9079
TEST_TIME 85 8990
TEST_TIME 86 8965
TEST_TIME 87 8981
TEST_TIME 88 9008
TEST_TIME 89 9016
TEST_TIME 90 8986
TEST_TIME 91 9013
TEST_TIME 92 9034
TEST_TIME 93 9084
TEST_TIME 94 9063
TEST_TIME 95 9062
TEST_TIME 96 9109
TEST_TIME 97 9151
TEST_TIME 98 9142
TEST_TIME 99 9102
TEST_TIME 100 9189
TEST_TIME 101 9159
TEST_TIME 102 9138
TEST_TIME 103 9067
TEST_TIME 104 9029
TEST_TIME 105 9017
TEST_TIME 106 8978
TEST_TIME 107 8933
TEST_TIME 108 8893
TEST_TIME 109 8903
TEST_TIME 110 8875
TEST_TIME 111 8869
TEST_TIME 112 8897
TEST_TIME 113 8900
TEST_TIME 114 8945
TEST_TIME 115 8915
TEST_TIME 116 8934
TEST_TIME 117 8931
TEST_TIME 118 8931
TEST_TIME 119 8960
TEST_TIME 120 8901

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2021 01:28:05 to 08-03-2021 01:28:08.

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 1495593 1495593 0 0.00 0 24501 7 0 0
doc_list_biud 1495593 1495593 0 0.00 0 38471 26 0 0
sp_add_invoice_to_stock 5259 5154 105 1.99 41 179440 18395 0 105
sp_cancel_adding_invoice 5316 5316 0 0.00 6 48359 810 0 0
sp_cancel_client_order 1786 1786 0 0.00 4 6530 348 0 0
sp_cancel_customer_reserve 520436 520436 0 0.00 1 36600 58 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 2703 75 0 0
sp_cancel_pay_to_supplier 471 471 0 0.00 3 5291 89 0 0
sp_cancel_supplier_invoice 5916 5906 10 0.16 2 38488 814 0 10
sp_cancel_supplier_order 392 392 0 0.00 5 1019424 98611 0 0
sp_cancel_write_off 10086 10086 0 0.00 1 21895 118 0 0
sp_client_order 21443 21443 0 0.00 3 14404 343 0 0
sp_customer_reserve 459450 459450 0 0.00 0 54470 190 0 0
sp_fill_shopping_cart 32858 32858 0 0.00 1 17960 39 0 0
sp_fill_shopping_cart_clo_res 459443 459443 0 0.00 0 16689 15 0 0
sp_get_clo_for_invoice 5146 5146 0 0.00 0 32028 306 0 0
sp_kill_cost_storno 16586 16586 0 0.00 0 13105 56 0 0
sp_kill_qstorno_ret_qs2qd 1057256 1057256 0 0.00 0 38468 32 0 0
sp_kill_qty_storno 559434 559434 0 0.00 0 38470 68 0 0
sp_lock_selected_doc 21410 21410 0 0.00 0 8579 6 0 0
sp_make_cost_storno 28926 28926 0 0.00 0 19807 63 0 0
sp_multiply_rows_for_pdistr 28926 28926 0 0.00 0 14477 31 0 0
sp_multiply_rows_for_qdistr 21443 21443 0 0.00 0 10073 157 0 0
sp_pay_from_customer 7380 7380 0 0.00 4 18198 126 0 0
sp_pay_to_supplier 6034 6034 0 0.00 5 19820 157 0 0
sp_payment_common 13414 13414 0 0.00 1 14368 44 0 0
sp_qd_handle_on_cancel_clo 1786 1786 0 0.00 0 6525 309 0 0
sp_qd_handle_on_invoice_upd_sts 10462 10462 0 0.00 0 17443 314 0 0
sp_qd_handle_on_reserve_upd_sts 10366 10366 0 0.00 0 15083 51 0 0
sp_reserve_write_off 10366 10366 0 0.00 6 18194 177 0 0
sp_supplier_invoice 5769 5769 0 0.00 7 96389 3458 0 0
sp_supplier_order 5651 5651 0 0.00 5 32447 1253 0 0
srv_aggregate_perf_data 89 89 0 0.00 3065 190727 22268 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1403 145993 32852 0 0
srv_find_qd_qs_mism 1020219 1020219 0 0.00 0 24501 7 0 0
srv_make_invnt_saldo 590 590 0 0.00 41 22965 928 0 0
srv_make_money_saldo 823 823 0 0.00 1 593 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 125441 426586 283451 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 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 5154 5154 0 0.00 0 16878 169 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 3977 88 0 0
t$perf-norm:sp_cancel_client_order 1786 1786 0 0.00 0 4136 14 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 2162 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 3689 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 471 471 0 0.00 0 752 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 5359 26 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 37853 1721 0 0
t$perf-norm:sp_cancel_write_off 1026 1026 0 0.00 0 8540 21 0 0
t$perf-norm:sp_client_order 21443 21443 0 0.00 0 19344 19 0 0
t$perf-norm:sp_customer_reserve 1072 1072 0 0.00 0 2471 5 0 0
t$perf-norm:sp_pay_from_customer 7380 7380 0 0.00 0 5057 8 0 0
t$perf-norm:sp_pay_to_supplier 6034 6034 0 0.00 0 5583 11 0 0
t$perf-norm:sp_reserve_write_off 10366 10366 0 0.00 0 11655 10 0 0
t$perf-norm:sp_supplier_invoice 5769 5769 0 0.00 0 6648 18 0 0
t$perf-norm:sp_supplier_order 5651 5651 0 0.00 0 3560 14 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 121 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 489 4 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 2845 28 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 1231 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 13 6 0 0
v_add_invoice_to_stock 10502 10292 210 1.99 0 12172 16 0 210
v_all_customers 39106 39106 0 0.00 0 20 1 0 0
v_all_suppliers 31070 31070 0 0.00 0 21 1 0 0
v_all_wares 42886 42886 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 563 6 0 0
v_cancel_client_order 3572 3572 0 0.00 0 3634 7 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 1486 6 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 3703 11 0 0
v_cancel_payment_to_supplier 942 942 0 0.00 0 727 5 0 0
v_cancel_supplier_invoice 832 812 20 2.40 0 3799 17 0 20
v_cancel_supplier_order 784 784 0 0.00 0 276 3 0 0
v_cancel_write_off 2052 2052 0 0.00 0 2897 12 0 0
v_max_id_clo_ord 5649 5649 0 0.00 0 1105 1 0 0
v_max_id_clo_res 1072 1072 0 0.00 0 2106 10 0 0
v_max_id_ord_sup 5766 5766 0 0.00 0 10207 9 0 0
v_max_non_paid_invoice 1914 1914 0 0.00 0 316 2 0 0
v_max_non_paid_realizn 3893 3893 0 0.00 0 5684 6 0 0
v_min_id_clo_ord 5649 5649 0 0.00 0 4894 6 0 0
v_min_id_clo_res 1072 1072 0 0.00 0 6087 9 0 0
v_min_id_ord_sup 5766 5766 0 0.00 0 8961 7 0 0
v_min_non_paid_invoice 6034 6034 0 0.00 0 14328 38 0 0
v_min_non_paid_realizn 7380 7380 0 0.00 0 14331 28 0 0
v_our_firm 10754 10754 0 0.00 0 12 1 0 0
v_reserve_write_off 20732 20732 0 0.00 0 3667 6 0 0
x_lock_depdocs_on_canc_invoice 10816 10816 0 0.00 0 24833 129 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 11480 353 0 0
x_make_qstorno_1000_1200 5651 5651 0 0.00 2 32438 1177 0 0
x_make_qstorno_1200_2000 5769 5769 0 0.00 2 93682 3307 0 0
x_make_qstorno_2100_3300 459450 459450 0 0.00 0 51759 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2021 01:28:09 to 08-03-2021 01:28:13.

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:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:28 8537 8192000000 10161499408 10459201536 900239792 9.901 72 55 112 0 921290976 2652720 18398464
22:57:44 23801 8192000000 10307340448 10622791680 1341110656 14.067 100 76 151 1 1370850272 4284640 25454976
22:58:25 27810 8192000000 10364842656 10687639552 1424029328 14.808 100 86 172 0 1457872032 6094544 27748160
22:59:01 17223 8192000000 10394718480 10719952896 1453015984 15.064 100 91 182 1 1490499136 7015856 30467296
22:59:34 20937 8192000000 10420936800 10748784640 1470947328 15.222 100 83 166 0 1505547280 7623872 26976080
23:00:08 25480 8192000000 10432712256 10765881344 1490107600 15.390 100 91 182 0 1527799152 8417184 29274368
23:00:51 18694 8192000000 10458186672 10793439232 1510573664 15.568 100 85 170 0 1546755872 8911920 27270288
23:01:18 16777 8192000000 10469658720 10807283712 1520403792 15.654 100 75 150 3 1552915104 9285264 23226048
23:01:49 12513 8192000000 10494190592 10845442048 1557463104 15.974 100 77 154 1 1590286208 9102768 23720336
23:02:10 15331 8192000000 10534564800 10887364608 1585159712 16.212 100 76 152 3 1618036784 10013536 22863536
23:02:38 12337 8192000000 10567731840 10922582016 1619827216 16.508 100 80 160 0 1654432128 10486608 24118304
23:03:01 15818 8192000000 10585600192 10943270912 1642336928 16.700 100 84 168 1 1679386848 11863568 25186352
23:03:25 9634 8192000000 10606727024 10965356544 1657261728 16.826 100 81 162 1 1692985808 12249184 23474896
23:03:43 10974 8192000000 10617174304 10982555648 1675365824 16.978 100 78 156 3 1710671200 12736512 22568864
23:04:09 11067 8192000000 10629939440 10999459840 1697096032 17.161 100 80 158 3 1732830048 12422192 23311824
23:04:28 8700 8192000000 10650752672 11025690624 1710673648 17.274 100 72 143 3 1743998976 12815072 20510256
23:04:44 7354 8192000000 10661499232 11035090944 1721515984 17.365 100 79 158 0 1756974288 12594512 22863792
23:04:59 6625 8192000000 10681176384 11051114496 1734707568 17.475 100 85 170 1 1772449584 13387168 24354848
23:05:14 5867 8192000000 10678734816 11053584384 1750452192 17.605 100 89 177 1 1788105728 12157952 25495584
23:05:26 5054 8192000000 10689276480 11066748928 1753769568 17.633 100 78 154 1 1788935280 12710016 22455696
23:05:39 5128 8192000000 10705804624 11085078528 1767289920 17.745 100 73 145 1 1799281952 12044576 19947456
23:05:51 5057 8192000000 10717182704 11096285184 1780310576 17.852 100 89 178 0 1817978752 12904272 24763904
23:06:03 3984 8192000000 10726939040 11104788480 1790942432 17.940 100 87 174 3 1828326880 12867776 24516672
23:06:13 4157 8192000000 10737249056 11119783936 1798376768 18.001 100 89 177 1 1835868736 13140080 24351888
23:06:24 3398 8192000000 10748141424 11125997568 1801359856 18.025 100 89 176 1 1840338688 14632640 24346192
23:06:34 2586 8192000000 10748551360 11127459840 1805438224 18.059 100 88 177 0 1844321280 14629360 24253696
23:06:43 2606 8192000000 10746575648 11130638336 1813831376 18.127 100 85 171 1 1850854544 13821312 23201856
23:06:54 3736 8192000000 10751399152 11136327680 1811828880 18.111 100 79 158 3 1847097392 13315056 21953456
23:07:04 7055 8192000000 10756838208 11136479232 1819187968 18.171 100 75 146 3 1851654016 11656080 20809968
23:07:18 2216 8192000000 10773764416 11160272896 1836276864 18.310 100 88 177 0 1874331040 12519040 25535136
23:07:27 1829 8192000000 10787051136 11168677888 1841175888 18.350 100 96 192 3 1882930384 14422256 27332240
23:07:36 2371 8192000000 10782157920 11172028416 1844341168 18.376 100 89 179 0 1882338048 13211312 24785568
23:07:45 2162 8192000000 10792689936 11178889216 1849738736 18.420 100 93 185 0 1889357136 13844416 25773984
23:07:54 2902 8192000000 10791005552 11180290048 1858869856 18.494 100 97 194 1 1900315552 13895072 27550624
23:08:03 1651 8192000000 10799496480 11186970624 1860153648 18.505 100 90 185 0 1899877472 13771552 25952272
23:08:11 2369 8192000000 10804617408 11195277312 1868318528 18.571 100 94 188 1 1908224896 13052048 26854320
23:08:19 1211 8192000000 10809512656 11195928576 1870080128 18.585 100 90 180 2 1908787376 13586816 25120432
23:08:27 6166 8192000000 10807290560 11201060864 1868205296 18.570 100 91 182 3 1906770672 12759376 25806000
23:08:39 1448 8192000000 10820533248 11207933952 1873248448 18.611 100 93 188 0 1912992960 13059344 26685168
23:08:47 18139 8192000000 10788139472 11208785920 1872917408 18.608 100 71 142 1 1905496016 12712160 19866448
23:09:19 11978 8192000000 10808410896 11206008832 1871908192 18.600 100 56 111 0 1896413632 8831536 15673904
23:09:37 2639 8192000000 10822889712 11216588800 1884866688 18.704 100 89 177 2 1921064016 10754176 25443152
23:09:46 7990 8192000000 10825483696 11224805376 1888269872 18.732 100 82 162 1 1922876160 11336272 23270016
23:10:01 6491 8192000000 10796913952 11217469440 1882432816 18.685 100 50 100 0 1907780624 11310976 14036832
23:10:14 3643 8192000000 10795660256 11218984960 1881749616 18.679 100 41 81 2 1901629504 8159168 11720720
23:10:25 3863 8192000000 10808503920 11224981504 1889424800 18.741 100 48 96 1 1911295952 8851040 13020112
23:10:38 3036 8192000000 10804178640 11225575424 1887481888 18.725 100 42 84 2 1910639808 11833856 11324064
23:10:47 7831 8192000000 10792668576 11222560768 1891003584 18.754 100 26 53 0 1904676512 6445584 7227344
23:11:01 7986 8192000000 10811942064 11229700096 1891651536 18.759 100 22 44 0 1904185312 6181056 6352720
23:11:16 9148 8192000000 10801735424 11228299264 1892829280 18.769 100 26 53 0 1906442928 6069744 7543904
23:11:32 9310 8192000000 10813659600 11234205696 1895289040 18.788 100 24 48 1 1908739088 5841008 7609040
23:11:50 7353 8192000000 10798933232 11235987456 1896916288 18.801 100 20 40 0 1909272208 6873728 5482192
23:12:08 11813 8192000000 10798953936 11237249024 1898208272 18.812 100 19 38 0 1909635360 6263664 5163424
23:12:31 9743 8192000000 10809468096 11239825408 1899953904 18.826 100 28 56 2 1914842816 6935376 7953536
23:12:48 7907 8192000000 10802972000 11241123840 1903569344 18.855 100 24 48 1 1917282288 6706576 7006368
23:13:05 14527 8192000000 10821135344 11249430528 1907297184 18.885 100 22 44 2 1919604656 5928656 6378816
23:13:30 36970 8192000000 10835894032 11254988800 1906357040 18.877 100 18 36 1 1916560304 5205280 4997984
23:14:14 24187 8192000000 10860657872 11265740800 1916743184 18.961 100 62 125 1 1941201744 6133152 18325408
23:14:44 4780 8192000000 10824347248 11257999360 1909637728 18.904 100 32 65 0 1926772000 8200512 8933760
23:14:56 5889 8192000000 10819597056 11254931456 1912113840 18.924 100 34 69 1 1928735008 6346656 10274512
23:15:10 4697 8192000000 10825069760 11253342208 1893479648 18.774 99 44 88 1 1912852816 7406528 11966640
23:15:23 4051 8192000000 10829768816 11257978880 1911285136 18.917 100 38 76 0 1930589536 8318432 10985968
23:15:36 6604 8192000000 10823584848 11258789888 1909589696 18.903 100 29 58 2 1924462720 6760112 8112912
23:15:51 6217 8192000000 10831979088 11263012864 1911213408 18.916 100 23 44 2 1923607376 6260416 6133552
23:16:06 5634 8192000000 10829403168 11262435328 1912611728 18.928 100 30 60 2 1927926416 7411072 7903616
23:16:19 6600 8192000000 10818850704 11255488512 1910147488 18.908 100 27 54 2 1922293072 5054144 7091440
23:16:37 9013 8192000000 10823942240 11259224064 1910468752 18.910 100 31 62 2 1926174368 6607792 9097824
23:16:52 3619 8192000000 10826132720 11252817920 1903755408 18.856 100 41 82 1 1920319088 4891520 11672160
23:17:06 8001 8192000000 10792273712 11226505216 1855725936 18.469 98 18 36 2 1866928384 5579216 5623232
23:17:22 8719 8192000000 10787532816 11222958080 1837123744 18.317 97 14 28 3 1846251024 5373328 3753952
23:17:37 8360 8192000000 10783269344 11217444864 1856079312 18.471 99 15 30 0 1865692464 5291840 4321312
23:17:54 9642 8192000000 10764048320 11187625984 1802475504 18.034 96 13 26 1 1811618800 5591872 3551424
23:18:10 16086 8192000000 10726649040 11145596928 1644089776 16.714 88 32 65 0 1658125664 4559888 9476000
23:18:33 56539 8192000000 10710475808 11120300032 1694879056 17.142 93 19 38 0 1705856560 5238752 5738752
23:19:37 5402 8192000000 10711176816 11129925632 1786269808 17.901 99 33 66 0 1802948928 6812784 9866336
23:19:51 7728 8192000000 10736512832 11156672512 1812490128 18.116 99 42 83 1 1831399136 6209504 12699504
23:20:08 5464 8192000000 10742605936 11150819328 1773168304 17.793 97 31 62 2 1787844304 6182304 8493696
23:20:21 5593 8192000000 10736123536 11143192576 1781860592 17.865 98 34 69 2 1797588416 5639664 10088160
23:20:33 7345 8192000000 10722066416 11148648448 1814883952 18.136 100 29 58 1 1829064736 5879248 8301536
23:20:46 6320 8192000000 10687043472 11103150080 1767761280 17.749 99 26 51 0 1781392752 6453744 7177728
23:20:59 7079 8192000000 10682792672 11084107776 1716285056 17.321 96 27 54 2 1729077776 4981968 7810752
23:21:15 6680 8192000000 10693039920 11102146560 1741127488 17.528 98 19 38 2 1751563296 4796832 5638976
23:21:30 7371 8192000000 10708086192 11112439808 1756248464 17.653 98 35 68 3 1772730352 5392528 11089360
23:21:44 9124 8192000000 10731776464 11145129984 1802136768 18.031 100 25 50 0 1815891376 6509808 7244800
23:21:59 6181 8192000000 10730260576 11149385728 1801548080 18.027 99 26 51 2 1818759632 9748400 7463152
23:22:13 4546 8192000000 10708442304 11134537728 1807802176 18.078 99 26 50 3 1820895984 5539600 7554208
23:22:25 12020 8192000000 10737434576 11163787264 1824203568 18.212 100 20 39 3 1834938992 5057488 5677936
23:22:44 10449 8192000000 10746994288 11169730560 1832845648 18.283 100 22 44 2 1845236976 5253904 7137424
23:23:00 63794 8192000000 10726790000 11158208512 1823087024 18.203 99 30 61 1 1836450864 5419952 7943888
23:24:10 14354 8192000000 10766697824 11189276672 1848884704 18.413 100 25 49 1 1862754560 6320720 7549136
23:24:32 9566 8192000000 10777757744 11192418304 1852300880 18.441 100 30 59 1 1866480848 5838720 8341248
23:24:47 4056 8192000000 10776962064 11199471616 1853816368 18.453 100 35 68 1 1872277136 8205664 10255104
23:25:01 4997 8192000000 10776550944 11194236928 1853249168 18.449 100 24 48 1 1866707120 6317648 7140304
23:25:12 4099 8192000000 10780298288 11201433600 1856273728 18.473 100 31 62 3 1870830496 5526240 9030528
23:25:22 9187 8192000000 10781216640 11202789376 1859378208 18.498 100 23 46 2 1871633952 6172224 6083520
23:25:40 5514 8192000000 10777692304 11207561216 1861256240 18.513 100 22 45 3 1873371008 5878464 6236304
23:25:53 8120 8192000000 10779835088 11207028736 1867012096 18.560 100 35 69 1 1882026768 5353024 9661648
23:26:12 12047 8192000000 10775662416 11206025216 1865377120 18.547 100 17 34 3 1875706352 5933680 4395552
23:26:30 6809 8192000000 10784908208 11210981376 1864783184 18.542 100 20 40 1 1876498048 6094352 5620512
23:26:45 7679 8192000000 10778276720 11209056256 1866417360 18.555 100 28 56 1 1880446096 5716368 8312368
23:26:59 9584 8192000000 10795995568 11219853312 1877665872 18.646 100 28 56 0 1891873408 6067296 8140240
23:27:17 6048 8192000000 10811119200 11229040640 1885380848 18.709 100 29 60 1 1898458176 5189008 7888320
23:27:32 21402 8192000000 10824671584 11245252608 1895110496 18.787 100 39 76 1 1911960272 5290880 11558896
23:28:06 13185 8192000000 10826929328 11246489600 1902792240 18.849 100 36 72 0 1920083856 6177216 11114400
23:28:28 29902 8192000000 10854427088 11271716864 1917255648 18.965 100 42 83 0 1937680880 8122752 12302480
23:29:16 118315 8192000000 10866800224 11300343808 1936943072 19.122 100 53 104 1 1965899472 13548304 15408096
23:31:22 71449 8192000000 10865034816 11311017984 1932155168 19.084 100 22 44 2 1951585344 13068544 6361632
23:32:50 16325 8192000000 10882936480 11311845376 1944679488 19.184 100 53 106 3 1972995920 12453280 15863152
23:33:22 22076 8192000000 10899014992 11331235840 1956915984 19.282 100 50 100 1 1990138256 18941344 14280928
23:33:56 3345 8192000000 10919968896 11340562432 1965664048 19.351 100 76 152 2 2007833504 20083632 22085824
23:34:07 4456 8192000000 10907063216 11334975488 1966496112 19.358 100 59 118 1 2001317744 18447008 16374624
23:34:20 5097 8192000000 10901958688 11325976576 1955395424 19.269 100 67 132 1 1993875376 19396656 19083296
23:34:39 4338 8192000000 10914469984 11340038144 1963737968 19.336 100 62 123 1 2000992288 19579888 17674432
23:34:51 3671 8192000000 10917283376 11343142912 1968273376 19.372 100 65 130 0 2007713216 20903216 18536624
23:35:01 3509 8192000000 10933721872 11354300416 1975303776 19.427 100 72 142 2 2017885568 21729104 20852688
23:35:12 13969 8192000000 10924374928 11342815232 1967807408 19.368 100 76 152 2 2012912896 23099920 22005568
23:35:33 1401 8192000000 10931744288 11341217792 1968066720 19.370 100 90 176 2 2017201568 22299776 26835072
23:35:42 2353 8192000000 10919803472 11328028672 1954826240 19.265 99 90 179 1 2002961984 22087536 26048208
23:35:51 1950 8192000000 10929863280 11334516736 1957931248 19.290 99 91 183 1 2006661328 22241168 26488912
23:36:02 1741 8192000000 10932455696 11341365248 1969477856 19.381 100 87 172 1 2017482176 22508128 25496192
23:36:11 13384 8192000000 10926286864 11347546112 1973772336 19.415 100 77 153 1 2020635584 23678992 23184256
23:36:37 5509 8192000000 10922357024 11348008960 1968003456 19.370 100 65 129 3 2010335088 23933808 18397824
23:36:50 1652 8192000000 10945317920 11357200384 1976963200 19.441 100 80 161 2 2022978800 22245008 23770592
23:37:01 4728 8192000000 10924476832 11357593600 1974750448 19.423 100 52 104 0 2015880432 25630800 15499184
23:37:12 13598 8192000000 10912270144 11346141184 1966006048 19.354 100 55 109 1 2003338224 21236224 16095952
23:37:47 3354 8192000000 10921130576 11347906560 1968840448 19.376 100 63 127 3 2010433648 22698064 18895136
23:38:00 13360 8192000000 10912649840 11347615744 1947817760 19.209 99 56 111 1 1987973632 23676304 16479568
23:38:25 6566 8192000000 10931671552 11358326784 1970983376 19.393 100 51 102 0 2010938048 24957600 14997072
23:38:42 2961 8192000000 10927721408 11348611072 1967579616 19.366 100 68 133 2 2013713440 25950544 20183280
23:38:54 3380 8192000000 10922523760 11345469440 1966436144 19.357 100 68 136 1 2013075536 25524848 21114544
23:39:06 4271 8192000000 10926254640 11341160448 1944930640 19.186 99 70 141 0 1992934112 26846656 21156816
23:39:18 4519 8192000000 10906172880 11324424192 1947767552 19.209 99 80 160 1 1999893856 26827440 25298864
23:39:30 6408 8192000000 10922113136 11347161088 1964753264 19.344 100 60 118 2 2009089232 25841200 18494768
23:39:58 8567 8192000000 10917209120 11338592256 1950187904 19.228 99 64 128 0 1999069568 29155200 19726464
23:40:18 2898 8192000000 10942273920 11359879168 1969785072 19.384 100 82 160 3 2027186432 33801984 23599376
23:40:34 8982 8192000000 10936690176 11360423936 1959084496 19.299 99 59 115 1 2006806352 30188256 17533600
23:40:58 3089 8192000000 10930891184 11359223808 1969224912 19.379 100 62 126 0 2017597312 28698272 19674128
23:41:13 1947 8192000000 10918372464 11325698048 1941853488 19.162 99 91 179 4 1995979216 27002608 27123120
23:41:23 3589 8192000000 10917716736 11329146880 1927322608 19.045 99 77 152 1 1980322144 29149936 23849600
23:41:34 11993 8192000000 10897052800 11313741824 1925217616 19.029 99 70 140 1 1978066560 30639568 22209376
23:41:54 7734 8192000000 10934536992 11343360000 1955823376 19.273 100 87 169 2 2013508576 32415248 25269952
23:42:08 8422 8192000000 10933979296 11352424448 1961892400 19.321 100 70 138 2 2018001968 34625664 21483904
23:42:24 4136 8192000000 10929785376 11338149888 1947096992 19.203 100 72 145 4 2002806528 32790112 22919424
23:42:38 5119 8192000000 10925035504 11347968000 1956617776 19.279 100 66 132 4 2008801184 31755872 20427536
23:42:52 4155 8192000000 10930930800 11347984384 1946305120 19.197 99 74 148 2 2001683440 31692784 23685536
23:43:05 6785 8192000000 10930761488 11349483520 1947970416 19.210 99 70 140 0 2003229392 32662256 22596720
23:43:25 2791 8192000000 10924783456 11335974912 1943735808 19.177 100 71 142 3 2002500672 36131520 22633344
23:43:35 3318 8192000000 10925252480 11331047424 1913685360 18.936 98 80 157 0 1973235216 34838656 24711200
23:43:44 7170 8192000000 10906184288 11331813376 1917779616 18.969 99 59 118 1 1970266368 33906512 18580240
23:43:59 5711 8192000000 10891694368 11312001024 1907866304 18.890 98 64 123 2 1956976864 29980368 19130192
23:44:11 4001 8192000000 10905192928 11320225792 1934879616 19.106 100 70 139 2 1987969376 31394496 21695264
23:44:24 2535 8192000000 10912921328 11332706304 1939521520 19.143 100 64 126 1 1994231152 35154128 19555504
23:44:35 2333 8192000000 10915470960 11323965440 1930610336 19.072 100 88 178 0 1997100688 38178336 28312016
23:44:45 2446 8192000000 10929477312 11339735040 1944159712 19.180 100 84 168 2 2009776320 40060544 25556064
23:44:56 2080 8192000000 10925548272 11346415616 1948434784 19.214 100 69 138 3 2012304848 41646400 22223664
23:45:14 3785 8192000000 10930071408 11354271744 1934782992 19.105 99 63 126 1 1996864928 41665760 20416176
23:45:28 5593 8192000000 10920308512 11345698816 1945303616 19.189 100 63 126 0 2007676144 41693568 20678960
23:45:40 2386 8192000000 10928598928 11355521024 1952444160 19.246 100 60 120 0 2016074480 43758640 19871680
23:45:51 3457 8192000000 10932538512 11359330304 1955477136 19.270 100 70 140 1 2022819968 44617344 22725488
23:46:04 6412 8192000000 10932581312 11361390592 1950756368 19.233 100 49 98 1 2013728304 46422592 16549344
23:46:18 6873 8192000000 10933404480 11359875072 1949344320 19.221 100 54 108 2 2013373568 45716112 18313136
23:46:42 13707 8192000000 10914701504 11352928256 1928718912 19.057 99 39 78 1 1987207328 44719904 13768512
23:47:05 9023 8192000000 10908259040 11348156416 1939431312 19.142 100 37 73 0 1994865824 42528176 12906336
23:47:24 8899 8192000000 10920728896 11343880192 1921578656 18.999 99 52 105 0 1982762640 43675664 17508320
23:47:50 4324 8192000000 10927541200 11362701312 1951463952 19.238 100 63 126 2 2018494800 47099952 19930896
23:48:01 4035 8192000000 10930284672 11364794368 1958555168 19.295 100 55 110 1 2016825520 41016496 17253856
23:48:12 9000 8192000000 10920227584 11360960512 1953884000 19.257 100 52 104 3 2009499264 38249648 17365616
23:48:32 23492 8192000000 10902375280 11356340224 1930409360 19.070 99 28 56 2 1978718480 38573664 9735456
23:49:03 3541 8192000000 10900909856 11340627968 1908817088 18.897 98 41 80 1 1957901984 35252640 13832256
23:49:14 6282 8192000000 10917089376 11351519232 1942035040 19.163 100 48 95 1 1998614000 40987760 15591200
23:49:32 14199 8192000000 10918401408 11360788480 1945159248 19.188 100 30 60 1 1997846144 41400080 11286816
23:50:06 18949 8192000000 10885777168 11360296960 1925504288 19.031 99 26 52 0 1967680192 33462736 8713168
23:50:31 31191 8192000000 10895760960 11357937664 1944466080 19.182 100 22 44 2 1980798224 28796416 7535728
23:51:13 28492 8192000000 10890527280 11349110784 1931189808 19.076 99 16 32 0 1961559840 25215472 5154560
23:51:53 18028 8192000000 10888198464 11344097280 1917371760 18.966 99 17 33 2 1957731888 34271808 6088320
23:52:17 20687 8192000000 10917991440 11357548544 1939998224 19.147 100 33 66 0 1989046848 38087552 10961072
23:52:47 4248 8192000000 10939932352 11362144256 1942849584 19.169 99 85 169 3 2007425072 38270096 26305392
23:52:58 4878 8192000000 10935507376 11376238592 1961279280 19.316 100 62 122 1 2023163024 42528160 19355584
23:53:13 12778 8192000000 10881092608 11330768896 1927358416 19.046 99 30 60 1 1969719776 32527584 9833776
23:53:32 19964 8192000000 10886435264 11335028736 1919787536 18.985 99 17 34 1 1948211936 23277888 5146512
23:53:59 70973 8192000000 10873158416 11313856512 1928535936 19.055 99 40 78 0 1949897616 9075440 12286240
23:55:27 60422 8192000000 10887811536 11325456384 1928209232 19.053 99 28 57 1 1946815408 9423952 9182224
23:56:35 23957 8192000000 10890885232 11337023488 1949568768 19.223 100 34 70 1 1971666800 12391248 9706784
23:57:08 39621 8192000000 10882078144 11337461760 1935805632 19.113 99 18 33 1 1948929008 8616384 4506992
23:57:54 71654 8192000000 10881050704 11334721536 1890128240 18.747 96 20 40 0 1903072848 7871088 5073520
23:59:14 45503 8192000000 10878474336 11332886528 1923545504 19.015 98 12 24 1 1935800688 9233632 3021552
00:00:58 66961 8192000000 10876353744 11331362816 1902234912 18.844 97 14 28 0 1922692848 15837280 4620656
00:02:35 44379 8192000000 10873945088 11346673664 1957533312 19.286 100 14 28 1 1971065472 9672144 3860016
00:03:27 108914 8192000000 10884488784 11355250688 1965298224 19.348 100 25 50 1 1987280720 14738832 7243664
00:05:27 88150 8192000000 10889571648 11362672640 1949474800 19.222 99 12 24 1 1962781568 10218656 3088112
00:07:05 51457 8192000000 10906893248 11377258496 1977090192 19.442 100 23 46 1 1994704144 10883264 6730688
00:08:04 87109 8192000000 10920423808 11388661760 1948988400 19.218 98 19 37 1 1971898336 17428720 5481216
00:10:44 61105 8192000000 10913541520 11384229888 1988090304 19.529 100 13 26 3 2014172176 22062480 4019392
00:11:53 54510 8192000000 10941929072 11395911680 1995357472 19.586 100 33 64 1 2015934752 10824896 9752384
00:12:57 24261 8192000000 10951453136 11404296192 2006889824 19.677 100 45 90 2 2028338960 8418256 13030880
00:13:32 43128 8192000000 10949568768 11410632704 1987521008 19.524 99 30 60 0 2008885584 12811184 8553392
00:14:26 34816 8192000000 10910884640 11376345088 1941503680 19.159 97 22 44 1 1957806352 10163424 6139248
00:15:07 63252 8192000000 10923341344 11379023872 1969893632 19.385 99 19 38 1 1983570080 7941712 5734736
00:16:23 74693 8192000000 10924609040 11372531712 1972244928 19.403 99 30 60 0 1992035984 10813616 8977440
00:17:48 59257 8192000000 10917190400 11388256256 1958660432 19.295 98 22 44 1 1976706000 11936560 6109008
00:18:54 78370 8192000000 10908310992 11385937920 1932905024 19.090 97 10 20 0 1946964656 11127104 2932528
00:20:18 145993 8192000000 10862362304 11330297856 1871028048 18.593 94 16 32 1 1892045504 16685072 4332384
00:22:50 92791 8192000000 10879882864 11353026560 1862934512 18.527 94 20 39 0 1891249968 21973984 6341472
00:24:29 2469 8192000000 10896562688 11369353216 1955933104 19.274 100 22 44 0 1983956304 21992048 6031152
00:24:38 22673 8192000000 10903114272 11362258944 1964382224 19.341 100 20 40 1 1990278656 20398512 5497920
00:25:12 50852 8192000000 10819739568 11291496448 1824613952 18.215 93 10 20 1 1837417376 9977824 2825600
00:26:12 56167 8192000000 10842418704 11315294208 1893099376 18.771 98 10 20 1 1910361888 14395952 2866560
00:27:19 25612 8192000000 10847922720 11327016960 1922016208 19.003 100 11 23 0 1938907104 13928784 2962112
00:27:52 20717 8192000000 10845330096 11327803392 1913139376 18.932 99 13 26 0 1931194720 14269392 3785952
00:28:24 78385 8192000000 10874208128 11352346624 1907066976 18.883 98 24 49 0 1930436288 16658688 6710624
00:29:48 85519 8192000000 10902384144 11382530048 1957840608 19.289 100 12 24 0 1978100880 17262864 2997408
00:31:20 55726 8192000000 10884739504 11356176384 1881157792 18.674 95 16 32 0 1891613840 6393648 4062400
00:32:25 39745 8192000000 10879008816 11340275712 1883625936 18.694 95 24 47 1 1901143184 10797104 6720144
00:33:11 38844 8192000000 10870505472 11331903488 1902450224 18.846 97 28 53 5 1922810928 12009696 8351008
00:33:58 63926 8192000000 10894432256 11364909056 1926570496 19.039 98 20 40 0 1948319856 15620128 6129232
00:35:15 46291 8192000000 10869867648 11345948672 1914057104 18.939 98 10 20 0 1935436224 18482016 2897104
00:36:07 36551 8192000000 10897463536 11347582976 1885288944 18.708 96 33 66 0 1904295792 10087504 8919344
00:37:00 47142 8192000000 10866099616 11313520640 1861442496 18.515 96 33 66 2 1886568464 15188416 9937552
00:37:54 32486 8192000000 10867886928 11326435328 1903420752 18.854 98 35 70 1 1930710672 17339440 9950480
00:38:33 76142 8192000000 10886757744 11351318528 1932340272 19.086 100 14 28 0 1956411536 19666384 4404880
00:39:56 27849 8192000000 10901012096 11354402816 1936895968 19.122 99 30 60 0 1954762176 9627776 8238432
00:40:32 28610 8192000000 10905576848 11359641600 1964833472 19.344 100 52 103 2 1990020160 11036912 14149776
00:41:32 21403 8192000000 10887408176 11333693440 1914980352 18.947 98 43 86 1 1938645168 11805856 11858960
00:42:05 70120 8192000000 10881958784 11356278784 1934379200 19.102 99 40 80 0 1960277408 14815168 11083040
00:43:22 37506 8192000000 10871087104 11316817920 1865459600 18.548 95 40 80 0 1887477680 10159024 11859056
00:44:09 131186 8192000000 10874734304 11340185600 1929682704 19.064 99 33 66 0 1951727696 12631488 9413504
00:46:27 66870 8192000000 10888161424 11350237184 1934064000 19.099 99 24 48 1 1959877744 18800048 7013696
00:47:50 17361 8192000000 10869610688 11344764928 1940228512 19.149 100 15 30 2 1962067312 17365568 4473232
00:48:22 69135 8192000000 10851864080 11331919872 1899767984 18.824 98 12 24 0 1918162320 15023104 3371232
00:49:44 35336 8192000000 10839395520 11323883520 1891930752 18.761 98 6 12 0 1910213952 16419648 1863552
00:50:30 14998 8192000000 10834832624 11298725888 1919033136 18.979 100 10 18 1 1933120560 11553952 2533472
00:50:52 41368 8192000000 10853287456 11327115264 1934676416 19.104 100 27 54 2 1954577840 11542608 8358816
00:51:41 59040 8192000000 10860446144 11331276800 1900435600 18.830 98 15 30 0 1911410256 6872464 4102192
00:52:59 54796 8192000000 10855666544 11336462336 1923909328 19.018 99 13 26 0 1939405360 11168624 4327408
00:54:00 47685 8192000000 10860789888 11354292224 1944289744 19.181 100 11 22 0 1961674640 14184000 3200896
00:54:55 41848 8192000000 10882434192 11366948864 1945794112 19.193 100 7 14 1 1963052320 15105312 2152896
00:56:03 86883 8192000000 10883633152 11351990272 1911745008 18.921 98 14 28 1 1926632304 10975808 3911488
00:57:39 78722 8192000000 10891536704 11361173504 1949464816 19.222 99 17 34 0 1970694768 16740160 4489792
00:59:04 81309 8192000000 10899673248 11380903936 1948672672 19.216 99 17 33 1 1969942464 17302448 3967344
01:00:33 73340 8192000000 10886220896 11356594176 1895009680 18.786 96 14 28 0 1907468944 8394800 4064464
01:01:53 18972 8192000000 10906667872 11362795520 1930861792 19.074 98 44 88 0 1953612240 10254576 12495872
01:02:24 24217 8192000000 10918272512 11372367872 1957541520 19.286 99 42 84 1 1982350832 13509248 11300064
01:02:57 42924 8192000000 10919658880 11386986496 1974320560 19.420 100 30 60 1 1998973200 15775712 8876928
01:03:49 46194 8192000000 10880231712 11358756864 1900820704 18.833 96 19 38 0 1918670048 12662848 5186496
01:04:41 53056 8192000000 10904975680 11371458560 1944381424 19.182 99 15 30 0 1959240336 10980768 3878144
01:05:48 51329 8192000000 10896741152 11355934720 1901277904 18.837 97 29 58 0 1924825632 15457760 8089968
01:07:30 128430 8192000000 10879443056 11359211520 1895731008 18.792 97 15 30 0 1916689296 16884176 4074112
01:10:45 41603 8192000000 10873554000 11326971904 1896117472 18.795 97 35 67 1 1911794432 6502832 9174128
01:11:33 11832 8192000000 10865181424 11332440064 1941154864 19.156 100 24 48 0 1955839552 8106288 6578400
01:11:53 85006 8192000000 10868800256 11352899584 1934336592 19.102 99 12 24 0 1945968992 8883504 2748896
01:13:41 28644 8192000000 10864850368 11348680704 1935323392 19.109 99 4 8 0 1948663296 12382336 957568
01:14:23 50021 8192000000 10854590944 11330584576 1901410464 18.838 97 12 24 1 1917419024 12546832 3461728
01:15:21 89652 8192000000 10872338688 11358322688 1942935056 19.170 99 15 30 1 1966368704 18335600 5098048
01:17:08 51966 8192000000 10898237440 11371601920 1970730400 19.391 100 21 42 0 1986105008 9412368 5962240
01:18:06 41510 8192000000 10890253568 11362631680 1919400784 18.982 97 23 46 1 1937277072 11244128 6632160
01:19:30 60545 8192000000 10877284208 11351519232 1916103104 18.956 98 14 28 0 1930209504 10088096 4018304
01:20:37 56704 8192000000 10890616448 11373174784 1968302608 19.372 100 11 22 0 1988939312 17634912 3001792
01:21:43 43748 8192000000 10868425472 11324411904 1863224368 18.529 95 14 28 0 1879198592 12027504 3946720
01:22:39 63344 8192000000 10857905936 11329490944 1894669024 18.783 97 21 42 1 1912746144 12076000 6001120
01:24:22 22517 8192000000 10871550288 11315113984 1923907584 19.018 100 23 46 1 1936866704 6627920 6331200
01:24:56 22310 8192000000 10865083504 11307139072 1886376976 18.717 98 51 102 2 1909218512 8652368 14189168
01:25:26 14888 8192000000 10847417872 11297902592 1877548560 18.645 98 44 88 1 1900340032 10598624 12192848
01:25:47 94307 8192000000 9935083520 10297798656 1023257248 11.103 54 10 20 0 1032774304 6697504 2819552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 08-03-2021 01:28:15 to 08-03-2021 01:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 105 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 08-03-2021 01:28:48 to 08-03-2021 01:28:50.

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          246307
MON$OLDEST_ACTIVE               247300
MON$OLDEST_SNAPSHOT             247300
MON$NEXT_TRANSACTION            247300
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                       2009280
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:164: 
:165: mscs-test-161.budzdorov.ru    Mon Mar  8 01:27:30 2021
:166:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:167: 
:168: 
:169: mscs-test-161.budzdorov.ru    Mon Mar  8 01:27:30 2021
:170:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:171: 
--- end of diff output ---

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

08.03.21 01:28:51. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-08 01:28:53 No severe PSQL-related problems occured
08.03.21 01:28:54. End of report.