Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.12.2020 16: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 17292012 kB
MemAvailable 31532416 kB
Buffers 0 kB
Cached 14412392 kB
SwapCached 3700 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-18 16:27:04
DTS_END                         2020-12-18 16:27:04.6030
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/53248
TRN_ID                          255555
ATT_ID                          728
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: 9483.28 19033 1137994
customer order: creation 187.46 301 22495
customer order: refuse 16.23 275 1947
order to supplier: creation 50.62 1080 6074
order to supplier: removal 3.38 77229 406
invoice (draft): creation 49.45 3064 5934
invoice (draft): removal 52.12 651 6254
invoice accept: apply 45.73 15337 5488
invoice accept: cancel 46.86 711 5623
customer reserve: creation 4137.50 155 496500
customer reserve: removal 4583.57 44 550028
realization accept: apply 90.87 159 10904
realization accept: cancel 80.18 93 9622
payment from customer: creation 63.43 115 7612
payment from customer: removal 5.94 70 713
payment to supplier: creation 53.03 118 6363
payment to supplier: removal 3.76 60 451
service: total inventory turnovers 5.01 1083 601
service: total monetary turnovers 7.20 32 864
service: aggregate perf. data 0.93 18956 111
service: refresh index statistics 0.03 261127 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-12-2020 16:28:26 to 18-12-2020 16:28:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4498
TEST_TIME 2 4371
TEST_TIME 3 4605
TEST_TIME 4 5082
TEST_TIME 5 6387
TEST_TIME 6 6848
TEST_TIME 7 7278
TEST_TIME 8 7258
TEST_TIME 9 7875
TEST_TIME 10 8043
TEST_TIME 11 9342
TEST_TIME 12 9664
TEST_TIME 13 9935
TEST_TIME 14 10249
TEST_TIME 15 10299
TEST_TIME 16 10427
TEST_TIME 17 10582
TEST_TIME 18 10642
TEST_TIME 19 10955
TEST_TIME 20 11251
TEST_TIME 21 11730
TEST_TIME 22 12069
TEST_TIME 23 11772
TEST_TIME 24 11667
TEST_TIME 25 11601
TEST_TIME 26 11751
TEST_TIME 27 11619
TEST_TIME 28 11401
TEST_TIME 29 11223
TEST_TIME 30 11168
TEST_TIME 31 11186
TEST_TIME 32 11324
TEST_TIME 33 11360
TEST_TIME 34 11204
TEST_TIME 35 11090
TEST_TIME 36 11098
TEST_TIME 37 11042
TEST_TIME 38 11052
TEST_TIME 39 10907
TEST_TIME 40 10700
TEST_TIME 41 10599
TEST_TIME 42 10592
TEST_TIME 43 10444
TEST_TIME 44 10401
TEST_TIME 45 10259
TEST_TIME 46 10387
TEST_TIME 47 10376
TEST_TIME 48 10337
TEST_TIME 49 10311
TEST_TIME 50 10221
TEST_TIME 51 10163
TEST_TIME 52 10109
TEST_TIME 53 10076
TEST_TIME 54 10017
TEST_TIME 55 9993
TEST_TIME 56 9995
TEST_TIME 57 10058
TEST_TIME 58 10101
TEST_TIME 59 10064
TEST_TIME 60 10095
TEST_TIME 61 10207
TEST_TIME 62 10173
TEST_TIME 63 10298
TEST_TIME 64 10358
TEST_TIME 65 10423
TEST_TIME 66 10388
TEST_TIME 67 10319
TEST_TIME 68 10274
TEST_TIME 69 10176
TEST_TIME 70 10140
TEST_TIME 71 10133
TEST_TIME 72 10089
TEST_TIME 73 10044
TEST_TIME 74 9976
TEST_TIME 75 9901
TEST_TIME 76 9865
TEST_TIME 77 9842
TEST_TIME 78 9938
TEST_TIME 79 9918
TEST_TIME 80 9885
TEST_TIME 81 9841
TEST_TIME 82 9909
TEST_TIME 83 9921
TEST_TIME 84 9904
TEST_TIME 85 9900
TEST_TIME 86 9954
TEST_TIME 87 9943
TEST_TIME 88 10002
TEST_TIME 89 10017
TEST_TIME 90 9975
TEST_TIME 91 9971
TEST_TIME 92 9891
TEST_TIME 93 9858
TEST_TIME 94 9847
TEST_TIME 95 9789
TEST_TIME 96 9739
TEST_TIME 97 9720
TEST_TIME 98 9730
TEST_TIME 99 9746
TEST_TIME 100 9759
TEST_TIME 101 9755
TEST_TIME 102 9734
TEST_TIME 103 9738
TEST_TIME 104 9773
TEST_TIME 105 9749
TEST_TIME 106 9784
TEST_TIME 107 9821
TEST_TIME 108 9813
TEST_TIME 109 9862
TEST_TIME 110 9861
TEST_TIME 111 9844
TEST_TIME 112 9760
TEST_TIME 113 9714
TEST_TIME 114 9675
TEST_TIME 115 9616
TEST_TIME 116 9600
TEST_TIME 117 9564
TEST_TIME 118 9558
TEST_TIME 119 9561
TEST_TIME 120 9484

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-12-2020 16:28:30 to 18-12-2020 16:28:33.

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 1597465 1597465 0 0.00 0 11545 6 0 0
doc_list_biud 1597464 1597464 0 0.00 0 26988 20 0 0
sp_add_invoice_to_stock 5570 5488 82 1.47 33 166362 15338 0 82
sp_cancel_adding_invoice 5623 5623 0 0.00 5 66090 712 0 0
sp_cancel_client_order 1947 1947 0 0.00 3 11494 275 0 0
sp_cancel_customer_reserve 550028 550028 0 0.00 1 27058 44 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 2 5726 71 0 0
sp_cancel_pay_to_supplier 451 451 0 0.00 3 2796 61 0 0
sp_cancel_supplier_invoice 6261 6254 7 0.11 2 23049 652 0 7
sp_cancel_supplier_order 406 406 0 0.00 7 698173 77230 0 0
sp_cancel_write_off 9622 9622 0 0.00 1 12048 94 0 0
sp_client_order 22495 22495 0 0.00 3 16547 301 0 0
sp_customer_reserve 496500 496500 0 0.00 0 41806 155 0 0
sp_fill_shopping_cart 34499 34499 0 0.00 1 11469 36 0 0
sp_fill_shopping_cart_clo_res 496496 496496 0 0.00 0 11609 12 0 0
sp_get_clo_for_invoice 5484 5484 0 0.00 0 23739 298 0 0
sp_kill_cost_storno 16409 16409 0 0.00 0 11536 45 0 0
sp_kill_qstorno_ret_qs2qd 1116338 1116338 0 0.00 0 26957 24 0 0
sp_kill_qty_storno 590267 590267 0 0.00 0 26988 53 0 0
sp_lock_selected_doc 22641 22641 0 0.00 0 6294 3 0 0
sp_make_cost_storno 30363 30363 0 0.00 0 10341 48 0 0
sp_multiply_rows_for_pdistr 30362 30362 0 0.00 0 9171 26 0 0
sp_multiply_rows_for_qdistr 22495 22495 0 0.00 0 16532 124 0 0
sp_pay_from_customer 7612 7612 0 0.00 4 13192 115 0 0
sp_pay_to_supplier 6363 6363 0 0.00 5 10453 119 0 0
sp_payment_common 13975 13975 0 0.00 1 10616 30 0 0
sp_qd_handle_on_cancel_clo 1947 1947 0 0.00 0 11486 250 0 0
sp_qd_handle_on_invoice_upd_sts 11106 11106 0 0.00 0 25021 286 0 0
sp_qd_handle_on_reserve_upd_sts 10904 10904 0 0.00 0 20947 52 0 0
sp_reserve_write_off 10904 10904 0 0.00 6 20958 160 0 0
sp_supplier_invoice 5934 5934 0 0.00 7 79807 3065 0 0
sp_supplier_order 6074 6074 0 0.00 4 42423 1081 0 0
srv_aggregate_perf_data 111 111 0 0.00 2308 212829 18957 0 0
srv_fill_mon_cache_memory 149 149 0 0.00 1032 187366 36981 0 0
srv_find_qd_qs_mism 1086300 1086300 0 0.00 0 10131 5 0 0
srv_make_invnt_saldo 601 601 0 0.00 32 119660 1083 0 0
srv_make_money_saldo 864 864 0 0.00 0 5520 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 177040 330911 261127 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5488 5488 0 0.00 0 14966 131 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 0 17681 140 0 0
t$perf-norm:sp_cancel_client_order 1947 1947 0 0.00 0 3491 17 0 0
t$perf-norm:sp_cancel_customer_reserve 746 746 0 0.00 0 5409 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 3152 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 451 451 0 0.00 0 2840 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 456 456 0 0.00 0 1237 13 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 30457 1563 0 0
t$perf-norm:sp_cancel_write_off 1085 1085 0 0.00 0 4523 15 0 0
t$perf-norm:sp_client_order 22495 22495 0 0.00 0 8554 16 0 0
t$perf-norm:sp_customer_reserve 1100 1100 0 0.00 0 978 6 0 0
t$perf-norm:sp_pay_from_customer 7612 7612 0 0.00 0 5426 10 0 0
t$perf-norm:sp_pay_to_supplier 6363 6363 0 0.00 0 8986 13 0 0
t$perf-norm:sp_reserve_write_off 10904 10904 0 0.00 0 9956 14 0 0
t$perf-norm:sp_supplier_invoice 5934 5934 0 0.00 0 15992 19 0 0
t$perf-norm:sp_supplier_order 6074 6074 0 0.00 0 5360 16 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 2391 29 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 1052 9 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 3126 21 0 0
t$perf-norm:srv_make_money_saldo 864 864 0 0.00 0 5314 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 11130 10966 164 1.47 0 5073 19 0 164
v_all_customers 40396 40396 0 0.00 0 85 1 0 0
v_all_suppliers 32836 32836 0 0.00 0 20 1 0 0
v_all_wares 44990 44990 0 0.00 0 164 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 505 5 0 0
v_cancel_client_order 3894 3894 0 0.00 0 4106 6 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 5706 12 0 0
v_cancel_customer_reserve 1492 1492 0 0.00 0 5707 14 0 0
v_cancel_payment_to_supplier 902 902 0 0.00 0 2457 7 0 0
v_cancel_supplier_invoice 926 912 14 1.51 0 1336 12 0 14
v_cancel_supplier_order 812 812 0 0.00 0 4553 8 0 0
v_cancel_write_off 2170 2170 0 0.00 0 3593 20 0 0
v_max_id_clo_ord 6072 6072 0 0.00 0 550 1 0 0
v_max_id_clo_res 1100 1100 0 0.00 0 4549 18 0 0
v_max_id_ord_sup 5932 5932 0 0.00 0 3382 3 0 0
v_max_non_paid_invoice 1949 1949 0 0.00 0 632 3 0 0
v_max_non_paid_realizn 4219 4219 0 0.00 0 2395 4 0 0
v_min_id_clo_ord 6072 6072 0 0.00 0 4243 6 0 0
v_min_id_clo_res 1100 1100 0 0.00 0 577 2 0 0
v_min_id_ord_sup 5932 5932 0 0.00 0 4629 8 0 0
v_min_non_paid_invoice 6363 6363 0 0.00 0 9748 20 0 0
v_min_non_paid_realizn 7612 7612 0 0.00 0 10440 18 0 0
v_our_firm 11380 11380 0 0.00 0 15 1 0 0
v_reserve_write_off 21808 21808 0 0.00 0 6594 7 0 0
x_lock_depdocs_on_canc_invoice 11421 11421 0 0.00 0 17056 103 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 11509 325 0 0
x_make_qstorno_1000_1200 6074 6074 0 0.00 2 42381 1006 0 0
x_make_qstorno_1200_2000 5934 5934 0 0.00 3 79791 2937 0 0
x_make_qstorno_2100_3300 496500 496500 0 0.00 0 40400 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-12-2020 16:28:34 to 18-12-2020 16:28:38.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:14 15883 8192000000 10236547600 10544771072 880250416 9.702 71 46 95 1 897827232 2250128 15326688
13:57:38 28310 8192000000 10353434368 10669477888 1391049008 14.515 100 84 166 0 1422537728 4697216 26791504
13:58:15 27986 8192000000 10386059728 10706821120 1429927712 14.861 100 90 180 0 1465568992 6546656 29094624
13:58:57 23689 8192000000 10410429600 10735599616 1465142128 15.171 100 91 182 1 1502305232 7930000 29233104
13:59:37 23770 8192000000 10438442000 10768367616 1481215472 15.312 100 88 176 1 1517794784 8556448 28022864
14:00:10 16517 8192000000 10440917152 10778107904 1500584960 15.481 100 82 164 0 1535506256 9106496 25814800
14:00:40 21947 8192000000 10470907616 10811133952 1528014720 15.720 100 83 166 0 1563856176 9474640 26366816
14:01:13 20645 8192000000 10505844928 10851856384 1550701728 15.916 100 82 164 0 1585968976 10252608 25014640
14:01:42 12443 8192000000 10516153936 10870661120 1583203632 16.196 100 79 158 1 1618365728 10831872 24330224
14:02:04 13648 8192000000 10549321120 10900619264 1606560448 16.395 100 80 160 0 1641175488 10802256 23812784
14:02:27 10455 8192000000 10567154384 10929315840 1623073792 16.536 100 73 146 1 1656122256 11420576 21627888
14:02:44 10496 8192000000 10598570176 10957189120 1647609872 16.744 100 82 162 3 1683925168 12403904 23911392
14:03:04 8494 8192000000 10613597888 10977308672 1669555760 16.929 100 81 162 1 1706335360 12902560 23877040
14:03:22 6479 8192000000 10611319488 10980339712 1675381312 16.978 100 76 152 0 1710213600 12444896 22387392
14:03:37 6425 8192000000 10631723136 11001118720 1693586112 17.131 100 79 155 1 1728018320 11739616 22692592
14:03:51 8359 8192000000 10647217248 11019984896 1711773552 17.284 100 79 158 0 1746630672 12069680 22787440
14:04:06 8672 8192000000 10662236288 11038806016 1728419072 17.422 100 76 152 0 1762312112 11992992 21900048
14:04:22 4218 8192000000 10689765168 11062104064 1744400416 17.555 100 80 160 1 1779242768 11660704 23181648
14:04:32 3836 8192000000 10693298784 11070214144 1762915328 17.708 100 89 178 0 1800669296 12723520 25030448
14:04:43 5063 8192000000 10704061872 11081981952 1765981920 17.734 100 86 172 1 1804184656 13852640 24350096
14:04:54 4374 8192000000 10723841584 11099701248 1777473072 17.829 100 88 175 0 1815982464 13952096 24557296
14:05:05 2299 8192000000 10734263712 11108220928 1789430336 17.927 100 92 184 1 1828329088 14125232 24773520
14:05:14 2697 8192000000 10732932496 11114250240 1795713632 17.979 100 85 170 0 1833663600 14097952 23852016
14:05:24 3170 8192000000 10746256832 11125907456 1802746608 18.036 100 86 170 0 1840848080 14423216 23678256
14:05:34 2472 8192000000 10753574512 11133960192 1810652416 18.101 100 89 176 2 1849237968 14480240 24105312
14:05:43 1921 8192000000 10762440368 11142545408 1814968128 18.137 100 89 178 0 1853477632 13969456 24540048
14:05:51 2058 8192000000 10756124720 11134722048 1815042320 18.137 100 89 178 0 1855022576 14415104 25565152
14:06:00 3727 8192000000 10741071104 11136843776 1819624608 18.175 100 76 152 0 1855305200 14709104 20971488
14:06:10 5911 8192000000 10753207408 11142852608 1819746256 18.176 100 82 166 2 1856116064 13513504 22856304
14:06:22 1867 8192000000 10781628848 11165835264 1834552256 18.296 100 81 162 0 1871180480 13507632 23120592
14:06:31 1857 8192000000 10787814752 11175854080 1845806160 18.388 100 88 176 2 1885216320 14047936 25362224
14:06:39 1722 8192000000 10801235824 11187462144 1853345056 18.449 100 96 192 1 1895294224 13825552 28123616
14:06:47 2001 8192000000 10793819968 11184676864 1857425376 18.482 100 83 166 1 1892892000 11728352 23738272
14:06:55 1620 8192000000 10811125792 11199803392 1866025744 18.552 100 90 181 0 1903314832 11627616 25661472
14:07:03 1307 8192000000 10813251280 11202211840 1869650736 18.581 100 92 184 0 1908028096 12268640 26108720
14:07:10 1206 8192000000 10822313216 11210661888 1871274528 18.595 100 89 177 1 1909442864 13893376 24274960
14:07:18 8376 8192000000 10811073920 11207974912 1870943728 18.592 100 78 155 0 1904555056 11901152 21710176
14:07:32 1765 8192000000 10800445520 11201646592 1867711664 18.566 100 52 104 1 1894131808 11641424 14778720
14:07:40 2539 8192000000 10803048416 11207290880 1871853120 18.599 100 64 126 2 1899691120 9892784 17945216
14:07:49 2101 8192000000 10797373104 11207618560 1873374768 18.612 100 69 138 3 1903792208 11223792 19193648
14:07:59 5174 8192000000 10785553680 11204542464 1870697392 18.590 100 42 85 1 1892116560 9970224 11448944
14:08:10 4759 8192000000 10800216064 11212402688 1876731936 18.639 100 51 103 2 1899780272 9234704 13813632
14:08:22 5829 8192000000 10805409632 11215630336 1878072912 18.650 100 42 83 3 1899194352 9781424 11340016
14:08:34 7841 8192000000 10788562384 11212120064 1876385168 18.636 100 33 66 1 1894015680 7994288 9636224
14:08:51 9745 8192000000 10790875776 11212681216 1879700784 18.663 100 25 50 1 1894519520 7191568 7627168
14:09:07 10089 8192000000 10813141648 11227934720 1882817168 18.688 100 29 58 1 1897326048 6481472 8027408
14:09:25 60379 8192000000 10818591888 11239174144 1884077824 18.698 100 27 51 3 1897487360 5421920 7987616
14:10:33 7731 8192000000 10797400528 11231358976 1885744848 18.711 100 24 48 0 1898692576 6565520 6382208
14:10:47 5701 8192000000 10817841472 11234992128 1888890640 18.737 100 31 62 0 1904748944 6700784 9157520
14:11:01 7951 8192000000 10801946832 11233583104 1889858944 18.745 100 27 55 2 1903254608 5399504 7996160
14:11:19 3815 8192000000 10815781776 11238887424 1894172032 18.779 100 41 82 3 1912397760 5546912 12678816
14:11:34 7292 8192000000 10813484288 11237797888 1889293328 18.740 100 16 32 0 1899324272 5534272 4496672
14:11:51 4948 8192000000 10799762736 11234529280 1891094352 18.755 100 25 51 0 1904778768 6508416 7176000
14:12:05 9998 8192000000 10808425712 11240923136 1892411792 18.765 100 14 28 1 1901823808 5548096 3863920
14:12:24 6344 8192000000 10806635664 11238027264 1890295984 18.748 100 23 47 1 1902784672 6056016 6432672
14:12:37 11208 8192000000 10803534464 11238854656 1889401680 18.741 100 18 36 1 1899782544 5413040 4967824
14:12:59 7996 8192000000 10796724704 11239608320 1891220992 18.756 100 19 38 2 1902614752 6230144 5163616
14:13:14 11692 8192000000 10798148880 11234201600 1874092624 18.617 99 16 30 4 1884243008 5890912 4259472
14:13:32 8375 8192000000 10804195328 11240169472 1894219616 18.780 100 28 56 4 1912847344 10990176 7637552
14:13:46 7566 8192000000 10814074960 11242213376 1874383040 18.620 99 19 38 1 1889573088 9358800 5831248
14:14:01 17808 8192000000 10802455216 11243986944 1893967168 18.778 100 15 30 1 1903324768 5280704 4076896
14:14:28 71380 8192000000 10807237168 11242704896 1880653216 18.670 99 32 62 2 1895584240 6116208 8814816
14:15:47 7979 8192000000 10822788992 11252219904 1900949168 18.834 100 36 72 0 1917955504 7386176 9620160
14:16:05 7526 8192000000 10807118640 11238457344 1882979648 18.689 99 37 73 0 1904045200 10994352 10071200
14:16:19 7446 8192000000 10808898352 11231223808 1842984064 18.365 97 30 60 0 1857244080 6158896 8101120
14:16:32 5081 8192000000 10797895664 11227824128 1870206016 18.586 99 28 56 0 1885395152 7266640 7922496
14:16:44 7430 8192000000 10792768688 11229278208 1866920832 18.559 99 21 42 2 1879007824 6287456 5799536
14:17:00 8085 8192000000 10790995968 11227725824 1880737040 18.671 100 25 49 1 1894043424 6015248 7291136
14:17:17 9081 8192000000 10724383744 11146452992 1717442096 17.331 92 12 24 0 1726075104 5070752 3562256
14:17:36 11574 8192000000 10723792960 11141279744 1735050400 17.478 95 18 36 1 1745500576 5295520 5154656
14:17:58 9870 8192000000 10718629984 11136921600 1742112240 17.536 96 29 58 2 1756707344 5574272 9020832
14:18:15 15428 8192000000 10717054816 11136647168 1739661584 17.516 96 15 30 0 1753690160 10043856 3984720
14:18:37 10556 8192000000 10690036352 11106340864 1736828064 17.492 97 18 36 0 1747747808 5890064 5029680
14:18:59 9509 8192000000 10661732352 11078918144 1677809328 16.999 94 19 38 0 1688111456 4928032 5374096
14:19:21 63232 8192000000 10674828320 11098451968 1696201216 17.153 95 35 70 0 1711568640 4927632 10439792
14:20:32 9274 8192000000 10706574464 11131850752 1785066416 17.891 99 20 39 2 1796624528 5794400 5763712
14:20:48 4883 8192000000 10729837312 11135434752 1786009760 17.899 99 40 80 3 1803511312 6223840 11277712
14:21:04 6364 8192000000 10716015072 11130445824 1772276832 17.786 98 24 48 0 1784798080 5989856 6531392
14:21:17 6145 8192000000 10735265840 11145084928 1810650752 18.101 100 36 72 1 1828052464 7183296 10218416
14:21:36 7793 8192000000 10739533248 11162595328 1825578752 18.223 100 30 60 1 1840235072 5759488 8896832
14:21:50 3281 8192000000 10737383904 11157680128 1811795696 18.111 99 32 63 2 1828340000 6719760 9824544
14:22:00 7620 8192000000 10751841008 11172728832 1829650384 18.256 100 25 50 2 1847052496 10022640 7379472
14:22:16 9862 8192000000 10758754704 11183181824 1838959040 18.332 100 16 32 1 1849042784 5628176 4455568
14:22:33 3771 8192000000 10767975760 11186339840 1846198784 18.391 100 21 42 1 1858745616 6141264 6405568
14:22:43 6074 8192000000 10762064624 11196596224 1849960480 18.422 100 23 46 1 1867416720 11064048 6392192
14:22:55 15743 8192000000 10765522128 11195879424 1852526608 18.443 100 10 20 1 1860479280 5277760 2674912
14:23:18 11619 8192000000 10767434864 11201011712 1856778528 18.477 100 12 24 1 1870112048 9963552 3369968
14:23:36 12719 8192000000 10772957200 11192541184 1837184880 18.318 99 24 48 0 1849685120 5155120 7345120
14:23:58 17513 8192000000 10767155408 11198943232 1859281264 18.497 100 16 32 3 1870538144 5936448 5320432
14:24:22 54463 8192000000 10786412176 11206434816 1863470912 18.531 100 24 48 1 1875514160 4993888 7049360
14:25:24 12644 8192000000 10787449616 11212685312 1870116640 18.585 100 26 52 2 1883255120 6088128 7050352
14:25:48 10175 8192000000 10777373696 11206680576 1854992176 18.463 99 34 68 1 1871152048 6915888 9243984
14:26:05 8651 8192000000 10771344912 11206770688 1864947344 18.543 100 21 42 3 1877101056 5371616 6782096
14:26:23 6404 8192000000 10779198048 11214303232 1871699424 18.598 100 23 46 2 1884417904 6066912 6651568
14:26:36 11338 8192000000 10781088976 11214946304 1873279936 18.611 100 23 46 1 1885954176 5343312 7330928
14:26:54 51193 8192000000 10818144464 11238141952 1882870640 18.688 100 21 42 0 1894347984 5668576 5808768
14:28:02 17511 8192000000 10843048352 11266912256 1917699280 18.968 100 44 88 3 1940077632 9521488 12856864
14:28:31 31540 8192000000 10852523584 11274276864 1908061856 18.891 99 49 96 1 1933944000 12535920 13346224
14:29:16 6130 8192000000 10862411344 11285782528 1928189728 19.052 100 39 78 1 1951813792 12595296 11028768
14:29:34 33331 8192000000 10874918224 11295567872 1943137696 19.172 100 44 87 0 1969006784 13612368 12256720
14:30:14 31161 8192000000 10880710944 11308060672 1944317760 19.181 100 31 62 2 1965986224 12300832 9367632
14:30:57 12792 8192000000 10881886416 11309412352 1950637952 19.232 100 46 90 2 1979532752 14327856 14566944
14:31:17 55202 8192000000 10877295200 11315425280 1929837152 19.066 99 43 86 0 1959444240 16790240 12816848
14:32:22 7226 8192000000 10875572464 11309608960 1941772064 19.161 100 35 70 2 1967269712 15111984 10385664
14:32:35 15678 8192000000 10873088752 11319050240 1944765728 19.185 100 32 64 1 1969584624 15213456 9605440
14:33:00 26964 8192000000 10892006960 11327160320 1953318848 19.253 100 41 78 3 1980675536 16117296 11239392
14:33:34 5114 8192000000 10902485936 11326447616 1955574224 19.271 100 48 96 1 1985908752 15794416 14540112
14:33:48 14960 8192000000 10874896144 11307016192 1936469664 19.119 99 44 85 1 1964860016 16146000 12244352
14:34:12 1029 8192000000 10933280064 11341484032 1975132288 19.426 100 91 183 1 2017135504 16262368 25740848
14:34:20 4423 8192000000 10916033184 11347791872 1975244736 19.427 100 59 118 1 2009512800 16566320 17701744
14:34:31 10624 8192000000 10918543888 11347480576 1957576400 19.287 99 53 105 0 1987687600 15751392 14359808
14:34:49 2167 8192000000 10919417840 11328790528 1961259856 19.316 99 72 141 1 1998175504 15938336 20977312
14:34:58 10088 8192000000 10911163040 11348512768 1975656480 19.430 100 51 102 0 2007317008 16245040 15415488
14:35:20 3486 8192000000 10904320128 11328335872 1953158320 19.252 99 57 115 1 1989039200 19225104 16655776
14:35:33 7852 8192000000 10916685136 11345948672 1970959312 19.393 100 60 120 0 2008694368 20083296 17651760
14:35:50 7704 8192000000 10922121520 11349262336 1960184304 19.308 99 52 99 5 1994896944 20152576 14560064
14:36:05 5839 8192000000 10914102560 11349057536 1960477168 19.310 99 57 114 1 1998667888 20729488 17461232
14:36:21 2204 8192000000 10930142560 11351470080 1978564288 19.453 100 68 137 0 2019096720 19607824 20924608
14:36:31 3675 8192000000 10929768656 11351580672 1965668032 19.351 99 71 142 0 2006944736 19896736 21379968
14:36:41 3828 8192000000 10937824592 11361796096 1982996784 19.488 100 78 157 2 2027086144 20994608 23094752
14:36:55 1590 8192000000 10946229840 11354656768 1965260384 19.348 99 89 177 2 2013652480 22385456 26006640
14:37:03 3044 8192000000 10935353392 11358863360 1977690576 19.446 100 67 130 0 2019783712 22430560 19662576
14:37:14 6224 8192000000 10921564096 11351007232 1970090256 19.386 100 65 126 3 2011817696 23026672 18700768
14:37:28 3519 8192000000 10934263392 11359301632 1976124720 19.434 100 70 140 1 2022451584 25111840 21215024
14:37:38 2771 8192000000 10936816512 11365400576 1978224416 19.451 100 56 112 0 2022571104 27658016 16688672
14:37:47 4877 8192000000 10938987312 11355799552 1962176096 19.323 99 76 143 1 2010895088 27686640 21032352
14:37:59 2183 8192000000 10949849232 11369025536 1979253232 19.459 100 80 158 1 2031985680 29169088 23563360
14:38:08 6868 8192000000 10926879904 11339948032 1958772880 19.296 99 79 157 1 2009621312 27690848 23157584
14:38:23 2893 8192000000 10937669024 11358023680 1972208912 19.403 100 74 146 0 2020258960 26159584 21890464
14:38:34 1440 8192000000 10913894080 11334504448 1953642448 19.255 100 71 141 0 1999148368 24929312 20576608
14:38:42 9278 8192000000 10901146240 11341193216 1945462544 19.190 99 59 118 0 1989209776 26210160 17537072
14:39:09 11179 8192000000 10891664016 11331530752 1949683568 19.224 100 44 88 1 1983512928 19009200 14820160
14:39:29 1264 8192000000 10907824336 11325091840 1941705600 19.160 100 79 154 0 1991310704 24485920 25119184
14:39:37 1656 8192000000 10909821936 11322515456 1940090656 19.147 100 92 186 0 1997332688 28369664 28872368
14:39:45 4505 8192000000 10872469648 11307532288 1899692864 18.824 98 45 89 0 1938675248 25443296 13539088
14:39:57 11233 8192000000 10866224544 11293249536 1895099936 18.787 98 35 70 1 1929089088 22375984 11613168
14:40:20 9855 8192000000 10873812816 11296645120 1914025392 18.939 99 56 109 0 1952243952 22005296 16213264
14:40:38 2964 8192000000 10897181360 11308322816 1925417568 19.030 99 77 154 2 1972798432 23369488 24011376
14:40:49 1516 8192000000 10893897056 11300667392 1923331232 19.014 99 95 190 0 1973467872 21899904 28236736
14:40:57 1733 8192000000 10893218864 11304722432 1928931744 19.058 100 76 152 0 1975199056 23561200 22706112
14:41:05 2575 8192000000 10906111696 11316793344 1940894592 19.154 100 82 160 2 1988789264 24105088 23789584
14:41:16 4461 8192000000 10854206688 11268354048 1861384160 18.515 96 67 132 3 1904931296 22669488 20877648
14:41:29 3456 8192000000 10898962624 11303997440 1925926992 19.034 100 75 151 0 1972070224 23301520 22841712
14:41:39 2311 8192000000 10883628496 11287744512 1892650400 18.767 98 87 172 0 1944317616 24857872 26809344
14:41:48 3902 8192000000 10869214064 11284729856 1908536368 18.895 100 60 119 1 1952378608 25884384 17957856
14:42:01 27044 8192000000 10855479264 11296747520 1907842176 18.889 100 36 72 2 1944289648 25061104 11386368
14:42:39 14566 8192000000 10867151120 11293609984 1899640336 18.823 99 29 58 2 1933250928 24156640 9453952
14:43:03 2542 8192000000 10868157424 11279470592 1896547408 18.799 98 77 149 1 1943184736 24058960 22578368
14:43:12 2785 8192000000 10879293888 11294998528 1904257488 18.861 99 74 146 4 1954432416 28432544 21742384
14:43:28 4204 8192000000 10894021232 11313430528 1931937248 19.082 100 69 139 1 1981913520 28210432 21765840
14:43:40 6625 8192000000 10876495664 11314589696 1929848656 19.066 100 39 76 1 1968896368 26896240 12151472
14:43:54 9146 8192000000 10893764080 11325018112 1937275472 19.125 100 35 68 1 1975804320 27263168 11265680
14:44:11 7531 8192000000 10905320528 11324317696 1926832128 19.042 99 57 112 2 1979515664 34691632 17991904
14:44:39 6390 8192000000 10889540288 11316445184 1929599184 19.064 100 41 82 0 1970997584 27847520 13550880
14:44:53 23949 8192000000 10889147728 11322265600 1933719104 19.097 100 36 72 0 1975412864 29233312 12460448
14:45:26 4176 8192000000 10896718080 11326177280 1923228496 19.013 99 46 90 2 1966463264 28358528 14876240
14:45:42 26728 8192000000 10908323968 11338506240 1939478224 19.143 100 39 76 3 1984293248 32266752 12548272
14:46:17 6152 8192000000 10901322416 11334762496 1937017984 19.123 100 49 99 2 1989180208 35686704 16475520
14:46:29 13156 8192000000 10898771952 11340926976 1944630272 19.184 100 29 58 2 1993772784 38714032 10428480
14:46:51 14077 8192000000 10897441440 11339223040 1922520592 19.007 99 27 54 2 1965335072 33665072 9149408
14:47:13 10767 8192000000 10894352304 11334606848 1918354880 18.974 99 35 66 1 1962809920 33115456 11339584
14:47:39 31882 8192000000 10901534368 11348156416 1942790272 19.169 100 40 77 0 1990876192 35787920 12298000
14:48:59 22084 8192000000 10871745312 11331031040 1936027344 19.115 100 27 54 2 1967403296 22761344 8614608
14:49:30 59231 8192000000 10855026816 11316539392 1922832288 19.010 99 28 56 1 1954507504 22896048 8779168
14:50:40 24448 8192000000 10863472080 11318902784 1916998272 18.963 99 20 40 1 1940527776 16432928 7096576
14:51:13 23791 8192000000 10854722240 11309596672 1926375008 19.038 100 17 35 3 1945513024 14426784 4711232
14:51:44 38172 8192000000 10850312016 11310387200 1896930608 18.802 98 20 40 0 1914040032 11552192 5557232
14:53:02 121265 8192000000 10878147408 11342761984 1938540656 19.135 100 8 16 1 1956898976 16043536 2314784
14:55:14 87774 8192000000 10879879424 11335696384 1881151504 18.674 96 17 34 1 1901653440 15471616 5030320
14:56:48 54790 8192000000 10890853728 11346440192 1933073440 19.091 99 13 26 0 1955447152 19314928 3058784
14:57:56 69875 8192000000 10918083600 11367522304 1936904512 19.122 99 15 30 1 1965156400 23152912 5098976
14:59:14 92814 8192000000 10893197472 11363725312 1955017456 19.266 99 29 58 0 1978401632 15438768 7945408
15:00:53 81149 8192000000 10911079216 11362545664 1938774896 19.137 98 15 30 1 1952551200 9265312 4510992
15:02:21 31177 8192000000 10919960720 11359571968 1969284032 19.380 100 12 24 2 1979227424 6588496 3354896
15:02:58 24403 8192000000 10925534048 11364057088 1963034224 19.330 99 41 83 0 1983671760 8628624 12008912
15:03:29 22870 8192000000 10905932544 11371831296 1982358832 19.483 100 31 61 0 2000716320 9556352 8801136
15:04:10 41404 8192000000 10918722704 11381809152 1985230736 19.506 100 9 18 0 1996631088 8794976 2605376
15:05:03 60884 8192000000 10919050192 11384680448 1975639680 19.430 99 10 20 2 1990767200 12306640 2820880
15:06:17 83700 8192000000 10941128768 11391602688 1991475472 19.555 100 18 36 0 2006151776 9942832 4733472
15:07:53 46387 8192000000 10932222976 11387686912 1980134640 19.466 99 40 77 4 1999177328 7874992 11167696
15:08:45 40532 8192000000 10932494432 11386658816 1983159648 19.490 99 35 67 2 2001829376 8021888 10647840
15:09:34 46006 8192000000 10914709488 11379400704 1991250832 19.554 100 20 40 0 2002825488 6522912 5051744
15:10:28 31897 8192000000 10908262512 11365154816 1974516560 19.421 99 19 38 0 1986598128 6601856 5479712
15:12:01 39023 8192000000 10949092736 11393499136 1986616192 19.517 99 44 85 3 2010784304 11707744 12460368
15:12:57 37852 8192000000 10885081280 11366580224 1930883296 19.074 97 14 28 0 1945637440 11250160 3503984
15:13:42 99358 8192000000 10909811248 11380281344 1931340240 19.078 97 16 32 2 1950452896 13823280 5289376
15:15:32 44633 8192000000 10897006528 11384221696 1979202016 19.458 100 7 14 0 1991846368 10484272 2160080
15:16:26 6607 8192000000 10894668960 11384872960 1979456032 19.460 100 6 12 1 1989777440 8715744 1605664
15:16:38 10865 8192000000 10887141056 11361767424 1943014016 19.171 98 11 22 0 1953046992 7298640 2734336
15:16:55 70021 8192000000 10875108896 11347533824 1878530144 18.653 95 14 28 3 1890843696 8197552 4116000
15:18:12 118327 8192000000 10852467616 11328364544 1858541920 18.491 95 16 32 0 1877408432 14058400 4808112
15:20:16 55030 8192000000 10870584656 11339513856 1926351424 19.038 99 11 22 0 1941827792 12783504 2692864
15:21:18 75311 8192000000 10862790800 11326140416 1881029168 18.673 96 15 30 0 1896059392 10538352 4491872
15:22:40 45550 8192000000 10864121632 11337863168 1885862400 18.712 97 9 18 1 1897401504 9261728 2277376
15:23:41 47194 8192000000 10837828032 11302764544 1839106640 18.334 95 18 35 2 1857650176 13405664 5137872
15:24:36 63852 8192000000 10821392368 11290349568 1826693472 18.232 95 17 34 0 1852163952 20365744 5104736
15:25:47 36861 8192000000 10833410832 11290320896 1832330384 18.278 96 22 42 3 1856990880 18422048 6238448
15:26:30 43248 8192000000 10814191952 11266625536 1830733392 18.265 97 23 46 0 1851271136 13718864 6818880
15:27:28 61955 8192000000 10795734880 11253325824 1792681952 17.954 94 12 24 2 1810253472 14651152 2920368
15:28:36 65696 8192000000 10828098416 11279310848 1785784448 17.897 94 19 38 1 1803700720 12970896 4945376
15:29:48 86007 8192000000 10836321680 11321696256 1868361376 18.571 98 12 24 0 1894556224 22962480 3232368
15:31:22 93092 8192000000 10848447392 11314860032 1877405120 18.644 97 16 32 2 1892494544 10692784 4396640
15:33:01 45160 8192000000 10883955488 11333607424 1922175456 19.004 99 37 73 3 1942302176 9737552 10389168
15:34:01 66461 8192000000 10879830144 11338702848 1923772368 19.017 99 29 57 1 1944328464 12193104 8362992
15:35:24 73014 8192000000 10889727280 11328593920 1927212144 19.045 99 31 60 4 1943268992 6607728 9449120
15:36:50 47480 8192000000 10885923392 11344691200 1947890416 19.210 100 36 72 2 1967140736 8964720 10285600
15:37:44 71555 8192000000 10846035536 11329097728 1898050032 18.811 97 23 46 3 1919765984 14913680 6802272
15:39:03 58916 8192000000 10843331168 11334926336 1883543984 18.694 97 3 6 0 1898145408 13952432 648992
15:40:12 53845 8192000000 10863839488 11331780608 1920697840 18.992 99 14 27 0 1933990480 9239632 4053008
15:41:12 116123 8192000000 10882462224 11347824640 1932158880 19.084 99 22 44 1 1955651408 15905136 7587392
15:43:18 41385 8192000000 10887040704 11352911872 1956932976 19.282 100 32 63 1 1982520352 15639248 9948128
15:44:11 50769 8192000000 10886045472 11370655744 1958282576 19.292 100 23 46 0 1987356320 21807408 7266336
15:45:23 77230 8192000000 10880124832 11341590528 1920433200 18.990 98 8 16 0 1931337952 8689872 2214880
15:46:55 31884 8192000000 10876131360 11341340672 1936377360 19.118 99 23 46 0 1950500080 7752032 6370688
15:47:39 24103 8192000000 10894830288 11352870912 1953413568 19.254 100 35 70 3 1972069200 9293776 9361856
15:48:09 16926 8192000000 10912933840 11361267712 1967040960 19.362 100 55 108 1 1993302000 10874368 15386672
15:48:37 20531 8192000000 10909486176 11368538112 1972458944 19.405 100 42 84 0 1996112096 12025136 11628016
15:49:08 56285 8192000000 10887253984 11363586048 1931625440 19.080 98 27 54 3 1950049536 11314752 7109344
15:50:11 87097 8192000000 10909999456 11382718464 1975861552 19.432 100 16 32 0 1988983712 8855184 4266976
15:51:44 52989 8192000000 10897706528 11354382336 1929063040 19.059 97 28 56 0 1948010064 11080256 7866768
15:52:46 30526 8192000000 10907046320 11376431104 1955213936 19.268 99 24 47 2 1975466544 13941264 6311344
15:53:29 71960 8192000000 10893228544 11359703040 1915678080 18.952 97 17 34 0 1928650064 8359008 4612976
15:54:49 93635 8192000000 10911027216 11382415360 1953500336 19.254 99 13 26 0 1970723680 13925376 3297968
15:56:32 75383 8192000000 10949105552 11389661184 1984671792 19.502 100 30 62 0 2002860768 10153136 8035840
15:57:56 36645 8192000000 10909572656 11370684416 1968496880 19.374 99 28 56 0 1987601296 11510224 7594192
15:58:42 98977 8192000000 10922139792 11393470464 1994442064 19.579 100 42 81 0 2015559952 10307552 10810336
16:00:29 76325 8192000000 10928337744 11395571712 1943373280 19.174 97 38 75 2 1968490784 14038064 11079440
16:02:31 69266 8192000000 10902234816 11387215872 1969004384 19.378 99 13 26 0 1987540528 14533968 4002176
16:04:37 50521 8192000000 10850930320 11319017472 1865863472 18.551 94 24 47 3 1883844944 10941984 7039488
16:05:35 47143 8192000000 10846588320 11327143936 1862338912 18.522 96 19 39 0 1884519456 16386352 5794192
16:06:28 67933 8192000000 10841170528 11323858944 1855313264 18.465 96 12 24 0 1870108624 11097232 3698128
16:08:26 85596 8192000000 10847880256 11303010304 1841125520 18.350 95 16 32 0 1854297856 8838800 4333536
16:09:57 89393 8192000000 10823125232 11281625088 1749214592 17.595 91 13 26 2 1760176272 7469136 3492544
16:11:33 54222 8192000000 10827911184 11277709312 1841699552 18.355 97 14 28 1 1856779312 11361856 3717904
16:12:38 18172 8192000000 10860291520 11308978176 1910029600 18.907 100 55 110 2 1940560464 14509584 16021280
16:13:03 62932 8192000000 10848574800 11310448640 1858059136 18.488 97 36 72 0 1884990672 16960160 9971376
16:14:20 80291 8192000000 10839876176 11313623040 1834106608 18.293 96 20 40 2 1858080224 18567376 5406240
16:15:51 187366 8192000000 10833622400 11297411072 1756616064 17.656 92 13 26 0 1773621488 13556096 3449328
16:19:44 80734 8192000000 10834733248 11304144896 1911738896 18.921 99 8 16 0 1920937888 6912448 2286544
16:21:18 53227 8192000000 10848733904 11329163264 1933748000 19.097 100 10 20 1 1943349616 6889376 2712240
16:22:29 12269 8192000000 10850020768 11330019328 1936800576 19.121 100 7 13 1 1946079104 7341104 1937424
16:22:48 92113 8192000000 10849432848 11331743744 1924143344 19.020 99 14 28 0 1936151984 8340736 3667904
16:25:36 72945 8192000000 10836087552 11310276608 1855896976 18.470 96 7 14 1 1870270272 12684288 1689008
16:26:55 14726 8192000000 9269726912 9533931520 425872192 4.941 22 6 12 0 434066752 6604336 1590224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 18-12-2020 16:28:40 to 18-12-2020 16:29:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 82 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-12-2020 16:29:11 to 18-12-2020 16:29:13.

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          255982
MON$OLDEST_ACTIVE               256682
MON$OLDEST_SNAPSHOT             256682
MON$NEXT_TRANSACTION            256682
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                       2046176
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:38: 
:39: mscs-test-161.budzdorov.ru    Fri Dec 18 16:27:13 2020
:40:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:41: 
:42: 
:43: mscs-test-161.budzdorov.ru    Fri Dec 18 16:27:13 2020
:44:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:45: 
--- end of diff output ---

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

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