Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.01.2021 19: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 16957620 kB
MemAvailable 31359524 kB
Buffers 0 kB
Cached 14701096 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-09 19:27:09
DTS_END                         2021-01-09 19:27:09.5330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34934
TRN_ID                          249637
ATT_ID                          672
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: 9478.68 19766 1137442
customer order: creation 182.68 315 21922
customer order: refuse 15.28 311 1833
order to supplier: creation 47.72 1182 5726
order to supplier: removal 3.33 104231 400
invoice (draft): creation 47.59 3204 5711
invoice (draft): removal 53.66 739 6439
invoice accept: apply 43.93 17635 5271
invoice accept: cancel 48.37 724 5804
customer reserve: creation 3968.37 178 476204
customer reserve: removal 4754.78 57 570574
realization accept: apply 87.32 174 10478
realization accept: cancel 90.73 109 10888
payment from customer: creation 61.59 139 7391
payment from customer: removal 5.99 71 719
payment to supplier: creation 51.23 149 6148
payment to supplier: removal 3.30 106 396
service: total inventory turnovers 5.01 1110 601
service: total monetary turnovers 6.88 50 826
service: aggregate perf. data 0.89 16954 107
service: refresh index statistics 0.03 247885 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-01-2021 19:28:06 to 09-01-2021 19:28:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2650
TEST_TIME 2 3381
TEST_TIME 3 4049
TEST_TIME 4 3904
TEST_TIME 5 4732
TEST_TIME 6 5258
TEST_TIME 7 5376
TEST_TIME 8 5544
TEST_TIME 9 5525
TEST_TIME 10 6232
TEST_TIME 11 7277
TEST_TIME 12 7254
TEST_TIME 13 7702
TEST_TIME 14 7727
TEST_TIME 15 7571
TEST_TIME 16 7784
TEST_TIME 17 8025
TEST_TIME 18 7905
TEST_TIME 19 7888
TEST_TIME 20 8382
TEST_TIME 21 8574
TEST_TIME 22 8664
TEST_TIME 23 9015
TEST_TIME 24 8965
TEST_TIME 25 9671
TEST_TIME 26 9670
TEST_TIME 27 10549
TEST_TIME 28 11409
TEST_TIME 29 11511
TEST_TIME 30 11197
TEST_TIME 31 11224
TEST_TIME 32 11146
TEST_TIME 33 10965
TEST_TIME 34 10869
TEST_TIME 35 10770
TEST_TIME 36 10605
TEST_TIME 37 10607
TEST_TIME 38 10448
TEST_TIME 39 10307
TEST_TIME 40 10354
TEST_TIME 41 10410
TEST_TIME 42 10349
TEST_TIME 43 10232
TEST_TIME 44 10265
TEST_TIME 45 10399
TEST_TIME 46 10309
TEST_TIME 47 10253
TEST_TIME 48 10273
TEST_TIME 49 10123
TEST_TIME 50 9939
TEST_TIME 51 9973
TEST_TIME 52 10048
TEST_TIME 53 9983
TEST_TIME 54 9972
TEST_TIME 55 9897
TEST_TIME 56 9817
TEST_TIME 57 9866
TEST_TIME 58 9844
TEST_TIME 59 9867
TEST_TIME 60 9772
TEST_TIME 61 9661
TEST_TIME 62 9570
TEST_TIME 63 9644
TEST_TIME 64 9660
TEST_TIME 65 9668
TEST_TIME 66 9677
TEST_TIME 67 9662
TEST_TIME 68 9733
TEST_TIME 69 9685
TEST_TIME 70 9731
TEST_TIME 71 9778
TEST_TIME 72 9768
TEST_TIME 73 9737
TEST_TIME 74 9740
TEST_TIME 75 9743
TEST_TIME 76 9906
TEST_TIME 77 9919
TEST_TIME 78 9877
TEST_TIME 79 9779
TEST_TIME 80 9742
TEST_TIME 81 9764
TEST_TIME 82 9709
TEST_TIME 83 9670
TEST_TIME 84 9683
TEST_TIME 85 9642
TEST_TIME 86 9625
TEST_TIME 87 9592
TEST_TIME 88 9532
TEST_TIME 89 9506
TEST_TIME 90 9544
TEST_TIME 91 9579
TEST_TIME 92 9570
TEST_TIME 93 9640
TEST_TIME 94 9657
TEST_TIME 95 9635
TEST_TIME 96 9647
TEST_TIME 97 9671
TEST_TIME 98 9714
TEST_TIME 99 9716
TEST_TIME 100 9747
TEST_TIME 101 9745
TEST_TIME 102 9790
TEST_TIME 103 9824
TEST_TIME 104 9775
TEST_TIME 105 9706
TEST_TIME 106 9656
TEST_TIME 107 9665
TEST_TIME 108 9632
TEST_TIME 109 9630
TEST_TIME 110 9587
TEST_TIME 111 9556
TEST_TIME 112 9493
TEST_TIME 113 9485
TEST_TIME 114 9508
TEST_TIME 115 9530
TEST_TIME 116 9500
TEST_TIME 117 9491
TEST_TIME 118 9490
TEST_TIME 119 9557
TEST_TIME 120 9483

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-01-2021 19:28:09 to 09-01-2021 19:28:13.

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 1579869 1579869 0 0.00 0 49001 7 0 0
doc_list_biud 1579869 1579869 0 0.00 0 60302 26 0 0
sp_add_invoice_to_stock 5419 5271 148 2.73 30 178500 17635 0 148
sp_cancel_adding_invoice 5804 5804 0 0.00 4 86888 725 0 0
sp_cancel_client_order 1833 1833 0 0.00 4 10535 312 0 0
sp_cancel_customer_reserve 570574 570574 0 0.00 1 60303 57 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 3 4262 71 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 3 7421 106 0 0
sp_cancel_supplier_invoice 6444 6439 5 0.07 1 46144 740 0 5
sp_cancel_supplier_order 400 400 0 0.00 7 1125140 104231 0 0
sp_cancel_write_off 10888 10888 0 0.00 1 24779 110 0 0
sp_client_order 21922 21922 0 0.00 3 15729 315 0 0
sp_customer_reserve 476204 476204 0 0.00 0 61101 179 0 0
sp_fill_shopping_cart 33357 33357 0 0.00 1 16504 39 0 0
sp_fill_shopping_cart_clo_res 476203 476203 0 0.00 0 21519 14 0 0
sp_get_clo_for_invoice 5269 5269 0 0.00 0 33385 289 0 0
sp_kill_cost_storno 17807 17807 0 0.00 0 24728 58 0 0
sp_kill_qstorno_ret_qs2qd 1158875 1158875 0 0.00 0 60297 31 0 0
sp_kill_qty_storno 611685 611685 0 0.00 0 60302 66 0 0
sp_lock_selected_doc 21701 21701 0 0.00 0 12638 6 0 0
sp_make_cost_storno 29286 29286 0 0.00 0 48945 63 0 0
sp_multiply_rows_for_pdistr 29286 29286 0 0.00 0 24627 34 0 0
sp_multiply_rows_for_qdistr 21922 21922 0 0.00 0 13156 130 0 0
sp_pay_from_customer 7391 7391 0 0.00 4 27565 140 0 0
sp_pay_to_supplier 6148 6148 0 0.00 4 24631 150 0 0
sp_payment_common 13539 13539 0 0.00 1 24106 46 0 0
sp_qd_handle_on_cancel_clo 1833 1833 0 0.00 0 10529 289 0 0
sp_qd_handle_on_invoice_upd_sts 11073 11073 0 0.00 0 18162 303 0 0
sp_qd_handle_on_reserve_upd_sts 10478 10478 0 0.00 0 12100 52 0 0
sp_reserve_write_off 10478 10478 0 0.00 6 24539 174 0 0
sp_supplier_invoice 5711 5711 0 0.00 6 80316 3205 0 0
sp_supplier_order 5726 5726 0 0.00 4 24167 1182 0 0
srv_aggregate_perf_data 107 107 0 0.00 2357 257429 16955 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1271 274016 30563 0 0
srv_find_qd_qs_mism 1088451 1088451 0 0.00 0 31504 5 0 0
srv_make_invnt_saldo 601 601 0 0.00 39 116290 1110 0 0
srv_make_money_saldo 826 826 0 0.00 0 19897 50 0 0
srv_recalc_idx_stat 4 4 0 0.00 165356 354855 247886 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5273 5273 0 0.00 0 20836 167 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 4718 94 0 0
t$perf-norm:sp_cancel_client_order 1833 1833 0 0.00 0 2509 10 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 320 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 5330 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 1304 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 432 432 0 0.00 0 1659 18 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 23607 1756 0 0
t$perf-norm:sp_cancel_write_off 1069 1069 0 0.00 0 3962 10 0 0
t$perf-norm:sp_client_order 21922 21922 0 0.00 0 9235 21 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 934 4 0 0
t$perf-norm:sp_pay_from_customer 7391 7391 0 0.00 0 5873 9 0 0
t$perf-norm:sp_pay_to_supplier 6148 6148 0 0.00 0 6166 8 0 0
t$perf-norm:sp_reserve_write_off 10478 10478 0 0.00 0 8677 12 0 0
t$perf-norm:sp_supplier_invoice 5711 5711 0 0.00 0 19706 23 0 0
t$perf-norm:sp_supplier_order 5726 5726 0 0.00 0 3653 18 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 1074 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 1886 21 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 5275 24 0 0
t$perf-norm:srv_make_money_saldo 826 826 0 0.00 0 2598 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 5 0 0
v_add_invoice_to_stock 10834 10538 296 2.73 0 7024 18 0 296
v_all_customers 39980 39980 0 0.00 0 24 1 0 0
v_all_suppliers 31748 31748 0 0.00 0 28 1 0 0
v_all_wares 43844 43844 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 711 7 0 0
v_cancel_client_order 3666 3666 0 0.00 0 2012 5 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 2296 5 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 975 4 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 4537 15 0 0
v_cancel_supplier_invoice 874 864 10 1.14 0 1346 17 0 10
v_cancel_supplier_order 800 800 0 0.00 0 1449 5 0 0
v_cancel_write_off 2138 2138 0 0.00 0 1973 16 0 0
v_max_id_clo_ord 5726 5726 0 0.00 0 1683 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 5337 14 0 0
v_max_id_ord_sup 5709 5709 0 0.00 0 5191 3 0 0
v_max_non_paid_invoice 1709 1709 0 0.00 0 3299 6 0 0
v_max_non_paid_realizn 3877 3877 0 0.00 0 24098 9 0 0
v_min_id_clo_ord 5726 5726 0 0.00 0 6411 11 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 7928 35 0 0
v_min_id_ord_sup 5709 5709 0 0.00 0 13444 12 0 0
v_min_non_paid_invoice 6148 6148 0 0.00 0 16470 33 0 0
v_min_non_paid_realizn 7391 7391 0 0.00 0 15810 28 0 0
v_our_firm 10892 10892 0 0.00 0 19 1 0 0
v_reserve_write_off 20956 20956 0 0.00 0 9629 5 0 0
x_lock_depdocs_on_canc_invoice 11811 11811 0 0.00 0 20613 130 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 34150 464 0 0
x_make_qstorno_1000_1200 5726 5726 0 0.00 1 24063 1099 0 0
x_make_qstorno_1200_2000 5711 5711 0 0.00 3 80307 3068 0 0
x_make_qstorno_2100_3300 476204 476204 0 0.00 0 61096 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-01-2021 19:28:14 to 09-01-2021 19:28:18.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 14750 8192000000 10198948992 10500722688 832915824 9.229 67 53 108 1 853244512 2317376 18011312
16:57:41 21384 8192000000 10312466160 10629115904 1366835824 14.299 100 81 163 0 1397895616 4413136 26646656
16:58:10 19692 8192000000 10351903776 10670452736 1409922288 14.683 100 88 176 1 1444814320 5765968 29126064
16:58:37 43666 8192000000 10398181792 10718543872 1436446832 14.918 100 90 180 0 1473318464 7266000 29605632
16:59:32 18943 8192000000 10407372048 10735341568 1461733760 15.141 100 92 184 0 1499908400 8341936 29832704
17:00:00 18548 8192000000 10425028032 10756083712 1477922032 15.283 100 91 182 1 1515924768 8702800 29299936
17:00:28 32266 8192000000 10452010704 10787282944 1502549296 15.498 100 89 178 0 1540629888 9383648 28696944
17:01:15 15447 8192000000 10493304176 10834321408 1532315904 15.757 100 82 164 2 1567674112 9961792 25396416
17:01:41 11539 8192000000 10514449440 10867109888 1572118816 16.100 100 80 160 0 1606892992 10836496 23937680
17:02:01 12070 8192000000 10556943744 10911928320 1607630128 16.405 100 76 150 0 1640957920 10780864 22546928
17:02:28 9158 8192000000 10575378544 10935255040 1636186160 16.647 100 76 151 3 1670177376 11655344 22335872
17:02:47 9939 8192000000 10594353552 10958315520 1651132544 16.774 100 79 158 0 1686970736 12474128 23364064
17:03:08 9413 8192000000 10601857616 10971365376 1672046256 16.950 100 77 154 0 1707087888 12314480 22727152
17:03:25 11051 8192000000 10629190976 11001823232 1691751712 17.116 100 80 161 2 1727676608 12763152 23161744
17:03:44 7947 8192000000 10646880240 11023618048 1714221104 17.304 100 77 154 3 1749414608 12979184 22214320
17:04:00 6956 8192000000 10672957696 11044671488 1728979840 17.427 100 82 164 4 1765889856 13563792 23346224
17:04:15 7383 8192000000 10674523264 11054817280 1741396096 17.530 100 83 166 0 1778948256 13989056 23563104
17:04:31 7542 8192000000 10692140608 11072139264 1749675232 17.599 100 81 160 2 1786627040 13961872 22989936
17:04:46 6882 8192000000 10700296432 11079401472 1762430432 17.704 100 85 168 0 1800187872 14030656 23726784
17:05:01 3591 8192000000 10710480048 11089510400 1770478304 17.771 100 84 169 0 1807073584 13317200 23278080
17:05:13 2968 8192000000 10721549536 11101773824 1773879184 17.799 100 84 168 0 1810986528 13201744 23905600
17:05:23 2952 8192000000 10716834448 11100807168 1783466208 17.878 100 83 167 0 1819317792 11848224 24003360
17:05:34 4769 8192000000 10732062736 11116756992 1798371008 18.001 100 84 169 2 1833759632 11596480 23792144
17:05:45 2070 8192000000 10740307120 11123118080 1806791296 18.070 100 81 159 1 1839560592 11090512 21678784
17:05:54 3424 8192000000 10748610016 11133861888 1809059600 18.088 100 71 140 1 1840180752 11742832 19378320
17:06:04 10241 8192000000 10750228464 11140390912 1819002240 18.170 100 84 164 1 1854434784 12740704 22691840
17:06:22 4586 8192000000 10761308160 11146133504 1820514368 18.182 100 80 161 1 1855934416 13338224 22081824
17:06:34 2321 8192000000 10774338960 11158138880 1835294096 18.302 100 84 168 0 1871398560 12773408 23331056
17:06:43 1601 8192000000 10776061104 11165577216 1839362272 18.336 100 87 174 0 1876744208 12887808 24494128
17:06:51 2337 8192000000 10787332688 11175514112 1843334384 18.368 100 93 187 0 1882961312 13705600 25921328
17:06:59 1653 8192000000 10799916544 11184205824 1850462176 18.426 100 93 186 0 1890484352 13821120 26201056
17:07:08 1839 8192000000 10794534048 11181260800 1852942752 18.446 100 94 187 1 1892479936 13878320 25658864
17:07:16 2007 8192000000 10798275200 11186765824 1854007312 18.455 100 87 174 3 1891361792 13422448 23932032
17:07:25 1293 8192000000 10804416368 11189841920 1859913760 18.503 100 91 184 0 1898912560 13523152 25475648
17:07:33 2125 8192000000 10798218160 11195383808 1860731328 18.509 100 83 166 2 1896659600 12411152 23517120
17:07:41 1617 8192000000 10808513856 11194859520 1863872192 18.535 100 93 185 2 1903253392 12960400 26420800
17:07:49 15560 8192000000 10786225600 11191087104 1859338304 18.498 100 67 132 1 1888403520 10437264 18627952
17:08:11 13404 8192000000 10815555456 11209637888 1872772032 18.607 100 80 159 2 1906614544 11533456 22309056
17:08:31 27710 8192000000 10775357200 11201765376 1871830432 18.599 100 45 90 0 1894908704 10759136 12319136
17:09:05 11681 8192000000 10776141440 11207774208 1870614480 18.589 100 20 40 0 1882170992 5705168 5851344
17:09:24 4443 8192000000 10791552304 11214131200 1878462912 18.653 100 36 72 1 1896966400 8598192 9905296
17:09:36 11195 8192000000 10794371936 11217752064 1878047600 18.649 100 27 52 3 1896661392 11073968 7539824
17:09:57 6397 8192000000 10794035648 11223244800 1883427392 18.693 100 31 61 2 1898997040 7507456 8062192
17:10:10 7643 8192000000 10796958032 11219996672 1883285472 18.692 100 23 45 1 1896224640 6842944 6096224
17:10:24 4744 8192000000 10800964560 11227422720 1886979888 18.721 100 34 68 0 1904419664 8183232 9256544
17:10:38 9659 8192000000 10790105232 11223031808 1888125888 18.731 100 24 48 3 1900705840 5433152 7146800
17:10:54 11936 8192000000 10797250560 11227570176 1889867824 18.745 100 23 45 1 1905416208 9366032 6182352
17:11:13 8134 8192000000 10791437360 11226972160 1887154128 18.723 100 18 34 3 1902717184 10434880 5128176
17:11:28 15754 8192000000 10801079120 11234263040 1889362080 18.741 100 20 40 0 1901238112 5770048 6105984
17:11:54 9054 8192000000 10801360560 11236868096 1898805440 18.817 100 18 36 1 1910110080 6438496 4866144
17:12:11 18233 8192000000 10822178608 11250253824 1902610848 18.847 100 24 47 2 1915395552 5453152 7331552
17:13:06 40553 8192000000 10827772176 11259879424 1909439056 18.902 100 46 92 0 1928855056 6254864 13161136
17:13:56 9194 8192000000 10808387744 11253223424 1905506960 18.871 100 24 48 3 1918803120 5954464 7341696
17:14:11 4434 8192000000 10824917648 11254308864 1905367712 18.869 100 23 46 0 1917469536 5115152 6986672
17:14:22 6283 8192000000 10822992928 11257241600 1906798624 18.881 100 30 60 0 1922791152 7393136 8599392
17:14:38 5303 8192000000 10822156272 11257675776 1907778752 18.889 100 30 58 3 1922812064 6940464 8092848
17:14:50 5643 8192000000 10826008656 11259170816 1911001264 18.915 100 42 84 0 1930185936 7042016 12142656
17:15:03 6440 8192000000 10821435456 11255476224 1908683776 18.896 100 21 42 1 1920349312 5409056 6256480
17:15:18 7706 8192000000 10798583472 11239960576 1869798960 18.583 98 26 52 3 1882986976 6184256 7003760
17:15:32 7979 8192000000 10815823568 11249700864 1900511984 18.830 100 23 46 0 1912716096 5734272 6469840
17:15:48 16243 8192000000 10811328560 11251019776 1882719536 18.687 99 18 36 3 1893468688 5401936 5347216
17:16:11 7468 8192000000 10809080928 11247972352 1897595472 18.807 100 27 54 3 1911842304 6788560 7458272
17:16:25 11939 8192000000 10794105072 11225788416 1848096288 18.407 98 12 24 1 1856401680 5418400 2886992
17:16:43 5932 8192000000 10793852624 11228405760 1878833168 18.656 100 14 28 0 1891960992 9903536 3224288
17:16:55 7621 8192000000 10780523632 11210801152 1842876656 18.364 98 22 44 2 1854669888 5516848 6276384
17:17:09 29251 8192000000 10757236064 11181187072 1764056368 17.718 94 11 20 1 1771625568 4859392 2709808
17:18:00 37325 8192000000 10752617040 11188895744 1795914064 17.980 96 37 72 2 1812665040 5667184 11083792
17:18:44 10581 8192000000 10773086416 11201007616 1836816048 18.315 99 28 56 1 1850235392 5926192 7493152
17:19:04 5294 8192000000 10724497328 11132551168 1740481136 17.523 95 39 78 0 1759047040 7173184 11392720
17:19:16 4507 8192000000 10713662784 11131740160 1781712096 17.864 98 29 57 3 1795956400 5404144 8840160
17:19:33 6058 8192000000 10697633568 11110260736 1713286544 17.296 95 27 54 0 1727507424 6029872 8191008
17:19:45 7012 8192000000 10712430208 11129446400 1749110304 17.594 97 27 53 1 1762256352 6296752 6849296
17:19:59 4496 8192000000 10713667760 11118104576 1743226304 17.545 97 28 56 0 1756961008 5786752 7947952
17:20:11 5509 8192000000 10694091728 11110608896 1780083440 17.850 100 20 40 2 1791498656 5825136 5590080
17:20:23 9503 8192000000 10673767760 11082534912 1686084672 17.068 94 26 50 0 1703666576 10136800 7445104
17:20:45 6167 8192000000 10693825424 11115372544 1785932848 17.898 99 27 52 1 1800037648 6312256 7792544
17:21:01 7201 8192000000 10711876848 11121954816 1766502928 17.738 98 38 75 0 1787137712 9402688 11232096
17:21:14 8602 8192000000 10713325712 11128782848 1786620304 17.904 99 25 49 1 1799028176 5705888 6701984
17:21:29 7954 8192000000 10716927808 11130691584 1773059936 17.792 98 15 30 0 1782744720 5769872 3914912
17:21:44 12793 8192000000 10720325920 11135574016 1766938608 17.742 98 26 53 0 1780365600 5457008 7969984
17:22:03 23367 8192000000 10733551984 11147177984 1776529120 17.821 98 17 34 0 1785990816 4993136 4468560
17:22:32 53098 8192000000 10728548432 11156148224 1822004272 18.194 100 32 64 0 1841385888 10173040 9208576
17:23:31 9420 8192000000 10742048320 11164995584 1812693296 18.118 99 25 50 1 1824807024 4919328 7194400
17:23:48 10038 8192000000 10762909248 11184316416 1844259536 18.375 100 29 58 0 1857356048 5558752 7537760
17:24:05 5632 8192000000 10762677296 11187322880 1850157856 18.423 100 33 66 2 1866552880 7492960 8902064
17:24:18 9052 8192000000 10771065616 11197288448 1853070624 18.447 100 32 64 1 1868413152 5858096 9484432
17:24:34 12072 8192000000 10766978688 11198509056 1858872000 18.494 100 27 54 1 1873068704 5756544 8440160
17:24:56 7118 8192000000 10771987216 11202551808 1863288672 18.530 100 29 58 1 1878460752 6774048 8398032
17:25:13 6631 8192000000 10787608336 11213520896 1871561728 18.597 100 23 44 2 1883759408 5761024 6436656
17:25:25 7844 8192000000 10784224320 11214565376 1873843792 18.615 100 20 41 2 1885394864 5899696 5651376
17:25:43 9921 8192000000 10790465072 11221569536 1877944880 18.649 100 17 34 2 1887480528 4870848 4664800
17:26:02 9469 8192000000 10799961200 11229827072 1884669488 18.703 100 25 49 0 1897628784 5665024 7294272
17:26:20 10933 8192000000 10787933760 11227144192 1886046752 18.714 100 17 34 0 1896463120 5487120 4929248
17:26:37 11332 8192000000 10790197680 11226976256 1883052192 18.690 100 10 20 1 1891791776 5192720 3546864
17:26:57 9678 8192000000 10802488240 11232501760 1888840336 18.736 100 24 44 2 1899928368 5178288 5909744
17:27:15 90078 8192000000 10848628208 11274776576 1912248560 18.925 100 36 71 1 1928047600 5811664 9987376
17:28:56 17127 8192000000 10863872016 11281600512 1930980096 19.075 100 37 73 2 1951708048 9943536 10784416
17:29:23 31518 8192000000 10859721248 11290648576 1934452832 19.102 100 28 57 2 1952254784 9522240 8279712
17:30:11 44765 8192000000 10860340448 11296051200 1925915408 19.034 99 51 102 2 1953097552 11989296 15192848
17:31:05 28077 8192000000 10881932624 11308187648 1942414976 19.166 100 39 78 1 1966695552 12898224 11382352
17:31:43 7626 8192000000 10889628768 11318177792 1953037856 19.251 100 60 119 1 1984075536 13418480 17619200
17:31:58 6320 8192000000 10899638784 11321913344 1958771360 19.296 100 55 111 2 1987813536 12745840 16296336
17:32:16 12489 8192000000 10888206608 11321589760 1960035136 19.306 100 46 90 2 1985191008 11962128 13193744
17:32:40 8927 8192000000 10903798016 11332894720 1968365984 19.372 100 51 100 1 1995729728 12758768 14604976
17:33:00 7482 8192000000 10905237264 11331719168 1968869120 19.376 100 57 115 1 1999467440 13618016 16980304
17:33:15 8144 8192000000 10919575216 11342008320 1975926784 19.432 100 68 134 2 2009559184 14570032 19062368
17:33:33 14803 8192000000 10924305488 11351191552 1979227984 19.459 100 56 112 2 2012494208 16899088 16367136
17:33:55 6299 8192000000 10929427504 11351527424 1981291648 19.475 100 63 123 4 2016737888 16421216 19025024
17:34:09 11796 8192000000 10931314880 11354726400 1986389168 19.515 100 78 156 1 2023983264 15175120 22418976
17:34:39 3653 8192000000 10927284960 11355910144 1987811328 19.526 100 51 102 2 2017101776 14650432 14640016
17:34:51 6031 8192000000 10935220576 11362762752 1993216784 19.569 100 63 127 1 2026339232 15857616 17264832
17:35:08 17400 8192000000 10948221136 11374436352 1997312384 19.602 100 54 108 2 2031535600 18309792 15913424
17:35:40 2942 8192000000 10947471744 11375812608 2001977728 19.638 100 54 107 2 2034578672 17542176 15058768
17:35:52 3396 8192000000 10937566064 11365937152 1977940736 19.448 99 64 128 3 2014290720 18519296 17830688
17:36:03 4315 8192000000 10956164928 11378249728 2000289504 19.625 100 78 155 3 2042281744 19220224 22772016
17:36:18 5378 8192000000 10932531376 11345039360 1972664736 19.407 99 82 163 0 2016947264 20647600 23634928
17:36:49 13516 8192000000 10930893520 11362918400 1966089648 19.354 99 54 107 1 2006753536 24712960 15950928
17:37:30 4467 8192000000 10934373616 11359318016 1979485568 19.461 100 73 146 0 2029100400 27064272 22550560
17:37:42 3303 8192000000 10957007360 11378962432 1987904704 19.527 100 72 143 0 2035198688 25999248 21294736
17:37:56 7074 8192000000 10943720832 11369988096 1987940784 19.528 100 64 128 2 2034162560 26917968 19303808
17:38:10 5109 8192000000 10952878384 11373527040 1991598368 19.556 100 81 162 0 2040617680 25222096 23797216
17:38:23 2187 8192000000 10944399824 11368075264 1987885520 19.527 100 63 126 1 2031627712 25425024 18317168
17:38:32 1485 8192000000 10925703232 11341082624 1960035520 19.306 99 77 155 1 2008163056 26127296 22000240
17:38:42 1687 8192000000 10937120416 11345182720 1972070608 19.402 100 87 170 2 2023032864 26029744 24932512
17:38:50 1433 8192000000 10948568288 11358416896 1983137072 19.490 100 93 183 2 2037634384 26675792 27821520
17:38:59 10237 8192000000 10930655392 11353747456 1973585456 19.414 100 66 132 0 2017949664 24649312 19714896
17:39:18 2823 8192000000 10949454816 11364225024 1981982192 19.480 100 76 154 3 2032882560 28237040 22663328
17:39:28 2067 8192000000 10939284992 11352616960 1959474112 19.302 99 89 178 0 2015293648 29686016 26133520
17:39:38 3138 8192000000 10959074944 11369836544 1983018560 19.489 100 89 176 1 2040523264 31118816 26385888
17:39:47 1973 8192000000 10959305920 11368022016 1967983808 19.369 99 85 169 1 2025447232 32136864 25326560
17:39:55 3743 8192000000 10934454512 11354038272 1970753072 19.391 100 84 168 0 2028364080 32203840 25407168
17:40:09 3437 8192000000 10918727328 11323613184 1945360496 19.190 99 75 149 3 1997338960 29603856 22374608
17:40:20 2216 8192000000 10939883232 11353133056 1977006592 19.441 100 84 168 1 2031981648 28850496 26124560
17:40:30 5446 8192000000 10929826800 11351932928 1969684864 19.383 100 71 139 2 2020364128 29794544 20884720
17:40:44 9578 8192000000 10919114512 11345756160 1946805184 19.201 99 56 112 1 1995612320 31194880 17612256
17:41:03 5168 8192000000 10900482992 11318878208 1922449920 19.006 98 64 129 1 1972564448 30491584 19622944
17:41:19 3427 8192000000 10940791424 11352530944 1961388416 19.317 100 79 155 0 2018167456 32339824 24439216
17:41:30 3132 8192000000 10950179600 11354955776 1965011200 19.346 100 93 184 2 2028135344 34373360 28750784
17:41:40 1271 8192000000 10916906944 11326615552 1932547632 19.087 99 81 156 1 1990095904 34212704 23335568
17:41:49 3922 8192000000 10921915168 11344945152 1954400832 19.262 100 66 132 2 2012169904 37598960 20170112
17:42:02 5510 8192000000 10910811376 11326410752 1934650752 19.104 99 69 134 3 1992647424 37499520 20497152
17:42:16 2227 8192000000 10941345088 11345108992 1956284672 19.276 100 90 178 2 2019212352 36388720 26538960
17:42:29 4609 8192000000 10934980272 11352268800 1962146256 19.323 100 71 140 3 2020490048 36721904 21621888
17:42:43 9450 8192000000 10938980432 11357478912 1962054512 19.322 100 73 144 1 2023061040 38778032 22228496
17:43:00 5610 8192000000 10945418400 11356676096 1948392048 19.214 99 77 154 4 2011597584 38949952 24255584
17:43:24 2768 8192000000 10934374016 11343331328 1950237648 19.228 99 70 139 3 2011354224 39745424 21371152
17:43:33 2530 8192000000 10927106704 11345293312 1950724832 19.232 99 74 146 0 2010499360 37225264 22549264
17:43:44 5583 8192000000 10956625744 11371155456 1975698048 19.431 100 73 147 1 2037056208 38195056 23163104
17:43:57 4352 8192000000 10961745808 11376447488 1982946976 19.488 100 79 158 2 2047122192 39309584 24865632
17:44:10 4010 8192000000 10938206496 11356381184 1948840656 19.217 99 74 148 1 2012663456 40436256 23386544
17:44:23 5873 8192000000 10941454096 11363127296 1961537088 19.318 100 59 118 0 2019177664 38691088 18949488
17:44:45 3042 8192000000 10933157904 11339689984 1947189248 19.204 99 79 155 0 2008480368 36854432 24436688
17:44:55 1385 8192000000 10958835104 11361599488 1972923968 19.409 100 89 179 3 2037304096 37028480 27351648
17:45:04 2383 8192000000 10948047776 11353505792 1962815920 19.328 100 83 163 3 2024628512 36914752 24897840
17:45:15 2144 8192000000 10938727488 11355664384 1964047056 19.338 100 60 120 1 2019774144 35994688 19732400
17:45:24 1632 8192000000 10950161488 11364618240 1971590128 19.398 100 82 157 0 2033180224 37274352 24315744
17:45:34 5375 8192000000 10958322704 11367702528 1972529904 19.406 100 86 171 2 2038262704 39098912 26633888
17:45:49 6725 8192000000 10954941152 11372834816 1971975456 19.401 100 70 140 1 2035172160 41020688 22176016
17:46:05 3159 8192000000 10964834768 11377008640 1980844128 19.471 100 82 164 0 2049996704 42757712 26394864
17:46:18 2626 8192000000 10972757088 11386118144 1982926624 19.488 100 78 156 0 2049439248 42056848 24455776
17:46:29 6803 8192000000 10959977136 11370848256 1970954944 19.393 100 70 140 2 2036538368 43090976 22492448
17:46:45 2537 8192000000 10960573568 11365920768 1965075536 19.346 100 82 164 2 2036286976 44902080 26309360
17:46:56 1880 8192000000 10959253584 11369697280 1969264896 19.380 100 89 174 1 2043125024 46011552 27848576
17:47:05 3962 8192000000 10966962032 11378024448 1975683456 19.431 100 83 167 0 2047287792 45705584 25898752
17:47:17 1663 8192000000 10974706944 11379388416 1975866528 19.432 100 94 189 0 2053381040 47559616 29954896
17:47:27 7006 8192000000 10953886176 11376013312 1955892960 19.273 99 78 154 1 2031051280 49975296 25183024
17:47:41 6581 8192000000 10933044640 11372994560 1949938512 19.226 99 44 88 1 2014242400 48888608 15415280
17:48:05 11614 8192000000 10932365136 11370491904 1961845856 19.321 100 43 87 2 2018236976 42464704 13926416
17:48:28 14677 8192000000 10943855872 11377385472 1968293472 19.372 100 35 70 2 2022143536 42309872 11540192
17:48:50 26442 8192000000 10957505520 11394056192 1978064608 19.449 100 41 83 3 2038291888 46053088 14174192
17:49:29 10494 8192000000 10964744304 11400204288 1984254816 19.498 100 37 74 3 2046183248 48448512 13479920
17:49:49 4313 8192000000 10981161408 11412672512 1992308592 19.562 100 54 108 0 2058932704 48777040 17847072
17:50:03 4515 8192000000 10983706704 11420733440 2004160832 19.656 100 60 118 2 2072899216 48919520 19818864
17:50:17 16008 8192000000 10976315392 11421650944 2002583600 19.643 100 35 70 2 2062755472 47768608 12403264
17:50:42 13242 8192000000 10951909328 11385692160 1952194048 19.244 98 38 76 0 2010411824 44272656 13945120
17:51:08 13127 8192000000 10956126000 11391881216 1963580144 19.334 99 38 76 3 2022740960 45975168 13185648
17:51:31 5546 8192000000 10964468416 11402145792 1982538752 19.485 100 37 74 1 2047167136 51465088 13163296
17:51:43 16685 8192000000 10958472576 11400425472 1959880320 19.305 99 36 72 0 2030412640 57196560 13335760
17:52:15 14225 8192000000 10934725968 11391471616 1977746256 19.447 100 29 58 2 2028306208 40938704 9621248
17:52:42 21365 8192000000 10934199360 11380920320 1970888064 19.392 100 28 57 1 2019589392 39713072 8988256
17:53:12 13813 8192000000 10942444160 11384897536 1967717200 19.367 100 26 52 0 2023204336 46019664 9467472
17:53:40 20290 8192000000 10926310752 11380391936 1934290080 19.101 99 23 46 2 2002045024 58673504 9081440
17:54:17 28922 8192000000 10904104016 11364872192 1906628208 18.880 98 23 46 0 1975071104 59773664 8669232
17:54:52 27106 8192000000 10893350688 11363074048 1923254992 19.013 99 17 34 0 1969830592 40133776 6441824
17:55:26 33862 8192000000 10872448240 11339051008 1893165328 18.771 97 14 28 0 1922698800 25201344 4332128
17:56:07 62545 8192000000 10892294384 11340611584 1949693392 19.224 100 13 25 3 1964907200 11563440 3650368
17:57:17 59638 8192000000 10891394256 11341201408 1928202288 19.053 98 34 68 0 1949835600 12262720 9370592
17:58:23 23361 8192000000 10875532304 11332325376 1950104352 19.227 100 18 36 1 1963984720 9104864 4775504
17:58:53 13728 8192000000 10883634208 11349700608 1958848448 19.297 100 6 12 0 1968874160 8197072 1828640
17:59:19 23907 8192000000 10898910928 11364343808 1964250896 19.340 100 9 19 0 1974653008 8258416 2143696
17:59:49 47492 8192000000 10881010752 11347525632 1930221312 19.069 98 10 20 0 1941313680 8499376 2592992
18:00:56 70924 8192000000 10884527824 11353395200 1956919248 19.282 100 9 18 1 1971027856 11735456 2373152
18:02:21 97271 8192000000 10909421856 11360038912 1949508000 19.223 99 19 40 0 1961774208 7559120 4707088
18:04:09 102144 8192000000 10902826512 11366998016 1957518928 19.286 99 15 30 0 1973619792 12244416 3856448
18:06:11 54555 8192000000 10923357984 11388678144 1989710528 19.542 100 28 56 0 2009776384 11443776 8622080
18:07:26 129152 8192000000 10918697456 11399876608 1969153440 19.379 99 9 18 1 1991394912 19876464 2365008
18:09:42 68574 8192000000 10918864112 11379953664 1950171200 19.228 98 11 22 0 1965890288 12812672 2906416
18:10:57 97095 8192000000 10920321536 11398553600 1986511152 19.516 100 8 16 0 2008689616 19733360 2445104
18:12:52 87409 8192000000 10895042784 11357974528 1887767600 18.728 95 6 12 0 1898107648 8978752 1361296
18:14:43 116534 8192000000 10919550384 11367153664 1903330752 18.853 96 14 28 0 1920055072 13035984 3688336
18:16:46 97601 8192000000 10906109136 11375206400 1958994944 19.298 99 33 64 1 1976621136 8174256 9451936
18:18:43 64235 8192000000 10924176704 11395383296 1973149424 19.410 99 34 67 3 2005861632 23035184 9677024
18:20:00 78501 8192000000 10921606304 11408068608 1984301184 19.499 100 12 25 1 2010042464 22066656 3674624
18:21:25 36587 8192000000 10916800176 11403591680 1981084656 19.473 100 6 12 0 2006821504 24139872 1596976
18:22:08 19016 8192000000 10893006784 11351556096 1947374416 19.206 99 32 63 1 1965734208 9821584 8538208
18:22:34 19405 8192000000 10891561952 11338874880 1887279856 18.724 96 27 54 0 1905552736 10477248 7795632
18:23:03 29186 8192000000 10897774352 11331911680 1885102496 18.706 96 54 107 0 1914299072 13793904 15402672
18:23:39 8575 8192000000 10898544304 11344531456 1950592560 19.231 100 62 125 0 1981845008 13357888 17894560
18:23:59 9089 8192000000 10903495680 11352297472 1957906144 19.289 100 58 116 1 1989544528 13926656 17711728
18:24:15 35997 8192000000 10877381840 11339689984 1930280864 19.069 99 40 80 0 1955082912 13582736 11219312
18:25:08 52215 8192000000 10879059536 11352940544 1927214176 19.045 99 11 22 0 1944499616 13953824 3331616
18:26:07 14104 8192000000 10867371888 11351007232 1941804656 19.161 100 7 14 0 1956221744 12848464 1568624
18:26:27 7227 8192000000 10858752208 11341733888 1936645248 19.120 100 3 6 0 1949400384 12166544 588592
18:26:41 5658 8192000000 10849341552 11323457536 1912600288 18.928 99 6 12 0 1925817232 11851840 1365104
18:26:53 42058 8192000000 10852683344 11324411904 1898353408 18.813 98 14 28 1 1910117296 8121872 3642016
18:27:41 66914 8192000000 10854202848 11332022272 1937131184 19.124 100 9 18 1 1948607136 9549440 1926512
18:29:03 75228 8192000000 10845303632 11328335872 1889062528 18.738 97 15 31 2 1908676784 15089040 4525216
18:31:22 59970 8192000000 10834765440 11305607168 1826000160 18.227 94 10 20 0 1839219360 10536000 2683200
18:32:28 62888 8192000000 10830621792 11301007360 1828142560 18.244 95 14 28 2 1840161648 8368304 3650784
18:33:43 49972 8192000000 10861441168 11325198336 1904712864 18.864 99 22 44 1 1921984688 10865808 6406016
18:34:40 48944 8192000000 10852104048 11318276096 1861728096 18.517 96 23 46 2 1880495936 12444848 6322992
18:35:37 25126 8192000000 10829767856 11299483648 1859517008 18.499 97 16 32 1 1878326192 14103312 4705872
18:36:09 22399 8192000000 10855729200 11310813184 1902427424 18.846 99 29 58 1 1922468192 12143264 7897504
18:36:43 11775 8192000000 10868420752 11318636544 1908789296 18.897 99 41 82 4 1929436496 9368784 11278416
18:37:01 42738 8192000000 10862205440 11316772864 1891892528 18.761 98 36 72 1 1914811648 12746320 10172800
18:38:00 38556 8192000000 10851239232 11315900416 1899835840 18.825 99 28 56 0 1917407600 10114608 7457152
18:38:45 22078 8192000000 10859249872 11316772864 1925283328 19.029 100 22 44 1 1939824384 8831472 5709584
18:39:15 22891 8192000000 10865945392 11315208192 1896307920 18.797 98 28 56 0 1913990944 9618736 8064288
18:39:51 46250 8192000000 10870144336 11322724352 1857905168 18.486 96 33 66 2 1877313408 10341840 9066400
18:40:44 12376 8192000000 10853289424 11293708288 1894592784 18.783 98 49 98 5 1916777072 8554448 13629840
18:41:08 11194 8192000000 10891192128 11335802880 1942921216 19.170 100 52 104 1 1969471968 12089952 14460800
18:41:30 60805 8192000000 10889198368 11349737472 1909185968 18.900 98 26 52 0 1938546384 22231792 7128624
18:42:53 61948 8192000000 10877931104 11363143680 1931410496 19.078 99 13 26 2 1962087616 26535680 4141440
18:44:07 105596 8192000000 10873385264 11338416128 1888406048 18.733 97 13 26 1 1908410416 16644336 3360032
18:45:59 84438 8192000000 10882552512 11343147008 1959645152 19.303 100 46 88 1 1978464080 6622224 12196704
18:47:44 101165 8192000000 10894328576 11366559744 1907311744 18.885 97 23 46 2 1925873856 12477280 6084832
18:49:32 39290 8192000000 10876063872 11356958720 1935457968 19.110 99 4 8 0 1955986448 19474720 1053760
18:50:17 34821 8192000000 10872723232 11334221824 1945065648 19.187 99 23 46 0 1963957536 12489680 6402208
18:51:07 57437 8192000000 10884548096 11355967488 1963855456 19.337 100 25 50 0 1980136640 9271248 7009936
18:52:50 78716 8192000000 10892299472 11364249600 1933288864 19.093 98 19 38 1 1950780352 11823456 5668032
18:56:27 63229 8192000000 10901200640 11384041472 1971775024 19.400 100 13 26 1 1993114352 17307280 4032048
18:57:51 65113 8192000000 10908002208 11382456320 1944179584 19.180 98 11 22 2 1957229072 9862720 3186768
18:59:05 49563 8192000000 10936042688 11402940416 1994320992 19.578 100 29 55 0 2014740832 12749840 7670000
19:00:06 94266 8192000000 10909759072 11400093696 1977805872 19.447 99 13 26 0 1998742496 16730880 4205744
19:01:46 19576 8192000000 10935405360 11382824960 1978365824 19.452 99 55 110 0 2000765280 6741248 15658208
19:02:13 27103 8192000000 10906580704 11364958208 1910369232 18.910 96 28 55 1 1926653584 8197472 8086880
19:02:50 19775 8192000000 10923059056 11371548672 1976554608 19.437 100 53 106 0 2002427472 10997936 14874928
19:03:20 26418 8192000000 10911368592 11367714816 1917163520 18.964 97 43 86 0 1943599824 14353792 12082512
19:04:52 274016 8192000000 10930989584 11423576064 1881645040 18.678 95 11 22 0 1913178672 28713040 2820592
19:09:32 78364 8192000000 10884510432 11345571840 1826691936 18.232 92 17 34 1 1850085600 18198384 5195280
19:11:02 126572 8192000000 10875284944 11345891328 1904822304 18.865 98 13 26 0 1921131264 12869968 3438992
19:13:23 77617 8192000000 10871849600 11344146432 1915715008 18.952 98 17 34 0 1932120496 12158896 4246592
19:15:21 57251 8192000000 10863712096 11333742592 1908080208 18.891 98 21 42 3 1923962784 9922064 5960512
19:16:55 39580 8192000000 10829290816 11307716608 1861684224 18.517 97 3 6 0 1875572704 13087264 801216
19:17:41 61927 8192000000 10837637056 11306962944 1862245552 18.521 97 23 46 2 1879392304 10062624 7084128
19:20:21 88732 8192000000 10819532160 11305177088 1851163440 18.432 97 15 29 2 1874276128 19033728 4078960
19:21:56 72579 8192000000 10829761440 11294871552 1848034256 18.406 97 16 32 2 1863809056 11410304 4364496
19:23:18 22751 8192000000 10842485744 11297849344 1879531680 18.661 98 38 75 1 1900198400 10287616 10379104
19:23:50 23746 8192000000 10867552400 11317465088 1912563328 18.927 100 32 64 1 1932548128 10933312 9051488
19:24:22 70152 8192000000 10860660144 11329937408 1904499568 18.862 99 22 44 1 1924463440 13882592 6081280
19:25:45 55326 8192000000 10857785296 11339845632 1931578944 19.080 100 22 44 1 1956676496 18719040 6378512
19:26:48 24736 8192000000 9128205888 9364004864 292983040 3.452 16 2 4 0 297210608 3816096 411472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-01-2021 19:28:20 to 09-01-2021 19:28:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-01-2021 19:28:52 to 09-01-2021 19:28:54.

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          250096
MON$OLDEST_ACTIVE               250097
MON$OLDEST_SNAPSHOT             250097
MON$NEXT_TRANSACTION            250097
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                       2065824
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 ---
--- end of diff output ---

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

09.01.21 19:28:55. 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-09 19:28:58 No severe PSQL-related problems occured
09.01.21 19:28:59. End of report.