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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17470372 kB
MemAvailable 31375656 kB
Buffers 0 kB
Cached 14202564 kB
SwapCached 4864 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-06 01:27:10
DTS_END                         2021-01-06 01:27:10.2740
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60960
TRN_ID                          239085
ATT_ID                          636
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: 9129.27 24490 1095512
customer order: creation 171.88 366 20625
customer order: refuse 14.94 361 1793
order to supplier: creation 45.09 1385 5411
order to supplier: removal 3.19 107782 383
invoice (draft): creation 46.37 3604 5564
invoice (draft): removal 51.44 836 6173
invoice accept: apply 41.96 17171 5035
invoice accept: cancel 46.26 802 5551
customer reserve: creation 3893.48 168 467218
customer reserve: removal 4525.57 59 543068
realization accept: apply 82.82 199 9938
realization accept: cancel 76.91 113 9229
payment from customer: creation 57.75 133 6930
payment from customer: removal 5.71 91 685
payment to supplier: creation 49.89 159 5987
payment to supplier: removal 3.53 113 423
service: total inventory turnovers 4.78 965 574
service: total monetary turnovers 6.83 18 819
service: aggregate perf. data 0.85 20133 102
service: refresh index statistics 0.03 335336 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5449
TEST_TIME 2 4665
TEST_TIME 3 4015
TEST_TIME 4 3976
TEST_TIME 5 4303
TEST_TIME 6 4990
TEST_TIME 7 5545
TEST_TIME 8 5965
TEST_TIME 9 6004
TEST_TIME 10 6536
TEST_TIME 11 6828
TEST_TIME 12 7110
TEST_TIME 13 7346
TEST_TIME 14 7289
TEST_TIME 15 7223
TEST_TIME 16 7678
TEST_TIME 17 7672
TEST_TIME 18 8108
TEST_TIME 19 8096
TEST_TIME 20 8351
TEST_TIME 21 8311
TEST_TIME 22 8538
TEST_TIME 23 8806
TEST_TIME 24 8893
TEST_TIME 25 9126
TEST_TIME 26 9721
TEST_TIME 27 9852
TEST_TIME 28 10423
TEST_TIME 29 10378
TEST_TIME 30 10131
TEST_TIME 31 9987
TEST_TIME 32 9878
TEST_TIME 33 9691
TEST_TIME 34 9664
TEST_TIME 35 9595
TEST_TIME 36 9531
TEST_TIME 37 9440
TEST_TIME 38 9298
TEST_TIME 39 9237
TEST_TIME 40 9132
TEST_TIME 41 9357
TEST_TIME 42 9347
TEST_TIME 43 9449
TEST_TIME 44 9341
TEST_TIME 45 9339
TEST_TIME 46 9328
TEST_TIME 47 9357
TEST_TIME 48 9404
TEST_TIME 49 9406
TEST_TIME 50 9442
TEST_TIME 51 9554
TEST_TIME 52 9573
TEST_TIME 53 9550
TEST_TIME 54 9647
TEST_TIME 55 9559
TEST_TIME 56 9656
TEST_TIME 57 9604
TEST_TIME 58 9477
TEST_TIME 59 9365
TEST_TIME 60 9414
TEST_TIME 61 9348
TEST_TIME 62 9373
TEST_TIME 63 9385
TEST_TIME 64 9321
TEST_TIME 65 9246
TEST_TIME 66 9167
TEST_TIME 67 9131
TEST_TIME 68 9133
TEST_TIME 69 9139
TEST_TIME 70 9208
TEST_TIME 71 9210
TEST_TIME 72 9166
TEST_TIME 73 9246
TEST_TIME 74 9228
TEST_TIME 75 9271
TEST_TIME 76 9262
TEST_TIME 77 9246
TEST_TIME 78 9307
TEST_TIME 79 9354
TEST_TIME 80 9342
TEST_TIME 81 9246
TEST_TIME 82 9232
TEST_TIME 83 9239
TEST_TIME 84 9221
TEST_TIME 85 9196
TEST_TIME 86 9154
TEST_TIME 87 9085
TEST_TIME 88 9071
TEST_TIME 89 9074
TEST_TIME 90 9080
TEST_TIME 91 9116
TEST_TIME 92 9103
TEST_TIME 93 9090
TEST_TIME 94 9163
TEST_TIME 95 9204
TEST_TIME 96 9245
TEST_TIME 97 9243
TEST_TIME 98 9237
TEST_TIME 99 9235
TEST_TIME 100 9297
TEST_TIME 101 9369
TEST_TIME 102 9347
TEST_TIME 103 9416
TEST_TIME 104 9415
TEST_TIME 105 9338
TEST_TIME 106 9303
TEST_TIME 107 9276
TEST_TIME 108 9294
TEST_TIME 109 9255
TEST_TIME 110 9213
TEST_TIME 111 9217
TEST_TIME 112 9164
TEST_TIME 113 9134
TEST_TIME 114 9086
TEST_TIME 115 9085
TEST_TIME 116 9161
TEST_TIME 117 9172
TEST_TIME 118 9175
TEST_TIME 119 9204
TEST_TIME 120 9133

