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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-23 01:27:08
DTS_END                         2020-12-23 01:27:08.5110
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/38572
TRN_ID                          249980
ATT_ID                          659
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: 9659.43 21211 1159132
customer order: creation 181.32 346 21758
customer order: refuse 15.49 261 1859
order to supplier: creation 47.38 1080 5686
order to supplier: removal 3.83 76921 459
invoice (draft): creation 47.13 2732 5655
invoice (draft): removal 56.97 553 6836
invoice accept: apply 42.85 15619 5142
invoice accept: cancel 51.62 617 6194
customer reserve: creation 3926.90 157 471228
customer reserve: removal 4973.25 47 596790
realization accept: apply 87.22 138 10466
realization accept: cancel 90.71 91 10885
payment from customer: creation 61.13 102 7335
payment from customer: removal 5.93 79 712
payment to supplier: creation 51.83 113 6220
payment to supplier: removal 3.47 47 416
service: total inventory turnovers 4.92 1177 590
service: total monetary turnovers 6.55 20 786
service: aggregate perf. data 0.93 16830 111
service: refresh index statistics 0.03 307292 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5078
TEST_TIME 2 5539
TEST_TIME 3 5580
TEST_TIME 4 5500
TEST_TIME 5 5919
TEST_TIME 6 5992
TEST_TIME 7 6249
TEST_TIME 8 6283
TEST_TIME 9 7166
TEST_TIME 10 7733
TEST_TIME 11 8022
TEST_TIME 12 8502
TEST_TIME 13 9134
TEST_TIME 14 9165
TEST_TIME 15 9635
TEST_TIME 16 9519
TEST_TIME 17 9768
TEST_TIME 18 10325
TEST_TIME 19 11455
TEST_TIME 20 12160
TEST_TIME 21 12517
TEST_TIME 22 12409
TEST_TIME 23 12236
TEST_TIME 24 11884
TEST_TIME 25 11708
TEST_TIME 26 11811
TEST_TIME 27 11597
TEST_TIME 28 11462
TEST_TIME 29 11278
TEST_TIME 30 11100
TEST_TIME 31 11282
TEST_TIME 32 11126
TEST_TIME 33 10932
TEST_TIME 34 10704
TEST_TIME 35 10544
TEST_TIME 36 10512
TEST_TIME 37 10560
TEST_TIME 38 10661
TEST_TIME 39 10520
TEST_TIME 40 10628
TEST_TIME 41 10523
TEST_TIME 42 10569
TEST_TIME 43 10463
TEST_TIME 44 10386
TEST_TIME 45 10692
TEST_TIME 46 10697
TEST_TIME 47 10606
TEST_TIME 48 10846
TEST_TIME 49 10750
TEST_TIME 50 10762
TEST_TIME 51 10630
TEST_TIME 52 10449
TEST_TIME 53 10393
TEST_TIME 54 10362
TEST_TIME 55 10333
TEST_TIME 56 10284
TEST_TIME 57 10217
TEST_TIME 58 10192
TEST_TIME 59 10083
TEST_TIME 60 10131
TEST_TIME 61 10123
TEST_TIME 62 10095
TEST_TIME 63 10054
TEST_TIME 64 10057
TEST_TIME 65 10088
TEST_TIME 66 10156
TEST_TIME 67 10096
TEST_TIME 68 10079
TEST_TIME 69 10139
TEST_TIME 70 10205
TEST_TIME 71 10208
TEST_TIME 72 10300
TEST_TIME 73 10308
TEST_TIME 74 10335
TEST_TIME 75 10248
TEST_TIME 76 10171
TEST_TIME 77 10161
TEST_TIME 78 10113
TEST_TIME 79 10124
TEST_TIME 80 10052
TEST_TIME 81 10022
TEST_TIME 82 9973
TEST_TIME 83 9881
TEST_TIME 84 9894
TEST_TIME 85 9864
TEST_TIME 86 9888
TEST_TIME 87 9917
TEST_TIME 88 9890
TEST_TIME 89 9922
TEST_TIME 90 9920
TEST_TIME 91 9925
TEST_TIME 92 9899
TEST_TIME 93 10021
TEST_TIME 94 10024
TEST_TIME 95 10034
TEST_TIME 96 10033
TEST_TIME 97 9997
TEST_TIME 98 10102
TEST_TIME 99 10059
TEST_TIME 100 10019
TEST_TIME 101 9966
TEST_TIME 102 9972
TEST_TIME 103 9935
TEST_TIME 104 9926
TEST_TIME 105 9871
TEST_TIME 106 9834
TEST_TIME 107 9797
TEST_TIME 108 9806
TEST_TIME 109 9748
TEST_TIME 110 9743
TEST_TIME 111 9720
TEST_TIME 112 9695
TEST_TIME 113 9693
TEST_TIME 114 9714
TEST_TIME 115 9732
TEST_TIME 116 9691
TEST_TIME 117 9740
TEST_TIME 118 9754
TEST_TIME 119 9735
TEST_TIME 120 9665

