Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.11.2020 19: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 17435696 kB
MemAvailable 31613020 kB
Buffers 0 kB
Cached 14222616 kB
SwapCached 1976 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-11-27 19:27:06
DTS_END                         2020-11-27 19:27:06.6110
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/45400
TRN_ID                          245348
ATT_ID                          647
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: 9554.39 19412 1146527
customer order: creation 185.82 366 22298
customer order: refuse 16.21 327 1945
order to supplier: creation 48.84 1345 5861
order to supplier: removal 3.43 100701 411
invoice (draft): creation 49.38 3373 5925
invoice (draft): removal 54.61 724 6553
invoice accept: apply 43.84 17041 5261
invoice accept: cancel 49.05 708 5886
customer reserve: creation 4040.03 168 484803
customer reserve: removal 4751.84 58 570221
realization accept: apply 88.41 172 10609
realization accept: cancel 84.94 110 10193
payment from customer: creation 62.88 131 7545
payment from customer: removal 6.03 112 723
payment to supplier: creation 52.48 135 6297
payment to supplier: removal 3.73 86 447
service: total inventory turnovers 5.15 1189 618
service: total monetary turnovers 6.88 22 825
service: aggregate perf. data 0.85 20897 102
service: refresh index statistics 0.03 240580 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-11-2020 19:27:57 to 27-11-2020 19:27:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5382
TEST_TIME 2 6539
TEST_TIME 3 6354
TEST_TIME 4 5895
TEST_TIME 5 5947
TEST_TIME 6 5673
TEST_TIME 7 6010
TEST_TIME 8 6209
TEST_TIME 9 6257
TEST_TIME 10 6763
TEST_TIME 11 6878
TEST_TIME 12 7136
TEST_TIME 13 7721
TEST_TIME 14 7741
TEST_TIME 15 8379
TEST_TIME 16 8366
TEST_TIME 17 8561
TEST_TIME 18 8627
TEST_TIME 19 9006
TEST_TIME 20 8987
TEST_TIME 21 9310
TEST_TIME 22 9485
TEST_TIME 23 9786
TEST_TIME 24 10367
TEST_TIME 25 10555
TEST_TIME 26 12023
TEST_TIME 27 12218
TEST_TIME 28 11795
TEST_TIME 29 11576
TEST_TIME 30 11460
TEST_TIME 31 11368
TEST_TIME 32 11401
TEST_TIME 33 11139
TEST_TIME 34 11017
TEST_TIME 35 10899
TEST_TIME 36 10736
TEST_TIME 37 10798
TEST_TIME 38 10919
TEST_TIME 39 10801
TEST_TIME 40 10662
TEST_TIME 41 10540
TEST_TIME 42 10411
TEST_TIME 43 10411
TEST_TIME 44 10366
TEST_TIME 45 10368
TEST_TIME 46 10259
TEST_TIME 47 10254
TEST_TIME 48 10401
TEST_TIME 49 10492
TEST_TIME 50 10398
TEST_TIME 51 10339
TEST_TIME 52 10322
TEST_TIME 53 10315
TEST_TIME 54 10285
TEST_TIME 55 10307
TEST_TIME 56 10356
TEST_TIME 57 10197
TEST_TIME 58 10146
TEST_TIME 59 10077
TEST_TIME 60 10018
TEST_TIME 61 10022
TEST_TIME 62 9995
TEST_TIME 63 9885
TEST_TIME 64 9860
TEST_TIME 65 9858
TEST_TIME 66 9858
TEST_TIME 67 9830
TEST_TIME 68 9868
TEST_TIME 69 9875
TEST_TIME 70 9851
TEST_TIME 71 9890
TEST_TIME 72 9871
TEST_TIME 73 9878
TEST_TIME 74 9929
TEST_TIME 75 9991
TEST_TIME 76 10020
TEST_TIME 77 9953
TEST_TIME 78 10006
TEST_TIME 79 9893
TEST_TIME 80 9824
TEST_TIME 81 9812
TEST_TIME 82 9767
TEST_TIME 83 9736
TEST_TIME 84 9705
TEST_TIME 85 9692
TEST_TIME 86 9688
TEST_TIME 87 9693
TEST_TIME 88 9733
TEST_TIME 89 9750
TEST_TIME 90 9742
TEST_TIME 91 9709
TEST_TIME 92 9791
TEST_TIME 93 9793
TEST_TIME 94 9816
TEST_TIME 95 9795
TEST_TIME 96 9839
TEST_TIME 97 9799
TEST_TIME 98 9774
TEST_TIME 99 9867
TEST_TIME 100 9852
TEST_TIME 101 9927
TEST_TIME 102 9845
TEST_TIME 103 9798
TEST_TIME 104 9743
TEST_TIME 105 9755
TEST_TIME 106 9733
TEST_TIME 107 9683
TEST_TIME 108 9662
TEST_TIME 109 9632
TEST_TIME 110 9570
TEST_TIME 111 9576
TEST_TIME 112 9604
TEST_TIME 113 9598
TEST_TIME 114 9565
TEST_TIME 115 9542
TEST_TIME 116 9665
TEST_TIME 117 9629
TEST_TIME 118 9678
TEST_TIME 119 9639
TEST_TIME 120 9562

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-11-2020 19:28:01 to 27-11-2020 19:28:04.

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 1595718 1595718 0 0.00 0 20475 6 0 0
doc_list_biud 1595713 1595713 0 0.00 0 28533 26 0 0
sp_add_invoice_to_stock 5371 5261 110 2.04 30 169071 17042 0 110
sp_cancel_adding_invoice 5886 5886 0 0.00 5 65085 708 0 0
sp_cancel_client_order 1945 1945 0 0.00 3 11603 327 0 0
sp_cancel_customer_reserve 570221 570221 0 0.00 1 20007 58 0 0
sp_cancel_pay_from_customer 723 723 0 0.00 3 11619 112 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 7023 87 0 0
sp_cancel_supplier_invoice 6565 6553 12 0.18 2 20569 724 0 12
sp_cancel_supplier_order 411 411 0 0.00 9 1227630 100702 0 0
sp_cancel_write_off 10193 10193 0 0.00 1 11284 111 0 0
sp_client_order 22298 22298 0 0.00 3 22751 366 0 0
sp_customer_reserve 484803 484803 0 0.00 0 82056 169 0 0
sp_fill_shopping_cart 34081 34081 0 0.00 1 15120 40 0 0
sp_fill_shopping_cart_clo_res 484798 484798 0 0.00 0 14657 12 0 0
sp_get_clo_for_invoice 5254 5254 0 0.00 0 25773 290 0 0
sp_kill_cost_storno 17249 17249 0 0.00 0 10164 48 0 0
sp_kill_qstorno_ret_qs2qd 1157599 1157599 0 0.00 0 20557 31 0 0
sp_kill_qty_storno 611066 611066 0 0.00 0 28533 67 0 0
sp_lock_selected_doc 22012 22012 0 0.00 0 8212 6 0 0
sp_make_cost_storno 29703 29703 0 0.00 0 13505 48 0 0
sp_multiply_rows_for_pdistr 29700 29700 0 0.00 0 8377 32 0 0
sp_multiply_rows_for_qdistr 22298 22298 0 0.00 0 19558 154 0 0
sp_pay_from_customer 7545 7545 0 0.00 4 16602 132 0 0
sp_pay_to_supplier 6297 6297 0 0.00 5 14749 136 0 0
sp_payment_common 13842 13842 0 0.00 2 16556 38 0 0
sp_qd_handle_on_cancel_clo 1945 1945 0 0.00 0 11581 291 0 0
sp_qd_handle_on_invoice_upd_sts 11135 11135 0 0.00 0 28531 305 0 0
sp_qd_handle_on_reserve_upd_sts 10608 10608 0 0.00 0 14757 61 0 0
sp_reserve_write_off 10609 10609 0 0.00 6 14772 173 0 0
sp_supplier_invoice 5925 5925 0 0.00 5 75380 3373 0 0
sp_supplier_order 5861 5861 0 0.00 5 34988 1346 0 0
srv_aggregate_perf_data 102 102 0 0.00 2767 206898 20897 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1198 155059 30324 0 0
srv_find_qd_qs_mism 1095886 1095886 0 0.00 0 20473 6 0 0
srv_make_invnt_saldo 618 618 0 0.00 39 80210 1190 0 0
srv_make_money_saldo 825 825 0 0.00 0 716 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 153501 332120 240581 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5263 5263 0 0.00 0 16277 173 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 3767 108 0 0
t$perf-norm:sp_cancel_client_order 1945 1945 0 0.00 0 1828 12 0 0
t$perf-norm:sp_cancel_customer_reserve 736 736 0 0.00 0 763 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 723 723 0 0.00 0 6188 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 3444 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 421 421 0 0.00 0 1041 12 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 26033 1482 0 0
t$perf-norm:sp_cancel_write_off 1060 1060 0 0.00 0 1709 5 0 0
t$perf-norm:sp_client_order 22298 22298 0 0.00 0 20040 22 0 0
t$perf-norm:sp_customer_reserve 1045 1045 0 0.00 0 4198 9 0 0
t$perf-norm:sp_pay_from_customer 7545 7545 0 0.00 0 10971 11 0 0
t$perf-norm:sp_pay_to_supplier 6297 6297 0 0.00 0 17703 13 0 0
t$perf-norm:sp_reserve_write_off 10609 10609 0 0.00 0 9709 12 0 0
t$perf-norm:sp_supplier_invoice 5925 5925 0 0.00 0 10659 16 0 0
t$perf-norm:sp_supplier_order 5861 5861 0 0.00 0 3504 16 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 328 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 164 3 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 599 17 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 2843 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10716 10496 220 2.05 0 9709 20 0 220
v_all_customers 40406 40406 0 0.00 0 16 1 0 0
v_all_suppliers 32600 32600 0 0.00 0 46 1 0 0
v_all_wares 44596 44596 0 0.00 0 46 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 2721 11 0 0
v_cancel_client_order 3890 3890 0 0.00 0 4288 7 0 0
v_cancel_customer_prepayment 1446 1446 0 0.00 0 4499 11 0 0
v_cancel_customer_reserve 1472 1472 0 0.00 0 2833 6 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 1166 5 0 0
v_cancel_supplier_invoice 866 842 24 2.77 0 627 13 0 24
v_cancel_supplier_order 822 822 0 0.00 0 2063 6 0 0
v_cancel_write_off 2120 2120 0 0.00 0 3037 16 0 0
v_max_id_clo_ord 5861 5861 0 0.00 0 362 1 0 0
v_max_id_clo_res 1045 1045 0 0.00 0 4335 14 0 0
v_max_id_ord_sup 5922 5922 0 0.00 0 9020 6 0 0
v_max_non_paid_invoice 1780 1780 0 0.00 0 363 2 0 0
v_max_non_paid_realizn 4108 4108 0 0.00 0 5028 4 0 0
v_min_id_clo_ord 5861 5861 0 0.00 0 8776 8 0 0
v_min_id_clo_res 1045 1045 0 0.00 0 7025 22 0 0
v_min_id_ord_sup 5922 5922 0 0.00 0 13653 10 0 0
v_min_non_paid_invoice 6297 6297 0 0.00 0 9882 26 0 0
v_min_non_paid_realizn 7545 7545 0 0.00 0 14713 29 0 0
v_our_firm 11064 11064 0 0.00 0 32 1 0 0
v_reserve_write_off 21216 21216 0 0.00 0 3966 7 0 0
x_lock_depdocs_on_canc_invoice 12018 12018 0 0.00 0 27793 105 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 29558 382 0 0
x_make_qstorno_1000_1200 5861 5861 0 0.00 2 34966 1267 0 0
x_make_qstorno_1200_2000 5925 5925 0 0.00 3 75371 3222 0 0
x_make_qstorno_2100_3300 484803 484803 0 0.00 0 82055 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-11-2020 19:28:05 to 27-11-2020 19:28:09.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 18067 8192000000 10277588464 10586902528 986495920 10.747 76 61 123 0 1009630848 2725552 20409376
16:57:45 35825 8192000000 10381823984 10703892480 1436757648 14.921 100 88 176 0 1470113488 5554352 27801488
16:58:33 35733 8192000000 10419244016 10748248064 1467338384 15.190 100 87 174 0 1503626464 7868224 28419856
16:59:22 11898 8192000000 10434749552 10764902400 1487393920 15.366 100 90 180 2 1524982192 8619376 28968896
16:59:44 25351 8192000000 10449737904 10782740480 1507789728 15.544 100 95 190 0 1547546128 9683216 30073184
17:00:17 1501 8192000000 10455552240 10789003264 1510261984 15.566 100 93 184 0 1549538752 9905440 29371328
17:00:28 17694 8192000000 10472268416 10811801600 1520929904 15.658 100 92 185 2 1560834320 10568704 29335712
17:00:57 13610 8192000000 10486301520 10830036992 1539334480 15.818 100 85 170 2 1576513440 10885184 26293776
17:01:25 16910 8192000000 10521536080 10870632448 1564817632 16.038 100 80 160 2 1601019760 11453488 24748640
17:01:50 15980 8192000000 10543289184 10897604608 1599542096 16.335 100 88 176 2 1637556912 11861536 26153280
17:02:14 11598 8192000000 10557681760 10916036608 1616437168 16.480 100 80 158 0 1651509344 11617712 23454464
17:02:38 14876 8192000000 10584694256 10942476288 1636195184 16.647 100 84 169 3 1673738416 13013536 24529696
17:03:01 13609 8192000000 10605332864 10965278720 1654664272 16.804 100 87 174 0 1693323776 13270640 25388864
17:03:24 10066 8192000000 10605054272 10971238400 1668108080 16.917 100 82 164 1 1705703744 13726704 23868960
17:03:41 7058 8192000000 10612739344 10981834752 1676113600 16.985 100 85 169 1 1714973552 13796912 25063040
17:04:04 9383 8192000000 10652360464 11015741440 1704676016 17.224 100 88 176 1 1744151184 13844048 25631120
17:04:22 8428 8192000000 10650758272 11022417920 1709879968 17.268 100 81 162 1 1747433040 14618208 22934864
17:04:39 6696 8192000000 10659092960 11036991488 1724384592 17.389 100 77 152 3 1759006656 12775744 21846320
17:04:53 3968 8192000000 10675904192 11052740608 1739119280 17.511 100 80 159 3 1774894384 13439056 22336048
17:05:04 7182 8192000000 10685632448 11063742464 1746413936 17.572 100 81 162 0 1782912816 13642800 22856080
17:05:19 5451 8192000000 10696597088 11073167360 1754616176 17.640 100 82 164 2 1791996208 14373456 23006576
17:05:31 4203 8192000000 10710933136 11086401536 1764449888 17.721 100 86 174 0 1802387472 14113408 23824176
17:05:42 3335 8192000000 10709059888 11090001920 1773938480 17.800 100 90 180 1 1813604288 13584320 26081488
17:05:52 2618 8192000000 10722146720 11099308032 1782775040 17.872 100 90 175 2 1820860400 13841488 24243872
17:06:01 3106 8192000000 10729241696 11105902592 1786484976 17.903 100 86 170 1 1823915232 13325104 24105152
17:06:12 2354 8192000000 10736966480 11117060096 1792403264 17.952 100 84 168 2 1828009536 12533936 23072336
17:06:21 2676 8192000000 10735338768 11115159552 1799899248 18.013 100 86 170 0 1835977184 12562400 23515536
17:06:30 8629 8192000000 10736613072 11126898688 1807948368 18.079 100 79 157 0 1841835904 11581728 22305808
17:06:46 3428 8192000000 10760802912 11151499264 1816530064 18.149 100 74 147 0 1848120048 11019216 20570768
17:06:56 2808 8192000000 10771447696 11157581824 1831315136 18.270 100 86 171 1 1866957840 11357936 24284768
17:07:06 2215 8192000000 10779833520 11169792000 1838217968 18.326 100 85 170 2 1874341712 12286400 23837344
17:07:15 2596 8192000000 10779070976 11169386496 1840636992 18.346 100 88 174 3 1879443728 13577024 25229712
17:07:23 1963 8192000000 10786949392 11173572608 1848161120 18.407 100 86 173 0 1885679008 12406096 25111792
17:07:32 3089 8192000000 10791760688 11178151936 1851301856 18.433 100 93 183 2 1889132384 12159360 25671168
17:07:42 1528 8192000000 10798854768 11185029120 1854886592 18.462 100 92 184 0 1893325872 12958624 25480656
17:07:49 1321 8192000000 10801417808 11187122176 1855918528 18.470 100 94 189 0 1896414272 14015104 26480640
17:07:57 2030 8192000000 10795834832 11188113408 1857593360 18.484 100 88 177 3 1894487456 12004896 24889200
17:08:05 1796 8192000000 10806730240 11193159680 1861579760 18.516 100 91 182 3 1899143744 11727952 25836032
17:08:13 25346 8192000000 10799533744 11192381440 1860595136 18.508 100 66 132 1 1890781120 11731664 18454320
17:08:45 15139 8192000000 10802575296 11196796928 1865886400 18.551 100 80 159 2 1898987600 10856736 22244464
17:09:07 1522 8192000000 10821101952 11209293824 1871977136 18.600 100 95 191 2 1911999392 12574016 27448240
17:09:15 4815 8192000000 10803480992 11200200704 1865814416 18.550 100 54 108 1 1890966784 10161328 14991040
17:09:26 2475 8192000000 10799160000 11208716288 1869841696 18.583 100 56 112 1 1896490224 11186736 15461792
17:09:39 7832 8192000000 10788776464 11198791680 1865077120 18.544 100 32 65 2 1881320464 7454256 8789088
17:09:53 3181 8192000000 10785069936 11205640192 1869664464 18.582 100 30 60 3 1885410512 7293744 8452304
17:10:05 6286 8192000000 10794573600 11207114752 1876475120 18.637 100 34 68 3 1896368640 10915728 8977792
17:10:18 3460 8192000000 10798487200 11217854464 1880860240 18.672 100 42 84 1 1901390160 9138960 11390960
17:10:29 13978 8192000000 10778439888 11211771904 1878351648 18.652 100 24 47 1 1903690592 19294032 6044912
17:10:50 70339 8192000000 10790566416 11227066368 1880560848 18.670 100 20 40 2 1891352848 4752144 6039856
17:12:07 7287 8192000000 10806203456 11230060544 1884233440 18.699 100 20 40 1 1899678384 10244272 5200672
17:12:22 6300 8192000000 10803968416 11233775616 1889583984 18.742 100 38 76 2 1908119200 7429120 11106096
17:12:36 4887 8192000000 10802559184 11232227328 1889217216 18.739 100 31 62 1 1904143024 6215904 8709904
17:12:49 6111 8192000000 10818888768 11244843008 1893211632 18.772 100 37 74 0 1911187984 7498944 10477408
17:13:01 5298 8192000000 10812411312 11239919616 1892601872 18.767 100 26 52 0 1906853536 6957968 7293696
17:13:13 4139 8192000000 10809466736 11240247296 1893554032 18.774 100 24 46 2 1906527776 6473408 6500336
17:13:25 4369 8192000000 10809496176 11237986304 1898027008 18.810 100 29 56 3 1912402880 5843824 8532048
17:13:36 11562 8192000000 10799979712 11240706048 1894609696 18.783 100 14 28 0 1904357424 5761632 3986096
17:13:54 8705 8192000000 10807921936 11242393600 1896814864 18.801 100 18 36 1 1908094864 5828720 5451280
17:14:13 7580 8192000000 10804727488 11244331008 1899015888 18.818 100 17 34 1 1910115360 6139760 4959712
17:14:27 12521 8192000000 10823394928 11258101760 1907594288 18.887 100 21 42 2 1923920304 10550016 5776000
17:14:48 9758 8192000000 10817036464 11255582720 1906563088 18.879 100 15 30 0 1917143392 6284512 4295792
17:15:04 9365 8192000000 10815416096 11247448064 1901138016 18.835 100 18 36 1 1911678208 5303616 5236576
17:15:20 51629 8192000000 10828972112 11252785152 1906340848 18.877 100 48 94 5 1927064912 5573760 15150304
17:16:24 15014 8192000000 10835439200 11242668032 1889537152 18.742 99 50 100 2 1910659120 7005568 14116400
17:16:47 8874 8192000000 10796573232 11235270656 1864528928 18.540 98 21 42 1 1876976064 6461792 5985344
17:17:03 9343 8192000000 10813612224 11249741824 1902543264 18.847 100 36 70 2 1919543392 7080128 9920000
17:17:21 2916 8192000000 10832708496 11253207040 1903637488 18.856 100 47 95 1 1924684080 7946928 13099664
17:17:31 6491 8192000000 10813887552 11253256192 1905173216 18.868 100 37 72 2 1923292928 7977872 10141840
17:17:44 7543 8192000000 10795670256 11220877312 1838932272 18.332 97 17 34 0 1849571024 5912752 4726000
17:17:59 6943 8192000000 10795494304 11226824704 1863621200 18.533 99 33 66 1 1879596896 7439824 8535872
17:18:16 7406 8192000000 10745676960 11164479488 1803910096 18.046 97 16 32 0 1813883792 4977328 4996368
17:18:30 10137 8192000000 10755894112 11184484352 1799523024 18.010 97 21 42 0 1811030048 5798880 5708144
17:18:46 5741 8192000000 10760914352 11189342208 1839337936 18.335 99 27 54 1 1853481440 6110784 8032720
17:18:59 7392 8192000000 10756100944 11182280704 1799464912 18.010 97 22 45 3 1811968768 6578848 5925008
17:19:13 5705 8192000000 10729267584 11144245248 1732551104 17.457 94 29 56 1 1746708432 5566544 8590784
17:19:26 11275 8192000000 10692951744 11111845888 1673120848 16.959 92 20 40 1 1689490080 10507808 5861424
17:19:45 9095 8192000000 10713066592 11136466944 1758978240 17.676 97 25 49 1 1771544768 5423984 7142544
17:20:01 11518 8192000000 10699517792 11116933120 1732568400 17.457 96 22 44 1 1744356112 5223744 6563968
17:20:22 10875 8192000000 10709139296 11123183616 1724384448 17.389 95 31 62 3 1739401728 5501712 9515568
17:20:40 63756 8192000000 10692934832 11107282944 1706021168 17.235 95 35 70 1 1721588336 5466544 10100624
17:21:51 10629 8192000000 10682351200 11092025344 1685710384 17.065 94 24 48 1 1697827456 5533920 6583152
17:22:08 8216 8192000000 10702618336 11115630592 1759291136 17.679 98 32 64 2 1774286912 6040448 8955328
17:22:23 5594 8192000000 10710830272 11125641216 1776906400 17.824 99 37 74 2 1795326144 7687600 10732144
17:22:37 5754 8192000000 10715837088 11135762432 1801297872 18.025 100 21 42 1 1813732608 6753408 5681328
17:22:49 8249 8192000000 10733059200 11153190912 1818365872 18.164 100 25 50 0 1831358464 4632016 8360576
17:23:04 6050 8192000000 10726198960 11152199680 1805401360 18.058 99 22 44 0 1817663664 5834432 6427872
17:23:17 5564 8192000000 10761803040 11172233216 1830717376 18.265 100 20 40 1 1842397200 6110592 5569232
17:23:32 9491 8192000000 10755187712 11174752256 1836225536 18.310 100 30 60 1 1850635216 5292880 9116800
17:23:49 11050 8192000000 10759350688 11174625280 1840103872 18.342 100 33 66 2 1856332112 5446384 10781856
17:24:07 8968 8192000000 10754938752 11168059392 1821023296 18.186 99 16 32 0 1831552336 5635104 4893936
17:24:22 9526 8192000000 10752187952 11177574400 1841187344 18.350 100 19 38 0 1852484672 5603040 5694288
17:24:40 6852 8192000000 10768175760 11188162560 1849573920 18.419 100 23 44 4 1861577632 6069728 5933984
17:24:54 9598 8192000000 10762078048 11186388992 1848432096 18.409 100 17 34 1 1858978464 5399744 5146624
17:25:12 69848 8192000000 10767633088 11200126976 1856156000 18.472 100 23 46 2 1868260832 5694032 6410800
17:26:30 5957 8192000000 10769187120 11201658880 1864453216 18.539 100 26 52 4 1877714816 6105680 7155920
17:26:42 6798 8192000000 10788903776 11210010624 1865130176 18.545 100 29 56 4 1879446752 6538720 7777856
17:26:55 6276 8192000000 10789100176 11212890112 1870657328 18.590 100 35 71 0 1887050656 6780512 9612816
17:27:10 46513 8192000000 10814206304 11236454400 1888346400 18.732 100 41 83 1 1905944704 6248480 11349824
17:28:07 1780 8192000000 10847098016 11255095296 1909161552 18.900 100 67 131 1 1940156192 12498000 18496640
17:28:16 17236 8192000000 10853802384 11267870720 1910897408 18.914 100 45 90 2 1936196320 12819104 12479808
17:28:43 28358 8192000000 10867554320 11282927616 1923046032 19.011 100 58 117 1 1955623600 16435648 16141920
17:29:18 2962 8192000000 10869471968 11288608768 1930612704 19.072 100 59 114 1 1962198336 15456624 16129008
17:29:32 8596 8192000000 10873295232 11296186368 1938706336 19.136 100 44 88 0 1967120096 15875456 12538304
17:29:50 17373 8192000000 10876414176 11303878656 1943374144 19.174 100 51 102 0 1974602112 16313328 14914640
17:30:14 17738 8192000000 10877502560 11306393600 1944552080 19.183 100 43 86 3 1974379392 16730448 13096864
17:30:45 8849 8192000000 10890166240 11315601408 1953647632 19.256 100 49 98 0 1984821696 16795360 14378704
17:31:02 9554 8192000000 10900132496 11324207104 1958797392 19.296 100 53 106 2 1991144720 17013104 15334224
17:31:19 37517 8192000000 10908991104 11331317760 1961895184 19.321 100 49 98 0 1994231280 17759328 14576768
17:32:18 13319 8192000000 10897114976 11333439488 1963123616 19.331 100 46 91 1 1995518592 19354736 13040240
17:32:44 32619 8192000000 10909207888 11345342464 1965827568 19.352 100 43 86 2 1998691344 20270992 12592784
17:33:30 13281 8192000000 10912986304 11344551936 1967883344 19.369 100 40 80 2 2003319200 23655200 11780656
17:34:00 3431 8192000000 10932062352 11356381184 1976610864 19.438 100 67 130 2 2020783728 25628800 18544064
17:34:14 10480 8192000000 10940769088 11362529280 1982696080 19.486 100 61 122 1 2026493392 26166560 17630752
17:34:38 5531 8192000000 10939304944 11366473728 1988734128 19.534 100 54 106 0 2031259248 27264448 15260672
17:34:52 5408 8192000000 10943558160 11366363136 1987241520 19.522 100 71 141 0 2036079664 28610112 20228032
17:35:07 9312 8192000000 10944952240 11363553280 1965679584 19.351 99 69 135 1 2015636592 29696880 20260128
17:35:24 8476 8192000000 10942521248 11365081088 1981529104 19.477 100 61 122 0 2029337760 29825776 17982880
17:35:51 15856 8192000000 10938584064 11378221056 1990423952 19.547 100 48 95 0 2034480208 30226592 13829664
17:36:16 7696 8192000000 10947780240 11384807424 1997898176 19.606 100 47 95 1 2042687136 30821600 13967360
17:36:32 3233 8192000000 10954079312 11385360384 1984542384 19.501 99 57 114 2 2033489536 31636704 17310448
17:36:42 6009 8192000000 10968985328 11389022208 1996302848 19.594 100 64 124 0 2047966608 32747792 18915968
17:36:55 11802 8192000000 10961388000 11395801088 2003283936 19.649 100 66 131 2 2057100816 34411968 19404912
17:37:14 7316 8192000000 10972109040 11404009472 2007975536 19.686 100 58 116 0 2062754368 37591760 17187072
17:37:29 2915 8192000000 10980100736 11409276928 2011488496 19.713 100 72 144 1 2071556848 38734992 21333360
17:37:39 2751 8192000000 10986222336 11413450752 2014428304 19.736 100 83 163 1 2080445952 40834912 25182736
17:37:52 3467 8192000000 10979595056 11397369856 2005230336 19.664 100 74 144 3 2064340336 37328208 21781792
17:38:02 2720 8192000000 10975426128 11394277376 2001786064 19.637 100 77 153 0 2060777120 36718544 22272512
17:38:13 3478 8192000000 10972854416 11387809792 1992938912 19.567 100 86 172 1 2056229888 37331152 25959824
17:38:24 4325 8192000000 10961596048 11384713216 1977210048 19.443 99 73 142 1 2036668752 37557536 21901168
17:38:35 5036 8192000000 10978289504 11400810496 1997456128 19.603 100 72 145 3 2059198544 39721680 22020736
17:38:52 8118 8192000000 10973612736 11401043968 1997095680 19.600 100 62 124 1 2057074096 41041216 18937200
17:39:11 9173 8192000000 10973748672 11400671232 2001849648 19.637 100 53 106 2 2061016544 41409936 17756960
17:39:26 1932 8192000000 10977842528 11397431296 1984535824 19.501 99 76 151 0 2048307984 40300736 23471424
17:39:36 1997 8192000000 10973651680 11400458240 2002572400 19.643 100 73 145 1 2064192224 39743152 21876672
17:39:46 4492 8192000000 10983298096 11398660096 1998160112 19.608 100 83 166 1 2064081296 40692848 25228336
17:39:58 1578 8192000000 10971277376 11387150336 1983691600 19.494 99 87 175 0 2051118448 41003136 26423712
17:40:06 4098 8192000000 10971862176 11394932736 1996561008 19.596 100 72 144 2 2058037840 39409472 22067360
17:40:17 3292 8192000000 10956133760 11376852992 1985742096 19.510 100 81 162 3 2044639872 33959120 24938656
17:40:27 1909 8192000000 10956519664 11372249088 1965124064 19.347 99 82 164 2 2024140288 33954576 25061648
17:40:39 1648 8192000000 10967573984 11385212928 1992981584 19.567 100 83 166 0 2053157392 35721072 24454736
17:40:47 1660 8192000000 10963592032 11368484864 1959535104 19.302 98 88 172 0 2024706768 39548880 25622784
17:40:58 8287 8192000000 10962315824 11382644736 1987337952 19.523 100 75 148 1 2048972672 39075088 22559632
17:41:15 3143 8192000000 10934101600 11346358272 1947484880 19.206 98 75 150 0 2013309104 42597856 23226368
17:41:25 4697 8192000000 10937179024 11347251200 1933984784 19.099 99 83 165 0 2002844080 43744272 25115024
17:41:42 2945 8192000000 10917716256 11340664832 1935247792 19.109 99 68 132 0 2000652336 44088048 21316496
17:41:52 5219 8192000000 10950555712 11358924800 1957689904 19.288 100 81 162 2 2026797856 44301520 24806432
17:42:06 2451 8192000000 10969052480 11377233920 1973185616 19.411 100 85 167 1 2045073568 46266768 25621184
17:42:18 2768 8192000000 10978488320 11390812160 1984644560 19.501 100 86 172 2 2059230944 48155024 26431360
17:42:28 2940 8192000000 10973518928 11390418944 1985877712 19.511 100 83 167 0 2057143200 46226160 25039328
17:42:39 2459 8192000000 10971127392 11388293120 1986750320 19.518 100 87 174 0 2057551088 44102592 26698176
17:42:48 1752 8192000000 10958166416 11370643456 1967106032 19.362 99 76 150 2 2033185632 42380640 23698960
17:42:57 3580 8192000000 10948766096 11361001472 1962183088 19.323 99 82 164 0 2028479856 41505904 24790864
17:43:08 3921 8192000000 10959921584 11372642304 1968004016 19.370 100 83 159 1 2038904128 46334016 24566096
17:43:21 3687 8192000000 10935295424 11353436160 1955406720 19.270 100 86 172 1 2024833824 43619360 25807744
17:43:32 3284 8192000000 10955942432 11357077504 1961086496 19.315 100 91 181 3 2031359168 43104960 27167712
17:43:42 5120 8192000000 10942379360 11356790784 1956188816 19.276 100 74 148 0 2024711792 44404976 24118000
17:43:54 3307 8192000000 10961806336 11377246208 1967758640 19.368 100 77 152 2 2037805552 46596576 23450336
17:44:04 1473 8192000000 10920888080 11321745408 1912473920 18.927 97 89 178 1 1987990000 47220688 28295392
17:44:12 5862 8192000000 10904327472 11323600896 1901931904 18.842 98 69 138 0 1971059440 46727632 22399904
17:44:26 5165 8192000000 10935896784 11349200896 1945290720 19.189 100 64 127 3 2010971696 46659776 19021200
17:44:38 2552 8192000000 10931224560 11334979584 1928508048 19.055 99 79 151 1 2001629552 49090928 24030576
17:44:49 2197 8192000000 10948533808 11359461376 1952469936 19.246 100 73 144 1 2027630496 52597120 22563440
17:45:00 2743 8192000000 10944973184 11356094464 1942633520 19.168 99 77 156 0 2022847584 56792016 23422048
17:45:10 2965 8192000000 10964576960 11368882176 1961917728 19.321 100 80 158 2 2039039232 52074992 25046512
17:45:20 2755 8192000000 10966326512 11372322816 1958820224 19.297 100 81 161 1 2043348368 59156832 25371312
17:45:30 2800 8192000000 10962955136 11376541696 1963416352 19.333 100 75 148 1 2043963232 57201552 23345328
17:45:47 10948 8192000000 10952477008 11385794560 1965262064 19.348 100 37 74 2 2036462784 58886432 12314288
17:46:07 11175 8192000000 10954797920 11379433472 1946681280 19.200 99 45 88 2 2023326448 61247120 15398048
17:46:30 1198 8192000000 10994687232 11402178560 1978470512 19.453 100 76 150 3 2067294192 63728336 25095344
17:46:39 8740 8192000000 10969488448 11413929984 1984334720 19.499 100 50 100 0 2064211120 63224448 16651952
17:46:57 6981 8192000000 10968802448 11403542528 1983739984 19.494 100 50 97 0 2057167600 57069968 16357648
17:47:13 9374 8192000000 10974577872 11412979712 1985689680 19.510 100 42 83 2 2059839440 60071024 14078736
17:47:54 16916 8192000000 10960026640 11411263488 1975492112 19.429 100 40 79 3 2053577888 64475344 13610432
17:48:34 19619 8192000000 10962465712 11412983808 1975577232 19.430 100 36 72 1 2048956752 60713056 12666464
17:49:07 15671 8192000000 10972045008 11410800640 1975659776 19.430 100 45 90 1 2054113856 62131712 16322368
17:49:30 11549 8192000000 10964439424 11413622784 1961409504 19.317 99 40 80 1 2038919680 63346720 14163456
17:49:55 13871 8192000000 10947783872 11400691712 1936781040 19.121 98 41 82 1 2012007136 61340512 13885584
17:50:15 21730 8192000000 10946643312 11403952128 1963060592 19.330 100 26 52 2 2036616960 64025216 9531152
17:50:43 31710 8192000000 10953205792 11410591744 1974834976 19.424 100 34 66 1 2046913584 60264240 11814368
17:51:29 35469 8192000000 10948278176 11414306816 1965727456 19.352 100 26 52 1 2034818208 59610096 9480656
17:53:07 23918 8192000000 10878015392 11339141120 1885072448 18.706 97 18 36 0 1938849792 46610112 7167232
17:53:40 29302 8192000000 10855087168 11324055552 1911632976 18.920 99 16 33 3 1941582496 25216256 4733264
17:54:19 109628 8192000000 10897382848 11338899456 1924001200 19.019 99 27 54 0 1941278624 9735168 7542256
17:56:18 61662 8192000000 10867581360 11328016384 1906051392 18.875 98 31 60 0 1925002160 9809152 9141616
17:57:36 50428 8192000000 10885528176 11350355968 1921222976 18.997 98 32 64 0 1940891424 9348544 10319904
17:58:52 155059 8192000000 10902316752 11358277632 1917506864 18.967 98 24 48 1 1937812432 13871520 6434048
18:01:34 8754 8192000000 10914538800 11369656320 1976497568 19.437 100 31 60 2 1994374416 9664736 8212112
18:01:49 21648 8192000000 10908012688 11376128000 1978917056 19.456 100 20 40 1 1995716576 10869712 5929808
18:02:21 31391 8192000000 10913540384 11372474368 1964880688 19.345 99 30 60 1 1985287936 10788096 9619152
18:03:17 16572 8192000000 10933996976 11373989888 1977702608 19.447 100 39 80 2 2000199920 10161712 12335600
18:03:42 37788 8192000000 10912689152 11365425152 1926817712 19.041 97 52 106 0 1960597312 18950368 14829232
18:04:41 64094 8192000000 10895587248 11371655168 1957817408 19.289 100 15 31 0 1977571232 15231248 4522576
18:05:52 27384 8192000000 10882724960 11361964032 1958477552 19.294 100 9 19 0 1971957232 10969248 2510432
18:06:25 12823 8192000000 10882236784 11360391168 1964589584 19.343 100 5 10 0 1973582048 7632720 1359744
18:06:44 28300 8192000000 10888458368 11365289984 1971277392 19.396 100 6 12 0 1980469216 7462768 1729056
18:07:25 5195 8192000000 10910138064 11371565056 1974914384 19.424 100 12 25 1 1984896416 6665552 3316480
18:07:40 43700 8192000000 10907282768 11373400064 1978607072 19.454 100 24 48 0 1993695024 8378576 6709376
18:08:30 59979 8192000000 10903371728 11380469760 1960959968 19.314 99 11 22 0 1974338112 10036624 3341520
18:09:54 50780 8192000000 10904647408 11381497856 1979528256 19.461 100 14 25 3 1990683392 6582464 4572672
18:10:58 38672 8192000000 10928908896 11393466368 1986370656 19.515 100 21 42 1 1999609152 7614032 5624464
18:11:47 34119 8192000000 10895015664 11371413504 1974668592 19.422 99 38 78 1 1992456656 7079360 10708704
18:12:29 63773 8192000000 10909581488 11387588608 1950604688 19.231 98 15 30 0 1963407328 8839920 3962720
18:13:39 41448 8192000000 10914762592 11380420608 1932933200 19.090 97 28 56 0 1954414352 13449600 8031552
18:14:42 51817 8192000000 10914904784 11401408512 1960162688 19.307 99 13 26 1 1983420128 19403360 3854080
18:16:01 123994 8192000000 10885555392 11350994944 1852176272 18.440 94 19 38 1 1879458464 21717392 5564800
18:18:11 57534 8192000000 10882447568 11343761408 1917916416 18.970 98 24 48 0 1939522208 14848016 6757776
18:19:15 41734 8192000000 10893016128 11364040704 1949404816 19.222 99 32 64 2 1969555840 10598000 9553024
18:20:17 39840 8192000000 10867541952 11316178944 1854537120 18.459 95 18 36 1 1868085696 7661168 5887408
18:21:03 12194 8192000000 10891212000 11330187264 1924939904 19.026 99 61 122 1 1951129856 7985968 18203984
18:21:22 25368 8192000000 10867196112 11324567552 1912238064 18.925 99 33 66 0 1931656944 10021568 9397312
18:22:24 44675 8192000000 10875752288 11346128896 1910183136 18.908 98 20 40 0 1929626928 13389168 6054624
18:23:16 102829 8192000000 10877133184 11338870784 1937082816 19.123 99 15 31 0 1951760208 10710080 3967312
18:25:05 56964 8192000000 10895772560 11342372864 1884057600 18.698 96 42 84 2 1904282144 8124208 12100336
18:26:11 84117 8192000000 10872482480 11328606208 1858336560 18.490 95 40 79 1 1886014896 16684032 10994304
18:27:43 2802 8192000000 10873396560 11333959680 1913785168 18.937 99 33 66 0 1945769776 22691536 9293072
18:27:52 11797 8192000000 10865283952 11335766016 1926872304 19.042 100 18 36 0 1953583552 21825104 4886144
18:28:11 12412 8192000000 10865250672 11338158080 1937259840 19.125 100 17 33 0 1958377536 16559248 4558448
18:28:42 38646 8192000000 10825021280 11294605312 1859897392 18.502 96 15 27 1 1875276880 12451776 2927712
18:29:33 47069 8192000000 10847042144 11323478016 1929687584 19.064 100 10 20 0 1943032352 10769984 2574784
18:30:40 35266 8192000000 10868430560 11338924032 1923752720 19.017 99 10 20 0 1937592416 11537024 2302672
18:32:33 60504 8192000000 10877283840 11335819264 1893982864 18.778 98 17 34 0 1913762848 15107360 4672624
18:33:40 28434 8192000000 10860262544 11328483328 1911045952 18.915 98 30 61 0 1929299408 10032448 8221008
18:34:17 44538 8192000000 10875820384 11326930944 1884190112 18.699 97 25 50 0 1904513136 12638000 7685024
18:35:14 38381 8192000000 10837401744 11289501696 1822684544 18.200 95 16 32 1 1836639232 9523280 4431408
18:36:00 30225 8192000000 10859100144 11316748288 1905455408 18.870 99 28 56 1 1921453664 8331520 7666736
18:36:37 70170 8192000000 10833257072 11302887424 1836159024 18.310 95 13 26 0 1852785216 12937504 3688688
18:37:58 49893 8192000000 10859472400 11318927360 1879827488 18.664 98 22 44 1 1902618448 16580704 6210256
18:38:54 57333 8192000000 10865770992 11329941504 1912469088 18.926 99 22 44 2 1934439888 15782352 6188448
18:39:58 48341 8192000000 10872899600 11336904704 1912476224 18.927 99 16 32 0 1939787248 22698752 4612272
18:40:58 87885 8192000000 10865324912 11344138240 1882936336 18.689 97 13 26 0 1904029904 17386752 3706816
18:42:32 88877 8192000000 10851791776 11311325184 1856252816 18.473 96 11 19 3 1871050032 12016352 2780864
18:44:10 57816 8192000000 10875199488 11338067968 1934841360 19.106 100 27 54 1 1959393008 16847840 7703808
18:45:17 127253 8192000000 10853517632 11328909312 1921441440 18.998 99 27 54 2 1941688240 12463632 7783168
18:48:02 3224 8192000000 10864375600 11333210112 1939719136 19.145 100 19 39 0 1955727296 9778928 6229232
18:48:11 10673 8192000000 10857141024 11327148032 1933000480 19.091 100 8 17 0 1943322816 8423696 1898640
18:48:28 5189 8192000000 10875771184 11339587584 1945191072 19.188 100 21 42 2 1963596512 12550848 5854592
18:48:39 31584 8192000000 10854330656 11327533056 1930001152 19.067 99 18 36 1 1946520880 11727280 4792448
18:49:24 65876 8192000000 10838884848 11312295936 1892651472 18.767 97 11 22 1 1909836672 13390832 3794368
18:50:36 59367 8192000000 10862684112 11342213120 1922664544 19.008 99 10 20 0 1937855648 12200432 2990672
18:51:42 44731 8192000000 10880224496 11351080960 1950950352 19.234 100 20 40 1 1971989920 15147968 5891600
18:52:47 49182 8192000000 10880585808 11357605888 1952843168 19.249 100 19 38 2 1977249600 18619984 5786448
18:54:22 74030 8192000000 10888591248 11382669312 1932395200 19.086 99 11 22 0 1956562528 21408256 2759072
18:55:43 36801 8192000000 10886975008 11358724096 1943234016 19.173 99 17 34 1 1955215424 7904080 4077328
18:56:34 77382 8192000000 10905646144 11378253824 1919966704 18.987 97 21 42 1 1937930336 11832096 6131536
18:58:01 49948 8192000000 10908516736 11369107456 1962593840 19.327 99 23 46 1 1981494832 12174720 6726272
18:58:57 78215 8192000000 10896636784 11360956416 1932767328 19.089 98 13 26 1 1946840000 10916128 3156544
19:00:22 56076 8192000000 10904787632 11380436992 1976567536 19.438 100 20 40 1 1995736256 13553696 5615024
19:01:29 55698 8192000000 10910100336 11361775616 1905732080 18.872 96 24 48 1 1922241232 9657168 6851984
19:02:34 27883 8192000000 10901560112 11367669760 1953850656 19.257 99 30 58 2 1970845120 9000064 7994400
19:03:08 63916 8192000000 10906924112 11394211840 1961096960 19.315 99 21 42 0 1977663008 10901968 5664080
19:04:18 24369 8192000000 10930789872 11380699136 1954971904 19.266 98 38 77 1 1973883920 7513456 11398560
19:04:50 21588 8192000000 10950413984 11403563008 1995468512 19.587 100 43 87 1 2019570656 11745792 12356352
19:05:20 55062 8192000000 10893099616 11365756928 1871700512 18.598 94 29 58 4 1899220832 19436768 8083552
19:06:26 88442 8192000000 10921371424 11385946112 1892235408 18.764 96 12 23 1 1910094624 14403456 3455760
19:08:03 127851 8192000000 10893991216 11364966400 1938966496 19.139 98 13 26 1 1955456976 12985056 3505424
19:10:17 103974 8192000000 10888889200 11360051200 1885957920 18.713 95 21 42 1 1903321040 11353952 6009168
19:12:09 4795 8192000000 10883156096 11353198592 1945015792 19.187 99 28 56 2 1967013808 13840688 8157328
19:12:22 16824 8192000000 10875496768 11348811776 1934399440 19.102 99 8 16 0 1944831280 8059072 2372768
19:12:46 60311 8192000000 10883935376 11370295296 1936201968 19.116 98 13 26 1 1947511216 7456128 3853120
19:13:53 94489 8192000000 10868797920 11345170432 1853490720 18.450 94 8 16 0 1861874864 6430528 1953616
19:15:33 77637 8192000000 10836163536 11312603136 1846079728 18.390 94 21 42 3 1862988688 11136416 5772544
19:17:12 52981 8192000000 10855622848 11331194880 1900237840 18.828 98 9 18 0 1913504880 10624144 2642896
19:18:22 71086 8192000000 10848034048 11328905216 1876645024 18.638 97 10 20 0 1892201152 12542960 3013168
19:19:44 49188 8192000000 10839395744 11315429376 1806328272 18.066 93 19 38 1 1820754416 8433920 5992224
19:20:42 36734 8192000000 10853538688 11321577472 1903092560 18.851 98 20 40 0 1924691184 15555344 6043280
19:21:41 42967 8192000000 10872023184 11334320128 1901295296 18.837 98 35 70 3 1930343280 18708672 10339312
19:22:30 73778 8192000000 10866869776 11353694208 1901806416 18.841 98 18 36 1 1928288928 20973376 5509136
19:23:51 41464 8192000000 10889283296 11340603392 1923689648 19.016 99 20 40 1 1941870416 13265520 4915248
19:25:05 66977 8192000000 10882097680 11351506944 1928498864 19.055 99 14 28 0 1942891296 10479936 3912496
19:26:46 32564 8192000000 8983854496 9157922816 147823872 1.772 8 4 8 0 157650880 8746048 1080960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-11-2020 19:28:11 to 27-11-2020 19:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-11-2020 19:28:44 to 27-11-2020 19:28:46.

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          247533
MON$OLDEST_ACTIVE               247534
MON$OLDEST_SNAPSHOT             247534
MON$NEXT_TRANSACTION            247534
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                       2037728
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:15: 
:16: mscs-test-161.budzdorov.ru    Fri Nov 27 19:27:26 2020
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
--- end of diff output ---

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

27.11.20 19:28:47. 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-11-27 19:28:50 No severe PSQL-related problems occured
27.11.20 19:28:51. End of report.