Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17522964 kB
MemAvailable 31549676 kB
Buffers 0 kB
Cached 14117084 kB
SwapCached 0 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-03-12 19:27:24
DTS_END                         2021-03-12 19:27:24.2190
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/44588
TRN_ID                          234594
ATT_ID                          634
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: 9105.60 20231 1092672
customer order: creation 163.93 403 19672
customer order: refuse 14.18 339 1701
order to supplier: creation 43.80 1304 5256
order to supplier: removal 3.63 103099 435
invoice (draft): creation 44.07 3464 5288
invoice (draft): removal 55.00 802 6600
invoice accept: apply 39.73 20753 4767
invoice accept: cancel 49.49 784 5939
customer reserve: creation 3599.69 210 431963
customer reserve: removal 4800.36 60 576043
realization accept: apply 79.66 190 9559
realization accept: cancel 88.54 109 10625
payment from customer: creation 56.54 116 6785
payment from customer: removal 5.30 93 636
payment to supplier: creation 46.48 131 5578
payment to supplier: removal 3.17 47 380
service: total inventory turnovers 4.94 1148 593
service: total monetary turnovers 6.45 47 774
service: aggregate perf. data 0.62 32274 74
service: refresh index statistics 0.03 239250 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2021 19:28:05 to 12-03-2021 19:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7080
TEST_TIME 2 5756
TEST_TIME 3 4866
TEST_TIME 4 5344
TEST_TIME 5 4846
TEST_TIME 6 4817
TEST_TIME 7 5151
TEST_TIME 8 5973
TEST_TIME 9 5992
TEST_TIME 10 5842
TEST_TIME 11 5826
TEST_TIME 12 6301
TEST_TIME 13 6595
TEST_TIME 14 6771
TEST_TIME 15 6693
TEST_TIME 16 6869
TEST_TIME 17 7481
TEST_TIME 18 7572
TEST_TIME 19 7850
TEST_TIME 20 8219
TEST_TIME 21 8889
TEST_TIME 22 9252
TEST_TIME 23 9191
TEST_TIME 24 9287
TEST_TIME 25 9259
TEST_TIME 26 9527
TEST_TIME 27 9652
TEST_TIME 28 10233
TEST_TIME 29 10905
TEST_TIME 30 10941
TEST_TIME 31 10651
TEST_TIME 32 10519
TEST_TIME 33 10485
TEST_TIME 34 10260
TEST_TIME 35 10166
TEST_TIME 36 10091
TEST_TIME 37 10024
TEST_TIME 38 10011
TEST_TIME 39 9922
TEST_TIME 40 9823
TEST_TIME 41 9725
TEST_TIME 42 9567
TEST_TIME 43 9551
TEST_TIME 44 9689
TEST_TIME 45 9598
TEST_TIME 46 9446
TEST_TIME 47 9462
TEST_TIME 48 9474
TEST_TIME 49 9460
TEST_TIME 50 9502
TEST_TIME 51 9404
TEST_TIME 52 9264
TEST_TIME 53 9462
TEST_TIME 54 9406
TEST_TIME 55 9458
TEST_TIME 56 9462
TEST_TIME 57 9387
TEST_TIME 58 9395
TEST_TIME 59 9373
TEST_TIME 60 9427
TEST_TIME 61 9439
TEST_TIME 62 9534
TEST_TIME 63 9636
TEST_TIME 64 9707
TEST_TIME 65 9706
TEST_TIME 66 9761
TEST_TIME 67 9721
TEST_TIME 68 9727
TEST_TIME 69 9690
TEST_TIME 70 9635
TEST_TIME 71 9539
TEST_TIME 72 9558
TEST_TIME 73 9589
TEST_TIME 74 9549
TEST_TIME 75 9523
TEST_TIME 76 9464
TEST_TIME 77 9460
TEST_TIME 78 9387
TEST_TIME 79 9309
TEST_TIME 80 9333
TEST_TIME 81 9307
TEST_TIME 82 9331
TEST_TIME 83 9306
TEST_TIME 84 9249
TEST_TIME 85 9253
TEST_TIME 86 9266
TEST_TIME 87 9248
TEST_TIME 88 9249
TEST_TIME 89 9255
TEST_TIME 90 9281
TEST_TIME 91 9386
TEST_TIME 92 9351
TEST_TIME 93 9332
TEST_TIME 94 9301
TEST_TIME 95 9348
TEST_TIME 96 9428
TEST_TIME 97 9398
TEST_TIME 98 9411
TEST_TIME 99 9433
TEST_TIME 100 9407
TEST_TIME 101 9347
TEST_TIME 102 9266
TEST_TIME 103 9239
TEST_TIME 104 9238
TEST_TIME 105 9228
TEST_TIME 106 9206
TEST_TIME 107 9166
TEST_TIME 108 9158
TEST_TIME 109 9085
TEST_TIME 110 9089
TEST_TIME 111 9100
TEST_TIME 112 9076
TEST_TIME 113 9039
TEST_TIME 114 9015
TEST_TIME 115 9119
TEST_TIME 116 9125
TEST_TIME 117 9100
TEST_TIME 118 9123
TEST_TIME 119 9167
TEST_TIME 120 9108

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-03-2021 19:28:08 to 12-03-2021 19:28:12.

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 1494397 1494397 0 0.00 0 25558 6 0 0
doc_list_biud 1494396 1494396 0 0.00 0 36761 29 0 0
sp_add_invoice_to_stock 4919 4767 152 3.09 25 199243 20754 0 152
sp_cancel_adding_invoice 5939 5939 0 0.00 2 74886 785 0 0
sp_cancel_client_order 1701 1701 0 0.00 4 12468 340 0 0
sp_cancel_customer_reserve 576043 576043 0 0.00 1 26032 60 0 0
sp_cancel_pay_from_customer 636 636 0 0.00 3 7606 93 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 3 1167 47 0 0
sp_cancel_supplier_invoice 6614 6600 14 0.21 2 22813 803 0 14
sp_cancel_supplier_order 435 435 0 0.00 9 989939 103099 0 0
sp_cancel_write_off 10625 10625 0 0.00 1 14789 110 0 0
sp_client_order 19672 19672 0 0.00 3 67353 404 0 0
sp_customer_reserve 431963 431963 0 0.00 0 38304 211 0 0
sp_fill_shopping_cart 30204 30204 0 0.00 1 17687 38 0 0
sp_fill_shopping_cart_clo_res 431960 431960 0 0.00 0 22166 15 0 0
sp_get_clo_for_invoice 4764 4764 0 0.00 0 44564 315 0 0
sp_kill_cost_storno 17580 17580 0 0.00 0 20394 61 0 0
sp_kill_qstorno_ret_qs2qd 1169746 1169746 0 0.00 0 26023 33 0 0
sp_kill_qty_storno 615665 615665 0 0.00 0 36760 71 0 0
sp_lock_selected_doc 19885 19885 0 0.00 0 11240 5 0 0
sp_make_cost_storno 26686 26686 0 0.00 0 25539 56 0 0
sp_multiply_rows_for_pdistr 26685 26685 0 0.00 0 8417 29 0 0
sp_multiply_rows_for_qdistr 19672 19672 0 0.00 0 67283 175 0 0
sp_pay_from_customer 6785 6785 0 0.00 5 12101 117 0 0
sp_pay_to_supplier 5578 5578 0 0.00 5 8945 132 0 0
sp_payment_common 12363 12363 0 0.00 1 12090 32 0 0
sp_qd_handle_on_cancel_clo 1701 1701 0 0.00 0 12462 311 0 0
sp_qd_handle_on_invoice_upd_sts 10702 10702 0 0.00 0 36757 363 0 0
sp_qd_handle_on_reserve_upd_sts 9559 9559 0 0.00 0 20659 66 0 0
sp_reserve_write_off 9559 9559 0 0.00 6 20705 191 0 0
sp_supplier_invoice 5288 5288 0 0.00 6 91510 3464 0 0
sp_supplier_order 5256 5256 0 0.00 5 55244 1305 0 0
srv_aggregate_perf_data 74 74 0 0.00 2779 483244 32274 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1582 148332 31557 0 0
srv_find_qd_qs_mism 1048347 1048347 0 0.00 0 10901 5 0 0
srv_make_invnt_saldo 593 593 0 0.00 36 60938 1149 0 0
srv_make_money_saldo 774 774 0 0.00 0 10015 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 91191 422940 239251 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4767 4767 0 0.00 0 30297 197 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 0 4926 124 0 0
t$perf-norm:sp_cancel_client_order 1701 1701 0 0.00 0 1717 11 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 851 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 636 636 0 0.00 0 2575 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 308 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 376 376 0 0.00 0 1698 18 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 33735 1687 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 1280 5 0 0
t$perf-norm:sp_client_order 19672 19672 0 0.00 0 20521 21 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 3215 6 0 0
t$perf-norm:sp_pay_from_customer 6785 6785 0 0.00 0 10123 11 0 0
t$perf-norm:sp_pay_to_supplier 5578 5578 0 0.00 0 4701 10 0 0
t$perf-norm:sp_reserve_write_off 9559 9559 0 0.00 0 3861 11 0 0
t$perf-norm:sp_supplier_invoice 5288 5288 0 0.00 0 5772 17 0 0
t$perf-norm:sp_supplier_order 5256 5256 0 0.00 0 4960 21 0 0
t$perf-norm:srv_aggregate_perf_data 74 74 0 0.00 0 332 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 986 11 0 0
t$perf-norm:srv_make_invnt_saldo 593 593 0 0.00 0 925 21 0 0
t$perf-norm:srv_make_money_saldo 774 774 0 0.00 0 1120 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9830 9526 304 3.09 0 8679 19 0 304
v_all_customers 35678 35678 0 0.00 0 34 1 0 0
v_all_suppliers 29216 29216 0 0.00 0 13 1 0 0
v_all_wares 39344 39344 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 2148 8 0 0
v_cancel_client_order 3402 3402 0 0.00 0 7237 7 0 0
v_cancel_customer_prepayment 1272 1272 0 0.00 0 1138 6 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 4338 14 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 564 4 0 0
v_cancel_supplier_invoice 780 752 28 3.58 0 387 13 0 28
v_cancel_supplier_order 870 870 0 0.00 0 6767 20 0 0
v_cancel_write_off 1980 1980 0 0.00 0 3050 16 0 0
v_max_id_clo_ord 5256 5256 0 0.00 0 446 1 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 2862 10 0 0
v_max_id_ord_sup 5276 5276 0 0.00 0 6670 4 0 0
v_max_non_paid_invoice 1502 1502 0 0.00 0 2113 3 0 0
v_max_non_paid_realizn 3597 3597 0 0.00 0 3219 4 0 0
v_min_id_clo_ord 5256 5256 0 0.00 0 6489 12 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 4899 11 0 0
v_min_id_ord_sup 5276 5276 0 0.00 0 7221 9 0 0
v_min_non_paid_invoice 5578 5578 0 0.00 0 6788 19 0 0
v_min_non_paid_realizn 6785 6785 0 0.00 0 8364 25 0 0
v_our_firm 10042 10042 0 0.00 0 21 1 0 0
v_reserve_write_off 19118 19118 0 0.00 0 12940 8 0 0
x_lock_depdocs_on_canc_invoice 12163 12163 0 0.00 0 16873 111 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 14350 407 0 0
x_make_qstorno_1000_1200 5256 5256 0 0.00 2 55215 1217 0 0
x_make_qstorno_1200_2000 5288 5288 0 0.00 3 91500 3341 0 0
x_make_qstorno_2100_3300 431963 431963 0 0.00 0 38303 193 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2021 19:28:13 to 12-03-2021 19:28:17.

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:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:33 10131 8192000000 10178201712 10480455680 901747536 9.916 71 53 106 0 922364896 2475984 18141376
16:57:52 20436 8192000000 10302920608 10615922688 1359571504 14.234 100 82 165 0 1390756928 4160112 27025312
16:58:23 26417 8192000000 10364329776 10679394304 1400879968 14.603 100 84 168 0 1433084816 5155200 27049648
16:58:59 23680 8192000000 10395303488 10721243136 1443652464 14.982 100 88 176 0 1478964688 6122416 29189808
16:59:31 17291 8192000000 10410672240 10738315264 1466920048 15.187 100 89 178 0 1502895136 7071280 28903808
16:59:58 19307 8192000000 10437893632 10768736256 1490636784 15.394 100 86 172 0 1525723472 7669312 27417376
17:00:25 28971 8192000000 10465396496 10802515968 1516673072 15.621 100 89 178 0 1553534384 8675776 28185536
17:01:02 15208 8192000000 10479141888 10822553600 1538357440 15.809 100 82 164 0 1572969216 8743024 25868752
17:01:28 16434 8192000000 10489052592 10833551360 1547477024 15.888 100 80 160 1 1581414464 9270240 24667200
17:01:53 19766 8192000000 10511452384 10864607232 1571607856 16.096 100 81 162 0 1606277584 9467936 25201792
17:02:22 12740 8192000000 10543061056 10900795392 1601421744 16.352 100 68 136 0 1631243728 9663744 20158240
17:02:43 13845 8192000000 10573903968 10930679808 1630532064 16.599 100 75 149 0 1662990384 10363408 22094912
17:03:06 13442 8192000000 10593993248 10957307904 1656659280 16.821 100 81 160 1 1691904192 11561008 23683904
17:03:29 10389 8192000000 10608191344 10973896704 1673751408 16.965 100 80 160 0 1709896560 12163296 23981856
17:03:48 8359 8192000000 10629463344 10995625984 1688650544 17.090 100 83 166 1 1728803968 16490144 23663280
17:04:06 9995 8192000000 10644972224 11013357568 1704896784 17.226 100 83 166 1 1742267168 13576544 23793840
17:04:24 9311 8192000000 10661016832 11031597056 1720463568 17.356 100 87 174 1 1759253936 13654256 25136112
17:04:41 7545 8192000000 10679893664 11050622976 1733923008 17.468 100 83 166 0 1772233792 14650784 23660000
17:04:57 7298 8192000000 10682312576 11061362688 1747090176 17.577 100 80 161 1 1782310768 12998224 22222368
17:05:11 5390 8192000000 10696308304 11075842048 1755943680 17.651 100 83 166 3 1793446016 14044480 23457856
17:05:24 4417 8192000000 10703664768 11083808768 1772348912 17.786 100 81 162 0 1807554592 12536672 22669008
17:05:36 4437 8192000000 10714034384 11091349504 1778947840 17.841 100 86 172 0 1815252416 12568176 23736400
17:05:47 3977 8192000000 10714938656 11095101440 1779288624 17.844 100 74 149 1 1813528288 13427248 20812416
17:05:58 2490 8192000000 10730484432 11108577280 1789533280 17.928 100 87 174 1 1826091776 12114560 24443936
17:06:07 7841 8192000000 10734143568 11116134400 1795330896 17.976 100 78 159 1 1829559072 12267184 21960992
17:06:23 4288 8192000000 10757514480 11140567040 1809311440 18.090 100 90 181 3 1847415936 13016784 25087712
17:06:34 2650 8192000000 10772709600 11154206720 1826310544 18.229 100 91 182 1 1866681152 14390960 25979648
17:06:42 2490 8192000000 10775635664 11161038848 1836408336 18.312 100 90 177 1 1875214880 14255104 24551440
17:06:51 2593 8192000000 10784178016 11171594240 1840737408 18.347 100 87 173 2 1877901424 12669984 24494032
17:07:00 1457 8192000000 10788492112 11178078208 1847849488 18.405 100 92 186 4 1886277248 12742528 25685232
17:07:08 1677 8192000000 10798444816 11184046080 1853344080 18.449 100 92 184 0 1892779200 13615248 25819872
17:07:16 1550 8192000000 10804241472 11192578048 1858546000 18.491 100 88 176 1 1897510208 13644704 25319504
17:07:25 1471 8192000000 10814798080 11199967232 1865957584 18.552 100 95 190 2 1908385824 15355120 27073120
17:07:32 2375 8192000000 10807837824 11198529536 1869753072 18.582 100 97 194 1 1912140624 15126096 27261456
17:07:41 1805 8192000000 10812600016 11199414272 1872653456 18.606 100 95 188 1 1912105248 13214528 26237264
17:07:50 1529 8192000000 10816596176 11205578752 1874492656 18.621 100 90 180 1 1913818128 14159056 25166416
17:07:57 3609 8192000000 10822088112 11210063872 1874655984 18.622 100 92 184 1 1915326944 14646448 26024512
17:08:07 1806 8192000000 10831794592 11220615168 1881814816 18.680 100 96 191 1 1922981760 13840480 27326464
17:08:15 3830 8192000000 10804183936 11214209024 1876084912 18.633 100 70 140 0 1908433184 13050912 19297360
17:08:26 33951 8192000000 10810320080 11213533184 1879743264 18.663 100 59 116 1 1905710112 8741296 17225552
17:09:06 29948 8192000000 10796211552 11212976128 1880586128 18.670 100 57 114 1 1906374752 9158896 16629728
17:09:44 4248 8192000000 10811952048 11218132992 1887335344 18.724 100 57 114 0 1910382528 4743920 18303264
17:09:54 29707 8192000000 10784431168 11220017152 1882184144 18.683 100 21 43 1 1893930352 5820880 5925328
17:10:33 7885 8192000000 10788672096 11222728704 1885830656 18.712 100 25 49 2 1899749536 6829968 7088912
17:10:48 6670 8192000000 10805593216 11225231360 1886803760 18.720 100 27 54 1 1901444944 6887600 7753584
17:11:02 6399 8192000000 10802795008 11226128384 1888543600 18.734 100 27 54 2 1902231360 5576032 8111728
17:11:15 4316 8192000000 10806510352 11229519872 1891291376 18.756 100 41 80 2 1910555504 7590528 11673600
17:11:28 4865 8192000000 10790942928 11227262976 1888033280 18.730 100 20 40 3 1900114576 6644896 5436400
17:11:39 6127 8192000000 10795086672 11224961024 1889652592 18.743 100 30 60 2 1904886912 6183744 9050576
17:11:54 4268 8192000000 10796005680 11226513408 1890080352 18.746 100 24 48 0 1903492480 6827600 6584528
17:12:04 9225 8192000000 10808477024 11231637504 1889521904 18.742 100 20 40 1 1905110864 10152496 5436464
17:12:21 9498 8192000000 10796265664 11231035392 1891918144 18.761 100 24 46 0 1905406768 6307472 7181152
17:12:36 11327 8192000000 10800783696 11234131968 1894778672 18.784 100 26 48 1 1908208080 6113296 7316112
17:12:56 9477 8192000000 10809225344 11237081088 1896852768 18.801 100 22 44 2 1909645616 6907248 5885600
17:13:11 15415 8192000000 10800042016 11235348480 1896547280 18.799 100 21 42 2 1908440320 6123328 5769712
17:13:33 11039 8192000000 10796038384 11234476032 1895305136 18.789 100 11 22 1 1904736208 5457408 3973664
17:13:51 9136 8192000000 10811552160 11237408768 1898318608 18.813 100 17 34 1 1908644224 5853296 4472320
17:14:08 47642 8192000000 10821639232 11252219904 1902976256 18.850 100 26 50 1 1915538112 5276720 7285136
17:15:06 27310 8192000000 10814903008 11257921536 1906072880 18.875 100 26 52 1 1920138688 7457056 6608752
17:15:41 5175 8192000000 10823419536 11251179520 1903770320 18.857 100 36 72 3 1920926720 7657456 9498944
17:15:54 9450 8192000000 10816899248 11255451648 1904554592 18.863 100 29 58 0 1919570224 6517680 8497952
17:16:12 6625 8192000000 10816175808 11250438144 1899789232 18.825 100 20 40 1 1911185232 5849376 5546624
17:16:28 5318 8192000000 10815548720 11252752384 1899157904 18.820 100 28 57 3 1913185712 5832496 8195312
17:16:41 4359 8192000000 10818821392 11242504192 1893711360 18.776 100 34 69 0 1914710960 10416016 10583584
17:16:52 4946 8192000000 10806999808 11240419328 1882160176 18.683 99 44 88 2 1901650000 5841952 13647872
17:17:06 6878 8192000000 10809272720 11238137856 1875332208 18.627 99 35 70 0 1891857472 6656752 9868512
17:17:20 5347 8192000000 10784370704 11218808832 1847012000 18.398 98 20 40 1 1857921248 5021760 5887488
17:17:32 5413 8192000000 10773131392 11205988352 1838497616 18.329 98 25 50 1 1851930384 6258400 7174368
17:17:43 14768 8192000000 10767047872 11198386176 1783458544 17.878 95 13 26 0 1796388640 9131072 3799024
17:18:11 8037 8192000000 10760886288 11189161984 1832634512 18.281 99 16 32 0 1842439936 5640128 4165296
17:18:27 6833 8192000000 10756831520 11188506624 1834991440 18.300 99 17 34 2 1845848560 6052480 4804640
17:18:40 66508 8192000000 10724952464 11148533760 1725945008 17.402 93 50 99 1 1746031904 5311376 14775520
17:19:53 9733 8192000000 10697986672 11118510080 1705551472 17.232 94 16 32 0 1714890112 4669376 4669264
17:20:09 5703 8192000000 10727330704 11148079104 1792777760 17.955 99 23 46 0 1804642000 5306944 6557296
17:20:23 4143 8192000000 10721768208 11130802176 1763090368 17.710 97 40 80 0 1780098400 5687776 11320256
17:20:33 4371 8192000000 10706820944 11112570880 1732744384 17.458 96 40 79 1 1750911616 6506656 11660576
17:20:45 5730 8192000000 10698083920 11103563776 1720781552 17.359 96 37 74 0 1738142400 6433904 10926944
17:20:58 7190 8192000000 10697749648 11098439680 1713912016 17.301 96 30 60 2 1728889920 6068928 8908976
17:21:13 6587 8192000000 10683585840 11101564928 1762898112 17.708 99 31 62 2 1778259760 5449424 9912224
17:21:27 7895 8192000000 10710320000 11129348096 1790141216 17.933 100 18 36 1 1805431488 10470960 4819312
17:21:43 8225 8192000000 10693551488 11115409408 1774807360 17.807 99 32 64 2 1790318640 5699248 9812032
17:21:57 10699 8192000000 10702406000 11123564544 1750532672 17.606 97 16 32 2 1760725200 5905360 4287168
17:22:15 8213 8192000000 10724903888 11140456448 1807414720 18.075 100 36 70 2 1824775264 6755488 10605056
17:22:30 16796 8192000000 10736575232 11155861504 1801032544 18.022 99 23 46 0 1813531536 5891136 6607856
17:22:54 10467 8192000000 10740170208 11166871552 1825307392 18.221 100 22 44 2 1837257296 5037024 6912880
17:23:14 56550 8192000000 10752395840 11180933120 1841795296 18.355 100 26 50 1 1854382544 5571312 7015936
17:24:26 24852 8192000000 10773295680 11195146240 1852579872 18.443 100 30 60 0 1866927008 5523248 8823888
17:24:57 6695 8192000000 10771541840 11197804544 1851506912 18.434 100 26 52 0 1865089808 6497696 7085200
17:25:13 4958 8192000000 10775101824 11196497920 1855815728 18.469 100 34 67 0 1872149120 7049456 9283936
17:25:27 7913 8192000000 10785777536 11207622656 1860222992 18.505 100 23 47 2 1878510000 10364928 7922080
17:25:41 7001 8192000000 10785497152 11208749056 1862735472 18.525 100 21 44 1 1874403472 5443808 6224192
17:25:57 8568 8192000000 10786697472 11211689984 1865258656 18.546 100 25 50 2 1878802304 5985968 7557680
17:26:12 11689 8192000000 10775447792 11210694656 1866592896 18.557 100 19 38 1 1877815840 6103296 5119648
17:26:36 13030 8192000000 10800115760 11217293312 1871594208 18.597 100 29 59 2 1885245184 4608816 9042160
17:26:57 10119 8192000000 10793338048 11223949312 1874375216 18.620 100 23 45 2 1886812592 5909008 6528368
17:27:15 18930 8192000000 10825305408 11247042560 1897512560 18.806 100 24 48 1 1909487376 4703952 7270864
17:27:48 12991 8192000000 10845227904 11263291392 1906278896 18.877 100 35 67 2 1921926752 5951232 9696624
17:28:07 17360 8192000000 10848046128 11272155136 1917696496 18.968 100 48 94 2 1940134752 10174704 12263552
17:28:32 63825 8192000000 10858090016 11287670784 1925093328 19.028 100 47 94 2 1949902640 11120384 13688928
17:29:44 18968 8192000000 10884327616 11301437440 1938169408 19.132 100 49 97 3 1963488000 10973920 14344672
17:30:10 13735 8192000000 10882945120 11309064192 1946027584 19.195 100 64 128 5 1976893616 12452304 18413728
17:30:55 8701 8192000000 10897054112 11312775168 1953896208 19.257 100 69 138 0 1991050416 17668944 19485264
17:31:13 9660 8192000000 10898272800 11324809216 1955978992 19.274 100 69 136 1 1992341056 16785184 19576880
17:31:32 11969 8192000000 10875249104 11313680384 1934396464 19.102 99 36 72 1 1959164832 14605392 10162976
17:31:53 21377 8192000000 10886646320 11311235072 1928595072 19.056 99 44 87 0 1957990256 16761360 12633824
17:32:26 4582 8192000000 10892515536 11313405952 1928196768 19.052 99 51 96 2 1958964624 16632816 14135040
17:32:41 19688 8192000000 10887347280 11319828480 1949943392 19.226 100 47 94 0 1984838576 20268464 14626720
17:33:16 20922 8192000000 10897185952 11328819200 1958210800 19.292 100 47 94 0 1993132576 20673264 14248512
17:33:44 13665 8192000000 10912399728 11345113088 1965696496 19.351 100 52 104 0 2003140416 22106416 15337504
17:34:05 19441 8192000000 10928081104 11357769728 1975218544 19.427 100 54 103 1 2014925040 23289840 16416656
17:34:35 8677 8192000000 10935915920 11360899072 1978014016 19.449 100 54 108 1 2018847600 24641104 16192480
17:34:51 9026 8192000000 10933912496 11359342592 1976863520 19.440 100 61 122 1 2021017808 25932112 18222176
17:35:10 3381 8192000000 10941987344 11368124416 1962559824 19.326 99 65 130 2 2007478960 26087088 18832048
17:35:20 10335 8192000000 10937196528 11360755712 1982578960 19.485 100 72 144 3 2032634032 28544608 21510464
17:35:39 4942 8192000000 10939767616 11363033088 1983015872 19.489 100 65 129 3 2026066848 23956784 19094192
17:36:06 9817 8192000000 10931538816 11362246656 1975731696 19.431 100 48 96 0 2011721280 21657120 14332464
17:36:31 13278 8192000000 10930097776 11362279424 1968317728 19.372 99 61 123 1 2008560624 22630816 17612080
17:36:51 5801 8192000000 10934436512 11370016768 1982815776 19.487 100 52 102 2 2024230128 26346832 15067520
17:37:05 3490 8192000000 10939582608 11361755136 1970694256 19.391 99 69 137 1 2012878768 22163744 20020768
17:37:16 18766 8192000000 10949659328 11377762304 1987223392 19.522 100 51 100 1 2025952688 23916464 14812832
17:37:46 9694 8192000000 10931671296 11361017856 1968776880 19.376 99 57 111 2 2010495840 24448112 17270848
17:38:05 8981 8192000000 10942005680 11375906816 1989527968 19.540 100 58 116 1 2035332720 27137024 18667728
17:38:28 7396 8192000000 10949711440 11391127552 1994892352 19.582 100 51 102 0 2041266240 29898848 16475040
17:38:48 3785 8192000000 10962459728 11388928000 1980774096 19.471 99 66 132 4 2033931440 32465424 20691920
17:38:59 5629 8192000000 10968910080 11388477440 1994568704 19.580 100 76 152 0 2053738672 35837296 23332672
17:39:11 3875 8192000000 10971667696 11398631424 1998125584 19.608 100 69 138 1 2052914096 34042320 20746192
17:39:23 3739 8192000000 10966593088 11389087744 1980963504 19.472 99 72 143 0 2037200592 34558304 21678784
17:39:33 13701 8192000000 10915629632 11341897728 1912891408 18.930 96 64 128 1 1964195584 31736208 19567968
17:39:55 9300 8192000000 10941492080 11366723584 1974494784 19.421 100 66 132 2 2026300416 31100960 20704672
17:40:11 7576 8192000000 10942859168 11371003904 1975093248 19.426 100 64 128 2 2028352144 33730352 19528544
17:40:28 6786 8192000000 10956665056 11380707328 1969993120 19.385 99 79 158 1 2029674704 35572128 24109456
17:40:42 4609 8192000000 10955265648 11372552192 1982680032 19.486 100 81 159 0 2039159088 32247600 24231456
17:40:54 5320 8192000000 10963239920 11383230464 1988080304 19.529 100 78 156 2 2044555856 32844848 23630704
17:41:07 5252 8192000000 10950175792 11375841280 1971399968 19.397 99 78 156 1 2027773568 32863568 23510032
17:41:20 2368 8192000000 10965515968 11384848384 1991161200 19.553 100 78 155 4 2046862080 31913136 23787744
17:41:31 9684 8192000000 10946314688 11364028416 1970685552 19.391 99 72 143 1 2024533088 32156000 21691536
17:41:51 3520 8192000000 10945865616 11361386496 1945246128 19.189 98 83 167 2 2003210992 32438672 25526192
17:42:03 5458 8192000000 10953145952 11372642304 1976211168 19.435 100 69 138 1 2032033120 34681296 21140656
17:42:17 3227 8192000000 10945582528 11365642240 1957337184 19.285 99 80 160 2 2020718848 37874176 25507488
17:42:28 6188 8192000000 10926490016 11345780736 1938711664 19.136 99 73 146 0 1999034960 38040784 22282512
17:42:41 4150 8192000000 10931775376 11346546688 1934928240 19.106 99 80 160 1 1999962528 40010080 25024208
17:42:52 7356 8192000000 10934160112 11353915392 1953899952 19.258 100 76 152 2 2018926080 41165184 23860944
17:43:09 1808 8192000000 10942699328 11362131968 1962114720 19.323 100 75 149 0 2026871744 41289744 23467280
17:43:19 2177 8192000000 10937454784 11354288128 1954742272 19.264 100 74 148 0 2021586080 42977760 23866048
17:43:28 6852 8192000000 10943184816 11367469056 1959779376 19.304 100 66 130 1 2023939488 43288288 20871824
17:43:44 4255 8192000000 10913745856 11344408576 1934457360 19.103 99 50 100 0 1996168464 44643808 17067296
17:43:57 3556 8192000000 10924239632 11346866176 1934099120 19.100 99 70 140 1 2003010400 46305584 22605696
17:44:11 6467 8192000000 10927276544 11343413248 1946195264 19.196 100 75 148 2 2009053568 40322272 22536032
17:44:26 4376 8192000000 10948863152 11359457280 1959994400 19.306 100 79 159 0 2026643504 42682016 23967088
17:44:37 2504 8192000000 10953921056 11368108032 1964025056 19.338 100 85 164 1 2032496960 43037040 25434864
17:44:47 1582 8192000000 10948037040 11361013760 1951512208 19.239 99 86 168 0 2020415872 41810576 27093088
17:44:57 1859 8192000000 10956501776 11367817216 1967636672 19.367 100 89 177 2 2038001952 43382784 26982496
17:45:05 2757 8192000000 10947617168 11358658560 1954668480 19.264 100 77 150 0 2023508928 44853520 23986928
17:45:15 2545 8192000000 10946659696 11362410496 1959883008 19.305 100 85 171 4 2031675328 45086960 26705360
17:45:24 3670 8192000000 10949745376 11364143104 1963745280 19.336 100 81 161 0 2034761456 46291248 24724928
17:45:35 4587 8192000000 10941864560 11354861568 1935849632 19.114 99 80 158 2 2005421136 44840112 24731392
17:45:48 1888 8192000000 10945391360 11359948800 1955853696 19.273 100 82 164 3 2027921776 46607888 25460192
17:45:57 3396 8192000000 10966178752 11376353280 1968223760 19.371 100 93 185 3 2044259024 47455920 28579344
17:46:08 1747 8192000000 10965284112 11372953600 1959210352 19.300 100 91 182 2 2038016000 50897488 27908160
17:46:17 2117 8192000000 10954798352 11366617088 1939077056 19.139 99 83 164 2 2016388208 51257312 26053840
17:46:28 1758 8192000000 10958413472 11377385472 1962542960 19.326 100 89 178 1 2043245728 52471424 28231344
17:46:37 3807 8192000000 10933851872 11341606912 1936949968 19.122 99 85 170 2 2013212720 49352912 26909840
17:46:48 4910 8192000000 10949124976 11366510592 1957634720 19.287 100 88 176 2 2036357728 50893200 27829808
17:47:02 3121 8192000000 10953441520 11365715968 1954048944 19.259 100 82 163 3 2030428144 51032944 25346256
17:47:14 2178 8192000000 10953838112 11366379520 1953517120 19.254 100 80 160 0 2030946368 51989632 25439616
17:47:23 3411 8192000000 10957456816 11373035520 1957194304 19.284 100 83 166 2 2037254240 53112368 26947568
17:47:33 2194 8192000000 10946575568 11354587136 1943422208 19.174 99 89 175 1 2025286032 54039888 27823936
17:47:43 2102 8192000000 10965024880 11379372032 1963650560 19.335 100 89 177 1 2047851776 55696832 28504384
17:47:52 6147 8192000000 10950174480 11378642944 1960066144 19.307 100 68 136 1 2034931776 52718368 22147264
17:48:06 2848 8192000000 10954509840 11385946112 1966137488 19.355 100 60 120 1 2038314848 52500976 19676384
17:48:17 7137 8192000000 10927364528 11366776832 1946421360 19.198 99 47 94 0 2003398944 42077184 14900400
17:48:35 4638 8192000000 10913129680 11351216128 1943943408 19.178 100 46 89 2 1997375600 37993824 15438368
17:48:47 10298 8192000000 10923631328 11370196992 1958751296 19.296 100 37 73 0 2014772752 43354080 12667376
17:49:08 22853 8192000000 10914053136 11348426752 1912093696 18.923 98 38 76 1 1969451616 44165440 13192480
17:49:47 10662 8192000000 10911524320 11359834112 1948173168 19.212 100 39 76 1 1996803920 36008144 12622608
17:50:05 11448 8192000000 10916086368 11359105024 1953210240 19.252 100 31 62 1 1999889424 36133584 10545600
17:50:25 25204 8192000000 10926993408 11366760448 1935909680 19.114 99 28 56 2 1982846704 37808976 9128048
17:51:12 29060 8192000000 10913432768 11365191680 1941943136 19.162 100 23 46 1 1990075856 40407472 7725248
17:51:47 20377 8192000000 10917752144 11372654592 1949197056 19.220 100 26 52 1 2001836256 43354480 9284720
17:52:20 26548 8192000000 10919518944 11362795520 1932057424 19.083 99 29 58 0 1982386880 40867232 9462224
17:53:02 26303 8192000000 10898741120 11349602304 1922293888 19.005 99 26 52 1 1976003840 44804288 8905664
17:53:35 42541 8192000000 10884382992 11342032896 1898848272 18.817 98 22 44 1 1945733232 38889296 7995664
17:54:24 40547 8192000000 10898884944 11356725248 1926288304 19.037 100 15 30 1 1974296320 42175728 5832288
17:55:11 27913 8192000000 10909840752 11372437504 1927818464 19.049 100 20 39 1 1994066256 58107312 8140480
17:56:02 23066 8192000000 10868024368 11337859072 1893555104 18.774 98 10 20 1 1933452608 36572016 3325488
17:56:34 53144 8192000000 10879631856 11360567296 1910095120 18.907 99 11 22 0 1950438288 37367104 2976064
17:57:34 69422 8192000000 10877878544 11336560640 1925472400 19.031 99 27 54 2 1952009504 18914368 7622736
17:59:26 28451 8192000000 10884878592 11351068672 1959049008 19.298 100 36 72 0 1981281104 11806848 10425248
18:00:10 23184 8192000000 10892145872 11363807232 1961770272 19.320 100 16 32 2 1980787168 14620528 4396368
18:00:39 19646 8192000000 10899836384 11366166528 1966884960 19.361 100 19 39 1 1983399392 11615424 4899008
18:01:06 43678 8192000000 10883881904 11340341248 1951178480 19.236 99 17 35 1 1967646720 11998928 4469312
18:01:56 85370 8192000000 10890904896 11347189760 1908618240 18.896 97 18 35 0 1923597072 10171344 4807488
18:03:28 44771 8192000000 10888317632 11353264128 1940841824 19.153 99 10 19 0 1952144576 8745488 2557264
18:04:22 35266 8192000000 10897315648 11359358976 1971772656 19.400 100 29 57 0 1987818608 8672752 7373200
18:05:33 46581 8192000000 10897542512 11357491200 1955318656 19.269 99 20 40 0 1968308112 7970608 5018848
18:06:30 22261 8192000000 10884898112 11355144192 1966479920 19.358 100 11 22 2 1976355472 7012512 2863040
18:06:59 52017 8192000000 10883286448 11351748608 1959370048 19.301 99 20 40 1 1974474544 9419248 5685248
18:08:02 65940 8192000000 10918965520 11390046208 1981120640 19.474 100 15 30 1 1999271616 13966928 4184048
18:09:14 122246 8192000000 10917795712 11394940928 1992272976 19.562 100 24 49 1 2020802000 20871344 7657680
18:11:23 119567 8192000000 10923542736 11387592704 1948120992 19.212 98 20 40 0 1962643008 8572800 5949216
18:13:49 8628 8192000000 10921543136 11386359808 1989391648 19.539 100 26 51 2 2009419856 12054640 7973568
18:14:05 37911 8192000000 10915398912 11389616128 1998692480 19.612 100 26 52 0 2018927456 12163312 8071664
18:15:14 22917 8192000000 10933333792 11403255808 2005883728 19.669 100 39 77 4 2031094656 11721968 13488960
18:15:49 45095 8192000000 10947665072 11411800064 2004962896 19.662 100 38 76 2 2032642656 16308832 11370928
18:16:45 66148 8192000000 10920573792 11414298624 2001635840 19.636 100 24 48 0 2030305040 21095056 7574144
18:17:58 54708 8192000000 10920137776 11395710976 1979283360 19.459 99 15 30 3 2001311024 17741200 4286464
18:19:07 75744 8192000000 10914831872 11393589248 1968375632 19.373 99 19 38 0 2002855872 27945136 6535104
18:20:34 35831 8192000000 10876469424 11376451584 1934089184 19.100 98 7 14 2 1950170288 13510832 2570272
18:21:22 74136 8192000000 10880976608 11365199872 1944283520 19.181 99 7 14 0 1957656576 11112688 2260368
18:22:45 33425 8192000000 10919536624 11368628224 1971349664 19.396 100 29 58 2 1987495520 8284912 7860944
18:23:27 44312 8192000000 10890537472 11367878656 1937463616 19.127 98 15 30 0 1949733248 8404528 3865104
18:24:33 43321 8192000000 10896105952 11366965248 1933214704 19.093 98 25 50 0 1950280512 9762800 7303008
18:25:46 76881 8192000000 10885516464 11355779072 1883121264 18.690 95 16 32 0 1900657584 12825200 4711120
18:27:15 37792 8192000000 10914121216 11375783936 1952310064 19.245 99 37 74 1 1980906032 17652320 10943648
18:28:03 47755 8192000000 10907709168 11366236160 1961515280 19.318 99 22 42 1 1985964704 18414608 6034816
18:28:59 38040 8192000000 10885058368 11359227904 1900497984 18.830 96 29 58 1 1927839680 19083616 8258080
18:29:45 71278 8192000000 10860813456 11346776064 1909602272 18.903 98 20 39 0 1932717520 17921152 5194096
18:31:20 148332 8192000000 10887162272 11367477248 1880218944 18.667 95 10 20 0 1897764880 14737616 2808320
18:33:57 63095 8192000000 10907524160 11384741888 1957768160 19.288 99 12 24 1 1976251280 15050784 3432336
18:35:18 51230 8192000000 10889010336 11347750912 1894525584 18.782 96 17 32 1 1907317792 8453488 4338720
18:36:20 53662 8192000000 10886789200 11351117824 1934506336 19.103 99 39 78 1 1956832224 11438800 10887088
18:37:26 103819 8192000000 10874030608 11342213120 1923646368 19.016 98 36 72 0 1945551504 11480832 10424304
18:39:25 56083 8192000000 10883774304 11347226624 1914853216 18.946 98 28 56 1 1934144352 11646864 7644272
18:40:27 41800 8192000000 10892515008 11352424448 1958102608 19.291 100 40 80 1 1980281872 10579664 11599600
18:41:34 26750 8192000000 10850172464 11326693376 1905175696 18.868 97 29 58 0 1923517232 10253888 8087648
18:42:32 43926 8192000000 10850321456 11319296000 1880193248 18.667 97 20 40 0 1894238944 8991280 5054416
18:43:29 33221 8192000000 10835148544 11286769664 1809714496 18.094 94 35 70 0 1830485280 11408016 9362768
18:44:24 100311 8192000000 10802856592 11267739648 1791702752 17.946 94 19 38 0 1806153808 8603232 5847824
18:46:11 49555 8192000000 10813356384 11275722752 1860359040 18.506 98 13 26 0 1876017680 11682192 3976448
18:48:27 82217 8192000000 10853235792 11312717824 1870613584 18.589 97 22 44 1 1886484368 10388224 5482560
18:49:55 19740 8192000000 10856529232 11306635264 1899834656 18.825 99 30 60 1 1916378432 8205488 8338288
18:50:23 60998 8192000000 10821834800 11304824832 1909027248 18.899 100 7 14 0 1917600000 6862656 1710096
18:51:37 71187 8192000000 10831418256 11314216960 1846603520 18.395 96 14 28 0 1859923424 9648080 3671824
18:53:03 32516 8192000000 10829938160 11302006784 1878290272 18.651 98 13 26 1 1891416352 8719664 4406416
18:53:45 30708 8192000000 10868123312 11325669376 1925279680 19.029 100 26 52 1 1938568848 5875840 7413328
18:54:22 65857 8192000000 10867734416 11340288000 1940086288 19.147 100 20 40 0 1955641584 9334128 6221168
18:55:42 18629 8192000000 10881611344 11341037568 1934090656 19.100 99 36 72 0 1953712144 9854432 9767056
18:56:10 43099 8192000000 10887251520 11352072192 1913055056 18.931 98 27 54 2 1935338288 14747936 7535296
18:57:09 68835 8192000000 10898689920 11375054848 1936063536 19.115 99 31 62 1 1957088400 13241616 7783248
18:58:25 91280 8192000000 10903610512 11373555712 1928693984 19.056 98 8 16 0 1945041024 14339136 2007904
19:00:03 73613 8192000000 10927186432 11395612672 1980542240 19.469 100 19 38 1 2000308016 14420288 5345488
19:01:26 61435 8192000000 10929778496 11401043968 1963077968 19.330 98 27 53 1 1982890768 12032800 7780000
19:02:34 113474 8192000000 10898978960 11379941376 1887688944 18.727 95 11 22 1 1908671728 18101024 2881760
19:04:37 31985 8192000000 10924278192 11385450496 1979058096 19.457 100 29 58 4 2000251760 12617936 8575728
19:05:19 43422 8192000000 10925239328 11392503808 1968259488 19.372 99 51 102 1 1995955216 13586832 14108896
19:06:15 60169 8192000000 10920522736 11394514944 1949591072 19.223 98 28 56 0 1974322672 17233344 7498256
19:07:27 68537 8192000000 10917004560 11377475584 1962577136 19.327 99 26 52 1 1981585920 11957504 7051280
19:10:23 76821 8192000000 10897396256 11356676096 1926843520 19.042 97 27 54 1 1947987216 13500768 7642928
19:11:51 82053 8192000000 10875393536 11359760384 1955158624 19.268 99 16 32 0 1971351424 11119904 5072896
19:13:20 46337 8192000000 10885263120 11374321664 1970469264 19.389 100 10 20 1 1982080816 8784848 2826704
19:14:12 41185 8192000000 10874090784 11347124224 1889302432 18.740 96 5 10 0 1902252624 11779744 1170448
19:14:59 70734 8192000000 10888642640 11364708352 1961865120 19.321 100 12 24 0 1974716608 9215856 3635632
19:16:16 74092 8192000000 10884729616 11364089856 1930517120 19.071 98 18 36 1 1946929808 11283616 5129072
19:17:53 72693 8192000000 10862755472 11352289280 1886770320 18.720 96 5 10 1 1898563264 10488816 1304128
19:20:19 63861 8192000000 10870169984 11342901248 1883016896 18.689 96 17 34 0 1900732896 12559952 5156048
19:21:48 67576 8192000000 10873860096 11350581248 1945687216 19.192 100 17 33 2 1963864048 13249472 4927360
19:23:02 75779 8192000000 10883625136 11355615232 1920184656 18.988 98 13 26 1 1932534304 8682016 3667632
19:24:35 61742 8192000000 10901090912 11368087552 1931605824 19.080 98 36 72 1 1955635568 14390304 9639440
19:25:43 55314 8192000000 10912198400 11383291904 1930522336 19.071 98 41 80 1 1962976128 21536656 10917136
19:26:52 43375 8192000000 9128468352 9450770432 25113200 0.305 2 1 2 0 25637328 462000 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-03-2021 19:28:18 to 12-03-2021 19:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2021 19:28:51 to 12-03-2021 19:28:53.

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          235496
MON$OLDEST_ACTIVE               235497
MON$OLDEST_SNAPSHOT             235497
MON$NEXT_TRANSACTION            235497
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                       2020544
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.33425 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33425 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33425 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33425 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'

12.03.21 19:28:54. 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-03-12 19:28:56 No severe PSQL-related problems occured
12.03.21 19:28:57. End of report.