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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17495032 kB
MemAvailable 31508332 kB
Buffers 0 kB
Cached 14231396 kB
SwapCached 3700 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-24 19:27:05
DTS_END                         2020-12-24 19:27:05.3440
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/38510
TRN_ID                          244067
ATT_ID                          669
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: 9623.63 17081 1154836
customer order: creation 174.93 357 20991
customer order: refuse 15.28 290 1833
order to supplier: creation 46.98 1130 5638
order to supplier: removal 3.62 81059 434
invoice (draft): creation 46.95 2803 5634
invoice (draft): removal 56.43 635 6772
invoice accept: apply 42.93 16853 5151
invoice accept: cancel 50.69 634 6083
customer reserve: creation 4007.23 165 480867
customer reserve: removal 4866.48 47 583977
realization accept: apply 85.01 160 10201
realization accept: cancel 95.47 100 11456
payment from customer: creation 60.56 119 7267
payment from customer: removal 5.65 70 678
payment to supplier: creation 50.71 136 6085
payment to supplier: removal 3.27 68 392
service: total inventory turnovers 4.50 977 540
service: total monetary turnovers 6.15 21 738
service: aggregate perf. data 0.79 21954 95
service: refresh index statistics 0.03 214032 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-12-2020 19:28:54 to 24-12-2020 19:28:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8377
TEST_TIME 2 7281
TEST_TIME 3 6984
TEST_TIME 4 6325
TEST_TIME 5 5527
TEST_TIME 6 5475
TEST_TIME 7 5689
TEST_TIME 8 6179
TEST_TIME 9 6282
TEST_TIME 10 6810
TEST_TIME 11 7048
TEST_TIME 12 7256
TEST_TIME 13 7717
TEST_TIME 14 8144
TEST_TIME 15 9108
TEST_TIME 16 9826
TEST_TIME 17 9796
TEST_TIME 18 9908
TEST_TIME 19 10987
TEST_TIME 20 10957
TEST_TIME 21 11790
TEST_TIME 22 12408
TEST_TIME 23 12239
TEST_TIME 24 11842
TEST_TIME 25 11654
TEST_TIME 26 11421
TEST_TIME 27 11414
TEST_TIME 28 11179
TEST_TIME 29 11085
TEST_TIME 30 11158
TEST_TIME 31 10986
TEST_TIME 32 10802
TEST_TIME 33 10706
TEST_TIME 34 10766
TEST_TIME 35 10676
TEST_TIME 36 10556
TEST_TIME 37 10571
TEST_TIME 38 10634
TEST_TIME 39 10641
TEST_TIME 40 10514
TEST_TIME 41 10667
TEST_TIME 42 10775
TEST_TIME 43 10717
TEST_TIME 44 10773
TEST_TIME 45 10812
TEST_TIME 46 10746
TEST_TIME 47 10850
TEST_TIME 48 10780
TEST_TIME 49 10604
TEST_TIME 50 10489
TEST_TIME 51 10507
TEST_TIME 52 10371
TEST_TIME 53 10360
TEST_TIME 54 10238
TEST_TIME 55 10344
TEST_TIME 56 10320
TEST_TIME 57 10258
TEST_TIME 58 10209
TEST_TIME 59 10262
TEST_TIME 60 10267
TEST_TIME 61 10206
TEST_TIME 62 10246
TEST_TIME 63 10352
TEST_TIME 64 10373
TEST_TIME 65 10311
TEST_TIME 66 10280
TEST_TIME 67 10390
TEST_TIME 68 10402
TEST_TIME 69 10409
TEST_TIME 70 10428
TEST_TIME 71 10317
TEST_TIME 72 10241
TEST_TIME 73 10233
TEST_TIME 74 10142
TEST_TIME 75 10139
TEST_TIME 76 10108
TEST_TIME 77 10082
TEST_TIME 78 10082
TEST_TIME 79 10029
TEST_TIME 80 9955
TEST_TIME 81 9975
TEST_TIME 82 10040
TEST_TIME 83 10052
TEST_TIME 84 10048
TEST_TIME 85 10107
TEST_TIME 86 10058
TEST_TIME 87 10058
TEST_TIME 88 10142
TEST_TIME 89 10117
TEST_TIME 90 10114
TEST_TIME 91 10127
TEST_TIME 92 10178
TEST_TIME 93 10155
TEST_TIME 94 10051
TEST_TIME 95 10048
TEST_TIME 96 10029
TEST_TIME 97 9993
TEST_TIME 98 9937
TEST_TIME 99 9918
TEST_TIME 100 9889
TEST_TIME 101 9873
TEST_TIME 102 9842
TEST_TIME 103 9840
TEST_TIME 104 9826
TEST_TIME 105 9800
TEST_TIME 106 9824
TEST_TIME 107 9845
TEST_TIME 108 9888
TEST_TIME 109 9851
TEST_TIME 110 9923
TEST_TIME 111 9904
TEST_TIME 112 9899
TEST_TIME 113 9919
TEST_TIME 114 9878
TEST_TIME 115 9813
TEST_TIME 116 9809
TEST_TIME 117 9766
TEST_TIME 118 9744
TEST_TIME 119 9699
TEST_TIME 120 9626

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-12-2020 19:28:57 to 24-12-2020 19:29:01.

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 1599037 1599037 0 0.00 0 20656 6 0 0
doc_list_biud 1599035 1599035 0 0.00 0 30554 22 0 0
sp_add_invoice_to_stock 5262 5151 111 2.10 33 172839 16853 0 111
sp_cancel_adding_invoice 6083 6083 0 0.00 5 80983 634 0 0
sp_cancel_client_order 1833 1833 0 0.00 4 11290 291 0 0
sp_cancel_customer_reserve 583977 583977 0 0.00 1 23642 47 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 2 4945 70 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 3894 68 0 0
sp_cancel_supplier_invoice 6788 6772 16 0.23 1 30587 636 0 16
sp_cancel_supplier_order 434 434 0 0.00 7 912625 81059 0 0
sp_cancel_write_off 11456 11456 0 0.00 1 23754 101 0 0
sp_client_order 20991 20991 0 0.00 3 26180 358 0 0
sp_customer_reserve 480867 480867 0 0.00 0 114161 166 0 0
sp_fill_shopping_cart 32254 32254 0 0.00 1 10670 35 0 0
sp_fill_shopping_cart_clo_res 480864 480864 0 0.00 0 14515 14 0 0
sp_get_clo_for_invoice 5148 5148 0 0.00 0 20635 284 0 0
sp_kill_cost_storno 18609 18609 0 0.00 0 9280 45 0 0
sp_kill_qstorno_ret_qs2qd 1186616 1186616 0 0.00 0 30536 26 0 0
sp_kill_qty_storno 625904 625904 0 0.00 0 30547 56 0 0
sp_lock_selected_doc 21337 21337 0 0.00 0 7732 6 0 0
sp_make_cost_storno 28701 28701 0 0.00 0 20654 51 0 0
sp_multiply_rows_for_pdistr 28701 28701 0 0.00 0 19277 26 0 0
sp_multiply_rows_for_qdistr 20991 20991 0 0.00 0 19608 164 0 0
sp_pay_from_customer 7267 7267 0 0.00 4 20296 119 0 0
sp_pay_to_supplier 6085 6085 0 0.00 4 18946 136 0 0
sp_payment_common 13351 13351 0 0.00 1 20261 45 0 0
sp_qd_handle_on_cancel_clo 1833 1833 0 0.00 0 11275 267 0 0
sp_qd_handle_on_invoice_upd_sts 11231 11231 0 0.00 0 23029 279 0 0
sp_qd_handle_on_reserve_upd_sts 10201 10201 0 0.00 0 21344 57 0 0
sp_reserve_write_off 10201 10201 0 0.00 6 21360 161 0 0
sp_supplier_invoice 5634 5634 0 0.00 6 90843 2804 0 0
sp_supplier_order 5638 5638 0 0.00 5 31127 1131 0 0
srv_aggregate_perf_data 95 95 0 0.00 2713 588706 21955 0 0
srv_fill_mon_cache_memory 142 142 0 0.00 1517 209819 39397 0 0
srv_find_qd_qs_mism 1105265 1105265 0 0.00 0 20237 5 0 0
srv_make_invnt_saldo 540 540 0 0.00 52 53289 978 0 0
srv_make_money_saldo 738 738 0 0.00 1 824 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 142220 344124 214033 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 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 5151 5151 0 0.00 0 41417 180 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 4919 82 0 0
t$perf-norm:sp_cancel_client_order 1833 1833 0 0.00 0 4360 11 0 0
t$perf-norm:sp_cancel_customer_reserve 709 709 0 0.00 0 5608 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 1605 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 3881 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 466 466 0 0.00 0 4414 23 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 19672 1326 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 1140 3 0 0
t$perf-norm:sp_client_order 20991 20991 0 0.00 0 16402 16 0 0
t$perf-norm:sp_customer_reserve 1018 1018 0 0.00 0 4990 10 0 0
t$perf-norm:sp_pay_from_customer 7267 7267 0 0.00 0 3852 7 0 0
t$perf-norm:sp_pay_to_supplier 6085 6085 0 0.00 0 5562 9 0 0
t$perf-norm:sp_reserve_write_off 10201 10201 0 0.00 0 19633 16 0 0
t$perf-norm:sp_supplier_invoice 5634 5634 0 0.00 0 9169 15 0 0
t$perf-norm:sp_supplier_order 5638 5638 0 0.00 0 6143 12 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 186 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 142 142 0 0.00 0 2670 31 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 781 15 0 0
t$perf-norm:srv_make_money_saldo 738 738 0 0.00 0 10570 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10518 10296 222 2.11 0 4784 16 0 222
v_all_customers 38478 38478 0 0.00 0 19 0 0 0
v_all_suppliers 31580 31580 0 0.00 0 17 1 0 0
v_all_wares 41980 41980 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 1402 7 0 0
v_cancel_client_order 3666 3666 0 0.00 0 2037 4 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 2622 4 0 0
v_cancel_customer_reserve 1418 1418 0 0.00 0 237 3 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 443 3 0 0
v_cancel_supplier_invoice 964 932 32 3.31 0 1077 16 0 32
v_cancel_supplier_order 868 868 0 0.00 0 1783 6 0 0
v_cancel_write_off 2076 2076 0 0.00 0 2907 15 0 0
v_max_id_clo_ord 5636 5636 0 0.00 0 1433 2 0 0
v_max_id_clo_res 1018 1018 0 0.00 0 1809 12 0 0
v_max_id_ord_sup 5628 5628 0 0.00 0 5964 5 0 0
v_max_non_paid_invoice 1557 1557 0 0.00 0 1593 3 0 0
v_max_non_paid_realizn 3823 3823 0 0.00 0 3462 4 0 0
v_min_id_clo_ord 5636 5636 0 0.00 0 5985 5 0 0
v_min_id_clo_res 1018 1018 0 0.00 0 4053 8 0 0
v_min_id_ord_sup 5628 5628 0 0.00 0 4539 5 0 0
v_min_non_paid_invoice 6083 6083 0 0.00 0 18917 34 0 0
v_min_non_paid_realizn 7267 7267 0 0.00 0 20254 32 0 0
v_our_firm 10390 10390 0 0.00 0 12 1 0 0
v_reserve_write_off 20400 20400 0 0.00 0 5698 5 0 0
x_lock_depdocs_on_canc_invoice 12389 12389 0 0.00 0 20955 103 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 10795 292 0 0
x_make_qstorno_1000_1200 5638 5638 0 0.00 2 31106 1063 0 0
x_make_qstorno_1200_2000 5634 5634 0 0.00 3 83998 2677 0 0
x_make_qstorno_2100_3300 480867 480867 0 0.00 0 114160 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-12-2020 19:29:02 to 24-12-2020 19:29:06.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:15 6401 8192000000 10151144560 10447015936 802978672 8.926 65 53 110 1 825289056 2385488 19924896
16:57:30 26122 8192000000 10300791040 10615328768 1341163904 14.068 100 76 152 1 1370631680 4149744 25318032
16:58:08 30289 8192000000 10367200960 10690617344 1410305648 14.687 100 88 176 0 1444350880 5256672 28788560
16:58:51 14599 8192000000 10399348720 10727768064 1454152656 15.074 100 85 170 0 1488861920 6357632 28351632
16:59:16 19861 8192000000 10425845136 10753667072 1473628352 15.246 100 88 176 0 1509174352 6911104 28634896
16:59:47 16304 8192000000 10442661664 10772865024 1495367744 15.436 100 92 184 1 1532647424 7553936 29725744
17:00:18 14517 8192000000 10458071584 10792824832 1512569008 15.586 100 91 182 0 1549643632 8160240 28914384
17:00:42 14185 8192000000 10465465536 10804633600 1519957968 15.650 100 82 164 0 1555317184 8986800 26372416
17:01:08 15785 8192000000 10486944736 10831384576 1541394608 15.836 100 84 168 1 1576703312 9380128 25928576
17:01:33 17041 8192000000 10505622256 10859814912 1568039344 16.065 100 77 154 0 1601561296 9605824 23916128
17:02:01 13404 8192000000 10536510560 10893561856 1594170800 16.290 100 73 146 1 1626172176 10055744 21945632
17:02:22 13395 8192000000 10551329856 10908151808 1610883552 16.432 100 78 156 0 1645038784 10962016 23193216
17:02:45 10992 8192000000 10574496576 10935595008 1631452064 16.607 100 75 150 0 1664445072 10917952 22075056
17:03:04 7518 8192000000 10596808720 10964516864 1660837632 16.856 100 74 148 4 1693649488 11208976 21602880
17:03:19 10258 8192000000 10626468336 10996789248 1681857040 17.033 100 78 156 1 1716150688 11557184 22736464
17:03:36 8886 8192000000 10647061456 11018489856 1701432336 17.197 100 78 155 0 1736062416 11883184 22746896
17:03:54 7752 8192000000 10657726944 11031240704 1719977488 17.352 100 74 148 0 1752983792 11520752 21485552
17:04:08 4798 8192000000 10661624128 11043045376 1729850272 17.434 100 73 146 2 1762332656 11342192 21140192
17:04:20 4606 8192000000 10682143760 11060137984 1750843200 17.609 100 84 167 0 1785998400 11464240 23690960
17:04:31 4710 8192000000 10695302464 11077554176 1757853584 17.667 100 79 154 1 1792358000 12582592 21921824
17:04:43 4154 8192000000 10705829232 11089055744 1769506384 17.763 100 83 164 1 1806415328 13140000 23768944
17:04:54 5679 8192000000 10716822352 11099770880 1775954256 17.816 100 73 146 2 1809088064 12949248 20184560
17:05:07 3965 8192000000 10728596880 11108691968 1789004000 17.924 100 83 166 1 1824717632 13316336 22397296
17:05:18 3728 8192000000 10725813392 11110850560 1794012592 17.965 100 88 176 0 1832740208 14297616 24430000
17:05:29 4134 8192000000 10742570592 11125645312 1800647424 18.019 100 84 168 0 1838604720 14213632 23743664
17:05:40 2852 8192000000 10749942592 11131006976 1809536608 18.092 100 90 180 1 1848179728 13812912 24830208
17:05:50 1735 8192000000 10755709280 11136311296 1812055504 18.113 100 87 175 3 1851200384 14380880 24764000
17:05:58 2672 8192000000 10756478144 11142176768 1817765808 18.159 100 89 176 0 1855860032 13628048 24466176
17:06:07 2638 8192000000 10752998976 11142701056 1816665392 18.150 100 68 134 0 1847441696 12435920 18340384
17:06:17 3313 8192000000 10771497264 11156389888 1822758544 18.200 100 77 153 0 1856975216 12904896 21311776
17:06:27 2093 8192000000 10779153840 11164860416 1837415264 18.320 100 87 173 1 1875265616 13321792 24528560
17:06:35 1851 8192000000 10785513120 11167596544 1840800400 18.347 100 97 195 0 1882279216 14483920 26994896
17:06:43 1275 8192000000 10788804432 11174834176 1843732768 18.371 100 92 182 0 1883409264 13360992 26315504
17:06:51 1568 8192000000 10799034240 11184455680 1856886416 18.478 100 90 180 2 1895002816 13527952 24588448
17:06:59 1968 8192000000 10799817296 11190386688 1858436992 18.491 100 93 184 1 1898812160 14743024 25632144
17:07:07 1243 8192000000 10800503056 11187146752 1859837456 18.502 100 91 185 1 1900265664 13713808 26714400
17:07:15 1847 8192000000 10804217456 11193991168 1860877120 18.510 100 93 185 0 1900790448 13290560 26622768
17:07:23 2232 8192000000 10796038848 11197706240 1866382784 18.555 100 86 170 1 1902807776 12783712 23641280
17:07:33 11010 8192000000 10802074288 11194298368 1863178560 18.529 100 64 128 1 1893379728 12211680 17989488
17:07:51 3644 8192000000 10803265456 11212963840 1872963536 18.608 100 62 124 0 1902763024 12491568 17307920
17:08:01 2803 8192000000 10801754624 11213791232 1877378224 18.644 100 59 116 1 1904205152 10716720 16110208
17:08:13 4614 8192000000 10794728960 11212455936 1882889776 18.688 100 48 96 0 1905167984 8755424 13522784
17:08:24 6750 8192000000 10786937024 11210686464 1878040464 18.649 100 34 67 1 1894790896 7296912 9453520
17:08:40 7946 8192000000 10778233504 11213770752 1877186304 18.642 100 24 47 3 1889966944 6635296 6145344
17:08:55 4647 8192000000 10804740656 11223347200 1889575424 18.742 100 51 104 1 1910026176 5930512 14520240
17:09:06 7329 8192000000 10798622992 11216728064 1881028208 18.673 100 21 40 1 1892587792 5644896 5914688
17:09:20 3999 8192000000 10789552608 11220877312 1884199552 18.699 100 24 48 3 1897077360 6310816 6566992
17:09:35 15155 8192000000 10788409536 11225006080 1883441360 18.693 100 19 38 2 1895484448 6800576 5242512
17:10:01 65063 8192000000 10823851872 11245576192 1890387184 18.749 100 41 84 2 1909167488 5477344 13302960
17:11:22 5855 8192000000 10806067088 11246333952 1892544640 18.766 100 23 46 2 1909482704 10500416 6437648
17:11:34 7591 8192000000 10817409936 11248603136 1896345520 18.797 100 27 54 0 1910290048 6491408 7453120
17:11:49 6234 8192000000 10808478640 11243667456 1896518960 18.798 100 28 56 0 1911111072 6878320 7713792
17:12:02 5474 8192000000 10822752016 11252678656 1898011408 18.810 100 23 46 3 1910623264 6046736 6565120
17:12:14 9178 8192000000 10810085840 11250094080 1899323456 18.821 100 21 42 1 1911730256 6455984 5950816
17:12:30 6378 8192000000 10819408640 11252994048 1901070016 18.835 100 23 45 2 1914018080 6443024 6505040
17:12:45 3702 8192000000 10822283296 11252940800 1903297552 18.853 100 32 64 1 1924330736 12209536 8823648
17:12:55 10111 8192000000 10811524304 11250163712 1900867840 18.833 100 14 28 0 1910017616 5008080 4141696
17:13:11 7474 8192000000 10817107584 11254489088 1903308656 18.853 100 26 52 1 1916444320 6163440 6972224
17:13:28 7287 8192000000 10828511408 11260981248 1905742352 18.872 100 25 50 3 1919151392 6187232 7221808
17:13:41 13624 8192000000 10817836832 11258060800 1888392160 18.733 99 9 17 2 1895777424 4973888 2411376
17:14:01 8664 8192000000 10817981024 11254865920 1890802768 18.752 99 22 43 4 1902958064 6100960 6054336
17:14:19 14248 8192000000 10819696944 11260522496 1912402928 18.926 100 24 47 3 1925316064 6434448 6478688
17:14:44 20050 8192000000 10823182208 11246505984 1873877904 18.616 98 27 54 1 1886918560 5365696 7674960
17:15:12 67975 8192000000 10812382272 11255668736 1891067152 18.754 99 21 42 2 1902299584 4635296 6597136
17:16:31 7329 8192000000 10817960848 11240488960 1839251408 18.335 96 34 67 2 1855409472 6783744 9374320
17:16:45 5669 8192000000 10815038400 11235102720 1853906816 18.454 98 34 68 0 1870332512 7164624 9261072
17:16:57 3360 8192000000 10802774304 11225235456 1836328208 18.311 97 43 87 0 1860360448 11830960 12201280
17:17:08 8695 8192000000 10779594208 11207069696 1824954608 18.218 97 31 62 1 1840548624 6372384 9221632
17:17:23 7868 8192000000 10771510880 11204153344 1844197744 18.375 99 31 62 1 1860200912 7374896 8628272
17:17:39 4518 8192000000 10755722656 11182632960 1828658592 18.248 99 20 40 2 1840416880 6093296 5664992
17:17:50 6007 8192000000 10743859824 11161100288 1807413856 18.075 98 27 54 1 1820822496 5746016 7662624
17:18:05 11291 8192000000 10764352240 11195027456 1838623440 18.330 99 25 48 5 1851923072 5663888 7635744
17:18:22 7431 8192000000 10739622960 11165978624 1773558704 17.796 96 27 53 1 1787724832 5991040 8175088
17:18:38 5655 8192000000 10672580912 11084640256 1729502512 17.431 96 17 32 2 1740239600 5617632 5119456
17:18:49 8983 8192000000 10698709024 11116982272 1715286144 17.313 95 14 28 1 1724336928 5133328 3917456
17:19:05 10470 8192000000 10664406352 11071811584 1673269264 16.961 94 23 46 0 1685060976 4809920 6981792
17:19:22 11534 8192000000 10700962160 11107180544 1711408944 17.281 96 13 26 0 1720278624 5034672 3835008
17:19:40 17698 8192000000 10708414384 11116445696 1694929536 17.143 94 21 42 0 1706863264 5177136 6756592
17:20:16 51190 8192000000 10659332352 11070812160 1648628272 16.753 92 16 32 1 1657516960 4403360 4485328
17:21:16 11133 8192000000 10682806560 11099398144 1746011936 17.569 98 27 52 0 1759275856 6072560 7191360
17:21:36 8554 8192000000 10717470208 11130146816 1794355744 17.968 100 36 72 4 1810527456 5763504 10408208
17:21:51 5719 8192000000 10728170928 11147595776 1810149280 18.097 100 37 74 1 1829361616 8517072 10695264
17:22:03 10593 8192000000 10718227120 11139149824 1805829520 18.062 100 26 51 5 1819047552 5432928 7785104
17:22:20 6519 8192000000 10739527072 11156946944 1821603696 18.191 100 40 77 3 1839245872 5616848 12025328
17:22:32 6179 8192000000 10743220512 11167727616 1831693008 18.273 100 25 50 1 1845149264 6133184 7323072
17:22:47 15599 8192000000 10745012896 11171385344 1832622896 18.281 100 21 42 2 1849391456 10018928 6749632
17:23:11 14414 8192000000 10774879760 11189563392 1841701232 18.355 100 27 54 1 1854996480 4816496 8478752
17:23:35 14388 8192000000 10757495648 11183230976 1844851984 18.380 100 20 40 0 1856730272 6069760 5808528
17:23:55 15328 8192000000 10767697120 11194970112 1849098288 18.415 100 13 26 0 1858085760 5449648 3537824
17:24:18 13587 8192000000 10770692112 11202428928 1860236192 18.505 100 16 32 2 1870952224 5482256 5233776
17:24:40 14894 8192000000 10771345456 11203219456 1860992208 18.511 100 18 34 1 1871662880 5896832 4773840
17:25:01 66725 8192000000 10771150048 11213115392 1870368560 18.587 100 25 51 1 1883485280 5548656 7568064
17:26:17 13264 8192000000 10779165120 11214348288 1872507824 18.605 100 20 39 1 1883266656 5655616 5103216
17:26:37 9303 8192000000 10787299488 11218522112 1876627424 18.638 100 19 38 3 1887206688 5427360 5151904
17:26:53 9038 8192000000 10793393984 11223699456 1879489856 18.661 100 22 44 1 1891797824 6087712 6220256
17:27:08 4791 8192000000 10845652272 11258228736 1908407616 18.894 100 61 120 2 1935172944 9376080 17389248
17:27:24 29969 8192000000 10831447312 11254841344 1909594720 18.903 100 33 65 3 1924476464 5304208 9577536
17:28:06 2430 8192000000 10861396016 11272413184 1920908896 18.994 100 62 125 1 1948189264 10191328 17089040
17:28:16 20466 8192000000 10863214496 11281559552 1926834368 19.042 100 58 115 0 1954774608 12459552 15480688
17:28:52 7755 8192000000 10873152656 11290996736 1933050912 19.091 100 55 110 0 1961971328 14325312 14595104
17:29:09 21085 8192000000 10889804112 11313332224 1941566368 19.159 100 57 114 1 1972830656 15436448 15827840
17:29:38 21551 8192000000 10882214912 11316924416 1951063168 19.235 100 53 106 3 1985740864 19293600 15384096
17:30:08 11546 8192000000 10913207024 11334057984 1959546832 19.302 100 60 118 2 1999561552 22290928 17723792
17:30:35 21725 8192000000 10907072400 11334455296 1961108704 19.315 100 38 73 1 1993584832 21545472 10930656
17:31:15 57608 8192000000 10912278672 11348680704 1951551296 19.239 99 30 60 2 1986752096 25709216 9491584
17:32:20 28486 8192000000 10924021664 11356205056 1972386448 19.404 100 37 74 0 2012306896 28517408 11403040
17:32:57 14928 8192000000 10910128064 11350155264 1954376416 19.261 99 39 77 1 1995173568 29825360 10971792
17:33:20 11909 8192000000 10920576448 11354984448 1972971520 19.409 100 42 81 4 2014430864 29060688 12398656
17:33:45 8863 8192000000 10944143536 11374878720 1984088832 19.497 100 54 108 3 2037207248 37160976 15957440
17:34:01 12868 8192000000 10937311792 11372388352 1982489568 19.484 100 44 88 3 2029415200 33773696 13151936
17:34:21 10995 8192000000 10944467776 11372417024 1967661904 19.367 99 51 102 3 2018835056 35872400 15300752
17:34:40 8324 8192000000 10935363760 11367628800 1962278192 19.324 99 50 100 2 2013034784 35764144 14992448
17:35:02 8151 8192000000 10946133840 11374141440 1977701360 19.446 100 53 102 2 2029912000 36461264 15749376
17:35:17 3994 8192000000 10939296272 11368169472 1975470352 19.429 100 61 122 0 2030828176 37099216 18258608
17:35:32 7863 8192000000 10938165168 11369967616 1975898928 19.432 100 56 112 0 2031295728 38667936 16728864
17:35:47 3170 8192000000 10957749280 11382087680 1983584816 19.493 100 58 116 3 2039687440 39245328 16857296
17:35:59 3326 8192000000 10962346880 11391651840 1994059152 19.576 100 64 128 1 2053933568 40266960 19607456
17:36:10 2378 8192000000 10974158224 11393970176 1999532544 19.619 100 71 142 0 2062149072 41567488 21049040
17:36:21 2234 8192000000 10981936464 11402801152 2003872464 19.653 100 73 146 3 2072025696 46493056 21660176
17:36:30 1913 8192000000 10985514672 11401035776 2000267184 19.625 100 82 161 0 2067707680 44003520 23436976
17:36:40 3972 8192000000 10983754752 11403739136 1998410480 19.610 100 78 156 1 2069158512 47381312 23366720
17:36:51 4342 8192000000 10990103920 11408576512 2002649360 19.644 100 77 155 1 2072548752 47458896 22440496
17:37:02 4028 8192000000 10988035024 11404214272 2005996064 19.670 100 73 146 0 2070722864 43683488 21043312
17:37:12 2131 8192000000 10986750160 11409223680 2008313712 19.688 100 76 152 0 2073956000 43478144 22164144
17:37:21 5308 8192000000 10980839904 11410198528 2009813152 19.700 100 67 133 1 2072196496 42865424 19517920
17:37:34 5279 8192000000 10977032816 11403100160 2003264848 19.648 100 61 121 1 2064794496 43209216 18320432
17:37:48 2207 8192000000 10990530816 11412725760 2011084480 19.710 100 65 125 2 2073432288 43253216 19094592
17:37:57 2807 8192000000 10978288880 11397275648 1974385744 19.420 98 70 139 1 2038976320 43726112 20864464
17:38:07 2690 8192000000 10976893024 11398516736 1985673712 19.510 99 71 142 2 2050077936 42116416 22287808
17:38:20 2863 8192000000 10974977248 11401678848 1997270656 19.601 100 71 141 1 2062900528 43055600 22574272
17:38:34 5781 8192000000 10981419888 11409952768 2003166944 19.648 100 66 132 2 2070841152 46659472 21014736
17:38:51 2046 8192000000 10993406816 11412086784 2002894992 19.646 100 78 156 1 2076494176 49313248 24285936
17:39:00 7677 8192000000 10990470176 11411230720 1999511280 19.619 100 84 166 1 2076896864 52075424 25310160
17:39:18 5856 8192000000 11000242048 11413487616 2000707536 19.628 100 73 147 2 2076358160 52537696 23112928
17:39:31 3433 8192000000 10995960416 11407081472 1994110384 19.576 100 84 167 1 2073919792 54048448 25760960
17:39:41 2115 8192000000 10995431968 11408769024 1995682336 19.589 100 88 177 1 2077112032 54435968 26993728
17:39:50 5589 8192000000 10993897920 11406450688 1980287888 19.467 99 80 160 2 2059366272 54730400 24347984
17:40:03 5897 8192000000 10979018560 11399311360 1981602048 19.477 100 73 146 1 2060809664 56433392 22774224
17:40:16 1779 8192000000 10984928960 11406028800 1988042160 19.528 100 83 165 1 2071728928 57544432 26142336
17:40:25 2744 8192000000 10955575808 11370180608 1950692400 19.232 99 88 176 0 2036506816 57780640 28033776
17:40:35 2609 8192000000 10922530560 11333664768 1915796160 18.953 98 83 162 1 1999464928 57541680 26127088
17:40:44 2598 8192000000 10958059152 11371245568 1958009024 19.290 100 90 179 1 2044282432 58820544 27452864
17:40:53 1514 8192000000 10968249216 11378192384 1961163856 19.315 100 94 189 0 2050775856 59794464 29817536
17:41:01 6738 8192000000 10940859616 11362856960 1955902112 19.273 100 68 136 1 2029437872 52503296 21032464
17:41:18 4411 8192000000 10931338960 11355029504 1933408816 19.094 99 66 133 1 2005140656 51013184 20718656
17:41:33 2159 8192000000 10955315616 11364749312 1957539584 19.286 100 72 137 1 2028140304 48141392 22459328
17:41:44 2431 8192000000 10950563680 11364716544 1956772032 19.280 100 83 164 1 2033572224 50859536 25940656
17:41:59 2948 8192000000 10960179760 11375648768 1958783664 19.296 100 76 149 0 2039177120 56842640 23550816
17:42:10 11939 8192000000 10920162336 11360485376 1938021792 19.131 99 40 80 1 2011658656 59412160 14224704
17:42:40 8669 8192000000 10932533504 11371520000 1952805744 19.249 100 43 86 4 2027193744 59061344 15326656
17:43:01 16493 8192000000 10925605760 11373318144 1951289840 19.237 100 35 70 1 2017626736 54637920 11698976
17:43:24 11573 8192000000 10918600544 11353346048 1928727664 19.057 99 38 76 1 1991546976 49261344 13557968
17:43:53 10080 8192000000 10911368848 11348164608 1933556064 19.095 99 37 73 1 1988146176 42225984 12364128
17:44:09 11707 8192000000 10944371344 11376984064 1961317120 19.317 100 46 91 2 2024514864 49117520 14080224
17:44:28 15323 8192000000 10931364496 11373723648 1958016112 19.290 100 36 72 1 2020548944 50623408 11909424
17:44:50 23347 8192000000 10924056672 11366813696 1911840944 18.921 98 29 58 0 1978057472 55909120 10307408
17:45:19 22261 8192000000 10913750512 11360202752 1932348592 19.086 99 35 70 0 2009696144 64535456 12812096
17:45:49 22185 8192000000 10909676464 11349041152 1886798784 18.720 97 33 66 2 1955407376 57311376 11297216
17:46:22 32657 8192000000 10895923664 11346788352 1929115440 19.060 100 19 38 0 1972090416 36474944 6500032
17:47:01 23965 8192000000 10852920224 11297992704 1822637664 18.199 94 19 38 2 1863726272 34690784 6397824
17:47:31 52009 8192000000 10870826240 11315757056 1890229584 18.748 99 18 36 0 1934956304 38639728 6086992
17:48:31 66929 8192000000 10839193408 11308646400 1849956560 18.422 97 20 41 1 1901577344 45107536 6513248
17:49:48 28239 8192000000 10829697344 11282141184 1854991888 18.463 97 10 20 0 1874395376 16923232 2480256
17:50:22 87042 8192000000 10852196544 11296686080 1899011344 18.818 99 28 56 1 1916731520 8961776 8758400
17:51:59 153107 8192000000 10854885456 11302199296 1828737536 18.249 95 17 34 0 1841182736 8056944 4388256
17:54:40 85991 8192000000 10849988272 11310194688 1881651904 18.678 98 12 24 1 1898038336 13069968 3316464
17:56:12 209819 8192000000 10857701312 11311230976 1824405856 18.214 94 12 24 0 1838838912 11054448 3378608
18:01:02 72226 8192000000 10845511728 11304574976 1905630320 18.872 98 20 40 3 1920909184 8529328 6749536
18:02:28 84401 8192000000 10888735200 11349012480 1951171888 19.236 100 8 16 0 1964808000 10981824 2654288
18:04:11 17450 8192000000 10896351584 11361263616 1972848752 19.408 100 36 71 3 1999683344 15594784 11239808
18:04:42 55445 8192000000 10883897248 11341725696 1928425280 19.054 98 28 56 1 1944122048 7420464 8276304
18:05:55 82828 8192000000 10905806656 11363217408 1949895872 19.226 99 18 36 0 1966125424 11360208 4869344
18:07:32 55833 8192000000 10923056288 11379904512 1974038528 19.417 99 40 76 1 2002139392 16360080 11740784
18:08:34 99872 8192000000 10902513008 11378061312 1962030992 19.322 99 11 22 1 1983123232 17910720 3181520
18:10:20 30534 8192000000 10923997696 11386687488 1992076800 19.560 100 23 46 0 2013562304 15176720 6308784
18:10:56 42746 8192000000 10931217280 11387629568 1996512352 19.595 100 25 49 0 2014543248 10995120 7035776
18:11:49 37966 8192000000 10932528128 11399114752 2000098784 19.624 100 20 40 0 2019117136 13549328 5469024
18:12:35 59764 8192000000 10932643584 11401105408 1998178912 19.608 100 11 22 0 2010980144 10177120 2624112
18:13:41 114385 8192000000 10924179024 11402481664 1967112080 19.363 98 10 20 1 1980701856 10983072 2606704
18:15:42 43732 8192000000 10937370480 11382534144 1955500096 19.270 97 45 90 3 1979163280 10309984 13353200
18:16:53 121023 8192000000 10928067104 11403522048 1959676256 19.303 98 34 68 2 1983894432 14358864 9859312
18:19:02 50598 8192000000 10908961024 11391299584 1972693168 19.407 99 14 28 1 1995044992 18383008 3968816
18:19:59 25319 8192000000 10910000656 11395936256 1984963664 19.504 100 10 20 1 2005697696 17594720 3139312
18:20:30 75439 8192000000 10901574272 11389128704 1955183056 19.268 98 12 24 0 1972571264 13640528 3747680
18:21:52 42568 8192000000 10909055120 11378839552 1965101104 19.347 99 18 37 1 1984016704 13445824 5469776
18:22:41 40265 8192000000 10886917216 11373789184 1958205888 19.292 99 13 26 0 1975056464 13390976 3459600
18:23:28 50741 8192000000 10908428960 11384983552 1964317760 19.340 99 12 23 2 1974944944 7059280 3567904
18:24:26 66294 8192000000 10918839152 11385122816 1954738832 19.264 98 10 20 0 1967496832 10029056 2728944
18:25:41 103646 8192000000 10888777456 11361271808 1900016400 18.826 96 16 31 1 1917024960 12824848 4183712
18:27:43 30149 8192000000 10870266000 11322171392 1832991088 18.284 93 29 58 1 1846978832 6013648 7974096
18:28:33 74663 8192000000 10898211584 11372924928 1944851104 19.185 99 18 36 1 1962252160 12227568 5173488
18:29:58 100862 8192000000 10869497952 11337670656 1847788896 18.404 94 16 32 0 1867704304 15155856 4759552
18:33:00 36256 8192000000 10882233760 11320500224 1901811888 18.841 98 38 76 0 1927043488 14059200 11172400
18:33:46 73745 8192000000 10847073328 11320885248 1886451584 18.717 98 22 44 0 1911908816 19311152 6146080
18:35:06 24921 8192000000 10824254304 11267694592 1824932896 18.218 94 24 48 2 1839482432 8262304 6287232
18:35:38 33016 8192000000 10833831984 11290894336 1882890784 18.688 99 18 36 1 1898767056 11003504 4872768
18:36:17 69112 8192000000 10844669584 11309776896 1857148560 18.480 97 13 26 0 1870901792 10487424 3265808
18:37:34 75502 8192000000 10844464720 11300691968 1882540416 18.686 98 16 32 2 1900522624 13382208 4600000
18:39:24 117654 8192000000 10818746752 11282288640 1794720608 17.971 93 18 36 0 1808836960 9342784 4773568
18:41:31 39775 8192000000 10831282160 11286630400 1876030080 18.633 98 39 78 0 1897776400 9816400 11929920
18:42:27 33173 8192000000 10829992496 11296141312 1896041680 18.794 99 20 40 0 1912257664 10502064 5713920
18:43:06 67175 8192000000 10835454336 11294986240 1882592272 18.686 98 12 24 0 1894429856 8689104 3148480
18:44:45 52229 8192000000 10833202144 11301826560 1900501392 18.830 99 18 37 0 1915334608 9046304 5786912
18:45:44 50213 8192000000 10822996160 11283890176 1861981312 18.519 97 23 46 1 1876402928 7291088 7130528
18:46:44 70795 8192000000 10847477264 11307315200 1882345744 18.684 98 14 28 1 1899374704 13026896 4002064
18:48:13 54750 8192000000 10830319408 11292430336 1854713200 18.460 97 7 14 2 1871130944 14406224 2011520
18:49:30 52338 8192000000 10841209888 11312398336 1905930416 18.874 100 10 20 0 1929465728 20855296 2680016
18:50:31 88468 8192000000 10840584304 11320508416 1857095696 18.480 97 9 18 0 1876444160 16850112 2498352
18:52:11 63458 8192000000 10833753344 11293614080 1861657568 18.517 97 12 24 3 1873026608 8357888 3011152
18:53:22 28902 8192000000 10863851280 11320913920 1928758608 19.057 100 36 72 0 1948824704 9896128 10169968
18:54:02 24962 8192000000 10885563440 11331887104 1937187392 19.124 100 49 99 2 1962233632 11009408 14036832
18:54:35 27857 8192000000 10885361504 11335651328 1944291296 19.181 100 49 98 2 1973152000 15112880 13747824
18:55:09 30397 8192000000 10881609888 11338268672 1941777504 19.161 100 29 58 1 1963981168 14023904 8179760
18:55:49 82912 8192000000 10892355200 11352944640 1952239984 19.244 100 28 56 0 1976384240 16758112 7386144
18:57:18 48149 8192000000 10913913088 11357798400 1927763584 19.049 98 40 79 2 1948081040 9417328 10900128
18:58:15 65778 8192000000 10899162640 11362000896 1925753264 19.033 98 31 60 1 1944200816 10258464 8189088
18:59:28 96817 8192000000 10852049136 11317805056 1858172448 18.488 95 9 18 0 1874805024 14325856 2306720
19:01:11 106766 8192000000 10876555536 11344486400 1951669408 19.240 100 25 49 1 1969859376 11195712 6994256
19:03:40 67032 8192000000 10889172112 11374911488 1970420704 19.389 100 11 22 0 1987512528 14071968 3019856
19:04:54 47804 8192000000 10887386944 11372625920 1973620608 19.414 100 7 14 1 1989403152 13705472 2077072
19:05:53 33524 8192000000 10900818432 11369996288 1953448016 19.254 99 8 16 1 1967109632 11026112 2635504
19:06:38 72197 8192000000 10888480416 11373498368 1957734096 19.288 99 11 22 2 1973461344 11965376 3761872
19:08:16 85645 8192000000 10884463856 11355000832 1918254144 18.973 97 9 18 0 1928973744 8286112 2433488
19:09:49 64296 8192000000 10885755952 11365007360 1934812656 19.105 98 22 44 1 1952960528 12163536 5984336
19:11:00 72257 8192000000 10889942000 11360632832 1916166672 18.956 97 11 22 0 1935942368 15825584 3950112
19:12:28 60198 8192000000 10892719920 11360616448 1897890032 18.809 96 21 42 1 1924044384 19925872 6228480
19:13:45 56357 8192000000 10893538912 11369062400 1922727744 19.009 98 13 25 1 1944243056 17553056 3962256
19:15:08 29871 8192000000 10877660944 11355131904 1921874160 19.002 98 15 30 0 1936808560 10776304 4158096
19:15:44 71730 8192000000 10882239024 11335430144 1881647424 18.678 96 25 50 0 1904002272 14653696 7701152
19:17:02 95189 8192000000 10885032704 11349762048 1874441712 18.620 96 21 42 0 1892333376 12066000 5825664
19:18:51 69510 8192000000 10874178128 11324805120 1860461552 18.507 95 28 56 0 1879893504 11555312 7876640
19:20:09 19718 8192000000 10878682416 11334356992 1926667808 19.040 99 37 74 0 1947804320 10654128 10482384
19:20:40 71102 8192000000 10886110592 11329052672 1892694064 18.767 97 24 48 1 1909146224 10051744 6400416
19:21:59 118241 8192000000 10860651952 11330375680 1919464496 18.983 98 26 52 1 1937435920 10834336 7137088
19:24:05 60687 8192000000 10850265904 11330179072 1897818288 18.809 97 26 52 0 1914407728 9190096 7399344
19:25:17 46119 8192000000 10863350880 11342913536 1925383328 19.030 99 11 22 1 1935909152 7462560 3063264
19:26:42 33217 8192000000 9775699808 10128027648 915582688 10.052 47 4 8 0 923210320 6506352 1121280

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 24-12-2020 19:29:08 to 24-12-2020 19:29:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 111 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 24-12-2020 19:29:38 to 24-12-2020 19:29:40.

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          242875
MON$OLDEST_ACTIVE               244401
MON$OLDEST_SNAPSHOT             244401
MON$NEXT_TRANSACTION            244401
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                       2013376
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 ---
:315: 
:316: mscs-test-161.budzdorov.ru    Thu Dec 24 19:27:23 2020
:317:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:318: 
:319: 
:320: mscs-test-161.budzdorov.ru    Thu Dec 24 19:27:23 2020
:321:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:322: 
:323: 
:324: mscs-test-161.budzdorov.ru    Thu Dec 24 19:27:23 2020
:325:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:326: 
:327: 
:328: mscs-test-161.budzdorov.ru    Thu Dec 24 19:27:23 2020
:329:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:330: 
--- end of diff output ---

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

24.12.20 19:29:41. 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-24 19:29:43 No severe PSQL-related problems occured
24.12.20 19:29:44. End of report.