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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-16 19:27:19
DTS_END                         2021-03-16 19:27:19.9580
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/50578
TRN_ID                          236090
ATT_ID                          680
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: 9157.84 20118 1098941
customer order: creation 173.03 364 20764
customer order: refuse 14.06 392 1687
order to supplier: creation 46.50 1363 5580
order to supplier: removal 3.34 103314 401
invoice (draft): creation 45.95 3814 5514
invoice (draft): removal 53.45 741 6414
invoice accept: apply 41.18 18529 4941
invoice accept: cancel 47.98 872 5758
customer reserve: creation 3757.03 183 450843
customer reserve: removal 4674.18 58 560902
realization accept: apply 83.03 214 9963
realization accept: cancel 88.06 112 10567
payment from customer: creation 59.27 160 7112
payment from customer: removal 5.88 81 705
payment to supplier: creation 49.38 179 5926
payment to supplier: removal 3.44 89 413
service: total inventory turnovers 4.58 1122 550
service: total monetary turnovers 6.76 58 811
service: aggregate perf. data 0.72 25521 86
service: refresh index statistics 0.03 245190 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-03-2021 19:28:38 to 16-03-2021 19:28:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2509
TEST_TIME 2 4092
TEST_TIME 3 3268
TEST_TIME 4 3268
TEST_TIME 5 4107
TEST_TIME 6 4072
TEST_TIME 7 5452
TEST_TIME 8 5936
TEST_TIME 9 6788
TEST_TIME 10 6960
TEST_TIME 11 7084
TEST_TIME 12 7389
TEST_TIME 13 8072
TEST_TIME 14 8362
TEST_TIME 15 8721
TEST_TIME 16 9157
TEST_TIME 17 9343
TEST_TIME 18 9297
TEST_TIME 19 9713
TEST_TIME 20 10035
TEST_TIME 21 9923
TEST_TIME 22 10299
TEST_TIME 23 10424
TEST_TIME 24 10555
TEST_TIME 25 10461
TEST_TIME 26 10409
TEST_TIME 27 10381
TEST_TIME 28 10683
TEST_TIME 29 10516
TEST_TIME 30 10837
TEST_TIME 31 11134
TEST_TIME 32 11198
TEST_TIME 33 11212
TEST_TIME 34 11031
TEST_TIME 35 10852
TEST_TIME 36 10840
TEST_TIME 37 10770
TEST_TIME 38 10706
TEST_TIME 39 10625
TEST_TIME 40 10579
TEST_TIME 41 10450
TEST_TIME 42 10360
TEST_TIME 43 10268
TEST_TIME 44 10205
TEST_TIME 45 10087
TEST_TIME 46 9978
TEST_TIME 47 9919
TEST_TIME 48 9808
TEST_TIME 49 9880
TEST_TIME 50 9731
TEST_TIME 51 9620
TEST_TIME 52 9583
TEST_TIME 53 9518
TEST_TIME 54 9520
TEST_TIME 55 9504
TEST_TIME 56 9525
TEST_TIME 57 9460
TEST_TIME 58 9831
TEST_TIME 59 9807
TEST_TIME 60 9823
TEST_TIME 61 9762
TEST_TIME 62 9746
TEST_TIME 63 9745
TEST_TIME 64 9885
TEST_TIME 65 9829
TEST_TIME 66 9861
TEST_TIME 67 9806
TEST_TIME 68 9876
TEST_TIME 69 9880
TEST_TIME 70 9811
TEST_TIME 71 9796
TEST_TIME 72 9831
TEST_TIME 73 9765
TEST_TIME 74 9669
TEST_TIME 75 9715
TEST_TIME 76 9700
TEST_TIME 77 9630
TEST_TIME 78 9611
TEST_TIME 79 9565
TEST_TIME 80 9538
TEST_TIME 81 9498
TEST_TIME 82 9522
TEST_TIME 83 9465
TEST_TIME 84 9397
TEST_TIME 85 9378
TEST_TIME 86 9429
TEST_TIME 87 9381
TEST_TIME 88 9327
TEST_TIME 89 9470
TEST_TIME 90 9434
TEST_TIME 91 9458
TEST_TIME 92 9454
TEST_TIME 93 9431
TEST_TIME 94 9522
TEST_TIME 95 9513
TEST_TIME 96 9471
TEST_TIME 97 9586
TEST_TIME 98 9550
TEST_TIME 99 9519
TEST_TIME 100 9592
TEST_TIME 101 9615
TEST_TIME 102 9544
TEST_TIME 103 9524
TEST_TIME 104 9479
TEST_TIME 105 9446
TEST_TIME 106 9423
TEST_TIME 107 9427
TEST_TIME 108 9407
TEST_TIME 109 9382
TEST_TIME 110 9361
TEST_TIME 111 9322
TEST_TIME 112 9349
TEST_TIME 113 9347
TEST_TIME 114 9287
TEST_TIME 115 9319
TEST_TIME 116 9274
TEST_TIME 117 9232
TEST_TIME 118 9244
TEST_TIME 119 9216
TEST_TIME 120 9162

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-03-2021 19:28:41 to 16-03-2021 19:28:45.

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 1517362 1517362 0 0.00 0 33308 7 0 0
doc_list_biud 1517362 1517362 0 0.00 0 35725 28 0 0
sp_add_invoice_to_stock 5087 4941 146 2.87 42 156278 18530 0 146
sp_cancel_adding_invoice 5758 5758 0 0.00 4 113467 873 0 0
sp_cancel_client_order 1687 1687 0 0.00 4 30520 392 0 0
sp_cancel_customer_reserve 560902 560902 0 0.00 1 35728 58 0 0
sp_cancel_pay_from_customer 705 705 0 0.00 3 4018 81 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 3 3896 89 0 0
sp_cancel_supplier_invoice 6422 6414 8 0.12 1 20379 741 0 8
sp_cancel_supplier_order 401 401 0 0.00 4 957090 103315 0 0
sp_cancel_write_off 10567 10567 0 0.00 1 11894 112 0 0
sp_client_order 20764 20764 0 0.00 4 22062 364 0 0
sp_customer_reserve 450843 450843 0 0.00 0 50882 183 0 0
sp_fill_shopping_cart 31855 31855 0 0.00 1 12004 44 0 0
sp_fill_shopping_cart_clo_res 450836 450836 0 0.00 0 19964 12 0 0
sp_get_clo_for_invoice 4934 4934 0 0.00 0 22082 278 0 0
sp_kill_cost_storno 17443 17443 0 0.00 0 33296 61 0 0
sp_kill_qstorno_ret_qs2qd 1139186 1139186 0 0.00 0 28512 31 0 0
sp_kill_qty_storno 600626 600626 0 0.00 0 35725 69 0 0
sp_lock_selected_doc 20651 20651 0 0.00 0 6933 6 0 0
sp_make_cost_storno 27935 27935 0 0.00 0 25864 72 0 0
sp_multiply_rows_for_pdistr 27935 27935 0 0.00 0 15494 35 0 0
sp_multiply_rows_for_qdistr 20764 20764 0 0.00 0 12586 147 0 0
sp_pay_from_customer 7112 7112 0 0.00 4 20846 161 0 0
sp_pay_to_supplier 5926 5926 0 0.00 5 20896 180 0 0
sp_payment_common 13038 13038 0 0.00 1 16951 47 0 0
sp_qd_handle_on_cancel_clo 1687 1687 0 0.00 0 30509 355 0 0
sp_qd_handle_on_invoice_upd_sts 10692 10692 0 0.00 0 31696 371 0 0
sp_qd_handle_on_reserve_upd_sts 9963 9963 0 0.00 0 18349 70 0 0
sp_reserve_write_off 9963 9963 0 0.00 6 23915 214 0 0
sp_supplier_invoice 5514 5514 0 0.00 5 98633 3815 0 0
sp_supplier_order 5580 5580 0 0.00 4 37317 1363 0 0
srv_aggregate_perf_data 86 86 0 0.00 2318 139617 25522 0 0
srv_fill_mon_cache_memory 179 179 0 0.00 1319 162282 29569 0 0
srv_find_qd_qs_mism 1051919 1051919 0 0.00 0 11152 5 0 0
srv_make_invnt_saldo 550 550 0 0.00 30 48156 1123 0 0
srv_make_money_saldo 811 811 0 0.00 1 15970 59 0 0
srv_recalc_idx_stat 4 4 0 0.00 157370 438388 245191 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 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 4941 4941 0 0.00 0 29045 223 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 4727 161 0 0
t$perf-norm:sp_cancel_client_order 1687 1687 0 0.00 0 3658 19 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 1362 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 705 705 0 0.00 0 1399 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 4159 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 10381 44 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 42224 1726 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 873 9 0 0
t$perf-norm:sp_client_order 20764 20764 0 0.00 0 10119 21 0 0
t$perf-norm:sp_customer_reserve 1047 1047 0 0.00 0 12069 17 0 0
t$perf-norm:sp_pay_from_customer 7112 7112 0 0.00 0 5227 11 0 0
t$perf-norm:sp_pay_to_supplier 5926 5926 0 0.00 0 5956 12 0 0
t$perf-norm:sp_reserve_write_off 9963 9963 0 0.00 0 8605 14 0 0
t$perf-norm:sp_supplier_invoice 5514 5514 0 0.00 0 5474 20 0 0
t$perf-norm:sp_supplier_order 5580 5580 0 0.00 0 5207 20 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 174 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 179 179 0 0.00 0 406 5 0 0
t$perf-norm:srv_make_invnt_saldo 550 550 0 0.00 0 1818 35 0 0
t$perf-norm:srv_make_money_saldo 811 811 0 0.00 0 7982 36 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10160 9868 292 2.87 0 6856 24 0 292
v_all_customers 37808 37808 0 0.00 0 38 1 0 0
v_all_suppliers 30772 30772 0 0.00 0 55 1 0 0
v_all_wares 41528 41528 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 4856 19 0 0
v_cancel_client_order 3374 3374 0 0.00 0 3956 6 0 0
v_cancel_customer_prepayment 1410 1410 0 0.00 0 2011 7 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 1464 6 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 1856 9 0 0
v_cancel_supplier_invoice 832 816 16 1.92 0 746 14 0 16
v_cancel_supplier_order 802 802 0 0.00 0 2014 9 0 0
v_cancel_write_off 2124 2124 0 0.00 0 4004 22 0 0
v_max_id_clo_ord 5580 5580 0 0.00 0 1442 2 0 0
v_max_id_clo_res 1047 1047 0 0.00 0 1727 14 0 0
v_max_id_ord_sup 5509 5509 0 0.00 0 3646 4 0 0
v_max_non_paid_invoice 1629 1629 0 0.00 0 538 3 0 0
v_max_non_paid_realizn 3763 3763 0 0.00 0 7525 8 0 0
v_min_id_clo_ord 5580 5580 0 0.00 0 11936 15 0 0
v_min_id_clo_res 1047 1047 0 0.00 0 1770 6 0 0
v_min_id_ord_sup 5509 5509 0 0.00 0 8988 11 0 0
v_min_non_paid_invoice 5926 5926 0 0.00 0 12505 35 0 0
v_min_non_paid_realizn 7112 7112 0 0.00 0 13220 28 0 0
v_our_firm 10418 10418 0 0.00 0 26 1 0 0
v_reserve_write_off 19926 19926 0 0.00 0 5418 9 0 0
x_lock_depdocs_on_canc_invoice 11764 11764 0 0.00 0 20876 142 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 28347 445 0 0
x_make_qstorno_1000_1200 5580 5580 0 0.00 2 37302 1257 0 0
x_make_qstorno_1200_2000 5514 5514 0 0.00 2 98417 3673 0 0
x_make_qstorno_2100_3300 450843 450843 0 0.00 0 43188 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-03-2021 19:28:46 to 16-03-2021 19:28:50.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:29 25773 8192000000 10263791584 10573737984 899134400 9.890 69 51 103 0 918070848 2404272 16532176
16:58:11 31844 8192000000 10368269040 10688995328 1418169056 14.756 100 84 168 0 1451328192 5835632 27323504
16:58:53 12592 8192000000 10385936128 10712535040 1443518864 14.981 100 87 174 0 1479111520 7186960 28405696
16:59:24 20076 8192000000 10426305856 10753961984 1476431488 15.270 100 93 186 0 1514459904 8230768 29797648
16:59:53 26577 8192000000 10435749824 10766254080 1488727232 15.378 100 90 180 0 1526449808 8789120 28933456
17:00:29 27091 8192000000 10451844288 10785923072 1508478416 15.550 100 94 189 0 1548232960 9816432 29938112
17:01:10 27325 8192000000 10467957712 10809544704 1522147184 15.669 100 87 174 0 1560474144 10721520 27605440
17:01:51 13732 8192000000 10491470224 10839769088 1543027776 15.850 100 78 156 0 1577660640 10827136 23805728
17:02:16 15282 8192000000 10527976928 10876542976 1583734576 16.200 100 86 172 1 1622012704 11988080 26290048
17:02:39 10582 8192000000 10543770528 10895249408 1602307536 16.359 100 90 180 1 1641964368 12470048 27186784
17:03:02 8082 8192000000 10559444048 10915962880 1615438480 16.471 100 77 154 0 1650959104 12821904 22698720
17:03:24 7842 8192000000 10583447728 10944737280 1644360912 16.717 100 82 164 2 1682522896 13506464 24655520
17:03:44 10804 8192000000 10604852784 10973945856 1666072960 16.900 100 79 159 1 1703039488 13064288 23902240
17:04:04 8376 8192000000 10626770576 10995802112 1692196304 17.120 100 86 170 0 1728874464 12017808 24660352
17:04:20 6661 8192000000 10640111520 11010945024 1699955136 17.185 100 75 150 1 1733495296 11584672 21955488
17:04:34 8454 8192000000 10657624064 11029135360 1718574784 17.340 100 84 166 3 1755910880 12298464 25037632
17:04:50 5057 8192000000 10656476800 11034071040 1731380048 17.447 100 78 153 1 1769786976 15631104 22775824
17:05:03 5841 8192000000 10683314000 11061465088 1748389424 17.588 100 79 158 0 1782929040 11537888 23001728
17:05:17 6080 8192000000 10702096960 11080097792 1762684208 17.707 100 80 158 0 1797292832 12209824 22398800
17:05:29 5676 8192000000 10712183568 11092058112 1770372448 17.770 100 81 161 1 1805443984 12459088 22612448
17:05:41 6206 8192000000 10729948368 11103895552 1785543184 17.895 100 83 166 2 1821350512 12974944 22832384
17:05:54 4200 8192000000 10729238624 11108155392 1789172720 17.925 100 88 176 0 1827881280 13761088 24947472
17:06:05 4242 8192000000 10741333456 11120205824 1802825776 18.037 100 90 178 1 1840679776 13474608 24379392
17:06:17 4941 8192000000 10742055120 11123793920 1806867152 18.070 100 90 177 5 1846110704 13923632 25319920
17:06:28 3402 8192000000 10760441888 11138596864 1812322208 18.115 100 94 188 2 1853122592 14560432 26239952
17:06:38 2732 8192000000 10759929184 11139756032 1818954672 18.169 100 90 178 0 1857813504 14382992 24475840
17:06:48 8586 8192000000 10757688624 11142410240 1816273664 18.147 100 84 168 0 1854071024 14849408 22947952
17:07:04 5824 8192000000 10763136928 11146051584 1819995152 18.178 100 86 172 0 1858826752 15105968 23725632
17:07:16 2273 8192000000 10780948176 11162976256 1834301424 18.294 100 95 192 2 1877119360 15719872 27098064
17:07:25 2011 8192000000 10781504768 11165687808 1840274320 18.343 100 89 180 1 1879929344 14431776 25223248
17:07:34 1934 8192000000 10791738848 11174293504 1847602112 18.403 100 93 185 3 1888289664 14115200 26572352
17:07:42 2394 8192000000 10793670288 11175596032 1850320896 18.425 100 92 182 1 1889888288 14452816 25114576
17:07:51 3151 8192000000 10797397264 11187167232 1856980608 18.479 100 89 178 0 1895272240 12460928 25830704
17:08:01 1990 8192000000 10802893328 11188150272 1858720528 18.493 100 97 194 2 1898559168 12845184 26993456
17:08:09 2182 8192000000 10806376928 11194359808 1862821408 18.526 100 96 190 0 1903152416 13898144 26432864
17:08:18 1841 8192000000 10808797904 11195592704 1863540480 18.532 100 89 178 2 1901668576 13024672 25103424
17:08:26 2347 8192000000 10808677776 11194564608 1865530032 18.548 100 94 188 1 1905623184 13687440 26405712
17:08:35 1391 8192000000 10814901056 11199139840 1864994320 18.544 100 91 182 1 1904767648 14013520 25759808
17:08:42 1142 8192000000 10815003056 11200360448 1870537168 18.589 100 98 196 3 1911858192 14174976 27146048
17:08:50 1763 8192000000 10820735456 11208261632 1871273568 18.595 100 99 197 0 1912155024 12465664 28415792
17:08:58 1821 8192000000 10819415456 11207630848 1872291920 18.603 100 90 180 0 1911390176 13122320 25975936
17:09:06 1492 8192000000 10822054000 11211780096 1873238432 18.610 100 88 176 1 1916292400 17801056 25252912
17:09:16 48584 8192000000 10794827680 11201134592 1867724416 18.566 100 60 120 0 1891332064 6708528 16899120
17:10:10 1788 8192000000 10826215200 11215417344 1878595744 18.654 100 89 176 1 1913352544 9124496 25632304
17:10:19 1489 8192000000 10827646848 11218911232 1882939280 18.689 100 96 192 4 1922844576 12222320 27682976
17:10:26 3360 8192000000 10802821264 11213770752 1875570928 18.629 100 54 106 3 1900542272 10936928 14034416
17:10:37 4821 8192000000 10814604304 11217293312 1878039568 18.649 100 58 116 3 1904574960 10445248 16090144
17:10:50 2174 8192000000 10796960512 11213541376 1878458096 18.653 100 47 94 0 1900771424 8984976 13328352
17:10:59 3217 8192000000 10792406368 11215446016 1878217664 18.651 100 39 78 0 1898530656 9650304 10662688
17:11:09 2942 8192000000 10813898704 11225305088 1887429088 18.725 100 53 106 0 1910746272 8981552 14335632
17:11:21 6082 8192000000 10806702272 11226013696 1885230240 18.707 100 39 78 4 1904644112 8996352 10417520
17:11:34 4189 8192000000 10799507632 11221712896 1884858224 18.704 100 35 70 0 1903223264 7588336 10776704
17:11:46 5478 8192000000 10807666960 11225751552 1888585456 18.734 100 49 98 2 1910268384 7434512 14248416
17:12:02 9549 8192000000 10799357696 11222605824 1884046704 18.698 100 22 44 1 1896474176 6275824 6151648
17:12:18 5345 8192000000 10807520416 11222155264 1886097408 18.714 100 33 65 0 1905455472 9159408 10198656
17:12:32 4987 8192000000 10801817456 11221471232 1886185200 18.715 100 31 62 2 1902469440 7561616 8722624
17:12:43 43940 8192000000 10796204912 11225231360 1886964896 18.721 100 21 42 1 1898163072 5129296 6068880
17:13:40 14076 8192000000 10847753856 11246051328 1900921536 18.834 100 78 158 0 1931200768 6265728 24013504
17:14:01 1839 8192000000 10855554416 11251544064 1904630512 18.864 100 90 179 2 1939926144 9369792 25925840
17:14:09 7542 8192000000 10810636720 11242569728 1895294368 18.788 100 40 79 1 1915132608 9381936 10456304
17:14:27 5059 8192000000 10811612096 11239563264 1895598016 18.791 100 34 68 1 1912458528 7038800 9821712
17:14:40 3573 8192000000 10810443456 11239653376 1897478320 18.806 100 45 91 1 1917034672 6394912 13161440
17:14:51 5857 8192000000 10815635040 11242147840 1896446416 18.798 100 30 61 0 1912047312 6814992 8785904
17:15:06 5431 8192000000 10814517440 11248599040 1902871200 18.849 100 27 54 0 1916419808 5527440 8021168
17:15:19 9834 8192000000 10810036656 11240775680 1894318656 18.781 100 21 42 2 1906590960 6253984 6018320
17:15:38 8470 8192000000 10807718032 11244384256 1899590736 18.823 100 23 46 0 1912398848 6298160 6509952
17:15:53 5760 8192000000 10826677840 11249295360 1901015136 18.834 100 29 58 1 1915869600 6025424 8829040
17:16:05 3651 8192000000 10818893104 11249582080 1902721872 18.848 100 32 65 1 1917755760 5925552 9108336
17:16:18 11728 8192000000 10792076448 11215773696 1826527776 18.231 96 13 26 0 1835637664 5212960 3896928
17:16:39 5432 8192000000 10820164816 11230687232 1891262464 18.756 100 47 90 2 1908443248 4331040 12849744
17:16:51 64031 8192000000 10832495392 11250135040 1900315248 18.829 100 36 72 2 1916695360 5745760 10634352
17:18:01 9761 8192000000 10816783376 11244580864 1898403520 18.813 100 33 65 2 1916212368 8512704 9296144
17:18:17 5297 8192000000 10812229600 11247558656 1900143792 18.827 100 31 62 1 1915740640 6388960 9207888
17:18:28 6837 8192000000 10757042016 11188502528 1814989552 18.137 96 20 40 0 1826435712 6207968 5238192
17:18:43 7168 8192000000 10740003872 11168112640 1806888304 18.070 97 29 58 2 1821737312 5787376 9061632
17:18:56 5694 8192000000 10750501248 11175559168 1840850768 18.348 100 28 57 4 1855524320 6003232 8670320
17:19:08 9041 8192000000 10763445088 11191107584 1851279616 18.433 100 23 46 0 1864022528 5538576 7204336
17:19:25 7858 8192000000 10733052064 11153580032 1810800656 18.102 98 27 54 1 1823988848 5394032 7794160
17:19:40 4958 8192000000 10715160368 11135545344 1746073840 17.569 95 39 77 3 1762960432 4880320 12006272
17:19:51 54684 8192000000 10732574656 11148648448 1694120496 17.136 92 43 88 1 1711668704 4860064 12688144
17:20:52 11643 8192000000 10695586432 11115880448 1673715008 16.964 92 23 46 1 1684497648 4881600 5901040
17:21:10 8323 8192000000 10724033728 11125157888 1781163856 17.859 99 29 58 1 1796129888 6489904 8476128
17:21:26 5502 8192000000 10714055072 11118743552 1782899888 17.873 100 34 66 4 1799626512 6090624 10636000
17:21:40 8778 8192000000 10716818496 11132837888 1783034464 17.874 99 28 56 1 1797152784 6143456 7974864
17:21:56 8797 8192000000 10707207760 11118567424 1736277728 17.488 96 32 64 2 1751550560 6035840 9236992
17:22:12 6110 8192000000 10709891152 11120017408 1748369696 17.588 97 28 56 4 1762743744 6610800 7763248
17:22:25 5179 8192000000 10718939680 11126132736 1794949216 17.972 100 43 87 1 1814011216 5397296 13664704
17:22:36 6784 8192000000 10698140752 11105288192 1777711184 17.831 99 23 46 2 1790774480 5561232 7502064
17:22:52 3207 8192000000 10698445856 11107196928 1781113376 17.859 99 28 56 0 1795614336 6488704 8012256
17:23:02 5617 8192000000 10728760272 11147665408 1812086656 18.113 100 31 59 2 1836117696 14605632 9425408
17:23:19 8918 8192000000 10727688864 11144564736 1812739472 18.118 100 16 32 0 1822798992 5600864 4458656
17:23:34 9944 8192000000 10711970672 11137892352 1802207536 18.032 99 21 42 1 1813519552 5544192 5767824
17:23:53 13800 8192000000 10770084832 11172585472 1837005360 18.316 100 47 96 2 1856200464 5320752 13874352
17:24:13 63093 8192000000 10749370784 11173765120 1834987760 18.300 100 25 49 0 1847416448 5181856 7246832
17:25:22 7931 8192000000 10766840656 11187191808 1846895888 18.397 100 27 54 2 1864749328 10399472 7453968
17:25:40 5251 8192000000 10778125056 11199049728 1854803216 18.461 100 37 76 0 1877035680 11666496 10565968
17:25:52 9644 8192000000 10775761824 11194433536 1835610208 18.305 99 22 44 0 1847161968 5274944 6276816
17:26:10 7709 8192000000 10771381104 11199328256 1854542896 18.459 100 27 54 1 1869088528 6677744 7867888
17:26:24 7136 8192000000 10771571040 11203579904 1863447632 18.531 100 30 57 0 1878559376 6653888 8457856
17:26:39 7384 8192000000 10793634432 11210436608 1864896160 18.543 100 28 56 0 1880119664 7015456 8208048
17:26:53 9573 8192000000 10777927344 11207491584 1867550080 18.564 100 22 43 1 1879464224 5491744 6422400
17:27:09 6010 8192000000 10795359264 11215622144 1863629520 18.533 99 21 42 3 1875308112 5984944 5693648
17:27:23 62305 8192000000 10831921136 11249295360 1895833280 18.793 100 42 82 2 1913884816 6021776 12029760
17:28:34 30250 8192000000 10843824032 11265990656 1909084144 18.899 100 45 88 1 1931917648 10136816 12696688
17:29:12 7846 8192000000 10867008224 11279593472 1925752208 19.033 100 54 109 0 1952705648 11280640 15672800
17:29:27 44447 8192000000 10866464768 11290566656 1933708704 19.097 100 57 112 1 1962523136 12206176 16608256
17:30:22 126112 8192000000 10860232432 11310084096 1937009040 19.123 100 27 54 0 1963166384 17673200 8484144
17:32:34 30380 8192000000 10870995648 11310104576 1936821136 19.121 100 15 30 1 1958444096 17250032 4372928
17:33:12 12542 8192000000 10895400608 11323559936 1949638736 19.224 100 49 96 0 1985240608 21615712 13986160
17:33:41 18001 8192000000 10898986384 11333058560 1954845136 19.265 100 37 72 1 1989392736 23264304 11283296
17:34:06 5045 8192000000 10923286160 11341025280 1966050400 19.354 100 59 118 1 2004347776 20278816 18018560
17:34:19 2376 8192000000 10911915248 11331489792 1951576448 19.239 99 66 131 0 1990019808 18935296 19508064
17:34:29 4163 8192000000 10917234224 11343048704 1969954240 19.385 100 65 131 2 2007080640 18825456 18300944
17:34:41 3814 8192000000 10926882080 11347648512 1971976496 19.401 100 66 130 1 2009952560 19515808 18460256
17:34:52 6444 8192000000 10915842368 11335426048 1946783728 19.201 99 73 143 0 1989010112 21324064 20902320
17:35:06 5527 8192000000 10934654240 11343986688 1970654464 19.391 100 78 154 2 2014870112 21753488 22462160
17:35:20 2270 8192000000 10944119392 11354198016 1976710928 19.439 100 78 154 1 2022308096 23418992 22178176
17:35:30 8770 8192000000 10934906560 11354796032 1978495392 19.453 100 76 149 1 2023486112 23613264 21377456
17:35:47 3156 8192000000 10933327520 11354935296 1981735232 19.478 100 81 163 0 2028555776 23214880 23605664
17:35:57 2614 8192000000 10938870240 11356610560 1985577904 19.509 100 83 164 3 2033515904 23968080 23969920
17:36:07 4902 8192000000 10915664544 11343044608 1957643264 19.287 99 71 139 2 1999195744 21925840 19626640
17:36:22 4558 8192000000 10921516816 11346427904 1973759936 19.415 100 55 109 2 2007637536 18566640 15310960
17:36:33 3683 8192000000 10930980720 11356041216 1980339792 19.467 100 66 129 0 2019467696 19891920 19235984
17:36:47 3305 8192000000 10947073840 11366756352 1987745472 19.526 100 79 155 2 2029724256 19241552 22737232
17:37:00 2973 8192000000 10948595488 11367104512 1991018640 19.552 100 72 145 0 2031709312 19114624 21576048
17:37:12 6121 8192000000 10954095648 11376959488 1994436288 19.579 100 72 143 1 2034573712 19481536 20655888
17:37:25 2414 8192000000 10952167264 11375693824 1998882576 19.614 100 83 163 1 2042406704 19502672 24021456
17:37:34 3032 8192000000 10958793184 11376386048 1998556432 19.611 100 76 152 0 2043218544 22154096 22508016
17:37:45 3280 8192000000 10950523696 11371511808 1993054656 19.568 100 79 157 1 2039951136 23311184 23585296
17:37:55 1806 8192000000 10965759136 11376472064 1998040448 19.607 100 80 158 1 2043536336 22858432 22637456
17:38:04 3102 8192000000 10946656576 11371741184 1994594720 19.580 100 78 155 0 2041689376 23605952 23488704
17:38:18 1537 8192000000 10975004080 11386458112 2002417184 19.642 100 98 199 4 2055673440 23885040 29371216
17:38:26 7593 8192000000 10957919504 11386765312 2001964048 19.638 100 77 153 1 2049746048 24959408 22822592
17:38:41 1960 8192000000 10978753760 11393523712 2005607408 19.667 100 83 164 2 2057369200 27885792 23876000
17:38:51 1830 8192000000 10974663424 11396792320 2009383312 19.697 100 86 168 0 2061102256 26574000 25144944
17:39:00 2833 8192000000 10958223120 11383459840 1995491856 19.587 100 78 154 0 2047025040 27778384 23754800
17:39:10 1673 8192000000 10976409552 11393744896 2004027184 19.654 100 86 168 2 2058074128 28009648 26037296
17:39:19 2732 8192000000 10971835072 11392135168 2005875760 19.669 100 81 159 0 2057669776 28787296 23006720
17:39:28 4262 8192000000 10987148272 11404091392 2012148336 19.718 100 88 176 1 2069445104 30914496 26382272
17:39:40 5164 8192000000 10973396992 11387785216 1974270672 19.419 98 89 178 0 2032459584 32153632 26035280
17:39:53 1510 8192000000 10977433792 11397259264 2005231792 19.664 100 79 158 0 2061554512 32048784 24273936
17:40:01 2601 8192000000 10977408480 11397033984 2002220320 19.640 100 85 170 0 2062057840 33700256 26137264
17:40:17 1956 8192000000 10964426432 11390894080 1993808720 19.574 100 82 164 0 2053137136 33988000 25340416
17:40:28 6848 8192000000 10953779232 11383201792 1991072416 19.552 100 68 136 1 2046770400 34127424 21570560
17:40:43 1849 8192000000 10936292400 11354513408 1957070864 19.283 98 74 149 2 2012934160 32827360 23035936
17:40:52 3477 8192000000 10959596112 11374063616 1987539040 19.524 100 83 163 4 2040159520 28054000 24566480
17:41:02 1908 8192000000 10967577504 11385946112 1994876432 19.582 100 84 168 1 2049118640 28959264 25282944
17:41:11 2445 8192000000 10969563456 11382689792 1977399952 19.444 99 87 176 0 2033092304 29637488 26054864
17:41:20 3056 8192000000 10967994432 11384913920 1993655488 19.573 100 84 168 1 2051242864 31948000 25639376
17:41:30 13884 8192000000 10966681520 11394940928 1996847584 19.598 100 68 136 2 2050482400 33066656 20568160
17:41:52 2641 8192000000 10980762352 11398373376 2009491248 19.698 100 89 175 4 2067538496 31406000 26641248
17:42:02 3010 8192000000 10977690288 11401539584 2002682288 19.644 100 79 159 1 2057893968 30309088 24902592
17:42:12 3983 8192000000 10971538160 11400175616 2005120128 19.663 100 69 138 1 2054765104 28935328 20709648
17:42:23 4900 8192000000 10975558736 11403870208 2009185680 19.695 100 70 138 1 2059956624 29582848 21188096
17:42:35 1451 8192000000 10942490784 11359334400 1932136960 19.084 97 85 167 0 1986550752 29797776 24616016
17:42:45 2852 8192000000 10956333488 11374354432 1977784320 19.447 100 87 172 1 2035607792 30966512 26856960
17:42:54 3281 8192000000 10952072048 11380883456 1984334112 19.499 100 70 140 0 2038656560 31998752 22323696
17:43:07 1318 8192000000 10967269632 11380572160 1974566464 19.422 99 93 184 3 2033140896 31058208 27516224
17:43:16 4034 8192000000 10963175184 11384184832 1986312864 19.515 100 73 145 0 2038973616 30643632 22017120
17:43:27 2420 8192000000 10944852128 11365519360 1962098448 19.323 99 84 168 2 2017008288 30621728 24288112
17:43:37 4993 8192000000 10947391136 11368194048 1961210320 19.316 99 84 167 0 2019908000 32187904 26509776
17:43:52 4259 8192000000 10939150944 11358277632 1952627456 19.247 99 78 151 0 2002052336 25784160 23640720
17:44:03 1815 8192000000 10942586400 11359698944 1970536976 19.390 100 80 160 1 2018414544 24437152 23440416
17:44:12 3514 8192000000 10928072144 11352092672 1953566480 19.255 99 72 145 0 2000269744 25686128 21017136
17:44:24 5354 8192000000 10926081616 11358326784 1969288784 19.380 100 61 119 1 2012940272 25446064 18205424
17:44:41 10539 8192000000 10923163664 11363577856 1971472496 19.397 100 33 66 0 2004786224 22977536 10336192
17:45:04 3883 8192000000 10928558272 11351351296 1950152416 19.228 99 62 122 1 1991881248 23207792 18521040
17:45:15 9603 8192000000 10899577360 11341418496 1934042544 19.099 99 40 80 2 1970255696 24041280 12171872
17:45:31 11684 8192000000 10918037216 11350310912 1960724928 19.312 100 38 76 3 1997413568 24293136 12395504
17:45:54 3818 8192000000 10912302544 11336159232 1953568160 19.255 100 69 138 2 2000902384 26372352 20961872
17:46:05 4286 8192000000 10892236640 11320438784 1927719552 19.049 99 58 116 0 1974828288 29263344 17845392
17:46:16 11074 8192000000 10877142208 11315109888 1912337680 18.925 99 28 56 2 1946579360 24646528 9595152
17:46:38 7490 8192000000 10909025232 11342524416 1949208784 19.220 100 41 78 1 1987593520 26095104 12289632
17:46:56 3216 8192000000 10932852496 11349295104 1962901296 19.329 100 90 181 1 2016006560 26302848 26802416
17:47:06 5477 8192000000 10910481808 11345838080 1952167056 19.244 100 53 105 1 1994817648 26811024 15839568
17:47:19 14049 8192000000 10893836528 11337236480 1933117968 19.092 99 30 58 2 1969159232 26853104 9188160
17:47:54 22117 8192000000 10873145392 11322589184 1903249440 18.852 98 20 40 1 1939074976 28860192 6965344
17:48:23 5633 8192000000 10880934496 11313078272 1923057392 19.011 99 42 82 1 1964257584 27877520 13322672
17:48:36 7706 8192000000 10900564608 11331694592 1921833280 19.002 99 51 100 3 1967809360 29625648 16350432
17:48:52 3920 8192000000 10910242064 11329028096 1937853808 19.130 100 66 133 2 1989087600 30973280 20260512
17:49:06 20636 8192000000 10874400976 11330560000 1934105168 19.100 100 23 46 0 1966953552 26048624 6799760
17:49:33 13569 8192000000 10889909328 11323637760 1925960080 19.035 99 32 64 3 1956051488 19995216 10096192
17:49:56 4331 8192000000 10892572464 11318988800 1914993664 18.947 98 70 139 5 1957494016 20564672 21935680
17:50:07 4157 8192000000 10908196608 11331698688 1927625072 19.048 99 73 146 1 1976323904 25891696 22807136
17:50:18 2856 8192000000 10951006192 11359555584 1963286016 19.332 100 86 172 1 2020524848 30481536 26757296
17:50:27 2593 8192000000 10930299872 11348971520 1937137088 19.124 99 73 148 0 1991084560 31794896 22152576
17:50:39 7213 8192000000 10906040160 11334127616 1937548864 19.127 100 44 88 3 1984553120 33004736 13999520
17:50:54 10388 8192000000 10891637152 11326423040 1932909344 19.090 100 27 54 2 1970380128 28705520 8765264
17:51:17 17154 8192000000 10901384944 11342462976 1948250832 19.213 100 30 59 2 1985092208 27053888 9787488
17:51:46 12593 8192000000 10881429456 11331239936 1909701632 18.904 98 26 51 0 1945831456 27904272 8225552
17:52:05 9314 8192000000 10897972720 11329568768 1923094896 19.012 99 33 67 1 1958504176 25170992 10238288
17:52:26 2994 8192000000 10925251008 11348541440 1953261376 19.252 100 73 144 3 2005838816 29593968 22983472
17:52:36 7496 8192000000 10921664400 11355344896 1957552256 19.287 100 50 100 5 2004106304 31431936 15122112
17:52:52 4846 8192000000 10900484544 11333107712 1931856576 19.082 99 45 90 0 1977989008 31297120 14835312
17:53:06 12246 8192000000 10902273952 11336744960 1928721312 19.057 99 27 54 1 1967940624 30479744 8739568
17:53:33 20083 8192000000 10914819680 11352637440 1950065952 19.227 100 24 48 1 1992110912 33559072 8485888
17:54:11 18614 8192000000 10889309056 11333926912 1906985024 18.882 98 28 56 1 1951511216 34954624 9571568
17:54:37 18299 8192000000 10884352240 11316080640 1907401744 18.886 99 29 56 0 1953499232 35861744 10235744
17:55:03 6641 8192000000 10904430512 11334062080 1931309856 19.077 100 40 80 3 1984178256 39459024 13409376
17:55:19 35075 8192000000 10891274512 11337900032 1909959392 18.906 99 27 54 1 1962414240 42884160 9570688
17:56:02 15192 8192000000 10893168064 11338948608 1925671152 19.032 100 24 48 2 1975803984 41829776 8303056
17:56:31 27268 8192000000 10870810896 11313700864 1901651456 18.840 99 29 59 3 1952387824 40638272 10098096
17:57:16 27582 8192000000 10874645168 11321516032 1894634864 18.783 99 26 52 0 1946247632 42128304 9484464
17:57:51 40240 8192000000 10887566880 11324579840 1914518336 18.943 100 26 52 1 1964035360 40674688 8842336
17:58:39 28452 8192000000 10899925504 11319300096 1918950848 18.978 99 62 124 5 1959683088 23452656 17279584
17:59:14 4452 8192000000 10897589728 11328180224 1949724880 19.224 100 64 129 3 1984816240 16660592 18430768
17:59:28 12448 8192000000 10899114048 11334590464 1950375072 19.229 100 57 115 0 1984728704 18173296 16180336
18:00:17 46645 8192000000 10913418000 11342323712 1934047264 19.099 99 25 47 1 1951611232 11213376 6350592
18:01:10 50164 8192000000 10902348128 11347996672 1965436144 19.349 100 28 56 1 1984717136 11103184 8177808
18:02:37 70068 8192000000 10887506608 11357208576 1963082816 19.331 100 13 25 2 1982279904 15455216 3741872
18:03:54 58728 8192000000 10892450736 11357577216 1945781392 19.193 99 10 20 1 1962032224 12944864 3305968
18:05:16 108923 8192000000 10921161856 11358629888 1956403456 19.277 99 26 53 1 1975264176 11217776 7642944
18:07:17 39144 8192000000 10889051968 11334270976 1953767328 19.256 99 15 30 0 1964388880 7000160 3621392
18:08:05 19411 8192000000 10903573360 11356033024 1975664192 19.430 100 38 76 1 1994402816 8266048 10472576
18:08:39 41670 8192000000 10903740704 11367698432 1977216576 19.443 100 18 36 0 1991776976 9080240 5480160
18:09:28 54920 8192000000 10914722896 11371245568 1984093392 19.497 100 16 32 2 1998946640 10045312 4807936
18:10:33 30429 8192000000 10930083680 11385794560 1990407424 19.547 100 28 57 2 2010893104 12303312 8182368
18:12:06 74221 8192000000 10925019296 11380858880 1996861024 19.598 100 36 72 1 2015498128 8231792 10405312
18:13:35 9054 8192000000 10958947344 11396849664 2006801072 19.676 100 54 106 1 2029577376 7645408 15130896
18:13:52 107386 8192000000 10912264208 11377090560 1922994896 19.011 96 20 40 2 1943145200 14765168 5385136
18:15:56 43717 8192000000 10919893728 11385249792 1987415328 19.523 100 30 60 2 2014365168 18138928 8810912
18:16:53 85376 8192000000 10943043376 11409199104 2009995568 19.701 100 26 52 0 2036275152 18578944 7700640
18:18:25 34229 8192000000 10937001312 11388813312 1986341344 19.515 99 43 86 1 2021674016 22146032 13186640
18:19:06 29054 8192000000 10941404272 11402227712 1982510176 19.485 99 30 60 1 2016846800 24936304 9400320
18:19:45 13269 8192000000 10949341328 11408859136 2001944224 19.638 100 29 58 1 2039228192 28437456 8846512
18:20:15 27469 8192000000 10947415040 11415416832 2004835632 19.661 100 39 77 2 2045326416 28117168 12373616
18:20:53 54337 8192000000 10941797008 11414523904 1997697344 19.605 100 24 48 1 2036363088 31081504 7584240
18:22:01 57807 8192000000 10925643984 11410255872 1969522032 19.382 99 11 22 0 2004772384 31423792 3826560
18:23:05 35461 8192000000 10888020304 11372490752 1903598000 18.855 96 12 25 1 1941115728 33378000 4139728
18:23:48 44814 8192000000 10897793904 11379691520 1954116224 19.259 100 16 32 1 1989262368 29823680 5322464
18:24:43 80233 8192000000 10881947776 11386343424 1915913312 18.954 98 13 24 1 1940059008 20944208 3201488
18:26:10 89951 8192000000 10876711600 11342348288 1900904160 18.834 97 18 36 0 1918640512 12804544 4931808
18:27:46 52846 8192000000 10898107408 11356397568 1929398784 19.062 98 30 61 2 1948965296 11191872 8374640
18:28:46 26731 8192000000 10908945648 11353935872 1964086672 19.339 100 55 110 3 1991442016 11366352 15988992
18:29:20 67407 8192000000 10875184224 11353214976 1908152016 18.892 97 36 72 1 1935109552 16966416 9991120
18:30:34 92201 8192000000 10870657872 11351199744 1890246464 18.748 97 11 22 0 1905840512 12753920 2840128
18:32:12 97588 8192000000 10850214224 11308146688 1812817200 18.119 93 7 14 0 1830404896 15876864 1710832
18:34:01 29273 8192000000 10856557920 11302842368 1866351616 18.555 96 38 77 2 1884613856 7962000 10300240
18:34:36 26733 8192000000 10884235632 11329388544 1911075904 18.915 99 36 72 1 1935619920 14140448 10403568
18:35:09 59526 8192000000 10872610064 11338743808 1902579552 18.847 98 11 22 0 1915278624 10061456 2637616
18:36:15 89600 8192000000 10888881856 11342647296 1920122992 18.988 98 11 22 1 1933065888 9860208 3082688
18:37:56 9231 8192000000 10905347120 11355295744 1964975888 19.346 100 46 92 1 1987208736 9202768 13030080
18:38:15 23266 8192000000 10888581744 11344601088 1923945904 19.018 98 37 74 0 1947787536 13521296 10320336
18:38:46 47955 8192000000 10872865216 11350405120 1904875504 18.865 97 21 42 0 1923214384 12721328 5617552
18:39:49 85854 8192000000 10861969088 11330392064 1884918656 18.705 97 23 46 1 1904989648 13612880 6458112
18:41:21 104915 8192000000 10872616416 11350589440 1916535584 18.959 99 22 44 0 1934006176 11095344 6375248
18:43:21 79804 8192000000 10862850144 11319443456 1908719088 18.896 98 26 53 0 1929255424 13188768 7347568
18:44:48 46015 8192000000 10888899936 11336568832 1907328592 18.885 98 29 58 2 1925016624 9154624 8533408
18:45:41 41838 8192000000 10850031632 11309449216 1876250864 18.635 97 16 31 0 1889414624 8510960 4652800
18:46:36 92900 8192000000 10866989296 11340890112 1883631600 18.694 97 12 24 1 1900197104 13281200 3284304
18:48:31 76256 8192000000 10855828112 11335593984 1919112144 18.980 99 13 26 0 1939588976 16538672 3938160
18:50:08 46958 8192000000 10854511328 11331072000 1930490336 19.071 100 11 21 0 1945887872 12416880 2980656
18:51:06 70782 8192000000 10837499936 11306541056 1856964528 18.479 96 8 16 1 1869864480 10194608 2705344
18:53:13 80930 8192000000 10857172144 11327938560 1861258304 18.513 96 21 42 2 1883207264 14931088 7017872
18:54:53 83526 8192000000 10871779632 11343163392 1882275904 18.683 97 10 20 1 1899840160 15045296 2518960
18:56:22 70829 8192000000 10887213664 11343556608 1902341168 18.845 98 13 26 0 1920530304 14978816 3210320
18:57:42 41443 8192000000 10884423856 11347136512 1936916240 19.122 99 27 55 3 1953751056 9606016 7228800
18:58:43 38852 8192000000 10876595648 11347062784 1921822816 19.001 98 21 42 0 1938678912 10897328 5958768
18:59:28 34426 8192000000 10892893232 11357466624 1940266336 19.149 99 27 53 1 1956430048 8628256 7535456
19:00:14 94985 8192000000 10897352240 11386212352 1952977744 19.250 99 19 38 1 1974454272 15879312 5597216
19:01:55 65780 8192000000 10905335200 11379167232 1971477056 19.397 100 16 32 1 1989563152 13679216 4406880
19:03:10 59550 8192000000 10936218880 11410444288 1966995968 19.362 99 25 48 1 1990830112 16879824 6954320
19:04:18 91691 8192000000 10936535104 11397185536 1967561504 19.366 99 14 28 1 1992082016 20209664 4310848
19:06:01 75612 8192000000 10923734416 11409682432 1989937440 19.543 100 17 34 2 2016020880 21048848 5034592
19:07:29 162282 8192000000 10903964704 11372691456 1909947168 18.906 96 10 20 0 1928909104 16248928 2713008
19:11:33 61362 8192000000 10911834672 11379732480 1980482272 19.469 100 29 58 2 1997419968 8517424 8420272
19:12:55 36120 8192000000 10874076560 11344957440 1923691408 19.016 97 37 74 1 1943597744 9217200 10689136
19:13:38 35152 8192000000 10868211792 11346927616 1937166160 19.124 99 29 58 1 1953592656 7785392 8641104
19:14:25 78051 8192000000 10873553472 11358486528 1901411664 18.838 97 19 38 0 1919530672 12866944 5252064
19:15:49 66573 8192000000 10889135200 11358076928 1941319040 19.157 99 25 50 2 1966850848 18736304 6795504
19:17:07 55197 8192000000 10872649440 11351539712 1920948528 18.994 98 23 46 1 1940778480 13618144 6211808
19:18:46 64648 8192000000 10847464592 11330764800 1873774304 18.615 96 15 30 0 1896668608 18755344 4138960
19:19:59 21702 8192000000 10858740288 11321753600 1910150176 18.908 99 13 27 2 1926030880 12045920 3834784
19:20:30 94057 8192000000 10855257872 11336785920 1899294944 18.821 98 20 40 0 1914095584 9281056 5519584
19:22:14 34002 8192000000 10848882784 11317862400 1857877216 18.486 96 21 43 0 1876055616 12679856 5498544
19:22:58 38401 8192000000 10834630528 11325222912 1913588208 18.935 100 3 6 0 1926521312 12256992 676112
19:23:43 44862 8192000000 10834929104 11327873024 1900530464 18.831 99 7 14 0 1914616000 12247248 1838288
19:24:35 55951 8192000000 10846440912 11330228224 1902261808 18.844 99 7 14 0 1920432496 15913440 2257248
19:25:37 44819 8192000000 10840782768 11309625344 1855403552 18.466 96 8 15 1 1866335088 8350416 2581120
19:26:29 15287 8192000000 10858833840 11310436352 1877866480 18.648 97 44 88 1 1897479696 6810736 12802480
19:26:52 26631 8192000000 10866710496 11321442304 1898129264 18.811 98 48 96 0 1925354752 13847536 13377952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 16-03-2021 19:28:52 to 16-03-2021 19:29:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 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 16-03-2021 19:29:26 to 16-03-2021 19:29:28.

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          234140
MON$OLDEST_ACTIVE               236455
MON$OLDEST_SNAPSHOT             236455
MON$NEXT_TRANSACTION            236455
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                       2050464
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:147: 
:148: mscs-test-161.budzdorov.ru    Tue Mar 16 19:27:30 2021
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
--- end of diff output ---

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

16.03.21 19:29:29. 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-03-16 19:29:32 No severe PSQL-related problems occured
16.03.21 19:29:33. End of report.