Performance per minute, chart


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

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 1599456 1599456 0 0.00 0 13176 5 0 0
doc_list_biud 1599456 1599456 0 0.00 0 32968 22 0 0
sp_add_invoice_to_stock 5217 5142 75 1.43 31 149607 15619 0 75
sp_cancel_adding_invoice 6194 6194 0 0.00 5 67851 618 0 0
sp_cancel_client_order 1859 1859 0 0.00 4 9645 262 0 0
sp_cancel_customer_reserve 596790 596790 0 0.00 1 21007 48 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 9542 80 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 2397 47 0 0
sp_cancel_supplier_invoice 6838 6836 2 0.02 2 33031 553 0 2
sp_cancel_supplier_order 459 459 0 0.00 4 1153092 76921 0 0
sp_cancel_write_off 10885 10885 0 0.00 1 5292 91 0 0
sp_client_order 21758 21758 0 0.00 3 25438 347 0 0
sp_customer_reserve 471228 471228 0 0.00 0 77948 157 0 0
sp_fill_shopping_cart 33097 33097 0 0.00 1 19834 32 0 0
sp_fill_shopping_cart_clo_res 471218 471218 0 0.00 0 15517 13 0 0
sp_get_clo_for_invoice 5132 5132 0 0.00 0 36265 308 0 0
sp_kill_cost_storno 18207 18207 0 0.00 0 7389 41 0 0
sp_kill_qstorno_ret_qs2qd 1211760 1211760 0 0.00 0 32966 25 0 0
sp_kill_qty_storno 638621 638621 0 0.00 0 32967 54 0 0
sp_lock_selected_doc 21687 21687 0 0.00 0 9481 5 0 0
sp_make_cost_storno 29153 29153 0 0.00 0 13161 42 0 0
sp_multiply_rows_for_pdistr 29153 29153 0 0.00 0 10680 25 0 0
sp_multiply_rows_for_qdistr 21758 21758 0 0.00 0 12448 166 0 0
sp_pay_from_customer 7335 7335 0 0.00 4 21925 103 0 0
sp_pay_to_supplier 6220 6220 0 0.00 4 11837 113 0 0
sp_payment_common 13555 13555 0 0.00 1 21293 25 0 0
sp_qd_handle_on_cancel_clo 1859 1859 0 0.00 0 8340 235 0 0
sp_qd_handle_on_invoice_upd_sts 11326 11326 0 0.00 0 18875 249 0 0
sp_qd_handle_on_reserve_upd_sts 10466 10466 0 0.00 0 17891 46 0 0
sp_reserve_write_off 10466 10466 0 0.00 6 17969 139 0 0
sp_supplier_invoice 5655 5655 0 0.00 7 87913 2733 0 0
sp_supplier_order 5686 5686 0 0.00 5 93762 1080 0 0
srv_aggregate_perf_data 111 111 0 0.00 3035 203487 16831 0 0
srv_fill_mon_cache_memory 150 150 0 0.00 209 167709 36129 0 0
srv_find_qd_qs_mism 1111701 1111701 0 0.00 0 13143 5 0 0
srv_make_invnt_saldo 590 590 0 0.00 27 103300 1178 0 0
srv_make_money_saldo 786 786 0 0.00 0 3039 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 164458 560398 307292 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5142 5142 0 0.00 0 14275 142 0 0
t$perf-norm:sp_cancel_adding_invoice 430 430 0 0.00 0 6235 118 0 0
t$perf-norm:sp_cancel_client_order 1859 1859 0 0.00 0 3646 15 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 1749 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2689 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 605 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 6111 37 0 0
t$perf-norm:sp_cancel_supplier_order 459 459 0 0.00 0 16832 1258 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 5355 16 0 0
t$perf-norm:sp_client_order 21758 21758 0 0.00 0 8937 15 0 0
t$perf-norm:sp_customer_reserve 1061 1061 0 0.00 0 1680 5 0 0
t$perf-norm:sp_pay_from_customer 7335 7335 0 0.00 0 6400 8 0 0
t$perf-norm:sp_pay_to_supplier 6220 6220 0 0.00 0 5406 9 0 0
t$perf-norm:sp_reserve_write_off 10466 10466 0 0.00 0 8434 15 0 0
t$perf-norm:sp_supplier_invoice 5655 5655 0 0.00 0 6959 14 0 0
t$perf-norm:sp_supplier_order 5686 5686 0 0.00 0 11605 13 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 165 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 150 150 0 0.00 0 231 5 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 585 14 0 0
t$perf-norm:srv_make_money_saldo 786 786 0 0.00 0 472 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10414 10264 150 1.44 0 9218 18 0 150
v_all_customers 39352 39352 0 0.00 0 18 0 0 0
v_all_suppliers 31574 31574 0 0.00 0 20 1 0 0
v_all_wares 43516 43516 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 860 860 0 0.00 0 595 6 0 0
v_cancel_client_order 3718 3718 0 0.00 0 2665 5 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 2136 4 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 541 3 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 330 3 0 0
v_cancel_supplier_invoice 876 872 4 0.45 0 3161 24 0 4
v_cancel_supplier_order 918 918 0 0.00 0 9907 18 0 0
v_cancel_write_off 2102 2102 0 0.00 0 2013 12 0 0
v_max_id_clo_ord 5686 5686 0 0.00 0 1358 1 0 0
v_max_id_clo_res 1061 1061 0 0.00 0 5927 15 0 0
v_max_id_ord_sup 5653 5653 0 0.00 0 4677 5 0 0
v_max_non_paid_invoice 1772 1772 0 0.00 0 1647 5 0 0
v_max_non_paid_realizn 3971 3971 0 0.00 0 1527 3 0 0
v_min_id_clo_ord 5686 5686 0 0.00 0 2589 4 0 0
v_min_id_clo_res 1061 1061 0 0.00 0 2086 5 0 0
v_min_id_ord_sup 5653 5653 0 0.00 0 5523 9 0 0
v_min_non_paid_invoice 6220 6220 0 0.00 0 3099 11 0 0
v_min_non_paid_realizn 7335 7335 0 0.00 0 16286 16 0 0
v_our_firm 10892 10892 0 0.00 0 11 1 0 0
v_reserve_write_off 20932 20932 0 0.00 0 9252 6 0 0
x_lock_depdocs_on_canc_invoice 12594 12594 0 0.00 0 23179 109 0 0
x_lock_depdocs_on_canc_sup_ord 459 459 0 0.00 0 16058 289 0 0
x_make_qstorno_1000_1200 5686 5686 0 0.00 2 93744 1020 0 0
x_make_qstorno_1200_2000 5655 5655 0 0.00 4 87905 2608 0 0
x_make_qstorno_2100_3300 471228 471228 0 0.00 0 77947 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-12-2020 01:28:04 to 23-12-2020 01:28:08.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 21958 8192000000 10297551488 10610987008 1111118880 11.943 83 71 141 1 1137270528 3463200 22688448
22:57:50 29752 8192000000 10373176688 10696884224 1423050736 14.800 100 89 177 1 1457482848 5830112 28602000
22:58:32 34043 8192000000 10416025376 10740871168 1458211584 15.110 100 88 176 0 1493776896 7366096 28199216
22:59:16 21409 8192000000 10437653776 10767253504 1486983104 15.363 100 92 184 3 1525297216 8138304 30175808
22:59:44 18427 8192000000 10446718768 10780237824 1504108592 15.512 100 94 188 0 1543192512 8894896 30189024
23:00:26 22766 8192000000 10470079632 10809040896 1523434800 15.680 100 94 186 2 1563417104 10085184 29897120
23:01:02 14709 8192000000 10487903280 10829438976 1541080496 15.833 100 80 161 0 1576222592 10096656 25045440
23:01:27 15114 8192000000 10503819504 10851639296 1557891872 15.978 100 86 172 1 1595088816 10660672 26536272
23:01:52 11737 8192000000 10536069776 10890014720 1587558544 16.233 100 83 166 0 1624269424 11053712 25657168
23:02:12 13256 8192000000 10548576128 10908631040 1614674576 16.465 100 74 148 0 1647753936 10607392 22471968
23:02:37 8832 8192000000 10586692624 10946932736 1644961808 16.722 100 86 172 0 1682740640 11766656 26012176
23:02:56 8792 8192000000 10598730192 10964520960 1661882480 16.865 100 79 157 3 1697146736 11176832 24087424
23:03:12 9301 8192000000 10622476224 10988118016 1680012224 17.017 100 75 150 2 1713175680 10849136 22314320
23:03:32 5249 8192000000 10637176688 11006554112 1702285808 17.204 100 74 148 3 1735177664 11451504 21440352
23:03:44 5762 8192000000 10657413104 11028525056 1719205504 17.346 100 80 160 0 1755228448 12850304 23172640
23:03:57 4910 8192000000 10666555648 11044151296 1729070336 17.428 100 81 160 3 1764426304 12603936 22752032
23:04:09 4827 8192000000 10676029200 11055243264 1745306608 17.563 100 80 158 1 1779430912 11955552 22168752
23:04:20 4336 8192000000 10690054288 11069906944 1759615280 17.681 100 79 158 1 1794062832 12573344 21874208
23:04:33 3706 8192000000 10712554864 11089854464 1779456576 17.845 100 95 190 0 1819503744 13558256 26488912
23:04:44 3139 8192000000 10715703680 11094466560 1781223984 17.860 100 84 169 1 1818675408 13982176 23469248
23:04:53 3298 8192000000 10726798816 11107270656 1787770320 17.913 100 83 166 0 1823619520 13264016 22585184
23:05:03 3177 8192000000 10739917104 11116732416 1794220320 17.966 100 86 172 1 1832177232 14487648 23469264
23:05:13 2801 8192000000 10744984864 11127029760 1803293552 18.041 100 88 178 0 1842999248 15161200 24544496
23:05:22 2217 8192000000 10749783360 11132063744 1804913264 18.054 100 86 172 2 1844409248 15509552 23986432
23:05:31 2450 8192000000 10752173136 11137433600 1813521808 18.125 100 82 165 2 1850987440 14694784 22770848
23:05:40 3080 8192000000 10763448208 11148828672 1820274144 18.180 100 87 173 0 1858370976 14029296 24067536
23:05:51 4196 8192000000 10763289376 11151577088 1827462320 18.239 100 84 166 3 1864483568 14134416 22886832
23:06:02 1682 8192000000 10784726304 11169378304 1837708080 18.322 100 92 184 2 1877762400 14131696 25922624
23:06:09 1854 8192000000 10793134880 11175956480 1849140640 18.415 100 96 193 1 1890303088 14021840 27140608
23:06:18 1845 8192000000 10789309408 11185065984 1854148816 18.456 100 78 156 0 1887988336 11978208 21861312
23:06:26 1533 8192000000 10802185456 11192205312 1864132720 18.537 100 92 184 0 1903931440 14138992 25659728
23:06:34 1889 8192000000 10809507120 11198992384 1871626976 18.597 100 95 190 1 1913374320 14952080 26795264
23:06:42 1743 8192000000 10809281920 11198201856 1868817632 18.575 100 89 177 2 1908398256 14583216 24997408
23:06:50 1363 8192000000 10821722960 11212083200 1874198672 18.618 100 94 187 1 1914365488 13407696 26759120
23:06:58 1308 8192000000 10826037584 11216736256 1877154864 18.642 100 90 181 1 1915568928 12616272 25797792
23:07:05 1459 8192000000 10828067616 11218743296 1879297888 18.659 100 90 182 3 1918202336 12982144 25922304
23:07:13 25057 8192000000 10776608384 11204009984 1876753408 18.639 100 66 132 1 1907855216 12406112 18695696
23:07:45 8585 8192000000 10799082800 11215966208 1877758016 18.647 100 39 78 4 1896675392 7933456 10983920
23:08:00 2002 8192000000 10808742880 11218763776 1886086000 18.714 100 51 103 0 1907187568 6719760 14381808
23:08:10 4968 8192000000 10808108208 11224494080 1883446784 18.693 100 41 83 0 1908107472 12460400 12200288
23:08:32 8989 8192000000 10782318000 11214397440 1878099872 18.650 100 16 32 2 1889482512 6512832 4869808
23:08:47 11116 8192000000 10796148960 11226161152 1882229632 18.683 100 22 42 2 1895036656 6417072 6389952
23:09:04 10333 8192000000 10795649632 11225174016 1885198416 18.707 100 26 52 3 1899029968 6599568 7231984
23:09:23 10772 8192000000 10790069712 11226718208 1890964384 18.754 100 21 42 2 1904952800 7388736 6599680
23:09:42 16632 8192000000 10794109776 11234418688 1893270000 18.772 100 13 25 0 1901865952 5238304 3357648
23:10:06 9939 8192000000 10799341808 11235520512 1893611472 18.775 100 13 26 2 1903021664 6047120 3363072
23:10:22 8407 8192000000 10800256368 11238637568 1898479248 18.814 100 16 32 3 1908922944 6132784 4310912
23:10:41 24683 8192000000 10811457168 11251654656 1900221536 18.828 100 26 52 3 1913641632 5875840 7544256
23:11:48 19062 8192000000 10810553776 11253346304 1905425408 18.870 100 31 62 3 1921118976 7419808 8273760
23:12:16 8027 8192000000 10822280752 11257892864 1907330192 18.885 100 31 60 2 1922253360 5722000 9201168
23:12:31 5944 8192000000 10820414560 11258925056 1905938544 18.874 100 19 38 0 1917551952 6475440 5137968
23:12:43 4823 8192000000 10822777280 11260743680 1908926560 18.898 100 27 52 1 1923240720 7115184 7198976
23:12:54 4800 8192000000 10833436576 11265105920 1912149936 18.924 100 37 74 0 1929940592 7157712 10632944
23:13:07 6094 8192000000 10813767616 11255148544 1890844208 18.753 99 29 58 0 1905154832 5828640 8481984
23:13:20 6635 8192000000 10827771264 11263766528 1905605072 18.871 100 29 56 2 1924207232 10943120 7659040
23:13:33 8947 8192000000 10824602144 11266502656 1909231696 18.900 100 20 40 0 1920690112 5576080 5882336
23:13:50 7723 8192000000 10823697680 11267047424 1917871568 18.970 100 27 54 1 1931673024 6039408 7762048
23:14:04 9444 8192000000 10828402576 11274170368 1917381680 18.966 100 29 58 0 1931915248 6275552 8258016
23:14:19 11962 8192000000 10832688736 11267719168 1900425136 18.830 99 22 44 1 1913736240 6356224 6954880
23:14:38 5054 8192000000 10827754016 11271819264 1917547072 18.967 100 21 40 0 1929643968 6684064 5412832
23:14:50 10323 8192000000 10832244752 11264249856 1881130256 18.674 98 25 48 1 1893819152 5371008 7317888
23:15:08 8435 8192000000 10829558816 11258605568 1889392528 18.741 99 29 56 0 1904304320 7055120 7856672
23:15:26 19413 8192000000 10815400832 11245649920 1820320448 18.180 95 20 38 1 1830879216 5074400 5484368
23:15:52 61644 8192000000 10763332032 11190677504 1710118864 17.270 90 23 46 1 1721551184 4847024 6585296
23:17:01 11564 8192000000 10735319056 11155320832 1740205664 17.520 94 19 38 1 1750574384 5154256 5214464
23:17:20 6785 8192000000 10765249488 11183632384 1816925856 18.153 98 39 79 1 1835344816 7614368 10804592
23:17:33 7048 8192000000 10747205056 11175919616 1823636160 18.207 99 30 60 2 1839090912 6208048 9246704
23:17:46 8942 8192000000 10740046912 11166969856 1816785328 18.151 98 33 67 1 1833479568 7386752 9307488
23:18:01 4204 8192000000 10749867456 11174322176 1808727024 18.085 98 32 64 2 1824562016 6416128 9418864
23:18:15 5083 8192000000 10748684688 11161841664 1820980288 18.186 100 40 82 1 1838186560 5260336 11945936
23:18:31 5245 8192000000 10711702128 11128737792 1780206928 17.851 98 32 65 1 1795710640 6166592 9337120
23:18:47 10538 8192000000 10692190752 11114344448 1712847984 17.293 94 19 38 2 1723321248 5036960 5436304
23:19:04 11214 8192000000 10697807200 11113631744 1717760720 17.334 95 17 34 2 1727735568 5464672 4510176
23:19:24 7011 8192000000 10721106048 11137683456 1801242304 18.024 100 23 46 3 1814134096 6141072 6750720
23:19:41 6723 8192000000 10705558496 11126980608 1791613168 17.945 100 18 36 1 1802102864 5642832 4846864
23:19:56 5514 8192000000 10718188992 11131858944 1772535536 17.788 98 27 54 1 1790853424 9912032 8405856
23:20:12 10601 8192000000 10702801296 11119591424 1768775824 17.757 98 21 42 0 1780247296 5406880 6064592
23:20:29 7080 8192000000 10701162464 11122704384 1766995568 17.742 98 22 44 1 1779239920 5720768 6523584
23:20:44 67568 8192000000 10712530544 11140595712 1774992096 17.808 98 20 40 0 1785764880 5040592 5732192
23:21:58 10448 8192000000 10739170496 11157970944 1816740688 18.151 100 16 32 1 1826594896 5725968 4128240
23:22:16 10726 8192000000 10759233136 11168595968 1825144480 18.220 100 18 37 1 1835469200 5659728 4664992
23:22:33 8449 8192000000 10751253408 11173171200 1836375168 18.311 100 23 45 1 1848280352 5198096 6707088
23:22:48 4561 8192000000 10755478992 11176415232 1843890976 18.372 100 38 77 0 1861644048 7036160 10716912
23:22:59 10293 8192000000 10769148352 11190366208 1846121456 18.391 100 23 46 0 1858624896 6088512 6414928
23:23:17 6250 8192000000 10762078144 11192696832 1853613728 18.451 100 16 32 1 1863108416 5156432 4338256
23:23:30 11315 8192000000 10783995408 11200634880 1859527648 18.499 100 19 38 1 1869968192 5356864 5083680
23:23:50 8628 8192000000 10778929424 11209945088 1865207312 18.545 100 20 40 0 1876555936 5929424 5419200
23:24:05 8844 8192000000 10777547008 11212464128 1870613040 18.589 100 24 48 1 1884109760 6073136 7423584
23:24:24 8838 8192000000 10780431568 11213746176 1870830208 18.591 100 17 33 0 1880953600 5316016 4807376
23:24:39 9440 8192000000 10788985552 11215486976 1871994224 18.600 100 15 30 0 1881789760 5331792 4463744
23:24:54 9348 8192000000 10794247712 11221430272 1875510368 18.629 100 11 22 0 1884021728 4679696 3831664
23:25:10 6999 8192000000 10787291456 11222913024 1878724192 18.655 100 20 40 1 1890658224 6743744 5190288
23:25:23 17425 8192000000 10792458464 11221049344 1878464368 18.653 100 11 22 0 1886984256 5674128 2845760
23:25:47 54617 8192000000 10806915936 11230625792 1882817712 18.688 100 26 52 1 1895992928 5055344 8119872
23:26:48 27904 8192000000 10811015328 11242049536 1895802256 18.793 100 26 51 2 1908620704 5135264 7683184
23:27:44 55245 8192000000 10830865632 11252649984 1896398272 18.797 99 35 69 2 1913276864 7820304 9058288
23:28:46 2640 8192000000 10863729920 11283668992 1933001312 19.091 100 50 97 1 1957234192 9708720 14524160
23:28:56 9663 8192000000 10882767424 11304062976 1943603552 19.176 100 61 119 2 1971826016 11561056 16661408
23:29:17 4507 8192000000 10882761584 11309174784 1948544528 19.215 100 51 102 3 1975384976 12518848 14321600
23:29:30 17054 8192000000 10890287408 11321368576 1955398416 19.269 100 45 90 1 1980781392 12488320 12894656
23:29:55 22031 8192000000 10901879056 11333148672 1967393728 19.365 100 54 108 2 1996525536 13300032 15831776
23:30:25 33792 8192000000 10901627600 11335340032 1968648880 19.375 100 40 80 2 1995886384 15016944 12220560
23:31:08 24371 8192000000 10897986800 11330912256 1949014448 19.219 99 36 72 3 1973244128 13208080 11021600
23:31:48 11750 8192000000 10910730016 11343704064 1973646752 19.414 100 46 92 1 2002595264 14775264 14173248
23:32:08 11541 8192000000 10933931600 11357802496 1980440496 19.468 100 47 94 0 2010368832 16032480 13895856
23:32:30 8346 8192000000 10922578480 11350990848 1964679248 19.343 99 52 102 1 1995173888 15212496 15282144
23:32:49 5583 8192000000 10915794400 11340931072 1956020720 19.274 99 52 104 0 1989376544 18063856 15291968
23:33:10 14215 8192000000 10923866048 11348291584 1973406048 19.412 100 62 122 1 2012397136 20994848 17996240
23:33:32 5910 8192000000 10935802128 11365986304 1988752000 19.534 100 66 132 2 2028933232 21013024 19168208
23:33:55 11173 8192000000 10942117984 11377893376 2000824848 19.629 100 49 97 0 2037779104 22525584 14428672
23:34:15 4929 8192000000 10948334272 11382779904 2002838672 19.645 100 48 96 2 2039464112 21756624 14868816
23:34:28 11147 8192000000 10956926160 11390599168 2007636544 19.683 100 42 84 1 2044263392 23958624 12668224
23:34:46 3644 8192000000 10961404416 11379372032 1997407200 19.602 99 67 134 1 2042147072 24594048 20145824
23:34:57 3865 8192000000 10964700080 11389816832 2006747456 19.676 100 69 139 2 2051232192 24375056 20109680
23:35:09 7594 8192000000 10948693552 11381956608 1987391488 19.523 99 55 107 1 2027522368 23979584 16151296
23:35:27 10461 8192000000 10954446672 11391655936 2003521552 19.650 100 54 108 1 2046815184 26632752 16660880
23:35:47 5115 8192000000 10957214192 11387547648 1998082720 19.608 100 57 114 2 2044716768 28710048 17924000
23:36:01 7802 8192000000 10944956144 11373039616 1977731648 19.447 99 55 108 2 2025708688 30717424 17259616
23:36:19 3273 8192000000 10966063824 11391434752 2000086336 19.623 100 68 135 5 2054317696 33538528 20692832
23:36:29 3002 8192000000 10971708800 11401523200 2005323552 19.665 100 67 134 0 2061750288 35596384 20830352
23:36:42 2374 8192000000 10945018576 11371356160 1976739296 19.439 100 71 140 4 2034406352 35752128 21914928
23:36:53 2366 8192000000 10919856144 11340206080 1945520320 19.191 98 73 146 5 2001069296 32713264 22835712
23:37:03 2409 8192000000 10931148448 11361624064 1974246208 19.419 100 66 131 2 2023004768 28345536 20413024
23:37:12 2449 8192000000 10942445936 11350044672 1951473552 19.238 98 82 162 4 2004223280 27056832 25692896
23:37:21 3732 8192000000 10948727280 11365969920 1978329600 19.451 100 79 158 2 2030732560 28702928 23700032
23:37:33 2133 8192000000 10945104784 11356737536 1962454400 19.326 99 79 160 1 2015674768 29006336 24214032
23:37:44 6353 8192000000 10952921968 11371900928 1985003552 19.504 100 79 157 0 2038429008 29997728 23427728
23:37:57 3240 8192000000 10953606352 11371134976 1979589824 19.461 100 72 144 1 2036158128 33961712 22606592
23:38:07 7693 8192000000 10957491040 11381600256 1987913152 19.527 100 71 140 0 2045399840 36298192 21188496
23:38:21 2562 8192000000 10960023168 11388399616 1989613008 19.541 100 65 130 2 2044363872 34588288 20162576
23:38:32 2028 8192000000 10960929216 11373293568 1980328944 19.467 100 82 158 1 2039524240 34717920 24477376
23:38:43 13668 8192000000 10945316304 11377733632 1966143872 19.355 99 62 124 1 2018646512 33380016 19122624
23:39:07 4655 8192000000 10954706384 11377860608 1979965984 19.464 100 70 138 0 2041396512 39489824 21940704
23:39:18 922 8192000000 10952603568 11359002624 1964606400 19.343 99 85 170 0 2031196528 39975424 26614704
23:39:26 2507 8192000000 10944131328 11354759168 1959593408 19.303 99 83 165 1 2026663424 41345968 25724048
23:39:40 2544 8192000000 10942701008 11355058176 1959520016 19.302 99 83 166 2 2024981824 40110912 25350896
23:39:49 1720 8192000000 10945046848 11354705920 1956973616 19.282 99 80 160 4 2021118592 38551728 25593248
23:39:58 6515 8192000000 10938110736 11350622208 1956858752 19.281 99 71 141 0 2016781472 38233408 21689312
23:40:18 4721 8192000000 10963806464 11373244416 1962050448 19.322 99 64 128 1 2022691136 40066880 20573808
23:40:30 2809 8192000000 10946813648 11370799104 1972077424 19.402 100 72 144 0 2035273248 40384928 22810896
23:40:40 3337 8192000000 10950306592 11376418816 1975070400 19.426 100 65 130 4 2034959376 39262352 20626624
23:40:50 6860 8192000000 10935554912 11373936640 1974925120 19.424 100 47 94 1 2029440432 39422800 15092512
23:41:04 5749 8192000000 10929903888 11363524608 1949484464 19.222 99 44 88 0 2001857024 37368512 15004048
23:41:18 3696 8192000000 10948131936 11374989312 1974636560 19.422 100 54 106 1 2030382080 38093136 17652384
23:41:28 11167 8192000000 10927472944 11364618240 1942862624 19.170 98 43 83 3 1995505616 38848560 13794432
23:41:49 4963 8192000000 10959026384 11385888768 1977676048 19.446 100 57 113 1 2037420496 41465408 18279040
23:42:03 9203 8192000000 10955811568 11386081280 1972498400 19.405 100 52 102 0 2030707904 41151152 17058352
23:42:25 5018 8192000000 10976094240 11402100736 1983018400 19.489 100 63 126 1 2055881168 52353728 20509040
23:42:47 12527 8192000000 10946984416 11385831424 1968519872 19.374 99 38 76 1 2029456976 47641552 13295552
23:43:07 10500 8192000000 10960488464 11398479872 1971195440 19.395 99 43 86 2 2031955424 46598256 14161728
23:43:32 16595 8192000000 10970002528 11410886656 1985439216 19.508 100 34 68 2 2047801792 50376752 11985824
23:43:56 15816 8192000000 10958358496 11402579968 1965934448 19.353 99 37 75 2 2034654208 55113456 13606304
23:44:27 10450 8192000000 10934164160 11376148480 1928537392 19.055 98 34 68 0 1992592864 51978320 12077152
23:44:44 20910 8192000000 10945222832 11390029824 1959196656 19.300 100 38 76 4 2025469536 53649712 12623168
23:45:13 20767 8192000000 10944801152 11401052160 1957862976 19.289 100 29 58 0 2031898112 63112592 10922544
23:46:07 31455 8192000000 10898275152 11364593664 1915411248 18.950 98 22 44 1 1972355184 49444448 7499488
23:46:47 83410 8192000000 10833842704 11296620544 1755129456 17.644 91 11 22 0 1801129168 41949008 4050704
23:48:20 62238 8192000000 10829695760 11273945088 1816218608 18.147 95 9 18 1 1837881568 18432256 3230704
23:49:36 91576 8192000000 10859134096 11302785024 1914286096 18.941 100 20 40 0 1933756592 13744368 5726128
23:51:27 87304 8192000000 10854327408 11315937280 1887141728 18.723 98 19 36 2 1901465392 9657264 4666400
23:53:01 94007 8192000000 10866643520 11328409600 1915106736 18.948 99 14 28 1 1927908080 9678544 3122800
23:54:42 113559 8192000000 10892195024 11339034624 1913225248 18.933 98 30 60 0 1931622560 9965344 8431968
23:56:42 20885 8192000000 10857244416 11322413056 1905773744 18.873 98 10 20 0 1916539424 8216896 2548784
23:57:09 4061 8192000000 10875568064 11338174464 1948094640 19.211 100 13 25 1 1961401984 9897440 3409904
23:57:20 16182 8192000000 10885048768 11341881344 1952812432 19.249 100 16 32 0 1969015568 11441264 4761872
23:57:42 50772 8192000000 10921743344 11363479552 1968651568 19.375 100 37 74 3 1991696816 12641584 10403664
23:59:18 39571 8192000000 10899707456 11371945984 1974619664 19.422 100 11 22 1 1990109328 12833760 2655904
00:00:04 12451 8192000000 10894419088 11368923136 1975392416 19.428 100 6 12 0 1984420704 7674352 1353936
00:00:28 2042 8192000000 10893411632 11368792064 1975434848 19.429 100 4 8 0 1983960096 7777568 747680
00:00:36 2650 8192000000 10895766160 11369779200 1976106560 19.434 100 7 14 0 1985954000 8198640 1648800
00:00:45 209 8192000000 10893889072 11370500096 1975292000 19.427 100 3 6 1 1983833680 8064992 476688
00:00:51 3264 8192000000 10892315952 11365105664 1968959360 19.377 100 8 16 0 1983610368 12732608 1918400
00:01:03 6255 8192000000 10901157648 11376402432 1973921648 19.417 100 5 10 0 1988046592 13207712 917232
00:01:17 28732 8192000000 10917614416 11389939712 1985142864 19.505 100 15 30 0 2007074656 18089360 3842432
00:02:00 37735 8192000000 10916701456 11383070720 1967879040 19.369 99 13 26 0 1990577072 19176704 3521328
00:03:22 55125 8192000000 10911261104 11384848384 1957074624 19.283 99 19 38 0 1981264864 18656800 5533440
00:04:44 74267 8192000000 10900771504 11373584384 1960214304 19.308 99 14 28 0 1975273392 11437952 3621136
00:06:12 61134 8192000000 10919174064 11388977152 1971721152 19.399 99 9 18 1 1986222688 11965088 2536448
00:07:27 73947 8192000000 10940596416 11400282112 1976319264 19.436 99 22 45 1 1993060656 10916144 5825248
00:08:50 23425 8192000000 10940221632 11391492096 1968089616 19.370 98 63 126 2 1995637920 10276960 17271344
00:09:29 43895 8192000000 10912537536 11370930176 1943332576 19.173 98 18 36 0 1962568976 14182064 5054336
00:10:28 89731 8192000000 10927241056 11391897600 1947889152 19.210 98 22 44 0 1974750144 20035920 6825072
00:12:39 96239 8192000000 10926706704 11401011200 1948563024 19.215 98 19 38 1 1967728400 13725760 5439616
00:14:22 98823 8192000000 10907475136 11392315392 1909180624 18.900 96 9 17 2 1927840544 16367152 2292768
00:16:07 37003 8192000000 10934262144 11375714304 1959264032 19.300 99 15 29 0 1972434592 9513728 3656832
00:17:01 65083 8192000000 10917758272 11379920896 1944465312 19.182 98 24 48 2 1961009616 10541968 6002336
00:18:42 86520 8192000000 10927239248 11387498496 1986350640 19.515 100 42 83 0 2009816752 11386256 12079856
00:20:33 56017 8192000000 10903707072 11367309312 1889748416 18.744 95 30 60 2 1912700560 13924608 9027536
00:21:35 41894 8192000000 10919540528 11375493120 1976996288 19.441 100 52 106 1 2002937056 10792192 15148576
00:22:24 60301 8192000000 10883357680 11347943424 1941008000 19.155 98 33 66 1 1960682880 10712128 8962752
00:23:32 47116 8192000000 10873196880 11343998976 1888079984 18.730 96 9 18 0 1899925280 9718576 2126720
00:24:25 46882 8192000000 10886012624 11349889024 1923329536 19.014 98 13 25 1 1938165472 11041936 3794000
00:25:26 41779 8192000000 10870302240 11349315584 1919687568 18.984 98 9 18 0 1936775552 13891264 3196720
00:26:15 48514 8192000000 10874190512 11349221376 1932087792 19.084 99 8 16 0 1949767136 15021360 2657984
00:27:23 59974 8192000000 10869111824 11349377024 1916393056 18.958 98 10 20 1 1932472368 13260784 2818528
00:28:31 43179 8192000000 10843276320 11315437568 1852369424 18.441 95 6 12 0 1863233216 9814272 1049520
00:29:21 23049 8192000000 10865121024 11328593920 1919333712 18.982 99 19 36 1 1934849504 10265808 5249984
00:29:53 22835 8192000000 10861084688 11325497344 1918998256 18.979 99 33 66 1 1936854704 8326608 9529840
00:30:23 38565 8192000000 10875682368 11329925120 1932730784 19.089 100 21 42 0 1947668720 8822544 6115392
00:31:11 45774 8192000000 10863502784 11312513024 1860179952 18.505 96 35 70 0 1879571472 9763024 9628496
00:32:09 29862 8192000000 10857297680 11319570432 1900839824 18.833 98 39 78 0 1923159904 10426240 11893840
00:32:50 53456 8192000000 10840006496 11312652288 1864431680 18.539 97 16 32 0 1879155872 10298448 4425744
00:33:55 39869 8192000000 10858529600 11313942528 1887634560 18.727 98 13 26 0 1899339120 8241904 3462656
00:34:44 47165 8192000000 10870896064 11308281856 1867286656 18.562 96 28 56 1 1887177664 11674240 8216768
00:35:38 35260 8192000000 10855320304 11308986368 1868311248 18.571 97 40 80 3 1895360672 15715744 11333680
00:36:56 104130 8192000000 10870459744 11325857792 1855969712 18.471 96 17 35 0 1872705024 11923072 4812240
00:39:20 67016 8192000000 10879074448 11342606336 1902801024 18.849 98 7 14 2 1917242368 12471600 1969744
00:40:38 27710 8192000000 10891131808 11352961024 1948101824 19.211 100 30 60 0 1969222656 13081728 8039104
00:41:25 111480 8192000000 10882199856 11342045184 1918774400 18.977 98 18 36 3 1935014480 11387792 4852288
00:43:39 63214 8192000000 10891222720 11358269440 1941391264 19.158 99 29 57 1 1959055680 10103792 7560624
00:44:54 23180 8192000000 10878865136 11363745792 1958534480 19.294 100 9 18 0 1976012336 15690832 1787024
00:45:30 65070 8192000000 10882820688 11362021376 1946676016 19.200 99 19 38 0 1960393088 8055088 5661984
00:47:01 65874 8192000000 10869980064 11353833472 1924866352 19.026 98 7 14 1 1936469552 9355264 2247936
00:48:15 80348 8192000000 10872886688 11346337792 1902438192 18.846 97 17 34 1 1914762352 7554000 4770160
00:49:42 50869 8192000000 10863768016 11343282176 1934939440 19.106 99 11 22 0 1946949728 8677808 3332480
00:51:00 94892 8192000000 10884974464 11351293952 1920737440 18.993 98 14 28 1 1935540288 10715952 4086896
00:52:55 70472 8192000000 10883842976 11356884992 1934753952 19.105 99 11 21 0 1946946176 9360944 2831280
00:54:12 39544 8192000000 10888251632 11359272960 1960553088 19.310 100 23 46 0 1979619264 12142384 6923792
00:55:09 72697 8192000000 10886686768 11365830656 1923424768 19.014 98 8 16 2 1936571344 10589152 2557424
00:56:28 44235 8192000000 10889337136 11366072320 1943992096 19.179 99 33 66 0 1962978944 10407696 8579152
00:58:15 63981 8192000000 10926477712 11393191936 1980370784 19.468 100 27 54 2 2003088544 14986192 7731568
00:59:46 64159 8192000000 10910174016 11394097152 1954799456 19.265 99 7 13 0 1972981888 16436544 1745888
01:00:57 88336 8192000000 10916238896 11387478016 1924891392 19.026 97 15 30 1 1939620464 10692496 4036576
01:02:31 90107 8192000000 10899272960 11378331648 1888340576 18.732 95 14 28 0 1906543920 14359328 3844016
01:04:18 44180 8192000000 10934054112 11386916864 1977447840 19.444 100 43 84 4 2010429952 20283456 12698656
01:05:15 55881 8192000000 10923764640 11395330048 1982090784 19.481 100 32 64 1 2001816464 11078448 8647232
01:06:17 25592 8192000000 10920022992 11385163776 1969048272 19.378 99 22 44 0 1983947952 8609312 6290368
01:06:49 167709 8192000000 10912246336 11379728384 1911841296 18.921 96 24 48 1 1928785232 9382704 7561232
01:09:42 33257 8192000000 10907252336 11386892288 1978262576 19.451 100 18 36 0 1996193440 13038720 4892144
01:10:27 17451 8192000000 10913517856 11395026944 1986890128 19.519 100 19 38 2 2004663280 12173504 5599648
01:10:50 31690 8192000000 10895215328 11374399488 1967386832 19.365 99 7 14 1 1981591168 12233088 1971248
01:11:33 106862 8192000000 10897841280 11377557504 1891048464 18.754 95 11 22 0 1906633200 12637936 2946800
01:13:27 115550 8192000000 10856279344 11337306112 1823193824 18.204 92 15 30 1 1836697504 8751232 4752448
01:15:35 73941 8192000000 10885863184 11361517568 1956264432 19.276 100 11 22 0 1967310592 7810144 3236016
01:16:55 47778 8192000000 10862963760 11349524480 1899507712 18.822 97 10 20 0 1910476848 8083344 2885792
01:17:56 47968 8192000000 10856869712 11322978304 1841370448 18.352 94 8 16 0 1853511472 10223808 1917216
01:18:56 52702 8192000000 10834564752 11290554368 1806008272 18.063 94 8 16 1 1818283760 10133024 2142464
01:19:57 32438 8192000000 10852460544 11308380160 1888013296 18.730 98 17 34 0 1902056384 9696592 4346496
01:20:44 32854 8192000000 10837271760 11299880960 1875362928 18.628 97 36 72 0 1894716032 9750176 9602928
01:21:23 41121 8192000000 10834818048 11297497088 1841807872 18.356 96 17 34 0 1854420464 8260096 4352496
01:22:12 43546 8192000000 10812449888 11276251136 1833360448 18.287 96 17 34 0 1846029408 8008528 4660432
01:23:01 37973 8192000000 10861950928 11313451008 1879065568 18.658 98 14 28 2 1891188768 7842176 4281024
01:23:52 87253 8192000000 10834280368 11295993856 1823440864 18.206 95 12 24 0 1841186272 14173872 3571536
01:25:25 99523 8192000000 10862827248 11316133888 1855038432 18.463 97 22 44 0 1870360336 9567040 5754864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 23-12-2020 01:28:10 to 23-12-2020 01:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-12-2020 01:28:41 to 23-12-2020 01:28:43.

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          249979
MON$OLDEST_ACTIVE               250659
MON$OLDEST_SNAPSHOT             250659
MON$NEXT_TRANSACTION            250659
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                       2028192
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:245: 
:246: mscs-test-161.budzdorov.ru    Wed Dec 23 01:27:14 2020
:247:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:248: 
:249: 
:250: mscs-test-161.budzdorov.ru    Wed Dec 23 01:27:20 2020
:251:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:252: 
:253: 
:254: mscs-test-161.budzdorov.ru    Wed Dec 23 01:27:20 2020
:255:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:256: 
:257: 
:258: mscs-test-161.budzdorov.ru    Wed Dec 23 01:27:25 2020
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
:261: 
:262: mscs-test-161.budzdorov.ru    Wed Dec 23 01:27:26 2020
:263:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:264: 
--- end of diff output ---

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

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