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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-22 16:27:12
DTS_END                         2021-01-22 16:27:12.6040
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/32940
TRN_ID                          234846
ATT_ID                          644
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: 8886.58 19445 1066390
customer order: creation 170.00 382 20400
customer order: refuse 14.38 363 1725
order to supplier: creation 44.33 1390 5319
order to supplier: removal 3.39 99677 407
invoice (draft): creation 45.12 3386 5414
invoice (draft): removal 50.36 823 6043
invoice accept: apply 40.44 18630 4853
invoice accept: cancel 45.01 780 5401
customer reserve: creation 3759.97 183 451196
customer reserve: removal 4429.13 59 531496
realization accept: apply 82.23 195 9868
realization accept: cancel 75.13 118 9016
payment from customer: creation 57.53 143 6903
payment from customer: removal 5.81 61 697
payment to supplier: creation 48.67 163 5840
payment to supplier: removal 3.20 73 384
service: total inventory turnovers 4.26 1391 511
service: total monetary turnovers 6.77 21 812
service: aggregate perf. data 0.84 19527 101
service: refresh index statistics 0.03 241528 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-01-2021 16:29:34 to 22-01-2021 16:29:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4369
TEST_TIME 2 4915
TEST_TIME 3 6014
TEST_TIME 4 5466
TEST_TIME 5 5362
TEST_TIME 6 5888
TEST_TIME 7 6500
TEST_TIME 8 6382
TEST_TIME 9 6382
TEST_TIME 10 6387
TEST_TIME 11 6952
TEST_TIME 12 7238
TEST_TIME 13 7259
TEST_TIME 14 7640
TEST_TIME 15 7554
TEST_TIME 16 7736
TEST_TIME 17 8341
TEST_TIME 18 8169
TEST_TIME 19 8343
TEST_TIME 20 8899
TEST_TIME 21 9058
TEST_TIME 22 8946
TEST_TIME 23 9329
TEST_TIME 24 9766
TEST_TIME 25 10047
TEST_TIME 26 10675
TEST_TIME 27 10728
TEST_TIME 28 10445
TEST_TIME 29 10711
TEST_TIME 30 10709
TEST_TIME 31 10853
TEST_TIME 32 10862
TEST_TIME 33 10735
TEST_TIME 34 10487
TEST_TIME 35 10324
TEST_TIME 36 10219
TEST_TIME 37 10046
TEST_TIME 38 9916
TEST_TIME 39 9941
TEST_TIME 40 9919
TEST_TIME 41 9845
TEST_TIME 42 9742
TEST_TIME 43 9656
TEST_TIME 44 9499
TEST_TIME 45 9366
TEST_TIME 46 9201
TEST_TIME 47 9411
TEST_TIME 48 9309
TEST_TIME 49 9370
TEST_TIME 50 9347
TEST_TIME 51 9301
TEST_TIME 52 9222
TEST_TIME 53 9176
TEST_TIME 54 9269
TEST_TIME 55 9202
TEST_TIME 56 9258
TEST_TIME 57 9209
TEST_TIME 58 9204
TEST_TIME 59 9259
TEST_TIME 60 9225
TEST_TIME 61 9291
TEST_TIME 62 9378
TEST_TIME 63 9342
TEST_TIME 64 9390
TEST_TIME 65 9467
TEST_TIME 66 9401
TEST_TIME 67 9296
TEST_TIME 68 9285
TEST_TIME 69 9217
TEST_TIME 70 9151
TEST_TIME 71 9195
TEST_TIME 72 9181
TEST_TIME 73 9107
TEST_TIME 74 9062
TEST_TIME 75 9061
TEST_TIME 76 9088
TEST_TIME 77 9060
TEST_TIME 78 9034
TEST_TIME 79 9036
TEST_TIME 80 9115
TEST_TIME 81 9120
TEST_TIME 82 9117
TEST_TIME 83 9159
TEST_TIME 84 9180
TEST_TIME 85 9203
TEST_TIME 86 9224
TEST_TIME 87 9238
TEST_TIME 88 9236
TEST_TIME 89 9281
TEST_TIME 90 9193
TEST_TIME 91 9145
TEST_TIME 92 9115
TEST_TIME 93 9080
TEST_TIME 94 9093
TEST_TIME 95 9045
TEST_TIME 96 9017
TEST_TIME 97 8985
TEST_TIME 98 8936
TEST_TIME 99 8911
TEST_TIME 100 8870
TEST_TIME 101 8960
TEST_TIME 102 8954
TEST_TIME 103 8969
TEST_TIME 104 8973
TEST_TIME 105 9005
TEST_TIME 106 9015
TEST_TIME 107 9021
TEST_TIME 108 8975
TEST_TIME 109 8983
TEST_TIME 110 9090
TEST_TIME 111 9102
TEST_TIME 112 9081
TEST_TIME 113 9135
TEST_TIME 114 9129
TEST_TIME 115 9054
TEST_TIME 116 9023
TEST_TIME 117 9031
TEST_TIME 118 8991
TEST_TIME 119 8956
TEST_TIME 120 8889

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-01-2021 16:29:38 to 22-01-2021 16:29:41.

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 1484497 1484497 0 0.00 0 29590 7 0 0
doc_list_biud 1484495 1484495 0 0.00 0 28448 28 0 0
sp_add_invoice_to_stock 4965 4853 112 2.25 51 157120 18631 0 112
sp_cancel_adding_invoice 5401 5401 0 0.00 4 53263 781 0 0
sp_cancel_client_order 1725 1725 0 0.00 4 11877 363 0 0
sp_cancel_customer_reserve 531496 531496 0 0.00 1 24552 60 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 3 1992 62 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 2 4472 73 0 0
sp_cancel_supplier_invoice 6047 6043 4 0.06 2 15816 823 0 4
sp_cancel_supplier_order 407 407 0 0.00 5 927079 99678 0 0
sp_cancel_write_off 9016 9016 0 0.00 1 8326 118 0 0
sp_client_order 20400 20400 0 0.00 3 20018 383 0 0
sp_customer_reserve 451196 451196 0 0.00 0 66428 183 0 0
sp_fill_shopping_cart 31118 31118 0 0.00 1 34454 43 0 0
sp_fill_shopping_cart_clo_res 451191 451191 0 0.00 0 15554 15 0 0
sp_get_clo_for_invoice 4848 4848 0 0.00 0 28887 402 0 0
sp_kill_cost_storno 15498 15498 0 0.00 0 9534 57 0 0
sp_kill_qstorno_ret_qs2qd 1078458 1078458 0 0.00 0 24488 33 0 0
sp_kill_qty_storno 568804 568804 0 0.00 0 28445 71 0 0
sp_lock_selected_doc 20377 20377 0 0.00 0 9166 5 0 0
sp_make_cost_storno 27459 27459 0 0.00 0 29588 69 0 0
sp_multiply_rows_for_pdistr 27459 27459 0 0.00 0 8735 29 0 0
sp_multiply_rows_for_qdistr 20399 20399 0 0.00 0 19986 186 0 0
sp_pay_from_customer 6903 6903 0 0.00 4 18054 144 0 0
sp_pay_to_supplier 5840 5840 0 0.00 4 29595 164 0 0
sp_payment_common 12743 12743 0 0.00 1 12189 41 0 0
sp_qd_handle_on_cancel_clo 1725 1725 0 0.00 0 10460 332 0 0
sp_qd_handle_on_invoice_upd_sts 10249 10249 0 0.00 0 28438 348 0 0
sp_qd_handle_on_reserve_upd_sts 9868 9868 0 0.00 0 11325 63 0 0
sp_reserve_write_off 9868 9868 0 0.00 6 16700 195 0 0
sp_supplier_invoice 5414 5414 0 0.00 6 101762 3387 0 0
sp_supplier_order 5319 5319 0 0.00 5 46972 1390 0 0
srv_aggregate_perf_data 101 101 0 0.00 2418 149987 19528 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 966 133310 34154 0 0
srv_find_qd_qs_mism 1019746 1019746 0 0.00 0 19340 5 0 0
srv_make_invnt_saldo 511 511 0 0.00 37 112719 1392 0 0
srv_make_money_saldo 812 812 0 0.00 1 1426 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 164047 431278 241529 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4853 4853 0 0.00 0 10086 150 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 0 7005 94 0 0
t$perf-norm:sp_cancel_client_order 1725 1725 0 0.00 0 4822 14 0 0
t$perf-norm:sp_cancel_customer_reserve 671 671 0 0.00 0 1061 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 599 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 1365 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 1257 22 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 22393 1562 0 0
t$perf-norm:sp_cancel_write_off 972 972 0 0.00 0 3129 11 0 0
t$perf-norm:sp_client_order 20400 20400 0 0.00 0 32615 19 0 0
t$perf-norm:sp_customer_reserve 939 939 0 0.00 0 3723 10 0 0
t$perf-norm:sp_pay_from_customer 6903 6903 0 0.00 0 5761 8 0 0
t$perf-norm:sp_pay_to_supplier 5840 5840 0 0.00 0 4069 9 0 0
t$perf-norm:sp_reserve_write_off 9868 9868 0 0.00 0 33606 15 0 0
t$perf-norm:sp_supplier_invoice 5414 5414 0 0.00 0 6711 18 0 0
t$perf-norm:sp_supplier_order 5319 5319 0 0.00 0 4172 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 545 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 962 17 0 0
t$perf-norm:srv_make_invnt_saldo 511 511 0 0.00 0 1710 27 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 4552 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 11 5 0 0
v_add_invoice_to_stock 9912 9688 224 2.25 0 10611 21 0 224
v_all_customers 36752 36752 0 0.00 0 17 1 0 0
v_all_suppliers 30044 30044 0 0.00 0 20 1 0 0
v_all_wares 40798 40798 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 6092 15 0 0
v_cancel_client_order 3450 3450 0 0.00 0 6922 9 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 1911 5 0 0
v_cancel_customer_reserve 1342 1342 0 0.00 0 2359 8 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 2182 7 0 0
v_cancel_supplier_invoice 848 840 8 0.94 0 2930 21 0 8
v_cancel_supplier_order 814 814 0 0.00 0 2724 8 0 0
v_cancel_write_off 1944 1944 0 0.00 0 2001 12 0 0
v_max_id_clo_ord 5314 5314 0 0.00 0 2028 1 0 0
v_max_id_clo_res 939 939 0 0.00 0 4284 17 0 0
v_max_id_ord_sup 5405 5405 0 0.00 0 6006 6 0 0
v_max_non_paid_invoice 1537 1537 0 0.00 0 1163 3 0 0
v_max_non_paid_realizn 3870 3870 0 0.00 0 6741 5 0 0
v_min_id_clo_ord 5314 5314 0 0.00 0 5989 11 0 0
v_min_id_clo_res 939 939 0 0.00 0 3507 9 0 0
v_min_id_ord_sup 5405 5405 0 0.00 0 7536 9 0 0
v_min_non_paid_invoice 5840 5840 0 0.00 0 11001 31 0 0
v_min_non_paid_realizn 6903 6903 0 0.00 0 11993 31 0 0
v_our_firm 10112 10112 0 0.00 0 14 1 0 0
v_reserve_write_off 19736 19736 0 0.00 0 6930 6 0 0
x_lock_depdocs_on_canc_invoice 11024 11024 0 0.00 0 10982 111 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 9362 347 0 0
x_make_qstorno_1000_1200 5319 5319 0 0.00 2 46951 1303 0 0
x_make_qstorno_1200_2000 5414 5414 0 0.00 2 101657 3226 0 0
x_make_qstorno_2100_3300 451196 451196 0 0.00 0 66426 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-01-2021 16:29:42 to 22-01-2021 16:29:46.

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
13:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:23 8990 8192000000 10185920800 10485104640 994923440 10.829 78 71 143 0 1021067712 2781600 23362672
13:57:39 27973 8192000000 10331282448 10643349504 1359079152 14.229 100 86 173 1 1391845424 4336080 28430192
13:58:18 42725 8192000000 10382377728 10706284544 1430755344 14.868 100 90 180 0 1466774976 6357504 29662128
13:59:12 29357 8192000000 10414691920 10740506624 1465899440 15.178 100 93 187 0 1503987184 7877904 30209840
13:59:54 20986 8192000000 10420193360 10748936192 1476376752 15.270 100 91 182 0 1514743600 8775376 29591472
14:00:40 20012 8192000000 10451685296 10788630528 1504213968 15.513 100 83 166 0 1539951088 9178896 26558224
14:01:10 17983 8192000000 10474487152 10817409024 1530735104 15.743 100 83 167 0 1567320752 9971760 26613888
14:01:38 18471 8192000000 10489330480 10839416832 1550186928 15.912 100 80 160 0 1586278208 10493104 25598176
14:02:06 14542 8192000000 10518652400 10869780480 1573095216 16.109 100 76 152 0 1606841232 10250384 23495632
14:02:30 16687 8192000000 10545984288 10899636224 1606365584 16.394 100 79 158 1 1641113168 10839568 23908016
14:03:01 10468 8192000000 10563023744 10920091648 1621922912 16.526 100 80 160 1 1657757104 11489360 24344832
14:03:20 9947 8192000000 10586396384 10951225344 1647147888 16.740 100 77 152 2 1681955776 11754640 23053248
14:03:40 7796 8192000000 10592282752 10966573056 1661840400 16.864 100 70 140 0 1693473600 10721808 20911392
14:03:54 8935 8192000000 10613711952 10984370176 1678830384 17.007 100 73 146 1 1710529536 10888992 20810160
14:04:16 7349 8192000000 10644427440 11016126464 1697664672 17.166 100 73 146 1 1730665328 12036144 20964512
14:04:31 5967 8192000000 10654671936 11026890752 1711913856 17.285 100 71 142 1 1744477264 12158496 20404912
14:04:44 6967 8192000000 10662057264 11038027776 1723886944 17.385 100 79 158 1 1758404624 12286480 22231200
14:04:59 7931 8192000000 10678994176 11051790336 1741190960 17.529 100 80 160 0 1775913856 12546016 22176880
14:05:14 4946 8192000000 10682705120 11061436416 1748843824 17.592 100 80 161 1 1784531712 13239328 22448560
14:05:26 6713 8192000000 10701054912 11080146944 1763037216 17.710 100 81 162 0 1798484688 13218944 22228528
14:05:40 10022 8192000000 10708023520 11090821120 1768964624 17.758 100 71 142 0 1801513840 13125152 19424064
14:05:58 8053 8192000000 10718974784 11102236672 1779518096 17.846 100 70 141 1 1811588704 12752560 19318048
14:06:13 4713 8192000000 10728231424 11115876352 1796117296 17.982 100 82 164 1 1832603840 13249360 23237184
14:06:25 4107 8192000000 10741591440 11129856000 1801695456 18.028 100 73 146 0 1835812480 13376640 20740384
14:06:37 2739 8192000000 10748739328 11135528960 1808867280 18.087 100 78 157 1 1843325408 12516592 21941536
14:06:46 4280 8192000000 10756699824 11145023488 1819894160 18.177 100 90 175 2 1858401680 13500560 25006960
14:06:57 4717 8192000000 10769178528 11154739200 1822546176 18.198 100 84 168 0 1859454240 13991056 22917008
14:07:09 2375 8192000000 10767367840 11154694144 1829321744 18.254 100 85 170 2 1867600784 13697232 24581808
14:07:17 3468 8192000000 10781543888 11163205632 1832529520 18.280 100 91 180 4 1871681792 13945024 25207248
14:07:27 2083 8192000000 10783896480 11165425664 1835285488 18.302 100 88 177 1 1874852944 14834976 24732480
14:07:37 1895 8192000000 10785386800 11167780864 1843348864 18.368 100 95 191 2 1884489024 15030400 26109760
14:07:45 1717 8192000000 10790276880 11174686720 1845513312 18.386 100 88 177 1 1884362656 14084832 24764512
14:07:54 1587 8192000000 10798609504 11186278400 1852461920 18.442 100 91 182 2 1893225424 14284768 26478736
14:08:02 1856 8192000000 10795473040 11182825472 1856165392 18.472 100 87 173 2 1893151616 12718256 24267968
14:08:10 1478 8192000000 10803730640 11194114048 1859064768 18.496 100 96 193 2 1900517360 13955168 27497424
14:08:18 1778 8192000000 10809238256 11196870656 1863226448 18.529 100 95 191 1 1904165968 13875328 27064192
14:08:27 1416 8192000000 10806712992 11196858368 1865024656 18.544 100 91 182 1 1905264880 14741488 25498736
14:08:35 1448 8192000000 10813680608 11200425984 1863228576 18.529 100 90 179 4 1901394736 13704672 24461488
14:08:42 1715 8192000000 10814248304 11201273856 1866726848 18.558 100 88 176 2 1903411616 12107360 24577408
14:08:50 11083 8192000000 10818289392 11205115904 1869253680 18.578 100 73 146 4 1901396416 10768800 21373936
14:09:08 2293 8192000000 10818338880 11209764864 1875022256 18.625 100 91 184 0 1912231424 10397456 26811712
14:09:16 1811 8192000000 10800264736 11204763648 1875329648 18.627 100 79 154 1 1909559248 12162464 22067136
14:09:25 1979 8192000000 10811290768 11213205504 1879591104 18.662 100 78 156 2 1913802432 11329760 22881568
14:09:37 6909 8192000000 10772449504 11200036864 1872228576 18.602 100 33 67 1 1888983392 7022128 9732688
14:09:53 7381 8192000000 10787635632 11209539584 1873429584 18.612 100 31 62 2 1888819792 7102192 8288016
14:10:07 6951 8192000000 10800340032 11217166336 1876294160 18.635 100 35 71 1 1893722912 7883920 9544832
14:10:21 5335 8192000000 10804219968 11223916544 1884067232 18.698 100 46 92 0 1910464944 13487824 12909888
14:10:35 5800 8192000000 10797747216 11218563072 1884439248 18.701 100 44 91 1 1905763136 8525632 12798256
14:10:48 61209 8192000000 10805659152 11230474240 1882922608 18.689 100 29 57 1 1896750352 5957296 7870448
14:11:59 8011 8192000000 10804705680 11231600640 1887332688 18.724 100 44 88 0 1907584128 7353808 12897632
14:12:16 6402 8192000000 10807349936 11229978624 1884889824 18.705 100 23 46 2 1898359760 7232864 6237072
14:12:30 3197 8192000000 10807381776 11236040704 1890784656 18.752 100 34 68 1 1908220144 7799328 9636160
14:12:41 5910 8192000000 10809320352 11241533440 1895418720 18.789 100 27 54 3 1909633520 6239824 7974976
14:12:57 6873 8192000000 10799368736 11237834752 1896982880 18.802 100 28 56 2 1912090112 7116352 7990880
14:13:12 6843 8192000000 10809864272 11243794432 1896353824 18.797 100 17 34 2 1907094208 5964288 4776096
14:13:27 14196 8192000000 10807418544 11244609536 1898291312 18.813 100 13 26 1 1908464800 6332752 3840736
14:13:49 6815 8192000000 10812824512 11247538176 1901832368 18.841 100 11 22 2 1910525696 5789616 2903712
14:14:02 6630 8192000000 10823326256 11251896320 1907111712 18.883 100 24 48 1 1920101360 6285392 6704256
14:14:18 9637 8192000000 10820916208 11256995840 1909691728 18.904 100 17 34 1 1919392864 5221760 4479376
14:14:36 7686 8192000000 10834768080 11264929792 1914056704 18.939 100 16 31 1 1923623760 5235872 4331184
14:14:55 15436 8192000000 10824041312 11266011136 1915667024 18.952 100 18 36 3 1925714384 5591504 4455856
14:15:20 70137 8192000000 10836141456 11266129920 1917587776 18.968 100 39 78 0 1934104496 5234784 11281936
14:16:39 8944 8192000000 10827687744 11258208256 1906275968 18.877 100 24 48 3 1918856608 5212928 7367712
14:16:54 9972 8192000000 10829029808 11260698624 1898450032 18.814 99 30 60 0 1913490160 5841568 9198560
14:17:12 8521 8192000000 10830774352 11261513728 1912274224 18.925 100 32 63 1 1926553952 5468416 8811312
14:17:28 3578 8192000000 10819640736 11251449856 1904832848 18.865 99 33 66 3 1920089040 5712896 9543296
14:17:38 3671 8192000000 10845332640 11269648384 1915744576 18.953 100 30 60 0 1929302928 5776160 7782192
14:17:50 6784 8192000000 10807679280 11238318080 1844901984 18.381 97 29 57 1 1867596368 15125088 7569296
14:18:03 7299 8192000000 10760346208 11187396608 1784907216 17.890 95 22 44 1 1797045696 5714016 6424464
14:18:20 10556 8192000000 10758496064 11188928512 1810604480 18.101 97 18 36 2 1821202160 4814784 5782896
14:18:38 8919 8192000000 10757363184 11173765120 1801053440 18.023 97 23 46 2 1813498992 5478512 6967040
14:18:54 13546 8192000000 10750607424 11176222720 1752312736 17.621 94 21 42 0 1764184912 5754112 6118064
14:19:15 12475 8192000000 10733796688 11152453632 1768313600 17.753 96 18 36 1 1778958192 5261200 5383392
14:19:34 6110 8192000000 10748527600 11167162368 1816347072 18.148 99 22 44 1 1827992064 5861456 5783536
14:19:50 11183 8192000000 10718081280 11135111168 1769401968 17.762 97 26 52 0 1782305856 5886992 7016896
14:20:07 9357 8192000000 10702749568 11114590208 1701599584 17.198 94 33 65 0 1719082000 5654368 11828048
14:20:23 54170 8192000000 10679583328 11099209728 1662476976 16.870 92 29 58 0 1676316224 5085280 8753968
14:21:24 12775 8192000000 10692239072 11109593088 1704334624 17.221 95 18 36 1 1718536064 9350992 4850448
14:21:46 7217 8192000000 10676649312 11087249408 1673811296 16.965 94 24 48 1 1686496048 6150448 6534304
14:22:03 4931 8192000000 10700520928 11120996352 1777879456 17.832 99 34 69 1 1794605328 6759584 9966288
14:22:14 5978 8192000000 10718391456 11132510208 1795976576 17.981 100 32 61 2 1810113824 5507664 8629584
14:22:28 10520 8192000000 10733248352 11151958016 1800728080 18.020 99 31 62 5 1814887408 5410224 8749104
14:22:46 8568 8192000000 10727189168 11154419712 1821649648 18.191 100 23 46 0 1833753936 4949984 7154304
14:23:01 5824 8192000000 10750586816 11175190528 1837127488 18.317 100 33 66 2 1857034736 10308816 9598432
14:23:13 7735 8192000000 10735647280 11149856768 1812844544 18.119 99 36 72 2 1829688016 5557744 11285728
14:23:30 8358 8192000000 10753755424 11178070016 1835959184 18.308 100 21 42 2 1848022160 5572304 6490672
14:23:46 8357 8192000000 10762122512 11184349184 1846851264 18.397 100 32 64 1 1862396864 5476048 10069552
14:24:00 8300 8192000000 10771271504 11191218176 1848528752 18.410 100 21 42 1 1860234224 5638592 6066880
14:24:18 10604 8192000000 10766418960 11196428288 1853671792 18.452 100 19 36 2 1864754624 5805664 5277168
14:24:35 14445 8192000000 10780116640 11203960832 1858443424 18.491 100 14 28 0 1867550128 5020960 4085744
14:24:55 15017 8192000000 10797722992 11212660736 1867042864 18.560 100 24 48 0 1879932224 6086512 6802848
14:25:53 28343 8192000000 10780289152 11209994240 1873531440 18.613 100 62 123 4 1898571616 6166624 18873552
14:26:30 8942 8192000000 10804109008 11223638016 1875363712 18.628 100 30 60 0 1893531904 9692720 8475472
14:26:46 7154 8192000000 10792952656 11218673664 1874718432 18.622 100 15 30 0 1884451392 5445648 4287312
14:26:59 6551 8192000000 10793167856 11223805952 1882654848 18.687 100 23 45 2 1894488432 5926848 5906736
14:27:14 4644 8192000000 10829127088 11241951232 1900851568 18.833 100 39 79 4 1917027664 4547440 11628656
14:27:25 10294 8192000000 10837049120 11256475648 1910397200 18.910 100 47 94 3 1931092656 6748544 13946912
14:27:45 35566 8192000000 10836644192 11262181376 1914005248 18.939 100 44 87 1 1934201152 8031920 12163984
14:28:32 19210 8192000000 10853075184 11275665408 1926252144 19.037 100 47 93 0 1949064192 10497200 12314848
14:29:07 3811 8192000000 10873538720 11294310400 1933874352 19.098 100 46 89 0 1961383360 15791568 11717440
14:29:18 6860 8192000000 10870637792 11295633408 1941730224 19.161 100 54 108 1 1968928720 11925744 15272752
14:29:33 16034 8192000000 10879251072 11304816640 1947678112 19.208 100 59 117 4 1976263904 12211472 16374320
14:29:58 9118 8192000000 10874018720 11307479040 1947911952 19.210 100 42 84 1 1973475440 13499440 12064048
14:30:24 21405 8192000000 10879339216 11315240960 1952685776 19.248 100 45 90 3 1978888832 12903120 13299936
14:30:57 19087 8192000000 10890566528 11318927360 1954384800 19.261 100 37 73 3 1977596448 12326352 10885296
14:31:23 18901 8192000000 10892800048 11323858944 1960048016 19.306 100 46 88 0 1986961888 13640928 13272944
14:31:55 29710 8192000000 10892195536 11328151552 1964732576 19.344 100 46 92 0 1993026352 15050016 13243760
14:32:41 53631 8192000000 10888662144 11334983680 1962734752 19.328 100 34 67 3 1987283776 14027312 10521712
14:34:00 26080 8192000000 10904351104 11345321984 1965508000 19.350 100 26 52 1 1989277168 15971600 7797568
14:34:34 4897 8192000000 10912415296 11344289792 1958601024 19.295 99 49 98 1 1987277616 14344896 14331696
14:34:45 12036 8192000000 10927602880 11350077440 1980876464 19.472 100 68 134 1 2015452768 15102528 19473776
14:35:04 5028 8192000000 10930211520 11355365376 1986527840 19.516 100 65 130 1 2021854192 17636336 17690016
14:35:17 6013 8192000000 10943421120 11366666240 1993223728 19.569 100 82 163 2 2035206000 18022944 23959328
14:35:32 8275 8192000000 10941855680 11366354944 1993113904 19.568 100 68 135 2 2030912384 18313216 19485264
14:35:49 14662 8192000000 10940816016 11368415232 1993363056 19.570 100 55 108 1 2027669952 18723600 15583296
14:36:11 11776 8192000000 10943621648 11380219904 1997505168 19.603 100 48 96 1 2031526704 20452192 13569344
14:36:39 2627 8192000000 10954484688 11388403712 2008448160 19.689 100 56 113 4 2047421264 21812752 17160352
14:36:56 11789 8192000000 10955505440 11389800448 2005287664 19.664 100 57 114 1 2047001664 24553536 17160464
14:37:16 4778 8192000000 10970353664 11394379776 2011983424 19.717 100 67 134 2 2053314960 21010224 20321312
14:37:28 7285 8192000000 10969068224 11395747840 2015116496 19.742 100 60 117 2 2054682528 21840720 17725312
14:37:43 5725 8192000000 10968825296 11397423104 2012220256 19.719 100 69 138 1 2056953904 23807088 20926560
14:37:57 3728 8192000000 10969737808 11389255680 1997838336 19.606 99 81 161 1 2046226896 24325360 24063200
14:38:14 3597 8192000000 10972237680 11402506240 2015066384 19.741 100 68 136 0 2062060944 26335280 20659280
14:38:24 4015 8192000000 10972785040 11399528448 2000591744 19.627 99 78 152 0 2049180272 26171440 22417088
14:38:35 962 8192000000 10990558528 11405664256 2020982992 19.788 100 91 179 0 2074791952 27580784 26228176
14:38:43 2852 8192000000 10990461376 11409879040 2024946000 19.819 100 88 176 0 2077893360 26832864 26114496
14:38:56 2432 8192000000 10988234720 11408306176 2021763184 19.794 100 81 162 2 2073107600 26587168 24757248
14:39:06 4063 8192000000 10982337552 11410509824 2021794624 19.794 100 80 161 0 2072682592 26890384 23997584
14:39:24 3904 8192000000 10973731440 11398602752 1998931184 19.614 99 71 142 0 2048286336 27538768 21816384
14:39:38 3775 8192000000 10972173104 11400269824 2007447056 19.681 100 60 118 0 2053941712 28259264 18235392
14:39:51 4182 8192000000 10971043040 11400134656 2008408096 19.689 100 62 123 2 2053817776 26980448 18429232
14:40:04 11373 8192000000 10943041696 11373015040 1959842896 19.305 98 62 124 0 2008019248 28630272 19546080
14:40:27 5898 8192000000 10947763712 11387064320 1991162464 19.553 100 45 90 2 2034779136 29117360 14499312
14:40:41 8325 8192000000 10956832160 11396927488 2001156000 19.632 100 48 96 2 2045746640 29407776 15182864
14:40:59 10145 8192000000 10942197792 11374657536 1965413280 19.349 98 40 77 1 2008323360 30005312 12904768
14:41:17 3055 8192000000 10977273824 11395104768 2001582080 19.635 100 74 148 2 2054744640 30513216 22649344
14:41:26 2355 8192000000 10956955360 11373735936 1980872992 19.472 99 81 162 0 2038685968 32807392 25005584
14:41:39 3378 8192000000 10969339664 11388919808 1989679184 19.541 100 74 146 1 2046406576 34310560 22416832
14:41:49 6272 8192000000 10954994320 11373182976 1971942640 19.401 99 71 138 1 2021720512 29007968 20769904
14:42:04 2345 8192000000 10960987040 11371892736 1984475824 19.500 100 78 154 3 2037500048 28725024 24299200
14:42:15 2702 8192000000 10962950624 11385999360 1994847648 19.582 100 74 148 1 2046803312 29716592 22239072
14:42:25 1405 8192000000 10951621632 11373809664 1974119424 19.418 99 90 180 0 2032843824 29971088 28753312
14:42:34 1588 8192000000 10968723440 11379924992 1987202016 19.522 100 86 173 0 2045564848 30925616 27437216
14:42:42 4017 8192000000 10967283744 11389153280 1997152912 19.600 100 78 155 2 2053515120 32142832 24219376
14:42:55 7893 8192000000 10968220976 11392307200 1997376816 19.602 100 73 145 2 2052529120 32964096 22188208
14:43:09 2292 8192000000 10943500880 11357929472 1954910800 19.266 99 78 155 0 2013303232 34152272 24240160
14:43:18 2931 8192000000 10953224352 11367821312 1977084704 19.442 100 72 144 4 2033934368 34904000 21945664
14:43:30 9244 8192000000 10942887840 11369304064 1971456144 19.397 100 65 129 2 2028533632 36238640 20838848
14:43:50 7451 8192000000 10932956016 11361091584 1966113952 19.355 100 61 122 0 2020465824 34898912 19452960
14:44:08 3705 8192000000 10953029456 11373494272 1974619376 19.422 100 71 142 0 2036059904 38191776 23248752
14:44:25 14252 8192000000 10919894688 11369254912 1953319008 19.253 99 35 68 0 1996436704 31863632 11254064
14:44:48 19551 8192000000 10907004064 11352326144 1930743216 19.073 98 30 60 2 1973331888 32789328 9799344
14:45:26 7548 8192000000 10918685152 11346800640 1922372432 19.006 98 44 88 1 1965348816 28854416 14121968
14:45:50 4527 8192000000 10936462816 11363426304 1968558896 19.374 100 70 138 2 2022080752 32495856 21026000
14:46:02 2180 8192000000 10935338240 11360210944 1961538576 19.318 100 73 146 1 2020261472 35945344 22777552
14:46:13 3180 8192000000 10907648192 11328933888 1905777424 18.873 97 64 127 0 1960697136 34564656 20355056
14:46:23 4968 8192000000 10923860144 11352039424 1950568272 19.231 100 54 107 0 2004105088 36701920 16834896
14:46:52 7988 8192000000 10926784080 11358302208 1942042112 19.163 99 50 100 0 2000906208 41648576 17215520
14:47:07 3171 8192000000 10942121088 11365875712 1963953520 19.337 100 70 136 1 2026398768 39886336 22558912
14:47:18 2034 8192000000 10948172064 11369472000 1966031904 19.354 100 67 135 0 2026983312 39370256 21581152
14:47:28 9118 8192000000 10912049360 11356770304 1929568048 19.063 98 52 104 0 1985392304 38912240 16912016
14:47:52 15964 8192000000 10905388112 11348516864 1936649840 19.120 99 37 74 0 1983680864 34844192 12186832
14:48:18 1257 8192000000 10930368016 11346288640 1944880368 19.186 100 83 165 1 2006184256 35613600 25690288
14:48:27 3100 8192000000 10936875840 11347775488 1951688192 19.240 100 87 173 3 2016548960 38234880 26625888
14:48:37 4233 8192000000 10911043728 11332513792 1936905952 19.122 100 80 160 0 2000475104 38876816 24692336
14:48:49 10655 8192000000 10885762128 11323224064 1917383904 18.966 99 35 70 0 1962838672 34237152 11217616
14:49:09 10744 8192000000 10905703200 11335421952 1934753392 19.105 100 41 82 1 1984151216 35691744 13706080
14:49:27 16627 8192000000 10899383824 11339640832 1935653328 19.112 100 37 74 1 1986828640 38252080 12923232
14:49:57 14671 8192000000 10917111696 11354173440 1941451184 19.158 100 35 70 0 1998262080 44172224 12638672
14:50:32 15569 8192000000 10902901984 11340144640 1923819136 19.017 99 35 70 1 1980630592 44554096 12257360
14:51:04 19975 8192000000 10887434480 11334959104 1910156656 18.908 99 30 60 0 1967197520 45918080 11122784
14:51:38 26229 8192000000 10895040000 11346829312 1929563744 19.063 100 31 62 1 1976756912 36206112 10987056
14:52:22 13083 8192000000 10883485312 11336347648 1911486528 18.919 99 27 54 1 1959662064 38228816 9946720
14:52:53 17570 8192000000 10892792768 11342364672 1908992832 18.899 99 35 70 0 1969285376 48093808 12198736
14:53:22 14539 8192000000 10894392128 11353509888 1931464416 19.079 100 19 38 0 1978071936 39285760 7321760
14:53:45 6171 8192000000 10906696176 11359576064 1941759360 19.161 100 28 56 0 1992007680 41575168 8673152
14:53:57 9758 8192000000 10897209920 11356672000 1944671248 19.184 100 17 34 1 1982056032 31618976 5765808
14:54:38 53858 8192000000 10906499200 11343110144 1936049616 19.115 100 24 48 1 1969228736 24879280 8299840
14:55:48 17391 8192000000 10900368400 11342106624 1937174304 19.124 100 34 68 2 1978735408 29805472 11755632
14:56:13 27333 8192000000 10898420592 11355451392 1946474656 19.198 100 31 62 1 1990387504 33596096 10316752
14:56:50 31954 8192000000 10892117376 11352481792 1941343248 19.157 100 14 28 1 1975420416 29535392 4541776
14:57:28 46706 8192000000 10894676592 11355766784 1939093344 19.140 99 30 61 1 1981221728 33994656 8133728
14:58:26 20272 8192000000 10882328992 11349827584 1936276688 19.117 100 11 22 1 1967488688 27976400 3235600
14:58:54 25265 8192000000 10876632080 11356553216 1938220064 19.133 100 13 26 1 1970888928 28974912 3693952
14:59:32 49631 8192000000 10860789536 11336790016 1908801440 18.897 99 13 26 1 1931867232 19374528 3691264
15:00:34 75933 8192000000 10861597184 11313074176 1899987984 18.826 98 11 21 0 1912894960 10509840 2397136
15:01:56 38253 8192000000 10890074000 11316576256 1911880176 18.922 98 47 92 1 1932038096 8077712 12080208
15:02:42 50171 8192000000 10873090240 11321286656 1939683568 19.144 100 16 32 0 1950897072 6820592 4392912
15:03:39 56361 8192000000 10863438352 11316621312 1900635408 18.831 97 36 70 0 1918244400 7338208 10270784
15:05:24 19148 8192000000 10902200000 11346116608 1959332736 19.301 100 32 64 0 1979886048 11478032 9075280
15:05:52 125874 8192000000 10898192064 11360210944 1966736304 19.360 100 37 76 0 1988055120 9917584 11401232
15:08:10 52103 8192000000 10911217936 11374092288 1978219520 19.451 100 26 52 1 1994356704 8579296 7557888
15:09:13 72424 8192000000 10906342400 11378159616 1962169040 19.323 99 20 40 1 1978296960 10089248 6038672
15:10:32 20663 8192000000 10901454224 11374493696 1980168992 19.466 100 14 28 2 1994611504 10799392 3643120
15:11:07 89419 8192000000 10914092576 11385556992 1969501296 19.381 99 14 27 0 1988802784 15714368 3587120
15:12:51 91859 8192000000 10929351184 11400327168 1993259056 19.570 100 26 53 0 2024928272 24003296 7665920
15:14:30 77998 8192000000 10931918832 11398078464 1985554592 19.509 100 20 40 1 2013955776 22080416 6320768
15:16:04 89438 8192000000 10902427600 11392937984 1976078592 19.434 99 41 83 3 2004560560 16581040 11900928
15:17:41 92045 8192000000 10909458656 11388846080 1987612704 19.525 100 5 10 0 2002724528 13864672 1247152
15:19:19 47250 8192000000 10928877968 11403145216 2000884912 19.630 100 25 50 0 2017923280 9669712 7368656
15:20:17 51576 8192000000 10922965248 11395702784 1971486960 19.397 98 11 22 0 1982877856 8490560 2900336
15:21:15 66351 8192000000 10913189408 11388788736 1954542080 19.263 98 8 16 0 1969485856 12928784 2014992
15:22:33 32248 8192000000 10937563936 11392557056 2000075376 19.623 100 43 85 3 2020335008 8184224 12075408
15:23:14 51019 8192000000 10912578912 11393785856 1961092064 19.315 98 35 70 3 1982682640 10458880 11131696
15:24:12 74129 8192000000 10914136448 11372986368 1920560688 18.991 96 36 72 2 1941534912 11107968 9866256
15:25:35 85494 8192000000 10902840800 11370090496 1928783616 19.057 97 15 30 0 1942574864 9657200 4134048
15:27:11 69787 8192000000 10876096416 11348168704 1927534048 19.047 97 32 64 2 1951877024 15182352 9160624
15:29:16 67900 8192000000 10894338448 11351306240 1866376144 18.555 94 16 32 3 1877587040 7132448 4078448
15:30:35 53164 8192000000 10916599520 11377315840 1926832848 19.042 97 29 58 0 1950094800 15517072 7744880
15:31:37 63168 8192000000 10898766736 11373633536 1940419952 19.150 98 14 28 0 1958661328 14349280 3892096
15:32:49 65951 8192000000 10888403408 11343101952 1895885280 18.793 96 26 51 2 1912662864 9236736 7540848
15:34:01 133310 8192000000 10889041808 11356127232 1891056544 18.754 96 19 38 1 1904151680 8351104 4744032
15:36:21 65944 8192000000 10897055232 11364569088 1936319120 19.117 98 22 41 1 1957469760 14897312 6253328
15:37:34 43037 8192000000 10909728544 11380174848 1976189040 19.435 100 29 58 1 1998701472 14067600 8444832
15:38:28 96457 8192000000 10866283888 11346108416 1847478864 18.402 93 16 32 1 1866469424 13910704 5079856
15:40:21 70071 8192000000 10860820640 11332816896 1924360928 19.022 98 23 45 0 1943322096 12420272 6540896
15:41:40 87326 8192000000 10872775808 11351830528 1921773024 19.001 98 10 20 0 1936227040 11959360 2494656
15:43:26 60892 8192000000 10857497040 11328790528 1835608704 18.305 94 8 16 0 1852578224 14675568 2293952
15:44:38 30880 8192000000 10864292528 11318648832 1899481760 18.822 98 27 54 2 1915238000 8180560 7575680
15:45:17 55329 8192000000 10859420576 11337633792 1931435072 19.078 99 29 58 0 1950171216 10052672 8683472
15:46:23 53973 8192000000 10862518960 11322933248 1878737504 18.655 96 10 20 0 1893308240 11070624 3500112
15:47:29 97745 8192000000 10882040528 11339415552 1851651344 18.436 95 25 50 0 1871804736 12886432 7266960
15:49:14 53787 8192000000 10865235824 11344453632 1904964720 18.866 98 25 50 2 1930941920 18609648 7367552
15:50:19 43257 8192000000 10886202496 11339276288 1930319200 19.069 99 24 48 0 1946159536 8828368 7011968
15:51:11 111252 8192000000 10869558704 11341291520 1859563440 18.500 95 16 32 0 1875274432 11081712 4629280
15:53:20 61965 8192000000 10848763520 11306225664 1842314160 18.360 95 23 46 1 1861045040 12384704 6346176
15:54:35 63261 8192000000 10868849776 11329884160 1923486128 19.015 99 21 42 1 1938562848 8878608 6198112
15:55:47 64462 8192000000 10867416256 11344723968 1911724016 18.920 98 19 38 0 1928599664 11584336 5291312
15:57:00 126750 8192000000 10887970448 11348373504 1935866720 19.114 99 26 52 0 1951214960 7893088 7455152
15:59:12 38595 8192000000 10909383968 11371507712 1973918752 19.417 100 29 58 1 1990645584 8657888 8068944
16:00:07 16656 8192000000 10909224192 11372634112 1983115104 19.489 100 25 50 0 1999912576 9779568 7017904
16:00:29 31670 8192000000 10914597648 11380817920 1983564400 19.493 100 17 34 1 1997684128 9456720 4663008
16:01:24 66044 8192000000 10899013152 11376959488 1965360512 19.349 99 7 14 0 1975230528 7863856 2006160
16:02:36 27025 8192000000 10903789632 11365220352 1979110688 19.458 100 21 42 2 1992950944 7153392 6686864
16:03:16 67309 8192000000 10905202656 11374350336 1950153264 19.228 98 14 28 2 1960559584 6684592 3721728
16:04:30 99138 8192000000 10913789024 11388928000 1991555952 19.556 100 15 30 0 2007794992 12043328 4195712
16:06:27 92963 8192000000 10902512192 11374768128 1933834192 19.098 97 14 28 2 1950173216 12503616 3835408
16:08:06 84739 8192000000 10887012944 11359657984 1916996992 18.963 97 8 16 0 1929287936 10053312 2237632
16:09:37 34172 8192000000 10911213360 11374489600 1977192000 19.442 100 12 24 1 1988344928 7873040 3279888
16:10:19 47932 8192000000 10905980128 11384799232 1969760016 19.384 99 27 54 0 1990253344 12573824 7919504
16:11:13 58156 8192000000 10918012528 11376566272 1954639584 19.263 98 16 32 0 1970182896 11248784 4294528
16:12:23 72358 8192000000 10915327872 11379879936 1966584832 19.358 99 24 48 3 1985298064 12067904 6645328
16:13:46 85039 8192000000 10919107216 11382530048 1948995344 19.218 98 30 58 3 1967241520 9816096 8430080
16:15:17 26375 8192000000 10895373504 11343372288 1926909488 19.042 97 34 68 1 1951256928 14866288 9481152
16:15:51 77175 8192000000 10896205792 11367374848 1941945552 19.162 98 33 66 1 1970169280 18899952 9323776
16:17:20 78071 8192000000 10890893456 11360022528 1890529008 18.750 96 18 36 1 1912369824 16838352 5002464
16:18:55 43195 8192000000 10928452032 11379322880 1960696352 19.312 99 43 86 2 1982551664 9908880 11946432
16:20:02 44446 8192000000 10912213616 11380969472 1936106096 19.116 98 23 46 0 1963129344 20902112 6121136
16:22:34 74811 8192000000 10881332176 11348287488 1932527328 19.087 98 21 43 1 1943870128 5814288 5528512
16:23:56 54651 8192000000 10862620080 11331563520 1867876720 18.567 95 15 30 2 1878811872 6699744 4235408
16:24:59 50266 8192000000 10856591728 11329912832 1927686544 19.048 99 6 12 1 1937120672 7840224 1593904
16:25:55 52907 8192000000 10842553040 11315957760 1906599872 18.879 98 3 6 0 1915687088 8382688 704528
16:26:57 22833 8192000000 9404298944 9699614720 560986784 6.409 29 3 6 0 567113760 5422528 704448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-01-2021 16:29:48 to 22-01-2021 16:30:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-01-2021 16:30:20 to 22-01-2021 16:30:22.

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          235161
MON$OLDEST_ACTIVE               235162
MON$OLDEST_SNAPSHOT             235162
MON$NEXT_TRANSACTION            235162
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                       2017984
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:234: 
:235: mscs-test-161.budzdorov.ru    Fri Jan 22 16:27:21 2021
:236:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:237: 
:238: 
:239: mscs-test-161.budzdorov.ru    Fri Jan 22 16:27:24 2021
:240:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:241: 
--- end of diff output ---

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

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