Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.12.2020 16:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17528660 kB
MemAvailable 31554124 kB
Buffers 0 kB
Cached 14145468 kB
SwapCached 1988 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-08 16:27:06
DTS_END                         2020-12-08 16:27:06.8910
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38156
TRN_ID                          255077
ATT_ID                          688
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: 9582.67 22552 1149921
customer order: creation 187.86 342 22543
customer order: refuse 16.29 269 1955
order to supplier: creation 49.33 1224 5919
order to supplier: removal 3.64 70474 437
invoice (draft): creation 48.70 3339 5844
invoice (draft): removal 53.18 592 6381
invoice accept: apply 44.58 15534 5350
invoice accept: cancel 48.21 636 5785
customer reserve: creation 4038.07 157 484568
customer reserve: removal 4777.13 42 573255
realization accept: apply 90.75 151 10890
realization accept: cancel 83.53 85 10024
payment from customer: creation 64.77 96 7772
payment from customer: removal 6.45 65 774
payment to supplier: creation 53.79 117 6455
payment to supplier: removal 3.83 56 460
service: total inventory turnovers 5.27 901 632
service: total monetary turnovers 6.28 23 753
service: aggregate perf. data 1.00 15825 120
service: refresh index statistics 0.03 341107 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-12-2020 16:28:13 to 08-12-2020 16:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4715
TEST_TIME 2 5593
TEST_TIME 3 6440
TEST_TIME 4 7042
TEST_TIME 5 7212
TEST_TIME 6 7541
TEST_TIME 7 7496
TEST_TIME 8 8043
TEST_TIME 9 8412
TEST_TIME 10 8483
TEST_TIME 11 8746
TEST_TIME 12 9177
TEST_TIME 13 10184
TEST_TIME 14 10383
TEST_TIME 15 10881
TEST_TIME 16 11344
TEST_TIME 17 11819
TEST_TIME 18 11619
TEST_TIME 19 11774
TEST_TIME 20 11584
TEST_TIME 21 11669
TEST_TIME 22 11720
TEST_TIME 23 11416
TEST_TIME 24 11637
TEST_TIME 25 11817
TEST_TIME 26 11566
TEST_TIME 27 11302
TEST_TIME 28 11433
TEST_TIME 29 11165
TEST_TIME 30 11025
TEST_TIME 31 10955
TEST_TIME 32 10813
TEST_TIME 33 10760
TEST_TIME 34 10661
TEST_TIME 35 10482
TEST_TIME 36 10443
TEST_TIME 37 10417
TEST_TIME 38 10283
TEST_TIME 39 10256
TEST_TIME 40 10168
TEST_TIME 41 10039
TEST_TIME 42 9988
TEST_TIME 43 10052
TEST_TIME 44 10027
TEST_TIME 45 10001
TEST_TIME 46 10080
TEST_TIME 47 10069
TEST_TIME 48 10005
TEST_TIME 49 10081
TEST_TIME 50 10136
TEST_TIME 51 10105
TEST_TIME 52 10077
TEST_TIME 53 10195
TEST_TIME 54 10115
TEST_TIME 55 10026
TEST_TIME 56 10014
TEST_TIME 57 9959
TEST_TIME 58 9873
TEST_TIME 59 9843
TEST_TIME 60 9830
TEST_TIME 61 9868
TEST_TIME 62 9845
TEST_TIME 63 9775
TEST_TIME 64 9701
TEST_TIME 65 9806
TEST_TIME 66 9837
TEST_TIME 67 9899
TEST_TIME 68 9880
TEST_TIME 69 9928
TEST_TIME 70 10022
TEST_TIME 71 9933
TEST_TIME 72 10005
TEST_TIME 73 10056
TEST_TIME 74 10089
TEST_TIME 75 10083
TEST_TIME 76 10089
TEST_TIME 77 10133
TEST_TIME 78 10083
TEST_TIME 79 9969
TEST_TIME 80 9886
TEST_TIME 81 9906
TEST_TIME 82 9928
TEST_TIME 83 9887
TEST_TIME 84 9856
TEST_TIME 85 9809
TEST_TIME 86 9787
TEST_TIME 87 9712
TEST_TIME 88 9706
TEST_TIME 89 9717
TEST_TIME 90 9713
TEST_TIME 91 9752
TEST_TIME 92 9788
TEST_TIME 93 9783
TEST_TIME 94 9809
TEST_TIME 95 9860
TEST_TIME 96 9817
TEST_TIME 97 9864
TEST_TIME 98 9838
TEST_TIME 99 9826
TEST_TIME 100 9876
TEST_TIME 101 9930
TEST_TIME 102 9878
TEST_TIME 103 9924
TEST_TIME 104 9871
TEST_TIME 105 9861
TEST_TIME 106 9830
TEST_TIME 107 9825
TEST_TIME 108 9808
TEST_TIME 109 9746
TEST_TIME 110 9742
TEST_TIME 111 9735
TEST_TIME 112 9686
TEST_TIME 113 9653
TEST_TIME 114 9681
TEST_TIME 115 9670
TEST_TIME 116 9653
TEST_TIME 117 9671
TEST_TIME 118 9685
TEST_TIME 119 9665
TEST_TIME 120 9589

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-12-2020 16:28:17 to 08-12-2020 16:28:20.

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 1599818 1599818 0 0.00 0 20944 5 0 0
doc_list_biud 1599814 1599814 0 0.00 0 33973 20 0 0
sp_add_invoice_to_stock 5459 5350 109 1.99 37 153005 15534 0 109
sp_cancel_adding_invoice 5785 5785 0 0.00 5 58347 637 0 0
sp_cancel_client_order 1955 1955 0 0.00 4 16350 269 0 0
sp_cancel_customer_reserve 573255 573255 0 0.00 1 20118 42 0 0
sp_cancel_pay_from_customer 774 774 0 0.00 2 6666 66 0 0
sp_cancel_pay_to_supplier 460 460 0 0.00 3 2967 56 0 0
sp_cancel_supplier_invoice 6391 6381 10 0.15 1 12848 592 0 10
sp_cancel_supplier_order 437 437 0 0.00 7 864992 70474 0 0
sp_cancel_write_off 10024 10024 0 0.00 1 19771 85 0 0
sp_client_order 22543 22543 0 0.00 3 24763 342 0 0
sp_customer_reserve 484568 484568 0 0.00 0 49413 157 0 0
sp_fill_shopping_cart 34293 34293 0 0.00 1 13570 39 0 0
sp_fill_shopping_cart_clo_res 484551 484551 0 0.00 0 14757 12 0 0
sp_get_clo_for_invoice 5330 5330 0 0.00 0 21688 272 0 0
sp_kill_cost_storno 17043 17043 0 0.00 0 20933 41 0 0
sp_kill_qstorno_ret_qs2qd 1163352 1163352 0 0.00 0 23123 23 0 0
sp_kill_qty_storno 614057 614057 0 0.00 0 33973 51 0 0
sp_lock_selected_doc 22566 22566 0 0.00 0 8353 5 0 0
sp_make_cost_storno 30447 30447 0 0.00 0 16150 39 0 0
sp_multiply_rows_for_pdistr 30447 30447 0 0.00 0 11624 23 0 0
sp_multiply_rows_for_qdistr 22543 22543 0 0.00 0 13602 149 0 0
sp_pay_from_customer 7772 7772 0 0.00 4 11644 97 0 0
sp_pay_to_supplier 6455 6455 0 0.00 5 16157 117 0 0
sp_payment_common 14227 14227 0 0.00 1 8219 27 0 0
sp_qd_handle_on_cancel_clo 1955 1955 0 0.00 0 16266 236 0 0
sp_qd_handle_on_invoice_upd_sts 11115 11115 0 0.00 0 33972 283 0 0
sp_qd_handle_on_reserve_upd_sts 10890 10890 0 0.00 0 12990 51 0 0
sp_reserve_write_off 10890 10890 0 0.00 6 13529 152 0 0
sp_supplier_invoice 5844 5844 0 0.00 5 125400 3339 0 0
sp_supplier_order 5919 5919 0 0.00 5 34804 1224 0 0
srv_aggregate_perf_data 121 120 1 0.82 2846 84574 15826 0 1
srv_fill_mon_cache_memory 147 147 0 0.00 982 148263 37839 0 0
srv_find_qd_qs_mism 1099217 1099217 0 0.00 0 19943 5 0 0
srv_make_invnt_saldo 632 632 0 0.00 33 24176 902 0 0
srv_make_money_saldo 753 753 0 0.00 1 1388 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 185377 495695 341107 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5350 5350 0 0.00 0 30271 131 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 1460 52 0 0
t$perf-norm:sp_cancel_client_order 1955 1955 0 0.00 0 5686 16 0 0
t$perf-norm:sp_cancel_customer_reserve 771 771 0 0.00 0 2262 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 774 774 0 0.00 0 4827 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 460 460 0 0.00 0 273 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 443 443 0 0.00 0 923 10 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 26051 1074 0 0
t$perf-norm:sp_cancel_write_off 1096 1096 0 0.00 0 2666 8 0 0
t$perf-norm:sp_client_order 22543 22543 0 0.00 0 33618 16 0 0
t$perf-norm:sp_customer_reserve 1136 1136 0 0.00 0 5114 11 0 0
t$perf-norm:sp_pay_from_customer 7772 7772 0 0.00 0 9823 11 0 0
t$perf-norm:sp_pay_to_supplier 6455 6455 0 0.00 0 10686 12 0 0
t$perf-norm:sp_reserve_write_off 10890 10890 0 0.00 0 14723 14 0 0
t$perf-norm:sp_supplier_invoice 5844 5844 0 0.00 0 7551 15 0 0
t$perf-norm:sp_supplier_order 5919 5919 0 0.00 0 8163 11 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 409 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 5272 42 0 0
t$perf-norm:srv_make_invnt_saldo 632 632 0 0.00 0 2585 13 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 1340 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 209 93 0 0
v_add_invoice_to_stock 10878 10660 218 2.00 0 3760 18 0 218
v_all_customers 41162 41162 0 0.00 0 61 1 0 0
v_all_suppliers 32730 32730 0 0.00 0 48 1 0 0
v_all_wares 45086 45086 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 451 6 0 0
v_cancel_client_order 3910 3910 0 0.00 0 3183 8 0 0
v_cancel_customer_prepayment 1548 1548 0 0.00 0 767 2 0 0
v_cancel_customer_reserve 1542 1542 0 0.00 0 3613 7 0 0
v_cancel_payment_to_supplier 920 920 0 0.00 0 2826 7 0 0
v_cancel_supplier_invoice 906 886 20 2.20 0 3257 22 0 20
v_cancel_supplier_order 874 874 0 0.00 0 2129 17 0 0
v_cancel_write_off 2192 2192 0 0.00 0 3256 18 0 0
v_max_id_clo_ord 5919 5919 0 0.00 0 5933 2 0 0
v_max_id_clo_res 1136 1136 0 0.00 0 2734 12 0 0
v_max_id_ord_sup 5831 5831 0 0.00 0 5164 4 0 0
v_max_non_paid_invoice 1840 1840 0 0.00 0 365 2 0 0
v_max_non_paid_realizn 4189 4189 0 0.00 0 2005 3 0 0
v_min_id_clo_ord 5919 5919 0 0.00 0 3385 8 0 0
v_min_id_clo_res 1136 1136 0 0.00 0 4423 15 0 0
v_min_id_ord_sup 5831 5831 0 0.00 0 12645 16 0 0
v_min_non_paid_invoice 6455 6455 0 0.00 0 7570 20 0 0
v_min_non_paid_realizn 7772 7772 0 0.00 0 7021 16 0 0
v_our_firm 11090 11090 0 0.00 0 60 1 0 0
v_reserve_write_off 21780 21780 0 0.00 0 4602 8 0 0
x_lock_depdocs_on_canc_invoice 11723 11723 0 0.00 0 13702 90 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 9821 309 0 0
x_make_qstorno_1000_1200 5919 5919 0 0.00 2 34793 1148 0 0
x_make_qstorno_1200_2000 5844 5844 0 0.00 2 121426 3195 0 0
x_make_qstorno_2100_3300 484568 484568 0 0.00 0 49380 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-12-2020 16:28:21 to 08-12-2020 16:28:25.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:16 9908 8192000000 10221773504 10526334976 901381568 9.912 72 54 108 0 923149344 2464848 19302928
13:57:36 23464 8192000000 10339690688 10656382976 1388359872 14.491 100 84 168 1 1419887264 4688784 26838608
13:58:09 35178 8192000000 10394905120 10721435648 1444712592 14.991 100 85 170 1 1478394800 6698416 26983792
13:58:56 19982 8192000000 10430826192 10760495104 1473965584 15.249 100 88 176 0 1509973136 8048208 27959344
13:59:30 18708 8192000000 10447271856 10777378816 1497782384 15.457 100 94 188 0 1536593120 8684384 30126352
14:00:00 15066 8192000000 10456794368 10791518208 1509881152 15.562 100 89 178 0 1547260192 9266640 28112400
14:00:27 19055 8192000000 10475839808 10814652416 1526573424 15.707 100 87 174 0 1563740544 9516608 27650512
14:00:58 19165 8192000000 10498936128 10843242496 1551636592 15.924 100 84 168 1 1587264880 9991296 25636992
14:01:28 12444 8192000000 10510240832 10860015616 1571041584 16.091 100 85 170 0 1607324368 10312192 25970592
14:01:51 13611 8192000000 10544709392 10895298560 1599436128 16.335 100 84 168 1 1635525296 10935296 25153872
14:02:13 10910 8192000000 10557267488 10915192832 1615488608 16.471 100 82 164 2 1651067488 11060224 24518656
14:02:36 7806 8192000000 10576584880 10939645952 1640436368 16.683 100 76 151 4 1674437424 11272864 22728192
14:02:53 8798 8192000000 10593509472 10959994880 1659997232 16.849 100 82 164 0 1696527440 11784464 24745744
14:03:12 8964 8192000000 10609098000 10981220352 1675698928 16.981 100 67 134 3 1706396672 11044528 19653216
14:03:28 10930 8192000000 10636737056 11010543616 1696964192 17.160 100 69 138 1 1727732768 10765616 20002960
14:03:49 5619 8192000000 10655490496 11030863872 1724876112 17.393 100 73 146 0 1757349584 11343184 21130288
14:04:02 6123 8192000000 10665113248 11040407552 1731610160 17.449 100 82 162 3 1767405632 12883728 22911744
14:04:16 6116 8192000000 10680539680 11054948352 1744439296 17.555 100 80 160 0 1780105024 13448240 22217488
14:04:29 5340 8192000000 10692239728 11071332352 1755589216 17.648 100 79 157 1 1791098592 14074416 21434960
14:04:43 5799 8192000000 10699971104 11084296192 1767341488 17.745 100 77 155 1 1802854480 13865696 21647296
14:04:57 3326 8192000000 10715116752 11095560192 1776479440 17.820 100 84 168 2 1813341488 13340864 23521184
14:05:06 2667 8192000000 10727846944 11106185216 1786148416 17.900 100 81 162 1 1821117616 12736896 22232304
14:05:15 3368 8192000000 10727931616 11110645760 1794367136 17.968 100 76 151 2 1828354144 13287712 20699296
14:05:27 3505 8192000000 10724853792 11118735360 1798268496 18.000 100 69 137 1 1829240528 12442480 18529552
14:05:37 3322 8192000000 10746076880 11138457600 1813338736 18.123 100 81 162 0 1849152224 12345184 23468304
14:05:47 2950 8192000000 10761297040 11148124160 1825379968 18.222 100 77 153 0 1858736176 12207584 21148624
14:05:56 2535 8192000000 10771369216 11161321472 1835079392 18.301 100 80 161 1 1869804400 12513936 22211072
14:06:06 1225 8192000000 10777082256 11165835264 1838346816 18.327 100 88 175 1 1876250944 13459392 24444736
14:06:13 1604 8192000000 10783446864 11170734080 1846861216 18.397 100 87 176 1 1884171648 11532560 25777872
14:06:22 1670 8192000000 10785765152 11172982784 1846772576 18.396 100 89 180 2 1884165680 11999360 25393744
14:06:30 1356 8192000000 10799492000 11186974720 1857346512 18.482 100 94 188 0 1895919360 12055920 26516928
14:06:38 2919 8192000000 10804209056 11192393728 1861123280 18.512 100 93 184 0 1900383584 13485648 25774656
14:06:47 1692 8192000000 10807674592 11195244544 1869544464 18.581 100 93 187 0 1909526768 13377584 26604720
14:06:55 2655 8192000000 10805822544 11199520768 1868580224 18.573 100 87 174 1 1906823856 14127568 24116064
14:07:05 1644 8192000000 10815099440 11205509120 1872054480 18.601 100 92 184 0 1911998624 13947520 25996624
14:07:12 1637 8192000000 10820419440 11208904704 1872166800 18.602 100 94 188 1 1912384128 13468544 26748784
14:07:21 1393 8192000000 10825781888 11213426688 1873826672 18.615 100 93 187 2 1913704688 13614480 26263536
14:07:28 29193 8192000000 10791590208 11199315968 1870954096 18.592 100 61 122 1 1899818288 11104976 17759216
14:08:05 7182 8192000000 10784541904 11205017600 1867257408 18.562 100 47 95 1 1893526256 12183424 14085424
14:08:25 10190 8192000000 10774300016 11201667072 1868324736 18.571 100 21 42 1 1880198928 6141808 5732384
14:08:42 4989 8192000000 10785805968 11207561216 1875914624 18.632 100 40 81 1 1894662256 7633776 11113856
14:08:54 4171 8192000000 10800021648 11211890688 1876891264 18.640 100 38 76 1 1894837232 7936176 10009792
14:09:05 5290 8192000000 10788294464 11213873152 1877836000 18.648 100 34 68 0 1895902832 8816448 9250384
14:09:17 10770 8192000000 10797206336 11219677184 1877922656 18.648 100 20 40 1 1889395488 5310368 6162464
14:09:34 6465 8192000000 10795835456 11224260608 1883264912 18.691 100 30 60 0 1902372720 11213360 7894448
14:09:48 7544 8192000000 10799948272 11228086272 1887644864 18.727 100 28 54 2 1902623296 6913200 8065232
14:10:05 9300 8192000000 10797012144 11224866816 1887928928 18.729 100 21 42 3 1900012528 6035360 6048240
14:10:20 9174 8192000000 10795420448 11227308032 1887670416 18.727 100 18 35 1 1898872384 5806560 5395408
14:10:39 5941 8192000000 10808132464 11231543296 1891800848 18.760 100 33 68 2 1908249552 7621760 8826944
14:10:54 7510 8192000000 10798207392 11229655040 1892641600 18.767 100 26 52 3 1906581904 6878752 7061552
14:11:08 11509 8192000000 10799058896 11228704768 1888585056 18.734 100 15 30 3 1898052896 5424768 4043072
14:11:26 5309 8192000000 10800739216 11233153024 1894538560 18.782 100 32 64 0 1910395264 6131712 9724992
14:11:39 55255 8192000000 10811238064 11241439232 1892221392 18.764 100 20 41 1 1903073568 4712480 6139696
14:12:41 35365 8192000000 10819892720 11245981696 1897769296 18.808 100 23 45 1 1910311040 5673456 6868288
14:13:24 4141 8192000000 10812041664 11248578560 1905202688 18.868 100 33 66 1 1922243008 7804640 9235680
14:13:37 8319 8192000000 10816409648 11251785728 1904241872 18.860 100 33 65 4 1920698928 7002560 9454496
14:13:52 13027 8192000000 10821324544 11253809152 1905072704 18.867 100 23 46 1 1917818240 6421312 6324224
14:14:11 6415 8192000000 10820711872 11258089472 1907870400 18.890 100 29 58 2 1922061136 5481424 8709312
14:14:28 6962 8192000000 10821280208 11261837312 1915569344 18.951 100 26 52 2 1929468832 6321152 7578336
14:14:42 6047 8192000000 10802645968 11241664512 1896160608 18.795 99 20 40 0 1907207008 5902272 5144128
14:14:57 9014 8192000000 10827692416 11261022208 1914704288 18.944 100 25 50 3 1926691088 5392384 6594416
14:15:16 13523 8192000000 10818656336 11260268544 1913330064 18.933 100 15 30 1 1922843888 5546096 3967728
14:15:40 9806 8192000000 10816534720 11253977088 1894849104 18.785 99 19 38 2 1905765024 5544560 5371360
14:15:56 8789 8192000000 10815263472 11257577472 1891100480 18.755 99 17 32 0 1901552400 6076496 4375424
14:16:12 10024 8192000000 10791514624 11235024896 1845377088 18.385 97 10 20 1 1853864208 5795904 2691216
14:16:30 7346 8192000000 10789074880 11225722880 1881191024 18.675 100 19 38 1 1892349200 5992176 5166000
14:16:43 76082 8192000000 10711576672 11131015168 1663767232 16.881 88 16 32 0 1673117280 4574224 4775824
14:18:07 10838 8192000000 10746412624 11166961664 1771627232 17.780 96 22 42 2 1783073552 5937296 5509024
14:18:25 4767 8192000000 10717960768 11127058432 1715933584 17.318 93 29 58 0 1730363632 5120128 9309920
14:18:36 5590 8192000000 10724165728 11138736128 1783318144 17.877 98 30 60 0 1797733216 5846000 8569072
14:18:48 5889 8192000000 10732675776 11157417984 1800168592 18.015 99 29 60 1 1813701632 5250544 8282496
14:19:02 9068 8192000000 10714897584 11131150336 1758461984 17.672 97 29 59 2 1773023120 6499568 8061568
14:19:17 7066 8192000000 10718058816 11135246336 1758003136 17.668 97 26 53 1 1771195088 6337312 6854640
14:19:31 4840 8192000000 10702746512 11114000384 1758425696 17.671 98 23 46 1 1771357648 5958128 6973824
14:19:43 9376 8192000000 10708497296 11131879424 1733023296 17.461 96 20 40 1 1744463584 5188768 6251520
14:20:00 12649 8192000000 10718419616 11137724416 1771982416 17.783 98 19 37 2 1782507280 4948208 5576656
14:20:22 6999 8192000000 10695335456 11106533376 1763927408 17.717 98 24 48 2 1776361648 5119360 7314880
14:20:38 5492 8192000000 10703045120 11124625408 1794125280 17.966 100 24 48 1 1807630800 5928368 7577152
14:20:50 6654 8192000000 10714792656 11118743552 1762003152 17.701 98 27 55 2 1774803952 4573184 8227616
14:21:04 10403 8192000000 10693091872 11116326912 1772356688 17.786 99 25 50 0 1785685360 5599440 7729232
14:21:23 11934 8192000000 10712170816 11130601472 1787709488 17.913 99 16 32 0 1798848416 5949904 5189024
14:21:41 62551 8192000000 10748108064 11145572352 1736926336 17.493 95 38 76 0 1753496384 5176304 11393744
14:22:51 16286 8192000000 10736309152 11153788928 1812637616 18.117 100 15 30 0 1822022656 5394144 3990896
14:23:14 9580 8192000000 10737946000 11162972160 1824462304 18.214 100 27 54 3 1838784656 7152992 7169360
14:23:30 8123 8192000000 10750592496 11169415168 1833310128 18.286 100 33 66 2 1848778368 5756448 9711792
14:23:51 7910 8192000000 10751636112 11174395904 1836821504 18.315 100 27 54 0 1851591456 7511792 7258160
14:24:09 9023 8192000000 10754046160 11184128000 1842449056 18.361 100 21 43 1 1854075776 5556992 6069728
14:24:26 6624 8192000000 10760473344 11187453952 1849414000 18.417 100 31 61 4 1865014960 6249296 9351664
14:24:39 7497 8192000000 10770171280 11195965440 1856256016 18.473 100 39 77 4 1874385968 5849552 12280400
14:24:56 9342 8192000000 10778008448 11200290816 1858150416 18.488 100 32 64 1 1873272560 5529936 9592208
14:25:13 8934 8192000000 10779476144 11204984832 1862843904 18.526 100 37 73 1 1880086400 5613504 11628992
14:25:29 8718 8192000000 10771264960 11203948544 1864035280 18.536 100 19 38 0 1874717328 5097520 5584528
14:25:44 11874 8192000000 10777701200 11209940992 1867852848 18.567 100 26 53 0 1881279488 5826272 7600368
14:26:04 10688 8192000000 10782411200 11214008320 1871680000 18.598 100 21 42 0 1884086704 6042592 6364112
14:26:22 102002 8192000000 10819317888 11241287680 1878963184 18.657 100 28 55 2 1892930832 6086928 7880720
14:28:20 8267 8192000000 10833042848 11256819712 1905249680 18.868 100 50 102 2 1929575200 10598352 13727168
14:28:38 14268 8192000000 10844792432 11264086016 1896816544 18.801 99 53 104 1 1923253968 12288096 14149328
14:29:02 12232 8192000000 10849500800 11269029888 1917188992 18.964 100 51 102 1 1943598736 12008592 14401152
14:29:22 4712 8192000000 10864016176 11284885504 1929916080 19.066 100 57 114 2 1961169072 15217296 16035696
14:29:34 17027 8192000000 10871913840 11295797248 1932906368 19.090 100 48 96 2 1963764176 17314576 13543232
14:29:59 5453 8192000000 10881161824 11300728832 1942706800 19.168 100 51 103 0 1973877648 16215488 14955360
14:30:13 13317 8192000000 10897790112 11320315904 1957275536 19.284 100 54 107 2 1989068144 16675200 15117408
14:30:38 11627 8192000000 10905403712 11330699264 1962269904 19.324 100 57 113 2 1997054416 18580160 16204352
14:30:56 4790 8192000000 10889507680 11308961792 1944528336 19.183 99 57 114 1 1979268560 18477168 16263056
14:31:12 4749 8192000000 10898264752 11324387328 1960908064 19.313 100 58 116 0 1996265104 18362720 16994320
14:31:25 9956 8192000000 10904533120 11327811584 1964669360 19.343 100 56 111 2 1998856000 17595248 16591392
14:31:41 10917 8192000000 10915267968 11342413824 1970149520 19.387 100 51 100 1 2002229904 17757776 14322608
14:32:01 5342 8192000000 10921544960 11343183872 1977769680 19.447 100 68 135 1 2017669664 20173520 19726464
14:32:13 3030 8192000000 10941254928 11352276992 1982932480 19.488 100 82 165 0 2026451216 20464208 23054528
14:32:24 17091 8192000000 10930201840 11359436800 1981664720 19.478 100 60 119 1 2020843216 22128784 17049712
14:32:55 9238 8192000000 10922788512 11352133632 1964604800 19.343 99 51 102 3 2001993264 22491312 14897152
14:33:12 14081 8192000000 10922264352 11358187520 1984632960 19.501 100 57 112 2 2021182944 20057232 16492752
14:33:41 9153 8192000000 10920704416 11345334272 1969060928 19.378 99 60 120 0 2007940992 20260896 18619168
14:34:00 22164 8192000000 10926844368 11352580096 1960915424 19.313 99 52 104 1 1997189184 20398144 15875616
14:34:31 7472 8192000000 10927451104 11358633984 1981775552 19.479 100 54 105 1 2018262848 20476688 16010608
14:34:50 7137 8192000000 10934850224 11366584320 1986599600 19.517 100 57 112 2 2023481920 20438160 16444160
14:35:05 1938 8192000000 10939466560 11358076928 1969926064 19.385 99 71 138 0 2013018400 22408512 20683824
14:35:14 1673 8192000000 10944198608 11365330944 1986754560 19.518 100 63 122 3 2028724944 23727136 18243248
14:35:22 3848 8192000000 10958772496 11371036672 1978297488 19.451 99 87 175 2 2030779184 26249808 26231888
14:35:37 981 8192000000 10957169056 11364622336 1987070592 19.521 100 90 178 0 2039121744 26973200 25077952
14:35:46 4427 8192000000 10956036416 11374329856 1992571360 19.564 100 71 141 0 2040813200 27443936 20797904
14:35:57 9858 8192000000 10939895808 11359473664 1974406080 19.420 99 66 131 1 2019096944 25041024 19649840
14:36:14 5411 8192000000 10941821984 11367444480 1987203456 19.522 100 74 147 2 2034774144 25655568 21915120
14:36:27 5265 8192000000 10938454960 11365167104 1985167360 19.506 100 58 116 2 2025635616 23270704 17197552
14:36:39 10826 8192000000 10907716736 11340308480 1931657024 19.080 97 55 110 1 1971507392 23135152 16715216
14:36:59 3210 8192000000 10921762368 11342409728 1962088464 19.323 99 64 128 1 2005348896 23597744 19662688
14:37:11 5725 8192000000 10941602832 11364302848 1967578000 19.366 99 75 148 3 2014843184 24231920 23033264
14:37:26 7144 8192000000 10936723184 11363319808 1981745632 19.479 100 66 131 1 2026223440 25394032 19083776
14:37:41 2336 8192000000 10948680432 11359649792 1972304352 19.404 99 78 157 0 2021720992 26160608 23256032
14:37:50 3122 8192000000 10952762512 11378921472 1995563776 19.588 100 76 152 3 2045792496 27419904 22808816
14:38:01 2808 8192000000 10942759040 11360387072 1964979376 19.346 99 83 162 2 2017171456 27944368 24247712
14:38:10 2405 8192000000 10907313808 11322540032 1942222784 19.164 99 73 146 0 1993045104 28475472 22346848
14:38:19 3866 8192000000 10930417600 11348332544 1961915488 19.321 100 80 160 1 2015121168 29535392 23670288
14:38:33 4047 8192000000 10933336832 11352719360 1966937328 19.361 100 68 136 0 2016628672 29281840 20409504
14:38:44 2737 8192000000 10944972912 11364253696 1975638064 19.430 100 79 158 1 2033032000 32604752 24789184
14:38:54 2924 8192000000 10942367984 11358965760 1954158032 19.260 99 74 148 2 2010513264 33808736 22546496
14:39:03 2841 8192000000 10931337104 11345313792 1947250304 19.205 99 74 150 1 2004377648 34830032 22297312
14:39:14 2137 8192000000 10948219040 11359232000 1972172688 19.403 100 82 163 0 2031969680 34687568 25109424
14:39:22 5247 8192000000 10914374720 11342053376 1938268160 19.133 99 55 110 3 1993242368 37166160 17808048
14:39:38 6364 8192000000 10922157600 11351740416 1955045024 19.267 100 38 73 1 2003396256 35706848 12644384
14:39:54 4203 8192000000 10948742048 11369930752 1975414992 19.428 100 72 142 0 2034006864 35959616 22632256
14:40:12 4635 8192000000 10954140848 11369603072 1974740496 19.423 100 81 163 2 2038169504 37900000 25529008
14:40:23 2719 8192000000 10932345904 11343052800 1948881296 19.218 100 81 161 0 2007682528 34053392 24747840
14:40:34 1228 8192000000 10931135808 11344150528 1942545008 19.167 99 86 173 0 2004000848 33572816 27883024
14:40:42 5418 8192000000 10905481824 11333345280 1945617536 19.192 100 65 130 0 1997521744 31172720 20731488
14:40:58 10985 8192000000 10876323984 11311448064 1921004944 18.995 99 31 62 1 1958968800 27878848 10085008
14:41:18 6934 8192000000 10894210464 11326078976 1937721936 19.129 100 44 90 1 1981637904 29189152 14726816
14:41:32 9774 8192000000 10885091568 11323281408 1906145616 18.876 98 33 66 0 1949933200 32999968 10787616
14:41:51 12066 8192000000 10876716608 11321839616 1917515168 18.967 99 31 62 3 1966209168 38286384 10407616
14:42:09 19274 8192000000 10873647216 11317964800 1915900832 18.954 99 26 52 1 1959698624 34756304 9041488
14:42:40 20867 8192000000 10886250128 11330531328 1933823776 19.097 100 18 36 0 1962961312 22869328 6268208
14:43:09 21048 8192000000 10879251264 11335913472 1930069712 19.067 99 28 56 1 1965749008 26561440 9117856
14:43:46 28651 8192000000 10867691408 11310751744 1884091888 18.698 97 20 40 1 1916169888 25719632 6358368
14:44:27 12043 8192000000 10868930672 11316776960 1908096784 18.891 99 23 46 0 1941876624 27063248 6716592
14:44:46 16615 8192000000 10841002448 11283607552 1847748128 18.404 96 20 40 0 1879238992 24805072 6685792
14:45:10 17933 8192000000 10841495360 11278004224 1882589648 18.686 99 27 52 2 1911994240 21113216 8291376
14:45:59 24876 8192000000 10854394560 11295764480 1878445184 18.653 98 25 50 0 1912985776 26932144 7608448
14:46:32 15675 8192000000 10863726048 11297460224 1898602752 18.815 99 29 58 0 1935748288 28190064 8955472
14:46:54 18373 8192000000 10859217168 11309359104 1901343856 18.837 99 20 40 1 1933081552 25957952 5779744
14:47:32 10091 8192000000 10872081968 11304275968 1920049040 18.987 100 55 111 3 1962001504 25240496 16711968
14:47:51 18403 8192000000 10873507440 11291054080 1901765680 18.840 99 35 70 0 1935919936 23395600 10758656
14:48:17 9218 8192000000 10867037568 11310764032 1923388240 19.014 100 39 78 3 1960562704 24895616 12278848
14:48:37 15517 8192000000 10857611856 11294040064 1881643504 18.678 98 24 45 2 1911234704 22382688 7208512
14:49:03 58864 8192000000 10841703872 11295719424 1911293280 18.917 100 24 48 3 1939537968 21032800 7211888
14:50:18 92697 8192000000 10853402560 11310571520 1900748848 18.832 99 45 88 1 1932498624 18559072 13190704
14:51:58 33344 8192000000 10847912624 11304472576 1899399040 18.821 99 11 23 0 1925586368 22710048 3477280
14:52:41 60698 8192000000 10846944096 11309920256 1902703616 18.848 99 12 24 0 1920315664 14115504 3496544
14:53:48 77171 8192000000 10849339152 11295612928 1867583456 18.565 97 24 48 0 1886152320 11367888 7200976
14:55:30 49570 8192000000 10845107856 11302580224 1925933824 19.034 100 24 46 1 1938724656 6858032 5932800
14:56:31 53794 8192000000 10893214736 11327676416 1943799360 19.177 100 32 62 1 1960475792 7917696 8758736
14:57:32 89430 8192000000 10899433216 11356065792 1967232944 19.363 100 25 50 1 1986010560 11072112 7705504
15:01:01 67418 8192000000 10892972272 11356827648 1970549712 19.390 100 13 26 0 1983888096 9830528 3507856
15:02:15 50824 8192000000 10905236784 11363430400 1979481552 19.461 100 14 28 0 1992302624 9400160 3420912
15:03:14 36735 8192000000 10923248336 11369615360 1991022432 19.552 100 25 50 2 2007492160 8880096 7589632
15:03:58 36595 8192000000 10914450064 11369594880 1971919616 19.401 99 34 67 2 1991669728 9356208 10393904
15:05:38 86654 8192000000 10896279248 11377942528 1986894784 19.519 100 9 18 1 1998541600 9041360 2605456
15:07:13 44862 8192000000 10898274880 11375030272 1968453392 19.373 99 7 14 1 1977382640 6799760 2129488
15:08:05 103675 8192000000 10921123136 11395653632 1975722256 19.431 99 8 16 0 1990359088 12330768 2306064
15:09:55 71208 8192000000 10943470384 11384602624 1978220720 19.451 99 15 30 2 1996870688 14387520 4262448
15:11:13 52622 8192000000 10926420288 11385417728 1941540736 19.159 97 15 30 0 1955082496 9369920 4171840
15:12:14 57480 8192000000 10930543232 11397496832 1982225264 19.482 99 29 58 1 2002302864 11877856 8199744
15:13:31 136832 8192000000 10902721744 11374350336 1837110304 18.317 92 7 14 0 1852318944 13294656 1913984
15:16:03 112201 8192000000 10889295056 11345354752 1859307424 18.498 94 9 18 0 1879705440 17849728 2548288
15:18:04 36696 8192000000 10873117824 11309117440 1843812912 18.372 94 32 64 1 1860796320 7850512 9132896
15:18:49 12580 8192000000 10888973568 11329683456 1942924192 19.170 100 40 80 2 1961222576 7737088 10561296
15:19:08 23355 8192000000 10904856384 11340976128 1935098976 19.108 99 48 94 2 1958226704 10194624 12933104
15:19:40 65150 8192000000 10880480080 11361095680 1940848864 19.154 99 28 55 0 1964191216 15518288 7824064
15:20:52 72595 8192000000 10869039568 11326021632 1880016416 18.665 96 22 44 1 1895760336 9852192 5891728
15:22:13 66567 8192000000 10901242656 11336019968 1919002880 18.979 98 48 94 1 1940000272 7477168 13520224
15:23:26 57235 8192000000 10843994992 11295543296 1802489856 18.034 93 17 34 1 1815240960 8327632 4423472
15:24:30 24205 8192000000 10834969776 11275771904 1867201440 18.562 97 37 74 2 1885946336 8025728 10719168
15:25:00 51006 8192000000 10840263632 11286441984 1906370048 18.877 99 33 66 0 1926466016 10664448 9431520
15:25:59 64207 8192000000 10836576192 11293696000 1863798832 18.534 97 27 54 1 1885794400 14412016 7583552
15:27:39 70787 8192000000 10856695008 11330838528 1919421296 18.982 100 10 20 0 1942469456 20474112 2574048
15:29:00 17252 8192000000 10849156880 11329617920 1925615520 19.032 100 8 16 0 1946195328 18475376 2104432
15:29:23 78539 8192000000 10832400992 11293462528 1875413248 18.628 97 12 24 2 1890715168 12194032 3107888
15:31:28 77471 8192000000 10867209104 11327528960 1869784480 18.583 96 16 32 0 1888564672 13807680 4972512
15:32:53 75706 8192000000 10839289584 11310620672 1799353744 18.009 93 17 34 0 1813185424 9694144 4137536
15:34:21 68766 8192000000 10851052944 11306745856 1791310336 17.943 93 10 19 2 1801168656 7413280 2445040
15:35:57 57649 8192000000 10857838016 11293446144 1850405552 18.425 96 20 40 1 1869564256 13482832 5675872
15:37:04 88528 8192000000 10868325632 11309166592 1872799376 18.607 97 33 65 1 1899952560 17144896 10008288
15:38:48 41907 8192000000 10884029872 11339898880 1920146656 18.988 99 31 62 1 1945876064 17089856 8639552
15:39:41 93456 8192000000 10867343424 11333611520 1861327632 18.514 96 15 30 0 1885492608 19990640 4174336
15:41:22 110123 8192000000 10902551136 11351687168 1937336240 19.125 99 23 46 1 1957720144 14183200 6200704
15:43:18 59188 8192000000 10903549184 11370139648 1957593840 19.287 100 18 36 0 1978210992 15217376 5399776
15:44:39 148260 8192000000 10891505376 11351666688 1956027376 19.274 99 22 45 0 1976952624 14489200 6436048
15:47:24 30790 8192000000 10906241984 11366313984 1973218272 19.411 100 36 70 0 1999153568 16159056 9776240
15:48:03 35231 8192000000 10904182704 11375980544 1974054160 19.418 100 28 57 2 2003185824 20724960 8406704
15:48:54 21731 8192000000 10890818960 11371446272 1949405600 19.222 99 5 10 0 1963918112 13072528 1439984
15:49:22 40788 8192000000 10875575024 11360759808 1922924496 19.010 98 5 10 0 1937716608 13499504 1292608
15:50:09 36926 8192000000 10872141888 11339415552 1938159328 19.132 99 8 16 0 1952901184 12837152 1904704
15:50:52 60877 8192000000 10885927216 11361951744 1968000128 19.370 100 8 16 0 1979597232 9556448 2040656
15:52:08 38064 8192000000 10868540928 11337175040 1912483840 18.927 97 15 30 1 1925612016 9270368 3857808
15:52:52 67797 8192000000 10881863104 11352805376 1917661056 18.968 98 13 26 0 1930710544 9401872 3647616
15:54:06 65176 8192000000 10890207776 11353886720 1945757696 19.193 99 14 28 0 1964163616 14152624 4253296
15:55:19 69228 8192000000 10884363648 11361853440 1927183488 19.044 98 14 28 0 1947161664 15785728 4192448
15:56:44 98972 8192000000 10938429696 11395366912 1975502416 19.429 100 13 26 0 2004965648 25782384 3680848
15:58:33 84515 8192000000 10892789552 11366928384 1886748192 18.720 95 12 25 0 1903484816 13555296 3181328
16:00:07 95970 8192000000 10913339872 11381108736 1941401216 19.158 98 12 24 2 1960081968 15600544 3080208
16:02:12 43008 8192000000 10914030320 11386413056 1962114592 19.323 99 23 47 0 1979494144 11743792 5635760
16:03:09 33886 8192000000 10916857248 11371220992 1947687712 19.208 98 32 62 2 1967102544 10992384 8422448
16:03:53 39724 8192000000 10915557040 11363610624 1936929680 19.122 98 40 80 1 1962817232 14956528 10931024
16:04:39 72985 8192000000 10891646736 11335823360 1885876384 18.713 96 15 30 1 1899094096 9660416 3557296
16:05:58 54579 8192000000 10922749904 11378085888 1972471344 19.405 100 35 70 2 1991900576 9962736 9466496
16:06:59 53103 8192000000 10921156736 11374030848 1959268192 19.300 99 22 43 2 1979741552 14176416 6296944
16:08:00 115681 8192000000 10890807520 11351470080 1852732240 18.444 94 14 28 0 1871277104 15025712 3519152
16:10:02 27441 8192000000 10913329392 11374190592 1973254480 19.411 100 28 56 1 1994856688 13779056 7823152
16:10:36 81702 8192000000 10894010192 11365023744 1930873152 19.074 98 22 44 2 1956664480 19628944 6162384
16:12:08 68767 8192000000 10885084960 11337912320 1918366896 18.974 98 16 32 0 1938105568 14969760 4768912
16:13:23 52849 8192000000 10844107888 11303698432 1832028032 18.276 94 31 62 1 1851263808 10459744 8776032
16:14:57 37385 8192000000 10822093760 11278303232 1878242864 18.651 98 18 36 0 1895013968 11802960 4968144
16:15:46 48977 8192000000 10833477040 11299328000 1878537280 18.653 98 6 12 0 1890809520 10575968 1696272
16:16:42 92406 8192000000 10840578224 11309056000 1857392880 18.482 97 6 11 0 1870824512 12105088 1326544
16:18:20 50656 8192000000 10828931696 11301507072 1885916432 18.713 98 8 16 0 1899675408 11648688 2110288
16:19:20 46179 8192000000 10834889872 11307696128 1904128960 18.859 99 6 12 1 1915644272 9987296 1528016
16:20:17 51244 8192000000 10841277792 11300974592 1846628144 18.395 96 23 46 1 1866036752 12881696 6526912
16:21:17 53043 8192000000 10818967152 11281485824 1815955360 18.145 95 15 30 2 1831475072 10830080 4689632
16:22:23 43835 8192000000 10833929008 11293995008 1848784032 18.412 97 11 22 0 1861603952 10069952 2749968
16:23:13 60784 8192000000 10836491872 11297406976 1865393680 18.547 97 19 38 1 1882651184 11551696 5705808
16:24:55 92642 8192000000 10858170944 11313856512 1830734288 18.265 95 16 32 1 1846437680 11104352 4599040
16:26:34 39553 8192000000 9344699536 9624035328 502130160 5.775 26 12 21 1 514134592 8867424 3137008

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 08-12-2020 16:28:27 to 08-12-2020 16:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 109 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:01, from 08-12-2020 16:28:58 to 08-12-2020 16:28:59.

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          255340
MON$OLDEST_ACTIVE               255341
MON$OLDEST_SNAPSHOT             255341
MON$NEXT_TRANSACTION            255341
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                       2020160
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:178: 
:179: mscs-test-161.budzdorov.ru    Tue Dec  8 16:27:15 2020
:180:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:181: 
:182: 
:183: mscs-test-161.budzdorov.ru    Tue Dec  8 16:27:21 2020
:184:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:185: 
:186: 
:187: mscs-test-161.budzdorov.ru    Tue Dec  8 16:27:21 2020
:188:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:189: 
:190: 
:191: mscs-test-161.budzdorov.ru    Tue Dec  8 16:27:23 2020
:192:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:193: 
--- end of diff output ---

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

08.12.20 16:29:00. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-08 16:29:03 No severe PSQL-related problems occured
08.12.20 16:29:04. End of report.