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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-02 01:27:09
DTS_END                         2021-01-02 01:27:09.8420
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/54992
TRN_ID                          234850
ATT_ID                          691
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: 9211.70 23333 1105404
customer order: creation 168.19 415 20183
customer order: refuse 13.65 403 1638
order to supplier: creation 43.57 1358 5228
order to supplier: removal 3.73 100086 447
invoice (draft): creation 43.71 3356 5245
invoice (draft): removal 54.57 810 6548
invoice accept: apply 39.58 18765 4749
invoice accept: cancel 49.53 817 5944
customer reserve: creation 3671.09 183 440531
customer reserve: removal 4834.55 60 580146
realization accept: apply 80.40 206 9648
realization accept: cancel 85.71 117 10285
payment from customer: creation 56.37 131 6764
payment from customer: removal 5.70 132 684
payment to supplier: creation 46.81 150 5617
payment to supplier: removal 3.21 95 385
service: total inventory turnovers 4.31 1334 517
service: total monetary turnovers 6.07 55 728
service: aggregate perf. data 0.94 17812 113
service: refresh index statistics 0.03 320369 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-01-2021 01:28:31 to 02-01-2021 01:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4740
TEST_TIME 2 3043
TEST_TIME 3 3505
TEST_TIME 4 3149
TEST_TIME 5 3248
TEST_TIME 6 3600
TEST_TIME 7 4084
TEST_TIME 8 4638
TEST_TIME 9 4567
TEST_TIME 10 5043
TEST_TIME 11 5172
TEST_TIME 12 5941
TEST_TIME 13 6290
TEST_TIME 14 6240
TEST_TIME 15 6774
TEST_TIME 16 6872
TEST_TIME 17 7056
TEST_TIME 18 7117
TEST_TIME 19 7732
TEST_TIME 20 8309
TEST_TIME 21 8472
TEST_TIME 22 8501
TEST_TIME 23 9005
TEST_TIME 24 9220
TEST_TIME 25 9791
TEST_TIME 26 10830
TEST_TIME 27 10683
TEST_TIME 28 10918
TEST_TIME 29 10850
TEST_TIME 30 10646
TEST_TIME 31 10500
TEST_TIME 32 10528
TEST_TIME 33 10410
TEST_TIME 34 10125
TEST_TIME 35 10296
TEST_TIME 36 10205
TEST_TIME 37 9973
TEST_TIME 38 9959
TEST_TIME 39 9853
TEST_TIME 40 9813
TEST_TIME 41 9897
TEST_TIME 42 9868
TEST_TIME 43 9838
TEST_TIME 44 9714
TEST_TIME 45 9832
TEST_TIME 46 9758
TEST_TIME 47 9687
TEST_TIME 48 9707
TEST_TIME 49 9642
TEST_TIME 50 9621
TEST_TIME 51 9629
TEST_TIME 52 9687
TEST_TIME 53 9726
TEST_TIME 54 9772
TEST_TIME 55 9666
TEST_TIME 56 9760
TEST_TIME 57 9955
TEST_TIME 58 9886
TEST_TIME 59 9804
TEST_TIME 60 9824
TEST_TIME 61 9818
TEST_TIME 62 9707
TEST_TIME 63 9658
TEST_TIME 64 9605
TEST_TIME 65 9610
TEST_TIME 66 9530
TEST_TIME 67 9509
TEST_TIME 68 9454
TEST_TIME 69 9387
TEST_TIME 70 9319
TEST_TIME 71 9392
TEST_TIME 72 9341
TEST_TIME 73 9341
TEST_TIME 74 9481
TEST_TIME 75 9503
TEST_TIME 76 9534
TEST_TIME 77 9599
TEST_TIME 78 9568
TEST_TIME 79 9526
TEST_TIME 80 9660
TEST_TIME 81 9602
TEST_TIME 82 9665
TEST_TIME 83 9706
TEST_TIME 84 9655
TEST_TIME 85 9582
TEST_TIME 86 9574
TEST_TIME 87 9521
TEST_TIME 88 9535
TEST_TIME 89 9494
TEST_TIME 90 9475
TEST_TIME 91 9459
TEST_TIME 92 9429
TEST_TIME 93 9370
TEST_TIME 94 9428
TEST_TIME 95 9455
TEST_TIME 96 9432
TEST_TIME 97 9428
TEST_TIME 98 9384
TEST_TIME 99 9463
TEST_TIME 100 9470
TEST_TIME 101 9425
TEST_TIME 102 9467
TEST_TIME 103 9501
TEST_TIME 104 9608
TEST_TIME 105 9614
TEST_TIME 106 9619
TEST_TIME 107 9590
TEST_TIME 108 9527
TEST_TIME 109 9481
TEST_TIME 110 9438
TEST_TIME 111 9435
TEST_TIME 112 9402
TEST_TIME 113 9364
TEST_TIME 114 9322
TEST_TIME 115 9334
TEST_TIME 116 9294
TEST_TIME 117 9285
TEST_TIME 118 9270
TEST_TIME 119 9266
TEST_TIME 120 9212

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-01-2021 01:28:34 to 02-01-2021 01:28:38.

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 1514940 1514940 0 0.00 0 34035 6 0 0
doc_list_biud 1514939 1514939 0 0.00 0 63631 29 0 0
sp_add_invoice_to_stock 4862 4749 113 2.32 45 215167 18765 0 113
sp_cancel_adding_invoice 5944 5944 0 0.00 5 92932 818 0 0
sp_cancel_client_order 1638 1638 0 0.00 4 28844 404 0 0
sp_cancel_customer_reserve 580146 580146 0 0.00 1 63635 61 0 0
sp_cancel_pay_from_customer 684 684 0 0.00 3 17558 132 0 0
sp_cancel_pay_to_supplier 385 385 0 0.00 3 7522 95 0 0
sp_cancel_supplier_invoice 6559 6548 11 0.16 1 33988 811 0 11
sp_cancel_supplier_order 447 447 0 0.00 9 1131463 100087 0 0
sp_cancel_write_off 10285 10285 0 0.00 1 29886 117 0 0
sp_client_order 20183 20183 0 0.00 3 33078 416 0 0
sp_customer_reserve 440531 440531 0 0.00 0 122494 184 0 0
sp_fill_shopping_cart 30645 30645 0 0.00 1 17359 34 0 0
sp_fill_shopping_cart_clo_res 440526 440526 0 0.00 0 19442 16 0 0
sp_get_clo_for_invoice 4744 4744 0 0.00 0 28223 355 0 0
sp_kill_cost_storno 17298 17298 0 0.00 0 19120 61 0 0
sp_kill_qstorno_ret_qs2qd 1177572 1177572 0 0.00 0 63626 33 0 0
sp_kill_qty_storno 619400 619400 0 0.00 0 63631 71 0 0
sp_lock_selected_doc 20059 20059 0 0.00 0 8557 9 0 0
sp_make_cost_storno 26773 26773 0 0.00 0 23528 58 0 0
sp_multiply_rows_for_pdistr 26773 26773 0 0.00 0 18167 35 0 0
sp_multiply_rows_for_qdistr 20183 20183 0 0.00 0 12802 184 0 0
sp_pay_from_customer 6764 6764 0 0.00 4 21136 131 0 0
sp_pay_to_supplier 5617 5617 0 0.00 5 18391 150 0 0
sp_payment_common 12381 12381 0 0.00 1 19529 33 0 0
sp_qd_handle_on_cancel_clo 1638 1638 0 0.00 0 28838 356 0 0
sp_qd_handle_on_invoice_upd_sts 10688 10688 0 0.00 0 26618 327 0 0
sp_qd_handle_on_reserve_upd_sts 9648 9648 0 0.00 0 24106 69 0 0
sp_reserve_write_off 9648 9648 0 0.00 7 24115 207 0 0
sp_supplier_invoice 5245 5245 0 0.00 5 111947 3357 0 0
sp_supplier_order 5228 5228 0 0.00 5 85286 1359 0 0
srv_aggregate_perf_data 113 113 0 0.00 2351 126217 17813 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1200 211504 34873 0 0
srv_find_qd_qs_mism 1060452 1060452 0 0.00 0 24457 5 0 0
srv_make_invnt_saldo 517 517 0 0.00 27 84533 1335 0 0
srv_make_money_saldo 728 728 0 0.00 1 21290 56 0 0
srv_recalc_idx_stat 4 4 0 0.00 211174 392351 320369 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4749 4749 0 0.00 0 32254 190 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 1 2412 85 0 0
t$perf-norm:sp_cancel_client_order 1638 1638 0 0.00 0 8800 22 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 11980 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 684 684 0 0.00 0 33590 64 0 0
t$perf-norm:sp_cancel_pay_to_supplier 385 385 0 0.00 0 106 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 2081 19 0 0
t$perf-norm:sp_cancel_supplier_order 447 447 0 0.00 0 23166 1558 0 0
t$perf-norm:sp_cancel_write_off 1008 1008 0 0.00 0 1018 5 0 0
t$perf-norm:sp_client_order 20183 20183 0 0.00 0 37416 24 0 0
t$perf-norm:sp_customer_reserve 1016 1016 0 0.00 0 10816 20 0 0
t$perf-norm:sp_pay_from_customer 6764 6764 0 0.00 0 38138 21 0 0
t$perf-norm:sp_pay_to_supplier 5617 5617 0 0.00 0 21359 18 0 0
t$perf-norm:sp_reserve_write_off 9648 9648 0 0.00 0 34770 19 0 0
t$perf-norm:sp_supplier_invoice 5246 5246 0 0.00 0 32502 35 0 0
t$perf-norm:sp_supplier_order 5228 5228 0 0.00 0 37796 23 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 414 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 777 12 0 0
t$perf-norm:srv_make_invnt_saldo 517 517 0 0.00 0 1163 27 0 0
t$perf-norm:srv_make_money_saldo 728 728 0 0.00 0 2122 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9714 9488 226 2.32 0 8351 18 0 226
v_all_customers 36948 36948 0 0.00 0 163 1 0 0
v_all_suppliers 29230 29230 0 0.00 0 163 1 0 0
v_all_wares 40366 40366 0 0.00 0 62 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 1774 16 0 0
v_cancel_client_order 3276 3276 0 0.00 0 3391 8 0 0
v_cancel_customer_prepayment 1368 1368 0 0.00 0 17283 22 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 2035 7 0 0
v_cancel_payment_to_supplier 770 770 0 0.00 0 639 4 0 0
v_cancel_supplier_invoice 828 806 22 2.65 0 3086 19 0 22
v_cancel_supplier_order 894 894 0 0.00 0 1440 5 0 0
v_cancel_write_off 2016 2016 0 0.00 0 3908 15 0 0
v_max_id_clo_ord 5227 5227 0 0.00 0 910 1 0 0
v_max_id_clo_res 1016 1016 0 0.00 0 5426 27 0 0
v_max_id_ord_sup 5235 5235 0 0.00 0 5688 4 0 0
v_max_non_paid_invoice 1464 1464 0 0.00 0 388 2 0 0
v_max_non_paid_realizn 3468 3468 0 0.00 0 1793 4 0 0
v_min_id_clo_ord 5227 5227 0 0.00 0 2484 8 0 0
v_min_id_clo_res 1016 1016 0 0.00 0 4327 11 0 0
v_min_id_ord_sup 5235 5235 0 0.00 0 7279 4 0 0
v_min_non_paid_invoice 5617 5617 0 0.00 0 18280 22 0 0
v_min_non_paid_realizn 6764 6764 0 0.00 0 19526 21 0 0
v_our_firm 10010 10010 0 0.00 0 163 1 0 0
v_reserve_write_off 19296 19296 0 0.00 0 7657 7 0 0
x_lock_depdocs_on_canc_invoice 12089 12089 0 0.00 0 16538 135 0 0
x_lock_depdocs_on_canc_sup_ord 447 447 0 0.00 0 12576 373 0 0
x_make_qstorno_1000_1200 5228 5228 0 0.00 1 84780 1279 0 0
x_make_qstorno_1200_2000 5245 5245 0 0.00 2 111907 3239 0 0
x_make_qstorno_2100_3300 440531 440531 0 0.00 0 122488 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-01-2021 01:28:39 to 02-01-2021 01:28:43.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:13 3 8192000000 8802537552 8814166016 8586240 0.104 2 1 2 0 8714688 58672 69776
22:57:20 16412 8192000000 10260135360 10564911104 857922128 9.479 67 55 110 0 878462320 2286768 18253424
22:57:48 34717 8192000000 10339368464 10653843456 1386050880 14.471 100 88 176 0 1420304720 4989184 29264656
22:58:36 32261 8192000000 10392010672 10714411008 1423678144 14.805 100 87 174 0 1459717888 7023712 29016032
22:59:17 13713 8192000000 10389617200 10716770304 1449903664 15.037 100 92 184 1 1488664240 8310816 30449760
22:59:40 22126 8192000000 10415222784 10743525376 1464461888 15.165 100 91 182 0 1503177568 8688528 30027152
23:00:13 16736 8192000000 10424016368 10757169152 1479373904 15.296 100 88 176 0 1517181760 9304880 28502976
23:00:41 22147 8192000000 10444687184 10783449088 1501709024 15.491 100 84 168 0 1538321056 9647072 26964960
23:01:13 16027 8192000000 10470984800 10814087168 1527665808 15.717 100 81 162 0 1563721760 10210112 25845840
23:01:40 19447 8192000000 10490947728 10841333760 1554662944 15.950 100 83 163 4 1591343952 10856416 25824592
23:02:08 16592 8192000000 10538760976 10891051008 1590181488 16.255 100 75 150 1 1624730016 10951520 23597008
23:02:34 13217 8192000000 10560253488 10917928960 1617238064 16.486 100 83 166 1 1654304880 11623520 25443296
23:02:55 13857 8192000000 10575497376 10940063744 1634342800 16.632 100 75 146 1 1668943664 11638624 22962240
23:03:16 11635 8192000000 10596053488 10961850368 1654916432 16.806 100 82 165 1 1691343824 12179600 24247792
23:03:35 5800 8192000000 10607825376 10974048256 1668348944 16.919 100 77 154 2 1703604416 12634288 22621184
23:03:49 10586 8192000000 10631993248 11003400192 1690671136 17.107 100 78 156 1 1725859632 12869728 22318768
23:04:07 6850 8192000000 10640591520 11016536064 1705979104 17.235 100 80 155 1 1742393872 13257392 23157376
23:04:21 8325 8192000000 10661319104 11033391104 1717952336 17.335 100 77 154 0 1753690128 13744272 21993520
23:04:38 5067 8192000000 10669676688 11042914304 1727994560 17.419 100 81 161 0 1764051216 13000768 23055888
23:04:51 6954 8192000000 10679661856 11059634176 1739630032 17.516 100 66 132 0 1769915872 11723120 18562720
23:05:06 6407 8192000000 10695319552 11075452928 1758721584 17.674 100 80 160 2 1794487808 13094976 22671248
23:05:19 5388 8192000000 10700783200 11085824000 1768667488 17.756 100 73 146 1 1801528128 12756736 20103904
23:05:31 4392 8192000000 10725997904 11105972224 1780638112 17.855 100 90 181 1 1817988080 12636288 24713680
23:05:42 4362 8192000000 10722806400 11111006208 1790523856 17.936 100 82 164 1 1826751824 13056448 23171520
23:05:53 3456 8192000000 10731873424 11115487232 1795744832 17.979 100 82 161 5 1831097152 12876656 22475664
23:06:03 3214 8192000000 10749252336 11129565184 1805106720 18.056 100 84 168 1 1841926368 12824592 23995056
23:06:13 2647 8192000000 10751190480 11137736704 1810358112 18.099 100 85 167 1 1847444256 13283376 23802768
23:06:22 8886 8192000000 10746203440 11137601536 1809392448 18.091 100 71 138 2 1842711232 13785744 19533040
23:06:39 3333 8192000000 10765313872 11159801856 1831755600 18.274 100 79 158 3 1866454272 12591520 22107152
23:06:49 2378 8192000000 10790149312 11174793216 1836452496 18.312 100 86 172 2 1873758384 12671328 24634560
23:06:57 2330 8192000000 10781178848 11168124928 1840518368 18.345 100 85 169 3 1877488448 13075584 23894496
23:07:06 2635 8192000000 10797206944 11181486080 1848054624 18.406 100 93 187 2 1888765392 14261008 26449760
23:07:15 2270 8192000000 10793468544 11179982848 1849067184 18.415 100 85 171 0 1887851280 14434944 24349152
23:07:24 1802 8192000000 10796905440 11183632384 1855117200 18.464 100 88 173 1 1893250448 13310992 24822256
23:07:33 2587 8192000000 10802370064 11196841984 1862675776 18.525 100 90 181 1 1901460144 13432608 25351760
23:07:42 2310 8192000000 10810321136 11198668800 1867347456 18.563 100 93 186 2 1908025968 14563536 26114976
23:07:50 2623 8192000000 10821358128 11209428992 1873205536 18.610 100 95 191 0 1913969168 15123888 25639744
23:08:00 1717 8192000000 10822392608 11210452992 1873269888 18.611 100 95 190 1 1916169520 15955296 26944336
23:08:08 1408 8192000000 10822853888 11214696448 1875844176 18.632 100 85 170 2 1914866320 14685888 24336256
23:08:16 1477 8192000000 10818323792 11209949184 1875683264 18.630 100 92 184 0 1915551104 14173248 25694592
23:08:24 1433 8192000000 10813241984 11206701056 1878212240 18.651 100 91 184 0 1917000976 13296928 25491808
23:08:32 1601 8192000000 10823275616 11214233600 1877525568 18.645 100 87 172 0 1914604496 12676992 24401936
23:08:40 1226 8192000000 10828694464 11218575360 1880435712 18.669 100 93 187 0 1920338384 13383856 26518816
23:08:48 35343 8192000000 10810456864 11220381696 1874935680 18.624 100 62 124 0 1902520000 10486944 17097376
23:09:30 4051 8192000000 10788538112 11213135872 1877676672 18.646 100 41 82 1 1898795504 9085440 12033392
23:09:44 4930 8192000000 10797247328 11214643200 1877096704 18.642 100 31 62 1 1892747184 6771120 8879360
23:09:56 7333 8192000000 10787058672 11217080320 1880160960 18.666 100 26 52 0 1894729136 6997488 7570688
23:10:11 13398 8192000000 10791721328 11221479424 1877605840 18.646 100 15 29 1 1887216992 5792896 3818256
23:10:33 8601 8192000000 10797833072 11227394048 1883597840 18.694 100 25 47 3 1897807504 6837456 7372208
23:10:48 8475 8192000000 10800538992 11231367168 1889015920 18.738 100 23 46 0 1901979648 6090528 6873200
23:11:03 11444 8192000000 10799862112 11234951168 1888279520 18.732 100 19 38 2 1900259264 5930320 6049424
23:11:26 8906 8192000000 10797317504 11236478976 1893762656 18.776 100 19 38 0 1904547584 5619136 5165792
23:11:43 7617 8192000000 10795795120 11236016128 1893466512 18.774 100 16 32 2 1904011264 5818400 4726352
23:11:57 6802 8192000000 10816336704 11244863488 1896289904 18.796 100 31 62 0 1915909984 10846608 8773472
23:12:10 7040 8192000000 10807377600 11239534592 1893403136 18.773 100 15 30 0 1904628224 7277312 3947776
23:12:26 13708 8192000000 10799029728 11239084032 1893468528 18.774 100 16 32 0 1903621920 5318288 4835104
23:12:47 73495 8192000000 10840189440 11259392000 1901478672 18.838 100 46 92 2 1920628960 5336432 13813856
23:14:10 6732 8192000000 10811246384 11241951232 1895383072 18.789 100 34 66 4 1910341056 6190224 8767760
23:14:25 4838 8192000000 10811912880 11249819648 1897154704 18.803 100 22 44 2 1909081360 6001056 5925600
23:14:39 5903 8192000000 10812095872 11251200000 1899880432 18.825 100 33 66 2 1916987424 8293216 8813776
23:14:52 5436 8192000000 10832536672 11258900480 1905574192 18.871 100 37 74 1 1922967856 6987968 10405696
23:15:04 6038 8192000000 10823483376 11250819072 1899125616 18.819 100 19 38 1 1910699584 6009888 5564080
23:15:17 6434 8192000000 10817816880 11257847808 1901883168 18.841 100 24 48 1 1919084384 10606416 6594800
23:15:31 4941 8192000000 10821634592 11259113472 1905885744 18.874 100 25 50 1 1919170640 6323104 6961792
23:15:43 8645 8192000000 10822097056 11260526592 1909083200 18.899 100 25 50 2 1923506352 6698080 7725072
23:15:59 8359 8192000000 10804547360 11244924928 1883149904 18.691 99 20 39 1 1894465920 5381296 5934720
23:16:20 7422 8192000000 10821935088 11259256832 1908260976 18.893 100 34 68 1 1924348320 5681536 10405808
23:16:40 12216 8192000000 10816169776 11254927360 1896813200 18.801 100 12 23 2 1909257840 9446176 2998464
23:17:00 5074 8192000000 10804609280 11236843520 1885266128 18.708 100 23 45 2 1898898896 6608976 7023792
23:17:18 21116 8192000000 10786142272 11215515648 1827356624 18.238 97 21 43 0 1839437920 5263872 6817424
23:17:46 51980 8192000000 10718496912 11141431296 1737388608 17.497 93 23 45 1 1748547072 4607584 6550880
23:18:45 10544 8192000000 10716130320 11137916928 1723156080 17.379 94 15 29 1 1732603344 5136720 4310544
23:19:01 13014 8192000000 10724052096 11147370496 1769930752 17.766 97 20 40 2 1780851312 5634832 5285728
23:19:20 9538 8192000000 10717695136 11131551744 1753712192 17.632 97 33 66 3 1767959424 4873472 9373760
23:19:36 6260 8192000000 10699848688 11122364416 1747150672 17.578 97 21 42 0 1758716864 5425120 6141072
23:19:52 6572 8192000000 10732779376 11150589952 1796673968 17.987 99 24 48 1 1809474144 5872624 6927552
23:20:05 9181 8192000000 10737474128 11140915200 1784722256 17.888 98 24 48 2 1797767664 6113360 6932048
23:20:21 6245 8192000000 10729954208 11151876096 1800290480 18.016 99 28 56 0 1815636432 6666688 8679264
23:20:36 6452 8192000000 10714686256 11123290112 1738274000 17.504 96 25 49 1 1750881584 5303328 7304256
23:20:50 14698 8192000000 10709645680 11124502528 1710291776 17.271 95 24 48 1 1723136064 4832368 8011920
23:21:16 8753 8192000000 10680098832 11095031808 1736797360 17.492 97 26 53 0 1749682016 4923024 7961632
23:21:35 9154 8192000000 10721925872 11130605568 1767349408 17.745 98 22 44 1 1779793808 5778048 6666352
23:21:54 13804 8192000000 10738711392 11152297984 1798129728 17.999 99 21 43 0 1810059696 5948000 5981968
23:22:16 15288 8192000000 10743093440 11165138944 1812041424 18.113 99 16 30 1 1821483440 5378528 4063488
23:22:43 63182 8192000000 10732881728 11158294528 1793435840 17.960 98 32 64 0 1808321952 5741872 9144240
23:23:54 6446 8192000000 10749098352 11174879232 1830576768 18.264 100 25 48 0 1842686976 6004512 6105696
23:24:08 7103 8192000000 10757921264 11178840064 1821066288 18.186 99 26 52 0 1834222688 6061632 7094768
23:24:21 5874 8192000000 10779995248 11184197632 1846456064 18.393 100 43 88 1 1865754208 6307200 12990944
23:24:36 6166 8192000000 10768062048 11185344512 1847908144 18.405 100 33 66 1 1864767680 8055664 8803872
23:24:52 7334 8192000000 10758670240 11189493760 1849525344 18.418 100 24 47 3 1862883696 6143520 7214832
23:25:06 6400 8192000000 10770311840 11199377408 1856468480 18.475 100 22 44 3 1869733664 6090880 7174304
23:25:21 9190 8192000000 10770596224 11201634304 1862677008 18.525 100 28 56 2 1876791104 5458272 8655824
23:25:36 10834 8192000000 10777370208 11205300224 1863873648 18.535 100 23 46 1 1875962720 5164560 6924512
23:25:54 11393 8192000000 10780311312 11209003008 1864631328 18.541 100 14 28 1 1874544448 5394064 4519056
23:26:12 15155 8192000000 10794719088 11216642048 1866860960 18.559 100 12 24 1 1875393424 5334416 3198048
23:26:33 8084 8192000000 10794095520 11221487616 1872691968 18.606 100 22 44 1 1884548848 5359936 6496944
23:26:48 10750 8192000000 10791603136 11220340736 1877459584 18.645 100 27 54 2 1890902464 5401504 8041376
23:27:04 10648 8192000000 10800476448 11228295168 1885080416 18.706 100 17 34 1 1894779536 5018640 4680480
23:27:22 81582 8192000000 10840539024 11271614464 1905447136 18.870 100 31 59 2 1919542672 5549984 8545552
23:28:52 36659 8192000000 10855640304 11284205568 1909902608 18.906 99 37 73 0 1929758272 10109344 9746320
23:29:39 124691 8192000000 10867629712 11306967040 1938830816 19.137 100 32 64 3 1962825072 15352528 8641728
23:32:41 14041 8192000000 10897552240 11326369792 1955214800 19.268 100 36 72 1 1983687904 17722336 10750768
23:33:03 16665 8192000000 10890146272 11316563968 1943622400 19.176 99 42 81 1 1974400560 18364176 12413984
23:33:26 8182 8192000000 10909042944 11335573504 1960070400 19.307 100 50 98 0 1995557424 20808048 14678976
23:33:42 15653 8192000000 10910761008 11341172736 1965511104 19.350 100 62 124 2 2006219456 22374848 18333504
23:34:07 2787 8192000000 10919488096 11347648512 1973530016 19.413 100 60 122 0 2013861616 22587664 17743936
23:34:17 7692 8192000000 10928735120 11354738688 1976082768 19.434 100 56 113 1 2016458896 23387264 16988864
23:34:35 7642 8192000000 10925043760 11355754496 1977609392 19.446 100 57 112 3 2018111936 23771456 16731088
23:34:54 11609 8192000000 10923161856 11354722304 1972968864 19.409 100 45 90 1 2008879392 22025824 13884704
23:35:14 24869 8192000000 10916400720 11362402304 1979212560 19.458 100 40 81 3 2014860992 23146304 12502128
23:35:47 3225 8192000000 10938580032 11367329792 1990659376 19.549 100 53 101 1 2024899216 19479136 14760704
23:35:59 4919 8192000000 10939535312 11374223360 1993137984 19.569 100 58 115 1 2031276880 21057520 17081376
23:36:15 3068 8192000000 10950485728 11379159040 1995776864 19.589 100 63 124 0 2036376096 22318464 18280768
23:36:37 10703 8192000000 10948674560 11384918016 1996550912 19.596 100 53 106 2 2037200096 25013296 15635888
23:36:56 9727 8192000000 10942949968 11385622528 1999779744 19.621 100 51 102 1 2043278336 27448848 16049744
23:37:16 3400 8192000000 10956368896 11393146880 2004897840 19.661 100 54 106 1 2048548752 27188512 16462400
23:37:26 6732 8192000000 10960485376 11395727360 2007855744 19.685 100 59 118 3 2052757552 27315760 17586048
23:37:40 6904 8192000000 10968631568 11399393280 2008161872 19.687 100 51 102 0 2051608992 27247312 16199808
23:38:04 11930 8192000000 10977236000 11414986752 2019125056 19.773 100 57 114 0 2068352912 31624080 17603776
23:38:25 11604 8192000000 10967396224 11405914112 2016971776 19.756 100 49 97 0 2066825408 34281856 15571776
23:38:49 3098 8192000000 10989503152 11417874432 2016400208 19.752 100 66 130 0 2078454928 41353744 20700976
23:39:02 2967 8192000000 10995072512 11420381184 2020520480 19.784 100 71 139 0 2077387456 35554896 21312080
23:39:12 4216 8192000000 11002954272 11427491840 2024249984 19.814 100 70 140 1 2082278448 36109200 21919264
23:39:26 3538 8192000000 11012344720 11432861696 2028173296 19.844 100 76 151 1 2089598592 38991904 22433392
23:39:37 3629 8192000000 11013579232 11437670400 2032567872 19.879 100 83 165 0 2100275248 41862400 25844976
23:39:49 4130 8192000000 11015731072 11443113984 2035048720 19.898 100 77 154 1 2099787248 40968112 23770416
23:40:03 4540 8192000000 11002793744 11435257856 2034500128 19.894 100 61 122 1 2091781792 38739680 18541984
23:40:15 5196 8192000000 11013255904 11434758144 2017003904 19.757 99 76 151 1 2078537280 38185424 23347952
23:40:27 3016 8192000000 10995425456 11430436864 2026371872 19.830 100 63 126 2 2082935824 37216736 19347216
23:40:38 6313 8192000000 10988250464 11415855104 1998666336 19.612 98 75 147 2 2059336240 37850528 22819376
23:40:51 1360 8192000000 10999797200 11421691904 2018364496 19.767 100 80 159 1 2082012672 39008016 24640160
23:40:59 2197 8192000000 11008413472 11426451456 2010896848 19.709 99 91 181 0 2079896256 40732624 28266784
23:41:09 6311 8192000000 10995424096 11421249536 2019801856 19.779 100 84 168 1 2086221008 41418496 25000656
23:41:25 1200 8192000000 11011386272 11431112704 2024714112 19.817 100 81 162 1 2094600176 43334944 26551120
23:41:37 6374 8192000000 10992725632 11422285824 2016185456 19.750 100 65 130 1 2079502544 42967920 20349168
23:41:57 8569 8192000000 10991383856 11422429184 2001804080 19.637 99 62 121 1 2065044528 44028112 19212336
23:42:15 2975 8192000000 10983277296 11405410304 2002130048 19.640 100 67 134 2 2069301184 45421552 21749584
23:42:34 3234 8192000000 10991638688 11420631040 2003136320 19.647 99 71 143 0 2063555296 38233952 22185024
23:42:44 3262 8192000000 10998900768 11418906624 2004182080 19.656 99 83 165 2 2069816160 39293968 26340112
23:42:55 5864 8192000000 10997128256 11417706496 2015720912 19.747 100 79 158 0 2081659376 41004576 24933888
23:43:09 3403 8192000000 11004839424 11425296384 2018817104 19.771 100 87 174 1 2086299008 40601376 26880528
23:43:24 3518 8192000000 10969515808 11385020416 1966444080 19.357 98 81 162 2 2034065888 42571648 25050160
23:43:36 1563 8192000000 10986105184 11405533184 1997752784 19.605 100 82 160 2 2071220112 48778928 24688400
23:43:44 2341 8192000000 10985405392 11395149824 1989060560 19.536 100 81 160 1 2059342192 44547824 25733808
23:43:53 4100 8192000000 10992616560 11405770752 1993932400 19.575 100 89 177 1 2066050672 45146064 26972208
23:44:04 3008 8192000000 10983512816 11395538944 1988501152 19.532 100 89 178 1 2061562480 45793664 27267664
23:44:15 1970 8192000000 10999792128 11411685376 2006214096 19.672 100 88 175 0 2080412736 46609840 27588800
23:44:25 2366 8192000000 10987160800 11399184384 1993899616 19.575 100 78 155 0 2064873856 46771200 24203040
23:44:36 1669 8192000000 10983326016 11396583424 1976926336 19.440 99 89 179 0 2053481632 48828576 27726720
23:44:44 1927 8192000000 10983469952 11404623872 1996647392 19.596 100 82 163 1 2070501264 46577392 27276480
23:44:56 3957 8192000000 10998799520 11413102592 2005604960 19.667 100 85 167 4 2080001456 48151792 26244704
23:45:08 4268 8192000000 10985936704 11408936960 1985422576 19.508 99 80 159 2 2060263120 49025744 25814800
23:45:20 4258 8192000000 10994015024 11411623936 1999230880 19.617 100 77 153 2 2074820768 50806736 24783152
23:45:33 2030 8192000000 10984599360 11404062720 1970235088 19.387 98 73 146 2 2044769552 50525520 24008944
23:45:44 1248 8192000000 10971989840 11391807488 1975080576 19.426 100 74 148 0 2051732480 51982144 24669760
23:45:52 2322 8192000000 10999569664 11409686528 1992300896 19.562 100 89 180 0 2074749312 54180816 28267600
23:46:05 2075 8192000000 10995932928 11412353024 1993006128 19.568 100 83 167 1 2075357040 55223952 27126960
23:46:15 4502 8192000000 10978338688 11409268736 1988048624 19.528 100 66 132 1 2061849776 52261408 21539744
23:46:27 13975 8192000000 10959240368 11407478784 1988514560 19.532 100 42 84 1 2053126880 50158512 14453808
23:46:53 10785 8192000000 10977352176 11417141248 1998196432 19.609 100 43 86 1 2062813568 50292608 14324528
23:47:22 12386 8192000000 10965540688 11410399232 1993675760 19.573 100 38 76 2 2051475232 45835344 11964128
23:47:43 6761 8192000000 10952078704 11402067968 1975932144 19.432 99 33 66 4 2030211104 43384768 10894192
23:48:01 9724 8192000000 10966614960 11412860928 1990356288 19.547 100 36 72 1 2051488032 49349904 11781840
23:48:18 7863 8192000000 10943030480 11385769984 1941460400 19.158 98 33 66 1 2001178384 48817840 10900144
23:48:32 8542 8192000000 10946364592 11395952640 1972355104 19.404 100 36 72 0 2033015504 48977984 11682416
23:48:50 11500 8192000000 10945751632 11388665856 1961965856 19.322 99 36 71 0 2017951696 44235008 11750832
23:49:15 21944 8192000000 10959585280 11400212480 1973324624 19.412 100 29 58 2 2029828272 46757504 9746144
23:49:44 20136 8192000000 10933164928 11386007552 1946310592 19.197 99 23 46 2 2009227840 53941328 8975920
23:50:15 20286 8192000000 10909487040 11353878528 1904382800 18.862 97 29 58 2 1967416352 51990848 11042704
23:50:45 33521 8192000000 10889689120 11342102528 1876193584 18.634 97 25 50 0 1935338240 49266656 9878000
23:51:25 34771 8192000000 10910613744 11364356096 1926935488 19.042 100 22 44 2 1992627872 57437376 8255008
23:52:07 20084 8192000000 10920678240 11372253184 1940571664 19.151 100 17 34 0 1995914880 48888752 6454464
23:52:38 24790 8192000000 10901703776 11361550336 1925158592 19.028 99 15 30 1 1977331712 46821200 5351920
23:53:11 22066 8192000000 10880518576 11357204480 1934426192 19.102 100 20 40 0 1978440640 37303904 6710544
23:53:40 33801 8192000000 10875546432 11330052096 1906277984 18.877 98 21 39 1 1924596224 12422608 5895632
23:54:21 42759 8192000000 10897334160 11337232384 1944968752 19.186 100 28 57 0 1967078704 12734704 9375248
23:55:13 121518 8192000000 10855523984 11320045568 1808343136 18.082 93 12 24 0 1827369312 15733536 3292640
23:57:20 46990 8192000000 10911617088 11339296768 1890721568 18.752 97 44 88 3 1909328160 5444032 13162560
23:58:14 69420 8192000000 10876143296 11324866560 1886752480 18.720 96 32 65 3 1907103872 11896464 8454928
23:59:31 45341 8192000000 10898450288 11349360640 1965832560 19.352 100 28 56 1 1989922768 15888192 8202016
00:01:08 130753 8192000000 10888330640 11349082112 1938534176 19.135 99 31 62 0 1959233120 11034448 9664496
00:03:30 211504 8192000000 10922946992 11383697408 1924526816 19.023 97 37 74 1 1943839648 8994080 10318752
00:07:09 35191 8192000000 10930697408 11386281984 1992832800 19.566 100 49 98 0 2023791824 14784240 16174784
00:07:50 16160 8192000000 10941320176 11391270912 1975316448 19.428 99 39 78 1 2007373760 20294448 11762864
00:08:23 30684 8192000000 10927327360 11383087104 1975980464 19.433 99 40 78 1 2002787072 15257616 11548992
00:09:04 41636 8192000000 10910820672 11381231616 1963561600 19.334 99 9 18 1 1982426960 15957168 2908192
00:10:00 83015 8192000000 10911587600 11383717888 1969722400 19.383 99 12 24 1 1986825200 13529872 3572928
00:11:59 56505 8192000000 10906612976 11389579264 1983329088 19.491 100 17 32 2 2006084576 17686240 5069248
00:13:03 32615 8192000000 10908044688 11380797440 1983510880 19.492 100 7 14 0 1996208336 10526544 2170912
00:13:42 23614 8192000000 10934299040 11375689728 1986697888 19.518 100 31 62 2 2002179632 7282464 8199280
00:14:21 43766 8192000000 10898868176 11375120384 1969592672 19.382 99 24 48 0 1984624864 8506624 6525568
00:15:24 73971 8192000000 10908070544 11373977600 1944107696 19.180 98 8 16 0 1956217920 9907744 2202480
00:16:46 32608 8192000000 10909431792 11373256704 1966015968 19.354 99 19 37 2 1979521696 8107104 5398624
00:17:30 42890 8192000000 10913105104 11392831488 1990304928 19.546 100 30 60 0 2009878640 10969456 8604256
00:18:19 54701 8192000000 10911007392 11384201216 1915140656 18.948 96 23 46 0 1931609680 10555968 5913056
00:19:27 92286 8192000000 10892600880 11362684928 1905196704 18.868 96 12 22 2 1923915968 15245584 3473680
00:21:09 45454 8192000000 10899496688 11378831360 1955467280 19.270 99 12 24 1 1970357488 11526368 3363840
00:22:01 44053 8192000000 10923898960 11384066048 1953158864 19.252 98 27 54 0 1973976272 13257616 7559792
00:23:08 69335 8192000000 10896171872 11377012736 1958732016 19.296 99 19 38 1 1981522480 17207632 5582832
00:24:24 98902 8192000000 10890989104 11370283008 1879668784 18.662 95 6 12 0 1893079360 11834592 1575984
00:26:09 34796 8192000000 10914981072 11366711296 1954102176 19.259 99 17 34 0 1967735296 8763792 4869328
00:26:52 10408 8192000000 10922704816 11368357888 1975293232 19.427 100 50 98 1 2000768704 10255360 15220112
00:27:09 34661 8192000000 10903126368 11354640384 1935110656 19.108 98 27 54 1 1951494992 9347328 7037008
00:27:50 56248 8192000000 10888628704 11340898304 1903726640 18.856 96 36 72 2 1923657520 10471408 9459472
00:28:54 106708 8192000000 10884773952 11357315072 1946598160 19.199 99 30 60 0 1964235936 9513136 8124640
00:30:48 55592 8192000000 10890940480 11365502976 1957402992 19.285 99 20 40 1 1973297872 10206320 5688560
00:31:50 26707 8192000000 10895328352 11369353216 1959445648 19.302 99 19 38 1 1979000128 14345424 5209056
00:32:34 53042 8192000000 10877086464 11360833536 1945640048 19.192 99 5 10 0 1956986672 10261536 1085088
00:33:33 38356 8192000000 10877643168 11351330816 1910875536 18.914 97 22 42 0 1931241056 12871648 7493872
00:34:26 45915 8192000000 10899453664 11365949440 1966323104 19.356 100 12 24 1 1982498688 12508240 3667344
00:35:34 56151 8192000000 10894411296 11359776768 1943248912 19.173 98 17 35 1 1964047312 15364624 5433776
00:36:36 54172 8192000000 10918353360 11390976000 1980595152 19.469 100 18 36 0 2002541264 16253616 5692496
00:37:38 41189 8192000000 10929015792 11392872448 1966094192 19.354 99 35 70 1 1997629504 21634640 9900672
00:38:46 45223 8192000000 10901160432 11361345536 1934370176 19.102 98 18 36 1 1959361632 19680544 5310912
00:39:40 55536 8192000000 10877236016 11340947456 1871330368 18.595 95 21 42 0 1896196528 18257200 6608960
00:40:49 90613 8192000000 10872633072 11333394432 1846436336 18.393 95 14 28 1 1873164640 22239200 4489104
00:42:25 50672 8192000000 10858347136 11318992896 1865769104 18.550 96 22 44 0 1891613856 19642432 6202320
00:43:23 48039 8192000000 10880113024 11339079680 1922812272 19.009 100 20 40 0 1942210496 13453008 5945216
00:44:17 56939 8192000000 10880009824 11343437824 1928294864 19.053 99 20 40 1 1946190736 11925552 5970320
00:45:21 37212 8192000000 10856053952 11305152512 1849844640 18.421 95 25 50 0 1865189248 7531168 7813440
00:46:08 42096 8192000000 10872274336 11327385600 1911899616 18.922 98 46 92 0 1939130304 14086400 13144288
00:47:07 78296 8192000000 10877382048 11349295104 1909947056 18.906 98 15 31 3 1933566128 19265488 4353584
00:48:32 25647 8192000000 10905306976 11358539776 1955859856 19.273 100 30 60 0 1976760352 12171728 8728768
00:49:04 70126 8192000000 10906093184 11374612480 1928775328 19.057 98 19 38 0 1951436288 17702160 4958800
00:50:30 51477 8192000000 10906805264 11362607104 1940201984 19.148 99 14 28 0 1954314544 10365264 3747296
00:51:29 29587 8192000000 10904708416 11349045248 1950872640 19.233 99 49 98 1 1978805696 13833264 14099792
00:52:05 116485 8192000000 10888202240 11348463616 1944369936 19.182 99 30 60 1 1964966288 12572064 8024288
00:54:16 29615 8192000000 10885779696 11334176768 1939590080 19.143 99 28 54 1 1958052288 11074128 7388080
00:54:52 63665 8192000000 10877657376 11357532160 1951718256 19.240 99 38 75 2 1973007904 9928832 11360816
00:56:11 59029 8192000000 10873726864 11359211520 1953469536 19.254 99 12 24 0 1970605280 13750720 3385024
00:58:01 109347 8192000000 10885084928 11355713536 1938790128 19.137 98 21 42 0 1957658144 12602896 6265120
00:59:56 69545 8192000000 10894461120 11369521152 1972186128 19.403 100 22 44 1 1990271360 12045136 6040096
01:01:18 60462 8192000000 10904952000 11375538176 1956762720 19.280 99 9 18 1 1969984464 11030496 2191248
01:02:24 89312 8192000000 10914458272 11387973632 1962890496 19.329 99 12 24 1 1980248624 14237232 3120896
01:04:00 48176 8192000000 10917925264 11384909824 1954032992 19.259 98 19 38 1 1969010688 9752400 5225296
01:05:05 39603 8192000000 10914477808 11380056064 1971960736 19.401 99 35 70 0 1993703616 11829888 9912992
01:05:57 58125 8192000000 10914183600 11385069568 1979776928 19.463 100 14 29 1 1996656784 12708976 4170880
01:07:02 60447 8192000000 10935523248 11390259200 1973389936 19.412 99 13 26 0 1991397920 14387840 3620144
01:08:10 31055 8192000000 10948143072 11411632128 2007449520 19.681 100 33 66 0 2027874736 11571584 8853632
01:08:52 35370 8192000000 10947343680 11418370048 2007119600 19.679 100 40 80 3 2034720080 16522560 11077920
01:09:37 61066 8192000000 10950645744 11432103936 2014270016 19.735 100 27 54 1 2044931984 23248672 7413296
01:10:49 46259 8192000000 10959168288 11454791680 2013247104 19.727 100 13 26 0 2043261280 26253312 3760864
01:11:49 144728 8192000000 10882894768 11348312064 1763284816 17.712 88 17 33 2 1781610128 14311360 4013952
01:14:21 65380 8192000000 10888124368 11351736320 1882557248 18.686 96 28 56 2 1900470192 10324080 7588864
01:15:43 87472 8192000000 10862569888 11320520704 1877322128 18.643 96 29 58 1 1892911440 7516816 8072496
01:17:56 39140 8192000000 10852265216 11302129664 1885308288 18.708 97 22 44 1 1898893488 6262800 7322400
01:18:42 51594 8192000000 10817507680 11289903104 1833647936 18.289 95 11 22 0 1842832912 6211248 2973728
01:19:41 72152 8192000000 10845606336 11318337536 1926373632 19.038 100 8 16 0 1935834768 7122608 2338528
01:21:45 47502 8192000000 10858382720 11329929216 1906939216 18.882 98 17 34 0 1920497072 8566480 4991376
01:22:38 71189 8192000000 10855080640 11336568832 1923152496 19.012 99 12 24 0 1940914112 14351472 3410144
01:24:00 46515 8192000000 10863123008 11334279168 1926028832 19.035 99 25 50 2 1941744464 8673696 7041936
01:24:55 35691 8192000000 10870645504 11332276224 1910493072 18.911 98 25 50 2 1926908960 8925936 7489952
01:25:59 59713 8192000000 10855690320 11323387904 1908189264 18.892 98 21 42 0 1926953808 13132032 5632512
01:27:05 14761 8192000000 9141564496 9386065920 299550256 3.527 16 3 6 0 308708864 8507296 651312

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-01-2021 01:28:44 to 02-01-2021 01:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          235273
MON$OLDEST_ACTIVE               235274
MON$OLDEST_SNAPSHOT             235274
MON$NEXT_TRANSACTION            235274
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                       2043296
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

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