Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.02.2021 01: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 17265412 kB
MemAvailable 31133432 kB
Buffers 0 kB
Cached 14436872 kB
SwapCached 3892 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-21 01:27:19
DTS_END                         2021-02-21 01:27:19.8210
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/33936
TRN_ID                          231719
ATT_ID                          648
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: 8882.49 20170 1065899
customer order: creation 168.61 382 20233
customer order: refuse 14.57 338 1748
order to supplier: creation 45.54 1235 5465
order to supplier: removal 3.46 106100 415
invoice (draft): creation 45.18 3353 5422
invoice (draft): removal 50.64 757 6077
invoice accept: apply 40.81 18984 4897
invoice accept: cancel 45.35 859 5442
customer reserve: creation 3720.47 188 446456
customer reserve: removal 4461.01 66 535321
realization accept: apply 83.37 184 10004
realization accept: cancel 77.16 126 9259
payment from customer: creation 57.08 123 6849
payment from customer: removal 5.49 82 659
payment to supplier: creation 48.08 132 5769
payment to supplier: removal 3.27 62 392
service: total inventory turnovers 4.60 990 552
service: total monetary turnovers 6.88 33 825
service: aggregate perf. data 0.92 18298 110
service: refresh index statistics 0.03 251115 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-02-2021 01:28:41 to 21-02-2021 01:28:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4567
TEST_TIME 2 6447
TEST_TIME 3 5578
TEST_TIME 4 5313
TEST_TIME 5 5703
TEST_TIME 6 5760
TEST_TIME 7 6215
TEST_TIME 8 6317
TEST_TIME 9 6879
TEST_TIME 10 6681
TEST_TIME 11 6747
TEST_TIME 12 7182
TEST_TIME 13 7215
TEST_TIME 14 7516
TEST_TIME 15 7557
TEST_TIME 16 7735
TEST_TIME 17 7695
TEST_TIME 18 7898
TEST_TIME 19 8108
TEST_TIME 20 8716
TEST_TIME 21 8978
TEST_TIME 22 9372
TEST_TIME 23 9591
TEST_TIME 24 9592
TEST_TIME 25 10087
TEST_TIME 26 10484
TEST_TIME 27 10885
TEST_TIME 28 10772
TEST_TIME 29 10626
TEST_TIME 30 10518
TEST_TIME 31 10205
TEST_TIME 32 10037
TEST_TIME 33 9868
TEST_TIME 34 9653
TEST_TIME 35 9712
TEST_TIME 36 9490
TEST_TIME 37 9526
TEST_TIME 38 9540
TEST_TIME 39 9472
TEST_TIME 40 9596
TEST_TIME 41 9453
TEST_TIME 42 9351
TEST_TIME 43 9282
TEST_TIME 44 9233
TEST_TIME 45 9175
TEST_TIME 46 9073
TEST_TIME 47 9067
TEST_TIME 48 9010
TEST_TIME 49 8944
TEST_TIME 50 8779
TEST_TIME 51 8919
TEST_TIME 52 8913
TEST_TIME 53 8872
TEST_TIME 54 8914
TEST_TIME 55 8941
TEST_TIME 56 8958
TEST_TIME 57 9006
TEST_TIME 58 9033
TEST_TIME 59 9078
TEST_TIME 60 9056
TEST_TIME 61 9125
TEST_TIME 62 9349
TEST_TIME 63 9296
TEST_TIME 64 9345
TEST_TIME 65 9308
TEST_TIME 66 9198
TEST_TIME 67 9143
TEST_TIME 68 9149
TEST_TIME 69 9172
TEST_TIME 70 9116
TEST_TIME 71 9049
TEST_TIME 72 8986
TEST_TIME 73 8897
TEST_TIME 74 8981
TEST_TIME 75 8938
TEST_TIME 76 8927
TEST_TIME 77 9011
TEST_TIME 78 8991
TEST_TIME 79 9049
TEST_TIME 80 9067
TEST_TIME 81 9060
TEST_TIME 82 9064
TEST_TIME 83 9086
TEST_TIME 84 9143
TEST_TIME 85 9155
TEST_TIME 86 9193
TEST_TIME 87 9199
TEST_TIME 88 9101
TEST_TIME 89 9073
TEST_TIME 90 9019
TEST_TIME 91 9084
TEST_TIME 92 9041
TEST_TIME 93 8987
TEST_TIME 94 8949
TEST_TIME 95 8913
TEST_TIME 96 8923
TEST_TIME 97 8950
TEST_TIME 98 8942
TEST_TIME 99 9014
TEST_TIME 100 8986
TEST_TIME 101 8974
TEST_TIME 102 8997
TEST_TIME 103 9088
TEST_TIME 104 9084
TEST_TIME 105 9083
TEST_TIME 106 9129
TEST_TIME 107 9154
TEST_TIME 108 9106
TEST_TIME 109 9026
TEST_TIME 110 8972
TEST_TIME 111 8981
TEST_TIME 112 8954
TEST_TIME 113 8899
TEST_TIME 114 8862
TEST_TIME 115 8839
TEST_TIME 116 8790
TEST_TIME 117 8807
TEST_TIME 118 8846
TEST_TIME 119 8951
TEST_TIME 120 8892

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2021 01:28:45 to 21-02-2021 01:28:48.

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 1478974 1478974 0 0.00 0 21401 7 0 0
doc_list_biud 1478973 1478973 0 0.00 0 39893 30 0 0
sp_add_invoice_to_stock 4999 4897 102 2.04 27 234711 18985 0 102
sp_cancel_adding_invoice 5442 5442 0 0.00 5 63968 859 0 0
sp_cancel_client_order 1748 1748 0 0.00 4 9139 339 0 0
sp_cancel_customer_reserve 535321 535321 0 0.00 1 28117 67 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 3 4899 82 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 1241 62 0 0
sp_cancel_supplier_invoice 6092 6077 15 0.24 1 11667 757 0 15
sp_cancel_supplier_order 415 415 0 0.00 10 1037113 106101 0 0
sp_cancel_write_off 9259 9259 0 0.00 1 7833 127 0 0
sp_client_order 20233 20233 0 0.00 3 20005 383 0 0
sp_customer_reserve 446456 446456 0 0.00 0 38721 189 0 0
sp_fill_shopping_cart 31120 31120 0 0.00 1 22958 42 0 0
sp_fill_shopping_cart_clo_res 446450 446450 0 0.00 0 19050 15 0 0
sp_get_clo_for_invoice 4872 4872 0 0.00 0 37317 408 0 0
sp_kill_cost_storno 15752 15752 0 0.00 0 5142 59 0 0
sp_kill_qstorno_ret_qs2qd 1086393 1086393 0 0.00 0 20677 35 0 0
sp_kill_qty_storno 573134 573134 0 0.00 0 39892 76 0 0
sp_lock_selected_doc 20556 20556 0 0.00 0 5772 5 0 0
sp_make_cost_storno 27490 27490 0 0.00 0 21062 61 0 0
sp_multiply_rows_for_pdistr 27490 27490 0 0.00 0 7310 32 0 0
sp_multiply_rows_for_qdistr 20233 20233 0 0.00 0 19988 203 0 0
sp_pay_from_customer 6849 6849 0 0.00 4 18555 123 0 0
sp_pay_to_supplier 5769 5769 0 0.00 5 13794 132 0 0
sp_payment_common 12618 12618 0 0.00 1 18540 34 0 0
sp_qd_handle_on_cancel_clo 1748 1748 0 0.00 0 9131 313 0 0
sp_qd_handle_on_invoice_upd_sts 10310 10310 0 0.00 0 39892 360 0 0
sp_qd_handle_on_reserve_upd_sts 10004 10004 0 0.00 0 17831 51 0 0
sp_reserve_write_off 10004 10004 0 0.00 6 20459 185 0 0
sp_supplier_invoice 5422 5422 0 0.00 6 69262 3353 0 0
sp_supplier_order 5465 5465 0 0.00 4 57956 1235 0 0
srv_aggregate_perf_data 110 110 0 0.00 2356 181411 18298 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1068 140796 30414 0 0
srv_find_qd_qs_mism 1019222 1019222 0 0.00 0 8003 6 0 0
srv_make_invnt_saldo 552 552 0 0.00 30 21401 990 0 0
srv_make_money_saldo 825 825 0 0.00 1 6849 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 174511 330887 251115 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4897 4897 0 0.00 0 12950 193 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 6369 98 0 0
t$perf-norm:sp_cancel_client_order 1748 1748 0 0.00 0 647 9 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 7127 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 2124 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 1069 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 3922 33 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 26644 1685 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 2167 13 0 0
t$perf-norm:sp_client_order 20233 20233 0 0.00 0 7725 20 0 0
t$perf-norm:sp_customer_reserve 956 956 0 0.00 0 4023 13 0 0
t$perf-norm:sp_pay_from_customer 6849 6849 0 0.00 0 8571 12 0 0
t$perf-norm:sp_pay_to_supplier 5769 5769 0 0.00 0 7497 13 0 0
t$perf-norm:sp_reserve_write_off 10004 10004 0 0.00 0 7796 12 0 0
t$perf-norm:sp_supplier_invoice 5422 5422 0 0.00 0 5708 19 0 0
t$perf-norm:sp_supplier_order 5465 5465 0 0.00 0 7286 22 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 479 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 3047 20 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 3479 34 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 3307 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9940 9736 204 2.05 0 4574 19 0 204
v_all_customers 36316 36316 0 0.00 0 52 1 0 0
v_all_suppliers 30144 30144 0 0.00 0 19 1 0 0
v_all_wares 40466 40466 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 631 7 0 0
v_cancel_client_order 3496 3496 0 0.00 0 2585 4 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 3420 7 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 3053 8 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 654 4 0 0
v_cancel_supplier_invoice 812 782 30 3.69 0 558 15 0 30
v_cancel_supplier_order 830 830 0 0.00 0 4414 11 0 0
v_cancel_write_off 2012 2012 0 0.00 0 2714 15 0 0
v_max_id_clo_ord 5465 5465 0 0.00 0 488 1 0 0
v_max_id_clo_res 956 956 0 0.00 0 7743 22 0 0
v_max_id_ord_sup 5422 5422 0 0.00 0 2806 4 0 0
v_max_non_paid_invoice 1584 1584 0 0.00 0 1323 3 0 0
v_max_non_paid_realizn 3792 3792 0 0.00 0 3835 6 0 0
v_min_id_clo_ord 5465 5465 0 0.00 0 3161 8 0 0
v_min_id_clo_res 956 956 0 0.00 0 1633 6 0 0
v_min_id_ord_sup 5422 5422 0 0.00 0 6492 7 0 0
v_min_non_paid_invoice 5769 5769 0 0.00 0 13763 20 0 0
v_min_non_paid_realizn 6849 6849 0 0.00 0 18533 22 0 0
v_our_firm 10264 10264 0 0.00 0 23 1 0 0
v_reserve_write_off 20008 20008 0 0.00 0 4971 5 0 0
x_lock_depdocs_on_canc_invoice 11128 11128 0 0.00 0 19400 134 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 9295 353 0 0
x_make_qstorno_1000_1200 5465 5465 0 0.00 1 57939 1146 0 0
x_make_qstorno_1200_2000 5422 5422 0 0.00 3 69237 3206 0 0
x_make_qstorno_2100_3300 446456 446456 0 0.00 0 35461 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2021 01:28:49 to 21-02-2021 01:28:53.

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:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:29 8698 8192000000 10195053712 10494332928 807818864 8.975 64 59 119 1 830953520 2399424 20735232
22:57:47 24526 8192000000 10305865808 10617618432 1360177136 14.239 100 84 168 0 1392762016 4687504 27897376
22:58:29 24957 8192000000 10358923184 10682851328 1412010944 14.702 100 84 168 1 1445446928 6215856 27220128
22:59:04 17377 8192000000 10394990720 10720243712 1443058992 14.977 100 86 172 0 1479801808 7479024 29263792
22:59:37 25020 8192000000 10422376192 10751901696 1471546288 15.227 100 86 172 0 1507954672 8461968 27946416
23:00:25 13642 8192000000 10447927584 10779594752 1500245296 15.478 100 91 182 0 1539723712 9729552 29748864
23:00:52 19927 8192000000 10456129984 10796318720 1510772768 15.570 100 85 169 1 1547514160 9816144 26925248
23:01:23 14008 8192000000 10486067904 10828918784 1534505712 15.776 100 82 164 0 1570076272 9947376 25623184
23:01:48 16474 8192000000 10502559440 10849947648 1555904112 15.961 100 81 162 0 1591861552 10917792 25039648
23:02:19 13759 8192000000 10541454016 10892517376 1590084272 16.255 100 83 166 2 1626621088 11827744 24709072
23:02:46 6660 8192000000 10553375152 10910187520 1614889392 16.466 100 83 166 0 1651966032 12401616 24675024
23:03:02 8567 8192000000 10572219184 10928496640 1622625408 16.532 100 80 159 0 1658235408 12023328 23586672
23:03:20 15676 8192000000 10584653600 10945863680 1643256464 16.707 100 85 166 2 1681556384 12740000 25559920
23:03:44 11914 8192000000 10608575808 10972966912 1665025920 16.891 100 78 156 0 1700492816 12870704 22596192
23:04:03 13811 8192000000 10622893376 10990563328 1682533840 17.039 100 84 168 2 1719838496 13149872 24154784
23:04:25 10390 8192000000 10642910912 11010686976 1703326864 17.213 100 90 180 1 1743538992 14184208 26027920
23:04:43 7370 8192000000 10654640864 11021705216 1710415520 17.272 100 84 168 1 1748841760 13983568 24442672
23:04:58 8472 8192000000 10663640208 11035889664 1719654208 17.349 100 85 170 0 1758886080 14516160 24715712
23:05:14 6076 8192000000 10670846864 11042947072 1731564624 17.449 100 78 156 1 1766915568 12831168 22519776
23:05:28 4669 8192000000 10674872512 11052376064 1739235408 17.512 100 82 163 2 1775350752 13060976 23054368
23:05:40 4623 8192000000 10696874624 11073335296 1750410464 17.605 100 78 157 0 1784252368 12299376 21542528
23:05:51 4438 8192000000 10704087008 11077660672 1763286416 17.712 100 80 158 3 1797196912 11259424 22651072
23:06:03 3494 8192000000 10708184592 11083907072 1769307760 17.761 100 78 157 0 1803492928 11520432 22664736
23:06:13 4163 8192000000 10717919232 11095764992 1776906960 17.824 100 76 152 0 1811523872 13219024 21397888
23:06:24 2577 8192000000 10723172640 11100340224 1785554048 17.895 100 84 164 3 1822208864 13562832 23091984
23:06:34 3104 8192000000 10729597072 11110035456 1793348224 17.959 100 92 183 2 1832527584 13571584 25607776
23:06:44 9040 8192000000 10733400576 11112910848 1795544016 17.977 100 85 170 0 1834174112 14590848 24039248
23:06:59 4331 8192000000 10740848528 11124711424 1797778112 17.996 100 78 156 2 1833796880 14735184 21283584
23:07:10 2308 8192000000 10762724320 11143094272 1816665024 18.150 100 94 187 0 1857460560 14801088 25994448
23:07:19 2396 8192000000 10762557600 11145609216 1819593984 18.174 100 89 178 1 1859386400 14341904 25450512
23:07:28 2089 8192000000 10775922368 11157581824 1830783376 18.266 100 89 177 1 1869853216 14408240 24661600
23:07:36 3478 8192000000 10775624112 11160129536 1836740752 18.314 100 93 185 0 1876484944 13348160 26396032
23:07:46 2345 8192000000 10784556640 11168972800 1841411616 18.352 100 90 178 2 1880553424 14041040 25100768
23:07:55 1893 8192000000 10783128752 11169898496 1840505344 18.345 100 88 176 0 1880172608 13887840 25779424
23:08:03 2156 8192000000 10783905456 11170631680 1843321680 18.368 100 87 175 1 1880250512 11972464 24956368
23:08:12 1820 8192000000 10782586352 11171319808 1846693264 18.395 100 87 174 0 1885207472 13270544 25243664
23:08:20 1418 8192000000 10791908896 11179962368 1850464592 18.426 100 96 190 3 1889775552 12856080 26454880
23:08:28 2881 8192000000 10799268512 11184881664 1852370496 18.441 100 90 180 1 1892367472 14050352 25946624
23:08:38 2173 8192000000 10793387904 11185549312 1854142096 18.456 100 89 177 2 1892797776 13914016 24741664
23:08:46 2208 8192000000 10807324848 11190231040 1857345968 18.482 100 94 188 0 1898231936 14662096 26223872
23:08:55 2875 8192000000 10803580640 11188461568 1856683200 18.476 100 86 172 2 1895260832 14848928 23728704
23:09:04 2694 8192000000 10809253200 11198119936 1862131312 18.521 100 90 180 0 1902722816 14964064 25627440
23:09:14 7320 8192000000 10804395120 11193917440 1860719040 18.509 100 77 152 2 1896046992 13483088 21844864
23:09:27 1065 8192000000 10818405888 11206901760 1870402528 18.588 100 97 194 2 1910769792 12940176 27427088
23:09:35 20569 8192000000 10787116032 11192053760 1860516784 18.507 100 42 84 2 1879650560 6724800 12408976
23:10:02 5775 8192000000 10796249424 11202084864 1866173232 18.553 100 50 99 4 1888610704 7995072 14442400
23:10:14 3483 8192000000 10790997088 11203100672 1869461024 18.580 100 42 84 2 1891384656 9774080 12149552
23:10:27 4182 8192000000 10795612400 11209469952 1874906560 18.624 100 49 97 0 1897232448 9400912 12924976
23:10:38 4049 8192000000 10798304432 11209850880 1875696160 18.630 100 44 89 2 1896799744 9141344 11962240
23:10:48 6233 8192000000 10787655664 11208810496 1878283312 18.651 100 40 80 1 1898018624 8057472 11677840
23:11:03 1730 8192000000 10824354880 11224547328 1886329616 18.716 100 65 131 1 1911455056 6335472 18789968
23:11:12 7552 8192000000 10784509392 11217096704 1880561840 18.670 100 24 49 1 1893910496 6728304 6620352
23:11:27 4619 8192000000 10791846656 11219615744 1884748896 18.703 100 37 73 1 1903342640 7534416 11059328
23:11:39 8038 8192000000 10810327280 11223068672 1883083568 18.690 100 20 40 0 1894258912 5352224 5823120
23:11:54 11738 8192000000 10795172640 11227725824 1889670064 18.743 100 30 58 2 1904875504 6767264 8438176
23:12:12 13745 8192000000 10794805440 11231010816 1891595472 18.759 100 18 36 0 1903264144 6887392 4781280
23:12:32 22187 8192000000 10800589024 11239583744 1896318336 18.797 100 29 58 3 1915087488 10530464 8238688
23:13:33 16797 8192000000 10816586768 11247181824 1898043840 18.811 100 29 59 1 1917434512 10658624 8732048
23:13:58 2566 8192000000 10830622736 11250524160 1902463136 18.846 100 47 92 1 1923112928 7574704 13075088
23:14:07 3641 8192000000 10835367168 11252215808 1905386656 18.870 100 43 86 2 1925148576 7911248 11850672
23:14:17 5893 8192000000 10825351744 11252264960 1904353168 18.861 100 40 80 4 1924030192 7695536 11981488
23:14:31 4665 8192000000 10819344848 11251130368 1902098176 18.843 100 27 53 1 1916841824 6954944 7788704
23:14:43 4014 8192000000 10841828320 11256410112 1904908832 18.866 100 35 71 2 1921428336 4975200 11544304
23:14:55 8679 8192000000 10822029472 11253645312 1902191040 18.844 100 15 30 0 1912370368 6080192 4099136
23:15:11 7854 8192000000 10820049072 11253043200 1904609600 18.863 100 27 54 0 1919249472 6569632 8070240
23:15:25 5689 8192000000 10825019296 11254538240 1904828672 18.865 100 26 50 2 1917804176 5320144 7655360
23:15:38 9050 8192000000 10814544320 11249467392 1901248048 18.836 100 23 44 1 1914014160 6605760 6160352
23:15:53 11181 8192000000 10827433968 11263938560 1902434096 18.846 100 19 38 0 1917851728 9817232 5600400
23:16:10 6122 8192000000 10833215408 11266699264 1908976512 18.898 100 11 22 0 1917465824 5282592 3206720
23:16:24 8766 8192000000 10833036496 11269562368 1913912240 18.938 100 23 47 1 1926119520 5800240 6407040
23:16:39 6957 8192000000 10829211968 11268034560 1915645968 18.952 100 24 48 0 1928806976 6652976 6508032
23:16:53 23655 8192000000 10806532208 11239698432 1867143616 18.561 98 22 44 2 1880513280 5679616 7690048
23:17:51 16909 8192000000 10786943168 11213619200 1815878912 18.144 96 43 86 2 1838958864 11174816 11905136
23:18:14 8542 8192000000 10791335440 11214802944 1840238624 18.343 98 24 48 2 1853022912 4790128 7994160
23:18:30 4220 8192000000 10790591664 11221635072 1873746400 18.615 100 29 59 1 1888465472 6215248 8503824
23:18:40 5340 8192000000 10826670112 11241193472 1889863568 18.745 100 46 92 1 1909823040 7119104 12840368
23:18:52 4254 8192000000 10757206496 11183636480 1805779824 18.061 97 36 72 2 1823165056 6924432 10460800
23:19:04 4536 8192000000 10758768320 11177807872 1824455520 18.214 99 27 54 0 1839234752 7331264 7447968
23:19:16 5794 8192000000 10737254736 11154259968 1785113456 17.892 97 26 50 3 1798083536 6316000 6654080
23:19:28 6010 8192000000 10715368384 11118800896 1732043232 17.452 95 37 71 2 1747510112 5218480 10248400
23:19:44 4571 8192000000 10739537616 11149352960 1796450416 17.985 99 43 86 0 1816249472 7298656 12500400
23:19:54 8888 8192000000 10742302528 11160035328 1789524352 17.928 98 18 36 0 1799378352 5174208 4679792
23:20:10 5086 8192000000 10753421296 11170402304 1821481408 18.190 99 25 51 1 1835100272 5715488 7903376
23:20:24 7342 8192000000 10717203840 11129184256 1746523776 17.573 96 16 31 2 1756442992 5176096 4743120
23:20:42 11155 8192000000 10716063168 11140796416 1772661008 17.789 98 14 28 0 1781979792 5423632 3895152
23:21:02 10356 8192000000 10703249696 11114127360 1698731408 17.174 94 27 53 2 1712521296 5430608 8359280
23:21:24 9134 8192000000 10686508736 11095379968 1704573408 17.223 95 35 70 1 1720351104 5139024 10638672
23:21:44 65243 8192000000 10704265872 11127414784 1750155280 17.603 97 32 63 2 1765436096 5902784 9378032
23:22:57 11312 8192000000 10731695584 11147481088 1791456896 17.944 99 31 62 0 1806393344 6545536 8390912
23:23:17 5713 8192000000 10739059920 11159941120 1822310784 18.197 100 43 85 1 1842722960 8399408 12012768
23:23:29 6888 8192000000 10737253888 11163574272 1829962720 18.259 100 34 68 1 1847209568 6507968 10738880
23:23:45 7532 8192000000 10762362672 11181043712 1838688384 18.330 100 34 67 0 1855867872 7561360 9618128
23:23:59 7168 8192000000 10741255888 11157434368 1821541664 18.190 99 32 62 2 1836254224 5271408 9441152
23:24:12 9379 8192000000 10758179008 11177066496 1843113360 18.366 100 34 68 1 1858495872 5668352 9714160
23:24:29 7828 8192000000 10765055680 11184238592 1842546560 18.362 100 19 38 2 1854062736 5553584 5962592
23:24:46 8176 8192000000 10769294784 11195686912 1850957152 18.430 100 16 32 0 1861431872 5589072 4885648
23:25:04 9571 8192000000 10762384672 11193667584 1846388304 18.393 100 15 30 1 1855879088 5308256 4182528
23:25:22 6733 8192000000 10772342768 11194212352 1853698416 18.452 100 34 68 1 1869707760 5879520 10129824
23:25:38 9576 8192000000 10767027568 11195146240 1856458560 18.475 100 27 54 2 1869967456 5584832 7924064
23:25:55 12106 8192000000 10775091200 11205287936 1862800480 18.526 100 26 51 1 1876589024 6509872 7278672
23:26:13 11291 8192000000 10771419120 11205464064 1862842032 18.526 100 16 32 1 1873293632 5407840 5043760
23:26:49 77795 8192000000 10818155840 11239378944 1877583776 18.646 100 32 64 2 1896786208 10652768 8549664
23:28:15 38574 8192000000 10849152512 11265753088 1905739248 18.872 100 57 115 1 1931564768 10200848 15624672
23:29:03 20238 8192000000 10848410384 11272159232 1915087632 18.947 100 45 91 1 1945334752 17396272 12850848
23:29:31 11225 8192000000 10856346880 11279155200 1926639760 19.040 100 39 76 0 1948159952 10779200 10740992
23:29:51 6381 8192000000 10859250000 11282882560 1928624208 19.056 100 56 112 1 1956466128 11862208 15979712
23:30:15 27141 8192000000 10872134480 11296342016 1932725360 19.089 100 42 84 0 1956288272 11962400 11600512
23:30:52 34185 8192000000 10868046192 11299340288 1921658704 19.000 99 44 88 2 1946497024 12024032 12814288
23:31:39 15700 8192000000 10892813616 11316449280 1945234720 19.189 100 44 88 1 1974258224 15621008 13402496
23:32:05 14940 8192000000 10884827792 11314606080 1948545280 19.215 100 43 86 2 1977892720 16845824 12501616
23:32:30 18522 8192000000 10882837104 11322081280 1950718384 19.232 100 30 60 0 1976065008 16266944 9079680
23:33:05 9960 8192000000 10897495440 11325513728 1959689200 19.304 100 43 86 2 1988033520 14695600 13648720
23:33:25 11612 8192000000 10909518896 11337097216 1964236912 19.340 100 50 99 2 1995658880 16241296 15180672
23:33:47 12723 8192000000 10904721888 11337592832 1963812672 19.336 100 48 95 1 1995470480 17594336 14063472
23:34:12 1250 8192000000 10931342096 11348885504 1974486320 19.421 100 79 156 1 2015979888 17784576 23708992
23:34:20 3551 8192000000 10924316240 11352514560 1979223760 19.459 100 68 136 1 2018329376 19031728 20073888
23:34:35 18620 8192000000 10933342384 11369787392 1983038400 19.489 100 56 112 1 2019946080 20541952 16365728
23:35:08 8238 8192000000 10943191568 11375439872 1993521904 19.572 100 57 113 2 2031239712 21171808 16546000
23:35:24 1342 8192000000 10956558640 11377029120 1999780848 19.621 100 74 148 1 2042584304 21283168 21520288
23:35:32 2108 8192000000 10961525232 11380199424 2001678144 19.636 100 87 172 1 2049070720 22029168 25363408
23:35:42 5702 8192000000 10957031344 11382272000 2000010064 19.623 100 69 138 1 2043151872 23223664 19918144
23:35:57 3735 8192000000 10954967792 11383382016 1999303024 19.617 100 71 142 0 2043555584 24036736 20215824
23:36:11 2915 8192000000 10954856448 11388739584 2003908608 19.654 100 67 134 1 2047514336 23736256 19869472
23:36:21 6851 8192000000 10967204560 11389935616 2006458304 19.674 100 71 142 2 2049676736 22626896 20591536
23:36:36 3784 8192000000 10957813664 11394457600 2008812544 19.692 100 59 118 0 2047960896 21468720 17679632
23:36:46 3998 8192000000 10958759232 11390902272 1992532720 19.564 99 60 119 0 2030556480 21016432 17007328
23:36:59 8960 8192000000 10968110944 11400421376 2009850320 19.700 100 59 118 3 2048104224 21671728 16582176
23:37:21 7187 8192000000 10983946608 11409420288 2019599520 19.777 100 75 150 1 2065791776 23902080 22290176
23:37:37 1383 8192000000 10987745488 11404980224 2019726816 19.778 100 88 175 0 2072221312 26832768 25661728
23:37:51 3022 8192000000 10983592752 11400519680 1998118144 19.608 99 73 145 1 2046376128 26833680 21424304
23:38:01 2209 8192000000 10967418880 11387584512 1996920304 19.598 99 78 153 0 2046864976 26878576 23066096
23:38:11 5534 8192000000 10965384400 11397787648 1988755360 19.534 99 56 111 1 2032929840 27708912 16465568
23:38:25 7478 8192000000 10957101712 11388547072 1994776528 19.582 100 61 121 0 2041507664 28466960 18264176
23:38:43 7913 8192000000 10956864288 11383246848 1992995056 19.567 100 60 120 1 2039510864 28301616 18214192
23:38:59 5015 8192000000 10963159568 11388731392 1998238080 19.609 100 68 136 1 2048255264 29364736 20652448
23:39:10 4016 8192000000 10959472784 11392233472 1998960064 19.615 100 68 130 1 2050060896 32112368 18988464
23:39:22 7172 8192000000 10983172816 11410079744 2011468464 19.713 100 72 144 0 2067120832 33812080 21840288
23:39:36 4131 8192000000 10983950480 11413225472 2013675856 19.730 100 75 150 2 2071451792 35213808 22562128
23:39:48 3778 8192000000 10988088720 11416055808 2013864256 19.732 100 71 142 0 2069634176 34389760 21380160
23:40:01 2400 8192000000 10989140416 11414081536 2023189360 19.805 100 72 144 1 2075794656 31273664 21331632
23:40:11 2176 8192000000 10973958288 11392479232 1996373168 19.594 100 87 175 1 2054898976 32865840 25659968
23:40:21 3078 8192000000 10960917904 11376832512 1992078944 19.560 100 85 170 0 2051106192 33274320 25752928
23:40:32 2489 8192000000 10950134224 11363479552 1971558752 19.398 100 70 139 2 2026308704 33428736 21321216
23:40:42 4335 8192000000 10949506096 11371020288 1962445488 19.325 99 84 166 0 2021174592 33910896 24818208
23:40:56 3141 8192000000 10938876880 11358687232 1947221328 19.204 99 76 150 2 2005572672 35065792 23285552
23:41:06 1473 8192000000 10953771280 11365003264 1971709872 19.399 100 80 158 2 2030868368 35908336 23250160
23:41:16 3886 8192000000 10956075488 11373047808 1975907840 19.432 100 76 152 2 2037596208 37147456 24540912
23:41:28 5918 8192000000 10958875440 11383238656 1984309056 19.499 100 74 145 2 2043448096 36944800 22194240
23:41:41 2467 8192000000 10969203744 11388231680 1987063952 19.521 100 79 159 1 2048594288 37522544 24007792
23:41:50 2671 8192000000 10949553280 11370590208 1959414624 19.301 99 73 143 0 2019962144 38581984 21965536
23:42:00 7465 8192000000 10912109440 11335643136 1928790064 19.057 98 63 126 4 1984654688 36749952 19114672
23:42:15 2359 8192000000 10953008528 11361177600 1966610992 19.359 100 80 159 0 2028429840 37313536 24505312
23:42:27 4749 8192000000 10954016816 11372183552 1960280208 19.308 99 74 144 2 2021399872 38243392 22876272
23:42:41 9467 8192000000 10958877712 11381288960 1980550272 19.469 100 84 169 4 2047367600 40939264 25878064
23:42:59 4270 8192000000 10966670176 11391250432 1987323680 19.523 100 69 138 1 2049511712 40973520 21214512
23:43:18 3139 8192000000 10978673120 11403427840 1997224800 19.601 100 71 141 1 2061434752 42195888 22014064
23:43:28 3986 8192000000 10983554096 11403321344 1996731072 19.597 100 84 166 0 2064453408 43326336 24396000
23:43:40 4425 8192000000 10988145696 11409227776 2001876256 19.638 100 77 153 0 2071399936 45959024 23564656
23:43:52 2377 8192000000 10967481952 11375616000 1976996720 19.441 99 91 183 1 2044718736 39723152 27998864
23:44:02 3304 8192000000 10973774224 11384549376 1970927936 19.393 99 79 158 1 2033297808 37563440 24806432
23:44:12 2669 8192000000 10979564304 11390439424 1987569040 19.525 100 89 178 0 2056339280 40159008 28611232
23:44:24 4194 8192000000 10969298256 11382177792 1978635520 19.454 100 90 180 0 2049481696 42114048 28732128
23:44:36 2491 8192000000 10968210176 11380707328 1977139920 19.442 100 77 154 1 2044234912 42890368 24204624
23:44:46 3871 8192000000 10964567456 11379904512 1976826560 19.440 100 77 152 0 2044456720 43403648 24226512
23:44:57 1398 8192000000 10968939120 11380944896 1976643264 19.438 100 86 172 0 2047986528 44405840 26937424
23:45:05 2594 8192000000 10955000032 11362156544 1958911264 19.297 99 78 155 2 2026932240 43886128 24134848
23:45:16 3121 8192000000 10968661568 11385860096 1983131328 19.489 100 85 169 1 2051336032 40927712 27276992
23:45:29 4303 8192000000 10931756192 11350626304 1947266192 19.205 99 75 149 3 2012461968 40974848 24220928
23:45:43 4226 8192000000 10958653904 11379294208 1975228768 19.427 100 73 146 0 2043335248 44480672 23625808
23:45:55 4155 8192000000 10979971600 11390963712 1983718192 19.494 100 82 164 1 2057670688 47644192 26308304
23:46:09 4679 8192000000 10978655216 11398791168 1984695312 19.502 100 75 150 1 2057485648 49338688 23451648
23:46:22 12385 8192000000 10980365264 11399753728 1979889744 19.464 100 65 128 2 2050333072 49507552 20935776
23:46:42 1885 8192000000 10991712064 11406135296 1990294192 19.546 100 88 175 2 2069868000 51322512 28251296
23:46:51 1067 8192000000 10996088368 11405668352 1991158512 19.553 100 96 189 1 2072222304 50851520 30212272
23:47:05 1702 8192000000 10996532016 11407831040 1992066016 19.560 100 80 160 1 2069084784 51222656 25796112
23:47:15 3998 8192000000 10982045840 11403165696 1987416272 19.523 100 77 154 1 2061132912 49122432 24594208
23:47:27 7130 8192000000 10972164864 11407835136 1987929904 19.527 100 61 122 1 2057797696 49912032 19955760
23:47:50 10723 8192000000 10945646272 11398520832 1962554096 19.326 99 44 88 0 2027134512 48768640 15811776
23:48:13 12870 8192000000 10937483264 11378036736 1947650800 19.208 99 42 84 1 2006568368 44722336 14195232
23:48:34 9580 8192000000 10936113680 11363024896 1952170640 19.244 100 54 104 0 2016472944 46857424 17444880
23:48:52 3780 8192000000 10941311504 11370082304 1959743072 19.304 100 69 138 1 2025633952 43361408 22529472
23:49:04 7498 8192000000 10932594416 11370815488 1957883728 19.289 100 48 96 1 2018087776 44668624 15535424
23:49:19 8924 8192000000 10929883520 11378065408 1961814016 19.320 100 40 81 0 2020568800 45236816 13517968
23:49:57 18458 8192000000 10921827344 11351326720 1940922384 19.154 100 40 79 2 1989080976 34613984 13544608
23:50:26 13536 8192000000 10905519920 11357478912 1952674976 19.248 100 46 91 1 2004953808 37390400 14888432
23:50:46 18533 8192000000 10894665584 11340550144 1912678896 18.928 98 25 50 2 1954393552 32946144 8768512
23:51:12 20653 8192000000 10890229936 11343261696 1937645328 19.128 100 22 44 0 1980256960 34703456 7908176
23:51:54 18562 8192000000 10892087696 11339120640 1920452544 18.990 99 28 57 0 1963436480 33213440 9770496
23:52:19 25009 8192000000 10898519920 11366957056 1943081808 19.171 100 26 52 1 1987809904 36220176 8507920
23:52:52 38095 8192000000 10882223440 11337531392 1922131440 19.004 99 20 40 1 1968518656 38670880 7716336
23:53:53 24086 8192000000 10887336256 11345887232 1933207136 19.093 100 24 48 1 1970298256 29147280 7943840
23:54:55 33257 8192000000 10891487456 11344015360 1947073504 19.203 100 36 73 0 1969181296 11969296 10138496
23:55:47 19122 8192000000 10889796976 11345223680 1950230752 19.228 100 37 73 4 1970589088 9580784 10777552
23:56:12 30718 8192000000 10880168560 11343331328 1953479184 19.254 100 24 48 0 1971149504 10603936 7066384
23:57:01 64075 8192000000 10873477824 11351552000 1933809984 19.097 99 14 26 2 1944783872 7633616 3340272
23:58:12 53912 8192000000 10883609872 11341938688 1945074224 19.187 99 26 48 2 1959089776 6837408 7178144
23:59:29 78846 8192000000 10908937520 11366137856 1957991808 19.290 99 24 48 0 1973717264 9199712 6525744
00:01:05 35893 8192000000 10916541728 11364302848 1960664752 19.311 99 38 73 1 1985407472 13172272 11570448
00:01:47 110852 8192000000 10904795600 11374948352 1956062544 19.275 99 15 30 0 1976331056 15116848 5151664
00:03:49 21174 8192000000 10938080448 11378950144 1983037088 19.489 100 37 76 0 2009854320 15987856 10829376
00:04:30 39198 8192000000 10909824400 11382927360 1964318960 19.340 99 12 24 1 1985100000 17237744 3543296
00:05:57 28251 8192000000 10926542752 11384680448 1981631696 19.478 100 51 100 1 2016520496 20685632 14203168
00:07:21 48755 8192000000 10893591280 11368157184 1956851168 19.281 99 9 18 1 1975345616 15974656 2519792
00:08:23 39681 8192000000 10887281888 11352059904 1963420096 19.333 100 25 47 1 1977931600 7095360 7416144
00:09:09 73375 8192000000 10898573808 11370549248 1978142384 19.450 100 10 20 2 1990408416 9283792 2982240
00:10:30 57408 8192000000 10876675632 11354902528 1928238976 19.053 98 9 18 0 1940445600 9520464 2686160
00:11:43 70659 8192000000 10868207680 11338448896 1920531504 18.991 98 17 34 3 1934658192 8539392 5587296
00:15:12 39841 8192000000 10869987984 11339272192 1925184848 19.028 98 27 53 0 1938782592 5926752 7670992
00:15:58 48035 8192000000 10880025168 11352305664 1946104224 19.195 99 20 40 0 1960995808 9014048 5877536
00:18:29 70482 8192000000 10894278432 11372691456 1974561280 19.422 100 9 18 0 1990669056 13443552 2664224
00:19:51 63639 8192000000 10901931184 11378470912 1984361552 19.499 100 15 30 0 1998145152 9369712 4413888
00:21:14 47760 8192000000 10908483408 11371323392 1969850976 19.384 99 26 52 0 1984985552 8401616 6732960
00:22:11 47923 8192000000 10918825104 11393880064 1978219056 19.451 99 28 56 1 1999831792 13564464 8048272
00:23:18 45101 8192000000 10895053680 11356696576 1917255376 18.965 96 30 60 0 1939535776 13322560 8957840
00:24:12 62276 8192000000 10874838032 11351244800 1909893696 18.906 97 19 38 0 1925770864 10612144 5265024
00:25:24 50126 8192000000 10895921648 11348856832 1910718176 18.912 97 31 61 1 1930300384 10577360 9004848
00:26:24 40977 8192000000 10884372976 11348336640 1910120960 18.908 97 34 68 2 1931473328 11461344 9891024
00:27:15 29904 8192000000 10919297408 11376332800 1968388208 19.373 100 26 52 2 1990248352 14965712 6894432
00:28:33 64608 8192000000 10906742144 11382620160 1958118176 19.291 99 14 28 0 1987042528 25134096 3790256
00:29:51 135094 8192000000 10872367696 11334410240 1760401248 17.688 89 8 16 0 1778143568 16042240 1700080
00:32:14 37021 8192000000 10853381792 11305590784 1878177408 18.650 97 35 69 2 1895802448 8142448 9482592
00:32:57 84858 8192000000 10820224128 11273048064 1865333136 18.546 97 29 56 0 1879781872 6529600 7919136
00:34:45 73749 8192000000 10829265408 11300360192 1853250400 18.449 96 25 50 0 1872890624 12507344 7132880
00:36:05 3868 8192000000 10828391792 11295993856 1892539648 18.766 99 21 40 3 1909649424 11279728 5830048
00:36:16 3691 8192000000 10822566288 11292020736 1900460528 18.830 100 8 16 0 1914360192 11597968 2301696
00:36:27 8416 8192000000 10853325408 11301228544 1916264976 18.957 100 18 35 1 1932469456 10887856 5316624
00:37:07 33274 8192000000 10836523168 11309674496 1908775744 18.897 99 10 20 0 1922653936 11265344 2612848
00:37:46 84358 8192000000 10817918640 11279015936 1838040656 18.325 95 16 32 0 1853611280 10928592 4642032
00:39:36 63944 8192000000 10848649280 11320520704 1929733296 19.065 100 11 22 0 1942685520 9450880 3501344
00:40:57 68025 8192000000 10849298816 11318046720 1880250160 18.667 97 12 24 1 1891846128 8293552 3302416
00:42:12 23835 8192000000 10860487888 11328950272 1932488880 19.087 100 23 46 1 1948132208 9370096 6273232
00:42:43 42136 8192000000 10867404560 11330437120 1907197392 18.884 98 23 44 2 1928985072 15586192 6201488
00:43:38 62017 8192000000 10874085216 11356377088 1926708752 19.041 99 18 37 0 1948153840 15884400 5560688
00:44:47 60260 8192000000 10871787664 11344056320 1909711248 18.904 98 15 30 0 1925735680 11957488 4066944
00:46:30 120580 8192000000 10883027168 11356114944 1886554832 18.718 96 24 48 0 1912665168 19653744 6456592
00:48:41 21390 8192000000 10894993200 11347906560 1937076176 19.123 99 44 87 1 1958429072 10047344 11305552
00:49:12 48014 8192000000 10891152176 11347357696 1938111584 19.132 99 45 91 0 1962101104 11522736 12466784
00:50:10 100873 8192000000 10872835200 11348647936 1880818064 18.672 96 17 34 0 1900721760 15525520 4378176
00:51:57 91564 8192000000 10868048240 11333414912 1867932304 18.568 96 12 24 0 1888512432 17565456 3014672
00:53:48 140796 8192000000 10874941760 11334221824 1903182560 18.852 98 11 22 1 1916711152 10637504 2891088
00:56:15 66185 8192000000 10875909232 11341664256 1887794016 18.728 97 23 46 1 1900871216 6728688 6348512
00:58:12 58135 8192000000 10880721712 11369566208 1948217344 19.212 99 20 40 0 1964011648 10318848 5475456
00:59:39 27977 8192000000 10885731696 11375050752 1970364752 19.388 100 3 6 0 1979569216 8808464 396000
01:00:34 76593 8192000000 10876340960 11352698880 1884075984 18.698 95 11 21 1 1895982976 9058016 2848976
01:02:06 62164 8192000000 10882977248 11355123712 1904596192 18.863 97 26 51 1 1924107072 11570656 7940224
01:03:30 64935 8192000000 10906682000 11381194752 1965275984 19.348 100 16 31 2 1981324432 11298368 4750080
01:05:03 22553 8192000000 10905347776 11373592576 1960205264 19.308 99 31 62 2 1976167568 7294672 8667632
01:05:35 61470 8192000000 10900021728 11365433344 1934102336 19.100 98 27 54 3 1952525888 10382672 8040880
01:06:47 31834 8192000000 10889887248 11367612416 1945616608 19.192 99 11 22 0 1957747856 9327040 2804208
01:07:29 36734 8192000000 10920146640 11386531840 1980003760 19.465 100 30 60 2 2001843648 13136400 8703488
01:08:15 67545 8192000000 10908209104 11390943232 1961809104 19.320 99 20 40 1 1984000576 16054720 6136752
01:09:39 114958 8192000000 10905543360 11384569856 1931774944 19.081 98 13 27 0 1953551216 18262592 3513680
01:11:45 74985 8192000000 10919013168 11394539520 1955798720 19.273 99 16 30 1 1971173776 11057456 4317600
01:13:14 61197 8192000000 10913983728 11383435264 1940874672 19.154 98 20 40 1 1967504128 21497920 5131536
01:14:31 93288 8192000000 10886883728 11375333376 1931151792 19.076 98 18 36 0 1954174816 17989712 5033312
01:16:59 23449 8192000000 10923560528 11364601856 1956341872 19.277 99 65 126 3 1980646112 6015248 18288992
01:17:29 73163 8192000000 10881248736 11364732928 1931492432 19.079 98 22 44 0 1946105696 8460032 6153232
01:19:17 37811 8192000000 10886177312 11369783296 1928655552 19.056 98 8 16 0 1943402720 12877296 1869872
01:20:36 38648 8192000000 10867563024 11337723904 1889174560 18.739 96 16 30 2 1907230496 12948912 5107024
01:21:21 65414 8192000000 10884651552 11358167040 1936940464 19.122 99 14 28 0 1955135744 14307968 3887312
01:23:07 58807 8192000000 10899634608 11369947136 1924469104 19.023 98 19 38 1 1958074400 28121680 5483616
01:24:21 90875 8192000000 10879790896 11360088064 1898148128 18.811 97 24 47 4 1938828304 33704736 6975440
01:25:58 89876 8192000000 9448354704 9744592896 591332224 6.732 31 5 10 1 610824576 18065648 1426704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-02-2021 01:28:55 to 21-02-2021 01:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-02-2021 01:29:28 to 21-02-2021 01:29:30.

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          234145
MON$OLDEST_ACTIVE               234146
MON$OLDEST_SNAPSHOT             234146
MON$NEXT_TRANSACTION            234146
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                       2003072
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:81: 
:82: mscs-test-161.budzdorov.ru    Sun Feb 21 01:27:29 2021
:83:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:84: 
:85: 
:86: mscs-test-161.budzdorov.ru    Sun Feb 21 01:27:44 2021
:87:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:88: 
--- end of diff output ---

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

21.02.21 01:29:31. 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-21 01:29:33 No severe PSQL-related problems occured
21.02.21 01:29:34. End of report.