Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.04.2021 16:34
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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17107324 kB
MemAvailable 31410472 kB
Buffers 0 kB
Cached 14514016 kB
SwapCached 0 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-04-03 16:33:32
DTS_END                         2021-04-03 16:33:32.5450
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45188
TRN_ID                          242492
ATT_ID                          712
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: 9680.50 19899 1161660
customer order: creation 175.63 339 21075
customer order: refuse 15.83 375 1899
order to supplier: creation 47.73 1279 5728
order to supplier: removal 3.62 94979 434
invoice (draft): creation 46.53 3214 5583
invoice (draft): removal 55.76 847 6691
invoice accept: apply 43.28 16835 5193
invoice accept: cancel 50.63 783 6075
customer reserve: creation 3988.36 167 478603
customer reserve: removal 4944.10 52 593292
realization accept: apply 85.98 184 10318
realization accept: cancel 89.49 108 10739
payment from customer: creation 61.09 124 7331
payment from customer: removal 5.94 80 713
payment to supplier: creation 50.58 137 6069
payment to supplier: removal 3.38 89 406
service: total inventory turnovers 5.15 1188 618
service: total monetary turnovers 6.62 29 794
service: aggregate perf. data 0.79 25932 95
service: refresh index statistics 0.03 251234 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-04-2021 16:34:28 to 03-04-2021 16:34:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4290
TEST_TIME 2 2644
TEST_TIME 3 4253
TEST_TIME 4 5220
TEST_TIME 5 4924
TEST_TIME 6 5034
TEST_TIME 7 5136
TEST_TIME 8 5415
TEST_TIME 9 5254
TEST_TIME 10 5557
TEST_TIME 11 5779
TEST_TIME 12 5846
TEST_TIME 13 6082
TEST_TIME 14 6783
TEST_TIME 15 6736
TEST_TIME 16 6789
TEST_TIME 17 6880
TEST_TIME 18 7001
TEST_TIME 19 7495
TEST_TIME 20 7758
TEST_TIME 21 7749
TEST_TIME 22 7832
TEST_TIME 23 7936
TEST_TIME 24 8503
TEST_TIME 25 8895
TEST_TIME 26 9036
TEST_TIME 27 9761
TEST_TIME 28 9915
TEST_TIME 29 10096
TEST_TIME 30 10818
TEST_TIME 31 10741
TEST_TIME 32 10746
TEST_TIME 33 10699
TEST_TIME 34 10793
TEST_TIME 35 10762
TEST_TIME 36 10850
TEST_TIME 37 10637
TEST_TIME 38 10539
TEST_TIME 39 10521
TEST_TIME 40 10466
TEST_TIME 41 10406
TEST_TIME 42 10243
TEST_TIME 43 10052
TEST_TIME 44 10159
TEST_TIME 45 10162
TEST_TIME 46 10019
TEST_TIME 47 10019
TEST_TIME 48 9997
TEST_TIME 49 9910
TEST_TIME 50 9879
TEST_TIME 51 9991
TEST_TIME 52 10038
TEST_TIME 53 9924
TEST_TIME 54 9879
TEST_TIME 55 9768
TEST_TIME 56 9704
TEST_TIME 57 9847
TEST_TIME 58 9765
TEST_TIME 59 9830
TEST_TIME 60 9774
TEST_TIME 61 9792
TEST_TIME 62 9829
TEST_TIME 63 9908
TEST_TIME 64 9868
TEST_TIME 65 9918
TEST_TIME 66 9930
TEST_TIME 67 9962
TEST_TIME 68 9992
TEST_TIME 69 10000
TEST_TIME 70 9995
TEST_TIME 71 10060
TEST_TIME 72 10023
TEST_TIME 73 9961
TEST_TIME 74 9910
TEST_TIME 75 9841
TEST_TIME 76 9882
TEST_TIME 77 9895
TEST_TIME 78 9831
TEST_TIME 79 9824
TEST_TIME 80 9757
TEST_TIME 81 9760
TEST_TIME 82 9742
TEST_TIME 83 9681
TEST_TIME 84 9666
TEST_TIME 85 9587
TEST_TIME 86 9639
TEST_TIME 87 9614
TEST_TIME 88 9615
TEST_TIME 89 9614
TEST_TIME 90 9649
TEST_TIME 91 9634
TEST_TIME 92 9621
TEST_TIME 93 9684
TEST_TIME 94 9696
TEST_TIME 95 9734
TEST_TIME 96 9716
TEST_TIME 97 9767
TEST_TIME 98 9779
TEST_TIME 99 9806
TEST_TIME 100 9904
TEST_TIME 101 9985
TEST_TIME 102 9976
TEST_TIME 103 9923
TEST_TIME 104 9872
TEST_TIME 105 9836
TEST_TIME 106 9796
TEST_TIME 107 9828
TEST_TIME 108 9793
TEST_TIME 109 9807
TEST_TIME 110 9780
TEST_TIME 111 9740
TEST_TIME 112 9719
TEST_TIME 113 9715
TEST_TIME 114 9703
TEST_TIME 115 9688
TEST_TIME 116 9733
TEST_TIME 117 9721
TEST_TIME 118 9698
TEST_TIME 119 9682
TEST_TIME 120 9682

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-04-2021 16:34:32 to 03-04-2021 16:34:35.

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 1604392 1604392 0 0.00 0 20390 6 0 0
doc_list_biud 1604392 1604392 0 0.00 0 22673 26 0 0
sp_add_invoice_to_stock 5338 5193 145 2.71 41 180752 16835 0 145
sp_cancel_adding_invoice 6075 6075 0 0.00 4 54634 783 0 0
sp_cancel_client_order 1899 1899 0 0.00 4 12599 376 0 0
sp_cancel_customer_reserve 593292 593292 0 0.00 1 21121 53 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 4048 81 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 2 7060 90 0 0
sp_cancel_supplier_invoice 6705 6691 14 0.20 1 15894 848 0 14
sp_cancel_supplier_order 434 434 0 0.00 5 1083420 94980 0 0
sp_cancel_write_off 10739 10739 0 0.00 1 8884 108 0 0
sp_client_order 21075 21075 0 0.00 4 14505 340 0 0
sp_customer_reserve 478603 478603 0 0.00 0 102351 167 0 0
sp_fill_shopping_cart 32383 32383 0 0.00 1 7848 36 0 0
sp_fill_shopping_cart_clo_res 478598 478598 0 0.00 0 16884 14 0 0
sp_get_clo_for_invoice 5188 5188 0 0.00 0 19381 243 0 0
sp_kill_cost_storno 17933 17933 0 0.00 0 6922 51 0 0
sp_kill_qstorno_ret_qs2qd 1204448 1204448 0 0.00 0 21087 29 0 0
sp_kill_qty_storno 634635 634635 0 0.00 0 22673 64 0 0
sp_lock_selected_doc 21634 21634 0 0.00 0 8221 5 0 0
sp_make_cost_storno 28905 28905 0 0.00 0 11411 59 0 0
sp_multiply_rows_for_pdistr 28905 28905 0 0.00 0 8175 31 0 0
sp_multiply_rows_for_qdistr 21075 21075 0 0.00 0 14491 149 0 0
sp_pay_from_customer 7331 7331 0 0.00 4 12544 124 0 0
sp_pay_to_supplier 6069 6069 0 0.00 5 11038 137 0 0
sp_payment_common 13400 13400 0 0.00 1 12526 40 0 0
sp_qd_handle_on_cancel_clo 1899 1899 0 0.00 0 12591 338 0 0
sp_qd_handle_on_invoice_upd_sts 11263 11263 0 0.00 0 22672 316 0 0
sp_qd_handle_on_reserve_upd_sts 10317 10317 0 0.00 0 16260 59 0 0
sp_reserve_write_off 10318 10318 0 0.00 6 16280 184 0 0
sp_supplier_invoice 5583 5583 0 0.00 7 70534 3214 0 0
sp_supplier_order 5728 5728 0 0.00 5 27898 1279 0 0
srv_aggregate_perf_data 95 95 0 0.00 2829 634253 25933 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1070 138034 32284 0 0
srv_find_qd_qs_mism 1112257 1112257 0 0.00 0 20389 5 0 0
srv_make_invnt_saldo 618 618 0 0.00 47 156972 1189 0 0
srv_make_money_saldo 794 794 0 0.00 1 3922 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 172459 409082 251235 0 0
t$perf-abend:sp_add_invoice_to_stock 145 145 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5193 5193 0 0.00 0 21610 186 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 0 6976 109 0 0
t$perf-norm:sp_cancel_client_order 1899 1899 0 0.00 0 23985 47 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 6077 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 9034 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 3608 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 1950 22 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 31159 1526 0 0
t$perf-norm:sp_cancel_write_off 1097 1097 0 0.00 0 3890 13 0 0
t$perf-norm:sp_client_order 21075 21075 0 0.00 0 11247 19 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 3569 13 0 0
t$perf-norm:sp_pay_from_customer 7331 7331 0 0.00 0 8481 12 0 0
t$perf-norm:sp_pay_to_supplier 6069 6069 0 0.00 0 8476 15 0 0
t$perf-norm:sp_reserve_write_off 10318 10318 0 0.00 0 11234 15 0 0
t$perf-norm:sp_supplier_invoice 5583 5583 0 0.00 0 16995 22 0 0
t$perf-norm:sp_supplier_order 5728 5728 0 0.00 0 6812 20 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 317 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 1377 15 0 0
t$perf-norm:srv_make_invnt_saldo 618 618 0 0.00 0 4485 41 0 0
t$perf-norm:srv_make_money_saldo 794 794 0 0.00 0 4266 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 172 44 0 0
v_add_invoice_to_stock 10664 10374 290 2.71 0 6723 21 0 290
v_all_customers 38584 38584 0 0.00 0 15 1 0 0
v_all_suppliers 31528 31528 0 0.00 0 103 1 0 0
v_all_wares 42150 42150 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 8078 31 0 0
v_cancel_client_order 3798 3798 0 0.00 0 3152 9 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 2854 11 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 2084 10 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 3231 11 0 0
v_cancel_supplier_invoice 880 852 28 3.18 0 1953 21 0 28
v_cancel_supplier_order 868 868 0 0.00 0 1278 6 0 0
v_cancel_write_off 2194 2194 0 0.00 0 4756 20 0 0
v_max_id_clo_ord 5728 5728 0 0.00 0 4560 2 0 0
v_max_id_clo_res 981 981 0 0.00 0 2427 13 0 0
v_max_id_ord_sup 5580 5580 0 0.00 0 4324 4 0 0
v_max_non_paid_invoice 1613 1613 0 0.00 0 4421 9 0 0
v_max_non_paid_realizn 3864 3864 0 0.00 0 1529 3 0 0
v_min_id_clo_ord 5728 5728 0 0.00 0 5776 10 0 0
v_min_id_clo_res 981 981 0 0.00 0 7497 17 0 0
v_min_id_ord_sup 5580 5580 0 0.00 0 7845 9 0 0
v_min_non_paid_invoice 6069 6069 0 0.00 0 9862 32 0 0
v_min_non_paid_realizn 7331 7331 0 0.00 0 10181 23 0 0
v_our_firm 10500 10500 0 0.00 0 45 1 0 0
v_reserve_write_off 20634 20634 0 0.00 0 4723 9 0 0
x_lock_depdocs_on_canc_invoice 12340 12340 0 0.00 0 17377 108 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 15088 345 0 0
x_make_qstorno_1000_1200 5728 5728 0 0.00 2 27083 1190 0 0
x_make_qstorno_1200_2000 5583 5583 0 0.00 4 70416 3093 0 0
x_make_qstorno_2100_3300 478603 478603 0 0.00 0 102349 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-04-2021 16:34:36 to 03-04-2021 16:34:40.

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
14:03:36 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:03:42 24328 8192000000 10291391312 10601709568 1022077296 11.092 79 60 120 1 1044725584 2758368 19889920
14:04:14 43346 8192000000 10374034032 10696986624 1416894816 14.745 100 86 172 0 1449979472 5215504 27869152
14:05:05 25646 8192000000 10408220512 10736160768 1458664784 15.114 100 86 172 0 1493709232 6938112 28106336
14:05:45 34193 8192000000 10457582288 10790281216 1497408352 15.454 100 89 178 1 1534129536 8239104 28482080
14:06:27 21706 8192000000 10475890368 10812096512 1528809440 15.727 100 89 178 0 1565986608 9171776 28005392
14:06:57 21284 8192000000 10497473600 10836701184 1543202976 15.851 100 85 170 0 1579845680 9769328 26873376
14:07:27 21087 8192000000 10507298352 10850619392 1560269664 15.999 100 88 176 0 1597677888 10044960 27363264
14:07:58 17879 8192000000 10527942048 10878316544 1576409392 16.137 100 81 162 0 1611135712 10161200 24565120
14:08:26 16702 8192000000 10551931216 10905092096 1604277936 16.376 100 76 155 1 1637379504 10647184 22454384
14:08:52 8628 8192000000 10563329760 10917199872 1623196560 16.537 100 82 164 1 1658786448 11513088 24076800
14:09:09 17655 8192000000 10585493616 10944188416 1641586448 16.693 100 86 172 1 1679289248 12233696 25469104
14:09:39 9935 8192000000 10601441168 10965729280 1661313776 16.860 100 77 154 1 1696214288 12382512 22518000
14:09:57 13541 8192000000 10626351216 10993192960 1680961056 17.025 100 79 158 0 1716588384 12600656 23026672
14:10:19 10796 8192000000 10643243648 11013201920 1701110720 17.194 100 76 150 1 1735378928 12734512 21533696
14:10:37 8516 8192000000 10661958816 11034337280 1721070976 17.361 100 86 172 2 1759489408 13229440 25188992
14:10:53 6798 8192000000 10663820256 11039113216 1724987264 17.394 100 74 148 2 1758494000 13081136 20425600
14:11:07 4775 8192000000 10676155648 11052675072 1735787328 17.484 100 81 162 1 1772504576 13530176 23187072
14:11:22 6070 8192000000 10685237104 11062239232 1749448400 17.597 100 72 144 1 1781858720 11934000 20476320
14:11:35 7675 8192000000 10699463120 11080654848 1760923088 17.692 100 80 159 1 1795595136 12332624 22339424
14:11:50 4501 8192000000 10706891552 11088343040 1772937200 17.791 100 77 152 0 1806481904 12247296 21297408
14:12:02 3838 8192000000 10726761584 11105849344 1783599040 17.879 100 84 166 1 1819382528 12374384 23409104
14:12:13 3890 8192000000 10727702896 11111616512 1789941488 17.931 100 84 168 0 1826787104 12483984 24361632
14:12:24 3644 8192000000 10730782848 11113689088 1792032064 17.948 100 79 157 1 1826613376 12296320 22284992
14:12:34 4357 8192000000 10737492192 11122020352 1803612496 18.044 100 84 168 0 1840015504 12962432 23440576
14:12:45 3400 8192000000 10741850672 11123269632 1805546352 18.059 100 91 182 1 1844414768 13685632 25182784
14:12:55 6386 8192000000 10748631424 11131539456 1812398576 18.116 100 80 161 1 1847820848 13955248 21467024
14:13:09 3642 8192000000 10761131552 11143663616 1814469648 18.132 100 78 156 0 1850567632 13580976 22517008
14:13:20 2815 8192000000 10769358896 11152195584 1829115232 18.252 100 94 188 2 1870492288 14111408 27265648
14:13:29 2202 8192000000 10767384784 11158413312 1836597136 18.313 100 87 171 1 1873389536 12746064 24046336
14:13:38 2307 8192000000 10790193440 11173961728 1846541808 18.394 100 93 186 0 1887085616 14120528 26423280
14:13:47 2617 8192000000 10789198544 11178713088 1852045696 18.439 100 90 181 1 1891234032 13604656 25583680
14:13:56 1774 8192000000 10789666528 11180187648 1852662752 18.444 100 90 176 1 1891101952 13668880 24770320
14:14:04 1874 8192000000 10802873120 11187572736 1858500048 18.491 100 90 180 0 1898225872 13675984 26049840
14:14:12 2483 8192000000 10802951664 11192967168 1864513472 18.540 100 87 174 2 1900995664 11863504 24618688
14:14:21 2363 8192000000 10804755568 11191468032 1864078192 18.536 100 94 185 1 1902288576 13100672 25109712
14:14:30 1534 8192000000 10808185216 11198353408 1867930224 18.568 100 92 185 0 1907977008 14019504 26027280
14:14:38 1485 8192000000 10812973568 11200917504 1873639424 18.614 100 95 191 1 1915009824 14628512 26741888
14:14:46 1965 8192000000 10819583600 11207737344 1874848368 18.623 100 95 190 2 1915669040 13201072 27619600
14:14:58 1400 8192000000 10825654912 11214483456 1878030240 18.649 100 94 186 1 1915203264 11795760 25377264
14:15:06 1415 8192000000 10825128704 11218952192 1884412640 18.701 100 97 195 2 1926127808 13524368 28190800
14:15:14 2255 8192000000 10822575888 11217420288 1882767744 18.687 100 87 177 0 1921070832 13415424 24887664
14:15:23 1479 8192000000 10823886048 11223863296 1884190000 18.699 100 79 158 0 1919801232 12508784 23102448
14:15:38 23553 8192000000 10808416464 11214598144 1884016208 18.698 100 50 100 3 1904912528 5484784 15411536
14:16:10 15731 8192000000 10825427616 11221929984 1889134224 18.739 100 67 135 4 1916434352 7620416 19679712
14:16:32 1263 8192000000 10842020944 11235414016 1893906528 18.777 100 92 185 1 1932352384 11138976 27306880
14:16:39 9702 8192000000 10828973520 11227729920 1890246368 18.748 100 72 143 0 1920830320 11047920 19536032
14:16:56 4548 8192000000 10816948656 11233026048 1888436896 18.733 100 58 116 1 1916861168 12504992 15919280
14:17:08 3657 8192000000 10816894768 11227070464 1890811536 18.752 100 51 102 1 1914506768 9601344 14093888
14:17:20 4565 8192000000 10807776032 11228200960 1889302240 18.740 100 38 77 0 1908593024 8346672 10944112
14:17:35 2589 8192000000 10820483840 11237310464 1895848752 18.793 100 50 100 0 1918707008 8821632 14036624
14:17:48 8511 8192000000 10805468160 11236384768 1896882928 18.801 100 34 69 1 1914248720 7209376 10156416
14:18:03 5493 8192000000 10819902624 11239415808 1899023920 18.818 100 39 80 2 1917590304 7831056 10735328
14:18:14 3934 8192000000 10821892816 11243761664 1899361408 18.821 100 32 60 1 1918861104 11712400 7787296
14:18:32 5926 8192000000 10805082592 11237199872 1899877024 18.825 100 29 58 3 1914772560 5729952 9165584
14:18:46 4471 8192000000 10820336208 11243032576 1899905120 18.826 100 29 58 1 1915262320 6825840 8531360
14:18:58 11869 8192000000 10820667264 11249127424 1905343264 18.869 100 24 48 0 1918730080 6706256 6680560
14:19:18 7597 8192000000 10810956064 11247218688 1910382864 18.910 100 26 52 2 1923489024 5687008 7419152
14:19:33 10410 8192000000 10816947568 11252056064 1910273056 18.909 100 19 38 1 1921516432 6092608 5150768
14:19:54 8943 8192000000 10836125520 11263819776 1917706160 18.968 100 30 60 0 1932341344 6154592 8480592
14:20:14 67616 8192000000 10851134144 11266703360 1921767312 19.001 100 44 88 2 1941492976 6050256 13675408
14:21:28 5312 8192000000 10837646608 11272048640 1922318592 19.005 100 40 80 2 1942988672 9433296 11236784
14:21:43 7675 8192000000 10824833184 11265519616 1920279808 18.989 100 25 50 1 1934706016 7404272 7021936
14:21:58 3713 8192000000 10837941856 11265110016 1902402784 18.846 99 34 68 1 1919457664 7739872 9315008
14:22:15 5953 8192000000 10833483408 11265994752 1916462528 18.958 100 29 58 3 1931627136 6680768 8483840
14:22:28 5555 8192000000 10833417216 11264356352 1918678352 18.976 100 36 72 1 1934403040 6277408 9447280
14:22:40 5862 8192000000 10832706112 11257872384 1909365744 18.902 100 34 68 3 1926197744 7282128 9549872
14:22:53 9922 8192000000 10824134448 11259617280 1911637312 18.920 100 17 34 0 1922646304 6236272 4772720
14:23:10 7350 8192000000 10827678272 11258044416 1911416368 18.918 100 19 38 0 1922896368 6206880 5273120
14:23:25 9518 8192000000 10806028912 11245944832 1887173072 18.723 99 18 36 1 1899165600 6750080 5242448
14:23:44 10598 8192000000 10807170784 11242209280 1886685344 18.719 99 21 41 1 1898356064 5954048 5716672
14:24:05 45494 8192000000 10820700688 11247820800 1856840432 18.478 97 28 56 3 1870643632 5231424 8571776
14:25:07 17051 8192000000 10780332864 11217690624 1803202672 18.040 95 13 26 0 1812066960 5135696 3728592
14:25:31 10840 8192000000 10760825184 11184009216 1804549520 18.051 96 18 36 2 1815126432 5727184 4849728
14:25:50 8216 8192000000 10766012480 11185065984 1825499312 18.223 98 28 56 2 1839914064 6284992 8129760
14:26:05 5972 8192000000 10748714544 11172003840 1805024720 18.055 98 26 52 1 1818508592 5859872 7624000
14:26:19 5803 8192000000 10730996320 11159797760 1771518864 17.780 96 23 46 0 1785086288 6508496 7058928
14:26:32 6763 8192000000 10721388352 11142541312 1774581520 17.805 97 25 46 2 1786607488 5621328 6404640
14:26:47 8380 8192000000 10703155424 11120439296 1729406272 17.431 95 27 55 2 1743178080 5747664 8024144
14:27:04 10847 8192000000 10706720240 11121672192 1738280752 17.504 96 25 50 0 1751015296 5190288 7544256
14:27:23 8493 8192000000 10717312224 11132571648 1790389648 17.935 99 25 50 0 1802634176 5270800 6973728
14:27:40 7567 8192000000 10708829456 11128745984 1770413760 17.770 98 28 56 2 1786069168 6657712 8997696
14:27:56 12898 8192000000 10728289264 11149594624 1786055024 17.899 98 25 50 0 1799928848 5687824 8186000
14:28:17 9038 8192000000 10728124016 11147882496 1786130864 17.900 98 17 34 1 1797208880 6427424 4650592
14:28:32 18584 8192000000 10717633664 11138531328 1737852320 17.501 95 37 73 1 1753453712 4513296 11088096
14:28:57 76926 8192000000 10722246896 11149836288 1749266240 17.596 96 24 48 1 1765130576 9164096 6700240
14:30:20 9592 8192000000 10755241088 11173789696 1825828624 18.225 100 41 82 0 1849071600 12019680 11223296
14:30:36 4673 8192000000 10743874224 11168829440 1834971440 18.300 100 33 66 0 1855575536 10436704 10167392
14:30:48 7272 8192000000 10742606336 11165175808 1831670016 18.273 100 28 56 3 1845269856 5719952 7879888
14:31:04 7703 8192000000 10754824816 11175956480 1837564256 18.321 100 24 49 1 1850718784 6034688 7119840
14:31:19 6283 8192000000 10759671248 11181092864 1841762384 18.355 100 30 60 1 1857085168 5446992 9875792
14:31:32 8529 8192000000 10771780240 11194347520 1852970720 18.446 100 30 60 0 1868928224 6792128 9165376
14:31:48 5746 8192000000 10768393456 11198095360 1855357296 18.466 100 26 50 1 1868170592 5354384 7458912
14:32:03 6578 8192000000 10768875616 11198021632 1857603120 18.484 100 32 64 3 1873476368 5785792 10087456
14:32:16 9732 8192000000 10773125584 11203665920 1860477872 18.507 100 20 40 2 1872057216 5756064 5823280
14:32:32 5114 8192000000 10776889168 11207282688 1864982176 18.544 100 32 64 2 1879946224 5801664 9162384
14:32:45 7835 8192000000 10776955312 11209068544 1862678432 18.525 100 21 42 1 1878398352 9108272 6611648
14:33:01 12915 8192000000 10792472080 11220434944 1875886032 18.632 100 19 39 1 1886320592 5472336 4962224
14:33:20 8412 8192000000 10790442848 11224412160 1883815344 18.696 100 11 22 1 1891681648 5136816 2729488
14:33:38 22016 8192000000 10825423344 11242745856 1895455152 18.790 100 29 58 0 1908799632 4728912 8615568
14:34:13 15438 8192000000 10838893632 11257597952 1904249296 18.860 100 37 74 2 1920495120 6721920 9523904
14:34:38 28223 8192000000 10850943040 11268493312 1914254208 18.941 100 49 100 1 1936393984 8357904 13781872
14:35:14 94320 8192000000 10848558032 11285778432 1920102016 18.988 100 29 56 3 1941729456 12665056 8962384
14:36:55 40547 8192000000 10870158992 11304411136 1930156112 19.068 100 38 75 1 1955632800 14145920 11330768
14:37:44 6871 8192000000 10875369136 11303890944 1945250464 19.189 100 54 108 1 1972577680 11340736 15986480
14:37:58 9347 8192000000 10889123680 11307851776 1948385344 19.214 100 65 130 3 1978656544 11476160 18795040
14:38:17 9974 8192000000 10893117568 11316039680 1950052304 19.227 100 57 112 1 1978576416 12877824 15646288
14:38:34 2846 8192000000 10888704256 11316060160 1953311088 19.253 100 58 116 0 1983936960 13992832 16633040
14:38:46 26662 8192000000 10891770512 11318370304 1938540720 19.135 99 58 116 0 1969824544 14543360 16740464
14:39:28 11245 8192000000 10898674432 11331354624 1959093360 19.299 100 50 99 2 1990268192 16682480 14492352
14:39:51 16637 8192000000 10902397920 11341639680 1958838912 19.297 100 39 79 0 1986852048 16479856 11533280
14:40:20 23383 8192000000 10917427376 11349823488 1970488608 19.389 100 32 62 0 1998779248 18887904 9402736
14:40:53 14961 8192000000 10912151648 11348766720 1961503488 19.318 99 47 93 1 1996291904 20609744 14178672
14:41:16 15298 8192000000 10922997024 11360051200 1975732080 19.431 100 44 88 0 2010979712 21846720 13400912
14:41:38 23097 8192000000 10923493264 11366948864 1983834096 19.495 100 50 98 2 2020102160 21157184 15110880
14:42:11 16164 8192000000 10942943360 11376828416 1991344800 19.554 100 48 96 1 2028789296 23300176 14144320
14:42:34 5821 8192000000 10948351088 11379314688 1995295280 19.586 100 50 100 0 2033880848 23985184 14600384
14:42:50 12261 8192000000 10959748384 11390672896 2000655488 19.628 100 64 128 0 2045756912 26578432 18522992
14:43:13 7321 8192000000 10959758256 11393171456 1998776352 19.613 100 62 124 1 2048286560 31248496 18261712
14:43:27 5207 8192000000 10940089456 11363115008 1959923648 19.305 98 68 136 0 2011574320 31755312 19895360
14:43:44 2925 8192000000 10962889632 11383607296 1993561344 19.572 100 71 142 1 2046473456 32730496 20181616
14:43:54 1720 8192000000 10989256608 11399589888 2006215952 19.672 100 91 181 1 2067645888 35329168 26100768
14:44:03 4042 8192000000 10985976976 11397627904 2007894656 19.685 100 82 162 0 2066999568 35736912 23368000
14:44:20 3662 8192000000 10972163152 11398463488 2005650864 19.667 100 61 122 3 2057792928 34372848 17769216
14:44:32 6501 8192000000 10982752896 11400257536 1991322848 19.554 99 78 155 0 2053546352 39244384 22979120
14:44:48 9409 8192000000 10979230272 11401838592 2004989088 19.662 100 72 144 0 2062357120 36056272 21311760
14:45:05 11204 8192000000 10973730768 11407335424 2005037568 19.662 100 59 118 1 2059029312 36606816 17384928
14:45:25 6249 8192000000 10984290176 11417378816 2011771680 19.715 100 66 132 0 2070538736 39126544 19640512
14:45:39 2040 8192000000 10992106256 11421908992 2016445664 19.752 100 69 138 3 2080336704 42913168 20977872
14:45:48 4215 8192000000 10987153024 11423424512 2017230384 19.758 100 65 130 2 2079353392 43142592 18980416
14:45:59 6041 8192000000 11002998272 11432726528 2021595936 19.793 100 75 147 1 2088211936 43524048 23091952
14:46:12 4844 8192000000 10993845920 11421245440 2013602992 19.730 100 77 154 0 2081024896 43760688 23661216
14:46:24 7317 8192000000 10994157920 11417006080 2007210064 19.680 100 72 143 3 2073356816 44831744 21315008
14:46:45 5773 8192000000 10990234864 11421872128 2012098304 19.718 100 75 150 2 2078929056 43590832 23239920
14:46:59 3174 8192000000 10972831424 11405803520 1997982960 19.607 100 67 130 1 2067639120 48112784 21543376
14:47:10 10627 8192000000 10958896480 11398500352 2001940768 19.638 100 66 133 2 2064112816 40334320 21837728
14:47:30 3325 8192000000 10991190192 11411382272 2010077312 19.702 100 87 172 1 2075374352 39198432 26098608
14:47:41 2425 8192000000 10981836992 11409575936 2007783184 19.684 100 68 136 1 2065111936 36456608 20872144
14:47:51 4255 8192000000 10990374928 11406528512 2005773968 19.668 100 85 171 2 2069721776 38736448 25211360
14:48:02 1437 8192000000 10982253392 11412041728 2009807072 19.700 100 66 131 2 2066868496 37681792 19379632
14:48:10 1069 8192000000 10971973712 11390230528 1988061456 19.528 99 82 160 1 2049886432 37595312 24229664
14:48:19 6048 8192000000 10975105152 11408973824 2001962160 19.638 100 63 126 0 2059935664 39087152 18886352
14:48:36 6252 8192000000 10978311296 11412082688 2006565072 19.674 100 62 122 1 2064422880 39366384 18491424
14:48:50 6430 8192000000 10985928096 11420151808 2012071840 19.718 100 60 118 4 2071351280 41596608 17682832
14:49:06 7947 8192000000 10993915136 11423252480 2014627472 19.738 100 63 126 1 2075703504 41630816 19445216
14:49:21 3592 8192000000 10983656112 11410100224 1989836176 19.542 99 67 134 1 2053545696 42813072 20896448
14:49:33 5283 8192000000 10971141472 11413356544 2003050912 19.647 100 60 117 0 2064870128 43032144 18787072
14:49:57 6929 8192000000 10990648688 11425386496 2010574832 19.706 100 61 121 0 2074718272 45009952 19133488
14:50:17 5832 8192000000 10975380240 11404099584 1992884144 19.567 100 69 138 0 2061407072 46269952 22252976
14:50:30 5506 8192000000 10985736032 11418148864 2005690288 19.668 100 73 146 1 2077042112 48426256 22925568
14:50:44 4376 8192000000 10977512880 11399745536 1985133584 19.505 100 74 148 0 2055942416 48236352 22572480
14:50:59 2368 8192000000 10990919184 11405148160 1992257088 19.562 100 85 172 2 2070026160 51570368 26198704
14:51:09 3189 8192000000 10980121840 11406127104 1977039968 19.441 99 80 160 2 2053164528 51192384 24932176
14:51:21 2121 8192000000 10971801152 11390414848 1976812624 19.439 100 75 151 0 2051892944 51617744 23462576
14:51:35 1821 8192000000 10959629184 11372343296 1944017408 19.179 98 85 168 3 2023657280 52918784 26721088
14:51:45 8971 8192000000 10968279728 11390496768 1974596352 19.422 100 72 143 2 2051394512 54182368 22615792
14:52:01 4655 8192000000 10971910848 11398434816 1977981680 19.449 100 65 129 2 2054398016 56401104 20015232
14:52:12 2797 8192000000 10967795936 11390754816 1976491200 19.437 100 80 160 1 2056045984 55155984 24398800
14:52:22 2238 8192000000 10979342032 11400359936 1980063952 19.465 100 87 172 1 2063963664 57130544 26769168
14:52:32 3118 8192000000 10969833104 11383508992 1964023952 19.338 100 82 164 4 2047893456 57991664 25877840
14:52:43 1367 8192000000 10974439072 11386331136 1977788832 19.447 100 89 174 2 2057732832 53053520 26890480
14:52:51 2639 8192000000 10954673280 11361402880 1955775792 19.272 99 80 158 1 2033683360 53099152 24808416
14:53:01 5854 8192000000 10959857792 11372679168 1931908816 19.082 98 74 147 1 2009720880 55347232 22464832
14:53:14 6255 8192000000 10956545712 11379765248 1962653536 19.327 100 65 129 0 2037191232 55537200 19000496
14:53:28 8549 8192000000 10936064816 11378061312 1955959264 19.274 100 41 82 1 2024173888 55420176 12794448
14:54:00 9454 8192000000 10924671616 11356626944 1934104544 19.100 99 38 74 1 1999656624 53291104 12260976
14:54:18 6157 8192000000 10946820192 11361193984 1932884688 19.090 99 68 137 1 2011499392 57712608 20902096
14:54:34 3629 8192000000 10934414592 11364851712 1945286608 19.189 100 46 93 2 2016590224 56416960 14886656
14:54:46 12110 8192000000 10919494512 11357822976 1923924832 19.018 99 41 82 2 1997539392 60201360 13413200
14:55:04 12007 8192000000 10925559472 11357532160 1938106896 19.132 100 41 82 1 2015243456 63155856 13980704
14:55:23 20798 8192000000 10917543264 11353456640 1925705696 19.033 99 32 64 1 1998690496 61681552 11303248
14:55:55 17182 8192000000 10938508656 11373887488 1927097824 19.044 99 32 64 1 2002977968 64748144 11132000
14:56:22 25405 8192000000 10948463968 11386642432 1950883920 19.234 100 39 78 0 2032156224 67724496 13547808
14:56:53 9287 8192000000 10938178016 11376783360 1925183296 19.028 99 34 68 1 2006483200 69280336 12019568
14:57:18 5629 8192000000 10947255840 11380793344 1952410576 19.246 100 50 101 2 2036789216 68089136 16289504
14:57:38 15585 8192000000 10938402352 11391172608 1939829776 19.145 99 36 72 2 2016165504 63815616 12520112
14:58:00 12827 8192000000 10956438960 11394510848 1957614480 19.287 100 34 68 2 2031413456 62236768 11562208
14:58:24 9623 8192000000 10953858944 11387514880 1941758000 19.161 99 42 83 3 2021159744 65039696 14362048
14:58:40 10501 8192000000 10943589136 11392225280 1934191216 19.100 99 32 64 1 2013745216 68147536 11406464
14:59:00 13215 8192000000 10941972736 11388837888 1952589376 19.247 100 36 72 1 2027248256 62395360 12263520
14:59:20 22547 8192000000 10928553872 11378241536 1954328576 19.261 100 29 58 2 2022627952 57579024 10720352
14:59:49 28618 8192000000 10929239616 11385024512 1930472992 19.071 99 28 56 0 2000225040 59699840 10052208
15:00:31 27559 8192000000 10877957104 11338788864 1879354896 18.660 97 20 40 0 1933598160 46889936 7353328
15:01:09 30391 8192000000 10876357024 11325165568 1895891808 18.793 99 18 36 0 1951644576 48885584 6867184
15:01:58 29083 8192000000 10882338912 11314999296 1875989600 18.633 98 34 69 1 1925925984 39405968 10530416
15:02:34 12697 8192000000 10877704784 11319390208 1908663632 18.896 100 34 67 1 1959115856 39363440 11088784
15:03:01 23545 8192000000 10839572480 11305570304 1907434752 18.886 100 18 37 2 1946128176 32654560 6038864
15:03:34 74714 8192000000 10847445536 11305422848 1807160288 18.073 94 12 22 2 1825389504 15457760 2771456
15:05:29 74690 8192000000 10871498528 11334877184 1926358496 19.038 100 3 6 0 1942024896 15217200 449200
15:06:50 82605 8192000000 10876372496 11345334272 1894370656 18.781 97 11 20 1 1916469200 19160624 2937920
15:08:19 119894 8192000000 10892822896 11356061696 1957672528 19.288 100 15 30 0 1981095392 18930672 4492192
15:10:31 27797 8192000000 10880174896 11326005248 1919603568 18.984 98 56 108 0 1942377056 6285376 16488112
15:11:05 43280 8192000000 10895305136 11338280960 1956671744 19.280 100 33 65 0 1973232208 7721296 8839168
15:12:02 72152 8192000000 10886075472 11335835648 1919972912 18.987 98 25 50 2 1934178032 7580304 6624816
15:13:23 54258 8192000000 10891750960 11347873792 1934441920 19.102 99 19 38 1 1956505392 17241296 4822176
15:14:23 54997 8192000000 10894913664 11346853888 1942950368 19.170 99 33 66 0 1964206448 12350304 8905776
15:15:25 91311 8192000000 10916859376 11365265408 1967955088 19.369 100 36 71 3 1990994000 13565136 9473776
15:17:04 55012 8192000000 10913480464 11367686144 1978224448 19.451 100 32 65 2 1999132288 11087296 9820544
15:18:06 138034 8192000000 10917960720 11381637120 1970309456 19.388 99 47 94 2 1993751472 10072960 13369056
15:20:30 2636 8192000000 10917920544 11384131584 1987094032 19.521 100 33 62 2 2005194544 9425696 8674816
15:20:40 8260 8192000000 10908303328 11386454016 1987770352 19.526 100 11 22 0 2000460208 8941344 3748512
15:20:55 6344 8192000000 10928001584 11387748352 1992370688 19.563 100 17 34 1 2005152512 8528448 4253376
15:21:12 17012 8192000000 10920225616 11390398464 1991818272 19.558 100 28 55 2 2009158304 9669664 7670368
15:21:37 25783 8192000000 10916007520 11380297728 1973627376 19.414 99 20 39 1 1994118528 14880816 5610336
15:22:19 34613 8192000000 10938099520 11400126464 1984816304 19.503 99 35 71 1 2011854064 14957312 12080448
15:23:29 67676 8192000000 10904831152 11390988288 1945415440 19.190 98 21 42 0 1968988688 17246368 6326880
15:24:43 60456 8192000000 10903105216 11401998336 1974457120 19.421 100 11 22 0 1997475072 19782656 3235296
15:25:50 51954 8192000000 10912917968 11385458688 1963495088 19.334 99 11 22 0 1980848720 13415744 3937888
15:26:50 80539 8192000000 10917198832 11398725632 1993502128 19.571 100 12 23 1 2009440064 12508656 3429280
15:28:25 68597 8192000000 10927435296 11405729792 1972494896 19.405 99 16 32 0 1988763712 11678240 4590576
15:30:16 67224 8192000000 10929864560 11421863936 1996396368 19.594 100 14 28 0 2022606624 22086656 4123600
15:31:33 68158 8192000000 10909721600 11388522496 1935929328 19.114 97 6 13 0 1955023984 17401536 1693120
15:32:48 31954 8192000000 10900319936 11366055936 1911321696 18.917 96 14 26 1 1920972624 6472368 3178560
15:33:27 12541 8192000000 10915668512 11370127360 1952132016 19.243 99 45 89 2 1971846992 7063392 12651584
15:33:46 15597 8192000000 10921221344 11380514816 1981796128 19.479 100 59 119 2 2007181104 8432416 16952560
15:34:09 11486 8192000000 10926972928 11385430016 1983017536 19.489 100 38 76 0 2002775104 9448416 10309152
15:34:27 40788 8192000000 10888416416 11368914944 1942501600 19.167 98 13 26 0 1954122672 8299664 3321408
15:35:14 43540 8192000000 10888159536 11351707648 1909869392 18.906 97 19 38 0 1925566272 10081664 5615216
15:36:31 97308 8192000000 10897398160 11370070016 1902727616 18.848 96 23 46 2 1920792160 11808736 6255808
15:38:17 39671 8192000000 10898307792 11362197504 1947724976 19.208 99 23 46 1 1973636096 18641344 7269776
15:39:07 43057 8192000000 10898912496 11372515328 1933107664 19.092 98 29 58 0 1954864048 13598448 8157936
15:40:00 89929 8192000000 10894154736 11365273600 1885425360 18.709 96 9 18 0 1903303504 15358896 2519248
15:41:39 88809 8192000000 10913751264 11365339136 1875817616 18.631 95 15 30 1 1887946832 8089216 4040000
15:43:20 53963 8192000000 10889411984 11357675520 1931396832 19.078 98 31 62 0 1950635392 10609376 8629184
15:44:27 73625 8192000000 10885978592 11342721024 1850790224 18.429 94 24 48 0 1869673312 12078768 6804320
15:45:46 36989 8192000000 10890380048 11347816448 1911732368 18.921 98 19 38 1 1928401312 11484544 5184400
15:46:35 73744 8192000000 10861319328 11334811648 1865561072 18.548 96 19 38 0 1883793024 12945776 5286176
15:48:21 72457 8192000000 10880478528 11348443136 1935195392 19.108 100 25 50 4 1957431360 14822208 7413760
15:49:42 83476 8192000000 10838992480 11312115712 1848063168 18.406 95 22 44 0 1869347056 15271408 6012480
15:51:25 35121 8192000000 10862448608 11298390016 1880443200 18.669 98 20 40 1 1897107520 11242640 5421680
15:52:14 72083 8192000000 10844315472 11320582144 1910160144 18.908 99 12 23 1 1921071440 8403360 2507936
15:53:32 70028 8192000000 10868384880 11336892416 1923578656 19.016 99 27 54 0 1940848960 9448448 7821856
15:54:51 54092 8192000000 10843116464 11324547072 1925715632 19.033 99 17 34 1 1940407616 10113824 4578160
15:56:39 48765 8192000000 10876718960 11344457728 1931608352 19.080 99 19 38 3 1944589808 7668288 5313168
15:57:36 89585 8192000000 10874894080 11344719872 1892774800 18.768 97 21 43 0 1907803184 8619728 6408656
15:59:28 49464 8192000000 10856775696 11338989568 1937149120 19.124 100 20 40 0 1953095040 10394048 5551872
16:00:23 50426 8192000000 10849491088 11330928640 1884017120 18.698 97 17 34 0 1901141248 12236480 4887648
16:01:24 54792 8192000000 10841498096 11321573376 1872102496 18.601 97 10 20 0 1884155568 9779952 2273120
16:02:25 91291 8192000000 10864385376 11342020608 1884582880 18.702 97 32 64 0 1903774032 10259936 8931216
16:04:02 62250 8192000000 10883252304 11343306752 1892953904 18.770 97 9 18 1 1901821408 6482896 2384608
16:05:11 47951 8192000000 10899609536 11371028480 1943780992 19.177 99 21 42 1 1957579760 8804896 4993872
16:06:33 87923 8192000000 10914027120 11392409600 1970225360 19.387 100 19 38 1 1998209584 22425600 5558624
16:08:07 55578 8192000000 10883418176 11372695552 1919401792 18.982 97 17 33 2 1937827856 13348464 5077600
16:09:13 58790 8192000000 10894219648 11372097536 1952028096 19.243 99 20 40 1 1969797216 11838976 5930144
16:10:22 41319 8192000000 10914553280 11383152640 1958556000 19.295 99 24 47 1 1979582832 14176960 6849872
16:11:10 50186 8192000000 10910485392 11386957824 1961110992 19.315 100 24 48 0 1985443936 17394384 6938560
16:12:11 58664 8192000000 10903559920 11378253824 1949560048 19.223 99 12 24 0 1968238880 14917344 3761488
16:13:19 89088 8192000000 10894862928 11390771200 1911515552 18.919 97 10 20 0 1933484832 18981904 2987376
16:14:54 99428 8192000000 10910778208 11374452736 1908137776 18.892 97 33 66 4 1926884960 10044800 8702384
16:16:40 85300 8192000000 10879666080 11358224384 1931079568 19.076 98 22 44 2 1946359488 8925488 6354432
16:18:16 71479 8192000000 10897998896 11375820800 1948810656 19.217 99 22 44 2 1968656752 13515216 6330880
16:19:41 21146 8192000000 10886048096 11362222080 1903902304 18.858 97 22 44 1 1925219024 15044528 6272192
16:20:09 40930 8192000000 10891107264 11371618304 1957644672 19.287 100 17 34 0 1978912112 15735808 5531632
16:21:09 63749 8192000000 10877514464 11382321152 1940568064 19.151 99 8 16 2 1960924064 18358448 1997552
16:22:19 8551 8192000000 10870235728 11362848768 1934555856 19.103 99 5 10 0 1950352624 14528576 1268192
16:22:37 21479 8192000000 10881286848 11366625280 1958000704 19.290 100 10 20 0 1972154896 11714736 2439456
16:24:02 63903 8192000000 10887232000 11371208704 1949122864 19.219 99 7 14 0 1963895488 12630256 2142368
16:25:16 24375 8192000000 10873843456 11361370112 1920715872 18.993 98 7 14 2 1939229136 16406752 2106512
16:25:46 15415 8192000000 10877689712 11368140800 1956600672 19.279 100 9 18 1 1972294384 13115072 2578640
16:26:10 28930 8192000000 10860956176 11353026560 1895666288 18.791 97 4 8 0 1906585632 10000480 918864
16:27:11 47558 8192000000 10893445424 11369476096 1936413728 19.118 99 20 40 1 1950599744 8926976 5259040
16:28:07 38682 8192000000 10861812000 11327418368 1884215216 18.699 96 17 34 0 1899144016 10482528 4446272
16:28:58 48343 8192000000 10877129136 11355566080 1913223600 18.933 98 27 53 1 1932975216 11362448 8389168
16:30:01 93096 8192000000 10870332608 11338330112 1856405168 18.474 95 20 40 2 1872624544 11522048 4697328
16:31:43 46555 8192000000 10866703728 11332669440 1880007200 18.665 97 17 34 0 1895196224 10220368 4968656
16:32:37 66037 8192000000 9412480832 9714995200 556537088 6.361 29 7 14 0 564714656 6434304 1743264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 03-04-2021 16:34:42 to 03-04-2021 16:35:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 145 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-04-2021 16:35:15 to 03-04-2021 16:35:17.

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          243575
MON$OLDEST_ACTIVE               243576
MON$OLDEST_SNAPSHOT             243576
MON$NEXT_TRANSACTION            243576
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                       2046816
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.33435 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33435 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33435 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33435 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Apr  3 16:33:46 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sat Apr  3 16:33:46 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

03.04.21 16:35:18. 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-04-03 16:35:21 No severe PSQL-related problems occured
03.04.21 16:35:22. End of report.