Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.02.2021 19: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 17272084 kB
MemAvailable 31123188 kB
Buffers 0 kB
Cached 14418940 kB
SwapCached 3904 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-02-19 19:27:21
DTS_END                         2021-02-19 19:27:21.5100
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/42452
TRN_ID                          242403
ATT_ID                          651
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: 8969.92 19426 1076390
customer order: creation 176.69 400 21203
customer order: refuse 14.77 342 1772
order to supplier: creation 44.88 1358 5385
order to supplier: removal 3.33 105216 399
invoice (draft): creation 46.19 3693 5543
invoice (draft): removal 48.96 867 5875
invoice accept: apply 42.08 17759 5049
invoice accept: cancel 44.98 868 5398
customer reserve: creation 3812.24 179 457469
customer reserve: removal 4444.31 62 533317
realization accept: apply 84.92 153 10190
realization accept: cancel 74.48 111 8938
payment from customer: creation 61.15 105 7338
payment from customer: removal 5.73 74 687
payment to supplier: creation 49.56 103 5947
payment to supplier: removal 3.62 59 434
service: total inventory turnovers 4.47 1315 537
service: total monetary turnovers 6.66 35 799
service: aggregate perf. data 0.88 16216 106
service: refresh index statistics 0.03 239611 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2021 19:28:50 to 19-02-2021 19:28:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2003
TEST_TIME 2 2860
TEST_TIME 3 3843
TEST_TIME 4 4337
TEST_TIME 5 4585
TEST_TIME 6 4479
TEST_TIME 7 4532
TEST_TIME 8 4478
TEST_TIME 9 4587
TEST_TIME 10 4988
TEST_TIME 11 5325
TEST_TIME 12 5466
TEST_TIME 13 6098
TEST_TIME 14 6460
TEST_TIME 15 6820
TEST_TIME 16 7431
TEST_TIME 17 7716
TEST_TIME 18 8034
TEST_TIME 19 8031
TEST_TIME 20 8481
TEST_TIME 21 8508
TEST_TIME 22 8784
TEST_TIME 23 9263
TEST_TIME 24 9596
TEST_TIME 25 10130
TEST_TIME 26 10443
TEST_TIME 27 10730
TEST_TIME 28 10825
TEST_TIME 29 10651
TEST_TIME 30 10547
TEST_TIME 31 10443
TEST_TIME 32 10260
TEST_TIME 33 10168
TEST_TIME 34 10180
TEST_TIME 35 10100
TEST_TIME 36 10001
TEST_TIME 37 9910
TEST_TIME 38 9752
TEST_TIME 39 9709
TEST_TIME 40 9599
TEST_TIME 41 9544
TEST_TIME 42 9597
TEST_TIME 43 9559
TEST_TIME 44 9476
TEST_TIME 45 9467
TEST_TIME 46 9363
TEST_TIME 47 9291
TEST_TIME 48 9231
TEST_TIME 49 9236
TEST_TIME 50 9234
TEST_TIME 51 9224
TEST_TIME 52 9227
TEST_TIME 53 9257
TEST_TIME 54 9231
TEST_TIME 55 9277
TEST_TIME 56 9282
TEST_TIME 57 9262
TEST_TIME 58 9272
TEST_TIME 59 9341
TEST_TIME 60 9478
TEST_TIME 61 9419
TEST_TIME 62 9468
TEST_TIME 63 9361
TEST_TIME 64 9339
TEST_TIME 65 9234
TEST_TIME 66 9280
TEST_TIME 67 9210
TEST_TIME 68 9165
TEST_TIME 69 9142
TEST_TIME 70 9085
TEST_TIME 71 9057
TEST_TIME 72 9004
TEST_TIME 73 8999
TEST_TIME 74 9013
TEST_TIME 75 9030
TEST_TIME 76 9060
TEST_TIME 77 9054
TEST_TIME 78 9032
TEST_TIME 79 9105
TEST_TIME 80 9089
TEST_TIME 81 9099
TEST_TIME 82 9168
TEST_TIME 83 9168
TEST_TIME 84 9208
TEST_TIME 85 9263
TEST_TIME 86 9160
TEST_TIME 87 9143
TEST_TIME 88 9096
TEST_TIME 89 9058
TEST_TIME 90 9026
TEST_TIME 91 8999
TEST_TIME 92 8982
TEST_TIME 93 8998
TEST_TIME 94 9013
TEST_TIME 95 9009
TEST_TIME 96 9010
TEST_TIME 97 9104
TEST_TIME 98 9112
TEST_TIME 99 9093
TEST_TIME 100 9096
TEST_TIME 101 9070
TEST_TIME 102 9165
TEST_TIME 103 9182
TEST_TIME 104 9183
TEST_TIME 105 9162
TEST_TIME 106 9120
TEST_TIME 107 9101
TEST_TIME 108 9073
TEST_TIME 109 9069
TEST_TIME 110 9032
TEST_TIME 111 8992
TEST_TIME 112 8965
TEST_TIME 113 8985
TEST_TIME 114 8956
TEST_TIME 115 8977
TEST_TIME 116 8971
TEST_TIME 117 8967
TEST_TIME 118 8978
TEST_TIME 119 9003
TEST_TIME 120 8971

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-02-2021 19:28:53 to 19-02-2021 19:28:57.

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 1501223 1501223 0 0.00 0 28604 6 0 0
doc_list_biud 1501223 1501223 0 0.00 0 32173 28 0 0
sp_add_invoice_to_stock 5158 5049 109 2.11 38 170311 17760 0 109
sp_cancel_adding_invoice 5398 5398 0 0.00 3 68762 869 0 0
sp_cancel_client_order 1772 1772 0 0.00 4 12385 342 0 0
sp_cancel_customer_reserve 533317 533317 0 0.00 1 32179 62 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 3 4591 74 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 2164 60 0 0
sp_cancel_supplier_invoice 5885 5875 10 0.16 1 15754 868 0 10
sp_cancel_supplier_order 399 399 0 0.00 7 1025162 105216 0 0
sp_cancel_write_off 8938 8938 0 0.00 1 12597 111 0 0
sp_client_order 21203 21203 0 0.00 3 20950 401 0 0
sp_customer_reserve 457469 457469 0 0.00 0 52832 180 0 0
sp_fill_shopping_cart 32115 32115 0 0.00 1 38514 43 0 0
sp_fill_shopping_cart_clo_res 457469 457469 0 0.00 0 37793 15 0 0
sp_get_clo_for_invoice 5048 5048 0 0.00 0 37745 337 0 0
sp_kill_cost_storno 15457 15457 0 0.00 0 28589 60 0 0
sp_kill_qstorno_ret_qs2qd 1081846 1081846 0 0.00 0 32156 34 0 0
sp_kill_qty_storno 570936 570936 0 0.00 0 32173 73 0 0
sp_lock_selected_doc 21023 21023 0 0.00 0 6335 4 0 0
sp_make_cost_storno 28522 28522 0 0.00 0 12994 44 0 0
sp_multiply_rows_for_pdistr 28522 28522 0 0.00 0 8988 25 0 0
sp_multiply_rows_for_qdistr 21203 21203 0 0.00 0 17937 196 0 0
sp_pay_from_customer 7338 7338 0 0.00 4 13417 106 0 0
sp_pay_to_supplier 5947 5947 0 0.00 4 15352 104 0 0
sp_payment_common 13285 13285 0 0.00 1 12847 23 0 0
sp_qd_handle_on_cancel_clo 1772 1772 0 0.00 0 12378 316 0 0
sp_qd_handle_on_invoice_upd_sts 10445 10445 0 0.00 0 28627 335 0 0
sp_qd_handle_on_reserve_upd_sts 10190 10190 0 0.00 0 11804 56 0 0
sp_reserve_write_off 10190 10190 0 0.00 6 12099 154 0 0
sp_supplier_invoice 5543 5543 0 0.00 6 114619 3693 0 0
sp_supplier_order 5385 5385 0 0.00 5 130370 1359 0 0
srv_aggregate_perf_data 106 106 0 0.00 2902 143531 16217 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1116 168679 34195 0 0
srv_find_qd_qs_mism 1028883 1028883 0 0.00 0 14402 6 0 0
srv_make_invnt_saldo 537 537 0 0.00 39 143938 1316 0 0
srv_make_money_saldo 799 799 0 0.00 0 6931 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 161138 358394 239612 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5049 5049 0 0.00 0 13156 179 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 3728 85 0 0
t$perf-norm:sp_cancel_client_order 1772 1772 0 0.00 0 7886 21 0 0
t$perf-norm:sp_cancel_customer_reserve 736 736 0 0.00 0 1853 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 2923 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 3090 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 2275 21 0 0
t$perf-norm:sp_cancel_supplier_order 399 399 0 0.00 0 31236 1958 0 0
t$perf-norm:sp_cancel_write_off 991 991 0 0.00 0 4557 9 0 0
t$perf-norm:sp_client_order 21203 21203 0 0.00 0 10967 20 0 0
t$perf-norm:sp_customer_reserve 983 983 0 0.00 0 3544 9 0 0
t$perf-norm:sp_pay_from_customer 7338 7338 0 0.00 0 11018 13 0 0
t$perf-norm:sp_pay_to_supplier 5947 5947 0 0.00 0 10931 13 0 0
t$perf-norm:sp_reserve_write_off 10190 10190 0 0.00 0 7876 12 0 0
t$perf-norm:sp_supplier_invoice 5543 5543 0 0.00 0 7517 21 0 0
t$perf-norm:sp_supplier_order 5385 5385 0 0.00 0 8554 23 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 116 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 3312 44 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 3550 25 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 5103 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10312 10094 218 2.11 0 3391 17 0 218
v_all_customers 38410 38410 0 0.00 0 14 1 0 0
v_all_suppliers 30212 30212 0 0.00 0 22 1 0 0
v_all_wares 42404 42404 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 1358 11 0 0
v_cancel_client_order 3544 3544 0 0.00 0 7157 6 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 1704 5 0 0
v_cancel_customer_reserve 1472 1472 0 0.00 0 3768 8 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 963 3 0 0
v_cancel_supplier_invoice 728 708 20 2.74 0 1348 14 0 20
v_cancel_supplier_order 798 798 0 0.00 0 1476 6 0 0
v_cancel_write_off 1982 1982 0 0.00 0 4380 16 0 0
v_max_id_clo_ord 5384 5384 0 0.00 0 2807 2 0 0
v_max_id_clo_res 983 983 0 0.00 0 2030 10 0 0
v_max_id_ord_sup 5529 5529 0 0.00 0 5272 6 0 0
v_max_non_paid_invoice 1754 1754 0 0.00 0 4681 6 0 0
v_max_non_paid_realizn 4017 4017 0 0.00 0 3272 3 0 0
v_min_id_clo_ord 5384 5384 0 0.00 0 2957 5 0 0
v_min_id_clo_res 983 983 0 0.00 0 6680 17 0 0
v_min_id_ord_sup 5529 5529 0 0.00 0 7511 11 0 0
v_min_non_paid_invoice 5947 5947 0 0.00 0 3031 10 0 0
v_min_non_paid_realizn 7338 7338 0 0.00 0 5366 11 0 0
v_our_firm 10636 10636 0 0.00 0 28 1 0 0
v_reserve_write_off 20380 20380 0 0.00 0 3738 6 0 0
x_lock_depdocs_on_canc_invoice 10919 10919 0 0.00 0 15764 114 0 0
x_lock_depdocs_on_canc_sup_ord 399 399 0 0.00 0 6377 327 0 0
x_make_qstorno_1000_1200 5385 5385 0 0.00 2 130258 1279 0 0
x_make_qstorno_1200_2000 5543 5543 0 0.00 3 114226 3522 0 0
x_make_qstorno_2100_3300 457469 457469 0 0.00 0 52829 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-02-2021 19:28:58 to 19-02-2021 19:29:02.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:31 14876 8192000000 10222388448 10527285248 800557168 8.902 64 49 100 0 820176304 2346496 17272640
16:57:54 48691 8192000000 10343744144 10660995072 1391002720 14.515 100 88 175 1 1425668576 5569408 29096448
16:58:54 18780 8192000000 10374791904 10699653120 1428084208 14.844 100 89 178 0 1464215664 6668432 29463024
16:59:26 29286 8192000000 10414943776 10740174848 1458788016 15.115 100 86 172 1 1494331712 7498944 28044752
17:00:05 21699 8192000000 10426932480 10756431872 1474454688 15.253 100 89 178 1 1511792496 8372240 28965568
17:00:44 25186 8192000000 10456610704 10795143168 1508488208 15.550 100 88 176 0 1545232400 9030976 27713216
17:01:16 22806 8192000000 10493033936 10831159296 1536109424 15.790 100 87 174 0 1572965072 9383616 27472032
17:01:48 16870 8192000000 10502995536 10850410496 1559175664 15.989 100 76 152 1 1593000992 10143744 23681584
17:02:14 18982 8192000000 10537004224 10891390976 1579450528 16.163 100 76 152 1 1613580576 10631408 23498640
17:02:44 12012 8192000000 10553064272 10913964032 1615899536 16.475 100 79 158 0 1651306720 11395648 24011536
17:03:05 12989 8192000000 10580143296 10941698048 1639790944 16.678 100 72 142 3 1671245632 10496384 20958304
17:03:28 10573 8192000000 10607251088 10969948160 1664698496 16.889 100 83 166 2 1701164672 11674528 24791648
17:03:47 12515 8192000000 10626762288 10994913280 1687559232 17.081 100 77 154 2 1721814896 11806768 22448896
17:04:10 9860 8192000000 10648796112 11023331328 1715378864 17.314 100 77 155 1 1749236016 11690160 22166992
17:04:28 6426 8192000000 10667957440 11042631680 1724680832 17.391 100 77 152 0 1758780960 12624592 21475536
17:04:42 7247 8192000000 10677824160 11056275456 1738553984 17.507 100 78 156 2 1772951072 12557616 21839472
17:04:58 7711 8192000000 10680818560 11058868224 1749539856 17.598 100 82 165 0 1786344176 13361840 23442480
17:05:13 4814 8192000000 10684042528 11065397248 1755749120 17.649 100 74 148 1 1790073520 13657728 20666672
17:05:25 3502 8192000000 10696377376 11076448256 1760105296 17.685 100 64 129 1 1791035184 13083104 17846784
17:05:36 4961 8192000000 10705925776 11088027648 1770791648 17.774 100 79 158 0 1806339200 12893952 22653600
17:05:52 10544 8192000000 10710542832 11097989120 1781078496 17.858 100 72 142 1 1814211296 13055104 20077696
17:06:09 4008 8192000000 10734071360 11123650560 1791298992 17.942 100 74 143 4 1823398064 12326432 19772640
17:06:20 3915 8192000000 10742346880 11128733696 1807643600 18.077 100 81 162 2 1843669632 12907584 23118448
17:06:31 3455 8192000000 10750916864 11141255168 1814877024 18.136 100 82 163 0 1850873600 13213760 22782816
17:06:41 3076 8192000000 10769826304 11152265216 1824909424 18.218 100 88 176 2 1863518128 13952512 24656192
17:06:51 3448 8192000000 10773319424 11156893696 1834496432 18.296 100 90 179 0 1873327296 14115296 24715568
17:07:00 2798 8192000000 10773252752 11160973312 1831045584 18.268 100 83 167 0 1868522864 13815424 23661856
17:07:10 3730 8192000000 10776984720 11164106752 1838855728 18.331 100 87 170 4 1873830928 11959520 23015680
17:07:20 2465 8192000000 10786788976 11171659776 1847938944 18.405 100 90 176 0 1886818224 13540592 25338688
17:07:30 2715 8192000000 10782398656 11172208640 1845571568 18.386 100 84 167 0 1882600656 13476416 23552672
17:07:39 1666 8192000000 10790861856 11176112128 1852772992 18.445 100 94 188 1 1891710752 12580368 26357392
17:07:48 1819 8192000000 10795042896 11183697920 1854597280 18.459 100 86 173 1 1891250496 12529136 24124080
17:07:56 2030 8192000000 10803048688 11188035584 1858519872 18.491 100 91 183 0 1897769568 13386912 25862784
17:08:04 2608 8192000000 10797249488 11188408320 1857872384 18.486 100 91 182 1 1896941680 13717056 25352240
17:08:14 2039 8192000000 10800462992 11191353344 1859681888 18.501 100 87 175 0 1897142064 12472144 24988032
17:08:23 15496 8192000000 10799625376 11190382592 1856673904 18.476 100 69 135 0 1885699072 10437376 18587792
17:08:46 10918 8192000000 10807888000 11194937344 1859969648 18.503 100 76 150 1 1892953728 11653152 21330928
17:09:03 1312 8192000000 10802011232 11197050880 1865283264 18.546 100 81 162 4 1899911552 12083328 22544960
17:09:11 6797 8192000000 10796205728 11192307712 1864241760 18.538 100 70 141 1 1894847744 10772640 19833344
17:09:24 3408 8192000000 10789122400 11200634880 1870499424 18.588 100 65 126 1 1899017072 11339136 17178512
17:09:34 3199 8192000000 10791576752 11200081920 1865944768 18.551 100 57 115 1 1890226144 8399888 15881488
17:09:43 2393 8192000000 10789859424 11199238144 1871855344 18.599 100 54 108 0 1896961328 10741888 14364096
17:09:52 4199 8192000000 10783542336 11203186688 1865279696 18.546 100 40 80 0 1889726944 13729136 10718112
17:10:06 4137 8192000000 10796862192 11200827392 1868214848 18.570 100 51 101 2 1889800352 7860480 13725024
17:10:19 2206 8192000000 10800290944 11206582272 1873944640 18.616 100 57 114 2 1899403824 9792896 15666288
17:10:27 6474 8192000000 10793491328 11202777088 1871967568 18.600 100 52 106 1 1893931808 7062832 14901408
17:10:40 8848 8192000000 10785869520 11206537216 1871827200 18.599 100 26 52 3 1885436720 6445456 7164064
17:10:56 9786 8192000000 10783522688 11216687104 1880942960 18.673 100 32 64 3 1901216512 10132400 10141152
17:11:15 9843 8192000000 10782883632 11212812288 1877153504 18.642 100 13 25 1 1885929424 5511392 3264528
17:11:32 8293 8192000000 10796361248 11224178688 1889367408 18.741 100 31 62 0 1904429520 6401536 8660576
17:11:47 7193 8192000000 10793991856 11224690688 1889374032 18.741 100 27 54 3 1903559088 6688464 7496592
17:12:02 10078 8192000000 10804857088 11231117312 1889343088 18.740 100 29 58 0 1907261808 9604240 8314480
17:12:21 10266 8192000000 10804528768 11228680192 1897261888 18.804 100 38 77 5 1913561584 5529760 10769936
17:12:38 53255 8192000000 10813289808 11240218624 1899112144 18.819 100 30 61 1 1912803872 4823184 8868544
17:13:40 20698 8192000000 10806052560 11242901504 1898056752 18.811 100 27 54 2 1911979344 6507408 7415184
17:14:07 8723 8192000000 10815764720 11251703808 1899691472 18.824 100 34 68 2 1916993040 8024480 9277088
17:14:22 4297 8192000000 10813022624 11251605504 1904625072 18.863 100 31 62 0 1921012912 7102592 9285248
17:14:35 4601 8192000000 10819431600 11252031488 1904543744 18.863 100 23 46 0 1917688432 6100368 7044320
17:14:46 6422 8192000000 10821381728 11259600896 1909446816 18.902 100 26 51 3 1927526256 10630576 7448864
17:14:59 6272 8192000000 10835469616 11258761216 1915212192 18.948 100 45 91 0 1933992368 5811232 12968944
17:15:14 6931 8192000000 10830140416 11262304256 1910643776 18.912 100 27 54 1 1925103200 6886672 7572752
17:15:29 9054 8192000000 10802912976 11242504192 1882881216 18.688 99 18 34 4 1893211728 5528912 4801600
17:15:44 8029 8192000000 10806632592 11246297088 1899550976 18.823 100 21 41 1 1911549152 5838080 6160096
17:15:59 6026 8192000000 10819977712 11249065984 1902644608 18.848 100 28 57 0 1916714864 6239360 7830896
17:16:12 9361 8192000000 10800890080 11238686720 1882697168 18.687 99 18 34 3 1893099056 5370400 5031488
17:16:27 19621 8192000000 10795721296 11233714176 1846592720 18.394 97 12 24 1 1855419840 5556288 3270832
17:16:56 10035 8192000000 10811985824 11243167744 1862039040 18.520 98 24 48 0 1875588000 6279952 7269008
17:17:17 12096 8192000000 10781199728 11214340096 1830085216 18.260 97 26 50 4 1845155280 5616080 9453984
17:17:38 69369 8192000000 10771741952 11203702784 1792410432 17.952 95 30 60 1 1806833488 5580928 8842128
17:18:56 8596 8192000000 10723098176 11142688768 1753623408 17.632 95 31 59 1 1767935872 5256080 9056384
17:19:12 4667 8192000000 10722865456 11139153920 1776281168 17.819 98 40 79 0 1794151664 6234160 11636336
17:19:22 3989 8192000000 10723796640 11132448768 1768121600 17.752 97 47 94 0 1789917104 8523776 13271728
17:19:33 3570 8192000000 10737252176 11145965568 1808990784 18.088 99 39 78 2 1828699040 9038704 10669552
17:19:43 7101 8192000000 10726159936 11136032768 1749137216 17.594 96 26 52 0 1762040112 5864352 7038544
17:19:57 6444 8192000000 10699449408 11115204608 1725027904 17.394 96 22 44 0 1736486800 5225616 6233280
17:20:10 7125 8192000000 10707508960 11110027264 1730520880 17.440 96 38 76 3 1747838416 5619440 11698096
17:20:25 7700 8192000000 10680729200 11095453696 1682916800 17.042 94 20 39 3 1694515408 5884288 5714320
17:20:39 7324 8192000000 10705396576 11123924992 1774280224 17.802 99 28 56 2 1788904032 6709088 7914720
17:20:54 7210 8192000000 10688631968 11101491200 1746869840 17.576 97 27 55 2 1764599216 10141744 7587632
17:21:11 6995 8192000000 10720359200 11134562304 1772075552 17.784 99 33 62 1 1790795312 9710480 9009280
17:21:24 12846 8192000000 10725459168 11142488064 1779652144 17.847 98 23 46 0 1791909072 5391984 6864944
17:21:45 11436 8192000000 10725775328 11147726848 1809781744 18.094 100 24 48 0 1823229440 5925824 7521872
17:22:03 10090 8192000000 10727241968 11147292672 1783129792 17.875 98 23 46 0 1795650464 5679840 6840832
17:22:21 54269 8192000000 10764497216 11180752896 1830218592 18.261 100 35 70 2 1850530288 9022912 11288784
17:23:32 10114 8192000000 10749569040 11180105728 1838114464 18.325 100 27 51 3 1855637808 10586784 6936560
17:23:49 7043 8192000000 10751244320 11178741760 1843199840 18.367 100 19 38 1 1854392112 5486736 5705536
17:24:05 4927 8192000000 10763368208 11191017472 1849390368 18.417 100 31 62 0 1866095568 8281888 8423312
17:24:16 5976 8192000000 10763204704 11186974720 1851312096 18.433 100 33 66 0 1867182048 6713264 9156688
17:24:29 8629 8192000000 10772901152 11193610240 1853326704 18.449 100 29 58 2 1866871936 5425392 8119840
17:24:46 5265 8192000000 10775426992 11197202432 1853350752 18.449 100 16 32 0 1862808112 4999328 4458032
17:24:57 5691 8192000000 10778199872 11202220032 1857017616 18.479 100 29 58 1 1870451776 5236480 8197680
17:25:11 7705 8192000000 10770016672 11199660032 1860363024 18.506 100 24 48 0 1872748976 5353216 7032736
17:25:29 9497 8192000000 10770495696 11200946176 1865773712 18.550 100 17 33 0 1875915616 5129952 5011952
17:25:46 9401 8192000000 10781345744 11206049792 1865719456 18.550 100 26 52 0 1878652464 5436576 7496432
17:26:02 9746 8192000000 10774058208 11211673600 1866854112 18.559 100 25 50 2 1881011488 5798720 8358656
17:26:20 3472 8192000000 10790382896 11213987840 1870332384 18.587 100 32 64 0 1886335616 6460352 9542880
17:26:33 8674 8192000000 10786384144 11216953344 1872340448 18.603 100 25 50 3 1884315360 4973728 7001184
17:26:51 62886 8192000000 10802682800 11229499392 1878878272 18.656 100 20 40 2 1889025456 4985872 5161312
17:29:03 39304 8192000000 10848212448 11277598720 1923706656 19.017 100 47 89 2 1943224080 6429472 13087952
17:29:51 37909 8192000000 10871553376 11303636992 1929875312 19.066 100 31 62 2 1947723408 8922064 8926032
17:30:52 15235 8192000000 10889004992 11315720192 1950821136 19.233 100 53 106 0 1978227504 11826624 15579744
17:31:15 10834 8192000000 10890320800 11315728384 1955204352 19.268 100 49 98 3 1981491824 11985584 14301888
17:31:37 32095 8192000000 10886631440 11329994752 1960928176 19.313 100 33 66 1 1983420624 12519696 9972752
17:32:21 6491 8192000000 10910812048 11336003584 1967216064 19.363 100 49 98 0 1994724928 13054384 14454480
17:32:36 7272 8192000000 10907290736 11338276864 1969872160 19.384 100 54 108 0 1999739680 14057712 15809808
17:32:50 7090 8192000000 10902496032 11336036352 1968451552 19.373 100 38 76 1 1992937632 13533440 10952640
17:33:08 3786 8192000000 10919711168 11344277504 1973886288 19.416 100 57 112 2 2004098224 13895696 16316240
17:33:21 15316 8192000000 10913108736 11347128320 1977054128 19.441 100 50 100 1 2006251136 14295088 14901920
17:34:12 14064 8192000000 10900524576 11327021056 1955708528 19.272 99 56 110 4 1989080928 15946976 17425424
17:34:35 22552 8192000000 10906156912 11341127680 1964766880 19.344 100 41 82 1 1994300816 16579792 12954144
17:35:20 13163 8192000000 10911024512 11344814080 1959747536 19.304 99 47 94 1 1993227744 19126848 14353360
17:35:44 8656 8192000000 10913185232 11346370560 1975435920 19.429 100 51 102 0 2009636032 18913968 15286144
17:36:07 7598 8192000000 10926268512 11360055296 1985039824 19.505 100 56 112 0 2021837120 19771120 17026176
17:36:24 5076 8192000000 10943819520 11365240832 1988527536 19.532 100 72 144 0 2031688320 21623968 21536816
17:36:37 2308 8192000000 10957889296 11368218624 1991307312 19.554 100 73 143 1 2035255280 22964608 20983360
17:36:47 4840 8192000000 10957762400 11379310592 1996183632 19.593 100 76 152 0 2048342912 29656752 22502528
17:37:02 2985 8192000000 10957281824 11383181312 1999372128 19.618 100 69 138 0 2046075008 25709680 20993200
17:37:18 3767 8192000000 10957866128 11380404224 2000016272 19.623 100 68 131 0 2043269040 23339136 19913632
17:37:28 2447 8192000000 10948727072 11361796096 1984940800 19.504 100 71 142 1 2029226128 22221584 22063744
17:37:39 9352 8192000000 10945394816 11369734144 1991426800 19.555 100 71 141 1 2036567792 23907344 21233648
17:37:56 3026 8192000000 10958978096 11377528832 1996328864 19.594 100 68 133 0 2040863024 25050336 19483824
17:38:07 2376 8192000000 10969431776 11387383808 2004920880 19.662 100 82 163 2 2055152288 26471040 23760368
17:38:16 2115 8192000000 10966514000 11385888768 2003139552 19.647 100 74 146 2 2052409008 27152512 22116944
17:38:26 10661 8192000000 10936719936 11354578944 1973188288 19.411 99 74 147 3 2023496368 27943520 22364560
17:38:46 4549 8192000000 10945567264 11375063040 1984453536 19.500 100 70 139 0 2033963280 28221696 21288048
17:38:57 5437 8192000000 10928685472 11349581824 1964980960 19.346 99 73 145 1 2016009360 27699280 23329120
17:39:17 6899 8192000000 10947297424 11378823168 1983262000 19.491 100 54 108 0 2030550464 29672288 17616176
17:39:32 11428 8192000000 10962276240 11394625536 1995088016 19.584 100 63 125 1 2047498832 31367952 21042864
17:39:54 8915 8192000000 10948572944 11394031616 1981497440 19.477 99 48 96 0 2032697168 35083136 16116592
17:40:11 4745 8192000000 10950706160 11390205952 1994236704 19.577 100 56 111 1 2043796816 31627824 17932288
17:40:22 5025 8192000000 10952379840 11381661696 1978620960 19.454 99 60 119 2 2026058448 28278896 19158592
17:40:36 8471 8192000000 10930041360 11354357760 1965385088 19.349 99 61 123 2 2011780416 27225056 19170272
17:40:51 2551 8192000000 10963507536 11381387264 1991031616 19.552 100 80 158 1 2047564160 30206624 26325920
17:41:02 1867 8192000000 10970046400 11390681088 1990089632 19.545 100 78 156 1 2048801472 33519232 25192608
17:41:12 6938 8192000000 10949135888 11373617152 1961817600 19.320 99 74 148 0 2024595776 39764992 23013184
17:41:29 3890 8192000000 10960786704 11383795712 1981843488 19.479 100 81 157 2 2043719392 37084896 24791008
17:41:42 1405 8192000000 10966249632 11381039104 1966318592 19.356 99 72 139 2 2026409360 38096768 21994000
17:41:52 3727 8192000000 10962075280 11383009280 1983316432 19.491 100 82 164 3 2045855728 37450944 25088352
17:42:03 2811 8192000000 10966339056 11383808000 1983028816 19.489 100 90 181 2 2048964736 37473328 28462592
17:42:12 1754 8192000000 10976395920 11386855424 1985853936 19.511 100 85 172 2 2052577248 39506992 27216320
17:42:20 3991 8192000000 10954489952 11375501312 1974955488 19.425 100 76 150 1 2038983552 40249776 23778288
17:42:31 6857 8192000000 10965173376 11390640128 1990470736 19.548 100 79 155 1 2054413936 39290944 24652256
17:42:44 4570 8192000000 10960605200 11383242752 1955084256 19.267 98 73 147 2 2019608400 41222944 23301200
17:42:58 1115 8192000000 10968372944 11391176704 1983457664 19.492 100 86 172 0 2051559696 41025504 27076528
17:43:08 4910 8192000000 10942709744 11361001472 1944661280 19.184 99 78 155 0 2012259024 42732400 24865344
17:43:20 2852 8192000000 10969165952 11385790464 1981991872 19.480 100 81 162 1 2045563968 38606192 24965904
17:43:32 3459 8192000000 10963084624 11379314688 1985037680 19.505 100 82 163 2 2051151424 40023136 26090608
17:43:43 4798 8192000000 10959450944 11383607296 1985699056 19.510 100 77 153 1 2042873744 32418816 24755872
17:43:58 5889 8192000000 10960653808 11384094720 1987727488 19.526 100 70 140 0 2042351344 32534448 22089408
17:44:11 2477 8192000000 10945347728 11358097408 1952462304 19.246 99 79 158 2 2009792432 33335856 23994272
17:44:21 3445 8192000000 10932077952 11347312640 1952950640 19.250 100 77 153 0 2010659712 34278688 23430384
17:44:31 3861 8192000000 10938925056 11356389376 1967292896 19.364 100 78 156 0 2022350192 31817520 23239776
17:44:44 3446 8192000000 10933276544 11347259392 1930349216 19.070 98 79 156 0 1985519168 31820800 23349152
17:44:54 3279 8192000000 10931119760 11348828160 1957773280 19.288 100 75 150 1 2012801744 32227616 22800848
17:45:05 4123 8192000000 10945610208 11355430912 1958932848 19.298 100 86 175 1 2018223696 32777360 26513488
17:45:21 3121 8192000000 10938179280 11360391168 1963843456 19.337 100 69 138 1 2019271568 33672800 21755312
17:45:35 3781 8192000000 10933388496 11352879104 1956302560 19.277 100 75 150 1 2015919968 35633008 23984400
17:45:52 10974 8192000000 10907754848 11348905984 1925443376 19.030 98 42 82 1 1970722720 31317760 13961584
17:46:17 3046 8192000000 10919015808 11338969088 1934174144 19.100 99 74 150 2 1990087808 32275200 23638464
17:46:28 11055 8192000000 10898573648 11326652416 1895821056 18.793 97 49 98 1 1944200240 32618448 15760736
17:46:46 4343 8192000000 10937754000 11346972672 1952234240 19.244 100 78 155 3 2013781760 36445808 25101712
17:46:57 1933 8192000000 10961817152 11373391872 1975052144 19.426 100 85 170 0 2038732624 36598816 27081664
17:47:07 7120 8192000000 10935965920 11364679680 1952070624 19.243 99 53 106 1 2009415216 39856144 17488448
17:47:25 13444 8192000000 10923267840 11368505344 1957560016 19.287 100 35 71 1 2008610560 39273824 11776720
17:47:45 13212 8192000000 10922712256 11357765632 1939489312 19.143 99 35 70 0 1992902224 41243920 12168992
17:48:05 12695 8192000000 10921392960 11355131904 1936987088 19.123 99 45 90 1 1991885968 39728864 15170016
17:48:26 11441 8192000000 10919105344 11357597696 1929997904 19.067 99 39 76 3 1985739168 42965520 12775744
17:48:44 11400 8192000000 10923800400 11357360128 1952231056 19.244 100 39 78 0 2011718848 47022672 12465120
17:49:19 19538 8192000000 10918146048 11359764480 1928445904 19.054 99 37 74 1 1985967520 45220080 12301536
17:49:56 6511 8192000000 10916181712 11346579456 1920838624 18.994 99 43 85 0 1982758208 46485632 15433952
17:50:14 11085 8192000000 10908246480 11346690048 1938741792 19.137 100 34 68 0 1995544592 45253632 11549168
17:50:37 9574 8192000000 10933239952 11360112640 1944433184 19.182 100 52 104 1 2011591360 49254320 17903856
17:50:54 6459 8192000000 10929952224 11368501248 1953974544 19.258 100 59 116 2 2020715008 47477328 19263136
17:51:16 10836 8192000000 10931133504 11365081088 1933611504 19.096 99 53 107 1 2001475696 49885568 17978624
17:51:39 22548 8192000000 10898372736 11351117824 1902025136 18.843 98 33 66 2 1960486672 46838432 11623104
17:52:14 20494 8192000000 10884129280 11336052736 1918462048 18.975 99 26 53 1 1963035168 35328592 9244528
17:52:45 36782 8192000000 10886797696 11345207296 1925100224 19.028 100 20 36 1 1969131808 36977008 7054576
17:53:39 30263 8192000000 10897623456 11346767872 1935870976 19.114 100 23 47 1 1975499584 31423152 8205456
17:54:31 44824 8192000000 10876746736 11328651264 1921597040 19.000 99 25 50 1 1949519936 19909824 8013072
17:55:23 35553 8192000000 10874163840 11323465728 1901812592 18.841 98 36 70 0 1922607840 10913104 9882144
17:56:10 73082 8192000000 10880696720 11346669568 1942123872 19.164 100 24 48 0 1967702224 18890288 6688064
17:57:31 94210 8192000000 10875652608 11339849728 1896663104 18.799 97 13 26 1 1911843344 11932880 3247360
17:59:12 76717 8192000000 10880554576 11350880256 1952034880 19.243 100 18 36 0 1973025280 15752368 5238032
18:00:36 120544 8192000000 10847497728 11323109376 1879941200 18.665 96 31 62 2 1901795952 12491440 9363312
18:02:54 68205 8192000000 10879600320 11328434176 1925113296 19.028 99 30 58 2 1944794608 11562624 8118688
18:04:16 90234 8192000000 10870791600 11323985920 1912915296 18.930 98 13 26 0 1926588384 9973248 3699840
18:05:53 22938 8192000000 10901008304 11344912384 1957934992 19.290 100 37 73 1 1978291872 10283904 10072976
18:06:23 26850 8192000000 10889418176 11349114880 1961066432 19.315 100 25 50 1 1980162128 12168144 6927552
18:06:58 63507 8192000000 10888366576 11350274048 1941910336 19.162 99 16 32 0 1957865600 11590400 4364864
18:08:10 63626 8192000000 10907802960 11374182400 1973802672 19.416 100 18 36 0 1994050272 15025792 5221808
18:09:24 72169 8192000000 10919234224 11381444608 1984864400 19.503 100 11 22 1 2000382304 12186192 3331712
18:10:50 67119 8192000000 10895934448 11372699648 1969289600 19.380 99 11 22 0 1983506864 11036496 3180768
18:12:03 76221 8192000000 10902424752 11369857024 1962759136 19.328 99 13 26 0 1976438176 10260064 3418976
18:13:53 58248 8192000000 10918653776 11380080640 1985388560 19.507 100 29 58 2 2003679568 10359840 7931168
18:14:57 107655 8192000000 10908478336 11384074240 1962143680 19.323 99 23 46 1 1984388864 15814320 6430864
18:16:53 108537 8192000000 10916483488 11367002112 1930877584 19.074 97 23 45 3 1948346560 11213024 6255952
18:18:48 154705 8192000000 10905950576 11390062592 1932829936 19.089 97 17 33 2 1947606640 10652768 4123936
18:21:29 61175 8192000000 10927058560 11390300160 1976164272 19.434 99 17 34 0 1992479472 11225952 5089248
18:22:37 96544 8192000000 10903491392 11386671104 1933007040 19.091 97 15 30 1 1947825472 10581216 4237216
18:24:21 72353 8192000000 10923058304 11382992896 1926165744 19.036 97 17 34 1 1940651712 9728144 4757824
18:25:44 36936 8192000000 10913556736 11369881600 1958677104 19.296 99 39 78 1 1985771360 16202912 10891344
18:26:34 116602 8192000000 10915055280 11388514304 1903424128 18.854 96 26 52 1 1927948208 17494080 7030000
18:28:38 168678 8192000000 10916415632 11387183104 1936372192 19.118 97 8 16 0 1956668528 18157088 2139248
18:32:06 32172 8192000000 10904409808 11329961984 1878456368 18.653 95 50 99 4 1898436416 6989248 12990800
18:32:44 40474 8192000000 10887871968 11336671232 1899805088 18.825 97 50 100 1 1924484512 9925456 14753968
18:33:55 57904 8192000000 10852037840 11333324800 1923024064 19.011 99 8 16 0 1937075440 11763312 2288064
18:35:01 29006 8192000000 10857255856 11327639552 1935424704 19.110 100 10 20 0 1948734368 10370112 2939552
18:35:43 34147 8192000000 10839883008 11319631872 1913390320 18.934 99 3 6 0 1923834832 9771376 673136
18:36:33 54812 8192000000 10870835504 11332780032 1927508192 19.047 99 27 54 2 1944330064 8453232 8368640
18:37:58 52902 8192000000 10865162640 11335196672 1929888384 19.066 99 18 36 0 1943876960 8970816 5017760
18:39:02 54523 8192000000 10841097216 11298074624 1861599472 18.516 96 8 15 0 1869638992 6117024 1922496
18:40:06 77806 8192000000 10855934064 11320537088 1883918832 18.697 97 12 24 0 1898992752 11252112 3821808
18:41:31 35660 8192000000 10876230352 11319185408 1884568144 18.702 97 29 58 3 1903195696 10590640 8036912
18:42:19 81134 8192000000 10851271728 11316654080 1898321152 18.813 98 21 42 0 1915560848 11368688 5871008
18:43:51 42613 8192000000 10789156832 11238723584 1721564656 17.365 90 26 51 1 1737685744 9190528 6930560
18:44:40 25278 8192000000 10825553456 11271901184 1869831312 18.583 99 38 76 0 1890147936 9972384 10344240
18:45:13 40344 8192000000 10848674560 11299565568 1911702256 18.920 100 43 85 1 1936558160 12851376 12004528
18:46:00 67771 8192000000 10850484656 11309256704 1902142512 18.844 99 25 50 1 1919253760 10207648 6903600
18:47:17 29122 8192000000 10849370896 11290337280 1866133648 18.553 97 39 78 0 1885802592 9282656 10386288
18:48:00 22462 8192000000 10840958160 11284865024 1875435472 18.628 98 47 94 3 1899977664 11498304 13043888
18:48:28 57153 8192000000 10834281616 11302330368 1860746032 18.509 97 32 64 4 1885746704 16414832 8585840
18:49:36 46997 8192000000 10850141552 11297042432 1889250784 18.740 99 21 42 0 1907586800 12454752 5881264
18:50:30 53505 8192000000 10857170720 11314638848 1913525088 18.935 99 41 82 1 1938849344 13888176 11436080
18:52:23 112496 8192000000 10807480880 11265421312 1849205584 18.416 96 16 32 1 1871616432 17043424 5367424
18:54:30 49626 8192000000 10870455872 11308441600 1923851696 19.018 100 47 92 2 1943148368 5995520 13301152
18:55:26 57411 8192000000 10855713312 11332374528 1937796000 19.129 100 38 76 1 1958038736 8435040 11807696
18:57:59 73715 8192000000 10854121504 11338317824 1909473792 18.902 98 12 24 0 1921663856 9191824 2998240
18:59:20 15411 8192000000 10883968272 11344257024 1950949024 19.234 100 42 81 1 1966959024 6323712 9686288
18:59:42 86746 8192000000 10884792592 11367505920 1946417600 19.198 99 16 32 1 1961297504 10394016 4485888
19:01:25 55510 8192000000 10905451168 11374387200 1960273664 19.308 99 16 32 1 1974202256 9246592 4682000
19:02:28 39870 8192000000 10897455168 11364671488 1940205744 19.148 98 23 46 0 1956227968 9434352 6587872
19:03:16 64131 8192000000 10901037680 11378737152 1958093584 19.291 99 20 40 1 1980198688 16275840 5829264
19:04:26 69819 8192000000 10896674528 11361247232 1938035696 19.131 98 18 36 2 1951406336 8560640 4810000
19:05:53 99716 8192000000 10886529984 11363405824 1912154688 18.924 97 9 18 1 1925241296 10751648 2334960
19:07:46 9094 8192000000 10924815808 11368210432 1977269472 19.443 100 56 112 3 1999194144 6919088 15005584
19:08:02 13610 8192000000 10920807472 11374665728 1979258832 19.459 100 41 82 1 2003028560 12935232 10834496
19:08:22 13485 8192000000 10929637216 11378688000 1983087952 19.489 100 36 72 0 2005743568 12863328 9792288
19:08:45 14985 8192000000 10950163680 11389673472 1991854640 19.558 100 61 122 0 2022452048 13668896 16928512
19:09:06 52376 8192000000 10926501632 11405758464 1972708912 19.407 99 44 88 0 2002789792 17763680 12317200
19:10:12 102730 8192000000 10913103696 11379384320 1942324704 19.165 98 19 39 0 1957147328 9546976 5275648
19:12:07 43246 8192000000 10913932624 11369299968 1943564272 19.175 98 15 30 0 1955826432 8169840 4092320
19:12:57 102112 8192000000 10882668352 11348660224 1932792032 19.089 98 22 44 0 1949382336 10324144 6266160
19:15:10 52478 8192000000 10881166976 11346923520 1914132096 18.940 98 31 63 2 1933891584 11498432 8261056
19:16:46 31464 8192000000 10870324928 11350949888 1954545088 19.263 100 13 26 0 1968737680 11350544 2842048
19:17:26 72066 8192000000 10872420592 11353587712 1922571136 19.007 98 11 22 0 1941135680 15763104 2801440
19:18:44 32725 8192000000 10879623296 11361587200 1957125280 19.283 100 6 12 0 1970604400 11848448 1630672
19:19:23 38646 8192000000 10884872944 11365965824 1963676976 19.335 100 11 22 0 1980375328 13734864 2963488
19:20:10 60749 8192000000 10852525184 11323568128 1844594880 18.378 94 14 28 0 1856648752 7443568 4610304
19:21:39 40454 8192000000 10860588832 11322572800 1890577088 18.750 97 22 42 2 1905345616 8625408 6143120
19:22:33 78308 8192000000 10860270768 11324706816 1834368512 18.295 95 13 25 1 1846976432 9217696 3390224
19:24:08 20026 8192000000 10847616864 11318939648 1895695952 18.792 98 25 49 3 1915077168 11695472 7685744
19:24:36 43010 8192000000 10866704880 11321769984 1878201776 18.651 97 30 60 0 1899067312 12109280 8756256
19:25:31 100694 8192000000 10826760032 11292000256 1815453856 18.141 94 21 42 1 1840012048 18096768 6461424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-02-2021 19:29:04 to 19-02-2021 19:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 109 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          239971
MON$OLDEST_ACTIVE               242756
MON$OLDEST_SNAPSHOT             242756
MON$NEXT_TRANSACTION            242756
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                       2003776
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Feb 19 19:27:33 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Fri Feb 19 19:27:34 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

19.02.21 19:29:38. 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-02-19 19:29:41 No severe PSQL-related problems occured
19.02.21 19:29:42. End of report.