Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.02.2021 19:28
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 16981732 kB
MemAvailable 31078040 kB
Buffers 0 kB
Cached 14707020 kB
SwapCached 3280 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-02-28 19:27:21
DTS_END                         2021-02-28 19:27:21.3630
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/41310
TRN_ID                          240851
ATT_ID                          704
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: 9441.76 23101 1133011
customer order: creation 170.10 383 20412
customer order: refuse 14.82 332 1778
order to supplier: creation 45.86 1279 5503
order to supplier: removal 3.51 97175 421
invoice (draft): creation 45.17 3388 5420
invoice (draft): removal 53.11 728 6373
invoice accept: apply 41.69 16629 5003
invoice accept: cancel 48.42 855 5810
customer reserve: creation 3923.67 160 470840
customer reserve: removal 4799.05 55 575886
realization accept: apply 81.53 211 9784
realization accept: cancel 86.67 107 10400
payment from customer: creation 58.38 148 7006
payment from customer: removal 5.98 83 717
payment to supplier: creation 48.57 150 5828
payment to supplier: removal 3.54 75 425
service: total inventory turnovers 4.52 1142 542
service: total monetary turnovers 6.37 30 764
service: aggregate perf. data 0.79 17238 95
service: refresh index statistics 0.03 321861 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-02-2021 19:28:40 to 28-02-2021 19:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2831
TEST_TIME 2 3421
TEST_TIME 3 2462
TEST_TIME 4 3188
TEST_TIME 5 3851
TEST_TIME 6 3674
TEST_TIME 7 4038
TEST_TIME 8 4142
TEST_TIME 9 5000
TEST_TIME 10 5698
TEST_TIME 11 6021
TEST_TIME 12 5981
TEST_TIME 13 6350
TEST_TIME 14 6490
TEST_TIME 15 6635
TEST_TIME 16 6871
TEST_TIME 17 7277
TEST_TIME 18 7376
TEST_TIME 19 7355
TEST_TIME 20 8210
TEST_TIME 21 8553
TEST_TIME 22 8838
TEST_TIME 23 8999
TEST_TIME 24 9417
TEST_TIME 25 9607
TEST_TIME 26 9952
TEST_TIME 27 10112
TEST_TIME 28 10288
TEST_TIME 29 10142
TEST_TIME 30 10149
TEST_TIME 31 10117
TEST_TIME 32 9999
TEST_TIME 33 10140
TEST_TIME 34 10083
TEST_TIME 35 10031
TEST_TIME 36 10250
TEST_TIME 37 10184
TEST_TIME 38 10281
TEST_TIME 39 10089
TEST_TIME 40 9901
TEST_TIME 41 9817
TEST_TIME 42 9811
TEST_TIME 43 9809
TEST_TIME 44 9758
TEST_TIME 45 9725
TEST_TIME 46 9673
TEST_TIME 47 9913
TEST_TIME 48 9820
TEST_TIME 49 9700
TEST_TIME 50 9704
TEST_TIME 51 9612
TEST_TIME 52 9601
TEST_TIME 53 9729
TEST_TIME 54 9644
TEST_TIME 55 9638
TEST_TIME 56 9648
TEST_TIME 57 9701
TEST_TIME 58 9718
TEST_TIME 59 9656
TEST_TIME 60 9633
TEST_TIME 61 9815
TEST_TIME 62 9843
TEST_TIME 63 9853
TEST_TIME 64 9959
TEST_TIME 65 9948
TEST_TIME 66 9868
TEST_TIME 67 9797
TEST_TIME 68 9850
TEST_TIME 69 9758
TEST_TIME 70 9704
TEST_TIME 71 9666
TEST_TIME 72 9609
TEST_TIME 73 9602
TEST_TIME 74 9569
TEST_TIME 75 9583
TEST_TIME 76 9550
TEST_TIME 77 9598
TEST_TIME 78 9554
TEST_TIME 79 9608
TEST_TIME 80 9594
TEST_TIME 81 9663
TEST_TIME 82 9667
TEST_TIME 83 9695
TEST_TIME 84 9718
TEST_TIME 85 9706
TEST_TIME 86 9823
TEST_TIME 87 9845
TEST_TIME 88 9853
TEST_TIME 89 9778
TEST_TIME 90 9699
TEST_TIME 91 9728
TEST_TIME 92 9706
TEST_TIME 93 9731
TEST_TIME 94 9713
TEST_TIME 95 9655
TEST_TIME 96 9620
TEST_TIME 97 9631
TEST_TIME 98 9601
TEST_TIME 99 9563
TEST_TIME 100 9571
TEST_TIME 101 9597
TEST_TIME 102 9577
TEST_TIME 103 9671
TEST_TIME 104 9662
TEST_TIME 105 9657
TEST_TIME 106 9685
TEST_TIME 107 9689
TEST_TIME 108 9719
TEST_TIME 109 9719
TEST_TIME 110 9727
TEST_TIME 111 9718
TEST_TIME 112 9646
TEST_TIME 113 9591
TEST_TIME 114 9574
TEST_TIME 115 9526
TEST_TIME 116 9516
TEST_TIME 117 9487
TEST_TIME 118 9459
TEST_TIME 119 9486
TEST_TIME 120 9443

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-02-2021 19:28:44 to 28-02-2021 19:28:47.

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 1568864 1568864 0 0.00 0 30699 6 0 0
doc_list_biud 1568864 1568864 0 0.00 0 63299 26 0 0
sp_add_invoice_to_stock 5154 5003 151 2.92 46 195420 16630 0 151
sp_cancel_adding_invoice 5810 5810 0 0.00 5 82175 855 0 0
sp_cancel_client_order 1778 1778 0 0.00 4 18641 333 0 0
sp_cancel_customer_reserve 575886 575886 0 0.00 1 63301 56 0 0
sp_cancel_pay_from_customer 717 717 0 0.00 2 4750 83 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 2 2332 76 0 0
sp_cancel_supplier_invoice 6378 6373 5 0.07 1 17777 729 0 5
sp_cancel_supplier_order 421 421 0 0.00 11 972356 97175 0 0
sp_cancel_write_off 10400 10400 0 0.00 1 13752 108 0 0
sp_client_order 20412 20412 0 0.00 3 60883 384 0 0
sp_customer_reserve 470840 470840 0 0.00 0 106764 161 0 0
sp_fill_shopping_cart 31325 31325 0 0.00 1 12148 35 0 0
sp_fill_shopping_cart_clo_res 470837 470837 0 0.00 0 21939 14 0 0
sp_get_clo_for_invoice 5000 5000 0 0.00 0 24784 276 0 0
sp_kill_cost_storno 17352 17352 0 0.00 0 30691 62 0 0
sp_kill_qstorno_ret_qs2qd 1168966 1168966 0 0.00 0 63273 30 0 0
sp_kill_qty_storno 615452 615452 0 0.00 0 63299 65 0 0
sp_lock_selected_doc 20646 20646 0 0.00 0 9550 7 0 0
sp_make_cost_storno 27618 27618 0 0.00 0 24272 67 0 0
sp_multiply_rows_for_pdistr 27618 27618 0 0.00 0 19969 31 0 0
sp_multiply_rows_for_qdistr 20412 20412 0 0.00 0 60873 181 0 0
sp_pay_from_customer 7006 7006 0 0.00 4 20355 148 0 0
sp_pay_to_supplier 5828 5828 0 0.00 5 16412 151 0 0
sp_payment_common 12834 12834 0 0.00 1 20303 52 0 0
sp_qd_handle_on_cancel_clo 1778 1778 0 0.00 0 18633 302 0 0
sp_qd_handle_on_invoice_upd_sts 10810 10810 0 0.00 0 22051 333 0 0
sp_qd_handle_on_reserve_upd_sts 9784 9784 0 0.00 0 18289 65 0 0
sp_reserve_write_off 9784 9784 0 0.00 6 21505 212 0 0
sp_supplier_invoice 5420 5420 0 0.00 5 77779 3388 0 0
sp_supplier_order 5503 5503 0 0.00 4 67967 1280 0 0
srv_aggregate_perf_data 95 95 0 0.00 2992 135609 17239 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1213 151631 33401 0 0
srv_find_qd_qs_mism 1085175 1085175 0 0.00 0 22275 5 0 0
srv_make_invnt_saldo 542 542 0 0.00 49 46277 1143 0 0
srv_make_money_saldo 764 764 0 0.00 1 2860 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 223955 470683 321861 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 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 5003 5003 0 0.00 0 9878 176 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 3856 138 0 0
t$perf-norm:sp_cancel_client_order 1778 1778 0 0.00 0 760 8 0 0
t$perf-norm:sp_cancel_customer_reserve 696 696 0 0.00 0 2705 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 717 717 0 0.00 0 790 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 2936 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 8646 49 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 24735 1536 0 0
t$perf-norm:sp_cancel_write_off 1013 1013 0 0.00 0 5774 15 0 0
t$perf-norm:sp_client_order 20412 20412 0 0.00 0 7902 20 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 4493 9 0 0
t$perf-norm:sp_pay_from_customer 7006 7006 0 0.00 0 5044 8 0 0
t$perf-norm:sp_pay_to_supplier 5828 5828 0 0.00 0 8449 12 0 0
t$perf-norm:sp_reserve_write_off 9784 9784 0 0.00 0 11756 12 0 0
t$perf-norm:sp_supplier_invoice 5420 5420 0 0.00 0 3965 17 0 0
t$perf-norm:sp_supplier_order 5503 5503 0 0.00 0 5839 16 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 648 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1529 27 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 1016 24 0 0
t$perf-norm:srv_make_money_saldo 764 764 0 0.00 0 4177 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10302 10000 302 2.93 0 7157 19 0 302
v_all_customers 37476 37476 0 0.00 0 22 1 0 0
v_all_suppliers 30562 30562 0 0.00 0 25 1 0 0
v_all_wares 40824 40824 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 1984 12 0 0
v_cancel_client_order 3556 3556 0 0.00 0 3662 5 0 0
v_cancel_customer_prepayment 1434 1434 0 0.00 0 2262 6 0 0
v_cancel_customer_reserve 1392 1392 0 0.00 0 4103 7 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 2277 10 0 0
v_cancel_supplier_invoice 798 788 10 1.25 0 3657 16 0 10
v_cancel_supplier_order 842 842 0 0.00 0 1914 6 0 0
v_cancel_write_off 2026 2026 0 0.00 0 13506 19 0 0
v_max_id_clo_ord 5500 5500 0 0.00 0 1481 1 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 9973 33 0 0
v_max_id_ord_sup 5412 5412 0 0.00 0 2478 2 0 0
v_max_non_paid_invoice 1459 1459 0 0.00 0 355 3 0 0
v_max_non_paid_realizn 3583 3583 0 0.00 0 5024 5 0 0
v_min_id_clo_ord 5500 5500 0 0.00 0 7742 9 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 12163 39 0 0
v_min_id_ord_sup 5412 5412 0 0.00 0 5855 7 0 0
v_min_non_paid_invoice 5828 5828 0 0.00 0 15889 37 0 0
v_min_non_paid_realizn 7006 7006 0 0.00 0 19803 40 0 0
v_our_firm 10194 10194 0 0.00 0 16 1 0 0
v_reserve_write_off 19568 19568 0 0.00 0 13502 7 0 0
x_lock_depdocs_on_canc_invoice 11789 11789 0 0.00 0 17059 124 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 24592 470 0 0
x_make_qstorno_1000_1200 5503 5503 0 0.00 1 67942 1199 0 0
x_make_qstorno_1200_2000 5420 5420 0 0.00 3 75578 3272 0 0
x_make_qstorno_2100_3300 470840 470840 0 0.00 0 106761 145 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-02-2021 19:28:48 to 28-02-2021 19:28:52.

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:25 5 8192000000 8800926816 8812138496 6918096 0.084 2 1 2 0 7037472 56816 62560
16:57:31 21977 8192000000 10247712608 10555224064 809723984 8.995 64 48 97 0 827914000 2216880 15973136
16:58:01 38756 8192000000 10353402496 10673766400 1404785632 14.638 100 89 178 0 1438862400 5194336 28882432
16:58:48 23165 8192000000 10390167920 10718494720 1447969456 15.020 100 90 180 0 1483912144 6171456 29771232
16:59:20 29963 8192000000 10437760576 10766200832 1480727744 15.308 100 89 178 0 1516041696 6925040 28388912
16:59:58 21973 8192000000 10445484720 10775658496 1500494256 15.480 100 91 182 0 1537951024 7802288 29654480
17:00:28 13935 8192000000 10457622544 10790055936 1512361904 15.584 100 86 172 1 1548541488 8303296 27876288
17:00:49 19772 8192000000 10471606352 10808840192 1521306208 15.662 100 86 172 1 1557268880 8399840 27562832
17:01:19 26338 8192000000 10492985536 10836017152 1549538944 15.906 100 87 174 1 1585585072 8986128 27060000
17:02:07 17673 8192000000 10548389840 10899333120 1595132128 16.298 100 81 162 0 1629440800 9903536 24405136
17:02:33 17140 8192000000 10569454416 10928549888 1627750512 16.576 100 73 145 1 1658821744 9905856 21165376
17:02:59 14964 8192000000 10610674912 10969243648 1657232688 16.826 100 81 162 0 1692546896 10772976 24541232
17:03:25 11757 8192000000 10627354256 10991280128 1685932880 17.067 100 82 162 2 1721120288 11310304 23877104
17:03:46 12237 8192000000 10636555296 11005861888 1699779840 17.183 100 81 162 2 1735696640 12071472 23845328
17:04:12 8843 8192000000 10663284912 11029762048 1712705936 17.291 100 79 158 1 1748159648 12141808 23311904
17:04:30 10706 8192000000 10667546976 11042283520 1724898176 17.393 100 82 164 1 1760691616 11666240 24127200
17:04:48 7892 8192000000 10678121888 11058675712 1745729520 17.566 100 79 158 1 1780092848 11702640 22660688
17:05:02 6921 8192000000 10692444400 11071561728 1760102880 17.685 100 81 158 1 1795079504 11799856 23176768
17:05:18 6667 8192000000 10710318480 11090726912 1769587376 17.764 100 73 146 0 1802531232 12093232 20850624
17:05:30 6562 8192000000 10718291744 11100491776 1781868656 17.865 100 80 159 2 1816698224 12152608 22676960
17:05:45 4582 8192000000 10722879040 11107090432 1790142720 17.933 100 73 146 1 1822936384 12040496 20753168
17:05:56 4709 8192000000 10738838544 11122188288 1800508336 18.018 100 75 147 2 1832622240 11544864 20569040
17:06:08 3891 8192000000 10732404640 11124334592 1803138688 18.040 100 65 129 0 1833022400 11544400 18339312
17:06:19 3436 8192000000 10760133600 11140694016 1816013568 18.145 100 84 164 3 1851133440 12278416 22841456
17:06:29 14090 8192000000 10756101584 11145646080 1819714640 18.175 100 77 152 2 1854328912 13403168 21211104
17:06:51 2637 8192000000 10771009888 11161579520 1832723264 18.282 100 84 168 0 1869719360 13698496 23297600
17:07:00 3372 8192000000 10783958032 11168751616 1840610240 18.346 100 83 166 2 1877521536 13749056 23162240
17:07:10 3792 8192000000 10782582592 11170164736 1843574656 18.370 100 93 187 0 1883342656 13658592 26109408
17:07:21 2766 8192000000 10788655776 11174408192 1843685920 18.371 100 85 170 1 1880721728 13502400 23533408
17:07:30 3360 8192000000 10792633696 11183722496 1850863088 18.429 100 90 182 1 1889307232 13440848 25003296
17:07:40 2539 8192000000 10794931120 11183931392 1858141792 18.488 100 92 183 2 1897378320 14074736 25161792
17:07:49 2128 8192000000 10803470736 11190665216 1858297856 18.489 100 89 176 1 1898177456 14815920 25063680
17:07:58 1436 8192000000 10809089488 11195924480 1857870464 18.486 100 94 187 4 1897882000 14270912 25740624
17:08:06 1849 8192000000 10802280288 11190915072 1862101120 18.520 100 93 184 1 1903100464 14411968 26587376
17:08:15 1189 8192000000 10799840064 11191148544 1862724256 18.525 100 94 188 1 1901670704 13058784 25887664
17:08:22 1505 8192000000 10807482064 11194814464 1866543568 18.556 100 92 185 5 1906263248 13541856 26177824
17:08:30 1894 8192000000 10801858048 11193479168 1863128720 18.529 100 90 180 3 1900293664 11296144 25868800
17:08:38 1779 8192000000 10809540816 11200086016 1865461632 18.548 100 91 181 2 1903320576 12455232 25403712
17:08:46 1387 8192000000 10814856560 11202240512 1870022080 18.584 100 98 198 2 1910010064 13157424 26830560
17:08:54 1414 8192000000 10816802784 11203633152 1869137152 18.577 100 97 195 2 1910952352 14183712 27631488
17:09:02 2701 8192000000 10818823824 11209134080 1870267856 18.586 100 84 168 0 1908290224 14490560 23531808
17:09:11 2563 8192000000 10819368864 11210596352 1874870864 18.624 100 96 192 2 1917490256 15671040 26948352
17:09:21 1659 8192000000 10824364464 11212419072 1876649664 18.638 100 88 176 1 1915808816 13667232 25491920
17:09:29 8394 8192000000 10822016720 11213193216 1876425808 18.636 100 89 178 0 1915680576 13686640 25568128
17:09:44 1797 8192000000 10822075680 11210891264 1878238032 18.651 100 90 181 3 1915833120 12792976 24802112
17:09:52 2397 8192000000 10811233200 11207688192 1876654240 18.638 100 72 142 1 1908842272 11986288 20201744
17:10:07 26784 8192000000 10779181536 11207778304 1874906624 18.624 100 45 90 1 1897420432 9961728 12552080
17:10:44 8921 8192000000 10798128336 11215060992 1876289104 18.635 100 36 72 0 1894172192 7820352 10062736
17:11:01 4098 8192000000 10788747600 11211894784 1881170736 18.675 100 52 104 2 1904010864 8231040 14609088
17:11:20 5883 8192000000 10795875216 11216482304 1878232784 18.651 100 29 57 2 1892718096 6033056 8452256
17:11:34 6055 8192000000 10781869376 11216752640 1880537056 18.669 100 25 50 1 1895535152 7470048 7528048
17:11:46 4978 8192000000 10791309216 11218137088 1882720320 18.687 100 29 57 0 1896579200 5273584 8585296
17:12:01 5530 8192000000 10800966480 11226230784 1886250848 18.716 100 27 54 1 1900185664 6640144 7294672
17:12:16 9722 8192000000 10791667696 11223785472 1885744880 18.711 100 15 29 3 1895925680 5747424 4433376
17:12:34 3992 8192000000 10798007408 11228971008 1888789424 18.736 100 32 63 3 1905013616 6937968 9286224
17:12:44 8483 8192000000 10795749856 11231113216 1890501904 18.750 100 24 48 0 1908044112 10827056 6715152
17:12:59 7652 8192000000 10803207136 11230691328 1894255248 18.780 100 34 68 0 1910733728 6462576 10015904
17:13:14 10759 8192000000 10797779744 11232550912 1892624128 18.767 100 19 38 1 1903321392 5304624 5392640
17:13:35 11346 8192000000 10799599552 11233157120 1896332672 18.797 100 17 34 1 1907050064 6049728 4667664
17:13:57 4760 8192000000 10812825232 11243692032 1900486512 18.830 100 29 58 1 1919018336 9551424 8980400
17:14:09 73983 8192000000 10810987440 11247419392 1902348384 18.845 100 23 45 0 1913980768 5664176 5968208
17:15:29 8022 8192000000 10824454224 11250745344 1904296768 18.861 100 28 56 2 1919619232 5973104 9349360
17:15:45 5858 8192000000 10832488640 11254693888 1905336640 18.869 100 34 68 0 1922966320 7862016 9767664
17:15:59 4009 8192000000 10824262576 11253833728 1905137872 18.868 100 35 70 3 1922901776 7645776 10118128
17:16:11 5025 8192000000 10805933008 11235098624 1881327312 18.676 99 23 46 2 1893362416 5878208 6156896
17:16:22 7252 8192000000 10813061840 11243020288 1880478800 18.669 99 22 44 0 1893260528 6668768 6112960
17:16:40 6616 8192000000 10806531024 11232710656 1888586176 18.734 100 36 71 0 1906124736 7730720 9807840
17:16:53 6746 8192000000 10811100928 11244707840 1896413088 18.797 100 34 66 3 1916844432 10799920 9631424
17:17:09 11529 8192000000 10762806096 11182166016 1816824256 18.152 96 23 42 0 1827815936 5028272 5963408
17:17:27 9166 8192000000 10788817904 11202945024 1846914608 18.397 99 14 27 0 1854980976 4476080 3590288
17:17:42 9792 8192000000 10766764576 11198472192 1827936608 18.242 98 18 36 2 1843146576 10052768 5157200
17:17:58 8636 8192000000 10753320832 11185143808 1808510208 18.084 97 16 32 1 1819156224 5998288 4647728
17:18:13 8571 8192000000 10756859456 11184115712 1842736496 18.363 99 18 35 3 1853134736 5238848 5159392
17:18:28 5515 8192000000 10746014848 11175464960 1814451744 18.132 98 19 38 2 1825564144 5350976 5761424
17:18:40 49359 8192000000 10709993632 11121709056 1719706544 17.350 93 30 59 3 1733669392 5274176 8688672
17:19:35 25107 8192000000 10719179152 11144056832 1734088592 17.470 95 20 39 0 1744237344 4516224 5632528
17:20:07 7203 8192000000 10743893152 11156418560 1785122912 17.892 98 46 92 0 1806230704 8163968 12943824
17:20:23 5850 8192000000 10713066992 11130478592 1781247904 17.860 99 39 78 3 1799432272 7524448 10659920
17:20:37 2291 8192000000 10746192976 11140096000 1801511280 18.026 100 56 114 0 1829711856 11084080 17116496
17:20:46 5885 8192000000 10731342864 11144429568 1797172688 17.991 99 33 64 1 1813645488 6972752 9500048
17:21:00 9030 8192000000 10709857984 11116986368 1752123312 17.619 97 20 41 1 1763724976 5484032 6117632
17:21:16 8319 8192000000 10696817776 11101347840 1704066640 17.219 95 28 56 0 1722625216 9675808 8882768
17:21:31 5487 8192000000 10702379088 11116482560 1760554336 17.689 98 34 63 3 1774906256 5332736 9019184
17:21:44 6163 8192000000 10710851504 11131785216 1766835792 17.741 98 17 35 1 1778034640 5630640 5568208
17:22:00 9465 8192000000 10702844656 11107540992 1734725536 17.475 97 24 48 1 1747235072 5250064 7259472
17:22:15 7462 8192000000 10724192192 11136737280 1801819520 18.029 100 28 57 0 1816049808 5970624 8259664
17:22:33 8604 8192000000 10729828064 11134963712 1776312560 17.819 98 27 53 2 1789974144 5794336 7867248
17:22:48 13598 8192000000 10734419296 11146575872 1790566512 17.936 99 17 32 2 1800203584 4947056 4690016
17:23:10 68374 8192000000 10745740640 11165691904 1807262144 18.073 99 21 38 1 1817448336 4278544 5907648
17:24:27 10532 8192000000 10757904272 11183104000 1838102320 18.325 100 22 43 2 1849406784 5345792 5958672
17:24:44 8735 8192000000 10751665296 11182903296 1841120672 18.350 100 23 47 1 1852725344 4715664 6889008
17:25:02 6931 8192000000 10765776128 11189313536 1846313168 18.392 100 31 63 0 1861352832 6021056 9018608
17:25:15 8262 8192000000 10755986672 11186999296 1847138000 18.399 100 18 36 2 1858356464 6116480 5101984
17:25:29 13121 8192000000 10769587536 11200540672 1852985632 18.446 100 17 34 0 1863057248 5130224 4941392
17:25:49 10445 8192000000 10771649184 11200610304 1857532272 18.483 100 22 44 1 1869279936 5437728 6309936
17:26:05 8792 8192000000 10772408000 11207790592 1863048576 18.528 100 24 45 1 1876481504 5771904 7661024
17:26:20 19032 8192000000 10782829712 11210731520 1865292528 18.546 100 10 20 0 1873263248 5504656 2466064
17:26:48 10703 8192000000 10786008816 11218313216 1870823216 18.591 100 20 40 2 1881659936 5103392 5733328
17:27:04 7961 8192000000 10805408688 11232182272 1883301072 18.692 100 23 46 2 1895657216 5378416 6977728
17:27:18 52513 8192000000 10823897600 11252101120 1897384896 18.805 100 25 49 2 1909449920 5104976 6960048
17:28:18 11572 8192000000 10840866960 11264782336 1915427536 18.950 100 46 90 4 1935179040 6774448 12977056
17:28:42 13900 8192000000 10844780336 11270217728 1920614112 18.992 100 35 68 1 1937658288 7673840 9370336
17:29:05 26847 8192000000 10855108256 11282243584 1927685424 19.048 100 40 80 3 1950902304 10353232 12863648
17:29:58 91315 8192000000 10872160992 11309309952 1940010464 19.147 100 38 75 1 1963966096 13451760 10503872
17:31:37 18492 8192000000 10873461424 11308896256 1946625168 19.200 100 32 62 3 1971839744 15857776 9356800
17:32:10 47186 8192000000 10861735152 11308355584 1930255664 19.069 99 24 46 2 1955565328 17928000 7381664
17:33:04 68612 8192000000 10882534048 11315630080 1933722944 19.097 99 25 48 2 1969155056 27502784 7929328
17:34:28 9284 8192000000 10902883872 11336691712 1956211440 19.276 100 34 68 1 1991126176 23733856 11180880
17:34:44 10178 8192000000 10899691520 11333812224 1958647968 19.295 100 40 81 0 1994613680 23748800 12216912
17:35:04 6087 8192000000 10918663360 11338944512 1958648384 19.295 100 60 120 1 2000980144 23414112 18917648
17:35:17 15994 8192000000 10907785072 11343187968 1965776032 19.352 100 50 98 1 2007068224 25547024 15745168
17:35:45 13304 8192000000 10924899888 11344138240 1948709632 19.216 99 60 118 2 1993366800 27127200 17529968
17:36:07 7141 8192000000 10938168944 11356672000 1971453200 19.397 100 62 124 0 2019640560 28873072 19314288
17:36:24 5402 8192000000 10938836176 11362340864 1979095808 19.458 100 59 117 3 2024312096 27379872 17836416
17:36:36 4247 8192000000 10938693952 11366481920 1980697200 19.470 100 57 114 1 2027160272 29238544 17224528
17:36:52 12112 8192000000 10955170240 11378487296 1986857056 19.519 100 62 124 1 2036599328 30810640 18931632
17:37:16 3706 8192000000 10944989264 11375214592 1992724112 19.565 100 66 132 1 2040483248 26014720 21744416
17:37:29 5355 8192000000 10943500096 11375865856 1993940384 19.575 100 63 125 0 2040644640 27212560 19491696
17:37:44 6291 8192000000 10945602432 11366715392 1979634432 19.462 99 79 156 1 2028129712 25294144 23201136
17:38:01 6197 8192000000 10938101664 11370901504 1984715600 19.502 100 68 136 2 2033447120 27978496 20753024
17:38:15 6694 8192000000 10961065904 11389562880 1999710928 19.620 100 64 128 1 2044192640 25011424 19470288
17:38:30 7583 8192000000 10941450672 11365404672 1984411120 19.500 99 58 115 2 2026426272 24799440 17215712
17:38:48 5362 8192000000 10960194224 11390148608 2000506496 19.627 100 54 108 0 2042893072 25848096 16538480
17:39:00 10319 8192000000 10977157984 11399094272 2012144688 19.718 100 65 130 1 2059840560 27208096 20487776
17:39:19 2381 8192000000 10961505424 11384537088 1994073008 19.576 99 76 149 1 2045257824 28057792 23127024
17:39:29 4312 8192000000 10967772240 11383701504 1983247856 19.490 99 81 163 1 2037905440 30053104 24604480
17:39:41 3649 8192000000 10966029840 11385540608 1994282320 19.578 100 77 154 2 2048817744 31173824 23361600
17:39:51 3468 8192000000 10970654208 11390738432 2000859808 19.630 100 80 160 1 2057441824 32486560 24095456
17:40:02 3816 8192000000 10966627440 11388674048 1999357760 19.618 100 85 170 0 2056873232 31466064 26049408
17:40:13 4240 8192000000 10946851024 11362295808 1981004896 19.473 99 80 157 2 2030222192 26249824 22967472
17:40:25 1212 8192000000 10969862176 11388715008 1999371504 19.618 100 80 159 2 2050181216 26482304 24327408
17:40:35 1855 8192000000 10965349376 11387133952 2000549376 19.627 100 80 158 3 2051541936 26789520 24203040
17:40:44 2549 8192000000 10964388688 11388915712 2000534336 19.627 100 80 160 0 2052146208 27124880 24486992
17:40:54 4521 8192000000 10966032240 11385032704 1984544288 19.501 99 82 164 0 2036548320 27509376 24494656
17:41:06 4975 8192000000 10966534736 11387584512 2001216672 19.632 100 76 150 3 2053292640 28488448 23587520
17:41:28 4267 8192000000 10950851600 11370770432 1979932368 19.464 100 74 146 3 2032414816 29917920 22564528
17:41:41 4637 8192000000 10944945008 11368144896 1978476080 19.453 100 67 134 3 2027754784 28546736 20731968
17:41:53 3688 8192000000 10952987824 11380191232 1986900192 19.519 100 69 136 1 2037388496 29353408 21134896
17:42:10 3012 8192000000 10971320592 11380256768 1989961712 19.543 100 84 166 1 2044088064 29592704 24533648
17:42:21 3457 8192000000 10955858304 11371118592 1983617568 19.493 99 89 178 1 2043171776 32249328 27304880
17:42:33 2425 8192000000 10969810704 11386961920 1991119040 19.553 100 91 180 3 2050621824 31764768 27738016
17:42:42 9671 8192000000 10969762880 11392970752 1997338048 19.602 100 69 138 2 2052154208 33661776 21154384
17:42:59 5936 8192000000 10962984128 11387293696 1996651568 19.596 100 84 170 1 2056307968 33068640 26587760
17:43:12 1749 8192000000 10968975008 11388096512 1991423632 19.555 100 87 174 0 2052600816 34380976 26796208
17:43:27 9365 8192000000 10963492672 11388559360 1988922192 19.535 100 65 129 0 2041721296 32784496 20014608
17:43:43 2034 8192000000 10972341440 11384754176 1990821024 19.550 100 92 181 3 2051368432 32663104 27884304
17:43:52 6924 8192000000 10971627904 11388518400 1991034320 19.552 100 81 162 2 2051150096 34362240 25753536
17:44:08 2449 8192000000 10973594400 11390443520 1993830944 19.574 100 90 180 1 2058164544 35766112 28567488
17:44:18 5097 8192000000 10967173648 11380953088 1984385408 19.499 100 80 154 0 2045599152 37036912 24176832
17:44:33 3275 8192000000 10973256896 11388452864 1988317200 19.530 100 85 170 2 2052788624 38115424 26356000
17:44:44 3886 8192000000 10959790112 11381096448 1982833920 19.487 100 69 138 1 2039853440 35423280 21596240
17:44:55 3250 8192000000 10961574352 11381014528 1983991888 19.496 100 83 164 1 2042920112 33499248 25428976
17:45:07 2271 8192000000 10963354976 11377053696 1984469760 19.500 100 78 156 0 2048165264 39078096 24617408
17:45:15 2014 8192000000 10959160496 11375964160 1965246704 19.348 99 89 175 2 2029553776 36711024 27596048
17:45:26 5376 8192000000 10958235520 11376984064 1975415872 19.428 100 90 177 2 2040902064 37571056 27915136
17:45:38 1813 8192000000 10975910384 11385536512 1983813840 19.495 100 87 173 0 2050652992 39531280 27307872
17:45:47 1529 8192000000 10971328256 11383316480 1981007936 19.473 100 96 189 1 2050469376 40557792 28903648
17:45:57 3613 8192000000 10957902736 11379212288 1965439120 19.349 99 80 158 1 2031158784 40327920 25391744
17:46:07 2006 8192000000 10972205584 11386634240 1979068496 19.457 100 80 159 2 2044708304 40987456 24652352
17:46:17 8793 8192000000 10944562976 11353604096 1952727024 19.248 99 66 131 2 2014582336 41416112 20439200
17:46:34 2967 8192000000 10954552864 11367747584 1952823040 19.249 99 76 148 1 2018938256 43374592 22740624
17:46:45 4543 8192000000 10957111104 11379126272 1977010976 19.441 100 79 156 0 2045782832 44216352 24555504
17:47:00 1501 8192000000 10961668480 11370831872 1968271696 19.372 99 93 186 2 2043899328 45924816 29702816
17:47:07 2596 8192000000 10974400496 11385372672 1979320304 19.459 100 85 169 3 2050937296 44642416 26974576
17:47:21 5791 8192000000 10953821616 11380867072 1974345888 19.420 100 57 113 3 2034379568 41523920 18509760
17:47:33 6836 8192000000 10944842208 11380805632 1971771424 19.399 100 45 90 2 2028783120 42060960 14950736
17:47:49 9675 8192000000 10936262608 11383476224 1977450656 19.445 100 40 80 1 2026687760 36686112 12550992
17:48:17 11346 8192000000 10912951808 11350822912 1942497472 19.167 99 51 102 1 1996595056 37912144 16185440
17:48:35 23750 8192000000 10896950160 11340787712 1930387952 19.070 99 31 60 2 1970916288 30081200 10447136
17:49:08 14101 8192000000 10897853040 11353833472 1948701632 19.216 100 28 56 1 1989146784 30752720 9692432
17:49:29 21666 8192000000 10898159840 11353583616 1949192928 19.220 100 25 50 3 1987797536 29687152 8917456
17:50:00 3754 8192000000 10897695008 11336986624 1937839728 19.130 100 38 77 2 1980842352 30574064 12428560
17:50:26 11511 8192000000 10899720528 11329671168 1907397072 18.886 98 45 89 1 1956614720 33954816 15262832
17:50:59 32232 8192000000 10866545392 11314495488 1895627072 18.791 98 27 54 3 1933024672 27799248 9598352
17:52:07 31307 8192000000 10857066096 11306872832 1857463872 18.483 97 29 58 1 1897592192 30402848 9725472
17:52:44 14186 8192000000 10859227840 11310694400 1900196528 18.828 100 24 48 2 1941074512 33248912 7629072
17:53:09 9962 8192000000 10864559568 11311689728 1911508288 18.919 100 28 56 2 1950609600 29983536 9117776
17:53:26 3533 8192000000 10843084928 11298590720 1900394560 18.829 100 27 54 0 1935411552 27185456 7831536
17:53:39 8738 8192000000 10846689072 11295617024 1894643120 18.783 100 20 40 1 1924765728 24283072 5839536
17:53:54 24371 8192000000 10855586832 11303366656 1911811760 18.921 100 18 36 0 1936426896 19059104 5556032
17:54:25 30113 8192000000 10879220176 11318566912 1924320608 19.021 100 37 75 1 1951681200 16774320 10586272
17:55:03 25579 8192000000 10839957264 11297718272 1877601296 18.646 98 7 14 0 1889385568 9634304 2149968
17:55:36 49514 8192000000 10847924928 11307511808 1896261920 18.796 99 9 18 0 1909656480 11306784 2087776
17:56:45 52192 8192000000 10869482336 11322138624 1917111568 18.964 99 25 49 2 1932221472 7893088 7216816
17:58:14 17908 8192000000 10870794816 11319132160 1918889440 18.978 98 38 71 3 1935087424 6505088 9692896
17:58:44 51842 8192000000 10894270496 11356831744 1936697552 19.120 99 12 24 1 1951344224 11679040 2967632
17:59:42 73286 8192000000 10863390256 11329839104 1851389008 18.433 95 3 6 0 1866721296 14867024 465264
18:01:07 67841 8192000000 10869260816 11330547712 1907827632 18.889 98 13 26 0 1922940480 12162272 2950576
18:02:22 86489 8192000000 10901150080 11377180672 1959849024 19.305 100 21 42 0 1978950208 13316496 5784688
18:03:56 99636 8192000000 10910328288 11374227456 1934077168 19.099 98 12 25 2 1955281280 17988640 3215472
18:05:51 151631 8192000000 10937873392 11399090176 1983990752 19.496 100 24 48 0 2000054752 9344352 6719648
18:08:38 138927 8192000000 10917651616 11390689280 1936879984 19.122 97 18 36 0 1956773264 14565584 5327696
18:11:03 8096 8192000000 10920378912 11399217152 1988920224 19.535 100 7 14 0 2011186976 20055936 2210816
18:11:20 40258 8192000000 10941063728 11395489792 1968968880 19.377 98 49 98 0 2000161792 17199408 13993504
18:12:07 67433 8192000000 10943047120 11406397440 1996955184 19.599 100 27 54 1 2025816528 19283824 9577520
18:13:28 47061 8192000000 10924741520 11404001280 1978282624 19.451 99 17 32 0 2005801920 22786240 4733056
18:14:31 38429 8192000000 10898684016 11396542464 1965370048 19.349 99 13 27 1 1986469952 17251520 3848384
18:15:15 39349 8192000000 10902618288 11383148544 1981829952 19.479 100 16 32 0 2003502064 17181264 4490848
18:16:33 74458 8192000000 10906543520 11383857152 1971045104 19.394 99 10 20 1 1992535264 18345888 3144272
18:17:54 93241 8192000000 10911824192 11395829760 1988584352 19.533 100 18 36 2 2009026048 14972928 5468768
18:19:34 35100 8192000000 10911805504 11402465280 1989748064 19.542 100 11 22 1 2014863056 21894960 3220032
18:20:20 68351 8192000000 10934953904 11400245248 1995602688 19.588 100 10 20 1 2005798800 7764752 2431360
18:21:34 34071 8192000000 10932721440 11407187968 2007388480 19.681 100 14 28 0 2018917920 7616256 3913184
18:22:20 49567 8192000000 10922399008 11393150976 1947417520 19.206 97 29 58 1 1965675184 9823264 8434400
18:23:17 40471 8192000000 10926391200 11393626112 1963580384 19.334 98 28 56 0 1981527232 10284176 7662672
18:24:09 59503 8192000000 10931607024 11403325440 1978288496 19.451 99 11 20 2 1994516208 13559264 2668448
18:25:15 69566 8192000000 10922050368 11396263936 1924030304 19.019 96 19 39 4 1945400608 16020160 5350144
18:26:51 42940 8192000000 10919063936 11391561728 1958875808 19.297 98 21 42 0 1978850688 14095904 5878976
18:27:50 61538 8192000000 10892798464 11365875712 1920523424 18.991 97 14 28 2 1937614960 13641200 3450336
18:30:13 71126 8192000000 10868787936 11342749696 1871457952 18.596 95 9 17 1 1886918544 13524080 1936512
18:31:31 83757 8192000000 10855497696 11307413504 1724317344 17.388 88 14 28 1 1739743920 10928560 4498016
18:33:01 45205 8192000000 10869514608 11316162560 1901579664 18.839 98 49 95 1 1924102208 9059984 13462560
18:34:06 117159 8192000000 10864318960 11341414400 1882966944 18.689 97 18 36 0 1902455632 13870848 5617840
18:36:09 49473 8192000000 10868472432 11345977344 1918242496 18.973 99 10 20 0 1941393504 20599824 2551184
18:37:05 7439 8192000000 10857893840 11340328960 1931855536 19.082 100 11 22 1 1954614272 20145936 2612800
18:37:19 1805 8192000000 10867373200 11331497984 1927511168 19.047 100 34 66 0 1952321456 14046112 10764176
18:37:31 47647 8192000000 10862142224 11336491008 1939298736 19.141 100 12 24 1 1951872880 8842400 3731744
18:38:24 80903 8192000000 10827687824 11296190464 1826752288 18.233 94 15 30 4 1839510944 8174096 4584560
18:40:16 93266 8192000000 10813543760 11284729856 1845130640 18.383 97 11 22 1 1858580288 10121184 3328464
18:42:19 64177 8192000000 10793121584 11272921088 1778691104 17.839 94 8 16 1 1796726480 15501744 2533632
18:43:29 37862 8192000000 10821836112 11292180480 1891337792 18.757 100 19 38 2 1908581520 11757984 5485744
18:44:17 74273 8192000000 10858736816 11316281344 1893575232 18.775 99 21 41 1 1914326576 14925888 5825456
18:45:37 65124 8192000000 10841122592 11310764032 1861732400 18.517 97 21 43 3 1881505376 13266160 6506816
18:46:50 40259 8192000000 10866376080 11310546944 1897809600 18.809 99 33 66 0 1916198976 9643424 8745952
18:47:40 76492 8192000000 10858050992 11316822016 1877048352 18.641 98 21 42 0 1892946976 10233040 5665584
18:49:09 77289 8192000000 10879113536 11338379264 1936692016 19.120 100 25 50 0 1956265024 12657792 6915216
18:50:35 57079 8192000000 10902849232 11353010176 1946299008 19.197 100 36 72 1 1965293296 9216560 9777728
18:51:43 54484 8192000000 10893206432 11358253056 1934624544 19.104 99 23 46 2 1951971920 10967568 6379808
18:52:43 112286 8192000000 10885198224 11370119168 1898311424 18.813 97 16 32 2 1928907616 26321440 4274752
18:54:43 54758 8192000000 10883132000 11357851648 1930440752 19.070 99 16 32 0 1950758928 15935360 4382816
18:55:44 20292 8192000000 10906938608 11350138880 1953045008 19.251 100 26 48 3 1969351120 9876416 6429696
18:56:12 132638 8192000000 10888624960 11363127296 1918926560 18.978 98 28 56 2 1935985232 9384928 7673744
18:58:31 58179 8192000000 10895519552 11359506432 1948796848 19.217 99 25 47 3 1971679168 15539392 7342928
18:59:41 15011 8192000000 10910933696 11368398848 1971819760 19.400 100 30 56 2 1990209008 10872592 7516656
19:00:02 19534 8192000000 10932629728 11389550592 1982287424 19.483 100 37 74 2 2013947184 21768992 9890768
19:00:33 65547 8192000000 10896149008 11385643008 1976880944 19.440 100 10 21 1 1992403088 12889680 2632464
19:01:46 10117 8192000000 10899249376 11389054976 1977996976 19.449 100 5 10 0 1993913120 15047728 868416
19:02:02 2232 8192000000 10899680752 11389505536 1978065168 19.449 100 5 10 1 1993878640 14889376 924096
19:02:11 2218 8192000000 10903878848 11394420736 1978270512 19.451 100 6 12 1 1998821728 19027184 1524032
19:02:19 17448 8192000000 10903694272 11384938496 1960064944 19.307 99 13 25 0 1976538432 13005152 3468336
19:02:44 41541 8192000000 10918483360 11397951488 1989900256 19.543 100 28 56 1 2008495632 10418096 8177280
19:03:34 58693 8192000000 10923730368 11404312576 1989218848 19.538 100 10 20 0 2005370656 13470976 2680832
19:04:40 27830 8192000000 10904366144 11394609152 1964513264 19.342 99 7 14 0 1982499296 16134592 1851440
19:05:18 44591 8192000000 10916779216 11392806912 1986353984 19.515 100 9 18 0 2002083808 13196672 2533152
19:06:09 35978 8192000000 10919683952 11397140480 1974853456 19.424 99 17 34 2 1992855568 13578960 4423152
19:07:03 39296 8192000000 10930378768 11402698752 1965496000 19.350 98 30 60 1 1989101872 15151680 8454192
19:07:52 55475 8192000000 10918434096 11394760704 1976930880 19.440 99 25 50 0 1996934960 12986096 7017984
19:09:02 54158 8192000000 10924602160 11395366912 1970600224 19.390 99 20 40 1 1990287744 14142064 5545456
19:10:24 63917 8192000000 10900486816 11379404800 1929236784 19.061 97 10 20 2 1943567488 11641904 2688800
19:11:41 32572 8192000000 10916011376 11386818560 1980287920 19.467 100 21 42 3 1996408624 10433536 5687168
19:12:34 71902 8192000000 10887426176 11366215680 1854457824 18.458 93 23 46 0 1875163760 14281296 6424640
19:13:59 43656 8192000000 10885138368 11334086656 1883153840 18.691 96 35 70 1 1907370720 15197456 9019424
19:14:49 77552 8192000000 10888220352 11360391168 1934684496 19.104 99 20 40 0 1951672304 11462640 5525168
19:16:13 115298 8192000000 10846498096 11321430016 1789324880 17.926 91 6 12 1 1800686368 10112480 1249008
19:18:18 134196 8192000000 10856205504 11323973632 1880313584 18.668 97 17 34 0 1896331360 10959792 5057984
19:20:38 41917 8192000000 10830238400 11311538176 1889059840 18.738 98 19 36 2 1900549200 6250144 5239216
19:21:26 58775 8192000000 10845384784 11324821504 1921216064 18.997 99 10 20 1 1929884528 6120368 2548096
19:22:33 32976 8192000000 10838557344 11310268416 1877936048 18.648 97 7 14 0 1888396240 8792192 1668000
19:23:14 20002 8192000000 10846344336 11313590272 1900612496 18.831 99 14 28 0 1914193440 9925104 3655840
19:23:43 55542 8192000000 10841923344 11327606784 1895337808 18.789 98 11 20 1 1906530352 8299344 2893200
19:25:07 54757 8192000000 10861602736 11328745472 1908351424 18.893 99 7 14 1 1918583792 8211872 2020496
19:26:11 64506 8192000000 10828268608 11304099840 1813637696 18.126 94 11 22 0 1825854816 9272272 2944848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-02-2021 19:28:54 to 28-02-2021 19:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 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 28-02-2021 19:29:26 to 28-02-2021 19:29:28.

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          240198
MON$OLDEST_ACTIVE               241077
MON$OLDEST_SNAPSHOT             241077
MON$NEXT_TRANSACTION            241077
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                       2024384
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:431: 
:432: mscs-test-161.budzdorov.ru    Sun Feb 28 19:27:29 2021
:433:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:434: 
:435: 
:436: mscs-test-161.budzdorov.ru    Sun Feb 28 19:27:30 2021
:437:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:438: 
:439: 
:440: mscs-test-161.budzdorov.ru    Sun Feb 28 19:27:30 2021
:441:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:442: 
:443: 
:444: mscs-test-161.budzdorov.ru    Sun Feb 28 19:27:30 2021
:445:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:446: 
:447: 
:448: mscs-test-161.budzdorov.ru    Sun Feb 28 19:27:30 2021
:449:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:450: 
--- end of diff output ---

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

28.02.21 19:29:29. 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-02-28 19:29:32 No severe PSQL-related problems occured
28.02.21 19:29:33. End of report.