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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17419400 kB
MemAvailable 31491228 kB
Buffers 0 kB
Cached 14245288 kB
SwapCached 3708 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-18 01:27:05
DTS_END                         2020-12-18 01:27:05.2540
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/43310
TRN_ID                          248446
ATT_ID                          708
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: 10023.83 17618 1202859
customer order: creation 183.66 355 22039
customer order: refuse 15.32 244 1838
order to supplier: creation 48.10 1201 5772
order to supplier: removal 3.78 82714 454
invoice (draft): creation 47.55 2691 5706
invoice (draft): removal 59.00 531 7080
invoice accept: apply 43.59 16276 5231
invoice accept: cancel 53.94 599 6473
customer reserve: creation 4035.12 163 484214
customer reserve: removal 5213.36 48 625603
realization accept: apply 87.19 167 10463
realization accept: cancel 94.92 91 11390
payment from customer: creation 63.33 121 7599
payment from customer: removal 5.97 52 716
payment to supplier: creation 52.58 152 6309
payment to supplier: removal 3.62 57 434
service: total inventory turnovers 5.31 974 637
service: total monetary turnovers 6.60 42 792
service: aggregate perf. data 0.88 20171 105
service: refresh index statistics 0.03 225717 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-12-2020 01:27:58 to 18-12-2020 01:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6369
TEST_TIME 2 5876
TEST_TIME 3 5414
TEST_TIME 4 5374
TEST_TIME 5 6436
TEST_TIME 6 6960
TEST_TIME 7 6969
TEST_TIME 8 7604
TEST_TIME 9 8377
TEST_TIME 10 8319
TEST_TIME 11 8433
TEST_TIME 12 9085
TEST_TIME 13 8932
TEST_TIME 14 9183
TEST_TIME 15 9917
TEST_TIME 16 9956
TEST_TIME 17 10398
TEST_TIME 18 10902
TEST_TIME 19 11243
TEST_TIME 20 12177
TEST_TIME 21 12040
TEST_TIME 22 13106
TEST_TIME 23 13019
TEST_TIME 24 12683
TEST_TIME 25 12487
TEST_TIME 26 12406
TEST_TIME 27 12078
TEST_TIME 28 11794
TEST_TIME 29 11829
TEST_TIME 30 11620
TEST_TIME 31 11507
TEST_TIME 32 11462
TEST_TIME 33 11438
TEST_TIME 34 11321
TEST_TIME 35 11177
TEST_TIME 36 11195
TEST_TIME 37 11084
TEST_TIME 38 11046
TEST_TIME 39 11072
TEST_TIME 40 11088
TEST_TIME 41 10983
TEST_TIME 42 11179
TEST_TIME 43 11218
TEST_TIME 44 11146
TEST_TIME 45 11106
TEST_TIME 46 11193
TEST_TIME 47 11113
TEST_TIME 48 11161
TEST_TIME 49 11264
TEST_TIME 50 11198
TEST_TIME 51 11036
TEST_TIME 52 10962
TEST_TIME 53 10821
TEST_TIME 54 10932
TEST_TIME 55 10784
TEST_TIME 56 10678
TEST_TIME 57 10689
TEST_TIME 58 10608
TEST_TIME 59 10519
TEST_TIME 60 10395
TEST_TIME 61 10476
TEST_TIME 62 10587
TEST_TIME 63 10548
TEST_TIME 64 10586
TEST_TIME 65 10542
TEST_TIME 66 10659
TEST_TIME 67 10645
TEST_TIME 68 10606
TEST_TIME 69 10714
TEST_TIME 70 10739
TEST_TIME 71 10786
TEST_TIME 72 10739
TEST_TIME 73 10752
TEST_TIME 74 10796
TEST_TIME 75 10812
TEST_TIME 76 10675
TEST_TIME 77 10653
TEST_TIME 78 10606
TEST_TIME 79 10554
TEST_TIME 80 10522
TEST_TIME 81 10480
TEST_TIME 82 10497
TEST_TIME 83 10434
TEST_TIME 84 10367
TEST_TIME 85 10354
TEST_TIME 86 10326
TEST_TIME 87 10299
TEST_TIME 88 10316
TEST_TIME 89 10313
TEST_TIME 90 10307
TEST_TIME 91 10286
TEST_TIME 92 10293
TEST_TIME 93 10310
TEST_TIME 94 10356
TEST_TIME 95 10351
TEST_TIME 96 10331
TEST_TIME 97 10404
TEST_TIME 98 10399
TEST_TIME 99 10381
TEST_TIME 100 10390
TEST_TIME 101 10351
TEST_TIME 102 10294
TEST_TIME 103 10277
TEST_TIME 104 10232
TEST_TIME 105 10195
TEST_TIME 106 10153
TEST_TIME 107 10116
TEST_TIME 108 10122
TEST_TIME 109 10164
TEST_TIME 110 10107
TEST_TIME 111 10070
TEST_TIME 112 10106
TEST_TIME 113 10103
TEST_TIME 114 10076
TEST_TIME 115 10078
TEST_TIME 116 10140
TEST_TIME 117 10128
TEST_TIME 118 10106
TEST_TIME 119 10104
TEST_TIME 120 10031

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-12-2020 01:28:02 to 18-12-2020 01:28:05.

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 1653876 1653876 0 0.00 0 27678 6 0 0
doc_list_biud 1653876 1653876 0 0.00 0 44420 22 0 0
sp_add_invoice_to_stock 5360 5231 129 2.40 59 194226 16277 0 129
sp_cancel_adding_invoice 6473 6473 0 0.00 5 61658 599 0 0
sp_cancel_client_order 1838 1838 0 0.00 4 15314 244 0 0
sp_cancel_customer_reserve 625603 625603 0 0.00 1 44422 49 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 3260 53 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 2574 58 0 0
sp_cancel_supplier_invoice 7090 7080 10 0.14 2 41571 531 0 10
sp_cancel_supplier_order 454 454 0 0.00 7 737307 82715 0 0
sp_cancel_write_off 11390 11390 0 0.00 1 12054 92 0 0
sp_client_order 22039 22039 0 0.00 3 23789 356 0 0
sp_customer_reserve 484214 484214 0 0.00 0 102237 163 0 0
sp_fill_shopping_cart 33513 33513 0 0.00 1 11983 31 0 0
sp_fill_shopping_cart_clo_res 484195 484195 0 0.00 0 14460 12 0 0
sp_get_clo_for_invoice 5210 5210 0 0.00 0 26091 253 0 0
sp_kill_cost_storno 19013 19013 0 0.00 0 13511 44 0 0
sp_kill_qstorno_ret_qs2qd 1270130 1270130 0 0.00 0 44418 26 0 0
sp_kill_qty_storno 668511 668511 0 0.00 0 44420 55 0 0
sp_lock_selected_doc 21818 21818 0 0.00 0 8539 5 0 0
sp_make_cost_storno 29581 29581 0 0.00 0 27676 57 0 0
sp_multiply_rows_for_pdistr 29581 29581 0 0.00 0 15579 28 0 0
sp_multiply_rows_for_qdistr 22039 22039 0 0.00 0 17339 154 0 0
sp_pay_from_customer 7599 7599 0 0.00 4 32904 121 0 0
sp_pay_to_supplier 6309 6309 0 0.00 4 31318 153 0 0
sp_payment_common 13908 13908 0 0.00 1 29910 38 0 0
sp_qd_handle_on_cancel_clo 1838 1838 0 0.00 0 15306 213 0 0
sp_qd_handle_on_invoice_upd_sts 11683 11683 0 0.00 0 41420 245 0 0
sp_qd_handle_on_reserve_upd_sts 10463 10463 0 0.00 0 17910 54 0 0
sp_reserve_write_off 10463 10463 0 0.00 6 17964 168 0 0
sp_supplier_invoice 5706 5706 0 0.00 7 89703 2691 0 0
sp_supplier_order 5772 5772 0 0.00 5 35706 1202 0 0
srv_aggregate_perf_data 105 105 0 0.00 2838 202849 20172 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 941 124596 34950 0 0
srv_find_qd_qs_mism 1153672 1153672 0 0.00 0 12091 5 0 0
srv_make_invnt_saldo 637 637 0 0.00 43 31414 974 0 0
srv_make_money_saldo 792 792 0 0.00 1 6495 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 140751 340074 225718 0 0
t$perf-abend:sp_add_invoice_to_stock 129 129 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 5231 5231 0 0.00 0 29671 140 0 0
t$perf-norm:sp_cancel_adding_invoice 483 483 0 0.00 0 8446 101 0 0
t$perf-norm:sp_cancel_client_order 1838 1838 0 0.00 0 1670 8 0 0
t$perf-norm:sp_cancel_customer_reserve 733 733 0 0.00 0 1926 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 12026 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 4129 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 430 430 0 0.00 0 3858 15 0 0
t$perf-norm:sp_cancel_supplier_order 454 454 0 0.00 0 33735 1353 0 0
t$perf-norm:sp_cancel_write_off 1057 1057 0 0.00 0 4615 15 0 0
t$perf-norm:sp_client_order 22039 22039 0 0.00 0 25201 17 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 8682 12 0 0
t$perf-norm:sp_pay_from_customer 7599 7599 0 0.00 0 16153 15 0 0
t$perf-norm:sp_pay_to_supplier 6309 6309 0 0.00 0 9603 9 0 0
t$perf-norm:sp_reserve_write_off 10463 10463 0 0.00 0 24852 20 0 0
t$perf-norm:sp_supplier_invoice 5706 5706 0 0.00 0 8533 18 0 0
t$perf-norm:sp_supplier_order 5772 5772 0 0.00 0 15990 15 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 91 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 276 3 0 0
t$perf-norm:srv_make_invnt_saldo 637 637 0 0.00 0 2352 14 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1497 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 25 9 0 0
v_add_invoice_to_stock 10678 10420 258 2.41 0 4259 15 0 258
v_all_customers 40566 40566 0 0.00 0 150 1 0 0
v_all_suppliers 32592 32592 0 0.00 0 110 1 0 0
v_all_wares 44078 44078 0 0.00 0 172 1 0 0
v_cancel_adding_invoice 966 966 0 0.00 0 555 7 0 0
v_cancel_client_order 3676 3676 0 0.00 0 2585 5 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 2489 7 0 0
v_cancel_customer_reserve 1466 1466 0 0.00 0 1225 6 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 885 4 0 0
v_cancel_supplier_invoice 880 860 20 2.27 0 1270 15 0 20
v_cancel_supplier_order 908 908 0 0.00 0 758 4 0 0
v_cancel_write_off 2114 2114 0 0.00 0 2538 13 0 0
v_max_id_clo_ord 5770 5770 0 0.00 0 710 1 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 1928 11 0 0
v_max_id_ord_sup 5704 5704 0 0.00 0 4088 2 0 0
v_max_non_paid_invoice 1487 1487 0 0.00 0 1617 3 0 0
v_max_non_paid_realizn 3853 3853 0 0.00 0 5393 4 0 0
v_min_id_clo_ord 5770 5770 0 0.00 0 3828 6 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 3079 7 0 0
v_min_id_ord_sup 5704 5704 0 0.00 0 4452 4 0 0
v_min_non_paid_invoice 6309 6309 0 0.00 0 27808 32 0 0
v_min_non_paid_realizn 7599 7599 0 0.00 0 21694 21 0 0
v_our_firm 11004 11004 0 0.00 0 12 1 0 0
v_reserve_write_off 20926 20926 0 0.00 0 4913 5 0 0
x_lock_depdocs_on_canc_invoice 13123 13123 0 0.00 0 17155 89 0 0
x_lock_depdocs_on_canc_sup_ord 454 454 0 0.00 0 10244 279 0 0
x_make_qstorno_1000_1200 5772 5772 0 0.00 2 35701 1139 0 0
x_make_qstorno_1200_2000 5706 5706 0 0.00 3 89696 2579 0 0
x_make_qstorno_2100_3300 484214 484214 0 0.00 0 102236 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-12-2020 01:28:06 to 18-12-2020 01:28:10.

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:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 13159 8192000000 10240586288 10541080576 874625600 9.646 69 51 102 0 894468272 2501904 17340768
22:57:38 24400 8192000000 10322345632 10637283328 1369809008 14.325 100 88 172 3 1403250240 4610368 28830864
22:58:16 31017 8192000000 10364661184 10691321856 1423201072 14.801 100 85 170 0 1457665184 6029632 28434480
22:58:55 32097 8192000000 10413254288 10742632448 1457838656 15.107 100 87 174 0 1492738880 6853232 28046992
22:59:42 22419 8192000000 10442049568 10773868544 1494340640 15.427 100 93 185 1 1531742976 7853600 29548736
23:00:21 7368 8192000000 10451928688 10784608256 1509896384 15.562 100 89 178 0 1546736368 8387536 28452448
23:00:36 23289 8192000000 10471270576 10809835520 1522249424 15.670 100 87 174 2 1558501696 8760144 27492128
23:01:13 11899 8192000000 10480446000 10825551872 1537209952 15.799 100 74 148 0 1569429888 8966960 23252976
23:01:32 18652 8192000000 10524946400 10879877120 1586557088 16.224 100 76 152 1 1618514880 8751936 23205856
23:02:02 11648 8192000000 10551240464 10908172288 1614649056 16.464 100 80 160 1 1648564192 9467472 24447664
23:02:22 11990 8192000000 10578842560 10938683392 1637314720 16.657 100 86 172 0 1673799296 10735200 25749376
23:02:42 10011 8192000000 10597413872 10961764352 1654647072 16.804 100 71 141 2 1686021584 10896624 20477888
23:03:01 8428 8192000000 10617781712 10982690816 1680357184 17.020 100 82 163 2 1716197856 11892096 23948576
23:03:17 6125 8192000000 10641031968 11005546496 1696956960 17.160 100 84 168 1 1733898160 13018400 23922800
23:03:32 6925 8192000000 10646883440 11020304384 1707349728 17.247 100 78 156 1 1743177488 13599456 22228304
23:03:46 5844 8192000000 10657939808 11030347776 1718358160 17.339 100 88 176 3 1758363728 13852208 26153360
23:04:00 8342 8192000000 10672654048 11048046592 1728518368 17.423 100 80 158 3 1764267648 12603632 23145648
23:04:16 5529 8192000000 10685594752 11062853632 1748839344 17.592 100 78 155 2 1781649632 11244480 21565808
23:04:29 4493 8192000000 10706170400 11082928128 1762056000 17.701 100 90 180 0 1800385744 13156864 25172880
23:04:41 3631 8192000000 10712429984 11088789504 1769664096 17.764 100 90 179 1 1809263280 14481472 25117712
23:04:52 3660 8192000000 10714207136 11094003712 1773437248 17.795 100 80 160 0 1810375952 14377296 22561408
23:05:02 2255 8192000000 10720331904 11099590656 1782140576 17.867 100 86 168 1 1821066480 14179344 24746560
23:05:10 3925 8192000000 10729432768 11110072320 1788168912 17.917 100 83 165 0 1825949328 14436064 23344352
23:05:21 3916 8192000000 10735934864 11117682688 1795744272 17.979 100 84 165 1 1832392368 13494432 23153664
23:05:31 2288 8192000000 10744591984 11121934336 1804607056 18.052 100 93 183 3 1844231632 14010784 25613792
23:05:40 9648 8192000000 10744729360 11130867712 1808078960 18.080 100 69 138 1 1839547072 12700448 18767664
23:05:56 2829 8192000000 10769032608 11153330176 1817830720 18.160 100 88 176 1 1856879232 14469072 24579440
23:06:05 2312 8192000000 10768362016 11155673088 1828852624 18.250 100 86 173 0 1866713504 13962080 23898800
23:06:15 2207 8192000000 10782269776 11166158848 1837148768 18.318 100 93 186 2 1877519072 15128400 25241904
23:06:24 2055 8192000000 10784594656 11168636928 1841314704 18.352 100 95 189 4 1883311824 15727744 26269376
23:06:32 2064 8192000000 10786120672 11175165952 1842734688 18.363 100 84 169 0 1879150640 12634512 23781440
23:06:40 2655 8192000000 10791896240 11181608960 1851608336 18.435 100 91 182 0 1890409504 12576496 26224672
23:06:49 2187 8192000000 10798993664 11186896896 1855289168 18.465 100 90 180 0 1893699808 12846736 25563904
23:06:58 2025 8192000000 10797707824 11186405376 1860419216 18.507 100 94 188 2 1899782368 13115152 26248000
23:07:06 1811 8192000000 10810378144 11198640128 1863490912 18.532 100 88 177 3 1900940128 13053040 24396176
23:07:14 1532 8192000000 10808041488 11195985920 1867245808 18.562 100 88 174 1 1904574624 12040656 25288160
23:07:23 4442 8192000000 10816584384 11205451776 1871068864 18.593 100 90 178 4 1909044544 13214704 24760976
23:07:34 3516 8192000000 10812947856 11209748480 1870266672 18.586 100 75 150 1 1905643232 14536976 20839584
23:07:43 1544 8192000000 10805711872 11206279168 1874452896 18.620 100 77 153 1 1909172928 13668832 21051200
23:07:51 6410 8192000000 10778740864 11193794560 1868084720 18.569 100 48 96 0 1890948928 8750944 14113264
23:08:05 41278 8192000000 10812173376 11215613952 1870729872 18.590 100 43 86 1 1890173104 6687456 12755776
23:08:52 23184 8192000000 10786276048 11215728640 1879443408 18.661 100 37 74 0 1896989488 6970384 10575696
23:09:23 2411 8192000000 10806298208 11225370624 1887527600 18.726 100 51 100 2 1909477600 6908512 15041488
23:09:32 8521 8192000000 10790253120 11221901312 1883295280 18.692 100 30 60 2 1898919984 7457472 8167232
23:09:46 5477 8192000000 10791798272 11223052288 1884598624 18.702 100 16 32 2 1895104032 6092528 4412880
23:10:04 8141 8192000000 10791001216 11230031872 1888331296 18.732 100 22 44 2 1900956000 5861984 6762720
23:10:18 9482 8192000000 10801876208 11230408704 1889184384 18.739 100 27 52 0 1903195408 7016480 6994544
23:10:36 11583 8192000000 10802180800 11233763328 1892082848 18.763 100 19 38 1 1903584448 6209824 5291776
23:10:54 7931 8192000000 10812678784 11240407040 1896600336 18.799 100 19 38 1 1909347760 7066064 5681360
23:11:08 9752 8192000000 10805312080 11243794432 1898231408 18.812 100 13 24 1 1907008240 5423600 3353232
23:11:24 11027 8192000000 10811634192 11249643520 1903414720 18.854 100 20 40 1 1914989536 6039440 5535376
23:11:42 5066 8192000000 10820299120 11250786304 1905252272 18.869 100 20 37 2 1916338320 5246976 5839072
23:11:53 10886 8192000000 10822154800 11257090048 1907012160 18.883 100 22 44 0 1924299712 11139920 6147632
23:12:12 9907 8192000000 10812326560 11252162560 1907297872 18.885 100 16 32 2 1917676336 5649568 4728896
23:12:28 13746 8192000000 10828211456 11260559360 1909754032 18.905 100 15 30 1 1919447888 5306912 4386944
23:12:49 54175 8192000000 10869530544 11279466496 1921502368 18.999 100 51 101 0 1942662784 6119424 15040992
23:13:50 5374 8192000000 10835377520 11271696384 1922256112 19.005 100 38 76 0 1942118864 9628976 10233776
23:14:02 7779 8192000000 10833899600 11266031616 1902970288 18.850 99 43 84 3 1921648368 6310400 12367680
23:14:17 3818 8192000000 10837539072 11269898240 1918106096 18.972 100 33 66 2 1934649136 6782400 9760640
23:14:27 5343 8192000000 10826715696 11263488000 1900792800 18.833 99 33 66 1 1916573248 6445168 9335280
23:14:45 3883 8192000000 10834130640 11269832704 1920619248 18.992 100 37 74 1 1938187552 6781200 10787104
23:14:55 8961 8192000000 10825414688 11257315328 1894297488 18.780 99 21 42 2 1906294640 5505712 6491440
23:15:10 5300 8192000000 10805485184 11235778560 1886471024 18.717 99 24 48 3 1899991904 6853536 6667344
23:15:24 8282 8192000000 10815996368 11250737152 1890747744 18.752 99 22 43 0 1902349488 5419504 6182240
23:15:40 7253 8192000000 10822206416 11255087104 1903919088 18.858 100 24 47 3 1916117440 5046880 7151472
23:15:54 8919 8192000000 10812300368 11258122240 1902916304 18.850 100 16 31 1 1917245488 9726752 4602432
23:16:10 65428 8192000000 10784279744 11219300352 1777565472 17.829 93 31 62 0 1792047696 5746976 8735248
23:17:22 10630 8192000000 10787630640 11211399168 1851005104 18.430 99 21 42 0 1864293408 6074688 7213616
23:17:42 4661 8192000000 10779457456 11202011136 1833617872 18.289 98 37 73 0 1851496992 7566304 10312816
23:17:52 5829 8192000000 10757076848 11179540480 1803741632 18.045 98 23 44 1 1815955840 5767152 6447056
23:18:04 7718 8192000000 10748548448 11172081664 1813131840 18.122 98 20 40 1 1824269200 5762352 5375008
23:18:20 5349 8192000000 10729449648 11148627968 1747882816 17.584 95 32 64 1 1763225696 6000992 9341888
23:18:33 9101 8192000000 10707198752 11131863040 1722782784 17.375 95 12 24 1 1731588768 5165360 3640624
23:18:50 10633 8192000000 10689998208 11100409856 1713176864 17.295 95 23 46 2 1725370464 5354592 6839008
23:19:10 9842 8192000000 10698433760 11104866304 1700490416 17.189 94 31 63 2 1714830384 5322736 9017232
23:19:28 10555 8192000000 10668227600 11073044480 1678040192 17.001 94 12 24 2 1686613984 5118912 3454880
23:19:46 6378 8192000000 10710051184 11114487808 1777944272 17.833 100 33 66 1 1793700640 5771888 9984480
23:20:02 5955 8192000000 10701778144 11120480256 1779826896 17.848 99 33 66 1 1795532192 6409056 9296240
23:20:14 19899 8192000000 10713265760 11115040768 1666972032 16.908 93 17 34 0 1676367824 5102896 4292896
23:20:40 59030 8192000000 10672008464 11089387520 1696848928 17.159 95 22 44 2 1709030896 5324976 6856992
23:21:46 8698 8192000000 10704431776 11126632448 1778770032 17.839 99 30 59 1 1793507056 6689872 8047152
23:22:01 4599 8192000000 10724394512 11145011200 1813515504 18.125 100 30 60 0 1828688384 6846416 8326464
23:22:13 8183 8192000000 10724017312 11142070272 1783819408 17.881 98 35 68 1 1799306208 6110032 9376768
23:22:29 6419 8192000000 10737773024 11158016000 1821194160 18.187 100 27 54 0 1834834320 5472480 8167680
23:22:44 6515 8192000000 10752374336 11173097472 1830768864 18.266 100 26 52 1 1843635360 5828176 7038320
23:22:59 13269 8192000000 10752006416 11177615360 1836540512 18.313 100 20 40 0 1847807792 5314976 5952304
23:23:18 5697 8192000000 10753551280 11182407680 1841070544 18.350 100 22 44 2 1854050288 6670832 6308912
23:23:30 5946 8192000000 10748465248 11179761664 1841342176 18.352 100 22 44 0 1853488544 5843056 6303312
23:23:42 7314 8192000000 10757587568 11184836608 1845211312 18.383 100 25 49 2 1858628880 6507776 6909792
23:23:57 13464 8192000000 10768989392 11188998144 1851882336 18.437 100 27 54 4 1864575904 5569584 7123984
23:24:19 8927 8192000000 10760755520 11189231616 1851334528 18.433 100 29 58 1 1865339632 5152896 8852208
23:24:35 8754 8192000000 10776334496 11200544768 1857024880 18.479 100 26 52 1 1874122048 10032320 7064848
23:24:50 11794 8192000000 10771107568 11201904640 1858327632 18.490 100 13 26 1 1867099056 4883488 3887936
23:25:10 24770 8192000000 10770261616 11211378688 1868312128 18.571 100 23 46 2 1881922688 5741744 7868816
23:26:11 32299 8192000000 10777605136 11216678912 1871725760 18.598 100 19 38 0 1882610640 5668528 5216352
23:26:52 12912 8192000000 10800569920 11228594176 1879525808 18.661 100 21 42 1 1890837920 6101872 5210240
23:27:11 26728 8192000000 10833888976 11250249728 1904777984 18.865 100 46 92 0 1923211424 5748880 12684560
23:27:46 8860 8192000000 10849758096 11269955584 1917867376 18.970 100 54 108 1 1942166912 9121296 15178240
23:28:02 5010 8192000000 10839030256 11255160832 1903296768 18.853 99 57 113 2 1927509968 8589120 15624080
23:28:16 30547 8192000000 10863890368 11284815872 1924010400 19.019 100 48 96 1 1947246768 9794576 13441792
23:28:58 13364 8192000000 10867843952 11287752704 1933743264 19.097 100 56 112 0 1960425344 11305888 15376192
23:29:24 4576 8192000000 10874111376 11296407552 1941112192 19.156 100 43 86 0 1963399552 10124320 12163040
23:29:38 36722 8192000000 10876485680 11306541056 1947126688 19.204 100 45 90 3 1971232784 11127440 12978656
23:30:25 6995 8192000000 10885744208 11314593792 1955754208 19.272 100 50 101 0 1982503872 12207472 14542192
23:30:40 17894 8192000000 10899115856 11323465728 1959241168 19.300 100 54 108 0 1988627920 14406208 14980544
23:31:13 10517 8192000000 10903192064 11327754240 1961478304 19.318 100 62 123 1 1996828304 17488736 17861264
23:31:40 21105 8192000000 10904407632 11339497472 1965249296 19.348 100 50 97 1 1996903024 17087376 14566352
23:32:18 13368 8192000000 10909737696 11341635584 1968102048 19.370 100 37 71 3 1994846016 15682976 11060992
23:32:40 9408 8192000000 10923245952 11356913664 1978765168 19.455 100 43 86 1 2014186320 23106192 12314960
23:33:02 4867 8192000000 10917941424 11352580096 1962430848 19.325 99 42 84 2 1993697184 19105600 12160736
23:33:14 1330 8192000000 10949004928 11360645120 1985660960 19.509 100 55 108 0 2019736672 17186352 16889360
23:33:22 4752 8192000000 10933516560 11365888000 1989799856 19.542 100 64 128 3 2028711312 19732784 19178672
23:33:34 7881 8192000000 10936981152 11371573248 1993648688 19.573 100 52 104 1 2028888080 19981792 15257600
23:33:53 11107 8192000000 10948806272 11383943168 1997720576 19.605 100 49 98 0 2035277072 23181536 14374960
23:34:11 9013 8192000000 10947174576 11383439360 2000908848 19.630 100 47 90 1 2035825568 21586224 13330496
23:34:27 4353 8192000000 10945073760 11371655168 1986258544 19.514 99 47 92 3 2023735136 23543264 13933328
23:34:38 5349 8192000000 10946078416 11381706752 1999878960 19.622 100 59 116 3 2042983568 25484320 17620288
23:34:51 12546 8192000000 10948930032 11381919744 1998725392 19.613 100 56 112 0 2043138272 27430608 16982272
23:35:15 8827 8192000000 10933510496 11362881536 1975053552 19.426 99 47 93 0 2016725040 27177136 14494352
23:35:35 8056 8192000000 10955313152 11382259712 1977527584 19.445 99 56 112 0 2024519296 29538656 17453056
23:35:50 4862 8192000000 10956575056 11383808000 1992387808 19.563 100 66 132 0 2044981712 32003888 20590016
23:36:03 5488 8192000000 10948028112 11384676352 1994331008 19.578 100 52 103 0 2040803776 30818768 15654000
23:36:15 3619 8192000000 10947784464 11374931968 1964483072 19.342 98 68 135 0 2010407232 25988224 19935936
23:36:30 4983 8192000000 10950635632 11381440512 1990407840 19.547 100 61 120 1 2036115184 28091728 17615616
23:36:45 5628 8192000000 10954291888 11376406528 1980058144 19.465 99 68 136 1 2027232288 26223904 20950240
23:37:00 9048 8192000000 10943347104 11371212800 1972605680 19.406 99 65 130 2 2018916464 27368320 18942464
23:37:22 4276 8192000000 10933290192 11355545600 1972243424 19.403 100 69 137 1 2025379728 32936192 20200112
23:37:33 1632 8192000000 10933682992 11353845760 1967006000 19.362 100 65 130 0 2019492096 32402320 20083776
23:37:41 2654 8192000000 10957436368 11374637056 1982781968 19.487 100 79 154 2 2044130768 37778928 23569872
23:37:50 1270 8192000000 10958778480 11367337984 1980106368 19.466 100 90 176 1 2042276256 34630592 27539296
23:37:59 3775 8192000000 10959259136 11377537024 1981367952 19.476 100 71 142 0 2038636800 35257632 22011216
23:38:09 2720 8192000000 10977138464 11391627264 1996813568 19.598 100 85 170 1 2061220352 38039280 26367504
23:38:19 6125 8192000000 10982462928 11404587008 2006015168 19.670 100 76 152 0 2066661872 37859824 22786880
23:38:32 3639 8192000000 10996348464 11417952256 2012092688 19.718 100 81 161 2 2081990912 45064512 24833712
23:38:45 7616 8192000000 10984794464 11409686528 2010239376 19.703 100 69 140 0 2073276960 40613232 22424352
23:39:06 941 8192000000 10981792320 11402174464 2003637856 19.651 100 75 149 1 2068962288 41337616 23986816
23:39:15 2982 8192000000 10990189552 11407523840 1983197120 19.490 99 75 150 0 2048518080 41722848 23598112
23:39:25 1674 8192000000 10976094896 11398172672 1997920608 19.606 100 76 151 0 2064218688 42056672 24241408
23:39:35 12307 8192000000 10960074416 11405602816 1996097888 19.592 100 59 118 0 2059761920 44710320 18953712
23:40:08 13395 8192000000 10973829664 11406901248 1987884528 19.527 99 53 106 1 2048056688 42673952 17498208
23:40:30 1743 8192000000 10969349376 11392692224 1985463952 19.508 99 74 143 3 2050425664 41859200 23102512
23:40:39 3397 8192000000 10982618080 11400769536 1996342208 19.594 100 78 154 0 2065712880 44803168 24567504
23:40:51 6788 8192000000 10975031744 11393519616 1973717872 19.415 99 74 147 3 2042323968 45118096 23488000
23:41:04 1074 8192000000 10984698384 11396194304 1991037824 19.552 100 87 170 1 2066216448 48774816 26403808
23:41:13 1221 8192000000 10991861168 11405463552 1994575296 19.580 100 87 169 0 2070996272 50328480 26092496
23:41:21 2258 8192000000 10972419792 11385839616 1973734976 19.415 99 84 166 1 2051189072 49802912 27651184
23:41:32 1410 8192000000 10988769408 11399704576 1989420304 19.539 100 79 155 1 2066234624 52570224 24244096
23:41:41 7297 8192000000 10965862288 11399458816 1988152800 19.529 100 50 100 0 2055325248 50609328 16563120
23:42:05 6617 8192000000 10973742080 11405660160 1985422688 19.508 100 50 100 0 2054811328 53097760 16290880
23:42:29 10015 8192000000 10960856656 11398516736 1984467104 19.500 100 47 94 2 2047394416 47771632 15155680
23:42:58 3058 8192000000 10980599856 11406774272 1999743392 19.621 100 64 124 0 2064588896 45910304 18935200
23:43:09 8941 8192000000 10986015808 11425128448 2010615008 19.706 100 48 96 0 2075766368 49252400 15898960
23:43:25 10861 8192000000 10998142208 11429367808 2013336208 19.728 100 46 90 0 2076823856 48783872 14703776
23:43:43 13055 8192000000 10972247520 11416219648 1966145888 19.355 98 44 88 1 2035967120 55479344 14341888
23:44:05 19604 8192000000 10938534608 11377496064 1927961600 19.051 97 41 82 2 1995768256 54142080 13664576
23:44:32 15603 8192000000 10935188048 11381612544 1947615792 19.207 99 38 76 0 2012711808 52137840 12958176
23:44:57 12320 8192000000 10943339408 11387281408 1967624160 19.367 100 44 89 2 2035588400 52383600 15580640
23:45:31 19589 8192000000 10937598624 11392188416 1949227680 19.220 99 32 61 1 2011044272 50860368 10956224
23:46:00 39797 8192000000 10928064464 11385663488 1945804576 19.193 99 31 62 1 2004928912 48602592 10521744
23:46:47 33429 8192000000 10912778752 11383279616 1949432496 19.222 99 19 38 3 1996276416 39803168 7040752
23:47:31 21664 8192000000 10896679936 11382910976 1948278816 19.213 100 13 26 0 1999142288 45996992 4866480
23:48:10 26124 8192000000 10919135184 11384885248 1957063824 19.283 100 15 31 1 2000955888 38591200 5300864
23:48:43 34423 8192000000 10909218640 11374563328 1921341392 18.998 98 15 30 1 1971249040 44656432 5251216
23:49:24 22269 8192000000 10872111152 11357573120 1902149568 18.844 98 6 12 0 1929874352 25818576 1906208
23:50:04 70769 8192000000 10852248032 11299803136 1783496480 17.878 92 18 36 0 1801363968 12797296 5070192
23:51:24 26698 8192000000 10863472400 11302297600 1913151776 18.932 100 43 87 2 1936895536 11959984 11783776
23:52:25 26310 8192000000 10832798816 11287392256 1873451088 18.612 98 39 78 0 1897334768 11405424 12478256
23:53:20 87699 8192000000 10827349872 11280650240 1831723504 18.273 96 20 41 0 1844278608 7167936 5387168
23:54:54 41660 8192000000 10848277248 11284475904 1882202496 18.683 99 30 60 0 1900711008 9437616 9070896
23:56:31 106967 8192000000 10874293984 11306893312 1832573552 18.280 96 25 50 2 1851119968 11464416 7082000
23:58:24 10945 8192000000 10879454160 11306336256 1929445456 19.062 100 52 104 2 1952490896 8970960 14074480
23:58:43 8902 8192000000 10871834704 11304497152 1915315664 18.949 99 49 96 1 1938696400 10513312 12867424
23:58:59 46175 8192000000 10867197376 11329310720 1944751008 19.185 100 53 104 1 1973531520 13464624 15315888
23:59:57 42681 8192000000 10866064000 11345416192 1939155840 19.140 100 8 16 0 1959204352 17676512 2372000
00:00:46 87379 8192000000 10875592576 11344502784 1922958464 19.011 99 8 16 0 1940009328 14934448 2116416
00:02:21 37167 8192000000 10876835792 11338686464 1948260384 19.213 100 7 14 1 1961012240 10884864 1866992
00:03:06 58659 8192000000 10879730848 11350695936 1956881216 19.281 100 19 38 0 1972214752 9301344 6032192
00:04:27 65086 8192000000 10899208816 11370340352 1968629104 19.375 100 18 36 1 1981614256 8061280 4923872
00:05:44 49439 8192000000 10915037168 11378257920 1961060544 19.314 99 16 32 2 1975267648 9826240 4380864
00:06:46 41185 8192000000 10887308832 11361587200 1949599056 19.223 99 16 31 1 1968005552 13596448 4810048
00:07:36 25129 8192000000 10925376768 11373629440 1974034176 19.417 100 46 89 0 1996632384 9830912 12767296
00:08:09 54537 8192000000 10913334256 11387453440 1981431024 19.476 100 14 28 0 1998125392 12660160 4034208
00:10:27 73112 8192000000 10922777616 11391541248 1955747360 19.272 98 25 51 1 1975697376 13140496 6809520
00:11:47 35419 8192000000 10942563968 11404611584 2000119296 19.624 100 26 52 1 2019132144 11591904 7420944
00:13:23 51510 8192000000 10924319216 11381846016 1918299952 18.973 96 13 26 0 1930767600 8996704 3470944
00:14:24 30565 8192000000 10933045536 11392700416 1981484320 19.476 100 21 42 0 1997132912 9981488 5667104
00:15:21 39296 8192000000 10903121360 11383033856 1934444480 19.102 97 12 24 1 1955508960 17477344 3587136
00:16:09 46668 8192000000 10919142432 11390935040 1933533968 19.095 98 14 28 2 1960974048 23857280 3582800
00:17:02 98477 8192000000 10912594848 11374788608 1973516816 19.413 100 10 20 0 1995346176 19282464 2546896
00:19:02 72038 8192000000 10923737824 11394134016 1971348528 19.396 99 24 48 0 1987828432 9640992 6838912
00:20:23 24366 8192000000 10929980752 11392077824 1994726448 19.581 100 33 65 3 2017242720 12927296 9588976
00:20:54 69129 8192000000 10895870304 11388874752 1955503888 19.270 98 23 46 0 1975342656 12993856 6844912
00:22:11 39253 8192000000 10898040544 11393617920 1978247664 19.451 100 17 33 3 1997781856 14823776 4710416
00:22:57 57822 8192000000 10906330864 11375046656 1937846000 19.130 98 10 20 1 1956493440 15107968 3539472
00:24:08 51400 8192000000 10883914768 11351265280 1915378976 18.950 97 17 33 2 1931954192 11943264 4631952
00:25:05 52630 8192000000 10886941808 11357540352 1927678400 19.048 98 15 30 0 1942053104 10573280 3801424
00:26:04 56277 8192000000 10931207520 11383209984 1951241072 19.236 99 15 30 0 1968979600 13279680 4458848
00:27:26 83493 8192000000 10915368160 11407622144 1977809856 19.447 100 17 34 1 2003048784 20478608 4760320
00:29:02 47913 8192000000 10877700272 11358789632 1890109648 18.747 96 9 18 0 1917477904 24706272 2661984
00:29:57 46848 8192000000 10860308304 11324411904 1858131888 18.488 95 21 42 2 1873902688 9407280 6363520
00:30:49 35149 8192000000 10867659264 11327909888 1886679504 18.719 97 29 58 0 1903027792 8185872 8162416
00:31:31 51692 8192000000 10882851776 11350007808 1914929920 18.946 98 23 46 0 1933549536 12201712 6417904
00:32:29 41507 8192000000 10880593888 11338756096 1895120656 18.787 97 25 50 1 1918338000 16057536 7159808
00:33:18 64737 8192000000 10887732192 11351875584 1931020912 19.075 99 24 48 2 1956477248 18448816 7007520
00:34:34 43852 8192000000 10874888784 11337506816 1898628752 18.815 97 24 48 1 1915705440 10413440 6663248
00:35:24 36109 8192000000 10876156432 11308703744 1855239024 18.465 95 38 76 0 1879370064 13425776 10705264
00:36:06 51805 8192000000 10881098112 11358601216 1921642976 19.000 99 32 64 1 1951538352 20683600 9211776
00:37:11 32676 8192000000 10875878464 11344920576 1868034112 18.568 96 16 32 0 1890865296 18908976 3922208
00:37:57 69639 8192000000 10865459552 11328749568 1880892208 18.672 97 9 18 1 1898472480 15178528 2401744
00:39:13 62598 8192000000 10875834064 11335344128 1859603312 18.500 96 11 22 0 1876542656 14117888 2821456
00:40:22 65436 8192000000 10865202304 11332149248 1854271792 18.457 96 19 39 0 1882041648 22387664 5382192
00:41:55 38575 8192000000 10872004528 11327516672 1904920528 18.866 99 16 32 1 1933054688 23247920 4886240
00:43:48 102540 8192000000 10841202912 11303395328 1852535152 18.443 96 28 56 0 1873644720 13033344 8076224
00:45:37 27688 8192000000 10854722576 11311136768 1899346320 18.821 99 35 70 0 1919497248 10220512 9930416
00:46:13 44052 8192000000 10857739456 11320487936 1929659344 19.064 100 38 75 0 1954567888 14770752 10137792
00:47:06 26611 8192000000 10798421152 11242000384 1830259040 18.261 95 17 34 0 1843807712 8727648 4821024
00:47:41 56261 8192000000 10826738496 11291406336 1868646112 18.573 98 10 20 3 1882109216 10790832 2672272
00:48:43 61205 8192000000 10826986096 11299151872 1872041152 18.601 98 16 32 0 1888704272 12273904 4389216
00:50:37 73362 8192000000 10829944704 11305521152 1913201616 18.932 100 12 24 0 1926188960 8947664 4039680
00:52:12 82571 8192000000 10842808688 11321438208 1906084544 18.875 99 13 26 1 1920723072 10286288 4352240
00:53:42 52111 8192000000 10847807008 11316404224 1879806864 18.664 97 8 16 0 1890409392 8291520 2311008
00:54:43 61714 8192000000 10868687936 11330928640 1935921984 19.114 100 27 54 0 1956777760 12417568 8438208
00:55:53 64499 8192000000 10868371600 11329015808 1914051296 18.939 99 17 34 0 1927990272 9180832 4758144
00:57:08 23815 8192000000 10880288688 11342331904 1949490768 19.222 100 44 88 0 1973156992 11027776 12638448
00:57:39 67479 8192000000 10888949584 11346542592 1917139808 18.964 98 22 44 1 1930197088 7199024 5858256
00:58:52 20136 8192000000 10901559072 11353939968 1961895408 19.321 100 37 74 1 1980778080 8955680 9926992
00:59:20 58795 8192000000 10911507264 11370065920 1968519440 19.374 100 32 64 1 1989766608 12149248 9097920
01:00:29 124596 8192000000 10899453808 11382071296 1934276096 19.101 98 11 22 0 1951806112 14551296 2978720
01:02:39 83425 8192000000 10923007232 11374309376 1923088032 19.012 97 16 32 0 1938169680 11032560 4049088
01:04:10 103930 8192000000 10900877584 11365912576 1856326304 18.473 94 11 22 0 1876032112 16849824 2855984
01:06:09 44381 8192000000 10866339648 11337158656 1897618320 18.807 97 14 28 1 1916081152 14672832 3790000
01:07:00 16499 8192000000 10897103984 11350720512 1942804192 19.169 99 28 56 0 1958876784 7557200 8515392
01:07:35 104009 8192000000 10907261408 11379527680 1934634752 19.104 98 20 40 2 1950824512 10947392 5242368
01:10:21 96216 8192000000 10896633408 11374329856 1954796784 19.265 99 23 47 1 1972115360 11265248 6053328
01:12:11 49194 8192000000 10893496416 11365183488 1921299536 18.997 97 17 34 0 1936643424 10421776 4922112
01:13:09 54697 8192000000 10887878768 11369828352 1950904032 19.234 99 11 22 1 1965416000 11152000 3359968
01:14:10 69765 8192000000 10895100112 11371462656 1929887168 19.066 98 18 36 1 1946613248 11535712 5190368
01:15:27 67733 8192000000 10885520896 11366494208 1932308192 19.085 98 14 27 2 1950559344 14782896 3468256
01:16:51 92721 8192000000 10855219584 11332648960 1904101840 18.859 97 15 30 0 1922113392 13684608 4326944
01:18:48 59181 8192000000 10875366240 11367747584 1950326624 19.229 100 9 17 3 1973435776 20706960 2402192
01:19:59 47807 8192000000 10864915008 11337969664 1866902560 18.559 95 18 36 0 1880828032 8995008 4930464
01:20:54 35503 8192000000 10889520000 11358801920 1955990896 19.274 100 14 28 3 1970685088 10581888 4112304
01:21:40 69243 8192000000 10872270720 11344814080 1873078928 18.609 95 22 44 0 1891783088 12562064 6142096
01:23:03 123735 8192000000 10888146304 11345661952 1826540480 18.231 93 25 50 0 1844281600 11554448 6186672
01:25:13 18771 8192000000 10903439184 11350630400 1918564752 18.975 98 48 96 0 1941382304 9891808 12925744
01:25:39 29717 8192000000 10892740784 11342405632 1928007488 19.051 99 44 88 2 1951184688 10992192 12185008
01:26:15 30134 8192000000 10891206560 11353735168 1928352480 19.054 99 36 71 2 1951276608 12955600 9968528
01:26:51 28501 8192000000 9242214048 9495928832 400136672 4.657 21 5 9 0 405423264 3892880 1393712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-12-2020 01:28:12 to 18-12-2020 01:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 129 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 18-12-2020 01:28:44 to 18-12-2020 01:28:45.

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          249146
MON$OLDEST_ACTIVE               249147
MON$OLDEST_SNAPSHOT             249147
MON$NEXT_TRANSACTION            249147
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                       2024864
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:25: 
:26: mscs-test-161.budzdorov.ru    Fri Dec 18 01:27:25 2020
:27:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:28: 
:29: 
:30: mscs-test-161.budzdorov.ru    Fri Dec 18 01:27:25 2020
:31:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:32: 
--- end of diff output ---

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

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