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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-18 01:27:21
DTS_END                         2021-03-18 01:27:21.6230
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/41932
TRN_ID                          240031
ATT_ID                          652
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: 9221.84 21781 1106621
customer order: creation 171.11 373 20533
customer order: refuse 14.26 327 1711
order to supplier: creation 44.83 1280 5380
order to supplier: removal 3.53 101537 423
invoice (draft): creation 44.95 3234 5394
invoice (draft): removal 54.10 792 6492
invoice accept: apply 41.32 17293 4958
invoice accept: cancel 48.65 819 5838
customer reserve: creation 3751.78 173 450213
customer reserve: removal 4744.56 60 569347
realization accept: apply 84.40 199 10128
realization accept: cancel 87.37 111 10484
payment from customer: creation 60.02 117 7202
payment from customer: removal 5.98 73 717
payment to supplier: creation 49.33 117 5919
payment to supplier: removal 3.77 116 452
service: total inventory turnovers 5.02 1076 602
service: total monetary turnovers 6.03 47 723
service: aggregate perf. data 0.84 21156 101
service: refresh index statistics 0.03 286717 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3998
TEST_TIME 2 4655
TEST_TIME 3 5005
TEST_TIME 4 5206
TEST_TIME 5 4723
TEST_TIME 6 4667
TEST_TIME 7 4469
TEST_TIME 8 4933
TEST_TIME 9 4878
TEST_TIME 10 4998
TEST_TIME 11 5249
TEST_TIME 12 5255
TEST_TIME 13 5523
TEST_TIME 14 5954
TEST_TIME 15 6711
TEST_TIME 16 7331
TEST_TIME 17 7456
TEST_TIME 18 7844
TEST_TIME 19 8034
TEST_TIME 20 8300
TEST_TIME 21 8752
TEST_TIME 22 9652
TEST_TIME 23 10192
TEST_TIME 24 10585
TEST_TIME 25 10983
TEST_TIME 26 11153
TEST_TIME 27 10864
TEST_TIME 28 10719
TEST_TIME 29 10623
TEST_TIME 30 10441
TEST_TIME 31 10314
TEST_TIME 32 10329
TEST_TIME 33 10169
TEST_TIME 34 10028
TEST_TIME 35 9933
TEST_TIME 36 9846
TEST_TIME 37 9752
TEST_TIME 38 9904
TEST_TIME 39 9852
TEST_TIME 40 9878
TEST_TIME 41 9914
TEST_TIME 42 10049
TEST_TIME 43 9956
TEST_TIME 44 9968
TEST_TIME 45 10000
TEST_TIME 46 10092
TEST_TIME 47 10194
TEST_TIME 48 10089
TEST_TIME 49 10121
TEST_TIME 50 10130
TEST_TIME 51 10066
TEST_TIME 52 10101
TEST_TIME 53 10061
TEST_TIME 54 10035
TEST_TIME 55 9998
TEST_TIME 56 9850
TEST_TIME 57 9725
TEST_TIME 58 9696
TEST_TIME 59 9679
TEST_TIME 60 9682
TEST_TIME 61 9646
TEST_TIME 62 9608
TEST_TIME 63 9586
TEST_TIME 64 9577
TEST_TIME 65 9490
TEST_TIME 66 9557
TEST_TIME 67 9574
TEST_TIME 68 9609
TEST_TIME 69 9613
TEST_TIME 70 9563
TEST_TIME 71 9621
TEST_TIME 72 9649
TEST_TIME 73 9654
TEST_TIME 74 9694
TEST_TIME 75 9623
TEST_TIME 76 9746
TEST_TIME 77 9789
TEST_TIME 78 9759
TEST_TIME 79 9651
TEST_TIME 80 9625
TEST_TIME 81 9563
TEST_TIME 82 9601
TEST_TIME 83 9572
TEST_TIME 84 9538
TEST_TIME 85 9471
TEST_TIME 86 9461
TEST_TIME 87 9444
TEST_TIME 88 9469
TEST_TIME 89 9449
TEST_TIME 90 9410
TEST_TIME 91 9378
TEST_TIME 92 9437
TEST_TIME 93 9540
TEST_TIME 94 9522
TEST_TIME 95 9482
TEST_TIME 96 9527
TEST_TIME 97 9537
TEST_TIME 98 9523
TEST_TIME 99 9515
TEST_TIME 100 9529
TEST_TIME 101 9495
TEST_TIME 102 9495
TEST_TIME 103 9539
TEST_TIME 104 9462
TEST_TIME 105 9410
TEST_TIME 106 9383
TEST_TIME 107 9362
TEST_TIME 108 9365
TEST_TIME 109 9333
TEST_TIME 110 9299
TEST_TIME 111 9300
TEST_TIME 112 9251
TEST_TIME 113 9211
TEST_TIME 114 9242
TEST_TIME 115 9212
TEST_TIME 116 9258
TEST_TIME 117 9271
TEST_TIME 118 9252
TEST_TIME 119 9267
TEST_TIME 120 9223

