Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.02.2021 16:32
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 17307444 kB
MemAvailable 31201520 kB
Buffers 0 kB
Cached 14370224 kB
SwapCached 4876 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-05 16:32:08
DTS_END                         2021-02-05 16:32:08.7960
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49382
TRN_ID                          229868
ATT_ID                          649
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: 8993.70 19080 1079244
customer order: creation 170.67 356 20480
customer order: refuse 14.28 349 1714
order to supplier: creation 45.39 1336 5447
order to supplier: removal 3.25 107699 390
invoice (draft): creation 45.37 3676 5444
invoice (draft): removal 50.18 820 6022
invoice accept: apply 41.25 19890 4950
invoice accept: cancel 45.08 917 5409
customer reserve: creation 3869.72 193 464366
customer reserve: removal 4414.13 62 529696
realization accept: apply 82.98 183 9957
realization accept: cancel 84.11 118 10093
payment from customer: creation 57.56 120 6907
payment from customer: removal 5.39 81 647
payment to supplier: creation 49.03 123 5883
payment to supplier: removal 3.13 86 375
service: total inventory turnovers 4.64 1080 557
service: total monetary turnovers 6.76 26 811
service: aggregate perf. data 0.77 20085 92
service: refresh index statistics 0.03 224395 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-02-2021 16:32:58 to 05-02-2021 16:33:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3818
TEST_TIME 2 3416
TEST_TIME 3 3774
TEST_TIME 4 4402
TEST_TIME 5 4965
TEST_TIME 6 4818
TEST_TIME 7 4599
TEST_TIME 8 4656
TEST_TIME 9 4466
TEST_TIME 10 4398
TEST_TIME 11 4669
TEST_TIME 12 4935
TEST_TIME 13 5227
TEST_TIME 14 5456
TEST_TIME 15 5828
TEST_TIME 16 5992
TEST_TIME 17 6029
TEST_TIME 18 6541
TEST_TIME 19 6695
TEST_TIME 20 6861
TEST_TIME 21 7156
TEST_TIME 22 7595
TEST_TIME 23 7914
TEST_TIME 24 7949
TEST_TIME 25 8732
TEST_TIME 26 8568
TEST_TIME 27 8941
TEST_TIME 28 9162
TEST_TIME 29 9657
TEST_TIME 30 10175
TEST_TIME 31 10015
TEST_TIME 32 10214
TEST_TIME 33 10066
TEST_TIME 34 9839
TEST_TIME 35 9714
TEST_TIME 36 9510
TEST_TIME 37 9621
TEST_TIME 38 9440
TEST_TIME 39 9462
TEST_TIME 40 9323
TEST_TIME 41 9305
TEST_TIME 42 9253
TEST_TIME 43 9150
TEST_TIME 44 9161
TEST_TIME 45 9193
TEST_TIME 46 9063
TEST_TIME 47 9122
TEST_TIME 48 8979
TEST_TIME 49 8921
TEST_TIME 50 8983
TEST_TIME 51 8875
TEST_TIME 52 8863
TEST_TIME 53 8808
TEST_TIME 54 8752
TEST_TIME 55 8729
TEST_TIME 56 8674
TEST_TIME 57 8659
TEST_TIME 58 8662
TEST_TIME 59 8663
TEST_TIME 60 8626
TEST_TIME 61 8700
TEST_TIME 62 8760
TEST_TIME 63 8722
TEST_TIME 64 8829
TEST_TIME 65 8851
TEST_TIME 66 8888
TEST_TIME 67 8978
TEST_TIME 68 8950
TEST_TIME 69 9016
TEST_TIME 70 9091
TEST_TIME 71 9088
TEST_TIME 72 9162
TEST_TIME 73 9121
TEST_TIME 74 9071
TEST_TIME 75 9047
TEST_TIME 76 9003
TEST_TIME 77 8932
TEST_TIME 78 8978
TEST_TIME 79 8948
TEST_TIME 80 8918
TEST_TIME 81 8874
TEST_TIME 82 8880
TEST_TIME 83 8839
TEST_TIME 84 8789
TEST_TIME 85 8802
TEST_TIME 86 8841
TEST_TIME 87 8810
TEST_TIME 88 8838
TEST_TIME 89 8847
TEST_TIME 90 8866
TEST_TIME 91 8879
TEST_TIME 92 8898
TEST_TIME 93 8868
TEST_TIME 94 8992
TEST_TIME 95 8971
TEST_TIME 96 9034
TEST_TIME 97 9099
TEST_TIME 98 9063
TEST_TIME 99 9073
TEST_TIME 100 9079
TEST_TIME 101 9027
TEST_TIME 102 9033
TEST_TIME 103 8998
TEST_TIME 104 8974
TEST_TIME 105 8954
TEST_TIME 106 8928
TEST_TIME 107 8885
TEST_TIME 108 8836
TEST_TIME 109 8905
TEST_TIME 110 8904
TEST_TIME 111 8908
TEST_TIME 112 8946
TEST_TIME 113 8962
TEST_TIME 114 8983
TEST_TIME 115 8974
TEST_TIME 116 9034
TEST_TIME 117 9015
TEST_TIME 118 9023
TEST_TIME 119 9062
TEST_TIME 120 8996

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-02-2021 16:33:01 to 05-02-2021 16:33:05.

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 1507532 1507532 0 0.00 0 15719 7 0 0
doc_list_biud 1507532 1507532 0 0.00 0 25630 28 0 0
sp_add_invoice_to_stock 5050 4950 100 1.98 31 163537 19891 0 100
sp_cancel_adding_invoice 5409 5409 0 0.00 5 74029 918 0 0
sp_cancel_client_order 1714 1714 0 0.00 4 16843 349 0 0
sp_cancel_customer_reserve 529696 529696 0 0.00 1 27314 63 0 0
sp_cancel_pay_from_customer 647 647 0 0.00 3 3144 82 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 3 8989 86 0 0
sp_cancel_supplier_invoice 6030 6022 8 0.13 2 24961 821 0 8
sp_cancel_supplier_order 390 390 0 0.00 6 1382590 107699 0 0
sp_cancel_write_off 10093 10093 0 0.00 1 15296 119 0 0
sp_client_order 20480 20480 0 0.00 3 18003 357 0 0
sp_customer_reserve 464366 464366 0 0.00 0 121125 193 0 0
sp_fill_shopping_cart 31362 31362 0 0.00 1 25832 44 0 0
sp_fill_shopping_cart_clo_res 464363 464363 0 0.00 0 17549 14 0 0
sp_get_clo_for_invoice 4947 4947 0 0.00 0 32710 335 0 0
sp_kill_cost_storno 16524 16524 0 0.00 0 10296 63 0 0
sp_kill_qstorno_ret_qs2qd 1075897 1075897 0 0.00 0 25626 34 0 0
sp_kill_qty_storno 568228 568228 0 0.00 0 25630 74 0 0
sp_lock_selected_doc 20508 20508 0 0.00 0 9400 8 0 0
sp_make_cost_storno 27694 27694 0 0.00 0 9343 48 0 0
sp_multiply_rows_for_pdistr 27694 27694 0 0.00 0 15705 30 0 0
sp_multiply_rows_for_qdistr 20480 20480 0 0.00 0 15879 158 0 0
sp_pay_from_customer 6907 6907 0 0.00 4 18654 121 0 0
sp_pay_to_supplier 5883 5883 0 0.00 5 13146 123 0 0
sp_payment_common 12790 12790 0 0.00 1 18482 24 0 0
sp_qd_handle_on_cancel_clo 1714 1714 0 0.00 0 16829 323 0 0
sp_qd_handle_on_invoice_upd_sts 10356 10356 0 0.00 0 25535 381 0 0
sp_qd_handle_on_reserve_upd_sts 9957 9957 0 0.00 0 12521 63 0 0
sp_reserve_write_off 9957 9957 0 0.00 7 12535 183 0 0
sp_supplier_invoice 5444 5444 0 0.00 8 92029 3676 0 0
sp_supplier_order 5447 5447 0 0.00 5 29454 1337 0 0
srv_aggregate_perf_data 92 92 0 0.00 2383 178366 20085 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1441 156498 31304 0 0
srv_find_qd_qs_mism 1030978 1030978 0 0.00 0 12438 6 0 0
srv_make_invnt_saldo 557 557 0 0.00 58 48217 1081 0 0
srv_make_money_saldo 811 811 0 0.00 0 1481 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 191503 255777 224396 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4950 4950 0 0.00 0 9856 199 0 0
t$perf-norm:sp_cancel_adding_invoice 377 377 0 0.00 1 4812 154 0 0
t$perf-norm:sp_cancel_client_order 1714 1714 0 0.00 0 2041 15 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 4268 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 647 647 0 0.00 0 10101 28 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 1521 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 2561 29 0 0
t$perf-norm:sp_cancel_supplier_order 390 390 0 0.00 0 25209 1854 0 0
t$perf-norm:sp_cancel_write_off 1028 1028 0 0.00 0 1121 6 0 0
t$perf-norm:sp_client_order 20480 20480 0 0.00 0 11159 22 0 0
t$perf-norm:sp_customer_reserve 1000 1000 0 0.00 0 2584 12 0 0
t$perf-norm:sp_pay_from_customer 6907 6907 0 0.00 0 8373 14 0 0
t$perf-norm:sp_pay_to_supplier 5883 5883 0 0.00 0 7150 12 0 0
t$perf-norm:sp_reserve_write_off 9957 9957 0 0.00 0 15435 14 0 0
t$perf-norm:sp_supplier_invoice 5444 5444 0 0.00 0 11231 21 0 0
t$perf-norm:sp_supplier_order 5447 5447 0 0.00 0 11528 29 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 442 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 962 10 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 1330 37 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 629 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 10092 9892 200 1.98 0 6415 23 0 200
v_all_customers 37118 37118 0 0.00 0 118 1 0 0
v_all_suppliers 30386 30386 0 0.00 0 128 1 0 0
v_all_wares 40960 40960 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 754 754 0 0.00 0 3697 13 0 0
v_cancel_client_order 3428 3428 0 0.00 0 2945 5 0 0
v_cancel_customer_prepayment 1294 1294 0 0.00 0 1840 8 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 1884 7 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 8977 15 0 0
v_cancel_supplier_invoice 754 738 16 2.12 0 1092 15 0 16
v_cancel_supplier_order 780 780 0 0.00 0 5779 12 0 0
v_cancel_write_off 2056 2056 0 0.00 0 10839 20 0 0
v_max_id_clo_ord 5447 5447 0 0.00 0 458 1 0 0
v_max_id_clo_res 1000 1000 0 0.00 0 4546 15 0 0
v_max_id_ord_sup 5434 5434 0 0.00 0 5629 7 0 0
v_max_non_paid_invoice 1571 1571 0 0.00 0 409 2 0 0
v_max_non_paid_realizn 3658 3658 0 0.00 0 4426 4 0 0
v_min_id_clo_ord 5447 5447 0 0.00 0 3712 7 0 0
v_min_id_clo_res 1000 1000 0 0.00 0 7771 12 0 0
v_min_id_ord_sup 5434 5434 0 0.00 0 3839 7 0 0
v_min_non_paid_invoice 5883 5883 0 0.00 0 8661 13 0 0
v_min_non_paid_realizn 6907 6907 0 0.00 0 18476 15 0 0
v_our_firm 10340 10340 0 0.00 0 25 1 0 0
v_reserve_write_off 19914 19914 0 0.00 0 9167 8 0 0
x_lock_depdocs_on_canc_invoice 11062 11062 0 0.00 0 16297 131 0 0
x_lock_depdocs_on_canc_sup_ord 390 390 0 0.00 0 11442 418 0 0
x_make_qstorno_1000_1200 5447 5447 0 0.00 2 29444 1241 0 0
x_make_qstorno_1200_2000 5444 5444 0 0.00 4 77460 3515 0 0
x_make_qstorno_2100_3300 464366 464366 0 0.00 0 121055 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-02-2021 16:33:06 to 05-02-2021 16:33:10.

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:02:12 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:18 22739 8192000000 10274087744 10585665536 1145514352 12.267 88 72 144 0 1172157280 3469088 23173840
14:02:51 29070 8192000000 10353250688 10673692672 1397124752 14.569 100 84 168 1 1430184928 5603728 27456448
14:03:32 22396 8192000000 10392498976 10718711808 1444206624 14.987 100 90 180 1 1480377616 6807424 29363568
14:04:02 18692 8192000000 10417645680 10745466880 1473052368 15.241 100 90 180 1 1509514800 7658224 28804208
14:04:30 37415 8192000000 10443042608 10776477696 1494975680 15.432 100 90 180 0 1532595936 8670064 28950192
14:05:14 20372 8192000000 10457755136 10794303488 1514653600 15.604 100 92 184 0 1553181312 9399360 29128352
14:05:42 25616 8192000000 10475329712 10811645952 1522362128 15.671 100 85 170 0 1559170992 10037120 26771744
14:06:16 21379 8192000000 10480689792 10821562368 1538538096 15.811 100 90 178 1 1577354160 10719520 28096544
14:07:03 22346 8192000000 10511461888 10863747072 1574734352 16.123 100 77 154 0 1609182464 11389728 23058384
14:07:36 16646 8192000000 10534289552 10892001280 1598166752 16.324 100 80 158 1 1633108112 11484560 23456800
14:08:02 18753 8192000000 10565229920 10920611840 1619483952 16.506 100 87 174 0 1657819344 12170160 26165232
14:08:29 13862 8192000000 10578013616 10936856576 1627237232 16.571 100 78 154 0 1662632976 12674640 22721104
14:08:50 12079 8192000000 10589733728 10951835648 1649125488 16.757 100 81 162 1 1686051392 12702768 24223136
14:09:23 8383 8192000000 10615402464 10978041856 1669318848 16.927 100 82 162 0 1706126352 13356512 23450992
14:09:40 10582 8192000000 10625514688 10994831360 1685065984 17.060 100 89 177 2 1725002336 14283680 25652672
14:10:00 8955 8192000000 10636054144 11007991808 1697509072 17.164 100 79 157 0 1734306576 13928320 22869184
14:10:17 8988 8192000000 10662072320 11029434368 1711506192 17.281 100 77 149 2 1746177200 13412112 21258896
14:10:33 5204 8192000000 10664533792 11039809536 1731443968 17.448 100 83 166 0 1768759728 13793664 23522096
14:10:48 7446 8192000000 10674311968 11052179456 1742259216 17.537 100 82 164 0 1778508448 13512416 22736816
14:11:03 5006 8192000000 10689258336 11065724928 1747433872 17.580 100 78 155 1 1781129728 12696032 20999824
14:11:16 5095 8192000000 10695826048 11077926912 1758660944 17.673 100 74 146 1 1792065168 13099904 20304320
14:11:29 3515 8192000000 10714365568 11090092032 1767713024 17.748 100 88 172 3 1805051680 13087376 24251280
14:11:39 3483 8192000000 10712932544 11094171648 1777393536 17.828 100 83 164 4 1813711136 12450288 23867312
14:11:49 10477 8192000000 10717498464 11105148928 1786308144 17.901 100 73 144 2 1817966544 11562336 20096064
14:12:07 6081 8192000000 10733882336 11122200576 1788582864 17.920 100 76 153 1 1822064304 11944848 21536592
14:12:20 2141 8192000000 10746549472 11128987648 1809298320 18.090 100 89 178 2 1847497296 12877936 25321040
14:12:30 3829 8192000000 10751857520 11141025792 1812426544 18.116 100 81 162 2 1848118704 13072432 22619728
14:12:41 3106 8192000000 10762004656 11145818112 1821199616 18.187 100 82 162 1 1857378448 13108640 23070192
14:12:51 2326 8192000000 10766151024 11153231872 1825883392 18.226 100 91 181 3 1865843808 13571136 26389280
14:13:00 2300 8192000000 10770355024 11158695936 1832565136 18.280 100 89 178 0 1871954480 14148336 25241008
14:13:09 1493 8192000000 10780751088 11166838784 1837322560 18.319 100 90 180 0 1876560496 13801616 25436320
14:13:17 3275 8192000000 10789434288 11175735296 1845545280 18.386 100 94 188 1 1885599360 13543440 26510640
14:13:27 2250 8192000000 10786869248 11176280064 1848258736 18.408 100 88 174 2 1884570800 11923808 24388256
14:13:35 2648 8192000000 10798533888 11182006272 1850721520 18.428 100 93 183 1 1889088400 11980704 26386176
14:13:44 2189 8192000000 10800425216 11187290112 1854410192 18.458 100 87 175 1 1892970672 13301216 25259264
14:13:53 2229 8192000000 10798540352 11183280128 1854009168 18.455 100 92 184 0 1894138176 13473920 26655088
14:14:02 1794 8192000000 10802572624 11188588544 1854176832 18.456 100 92 185 1 1894553792 13035712 27341248
14:14:10 2247 8192000000 10803559120 11188101120 1855744960 18.469 100 89 176 1 1892904496 11702480 25457056
14:14:19 2020 8192000000 10795334864 11183185920 1858769552 18.493 100 95 192 1 1898621216 12115728 27735936
14:14:27 1799 8192000000 10799024944 11190321152 1859481584 18.499 100 88 176 2 1898147648 12764800 25901264
14:14:36 25905 8192000000 10786766784 11189895168 1859655488 18.500 100 63 126 2 1887713632 10393872 17664272
14:15:09 2095 8192000000 10801977440 11202580480 1864854464 18.543 100 69 138 0 1894837744 10293008 19690272
14:15:19 4140 8192000000 10785467120 11194662912 1860453024 18.507 100 46 94 0 1882164800 9191856 12519920
14:15:35 6506 8192000000 10794977104 11202596864 1867828912 18.567 100 45 92 1 1888335088 8225088 12281088
14:15:48 6909 8192000000 10793163600 11203497984 1868165680 18.569 100 45 91 1 1889319216 8311488 12842048
14:16:02 4676 8192000000 10780087328 11201073152 1867315792 18.563 100 35 70 2 1889619568 13205776 9098000
14:16:14 7067 8192000000 10780915952 11200860160 1866080016 18.553 100 27 54 2 1879730464 6676448 6974000
14:16:27 5662 8192000000 10779445648 11201179648 1867655424 18.565 100 31 63 0 1883538288 6937360 8945504
14:16:39 7452 8192000000 10767269872 11201613824 1869775712 18.582 100 28 57 1 1883873024 6413072 7684240
14:16:53 9444 8192000000 10781455840 11208765440 1874762656 18.623 100 20 41 3 1886023776 5818416 5442704
14:17:09 13116 8192000000 10797639008 11218558976 1879917392 18.664 100 27 53 1 1893702640 6782656 7002592
14:17:32 5021 8192000000 10795742400 11219173376 1882753440 18.687 100 25 50 1 1896674160 6189360 7731360
14:17:46 71920 8192000000 10802767648 11232858112 1890436016 18.749 100 29 58 0 1904204080 5923808 7844256
14:19:04 15013 8192000000 10802480992 11234492416 1892230848 18.764 100 19 38 0 1902912304 5601184 5080272
14:19:25 6399 8192000000 10809431744 11238039552 1896287872 18.796 100 31 62 2 1911341984 6213504 8840608
14:19:41 3450 8192000000 10827648192 11246063616 1896997312 18.802 100 44 86 1 1916014320 7429216 11587792
14:19:51 4230 8192000000 10811618192 11244683264 1899152688 18.819 100 40 80 1 1918326880 7889568 11284624
14:20:03 4617 8192000000 10816510896 11247394816 1900599984 18.831 100 34 68 0 1917391008 6204528 10586496
14:20:14 7892 8192000000 10816570128 11249790976 1901757984 18.840 100 30 61 0 1917794224 6751120 9285120
14:20:29 7212 8192000000 10812217616 11249819648 1903945344 18.858 100 22 44 1 1916624288 6899264 5779680
14:20:43 7384 8192000000 10813440416 11251462144 1900357648 18.829 100 12 24 1 1910067360 5515712 4194000
14:20:56 9576 8192000000 10811882336 11250638848 1901780304 18.841 100 13 26 0 1911996272 5547808 4668160
14:21:12 4135 8192000000 10823468400 11259166720 1903440288 18.854 100 23 46 2 1920180464 10312752 6427424
14:21:22 10459 8192000000 10806549312 11246026752 1899124736 18.819 100 22 43 2 1911622592 6426848 6071008
14:21:39 14173 8192000000 10809826240 11243331584 1883183216 18.691 99 18 35 2 1895457568 5700736 6573616
14:21:59 11699 8192000000 10822064544 11256164352 1901107760 18.835 100 17 34 1 1916141088 10328624 4704704
14:22:18 10262 8192000000 10784795568 11218595840 1835133696 18.301 97 15 30 0 1845295696 6036576 4125424
14:22:34 65995 8192000000 10795959072 11210596352 1855137056 18.464 98 42 81 2 1873740032 5648240 12954736
14:23:46 6671 8192000000 10794353040 11218673664 1863279328 18.530 99 42 84 1 1884751696 9401536 12070832
14:23:59 6064 8192000000 10794474608 11228602368 1882964768 18.689 100 27 55 0 1898352832 6711440 8676624
14:24:12 7630 8192000000 10783725696 11214155776 1845645392 18.387 98 21 42 0 1857260592 5461904 6153296
14:24:27 5807 8192000000 10759341504 11179884544 1788875312 17.923 96 36 71 1 1805964480 6677168 10412000
14:24:39 6061 8192000000 10773260832 11193348096 1851072784 18.431 100 43 85 1 1869829536 7203296 11553456
14:24:51 6424 8192000000 10749425088 11181555712 1820902688 18.185 98 33 66 1 1837310688 6500368 9907632
14:25:04 9420 8192000000 10769340128 11179147264 1807840544 18.078 98 25 50 0 1820706352 5528464 7337344
14:25:20 7209 8192000000 10749463840 11162439680 1787039696 17.907 97 35 70 1 1803227792 5992304 10195792
14:25:35 5703 8192000000 10718315040 11142356992 1783873392 17.881 98 20 40 0 1796435696 6865920 5696384
14:25:48 11281 8192000000 10690165328 11110625280 1717943264 17.335 95 18 36 2 1728319392 4710944 5665184
14:26:08 7974 8192000000 10680401248 11091435520 1761347840 17.696 99 28 56 2 1776231584 6710176 8173568
14:26:26 6974 8192000000 10649178128 11058028544 1698817712 17.175 96 21 38 1 1709555584 4881776 5856096
14:26:41 66464 8192000000 10705605888 11127963648 1730542256 17.440 96 32 64 1 1745157968 4798720 9816992
14:27:55 12991 8192000000 10695852720 11115876352 1729124032 17.428 96 15 30 0 1738825328 4999632 4701664
14:28:17 6811 8192000000 10705871216 11130257408 1782056320 17.866 99 19 38 1 1793338608 5736816 5545472
14:28:30 8159 8192000000 10704336352 11118809088 1778813248 17.840 98 28 56 1 1792600496 5892032 7895216
14:28:45 10310 8192000000 10712116576 11133755392 1792469008 17.952 99 25 50 0 1806133680 6543776 7120896
14:29:04 10914 8192000000 10720026864 11145252864 1796157712 17.982 99 19 38 3 1807058944 5696624 5204608
14:29:23 5693 8192000000 10725381344 11151233024 1798668608 18.003 99 24 48 3 1810976736 5695168 6612960
14:29:36 9341 8192000000 10749545744 11168268288 1834379328 18.295 100 21 42 0 1845902000 5350608 6172064
14:29:54 7816 8192000000 10753808464 11173257216 1831466816 18.271 100 21 43 0 1843913216 5435344 7011056
14:30:09 9490 8192000000 10754131488 11175575552 1833038480 18.284 100 12 24 1 1841348944 5142992 3167472
14:30:31 9517 8192000000 10754004944 11181551616 1846473824 18.393 100 33 66 0 1864164112 5937024 11753264
14:30:47 11581 8192000000 10758318592 11183509504 1842714464 18.363 100 20 40 2 1853813776 5643184 5456128
14:31:08 12530 8192000000 10775169776 11194679296 1852159120 18.440 100 24 47 1 1863576080 5188944 6228016
14:31:27 18093 8192000000 10769468736 11198205952 1856501504 18.475 100 18 37 0 1866911616 4942432 5467680
14:31:52 75519 8192000000 10825567424 11231031296 1868141904 18.569 100 29 58 0 1881213648 5028432 8043312
14:33:21 1985 8192000000 10830138320 11238187008 1894645984 18.783 100 55 108 2 1917519488 7728544 15144960
14:33:31 44358 8192000000 10826698368 11247722496 1899886048 18.825 100 49 98 2 1923177216 9703296 13587872
14:34:24 13797 8192000000 10838037536 11256877056 1905470464 18.870 100 54 106 2 1932775152 12207136 15097552
14:34:45 5774 8192000000 10846910432 11259940864 1910440080 18.910 100 61 123 1 1939710192 12277296 16992816
14:35:02 54162 8192000000 10847673840 11275026432 1913741984 18.937 100 42 82 1 1938126112 12687056 11697072
14:36:05 25140 8192000000 10856142432 11288772608 1922723136 19.009 100 33 66 0 1946073360 14063104 9287120
14:36:37 30396 8192000000 10869442864 11300311040 1935109824 19.108 100 47 94 0 1963471552 14972864 13388864
14:37:19 22859 8192000000 10872675616 11307098112 1941231664 19.157 100 52 104 3 1974725760 17747056 15747040
14:37:49 9397 8192000000 10877789200 11311218688 1945621072 19.192 100 39 78 1 1972241840 15516304 11104464
14:38:06 20477 8192000000 10893554144 11316600832 1949345472 19.221 100 43 86 1 1976344768 14263824 12735472
14:38:40 25327 8192000000 10908876576 11334488064 1956249952 19.276 100 47 94 0 1994180768 23993088 13937728
14:39:22 5248 8192000000 10911269488 11337080832 1967065680 19.362 100 59 115 0 2001549296 16961248 17522368
14:39:45 18241 8192000000 10908269360 11340607488 1969419792 19.381 100 46 92 0 2002162432 18926016 13816624
14:40:11 10966 8192000000 10912938992 11341606912 1972892128 19.408 100 40 76 1 2001093376 16881584 11319664
14:40:36 8204 8192000000 10924483088 11353763840 1981990352 19.480 100 56 112 2 2016530992 17355648 17184992
14:40:57 14835 8192000000 10922157456 11358388224 1985246768 19.506 100 51 102 0 2018837056 17748912 15841376
14:41:21 38569 8192000000 10935165984 11366150144 1974111504 19.418 99 41 80 3 2008566928 21298192 13157232
14:42:09 4274 8192000000 10962863584 11378913280 1997730320 19.605 100 70 139 1 2039670720 21531984 20408416
14:42:21 14367 8192000000 10952618208 11382202368 2000624416 19.628 100 60 120 0 2043144880 24384640 18135824
14:42:45 11277 8192000000 10948044496 11379277824 1994758960 19.581 100 57 114 1 2038576816 25795152 18022704
14:43:05 4588 8192000000 10960544416 11383795712 1997733760 19.605 100 58 116 0 2042309728 27306672 17269296
14:43:21 7562 8192000000 10951325296 11379408896 1999321424 19.617 100 62 123 1 2043996640 26252080 18423136
14:43:41 7111 8192000000 10966696752 11392462848 2008071360 19.686 100 64 128 0 2054202944 27289264 18842320
14:43:55 5417 8192000000 10971473616 11396943872 2009887792 19.701 100 70 140 3 2059350000 28256704 21205504
14:44:10 7814 8192000000 10976262768 11399024640 2012224576 19.719 100 71 142 2 2062984208 28855056 21904576
14:44:25 8888 8192000000 10969162672 11397787648 2010377072 19.704 100 71 142 2 2062858720 30520416 21961232
14:44:42 3226 8192000000 10982087280 11403141120 2011655520 19.715 100 68 135 1 2061849280 29740496 20453264
14:44:55 6060 8192000000 10972108208 11402735616 2012164368 19.719 100 63 126 2 2061993600 30343872 19485360
14:45:09 8278 8192000000 10982438128 11405828096 2014379264 19.736 100 69 137 1 2062138336 27501392 20257680
14:45:24 5394 8192000000 10983176256 11403026432 2014349216 19.736 100 83 164 2 2067736336 28800608 24586512
14:45:37 9801 8192000000 10971442672 11398692864 2004621696 19.659 100 67 133 0 2053776800 29856416 19298688
14:45:57 3811 8192000000 10962627584 11390898176 1988194160 19.530 99 70 140 2 2041086928 32461792 20430976
14:46:08 1885 8192000000 10986596400 11400134656 2002606496 19.643 100 89 175 0 2061771312 32961568 26203248
14:46:17 7522 8192000000 10979340560 11400544256 2006217104 19.672 100 77 154 1 2061905200 32772800 22915296
14:46:34 13002 8192000000 10970358336 11393507328 1987282976 19.522 99 73 146 0 2043838016 34595520 21959520
14:46:56 3534 8192000000 10977924528 11403018240 2007840352 19.685 100 84 165 2 2068887472 35519424 25527696
14:47:11 2808 8192000000 10982539440 11405803520 2011828544 19.716 100 84 168 1 2069425440 32660016 24936880
14:47:22 2670 8192000000 10980102480 11401056256 1989528384 19.540 99 79 158 1 2047797968 33822416 24447168
14:47:31 8618 8192000000 10977925584 11401289728 2005201056 19.664 100 78 156 1 2064076896 35022112 23853728
14:47:53 4890 8192000000 10978085744 11411136512 2008040576 19.686 100 71 141 2 2069537360 39277696 22219088
14:48:07 7585 8192000000 10989722864 11423731712 2018175152 19.766 100 61 121 2 2075231600 38152608 18903840
14:48:24 2742 8192000000 11010972368 11430957056 2027974512 19.843 100 80 156 1 2087796272 36391360 23430400
14:48:35 4547 8192000000 11003568592 11428745216 2026550944 19.832 100 71 141 0 2086409520 38283168 21575408
14:48:50 4940 8192000000 10991802736 11414048768 2004702880 19.660 99 76 148 2 2066076176 38762528 22610768
14:49:03 5266 8192000000 11006162176 11428560896 2025620384 19.824 100 85 170 1 2092797120 41122880 26053856
14:49:16 3118 8192000000 11010719248 11433611264 2028274000 19.845 100 82 164 1 2095300896 42403280 24623616
14:49:26 3418 8192000000 11022613504 11438333952 2027843552 19.842 100 83 166 1 2097273776 43720960 25709264
14:49:36 1627 8192000000 11027934528 11443343360 2031703568 19.872 100 82 164 2 2101974672 44592256 25678848
14:49:45 2372 8192000000 11030415088 11446288384 2032240944 19.876 100 89 176 1 2105466416 45153536 28071936
14:49:55 3170 8192000000 11030114176 11448696832 2033698784 19.888 100 85 170 0 2108097952 47215920 27183248
14:50:04 3848 8192000000 11022564000 11441696768 2005491360 19.666 99 90 180 1 2081655920 48488224 27676336
14:50:16 4975 8192000000 11003376640 11424641024 2009304912 19.696 100 80 159 0 2083842288 49567136 24970240
14:50:29 2060 8192000000 10990375696 11416907776 1997199328 19.601 99 74 147 1 2065554480 45022944 23332208
14:50:40 1688 8192000000 10990655840 11411070976 1997954208 19.607 99 82 164 1 2070028576 47041840 25032528
14:50:50 2762 8192000000 11003322320 11418320896 2009364288 19.697 100 87 173 4 2078203248 43057008 25781952
14:50:59 2513 8192000000 10998846784 11417493504 1996363360 19.594 99 88 178 1 2068239136 44540992 27334784
14:51:08 5853 8192000000 10993906336 11414605824 2006569456 19.675 100 84 168 2 2075816064 43679648 25566960
14:51:21 4635 8192000000 11002787616 11422728192 2016332592 19.751 100 81 158 0 2084309552 43308496 24668464
14:51:32 4516 8192000000 11011109728 11432845312 2020531008 19.784 100 87 174 0 2092425536 44986848 26907680
14:51:45 1763 8192000000 10981896320 11400978432 1990036416 19.544 99 84 167 2 2058048400 42696768 25315216
14:51:53 3212 8192000000 11000268944 11419693056 2006870480 19.677 100 89 179 1 2079198672 44499120 27829072
14:52:05 2287 8192000000 11001289616 11420999680 2011125520 19.710 100 88 176 2 2083153952 45039456 26988976
14:52:15 2132 8192000000 10995074208 11412353024 1999709152 19.620 100 90 180 0 2075799504 47544208 28546144
14:52:24 2147 8192000000 10986278144 11397496832 1988007408 19.528 100 87 173 1 2060224752 45579920 26637424
14:52:34 2936 8192000000 10982776016 11400228864 1989379264 19.539 100 79 155 0 2060546688 46749680 24417744
14:52:45 2008 8192000000 11000508624 11416633344 2005814608 19.669 100 92 184 2 2083112304 49049712 28247984
14:52:54 3921 8192000000 10988088864 11401039872 1976891008 19.440 99 86 172 3 2053162064 49331344 26939712
14:53:06 3994 8192000000 10980911888 11400175616 1987769280 19.526 100 84 164 1 2062388640 49254432 25364928
14:53:17 3593 8192000000 10994885760 11409907712 1993958288 19.575 100 79 159 3 2066981936 48141616 24882032
14:53:30 2540 8192000000 10976879008 11398209536 1973945968 19.417 99 88 176 2 2048777776 47321856 27509952
14:53:40 5773 8192000000 10970708576 11393511424 1979323648 19.459 100 72 144 1 2050000288 48184528 22492112
14:53:54 3670 8192000000 10986333504 11406045184 1988159248 19.529 100 77 153 1 2062938592 50497440 24281904
14:54:05 1441 8192000000 11001756624 11421392896 2001303952 19.633 100 84 168 1 2079073616 51965968 25803696
14:54:13 4109 8192000000 10975622240 11398672384 1978711936 19.454 99 75 147 0 2054230688 52142448 23376304
14:54:24 2430 8192000000 10976629760 11388526592 1970781168 19.392 100 95 186 2 2052979424 53238960 28959296
14:54:34 1702 8192000000 10938201456 11355332608 1921638512 19.000 98 73 147 0 1991962768 47635504 22688752
14:54:47 2771 8192000000 10946329808 11361951744 1948129840 19.212 100 85 171 4 2024468400 49803904 26534656
14:54:56 4386 8192000000 10919244672 11345588224 1931693392 19.080 100 59 118 2 2000858464 49987840 19177232
14:55:08 6483 8192000000 10892090144 11323031552 1878468096 18.653 97 49 97 0 1943555888 49379184 15708608
14:55:22 7528 8192000000 10893372144 11323416576 1899820864 18.825 99 42 84 2 1961828784 47191840 14816080
14:55:44 6897 8192000000 10912293472 11343589376 1909516192 18.903 99 40 80 2 1972949264 49714368 13718704
14:56:31 4562 8192000000 10884593856 11311869952 1892416464 18.765 99 52 102 1 1964522608 55012032 17094112
14:56:45 2920 8192000000 10930181392 11344297984 1908789056 18.897 99 79 152 1 1993492544 59582352 25121136
14:56:54 2973 8192000000 10938794128 11359600640 1937799280 19.129 100 81 159 1 2025549184 61801568 25948336
14:57:04 3892 8192000000 10952346320 11366486016 1943971616 19.178 100 83 165 5 2026506736 56867264 25667856
14:57:16 6327 8192000000 10918357376 11351879680 1932511824 19.087 100 57 114 2 2005137536 54460736 18164976
14:57:37 28177 8192000000 10883998448 11328135168 1897691968 18.808 98 24 48 0 1945254160 39639856 7922336
14:58:14 14315 8192000000 10875832688 11314290688 1896766976 18.800 98 40 79 3 1948757728 38416720 13574032
14:58:39 16167 8192000000 10889883920 11328290816 1900600096 18.831 99 28 56 1 1954951104 44019392 10331616
14:59:05 20822 8192000000 10887922832 11339755520 1920986384 18.995 100 29 58 0 1973566448 42530400 10049664
14:59:49 30234 8192000000 10880806320 11334746112 1924733536 19.025 100 19 38 1 1970975856 39336288 6906032
15:00:49 19849 8192000000 10880187632 11331166208 1916734224 18.961 100 14 28 1 1958740224 36713696 5292304
15:01:19 8914 8192000000 10889657264 11341402112 1924302336 19.021 100 15 30 0 1971997008 41900656 5794016
15:01:35 25933 8192000000 10852648144 11321307136 1898039472 18.811 99 15 30 0 1942693280 39621408 5032400
15:02:10 81662 8192000000 10837178352 11286892544 1828615136 18.248 95 14 25 1 1842184272 10462096 3107040
15:03:43 28275 8192000000 10861848192 11311464448 1930873632 19.074 100 32 64 2 1947498832 8113104 8512096
15:04:21 69433 8192000000 10865072976 11331624960 1867830368 18.567 97 14 29 2 1884298272 12984080 3483824
15:05:39 87035 8192000000 10859203008 11332988928 1917827648 18.969 99 17 34 0 1943944784 21543184 4573952
15:07:12 21891 8192000000 10865571920 11322605568 1935327936 19.109 100 15 30 0 1959814816 20268608 4218272
15:07:41 41511 8192000000 10889120736 11330564096 1930483680 19.071 99 35 70 3 1956444000 15327392 10632928
15:08:39 57067 8192000000 10876546976 11346976768 1948068992 19.211 100 30 60 2 1974473008 18193120 8210896
15:10:06 40183 8192000000 10882344816 11345711104 1954140592 19.259 100 26 54 0 1974877664 13057504 7679568
15:10:54 117710 8192000000 10879615648 11348320256 1932813456 19.089 99 12 24 0 1948482992 12339728 3329808
15:12:58 28555 8192000000 10887553296 11356016640 1957715248 19.288 100 11 23 1 1975940912 14932672 3292992
15:13:32 75800 8192000000 10905867216 11369422848 1947512752 19.207 99 12 24 4 1962429024 11226576 3689696
15:15:19 51040 8192000000 10893583936 11366039552 1939931056 19.146 98 24 48 2 1963253536 16508144 6814336
15:16:27 102382 8192000000 10875611632 11352547328 1949827968 19.225 99 18 36 2 1974095968 19210096 5057904
15:18:28 148016 8192000000 10889520096 11346657280 1921790416 19.001 98 22 44 0 1943340000 14731248 6818336
15:21:03 51243 8192000000 10877563040 11348725760 1942378624 19.166 99 19 38 0 1960478128 12861472 5238032
15:22:10 100534 8192000000 10878470672 11359940608 1960666256 19.311 100 9 18 0 1979834800 16506528 2662016
15:23:57 73431 8192000000 10904783584 11366866944 1967079232 19.362 100 20 40 2 1983999616 9447280 7473104
15:25:23 57528 8192000000 10891741904 11366891520 1951983968 19.242 99 32 65 2 1972576768 11439296 9153504
15:28:11 68530 8192000000 10878263168 11358793728 1958022736 19.290 99 11 22 1 1973925728 12757024 3145968
15:29:26 38629 8192000000 10896114176 11384823808 1972890240 19.408 100 8 16 0 1988193616 12509168 2794208
15:30:18 96656 8192000000 10903541968 11379482624 1965544704 19.350 99 15 30 0 1982204928 12655568 4004656
15:32:01 28230 8192000000 10911012640 11381587968 1962620208 19.327 99 22 44 0 1974874784 6225648 6028928
15:32:41 41526 8192000000 10923803504 11390726144 1982366544 19.483 100 30 60 0 2001256352 10762592 8127216
15:34:04 56296 8192000000 10885598128 11351941120 1941136448 19.156 99 17 34 0 1961942480 16379920 4426112
15:35:07 64934 8192000000 10907705264 11382226944 1963280976 19.332 99 20 40 2 1982445104 13207584 5956544
15:36:28 48656 8192000000 10919555184 11383267328 1963018944 19.330 99 12 24 0 1976954704 9508992 4426768
15:37:34 93095 8192000000 10930842112 11407740928 1968398848 19.373 99 23 45 1 1988721888 13688928 6634112
15:39:20 111922 8192000000 10859975008 11317096448 1768464368 17.754 89 13 26 1 1791294496 19083776 3746352
15:41:19 109047 8192000000 10874810048 11342655488 1853280208 18.449 95 8 16 0 1872048688 16681040 2087440
15:43:19 138718 8192000000 10853955136 11326361600 1804044000 18.047 93 7 14 1 1825701344 19619152 2038192
15:45:53 127196 8192000000 10821815408 11295563776 1858222144 18.489 97 20 40 1 1872672224 8750592 5699488
15:48:15 77763 8192000000 10847503664 11304632320 1899925392 18.826 99 24 48 0 1916174336 9710080 6538864
15:49:39 20325 8192000000 10850644464 11296477184 1844433344 18.377 96 49 97 3 1871051440 12894864 13723232
15:50:07 34283 8192000000 10848038176 11309060096 1913975792 18.939 100 36 72 0 1938543648 14391152 10176704
15:51:49 22100 8192000000 10825912704 11294162944 1893148848 18.771 99 12 24 0 1907976864 11706560 3121456
15:52:17 57377 8192000000 10824620688 11293937664 1864174944 18.537 97 10 20 0 1874284080 7345232 2763904
15:54:03 92391 8192000000 10821074128 11297710080 1875997920 18.633 98 15 30 0 1895223984 14434944 4791120
15:56:24 41739 8192000000 10838187648 11293736960 1894489024 18.782 99 24 48 2 1916416208 14483952 7443232
15:57:27 61130 8192000000 10848803696 11316359168 1904449184 18.862 99 16 32 1 1921640224 12803856 4387184
15:58:49 88476 8192000000 10830881568 11302436864 1806299232 18.066 94 17 34 2 1829222752 17622144 5301376
16:00:30 49838 8192000000 10821080832 11277078528 1830844832 18.266 96 35 68 3 1849096848 8741920 9510096
16:01:27 33582 8192000000 10851568720 11304816640 1914878528 18.946 100 31 61 1 1931424544 7769232 8776784
16:02:25 34366 8192000000 10851759200 11308445696 1917017488 18.963 99 39 78 1 1938959376 11353392 10588496
16:03:12 22787 8192000000 10866918864 11322216448 1928225104 19.053 100 24 48 0 1945288640 10062944 7000592
16:03:49 29509 8192000000 10874265984 11327279104 1928863968 19.058 99 30 58 2 1945549088 8965840 7719280
16:04:29 21912 8192000000 10893511072 11341107200 1930837184 19.074 99 36 72 1 1951073472 10284624 9951664
16:04:59 35095 8192000000 10887044928 11343736832 1914896736 18.946 98 30 60 1 1939610464 16749344 7964384
16:05:41 48249 8192000000 10885573696 11362144256 1944247024 19.181 100 18 36 1 1974145504 24293632 5604848
16:07:03 58288 8192000000 10880859840 11341594624 1887193712 18.723 96 24 48 0 1904295504 10393856 6707936
16:08:09 28720 8192000000 10895675280 11355910144 1936821632 19.121 99 38 76 0 1962932192 15291952 10818608
16:08:54 103643 8192000000 10889126864 11364573184 1941470352 19.158 99 11 22 0 1962967168 18573840 2922976
16:10:45 16625 8192000000 10905924592 11365593088 1973254624 19.411 100 47 94 0 1993932512 7413872 13264016
16:11:12 51561 8192000000 10909859568 11365015552 1954941232 19.266 99 38 76 0 1975656464 10668896 10046336
16:12:12 57608 8192000000 10866985760 11316555776 1876265840 18.635 95 36 72 1 1894161776 8120800 9775136
16:13:30 156497 8192000000 10866916336 11347468288 1904103744 18.859 97 26 52 0 1922962352 11932048 6926560
16:16:13 19994 8192000000 10902714416 11352735744 1957095520 19.283 100 15 30 0 1973662928 12463648 4103760
16:16:41 58234 8192000000 10867358784 11346599936 1934767424 19.105 98 21 42 0 1950819104 9686816 6364864
16:17:46 70926 8192000000 10878432016 11362689024 1927448224 19.046 98 9 18 1 1943868864 13633584 2787056
16:19:04 54054 8192000000 10893071904 11366875136 1966713616 19.359 100 19 39 0 1984054992 12035776 5305600
16:20:04 69908 8192000000 10889414144 11374227456 1979891104 19.464 100 25 50 0 1999670272 12505440 7273728
16:21:37 49466 8192000000 10892751184 11388157952 1955821776 19.273 99 6 12 0 1971115312 13910720 1382816
16:23:29 60754 8192000000 10907538544 11382210560 1964024192 19.338 99 18 36 0 1979463968 10204032 5235744
16:24:36 39652 8192000000 10924064000 11377537024 1966787696 19.360 99 29 58 1 1982871360 8213552 7870112
16:25:26 51072 8192000000 10905040288 11369324544 1960125264 19.307 99 40 79 0 1979853424 9217568 10510592
16:26:28 61416 8192000000 10901529056 11368361984 1918707984 18.976 97 29 58 2 1936985920 9773152 8504784
16:28:02 27112 8192000000 10898466400 11362574336 1933775424 19.097 98 30 60 0 1956276288 13736064 8764800
16:28:43 71897 8192000000 10896772656 11365187584 1869046432 18.577 95 13 26 0 1885351312 12422736 3882144
16:30:07 41719 8192000000 10902336352 11367231488 1945378768 19.190 99 38 77 0 1967891408 11835744 10676896
16:31:01 54153 8192000000 10896304480 11376357376 1951441120 19.238 99 26 52 0 1969252400 10545328 7265952
16:32:07 21554 8192000000 9081536960 9296138240 243670320 2.888 13 2 4 0 247772288 3768272 333696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-02-2021 16:33:12 to 05-02-2021 16:33:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-02-2021 16:33:44 to 05-02-2021 16:33:46.

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          231735
MON$OLDEST_ACTIVE               231736
MON$OLDEST_SNAPSHOT             231736
MON$NEXT_TRANSACTION            231736
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                       2008704
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.33414 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33414 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33414 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33414 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    Fri Feb  5 16:32:31 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Fri Feb  5 16:32:32 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'

05.02.21 16:33:47. 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-05 16:33:49 No severe PSQL-related problems occured
05.02.21 16:33:51. End of report.