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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-22 01:27:04
DTS_END                         2020-11-22 01:27:04.4180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53482
TRN_ID                          239245
ATT_ID                          630
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: 8960.18 23503 1075222
customer order: creation 171.68 361 20602
customer order: refuse 14.28 394 1713
order to supplier: creation 45.03 1333 5404
order to supplier: removal 3.43 108391 411
invoice (draft): creation 44.83 3695 5380
invoice (draft): removal 51.50 822 6180
invoice accept: apply 40.63 19298 4875
invoice accept: cancel 45.67 834 5480
customer reserve: creation 3797.12 187 455654
customer reserve: removal 4457.22 65 534866
realization accept: apply 82.72 214 9926
realization accept: cancel 79.14 117 9497
payment from customer: creation 57.54 134 6905
payment from customer: removal 5.64 79 677
payment to supplier: creation 47.98 157 5758
payment to supplier: removal 3.31 99 397
service: total inventory turnovers 4.86 1230 583
service: total monetary turnovers 6.75 38 810
service: aggregate perf. data 0.83 20631 100
service: refresh index statistics 0.03 311990 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-11-2020 01:29:20 to 22-11-2020 01:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7363
TEST_TIME 2 5832
TEST_TIME 3 5652
TEST_TIME 4 5715
TEST_TIME 5 4779
TEST_TIME 6 4805
TEST_TIME 7 5077
TEST_TIME 8 5222
TEST_TIME 9 5533
TEST_TIME 10 5473
TEST_TIME 11 5972
TEST_TIME 12 6167
TEST_TIME 13 6229
TEST_TIME 14 6667
TEST_TIME 15 6873
TEST_TIME 16 6962
TEST_TIME 17 7129
TEST_TIME 18 7218
TEST_TIME 19 7545
TEST_TIME 20 7827
TEST_TIME 21 7996
TEST_TIME 22 8486
TEST_TIME 23 9076
TEST_TIME 24 9074
TEST_TIME 25 9189
TEST_TIME 26 9307
TEST_TIME 27 10054
TEST_TIME 28 11148
TEST_TIME 29 10882
TEST_TIME 30 10812
TEST_TIME 31 10644
TEST_TIME 32 10569
TEST_TIME 33 10475
TEST_TIME 34 10457
TEST_TIME 35 10329
TEST_TIME 36 10198
TEST_TIME 37 10007
TEST_TIME 38 9978
TEST_TIME 39 9886
TEST_TIME 40 9842
TEST_TIME 41 9932
TEST_TIME 42 9810
TEST_TIME 43 9651
TEST_TIME 44 9598
TEST_TIME 45 9532
TEST_TIME 46 9644
TEST_TIME 47 9679
TEST_TIME 48 9520
TEST_TIME 49 9509
TEST_TIME 50 9533
TEST_TIME 51 9548
TEST_TIME 52 9428
TEST_TIME 53 9589
TEST_TIME 54 9601
TEST_TIME 55 9620
TEST_TIME 56 9644
TEST_TIME 57 9593
TEST_TIME 58 9514
TEST_TIME 59 9575
TEST_TIME 60 9631
TEST_TIME 61 9630
TEST_TIME 62 9657
TEST_TIME 63 9675
TEST_TIME 64 9742
TEST_TIME 65 9670
TEST_TIME 66 9536
TEST_TIME 67 9527
TEST_TIME 68 9489
TEST_TIME 69 9414
TEST_TIME 70 9400
TEST_TIME 71 9371
TEST_TIME 72 9352
TEST_TIME 73 9307
TEST_TIME 74 9246
TEST_TIME 75 9164
TEST_TIME 76 9183
TEST_TIME 77 9181
TEST_TIME 78 9200
TEST_TIME 79 9166
TEST_TIME 80 9207
TEST_TIME 81 9194
TEST_TIME 82 9163
TEST_TIME 83 9292
TEST_TIME 84 9246
TEST_TIME 85 9277
TEST_TIME 86 9277
TEST_TIME 87 9370
TEST_TIME 88 9353
TEST_TIME 89 9343
TEST_TIME 90 9431
TEST_TIME 91 9333
TEST_TIME 92 9303
TEST_TIME 93 9272
TEST_TIME 94 9237
TEST_TIME 95 9221
TEST_TIME 96 9163
TEST_TIME 97 9193
TEST_TIME 98 9165
TEST_TIME 99 9177
TEST_TIME 100 9181
TEST_TIME 101 9192
TEST_TIME 102 9172
TEST_TIME 103 9210
TEST_TIME 104 9226
TEST_TIME 105 9201
TEST_TIME 106 9182
TEST_TIME 107 9272
TEST_TIME 108 9246
TEST_TIME 109 9289
TEST_TIME 110 9294
TEST_TIME 111 9271
TEST_TIME 112 9222
TEST_TIME 113 9196
TEST_TIME 114 9195
TEST_TIME 115 9168
TEST_TIME 116 9156
TEST_TIME 117 9126
TEST_TIME 118 9109
TEST_TIME 119 9046
TEST_TIME 120 8972

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-11-2020 01:29:24 to 22-11-2020 01:29:27.

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 1496732 1496732 0 0.00 0 23598 6 0 0
doc_list_biud 1496731 1496731 0 0.00 0 26890 29 0 0
sp_add_invoice_to_stock 5021 4875 146 2.90 42 197937 19298 0 146
sp_cancel_adding_invoice 5480 5480 0 0.00 5 66918 835 0 0
sp_cancel_client_order 1713 1713 0 0.00 5 14165 394 0 0
sp_cancel_customer_reserve 534866 534866 0 0.00 1 24026 66 0 0
sp_cancel_pay_from_customer 677 677 0 0.00 2 6691 80 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 7802 100 0 0
sp_cancel_supplier_invoice 6185 6180 5 0.08 2 20623 823 0 5
sp_cancel_supplier_order 411 411 0 0.00 4 1116014 108392 0 0
sp_cancel_write_off 9497 9497 0 0.00 1 9254 117 0 0
sp_client_order 20602 20602 0 0.00 3 30931 361 0 0
sp_customer_reserve 455654 455654 0 0.00 0 137207 188 0 0
sp_fill_shopping_cart 31383 31383 0 0.00 1 18902 42 0 0
sp_fill_shopping_cart_clo_res 455644 455644 0 0.00 0 20111 15 0 0
sp_get_clo_for_invoice 4862 4862 0 0.00 0 45248 359 0 0
sp_kill_cost_storno 16051 16051 0 0.00 0 7629 61 0 0
sp_kill_qstorno_ret_qs2qd 1085820 1085820 0 0.00 0 26887 35 0 0
sp_kill_qty_storno 572934 572934 0 0.00 0 26889 76 0 0
sp_lock_selected_doc 20408 20408 0 0.00 0 9159 5 0 0
sp_make_cost_storno 27450 27450 0 0.00 0 23428 66 0 0
sp_multiply_rows_for_pdistr 27450 27450 0 0.00 0 8455 31 0 0
sp_multiply_rows_for_qdistr 20602 20602 0 0.00 0 28685 152 0 0
sp_pay_from_customer 6905 6905 0 0.00 4 15306 135 0 0
sp_pay_to_supplier 5758 5758 0 0.00 5 23626 157 0 0
sp_payment_common 12663 12663 0 0.00 1 14673 37 0 0
sp_qd_handle_on_cancel_clo 1713 1713 0 0.00 0 8441 359 0 0
sp_qd_handle_on_invoice_upd_sts 10341 10341 0 0.00 0 20484 351 0 0
sp_qd_handle_on_reserve_upd_sts 9926 9926 0 0.00 0 10551 70 0 0
sp_reserve_write_off 9926 9926 0 0.00 7 20202 214 0 0
sp_supplier_invoice 5380 5380 0 0.00 6 100596 3696 0 0
sp_supplier_order 5404 5404 0 0.00 6 45021 1334 0 0
srv_aggregate_perf_data 100 100 0 0.00 2965 161545 20631 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 707 141873 32246 0 0
srv_find_qd_qs_mism 1027968 1027968 0 0.00 0 18264 5 0 0
srv_make_invnt_saldo 583 583 0 0.00 44 49260 1230 0 0
srv_make_money_saldo 810 810 0 0.00 1 4116 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 160170 422687 311991 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4876 4876 0 0.00 0 20114 192 0 0
t$perf-norm:sp_cancel_adding_invoice 376 376 0 0.00 0 3712 101 0 0
t$perf-norm:sp_cancel_client_order 1713 1713 0 0.00 0 1457 14 0 0
t$perf-norm:sp_cancel_customer_reserve 665 665 0 0.00 0 1179 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 677 677 0 0.00 0 4392 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 4938 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 691 12 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 24514 1740 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 4807 12 0 0
t$perf-norm:sp_client_order 20602 20602 0 0.00 0 17830 21 0 0
t$perf-norm:sp_customer_reserve 1000 1000 0 0.00 0 2129 8 0 0
t$perf-norm:sp_pay_from_customer 6905 6905 0 0.00 0 7764 10 0 0
t$perf-norm:sp_pay_to_supplier 5758 5758 0 0.00 0 2636 8 0 0
t$perf-norm:sp_reserve_write_off 9926 9926 0 0.00 0 7747 10 0 0
t$perf-norm:sp_supplier_invoice 5380 5380 0 0.00 0 6925 17 0 0
t$perf-norm:sp_supplier_order 5404 5404 0 0.00 0 7326 16 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 427 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 12618 87 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 6110 43 0 0
t$perf-norm:srv_make_money_saldo 810 810 0 0.00 0 4312 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10014 9722 292 2.91 0 15318 30 0 292
v_all_customers 36884 36884 0 0.00 0 19 1 0 0
v_all_suppliers 29834 29834 0 0.00 0 24 1 0 0
v_all_wares 41204 41204 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 752 752 0 0.00 0 14136 32 0 0
v_cancel_client_order 3426 3426 0 0.00 0 13987 9 0 0
v_cancel_customer_prepayment 1354 1354 0 0.00 0 3615 6 0 0
v_cancel_customer_reserve 1330 1330 0 0.00 0 1162 5 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 7778 14 0 0
v_cancel_supplier_invoice 788 778 10 1.26 0 15255 59 0 10
v_cancel_supplier_order 822 822 0 0.00 0 1179 7 0 0
v_cancel_write_off 1986 1986 0 0.00 0 2805 14 0 0
v_max_id_clo_ord 5403 5403 0 0.00 0 1365 2 0 0
v_max_id_clo_res 1000 1000 0 0.00 0 4924 21 0 0
v_max_id_ord_sup 5378 5378 0 0.00 0 7307 5 0 0
v_max_non_paid_invoice 1620 1620 0 0.00 0 4156 9 0 0
v_max_non_paid_realizn 3876 3876 0 0.00 0 5174 6 0 0
v_min_id_clo_ord 5403 5403 0 0.00 0 6151 8 0 0
v_min_id_clo_res 1000 1000 0 0.00 0 7146 13 0 0
v_min_id_ord_sup 5378 5378 0 0.00 0 8460 12 0 0
v_min_non_paid_invoice 5757 5757 0 0.00 0 4860 23 0 0
v_min_non_paid_realizn 6905 6905 0 0.00 0 8492 26 0 0
v_our_firm 10378 10378 0 0.00 0 16 1 0 0
v_reserve_write_off 19852 19852 0 0.00 0 13750 11 0 0
x_lock_depdocs_on_canc_invoice 11271 11271 0 0.00 0 30658 124 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 30593 477 0 0
x_make_qstorno_1000_1200 5404 5404 0 0.00 1 45006 1243 0 0
x_make_qstorno_1200_2000 5380 5380 0 0.00 3 100549 3544 0 0
x_make_qstorno_2100_3300 455654 455654 0 0.00 0 137201 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-11-2020 01:29:28 to 22-11-2020 01:29:32.

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:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 10592 8192000000 10190305184 10492579840 830643696 9.206 67 56 117 0 851975616 2281392 19050528
22:57:36 30099 8192000000 10322475248 10633412608 1365983136 14.291 100 86 172 0 1398322560 4434080 27905344
22:58:15 36046 8192000000 10365185696 10683719680 1408252944 14.668 100 86 173 2 1442814816 6266944 28294928
22:59:02 23583 8192000000 10392169520 10718597120 1441544640 14.963 100 83 166 0 1475587552 7599312 26443600
22:59:40 29887 8192000000 10430093504 10760474624 1475874336 15.265 100 85 169 1 1510756688 8175264 26707088
23:00:20 16272 8192000000 10454424112 10787815424 1506275024 15.531 100 87 173 0 1542381328 8777664 27328640
23:00:45 14165 8192000000 10464821488 10801434624 1521927408 15.667 100 87 174 2 1558964224 9547488 27489328
23:01:11 18211 8192000000 10484581600 10826752000 1537671088 15.803 100 84 168 2 1574226304 10262960 26292256
23:01:37 10810 8192000000 10507264496 10849484800 1562030688 16.014 100 84 169 2 1598150656 10155856 25964112
23:01:55 18185 8192000000 10520915648 10874277888 1583309776 16.197 100 82 164 1 1619397472 10889616 25198080
23:02:34 16228 8192000000 10553146192 10909982720 1609490096 16.420 100 81 162 2 1645859856 11328832 25040928
23:02:59 11374 8192000000 10578741760 10941444096 1634548816 16.634 100 79 158 0 1669849952 11545024 23756112
23:03:19 9596 8192000000 10602439552 10963193856 1657576080 16.828 100 82 164 1 1694413632 11962224 24875328
23:03:36 8821 8192000000 10600874416 10969468928 1664299648 16.885 100 71 144 0 1696478832 11110880 21068304
23:03:52 8665 8192000000 10631511936 11006107648 1694515408 17.139 100 75 150 0 1728418368 11829840 22073120
23:04:10 9256 8192000000 10654892944 11030822912 1718137200 17.337 100 78 154 1 1752028464 11881312 22009952
23:04:27 4465 8192000000 10671355376 11048910848 1735026224 17.477 100 81 162 1 1770407408 12075200 23305984
23:04:40 5912 8192000000 10682134304 11064184832 1751102720 17.611 100 75 149 0 1783578336 11592960 20882656
23:04:53 4128 8192000000 10701230704 11078217728 1762822016 17.708 100 80 160 0 1797344896 11665760 22857120
23:05:04 4551 8192000000 10702409072 11083935744 1765292976 17.728 100 84 166 3 1801044896 11697424 24054496
23:05:15 3331 8192000000 10720643776 11096858624 1778541824 17.837 100 84 166 1 1814058624 12080688 23436112
23:05:25 5002 8192000000 10724246432 11105411072 1783894304 17.882 100 84 166 1 1819824528 13116528 22813696
23:05:37 4954 8192000000 10730647936 11114336256 1790749216 17.938 100 74 148 0 1824370048 13067504 20553328
23:05:49 3843 8192000000 10745695504 11123851264 1797675616 17.995 100 88 175 0 1837567616 15082048 24809952
23:06:00 2995 8192000000 10746465424 11128631296 1804085776 18.047 100 85 165 1 1840524688 13783136 22655776
23:06:10 8485 8192000000 10744017840 11129106432 1803905648 18.046 100 79 153 0 1838202144 13841104 20455392
23:06:28 2610 8192000000 10768002544 11151519744 1826826096 18.233 100 83 164 1 1863285040 13654112 22804832
23:06:39 4054 8192000000 10776161888 11163197440 1833406576 18.287 100 92 184 2 1873437856 13661984 26369296
23:06:49 2371 8192000000 10784320112 11172868096 1842453536 18.361 100 93 186 0 1882682016 13798640 26429840
23:06:58 2131 8192000000 10785433552 11175424000 1849212800 18.416 100 91 178 6 1888331632 13627760 25491072
23:07:06 1547 8192000000 10786783184 11176226816 1850324544 18.425 100 86 172 1 1886895536 12645024 23925968
23:07:14 2003 8192000000 10795064960 11183431680 1856653264 18.476 100 95 190 3 1897141680 13792112 26696304
23:07:22 1663 8192000000 10802129664 11193544704 1865171408 18.545 100 92 184 1 1905012992 13557952 26283632
23:07:31 2126 8192000000 10804778848 11194396672 1865191024 18.545 100 91 180 1 1902573360 12390768 24991568
23:07:39 1436 8192000000 10814796560 11200864256 1865175488 18.545 100 93 185 1 1906571120 14454672 26940960
23:07:47 1808 8192000000 10811798304 11201482752 1869265504 18.578 100 95 191 0 1909940832 13776720 26898608
23:07:55 1492 8192000000 10814164048 11204263936 1869118960 18.577 100 89 179 1 1906747888 11761520 25867408
23:08:03 25723 8192000000 10801348480 11202396160 1866756096 18.558 100 64 128 1 1895973712 10329200 18888416
23:08:37 7861 8192000000 10803922768 11202498560 1872113888 18.601 100 62 123 0 1897787104 7334736 18338480
23:08:50 2202 8192000000 10806432736 11217743872 1876875136 18.640 100 72 144 1 1908153712 10689664 20588912
23:09:01 2250 8192000000 10810530480 11218219008 1879121888 18.658 100 62 124 1 1908770320 11713104 17935328
23:09:11 3672 8192000000 10808665552 11219910656 1880589664 18.670 100 61 121 3 1907234592 10308320 16336608
23:09:21 5127 8192000000 10781053168 11210190848 1875823984 18.631 100 42 84 2 1897200656 8804560 12572112
23:09:33 5562 8192000000 10788512784 11215495168 1880264512 18.667 100 35 70 1 1898138096 8430992 9442592
23:09:45 9925 8192000000 10799547904 11220238336 1883565776 18.694 100 35 69 1 1900132736 6689344 9877616
23:10:03 11400 8192000000 10789670096 11220254720 1881819728 18.680 100 26 52 0 1895985568 6982480 7183360
23:10:21 6430 8192000000 10791612448 11222990848 1880469936 18.669 100 19 39 1 1892716464 7199712 5046816
23:10:38 15825 8192000000 10789643824 11226353664 1882960096 18.689 100 24 44 0 1895974416 5756784 7257536
23:11:02 25995 8192000000 10801360832 11232346112 1886628960 18.719 100 17 34 0 1900661664 9588864 4443840
23:12:00 25996 8192000000 10803050400 11239251968 1890897120 18.753 100 31 62 1 1907016528 7490976 8628432
23:12:36 6150 8192000000 10806780304 11240857600 1891896224 18.761 100 25 48 2 1905158176 6187392 7074560
23:12:54 5013 8192000000 10821963776 11247460352 1896107456 18.795 100 31 62 1 1911849152 7212256 8529440
23:13:07 7028 8192000000 10830684944 11252359168 1901669344 18.840 100 44 88 1 1924121408 9676688 12775376
23:13:20 5428 8192000000 10823335824 11251605504 1900662848 18.832 100 36 74 1 1919319424 8009584 10646992
23:13:33 9296 8192000000 10821076352 11249729536 1897583728 18.807 100 22 44 0 1910205744 6147072 6474944
23:13:51 9443 8192000000 10811336528 11249246208 1898843968 18.817 100 29 57 3 1913674928 6281024 8549936
23:14:08 8916 8192000000 10813030928 11252391936 1900628256 18.831 100 16 32 0 1912075616 6509520 4937840
23:14:24 9098 8192000000 10816899616 11254276096 1906956704 18.882 100 25 50 0 1920407280 5666752 7783824
23:14:42 6143 8192000000 10828244544 11260858368 1908071872 18.891 100 34 66 1 1925166736 7625984 9468880
23:14:54 13091 8192000000 10822994416 11255422976 1888187888 18.731 99 17 34 2 1898511824 5783584 4540352
23:15:16 64045 8192000000 10832212896 11243401216 1861953024 18.519 98 34 67 1 1876760928 5541440 9266464
23:16:27 13535 8192000000 10793942000 11235405824 1870346784 18.587 99 9 18 1 1878089920 5249344 2493792
23:16:47 8986 8192000000 10813872864 11249258496 1896768000 18.800 100 20 40 2 1907505792 5178752 5559040
23:17:03 5289 8192000000 10790955168 11230162944 1886867056 18.721 100 33 66 0 1903615104 7002112 9745936
23:17:16 10613 8192000000 10822213152 11254267904 1895998672 18.794 100 34 66 1 1912824784 6564160 10261952
23:17:34 7490 8192000000 10771686608 11194949632 1819875904 18.177 97 18 37 0 1831036640 5204544 5956192
23:17:48 3548 8192000000 10786628928 11198455808 1827696880 18.241 98 48 94 0 1848379264 6929904 13752480
23:18:00 5552 8192000000 10751769360 11176587264 1784448352 17.886 96 16 32 2 1794407584 5435616 4523616
23:18:12 9757 8192000000 10751607648 11173859328 1791792944 17.947 97 22 44 1 1807133104 9575200 5764960
23:18:27 8180 8192000000 10721410368 11135041536 1728675552 17.424 95 19 38 2 1743167008 9510656 4980800
23:18:44 9636 8192000000 10723129728 11147943936 1753439712 17.630 96 19 39 0 1764538560 5200976 5897872
23:19:02 7586 8192000000 10727229264 11146399744 1749648736 17.599 96 30 60 1 1764277920 5775664 8853520
23:19:17 6552 8192000000 10717156768 11134812160 1758925472 17.675 97 33 66 3 1774303104 5889264 9488368
23:19:30 6422 8192000000 10716432352 11142782976 1795426864 17.976 99 30 58 4 1809967008 5974560 8565584
23:19:49 68711 8192000000 10686881360 11104116736 1612450272 16.446 88 35 69 0 1627527408 4350016 10727120
23:21:04 12550 8192000000 10716730384 11128283136 1744228352 17.554 97 15 30 0 1753419984 4921024 4270608
23:21:26 7259 8192000000 10708847952 11126272000 1768072064 17.751 98 35 70 2 1784593680 6362560 10159056
23:21:41 6281 8192000000 10698541056 11116732416 1745487680 17.564 97 33 65 0 1761024800 5874272 9662848
23:21:58 2489 8192000000 10717029856 11128745984 1794864912 17.972 100 29 58 1 1809046416 5555936 8625568
23:22:10 11702 8192000000 10716084704 11141365760 1775890768 17.816 98 23 46 1 1789118080 6421648 6805664
23:22:28 6751 8192000000 10760984800 11179651072 1829046736 18.252 100 35 67 4 1848542144 10145408 9350000
23:22:41 6883 8192000000 10753937840 11170451456 1831218128 18.269 100 21 42 1 1843588544 5433088 6937328
23:22:55 6640 8192000000 10755353952 11177213952 1838343408 18.327 100 33 66 1 1854089888 6343184 9403296
23:23:09 10846 8192000000 10773287360 11188084736 1841056784 18.349 100 27 54 0 1854546240 5105984 8383472
23:23:26 11869 8192000000 10764896672 11186171904 1847719104 18.404 100 22 43 3 1859553904 5064416 6770384
23:23:47 7784 8192000000 10757180048 11188563968 1849581280 18.419 100 17 35 1 1859480016 4978352 4920384
23:24:03 20437 8192000000 10759573184 11190149120 1850095952 18.423 100 16 33 0 1859528032 5122240 4309840
23:24:33 65746 8192000000 10792295120 11203801088 1857369376 18.482 100 38 76 3 1878537024 10100752 11066896
23:25:45 15298 8192000000 10772486048 11204395008 1857739648 18.485 100 18 36 2 1868541680 5786240 5015792
23:26:07 5938 8192000000 10776241440 11207221248 1867259488 18.562 100 36 72 3 1883343024 5450480 10633056
23:26:20 9479 8192000000 10773358944 11205574656 1863023792 18.528 100 19 38 1 1874101520 5487856 5589872
23:26:36 8049 8192000000 10780447584 11208998912 1866928480 18.559 100 39 78 1 1885267056 7474320 10864256
23:26:53 6138 8192000000 10773946768 11205857280 1865682768 18.549 100 23 46 1 1878708432 6063184 6962480
23:27:06 52078 8192000000 10812931120 11238514688 1886687568 18.719 100 37 73 1 1903528880 6190688 10650624
23:28:06 12606 8192000000 10841117792 11258134528 1904771296 18.865 100 41 82 0 1924117248 7645408 11700544
23:28:27 22712 8192000000 10837885456 11263959040 1915340448 18.949 100 46 92 3 1937156736 8348128 13468160
23:28:56 15599 8192000000 10846375488 11269820416 1921071904 18.995 100 48 95 1 1943654960 8548624 14034432
23:29:19 15812 8192000000 10849717776 11277160448 1926118880 19.036 100 52 104 1 1950983024 10112528 14751616
23:29:42 18760 8192000000 10860386800 11283623936 1928931760 19.058 100 44 88 2 1951364224 9431792 13000672
23:30:22 31958 8192000000 10864760192 11292311552 1931843600 19.082 100 46 92 1 1955712000 11107776 12760624
23:31:12 14133 8192000000 10872225696 11302174720 1942283280 19.165 100 42 83 2 1965403312 9502608 13617424
23:31:38 85407 8192000000 10864968576 11307261952 1926926432 19.042 99 39 78 2 1950337152 11613248 11797472
23:33:10 22073 8192000000 10875515920 11314581504 1944671168 19.184 100 22 44 0 1966931360 14995504 7264688
23:33:55 23517 8192000000 10897685392 11325870080 1955103616 19.267 100 45 90 0 1984127616 15596464 13427536
23:34:27 4086 8192000000 10903840144 11331723264 1961764480 19.320 100 57 112 2 1995883712 17454704 16664528
23:34:43 13085 8192000000 10904437264 11330695168 1963563152 19.334 100 69 138 1 2000881104 16711520 20606432
23:35:04 6774 8192000000 10915225904 11338702848 1960212752 19.308 100 56 112 1 2000969296 24371728 16384816
23:35:19 7169 8192000000 10924012128 11341799424 1967386912 19.365 100 66 131 0 2008312352 22049568 18875872
23:35:34 22215 8192000000 10926156192 11353718784 1970769760 19.392 100 53 106 1 2009108896 22153440 16185696
23:36:08 8315 8192000000 10916148176 11350700032 1959225600 19.300 99 46 92 0 1993748256 20485152 14037504
23:36:24 16906 8192000000 10931787536 11354595328 1976669376 19.438 100 52 101 2 2013212816 21521968 15021472
23:36:54 8798 8192000000 10935225552 11362537472 1980382864 19.468 100 60 120 0 2025075888 26427248 18265776
23:37:11 2106 8192000000 10947018992 11367849984 1986841712 19.519 100 74 148 1 2035865168 26763984 22259472
23:37:20 8955 8192000000 10941984528 11371040768 1985151488 19.505 100 61 122 1 2031251472 27506928 18593056
23:37:36 9287 8192000000 10947502496 11375833088 1986461968 19.516 100 58 114 2 2032958944 29628832 16868144
23:37:52 11123 8192000000 10964221200 11384242176 1994137968 19.576 100 62 125 1 2045843728 33096816 18608944
23:38:10 5245 8192000000 10962830736 11380731904 1990896144 19.551 100 75 149 0 2047665024 34121328 22647552
23:38:25 2195 8192000000 10955832608 11378417664 1989066176 19.536 100 77 150 1 2044767568 32973408 22727984
23:38:34 4692 8192000000 10955932416 11377565696 1986476576 19.516 100 77 152 0 2044148464 34323840 23348048
23:38:47 2776 8192000000 10929290000 11349696512 1949376064 19.222 98 66 132 0 2003004064 32244416 21383584
23:38:58 3630 8192000000 10948338432 11367313408 1978853920 19.456 100 72 143 0 2032196288 32023776 21318592
23:39:08 9252 8192000000 10954160464 11382390784 1985719088 19.510 100 63 126 0 2042173904 37520720 18934096
23:39:26 2398 8192000000 10955001728 11381301248 1987820832 19.527 100 59 118 0 2038959328 33145072 17993424
23:39:39 1801 8192000000 10951491664 11374546944 1969458176 19.381 99 71 140 0 2028399712 37494592 21446944
23:39:47 2087 8192000000 10960659680 11377188864 1985880000 19.511 100 90 180 2 2048753968 34759312 28114656
23:40:02 3759 8192000000 10938526976 11357065216 1951171632 19.236 98 72 144 2 2007780240 34280592 22328016
23:40:13 2386 8192000000 10945902912 11355262976 1970288464 19.388 100 79 156 2 2026032208 33402528 22341216
23:40:22 2975 8192000000 10944303824 11358658560 1968432480 19.373 100 76 149 0 2026445904 35038096 22975328
23:40:33 2196 8192000000 10943481120 11364483072 1972709392 19.407 100 63 125 1 2027190928 35289888 19191648
23:40:46 2295 8192000000 10956902192 11376955392 1983643808 19.494 100 80 159 0 2044970864 36518992 24808064
23:40:56 8665 8192000000 10959000944 11384426496 1983665536 19.494 100 71 142 2 2045899984 39722080 22512368
23:41:12 7065 8192000000 10953860544 11379687424 1968130288 19.371 99 60 120 2 2023736752 37106896 18499568
23:41:26 6881 8192000000 10958269408 11383238656 1972515632 19.405 99 72 144 0 2029889744 35260928 22113184
23:41:41 4080 8192000000 10947255152 11369852928 1972065232 19.402 100 61 124 2 2026436768 35209312 19162224
23:41:55 4469 8192000000 10951074400 11373641728 1963617280 19.335 99 73 145 3 2022843216 37490864 21735072
23:42:08 4880 8192000000 10945694656 11364982784 1972900064 19.408 100 77 153 2 2031349984 34789104 23660816
23:42:19 6405 8192000000 10954870656 11375783936 1975858176 19.432 100 76 146 1 2035231360 37424576 21948608
23:42:34 2203 8192000000 10959070512 11373219840 1978478128 19.453 100 79 158 1 2038471568 36224784 23768656
23:42:43 3962 8192000000 10955655872 11368157184 1972383120 19.404 100 83 166 0 2036794128 39369232 25041776
23:42:53 2241 8192000000 10966605984 11379806208 1980077648 19.465 100 88 175 2 2046475488 40129632 26268208
23:43:03 3797 8192000000 10958624768 11368222720 1971124848 19.394 100 94 187 2 2039802512 40988032 27689632
23:43:14 2933 8192000000 10966693280 11378307072 1983100400 19.489 100 80 158 0 2048683280 40776720 24806160
23:43:28 3776 8192000000 10957004656 11379458048 1965256800 19.348 99 68 136 0 2029108304 42212432 21639072
23:43:39 2677 8192000000 10975217952 11388616704 1987142288 19.521 100 75 151 1 2054556320 43392576 24021456
23:43:50 2305 8192000000 10959177040 11377410048 1963710672 19.336 99 80 157 1 2030885408 42809472 24365264
23:44:00 3388 8192000000 10967686640 11393527808 1987354528 19.523 100 71 142 0 2054590400 44828320 22407552
23:44:11 2381 8192000000 10978170496 11394363392 1977573840 19.445 99 88 174 1 2049152464 43634304 27944320
23:44:21 3010 8192000000 10978550640 11396018176 1993763408 19.574 100 94 184 1 2065380800 42432672 29184720
23:44:34 4062 8192000000 10955317472 11368644608 1968695984 19.375 100 84 167 2 2038184480 43863856 25624640
23:44:46 4388 8192000000 10960888640 11373645824 1971675584 19.399 100 83 166 1 2043040112 45356480 26008048
23:45:05 2997 8192000000 10964002848 11380662272 1976078144 19.434 100 82 163 2 2048693376 46675376 25939856
23:45:16 3390 8192000000 10959647520 11375026176 1970174992 19.387 100 75 148 2 2040786592 47269952 23341648
23:45:28 4699 8192000000 10965761936 11384926208 1980258736 19.467 100 71 139 2 2048775600 46345312 22171552
23:45:39 6514 8192000000 10968594720 11389984768 1982519328 19.485 100 70 140 0 2053590592 48097632 22973632
23:45:55 2430 8192000000 10969149072 11387863040 1981771936 19.479 100 83 165 1 2055520992 47059136 26689920
23:46:07 1364 8192000000 10980027136 11395993600 1978901120 19.456 100 81 156 1 2056268544 51805568 25561856
23:46:17 6418 8192000000 10997643936 11415334912 1994325888 19.578 100 81 160 0 2075739408 55148304 26265216
23:46:31 2310 8192000000 11008369536 11422183424 2007696656 19.683 100 90 178 0 2089725216 53728288 28300272
23:46:41 702 8192000000 11013725264 11427438592 2010331088 19.704 100 90 180 1 2094160096 54720400 29108608
23:46:48 3189 8192000000 11005031632 11424768000 2005701632 19.668 100 79 158 0 2085122496 54607504 24813360
23:47:00 3070 8192000000 11012700288 11429351424 2010883408 19.708 100 89 178 4 2092161856 53374176 27904272
23:47:09 8023 8192000000 10995033536 11433226240 2010286224 19.704 100 62 123 0 2083381920 53189088 19906608
23:47:26 8356 8192000000 10986115424 11425112064 2003128768 19.647 100 53 106 0 2074512336 52973232 18410336
23:47:42 5663 8192000000 10978990304 11419049984 1997139888 19.600 100 49 98 1 2066667296 53318128 16209280
23:47:57 9362 8192000000 10958224320 11392487424 1955923856 19.274 98 38 76 1 2024405792 55251232 13230704
23:48:14 9042 8192000000 10961992864 11411636224 1989306368 19.538 100 47 94 0 2062118512 56504000 16308144
23:48:43 5133 8192000000 11001656336 11428450304 1991763392 19.558 99 71 141 3 2067434192 52423312 23247488
23:48:55 2129 8192000000 10996406960 11420192768 1999178160 19.616 100 79 157 4 2079466096 55932368 24355568
23:49:05 3100 8192000000 11002739056 11435769856 2004554208 19.659 100 71 140 0 2087671200 61422192 21694800
23:49:22 11269 8192000000 10975712944 11418406912 1975143952 19.426 99 37 74 0 2046727760 58346736 13237072
23:49:42 8993 8192000000 10986160928 11423899648 1985550464 19.509 100 39 78 0 2058568304 59864720 13153120
23:50:02 11104 8192000000 10966693680 11415072768 1974527056 19.421 100 41 83 0 2048367968 59603232 14237680
23:50:22 10420 8192000000 10959375680 11402141696 1965134336 19.347 99 42 84 0 2034109488 54826512 14148640
23:50:40 12540 8192000000 10950912576 11407826944 1977384448 19.444 100 36 71 1 2039619776 50254768 11980560
23:51:08 10773 8192000000 10955913072 11406987264 1985770816 19.510 100 38 76 0 2045489184 47282464 12435904
23:51:34 20657 8192000000 10958016576 11407351808 1980729824 19.470 100 25 50 1 2035978160 46761344 8486992
23:52:07 31377 8192000000 10932590512 11389222912 1944055264 19.179 98 25 50 1 1997994992 45932416 8007312
23:53:15 20501 8192000000 10928049552 11379253248 1936738736 19.121 99 28 56 0 2002491008 55294256 10458016
23:53:44 25841 8192000000 10928373632 11385671680 1939418160 19.142 100 22 44 1 2012643808 63880672 9344976
23:54:17 11553 8192000000 10945965120 11398643712 1948224464 19.212 100 32 64 2 2024345728 64398944 11722320
23:54:36 43539 8192000000 10903599760 11377270784 1894412592 18.781 97 25 50 0 1959798960 56108992 9277376
23:55:32 18055 8192000000 10884650352 11357138944 1938924464 19.138 100 13 26 1 1980163056 36893744 4344848
23:56:03 14775 8192000000 10856031792 11301105664 1888681504 18.735 97 26 53 1 1907222080 10781792 7758784
23:56:26 33111 8192000000 10881764576 11320365056 1905906608 18.874 98 41 84 1 1927296976 9222640 12167728
23:57:08 27818 8192000000 10863041728 11317276672 1927739616 19.049 99 43 85 1 1953526400 12779856 13006928
23:58:05 62607 8192000000 10875503984 11336650752 1930860448 19.074 99 12 24 0 1942917808 9437904 2619456
23:59:14 65699 8192000000 10872125584 11342688256 1937643248 19.128 99 8 16 0 1956894464 17153472 2097744
00:01:11 71115 8192000000 10878912208 11333029888 1910774608 18.913 98 21 42 2 1925100368 8646960 5678800
00:02:40 141873 8192000000 10907032336 11345264640 1952191808 19.244 99 39 79 2 1973523456 9565056 11766592
00:05:10 21148 8192000000 10908518000 11364270080 1978162080 19.450 100 44 86 2 2000313792 9900256 12251456
00:05:41 75890 8192000000 10923199168 11385466880 1987101568 19.521 100 22 43 0 2007579008 14426768 6050672
00:07:10 71099 8192000000 10919511504 11376386048 1930695408 19.072 97 28 56 0 1952926720 13926128 8305184
00:08:29 135049 8192000000 10905661456 11362488320 1915545712 18.951 96 32 65 2 1937235024 12707760 8981552
00:10:52 852 8192000000 10928325968 11372396544 1985355648 19.507 100 60 120 3 2015047200 13219536 16472016
00:11:00 6736 8192000000 10924471680 11374112768 1983487152 19.492 100 50 100 0 2017016336 19384592 14144592
00:11:17 25434 8192000000 10917262336 11375271936 1985220224 19.506 100 45 90 1 2014299264 16079680 12999360
00:11:58 60063 8192000000 10968158480 11402473472 1993643440 19.573 100 36 71 1 2019551888 15168176 10740272
00:13:10 54095 8192000000 10943956544 11418648576 2008285232 19.688 100 57 115 3 2047887024 22327952 17273840
00:14:22 35375 8192000000 10923326528 11417780224 2000766384 19.629 100 14 28 0 2024200960 19684960 3749616
00:15:04 23863 8192000000 10913851136 11393495040 1978152800 19.450 99 10 20 1 1996419824 15181472 3085552
00:15:42 76393 8192000000 10922595968 11406430208 1997698896 19.605 100 28 56 1 2018932848 13238112 7995840
00:17:22 53213 8192000000 10914411392 11406843904 1975580336 19.430 99 14 28 0 1999099728 19790448 3728944
00:18:23 55033 8192000000 10910863488 11401994240 1977618400 19.446 99 11 22 0 1996675904 15434944 3622560
00:19:31 76404 8192000000 10917053904 11416010752 1982872992 19.487 99 21 42 1 2006145632 16523232 6749408
00:20:59 93270 8192000000 10928463936 11409805312 1980444416 19.468 99 14 28 0 2002800368 18385424 3970528
00:23:24 57916 8192000000 10903180144 11374346240 1946845536 19.201 98 20 41 1 1962342304 9700944 5795824
00:24:32 56220 8192000000 10929284016 11398557696 1992419360 19.563 100 21 41 1 2008747024 10324512 6003152
00:25:40 41059 8192000000 10924236528 11387551744 1925353040 19.030 96 29 58 3 1950246976 16218752 8675184
00:26:27 54852 8192000000 10924230736 11390414848 1962707072 19.328 99 26 52 1 1986663568 17313120 6643376
00:27:34 76302 8192000000 10873362608 11341340672 1851407568 18.434 94 28 54 5 1870448304 11689120 7351616
00:28:57 97541 8192000000 10872603712 11333443584 1782009872 17.866 91 15 30 1 1797758720 12257344 3491504
00:30:45 116161 8192000000 10865822176 11333050368 1830259872 18.261 94 15 30 0 1850437616 15709728 4468016
00:32:47 101573 8192000000 10884053120 11334848512 1915016320 18.947 98 42 84 1 1934715472 8238816 11460336
00:34:58 74254 8192000000 10869106720 11322957824 1863576480 18.532 95 33 66 3 1881857840 9859408 8421952
00:36:19 22498 8192000000 10870606144 11332173824 1946299136 19.197 100 31 61 2 1964826688 9787200 8740352
00:36:56 5463 8192000000 10869728016 11325005824 1924584048 19.024 99 27 54 0 1942187920 9282336 8321536
00:37:09 17166 8192000000 10872160672 11325542400 1934154496 19.100 100 30 60 0 1951411248 8760592 8496160
00:37:33 24700 8192000000 10853726400 11320594432 1921541088 18.999 99 34 68 0 1941418224 10348352 9528784
00:38:10 68070 8192000000 10839166976 11308277760 1877520512 18.645 97 9 18 0 1888125616 8199200 2405904
00:39:24 39552 8192000000 10842770800 11315159040 1888168592 18.731 98 12 24 0 1899036720 7312288 3555840
00:40:22 42201 8192000000 10842190000 11308257280 1895017696 18.786 98 22 44 1 1911734432 10213776 6502960
00:41:13 79818 8192000000 10854042480 11324882944 1934447200 19.102 100 14 28 1 1948951776 10050304 4454272
00:42:39 85735 8192000000 10839339008 11310059520 1915015296 18.947 99 12 24 0 1928680512 10148816 3516400
00:44:11 72641 8192000000 10859739424 11333148672 1908248896 18.893 98 14 28 1 1923809024 11783696 3776432
00:45:48 45084 8192000000 10856103184 11310338048 1845647536 18.387 95 16 32 0 1857056144 7700592 3708016
00:46:42 65315 8192000000 10847625520 11319644160 1908661888 18.896 99 25 50 1 1926586032 10628864 7295280
00:48:13 38507 8192000000 10856980032 11314769920 1909054320 18.899 98 24 48 2 1925846912 9743536 7049056
00:49:01 39284 8192000000 10878567184 11338412032 1937160368 19.124 100 23 46 2 1954401216 10698832 6542016
00:49:55 58138 8192000000 10865110736 11334893568 1897082224 18.803 98 15 30 2 1916240416 14468688 4689504
00:50:59 76877 8192000000 10873455280 11344445440 1925388800 19.030 99 19 38 0 1945379424 14233680 5756944
00:52:24 53040 8192000000 10879474176 11342077952 1931601552 19.080 99 22 44 1 1952046736 13953520 6491664
00:53:28 64976 8192000000 10861217520 11346132992 1914141040 18.940 98 13 26 0 1933246176 15229360 3875776
00:54:39 54831 8192000000 10900477360 11353063424 1910262896 18.909 98 29 58 1 1928946752 10945584 7738272
00:55:47 67675 8192000000 10881654448 11355934720 1911904384 18.922 98 16 32 0 1932580880 16206400 4470096
00:57:03 130098 8192000000 10899850352 11357655040 1920465824 18.991 98 12 24 1 1944779536 21428208 2885504
00:59:19 85451 8192000000 10889912048 11358257152 1932703136 19.088 98 26 52 1 1949876080 9661728 7511216
01:00:51 58347 8192000000 10896529072 11368087552 1971373040 19.396 100 23 46 1 1989098944 11095424 6630480
01:01:57 102153 8192000000 10906561568 11372769280 1976645616 19.438 100 14 28 1 1991768992 11067296 4056080
01:03:52 50646 8192000000 10895806640 11379007488 1941799088 19.161 98 9 18 0 1957732272 13727168 2206016
01:04:57 35500 8192000000 10911691312 11371831296 1956649536 19.279 99 26 52 3 1970391552 6401504 7340512
01:05:42 37769 8192000000 10878151856 11358158848 1934909344 19.106 98 20 40 1 1950098064 9798768 5389952
01:06:27 62447 8192000000 10918674992 11373510656 1956218304 19.276 99 25 51 1 1973743376 10129696 7395376
01:07:39 61629 8192000000 10898164528 11370373120 1939295488 19.141 98 11 21 1 1950118848 7510992 3312368
01:09:00 39318 8192000000 10895272080 11365023744 1936893536 19.122 98 22 44 2 1951399552 8312880 6193136
01:09:52 67654 8192000000 10903810432 11379572736 1959647568 19.303 99 28 56 0 1976844032 9342128 7854336
01:11:06 64358 8192000000 10869128256 11351687168 1897067776 18.803 96 11 22 0 1912014352 11603664 3342912
01:12:24 20758 8192000000 10906919744 11357458432 1949541936 19.223 99 47 96 0 1972432384 9542736 13347712
01:12:54 58027 8192000000 10904398304 11364728832 1952782512 19.249 99 29 58 1 1978021120 17030016 8208592
01:14:02 91471 8192000000 10879398976 11343118336 1849447968 18.418 94 16 32 3 1879638064 25271440 4918656
01:15:40 36491 8192000000 10892122608 11348217856 1898844448 18.817 97 43 86 0 1925344176 14808448 11691280
01:16:23 73608 8192000000 10888136768 11338899456 1878678656 18.654 96 27 54 2 1897272576 11638272 6955648
01:17:42 29761 8192000000 10904596656 11359838208 1941341952 19.157 99 35 70 1 1963329296 11879808 10107536
01:18:22 94543 8192000000 10888369520 11357421568 1928373952 19.054 98 43 86 1 1952258640 11386912 12497776
01:20:41 53833 8192000000 10875665872 11359490048 1953757616 19.256 100 12 24 0 1973213792 16193184 3262992
01:21:51 8366 8192000000 10882443744 11339390976 1940117264 19.148 99 32 62 2 1963784176 12718032 10948880
01:22:16 37192 8192000000 10863289376 11333369856 1929569488 19.063 99 14 27 2 1939300880 6499152 3232240
01:23:03 59844 8192000000 10856422752 11329646592 1887450048 18.725 97 9 18 0 1896730512 6593312 2687152
01:24:09 42007 8192000000 10863456096 11338502144 1922921296 19.010 99 9 18 0 1935985568 10134448 2929824
01:25:02 50149 8192000000 10857509792 11330187264 1910146736 18.908 98 13 26 0 1927545408 13662368 3736304
01:26:10 65707 8192000000 9580480032 9906630656 732592480 8.208 38 5 8 1 740778480 6689360 1496640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-11-2020 01:29:34 to 22-11-2020 01:30:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-11-2020 01:30:06 to 22-11-2020 01:30:08.

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          239539
MON$OLDEST_ACTIVE               239540
MON$OLDEST_SNAPSHOT             239540
MON$NEXT_TRANSACTION            239540
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                       2025120
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Nov 22 01:27:25 2020
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Nov 22 01:27:31 2020
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sun Nov 22 01:27:39 2020
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
--- end of diff output ---

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

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