Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.03.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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17200176 kB
MemAvailable 31466128 kB
Buffers 0 kB
Cached 14438308 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-28 01:27:27
DTS_END                         2021-03-28 01:27:27.3180
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/54738
TRN_ID                          249797
ATT_ID                          655
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: 9500.86 18238 1140103
customer order: creation 180.36 309 21643
customer order: refuse 14.95 384 1794
order to supplier: creation 46.80 1255 5616
order to supplier: removal 3.31 97504 397
invoice (draft): creation 48.37 3188 5804
invoice (draft): removal 54.08 830 6489
invoice accept: apply 43.81 16830 5257
invoice accept: cancel 48.10 791 5772
customer reserve: creation 4027.11 167 483253
customer reserve: removal 4732.29 51 567875
realization accept: apply 87.09 169 10451
realization accept: cancel 79.43 112 9531
payment from customer: creation 62.28 103 7474
payment from customer: removal 6.08 98 730
payment to supplier: creation 50.75 112 6090
payment to supplier: removal 3.66 54 439
service: total inventory turnovers 4.55 1149 546
service: total monetary turnovers 6.92 27 830
service: aggregate perf. data 0.90 17470 108
service: refresh index statistics 0.03 224156 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5200
TEST_TIME 2 4594
TEST_TIME 3 4258
TEST_TIME 4 4797
TEST_TIME 5 5180
TEST_TIME 6 5782
TEST_TIME 7 5656
TEST_TIME 8 5938
TEST_TIME 9 5881
TEST_TIME 10 6139
TEST_TIME 11 6394
TEST_TIME 12 7264
TEST_TIME 13 7436
TEST_TIME 14 7331
TEST_TIME 15 7332
TEST_TIME 16 7469
TEST_TIME 17 7473
TEST_TIME 18 7703
TEST_TIME 19 7959
TEST_TIME 20 8294
TEST_TIME 21 8907
TEST_TIME 22 9073
TEST_TIME 23 9382
TEST_TIME 24 9350
TEST_TIME 25 9330
TEST_TIME 26 9977
TEST_TIME 27 10362
TEST_TIME 28 10918
TEST_TIME 29 11086
TEST_TIME 30 11325
TEST_TIME 31 11123
TEST_TIME 32 11007
TEST_TIME 33 10824
TEST_TIME 34 10936
TEST_TIME 35 10778
TEST_TIME 36 11046
TEST_TIME 37 11019
TEST_TIME 38 10875
TEST_TIME 39 10643
TEST_TIME 40 10552
TEST_TIME 41 10644
TEST_TIME 42 10507
TEST_TIME 43 10599
TEST_TIME 44 10461
TEST_TIME 45 10374
TEST_TIME 46 10334
TEST_TIME 47 10475
TEST_TIME 48 10384
TEST_TIME 49 10373
TEST_TIME 50 10359
TEST_TIME 51 10271
TEST_TIME 52 10203
TEST_TIME 53 10131
TEST_TIME 54 10175
TEST_TIME 55 10141
TEST_TIME 56 10090
TEST_TIME 57 10046
TEST_TIME 58 9902
TEST_TIME 59 9809
TEST_TIME 60 9913
TEST_TIME 61 9852
TEST_TIME 62 9840
TEST_TIME 63 9858
TEST_TIME 64 9894
TEST_TIME 65 9904
TEST_TIME 66 9973
TEST_TIME 67 9977
TEST_TIME 68 10011
TEST_TIME 69 10026
TEST_TIME 70 10048
TEST_TIME 71 10034
TEST_TIME 72 10029
TEST_TIME 73 10045
TEST_TIME 74 10034
TEST_TIME 75 10077
TEST_TIME 76 10049
TEST_TIME 77 9944
TEST_TIME 78 9922
TEST_TIME 79 9845
TEST_TIME 80 9857
TEST_TIME 81 9818
TEST_TIME 82 9762
TEST_TIME 83 9720
TEST_TIME 84 9648
TEST_TIME 85 9581
TEST_TIME 86 9535
TEST_TIME 87 9647
TEST_TIME 88 9661
TEST_TIME 89 9682
TEST_TIME 90 9638
TEST_TIME 91 9764
TEST_TIME 92 9728
TEST_TIME 93 9772
TEST_TIME 94 9756
TEST_TIME 95 9788
TEST_TIME 96 9801
TEST_TIME 97 9838
TEST_TIME 98 9808
TEST_TIME 99 9784
TEST_TIME 100 9915
TEST_TIME 101 9922
TEST_TIME 102 9846
TEST_TIME 103 9802
TEST_TIME 104 9746
TEST_TIME 105 9762
TEST_TIME 106 9724
TEST_TIME 107 9687
TEST_TIME 108 9666
TEST_TIME 109 9648
TEST_TIME 110 9622
TEST_TIME 111 9604
TEST_TIME 112 9594
TEST_TIME 113 9570
TEST_TIME 114 9553
TEST_TIME 115 9542
TEST_TIME 116 9568
TEST_TIME 117 9580
TEST_TIME 118 9587
TEST_TIME 119 9572
TEST_TIME 120 9511

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2021 01:28:32 to 28-03-2021 01:28:35.

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 1587329 1587329 0 0.00 0 14575 6 0 0
doc_list_biud 1587322 1587322 0 0.00 0 74629 25 0 0
sp_add_invoice_to_stock 5356 5257 99 1.84 31 169718 16831 0 99
sp_cancel_adding_invoice 5772 5772 0 0.00 6 80364 791 0 0
sp_cancel_client_order 1794 1794 0 0.00 4 16082 385 0 0
sp_cancel_customer_reserve 567875 567875 0 0.00 1 74633 52 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 3 13280 99 0 0
sp_cancel_pay_to_supplier 439 439 0 0.00 3 1736 54 0 0
sp_cancel_supplier_invoice 6498 6489 9 0.13 2 15048 831 0 9
sp_cancel_supplier_order 397 397 0 0.00 9 1046808 97505 0 0
sp_cancel_write_off 9531 9531 0 0.00 1 22779 113 0 0
sp_client_order 21643 21643 0 0.00 3 80315 309 0 0
sp_customer_reserve 483253 483253 0 0.00 0 54883 167 0 0
sp_fill_shopping_cart 33053 33053 0 0.00 1 16539 36 0 0
sp_fill_shopping_cart_clo_res 483235 483235 0 0.00 0 11654 12 0 0
sp_get_clo_for_invoice 5236 5236 0 0.00 0 26703 296 0 0
sp_kill_cost_storno 16472 16472 0 0.00 0 8368 54 0 0
sp_kill_qstorno_ret_qs2qd 1152167 1152167 0 0.00 0 74623 29 0 0
sp_kill_qty_storno 607545 607545 0 0.00 0 74629 63 0 0
sp_lock_selected_doc 21756 21756 0 0.00 0 7829 5 0 0
sp_make_cost_storno 29251 29251 0 0.00 0 14224 49 0 0
sp_multiply_rows_for_pdistr 29251 29251 0 0.00 0 9905 28 0 0
sp_multiply_rows_for_qdistr 21643 21643 0 0.00 0 80305 138 0 0
sp_pay_from_customer 7474 7474 0 0.00 4 12600 103 0 0
sp_pay_to_supplier 6090 6090 0 0.00 4 12015 113 0 0
sp_payment_common 13564 13564 0 0.00 1 10645 21 0 0
sp_qd_handle_on_cancel_clo 1794 1794 0 0.00 0 16076 362 0 0
sp_qd_handle_on_invoice_upd_sts 11008 11008 0 0.00 0 20281 325 0 0
sp_qd_handle_on_reserve_upd_sts 10451 10451 0 0.00 0 16504 56 0 0
sp_reserve_write_off 10451 10451 0 0.00 6 16527 170 0 0
sp_supplier_invoice 5804 5804 0 0.00 5 72881 3188 0 0
sp_supplier_order 5616 5616 0 0.00 5 45216 1256 0 0
srv_aggregate_perf_data 108 108 0 0.00 3206 160075 17471 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1077 139519 30989 0 0
srv_find_qd_qs_mism 1090083 1090083 0 0.00 0 14573 5 0 0
srv_make_invnt_saldo 546 546 0 0.00 38 33105 1149 0 0
srv_make_money_saldo 830 830 0 0.00 0 1079 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 153814 293490 224157 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5257 5257 0 0.00 0 25724 178 0 0
t$perf-norm:sp_cancel_adding_invoice 403 403 0 0.00 0 4435 87 0 0
t$perf-norm:sp_cancel_client_order 1794 1794 0 0.00 0 5186 19 0 0
t$perf-norm:sp_cancel_customer_reserve 774 774 0 0.00 0 1682 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 13367 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 439 439 0 0.00 0 1632 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 462 462 0 0.00 0 3428 30 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 31801 1779 0 0
t$perf-norm:sp_cancel_write_off 1070 1070 0 0.00 0 2823 7 0 0
t$perf-norm:sp_client_order 21643 21643 0 0.00 0 15389 19 0 0
t$perf-norm:sp_customer_reserve 1075 1075 0 0.00 0 1009 5 0 0
t$perf-norm:sp_pay_from_customer 7474 7474 0 0.00 0 17579 14 0 0
t$perf-norm:sp_pay_to_supplier 6090 6090 0 0.00 0 6374 13 0 0
t$perf-norm:sp_reserve_write_off 10451 10451 0 0.00 0 7941 13 0 0
t$perf-norm:sp_supplier_invoice 5804 5804 0 0.00 0 4815 14 0 0
t$perf-norm:sp_supplier_order 5616 5616 0 0.00 0 3683 19 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 270 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 538 6 0 0
t$perf-norm:srv_make_invnt_saldo 546 546 0 0.00 0 1561 28 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 17537 40 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 392 100 0 0
v_add_invoice_to_stock 10670 10472 198 1.85 0 4295 19 0 198
v_all_customers 39188 39188 0 0.00 0 124 1 0 0
v_all_suppliers 31662 31662 0 0.00 0 40 1 0 0
v_all_wares 43286 43286 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 806 806 0 0.00 0 286 6 0 0
v_cancel_client_order 3588 3588 0 0.00 0 1857 4 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 13263 16 0 0
v_cancel_customer_reserve 1548 1548 0 0.00 0 163 3 0 0
v_cancel_payment_to_supplier 878 878 0 0.00 0 976 4 0 0
v_cancel_supplier_invoice 942 924 18 1.91 0 1329 18 0 18
v_cancel_supplier_order 794 794 0 0.00 0 772 5 0 0
v_cancel_write_off 2140 2140 0 0.00 0 1565 13 0 0
v_max_id_clo_ord 5613 5613 0 0.00 0 581 1 0 0
v_max_id_clo_res 1075 1075 0 0.00 0 2864 11 0 0
v_max_id_ord_sup 5797 5797 0 0.00 0 6770 6 0 0
v_max_non_paid_invoice 1669 1669 0 0.00 0 152 2 0 0
v_max_non_paid_realizn 4034 4034 0 0.00 0 3318 5 0 0
v_min_id_clo_ord 5613 5613 0 0.00 0 2837 6 0 0
v_min_id_clo_res 1075 1075 0 0.00 0 10800 20 0 0
v_min_id_ord_sup 5797 5797 0 0.00 0 7168 12 0 0
v_min_non_paid_invoice 6090 6090 0 0.00 0 5106 11 0 0
v_min_non_paid_realizn 7474 7474 0 0.00 0 6640 12 0 0
v_our_firm 10978 10978 0 0.00 0 25 1 0 0
v_reserve_write_off 20902 20902 0 0.00 0 9601 6 0 0
x_lock_depdocs_on_canc_invoice 11799 11799 0 0.00 0 17325 117 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 10850 368 0 0
x_make_qstorno_1000_1200 5616 5616 0 0.00 1 45040 1179 0 0
x_make_qstorno_1200_2000 5804 5804 0 0.00 3 72867 3060 0 0
x_make_qstorno_2100_3300 483253 483253 0 0.00 0 54882 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2021 01:28:36 to 28-03-2021 01:28:40.

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:31 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:37 9707 8192000000 10170907920 10473492480 856877744 9.469 69 52 104 0 876991760 2323696 17790320
22:57:55 29375 8192000000 10330481936 10644217856 1368732656 14.316 100 85 170 1 1400399936 4416464 27250816
22:58:33 34426 8192000000 10374400928 10694930432 1417778912 14.753 100 90 181 0 1453527600 6269008 29479680
22:59:19 26870 8192000000 10412651136 10739175424 1464771280 15.168 100 92 184 1 1502225520 7603024 29851216
22:59:57 25740 8192000000 10433516368 10764849152 1491199952 15.399 100 90 180 1 1528939552 8782672 28956928
23:00:37 18396 8192000000 10441834112 10775756800 1495045152 15.433 100 87 173 0 1532005072 9368064 27591856
23:01:05 10346 8192000000 10452542528 10790944768 1510803968 15.570 100 81 162 0 1546117136 9373840 25939328
23:01:25 13579 8192000000 10477544288 10820116480 1531793168 15.753 100 82 164 1 1566803008 9381696 25628144
23:01:47 13866 8192000000 10504768112 10851917824 1558574000 15.984 100 86 172 1 1595864064 9825728 27464336
23:02:11 13365 8192000000 10533796240 10884710400 1585898768 16.219 100 78 156 1 1619959504 10122048 23938688
23:02:34 12178 8192000000 10554544368 10911399936 1609511568 16.421 100 78 156 0 1644313328 10429024 24372736
23:02:57 10983 8192000000 10577565392 10935975936 1635787184 16.644 100 82 164 1 1672160720 11469312 24904224
23:03:20 7128 8192000000 10586030384 10952728576 1649498192 16.760 100 73 147 0 1683023712 11604256 21921264
23:03:37 7629 8192000000 10609460624 10976284672 1671879040 16.949 100 80 158 1 1707121168 12014640 23227488
23:03:54 7850 8192000000 10632909216 11001999360 1689912752 17.101 100 84 166 1 1727633568 12818688 24902128
23:04:10 7176 8192000000 10641982704 11012677632 1703879552 17.218 100 79 155 4 1739795232 13133920 22781760
23:04:27 6848 8192000000 10669171408 11042131968 1724862304 17.393 100 81 162 2 1760669456 12168576 23638576
23:04:41 6275 8192000000 10670046240 11048976384 1732917712 17.460 100 72 144 0 1765510944 12076592 20516640
23:04:54 4940 8192000000 10691318672 11064123392 1749243696 17.595 100 82 164 0 1784794480 12267360 23283424
23:05:07 5674 8192000000 10701484192 11079946240 1759830672 17.683 100 74 148 1 1792553552 12207856 20515024
23:05:20 3805 8192000000 10715126912 11089846272 1771714752 17.781 100 82 163 3 1807350704 12548720 23087232
23:05:31 3184 8192000000 10714794816 11094208512 1779076560 17.842 100 78 156 0 1813301360 12650048 21574752
23:05:40 3630 8192000000 10743119680 11122315264 1796808608 17.988 100 82 164 0 1833190320 13708176 22673536
23:05:51 2578 8192000000 10741676432 11125026816 1803403664 18.042 100 84 166 1 1839347360 13402704 22540992
23:06:00 2501 8192000000 10747575536 11131920384 1808186000 18.081 100 83 164 2 1843643536 12690704 22766832
23:06:09 4282 8192000000 10756051360 11137134592 1811335408 18.107 100 81 162 2 1847214592 13943648 21935536
23:06:20 2908 8192000000 10756320720 11141099520 1814566064 18.133 100 83 167 0 1851871600 14431648 22873888
23:06:29 5421 8192000000 10773294912 11158052864 1817823680 18.160 100 81 160 0 1858837776 18694624 22319472
23:06:41 1499 8192000000 10777063008 11161686016 1836792032 18.315 100 91 184 1 1876517776 14247504 25478240
23:06:49 2498 8192000000 10781733808 11166973952 1838035520 18.325 100 90 181 1 1878185856 14693440 25456896
23:06:58 1512 8192000000 10791681536 11174526976 1842642256 18.362 100 92 181 1 1882440096 14530736 25267104
23:07:06 1293 8192000000 10798874768 11183009792 1849443648 18.418 100 88 174 1 1887195424 13486064 24265712
23:07:14 1794 8192000000 10798014176 11184746496 1852075904 18.439 100 87 174 1 1890092064 13636000 24380160
23:07:22 1690 8192000000 10804708256 11192504320 1860232272 18.505 100 95 190 3 1901159376 14225584 26701520
23:07:30 1814 8192000000 10803648576 11191623680 1860144864 18.504 100 92 186 0 1899970016 13582064 26243088
23:07:38 1884 8192000000 10806351440 11193856000 1865122896 18.545 100 90 180 3 1903613744 12749760 25741088
23:07:47 1764 8192000000 10810560928 11196715008 1864162432 18.537 100 91 182 1 1902637008 12353984 26120592
23:07:55 2303 8192000000 10801842880 11194765312 1864560144 18.540 100 83 163 2 1899850000 12818656 22471200
23:08:04 3903 8192000000 10795169920 11201314816 1870464080 18.588 100 61 124 1 1898638032 10969696 17204256
23:08:14 58964 8192000000 10777568768 11204521984 1868580448 18.573 100 30 60 1 1883052032 5160400 9311184
23:09:21 7134 8192000000 10786445728 11210620928 1874785232 18.623 100 35 70 1 1891214992 6833264 9596496
23:09:37 10298 8192000000 10781846384 11212337152 1874293744 18.619 100 22 44 0 1886718000 6580288 5843968
23:09:54 9739 8192000000 10796298192 11214737408 1878148848 18.650 100 25 49 1 1890929072 5723664 7056560
23:10:11 4722 8192000000 10800950992 11225759744 1882038896 18.682 100 33 66 2 1898380592 7400352 8941344
23:10:24 2851 8192000000 10799368480 11222212608 1888744384 18.736 100 38 75 3 1907365792 7532288 11089120
23:10:35 6968 8192000000 10800261296 11228282880 1886573968 18.718 100 32 64 0 1902908784 7815408 8519408
23:10:50 4753 8192000000 10812360576 11230482432 1891196736 18.755 100 41 80 1 1909350064 7186576 10966752
23:11:01 7250 8192000000 10791549600 11225112576 1887612800 18.727 100 22 44 0 1900178384 5999248 6566336
23:11:15 12674 8192000000 10802323232 11230044160 1889879680 18.745 100 19 38 2 1901068368 5964416 5224272
23:11:36 9701 8192000000 10803589456 11236085760 1897868352 18.809 100 14 28 2 1907802096 5784304 4149440
23:11:52 9875 8192000000 10815248688 11239972864 1899460000 18.822 100 19 38 1 1910511280 5227168 5824112
23:12:10 11247 8192000000 10810803040 11246088192 1903480384 18.854 100 12 23 1 1912410832 5567920 3362528
23:12:30 11329 8192000000 10820301840 11250438144 1905368912 18.869 100 13 26 2 1915108928 5933472 3806544
23:12:47 68889 8192000000 10816514720 11252813824 1910633120 18.912 100 37 71 4 1926949264 5286720 11029424
23:14:04 9573 8192000000 10820498512 11257929728 1911161744 18.916 100 24 48 2 1924281040 6936896 6182400
23:14:20 5475 8192000000 10828828448 11263705088 1915046240 18.947 100 30 60 0 1929918224 6725856 8146128
23:14:34 6179 8192000000 10835977024 11264516096 1914660640 18.944 100 29 56 1 1929176832 6665200 7850992
23:14:48 4540 8192000000 10837093968 11269550080 1916061552 18.955 100 28 56 0 1935197088 11517712 7617824
23:15:00 3559 8192000000 10831034128 11263700992 1917321776 18.965 100 35 69 2 1933625952 5903552 10400624
23:15:09 4589 8192000000 10825394336 11255754752 1897593280 18.807 99 32 65 1 1913484896 6278384 9613232
23:15:23 6164 8192000000 10816053776 11253129216 1892412288 18.765 99 25 49 1 1905723856 6469328 6842240
23:15:37 9373 8192000000 10811845952 11253784576 1904068960 18.859 100 27 54 1 1917867136 6294144 7504032
23:15:52 9864 8192000000 10828620656 11261255680 1913664208 18.936 100 24 48 1 1926819328 6559824 6595296
23:16:08 8496 8192000000 10803609920 11236286464 1869977024 18.584 98 31 62 2 1889523424 10431328 9115072
23:16:24 6581 8192000000 10827257024 11251093504 1903871488 18.857 100 20 41 0 1915640496 5816848 5952160
23:16:37 7877 8192000000 10800005408 11232669696 1859665136 18.501 98 13 26 0 1868335568 4791536 3878896
23:16:55 9938 8192000000 10792921920 11224731648 1836195840 18.310 97 15 30 0 1845811504 5573424 4042240
23:17:12 10623 8192000000 10747608784 11174617088 1755805200 17.650 94 20 40 1 1767308512 5643488 5859824
23:17:30 68753 8192000000 10737048464 11158130688 1778245280 17.835 95 26 52 1 1795059088 9361984 7451824
23:18:51 12767 8192000000 10744508496 11166527488 1758565232 17.673 95 20 38 3 1777702080 13770656 5366192
23:19:10 8110 8192000000 10728127008 11142684672 1769084784 17.759 97 34 68 1 1789734768 10912080 9737904
23:19:29 8498 8192000000 10726995120 11139805184 1781506016 17.862 98 23 46 2 1793174416 5337488 6330912
23:19:45 5333 8192000000 10701728048 11123777536 1781826288 17.865 99 32 63 1 1796219440 5532768 8860384
23:19:57 3800 8192000000 10722153488 11117424640 1775269600 17.810 99 46 93 4 1794459824 4667632 14522592
23:20:08 11119 8192000000 10692003648 11111264256 1769045504 17.759 99 20 40 1 1780895792 6211904 5638384
23:20:28 6572 8192000000 10708059280 11123310592 1763230064 17.711 98 19 37 1 1773974976 5751072 4993840
23:20:46 6941 8192000000 10686453104 11105755136 1701504096 17.198 94 20 40 0 1712012080 5240736 5267248
23:20:59 6017 8192000000 10708054800 11113963520 1739127024 17.511 97 29 60 1 1757360912 9674400 8559488
23:21:11 7000 8192000000 10710982704 11124989952 1778862832 17.840 99 18 37 0 1790336464 5998256 5475376
23:21:27 8056 8192000000 10710358032 11123621888 1764054624 17.718 98 24 48 0 1776958064 5713824 7189616
23:21:43 7518 8192000000 10709132080 11131215872 1770139840 17.768 98 28 56 2 1783241696 4591008 8510848
23:22:03 11061 8192000000 10732878144 11150602240 1803820672 18.045 99 33 65 1 1819887136 6041552 10024912
23:22:20 47575 8192000000 10759046656 11164299264 1826881776 18.234 100 28 55 3 1840763168 5446048 8435344
23:23:32 10491 8192000000 10751896784 11173937152 1828537344 18.247 100 18 36 0 1840040688 6821248 4682096
23:23:51 7223 8192000000 10754001088 11175624704 1825482944 18.222 99 32 62 1 1841924784 7292240 9149600
23:24:05 7379 8192000000 10765179552 11185995776 1844571600 18.378 100 30 60 0 1864177328 10552800 9052928
23:24:25 4722 8192000000 10781457200 11196784640 1855589200 18.468 100 45 90 0 1876140112 8158912 12392000
23:24:38 5461 8192000000 10771986064 11197493248 1856759424 18.477 100 33 67 1 1876822784 10621568 9441792
23:24:50 7324 8192000000 10764673328 11196858368 1856963456 18.479 100 25 50 0 1869731856 5799072 6969328
23:25:06 5684 8192000000 10773442352 11200684032 1858794592 18.494 100 26 53 0 1871812144 5001040 8016512
23:25:20 7920 8192000000 10776265536 11204034560 1861235648 18.513 100 31 60 1 1876087216 6019760 8831808
23:25:34 11181 8192000000 10793408192 11211481088 1866750800 18.558 100 39 78 2 1888349024 9511040 12087184
23:25:54 8230 8192000000 10787886128 11210670080 1871351856 18.595 100 33 66 0 1887500688 5249424 10899408
23:26:10 8442 8192000000 10784393008 11214405632 1871441152 18.596 100 29 58 0 1890159568 10225280 8493136
23:26:25 10825 8192000000 10788562736 11219193856 1872913744 18.608 100 16 32 2 1882397072 5181392 4301936
23:26:48 8993 8192000000 10783456048 11216695296 1874330464 18.619 100 11 22 0 1882506192 5279408 2896320
23:27:03 19747 8192000000 10808447088 11237560320 1887401072 18.725 100 14 28 0 1895948944 4444816 4103056
23:27:29 68395 8192000000 10842636144 11259203584 1908438432 18.894 100 40 80 3 1925788496 4974432 12375632
23:28:46 10067 8192000000 10843959616 11269132288 1916980064 18.963 100 37 72 1 1933748944 7221520 9547360
23:29:04 7327 8192000000 10857060224 11277922304 1927743744 19.049 100 57 110 0 1951492224 9006256 14742224
23:29:18 15444 8192000000 10860426336 11282132992 1930814480 19.073 100 55 110 1 1956258864 9593184 15851200
23:29:44 16350 8192000000 10872797648 11294076928 1937615152 19.128 100 54 106 0 1963014816 9662096 15737568
23:30:17 41049 8192000000 10872129744 11304943616 1932450992 19.086 99 47 94 1 1960451376 14292336 13708048
23:31:07 10290 8192000000 10892748880 11316776960 1952945216 19.250 100 44 88 2 1977853024 12203472 12704336
23:31:28 8757 8192000000 10888342032 11316006912 1943341744 19.173 99 57 114 1 1974677584 14566256 16769584
23:31:50 12342 8192000000 10906118464 11325771776 1962464768 19.326 100 63 125 0 1995655136 14679248 18511120
23:32:12 13122 8192000000 10903301104 11331731456 1967862464 19.368 100 58 116 2 2000000688 15370976 16767248
23:32:34 7977 8192000000 10896504288 11326193664 1950306528 19.229 99 53 107 1 1981477376 15544400 15626448
23:32:51 7412 8192000000 10914993456 11339321344 1970812496 19.392 100 64 128 0 2005036480 15847104 18376880
23:33:06 16632 8192000000 10921302496 11352702976 1980211984 19.466 100 64 124 1 2017543984 18556464 18775536
23:33:32 21423 8192000000 10905446256 11346964480 1969916016 19.385 100 47 92 1 2001263616 17442672 13904928
23:34:05 5579 8192000000 10907541296 11344375808 1959700656 19.304 99 47 94 0 1991291280 16639920 14950704
23:34:25 18909 8192000000 10925300608 11359834112 1981388768 19.476 100 51 98 3 2016370224 19468768 15512688
23:34:57 12656 8192000000 10929958688 11369119744 1990093216 19.545 100 52 103 3 2024584336 19663024 14828096
23:35:18 8747 8192000000 10916176688 11357282304 1969035104 19.378 99 45 90 2 2001842400 19463648 13343648
23:35:38 2637 8192000000 10912826480 11341430784 1959960896 19.306 99 54 108 2 1994669424 19042480 15666048
23:35:49 6045 8192000000 10919448112 11353952256 1977584416 19.446 100 54 106 2 2013675968 20040288 16051264
23:36:01 5586 8192000000 10893236896 11321360384 1944360240 19.182 99 53 106 1 1980539472 20867776 15311456
23:36:16 5079 8192000000 10926319376 11351818240 1971427392 19.397 100 62 122 0 2010383184 20781440 18174352
23:36:31 4632 8192000000 10922242672 11348623360 1958828576 19.297 99 63 122 2 1997766544 20918128 18019840
23:36:46 9999 8192000000 10928363216 11352985600 1975637792 19.430 100 60 120 1 2014695056 21837824 17219440
23:37:16 6023 8192000000 10940351216 11364311040 1984080496 19.497 100 72 142 1 2032382080 27073840 21227744
23:37:30 10217 8192000000 10952947968 11375214592 1989112432 19.537 100 70 140 0 2042860992 33563056 20185504
23:37:49 2347 8192000000 10949326208 11365265408 1981080720 19.473 100 84 168 1 2038721392 32875488 24765184
23:37:58 2804 8192000000 10945266544 11364913152 1981030896 19.473 100 74 148 0 2031617536 28907920 21678720
23:38:08 3984 8192000000 10932672144 11352301568 1958280320 19.292 99 77 154 1 2011020448 29701184 23038944
23:38:24 7851 8192000000 10926281648 11351703552 1953288064 19.253 99 65 130 1 2003643616 30733248 19622304
23:38:39 4051 8192000000 10934913440 11353022464 1962738608 19.328 100 65 130 0 2013033760 31027648 19267504
23:38:50 2033 8192000000 10906417840 11335684096 1925976784 19.035 98 69 136 1 1981660496 34436880 21246832
23:39:05 1962 8192000000 10943089872 11352727552 1961358192 19.317 100 82 165 0 2022877088 36232960 25285936
23:39:13 4712 8192000000 10926847040 11346321408 1952544512 19.247 100 70 137 2 2011026336 37933312 20548512
23:39:25 2385 8192000000 10948811472 11368853504 1973039552 19.410 100 75 146 1 2033388320 37249952 23098816
23:39:40 1751 8192000000 10946602800 11373289472 1980249648 19.467 100 67 133 0 2034961904 33985392 20726864
23:39:49 7524 8192000000 10927902384 11355488256 1965184048 19.347 100 72 143 0 2019823360 33523488 21115824
23:40:04 4892 8192000000 10941924048 11365453824 1974394064 19.420 100 73 142 2 2028638720 32778528 21466128
23:40:17 2337 8192000000 10943189616 11365576704 1962745952 19.328 99 66 133 1 2011086624 29150608 19190064
23:40:27 11360 8192000000 10937103920 11368284160 1978878368 19.456 100 62 124 0 2027764256 29445744 19440144
23:40:48 2671 8192000000 10933068896 11354587136 1960836912 19.313 99 70 138 1 2010211088 29515376 19858800
23:40:57 3458 8192000000 10938608480 11369521152 1980355920 19.468 100 60 120 1 2029397856 30130768 18911168
23:41:12 2822 8192000000 10941235280 11368574976 1980596080 19.469 100 66 130 1 2029563008 30009536 18957392
23:41:30 4973 8192000000 10949177424 11373899776 1983514256 19.493 100 62 124 0 2033623456 31152304 18956896
23:41:42 3863 8192000000 10962289856 11383017472 1993210016 19.569 100 74 147 1 2047657632 32032304 22415312
23:41:53 5899 8192000000 10942492336 11366187008 1961312928 19.316 99 66 132 1 2013106848 31999552 19794368
23:42:06 2495 8192000000 10959360208 11377565696 1985611968 19.509 100 80 161 1 2044606736 34987600 24007168
23:42:16 3449 8192000000 10957541536 11371864064 1977957072 19.449 100 71 142 2 2035047840 36158768 20932000
23:42:26 8401 8192000000 10962391680 11382161408 1982358768 19.483 100 78 155 0 2043304064 37622096 23323200
23:42:43 2661 8192000000 10937763008 11351138304 1960976496 19.314 100 92 182 0 2026133680 37764944 27392240
23:42:53 5189 8192000000 10930322512 11347849216 1953107344 19.251 100 78 155 1 2015371728 37937264 24327120
23:43:06 4473 8192000000 10908750528 11322748928 1923591024 19.016 99 76 146 0 1985132336 38218560 23322752
23:43:20 1076 8192000000 10927166416 11330203648 1942029216 19.163 99 95 190 2 2010323728 39145920 29148592
23:43:27 1860 8192000000 10927705520 11336572928 1932047472 19.083 99 89 174 2 2000458528 40780736 27630320
23:43:39 2292 8192000000 10936442480 11348291584 1953486736 19.254 100 74 148 2 2017239168 40706880 23045552
23:43:49 5287 8192000000 10921997248 11339108352 1926307392 19.037 99 74 147 3 1989946656 41012336 22626928
23:44:05 3119 8192000000 10891847824 11306233856 1908935872 18.898 99 70 141 1 1973748064 42514592 22297600
23:44:16 5089 8192000000 10890839744 11308371968 1908241904 18.893 99 58 116 2 1971470320 43706208 19522208
23:44:28 9775 8192000000 10889568672 11307175936 1898925888 18.818 99 58 116 1 1964430992 45803936 19701168
23:44:45 6595 8192000000 10896462304 11322343424 1906230512 18.876 99 67 135 2 1974613808 45444832 22938464
23:45:00 3301 8192000000 10898679360 11314540544 1914455632 18.942 100 76 152 0 1986685008 47467488 24761888
23:45:12 4268 8192000000 10927222480 11334311936 1929116560 19.060 100 72 144 0 2001820496 48636080 24067856
23:45:29 6393 8192000000 10915691968 11337834496 1938308416 19.133 100 56 112 0 1999820336 43133744 18378176
23:45:49 9936 8192000000 10921966208 11345473536 1944456064 19.182 100 60 120 2 2009983312 45780208 19747040
23:46:10 2687 8192000000 10947215120 11363831808 1959191760 19.300 100 78 154 0 2032675440 48066400 25417280
23:46:20 2068 8192000000 10952419872 11371540480 1966670000 19.359 100 78 156 0 2039036752 47956288 24410464
23:46:29 3056 8192000000 10959259616 11373588480 1975391136 19.428 100 85 169 2 2045970800 45506016 25073648
23:46:39 2024 8192000000 10952776464 11372380160 1966521504 19.358 100 71 142 3 2035214448 46592240 22100704
23:46:49 3077 8192000000 10957100800 11372036096 1952764800 19.248 99 79 158 0 2025965248 48744624 24455824
23:47:01 5578 8192000000 10970662960 11385016320 1974761200 19.423 100 79 159 1 2049564848 50020736 24782912
23:47:19 1262 8192000000 10979270080 11391098880 1977052944 19.441 100 93 185 3 2062262192 56505792 28703456
23:47:28 2321 8192000000 10972829216 11381628928 1954910160 19.266 99 78 154 1 2035429392 56282912 24236320
23:47:39 3758 8192000000 10961074688 11384762368 1969652592 19.383 100 62 120 0 2043857888 54634192 19571104
23:47:49 2325 8192000000 10956433376 11388784640 1969151920 19.379 100 49 98 2 2040524768 54718880 16653968
23:48:06 7340 8192000000 10938972160 11377934336 1962545824 19.326 100 34 68 0 2020627696 46557824 11524048
23:48:24 5875 8192000000 10928770976 11364986880 1958378112 19.293 100 41 81 0 2011108960 39954528 12776320
23:48:37 14497 8192000000 10921110752 11359113216 1939123344 19.140 99 38 74 2 1993999824 42509024 12367456
23:49:01 10160 8192000000 10925849520 11363794944 1956356400 19.277 100 41 82 2 2014676224 44097584 14222240
23:49:19 12252 8192000000 10940214896 11374460928 1961185088 19.315 100 40 80 0 2020005264 45161376 13658800
23:49:50 11044 8192000000 10921212096 11365765120 1941567840 19.159 99 35 68 1 1999431216 45644896 12218480
23:50:16 24339 8192000000 10903241328 11351339008 1938740400 19.137 99 21 42 1 1982724272 37068480 6915392
23:50:47 21130 8192000000 10927979808 11376697344 1958905248 19.297 100 19 39 1 2005043888 39720464 6418176
23:51:23 19516 8192000000 10914597616 11370225664 1934124992 19.100 99 16 32 2 1983287280 43471232 5691056
23:51:52 18664 8192000000 10913041776 11364577280 1943776784 19.177 100 21 40 0 1996868000 45781120 7310096
23:52:47 21408 8192000000 10916684096 11365203968 1914147648 18.940 98 27 54 1 1971323872 47123824 10052400
23:53:16 28936 8192000000 10905145440 11362164736 1920613856 18.992 99 17 34 3 1982209888 54933808 6662224
23:54:10 20766 8192000000 10911645936 11376062464 1952086832 19.243 100 29 58 2 2006354656 44303232 9964592
23:54:37 29918 8192000000 10917772400 11382398976 1956237040 19.276 100 26 52 2 2000076464 35663424 8176000
23:55:21 25948 8192000000 10885736832 11363991552 1922592272 19.008 98 24 48 0 1955616240 25633712 7390256
23:56:20 69245 8192000000 10883961184 11366252544 1940417072 19.150 100 7 16 2 1962322576 19754544 2150960
23:57:36 62468 8192000000 10899019792 11354710016 1940295440 19.149 99 8 16 1 1955382656 13335728 1751488
23:58:44 34159 8192000000 10905721424 11360768000 1970088000 19.386 100 12 24 0 1986495680 13455952 2951728
23:59:25 72802 8192000000 10930747776 11382587392 1979626448 19.462 100 26 52 1 2003964144 17315904 7021792
00:00:45 42789 8192000000 10922010352 11383373824 1953378224 19.253 98 16 32 3 1977181760 19514080 4289456
00:01:34 50860 8192000000 10924297440 11381997568 1954842432 19.265 98 20 38 1 1973175040 11606000 6726608
00:02:31 94537 8192000000 10931354640 11423617024 1985826400 19.511 100 8 16 2 2015838096 27848752 2162944
00:04:25 79754 8192000000 10935495520 11387650048 1960051952 19.306 98 23 46 1 1981817536 14467552 7298032
00:06:03 70617 8192000000 10933496416 11403309056 1993164800 19.569 100 17 32 2 2009521024 11198912 5157312
00:07:28 55676 8192000000 10934951600 11406880768 1969669408 19.383 98 47 94 1 1997176176 13673760 13833008
00:08:35 88528 8192000000 10943007888 11414413312 1958083200 19.291 98 30 59 0 1987140480 20489776 8567504
00:11:42 2756 8192000000 10929250608 11415724032 1992345792 19.562 100 14 28 1 2015161072 18414704 4400576
00:11:51 18076 8192000000 10934796080 11403128832 2003521440 19.650 100 31 62 3 2023297648 10753312 9022896
00:12:22 23623 8192000000 10915210720 11384373248 1955382224 19.269 98 16 31 4 1971044096 9978000 5683872
00:12:52 24294 8192000000 10914887936 11393146880 1988595328 19.533 100 13 26 1 2003322096 10777856 3948912
00:13:24 40801 8192000000 10926101888 11388395520 1980365120 19.468 100 25 51 4 2005388144 16795136 8227888
00:14:30 29350 8192000000 10922288928 11379195904 1954863520 19.265 98 46 90 0 1977497920 9754000 12880400
00:15:07 28852 8192000000 10922936528 11386884096 1982500640 19.484 100 34 68 0 2005117648 12821776 9795232
00:15:59 35880 8192000000 10930968528 11389493248 1973314544 19.412 99 38 76 0 2000231520 15851552 11065424
00:17:09 29244 8192000000 10896210720 11373658112 1944990608 19.187 98 23 46 2 1964016240 12293072 6732560
00:17:48 37933 8192000000 10899980816 11367538688 1963607600 19.335 99 7 14 0 1975143552 9582080 1953872
00:18:32 87693 8192000000 10913660720 11388088320 1950147712 19.228 98 8 16 0 1962888816 10491168 2249936
00:20:08 90248 8192000000 10916640624 11410997248 1994124080 19.576 100 15 30 0 2016726816 18304256 4298480
00:21:57 81325 8192000000 10898952384 11375210496 1913077056 18.931 96 22 42 3 1926982320 8051760 5853504
00:23:25 59044 8192000000 10887227840 11364057088 1953418000 19.254 99 16 32 0 1967460688 9515024 4527664
00:26:00 40905 8192000000 10901234960 11382272000 1948907440 19.218 98 13 26 0 1962264576 9334256 4022880
00:26:53 65621 8192000000 10890597648 11384651776 1941067568 19.155 98 9 18 0 1958673952 14971680 2634704
00:28:05 52130 8192000000 10901662720 11370983424 1944159440 19.180 98 18 36 0 1958980576 10332128 4489008
00:29:14 33639 8192000000 10886504992 11362209792 1920901024 18.994 97 25 51 1 1935849712 8059792 6888896
00:29:57 57745 8192000000 10864692704 11333976064 1833449200 18.287 93 9 18 0 1845705120 10080288 2175632
00:31:02 59890 8192000000 10884907728 11349471232 1914223168 18.941 98 19 38 0 1932651680 13032896 5395616
00:32:08 23354 8192000000 10906917088 11364118528 1930670128 19.072 98 46 92 0 1952554752 8550128 13334496
00:32:52 45768 8192000000 10894029360 11364691968 1928620592 19.056 98 27 54 0 1948989152 12991680 7376880
00:33:52 102640 8192000000 10849681984 11326570496 1763196080 17.711 90 8 16 0 1776324240 11064368 2063792
00:35:40 57415 8192000000 10887816336 11353219072 1890159680 18.747 98 17 34 0 1914292464 19133552 4999232
00:37:42 72273 8192000000 10838769632 11317792768 1842138736 18.358 96 17 34 0 1862733552 15963232 4631584
00:39:47 72933 8192000000 10890773664 11362091008 1927299584 19.045 99 17 34 2 1941229344 9643792 4285968
00:41:12 91678 8192000000 10865759440 11349061632 1846845072 18.396 95 15 30 0 1868541584 17442304 4254208
00:42:50 40577 8192000000 10846193120 11326353408 1872973632 18.608 97 11 22 1 1895779712 19612576 3193504
00:43:36 123488 8192000000 10843398144 11311804416 1865450352 18.547 97 19 38 0 1881476672 9973840 6052480
00:46:03 54141 8192000000 10873815920 11330768896 1924082864 19.020 99 31 62 0 1940561216 8378656 8099696
00:47:03 17595 8192000000 10881416848 11338264576 1940371168 19.150 100 30 60 1 1958409808 8879648 9158992
00:47:27 51634 8192000000 10857920656 11340218368 1925317232 19.029 99 12 24 0 1936038064 7699264 3021568
00:48:31 50823 8192000000 10880542336 11361267712 1950516560 19.231 100 10 19 0 1964017520 11244896 2256064
00:49:28 23311 8192000000 10883067328 11367444480 1962904896 19.329 100 18 35 0 1976678112 8601744 5171472
00:50:26 60312 8192000000 10883216816 11359674368 1954420976 19.262 100 11 22 0 1968617184 11081008 3115200
00:51:32 45616 8192000000 10884242480 11349577728 1943411840 19.174 99 16 32 0 1963081056 14900400 4768816
00:52:27 68700 8192000000 10902779696 11378012160 1959780416 19.304 100 20 40 2 1984229152 18238288 6210448
00:54:16 55357 8192000000 10880561936 11367034880 1945848304 19.193 99 12 24 0 1965899616 16509472 3541840
00:55:18 71013 8192000000 10881611616 11365687296 1924807728 19.025 98 19 38 0 1943357856 12289232 6260896
00:56:36 47369 8192000000 10900797040 11375448064 1936121328 19.116 98 24 48 1 1954634656 11901136 6612192
00:57:31 52771 8192000000 10887712576 11373756416 1923934528 19.018 97 23 46 0 1942504064 11941248 6628288
00:58:38 127041 8192000000 10889069984 11376603136 1915358800 18.950 97 13 26 0 1934370784 15278032 3733952
01:01:24 21144 8192000000 10904341056 11364401152 1926775968 19.041 98 38 75 0 1949048672 11530960 10741744
01:01:58 65356 8192000000 10885263616 11375841280 1930404624 19.070 98 27 54 1 1953682208 16145920 7131664
01:03:13 107118 8192000000 10892894672 11375321088 1921886896 19.002 98 8 16 0 1941394144 17360944 2146304
01:05:27 74045 8192000000 10928407568 11384426496 1943474672 19.174 98 35 68 1 1966321760 13414320 9432768
01:06:49 35587 8192000000 10920444784 11395670016 1978080112 19.449 100 17 34 1 2000040256 16996096 4964048
01:07:42 139519 8192000000 10872051568 11342819328 1855116288 18.464 94 11 22 1 1870362064 12571456 2674320
01:10:45 39734 8192000000 10856267696 11330768896 1930814320 19.073 100 16 32 0 1945537792 10079376 4644096
01:11:45 35062 8192000000 10864244432 11352281088 1928534544 19.055 99 22 44 1 1950451584 15463200 6453840
01:12:31 49773 8192000000 10860309952 11348725760 1921864192 19.002 99 8 16 0 1933314080 9065952 2383936
01:13:27 39565 8192000000 10859406432 11343405056 1925666640 19.032 99 5 10 0 1934944256 7825584 1452032
01:14:13 33647 8192000000 10865165696 11347836928 1947345312 19.205 100 8 16 1 1958386624 8612272 2429040
01:14:53 96689 8192000000 10852592192 11325988864 1862109968 18.520 95 20 40 1 1875500288 7935712 5454608
01:16:40 69224 8192000000 10848990256 11325530112 1902243296 18.844 98 15 30 1 1914324320 7436288 4644736
01:18:13 43735 8192000000 10864852720 11332415488 1904578976 18.863 98 20 39 1 1920141568 9424304 6138288
01:19:06 56026 8192000000 10835818720 11321962496 1859170544 18.497 96 17 34 0 1872344464 8539488 4634432
01:20:14 51353 8192000000 10825247040 11303100416 1844299312 18.376 96 7 14 0 1852536400 6459648 1777440
01:21:17 36425 8192000000 10846897680 11319676928 1848948144 18.414 96 23 46 3 1864002544 8301968 6752432
01:22:03 39699 8192000000 10842917968 11314229248 1881243136 18.675 98 21 42 1 1898288864 11124960 5920768
01:22:50 67454 8192000000 10867139392 11338481664 1899749248 18.824 98 25 50 1 1919114672 12204560 7160864
01:24:04 74448 8192000000 10858040224 11331227648 1905257056 18.869 98 18 36 2 1923437392 13289104 4891232
01:25:30 51086 8192000000 10887995104 11363753984 1948268288 19.213 100 21 42 1 1966370256 12648800 5453168
01:26:30 57079 8192000000 10926409616 11393363968 1947695792 19.208 99 25 49 1 1970424272 15673616 7054864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-03-2021 01:29:15 to 28-03-2021 01:29:17.

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          248683
MON$OLDEST_ACTIVE               250834
MON$OLDEST_SNAPSHOT             250834
MON$NEXT_TRANSACTION            250834
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                       2049056
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:45: 
:46: mscs-test-161.budzdorov.ru    Sun Mar 28 01:27:38 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Sun Mar 28 01:27:41 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Sun Mar 28 01:27:46 2021
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
:57: 
:58: mscs-test-161.budzdorov.ru    Sun Mar 28 01:27:53 2021
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
--- end of diff output ---

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

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