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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17386804 kB
MemAvailable 31429660 kB
Buffers 0 kB
Cached 14288020 kB
SwapCached 120 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-04-07 19:27:28
DTS_END                         2021-04-07 19:27:28.4800
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/53254
TRN_ID                          237900
ATT_ID                          666
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: 8984.13 21593 1078095
customer order: creation 170.82 388 20498
customer order: refuse 14.71 343 1765
order to supplier: creation 44.18 1351 5301
order to supplier: removal 3.13 96874 375
invoice (draft): creation 45.23 3277 5428
invoice (draft): removal 51.39 681 6167
invoice accept: apply 41.16 19144 4939
invoice accept: cancel 46.53 738 5583
customer reserve: creation 3726.08 192 447130
customer reserve: removal 4556.43 52 546771
realization accept: apply 81.60 187 9792
realization accept: cancel 74.48 105 8938
payment from customer: creation 58.01 131 6961
payment from customer: removal 5.89 78 707
payment to supplier: creation 49.23 135 5907
payment to supplier: removal 3.40 87 408
service: total inventory turnovers 4.53 1010 543
service: total monetary turnovers 6.54 39 785
service: aggregate perf. data 0.78 21947 93
service: refresh index statistics 0.03 285104 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-04-2021 19:28:51 to 07-04-2021 19:28:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4111
TEST_TIME 2 3561
TEST_TIME 3 4794
TEST_TIME 4 4690
TEST_TIME 5 5220
TEST_TIME 6 6422
TEST_TIME 7 6339
TEST_TIME 8 6822
TEST_TIME 9 6800
TEST_TIME 10 7073
TEST_TIME 11 7112
TEST_TIME 12 7580
TEST_TIME 13 7693
TEST_TIME 14 7819
TEST_TIME 15 8174
TEST_TIME 16 8562
TEST_TIME 17 8685
TEST_TIME 18 8679
TEST_TIME 19 8984
TEST_TIME 20 9576
TEST_TIME 21 9487
TEST_TIME 22 9643
TEST_TIME 23 9848
TEST_TIME 24 9919
TEST_TIME 25 10082
TEST_TIME 26 10163
TEST_TIME 27 9912
TEST_TIME 28 10011
TEST_TIME 29 10090
TEST_TIME 30 10204
TEST_TIME 31 10306
TEST_TIME 32 10096
TEST_TIME 33 10054
TEST_TIME 34 10059
TEST_TIME 35 10242
TEST_TIME 36 10076
TEST_TIME 37 10017
TEST_TIME 38 9919
TEST_TIME 39 9825
TEST_TIME 40 9714
TEST_TIME 41 9647
TEST_TIME 42 9551
TEST_TIME 43 9490
TEST_TIME 44 9376
TEST_TIME 45 9297
TEST_TIME 46 9228
TEST_TIME 47 9254
TEST_TIME 48 9119
TEST_TIME 49 9168
TEST_TIME 50 9249
TEST_TIME 51 9278
TEST_TIME 52 9338
TEST_TIME 53 9277
TEST_TIME 54 9262
TEST_TIME 55 9279
TEST_TIME 56 9184
TEST_TIME 57 9281
TEST_TIME 58 9221
TEST_TIME 59 9234
TEST_TIME 60 9470
TEST_TIME 61 9506
TEST_TIME 62 9573
TEST_TIME 63 9574
TEST_TIME 64 9585
TEST_TIME 65 9611
TEST_TIME 66 9556
TEST_TIME 67 9443
TEST_TIME 68 9422
TEST_TIME 69 9372
TEST_TIME 70 9360
TEST_TIME 71 9312
TEST_TIME 72 9301
TEST_TIME 73 9273
TEST_TIME 74 9206
TEST_TIME 75 9184
TEST_TIME 76 9200
TEST_TIME 77 9162
TEST_TIME 78 9177
TEST_TIME 79 9149
TEST_TIME 80 9155
TEST_TIME 81 9185
TEST_TIME 82 9206
TEST_TIME 83 9246
TEST_TIME 84 9180
TEST_TIME 85 9171
TEST_TIME 86 9257
TEST_TIME 87 9213
TEST_TIME 88 9291
TEST_TIME 89 9324
TEST_TIME 90 9393
TEST_TIME 91 9376
TEST_TIME 92 9336
TEST_TIME 93 9244
TEST_TIME 94 9259
TEST_TIME 95 9210
TEST_TIME 96 9156
TEST_TIME 97 9129
TEST_TIME 98 9112
TEST_TIME 99 9150
TEST_TIME 100 9147
TEST_TIME 101 9101
TEST_TIME 102 9116
TEST_TIME 103 9161
TEST_TIME 104 9197
TEST_TIME 105 9227
TEST_TIME 106 9254
TEST_TIME 107 9233
TEST_TIME 108 9245
TEST_TIME 109 9267
TEST_TIME 110 9248
TEST_TIME 111 9177
TEST_TIME 112 9158
TEST_TIME 113 9129
TEST_TIME 114 9113
TEST_TIME 115 9066
TEST_TIME 116 9049
TEST_TIME 117 9037
TEST_TIME 118 9028
TEST_TIME 119 9052
TEST_TIME 120 8991

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-04-2021 19:28:54 to 07-04-2021 19:28:58.

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 1493039 1493039 0 0.00 0 14085 6 0 0
doc_list_biud 1493039 1493039 0 0.00 0 41692 25 0 0
sp_add_invoice_to_stock 5052 4939 113 2.23 26 192691 19145 0 113
sp_cancel_adding_invoice 5583 5583 0 0.00 3 47051 738 0 0
sp_cancel_client_order 1765 1765 0 0.00 5 9817 344 0 0
sp_cancel_customer_reserve 546771 546771 0 0.00 1 41693 52 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 3 5980 79 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 2 4852 88 0 0
sp_cancel_supplier_invoice 6180 6167 13 0.21 2 19690 681 0 13
sp_cancel_supplier_order 375 375 0 0.00 7 817214 96874 0 0
sp_cancel_write_off 8938 8938 0 0.00 1 9710 105 0 0
sp_client_order 20498 20498 0 0.00 4 25352 389 0 0
sp_customer_reserve 447130 447130 0 0.00 0 68492 192 0 0
sp_fill_shopping_cart 31225 31225 0 0.00 1 20593 39 0 0
sp_fill_shopping_cart_clo_res 447125 447125 0 0.00 0 16151 16 0 0
sp_get_clo_for_invoice 4932 4932 0 0.00 0 52544 356 0 0
sp_kill_cost_storno 15636 15636 0 0.00 0 7544 54 0 0
sp_kill_qstorno_ret_qs2qd 1109022 1109022 0 0.00 0 41689 28 0 0
sp_kill_qty_storno 584323 584323 0 0.00 0 41692 62 0 0
sp_lock_selected_doc 20387 20387 0 0.00 0 7809 6 0 0
sp_make_cost_storno 27592 27592 0 0.00 0 13503 57 0 0
sp_multiply_rows_for_pdistr 27592 27592 0 0.00 0 6286 28 0 0
sp_multiply_rows_for_qdistr 20498 20498 0 0.00 0 17252 178 0 0
sp_pay_from_customer 6961 6961 0 0.00 4 74054 132 0 0
sp_pay_to_supplier 5907 5907 0 0.00 4 15624 136 0 0
sp_payment_common 12868 12868 0 0.00 1 74047 41 0 0
sp_qd_handle_on_cancel_clo 1765 1765 0 0.00 0 9811 310 0 0
sp_qd_handle_on_invoice_upd_sts 10515 10515 0 0.00 0 23446 343 0 0
sp_qd_handle_on_reserve_upd_sts 9792 9792 0 0.00 0 20011 65 0 0
sp_reserve_write_off 9792 9792 0 0.00 6 20045 188 0 0
sp_supplier_invoice 5428 5428 0 0.00 7 74316 3278 0 0
sp_supplier_order 5301 5301 0 0.00 5 29955 1352 0 0
srv_aggregate_perf_data 93 93 0 0.00 2507 341624 21947 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 858 162633 32356 0 0
srv_find_qd_qs_mism 1031693 1031693 0 0.00 0 10959 6 0 0
srv_make_invnt_saldo 543 543 0 0.00 28 25859 1010 0 0
srv_make_money_saldo 785 785 0 0.00 1 6131 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 180737 455881 285105 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4939 4939 0 0.00 0 14862 181 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 1 6372 122 0 0
t$perf-norm:sp_cancel_client_order 1765 1765 0 0.00 0 9058 22 0 0
t$perf-norm:sp_cancel_customer_reserve 627 627 0 0.00 0 1438 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 1007 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 2635 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 552 13 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 22175 1590 0 0
t$perf-norm:sp_cancel_write_off 997 997 0 0.00 0 1906 6 0 0
t$perf-norm:sp_client_order 20498 20498 0 0.00 0 10847 19 0 0
t$perf-norm:sp_customer_reserve 927 927 0 0.00 0 7832 19 0 0
t$perf-norm:sp_pay_from_customer 6961 6961 0 0.00 0 4803 14 0 0
t$perf-norm:sp_pay_to_supplier 5907 5907 0 0.00 0 9486 11 0 0
t$perf-norm:sp_reserve_write_off 9792 9792 0 0.00 0 7388 13 0 0
t$perf-norm:sp_supplier_invoice 5428 5428 0 0.00 0 4673 18 0 0
t$perf-norm:sp_supplier_order 5301 5301 0 0.00 0 4340 17 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 205 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1259 11 0 0
t$perf-norm:srv_make_invnt_saldo 543 543 0 0.00 0 4667 34 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 2177 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10088 9862 226 2.24 0 5069 21 0 226
v_all_customers 36770 36770 0 0.00 0 17 1 0 0
v_all_suppliers 29986 29986 0 0.00 0 27 1 0 0
v_all_wares 40996 40996 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 638 7 0 0
v_cancel_client_order 3530 3530 0 0.00 0 3479 7 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 2539 11 0 0
v_cancel_customer_reserve 1254 1254 0 0.00 0 1690 9 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 1296 10 0 0
v_cancel_supplier_invoice 780 754 26 3.33 0 2338 27 0 26
v_cancel_supplier_order 750 750 0 0.00 0 631 5 0 0
v_cancel_write_off 1994 1994 0 0.00 0 2926 15 0 0
v_max_id_clo_ord 5300 5300 0 0.00 0 1384 2 0 0
v_max_id_clo_res 927 927 0 0.00 0 1674 10 0 0
v_max_id_ord_sup 5426 5426 0 0.00 0 3971 4 0 0
v_max_non_paid_invoice 1640 1640 0 0.00 0 694 3 0 0
v_max_non_paid_realizn 3871 3871 0 0.00 0 4113 5 0 0
v_min_id_clo_ord 5300 5300 0 0.00 0 7218 10 0 0
v_min_id_clo_res 927 927 0 0.00 0 3036 7 0 0
v_min_id_ord_sup 5426 5426 0 0.00 0 5656 6 0 0
v_min_non_paid_invoice 5907 5907 0 0.00 0 9267 23 0 0
v_min_non_paid_realizn 6961 6961 0 0.00 0 9007 24 0 0
v_our_firm 10406 10406 0 0.00 0 17 1 0 0
v_reserve_write_off 19584 19584 0 0.00 0 3584 7 0 0
x_lock_depdocs_on_canc_invoice 11373 11373 0 0.00 0 13491 122 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 14615 406 0 0
x_make_qstorno_1000_1200 5301 5301 0 0.00 2 29942 1264 0 0
x_make_qstorno_1200_2000 5428 5428 0 0.00 3 74309 3145 0 0
x_make_qstorno_2100_3300 447130 447130 0 0.00 0 68491 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2021 19:28:59 to 07-04-2021 19:29:03.

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
16:57:32 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:38 9745 8192000000 10172618880 10469658624 717901344 8.057 58 50 107 0 735637216 1842768 15893104
16:57:56 26739 8192000000 10338135840 10649518080 1367191824 14.302 100 87 174 0 1400067040 4384256 28490960
16:58:30 33507 8192000000 10368040976 10687266816 1409641904 14.681 100 89 178 0 1445210464 6318864 29249696
16:59:13 29505 8192000000 10396632624 10727510016 1454064080 15.074 100 90 180 0 1491158224 7530480 29563664
16:59:54 19039 8192000000 10431254336 10760646656 1480567328 15.306 100 88 175 1 1516918304 8106000 28244976
17:00:27 22488 8192000000 10458190512 10793852928 1507341392 15.540 100 87 174 0 1544151392 9014224 27795776
17:00:59 21305 8192000000 10475671936 10815426560 1524782672 15.692 100 85 170 1 1561946960 9714048 27450240
17:01:29 13663 8192000000 10483982096 10830422016 1543653536 15.855 100 80 160 2 1577995440 9142064 25199840
17:01:52 20118 8192000000 10519473424 10869841920 1570709680 16.088 100 79 159 0 1605253712 9686576 24857456
17:02:23 14374 8192000000 10540395360 10896977920 1597447680 16.318 100 74 148 1 1630535584 10051200 23036704
17:02:51 14489 8192000000 10580482416 10941804544 1633043712 16.621 100 74 148 0 1665864592 10353216 22467664
17:03:13 9323 8192000000 10593197040 10959925248 1647552400 16.744 100 69 135 2 1678012208 10786352 19673456
17:03:30 10024 8192000000 10619863856 10989264896 1681620224 17.031 100 75 150 0 1715033680 11200320 22213136
17:03:46 12461 8192000000 10645237184 11016019968 1701736560 17.200 100 80 160 2 1736896880 11955424 23204896
17:04:06 10111 8192000000 10657924736 11028180992 1717816912 17.334 100 80 159 1 1753987216 13068320 23101984
17:04:25 6607 8192000000 10664896560 11038302208 1727184032 17.412 100 82 164 1 1764223696 13773792 23265872
17:04:40 5291 8192000000 10672719312 11051511808 1740044560 17.519 100 74 148 1 1773755248 12694320 21016368
17:04:53 8847 8192000000 10690523744 11069181952 1751326096 17.613 100 73 146 2 1783851200 11775712 20749392
17:05:09 5170 8192000000 10701179088 11079946240 1760187440 17.686 100 78 156 0 1798257152 16318576 21751136
17:05:22 5914 8192000000 10700105568 11083255808 1766218112 17.736 100 79 158 0 1801506544 13006224 22282208
17:05:35 3104 8192000000 10705570240 11088613376 1773816608 17.799 100 75 148 1 1808688480 13236576 21635296
17:05:47 8935 8192000000 10719503920 11101908992 1782397440 17.869 100 68 136 0 1813999376 13271984 18329952
17:06:03 4717 8192000000 10732424112 11121307648 1793840848 17.963 100 78 156 1 1827805360 12513664 21450848
17:06:15 2570 8192000000 10752049968 11132571648 1805500176 18.059 100 86 172 1 1843266128 14019808 23746144
17:06:24 3197 8192000000 10753075840 11138248704 1814642256 18.134 100 87 173 0 1853591216 14842208 24106752
17:06:34 3062 8192000000 10759768496 11143233536 1820706224 18.183 100 87 174 1 1859426656 14376480 24343952
17:06:44 2265 8192000000 10760170784 11151249408 1826547888 18.231 100 84 168 0 1864128704 13819376 23761440
17:06:53 3507 8192000000 10780163776 11162324992 1835204384 18.302 100 88 176 1 1874021584 14235328 24581872
17:07:03 2070 8192000000 10780802112 11164049408 1835174560 18.302 100 89 178 2 1873486080 13494448 24817072
17:07:12 2911 8192000000 10776836272 11160621056 1842529984 18.361 100 89 177 1 1879438848 12215248 24693616
17:07:22 2012 8192000000 10787360144 11171835904 1839600336 18.338 100 86 174 2 1875847008 12693888 23552784
17:07:31 2119 8192000000 10792504096 11174301696 1845819328 18.388 100 93 187 1 1885794336 14583104 25391904
17:07:39 2307 8192000000 10790969520 11172495360 1847970960 18.406 100 92 183 1 1888275808 15189376 25115472
17:07:49 1601 8192000000 10796420096 11182419968 1850112032 18.423 100 93 187 0 1891600816 14812480 26676304
17:07:57 2604 8192000000 10797580960 11185479680 1855070480 18.463 100 89 178 2 1895592608 14291200 26230928
17:08:06 1902 8192000000 10799817008 11185479680 1852984976 18.446 100 90 178 0 1892806032 14086304 25734752
17:08:14 1252 8192000000 10808536752 11194613760 1861131904 18.512 100 95 195 2 1901880448 13397536 27351008
17:08:22 2252 8192000000 10809192464 11196895232 1865709056 18.550 100 90 181 0 1904010704 12512672 25788976
17:08:30 20206 8192000000 10800606976 11192778752 1864593616 18.541 100 67 135 2 1892299664 8672704 19033344
17:08:57 1738 8192000000 10799051104 11202715648 1867959536 18.568 100 69 140 2 1899417760 10814384 20643840
17:09:05 3905 8192000000 10794244080 11201961984 1865470176 18.548 100 50 100 0 1889863552 9735584 14657792
17:09:17 4839 8192000000 10773565344 11195256832 1866792112 18.558 100 47 93 1 1887874032 8005648 13076272
17:09:28 4129 8192000000 10780138592 11197333504 1865948384 18.551 100 48 96 0 1887282208 8171040 13162784
17:09:41 3461 8192000000 10782395632 11201052672 1868375440 18.571 100 40 80 3 1886404448 7110112 10918896
17:09:56 7764 8192000000 10775976560 11204251648 1869117968 18.577 100 28 55 2 1883858704 7436992 7303744
17:10:12 5540 8192000000 10790794512 11205718016 1874366448 18.620 100 35 70 0 1890961232 7082352 9512432
17:10:29 12022 8192000000 10797598576 11213578240 1871984640 18.600 100 23 46 2 1885461056 7063120 6413296
17:10:47 54103 8192000000 10829943696 11225165824 1880015168 18.665 100 54 110 0 1901979728 5919136 16045424
17:11:48 6255 8192000000 10788562304 11225038848 1879419376 18.660 100 24 48 2 1893398448 7519936 6459136
17:12:00 8828 8192000000 10806983200 11231891456 1884677088 18.703 100 29 58 0 1899584128 6839968 8067072
17:12:19 9208 8192000000 10799417648 11231870976 1885458560 18.709 100 26 52 2 1903592112 11131072 7002480
17:12:35 4361 8192000000 10807645456 11236249600 1889778272 18.744 100 27 55 2 1903519248 6277504 7463472
17:12:46 10354 8192000000 10815033840 11242430464 1891717056 18.760 100 28 56 3 1910995872 10057232 9221584
17:13:02 8361 8192000000 10810440544 11238445056 1892086944 18.763 100 18 36 0 1902319328 5822544 4409840
17:13:17 6980 8192000000 10815136864 11242668032 1895523008 18.790 100 26 52 0 1909245936 6388112 7334816
17:13:34 9240 8192000000 10804782304 11243159552 1896776352 18.800 100 18 36 3 1908174464 5693712 5704400
17:13:49 7729 8192000000 10809339696 11243659264 1896812176 18.801 100 12 24 0 1905967264 5313760 3841328
17:14:05 6946 8192000000 10809398096 11246641152 1899643872 18.823 100 20 38 3 1911518768 5329552 6545344
17:14:18 12033 8192000000 10806938080 11249160192 1901907136 18.842 100 18 36 1 1912837024 5580224 5349664
17:14:37 8012 8192000000 10802782880 11244466176 1897410224 18.805 100 21 42 1 1909747072 6726208 5610640
17:14:52 53158 8192000000 10845167040 11252056064 1889986960 18.746 99 64 125 2 1914086544 4758768 19340816
17:15:57 9995 8192000000 10806157136 11245367296 1897611840 18.807 100 18 36 2 1908773408 6221360 4940208
17:16:14 8389 8192000000 10817817648 11241779200 1878621248 18.654 99 20 39 1 1890183888 5850128 5712512
17:16:28 3592 8192000000 10802778656 11237568512 1877047232 18.641 99 22 44 1 1889367008 5826160 6493616
17:16:38 2850 8192000000 10813359984 11240067072 1891644832 18.759 100 28 56 1 1905825024 6380880 7799312
17:16:48 7097 8192000000 10814676624 11241439232 1892958704 18.770 100 27 54 4 1906354240 5924176 7471360
17:17:03 7069 8192000000 10802919392 11226791936 1853243344 18.448 98 30 60 1 1872239584 10820832 8175408
17:17:17 7038 8192000000 10796129088 11227140096 1867417840 18.563 99 34 68 1 1887737904 10468016 9852048
17:17:35 4045 8192000000 10800282112 11229388800 1884387440 18.701 100 36 72 3 1902597152 7813120 10396592
17:17:45 7583 8192000000 10785038544 11214569472 1844617120 18.378 98 30 60 2 1862204256 9024096 8563040
17:18:00 11431 8192000000 10774318032 11199721472 1788517072 17.920 95 12 24 0 1797655632 5627936 3510624
17:18:18 7488 8192000000 10758415536 11183706112 1812602080 18.117 98 14 28 0 1821862368 5366000 3894288
17:18:33 9906 8192000000 10769167904 11188654080 1799941904 18.013 97 18 35 2 1810843136 5248720 5652512
17:18:51 7389 8192000000 10742286016 11170099200 1804089696 18.047 97 18 33 2 1814677872 4687040 5901136
17:19:08 14259 8192000000 10727119008 11147517952 1706714704 17.241 93 15 30 1 1716946320 5352864 4878752
17:19:29 38930 8192000000 10706910432 11130892288 1681357808 17.029 92 24 47 2 1694685888 5074400 8253680
17:20:24 14915 8192000000 10758443104 11141681152 1776377744 17.820 98 67 132 2 1801322192 5248816 19695632
17:20:46 6110 8192000000 10705425776 11123855360 1764366208 17.720 98 20 40 2 1776130256 5928032 5836016
17:21:02 11709 8192000000 10708524592 11114463232 1706280352 17.238 95 29 58 0 1721175536 6829344 8065840
17:21:20 7996 8192000000 10717262192 11137613824 1801632544 18.027 100 35 69 1 1818743488 7508560 9602384
17:21:38 9358 8192000000 10698783504 11111960576 1736310720 17.488 97 28 54 3 1751008800 6383312 8314768
17:21:56 8361 8192000000 10705310832 11117223936 1765324496 17.728 98 31 63 1 1780041152 5426768 9289888
17:22:12 7738 8192000000 10692493440 11112685568 1755878048 17.650 98 23 47 0 1768784960 4939776 7967136
17:22:31 5248 8192000000 10731581168 11151863808 1811888800 18.111 100 22 44 0 1823743024 5790608 6063616
17:22:42 7487 8192000000 10740180656 11160113152 1822800096 18.201 100 20 40 1 1834090192 5154480 6135616
17:22:59 11883 8192000000 10734197120 11154190336 1793461472 17.960 98 24 46 0 1805863968 5113392 7289104
17:23:18 8767 8192000000 10761256544 11174780928 1832231792 18.278 100 24 48 3 1844091760 4778608 7081360
17:23:33 9651 8192000000 10755995536 11179655168 1838334000 18.327 100 27 56 0 1852736512 5560160 8842352
17:23:51 7181 8192000000 10762176608 11184054272 1842324784 18.360 100 20 39 0 1853795072 5506544 5963744
17:24:09 10444 8192000000 10755998624 11180621824 1844673936 18.379 100 34 69 0 1864705120 9955040 10076144
17:24:26 22178 8192000000 10751270912 11188908032 1849623168 18.419 100 28 56 1 1864585328 5493792 9468368
17:24:59 46117 8192000000 10767703200 11198935040 1855635040 18.468 100 44 88 0 1874879216 5822672 13421504
17:25:53 17273 8192000000 10770615088 11204591616 1861702256 18.517 100 20 40 1 1873637680 5693360 6242064
17:26:20 8672 8192000000 10781759040 11211116544 1868296928 18.570 100 34 66 2 1883113504 5695280 9121296
17:26:36 10367 8192000000 10788650432 11217281024 1871867712 18.599 100 28 56 5 1886927968 7163328 7896928
17:26:54 10766 8192000000 10799435424 11226062848 1873781056 18.615 100 27 54 1 1891972432 10180320 8011056
17:27:11 9728 8192000000 10803044336 11228209152 1888600496 18.734 100 20 40 1 1899467616 5200624 5666496
17:27:26 24454 8192000000 10827920560 11249131520 1900744272 18.832 100 41 82 2 1917538912 5156576 11638064
17:28:05 26622 8192000000 10845686928 11265466368 1914458384 18.942 100 46 90 1 1934431456 7425680 12547392
17:28:44 13100 8192000000 10857624928 11277389824 1925837472 19.034 100 45 90 2 1946426512 8072000 12517040
17:29:11 27490 8192000000 10871600640 11290636288 1934315168 19.101 100 57 114 0 1960194912 10264608 15615136
17:29:47 18152 8192000000 10882753360 11305205760 1941197392 19.156 100 52 101 2 1969985936 14470576 14317968
17:30:13 6634 8192000000 10883111680 11305775104 1947678976 19.208 100 54 108 1 1978650496 15253648 15717872
17:30:32 11955 8192000000 10893664848 11316711424 1952672944 19.248 100 55 110 1 1984302256 15292000 16337312
17:30:53 8648 8192000000 10891342448 11320217600 1955103664 19.267 100 47 94 0 1983515904 14900704 13511536
17:31:10 8081 8192000000 10891252656 11318939648 1956658912 19.279 100 45 88 1 1985232112 14803680 13769520
17:31:27 43250 8192000000 10894680160 11325870080 1959118144 19.299 100 50 100 0 1988153104 14682544 14352416
17:32:18 12051 8192000000 10893463168 11324243968 1940521360 19.151 99 46 92 0 1971836048 18318352 12996336
17:32:40 2944 8192000000 10892975952 11319312384 1948716720 19.216 100 56 110 1 1983732688 19440336 15575632
17:32:51 4750 8192000000 10905031520 11328516096 1956094288 19.275 100 60 120 2 1995348928 21752144 17502496
17:33:02 6463 8192000000 10888431200 11317256192 1937533328 19.127 99 58 114 0 1972779520 19011696 16234496
17:33:17 6760 8192000000 10896974848 11306680320 1937502224 19.127 99 70 138 0 1978481392 20360224 20618944
17:33:31 1285 8192000000 10907324976 11321901056 1954002352 19.258 100 75 151 2 1996844624 21151200 21691072
17:33:40 4725 8192000000 10910046112 11333832704 1960658384 19.311 100 61 122 1 1997007616 18885584 17463648
17:34:04 1568 8192000000 10917221280 11336929280 1966985040 19.362 100 62 123 2 2002481648 17856576 17640032
17:34:12 11050 8192000000 10913019488 11341742080 1969516224 19.382 100 56 110 1 2003596688 18096336 15984128
17:34:44 10418 8192000000 10914003136 11343687680 1965785024 19.352 100 59 117 0 2002346432 19288160 17273248
17:35:02 10035 8192000000 10913390096 11344134144 1977048336 19.441 100 62 124 0 2014380656 19347872 17984448
17:35:19 17826 8192000000 10913338992 11347660800 1962204912 19.324 99 57 113 0 1995246480 16714448 16327120
17:35:45 18953 8192000000 10907458784 11345674240 1973264256 19.411 100 50 99 1 2002769280 15440064 14064960
17:36:11 4524 8192000000 10918617776 11346382848 1977246976 19.443 100 59 117 1 2011050560 15654464 18149120
17:36:24 2984 8192000000 10922093040 11345018880 1965201648 19.347 99 73 143 2 2003393392 17866320 20325424
17:36:36 3799 8192000000 10941971360 11364741120 1984529088 19.501 100 76 147 0 2023442896 18448160 20465648
17:36:47 6480 8192000000 10940604288 11362205696 1988186000 19.529 100 73 146 1 2028810000 18776416 21847584
17:37:01 1545 8192000000 10947783184 11367223296 1997245520 19.601 100 72 142 0 2036240592 18672592 20322480
17:37:09 3891 8192000000 10958694096 11381932032 1999097872 19.616 100 74 145 1 2043107456 23021024 20988560
17:37:23 2413 8192000000 10958138208 11383967744 2000309872 19.625 100 68 136 0 2041910480 22124032 19476576
17:37:45 3959 8192000000 10954957520 11374575616 1992385984 19.563 100 76 151 1 2037856720 23540032 21930704
17:37:55 2291 8192000000 10967404896 11381276672 2001329792 19.633 100 85 170 0 2049519440 23407296 24782352
17:38:05 7602 8192000000 10964065600 11387904000 2006022128 19.670 100 75 149 1 2052653504 24510880 22120496
17:38:22 5887 8192000000 10961537872 11390943232 2008776288 19.692 100 67 132 2 2051046976 22676752 19593936
17:38:36 3417 8192000000 10968775344 11395977216 2012446432 19.721 100 75 149 1 2056921104 23385056 21089616
17:38:47 4746 8192000000 10963755152 11394752512 2006832416 19.677 100 63 124 1 2048951472 24280944 17838112
17:39:03 2559 8192000000 10978767120 11392720896 2011057888 19.710 100 83 165 2 2059681344 24488512 24134944
17:39:14 2692 8192000000 10962151248 11380359168 1995276448 19.585 100 83 162 0 2047072208 27575632 24220128
17:39:24 10899 8192000000 10943337872 11373498368 1992404704 19.563 100 64 128 2 2035487616 24222256 18860656
17:39:42 1752 8192000000 10963633120 11385552896 2005120416 19.663 100 79 157 2 2051466112 21941456 24404240
17:39:52 1558 8192000000 10972485472 11388329984 2006690896 19.675 100 82 164 1 2054324080 23777824 23855360
17:40:00 9232 8192000000 10954145872 11387691008 1990899760 19.551 99 68 135 0 2033314928 22102912 20312256
17:40:19 3320 8192000000 10930053456 11352911872 1967094000 19.362 99 65 130 2 2010528528 23973776 19460752
17:40:30 8492 8192000000 10941500880 11370864640 1974417936 19.420 99 67 132 0 2019498416 24460768 20619712
17:40:45 2786 8192000000 10958177840 11373527040 1988334288 19.531 100 84 167 3 2038487584 26127888 24025408
17:40:56 6279 8192000000 10966914160 11383578624 1999058672 19.615 100 83 164 4 2050170032 27194064 23917296
17:41:10 4687 8192000000 10958459392 11384332288 1997059392 19.600 100 75 150 1 2048180032 28361520 22759120
17:41:22 2522 8192000000 10955113680 11367653376 1976856432 19.440 99 72 144 3 2028263120 29018128 22388560
17:41:31 1799 8192000000 10952575840 11362328576 1975685968 19.431 100 94 185 4 2035263552 31181504 28396080
17:41:40 3726 8192000000 10928890592 11351040000 1955683520 19.272 99 64 128 2 2005778400 31102128 18992752
17:41:51 8011 8192000000 10922229488 11347030016 1943168448 19.172 99 69 137 1 1997884560 33800160 20915952
17:42:10 2055 8192000000 10937771856 11363930112 1972347296 19.404 100 71 141 0 2028505840 35119904 21038640
17:42:24 3303 8192000000 10962563072 11373105152 1982127136 19.482 100 85 170 1 2043503744 35597744 25778864
17:42:34 6777 8192000000 10959126896 11382611968 1984896864 19.503 100 76 152 0 2045747264 37047296 23803104
17:42:49 3259 8192000000 10961731024 11389898752 1989221584 19.538 100 74 148 0 2050434640 38234656 22978400
17:42:59 2439 8192000000 10954234304 11370860544 1980385504 19.468 100 77 154 1 2034163472 29614320 24163648
17:43:10 9009 8192000000 10933006816 11357343744 1973996960 19.417 100 71 142 0 2026531616 30200592 22334064
17:43:26 2492 8192000000 10923499376 11341864960 1957398000 19.285 100 78 156 1 2008074400 25436384 25240016
17:43:35 2372 8192000000 10924754944 11338801152 1955656432 19.272 100 86 172 1 2008571168 26316480 26598256
17:43:44 7434 8192000000 10894537376 11316293632 1918603328 18.976 99 58 117 1 1962727664 25998336 18126000
17:43:59 26657 8192000000 10893045360 11328274432 1921684720 19.000 99 41 81 1 1960034976 25068720 13281536
17:44:32 2709 8192000000 10882466448 11313815552 1930908016 19.074 100 52 104 0 1971348528 23927264 16513248
17:45:03 4292 8192000000 10875570032 11301879808 1902914800 18.850 99 48 95 1 1944542976 26162416 15465760
17:45:19 6133 8192000000 10865414352 11303288832 1915374992 18.950 100 48 93 1 1957239184 26750672 15113520
17:45:36 7923 8192000000 10882905632 11315552256 1921515120 18.999 100 45 89 4 1964139616 28152208 14472288
17:45:54 7569 8192000000 10860202416 11293380608 1902508960 18.846 99 52 98 4 1949132512 29922912 16700640
17:46:11 4414 8192000000 10867576432 11292786688 1890391136 18.749 99 47 93 1 1937831648 31013088 16427424
17:46:22 3022 8192000000 10880880208 11298316288 1907316112 18.885 100 72 142 0 1962873072 32683184 22873776
17:46:33 3169 8192000000 10866175584 11284045824 1891687360 18.759 99 68 133 1 1945717824 31758576 22271888
17:46:44 2688 8192000000 10904490256 11319054336 1926683104 19.040 100 90 180 3 1988517296 32935888 28898304
17:46:58 3900 8192000000 10866702176 11289964544 1898959760 18.818 99 55 110 1 1944019264 28315952 16743552
17:47:08 13435 8192000000 10839424528 11284672512 1877135312 18.642 98 33 66 1 1911351152 23740960 10474880
17:47:29 7318 8192000000 10864350704 11288784896 1908642384 18.896 100 45 90 0 1939791248 17362960 13785904
17:47:43 17193 8192000000 10837118704 11280846848 1874608160 18.622 98 24 48 2 1901239392 18672208 7959024
17:48:07 6823 8192000000 10856262832 11288711168 1908008128 18.891 100 36 72 2 1938823776 19299952 11515696
17:48:26 6457 8192000000 10872563968 11301163008 1918129520 18.972 100 59 118 0 1960684336 23390576 19164240
17:48:44 8658 8192000000 10856820384 11298607104 1918086464 18.972 100 29 58 0 1951986656 23212400 10687792
17:48:58 20065 8192000000 10850096736 11299815424 1912949536 18.930 100 26 53 2 1945624128 24235456 8439136
17:49:50 15802 8192000000 10866603088 11315314688 1917988704 18.971 100 21 43 3 1950809776 25404608 7416464
17:50:14 8071 8192000000 10873576416 11314421760 1914321472 18.941 99 46 92 2 1954489104 25692240 14475392
17:50:31 21787 8192000000 10879847232 11322101760 1932525744 19.087 100 23 46 1 1961443072 22278288 6639040
17:50:59 8920 8192000000 10887328256 11325358080 1936411728 19.118 100 28 55 2 1968843248 23435408 8996112
17:51:15 16054 8192000000 10882460448 11323080704 1914529008 18.943 99 25 50 2 1947218912 24998944 7690960
17:51:45 26062 8192000000 10897743152 11330879488 1916507696 18.959 99 33 66 1 1957597568 29894192 11195680
17:52:19 10780 8192000000 10874646640 11315036160 1923302624 19.013 100 28 56 1 1956100624 24004640 8793360
17:52:55 21030 8192000000 10885236256 11334025216 1937619408 19.128 100 25 48 3 1971470496 25661808 8189280
17:53:31 86885 8192000000 10867822832 11311554560 1902983504 18.850 98 17 34 0 1929082448 20494704 5604240
17:55:24 48621 8192000000 10864909744 11330756608 1928825232 19.057 100 20 40 1 1966198560 30745664 6627664
17:57:31 24388 8192000000 10895374096 11320926208 1942098672 19.164 100 29 53 2 1963686784 14331920 7256192
17:58:06 10523 8192000000 10897649792 11346411520 1958702544 19.296 100 38 76 2 1988125808 18757760 10665504
17:58:23 24230 8192000000 10893067952 11351904256 1959443808 19.302 100 19 38 0 1984100368 19256384 5400176
17:58:54 34267 8192000000 10876748608 11332968448 1943747520 19.177 99 20 40 1 1967897520 18505920 5644080
17:59:43 162633 8192000000 10864546576 11324858368 1914568768 18.943 98 17 33 0 1935777184 16418128 4790288
18:02:32 42356 8192000000 10858942592 11311357952 1924102080 19.020 99 8 16 0 1933646976 7706368 1838528
18:03:26 38612 8192000000 10874016720 11328278528 1929529984 19.063 99 16 32 0 1942851456 8863536 4457936
18:04:16 39208 8192000000 10866970752 11324932096 1936562720 19.119 99 23 45 1 1955960256 13331568 6065968
18:05:37 68043 8192000000 10881764640 11347415040 1958664672 19.295 100 22 44 0 1973387024 8562160 6160192
18:06:56 63662 8192000000 10897987488 11346870272 1960779648 19.312 100 26 51 3 1975322512 8120736 6422128
18:08:07 7866 8192000000 10890452784 11341160448 1944963568 19.186 99 33 67 2 1963091312 9410992 8716752
18:08:23 18115 8192000000 10902472560 11342614528 1947218896 19.204 99 44 82 1 1968478816 8982064 12277856
18:08:52 19981 8192000000 10893230064 11340271616 1945864496 19.194 99 27 54 1 1961053968 6921360 8268112
18:09:20 11408 8192000000 10895225248 11342815232 1955037104 19.267 99 53 104 1 1977899616 7646320 15216192
18:09:51 53660 8192000000 10887570576 11360686080 1969768688 19.384 100 11 22 0 1986333920 13568016 2997216
18:10:51 59143 8192000000 10900180864 11367866368 1960612848 19.311 99 16 31 1 1974378608 9500096 4265664
18:11:56 49256 8192000000 10913415520 11377946624 1974251056 19.419 99 23 46 0 1992838096 11736672 6850368
18:12:57 57268 8192000000 10912155280 11380793344 1968417776 19.373 99 11 22 1 1986817296 14921664 3477856
18:14:00 48951 8192000000 10894551088 11372363776 1925003616 19.027 97 7 14 0 1943725040 16200784 2520640
18:15:51 92446 8192000000 10911979232 11394715648 1983566144 19.493 100 22 44 0 2013243264 22590656 7086464
18:17:44 97493 8192000000 10911074896 11387060224 1946967216 19.202 98 29 58 1 1974289152 19356608 7965328
18:19:44 70892 8192000000 10918369760 11370147840 1942699632 19.168 98 20 41 1 1961280960 12209952 6371376
18:21:04 63020 8192000000 10899647952 11373850624 1976758240 19.439 100 13 24 2 1990122880 9889168 3475472
18:22:17 78003 8192000000 10926285424 11386404864 1987609136 19.525 100 16 32 0 2006513440 14390208 4514096
18:23:41 55967 8192000000 10930532432 11401486336 2000211824 19.624 100 32 64 2 2025256624 15754032 9290768
18:24:47 90882 8192000000 10937179184 11420479488 1995951232 19.591 100 12 24 1 2018425024 19015488 3458304
18:26:24 82395 8192000000 10933261136 11413032960 1943108816 19.172 97 14 28 0 1974724352 28128304 3487232
18:27:52 80909 8192000000 10926445248 11408044032 1949834272 19.225 98 9 18 0 1975673776 23669968 2169536
18:29:20 129628 8192000000 10925413472 11409715200 1959697568 19.304 98 13 26 0 1974320688 11738384 2884736
18:31:35 84225 8192000000 10845308624 11301634048 1810672784 18.101 91 13 26 2 1831689200 17851728 3164688
18:33:09 82453 8192000000 10875629984 11331059712 1883890432 18.697 96 35 70 3 1905520672 10707728 10922512
18:34:42 117857 8192000000 10870254080 11335651328 1865651584 18.549 96 16 32 0 1879146368 9072112 4422672
18:37:06 858 8192000000 10871825184 11328032768 1934973312 19.107 100 42 86 0 1959353376 12198384 12181680
18:37:13 9092 8192000000 10878060480 11337052160 1945385824 19.190 100 37 73 1 1969227920 13957520 9884576
18:37:34 22023 8192000000 10872194096 11338506240 1939982624 19.147 99 47 96 4 1965020720 10649712 14388384
18:38:18 12341 8192000000 10848015136 11304140800 1901176224 18.836 99 29 58 0 1916419808 6800400 8443184
18:38:37 73810 8192000000 10848937376 11315556352 1894368208 18.781 98 18 36 0 1910399664 11136800 4894656
18:39:57 49265 8192000000 10813973504 11260530688 1855986576 18.471 96 15 30 0 1873216208 12939360 4290272
18:40:58 62325 8192000000 10835012016 11295948800 1855031808 18.463 96 18 36 1 1873059600 12937712 5090080
18:43:51 42364 8192000000 10840763856 11291455488 1884363088 18.700 98 36 69 1 1905990064 11265040 10361936
18:44:40 52663 8192000000 10841167424 11310919680 1917419680 18.966 100 18 36 0 1934109376 11523312 5166384
18:45:46 53744 8192000000 10847301856 11326324736 1872899952 18.608 97 12 24 1 1886824688 10417680 3507056
18:46:49 57536 8192000000 10854360976 11320758272 1892097728 18.763 98 9 17 1 1910404384 15970912 2335744
18:48:02 58823 8192000000 10849762560 11318538240 1882699024 18.687 97 13 26 0 1900898224 14237680 3961520
18:49:08 28438 8192000000 10856240688 11310669824 1898700464 18.816 99 20 40 1 1916000768 11177888 6122416
18:49:45 68179 8192000000 10864161584 11338006528 1940370480 19.150 100 29 58 2 1959162528 10562928 8229120
18:51:07 30865 8192000000 10891461536 11342356480 1947067968 19.203 100 26 53 1 1964149520 10101568 6979984
18:51:48 27124 8192000000 10898272208 11356004352 1960206720 19.308 100 49 98 1 1990031808 16125632 13699456
18:52:37 86746 8192000000 10866017184 11330777088 1884691120 18.703 97 17 33 0 1905005760 15719776 4594864
18:54:11 82010 8192000000 10864555280 11345616896 1901437648 18.838 98 21 41 1 1926065888 18845904 5782336
18:55:39 95567 8192000000 10882363936 11364339712 1926449504 19.038 99 17 34 1 1952241504 21402592 4389408
18:57:26 51868 8192000000 10905111792 11346092032 1919374704 18.982 98 28 56 2 1937728208 11145920 7207584
18:58:32 27999 8192000000 10888014480 11334057984 1902468704 18.846 97 40 80 2 1925590672 11896736 11225232
18:59:08 113298 8192000000 10898023072 11342979072 1955302192 19.269 100 40 79 0 1976562624 10742144 10518288
19:01:11 91147 8192000000 10878078960 11355398144 1923513648 19.015 98 18 37 0 1936726912 8427104 4786160
19:02:51 76214 8192000000 10871712688 11348975616 1924072288 19.019 98 10 20 1 1935068352 7829600 3166464
19:04:13 56606 8192000000 10881988016 11364859904 1961436512 19.317 100 11 21 2 1973479632 8927968 3115152
19:05:24 74795 8192000000 10896636432 11361865728 1917711312 18.969 97 17 34 1 1934472272 11682016 5078944
19:06:46 52038 8192000000 10907556576 11383455744 1974776848 19.423 100 35 70 1 1996844176 11421248 10646080
19:07:52 58370 8192000000 10909823088 11377737728 1924475760 19.023 97 13 26 0 1938974416 11016976 3481680
19:08:57 106191 8192000000 10910398096 11397746688 1981598976 19.477 100 15 30 0 2002708960 16382064 4727920
19:10:50 53830 8192000000 10906955536 11386769408 1983138192 19.490 100 14 26 2 2000355152 13113744 4103216
19:11:52 69055 8192000000 10928188000 11408551936 1993752224 19.573 100 11 22 0 2013401584 16082640 3566720
19:13:07 44464 8192000000 10914862688 11396390912 1986248208 19.514 100 13 26 0 2004868288 15096320 3523760
19:13:58 45378 8192000000 10929967120 11375034368 1946191568 19.196 98 32 64 0 1963869872 8887824 8790480
19:14:49 47282 8192000000 10901473392 11380445184 1964530224 19.342 99 27 54 0 1982931424 10992160 7409040
19:15:43 30812 8192000000 10893130928 11345313792 1901573728 18.839 96 25 49 1 1918021168 9439024 7008416
19:16:24 49829 8192000000 10935134352 11372064768 1901776016 18.841 96 36 71 0 1922174832 10803376 9595440
19:17:22 48993 8192000000 10920034224 11375542272 1947100256 19.203 99 39 78 1 1972018624 14060464 10857904
19:18:18 124997 8192000000 10885281280 11350568960 1897164192 18.803 96 38 76 2 1919538160 11372048 11001920
19:21:00 89047 8192000000 10874901712 11355402240 1940255728 19.149 99 15 30 0 1953310400 8901536 4153136
19:22:52 68072 8192000000 10837582976 11310682112 1886944688 18.721 97 7 14 0 1897511568 8847792 1719088
19:24:07 57214 8192000000 10868451632 11342921728 1923956400 19.019 99 10 20 0 1934667408 7829808 2881200
19:25:52 75122 8192000000 10861249920 11347927040 1913079472 18.931 98 10 20 1 1925950736 9986112 2885152
19:27:25 11014 8192000000 8968683840 9155538944 145819920 1.748 8 2 3 0 147313968 1076944 417104

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 07-04-2021 19:29:05 to 07-04-2021 19:29:36.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-04-2021 19:29:37 to 07-04-2021 19:29:39.

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          238902
MON$OLDEST_ACTIVE               238903
MON$OLDEST_SNAPSHOT             238903
MON$NEXT_TRANSACTION            238903
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                       2020416
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.33442 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33442 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33442 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33442 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 ---
:39: 
:40: mscs-test-161.budzdorov.ru    Wed Apr  7 19:27:39 2021
:41:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:42: 
--- end of diff output ---

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

07.04.21 19:29:40. 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-04-07 19:29:43 No severe PSQL-related problems occured
07.04.21 19:29:44. End of report.