Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.02.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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17169212 kB
MemAvailable 31229304 kB
Buffers 0 kB
Cached 14539984 kB
SwapCached 4876 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-02-07 19:27:16
DTS_END                         2021-02-07 19:27:16.9810
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54182
TRN_ID                          228877
ATT_ID                          615
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: 9074.07 27610 1088888
customer order: creation 160.52 374 19262
customer order: refuse 13.83 368 1659
order to supplier: creation 43.45 1271 5214
order to supplier: removal 3.28 110888 394
invoice (draft): creation 42.59 3384 5111
invoice (draft): removal 53.13 762 6376
invoice accept: apply 39.54 18566 4745
invoice accept: cancel 48.00 775 5760
customer reserve: creation 3669.53 182 440343
customer reserve: removal 4711.93 61 565432
realization accept: apply 77.54 185 9305
realization accept: cancel 89.08 107 10689
payment from customer: creation 56.24 104 6749
payment from customer: removal 5.18 76 622
payment to supplier: creation 45.77 121 5492
payment to supplier: removal 3.18 75 381
service: total inventory turnovers 4.29 1130 515
service: total monetary turnovers 6.13 24 735
service: aggregate perf. data 0.83 19658 100
service: refresh index statistics 0.03 394080 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-02-2021 19:28:48 to 07-02-2021 19:28:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3659
TEST_TIME 2 4831
TEST_TIME 3 3468
TEST_TIME 4 4881
TEST_TIME 5 5261
TEST_TIME 6 5482
TEST_TIME 7 6088
TEST_TIME 8 6114
TEST_TIME 9 6431
TEST_TIME 10 6214
TEST_TIME 11 6141
TEST_TIME 12 6145
TEST_TIME 13 6191
TEST_TIME 14 6216
TEST_TIME 15 6348
TEST_TIME 16 6589
TEST_TIME 17 6761
TEST_TIME 18 6642
TEST_TIME 19 7100
TEST_TIME 20 7578
TEST_TIME 21 7538
TEST_TIME 22 7625
TEST_TIME 23 8141
TEST_TIME 24 8303
TEST_TIME 25 8620
TEST_TIME 26 8713
TEST_TIME 27 8786
TEST_TIME 28 9945
TEST_TIME 29 10432
TEST_TIME 30 10359
TEST_TIME 31 10555
TEST_TIME 32 10470
TEST_TIME 33 10461
TEST_TIME 34 10438
TEST_TIME 35 10165
TEST_TIME 36 9987
TEST_TIME 37 9799
TEST_TIME 38 9749
TEST_TIME 39 9678
TEST_TIME 40 9781
TEST_TIME 41 9647
TEST_TIME 42 9513
TEST_TIME 43 9488
TEST_TIME 44 9483
TEST_TIME 45 9514
TEST_TIME 46 9549
TEST_TIME 47 9551
TEST_TIME 48 9558
TEST_TIME 49 9475
TEST_TIME 50 9527
TEST_TIME 51 9435
TEST_TIME 52 9441
TEST_TIME 53 9525
TEST_TIME 54 9502
TEST_TIME 55 9527
TEST_TIME 56 9570
TEST_TIME 57 9587
TEST_TIME 58 9612
TEST_TIME 59 9558
TEST_TIME 60 9549
TEST_TIME 61 9645
TEST_TIME 62 9627
TEST_TIME 63 9737
TEST_TIME 64 9652
TEST_TIME 65 9520
TEST_TIME 66 9466
TEST_TIME 67 9406
TEST_TIME 68 9362
TEST_TIME 69 9434
TEST_TIME 70 9380
TEST_TIME 71 9352
TEST_TIME 72 9393
TEST_TIME 73 9399
TEST_TIME 74 9352
TEST_TIME 75 9357
TEST_TIME 76 9333
TEST_TIME 77 9367
TEST_TIME 78 9411
TEST_TIME 79 9385
TEST_TIME 80 9391
TEST_TIME 81 9416
TEST_TIME 82 9415
TEST_TIME 83 9437
TEST_TIME 84 9457
TEST_TIME 85 9446
TEST_TIME 86 9373
TEST_TIME 87 9340
TEST_TIME 88 9293
TEST_TIME 89 9305
TEST_TIME 90 9295
TEST_TIME 91 9273
TEST_TIME 92 9208
TEST_TIME 93 9214
TEST_TIME 94 9183
TEST_TIME 95 9181
TEST_TIME 96 9146
TEST_TIME 97 9190
TEST_TIME 98 9279
TEST_TIME 99 9264
TEST_TIME 100 9292
TEST_TIME 101 9285
TEST_TIME 102 9264
TEST_TIME 103 9341
TEST_TIME 104 9364
TEST_TIME 105 9379
TEST_TIME 106 9422
TEST_TIME 107 9410
TEST_TIME 108 9407
TEST_TIME 109 9333
TEST_TIME 110 9275
TEST_TIME 111 9271
TEST_TIME 112 9237
TEST_TIME 113 9191
TEST_TIME 114 9177
TEST_TIME 115 9141
TEST_TIME 116 9123
TEST_TIME 117 9083
TEST_TIME 118 9106
TEST_TIME 119 9080
TEST_TIME 120 9080

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-02-2021 19:28:51 to 07-02-2021 19:28:55.

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 1496781 1496781 0 0.00 0 42203 6 0 0
doc_list_biud 1496779 1496779 0 0.00 0 33347 29 0 0
sp_add_invoice_to_stock 4860 4745 115 2.36 48 168597 18566 0 115
sp_cancel_adding_invoice 5760 5760 0 0.00 3 79116 775 0 0
sp_cancel_client_order 1659 1659 0 0.00 4 9306 369 0 0
sp_cancel_customer_reserve 565432 565432 0 0.00 1 29804 61 0 0
sp_cancel_pay_from_customer 622 622 0 0.00 3 4192 76 0 0
sp_cancel_pay_to_supplier 381 381 0 0.00 2 2371 75 0 0
sp_cancel_supplier_invoice 6379 6376 3 0.04 1 16503 762 0 3
sp_cancel_supplier_order 394 394 0 0.00 8 1042780 110888 0 0
sp_cancel_write_off 10689 10689 0 0.00 1 11363 108 0 0
sp_client_order 19262 19262 0 0.00 4 32299 374 0 0
sp_customer_reserve 440343 440343 0 0.00 0 94614 182 0 0
sp_fill_shopping_cart 29577 29577 0 0.00 1 10053 39 0 0
sp_fill_shopping_cart_clo_res 440337 440337 0 0.00 0 21092 14 0 0
sp_get_clo_for_invoice 4739 4739 0 0.00 0 24205 323 0 0
sp_kill_cost_storno 17452 17452 0 0.00 0 7186 55 0 0
sp_kill_qstorno_ret_qs2qd 1148323 1148323 0 0.00 0 29798 33 0 0
sp_kill_qty_storno 604354 604354 0 0.00 0 33346 71 0 0
sp_lock_selected_doc 19538 19538 0 0.00 0 8539 5 0 0
sp_make_cost_storno 26285 26285 0 0.00 0 42187 59 0 0
sp_multiply_rows_for_pdistr 26285 26285 0 0.00 0 6863 26 0 0
sp_multiply_rows_for_qdistr 19262 19262 0 0.00 0 18727 172 0 0
sp_pay_from_customer 6749 6749 0 0.00 4 14799 105 0 0
sp_pay_to_supplier 5492 5492 0 0.00 4 17262 122 0 0
sp_payment_common 12241 12241 0 0.00 1 12672 26 0 0
sp_qd_handle_on_cancel_clo 1659 1659 0 0.00 0 9270 336 0 0
sp_qd_handle_on_invoice_upd_sts 10499 10499 0 0.00 0 33345 336 0 0
sp_qd_handle_on_reserve_upd_sts 9305 9305 0 0.00 0 16074 63 0 0
sp_reserve_write_off 9305 9305 0 0.00 6 16101 185 0 0
sp_supplier_invoice 5111 5111 0 0.00 6 72527 3384 0 0
sp_supplier_order 5214 5214 0 0.00 5 62180 1272 0 0
srv_aggregate_perf_data 100 100 0 0.00 2808 179847 19659 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1375 137287 34323 0 0
srv_find_qd_qs_mism 1043952 1043952 0 0.00 0 16921 5 0 0
srv_make_invnt_saldo 515 515 0 0.00 32 36465 1131 0 0
srv_make_money_saldo 735 735 0 0.00 1 865 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 216344 589184 394080 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4745 4745 0 0.00 0 24330 179 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 2130 92 0 0
t$perf-norm:sp_cancel_client_order 1659 1659 0 0.00 0 2171 9 0 0
t$perf-norm:sp_cancel_customer_reserve 665 665 0 0.00 0 698 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 622 622 0 0.00 0 3212 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 381 381 0 0.00 0 1079 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 1768 21 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 27400 1639 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 1811 12 0 0
t$perf-norm:sp_client_order 19262 19262 0 0.00 0 9641 17 0 0
t$perf-norm:sp_customer_reserve 945 945 0 0.00 0 863 7 0 0
t$perf-norm:sp_pay_from_customer 6749 6749 0 0.00 0 7085 10 0 0
t$perf-norm:sp_pay_to_supplier 5492 5492 0 0.00 0 5963 9 0 0
t$perf-norm:sp_reserve_write_off 9305 9305 0 0.00 0 19853 12 0 0
t$perf-norm:sp_supplier_invoice 5111 5111 0 0.00 0 3853 19 0 0
t$perf-norm:sp_supplier_order 5214 5214 0 0.00 0 19815 22 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 495 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 187 2 0 0
t$perf-norm:srv_make_invnt_saldo 515 515 0 0.00 0 9445 40 0 0
t$perf-norm:srv_make_money_saldo 735 735 0 0.00 0 2298 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9708 9478 230 2.36 0 7274 21 0 230
v_all_customers 35642 35642 0 0.00 0 17 1 0 0
v_all_suppliers 28674 28674 0 0.00 0 20 1 0 0
v_all_wares 38524 38524 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 3613 11 0 0
v_cancel_client_order 3318 3318 0 0.00 0 4480 7 0 0
v_cancel_customer_prepayment 1244 1244 0 0.00 0 1291 6 0 0
v_cancel_customer_reserve 1330 1330 0 0.00 0 1669 5 0 0
v_cancel_payment_to_supplier 762 762 0 0.00 0 1801 6 0 0
v_cancel_supplier_invoice 764 758 6 0.78 0 1632 17 0 6
v_cancel_supplier_order 788 788 0 0.00 0 4743 11 0 0
v_cancel_write_off 2048 2048 0 0.00 0 4519 20 0 0
v_max_id_clo_ord 5211 5211 0 0.00 0 1580 2 0 0
v_max_id_clo_res 945 945 0 0.00 0 3889 22 0 0
v_max_id_ord_sup 5104 5104 0 0.00 0 5081 6 0 0
v_max_non_paid_invoice 1470 1470 0 0.00 0 1808 4 0 0
v_max_non_paid_realizn 3401 3401 0 0.00 0 863 3 0 0
v_min_id_clo_ord 5211 5211 0 0.00 0 2608 7 0 0
v_min_id_clo_res 945 945 0 0.00 0 3389 6 0 0
v_min_id_ord_sup 5104 5104 0 0.00 0 8836 6 0 0
v_min_non_paid_invoice 5492 5492 0 0.00 0 5815 16 0 0
v_min_non_paid_realizn 6749 6749 0 0.00 0 12651 17 0 0
v_our_firm 9578 9578 0 0.00 0 12 1 0 0
v_reserve_write_off 18610 18610 0 0.00 0 3961 8 0 0
x_lock_depdocs_on_canc_invoice 11757 11757 0 0.00 0 29355 137 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 7916 357 0 0
x_make_qstorno_1000_1200 5214 5214 0 0.00 1 61852 1193 0 0
x_make_qstorno_1200_2000 5111 5111 0 0.00 2 72502 3244 0 0
x_make_qstorno_2100_3300 440343 440343 0 0.00 0 94613 166 0 0

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

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:20 12 8192000000 8818355392 8833900544 21188080 0.257 4 4 6 0 21500064 88016 223968
16:57:27 5305 8192000000 10017148688 10282647552 785670848 8.751 65 50 108 0 804990848 2180656 17139344
16:57:50 32826 8192000000 10337770496 10650931200 1373660336 14.360 100 90 180 1 1406481360 4227760 28593264
16:58:40 26692 8192000000 10366111184 10683482112 1420058800 14.773 100 87 174 0 1455094928 6446912 28589216
16:59:25 41239 8192000000 10421776960 10746499072 1469685824 15.211 100 90 180 0 1506956688 7840048 29430816
17:00:20 20362 8192000000 10440346592 10770329600 1492937152 15.415 100 90 179 1 1530489392 8715792 28836448
17:00:52 25086 8192000000 10460994848 10798886912 1524179424 15.687 100 81 162 1 1558638464 9275376 25183664
17:01:25 18620 8192000000 10492944288 10834038784 1542041984 15.841 100 84 168 3 1578245824 9779296 26424544
17:01:54 13357 8192000000 10528882608 10878439424 1576951680 16.142 100 83 164 2 1611975456 10178032 24845744
17:02:19 12927 8192000000 10554661728 10911657984 1605939936 16.390 100 76 152 0 1639454000 10800304 22713760
17:02:39 10679 8192000000 10573688544 10928537600 1629905168 16.594 100 83 166 0 1666098080 11553360 24639552
17:02:57 9795 8192000000 10570258064 10932965376 1634035344 16.629 100 74 149 0 1667468368 11321904 22111120
17:03:14 9657 8192000000 10591402720 10956279808 1648108240 16.748 100 74 148 2 1681500272 11737248 21654784
17:03:37 9437 8192000000 10606328480 10976022528 1671791104 16.948 100 76 150 2 1705111072 11367808 21952160
17:03:55 9161 8192000000 10636711472 11005227008 1693507056 17.131 100 75 150 0 1727028080 11918064 21602960
17:04:14 6422 8192000000 10648740832 11017302016 1709779360 17.267 100 78 152 4 1744621536 13091280 21750896
17:04:28 7894 8192000000 10659575280 11031134208 1723126032 17.378 100 80 161 2 1759546624 14196880 22223712
17:04:43 8933 8192000000 10670105648 11042566144 1735038016 17.477 100 86 170 1 1772867216 13790832 24038368
17:05:02 6289 8192000000 10687635536 11061448704 1742798048 17.542 100 81 161 0 1779485600 13878144 22809408
17:05:15 4959 8192000000 10680507056 11062542336 1753396752 17.630 100 74 148 0 1787737728 12901824 21439152
17:05:27 4632 8192000000 10691028064 11074215936 1763185808 17.711 100 72 144 1 1795368016 11127824 21054384
17:05:39 5496 8192000000 10706627584 11089653760 1769543728 17.763 100 67 132 0 1799991920 11585680 18862512
17:05:53 3794 8192000000 10720351552 11098669056 1786997552 17.907 100 84 168 0 1821990480 11407040 23585888
17:06:03 7671 8192000000 10720424784 11110334464 1789054976 17.924 100 69 138 2 1824842224 16732336 19054912
17:06:19 3553 8192000000 10732009904 11121766400 1797453568 17.993 100 76 153 0 1831461344 12484160 21523616
17:06:29 1849 8192000000 10748691248 11136528384 1811740416 18.110 100 87 174 1 1849845968 12956480 25149072
17:06:38 2758 8192000000 10751938704 11142402048 1818320624 18.164 100 81 162 0 1854135328 12980976 22833728
17:06:49 3692 8192000000 10766673472 11152551936 1827608480 18.240 100 89 179 4 1866940288 13960112 25371696
17:07:00 3020 8192000000 10769724976 11158556672 1835561088 18.305 100 85 173 1 1871223984 11353824 24309072
17:07:10 2562 8192000000 10783578640 11165265920 1837959696 18.324 100 94 186 3 1878130656 14348672 25822288
17:07:19 2218 8192000000 10794523296 11178065920 1847074192 18.398 100 92 185 1 1887101328 13940816 26086320
17:07:28 1766 8192000000 10793738320 11177140224 1847747664 18.404 100 87 173 0 1886646176 14509232 24389280
17:07:36 2542 8192000000 10790470800 11183673344 1854112720 18.456 100 87 176 0 1890739616 12629616 23997280
17:07:46 2865 8192000000 10797023408 11185152000 1857047984 18.479 100 82 163 0 1892015200 12426256 22540960
17:07:56 1419 8192000000 10803318784 11192131584 1861457328 18.515 100 87 173 2 1898508560 12603424 24447808
17:08:04 1095 8192000000 10811233472 11197460480 1868151024 18.569 100 93 186 0 1907316736 13315424 25850288
17:08:12 2104 8192000000 10816640992 11201994752 1865223152 18.546 100 93 185 1 1905633248 14331472 26078624
17:08:21 1201 8192000000 10816183968 11201839104 1867490544 18.564 100 88 175 2 1907340320 14930624 24919152
17:08:29 2022 8192000000 10814319088 11204939776 1875316016 18.627 100 91 183 1 1915278560 14064976 25897568
17:08:37 1761 8192000000 10817683312 11207749632 1875584464 18.629 100 88 174 1 1912699760 11972000 25143296
17:08:45 35356 8192000000 10799235232 11206250496 1873232128 18.610 100 61 121 0 1900197824 9370288 17595408
17:09:48 1489 8192000000 10822645248 11216453632 1881587072 18.678 100 87 173 0 1915959440 8442144 25930224
17:09:55 1026 8192000000 10824690752 11218169856 1879591440 18.662 100 75 151 1 1910263920 8942144 21730336
17:10:03 2499 8192000000 10826213120 11217543168 1880705312 18.671 100 80 160 3 1913089296 9422736 22961248
17:10:12 5314 8192000000 10822452992 11226910720 1882519856 18.685 100 80 160 1 1917748560 12159248 23069456
17:10:24 4377 8192000000 10812346752 11221270528 1882147376 18.682 100 57 114 1 1910362752 12311088 15904288
17:10:35 3819 8192000000 10794217248 11213488128 1878189424 18.650 100 45 90 3 1900793504 9826640 12777440
17:10:48 3263 8192000000 10806324160 11222085632 1881788832 18.680 100 42 84 2 1901916000 8002224 12124944
17:11:00 6079 8192000000 10797433344 11220254720 1880966656 18.673 100 38 76 0 1899630000 8008064 10655280
17:11:12 6051 8192000000 10804250752 11222138880 1880079456 18.666 100 30 60 2 1896546864 8195936 8271472
17:11:26 8363 8192000000 10795339664 11219419136 1882945568 18.689 100 31 62 2 1899211376 7436496 8829312
17:11:46 8613 8192000000 10787244128 11219709952 1883367888 18.692 100 31 62 3 1899098704 6396416 9334400
17:12:02 6868 8192000000 10791897200 11221663744 1881233136 18.675 100 16 32 1 1891534112 5901600 4399376
17:12:17 5598 8192000000 10796198416 11225591808 1886291312 18.716 100 21 42 0 1897524080 4993776 6238992
17:12:33 3905 8192000000 10804004640 11231879168 1889988944 18.746 100 32 65 3 1910008176 9910672 10108560
17:12:50 3516 8192000000 10809402400 11232997376 1890533328 18.750 100 34 69 0 1906190464 5910304 9746832
17:13:05 8649 8192000000 10805913152 11230588928 1890263872 18.748 100 24 48 2 1903557664 6305216 6988576
17:13:20 7955 8192000000 10796148080 11231514624 1893476960 18.774 100 23 46 0 1906289024 6072448 6739616
17:13:37 8470 8192000000 10803873968 11235467264 1894991856 18.786 100 35 70 2 1911868112 7000976 9875280
17:13:54 61129 8192000000 10822127008 11248775168 1901583888 18.839 100 34 68 0 1917026976 5177664 10265424
17:15:03 9101 8192000000 10810025664 11246465024 1900575472 18.831 100 27 54 0 1914674176 6240784 7857920
17:15:20 4591 8192000000 10828932016 11248672768 1901012960 18.834 100 31 62 2 1916185888 5992512 9180416
17:15:36 5134 8192000000 10825655264 11256590336 1901460800 18.838 100 27 49 3 1919145712 9936800 7748112
17:15:47 4927 8192000000 10826941600 11254845440 1904961536 18.866 100 37 73 2 1921107888 6169248 9977104
17:16:00 5789 8192000000 10820544080 11250044928 1905952384 18.874 100 33 66 0 1922873296 6732336 10188576
17:16:12 4225 8192000000 10831576416 11259666432 1907905648 18.890 100 31 62 2 1923295888 6569264 8820976
17:16:23 7437 8192000000 10822038960 11254566912 1889772800 18.744 99 24 47 3 1907276384 10048880 7454704
17:16:37 7698 8192000000 10807134384 11242332160 1885917248 18.713 99 25 51 0 1898343264 4854272 7571744
17:16:52 9476 8192000000 10798740400 11229646848 1878219616 18.651 99 15 30 0 1887379808 5130096 4030096
17:17:11 8722 8192000000 10807009504 11243327488 1886331856 18.716 99 24 46 1 1898754128 5699344 6722928
17:17:26 9976 8192000000 10796140592 11232223232 1846109824 18.391 97 19 37 2 1856944720 5706800 5128096
17:17:42 9646 8192000000 10775901408 11208663040 1850953792 18.430 98 23 46 0 1867132976 9831248 6347936
17:17:58 15711 8192000000 10777517872 11209019392 1823719520 18.208 97 13 26 2 1832894336 5420896 3753920
17:18:20 64378 8192000000 10754739392 11174596608 1744714320 17.558 93 24 47 1 1755953952 4991872 6247760
17:19:31 14412 8192000000 10757145792 11182493696 1783229568 17.876 96 15 30 1 1796568832 9196448 4142816
17:19:53 6605 8192000000 10699172016 11107745792 1720054256 17.353 94 39 78 0 1739354752 7845344 11455152
17:20:10 4682 8192000000 10725797264 11137466368 1768738496 17.757 97 28 56 1 1784212064 6626784 8846784
17:20:24 5554 8192000000 10735638512 11152605184 1786754624 17.905 98 33 66 0 1803307312 6425216 10127472
17:20:39 6100 8192000000 10712985664 11120533504 1758549008 17.672 97 33 66 3 1774756688 6299392 9908288
17:20:51 7224 8192000000 10708580080 11117871104 1745136512 17.561 97 23 45 1 1756891712 5383712 6371488
17:21:05 5689 8192000000 10699116512 11108384768 1764966576 17.725 98 39 78 3 1782872976 6341088 11565312
17:21:18 9424 8192000000 10683375040 11085881344 1724336288 17.388 97 32 64 0 1739161808 4782336 10043184
17:21:36 8426 8192000000 10691366496 11101642752 1719861584 17.351 96 25 50 1 1732880064 5593504 7424976
17:21:51 6641 8192000000 10707341072 11120803840 1757773168 17.666 98 40 80 0 1779721440 9902880 12045392
17:22:06 12060 8192000000 10711723552 11139563520 1774893984 17.807 98 28 56 1 1788998976 6302576 7802416
17:22:25 9354 8192000000 10733835504 11149717504 1796680560 17.987 99 26 48 1 1813323376 9539776 7103040
17:22:43 5458 8192000000 10724265856 11147333632 1799128480 18.007 99 29 58 1 1813413744 5911808 8373456
17:22:55 6697 8192000000 10737709264 11160227840 1806394912 18.066 99 27 52 2 1819984880 6181936 7408032
17:23:09 8310 8192000000 10771200704 11169103872 1838486912 18.328 100 61 123 1 1859339840 4178848 16674080
17:23:24 66157 8192000000 10745839072 11172409344 1805102512 18.056 98 24 48 0 1817543392 4942880 7498000
17:24:36 7716 8192000000 10744056576 11175419904 1838166720 18.326 100 28 56 1 1852637568 6723920 7746928
17:24:52 10233 8192000000 10782100144 11197607936 1849959920 18.422 100 27 54 2 1863256496 5595248 7701328
17:25:10 5759 8192000000 10778082688 11203538944 1858096992 18.488 100 30 59 1 1872978144 7175472 7705680
17:25:25 4452 8192000000 10774504208 11203371008 1862410128 18.523 100 40 80 3 1881979488 7894544 11674816
17:25:37 5812 8192000000 10776069824 11205410816 1860393680 18.506 100 26 52 0 1873455744 5580496 7481568
17:25:50 6120 8192000000 10770489088 11201757184 1862217072 18.521 100 23 46 1 1875078816 6141488 6720256
17:26:04 7489 8192000000 10781173328 11211059200 1869255968 18.578 100 23 46 0 1882008896 5729520 7023408
17:26:18 6818 8192000000 10789960960 11214225408 1868306208 18.571 100 29 58 0 1883977328 6307680 9363440
17:26:33 10760 8192000000 10792424496 11219177472 1868690112 18.574 100 18 36 0 1879996592 5111952 6194528
17:26:50 11110 8192000000 10809118976 11225612288 1876767680 18.639 100 35 70 0 1892305536 4775424 10762432
17:27:09 25429 8192000000 10822619088 11243360256 1895595424 18.791 100 20 40 1 1905914096 4306368 6012304
17:27:42 28140 8192000000 10837896032 11260641280 1913103552 18.932 100 46 92 0 1934148432 7221280 13823600
17:28:20 17995 8192000000 10870247152 11285225472 1918624048 18.976 100 42 84 0 1941909776 11153680 12132048
17:28:46 46059 8192000000 10856322592 11282333696 1927132688 19.044 100 45 90 2 1950659152 11128688 12397776
17:29:51 78649 8192000000 10875727120 11302031360 1938052656 19.131 100 47 94 2 1964826816 12992064 13782096
17:31:17 1906 8192000000 10885897584 11310915584 1945237296 19.189 100 67 134 1 1979663728 14368768 20057664
17:31:29 4735 8192000000 10899378928 11305664512 1953009072 19.250 100 61 121 3 1982817776 12864016 16944688
17:31:45 21532 8192000000 10887917152 11320623104 1954261296 19.260 100 57 110 0 1982708976 13133008 15314672
17:32:15 12430 8192000000 10896157856 11324198912 1959833072 19.305 100 65 130 2 1992635504 14115760 18686672
17:32:36 33650 8192000000 10894976672 11333402624 1961253888 19.316 100 38 76 1 1984920304 13211168 10455248
17:33:18 6762 8192000000 10905145600 11341692928 1970966480 19.393 100 42 83 1 1998127872 15240320 11921072
17:33:33 17404 8192000000 10918595184 11352780800 1977952560 19.448 100 52 103 3 2009502288 16870592 14679136
17:34:01 13994 8192000000 10920080096 11358654464 1980791264 19.471 100 43 86 2 2010534816 17250656 12492896
17:34:22 8394 8192000000 10925504352 11361406976 1987693824 19.526 100 48 94 4 2018982352 16908784 14379744
17:34:39 3948 8192000000 10927483024 11363483648 1992042160 19.560 100 40 80 0 2019848720 16140816 11665744
17:34:51 20153 8192000000 10912313408 11345559552 1962156672 19.323 99 64 125 2 1999072592 19217648 17698272
17:35:24 5331 8192000000 10939783920 11360624640 1986264336 19.514 100 69 133 2 2028094176 22020016 19809824
17:35:37 7302 8192000000 10936859440 11365695488 1993075392 19.568 100 63 126 3 2035560176 23577344 18907440
17:35:52 3101 8192000000 10946149424 11375042560 1993453728 19.571 100 64 128 0 2036421008 22850512 20116768
17:36:04 10572 8192000000 10949454048 11377487872 1995735024 19.589 100 59 116 4 2037415616 24841792 16838800
17:36:29 3765 8192000000 10951605216 11386564608 2001354160 19.633 100 50 98 0 2040684240 24516768 14813312
17:36:43 10055 8192000000 10949007584 11387404288 2005008832 19.662 100 58 115 2 2047375952 25154800 17212320
17:37:01 11838 8192000000 10952093872 11390988288 2009821808 19.700 100 51 102 0 2045652096 20317664 15512624
17:37:37 14776 8192000000 10959501936 11393925120 2013749488 19.731 100 55 109 1 2049504448 20445440 15309520
17:38:00 3035 8192000000 10973425968 11407204352 2021198352 19.790 100 59 118 0 2059770128 21209648 17362128
17:38:10 5940 8192000000 10969364256 11405459456 2021178608 19.789 100 53 103 1 2057370976 21165744 15026624
17:38:24 8318 8192000000 10966382560 11400929280 2020787648 19.786 100 46 92 1 2055519136 21301632 13429856
17:38:45 13501 8192000000 10966621568 11408343040 2023519536 19.808 100 46 92 2 2058798048 21929056 13349456
17:39:10 10644 8192000000 10972896896 11414233088 2025291776 19.822 100 50 96 2 2059962624 20480976 14189872
17:39:27 4245 8192000000 10980924320 11415580672 2025917152 19.827 100 73 145 3 2069098144 21772272 21408720
17:39:40 12733 8192000000 10959705056 11397660672 2004765872 19.660 99 51 102 1 2044222928 24326640 15130416
17:40:12 15614 8192000000 10983749264 11426988032 2028801824 19.849 100 49 98 0 2074398960 30138224 15458912
17:40:37 8249 8192000000 10984551504 11424522240 2025730032 19.825 100 48 95 1 2070751952 29902832 15119088
17:40:54 4424 8192000000 10983476864 11421843456 2025856784 19.826 100 49 98 1 2070445296 29471200 15117312
17:41:07 2504 8192000000 10993424544 11412570112 2014958160 19.741 99 78 154 1 2067881472 29510992 23412320
17:41:17 14414 8192000000 10983019456 11418185728 2021081872 19.789 100 54 108 2 2068532688 30524288 16926528
17:41:43 3443 8192000000 10962488448 11388850176 1988749984 19.534 98 62 122 1 2041013232 33533120 18730128
17:41:53 7785 8192000000 10988853616 11419234304 2019073760 19.773 100 63 126 0 2073166048 34627728 19464560
17:42:08 1906 8192000000 10989451600 11416170496 2018045728 19.765 100 74 144 2 2075537216 35204064 22287424
17:42:17 13933 8192000000 10989030672 11416862720 2014548912 19.737 100 66 131 0 2072309408 37573824 20186672
17:42:39 2841 8192000000 11006757088 11433721856 2027872240 19.842 100 78 156 0 2093259824 40728208 24659376
17:42:50 4254 8192000000 10997603760 11422994432 2017226720 19.758 100 68 136 1 2078424912 40612720 20585472
17:43:01 3615 8192000000 10988171104 11417141248 2003847760 19.653 99 81 160 2 2070305856 41805536 24652560
17:43:16 5609 8192000000 11009616576 11434823680 2025203120 19.821 100 73 143 4 2092406832 44470336 22733376
17:43:35 2815 8192000000 10998380272 11425693696 2019437152 19.776 100 67 135 0 2083339616 42257168 21645296
17:43:46 2472 8192000000 11007015984 11436007424 2025735808 19.825 100 60 119 0 2088795040 44547472 18511760
17:43:56 6449 8192000000 10996848672 11425910784 2000694528 19.628 99 69 138 2 2071177760 49358496 21124736
17:44:22 3395 8192000000 10977588848 11401371648 1989932336 19.543 99 72 144 0 2059863536 46281856 23649344
17:44:33 4882 8192000000 10987773360 11409813504 1983708752 19.494 99 70 140 2 2055124784 48734256 22681776
17:44:46 4086 8192000000 10983575568 11405201408 1994230928 19.577 100 74 147 2 2066770192 48502864 24036400
17:44:58 3314 8192000000 10982091392 11404828672 1984161888 19.498 99 74 147 2 2054412256 46500880 23749488
17:45:08 2989 8192000000 10966339024 11387019264 1978455328 19.452 100 75 149 0 2051060464 47960944 24644192
17:45:23 7432 8192000000 10978167888 11400863744 1978537872 19.453 99 71 141 1 2051254384 50425728 22290784
17:45:38 6749 8192000000 10981364640 11402928128 1975414416 19.428 99 73 144 1 2051003824 52835872 22753536
17:45:54 3794 8192000000 10984336080 11398758400 1972506672 19.405 99 79 156 1 2051480240 54647760 24325808
17:46:06 4492 8192000000 10978425456 11400282112 1973907712 19.416 99 87 174 0 2060893664 58903648 28082304
17:46:17 6228 8192000000 10962000096 11382870016 1966442832 19.357 100 72 144 0 2050734272 60916816 23374624
17:46:36 2077 8192000000 10982718944 11401568256 1967691552 19.367 99 81 161 0 2051423424 58509056 25222816
17:46:46 1447 8192000000 10979283952 11402174464 1981611632 19.477 100 74 148 0 2060768000 55303776 23852592
17:46:57 7946 8192000000 10996975520 11413213184 1995231024 19.585 100 74 144 1 2073691168 55375120 23085024
17:47:14 1483 8192000000 11011171776 11425206272 2004581840 19.659 100 85 169 0 2088135840 56780688 26773312
17:47:23 1374 8192000000 11010801536 11423916032 2010537424 19.706 100 94 191 0 2092671888 52496160 29638304
17:47:31 2062 8192000000 11009114224 11422859264 2013022928 19.725 100 80 161 0 2089827568 50565696 26238944
17:47:41 1995 8192000000 11014643616 11428605952 2015273664 19.743 100 92 184 0 2095741152 52017696 28449792
17:47:49 3443 8192000000 10996106944 11416924160 1984994416 19.504 99 76 151 3 2062090928 52897856 24198656
17:48:00 5050 8192000000 10964504048 11390222336 1971835888 19.400 99 61 119 3 2042260448 51902656 18521904
17:48:11 6650 8192000000 10957931040 11389124608 1968312464 19.372 99 49 98 0 2035940320 51662528 15965328
17:48:24 7663 8192000000 10966653184 11396141056 1947747856 19.209 98 54 108 0 2017816112 52611712 17456544
17:48:46 3194 8192000000 10957924080 11375083520 1942334768 19.165 98 72 144 2 2020212800 54756512 23121520
17:48:57 4322 8192000000 10990604224 11412021248 1985950416 19.512 100 83 166 0 2070764336 57325744 27488176
17:49:09 3245 8192000000 10982747760 11412549632 1982223408 19.482 100 57 114 3 2064921600 63432112 19266080
17:49:26 14353 8192000000 10979966432 11419058176 1990194176 19.545 100 46 92 3 2069739152 63227376 16317600
17:50:00 8735 8192000000 10981911840 11426410496 1974006112 19.417 99 45 91 0 2056945872 67335680 15604080
17:50:18 19354 8192000000 10972500992 11418648576 1989386320 19.539 100 43 86 1 2058155552 54059312 14709920
17:50:55 18431 8192000000 10987236160 11420995584 1997461328 19.603 100 56 111 2 2070826848 54629232 18736288
17:51:27 17720 8192000000 10966260144 11421077504 1992336784 19.562 100 31 62 1 2059117200 55821728 10958688
17:51:55 13987 8192000000 10952578608 11402153984 1978088576 19.450 100 35 70 2 2045839664 55009264 12741824
17:52:18 16526 8192000000 10931701216 11374784512 1934833872 19.106 98 30 60 0 1999245232 53571360 10840000
17:53:10 16151 8192000000 10939104720 11391225856 1938156320 19.132 99 26 52 2 2002648752 55601920 8890512
17:53:40 21370 8192000000 10917796240 11375280128 1923974016 19.019 99 23 46 0 1992270640 59636112 8660512
17:54:11 11447 8192000000 10916132496 11388456960 1941080960 19.155 100 17 34 3 2007952144 60310384 6560800
17:54:29 6651 8192000000 10921502208 11392360448 1940420448 19.150 100 17 34 1 2006071072 59176208 6474416
17:54:42 19310 8192000000 10929999696 11374407680 1921733120 19.001 99 33 66 1 1996993328 63486640 11773568
17:55:17 24884 8192000000 10912839552 11391729664 1941626336 19.160 100 15 30 2 2005537632 57293104 6618192
17:55:53 11632 8192000000 10869870880 11319005184 1892795632 18.768 98 26 52 0 1931190192 30403392 7991168
17:56:14 33599 8192000000 10841054416 11301883904 1882769568 18.687 98 10 20 1 1900504032 14929568 2804896
17:56:54 85325 8192000000 10873315696 11343376384 1894703392 18.784 98 13 25 1 1922371984 23713120 3955472
17:58:26 56094 8192000000 10878286080 11324452864 1867019376 18.560 96 14 28 0 1882634816 12170864 3444576
17:59:29 98606 8192000000 10880138768 11335729152 1874452432 18.620 97 13 26 0 1888934400 11784560 2697408
18:01:31 91069 8192000000 10853501296 11307843584 1887183792 18.723 97 12 24 0 1903529696 12967392 3378512
18:03:14 92057 8192000000 10882604720 11327713280 1918961072 18.979 98 52 100 3 1940842272 7645424 14235776
18:04:53 9253 8192000000 10890691680 11328258048 1926240512 19.037 99 42 83 1 1946723520 8595648 11887360
18:05:08 52991 8192000000 10870845808 11333160960 1928437504 19.054 99 17 34 1 1941485632 8583360 4464768
18:06:08 35732 8192000000 10880389744 11346358272 1958887712 19.297 100 33 66 1 1982931632 14066400 9977520
18:07:13 47043 8192000000 10878997504 11350474752 1934470400 19.103 99 9 18 0 1948578496 11461088 2647008
18:08:09 59782 8192000000 10904168400 11369168896 1946806288 19.201 99 21 42 1 1967455040 14164784 6483968
18:09:52 83558 8192000000 10903598960 11369537536 1925745104 19.033 97 17 34 2 1952141584 20962928 5433552
18:11:56 35764 8192000000 10908306064 11375796224 1966721616 19.359 100 21 41 0 1996066928 22885536 6459776
18:12:58 99018 8192000000 10885698912 11350757376 1929369504 19.062 98 16 30 0 1946849728 13127440 4352784
18:14:45 59387 8192000000 10870800416 11354595328 1942176048 19.164 99 11 22 0 1956658784 11837408 2645328
18:15:51 50471 8192000000 10892434720 11361198080 1958713600 19.296 100 12 24 1 1970611408 8888720 3009088
18:17:12 72389 8192000000 10885061008 11364892672 1958342112 19.293 99 18 36 0 1975467120 11956560 5168448
18:18:36 74953 8192000000 10929039488 11391401984 1990486224 19.548 100 24 48 0 2017670064 20238736 6945104
18:19:58 91030 8192000000 10926965968 11385856000 1956081712 19.275 98 29 58 0 1976524624 12543632 7899280
18:21:38 13700 8192000000 10921917008 11382255616 1972245744 19.403 99 41 82 2 1994688288 11252800 11189744
18:22:04 86148 8192000000 10886519120 11374522368 1900379280 18.829 96 18 36 0 1919635072 14456736 4799056
18:23:36 84559 8192000000 10873940688 11348123648 1918909840 18.978 97 30 60 2 1939081728 11187200 8984688
18:25:15 71939 8192000000 10906173472 11376726016 1968461952 19.373 100 10 20 0 1980802000 9907312 2432736
18:26:33 50905 8192000000 10944746704 11395629056 1989603504 19.541 100 26 52 1 2005682896 9362640 6716752
18:27:32 86475 8192000000 10909126560 11389255680 1933735168 19.097 97 19 38 1 1953463216 14410992 5317056
18:29:08 111598 8192000000 10897966896 11378601984 1919726016 18.985 97 6 12 1 1935689456 14575792 1387648
18:31:06 137286 8192000000 10912913824 11378622464 1940605792 19.152 98 24 46 1 1961037008 13518416 6912800
18:33:42 32323 8192000000 10893763600 11355045888 1954866560 19.265 99 21 41 3 1974522624 13957344 5698720
18:34:34 54716 8192000000 10868596384 11345240064 1885302448 18.708 96 19 38 2 1907938240 17013344 5622448
18:35:41 43614 8192000000 10863903984 11358867456 1939223872 19.141 100 5 10 0 1963895040 23315296 1355872
18:36:31 49593 8192000000 10905363200 11372789760 1959253920 19.300 100 15 30 1 1973491696 10408320 3829456
18:37:28 42889 8192000000 10891037408 11362914304 1951870720 19.241 98 26 51 1 1972628880 13905072 6853088
18:38:18 62424 8192000000 10885434064 11384389632 1941258688 19.157 98 12 24 0 1958127184 12897792 3970704
18:39:37 91935 8192000000 10882300736 11350683648 1822193616 18.196 92 8 16 0 1835194896 10820624 2180656
18:41:18 39761 8192000000 10901716736 11353985024 1954727488 19.264 100 47 93 2 1978153888 10417536 13008864
18:42:08 30849 8192000000 10888453968 11348901888 1902430352 18.846 97 45 88 1 1926508032 12219408 11858272
18:42:55 47826 8192000000 10859687920 11324018688 1870765648 18.590 96 25 50 1 1893871408 16281168 6824592
18:43:54 68091 8192000000 10879051248 11346866176 1920181424 18.988 99 20 40 0 1936358464 10594576 5582464
18:45:08 44637 8192000000 10884802304 11348811776 1944691248 19.184 100 24 48 0 1962109424 10446608 6971568
18:46:01 78564 8192000000 10869703600 11342041088 1883175616 18.691 96 24 48 2 1900376272 10429664 6770992
18:47:35 55785 8192000000 10891967776 11357601792 1894062896 18.779 97 18 36 0 1911795920 12829712 4903312
18:48:44 63906 8192000000 10894035328 11353542656 1936308704 19.117 99 22 44 0 1957974480 15723680 5942096
18:49:54 23437 8192000000 10920362016 11367231488 1964472656 19.342 100 36 73 1 1983995904 9082416 10440832
18:50:36 104320 8192000000 10911357984 11380973568 1910316144 18.909 97 16 32 1 1931958080 17302512 4339424
18:52:30 114089 8192000000 10874013136 11337830400 1906098464 18.875 97 25 50 0 1925219264 12154992 6965808
18:54:34 81543 8192000000 10866392672 11335815168 1892983312 18.770 97 31 62 2 1914509680 12574336 8952032
18:56:02 39811 8192000000 10841192000 11313655808 1876731488 18.639 97 6 12 0 1889145728 10639472 1774768
18:56:53 66263 8192000000 10832812944 11314970624 1872477280 18.604 97 13 26 1 1884884352 8983040 3424032
18:58:58 87869 8192000000 10823848832 11293552640 1840036976 18.341 96 13 24 1 1853776224 10040832 3698416
19:00:41 50013 8192000000 10838279584 11325067264 1922674352 19.008 100 6 13 0 1935037488 10878896 1484240
19:01:37 29268 8192000000 10855910496 11325386752 1910670880 18.912 99 10 20 2 1924366288 11102944 2592464
19:02:13 31655 8192000000 10884545840 11345633280 1949645104 19.224 100 21 42 0 1965428528 10151904 5631520
19:03:23 60609 8192000000 10894041392 11368488960 1921643072 19.000 98 24 48 2 1939977616 11456528 6878016
19:04:30 26068 8192000000 10901082464 11369639936 1970356800 19.388 100 29 56 2 1989168336 10668944 8142592
19:05:21 76091 8192000000 10912211456 11389804544 1951023072 19.235 99 20 40 1 1971227088 14363888 5840128
19:06:44 77887 8192000000 10900466672 11381739520 1938341344 19.134 98 13 26 0 1958358912 16169104 3848464
19:08:14 73942 8192000000 10927413936 11394142208 1978860800 19.456 100 21 42 0 2000400000 15143552 6395648
19:09:40 45214 8192000000 10918964976 11393536000 1964937440 19.345 99 19 38 1 1988443136 17665232 5840464
19:10:31 66848 8192000000 10877056688 11360456704 1915379184 18.950 97 10 20 0 1940245360 22129744 2736432
19:11:47 41092 8192000000 10918499952 11377324032 1974300000 19.420 100 31 61 1 1996511920 13131328 9080592
19:12:41 39080 8192000000 10911802352 11370127360 1962076880 19.323 99 35 70 1 1984038832 11336960 10624992
19:13:55 102166 8192000000 10906349536 11371458560 1884813776 18.704 95 34 69 0 1906328672 11787072 9727824
19:15:54 89221 8192000000 10859878432 11325284352 1924286672 19.021 98 9 18 0 1934839328 7065664 3486992
19:17:33 72106 8192000000 10868077296 11350339584 1903427328 18.854 97 21 42 1 1921289744 11961200 5901216
19:18:51 78764 8192000000 10872087456 11365986304 1939478848 19.143 99 9 18 0 1949518768 8000736 2039184
19:20:52 77008 8192000000 10880144256 11363987456 1937702992 19.128 98 12 24 1 1947739536 7236544 2800000
19:22:15 23928 8192000000 10876074832 11350433792 1951429344 19.238 99 17 35 1 1963758288 7252528 5076416
19:22:46 45572 8192000000 10873514016 11362553856 1927167568 19.044 98 8 16 0 1937743984 8436224 2140192
19:23:38 35243 8192000000 10887819728 11380842496 1962424416 19.325 100 3 6 0 1979002352 15802912 775024
19:24:19 26175 8192000000 10886748992 11372539904 1945018656 19.187 99 6 12 0 1964416736 17814032 1584048
19:24:52 74396 8192000000 10909211488 11386007552 1964538480 19.342 100 13 26 1 1979435392 11062736 3834176
19:26:33 64664 8192000000 9144107904 9380917248 310793120 3.655 16 7 13 1 318634112 5702336 2138656

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-02-2021 19:29:02 to 07-02-2021 19:29:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

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

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          229482
MON$OLDEST_ACTIVE               229483
MON$OLDEST_SNAPSHOT             229483
MON$NEXT_TRANSACTION            229483
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                       2024640
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:71: 
:72: mscs-test-161.budzdorov.ru    Sun Feb  7 19:27:41 2021
:73:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:74: 
--- end of diff output ---

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

07.02.21 19:29:37. 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-02-07 19:29:39 No severe PSQL-related problems occured
07.02.21 19:29:40. End of report.