Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.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 17089232 kB
MemAvailable 31258296 kB
Buffers 0 kB
Cached 14565280 kB
SwapCached 4868 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-24 19:27:10
DTS_END                         2021-01-24 19:27:10.9220
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/38132
TRN_ID                          250450
ATT_ID                          679
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: 9546.85 19128 1145622
customer order: creation 184.65 314 22158
customer order: refuse 16.12 334 1934
order to supplier: creation 49.05 1383 5886
order to supplier: removal 3.67 87394 440
invoice (draft): creation 49.51 3131 5941
invoice (draft): removal 51.64 785 6197
invoice accept: apply 45.16 18080 5419
invoice accept: cancel 46.06 858 5527
customer reserve: creation 4178.96 179 501475
customer reserve: removal 4615.74 53 553889
realization accept: apply 88.73 167 10648
realization accept: cancel 78.21 103 9385
payment from customer: creation 64.37 104 7724
payment from customer: removal 5.93 72 711
payment to supplier: creation 52.23 131 6267
payment to supplier: removal 4.05 59 486
service: total inventory turnovers 5.11 1112 613
service: total monetary turnovers 6.68 26 802
service: aggregate perf. data 0.97 17155 116
service: refresh index statistics 0.03 251129 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-01-2021 19:27:55 to 24-01-2021 19:27:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7202
TEST_TIME 2 6789
TEST_TIME 3 6273
TEST_TIME 4 6943
TEST_TIME 5 6271
TEST_TIME 6 6314
TEST_TIME 7 6356
TEST_TIME 8 6810
TEST_TIME 9 6931
TEST_TIME 10 6918
TEST_TIME 11 7837
TEST_TIME 12 7749
TEST_TIME 13 7805
TEST_TIME 14 7778
TEST_TIME 15 7996
TEST_TIME 16 7970
TEST_TIME 17 8037
TEST_TIME 18 8370
TEST_TIME 19 8494
TEST_TIME 20 8486
TEST_TIME 21 9319
TEST_TIME 22 9356
TEST_TIME 23 9651
TEST_TIME 24 9895
TEST_TIME 25 9928
TEST_TIME 26 10172
TEST_TIME 27 10354
TEST_TIME 28 10617
TEST_TIME 29 10862
TEST_TIME 30 11095
TEST_TIME 31 10934
TEST_TIME 32 10921
TEST_TIME 33 10965
TEST_TIME 34 10858
TEST_TIME 35 10805
TEST_TIME 36 10723
TEST_TIME 37 10917
TEST_TIME 38 10746
TEST_TIME 39 10604
TEST_TIME 40 10426
TEST_TIME 41 10431
TEST_TIME 42 10503
TEST_TIME 43 10342
TEST_TIME 44 10289
TEST_TIME 45 10198
TEST_TIME 46 10117
TEST_TIME 47 10258
TEST_TIME 48 10243
TEST_TIME 49 10150
TEST_TIME 50 10113
TEST_TIME 51 10083
TEST_TIME 52 9980
TEST_TIME 53 9872
TEST_TIME 54 9819
TEST_TIME 55 9859
TEST_TIME 56 9873
TEST_TIME 57 9831
TEST_TIME 58 9789
TEST_TIME 59 9954
TEST_TIME 60 9945
TEST_TIME 61 9961
TEST_TIME 62 9972
TEST_TIME 63 9971
TEST_TIME 64 10022
TEST_TIME 65 10025
TEST_TIME 66 10023
TEST_TIME 67 10108
TEST_TIME 68 10103
TEST_TIME 69 10146
TEST_TIME 70 10098
TEST_TIME 71 10144
TEST_TIME 72 10040
TEST_TIME 73 10095
TEST_TIME 74 10016
TEST_TIME 75 9951
TEST_TIME 76 9970
TEST_TIME 77 9886
TEST_TIME 78 9807
TEST_TIME 79 9891
TEST_TIME 80 9823
TEST_TIME 81 9778
TEST_TIME 82 9749
TEST_TIME 83 9677
TEST_TIME 84 9682
TEST_TIME 85 9675
TEST_TIME 86 9696
TEST_TIME 87 9713
TEST_TIME 88 9717
TEST_TIME 89 9705
TEST_TIME 90 9782
TEST_TIME 91 9789
TEST_TIME 92 9787
TEST_TIME 93 9798
TEST_TIME 94 9816
TEST_TIME 95 9824
TEST_TIME 96 9841
TEST_TIME 97 9842
TEST_TIME 98 9907
TEST_TIME 99 9814
TEST_TIME 100 9768
TEST_TIME 101 9754
TEST_TIME 102 9727
TEST_TIME 103 9684
TEST_TIME 104 9645
TEST_TIME 105 9625
TEST_TIME 106 9570
TEST_TIME 107 9556
TEST_TIME 108 9563
TEST_TIME 109 9554
TEST_TIME 110 9527
TEST_TIME 111 9509
TEST_TIME 112 9590
TEST_TIME 113 9600
TEST_TIME 114 9599
TEST_TIME 115 9589
TEST_TIME 116 9600
TEST_TIME 117 9578
TEST_TIME 118 9605
TEST_TIME 119 9610
TEST_TIME 120 9550

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-01-2021 19:27:58 to 24-01-2021 19:28:02.

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 1609827 1609827 0 0.00 0 16616 6 0 0
doc_list_biud 1609825 1609825 0 0.00 0 63133 24 0 0
sp_add_invoice_to_stock 5536 5419 117 2.11 28 175954 18080 0 117
sp_cancel_adding_invoice 5527 5527 0 0.00 3 82246 859 0 0
sp_cancel_client_order 1934 1934 0 0.00 4 9678 334 0 0
sp_cancel_customer_reserve 553889 553889 0 0.00 1 63136 54 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 3 4254 72 0 0
sp_cancel_pay_to_supplier 486 486 0 0.00 3 2149 60 0 0
sp_cancel_supplier_invoice 6207 6197 10 0.16 1 45328 786 0 10
sp_cancel_supplier_order 440 440 0 0.00 6 886789 87395 0 0
sp_cancel_write_off 9385 9385 0 0.00 1 10647 103 0 0
sp_client_order 22158 22158 0 0.00 3 15100 314 0 0
sp_customer_reserve 501475 501475 0 0.00 0 146724 180 0 0
sp_fill_shopping_cart 33979 33979 0 0.00 1 13000 37 0 0
sp_fill_shopping_cart_clo_res 501453 501453 0 0.00 0 12494 12 0 0
sp_get_clo_for_invoice 5397 5397 0 0.00 0 17236 269 0 0
sp_kill_cost_storno 16109 16109 0 0.00 0 7954 53 0 0
sp_kill_qstorno_ret_qs2qd 1123800 1123800 0 0.00 0 63132 29 0 0
sp_kill_qty_storno 593416 593416 0 0.00 0 63133 65 0 0
sp_lock_selected_doc 22274 22274 0 0.00 0 9576 5 0 0
sp_make_cost_storno 30036 30036 0 0.00 0 16221 48 0 0
sp_multiply_rows_for_pdistr 30036 30036 0 0.00 0 8973 27 0 0
sp_multiply_rows_for_qdistr 22158 22158 0 0.00 0 12003 139 0 0
sp_pay_from_customer 7724 7724 0 0.00 4 13657 105 0 0
sp_pay_to_supplier 6267 6267 0 0.00 5 13234 132 0 0
sp_payment_common 13991 13991 0 0.00 1 13197 29 0 0
sp_qd_handle_on_cancel_clo 1934 1934 0 0.00 0 8701 303 0 0
sp_qd_handle_on_invoice_upd_sts 10924 10924 0 0.00 0 36118 360 0 0
sp_qd_handle_on_reserve_upd_sts 10647 10647 0 0.00 0 23110 61 0 0
sp_reserve_write_off 10648 10648 0 0.00 6 23152 167 0 0
sp_supplier_invoice 5941 5941 0 0.00 6 95791 3132 0 0
sp_supplier_order 5886 5886 0 0.00 5 64075 1383 0 0
srv_aggregate_perf_data 116 116 0 0.00 2044 126812 17155 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1239 167032 30209 0 0
srv_find_qd_qs_mism 1094034 1094034 0 0.00 0 12662 6 0 0
srv_make_invnt_saldo 613 613 0 0.00 40 64245 1113 0 0
srv_make_money_saldo 802 802 0 0.00 1 908 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 191014 289652 251130 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 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 5419 5419 0 0.00 0 15408 205 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 1 5405 104 0 0
t$perf-norm:sp_cancel_client_order 1934 1934 0 0.00 0 3071 13 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 2514 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 1504 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 486 486 0 0.00 0 782 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 437 437 0 0.00 0 1435 15 0 0
t$perf-norm:sp_cancel_supplier_order 440 440 0 0.00 0 22360 1449 0 0
t$perf-norm:sp_cancel_write_off 1081 1081 0 0.00 0 13410 24 0 0
t$perf-norm:sp_client_order 22158 22158 0 0.00 0 14427 19 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 6846 9 0 0
t$perf-norm:sp_pay_from_customer 7724 7724 0 0.00 0 6775 11 0 0
t$perf-norm:sp_pay_to_supplier 6267 6267 0 0.00 0 6009 10 0 0
t$perf-norm:sp_reserve_write_off 10648 10648 0 0.00 0 13688 13 0 0
t$perf-norm:sp_supplier_invoice 5941 5941 0 0.00 0 10530 26 0 0
t$perf-norm:sp_supplier_order 5886 5886 0 0.00 0 6855 18 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 2544 34 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 226 4 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 556 20 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2854 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 11024 10790 234 2.12 0 12836 20 0 234
v_all_customers 40118 40118 0 0.00 0 124 1 0 0
v_all_suppliers 32754 32754 0 0.00 0 16 1 0 0
v_all_wares 44316 44316 0 0.00 0 156 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 962 8 0 0
v_cancel_client_order 3868 3868 0 0.00 0 8788 5 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 855 5 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 2126 6 0 0
v_cancel_payment_to_supplier 972 972 0 0.00 0 2143 6 0 0
v_cancel_supplier_invoice 894 874 20 2.23 0 6157 25 0 20
v_cancel_supplier_order 880 880 0 0.00 0 1219 6 0 0
v_cancel_write_off 2162 2162 0 0.00 0 1871 13 0 0
v_max_id_clo_ord 5886 5886 0 0.00 0 7850 3 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 1590 6 0 0
v_max_id_ord_sup 5935 5935 0 0.00 0 7350 7 0 0
v_max_non_paid_invoice 1711 1711 0 0.00 0 1883 4 0 0
v_max_non_paid_realizn 4226 4226 0 0.00 0 4563 6 0 0
v_min_id_clo_ord 5886 5886 0 0.00 0 7910 8 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 1831 6 0 0
v_min_id_ord_sup 5935 5935 0 0.00 0 4362 5 0 0
v_min_non_paid_invoice 6267 6267 0 0.00 0 13192 24 0 0
v_min_non_paid_realizn 7724 7724 0 0.00 0 4816 13 0 0
v_our_firm 11194 11194 0 0.00 0 18 1 0 0
v_reserve_write_off 21294 21294 0 0.00 0 12715 7 0 0
x_lock_depdocs_on_canc_invoice 11287 11287 0 0.00 0 20009 116 0 0
x_lock_depdocs_on_canc_sup_ord 440 440 0 0.00 0 9749 330 0 0
x_make_qstorno_1000_1200 5886 5886 0 0.00 2 64055 1297 0 0
x_make_qstorno_1200_2000 5941 5941 0 0.00 2 95732 3007 0 0
x_make_qstorno_2100_3300 501475 501475 0 0.00 0 146723 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-01-2021 19:28:03 to 24-01-2021 19:28:07.

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:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 6193 8192000000 9910464928 10159476736 795339648 8.849 66 52 107 0 815937072 2263248 18334176
16:57:34 39007 8192000000 10310880480 10626895872 1351530992 14.161 100 84 168 0 1383202096 4348752 27322352
16:58:24 21473 8192000000 10350005936 10666192896 1403154688 14.623 100 80 159 0 1434386528 5481040 25750800
16:58:54 30087 8192000000 10394816928 10717728768 1441420592 14.962 100 89 178 0 1477465488 6903456 29141440
16:59:33 23884 8192000000 10415631056 10741895168 1459304672 15.120 100 88 176 2 1495784080 7932880 28546528
17:00:08 31944 8192000000 10431804592 10763927552 1483323264 15.330 100 84 168 0 1518925072 8785616 26816192
17:00:53 17649 8192000000 10458187072 10795319296 1517095392 15.625 100 88 176 0 1554126864 9486016 27545456
17:01:20 12393 8192000000 10483464976 10820820992 1533070368 15.764 100 84 168 1 1569186672 9985104 26131200
17:01:40 17052 8192000000 10493870592 10838900736 1554961216 15.953 100 79 158 0 1589508128 10262304 24284608
17:02:05 10473 8192000000 10516307168 10865582080 1569460128 16.078 100 75 148 1 1602560256 10780576 22319552
17:02:25 13337 8192000000 10545111808 10900754432 1602361216 16.360 100 78 156 1 1636956352 10948480 23646656
17:02:49 10429 8192000000 10569932048 10930356224 1629939200 16.594 100 76 152 1 1663865648 11551776 22374672
17:03:06 7852 8192000000 10593177600 10959339520 1650272352 16.767 100 69 138 0 1682705408 11993696 20439360
17:03:22 9022 8192000000 10614636224 10980999168 1670809136 16.940 100 77 153 1 1704772784 12050816 21912832
17:03:38 8461 8192000000 10633398480 10999357440 1690644944 17.107 100 81 162 0 1726793440 12820064 23328432
17:03:53 6939 8192000000 10644774288 11012038656 1703216160 17.212 100 80 160 1 1739861536 13122768 23522608
17:04:10 5719 8192000000 10661121952 11033714688 1717128432 17.328 100 77 154 1 1751630368 12917936 21584000
17:04:22 6005 8192000000 10673752480 11046912000 1728876848 17.426 100 79 157 1 1764954768 14082176 21995744
17:04:35 6589 8192000000 10683205440 11059884032 1745615360 17.565 100 83 164 1 1782345136 13726976 23002800
17:04:49 4647 8192000000 10690209024 11070455808 1757474736 17.663 100 88 175 3 1796613856 14256592 24882528
17:05:01 5125 8192000000 10699781472 11077750784 1761771968 17.699 100 81 158 1 1796700304 12753744 22174592
17:05:13 2448 8192000000 10713397920 11090145280 1772360272 17.786 100 81 162 1 1808447120 11736800 24350048
17:05:22 4971 8192000000 10725930336 11106619392 1785658096 17.896 100 77 154 1 1818897168 10992160 22246912
17:05:35 3261 8192000000 10730668336 11110727680 1792155680 17.949 100 78 153 1 1825706800 12195856 21355264
17:05:45 3758 8192000000 10745750112 11128434688 1800775648 18.020 100 80 161 1 1835302560 12452496 22074416
17:05:56 2120 8192000000 10746771760 11125338112 1807239008 18.073 100 84 163 0 1843056672 13133280 22684384
17:06:06 7724 8192000000 10741442960 11131383808 1810885952 18.103 100 85 170 0 1847764576 13595360 23283264
17:06:21 5093 8192000000 10752487184 11138482176 1818360160 18.164 100 84 169 0 1855375360 13767920 23247280
17:06:34 1559 8192000000 10773779328 11163226112 1834089872 18.293 100 84 166 0 1871229472 13818512 23321088
17:06:42 2375 8192000000 10780025824 11170484224 1846661648 18.395 100 87 174 0 1884293936 13098400 24533888
17:06:51 1952 8192000000 10793182352 11181916160 1851163040 18.432 100 91 182 1 1890361840 13787280 25411520
17:07:00 2579 8192000000 10796697968 11184906240 1853727008 18.452 100 89 177 3 1890751520 12352992 24671520
17:07:09 2680 8192000000 10805169728 11190034432 1855364336 18.466 100 90 180 1 1893440432 12457472 25618624
17:07:19 1892 8192000000 10809992176 11195731968 1860938224 18.511 100 90 181 1 1899622752 13608736 25075792
17:07:27 1599 8192000000 10804827984 11194736640 1859879696 18.502 100 94 189 0 1900018832 14047648 26091488
17:07:35 1860 8192000000 10809754784 11198767104 1866653680 18.557 100 90 180 0 1905568432 13996880 24917872
17:07:43 1367 8192000000 10809648224 11199438848 1868952432 18.576 100 86 174 0 1906308864 13124832 24231600
17:07:51 1943 8192000000 10815364224 11205283840 1869327136 18.579 100 91 182 0 1908822096 13981104 25513856
17:07:59 10868 8192000000 10811414352 11209519104 1876978928 18.641 100 68 133 3 1907200960 10965824 19256208
17:08:18 7575 8192000000 10809758176 11207827456 1878313984 18.651 100 75 148 1 1909294608 9280064 21700560
17:08:32 1467 8192000000 10816355216 11215007744 1884407472 18.701 100 87 174 0 1920407520 11054352 24945696
17:08:40 2769 8192000000 10814337104 11220262912 1883823488 18.696 100 79 159 1 1918530784 12306384 22400912
17:08:50 2210 8192000000 10818541776 11222724608 1888023168 18.730 100 74 148 0 1921354192 11595024 21736000
17:09:00 4105 8192000000 10805109600 11218755584 1882293216 18.684 100 52 102 1 1907331392 10724064 14314112
17:09:15 6069 8192000000 10784369872 11211702272 1877604048 18.646 100 24 48 0 1891395120 7051824 6739248
17:09:28 6473 8192000000 10791447936 11216773120 1884285456 18.700 100 44 90 1 1904145568 6644000 13216112
17:09:40 4968 8192000000 10808490944 11223650304 1883958608 18.697 100 38 76 0 1900183760 5792832 10432320
17:09:52 4122 8192000000 10802035680 11227815936 1885496192 18.709 100 38 72 2 1907639264 12578320 9564752
17:10:03 4752 8192000000 10796738240 11221553152 1885185424 18.707 100 30 60 2 1901304384 7696272 8422688
17:10:16 9525 8192000000 10791029104 11223318528 1885240192 18.707 100 21 42 2 1897679056 6058576 6380288
17:10:34 12548 8192000000 10788848144 11220045824 1885246736 18.707 100 20 40 1 1897981872 6342816 6392320
17:10:55 15227 8192000000 10792358240 11231383552 1892245360 18.764 100 29 59 2 1907345824 6591968 8508496
17:11:17 69680 8192000000 10810727776 11250900992 1896751792 18.800 100 38 76 2 1918276128 9901264 11623072
17:12:32 5346 8192000000 10815590688 11249463296 1899692448 18.824 100 37 74 0 1918992896 8431808 10868640
17:12:44 5494 8192000000 10832722336 11259662336 1901314560 18.837 100 42 84 0 1925192416 12299856 11578000
17:12:59 5012 8192000000 10831537120 11255734272 1903258944 18.852 100 31 61 1 1918027968 5875456 8893568
17:13:11 4043 8192000000 10821382448 11253948416 1905909408 18.874 100 33 66 0 1922270160 7020976 9339776
17:13:21 3856 8192000000 10831988208 11256119296 1909290016 18.901 100 39 78 3 1927470560 7459856 10720688
17:13:32 8897 8192000000 10812900144 11254013952 1891214400 18.756 99 32 63 2 1907107952 6629104 9264448
17:13:47 7841 8192000000 10824674528 11255857152 1907073792 18.883 100 28 57 1 1921619888 6532608 8013488
17:14:01 6696 8192000000 10831132688 11264610304 1908282928 18.893 100 30 60 2 1923226640 6768160 8175552
17:14:14 9281 8192000000 10820750032 11257774080 1907285792 18.885 100 17 34 1 1917652592 5339408 5027392
17:14:31 7738 8192000000 10821417104 11261947904 1914953152 18.946 100 33 66 2 1930892848 6812992 9126704
17:14:49 9453 8192000000 10814727392 11253141504 1899098544 18.819 100 11 22 0 1907024192 5333520 2592128
17:15:10 9262 8192000000 10818207408 11258150912 1906492384 18.878 100 22 44 1 1918738848 6267184 5979280
17:15:26 16478 8192000000 10825265136 11257106432 1915104848 18.948 100 31 62 2 1928734576 5602688 8027040
17:15:51 63623 8192000000 10823159568 11258847232 1859310704 18.498 97 28 55 1 1876370096 9299312 7760080
17:17:01 7842 8192000000 10807199056 11245215744 1869895584 18.583 98 21 41 2 1881826272 5816144 6114544
17:17:15 12703 8192000000 10773080576 11208880128 1804819440 18.053 95 25 50 0 1817261920 5216048 7226432
17:17:35 4384 8192000000 10786852736 11214340096 1858410864 18.490 99 29 58 1 1873350224 6986208 7953152
17:17:47 5319 8192000000 10787016784 11224363008 1865678448 18.549 99 29 58 0 1880085008 5675168 8731392
17:18:00 6298 8192000000 10779066864 11213787136 1851539712 18.435 99 28 56 0 1870449936 10784736 8125488
17:18:13 8192 8192000000 10765635024 11192233984 1797039952 17.990 96 28 54 0 1811220096 6260528 7919616
17:18:29 6733 8192000000 10751694096 11171852288 1785812176 17.897 96 18 36 0 1796050512 4834272 5404064
17:18:44 10089 8192000000 10735057040 11159298048 1773015712 17.792 96 16 32 0 1783151120 5619552 4515856
17:19:02 3219 8192000000 10689928096 11097477120 1729966944 17.435 95 26 53 0 1743152768 5816720 7369104
17:19:15 12655 8192000000 10725189392 11153186816 1759692128 17.682 96 27 54 0 1772106112 4865024 7548960
17:19:34 7956 8192000000 10699156960 11108102144 1756565968 17.656 97 35 70 0 1773095920 5728288 10801664
17:19:48 9225 8192000000 10719447600 11139252224 1789034752 17.924 99 15 30 0 1798430336 5074656 4320928
17:20:07 9923 8192000000 10723454720 11135676416 1766372560 17.737 97 24 45 1 1783522384 9469824 7680000
17:20:23 23457 8192000000 10729978400 11150462976 1785371744 17.894 98 21 42 2 1795812208 5172592 5267872
17:20:52 60440 8192000000 10717544864 11137720320 1754170544 17.636 96 26 52 0 1768205040 6081808 7952688
17:21:59 12472 8192000000 10724751008 11151806464 1799471664 18.010 99 25 50 2 1812983216 5522016 7989536
17:22:18 11440 8192000000 10722721232 11139944448 1804605552 18.052 99 29 58 3 1819366112 6967392 7793168
17:22:38 6416 8192000000 10760210640 11178754048 1832829136 18.282 100 40 79 1 1851109936 6942224 11338576
17:22:51 4940 8192000000 10729464752 11145424896 1813172880 18.122 99 38 76 1 1830493600 5749968 11570752
17:23:06 8587 8192000000 10766338576 11180179456 1837246848 18.318 100 32 64 3 1852192352 5197984 9747520
17:23:21 6587 8192000000 10740516784 11165061120 1812838016 18.119 99 28 56 1 1826536368 5751824 7946528
17:23:34 11915 8192000000 10746645488 11175165952 1834826688 18.299 100 25 50 0 1847879056 5800016 7252352
17:23:55 6502 8192000000 10768371264 11185459200 1841959744 18.357 100 27 53 1 1853981376 4592848 7428784
17:24:08 6785 8192000000 10761785888 11183214592 1847239280 18.400 100 27 54 0 1860825824 6039024 7547520
17:24:23 8224 8192000000 10762174912 11189833728 1848338288 18.409 100 14 26 1 1858746864 5542160 4866416
17:24:37 11407 8192000000 10777166880 11198783488 1859782960 18.502 100 26 52 1 1872886992 5292272 7811760
17:24:55 9421 8192000000 10769298816 11195711488 1858488528 18.491 100 20 39 1 1869417232 5601760 5326944
17:25:15 11325 8192000000 10766902976 11201384448 1858654512 18.492 100 18 36 0 1868779008 5195680 4928816
17:25:35 47241 8192000000 10792920112 11212296192 1870471744 18.588 100 33 66 3 1885899488 6113536 9314208
17:26:29 26211 8192000000 10776321680 11213541376 1869148256 18.577 100 18 36 2 1880321936 5975888 5197792
17:27:04 8911 8192000000 10818963120 11238440960 1888616720 18.735 100 35 70 2 1903261552 5219424 9425408
17:27:26 17196 8192000000 10837986240 11255226368 1906839728 18.881 100 55 110 1 1931017056 8880736 15296592
17:27:53 7623 8192000000 10839823216 11262128128 1912054000 18.923 100 52 103 3 1935470384 9247328 14169056
17:28:17 15019 8192000000 10844134368 11268575232 1916679552 18.960 100 49 97 1 1938399776 8578896 13141328
17:28:39 8734 8192000000 10848044512 11275104256 1921891136 19.002 100 43 86 0 1944235968 10183936 12160896
17:28:57 11200 8192000000 10855228768 11280150528 1927687024 19.048 100 51 101 1 1953617728 10580000 15350704
17:29:17 14773 8192000000 10868296640 11288932352 1913148976 18.932 99 43 86 0 1938119424 12856096 12114352
17:29:41 18119 8192000000 10873251632 11299307520 1936494224 19.119 100 53 104 1 1964345456 14075232 13776000
17:30:11 8474 8192000000 10881507248 11304845312 1943665712 19.176 100 62 122 2 1975102432 14020272 17416448
17:30:27 22225 8192000000 10871304688 11307827200 1945279024 19.189 100 49 98 1 1976390256 16483744 14627488
17:31:27 11999 8192000000 10897610000 11322798080 1956600896 19.279 100 54 106 3 1986855568 15035760 15218912
17:31:51 4963 8192000000 10898966016 11325161472 1957972208 19.290 100 48 94 2 1985944832 14530176 13442448
17:32:05 32722 8192000000 10898250304 11332825088 1963834768 19.337 100 56 113 3 1995772240 16485248 15452224
17:32:46 10887 8192000000 10899293056 11334373376 1965104320 19.347 100 48 96 1 1996212560 17095776 14012464
17:33:06 24033 8192000000 10908977104 11343978496 1965761392 19.352 100 44 84 0 1995877760 17730592 12385776
17:33:37 4752 8192000000 10907072992 11345928192 1973153904 19.410 100 54 106 1 2006017248 17229056 15634288
17:33:56 26125 8192000000 10914146160 11352489984 1971470368 19.397 100 51 100 0 2004578880 18380304 14728208
17:34:39 12288 8192000000 10912770320 11355631616 1980499584 19.469 100 42 84 1 2013792304 20507744 12784976
17:34:59 7801 8192000000 10925186448 11361972224 1985390144 19.507 100 49 96 1 2020652128 20288128 14973856
17:35:15 2696 8192000000 10944049904 11355365376 1968954928 19.377 99 76 150 1 2013573520 22165584 22453008
17:35:26 4873 8192000000 10944205136 11367018496 1985760992 19.510 100 69 138 1 2029930880 24226560 19943328
17:35:38 4818 8192000000 10933058720 11360206848 1983824880 19.495 100 78 156 0 2030696880 24255200 22616800
17:35:50 3000 8192000000 10937341568 11363217408 1983305328 19.491 100 66 130 2 2025786288 23704240 18776720
17:36:04 8888 8192000000 10934012016 11359662080 1979506208 19.461 100 67 133 0 2026095984 27429712 19160064
17:36:22 6283 8192000000 10942240336 11363213312 1985569360 19.509 100 66 131 1 2027953312 23680144 18703808
17:36:36 10826 8192000000 10930634384 11354329088 1962628576 19.327 99 73 146 1 2009829968 25834176 21367216
17:36:57 2911 8192000000 10937879200 11351584768 1966788448 19.360 99 75 148 2 2016618496 28219712 21610336
17:37:06 5209 8192000000 10944777136 11366526976 1978351904 19.452 100 75 150 1 2030581568 29009904 23219760
17:37:21 12763 8192000000 10942105168 11369320448 1973462608 19.413 100 50 100 0 2018525648 29354736 15708304
17:37:43 4578 8192000000 10947549280 11374030848 1984285936 19.499 100 76 152 0 2040804080 33315680 23202464
17:38:01 3333 8192000000 10949086704 11366801408 1969631984 19.383 99 82 164 1 2033023664 39240816 24150864
17:38:11 4891 8192000000 10950154704 11377934336 1978987504 19.457 100 65 130 0 2038472080 38787776 20696800
17:38:24 5908 8192000000 10960034528 11391074304 1992494048 19.563 100 74 144 3 2050580560 36142928 21943584
17:38:38 4244 8192000000 10963176336 11390033920 1999172848 19.616 100 73 146 0 2052854032 31735120 21946064
17:38:50 7720 8192000000 10961285312 11388252160 1998875136 19.614 100 68 136 2 2046986016 27506496 20604384
17:39:07 2071 8192000000 10966041152 11396374528 2004054624 19.655 100 59 117 0 2048667456 27109520 17503312
17:39:18 32524 8192000000 10961021360 11394170880 1992232432 19.561 99 59 117 1 2035404608 25256224 17915952
17:40:04 4355 8192000000 10973309072 11403390976 2011965648 19.717 100 73 144 4 2060546000 27185776 21394576
17:40:21 6860 8192000000 10961935808 11395133440 2007157136 19.679 100 61 122 1 2051696656 25684848 18854672
17:40:43 14582 8192000000 10937266000 11372892160 1938813472 19.137 97 53 106 2 1981802080 26514128 16474480
17:41:05 4638 8192000000 10932949488 11365109760 1969916160 19.385 100 63 126 1 2018614624 28524480 20173984
17:41:19 8181 8192000000 10943653600 11370811392 1978479424 19.453 100 67 128 2 2026619904 27977600 20162880
17:41:41 5374 8192000000 10927799040 11360690176 1949012208 19.219 98 62 123 1 1997634928 29255712 19367008
17:41:54 7556 8192000000 10943523680 11374067712 1979560528 19.461 100 57 114 0 2026776720 29289248 17926944
17:42:11 8203 8192000000 10955351008 11391520768 1995655680 19.588 100 65 129 0 2047091744 30203184 21232880
17:42:32 9367 8192000000 10954680928 11384238080 1963432864 19.333 98 56 112 0 2008313296 27736800 17143632
17:42:50 3848 8192000000 10959022272 11381424128 1977138240 19.442 99 60 120 0 2023774720 27866160 18770320
17:43:02 3055 8192000000 10949918464 11371397120 1964658480 19.343 99 70 138 0 2015251744 28638624 21954640
17:43:17 5707 8192000000 10954015920 11380264960 1982129040 19.482 100 64 129 0 2031959920 29717536 20113344
17:43:30 3387 8192000000 10969293296 11386220544 1992487088 19.563 100 78 156 3 2045609440 30056592 23065760
17:43:40 4283 8192000000 10974471360 11386933248 1993441728 19.571 100 71 143 0 2047826992 32029200 22356064
17:43:51 4115 8192000000 10970227840 11383037952 1975167072 19.426 99 89 176 1 2035990112 33326176 27496864
17:44:04 1237 8192000000 10950185616 11360153600 1970117776 19.386 100 83 167 3 2029263376 34060448 25085152
17:44:12 3269 8192000000 10945139648 11361443840 1960258848 19.308 99 83 166 2 2020186992 34137632 25790512
17:44:23 4600 8192000000 10948280288 11365081088 1976849504 19.440 100 89 176 2 2038988848 34419616 27719728
17:44:36 1755 8192000000 10965154192 11378401280 1981117552 19.474 100 89 178 2 2044590912 35240352 28233008
17:44:46 4729 8192000000 10950604352 11364388864 1955902944 19.273 99 81 161 3 2015844576 35627488 24314144
17:45:02 3144 8192000000 10940993392 11356999680 1966404688 19.357 100 88 176 2 2033426896 40070560 26951648
17:45:13 3177 8192000000 10948011680 11359965184 1963002992 19.330 100 84 167 0 2030074800 41018320 26053488
17:45:23 5309 8192000000 10938899408 11347574784 1947669040 19.208 99 85 167 1 2014889984 41178720 26042224
17:45:37 2416 8192000000 10938266608 11355987968 1957601440 19.287 100 79 157 2 2024481968 42182448 24698080
17:45:47 2699 8192000000 10951720288 11367682048 1963363328 19.333 100 81 163 1 2030751856 41171344 26217184
17:45:58 6203 8192000000 10953318240 11368370176 1969489696 19.381 100 80 160 0 2031044736 37222624 24332416
17:46:12 3439 8192000000 10946831472 11356962816 1959951152 19.306 100 89 177 1 2025480896 38946656 26583088
17:46:23 4098 8192000000 10926928656 11335544832 1925178464 19.028 99 87 174 1 1988007344 36073152 26755728
17:46:34 3499 8192000000 10929842208 11339235328 1949125920 19.220 100 79 157 2 2011195280 38058064 24011296
17:46:44 1396 8192000000 10952256048 11356356608 1964307008 19.340 100 85 171 1 2028021600 38263504 25451088
17:46:52 3922 8192000000 10938792208 11355512832 1962793312 19.328 100 77 154 0 2026660832 40248544 23618976
17:47:06 4301 8192000000 10950281488 11368013824 1968700064 19.375 100 72 143 0 2031781008 40795040 22285904
17:47:19 5855 8192000000 10935066480 11353415680 1950544608 19.231 99 62 122 2 2010426432 40324784 19557040
17:47:32 3171 8192000000 10956524496 11370151936 1968163888 19.371 100 71 142 0 2033470048 42616976 22689184
17:47:43 2884 8192000000 10951312848 11363803136 1958465984 19.294 100 79 158 0 2028939968 46070960 24403024
17:47:52 1503 8192000000 10945628304 11349721088 1943779472 19.177 99 88 178 2 2016576016 44674656 28121888
17:48:03 5600 8192000000 10941358384 11371356160 1959596464 19.303 100 68 137 1 2027562448 45778320 22187664
17:48:15 11711 8192000000 10923947664 11362992128 1943807552 19.177 99 44 87 1 1999268016 41051792 14408672
17:48:36 15737 8192000000 10899818064 11333730304 1904164816 18.860 98 27 54 0 1948728256 34924912 9638528
17:48:58 13836 8192000000 10906910288 11352076288 1942947328 19.170 100 30 60 2 1986213296 33942256 9323712
17:49:19 7369 8192000000 10897554256 11340722176 1947989136 19.210 100 36 72 0 1993071776 32074112 13008528
17:49:35 10905 8192000000 10914939984 11352371200 1953240272 19.252 100 38 76 1 2000101696 34683888 12177536
17:49:54 7299 8192000000 10934059712 11368988672 1960570480 19.311 100 55 110 1 2015060528 37102320 17387728
17:50:25 16558 8192000000 10919635760 11363475456 1936706656 19.120 99 33 66 2 1993054032 45323760 11023616
17:51:00 17078 8192000000 10904493184 11354091520 1934035904 19.099 99 34 68 4 1984031168 38794016 11201248
17:51:30 11979 8192000000 10909123552 11348656128 1927995232 19.051 99 35 70 1 1977617024 38004352 11617440
17:52:09 43186 8192000000 10893304352 11336097792 1901262704 18.836 98 26 52 1 1947397024 37489840 8644480
17:53:01 24832 8192000000 10894650032 11335061504 1914330064 18.941 99 45 90 2 1969701408 41338272 14033072
17:53:52 20738 8192000000 10860901920 11324461056 1913175904 18.932 100 22 44 1 1953799536 33138576 7485056
17:54:32 19966 8192000000 10865376720 11322429440 1914123296 18.940 100 16 32 1 1950802800 31601760 5077744
17:55:24 41566 8192000000 10883491696 11333332992 1922620672 19.008 100 17 33 0 1959704240 31590032 5493536
17:56:13 40906 8192000000 10871195920 11338584064 1917473648 18.967 100 6 12 1 1951570208 32030176 2066384
17:57:05 79103 8192000000 10871213056 11315818496 1887944880 18.729 97 28 57 2 1907992112 11390064 8657168
17:58:30 52174 8192000000 10878823824 11312726016 1884507472 18.701 97 18 36 0 1901981248 11909840 5563936
17:59:30 34899 8192000000 10884201184 11331813376 1940691808 19.152 99 34 66 4 1957819936 7427424 9700704
18:00:21 83193 8192000000 10878820336 11334426624 1890364944 18.749 97 9 18 3 1905710912 12992256 2353712
18:02:05 49601 8192000000 10889131728 11348729856 1934273200 19.101 99 16 32 1 1955829152 17092224 4463728
18:03:21 91152 8192000000 10888587520 11349483520 1939743200 19.145 99 27 52 0 1960343152 13067184 7532768
18:04:59 75163 8192000000 10889978688 11364040704 1958883264 19.297 100 12 25 0 1976802880 14884256 3035360
18:06:23 109177 8192000000 10908464864 11355045888 1956912160 19.281 99 42 84 0 1981568624 12202176 12454288
18:08:30 123404 8192000000 10915669056 11394134016 1977125504 19.442 100 21 41 1 1998720112 15853024 5741584
18:10:41 34202 8192000000 10911245776 11391696896 1981117776 19.474 100 4 8 1 2000855728 18847040 890912
18:11:21 1612 8192000000 10940333824 11372134400 1985176464 19.506 100 59 116 1 2013125536 11382848 16566224
18:11:29 4974 8192000000 10957907760 11390144512 1995326080 19.586 100 81 159 1 2030982768 12150448 23506240
18:11:40 31875 8192000000 10913900048 11383762944 1971485008 19.397 99 25 50 2 1990254848 12078048 6691792
18:12:19 42930 8192000000 10915273760 11373883392 1962875328 19.329 99 19 39 1 1980377520 11943744 5558448
18:13:09 26116 8192000000 10932697360 11388788736 1983856960 19.495 100 26 52 0 2005936368 14311776 7767632
18:13:45 36154 8192000000 10918348592 11379974144 1990471328 19.548 100 50 100 0 2019766880 14548624 14746928
18:14:36 52886 8192000000 10907711056 11379015680 1961800224 19.320 99 17 35 0 1975253424 8586064 4867136
18:15:42 39266 8192000000 10884972560 11360501760 1945224816 19.188 98 9 18 0 1955914976 8222544 2467616
18:16:29 13907 8192000000 10893922512 11367362560 1970797632 19.392 100 5 10 0 1980279424 8136608 1345184
18:17:20 17746 8192000000 10903384512 11374292992 1980716656 19.470 100 15 30 1 1992590288 7406944 4466688
18:17:43 24649 8192000000 10897167392 11370303488 1981057008 19.473 100 19 38 1 1993009632 6487408 5465216
18:18:14 167032 8192000000 10886056416 11363753984 1874624128 18.622 94 17 34 0 1887175328 8105776 4445424
18:21:34 31732 8192000000 10902006416 11382554624 1965259280 19.348 100 23 44 1 1985009760 13320096 6430384
18:23:18 65191 8192000000 10894500880 11387633664 1977597360 19.446 100 6 12 0 1990520576 11360544 1562672
18:24:30 45162 8192000000 10884276480 11354689536 1886939248 18.721 95 12 24 2 1903158544 12873776 3345520
18:25:22 38941 8192000000 10898443664 11366305792 1941004944 19.155 99 24 48 1 1963613072 15054112 7554016
18:26:17 39887 8192000000 10854611168 11334348800 1886474576 18.717 96 19 38 1 1901568336 9862448 5231312
18:27:04 24412 8192000000 10905142256 11350020096 1957878128 19.289 100 49 98 2 1978711392 7793968 13039296
18:27:38 53674 8192000000 10876296880 11343425536 1936755072 19.121 99 25 50 2 1954669760 10755840 7158848
18:28:39 44255 8192000000 10880167344 11337109504 1909501904 18.903 97 11 22 0 1919692816 7357712 2833200
18:29:32 29692 8192000000 10857213328 11322478592 1878506880 18.653 96 24 48 0 1894906640 9721904 6677856
18:30:27 35217 8192000000 10862057152 11318722560 1866762416 18.558 96 23 43 1 1881213440 8602528 5848496
18:31:16 61843 8192000000 10843474128 11310383104 1864907168 18.543 96 22 44 0 1883860320 12255600 6697552
18:32:24 46083 8192000000 10874314688 11325419520 1868073392 18.569 96 25 50 0 1890081552 14839024 7169136
18:33:18 23782 8192000000 10878169760 11326652416 1899825472 18.825 98 40 80 2 1927222272 16533728 10863072
18:33:49 17271 8192000000 10868176848 11313750016 1906424400 18.878 99 49 98 1 1935774096 15646224 13703472
18:34:45 116150 8192000000 10834878400 11295006720 1719398736 17.347 89 21 42 3 1739150864 14162656 5589472
18:36:47 65257 8192000000 10858224400 11308253184 1845568832 18.386 96 23 46 0 1864299632 12565248 6165552
18:38:07 60308 8192000000 10843142768 11312226304 1831402336 18.271 95 18 36 0 1853326288 17164304 4759648
18:39:17 50788 8192000000 10861864624 11311517696 1907091120 18.883 100 11 22 0 1932584656 21589760 3903776
18:40:50 74136 8192000000 10859134448 11319816192 1910302608 18.909 99 30 58 2 1926678096 8348464 8027024
18:42:14 5680 8192000000 10864330416 11320377344 1916610720 18.960 99 41 84 2 1936711696 8704000 11396976
18:42:29 24149 8192000000 10875401088 11335577600 1933317344 19.093 100 34 68 1 1956209568 13328784 9563440
18:42:59 66130 8192000000 10859800176 11339251712 1937019840 19.123 100 18 36 2 1957511824 14764960 5727024
18:44:17 35995 8192000000 10865571648 11344203776 1945878800 19.194 100 10 20 1 1962004416 13231520 2894096
18:45:03 46459 8192000000 10858964688 11328397312 1906099952 18.875 98 13 27 2 1924396800 14333232 3963616
18:45:55 73110 8192000000 10863056576 11339067392 1921399888 18.998 99 17 35 0 1940913616 14458032 5055696
18:47:23 58983 8192000000 10858566288 11320365056 1887287952 18.724 97 14 27 0 1897999360 6840976 3870432
18:48:28 37226 8192000000 10859102592 11326300160 1935860624 19.114 100 15 28 0 1949142576 9739984 3541968
18:49:11 57279 8192000000 10823537920 11295256576 1857108496 18.480 96 14 28 0 1869262928 8216128 3938304
18:50:49 45991 8192000000 10848302576 11328778240 1930910784 19.074 100 8 17 0 1940687232 7094496 2681952
18:51:44 41397 8192000000 10870442608 11348590592 1952615856 19.247 100 16 32 1 1966026160 8851968 4558336
18:52:51 26237 8192000000 10890634352 11355193344 1963951776 19.337 100 37 74 1 1983033184 8513984 10567424
18:53:23 33480 8192000000 10882951952 11357392896 1957724864 19.288 100 22 44 1 1973564848 9130208 6709776
18:54:10 60174 8192000000 10895257872 11369312256 1948829248 19.217 99 14 28 0 1965418224 12238656 4350320
18:55:23 43932 8192000000 10907865824 11373920256 1973857408 19.416 100 15 30 0 1987987168 9758832 4370928
18:56:13 47291 8192000000 10921974448 11387416576 1986900640 19.519 100 27 53 0 2007483872 12901104 7682128
18:57:07 65834 8192000000 10920152560 11405041664 1993106784 19.568 100 19 38 2 2014456560 15967760 5382016
18:58:19 95401 8192000000 10919316400 11395194880 1937097952 19.124 97 15 30 0 1952569344 11449792 4021600
19:00:01 87114 8192000000 10907854240 11375980544 1898494304 18.814 95 23 46 1 1918430352 14076864 5859184
19:01:35 29581 8192000000 10933702800 11391631360 1968352848 19.372 99 29 58 1 1986386048 10484416 7548784
19:02:16 85894 8192000000 10915032832 11389358080 1929650464 19.064 97 15 30 0 1942544720 8994176 3900080
19:03:48 39173 8192000000 10956305408 11404648448 2000863312 19.630 100 36 72 1 2026112048 13838576 11410160
19:04:36 27496 8192000000 10954850080 11410944000 1986698720 19.518 99 46 92 2 2013139456 13468624 12972112
19:05:16 119683 8192000000 10920828320 11396853760 1962156688 19.323 98 19 38 0 1982598032 15387584 5053760
19:07:22 42972 8192000000 10911053680 11378163712 1974123328 19.418 99 32 64 2 1990777680 7888528 8765824
19:08:12 12655 8192000000 10924002640 11390935040 1992000768 19.560 100 55 106 1 2016329824 9595248 14733808
19:08:37 19949 8192000000 10896608336 11382923264 1987101472 19.521 100 16 32 1 1996930704 4988880 4840352
19:09:04 70535 8192000000 10895200048 11376197632 1975852848 19.432 99 4 8 0 1983524112 6653024 1018240
19:11:58 80730 8192000000 10881017056 11353874432 1935376576 19.110 98 19 38 1 1950426560 9788496 5261488
19:13:45 73545 8192000000 10860870560 11343081472 1893776432 18.776 97 13 26 2 1911824896 14121408 3927056
19:15:06 58876 8192000000 10884883008 11350564864 1917270816 18.965 98 17 34 0 1929786528 8186608 4329104
19:16:14 26417 8192000000 10860468672 11329679360 1911367904 18.918 98 21 41 0 1924428304 7479056 5581344
19:17:35 28173 8192000000 10874132496 11340861440 1943434992 19.174 100 28 56 4 1963815200 12608560 7771648
19:18:12 37650 8192000000 10892030208 11353071616 1953122480 19.251 100 31 62 1 1976342384 14323920 8895984
19:18:59 36500 8192000000 10897458112 11374010368 1964768864 19.344 100 26 52 3 1994383152 21979120 7635168
19:19:44 84771 8192000000 10892633776 11361730560 1905721904 18.872 97 18 36 0 1927543504 16361376 5460224
19:21:19 87718 8192000000 10865238512 11342438400 1869711680 18.582 95 16 32 5 1889271168 15433888 4125600
19:22:54 89772 8192000000 10875297552 11336105984 1853568592 18.451 95 30 60 0 1871813136 9127472 9117072
19:24:30 84353 8192000000 10853611552 11326214144 1831308192 18.270 94 26 52 1 1851739712 13008096 7423424
19:26:19 61198 8192000000 9045050656 9247531008 183199440 2.187 10 1 2 0 184375152 1113584 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-01-2021 19:28:09 to 24-01-2021 19:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 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 24-01-2021 19:28:42 to 24-01-2021 19:28:44.

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          251091
MON$OLDEST_ACTIVE               251092
MON$OLDEST_SNAPSHOT             251092
MON$NEXT_TRANSACTION            251092
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                       2037664
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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'

24.01.21 19:28:45. 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-24 19:28:47 No severe PSQL-related problems occured
24.01.21 19:28:49. End of report.