Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.01.2021 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 17286760 kB
MemAvailable 31381292 kB
Buffers 0 kB
Cached 14369092 kB
SwapCached 4864 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 2021-01-02 16:27:11
DTS_END                         2021-01-02 16:27:11.6260
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/36376
TRN_ID                          247329
ATT_ID                          714
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: 9245.18 21207 1109422
customer order: creation 174.87 358 20984
customer order: refuse 15.82 330 1898
order to supplier: creation 46.50 1274 5580
order to supplier: removal 3.55 98369 426
invoice (draft): creation 46.52 3439 5582
invoice (draft): removal 52.77 859 6332
invoice accept: apply 41.73 19049 5008
invoice accept: cancel 47.40 793 5688
customer reserve: creation 3844.63 189 461356
customer reserve: removal 4665.68 57 559881
realization accept: apply 87.30 175 10476
realization accept: cancel 84.53 102 10144
payment from customer: creation 60.50 120 7260
payment from customer: removal 6.22 63 746
payment to supplier: creation 50.93 123 6111
payment to supplier: removal 3.36 73 403
service: total inventory turnovers 4.83 1136 580
service: total monetary turnovers 7.26 27 871
service: aggregate perf. data 0.77 22970 92
service: refresh index statistics 0.03 274635 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-01-2021 16:27:56 to 02-01-2021 16:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3050
TEST_TIME 2 3353
TEST_TIME 3 4498
TEST_TIME 4 5010
TEST_TIME 5 5828
TEST_TIME 6 5565
TEST_TIME 7 5649
TEST_TIME 8 5648
TEST_TIME 9 6575
TEST_TIME 10 7301
TEST_TIME 11 7246
TEST_TIME 12 7587
TEST_TIME 13 7420
TEST_TIME 14 7523
TEST_TIME 15 7508
TEST_TIME 16 7667
TEST_TIME 17 7570
TEST_TIME 18 7704
TEST_TIME 19 7952
TEST_TIME 20 8127
TEST_TIME 21 8398
TEST_TIME 22 8878
TEST_TIME 23 8853
TEST_TIME 24 8740
TEST_TIME 25 9133
TEST_TIME 26 9096
TEST_TIME 27 9031
TEST_TIME 28 9367
TEST_TIME 29 10010
TEST_TIME 30 10714
TEST_TIME 31 10489
TEST_TIME 32 10637
TEST_TIME 33 10597
TEST_TIME 34 10672
TEST_TIME 35 10748
TEST_TIME 36 10498
TEST_TIME 37 10389
TEST_TIME 38 10182
TEST_TIME 39 10280
TEST_TIME 40 10138
TEST_TIME 41 10005
TEST_TIME 42 9894
TEST_TIME 43 9753
TEST_TIME 44 9773
TEST_TIME 45 9702
TEST_TIME 46 9605
TEST_TIME 47 9526
TEST_TIME 48 9409
TEST_TIME 49 9487
TEST_TIME 50 9347
TEST_TIME 51 9246
TEST_TIME 52 9251
TEST_TIME 53 9158
TEST_TIME 54 9034
TEST_TIME 55 9007
TEST_TIME 56 8954
TEST_TIME 57 8974
TEST_TIME 58 9004
TEST_TIME 59 8979
TEST_TIME 60 9000
TEST_TIME 61 9139
TEST_TIME 62 9105
TEST_TIME 63 9184
TEST_TIME 64 9209
TEST_TIME 65 9220
TEST_TIME 66 9286
TEST_TIME 67 9254
TEST_TIME 68 9267
TEST_TIME 69 9404
TEST_TIME 70 9396
TEST_TIME 71 9398
TEST_TIME 72 9386
TEST_TIME 73 9317
TEST_TIME 74 9302
TEST_TIME 75 9289
TEST_TIME 76 9228
TEST_TIME 77 9228
TEST_TIME 78 9195
TEST_TIME 79 9146
TEST_TIME 80 9176
TEST_TIME 81 9117
TEST_TIME 82 9076
TEST_TIME 83 9022
TEST_TIME 84 9070
TEST_TIME 85 9132
TEST_TIME 86 9142
TEST_TIME 87 9140
TEST_TIME 88 9117
TEST_TIME 89 9170
TEST_TIME 90 9242
TEST_TIME 91 9233
TEST_TIME 92 9279
TEST_TIME 93 9274
TEST_TIME 94 9295
TEST_TIME 95 9355
TEST_TIME 96 9305
TEST_TIME 97 9312
TEST_TIME 98 9370
TEST_TIME 99 9370
TEST_TIME 100 9314
TEST_TIME 101 9290
TEST_TIME 102 9242
TEST_TIME 103 9228
TEST_TIME 104 9208
TEST_TIME 105 9193
TEST_TIME 106 9159
TEST_TIME 107 9188
TEST_TIME 108 9149
TEST_TIME 109 9146
TEST_TIME 110 9163
TEST_TIME 111 9163
TEST_TIME 112 9176
TEST_TIME 113 9198
TEST_TIME 114 9187
TEST_TIME 115 9227
TEST_TIME 116 9210
TEST_TIME 117 9243
TEST_TIME 118 9220
TEST_TIME 119 9320
TEST_TIME 120 9248

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-01-2021 16:27:59 to 02-01-2021 16:28:03.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1535952 1535952 0 0.00 0 13273 7 0 0
doc_list_biud 1535940 1535940 0 0.00 0 70024 27 0 0
sp_add_invoice_to_stock 5155 5008 147 2.85 32 207817 19049 0 147
sp_cancel_adding_invoice 5688 5688 0 0.00 5 69170 794 0 0
sp_cancel_client_order 1898 1898 0 0.00 4 23061 331 0 0
sp_cancel_customer_reserve 559881 559881 0 0.00 1 70027 58 0 0
sp_cancel_pay_from_customer 746 746 0 0.00 3 1909 64 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 2 3810 74 0 0
sp_cancel_supplier_invoice 6342 6332 10 0.15 1 14873 860 0 10
sp_cancel_supplier_order 426 426 0 0.00 8 850415 98370 0 0
sp_cancel_write_off 10144 10144 0 0.00 1 7461 103 0 0
sp_client_order 20984 20984 0 0.00 4 22551 358 0 0
sp_customer_reserve 461356 461356 0 0.00 0 68271 190 0 0
sp_fill_shopping_cart 32141 32141 0 0.00 1 28252 42 0 0
sp_fill_shopping_cart_clo_res 461356 461356 0 0.00 0 26397 13 0 0
sp_get_clo_for_invoice 5004 5004 0 0.00 0 26841 352 0 0
sp_kill_cost_storno 16981 16981 0 0.00 0 12042 55 0 0
sp_kill_qstorno_ret_qs2qd 1136664 1136664 0 0.00 0 70020 32 0 0
sp_kill_qty_storno 599841 599841 0 0.00 0 70024 69 0 0
sp_lock_selected_doc 21515 21515 0 0.00 0 9200 4 0 0
sp_make_cost_storno 28851 28851 0 0.00 0 11280 52 0 0
sp_multiply_rows_for_pdistr 28839 28839 0 0.00 0 7835 30 0 0
sp_multiply_rows_for_qdistr 20984 20984 0 0.00 0 22541 149 0 0
sp_pay_from_customer 7260 7260 0 0.00 4 12813 121 0 0
sp_pay_to_supplier 6111 6111 0 0.00 5 17182 124 0 0
sp_payment_common 13367 13367 0 0.00 1 10313 26 0 0
sp_qd_handle_on_cancel_clo 1898 1898 0 0.00 0 22887 300 0 0
sp_qd_handle_on_invoice_upd_sts 10685 10685 0 0.00 0 25972 342 0 0
sp_qd_handle_on_reserve_upd_sts 10475 10475 0 0.00 0 14834 59 0 0
sp_reserve_write_off 10476 10476 0 0.00 6 16210 176 0 0
sp_supplier_invoice 5582 5582 0 0.00 5 92495 3440 0 0
sp_supplier_order 5580 5580 0 0.00 5 33684 1274 0 0
srv_aggregate_perf_data 92 92 0 0.00 2069 252047 22970 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 1221 133242 30358 0 0
srv_find_qd_qs_mism 1060633 1060633 0 0.00 0 13273 6 0 0
srv_make_invnt_saldo 580 580 0 0.00 29 48299 1137 0 0
srv_make_money_saldo 871 871 0 0.00 1 2362 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 196942 406563 274636 0 0
t$perf-abend:sp_add_invoice_to_stock 147 147 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5008 5008 0 0.00 0 9965 165 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 0 12761 127 0 0
t$perf-norm:sp_cancel_client_order 1898 1898 0 0.00 0 5145 19 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 4760 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 746 746 0 0.00 0 4367 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 2381 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 4300 34 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 26219 1780 0 0
t$perf-norm:sp_cancel_write_off 1011 1011 0 0.00 0 696 5 0 0
t$perf-norm:sp_client_order 20984 20984 0 0.00 0 11804 23 0 0
t$perf-norm:sp_customer_reserve 948 948 0 0.00 0 6893 17 0 0
t$perf-norm:sp_pay_from_customer 7260 7260 0 0.00 0 6120 10 0 0
t$perf-norm:sp_pay_to_supplier 6111 6111 0 0.00 0 5706 12 0 0
t$perf-norm:sp_reserve_write_off 10476 10476 0 0.00 0 9401 14 0 0
t$perf-norm:sp_supplier_invoice 5582 5582 0 0.00 0 8067 21 0 0
t$perf-norm:sp_supplier_order 5580 5580 0 0.00 0 5057 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 265 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 265 6 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 4533 32 0 0
t$perf-norm:srv_make_money_saldo 871 871 0 0.00 0 2943 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10288 9994 294 2.85 0 6413 18 0 294
v_all_customers 37724 37724 0 0.00 0 15 1 0 0
v_all_suppliers 31144 31144 0 0.00 0 23 1 0 0
v_all_wares 41968 41968 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 5948 12 0 0
v_cancel_client_order 3796 3796 0 0.00 0 6852 7 0 0
v_cancel_customer_prepayment 1492 1492 0 0.00 0 1570 4 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 4250 13 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 3805 10 0 0
v_cancel_supplier_invoice 832 812 20 2.40 0 302 13 0 20
v_cancel_supplier_order 852 852 0 0.00 0 1871 6 0 0
v_cancel_write_off 2022 2022 0 0.00 0 4559 18 0 0
v_max_id_clo_ord 5576 5576 0 0.00 0 2686 2 0 0
v_max_id_clo_res 948 948 0 0.00 0 17142 47 0 0
v_max_id_ord_sup 5581 5581 0 0.00 0 4036 3 0 0
v_max_non_paid_invoice 1688 1688 0 0.00 0 268 2 0 0
v_max_non_paid_realizn 4065 4065 0 0.00 0 6547 5 0 0
v_min_id_clo_ord 5576 5576 0 0.00 0 1230 5 0 0
v_min_id_clo_res 948 948 0 0.00 0 5611 16 0 0
v_min_id_ord_sup 5581 5581 0 0.00 0 6745 11 0 0
v_min_non_paid_invoice 6107 6107 0 0.00 0 10306 20 0 0
v_min_non_paid_realizn 7260 7260 0 0.00 0 5204 14 0 0
v_our_firm 10634 10634 0 0.00 0 16 1 0 0
v_reserve_write_off 20950 20950 0 0.00 0 5906 8 0 0
x_lock_depdocs_on_canc_invoice 11614 11614 0 0.00 0 13003 119 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 21592 391 0 0
x_make_qstorno_1000_1200 5580 5580 0 0.00 1 33666 1195 0 0
x_make_qstorno_1200_2000 5582 5582 0 0.00 2 92477 3281 0 0
x_make_qstorno_2100_3300 461356 461356 0 0.00 0 68269 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-01-2021 16:28:04 to 02-01-2021 16:28:08.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:21 21555 8192000000 10239083520 10552107008 874526704 9.645 68 54 107 0 895280368 2596928 18156736
13:57:50 43162 8192000000 10377812128 10700517376 1408761168 14.673 100 84 169 0 1440425520 4842704 26821648
13:58:40 25569 8192000000 10410338544 10736885760 1458318224 15.111 100 87 173 0 1492812560 6567856 27926480
13:59:18 29663 8192000000 10433379632 10765082624 1488296464 15.374 100 88 176 0 1523502912 7320304 27886144
14:00:00 30209 8192000000 10474701504 10810236928 1516931808 15.624 100 93 186 0 1554467536 8170048 29365680
14:00:48 21205 8192000000 10490195632 10830241792 1546109488 15.876 100 86 172 0 1581946240 9118944 26717808
14:01:17 18224 8192000000 10507207584 10850906112 1557196464 15.972 100 85 170 0 1592934064 9455040 26282560
14:01:46 16026 8192000000 10525266080 10874789888 1584017168 16.203 100 81 162 1 1618592352 10150816 24424368
14:02:08 13646 8192000000 10544098512 10894487552 1602649408 16.362 100 83 165 1 1637448016 9910048 24888560
14:02:28 18648 8192000000 10568308608 10931683328 1629458528 16.590 100 77 154 1 1662899408 9904032 23536848
14:02:55 10730 8192000000 10589695440 10952347648 1649527744 16.760 100 68 136 1 1679462048 9862560 20071744
14:03:15 12003 8192000000 10621092816 10988654592 1684579136 17.056 100 81 161 1 1719427856 11642960 23205760
14:03:34 9590 8192000000 10635246080 11005235200 1697872480 17.167 100 82 164 0 1733193104 12150192 23170432
14:03:53 8411 8192000000 10648320816 11018465280 1711348496 17.280 100 86 172 0 1749528304 13136224 25043584
14:04:12 7674 8192000000 10668508448 11042160640 1726614960 17.407 100 78 156 1 1761497824 12945744 21937120
14:04:29 6653 8192000000 10677483360 11055017984 1741168208 17.528 100 74 146 1 1773713456 12058928 20486320
14:04:43 5435 8192000000 10683547408 11061944320 1748885472 17.592 100 68 135 1 1780060720 12533328 18641920
14:04:56 5588 8192000000 10698385600 11079938048 1764374640 17.721 100 71 140 1 1797091280 12462896 20253744
14:05:10 4908 8192000000 10720245936 11096649728 1775884736 17.816 100 85 170 1 1813053648 13867280 23301632
14:05:23 9165 8192000000 10714814368 11098210304 1783408176 17.878 100 81 162 1 1820751216 14820448 22522592
14:05:42 5701 8192000000 10723296224 11106566144 1787659216 17.913 100 74 148 2 1821451536 13674192 20118128
14:05:54 2709 8192000000 10738926768 11123785728 1800791312 18.020 100 73 146 0 1835085984 14017168 20277504
14:06:06 3147 8192000000 10761588880 11142193152 1814256224 18.131 100 79 158 2 1849383424 12572288 22554912
14:06:16 3821 8192000000 10762181392 11144531968 1818455616 18.165 100 81 161 0 1853475760 12832192 22187952
14:06:27 3502 8192000000 10765590592 11149250560 1824916912 18.218 100 83 166 0 1861898464 13693200 23288352
14:06:37 2421 8192000000 10776640368 11156832256 1828842512 18.250 100 86 171 1 1866336624 12691264 24802848
14:06:46 2624 8192000000 10775867520 11158093824 1835675216 18.306 100 87 174 2 1873000976 13477520 23848240
14:06:55 2519 8192000000 10776362176 11160670208 1834664640 18.297 100 88 175 0 1873809328 14684608 24460080
14:07:04 1974 8192000000 10783723536 11166613504 1839645824 18.338 100 90 180 1 1878576432 13416320 25514288
14:07:13 1673 8192000000 10792500080 11175710720 1849325568 18.417 100 92 186 1 1887371728 12681712 25364448
14:07:21 1873 8192000000 10792754368 11178622976 1846328032 18.392 100 88 175 1 1883565600 12723824 24513744
14:07:29 3365 8192000000 10794087776 11180625920 1853839424 18.453 100 92 185 0 1892915984 13358224 25718336
14:07:39 1640 8192000000 10799684000 11184447488 1856368240 18.474 100 95 191 1 1896670000 13839104 26462656
14:07:47 1636 8192000000 10805142704 11192107008 1855230048 18.465 100 88 173 1 1893391552 13888176 24273328
14:07:55 1498 8192000000 10801698032 11188740096 1856713328 18.477 100 85 170 1 1893015104 12096432 24205344
14:08:02 15120 8192000000 10795620416 11188678656 1856813616 18.477 100 54 108 0 1880226272 8289472 15123184
14:08:23 14638 8192000000 10793352816 11195678720 1861069744 18.512 100 62 124 0 1888136512 10611440 16455328
14:08:47 1267 8192000000 10810337408 11199574016 1867750800 18.566 100 93 189 2 1906528176 11875600 26901776
14:08:55 20633 8192000000 10795913536 11196076032 1863206864 18.529 100 44 86 0 1882871168 7033984 12630320
14:09:22 6627 8192000000 10780996160 11199619072 1868529440 18.572 100 38 76 2 1887342032 8051696 10760896
14:09:36 5730 8192000000 10787516448 11203735552 1870642864 18.589 100 41 82 1 1891077680 7693360 12741456
14:09:49 5087 8192000000 10793397184 11209220096 1874062416 18.617 100 33 66 0 1892261168 9153808 9044944
14:10:00 8296 8192000000 10783192304 11208335360 1873387744 18.612 100 28 56 0 1888844640 7825584 7631312
14:10:16 4007 8192000000 10796419904 11217948672 1880467632 18.669 100 45 90 1 1902349648 9411552 12470464
14:10:26 5321 8192000000 10792623520 11215028224 1880712144 18.671 100 33 67 0 1898707712 7442448 10553120
14:10:38 7366 8192000000 10794618912 11218386944 1879558560 18.662 100 21 42 0 1891894576 6826400 5509616
14:10:53 4963 8192000000 10788534528 11214315520 1880020272 18.665 100 23 46 1 1892867408 6131824 6715312
14:11:07 12471 8192000000 10782741536 11214012416 1881043440 18.674 100 21 42 1 1892658432 5883296 5731696
14:11:29 6035 8192000000 10787495360 11217252352 1882054928 18.682 100 24 46 4 1894800304 5647056 7098320
14:11:41 11548 8192000000 10784068032 11216003072 1881410000 18.676 100 14 29 0 1890781616 5548816 3822800
14:11:59 10481 8192000000 10797928608 11228397568 1884903168 18.705 100 11 22 0 1897948272 9734528 3310576
14:12:16 7656 8192000000 10796750672 11228139520 1888602960 18.735 100 17 34 0 1898677760 5190464 4884336
14:12:34 67876 8192000000 10799871232 11238518784 1892149328 18.763 100 21 40 0 1903075664 5350064 5576272
14:13:48 14618 8192000000 10802862848 11244912640 1892878080 18.769 100 22 46 2 1909510640 10469968 6162592
14:14:12 6552 8192000000 10808869440 11242958848 1897195984 18.804 100 37 76 2 1915217904 7223296 10798624
14:14:26 4352 8192000000 10817514864 11244900352 1896735344 18.800 100 35 70 1 1914476752 8064368 9677040
14:14:37 6861 8192000000 10821786032 11249627136 1900036720 18.827 100 30 60 0 1916310112 7803312 8470080
14:14:54 6767 8192000000 10817848224 11243716608 1897573088 18.807 100 28 56 0 1916296336 10848384 7874864
14:15:08 5290 8192000000 10805097072 11236667392 1880322096 18.668 99 29 58 0 1895430336 6849936 8258304
14:15:22 11729 8192000000 10805840096 11237613568 1877456096 18.645 99 21 42 1 1889899616 6446752 5996768
14:15:42 5892 8192000000 10814399120 11241545728 1892540416 18.766 100 27 53 2 1906098224 6208128 7349680
14:15:56 8374 8192000000 10818655280 11249160192 1897370640 18.805 100 29 58 1 1911235696 5768880 8096176
14:16:13 6035 8192000000 10806366544 11240349696 1893399824 18.773 100 23 46 1 1906192240 6144736 6647680
14:16:25 12920 8192000000 10816497040 11248508928 1877813984 18.647 99 25 48 5 1889651312 4896336 6940992
14:16:44 10580 8192000000 10780283616 11209744384 1840448704 18.344 97 28 56 1 1855560848 7418848 7693296
14:17:01 8919 8192000000 10743553184 11172278272 1771218960 17.777 95 19 37 1 1782263968 5250672 5794336
14:17:16 15381 8192000000 10766329728 11172655104 1759742016 17.682 95 29 58 0 1774071120 5377024 8952080
14:18:17 29424 8192000000 10726884736 11152916480 1728112384 17.420 94 29 57 1 1742162128 5112992 8936752
14:18:52 5506 8192000000 10709308160 11129585664 1750334592 17.604 96 22 44 2 1761784160 4759872 6689696
14:19:05 11078 8192000000 10732088560 11154403328 1734262240 17.471 95 21 41 3 1749591056 9286864 6041952
14:19:22 6254 8192000000 10722137184 11129991168 1766940224 17.742 98 27 54 2 1780763968 5894320 7929424
14:19:36 8048 8192000000 10707097968 11127033856 1748244208 17.587 97 19 38 1 1759727392 5350976 6132208
14:19:51 10673 8192000000 10702695136 11111596032 1721653376 17.366 95 27 54 0 1734306720 4785360 7867984
14:20:08 4740 8192000000 10668590672 11078471680 1697191088 17.162 95 20 41 1 1708330736 5607184 5532464
14:20:23 9069 8192000000 10698434256 11115839488 1763003248 17.709 99 25 50 1 1776296576 6439344 6853984
14:20:38 8159 8192000000 10704998320 11121332224 1778565232 17.838 99 34 68 0 1798986960 10331936 10089792
14:20:52 7524 8192000000 10702382320 11108474880 1704593232 17.224 95 30 60 3 1718864816 5604800 8666784
14:21:08 5620 8192000000 10710459216 11126267904 1794707136 17.970 100 29 55 1 1808452064 5334928 8410000
14:21:22 11309 8192000000 10717977280 11139096576 1774412240 17.803 98 19 38 3 1784638160 5307312 4918608
14:21:40 6097 8192000000 10736511760 11152105472 1811464304 18.108 100 25 49 2 1832504144 14160224 6879616
14:21:53 7630 8192000000 10742259216 11161051136 1822169312 18.195 100 30 57 3 1835659600 5381328 8108960
14:22:09 58416 8192000000 10742776608 11168006144 1830088992 18.260 100 29 58 0 1843801600 5686016 8026592
14:23:16 8373 8192000000 10756979072 11177742336 1838441408 18.328 100 23 44 1 1849765856 5257824 6066624
14:23:31 6727 8192000000 10757230816 11180605440 1839875920 18.340 100 27 54 0 1854031024 6879936 7275168
14:23:46 7161 8192000000 10767691568 11185020928 1843610128 18.370 100 30 60 2 1858856160 7002304 8243728
14:24:00 6507 8192000000 10767967776 11183869952 1830389632 18.263 99 38 76 0 1848476336 7854176 10232528
14:24:14 11091 8192000000 10764969984 11191382016 1847760208 18.404 100 22 42 2 1860130416 6133312 6236896
14:24:33 6602 8192000000 10779060848 11202490368 1860082176 18.504 100 29 59 4 1873358272 5704480 7571616
14:24:50 9013 8192000000 10763547584 11198943232 1859304944 18.498 100 17 34 0 1870129168 5760560 5063664
14:25:05 13463 8192000000 10775838464 11207397376 1863487232 18.532 100 23 44 3 1880865024 9838352 7539440
14:25:28 11232 8192000000 10767549136 11207974912 1865672416 18.549 100 19 38 1 1876406912 5517680 5216816
14:25:47 8437 8192000000 10774730128 11210813440 1867893824 18.567 100 16 32 2 1877986624 5232560 4860240
14:26:03 12205 8192000000 10789907904 11218391040 1872111216 18.601 100 24 48 3 1884512544 5613520 6787808
14:26:24 11327 8192000000 10789988224 11220766720 1874564672 18.621 100 18 36 0 1886245264 6409184 5271408
14:26:44 7120 8192000000 10790593840 11220783104 1875309856 18.627 100 22 44 2 1886713632 5046976 6356800
14:26:59 115717 8192000000 10834201232 11264966656 1905626096 18.872 100 35 68 1 1921574432 5627488 10320848
14:29:09 18283 8192000000 10846869408 11280424960 1925504128 19.031 100 31 61 1 1941517696 7120816 8892752
14:29:41 22147 8192000000 10858880224 11288449024 1930476832 19.071 100 43 83 2 1950834192 8087744 12269616
14:30:11 15019 8192000000 10867786800 11303170048 1940204256 19.148 100 40 80 0 1961104864 9997792 10902816
14:30:33 20996 8192000000 10875438320 11308843008 1946874336 19.202 100 42 84 2 1969699984 10346304 12479344
14:31:03 16753 8192000000 10886351984 11314761728 1953133664 19.251 100 45 90 0 1976424912 10377296 12913952
14:31:28 6548 8192000000 10887143872 11310399488 1946635792 19.200 100 52 102 2 1973414528 12066688 14712048
14:31:41 13119 8192000000 10894231744 11319136256 1947314080 19.205 100 53 107 0 1977751872 14886624 15551168
14:32:03 12384 8192000000 10891572144 11320471552 1953444688 19.254 100 56 112 2 1982201088 13091456 15664944
14:32:27 15823 8192000000 10898143536 11327627264 1956882064 19.281 100 52 104 1 1984966640 12663072 15421504
14:32:56 8649 8192000000 10902135424 11331162112 1965018704 19.346 100 54 106 4 1991704352 10883504 15802144
14:33:13 16538 8192000000 10889405264 11319611392 1956542368 19.279 100 49 97 1 1980693216 10012688 14138160
14:33:37 9865 8192000000 10913656992 11339165696 1966442112 19.357 100 52 103 2 1995094560 13699808 14952640
14:33:56 27667 8192000000 10926997344 11351662592 1974832704 19.424 100 54 108 1 2006261440 15680528 15748208
14:34:30 8120 8192000000 10919569472 11353923584 1980333776 19.467 100 55 110 0 2015669696 19355696 15980224
14:34:54 4659 8192000000 10921750112 11356205056 1979341040 19.459 100 54 108 1 2013241056 17717872 16182144
14:35:07 9935 8192000000 10928906608 11359178752 1985109568 19.505 100 56 112 1 2020310704 18421040 16780096
14:35:29 6851 8192000000 10927668480 11362914304 1986788656 19.518 100 60 119 0 2023736480 19507808 17440016
14:35:44 11486 8192000000 10923341808 11357888512 1978611984 19.454 100 53 106 1 2016601776 22627168 15362624
14:36:05 3424 8192000000 10946297568 11365687296 1981599808 19.477 100 68 134 1 2028076368 25319968 21156592
14:36:18 4023 8192000000 10941370656 11368091648 1988469152 19.532 100 65 126 1 2030922448 23758352 18694944
14:36:29 2179 8192000000 10949545120 11370393600 1988560288 19.532 100 79 151 2 2037069568 25863344 22645936
14:36:40 10623 8192000000 10944937632 11369046016 1985329472 19.507 100 64 128 0 2030913744 27159072 18425200
14:36:59 4434 8192000000 10960863200 11381702656 1997229104 19.601 100 87 167 1 2047692032 27432800 23030128
14:37:14 3735 8192000000 10948451296 11368243200 1973606016 19.414 99 70 140 2 2024083728 29800688 20677024
14:37:25 3089 8192000000 10945832928 11359469568 1940835040 19.153 97 82 163 2 1996386016 32192880 23358096
14:37:36 1909 8192000000 10947602560 11357368320 1966827472 19.360 99 87 172 0 2020544976 29390800 24326704
14:37:49 4832 8192000000 10932368304 11360788480 1978769760 19.455 100 65 128 1 2024330688 27116160 18444768
14:38:05 5035 8192000000 10925757520 11360665600 1956336624 19.277 99 54 108 1 1999929264 27952496 15640144
14:38:20 16530 8192000000 10924158224 11362066432 1976875968 19.440 100 51 102 3 2017421232 24752496 15792768
14:38:58 2522 8192000000 10936021616 11361112064 1972482080 19.405 100 65 129 1 2018022656 26226672 19313904
14:39:08 8496 8192000000 10926127392 11349004288 1938537552 19.135 98 73 143 1 1988158384 28431488 21189344
14:39:26 4734 8192000000 10926121472 11348996096 1953953312 19.258 99 64 127 2 1998670448 25997120 18720016
14:39:39 9164 8192000000 10911263408 11339440128 1958354016 19.293 100 63 123 4 2002679632 25260528 19065088
14:39:58 18526 8192000000 10908749744 11345973248 1946143920 19.196 99 42 82 1 1984375520 24858736 13372864
14:40:26 3846 8192000000 10908763392 11335503872 1943569904 19.175 99 52 104 4 1983778640 24785616 15423120
14:40:40 10795 8192000000 10889867760 11318853632 1930578320 19.072 99 51 102 1 1971254752 25325008 15351424
14:40:58 16901 8192000000 10904440656 11333025792 1934841312 19.106 99 50 99 1 1979947120 29774784 15331024
14:41:21 2837 8192000000 10909706176 11326869504 1932709616 19.089 99 60 121 1 1979412976 28233552 18469808
14:41:31 1968 8192000000 10924507648 11343491072 1959773248 19.304 100 78 156 1 2012963456 29723264 23466944
14:41:41 2975 8192000000 10915533056 11322814464 1931159232 19.076 99 83 164 0 1985503136 29494752 24849152
14:41:51 4022 8192000000 10893854400 11311939584 1926715488 19.041 100 66 127 1 1976152896 30368880 19068528
14:42:09 6755 8192000000 10892557408 11317628928 1918048624 18.971 99 52 104 1 1965801936 31735376 16017936
14:42:25 7463 8192000000 10889402736 11310784512 1913026592 18.931 99 52 104 0 1961567808 32511856 16029360
14:42:40 6900 8192000000 10895194592 11309559808 1909997824 18.907 99 63 126 1 1963347504 34310160 19039520
14:42:55 3124 8192000000 10892648784 11313049600 1923138688 19.012 100 64 127 0 1978103456 35468880 19495888
14:43:06 4340 8192000000 10906169696 11322630144 1933969760 19.099 100 71 143 1 1990173936 34552768 21651408
14:43:19 8227 8192000000 10903708912 11332407296 1940236640 19.149 100 49 98 1 1989134032 33599424 15297968
14:43:43 4706 8192000000 10908354576 11328204800 1923390560 19.014 99 72 144 1 1978148784 33283616 21474608
14:43:55 3250 8192000000 10913704272 11328000000 1922120800 19.004 99 77 152 2 1979543280 34453776 22968704
14:44:06 6075 8192000000 10909522672 11320008704 1921186736 18.996 99 77 154 1 1983989264 38852608 23949920
14:44:20 1220 8192000000 10943012736 11347570688 1954638336 19.263 100 88 172 2 2021151840 40283888 26229616
14:44:29 3871 8192000000 10932116096 11349229568 1953539808 19.255 100 75 149 6 2016815120 40454784 22820528
14:44:40 4903 8192000000 10938990576 11355643904 1954547792 19.263 100 68 136 4 2016853552 40847424 21458336
14:44:55 6173 8192000000 10931386032 11347386368 1923725616 19.017 98 76 151 2 1988906848 41648048 23533184
14:45:09 2076 8192000000 10946686688 11355131904 1950457648 19.230 100 86 172 1 2022037616 45036912 26543056
14:45:19 3328 8192000000 10934197696 11347869696 1937660112 19.128 99 73 145 0 2002444944 42136432 22648400
14:45:33 1510 8192000000 10942267632 11359150080 1960570832 19.311 100 70 140 1 2024689424 42615040 21503552
14:45:43 5310 8192000000 10943426672 11347857408 1950240816 19.228 100 79 155 3 2018368672 43399264 24728592
14:45:55 2903 8192000000 10943165104 11348881408 1949339552 19.221 100 89 175 1 2021780528 44691904 27749072
14:46:04 2153 8192000000 10946620704 11347128320 1947654144 19.208 100 88 176 1 2021326592 46642992 27029456
14:46:14 1522 8192000000 10933268592 11341508608 1940959424 19.154 100 85 170 1 2014204608 46952896 26292288
14:46:22 2829 8192000000 10946533168 11353538560 1949657760 19.224 100 89 175 0 2025529744 47873904 27998080
14:46:33 3865 8192000000 10944617456 11352477696 1950215072 19.228 100 81 163 2 2022940272 47036048 25689152
14:46:45 1695 8192000000 10950628544 11351773184 1950850496 19.233 100 94 187 1 2029202832 48609120 29743216
14:46:54 1512 8192000000 10943851632 11344969728 1950783744 19.233 100 87 175 1 2023416048 44572032 28060272
14:47:03 2865 8192000000 10942223552 11353251840 1952077056 19.243 100 77 153 3 2021286992 44851200 24358736
14:47:15 1984 8192000000 10928094480 11345035264 1916922752 18.962 98 78 157 4 1987674224 45826272 24925200
14:47:24 1933 8192000000 10921931312 11341250560 1939003136 19.139 100 69 138 0 2006872448 45921552 21947760
14:47:38 6284 8192000000 10924662976 11353915392 1946429072 19.198 100 53 106 1 2009310832 45308160 17573600
14:47:51 6445 8192000000 10930689120 11355934720 1948511488 19.215 100 65 131 1 2020936224 51395744 21028992
14:48:10 8992 8192000000 10934434304 11359305728 1949788288 19.225 100 50 98 2 2012739184 46957152 15993744
14:48:29 1655 8192000000 10961568352 11373076480 1964148704 19.339 100 75 150 4 2036584640 48563872 23872064
14:48:38 3066 8192000000 10952832720 11368321024 1961060192 19.314 100 81 163 1 2032138896 45312928 25765776
14:48:49 1415 8192000000 10955196560 11365580800 1964638224 19.343 100 81 160 3 2035467728 45747936 25081568
14:48:56 6139 8192000000 10937919184 11363663872 1959583296 19.303 100 58 116 1 2024236160 46179552 18473312
14:49:18 7659 8192000000 10943773792 11379245056 1969355504 19.380 100 45 90 2 2030025360 45788240 14881616
14:49:33 16062 8192000000 10946522096 11386380288 1976553584 19.437 100 41 82 0 2032293360 42214688 13525088
14:49:55 11395 8192000000 10939555072 11384901632 1974691088 19.423 100 30 60 0 2021911056 37201472 10018496
14:50:16 15208 8192000000 10921838400 11361914880 1950487184 19.230 99 45 90 3 2003043824 37530976 15025664
14:50:56 9622 8192000000 10922576432 11359928320 1954756448 19.264 100 35 70 0 2003036032 37099376 11180208
14:51:14 3737 8192000000 10928180176 11362668544 1956339360 19.277 100 44 88 0 2009182128 38707264 14135504
14:51:24 6093 8192000000 10934866352 11363885056 1958937056 19.298 100 50 100 1 2016142976 40670048 16535872
14:51:57 13907 8192000000 10929887344 11365400576 1957697360 19.288 100 34 66 0 2011060160 42076848 11285952
14:52:18 10921 8192000000 10936698304 11369111552 1946295616 19.197 99 48 96 1 2004749376 43257696 15196064
14:52:36 15317 8192000000 10926302752 11372822528 1956330048 19.277 100 32 65 0 2014216464 47050080 10836336
14:53:11 17086 8192000000 10929448960 11376082944 1963062304 19.330 100 25 51 1 2013010528 41058464 8889760
14:53:45 36159 8192000000 10922634256 11379081216 1966281088 19.356 100 30 60 1 2016380816 39872880 10226848
14:54:34 24682 8192000000 10932116064 11384070144 1956623696 19.279 100 24 48 0 2013457440 47501888 9331856
14:55:09 21910 8192000000 10922569456 11382509568 1931368320 19.078 99 23 46 0 1998522192 58356864 8797008
14:55:42 16116 8192000000 10944178736 11390173184 1948174176 19.212 100 32 65 1 2012732880 53003280 11555424
14:56:07 133240 8192000000 10908906176 11348606976 1915632240 18.952 98 18 37 3 1950777808 29683984 5461584
14:58:27 42584 8192000000 10914140000 11359465472 1959991888 19.306 99 30 59 1 1982621840 14425152 8204800
14:59:19 45718 8192000000 10913325344 11367481344 1969292752 19.380 100 9 18 1 1978772096 7432560 2046784
15:00:11 43737 8192000000 10922521232 11382980608 1980955104 19.472 100 10 20 1 1999340592 15846320 2539168
15:01:04 31352 8192000000 10914361424 11380719616 1951547728 19.239 99 10 20 1 1983937392 29705872 2683792
15:01:44 101505 8192000000 10924902528 11366510592 1939528512 19.143 98 22 44 3 1966061872 20822560 5710800
15:03:35 43280 8192000000 10912571504 11350851584 1957802928 19.289 99 61 122 1 1983649024 8741344 17104752
15:04:28 21880 8192000000 10903134368 11364200448 1971548608 19.398 100 25 50 0 1989712208 10826976 7336624
15:04:56 39180 8192000000 10930244416 11366633472 1982637968 19.486 100 52 97 1 2004691088 7289632 14763488
15:05:47 32414 8192000000 10923725648 11370692608 1982737024 19.486 100 41 82 1 2005356752 10851872 11767856
15:06:26 48863 8192000000 10899869808 11381915648 1982215136 19.482 100 19 39 1 1999254496 11305760 5733600
15:07:21 30100 8192000000 10902108304 11376156672 1982732800 19.486 100 12 23 1 1994285024 8340464 3211760
15:07:57 20379 8192000000 10906944704 11379916800 1991410944 19.555 100 16 32 0 2004081744 8598192 4072608
15:08:46 94699 8192000000 10904215360 11378237440 1987026096 19.520 100 15 30 1 2000083248 8833088 4224064
15:10:32 39502 8192000000 10928930432 11378950144 1975123120 19.426 99 29 58 1 1994962112 11356304 8482688
15:11:22 45186 8192000000 10908779696 11376087040 1970706304 19.391 99 26 52 1 1988828560 10939232 7183024
15:12:19 93764 8192000000 10929053104 11396669440 1998317568 19.609 100 17 34 1 2015218848 11671008 5230272
15:14:02 74193 8192000000 10922716960 11407093760 2001581504 19.635 100 13 26 1 2019251552 13339632 4330416
15:15:23 84984 8192000000 10922524944 11392876544 2001316240 19.633 100 14 28 2 2021564032 16139056 4108736
15:16:54 34088 8192000000 10912412208 11386802176 1983630368 19.493 99 17 35 2 1993603344 5133520 4839456
15:17:53 16132 8192000000 10921880912 11390980096 2002395360 19.642 100 27 54 1 2018215280 8036096 7783824
15:18:36 15710 8192000000 10899021824 11357384704 1942206400 19.164 98 23 46 1 1956150736 7181232 6763104
15:19:00 52532 8192000000 10884576624 11363811328 1944216464 19.180 98 22 44 3 1960449840 10033392 6199984
15:20:10 76410 8192000000 10861822032 11338244096 1856626464 18.476 94 7 14 0 1868206080 9368352 2211264
15:21:40 83830 8192000000 10856970320 11337711616 1901572336 18.839 97 14 28 2 1917241120 11764752 3904032
15:23:22 72842 8192000000 10866260720 11343851520 1916404800 18.958 98 10 20 0 1928136752 8842944 2889008
15:24:48 54981 8192000000 10873499056 11352403968 1945496912 19.191 99 15 30 1 1960802928 11102944 4203072
15:25:51 63258 8192000000 10901085008 11365031936 1949699520 19.224 99 16 32 0 1969542208 14879648 4963040
15:27:08 65129 8192000000 10892949424 11359903744 1916968752 18.963 97 21 42 0 1939178592 16256336 5953504
15:28:24 63255 8192000000 10862247456 11335073792 1862468336 18.523 95 16 32 0 1877539568 10940384 4130848
15:29:34 114227 8192000000 10842339104 11314925568 1823088624 18.203 93 15 30 0 1844169664 16758768 4322272
15:31:38 13838 8192000000 10892794128 11338792960 1926931952 19.042 99 42 84 1 1946621312 7169488 12519872
15:32:03 43157 8192000000 10857815776 11318853632 1846516112 18.394 95 27 54 0 1865228000 11531968 7179920
15:33:01 75100 8192000000 10843989264 11298050048 1828599344 18.248 95 13 26 1 1847180304 14919536 3661424
15:34:24 45102 8192000000 10896733632 11336572928 1904113360 18.859 98 41 82 1 1930289792 13703408 12473024
15:35:18 51138 8192000000 10854107312 11324858368 1903381840 18.853 98 23 46 2 1928888064 18917776 6588448
15:36:25 59126 8192000000 10843763312 11305582592 1857463664 18.483 96 12 24 0 1877941472 17418928 3058880
15:37:31 77127 8192000000 10815092128 11281211392 1782058096 17.866 93 7 14 0 1797431040 13611184 1761760
15:39:11 77427 8192000000 10839952752 11311124480 1914799280 18.945 100 23 46 3 1933810960 12357168 6654512
15:40:50 77834 8192000000 10854644624 11299745792 1828277616 18.245 95 24 47 3 1844845472 8848672 7719184
15:42:14 47814 8192000000 10854991136 11302506496 1887354464 18.724 98 50 99 2 1911706464 9933792 14418208
15:43:14 30902 8192000000 10846939936 11296423936 1896902000 18.801 99 38 76 0 1918463264 11121920 10439344
15:43:51 14131 8192000000 10860561792 11305594880 1921729696 19.001 100 45 91 0 1945249568 11069488 12450384
15:44:18 32986 8192000000 10826000128 11287019520 1876640048 18.638 98 17 34 0 1889090128 7500352 4949728
15:44:59 62176 8192000000 10835453456 11299332096 1892385216 18.765 99 24 47 0 1907358736 8437344 6536176
15:46:08 48207 8192000000 10874801664 11318628352 1924506592 19.023 100 32 63 3 1944169184 9666304 9996288
15:47:03 41624 8192000000 10844975712 11314106368 1911208160 18.916 99 17 34 0 1925205376 8803152 5194064
15:49:21 83969 8192000000 10843162912 11293585408 1889565296 18.742 98 18 36 0 1905925664 11226400 5133968
15:50:53 71045 8192000000 10864068816 11340386304 1934352688 19.102 100 18 36 1 1956487440 16580160 5554592
15:52:11 77075 8192000000 10862635136 11341053952 1920144192 18.988 99 12 23 0 1940124480 16919648 3060640
15:53:39 47384 8192000000 10887011472 11343810560 1928902800 19.058 99 24 46 0 1945160560 9443984 6813776
15:54:33 41980 8192000000 10892987328 11353960448 1956207920 19.276 100 26 52 1 1976291824 12640352 7443552
15:55:21 64580 8192000000 10868511888 11334025216 1899631920 18.823 97 18 36 0 1919391952 14193568 5566464
15:56:32 86575 8192000000 10888268960 11340689408 1928981872 19.059 99 19 38 1 1947631680 12867744 5782064
15:58:16 60096 8192000000 10905669616 11367788544 1962765840 19.328 100 27 54 0 1979159120 9421456 6971824
15:59:23 100355 8192000000 10914300352 11357925376 1916498928 18.959 97 25 50 0 1937423344 14529504 6394912
16:01:15 62712 8192000000 10892185920 11361017856 1941861504 19.162 99 38 77 0 1966977152 13963328 11152320
16:02:25 80110 8192000000 10911397744 11373060096 1956167136 19.276 99 13 26 1 1970063856 10252624 3644096
16:03:52 48459 8192000000 10910636096 11370840064 1946258720 19.197 98 42 84 2 1968393424 10694448 11440256
16:04:48 105512 8192000000 10908992496 11374555136 1917334912 18.965 97 20 40 2 1935783840 12985600 5463328
16:06:43 45726 8192000000 10903195648 11370967040 1953959760 19.258 99 13 26 0 1967466992 10202304 3304928
16:07:35 94091 8192000000 10902957584 11382063104 1975223392 19.427 100 8 16 1 1988546368 10852928 2470048
16:09:36 28784 8192000000 10890890688 11353489408 1950480672 19.230 99 30 60 3 1967670704 7701808 9488224
16:10:11 12385 8192000000 10883096640 11359506432 1965113472 19.347 100 7 14 0 1973948464 6998000 1836992
16:10:30 29607 8192000000 10881705728 11350433792 1928418528 19.054 98 17 34 0 1939871536 6900544 4552464
16:11:09 59396 8192000000 10888850288 11369123840 1950273728 19.229 99 16 32 1 1969566272 14590784 4701760
16:12:16 31451 8192000000 10883396000 11367284736 1961760816 19.320 100 5 10 0 1978675936 15502320 1412800
16:12:53 22320 8192000000 10895356768 11374010368 1964703488 19.343 100 6 12 1 1983128368 16630544 1794336
16:13:22 5933 8192000000 10888362896 11372568576 1964549392 19.342 100 5 10 0 1983105408 17069504 1486512
16:13:34 70099 8192000000 10866866912 11354132480 1906393712 18.878 97 8 17 0 1919736768 11053088 2289968
16:14:59 36717 8192000000 10879887760 11363020800 1953557952 19.255 100 6 12 0 1967573616 12275072 1740592
16:15:49 50243 8192000000 10880262992 11362627584 1933615920 19.096 98 15 30 0 1950702544 12883968 4202656
16:16:46 60988 8192000000 10889931872 11361554432 1942898112 19.170 99 10 20 0 1957681872 12205232 2578528
16:17:53 43844 8192000000 10879018592 11345715200 1888943344 18.737 96 11 22 1 1904671520 12871200 2856976
16:18:51 48960 8192000000 10848745296 11293843456 1802672000 18.036 92 19 38 0 1820334944 12370768 5292176
16:19:47 32009 8192000000 10866667104 11312402432 1890899200 18.753 98 53 104 0 1917507088 11845920 14761968
16:20:28 23466 8192000000 10836834272 11285848064 1861989408 18.519 97 30 59 1 1878620368 8473856 8157104
16:21:03 36000 8192000000 10872813856 11323236352 1909438272 18.902 99 32 64 1 1933352992 14793440 9121280
16:21:45 53869 8192000000 10864246368 11336757248 1897381168 18.805 98 25 50 1 1919083488 14707920 6994400
16:22:49 44347 8192000000 10817741808 11254870016 1758740576 17.674 91 29 56 1 1775327632 8838736 7748320
16:23:40 12116 8192000000 10839100416 11278352384 1896303584 18.797 100 51 100 1 1921070352 10332656 14434112
16:24:04 27849 8192000000 10840670720 11295227904 1908247568 18.893 100 37 74 0 1930963392 12510704 10205120
16:25:31 19388 8192000000 10825903664 11266904064 1810349328 18.099 95 37 74 1 1831330016 10332560 10648128
16:26:22 46729 8192000000 10800315200 11268599808 1812772640 18.119 96 17 34 0 1832767440 15193920 4800880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 02-01-2021 16:28:09 to 02-01-2021 16:28:42.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-01-2021 16:28:43 to 02-01-2021 16:28:45.

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          247789
MON$OLDEST_ACTIVE               247790
MON$OLDEST_SNAPSHOT             247790
MON$NEXT_TRANSACTION            247790
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                       2031392
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:222: 
:223: mscs-test-161.budzdorov.ru    Sat Jan  2 16:27:24 2021
:224:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:225: 
:226: 
:227: mscs-test-161.budzdorov.ru    Sat Jan  2 16:27:26 2021
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:229: 
--- end of diff output ---

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

02.01.21 16:28:46. 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
2021-01-02 16:28:48 No severe PSQL-related problems occured
02.01.21 16:28:50. End of report.