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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17460484 kB
MemAvailable 31535144 kB
Buffers 0 kB
Cached 14268840 kB
SwapCached 4652 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 2020-11-19 19:27:03
DTS_END                         2020-11-19 19:27:03.6260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45608
TRN_ID                          238872
ATT_ID                          707
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: 9267.51 25572 1112101
customer order: creation 167.51 336 20101
customer order: refuse 14.97 317 1796
order to supplier: creation 44.70 1247 5364
order to supplier: removal 3.46 101625 415
invoice (draft): creation 44.50 3718 5340
invoice (draft): removal 53.10 829 6372
invoice accept: apply 40.84 17986 4901
invoice accept: cancel 48.14 809 5777
customer reserve: creation 3824.70 175 458964
customer reserve: removal 4727.04 58 567245
realization accept: apply 82.59 182 9911
realization accept: cancel 86.83 109 10420
payment from customer: creation 58.93 138 7071
payment from customer: removal 5.93 64 712
payment to supplier: creation 49.02 144 5882
payment to supplier: removal 3.36 100 403
service: total inventory turnovers 4.57 982 548
service: total monetary turnovers 6.58 46 789
service: aggregate perf. data 0.72 25583 86
service: refresh index statistics 0.03 356988 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-11-2020 19:29:47 to 19-11-2020 19:29:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2996
TEST_TIME 2 5029
TEST_TIME 3 5003
TEST_TIME 4 4313
TEST_TIME 5 4366
TEST_TIME 6 4525
TEST_TIME 7 4357
TEST_TIME 8 4415
TEST_TIME 9 4427
TEST_TIME 10 4864
TEST_TIME 11 5490
TEST_TIME 12 5808
TEST_TIME 13 5834
TEST_TIME 14 6418
TEST_TIME 15 7254
TEST_TIME 16 7570
TEST_TIME 17 7795
TEST_TIME 18 8138
TEST_TIME 19 8804
TEST_TIME 20 8763
TEST_TIME 21 8710
TEST_TIME 22 8842
TEST_TIME 23 8906
TEST_TIME 24 9078
TEST_TIME 25 8998
TEST_TIME 26 9006
TEST_TIME 27 9316
TEST_TIME 28 10793
TEST_TIME 29 10852
TEST_TIME 30 10576
TEST_TIME 31 10355
TEST_TIME 32 10203
TEST_TIME 33 10127
TEST_TIME 34 10304
TEST_TIME 35 10211
TEST_TIME 36 10049
TEST_TIME 37 9917
TEST_TIME 38 9734
TEST_TIME 39 9584
TEST_TIME 40 9452
TEST_TIME 41 9769
TEST_TIME 42 9655
TEST_TIME 43 9534
TEST_TIME 44 9394
TEST_TIME 45 9380
TEST_TIME 46 9398
TEST_TIME 47 9329
TEST_TIME 48 9500
TEST_TIME 49 9387
TEST_TIME 50 9231
TEST_TIME 51 9226
TEST_TIME 52 9264
TEST_TIME 53 9138
TEST_TIME 54 9198
TEST_TIME 55 9261
TEST_TIME 56 9287
TEST_TIME 57 9288
TEST_TIME 58 9317
TEST_TIME 59 9362
TEST_TIME 60 9337
TEST_TIME 61 9314
TEST_TIME 62 9510
TEST_TIME 63 9501
TEST_TIME 64 9491
TEST_TIME 65 9624
TEST_TIME 66 9554
TEST_TIME 67 9708
TEST_TIME 68 9622
TEST_TIME 69 9491
TEST_TIME 70 9475
TEST_TIME 71 9462
TEST_TIME 72 9461
TEST_TIME 73 9420
TEST_TIME 74 9378
TEST_TIME 75 9336
TEST_TIME 76 9313
TEST_TIME 77 9281
TEST_TIME 78 9277
TEST_TIME 79 9252
TEST_TIME 80 9298
TEST_TIME 81 9264
TEST_TIME 82 9287
TEST_TIME 83 9336
TEST_TIME 84 9355
TEST_TIME 85 9399
TEST_TIME 86 9414
TEST_TIME 87 9413
TEST_TIME 88 9482
TEST_TIME 89 9479
TEST_TIME 90 9475
TEST_TIME 91 9501
TEST_TIME 92 9554
TEST_TIME 93 9466
TEST_TIME 94 9411
TEST_TIME 95 9431
TEST_TIME 96 9368
TEST_TIME 97 9338
TEST_TIME 98 9309
TEST_TIME 99 9279
TEST_TIME 100 9303
TEST_TIME 101 9287
TEST_TIME 102 9290
TEST_TIME 103 9429
TEST_TIME 104 9390
TEST_TIME 105 9394
TEST_TIME 106 9391
TEST_TIME 107 9417
TEST_TIME 108 9443
TEST_TIME 109 9513
TEST_TIME 110 9485
TEST_TIME 111 9453
TEST_TIME 112 9391
TEST_TIME 113 9400
TEST_TIME 114 9403
TEST_TIME 115 9366
TEST_TIME 116 9386
TEST_TIME 117 9395
TEST_TIME 118 9360
TEST_TIME 119 9349
TEST_TIME 120 9273

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-11-2020 19:29:51 to 19-11-2020 19:29:54.

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 1536354 1536354 0 0.00 0 24828 6 0 0
doc_list_biud 1536348 1536348 0 0.00 0 50339 27 0 0
sp_add_invoice_to_stock 5043 4901 142 2.81 20 202346 17986 0 142
sp_cancel_adding_invoice 5777 5777 0 0.00 4 57523 809 0 0
sp_cancel_client_order 1796 1796 0 0.00 4 11283 317 0 0
sp_cancel_customer_reserve 567245 567245 0 0.00 1 50346 59 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 2 4278 65 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 3 6214 100 0 0
sp_cancel_supplier_invoice 6380 6372 8 0.12 2 20303 829 0 8
sp_cancel_supplier_order 415 415 0 0.00 5 1012272 101625 0 0
sp_cancel_write_off 10420 10420 0 0.00 1 10858 109 0 0
sp_client_order 20101 20101 0 0.00 3 28049 336 0 0
sp_customer_reserve 458964 458964 0 0.00 0 53523 175 0 0
sp_fill_shopping_cart 30799 30799 0 0.00 1 26773 45 0 0
sp_fill_shopping_cart_clo_res 458960 458960 0 0.00 0 16230 14 0 0
sp_get_clo_for_invoice 4894 4894 0 0.00 0 39184 329 0 0
sp_kill_cost_storno 17312 17312 0 0.00 0 13008 58 0 0
sp_kill_qstorno_ret_qs2qd 1151697 1151697 0 0.00 0 50335 32 0 0
sp_kill_qty_storno 606828 606828 0 0.00 0 50339 69 0 0
sp_lock_selected_doc 20571 20571 0 0.00 0 7648 5 0 0
sp_make_cost_storno 27758 27758 0 0.00 0 24815 59 0 0
sp_multiply_rows_for_pdistr 27754 27754 0 0.00 0 7850 31 0 0
sp_multiply_rows_for_qdistr 20101 20101 0 0.00 0 14479 152 0 0
sp_pay_from_customer 7071 7071 0 0.00 4 18580 139 0 0
sp_pay_to_supplier 5882 5882 0 0.00 5 16561 144 0 0
sp_payment_common 12951 12951 0 0.00 1 18572 42 0 0
sp_qd_handle_on_cancel_clo 1796 1796 0 0.00 0 10713 283 0 0
sp_qd_handle_on_invoice_upd_sts 10670 10670 0 0.00 0 30659 337 0 0
sp_qd_handle_on_reserve_upd_sts 9910 9910 0 0.00 0 14296 58 0 0
sp_reserve_write_off 9911 9911 0 0.00 6 14436 183 0 0
sp_supplier_invoice 5340 5340 0 0.00 6 98010 3718 0 0
sp_supplier_order 5364 5364 0 0.00 5 37760 1247 0 0
srv_aggregate_perf_data 86 86 0 0.00 2610 401312 25584 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1301 136581 34208 0 0
srv_find_qd_qs_mism 1064560 1064560 0 0.00 0 19513 4 0 0
srv_make_invnt_saldo 548 548 0 0.00 45 39650 982 0 0
srv_make_money_saldo 789 789 0 0.00 1 17754 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 210626 454780 356989 0 0
t$perf-abend:sp_add_invoice_to_stock 142 142 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4902 4902 0 0.00 0 9982 158 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 11581 141 0 0
t$perf-norm:sp_cancel_client_order 1796 1796 0 0.00 0 11647 15 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 1785 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2028 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 126 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 6738 26 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 23451 1577 0 0
t$perf-norm:sp_cancel_write_off 927 927 0 0.00 0 2622 11 0 0
t$perf-norm:sp_client_order 20101 20101 0 0.00 0 15663 17 0 0
t$perf-norm:sp_customer_reserve 972 972 0 0.00 0 4541 9 0 0
t$perf-norm:sp_pay_from_customer 7071 7071 0 0.00 0 9591 11 0 0
t$perf-norm:sp_pay_to_supplier 5882 5882 0 0.00 0 15941 10 0 0
t$perf-norm:sp_reserve_write_off 9911 9911 0 0.00 0 16201 12 0 0
t$perf-norm:sp_supplier_invoice 5340 5340 0 0.00 0 8276 22 0 0
t$perf-norm:sp_supplier_order 5364 5364 0 0.00 0 11586 19 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 722 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 320 4 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 947 19 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 2997 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10068 9784 284 2.82 0 7676 20 0 284
v_all_customers 37024 37024 0 0.00 0 22 1 0 0
v_all_suppliers 29926 29926 0 0.00 0 37 1 0 0
v_all_wares 40202 40202 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 2330 16 0 0
v_cancel_client_order 3592 3592 0 0.00 0 3653 7 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 4271 8 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 2494 10 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 1205 5 0 0
v_cancel_supplier_invoice 854 838 16 1.87 0 7118 24 0 16
v_cancel_supplier_order 830 830 0 0.00 0 1251 7 0 0
v_cancel_write_off 1854 1854 0 0.00 0 3103 17 0 0
v_max_id_clo_ord 5363 5363 0 0.00 0 258 1 0 0
v_max_id_clo_res 972 972 0 0.00 0 2818 15 0 0
v_max_id_ord_sup 5335 5335 0 0.00 0 4826 6 0 0
v_max_non_paid_invoice 1615 1615 0 0.00 0 931 4 0 0
v_max_non_paid_realizn 3644 3644 0 0.00 0 3369 4 0 0
v_min_id_clo_ord 5363 5363 0 0.00 0 7905 17 0 0
v_min_id_clo_res 972 972 0 0.00 0 2823 8 0 0
v_min_id_ord_sup 5335 5335 0 0.00 0 8537 14 0 0
v_min_non_paid_invoice 5880 5880 0 0.00 0 9713 26 0 0
v_min_non_paid_realizn 7071 7071 0 0.00 0 18565 35 0 0
v_our_firm 10032 10032 0 0.00 0 31 1 0 0
v_reserve_write_off 19820 19820 0 0.00 0 4217 7 0 0
x_lock_depdocs_on_canc_invoice 11730 11730 0 0.00 0 23974 126 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 22050 413 0 0
x_make_qstorno_1000_1200 5364 5364 0 0.00 2 37587 1155 0 0
x_make_qstorno_1200_2000 5340 5340 0 0.00 2 91689 3557 0 0
x_make_qstorno_2100_3300 458964 458964 0 0.00 0 53517 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-11-2020 19:29:55 to 19-11-2020 19:29:59.

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:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:13 13378 8192000000 10188024912 10495410176 847168288 9.372 69 50 100 0 866388704 2334992 16885424
16:57:34 31431 8192000000 10349848864 10661756928 1379481968 14.412 100 81 161 0 1410242832 4461216 26299648
16:58:12 23449 8192000000 10359793072 10681700352 1419251712 14.766 100 89 178 0 1455303040 6507408 29543920
16:58:45 33448 8192000000 10402417232 10729279488 1453096528 15.065 100 90 180 1 1490294816 7535648 29662640
16:59:28 28639 8192000000 10429809472 10756825088 1473969728 15.249 100 88 176 1 1511229168 8148608 29110832
17:00:11 25230 8192000000 10439902176 10773725184 1493578256 15.420 100 88 177 0 1531112672 8894000 28640416
17:00:45 28452 8192000000 10454740912 10791538688 1506819056 15.536 100 87 174 1 1544310560 9734368 27757136
17:01:23 20183 8192000000 10467094688 10810425344 1520498448 15.655 100 81 162 0 1556541584 10251120 25792016
17:01:53 20309 8192000000 10517765872 10868256768 1561236416 16.007 100 77 154 1 1595048384 9871168 23940800
17:02:22 14462 8192000000 10549724672 10901958656 1598377152 16.326 100 80 160 0 1633635584 10733392 24525040
17:02:44 11510 8192000000 10564601248 10923081728 1620632640 16.515 100 78 156 2 1655611664 11467584 23511440
17:03:06 12236 8192000000 10578511792 10938953728 1636315424 16.648 100 74 148 0 1670188336 11473600 22399312
17:03:28 9209 8192000000 10594833312 10964910080 1657173232 16.825 100 70 140 0 1689610752 11687984 20749536
17:03:45 7025 8192000000 10611579472 10981789696 1677803600 16.999 100 76 153 1 1712066784 11842240 22420944
17:04:00 7106 8192000000 10626478048 11001737216 1692476400 17.122 100 72 142 1 1724467952 11435632 20555920
17:04:15 7846 8192000000 10656724672 11028631552 1708686592 17.258 100 76 154 0 1742648688 11898624 22063472
17:04:30 6341 8192000000 10662529024 11040116736 1726066576 17.403 100 78 157 4 1760926672 12867616 21992480
17:04:44 5404 8192000000 10672284848 11047522304 1738662320 17.508 100 76 152 0 1773270624 13055072 21553232
17:04:57 5719 8192000000 10693161248 11069857792 1751210144 17.612 100 83 165 1 1787451536 13487536 22753856
17:05:09 5047 8192000000 10700199888 11076845568 1758720128 17.674 100 84 168 0 1796745616 14771200 23254288
17:05:22 5432 8192000000 10714181728 11093581824 1767046816 17.743 100 78 156 0 1802872528 13925088 21900624
17:05:34 4255 8192000000 10709537856 11092439040 1773369104 17.795 100 79 158 0 1809508464 13620880 22518480
17:05:54 6502 8192000000 10724408048 11107012608 1780554000 17.854 100 71 142 1 1813227456 13137760 19535696
17:06:08 3490 8192000000 10729687632 11120590848 1801075472 18.023 100 74 146 0 1834745232 12625808 21043952
17:06:19 3518 8192000000 10755898800 11145555968 1818436496 18.165 100 91 182 0 1856899648 13013984 25449168
17:06:30 3291 8192000000 10767092032 11153305600 1826422448 18.230 100 89 178 0 1863849920 12153360 25274112
17:06:41 3247 8192000000 10767553280 11152330752 1825999104 18.227 100 83 166 1 1861442176 12570000 22873072
17:06:51 1784 8192000000 10772201168 11160276992 1830622608 18.264 100 77 154 1 1865079840 12265664 22191568
17:06:59 3026 8192000000 10783267616 11168055296 1843296496 18.368 100 91 183 0 1882046416 13718240 25031680
17:07:09 2827 8192000000 10778651648 11170283520 1845401696 18.385 100 88 176 0 1883075008 12758592 24914720
17:07:18 1789 8192000000 10797075632 11184816128 1852137264 18.439 100 94 189 3 1893536800 13980336 27419200
17:07:27 3133 8192000000 10797905424 11188310016 1856943760 18.478 100 84 168 0 1892987344 12833008 23210576
17:07:37 1844 8192000000 10802910160 11191070720 1858794016 18.494 100 92 183 2 1898311264 13578272 25938976
17:07:45 2021 8192000000 10809528544 11195895808 1860855760 18.510 100 91 185 1 1902252512 14699440 26697312
17:07:54 1479 8192000000 10805591744 11197091840 1866387808 18.555 100 90 178 1 1905694752 13326896 25980048
17:08:02 1611 8192000000 10814403520 11202375680 1868644400 18.573 100 95 193 1 1908001104 12030704 27326000
17:08:10 2070 8192000000 10815794512 11203575808 1869648912 18.581 100 88 177 1 1907301440 12421744 25230784
17:08:18 1395 8192000000 10822111008 11210690560 1878403680 18.652 100 93 186 1 1917811824 13077824 26330320
17:08:26 1294 8192000000 10819752064 11209625600 1880759152 18.671 100 92 182 2 1919961920 12221072 26981696
17:08:34 1210 8192000000 10834921792 11224887296 1885902960 18.713 100 94 190 0 1925135888 12084736 27148192
17:08:41 36643 8192000000 10787753888 11217502208 1881793616 18.680 100 45 90 0 1902618464 8273888 12550960
17:09:25 5145 8192000000 10815574640 11231735808 1880911792 18.672 100 46 93 0 1908680960 15193392 12575776
17:09:36 6840 8192000000 10798520656 11220656128 1883516288 18.693 100 44 88 2 1903916000 7823488 12576224
17:09:51 6951 8192000000 10786934128 11216465920 1882174128 18.683 100 25 50 0 1895800896 6156416 7470352
17:10:07 6671 8192000000 10798642368 11224887296 1884312944 18.700 100 28 56 2 1899292800 7207680 7772176
17:10:22 9325 8192000000 10793381472 11225661440 1886783408 18.720 100 19 38 2 1898408656 6459072 5166176
17:10:37 9004 8192000000 10788907504 11229061120 1888879360 18.737 100 15 30 0 1899396592 6022272 4494960
17:10:55 8905 8192000000 10801867104 11236171776 1891660928 18.759 100 16 32 2 1902418928 6202800 4555200
17:11:10 17562 8192000000 10804806384 11243499520 1898000368 18.810 100 15 29 1 1911897520 9983184 3913968
17:11:34 14708 8192000000 10803874048 11239096320 1897361808 18.805 100 10 17 2 1905446064 5214800 2869456
17:11:55 18810 8192000000 10806047072 11248459776 1901474208 18.838 100 11 22 1 1910290656 5849360 2967088
17:12:23 14668 8192000000 10809013648 11252359168 1906205744 18.876 100 14 28 0 1916234512 6278064 3750704
17:12:45 74350 8192000000 10820289120 11262398464 1914717888 18.945 100 28 56 1 1928375056 5298400 8358768
17:14:08 10745 8192000000 10825269456 11262955520 1896602864 18.799 99 29 58 1 1911046032 6612016 7831152
17:14:25 4909 8192000000 10824181360 11264184320 1914442832 18.942 100 25 50 0 1928426352 6502192 7481328
17:14:39 5110 8192000000 10824542848 11265388544 1911661968 18.920 100 25 50 3 1925452560 6543584 7247008
17:14:51 5086 8192000000 10837085664 11269206016 1915863936 18.954 100 23 46 1 1928815248 6486720 6464592
17:15:02 5859 8192000000 10840859984 11273277440 1918154864 18.972 100 31 62 0 1935502688 7724064 9623760
17:15:17 10138 8192000000 10824853744 11260821504 1899401488 18.821 99 26 52 1 1912413760 6026512 6985760
17:15:37 6663 8192000000 10822637312 11261227008 1903378368 18.853 100 25 49 0 1916825184 6860608 6586208
17:15:51 7236 8192000000 10826442992 11263918080 1908644896 18.896 100 21 42 1 1920435680 5660896 6129888
17:16:09 6447 8192000000 10837559296 11263950848 1877731616 18.647 98 30 61 0 1892020736 5390192 8898928
17:16:27 7490 8192000000 10819329728 11251642368 1884516336 18.702 99 17 34 2 1894616752 5456832 4643584
17:16:46 6102 8192000000 10816173248 11248902144 1898393728 18.813 100 29 59 0 1917272176 10836448 8042000
17:16:58 7105 8192000000 10803497680 11235254272 1849681680 18.420 98 23 46 0 1866313504 10129504 6502320
17:17:11 12633 8192000000 10788233776 11221827584 1859112992 18.496 99 15 30 1 1868695120 5217136 4364992
17:17:30 13548 8192000000 10802637152 11225104384 1858724480 18.493 99 20 40 0 1870204624 5611104 5869040
17:17:50 66012 8192000000 10711974928 11126865920 1661344128 16.860 89 30 60 1 1674736848 4772432 8620288
17:19:02 8088 8192000000 10742306432 11173068800 1799576640 18.010 98 21 42 1 1810901616 5072176 6252800
17:19:16 12859 8192000000 10742942544 11165351936 1765668432 17.731 96 30 61 2 1781011392 6061008 9281952
17:19:39 5608 8192000000 10738237776 11156033536 1804507440 18.051 98 23 46 1 1818046096 6910528 6628128
17:19:51 6027 8192000000 10739079312 11155197952 1772189664 17.785 97 25 51 4 1784451840 4997552 7264624
17:20:08 7178 8192000000 10721686784 11142115328 1780454544 17.853 98 18 36 0 1792003488 6396960 5151984
17:20:23 9263 8192000000 10728203984 11144163328 1772379520 17.787 98 22 45 0 1784815232 6357568 6078144
17:20:40 7077 8192000000 10652028672 11060629504 1695491456 17.147 96 34 67 2 1710930432 6032176 9406800
17:20:55 7438 8192000000 10688144544 11099746304 1746407392 17.572 99 21 42 5 1762211344 9819024 5984928
17:21:10 11516 8192000000 10682438528 11091939328 1705022896 17.227 96 22 43 0 1717507184 5573456 6910832
17:21:28 5714 8192000000 10704125504 11123654656 1789765520 17.930 100 27 54 1 1803613968 5649280 8199168
17:21:41 9221 8192000000 10707349792 11116896256 1777225664 17.827 99 31 62 3 1791690672 5274016 9190992
17:21:56 9372 8192000000 10725505056 11151740928 1813806576 18.127 100 28 56 1 1827477984 6006880 7664528
17:22:12 6971 8192000000 10725229568 11151020032 1814745632 18.135 100 17 32 5 1825135440 5400272 4989536
17:22:30 10475 8192000000 10752436208 11169882112 1812938336 18.120 99 22 43 4 1828164256 9038496 6187424
17:22:46 58239 8192000000 10761459520 11171729408 1821874928 18.193 99 33 66 1 1837053296 5476432 9701936
17:23:55 28698 8192000000 10747549328 11183185920 1842989664 18.365 100 26 52 2 1856590320 5263008 8337648
17:24:33 8096 8192000000 10763833216 11192430592 1850722208 18.428 100 21 42 0 1862105024 5695232 5687584
17:24:47 7667 8192000000 10779587552 11199901696 1856779104 18.477 100 24 46 4 1869128176 5495296 6853776
17:25:03 8489 8192000000 10772865872 11201531904 1856222352 18.473 100 13 26 1 1865059216 5263984 3572880
17:25:21 5191 8192000000 10782224656 11204378624 1861603904 18.516 100 26 52 4 1874665728 5727264 7334560
17:25:32 13421 8192000000 10777367776 11207639040 1862303984 18.522 100 19 38 2 1872767856 5271552 5192320
17:25:52 7596 8192000000 10783467392 11211300864 1863357728 18.530 100 21 41 0 1875165824 5716000 6092096
17:26:06 8178 8192000000 10785725120 11211341824 1866862688 18.559 100 23 47 1 1879472128 5970736 6638704
17:26:21 7040 8192000000 10786112176 11210432512 1865074832 18.544 100 14 26 2 1874343712 5467968 3800912
17:26:35 7933 8192000000 10779251088 11214536704 1866643968 18.557 100 19 37 2 1877711424 5776448 5291008
17:26:50 9172 8192000000 10794985488 11217104896 1869954400 18.584 100 17 34 2 1879895152 5423584 4517168
17:27:08 46796 8192000000 10816175392 11236524032 1885610464 18.710 100 31 62 3 1900646432 6438528 8597440
17:28:06 61550 8192000000 10848777344 11272871936 1907272960 18.885 100 37 74 4 1926359952 9027232 10059760
17:29:14 15428 8192000000 10841005408 11265875968 1905346256 18.869 99 34 68 0 1926383808 11475328 9562224
17:29:45 17170 8192000000 10860010944 11286990848 1924709536 19.025 100 36 72 1 1947999344 12834032 10455776
17:30:09 39047 8192000000 10868812752 11297394688 1933163376 19.092 100 30 60 1 1953638928 12013408 8462144
17:30:57 10835 8192000000 10882554352 11304165376 1946184912 19.196 100 53 106 1 1972170320 11820304 14165104
17:31:16 101303 8192000000 10878330176 11318345728 1944945920 19.186 100 46 91 2 1971687984 13206928 13535136
17:33:07 40464 8192000000 10894760832 11335880704 1953310048 19.253 100 26 52 0 1979194640 17736000 8148592
17:33:56 32396 8192000000 10893738288 11329171456 1926978960 19.043 98 34 66 1 1953953856 17430560 9544336
17:34:36 6749 8192000000 10906644480 11332890624 1960797760 19.312 100 45 90 0 1992525872 18676128 13051984
17:34:51 7865 8192000000 10909153472 11338371072 1963923040 19.337 100 47 91 1 1995732048 18396256 13412752
17:35:08 11121 8192000000 10925206192 11345571840 1970785728 19.392 100 58 116 1 2008294736 20878528 16630480
17:35:39 11030 8192000000 10919944736 11353395200 1975070912 19.426 100 41 82 0 2007427456 20382912 11973632
17:36:00 8889 8192000000 10919905696 11355066368 1976372752 19.436 100 40 78 0 2008401872 20436432 11592688
17:36:18 4006 8192000000 10939036960 11363135488 1983681840 19.494 100 63 124 1 2024602400 22562976 18357584
17:36:30 4167 8192000000 10947294000 11366248448 1986020976 19.512 100 71 140 0 2030779040 24864624 19893440
17:36:41 7904 8192000000 10926004992 11349704704 1969156656 19.379 99 64 127 0 2015049392 26391712 19501024
17:36:57 12671 8192000000 10937910272 11370467328 1984841440 19.503 100 61 122 4 2030068816 27314656 17912720
17:37:19 9344 8192000000 10953683824 11378249728 1990504656 19.548 100 64 128 0 2037148640 27707536 18936448
17:37:36 9780 8192000000 10954894576 11379732480 1974927088 19.425 99 57 114 0 2020645344 28544960 17173296
17:38:00 3194 8192000000 10942533200 11351441408 1970645152 19.391 99 83 161 1 2023050832 28732080 23673600
17:38:10 6362 8192000000 10955127200 11378696192 1993493008 19.571 100 77 151 2 2042361328 26241488 22626832
17:38:23 1300 8192000000 10941054384 11356397568 1976613408 19.438 99 86 173 2 2026631728 26327984 23690336
17:38:31 2740 8192000000 10956753392 11375456256 1994710672 19.581 100 73 146 0 2043713376 28180496 20822208
17:38:41 4672 8192000000 10963559872 11381481472 1994054464 19.576 100 72 141 1 2043257376 28996880 20206032
17:38:52 3776 8192000000 10958916704 11370823680 1986671872 19.517 100 80 159 2 2037655312 27777168 23206272
17:39:03 2001 8192000000 10964472704 11378176000 1992467600 19.563 100 83 166 3 2046365456 29559200 24338656
17:39:12 6025 8192000000 10949615552 11364478976 1963415472 19.333 99 70 140 2 2014727104 30574896 20736736
17:39:26 11492 8192000000 10945592080 11373244416 1985115424 19.505 100 78 154 0 2037305712 29400256 22790032
17:39:46 3119 8192000000 10960550336 11374149632 1986505072 19.516 100 73 145 2 2037372320 29209808 21657440
17:39:57 4617 8192000000 10939082560 11369418752 1986811680 19.519 100 72 145 4 2038206656 29144688 22250288
17:40:13 5804 8192000000 10943127504 11365662720 1973327520 19.412 99 70 139 1 2025429440 31024608 21077312
17:40:27 3409 8192000000 10959315376 11383402496 1973461616 19.413 99 64 125 0 2027878944 35821056 18596272
17:40:38 2142 8192000000 10958554832 11379167232 1969061200 19.378 99 80 160 2 2031545536 37342000 25142336
17:40:47 3022 8192000000 10978330032 11388428288 1989552288 19.540 100 86 168 1 2054129616 39575072 25002256
17:40:56 3322 8192000000 10947984384 11365298176 1953784368 19.257 98 88 174 1 2021107920 40581456 26742096
17:41:07 1424 8192000000 10972859728 11384442880 1983674144 19.494 100 85 171 1 2051399040 42022528 25702368
17:41:15 3687 8192000000 10962963088 11380973568 1980400448 19.468 100 86 172 0 2046862832 38994576 27467808
17:41:26 1756 8192000000 10965954640 11382689792 1979351520 19.460 100 78 155 1 2044134288 40780656 24002112
17:41:35 2442 8192000000 10952087504 11366068224 1965154880 19.347 100 84 169 1 2032193552 41447136 25591536
17:41:45 6065 8192000000 10948259952 11370848256 1972331952 19.404 100 81 162 2 2036771872 38512160 25927760
17:42:01 3780 8192000000 10920530160 11342594048 1929480912 19.063 99 66 133 2 1992470912 41929152 21060848
17:42:14 2332 8192000000 10921552528 11337539584 1938387216 19.134 99 75 153 2 2004351616 43084208 22880192
17:42:22 2638 8192000000 10934439920 11350102016 1937014208 19.123 99 73 146 0 2004636992 45211856 22410928
17:42:31 6509 8192000000 10904791872 11333296128 1931191344 19.076 99 56 112 1 1989238112 40913984 17132784
17:42:44 7886 8192000000 10916298208 11346546688 1942819488 19.169 100 48 96 1 1999568096 41215008 15533600
17:43:05 7991 8192000000 10932587216 11359780864 1949380080 19.222 100 61 120 8 2011272784 42224832 19667872
17:43:23 4328 8192000000 10930724752 11344834560 1923977648 19.019 98 78 150 1 1993448768 44653872 24817248
17:43:35 2110 8192000000 10955173696 11370549248 1960491264 19.310 100 84 166 2 2033270912 47267888 25511760
17:43:44 2421 8192000000 10953801136 11359121408 1953195280 19.252 100 92 183 3 2030637984 48564432 28878272
17:43:53 5099 8192000000 10935477248 11362881536 1953870160 19.257 100 67 132 1 2023613808 48867248 20876400
17:44:17 3474 8192000000 10957626688 11372572672 1965249488 19.348 100 73 146 2 2029451872 41165216 23037168
17:44:30 2273 8192000000 10944565344 11356254208 1937228320 19.125 99 76 150 0 2004311776 43794448 23289008
17:44:41 3532 8192000000 10906209584 11330441216 1919674640 18.984 99 64 128 2 1983677520 43905232 20097648
17:44:55 2104 8192000000 10915502912 11325857792 1924841632 19.026 100 77 152 1 1995292768 44826624 25624512
17:45:06 3460 8192000000 10922038800 11335294976 1928982176 19.059 100 74 148 1 1998608832 46346080 23280576
17:45:16 3640 8192000000 10929022336 11346665472 1940402720 19.150 100 70 140 1 2009497472 47479872 21614880
17:45:30 2879 8192000000 10948464064 11354370048 1948213504 19.212 100 67 130 2 2009306528 41186944 19906080
17:45:40 6672 8192000000 10950338128 11364597760 1957589840 19.287 100 79 157 1 2026082048 44221568 24270640
17:45:54 2114 8192000000 10938768784 11344408576 1937733360 19.129 99 85 170 2 2008184480 45148640 25302480
17:46:03 2482 8192000000 10941499392 11354738688 1950875488 19.233 100 83 164 0 2022435792 46039536 25520768
17:46:14 5453 8192000000 10923898656 11356131328 1947717312 19.208 100 66 132 0 2014306816 45974528 20614976
17:46:28 17731 8192000000 10890394992 11326423040 1901694160 18.840 98 40 80 1 1954794960 40134400 12966400
17:46:54 9106 8192000000 10900411568 11347693568 1943061408 19.171 100 53 106 1 1999804464 39788080 16954976
17:47:12 6623 8192000000 10919407616 11343724544 1946765584 19.201 100 52 104 0 1996327504 32720800 16841120
17:47:29 8656 8192000000 10920248944 11361296384 1960426912 19.309 100 47 94 3 2009405392 34583936 14394544
17:47:45 16688 8192000000 10920871872 11367481344 1963481216 19.334 100 37 74 0 2009384400 33757760 12145424
17:48:12 7376 8192000000 10946686512 11384664064 1977280096 19.443 100 43 86 2 2028699920 37622224 13797600
17:48:29 8901 8192000000 10940748624 11381473280 1972302016 19.404 100 37 74 1 2023241584 39119296 11820272
17:48:50 5977 8192000000 10946573712 11384934400 1972985200 19.409 100 45 90 1 2028137024 40647408 14504416
17:49:04 11846 8192000000 10940537312 11390488576 1976761760 19.439 100 42 84 0 2033483744 42512208 14209776
17:49:28 14782 8192000000 10942974368 11393773568 1976886784 19.440 100 29 57 2 2026363104 39959264 9517056
17:49:49 11408 8192000000 10948092144 11395805184 1978795872 19.455 100 32 64 1 2030510288 41096368 10618048
17:50:15 19963 8192000000 10932462448 11381383168 1951928240 19.242 99 27 54 2 2003391056 42345376 9117440
17:50:42 21261 8192000000 10925139120 11377152000 1940864480 19.154 99 29 58 1 1998470000 47481776 10123744
17:51:12 26567 8192000000 10927375536 11370049536 1938325840 19.133 99 35 70 4 1998490896 48170624 11994432
17:51:44 17466 8192000000 10923068704 11365175296 1915130720 18.948 98 32 64 0 1968236896 42532992 10573184
17:52:21 20164 8192000000 10930682304 11377995776 1950085664 19.227 100 26 52 0 2008322992 49503440 8733888
17:53:09 21144 8192000000 10907585872 11352940544 1903435728 18.854 98 36 71 1 1965937312 49466912 13034672
17:54:04 20253 8192000000 10891212592 11338690560 1886438336 18.717 98 22 44 0 1947475360 52512480 8524544
17:54:31 12059 8192000000 10905735536 11350360064 1908709104 18.896 100 25 49 2 1981090720 62761584 9620032
17:54:55 15429 8192000000 10910359856 11360538624 1920685072 18.992 100 26 52 1 1993582288 62793504 10103712
17:56:00 87471 8192000000 10862930608 11300167680 1877630272 18.646 97 40 81 2 1899258896 10278448 11350176
17:57:34 4323 8192000000 10880114064 11310858240 1932724080 19.089 100 57 110 1 1956957120 7571872 16661168
17:57:47 92413 8192000000 10898373744 11346317312 1930197088 19.068 99 36 71 2 1949117360 9681920 9238352
17:59:31 103266 8192000000 10885818368 11358015488 1940173424 19.148 99 24 48 0 1962293888 15282512 6837952
18:01:21 35212 8192000000 10865939600 11351457792 1927973760 19.051 99 14 29 0 1955021248 22868736 4178752
18:02:03 114373 8192000000 10891708432 11354128384 1958996608 19.298 100 9 18 0 1970968416 9931536 2040272
18:04:04 103529 8192000000 10917808576 11384258560 1982261712 19.483 100 18 34 2 2001493552 14350896 4880944
18:06:03 70626 8192000000 10925785296 11397074944 1989323968 19.538 100 16 32 2 2015558288 21609440 4624880
18:07:41 132323 8192000000 10903105328 11366764544 1890085136 18.746 95 26 51 0 1907165776 9158992 7921648
18:10:08 75660 8192000000 10891161504 11338035200 1894691312 18.784 96 21 42 1 1911717120 10785840 6239968
18:11:34 28895 8192000000 10917251424 11366535168 1976005520 19.433 100 47 94 3 2003494320 13731808 13756992
18:12:24 52563 8192000000 10899130656 11363196928 1964792128 19.344 100 18 36 1 1986477952 16053072 5632752
18:13:24 54631 8192000000 10918103168 11357773824 1935419664 19.110 98 22 44 0 1957312720 14746704 7146352
18:14:50 53243 8192000000 10891784976 11370012672 1965880528 19.353 100 12 24 1 1985793872 16028128 3885216
18:16:28 88588 8192000000 10905330944 11377205248 1983979536 19.496 100 12 24 0 1996111952 8856656 3275760
18:18:07 46765 8192000000 10901749440 11382235136 1971268432 19.396 99 18 36 2 1987143888 10277904 5597552
18:19:04 68446 8192000000 10900591744 11385925632 1945110320 19.188 98 5 10 0 1957508368 11349824 1048224
18:20:18 41033 8192000000 10905390976 11352584192 1929474288 19.063 98 26 52 1 1954285632 16839552 7971792
18:21:06 52859 8192000000 10895189248 11362902016 1947838304 19.209 99 21 42 0 1971878608 19231536 4808768
18:22:05 48847 8192000000 10873554224 11337629696 1934125984 19.100 98 11 22 0 1948534992 11206960 3202048
18:23:01 48993 8192000000 10898879488 11370450944 1974804528 19.424 100 19 37 1 1990916464 10730720 5381216
18:24:03 48524 8192000000 10900620560 11367522304 1941445056 19.158 98 20 40 1 1958232784 10810848 5976880
18:24:58 69314 8192000000 10920815136 11392057344 1957428976 19.286 99 18 36 1 1980594224 18318448 4846800
18:26:17 88071 8192000000 10923938464 11376254976 1930327504 19.069 97 27 54 1 1947205840 9368400 7509936
18:27:51 34521 8192000000 10928717616 11386556416 1990517088 19.548 100 28 56 2 2007235520 9476400 7242032
18:28:43 122401 8192000000 10930781136 11398103040 1886646448 18.719 95 8 16 1 1899996096 11434128 1915520
18:30:52 88187 8192000000 10910039584 11385516032 1910536832 18.911 96 9 18 0 1931501584 18633744 2331008
18:32:37 69099 8192000000 10931379024 11363549184 1935484496 19.111 98 28 56 1 1956030016 12057744 8487776
18:33:52 9301 8192000000 10916307216 11357483008 1934750640 19.105 98 50 100 0 1958125728 9795520 13579568
18:34:08 32205 8192000000 10877136048 11343519744 1905843328 18.873 97 31 62 2 1929788208 14852608 9092272
18:35:56 127004 8192000000 10888108736 11345494016 1885422368 18.709 96 33 66 1 1903560528 8819744 9318416
18:38:27 73656 8192000000 10881459872 11344867328 1909833120 18.905 98 13 26 2 1929053104 15331728 3888256
18:40:00 10747 8192000000 10856556368 11314311168 1897368656 18.805 97 38 78 4 1913328480 4689136 11270688
18:40:17 39410 8192000000 10848166144 11316039680 1911486272 18.919 98 14 29 1 1924218544 9339488 3392784
18:41:33 49479 8192000000 10846743680 11317161984 1888769344 18.736 97 22 45 1 1905644736 10412528 6462864
18:42:30 59764 8192000000 10834324336 11296845824 1891844592 18.761 98 17 34 2 1906698048 9837952 5015504
18:43:38 56896 8192000000 10835044912 11300986880 1893470320 18.774 98 20 40 3 1911632416 11502608 6659488
18:44:41 62793 8192000000 10856668784 11333169152 1927596832 19.048 100 15 30 0 1945622128 13192320 4832976
18:46:08 46011 8192000000 10813160336 11282382848 1842644208 18.362 95 19 38 1 1860616624 13356320 4616096
18:47:08 42827 8192000000 10820969360 11298459648 1851962160 18.438 97 5 10 1 1862249328 8856672 1430496
18:47:57 51377 8192000000 10840843328 11308929024 1865597200 18.549 97 19 38 0 1885530704 14766432 5167072
18:49:00 21592 8192000000 10854844128 11317841920 1920909984 18.994 100 21 42 2 1941642160 14699872 6032304
18:49:31 52519 8192000000 10858737072 11323744256 1893551664 18.774 98 15 30 0 1919712048 21494048 4666336
18:50:37 62233 8192000000 10877420624 11343171584 1921758048 19.001 99 12 23 0 1943434096 17790336 3885712
18:51:46 44331 8192000000 10896404000 11347595264 1932716832 19.089 99 26 52 0 1954766256 13761856 8287568
18:52:37 43546 8192000000 10892322224 11360063488 1940574160 19.151 99 22 44 0 1963167376 16260016 6333200
18:53:46 58341 8192000000 10892283856 11358113792 1957486752 19.286 100 21 42 1 1981187552 17437968 6262832
18:54:51 30941 8192000000 10881994960 11341123584 1934235504 19.101 99 37 74 4 1957649184 13126224 10287456
18:55:32 40047 8192000000 10870067472 11332665344 1853452848 18.450 95 25 50 2 1872569440 11659968 7456624
18:56:21 33720 8192000000 10863540672 11315040256 1881894816 18.680 97 44 86 1 1904930688 11282224 11753648
18:57:15 30589 8192000000 10890399488 11346632704 1947935376 19.210 100 32 63 1 1970391360 13649776 8806208
18:57:54 23307 8192000000 10907965376 11354738688 1957621744 19.287 100 25 50 1 1976817840 12708032 6488064
18:58:31 123702 8192000000 10875830896 11339366400 1889845872 18.745 96 16 30 2 1907064848 12633024 4585952
19:00:46 81468 8192000000 10891929728 11357589504 1945598848 19.191 99 30 60 2 1963708304 9540224 8569232
19:02:22 68070 8192000000 10881801424 11371642880 1946262000 19.197 99 7 14 0 1956421744 8016672 2143072
19:03:44 49381 8192000000 10874480240 11365273600 1946537360 19.199 99 3 6 0 1954905696 7643184 725152
19:04:39 63112 8192000000 10876407504 11349708800 1904104144 18.859 97 10 20 1 1914499952 7900416 2495392
19:05:56 71093 8192000000 10902301984 11362959360 1917990800 18.971 97 20 40 0 1938591088 15231760 5368528
19:07:13 40081 8192000000 10907587408 11383312384 1961782704 19.320 100 24 47 1 1983978224 15782208 6413312
19:08:15 53578 8192000000 10912397872 11370434560 1922384160 19.006 97 25 50 1 1947258032 17608272 7265600
19:09:19 52703 8192000000 10905043936 11389263872 1968515712 19.374 100 26 52 1 1997719552 21417360 7786480
19:10:20 77234 8192000000 10914561232 11365838848 1948368736 19.213 99 17 35 1 1969010000 16103152 4538112
19:11:46 27174 8192000000 10900416384 11362848768 1967775312 19.368 100 25 50 0 1982689760 8395056 6519392
19:12:24 47848 8192000000 10909520704 11373338624 1951653408 19.240 99 25 50 0 1974338144 16365024 6319712
19:13:24 56130 8192000000 10870002128 11346153472 1882339936 18.684 96 5 10 0 1895507280 11733008 1434336
19:14:26 40027 8192000000 10894459264 11342675968 1921421392 18.998 98 28 56 1 1938649552 9468864 7759296
19:15:18 53449 8192000000 10887005136 11357974528 1897870032 18.809 97 29 58 1 1919658848 13138096 8650720
19:16:18 108567 8192000000 10875009264 11342741504 1913425376 18.934 98 14 28 0 1934963696 18258944 3279376
19:18:15 38856 8192000000 10864453056 11305259008 1903386736 18.854 98 28 56 1 1919638480 8555280 7696464
19:19:20 136581 8192000000 10877653696 11344424960 1892790144 18.768 97 25 50 0 1910958352 10604496 7563712
19:21:43 37891 8192000000 10901350304 11354550272 1948257792 19.213 99 50 100 2 1975482080 13005728 14218560
19:22:28 30064 8192000000 10900357680 11359326208 1964691360 19.343 100 34 68 1 1986933920 12476960 9765600
19:23:04 36335 8192000000 10879432816 11359621120 1929544624 19.063 98 33 66 0 1954240560 15698512 8997424
19:23:53 69034 8192000000 10857179408 11338657792 1923473360 19.015 99 7 14 0 1937461568 12100624 1887584
19:25:25 41220 8192000000 10868730480 11331276800 1929117616 19.060 99 22 44 1 1941981520 6325632 6538272
19:26:12 56815 8192000000 10481942320 10913701888 1507758928 15.544 77 12 24 0 1521111888 9817808 3535152

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-11-2020 19:30:01 to 19-11-2020 19:30:32.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-11-2020 19:30:32 to 19-11-2020 19:30:34.

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          238871
MON$OLDEST_ACTIVE               239437
MON$OLDEST_SNAPSHOT             239437
MON$NEXT_TRANSACTION            239437
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                       2028768
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:87: 
:88: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:46 2020
:89:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:90: 
:91: 
:92: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:47 2020
:93:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:94: 
:95: 
:96: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:48 2020
:97:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:98: 
:99: 
:100: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:48 2020
:101:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:102: 
:103: 
:104: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:48 2020
:105:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:106: 
:107: 
:108: mscs-test-161.budzdorov.ru    Thu Nov 19 19:27:48 2020
:109:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:110: 
--- end of diff output ---

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

19.11.20 19:30:35. 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
2020-11-19 19:30:38 No severe PSQL-related problems occured
19.11.20 19:30:39. End of report.