Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.01.2021 19: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 17107216 kB
MemAvailable 31301556 kB
Buffers 0 kB
Cached 14572088 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-20 19:27:14
DTS_END                         2021-01-20 19:27:14.9780
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/60378
TRN_ID                          237698
ATT_ID                          684
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: 9118.25 20355 1094190
customer order: creation 169.99 349 20399
customer order: refuse 14.84 325 1781
order to supplier: creation 45.64 1314 5477
order to supplier: removal 3.59 111344 431
invoice (draft): creation 45.38 3311 5445
invoice (draft): removal 53.42 832 6410
invoice accept: apply 40.31 17360 4837
invoice accept: cancel 48.13 884 5776
customer reserve: creation 3703.26 171 444391
customer reserve: removal 4698.15 67 563778
realization accept: apply 80.98 167 9718
realization accept: cancel 85.78 118 10293
payment from customer: creation 58.29 110 6995
payment from customer: removal 5.73 110 687
payment to supplier: creation 49.18 128 5901
payment to supplier: removal 3.37 56 404
service: total inventory turnovers 4.56 1210 547
service: total monetary turnovers 6.67 33 800
service: aggregate perf. data 0.97 14599 116
service: refresh index statistics 0.03 254616 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4362
TEST_TIME 2 3996
TEST_TIME 3 4234
TEST_TIME 4 4206
TEST_TIME 5 4969
TEST_TIME 6 5014
TEST_TIME 7 4917
TEST_TIME 8 5112
TEST_TIME 9 5470
TEST_TIME 10 5464
TEST_TIME 11 5766
TEST_TIME 12 5840
TEST_TIME 13 5931
TEST_TIME 14 6063
TEST_TIME 15 6278
TEST_TIME 16 6780
TEST_TIME 17 7075
TEST_TIME 18 7084
TEST_TIME 19 7253
TEST_TIME 20 7357
TEST_TIME 21 7682
TEST_TIME 22 8264
TEST_TIME 23 8346
TEST_TIME 24 8570
TEST_TIME 25 8771
TEST_TIME 26 8653
TEST_TIME 27 8642
TEST_TIME 28 9848
TEST_TIME 29 10461
TEST_TIME 30 11105
TEST_TIME 31 10927
TEST_TIME 32 10712
TEST_TIME 33 10496
TEST_TIME 34 10427
TEST_TIME 35 10442
TEST_TIME 36 10417
TEST_TIME 37 10225
TEST_TIME 38 10070
TEST_TIME 39 10064
TEST_TIME 40 10007
TEST_TIME 41 9873
TEST_TIME 42 9751
TEST_TIME 43 9616
TEST_TIME 44 9778
TEST_TIME 45 9702
TEST_TIME 46 9584
TEST_TIME 47 9421
TEST_TIME 48 9531
TEST_TIME 49 9543
TEST_TIME 50 9484
TEST_TIME 51 9377
TEST_TIME 52 9312
TEST_TIME 53 9287
TEST_TIME 54 9315
TEST_TIME 55 9251
TEST_TIME 56 9218
TEST_TIME 57 9212
TEST_TIME 58 9228
TEST_TIME 59 9232
TEST_TIME 60 9244
TEST_TIME 61 9275
TEST_TIME 62 9241
TEST_TIME 63 9301
TEST_TIME 64 9324
TEST_TIME 65 9352
TEST_TIME 66 9341
TEST_TIME 67 9436
TEST_TIME 68 9409
TEST_TIME 69 9454
TEST_TIME 70 9467
TEST_TIME 71 9454
TEST_TIME 72 9510
TEST_TIME 73 9495
TEST_TIME 74 9418
TEST_TIME 75 9395
TEST_TIME 76 9408
TEST_TIME 77 9336
TEST_TIME 78 9259
TEST_TIME 79 9290
TEST_TIME 80 9243
TEST_TIME 81 9261
TEST_TIME 82 9275
TEST_TIME 83 9204
TEST_TIME 84 9145
TEST_TIME 85 9108
TEST_TIME 86 9021
TEST_TIME 87 9111
TEST_TIME 88 9108
TEST_TIME 89 9081
TEST_TIME 90 9101
TEST_TIME 91 9090
TEST_TIME 92 9128
TEST_TIME 93 9149
TEST_TIME 94 9171
TEST_TIME 95 9222
TEST_TIME 96 9234
TEST_TIME 97 9244
TEST_TIME 98 9242
TEST_TIME 99 9243
TEST_TIME 100 9328
TEST_TIME 101 9324
TEST_TIME 102 9330
TEST_TIME 103 9344
TEST_TIME 104 9283
TEST_TIME 105 9234
TEST_TIME 106 9209
TEST_TIME 107 9207
TEST_TIME 108 9210
TEST_TIME 109 9189
TEST_TIME 110 9157
TEST_TIME 111 9108
TEST_TIME 112 9097
TEST_TIME 113 9100
TEST_TIME 114 9119
TEST_TIME 115 9104
TEST_TIME 116 9077
TEST_TIME 117 9156
TEST_TIME 118 9203
TEST_TIME 119 9191
TEST_TIME 120 9122

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1508680 1508680 0 0.00 0 25668 6 0 0
doc_list_biud 1508670 1508670 0 0.00 0 44722 31 0 0
sp_add_invoice_to_stock 4939 4837 102 2.06 34 184338 17361 0 102
sp_cancel_adding_invoice 5776 5776 0 0.00 5 55308 884 0 0
sp_cancel_client_order 1781 1781 0 0.00 4 7403 325 0 0
sp_cancel_customer_reserve 563778 563778 0 0.00 1 44723 68 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 3 5089 111 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 2 2486 57 0 0
sp_cancel_supplier_invoice 6415 6410 5 0.07 2 16321 833 0 5
sp_cancel_supplier_order 431 431 0 0.00 8 1436423 111344 0 0
sp_cancel_write_off 10293 10293 0 0.00 1 19369 118 0 0
sp_client_order 20399 20399 0 0.00 3 23821 350 0 0
sp_customer_reserve 444391 444391 0 0.00 0 143737 172 0 0
sp_fill_shopping_cart 31321 31321 0 0.00 1 15336 40 0 0
sp_fill_shopping_cart_clo_res 444387 444387 0 0.00 0 21070 14 0 0
sp_get_clo_for_invoice 4833 4833 0 0.00 0 31605 332 0 0
sp_kill_cost_storno 17160 17160 0 0.00 0 25655 62 0 0
sp_kill_qstorno_ret_qs2qd 1144690 1144690 0 0.00 0 44721 36 0 0
sp_kill_qty_storno 603016 603016 0 0.00 0 44722 77 0 0
sp_lock_selected_doc 20347 20347 0 0.00 0 6929 5 0 0
sp_make_cost_storno 27447 27447 0 0.00 0 14194 56 0 0
sp_multiply_rows_for_pdistr 27437 27437 0 0.00 0 11893 30 0 0
sp_multiply_rows_for_qdistr 20399 20399 0 0.00 0 20259 166 0 0
sp_pay_from_customer 6995 6995 0 0.00 4 10616 111 0 0
sp_pay_to_supplier 5901 5901 0 0.00 5 14355 128 0 0
sp_payment_common 12890 12890 0 0.00 1 10347 29 0 0
sp_qd_handle_on_cancel_clo 1781 1781 0 0.00 0 7396 296 0 0
sp_qd_handle_on_invoice_upd_sts 10607 10607 0 0.00 0 20661 329 0 0
sp_qd_handle_on_reserve_upd_sts 9716 9716 0 0.00 0 23523 59 0 0
sp_reserve_write_off 9718 9718 0 0.00 6 27048 168 0 0
sp_supplier_invoice 5445 5445 0 0.00 6 83330 3311 0 0
sp_supplier_order 5477 5477 0 0.00 5 33024 1314 0 0
srv_aggregate_perf_data 116 116 0 0.00 2383 152511 14599 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1028 141829 32027 0 0
srv_find_qd_qs_mism 1048853 1048853 0 0.00 0 21365 5 0 0
srv_make_invnt_saldo 547 547 0 0.00 31 134245 1211 0 0
srv_make_money_saldo 800 800 0 0.00 0 5273 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 148081 432374 254617 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4837 4837 0 0.00 0 19661 156 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 1 6231 103 0 0
t$perf-norm:sp_cancel_client_order 1781 1781 0 0.00 0 4283 15 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 2868 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 5478 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 2662 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 5389 30 0 0
t$perf-norm:sp_cancel_supplier_order 431 431 0 0.00 0 17413 1643 0 0
t$perf-norm:sp_cancel_write_off 949 949 0 0.00 0 811 3 0 0
t$perf-norm:sp_client_order 20399 20399 0 0.00 0 8001 16 0 0
t$perf-norm:sp_customer_reserve 964 964 0 0.00 0 1204 6 0 0
t$perf-norm:sp_pay_from_customer 6995 6995 0 0.00 0 5841 8 0 0
t$perf-norm:sp_pay_to_supplier 5901 5901 0 0.00 0 6737 8 0 0
t$perf-norm:sp_reserve_write_off 9718 9718 0 0.00 0 4314 9 0 0
t$perf-norm:sp_supplier_invoice 5445 5445 0 0.00 0 3175 13 0 0
t$perf-norm:sp_supplier_order 5477 5477 0 0.00 0 7927 18 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 262 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 663 7 0 0
t$perf-norm:srv_make_invnt_saldo 547 547 0 0.00 0 1575 26 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 3809 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9862 9658 204 2.06 0 8892 18 0 204
v_all_customers 37036 37036 0 0.00 0 17 1 0 0
v_all_suppliers 30572 30572 0 0.00 0 17 1 0 0
v_all_wares 40798 40798 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 146 5 0 0
v_cancel_client_order 3562 3562 0 0.00 0 1330 5 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 2457 6 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 2795 7 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 775 3 0 0
v_cancel_supplier_invoice 856 846 10 1.16 0 1435 14 0 10
v_cancel_supplier_order 862 862 0 0.00 0 769 5 0 0
v_cancel_write_off 1898 1898 0 0.00 0 3204 17 0 0
v_max_id_clo_ord 5477 5477 0 0.00 0 1657 2 0 0
v_max_id_clo_res 964 964 0 0.00 0 2812 16 0 0
v_max_id_ord_sup 5445 5445 0 0.00 0 3691 4 0 0
v_max_non_paid_invoice 1533 1533 0 0.00 0 364 3 0 0
v_max_non_paid_realizn 3788 3788 0 0.00 0 6016 6 0 0
v_min_id_clo_ord 5477 5477 0 0.00 0 3755 7 0 0
v_min_id_clo_res 964 964 0 0.00 0 8050 21 0 0
v_min_id_ord_sup 5445 5445 0 0.00 0 3579 3 0 0
v_min_non_paid_invoice 5897 5897 0 0.00 0 7714 21 0 0
v_min_non_paid_realizn 6993 6993 0 0.00 0 6589 16 0 0
v_our_firm 10172 10172 0 0.00 0 12 1 0 0
v_reserve_write_off 19432 19432 0 0.00 0 1510 4 0 0
x_lock_depdocs_on_canc_invoice 11763 11763 0 0.00 0 25101 138 0 0
x_lock_depdocs_on_canc_sup_ord 431 431 0 0.00 0 13189 405 0 0
x_make_qstorno_1000_1200 5477 5477 0 0.00 2 33016 1222 0 0
x_make_qstorno_1200_2000 5445 5445 0 0.00 3 76578 3177 0 0
x_make_qstorno_2100_3300 444391 444391 0 0.00 0 143735 156 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 9951 8192000000 10194036592 10502119424 880190864 9.702 71 55 116 1 900383408 2252400 17940144
16:57:42 35622 8192000000 10341871280 10661535744 1379916432 14.416 100 83 166 0 1411330704 4653056 26761216
16:58:31 30739 8192000000 10391238304 10715131904 1443374880 14.979 100 92 184 0 1480579792 7019648 30185264
16:59:14 30986 8192000000 10411917024 10743107584 1465806528 15.177 100 89 178 0 1503065440 8210080 29048832
16:59:55 17562 8192000000 10431821744 10764484608 1482002992 15.319 100 82 164 0 1516871408 8758528 26109888
17:00:44 19037 8192000000 10455869312 10794807296 1514990496 15.607 100 88 176 0 1552789360 9923408 27875456
17:01:16 12500 8192000000 10486031728 10828275712 1537022624 15.798 100 83 166 0 1572910688 9951952 25936112
17:01:38 17328 8192000000 10508298336 10857095168 1564386400 16.034 100 86 173 0 1601343936 10391520 26566016
17:02:05 16093 8192000000 10530433152 10882269184 1586434384 16.223 100 89 178 1 1625007952 10837792 27735776
17:02:29 13776 8192000000 10541402656 10898530304 1603107008 16.366 100 80 160 0 1638459920 11301392 24051520
17:02:50 15949 8192000000 10563816144 10920988672 1616615360 16.481 100 80 160 1 1651871184 11553744 23702080
17:03:14 12087 8192000000 10578323664 10940575744 1634307392 16.631 100 79 158 0 1670324272 12048208 23968672
17:03:35 8986 8192000000 10587425488 10957967360 1655803904 16.813 100 79 158 1 1691452048 12136080 23512064
17:03:55 12688 8192000000 10616997520 10987028480 1683021808 17.043 100 78 154 2 1718011376 11534352 23455216
17:04:15 6131 8192000000 10628202208 11002003456 1693257408 17.129 100 74 149 3 1726805952 12221920 21326624
17:04:28 6102 8192000000 10650852064 11021602816 1709160128 17.262 100 79 158 0 1743940880 12854976 21925776
17:04:42 6787 8192000000 10660141984 11036311552 1721965296 17.369 100 75 150 1 1755982096 12804464 21212336
17:04:56 6812 8192000000 10665591856 11042799616 1732502000 17.456 100 69 138 0 1764212432 11870112 19840320
17:05:11 5749 8192000000 10678490608 11057090560 1745808768 17.567 100 74 146 0 1779062880 12787424 20466688
17:05:24 4935 8192000000 10684213392 11066908672 1754431664 17.638 100 81 163 1 1789532240 12425840 22674736
17:05:36 3189 8192000000 10694247696 11074945024 1762167664 17.702 100 69 138 2 1794159056 12722208 19269184
17:05:47 2695 8192000000 10717419568 11093540864 1776111504 17.817 100 84 168 1 1817628480 17936768 23580208
17:05:56 3691 8192000000 10716565088 11100856320 1782948912 17.874 100 77 154 0 1817697792 12700688 22048192
17:06:06 3136 8192000000 10729315712 11112665088 1787721952 17.913 100 78 156 0 1822642752 13311632 21609168
17:06:18 10758 8192000000 10734738096 11122241536 1795237808 17.975 100 78 156 1 1830396048 13525920 21632320
17:06:36 3835 8192000000 10746776512 11132964864 1803894464 18.046 100 81 162 1 1839381920 12697040 22790416
17:06:47 3616 8192000000 10751518992 11143479296 1818675632 18.167 100 78 156 0 1853934528 12139712 23119184
17:06:59 2845 8192000000 10767779664 11152273408 1825592976 18.223 100 82 164 1 1862182896 13241056 23348864
17:07:08 2400 8192000000 10781975936 11165429760 1836605520 18.313 100 92 185 1 1876201120 13301600 26294000
17:07:16 2660 8192000000 10779800048 11165323264 1837438864 18.320 100 85 171 3 1875204256 14518544 23246848
17:07:25 2566 8192000000 10790986880 11175960576 1842132768 18.358 100 91 182 2 1881972416 14704624 25135024
17:07:34 2031 8192000000 10796451072 11182637056 1847946496 18.405 100 87 176 0 1886391488 14219280 24225712
17:07:43 1628 8192000000 10793851856 11183050752 1851764640 18.436 100 85 170 0 1893716736 18329968 23622128
17:07:51 1677 8192000000 10793179872 11184107520 1851308976 18.433 100 89 178 1 1890687152 14360496 25017680
17:07:59 2046 8192000000 10796919168 11187609600 1854245904 18.457 100 87 174 2 1891688944 12531728 24911312
17:08:08 1419 8192000000 10795092992 11185033216 1859674016 18.501 100 90 176 4 1896976080 11667216 25634848
17:08:17 2313 8192000000 10803759056 11194327040 1866081920 18.553 100 86 173 0 1902706560 11867168 24757472
17:08:26 2582 8192000000 10790444448 11191668736 1864110272 18.537 100 78 156 1 1898721792 12507552 22103968
17:08:37 16208 8192000000 10805176576 11198038016 1865302352 18.546 100 78 157 2 1899212656 11933824 21976480
17:09:00 1492 8192000000 10819223632 11208196096 1876331136 18.635 100 92 182 2 1915226384 13381760 25513488
17:09:08 10293 8192000000 10813618432 11209375744 1870868112 18.591 100 75 150 0 1908758224 17264512 20625600
17:09:24 5676 8192000000 10797203568 11205910528 1872952576 18.608 100 65 129 1 1903704752 11943312 18808864
17:09:36 4760 8192000000 10796439648 11210502144 1876045744 18.633 100 59 118 1 1908095136 15374032 16675360
17:09:48 3794 8192000000 10786848112 11206991872 1874801024 18.623 100 35 70 0 1893754784 9308352 9645408
17:09:59 5273 8192000000 10794476816 11208040448 1876835072 18.640 100 34 68 1 1894038432 6342080 10861280
17:10:11 2106 8192000000 10795545264 11209129984 1878865728 18.656 100 39 79 3 1896444720 6105744 11473248
17:10:20 5753 8192000000 10793080720 11215020032 1877675376 18.646 100 29 58 0 1893104544 7108528 8320640
17:10:34 6288 8192000000 10787176080 11210080256 1878610816 18.654 100 28 56 3 1894246624 7294704 8341104
17:10:46 3863 8192000000 10788363568 11216982016 1879265632 18.659 100 33 66 1 1894819424 6625552 8928240
17:10:59 8422 8192000000 10798275136 11219685376 1881096592 18.674 100 37 74 0 1899189296 7631248 10461456
17:11:14 6219 8192000000 10788592048 11217326080 1879902672 18.664 100 24 47 1 1893132560 6254928 6974960
17:11:29 12232 8192000000 10783328960 11217756160 1881950192 18.681 100 13 26 0 1891275840 5684128 3641520
17:11:48 6489 8192000000 10798880256 11223494656 1887496256 18.726 100 27 54 0 1901244832 6542112 7206464
17:12:02 9658 8192000000 10790522832 11225325568 1889915200 18.745 100 25 50 0 1903463248 6396736 7151312
17:12:19 15598 8192000000 10806261760 11231498240 1890051040 18.746 100 19 36 2 1901378384 5783344 5544000
17:12:44 10171 8192000000 10822834784 11239428096 1893380256 18.773 100 36 73 2 1910953824 7065040 10508528
17:13:00 67542 8192000000 10809665424 11246338048 1898859680 18.817 100 40 78 1 1915796192 5101264 11835248
17:14:15 7188 8192000000 10814809504 11245088768 1895999568 18.794 100 18 36 1 1906487744 5426208 5061968
17:14:31 6466 8192000000 10812586960 11247755264 1898810768 18.817 100 26 52 1 1912174096 6537040 6826288
17:14:44 6172 8192000000 10810949248 11247132672 1901819984 18.841 100 29 59 4 1915716928 5766112 8130832
17:14:59 5489 8192000000 10811560560 11242205184 1880509120 18.669 99 24 48 1 1893740304 6772704 6458480
17:15:12 6417 8192000000 10819753088 11240833024 1879868816 18.664 99 35 70 2 1895366752 4978528 10519408
17:15:28 7402 8192000000 10809227008 11245240320 1894555520 18.782 100 30 60 2 1908636720 5631584 8449616
17:15:42 7700 8192000000 10810870640 11246268416 1894910576 18.785 100 23 46 0 1907577056 5700176 6966304
17:15:56 3973 8192000000 10811370256 11242786816 1891841232 18.761 100 39 78 2 1909789344 6531440 11416672
17:16:07 9997 8192000000 10810499760 11243057152 1889892976 18.745 100 18 35 2 1900817056 5730736 5193344
17:16:25 10824 8192000000 10796872144 11230007296 1858715984 18.493 98 25 50 2 1871757104 6244288 6796832
17:16:49 11357 8192000000 10798035136 11234181120 1856210080 18.473 98 17 34 0 1867119424 6295728 4613616
17:17:11 9963 8192000000 10784442896 11216285696 1854830480 18.461 98 22 44 1 1867294304 6551824 5912000
17:17:29 4957 8192000000 10790416672 11222192128 1874761584 18.623 100 22 45 1 1887869968 6682400 6425984
17:17:41 65345 8192000000 10724509088 11148320768 1767101120 17.743 94 52 102 1 1788181280 5705504 15374656
17:18:55 13780 8192000000 10751765392 11183476736 1768947600 17.758 96 16 31 0 1778790448 5787968 4054880
17:19:15 6628 8192000000 10779061920 11196346368 1821198080 18.187 98 30 60 1 1836073168 6027104 8847984
17:19:30 2853 8192000000 10750280448 11167817728 1806644432 18.068 98 55 109 5 1831401872 8819696 15937744
17:19:39 3568 8192000000 10733903520 11151839232 1798668336 18.003 99 28 56 2 1813345888 6075728 8601824
17:19:49 5632 8192000000 10732176784 11154669568 1811994320 18.112 99 32 63 1 1827094496 6003072 9097104
17:20:01 7210 8192000000 10668288128 11078672384 1725157568 17.395 95 35 70 1 1741321264 5478336 10685360
17:20:15 9672 8192000000 10698536560 11108634624 1712452576 17.289 95 20 40 1 1723843504 4957408 6433520
17:20:32 8625 8192000000 10688400624 11105325056 1722930864 17.377 96 22 45 0 1735277952 5559856 6787232
17:20:47 13651 8192000000 10697679760 11116032000 1715802016 17.317 95 27 54 2 1728916672 5864304 7250352
17:21:08 8414 8192000000 10687349840 11102339072 1767217856 17.744 99 22 44 0 1779673648 5325744 7130048
17:21:22 10002 8192000000 10691550256 11105554432 1748701072 17.591 98 16 32 1 1758784288 5223136 4860080
17:21:40 6257 8192000000 10708674768 11120562176 1789681904 17.929 100 28 56 0 1803974352 6678000 7614448
17:21:54 10281 8192000000 10720965920 11136675840 1802343808 18.033 100 28 56 2 1816163328 5475328 8344192
17:22:12 58457 8192000000 10725446592 11148460032 1801125312 18.023 99 43 85 2 1819771712 6200272 12446128
17:23:17 10567 8192000000 10739782912 11153563648 1799511088 18.010 99 32 64 1 1815397968 6583328 9303552
17:23:36 6338 8192000000 10745193920 11162091520 1823521552 18.206 100 42 85 0 1842593984 6186704 12885728
17:23:52 8740 8192000000 10756333088 11168272384 1824839984 18.217 100 37 75 2 1841922400 6467872 10614544
17:24:07 10550 8192000000 10739603488 11167588352 1828784640 18.249 100 25 50 0 1842488080 6430528 7272912
17:24:27 8002 8192000000 10745390112 11174338560 1835389584 18.303 100 21 42 1 1847461568 6204320 5867664
17:24:41 9503 8192000000 10761178512 11182206976 1837572688 18.321 100 19 38 2 1847662192 4846016 5243488
17:24:58 8177 8192000000 10765717712 11188576256 1847508976 18.402 100 29 58 3 1861475376 5155152 8811248
17:25:15 12011 8192000000 10766793456 11190366208 1847264656 18.400 100 13 26 0 1856573184 5613728 3694800
17:25:34 14666 8192000000 10758462368 11191029760 1850744928 18.428 100 18 36 1 1861404608 5646816 5012864
17:25:55 5241 8192000000 10771342416 11196805120 1854870640 18.462 100 29 58 1 1869663120 6628832 8163648
17:26:10 13928 8192000000 10774375040 11202703360 1856352544 18.474 100 20 40 1 1867230496 5367744 5510208
17:26:31 7675 8192000000 10773417216 11196948480 1843158768 18.367 99 18 36 1 1853747536 5225280 5363488
17:26:45 14526 8192000000 10766936384 11196653568 1859057312 18.496 100 12 24 0 1867965840 5261344 3647184
17:27:09 20912 8192000000 10817027456 11231436800 1884607536 18.702 100 28 56 1 1898363920 5012352 8744032
17:27:44 20835 8192000000 10822064080 11248058368 1900273984 18.828 100 47 94 2 1921294880 6860576 14160320
17:28:11 100036 8192000000 10835429648 11261452288 1907951280 18.890 100 33 66 0 1924049680 6486032 9612368
17:30:01 22463 8192000000 10851519952 11277262848 1916356336 18.958 100 36 71 0 1934609104 8216784 10035984
17:30:36 16034 8192000000 10865751760 11295014912 1930456976 19.071 100 40 80 0 1952482240 10853472 11171792
17:30:59 17511 8192000000 10868031968 11295330304 1935105376 19.108 100 40 80 0 1957784112 11007392 11671344
17:31:55 8829 8192000000 10889049296 11317047296 1951665600 19.240 100 55 109 2 1982690304 15349440 15675264
17:32:16 14289 8192000000 10891590960 11324194816 1955052288 19.267 100 41 82 2 1980895824 13908768 11934768
17:32:43 15888 8192000000 10911536144 11337117696 1967160336 19.363 100 45 90 2 1997419120 16901184 13357600
17:33:05 6940 8192000000 10915923456 11345211392 1975515856 19.429 100 57 113 1 2009238304 17243584 16478864
17:33:19 4178 8192000000 10929651792 11353440256 1977308368 19.443 100 57 113 0 2012394656 18680928 16405360
17:33:31 5228 8192000000 10909023248 11339767808 1957701840 19.288 99 49 97 0 1990458368 18667392 14089136
17:33:45 13035 8192000000 10914851232 11351105536 1974130496 19.418 100 50 100 2 2008187168 18633520 15423152
17:34:09 14525 8192000000 10920815648 11355435008 1977931440 19.448 100 44 86 4 2009263232 18565760 12766032
17:34:37 10913 8192000000 10898516768 11332902912 1957489776 19.286 99 37 72 1 1987698880 19043344 11165760
17:34:55 13712 8192000000 10929462480 11361275904 1983026784 19.489 100 51 101 1 2019269760 20508064 15734912
17:35:17 14644 8192000000 10919237488 11356532736 1977060544 19.441 100 53 106 0 2015742304 22538528 16143232
17:35:51 11271 8192000000 10923028064 11365396480 1978297280 19.451 100 40 80 1 2017786976 26972336 12517360
17:36:11 14371 8192000000 10906293600 11347116032 1965328608 19.348 99 39 78 0 1996878272 19581568 11968096
17:36:45 6510 8192000000 10911154912 11347955712 1969170400 19.379 100 34 68 1 1999851632 20047104 10634128
17:36:59 14863 8192000000 10924190960 11363946496 1979126304 19.458 100 53 105 1 2016731328 21727712 15877312
17:37:20 10306 8192000000 10942743552 11369725952 1989419280 19.539 100 56 112 4 2029529568 23156592 16953696
17:37:39 7296 8192000000 10951891184 11382423552 1998859264 19.614 100 57 114 1 2042932240 25972880 18100096
17:37:55 5149 8192000000 10949416896 11378851840 1979958048 19.464 99 66 129 1 2024273296 25289120 19026128
17:38:08 5726 8192000000 10941830272 11367911424 1983679424 19.494 100 71 140 0 2033268704 27791648 21797632
17:38:20 2006 8192000000 10945293616 11360759808 1972434160 19.405 99 74 144 2 2020723376 26946768 21342448
17:38:32 4496 8192000000 10948630256 11373355008 1989654160 19.541 100 70 140 1 2038538448 28059856 20824432
17:38:50 7095 8192000000 10944213264 11367079936 1979906608 19.464 100 63 123 1 2027504352 28788928 18808816
17:39:07 9558 8192000000 10933982544 11366125568 1977737472 19.447 100 59 118 0 2026494288 30448304 18308512
17:39:24 1763 8192000000 10950114352 11371687936 1985478912 19.508 100 74 147 2 2038482528 29877856 23125760
17:39:34 5224 8192000000 10946369296 11372195840 1981831648 19.479 100 62 123 1 2031053584 30479088 18742848
17:39:48 11621 8192000000 10952118624 11382718464 1988052240 19.528 100 66 129 1 2039761136 31507792 20201104
17:40:08 9458 8192000000 10962943456 11388522496 1997478720 19.603 100 69 136 0 2049796576 31877568 20440288
17:40:25 4441 8192000000 10946716752 11364782080 1970931776 19.393 99 82 162 2 2029996368 34503360 24561232
17:40:36 3188 8192000000 10963959904 11381317632 1983922304 19.496 100 77 153 0 2042923568 35574528 23426736
17:40:49 4156 8192000000 10952335504 11367514112 1963542320 19.334 99 80 160 1 2024194800 36329376 24323104
17:41:00 10328 8192000000 10956365360 11376885760 1982272496 19.483 100 67 133 1 2040133088 37224256 20636336
17:41:22 2428 8192000000 10926175296 11329196032 1935948176 19.114 98 94 186 3 2003285664 39800352 27537136
17:41:35 2963 8192000000 10957643216 11374510080 1974489632 19.421 100 82 165 0 2041191504 41105584 25596288
17:41:45 3339 8192000000 10964175744 11385999360 1984906928 19.504 100 75 147 2 2049343008 41827296 22608784
17:41:57 1221 8192000000 10984272400 11399516160 1997601504 19.604 100 88 174 1 2068890320 43736432 27552384
17:42:04 6657 8192000000 10956076192 11372220416 1969996896 19.385 99 74 148 0 2037464224 44134128 23333200
17:42:22 2552 8192000000 10978359904 11393400832 1987725920 19.526 100 85 167 1 2058813552 44887776 26199856
17:42:33 5017 8192000000 10985404032 11402588160 1994067440 19.576 100 81 163 1 2064796208 45504416 25224352
17:42:46 3173 8192000000 10980125936 11395112960 1987959344 19.528 100 85 170 1 2061703904 47195376 26549184
17:42:56 4313 8192000000 10980136160 11399344128 1974783264 19.423 99 81 162 1 2049101856 47922368 26396224
17:43:08 4533 8192000000 10983263312 11392798720 1983583520 19.493 100 85 168 0 2059795664 49042176 27169968
17:43:20 2430 8192000000 10976501296 11392389120 1985393792 19.507 100 86 170 0 2056960880 44591920 26975168
17:43:31 1386 8192000000 10978246096 11392892928 1992519808 19.564 100 91 181 0 2066030080 45206160 28304112
17:43:44 7019 8192000000 10955335008 11374387200 1970195920 19.387 99 72 143 2 2036015920 42898032 22921968
17:44:18 2018 8192000000 10989026848 11410817024 1999645216 19.620 100 67 133 3 2062780592 41678144 21457232
17:44:29 1067 8192000000 10973506880 11392438272 1989232432 19.538 100 91 180 4 2059189120 42790224 27166464
17:44:39 5237 8192000000 10944575584 11358081024 1957917568 19.289 99 78 157 1 2024872352 42420640 24534144
17:44:52 3531 8192000000 10956003488 11370442752 1968668928 19.375 100 88 176 1 2040029296 43898016 27462352
17:45:05 4450 8192000000 10969025024 11381792768 1972555760 19.406 100 72 145 0 2041216720 45795232 22865728
17:45:19 4972 8192000000 10950584384 11368853504 1964492032 19.342 100 80 157 3 2034712160 45720160 24499968
17:45:32 8442 8192000000 10943367936 11366203392 1947962464 19.210 99 68 136 0 2016394528 46183568 22248496
17:45:48 3431 8192000000 10951507568 11371368448 1967938560 19.369 100 72 145 2 2037078720 46372592 22767568
17:46:01 10839 8192000000 10955641264 11384414208 1973727728 19.415 100 57 115 1 2039904720 47707472 18469520
17:46:22 6134 8192000000 10960269328 11373731840 1954173424 19.260 99 75 151 0 2023392960 45850800 23368736
17:46:36 4948 8192000000 10951335440 11370156032 1963232480 19.332 100 69 137 1 2031741664 47192816 21316368
17:47:00 1159 8192000000 10934977312 11335577600 1935536064 19.111 98 93 183 2 2013980304 49894336 28549904
17:47:07 1937 8192000000 10973361040 11378536448 1972705152 19.407 100 90 180 1 2052346032 50827696 28813184
17:47:19 4041 8192000000 10953110912 11363274752 1957128016 19.283 100 74 147 1 2033003152 52167680 23707456
17:47:33 2676 8192000000 10968207584 11379736576 1967130448 19.363 100 83 164 0 2047018768 52875936 27012384
17:47:44 3687 8192000000 10968818608 11386716160 1971877680 19.400 100 77 154 0 2050868000 54106064 24884256
17:47:55 1026 8192000000 10974016560 11394789376 1977643520 19.446 100 69 138 1 2055730128 55598448 22488160
17:48:06 3843 8192000000 10963842176 11388301312 1970567536 19.390 100 59 117 1 2045691440 55202464 19921440
17:48:17 1866 8192000000 10979114544 11396378624 1979247184 19.459 100 78 156 4 2064437232 60495776 24694272
17:48:25 3828 8192000000 10990416256 11412299776 1983222560 19.490 100 73 147 0 2069198256 61570464 24405232
17:48:41 6295 8192000000 10972465344 11406229504 1985062976 19.505 100 55 110 0 2055462720 51970000 18429744
17:48:56 2724 8192000000 10978268880 11412086784 1989587408 19.541 100 64 128 1 2063916720 52706192 21623120
17:49:11 11595 8192000000 10962370032 11401515008 1970723360 19.391 99 47 91 3 2032339792 46321024 15295408
17:49:31 13691 8192000000 10933031200 11357089792 1926022176 19.035 97 42 82 1 1984676464 44570368 14083920
17:49:58 8824 8192000000 10957504640 11397476352 1977719584 19.447 100 38 76 0 2037463536 46671680 13072272
17:50:36 12703 8192000000 10969800576 11404443648 1975466000 19.429 99 47 94 3 2040255088 48890752 15898336
17:51:00 5073 8192000000 10970153744 11411415040 1991003584 19.552 100 48 95 2 2057277904 50581280 15693040
17:51:18 29125 8192000000 10959131168 11405914112 1946736128 19.200 98 35 69 4 2015179056 56586496 11856432
17:51:54 8980 8192000000 10952667232 11406958592 1972391504 19.404 100 33 66 1 2038159664 54365584 11402576
17:52:35 24597 8192000000 10966936624 11414974464 1979998656 19.465 100 29 58 0 2047251264 56378544 10874064
17:53:10 18474 8192000000 10961309776 11407101952 1974606160 19.422 100 33 66 1 2042757024 56367168 11783696
17:53:41 12545 8192000000 10957530672 11397300224 1950215680 19.228 99 39 78 0 2026399408 61911312 14272416
17:54:00 14901 8192000000 10958756816 11404058624 1945964256 19.194 99 34 68 0 2024231472 65452992 12814224
17:54:24 17780 8192000000 10940681120 11388801024 1935261648 19.109 99 31 62 1 2015336960 68255888 11819424
17:54:51 16486 8192000000 10955851056 11410567168 1947429904 19.206 100 30 60 0 2035870064 77103120 11337040
17:55:16 18720 8192000000 10918725904 11400376320 1947323856 19.205 100 22 42 3 2014637424 59125904 8187664
17:55:47 23923 8192000000 10899951632 11371827200 1932680944 19.088 100 18 36 0 1988278944 49213792 6384208
17:56:18 27267 8192000000 10894532640 11358851072 1913443776 18.934 99 13 26 0 1959574912 41559952 4571184
17:56:56 24001 8192000000 10884496128 11365523456 1947666704 19.208 100 17 33 1 1986306848 33390384 5249760
17:57:32 83034 8192000000 10902915424 11362938880 1921415776 18.998 98 11 22 0 1936976736 12027712 3533248
17:59:05 24759 8192000000 10919654320 11350528000 1933116400 19.092 98 50 96 4 1955560368 8607968 13836000
17:59:37 83336 8192000000 10901168720 11360313344 1947998640 19.211 99 33 66 1 1979578640 22562496 9017504
18:02:32 43331 8192000000 10908825136 11381415936 1973848336 19.416 100 14 28 1 1999067360 20925824 4293200
18:04:27 64976 8192000000 10903590208 11364438016 1946301728 19.197 98 22 44 0 1964282464 12013968 5966768
18:05:44 57598 8192000000 10885012608 11351232512 1929448384 19.062 98 25 46 1 1952692288 16481952 6761952
18:06:55 123477 8192000000 10905223984 11371585536 1956169616 19.276 99 27 52 2 1974792528 10581552 8041360
18:09:08 114860 8192000000 10908829568 11372498944 1947196560 19.204 98 21 43 3 1969519536 15778304 6544672
18:11:28 87183 8192000000 10889348080 11358453760 1963987424 19.338 99 11 22 0 1977043216 9920240 3135552
18:13:01 141829 8192000000 10899891968 11367378944 1949658880 19.224 98 26 51 1 1966334560 9177808 7497872
18:15:39 64381 8192000000 10906223136 11374260224 1949483616 19.222 98 24 48 0 1968905168 12927360 6494192
18:18:04 29042 8192000000 10908313472 11380162560 1966284688 19.356 99 18 36 1 1984994560 13638432 5071440
18:18:39 25948 8192000000 10888726032 11357769728 1929487840 19.063 97 25 50 0 1948331344 11095280 7748224
18:19:11 47340 8192000000 10910692880 11372138496 1953818384 19.257 99 24 48 2 1970956912 9853136 7285392
18:20:06 36440 8192000000 10924061104 11384426496 1984110128 19.497 100 30 60 1 2006220688 13670784 8439776
18:20:58 69967 8192000000 10923431600 11405066240 1997213808 19.601 100 17 34 0 2016084064 13631120 5239136
18:22:20 51378 8192000000 10919577056 11407208448 2005955280 19.670 100 15 30 1 2025623312 14958640 4709392
18:23:32 55056 8192000000 10892825344 11390259200 1957929648 19.290 98 8 16 1 1971900112 11506832 2463632
18:24:34 36220 8192000000 10899145472 11383586816 1984669216 19.502 100 7 14 1 1995384192 8849216 1865760
18:25:21 37148 8192000000 10884134160 11367649280 1930189584 19.068 97 24 48 2 1945293088 8435536 6667968
18:26:06 67955 8192000000 10937851648 11392651264 1986688304 19.518 100 13 25 1 2004547712 14514112 3345296
18:27:20 64220 8192000000 10919323040 11399729152 1979504176 19.461 99 22 44 1 1996134576 10577296 6053104
18:28:30 55924 8192000000 10922402224 11402235904 2002450704 19.642 100 15 29 2 2015889088 9419520 4018864
18:29:33 42810 8192000000 10908966944 11373154304 1925706304 19.033 96 16 32 2 1942988480 12804096 4478080
18:30:22 91984 8192000000 10904211840 11386929152 1902202160 18.844 96 13 26 0 1921630480 15993136 3435184
18:32:03 72372 8192000000 10915203248 11384307712 1906412240 18.878 96 19 38 1 1925518080 14175424 4930416
18:33:39 77470 8192000000 10877373856 11354566656 1875116080 18.626 95 20 40 1 1895079856 14600144 5363632
18:35:02 49204 8192000000 10868170544 11312463872 1783984272 17.882 91 12 24 0 1799035568 12095408 2955888
18:36:04 75531 8192000000 10856280736 11327369216 1860175872 18.505 96 25 50 1 1886337584 19251520 6910192
18:37:27 38140 8192000000 10861382288 11300925440 1885600816 18.710 97 40 80 2 1904841712 8287632 10953264
18:38:14 11138 8192000000 10870030864 11309445120 1894248320 18.780 98 47 94 4 1917275152 9866624 13160208
18:38:35 13722 8192000000 10859858448 11307257856 1907862240 18.889 99 40 80 0 1930758608 11956656 10939712
18:38:57 106337 8192000000 10833908592 11295105024 1807958304 18.079 94 10 19 0 1820674912 10316432 2400176
18:40:53 98262 8192000000 10868834688 11321176064 1921984384 19.003 100 31 62 3 1940050448 9586608 8479456
18:42:38 112027 8192000000 10839778944 11319238656 1869611968 18.581 97 14 28 0 1884685216 11019776 4053472
18:44:47 38571 8192000000 10869394896 11318358016 1888936864 18.737 98 16 32 0 1902629312 9148496 4543952
18:45:34 57080 8192000000 10846152896 11315453952 1907845536 18.889 99 25 50 0 1925088544 9636848 7606160
18:47:00 47869 8192000000 10849760400 11312246784 1904308928 18.861 99 9 18 0 1915681552 8894208 2478416
18:48:04 54239 8192000000 10818831104 11294027776 1867954896 18.568 97 19 38 2 1881824624 8549328 5320400
18:49:06 69842 8192000000 10803562608 11277692928 1789387152 17.927 94 7 14 0 1800915072 8757856 2770064
18:50:34 51911 8192000000 10825359776 11293675520 1903011568 18.851 100 10 21 1 1912226096 6531520 2683008
18:51:36 85531 8192000000 10833682960 11304607744 1883436048 18.693 98 11 21 0 1893196576 7158832 2601696
18:53:11 77285 8192000000 10843126944 11320254464 1890820096 18.752 98 18 36 0 1910516416 14390048 5306272
18:54:54 55452 8192000000 10840562896 11328126976 1921229568 18.997 100 6 12 1 1935346480 12567984 1548928
18:56:07 40123 8192000000 10868533568 11332751360 1939469968 19.143 100 13 26 0 1953437376 10405056 3562352
18:56:57 54260 8192000000 10874810560 11347668992 1930743248 19.073 99 19 38 0 1943947552 7946480 5257824
18:58:22 62595 8192000000 10869089824 11341008896 1903337744 18.853 97 16 32 1 1918686800 11059376 4289680
18:59:31 70623 8192000000 10878197456 11349540864 1900419024 18.830 97 13 26 0 1912723216 8642960 3661232
19:00:48 64788 8192000000 10883459168 11352489984 1939421456 19.142 99 20 40 0 1953818336 9345248 5051632
19:02:02 54671 8192000000 10886095248 11365572608 1946051120 19.195 99 20 40 1 1963100688 11396912 5652656
19:03:02 40781 8192000000 10884260784 11363422208 1903679776 18.856 97 21 42 0 1928839504 19316656 5843072
19:03:55 27766 8192000000 10905556560 11349426176 1932301888 19.085 99 32 63 1 1952910848 11803232 8805728
19:04:30 27817 8192000000 10902217792 11350114304 1923827968 19.017 98 51 101 0 1947553168 10005024 13720176
19:05:05 15056 8192000000 10896459184 11345211392 1942633264 19.168 99 39 78 1 1963891216 10969488 10288464
19:05:27 14012 8192000000 10904244448 11353993216 1960251760 19.308 100 41 82 0 1982258992 10685856 11321376
19:05:50 49111 8192000000 10901389920 11355377664 1944651504 19.184 99 37 74 1 1969312384 14463584 10197296
19:06:52 71276 8192000000 10893256128 11378262016 1939069888 19.139 99 22 45 1 1960782208 15539472 6172848
19:08:11 45843 8192000000 10903261024 11369779200 1932701248 19.088 98 23 46 0 1952311776 12607600 7002928
19:09:10 54396 8192000000 10889474320 11357958144 1912041216 18.923 97 22 44 0 1932643424 14718208 5884000
19:10:11 123924 8192000000 10860072912 11322613760 1900980064 18.834 97 19 39 2 1922057888 15949344 5128480
19:12:38 36437 8192000000 10870863600 11342921728 1952182768 19.244 100 15 30 0 1965090592 8081392 4826432
19:13:22 2842 8192000000 10871071504 11341058048 1950982240 19.234 100 7 14 0 1961002720 8117616 1902864
19:13:31 35459 8192000000 10870516576 11327619072 1912173040 18.924 98 24 48 0 1929473232 10501104 6799088
19:14:18 78238 8192000000 10886373264 11367485440 1945668016 19.192 99 15 31 0 1962078768 12667232 3743520
19:16:45 66698 8192000000 10874697248 11344572416 1912623744 18.928 97 10 20 0 1922798064 7264336 2909984
19:18:29 73895 8192000000 10873630848 11353481216 1928324160 19.053 98 20 40 1 1944390592 10407152 5659280
19:19:57 53803 8192000000 10872352992 11337080832 1910636448 18.912 97 23 44 2 1927471696 9847760 6987488
19:20:58 65293 8192000000 10843998112 11322580992 1839001024 18.333 94 27 55 3 1856519552 9806592 7711936
19:22:19 64763 8192000000 10895670576 11357093888 1956039712 19.275 100 18 36 1 1974063888 11837808 6186368
19:23:56 37445 8192000000 10866455696 11334852608 1939393984 19.142 100 29 58 3 1963362832 15202112 8766736
19:24:51 117510 8192000000 10869057296 11325784064 1862519152 18.524 96 10 20 0 1875986656 10526544 2940960
19:26:58 21792 8192000000 9026831008 9277890560 176451136 2.108 10 5 10 0 178892480 1258288 1183056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-01-2021 19:28:48 to 20-01-2021 19:28:50.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          239128
MON$OLDEST_ACTIVE               239129
MON$OLDEST_SNAPSHOT             239129
MON$NEXT_TRANSACTION            239129
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                       2041440
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 ---
--- end of diff output ---

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

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