Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.03.2021 01:27
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 17366464 kB
MemAvailable 31514572 kB
Buffers 0 kB
Cached 14275108 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-20 01:27:21
DTS_END                         2021-03-20 01:27:21.8010
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/45172
TRN_ID                          240292
ATT_ID                          694
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: 9048.38 21446 1085806
customer order: creation 173.12 370 20774
customer order: refuse 14.70 350 1764
order to supplier: creation 45.15 1391 5418
order to supplier: removal 3.28 109603 394
invoice (draft): creation 46.80 3498 5616
invoice (draft): removal 51.70 882 6204
invoice accept: apply 41.07 17747 4928
invoice accept: cancel 46.48 822 5577
customer reserve: creation 3769.08 176 452290
customer reserve: removal 4559.45 62 547134
realization accept: apply 84.28 187 10114
realization accept: cancel 82.63 109 9915
payment from customer: creation 60.00 101 7200
payment from customer: removal 5.98 68 718
payment to supplier: creation 48.97 129 5876
payment to supplier: removal 3.38 110 405
service: total inventory turnovers 4.80 959 576
service: total monetary turnovers 6.68 31 801
service: aggregate perf. data 0.82 19691 98
service: refresh index statistics 0.03 272624 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2021 01:28:09 to 20-03-2021 01:28:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5393
TEST_TIME 2 5830
TEST_TIME 3 5395
TEST_TIME 4 5060
TEST_TIME 5 5155
TEST_TIME 6 5446
TEST_TIME 7 5273
TEST_TIME 8 5123
TEST_TIME 9 5586
TEST_TIME 10 5503
TEST_TIME 11 5409
TEST_TIME 12 5551
TEST_TIME 13 5787
TEST_TIME 14 5935
TEST_TIME 15 6544
TEST_TIME 16 6785
TEST_TIME 17 7023
TEST_TIME 18 7180
TEST_TIME 19 7282
TEST_TIME 20 7352
TEST_TIME 21 8166
TEST_TIME 22 8323
TEST_TIME 23 8394
TEST_TIME 24 8590
TEST_TIME 25 8864
TEST_TIME 26 9089
TEST_TIME 27 9021
TEST_TIME 28 9367
TEST_TIME 29 9847
TEST_TIME 30 10745
TEST_TIME 31 10686
TEST_TIME 32 10698
TEST_TIME 33 10682
TEST_TIME 34 10393
TEST_TIME 35 10277
TEST_TIME 36 10170
TEST_TIME 37 9962
TEST_TIME 38 9895
TEST_TIME 39 9804
TEST_TIME 40 9880
TEST_TIME 41 9755
TEST_TIME 42 9699
TEST_TIME 43 9633
TEST_TIME 44 9505
TEST_TIME 45 9409
TEST_TIME 46 9314
TEST_TIME 47 9371
TEST_TIME 48 9250
TEST_TIME 49 9247
TEST_TIME 50 9157
TEST_TIME 51 9135
TEST_TIME 52 9125
TEST_TIME 53 9129
TEST_TIME 54 9125
TEST_TIME 55 9005
TEST_TIME 56 8937
TEST_TIME 57 9032
TEST_TIME 58 9062
TEST_TIME 59 9016
TEST_TIME 60 9013
TEST_TIME 61 9005
TEST_TIME 62 9023
TEST_TIME 63 9059
TEST_TIME 64 9095
TEST_TIME 65 9214
TEST_TIME 66 9157
TEST_TIME 67 9240
TEST_TIME 68 9247
TEST_TIME 69 9217
TEST_TIME 70 9215
TEST_TIME 71 9435
TEST_TIME 72 9454
TEST_TIME 73 9401
TEST_TIME 74 9278
TEST_TIME 75 9239
TEST_TIME 76 9172
TEST_TIME 77 9151
TEST_TIME 78 9189
TEST_TIME 79 9158
TEST_TIME 80 9124
TEST_TIME 81 9111
TEST_TIME 82 9088
TEST_TIME 83 9017
TEST_TIME 84 8974
TEST_TIME 85 8932
TEST_TIME 86 8966
TEST_TIME 87 8969
TEST_TIME 88 8971
TEST_TIME 89 9013
TEST_TIME 90 9009
TEST_TIME 91 9003
TEST_TIME 92 9109
TEST_TIME 93 9163
TEST_TIME 94 9203
TEST_TIME 95 9193
TEST_TIME 96 9200
TEST_TIME 97 9208
TEST_TIME 98 9200
TEST_TIME 99 9180
TEST_TIME 100 9185
TEST_TIME 101 9245
TEST_TIME 102 9163
TEST_TIME 103 9115
TEST_TIME 104 9088
TEST_TIME 105 9093
TEST_TIME 106 9060
TEST_TIME 107 9032
TEST_TIME 108 9029
TEST_TIME 109 8988
TEST_TIME 110 8956
TEST_TIME 111 8985
TEST_TIME 112 8978
TEST_TIME 113 8951
TEST_TIME 114 8956
TEST_TIME 115 9021
TEST_TIME 116 9094
TEST_TIME 117 9096
TEST_TIME 118 9055
TEST_TIME 119 9070
TEST_TIME 120 9053

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-03-2021 01:28:12 to 20-03-2021 01:28:16.

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 1504588 1504588 0 0.00 0 21180 6 0 0
doc_list_biud 1504587 1504587 0 0.00 0 32898 29 0 0
sp_add_invoice_to_stock 5004 4928 76 1.51 25 176510 17748 0 76
sp_cancel_adding_invoice 5577 5577 0 0.00 3 79407 823 0 0
sp_cancel_client_order 1764 1764 0 0.00 4 9481 351 0 0
sp_cancel_customer_reserve 547134 547134 0 0.00 1 28526 63 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 1784 68 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 6782 110 0 0
sp_cancel_supplier_invoice 6210 6204 6 0.09 2 32905 883 0 6
sp_cancel_supplier_order 394 394 0 0.00 13 1106781 109604 0 0
sp_cancel_write_off 9915 9915 0 0.00 1 9379 110 0 0
sp_client_order 20774 20774 0 0.00 3 37077 370 0 0
sp_customer_reserve 452290 452290 0 0.00 0 94326 177 0 0
sp_fill_shopping_cart 31808 31808 0 0.00 1 20453 46 0 0
sp_fill_shopping_cart_clo_res 452285 452285 0 0.00 0 24661 14 0 0
sp_get_clo_for_invoice 4921 4921 0 0.00 0 27321 345 0 0
sp_kill_cost_storno 16615 16615 0 0.00 0 9349 56 0 0
sp_kill_qstorno_ret_qs2qd 1110781 1110781 0 0.00 0 32896 34 0 0
sp_kill_qty_storno 586023 586023 0 0.00 0 32897 74 0 0
sp_lock_selected_doc 20833 20833 0 0.00 0 9462 6 0 0
sp_make_cost_storno 28111 28111 0 0.00 0 15113 51 0 0
sp_multiply_rows_for_pdistr 28111 28111 0 0.00 0 6772 29 0 0
sp_multiply_rows_for_qdistr 20774 20774 0 0.00 0 34250 170 0 0
sp_pay_from_customer 7200 7200 0 0.00 4 10044 102 0 0
sp_pay_to_supplier 5876 5876 0 0.00 5 21358 130 0 0
sp_payment_common 13076 13076 0 0.00 1 21350 27 0 0
sp_qd_handle_on_cancel_clo 1764 1764 0 0.00 0 9474 322 0 0
sp_qd_handle_on_invoice_upd_sts 10498 10498 0 0.00 0 16457 339 0 0
sp_qd_handle_on_reserve_upd_sts 10114 10114 0 0.00 0 13773 60 0 0
sp_reserve_write_off 10114 10114 0 0.00 6 15050 187 0 0
sp_supplier_invoice 5616 5616 0 0.00 7 87221 3499 0 0
sp_supplier_order 5418 5418 0 0.00 5 34033 1391 0 0
srv_aggregate_perf_data 98 98 0 0.00 2344 359210 19691 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1387 163658 30382 0 0
srv_find_qd_qs_mism 1038207 1038207 0 0.00 0 21178 5 0 0
srv_make_invnt_saldo 576 576 0 0.00 37 33922 960 0 0
srv_make_money_saldo 801 801 0 0.00 0 2842 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 115181 375531 272624 0 0
t$perf-abend:sp_add_invoice_to_stock 76 76 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4929 4929 0 0.00 0 11140 160 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 3588 92 0 0
t$perf-norm:sp_cancel_client_order 1764 1764 0 0.00 0 17802 26 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 1414 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 4750 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 413 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 504 10 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 47676 1667 0 0
t$perf-norm:sp_cancel_write_off 956 956 0 0.00 0 4793 10 0 0
t$perf-norm:sp_client_order 20774 20774 0 0.00 0 7716 18 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 3610 15 0 0
t$perf-norm:sp_pay_from_customer 7200 7200 0 0.00 0 5826 10 0 0
t$perf-norm:sp_pay_to_supplier 5876 5876 0 0.00 0 5067 12 0 0
t$perf-norm:sp_reserve_write_off 10114 10114 0 0.00 0 7741 13 0 0
t$perf-norm:sp_supplier_invoice 5616 5616 0 0.00 0 7352 22 0 0
t$perf-norm:sp_supplier_order 5418 5418 0 0.00 0 6709 20 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 156 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 60 2 0 0
t$perf-norm:srv_make_invnt_saldo 576 576 0 0.00 0 569 22 0 0
t$perf-norm:srv_make_money_saldo 801 801 0 0.00 0 2155 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 9992 9840 152 1.52 0 14678 19 0 152
v_all_customers 37684 37684 0 0.00 0 79 1 0 0
v_all_suppliers 30318 30318 0 0.00 0 158 1 0 0
v_all_wares 41548 41548 0 0.00 0 159 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 2283 13 0 0
v_cancel_client_order 3528 3528 0 0.00 0 1626 3 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 1772 6 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 1754 5 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 5470 12 0 0
v_cancel_supplier_invoice 892 880 12 1.34 0 2865 20 0 12
v_cancel_supplier_order 788 788 0 0.00 0 1603 9 0 0
v_cancel_write_off 1912 1912 0 0.00 0 1644 14 0 0
v_max_id_clo_ord 5418 5418 0 0.00 0 1341 2 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 4659 14 0 0
v_max_id_ord_sup 5616 5616 0 0.00 0 3478 3 0 0
v_max_non_paid_invoice 1751 1751 0 0.00 0 1328 3 0 0
v_max_non_paid_realizn 3843 3843 0 0.00 0 3337 6 0 0
v_min_id_clo_ord 5418 5418 0 0.00 0 5953 12 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 4901 19 0 0
v_min_id_ord_sup 5616 5616 0 0.00 0 4069 9 0 0
v_min_non_paid_invoice 5876 5876 0 0.00 0 21347 18 0 0
v_min_non_paid_realizn 7200 7200 0 0.00 0 6445 16 0 0
v_our_firm 10578 10578 0 0.00 0 16 1 0 0
v_reserve_write_off 20228 20228 0 0.00 0 14970 10 0 0
x_lock_depdocs_on_canc_invoice 11341 11341 0 0.00 0 13798 112 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 6129 364 0 0
x_make_qstorno_1000_1200 5418 5418 0 0.00 2 33856 1294 0 0
x_make_qstorno_1200_2000 5616 5616 0 0.00 3 86980 3337 0 0
x_make_qstorno_2100_3300 452290 452290 0 0.00 0 94324 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2021 01:28:17 to 20-03-2021 01:28:21.

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
22:57:25 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:32 19658 8192000000 10264085520 10576486400 977706016 10.662 77 52 110 1 996816784 2555584 16555184
22:58:03 14850 8192000000 10343979472 10658811904 1397524208 14.573 100 84 168 0 1428828288 4579808 26724272
22:58:31 28482 8192000000 10382425856 10705866752 1433170752 14.889 100 90 180 0 1469736832 6810832 29755248
22:59:10 26237 8192000000 10416105120 10741178368 1463967216 15.161 100 90 180 0 1501568784 8096400 29505168
22:59:46 28151 8192000000 10432136336 10762244096 1474764816 15.256 100 93 186 0 1514495104 9111792 30618496
23:00:23 24803 8192000000 10451980480 10785218560 1502478208 15.498 100 95 190 0 1543576832 10211840 30886784
23:00:57 22531 8192000000 10460134800 10797801472 1516062944 15.616 100 91 183 0 1556389088 10856992 29469152
23:01:40 25440 8192000000 10497456032 10841686016 1541669312 15.838 100 85 169 0 1579270512 10826176 26775024
23:02:15 12604 8192000000 10511832384 10862874624 1569376000 16.077 100 82 164 0 1606231520 11457696 25397824
23:02:36 17579 8192000000 10537076384 10892533760 1593308928 16.282 100 84 168 0 1630555648 11204256 26042464
23:03:08 11469 8192000000 10568647264 10928799744 1624386944 16.547 100 81 162 1 1660528464 12010304 24131216
23:03:31 6218 8192000000 10583276736 10951757824 1644537904 16.718 100 71 142 0 1677916720 12365392 21013424
23:03:45 12675 8192000000 10608121424 10972299264 1658992528 16.840 100 75 150 0 1693816368 12997872 21825968
23:04:07 9510 8192000000 10631282448 10996207616 1681588704 17.031 100 81 162 1 1718921904 14273184 23060016
23:04:26 5192 8192000000 10638790608 11010281472 1694650624 17.140 100 81 160 2 1731950176 14352912 22946640
23:04:41 7247 8192000000 10657174224 11027116032 1712639360 17.291 100 81 162 1 1749394848 13474064 23281424
23:04:56 7039 8192000000 10667297344 11044847616 1731337232 17.447 100 80 161 1 1766354976 12388960 22628784
23:05:11 4772 8192000000 10675556128 11051118592 1739204880 17.512 100 75 150 0 1772507936 11842480 21460576
23:05:23 5955 8192000000 10694024736 11070263296 1754498928 17.639 100 81 162 0 1789082960 11966816 22617216
23:05:36 3735 8192000000 10696423232 11077390336 1765513872 17.730 100 72 145 1 1798214496 11891680 20808944
23:05:47 4681 8192000000 10715721696 11099459584 1783763392 17.880 100 80 160 0 1818675968 12181376 22731200
23:06:05 5019 8192000000 10725520720 11112439808 1791301248 17.942 100 69 136 1 1822084208 12046992 18735968
23:06:17 2803 8192000000 10740825456 11127656448 1808129472 18.081 100 80 160 0 1842773440 11955824 22688144
23:06:28 2576 8192000000 10754636944 11140648960 1820006144 18.178 100 77 154 4 1853537168 12453552 21077472
23:06:37 4756 8192000000 10762396576 11154841600 1827485840 18.239 100 71 141 0 1859003696 11801648 19716208
23:06:48 2413 8192000000 10786565840 11174170624 1841199216 18.351 100 86 172 0 1877291952 11710384 24382352
23:06:58 2382 8192000000 10790380592 11173171200 1850172288 18.424 100 90 180 0 1888241056 13530224 24538544
23:07:07 2339 8192000000 10798020016 11181559808 1852041728 18.439 100 94 188 1 1892876016 14936176 25898112
23:07:16 2143 8192000000 10800026368 11184783360 1852843072 18.445 100 91 182 1 1893331392 13861072 26627248
23:07:25 2056 8192000000 10797969200 11186483200 1857551888 18.483 100 92 180 2 1896140304 12510320 26078096
23:07:33 2397 8192000000 10798033232 11187802112 1857017888 18.479 100 84 169 2 1893461328 12771424 23672016
23:07:42 1328 8192000000 10811758464 11197001728 1861990400 18.519 100 90 178 0 1899764928 13249168 24525360
23:07:50 2058 8192000000 10816380768 11203076096 1869726240 18.582 100 92 182 3 1908921424 13394448 25800736
23:07:59 2002 8192000000 10817127840 11206602752 1874210448 18.618 100 93 186 0 1915083024 14285008 26587568
23:08:07 1365 8192000000 10823175216 11213426688 1878209936 18.651 100 98 196 0 1919956032 14011472 27734624
23:08:15 2464 8192000000 10831435152 11219947520 1885096576 18.706 100 93 186 1 1924483024 12830080 26556368
23:08:24 1540 8192000000 10816493440 11216011264 1886750064 18.720 100 88 177 0 1923998304 12049792 25198448
23:08:31 21534 8192000000 10799183728 11210174464 1876682896 18.638 100 54 108 0 1903420496 11729952 15007648
23:09:04 14080 8192000000 10821006192 11214934016 1882577264 18.686 100 77 150 2 1915286688 10192368 22517056
23:09:25 2006 8192000000 10830284352 11221483520 1890261376 18.748 100 95 190 3 1928785936 11398752 27125808
23:09:34 3928 8192000000 10826572448 11226435584 1889535120 18.742 100 80 160 0 1925146448 12818592 22792736
23:09:44 16161 8192000000 10787256000 11215626240 1878635568 18.654 100 28 56 0 1894864064 8762528 7465968
23:10:07 6157 8192000000 10791212176 11217125376 1880598688 18.670 100 30 60 1 1896127808 7038592 8490528
23:10:20 11462 8192000000 10794138720 11217842176 1883292832 18.692 100 29 56 1 1898716656 7282624 8141200
23:10:39 5292 8192000000 10818341744 11227549696 1888082160 18.730 100 43 84 2 1911529024 11741296 11705568
23:10:50 7869 8192000000 10792333472 11222515712 1886200416 18.715 100 24 46 1 1899860112 7283680 6376016
23:11:04 9726 8192000000 10807064704 11230842880 1889630448 18.743 100 27 53 1 1904239792 6696384 7912960
23:11:23 17975 8192000000 10796170160 11229302784 1892160864 18.763 100 23 46 0 1905481264 6120768 7199632
23:11:49 15206 8192000000 10798990128 11235053568 1895970816 18.794 100 21 42 2 1908319712 6793296 5555600
23:12:10 12755 8192000000 10800669344 11238199296 1894092000 18.779 100 10 20 0 1906305568 9691680 2521888
23:12:29 16133 8192000000 10799721520 11234684928 1894616064 18.783 100 13 26 0 1904194976 5648048 3930864
23:12:56 5393 8192000000 10811724096 11241406464 1901085040 18.835 100 31 63 1 1915318288 4861024 9372224
23:13:11 8201 8192000000 10799793312 11238645760 1897772720 18.808 100 14 27 1 1911687120 10562048 3352352
23:13:27 9843 8192000000 10812709360 11248398336 1900279088 18.829 100 13 26 0 1913450304 9703248 3467968
23:13:43 15056 8192000000 10811789136 11245789184 1915091520 18.947 100 21 44 1 1926197568 4719504 6386544
23:14:07 71705 8192000000 10824009168 11262349312 1913687328 18.936 100 30 57 2 1927286208 5490144 8108736
23:15:26 3528 8192000000 10851429424 11269652480 1927351808 19.046 100 64 127 3 1950767376 5843200 17572368
23:15:36 8023 8192000000 10822709216 11254689792 1875492224 18.629 98 27 54 0 1889782800 6984368 7306208
23:15:50 5523 8192000000 10820913808 11258556416 1908948912 18.898 100 28 55 1 1923704944 7509280 7246752
23:16:03 5673 8192000000 10835795856 11261394944 1907109424 18.883 100 39 79 1 1924858736 6670832 11078480
23:16:15 3647 8192000000 10824480384 11256639488 1911262416 18.917 100 36 73 1 1927101904 6289744 9549744
23:16:26 5352 8192000000 10834679264 11259002880 1893490432 18.774 99 27 54 2 1911352512 9442064 8420016
23:16:40 10315 8192000000 10822073712 11258933248 1909698800 18.904 100 24 46 3 1921641392 5914592 6028000
23:16:57 10749 8192000000 10808108752 11240374272 1872492928 18.604 98 18 36 0 1887123280 9788848 4841504
23:17:15 8252 8192000000 10797525968 11226288128 1811749248 18.110 95 17 36 0 1823156464 5788816 5618400
23:17:29 4858 8192000000 10798618496 11228622848 1867053904 18.560 99 28 56 3 1881193408 5603632 8535872
23:17:43 7237 8192000000 10781656288 11205898240 1828359840 18.246 97 24 48 2 1841688896 6481792 6847264
23:17:56 14151 8192000000 10745912384 11175317504 1722906352 17.376 92 9 18 0 1730872016 4903888 3061776
23:18:18 4344 8192000000 10750052016 11170103296 1832330768 18.278 100 24 48 0 1845008080 5626400 7050912
23:18:33 11936 8192000000 10715977776 11143114752 1765817696 17.732 96 18 35 2 1776246608 5159808 5269104
23:18:55 9592 8192000000 10752497456 11183013888 1831491904 18.271 99 26 52 2 1848955408 9908656 7554848
23:19:14 59469 8192000000 10718380432 11147038720 1737718624 17.500 94 29 59 0 1752024208 5577744 8727840
23:20:22 11874 8192000000 10738380624 11154546688 1763481728 17.713 96 25 49 2 1776185392 5606816 7096848
23:20:41 6625 8192000000 10742983504 11161116672 1808458368 18.083 99 37 74 1 1827729648 7905600 11365680
23:20:56 8381 8192000000 10714415024 11133882368 1749003984 17.593 96 27 53 3 1761430528 5231296 7195248
23:21:11 5453 8192000000 10719102704 11136888832 1801421136 18.026 100 26 52 1 1816228976 7151824 7656016
23:21:24 7042 8192000000 10698149776 11116408832 1773787056 17.798 99 28 56 0 1788779296 5597200 9395040
23:21:38 7556 8192000000 10713286800 11124584448 1793585792 17.961 100 35 70 1 1810527024 6455488 10485744
23:21:52 6164 8192000000 10693566512 11106181120 1742912896 17.543 97 32 64 0 1758757648 6386704 9458048
23:22:05 5186 8192000000 10672876128 11087835136 1760395392 17.688 99 31 59 3 1776925296 6902480 9627424
23:22:19 9277 8192000000 10701008080 11127640064 1767781088 17.749 98 21 41 2 1779957312 5721584 6454640
23:22:37 7150 8192000000 10714595792 11135873024 1803823440 18.045 100 24 48 3 1817235056 6879632 6531984
23:22:52 5873 8192000000 10726376288 11154411520 1817224672 18.155 100 18 36 0 1828044704 5614176 5205856
23:23:09 4727 8192000000 10738833456 11158462464 1821566784 18.190 100 21 42 1 1833559504 5275008 6717712
23:23:21 15032 8192000000 10749795552 11168305152 1812932048 18.120 99 17 34 0 1823244912 5222704 5090160
23:23:43 74742 8192000000 10765279440 11192610816 1840364400 18.344 100 26 52 0 1853466784 5401584 7700800
23:25:04 17157 8192000000 10759290128 11187392512 1846933776 18.397 100 24 48 1 1859589248 6126768 6528704
23:25:32 10095 8192000000 10777106928 11195482112 1852690432 18.444 100 38 76 1 1870206240 6473952 11041856
23:25:52 5294 8192000000 10782163408 11199012864 1855214512 18.464 100 31 61 3 1869574464 5595152 8764800
23:26:04 8472 8192000000 10781577152 11205898240 1862554864 18.524 100 30 60 2 1877578000 6947536 8075600
23:26:20 19580 8192000000 10784999312 11215761408 1869636464 18.581 100 34 67 1 1885646688 6003968 10006256
23:26:47 8178 8192000000 10786592928 11216687104 1873919424 18.616 100 26 52 2 1886854272 5313136 7621712
23:27:02 8295 8192000000 10804257376 11232587776 1884832992 18.704 100 23 46 1 1896945664 4845200 7267472
23:27:19 20074 8192000000 10817816160 11243130880 1899413152 18.822 100 29 57 4 1912596656 5237664 7945840
23:27:48 22894 8192000000 10833876832 11260284928 1911738480 18.921 100 41 82 1 1929365328 5811312 11815536
23:28:21 17090 8192000000 10860617456 11279159296 1924676896 19.024 100 49 98 2 1946406032 8552848 13176288
23:28:46 21309 8192000000 10859333840 11284381696 1930374480 19.070 100 42 84 0 1952095952 9154864 12566608
23:29:15 16277 8192000000 10869258384 11297763328 1934890944 19.106 100 40 80 1 1954925920 8374992 11659984
23:29:39 9123 8192000000 10878726208 11302240256 1941119552 19.156 100 45 90 1 1963907824 9971984 12816288
23:30:57 9634 8192000000 10875383136 11312693248 1949005120 19.219 100 37 73 2 1968999712 9204976 10789616
23:31:14 6543 8192000000 10884453552 11319332864 1955344704 19.269 100 43 86 1 1977164608 9384992 12434912
23:31:37 37963 8192000000 10892478112 11330269184 1957979296 19.290 100 35 70 1 1981641744 13466400 10196048
23:32:25 42566 8192000000 10891281728 11335356416 1963270496 19.332 100 25 50 0 1983976240 13004176 7701568
23:33:43 24387 8192000000 10906214224 11340713984 1942129168 19.164 98 44 88 2 1971609472 16222816 13257488
23:34:14 15655 8192000000 10910954752 11348959232 1974616288 19.422 100 43 85 2 2005115216 17156880 13342048
23:34:48 2160 8192000000 10918493104 11353403392 1981286752 19.475 100 37 74 0 2010408464 16926304 12195408
23:35:02 12140 8192000000 10934682912 11366715392 1989449728 19.539 100 48 96 2 2023205216 18902912 14852576
23:35:24 11753 8192000000 10945997360 11371786240 1992305088 19.562 100 61 122 1 2031736912 20343536 19088288
23:35:46 18597 8192000000 10936176896 11370762240 1975192640 19.427 99 51 99 2 2012262208 21392208 15677360
23:36:20 18460 8192000000 10945424512 11379724288 1995319408 19.586 100 47 94 0 2033371824 23292528 14759888
23:36:45 7114 8192000000 10945208480 11384041472 2001342192 19.633 100 49 98 1 2038039168 21411712 15285264
23:36:59 10061 8192000000 10946027440 11383623680 1986378448 19.515 99 64 121 3 2026462688 21723200 18361040
23:37:21 19529 8192000000 10946885888 11384086528 1979422576 19.460 99 52 102 1 2019861520 24890608 15548336
23:37:47 9150 8192000000 10949030208 11390488576 2000012192 19.623 100 53 108 2 2040999808 25288368 15699248
23:38:09 9789 8192000000 10954561472 11387883520 2003286576 19.649 100 55 109 1 2043722304 23940688 16495040
23:38:27 7670 8192000000 10950245008 11386646528 1989502112 19.540 99 61 117 2 2034158528 26606176 18050240
23:38:50 2573 8192000000 10968430288 11394138112 2003447472 19.650 100 72 145 0 2052999120 28011520 21540128
23:39:00 4994 8192000000 10983705744 11402362880 2009083664 19.694 100 81 162 0 2062879760 29659168 24136928
23:39:11 2160 8192000000 10970940432 11381436416 1994125296 19.576 99 82 164 3 2048063744 29815840 24122608
23:39:21 6401 8192000000 10955014608 11387449344 1983373200 19.491 99 74 147 2 2035441456 30152720 21915536
23:39:35 11049 8192000000 10968659616 11391066112 1999159360 19.616 100 72 141 1 2050866976 30729184 20978432
23:39:53 3264 8192000000 10978067696 11394064384 2003020640 19.647 100 84 168 3 2062547104 33196528 26329936
23:40:04 2388 8192000000 10990480272 11407818752 2010119248 19.702 100 86 170 0 2072988880 37945328 24924304
23:40:14 4075 8192000000 10965714256 11402575872 2004615888 19.659 100 63 122 1 2060196208 36009456 19570864
23:40:25 2161 8192000000 10968761840 11394510848 2001390256 19.634 100 76 152 0 2056693168 32206336 23096576
23:40:36 4138 8192000000 10970700416 11399819264 2002627632 19.643 100 69 136 0 2056514864 33317584 20569648
23:40:49 8504 8192000000 10957240752 11389177856 1990314848 19.546 100 66 131 0 2047846272 38254416 19277008
23:41:04 8545 8192000000 10976603088 11403100160 2004106640 19.655 100 70 140 0 2062109040 36804080 21198320
23:41:22 5171 8192000000 10963203456 11390697472 1989264352 19.538 100 72 144 0 2049868032 38403712 22199968
23:41:35 2902 8192000000 10972203136 11391873024 1992165792 19.561 100 78 155 1 2054869936 38005904 24698240
23:41:49 3204 8192000000 10978911520 11400060928 1995018976 19.583 100 70 139 1 2054610848 38315264 21276608
23:42:03 2025 8192000000 10993520560 11413618688 2007504112 19.682 100 72 145 1 2068786096 39042480 22239504
23:42:12 7285 8192000000 10971876624 11400232960 1997464512 19.603 100 79 156 1 2062842480 41366032 24011936
23:42:26 2490 8192000000 10991708192 11406524416 2003899328 19.653 100 78 154 1 2068644448 40046496 24698624
23:42:35 3735 8192000000 10987772960 11404824576 1996859136 19.598 100 83 168 1 2063489808 40574144 26056528
23:42:45 4227 8192000000 10960496336 11393667072 1992773536 19.566 100 66 132 1 2051086544 37723456 20589552
23:42:56 2671 8192000000 10951851936 11372818432 1960137488 19.307 99 82 165 0 2024571504 37808000 26626016
23:43:08 2884 8192000000 10934328336 11344609280 1949131536 19.220 99 81 161 0 2010760384 36146272 25482576
23:43:20 3460 8192000000 10928879520 11356815360 1959271408 19.300 100 64 129 6 2015897824 36864064 19762352
23:43:32 7380 8192000000 10950187280 11374129152 1969681888 19.383 100 67 133 2 2031632400 41251760 20698752
23:43:51 4545 8192000000 10933922128 11360317440 1945288208 19.189 99 60 116 0 2006162544 43307056 17567280
23:44:08 1387 8192000000 10952650896 11372261376 1971447584 19.397 100 83 166 1 2041524960 44168064 25909312
23:44:19 1419 8192000000 10963962896 11379494912 1979312448 19.459 100 86 170 1 2047074720 42182944 25579328
23:44:27 2982 8192000000 10964567904 11384430592 1980087632 19.465 100 81 161 2 2047468816 42936160 24445024
23:44:37 3438 8192000000 10956063312 11377479680 1974206816 19.419 100 72 141 1 2040614464 45130688 21276960
23:44:50 1582 8192000000 10976565296 11392933888 1981489984 19.476 100 79 158 0 2052795536 46140352 25165200
23:45:01 2370 8192000000 10978868256 11397824512 1991786080 19.558 100 75 151 0 2061131504 46674480 22670944
23:45:16 3965 8192000000 10966422752 11397677056 1986028144 19.512 100 56 110 1 2050634416 47437920 17168352
23:45:31 6832 8192000000 10935176784 11369025536 1944565360 19.183 98 53 105 2 2008282048 47360112 16356576
23:45:52 4868 8192000000 10950345040 11377856512 1952678592 19.248 99 60 118 2 2020935328 49376016 18880720
23:46:07 3454 8192000000 10926223888 11345186816 1939460304 19.142 99 74 147 0 2012850128 50432240 22957584
23:46:19 6563 8192000000 10920857872 11354861568 1928596800 19.056 99 47 92 3 1996586128 52451072 15538256
23:46:39 5675 8192000000 10926941776 11354890240 1944898400 19.186 100 47 93 1 2013012048 51864528 16249120
23:46:53 6144 8192000000 10939658720 11364704256 1933400288 19.094 99 56 111 1 2005364656 54365632 17598736
23:47:06 2522 8192000000 10964451744 11376750592 1961198256 19.316 100 81 159 1 2042216976 55300128 25718592
23:47:16 5918 8192000000 10970181088 11384635392 1970028432 19.386 100 79 159 1 2050162992 54636544 25498016
23:47:29 2394 8192000000 10971074496 11379032064 1947480032 19.206 99 92 186 1 2031847120 55559984 28807104
23:47:38 3233 8192000000 10972231744 11380244480 1964253312 19.340 100 77 154 0 2045637376 57127584 24256480
23:47:49 1433 8192000000 10978657264 11389919232 1973443328 19.413 100 91 179 3 2060351296 58433840 28474128
23:47:57 2940 8192000000 10989529200 11401285632 1978018640 19.449 100 94 188 1 2066565232 59708656 28837936
23:48:08 2850 8192000000 10983676864 11404386304 1979812480 19.463 100 87 173 2 2065752544 58714880 27225184
23:48:20 3679 8192000000 10989111072 11406192640 1986158624 19.513 100 74 148 2 2066642560 57004736 23479200
23:48:30 2551 8192000000 10956343120 11373056000 1961218304 19.316 99 71 142 1 2034079120 50992896 21867920
23:48:44 8959 8192000000 10953549152 11394732032 1977023504 19.441 100 46 92 0 2043801904 51881088 14897312
23:49:04 12377 8192000000 10950415216 11394945024 1977587824 19.446 100 32 65 1 2040804032 52401840 10814368
23:49:28 5150 8192000000 10960545712 11391627264 1976103120 19.434 100 56 112 2 2044267120 50324304 17839696
23:49:40 5144 8192000000 10938548144 11371839488 1932696160 19.088 98 45 87 1 1998054288 50636880 14721248
23:49:56 11583 8192000000 10933295008 11370377216 1949735232 19.224 100 36 71 2 2013346000 51756544 11854224
23:50:31 11040 8192000000 10921524320 11346870272 1924376144 19.022 99 34 68 0 1985735536 50050144 11309248
23:51:04 7001 8192000000 10918833552 11347410944 1929181264 19.060 100 47 94 0 1999730544 54395168 16154112
23:51:22 4412 8192000000 10941445552 11358638080 1926735360 19.041 99 57 113 1 2002196128 57364592 18096176
23:51:35 1815 8192000000 10933248768 11351404544 1916967200 18.963 98 67 135 0 2000374032 61701744 21705088
23:51:44 6535 8192000000 10956348960 11383595008 1958116480 19.291 100 54 107 0 2038458384 63233248 17108656
23:51:57 4288 8192000000 10945222576 11381796864 1957052144 19.283 100 42 84 1 2026531664 55686736 13792784
23:52:12 8108 8192000000 10939922560 11384188928 1962392176 19.325 100 41 82 1 2028875952 53214640 13269136
23:52:33 17072 8192000000 10944673360 11389198336 1967363120 19.365 100 40 79 1 2033515472 53311856 12840496
23:52:59 11393 8192000000 10947874160 11397197824 1970533648 19.390 100 30 60 0 2030746192 49696112 10516432
23:53:19 19443 8192000000 10937902544 11397382144 1969916944 19.385 100 22 44 1 2021654432 43748592 7988896
23:53:46 18773 8192000000 10942133664 11389353984 1965641904 19.351 100 22 44 0 2017157696 43726304 7789488
23:54:20 22050 8192000000 10941759056 11396775936 1963135088 19.331 100 27 54 3 2025673312 51857312 10680912
23:54:49 26315 8192000000 10940436704 11394789376 1960852288 19.313 100 23 46 1 2026530896 56662320 9016288
23:55:40 30749 8192000000 10934863696 11375775744 1943140480 19.172 100 19 38 0 2003323872 52574000 7609392
23:56:20 20924 8192000000 10921392224 11381444608 1952678768 19.248 100 25 50 1 2010552288 48950432 8923088
23:56:47 19535 8192000000 10920497568 11381522432 1961016320 19.314 100 19 38 0 2010375312 42696704 6662288
23:57:13 21001 8192000000 10919658576 11382235136 1969468528 19.381 100 18 35 1 2005738336 30287952 5981856
23:57:50 32497 8192000000 10923308592 11371921408 1965556608 19.350 99 37 73 3 1985309872 8660256 11093008
23:58:34 38693 8192000000 10875618448 11338121216 1932753808 19.089 98 16 32 1 1948627344 11764720 4108816
23:59:21 124807 8192000000 10902123376 11347505152 1923047488 19.011 97 21 41 0 1944396800 15688096 5661216
00:01:39 33066 8192000000 10925188704 11359014912 1962218448 19.324 99 59 118 1 1985930528 6202864 17509216
00:02:18 5071 8192000000 10916411712 11364327424 1977779456 19.447 100 65 130 0 2005696784 9133024 18784304
00:02:36 106076 8192000000 10879403296 11341856768 1920433696 18.990 97 26 53 0 1940254816 12325040 7496080
00:04:33 42896 8192000000 10886761200 11346030592 1946424896 19.198 99 23 46 2 1964200336 11221584 6553856
00:05:22 122980 8192000000 10881939712 11351715840 1908253824 18.893 97 17 34 1 1927359664 14548112 4557728
00:07:48 122116 8192000000 10876542032 11329609728 1905505936 18.871 97 23 46 0 1923502256 11794896 6201424
00:09:56 15024 8192000000 10898130224 11352002560 1963585808 19.335 100 51 103 1 1990489632 11535504 15368320
00:10:20 31370 8192000000 10897785056 11358191616 1947515680 19.207 99 19 38 0 1964048672 11293824 5239168
00:11:42 65649 8192000000 10894365056 11363168256 1953190704 19.252 99 13 26 0 1973289744 16108208 3990832
00:12:54 104388 8192000000 10895866464 11373174784 1950279696 19.229 99 14 28 0 1969574272 14797248 4497328
00:15:45 82119 8192000000 10897042256 11381104640 1975788272 19.431 100 9 16 2 1992105728 14225520 2091936
00:17:15 1469 8192000000 10911926144 11385245696 1984061216 19.497 100 23 46 0 2005044112 13535040 7447856
00:17:25 8122 8192000000 10909373952 11364974592 1975528688 19.429 100 50 100 3 2003906192 14189984 14187520
00:17:47 37755 8192000000 10907860176 11367583744 1952824704 19.249 99 29 58 0 1982033536 19896192 9312640
00:18:39 32392 8192000000 10887126624 11364470784 1947518624 19.207 99 24 47 1 1969791680 14836832 7436224
00:19:21 51969 8192000000 10886093648 11357249536 1926274752 19.037 98 17 35 1 1948502784 16721856 5506176
00:20:21 81906 8192000000 10879536624 11359248384 1938760288 19.137 99 10 20 1 1959082704 17337936 2984480
00:21:50 66212 8192000000 10896873072 11369820160 1964113024 19.339 100 14 27 1 1987323024 19260768 3949232
00:23:27 79485 8192000000 10891750080 11378008064 1954142848 19.259 99 15 30 3 1977594448 18972624 4478976
00:25:50 25148 8192000000 10893603696 11360145408 1958759792 19.296 99 26 51 3 1971846432 6332752 6753888
00:26:25 39485 8192000000 10887227056 11352129536 1959835072 19.305 100 24 48 0 1974716112 8041024 6840016
00:27:11 78226 8192000000 10880608080 11349102592 1862909408 18.527 94 20 40 0 1875504288 7454928 5139952
00:28:35 31955 8192000000 10895131328 11350683648 1927789280 19.049 98 28 54 5 1944067552 8810512 7467760
00:29:24 44229 8192000000 10866816016 11332800512 1883752976 18.695 96 23 46 1 1907254544 17445248 6056320
00:30:14 70128 8192000000 10850293168 11317092352 1810720384 18.102 93 19 38 0 1830463168 14848800 4893984
00:31:35 80110 8192000000 10871470528 11331608576 1886231264 18.715 97 12 24 1 1898814816 9400848 3182704
00:33:06 41543 8192000000 10898909728 11352121344 1922686048 19.008 98 28 56 0 1939027504 8716112 7625344
00:33:57 89380 8192000000 10887054704 11364179968 1907543648 18.887 97 21 42 0 1929866752 16557632 5765472
00:35:34 60536 8192000000 10874975984 11339603968 1895935600 18.794 97 21 41 2 1916229280 14639360 5654320
00:37:31 68323 8192000000 10891548960 11385692160 1938044784 19.131 99 10 20 0 1968787056 27654848 3087424
00:38:48 163658 8192000000 10844107568 11304038400 1717344768 17.330 88 7 13 0 1738356640 19172528 1839344
00:41:54 35899 8192000000 10848428960 11285028864 1874671536 18.622 97 49 92 5 1894904272 5569824 14662912
00:42:38 69959 8192000000 10848537536 11298742272 1871199200 18.594 97 33 66 1 1888544336 7834736 9510400
00:44:25 10804 8192000000 10852977168 11311439872 1928472320 19.055 100 39 77 1 1949309504 10456096 10381088
00:44:42 18879 8192000000 10871705248 11320279040 1901831264 18.841 98 40 78 1 1921802816 8834048 11137504
00:45:08 1579 8192000000 10886402192 11328364544 1941661680 19.160 100 52 103 0 1966145024 10412272 14071072
00:45:17 44879 8192000000 10863160384 11329015808 1922106800 19.004 99 14 28 1 1934202624 6912832 5182992
00:46:11 76792 8192000000 10837260928 11314069504 1878506512 18.653 97 10 20 0 1890587088 9258896 2821680
00:47:40 55244 8192000000 10852065424 11326189568 1920411936 18.990 99 11 22 0 1931856320 8150048 3294336
00:48:42 68740 8192000000 10845364496 11319775232 1886333152 18.716 97 13 24 1 1897285920 7605712 3347056
00:50:05 49188 8192000000 10841876656 11323215872 1930329168 19.070 100 7 14 1 1940910080 8757952 1822960
00:51:00 10089 8192000000 10845047792 11324801024 1931778256 19.081 100 6 12 0 1941951584 8542144 1631184
00:51:33 93535 8192000000 10858448560 11337932800 1907211008 18.884 98 14 28 0 1921894992 10706224 3977760
00:53:18 52215 8192000000 10877354784 11346087936 1927275744 19.045 99 9 18 0 1939638928 9959360 2403824
00:54:21 39824 8192000000 10888817200 11359436800 1962534096 19.326 100 21 42 1 1977660064 9062448 6063520
00:55:18 37293 8192000000 10894711264 11363053568 1930447568 19.070 98 27 54 1 1949124624 10880176 7796880
00:56:02 64788 8192000000 10891414624 11374755840 1967829024 19.368 100 21 42 0 1986651088 12680896 6141168
00:57:13 37986 8192000000 10913425424 11391373312 1963246768 19.332 99 17 34 2 1985000272 17083680 4669824
00:57:58 52893 8192000000 10927817120 11391283200 1969694288 19.383 99 21 42 1 1992475520 16817840 5963392
00:59:12 77619 8192000000 10909755872 11390414848 1960152304 19.307 99 20 40 1 1981762208 15635008 5974896
01:00:38 89365 8192000000 10891019184 11372265472 1913620432 18.936 97 13 26 0 1933143216 15896672 3626112
01:02:19 43473 8192000000 10912630240 11356540928 1935532336 19.111 98 42 84 1 1957955792 10737184 11686272
01:03:08 16232 8192000000 10912726768 11360710656 1964986688 19.346 100 39 78 0 1985425712 9199424 11239600
01:03:32 25760 8192000000 10914864864 11376099328 1976101456 19.434 100 42 84 0 1998970816 11433552 11435808
01:04:05 43672 8192000000 10920220704 11376013312 1941071248 19.155 98 36 72 3 1966389728 15505312 9813168
01:04:57 38229 8192000000 10913980112 11367477248 1920737216 18.993 97 42 85 1 1943063456 10303504 12022736
01:05:43 43749 8192000000 10917980896 11374821376 1970488096 19.389 100 31 62 0 1990291616 11210048 8593472
01:06:33 40292 8192000000 10925679344 11375775744 1958430576 19.294 99 44 88 2 1985620000 14809472 12379952
01:07:20 27786 8192000000 10901240352 11363315712 1928948752 19.058 98 37 74 1 1958808832 19056528 10803552
01:08:03 136102 8192000000 10852395888 11322732544 1883865088 18.696 97 22 44 1 1901620672 11154016 6601568
01:10:32 42669 8192000000 10882242848 11345510400 1953551296 19.255 100 32 63 1 1969340560 7045520 8743744
01:11:30 56671 8192000000 10891903824 11363098624 1958656784 19.295 100 20 40 2 1977373184 13093408 5622992
01:12:33 46683 8192000000 10873446928 11360837632 1938231632 19.133 99 8 16 2 1955806448 15532464 2042352
01:13:26 30489 8192000000 10876539344 11366256640 1952047552 19.243 100 5 10 0 1969408400 16207952 1152896
01:14:02 1923 8192000000 10876660768 11366248448 1955158304 19.268 100 5 10 0 1973069088 16646336 1264448
01:14:11 59213 8192000000 10873103072 11360092160 1955149488 19.267 100 16 31 1 1972623856 12752864 4721504
01:15:58 71774 8192000000 10851699600 11328925696 1892295008 18.764 97 11 22 2 1906632560 11033360 3304192
01:17:19 86049 8192000000 10869972512 11357421568 1930332064 19.070 99 18 37 0 1947517584 11873408 5312112
01:18:51 36103 8192000000 10867363072 11330232320 1898081968 18.811 97 30 61 0 1915915312 9272176 8561168
01:19:34 32952 8192000000 10851615472 11307360256 1861027632 18.512 96 27 53 1 1875009088 6927008 7054448
01:20:23 69021 8192000000 10866549632 11332096000 1901051040 18.835 98 37 71 3 1924745232 12447024 11247168
01:21:54 112954 8192000000 10840238096 11334987776 1856897056 18.478 96 13 26 1 1877399808 16651344 3851408
01:24:05 89931 8192000000 10863494928 11335409664 1889736176 18.744 98 15 30 1 1905993440 12287552 3969712
01:25:41 27596 8192000000 10867651088 11319394304 1898512160 18.814 98 28 56 1 1920812064 14398384 7901520
01:26:20 65069 8192000000 9839397984 10199539712 919969008 10.096 48 10 19 0 933692304 10899600 2823696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-03-2021 01:28:23 to 20-03-2021 01:28:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 76 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2021 01:28:55 to 20-03-2021 01:28:57.

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          240429
MON$OLDEST_ACTIVE               241163
MON$OLDEST_SNAPSHOT             241163
MON$NEXT_TRANSACTION            241163
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                       2034912
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:49: 
:50: mscs-test-161.budzdorov.ru    Sat Mar 20 01:27:37 2021
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Sat Mar 20 01:27:38 2021
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
--- end of diff output ---

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

20.03.21 01:28:58. 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-20 01:29:01 No severe PSQL-related problems occured
20.03.21 01:29:02. End of report.