Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.12.2020 16: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 17308252 kB
MemAvailable 31496980 kB
Buffers 0 kB
Cached 14353532 kB
SwapCached 3712 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-15 16:27:07
DTS_END                         2020-12-15 16:27:07.5790
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/33116
TRN_ID                          260479
ATT_ID                          690
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: 9658.18 19176 1158982
customer order: creation 192.30 308 23076
customer order: refuse 16.48 250 1978
order to supplier: creation 50.14 1104 6017
order to supplier: removal 3.63 79325 435
invoice (draft): creation 49.91 2989 5989
invoice (draft): removal 53.67 650 6440
invoice accept: apply 45.74 16558 5489
invoice accept: cancel 48.20 670 5784
customer reserve: creation 4204.17 167 504500
customer reserve: removal 4677.88 49 561345
realization accept: apply 91.80 133 11016
realization accept: cancel 82.08 90 9850
payment from customer: creation 65.23 84 7828
payment from customer: removal 5.92 51 710
payment to supplier: creation 53.58 97 6430
payment to supplier: removal 3.73 44 447
service: total inventory turnovers 5.45 927 654
service: total monetary turnovers 7.42 21 890
service: aggregate perf. data 0.83 21297 100
service: refresh index statistics 0.03 258698 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-12-2020 16:27:51 to 15-12-2020 16:27:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5299
TEST_TIME 2 5021
TEST_TIME 3 4857
TEST_TIME 4 4968
TEST_TIME 5 5240
TEST_TIME 6 5260
TEST_TIME 7 5828
TEST_TIME 8 5983
TEST_TIME 9 6286
TEST_TIME 10 7379
TEST_TIME 11 7513
TEST_TIME 12 7852
TEST_TIME 13 8229
TEST_TIME 14 8522
TEST_TIME 15 8868
TEST_TIME 16 9029
TEST_TIME 17 9286
TEST_TIME 18 9826
TEST_TIME 19 9997
TEST_TIME 20 10411
TEST_TIME 21 10895
TEST_TIME 22 11873
TEST_TIME 23 11754
TEST_TIME 24 12152
TEST_TIME 25 11876
TEST_TIME 26 12026
TEST_TIME 27 11795
TEST_TIME 28 11665
TEST_TIME 29 11279
TEST_TIME 30 11341
TEST_TIME 31 11478
TEST_TIME 32 11441
TEST_TIME 33 11156
TEST_TIME 34 11129
TEST_TIME 35 11038
TEST_TIME 36 10985
TEST_TIME 37 10965
TEST_TIME 38 10744
TEST_TIME 39 10712
TEST_TIME 40 10854
TEST_TIME 41 10697
TEST_TIME 42 10604
TEST_TIME 43 10491
TEST_TIME 44 10478
TEST_TIME 45 10314
TEST_TIME 46 10181
TEST_TIME 47 10159
TEST_TIME 48 10127
TEST_TIME 49 10130
TEST_TIME 50 10277
TEST_TIME 51 10272
TEST_TIME 52 10328
TEST_TIME 53 10331
TEST_TIME 54 10371
TEST_TIME 55 10378
TEST_TIME 56 10342
TEST_TIME 57 10412
TEST_TIME 58 10388
TEST_TIME 59 10307
TEST_TIME 60 10224
TEST_TIME 61 10201
TEST_TIME 62 10171
TEST_TIME 63 10105
TEST_TIME 64 10009
TEST_TIME 65 9985
TEST_TIME 66 9928
TEST_TIME 67 10009
TEST_TIME 68 10092
TEST_TIME 69 10053
TEST_TIME 70 9995
TEST_TIME 71 9993
TEST_TIME 72 10073
TEST_TIME 73 10108
TEST_TIME 74 10096
TEST_TIME 75 10105
TEST_TIME 76 10178
TEST_TIME 77 10210
TEST_TIME 78 10111
TEST_TIME 79 10014
TEST_TIME 80 9957
TEST_TIME 81 9875
TEST_TIME 82 9871
TEST_TIME 83 9821
TEST_TIME 84 9788
TEST_TIME 85 9774
TEST_TIME 86 9798
TEST_TIME 87 9806
TEST_TIME 88 9766
TEST_TIME 89 9764
TEST_TIME 90 9765
TEST_TIME 91 9797
TEST_TIME 92 9889
TEST_TIME 93 9847
TEST_TIME 94 9865
TEST_TIME 95 9895
TEST_TIME 96 9896
TEST_TIME 97 10004
TEST_TIME 98 9989
TEST_TIME 99 9990
TEST_TIME 100 9898
TEST_TIME 101 9827
TEST_TIME 102 9843
TEST_TIME 103 9794
TEST_TIME 104 9742
TEST_TIME 105 9711
TEST_TIME 106 9747
TEST_TIME 107 9714
TEST_TIME 108 9716
TEST_TIME 109 9687
TEST_TIME 110 9679
TEST_TIME 111 9658
TEST_TIME 112 9653
TEST_TIME 113 9685
TEST_TIME 114 9660
TEST_TIME 115 9702
TEST_TIME 116 9725
TEST_TIME 117 9710
TEST_TIME 118 9732
TEST_TIME 119 9735
TEST_TIME 120 9659

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-12-2020 16:27:55 to 15-12-2020 16:27:58.

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 1626153 1626153 0 0.00 0 21550 6 0 0
doc_list_biud 1626151 1626151 0 0.00 0 47891 21 0 0
sp_add_invoice_to_stock 5679 5489 190 3.34 34 173891 16559 0 190
sp_cancel_adding_invoice 5784 5784 0 0.00 5 77806 671 0 0
sp_cancel_client_order 1978 1978 0 0.00 3 9374 251 0 0
sp_cancel_customer_reserve 561345 561345 0 0.00 1 29436 49 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 3 3034 51 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 3 1956 45 0 0
sp_cancel_supplier_invoice 6454 6440 14 0.21 2 25962 650 0 14
sp_cancel_supplier_order 435 435 0 0.00 6 908236 79326 0 0
sp_cancel_write_off 9850 9850 0 0.00 1 5460 91 0 0
sp_client_order 23076 23076 0 0.00 3 19221 308 0 0
sp_customer_reserve 504500 504500 0 0.00 0 105270 167 0 0
sp_fill_shopping_cart 35066 35066 0 0.00 1 12065 34 0 0
sp_fill_shopping_cart_clo_res 504493 504493 0 0.00 0 13357 11 0 0
sp_get_clo_for_invoice 5482 5482 0 0.00 0 30426 297 0 0
sp_kill_cost_storno 16791 16791 0 0.00 0 16479 41 0 0
sp_kill_qstorno_ret_qs2qd 1139415 1139415 0 0.00 0 29428 27 0 0
sp_kill_qty_storno 602327 602327 0 0.00 0 47888 57 0 0
sp_lock_selected_doc 22845 22845 0 0.00 0 5270 3 0 0
sp_make_cost_storno 30753 30753 0 0.00 0 19609 38 0 0
sp_multiply_rows_for_pdistr 30753 30753 0 0.00 0 6184 21 0 0
sp_multiply_rows_for_qdistr 23076 23076 0 0.00 0 10664 149 0 0
sp_pay_from_customer 7828 7828 0 0.00 4 16955 84 0 0
sp_pay_to_supplier 6430 6430 0 0.00 5 19780 97 0 0
sp_payment_common 14258 14258 0 0.00 1 17493 22 0 0
sp_qd_handle_on_cancel_clo 1978 1978 0 0.00 0 9367 232 0 0
sp_qd_handle_on_invoice_upd_sts 11263 11263 0 0.00 0 47881 255 0 0
sp_qd_handle_on_reserve_upd_sts 11016 11016 0 0.00 0 19550 43 0 0
sp_reserve_write_off 11016 11016 0 0.00 6 19582 134 0 0
sp_supplier_invoice 5989 5989 0 0.00 6 86361 2989 0 0
sp_supplier_order 6017 6017 0 0.00 5 43114 1104 0 0
srv_aggregate_perf_data 100 100 0 0.00 2438 174985 21298 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1310 205040 36745 0 0
srv_find_qd_qs_mism 1106542 1106542 0 0.00 0 21549 6 0 0
srv_make_invnt_saldo 654 654 0 0.00 31 40001 927 0 0
srv_make_money_saldo 890 890 0 0.00 0 1368 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 132559 387227 258699 0 0
t$perf-abend:sp_add_invoice_to_stock 190 190 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5489 5489 0 0.00 0 16161 181 0 0
t$perf-norm:sp_cancel_adding_invoice 454 454 0 0.00 1 4068 70 0 0
t$perf-norm:sp_cancel_client_order 1978 1978 0 0.00 0 18250 20 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 806 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 517 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 447 447 0 0.00 0 5643 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 475 475 0 0.00 0 2383 16 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 25191 1278 0 0
t$perf-norm:sp_cancel_write_off 1112 1112 0 0.00 0 5568 9 0 0
t$perf-norm:sp_client_order 23076 23076 0 0.00 0 12586 17 0 0
t$perf-norm:sp_customer_reserve 1100 1100 0 0.00 0 1697 6 0 0
t$perf-norm:sp_pay_from_customer 7828 7828 0 0.00 0 4803 11 0 0
t$perf-norm:sp_pay_to_supplier 6430 6430 0 0.00 0 6616 11 0 0
t$perf-norm:sp_reserve_write_off 11016 11016 0 0.00 0 5538 13 0 0
t$perf-norm:sp_supplier_invoice 5989 5989 0 0.00 0 6433 14 0 0
t$perf-norm:sp_supplier_order 6017 6017 0 0.00 0 8333 16 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 2765 52 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 413 6 0 0
t$perf-norm:srv_make_invnt_saldo 654 654 0 0.00 0 3972 18 0 0
t$perf-norm:srv_make_money_saldo 890 890 0 0.00 0 7031 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 107 28 0 0
v_add_invoice_to_stock 11338 10958 380 3.35 0 6895 20 0 380
v_all_customers 42258 42258 0 0.00 0 23 0 0 0
v_all_suppliers 33184 33184 0 0.00 0 20 1 0 0
v_all_wares 46152 46152 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 908 908 0 0.00 0 1604 7 0 0
v_cancel_client_order 3956 3956 0 0.00 0 2099 4 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 3023 6 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 0 1608 8 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 278 2 0 0
v_cancel_supplier_invoice 978 950 28 2.86 0 2306 18 0 28
v_cancel_supplier_order 870 870 0 0.00 0 1549 4 0 0
v_cancel_write_off 2224 2224 0 0.00 0 2283 12 0 0
v_max_id_clo_ord 6017 6017 0 0.00 0 464 1 0 0
v_max_id_clo_res 1100 1100 0 0.00 0 6686 23 0 0
v_max_id_ord_sup 5973 5973 0 0.00 0 7164 6 0 0
v_max_non_paid_invoice 1828 1828 0 0.00 0 195 2 0 0
v_max_non_paid_realizn 4064 4064 0 0.00 0 2372 3 0 0
v_min_id_clo_ord 6017 6017 0 0.00 0 2803 4 0 0
v_min_id_clo_res 1100 1100 0 0.00 0 5675 16 0 0
v_min_id_ord_sup 5973 5973 0 0.00 0 4220 7 0 0
v_min_non_paid_invoice 6430 6430 0 0.00 0 17489 17 0 0
v_min_non_paid_realizn 7828 7828 0 0.00 0 4786 10 0 0
v_our_firm 11422 11422 0 0.00 0 13 1 0 0
v_reserve_write_off 22032 22032 0 0.00 0 4878 6 0 0
x_lock_depdocs_on_canc_invoice 11749 11749 0 0.00 0 18060 104 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 8219 285 0 0
x_make_qstorno_1000_1200 6017 6017 0 0.00 1 43103 1043 0 0
x_make_qstorno_1200_2000 5989 5989 0 0.00 3 85574 2856 0 0
x_make_qstorno_2100_3300 504500 504500 0 0.00 0 105254 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-12-2020 16:27:59 to 15-12-2020 16:28:03.

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
13:57:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:17 10899 8192000000 10198037696 10499059712 815809824 9.056 65 56 110 1 837331120 2376976 19144320
13:57:35 23222 8192000000 10316906800 10630602752 1348285600 14.132 100 83 167 0 1379802832 4215696 27301536
13:58:09 25713 8192000000 10358898352 10679074816 1406636688 14.654 100 85 170 0 1441242624 6023280 28582656
13:58:51 12006 8192000000 10382123136 10707861504 1444602656 14.990 100 87 174 0 1481465872 7496736 29366480
13:59:18 15514 8192000000 10408900992 10736467968 1467823808 15.195 100 92 184 0 1505611968 8170256 29617904
13:59:44 23133 8192000000 10430346336 10761670656 1478019984 15.284 100 85 170 2 1514477584 8946928 27510672
14:00:16 14871 8192000000 10446573392 10780028928 1500044384 15.477 100 90 180 1 1538439088 9645264 28749440
14:00:43 20276 8192000000 10474575680 10814795776 1527621696 15.716 100 87 174 0 1565254672 10472784 27160192
14:01:15 15962 8192000000 10501750144 10848301056 1557557120 15.975 100 91 182 0 1596812096 10865728 28389248
14:01:40 16215 8192000000 10534815568 10887921664 1589437008 16.249 100 76 152 2 1623661344 11161296 23063040
14:02:06 13008 8192000000 10567509488 10927267840 1622385744 16.530 100 75 150 1 1655476592 10877808 22213040
14:02:26 9076 8192000000 10584719600 10945335296 1639850896 16.678 100 83 164 2 1676307568 11287888 25168784
14:02:44 11170 8192000000 10607603440 10971443200 1659260000 16.843 100 75 150 1 1693980576 11929392 22791184
14:03:03 7334 8192000000 10612344144 10981376000 1678893760 17.008 100 83 166 1 1716252704 12724320 24634624
14:03:19 8819 8192000000 10631852224 11002687488 1691586176 17.115 100 84 168 0 1729458032 12843808 25028048
14:03:35 6523 8192000000 10640578576 11009179648 1699127264 17.178 100 82 162 1 1735982064 13407376 23447424
14:03:48 8359 8192000000 10657829712 11033419776 1715734848 17.317 100 81 159 2 1752814304 13459008 23620448
14:04:03 4711 8192000000 10672142416 11046076416 1734340624 17.472 100 77 152 1 1769469424 13639792 21489008
14:04:18 7072 8192000000 10693921200 11069251584 1753392080 17.630 100 86 172 3 1791421664 13850768 24178816
14:04:31 6158 8192000000 10695546368 11072823296 1758058288 17.668 100 82 162 1 1793972848 13013792 22900768
14:04:45 3386 8192000000 10702613520 11082887168 1764769904 17.724 100 78 155 0 1799651824 13735104 21146816
14:04:55 3377 8192000000 10709993184 11088601088 1770395552 17.770 100 83 163 0 1806783312 13347792 23039968
14:05:05 2572 8192000000 10722723344 11104571392 1784068736 17.883 100 78 158 2 1818801952 12637936 22095280
14:05:14 3446 8192000000 10737202912 11119374336 1794145472 17.966 100 81 162 2 1829934544 13189168 22599904
14:05:25 3190 8192000000 10737668176 11119116288 1803135536 18.040 100 87 175 0 1840685136 12678192 24871408
14:05:35 2786 8192000000 10753285664 11134210048 1807128960 18.072 100 78 156 0 1841916656 12819696 21968000
14:05:44 4201 8192000000 10745293680 11133624320 1814764608 18.135 100 83 166 2 1851193168 13276112 23152448
14:05:55 4347 8192000000 10770643120 11154595840 1822765312 18.200 100 84 169 2 1859795824 13894480 23136032
14:06:06 1816 8192000000 10778190976 11164663808 1834248816 18.294 100 87 174 0 1873054704 14913472 23892416
14:06:14 2151 8192000000 10788367792 11174518784 1845077744 18.382 100 90 181 2 1883480352 13884032 24518576
14:06:22 1040 8192000000 10796823440 11180552192 1847746752 18.404 100 92 184 0 1887500256 14158368 25595136
14:06:29 2045 8192000000 10790773344 11174760448 1849286160 18.416 100 89 179 1 1888457648 13371744 25799744
14:06:38 1477 8192000000 10800652448 11187601408 1857454480 18.483 100 91 182 0 1896829696 13044560 26330656
14:06:45 1947 8192000000 10803066032 11191627776 1861607776 18.516 100 96 190 2 1901849440 12930272 27311392
14:06:54 1450 8192000000 10809362208 11196731392 1867088240 18.561 100 93 187 0 1904629936 11266784 26274912
14:07:01 1979 8192000000 10808751296 11198337024 1867149328 18.561 100 92 183 0 1906059600 12346416 26563856
14:07:09 1771 8192000000 10813648336 11203190784 1871006912 18.592 100 94 189 1 1910730464 13779360 25944192
14:07:18 2049 8192000000 10804633552 11203645440 1868418352 18.571 100 68 136 1 1900233216 12937296 18877568
14:07:26 6084 8192000000 10785091904 11198820352 1867146720 18.561 100 55 108 0 1892786240 9875328 15764192
14:07:39 23789 8192000000 10813268288 11211649024 1871556272 18.597 100 50 100 0 1894146752 7856784 14733696
14:08:14 9848 8192000000 10812849408 11213242368 1876824592 18.639 100 76 155 2 1906485744 7007200 22653952
14:08:30 27971 8192000000 10785905600 11207917568 1873792208 18.615 100 47 91 4 1894325728 7103984 13429536
14:09:06 5101 8192000000 10782566064 11210530816 1871803712 18.599 100 25 50 1 1885604576 6827232 6973632
14:09:17 6644 8192000000 10791875360 11216769024 1874975216 18.625 100 25 50 1 1887852864 6024384 6853264
14:09:30 5969 8192000000 10800192512 11220529152 1881926496 18.681 100 26 51 0 1895439200 5660576 7852128
14:09:42 9050 8192000000 10793235872 11224649728 1885400912 18.709 100 22 44 2 1898071088 6766432 5903744
14:09:59 6804 8192000000 10792401392 11229966336 1891353152 18.757 100 27 54 1 1906342080 7026048 7962880
14:10:13 4473 8192000000 10798111184 11229761536 1889712448 18.743 100 21 42 2 1901987984 6235104 6040432
14:10:23 13489 8192000000 10794116096 11232878592 1891187712 18.755 100 13 26 1 1900937728 5986192 3763824
14:10:45 9205 8192000000 10806179984 11238580224 1894893120 18.785 100 24 48 0 1907737712 6495200 6349392
14:11:06 11452 8192000000 10801479248 11234791424 1893968032 18.778 100 17 34 0 1904634928 5576048 5090848
14:11:26 11361 8192000000 10807220384 11243474944 1896232368 18.796 100 14 28 1 1906366576 6030144 4104064
14:11:43 12674 8192000000 10812183392 11241582592 1896328240 18.797 100 15 30 1 1906285440 6073360 3883840
14:12:02 6879 8192000000 10808786816 11243405312 1900730480 18.832 100 30 59 3 1916337360 7173264 8433616
14:12:17 16343 8192000000 10816748048 11238694912 1896656144 18.799 100 10 20 0 1905478416 5786256 3036016
14:12:39 52730 8192000000 10839521888 11256078336 1901531104 18.839 100 28 54 0 1915847792 5304928 9011760
14:13:53 5232 8192000000 10819883328 11257012224 1906030864 18.875 100 34 68 0 1924433056 8964304 9437888
14:14:05 8384 8192000000 10818626400 11253817344 1904111456 18.859 100 18 35 2 1915281392 6064032 5105904
14:14:19 6144 8192000000 10828610464 11259957248 1908153888 18.892 100 33 66 1 1923821792 6419120 9248784
14:14:35 7274 8192000000 10825770416 11258888192 1906398528 18.878 100 24 48 1 1919621664 5986416 7236720
14:14:50 7956 8192000000 10812690032 11251257344 1889368896 18.741 99 23 46 1 1901852704 6270960 6212848
14:15:05 6480 8192000000 10811222528 11252580352 1904649904 18.864 100 23 45 3 1917173328 6149184 6374240
14:15:18 5859 8192000000 10823497856 11246489600 1896822304 18.801 100 21 40 1 1908096752 5521920 5752528
14:15:30 5693 8192000000 10808326128 11248451584 1900412064 18.830 100 25 50 1 1914019616 6070224 7537328
14:15:43 11112 8192000000 10785342880 11222609920 1804202592 18.048 95 9 18 1 1811730624 5186352 2341680
14:16:01 8187 8192000000 10733925856 11155390464 1781176544 17.859 95 22 44 1 1797085824 9772032 6137248
14:16:16 9125 8192000000 10761809632 11193098240 1769703376 17.765 95 12 24 1 1779373552 5423008 4247168
14:16:33 11729 8192000000 10735073648 11165065216 1799313312 18.008 98 9 18 0 1807312112 5393328 2605472
14:16:52 7964 8192000000 10715882400 11137515520 1763467920 17.713 96 21 42 0 1774885760 5315616 6102224
14:17:08 41919 8192000000 10741275248 11164151808 1783985808 17.882 97 24 46 0 1795452944 4658704 6808432
14:18:29 12708 8192000000 10713606144 11123986432 1743754576 17.550 97 25 48 0 1756461072 5810992 6895504
14:18:49 5444 8192000000 10710008784 11122511872 1780503456 17.854 99 34 67 1 1796939408 6861872 9574080
14:19:00 6709 8192000000 10716974368 11126931456 1764893408 17.725 98 25 50 1 1778187584 5833152 7461024
14:19:14 8287 8192000000 10705195424 11128082432 1788359824 17.918 99 32 64 0 1803812560 6614336 8838400
14:19:30 6797 8192000000 10736112432 11156758528 1808039728 18.080 99 21 42 0 1819282160 5466496 5775936
14:19:45 7300 8192000000 10707519568 11126681600 1793499008 17.961 100 22 44 2 1805631248 5953312 6178928
14:20:01 6788 8192000000 10705143264 11118477312 1762937520 17.709 98 30 58 1 1777262768 5774208 8551040
14:20:14 8334 8192000000 10702562480 11117916160 1789587248 17.928 100 25 50 0 1802863104 6040336 7235520
14:20:29 9027 8192000000 10711248912 11126050816 1769742720 17.765 98 12 24 0 1778819408 5146048 3930640
14:20:46 12667 8192000000 10732910800 11142369280 1778365584 17.836 98 24 48 0 1790375984 4804032 7206368
14:21:05 8696 8192000000 10750434832 11158536192 1824544448 18.215 100 21 41 0 1834863632 4530240 5788944
14:21:21 13894 8192000000 10756907312 11179704320 1837112784 18.317 100 20 40 1 1853659424 10293536 6253104
14:21:41 12448 8192000000 10759006384 11181531136 1842382400 18.360 100 19 36 3 1853527680 6411920 4733360
14:22:02 63219 8192000000 10749734016 11183325184 1830674096 18.265 99 28 56 1 1844722160 5645120 8402944
14:23:13 8026 8192000000 10777469344 11193171968 1853622304 18.452 100 31 63 4 1868662912 5784800 9255808
14:23:30 8762 8192000000 10782226464 11199725568 1856054992 18.471 100 26 52 2 1869281856 5845488 7381376
14:23:45 6349 8192000000 10775261536 11197313024 1860587536 18.508 100 36 71 0 1876624512 6316512 9720464
14:23:57 7231 8192000000 10771773136 11196993536 1863005744 18.528 100 30 58 4 1876858368 5552576 8300048
14:24:14 6998 8192000000 10773907056 11204096000 1866828592 18.559 100 25 50 0 1879817696 5630160 7358944
14:24:29 10760 8192000000 10767753840 11204685824 1865453952 18.547 100 17 34 2 1875907312 5438704 5014656
14:24:47 8267 8192000000 10773568368 11205746688 1867842976 18.567 100 21 42 1 1879997376 5586096 6568304
14:25:03 12952 8192000000 10784469776 11207258112 1869813568 18.583 100 24 49 1 1882390336 6095824 6480944
14:25:25 7630 8192000000 10783746832 11210100736 1869030240 18.576 100 16 32 3 1879021408 4847872 5143296
14:25:39 7442 8192000000 10780836128 11209719808 1869580176 18.581 100 18 36 3 1880452592 5716816 5155600
14:25:55 8355 8192000000 10784805744 11216728064 1874776528 18.623 100 28 56 1 1888933728 6228816 7928384
14:26:12 15630 8192000000 10782188064 11216314368 1874550240 18.621 100 21 40 4 1885848368 5918160 5379968
14:26:37 60164 8192000000 10789906144 11223064576 1877481232 18.645 100 16 32 1 1887574368 5555200 4537936
14:27:51 28742 8192000000 10836204000 11252133888 1901617872 18.839 100 34 66 0 1916963232 6246448 9098912
14:28:27 7014 8192000000 10854874848 11272327168 1922535296 19.007 100 66 128 1 1949327200 9516304 17275600
14:28:43 27189 8192000000 10853542144 11268190208 1912978592 18.931 99 63 124 2 1940367216 10230912 17157712
14:29:18 23550 8192000000 10858328480 11283554304 1930413104 19.070 100 44 88 0 1953804496 11167280 12224112
14:29:56 15103 8192000000 10875377312 11299209216 1945476784 19.190 100 51 102 1 1972616448 12796768 14342896
14:30:18 20960 8192000000 10886226368 11306299392 1948229440 19.212 100 47 94 0 1974396272 13060256 13106576
14:30:47 13333 8192000000 10892066880 11316686848 1955157808 19.268 100 47 94 1 1984024288 15143088 13723392
14:31:26 7903 8192000000 10895273216 11323633664 1963512304 19.334 100 55 110 2 1995997776 15775456 16710016
14:31:54 14444 8192000000 10903080544 11327746048 1948830592 19.217 99 49 96 1 1981573344 18897600 13845152
14:32:17 8188 8192000000 10898512672 11326328832 1957686992 19.288 100 42 84 2 1988916496 18840800 12388704
14:32:35 21496 8192000000 10886054016 11325042688 1944711296 19.184 99 37 74 2 1976091968 19680624 11700048
14:33:05 10607 8192000000 10907592496 11336155136 1969015568 19.378 100 50 98 3 2004075472 19327152 15732752
14:33:24 13657 8192000000 10913367344 11341443072 1974328976 19.420 100 55 109 0 2011838448 21208752 16300720
14:33:44 8601 8192000000 10916851904 11344846848 1961233024 19.316 99 54 108 2 2000862944 22347664 17282256
14:34:00 14119 8192000000 10924843936 11355164672 1976511920 19.437 100 48 96 1 2019045824 27524816 15009088
14:34:22 22637 8192000000 10929281264 11362439168 1976310192 19.435 100 42 80 2 2017049904 28479472 12260240
14:34:52 8212 8192000000 10932931024 11360829440 1981981312 19.480 100 54 104 4 2024153488 26713584 15458592
14:35:10 10855 8192000000 10908209456 11333722112 1950991600 19.234 99 49 98 2 1993426064 26815696 15618768
14:35:29 19580 8192000000 10917058640 11352891392 1949751072 19.224 99 46 92 1 1998105616 34094144 14260400
14:36:02 11608 8192000000 10885756720 11312037888 1922092736 19.004 98 39 74 3 1959369328 25542272 11734320
14:36:21 7638 8192000000 10906609472 11337789440 1956881248 19.281 100 55 110 0 2000433488 25830960 17721280
14:36:38 6537 8192000000 10917652640 11341664256 1943072368 19.171 99 51 102 1 1989299904 30169424 16058112
14:37:04 5236 8192000000 10887776432 11316711424 1921004432 18.995 99 60 121 1 1971134384 31088624 19041328
14:37:16 5798 8192000000 10909674608 11322675200 1928970560 19.059 99 60 117 1 1976294432 30104912 17218960
14:37:30 6737 8192000000 10921016320 11336564736 1952902480 19.250 100 75 150 0 2009761952 34329536 22529936
14:37:45 4004 8192000000 10900258672 11315097600 1929437472 19.062 99 64 125 1 1981448384 33000288 19010624
14:37:57 1824 8192000000 10935115696 11348045824 1967270720 19.364 100 87 170 0 2021706080 28839088 25596272
14:38:05 2318 8192000000 10941311200 11350245376 1966333936 19.356 100 83 162 1 2024151280 33978784 23838560
14:38:15 2871 8192000000 10930154416 11355750400 1967278944 19.364 100 73 144 0 2023338144 34721616 21337584
14:38:25 2189 8192000000 10916634464 11337498624 1937074160 19.123 99 72 139 2 1992791248 34195136 21521952
14:38:35 2010 8192000000 10913374720 11321905152 1938144928 19.132 100 86 172 3 1994844128 30930976 25768224
14:38:44 1914 8192000000 10928890976 11338670080 1951892656 19.242 100 86 170 3 2011547760 33561920 26093184
14:38:55 6770 8192000000 10906512576 11325612032 1913918656 18.938 98 70 140 0 1968243408 33193408 21131344
14:39:12 2904 8192000000 10921220528 11331657728 1951489392 19.238 100 83 166 0 2014698608 38010800 25198416
14:39:23 7149 8192000000 10918266784 11335155712 1949297728 19.221 100 60 119 1 2001254400 33903984 18052688
14:39:37 4907 8192000000 10911886624 11325001728 1916066272 18.955 98 72 142 0 1973573232 34501584 23005376
14:39:49 1790 8192000000 10914415888 11325296640 1928072272 19.051 99 84 170 0 1989436240 35394288 25969680
14:39:57 6101 8192000000 10911850128 11324157952 1930522640 19.071 99 73 146 1 1990794320 37222480 23049200
14:40:14 6278 8192000000 10910426864 11336626176 1941881920 19.162 100 53 106 0 1994533136 36078320 16572896
14:40:28 4330 8192000000 10940183632 11358498816 1965422112 19.349 100 67 132 0 2024124880 38406912 20295856
14:40:39 2768 8192000000 10934854512 11343343616 1953521232 19.255 99 83 164 0 2017806992 39143504 25142256
14:40:49 3157 8192000000 10956236016 11367616512 1971715952 19.399 100 85 171 0 2039341664 41662464 25963248
14:40:59 1785 8192000000 10941089952 11354206208 1959008720 19.298 100 78 155 0 2022760224 40148112 23603392
14:41:07 1307 8192000000 10953164976 11365425152 1967846880 19.368 100 91 181 2 2037816448 42344592 27624976
14:41:15 4938 8192000000 10949714080 11365732352 1967530064 19.366 100 76 152 0 2032444512 41442384 23472064
14:41:27 2472 8192000000 10959091728 11374518272 1973174336 19.411 100 90 179 1 2044412864 43181904 28056624
14:41:36 4401 8192000000 10948095568 11376267264 1974640096 19.422 100 69 137 1 2040081200 43067488 22373616
14:41:58 9637 8192000000 10895948576 11333193728 1920139744 18.988 98 49 98 2 1978510720 42679456 15691520
14:42:18 4954 8192000000 10899549216 11328454656 1915315728 18.949 99 44 88 2 1969874256 40402944 14155584
14:42:31 2376 8192000000 10914063104 11317497856 1914363776 18.942 98 80 156 2 1976811456 39101824 23345856
14:42:40 4260 8192000000 10924162672 11338924032 1929922048 19.066 99 68 136 1 1992552432 41206784 21423600
14:42:55 6594 8192000000 10895320432 11327959040 1918670064 18.976 99 42 84 2 1974099744 41951552 13478128
14:43:26 3610 8192000000 10929010704 11343286272 1940330368 19.149 99 73 144 0 2001679808 39451104 21898336
14:43:36 2634 8192000000 10934668128 11357937664 1953906304 19.258 100 77 154 0 2024830752 47257536 23666912
14:43:50 1985 8192000000 10931978400 11346493440 1938256624 19.133 99 81 159 0 2004469888 42014176 24199088
14:44:05 2585 8192000000 10927508656 11346124800 1949531744 19.223 100 69 139 1 2016474176 44560048 22382384
14:44:19 19310 8192000000 10912373616 11351879680 1950205664 19.228 100 34 68 2 2004217120 42801984 11209472
14:44:45 10877 8192000000 10925062768 11368443904 1956212480 19.276 100 38 76 1 2018308160 49461472 12634208
14:45:02 14933 8192000000 10936415872 11379200000 1962706992 19.328 100 32 64 0 2017671840 43966160 10998688
14:45:23 16229 8192000000 10940881168 11385360384 1965196560 19.347 100 28 56 0 2022268736 47329232 9742944
14:45:49 12569 8192000000 10926368064 11390300160 1948270592 19.213 99 27 54 0 2000562800 43127792 9164416
14:46:24 23884 8192000000 10897180304 11345846272 1923504464 19.015 99 28 56 0 1977230032 44105008 9620560
14:47:12 43259 8192000000 10877451792 11338240000 1926267312 19.037 100 17 34 1 1971702576 39506944 5928320
14:48:01 29716 8192000000 10873433104 11334766592 1900740608 18.832 99 22 44 0 1953803488 44671408 8391472
14:48:39 12172 8192000000 10900237520 11343941632 1925074384 19.027 100 23 46 0 1978656192 45451488 8130320
14:49:32 20745 8192000000 10869011888 11319091200 1927873136 19.050 100 14 28 1 1952611760 20715184 4023440
14:50:31 64615 8192000000 10859872544 11338375168 1889998464 18.746 98 11 22 0 1924843056 31530736 3313856
14:51:53 60521 8192000000 10874760832 11319787520 1915479712 18.951 99 23 46 0 1932742768 10786816 6476240
14:53:14 79574 8192000000 10854202960 11301421056 1860715536 18.509 96 26 49 1 1883891760 16439568 6736656
14:54:47 150712 8192000000 10889458000 11334127616 1931081792 19.076 100 31 63 5 1953618240 13594880 8941568
14:57:30 112888 8192000000 10898305472 11340439552 1916237760 18.957 98 16 32 3 1933426368 12947184 4241424
14:59:32 91143 8192000000 10897607616 11361882112 1966715200 19.359 100 33 66 1 1988097648 11992400 9390048
15:01:09 3255 8192000000 10898951984 11368091648 1972668048 19.407 100 25 50 3 1990234496 10371456 7194992
15:01:19 41571 8192000000 10925789872 11373936640 1979075440 19.457 100 29 55 0 1995904000 8407344 8421216
15:02:11 26512 8192000000 10910406880 11365920768 1954439632 19.262 98 52 103 1 1979639728 10657568 14542528
15:02:44 69728 8192000000 10903146848 11378462720 1974629712 19.422 100 14 28 1 1994939776 16191728 4118336
15:04:03 205040 8192000000 10917670848 11395850240 1988990096 19.536 100 18 36 0 2009357792 14656736 5710960
15:07:40 51270 8192000000 10909617248 11384942592 1991209648 19.553 100 13 26 2 2002382864 7365488 3807728
15:09:00 61081 8192000000 10905418976 11379109888 1970092112 19.386 99 16 32 0 1981752592 7354528 4305952
15:10:10 3908 8192000000 10950380704 11389865984 2000162208 19.624 100 75 151 4 2027909680 5800192 21947280
15:10:22 61593 8192000000 10905237904 11389755392 1991848848 19.558 100 17 34 1 2004760464 8173824 4737792
15:11:37 53342 8192000000 10907245456 11387400192 1974334736 19.420 99 7 14 1 1985212480 8810112 2067632
15:12:39 69470 8192000000 10903830608 11385692160 1950804368 19.233 98 13 26 0 1962759680 8456000 3499312
15:14:23 113780 8192000000 10912710240 11387789312 1950580480 19.231 98 10 20 0 1972418784 18891152 2947152
15:16:44 40692 8192000000 10884858800 11357827072 1924325712 19.021 97 14 28 0 1935921888 7821600 3774576
15:17:44 34008 8192000000 10901313056 11365240832 1923468688 19.015 97 35 70 0 1942222480 9336832 9416960
15:18:28 54163 8192000000 10897055120 11360772096 1917926144 18.970 97 32 64 2 1941268512 14384448 8957920
15:19:30 87578 8192000000 10856019824 11326504960 1868119648 18.569 95 12 24 0 1880846032 9589424 3136960
15:21:03 50161 8192000000 10876404688 11340472320 1880212432 18.667 96 17 34 1 1896317152 11277456 4827264
15:22:00 66017 8192000000 10865077552 11330625536 1830229920 18.261 94 15 30 1 1844944400 10559008 4155472
15:23:17 19086 8192000000 10888857568 11320684544 1903699984 18.856 98 49 97 1 1931608464 13882224 14026256
15:23:43 18701 8192000000 10880038432 11323981824 1922592400 19.008 99 57 114 0 1951110592 12890592 15627600
15:24:19 71087 8192000000 10852819232 11319091200 1855180032 18.464 96 14 28 0 1869059120 10452144 3426944
15:25:43 29618 8192000000 10889315072 11337412608 1920552048 18.991 99 30 61 1 1939794576 11026688 8215840
15:26:20 18723 8192000000 10864563024 11300552704 1837864352 18.323 95 47 94 0 1864948464 14306048 12778064
15:26:46 104813 8192000000 10837109648 11297296384 1844742080 18.379 96 37 74 0 1865975952 11336080 9897792
15:28:39 27644 8192000000 10838822336 11296903168 1907790704 18.889 100 23 46 0 1923865024 10122080 5952240
15:29:16 27493 8192000000 10847726320 11299299328 1869361024 18.579 97 36 72 2 1891071424 11440816 10269584
15:29:50 50871 8192000000 10845004256 11320688640 1925774512 19.033 100 14 28 0 1939613136 9622960 4215664
15:30:50 29025 8192000000 10840844464 11317989376 1909356240 18.901 99 7 14 1 1919601712 8719024 1526448
15:31:25 10421 8192000000 10833855568 11304841216 1905164832 18.868 99 8 15 1 1919180096 12717104 1298160
15:31:41 16019 8192000000 10864774384 11325874176 1912171040 18.924 99 11 22 1 1931964736 17039616 2754080
15:32:03 68168 8192000000 10866231664 11325739008 1876326144 18.635 97 17 34 0 1896482976 15544768 4612064
15:33:18 38806 8192000000 10856699136 11318513664 1894171424 18.779 98 25 50 1 1915176032 13788352 7216256
15:34:05 55560 8192000000 10867997200 11334766592 1889601872 18.743 98 28 54 3 1915673792 17479360 8592560
15:35:11 72966 8192000000 10850143552 11317403648 1856020256 18.471 96 15 30 1 1880703888 20350960 4332672
15:36:31 44858 8192000000 10863210896 11328884736 1901607328 18.839 98 23 46 1 1916847424 9257328 5982768
15:37:23 17120 8192000000 10914657520 11347320832 1925316416 19.029 99 44 85 0 1945039856 7650528 12072912
15:37:46 32542 8192000000 10885840992 11344048128 1933481376 19.095 99 34 68 3 1955689424 12673776 9534272
15:38:38 62654 8192000000 10885422144 11357593600 1938905104 19.138 99 20 40 1 1959353712 14792640 5655968
15:39:47 86089 8192000000 10887524864 11356307456 1929907696 19.066 99 12 24 1 1946904304 13926896 3069712
15:42:02 34850 8192000000 10890503568 11346505728 1896681600 18.800 97 31 62 0 1915655040 10027312 8946128
15:42:47 30388 8192000000 10885442944 11347640320 1934205504 19.100 99 38 76 0 1956450880 11378224 10867152
15:43:25 69174 8192000000 10885133328 11363684352 1903745616 18.856 97 17 34 1 1927112464 18761232 4605616
15:44:40 146691 8192000000 10893416272 11363450880 1959527184 19.302 100 17 34 0 1980017424 14892736 5597504
15:47:13 70617 8192000000 10912664304 11385237504 1976468992 19.437 100 22 44 0 1998298112 15981536 5847584
15:48:31 56977 8192000000 10896608112 11391762432 1977669392 19.446 100 7 14 0 1996031952 16671536 1691024
15:49:49 24776 8192000000 10895577904 11390107648 1979323712 19.459 100 6 12 0 1990965328 10078544 1563072
15:50:20 27083 8192000000 10896236512 11395371008 1980019088 19.465 100 1 2 0 1990296544 10215328 62128
15:50:54 75763 8192000000 10915725184 11401617408 1967685424 19.367 99 9 18 0 1981685680 11191472 2808784
15:52:16 65818 8192000000 10928031056 11407339520 1972699552 19.407 99 12 24 0 1995771632 19084864 3987216
15:53:28 57350 8192000000 10924701712 11382153216 1949663040 19.224 98 27 54 2 1965492336 6977456 8851840
15:54:34 63282 8192000000 10902174176 11376779264 1923692528 19.016 97 24 49 0 1937331872 6924176 6715168
15:55:44 35368 8192000000 10942700464 11404697600 1990649216 19.549 100 43 87 0 2012329088 9333840 12346032
15:56:25 75204 8192000000 10913501472 11388293120 1955419328 19.270 98 21 43 3 1974861488 13390928 6051232
15:57:47 78960 8192000000 10917188960 11400048640 1970922160 19.393 99 19 38 0 1990124064 13866528 5335376
15:59:15 55314 8192000000 10892819120 11370258432 1922661824 19.008 97 13 26 2 1937391120 11102416 3626880
16:00:20 12010 8192000000 10932311232 11381399552 1982806608 19.487 100 51 102 0 2005847936 7474880 15566448
16:00:38 29188 8192000000 10926829680 11380572160 1961550592 19.318 99 43 85 1 1983056128 9657616 11847920
16:01:15 23489 8192000000 10923233056 11383111680 1942880064 19.170 98 47 94 2 1967986992 11708960 13397968
16:01:51 37710 8192000000 10885989392 11352264704 1893440992 18.774 96 19 38 1 1908035008 9105488 5488528
16:02:35 43940 8192000000 10887791152 11357241344 1919252992 18.981 98 25 50 2 1937074848 10963760 6858096
16:03:29 67152 8192000000 10893553008 11379380224 1909052224 18.899 97 15 30 0 1928564336 15337696 4174416
16:04:52 144378 8192000000 10846819216 11317112832 1788292336 17.918 91 11 22 1 1810917632 19872528 2752768
16:08:04 72651 8192000000 10810188320 11282202624 1870581632 18.589 97 27 52 3 1889083696 11477920 7024144
16:09:29 46790 8192000000 10816284432 11299024896 1842570560 18.362 96 8 16 2 1853840928 9088432 2181936
16:10:23 84488 8192000000 10814092128 11290529792 1841004352 18.349 97 7 14 0 1852164016 8776464 2383200
16:11:53 50348 8192000000 10811843776 11275620352 1830020768 18.259 96 16 32 1 1843136512 8088944 5026800
16:12:54 69047 8192000000 10831944400 11312410624 1878907520 18.656 99 16 34 0 1897219312 12566896 5744896
16:14:18 94798 8192000000 10794264144 11262500864 1715080384 17.311 90 15 30 0 1732916912 14053072 3783456
16:15:59 64338 8192000000 10801662144 11267207168 1811344336 18.107 96 17 34 1 1823295168 7418560 4532272
16:18:15 10173 8192000000 10839638224 11287998464 1895010224 18.786 99 60 118 2 1918805104 6225088 17569792
16:18:33 33643 8192000000 10837499472 11294236672 1878905328 18.656 99 48 96 1 1902461392 9683648 13872416
16:19:14 52779 8192000000 10852577232 11304472576 1872266048 18.603 98 37 74 0 1895367920 13038720 10063152
16:20:17 78377 8192000000 10853327808 11331854336 1924029584 19.019 100 29 58 3 1949842656 17601632 8211440
16:21:42 63481 8192000000 10870266016 11334938624 1929346304 19.062 100 26 52 0 1953451376 16241504 7863568
16:24:03 76752 8192000000 10870034096 11338424320 1864997536 18.544 96 24 48 0 1886050720 14470336 6582848
16:25:32 76339 8192000000 10876347984 11343896576 1899630448 18.823 98 18 36 1 1918684992 14096752 4957792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 15-12-2020 16:28:05 to 15-12-2020 16:28:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 190 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-12-2020 16:28:36 to 15-12-2020 16:28:38.

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          258250
MON$OLDEST_ACTIVE               260824
MON$OLDEST_SNAPSHOT             260824
MON$NEXT_TRANSACTION            260824
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                       2040800
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
:70: 
:71: mscs-test-161.budzdorov.ru    Tue Dec 15 16:27:08 2020
:72:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:73: 
:74: 
:75: mscs-test-161.budzdorov.ru    Tue Dec 15 16:27:13 2020
:76:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:77: 
:78: 
:79: mscs-test-161.budzdorov.ru    Tue Dec 15 16:27:13 2020
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
--- end of diff output ---

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

15.12.20 16:28:39. 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-15 16:28:41 No severe PSQL-related problems occured
15.12.20 16:28:43. End of report.