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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-12 22:27:19
DTS_END                         2021-02-12 22:27:19.1610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49118
TRN_ID                          242039
ATT_ID                          693
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: 9032.65 22717 1083918
customer order: creation 174.42 380 20930
customer order: refuse 14.32 354 1718
order to supplier: creation 46.25 1365 5550
order to supplier: removal 3.50 93753 420
invoice (draft): creation 47.09 3883 5651
invoice (draft): removal 50.21 776 6025
invoice accept: apply 41.91 18468 5029
invoice accept: cancel 45.84 850 5501
customer reserve: creation 3819.72 185 458366
customer reserve: removal 4495.77 57 539492
realization accept: apply 85.26 182 10231
realization accept: cancel 77.53 111 9304
payment from customer: creation 59.60 128 7152
payment from customer: removal 5.53 86 664
payment to supplier: creation 49.30 145 5916
payment to supplier: removal 3.66 75 439
service: total inventory turnovers 4.82 1249 578
service: total monetary turnovers 6.96 40 835
service: aggregate perf. data 0.94 18502 113
service: refresh index statistics 0.03 313751 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-02-2021 22:28:39 to 12-02-2021 22:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11570
TEST_TIME 2 8076
TEST_TIME 3 7093
TEST_TIME 4 6981
TEST_TIME 5 6861
TEST_TIME 6 6495
TEST_TIME 7 6552
TEST_TIME 8 6625
TEST_TIME 9 6534
TEST_TIME 10 6542
TEST_TIME 11 6437
TEST_TIME 12 6465
TEST_TIME 13 6570
TEST_TIME 14 6624
TEST_TIME 15 6753
TEST_TIME 16 7298
TEST_TIME 17 7357
TEST_TIME 18 7568
TEST_TIME 19 7807
TEST_TIME 20 8174
TEST_TIME 21 8411
TEST_TIME 22 9038
TEST_TIME 23 9064
TEST_TIME 24 9063
TEST_TIME 25 9172
TEST_TIME 26 9201
TEST_TIME 27 9374
TEST_TIME 28 9570
TEST_TIME 29 9963
TEST_TIME 30 10792
TEST_TIME 31 10524
TEST_TIME 32 10369
TEST_TIME 33 10223
TEST_TIME 34 10175
TEST_TIME 35 10054
TEST_TIME 36 10120
TEST_TIME 37 10020
TEST_TIME 38 9845
TEST_TIME 39 9766
TEST_TIME 40 9641
TEST_TIME 41 9569
TEST_TIME 42 9735
TEST_TIME 43 9594
TEST_TIME 44 9503
TEST_TIME 45 9397
TEST_TIME 46 9395
TEST_TIME 47 9295
TEST_TIME 48 9169
TEST_TIME 49 9109
TEST_TIME 50 9097
TEST_TIME 51 9179
TEST_TIME 52 9072
TEST_TIME 53 9014
TEST_TIME 54 8986
TEST_TIME 55 8868
TEST_TIME 56 8761
TEST_TIME 57 8948
TEST_TIME 58 8931
TEST_TIME 59 8903
TEST_TIME 60 8783
TEST_TIME 61 8728
TEST_TIME 62 8645
TEST_TIME 63 8759
TEST_TIME 64 8815
TEST_TIME 65 8759
TEST_TIME 66 8862
TEST_TIME 67 8917
TEST_TIME 68 8943
TEST_TIME 69 8989
TEST_TIME 70 8990
TEST_TIME 71 9046
TEST_TIME 72 9246
TEST_TIME 73 9290
TEST_TIME 74 9319
TEST_TIME 75 9338
TEST_TIME 76 9431
TEST_TIME 77 9422
TEST_TIME 78 9333
TEST_TIME 79 9298
TEST_TIME 80 9272
TEST_TIME 81 9269
TEST_TIME 82 9246
TEST_TIME 83 9225
TEST_TIME 84 9248
TEST_TIME 85 9201
TEST_TIME 86 9184
TEST_TIME 87 9129
TEST_TIME 88 9068
TEST_TIME 89 9094
TEST_TIME 90 9118
TEST_TIME 91 9089
TEST_TIME 92 9067
TEST_TIME 93 9122
TEST_TIME 94 9140
TEST_TIME 95 9126
TEST_TIME 96 9162
TEST_TIME 97 9185
TEST_TIME 98 9155
TEST_TIME 99 9206
TEST_TIME 100 9287
TEST_TIME 101 9260
TEST_TIME 102 9262
TEST_TIME 103 9268
TEST_TIME 104 9285
TEST_TIME 105 9253
TEST_TIME 106 9196
TEST_TIME 107 9175
TEST_TIME 108 9164
TEST_TIME 109 9095
TEST_TIME 110 9059
TEST_TIME 111 9098
TEST_TIME 112 9095
TEST_TIME 113 9107
TEST_TIME 114 9069
TEST_TIME 115 9095
TEST_TIME 116 9069
TEST_TIME 117 9079
TEST_TIME 118 9052
TEST_TIME 119 9071
TEST_TIME 120 9037

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-02-2021 22:28:42 to 12-02-2021 22:28:46.

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 1510031 1510031 0 0.00 0 15094 6 0 0
doc_list_biud 1510029 1510029 0 0.00 0 63216 26 0 0
sp_add_invoice_to_stock 5152 5029 123 2.38 54 214596 18468 0 123
sp_cancel_adding_invoice 5501 5501 0 0.00 5 57087 850 0 0
sp_cancel_client_order 1718 1718 0 0.00 4 15133 355 0 0
sp_cancel_customer_reserve 539492 539492 0 0.00 1 21847 58 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 3 6768 86 0 0
sp_cancel_pay_to_supplier 439 439 0 0.00 3 2999 76 0 0
sp_cancel_supplier_invoice 6034 6025 9 0.14 2 63221 777 0 9
sp_cancel_supplier_order 420 420 0 0.00 5 980886 93754 0 0
sp_cancel_write_off 9304 9304 0 0.00 1 12212 112 0 0
sp_client_order 20930 20930 0 0.00 4 19903 381 0 0
sp_customer_reserve 458366 458366 0 0.00 0 50139 185 0 0
sp_fill_shopping_cart 32119 32119 0 0.00 1 27811 46 0 0
sp_fill_shopping_cart_clo_res 458361 458361 0 0.00 0 11795 14 0 0
sp_get_clo_for_invoice 5023 5023 0 0.00 0 22843 293 0 0
sp_kill_cost_storno 15908 15908 0 0.00 0 6872 54 0 0
sp_kill_qstorno_ret_qs2qd 1094733 1094733 0 0.00 0 63213 31 0 0
sp_kill_qty_storno 577713 577713 0 0.00 0 63214 68 0 0
sp_lock_selected_doc 21013 21013 0 0.00 0 6759 4 0 0
sp_make_cost_storno 28321 28321 0 0.00 0 13994 57 0 0
sp_multiply_rows_for_pdistr 28321 28321 0 0.00 0 8958 29 0 0
sp_multiply_rows_for_qdistr 20930 20930 0 0.00 0 13113 157 0 0
sp_pay_from_customer 7152 7152 0 0.00 4 16439 128 0 0
sp_pay_to_supplier 5916 5916 0 0.00 4 12089 145 0 0
sp_payment_common 13068 13068 0 0.00 1 11598 35 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 15123 309 0 0
sp_qd_handle_on_invoice_upd_sts 10524 10524 0 0.00 0 13337 333 0 0
sp_qd_handle_on_reserve_upd_sts 10230 10230 0 0.00 0 10628 54 0 0
sp_reserve_write_off 10231 10231 0 0.00 6 17187 183 0 0
sp_supplier_invoice 5651 5651 0 0.00 6 105394 3884 0 0
sp_supplier_order 5550 5550 0 0.00 6 67657 1365 0 0
srv_aggregate_perf_data 113 113 0 0.00 2222 218709 18503 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1151 145449 31418 0 0
srv_find_qd_qs_mism 1036792 1036792 0 0.00 0 15093 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 36 181094 1250 0 0
srv_make_money_saldo 835 835 0 0.00 1 12214 41 0 0
srv_recalc_idx_stat 4 4 0 0.00 74737 493498 313751 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5029 5029 0 0.00 0 17325 185 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 0 20655 103 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 5221 19 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 3380 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 589 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 439 439 0 0.00 0 573 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 4627 33 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 23313 1478 0 0
t$perf-norm:sp_cancel_write_off 1012 1012 0 0.00 0 1109 6 0 0
t$perf-norm:sp_client_order 20930 20930 0 0.00 0 23102 24 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 10209 18 0 0
t$perf-norm:sp_pay_from_customer 7152 7152 0 0.00 0 10612 11 0 0
t$perf-norm:sp_pay_to_supplier 5916 5916 0 0.00 0 16260 14 0 0
t$perf-norm:sp_reserve_write_off 10231 10231 0 0.00 0 16254 16 0 0
t$perf-norm:sp_supplier_invoice 5651 5651 0 0.00 0 12047 24 0 0
t$perf-norm:sp_supplier_order 5550 5550 0 0.00 0 16103 19 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 752 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 3733 31 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 5012 31 0 0
t$perf-norm:srv_make_money_saldo 835 835 0 0.00 0 5430 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10292 10046 246 2.39 0 6840 25 0 246
v_all_customers 38154 38154 0 0.00 0 18 1 0 0
v_all_suppliers 30744 30744 0 0.00 0 15 1 0 0
v_all_wares 41860 41860 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 628 9 0 0
v_cancel_client_order 3436 3436 0 0.00 0 5388 11 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 2753 10 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 4459 7 0 0
v_cancel_payment_to_supplier 878 878 0 0.00 0 2970 7 0 0
v_cancel_supplier_invoice 762 744 18 2.36 0 4982 21 0 18
v_cancel_supplier_order 840 840 0 0.00 0 7684 26 0 0
v_cancel_write_off 2024 2024 0 0.00 0 4752 21 0 0
v_max_id_clo_ord 5550 5550 0 0.00 0 1266 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 2324 17 0 0
v_max_id_ord_sup 5638 5638 0 0.00 0 6018 5 0 0
v_max_non_paid_invoice 1732 1732 0 0.00 0 1496 5 0 0
v_max_non_paid_realizn 3875 3875 0 0.00 0 3360 6 0 0
v_min_id_clo_ord 5550 5550 0 0.00 0 11717 10 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 6515 13 0 0
v_min_id_ord_sup 5638 5638 0 0.00 0 4757 8 0 0
v_min_non_paid_invoice 5916 5916 0 0.00 0 9594 23 0 0
v_min_non_paid_realizn 7152 7152 0 0.00 0 11591 26 0 0
v_our_firm 10260 10260 0 0.00 0 18 1 0 0
v_reserve_write_off 20460 20460 0 0.00 0 6756 10 0 0
x_lock_depdocs_on_canc_invoice 11154 11154 0 0.00 0 12903 123 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 12400 372 0 0
x_make_qstorno_1000_1200 5550 5550 0 0.00 1 67648 1271 0 0
x_make_qstorno_1200_2000 5651 5651 0 0.00 3 105376 3722 0 0
x_make_qstorno_2100_3300 458366 458366 0 0.00 0 50138 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-02-2021 22:28:47 to 12-02-2021 22:28:51.

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
19:57:23 8 8192000000 8805050912 8817512448 10197552 0.124 3 1 2 0 10316928 56816 62560
19:57:29 24897 8192000000 10308761952 10622779392 1299468720 13.690 100 77 153 2 1328682688 3650896 25563072
19:58:03 38408 8192000000 10376732880 10697011200 1416784960 14.744 100 85 170 0 1450549488 5995792 27768736
19:58:50 26320 8192000000 10403251024 10726486016 1453668304 15.070 100 89 176 1 1489650384 6972432 29009648
19:59:36 35142 8192000000 10433573488 10764718080 1483660800 15.333 100 90 180 0 1521481904 8740816 29080288
20:00:21 25077 8192000000 10443782144 10779504640 1501192288 15.487 100 89 178 0 1539218800 9224736 28801776
20:00:57 16885 8192000000 10468525552 10807390208 1513112016 15.590 100 83 166 0 1549008672 9028960 26867696
20:01:25 19500 8192000000 10482705952 10830069760 1546751200 15.882 100 82 164 2 1581930784 9100384 26079200
20:01:53 10529 8192000000 10511274128 10859831296 1568604752 16.070 100 78 156 0 1602382416 9770032 24007632
20:02:17 16786 8192000000 10545360576 10901237760 1597795184 16.321 100 80 160 1 1632404992 10583376 24026432
20:02:45 11370 8192000000 10567838368 10930274304 1624545728 16.549 100 76 150 2 1657503776 10767776 22190272
20:03:03 8380 8192000000 10590520880 10950029312 1642499760 16.701 100 75 150 0 1675815664 11112112 22203792
20:03:21 9536 8192000000 10609685552 10977042432 1662360672 16.869 100 72 144 1 1694551936 11479568 20711696
20:03:40 8235 8192000000 10617374848 10984869888 1681143136 17.027 100 76 152 0 1715123152 12184672 21795344
20:03:57 7854 8192000000 10635457616 11002798080 1695601856 17.148 100 79 158 1 1730592368 12236976 22753536
20:04:13 11434 8192000000 10657038400 11027570688 1708779584 17.259 100 77 154 4 1743891008 12866848 22244576
20:04:31 8852 8192000000 10660547968 11038732288 1721164896 17.362 100 70 140 1 1753300176 11994736 20140544
20:04:47 6641 8192000000 10678135248 11053940736 1735284256 17.479 100 77 154 2 1773067344 16916048 20867040
20:05:01 6153 8192000000 10698654048 11078860800 1754017024 17.635 100 78 154 2 1788579984 12832208 21730752
20:05:15 5477 8192000000 10704813344 11080515584 1765086144 17.726 100 83 165 2 1802410800 13538912 23785744
20:05:27 4029 8192000000 10704496608 11085262848 1769630384 17.764 100 81 162 2 1805181584 13348304 22202896
20:05:38 4171 8192000000 10717641568 11098980352 1773397408 17.795 100 77 152 0 1807843232 13067168 21378656
20:05:49 8558 8192000000 10705728096 11096322048 1776677920 17.822 100 65 130 0 1808039424 12802704 18558800
20:06:04 3632 8192000000 10736288912 11120201728 1794994000 17.973 100 78 156 0 1828971424 12066864 21910560
20:06:14 2926 8192000000 10740083760 11125760000 1799938624 18.013 100 76 152 0 1833505568 12100960 21465984
20:06:24 4835 8192000000 10753262176 11137458176 1811024000 18.104 100 85 170 0 1848178560 12823504 24331056
20:06:36 2838 8192000000 10744248816 11135881216 1811325536 18.107 100 70 140 1 1843391664 12342176 19723952
20:06:46 2682 8192000000 10765158624 11151613952 1824341792 18.213 100 89 178 0 1862819552 13495488 24982272
20:06:55 2713 8192000000 10771447664 11156439040 1830078080 18.260 100 91 180 0 1868698288 13084512 25535696
20:07:05 2628 8192000000 10774034672 11160068096 1834894080 18.299 100 91 182 1 1872030432 11449280 25687072
20:07:14 3172 8192000000 10776913728 11161444352 1839027184 18.333 100 89 177 0 1877623664 12837088 25759392
20:07:24 2056 8192000000 10783497936 11170508800 1843688560 18.371 100 91 182 0 1882953680 13037872 26227248
20:07:32 2303 8192000000 10789970480 11175055360 1844116880 18.374 100 90 180 0 1883946608 14360176 25469552
20:07:41 3279 8192000000 10785303600 11173818368 1847445456 18.401 100 85 167 0 1882865536 12099792 23320288
20:07:51 3880 8192000000 10785834080 11181039616 1848256528 18.408 100 84 169 1 1884599232 13395424 22947280
20:08:02 3749 8192000000 10795007392 11179995136 1849653152 18.419 100 85 172 2 1886933792 13147728 24132912
20:08:12 2080 8192000000 10802252096 11187802112 1856967280 18.479 100 89 175 0 1894167696 12617376 24583040
20:08:20 1638 8192000000 10804826160 11192496128 1859834880 18.502 100 93 187 2 1899707680 13701296 26171504
20:08:28 1140 8192000000 10804619632 11192557568 1866957120 18.560 100 93 188 1 1906066928 13590864 25518944
20:08:36 3438 8192000000 10792262208 11195015168 1862713472 18.525 100 67 132 0 1892394496 11324368 18356656
20:08:47 9326 8192000000 10795535760 11189477376 1860129568 18.504 100 72 144 0 1892166256 10604272 21432416
20:09:03 1418 8192000000 10795870704 11194904576 1862585344 18.524 100 71 142 0 1895187472 12399040 20203088
20:09:14 3499 8192000000 10806644480 11202785280 1866120032 18.553 100 65 130 1 1895515248 10989840 18405376
20:09:24 1985 8192000000 10795950976 11200655360 1870123536 18.585 100 68 136 2 1901464624 11606080 19735008
20:09:33 1773 8192000000 10812196512 11207086080 1873217408 18.610 100 80 160 2 1907946496 12334320 22394768
20:09:42 3553 8192000000 10813787248 11214245888 1881533376 18.677 100 76 151 2 1914039424 12087152 20418896
20:09:52 20960 8192000000 10804251008 11204648960 1877330816 18.644 100 67 134 2 1906652864 10268640 19053408
20:10:19 17986 8192000000 10783474800 11202895872 1872861792 18.607 100 39 76 4 1890666112 6713904 11090416
20:10:43 5553 8192000000 10790701280 11214004224 1880142496 18.666 100 46 92 2 1901250848 7445072 13663280
20:10:59 3570 8192000000 10804308384 11213557760 1883274112 18.692 100 46 93 0 1901827616 4831744 13721760
20:11:10 4565 8192000000 10800874720 11222093824 1885304512 18.708 100 30 60 2 1900282672 6497760 8480400
20:11:23 4643 8192000000 10797143968 11225739264 1886132704 18.715 100 26 52 1 1900763184 7665072 6965408
20:11:35 5290 8192000000 10809014128 11228155904 1888766400 18.736 100 34 68 0 1905907360 7310304 9830656
20:11:47 4853 8192000000 10802996288 11229913088 1891238016 18.756 100 32 64 1 1907299248 7232800 8828432
20:11:59 9303 8192000000 10802645520 11237285888 1892068784 18.762 100 21 42 1 1904656736 7049696 5538256
20:12:16 9291 8192000000 10803321216 11236356096 1899426800 18.822 100 28 56 0 1914491952 7431776 7633376
20:12:35 5055 8192000000 10805395408 11236999168 1899657920 18.824 100 23 46 1 1912430192 5589616 7182656
20:12:48 8184 8192000000 10803546560 11240767488 1898899568 18.817 100 19 37 4 1909903408 5501552 5502288
20:13:03 5281 8192000000 10799903904 11239026688 1900189456 18.828 100 18 36 1 1911363344 6451344 4722544
20:13:17 20938 8192000000 10807856656 11245449216 1902000848 18.842 100 26 52 2 1915608608 6448304 7159456
20:14:13 20457 8192000000 10847858880 11256479744 1910951360 18.914 100 67 134 1 1937201616 6180544 20069712
20:14:40 4915 8192000000 10821285552 11254575104 1908247760 18.893 100 41 82 2 1929777328 9983072 11546496
20:14:53 5831 8192000000 10826230208 11257282560 1908984672 18.898 100 34 70 3 1925523248 6668592 9869984
20:15:09 4669 8192000000 10819490256 11246587904 1889552624 18.742 99 34 68 1 1906384592 7200544 9631424
20:15:21 3725 8192000000 10841989264 11267616768 1912379056 18.926 100 36 72 1 1933805280 11488800 9937424
20:15:31 5173 8192000000 10834033232 11266154496 1915898592 18.954 100 41 82 1 1934966256 7753232 11314432
20:15:43 7407 8192000000 10838143632 11268796416 1917423872 18.966 100 32 61 3 1933607904 6733728 9450304
20:15:59 7765 8192000000 10835818496 11268333568 1919570352 18.983 100 18 36 3 1929183344 4619392 4993600
20:16:15 6772 8192000000 10834086224 11274801152 1924313296 19.021 100 30 59 2 1937646128 5919712 7413120
20:16:28 4708 8192000000 10841237024 11267678208 1918381200 18.974 100 37 72 2 1935871728 6843456 10647072
20:16:40 44304 8192000000 10830812544 11256168448 1864280224 18.538 97 26 51 0 1877535120 4871568 8383328
20:17:31 17498 8192000000 10814734880 11243048960 1855957904 18.470 97 44 86 2 1879451744 11712512 11781328
20:17:57 7189 8192000000 10799758672 11231768576 1872652448 18.606 99 22 44 0 1884347520 5378624 6316448
20:18:11 9321 8192000000 10800807712 11229888512 1884947584 18.705 100 32 64 2 1900750096 6791136 9011376
20:18:30 4964 8192000000 10798439184 11230179328 1887063408 18.722 100 28 54 2 1901265424 5998496 8203520
20:18:42 4750 8192000000 10768234688 11186319360 1814905728 18.136 97 33 67 2 1831690672 7248576 9536368
20:18:54 4797 8192000000 10771980336 11198648320 1825689552 18.224 98 26 52 2 1843160160 10267776 7202832
20:19:06 6870 8192000000 10749960512 11170611200 1803779472 18.045 98 21 43 3 1814856336 5347632 5729232
20:19:19 6283 8192000000 10727929904 11144478720 1768760080 17.757 96 20 41 2 1783673120 9728640 5184400
20:19:34 3933 8192000000 10714747536 11137097728 1779453168 17.845 98 20 40 2 1791464160 5334224 6676768
20:19:45 6193 8192000000 10702512752 11115765760 1714647024 17.308 94 19 38 2 1725051424 4937712 5466688
20:19:57 5353 8192000000 10702317488 11118239744 1757972528 17.668 98 19 38 2 1769178016 6135392 5070096
20:20:10 7090 8192000000 10709505712 11122900992 1777519696 17.829 99 25 48 3 1794154720 9296016 7339008
20:20:23 13124 8192000000 10742037008 11160100864 1799539232 18.010 99 17 34 2 1810100288 5411344 5149712
20:20:43 11065 8192000000 10729122096 11141398528 1735738560 17.483 95 29 58 1 1749936032 5303088 8894384
20:21:01 75290 8192000000 10725595808 11145232384 1709743616 17.267 94 23 46 0 1721210624 4971248 6495760
20:22:25 8651 8192000000 10695152240 11112693760 1748385760 17.588 96 23 48 0 1760605392 5231296 6988336
20:22:40 5997 8192000000 10725654272 11143393280 1782145680 17.867 98 41 83 0 1800319264 7260544 10913040
20:22:54 7785 8192000000 10731992064 11139112960 1776382480 17.820 98 38 76 0 1797993008 11083952 10526576
20:23:12 6300 8192000000 10731299488 11146457088 1783797008 17.881 98 43 86 1 1803294736 6437216 13060512
20:23:25 8056 8192000000 10755397616 11166203904 1821752848 18.192 100 25 50 0 1834956080 5028528 8174704
20:23:44 8999 8192000000 10738614592 11170193408 1835703728 18.306 100 20 40 0 1846920496 5358672 5858096
20:24:00 5677 8192000000 10752671920 11177308160 1839960288 18.340 100 23 46 1 1852704736 6388592 6355856
20:24:12 12586 8192000000 10768856256 11189616640 1842842944 18.364 100 28 56 2 1857261072 6241632 8176496
20:24:32 9818 8192000000 10762114768 11188871168 1847384944 18.401 100 20 39 2 1858888016 5100816 6402256
20:24:48 7253 8192000000 10755205168 11190468608 1851340208 18.433 100 25 50 0 1865308304 6504528 7463568
20:25:02 8826 8192000000 10772093168 11197542400 1855286576 18.465 100 24 48 0 1867616448 5152160 7177712
20:25:16 7748 8192000000 10779857136 11200753664 1859272736 18.497 100 28 56 1 1873992592 7016384 7703472
20:25:32 16439 8192000000 10780187648 11201536000 1870150736 18.585 100 28 56 0 1883069440 4947168 7971536
20:25:55 51770 8192000000 10799973520 11209203712 1870293984 18.587 100 48 97 1 1891012336 6008224 14710128
20:26:53 5193 8192000000 10783164096 11208806400 1867334160 18.563 100 29 56 3 1881984880 7358368 7292352
20:27:07 7045 8192000000 10800186016 11226939392 1882356368 18.684 100 20 40 1 1893601152 6024752 5220032
20:27:20 18481 8192000000 10825309408 11246600192 1897820688 18.809 100 30 57 0 1910136128 4668576 7646864
20:27:46 7037 8192000000 10822665872 11247742976 1904314560 18.861 100 36 72 2 1920175968 5648176 10213232
20:28:01 5743 8192000000 10837397536 11262058496 1917204016 18.964 100 57 114 1 1941536336 7846512 16485808
20:28:14 2604 8192000000 10863797744 11271970816 1923181936 19.012 100 64 129 1 1950546784 7650400 19714448
20:28:23 6776 8192000000 10863093888 11282173952 1925087520 19.028 100 53 106 1 1949037424 8827536 15122368
20:28:37 1707 8192000000 10871295728 11285442560 1934308880 19.101 100 73 145 2 1962833680 8621520 19903280
20:28:47 4931 8192000000 10870243472 11291766784 1937551264 19.127 100 56 110 0 1963344512 10865696 14927552
20:28:59 17474 8192000000 10872066176 11291963392 1920619632 18.992 99 53 106 1 1945585120 10682256 14283232
20:29:27 78704 8192000000 10866988768 11300712448 1937320192 19.125 100 39 75 4 1956703456 7166704 12216560
20:30:57 23867 8192000000 10876989584 11314311168 1948782288 19.217 100 40 81 0 1970917232 10888384 11246560
20:31:29 11014 8192000000 10901264464 11327082496 1959780832 19.304 100 54 104 1 1985145040 10840272 14523936
20:31:49 15953 8192000000 10899980544 11331985408 1966355408 19.357 100 58 117 1 1995333776 11768880 17209488
20:32:13 10607 8192000000 10892799120 11329032192 1960771168 19.312 100 55 110 2 1989706800 12696672 16238960
20:32:31 11404 8192000000 10888929856 11332554752 1962134928 19.323 100 44 86 4 1986312736 12206112 11971696
20:32:49 7050 8192000000 10894334992 11329839104 1968273296 19.372 100 51 102 0 1993893520 11330592 14289632
20:33:05 12465 8192000000 10896740976 11338788864 1968049856 19.370 100 52 104 0 1994392256 11588448 14753952
20:33:25 11384 8192000000 10908936992 11343298560 1956463872 19.278 99 49 96 2 1984717264 14131568 14121824
20:33:49 10971 8192000000 10912093488 11352883200 1959134864 19.299 99 54 107 4 1993233600 18172192 15926544
20:34:06 3673 8192000000 10920509632 11347525632 1973598576 19.414 100 71 143 0 2013484304 18677200 21208528
20:34:18 43451 8192000000 10917715952 11354865664 1973393968 19.412 100 52 104 2 2007482688 18004720 16084000
20:35:17 13810 8192000000 10916010032 11360219136 1977268288 19.443 100 43 85 1 2008725056 19024224 12432544
20:35:41 6678 8192000000 10920998992 11362050048 1984070320 19.497 100 47 92 0 2014097664 17015776 13011568
20:35:55 7510 8192000000 10919634656 11358224384 1966754512 19.360 99 61 120 1 2001062848 17060080 17248256
20:36:11 8785 8192000000 10901034272 11338272768 1945354192 19.189 99 52 104 0 1977209536 16924544 14930800
20:36:26 2905 8192000000 10935874320 11354492928 1977863248 19.448 100 86 171 3 2021732320 18371936 25497136
20:36:44 9089 8192000000 10921421552 11359711232 1977718208 19.447 100 57 114 2 2016820624 21951696 17150720
20:37:00 3457 8192000000 10923491040 11355754496 1962353072 19.325 99 59 118 0 2001137600 21090480 17694048
20:37:12 7859 8192000000 10929810096 11357564928 1977739216 19.447 100 63 126 0 2018132544 21694416 18698912
20:37:33 6172 8192000000 10925410336 11363233792 1984824912 19.503 100 55 109 3 2020954016 20365456 15763648
20:37:47 5522 8192000000 10945116944 11366563840 1973969712 19.417 99 62 124 0 2013110912 20998400 18142800
20:38:01 4303 8192000000 10949907280 11375779840 1992509088 19.564 100 67 133 2 2034177872 22020096 19648688
20:38:14 6282 8192000000 10944711616 11369689088 1986534592 19.516 100 75 150 0 2030684992 22196368 21954032
20:38:30 3476 8192000000 10937920400 11370631168 1989841200 19.543 100 58 114 1 2029823920 22922800 17059920
20:38:43 1445 8192000000 10936431728 11363495936 1983863632 19.495 100 59 118 0 2024158320 22025264 18269424
20:38:52 3184 8192000000 10935068928 11357179904 1975043152 19.425 99 69 137 2 2022975728 27149008 20783568
20:39:02 7353 8192000000 10935316448 11350376448 1956496400 19.278 98 72 141 2 2001218192 23815024 20906768
20:39:20 1721 8192000000 10950233088 11369828352 1974943824 19.425 99 77 153 1 2023206064 25082080 23180160
20:39:29 12346 8192000000 10937361760 11359420416 1948367936 19.213 98 73 146 1 1998122832 28179712 21575184
20:39:54 2641 8192000000 10934286720 11357052928 1973083584 19.410 100 72 141 0 2021080864 26447072 21550208
20:40:03 2770 8192000000 10903118304 11308396544 1933963072 19.099 98 77 152 2 1982671536 25815200 22893264
20:40:13 2247 8192000000 10937037040 11353882624 1975203152 19.427 100 84 168 3 2026460416 26227600 25029664
20:40:23 2830 8192000000 10947286896 11360980992 1974565232 19.422 100 77 154 0 2025440288 27506720 23368336
20:40:33 5216 8192000000 10944602416 11365466112 1979368240 19.460 100 70 140 1 2029305344 28677840 21259264
20:40:45 3216 8192000000 10960130208 11375439872 1993091632 19.568 100 86 168 4 2049174592 29709872 26373088
20:40:57 1150 8192000000 10934486352 11345076224 1952788160 19.249 98 80 159 1 2005894720 29200368 23906192
20:41:05 3728 8192000000 10954363648 11370250240 1982289168 19.483 100 77 151 3 2035418624 30115600 23013856
20:41:16 7510 8192000000 10951931216 11371003904 1984060496 19.497 100 76 151 0 2038453920 30946704 23446720
20:41:32 4996 8192000000 10940183856 11368665088 1978877616 19.456 100 67 134 2 2030468944 31175776 20415552
20:41:47 9834 8192000000 10939401840 11363012608 1965303504 19.348 99 62 122 3 2018237872 33029872 19904496
20:42:08 10303 8192000000 10952492624 11370520576 1960694848 19.312 99 62 124 3 2015836832 34395392 20746592
20:42:26 8750 8192000000 10949973520 11373117440 1978154208 19.450 100 69 138 2 2038270400 37804000 22312192
20:42:42 5795 8192000000 10956428192 11373772800 1978165840 19.450 100 74 148 2 2038711904 37414384 23131680
20:42:59 2576 8192000000 10928966464 11337183232 1949940064 19.226 99 83 162 0 2012898944 37004368 25954512
20:43:09 3274 8192000000 10952622256 11359936512 1965903488 19.353 100 83 165 2 2028129728 37121664 25104576
20:43:20 5007 8192000000 10933042768 11359973376 1959911184 19.305 100 64 127 2 2017405376 37662576 19831616
20:43:34 4263 8192000000 10936860528 11355160576 1966090112 19.354 100 86 173 1 2028409680 35236928 27082640
20:43:47 4400 8192000000 10945396144 11360313344 1967552528 19.366 100 68 136 1 2023589024 35638688 20397808
20:43:59 3742 8192000000 10941142048 11358543872 1964829072 19.344 100 83 164 0 2028849248 38759680 25260496
20:44:15 6398 8192000000 10953186176 11376300032 1974915328 19.424 100 67 133 3 2034890736 39506496 20468912
20:44:32 6183 8192000000 10972163136 11389947904 1978752976 19.455 100 71 140 1 2043677744 43756528 21168240
20:44:46 1779 8192000000 10982027072 11388735488 1982115264 19.481 100 83 166 3 2055054736 47399616 25539856
20:44:54 2122 8192000000 10962512400 11368611840 1959070256 19.299 99 92 181 2 2034443632 47238112 28135264
20:45:04 1767 8192000000 10967325568 11377786880 1973982800 19.417 100 94 188 0 2051168288 47627600 29557888
20:45:14 6602 8192000000 10947599488 11369041920 1951638976 19.240 99 74 148 1 2023453584 48366416 23448192
20:45:29 2722 8192000000 10917299152 11341062144 1928225344 19.053 99 60 120 0 1995021952 48239216 18557392
20:45:39 3688 8192000000 10935280128 11348041728 1944605120 19.183 100 84 164 1 2016259248 46669088 24985040
20:45:50 4037 8192000000 10931505280 11342626816 1915728832 18.953 98 83 166 1 1989646192 48605456 25311904
20:46:06 6044 8192000000 10938288688 11353571328 1946199712 19.196 100 76 152 1 2019002144 49804512 22997920
20:46:19 3321 8192000000 10948288832 11360796672 1956751280 19.280 100 81 162 2 2028864624 46897088 25216256
20:46:29 2540 8192000000 10958299520 11367571456 1962793728 19.328 100 85 171 2 2037788384 48750704 26243952
20:46:39 2270 8192000000 10962319840 11373641728 1964128560 19.339 100 80 159 2 2038342256 49325792 24887904
20:46:49 4975 8192000000 10960425984 11365052416 1944110704 19.180 99 76 153 2 2019391776 50879504 24401568
20:47:04 9571 8192000000 10955449520 11376279552 1963232416 19.332 100 71 139 0 2037992448 52282128 22477904
20:47:23 3318 8192000000 10965448864 11385245696 1970022992 19.386 100 64 128 0 2045636512 54755632 20857888
20:47:37 10858 8192000000 10954572720 11384844288 1975849968 19.432 100 43 86 1 2035554224 44794512 14909744
20:48:03 4744 8192000000 10949554176 11382247424 1956189248 19.276 99 61 122 2 2026511200 50662240 19659712
20:48:16 1967 8192000000 10933315296 11353133056 1949726192 19.224 100 64 125 2 2016384064 47562560 19095312
20:48:29 2372 8192000000 10932063808 11351769088 1945008352 19.187 100 68 136 2 2017969952 50644720 22316880
20:48:41 3525 8192000000 10942778928 11366445056 1955914160 19.274 100 69 138 1 2028049136 50724112 21410864
20:48:54 11959 8192000000 10928068672 11361730560 1935726288 19.113 99 51 103 1 2001908016 49909088 16272640
20:49:13 8889 8192000000 10917491712 11365826560 1948216768 19.212 100 41 82 0 2013436752 52005872 13214112
20:49:35 18379 8192000000 10908295248 11357540352 1953406192 19.254 100 22 42 0 2001458624 41288368 6764064
20:50:04 34090 8192000000 10918316112 11355926528 1925335232 19.030 98 31 62 2 1976702400 40992624 10374544
20:50:58 20182 8192000000 10885133984 11333394432 1894379248 18.781 97 28 53 0 1944412576 41620384 8412944
20:51:26 19611 8192000000 10892438000 11343011840 1926002016 19.035 100 21 43 0 1974887488 42337008 6548464
20:52:15 15961 8192000000 10883879328 11325591552 1900554480 18.831 98 30 60 0 1948965280 38765904 9644896
20:52:44 15350 8192000000 10902128144 11346882560 1942638256 19.168 100 36 72 3 1991673392 37144864 11890272
20:53:12 22786 8192000000 10882613888 11331190784 1895095744 18.787 98 25 50 1 1950222160 47184576 7941840
20:53:45 13018 8192000000 10890526240 11334647808 1925411424 19.030 100 33 66 0 1975972928 40234416 10327088
20:54:05 25171 8192000000 10895792032 11344551936 1916104416 18.956 99 27 54 0 1966208208 40768448 9335344
20:54:36 16733 8192000000 10899454320 11342430208 1937841712 19.130 100 33 66 2 1988646320 40417392 10387216
20:55:04 11996 8192000000 10899883568 11344732160 1932717616 19.089 100 21 42 2 1982332896 41907152 7708128
20:55:40 19521 8192000000 10892894608 11342909440 1930897104 19.074 100 20 40 1 1978119424 40016320 7206000
20:56:31 26170 8192000000 10903286544 11366875136 1939600320 19.144 100 26 52 1 1990480128 41794208 9085600
20:57:05 27126 8192000000 10889319024 11351437312 1943673744 19.176 100 14 28 0 1978948976 30654592 4620640
20:57:39 37602 8192000000 10895082752 11336028160 1937085808 19.123 99 19 36 2 1949608320 7061632 5460880
20:58:24 64656 8192000000 10903633936 11345461248 1964887568 19.345 100 36 73 0 1983867984 8351920 10628496
20:59:43 59375 8192000000 10893904352 11353411584 1948889776 19.218 99 23 46 0 1968769824 13420160 6459888
21:00:55 8239 8192000000 10889258720 11350429696 1940908256 19.154 99 18 36 0 1961136224 14785264 5442704
21:01:09 14386 8192000000 10875854992 11334504448 1935636960 19.112 99 15 30 1 1950584960 11071936 3876064
21:01:30 24174 8192000000 10875677072 11331002368 1935040256 19.107 99 19 38 1 1950493184 10161792 5291136
21:02:01 72981 8192000000 10878799680 11342561280 1924819712 19.025 98 27 55 0 1946409392 14040032 7549648
21:03:20 75673 8192000000 10890315360 11358199808 1946295792 19.197 99 16 30 2 1963219344 13079824 3843728
21:04:42 77678 8192000000 10909599216 11362480128 1950826032 19.233 99 16 32 2 1963686160 8213728 4646400
21:06:13 92109 8192000000 10894397344 11360468992 1954044656 19.259 99 23 46 0 1972438608 11605344 6788608
21:07:59 105751 8192000000 10881683552 11350978560 1950040272 19.227 99 23 46 1 1972670560 16190832 6439456
21:09:54 76833 8192000000 10903001744 11360391168 1955640720 19.271 99 19 38 1 1973223984 12526512 5056752
21:11:21 92264 8192000000 10905691568 11369861120 1975898384 19.432 100 38 77 2 1999785440 12868080 11018976
21:13:13 95676 8192000000 10890434032 11366150144 1941351344 19.158 98 31 62 1 1965364864 15309728 8703792
21:15:04 68053 8192000000 10893079984 11353010176 1951340112 19.237 99 35 70 0 1973813440 12000592 10472736
21:16:23 20082 8192000000 10888216048 11349970944 1964982656 19.346 100 28 54 1 1983415120 11012832 7419632
21:16:49 23471 8192000000 10909550288 11357052928 1972358336 19.404 100 48 97 4 1998143888 11750288 14035264
21:18:31 50787 8192000000 10890168768 11380076544 1954649184 19.263 99 6 12 0 1970395280 14214576 1531520
21:20:03 62125 8192000000 10894897488 11368603648 1946356240 19.197 98 12 24 2 1958426240 8781072 3288928
21:21:12 59419 8192000000 10862775136 11334045696 1906070528 18.875 97 11 22 0 1922267504 11920608 4276368
21:23:12 105300 8192000000 10895109328 11367485440 1952693312 19.248 99 18 36 0 1980007728 21881136 5433280
21:25:06 43849 8192000000 10886840000 11361275904 1956151328 19.275 99 23 46 1 1973488240 10226496 7110416
21:26:09 48936 8192000000 10875582992 11355254784 1933028480 19.091 98 13 26 0 1943791728 7285856 3477392
21:28:10 77576 8192000000 10852346112 11331190784 1867477536 18.564 95 5 10 0 1877650864 9126112 1047216
21:29:40 73396 8192000000 10876906512 11366367232 1939731872 19.145 99 12 24 1 1957971232 14950672 3288688
21:31:30 68548 8192000000 10870653664 11341631488 1838652160 18.330 93 13 26 0 1856503760 14228560 3623040
21:32:45 28751 8192000000 10888451760 11348205568 1919853424 18.986 98 22 44 1 1940581520 14442464 6285632
21:33:32 65412 8192000000 10892180720 11366924288 1951413408 19.238 100 10 20 0 1965353584 10857056 3083120
21:34:50 54893 8192000000 10896161968 11362250752 1897565504 18.807 96 23 46 0 1921051888 17165232 6321152
21:35:51 74801 8192000000 10882689632 11343306752 1870271536 18.586 95 24 48 1 1893378016 16244352 6862128
21:37:12 54213 8192000000 10885859104 11340587008 1906011280 18.875 98 15 30 0 1926542352 16219520 4311552
21:38:21 43571 8192000000 10900058224 11373785088 1950172176 19.228 100 32 64 0 1983711456 24246768 9292512
21:39:14 80063 8192000000 10894727968 11390746624 1941673520 19.160 99 15 30 0 1972328336 26365680 4289136
21:40:40 137352 8192000000 10885934800 11355717632 1864390592 18.539 95 19 38 1 1888345888 19058384 4896912
21:43:04 77120 8192000000 10865779232 11347398656 1850346384 18.425 95 23 46 1 1873017072 16154400 6516288
21:44:27 119491 8192000000 10853382752 11311869952 1851293584 18.433 96 12 24 2 1864392848 8864976 4234288
21:46:49 85466 8192000000 10848291056 11311972352 1861586480 18.516 96 36 72 0 1884400400 12782336 10031584
21:48:39 29058 8192000000 10863072832 11330854912 1910374224 18.910 99 30 60 0 1932012160 13169104 8468832
21:49:14 25935 8192000000 10859820048 11337392128 1936338592 19.118 100 20 40 1 1955255104 13169040 5747472
21:49:54 56183 8192000000 10834143168 11308507136 1909872288 18.906 99 8 16 0 1923471776 11286976 2312512
21:50:56 38458 8192000000 10835878528 11306401792 1894007168 18.778 98 15 30 1 1905034304 7120224 3906912
21:51:41 45729 8192000000 10832522288 11301838848 1868651968 18.573 97 13 23 2 1878905104 6999632 3253504
21:52:56 44381 8192000000 10841098240 11317063680 1927060288 19.043 100 15 30 1 1939863680 8129728 4673664
21:53:46 42844 8192000000 10851296448 11327651840 1911243648 18.917 99 10 20 0 1921220544 7079840 2897056
21:54:35 79174 8192000000 10862163792 11337752576 1937703056 19.128 100 19 38 0 1956051152 12971696 5376400
21:56:01 53932 8192000000 10875783984 11339468800 1922005248 19.003 99 15 30 0 1937703056 11220016 4477792
21:57:08 60616 8192000000 10839386192 11321057280 1850535920 18.426 95 6 12 0 1861889040 9949296 1403824
21:58:15 49102 8192000000 10856247376 11322875904 1886864416 18.721 97 14 26 1 1900275488 9244512 4166560
21:59:10 64543 8192000000 10886585664 11357122560 1951720384 19.240 100 22 44 2 1971638960 13544400 6374176
22:00:25 48316 8192000000 10880734384 11344506880 1918843792 18.978 98 11 22 0 1929843600 8245232 2754576
22:01:21 56010 8192000000 10880601968 11352383488 1924178400 19.020 98 17 34 0 1937015536 8176160 4660976
22:02:35 46823 8192000000 10898315184 11369291776 1957805232 19.289 99 45 90 0 1981500736 10916752 12778752
22:03:54 57096 8192000000 10897732576 11373891584 1964075744 19.338 100 14 28 0 1978349120 10349136 3924240
22:04:58 86864 8192000000 10905859792 11387203584 1936380000 19.118 98 13 26 2 1953691008 13575536 3735472
22:06:31 92853 8192000000 10901146528 11381665792 1954375328 19.261 99 11 22 0 1974130720 16593776 3161616
22:08:10 49582 8192000000 10912508960 11354726400 1902317344 18.845 96 38 76 1 1921260464 8598768 10344352
22:09:08 36525 8192000000 10901392464 11357556736 1906145904 18.876 97 35 70 2 1925752464 10395920 9210640
22:09:54 23586 8192000000 10903467632 11359567872 1945505760 19.191 99 44 89 1 1968130480 10018768 12605952
22:10:24 61636 8192000000 10904710832 11364442112 1906799696 18.881 97 22 44 1 1923928032 11083872 6044464
22:11:33 145448 8192000000 10883452784 11344748544 1897841056 18.809 97 30 60 0 1924480048 18163600 8475392
22:14:13 78907 8192000000 10863907952 11352219648 1913685520 18.936 98 24 48 2 1932239616 11977776 6576320
22:15:38 60521 8192000000 10876629440 11354345472 1957963520 19.290 100 12 24 0 1975034848 13820464 3250864
22:16:48 40198 8192000000 10880033712 11350732800 1939600640 19.144 99 8 16 1 1955906576 13819232 2486704
22:17:36 81264 8192000000 10890888976 11371401216 1961996704 19.322 100 13 26 1 1979627248 13699728 3930816
22:19:04 89702 8192000000 10881202096 11373150208 1948872704 19.217 99 13 26 0 1964635264 12102864 3659696
22:20:40 36034 8192000000 10880693424 11351379968 1909435040 18.902 97 6 12 0 1918391168 7711680 1244448
22:21:23 41631 8192000000 10901279632 11353513984 1907462224 18.886 97 28 57 1 1923074016 7243984 8367808
22:22:15 48834 8192000000 10870842608 11348852736 1923713808 19.017 98 15 30 1 1934443200 6560000 4169392
22:23:12 26492 8192000000 10897265616 11351670784 1939963328 19.146 99 17 34 0 1951727568 6651536 5112704
22:23:45 17968 8192000000 10897835744 11355934720 1960702816 19.312 100 37 74 1 1980261200 8701840 10856544
22:24:18 29943 8192000000 10860566384 11321266176 1900690112 18.832 97 27 54 0 1925605968 16894016 8021840
22:25:06 35016 8192000000 10876373760 11337838592 1900997472 18.834 97 24 48 0 1919256896 11151616 7107808
22:25:47 28142 8192000000 10887377984 11347599360 1932993600 19.091 99 28 56 3 1954517232 13040944 8482688
22:26:21 70867 8192000000 9925359344 10311086080 863819776 9.538 44 10 20 0 877491552 10671856 2999920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 12-02-2021 22:28:52 to 12-02-2021 22:29:25.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-02-2021 22:29:26 to 12-02-2021 22: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          241166
MON$OLDEST_ACTIVE               242362
MON$OLDEST_SNAPSHOT             242362
MON$NEXT_TRANSACTION            242362
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                       2033888
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:292: 
:293: mscs-test-161.budzdorov.ru    Fri Feb 12 22:27:43 2021
:294:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:295: 
:296: 
:297: mscs-test-161.budzdorov.ru    Fri Feb 12 22:27:43 2021
:298:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:299: 
:300: 
:301: mscs-test-161.budzdorov.ru    Fri Feb 12 22:27:49 2021
:302:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:303: 
--- end of diff output ---

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

12.02.21 22: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-02-12 22:29:31 No severe PSQL-related problems occured
12.02.21 22:29:33. End of report.