Performance per minute, chart


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

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 1526443 1526443 0 0.00 0 27668 6 0 0
doc_list_biud 1526439 1526439 0 0.00 0 34013 27 0 0
sp_add_invoice_to_stock 5142 5035 107 2.08 28 163675 17172 0 107
sp_cancel_adding_invoice 5551 5551 0 0.00 5 58370 803 0 0
sp_cancel_client_order 1793 1793 0 0.00 4 14030 361 0 0
sp_cancel_customer_reserve 543068 543068 0 0.00 1 17765 60 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 2 12219 92 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 2 8058 113 0 0
sp_cancel_supplier_invoice 6181 6173 8 0.12 2 19499 836 0 8
sp_cancel_supplier_order 383 383 0 0.00 5 930672 107782 0 0
sp_cancel_write_off 9229 9229 0 0.00 1 8361 113 0 0
sp_client_order 20625 20625 0 0.00 4 13010 367 0 0
sp_customer_reserve 467218 467218 0 0.00 0 93538 169 0 0
sp_fill_shopping_cart 31578 31578 0 0.00 1 23437 41 0 0
sp_fill_shopping_cart_clo_res 467211 467211 0 0.00 0 20876 16 0 0
sp_get_clo_for_invoice 5028 5028 0 0.00 0 34605 350 0 0
sp_kill_cost_storno 15888 15888 0 0.00 0 7379 57 0 0
sp_kill_qstorno_ret_qs2qd 1101921 1101921 0 0.00 0 17761 32 0 0
sp_kill_qty_storno 581159 581159 0 0.00 0 34010 70 0 0
sp_lock_selected_doc 20758 20758 0 0.00 0 7915 7 0 0
sp_make_cost_storno 27882 27882 0 0.00 0 27640 65 0 0
sp_multiply_rows_for_pdistr 27879 27879 0 0.00 0 16470 32 0 0
sp_multiply_rows_for_qdistr 20625 20625 0 0.00 0 10302 165 0 0
sp_pay_from_customer 6930 6930 0 0.00 4 20796 134 0 0
sp_pay_to_supplier 5987 5987 0 0.00 5 27680 160 0 0
sp_payment_common 12917 12917 0 0.00 1 26032 49 0 0
sp_qd_handle_on_cancel_clo 1793 1793 0 0.00 0 14024 328 0 0
sp_qd_handle_on_invoice_upd_sts 10578 10578 0 0.00 0 34008 321 0 0
sp_qd_handle_on_reserve_upd_sts 9935 9935 0 0.00 0 15710 60 0 0
sp_reserve_write_off 9938 9938 0 0.00 6 21275 199 0 0
sp_supplier_invoice 5564 5564 0 0.00 6 86140 3604 0 0
sp_supplier_order 5411 5411 0 0.00 5 32315 1385 0 0
srv_aggregate_perf_data 102 102 0 0.00 2488 281873 20133 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1235 128531 33570 0 0
srv_find_qd_qs_mism 1046795 1046795 0 0.00 0 16150 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 29 47008 966 0 0
srv_make_money_saldo 819 819 0 0.00 1 246 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 289092 431938 335337 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5035 5035 0 0.00 0 7091 140 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 3394 81 0 0
t$perf-norm:sp_cancel_client_order 1793 1793 0 0.00 0 8006 29 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 3018 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 465 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 2228 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 3509 25 0 0
t$perf-norm:sp_cancel_supplier_order 383 383 0 0.00 0 19206 1654 0 0
t$perf-norm:sp_cancel_write_off 956 956 0 0.00 0 4736 10 0 0
t$perf-norm:sp_client_order 20625 20625 0 0.00 0 30960 18 0 0
t$perf-norm:sp_customer_reserve 969 969 0 0.00 0 144 2 0 0
t$perf-norm:sp_pay_from_customer 6930 6930 0 0.00 0 32229 11 0 0
t$perf-norm:sp_pay_to_supplier 5987 5987 0 0.00 0 6621 11 0 0
t$perf-norm:sp_reserve_write_off 9938 9938 0 0.00 0 6691 12 0 0
t$perf-norm:sp_supplier_invoice 5564 5564 0 0.00 0 7559 24 0 0
t$perf-norm:sp_supplier_order 5411 5411 0 0.00 0 29244 27 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 373 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 364 7 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 1066 19 0 0
t$perf-norm:srv_make_money_saldo 819 819 0 0.00 0 932 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 6 0 0
v_add_invoice_to_stock 10264 10050 214 2.08 0 5916 19 0 214
v_all_customers 37442 37442 0 0.00 0 20 1 0 0
v_all_suppliers 30426 30426 0 0.00 0 16 1 0 0
v_all_wares 41250 41250 0 0.00 0 146 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 2162 9 0 0
v_cancel_client_order 3586 3586 0 0.00 0 2393 5 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 7087 13 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 576 3 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 1038 4 0 0
v_cancel_supplier_invoice 884 868 16 1.80 0 4672 24 0 16
v_cancel_supplier_order 766 766 0 0.00 0 288 4 0 0
v_cancel_write_off 1912 1912 0 0.00 0 3924 16 0 0
v_max_id_clo_ord 5410 5410 0 0.00 0 255 1 0 0
v_max_id_clo_res 969 969 0 0.00 0 5496 17 0 0
v_max_id_ord_sup 5543 5543 0 0.00 0 5825 6 0 0
v_max_non_paid_invoice 1727 1727 0 0.00 0 779 3 0 0
v_max_non_paid_realizn 3742 3742 0 0.00 0 1248 3 0 0
v_min_id_clo_ord 5410 5410 0 0.00 0 6993 7 0 0
v_min_id_clo_res 969 969 0 0.00 0 9260 19 0 0
v_min_id_ord_sup 5543 5543 0 0.00 0 9277 10 0 0
v_min_non_paid_invoice 5987 5987 0 0.00 0 21278 38 0 0
v_min_non_paid_realizn 6930 6930 0 0.00 0 20660 33 0 0
v_our_firm 10184 10184 0 0.00 0 28 1 0 0
v_reserve_write_off 19868 19868 0 0.00 0 6568 6 0 0
x_lock_depdocs_on_canc_invoice 11290 11290 0 0.00 0 12136 125 0 0
x_lock_depdocs_on_canc_sup_ord 383 383 0 0.00 0 17471 526 0 0
x_make_qstorno_1000_1200 5411 5411 0 0.00 1 32303 1306 0 0
x_make_qstorno_1200_2000 5564 5564 0 0.00 3 86120 3451 0 0
x_make_qstorno_2100_3300 467218 467218 0 0.00 0 93519 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-01-2021 01:28:27 to 06-01-2021 01:28:31.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 25085 8192000000 10277282816 10590134272 985185312 10.735 76 58 114 1 1006882960 2755696 18941952
22:57:55 30660 8192000000 10348583024 10664955904 1402932080 14.621 100 89 178 0 1436903456 5576544 28394832
22:58:48 23062 8192000000 10393396624 10719592448 1448574832 15.025 100 90 180 1 1484424480 7430336 28419312
22:59:25 25918 8192000000 10431500320 10762616832 1487995760 15.371 100 92 185 1 1524989648 8145056 28848832
23:00:02 16173 8192000000 10447107504 10779418624 1505233776 15.522 100 94 188 0 1544204032 9161664 29808592
23:00:26 17229 8192000000 10455014272 10789904384 1511274512 15.574 100 91 182 1 1549921328 9555552 29091264
23:01:00 18470 8192000000 10467655488 10809593856 1527151648 15.712 100 84 168 0 1563638992 10037056 26450288
23:01:30 7593 8192000000 10481238064 10827132928 1544652720 15.864 100 74 148 0 1577083456 9963472 22467264
23:01:45 16766 8192000000 10523039920 10869653504 1575226896 16.127 100 81 162 0 1610314560 10507984 24579680
23:02:09 14941 8192000000 10540306896 10892517376 1594684720 16.294 100 77 154 0 1629335264 11188512 23462032
23:02:31 10192 8192000000 10561049152 10914594816 1616091248 16.477 100 85 170 1 1652844752 11662016 25091488
23:02:49 11933 8192000000 10569294624 10924654592 1625596880 16.557 100 85 170 1 1663171840 11785856 25789104
23:03:10 11150 8192000000 10590711696 10950664192 1646400464 16.734 100 76 152 1 1680377056 11816944 22159648
23:03:30 12214 8192000000 10619436400 10987753472 1670944624 16.941 100 75 150 0 1703747968 11260848 21542496
23:03:51 8576 8192000000 10632193040 11001094144 1694634928 17.140 100 69 138 1 1726382384 11917824 19829632
23:04:11 6493 8192000000 10661096080 11032436736 1720722080 17.358 100 87 174 1 1758253216 12207456 25323680
23:04:26 5715 8192000000 10668564720 11044286464 1728071840 17.419 100 76 152 0 1761862256 11802176 21988240
23:04:39 6516 8192000000 10696175696 11073069056 1759420304 17.680 100 87 170 0 1795067104 12245360 23401440
23:04:53 4883 8192000000 10705333024 11080445952 1765074208 17.726 100 87 172 1 1802588640 13068384 24446048
23:05:06 4835 8192000000 10708486848 11086319616 1771206720 17.777 100 79 154 1 1805538800 13267728 21064352
23:05:17 5550 8192000000 10719204784 11097759744 1779054528 17.842 100 84 167 0 1816946288 14576688 23315072
23:05:31 3383 8192000000 10721821072 11104858112 1784094464 17.883 100 82 164 0 1821254304 14007968 23151872
23:05:41 3241 8192000000 10732110944 11112202240 1789474720 17.927 100 81 162 1 1825300192 13534032 22291440
23:05:50 2921 8192000000 10740429408 11122069504 1796256160 17.983 100 85 168 2 1833826128 13885920 23684048
23:06:00 3668 8192000000 10744786032 11127799808 1805052432 18.055 100 93 187 2 1846702416 15284416 26365568
23:06:10 2436 8192000000 10753046768 11133190144 1805252416 18.057 100 81 163 2 1842664160 14920512 22491232
23:06:20 2278 8192000000 10756311232 11137101824 1813177616 18.122 100 88 176 0 1852162752 14654384 24330752
23:06:29 2504 8192000000 10764776144 11147472896 1825514448 18.223 100 85 167 1 1861734848 12825344 23395056
23:06:38 2299 8192000000 10759402448 11147431936 1824726016 18.216 100 88 175 4 1861080880 11133392 25221472
23:06:46 1819 8192000000 10769361536 11157221376 1835164272 18.301 100 91 181 3 1870664272 11040048 24459952
23:06:55 2734 8192000000 10776008992 11172286464 1844022416 18.374 100 81 162 1 1877681600 11679936 21979248
23:07:04 2096 8192000000 10786280448 11176812544 1849748992 18.420 100 83 166 2 1884400720 11843888 22807840
23:07:12 1608 8192000000 10796403184 11182055424 1854321168 18.457 100 93 187 2 1894293232 13644432 26327632
23:07:20 1759 8192000000 10801237648 11188211712 1861430752 18.515 100 89 177 1 1899095520 13498048 24166720
23:07:28 1670 8192000000 10811988128 11197153280 1862269088 18.522 100 94 190 1 1902859264 13890976 26699200
23:07:36 1172 8192000000 10808236272 11199172608 1862386832 18.523 100 90 181 1 1901589456 13518992 25683632
23:07:44 2337 8192000000 10808509696 11196112896 1865330432 18.546 100 85 168 2 1903247856 12854208 25063216
23:07:52 39575 8192000000 10802795328 11201835008 1868437424 18.572 100 63 126 3 1894370304 7637504 18295376
23:08:38 1641 8192000000 10828022128 11218018304 1878140720 18.650 100 92 183 0 1916937712 11257328 27539664
23:08:46 1864 8192000000 10810066784 11213545472 1873725392 18.614 100 66 132 0 1904323200 12355040 18242768
23:08:54 4177 8192000000 10791731280 11206541312 1871859296 18.599 100 45 88 2 1894383040 9535968 12987776
23:09:07 4304 8192000000 10785526528 11208577024 1874670992 18.622 100 49 97 2 1897831632 9088880 14071760
23:09:17 5821 8192000000 10795523088 11211214848 1872217248 18.602 100 33 66 1 1889770224 8257664 9295312
23:09:30 5065 8192000000 10796533408 11213283328 1874983568 18.625 100 39 78 0 1894764960 8930416 10850976
23:09:43 3292 8192000000 10788811104 11209797632 1879797552 18.663 100 48 95 1 1900857072 7352512 13707008
23:09:53 9738 8192000000 10790366608 11214831616 1880195792 18.667 100 36 74 1 1897646192 6902672 10547728
23:10:12 41957 8192000000 10817987520 11224223744 1881693376 18.679 100 43 88 0 1899521216 5349424 12478416
23:11:01 10588 8192000000 10791429488 11224363008 1879695616 18.663 100 22 44 0 1892457792 6824432 5937744
23:11:22 7766 8192000000 10796246800 11232260096 1888613808 18.735 100 32 64 0 1905345440 7835472 8896160
23:11:36 6477 8192000000 10805508432 11233779712 1892425984 18.765 100 37 75 1 1910258912 7117760 10715168
23:11:50 5852 8192000000 10801438720 11237093376 1891046384 18.754 100 22 44 0 1904680160 7324576 6309200
23:12:03 6814 8192000000 10804982464 11235393536 1892768528 18.768 100 26 52 2 1906410864 6527584 7114752
23:12:18 4823 8192000000 10816362432 11245273088 1899341168 18.821 100 31 62 2 1913887072 5706320 8839584
23:12:28 10644 8192000000 10812500960 11244716032 1901992272 18.842 100 25 48 1 1914892704 6198912 6701520
23:12:45 6460 8192000000 10819023248 11249049600 1903538192 18.855 100 28 55 3 1918612832 7399760 7674880
23:12:59 12018 8192000000 10816008528 11252908032 1904422512 18.862 100 20 38 2 1916145632 5912816 5810304
23:13:17 8118 8192000000 10815519008 11255644160 1906178240 18.876 100 17 34 2 1921405056 9618336 5608480
23:13:31 8595 8192000000 10819525600 11255595008 1905496752 18.870 100 17 34 2 1920079856 9778800 4804304
23:13:49 13848 8192000000 10813423712 11251822592 1905914064 18.874 100 17 34 1 1917604816 6625408 5065344
23:14:11 62929 8192000000 10830951344 11262320640 1912655136 18.928 100 30 60 3 1927250208 4895760 9699312
23:15:26 16204 8192000000 10824714448 11261304832 1907525264 18.887 100 15 30 1 1916712064 5295904 3890896
23:15:48 10529 8192000000 10813580208 11258032128 1907059136 18.883 100 20 36 3 1917499616 5101792 5338688
23:16:05 5746 8192000000 10827998128 11256217600 1908505968 18.895 100 38 74 3 1925364736 5537792 11320976
23:16:22 10823 8192000000 10834638800 11262005248 1904691904 18.864 100 19 38 1 1915898880 5701296 5505680
23:16:45 5875 8192000000 10818121264 11252391936 1905470416 18.870 100 28 56 0 1919886864 5839872 8576576
23:16:57 6379 8192000000 10807290624 11239567360 1891973616 18.762 100 28 55 1 1905825136 6147984 7703536
23:17:11 4216 8192000000 10781328768 11211300864 1853698224 18.452 98 37 74 1 1870665152 6126304 10840624
23:17:22 6244 8192000000 10784046496 11218001920 1859492640 18.499 99 21 40 4 1870692288 4769168 6430480
23:17:36 8815 8192000000 10778473248 11205992448 1809265728 18.090 96 18 36 2 1820698800 5470528 5962544
23:17:51 12146 8192000000 10780223232 11209482240 1837322768 18.319 98 21 43 0 1852657008 10149024 5185216
23:18:10 5920 8192000000 10736251952 11164082176 1798332896 18.000 98 17 34 2 1809174288 6221968 4619424
23:18:24 10302 8192000000 10757086864 11180711936 1818049152 18.162 99 16 32 1 1827841408 5462176 4330080
23:18:42 6565 8192000000 10675436256 11092602880 1719724624 17.350 95 22 44 1 1732043584 6096272 6222688
23:18:59 58078 8192000000 10712356368 11142725632 1806514320 18.067 100 39 77 0 1824311968 6553184 11244464
23:20:03 11335 8192000000 10700326704 11122040832 1707634304 17.249 94 17 34 1 1717774800 5769520 4370976
23:20:22 4662 8192000000 10710099728 11125374976 1776917696 17.824 99 37 74 1 1794581696 7115024 10548976
23:20:33 6065 8192000000 10704479616 11115962368 1771545888 17.780 99 33 64 1 1788209104 8007344 8655872
23:20:48 5620 8192000000 10688557904 11111366656 1782746960 17.872 99 29 59 1 1797568688 6287648 8534080
23:21:02 6122 8192000000 10716505136 11115646976 1764663616 17.723 99 34 68 2 1780194704 5959568 9571520
23:21:14 6573 8192000000 10735499904 11143294976 1802928256 18.038 100 27 55 1 1816654272 5815664 7910352
23:21:30 8376 8192000000 10690150656 11104735232 1740894304 17.526 97 20 40 2 1751786320 4585808 6306208
23:21:44 9538 8192000000 10709351536 11130322944 1781053088 17.858 99 30 60 1 1796027856 5160720 9814048
23:22:03 9824 8192000000 10726237696 11145691136 1794858672 17.972 99 20 39 1 1806200896 5340432 6001792
23:22:19 11256 8192000000 10731783440 11156672512 1819304912 18.172 100 17 32 0 1829364928 4783840 5276176
23:22:42 10548 8192000000 10729753184 11161186304 1810361792 18.099 99 23 46 2 1823835168 6298048 7175328
23:23:03 19384 8192000000 10746009520 11170070528 1830085472 18.260 100 12 24 0 1838633168 5190224 3357472
23:23:37 66752 8192000000 10739920160 11175239680 1835888016 18.307 100 26 52 1 1848926496 5289488 7748992
23:24:50 6802 8192000000 10763774304 11183394816 1847271648 18.400 100 25 51 1 1860490432 5724992 7493792
23:25:04 6900 8192000000 10769932768 11189927936 1849818192 18.421 100 24 48 0 1863926112 6942112 7165808
23:25:18 8636 8192000000 10763353184 11192836096 1851533696 18.435 100 26 52 0 1865676544 6655392 7487456
23:25:34 4025 8192000000 10772859616 11197739008 1854373200 18.458 100 21 42 3 1865849920 5961872 5514848
23:25:44 10807 8192000000 10769635552 11200237568 1856558080 18.475 100 22 44 1 1869328512 6222464 6547968
23:26:04 7015 8192000000 10774704768 11202494464 1860407008 18.507 100 27 54 0 1874598032 6787536 7403488
23:26:18 14762 8192000000 10779036944 11209658368 1863600912 18.532 100 25 50 0 1880843696 10817504 6425280
23:26:40 8576 8192000000 10779399712 11206914048 1862240000 18.521 100 22 42 4 1873773600 5603920 5929680
23:26:56 14403 8192000000 10800483696 11220447232 1869960624 18.584 100 24 48 1 1882207728 5223088 7024016
23:27:39 11144 8192000000 10833495120 11244535808 1898552640 18.815 100 59 118 0 1922870688 6891104 17426944
23:28:15 8654 8192000000 10836298368 11249954816 1905140000 18.868 100 53 106 1 1928311184 8143984 15027200
23:28:31 33061 8192000000 10851403680 11269824512 1909073280 18.899 100 37 74 0 1927829760 8220688 10535792
23:29:11 46861 8192000000 10858984080 11282071552 1922790896 19.009 100 49 96 1 1944956128 8672032 13493200
23:30:05 18564 8192000000 10862280000 11288588288 1934659760 19.104 100 43 87 1 1955921792 9337024 11925008
23:30:38 128531 8192000000 10863776848 11309805568 1934826720 19.105 100 33 66 0 1958614720 13870256 9917744
23:32:54 29718 8192000000 10871184912 11311546368 1944498096 19.183 100 28 56 3 1967408944 14576736 8334112
23:33:30 10905 8192000000 10885528240 11317518336 1949041584 19.219 100 41 78 3 1973841136 13158816 11640736
23:33:49 4117 8192000000 10900641744 11324719104 1958913344 19.297 100 50 100 3 1984775424 11326688 14535392
23:34:01 3484 8192000000 10908738944 11331911680 1964469952 19.342 100 69 137 1 1998495040 13140912 20884176
23:34:12 13396 8192000000 10904855520 11339292672 1969543776 19.382 100 52 104 0 1999331888 14876768 14911344
23:34:31 5017 8192000000 10920832304 11336970240 1952648240 19.248 99 77 153 2 1991444240 16593232 22202768
23:34:44 3748 8192000000 10928922736 11348217856 1976985904 19.441 100 79 156 0 2016412688 17055616 22371168
23:34:55 5650 8192000000 10917294384 11339456512 1968607440 19.374 100 72 145 2 2007340688 18380880 20352368
23:35:09 7181 8192000000 10919416688 11342217216 1972503904 19.405 100 75 148 1 2009239056 15939696 20795456
23:35:24 3464 8192000000 10941978400 11357257728 1982450832 19.484 100 75 151 0 2020240752 16323344 21466576
23:35:40 5398 8192000000 10940792576 11357614080 1987251264 19.522 100 70 140 0 2026353408 18108400 20993744
23:35:54 10993 8192000000 10944843312 11365187584 1990550656 19.548 100 70 138 2 2029852512 18715600 20586256
23:36:13 5188 8192000000 10946306928 11376361472 1993896832 19.575 100 71 139 2 2037998064 23714944 20386288
23:36:35 16550 8192000000 10945283552 11365404672 1973466000 19.413 99 71 143 1 2018010016 22962032 21581984
23:36:58 14662 8192000000 10927817920 11358605312 1984442048 19.500 100 55 111 1 2021764352 20829264 16493040
23:37:30 12981 8192000000 10932457392 11365720064 1989613984 19.541 100 55 108 4 2023421728 17653120 16154624
23:37:55 5647 8192000000 10947671312 11379986432 1995272032 19.585 100 57 114 1 2033831824 21477536 17082256
23:38:10 4105 8192000000 10951626736 11386486784 1998777152 19.613 100 57 114 0 2041868128 25183488 17907488
23:38:22 4752 8192000000 10950546208 11380969472 1999530576 19.619 100 75 150 1 2046222448 22607712 24084160
23:38:34 3038 8192000000 10967782864 11385683968 2004966800 19.662 100 87 171 1 2052313424 22109968 25236656
23:38:44 1233 8192000000 10962472064 11382177792 2004844624 19.661 100 90 176 1 2056241040 24704192 26692224
23:38:52 6391 8192000000 10960185136 11381465088 1982964192 19.488 99 84 168 0 2033834656 26043088 24827376
23:39:07 5884 8192000000 10954306832 11383009280 1999395168 19.618 100 81 162 0 2050992720 27324240 24273312
23:39:23 2477 8192000000 10964625824 11384877056 2002745600 19.644 100 76 149 1 2050620496 25242976 22631920
23:39:33 9998 8192000000 10955574192 11384836096 1993909248 19.575 100 65 130 1 2040641616 26926352 19806016
23:39:56 6452 8192000000 10942091840 11381698560 1976462800 19.437 99 43 86 2 2017381168 27395024 13523344
23:40:14 12996 8192000000 10914991696 11357892608 1971921792 19.401 99 42 83 1 2006936112 21964496 13049824
23:40:40 2921 8192000000 10929795632 11352014848 1970143088 19.387 100 64 130 0 2010344464 20347712 19853664
23:40:49 18366 8192000000 10933795568 11367071744 1973041104 19.410 100 52 104 0 2011053872 21487616 16525152
23:41:14 4911 8192000000 10938820544 11371593728 1987042192 19.520 100 54 107 1 2028100144 24238976 16818976
23:41:31 4929 8192000000 10945556208 11372048384 1983099056 19.489 99 63 123 0 2027291680 24885296 19307328
23:41:45 6846 8192000000 10968349600 11396657152 2002992032 19.646 100 69 130 3 2049674000 26197952 20484016
23:41:59 3509 8192000000 10943761344 11371192320 1984081280 19.497 100 68 135 3 2035632832 30285488 21266064
23:42:16 4924 8192000000 10957896848 11381600256 1988081824 19.529 100 65 130 1 2038561296 29779680 20699792
23:42:29 10462 8192000000 10971436128 11398520832 2000700176 19.628 100 68 134 1 2054251360 31064640 22486544
23:42:47 4962 8192000000 10955600048 11383062528 1975424000 19.428 99 59 116 0 2026534352 32129696 18980656
23:43:00 1757 8192000000 10958291808 11386585088 1989565296 19.540 100 75 150 2 2046935968 32872448 24498224
23:43:10 4232 8192000000 10955607056 11381039104 1973347888 19.412 99 72 144 2 2027624640 30742064 23534688
23:43:23 6485 8192000000 10958179760 11389558784 1992772272 19.566 100 62 124 0 2047429904 33376960 21280672
23:43:38 2740 8192000000 10969945744 11387994112 1990012848 19.544 100 76 151 2 2047954336 33909200 24032288
23:43:48 2863 8192000000 10959355792 11382480896 1984434944 19.500 100 79 157 1 2043882288 34283488 25163856
23:43:58 3991 8192000000 10929104368 11356086272 1956733552 19.280 99 64 127 2 2006481056 29857680 19889824
23:44:12 2730 8192000000 10952100464 11365588992 1970185216 19.387 100 83 166 0 2028104064 32314576 25604272
23:44:23 1627 8192000000 10965354304 11387117568 1990391440 19.547 100 79 157 0 2046754256 32905840 23456976
23:44:35 3076 8192000000 10955150368 11374821376 1967513472 19.366 99 72 144 1 2023379904 34006960 21859472
23:44:46 6306 8192000000 10958539584 11382996992 1985082576 19.505 100 74 148 2 2046849392 38185728 23581088
23:45:01 4864 8192000000 10960683984 11380936704 1978775744 19.455 100 75 150 2 2041370192 39042032 23552416
23:45:13 1268 8192000000 10967006160 11384655872 1981513984 19.477 100 80 157 3 2046293008 40110384 24668640
23:45:23 8882 8192000000 10934153872 11376132096 1960143552 19.307 99 43 86 1 2006581072 32466592 13970928
23:45:41 9655 8192000000 10921175120 11358760960 1958545632 19.294 99 46 92 0 2004985408 32016464 14423312
23:46:03 5601 8192000000 10930866752 11370180608 1971475856 19.397 100 43 84 4 2018378048 32719808 14182384
23:46:31 3450 8192000000 10961696592 11392225280 1988390048 19.531 100 55 110 2 2042614576 37268112 16956416
23:46:41 2092 8192000000 10962313232 11377659904 1953984304 19.258 98 85 169 0 2020811584 39484976 27342304
23:46:49 3799 8192000000 10971967264 11386843136 1972315776 19.404 99 84 167 0 2038742992 40405616 26021600
23:47:04 5093 8192000000 10946853392 11389079552 1979855488 19.464 100 52 104 1 2035812400 39682640 16274272
23:47:16 7061 8192000000 10931034608 11373391872 1971417152 19.397 100 48 96 4 2021632448 34310736 15904560
23:47:30 7643 8192000000 10944882288 11382272000 1979979152 19.465 100 53 106 0 2031509008 34536416 16993440
23:47:48 9244 8192000000 10925979104 11364143104 1950064976 19.227 99 39 78 1 1998673008 35946112 12661920
23:48:11 4247 8192000000 10907592064 11337461760 1924722240 19.025 98 51 102 1 1979514592 38653840 16138512
23:48:23 3502 8192000000 10915854720 11337236480 1938341248 19.134 100 66 132 1 1999199712 40124304 20734160
23:48:35 3262 8192000000 10923656768 11344232448 1943813904 19.177 100 63 126 2 2005588160 41233760 20540496
23:48:47 8781 8192000000 10917040816 11351207936 1945587328 19.191 100 39 78 1 2001775648 42992512 13195808
23:49:03 12448 8192000000 10897887024 11343319040 1929018960 19.059 99 31 63 1 1983365888 43015520 11331408
23:49:22 7402 8192000000 10882699648 11323060224 1908736800 18.897 98 30 60 1 1957126896 38476384 9913712
23:49:37 13337 8192000000 10902723024 11340128256 1923551664 19.015 99 38 76 0 1976435632 40582240 12301728
23:50:04 13266 8192000000 10930914640 11367395328 1955379120 19.269 100 38 75 1 2011939776 44253136 12307520
23:50:31 23067 8192000000 10905204928 11355574272 1926310240 19.037 99 28 56 2 1982480832 46351184 9819408
23:51:06 19290 8192000000 10878947936 11321700352 1898872848 18.817 98 27 54 0 1951551664 43453088 9225728
23:51:34 23483 8192000000 10864024720 11297529856 1851594480 18.435 97 31 62 1 1906046624 43715472 10736672
23:52:04 19023 8192000000 10870655280 11309789184 1901118352 18.835 100 31 62 2 1960357360 48012384 11226624
23:52:55 34510 8192000000 10874575824 11321872384 1896243824 18.796 100 27 54 0 1956719664 50936256 9539584
23:53:36 51348 8192000000 10854013488 11317846016 1866438144 18.555 98 17 34 0 1918820560 46389584 5992832
23:54:34 52304 8192000000 10865176976 11314741248 1912469136 18.926 100 26 51 0 1945755136 25303072 7982928
23:55:34 22898 8192000000 10844860864 11294269440 1887574080 18.726 98 40 78 2 1919436128 20270624 11591424
23:56:04 26670 8192000000 10831318752 11286052864 1887751760 18.728 99 18 36 1 1902530352 10268064 4510528
23:56:37 53233 8192000000 10817353744 11269132288 1833222896 18.286 96 18 36 1 1846655120 8212480 5219744
23:57:40 123018 8192000000 10819230624 11271704576 1825169072 18.220 95 30 61 3 1840150656 6486544 8495040
23:59:49 111595 8192000000 10823823072 11272835072 1840906112 18.348 96 27 54 2 1855681824 7059024 7716688
00:01:47 60541 8192000000 10832431072 11283599360 1876208304 18.634 98 12 24 0 1885372816 6131120 3033392
00:02:54 90546 8192000000 10853711712 11310256128 1890709792 18.752 98 17 34 2 1905154960 9206176 5238992
00:05:40 17207 8192000000 10919337920 11352985600 1952320832 19.245 100 43 85 1 1981172784 15049120 13802832
00:06:04 43555 8192000000 10898975280 11356459008 1961363248 19.317 100 19 38 3 1984799456 17614128 5822080
00:06:59 41715 8192000000 10910624352 11357224960 1966946576 19.361 100 26 52 0 1994902384 19782208 8173600
00:07:57 38206 8192000000 10892735488 11356512256 1949962688 19.226 99 24 48 0 1981145856 23668576 7514592
00:08:58 123476 8192000000 10878321968 11366072320 1964053984 19.338 100 20 41 0 1989755040 19664064 6036992
00:11:22 81148 8192000000 10906893472 11375562752 1966324016 19.356 100 19 38 1 1988639216 17481024 4834176
00:12:52 38094 8192000000 10894380784 11370553344 1975578896 19.430 100 22 44 1 1992337408 10696336 6062176
00:13:37 43455 8192000000 10917205776 11381649408 1988646400 19.533 100 40 80 2 2013932192 13324320 11961472
00:14:55 67591 8192000000 10917395456 11395203072 1986425120 19.516 100 14 28 1 2003384112 13035680 3923312
00:16:28 16834 8192000000 10932087600 11373543424 1984484944 19.500 100 55 113 1 2007416512 6816256 16115312
00:16:54 28564 8192000000 10897322176 11369852928 1973598032 19.414 100 12 24 0 1984989424 8180016 3211376
00:17:29 62179 8192000000 10923657232 11393241088 1984595072 19.501 100 11 22 1 1999907168 12384640 2927456
00:18:37 75535 8192000000 10914785200 11377889280 1967977088 19.369 99 13 26 0 1990048336 18245968 3825280
00:19:59 30040 8192000000 10930728592 11387977728 1991877424 19.559 100 22 44 0 2006626656 8541248 6207984
00:20:35 96503 8192000000 10895560704 11368833024 1914970304 18.947 96 19 38 0 1931196672 11258672 4967696
00:22:18 56428 8192000000 10906782656 11365060608 1920139840 18.988 97 16 32 2 1934971296 10546288 4285168
00:23:23 71741 8192000000 10899017216 11372605440 1935425712 19.110 98 16 32 0 1952699920 13043312 4230896
00:24:41 84844 8192000000 10910885488 11370823680 1943229536 19.173 98 27 54 1 1959095792 7590032 8276224
00:26:31 62506 8192000000 10901603712 11369889792 1944404064 19.182 98 40 80 2 1969650912 13577536 11669312
00:27:40 80301 8192000000 10889365280 11368583168 1912522016 18.927 97 18 36 0 1936757264 19511088 4724160
00:29:11 2259 8192000000 10907225408 11348688896 1953378688 19.253 100 47 94 1 1980546944 13794512 13373744
00:29:39 21936 8192000000 10882131552 11327950848 1928523408 19.055 99 52 101 1 1956765360 13135392 15106560
00:30:08 15113 8192000000 10859954912 11323420672 1931381824 19.078 99 53 102 0 1954403024 8668912 14352288
00:30:38 60813 8192000000 10852834960 11327471616 1917959712 18.970 98 17 34 1 1930171712 7565584 4646416
00:31:47 14112 8192000000 10838096560 11311788032 1908986496 18.899 98 3 6 0 1915869120 5908160 974464
00:32:07 79429 8192000000 10871997248 11346440192 1949979040 19.226 100 18 36 1 1962383600 7298800 5105760
00:33:35 31047 8192000000 10862973504 11332255744 1929025504 19.059 99 4 8 0 1940168816 10031920 1111392
00:34:12 47734 8192000000 10881008432 11350949888 1933970336 19.099 99 11 22 1 1947875376 10224816 3680224
00:35:08 33775 8192000000 10892325376 11338407936 1885037712 18.706 96 39 78 2 1913024688 16046192 11940784
00:35:59 57219 8192000000 10870375760 11338088448 1912069328 18.923 98 18 36 3 1928690432 11511856 5109248
00:37:19 35731 8192000000 10871409792 11335254016 1890498624 18.750 97 15 30 0 1911833712 16521744 4813344
00:38:03 52597 8192000000 10835013696 11298123776 1823926608 18.210 94 17 34 0 1842151808 13024976 5200224
00:39:02 45256 8192000000 10839429696 11298668544 1849413008 18.417 96 23 46 0 1868305568 12016048 6876512
00:40:07 48756 8192000000 10798270336 11243462656 1758074368 17.668 92 17 34 0 1769612688 6939824 4598496
00:41:05 10094 8192000000 10848514496 11281182720 1900836272 18.833 100 58 113 1 1926241584 8668304 16737008
00:41:21 47362 8192000000 10824454944 11275612160 1827602240 18.240 96 39 78 3 1851656240 13320160 10733840
00:42:20 62819 8192000000 10807646048 11261063168 1764935072 17.725 93 24 48 0 1781015872 9469104 6611696
00:43:46 29042 8192000000 10828694480 11266772992 1840000688 18.341 97 30 59 0 1856046864 7792624 8253552
00:44:24 51042 8192000000 10838166832 11284000768 1874418960 18.620 99 36 72 1 1895894192 11344640 10130592
00:46:57 95746 8192000000 10839536240 11296477184 1906050352 18.875 99 21 42 2 1921404384 9295312 6058720
00:48:44 123300 8192000000 10831444624 11307335680 1851790256 18.437 96 32 64 2 1874684048 13432016 9461776
00:50:54 42605 8192000000 10831069840 11311677440 1902181584 18.844 99 10 19 2 1920675376 15884176 2609616
00:51:46 53917 8192000000 10833117648 11307769856 1918811504 18.977 100 6 12 1 1927932064 7835552 1285008
00:52:46 49817 8192000000 10832370560 11295907840 1889213552 18.739 98 11 22 0 1897953184 5766576 2973056
00:54:42 70400 8192000000 10850066880 11325952000 1918027760 18.971 99 15 30 0 1932035616 9732368 4275488
00:56:04 122857 8192000000 10879694848 11339288576 1917624704 18.968 99 7 14 1 1930372896 10630960 2117232
00:58:14 40945 8192000000 10908080368 11349450752 1958363072 19.293 100 32 63 3 1973796176 6917552 8515552
00:59:02 39319 8192000000 10905049424 11367997440 1952803504 19.249 99 26 51 3 1970734896 10661776 7269616
00:59:47 65300 8192000000 10906879248 11374227456 1958813568 19.297 99 15 30 1 1976244592 13127168 4303856
01:00:59 81866 8192000000 10906352864 11387662336 1961146416 19.315 99 15 30 0 1979969136 14141776 4680944
01:02:28 90405 8192000000 10918002304 11387064320 1944079456 19.179 98 21 41 2 1968200128 17855504 6265168
01:04:06 36499 8192000000 10937678048 11385999360 1991342480 19.554 100 31 62 1 2011111280 10759296 9009504
01:05:01 31068 8192000000 10919671456 11380473856 1971858816 19.400 99 22 44 0 1986178048 8649440 5669792
01:05:43 42865 8192000000 10942920800 11390754816 1987320400 19.523 100 21 42 1 2003362208 10221968 5819840
01:06:35 68996 8192000000 10910987424 11383783424 1962813072 19.328 99 20 40 0 1985533776 16970896 5749808
01:07:52 86443 8192000000 10902761344 11380498432 1968895728 19.377 99 17 34 0 1998536416 24451504 5189184
01:09:25 38986 8192000000 10928051504 11390296064 1964728992 19.344 99 22 44 1 1981435152 10851456 5854704
01:10:10 37896 8192000000 10908432416 11392565248 1964025616 19.338 99 9 17 2 1986663120 19432704 3204800
01:10:54 99261 8192000000 10886720320 11353382912 1899956928 18.826 96 13 26 1 1919404736 15337520 4110288
01:13:02 102736 8192000000 10891663552 11357544448 1894474944 18.782 96 19 38 2 1909111456 9054192 5582320
01:15:03 35351 8192000000 10868824816 11337531392 1918840880 18.978 98 14 28 0 1930552624 7921056 3790688
01:16:02 33282 8192000000 10867117344 11351445504 1951655712 19.240 100 3 6 1 1959417936 7143312 618912
01:16:42 34228 8192000000 10878364336 11363835904 1964007472 19.338 100 6 12 0 1972935680 7440640 1487568
01:17:26 46008 8192000000 10880562160 11358351360 1954353024 19.261 99 13 22 0 1966142448 8682848 3106576
01:18:19 61690 8192000000 10889436480 11366117376 1913882192 18.938 97 11 22 0 1928915232 11764544 3268496
01:19:34 59697 8192000000 10883383776 11346796544 1893870528 18.777 96 23 46 1 1910332912 9842560 6619824
01:21:43 87072 8192000000 10868379296 11358441472 1914777200 18.945 98 12 24 0 1937138384 18469600 3891584
01:23:24 100895 8192000000 10857151824 11323813888 1816064576 18.146 93 11 21 0 1833085600 14459584 2561440
01:25:30 25738 8192000000 10907842320 11350138880 1935451680 19.110 99 47 94 2 1957097040 8617008 13028352
01:26:03 50382 8192000000 10881885648 11352440832 1918358368 18.974 98 34 68 1 1940958288 13065424 9534496
01:27:00 21556 8192000000 9460231008 9760800768 602455392 6.850 31 4 8 0 610897360 7364720 1077248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          241226
MON$OLDEST_ACTIVE               241227
MON$OLDEST_SNAPSHOT             241227
MON$NEXT_TRANSACTION            241227
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                       2009792
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:453: 
:454: mscs-test-161.budzdorov.ru    Wed Jan  6 01:27:31 2021
:455:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:456: 
:457: 
:458: mscs-test-161.budzdorov.ru    Wed Jan  6 01:27:31 2021
:459:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:460: 
--- end of diff output ---

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

06.01.21 01:29:07. 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-06 01:29:09 No severe PSQL-related problems occured
06.01.21 01:29:11. End of report.