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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-18 19:27:14
DTS_END                         2021-02-18 19:27:14.7340
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/54914
TRN_ID                          231097
ATT_ID                          625
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: 8912.00 24565 1069440
customer order: creation 160.75 410 19290
customer order: refuse 14.57 345 1748
order to supplier: creation 42.59 1494 5111
order to supplier: removal 3.41 107277 409
invoice (draft): creation 42.98 3950 5157
invoice (draft): removal 51.25 943 6150
invoice accept: apply 39.53 19680 4743
invoice accept: cancel 45.80 809 5496
customer reserve: creation 3689.70 192 442764
customer reserve: removal 4539.73 60 544768
realization accept: apply 79.65 201 9558
realization accept: cancel 78.43 120 9412
payment from customer: creation 55.96 132 6715
payment from customer: removal 5.68 100 682
payment to supplier: creation 46.97 148 5636
payment to supplier: removal 3.29 78 395
service: total inventory turnovers 4.62 1265 554
service: total monetary turnovers 6.33 59 760
service: aggregate perf. data 0.73 25008 88
service: refresh index statistics 0.03 329029 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2021 19:28:57 to 18-02-2021 19:28:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5592
TEST_TIME 2 5451
TEST_TIME 3 5461
TEST_TIME 4 5407
TEST_TIME 5 5126
TEST_TIME 6 4940
TEST_TIME 7 5113
TEST_TIME 8 5526
TEST_TIME 9 5490
TEST_TIME 10 5891
TEST_TIME 11 6169
TEST_TIME 12 6817
TEST_TIME 13 6922
TEST_TIME 14 7177
TEST_TIME 15 7332
TEST_TIME 16 7787
TEST_TIME 17 7858
TEST_TIME 18 8003
TEST_TIME 19 7877
TEST_TIME 20 7892
TEST_TIME 21 8364
TEST_TIME 22 8283
TEST_TIME 23 8382
TEST_TIME 24 8739
TEST_TIME 25 8874
TEST_TIME 26 9229
TEST_TIME 27 9665
TEST_TIME 28 9932
TEST_TIME 29 9892
TEST_TIME 30 10711
TEST_TIME 31 10538
TEST_TIME 32 10459
TEST_TIME 33 10290
TEST_TIME 34 10025
TEST_TIME 35 9951
TEST_TIME 36 9862
TEST_TIME 37 9742
TEST_TIME 38 9712
TEST_TIME 39 9551
TEST_TIME 40 9553
TEST_TIME 41 9542
TEST_TIME 42 9507
TEST_TIME 43 9347
TEST_TIME 44 9532
TEST_TIME 45 9420
TEST_TIME 46 9267
TEST_TIME 47 9108
TEST_TIME 48 9201
TEST_TIME 49 9133
TEST_TIME 50 9031
TEST_TIME 51 9028
TEST_TIME 52 9083
TEST_TIME 53 9035
TEST_TIME 54 8997
TEST_TIME 55 8983
TEST_TIME 56 9058
TEST_TIME 57 9157
TEST_TIME 58 9134
TEST_TIME 59 9145
TEST_TIME 60 9054
TEST_TIME 61 9030
TEST_TIME 62 9301
TEST_TIME 63 9372
TEST_TIME 64 9316
TEST_TIME 65 9411
TEST_TIME 66 9325
TEST_TIME 67 9211
TEST_TIME 68 9245
TEST_TIME 69 9159
TEST_TIME 70 9108
TEST_TIME 71 9119
TEST_TIME 72 9074
TEST_TIME 73 9069
TEST_TIME 74 9023
TEST_TIME 75 8953
TEST_TIME 76 8904
TEST_TIME 77 8915
TEST_TIME 78 8945
TEST_TIME 79 8989
TEST_TIME 80 8949
TEST_TIME 81 9052
TEST_TIME 82 9101
TEST_TIME 83 9078
TEST_TIME 84 9086
TEST_TIME 85 9055
TEST_TIME 86 9102
TEST_TIME 87 9187
TEST_TIME 88 9143
TEST_TIME 89 9191
TEST_TIME 90 9189
TEST_TIME 91 9094
TEST_TIME 92 9090
TEST_TIME 93 9086
TEST_TIME 94 9048
TEST_TIME 95 8997
TEST_TIME 96 8996
TEST_TIME 97 8950
TEST_TIME 98 9009
TEST_TIME 99 9038
TEST_TIME 100 9025
TEST_TIME 101 9051
TEST_TIME 102 9079
TEST_TIME 103 9065
TEST_TIME 104 9077
TEST_TIME 105 9112
TEST_TIME 106 9083
TEST_TIME 107 9105
TEST_TIME 108 9121
TEST_TIME 109 9155
TEST_TIME 110 9180
TEST_TIME 111 9111
TEST_TIME 112 9111
TEST_TIME 113 9071
TEST_TIME 114 9011
TEST_TIME 115 9007
TEST_TIME 116 9018
TEST_TIME 117 8990
TEST_TIME 118 8975
TEST_TIME 119 8943
TEST_TIME 120 8915

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-02-2021 19:29:00 to 18-02-2021 19:29:04.

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 1478538 1478538 0 0.00 0 20048 7 0 0
doc_list_biud 1478532 1478532 0 0.00 0 26849 29 0 0
sp_add_invoice_to_stock 4830 4743 87 1.80 21 166730 19681 0 87
sp_cancel_adding_invoice 5496 5496 0 0.00 5 49867 810 0 0
sp_cancel_client_order 1748 1748 0 0.00 4 12191 345 0 0
sp_cancel_customer_reserve 544768 544768 0 0.00 1 26851 61 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 3 5325 101 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 2501 78 0 0
sp_cancel_supplier_invoice 6153 6150 3 0.04 1 16957 944 0 3
sp_cancel_supplier_order 409 409 0 0.00 6 968115 107277 0 0
sp_cancel_write_off 9412 9412 0 0.00 1 12835 121 0 0
sp_client_order 19290 19290 0 0.00 3 30598 411 0 0
sp_customer_reserve 442764 442764 0 0.00 0 39825 193 0 0
sp_fill_shopping_cart 29541 29541 0 0.00 1 15686 43 0 0
sp_fill_shopping_cart_clo_res 442759 442759 0 0.00 0 15779 15 0 0
sp_get_clo_for_invoice 4738 4738 0 0.00 0 22869 353 0 0
sp_kill_cost_storno 15985 15985 0 0.00 0 10876 62 0 0
sp_kill_qstorno_ret_qs2qd 1105507 1105507 0 0.00 0 26808 33 0 0
sp_kill_qty_storno 582277 582277 0 0.00 0 26849 73 0 0
sp_lock_selected_doc 19936 19936 0 0.00 0 6804 7 0 0
sp_make_cost_storno 26647 26647 0 0.00 0 16835 65 0 0
sp_multiply_rows_for_pdistr 26646 26646 0 0.00 0 12850 32 0 0
sp_multiply_rows_for_qdistr 19290 19290 0 0.00 0 13652 180 0 0
sp_pay_from_customer 6715 6715 0 0.00 4 23893 132 0 0
sp_pay_to_supplier 5636 5636 0 0.00 5 14971 149 0 0
sp_payment_common 12349 12349 0 0.00 1 23884 43 0 0
sp_qd_handle_on_cancel_clo 1748 1748 0 0.00 0 12186 307 0 0
sp_qd_handle_on_invoice_upd_sts 10234 10234 0 0.00 0 22694 385 0 0
sp_qd_handle_on_reserve_upd_sts 9556 9556 0 0.00 0 19939 62 0 0
sp_reserve_write_off 9558 9558 0 0.00 7 21047 201 0 0
sp_supplier_invoice 5157 5157 0 0.00 7 89946 3951 0 0
sp_supplier_order 5111 5111 0 0.00 5 66615 1494 0 0
srv_aggregate_perf_data 88 88 0 0.00 2892 633477 25009 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1195 184118 31393 0 0
srv_find_qd_qs_mism 1023700 1023700 0 0.00 0 13013 5 0 0
srv_make_invnt_saldo 554 554 0 0.00 37 54324 1266 0 0
srv_make_money_saldo 760 760 0 0.00 0 24055 59 0 0
srv_recalc_idx_stat 4 4 0 0.00 261501 438933 329029 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4743 4743 0 0.00 0 20828 217 0 0
t$perf-norm:sp_cancel_adding_invoice 347 347 0 0.00 0 5362 122 0 0
t$perf-norm:sp_cancel_client_order 1748 1748 0 0.00 0 5640 18 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 4425 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 627 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 3072 25 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 5235 38 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 42288 1737 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 2931 8 0 0
t$perf-norm:sp_client_order 19290 19290 0 0.00 0 6969 19 0 0
t$perf-norm:sp_customer_reserve 978 978 0 0.00 0 2532 6 0 0
t$perf-norm:sp_pay_from_customer 6715 6715 0 0.00 0 17855 17 0 0
t$perf-norm:sp_pay_to_supplier 5636 5636 0 0.00 0 7818 11 0 0
t$perf-norm:sp_reserve_write_off 9558 9558 0 0.00 0 11072 13 0 0
t$perf-norm:sp_supplier_invoice 5157 5157 0 0.00 0 5880 22 0 0
t$perf-norm:sp_supplier_order 5111 5111 0 0.00 0 5967 20 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 761 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 4043 49 0 0
t$perf-norm:srv_make_invnt_saldo 554 554 0 0.00 0 2073 22 0 0
t$perf-norm:srv_make_money_saldo 760 760 0 0.00 0 1291 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 9650 9476 174 1.80 0 4913 23 0 174
v_all_customers 34946 34946 0 0.00 0 153 1 0 0
v_all_suppliers 28544 28544 0 0.00 0 20 1 0 0
v_all_wares 38578 38578 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 694 694 0 0.00 0 1738 13 0 0
v_cancel_client_order 3496 3496 0 0.00 0 3458 10 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 2768 13 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 1882 6 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 1980 8 0 0
v_cancel_supplier_invoice 786 780 6 0.76 0 2772 19 0 6
v_cancel_supplier_order 818 818 0 0.00 0 2866 14 0 0
v_cancel_write_off 1926 1926 0 0.00 0 3465 22 0 0
v_max_id_clo_ord 5105 5105 0 0.00 0 3586 3 0 0
v_max_id_clo_res 977 977 0 0.00 0 1014 8 0 0
v_max_id_ord_sup 5146 5146 0 0.00 0 6961 5 0 0
v_max_non_paid_invoice 1613 1613 0 0.00 0 4520 6 0 0
v_max_non_paid_realizn 3701 3701 0 0.00 0 6860 9 0 0
v_min_id_clo_ord 5105 5105 0 0.00 0 10503 8 0 0
v_min_id_clo_res 977 977 0 0.00 0 2590 11 0 0
v_min_id_ord_sup 5146 5146 0 0.00 0 5534 8 0 0
v_min_non_paid_invoice 5634 5634 0 0.00 0 14941 30 0 0
v_min_non_paid_realizn 6715 6715 0 0.00 0 23879 31 0 0
v_our_firm 9660 9660 0 0.00 0 14 1 0 0
v_reserve_write_off 19112 19112 0 0.00 0 3462 6 0 0
x_lock_depdocs_on_canc_invoice 11256 11256 0 0.00 0 14060 137 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 5212 357 0 0
x_make_qstorno_1000_1200 5111 5111 0 0.00 2 63841 1403 0 0
x_make_qstorno_1200_2000 5157 5157 0 0.00 3 89937 3801 0 0
x_make_qstorno_2100_3300 442764 442764 0 0.00 0 31472 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2021 19:29:05 to 18-02-2021 19:29:09.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 19 8192000000 8804615952 8816984064 10072608 0.122 3 1 2 0 10193872 58704 62560
16:57:25 10435 8192000000 10222473616 10523832320 836770944 9.267 68 52 105 0 857648176 2442960 18434272
16:57:47 30055 8192000000 10341443840 10654920704 1381625680 14.431 100 90 180 0 1416148208 4660544 29861984
16:58:26 23562 8192000000 10371573984 10693545984 1422310624 14.793 100 84 168 0 1456112000 6006944 27794432
16:59:04 25602 8192000000 10419759040 10746376192 1463009008 15.152 100 89 178 0 1498888480 7175200 28704272
16:59:41 13667 8192000000 10435816064 10762723328 1490539120 15.394 100 95 190 0 1528781616 8147984 30094512
17:00:13 21923 8192000000 10451208816 10783027200 1505541056 15.524 100 89 178 0 1542644336 8605808 28497472
17:00:45 16700 8192000000 10453421616 10791133184 1513892736 15.597 100 85 170 1 1549932976 8943664 27096576
17:01:12 19312 8192000000 10483910144 10824081408 1533614160 15.768 100 86 172 0 1569658560 9195424 26848976
17:01:40 13752 8192000000 10498087744 10845057024 1559071872 15.988 100 81 162 1 1593634896 9625408 24937616
17:02:05 15102 8192000000 10531202640 10883653632 1591665808 16.268 100 82 164 1 1626244528 9550528 25028192
17:02:29 11367 8192000000 10555930528 10912817152 1608359984 16.411 100 70 140 0 1639781728 9902240 21519504
17:02:49 11470 8192000000 10569662608 10932719616 1632000304 16.612 100 78 156 2 1666550384 10766320 23783760
17:03:09 8272 8192000000 10589002144 10952937472 1645749728 16.728 100 74 148 0 1678413552 10565184 22098640
17:03:25 13911 8192000000 10623507664 10986168320 1676340032 16.987 100 83 166 1 1712158800 11642960 24175808
17:03:49 9372 8192000000 10627532112 10997698560 1689176896 17.094 100 78 156 1 1724491488 12486336 22828256
17:04:08 7991 8192000000 10640894096 11009683456 1705656672 17.232 100 82 164 1 1743032944 13646736 23729536
17:04:23 7883 8192000000 10658998672 11027193856 1717138736 17.328 100 86 172 0 1755668736 14240368 24289632
17:04:37 5576 8192000000 10664441136 11034849280 1721337568 17.363 100 84 167 0 1759341056 14686560 23316928
17:04:49 6300 8192000000 10676190208 11051159552 1733624576 17.466 100 85 169 1 1771847280 14363072 23859632
17:05:03 3500 8192000000 10686091376 11060285440 1748564096 17.590 100 88 174 1 1787664272 14306752 24793424
17:05:14 4237 8192000000 10695977152 11069894656 1752270688 17.620 100 80 160 1 1788912512 14106064 22535760
17:05:26 2844 8192000000 10704946592 11081793536 1767504304 17.746 100 90 180 1 1806176192 13442944 25228944
17:05:36 5141 8192000000 10715029760 11095379968 1773306480 17.794 100 88 176 2 1812051088 13895776 24848832
17:05:49 3518 8192000000 10717603040 11096240128 1781444016 17.861 100 83 162 3 1817528144 12393168 23690960
17:05:59 3818 8192000000 10728682784 11110264832 1785847808 17.898 100 79 158 0 1821673056 13747584 22077664
17:06:10 2583 8192000000 10740896016 11119030272 1797517904 17.994 100 93 187 2 1837484768 14447152 25519712
17:06:20 10104 8192000000 10750295056 11127316480 1804366640 18.050 100 86 170 2 1841862832 14250768 23245424
17:06:36 6020 8192000000 10759056592 11140755456 1805200304 18.057 100 82 165 2 1841618368 14098640 22319424
17:06:49 2157 8192000000 10768491168 11150426112 1824211248 18.212 100 90 180 1 1865174112 15264880 25697984
17:06:58 1764 8192000000 10766328880 11150974976 1827916608 18.242 100 90 180 2 1868507168 14599264 25991296
17:07:06 1262 8192000000 10776806240 11157024768 1829888752 18.258 100 87 175 0 1868917712 13562768 25466192
17:07:13 2065 8192000000 10781229056 11165241344 1835488320 18.304 100 92 185 2 1876341456 14329664 26523472
17:07:22 2313 8192000000 10787866784 11173179392 1845603920 18.386 100 86 171 3 1881655376 12216704 23834752
17:07:30 2240 8192000000 10797007760 11180834816 1851977552 18.438 100 87 175 1 1888489776 12422672 24089552
17:07:39 1860 8192000000 10800074944 11189665792 1862064448 18.520 100 95 191 2 1902042480 12920672 27057360
17:07:47 2046 8192000000 10809835264 11194687488 1861329632 18.514 100 87 173 2 1897892000 10883296 25679072
17:07:56 1974 8192000000 10809153184 11198816256 1865817936 18.550 100 91 183 1 1905324256 12411216 27095104
17:08:04 27397 8192000000 10790296848 11191615488 1861629488 18.516 100 66 131 2 1890747312 10003664 19114160
17:08:39 30422 8192000000 10773054736 11192504320 1858669504 18.492 100 36 72 1 1876260416 6981008 10609904
17:09:17 7562 8192000000 10777506176 11195015168 1862430672 18.523 100 25 50 1 1876237904 5896032 7911200
17:09:31 6282 8192000000 10771343936 11199188992 1866879296 18.559 100 32 62 1 1883866320 8257744 8729280
17:09:46 7455 8192000000 10769766192 11194048512 1867158752 18.561 100 23 46 0 1879633312 6369504 6105056
17:10:03 8587 8192000000 10781975776 11204886528 1869116048 18.577 100 19 38 0 1880780912 6022048 5642816
17:10:21 5920 8192000000 10796982256 11212718080 1874564576 18.621 100 32 64 5 1889549184 5494416 9490192
17:10:37 7501 8192000000 10785434864 11211837440 1878626848 18.654 100 28 56 2 1892778944 5888112 8263984
17:10:53 9545 8192000000 10781973328 11212288000 1877477664 18.645 100 21 40 1 1888752992 6012400 5262928
17:11:09 5934 8192000000 10776359200 11213185024 1879820720 18.664 100 24 48 1 1893660576 7065760 6774096
17:11:23 6140 8192000000 10799234496 11218010112 1881880896 18.680 100 28 55 2 1895203456 5909792 7412768
17:11:36 9215 8192000000 10787178080 11220439040 1884418288 18.701 100 32 62 3 1900491312 6938272 9134752
17:11:51 14709 8192000000 10790862944 11222978560 1882665424 18.687 100 7 14 0 1889733776 5294064 1774288
17:12:14 7048 8192000000 10792194256 11225403392 1888893664 18.737 100 31 63 1 1904626016 7039456 8692896
17:12:27 12976 8192000000 10790776768 11225149440 1890065168 18.746 100 17 34 3 1901514128 5993760 5455200
17:12:47 64536 8192000000 10844958512 11243163648 1897892784 18.809 100 67 136 4 1922772480 5166928 19712768
17:13:57 3803 8192000000 10810406208 11239718912 1894558096 18.782 100 36 72 1 1913964912 9067696 10339120
17:14:08 4813 8192000000 10811568496 11242225664 1896493792 18.798 100 42 82 3 1916524496 8231760 11798944
17:14:20 7952 8192000000 10823761472 11249762304 1898435328 18.814 100 31 62 1 1913620512 6721888 8463296
17:14:34 7905 8192000000 10819352816 11249135616 1904362592 18.861 100 34 68 0 1921855360 7311616 10181152
17:14:51 6597 8192000000 10823677248 11248082944 1902152384 18.844 100 34 71 1 1919209024 7596528 9460112
17:15:05 6108 8192000000 10809979888 11245166592 1908421088 18.894 100 33 66 2 1925204352 6999552 9783712
17:15:17 6675 8192000000 10819210864 11246632960 1900870288 18.833 100 25 50 2 1914839328 6457456 7511584
17:15:31 6889 8192000000 10806721776 11246792704 1901307104 18.837 100 30 57 1 1916004976 6694016 8003856
17:15:44 53624 8192000000 10812122672 11249311744 1903049456 18.851 100 22 44 2 1914531872 5288896 6193520
17:16:44 9336 8192000000 10822611520 11245703168 1877690976 18.646 99 20 40 1 1892964880 9852736 5421168
17:17:00 5335 8192000000 10813394400 11241480192 1896128880 18.795 100 27 52 1 1917445968 13833840 7483248
17:17:15 7764 8192000000 10793642000 11232612352 1875663904 18.630 99 26 53 1 1894139568 10883328 7592336
17:17:33 8576 8192000000 10775992064 11203043328 1848406032 18.409 99 32 61 2 1864492096 6029040 10057024
17:17:52 5476 8192000000 10786081184 11208663040 1864404352 18.539 100 21 42 1 1876877376 6107440 6365584
17:18:05 9078 8192000000 10771847760 11193425920 1826479568 18.231 98 15 29 1 1835311312 5051104 3780640
17:18:21 5489 8192000000 10759038880 11183296512 1838347552 18.327 99 26 52 0 1851371040 5990864 7032624
17:18:32 3725 8192000000 10753954816 11180707840 1829842992 18.258 99 24 47 3 1843551648 6324352 7384304
17:18:43 5950 8192000000 10745763840 11164434432 1809250512 18.090 98 33 65 0 1825450608 6409568 9790528
17:18:56 6304 8192000000 10739087376 11166023680 1834549520 18.296 100 34 68 0 1851422912 6956864 9916528
17:19:08 9781 8192000000 10734279936 11150581760 1734736064 17.475 94 23 46 0 1747198432 5896272 6566096
17:19:24 6591 8192000000 10765213920 11184214016 1844111216 18.374 100 25 50 1 1857826528 6401264 7314048
17:19:38 7252 8192000000 10707444736 11130847232 1764566208 17.722 97 23 46 0 1776854128 5517792 6770128
17:19:51 33329 8192000000 10664752304 11072090112 1656846464 16.822 92 23 46 1 1668597552 4874752 6876336
17:20:37 40862 8192000000 10696493264 11105492992 1611982112 16.442 90 27 53 2 1624625728 5141504 7502112
17:21:24 5782 8192000000 10721011680 11128946688 1778883184 17.840 99 37 74 2 1796572720 7133376 10556160
17:21:40 4508 8192000000 10719426736 11137445888 1805325808 18.058 100 46 92 2 1826962032 8105520 13530704
17:21:51 7952 8192000000 10718270976 11137261568 1776197104 17.818 98 25 49 2 1789235984 6474880 6564000
17:22:06 8543 8192000000 10728219888 11152867328 1818133520 18.162 100 18 36 0 1829215088 5333504 5748064
17:22:21 5123 8192000000 10707844416 11122520064 1769287232 17.761 98 40 77 0 1785335584 4710880 11337472
17:22:32 5406 8192000000 10703827168 11129896960 1787992672 17.915 99 30 60 1 1802225936 5691888 8541376
17:22:44 6231 8192000000 10714707744 11133632512 1791268064 17.942 99 16 32 2 1801720896 5925776 4527056
17:22:56 8303 8192000000 10735528240 11158978560 1818079616 18.162 100 17 34 1 1827391824 4513504 4798704
17:23:15 8486 8192000000 10748504960 11166879744 1829694016 18.257 100 26 49 3 1842164384 4876448 7593920
17:23:30 7108 8192000000 10758861776 11174576128 1835711088 18.306 100 22 44 0 1848011840 5241328 7059424
17:23:43 12480 8192000000 10754425680 11185287168 1844232448 18.375 100 23 46 1 1856612992 5628720 6751824
17:24:01 12117 8192000000 10766551456 11188350976 1848822192 18.413 100 19 38 0 1860564384 6143536 5598656
17:24:25 71141 8192000000 10754544432 11193573376 1857826528 18.486 100 29 58 0 1873131584 5635488 9669568
17:25:43 8497 8192000000 10777177344 11205304320 1861666672 18.517 100 30 59 1 1876149424 6372224 8110528
17:25:58 6119 8192000000 10775882816 11201220608 1861901984 18.519 100 21 42 0 1872966160 5377280 5686896
17:26:11 4883 8192000000 10785740720 11207069696 1865939168 18.551 100 30 60 4 1881627360 7542256 8145936
17:26:24 7236 8192000000 10792364496 11213766656 1867245872 18.562 100 26 52 1 1884748976 9935024 7568080
17:26:41 7607 8192000000 10783275904 11214471168 1873618816 18.614 100 32 64 0 1889882480 7687280 8576384
17:26:56 11533 8192000000 10792265568 11220742144 1877326128 18.644 100 27 54 2 1890777952 5340864 8110960
17:27:16 34118 8192000000 10829300640 11245187072 1899191536 18.820 100 41 83 1 1916849392 5637536 12020320
17:28:00 4617 8192000000 10847857408 11262304256 1911954992 18.922 100 49 97 0 1934042592 7201008 14886592
17:28:18 9820 8192000000 10859927776 11274276864 1921355632 18.998 100 58 116 0 1947590224 9321440 16913152
17:28:37 16191 8192000000 10859080864 11278503936 1925604976 19.032 100 55 108 1 1951212672 10316880 15290816
17:29:02 28043 8192000000 10855454144 11280969728 1926416976 19.038 100 43 86 0 1947684192 9634688 11632528
17:29:39 23393 8192000000 10858127456 11287556096 1931979056 19.083 100 45 89 1 1954473216 9351696 13142464
17:30:17 115299 8192000000 10875148656 11308285952 1944972544 19.186 100 34 68 0 1964294704 9238176 10083984
17:32:25 26124 8192000000 10894213600 11328180224 1958368016 19.293 100 50 99 1 1983306960 10286336 14652608
17:33:07 2895 8192000000 10901368016 11331280896 1966596192 19.358 100 46 92 1 1991185504 10522672 14066640
17:33:17 9705 8192000000 10903338032 11328098304 1965514272 19.350 100 54 107 2 1992472752 11143216 15815264
17:33:41 21358 8192000000 10900953600 11334361088 1967972608 19.369 100 54 108 1 1997089376 13565008 15551760
17:34:16 11019 8192000000 10918618720 11348631552 1976449872 19.437 100 49 94 1 2005684240 14764560 14469808
17:34:37 11766 8192000000 10927840896 11352334336 1984445984 19.500 100 62 120 1 2017161680 15075440 17640256
17:34:56 6581 8192000000 10932349632 11357995008 1983849072 19.495 100 56 112 1 2015667824 15595088 16223664
17:35:10 16126 8192000000 10926423840 11362164736 1984788528 19.503 100 58 116 0 2019941168 17851840 17300800
17:35:35 6168 8192000000 10931051984 11363274752 1992012368 19.560 100 63 126 3 2027369664 15830864 19526432
17:35:53 9017 8192000000 10921782000 11350188032 1976566416 19.438 100 53 106 0 2007799360 15470384 15762560
17:36:11 7866 8192000000 10922942944 11350573056 1978986672 19.457 100 48 96 2 2009213680 15468176 14758832
17:36:26 10734 8192000000 10919894704 11353882624 1975683920 19.431 100 45 87 0 2007665632 18049200 13932512
17:36:48 6020 8192000000 10954484864 11370180608 1988649840 19.533 100 62 124 1 2028320496 21575984 18094672
17:37:01 6089 8192000000 10955272176 11380924416 1994686400 19.581 100 73 146 1 2039552912 23586208 21280304
17:37:18 6155 8192000000 10962728688 11386617856 2002131120 19.640 100 71 142 0 2048383808 24908624 21344064
17:37:34 3011 8192000000 10958261040 11387031552 2003739952 19.652 100 67 134 1 2046568992 22612176 20216864
17:37:45 10419 8192000000 10961390192 11389988864 2006556416 19.674 100 63 126 1 2048117216 22005280 19555520
17:38:04 3382 8192000000 10969175200 11399249920 2010023904 19.702 100 64 126 0 2055529776 26124608 19381264
17:38:16 11771 8192000000 10962970560 11382632448 1981712400 19.478 99 75 150 2 2032626512 27700464 23213648
17:38:38 11347 8192000000 10963586528 11397844992 2002142704 19.640 100 55 110 1 2052974032 33060384 17770944
17:39:04 4494 8192000000 10969945984 11396644864 2003356016 19.649 100 67 134 2 2056850432 32555360 20939056
17:39:19 2102 8192000000 10969604976 11393507328 1998556464 19.611 100 72 141 0 2054685840 33737424 22391952
17:39:28 5052 8192000000 10954425424 11385085952 1978645328 19.454 99 72 143 0 2034193888 33446256 22102304
17:39:47 5008 8192000000 10955469632 11378868224 1988806640 19.534 100 76 149 2 2043301472 32281856 22212976
17:40:00 4480 8192000000 10956184704 11377741824 1990935392 19.551 100 70 140 0 2041583760 29977232 20671136
17:40:14 7994 8192000000 10937173440 11358511104 1953751216 19.256 98 60 121 1 2002535008 30746976 18036816
17:40:29 1713 8192000000 10957046864 11378204672 1984420256 19.500 100 78 154 1 2040594832 32750688 23423888
17:40:38 4508 8192000000 10962936928 11387559936 1994755104 19.581 100 78 154 2 2048099680 30864976 22479600
17:40:50 5886 8192000000 10956268304 11379544064 1984627360 19.501 100 75 151 0 2040998448 32947008 23424080
17:41:03 3373 8192000000 10969184560 11397070848 1998579936 19.612 100 71 143 0 2055190368 34695728 21914704
17:41:13 2696 8192000000 10970996816 11393609728 1996073648 19.592 100 78 153 2 2055307248 35177392 24056208
17:41:22 5458 8192000000 10973335216 11392806912 1991232048 19.554 100 84 168 0 2053741184 36807488 25701648
17:41:38 10095 8192000000 10964078832 11388559360 1993813104 19.574 100 76 151 2 2049260256 33140416 22306736
17:41:56 2001 8192000000 10985639392 11400544256 2002426624 19.642 100 88 175 1 2063480240 34753712 26299904
17:42:04 6434 8192000000 10990705440 11416694784 2009548496 19.698 100 82 164 1 2071977808 37658688 24770624
17:42:27 3545 8192000000 10969837744 11395444736 1996756208 19.597 99 67 133 0 2053144448 36118080 20270160
17:42:42 4884 8192000000 10983715408 11413504000 2006924896 19.677 100 68 135 1 2067294880 38940240 21429744
17:42:55 3584 8192000000 10979453392 11405078528 2001588208 19.635 100 79 158 1 2066850432 39615952 25646272
17:43:06 1726 8192000000 10968392816 11386261504 1984641968 19.501 99 76 151 1 2047420416 39030240 23748208
17:43:15 1751 8192000000 10954237456 11382935552 1976032960 19.433 99 77 153 0 2036271632 37248864 22989808
17:43:24 3441 8192000000 10986231168 11403808768 1998617392 19.612 100 87 174 2 2063107904 38838656 25651856
17:43:34 3057 8192000000 10982532192 11402891264 1996806832 19.598 100 88 173 2 2059793760 37994288 24992640
17:43:45 1191 8192000000 10979125520 11397701632 1997848960 19.606 100 89 178 0 2058955152 34663360 26442832
17:43:52 3328 8192000000 10980620144 11404136448 2004762000 19.660 100 87 172 2 2068521424 37569760 26189664
17:44:02 2611 8192000000 10977100448 11400781824 1998283600 19.609 100 72 143 1 2057640560 38092480 21264480
17:44:13 1634 8192000000 10982853472 11402731520 2001288672 19.633 100 85 171 0 2066288976 39404768 25595536
17:44:23 3295 8192000000 10970416128 11399766016 1998779968 19.613 100 68 135 2 2058682960 39464928 20438064
17:44:36 8126 8192000000 10974807888 11406745600 1999208960 19.616 100 58 115 4 2056403136 39911248 17282928
17:44:53 5388 8192000000 10974064256 11410071552 2005028064 19.662 100 62 120 3 2060689856 36584656 19077136
17:45:09 4941 8192000000 10959068224 11405656064 2000009584 19.623 100 43 86 0 2050265536 37101248 13154704
17:45:28 11181 8192000000 10951815952 11394465792 1976186544 19.434 99 43 86 0 2025944208 35840320 13917344
17:45:46 9423 8192000000 10909979376 11338592256 1917222160 18.965 96 45 91 3 1966767488 35410496 14134832
17:46:05 2834 8192000000 10924004512 11351142400 1945601680 19.191 99 66 132 1 2001522576 35679168 20241728
17:46:25 4627 8192000000 10938369616 11369750528 1963934336 19.337 100 63 125 1 2021816144 37849248 20032560
17:46:37 8271 8192000000 10926526288 11357151232 1951107296 19.235 100 55 110 2 2008543696 39240000 18196400
17:46:53 5093 8192000000 10904930016 11327057920 1896823536 18.801 97 71 140 2 1959532608 40971440 21737632
17:47:05 4167 8192000000 10916992944 11329069056 1924431088 19.022 99 81 162 2 1993158128 42701120 26025920
17:47:17 5217 8192000000 10936621504 11352440832 1945664608 19.192 100 81 162 0 2015980192 45160272 25155312
17:47:32 4129 8192000000 10943750848 11364438016 1954053152 19.259 100 74 148 0 2026135104 48627760 23454192
17:47:45 2812 8192000000 10956728240 11378278400 1963615088 19.335 100 78 154 0 2038871328 50937664 24318576
17:47:58 4266 8192000000 10952776304 11373318144 1961011856 19.314 100 66 132 0 2033165872 50538000 21616016
17:48:11 5078 8192000000 10955619728 11381141504 1965836240 19.352 100 59 118 1 2031764480 47520336 18407904
17:48:25 11467 8192000000 10913753680 11356495872 1947332832 19.205 99 51 102 1 2005728256 42734064 15661360
17:48:47 5784 8192000000 10921809248 11351830528 1918958496 18.978 98 47 94 1 1973928864 40585792 14384576
17:49:04 10513 8192000000 10936203072 11368677376 1958901936 19.297 100 62 123 1 2023246400 44776240 19568224
17:49:21 5666 8192000000 10929571120 11365863424 1950789328 19.233 100 47 94 2 2012495744 46379648 15326768
17:49:39 9576 8192000000 10939173280 11360727040 1935967280 19.115 99 67 133 1 2004452544 48100256 20385008
17:49:57 3175 8192000000 10946176384 11361804288 1938300960 19.133 99 88 173 2 2014214064 49147376 26765728
17:50:07 7152 8192000000 10930776048 11363950592 1946021104 19.195 100 56 112 1 2014097392 50469152 17607136
17:50:23 5517 8192000000 10926005056 11366531072 1947181280 19.204 100 34 68 0 2007809776 48823120 11805376
17:50:37 13201 8192000000 10923748144 11361509376 1928118320 19.052 99 37 72 2 1990969456 50306320 12544816
17:51:06 1655 8192000000 10950674176 11360444416 1941567120 19.159 100 85 174 5 2021650112 51965248 28117744
17:51:14 2890 8192000000 10921793360 11344384000 1913478944 18.935 99 70 138 2 1991071616 55456656 22136016
17:51:29 8322 8192000000 10904370368 11342221312 1928925616 19.058 100 44 88 1 1992807728 48967760 14914352
17:51:47 20434 8192000000 10902651648 11356917760 1933155232 19.092 100 34 68 0 1992509440 46814096 12540112
17:52:13 13585 8192000000 10917062624 11357597696 1942620944 19.168 100 35 70 0 1998679360 43856368 12202048
17:52:38 21371 8192000000 10929225984 11372929024 1946867472 19.202 100 31 62 0 2006691472 48626736 11197264
17:53:08 13564 8192000000 10932237408 11375857664 1950860160 19.233 100 30 60 1 2014019648 51670416 11489072
17:53:38 12194 8192000000 10935367424 11387027456 1954490112 19.262 100 33 66 2 2020308944 53780576 12038256
17:54:03 28361 8192000000 10919729008 11373133824 1958003552 19.290 100 27 54 0 2008405312 40847488 9554272
17:55:25 31238 8192000000 10884666944 11338956800 1927371296 19.046 99 27 54 0 1961656400 24877488 9407616
17:56:03 27420 8192000000 10889786880 11341950976 1930549920 19.071 100 23 46 3 1971912112 32988736 8373456
17:56:48 41080 8192000000 10894295056 11339067392 1919932224 18.986 99 34 68 3 1962386496 31270016 11184256
17:57:36 9308 8192000000 10897668368 11343171584 1941593728 19.159 100 45 91 3 1982255056 26295712 14365616
17:57:56 11166 8192000000 10879739488 11337129984 1949709504 19.224 100 28 57 2 1967049600 9237520 8102576
17:58:20 32832 8192000000 10906863232 11358527488 1939562336 19.143 99 45 88 1 1960164240 8943488 11658416
17:59:03 59408 8192000000 10871205968 11336982528 1951403312 19.238 100 27 54 0 1971607792 12599824 7604656
18:00:28 56797 8192000000 10885464112 11336757248 1948978608 19.218 100 20 40 2 1965094080 10369136 5746336
18:01:41 59642 8192000000 10870005456 11336642560 1940200912 19.148 99 12 24 0 1953669328 10256944 3211472
18:03:52 19575 8192000000 10880731248 11342475264 1946376784 19.198 100 16 32 0 1963278496 12575216 4326496
18:04:32 5908 8192000000 10865710144 11318616064 1901214720 18.836 98 32 64 3 1923824320 13123392 9486208
18:04:46 69978 8192000000 10878009232 11337392128 1934703840 19.104 100 20 40 3 1949698272 10141488 4852944
18:06:03 62211 8192000000 10883935728 11338543104 1923486512 19.015 98 43 87 0 1948058448 11388912 13183024
18:07:27 85647 8192000000 10882832704 11355983872 1927659792 19.048 99 17 34 1 1955342144 22054864 5627488
18:09:01 84919 8192000000 10889788848 11358601216 1942864064 19.170 99 16 33 0 1962568272 14711600 4992608
18:10:54 79736 8192000000 10885041856 11366359040 1920436144 18.990 98 13 26 1 1951124736 27303152 3385440
18:12:21 45203 8192000000 10885865328 11344424960 1958896304 19.297 100 20 42 1 1974193648 9466608 5830736
18:13:20 79539 8192000000 10907391216 11365826560 1971701600 19.399 100 23 46 0 1985952176 7414000 6836576
18:14:50 69325 8192000000 10890936704 11375960064 1969122112 19.378 100 13 26 0 1985167632 12318976 3726544
18:16:05 79124 8192000000 10894562336 11377336320 1981393744 19.476 100 23 46 1 1999942464 11986224 6562496
18:17:34 49508 8192000000 10899613856 11376717824 1941867840 19.162 98 9 18 1 1960791744 16183952 2739952
18:18:36 53284 8192000000 10900374432 11388481536 1978362032 19.452 100 4 8 0 1994838304 15457376 1018896
18:19:38 62630 8192000000 10899956432 11379580928 1944810608 19.185 98 8 17 0 1958754592 11133664 2810320
18:20:47 41831 8192000000 10905938096 11368935424 1959848064 19.305 99 15 30 0 1973952048 9863280 4240704
18:21:44 79579 8192000000 10893603440 11365117952 1911645760 18.920 96 13 26 0 1930371264 14946464 3779040
18:23:19 121589 8192000000 10906733584 11374526464 1937675440 19.128 98 14 28 0 1965032224 23242864 4113920
18:25:28 47637 8192000000 10903640272 11360182272 1937970832 19.131 98 24 48 0 1957723152 13221648 6530672
18:26:25 50090 8192000000 10919227168 11384373248 1955672848 19.272 99 23 46 0 1978640592 16510672 6457072
18:27:24 73388 8192000000 10900996576 11361869824 1906194288 18.876 96 29 58 0 1932228416 17999472 8034656
18:28:44 184118 8192000000 10878903104 11337678848 1774906160 17.807 90 11 22 0 1803406896 25090032 3410704
18:32:02 56249 8192000000 10864626448 11337252864 1889058768 18.738 97 19 38 2 1905940080 11959536 4921776
18:33:19 81720 8192000000 10878307712 11326459904 1933962832 19.099 99 42 82 1 1952857376 7640544 11254000
18:34:55 49986 8192000000 10866367168 11341017088 1916638560 18.960 98 23 46 1 1934397824 11171488 6587776
18:35:51 60017 8192000000 10890067648 11351535616 1964159152 19.339 100 44 88 1 1985091264 7886624 13045488
18:37:02 13396 8192000000 10861848048 11325280256 1921646704 19.000 98 24 48 0 1935929792 7819376 6463712
18:37:28 33000 8192000000 10870585584 11335987200 1936833696 19.121 99 50 100 0 1960965056 9034864 15096496
18:38:13 37990 8192000000 10870426880 11348766720 1959683856 19.304 100 13 26 3 1970854128 7681008 3489264
18:40:03 55148 8192000000 10842998896 11311652864 1910489616 18.911 99 11 22 0 1922617280 8764160 3363504
18:41:11 62373 8192000000 10854696352 11315671040 1924874816 19.026 99 11 22 0 1935481936 6963520 3643600
18:42:33 75879 8192000000 10860248496 11334094848 1896472832 18.798 97 17 34 1 1912423440 10894496 5056112
18:43:58 33741 8192000000 10842735440 11323764736 1901275968 18.837 98 15 30 0 1917435088 11790928 4368192
18:44:41 57581 8192000000 10871516096 11348967424 1921399216 18.998 99 15 30 0 1944321344 18590432 4331696
18:45:51 52853 8192000000 10849338928 11315421184 1845894256 18.389 95 22 44 0 1865373616 13087248 6392112
18:46:50 57804 8192000000 10869753504 11336310784 1918921376 18.978 99 22 43 0 1937986896 12976944 6088576
18:47:59 36672 8192000000 10857510240 11335581696 1899740144 18.824 98 25 51 2 1922805760 15349728 7715888
18:48:42 81338 8192000000 10868478224 11327750144 1918377600 18.974 99 16 32 1 1931089408 8374000 4337808
18:50:10 35691 8192000000 10833912160 11285454848 1838599792 18.329 95 33 66 1 1856025616 8349456 9076368
18:50:52 44425 8192000000 10861599856 11310698496 1885180656 18.707 98 31 62 0 1904403024 10722960 8499408
18:51:47 48205 8192000000 10885274816 11326476288 1890734416 18.752 98 36 71 1 1914327488 13209280 10383792
18:52:44 77503 8192000000 10859273424 11337707520 1915756784 18.953 99 33 67 0 1944638128 19391648 9489696
18:54:26 52377 8192000000 10857110384 11315511296 1876114544 18.634 97 16 32 1 1892967568 12605904 4247120
18:55:26 32355 8192000000 10878867744 11325730816 1909712032 18.904 99 31 62 2 1934451312 16401712 8337568
18:56:05 6819 8192000000 10877306000 11323359232 1920740720 18.993 99 52 104 1 1946272176 10077088 15454368
18:56:23 11707 8192000000 10874282832 11309592576 1890290720 18.748 98 59 114 2 1918015952 10936528 16788704
18:56:42 38142 8192000000 10858870496 11325444096 1904014640 18.859 99 37 74 0 1926486128 12671008 9800480
18:57:33 118358 8192000000 10861167552 11326115840 1919909552 18.986 99 25 50 0 1937762848 11453056 6400240
18:59:37 40920 8192000000 10871552320 11342057472 1945775344 19.193 100 14 28 0 1961655568 12164672 3715552
19:00:37 9219 8192000000 10865635696 11339395072 1941710160 19.160 100 14 28 0 1959210912 13603280 3897472
19:00:57 74033 8192000000 10859931712 11341000704 1892134304 18.763 97 12 24 0 1905515824 10094544 3286976
19:02:18 43159 8192000000 10872172352 11345743872 1945645008 19.192 100 7 14 0 1959650704 12100000 1905696
19:03:07 39816 8192000000 10875878032 11356168192 1952100272 19.243 100 4 8 1 1963405600 10742176 563152
19:03:53 58091 8192000000 10906647744 11373711360 1970821424 19.392 100 22 44 1 1989157264 11852752 6483088
19:05:08 47913 8192000000 10871281856 11346280448 1907131296 18.884 97 20 39 2 1921223456 8461312 5630848
19:06:07 80497 8192000000 10896789216 11355844608 1921314144 18.997 98 19 38 0 1935669344 8660272 5694928
19:08:05 85187 8192000000 10915310656 11399647232 1977972384 19.449 100 24 48 1 1997475824 12975040 6528400
19:10:19 82367 8192000000 10892097472 11371511808 1917211984 18.964 97 10 20 0 1932528448 12653824 2662640
19:11:58 104365 8192000000 10912831968 11381690368 1955262624 19.268 99 20 40 1 1976541952 15745968 5533360
19:13:55 25605 8192000000 10927330576 11385507840 1961347456 19.317 99 40 78 1 1981331680 9501488 10482736
19:14:32 50611 8192000000 10914836544 11375116288 1901410512 18.838 96 42 84 2 1925047952 12069232 11568208
19:15:30 54763 8192000000 10892060816 11365969920 1908033440 18.891 97 23 46 1 1926521712 12248176 6240096
19:16:35 82509 8192000000 10885250096 11363586048 1907042736 18.883 97 10 20 0 1925673648 15709712 2921200
19:18:07 149464 8192000000 10868696480 11348111360 1882456720 18.685 96 22 42 2 1896745472 8609888 5678864
19:20:44 34435 8192000000 10870429024 11354734592 1949910592 19.226 100 5 10 0 1966010352 14704704 1395056
19:21:32 75062 8192000000 10869190608 11356766208 1941929280 19.162 99 11 22 0 1957027856 11918688 3179888
19:22:53 36119 8192000000 10878900400 11366330368 1942037104 19.163 99 11 22 0 1965182544 19703056 3442384
19:23:36 17437 8192000000 10884349168 11366764544 1957275344 19.284 100 10 20 0 1976595104 16400576 2919184
19:24:04 44129 8192000000 10868020048 11336073216 1868227152 18.570 95 13 27 2 1881266208 9254896 3784160
19:24:56 44410 8192000000 10861487408 11332653056 1926951488 19.042 99 16 32 2 1945252512 13464800 4836224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-02-2021 19:29:10 to 18-02-2021 19:29:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2021 19:29:43 to 18-02-2021 19:29:45.

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          230451
MON$OLDEST_ACTIVE               231609
MON$OLDEST_SNAPSHOT             231609
MON$NEXT_TRANSACTION            231609
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                       2010176
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.33418 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33418 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33418 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33418 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Thu Feb 18 19:27:25 2021
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
:15: 
:16: mscs-test-161.budzdorov.ru    Thu Feb 18 19:27:26 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Thu Feb 18 19:27:28 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Thu Feb 18 19:27:28 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

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