Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.11.2020 22: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 17154920 kB
MemAvailable 31437172 kB
Buffers 0 kB
Cached 14498240 kB
SwapCached 2828 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.7
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-05 22:27:00
DTS_END                         2020-11-05 22:27:00.3130
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/52920
TRN_ID                          250749
ATT_ID                          664
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: 9613.67 21744 1153640
customer order: creation 178.28 313 21393
customer order: refuse 15.07 350 1808
order to supplier: creation 47.68 1274 5722
order to supplier: removal 3.58 101442 430
invoice (draft): creation 46.28 3260 5554
invoice (draft): removal 54.18 743 6502
invoice accept: apply 43.30 18755 5196
invoice accept: cancel 49.67 803 5960
customer reserve: creation 4018.98 185 482278
customer reserve: removal 4840.86 59 580903
realization accept: apply 86.72 198 10406
realization accept: cancel 93.39 110 11207
payment from customer: creation 62.32 117 7478
payment from customer: removal 6.13 84 735
payment to supplier: creation 51.28 124 6153
payment to supplier: removal 3.50 69 420
service: total inventory turnovers 4.74 1307 569
service: total monetary turnovers 6.80 33 816
service: aggregate perf. data 0.88 17497 106
service: refresh index statistics 0.03 288157 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2020 22:27:47 to 05-11-2020 22:27:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5187
TEST_TIME 2 3959
TEST_TIME 3 2778
TEST_TIME 4 3854
TEST_TIME 5 4149
TEST_TIME 6 4696
TEST_TIME 7 5794
TEST_TIME 8 5886
TEST_TIME 9 6424
TEST_TIME 10 6766
TEST_TIME 11 7017
TEST_TIME 12 7051
TEST_TIME 13 7431
TEST_TIME 14 8027
TEST_TIME 15 7915
TEST_TIME 16 8012
TEST_TIME 17 8124
TEST_TIME 18 8369
TEST_TIME 19 8298
TEST_TIME 20 8505
TEST_TIME 21 8792
TEST_TIME 22 8991
TEST_TIME 23 9117
TEST_TIME 24 9088
TEST_TIME 25 9105
TEST_TIME 26 9237
TEST_TIME 27 9204
TEST_TIME 28 9646
TEST_TIME 29 9964
TEST_TIME 30 10704
TEST_TIME 31 11240
TEST_TIME 32 11216
TEST_TIME 33 11066
TEST_TIME 34 11130
TEST_TIME 35 11092
TEST_TIME 36 11208
TEST_TIME 37 11034
TEST_TIME 38 10841
TEST_TIME 39 10645
TEST_TIME 40 10659
TEST_TIME 41 10618
TEST_TIME 42 10455
TEST_TIME 43 10369
TEST_TIME 44 10340
TEST_TIME 45 10241
TEST_TIME 46 10283
TEST_TIME 47 10505
TEST_TIME 48 10354
TEST_TIME 49 10266
TEST_TIME 50 10195
TEST_TIME 51 10114
TEST_TIME 52 10057
TEST_TIME 53 10052
TEST_TIME 54 9959
TEST_TIME 55 9876
TEST_TIME 56 9768
TEST_TIME 57 9688
TEST_TIME 58 9752
TEST_TIME 59 9972
TEST_TIME 60 9948
TEST_TIME 61 9963
TEST_TIME 62 9954
TEST_TIME 63 10024
TEST_TIME 64 10053
TEST_TIME 65 10103
TEST_TIME 66 10128
TEST_TIME 67 10134
TEST_TIME 68 10102
TEST_TIME 69 10135
TEST_TIME 70 10084
TEST_TIME 71 10188
TEST_TIME 72 10183
TEST_TIME 73 10114
TEST_TIME 74 10027
TEST_TIME 75 9997
TEST_TIME 76 9934
TEST_TIME 77 9942
TEST_TIME 78 9890
TEST_TIME 79 9839
TEST_TIME 80 9815
TEST_TIME 81 9730
TEST_TIME 82 9697
TEST_TIME 83 9647
TEST_TIME 84 9668
TEST_TIME 85 9694
TEST_TIME 86 9727
TEST_TIME 87 9710
TEST_TIME 88 9699
TEST_TIME 89 9724
TEST_TIME 90 9723
TEST_TIME 91 9803
TEST_TIME 92 9818
TEST_TIME 93 9859
TEST_TIME 94 9871
TEST_TIME 95 9910
TEST_TIME 96 9859
TEST_TIME 97 9880
TEST_TIME 98 9889
TEST_TIME 99 9837
TEST_TIME 100 9822
TEST_TIME 101 9750
TEST_TIME 102 9732
TEST_TIME 103 9742
TEST_TIME 104 9687
TEST_TIME 105 9633
TEST_TIME 106 9631
TEST_TIME 107 9611
TEST_TIME 108 9619
TEST_TIME 109 9626
TEST_TIME 110 9605
TEST_TIME 111 9645
TEST_TIME 112 9643
TEST_TIME 113 9631
TEST_TIME 114 9631
TEST_TIME 115 9637
TEST_TIME 116 9653
TEST_TIME 117 9627
TEST_TIME 118 9692
TEST_TIME 119 9694
TEST_TIME 120 9614

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-11-2020 22:27:50 to 05-11-2020 22:27:54.

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 1601551 1601551 0 0.00 0 22894 7 0 0
doc_list_biud 1601549 1601549 0 0.00 0 27530 27 0 0
sp_add_invoice_to_stock 5343 5196 147 2.75 41 243376 18755 0 147
sp_cancel_adding_invoice 5960 5960 0 0.00 4 56460 803 0 0
sp_cancel_client_order 1808 1808 0 0.00 4 15435 350 0 0
sp_cancel_customer_reserve 580903 580903 0 0.00 1 33618 60 0 0
sp_cancel_pay_from_customer 735 735 0 0.00 2 6777 84 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 3 1589 69 0 0
sp_cancel_supplier_invoice 6518 6502 16 0.24 2 17100 743 0 16
sp_cancel_supplier_order 430 430 0 0.00 5 946935 101442 0 0
sp_cancel_write_off 11207 11207 0 0.00 1 13219 111 0 0
sp_client_order 21393 21393 0 0.00 3 26253 314 0 0
sp_customer_reserve 482278 482278 0 0.00 0 42464 185 0 0
sp_fill_shopping_cart 32667 32667 0 0.00 1 12445 38 0 0
sp_fill_shopping_cart_clo_res 482278 482278 0 0.00 0 21480 13 0 0
sp_get_clo_for_invoice 5196 5196 0 0.00 0 15447 274 0 0
sp_kill_cost_storno 18322 18322 0 0.00 0 8196 55 0 0
sp_kill_qstorno_ret_qs2qd 1179945 1179945 0 0.00 0 26047 32 0 0
sp_kill_qty_storno 622412 622412 0 0.00 0 27530 69 0 0
sp_lock_selected_doc 21653 21653 0 0.00 0 8755 6 0 0
sp_make_cost_storno 29233 29233 0 0.00 0 20483 57 0 0
sp_multiply_rows_for_pdistr 29231 29231 0 0.00 0 10335 29 0 0
sp_multiply_rows_for_qdistr 21393 21393 0 0.00 0 11001 135 0 0
sp_pay_from_customer 7478 7478 0 0.00 4 17704 117 0 0
sp_pay_to_supplier 6153 6153 0 0.00 4 21368 124 0 0
sp_payment_common 13629 13629 0 0.00 1 16113 33 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 15426 330 0 0
sp_qd_handle_on_invoice_upd_sts 11156 11156 0 0.00 0 17174 327 0 0
sp_qd_handle_on_reserve_upd_sts 10406 10406 0 0.00 0 27529 74 0 0
sp_reserve_write_off 10406 10406 0 0.00 6 27555 198 0 0
sp_supplier_invoice 5554 5554 0 0.00 7 103936 3260 0 0
sp_supplier_order 5722 5722 0 0.00 5 86494 1275 0 0
srv_aggregate_perf_data 106 106 0 0.00 2768 288632 17498 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1417 141746 29421 0 0
srv_find_qd_qs_mism 1104589 1104589 0 0.00 0 19722 6 0 0
srv_make_invnt_saldo 569 569 0 0.00 25 79077 1308 0 0
srv_make_money_saldo 816 816 0 0.00 0 3035 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 105873 365283 288157 0 0
t$perf-abend:sp_add_invoice_to_stock 147 147 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5196 5196 0 0.00 0 8185 172 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 0 2790 87 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 2542 15 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 2612 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 735 735 0 0.00 0 5738 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 5327 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 1312 17 0 0
t$perf-norm:sp_cancel_supplier_order 430 430 0 0.00 0 18457 1607 0 0
t$perf-norm:sp_cancel_write_off 1072 1072 0 0.00 0 2189 10 0 0
t$perf-norm:sp_client_order 21393 21393 0 0.00 0 10520 18 0 0
t$perf-norm:sp_customer_reserve 1076 1076 0 0.00 0 1494 6 0 0
t$perf-norm:sp_pay_from_customer 7478 7478 0 0.00 0 3591 6 0 0
t$perf-norm:sp_pay_to_supplier 6153 6153 0 0.00 0 2722 9 0 0
t$perf-norm:sp_reserve_write_off 10406 10406 0 0.00 0 4834 8 0 0
t$perf-norm:sp_supplier_invoice 5554 5554 0 0.00 0 2840 16 0 0
t$perf-norm:sp_supplier_order 5722 5722 0 0.00 0 9441 17 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 897 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 301 4 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1634 23 0 0
t$perf-norm:srv_make_money_saldo 816 816 0 0.00 0 1247 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 5 0 0
v_add_invoice_to_stock 10686 10392 294 2.75 0 5409 19 0 294
v_all_customers 39398 39398 0 0.00 0 187 1 0 0
v_all_suppliers 31528 31528 0 0.00 0 20 1 0 0
v_all_wares 42786 42786 0 0.00 0 195 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 1442 8 0 0
v_cancel_client_order 3616 3616 0 0.00 0 3282 5 0 0
v_cancel_customer_prepayment 1470 1470 0 0.00 0 5038 6 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 547 4 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 1532 6 0 0
v_cancel_supplier_invoice 850 818 32 3.76 0 1024 18 0 32
v_cancel_supplier_order 860 860 0 0.00 0 605 5 0 0
v_cancel_write_off 2144 2144 0 0.00 0 5226 17 0 0
v_max_id_clo_ord 5722 5722 0 0.00 0 916 2 0 0
v_max_id_clo_res 1076 1076 0 0.00 0 3499 15 0 0
v_max_id_ord_sup 5552 5552 0 0.00 0 4280 3 0 0
v_max_non_paid_invoice 1662 1662 0 0.00 0 718 4 0 0
v_max_non_paid_realizn 3838 3838 0 0.00 0 823 3 0 0
v_min_id_clo_ord 5722 5722 0 0.00 0 6010 12 0 0
v_min_id_clo_res 1076 1076 0 0.00 0 3320 10 0 0
v_min_id_ord_sup 5552 5552 0 0.00 0 6353 7 0 0
v_min_non_paid_invoice 6152 6152 0 0.00 0 10131 20 0 0
v_min_non_paid_realizn 7477 7477 0 0.00 0 10081 25 0 0
v_our_firm 10666 10666 0 0.00 0 15 1 0 0
v_reserve_write_off 20812 20812 0 0.00 0 5367 6 0 0
x_lock_depdocs_on_canc_invoice 12053 12053 0 0.00 0 13989 118 0 0
x_lock_depdocs_on_canc_sup_ord 430 430 0 0.00 0 3697 344 0 0
x_make_qstorno_1000_1200 5722 5722 0 0.00 2 86478 1178 0 0
x_make_qstorno_1200_2000 5554 5554 0 0.00 3 103773 3136 0 0
x_make_qstorno_2100_3300 482278 482278 0 0.00 0 42463 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2020 22:27:55 to 05-11-2020 22:27:59.

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
19:57:04 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:10 13917 8192000000 10212591744 10518843392 873790800 9.638 69 54 111 0 893839952 2502720 17546432
19:57:32 25724 8192000000 10309325584 10625830912 1349107296 14.139 100 75 149 0 1378612896 4541632 24963968
19:58:09 32821 8192000000 10367830464 10688712704 1414957168 14.728 100 86 172 2 1449792816 6377968 28457680
19:58:52 20870 8192000000 10404090400 10730373120 1456769328 15.097 100 89 178 0 1493547856 7745488 29033040
19:59:25 13361 8192000000 10413419648 10742333440 1470628032 15.219 100 87 174 0 1506963248 8167344 28167872
19:59:49 19531 8192000000 10439301344 10771914752 1489301376 15.383 100 88 176 0 1526860480 8959104 28600000
20:00:26 13984 8192000000 10457742304 10794352640 1512411456 15.584 100 88 176 0 1549646432 9507440 27727536
20:00:50 18939 8192000000 10480047296 10823794688 1535185680 15.782 100 86 172 0 1572176352 10096640 26894032
20:01:22 6162 8192000000 10494666416 10841853952 1555990512 15.962 100 78 156 0 1590414192 10481824 23941856
20:01:40 9472 8192000000 10528513616 10879520768 1584087360 16.203 100 83 166 0 1620529648 10984288 25458000
20:02:01 9188 8192000000 10538403312 10894123008 1599602896 16.336 100 82 164 1 1635981520 11126880 25251744
20:02:22 9637 8192000000 10555402544 10913087488 1613259504 16.453 100 78 150 4 1646787920 11040960 22487456
20:02:41 10734 8192000000 10588644640 10948370432 1638496288 16.667 100 80 158 1 1673040096 11079312 23464496
20:02:59 9959 8192000000 10600504288 10964684800 1660603024 16.854 100 81 162 2 1696330304 11829776 23897504
20:03:15 8392 8192000000 10631498128 10996715520 1681956896 17.034 100 81 162 2 1717893936 12371616 23565424
20:03:34 8161 8192000000 10642449456 11016380416 1702499632 17.206 100 80 160 1 1738437520 12805424 23132464
20:03:50 7780 8192000000 10660735760 11030589440 1718045968 17.336 100 82 165 1 1754007696 12969568 22992160
20:04:05 7505 8192000000 10680165632 11051298816 1734836112 17.476 100 80 160 1 1770343776 13276896 22230768
20:04:20 6323 8192000000 10682008032 11059159040 1741695616 17.533 100 82 165 1 1779278064 14156368 23426080
20:04:35 3543 8192000000 10704251136 11079774208 1759328672 17.679 100 80 159 2 1798989024 17411984 22248368
20:04:46 4429 8192000000 10711648240 11088633856 1777399984 17.828 100 85 171 0 1814524208 13377872 23746352
20:04:57 4492 8192000000 10715789312 11097608192 1777012992 17.825 100 84 168 1 1814298416 13414512 23870912
20:05:09 5185 8192000000 10729973296 11106410496 1783280416 17.876 100 85 170 1 1821737728 14503584 23953728
20:05:21 4450 8192000000 10724977760 11107581952 1788692544 17.921 100 78 156 1 1825507632 14279968 22535120
20:05:32 3442 8192000000 10734903776 11116097536 1790858816 17.939 100 83 166 3 1829204096 14312464 24032816
20:05:43 3034 8192000000 10748127264 11127681024 1799081696 18.006 100 88 175 0 1837623408 14198032 24343680
20:05:53 6557 8192000000 10737278912 11124428800 1801956832 18.030 100 79 157 2 1838485600 14531072 21997696
20:06:07 4941 8192000000 10766810496 11147079680 1812155472 18.114 100 88 176 0 1850565904 14303632 24106800
20:06:19 3266 8192000000 10756817776 11145723904 1826245328 18.229 100 93 186 1 1867075584 14553936 26276320
20:06:29 1931 8192000000 10773472752 11161448448 1834548384 18.296 100 92 184 1 1874145344 13481248 26115712
20:06:37 1918 8192000000 10781768784 11167879168 1841229488 18.351 100 97 194 3 1884156528 15586896 27340144
20:06:45 1888 8192000000 10790101360 11173572608 1839369200 18.336 100 89 178 1 1879091760 14337616 25384944
20:06:53 1654 8192000000 10784942832 11174236160 1847384240 18.401 100 87 174 0 1885858992 13268592 25206160
20:07:02 2254 8192000000 10790714720 11179839488 1853637792 18.452 100 92 184 0 1893343264 13359984 26345488
20:07:11 1120 8192000000 10801446304 11188084736 1857307664 18.481 100 86 172 0 1893766448 12181280 24277504
20:07:18 1587 8192000000 10804178768 11195478016 1862117344 18.520 100 95 189 1 1901639312 12507504 27014464
20:07:26 1686 8192000000 10810504032 11197255680 1864782144 18.542 100 91 181 2 1903593184 13243088 25567952
20:07:34 1284 8192000000 10818120560 11205353472 1871238032 18.594 100 93 187 0 1910454560 12540304 26676224
20:07:42 1049 8192000000 10820470288 11211784192 1878160272 18.650 100 93 186 2 1917422368 13250016 26012080
20:07:49 1233 8192000000 10820313648 11209699328 1876827984 18.639 100 91 181 2 1913765376 11369344 25568048
20:07:56 4426 8192000000 10805593776 11212480512 1875139488 18.626 100 57 114 1 1902580672 11888848 15552336
20:08:08 38755 8192000000 10811305936 11219116032 1882194880 18.683 100 59 119 0 1907716096 9123680 16397536
20:08:58 13865 8192000000 10782499664 11213598720 1875426672 18.628 100 29 60 2 1892001360 7564272 9010416
20:09:21 4709 8192000000 10806510000 11220488192 1878076256 18.650 100 34 68 2 1893545360 5804144 9664960
20:09:32 10432 8192000000 10798258928 11222347776 1881660512 18.679 100 33 66 0 1900199600 8046352 10492736
20:09:49 10089 8192000000 10796668544 11221774336 1884129328 18.698 100 21 42 2 1896176320 5810560 6236432
20:10:05 9551 8192000000 10790900656 11224813568 1882360144 18.684 100 16 32 0 1892344944 5731456 4253344
20:10:21 7712 8192000000 10800844544 11231256576 1888843040 18.736 100 19 38 0 1901331840 6580384 5908416
20:10:35 8861 8192000000 10804225344 11235987456 1893318384 18.773 100 21 43 0 1905153536 6114640 5720512
20:10:50 8637 8192000000 10802254992 11236106240 1896469712 18.798 100 19 38 1 1907572096 5898048 5204336
20:11:05 6491 8192000000 10809451696 11238588416 1897850800 18.809 100 25 50 0 1911332016 5951184 7530032
20:11:18 8342 8192000000 10802671120 11240083456 1897132960 18.803 100 25 50 1 1911583456 7181344 7269152
20:11:34 11696 8192000000 10797321600 11241594880 1897697008 18.808 100 26 52 5 1911465008 6995840 6772160
20:11:52 12191 8192000000 10804166032 11242442752 1899774768 18.824 100 19 38 3 1911084608 6427376 4882464
20:12:11 14606 8192000000 10806986976 11246268416 1901859808 18.841 100 19 38 3 1913517216 6663408 4994000
20:12:32 12194 8192000000 10812405920 11248271360 1903274464 18.853 100 12 24 2 1912206560 5646416 3285680
20:12:52 13881 8192000000 10812779104 11254476800 1907486208 18.886 100 29 58 3 1922659312 6061920 9111184
20:13:13 72523 8192000000 10824143088 11261853696 1913150960 18.932 100 32 64 0 1928759376 5538336 10070080
20:14:32 7788 8192000000 10823464384 11265437696 1912945424 18.930 100 17 34 1 1923344064 5216384 5182256
20:14:48 8316 8192000000 10833201264 11271290880 1914928032 18.946 100 30 60 2 1930720320 7508960 8283328
20:15:03 8185 8192000000 10833079008 11268231168 1913327584 18.933 100 22 44 0 1925766064 6288080 6150400
20:15:18 4032 8192000000 10843925088 11273560064 1918200336 18.972 100 46 88 2 1939251152 7448960 13601856
20:15:31 5219 8192000000 10822531072 11251843072 1874281968 18.619 98 35 70 1 1891376656 7188928 9905760
20:15:42 6816 8192000000 10817287936 11253792768 1886869408 18.721 99 29 57 1 1901230528 5981088 8380032
20:15:58 7835 8192000000 10811876224 11253161984 1889586576 18.742 99 34 69 3 1906483664 6469472 10427616
20:16:13 7404 8192000000 10829349152 11259355136 1904756688 18.865 100 30 60 2 1918883888 5903568 8223632
20:16:29 4620 8192000000 10791946256 11221057536 1861309648 18.514 98 32 64 2 1876166032 5547392 9308992
20:16:43 10164 8192000000 10788287152 11219398656 1829428800 18.255 97 21 41 1 1841614736 6090432 6095504
20:17:01 4992 8192000000 10805894896 11230945280 1876538816 18.637 100 31 62 1 1891822480 6382608 8901056
20:17:13 11984 8192000000 10757579408 11189133312 1792789168 17.955 96 13 26 0 1802215056 5860560 3565328
20:17:34 16564 8192000000 10730968592 11148328960 1742984016 17.543 94 31 64 2 1756566144 5047568 8534560
20:17:58 57359 8192000000 10735893504 11153346560 1736948400 17.493 95 53 107 2 1758495664 5343728 16203536
20:19:08 12747 8192000000 10678234688 11095396352 1692533680 17.123 93 19 38 0 1704134368 6010720 5589968
20:19:28 10704 8192000000 10678264928 11084341248 1676787520 16.990 93 23 46 1 1689420928 6174880 6458528
20:19:46 4181 8192000000 10690488544 11100958720 1760005104 17.684 99 34 68 1 1776861584 7473792 9382688
20:19:58 5690 8192000000 10709233552 11122102272 1759679488 17.682 98 30 59 2 1774178000 6572256 7926256
20:20:11 7428 8192000000 10710173296 11125121024 1749042560 17.594 97 27 54 1 1762360736 5591744 7726432
20:20:24 10177 8192000000 10695733360 11112202240 1736166192 17.487 97 17 34 1 1746230000 4893728 5170080
20:20:42 5994 8192000000 10717641696 11120443392 1759332432 17.679 98 37 74 2 1776143392 5131536 11679424
20:20:54 5282 8192000000 10698883664 11119579136 1759706752 17.682 98 20 40 1 1770976288 5653456 5616080
20:21:06 5645 8192000000 10711898032 11127193600 1781059872 17.858 99 36 72 0 1797686560 7067008 9559680
20:21:20 8418 8192000000 10736322688 11147464704 1808144144 18.081 100 37 74 1 1825270160 5939168 11186848
20:21:36 5969 8192000000 10752940848 11162570752 1820758208 18.184 100 34 68 2 1841129168 9762880 10608080
20:21:48 6378 8192000000 10739516848 11156545536 1819468640 18.173 100 37 71 1 1835072384 5094016 10509728
20:22:03 10989 8192000000 10749824544 11169042432 1829587120 18.256 100 18 35 1 1840250272 5067520 5595632
20:22:27 10411 8192000000 10753311776 11174199296 1803969056 18.046 98 28 56 2 1818151040 5988288 8193696
20:22:44 71181 8192000000 10749281632 11181322240 1841165136 18.350 100 25 50 1 1853310176 5231024 6914016
20:24:05 5895 8192000000 10757353840 11187961856 1848916768 18.413 100 20 39 0 1860778464 6334752 5526944
20:24:17 9128 8192000000 10774369136 11192627200 1851323024 18.433 100 31 62 1 1866527312 6798240 8406048
20:24:33 10751 8192000000 10767284096 11194167296 1856243920 18.473 100 33 66 2 1872113136 6993440 8875776
20:24:53 7681 8192000000 10777574928 11199496192 1859399152 18.498 100 27 54 0 1872871008 5590064 7881792
20:25:09 8219 8192000000 10769926400 11201683456 1863288848 18.530 100 35 70 2 1879218720 5538624 10391248
20:25:25 5355 8192000000 10774865216 11203760128 1865207376 18.545 100 22 44 1 1877663792 6485840 5970576
20:25:37 4813 8192000000 10780456416 11204935680 1864306000 18.538 100 21 41 0 1876054496 6034544 5713952
20:25:50 9315 8192000000 10785245584 11207286784 1865918192 18.551 100 22 44 1 1878577456 6282368 6376896
20:26:06 9752 8192000000 10786665984 11216244736 1869058624 18.577 100 31 60 0 1884256976 6021872 9176480
20:26:23 7020 8192000000 10778189872 11213430784 1872515056 18.605 100 28 55 2 1885524768 5073856 7935856
20:26:36 9348 8192000000 10792017504 11221254144 1871432976 18.596 100 21 40 2 1887125856 10049552 5643328
20:26:56 35515 8192000000 10817477200 11235786752 1883222288 18.691 100 33 66 1 1897315232 4321904 9771040
20:27:45 20973 8192000000 10835319808 11255713792 1908425216 18.894 100 43 84 1 1927070352 6818144 11826992
20:28:14 42444 8192000000 10852822432 11280261120 1924702528 19.024 100 54 103 2 1950084720 10466480 14915712
20:29:11 87447 8192000000 10862310720 11294617600 1933087728 19.092 100 38 74 3 1954169472 10533248 10548496
20:31:01 50742 8192000000 10873465312 11315408896 1943554800 19.175 100 27 53 0 1967852544 16107632 8190112
20:32:02 75042 8192000000 10887595968 11323850752 1948508000 19.215 100 25 51 2 1968152560 12284720 7359840
20:33:25 1775 8192000000 10905381168 11321323520 1945887568 19.194 99 79 159 0 1983640832 13087472 24665792
20:33:35 6379 8192000000 10910578064 11328016384 1958029088 19.290 100 64 128 0 1992638160 16160288 18448784
20:33:48 7346 8192000000 10913893920 11332911104 1963251840 19.332 100 65 128 1 1999751536 18310544 18189152
20:34:02 30625 8192000000 10924470656 11347828736 1967023824 19.362 100 69 138 1 2006792672 19589712 20179136
20:34:40 10163 8192000000 10918648176 11347378176 1972144560 19.402 100 58 115 1 2010342320 20467648 17730112
20:34:57 16759 8192000000 10913815472 11345637376 1971604512 19.398 100 48 96 1 2006728688 21196816 13927360
20:35:32 5124 8192000000 10916657136 11351351296 1973772464 19.415 100 51 101 0 2006876352 18333296 14770592
20:35:48 5322 8192000000 10919608880 11346112512 1969898064 19.385 100 51 100 1 2003433680 18627632 14907984
20:36:00 4436 8192000000 10926307248 11349741568 1974533072 19.421 100 60 121 0 2011454192 19527792 17393328
20:36:11 11389 8192000000 10922298448 11344220160 1973810096 19.416 100 65 130 0 2013990624 21016720 19163808
20:36:30 7016 8192000000 10928832944 11354177536 1969375936 19.380 99 70 139 0 2009809456 20528112 19905408
20:36:48 15965 8192000000 10925867952 11352535040 1963142256 19.331 99 59 118 0 1998222816 17604048 17476512
20:37:11 2738 8192000000 10920258352 11346874368 1959571712 19.303 99 60 119 0 1999517168 23564592 16380864
20:37:21 3925 8192000000 10937388272 11356119040 1978786976 19.455 100 65 131 0 2016467440 19059168 18621296
20:37:31 3974 8192000000 10919602752 11340763136 1950428896 19.230 99 65 129 2 1989251904 19869888 18953120
20:37:41 3006 8192000000 10926465216 11351674880 1971088896 19.394 100 60 115 2 2008593488 20889632 16614960
20:37:52 1556 8192000000 10924403184 11340468224 1952312672 19.245 99 70 140 0 1995799280 22374624 21111984
20:38:00 3109 8192000000 10935541008 11351834624 1975292864 19.427 100 68 134 2 2016793072 22046368 19453840
20:38:12 3612 8192000000 10935071280 11352875008 1979192480 19.458 100 78 153 0 2024868688 23178272 22497936
20:38:23 3643 8192000000 10940682656 11363532800 1985290672 19.507 100 67 135 2 2026969280 22748208 18930400
20:38:34 6001 8192000000 10958205216 11374800896 1990081664 19.544 100 72 143 0 2034187888 23379856 20726368
20:38:46 2967 8192000000 10932371664 11356516352 1969848688 19.384 99 66 130 0 2011419040 23197872 18372480
20:38:56 2572 8192000000 10909310592 11333267456 1951594352 19.239 99 65 127 2 1994534656 24478944 18461360
20:39:06 8773 8192000000 10890815600 11308384256 1911853168 18.922 98 57 112 0 1952125680 23752032 16520480
20:39:22 3029 8192000000 10903069072 11321061376 1938777600 19.137 99 79 158 2 1987403760 25595040 23031120
20:39:33 3654 8192000000 10904111584 11327746048 1950185808 19.228 100 70 140 1 1998080752 26305216 21589728
20:39:43 4388 8192000000 10934510096 11346731008 1965673776 19.351 100 82 165 0 2018387728 28054144 24659808
20:39:57 2435 8192000000 10924648224 11335090176 1952763696 19.248 100 76 150 1 2004560768 29274096 22522976
20:40:08 2102 8192000000 10934258064 11346948096 1965114288 19.347 100 77 153 1 2017551296 29787568 22649440
20:40:17 2642 8192000000 10925162160 11342241792 1935769504 19.113 98 71 142 1 1984055568 27671312 20614752
20:40:27 2447 8192000000 10927126096 11337330688 1942525600 19.167 99 71 139 1 1993062224 28523376 22013248
20:40:36 1636 8192000000 10928133840 11346771968 1964314112 19.340 100 83 165 1 2018082240 29561168 24206960
20:40:46 3764 8192000000 10917682544 11332136960 1946458976 19.198 99 74 147 0 1999605632 30961728 22184928
20:40:58 3995 8192000000 10901460464 11317592064 1935483760 19.111 100 64 127 2 1985765312 31479424 18802128
20:41:08 5727 8192000000 10927986608 11337842688 1949176320 19.220 100 74 146 1 2003141616 32014784 21950512
20:41:21 2796 8192000000 10912012832 11324022784 1941474784 19.159 100 92 182 0 1996934688 27082544 28377360
20:41:30 3349 8192000000 10909772608 11321589760 1938896544 19.138 100 84 167 1 1989712880 26018768 24797568
20:41:40 4517 8192000000 10916440336 11321466880 1943963216 19.178 100 81 162 2 1994154192 24702704 25488272
20:41:51 1854 8192000000 10898406032 11309146112 1905130224 18.868 98 78 156 1 1954838960 25944416 23764320
20:42:01 4817 8192000000 10900481120 11318829056 1942729248 19.169 100 74 147 0 1991066640 25867072 22470320
20:42:15 2637 8192000000 10895700896 11310256128 1910908944 18.914 99 67 133 1 1962005216 31655280 19440992
20:42:25 8327 8192000000 10892181008 11309481984 1931631392 19.080 100 70 140 1 1980564592 28066496 20866704
20:42:41 4845 8192000000 10908023344 11321724928 1943597600 19.175 100 70 140 0 1993271440 28981968 20691872
20:42:56 3818 8192000000 10919017440 11330318336 1947035584 19.203 100 82 165 0 2000354944 29035792 24283568
20:43:06 3798 8192000000 10923846928 11338502144 1953730592 19.256 100 64 126 1 2002392240 29701712 18959936
20:43:16 5120 8192000000 10939100736 11349536768 1958398464 19.293 100 62 125 1 2009545536 32135104 19011968
20:43:29 1415 8192000000 10913013920 11316469760 1930228576 19.069 98 90 179 2 1988133168 31493264 26411328
20:43:38 2654 8192000000 10932679168 11350478848 1958551648 19.295 100 77 154 2 2014188064 32967712 22668704
20:43:47 3301 8192000000 10944998112 11352133632 1961824976 19.321 100 79 157 0 2018270672 33650736 22794960
20:43:58 4984 8192000000 10946865648 11360731136 1965857952 19.353 100 74 148 1 2022933648 33936288 23139408
20:44:11 3581 8192000000 10919273712 11334103040 1932997776 19.091 99 79 158 0 1990655680 34155056 23502848
20:44:22 2399 8192000000 10942951024 11349913600 1948343024 19.213 99 87 173 0 2008457568 34766496 25348048
20:44:32 4676 8192000000 10935964256 11354214400 1963098336 19.331 100 73 143 1 2021460848 35797472 22565040
20:44:44 1814 8192000000 10948082816 11352571904 1965542176 19.350 100 92 181 0 2027436112 35443664 26450272
20:44:53 2524 8192000000 10937227520 11353313280 1965523488 19.350 100 79 158 2 2024357472 35313552 23520432
20:45:03 1828 8192000000 10957723920 11364171776 1968916352 19.377 100 88 177 0 2032432512 35862272 27653888
20:45:13 1737 8192000000 10961549072 11370737664 1970258144 19.387 100 87 174 1 2036062640 39170864 26633632
20:45:23 4014 8192000000 10945216704 11377147904 1971231648 19.395 100 61 122 0 2032514432 41804224 19478560
20:45:48 6104 8192000000 10937836320 11366240256 1952794944 19.249 99 51 102 0 2010211456 40733184 16683328
20:46:02 3157 8192000000 10977562400 11385098240 1978135520 19.450 100 77 154 0 2043975856 42093792 23746544
20:46:12 3703 8192000000 10951260272 11360821248 1958756320 19.296 100 79 156 2 2028202256 45011856 24434080
20:46:26 6604 8192000000 10931799024 11344646144 1928760368 19.057 99 78 156 0 1999226608 46110768 24355472
20:46:41 2546 8192000000 10927842512 11338051584 1935439488 19.110 99 74 148 0 2009514240 50173360 23901392
20:46:52 5954 8192000000 10959041024 11363528704 1954259296 19.260 100 78 155 2 2030458960 51322032 24877632
20:47:08 2909 8192000000 10969821440 11379220480 1967340448 19.364 100 82 162 2 2045417856 52336944 25740464
20:47:18 1871 8192000000 10976194128 11379195904 1968997520 19.377 100 91 179 1 2051124608 53826864 28300224
20:47:28 2268 8192000000 10976962304 11382812672 1969042784 19.378 100 91 176 1 2052606912 55192496 28371632
20:47:48 2107 8192000000 10978031472 11390644224 1976282048 19.435 100 80 161 3 2058105488 55701344 26122096
20:47:57 2605 8192000000 10974633760 11388116992 1973612304 19.414 100 85 169 0 2055590912 55052400 26926208
20:48:07 3220 8192000000 10968853712 11387830272 1977904336 19.448 100 78 156 1 2051961856 49383824 24673696
20:48:17 2537 8192000000 10978570192 11393892352 1982927824 19.488 100 78 156 1 2058179616 49974768 25277024
20:48:29 3586 8192000000 10978114800 11393003520 1976638224 19.438 100 76 152 3 2052205584 51116320 24451040
20:48:49 10877 8192000000 10968797488 11397324800 1978791168 19.455 100 55 110 0 2051620496 53959696 18869632
20:49:10 7351 8192000000 10965375840 11407757312 1980043152 19.465 100 50 100 0 2050466960 53232656 17191152
20:49:25 3982 8192000000 10963757408 11399921664 1976862080 19.440 100 48 96 3 2044443104 50513600 17067424
20:49:40 2751 8192000000 10973407488 11401502720 1985553280 19.509 100 69 139 2 2057475264 49295904 22626080
20:49:57 3894 8192000000 10978391584 11391037440 1981375456 19.476 100 79 155 1 2052914896 47369008 24170432
20:50:14 5248 8192000000 10964819824 11382575104 1974582992 19.422 100 71 142 2 2044901728 47753136 22565600
20:50:27 3280 8192000000 10959372992 11378634752 1969732944 19.383 100 73 145 0 2038863152 46622960 22507248
20:50:36 8083 8192000000 10959802544 11394248704 1980901808 19.472 100 60 120 1 2050767648 50404672 19461168
20:51:02 8114 8192000000 10974531344 11410247680 1990415008 19.547 100 46 92 2 2058383280 51937536 16030736
20:51:20 16559 8192000000 10984530672 11425513472 1993480720 19.571 100 41 82 0 2066044000 58801552 13761728
20:51:56 13017 8192000000 10979730528 11416244224 1978713552 19.455 99 48 97 5 2050841344 55911984 16215808
20:52:22 25260 8192000000 10972774176 11419697152 1991226608 19.553 100 44 87 2 2057288320 51117072 14944640
20:52:56 16449 8192000000 10971700720 11416592384 1993794528 19.574 100 41 82 0 2059767520 51765248 14207744
20:53:25 28063 8192000000 10964777920 11414077440 1974614800 19.422 99 33 66 1 2036992480 50488864 11888816
20:54:05 15242 8192000000 10970699456 11420516352 1986758112 19.518 100 31 62 1 2056265344 57879424 11627808
20:54:59 38572 8192000000 10949608352 11419627520 1966212512 19.355 100 24 48 3 2034161456 58916384 9032560
20:55:51 36306 8192000000 10935619648 11419246592 1959073600 19.299 100 13 26 0 2017138864 53156640 4908624
20:56:37 38284 8192000000 10934492880 11412422656 1929818784 19.065 99 14 28 0 2004382432 69082272 5481376
20:57:24 19811 8192000000 10941510272 11417157632 1948896304 19.218 100 15 30 2 2021088032 67383696 4808032
20:57:50 3313 8192000000 10961000288 11425529856 1963986720 19.338 100 29 58 2 2040953472 67558368 9408384
20:59:29 67949 8192000000 10931121696 11381694464 1927510672 19.047 97 21 42 0 1945555872 12380896 5664304
21:00:46 18598 8192000000 10942837088 11385196544 1994986480 19.583 100 43 85 1 2018236672 11032464 12217728
21:01:11 102368 8192000000 10914110512 11378360320 1951825664 19.241 98 12 24 0 1967717920 12291152 3601104
21:03:47 62584 8192000000 10946798976 11405869056 2002624544 19.643 100 20 38 1 2020602784 12507952 5470288
21:05:01 102590 8192000000 10950296144 11406618624 2005761312 19.668 100 20 40 1 2019236416 7649216 5825888
21:06:52 24526 8192000000 10965613808 11418382336 2017052768 19.757 100 31 60 4 2035256016 9135568 9067680
21:07:25 74424 8192000000 10951762672 11423969280 1975709904 19.431 98 27 54 0 1996872592 13539424 7623264
21:08:50 40541 8192000000 10929499600 11408486400 1988463072 19.532 99 17 34 1 2007881216 14235600 5182544
21:09:37 26709 8192000000 10927790944 11401613312 1985181296 19.506 99 11 22 0 2002223168 14021728 3020144
21:10:11 17744 8192000000 10935505872 11402600448 2001155072 19.632 100 13 26 1 2015573552 10524048 3894432
21:10:36 1670 8192000000 10956766400 11415941120 2019682080 19.778 100 43 87 1 2044982560 12676416 12624064
21:10:44 9253 8192000000 10961473168 11420393472 2015205008 19.742 100 24 48 1 2034835296 11786832 7843456
21:11:00 24874 8192000000 10941180176 11416702976 2000419168 19.626 99 28 56 1 2023421552 14851328 8151056
21:11:43 47186 8192000000 10950179760 11407048704 1968337968 19.372 98 26 51 3 1994193056 18039824 7815264
21:12:57 27131 8192000000 10924785776 11377106944 1970988016 19.393 99 31 62 1 1993777552 13147840 9641696
21:13:37 42559 8192000000 10922835520 11408691200 1992979952 19.567 100 28 56 2 2022875616 21265600 8630064
21:15:07 12934 8192000000 10926473792 11414790144 2001559504 19.635 100 10 20 0 2015683488 11312976 2811008
21:15:28 30970 8192000000 10917826768 11389521920 1966946544 19.361 98 15 31 0 1978295824 6892032 4457248
21:16:08 64374 8192000000 10891770672 11368415232 1947343216 19.205 97 12 24 0 1957970592 7220080 3407296
21:17:19 39297 8192000000 10913072400 11391508480 1991150336 19.553 100 13 27 1 2003485520 8443504 3891680
21:18:42 35890 8192000000 10916192464 11396321280 1980505616 19.469 99 20 39 1 1997042432 10926976 5609840
21:19:33 40620 8192000000 10905608416 11388260352 1958813504 19.297 98 10 20 0 1972105168 10590704 2700960
21:20:21 54634 8192000000 10885469488 11369869312 1921251280 18.997 97 9 18 0 1934646672 11274928 2120464
21:21:24 64497 8192000000 10913324368 11386535936 1917392976 18.966 96 28 56 1 1934158032 9579120 7185936
21:22:38 49217 8192000000 10900048976 11376955392 1924294384 19.021 97 16 32 2 1945368208 16380960 4692864
21:23:33 39483 8192000000 10888846768 11362795520 1932403680 19.086 98 11 21 1 1958881744 22834000 3644064
21:24:32 77353 8192000000 10900102384 11377721344 1946343568 19.197 99 16 32 1 1974198176 23155024 4699584
21:25:56 60250 8192000000 10833851456 11318685696 1834911744 18.299 94 8 16 0 1858708288 21655056 2141488
21:27:03 20396 8192000000 10878527136 11342606336 1949274384 19.221 100 18 36 0 1959810448 6216272 4319792
21:27:31 21336 8192000000 10899805344 11364311040 1953858368 19.257 99 43 86 1 1974522400 8764176 11899856
21:28:05 51775 8192000000 10910856752 11378475008 1947666448 19.208 99 28 56 2 1964228752 9701888 6860416
21:29:38 44395 8192000000 10917112688 11401502720 1979604720 19.462 100 18 36 0 2009628960 24925456 5098784
21:30:33 78404 8192000000 10894274288 11383435264 1885134896 18.707 95 11 22 1 1908652384 20171616 3345872
21:31:57 68369 8192000000 10884326768 11355410432 1875523920 18.629 95 17 34 0 1894737424 13929584 5283920
21:33:13 84200 8192000000 10881076432 11357900800 1843132960 18.366 94 10 20 1 1860270848 14744976 2392912
21:34:43 87919 8192000000 10869181248 11325169664 1820955152 18.185 93 25 50 1 1837015584 9025248 7035184
21:36:19 72729 8192000000 10881160592 11342962688 1899877616 18.825 98 19 36 2 1914458640 9492528 5088496
21:37:40 46767 8192000000 10900750992 11348176896 1906543296 18.879 98 40 80 2 1931734608 13960080 11231232
21:38:39 60651 8192000000 10898089360 11368886272 1928408832 19.054 99 20 40 0 1947717728 13588976 5719920
21:39:47 134828 8192000000 10890133392 11363348480 1940225760 19.149 99 22 44 2 1958610128 12053088 6331280
21:43:20 41906 8192000000 10865384656 11337854976 1939269216 19.141 99 23 45 4 1957741168 11874672 6597280
21:44:10 63865 8192000000 10863999216 11350999040 1935897664 19.114 99 9 18 1 1950787344 12242336 2647344
21:45:20 25670 8192000000 10860201728 11337269248 1929633440 19.064 99 7 14 0 1938609888 7139248 1837200
21:46:01 45839 8192000000 10872763712 11336081408 1932340848 19.086 99 21 42 0 1945221344 6766688 6113808
21:46:53 54483 8192000000 10882845440 11362885632 1957625984 19.287 100 12 24 0 1968434784 7108944 3699856
21:47:58 77152 8192000000 10879449728 11347738624 1924180272 19.020 98 19 38 1 1941717744 12077088 5460384
21:50:00 102705 8192000000 10899679888 11367763968 1962406096 19.325 100 12 24 1 1984083728 17767664 3909968
21:51:54 65255 8192000000 10892141696 11374215168 1949716320 19.224 99 11 22 0 1968138080 15055616 3366144
21:53:20 61164 8192000000 10910453568 11381338112 1978335456 19.452 100 15 30 2 1992387024 9518288 4533280
21:54:30 28776 8192000000 10895437904 11352281088 1944599520 19.183 99 24 48 0 1959832688 8398496 6834672
21:55:08 43090 8192000000 10890825040 11364773888 1951304352 19.237 99 23 46 0 1972666640 15377040 5985248
21:55:57 60414 8192000000 10902813344 11382091776 1958515296 19.294 99 32 64 0 1980119600 12642144 8962160
21:57:04 37607 8192000000 10889432080 11368914944 1936322608 19.117 98 12 24 1 1950337808 10998112 3017088
21:57:54 92100 8192000000 10910275520 11392765952 1957192880 19.284 99 10 20 0 1976552064 17139488 2219696
21:59:32 72489 8192000000 10913416752 11395493888 1961855376 19.321 99 11 22 1 1981593648 17252992 2485280
22:00:51 141746 8192000000 10895824448 11367661568 1834940032 18.300 92 14 28 1 1851020256 12647552 3432672
22:03:18 45815 8192000000 10910605376 11356532736 1899011680 18.818 96 26 52 0 1915715712 9525424 7178608
22:04:16 28171 8192000000 10891852192 11337302016 1906556816 18.879 97 45 89 2 1929037776 11052608 11428352
22:05:07 51667 8192000000 10913733600 11371446272 1933616160 19.096 98 35 70 0 1955424032 12103648 9704224
22:06:06 111919 8192000000 10892344880 11363643392 1953166080 19.252 99 35 70 3 1974477680 11079136 10232464
22:08:08 59684 8192000000 10891156256 11356073984 1919883344 18.986 97 33 66 0 1942394736 13045600 9465792
22:09:19 48024 8192000000 10880416944 11357564928 1954563952 19.263 100 13 26 2 1968983648 10623872 3795824
22:10:14 59915 8192000000 10873270208 11362295808 1957571120 19.287 100 11 22 0 1970666208 9937376 3157712
22:11:20 45108 8192000000 10879860752 11354906624 1903406400 18.854 97 7 14 0 1913122704 7805360 1910944
22:12:11 66832 8192000000 10867610272 11339300864 1883162896 18.691 96 12 24 0 1896113536 8968752 3981888
22:13:36 90127 8192000000 10851794592 11336187904 1911772736 18.921 98 23 46 0 1931371872 12569232 7029904
22:15:24 60446 8192000000 10832958304 11315232768 1895556224 18.791 97 17 35 1 1909353200 9094928 4702048
22:16:32 57504 8192000000 10874257840 11338305536 1876268304 18.635 96 13 26 1 1890293216 10838864 3186048
22:17:40 67038 8192000000 10846425280 11319574528 1848830912 18.413 95 21 42 1 1869420480 14606608 5982960
22:18:54 62448 8192000000 10853570336 11317800960 1834679616 18.297 95 11 22 0 1849027392 11396576 2951200
22:20:05 31263 8192000000 10864381584 11324076032 1915426256 18.950 99 34 68 4 1934135344 9466656 9242432
22:20:47 18679 8192000000 10842483552 11291320320 1858353792 18.490 97 39 76 1 1878492864 9165712 10973360
22:21:18 14706 8192000000 10847175232 11299069952 1912449024 18.926 100 45 90 0 1935978944 11274368 12255552
22:21:40 35600 8192000000 10857962688 11308900352 1887167200 18.723 98 40 81 1 1908983232 10343680 11472352
22:22:24 39797 8192000000 10867002432 11325669376 1915155248 18.948 99 28 56 0 1932000192 9488688 7356256
22:23:10 41254 8192000000 10866514032 11327877120 1874208480 18.618 97 35 70 1 1894042944 10172688 9661776
22:23:58 71569 8192000000 10879802016 11337953280 1883451344 18.693 97 33 65 1 1906029248 14039456 8538448
22:25:17 50771 8192000000 10860379520 11355402240 1918584384 18.975 99 28 56 4 1942367936 16204544 7579008
22:26:17 52202 8192000000 9695161680 10035494912 825901344 9.158 43 6 11 1 834616928 7081584 1634000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 05-11-2020 22:28:00 to 05-11-2020 22:28:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 147 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-11-2020 22:28:34 to 05-11-2020 22:28:36.

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          250854
MON$OLDEST_ACTIVE               251127
MON$OLDEST_SNAPSHOT             251127
MON$NEXT_TRANSACTION            251127
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                       2055392
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:72: 
:73: mscs-test-161.budzdorov.ru    Thu Nov  5 22:27:15 2020
:74:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:75: 
:76: 
:77: mscs-test-161.budzdorov.ru    Thu Nov  5 22:27:17 2020
:78:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:79: 
:80: 
:81: mscs-test-161.budzdorov.ru    Thu Nov  5 22:27:17 2020
:82:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:83: 
--- end of diff output ---

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

05.11.20 22:28:37. 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-05 22:28:40 No severe PSQL-related problems occured
05.11.20 22:28:41. End of report.