Performance per minute, chart


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

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 1526184 1526184 0 0.00 0 17350 6 0 0
doc_list_biud 1526184 1526184 0 0.00 0 38290 28 0 0
sp_add_invoice_to_stock 5073 4958 115 2.26 37 173727 17293 0 115
sp_cancel_adding_invoice 5838 5838 0 0.00 4 70826 819 0 0
sp_cancel_client_order 1711 1711 0 0.00 4 10617 328 0 0
sp_cancel_customer_reserve 569347 569347 0 0.00 1 23865 60 0 0
sp_cancel_pay_from_customer 717 717 0 0.00 3 5566 73 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 10720 117 0 0
sp_cancel_supplier_invoice 6503 6492 11 0.16 2 16687 793 0 11
sp_cancel_supplier_order 423 423 0 0.00 5 1249756 101538 0 0
sp_cancel_write_off 10484 10484 0 0.00 1 12070 112 0 0
sp_client_order 20533 20533 0 0.00 4 27862 373 0 0
sp_customer_reserve 450213 450213 0 0.00 0 97177 174 0 0
sp_fill_shopping_cart 31298 31298 0 0.00 1 9357 33 0 0
sp_fill_shopping_cart_clo_res 450208 450208 0 0.00 0 24653 13 0 0
sp_get_clo_for_invoice 4947 4947 0 0.00 0 30013 255 0 0
sp_kill_cost_storno 17491 17491 0 0.00 0 17348 54 0 0
sp_kill_qstorno_ret_qs2qd 1156093 1156093 0 0.00 0 23831 33 0 0
sp_kill_qty_storno 609370 609370 0 0.00 0 38290 70 0 0
sp_lock_selected_doc 20825 20825 0 0.00 0 9033 7 0 0
sp_make_cost_storno 28196 28196 0 0.00 0 14233 48 0 0
sp_multiply_rows_for_pdistr 28196 28196 0 0.00 0 6366 28 0 0
sp_multiply_rows_for_qdistr 20533 20533 0 0.00 0 15811 166 0 0
sp_pay_from_customer 7202 7202 0 0.00 4 17016 117 0 0
sp_pay_to_supplier 5919 5919 0 0.00 4 22053 118 0 0
sp_payment_common 13121 13121 0 0.00 1 14729 30 0 0
sp_qd_handle_on_cancel_clo 1711 1711 0 0.00 0 10607 297 0 0
sp_qd_handle_on_invoice_upd_sts 10785 10785 0 0.00 0 38288 333 0 0
sp_qd_handle_on_reserve_upd_sts 10128 10128 0 0.00 0 31897 76 0 0
sp_reserve_write_off 10128 10128 0 0.00 6 36275 199 0 0
sp_supplier_invoice 5394 5394 0 0.00 6 84926 3235 0 0
sp_supplier_order 5380 5380 0 0.00 6 30931 1281 0 0
srv_aggregate_perf_data 101 101 0 0.00 2489 181281 21157 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1472 215007 36547 0 0
srv_find_qd_qs_mism 1060638 1060638 0 0.00 0 12865 6 0 0
srv_make_invnt_saldo 602 602 0 0.00 46 35772 1076 0 0
srv_make_money_saldo 723 723 0 0.00 1 7628 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 125804 442183 286717 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4958 4958 0 0.00 0 27433 168 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 1 25229 141 0 0
t$perf-norm:sp_cancel_client_order 1711 1711 0 0.00 0 4846 26 0 0
t$perf-norm:sp_cancel_customer_reserve 643 643 0 0.00 0 2552 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 717 717 0 0.00 0 10250 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 4834 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 10533 42 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 26289 1415 0 0
t$perf-norm:sp_cancel_write_off 1010 1010 0 0.00 0 4132 15 0 0
t$perf-norm:sp_client_order 20533 20533 0 0.00 0 10217 19 0 0
t$perf-norm:sp_customer_reserve 1012 1012 0 0.00 0 5159 16 0 0
t$perf-norm:sp_pay_from_customer 7202 7202 0 0.00 0 6258 9 0 0
t$perf-norm:sp_pay_to_supplier 5919 5919 0 0.00 0 10645 12 0 0
t$perf-norm:sp_reserve_write_off 10128 10128 0 0.00 0 6257 10 0 0
t$perf-norm:sp_supplier_invoice 5394 5394 0 0.00 0 8334 21 0 0
t$perf-norm:sp_supplier_order 5380 5380 0 0.00 0 10210 19 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 207 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 437 11 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 5128 24 0 0
t$perf-norm:srv_make_money_saldo 723 723 0 0.00 0 7864 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10124 9894 230 2.27 0 16516 20 0 230
v_all_customers 37604 37604 0 0.00 0 20 1 0 0
v_all_suppliers 29964 29964 0 0.00 0 121 1 0 0
v_all_wares 41062 41062 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 165 6 0 0
v_cancel_client_order 3422 3422 0 0.00 0 3454 5 0 0
v_cancel_customer_prepayment 1434 1434 0 0.00 0 2196 7 0 0
v_cancel_customer_reserve 1286 1286 0 0.00 0 230 3 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 5249 17 0 0
v_cancel_supplier_invoice 800 778 22 2.75 0 2128 17 0 22
v_cancel_supplier_order 846 846 0 0.00 0 1128 4 0 0
v_cancel_write_off 2020 2020 0 0.00 0 1003 12 0 0
v_max_id_clo_ord 5379 5379 0 0.00 0 910 1 0 0
v_max_id_clo_res 1012 1012 0 0.00 0 3533 17 0 0
v_max_id_ord_sup 5385 5385 0 0.00 0 4035 3 0 0
v_max_non_paid_invoice 1701 1701 0 0.00 0 1259 4 0 0
v_max_non_paid_realizn 3758 3758 0 0.00 0 3344 4 0 0
v_min_id_clo_ord 5379 5379 0 0.00 0 1828 5 0 0
v_min_id_clo_res 1012 1012 0 0.00 0 1523 5 0 0
v_min_id_ord_sup 5385 5385 0 0.00 0 4412 5 0 0
v_min_non_paid_invoice 5919 5919 0 0.00 0 12180 17 0 0
v_min_non_paid_realizn 7202 7202 0 0.00 0 6125 16 0 0
v_our_firm 10346 10346 0 0.00 0 16 1 0 0
v_reserve_write_off 20256 20256 0 0.00 0 11540 7 0 0
x_lock_depdocs_on_canc_invoice 11941 11941 0 0.00 0 24784 112 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 7562 283 0 0
x_make_qstorno_1000_1200 5380 5380 0 0.00 1 30925 1207 0 0
x_make_qstorno_1200_2000 5394 5394 0 0.00 3 84662 3122 0 0
x_make_qstorno_2100_3300 450213 450213 0 0.00 0 97171 159 0 0

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

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:25 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 19648 8192000000 10252171376 10562383872 1072301792 11.574 83 60 121 0 1096116128 2999296 20815040
22:58:01 21121 8192000000 10342131136 10656301056 1381534496 14.430 100 82 164 1 1413498960 4929504 27034960
22:58:33 39088 8192000000 10391871104 10714722304 1431360288 14.873 100 89 178 0 1466287776 5998432 28929056
22:59:21 19186 8192000000 10407232272 10738593792 1464716688 15.167 100 92 184 0 1502454704 7407184 30330832
22:59:49 22149 8192000000 10436000448 10767863808 1489352320 15.383 100 88 176 0 1525353856 7989760 28011776
23:00:24 14528 8192000000 10453165872 10788814848 1511599936 15.577 100 85 170 0 1547261200 8712720 26948544
23:00:48 25299 8192000000 10482730880 10821136384 1522127296 15.669 100 82 164 1 1557268544 9299536 25841712
23:01:21 19477 8192000000 10504326288 10845540352 1556062656 15.962 100 88 176 0 1593550800 10004208 27483936
23:01:50 13275 8192000000 10517833968 10864095232 1573851136 16.115 100 88 176 0 1611745552 10590752 27303664
23:02:12 14920 8192000000 10533512560 10885419008 1583539936 16.199 100 80 160 0 1618254960 10231376 24483648
23:02:34 13548 8192000000 10559712560 10912641024 1610970608 16.433 100 78 157 0 1645074032 10344816 23758608
23:02:55 13451 8192000000 10579296960 10938699776 1640358480 16.683 100 84 168 1 1676048224 10914288 24775456
23:03:16 9970 8192000000 10592581312 10957627392 1655363840 16.810 100 79 158 1 1690078624 11559664 23155120
23:03:35 8623 8192000000 10625939856 10987593728 1676555216 16.988 100 79 156 3 1711633536 12330672 22747648
23:03:51 6918 8192000000 10622334352 10989125632 1685490800 17.063 100 78 156 1 1720094384 11929472 22674112
23:04:06 8310 8192000000 10640612320 11008638976 1701472000 17.197 100 79 157 1 1736423824 12537152 22414672
23:04:21 7533 8192000000 10662468384 11033231360 1720801136 17.359 100 87 174 0 1759838640 13945888 25091616
23:04:37 8187 8192000000 10671749504 11043360768 1727742192 17.417 100 80 160 2 1763545904 13524784 22278928
23:04:54 3937 8192000000 10681890976 11056640000 1744973120 17.560 100 86 168 1 1782034816 12894784 24166912
23:05:05 4916 8192000000 10692010528 11070201856 1751894272 17.617 100 83 165 1 1788155504 13625024 22636208
23:05:18 6041 8192000000 10701699168 11076681728 1763262144 17.711 100 80 158 1 1798632160 14165216 21204800
23:05:31 5620 8192000000 10718929664 11095138304 1771276832 17.778 100 75 150 1 1805737824 13732944 20728048
23:05:44 3479 8192000000 10722209536 11100463104 1777730512 17.831 100 86 173 1 1815610096 13841488 24038096
23:05:55 2966 8192000000 10725543200 11103571968 1784747520 17.889 100 85 170 1 1822919216 13822656 24349040
23:06:05 4569 8192000000 10730782880 11112955904 1792172496 17.950 100 87 173 3 1830658880 14012784 24473600
23:06:16 2246 8192000000 10744955760 11119517696 1798363424 18.000 100 94 188 0 1839020336 14380928 26275984
23:06:26 8424 8192000000 10729499600 11120857088 1800126656 18.015 100 81 160 2 1836345200 14341952 21876592
23:06:43 1966 8192000000 10749054176 11134586880 1802700848 18.036 100 81 159 1 1838209824 12917824 22591152
23:06:52 2490 8192000000 10753949872 11138715648 1814812224 18.135 100 81 160 1 1848780784 10960432 23008128
23:07:01 1420 8192000000 10765371744 11150667776 1832985920 18.284 100 90 178 2 1869209696 10413664 25810112
23:07:09 1895 8192000000 10774964384 11160260608 1834214192 18.294 100 91 182 2 1872338704 12110528 26013984
23:07:17 1936 8192000000 10781410720 11170160640 1839131872 18.334 100 85 169 1 1876245264 13530736 23582656
23:07:25 1686 8192000000 10792763984 11176366080 1844384208 18.376 100 92 182 2 1882966704 13656288 24926208
23:07:34 1269 8192000000 10789170688 11177402368 1845134400 18.383 100 90 180 2 1883876816 13386944 25355472
23:07:41 1545 8192000000 10792152544 11178766336 1848271856 18.408 100 84 164 1 1885277456 13377296 23628304
23:07:49 2047 8192000000 10801077712 11187961856 1854581712 18.459 100 93 186 0 1894288512 13394016 26312784
23:07:57 2130 8192000000 10792069440 11185729536 1854718384 18.460 100 81 162 3 1890285024 13155744 22410896
23:08:06 2004 8192000000 10804352272 11194986496 1861824736 18.518 100 87 172 0 1900793168 14280928 24687504
23:08:15 7047 8192000000 10804456672 11196010496 1861289120 18.514 100 75 147 1 1896079712 13804336 20986256
23:08:28 1798 8192000000 10807094416 11202015232 1867463392 18.564 100 93 186 1 1906991968 13562608 25965968
23:08:36 20041 8192000000 10783208928 11191369728 1860712800 18.509 100 48 98 0 1883184128 8462288 14009040
23:09:03 4999 8192000000 10772331024 11191541760 1862145216 18.521 100 40 80 0 1882056096 8685088 11225792
23:09:14 7772 8192000000 10766589200 11191779328 1864088704 18.536 100 36 72 1 1881323632 7217376 10017552
23:09:28 2730 8192000000 10787333072 11199492096 1866647648 18.557 100 47 94 2 1888149168 7619056 13882464
23:09:40 9718 8192000000 10769810096 11196682240 1864400608 18.539 100 28 56 1 1878933024 6340192 8192224
23:10:00 4110 8192000000 10782812192 11208495104 1868871296 18.575 100 35 70 0 1891978736 13252624 9854816
23:10:13 5446 8192000000 10777084864 11205451776 1873313920 18.611 100 35 71 0 1889953568 6483984 10155664
23:10:26 18271 8192000000 10779943088 11208269824 1874310656 18.619 100 19 38 0 1885451040 5963008 5177376
23:10:50 10874 8192000000 10781207568 11213459456 1874000816 18.617 100 20 38 0 1886365888 7228112 5136960
23:11:11 10103 8192000000 10780087072 11214254080 1875898608 18.632 100 24 46 2 1887676224 5367296 6410320
23:11:29 9282 8192000000 10785526528 11218608128 1877471424 18.645 100 23 44 2 1890433632 6732400 6229808
23:11:51 10953 8192000000 10791619808 11219578880 1880608592 18.670 100 21 42 2 1893259728 6605392 6045744
23:12:11 67918 8192000000 10808239376 11240620032 1887959872 18.729 100 25 50 0 1900657296 5403136 7294288
23:13:26 8258 8192000000 10809086432 11240607744 1891554144 18.758 100 21 42 0 1903809696 6434320 5821232
23:13:44 6669 8192000000 10816327936 11243864064 1892396688 18.765 100 26 52 1 1906748224 6205536 8146000
23:14:01 5103 8192000000 10810647536 11244748800 1895168672 18.787 100 30 61 2 1911090976 7537120 8385184
23:14:13 6230 8192000000 10815360512 11243933696 1896907056 18.801 100 26 52 0 1909830896 5847744 7076096
23:14:28 5173 8192000000 10820067968 11250151424 1900770784 18.832 100 35 71 1 1918371264 7668304 9932176
23:14:43 7728 8192000000 10813921056 11249258496 1898882016 18.817 100 28 55 1 1912881776 5970288 8029472
23:14:57 6366 8192000000 10819125056 11255320576 1904857424 18.865 100 45 89 2 1924612096 6852880 12901792
23:15:12 4851 8192000000 10815154320 11254697984 1904476288 18.862 100 13 26 0 1913420160 5495824 3448048
23:15:25 6487 8192000000 10824859776 11254439936 1904494112 18.862 100 24 49 1 1916201712 5634432 6073168
23:15:38 5065 8192000000 10838136000 11258638336 1885751136 18.712 99 25 50 1 1902869952 9334256 7784560
23:15:54 7753 8192000000 10803396384 11240083456 1864739728 18.542 98 19 37 0 1875173616 5095296 5338592
23:16:11 12353 8192000000 10785547440 11225878528 1849275664 18.416 98 12 24 0 1857750992 5016944 3458384
23:16:33 8134 8192000000 10798847056 11228868608 1843895584 18.373 98 20 40 0 1854191728 4602672 5693472
23:17:24 16506 8192000000 10834295344 11235344384 1872468400 18.604 99 67 133 3 1898411120 6005456 19937264
23:17:46 5996 8192000000 10792758992 11220480000 1861683392 18.517 99 39 78 1 1881150544 9359744 10107408
23:18:00 7202 8192000000 10783772832 11202019328 1826349088 18.230 98 35 70 1 1842635536 6386864 9899584
23:18:14 5153 8192000000 10761224640 11184336896 1820708784 18.183 98 30 60 0 1835467792 6232000 8527008
23:18:26 5153 8192000000 10750210976 11167678464 1815459856 18.141 99 27 54 1 1830184704 6796624 7928224
23:18:39 2898 8192000000 10756626256 11177463808 1823204192 18.204 99 34 68 3 1845640432 11962096 10474144
23:18:49 6639 8192000000 10738774672 11163455488 1798606320 18.002 98 21 42 2 1810227168 5387232 6233616
23:19:02 6421 8192000000 10752437120 11162062848 1796034240 17.981 98 23 46 0 1809607568 6173776 7399552
23:19:16 10258 8192000000 10732384624 11149950976 1741009232 17.527 95 22 44 3 1753243520 5820032 6414256
23:19:33 7503 8192000000 10706590816 11126247424 1723457728 17.381 95 20 38 1 1733406000 4528576 5419696
23:19:47 6041 8192000000 10693309952 11109134336 1745281248 17.562 97 24 46 2 1757791664 5139616 7370800
23:20:00 8243 8192000000 10703333056 11108884480 1728119552 17.420 96 17 33 1 1738532704 5389760 5023392
23:20:15 12000 8192000000 10716064832 11135270912 1753222592 17.628 97 17 34 0 1767359328 9668608 4468128
23:20:36 6594 8192000000 10701614592 11116933120 1745020048 17.560 97 25 50 2 1757943648 5506208 7417392
23:20:50 14691 8192000000 10718274992 11134812160 1747175392 17.578 96 27 54 3 1759999776 4580992 8243392
23:21:17 65726 8192000000 10700774176 11122409472 1749491408 17.597 97 22 44 0 1760674432 4711136 6471888
23:22:36 5182 8192000000 10719806992 11142565888 1799278160 18.008 99 25 50 1 1814112096 6933456 7900480
23:22:47 3829 8192000000 10739476112 11159154688 1808911984 18.087 99 38 76 1 1826777040 6804608 11060448
23:22:57 7349 8192000000 10736049728 11160301568 1820646512 18.183 100 39 76 1 1843268304 11817152 10804640
23:23:16 3698 8192000000 10734512736 11161264128 1813466256 18.124 99 21 40 2 1825124960 5713776 5944928
23:23:27 9514 8192000000 10762472688 11174371328 1818339856 18.164 99 25 50 1 1831506256 6100112 7066288
23:23:43 5911 8192000000 10759671936 11180630016 1836414240 18.312 100 38 76 2 1857919616 10437680 11067696
23:23:58 5123 8192000000 10756627520 11186364416 1841882288 18.356 100 24 48 1 1858969984 10199440 6888256
23:24:10 8147 8192000000 10761251088 11190714368 1847436320 18.401 100 20 40 0 1859239728 6182720 5620688
23:24:28 6611 8192000000 10763916048 11195019264 1849153056 18.415 100 19 38 1 1859783552 5321648 5308848
23:24:42 8762 8192000000 10787277792 11207749632 1856801776 18.477 100 27 54 1 1870164848 5791760 7571312
23:24:57 9111 8192000000 10772840080 11202506752 1857934512 18.487 100 30 59 2 1876423600 9734832 8754256
23:25:16 12108 8192000000 10784502464 11208945664 1860649392 18.509 100 21 42 2 1876347744 9710992 5987360
23:25:35 13711 8192000000 10789749360 11210698752 1862847376 18.526 100 24 48 1 1875134896 5737008 6550512
23:25:55 59445 8192000000 10776675280 11214102528 1869099232 18.577 100 49 98 2 1894389776 10499184 14791360
23:27:01 14566 8192000000 10798723904 11227807744 1881342992 18.676 100 22 44 0 1893199168 5284080 6572096
23:27:22 13640 8192000000 10819456176 11242029056 1894033392 18.778 100 38 72 1 1910153792 4997088 11123312
23:27:44 15312 8192000000 10835937744 11256107008 1908843520 18.897 100 52 102 1 1931053696 7156080 15054096
23:28:13 45172 8192000000 10845106720 11271553024 1918724976 18.977 100 64 125 1 1945229696 9382320 17122400
23:29:07 2362 8192000000 10855291616 11279183872 1923143088 19.012 100 46 92 2 1947507920 11953568 12411264
23:29:18 12096 8192000000 10865955872 11285676032 1928737232 19.057 100 51 100 0 1954338528 11200608 14400688
23:29:40 21400 8192000000 10870577216 11296010240 1932950992 19.090 100 52 102 1 1959523408 12019536 14552880
23:30:09 6260 8192000000 10876672432 11301257216 1940526576 19.151 100 55 110 1 1970905328 13859296 16519456
23:30:28 31668 8192000000 10871678832 11307339776 1930556800 19.071 99 53 106 0 1960222368 13935888 15729680
23:31:10 19298 8192000000 10894270944 11328339968 1952672576 19.248 100 45 88 3 1988891424 23013568 13205280
23:31:40 9982 8192000000 10907354496 11333165056 1962245200 19.324 100 49 98 0 1996746736 18760848 15740688
23:31:59 37353 8192000000 10912791232 11350843392 1971032480 19.394 100 46 91 0 2006754976 22199488 13523008
23:33:10 11912 8192000000 10919225536 11355680768 1976198240 19.435 100 43 87 1 2014885136 25913456 12773440
23:33:30 13476 8192000000 10925679440 11362091008 1979236528 19.459 100 48 94 2 2019643904 25906000 14501376
23:34:00 14151 8192000000 10945178000 11376005120 1991758832 19.558 100 58 112 5 2036838016 27347072 17732112
23:34:23 21326 8192000000 10954084368 11383812096 1996699984 19.597 100 56 112 1 2043314464 29492592 17121888
23:34:59 6943 8192000000 10961912672 11389153280 2000031808 19.623 100 58 115 2 2047771200 29809600 17929792
23:35:15 10605 8192000000 10957423072 11392094208 2003207632 19.648 100 58 117 0 2051573216 30088800 18276784
23:35:40 9839 8192000000 10955947968 11388956672 1996356064 19.594 100 58 115 2 2051292576 36679792 18256720
23:36:06 12907 8192000000 10961655280 11388669952 1999680928 19.620 100 61 123 2 2050038016 31261696 19095392
23:36:31 4375 8192000000 10955994640 11381432320 1991157376 19.553 100 62 124 1 2043462384 32901312 19403696
23:37:03 8609 8192000000 10955664576 11380240384 1973646704 19.414 99 61 122 1 2027100544 34301008 19152832
23:37:19 11970 8192000000 10952551616 11383955456 1990223904 19.546 100 50 100 0 2039854432 33925216 15705312
23:37:44 8031 8192000000 10957177216 11382771712 1991410688 19.555 100 58 117 2 2043908352 33660544 18837120
23:38:01 2624 8192000000 10954821888 11372695552 1973315936 19.412 99 78 153 1 2031181168 34406176 23459056
23:38:11 3504 8192000000 10957995600 11379388416 1984811552 19.503 100 74 145 1 2044878288 38532368 21534368
23:38:22 8227 8192000000 10964516848 11388071936 1996263616 19.593 100 66 130 1 2051934256 35527024 20143616
23:38:39 2342 8192000000 10974045600 11397537792 2003863792 19.653 100 74 148 2 2063279312 36639488 22776032
23:38:50 1801 8192000000 10984758432 11407097856 2014929328 19.740 100 75 150 0 2074781760 35715248 24137184
23:39:01 2857 8192000000 10972584576 11390922752 1995189152 19.585 99 78 157 0 2056862224 37028208 24644864
23:39:13 8068 8192000000 10976033808 11404787712 2003545968 19.651 100 62 124 1 2059695888 37301904 18848016
23:39:31 3297 8192000000 10998604128 11417014272 2015268368 19.743 100 87 171 0 2079562656 37848928 26445360
23:39:41 3226 8192000000 10991878896 11413331968 2014169808 19.734 100 83 165 2 2078719696 39569264 24980624
23:39:51 3723 8192000000 10979592800 11397181440 1993068896 19.568 99 83 166 0 2060146368 41553344 25524128
23:40:02 1767 8192000000 10997444560 11411320832 2005455760 19.666 100 93 187 1 2081115488 47205664 28454064
23:40:11 3460 8192000000 10990391216 11403165696 1990145264 19.545 99 76 152 2 2055890272 41431728 24313280
23:40:22 1492 8192000000 10995162048 11411288064 2010493536 19.705 100 91 184 3 2081735120 42535776 28705808
23:40:30 2456 8192000000 10999411872 11418845184 2008295376 19.688 100 85 166 3 2077961728 43463376 26202976
23:40:39 2699 8192000000 10991688064 11403362304 1998805168 19.613 100 91 182 2 2072726832 45374432 28547232
23:40:49 4497 8192000000 10995644560 11404148736 1996818640 19.598 100 89 178 2 2070998000 45968176 28211184
23:41:02 4930 8192000000 10973298672 11399331840 1977863424 19.448 99 82 164 1 2052125232 48124000 26137808
23:41:15 2625 8192000000 10969813024 11381841920 1974578320 19.422 99 84 164 2 2045306480 45282784 25445376
23:41:28 2776 8192000000 10966920080 11386363904 1969700784 19.383 99 76 152 1 2040944384 46930128 24313472
23:41:41 5293 8192000000 10960603664 11386859520 1963662784 19.335 99 83 166 1 2038251168 48235408 26352976
23:41:57 11538 8192000000 10963829248 11395936256 1979033440 19.457 100 56 112 1 2050260736 52321760 18905536
23:42:17 2493 8192000000 10998813152 11410198528 1989925584 19.543 100 86 164 3 2067628672 50602112 27100976
23:42:29 2840 8192000000 10982389664 11405221888 1973474160 19.413 99 80 160 0 2053365024 53331280 26559584
23:42:38 2087 8192000000 10981730480 11399843840 1967208288 19.363 99 89 177 0 2048956992 53619488 28129216
23:42:48 5030 8192000000 10936687264 11356336128 1930234416 19.069 98 75 148 0 2005584512 51712016 23638080
23:43:01 4569 8192000000 10923482608 11341496320 1911112048 18.916 98 69 138 0 1981680288 48700688 21867552
23:43:13 2821 8192000000 10944685424 11358617600 1958557408 19.295 100 78 153 2 2026599072 43632976 24408688
23:43:22 3710 8192000000 10927586576 11352477696 1948151264 19.212 100 74 148 2 2014985712 43489424 23345024
23:43:37 7676 8192000000 10927480336 11360342016 1952454144 19.246 100 49 97 1 2012568528 44103936 16010448
23:43:52 9440 8192000000 10929609424 11370663936 1961288272 19.316 100 45 89 3 2020047632 44492656 14266704
23:44:10 4401 8192000000 10928851296 11356733440 1925093488 19.028 98 46 91 1 1981282400 41873888 14315024
23:44:21 7634 8192000000 10930783360 11357552640 1952640208 19.247 100 56 108 2 2014306912 44710880 16955824
23:44:47 7306 8192000000 10926715392 11357986816 1946692368 19.200 100 50 101 1 2009795536 47655024 15448144
23:45:04 1583 8192000000 10959410784 11368198144 1959498768 19.302 100 84 166 0 2038192432 52167888 26525776
23:45:12 7045 8192000000 10937259456 11366113280 1935922160 19.114 99 51 102 5 2004776928 52206848 16647920
23:45:26 3135 8192000000 10949834288 11365007360 1954799664 19.265 100 75 150 2 2025971728 47622256 23549808
23:45:35 1543 8192000000 10960333968 11373514752 1962989648 19.330 100 76 153 1 2036397936 49420576 23987712
23:45:43 1472 8192000000 10971783936 11380453376 1968061840 19.370 100 86 172 1 2045469712 51134144 26273728
23:45:53 5067 8192000000 10960803280 11384451072 1971074800 19.394 100 65 130 1 2044565280 52597520 20892960
23:46:21 10998 8192000000 10903239232 11335544832 1883673424 18.695 96 47 94 0 1948790256 48788272 16328560
23:46:39 5112 8192000000 10923952400 11344072704 1922636816 19.008 99 51 101 1 1990913728 51181280 17095632
23:47:03 10323 8192000000 10890914224 11322527744 1906616128 18.879 99 45 91 1 1975175408 53374208 15185072
23:47:22 10217 8192000000 10904146096 11334471680 1890177776 18.747 98 49 94 1 1963100768 57038192 15884800
23:47:47 9045 8192000000 10907710432 11343196160 1905766848 18.873 99 42 84 0 1975720224 55292976 14660400
23:48:18 6532 8192000000 10934578544 11361042432 1934965456 19.107 100 52 104 0 2014136208 61339520 17831232
23:48:31 6557 8192000000 10924363232 11357446144 1933593264 19.096 100 55 110 2 2012849344 61057952 18198128
23:48:49 27991 8192000000 10901958560 11349999616 1915925776 18.954 99 30 60 1 1984463024 58015648 10521600
23:49:24 39212 8192000000 10895340688 11352035328 1935563280 19.111 100 29 58 0 1994747968 48655008 10529680
23:50:14 63673 8192000000 10879187680 11340193792 1912472256 18.926 99 14 28 4 1952048592 34817328 4759008
23:51:36 64815 8192000000 10866182576 11326119936 1911859984 18.922 99 10 21 0 1939293008 24354432 3078592
23:53:13 26620 8192000000 10888540944 11343585280 1934991840 19.107 99 22 44 3 1954596672 12604672 7000160
23:53:47 67150 8192000000 10899529392 11338842112 1928626160 19.056 99 16 33 1 1943770144 10676016 4467968
23:55:01 76190 8192000000 10871802288 11316617216 1886529760 18.718 97 25 50 0 1901246416 8259568 6457088
23:56:24 62851 8192000000 10858597568 11301040128 1875096544 18.625 97 22 43 1 1889270416 8065424 6108448
23:57:51 64227 8192000000 10861089760 11315916800 1853498608 18.451 95 30 60 1 1871387424 9378992 8509824
23:59:01 56155 8192000000 10851471520 11302907904 1880250736 18.667 97 21 42 0 1899887200 13842976 5793488
00:00:05 78933 8192000000 10881463168 11339403264 1931013600 19.075 99 22 44 0 1948036880 10008544 7014736
00:01:31 43406 8192000000 10900017328 11348582400 1944249568 19.181 99 38 74 2 1969922576 14452336 11220672
00:02:22 35107 8192000000 10922157760 11366055936 1970729792 19.391 100 38 76 0 2002862384 19258800 12873792
00:03:10 36444 8192000000 10920809376 11369578496 1956420096 19.278 99 34 68 2 1993052592 25347472 11285024
00:04:05 55475 8192000000 10912089632 11369582592 1969579152 19.382 100 29 58 0 2006864576 27613376 9672048
00:05:43 48324 8192000000 10865633168 11332673536 1930472640 19.071 99 17 34 0 1962153376 25686304 5994432
00:06:41 25380 8192000000 10853199808 11310964736 1907715712 18.888 98 11 22 1 1934171152 23037568 3417872
00:07:43 95520 8192000000 10879179632 11341496320 1913640912 18.936 98 20 40 2 1937922656 16970368 7311376
00:09:33 61023 8192000000 10890158624 11357773824 1958756624 19.296 100 10 19 3 1972670144 11147088 2766432
00:10:42 44809 8192000000 10893664192 11373162496 1959599536 19.303 100 10 20 0 1970923888 8485776 2838576
00:11:33 32181 8192000000 10916108656 11381129216 1973250240 19.411 100 14 28 1 1994701392 17546432 3904720
00:12:11 72146 8192000000 10921961136 11405762560 1980209424 19.466 100 13 26 2 2008980688 24564448 4206816
00:13:30 61835 8192000000 10900849392 11376664576 1956479744 19.278 99 13 27 0 1983094448 22352032 4262672
00:14:38 61563 8192000000 10910687136 11367198720 1964081200 19.338 99 20 40 1 1979217552 8742224 6394128
00:15:46 31960 8192000000 10897062928 11349319680 1927848048 19.050 97 45 89 1 1950676416 9999648 12828720
00:16:29 61571 8192000000 10895727904 11373154304 1936361200 19.118 98 15 30 1 1953001600 12842240 3798160
00:17:44 111063 8192000000 10897393168 11372044288 1942658160 19.168 98 14 28 0 1962214512 15638688 3917664
00:19:41 33444 8192000000 10915320928 11372670976 1957280368 19.284 99 20 40 1 1970361312 7669040 5411904
00:20:22 58633 8192000000 10914357728 11369140224 1950745904 19.232 98 39 73 2 1970480128 9255312 10478912
00:21:28 20204 8192000000 10916009200 11371896832 1946293184 19.197 98 40 78 1 1966821568 9895680 10632704
00:22:17 126146 8192000000 10905073536 11365437440 1940341984 19.149 98 38 77 1 1961092608 9725984 11024640
00:24:38 32498 8192000000 10868696768 11318824960 1895568400 18.791 96 36 72 0 1917538560 11981744 9988416
00:25:25 66528 8192000000 10891920352 11373518848 1958724976 19.296 100 24 48 2 1980001888 13721936 7554976
00:27:03 57395 8192000000 10867761872 11352924160 1936076128 19.115 99 11 22 1 1961742608 22265152 3401328
00:28:07 14817 8192000000 10864988352 11355152384 1939785920 19.145 100 6 12 0 1960650608 19670864 1193824
00:28:42 12948 8192000000 10866941760 11351982080 1935164160 19.108 100 7 14 0 1955071808 18429872 1477776
00:29:02 33145 8192000000 10870826784 11335299072 1928337424 19.054 99 16 32 0 1948952016 15657808 4956784
00:29:45 72812 8192000000 10860272400 11333578752 1930343728 19.070 99 15 30 1 1946801296 12189936 4267632
00:31:04 44154 8192000000 10875086976 11351236608 1949868960 19.225 100 15 28 1 1966272928 12286000 4117968
00:31:54 34619 8192000000 10887634928 11357458432 1927216656 19.045 98 11 23 0 1938903424 8789392 2897376
00:32:35 53179 8192000000 10869699696 11339800576 1891658400 18.759 96 12 24 0 1908267392 13215840 3393152
00:33:34 59249 8192000000 10857075616 11332145152 1893475664 18.774 97 14 28 0 1915684400 18253312 3955424
00:34:40 25711 8192000000 10862359600 11313655808 1905375712 18.870 98 22 44 1 1923703472 11661072 6666688
00:35:13 55304 8192000000 10883912272 11333623808 1827675024 18.240 94 14 28 1 1841074224 9473552 3925648
00:36:16 47481 8192000000 10901878192 11356897280 1934084624 19.100 99 34 68 1 1964313968 21121280 9108064
00:37:17 63346 8192000000 10880949984 11339075584 1859741344 18.501 95 51 102 2 1888245616 14516176 13988096
00:38:32 73062 8192000000 10877038336 11329323008 1923193664 19.012 99 20 40 1 1943911760 15042144 5675952
00:39:56 68627 8192000000 10884231264 11340414976 1912400768 18.926 98 34 66 0 1932871968 10835152 9636048
00:41:13 66284 8192000000 10901909776 11348303872 1911713312 18.920 98 31 62 1 1930759760 10405648 8640800
00:42:27 48790 8192000000 10918601232 11377893376 1962776080 19.328 100 44 88 3 1990132864 14882336 12474448
00:43:27 82514 8192000000 10870945008 11357712384 1848903904 18.413 94 27 54 0 1873742544 17255040 7583600
00:45:48 107560 8192000000 10886634464 11352227840 1933017936 19.091 99 17 34 1 1946367408 8609408 4740064
00:48:03 56095 8192000000 10864633440 11338436608 1893816592 18.777 97 23 46 1 1916883856 16854784 6212480
00:49:05 40777 8192000000 10871502528 11363168256 1938905664 19.138 100 13 26 0 1962900304 20229472 3765168
00:50:09 46981 8192000000 10880017456 11368210432 1951883152 19.241 100 16 32 2 1973302112 16956000 4462960
00:51:03 58067 8192000000 10889297680 11381153792 1960409504 19.309 100 10 20 1 1983097072 20191040 2496528
00:52:08 75757 8192000000 10900937424 11381346304 1947540640 19.207 99 9 18 0 1972455856 22487840 2427376
00:53:30 69696 8192000000 10879170480 11362209792 1944273888 19.181 99 13 26 0 1969286592 21404368 3608336
00:54:47 101985 8192000000 10866028848 11347836928 1900104032 18.827 97 13 26 0 1913635360 8902848 4628480
00:56:35 71090 8192000000 10889645824 11357503488 1926289072 19.037 98 15 31 2 1936575696 6688864 3597760
00:57:53 78494 8192000000 10906621664 11379855360 1941760096 19.161 98 16 32 0 1956513936 10544352 4209488
00:59:18 215007 8192000000 10913694816 11395072000 1941230528 19.157 98 12 24 0 1963377904 19043424 3103952
01:02:59 186031 8192000000 10887179520 11354869760 1824142576 18.212 92 12 24 0 1842412624 15880640 2389408
01:06:11 37100 8192000000 10906431216 11369238528 1948912128 19.218 99 36 70 0 1973190432 14154320 10123984
01:07:04 101325 8192000000 10913198560 11374804992 1939892960 19.146 98 20 39 2 1958044720 13090048 5061712
01:08:53 60568 8192000000 10914722528 11383980032 1946598640 19.199 98 28 57 0 1966041584 12124224 7318720
01:10:04 131757 8192000000 10911708096 11394912256 1953964448 19.258 98 19 38 1 1976131344 16449600 5717296
01:12:30 74387 8192000000 10896275568 11369500672 1926695216 19.040 97 14 28 0 1938353456 7718496 3939744
01:13:51 65877 8192000000 10888607456 11372806144 1939948080 19.146 98 25 49 1 1955310064 8736880 6625104
01:16:16 35370 8192000000 10893063280 11371323392 1953438752 19.254 99 17 33 1 1964391600 6610832 4342016
01:17:04 60419 8192000000 10869117312 11333632000 1856525632 18.475 94 20 39 2 1869404160 6904864 5973664
01:18:10 52104 8192000000 10864045936 11334963200 1910629840 18.912 98 14 27 1 1923060576 7765984 4664752
01:19:12 49027 8192000000 10866221824 11337670656 1872417472 18.604 96 19 38 1 1887386352 8562752 6406128
01:20:13 50771 8192000000 10862981936 11334541312 1907599344 18.887 98 16 32 1 1924712400 12024592 5088464
01:21:12 60505 8192000000 10856030592 11338571776 1881707840 18.679 97 10 20 0 1894923488 10393840 2821808
01:22:21 60854 8192000000 10856379680 11350138880 1923337104 19.014 99 11 22 0 1939850384 13149328 3363952
01:24:14 64340 8192000000 10876385040 11351969792 1931485456 19.079 99 12 24 0 1942989808 8489552 3014800
01:25:34 28193 8192000000 10869998880 11327664128 1879650304 18.662 96 33 66 1 1897123632 8234208 9239120
01:26:10 52806 8192000000 10867684896 11327463424 1869870864 18.583 96 32 64 2 1888924464 10281440 8772160
01:27:09 25431 8192000000 9184483696 9429643264 345721744 4.049 18 4 8 0 353729552 6903856 1103952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 18-03-2021 01:28:38 to 18-03-2021 01:29:08.

Exceptions occured during test was in run

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

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

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          240967
MON$OLDEST_ACTIVE               240968
MON$OLDEST_SNAPSHOT             240968
MON$NEXT_TRANSACTION            240968
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                       2030816
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Thu Mar 18 01:27:36 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Thu Mar 18 01:27:40 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

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