Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.12.2020 22:29
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 17235664 kB
MemAvailable 31505376 kB
Buffers 0 kB
Cached 14489060 kB
SwapCached 2540 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-25 22:27:06
DTS_END                         2020-12-25 22:27:06.7770
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/56650
TRN_ID                          243024
ATT_ID                          718
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: 9472.03 17092 1136644
customer order: creation 176.50 327 21180
customer order: refuse 15.38 322 1845
order to supplier: creation 46.57 1204 5588
order to supplier: removal 3.63 91705 435
invoice (draft): creation 45.63 3071 5475
invoice (draft): removal 55.30 630 6636
invoice accept: apply 41.44 17757 4973
invoice accept: cancel 49.54 739 5945
customer reserve: creation 3858.80 175 463056
customer reserve: removal 4881.38 54 585766
realization accept: apply 83.70 218 10044
realization accept: cancel 83.51 108 10021
payment from customer: creation 60.13 159 7216
payment from customer: removal 5.49 123 659
payment to supplier: creation 49.66 137 5959
payment to supplier: removal 3.49 142 419
service: total inventory turnovers 4.38 1249 526
service: total monetary turnovers 6.68 82 802
service: aggregate perf. data 0.79 18659 95
service: refresh index statistics 0.03 204985 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-12-2020 22:29:45 to 25-12-2020 22:29:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4910
TEST_TIME 2 3829
TEST_TIME 3 3985
TEST_TIME 4 4332
TEST_TIME 5 4172
TEST_TIME 6 5063
TEST_TIME 7 5516
TEST_TIME 8 5402
TEST_TIME 9 5713
TEST_TIME 10 5814
TEST_TIME 11 6259
TEST_TIME 12 6521
TEST_TIME 13 6725
TEST_TIME 14 6998
TEST_TIME 15 7033
TEST_TIME 16 7984
TEST_TIME 17 8552
TEST_TIME 18 8836
TEST_TIME 19 8866
TEST_TIME 20 8942
TEST_TIME 21 9324
TEST_TIME 22 9150
TEST_TIME 23 9478
TEST_TIME 24 9918
TEST_TIME 25 9763
TEST_TIME 26 9846
TEST_TIME 27 10831
TEST_TIME 28 11456
TEST_TIME 29 11441
TEST_TIME 30 11222
TEST_TIME 31 11184
TEST_TIME 32 11262
TEST_TIME 33 11027
TEST_TIME 34 10998
TEST_TIME 35 10891
TEST_TIME 36 10668
TEST_TIME 37 10646
TEST_TIME 38 10661
TEST_TIME 39 10521
TEST_TIME 40 10400
TEST_TIME 41 10373
TEST_TIME 42 10329
TEST_TIME 43 10275
TEST_TIME 44 10416
TEST_TIME 45 10264
TEST_TIME 46 10204
TEST_TIME 47 10037
TEST_TIME 48 10003
TEST_TIME 49 10045
TEST_TIME 50 10051
TEST_TIME 51 10065
TEST_TIME 52 9898
TEST_TIME 53 9889
TEST_TIME 54 9830
TEST_TIME 55 9776
TEST_TIME 56 9815
TEST_TIME 57 9782
TEST_TIME 58 9894
TEST_TIME 59 9820
TEST_TIME 60 9917
TEST_TIME 61 9951
TEST_TIME 62 9999
TEST_TIME 63 9991
TEST_TIME 64 9978
TEST_TIME 65 9980
TEST_TIME 66 9968
TEST_TIME 67 10029
TEST_TIME 68 10036
TEST_TIME 69 10148
TEST_TIME 70 10034
TEST_TIME 71 9974
TEST_TIME 72 9945
TEST_TIME 73 9866
TEST_TIME 74 9904
TEST_TIME 75 9887
TEST_TIME 76 9827
TEST_TIME 77 9808
TEST_TIME 78 9785
TEST_TIME 79 9781
TEST_TIME 80 9729
TEST_TIME 81 9681
TEST_TIME 82 9716
TEST_TIME 83 9696
TEST_TIME 84 9712
TEST_TIME 85 9756
TEST_TIME 86 9803
TEST_TIME 87 9777
TEST_TIME 88 9825
TEST_TIME 89 9828
TEST_TIME 90 9812
TEST_TIME 91 9880
TEST_TIME 92 9922
TEST_TIME 93 10015
TEST_TIME 94 9924
TEST_TIME 95 9829
TEST_TIME 96 9846
TEST_TIME 97 9806
TEST_TIME 98 9738
TEST_TIME 99 9718
TEST_TIME 100 9698
TEST_TIME 101 9663
TEST_TIME 102 9651
TEST_TIME 103 9673
TEST_TIME 104 9643
TEST_TIME 105 9640
TEST_TIME 106 9696
TEST_TIME 107 9694
TEST_TIME 108 9706
TEST_TIME 109 9690
TEST_TIME 110 9735
TEST_TIME 111 9732
TEST_TIME 112 9703
TEST_TIME 113 9708
TEST_TIME 114 9786
TEST_TIME 115 9747
TEST_TIME 116 9669
TEST_TIME 117 9651
TEST_TIME 118 9605
TEST_TIME 119 9554
TEST_TIME 120 9475

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-12-2020 22:29:49 to 25-12-2020 22:29:52.

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 1566925 1566925 0 0.00 0 44820 7 0 0
doc_list_biud 1566925 1566925 0 0.00 0 57324 25 0 0
sp_add_invoice_to_stock 5128 4973 155 3.02 33 222027 17757 0 155
sp_cancel_adding_invoice 5945 5945 0 0.00 5 60778 740 0 0
sp_cancel_client_order 1845 1845 0 0.00 4 12195 322 0 0
sp_cancel_customer_reserve 585766 585766 0 0.00 1 57329 55 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 3 31460 124 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 28358 143 0 0
sp_cancel_supplier_invoice 6649 6636 13 0.19 1 13096 630 0 13
sp_cancel_supplier_order 435 435 0 0.00 5 1054717 91706 0 0
sp_cancel_write_off 10021 10021 0 0.00 1 32929 109 0 0
sp_client_order 21180 21180 0 0.00 4 61291 328 0 0
sp_customer_reserve 463056 463056 0 0.00 0 32905 175 0 0
sp_fill_shopping_cart 32238 32238 0 0.00 1 13599 36 0 0
sp_fill_shopping_cart_clo_res 463049 463049 0 0.00 0 20968 14 0 0
sp_get_clo_for_invoice 4965 4965 0 0.00 0 25390 319 0 0
sp_kill_cost_storno 17044 17044 0 0.00 0 32827 59 0 0
sp_kill_qstorno_ret_qs2qd 1188624 1188624 0 0.00 0 57310 29 0 0
sp_kill_qty_storno 625656 625656 0 0.00 0 57323 63 0 0
sp_lock_selected_doc 20867 20867 0 0.00 0 9982 6 0 0
sp_make_cost_storno 28183 28183 0 0.00 0 44805 57 0 0
sp_multiply_rows_for_pdistr 28183 28183 0 0.00 0 37305 47 0 0
sp_multiply_rows_for_qdistr 21180 21180 0 0.00 0 61279 156 0 0
sp_pay_from_customer 7216 7216 0 0.00 4 34623 159 0 0
sp_pay_to_supplier 5959 5959 0 0.00 4 34606 137 0 0
sp_payment_common 13175 13175 0 0.00 1 33854 60 0 0
sp_qd_handle_on_cancel_clo 1845 1845 0 0.00 0 12187 293 0 0
sp_qd_handle_on_invoice_upd_sts 10909 10909 0 0.00 0 13515 298 0 0
sp_qd_handle_on_reserve_upd_sts 10044 10044 0 0.00 0 25214 65 0 0
sp_reserve_write_off 10044 10044 0 0.00 6 45654 219 0 0
sp_supplier_invoice 5475 5475 0 0.00 7 93688 3072 0 0
sp_supplier_order 5588 5588 0 0.00 5 37400 1205 0 0
srv_aggregate_perf_data 95 95 0 0.00 2410 111359 18660 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1159 140310 31969 0 0
srv_find_qd_qs_mism 1089169 1089169 0 0.00 0 6124 5 0 0
srv_make_invnt_saldo 526 526 0 0.00 46 51273 1249 0 0
srv_make_money_saldo 802 802 0 0.00 1 21703 82 0 0
srv_recalc_idx_stat 4 4 0 0.00 110422 283889 204986 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4973 4973 0 0.00 0 18884 166 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 2868 88 0 0
t$perf-norm:sp_cancel_client_order 1845 1845 0 0.00 0 7176 14 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 980 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 892 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 2391 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 2363 24 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 22241 1595 0 0
t$perf-norm:sp_cancel_write_off 1011 1011 0 0.00 0 7766 16 0 0
t$perf-norm:sp_client_order 21180 21180 0 0.00 0 18464 17 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 4923 11 0 0
t$perf-norm:sp_pay_from_customer 7216 7216 0 0.00 0 4984 10 0 0
t$perf-norm:sp_pay_to_supplier 5959 5959 0 0.00 0 7214 11 0 0
t$perf-norm:sp_reserve_write_off 10044 10044 0 0.00 0 7484 12 0 0
t$perf-norm:sp_supplier_invoice 5475 5475 0 0.00 0 8080 20 0 0
t$perf-norm:sp_supplier_order 5588 5588 0 0.00 0 3121 16 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 154 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 482 9 0 0
t$perf-norm:srv_make_invnt_saldo 526 526 0 0.00 0 3453 28 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 6792 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10238 9928 310 3.02 0 7594 22 0 310
v_all_customers 38938 38938 0 0.00 0 212 1 0 0
v_all_suppliers 31044 31044 0 0.00 0 21 1 0 0
v_all_wares 42360 42360 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 2972 14 0 0
v_cancel_client_order 3690 3690 0 0.00 0 3525 7 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 1894 6 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 599 4 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 2739 6 0 0
v_cancel_supplier_invoice 830 804 26 3.13 0 661 16 0 26
v_cancel_supplier_order 870 870 0 0.00 0 620 4 0 0
v_cancel_write_off 2022 2022 0 0.00 0 5304 19 0 0
v_max_id_clo_ord 5586 5586 0 0.00 0 622 2 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 3782 21 0 0
v_max_id_ord_sup 5472 5472 0 0.00 0 7013 7 0 0
v_max_non_paid_invoice 1495 1495 0 0.00 0 2113 5 0 0
v_max_non_paid_realizn 3731 3731 0 0.00 0 1977 4 0 0
v_min_id_clo_ord 5586 5586 0 0.00 0 3722 9 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 15111 20 0 0
v_min_id_ord_sup 5472 5472 0 0.00 0 7492 10 0 0
v_min_non_paid_invoice 5959 5959 0 0.00 0 33839 37 0 0
v_min_non_paid_realizn 7216 7216 0 0.00 0 33841 58 0 0
v_our_firm 10392 10392 0 0.00 0 14 1 0 0
v_reserve_write_off 20088 20088 0 0.00 0 3806 6 0 0
x_lock_depdocs_on_canc_invoice 12179 12179 0 0.00 0 16138 127 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 7490 305 0 0
x_make_qstorno_1000_1200 5588 5588 0 0.00 2 37386 1122 0 0
x_make_qstorno_1200_2000 5475 5475 0 0.00 3 93670 2950 0 0
x_make_qstorno_2100_3300 463056 463056 0 0.00 0 30089 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-12-2020 22:29:53 to 25-12-2020 22:29:57.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:09 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:15 13274 8192000000 10238437520 10547146752 849925072 9.399 68 47 97 0 868599728 2424304 16250352
19:57:39 31038 8192000000 10349492048 10666561536 1380837616 14.424 100 86 172 0 1413858816 4524848 28496352
19:58:22 25938 8192000000 10382714368 10707087360 1438106672 14.933 100 92 184 0 1474728448 6820224 29801552
19:58:58 13256 8192000000 10401919856 10728050688 1459633856 15.123 100 85 170 0 1495165264 7472560 28058848
19:59:21 23754 8192000000 10431163840 10762432512 1477288240 15.278 100 90 180 0 1514909904 7934064 29687600
19:59:53 8694 8192000000 10440694352 10775175168 1493204272 15.417 100 87 174 0 1529502320 8217392 28080656
20:00:15 20156 8192000000 10462549824 10798571520 1516601216 15.621 100 88 176 0 1553216688 8687904 27927568
20:00:47 28141 8192000000 10492283664 10836008960 1544337280 15.861 100 90 180 0 1582006896 9419120 28250496
20:01:31 10992 8192000000 10533631888 10880733184 1585399968 16.214 100 88 176 0 1622874240 10523696 26950576
20:01:59 15494 8192000000 10550944160 10902945792 1607412064 16.403 100 85 170 0 1644815680 11321024 26082592
20:02:24 15358 8192000000 10573442400 10929721344 1621852688 16.526 100 83 167 0 1658773760 11771424 25149648
20:02:47 12394 8192000000 10592483488 10949349376 1641873232 16.696 100 83 166 0 1679187248 12685008 24629008
20:03:09 11241 8192000000 10597051232 10962817024 1659744192 16.847 100 81 162 2 1696654832 13171392 23739248
20:03:30 9934 8192000000 10617915552 10983124992 1680260912 17.020 100 85 169 2 1718482432 13503216 24718304
20:03:49 6523 8192000000 10628954208 10995515392 1686147536 17.069 100 82 163 0 1722984864 12730256 24107072
20:04:05 8809 8192000000 10628984784 11002671104 1695618672 17.148 100 79 158 0 1731319152 12128672 23571808
20:04:21 7177 8192000000 10646748640 11020693504 1709802176 17.267 100 78 154 0 1744040896 11946496 22292224
20:04:36 8363 8192000000 10670237632 11043188736 1725648288 17.399 100 80 160 1 1759781696 11085600 23047808
20:04:52 5811 8192000000 10680610832 11054104576 1739687632 17.516 100 76 151 1 1772854976 11435472 21731872
20:05:05 4008 8192000000 10685965056 11059343360 1750871904 17.609 100 79 154 4 1784741008 12054672 21814432
20:05:17 6133 8192000000 10702849728 11081560064 1762128640 17.702 100 78 156 0 1796850928 12816128 21906160
20:05:30 3684 8192000000 10708710624 11084201984 1777625632 17.830 100 82 163 2 1813058560 12541424 22891504
20:05:40 5143 8192000000 10728377664 11106631680 1782861088 17.873 100 82 164 3 1820242864 13899824 23481952
20:05:52 2951 8192000000 10732871168 11114024960 1791907392 17.947 100 89 179 1 1830550064 13973600 24669072
20:06:02 3581 8192000000 10743164864 11124940800 1799888304 18.013 100 90 178 2 1839859568 14856224 25115040
20:06:13 3521 8192000000 10740693936 11127013376 1803867536 18.046 100 82 163 1 1841189312 14387488 22934288
20:06:23 3244 8192000000 10757689488 11139137536 1814024480 18.129 100 89 174 2 1851516528 13435440 24056608
20:06:32 2588 8192000000 10765086032 11150622720 1824313872 18.213 100 94 187 1 1864172720 13761104 26097744
20:06:42 4359 8192000000 10769122352 11155824640 1824675840 18.216 100 85 166 2 1861548704 13915440 22957424
20:06:53 4966 8192000000 10772082432 11162193920 1830500272 18.263 100 75 150 2 1865147136 13130960 21515904
20:07:05 2441 8192000000 10790377344 11180310528 1849687744 18.420 100 91 181 1 1888235072 13258832 25288496
20:07:13 1815 8192000000 10794045680 11183964160 1852739760 18.444 100 91 181 0 1891665984 12683376 26242848
20:07:21 1933 8192000000 10796555056 11182620672 1855671328 18.468 100 94 189 4 1893661504 11414224 26575952
20:07:30 1608 8192000000 10810442288 11197108224 1864586544 18.540 100 99 197 1 1905009136 13384384 27038208
20:07:37 1599 8192000000 10804339856 11195740160 1866185376 18.553 100 91 182 1 1906610528 14014160 26410992
20:07:45 1845 8192000000 10811889488 11201331200 1869015328 18.576 100 97 195 0 1910476096 14488272 26972496
20:07:53 1081 8192000000 10821978336 11211923456 1874596800 18.621 100 96 191 4 1915572304 14887408 26088096
20:08:01 1510 8192000000 10819959472 11212197888 1886173072 18.715 100 92 185 2 1925487984 13789968 25524944
20:08:09 11865 8192000000 10819654832 11219361792 1879341024 18.660 100 68 137 0 1910440288 11843952 19255312
20:08:27 2663 8192000000 10811932768 11218391040 1881761888 18.679 100 65 130 1 1912384320 12531536 18090896
20:08:36 2275 8192000000 10816660032 11223183360 1884900432 18.705 100 69 131 1 1913536224 10772224 17863568
20:08:44 2499 8192000000 10819063568 11223363584 1883018576 18.689 100 51 102 0 1910170288 12952976 14198736
20:08:53 5078 8192000000 10797692160 11218100224 1880515776 18.669 100 36 72 1 1899872896 8871936 10485184
20:09:08 5270 8192000000 10819996576 11224690688 1887177680 18.723 100 48 95 1 1912485184 12498960 12808544
20:09:19 10304 8192000000 10820295584 11223207936 1892675216 18.767 100 53 105 6 1911953184 4407936 14870032
20:09:36 40693 8192000000 10817895696 11232055296 1885705872 18.711 100 23 46 0 1898031472 5919040 6406560
20:10:47 1383 8192000000 10853046880 11250794496 1901762368 18.840 100 92 185 1 1937907728 9331776 26813584
20:10:55 3594 8192000000 10825389824 11246403584 1893939552 18.778 100 55 110 1 1921373904 12233744 15200608
20:11:05 3822 8192000000 10819889728 11240910848 1892893040 18.769 100 45 89 1 1914478304 9417360 12167904
20:11:15 4415 8192000000 10810542496 11239510016 1893571360 18.775 100 37 74 0 1911686704 7623360 10491984
20:11:28 3858 8192000000 10807394368 11237527552 1890699776 18.751 100 27 55 2 1905023024 6136992 8186256
20:11:39 10880 8192000000 10819759232 11242905600 1896261632 18.796 100 31 61 0 1912164096 7191712 8710752
20:11:56 7462 8192000000 10817632288 11248308224 1898168240 18.812 100 27 54 0 1911177440 5104176 7905024
20:12:12 10218 8192000000 10817171248 11246546944 1898618560 18.815 100 24 48 1 1912576640 6520176 7437904
20:12:28 5903 8192000000 10813080592 11247714304 1899253552 18.820 100 21 42 3 1911329728 6147296 5928880
20:12:45 12539 8192000000 10817490096 11253059584 1906180144 18.876 100 15 30 3 1916229584 5677872 4371568
20:13:08 16876 8192000000 10829601872 11259797504 1907832848 18.889 100 23 46 0 1925859744 9026432 9000464
20:13:31 33408 8192000000 10866489728 11270082560 1916742080 18.961 100 72 146 2 1945351872 7080000 21529792
20:14:10 10097 8192000000 10821108176 11260137472 1909444256 18.902 100 18 36 0 1920745360 6248528 5052576
20:14:27 10492 8192000000 10826533760 11262631936 1912368848 18.926 100 26 52 2 1925748928 6382256 6997824
20:14:44 7178 8192000000 10829687664 11265376256 1912933440 18.930 100 23 47 1 1925104208 6067232 6103536
20:14:58 4393 8192000000 10826554288 11253383168 1905685584 18.872 100 32 67 0 1922637984 7127760 9824640
20:15:09 9766 8192000000 10819773392 11260604416 1909971840 18.906 100 19 38 2 1921076896 5873344 5231712
20:15:29 7171 8192000000 10827927984 11264151552 1914456624 18.942 100 20 40 4 1925678688 5748800 5473264
20:15:46 2611 8192000000 10840091456 11270770688 1919876720 18.986 100 33 66 0 1936206928 6609680 9720528
20:15:57 4218 8192000000 10828239184 11262578688 1900007856 18.826 99 32 61 3 1914805648 6776032 8021760
20:16:08 7253 8192000000 10831811344 11256094720 1870340432 18.587 98 21 42 1 1886300480 10092272 5867776
20:16:24 8043 8192000000 10830828928 11263672320 1909976160 18.906 100 28 56 1 1923811536 5833296 8002080
20:16:40 10040 8192000000 10799159776 11233214464 1859473424 18.499 98 18 36 1 1869563040 5210640 4878976
20:16:58 8121 8192000000 10791876048 11225305088 1856497232 18.475 98 19 38 3 1867903328 5898960 5507136
20:17:13 11955 8192000000 10789396928 11204227072 1842334560 18.360 98 15 30 0 1852252128 5235904 4681664
20:17:31 69684 8192000000 10740768752 11160137728 1631016608 16.604 87 31 61 3 1644137232 4721248 8399376
20:18:47 8019 8192000000 10713355424 11136024576 1738266704 17.504 95 19 38 2 1749932512 6638304 5027504
20:19:04 3701 8192000000 10736327904 11140284416 1754019216 17.635 96 43 86 1 1773513840 7394944 12099680
20:19:16 3659 8192000000 10740840640 11155623936 1801260240 18.024 99 42 83 3 1820112544 6460672 12391632
20:19:26 10787 8192000000 10706666512 11124482048 1731962544 17.452 96 24 48 3 1745036256 5711088 7362624
20:19:43 7319 8192000000 10700168320 11101859840 1737674912 17.499 97 39 78 3 1755893792 7107728 11111152
20:19:57 11142 8192000000 10692559040 11110825984 1722410800 17.372 96 25 50 1 1734964064 5626768 6926496
20:20:17 5993 8192000000 10680485296 11098533888 1759310704 17.679 99 26 52 1 1773109232 6136144 7662384
20:20:31 5234 8192000000 10696149552 11116859392 1783220480 17.876 100 28 56 2 1797591088 6337088 8033520
20:20:52 10439 8192000000 10707066464 11128287232 1768748160 17.757 98 29 57 1 1782721424 5568208 8405056
20:21:08 12402 8192000000 10747097936 11153637376 1799776960 18.012 99 26 52 1 1812232112 5044608 7410544
20:21:30 8234 8192000000 10728148416 11147657216 1786201840 17.901 98 28 57 0 1800247472 5498448 8547184
20:21:47 11841 8192000000 10717446208 11136962560 1760092544 17.685 97 21 43 0 1771418192 5382896 5942752
20:22:08 17018 8192000000 10732156336 11139776512 1774690448 17.806 98 19 37 2 1784796272 4782672 5323152
20:22:50 38974 8192000000 10728347584 11153035264 1813097776 18.121 100 46 92 2 1832661920 6147584 13416560
20:23:35 11226 8192000000 10733147728 11156877312 1811253712 18.106 99 25 50 3 1824534368 5880544 7400112
20:23:53 7812 8192000000 10747065504 11167772672 1832509088 18.280 100 23 46 0 1845564656 6110880 6944688
20:24:07 6479 8192000000 10754092256 11174453248 1839334992 18.335 100 29 59 1 1854090560 6892528 7863040
20:24:21 5279 8192000000 10751561888 11179839488 1841701888 18.355 100 29 58 2 1857122960 7451456 7969616
20:24:33 7971 8192000000 10759117104 11176771584 1842016528 18.357 100 19 38 1 1853493808 5554864 5922416
20:24:48 8210 8192000000 10758170032 11185451008 1848734704 18.412 100 33 67 0 1864354928 5395216 10225008
20:25:02 8049 8192000000 10766495200 11189432320 1849714672 18.420 100 22 44 1 1861900080 5576800 6608608
20:25:18 10049 8192000000 10760770240 11190636544 1851281936 18.433 100 19 38 1 1863543248 6638416 5622896
20:25:36 8325 8192000000 10763519120 11195719680 1853883376 18.454 100 15 30 0 1871938432 13599440 4455616
20:25:51 11272 8192000000 10771877040 11197841408 1860432672 18.507 100 23 46 0 1872895376 5233296 7229408
20:26:10 12590 8192000000 10787468320 11206733824 1861260448 18.513 100 29 58 1 1875579136 5135776 9182912
20:26:30 8834 8192000000 10784708992 11207938048 1865534016 18.548 100 33 66 1 1880676352 5141392 10000944
20:26:46 14120 8192000000 10781342848 11208396800 1866487568 18.556 100 21 41 3 1878513392 5695936 6329888
20:27:12 60364 8192000000 10816052064 11240361984 1894309856 18.781 100 33 66 0 1910704864 5185488 11209520
20:28:35 10767 8192000000 10845014896 11261263872 1916014912 18.955 100 56 112 1 1940879456 8293584 16570960
20:28:54 43532 8192000000 10853035824 11276312576 1925123168 19.028 100 56 112 0 1950390736 9156272 16111296
20:30:04 61538 8192000000 10862999936 11296677888 1932973888 19.091 100 37 74 1 1956612656 12149056 11489712
20:31:23 23129 8192000000 10860003056 11300880384 1936894400 19.122 100 32 65 4 1957716016 11447824 9373792
20:32:03 15100 8192000000 10867561760 11300409344 1924895024 19.026 99 45 90 0 1951270000 12723344 13651632
20:32:28 1992 8192000000 10897614560 11311673344 1949836464 19.225 100 74 149 4 1985309664 13946176 21527024
20:32:45 20359 8192000000 10886462240 11315748864 1945366672 19.190 100 52 104 2 1976048656 15452960 15229024
20:33:12 22655 8192000000 10885735040 11325620224 1951541568 19.239 100 42 84 1 1985671936 21207424 12922944
20:33:59 10553 8192000000 10882995216 11311128576 1928366880 19.054 99 38 76 0 1959274016 19591648 11315488
20:34:17 15121 8192000000 10889875520 11324272640 1950433904 19.230 100 42 84 3 1981140496 17504144 13202448
20:34:39 4757 8192000000 10913286624 11337297920 1962873136 19.329 100 67 131 1 2001659328 19435600 19350592
20:34:50 5907 8192000000 10915947824 11339362304 1965102816 19.347 100 58 116 0 2002134320 20710384 16321120
20:35:08 11194 8192000000 10917935616 11348856832 1970895008 19.393 100 59 117 1 2009586832 21561088 17130736
20:35:31 14629 8192000000 10919256496 11350126592 1971818800 19.400 100 53 105 1 2010294208 22442656 16032752
20:35:55 12568 8192000000 10930134800 11358793728 1976875120 19.440 100 54 106 1 2015182800 22416192 15891488
20:36:16 7885 8192000000 10938011456 11367317504 1985354976 19.507 100 57 114 1 2026256288 23563184 17338128
20:36:33 4378 8192000000 10944213472 11370561536 1968811888 19.376 99 63 125 1 2012845440 24285088 19748464
20:36:48 7031 8192000000 10936013248 11368157184 1983713120 19.494 100 57 113 1 2027822304 26834032 17275152
20:37:02 4155 8192000000 10932677200 11359539200 1965877568 19.353 99 51 102 1 2004697712 22538592 16281552
20:37:14 5544 8192000000 10936540912 11361423360 1980347792 19.467 100 61 122 0 2023064384 24273248 18443344
20:37:28 24855 8192000000 10944495872 11371503616 1967282112 19.364 99 57 112 1 2013630304 28849856 17498336
20:38:02 13093 8192000000 10940338112 11376009216 1986314480 19.515 100 53 106 2 2031881600 28541888 17025232
20:38:23 6202 8192000000 10926195808 11362275328 1962458112 19.326 99 52 103 0 2006221280 27578816 16184352
20:38:37 5911 8192000000 10920113456 11350487040 1956683744 19.280 99 53 105 1 1996408832 23863616 15861472
20:38:50 4888 8192000000 10943951936 11362951168 1979244736 19.459 100 68 136 0 2026400256 26209296 20946224
20:39:07 6151 8192000000 10937559616 11367878656 1979879104 19.464 100 63 122 1 2029076688 29644704 19552880
20:39:22 1155 8192000000 10941932032 11358720000 1964532000 19.342 99 75 150 3 2017779616 30798000 22449616
20:39:30 1894 8192000000 10956486880 11372191744 1981979328 19.480 100 89 176 1 2039755984 31447504 26329152
20:39:39 3206 8192000000 10953198048 11372003328 1986527856 19.516 100 82 161 0 2041996816 31678288 23790672
20:39:50 4008 8192000000 10939897840 11359764480 1963532352 19.334 99 79 158 2 2017330608 30551168 23247088
20:40:04 4519 8192000000 10953766256 11369869312 1982483072 19.484 100 79 158 0 2038197344 31966384 23747888
20:40:15 3094 8192000000 10956694912 11373371392 1985220144 19.506 100 86 172 8 2041324512 30789792 25314576
20:40:26 4309 8192000000 10953688672 11370467328 1965106800 19.347 99 78 156 1 2020047600 31430976 23509824
20:40:36 2651 8192000000 10947831232 11366998016 1974897184 19.424 100 80 159 1 2034213696 35589984 23726528
20:40:49 8231 8192000000 10944032992 11367247872 1979147888 19.458 100 67 134 2 2031612512 32187664 20276960
20:41:03 1423 8192000000 10969288208 11378073600 1985535312 19.508 100 97 193 2 2047117088 33950688 27631088
20:41:13 3647 8192000000 10945739824 11358699520 1971744400 19.399 100 89 178 0 2034010720 35605264 26661056
20:41:25 2647 8192000000 10925616096 11336495104 1945073888 19.187 98 82 160 2 2005725072 35639648 25011536
20:41:36 9091 8192000000 10951312256 11367579648 1974313728 19.420 100 75 150 0 2033137456 35936768 22886960
20:41:52 4072 8192000000 10946014304 11366895616 1961601328 19.319 99 72 142 2 2021521440 37602064 22318048
20:42:04 1309 8192000000 10914909984 11332694016 1912229568 18.925 98 76 146 4 1978579680 43200624 23149488
20:42:12 5421 8192000000 10937127568 11353661440 1957526544 19.286 100 83 164 1 2022959696 40535104 24898048
20:42:26 2995 8192000000 10923370976 11332194304 1923247216 19.013 99 86 173 1 1992741168 42871712 26622240
20:42:36 3436 8192000000 10923230512 11336552448 1926457328 19.039 99 76 153 1 1995477472 44841952 24178192
20:42:49 2196 8192000000 10926102736 11334975488 1927699152 19.048 99 84 168 2 2000313200 46152160 26461888
20:42:59 3977 8192000000 10933733840 11341815808 1937018464 19.123 100 90 178 1 2014664816 48650320 28996032
20:43:11 3058 8192000000 10947578656 11360346112 1951321168 19.237 100 84 167 1 2027394000 49304912 26767920
20:43:22 2587 8192000000 10937298800 11350405120 1950719040 19.232 100 83 163 1 2022635040 46166416 25749584
20:43:32 2327 8192000000 10952715168 11366109184 1963061584 19.330 100 84 163 1 2034985280 46910672 25013024
20:43:42 3715 8192000000 10947043424 11358322688 1952297072 19.245 99 87 175 4 2017559552 37665120 27597360
20:43:55 1560 8192000000 10933718448 11343724544 1949644736 19.224 99 86 170 2 2016381296 39803360 26933200
20:44:05 5106 8192000000 10948996736 11368198144 1966923680 19.361 100 77 155 0 2032501936 41413216 24165040
20:44:18 4022 8192000000 10931183440 11347034112 1955670016 19.272 100 71 141 1 2016184352 38768176 21746160
20:44:30 3816 8192000000 10933372880 11347804160 1950875616 19.233 100 71 142 0 2012031664 39226560 21929488
20:44:41 2321 8192000000 10929335840 11345326080 1953684672 19.256 100 70 140 0 2012849680 37839456 21325552
20:44:51 1920 8192000000 10927900960 11341635584 1951312288 19.237 100 75 150 0 2010057344 35871472 22873584
20:45:00 7951 8192000000 10912730912 11339485184 1945905680 19.194 100 51 102 0 1997993120 36050688 16036752
20:45:17 14169 8192000000 10897211744 11337302016 1927670048 19.048 99 29 58 2 1972367424 35093104 9604272
20:45:59 11907 8192000000 10875366112 11307466752 1904445472 18.862 99 40 80 0 1952579264 34674832 13458960
20:46:18 16077 8192000000 10886805344 11329699840 1930327040 19.069 100 31 62 1 1973451696 33031056 10093600
20:46:45 8444 8192000000 10899940160 11338850304 1943161104 19.172 100 32 63 2 1986240992 32776464 10303424
20:47:00 17040 8192000000 10883932896 11315720192 1861339472 18.514 96 33 65 1 1912558176 40331920 10886784
20:47:27 5859 8192000000 10886776192 11306430464 1890737328 18.752 99 67 132 3 1949084976 37288528 21059120
20:47:40 9687 8192000000 10890151024 11314778112 1916017904 18.955 100 47 94 1 1971952912 40001280 15933728
20:47:57 19250 8192000000 10885429584 11323355136 1919036240 18.979 100 30 60 2 1971105968 41990096 10079632
20:48:31 11576 8192000000 10894556736 11336388608 1935748704 19.113 100 25 50 0 1981539232 37423184 8367344
20:48:55 16024 8192000000 10901200704 11341488128 1927094064 19.044 99 29 58 2 1971702432 34678304 9930064
20:49:17 7481 8192000000 10910466544 11340959744 1925359424 19.030 99 40 80 1 1978312080 39945952 13006704
20:49:32 22066 8192000000 10901359808 11341299712 1920611936 18.992 99 32 64 0 1974807600 43581776 10613888
20:50:01 6219 8192000000 10914515280 11343626240 1935161584 19.108 100 44 87 1 1997049392 47357184 14530624
20:50:15 2503 8192000000 10943257472 11367235584 1951624032 19.239 100 76 152 1 2029100928 52423552 25053344
20:50:25 4840 8192000000 10951131936 11383193600 1960548864 19.310 100 59 118 0 2033315648 53485856 19280928
20:50:38 8776 8192000000 10943112848 11389349888 1961373792 19.317 100 38 76 2 2026593104 52397744 12821568
20:51:16 22095 8192000000 10921343296 11375906816 1941894176 19.162 99 31 62 0 1994151872 42140480 10117216
20:51:52 16742 8192000000 10928784512 11367022592 1960247104 19.308 100 36 71 0 2008317696 36676512 11394080
20:52:20 18943 8192000000 10922669584 11367919616 1956859280 19.281 100 26 52 1 2005376720 39907152 8610288
20:52:46 44958 8192000000 10914942592 11369852928 1926777248 19.041 99 26 52 0 1983250512 46712880 9760384
20:53:38 11856 8192000000 10916710800 11372339200 1934822112 19.105 100 22 44 1 2002037248 58699904 8515232
20:53:59 22555 8192000000 10904065200 11382333440 1925033664 19.027 100 18 36 0 1991582608 59007840 7541104
20:55:02 54443 8192000000 10857461040 11330813952 1880475616 18.669 98 4 8 1 1899786160 18356000 954544
20:56:05 88033 8192000000 10872941312 11322474496 1883902880 18.697 97 26 52 1 1902503520 12044576 6556064
20:57:46 38518 8192000000 10886226880 11328983040 1927027024 19.043 99 26 52 3 1944395840 9921904 7446912
20:58:37 80856 8192000000 10891355776 11364478976 1935309792 19.109 99 8 16 1 1949036688 12303600 1423296
21:00:05 78785 8192000000 10908605952 11368882176 1922464000 19.007 98 22 44 1 1939667472 11309216 5894256
21:01:31 121206 8192000000 10903954432 11364003840 1947526336 19.207 99 24 48 3 1973722384 18671520 7524528
21:03:47 53565 8192000000 10893632832 11361214464 1933764432 19.097 98 31 59 0 1949113568 6903024 8446112
21:04:48 75807 8192000000 10901883616 11368009728 1953384288 19.253 99 24 48 3 1970642512 10208032 7050192
21:06:12 81865 8192000000 10901044640 11359535104 1955144352 19.267 99 24 48 1 1970756128 9047280 6564496
21:07:40 23265 8192000000 10926264544 11378388992 1981944688 19.480 100 45 90 0 2005025072 10434400 12645984
21:08:10 26437 8192000000 10898468448 11370991616 1961480976 19.318 99 11 22 0 1974232224 9530208 3221040
21:08:48 16770 8192000000 10911017904 11367161856 1964164640 19.339 99 30 59 2 1982455392 9497056 8793696
21:09:14 49724 8192000000 10932176128 11382169600 1985316512 19.507 100 29 59 1 2008132960 13811040 9005408
21:10:12 26597 8192000000 10956490208 11392335872 1995584432 19.588 100 59 116 3 2025071936 12617872 16869632
21:10:58 55798 8192000000 10910136640 11395624960 1991831440 19.558 100 19 35 2 2009140544 12172032 5137072
21:12:10 56089 8192000000 10907147264 11381354496 1969755824 19.384 99 8 16 1 1980154672 7931968 2466880
21:13:47 35257 8192000000 10925396800 11405402112 1997293568 19.601 100 9 18 0 2009594592 9517232 2783792
21:15:57 65397 8192000000 10908394320 11381391360 1961665424 19.319 99 14 27 1 1979727360 13932112 4129824
21:17:14 34034 8192000000 10931760240 11389497344 1983518752 19.493 100 28 55 2 2001312256 10435616 7357888
21:18:01 57274 8192000000 10889251280 11382956032 1931526848 19.079 97 8 16 0 1945155776 11321712 2307216
21:19:11 46241 8192000000 10885416848 11366645760 1939192608 19.140 98 11 22 0 1952737392 10390784 3154000
21:20:08 84571 8192000000 10875067152 11363762176 1940351760 19.150 99 10 20 0 1951361696 8293968 2715968
21:21:41 33434 8192000000 10896171968 11371069440 1953926528 19.258 99 16 33 0 1965478096 7305536 4246032
21:22:23 17848 8192000000 10878894944 11350077440 1947568192 19.207 99 26 51 3 1961903728 7202640 7132896
21:22:53 35944 8192000000 10890896672 11365072896 1949295792 19.221 99 18 36 0 1965325008 10694848 5334368
21:23:35 45691 8192000000 10899755152 11359719424 1937350096 19.126 98 26 52 0 1956172240 11790864 7031280
21:25:18 52064 8192000000 10890674208 11361546240 1913280880 18.933 97 9 17 1 1929780240 14055632 2443728
21:26:24 38543 8192000000 10894713120 11350503424 1910805296 18.913 97 31 62 1 1934083984 14524112 8754576
21:27:36 40057 8192000000 10894095984 11357245440 1939537584 19.143 99 13 26 2 1958020272 15395808 3086880
21:28:22 85472 8192000000 10870169584 11344130048 1830464944 18.263 93 6 12 0 1844404592 12551056 1388592
21:29:56 50944 8192000000 10890473552 11342893056 1909271616 18.901 98 10 20 0 1921179680 9010304 2897760
21:30:53 53362 8192000000 10882425152 11348328448 1933154208 19.092 99 25 50 2 1950283024 10174832 6953984
21:31:53 36645 8192000000 10880665872 11336515584 1915098992 18.948 98 28 56 2 1931438560 8817488 7522080
21:32:40 40777 8192000000 10830006224 11293839360 1807257008 18.073 94 27 54 1 1829239088 14621136 7360944
21:33:28 46059 8192000000 10833016720 11297845248 1849722144 18.420 97 16 32 1 1870611872 16174336 4715392
21:34:21 21796 8192000000 10824931904 11266359296 1841475392 18.353 97 34 68 1 1859857904 9227504 9155008
21:34:51 43457 8192000000 10831283824 11286564864 1865349552 18.547 98 33 67 1 1888694960 14146864 9198544
21:35:51 70861 8192000000 10832613168 11305951232 1885025616 18.706 99 8 16 0 1902283328 15045808 2211904
21:37:08 109002 8192000000 10853940496 11311833088 1902285600 18.845 99 28 56 1 1917901504 8122368 7493536
21:39:04 58611 8192000000 10866027696 11321364480 1916636912 18.960 99 29 58 0 1935204288 9993808 8573568
21:40:19 12592 8192000000 10826800800 11283099648 1875779984 18.631 97 22 44 0 1889306192 7316432 6209776
21:40:41 36601 8192000000 10858305168 11314180096 1925019872 19.027 100 23 45 2 1940635424 8676400 6939152
21:41:25 78869 8192000000 10832789952 11321458688 1887427680 18.725 98 11 22 0 1903704048 12625456 3650912
21:42:50 9863 8192000000 10836772368 11327029248 1916401824 18.958 100 2 4 0 1931188144 14373808 412512
21:43:06 25410 8192000000 10852625216 11318972416 1921679872 19.000 100 12 24 0 1939565840 14630208 3255760
21:43:45 90151 8192000000 10856776128 11329269760 1903869344 18.857 98 16 32 3 1922245200 13481168 4894688
21:45:22 66636 8192000000 10850032720 11321585664 1894342432 18.781 98 11 22 0 1906075440 8533264 3199744
21:46:40 48036 8192000000 10842365392 11327877120 1910913232 18.914 99 5 10 0 1921784064 9551920 1318912
21:47:39 72091 8192000000 10852174336 11330822144 1896509840 18.798 98 6 12 0 1907635888 9492336 1633712
21:48:58 82476 8192000000 10873460208 11347636224 1906274608 18.877 98 17 34 1 1925431952 14067520 5089824
21:50:27 43337 8192000000 10879914448 11335708672 1890898192 18.753 97 23 46 1 1909648800 12282128 6468480
21:51:20 61323 8192000000 10856077664 11327090688 1899567616 18.823 98 26 52 0 1921847568 14982624 7297328
21:52:37 79652 8192000000 10873707280 11350372352 1943655392 19.176 100 11 22 1 1959895248 12278672 3961184
21:54:09 57589 8192000000 10897064224 11346944000 1930506288 19.071 99 23 46 2 1949215440 12409664 6299488
21:55:13 40579 8192000000 10885007264 11354779648 1936520160 19.119 99 39 78 3 1963227264 15715024 10992080
21:56:17 59566 8192000000 10904455168 11360780288 1961439328 19.317 100 28 56 0 1981400768 12447504 7513936
21:57:22 32849 8192000000 10903244784 11367174144 1963019232 19.330 100 25 50 1 1983518224 13864080 6634912
21:58:14 52334 8192000000 10895264048 11365851136 1900366608 18.829 96 27 54 4 1925189472 17546752 7276112
21:59:13 55710 8192000000 10914176048 11389960192 1980504976 19.469 100 18 36 2 2002116624 16926800 4684848
22:00:15 70737 8192000000 10869328576 11348664320 1870481488 18.588 95 9 18 0 1887385856 14421840 2482528
22:01:39 113886 8192000000 10875523376 11357392896 1939180864 19.140 99 22 44 1 1961319072 16265264 5872944
22:03:41 46737 8192000000 10845271328 11335127040 1911807824 18.921 98 6 12 0 1925472016 12367792 1296400
22:04:41 13132 8192000000 10847631360 11337338880 1930444944 19.070 100 3 6 0 1943412400 12111680 855776
22:05:00 14486 8192000000 10859410848 11336331264 1933575200 19.095 100 3 6 0 1946143984 11908880 659904
22:05:23 52370 8192000000 10878347328 11355045888 1961743568 19.320 100 17 34 2 1972119008 5903808 4471632
22:06:22 91788 8192000000 10907493376 11390291968 1978273856 19.451 100 11 22 1 1991692128 10189312 3228960
22:08:36 60824 8192000000 10910234080 11387215872 1962257360 19.324 99 19 37 1 1981854352 14315744 5281248
22:09:48 59724 8192000000 10879897296 11364175872 1952673552 19.248 99 3 6 0 1966241440 12843040 724848
22:11:00 29324 8192000000 10906685872 11368022016 1935396192 19.110 98 31 62 2 1958316960 14478464 8442304
22:11:36 69659 8192000000 10886344064 11364769792 1956611440 19.279 99 18 36 0 1974773264 12821712 5340112
22:12:52 81027 8192000000 10887375584 11355836416 1895268960 18.788 96 16 32 1 1912096496 12153056 4674480
22:14:54 61376 8192000000 10872302752 11344216064 1876466800 18.637 95 16 32 0 1890696736 9629728 4600208
22:16:32 27589 8192000000 10894830944 11360964608 1953926624 19.258 100 29 58 0 1974274560 12219296 8128640
22:17:11 31040 8192000000 10886944624 11347689472 1924652064 19.024 98 37 74 2 1947371584 12353392 10366128
22:18:28 38083 8192000000 10893981136 11349544960 1918779696 18.977 98 33 66 0 1938520416 10841680 8899040
22:19:26 13724 8192000000 10898596192 11345231872 1936414768 19.118 99 50 101 1 1961653632 11413808 13825056
22:19:50 10715 8192000000 10890692080 11329409024 1887477408 18.725 97 51 101 0 1913077744 11781888 13818448
22:20:08 8124 8192000000 10882669264 11318435840 1918638864 18.976 99 58 116 3 1949252768 14065040 16548864
22:20:23 6940 8192000000 10895572240 11328745472 1936084384 19.115 100 65 126 1 1967798624 14002368 17711872
22:20:45 56462 8192000000 10869993104 11335315456 1900138736 18.827 98 46 92 0 1928819504 15828240 12852528
22:21:53 140310 8192000000 10843330224 11305226240 1841957104 18.357 95 13 26 0 1856288944 10464960 3866880
22:24:20 62238 8192000000 10815957616 11289550848 1885333376 18.708 98 23 46 0 1899316960 7420704 6562880
22:25:56 58638 8192000000 10825849328 11303129088 1896982784 18.802 99 7 14 0 1908777392 9761392 2033216

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 25-12-2020 22:29:59 to 25-12-2020 22:30:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-12-2020 22:30:32 to 25-12-2020 22:30:34.

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          243751
MON$OLDEST_ACTIVE               243752
MON$OLDEST_SNAPSHOT             243752
MON$NEXT_TRANSACTION            243752
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                       2047968
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 ---
:380: 
:381: mscs-test-161.budzdorov.ru    Fri Dec 25 22:27:47 2020
:382:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:383: 
:384: 
:385: mscs-test-161.budzdorov.ru    Fri Dec 25 22:27:47 2020
:386:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:387: 
:388: 
:389: mscs-test-161.budzdorov.ru    Fri Dec 25 22:27:55 2020
:390:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:391: 
--- end of diff output ---

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

25.12.20 22:30:35. 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-25 22:30:37 No severe PSQL-related problems occured
25.12.20 22:30:38. End of report.